Question: Using the sensitivity report below, answer the following question: The seller was able to acquire 10 pounds of cheese for $5. How much additional profit
Using the sensitivity report below, answer the following question:
Using the sensitivity report below, answer the following question: The seller was able to acquire 10 pounds of cheese for $5. How much additional profit can she earn at most? Adjustable Cells Cell Name $B$2 # of Apple Pie $C$2 # of Turnovers $D$2 # of Cheesecake Final Value 5.66 35.25 4 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 0 6 5.87 3.25 0 0.75 0.89 0.55 0 8 1E+30 3.860759494 Constraints Final Value Cell Name $E$8 Apple Total $E$9 Flour Total $E$10 Sugar Total $E$11 Cheese Total $E$12 Other Limits Total 16.81 5.7 200 15 35.25 Shadow Price 0 6.17 0.21 1.03 Constraint Allowable R.H. Side Increase 20.83 1E+30 5.7 2.67 200 63.534 15 32.24 8 27.25 Allowable Decrease 4.02 2.98 71.77 13.60 1E+30 0 O $1.03 $5.30 O $32.24 $6.17 O $0.00
The seller was able to acquire 10 pounds of cheese for $5. How much additional profit can she earn at most?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
