Question

The landlord ran the model in Excel and received the sensitivity report for the constraints as contained in the table. Which of the following statements is correct?


FinalShadowConstraintAllowableAllowable
CellNameValuePriceR.H. SideIncreaseDecrease
$B$12Total Time Weeks4.0013.6441.13.1E-16
$E$10Total Cost3000.000.0130005503.1E-13
$I$4wood floors Included?1.0067.2711.27E-164.6E-01
$I$5kitchen tile Included?1.0025.4517.63E-172.8E-01
$I$6back door Included?0.000.0011.00E+301.0E+00
$I$7garage door opener Included?1.0011.8215.09E-161.0E+00

A) If there are 2 more weeks available for work, it would be possible to increase rent by $27.28 per week
B) Given the scenario, it is evident that a constraint is missing.
C) If the landlord installed two garage doors, rent could be increased by $23.64.
D) Given the scenario, it is evident that the objective function is misstated.

Answer

This answer is hidden. It contains 1 characters.