Liner program using excel

Experiment three (Infrastructure investment) We have three production centers and four distributors. This supply chain is in a developing area, so we must build the road for any route (producer to distributor) that we choose to use. We have the following information, where for each producer-distributor pair we have a fixed cost of building a road and then a unit cost of shipping along that road. Distributor 1 Distributor 2 Distributor 3 Distributor 4 Capacity Producer 1 100, 2 60, 5 90, 4 150, 3 400 Producer 2 80, 3 5 0, 4 110,5 L 60, 6 300 Producer 3 90,5 30, 6 100, 5 110, 4 350 Demand 250 120 180 200 Find a minimum cost solution (which roads to build and how much to route on each road) to meet all customer demand