Answer:
The minimum cost will be of 10,000 dollars
Explanation:
The cost of each shipment considering starting point and destination:
(IE: From plant 2 to outlet 3 it cost 100)
OUTLET
PLANTS 1 2 3 4
1 $ 500.00 $ 600.00 $ 400.00 $ 200.00
2 $ 200.00 $ 900.00 $ 100.00 $ 300.00
3 $ 300.00 $ 400.00 $ 200.00 $ 100.00
4 $ 200.00 $ 100.00 $ 300.00 $ 200.00
Maximum deliveries per plants
Make
1 10.00
2 20.00
3 20.00
4 10.00
Shipment needed per outlet
Receive
1 20.00
2 10.00
3 10.00
4 20.00
We need to make the minimum cost.
We setp up two more tables, one with the shipment per plant
and one that calcualte the cost.
Then, we put the constrain (the amount each plant can make and the amount each outlet should receive) and let excel solve it
Plant Destination(Outlet 1 //2 //3 //4) Total shipment
1 - - - 10.00 10.00
2 11.00 - 9.00 - 20.00
3 9.00 0.00 1.00 10.00 20.00
4 - 10.00 - - 10.00
20 10 10 20
Total order made to each one
We multiply this by the cost-matrix and get a minimum cost of $10,000
