Determine the minimum number of employees to schedule

Assignment Help Operation Management

Reference no: EM131933198

The question is:

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.

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

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 (i.e. values for all the decision variables) and the value of the objective function in your report. In addition, save your work in Excel and upload the file along with your report.

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 and upload the new Excel model. (No need to provide the updated mathematical model).

Reference no: EM131933198

Questions Cloud

Prepare analysis indicating the difference in profitability : Prepare an analysis indicating the increase or decrease in total profitability if 15,000 additional running shoes and 10,000 additional golf shoes are produced.

Describe the purpose of each financial statement : Describe the purpose of each financial statement. Determine which one (1) is the most effective in communicating the financial health of an organization

What annual interest rate would you need to earn : What annual interest rate would you need to earn if you wanted a $600 per month contribution to grow to $53,500 in six years?

What are the five annual payments : Anderson Manufacturing? Co., a small fabricator of? plastics, needs to purchase an extrusion molding machine for ?$130,000. Kersey will borrow money.

Determine the minimum number of employees to schedule : Determine the minimum number of employees to schedule that meets the minimum staffing requirements.

How does society shapes family life : How does society shapes family life? Do you think families today have the same values as the more traditional families of the past? Why or why not?

Activities in the value chain of nintendo : What are the primary and support activities in the value chain of Nintendo?

Determine what is the savings rate : Angela's monthly disposable income is $3,027. She has monthly expenses of $2,625 (including recreational expenses of $376) and net cash flow of $402 per month.

Prepare relevant journal entry of tassie ltd for year ending : Accounting for foreign currency transactions Tassie Ltd. Prepare relevant journal entries of Tassie Ltd for the years ending 30 June 2017 and 30 June 2018.

User Account

All Pages