pls help

OM 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, for 48 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? Notes/Formulas A13 is (p/m) and the formula for 3 is m-le In is (1/a) * p To calculate t/q use (p/m) * (Util^A1341 - util)) * (CVa2 + CVP2 / 2). (p/m) * (util^(sqrt(2(m+1))-1)/(1-util) * (CVa^2 + CVp^2)/2 |