solve it by excel and step by step clearly !!

620 You have two machines under consideration for an improved automated wrapping process for Snick- ers Fun Size candy bars as detailed below. (a) Using an AW analysis, determine which should be selected at 15% per year. 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. (b) Machine First cost, $ Annual cost, S/year Salvage value, S Life, years -40,000 -10,000 12,000 -65,000 -12,000 25,000 6