1. Consider the following network representation problem :
The supplies, demands and transportation cost per unit are shown on the network.
From the network representation, set up a model in Excel. Run Excel solver on the model and generate how much of the product should be transported through each route to minimize shipping cost. What is the optimal (cost minimizing) distribution plan?