Response to the following problem:
Customers arrive at Ted's TV Repair shop according to a Poisson process at an average of once every 2.5 hours. By using existing equipment, the service time to repair a television set is 2.25 hours with a standard deviation of 45 minutes. Suppose Ted decides to hire a second repair person and this person also takes an average of 2.25 hours to fix a television with a standard deviation of 45 minutes.
a. Assuming that the service time of both Ted and his assistant follows a normal distribution, develop an Excel simulation for this system.
b. Run the simulation for 1000 customers and determine the average time a television set spends at the shop by excluding the first 100 customers.