Is my solution correct and did I fully answer the questions? (see attachment for my solution)Question: There are three factories on 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 $1,500 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 $2,500 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 $3,000 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 amount 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 amount processed at the three factories and the total cost change in a linear manner? 1Calibri✓ 11VA A• Α' Α΄0PasteBI UVAvOpen recovered workbooks? Your recent changes were saved. Do you want to ce22X-xv fxABCDEFGHRiver pollutantsF1Processed57.6923077298.076923102500cost per ton15003000980769.231 Total costF1ReductionRequired125Pollutant 10.10.20.4125 >Pollutant 20.450.250.5175X17591012 work. Still, it is reasonable that these assumptions hold.11 The proportionality and additivity assumptions may seem to cause doubt due to the way that chemical reactions1314 % change in reqirementsProcessed 163.46Processed 2 Processed 30.001510%Cost327.88357.691078846.151176923.0820%69.230.0030%75.000.00387.501275000.0040%80.770.001373076.92417.31447.1250%86.540.001471153.8560%92.310.00476.921569230.7770%98.081667307.6980%103.850.000.000.000.00506.73536.54566.351765384.6290%109.621863461.54100%115.38596.15 1961538.4610%5.770.0029.8198076.9210%5.770.0029.8198076.9210%5.770.0029.8198076.9210%5.770.0029.8198076.9210%5.770.0029.8198076.9210%5.770.0029.8198076.9210%5.770.0029.8198076.9210%5.770.0029.8198076.9210%5.770.0029.8198076.92by the same value each time.The results change in a linear manner as shown above because each column above changesWaste that will be treated at factory 1 increases by 5.77 tons for every 10% increase in reduction of both the pollutants.Waste that will be treated at factory 3 increases by 29.81 tons for every 10% increase in reduction of both the pollutants.Answer Report 1Sensitivity Report 1Answer Report 2Sensitivity Report 2JUN22345678561617181920212223242526 Differences272829S30313233343536373839404142434445ReadyOF2F2F3F3

With help of excel solver we can generate sensistivity and limits report based on which we can…

Is my solution correct and did I fully answer the questions? (see attachment for my solution) Question: There are three factories on 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 $1,500 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 $2,500 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 $3,000 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 amount 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 amount processed at the three factories and the total cost change in a linear manner?

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

See similar textbooks

Related questions

Question

100%

Is my solution correct and did I fully answer the questions? (see attachment for my solution)

Question: There are three factories on Momiss River. Each emits two types of pollutants, labeled P₁ and P₂, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1,500 to process a ton of factory 1 waste, and each ton processed reduces the amount of P₁by 0.10 ton and the amount of P₂by 0.45 ton. It costs $2,500 to process a ton of factory 2 waste, and each ton processed reduces the amount of P₁by 0.20 ton and the amount of P₂by 0.25 ton. It costs $3,000 to process a ton of factory 3 waste, and each ton processed reduces the amount of P₁ by 0.40 ton and the amount of P₂by 0.50 ton. The state wants to reduce the amount of P₁in the river by at least 125 tons and the amount of P₂ 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 amount 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 amount processed at the three factories and the total cost change in a linear manner?