412LP-BusSked

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 DocumentRight 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 VariaMon-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 DocumentRight 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
Background image of page 5

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

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

This note was uploaded on 10/19/2011 for the course DS 412 taught by Professor Eng during the Spring '07 term at S.F. State.

Page1 / 16

412LP-BusSked - MicrosoftExcel11.3AnswerReport

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