solution

CT-Power has three electric power plants that supply the needs of four cities in connecticut. Each plant can supply some number of killowatt-hours (kwh) as in table. The peak power demands and the costs of sending 1 million kwh of electricity from a plant to a city are also given in the table. CT-Power wants to minimize the cost of meeting each city’s peak power demand. From ?? City 1 City 2 City 3 City 4 Supply (Million kwh) 35 Plant 1 $8 $6 $10 $9 $9 $12 S7 50 Plant 2 Plant 3 $13 $16 $14 $9 S5 40 45 20 30 30 Demand (Million kwh) (a) Formulate this problem as a transportation problem. (b) Find a feasible solution for this problem using Northwest method (c) Use Stepping Stone method to check optimality of your feasible solution and improve your solution if it is not optimum. (d) Solve the problem using Excel solver or CPLEX.