Details of this Paper

Question needs to be answered using the attached t...




Question needs to be answered using the attached template in excel and using excel's solver. 8-3 (Restaurant work scheduling problem). The famous Y. S. Chang Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 A.M., 7 A.M., 11 A.M., 3 P.M., 7 P.M., or 11 P.M., 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. Add this additional constraint: Total Number of Workers to Start the Shifts must be less than or equal to 31.,Thank you


Paper#8309 | Written in 18-Jul-2015

Price : $25