In: Accounting
Problem 5-3 Determine break-even point under varying assumptions (L.O. 3, 4)
The management of Bootleg Company wants to know the break-even point for its new line of hiking boots under each of the following independent assumptions. The selling price is $50 per paid of boots unless otherwise stated. (Each pair of boots in one unit.)
Fixed costs are $300,000; variable cost is $30 per unit
Fixed costs are $300,000; variable cost is $20 per unit
Fixed costs are $250,000; variable cost is $20 per unit
Fixed costs are $250,000; selling price is $40; and variable cost
is $30 per unit
Compute the break-even point in units and sales dollars for each of the four independent cases.
Problem 5-4 Determine the margin of safety (L.O. 5)
Refer to Problem 5-3. Bootleg Company’s sales are $1,100,000. Determine the margin of safety in dollars for cases (a) through (d).
Problem 5-5 Compute the level of sales dollars needed to achieve a specified level of income (L.O. 6)
Using the data in Problem 5-3 (a through d), determine the level of sales dollars required to achieve a net income of $125,000.
SITUATION 1 |
SITUATION 2 |
SITUATION 3 |
SITUATION 4 |
||
a |
SELLING PRICE PER UNIT |
50 |
50 |
50 |
40 |
b |
VARIABLE COST PER UNIT |
(30) |
(20) |
(20) |
(30) |
c = a-b |
CONTRIBUTION PER UNIT |
20 |
30 |
30 |
10 |
d = (c/a)*100 |
PROFIT VOLUME RATIO |
40% |
60% |
60% |
25% |
e |
FIXED COST |
300000 |
300000 |
250000 |
250000 |
f = (e/c) |
BREAK EVEN POINT (UNITS) |
15000 |
10000 |
8333 |
25000 |
g = (e/d) |
BREAK EVEN POINT (SALES) |
750000 |
500000 |
416667 |
1000000 |
Break even point (units) = Fixed Cost / Contribution per unit
Break even point (sales) = Fixed Cost / Profit Volme Ratio
SITUATION 1 |
SITUATION 2 |
SITUATION 3 |
SITUATION 4 |
||
a |
SALES |
1100000 |
1100000 |
1100000 |
1100000 |
b |
BREAK EVEN POINT (SALES) |
750000 |
500000 |
416667 |
1000000 |
c = a-b |
MARGIN OF SAFETY |
350000 |
600000 |
683333 |
100000 |
Margin of Safety = Sales - Break Even Sales
(Note: Break Even sales calculated in Table 1 above )
SITUATION 1 |
SITUATION 2 |
SITUATION 3 |
SITUATION 4 |
||
a |
FIXED COST |
300000 |
300000 |
250000 |
250000 |
b |
EXPECTED PROFIT |
125000 |
125000 |
125000 |
125000 |
c |
PROFIT VOLUME RATIO |
40% |
60% |
60% |
25% |
d = (a+b)/c |
LEVEL OF SALES REQUIRED |
1062500 |
708333 |
625000 |
1500000 |
Level of Sales required = (Fixed Cost + Expected Profit) / Profit Volme Ratio