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


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
Get step-by-step solutions from verified subject matter experts
