Based on the available capacity at each facility, which facility or combo of

facilities should be used to absorb the excess demand at Denver?Change or ENTER values in the GREEN shade areas

Channel Network for ABC Distribution

Location Forecast

$/$

Inventory Tons

Los Angeles $

$1$

$.$

$6$

$5$

$6$

$0$

$0$

$,$

$0$

$0$

$0$

$5$

$9$

$5$

$,$

$0$

$0$

$0$

Denver $

$0$

$.$

$8$

$5$

$5$

$0$

$0$

$,$

$0$

$0$

$0$

$5$

$1$

$5$

$,$

$0$

$0$

$0$

Boston $

$1$

$.$

$3$

$0$

$4$

$0$

$0$

$,$

$0$

$0$

$0$

$3$

$7$

$0$

$,$

$0$

$0$

$0$

New York $

$1$

$.$

$2$

$5$

$4$

$0$

$0$

$,$

$0$

$0$

$0$

$3$

$9$

$5$

$,$

$0$

$0$

$0$

Philadelphia $

$0$

$.$

$7$

$5$

$4$

$0$

$0$

$,$

$0$

$0$

$0$

$3$

$9$

$0$

$,$

$0$

$0$

$0$

Cincinnati $

$0$

$.$

$9$

$5$

$6$

$0$

$0$

$,$

$0$

$0$

$0$

$5$

$8$

$0$

$,$

$0$

$0$

$0$

SUM

$2$

$,$

$9$

$0$

$0$

$,$

$0$

$0$

$0$

$2$

$,$

$8$

$4$

$5$

$,$

$0$

$0$

$0$

Costs

Location Transfer Qty

Los Angeles

$3$

$0$

$0$

$5$

$,$

$0$

$0$

$0$

$0$

Denver

$($

$1$

$5$

$,$

$0$

$0$

$0$

$)$

Boston

$1$

$,$

$6$

$0$

$0$

$3$

$0$

$,$

$0$

$0$

$0$

$0$

New York

$1$

$,$

$4$

$0$

$0$

$5$

$,$

$0$

$0$

$0$

$0$

Philadelphia

$1$

$,$

$1$

$0$

$0$

$1$

$0$

$,$

$0$

$0$

$0$

$0$

Cincinnati

$9$

$0$

$0$

$2$

$0$

$,$

$0$

$0$

$0$

$0$

Total Total

Transportatio

n Cost

US$

$/$

Ton

Mile

$($

Avg

$.$

$)$

Max

Capacity

$/$

Inventory

Tons

Shipment

miles to

Denver

Capacity

$/$

Tons

Available

Capacity

$/$

Tons Available

$5$

$,$

$0$

$0$

$0$

$-$

$1$

$5$

$,$

$0$

$0$

$0$

$3$

$0$

$,$

$0$

$0$

$0$

$5$

$,$

$0$

$0$

$0$

$1$

$0$

$,$

$0$

$0$

$0$

$2$

$0$

$,$

$0$

$0$

$0$

$5$

$5$

$,$

$0$

$0$

$0$

Value

$

$-$

$

$-$

$

$-$

$

$-$

$

$-$

$

$-$