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 eighthour 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 four-hour time period. Time Period Needed Minimum Employees 12 a.m. – 4 a.m. 80 4 a.m. – 8 a.m. 210 8 a.m. – 12 p.m. 245 12 p.m. – 4 p.m. 160 4 p.m. – 8 p.m. 295 8 p.m. – 12 a.m. 120 The maintenance supervisor wants to determine the minimum number of employees to schedule that meets the minimum staffing requirements. 1. Formulate the LP model for this problem. 2. Create the spreadsheet model and use Solver to solve the problem.
PLease use excel
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 eighthour 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 four-hour time period.
Time Period Needed Minimum Employees
12 a.m. – 4 a.m. 80
4 a.m. – 8 a.m. 210
8 a.m. – 12 p.m. 245
12 p.m. – 4 p.m. 160
4 p.m. – 8 p.m. 295
8 p.m. – 12 a.m. 120
The maintenance supervisor wants to determine the minimum number of
employees to
1. Formulate the LP model for this problem.
2. Create the spreadsheet model and use Solver to solve the problem.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
