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
Gilman Heating and Air Conditioning Gilman Heating and Air Conditioning Inc. provides a broad range of services to commercial and residential customers, including installation and repair of several different brands of heating and air-conditioning systems, Gilman has a fleet of 28 trucks, each operated by one or more service technicians, depending on the size of a job. A recurrent problem for Gilman has been coordinating the service teams during the day to determine the status of a job and the need for parts not kept in the service vehicle, as well as to identify which team to send on emergency calls. Gilman's service area is spread over an urban/rural area of approximately 50 square miles. The company has developed cost and price sheets so that the service technicians accurately and consistently price the service work they perform.
Beeson Co. is experiencing a decrease in sales and operating income for the fiscal year ending December 31st. Julia Faure, controller of Beeson Co., has suggested that all orders received before the end of the fiscal year be shipped by midnight, December 31st even if shipping department must work overtime. Since Beeson Co. ships all merchandise FOB shipping point, it would record all such shipments as sales for the year ending December 31st, thereby offsetting some of the decreases in sales and operating income.Discuss whether Julia Faure is behaving in a professional manner and what are the implications of her actions?
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.
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
- please dont answer in image format. Do type Thnksarrow_forwardChapter 5. (M/M/s/K Model). Leia is responsible for 8 computers in the IT offices in a small business called DataWish. Each computer runs on an average for 3 weeks and requires an average of ½ or 0.5 weeks to get reset by Leia before it can start up again. If we assign the Poisson distribution to the "arrival" of each computer for service and an exponential distribution to the actual service provided, answer the following questions: a. The arrival rate would bel units per week and the service rate would be units per week. b. Calculate the following operating characteristics for the M/M/s/K system: Utilization Factor (p) Performance Measures c. If we assign a cost of waiting as $500 per week per computer and $800 per week of hiring Leia, what is the Total Time Cost per week cost of servicing the machines? PO (probability that sytem is empty) % dollars L (average units in system) units d. If DataWish decides to hire another individual to help Leia, what would the new Total Time Cost per…arrow_forwardChapter 5. (M/M/s/K Model). Leia is responsible for 8 computers in the IT offices in a small business called DataWish. Each computer runs on an average for 3 weeks and requires an average of ½ or 0.5 weeks to get reset by Leia before it can start up again. If we assign the Poisson distribution to the "arrival" of each computer for service and an exponential distribution to the actual service provided, answer the following questions: a. The arrival rate would be units per week and the service rate would be units per week. b. Calculate the following operating characteristics for the M/M/s/K system: Utilization Factor (p) % Performance Measures PO (probability that sytem is empty) L (average units in units system) La (average units waiting in queue) units W (average time in the weeks system) Wq (average time in the queue) weeks c. If we assign a cost of waiting as $500 per week per computer and $800 per week of hiring Leia, what is the Total Time Cost per week cost of servicing the…arrow_forward
- Graph 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_forwardSolve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour?arrow_forwardSolve the question below using the attached excel templates with formulas for renting both slow and fast copies (labeled in the excel tabs). Question: The Decision Sciences Department is trying to determine whether to rent a slow or a fast copier. The department believes that an employee’s time is worth $15 per hour. The slow copier rents for $4 per hour, and it takes an employee an average of 10 minutes to complete copying. The fast copier rents for $15 per hour, and it takes an employee an average of six minutes to complete copying. On average, four employees per hour need to use the copying machine. (Assume the copying times and interarrival times to the copying machine are exponentially distributed.) Which machine should the department rent to minimize expected total cost per hour?arrow_forward
- 11 The director of an emergency room, Simran Kaur, hasobserved that patient traffic at the emergency roomfollows a seasonal pattern, with higher patient trafficon weekends that on weekdays. She has gathered thefollowing data on daily patient admissions during the past4 weeks.Day Week 1 2 3 4Monday 110 105 109 112Tuesday 95 100 92 88Wednesday 89 85 80 84Thursday 93 96 78…arrow_forward. An automobile dealer is planning a new custom service center to repair the microcomputer-based engine controls in new-model cars. With the new diag- nostic equipment they are installing, each job should take about 75 minutes to complete. The dealer plans to operate the center 8 hours per day. Preliminary estimates suggest that about 5 customers will bring their cars for repair each day. To analyze this situation, make the following assumptions: The customer arrivals form a Poisson process. Each job requires on average 75 minutes. We can ignore the time that the service center is closed. (That is, no arrivals occur during such gaps, and we don't count them in the total response time.) (a) Measure time in hours. In the terms of queueing theory, what are A, μ, and p? (b) Compute an estimate of the average total response time (which we call Ts). 2 (c) Estimate the average number of cars in the center (including those waiting as well as in service). (d) Suppose the average number of…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_forward
- 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)?arrow_forwardCustomers arrive at a one window drive according to a poison distribution with mean of 10 minutes and service time per customer is exponential with mean of 6 minutes. The space in front of the window can accommodate only three vehicles including the serviced ones. Other vehicles are have to wait outside this space. Calculate:a. A. probability that an arriving customer can drive directly to the space in front of the windowb. Probability that an arriving customer will have to wait outside the directed space c. How long an arriving customer is expected to wait before getting the service?arrow_forwardestablish the significance of random numbers in Monte Carlo simulations.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,
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY