Verified Document

Break Even Planning And Analysis Case Study

¶ … assist the Pringly Division to set up the appropriate pricing for the new product. To achieve this objective, the paper carries out the break-even analysis that will assist the company to fix the appropriate pricing and quantity for the new product. The company had not been able to achieve its sales target in the past making the company to lose some profits. Thus, the company has decided to reduce its budget to avoid disappointment of the past. Thus, the company has set up different targets to follow and the targets will be evaluated to assist the company to make appropriate decision on the pricing of the new product:

The first strategy is to fix the selling price of the new product to $170 per unit carrying the annual fixed costs of $20,000,000.

The second alternative is to increase the cost of promotion and advertising and set the selling price of the new product to $220. However, the fixed costs will increase to $25,000,000 because the marketing department is adamant that the company needs to increase the advertising costs to achieve the sales target.

The table below reveals the three possibility levels of customer demands.

Estimated demand (units)

Estimated probability (units)*

0.25

0.5

0.25

Financial Analysis

The first step is to set up the selling price, the fixed costs and variable costs per unit.

Selling price

Fixed costs

Variable Cost per unit

$170

$20,000,000

$35

$220

$25,000,000

$35

Thus, the report will provide the break-even points at each level for the first and second strategies as being revealed below:

Break-even point for the first strategy based on the estimated demand of 150,000 units.

Break-even point for the first strategy based on the estimated demand of 180,000 units.

Break-even point for the first strategy based on the estimated demand of 200,000 units.

Break-even point for the second strategy based on the estimated demand of 150,000 units.

Break-even point for the second based on the estimated demand of 180,000 units.

Break-even point for the second strategy based on the estimated demand of 200,000 units.

Thus, the paper calculates the breakeven point at different levels using the data in the table below:

When Estimated Demand = 150,000 units

First Strategy

Second Strategy

New Product

Estimated Costs

Estimated Costs

Variable cost per unit

$35

$35

Fixed cost

20, 000,000

$25,000,000

Selling price per unit

$170

$220

Budget volume

150,000

150,000

When Estimated Demand = 180,000 units

First Strategy

Second Strategy

New Product

Estimated Costs

Estimated Costs

Variable cost per unit

$35

$35

Fixed cost

20, 000,000

$25,000,000.

Selling price per unit

$170

$220

Budget volume

180,000

180,000

When Estimated Demand = 200,000 units

First Strategy

Second Strategy

However, the company will not achieve the target profit of more than $4,000,000 with the estimated demand of 150,000 units using the first and second strategy. The detailed breakdown of the break even analysis is revealed in the Appendix 1.
The paper uses the financial analysis in the table below to support this assertion:

Profits derived at the First and Second Strategy when the estimated Demand is 150,000 units

First Strategy

Second Strategy

Sales (150,000 x $170)

$25,500,000

Sales (150,000 x $220)

$33,000,000

Variable cost per unit (150,000 x35)

5,250,000

5,250,000

Fixed Costs

20,000,000

25,000,000

Total Costs

25,250,000

25,250,000

30,250,000

30,250,000

Profits

$250,000

$2,750,000

Profits derived at the First and Second Strategy when the estimated Demand is 180,000 units

First Strategy

Second Strategy

Sales (180,000 x $170)

$30,600,000

Sales (180,000 x $220)

$39,600,000

Variable cost per unit (180,000 x35)

6,300,000

6,300,000

Fixed Costs

20,000,000

25,000,000

Total Costs

26,300,000

26,300,000

31,300,000

31,300,000

Profits

$4,300,000

$8, 300,000

Profits derived at the First and Second Strategy when the estimated Demand is 200,000 units

First Strategy

Second…

Cite this Document:
Copy Bibliography Citation

Related Documents

Break Even Analysis and Planning
Words: 1062 Length: 3 Document Type: Case Study

Costing Case Study The managers at Pringly Division need to make a decision regarding the pricing of a new product. There are two strategies suggested; the first is for the product to be sold at $170, the second strategy is to increase the marketing and increase the price. In both cases, the firm has a requirement that they will make a $4,000,000 profit. In order to assess which is likely

Break Even Analysis and Modeling
Words: 497 Length: 4 Document Type: Essay

Excel Modeling: Sports Feet Manufacturing Planning and Implementing the Model The first step in this modeling exercise was to plan for the variables that will later be used in the desired calculations. Annual fixed cost ($52,000), unit variable cost ($9), and unit selling price ($25) need to be utilized as inputs for calculations on outputs such as annual revenue, annual total cost, and annual profit / loss (). This data was then

Break Even Analysis and Planning
Words: 898 Length: 3 Document Type: Essay

Flexible Budgeting Flexible Budget Levels (in millions) Competitor Corporate Economic 10% Rate 9% Rate % Rate Revenue Company Operating Stores Licensed Stores CPG, food service, & other Total Revenue Cost of Sales Total Operating Expenses Total Cost Income from equity investees Operating Income Interest Income Interest Expense Earnings Before Tax Income Tax Net Earnings This flexible budget was done for Starbucks Corporation and is an annual budget for the year 2012. Caribou Coffee is one of Starbucks Corporation's largest competitors. Caribou Coffee's annual projected sales growth for 2012 is 10%. (Caribou Coffee Reports Fourth

Planning and Reflection During My Student Teaching
Words: 2663 Length: 8 Document Type: Term Paper

Planning and Reflection During my student teaching experiences I kept a journal, which greatly helped me to organize my thoughts and clarify the areas in which I most needed to improve. My mentor also pointed out for me the key areas that need improvement. Therefore, as I look forward to a professional career as a teacher, I will be able to draw on these early experiences. I will remember what works

Marketing Planning Project Quantify the
Words: 2603 Length: 6 Document Type: Term Paper

Opportunities Demographics throughout all Australian cities reflect significant opportunity for an online DVD ordering service, replicating the success of NetFlix in the U.S. Development of music and other forms of digital content can also specifically be sold through this channel once established. Potential exit strategy is to sell QuickFlix to NetFlix. Threats Well-funded broadband providers attack the downloadable movie market and force a premature consolidation of this business model. Pricing becomes more inelastic and profitability suffers. Postal

Succession Planning for Multi-Faceted Enterprises and Organizations...
Words: 9765 Length: 30 Document Type: Essay

Succession Planning for Multi-Faceted Enterprises and Organizations La Russa Enterprises Thunder Bay, Ontario Nadia La Russa The journey to this point in my academic career has been a long one, and challenging, however I am successful. A number of people have effortlessly contributed to my success, and I take this opportunity to thank them. First, it is with great honor that I thank my academic adviser he/she took on the obligation of advising me

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now