Spreadsheet Long lines of patients wait for CAT scanning service in a hospital. Patients arrive for scans at a rate of 1.4 per hour. The average processing time for CAT service is 27 minutes per patient. Your summer internship is in the hospital where you are assigned to help analyze the bottleneck situation. One tool that you think can help evaluate the situation is a single server queueing model. Use the Single Server Queue Excel template to answer the following questions. Do not round intermediate calculations. Round your answers to three decimal places. a. What is the probability that the system is empty? b. What is the probability that a customer must wait for service? c. What is the average number of customers waiting for service in the queue? customer(s) d. What is the average wait time in the queue? hour(s) e. What is the average time spent in the system? hour(s) As the assistant manager of a restaurant, how many servers will you need given the following information for Saturday night's dinner menu: Demand (dinners served) = 90 dinners per hour Server target utilization = 85% Service rate per server = 16 dinners/hour Round your answer up to the nearest whole number. servers The consumer loan division of a major bank wants to determine the size of the staff it would need to process up to 195 loan applications per day. It estimated that each loan officer can process a loan application in approximately 15 minutes. If the utilization of a loan officer is 0.85 (85 percent) and each loan officer works six hours each day, how many loan officers would be needed to handle that volume of business? Round your answer up to the nearest whole number. loan officers A telephone call center uses two customer service representatives (CSRs) during the 8:30 a.m. to 9:00 a.m. time period. The standard service rate is 3.0 minutes per telephone call per CSR. Assuming a target labor utilization rate of 80 percent, how many calls can these two CSRS handle during this half-hour period? Round your answer to the nearest whole number. calls