Q: Use the Excel Solver to solve this model. Submit the computer file.

2. A restaurant opens at 7 a.m. each day, and stays open until 2:59 a.m. the next morn- ing. Their food service employees work two four-hour shifts per day. For some workers, the two shifts are consecutive (effectively one eight-hour shift), but other workers work split-shifts, with a four hour gap between their shifts. All food service workers earn a base rate of $14 per hour. In addition, there is a bonus of $12 paid to each person who works on a split-shift. The restaurant has the following daily requirements: Shift Index 1 2 Time of Day 7 a.m. to 10:59 a.m. 11:00 a.m. to 2:59 p.m. 3:00 p.m. to 6:59 p.m. 7:00 p.m. to 10:59 p.m. 11:00 p.m. to 2:59 a.m. Minimum Number of Workers Needed 15 23 11 25 6 3 4 5 Subject to meeting all its requirements for workers, the restaurant wishes to mini- mize its daily labour cost (regular and bonus). Formulate the model so that the $14 and the $12 are entered only once