For the scenario described in section 15.2c, suppose the number of employees needed for each hour are as shown in the following table:Develop and solve the optimization model on a spreadsheet and use Solver to find the number of employees to assign to the four work shifts to minimize the total number of employees.

Transcribed Image Text:

Hour 7 a.m. 8 a.m. 9 a.m. 10 a.m. 11 a.m. 12 p.m. 1 p.m. 2 p.m. 3 p.m. 4 p.m. 5 p.m. 6 p.m. 7 p.m. 8 p.m. 9 p.m. 10 p.m. 11 p.m. Number of employees needed 8 10 10 7 5 4 6 6 5 8 8 12 15 10 9 7 4