7. Chapter 6, Problem 17. Snookers Restaurant is open from 8:00 am to [0:00 pm daily. Besides the hours that they are open for business, workers are needed an hour before opening and an hour after closing for setup and cleanup activities. The restaurant operates with both fulltime and part-time workers on the following shifts: stilt Daily Pay In. 7:00 arm-11:00 am $32 7:00 am3:00 pm 580 11:00 am3:m pm 532 llrtl) arm-7:00 pm $80 3:00 pm7:00 pm $32 3:00 pm-l l :00 pm 580 71!) pin11:00 pm $32 The following numbers of workers are needed during each of the indicated time blocks. Hours Mm M 7:00 amll:00 am 11 11:00 aml) pm 2-1 111) pin-3.11) pm 16 3:00 prim-5:00 pm 10 5:00 pm7:{I) pm 22 7:00 prim900 pm 17 9:00 pmllrtll pm 6 At least one fulltime 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 aml:00 pm and 5:00 pm7:00 pm. Formulate an [LP for this problem with the objective of minimizing total daily labor costs. a. Formulate an ILP for this problem with the objective of minimizing total daily labor costs. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution