Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
a.
Effect of changes in variable costs of goods sold:
Variable cost quantity factor*
Unit cost factor**
Total effect of change in variable cost of goods sold
Effect of changes in variable and administrative expenses:
Variable cost quantity factor***
Unit cost factor****
Total effect of changes in selling and admin. expenses
Decrease in contribution margin from change in variable costs
**Difference in sales quantity
Planned unit variable cost of goods sold
Variable cost quantity factor
** Difference in unit variable cost of goods sold
Sales quantity factor
*** Difference in sales quantity
Planned unit variable selling & admin.
Sales quantity factor
**** Difference in unit variable selling & admin.
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Contribution Margin Analysis⎯Variable Costs
For the Year Ended December 31, 2014
An asterisk (*) will appear to the right of an incorrect entry.
a.
Effect of changes in variable costs of goods sold:
Variable cost quantity factor*
240,000$
Unit cost factor** (456,000)
Contribution Margin Analysis⎯Variable Costs
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.