Movie rental store problem

Question
Movie rental store problem

You are looking at opening a new movie rental store. You expect that customers will arrive at the store that will have one cashier at a mean rate of 30/hour. You need to hire a cashier. You have narrowed the search to two candidates. Tom has a lot of experience but you will have to pay him more. Jane has never been a cashier but you expect you can hire her at a cheaper rate. Both candidates you would expect to have an exponentially distributed service time with Tom having a mean of 1.2 minutes and Jane of 1.5 minutes. Revenue per month for the store is given by $6000/Ws where Ws is the average waiting time (in minutes) of a customer in the system.

a) Compare the time that an average customer spends waiting in line for both Tom and Jane.

b) Compare the utilization rates for both Tom and Jane.

c) Assuming that we hire Tom. We know from experience that if 6 or more people are waiting in line, people will simply go somewhere else. If business grows, what is the maximum customer arrival rate that Tom can service before we need to hire another cashier (hint simply program the equations in Excel and trial and error until you get the desired number)? Assume that we will hire another cashier when the average queue length reached 6. What if we hire Jane instead of Tom?

d) Compare the revenue per month if we hire Tom vs. Jane.

e) What would Ws become if we hired BOTH Tom and Jane. Discuss your choice of using equations or simulation.

Please see attached & solve. Format is Excel. Do parts a, b, and d only (bid reduced to 4 credits).

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."

"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"