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 $19,100 from the planned level of $1,025,100. The following information is available from the accounting records for the year ended December 31.
| Actual | Planned | Increase or (Decrease) | ||||
| Sales | $1,044,200 | $1,025,100 | $19,100 | |||
| Number of units sold | 22,700 | 20,100 | 2,600 | |||
| Sales price | $46 | $51 | $(5) | |||
| Variable cost per unit | $8 | $8 | $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 $8, as planned?
Sale Quantity Factor =(Actual Units -
Planned units) x Planned sales price
= (22,700 – 20,100) x $51
= $ 132,600
Unit Price Factor = ( Actual Sales
price – Planned Sales Price) x Actual units sold
= ($ 46 – $ 51) x 22,700
= $ (113,500)
|
Select Audio Inc. |
||
|
Contribution Margin Analysis—Sales |
||
|
For the Year Ended December 31 |
||
|
Effect of changes in sales: |
||
|
Sales quantity factor |
$ 132,600.00 |
|
|
Unit price factor |
$ (113,500.00) |
|
|
Total effect of changes in sales |
$ 19,100.00 |
|
----Working----
|
Working |
Actual |
Planned |
|
|
A |
Sales |
$ 1,044,200.00 |
$ 1,025,100.00 |
|
B |
Variable cost |
$ 181,600.00 |
$ 160,800.00 |
|
C=A-B |
Contribution margin |
$ 862,600.00 |
$ 864,300.00 |
Answer: Actual Contribution margin ($862,600) is LOWER than Planned Contribution margin ($864,300), hence, Price decrease has not resulted in a net increase in Contribution margin.