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
During an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.
Based on Kolesar et al. (1974), Metropolis PD Precinct 88 must determine the minimum number of police cars required to meet its needs for the next 24 hours. An average call for service requires 30minutes. The number of calls the police department expects to receive during each hour is shown in the file P12_61.xlsx. The Metropolis PD standard of service is that there should be a 90% chance that a car is avail-able to respond to a call. For each of the following,discuss how you might find a solution.a. Suppose that patrol officer teams assigned to a car work an 8-hour shift beginning at 12 a.m., 8 a.m., or 4 p.m. Officers get an hour off for a meal. This hour can be anytime between the second and fifthhour of their shift. The precinct wants to know how many teams are needed to meet daily demand.b. Suppose that patrol officer teams assigned to a car begin their 8-hour shifts at 12 a.m., 8 a.m., 12 p.m., 4 p.m., and 8 p.m. An hour off for meals may be taken anytime during a shift. The…
The 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)?
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
- 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 new…arrow_forwardThe average time between the arrivals of the taxis arriving at the airport to pick up passengers has an exponential distribution, with an average of 10 minutes. a) What is the probability that a passenger will wait for the taxi less than 15 minutes? b) What is the probability that a passenger will wait for the taxi between 20 and 30 minutes? Solve using the cumulative distribution function H1arrow_forwardEasy Moving, a moving company, is seeking outside advice from a consultant (you) about the appropriate selection measures to use to analyze job candidates. The position that the company most often hires for is a Driver/Mover. Individuals in this job must be able to drive long hours, and lift and carry heavy objects for long periods of time. When people are moving from one home to another they contact Easy Moving to take care of relocating all of their belongings. The people responsible for the move are the Drivers/Movers. Because driving a truck is an essential function of the job, individuals must not only be physically capable of driving, but also must have an impeccable driving record. Driving a truck can be considered a safety hazard if the individuals were not in the right frame of mind to be a good driver. Easy Moving should keep these things in mind when analyzing applicants. Additionally, individuals applying for a Driver/Mover position with Easy Moving must have the physical…arrow_forward
- 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_forwardWhat is the answer in this number 4?arrow_forwardYour company has a very complex conveyor system in the warehouse. The conveyors take product from a receiving dock and route them to one of ten different shipping points on the shipping dock. The conveyors are controlled by computers. You need to find an employee maintain this computer system on the night shift. Your assignment recruit an employee to fill this position. How would find a qualified candidate?arrow_forward
- Patxiko just opened his website, where he sells his Patxaran online. His websites gatheres all kinds of data from customers navigation (time spent on each page, how long the customer has products in his cart before purchasing, what he purchased, etc). He is trying to optimize the website to increase the probability of a purchase. First, he wants to predict whether a customer will purchase or not. What model would you advise him to use? Suggest two methods and explain how one of them works.arrow_forwardOffice 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 three hours from when the customer notifies OEI of an equipment problem. Currently, OEI has ten 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. Suppose the service technician is available when a customer calls for service. In that case, 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…arrow_forward(Physics: acceleration) Average acceleration is defined as the change of velocity divided by the time taken to make the change, as shown in the following formula: a = (v1 - v0) / t Here, v0 is the starting velocity in meters/second, v1 is the ending velocity in meters/second, and t is the time span in seconds. Assume v0 is 5.6, v1 is 10.5, and t is 0.5, and write the code to display the average acceleration. If you get a logical or runtime error, please refer https://liangpy.pearsoncmg.com/faq.html.arrow_forward
- Hi, would you be able to help me with this question? Thanksarrow_forwardGraph and Solve. Kindly show the probabilities and explain how to solve this question. The time between arrival of customers at the drive-up window of a bank follows an exponential distribution with mean of 8 minutes. a.What is the probability that arrival time between customers will be 10 minutes or less? b.What is the probability that arrival time between customers will be between 5 and 9 minutes?arrow_forwardUsers are connected to a database server through a network. Users request files from the Database server. The database server takes a period of time that is exponentially distributed with mean 5 seconds to process a request. Find the probability that 10 requests are processed by the server during the first 1 minutes. Determine the probability that no request is processed by the server during the first 2 minutes Determine the average number of requests processed in 2 minutesarrow_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,