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
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…
Silicon Valley Transport Commission (SVTC) has a fleet of maintenance vehicles that includes cars, vans, and trucks. SVTC is currently evaluating four different approaches to help them maintain their fleet of cars and vans efficiently at the lowest possible cost. Their options are: (1) No preventive maintenance at all and repair vehicle components when they fail; (2) Take oil samples at regular intervals and perform whatever preventive maintenance is indicated by the oil analysis; (3) Perform an oil change on a regular basis on each vehicle and perform repairs when needed; (4) perform oil changes at regular intervals, take oil samples regularly, and perform maintenance repairs as indicated by the sample analysis.
Option #1 costs nothing to implement and results in two possible outcomes: There is a .10 probability that a defective component will occur, requiring emergency maintenance at a cost of $1,200, or there is a chance that no defects will occur and no maintenance will be…
Silicon Valley Transport Commission (SVTC) has a fleet of maintenance vehicles that includes cars, vans, and trucks. SVTC is currently evaluating four different approaches to help them maintain their fleet of cars and vans efficiently at the lowest possible cost. Their options are: (1) No preventive maintenance at all and repair vehicle components when they fail; (2) Take oil samples at regular intervals and perform whatever preventive maintenance is indicated by the oil analysis; (3) Perform an oil change on a regular basis on each vehicle and perform repairs when needed; (4) perform oil changes at regular intervals, take oil samples regularly, and perform maintenance repairs as indicated by the sample analysis.
Option #1 costs nothing to implement and results in two possible outcomes: There is a .10 probability that a defective component will occur, requiring emergency maintenance at a cost of $1,200, or there is a chance that no defects will occur and no maintenance will be…
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
- Morgan Trucking Company operates a special pickup and delivery service between Chicago and six other cities located in a four-state area. When Morgan receives a request for service, it dispatches a truck from Chicago to the city requesting service as soon as possible. With both fast service and minimum travel costs as objectives for Morgan, it is important that the dispatched truck take the shortest route from Chicago to the specified city. Assume that the following network (not drawn to scale) with distances given in miles represents the highway network for this problem. Chicago 1 36 31 21 2 3 9 10 11 21 4 13 Find the shortest-route distance from Chicago to node 6. 6 5 6 16 6 21 7arrow_forwardQL (“Quebec Lumber”) is a logging and wood processing firm in a remote part of the Canadian province of Quebec. They have recently acquired a remote track of timber that is located ten miles from their processing facility. Normally, this is not a problem as they are able to simply cut the timber and haul it using trucks to their processing facility. However, this track of forestland is ten miles to their north, and there are no roads connecting the tract of land to their facility. They have also acquired a narrow (120 foot wide) ten-mile strip of land connecting this tract of timber to their processing facility. QL considered building their own road between the two points, and have log trucks haul the logs to the processing facility. However, they have decided instead to go with a less expensive option, a narrow gauge railroad. The narrow gauge railroad would require the laying of ties and steel tracks, and will require a custom-built locomotive and rolling stock (train cars that will…arrow_forwardUnder gate-usage agreements, aircraft schedule use of gates is coordinated with airport management and other air carriers serving the airport. These air carriers usually have relatively few operations scheduled at the airport and airport operators can maximize the number of aircraft that may use gates over the course of the day. Which agreement does this represent?arrow_forward
- 4.Silicon Valley Transport Commission (SVTC) has a fleet of maintenance vehicles that includes cars, vans, and trucks. SVTC is currently evaluating four different approaches to help them maintain their fleet of cars and vans efficiently at the lowest possible cost. Their options are: (1) No preventive maintenance at all and repair vehicle components when they fail; (2) Take oil samples at regular intervals and perform whatever preventive maintenance is indicated by the oil analysis; (3) Perform an oil change on a regular basis on each vehicle and perform repairs when needed; (4) perform oil changes at regular intervals, take oil samples regularly, and perform maintenance repairs as indicated by the sample analysis. Option #1 costs nothing to implement and results in two possible outcomes: There is a .10 probability that a defective component will occur, requiring emergency maintenance at a cost of $1,200, or there is a chance that no defects will occur and no maintenance will be…arrow_forwardThe College Avenue Sub Shop is located in a small college town. Virtually all of its phone delivery orders are in the evening, between 5:00 P.M. and 1:00 A.M., so the shop has a delivery person for that time period. It receives an average of about 3 orders per hour (Poisson distributed). However, because of the different distances the delivery person must travel, the service time is undefined, with a mean of 15 minutes and a standard deviation of 6 minutes. Compute L, Lq, W, and Wq.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
- On 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_forwardGive one example of linear bus bay in Chicagoarrow_forwardAn Internet-service provider company uses a fiber-optic network to transmit data between locations. Data are carried through fiber-optic cables and switching nodes. A portion of the company's transmission network is shown here. The numbers above each arc show the capacity in gigabits of data per second that can be transmitted over that branch of the network. 3 4 3 3 2 6 5 5 3 7 To keep up with the volume of information transmitted between origin and destination points, use the network to determine the maximum amount of data, in gigabits per second, that may be sent from node 1 to node 7. GB/sarrow_forward
- Discuss how the principle of queues can be used when designing queueing schemes to reduce overall service costs?arrow_forwardPlease help do work in excelarrow_forwardWhatYouNeed is an online retailer with operations in Northern Indiana. Their network includes five big warehouses. All of the warehouses are fully automated: packaging is performed by robots on top of electric conveyors. Although the company has saved a lot in labor costs by the use of this packaging line, it has resulted in some excessive waste of material. After some analysis of this waste issue, the company has discovered that the number of product types that are assigned to the packaging line is strongly correlated with the amount of wasted material. Based on this insight, their operations manager has built a mathematical expression that estimates the expected amount of waste from the packaging line as a function of the number of product types in it. The expression is as follows: W = (n-93)2 – (n-88) + 227 In this expression, n is the number of product types you are packing on the line and W is the hourly waste of packaging material (in lbs). Based on this expression, what is the…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,