In: Accounting
Contribution Margin Analysis—Sales
Select Audio Inc. sells electronic equipment. Management decided early in the year to reduce the price of the speakers in order to increase sales volume. As a result, for the year ended December 31, the sales increased by $23,500 from the planned level of $1,228,500. The following information is available from the accounting records for the year ended December 31.
Actual | Planned | Increase or (Decrease) | ||||
Sales | $1,252,000 | $1,228,500 | $23,500 | |||
Number of units sold | 31,300 | 27,300 | 4,000 | |||
Sales price | $40 | $45 | $(5) | |||
Variable cost per unit | $7 | $7 | $0 |
a. Prepare an analysis of the sales quantity and unit price factors. Use a minus sign for any negative amounts.
Select Audio Inc. | ||
Contribution Margin Analysis—Sales | ||
For the Year Ended December 31 | ||
Effect of changes in sales: | ||
Sales quantity factor | $ | |
Unit price factor | ||
Total effect of changes in sales | $ |
b. Did the price decrease generate sufficient
volume to result in a net increase in contribution margin if the
actual variable cost per unit was $7, as planned?
Solution :-
a. Prepare an analysis of the sales quantity and unit price factors. Use a minus sign for any negative amounts :-
Select Audio Inc. | ||
Contribution Margin Analysis—Sales | ||
For the Year Ended December 31 | ||
Effect of changes in sales: | ||
Sales quantity factor |
= [ 31,300 - 27,300 ] * $45 = $180,000 |
|
Unit price factor |
= [ $45 - $40 ] * 31,300 = $156,500 |
|
Total effect of changes in sales |
= $180,000 - $156,500 = $23,500 |
b. Did the price decrease generate sufficient volume to result in a net increase in contribution margin if the actual variable cost per unit was $7, as planned?
Actual | Planned | Change | |
Sales | $1,252,000 | $1,228,500 | $23,500 |
Variable cost |
= 31,300 * $7 = $219,100 |
= 27,300 * $7 = $191,100 |
= $219,100 - $191,100 = $28,000 |
Contribution margin |
= $1,252,000 - $219,100 = $1,032,900 |
= $1,228,500 - $191,100 = $1,037,400 |
= $23,500 - $28,000 = - $4,500 |