In: Accounting
Contribution Margin Analysis
Mathews Company manufactures only one product. For the year ended December 31, the contribution margin increased by $10,864 from the planned level of $464,436. The president of Mathews Company has expressed some concern about this increase and has requested a follow-up report.
The following data have been gathered from the accounting records for the year ended December 31:
Actual |
Planned |
Difference—Increase (Decrease) | ||||
Sales | $911,800 | $895,698 | $16,102 | |||
Variable costs: | ||||||
Variable cost of goods sold | $349,200 | $364,914 | $(15,714) | |||
Variable selling and administrative expenses | 87,300 | 66,348 | 20,952 | |||
Total variable costs | $436,500 | $431,262 | $(5,238) | |||
Contribution margin | $475,300 | $464,436 | $10,864 | |||
Number of units sold | 9,700 | 11,058 | ||||
Per unit: | ||||||
Sales price | $94 | $81 | ||||
Variable cost of goods sold | 36 | 33 | ||||
Variable selling and administrative expenses | 9 | 6 |
Required:
1. Prepare a contribution margin analysis report for the year ended December 31.
Mathews Company | ||
Contribution Margin Analysis | ||
For the Year Ended December 31 | ||
Planned contribution margin | $ | |
Effect of changes in sales: | ||
Sales quantity factor | $ | |
Unit price factor | ||
Total effect of changes in sales | ||
Effect of changes in variable cost of goods sold: | ||
Variable cost quantity factor | $ | |
Unit cost factor | ||
Total effect of changes in variable cost of goods sold | ||
Effect of changes in selling and administrative expenses: | ||
Variable cost quantity factor | $ | |
Unit cost factor | ||
Total effect of changes in selling and administrative expenses | ||
Actual contribution margin |
Solution:
Mathews Company | ||
Contribution margin analysis | ||
Particulars | Details | Amount |
Planned contribution Margin | $464,436.00 | |
Effect of changes in Sales: | ||
Unit Price factor | $126,100.00 | |
Sales Quantity Factor | -$109,998.00 | |
Total effect of changes in sales | $16,102.00 | |
Effect of changes in variable cost of goods sold: | ||
Unit cost factor | -$29,100.00 | |
Variable cost quantity factor | $44,814.00 | |
Total Effect of changes in variable cost of goods sold | $15,714.00 | |
Effect of changes in variable selling and adminstrative expenses: | ||
Unit cost factor | -$29,100.00 | |
Variable cost quantity factor | $8,148.00 | |
Total Effect of changes in variable selling and administrative expenses | -$20,952.00 | |
Increase in contribution margin from change in variable cost | -$5,238.00 | |
Total increase in contribution margin | $10,864.00 | |
Actual contribution margin | $475,300.00 |