Weighted Avg(?) Margin/Contribution Margin %
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...(Headbang)
Any help or suggestions would be appreciated.