Question: do not use excel show all steps for thump up please help me correct my mistakes use AW and not PW 1. (20 Points) A


1. (20 Points) A public agency is considering four mutually exclusive alternatives in addition, the do-nothing alternative is feasible). Use the benefit to cost ratio method to determine which of the alternatives is preferable, given an interest rate of 12% per year. Alternative A B D Initial Cost (SK) Annual Benefit (SK) 100 30 120 35 250 50 175 38 Life (years) 10 5 15 6 rest Can't compare PW es alternatwer .7 compare Aw Benedit to cost ratio = (Presort value of benent t-atron have different F Alternate Ai 30 (1-C12-7a3ale ) = 30(6.65cm) 169.506820 12 B/C = 169.50669 - 1.69506 too Alternative B 22 2.5 ( FUJ = 36(3.6047=126.1676 B/C- 126-16716 10 5139 too Alternthe ci to ( Hiriasis) - sofa.3.1636) - 340, 64333 B/C = 340.54322. 1. 36217 246 Alternative Di 37(")= 33( 414= 16.6.23397 -0.842762 175 project A because it has the X highest benefit to castratio B/C= 156.23347
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
