In: Accounting
Dunphy Inc. produces three models of a certain product: Standard, Deluxe, and Super. Relevant data: | |||||||||||||
Standard | Deluxe | Super | |||||||||||
Sales in units | 12,000 | 5,000 | 3,000 | ||||||||||
Price per unit | 85 | 120 | 166 | ||||||||||
Variable cost per unit | 34 | 45 | 84 | ||||||||||
Fixed costs are $1,000,000. | |||||||||||||
a) | Compute Dunphy's breakeven point in sales dollars with the current sales mix. | ||||||||||||
b) | Compute Dunphy's current margin of safety. | ||||||||||||
c) | What is forecast net income at sales of $2,400,000 given the current sales mix? | ||||||||||||
d) | Marketing Department has proposed a sales promotion costing $40,000 with a focus on one model only. | ||||||||||||
Depending on which model is chosen, the promotion is expected to increase sales of Standard by 11%, Deluxe by 15%, or Super by 20%. | |||||||||||||
Should the campaign be approved, and if so, which model should it promote? Explain, with relevant calculations. |
a) | ||||
Standard | Deluxe | Super | Total | |
Sales in units | 12000 | 5000 | 3000 | 20000 |
Price per unit (a) | $85.00 | $120.00 | $166.00 | |
Variable cost per unit (b) | $34.00 | $45.00 | $84.00 | |
Contribution Margin per unit = a - b | $51.00 | $75.00 | $82.00 | |
Product | Unit selling price (a) | Sales Mix | Weights (b) | Weighted Selling Price a x b |
Standard | $85.00 | 12000 | 60.00% | $51.00 |
Deluxe | $120.00 | 5000 | 25.00% | $30.00 |
Super | $166.00 | 3000 | 15.00% | $24.90 |
Total | 20000 | 100.00% | $105.90 | |
Product | Unit Contribution Margin (a) | Sales Mix | Weights (b) | Weighted CM (a x b) |
Standard | $51.00 | 12000 | 60.00% | $30.60 |
Deluxe | $75.00 | 5000 | 25.00% | $18.75 |
Super | $82.00 | 3000 | 15.00% | $12.30 |
Total | 20000 | 100.00% | $61.65 | |
Product | Weighted Selling Price | Weighted Contribution Margin | ||
Standard | $51.00 | $30.60 | ||
Deluxe | $30.00 | $18.75 | ||
Super | $24.90 | $12.30 | ||
Total | $105.90 | $61.65 | ||
Contribution Margin Ratio = CM/SP = $61.65/$105.90 | 58.22% | |||
Dunphy's breakeven point in sales dollars = Fixed Cost/Contribution margin ratio = $1,000,000/58.22% | $1,717,761.56 | |||
b) | ||||
Actual sales volume = 20,000 x $105.90 | $2,118,000.00 | |||
BEP sales Dollar | -$1,717,761.56 | |||
Margin of safety (Actual sales - BEP) | $400,238.44 | |||
c) | ||||
BEP Dollars = FC + Desired Profit / CM Ratio | ||||
BEP Dollars = $1,000,000 + $2,400,000 / 58.22% | $5,840,389.29 |