412-busSked

412-busSked - Microsoft Excel 11.3 Answer Report Worksheet:

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
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

Page1 / 19

412-busSked - Microsoft Excel 11.3 Answer Report Worksheet:

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online