In: Accounting
Mathews Company manufactures only one product. For the year ended December 31, the contribution margin increased by $16,224 from the planned level of $545,376. 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 | $1,071,200 | $1,055,184 | $16,016 | |||
Variable costs: | ||||||
Variable cost of goods sold | $405,600 | $426,816 | $(21,216) | |||
Variable selling and administrative expenses | 104,000 | 82,992 | 21,008 | |||
Total variable costs | $509,600 | $509,808 | $(208) | |||
Contribution margin | $561,600 | $545,376 | $16,224 | |||
Number of units sold | 10,400 | 11,856 | ||||
Per unit: | ||||||
Sales price | $103 | $89 | ||||
Variable cost of goods sold | 39 | 36 | ||||
Variable selling and administrative expenses | 10 | 7 |
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 | $ |
2. At a meeting of the board of directors on January 30, the president, after reviewing the contribution margin analysis report, made the following comment:
It looks as if the price increase of $14 was a favorable tradeoff for decreased sales volume, yet variable cost of goods sold was less than planned and variable selling and administrative expenses were out of control and needed to be investigated. He went on to say that since the favorable tradeoff between higher price and lower sales volume was so successful, the company should consider increasing the sales price to $130.
Do you agree or disagree with the president's proposal and which reason would best explain your decision about the data?
Disagree with the president because the majority of the decrease in the variable cost of goods sold was due to the variable cost quantity factor and the increased variable selling and administrative expenses are probably a result of additional selling efforts needed to be competitive at higher prices.
Agree with the president because the unit cost factor for the variable selling and administrative cost is greater than the unit cost factor for the variable cost of goods sold, making an investigation necessary.
Agree with the president because the total effect of change in sales is greater than the total effect of changes in variable cost of goods sold, making an additional price raise attractive for more profits.
Disagree with the president because the contribution margin as a percentage of sales is greater for the planned sales level than the actual sales level, making his concern about variable selling and administrative expenses unwarranted.
Agree with the president because the majority of the decrease in the variable cost of goods sold was due to the sales price factor, as well as an increase in the variable selling and administrative expenses as a percentage of sales, making an additional price raise attractive for more profits.
The correct answer is:
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Planned Contribution Margin | 545376 | |
Effect of change in sale: | ||
Sales Quantity Factor | (10400-11856)*89 | -129584 |
Unit Price Factor | (103-89)*10400 | 145600 |
Effect of change in Variable COGS: | ||
Variable cost Quantity Factor | (10400-11856)*36 | 52416 |
Unit Price Factor | (36-39)*10400 | -31200 |
Effect of change in Variable SA: | ||
Variable cost Quantity Factor | (10400-11856)*7 | 10192 |
Unit Price Factor | (7-10)*10400 | -31200 |
Actual Contribution Margin | 561600 |
Part-2
Disagree with the president because the majority of the decrease in the variable cost of goods sold was due to the variable cost quantity factor and the increased variable selling and administrative expenses are probably a result of additional selling efforts needed to be competitive at higher prices.