Á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...
icon
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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 14 images

Blurred answer
Knowledge Booster
Work measurement
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.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.