Question: Ideally, show how to answer this using excel functions. Thanks! Problem 4. An environmental engineer is considering three methods for disposing of a non-hazardous chemical
Ideally, show how to answer this using excel functions. Thanks!
Problem 4. An environmental engineer is considering three methods for disposing of a non-hazardous chemical sludge: land application, fluidized-bed incineration, and private disposal contract. The estimates for each method are below. (a) Determine which has the least cost on the basis of an EAC comparison at 10% per year. (b) Determine the equivalent present value of each alternative using its EAC value. Inciner- ation First cost, $ Annual cost, $/year Salvage value, $ Land Application - 150,000 -95,000 25,000 -900,000 -60,000 300,000 Contract 0 -170,000 0 2 Life, years 4 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
