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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!