please solve using excel

& 3 Aubum Recreation and Parks Department is considering two mutually exclu- sive proposals for a new softball complex on a city-owned lot Alternative Seating Annual Annual Required Design Capadi Benefits Coses Investment AL 3,000 $194.000 $87500 $800000 A2 4.000 $224000 S105000 $1000000 The complex will be useful for 30 years and has no appreciable salvage value (regardless of seating capacity). Assuming an 8% discount rate, which of the following statements is incorrect? (a) Sclect A1 because it has the largest B/C ratio. (b) Select Al because it has the most benefits per seating capacity (c) Select A1 because it has the largest PW. (d) Select Al because the incremental benefits generated from A2 are not large enough to offset the additional investment ($200,000 more than At)