Files - OneDrive Formulas Data Home MT901.xlsx Help Daforce The City Commission of Nas Tell me what you want... Open in Desktop App Insert NYS ITS Password Self Service Review View Ream X Cut In Copy Paste Calibri 13.!. A Format Painter B TVR Clipboard Font 8 B C D E roblem 1 -- 15 ot: 19 Wrap Text Currency Merge & Center. 5.% Alignment Number Autos Clear Conditional Format Cell Formatting - Table - Styles Insert Delete Format cells F G 1 M N O P Q R S The three blood banks are coordinated through a central office that facilitates blood delivery to four hospitals in the region. The cost to ship a standard container of blood from each bank to each hospital is summarized in the table below. Also given are the biweekly number of containers available at each bank fi.e. supply available) and the biweekly number of containers of blood needed at each hospital The demand). The hospital can accept more containers of blood than needed if that happens. Although the bank does not have to ship out all available containers, each bank will not keep more than 10% of its available containers due to limited storage space for inventory. Show your biweekly shipments from each blood bank to each hospital so that the total shipment costs are minimized. Show your resulting total shipment cost as well. (Solver is required) Your answer Shippine quantities for each shippine lane TO FROM Hoso 1 Hose 2 Hoso 3 Hose 4 Unit shippine costs for each shippine lane TO FROM Hosn 1 Hose 2 Hoso 3 Hoso 4 Bank 1 $9 $11 $16 Bank 2 $12 $7 SS $8 Bank 3 $14 S6 $7 Total shippine cos Supply available 100 80 120 Bank 1 Bank 2 Bank 3 Bank 1 $10 Bank 2 Bank 3 Hoso 1 Hoso 2 HoSD 3 Hoso 4 90 80 50 60 Demand