Claflin University Break Even Analysis
|
Break-Even Analysis |
||||||||||||||||||||||||
|
Break-even analysis attempts to determine the volume of sales necessary for a manufacturer to cover costs or to make revenue equal costs. It is helpful in setting prices, estimating profit or loss potentials, and determining the discretionary costs that should be incurred. The general way to calculate break-even units is to take the ratio of total fixed costs to the difference between unit selling price and unit variable cost, or, as a formula, Break-Even Units = Total Fixed Costs / ( Unit Selling Price − Unit Variable Cost ) In PharmaSim, total fixed costs can be broken into discretionary marketing expenditures (such as sales force and advertising budget) and fixed costs for plant and overhead. The selling price is the MSRP less the volume discount, and the unit cost of goods sold and allowance expense make up the variable cost. In this assignment you will use break-even analysis as a check against a plan to launch a new product, and you will use it to assess the impact of higher fixed costs from an increase in capacity. For this assignment suppose that a firm has an existing product with a combined advertising and promotion budget of $25.0 million and with projected sales of 115 million units. They are launching a new product with a budget of $20.0 million and estimated sales of 10 million units in the first year. The sales force expense of $10 million has been allocated equally between products; 90% of the plant overhead has been allocated to the existing product, and 10%, to the new product. Additional values for each product are shown in the table below.
Continued on next page… |
Student or Team Name:
- In the table above, why do the fixed costs for sales force, plant, and administrative costs need to be allocated to each product? Why are advertising and promotion expenses shown separately from the allocated amount?
- Calculate the break-even units for each product, showing the intermediate calculations for the total fixed costs, selling prices, and unit variable costs.
|
Existing Product |
New Product |
|
|
Total Fixed Cost |
||
|
Unit Selling Price |
||
|
Unit Variable Cost |
||
|
Break-Even Units |
3. How might the results of your break-even calculation affect the marketing of the new product? What other factors besides break-even should you consider?
Continued on next page…
Student or Team Name:
4. Production anticipates it will need to increase capacity to 140 million units, adding $10.0 million to annual fixed costs. If the product allocation of the plant cost is also changed to 80%/20%, what is the impact on break-even units?
|
Existing Product |
New Product |
|
|
Total Fixed Cost |
||
|
Unit Selling Price |
||
|
Unit Variable Cost |
||
|
Break-Even Units |
