Share
Explore BrainMass

Breakeven Analysis and Planning Future Sales

Breakeven Analysis

Prepare a breakeven analysis and a C-V-P analysis planning future sales using the information below. Be sure to show your work in (Word or Excel document).

Breakeven Analysis and Planning Future Sales

Write Company has a maximum capacity of 200,000 units per year. Variable manufacturing costs are $12 per unit. Fixed overhead is $600,000 per year. Variable selling and administrative costs are $5 per unit, and fixed selling and administrative costs are $300,000 per year. The current sales price is $23 per unit.

Required

1. What is the breakeven point in (a) sales units and (b) sales dollars?
2. How many units must Write Company sell to earn a profit of $240,000 per year?
3. A strike at one of the company's major suppliers has caused a shortage of materials, so the current year's production and sales are limited to 160,000 units. To partially offset the effect of the reduced sales on profit, management is planning to reduce fixed costs to $841,000. Variable cost per unit is the same as last year. The company has already sold 30,000 units at the regular selling price of $23 per unit.
◦a. What amount of fixed costs was covered by the total contribution margin of the first 30,000 units sold?
◦b. What contribution margin per unit will be needed on the remaining 130,000 units to cover the remaining fixed costs and to earn a profit of $210,000 this year?

Do not forget to show your work in (Word or Excel document).

Solution Preview

See the attached file. Thanks

Prepare breakeven analysis and a C-V-P analysis planning future sales using the information below, and be sure to show your work in (Word or Excel document).
Breakeven Analysis and Planning Future Sales
Write Company has a maximum capacity of 200,000 units per year. Variable manufacturing costs are $12 per unit. Fixed overhead is $600,000 per year. Variable selling and administrative costs are $5 per unit, and fixed selling and administrative costs are $300,000 per year. The current sales price is $23 per unit.

Required
1. What is the breakeven point in (a) sales units and (b) sales ...

Solution Summary

This solution shows how to calculate the BEP in units and dollar sales. It also shows the required number of units for desired profit levels.

$2.19