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 clean-ue 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 The following numbers of workers are needed during each of the indicated time blocks: Workers Needed 11 24 16 10 22 17 6 $80 $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. Formulate the Integer Linear Programming for this problem, implement in spreadsheet and solve it by Solver. $2450 $2520 $2632 $2716 a value different from all the above Let Xi be the number of workers assigned to shift i, with i = 1, 2, 3, ..., 7 What is the optimal value of the objective function? Group of answer choices $2318

Seasoms Antisserie 6 Grill is apen from 8,00 ans to 10,00 pm daily. Besides the hours they are open foe business, workers are needed an hour before opening and an hour atter ciosing for setup and activities. The restaurant operates whth both full: fime and part-time workers on the following shift The followine numbers of workers are neebed during each of the insicated time block: At least one full time worker must be avaibble during the hour before opering and afver dosine. Additionally, at least 30 s of the errplopes should be full-time (8-hout) workers during the restourant's busy periods from 1100mm1,00pm and 5,00pm7,00pm Hint This problen is similar to the Enplovee Sctedule Problem - Aur Express discissed in the iecture video. The first table in the above provides intorrnation about daly pay rate for each of seven shitts. 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 wary. For esanple, 11 workers needed for 7.00mm 11.00 am can be expressed as 11 workers needed for 7.00am8.00am8.00am 9,00 an 9,00 am -1000 an and 10000 am 11,00 an Do the same thing for cher time blocks in the second table. Now you are able to create a spreadshert table with one dimension on 7 shifts and the other dimension on each of the 16 hours from 7.00am 1100pm. The structure of this table is simlar to that of the takle shown is the spreactsheet on slide in 24 of Chaptes 6 . Formulabe the integer Lincar Programming for this problem, inclement in spreadsheet and solve it by Solver. Let X be the number of workers assigned to shift i, withi =1,2,3,7 What is the optimal value of the objective function? they are open for businest. worlars are nended an hour before opening and an hour atter dosing for setip and lemene activities. The retaurat operates with both fulfime and part-time workers on the following stift: The folowine numbes of worhes are needed drine each of the indicated time blods: At least one hal time worker must be maluelit during the hour before coping and atter during the restaurant's busy periads fom 1100 am -100 pm and 5.00 pm 7:00 pm Ifnt This problem is similar to the Erployee Schedule Problem - Ar Express discussed in the lecture video. The first table in the jhove provides informubion sbou doily py rate for euch of seven sifts snce the schedse of hass in the second toble is ditferent fom the thot of stitt in the first table it is betiog to erpress the schedvle of hous in the second table in a mare detalled way. Far ecan ple 11 workens needed for. 7.00am 1100am can be expresued as 11 wohers needed for 7.00am8.00am a.00 am - 900sm900am1000am and 1000am1100sm Do the some thing for other dimersion on 7 shifts and the other dimersion on ruch of the 16 hours from 7,00am 1100pm. The structure of this tatle is simila to that of the tbile shown in the spreadsheet on slide int of Ohacter 6 and sche i by solver. Let X0 be the ramber of worken ksigred to shif i with i - 1.2.2...7 What is the optinal value of the objoctlive Iuncion? Grap of arsiver choices 52318 $2450