Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Town Taxi uses three dispatchers to handle requests for service and to dispatch the cabs. The telephone
calls that are made to Town Taxi use a common number. When all dispatchers are busy, the caller hears
a waiting song until the first dispatchers becomes available. The telephone system will assign available
dispatcher to the waiting callers according to FCFS. Assume that the arrival of calls follows a Poisson
distribution, with an average of 35 calls per hour. Also assume that the time that each dispatcher spends
with a customer follows Exponential distribution and each dispatcher takes an average of 3 minutes with
each caller.
15.What is the average time in minutes that a customer spends in the system?
3.8 mins
7 mins
4.8 mins
8.9 mins
Zimmerman’s Bank is the only bank in the small town of St. Thomas. On a typical Friday, an average of 10 customers per hour arrive at the bank to transact business. There is one teller at the bank, and the average time required to transact business is 4 minutes. It is assumed that service times may be described by the exponential distribution. A single line would be used, and the customer at the front of the line would go to the first available bank teller. If a single teller is used, find:
The average time in the line.
The average number in the line.
The average time in the system.
The average number in the system.
The probability that the bank is empty.
Explain the concept of queue and queue theory or waiting line theory and its importance in business
A bank has only one counter for its customers. Suppose that the customers to the bank arrive at random with exponential inter arrival time and their mean inter arrival time is 10 minutes. Suppose the counter takes on an average 15 minutes to serve the customer and this also follow an exponential distribution.
What percentage of time the bank counter is busy?
On the average, how many customers are in the system?
On the average, how many customers are in the queue waiting for the service?
How long a customer will take to be out of the service system after being served?
How long a customer to wait before being served?
What is the probability that there are at most three customers in the system?
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- A fast-food restaurant offers a variety of products: from pre-made packaged sandwiches to milkshakes with different flavors. Many customers order one item time, other customers order multiple items. Sometimes customers buy the pre- made items, and some customers actually ask the restaurant to cook their food while they wait. The restaurant manager has kept careful records of some queuing statistics over several weeks. According to this data, the staff needs 4 minutes on average to serve a random customer. On average, the restaurant served 120 customers on a given day. This restaurant is open from 9 AM to 9 PM every day, and has a single service counter. If you want to help the manager measure this restaurant's waiting line performance, which of the following should you use? Exponential Service Rate Model The Finite Source Model Constant Service Rate Model O The multi phase single channel modelarrow_forwardOn a toll road, there are 4 lanes for drivers to pay their toll. Customer arrival times are random, with a general independent distribution. Service times are random, with an exponential distribution. What is the proper description for this queueing system? Proper descriptionarrow_forwardA radio repairer notes that the time he spends on his job has an exponential distribution with a mean of 4 minutes. He follows the first come first serve principle. The arrival time of clients takes a Poisson distribution with an average rate of 8 clients every 1 hour.Determine the arrival rate value , service rate value to be used,time taken by aclient waiting in the queue Determine the client’s average waiting time in the system and Compute the probability that the system is idle; P (idle)arrow_forward
- Queuing theory refers to the fundamental concepts of a phenomenon that we constantly experience, the concept of queues. These queues are in production processes, such as in banks, service providers, etc.Based on the concepts of Production Modeling and Simulation, do the following: a) Assuming that cars arrive at a toll, on average, every 0.5 minutes, and the toll has only one payment window, and both the time between arrivals and the time between calls follow an exponential distribution. The toll attendant takes an average of 0.3 minutes to collect. Calculate the system performance measures, ie the car arrival rate and the toll service rate.arrow_forwardRay is planning to open a small car-wash operation for washing just one car at a time. He must decide how much additional space to provide for waiting cars. Ray estimates that customers would arrive according to a Poisson input process with a mean rate of 1 every 4 minutes, unless the waiting area is full, in which case the arriving customers would take their cars elsewhere. The time that can be attributed to washing one car has an exponential distribution with a mean of 2 minutes. Suppose that Ray makes an average $4 per served customers. Moreover, each car space rented for waiting costs $800 per month. Ray is planning to run the car-was for 200 hours every month. 2. How much space should Ray provide for the waiting cars in order to maximize his expected net profit? (By net profit, we mean profit from car-wash operations minus the rental cost)arrow_forwardOn a toll road, there are 5 lanes for drivers to pay their toll. Customer arrival times are random, with a general independent distribution. Service times are constant, with a degenerate distribution. What is the proper description for this queueing system?arrow_forward
- Neve Commercial Bank is the only bank in the town of York, Pennsylvania. On a typical Friday, an average of 12 customers per hour arrive at the bank to transact business. There is one teller at the bank, and the average time required to transact business is 4 minutes. It is assumed that service times may be described by the negative exponential distribution. A single line would be used, and the customer at the front of the line would go to the first available bank teller. If a single teller is used, find: 1. The average time in line 2. The average number in the line 3. The average time in the system 4. The average number in the system 5. The probability that the bank is empty 6. CEO Benjamin Neve is considering a second teller (who would work at the same rate as the first) to reduce waiting time for customers. A single line would be used, and the customer at the front of the line would go to the first available bank teller. He assumes that this will…arrow_forwardThe manager of a bank wants to use an MyMys queueingmodel to weigh the costs of extra tellers against the costof having customers wait in line. The arrival rate is 60customers per hour, and the average service time is fourminutes. The cost of each teller is easy to gauge at the$11.50 per hour wage rate. However, because estimatingthe cost per minute of waiting time is difficult, the bankmanager decides to hire the minimum number of tellersso that a typical customer has probability 0.05 of waitingmore than five minutes in line.a. How many tellers will the manager use, given thiscriterion?b. By deciding on this many tellers as “optimal,” themanager is implicitly using some value (or some range of values) for the cost per minute of wait-ing time. That is, a certain cost (or cost range) would lead to the same number of tellers as sug-gested in part a. What is this implied cost (or cost range)?arrow_forwardA horologist (watchmaker) is typically able to service a mechanical watch in about 120 minutes (exponential distribution). Assuming an 8 hour work-day, the watchmaker averages 3 customers arriving at his shop every day following a poisson distribution. The watchmaker just purchased a new machine that will polish the dial and crystal reducing his service time by 20 minutes per watch. How much will the line for a watch waiting to be serviced be reduced by the watchmaker using this new machine, assuming no increase in customer demand? O 2.25 watches waiting for service O The number waiting to be serviced will be reduced by about 1.2 watches O The number waiting to be serviced will be reduced by about 0.4 watches The number waiting to be serviced will be reduced by about 1.45 watchesarrow_forward
- On a toll road, there are 2 lanes for drivers to pay their toll. Customer arrival times are constant, with a degenerate distribution. Service times are random, with an exponential distribution. What is the proper description for this queueing system?arrow_forwardQueuing Modelsarrow_forwardPlease solve this in excel. Ray is planning to open a small car-wash operation for washing just one car at a time. He must decide how much additional space to provide for waiting cars. Ray estimates that customers would arrive according to a Poisson input process with a mean rate of 1 every 4 minutes, unless the waiting area is full, in which case the arriving customers would take their cars elsewhere. The time that can be attributed to washing one car has an exponential distribution with a mean of 2 minutes. Suppose that Ray makes an average $4 per served customers. Moreover, each car space rented for waiting costs $800 per month. Ray is planning to run the car-was for 200 hours every month. 2. How much space should Ray provide for the waiting cars in order to maximize his expected net profit? (By net profit, we mean profit from car-wash operations minus the rental cost)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,