The demand for cotton in Savannah, Perry, and Valdosta is 400, 300, and 450 tons, respectively. The trucks used to ship the cotton can hold a maximum of 400 tons. The cotton grower would like to meet the demand with the minimal shipping cost.

a.)  Draw a network flow model to represent this problem. Make sure that you note all the numerical information about each node and each arc appropriately on the graph using network modeling convention (if you prefer, you can take a picture of your drawing and paste it to your file).

b. Implement your model in Excel and solve it.

c. What is the optimal solution? You can summarize your solution in a table or in a graph.

Step-by-step solution1. Step 1 of 11A.According to the provided information of the problem, the following networkflow can be drawn, 2. Step 2 of 11B.Firstly take the cell B2 to B18 as…