In: Accounting
Tracey Incorporated has been experiencing difficulty for some time due to erratic sales of its only product. The company’s contribution format income statement for the most recent month is given below:
Total |
Per Unit |
Percent of Sales |
|
Sales (19,500 units) |
$585,000 |
||
Variable expenses |
409,500 |
||
Contribution margin |
175,500 |
||
Fixed expenses |
180,000 |
||
Net operating loss |
($4,500) |
Total |
Per Unit |
Percent of Sales |
|
Sales |
|||
Variable expenses |
|||
Contribution margin |
|||
Fixed expenses |
|||
Net operating income |
NOT AUTOMATED
Total |
Per Unit |
Percent of Sales |
|
Sales (26,000 units) |
|||
Variable expenses |
|||
Contribution margin |
|||
Fixed expenses |
|||
Net operating income |
AUTOMATED
Total |
Per Unit |
Percent of Sales |
|
Sales (26,000 units) |
|||
Variable expenses |
|||
Contribution margin |
|||
Fixed expenses |
|||
Net operating income |
Particulars | Total | per unit | Percentage of Sales | |||
Sales(19500 units) | 585000 | 30 | 100% | |||
Variable Expenses | 409500 | 21 | 70% | (409000/585000) | ||
Contribution Margin | 175500 | 9 | 30% | (175500/585000) | ||
Fixed Expenses | 180000 | |||||
Net Operating Loss | -4500 | |||||
Increase in advertising cost by $ 16000 | ||||||
Increase in Sales | $80,000 | |||||
Increase in units | $2,667 | Sales/per unit cost | (80000/30) | |||
Total Units | $22,167 | $465,500 | ||||
Variable Cost | 22167*21 | $465,500 | $2,667 | |||
Particulars | Total | per unit | Percentage of Sales | |||
Sales(22267 units) | 665000 | $30.00 | 100% | |||
Variable Expenses | 465500 | 21.00 | 70% | (465500/665000) | ||
Contribution Margin | 199500 | $9.00 | 30% | (199500/665000) | ||
Fixed Expenses | 196000 | |||||
Net Operating Profit | 3500 | |||||
Reduction in Selling price by 10% | ||||||
New Selling Price | 30*90%=$27 per unit | |||||
Units | 19500*2 | 39000 | ||||
Particulars | Total | per unit | Percentage of Sales | |||
Sales(39000 units) | 1053000 | (39000*27) | $27.00 | 100% | ||
Variable Expenses | 819000 | (39000*21) | 21.00 | 78% | (819000/1053000) | |
Contribution Margin | 234000 | $6.00 | 22% | (234000/1053000) | ||
Fixed Expenses | 240000 | |||||
Net Operating Profit | -6000 | |||||
Increase in packaing cost by 75cent per unit | ||||||
Let the units to be sold to earn the profit of $ 9750 be X | ||||||
Profit to be earned = | Fixed Cost+.75* x+Profit/ Contribution margin | |||||
X= | (180000+.75x+9750)/30-21 | |||||
9X= | 180000+.75x+9750 | |||||
9X= | 189750+.75x | |||||
9X-.75x= | 189750 | |||||
8.25X= | 189750 | |||||
X= | 189750/8.25 | |||||
23000 | ||||||
23000 units must be sold to earn the profit of $ 9750 |