Purchase Solution

Optimization at a major theme park in central Florida

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Solution Summary

The solution provides step-by-step and detailed answer for the problem, including Excel instructions.

Purchase this Solution
Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Probability Quiz

Some questions on probability

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

View More Free Quizzes
Related BrainMass Solutions

  • Linear programming for Florida theme park

    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.

  • Walt Disney's land speculation

    It isn't clear exactly why this upset him, but clearly property prices rose dramatically with the news that a theme park was being built.

  • Strategic Management

    The Universal Orlando of Florida is free from the state ride regulation and casualty inspection plans. // After going through the description of the Disney theme park in reference to its competitors, demand and supply and government regulations, we

  • Walt Disney in Tokyo, Paris, and Hong Kong

    Octoberfest is big business in Germany and could serve as a major theme for more of the park than is commonly devoted to that idea in the US parks. Germany would be a good choice due to the firm value of their currency at the present time.

  • Anchor Project for differentiation/acceleration/"free time"

    What else would a customer need to know? *A two sided MENU of ONE of the theme park restaurants in your new theme park. To do this, think of these questions: What restaurant will go with your park's theme?

  • This post addresses the internatioanl operations of WDC.

    At first, Disney opened all theme parks worldwide to be exact replicas of the theme park in the U.S.

  • Walt Disney Critical Issues

    The key facts in this case revolved around Walt Disney's initial Americanized viewpoint of the world, which led them to posit that they could open a theme park in another country without restructuring the theme park to adhere to cultural and local norms

  • Theme park experience

    Write a 350- to 700-word paper in APA format answering items a and b. Include a description of a recent theme park experience and an explanation of why you chose to visit that particular theme park.

  • Beyond Tokyo: Disney's Expansion in Asia

    This isn't the case at the Disneyland theme parks in Asia. 3. How do cultural variables influence the location choice of theme parks around the world? Disney's parks make it a priority to promote its characters and theme.

View More Related Solutions