No matter the business or the location, wait lines are found in every business and every day. Wait lines exist anywhere and everywhere \u2013 from fast food restaurants and manufacturing operations, to airline passenger boarding and prescription refills. We all have to wait for some good or service.\u00a0 As an example, consider how long it took you to renew your driver\u2019s license.\u00a0 How long did it take you to buy that last minute loaf of bread?\u00a0
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.\u00a0 Wait lines must be analyzed and kept to a minimum cycle time.
Another tool in the MBA\u2019s Management Science toolbox is the Wait Line Model.\u00a0 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.\u00a0
The Excel setup for this problem is\u00a0embedded here\u00a0\u00a0download.\u00a0 There is no need to set up anything!\u00a0 The embedded Excel file has all the formulas included.\u00a0 You need only plug in the different values called out below to solve this Wait Line problem!
Assume you are in a medical provider\u2019s office and there is a single provider. The waiting room is full.\u00a0 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?\u00a0
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.
Unit 3 Assignment 2Unit 3 Assignment 2CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeContentAll requirements of the assignment are met. Calculations of the 9 questions are correct.70\u00a0ptsFull Marks0\u00a0ptsNo Marks70\u00a0pts
This criterion is linked to a Learning OutcomeJustificationExplains the implications of the wait line model on business. Narrative content demonstrates sufficient elaboration and explanation of calculations.20\u00a0ptsFull Marks0\u00a0ptsNo Marks20\u00a0pts
This criterion is linked to a Learning OutcomeMechanicsFile is organized and has a logical sequence.10\u00a0ptsFull Marks0\u00a0ptsNo Marks10\u00a0pts
Total Points:\u00a0100<\/p>\n","protected":false},"excerpt":{"rendered":"
No matter the business or the location, wait lines are found in every business and every day. Wait lines exist anywhere and everywhere \u2013 from fast food restaurants and manufacturing operations, to airline passenger boarding and prescription refills. We all have to wait for some good or service.\u00a0 As an example, consider how long it […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[15],"class_list":["post-10302","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-business"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/10302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=10302"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/10302\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=10302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=10302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=10302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}