View the step-by-step solution to:

Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day.

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.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question