{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

412LP-BusSked - MicrosoftExcel11.3AnswerReport...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Microsoft Excel 11.3 Answer Report Worksheet: [412-BusSked.xls]Original Report Created: 2/16/2008 1:04:44 AM Target Cell (Min) Cell Name Original Value Final Value $I$4 #drivers  Total 30 31 Adjustable Cells Cell Name Original Value Final Value $B$4 #drivers  Mon-Fri 13 11 $C$4 #drivers  Tue-Sat 5 7 $D$4 #drivers  Wed-Sun 5 0 $E$4 #drivers  Thu-Mon 4 4 $F$4 #drivers  Fri-Tue 1 0 $G$4 #drivers  Sat-Wed 1 5 $H$4 #drivers  Sun-Thu 1 4 Constraints Cell Name Cell Value Formula Status Slack $I$7 Mon need Actual 24 $I$7>=$K$7 Binding 0 $I$8 Tue need Actual 27 $I$8>=$K$8 Not Binding 1 $I$9 Wed need Actual 27 $I$9>=$K$9 Binding 0 $I$10 Thu need Actual 26 $I$10>=$K$10 Binding 0 $I$11 Fri need Actual 22 $I$11>=$K$11 Binding 0 $I$12 Sat need Actual 16 $I$12>=$K$12 Binding 0 $I$13 Sun need Actual 13 $I$13>=$K$13 Not Binding 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Microsoft Excel 11.3 Sensitivity Report Worksheet: [412-BusSked.xls]Original Report Created: 2/16/2008 1:04:45 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 #drivers  Mon-Fri 11 0 1 0.5 0 $C$4 #drivers  Tue-Sat 7 0 1 0 1 $D$4 #drivers  Wed-Sun 0 0 1 1.0E+030 0 $E$4 #drivers  Thu-Mon 4 0 1 0.5 1 $F$4 #drivers  Fri-Tue 0 0.333333333 1 1.0E+030 0.333333333 $G$4 #drivers  Sat-Wed 5 0 1 0.5 1 $H$4 #drivers  Sun-Thu 4 0 1 0 0.333333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $I$7 Mon need Actual 24 0.333333333 24 10.5 1.5 $I$8 Tue need Actual 27 0 26 1 1.0000E+030 $I$9 Wed need Actual 27 0.333333333 27 3 1 $I$10 Thu need Actual 26 0.333333333 26 7.5 1.5 $I$11 Fri need Actual 22 0 22 1 11 $I$12 Sat need Actual 16 0.333333333 16 16.5 1.5 $I$13 Sun need Actual 13 0 12 1 1.0000E+030
Background image of page 2
Bus staffing Decision Varia Mon-Fri Tue-Sat Wed-SunThu-Mon Fri-TueSat-Wed Sun-Thu Total #drivers  11 7 0 4 0 5 4 31 Constraints Actual Need Mon need 1 1 1 1 1 24 >= 24 Tue need 1 1 1 1 1 27 >= 26 Wed need 1 1 1 1 1 27 >= 27 Thu need 1 1 1 1 1 26 >= 26 Fri need 1 1 1 1 1 22 >= 22 Sat need 1 1 1 1 1 16 >= 16 Sun need 1 1 1 1 1 13 >= 12
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Microsoft Excel 11.3 Answer Report Worksheet: [412-BusSked.xls]Weekwage change Report Created: 2/16/2008 1:34:21 AM Target Cell (Min) Cell Name Original Value Final Value $I$9 Wages/shift Total 300 225 Adjustable Cells Cell Name Original Value Final Value $B$4 #drivers  Mon-Fri 22 12 $C$4 #drivers  Tue-Sat 0 7 $D$4 #drivers  Wed-Sun 0 0 $E$4 #drivers  Thu-Mon 0 3.9999999999 $F$4 #drivers  Fri-Tue 0 0 $G$4 #drivers  Sat-Wed 16 5.0000000001 $H$4 #drivers  Sun-Thu 4 3 Constraints Cell Name Cell Value Formula Status Slack $I$12 Mon need Actual 24 $I$12>=$K$12 Binding 0 $I$13 Tue need Actual 27 $I$13>=$K$13 Not Binding 1 $I$14 Wed need Actual 27 $I$14>=$K$14 Binding 0 $I$15 Thu need Actual 26 $I$15>=$K$15 Binding 0 $I$16 Fri need Actual 23 $I$16>=$K$16 Not Binding 1 $I$17 Sat need Actual 16 $I$17>=$K$17 Binding 0 $I$18 Sun need Actual 12 $I$18>=$K$18 Binding 0
Background image of page 4
Microsoft Excel 11.3 Sensitivity Report Worksheet: [412-BusSked.xls]Weekwage change Report Created: 2/16/2008 1:34:22 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 #drivers  Mon-Fri 12 0 5 2.5 0 $C$4 #drivers  Tue-Sat 7 0 7.5 0 4.999999999 $D$4 #drivers  Wed-Sun 0 0 10 1.0000E+030 0 $E$4 #drivers  Thu-Mon 4 0 10 2.499999999 5 $F$4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}