Mazy’s Department Store has decided to stay open on a 24-hour basis. The store m
ID: 3384052 • Letter: M
Question
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.
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
Explanation / Answer
Mazy’s Department Store has decided to stay open on a 24-hour basis. The store m