I AM LOOKING TO LEARN FROM THE ANSWER TO PLEASE SHOW ALL WOR

I AM LOOKING TO LEARN FROM THE ANSWER TO PLEASE SHOW ALL WORK AND POST AS MANY DETAILS AS POSSIBLE. PLEASE DO NOT POST ANY PREVIOUSLY PROVIDED ANSWERS TO SIMILAR QUESTIONS.

There are three factories on the Ohio River (A, B, C). Each emits two types of pollutants (1 and 2) 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 A waste, and each ton processed reduces the amount of pollutant 1 by 0.10 ton and the amount of pollutant 2 by 0.45 ton. It costs $1000 to process a ton of factory B waste, and each ton processed will reduce the amount of pollutant 1 by 0.20 ton and the amount of pollutant 2 by 0.25 ton. It costs $2000 to process a ton of factory C waste, and each ton processed will reduce the amount of pollutant 1 by 0.40 ton and the amount of pollutant 2 by 0.30 ton. The state wants to reduce the amount of pollutant 1 in the river by at least 30 tons and amount of pollutant 2 in the river by at least 40 tons.

A. Clearly show the model setup for this in excel

B. Describes steps necessary to use solver to determine how to minimize the cost of reducing pollution by the desired amounts.

Solution

let a,b,c be the tons of waste processed at A,B,C factories

Obj. function

Minimize 15*a + 10*b + 20*c

Constraints

1 ) 0.1*a + 0.2*b + 0.4*c >= 30 (constraint for pollutant 1)

2) 0.45*a +0.25*b + 0.3*c >= 40 (constraint for pollutant 2)

3) a>=0, b>=0, c>=0