Question: Using the sensitivity report below, answer the following question: The seller can aquire 3 additonal pounds of flour for $10. How much additional profit can
Using the sensitivity report below, answer the following question:
Using the sensitivity report below, answer the following question: The seller can acquire 3 additional pounds of flour for $10. How much additional profit can she earn? Adjustable Cells Final Value Cell Name $B$2 # of Apple Pie $C$2 # of Turnovers $D$2 # of Cheesecake 5.66 35.25 Reduced Cost 0 0 0 Objective Allowable Allowable Coefficient Increase Decrease 6 5.87 3.25 0.75 0.89 0.55 8 1E+30 3.860759494 4 Constraints Final Value Shadow Price 0 6.17 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 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 1E30 0.21 1.03 0 $8.51 $0.00 $2.34 $12.34 $6.17
The seller can aquire 3 additonal pounds of flour for $10. How much additional profit can she earn?
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
