watch the video on Wait Line Models embedded https://www.youtube.com/watch?v=EMnDdH8fdEc
No matter the business or the location, wait lines are found in every business and every day. Wait lines exist anywhere and everywhere – from fast food restaurants and manufacturing operations, to airline passenger boarding and prescription refills. We all have to wait for some good or service. As an example, consider how long it took you to renew your driver’s license. How long did it take you to buy that last minute loaf of bread?
No matter the situation, customers do not like to wait. Granted, we are all locked in to the Department of Motor Vehicles, but if possible, customers will move to the competition with fewer wait times. Wait lines must be analyzed and kept to a minimum cycle time.
Another tool in the MBA’s Management Science toolbox is the Wait Line Model. The Wait Line problem is a programming tool that is easily solved for with the use of Excel and the proper formulas. The Wait Line Model in an Excel template can solve for mean time between customers, time per service, traffic intensity, utilization rate of server, average number of customers waiting in line, average waiting time, and probability of no customers in the system.
In this assignment you will use the Excel data analysis tool known as Wait Line Single Server, Infinite Population, Poisson Arrival, Constant Service Time, Unlimited Queue Length tool.
The Excel setup for this problem is embedded herePreview the document. There is no need to set up anything! The embedded Excel file has all the formulas included. You need only plug in the different values called out below to solve this Wait Line problem!
Assume you are in a medical provider’s office and there is a single provider. The waiting room is full. Also, assume that the unit of time is hours, arrival rate of customers per hour is .9, and the service rate is .75 customers per hour.
Answer the following questions:
What is the mean time between arrivals?
Exact time per service?
Utilization rate of server?
Average number of customers waiting in line?
Average number of customers in system?
Average time waiting in line?
Average time in system?
Probability of no customers in system?
Explain the implications of this wait line model on business operations. What steps need to be taken to optimize wait times without jeopardizing the health of the business?
Provide a brief narrative of your wait line analyses and describe the importance of the use of this tool for business and industry. Insert this narrative as a text box in the excel file.
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we\'ll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.