The minimum number of part-time employees needed at a quick service restaurant for each two-hour block is shown in the following table:

Part time college students work four-hour shifts (e.g., 7-11 a.m., 9 a.m. to 1 p.m., and so on, starting at each two-hour block, with the last shift from 7 p.m. to 11 p.m.). Formulate and solve an optimization model to determine how many employees are needed for each shift in order to minimize the total number of employees overall, implement it on a spreadsheet, and use Excel Solver to find an optimal solution.

Transcribed Image Text:

Time Block 1:7-9 a.m. 2:9-11 a.m. 3: 11-1 p.m. 4: 1-3p.m. 5:3-5 p.m. 6:5-7 p.m. 7:7-9 p.m. 8:9-11 p.m. Minimum number required 12 6 15 10 5 13 9 6