Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 2: [20 points] Maintenance at a major theme park in central Florida is an ongoing process that occurs 24 hours a day. Because it

image text in transcribed Question 2: [20 points] 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 8 hours. These eight-hour shifts start every 4 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. 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 it using Solver. Report the optimal solution and the value of the objective function in your report. In addition, save your work in Excel and upload the worksheet along with your report. (NOTE: Define the decision variables as integers). c. In order to balance the workforce utilization across the day, we are seeking an alternative solution that minimizes the maximum excess (slack) in the number of workers on any given day while still retaining the same workforce size. Update the spreadsheet model for this problem and resolve it to find the new optimal solution. Report the new solution in a new Excel worksheet. (No need to provide the updated mathematical model)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Alliance Management

Authors: Brian Tjemkes Pepijn Vos Koen Burgers

1st Edition

0128200405, 9780128200407

More Books

Students also viewed these General Management questions

Question

2. What assumptions have you made in estimating the requirement?

Answered: 1 week ago