{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

412LP-BusSked

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

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

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

View Full Document
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
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

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

View Full Document
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
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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}