in excel work

Midwest Electric has three electric power plants that supply the power needs of four cities. Each power plant can supply the amounts shown in the table below (in millions of kilowatt-hours of electricity): The peak power demand (again in millions of kwh) at each city is given in the following table: Finally, the cost (in dollars) of sending a million kwh from each plant to each city is given in the following table: Midwest Electric wants to find the lowest-cost method for meeting the demand of the four cities. a. Build a network flow model for Midwest and solve it using solver. (1.5 points) b. Identify the binding and the nonbinding constraints in your solution. (0.5 point) 2 c. Pick a constraint of your choice in your modet. What is the shadow price for this constraint? What does this shadow price mean in words? ( 1 point) Midwest Electric has three electric power plants that supply the power needs of four cities. Each power plant can supply the amounts shown in the table below (in millions of kilowatt-hours of electricity): The peak power demand (again in millions of kwh) at each city is given in the following table: Finally, the cost (in dollars) of sending a million kwh from each plant to each city is given in the following table: Midwest Electric wants to find the lowest-cost method for meeting the demand of the four cities. a. Build a network flow model for Midwest and solve it using solver. (1.5 points) b. Identify the binding and the nonbinding constraints in your solution. (0.5 point) 2 c. Pick a constraint of your choice in your modet. What is the shadow price for this constraint? What does this shadow price mean in words? ( 1 point)