Three engineers made the estimates shown below for two optional methods by which new construction technology would be implemented at a site for public housing. Either one of the two options or the current method may be selected. Set up a spreadsheet for B/C sensitivity analysis and determine if option 1, option 2 or the do-nothing option is selected by each of the three engineers. Use a life of 5 years and a discount rate of 10% per year for allanalyses.

Engineer Judy Option 1 0ption 2 Option 1 Option 2 Option1 Option 2 50,000 90,000 75,000 90.000 60,000 70,000 3,000 4,000 3,800 3,000 6,00 3,000 Engineer Bob Engineer Chen Initial cost, $ Cost, S/year Benefits, S/year 20,000 29,000 30,000 35.000 30,000 35,000 Disbenefits, S/year 50,500 1000 0 5,000 1,000