Use a spreadsheet for evaluation of the multiple alternatives provided below. You will have to read the chapter on Public Sector to figure this out. Use incremental B/C analysis. These alternatives are relative to the application of nanotechnology and the use of thin-film solar panels applied to houses to reduce the dependency on fossil-fuel generated electrical energy. A community of 400 new all-electric public housing units will utilize the technology as anticipated proof that significant reductions in overall utility costs can be attained over the expected 15-year life of the housing. The table below details the three bids received. Also included are estimated annual electricity usage costs for the community with the panels in use, and the PW of backup systems required in case of panel failures. Use i = 5% per year to select the best bid. Turn in the spreadsheet with calculations and the best alternative highlighted in pink. Alternatives estimated for use of Nanocrystal-Layered Thin-Film Solar Panel Technology for Energy Geyser, Inc. Harris Corp. Crumbley, LLP C 6,150,000 2,400,000 Bidder Bid identification PW of initial cost, $ Annual maintenance, S/year Annual utility bill, S/year PW of backup systems, S 450,000 500,000 960,000 650,000 1.850,000 650,000 1,000,000 750,000 550.000 950.000