Please answer number questions 3 and 4 clearly in Excel with its managerial reports (operation for number 4)

Case 4 Instruction 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 a.m. - 10:00 a.m. 10:00 a.m. - 11:00 a.m. 11:00 a.m. - Noon Noon - 1:00 p.m. 1:00 p.m. - 2:00 p.m. 2:00 p.m. - 3:00 p.m. 3:00 p.m. - 4:00 p.m. 4:00 p.m. - 5:00 p.m. 5:00 p.m. - 6:00 p.m. 6:00 pm - 7:00 p.m. 6 4 7 6 6 Time No. of Tellers 9:00 a.m. - 10:00 a.m. 6 4 8 10 9 10:00 a.m. - 11:00 a.m. 11:00 a.m. - Noon Noon - 1:00 p.m. 1:00 p.m. - 2:00 p.m. 2:00 p.m. - 3:00 p.m. 3:00 p.m. - 4:00 p.m. 4:00 p.m. - 5:00 p.m. 5:00 p.m. - 6:00 p.m. 6:00 p.m. - 7:00 p.m. 6 4 7 6 a 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). 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%) Your submission of report should include a MS Excel file showing the operations for Part 2 and Part 4