Question: please answer Q 3 & 4 clearly in Exell with its Report. Thank you. The Northside Bank is working to develop an efficient work schedule
please answer Q 3 & 4 clearly in Exell with its Report. Thank you.
The Northside Bank is working to develop an efficient work schedule for full-time and part-time tellers. The schedule must provide for efficient operation of the bank, including adequate customer service, employee breaks, and so on. On Fridays, the bank is open from 9:00 a.m. to 7:00 p.m. The number of tellers necessary to provide adequate customer service during each hour of operation is summarized as follows: Time No. of Tellers 6 4 8 10 9 9:00 am - 10:00 am 10:00 am - 11:00 a.m. 11:00 a.m. - Noon Noon - 1:00 pm 1:00 pm - 2:00 pm 2:00 pm - 3:00 pm 3:00 pm - 4:00 pm 4:00 pm - 5:00 p.m. 5:00 pm - 6:00 pm 6:00 pm - 7:00 pm 6 4 7 6 o a 6 6:00 p.m. - 7:00 p.m. 6 Each full-time employee starts on the hour and works a 4-hour shift, followed by a 1-hour break and then a 3-hour shift. Part-time employees work one 4-hour shift beginning on the hour. Considering salary and fringe benefits, full-time employees cost the bank $15 per hour ($105 a day), and part-time employees cost the bank $8 per hour ($32 per day). 1 3. Please comment on the optimal schedule of tellers. Any surplus of tellers at certain hours? (20%) 4. After reviewing the solution in the above, the bank manager realized that some additional requirements must be specified. Specifically, she wants to ensure that one full-time employee is on duty at all times and that there is a staff of at least five full-time employees. Revise your model to incorporate these additional requirements, and solve for the optimal solution. (20%)


Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
