Scheduling Bank Tellers Note: Setup example below in excel and Minimize total daily manpower cost in excel using solver. Mexico City Bank of Commerce and Industry is a busy bank that has requirements for between 10 and 18 tellers depending on the time of day. Lunchtime, from noon to 2 p.m., is usually heaviest. The following table indicates the workers needed at various hours that the bank is open. The bank now employs 12 full-time tellers, but many people are on its roster of available part-time employees. A part-time employee must put in exactly 4 hours per day but can start anytime between 9 a.m. and 1 p.m. Part-timers are a fairly inexpensive labor pool because no retirement or lunch benefits are provided them. Full-timers, on the other hand, work from 9 a.m. to 5 p.m. but are allowed 1 hour for lunch. (Half the full-timers eat at 11 a.m., the other half at noon.) Full-timers thus provide 35 hours per week of productive labor time. By corporate policy, the bank limits part-time hours to a maximum of 50% of the day’s total requirement. Part-timers earn $6 per hour (or $24 per day) on average, whereas full-timers earn $75 per day in salary and benefits on average. APPROACH The bank would like to set a schedule, using LP, that would minimize its total manpower costs. It will release 1 or more of its full-time tellers if it is profitable to do so. We can let: F = full time tellers P1 = part-timers starting at 9am (leaving at 1pm) P2 = Part-timers starting at 10am (leaving at 2pm) P3 = Part-timers starting at 11am (leaving at 3pm) P4 = Part-timers starting at noon (leaving at 4pm) P5 = Part-timers starting at 1pm (leaving at 5pm) Question Minimize total daily manpower cost in excel using solver.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

Scheduling Bank Tellers Note: Setup example below in excel and Minimize total daily manpower cost in excel using solver. Mexico City Bank of Commerce and Industry is a busy bank that has requirements for between 10 and 18 tellers depending on the time of day. Lunchtime, from noon to 2 p.m., is usually heaviest. The following table indicates the workers needed at various hours that the bank is open. The bank now employs 12 full-time tellers, but many people are on its roster of available part-time employees. A part-time employee must put in exactly 4 hours per day but can start anytime between 9 a.m. and 1 p.m. Part-timers are a fairly inexpensive labor pool because no retirement or lunch benefits are provided them. Full-timers, on the other hand, work from 9 a.m. to 5 p.m. but are allowed 1 hour for lunch. (Half the full-timers eat at 11 a.m., the other half at noon.) Full-timers thus provide 35 hours per week of productive labor time. By corporate policy, the bank limits part-time hours to a maximum of 50% of the day’s total requirement. Part-timers earn $6 per hour (or $24 per day) on average, whereas full-timers earn $75 per day in salary and benefits on average. APPROACH The bank would like to set a schedule, using LP, that would minimize its total manpower costs. It will release 1 or more of its full-time tellers if it is profitable to do so. We can let: F = full time tellers P1 = part-timers starting at 9am (leaving at 1pm) P2 = Part-timers starting at 10am (leaving at 2pm) P3 = Part-timers starting at 11am (leaving at 3pm) P4 = Part-timers starting at noon (leaving at 4pm) P5 = Part-timers starting at 1pm (leaving at 5pm) Question Minimize total daily manpower cost in excel using solver.