Mazys Department Store has decided to stay open on a 24hour

Mazy’s Department Store has decided to stay open on a 24-hour basis. The store manager has divided the 24-hour day into six 4-hour periods and determined the following minimum personnel requirements for each period Time Personnel Needed

Midnight - 4:00 AM 82

4:00 - 8:00 AM 98

8:00 - Noon 150

Noon - 4:00 PM 80

4:00 - 8:00 PM 220

8:00 - Midnight 150

Personnel must report for work at the beginning of one of these times and work 8 consecutive hours. The store manager wants to know the number of employees to assign for each 4-hour segment to minimize the total number of employees.Formulate a linear programming model for this problem. Define your decision variables, formulate your objective function and constraints. Please write the problem formulation in a word or pdf file.Solve the model by using the computer. Please submit your excel solver model, and name the sheet as Question1.

Solution