pls solve with excell

2. (50 points) Murteza is an entrepreneur and plans to open PIRILDAK CAR WASH company at a shopping mall's parking area. Murteza thinks about a car washing facility with 1 server. Washing bay requires 3 parking lots and he needs parking lots for waiting customer cars, too. His agreement with the mall management includes 3 lots for washing, but not any other lot for waiting cars. Each extra lot's rent (for waiting cars) is 1000 TL / year. On average, 5 customers/hr. arrive to PIRILDAK CAR WASH and it takes 10 min. to wash a car. Price for washing service is 20 TL/car. Shopping time for a customer is 30 min. Service (i.e., washing) time and interarrival times are exponentially distributed, but shopping time is almost constant. When average time to wash a car exceeds this time, Murteza assumes a waiting cost of 10 TL / hr for each customer. Murteza also considers lost customer as cost. (a) (25 points) Considering renting lots for waiting cars between 0 and 10, make a queue analysis that gives the expected profit for Murteza. Find the best value of lots to rent. (For example; renting 0 lots means there are 3 lots for washing but no other lots for waiting cars, so any car arriving while there is a car washed, leaves the system.) (b) (25 points) Shopping mall offers Murteza pay rent for Z lots, use all parking lots. Comparing M/M/1/GD/00 / solution (where rent is defined w.r.t. Z lots) with best M /M/1/GD/c/c solution, calculate Z for Murteza. Comment on Z