Optimal DCs-to-Stores Transportation Flows Model Author: Reginald Joules Ushar Enterprises Inc Colorado, USA www.ushar.com 303-731-3213 Topic: From-DCs-to-Stores Flows ~ Initial Best Solution With Potential Constraints Violations ------------------------------------------------------------------ DC Sequence: 1 DC ID: 1 Flows from DC 1 to 4 Stores... Record Store UnitCost Flow FlowCost 1 4 5 4.0000 0 0.000 2 3 1 7.0000 0 0.000 3 2 2 20.0000 0 0.000 4 1 3 4.0000 50 200.000 50 200.000 DC capacity Total shipped Remaining capacity 50 50 0 ------------------------------------------------------------------ DC Sequence: 2 DC ID: 2 Flows from DC 2 to 6 Stores... Record Store UnitCost Flow FlowCost 1 5 6 2.0000 0 0.000 2 6 7 9.0000 11 99.000 3 7 8 5.0000 64 320.000 4 8 1 13.0000 0 0.000 5 9 2 15.0000 0 0.000 6 10 4 10.0000 0 0.000 75 419.000 DC capacity Total shipped Remaining capacity 75 75 0 ------------------------------------------------------------------ DC Sequence: 3 DC ID: 3 Flows from DC 3 to 4 Stores... Record Store UnitCost Flow FlowCost 1 11 3 5.0000 15 75.000 2 12 2 3.0000 18 54.000 3 13 4 8.0000 27 216.000 4 14 6 1.0000 35 35.000 95 380.000 DC capacity Total shipped Remaining capacity 95 95 0 ------------------------------------------------------------------ DC Sequence: 4 DC ID: 4 Flows from DC 4 to 4 Stores... Record Store UnitCost Flow FlowCost 1 15 5 2.0000 59 118.000 2 16 8 14.0000 0 0.000 3 17 7 12.0000 38 456.000 4 18 6 6.0000 0 0.000 97 574.000 DC capacity Total shipped Remaining capacity 135 97 38 ------------------------------------------------------------------ DC Sequence: 5 DC ID: 5 Flows from DC 5 to 2 Stores... Record Store UnitCost Flow FlowCost 1 19 5 5.0000 0 0.000 2 20 8 15.0000 0 0.000 0 0.000 DC capacity Total shipped Remaining capacity 10 0 10 ------------------------------------------------------------------ Total costs: 1573.000000000000 Topic: To-Stores-From-DCs Flows ~ Initial Best Solution With Potential Constraints Violations ------------------------------------------------------------------ Store Sequence: 1 Store ID: 1 Flows to Store 1 from 2 DCs... Record DC UnitCost Flow FlowCost 1 8 2 13.0000 0 0.000 2 3 1 7.0000 0 0.000 0 0.000 Store Demand Total received Unfulfilled demand 20 0 20 Shortage at 1 1 ------------------------------------------------------------------ Store Sequence: 2 Store ID: 2 Flows to Store 2 from 3 DCs... Record DC UnitCost Flow FlowCost 1 12 3 3.0000 18 54.000 2 9 2 15.0000 0 0.000 3 2 1 20.0000 0 0.000 18 54.000 Store Demand Total received Unfulfilled demand 18 18 0 ------------------------------------------------------------------ Store Sequence: 3 Store ID: 3 Flows to Store 3 from 2 DCs... Record DC UnitCost Flow FlowCost 1 11 3 5.0000 15 75.000 2 1 1 4.0000 50 200.000 65 275.000 Store Demand Total received Unfulfilled demand 65 65 0 ------------------------------------------------------------------ Store Sequence: 4 Store ID: 4 Flows to Store 4 from 2 DCs... Record DC UnitCost Flow FlowCost 1 13 3 8.0000 27 216.000 2 10 2 10.0000 0 0.000 27 216.000 Store Demand Total received Unfulfilled demand 48 27 21 Shortage at 4 4 ------------------------------------------------------------------ Store Sequence: 5 Store ID: 5 Flows to Store 5 from 3 DCs... Record DC UnitCost Flow FlowCost 1 19 5 5.0000 0 0.000 2 15 4 2.0000 59 118.000 3 4 1 4.0000 0 0.000 59 118.000 Store Demand Total received Unfulfilled demand 59 59 0 ------------------------------------------------------------------ Store Sequence: 6 Store ID: 6 Flows to Store 6 from 3 DCs... Record DC UnitCost Flow FlowCost 1 18 4 6.0000 0 0.000 2 14 3 1.0000 35 35.000 3 5 2 2.0000 0 0.000 35 35.000 Store Demand Total received Unfulfilled demand 35 35 0 ------------------------------------------------------------------ Store Sequence: 7 Store ID: 7 Flows to Store 7 from 2 DCs... Record DC UnitCost Flow FlowCost 1 17 4 12.0000 38 456.000 2 6 2 9.0000 11 99.000 49 555.000 Store Demand Total received Unfulfilled demand 49 49 0 ------------------------------------------------------------------ Store Sequence: 8 Store ID: 8 Flows to Store 8 from 3 DCs... Record DC UnitCost Flow FlowCost 1 7 2 5.0000 64 320.000 2 16 4 14.0000 0 0.000 3 20 5 15.0000 0 0.000 64 320.000 Store Demand Total received Unfulfilled demand 64 64 0 ------------------------------------------------------------------ Total costs: 1573.000000000000