Create the spreadsheet model

Assignment Help Operation Management

Reference no: EM132133673

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 eight-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 four-hour time period. Time Period Minimum Employees Needed 12 a.m. – 4 a.m. 90 4 a.m. – 8 a.m. 215 8 a.m. – 12 p.m. 250 12 p.m. – 4 p.m. 165 4 p.m. – 8 p.m. 300 8 p.m. – 12 a.m. 125 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.

Reference no: EM132133673

Questions Cloud

How many units of should the firm use : A competitive firm produces output using three fixed factors and one variable factor. The firm's short-run production function is q = 305x - 2x2.

Make sense for delta to purchase refinery : Using the Delta Airlines’ decision to acquire a petroleum refinery, does it make sense for Delta to purchase a refinery?

How many more miles of use per year more preferable : Compare two cars A and B. The initial cost of Car A is $500 more than Car B. However Car A consumes 0.01 less gallons/mile compared to B. Given that B's salvage

Consistent with the desired service level : If an ROP model is used, what ROP would be consistent with the desired service level?

Create the spreadsheet model : Formulate the LP model for this problem. Create the spreadsheet model and use Solver to solve the problem.

Present plan to bring about necessary improvement for amazon : Present a plan to bring about necessary improvement for Amazon using John Kotter's 8-step change model.

Economic impact of non-revenue generating activity : What is the economic impact of non-revenue generating activity in the motor carrier industry?

Supplier quality relative to process management : Why would it be important for an organization to have a standard way of looking at (and evaluating) supplier quality relative to process management?

Four leadership skill sets that effective emotional leaders : What are the four leadership skill sets that Effective Emotional Leaders use/learn? Which do you think is the most critical and why?

User Account

All Pages