Question: Draw only the network representation for both questions don't solve. Thank you Question 1 Powereo has three clectric power plants that supply the needs of

Draw only the network representation for both questions don't solve. Thank you

Draw only the network representation for bothDraw only the network representation for both

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 Question 2 Arnoff Enterprises manufactures the central processing unit (CPU) for a line of personal computers. The CPUs are manufactured in Seattle, Columbus, and New York and shipped to warchouses in Pittsburgh, Mobile, Denver, Los Angeles, and Washington, D.C., for fur- ther distribution. The following table shows the number of CPUs available at each plant, the number of CPUs required by cach warehouse, and the shipping costs (dollars per unit): Warehouse Plant Seattle Columbus New York CPUs Required Pittsburgh 10 2 1 3000 Mobile 20 10 20 5000 Denver 5 8 7 4000 Los Angeles 9 30 10 6000 Washington 10 6 4 3000 CPUs Available 9000 4000 8000 21,000 Develop a network representation of this problem. Formulate as a LP. Solve Using EXCEL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!