Assig BB207 - Microsoft Excel 15.0 Sensitivity Report Worksheet[Assignment BB207 Management Science]Question 1 Report Created 6:02:24 PM Variable Cells

Assig BB207 - Microsoft Excel 15.0 Sensitivity Report...

This preview shows page 1 - 4 out of 6 pages.

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
Background image
X = units of French Provincial model' CabinetY = units of Danish Moderm model' CabinetVariablesXYNumber of produce6090ProfitObjective function28253930ContraintsLHS RHSContraint 132360360Contraint 21.51180200Contraint 30.750.75112.5125Contraint 416060Contraint 519060X , Y0
Background image
Microsoft Excel 15.0 Sensitivity ReportWorksheet: [Assignment BB207 Management Science.xlsx]Question 2Report Created: 20/6/2016 6:14:24 PMVariable Cells
Background image
Image of page 4

You've reached the end of your free preview.

Want to read all 6 pages?

  • Summer '19
  • Constraint satisfaction, R.H. Side, Contraint

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture