Change or ENTER values in the GREEN shade areas

Channel Network for ABC Distribution

Location Forecast$/$Inventory Tons

Los Angeles $ $1\mathrm{.}65600,000595,000$

Denver $ $0\mathrm{.}85500,000515,000$

Boston $ $1\mathrm{.}30400,000370,000$

New York $ $1\mathrm{.}25400,000395,000$

Philadelphia $ $0\mathrm{.}75400,000390,000$

Cincinnati $ $0\mathrm{.}95600,000580,000$

SUM $2,900,0002,845,000$

Costs

Location Transfer Qty

Los Angeles $3005,0000$

Denver $(15,000)$

Boston $1,60030,0000$

New York $1,4005,0000$

Philadelphia $1,10010,0000$

Cincinnati $90020,0000$

Total Total

Transportatio

n Cost

US$$/$Ton

Mile $($Avg$.)$

Max

Capacity$/$Inventory

Tons

Shipment

miles to

Denver

Capacity$/$Tons

Available

Capacity$/$Tons Available

$5,000$

$-15,000$

$30,000$

$5,000$

$10,000$

$20,000$

$55,000$

Value

$ $-$

$ $-$

$ $-$

$ $-$

$ $-$

$ $-$