Use the spreadsheet and Solver sensitivity report to answer these questions. 
a.What is the cell formula for B12?
b.What is the cell formula for C12?
c.What is the cell formula for D12?
d.What is the cell formula for B15?
e.What is the cell formula for B16?f. What is the cell formula for B17?g. What is the optimal value for x1?h. What is the optimal value for x2?i. Would you pay $.50 each for up to 60 more units of resource 1?j. Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver? 
Correct Answer:
Verified
b.=C8*C11
c.=B12+C12...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q2: Output from a computer package is precise
Q2: There is a dual price for every
Q42: Excel's Solver tool has been used
Q45: LINGO output is given for the
Q46: Use the following Management Scientist output
Q47: The LP model and LINGO output
Q49: How would sensitivity analysis of a linear
Q49: The following linear programming problem has
Q51: Explain the two interpretations of dual prices
Q56: Explain the connection between reduced costs and
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents