Compute break-even point for the given sales mix

Assignment Help Case Study
Reference no: EM131013329

Case: Mendel Paper Company

Mendel Paper Company produces four basic paper product lines at one of its plants: computer paper, napkins, place mats, and poster board. Materials and operations vary according to the line of product. The market has been relatively good. The demand for napkins and place mats has increased with more people eating out, and the demand for the other lines has been growing steadily.

The plant superintendent, Marlene Herbert, while pleased with the prospects for increased sales, is concerned about costs:

"We hear talk about a paperless office, but I haven't seen it yet. The computers, if anything, have increased the market for paper. Our big problem now is the high fixed cost of production. As we have automated our operation, we have experienced increases in fixed overhead and even variable overhead. And, we will have to add more equipment since it appears that we need even more plant capacity. We are operating over our normal capacity as it is.

The place mat market concerns me. We may have to discontinue printing the mats. Our specialty printing is driving up the variable overhead to the point where we may not find it profitable to continue with that line at all."

Cost and price data for the next fiscal quarter are as follows:

 

Computer paper

Napkins

Place mats

Poster board

Estimated sales volume in units

30,000

120,000

45,000

80,000

Selling prices................

     $14.00

      $7.00

     $12.00

      $8.50

Materials costs............

       6.00

       4.50

       3.60

        2.50

Variable overhead includes the cost of hourly labor and the variable cost of equipment operation. The fixed plant overhead is estimated at $420,000 for the quarter. Direct labor, to a large extent, is salaried; the cost is included as a part of fixed plant overhead. The superintendent's concern about the eventual need for more capacity is based on increases in production that may reach and exceed the practical capacity of 60,000 machine hours.

In addition to the fixed plant overhead, the plant incurs fixed selling and administrative expenses per quarter of $118,000.

"I share your concern about increasing fixed costs," the supervisor of plant operations replies. "We are still operating with about the same number of people we had when we didn't have this sophisticated equipment. In reviewing our needs and costs, it appears to me that we could cut fixed plant overhead to $378,000 a quarter without doing any violence to our operation. This would be a big help."

"You may be right," Herbert responds. "We forget that we have more productive power than we once had, and we may as well take advantage of it. Suppose we get some hard figures that show where the cost reductions will be made."

Data with respect to production per machine hour and the variable cost per hour of producing each of the products are given as follows:

 

Computer paper

Napkins

Place mats

Poster board

Units per hour

6

10

5

4

Variable overhead perhour

 $9.00

  $6.00

 $12.00

  $8.00

"I hate to spoil things," the vice-president of purchasing announces. "But the cost of our materials for computer stock is now up to $7. Just got a call about that this morning. Also, place mat materials will be up to $4 a unit."

"On the bright side," the vice-president of sales reports, "we have firm orders for 35,000 cartons of computer paper, not 30,000 as we originally figured."

Questions:

From all original estimates given, prepare estimated contribution margins by product line for the next fiscal quarter. Also, show the contribution margins per unit.

Prepare contribution margins as in part (1) with all revisions included.

For the original estimates, compute each of the following:

(a) Break-even point for the given sales mix.

(b) Margin of safety for the estimated sales volume.

For the revised estimates, compute each of the following:

(a) Break-even point for the given sales mix.

(b) Margin of safety for the estimated sales volume.

Comment on Herbert's concern about the variable cost of the place mats.

Reference no: EM131013329

Questions Cloud

Stocks and bonds are derivative assets : Stocks and Bonds are Derivative Assets. The New York Stock Exchange and the NASDAQ are Primary Markets, the American Stock Exchange is the Third Market. The NASDAQ is an example of an dealer market. The New York Stock Exchange is an example of an ove..
Describe autocratic versus democratic leadership dimension : Can there be an effective "EU Leader"? Is this a realistic prospect? Discuss the factors involved with this concept. What role has the financial crisis in the Eurozone played in this concept?
Each month to cover the rising costs of health care : Your aunt and uncle (from 9 above) figure that they will need to increase their monthly withdrawals by .25% each month to cover the rising costs of health care, housing and food. Assuming all of the other facts from the previous situation, what is th..
Dividends will grow at annual rate of four percent forever : You have been following a company, Marathon Capstone, Inc., that is about to go public this afternoon. You are fairly certain that the company will not pay dividends for the first eight years of its operations. You forecast that the tenth year's divi..
Compute break-even point for the given sales mix : Prepare contribution margins as in part (1) with all revisions included. For the original estimates, compute each of the following: Break-even point for the given sales mix
Estimate the volume v of the mound by computing the average : Estimate the volume V of the mound by computing the average of the two Riemann sums4,3 with lower-left and upper-right vertices of the sub rectangles as sample points.
How the project costs are influenced by the quality : Compare and contrast top-down versus bottom-up estimating and discuss how the project costs are influenced by the quality and accuracy of estimates.
Explain the theory of contingency leadership : What are the implications for motivation of Hofstede's research findings on the dimensions of power distance, uncertainty avoidance, individualism, and masculinity?
The market porfolio and the risk-free asset : You are given the following information concerning three portfolios, the market porfolio, and the risk-free asset: Portfolio X 12% Rp 29% Op 1.25 Bp Portfolio Y 11% Rp 24% Op 1.10% Bp Portfolio Z 8% Op 14% Op .75 Bp Market 10 Rp 19 Op 1.00 Bp Risk-fr..

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd