Results 1 to 1 of 1

Math Help - Calculating Weighted Contributions

  1. #1
    Newbie
    Joined
    Sep 2008
    Posts
    1

    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: July 21st 2010, 12:46 PM
  2. Weighted means
    Posted in the Math Topics Forum
    Replies: 2
    Last Post: February 16th 2009, 05:22 PM
  3. Weighted Averages
    Posted in the Calculus Forum
    Replies: 2
    Last Post: January 15th 2009, 01:58 PM
  4. Weighted Averages
    Posted in the Algebra Forum
    Replies: 1
    Last Post: March 8th 2008, 10:32 AM
  5. Calculating a Weighted Average and its Variance
    Posted in the Advanced Statistics Forum
    Replies: 7
    Last Post: August 29th 2007, 03:27 AM

Search Tags


/mathhelpforum @mathhelpforum