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...
-
The beginning balance sheet of Desk Source Co. included an $850,000 investment in Parson stock (20% ownership). During the year, Desk Source completed the following investment transactions: Mar. 3...
-
YUX Corporation sells a single product for $50. Its management estimates the following revenues and costs for the year 2016: Instructions (a) Assuming fixed costs and net sales are spread evenly...
-
How a user conceptually organizes and understands data is referred to as the a. physical view c. data model view b. logical view d. data organization view
-
Billings Company produces two products, Product Reno and Product Tahoe. Each product goes through its own assembly and finishing departments. However, both of them must go through the painting...
-
7 15 points Exercise 9-2 (Algo) Prepare a Report Showing Revenue and Spending Variances [LO9-2] Quilcene Oysteria farms and sells oysters in the Pacific Northwest. The company harvested and sold...
-
Here are some diagnostic plots for the final exam data from Exercise 13. These were generated by a computer package and may look different from the plots generated by the packages you use. (In...
-
You are a trader who entered a short position in BAB futures when their price was 91.57. Market prices have since changed to 91.61 and you have decided to close out your position. Calculate your...
-
Johnson Inc.s non - strategic investment portfolio at December 3 1 , 2 0 1 9 , consisted of the following: Debt and Equity Investments * Cost Fair Value 1 0 , 0 0 0 Xavier Corp. common shares $ 1 6 3...
-
Jaguar Plastics Company has been operating for three years. At December 31 of last year, the accounting records reflected the following: Cash $27,000 Accounts payable $18,000 Investments (short-term)...
-
Many times, performance management systems are linked to compensation. List three reasons why they should be linked and three reasons why they shouldn't be linked. As an employee, which do you...
-
I think the public can contribute to creating performance-based budgets, but how much they can participate depends on the government's structure and rules. Citizen involvement can greatly impact...
-
The following unadjusted trial balance is prepared at fiscal year - end for Nelson Company. Nelson Company uses a perpetual inventory system. It categorizes the following accounts as selling...
-
A recent article in a reputable journal states that that 39% of the consumer scam complaints by citizens of a certain country are about identity theft. Suppose a random sample of 100 complaints is...
-
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...
-
Let \(\mathbf{P}\) be a projection matrix. Show that the diagonal elements of \(\mathbf{P}\) all lie in the interval \([0,1]\). In particular, for \(\mathbf{P}=\mathbf{X X}^{+}\)in Theorem 5.1, the...
-
Consider the linear model \(\boldsymbol{Y}=\mathbf{X} \boldsymbol{\beta}+\varepsilon\) in (5.8), with \(\mathbf{X}\) being the \(n \times p\) model matrix and \(\boldsymbol{\varepsilon}\) having...
-
Using the notation from Exercises 11-13, Cook's distance for observation \(i\) is defined as \[ D_{i}:=\frac{\widehat{\boldsymbol{Y}}-\widehat{\boldsymbol{Y}}^{(i)^{2}}}{p S^{2}} \] It measures the...
Study smarter with the SolutionInn App