Question: Can you solve this please using EXCEEL ? and please shows the formulas 2. You are a member of an engineering project team that is

Can you solve this please using EXCEEL ? and please shows the formulas
2. You are a member of an engineering project team that is designing a new processing facility. Your present design task involves the portion of the system that requires pumping a slurry that is corrosive and contains abrasive particles. For final analysis and comparison, you have narrowed it down to two pump units of equal output capacity, from different manufacturers. Both will provide the same level of service, but have different useful lives and costs. SP240 $33,200 HEPS9 $47,600 Capital investment Annual expenses Electrical energy $2165 $1720 $1100 in year 1 and increasing $500/yr thereafter $500 in year 4 and increasing $100/yr thereafter Maintenance Useful Life (years) Salvage value at end of useful life $0 $5000 (a) If the MARR is 20%, which pump should you select (use an annual worth calculation)? (b) What would the capital cost of SP240 have to be such that the firm would be indifferent to pump selection
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
