please use excel and solver. Show formulas

3. A company manufactures machines in factories located in Newark and Indianapolis. These are shipped to regional distribution centers in Madison, Phoenix, and Cleveland. Ultimately, they are delivered to supply houses in New York, Miami, and Los Angeles. The available supplies at the factories, the demands at the final destinations, and shipping costs are illustrated in the table below. Find the shipping cost in the table. Formulate this transshipment problem as a linear program. (Solve using Solver) Let Node(1) = Newark, (2) = Indianapolis City, (3) = Madison, (4) = Phoenix, (5) = Cleveland, (6) = New York, (7)= Los Angeles, and (8) = Miami Write variables of X as product moving from node 1 to 3 as X13 1. Write the objective function and the constraints for this problem (don't forget the non-negative constraint). 2. What is the value of the objective function? 3. What are the values of the variables