PLEASE USE EXCEL, SHOW ALL THE STEPS AND DO ALL THE PARTS. YOU can email me the finished excel at - wmango19 @ g mail . com

Trucks wait in a single queue at an unloading facility where they are unloaded [in FCFS order} by a crew ofm workers. \"the arrival rate is on average 10 trucks per hour, Poisson distributed. The time taken by a crew of m workers (working together on a truck] to unload a truck is exponentially distributed with a mean of 30in} minutes. a. Which queueing model would you use for this situation? Explain. b. What is the minimum crew size m needed to have a viable queueing system? (Hint: steady state] c. Using the value of m that you find in {bi answer the following questions: 1. What is the average number oftrucks waiting to be unloaded? What is the average wait time for a ti'UCk before it can be unloaded? What percent ofthe time is the crew busy? What is the probability that there are no trucks waiting to be unloaded? The unloading faciiity has a policy that states there should be a high chance, i.e., at least 95%, that a truck waits no more than 30 minutes before being unloaded. What is the 5395\"!" crew size m that is needed to ensure that this poiicy is followed? d. Draw graphs that show the relationship between crew size and each of the following. Comment on what each graph is tellling you. 1. Utilization 2. Average time in line