Question

In: Statistics and Probability

A grocery store is open 24 hours a day, seven days a week. It has the...

A grocery store is open 24 hours a day, seven days a week. It has the following daily requirements for cashiers:

Time                             Minimum # of cashiers

0100 – 0400                              7

0400 – 0700                              4

0700 – 1000                              9

1000 – 1300                              12

1300 – 1600                              15

1600 – 1900                              17

1900 – 2200 19

2200 – 0100                              13

A cashier may start work at the beginning of any one of the shifts and, having begun, works 9 consecutive hours. Each cashier is paid $15 per hour.

Formulate the employee scheduling problem that minimizes the total daily cost, meeting the minimum level of each shift’s requirements. Implement this problem into excel and solve for the optimal solutions.

What is optimal number of people working for shift 0100-0400? (Please type ONLY NUMBERS with NO ROUNDING in the answer box)

Solutions

Expert Solution

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Clancy’s Casino, in Muledeer, Nevada, is open 24 hours a day, seven days a week. Along...
Clancy’s Casino, in Muledeer, Nevada, is open 24 hours a day, seven days a week. Along with all the other attractions and diversion, Clancy’s operates a variety of gaming tables. Dealers at these tables are interchangeable. The casino has the following daily requirements for dealers:                   Time                             Minimum # of dealers       0100 – 0500                               7       0500 – 0900                               4       0900 – 1300                               9       1300 – 1700                               12       1700 – 2100                               15       2100 – 0100                              ...
Atlantic Video, a small video rental store in Philadelphia, is open 24 hours a day, and—due...
Atlantic Video, a small video rental store in Philadelphia, is open 24 hours a day, and—due to its proximity to a major business school—experiences customers arriving around the clock. A recent analysis done by the store manager indicates that there are 20 customers arriving every hour, with a standard deviation of interarrival times of 2 minute(s). This arrival pattern is consistent and is independent of the time of day. The checkout is currently operated by one employee, who needs on...
Atlantic Video, a small video rental store in Philadelphia, is open 24 hours a day, and—due...
Atlantic Video, a small video rental store in Philadelphia, is open 24 hours a day, and—due to its proximity to a major business school—experiences customers arriving around the clock. A recent analysis done by the store manager indicates that there are 10 customers arriving every hour, with a standard deviation of interarrival times of 1 minute(s). This arrival pattern is consistent and is independent of the time of day. The checkout is currently operated by one employee, who needs on...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts each week. Management is interested in whether there is a difference in the number of units produced when the employees work on various shifts. A sample of five workers is selected and their output recorded on each shift. At the 0.05 significance level, can we conclude there is a difference in the mean production rate by shift or by employee? Units Produced Employee Day...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts each week. Management is interested in whether there is a difference in the number of units produced when the employees work on various shifts. A sample of five workers is selected and their output recorded on each shift. At the 0.01 significance level, can we conclude there is a difference in the mean production rate by shift or by employee? Units Produced Employee Day...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts each week. Management is interested in whether there is a difference in the number of units produced when the employees work on various shifts. A sample of five workers is selected and their output recorded on each shift. At the 0.05 significance level, can we conclude there is a difference in the mean production rate by shift or by employee? Units Produced Employee Day...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts...
Chapin Manufacturing Company operates 24 hours a day, five days a week. The workers rotate shifts each week. Management is interested in whether there is a difference in the number of units produced when the employees work on various shifts. A sample of five workers is selected and their output recorded on each shift. At the 0.01 significance level, can we conclude there is a difference in the mean production rate by shift or by employee? Units Produced Employee Day...
MW is a large discount store that operates seven days per week. The store needs the...
MW is a large discount store that operates seven days per week. The store needs the following number of full-time employees working each day of the week. Sunday Monday Tuesday Wednesday Thursday Friday Saturday # of Employees 188 88 112 140 136 172 212 Each employee must work five consecutive days each week and then have two days off. For example, any employee who works Sunday through Thursday has Friday and Saturday off. The store currently has a total of...
A clothing store is open each day for 12 hours. On average, the store gets 120...
A clothing store is open each day for 12 hours. On average, the store gets 120 customers per day. Round each answer below to the nearest hundredth. a. Find the probability that the store gets 140 or more customers today. b. Find the probability that the store gets 15 or more customers in the first hour of business. c. Find the probability that the store gets 40 or more customers in the first three hours of business. **Please show me...
You work in a factory that runs 24 hr a day, 7 days a week. The...
You work in a factory that runs 24 hr a day, 7 days a week. The boss insists that all 10 of the machines in the factory get a good servicing before he goes on vacation. Each of these machines has a part replaced that has an MTTF(µ) of 10,000hrs. The boss will then take the next 2 months (60 days) off for his “well deserved” vacation. The purchasing department will not purchase any expensive items while the boss is...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT