FedUps packages sent from Boston to San Diego are transported as follows: The package is sent...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
FedUps packages sent from Boston to San Diego are transported as follows: The package is sent first to either Houston or Pittsburgh, then routed through either Phoenix or Kansas City, and finally sent to San Diego. Due to the limitation of truck drivers and truck capacity, there is a maximum limit on the number of packages between each pair of cities as shown in the table below. FedUps wants to maximize the flow of packages from Boston to San Diego given the routing limitations. Cities Boston-Houston Boston-Pittsburgh Houston-Phoenix Houston-Kansas City Pittsburgh-Phoenix Pittsburgh-Kansas City Phoenix-San Diego Kansas City-San Diego # of Packages 5000 4000 3000 2050 2000 1500 4000 3050 a. (6 pts) Solve this problem in Excel. b. (3 pts) What is the maximum number of packages that can be shipped through this network? c. (3 pts) Which routes are at maximum capacity? FedUps packages sent from Boston to San Diego are transported as follows: The package is sent first to either Houston or Pittsburgh, then routed through either Phoenix or Kansas City, and finally sent to San Diego. Due to the limitation of truck drivers and truck capacity, there is a maximum limit on the number of packages between each pair of cities as shown in the table below. FedUps wants to maximize the flow of packages from Boston to San Diego given the routing limitations. Cities Boston-Houston Boston-Pittsburgh Houston-Phoenix Houston-Kansas City Pittsburgh-Phoenix Pittsburgh-Kansas City Phoenix-San Diego Kansas City-San Diego # of Packages 5000 4000 3000 2050 2000 1500 4000 3050 a. (6 pts) Solve this problem in Excel. b. (3 pts) What is the maximum number of packages that can be shipped through this network? c. (3 pts) Which routes are at maximum capacity?
Expert Answer:
Answer rating: 100% (QA)
Answer 1 General guidance The answer provided below has been developed in a clear s... View the full answer
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these accounting questions
-
Shown in the table below are the assets (in $billions) for 10 large companies that recently fled for bankruptcy. Determine the range, MAD, standard deviation, and variance for the assets listed....
-
What are the major DW implementation tasks that can be performed in parallel?
-
What are some operations/supply chain management strategies that can be used to deal with the challenges of diminishing natural resources?
-
The crate has a mass of 80 kg and is being towed by a chain which is always directed at 20 degrees from the horizontal. If the magnitude of P is increased until the crate begins to slide, determine...
-
Refer to the balance sheets of Plate and Salad in the previous problem. Assume that Plate buys 80% of Salads common stock for $180,000 cash. The fair value of Salads land is $20,000, the fair value...
-
How can an individual show prima facie evidence for adverse impact discrimination? How would an employer defend itself from this evidence?
-
Larry Riley formed a rental agreement for a self-storage unit with Iron Gate Self Storage in December 2003. The agreement stated that a maximum of \($5,000\) of personal property could be stored in...
-
Beverly Crusher, a new staff accountant, is confused because of the complexities involving accounting standard-setting. Specifically, she is confused by the number of bodies issuing financial...
-
3. Suppose f: RR is continuous and U CR. Assume R has the usual Euclidean metric. (a) Define U is "open" in R.
-
Client's Facts: The client found a check written out to cash in the amount of $750. The check was completely made out when he found it. He took it to the bank, signed it on the back as instructed by...
-
Martin has severe myopia, with a far point of only 19cm . He wants to get glasses that he'll wear while using his computer, whose screen is 63cm away. What refractive power will these glasses...
-
requirement 2 3 4 5 6 7 Data Unit sales Selling price per unit Variable expenses per unit Fixed expenses S 10,000 units 50 per unit 20 per unit $ $ 240,000
-
Oriole Corporation has outstanding 11,000 shares of $100 par value, 6% preferred stock and 64,200 shares of $10 par value common stock. The preferred stock was issued in January 2025, and no...
-
Consider the binary search tree below: sequence. List the keys of this binary tree in inorder, preorder, and postorder Show the resulting tree after deletion of node with key 10.
-
A company has liabilities of $ 1 5 , 5 0 0 and $ 2 0 , 2 0 0 of owners' equity at the year end. What is the total amount of assets held by the firm at the year end? $ 4 , 7 0 0 $ 3 5 , 7 0 0 $ 2 0 ,...
-
The book value of the company is $ 1 , 0 0 0 , 0 0 0 and the company ?? s share is traded at $ 1 2 . 0 0 . The shares outstanding is 2 0 0 , 0 0 0 . Calculate the market - to - book ratio. What does...
-
A. B and C are in partnership sharing profits and losses in the ratio of 5:3:2. On 1 Jan 2020, their capital balances are: RO A 75000 B 45000 C 30000 The terms of partnership provide that: a. All...
-
Smthe Co. makes furniture. The following data are taken from its production plans for the year. Required: 1. Determine the hazardous waste disposal cost per unit for chairs and for tables if costs...
-
County Beverage Drive-Thru, Inc., operates a chain of beverage supply stores in Northern Illinois. Each store has a single service lane; cars enter at one end of the store and exit at the other end....
-
Automobile sales at B. J. Scott Motors, Inc., provided the following 10-year time series: Plot the time series, and comment on the appropriateness of a linear trend. What type of functional form...
-
Embassy Club Condominium, located on the west coast of Florida, is undertaking a summer renovation of its main building. The project is scheduled to begin May 1, and a September 1 (17-week)...
-
Given the four criteria necessary for a sale to be complete, which of the following is not one of those conditions? 1. Delivery has occurred or services rendered. 2. Cash has been collected. 3. The...
-
What is the difference between a business and a pure charity? Between a business and a governmental agency?
-
Will reform have a greater impact on insurers or providers?
Study smarter with the SolutionInn App