B1B2B3N1N2N3
<= 30
and
border
31-50
and
border
>= 51
and
border
<= 30
and not
border
31-50
and not
border
>= 51
and not
border
<= 30 households 1 1 1000.00 >= 1000
31-50 households 1 1 600.00 >= 600
Management Science Associates
Problem 4-14. Management Science Associates
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$5 Number of households <= 30 and border 0.00 0.60 7.50 1E+30 0.60
$C$5 Number of households 31-50 and border 600.00 0.00 6.80 0.45 0.82
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$H$8 Total households 2300.00 5.98 2300.00 1E+30 700.00
Microsoft Excel 14.0 Sensitivity Report