Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please Provide the solutions to the following questions. This is all a single question with sub questions mentioned. Let us call the first constraint portfolio
Please Provide the solutions to the following questions. This is all a single question with sub questions mentioned.
Let us call the first constraint portfolio constraint 1 (PC1) and the second constraint portfolio constraint 2 (PC2)
Here is the sensitivity report (with some cells deleted). Answer the following questions based on the information given in the sensitivity report. The following questions should be answered based on the given sensitivity report alone. You are not expected to re-run Solver to answer these questions.
Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $G$33 x1 8.0 500.0 1.00E+30 15.4 $H$33 x2 1.5 450.0 33.3 75.0 $1$33 x3 0.5 600.0 33.3 1050.0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $J$36 Production 60.0 80.8 60.0 14.7 7.0 $J$37 Storage 116.2 0.0 150.0 1.00E+30 33.8 $J$38 Demand 8.0 15.4 8.0 1.2 8.0 $J$39 PC1 46.2 1.0 1.4 2.0 $J$40 PC2 0.0 1.0 1.00E+30 2.0Step 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