Product Profitability Analysis
PowerTrain Sports Inc. manufactures and sells two styles of All Terrain Vehicles (ATVs), the Mountain Monster and Desert Dragon, from a single manufacturing facility. The manufacturing facility operates at 100% of capacity. The following per-unit information is available for the two products:
| Mountain Monster | Desert Dragon | |||
| Sales price | $4,800 | $2,800 | ||
| Variable cost of goods sold | 3,020 | 1,880 | ||
| Manufacturing margin | $1,780 | $920 | ||
| Variable selling expenses | 964 | 304 | ||
| Contribution margin | $816 | $616 | ||
| Fixed expenses | 380 | 250 | ||
| Income from operations | $436 | $366 | ||
In addition, the following sales unit volume information for the period is as follows:
| Mountain Monster | Desert Dragon | |||
| Sales unit volume | 2,900 | 2,100 | ||
a. Prepare a contribution margin by product report. Calculate the contribution margin ratio for each product as a whole percent.
| PowerTrain Sports Inc. | ||
| Contribution Margin by Product | ||
| Mountain Monster | Desert Dragon | |
| Contribution margin | $ | $ |
| Sales | ||
| Manufacturing margin | $ | $ |
| Variable selling expenses | ||
| Contribution margin | $ | $ |
| Contribution margin ratio | % | % |
Feedback
b. What advice would you give to the management of PowerTrain Sports Inc. regarding the relative profitability of the two products?
The Desert Dragon line provides the largest total contribution margin and the largest contribution margin ratio. If the sales mix were shifted more toward the Desert Dragon line, the overall profitability of the company would increase.
Income Statement :-
| ........ | Mountain Monster | Desert Dragon |
| Particulars | Per unit data($) | Unit sold | Total($) | Per unit data($) | Unit sold | Total($) |
| Sale Price | 4800 | 2900 | 13920000 | 2800 | 2100 | 5880000 |
| Variable Cost of Goods Sold | 3020 | (8758000) | 1880 | (3948000) | ||
| Manufacturing Margin | 1780 | 5162000 | 920 | 1932000 | ||
| Variable Selling Exp. | 964 | (2795600) | 304 | (638400) | ||
| Contribution Margin | 816 | 2366400 | 616 | 1293600 | ||
| Fixed Expenses | 380 | 1102000 | 250 | 525000 | ||
| Income from operations | 436 | 1264400 | 366 | 768600 | ||
| Contribution Margin Ratio | Contribution margin / Sale | 0.17 or 17% | 0.22 or 22% |
Get Answers For Free
Most questions answered within 1 hours.