4-5 - 5.00 0.00 28.00 0.00 60.00 $G$5 Number of tellers PT...

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

View Full Document Right Arrow Icon
Hong Kong Bank F Number of tellers 10.0 0.0 7.0 2.0 5.0 0.0 Cost $90.00 $28.00 $28.00 $28.00 $28.00 $28.00 $1,292.00 Constraints: 9am-10am needs 1 1 10.0 >= 10 10am-11am needs 1 1 1 17.0 >= 12 11am-Noon needs 0.5 1 1 1 14.0 >= 14 Noon-1pm needs 0.5 1 1 1 1 19.0 >= 16 1pm-2pm needs 1 1 1 1 1 24.0 >= 18 2pm-3pm needs 1 1 1 1 17.0 >= 17 3pm-4pm needs 1 1 1 15.0 >= 15 4pm-5pm needs 1 1 10.0 >= 10 Max full time 1 10.0 <= 12 Part-time limit 4 4 4 4 4 56.0 <= 56 LHS Sign RHS P 1 P 2 P 3 P 4 P 5 FT tellers PT @9am PT @10am PT @11am PT @Noon PT @1pm
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 10.0 Sensitivity Report Worksheet: [4-5.xls]Hong Kong Bank Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of tellers FT tellers 10.00 0.00 90.00 1.00E+030 48.00 $C$5 Number of tellers PT @9am 0.00 0.00 28.00 48.00 0.00 $D$5 Number of tellers PT @10am 7.00 0.00 28.00 0.00 45.00 $E$5 Number of tellers PT @11am 2.00 0.00 28.00 60.00 0.00 $F$5 Number of tellers PT @Noon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 5.00 0.00 28.00 0.00 60.00 $G$5 Number of tellers PT @1pm 0.00 0.00 28.00 48.00 0.00 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $H$8 9am-10am needs 10.00 0.00 10.00 6.00 0.00 $H$9 10am-11am needs 17.00 0.00 12.00 5.00 1.00E+030 $H$10 11am-Noon needs 14.00 60.00 14.00 0.00 3.00 $H$11 Noon-1pm needs 19.00 0.00 16.00 3.00 1.00E+030 $H$12 1pm-2pm needs 24.00 0.00 18.00 6.00 1.00E+030 $H$13 2pm-3pm needs 17.00 0.00 17.00 5.00 2.00 $H$14 3pm-4pm needs 15.00 60.00 15.00 0.00 3.00 $H$15 4pm-5pm needs 10.00 0.00 10.00 3.00 0.00 $H$16 Max full time 10.00 0.00 12.00 1.00E+030 2.00 $H$17 Part-time limit 56.00-8.00 56.00 60.00 0.00...
View Full Document

Page1 / 2

4-5 - 5.00 0.00 28.00 0.00 60.00 $G$5 Number of tellers PT...

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

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