PLEASE SHOW IN EXCEL

The alternatives for an engineering praject to recover most of the energy presently being lost in the primary cooling stage of a chemical essing system have been reducea to three designs. The esimated capital investment amounts and annual expense savings are as follows Energy Recovery 1 125,000 Energy Rec Investmert Costs $180.000 S135.000 e Creeta a CFT fcr Each Energy Recvery altemative 15 Annual Expanse Savings in EOY1 530,000 560,500 40,000 b Find AW fo each E Excel Formula 15 e Ater year one, ths annualb Ainer yar one, ths annual savings are ostimaledto ncrease $150 saings are estmated to icrease $159 Unform sequence mrwai savings c Find A'W for each Energy FR usna Aw Method 15 Useul Lfe(Years) Which Ererngy Recovery project would ycu recommand? Justity your answer using AW Method fCite the Decision Rule and 10 10 number from your te Salvage Velue $60.000 $80,000 $7C,000 Total 50 MARR 14% 14% 14% The alternatives for an engineering praject to recover most of the energy presently being lost in the primary cooling stage of a chemical essing system have been reducea to three designs. The esimated capital investment amounts and annual expense savings are as follows Energy Recovery 1 125,000 Energy Rec Investmert Costs $180.000 S135.000 e Creeta a CFT fcr Each Energy Recvery altemative 15 Annual Expanse Savings in EOY1 530,000 560,500 40,000 b Find AW fo each E Excel Formula 15 e Ater year one, ths annualb Ainer yar one, ths annual savings are ostimaledto ncrease $150 saings are estmated to icrease $159 Unform sequence mrwai savings c Find A'W for each Energy FR usna Aw Method 15 Useul Lfe(Years) Which Ererngy Recovery project would ycu recommand? Justity your answer using AW Method fCite the Decision Rule and 10 10 number from your te Salvage Velue $60.000 $80,000 $7C,000 Total 50 MARR 14% 14% 14%