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

Using the sensitivity report below, answer the

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 11 Cell Name $B$2 # of Apple Pie $C$2 # of Turnovers $D$2 # of Cheesecake Constraints Cell Name $E$8 Apple Total $E$9 Flour Total $E$10 Sugar Total $E$11 Cheese Total $E$12 Other Limits Total $12.34 $6.17 $2.34 $8.51 $0.00 Final Value 5.66 35.25 4 Final Value 16.81 5.7 200 15 35.25 Reduced Objective Allowable Allowable Coefficient Increase Decrease Cost Shadow Price 0 0 0 0 6.17 0.21 1.03 0 6 0.75 8 5.87 0.89 1E+30 3.860759494 Constraint Allowable R.H. Side Increase 20.83 5.7 200 15 8 1E+30 2.67 3.25 0.55 63.534 32.24 27.25 Allowable Decrease 4.02 2.98 71.77 13.60 1E+30

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!