Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Linear, Integer and Mixed Integer Programming: The third evaluation concerns staff scheduling. Some of the customers have complained that service is slow. The restaurant is

Linear, Integer and Mixed Integer Programming: The third evaluation concerns staff scheduling. Some of the customers have complained that service is slow. The restaurant is open from 11:00 a.m. to midnight every day of the week. Tony divided the workday into five shifts. The table below shows the minimum number of workers needed during the five shifts of time into which the workday is divided. Shift Time # of Staff Required 1 10:00 a.m. – 1:00 p.m. 3 2 1:00 p.m. – 4:00 p.m. 4 3 4:00 p.m. – 7:00 p.m. 6 4 7:00 p.m. – 10:00 p.m. 7 5 10:00 p.m. – 1:00 a.m. 4 The owners must find the right number of staff to report at each start time to ensure that there is sufficient coverage. The organization is trying to keep costs low and balance the number of staff with the size of the restaurant, so the total number of workers is constrained to 15. Based on these factors, recommend the staff for each shift to accommodate the minimum requirements for customer service. Use Excel to show work.

Shift

Time

# of Staff Required

1

10:00 a.m. – 1:00 p.m.

3

2

1:00 p.m. – 4:00 p.m.

4

3

4:00 p.m. – 7:00 p.m.

6

4

7:00 p.m. – 10:00 p.m.

7

5

10:00 p.m. – 1:00 a.m.

4


Step by Step Solution

3.45 Rating (164 Votes )

There are 3 Steps involved in it

Step: 1

Based on these factors recommend t... 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

Step: 3

blur-text-image

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

Accounting Information Systems

Authors: Ulric J. Gelinas, Richard B. Dull

10th edition

9781305176218, 113393594X, 1305176219, 978-1133935940

More Books

Students also viewed these Accounting questions

Question

Under what conditions are two qualitative variables independent?

Answered: 1 week ago