Third evaluation concerns staff scheduling

Assignment Help Management Theories

Reference no: EM131099614

I am having problems figuring out where to place the data so that I can run the excel solver.....

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. Refer to the Excel spreadsheet "Benchmark Assignment - Data Analysis Case Study Linear Programming Template."

Reference no: EM131099614

Questions Cloud

What is the total amount you will receive : A clever, rich, and wealthy local politician promises to give you $1,000 on the first day of four months before elections. From here on he will give you 9/10 of the amount he gave you the day before.

Extensive form representations of a strategic : Consider the voting game. Suppose that each voter conditioned her second stage vote on how he voted the first time around. Explain why every strategy has five components in this case.

Standard error of the proportion : A local school district wants to survey parents about their attitudes toward the elimination of the marching band program as a way to save money. The school district sampled 120 parents and found 74 supported the plan to cut the band program.

Probability of a disk drive error : Using the information from the component performance standards, what is the probability of a disk drive error given that a failure occurred?

Third evaluation concerns staff scheduling : 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.

How implement and communicate your brand positioning : MKT10007 Fundamentals of Marketing. Summarize how your recommended Marketing Mix will implement and communicate your Brand Positioning

How to compete in individual country markets : How to compete in individual country markets? The standardization of specific competitive marketing variables (attitudes, etc you introduced) across country markets (Liberia vs. USA).

Explain why you used either the cpi data or the gdpd data : Explain why you used either the CPI data or the GDPD data - Draw a supply/demand diagram of the US Treasury bond market to illustrate the effects on it of the developments cited in part A.

How to design a c program to serve as a shell interface : In this project, you will learn how to design a C program to serve as a shell interface that accepts user commands and then executes each command in a separate process

User Account

All Pages