Question 2 The Hot Dawg Company (HDC) must determine the quantities of beef, chicken, and lamb...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 2 The Hot Dawg Company (HDC) must determine the quantities of beef, chicken, and lamb to use in blending 100 pounds of its Super Sausage. In blending the Super Sausage, HDC must meet the following four product requirements: 1. The percentage of the sausage's weight that is protein must be at least 12%. 2. The percentage of the sausage's weight that is fat must be at most 24%. 3. The percentage of the sausage's weight that is water must be at most 64%. 4. The percentage of the sausage's weight that is lamb must be at least 30%. The table below provides the composition and cost per pound of each type of meat. Beef Chicken Lamb 20 15 15 20 15 25 Percent protein Percent fat Percent water Cost per pound 60 70 60 $1.00 $0.50 $0.70 Assume that spices and casings contribute an insignificant amount to the total sausage weight and that unlimited quantities of beef, chicken, and lamb are available to HDC at the indicated costs. Let x, xc and x, denote the respective pounds of beef, chicken and lamb used to blend the 100 pounds of Super Sausage. The LP formulation for determining the blend that satisfies HDC's product requirements at minimum cost is as follows. Minimize XB +0.5xc +0.7x₁ subject to XB + Xc + x₁ = 100 0.2x +0.15xc +0.15x₁ 212 0.2x +0.15xc +0.25x, ≤24 0.6x +0.7x +0.6.x, ≤ 64 x₁ ≥ 30 XB XC , X₁ 20 (1) You are required to input the LP formation into Excel, and use Excel Solver to solve the problem. In your answer, please print out and attach the Formulation at the optimal solution, Answer Report, and Sensitivity Report, similar to those in the lecture notes. (16 marks) Parts (ii) - (vii) below request you to use the computer output in part (i) to analyse the effect of a change in a decision variable's objective function coefficient or a structural constraint's right-hand side. Regard each part as independent of the other parts. In some parts, the computer output may provide insufficient information to allow you to answer, in which case you should state "Insufficient information!" (ii) Write down the optimal values of the decision variables and the minimum total cost. (4 marks) (iii) If the cost per pound of lamb increases from $0.70 to $0.95, what are the optimal values of the decision variables and the minimum total cost? (6 marks) (iv) If the cost per pound of beef decreases from $1.00 to $0.65, what are the optimal values of the decision variables and the minimum total cost? (6 marks) (v) If the maximum fat content decreases from 24% to 20%, what is the minimum total cost? (6 marks) (vi) If the maximum water content decreases from 64% to 62%, what is the minimum total cost? (6 marks) (vii) If HDC must blend 90 pounds of Super Sausage instead of 100 pounds, what is the minimum total cost? (6 marks) Question 2 The Hot Dawg Company (HDC) must determine the quantities of beef, chicken, and lamb to use in blending 100 pounds of its Super Sausage. In blending the Super Sausage, HDC must meet the following four product requirements: 1. The percentage of the sausage's weight that is protein must be at least 12%. 2. The percentage of the sausage's weight that is fat must be at most 24%. 3. The percentage of the sausage's weight that is water must be at most 64%. 4. The percentage of the sausage's weight that is lamb must be at least 30%. The table below provides the composition and cost per pound of each type of meat. Beef Chicken Lamb 20 15 15 20 15 25 Percent protein Percent fat Percent water Cost per pound 60 70 60 $1.00 $0.50 $0.70 Assume that spices and casings contribute an insignificant amount to the total sausage weight and that unlimited quantities of beef, chicken, and lamb are available to HDC at the indicated costs. Let x, xc and x, denote the respective pounds of beef, chicken and lamb used to blend the 100 pounds of Super Sausage. The LP formulation for determining the blend that satisfies HDC's product requirements at minimum cost is as follows. Minimize XB +0.5xc +0.7x₁ subject to XB + Xc + x₁ = 100 0.2x +0.15xc +0.15x₁ 212 0.2x +0.15xc +0.25x, ≤24 0.6x +0.7x +0.6.x, ≤ 64 x₁ ≥ 30 XB XC , X₁ 20 (1) You are required to input the LP formation into Excel, and use Excel Solver to solve the problem. In your answer, please print out and attach the Formulation at the optimal solution, Answer Report, and Sensitivity Report, similar to those in the lecture notes. (16 marks) Parts (ii) - (vii) below request you to use the computer output in part (i) to analyse the effect of a change in a decision variable's objective function coefficient or a structural constraint's right-hand side. Regard each part as independent of the other parts. In some parts, the computer output may provide insufficient information to allow you to answer, in which case you should state "Insufficient information!" (ii) Write down the optimal values of the decision variables and the minimum total cost. (4 marks) (iii) If the cost per pound of lamb increases from $0.70 to $0.95, what are the optimal values of the decision variables and the minimum total cost? (6 marks) (iv) If the cost per pound of beef decreases from $1.00 to $0.65, what are the optimal values of the decision variables and the minimum total cost? (6 marks) (v) If the maximum fat content decreases from 24% to 20%, what is the minimum total cost? (6 marks) (vi) If the maximum water content decreases from 64% to 62%, what is the minimum total cost? (6 marks) (vii) If HDC must blend 90 pounds of Super Sausage instead of 100 pounds, what is the minimum total cost? (6 marks)
Expert Answer:
Related Book For
Mathematical Applications for the Management Life and Social Sciences
ISBN: 978-1305108042
11th edition
Authors: Ronald J. Harshbarger, James J. Reynolds
Posted Date:
Students also viewed these general management questions
-
Water at 70 F, 15 lbf/in.2, is brought to 30 lbf/in.2, 2700 F. Find the change in the specific internal energy, using the water table and the ideal gas water table in combination.
-
Water at 70 F, 15 lbf/in 2, is brought to 30 lbf/in 2, 2700 F. Find the change in the specific internal energy, using the water table and the ideal gas water table in combination.
-
Product X is produced for $24 per pound including a $9 per pound fixed cost. Product X can be sold without additional processing for $30 per pound, or processed further into Product Y at an...
-
Find a PTLU factorization of the given matrix A. (Enter each matrix in the form [[row 1], [row 2],...], where each row is a comma-separated list.) 0 1 2 -1 4 1 1 3 3 A =
-
If a company has sales of $10 million, a gross profit percentage of 35%, and days in inventory of 110, could you estimate its average inventory? Show your calculations.
-
Use depth-first search to find a spanning tree of each of these graphs. a) W6 (see Example 7 of Section 10.2), starting at the vertex of degree 6 b) K5 c) K3,4, starting at a vertex of degree 3 d) Q3
-
On December 31, Casper, Inc., issued \(\$ 300,000\) of eight percent, ten-year bonds for \(\$ 262,613\), yielding an effective interest rate of ten percent. Semiannual interest is payable on June 30...
-
Following are financial statement information for Welmark Corporation as of Year 2 and Year 3. Required: Using the residual income model, prepare a valuation of the common stock of Welmark...
-
The LIFO Inventory Reserve Waterloo Manufacturing Company uses the LIFO inventory costing method to value its ending inventory The following data were obtained from the company's accounting records...
-
The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $82.60 on December 31, 20Y2. Question not attempted. Determine the following...
-
5. You and two of your friends compete to see who can answers questions in a quiz game the quickest. Throughout, assume that the time it takes you T and times it takes each of your friends T2, T3 to...
-
Several ways of adapting existing columns to new uses were listed. Generate new methods that might allow existing systems to meet product specifications that could not be met without modification....
-
State the null and alternative hypotheses. a. H0: __________ b. Ha: __________ The U.S. Center for Disease Control reports that the mean life expectancy was 47.6 years for whites born in 1900 and...
-
Which distribution (normal or Student's t) would you use for this hypothesis test? In the recent Census, three percent of the U.S. population reported being of two or more races. However, the percent...
-
What is the random variable of interest for this test? In the recent Census, three percent of the U.S. population reported being of two or more races. However, the percent varies tremendously from...
-
This is: a. a test of two proportions b. a test of two independent means c. a test of a single mean d. a test of matched pairs. Neuroinvasive West Nile virus is a severe disease that affects a...
-
The economic question of what will be produced is O a. primarily answered by markets in a command economy O b. does not have to be answered by economies possessing great wealth O c. cannot be...
-
In your audit of Garza Company, you find that a physical inventory on December 31, 2012, showed merchandise with a cost of $441,000 was on hand at that date. You also discover the following items...
-
Find the sum of the first 200 terms of the arithmetic sequence 12, 9, 6, . . . .?
-
(a) If the total revenue function for a hammer is R=36x-0.01x2, then sale of how many hammers, x, will maximize the total revenue in dollars? Find the maximum revenue. (b) Find the maximum revenue if...
-
Since 1950 the U.S. workforce has seen the arrival of the Baby Boomers and the changing role of women, among other influences. The data in the table show the millions of men and women in the U.S....
-
Which of the following statements is true? a. Encrypting data is sufficient to protect confidentiality and privacy. b. Cookies are text files that only store information and cannot do anything. c. A...
-
Which of the following is designed to identify entry of a nonexistent customer account number? a. sequence check c. completeness check b. field check d. validity check
-
A batch total that is calculated by summing the part numbers sold in a batch of 50 sales invoices is called a a. financial total c. record count b. hash total d. part count
Study smarter with the SolutionInn App