Question: Following is the sensitivity report from a profit maximization Linear Programming problem in Excel. A firm produces two products P1 and P2. Each of these

Following is the sensitivity report from a profit maximization Linear Programming problem in Excel. A firm produces two products P1 and P2. Each of these two products requires three resources R1, R2 and R3 for its production. Answer the following questions based on the sensitivity report. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $K$7 P1 0 -1.5 2 1.5 1E+30 $K$8 P2 500 0 7 1E+30 3 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$9 R1 1000 3.5 1000 133.3333333 1000 $G$9 R2 500 0 1500 1E+30 1000 $H$9 R3 1500 0 1700 1E+30 200 1) The optimal profit is . (Enter the numerical value in the blank. Don't include any space or text) 2) The objective coefficient for product P1 should be greater than for it to be profitable enough for non-zero production at optimality
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
