John Powell, chief of airport security at a large Canadian airport, is responsible for scheduling security agents around the clock. Powell has divided the day into six 4-hour periods: midnight to 4:00 A.M., 4:00 A.M. to 8:00 A.M., etc. Security agents work 8-hour shifts. Passenger traffic in the airport is determined by domestic and international flight schedules, and Powell has decided that the minimum number of security agents that he needs on duty during the different 4-hour shifts is as shown in the table: Shift Time Min. #of agents required 1 Midnight to 4:00 6 2 4:00 to 8: 00 10 Curated by Sofia A. Silberberg 3 8:00 to 12: 00 24 4 12:00 to 16: 00 24 5 16:00 to 20: 00 16 6 20:00 to 24: 00 12 Since Powell has been requested to keep the security budget at a minimum, he needs to minimize the number of security agents who work in the airport in a day. In making up a daily roster of security agents, Powell has to specify the starting time for each agent, therefore he has to decide how many agents should start their 8-hour shift at the beginning of each 4-hour time block. What schedule optimizes the number of agents?

PLEASE SHOW WORK USING EXCEL FILE AND MODEL