Consider Figure 4.22 from the Hong Kong Bank labor planning example presented in Solved Problem 4–1. Suppose that every day between 11:00 a.m. and noon, two tellers’ worth of demand comes from employees from a nearby international company that requires a large number of teller transactions from the bank. The employees make these transactions and then go to lunch. How much money per week should the Hong Kong Bank be willing to offer its client to get the client to send all its employees over during the noon-1:00 p.m. time frame each day instead?

Figure 4.22

Transcribed Image Text:

Reduced cost of zero indicates that a solution that uses part-time tellers at 9 A.M. exists, with no change in the optimal objective value. Microsoft Excel 14.0 Sensitivity Report Worksheet: [Figure 4.21.xlsx]Hong Kong Bank Variable Cells Name SBS5 Number of tellers FT tellers SCS5 Number of tellers PT @9am SDS5 Number of tellers PT @10am SES5 Number of tellers PT @11am SFS5 Number of tellers PT @Noon SGS5 Number of tellers PT @1pm Final Reduced Objective Allowable Allowable Value 10.00 0.00 7.00 2.00 Cofficient Increase Decrease 0.00 0.00 0.00 0.00 Cll Cost 48.00 0.00 90.00 1E+30 48.00 0.00 60.00 0.00 48.00 28.00 28.00 28.00 45.00 0.00 60.00 These zeros indicate that there are alternate optimal solutions. 5.00 0.00 28.00 0.00 0.00 28.00 0.00 Constraints Final Shadow Constraint Allowable Allowable Name Cell SHS8 9am-10am needs SHS9 10am-11am needs SHS10 11am-Noon needs SHS11 Noon-1pm needs SHS 12 1pm-2pm needs SHS 13 2pm-3pm needs SHS 14 3pm-4pm needs SHS 15 4pm-5pm needs SHS 16 Max full time SHS 17 Part-time limit R.H. Side Increase Decrease 6.00 5.00 0.00 3.00 6.00 Value 10.00 17.00 Price 0.00 0.00 1E+30 3.00 10.00 0.00 12.00 60.00 0.00 14.00 14.00 19.00 24.00 17.00 0.00 0.00 60.00 16.00 18.00 17.00 15.00 10.00 1E+30 1E+30 2.00 5.00 3.00 0.00 15.00 10.00 10.00 56.00 0.00 3.00 0.00 0 00 -8.00 1E+30 60.00 12.00 2.00 56.00 0.00