Determine the minimum number of employees

Assignment Help Operation Management
Reference no: EM132699481

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.

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.

Reference no: EM132699481

Questions Cloud

What kinds of behavior could suggest intelligence : What kinds of behavior could suggest intelligence in an animal? Why do you think accepting the idea of intelligence in other animals is so difficult for us?
Describe a mouse as opportunistic or equilibrium : Should evolutionary principles be applied to human reproductive behavior?
Compare and contrast mitosis and meiosis : Compare and contrast mitosis and meiosis.
Differences in the rates or respiration in pinto beans : Describe what evidence you have that cellular respiration occurred in at least some of the beans? Explain using some of your lab data.
Determine the minimum number of employees : Determine the minimum number of employees to schedule that meets the minimum staffing requirements - Create the spreadsheet model and use Solver to solve
Firm after-tax cost of debt-rattle me bones inc : Rattle me Bones, Inc. sold a 20-year bond issue 10 years ago. It pays a 10% semi-annual coupon and has a $1,000 face value. If the current price per bond
Make the company cash budget for the upcoming fiscal year : Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Make the company cash budget for the upcoming fiscal year
What is the project npv : A project requires an investment in fixed asset of $1,400,000. This cost will be depreciated straight-line to zero over the project's ten-year life.
Define value of nursing documentation in healthcare planning : "Nursing Documentation: Is it valuable?" Discuss the value of nursing documentation in healthcare planning. Compare these purposes with the documentation format

Reviews

Write a Review

Operation Management Questions & Answers

  Will industry finance factors llc be able to insist

Premier Contracting Corporation purchased some equipment from Capitol Equipment Inc. pursuant to a contract that contained warranties.

  Discuss pros and cons of debt and equity financing

Discuss pros and cons of debt and equity financing. Determine which type of financing is best for your business.

  What aspects of your communication are more effective

What aspects of your communication are more effective? What aspects are you working to strengthen and how?

  Analyze the last two vendors across four categories

Daniel’s team had to analyze the last two vendors across four categories. Which basic characteristic groups of the potential providers are important to find the supplier that best matches the internal requirements of the Credit Suisse Group?

  What are the advantages to employees

Does your company's compensation plans help to attract and retain people with the right skills, knowledge and motivation to help the company succeed? Explain.

  Principle of selling class

List and compare the probable functional, situational, psychological, social, and knowledge needs of (a) a large financial investment office and (b) a college student, both of whom are looking to purchase a new computer print

  About warehouse configurations and material configurations

Based on what we have learned about warehouse configurations and material configurations within the warehouse

  Determine the advantages and the disadvantages of the system

Express your opinion about ios system. Determine the advantages and the disadvantages of the system. Develop your opinion based on :

  Contrast accounting profit and economic profit

Compare and contrast “accounting profit” and “economic profit” and provide an example of each?

  What specific change role of the three presented

What specific change role of the three presented in the case would you excel in personally if you were in this situation?

  Which structure do you think would be most effective

Which structure do you think would be most effective? Should each department have a manager that reports to the same director?

  Thinking about advertising in the local newspaper

Bobby the Barber is thinking about advertising in the local newspaper since he is idle 50 percent of the time.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd