In: Accounting
Break-Even Sales and Cost-Volume-Profit Chart
For the coming year, Cleves Company anticipates a unit selling price of $84, a unit variable cost of $42, and fixed costs of $399,000.
Required:
1. Compute the anticipated break-even sales
(units).
units
2. Compute the sales (units) required to
realize a target profit of $159,600.
units
3. Construct a cost-volume-profit chart, assuming maximum sales of 19,000 units within the relevant range. From your chart, indicate whether each of the following sales levels would produce a profit, a loss, or break-even.
$1,117,200 | |
$999,600 | |
$798,000 | |
$596,400 | |
$478,800 |
4. Determine the probable income (loss) from
operations if sales total 15,200 units. If required, use the minus
sign to indicate a loss.
Selling Price | 84.00 | |||||
Less: Variable Cost | 42.00 | |||||
Contribution Margin | 42.00 | |||||
Fixed Costs | 399000 | |||||
A | BEP in Units: | |||||
Fixed Costs | 399000 | A | ||||
Contribution Margin PU | 42.00 | B | ||||
BEP in Units | 9500 | A/B | ||||
B | Target Profit | 159600 | ||||
Add :Fixed Costs | 399000 | |||||
Total Required Contribution | 558600 | A | ||||
Contribution Margin PU | 42.00 | B | ||||
Units | 13300 | A/B | ||||
C | PU | Total | ||||
Selling Price | 84.00 | 1596000 | (X19000) | |||
Less: Variable Cost | 42.00 | 798000 | ||||
Contribution Margin | 42.00 | 798000 | ||||
Fixed Costs | 399000 | |||||
NOI | 399000 | |||||
D | PU | Total | ||||
Selling Price | 84.00 | 1276800 | (X15200) | |||
Less: Variable Cost | 42.00 | 638400 | ||||
Contribution Margin | 42.00 | 638400 | ||||
Fixed Costs | 399000 | |||||
NOI | 239400 | |||||