with calculations please

facility? Use the worksheet Uut Answer: Channel Network for ABC Distribution Max Transportation Cost Forecast/Inventory Location Capacity/Inventory US$/Ton Mile (Avg.) Tons Tons 1.65 600,000 595,000 Los Angeles 500,000 0.85 515,000 Denver 1.30 400,000 370,000 Boston 1.25 New York 395,000 400,000 0.75 Philadelphia 400.000 390,000 Cincinnati (est.) 580,000 0.95 $ 600,000 SUM 2,900,000 2,845,000 Capacity/Tons Available 5,000 - 15,000 30,000 5,000 10,000 20,000 55,000 Costs Transfer Qty Value Estimated Ship Ton- Miles 300 0 $ T$ 0 $ Location Los Angeles Denver Boston New York Philadelphia Cincinnati 1,600 Capacity/Tons Available 5,000 (15,000) 30,000 5,000 10,000 20,000 Total 0 $ 1,400 1,100 900 0 0 $ $ Total $ facility? Use the worksheet Uut Answer: Channel Network for ABC Distribution Max Transportation Cost Forecast/Inventory Location Capacity/Inventory US$/Ton Mile (Avg.) Tons Tons 1.65 600,000 595,000 Los Angeles 500,000 0.85 515,000 Denver 1.30 400,000 370,000 Boston 1.25 New York 395,000 400,000 0.75 Philadelphia 400.000 390,000 Cincinnati (est.) 580,000 0.95 $ 600,000 SUM 2,900,000 2,845,000 Capacity/Tons Available 5,000 - 15,000 30,000 5,000 10,000 20,000 55,000 Costs Transfer Qty Value Estimated Ship Ton- Miles 300 0 $ T$ 0 $ Location Los Angeles Denver Boston New York Philadelphia Cincinnati 1,600 Capacity/Tons Available 5,000 (15,000) 30,000 5,000 10,000 20,000 Total 0 $ 1,400 1,100 900 0 0 $ $ Total $