Donna Shader, manager of the Winter Park Hotel, is considering how to restructure the front desk to reach an optimum level of staff efficiency and guest service. At present, the hotel has five clerks on duty, each with a separate waiting line, during peak check-in time of 3:00 P.M. to 5:00 P.M. Observation of arrivals during this period shows that an average of 90 guests arrive each hour (although there is no upward limit on the number that could arrive at any given time). It takes an average of 3 minutes for the front-desk clerk to register each guest. Ms. Shader is considering three plans for improving guest service by reducing the length of time that guests spend waiting in line. The first proposal would designate one employee as a quickservice clerk for guests registering under corporate accounts, a market segment that fills about 30% of all occupied rooms. Because corporate guests are preregistered, their registration takes just 2 minutes. With these guests separated from the rest of the clientele, the average time for registering a typical guest would climb to 3.4 minutes. Under this plan, noncorporate guests would choose any of the remaining four lines. The second plan is to implement a single-line system. All guests could form a single waiting line to be served by whichever of five clerks became available. This option would require sufficient lobby space for what could be a substantial queue. The use of an automatic teller machine (ATM) for check-ins is the basis of the third proposal. This ATM would provide about the same service rate as would a clerk. Because initial use of this technology might be minimal, Shader estimates that 20% of customers, primarily frequent guests, would be willing to use the machines. (This might be a conservative estimate if guests perceive direct benefits from using the ATM, as bank customers do. Citibank reports that some 95% of its Manhattan customers use its ATMs.) Ms. Shader would set up a single queue for customers who prefer human check-in clerks. This line would be served by the five clerks, although Shader is hopeful that the ATM machine will allow a reduction to four.

1. Determine the average amount of time that a guest spends checking in.

2. How would this change under each of the stated options? Which option do you recommend?

Please show step by step caluclations in Excel