Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it is a long drive from most residential areas to the park, employees do not like to work shifts of fewer than eight hours. These 8-hour shifts start every four hours throughout the day. The number of maintenance workers needed at different times throughout the day varies. The following table summarizes the minimum number of employees needed in each 4-hour time period (see attached table). The maintenance supervisor wants to determine the minimum number of employees to schedule that meets the minimum staffing requirements

a) Formulate an LP model for this problem.

b) Create a spreadsheet model for this problem and solve using Excel Solver

c) What is the optimal solution?

...complete problem found in attachment.

Maintenance at a major theme park in central Florida is an ongoing

process that occurs 24 hours a day. Because it is a long drive from most

residential areas to the park, employees do not like to work shifts of

fewer than eight hours. These 8-hour shifts start every four hours

throughout the day. The number of maintenance workers needed at

different times throughout the day varies. The following table

summarizes the minimum number of employees needed in each 4-hour time

period (see attached table). The maintenance supervisor wants to

determine the minimum number of employees to schedule that meets the

minimum staffing requirements.

a) Formulate an LP model for this problem.

b) Create a spreadsheet model for this problem and solve using Excel

Solver

c) What is the optimal solution?

Data Table

Time Period Minimum Employees Needed

12 a.m. to 4 a.m. 90

4 a.m. to 8 a.m. 215

8 a.m. to 12 p.m. 250

12 p.m. to 4 p.m. 165

4 p.m. to 8 p.m. 300

8 p.m. to 12 a.m. 125

Note: Please send all the Word and Excel files that are created as part

of the solution.

a) Formulate an LP model for this problem.

b) Create a spreadsheet model for this problem and solve using Excel Solver

c) What is the optimal solution?

...complete problem found in attachment.

Maintenance at a major theme park in central Florida is an ongoing

process that occurs 24 hours a day. Because it is a long drive from most

residential areas to the park, employees do not like to work shifts of

fewer than eight hours. These 8-hour shifts start every four hours

throughout the day. The number of maintenance workers needed at

different times throughout the day varies. The following table

summarizes the minimum number of employees needed in each 4-hour time

period (see attached table). The maintenance supervisor wants to

determine the minimum number of employees to schedule that meets the

minimum staffing requirements.

a) Formulate an LP model for this problem.

b) Create a spreadsheet model for this problem and solve using Excel

Solver

c) What is the optimal solution?

Data Table

Time Period Minimum Employees Needed

12 a.m. to 4 a.m. 90

4 a.m. to 8 a.m. 215

8 a.m. to 12 p.m. 250

12 p.m. to 4 p.m. 165

4 p.m. to 8 p.m. 300

8 p.m. to 12 a.m. 125

Note: Please send all the Word and Excel files that are created as part

of the solution.

### Recently Asked Questions

- : If pentagon ABCDE is rotated 180° around the origin to create pentagon A'B'C'D'E', what is the ordered pair of point D'? (−1, 2) (2, 1) (1, −2)

- X, Y be random vectors. I want to show that: 1) Var(X) = E(XX') - E(X)(X') 2) Cov (X,Y) = (Cov(Y,X))' X' stands for X- transposed

- BBased on data from a college, scores on a certain test are normally distributed with a mean of 1546 and a standard deviation of 328. After viewing the icon