4 1000E030 D9 exposure Kanata E030 03 Sun ads TV ads

4 1000e030 d9 exposure kanata e030 03 sun ads tv ads

This preview shows page 8 - 11 out of 14 pages.

0.4 1.000E+030 $D$9 exposure Kanata LHS 0.6 30833.333333 0.6 1.000E+030 0.3
Image of page 8
Sun ads TV ads Solution 20 0 Total Min cost $ 925.00 $ 2,000.00 $ 18,500.00 Constraints LHS Signs RHS exposure city core 0.04 0.05 0.8 >= 0.4 exposure Kanata 0.03 0.03 0.6 >= 0.6
Image of page 9
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Week_5_Sensitivity Analysis Practice.xlsx]Sheet14 Report Created: 8/25/2015 2:44:46 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 Solution XR1 2400 0 10 5 1 $C$3 Solution XR2 2500 0 10 1 1.000E+030 $D$3 Solution XR3 2700 0 10 4 1.000E+030 $E$3 Solution XR4 2700 0 10 5 1.000E+030 $F$3 Solution XR5 2700 0 10 5 1.000E+030 $G$3 Solution XR6 2550 0 10 5 1.000E+030 $H$3 Solution XO1 0 5 15 1.000E+030 5 $I$3 Solution XO2 0 5 15 1.000E+030 5 $J$3 Solution XO3 0 1 15 1.000E+030 1 $K$3 Solution XO4 0 0 15 1 1 $L$3 Solution XO5 500 0 15 1 5 $M$3 Solution XO6 0 5 15 1.000E+030 5 $N$3 Solution XINV1 0 1 1 1.000E+030 1 $O$3 Solution XINV2 300 0 1 3 1.000E+030 $P$3 Solution XINV3 300 0 1 3 1 $Q$3 Solution XINV4 0 1 1 1.000E+030 1 $R$3 Solution XINV5 0 6 1 1.000E+030 6 $S$3 Solution XINV6 150 0 1 1.000E+030 1.000E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $T$14 Regular time max month 1 LHS 2400 0 2700 1.000E+030 300 $T$15 Regular time max month 2 LHS 2500 0 2700 1.000E+030 200 $T$16 Regular time max month 3 LHS 2700 -4 2700 0 300 $T$17 Regular time max month 4 LHS 2700 -5 2700 0 540 $T$18 Regular time max month 5 LHS 2700 -5 2700 500 40 $T$19 Regular time max month 6 LHS 2550 0 2700 1.000E+030 150 $T$20 Overtime max month 1 LHS 0 0 540 1.000E+030 540 $T$21 Overtime max month 2 LHS 0 0 540 1.000E+030 540 $T$22 Overtime max month 3 LHS 0 0 540 1.000E+030 540 $T$23 Overtime max month 4 LHS 0 0 540 1.000E+030 540 $T$24 Overtime max month 5 LHS 500 0 540 1.000E+030
Image of page 10
Image of page 11

You've reached the end of your free preview.

Want to read all 14 pages?

  • Summer '17
  • Jasmin Manseau
  • Harshad number, LHS, 3rd millennium, R.H. Side

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture