Microsoft Excel 15.0 Sensitivity ReportWorksheet: [Assignment BB207 Management Science.xlsx]Question 1Report Created: 20/6/2016 6:02:24 PMVariable CellsFinalReducedObjectiveAllowableAllowableCellNameValueCostCoefficientIncreaseDecrease$B$5Number of produce X600289.5 1.00000E+030$C$5Number of produce Y90025 1.00000E+030 6.3333333333ConstraintsFinalShadowConstraintAllowableAllowableCellNameValuePriceR.H. SideIncreaseDecrease$D$12Contraint 4 LHS 60-9.56020 33.333333333$D$13Contraint 5 LHS 9006030 1.00000E+030$D$9Contraint 1 LHS 36012.5360 33.33333333360$D$10Contraint 2 LHS 1800200 1.00000E+03020$D$11Contraint 3 LHS 112.50125 1.00000E+03012.5
X = units of French Provincial model' CabinetY = units of Danish Moderm model' CabinetVariablesXYNumber of produce6090ProfitObjective function28253930ContraintsLHS RHSContraint 132360≤360Contraint 21.51180≤200Contraint 30.750.75112.5≤125Contraint 4160≥60Contraint 5190≥60X , Y≥0
Microsoft Excel 15.0 Sensitivity ReportWorksheet: [Assignment BB207 Management Science.xlsx]Question 2Report Created: 20/6/2016 6:14:24 PMVariable Cells

You've reached the end of your free preview.
Want to read all 6 pages?
- Summer '19
- Constraint satisfaction, R.H. Side, Contraint