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

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

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 Mathematics Questions!