Please answer solution on an excel sheet (showing formulas) and please email the excel spreadsheet to gonza95c@gmail.com when completed for full credit.

The city bridge inspection team has noted 4 bridges that need replacement. Resources are available to do one of these. Proposals to repair them have been received as follows. Also shown are the number of vehicles per year that use each bridge that is an indicator of the size of the problem if the bridge would fail. Using a 10 year time span and a discount rate (MARR) of 7%, which one should be chosen. The city bridge inspection team has noted 4 bridges that need replacement. Resources are available to do one of these. Proposals to repair them have been received as follows. Also shown are the number of vehicles per year that use each bridge that is an indicator of the size of the problem if the bridge would fail. Using a 10 year time span and a discount rate (MARR) of 7%, which one should be chosen