Reference no: EM132075834

Sensitivity Report Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Optimal Values Small 3 0 600 400 1E+30 $C$4 Optimal Values Medium 3 0 750 250 1E+30 $D$4 Optimal Values Large 44 0 1000 1E+30 250 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$8 Square footage 48200 0 100000 1E+30 51800 $E$9 Minimum no. of small 3 -400 3 41 3 $E$10 Minimum no. of medium 3 -250 3 41 3 $E$11 Minimum no. of large 44 0 3 41 1E+30 $E$12 Total no. of offices 50 1000 50 51.8 41 How many small and large offices should the developer build? What is the total optimal monthly revenue? If the developer implements the optimal solution, what amount of square footage would remain unused? What is the impact on the optimal allocation of offices and the objective function value if small offices can be rented for $800 per month rather than $600 per month? What impact would an increase in 52,800 sq. ft of additional footage have on the optimal objective function value? What impact will an increase in the monthly rental of small offices to $650 and simultaneous decrease to $800 in the monthly rental of large offices have on the current optimal solution and the objective function value?