DO NOT SOLVE IT WITH EXCEL PLEASE

Multiple Alternative (More than Two) Evaluation A metal plating company is considering four different methods for recovering by-product heavy metals from a manufacturing site's liquid waste. The investment costs and annual net incomes associated with each method have been estimated. All methods have an 8-year life; the MARR is 11% per year and an AW-based ROR analysis is required. (a) If the methods are independent (because they can be implemented at different plants), which ones are acceptable? (b) If the methods are mutually exclusive, determine which one should be selected First Cost, $ 30,000 -36,000 -41,000 -53,000 Salvage Value, $ +1,000 +2,000 +500 2000 Annual Net Income, S/Year +4,000 +5,000 +8,000 +10,500 Method