CASE 4-1 A Nut Case The Molokai Nut Company (MNC) makes four different products from macadamia...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
CASE 4-1 A Nut Case The Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-coated nut clusters (Cluster), chocolate-coated nut crunch bars (Crunch), and plain roasted nuts (Roasted). The company is barely able to keep up with the increasing demand for these products. However, increasing raw material prices and foreign competition are forcing MNC to watch its margins to Sales Revenue Variable Costs Product Whole $5,304.00 Cluster $1,800.00 Crunch $510.00 Roasted $925.00 $8,539.00 Direct materials $1,331.00 $560.00 $144.00 Copyright 2018 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall leaming experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. Direct labor $1,092.00 $400.00 $96.00 $320.00 $130.00 Manufacturing overhead $333.00 $140.00 $36.00 Selling & Administrative $540.00 $180.00 $62.00 $90.00 $120.00 $2,355.00 $1,718.00 $599.00 $902.00 Questions and Problems 179 Allocated Fixed Costs ensure it is operating in the most efficient manner possible. To meet marketing demands for the coming week, MNC needs to produce at least 1,000 pounds of the Whole product, between 400 and 500 pounds of the Cluster product, no more than 150 pounds of the Crunch product, and no more than 200 pounds of Roasted product. Each pound of the Whole, Cluster, Crunch, and Roasted product contains, respectively, 60%, 40%, 20%, and 100% macadamia nuts with the remaining weight made up of chocolate coating. The company has 1100 pounds of nuts and 800 pounds of chocolate available for use in the next week. The various products are made using four different machines that hull the nuts, roast the nuts, coat the nuts in chocolate (if needed), and package the products. The following table summarizes the time required by each product on each machine. Each machine has 60 hours of time available in the coming week. 1. Do you agree with the controller's recommendation? Why or why not? Manufacturing overhead $687.83 $330.69 $99.21 Selling & Administrative $577.78 $277.78 $83.33 Net Profit $742.39 -$88.47 -$10.54 Units Sold Net Profit Per Unit 1040 $0.7138 500 150 $132.28 $111.11 $21.61 200 $1,250.01 $1,050.00 $664.99 -$0.1769 -$0.0703 $0.1081 Minutes Required per Pound Machine Whole Cluster Crunch Roasted Hulling 1.00 1.00 1.00 1.00 Roasting 2.00 1.50 1.00 1.75 Coating 1.00 0.70 0.20 0.00 Packaging 2.50 1.60 1.25 1.00 The controller recently presented management with the following financial summary of MNC's average weekly operations over the past quarter. From this report, the controller is arguing that the company should cease producing its Cluster and Crunch products. 2. Formulate an LP model for this problem. 3. Create a spreadsheet model for this problem and solve it using Solver. 4. What is the optimal solution? 5. Create a sensitivity report for this solution and answer the following questions. 6. Is the solution degenerate? 7. Is the solution unique? Total 1890 $0.3518 8. If MNC wanted to decrease the production on any product which one would you recom- mend and why? 9. If MNC wanted to increase the production of any product which one would you recommend and why? 10. Which resources are preventing MNS from making more money? If they could acquire more of this resource how much should they acquire and how much should they be willing to pay to acquire it? 11. How much should MNC be willing to pay to acquire more chocolate? 12. If the marketing department wanted to decrease the price of the Whole product by $0.25, would the optimal solution change? 13. Create a Spider Plot showing the impact on net profit of changing each product's required time in the packaging process from 70% to 130% of their original values in 5% increments. Interpret the information in the resulting chart. 14. Create a Spider Plot showing the impact on net profit of changing the availability of nuts and chocolate from 70% to 100% of their original values in 5% increments. Interpret the infor- mation in the resulting chart. CASE 4-1 A Nut Case The Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-coated nut clusters (Cluster), chocolate-coated nut crunch bars (Crunch), and plain roasted nuts (Roasted). The company is barely able to keep up with the increasing demand for these products. However, increasing raw material prices and foreign competition are forcing MNC to watch its margins to Sales Revenue Variable Costs Product Whole $5,304.00 Cluster $1,800.00 Crunch $510.00 Roasted $925.00 $8,539.00 Direct materials $1,331.00 $560.00 $144.00 Copyright 2018 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall leaming experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it. Direct labor $1,092.00 $400.00 $96.00 $320.00 $130.00 Manufacturing overhead $333.00 $140.00 $36.00 Selling & Administrative $540.00 $180.00 $62.00 $90.00 $120.00 $2,355.00 $1,718.00 $599.00 $902.00 Questions and Problems 179 Allocated Fixed Costs ensure it is operating in the most efficient manner possible. To meet marketing demands for the coming week, MNC needs to produce at least 1,000 pounds of the Whole product, between 400 and 500 pounds of the Cluster product, no more than 150 pounds of the Crunch product, and no more than 200 pounds of Roasted product. Each pound of the Whole, Cluster, Crunch, and Roasted product contains, respectively, 60%, 40%, 20%, and 100% macadamia nuts with the remaining weight made up of chocolate coating. The company has 1100 pounds of nuts and 800 pounds of chocolate available for use in the next week. The various products are made using four different machines that hull the nuts, roast the nuts, coat the nuts in chocolate (if needed), and package the products. The following table summarizes the time required by each product on each machine. Each machine has 60 hours of time available in the coming week. 1. Do you agree with the controller's recommendation? Why or why not? Manufacturing overhead $687.83 $330.69 $99.21 Selling & Administrative $577.78 $277.78 $83.33 Net Profit $742.39 -$88.47 -$10.54 Units Sold Net Profit Per Unit 1040 $0.7138 500 150 $132.28 $111.11 $21.61 200 $1,250.01 $1,050.00 $664.99 -$0.1769 -$0.0703 $0.1081 Minutes Required per Pound Machine Whole Cluster Crunch Roasted Hulling 1.00 1.00 1.00 1.00 Roasting 2.00 1.50 1.00 1.75 Coating 1.00 0.70 0.20 0.00 Packaging 2.50 1.60 1.25 1.00 The controller recently presented management with the following financial summary of MNC's average weekly operations over the past quarter. From this report, the controller is arguing that the company should cease producing its Cluster and Crunch products. 2. Formulate an LP model for this problem. 3. Create a spreadsheet model for this problem and solve it using Solver. 4. What is the optimal solution? 5. Create a sensitivity report for this solution and answer the following questions. 6. Is the solution degenerate? 7. Is the solution unique? Total 1890 $0.3518 8. If MNC wanted to decrease the production on any product which one would you recom- mend and why? 9. If MNC wanted to increase the production of any product which one would you recommend and why? 10. Which resources are preventing MNS from making more money? If they could acquire more of this resource how much should they acquire and how much should they be willing to pay to acquire it? 11. How much should MNC be willing to pay to acquire more chocolate? 12. If the marketing department wanted to decrease the price of the Whole product by $0.25, would the optimal solution change? 13. Create a Spider Plot showing the impact on net profit of changing each product's required time in the packaging process from 70% to 130% of their original values in 5% increments. Interpret the information in the resulting chart. 14. Create a Spider Plot showing the impact on net profit of changing the availability of nuts and chocolate from 70% to 100% of their original values in 5% increments. Interpret the infor- mation in the resulting chart.
Expert Answer:
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these general management questions
-
In cold climates, water pipes may freeze and burst if proper precautions are not taken. In such an occurrence, the exposed part of a pipe on the ground ruptures, and water shoots up to 34 m. Estimate...
-
In Power Bi please:I have a data table in the following format:DateSoccerBasketballBaseball2022 November9856602022 December10154612023 January10457642023 February100506 1 answer
-
For 2016, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: 1....
-
State an identity involving tan t and sec t.
-
The wreck of the S.S. Central America waited 130 years at the bottom of the ocean for someone to come along and claim its trove of gold. Thomas G. Thompson, funded by a multitude of investors, was...
-
The Colson Company issued $300,000 of 10% bonds on January 1, 2011. The bonds are due January 1, 2016, with interest payable each July 1 and January 1. The bonds are issued at face value. Prepare...
-
A 15 kg box is given a shove to the right on a horizontal, rough surface. After the hand loses contact, the box's acceleration (using standard directions) is a = (-1.2 m/s, 0). (a) What are the...
-
I have a presentation group and my part is the introduction, key Issues & Stakeholders: I will be presenting my part for two minutes:(And this is what I wrote to present it but I think it's not...
-
What steps are involved in establishing a credit policy?
-
In 2008/09 the British pound depreciated by approximately 25 per cent on a trade-weight basis after the Bank of England reduced interest rates to a historically low level. In your opinion, did the...
-
Which of the following companies are likely to have high short-term financing needs? Why? (a) The Hilton. (b) British Gas. (c) Manchester United. (d) Thomas Cook. (e) Private Infrastructure...
-
Provide an overview of the empirical determinants of hedging. If you were the corporate treasurer for a company, would you recommend hedging as a risk management strategy? Explain.
-
Wuttke plc wants to raise 3.65 million via a rights issue. The company currently has 490,000 ordinary shares outstanding that sell for 30 per share. Its underwriter has set a subscription price of 22...
-
Klein makes use of extended examples in building her argument. How do these examples enhance her central message? What about the fact that Klein does not provide in-text citations like most academic...
-
Do animals have rights? If so, what are they? What duties do human beings have toward animals? Does KFC protect animal welfare at an acceptable level?
-
Go to http://management.about.com/lr/project_time_ management/174690/1/ and click on Project Management on the left side of the screen. When you consider several of the articles on time management in...
-
Consider the following information that you have compiled regarding the steps needed to complete a project. You have identified all relevant steps and have made some determinations regarding...
-
Key in a search with the prompt projects in in which you select a country of interest (e.g., projects in Finland). Many of the projects generated by such a search are government-sponsored...
Study smarter with the SolutionInn App