In: Math
Problem 10-07 (Algorithmic)
Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie Power Generation's major residential markets, the annual demand in each market (in megawatts or MWs), and the cost to supply electricity to each market from each power generation plant (prices are in $/MW).
Distribution Costs | ||||
City | Los Angeles | Tulsa | Seattle | Demand (MWs) |
---|---|---|---|---|
Seattle | $351.25 | $588.75 | $54.38 | 945.00 |
Portland | $370.25 | $607.75 | $192.13 | 845.25 |
San Francisco | $168.13 | $465.00 | $286.88 | 2365.00 |
Boise | $344.25 | $463.00 | $284.88 | 581.75 |
Reno | $235.50 | $473.00 | $354.25 | 948.00 |
Bozeman | $429.63 | $429.63 | $310.88 | 507.15 |
Laramie | $377.25 | $436.63 | $377.25 | 1208.50 |
Park City | $383.25 | $383.25 | $502.00 | 630.25 |
Flagstaff | $210.13 | $507.00 | $625.75 | 1150.19 |
Durango | $341.25 | $281.88 | $578.75 | 1450.25 |
Answer:
a)
b)
The optimal solution is to produce 3800.00 MWs in Los Angeles
c) The optimal solution is to produce 3031.34 MWs in Tulsa
c) The optimal solution is to produce 3800.00 MWs in Seattle
d) The total distribution cost of this solution is $2,641,210.69
e) The increase in cost associated with the additional constraints is 2,641,210.69 - 2,505,996.00 = $135,214.69