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
At the British Grand Prix’s Silverstone Circuit’s 3 July 2022 race, it was another battle royal of sorts as the Formula 1 drivers battled for maximum points in the series.
The fans seeking to purchase tickets started arriving from 10:00 am running all through 1:30 pm, when the gates closed in readiness for the race. The fans were observed to arrive at an average of 2,048 each hour, and were being served at a rate of 533 every fourteen minutes.
Some fans had already purchased their tickets earlier via the ticket sales agency e-commerce portal. The Silverstone gallery has a 150,000 seating capacity. The gallery was 95% full for this grace.
Given the enthusiasm of the fans that were trickling in, this was going to be the race of the month.
required;
iv). On average, how long does a fan spend in the circuit ticketing system?
v). What is the probability of having more than 5 but less than 12 fans in the circuit ticketing system?
Determine the efficiency of the Silverstone circuit…
Cleveland Area Rapid Delivery (CARD) operates a delivery service in the Cleveland metropolitan area. Most of CARD's business
involves rapid delivery of documents and parcels between offices during the business day. CARD promotes its ability to make fast
and on-time deliveries anywhere in the metropolitan area. When a customer calls with a delivery request, CARD quotes a
guaranteed delivery time. The following network shows the street routes available. The numbers above each arc indicate the
travel time in minutes between the two locations.
Min
s.t.
Node 1 Flows
Node 2 Flows
Node 3 Flows
Node 4 Flows
Node 5 Flows
Node 6 Flows
35
For all X;; = 0, 1.
(a) Develop a linear programming model that can be used to find the minimum time required to make a delivery from location 1
to location 6. (Express your answers in the form where each Xij represents the arc from node i to node j as either 1 or
Xijr
0.)
30
12
p.m.
3
Need Help? Read It
18
15
39
12
16
5
(b) How long (in minutes) does it take to…
Netflix is a DVD movie rental company. They stock 50 DVDs of a recent blockbuster movie available for rental. Their rental fee is $4 per DVD per day. The inter-arrival time between rental requests for this movie is 2.5 hours, on average, with a standard deviation of 2.5 hours. Demand is steady throughout a 24-hour day (there is no evidence of other arrival patterns). Assume that if all copies of the DVD are rented, then customers are willing to wait for the next one to become available. Also, assume shipping is instantaneous (the shipping time is zero days). A DVD is rented, on average, for 5 days with a standard deviation of 3 days. What is the average number of unrented DVDs in Netflix’s warehouse? Hint: consider the average utilization.
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_forwardTSA security agents at the security gate at the Tri-Cities Regional Airport are able to check passengers and process them through the security gate at a rate of 50 per hour (Poisson distributed). Passengers arrive at the gate throughout the day at a rate of 40 per hour (Poisson distributed) the passenger traffic arriving at the airport security gate varies significantly during the day. At times close to flight takeoffs, the traffic is very heavy, while at other times there is little or no passenger traffic through the security gate. At the times leading up to flight takeoffs, passengers arrive at a rate of 110 per hour (Poisson distributed). Suggest a waiting line system that can accommodate this level of passenger traffic.arrow_forwardThe Seaboard Shipping Company has a warehouse terminalin Spartanburg, South Carolina. The capacity of each terminal dock is three trucks. As trucks enter the terminal, the drivers receive numbers, and when one of the three dock spacesbecomes available, the truck with the lowest number entersthe vacant dock. Truck arrivals are Poisson distributed, andthe unloading and loading times (service times) are exponentially distributed. The average arrival rate at the terminalis five trucks per hour, and the average service rate per dockis two trucks per hour (30 minutes per truck).a. Compute L, Lq, W, and Wq.b. The management of the shipping company is considering adding extra employees and equipment to improvethe average service time per terminal dock to 25 minutes per truck. It would cost the company $18,000 peryear to achieve this improved service. Managementestimates that it will increase its profit by $750 per yearfor each minute it is able to reduce a truck’s waitingtime. Determine…arrow_forward
- The Seaboard Shipping Company has a warehouse terminal in Spartanburg, South Carolina. The capacity of each termi-nal dock is three trucks. As trucks enter the terminal, the dri-vers receive numbers, and when one of the three dock spaces becomes available, the truck with the lowest number entersthe vacant dock. Truck arrivals are Poisson distributed, and the unloading and loading times (service times) are expo-nentially distributed. The average arrival rate at the terminal is five trucks per hour, and the average service rate per dockis two trucks per hour (30 minutes per truck).a. Compute L, Lq, W, and Wq. b. The management of the shipping company is consider-ing adding extra employees and equipment to improve the average service time per terminal dock to 25 min-utes per truck. It would cost the company $18,000 per year to achieve this improved service. Managementestimates that it will increase its profit by $750 per yearfor each minute it is able to reduce a truck’s waitingtime.…arrow_forwardThis effect is concerned with the firm being able to engage with the customer at the right place/time—its ability to do so 24/7 from any location. Select one: Network effect Timeliness Effect Dynamic Effect Connected Effectarrow_forwardDimeco, Inc., a small manufacturer of punching die sets has four high speed machines. Because of the age of these machines, they need minor repairs after 30 hours of use. Analysis of previous breakdowns indicates that breakdowns follow a Poisson distribution. The facility employs one repairman specifically to repair these machines. Average repair time is two hours following an exponential distribution. What is the service factor for this system? What is the average number of these machines in service? What is the impact of adding a second repairman?arrow_forward
- A study-aid desk staffed by a graduate student has been established to answer students' questions and help in working problems in your OSCM course. The desk is staffed eight hours per day. The dean wants to know how the facility is working. Statistics show that students arrive at a rate of four per hour and the distribution is approximately Poisson. Assistance time averages 10 minutes, distributed exponentially. Assume population and line length can be infinite and queue discipline is FCFS. Calculate the percentage utilization of the graduate student. Note: Round your answer to 1 decimal place. Calculate the average number of students in the system, including the graduate student service desk. Note: Round your answer to the nearest whole number. Calculate the average time in the system. Note: Round your answer to the nearest whole number. Calculate the probability of four or more students being in line or being served. Note: Round your intermediate calculations to 3…arrow_forwardA study-aid desk staffed by a graduate student has been established to answer students' questions and help in working problems in your OSCM course. The desk is staffed eight hours per day. The dean wants to know how the facility is working. Statistics show that students arrive at a rate of four per hour and the distribution is approximately Poisson. Assistance time averages 10 minutes, distributed exponentially. Assume population and line length can be infinite and queue discipline is FCFS.a. Calculate the percentage utilization of the graduate student.b. Calculate the average number of students in the system, excluding the graduate student service.c. Calculate the average time in the system.d. Calculate the probability of four or more students being in line or being served.e. Before a test, the arrival of students increases to six per hour, on average. What will the new average line length be?arrow_forwardAnalyzing Disaster Situations at Tech Two area hospitals have jointly initiated several planning projects to determine how effectively their emergency facilities can handle disaster-related situations at nearby Tech University. These disasters could be weather related (such as a tornado), a fire, accidents (such as a gas main explosion or a building collapse), or acts of terrorism. One of these projects has focused on the transport of disaster victims from the Tech campus to the two hospitals in the area, Montgomery Regional and Radford Memorial. When a disaster occurs at Tech, emergency vehicles are dispatched from Tech police, local EMT units, hospitals, and local county and city police departments. Victims are brought to a staging area near the disaster scene and wait for transport to one of the two area hospitals. Aspects of the project analysis include the waiting times victims might experience at the disaster scene for emergency vehicles to transport them to the hospital, and…arrow_forward
- For a single-server queue of 10 customers whose arrival and service time is given below in the table. Complete the below given table. Customer Arrival Time ti Inter Arrival Time Ai=ti—ti-1 Service Begins (Sb) Delay Time (Di) Service Time (Si) Calculate Ci=ti+Di+Si 1 7:00 7:02 6 2 7:08 7:12 4 3 7:11 7:16 1 4 7:13 7:19 5 5 7:18 7:25 10 6 7:36 7:39 2 7 7:40 7:44 3 8 7:45 7:48 3 9 7:49 7:52 4 10 7:55 7:57 3 Find the average service time and average delay time. Average Service Time= Average Delay Time=arrow_forwardJuhn and Sons Wholesale Fruit Distributors employ one worker whose job is to load fruit on outgoing company trucks. Trucks arrive at the loading gate at an average of 24 per day, or 3 per hour, according to a Poisson distribution. The worker loads them at a rate of 4 per hour, following approximately the exponential distribution in service times. Determine the operating characteristics of this loading gate problem. What is the probability that there will be more than three trucks either being loaded or waiting? Discuss the results of your queuing model computation.arrow_forwardThe 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…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