How do i input the data for this problem in excel qmthe, Ask an Expert

Management Studies

How do I input the data for this problem in Excel QM?

The famous Y.S. Chang Restaurant is open 24 hours a day. Waiter and busboys report for duty at 3 am, 7am, 11am, 3pm, 7pm, or 11pm, and each works an 8-hour shift. The following table shows the minimum number of workers needed during the six periods into which the day is divided. Chang's scheduling problem is to determine how many waiters and busboys should report for work at the start of each time period to minimize the total staff required for one day's operation.

Period 1 3am-7am 3 (required # of waiters and busboys)

Period 2 7am-11 am 12

Period 3 11am-3pm 16

Period 4 3pm-7pm 9

Period 5 7pm-11pm 11

Period 6 11pm-7am 4

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M91645550

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 social profiles and crowdsourced ratings can improve

1) Social profiles and crowdsourced ratings can improve trust, but they can also create opportunities for fraud and discrimination. Give examples of where this technology may have negative ethical implications, and discu ...

1 amazon competes in a number of industries with a variety

1. Amazon competes in a number of industries with a variety of companies. Identify one competing firm and compare Amazon's capabilities (strengths and weaknesses) to those of this firm. Who do you think will prevail in t ...

1 what qualities of netflix support the idea that it is a

1. What qualities of Netflix support the idea that it is a high-performance work system ? 2. What other qualities would contribute to it being a high-performance work system? 3. When should a firm configure its value cha ...

1 intel would like to increase the preference for intel

1. Intel would like to increase the preference for Intel chips among PC users in the individual user as well as business user segments. Define the management-decision problem. 2. Define an appropriate marketing research ...

The quality assurance plan is to eliminate patient falls

The quality assurance plan is to eliminate patient falls. The area that the focus is on, will be an assisted living facility. Write 300 or more words describing how, when, and to whom will you distribute your QA plan. Co ...

What is your thoughts or opinion on this question below i

What is your thoughts or opinion on this question below, I need 350-word summary with 2 references, Do you think these characteristics of employee involvement are a function of the fact that you are in one unit of a very ...

1 how can the similar-to-me effect result in illegal

1. How can the similar-to-me effect result in illegal discriminatory bias? A. When employees are rated close to average in all areas B. When an employee is rated on all aspects of the job based on one behavior C. When em ...

A joe was walking in a park and found a watch he took it to

a) Joe was walking in a park and found a watch. He took it to the City's lost and found, but it was not claimed. Three years later, Joe went to this lost and found and asked for the watch and was told that it was a prope ...

1 which is more important -- public safety or the

1. Which is more important -- public safety or the protection of Americans’ constitutional rights and liberties? List 3-5 reasons. 2. Should federal authorities be allowed to gain access to Americans’ business records (e ...

Answer both questions below about the eoq modela in the eoq

Answer both questions below about the EOQ model. a) In the EOQ model, unit product cost or selling price, C, is not included in the formula we use to solve for the economic order quantity. Explain why it is not necessary ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert