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 1 year ago
Next > < Previous

Related Solutions

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...
1. The world renown Chef Beaujolais Restaurant in New Orleans is open 24 hours a day....
1. The world renown Chef Beaujolais Restaurant in New Orleans is open 24 hours a day. Each waitperson works an 8-hour shift and can report for duty at midnight, 4 am, 8am, noon, 4pm or 8 pm. The table below shows the minimum number of waitpersons needed during each 4 hour period into which the day is divided. Time period Waitstaff needed. Midnight to 4am 4 4am to 8am 3 8am to noon 11 Noon to 4pm 10 4pm to...
Store is open 7 days/week. orders units every other week. maintains safety stock of 120 units....
Store is open 7 days/week. orders units every other week. maintains safety stock of 120 units. weekly sales is 800 units. lead time is 3 days. current inventory is 350 units, how many units should it order?
6. The Glass House Restaurant is open 24 hours per day serving breakfast, lunch and dinner.  ...
6. The Glass House Restaurant is open 24 hours per day serving breakfast, lunch and dinner.   Fixed Costs are $42,000 per month. Variable Costs are $11.50 per meal.   The average total bill is $15 per customer. Ignore taxes and tips. Required: Compute the number of meals that must be served if Glass House Restaurant wishes to earn a profit of $9,000 Compute the Break Even point in Units Compute the Break Even point in Sales Dollars Assume that fixed costs...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT