An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
Planned contribution margin
Effect of change in sales:
Total effect of change in sales
Effect of changes in variable cost of goods sold:
Variable cost quantity factor3
Total effect of changes in variable cost of goods sold
Effect of changes in variable selling and administrative expenses:
Variable cost quantity factor5
Total effect of changes in variable selling and admin. exp.
Actual contribution margin
1Difference in units sold
Planned unit sales price
Sales quantity factor
2Difference in sales price
Unit price factor
3Difference in units sold
Planned variable cost of goods sold
Variable cost quantity factor
4Difference in unit variable cost of goods sold
5Difference in units sold
Planned unit variable selling and admin. exp.
Variable cost quantity factor
6Difference in unit variable selling and admin. exp.
Contribution Margin Analysis
For the Year Ended December 31, 2014
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.