PLEASE USE EXCEL SOLVER

The Soup's On is a brand new, open 24-hours a day, restaurant in the City's East end. Arma, the owner, must schedule wait staff to ensure that no fewer than a certain number are on hand throughout the 24-hours. To accomplish this task, Arma has divided the day into 8 periods with each one 3-hours long. For each of these 3-hour demand periods shown in the table below, Arma has estimated the number of wait staff needed, as a minimum, to meet the expected demand within that period. Although demand for staff changes every 3 hours, Arma has to offer staff a 6-hour shift in order to get employees to work for her business. To avoid disrupting the restaurant at shift changes, no more than 7 new employees can begin work. As a new restaurant, Arma understands that minimizing wait staff costs is a key objective to success. Help Arma determine the optimal number of wait staff per shift to minimize costs. Minimum Shift start of Wait Demand Staff Period End Times Required Midnight to 1 3:00 AM 3 # & 1 2 2 3 10 4 11 5 12 3:00 AM to 6:00 AM 6:00 AM to 9:00 AM 9:00 AM to 12:00 PM 12:00 PM to 3:00 PM 3:00 PM to 6:00 PM 6:00 PM to 9:00 PM 9:00 PM to 12:00 AM 6 5 7 14 8 8