Assignment: Chapter 10 Homework: Forecasting and Demand Planning Questions Problem 10-43 Algo (Capacity Measurement) 3. 4. 5. 6. Spreadsheet A hotel hosts banquets for conferences in a large ballroom with tables of eight. Servers must get the meals from the kitchen, bring them out to the tables, and then place the meals on the tables. It takes four minutes to get the meals, bring them out to the tables, and then 15 seconds to serve each guest. Use the Service Capacity Excel template to answer the following questions. 7. O a. If 24 servers are available, how many tables can be served in 24 minutes? Do not round intermediate calculations. Round your answer to two decimal places. tables b. The hotel wants to be able to serve 160 tables in 24 minutes. How many servers are needed? Do not round intermediate calculations. Round your answer to the nearest whole number. servers service_capacity - File Hom Inser Page Form Data Revie View Help Be carefulfiles from the Internet can PROTECTED VIEW contain viruses. Unless Enable Editing you need to edit, it's safer to stay in Protected View. X B6 120 Check My Work -Measurement) Question 5 of 7 B 1 Service Capacity Cengage Learning 2 Not for commercial 3 Enter any two of the three values only in the yellow cells 4 and the spreadsheet will calculate the third. 5 6 Capacity 120 7 Service Rate 12 8 Number of Servers 9 10 Capacity 11 Service Rate 12 Number of Servers 10.00 Save Submit Assignment for Grading