Q 10 Question 10 to Question 12 is based on this problem. Seasons Rotisserie & Grill is open from 8:00 am to 10:00 pm daily. Besides the hours they are open for business, workers are needed an hour before opening and an hour after closing for setup and activities. The restaurant operates with both full- time and part-time workers on the following shift: Shift 1 2 3 4 5 6 7 Time 7:00 am-11:00 am 7:00 am - 3:00 pm 11:00 am-3:00 pm 11:00 am - 7:00 pm 3:00 pm - 7:00 pm 3:00 pm-11:00 pm 7:00 pm-11:00 pm Hours 7:00 am-11:00 am 11:00 am - 1:00 pm 1:00 pm - 3:00 pm 3:00 pm - 5:00 pm 5:00 pm - 7:00 pm 7:00 pm - 9:00 pm 9:00 pm-11:00 pm Daily Pay Rate $32 $80 The following numbers of workers are needed during each of the indicated time blocks: Workers Needed 11 24 16 10 22 17 6 $32 $80 $32 $80 $32 At least one full time worker must be available during the hour before opening and after closing. Additionally, at least 30% of the employees should be full-time (8-hour) workers during the restaurant's busy periods from 11:00 am - 1:00 pm and 5:00 pm - 7:00 pm. Hint: This problem is similar to the Employee Schedule Problem - Air Express discussed in the lecture video. The first table in the above provides information about daily pay rate for each of seven shifts. Since the schedule of hours in the second table is different from the that of shift in the first table, it is better to express the schedule of hours in the second table in a more detailed way. For example, 11 workers needed for 7:00 am - 11:00 am can be expressed as 11 workers needed for 7:00 am - 8:00 am, 8:00 am - 9:00 am, 9:00 am - 10:00 am and 10:00 am - 11:00 am. Do the same thing for other time blocks in the second table. Now you are able to create a spreadsheet table with one dimension on 7 shifts and the other dimension on each of the 16 hours from 7:00 am - 11:00 pm. The structure of this table is similar to that of the table shown in the spreadsheet on slide # 24 of Chapter 6. Group of answer choices Shift 2, 3 and 4 Shift 3, 4 and 5 Shift 4, 5 and 6 Shift 5, 6 and 7 Shift 6, 7 and 1 Formulate the Integer Linear Programming for this problem, implement in spreadsheet and solve it by Solver. Which shifts will cover the time slot of 3pm to 4pm?

Question 10 is Question 12 is best en Ris poulen. time and part-time workers on feve fullewint whit: Ae leant one full time woher man be avaboble dorne the hour befort oberine and after during the restuurantis bury geriods trom 11.00as1.00 pes and 5.00pm+7.00pm. Hint: This problem is sinilar to the Enployse Solestle Froblem - Ajr Evoreas dincussed seciond table in a more detaled way. For ecample. 11 wohers netded for 700 am dimemion an 7 shilts and the other dimetsipe on nach of the 16 haun from 7:00 am 11.00pm. The structure of thin table is similar to shat af the table thown in the speadeheet on slide 24 of Chapeer 6 . and solve in by Solver. Which shats well cover the time siot of 3pm to dpe? gah? Ijuda What 2+ - 3