The Chucky Nut Company (CNC) makes four different products from macadamia nuts grown in the Hawaiian...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Chucky Nut Company (CNC) 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 CNC to watch its margins to ensure it is operating in the most efficient manner possible. To meet marketing demands for the coming week, CNC needs to produce at least 1,050 pounds of the Whole product, between 400 and 500 pounds of the Cluster product, no more than 200 pounds of the Crunch product, and no more than 250 pounds of Roasted product. Each pound of the Whole, Cluster, Crunch, and Roasted product contains, respectively, 60%, 40%, 25%, and 100% macadamia nuts with the remaining weight, if any, being made up of chocolate coating. The company has 1,200 pounds of nuts and 850 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 production rate (pounds/hour) for each product on each machine. Each machine has 65 hours of operating time available in the coming week. Production rate (pounds/hour) Machine Whole Cluster Crunch Roasted Hulling 60 30 60 45 Roasting 30 40 60 35 Coating 60 75 120 Packaging 25 45 50 75 The production engineer recently presented management with the following financial summary of CNC's average weekly operations over the past quarter. Whole Cluster Crunch Roasted Sales Revenue $5,300 S2,150 $540 $930 Costs: Direct materials $1,331 $560 $144 S320 Direct labor $1,092 $400 $96 $130 Variable manufacturing overhead $333 $140 $36 $90 Variable selling & administrative $540 $180 $62 $120 Pounds Sold 1040 500 150 200 Managerial Report a) Formulate the above optimization problem as a linear program. Clearly define the decision variables and provide a verbal description of the objective function as well as each of the constraints. b) How many decision variables and functional constraints does the model developed in part (a) include? c) Solve the model developed in part (a) using Excel solver. d) Solve the model developed in part (a) using LINGO. e) Use a tabular format to clearly summarize the optimal solution obtained (i.e. the optimal values for all decision variables), as well as the associated optimal objective function value. ) Is the optimal solution obtained degenerate? Why or why not? g) Is the optimal solution obtained unique? Why or why not? h) Comment on the utilization of the resources (i.e., which of the resources have been fully utilized and which haven't). i) Comment on the range of optimality for the objective function coefficients and provide its interpretation. j) Discuss the range of feasibility for the constraints right hand sides and provide its interpretation. k) Present the shadow prices for the constraints along with their interpretations. I) If CNC wanted to decrease the production of any product, which one would you recommend and why? How much less of that product should be produced? (assume minimum production requirements could be violated). m) If CNC wanted to increase the production of any product, which one would you recommend and why? How much more of that product should be produced? (assume maximum production requirements could be violated). n) Which resource is preventing CNC from making more money? If they could acquire more of this resource, how much should they acquire & how much should they be willing to pay to acquire more of it? In case there is more than one such resource, then answer this question for each resource, one at a time. o) How much should CNC be willing to pay for every additional pound of chocolate? p) If the marketing department wanted to decrease the price of the Whole product by $0.5, would the optimal solution change? Report the revised objective function value either way. 9) If the marketing department wanted to increase the price of the Crunch product by $1, would the optimal solution change? Report the revised objective function value either way. r) Assuming that CNC imposes a restriction on the production quantity of Crunch whereby it shall not constitute more than 40% of the total produced from all products, how would this restriction be formulated as a constraint? Would the amendment of this constraint to the LP developed in part (a) change the optimal solution obtained earlier? Why or why not? s) Assume that the CNC has the option to run its 4 machines after hours on overtime basis for a maximum of 10 more hours per machine. The hourly rate amounts to $15, $21, $17 and $13 for the Hulling, Roasting, Coating and Packaging machines, respectively. Revisit the LP model developed in part (a) to account for overtime hours and report the revised optimal solution obtained. Which machines take advantage of the added overtime production capacity? The Chucky Nut Company (CNC) 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 CNC to watch its margins to ensure it is operating in the most efficient manner possible. To meet marketing demands for the coming week, CNC needs to produce at least 1,050 pounds of the Whole product, between 400 and 500 pounds of the Cluster product, no more than 200 pounds of the Crunch product, and no more than 250 pounds of Roasted product. Each pound of the Whole, Cluster, Crunch, and Roasted product contains, respectively, 60%, 40%, 25%, and 100% macadamia nuts with the remaining weight, if any, being made up of chocolate coating. The company has 1,200 pounds of nuts and 850 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 production rate (pounds/hour) for each product on each machine. Each machine has 65 hours of operating time available in the coming week. Production rate (pounds/hour) Machine Whole Cluster Crunch Roasted Hulling 60 30 60 45 Roasting 30 40 60 35 Coating 60 75 120 Packaging 25 45 50 75 The production engineer recently presented management with the following financial summary of CNC's average weekly operations over the past quarter. Whole Cluster Crunch Roasted Sales Revenue $5,300 S2,150 $540 $930 Costs: Direct materials $1,331 $560 $144 S320 Direct labor $1,092 $400 $96 $130 Variable manufacturing overhead $333 $140 $36 $90 Variable selling & administrative $540 $180 $62 $120 Pounds Sold 1040 500 150 200 Managerial Report a) Formulate the above optimization problem as a linear program. Clearly define the decision variables and provide a verbal description of the objective function as well as each of the constraints. b) How many decision variables and functional constraints does the model developed in part (a) include? c) Solve the model developed in part (a) using Excel solver. d) Solve the model developed in part (a) using LINGO. e) Use a tabular format to clearly summarize the optimal solution obtained (i.e. the optimal values for all decision variables), as well as the associated optimal objective function value. ) Is the optimal solution obtained degenerate? Why or why not? g) Is the optimal solution obtained unique? Why or why not? h) Comment on the utilization of the resources (i.e., which of the resources have been fully utilized and which haven't). i) Comment on the range of optimality for the objective function coefficients and provide its interpretation. j) Discuss the range of feasibility for the constraints right hand sides and provide its interpretation. k) Present the shadow prices for the constraints along with their interpretations. I) If CNC wanted to decrease the production of any product, which one would you recommend and why? How much less of that product should be produced? (assume minimum production requirements could be violated). m) If CNC wanted to increase the production of any product, which one would you recommend and why? How much more of that product should be produced? (assume maximum production requirements could be violated). n) Which resource is preventing CNC from making more money? If they could acquire more of this resource, how much should they acquire & how much should they be willing to pay to acquire more of it? In case there is more than one such resource, then answer this question for each resource, one at a time. o) How much should CNC be willing to pay for every additional pound of chocolate? p) If the marketing department wanted to decrease the price of the Whole product by $0.5, would the optimal solution change? Report the revised objective function value either way. 9) If the marketing department wanted to increase the price of the Crunch product by $1, would the optimal solution change? Report the revised objective function value either way. r) Assuming that CNC imposes a restriction on the production quantity of Crunch whereby it shall not constitute more than 40% of the total produced from all products, how would this restriction be formulated as a constraint? Would the amendment of this constraint to the LP developed in part (a) change the optimal solution obtained earlier? Why or why not? s) Assume that the CNC has the option to run its 4 machines after hours on overtime basis for a maximum of 10 more hours per machine. The hourly rate amounts to $15, $21, $17 and $13 for the Hulling, Roasting, Coating and Packaging machines, respectively. Revisit the LP model developed in part (a) to account for overtime hours and report the revised optimal solution obtained. Which machines take advantage of the added overtime production capacity?
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 an effort to keep up with the rapidly changing global financial markets, the FASB issued standards on accounting for and disclosure of derivative financial instruments. A Journal of Accountancy...
-
A metal ball is barely able to pass through a metal ring. When Anette Zetterberg heats the ball, it does not pass through the ring. What happens if she instead heats the ring (as shown)? Does the...
-
DISCUSSION No more than 200 words As we study human development, our focus turns to change and stability. Do peoples personalities ever really change? Or are we destined to make similar choices...
-
(a) lim f(x) X-C+ 5. y 7. Y 9. 2 IT - Limits and Continuity In Exercises 5-10, use the graph to determine each limit, and discuss the continuity of the function. -3+ (4,3), + + 1/2 3 4 (3, 1) (b) lim...
-
Increasing tuition has resulted in some students being saddled with large debts on graduation. To examine this issue, a random sample of recent graduates was asked to report whether they had student...
-
What was the payment for the 20 -year loan? The 30 -year loan? Calculate the difference. Below are two amortization tables. They are for loans with the same principal and interest rate, but different...
-
To what extent and in what ways are capital market participants, notably investors and corporations, affected by international accounting diversity?
-
Midwest Ventilation, Inc., produces industrial ventilation fans. The company plans to manufacture 72,000 fans evenly over the next quarter at the following costs: direct material, $2,880,000; direct...
-
Find all solutions for x in the interval [0, 360) for the following equation: cos(x) = - 3
-
Jeff Harris owns an appliance store. On January 1 he borrowed 50,000 dollars for improvements to the store from BBT, who took a security interest in all of the equipment and fixtures in the store. On...
-
1. Create a program that prompts the user to enter a the pH number of an aqueous solution (as a decimal number). The program then uses the number to determine if the solution is acidic (0 7). (The...
-
In the fall of2009, Kraft Foods attempted to buy Cadbury plc. Data for each of the two companies are given in the table. Both companies are all equity financed. The CEO of Kraft Foods estimated that...
-
Where did I go wrong? You can see the code I have applied and it's almost there, but something isn't correct in my code and I can't figure out where I went wrong. Please help me find the error and...
-
Wehner Company is currently manufacturing Part ABS-43, producing 53,400 units annually. The part is used in the production of several products made by Wehner. The cost per unit for ABS-43 is as...
-
Harem company uses an annual cost formula for overhead of 72,000 + 1.60 for each direct labor hour worked. For the upcoming month, Karla plans to manufacture 96,000 units. Each units requires five...
-
What role does the Chief Risk Officer play in the credit process and how does it differ from that of the Chief Credit Officer? Distinguish between the account officer, credit specialists and...
-
ngs Leung Corporation manufactures a single product. The standard cost per unit of product is as follows. Direct materials-2 pounds of plastic at $5 per pound Direct labor-2 hours at $12 per hour...
-
g(x) = x 5 5x 6 a. Show that g(x) = 0 has a root, , between x = 1 and x = 2. b. Show that the equation g(x) = 0 can be written as x = (px + q) 1/r , where p, q and r are integers to be found. The...
-
A trust officer at Pond Island Bank needs to determine what percentage of the banks investible funds to place in each of the following investments. The column labeled Yield represents each...
-
Draw the network representation of the following network flow problem. What kind of network flow problem is this? MIN: +2X13 + 6X14 + 5X15 + 4X23 + 3X24 + 7X25 Subject to: - X13 - X14 - X15 = - 8 +...
-
Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions: MAX: 4X1 + 2X2 Subject...
-
Three bases of position power are ____________. (a) reward, expertise, and coercive power (b) legitimate, experience, and judgment power (c) knowledge, experience, and judgment power (d) reward,...
-
What are power and influence?
-
What are the key sources of power and influence?
Study smarter with the SolutionInn App