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