Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

THEME PARK EMPLOYEE SCHEDULING A theme park specifies the requirements for employees in four-hour blocks of time. The estimated requirements for employees in the next

image text in transcribed
THEME PARK EMPLOYEE SCHEDULING A theme park specifies the requirements for employees in four-hour blocks of time. The estimated requirements for employees in the next month are given in Table 1. Table 1. Estimated employee requirements Estimated Minimum Number of Time Period Employees 12 am to 4 am 90 4 am to 8 am 215 8 am to 12 pm 250 12 pm to 4 pm 165 4 pm to 8 pm 300 8 pm to 12 am 125 The current plan is to staff the park with full time employees that work eight hours in a row and part time employees that work four hours in a row. Thus full time employees begin their shifts at the first hour of one of the 6 four-hour periods shown in Table 1 and work until the conclusion of the next four-hour period. For example, a full time employee starting at 8 pm on one day will cover the last four- hour period of that day and the first four-hour period of the next day. A part time employee starts at the beginning of one of the 6 four-hour periods and works until that period is over. Full time employees are paid $7.50 per hour and part time employees are paid $9.00 per hour. Create a Solver-based spreadsheet model to determine the number of full time and part time employees that start in each of the 6 four-hour periods and does at the minimum total daily cost and solve the model. Comments and Hints: You must define the number of full time and part time employees starting each period as the changing cells (12 changing cells total) and the number available each period as formula cells. The general idea is that the number available in any particular period is the number starting that period (full time plus part time) plus the number of full time starting the previous period. For example, the number available from 12 a.m. to 4 a.m.is the number starting (both full and part time) that period plus the number of full time starting in the period from 8 p.m. to 12 a.m. (from the previous day)

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_2

Step: 3

blur-text-image_3

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

WebAssign For Trigonometry

Authors: Ron Larson

10th Edition

1337879622, 9781337879620

More Books

Students also viewed these Mathematics questions

Question

2. Ask questions, listen rather than attempt to persuade.

Answered: 1 week ago

Question

1. Background knowledge of the subject and

Answered: 1 week ago