Start of each time period to minimize total staff required

Assignment Help Operation Management

Reference no: EM13970609

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

Reference no: EM13970609

Questions Cloud

Why these two are reacting differently to their jobs : Tony and Carol work as home sales representatives. After work Tony often comes home a migraine headache and feeling emotionally exhausted. Tony has difficulty sleeping before and after a long day at work. When dealing with stress, give three explanat..

Implemented goal-setting strategy within organizational team : A car manufacturing company has implemented a goal-setting strategy within the organizational teams. The goal-setting program brought forward encouragement and reminders by all team leads to their respective teams. Can you explain why goal setting di..

Explain frustration and un-satisfaction : Tom and Jerry are friends who work as marketing managers for different companies in the food industry. Upon a recent discussion, Tom discovered that Jerry's salary was nearly 20% higher than Tom's salary. Using the equity theory, how would you explai..

Formulate the linear programming equations : Jim Jones manufacturer’s inexpensive set-it-up-yourself furniture for students. He currently makes two products- bookcase and tables. Each bookcases and contributes $6 and each table contributes $7 towards profit. Formulate the linear programming equ..

Start of each time period to minimize total staff required : 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 i..

The opt-in statement : Assume you are working for a company that sells music online. The marketing department would like to send e-mails to customers who have purchased music from the Web site. These e-mails would use information about the genres of music customers have p..

Advertising regulation on the internet : Research and apply the content from recent articles about Advertising Regulation on the Internet. Write a minimum of 3 to 5 pages for the body of the research paper discussing your viewpoint on the topic.

What is the economic order quantity for this product : The winter company sells 8640 industrial pumps each year. each of pumps has a bulit-in filter that winter purchases from a supplier. it costs winter $20 to place an order for these filters and $1.50 per unit to hold them in inventory. what is the eco..

Skills integrate with the critical skills selected : Of the 9 skills listed above, select 4 skills you feel are most critical for facility manager. Develop at least 2 well written reasons for each of the 4 skills. How do remaining 5 skills integrate with the 4 critical skills selected above?

User Account

All Pages