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 =
-
Describe the filing deadline for Form 10-K.
-
"Time decay is greatest for an option close to expiration." Use the spreadsheet functions to evaluate this statement. Consider both the dollar change in the option value and the percentage change in...
-
Material price and quantity variances The BanULaura Company uses three materials in the production of aquariums and terrariums. Actual output is 680 units. Material standards and actual results are...
-
Spencer Kars provides shuttle service between four hotels near a medical center and an international airport. Spencer Kars uses two 10-passenger vans to offer 12 round trips per day. A recent month's...
-
Help please 2. Let q = f(p) be the number of skateboards sold at the price p (in $). Suppose we know that we sell 10,000 skateboards when the price is $140, and suppose f'(140) = 100. a) If R is the...
-
You have five 1.5 V cells. How would you connect all five of them to give an e.m.f. of: a. 7.5 V b. 1.5 V c. 4.5 V?
-
Bronco Company uses normal costing in its job-costing system. The company produces custom bikes for toddlers. The beginning balances (December 1) and ending balances (as of December 30) in their...
-
A plane wall 10 cm thick generates heat at the rate of 4x104 W/m3 when an electric current is passed through it. The convective H.T.C between each face of wall and ambient air is 50 W/m2k. Determine...
-
1. Develop 3 sigma level process control charts for monitoring weight of boxes that contain apples. You performed samplings over 5 weeks with sample size of 4 (n = 4). Draw variable control charts...
-
Describe the phenomenon of chromosomal aneuploidy and its potential impact on embryonic development and human disease. What are the molecular origins of nondisjunction events, and how do they relate...
-
Describe the function and features of CPUs Identify features of popular CPUs from various manufacturers List the basic functions common to all file systems Use and describe the file systems used by...
-
Daniel's employer, Rainy Days Inc, a retirement planning company, provides him with a moving allowance of $10,000. His marginal tax rate is 32 percent. Answer the following questions relating to this...
-
K 7 A ladder is leaning against a vertical wall The ladder is 15 feet long and the angle between the ladder and the ground is 60 degrees Find the height at which the ladder touches the wall SRCATO...
-
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....
-
Effects of Darden Restaurants Changes in Current Assets and Liabilities on Its Statement of Cash Flows The following items, listed in alphabetical order, are included in the Current Liabilities...
-
Using data from the stockholders equity section of Soong Corporations balance sheet shown below, compute the book value per share for both the preferred and the common stock. Contributed capital...
-
On August 10, the board of directors of Perlman International declared a 3-for-1 stock split of its $9 par value common stock, of which 400,000 shares were authorized and 125,000 were issued and...
Study smarter with the SolutionInn App