A metal plating company is considering four different methods for recovering byproduct heavy metals from a manufacturing site’s liquid waste. The investment costs and incomes associated with each method have been estimated as shown below. All methods have an 8-year life. The MARR is 11% per year. use Excel to solve any iterative formula, but explain your solution method on paper (please attached the excel sheet solution). (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 method should be selected, using a ROR evaluation.
3. A metal plating company is considering four different methods for recovering byproduct heavy metals from a manufacturing site’s liquid waste. The investment costs and incomes associated with each method have been estimated as shown below. All methods have an 8-year life. The MARR is 11% per year. use Excel to solve any iterative formula, but explain your solution method on paper (please attached the excel sheet solution).
(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 method should be
selected, using a ROR evaluation.
![Method
ABCD
First
Cost, $
-30,000
-36,000
-41,000
-53,000
Salvage
Value, $
+1,000
+2,000
+500
-2,000
Annual
Income, $/year
+4,000
+5,000
+8,000
+10,500](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5340c3b9-1332-4ae7-b4cf-0f576e0b0993%2F0e9294b4-ab1b-4984-97e1-4e98b62b2f1b%2F3n9rkoa_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
![Principles of Economics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305585126/9781305585126_smallCoverImage.gif)
![Managerial Economics: A Problem Solving Approach](https://www.bartleby.com/isbn_cover_images/9781337106665/9781337106665_smallCoverImage.gif)
![Managerial Economics & Business Strategy (Mcgraw-…](https://www.bartleby.com/isbn_cover_images/9781259290619/9781259290619_smallCoverImage.gif)