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).
- a. If there are no restrictions on the amount of power that can be supplied by any of the power plants, what is the optimal solution to this problem? Which cities should be supplied by which power plants? What is the total annual power distribution cost for this solution?
- b. If at most 4,000 MWs of power can be supplied by any one of the power plants, what is the optimal solution? What is the annual increase in power distribution cost that results from adding these constraints to the original formulation?
a.
Find the optimal solution and total annual power distribution plan.
Explanation of Solution
The linear programming model can be formulated as:
subject to
Formula:
Solver:
Output:
The total distribution cost of this solution is $2,552,382.81
b.
Find the optimal solution if at most 4,000 MWs of power is supplied.
Explanation of Solution
Other constraints that should be added in the model are:
Formula:
Solver:
Output:
The optimal solution is shown in the above output.
Want to see more full solutions like this?
Chapter 8 Solutions
Essentials Of Business Analytics
- What is the total effect on the economy of a government tax rebate of $1,000 to each household in order to stimulate the economy if each household will spend 90% of the rebate in goods and services?arrow_forwardCell Phone Plans Gwendolyn is mulling over the three cell phone plans shown in the table. Gigabytes GB of data included Monthly Cost Each additional megabytes MB Plan A Plan B Plan C 1 1 1 25.00 40.00 60.00 2.00 1.50 1.00 From past experience, Gwendolyn knows that she will always use more than 1GB of cell phone data every month. aMake table of values that shows the cost of each plan for 1 GB to 4 GB, in 500 MB increments. bFind formulas that give Gwendolyns monthly cost for each plan, assuming that she uses x gigabytes of data per month where x1. cWhat is the charge from each plan when Gwendolyn uses 2.2 GB? 3.7 GB? 4.9 GB? d Use your formulas from part b to determine the number of gigabytes of data usage for which: (i) Plan A and Plan B give the same cost. (ii) Plan A and Plan C give the same cost. (iii) Plan B and Plan C give the same cost.arrow_forward
- Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningAlgebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal LittellTrigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
- Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL