In an effort to better understand its customers’ needs, Magic Suds Car Wash has collected data regarding customer arrivals and service capacity. In a typical day, customers arrivals range between 4 and 7 per hour. Magic Suds is capable of serving 5 to 8 customers per hour. Customers are served on a first-come, first-served basis. Probability distributions for customer arrivals and service capacity are shown in the tables below. Using Excel, the car wash process was simulated for a period of 10 hours; the results are reported below. The random numbers for the simulation (labeled as RN1 and RN2) were generated using the function, =RAND(). If you can’t see table/image, then contact tech support! a). Why would the service rate vary? Identify at least two (2) reasons why the rate at which customers are served would fluctuate. b). For hour 7 above (row 19), very briefly indicate how the numbers in each column were computed or derived. You may write a formula or a few words for each item. Waiting (column B): Customer Arrivals (column D): Possibly Served (column G): Actually Served (column H): c). What is the average number of customers waiting to be served? (Be sure to show work/explain reasoning.) d). What is the average number of customers actually served? (Be sure to show work/explain reasoning.) e). Jorge Martinez, the manager of Magic Suds, is skeptical of the numbers computed above in parts c and d. List two (2) reasons why Martinez’s skepticism is justified.

In an effort to better understand its customers’ needs, Magic Suds Car Wash has collected data regarding customer arrivals and service capacity. In a typical day, customers arrivals range between 4 and 7 per hour. Magic Suds is capable of serving 5 to 8 customers per hour. Customers are served on a first-come, first-served basis. Probability distributions for customer arrivals and service capacity are shown in the tables below. Using Excel, the car wash process was simulated for a period

AllEscort