Cost Volume Profit Analysis Mba Finance Project Report

Using the assumptions given in the case, all elements of income statement and balance sheet can be projected for next three years 2010, 2011 and 2012. Sales cycle of the products of the company is such that sales of a particular product increases initially for few years and then starts to decline as the new technology

1. What is the weighted average contribution margin (WACM) percentage for Bridgestone’s next annual budget?

Breakeven Analysis for Product Tylenol Approach 1 - Same price as Tylenol Approach 2a - Cheaper than Tylenol Approach 2b - Cheaper w/lowered trade cost $ $ $ $ Unit Cost (Variable Cost) 0.60 0.60 0.60 0.60 Trade Cost (Selling Price to Retailers) $ 1.69 $ 1.69 $ 1.05 $ 0.70 Fixed Cost (Advertising) 2,000,000 6,000,000 6,000,000 6,000,000 Break-Even Quantity [Fixed Cost/(Trade Cost-Unit Cost)] 1,834,862 5,504,587 13,333,333 60,000,000 Contribution Margin (Unit) 64% 64% 43% 14%

In order to calculate the breakeven point, we use the following equation and budget data:

Although the financial goal is to create profit, we need to calculate the breakeven point to get started.

5. Determine the necessary sales in unit and dollars to break-even or attain desired profit using the break-even formula.

Determine the unit break-even point, assuming fixed costs are $60,000 per period, variable costs are $16.00 per unit, and the sales price is $25.00 per unit.

In our second assumption, instead of using the cost of goods per cases in 1986, we try to use the percentage it counts in the total expenses which is 50.4% and to find the sales needed to break-even. The detail of the calculation is shown in the answer for questions d. The result is that 95,635, a little bit higher than the estimated sales of 90,000.

Based on the Excel Problem of chapter one, if the total capacity for this business is 725 will you stay in it? If you want to stay in it what price you need to obtain a break even point of 725?

= Unit Selling Price – Unit Variable Cost = $9.00 – ($1.25 + $0.35 + $1.00) = $6.40

1. In the last five years the growth in sales for the company has been around 10% per annum, except for the 1997, the growth was 18.78%. In the case, nothing is mentioned that company has made any drastic changes in its strategy to grow faster. In such a scenario, projected a consistent growth of 20% per annum for the next 5 years is too optimistic.

A result on the next page shows that at sales price of $21.50, the sales quantity rises to 1,140,085 units and net profit turns to positive for the first time. Besides, if a company continues to reduce the price further, at the point of $15.50, it is where the company’s profit on product 101 is in the highest position as it gives the net profit of $3,901,908.

This question gives students an opportunity to exercise their ability to interpret break-even analyses. Key teaching points should include explaining the preparation of a break-even chart, the interpretation of the break-even volume (938,799 hectoliters [HL]), and the comparison of the break-even volume to the current volume (1,173,000 HL). Another key point is that the chart in case Exhibit 5 is relevant only for the current cost structure of the company—if variable costs increase or the plant expansion is approved, the break-even volume will rise. Finally, students should be aided in understanding that “break-even” refers to operating profit, not free cash flow. The typical use of the break-even chart ignores taxes, investments, and the depreciation tax shield.

3. Refer to the monthly sales forecasts given in the first Table. Assume that these amounts are realized and that the firm’s customers pay exactly as predicted.

The other assumptions of the management are that the selling price for goods will be the same in 2007 and that top line growth will be 3% assuming no acquisition in 2007. If in 2007, the