please do not use previous answers for this question. use Excel and provide the formula. Thank you in advance!

4. Walsh's Fruit Company contracts with growers in Ohio, Pennsylvania, and New York to purchase grapes. The grapes are processed into juice at the farms and stored in refrigerated vats. Then the juice is shipped to two plants, where it is processed into bottled grape juice and frozen concentrate. The juice and concentrate are then transported to three food distribution centers. The transportation costs per ton from the farms to the plants and from the plants to the distributors, and the supply at the farms and demand at the distribution centers are summarized in the following tables: Farm 1. Ohio 2. Pennsylvania 3. New York Plant 4. Indiana 5. Georgia Supply (1k tons) $18 $20 100 $21 $19 120 $22 $25 90 Plant 4. Indiana 5. Georgia Demand (1k tons) Distribution Center 6. Virginia 7. Kentucky 8. Louisiana $23 $15 $29 $20 $17 90 80 120 $24 The manage wants to minimize the total transportation cost, assuming that no stock is allowed to be stored in any plant. All the demands must be satisfied. (a) Find the optimal objective value and the optimal solution point by using the computer. (b) Draw the optimal solution network based on the solution in (a) specify the amount of shipments for cach route. (c) At the optimal solution in (a), how many tons of grapes will be processed by the plant at Georgia? (d) What is the new minimal total cost if the transportation cost from New York to Georgia is increased to $50 given the original