Results 1 to 2 of 2

Thread: Weighted Avg(?) Margin/Contribution Margin %

  1. #1
    Jan 2011

    Question Weighted Avg(?) Margin/Contribution Margin %

    Operating Plan.xls

    So i've attached a business problem I've been trying to work through.

    It seems to work fine when both Margin and Margin % are going in the same direction (They at least make sense), however in the attached example, when Margin goes up and Margin % goes down, the relationship doesn't seem to make sense.

    For example, Widget G is more favorable than the operating plan, but the margin % is showing negative, where as it would seem that the margin % should be favorable...

    Any help or suggestions would be appreciated.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Senior Member
    Nov 2010
    Hong Kong
    Are you trying to do variance analysis? What variance exactly do you need to analyse?

    If looking at act vs planned margin, there are two components here: volume variance (eg you sold less of higher margin products than planned, and more of lower margin product) and margin variance (products did not deliver on their margins). You will need to do these separately, not in one calculation.

    Ie first, analyse volume var * margin var = total sales var (see contribution of each product)

    then you can analyse margin var in % into volume and margin (here I'd rather call it price) and do it on a product level.
    Last edited by Volga; Jan 26th 2011 at 03:23 AM.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Margin of Error
    Posted in the Statistics Forum
    Replies: 0
    Last Post: Jan 21st 2010, 03:06 PM
  2. margin of error
    Posted in the Advanced Statistics Forum
    Replies: 1
    Last Post: Dec 11th 2009, 03:18 PM
  3. Margin of error
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: Jun 1st 2009, 06:06 PM
  4. how to set the left margin ?
    Posted in the LaTeX Help Forum
    Replies: 1
    Last Post: Oct 10th 2008, 10:11 AM
  5. margin economics
    Posted in the Math Topics Forum
    Replies: 2
    Last Post: Sep 3rd 2008, 12:15 PM

Search Tags

/mathhelpforum @mathhelpforum