Using Excel\'s solver: The famous YS Chang restaurant is open 24 hours a day. Wa
ID: 1721031 • Letter: U
Question
Using Excel's solver:
The famous YS Chang restaurant is open 24 hours a day. Waiters and busboys report for duty at 3am, 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.(Let Xi equal number of waiters and busboys beginning work in time period i, where i = 1,2,3,4,5,6.)
Period Time Number of waiters and busboys required
3am-7am 3
7am-11am 12
11am-3pm 16
3pm-7pm 9
7pm-11pm 11
11p-3am 4
Add this additional constraint: Total Number of Workers to Start the Shifts must be less than or equal to 31. Problem needs to be solved with excel solver. Thank you.
Explanation / Answer
Let X1 = Number of waiters and busboys at period 1
Let X2 = Number of waiters and busboys at period 2
Let X3 = Number of waiters and busboys at period 3
Let X4 = Number of waiters and busboys at period 4
Let X5 = Number of waiters and busboys at period 5
Let X6 = Number of waiters and busboys at period 6
Period 1 = 3
Period 2 = 14
Period 3 = 3
Period 4 = 8
Period 5 = 4
Period 6 = 0
Period 1, 3 and 5 drop from total 32 workers to 31 each if any of those 3 periods required minimum is reduce by 1. The period I choose (if have to choose 1 only) to make the reduction is period 1. When period 1 reduces by 1, the total number of workers required would drop from 32 to 31. Also, logically it makes sense to have lesser number of workers during the graveyard shift, as the number of customers should be lesser. And also it would save on company transport cost as going to work at 3am means no public transport and therefore would be claimable.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.