Should be in (((((Excel spreadsheet )))))

Answer is : AW: = -$24,063 (Machine C) (solve part (a) and part (b), Use goal seek tool for part (b)

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