Distributon at Heart Beats
From To Ship Capacity Unit Cost Locations
F1 WH1 0 ≤ 250 40 F1
F1 WH2 0 35 F2
F2 WH2 0 25 WH1
WH1 WS1 0 60 WH2
WH1 WS2 0 35 WS1
WH2 WS2 0 55 WS2
WH2 WS3 0 50 WS3
WH2 WS4 0 65 WS4
Total Cost 0
Formulas
G13 = SUMPRODUCT(Ship;Unit_Cost)
J4 = SUMIF(From;I4;Ship)-SUMIF(To;I4;Ship)
J5 = SUMIF(From;I5;Ship)-SUMIF(To;I5;Ship)
…
J11 = SUMIF(From;I11;Ship)-SUMIF(To;I11;Ship)
Range Names
Cap_F1_WH1 ='Heart Beats'!$F$4
F1_WH1 ='Heart Beats'!$D$4
From ='Heart Beats'!$B$4:$B$11
Net_Flow ='Heart Beats'!$J$4:$J$11
Ship ='Heart Beats'!$D$4:$D$11
Supply_Demand ='Heart Beats'!$L$4:$L$11
To ='Heart Beats'!$C$4:$C$11
Total_Cost ='Heart Beats'!$G$13
Unit_Cost ='Heart Beats'!$G$4:$G$11
Net Flow Supply/Demand
0 = 400
0 = 250
0 = 0
0 = 0
0 = -200
0 = -100
0 = -150
0 = -200