The three blood banks in Seminole County, Florida, are coordinated through a central office that facilitates blood delivery to four hospitals in the region. The cost to ship a standard container of bloodfrom each bank to each hospital is shown in the table below. Also given are the biweekly number of containers available at each bank and the biweekly number of containers of blood needed ateach hospital.SourceBank 1Bank 2Bank 3DemandSourceBank 1Bank 2Hospital 1Bank 3Demand90Hospital 190$8$12$14$8$12$14Hospital 2The given transportation problem is balancedThe number of shipments should be made biweekly from each blood bank to each hospital so that total shipment costs are minimized:(Note: You must enter a shipment in every cell, even if the shipment is 0.)DestinationDestination7070Hospital 2$9$10$9$7Hospital 3$1040Hospital 340$11$11$5Hospital 4$650Hospital 450$16$8$16$8Supply50$780120Supply5080120

Answered: Image /qna-images/answer/ed1a0434-7ec9-4d93-b849-0ece1064a6a8.jpg

Answered: The three blood banks in Seminole…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Which of the following is not information needed to use the transportation model? Multiple Choice Unit shipping distances. Capacity of the sources. All of the answer choices are correct. Demand of the destinations. Unit shipping costs.
Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity Tons Available Volume per Ton (cu.ft.) Profit per Ton ($)1 4,000 40 702 3,000 25 503 2,000 60 604 1,000 50 80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold Weight Capacity (tons) Volume Capacity (cu.ft.)Forward 3,000 100,000Center 5,000 150,000Rear 2,000 120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…
Valles Galactic Industries (VGI) owns a small company (VGI-Durango Sur) that manufactures various electronic products for original equipment manufacturers. Customer companies provide engineering designs, materials lists, and some unique materials. VGI-DS provides labor and space for the manufacturing and assembly operations and stocking a variety of inventory items for production, such as wire, cables, some electronic components, etc. Thus, VGI-DS orders a variety of components and raw materials by contract. The labor pool is primarily composed of about 100 retirees picking up extra cash by working four to six-hour shifts. Thus, the assembly operations must be simple and easy to teach. Skilled employees must do several raw material conversions for packaging—there are currently three such employees. VGI-DS receives forecasts from VGI headquarters for planned production for two years on a rolling quarterly basis. Staff at VGI-DS develop schedules and inventory plans based on this…
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help. Answer the following question: Which of these is not an element of the objective function? Group of answer choices 4D-T1 600T1 9T2-G 3C-T2 Plz do fast asap
The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air filters for residential heating and air- conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain: QUARTER 1 QUARTER 3 (JULY THROUGH QUARTER 4 QUARTER 2 (APRIL THROUGH JUNE) (JANUARY (OCTOBER THROUGH THROUGH MARCH) SEPTEMBER) DECEMBER) All amounts in millions of U.S. dollars Sales (total quarter): United states 356 532 552 436 Canada 130 127 116 151 Europe 42 34 49 24 Cost of goods sold (total quarter) 338 445 465 398 Raw materials at the Louisville plant (end-of-quarter) 93 49 79 89 Work-in-process and finished goods at the Louisville plant (end-of-quarter) 194 175 127 176 Distribution center inventory…
Golf World, Incorporated (GWI) sells products and services for the sport of golf. One of its key business units specializes in the repair and reconditioning of golf carts. GWI enters into contracts with a number of golf clubs throughout the U.S. in which the clubs send their carts to GWI for a complete reconditioning: motor, frame repair where necessary, and replacement of seat covers and canvas tops. The clubs usually will cycle 10–15% of their carts through this process each year. Because GWI's business has been growing steadily, it is very important to complete the reconditioning of the carts within a budgeted time and cost. The firm uses weighted-average process costing to keep track of the costs incurred in the reconditioning process. GWI's golf cart repair and reconditioning unit has the following information for the month of November, in which 1,200 carts were started for reconditioning: Beginning WIP: 150 units, 50% complete for materials ($16,600) and 30% complete for…
Your company offers a weekly consolidation service from Toronto to Frankfort , via Lufthansa Airways. The carrier has given you a 1000 kg (or less) buying rate of CAN $2.27/kg and a plus 1000 kg buying rate of CAN $1.85/kg. You sell this service to clients who ship 700 kg (or less) at a rate of CAN $2.95/kg and for clients who ship in excess of 700 kg at a rate of CAN $2.55/kg. A) Shipper: J&J Company 123 John Street Toronto, ON, Canada, L5R 2N3 Shipment: 140 cartons of books Total weight: 426 kg Dimensions of each carton: 15 cm x 49 cm x 47 cm B) Shipper: R&R Company 432 Avenue Road Toronto, ON, Canada, R2S 1A3 Shipment: 380 cartons of umbrellas Total weight: 700 kg Dimensions of each carton: 39 in x 18 in x 19 in What is the profit on this shipment? full calculation
The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air filters for residential heating and air- conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfiter supply chain: QUARTER 1 (JANUARY THROUGH QUARTER 2 (APRIL THROUGH JUNE) QUARTER 3 (JULY THROUGH QUARTER 4 (остовеR THROUGH MARCH) All amounts in millions of U.s. dollara SEPTEMBER) DECEMBER) Sales (total quarter): United states 354 358 530 378 Canada 98 148 123 44 153 21 Europe 65 40 Cost of goods sold (total quarter) 362 383 493 393 Raw materials at the Louiaville plant (end-of-quarter) 67 45 84 Work-in-process and finished goods at the Louisville plant (end-of-quarter) 183 199 127 239 Distribution center inventory…
Morton Corporation manufactures computers and wants to select a supplier to purchase chips for its computers. There are two major suppliers of chips – AirBoxChips and SoftChips. AirBoxChips is a relatively big company and has a good reputation in terms of reliability and delivery. As it is a big company, it provides supply guarantee and sells its products with a higher price. Specifically, it charges $1.20 for each chip that it sells. SoftChips is small company having limited capacity. Even though it charges $0.90 for each chip that it sells, it does not provide supply guarantee. If it is a low-demand year, Softchips is able to satisfy Morton’s demand fully. However, if it is a high-demand year, it allocates only 90,000 chips for the purchase of Morton. If Morton cannot purhcase chips from its contracted supplier, it buys chips on the spot market. Spot market prices for chips are $2.00 per unit in a low-demand year and $4.00 per unit in a high-demand year. Demand in chips has a 75%…
This page is related to Transportation and freight forwarding Project one Rene’s Royal Fabrics, a manufacturer of fashion garments and fabric, uses three primary carriers to move fabrics from its Toronto factory to retailers and fashion designers in Canada and the United States. He wants to evaluate the performance of the three carriers. He collected data for the following metrics over a four-month period. Performance Criteria Allied Transport Bestway Freight Certaint Carriers On-time delivery 99% 98.5% 98% Loads with damage claims 0.8% 1.8% 0.5% Customer satisfaction ratings 4.5 4 3.8 Billing accuracy 99.2% 99.5% 98.1% Loads rejected 1.4% 2.2% 0.8% Rene asked Abimbola, his transportation manager, to develop a scorecard to help compare the carriers on these five metrics. Abimbola came up with the following chart: Performance Criteria Weight Factor(how importantthe criteria isto your company) Performance Evaluation Maximum Score Possible Actual Score(weight…
Your fast-food outlet, Burger Queen, has obtained a license to open branches in three closely situated South African cities: Brakpan, Nigel, and Springs. Your market surveys show that Brakpan and Nigel each provide a potential market of 2,500 burgers a day, while Springs provides a potential market of 1,000 burgers per day. Your company can only finance an outlet in one of those cities at the present time. Your main competitor, Burger Princess, has also obtained licenses for these cities, and is similarly planning to open only one outlet. If you both happen to locate at the same city, you will share the total business from all three cities equally, but if you locate in different cities, you will each get all the business in the cities in which you have located, plus half the business in the third city. The payoff is the number of burgers you will sell per day minus the number of burgers your competitor will sell per day. Set up the payoff matrix. O a. Your Competitor B N S Вг 1,5001…
The Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 410 boards per week. The outlet in Honolulu orders 500 Gladiator boards per week, while Venice Beach orders 530 boards per week. Transportation costs are as follows. Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board. Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. (a) Assuming that you wish to fill all orders and ensure full capacity production at both plants, is it possible to meet a total transportation budget of $9,900? O Yes O No If so, how many Gladiator boards are shipped from each manufacturing plant to each distribution outlet? (If…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS