Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
thumb_up100%
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).
- 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.
Expert Solution
To determine
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.
Expert Solution
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:
Formula:
Solver:
Output:
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
6. Demand. The quantity sold x of a high-definition TVis inversely proportional to the price p. If 85,000 highdefinition TVs sold for $1200 each, how many will besold if the price is $850 each?
Please answer C. and D.
Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months.
Month
Labor Cost
Visitors
1
$
25,820
1,700
2
$
36,290
2,592
3
$
39,968
2,811
4
$
31,648
2,222
5
$
34,809
2,373
6
$
32,672
2,181
7
$
32,023
2,205
8
$
38,334
2,676
9
$
38,568
2,760
10
$
46,933
3,572
11
$
42,157
2,976
12
$
39,030
2,804
13
$
34,444
2,415
14
$
33,173
2,336
15
$
36,971
2,508
16
$
26,500
2,099
17
$
30,663
3,397
18
$
29,961
2,786
19
$
27,590
2,412
20
$
30,003
2,972
21
$
25,692
2,000
22
$
24,655
1,794
23
$
28,892
3,267
24
$
30,153
3,817
25
$
28,119
2,592
26
$
31,690
3,274
27
$
28,651
2,989
28
$
29,927
3,050
29
$
28,438
2,511
30
$
27,874
2,075…
Turnover is planned at 2.5 for the six-month peris starting February 1 through July 31. Average weekly sales for that period are $75,000. What average stock should be carried in this situation? $800,000 $900,000 O $720,000 $780,000
Chapter 11 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 11 - Kelson Sporting Equipment, Inc., makes two types...Ch. 11 - The Sea Wharf Restaurant would like to determine...Ch. 11 - Blair Rosen. Inc. (BR) is a brokerage firm that...Ch. 11 - Round Tree Manor is a hotel that provides two...Ch. 11 - Industrial Designs has been awarded a contract to...Ch. 11 - Vollmer Manufacturing makes three components for...Ch. 11 - Photon Technologies, Inc., a manufacturer of...Ch. 11 - The Westchester Chamber of Commerce periodically...Ch. 11 - The management of Hartman Company is trying to...Ch. 11 - The employee credit union at State University is...
Ch. 11 - The Atlantic Seafood Company (ASC) is a buyer and...Ch. 11 - The Silver Star Bicycle Company will manufacture...Ch. 11 - The Clark County Sheriff’s Department schedules...Ch. 11 - Bay Oil produces two types of fuel (regular and...Ch. 11 - Consider the following network representation of a...Ch. 11 - Refer to the transportation problem described in...Ch. 11 - Aggie Power Generation supplies electrical power...Ch. 11 - The Calhoun Textile Mill is in the process of...Ch. 11 - Refer to the Calhoun Textile Mill production...
Knowledge Booster
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
- An employee in Cuttack spends Rs. 750 pm. The cost of living index for 998 is 160. From the following data, ascertain the amount he spends on (i) ood, and (ii) fuel. Group Food Clothing Rent Fuel Misc. ? Expenditure Index ? 125 150 75 190 181 140 118 101arrow_forwardQ. 3 Anywhere Health Care Facility performed 692 surgical procedures during March and administered 652 anaesthetics. Deaths resulting from the administration of an anaesthetic totalled five for the month. Find Anaesthesia death rate.arrow_forward2. Draw diagrams to represent the following situations. a. The amount of flour that the bakery used this month was a 50% increase relative to last month. b. The amount of milk that the bakery used this month was a 75% decrease relative to last month.arrow_forward
- According to data from a Texas agricultural report, the amount of nitrogen (in lbs/acre), phosphate (in lbs/acre), and labor (in hr/acre) needed to grow honeydews, yellow onions, and lettuce is given in the following table. Source: The AMATYC Review. Let Nitrogen Phosphate Labor Phosphate (in lbs): Labor (in hours): Honeydews 120 180 4.97 h = # of acres of honeydew, y = # of acres of yellow onions, and 1=# of acres of lettuce planted. Assuming that the farmer has 26800 lb of nitrogen, 25000 lb of phosphate, 400 hours of labor, and 290 acres available for planting, write down a system of equations for the resources. Nitrogen (in lbs): Acreage (in acres): Yellow Onions 150 80 4.45 Lettuce 180 80 4.65arrow_forwardThe number of gallons of milk sold each day at a grocery store ........... variable .arrow_forwardThe amounts of power used in an electrical maintenance shop are as follows: April, 41.2 kilowatt-hours; May, 59.25 kilowatt-hours; June, 53.63 kilowatt-hours; July, 62.4 kilowatt-hours; August, 63.75 kilowatt- hours; September, 30.35 kilowatt-hours. What is the average monthly power usage? Express the answer to the nearest hundredth.arrow_forward
- A furniture store expects to sell 120 coffee tables during the next year. It costs $1.50 to store one coffee table for one year. To reorder, there is a fixed cost of $10, plus $2.80 for each coffee table ordered. In what lot size and how many times per year should an order be placed to minimize inventory costs? coffee tables per order orders per yeararrow_forwardThe Deinell-Forging-Corporation manufactures four highly confidential products that it supplies to ammunition firms that hold RSA government contracts. Each product must pass through the following departments before being shipped: forging, cleaning, weighing, and inspection. The time requirement in hours for each unit and its corresponding profit value are summarised in the following table: Department Product Forging Cleaning Weighing Inspection |хм122 Unit profit (Rand) 0.6 0.3 0.3 0.5 11000 XJ312 1.5 4 2. 14000 RM122 RM126 1.5 2. 1. 0.5 17000 1. 1.5 13000 Monthly available production in each department and the minimum monthly production requirement to fulfil these contracts are: Сараcity Departme (hours) Product Minimum production level Forging Cleaning Weighing Inspectior 10000 RM126 13000 XM122 130 15000 XJ312 80 24000 RM122 260 320 The production manager needs to specify production levels for each product for the next month. Formulate this problem to help him maximise the total…arrow_forward1. Juan has a net monthly income of $4800 and is willing to spend 11% of that income on groceries, and % on entertainment. How much money does he devote to each category?arrow_forward
- A campus student group is raising funds for charity by selling cups of boba tea. The expenses incurred by this student group are the cost of materials, estimated at $2 per cup (tea, boba, milk, sugar, cups, the big honking straws, napkins, etc.) and the $150 cost of renting the brewing and cooking space. The group will charge students $4 for each cup.a. Write down the associated cost, revenue, and profit functions. b. How many cups of boba must they sell to break even?c. What profit (or loss) results from the sale of 50 cups?arrow_forwardI need assistance with parts a, b, and c. Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment (in thousands) for Jefferson Community College for the nine most recent years. Click on the datafile logo to reference the data. Year Period (t) Enrollment(1,000s) 2001 1 6.5 2002 2 8.1 2003 3 8.4 2004 4 10.2 2005 5 12.5 2006 6 13.3 2007 7 13.7 2008 8 17.2 2009 9 18.1 A. Choose the correct time series plot. What type of pattern exists in the data? Positive trend pattern or negative trend pattern B. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = Slope, b1 = MSE= C. What is the forecast for year 10? Do not round your interim computations and round your final answer to two decimal places.arrow_forwardplease, show step by step in answering questionsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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