Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with the following: -In part A are the LP assumptions (proportionality, additivity, divisibility) reasonable in this problem (see attachment for part a work

Please help with the following:
-In part A are the LP assumptions (proportionality, additivity, divisibility) reasonable in this problem (see attachment for part a work to answer this).
-I also need help with part b. Please show the full steps to get the answer.
Question: There are three factories on the Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1500 to process a ton of factory 1 waste, and each ton processed reduces the amount of P1 by 0.10 ton and the amount of P2 by 0.45 ton. It costs $2500 to process a ton of factory 2 waste, and each ton processed reduces the amount of P1 by 0.20 ton and the amount of P2 by 0.25 ton. It costs $3000 to process a ton of factory 3 waste, and each ton processed reduces the amount of P1 by 0.40 ton and the amount of P2 by 0.50 ton. The state wants to reduce the amount of P1 in the river by at least 125 tons and the amount of P2 by at least 175 tons.
a. Use Solver to determine how to minimize the cost of reducing pollution by the desired amounts. Are the LP assumptions (proportionality, additivity, divisibility) reasonable in this problem?
b. Use SolverTable to investigate the effects of increases in the minimal reductions required by the state. Specifically, see what happens to the amounts of waste processed at the three factories and the total cost if both requirements (currently 125 and 175 tons, respectively) are increased
by the same percentage. Revise your model so that you can use SolverTable to investigate these changes when the percentage increase varies from 10% to 100% in increments of 10%. Do the amounts processed at the three factories and the total cost change in a linear manner?
image text in transcribed
Insert Format Tools Data Window Help 2. C Home Insert Draw Page Layout Queries & Connections Properties Refresh Get Data (Power Data from Query) Picture All Edit Links Open recovered workbooks? Your recent changes were saved. Do you A8 fx A B C D E F G River pollutants F3 57.69231 0 298.076923 1500 3000 980769.23 Min, cost Reduction Required 125 175 X Anewer Report 2 2 Processed 3 cost per ton 4 5 6 7 B 9 10 11 12 13 14 15 Subject to Pollutant 1 P1 16 17 IN 19 20 21 1022 21 24 le 25 26 of 1 25 ote so 44 M Pollutant 2 P2 F1 0.1 0.45 Anewer Report E F2 2500 0.2 0.25 Formulas Data 0.4 0.5 Senivity Report 1 31 45 125 175 Sensitivity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for creating and managing value

Authors: Kim Langfield Smith, David Smith, Paul Andon, Ronald Hilton, Helen Thorne

8th edition

9781760420413 , 978-1760420406

More Books

Students also viewed these Accounting questions

Question

Are hyphens used correctly? (678)

Answered: 1 week ago