Solver Assignment Wait Line Models

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 into 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 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. Before you begin, be sure to watch the video below: https://www.youtube.com/watch?v=EMnDdH8fdEc&feature=emb_imp_woyt

ASSIGNMENT INSTRUCTIONS 

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. To get started, download this Excel file Download download this Excel file. There is no need to set up anything! The Excel file has all the formulas included. You need only to 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? Traffic intensity? 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.