Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd
Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams' Essentials Of Business Analytics, 2nd
2nd Edition
ISBN: 9781305861794
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
100%
Book Icon
Chapter 11, Problem 18P

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).

Chapter 11, Problem 18P, Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its

  1. 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?
  2. 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.

Expert Solution
Check Mark
To determine

Find the optimal solution and total annual power distribution plan.

Explanation of Solution

The linear programming model can be formulated as:

Min(356.26xL1+356.25xL2+178.13xL3+356.25xL4+237.50xL5+415.63xL6+356.25xL7+356.25xL8+178.13xL9+356.25xL10+593.75xT1+593.75xT2+475.00xT3+475.00xT4+475.00xT5+415.60xT6+415.63xT7+356.25xT8+475.00xT9+296.88xT10+59.38xS1+178.13xS2+296.88xS3+296.88xS4+356.25xS5+296.88xS6+356.28xS7+475.00xS8+593.75xS9+593.75xS10)

subject to

xL1+xr1+xs1950xL2+xr2+xs2831.25xL3+xr3+xs32375xL4+xr4+xs4593.75xL5+xr5+xs5950xL6+xr6+xs6593.75xL7+xr7+xs71187.50xL8+xr8+xs8712.50xL9+xr9+xs91187.50xL10+xr10+xs101543.75xij0,i=L,T,S,j=1,2...,10

Formula:

Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd, Chapter 11, Problem 18P , additional homework tip  1

Solver:

Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd, Chapter 11, Problem 18P , additional homework tip  2

Output:

Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd, Chapter 11, Problem 18P , additional homework tip  3

The total distribution cost of this solution is $2,552,382.81

b.

Expert Solution
Check Mark
To determine

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:

xL1+xL2+xL3+xL4+xL5+xL6+xL7+xL8+xL9+xL104000xr1+xr2+xr3+xr4+xr5+xr6+xr7+xr8+xr9+xr104000xs1+xs2+xs3+xs4+xs5+xs6+xs7+xs8+xs9+xs104000

Formula:

Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd, Chapter 11, Problem 18P , additional homework tip  4

Solver:

Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd, Chapter 11, Problem 18P , additional homework tip  5

Output:

Mindtap Business Analytics, 1 Term (6 Months) Printed Access Card For Camm/cochran/fry/ohlmann/anderson/sweeney/williams'  Essentials Of Business Analytics, 2nd, Chapter 11, Problem 18P , additional homework tip  6

The optimal solution is shown in the above output.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Homework Let X1, X2, Xn be a random sample from f(x;0) where f(x; 0) = (-), 0 < x < ∞,0 € R Using Basu's theorem, show that Y = min{X} and Z =Σ(XY) are indep. -
Homework Let X1, X2, Xn be a random sample from f(x; 0) where f(x; 0) = e−(2-0), 0 < x < ∞,0 € R Using Basu's theorem, show that Y = min{X} and Z =Σ(XY) are indep.
An Arts group holds a raffle.  Each raffle ticket costs $2 and the raffle consists of 2500 tickets.  The prize is a vacation worth $3,000.    a. Determine your expected value if you buy one ticket.     b. Determine your expected value if you buy five tickets.     How much will the Arts group gain or lose if they sell all the tickets?
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY