L
Legacy 143009
Guest
Dear All,
Regarding this thread, I have another question. I re-setup another file. a,b are start points. y,z are end points.
Columns I, N, S and X are transportation costs. The target is to distribute the supplies to the demands with the minimum cost.
I solved scenarios 1, 2, 3 and 4 manually. I want a generic formula that I can apply for scenarios 5, 6, 7 and 8 (Columns K, P, U and Z).
I just want to see the distribution logic behind it. The formula should handle varying numbers of start or end points.
Bonus formula: Find the optimal distrubiton by multiplying cost*load
Regarding this thread, I have another question. I re-setup another file. a,b are start points. y,z are end points.
Columns I, N, S and X are transportation costs. The target is to distribute the supplies to the demands with the minimum cost.
I solved scenarios 1, 2, 3 and 4 manually. I want a generic formula that I can apply for scenarios 5, 6, 7 and 8 (Columns K, P, U and Z).
I just want to see the distribution logic behind it. The formula should handle varying numbers of start or end points.
Bonus formula: Find the optimal distrubiton by multiplying cost*load