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
A self-service store employs one cashier at its counter. Nine customers 'arrive on an average
every 5 minutes while the cashier can serve 10 customers in 5 minutes. Assuming Poisson
distribution for arrival rate and exponential distribution for service time, find
1. Average number of customers in the system.
2. Average number of customers in the queue or average queue length.
3. Average time a customer spends in the system.
4. Average time a customer waits before being served.
A.1
Customers arrive at Best-Bank-in-Town’s (BBT) sole ATM location at a rate of 21 customers per hour. It is assumed that the arrival process is random. BBT recently hired an intern who estimated that the average service time is 2 minutes per customer with a standard deviation of 1.2 minutes. [Assume that the arrival rate is the same throughout the day without peak and off-peak considerations and that there is only one ATM machine at that location]
1. Calculate average waiting time for ATM user at the BBT location
2. Calculate average length of queue at the ATM location (i.e. average numbers of customers waiting for service)?
3. What is the probability that an arriving customer has no waiting time to use the ATM?
4. BBT wants to cut the average waiting time in half without necessarily adding another ATM machine. They are in discussions with their ATM software provider who has told them that their new software is very consistent with information retrieval and can greatly minimize the…
Customers arrive to a local bakery with an average time between arrivals of5 minutes. However, there is quite a lot of variability in the customers’ arrivals, asone would expect in an unscheduled system. The single bakery server requires anamount of time having the exponential distribution with mean 4.5 minutes to servecustomers (in the order in which they arrive). No customers leave without service.d. Calculate the probability a customer will spend more than an hour at the bakery(time in queue plus service time).
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
- During nearly four decades of business operations, Memphis-based FedEx has earned a reputation for reliable, on-time delivery of packages to homes and offices around the country. Founder Fred Smith originally focused on overnight deliveries, choosing Memphis as the company’s headquarters because the airport rarely closes due to bad weather. With FedEx’s planes departing and arriving on schedule nearly all the time, its express shipments usually remained on schedule, then and now. To reassure customers that delivery will take place when and where promised, the firm offers a money-back guarantee on time-sensitive express shipments, among other services. FedEx has steadily expanded its portfolio of services since the 1970s. Its original overnight express delivery is currently available to U.S. customers in various forms, including “first-overnight” delivery, next-morning delivery, next-afternoon delivery, and budget-pleasing two- or three-day delivery. The company’s services also include cost-effective ground delivery for parcels and extra-speedy same-day delivery for urgent deliveries within 1,800 cities. Over the years, FedEx has widened its delivery network to more than 220 countries. It has purchased more cargo jets and acquired specialized shipping firms, including Tiger International, Roberts Express, RPS, and TNT Express, to support global growth. For international business customers needing products, parts, or raw materials shipped across countries or continents, the company now offers time-saving services such as commercial freight forwarding and cross-border logistical support. To add the convenience of local drop-off and pickup points for U.S. consumers and small businesses, FedEx acquired the Kinko’s office services company in 2004 and later rebranded it as FedEx Office. This acquisition also added printing and copying to the menu of services offered. Then the company arranged for large U.S. retailers such as Walgreens, Albertsons, Kroger, and Safeway to accept packages for shipment and receive package delivery for customer pickup in thousands of store locations. This means people who want to send a package can head to a nearby retailer and ship where they shop, rather than making a separate trip to the FedEx location. It’s also a safe alternative for packages to be picked up by people who don’t want FedEx shipments left by the front door. Another service FedEx offers to small and mid-sized businesses, including retailers, is FedEx Fulfillment. The purpose is to expedite order fulfillment by having each business store its products in a FedEx warehouse. Then, when the business’s customers place orders, FedEx puts the products into boxes bearing the business’s own logo and ships directly to those customers. The business doesn’t need a separate warehouse or staff for fulfillment, and packages are on their way to customers more quickly because the products were in FedEx’s warehouse, ready to be packed and shipped. This service puts FedEx into direct competition with Amazon.com, which offers a similar service to merchants that sell through the online Amazon Marketplace. But it also gives businesses that don’t sell via Amazon a fast and professional fulfillment alternative. FedEx is careful to let customers know, through media and social-media announcements, when it anticipates that extreme weather or other conditions will cause delays or force it to halt pickups and deliveries. For the duration of Hurricane Irma, for example, FedEx said it would suspend deliveries in Florida. Some Florida customers who had ordered generators to be delivered via FedEx were unhappy, because they worried about being without power during and after the storm. But one FedEx employee loaded several generator orders into his car and took them to customers himself. When a customer posted a grateful compliment to FedEx on Facebook, the message generated thousands of likes, shares, and positive comments. The company also received positive comments for its donations of cash and transportation services to areas devastated by Hurricanes Irma, Harvey, and Maria. According to the American Customer Satisfaction Index (ACSI), FedEx often tops the list of U.S. shipping companies as ranked by customers surveyed. Every day, the company delivers 13 million packages—and during the busy year-end holiday season, it delivers many more. By meeting customers’ expectations for on-time deliveries, FedEx has increased annual revenues beyond $60 billion and positioned itself for continued growth in the future. How does FedEx’s money-back guarantee address customers’ concerns about heterogeneity?arrow_forwardSolve This Questionarrow_forward[Queuing Theory - Operation research] The take-out counter at an ice-cream parlor is serviced by one attendant. Customers arrive according to a Poisson process, at a mean arrival rate of 30 per hour. They are serviced on a FCFS basis, and because of the quality of the ice cream, they are willing to wait if necessary. The service time per customer appears to be exponentially distributed, with a mean of 1.5 minutes. Determine the following: (a) probability that the system is idle (b) average number of customers in the system (c) amount of time a customer should expect to wait before service (d) probability that a customer will have to spend more than 15 minutes in the queuearrow_forward
- Please do not give solution in image format thankuarrow_forwardIn an M/MA queueing system, the arrival rate is 7 customers per hour and the service rate is 12 customers per hour. 0. What is the utilization? (Round your answer to 3 decimal places.) Utilization b. What is the expected number of customers in the system (L)? (Round your answer to 3 decimal places.) Expected number of customers c. What is the expected waiting time in the system (W? (Express the waiting time in hours, round your answer to 3 decimal places.) Expected waitng timearrow_forwardA request for assistance at the reference desk at a library is submittedat an average rate of 9 per hour (Poisson distribution). At the reference desk, there is only one librarianand he can serve customers in 6 minutes on average (exponential distribution). Calculate according tothe queuing model M/M/1:1. Server utilization2. Expected number of customers in queue3. Expected waiting time of customer in queuearrow_forward
- Many of a bank’s customers use its automated banking machine (ABM). During the early eveninghours in the summer months, customers arrive at an ABM at the rate of one every other minute(assume Poisson). Each customer spends an average of 99 seconds completing the transaction.Transaction times are exponentially distributed. Assume that the length of the queue is not aconstraint. Determine the average time customers spend at the machine, including waiting in line and completing transactions. Determine the probability that a customer will not have to wait upon arrival at the ABM. Determine the utilization of the ABM.arrow_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_forward1. Customers arrive at a single-server queueing system according to a Poisson process at a mean rate of 30 per hour. If the server works continuously, the number of customers that can be served in an hour has a Poisson distribution with a mean of 50. Determine the proportion of time during which no one is waiting to be served.arrow_forward
- Customers arrive at a server queuing system according to a Poisson process with mean rate of 30 per hour. If the server works continuously, the number of customers it can serve in an hour has Poisson distribution with mean 50. } Determine the proportion of the time during which no one waits for service.arrow_forwardAutomobiles arrive at the drive-through window at a post office at the rate of 7 every 10 minutes. The average service time is 7 minutes. The Poisson distribution is appropriate for the arrival rate and service times are exponentially distributed.(Note: the given equations are NOT necessarily in the correct order.) What is the average time a car is in the system? What is the average number of cars in the system? What is the average time cars spend waiting to receive service? What is the average number of cars in line behind the customerreceiving service? What is the probability that there are no cars at the window? What percentage of the time is the postal clerk busy? What is the probability that there are exactly two cars in the system?arrow_forwardMany of a bank’s customers use its automatic teller machine to transact business after normal banking hours. During the early evening hours in the summer months, customers arrive at a certain location at the rate of one every other minute. This can be modeled using a Poisson distribution. Each customer spends an average of 98 seconds completing his or her transactions. Transaction time is exponentially distributed. a. Determine the average time customers spend at the machine, including waiting in line and completing transactions. (Do not round intermediate calculations. Round your answer to the nearest whole number.) b. Determine the probability that a customer will not have to wait upon arriving at the automatic teller machine. (Round your answer to 2 decimal places.) c. Determine the average number of customers waiting to use the machine. (Round your answer to 2 decimal places.)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,MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing