A) Formulate an algebraic model for the problem.

B) Use Lingo or Excel to solve the problem

C) Explain the solution in words

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 Time of Day 1 7 a.m. to 10:59 a.m. 2 11:00 a.m. to 2:59 p.m. 3 3:00 p.m. to 6:59 p.m. 4 7:00 p.m. to 10:59 p.m. 5 11:00 p.m. to 2:59 a.m. Minimum Number of Workers Needed 15 23 11 25 6 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