please help

OH 335, Queueing Theory (best done using Excel) You are the General Manager of a car rental company that maintains a fleet of 115 Compact and Hybrid (or \"High Mileage Vehicle\" (HMV)) vehicles. The arrival time between requests for a HMV is .75 hours on average, with a standard deviation of 1.0 hours. Assume that, if all HMVs are rented, customers are willing to wait until there is an HMV available. An HMV is rented, on average, for48 hours, with a standard deviation of 12 hours. Assume the company is open 24 hours a day. 1) How long is a customer waiting in line, on average? 2) How many HMVs are being rented on average? 3) How many HMVs are in the lot ready to be rented, on average? Assume that you are currently protable, but you are hearing rumblings that your corporate parent is in some nancial trouble. You came into this role 3 months ago and you are winning awards for customer satisfaction (one of the key measurements is how long customers have to wait for a car). You have done some market study and found that customers will continue to provide superior feedback on satisfaction as long as they don't have to wait any longer than 30 minutes for the car of their choice. Likewise they will give poor feedback if they have to wait over an hour. Each HMV costs $10,000 per year to have in the eet when factoring in depreciation, maintenance, and amortized purchase price. Corporate leadership has stated clearly that they need at least $500,000 per year more prot to stay viable as a company, and they have asked you to help identify savings. More savings could lead to a promotion, but only if you are able to maintain customer satisfaction levels. 4) Lay out a plan that saves the company at least $500,000 but maintains customer satisfaction levels in the coming year. 5) What is the very best you can do and keep wait times under an hour? Aside from change the number of vehicles what else would you do to impact performance?|