Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started