Question: 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

Use the following problem statement to answer
Use the following problem statement to answer
Use the following problem statement to answer
Use the following problem statement to answer
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. Variable Cells XI no. of sausage biscuits Final X2=no. of ham biscuits Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease Cell Value 0 -40 20 40 1E+30 Max Z=20X1 + 60X2 10 0 60 1E+30 40 C1: X1 + 2X2 40. Sausage (lb.) C2: 4X1 +4X2 84. Ham (lb.) Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease C3: 2X1 + X2 50. Flour (lb.) 20 0 40 1E+30 C4: X1 + X2 10. Labor 0 84 1E+30 (hr.) 50 1E+30 C5: X1, X220 10 10 $B$3 $C$3 Constraints Cell $M$6 $M$7 SMS8 $M$9 Name X1 X2 Name C1 2002 C3 C4 Final Value 2929 40 10 10 0 60 2499 20 44 40 10 W Which additional resources would you recommend that Gale try to obtain? O ham O labor Question 2 8 pts A local supplier offers to sell Gale 9 pounds of sausage for $0.70 per pound (see C1). What should he do? O refuse to buy any sausage O buy 9 pounds for $0.70 per pound Question 3 8 pts Gale thinks that the profit contribution of Product 1 is too low to make profit. By how much would the profit contribution of Product 1 have to change to make it worthwhile to produce Product 1? 00 O 40 Question 4 8 pts If he can obtain additional flour and labor, but not both, which one should he select? flour O labor D Question 5 8 pts By how much would total profit increase if he could obtain additional two hours of labor in C4? O 10 O 120 Question 6 8 pts By how much would total profit increase if he could increase the amount of ham from 84 to 90 pounds? 00 O 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!