dont do it on excel

(26 marks) The local Irish Newfoundland band, Hey Blarney, is getting reading to open up for live performances again, with ticket sales beginning next week. a) (9 marks) The band has a small ticket kiosk with one clerk working the counter. From previous seasons, 5 customers per hour arrive to the ticket. On average, it takes 8 minutes to serve each customer. Find the following measures of performance of the ticket kiosk: i. What is the average utilization of the ticket kiosk clerk? ii. On average, how many customers are waiting in line? iii. What is the average time in minutes) a customer spends waiting for service at the ticket kiosk? iv. What is the probability that a customer waits 20 or more minutes to be served? b) ( marks) One of the newer band members mentioned about selling tickets online. From her experience with a previous band, an online site has customers 'arriving' at a rate of 27 per hour. The site is arranged so that customers can view their options while waiting in a queue for a 'system server'; there are 3 'system servers' and it takes 6 minutes to 'serve' the customer. Find the following measures of performance of the online ticket system: i. How many people on average are waiting to be served? ii. How many people on average would be in the online system (including those being served)? iii. If a person has to wait, what is the average wait time in minutes)? iv. What is the probability (as a percentage) of a person having to wait? c) (10 marks) The number of 'system servers' costs the band $5/hour and each customer in the system'costs' the band $2/hour. Use the table below to show the different values and costs needed to determine how many 'system servers' the band should purchase to minimize their total cost. State your recommended number of system servers