PLEASE SHOW IN EXCEL

Youngblood Enterprises hired you because the plant must add another boiler to its steam generating system. Bids have been obtained from two boiler manufacturers as folows Boiler A S50.C00 20 Boiler 8 120 000 40 20,000 Useful l'e, N Market value at EOYN $3,000 ircreasing by $300year after the first ysar Amual Operating Costs $9,000 The MARR is 10% per year Max 10 10 20 Earmed B Create E CFT for Each Boiler | Find Aw for each Boler cl Find AW for each Boler us Aw Method Which bilar wouid ycu recommand? Use tha repeatabiity dessumplicn. Justify your answer6.5 10 Total 50 Youngblood Enterprises hired you because the plant must add another boiler to its steam generating system. Bids have been obtained from two boiler manufacturers as folows Boiler A S50.C00 20 Boiler 8 120 000 40 20,000 Useful l'e, N Market value at EOYN $3,000 ircreasing by $300year after the first ysar Amual Operating Costs $9,000 The MARR is 10% per year Max 10 10 20 Earmed B Create E CFT for Each Boiler | Find Aw for each Boler cl Find AW for each Boler us Aw Method Which bilar wouid ycu recommand? Use tha repeatabiity dessumplicn. Justify your answer6.5 10 Total 50