412-busSked

# 412-busSked - Microsoft Excel 11.3 Answer Report...

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

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

View Full Document

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

View Full Document

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.

Unformatted text preview: 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 \$E\$4 #drivers Thu-Mon 4 4 \$F\$4 #drivers Fri-Tue 1 \$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 \$I\$8 Tue need Actual 27 \$I\$8>=\$K\$8 Not Binding 1 \$I\$9 Wed need Actual 27 \$I\$9>=\$K\$9 Binding \$I\$10 Thu need Actual 26 \$I\$10>=\$K\$10 Binding \$I\$11 Fri need Actual 22 \$I\$11>=\$K\$11 Binding \$I\$12 Sat need Actual 16 \$I\$12>=\$K\$12 Binding \$I\$13 Sun need Actual 13 \$I\$13>=\$K\$13 Not Binding 1 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 1 0.5 \$C\$4 #drivers Tue-Sat 7 1 1 \$D\$4 #drivers Wed-Sun 1 ### \$E\$4 #drivers Thu-Mon 4 1 0.5 1 \$F\$4 #drivers Fri-Tue 0.33 1 ### 0.33 \$G\$4 #drivers Sat-Wed 5 1 0.5 1 \$H\$4 #drivers Sun-Thu 4 1 0.33 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$I\$7 Mon need Actual 24 0.33 24 10.5 1.5 \$I\$8 Tue need Actual 27 26 1 1.00E+030 \$I\$9 Wed need Actual 27 0.33 27 3 1 \$I\$10 Thu need Actual 26 0.33 26 7.5 1.5 \$I\$11 Fri need Actual 22 22 1 11 \$I\$12 Sat need Actual 16 0.33 16 16.5 1.5 \$I\$13 Sun need Actual 13 12 1 1.00E+030 Bus staffing Decision VariaMon-Fri Tue-Sat Wed-SunThu-Mon Fri-Tue Sat-Wed Sun-Thu Total #drivers 11 7 4 5 4 31 Constraint 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 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 7 \$D\$4 #drivers Wed-Sun \$E\$4 #drivers Thu-Mon 4 \$F\$4 #drivers Fri-Tue \$G\$4 #drivers Sat-Wed 16 5 \$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 \$I\$13 Tue need Actual 27 \$I\$13>=\$K\$13 Not Binding 1 \$I\$14 Wed need Actual 27 \$I\$14>=\$K\$14 Binding \$I\$15 Thu need Actual 26 \$I\$15>=\$K\$15 Binding \$I\$16 Fri need Actual 23 \$I\$16>=\$K\$16 Not Binding 1 \$I\$17 Sat need Actual 16 \$I\$17>=\$K\$17 Binding \$I\$18 Sun need Actual 12 \$I\$18>=\$K\$18 Binding Microsoft Excel 11.3 Sensitivity Report Worksheet: [412-busSked.xls]Weekwage changeWorksheet: [412-busSked....
View Full Document

## This note was uploaded on 04/14/2008 for the course DS 412 taught by Professor Eng during the Fall '07 term at S.F. State.

### Page1 / 19

412-busSked - Microsoft Excel 11.3 Answer Report...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online