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 $500 to each household in order to stimulate the economy if each household will spend of the rebate in goods and services?arrow_forwardIf during the following year it is predicted that each comedy skit will generate 30 thousand and each musical number 20 thousand, find the maximum income for the year. A television program director must schedule comedy skits and musical numbers for prime-time variety shows. Each comedy skit requires 2 hours of rehearsal time, costs 3000, and brings in 20,000 from the shows sponsors. Each musical number requires 1 hour of rehearsal time, costs 6000, and generates 12,000. If 250 hours are available for rehearsal and 600,000 is budgeted for comedy and music, how many segments of each type should be produced to maximize income? Find the maximum income.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
- College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage LearningAlgebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning