J Linear, Integer and Mixed Integer Programming Emmavalueclnlheahedcdaml Thengomms DATATahonmedbbon, dldmnSolvarlnlmDetaMalysls Group and man dink SOLVE. , IfSOLVER Is not on the Dela Tab men please see lha Help lilo (Solver) for instructions. Signs less than or equal in equals (You needm enteran aposmphe first.) gleaierihan orequal in ' Dal: Problem setup area Mlnlmlle mnshalnts 10 AM-1 PM 0 0 U 3 1:00 PM ~ 4:00 PM 0 0 0 4 4:\") PM- 7:00 PM 0 0 0 6 7:00 PM- 10:00 PM 0 0 D 7 10:00 PM- 1:00 AM 0 0 0 4 Reruns , Varhblu ODIN-WI Third Evalation The third evaluation concerns staff scheduling. Some of the customers have complained that service is slow. The restaurant is open from 11:00 a.m. to midnight every day of the week. Tony divided the workday into ve shifts. The table below shows the minimum number of workers needed during the ve shis of time into which the workday is divided. Shift Time # of Staff Required 1 10:00 a.m. 1:00 p.m. 3 2 1:00 p.m. 4:00 p.m. 4 3 4:00 p.m. 7:00 p.m. 6 4 7:00 p.m. 10:00 p.m. 7 5 10:00 p.m. 1:00 am. 4 The owners must nd the right number of staff to report at each start time to ensure that there is sufcient coverage. The organization is trying to keep costs low and balance the number of staff with the size of the restaurant, so the total number of' workers is constrained to 15. Based on these factors, recommend the staff for each shift to accommodate the minimum requirements for customer service. Refer to the Excel spreadsheet \"Benchmark Assignment - Data Analysis Case Study Linear Programming Template.\