$!$ Required information Problem $08\mathrm{.}043-$ Purchase decision DVH Technologies purchases several parts for the instruments it makes via a fixed$-$price contract of $\backslash$$$170,000$ per year from a local supplier. The company is considering making the parts in$-$house through the purchase of equipment that will have a first cost of $\backslash (\backslash$$ $240,000\backslash )$ with an estimated salvage value of $\backslash (\backslash$$ $30,000\backslash )$ after $5$ years. The AOC is difficult to estimate, but company engineers have made optimistic, most likely, and pessimistic estimates of $\backslash (\backslash$$ $71,000,\backslash$$ $85,000\backslash ),$ and $\backslash (\backslash$$ $120,000\backslash ),$ respectively. The MARR is $\backslash (20\backslash \%\backslash )$ per year. Problem $08\mathrm{.}043.$a $-$ Make or purchase decision Use spreadsheet functions to determine if the company should purchase the equipment under any of the AOC scenarios. The spreadsheet function to determine the AW for the optimistic scenario is $],$ the AW value for the optimistic scenario is $\backslash$$$,$ and the company should $($Click to select$)\backslash (\backslash$vee $\backslash )$ the parts for the optimistic scenario. The spreadsheet function to determine the AW for the most likely scenario is $($Click to select$),$ the AW value for the most likely scenario is $\backslash$$$,$ and the company should $($Click to select$)$ the parts for the most likely scenario. The spreadsheet function to determine the AW for the pessimistic scenario is $($Click to selec $|,$ the AW value for the pessimistic scenario is $\backslash (\backslash$$$-\backslash ),$ and the company should $($Click to select$)\backslash (\backslash$vee $\backslash )$ the parts for the pessimistic scenario.