Assig BB207 - Microsoft Excel 15.0 Sensitivity Report...

Microsoft Excel 15.0 Sensitivity Report
Worksheet: [Assignment BB207 Management Science.xlsx]Question 1
Report Created: 20/6/2016 6:02:24 PM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$5 Number of produce X 60 0 28 9.5 1.00000E+030
$C$5 Number of produce Y 90 0 25 1.00000E+030 6.3333333333
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$D$12 Contraint 4 LHS 60 -9.5 60 20 33.333333333
$D$13 Contraint 5 LHS 90 0 60 30 1.00000E+030
$D$9 Contraint 1 LHS 360 12.5 360 33.333333333 60
$D$10 Contraint 2 LHS 180 0 200 1.00000E+030 20
$D$11 Contraint 3 LHS 112.5 0 125 1.00000E+030 12.5

X = units of French Provincial model' Cabinet
Y = units of Danish Moderm model' Cabinet
Variables X Y
Number of produce 60 90 Profit
Objective function 28 25 3930
Contraints LHS RHS
Contraint 1 3 2 360 ≤ 360
Contraint 2 1.5 1 180 ≤ 200
Contraint 3 0.75 0.75 112.5 ≤ 125
Contraint 4 1 60 ≥ 60
Contraint 5 1 90 ≥ 60
X , Y ≥ 0

Microsoft Excel 15.0 Sensitivity Report
Worksheet: [Assignment BB207 Management Science.xlsx]Question 2
Report Created: 20/6/2016 6:14:24 PM
Variable Cells