Results 1 to 1 of 1

Thread: Calculating Weighted Contributions

  1. #1
    Sep 2008

    Calculating Weighted Contributions

    I have three products that sum to a total (for this example types of milk and total milk). I am looking at units, dollars and price over two fixed time periods. I am trying to develop formulas that will determine the contibution of each item to the the total change in price. If the price for the total increased 10%, and each of the three items prices grew 5%, 15% and 20% relatively, what contribution did each make to the 10% total. Each one contributes a point change that sums to 10%, separate from their own % increases. The contribution figure I am looking for depends up the % chg for each item as well as the absolute dollar and unit sales for each item.

    If anyone can create formulas for me that allow for this calculation, I will be unbelieavably grateful. And impressed.

    see attached.
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Calculating 2 weighted averages in one equation
    Posted in the Statistics Forum
    Replies: 0
    Last Post: Jul 21st 2010, 11:46 AM
  2. Weighted means
    Posted in the Math Topics Forum
    Replies: 2
    Last Post: Feb 16th 2009, 04:22 PM
  3. Weighted Averages
    Posted in the Calculus Forum
    Replies: 2
    Last Post: Jan 15th 2009, 12:58 PM
  4. Weighted Averages
    Posted in the Algebra Forum
    Replies: 1
    Last Post: Mar 8th 2008, 09:32 AM
  5. Calculating a Weighted Average and its Variance
    Posted in the Advanced Statistics Forum
    Replies: 7
    Last Post: Aug 29th 2007, 02:27 AM

Search Tags

/mathhelpforum @mathhelpforum