Essay
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
a.=B8*B11
b.=C8*C11
c.=B12+C12...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
b.=C8*C11
c.=B12+C12...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q17: To solve a linear programming problem with
Q25: For a minimization problem,a positive dual price
Q33: Decision variables must be clearly defined before
Q34: A negative dual price indicates that increasing
Q36: In a linear programming problem,the binding constraints
Q40: Excel's Solver tool has been used
Q43: The dual price measures, per unit increase
Q45: The LP problem whose output follows
Q46: LINGO output is given for the
Q47: The 100% Rule compares<br>A) proposed changes to