YOU MUST USE EXCEL TO SOLVE THIS PROBLEM

You have two machines under consideration for an improved automated wrapping process for Snickers Fun Size candy bars as detailed below. (a) Using an Equivalent Worth, EW analysis, determine which should be selected at i=15% per year. Be sure to show your work. (b) Assume you want machine D to be selected and are willing to extend its estimated life, if necessary. Perform this analysis to ensure D's selection using factors or a spreadsheet. How many years should D be extended to? You have two machines under consideration for an improved automated wrapping process for Snickers Fun Size candy bars as detailed below. (a) Using an Equivalent Worth, EW analysis, determine which should be selected at i=15% per year. Be sure to show your work. (b) Assume you want machine D to be selected and are willing to extend its estimated life, if necessary. Perform this analysis to ensure D's selection using factors or a spreadsheet. How many years should D be extended to