Question: Question 1 Use the following problem statement to answer questions 1-6. Gale wants to determine the values of X1 and X2 to maximize total profit.

Question 1 Use the following problem statement to answer questions 1-6. Gale wants to determine the values of X1 and X2 to maximize total profit. The two types of biscuits require the following resources: sausage, ham, flour, and labor. The linear model and the sensitivity report are given as below. Round to two decimal places. X1 = = no. of sausage biscuits X2= no. of ham biscuits Max Z = 99X1 + 6X2 C1: 12X1 + 6X2 80. Sausage (lb.) C2: 2X1 + 6X2 20. Ham (lb.) C3: X1 +6. Flour (lb.) C4: 3X1 + 3X2 9. flour Final Reduced Objective Cell Name Value Cost Coefficient $B$3 X1 $C$3 X2 labor 3 0 Final Cell Name Value $M$6 C1 $M$7 C2 $M$8 C3 $M$9 C4 36 6 3 9 0 -93 99 6 Shadow Constraint Price R.H. Side 0 0 0 33 80 20 6 9 Allowable Allowable Increase Decrease 1E+30 93 Allowable Increase Labor (hr.) C5: X1, X2 20 If he can obtain additional flour and labor hour, but not both, which one should he select? 4 pts 1E+30 1E+30 1E+30 9 93 1E+30 Allowable Decrease 44 14 3 9
 Question 1 Use the following problem statement to answer questions 1-6.
Gale wants to determine the values of X1 and X2 to maximize
total profit. The two types of biscuits require the following resources: sausage,

Use the following problem statement to answer questions 1-6. Gale wants to determine the values of X1 and X2 to maximize total profit. The two types of biscuits require the following resources: sausage, ham, flour, and labor. The linear model and the sensitivity report are given as below. Round to two decimal places. If he can obtain additional flour and labor hour, but not both, which one should he select? nour labor Gale thinks that the profit contribution of Product 2 is too low to make profit. By how much would the profit contribution of Product 2 have to change to make it worthwhile to produce the product? 10 25 93 Question 6 4 pts A local supplier offers to sell Gale 100 pounds of flour for $2 per pound. What should he do? refuse to buy any flour buy 100 pounds of flour for $2 per pound By how much would total profit increase if he could obtain additional two hours of labor in C4? 0 66 Question 3 4 pts By how much would total profit increase if he could increase the number of labor hours from 9 to 14 in C4 ? 35 165 Question 4 4 pts By how much would total profit increase if he could increase the amount of ham from 20 to 30 pounds in C2 ? 0 100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!