Please attach the excel file you solved it with if possible Thank you

Question 1 Powereo has three clectric power plants that supply the needs of four cities. Each power plant can supply the following numbers of kilowatt-hours (kwh) of electricity: plant 1 35 million; plant 250 million; plant 3 40 million (see Table 1). The peak power de- mands in these cities, which occur at the same time (2 P.M.), are as follows (in kwh): city 145 million; city 220 million; city 330 million; city 430 million. The costs of sending 1 million kwh of electricity from plant to city depend on the distance the elec- Tricity must travel. Formulate an LP to minimize the cost of meeting cach city's pcak power demand. To formulate Powerco's problem as an LP, we begin by defining a variable for each deci- sion that Powerco must make. Because Powerco must determine how much power is sent from each plant to each city, we define (for i = 1, 2, 3 and j = 1, 2, 3, 4) Xij = number of (million) kwh produced at plant i and sent to city i Formulate as a LP. Solve Using EXCEL. City 3 City 4 Supply (million kwh) TABLE 1 Shipping Costs, Supply, and Demand for Powerco From City 1 City 2 Plant 1 $6 Plant 2 $9 $12 Plant 3 $14 $9 Demand 45 20 (million kwh) $8 35 $10 $13 $16 30 $9 $7 $5 50 40 30