Ás an engineer, suppose you are directed to design a pumping system to safely discharge a toxic industrial waste into a municipal reservoir. The concentrated wastewater from the plant will be mixed with freshwater from the lake, and this mixture is to be pumped into the center of the lake. You realize that the more water you mix with the waste, the more dilute it will be and thus the smaller the impact on the fish in the lake. On the other hand, the more the oou use, the more it costs in electricity for pumping. Your objective is to determine the optimum amount of water to pump so the overall cost is a minimum.
Ás an engineer, suppose you are directed to design a pumping system to safely discharge a toxic industrial waste into a municipal reservoir. The concentrated wastewater from the plant will be mixed with freshwater from the lake, and this mixture is to be pumped into the center of the lake. You realize that the more water you mix with the waste, the more dilute it will be and thus the smaller the impact on the fish in the lake. On the other hand, the more the oou use, the more it costs in electricity for pumping. Your objective is to determine the optimum amount of water to pump so the overall cost is a minimum.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
please show all the work, like the graph please and how the cells were added in excell . please
![19. As an engineer, suppose you are directed to design a pumping system to safely discharge a
plant will be mixed with freshwater from the lake, and this mixture is to be pumped into the
center of the lake. You realize that the more water you mix with the waste, the more dilute
toxic industrial waste into a municipal reservoir. The concentrated wastewater from the
waten oc and thus the smaller the impact on the fish in the lake. On the other hand, the more
the onou use, the more it costs in electricity for pumping. Your objective is to determine
Cte optimum amount of water to pump so the overall cost is a minimum.
Assume that the cost of pumping is given by the expression C,
rday) depends on the pumping rate Q [gallons per minute, or gpm] of the water used
10 Q2. The cost C
pump
%3D
pump
to dilute the industrial waste.
Now, suppose that some biologists have found that as more and more water dilutes the
waste, the fish loss C [$/day] can be expressed as Csh = 2250 – 150 Q.
fish
With this information, construct a graph, with pumping rate on the abscissa showing
the pumping cost, the fish-loss cost, and total cost on the ordinate. For the scale, plot 0 to 15
gallons per minute for flow rate.
Determine both the minimum cost and the corresponding flow rate. Indicate the loca-
tion of this answer on your graph.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fa9b91490-7014-4990-b9a4-62583a5b405c%2F8ce322cc-e518-4946-85f0-0263eba66970%2F1jl12d_processed.jpeg&w=3840&q=75)
Transcribed Image Text:19. As an engineer, suppose you are directed to design a pumping system to safely discharge a
plant will be mixed with freshwater from the lake, and this mixture is to be pumped into the
center of the lake. You realize that the more water you mix with the waste, the more dilute
toxic industrial waste into a municipal reservoir. The concentrated wastewater from the
waten oc and thus the smaller the impact on the fish in the lake. On the other hand, the more
the onou use, the more it costs in electricity for pumping. Your objective is to determine
Cte optimum amount of water to pump so the overall cost is a minimum.
Assume that the cost of pumping is given by the expression C,
rday) depends on the pumping rate Q [gallons per minute, or gpm] of the water used
10 Q2. The cost C
pump
%3D
pump
to dilute the industrial waste.
Now, suppose that some biologists have found that as more and more water dilutes the
waste, the fish loss C [$/day] can be expressed as Csh = 2250 – 150 Q.
fish
With this information, construct a graph, with pumping rate on the abscissa showing
the pumping cost, the fish-loss cost, and total cost on the ordinate. For the scale, plot 0 to 15
gallons per minute for flow rate.
Determine both the minimum cost and the corresponding flow rate. Indicate the loca-
tion of this answer on your graph.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 14 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.