Question: Use the solved linear program in Excel and the associated sensitivity report to answer the questions below. R 40000 Total RHS P 10000 Decision Variables

Use the solved linear program in Excel and the associated sensitivity report to answer the questions below. R 40000 Total RHS P 10000 Decision Variables Contribution 30 50 1,700,000 30 60 1,800,000 1,800,000 Constraint 1 Constraint 2 Constraint 3 1 1 50,000 50,000 1 10,000 20,000 Adjustable Cells Reduced Cost Cell Name $C$3 Decision Variables R $D$3 Decision Variables P Final Value 40000 10000 Objective Allowable Allowable Coefficient Increase Decrease 30 20 5 50 10 20 0 0 Constraints Cell Name $E$6 Constraint 1 Total $E$7 Constraint 2 Total $E$8 Constraint 3 Total Final Value 1800000 50000 10000 Shadow Price 0.666666667 10 0 Constraint Allowable Allowable R.H. Side Increase Decrease 1800000 300000 300000 50000 10000 10000 20000 infinity 10000 Note: All of the constraints are "less than or equal to constraints".
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
