Consider Figure 4.22 from the Hong Kong Bank labor-planning example presented in Solved Problem 4–1. What would be the impact on daily cost if corporate policy changed to allow the part-time hours to increase to a maximum of 75% of the day’s total requirement (instead of just 50%)?

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