Break-Even Analysis Breakeven 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 prot 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 xed 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 xed costs can be broken into discretionary marketing expenditures {such as sales force and advertising budget) and xed 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 breakeven analysis as a check against a plan to launch a new product, and you will use it to assess the impact of higher xed costs from an increase in capacity. For this assignment suppose that a rm 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 rst 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. Existing Product New Product MSRP $5.39 54.99 Volume Discount 35% 35% Unit Cost Promotional Allowance Advertising 8: Promotion Allocated Fixed Costs $68M $12M Projected Unit Sales 115M 10M 1. In the table above, why do the xed 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? 2. Calculate the break-even units for each product, showing the intermediate calculations for the total xed costs, selling prices, and unit variable costs. Total Fixed Cost Unit Selling Price Existing Product New Product 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? Production anticipates it will need to increase capacity to 140 million units, adding $10.0 million to annual xed costs. If the product allocation of the plant cost is also changed to 8096/2096, what is the impact on break-even units? Existing Product New Product Total Fixed Cost Unit Selling Price Unit Variable Cost Break-Even Units