Answer Happy

PLEASE SOLVE IN EXCEL - SHOW FORMULAS AND SCREENSHOTS
. Gamgee Fertilizer
Gamgee Fertilizer manufactures fertilizer in three plants
located in Hardbottle, Bywater, and Bree. The company ships its
products from plants to two central DCs located in Hobbiton and
Tuckborough, and then from the DCs to five regional warehouses
located in Longbottom, Pincup, Woodhall, Standelf, and Frogmorton.
At the DCs, no demand occurs, and no capacity limits exist. Demand
is associated with the warehouses, and capacities exist at the
plants. The system is described in the following two tables, one
for each stage. The units for capacity and demand are tons of
fertilizer, and the unit costs are given per ton.
Shipping Costs per Ton ($)
Hobbiton
Tuckborough
Capacity
Hardbottle
$1.36
$1.28
2,400
Bywater
$1.28
$1.35
2,750
Bree
$1.68
$1.55
1,950
Shipping Costs per Ton ($)
From/To
Longbottom
Pincup
Woodhall
Standelf
Frogmorton
Hobbiton
$0.60
$0.36
$0.32
$0.44
$0.72
Tuckborough
$0.80
$0.56
$0.42
$0.40
$0.55
Requirement
1,250
1,000
1,600
1,750
1,500
Find the minimum cost for Gamgee Fertilizer to distribute its
fertilizer from its plants to its warehouses. (10 points)