Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Catherine Blake, the office manager for the College of Business Administration, has received numerous complaints lately from several department chairpersons. In the past few months, the chairpersons have insisted that something be done about the amount of time their administrative assistants waste waiting in line to make copies. Currently, the college has two photocopy centers dedicated to small copying jobs: copy center A on the third floor and copy center B on the fourth floor. Both centers are self-serve and have identical processing capabilities. The copying machines are not visible to the administrative assistants from their offices. When copying is required, the administrative assistant goes to the copy room and waits in line to make the necessary copies. Catherine’s assistant, Brian, was assigned to investigate the problem.Brian reported that, on average, administrative assistants arrive at copy center A at the rate of 10 per hour and at copy center B at the rate of 14 per…
The new-accounts officer at the Bank enrolls all new customers in checking accounts. During the three-week period in August encompassing the beginning of the new school year at UTT, the bank opens many new accounts for students. The bank estimates that the arrival rate during this period will be Poisson distributed with an average of five (5) customers per hour. The service time is exponentially distributed with an average of 15 minutes per customer to set up a new account. The bank wants to determine the operating characteristics for this system to determine if the current person is sufficient to handle the increased traffic.
What is the probability of no customers in the system?
What is the average number of customers waiting in the bank?
What is the average time the customer spends in the bank?
What is the average number of customers waiting in the line?
What is the average time that a customer spends in the line?
Is the number of tellers sufficient to handle the increase…
Bill First, general manager of Worthmore Department Store, has estimated that every hour of customer time spent waiting in line for a sales clerk to become available costs the store $100 in lost sales and goodwill. Customers arrive at the checkout counter at the rate of 30 per hour, and the average service time is 3 minutes. The Poisson distribution describes the arrivals and the service times are exponentially distributed. The number of sales clerks can be 2, 3, or 4, with each one working at the same rate. Bill estimates the salary and benefits for each clerk to be $10 per hour. The store is open 10 hours per day.
(a) Find the average time in the line if 2, 3, and 4 clerks are used.
(b) What is the total time spent waiting in line each day if 2, 3, and 4 clerks are used?
(c) Calculate the total of the daily waiting cost and the service cost if 2, 3, and 4 clerks are used. What is the minimum total daily cost?
Chapter 5 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
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
- All airplane passengers at the Lake City Regional Airport must pass through a security screening area before proceeding to the boarding area. The airport has three screening stations available, and the facility manager must decide how many to have open at any particular time. The service rate for processing passengers at each screening station is 3.5 passengers per minute. On Monday morning the arrival rate is 4.9 passengers per minute. Assume that processing times at each screening station follow an exponential distribution and that arrivals follow a Poisson distribution. Note: Use Po values from Table 11.4 to answer the questions below. a. Suppose two of the three screening stations are open on Monday morning. Compute the operating characteristics for the screening facility. Round your answer to four decimal places. Po = Round your answers to two decimal places. La = L= W₂ = W = Pw Round your answer to four decimal places. b. Because of space considerations, the facility manager's…arrow_forwardAt Trojans Urgent Care Clinic, there is one triage nurse, 5 nurse practitioners, and 3 doctors. Patients arrive to the triage nurse, and the triage nurse decides if their case can be handled by a nurse practitioner or must be handled by a doctor. The triage nurse can detect patients whose case can be handled by a nurse practitioner in on average 5 minutes with standard deviation 1 minute; however, the triage nurse spends on average 10 minutes with standard deviation 3 minutes with patients whose case is eventually handled by a doctor. Patients seeing a nurse practitioner spend on average 30 minutes with standard deviation 8 minutes with the nurse practitioner, and patients seeing a doctor spend on average 45 minutes with standard deviation 10 minutes with the doctor. 60% of arriving patients are cared for by a nurse practitioner and 40% of arriving patients are cared for by a doctor. Patients leave the Urgent Care Clinic after seeing either the nurse practitioner or the doctor. a) If 8…arrow_forwardThe College of Business and Public Administration at Benton University has a copy machine on each floor for faculty use. Heavy use of the five copy machines causes frequent failures. Maintenance records show that a machine fails every 2.5 days (or l = 0.40 failure/day). The college has a maintenance contract with the authorized dealer of the copy machines. Because the copy machines fail so frequently, the dealer has assigned one person to the college to repair them. The person can repair an average of 2.5 machines per day. Using the finite-source model, answer the followingquestions: a. What is the average utilization of the maintenance person?b. On average, how many copy machines are being repaired or waiting to be repaired?c. What is the average time spent by a copy machine in the repair system (waiting and being repaired)?arrow_forward
- Solve with explanation:arrow_forwardAn M/M/1 queueing system has that customers arrive to it at a rate of 5 per hour, i.e., its interarrival times between two consecutive arrivals follows an exponential distribution with parameter 5 per hour. This question will ask you to evaluate two options for designing the server in the system. Both options for the single server provide the same service for the customers in the queueing system but they cost different amounts to implement. In addition, the total costs of the queuing system are the implementation costs plus the customer costs. Currently, the customer costs are $100 per hour per customer in the queueing system. In comparing these options, it costs us $100 per hour per customer in the queueing system. (a) The first option for the server is one that has a service time that follows an exponential distribution with mean 10 minutes. Determine L, W, Lq, and Wq for this system. (b) The second option for the server is one that has a service time that follows an…arrow_forwardOn average, 100 customers arrive per hour at GothamCity Bank. It takes a teller an average of two minutesto serve a customer. Interarrival and service times areexponentially distributed. The bank currently has fourtellers working. The bank manager wants to compare thefollowing two systems with regard to the average numberof customers present in the bank and the probability that acustomer will spend more than eight minutes in line.■ System 1: Each teller has his or her own line (andno moving between lines is permitted). Arrivingcustomers are equally likely to choose any teller.■ System 2: All customers wait in a single line forthe first available teller.If you were the bank manager, which system wouldyou prefer?arrow_forward
- Please build and simulate the following model in ARENA.In this model, car loan applications arrive at processing center approximately every 5 minutes. At this point, 1 of 5 loan officers will review the application to ensure that it is complete. This review step usually takes 15 minutes, but can be as short as 12 minutes or as long as 18 minutes. Applications are sent to an automatic processing machine where they are processed. This process can take from 0.5 to 1.5 hours to complete, but usually requires 1 hour. It is assumed that the automatic processor can process as many applications as needed.After processing, the results are reviewed by a loan officer who will write either an acceptance or rejection document. This task usually takes 7 minutes, but can require anywhere from 5 to 10 minutes to complete.At this point the loan application process is complete, and the acceptance or rejection document is sent to the customer.Run this simulation for one 8-hour day (5 replications).arrow_forwardScenario Office Equipment, Inc. (OEI) leases automatic mailing machines to business customers in Fort Wayne, Indiana. The company built its success on a reputation of providing timely maintenance and repair service. Each OEI service contract states that a service technician will arrive at a customer’s business site within an average of 3 hours from the time that the customer notifies OEI of an equipment problem. Currently, OEI has 10 customers with service contracts. One service technician is responsible for handling all service calls. A statistical analysis of historical service records indicates that a customer requests a service call at an average rate of one call per 50 hours of operation. If the service technician is available when a customer calls for service, it takes the technician an average of 1 hour of travel time to reach the customer’s office and an average of 1.5 hours to complete the repair service. However, if the service technician is busy with another customer when a…arrow_forwardDiscuss how the principle of queues can be used when designing queueing schemes to reduce overall service costs?arrow_forward
- Each airline passenger and his or her luggage must bechecked to determine whether he or she is carrying weaponsonto the airplane. Suppose that at Gotham City Airport, anaverage of 10 passengers per minute arrive (interarrivaltimes are exponential). To check passengers for weapons,the airport must have a checkpoint consisting of a metal detector and baggage X-ray machine. Whenever a check-point is in operation, two employees are required. A checkpoint can check an average of 12 passengers perminute (the time to check a passenger is exponential). Underthe assumption that the airport has only one checkpoint,answer the following questions:a What is the probability that a passenger will have towait before being checked for weapons?b On the average, how many passengers are waiting in line to enter the checkpoint? 1082 CHAPTER 2 0 Queuing Theoryc On the average, how long will a passenger spend atthe checkpoint?arrow_forwardIn the central railway station, 15 computerised reservation counters are available. A customer can book his/her ticket in any train on any day in any of these computerised reservation counters. The average time spent on each customer by each clerk is five minutes. Average arrivals per hour during three types of activity periods have been calculated and customers have been surveyed to determine how long they are willing to wait during each type of period. Customer's acceptable waiting time (minutes) Туре of period Arrivals per hour Peak 110+XX 10+X Normal 60+XX 5+X Low 30+XX 2+X Making suitable assumptions on this queuing process, determine how many counters should be kept open during each type of period. XX = last two digits of your roll no. and X = last digitarrow_forwardThe Riverton Police Department has eight patrol cars thatare on constant call 24 hours per day. A patrol car requiresrepairs every 30 days, on average, according to an exponential distribution. When a patrol car is in need of repair it isdriven into the motor pool, which has a repairperson onduty at all times. The average time required to repair a patrol car is 12 hours (exponentially distributed). Determinethe average time a patrol car is not available for use and theaverage number of patrol cars out of service at any onetime, and indicate if the repair service seems adequatearrow_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,