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...
-
Consider once again the nutritional deficiency example and Model 4 from Chapter 8. In Section 9.6.5, the parameter L = (1 + 2) associated with one-unit increases in height and age was considered, and...
-
Power +, Inc. produces AA batteries used in remote-controlled toy cars. The mean life of these batteries follows the normal probability distribution with a mean of 35.0 hours and a standard deviation...
-
Epic Systems is a Wisconsin health care software company. In 2014, Epic introduced a company policy that required employees to use individual arbitration in any disputes. Jacob Lewis, an Epic...
-
Helix Company produces costumes used in the television and movie industries. Recently the company received an ongoing order for Samurai robes to be worn in an upcoming Japanese historical action...
-
assumption 1 assume there will be 4000 visits, each visit will yield 1400 of revenue
-
On January 1, 2014, Freeman Inc. purchased a new machine and financed this purchase by making a cash down payment of $30,000 and issuing a 12%, 5-year note that will be paid in semiannual installment...
-
The amount of data in the healthcare ecosystem is doubling at an exponentially high rate and includes among many things financial and quality data points. What do you believe (either personally or...
-
I need some with this practice case, please. I rate The following is a waiting queue simulation model oriented towards service stations. The administration of a service station near a highway wants...
-
Our financial institution has been a leader in providing financial products and services to Canadians for over 100 years. As part of our commitment to meet the evolving needs of our customers, we are...
-
Discuss briefly the three inherent powers of the state, and for each power, give an example on how the state exercises them.
-
Your client traditionally provided free doughnuts and coffee to its employees every Friday morning to help boost morale. Under prior law, the cost of this event was 100 percent tax-deductible as a de...
-
If the price of sunscreen rises, with all other influences on buying plans remaining the same, does the demand for sunscreen change or does the quantity of sunscreen demanded change? A. The quantity...
-
Consider a second-order ODE representing a forced vibrating system: + 8y +2y=k cos(x) y(0) = 0, y(0) = 1 a. Use MATLAB in order to obtain the analytical solution y(t) for the above differential...
-
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...
-
An analysis of the accounts of Beautiful Bottles Pty Ltd reveals the following manufacturing cost data for the month ended 30 June 2019. Required (a) Prepare the cost of goods manufactured schedule...
-
The following accounts and amounts (balances are normal balances) were taken from the records of Prider Manufacturers Ltd at 30 June 2019. Required (a) Prepare a cost of goods manufactured statement...
-
The following data were taken from the records of Manik Manufacturing Ltd for the year ended 30 June 2019. Required (a) Prepare the cost of goods manufactured schedule for the year ended 30 June...
Study smarter with the SolutionInn App