Please work in excel

Thank you!!

16-30 The Fishery and Wildlife Agency of Ireland is considering four mutually exclusive design alterna- tives for a major salmon hatchery. This agency of the Irish government uses the following B/C ratio for . G decision making (EW = EUAW): B/C ratio = EW(Net benefits) EW(Capital recovery cost) + EW(O&M cost) Using an interest rate of 7% and a project life of 30 years, recommend which design is best. (Values in 1000s) Irish Fishery Design (Values in 1000s) Irish Fishery Design Alternatives A B D First cost Annual benefits Annual O&M costs Annual disbenefits Salvage value $10,000 $12,000 $14,000 $16,000 2,200 550 175 1,500 1,000 2,400 325 145 350 150 1,500 75 500 3,000 4,000 6,000 16-30 The Fishery and Wildlife Agency of Ireland is considering four mutually exclusive design alterna- tives for a major salmon hatchery. This agency of the Irish government uses the following B/C ratio for . G decision making (EW = EUAW): B/C ratio = EW(Net benefits) EW(Capital recovery cost) + EW(O&M cost) Using an interest rate of 7% and a project life of 30 years, recommend which design is best. (Values in 1000s) Irish Fishery Design (Values in 1000s) Irish Fishery Design Alternatives A B D First cost Annual benefits Annual O&M costs Annual disbenefits Salvage value $10,000 $12,000 $14,000 $16,000 2,200 550 175 1,500 1,000 2,400 325 145 350 150 1,500 75 500 3,000 4,000 6,000