3. Use a spreadsheet for evaluation of the multiple alternatives provided below. 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 Bidder Crumbley, LLP Geyser, Inc. G Harris Corp. Bid identification PW of initial cost, $ 2,400,000 1.850,000 6.150.000 500,000 650,000 450,000 Annual maintenance, $/year Annual utility bill, $/year PW of backup systems, $ 960,000 650,000 1,000,000 750,000 550,000 950,000