Topic $5$: Annual Cash Flow Analysis $($Please show your calculations, cash

flow diagrams, results and conclusions$)$

Your industrial engineering group has been selected to consider a project for an additional water supply line for your town. The town's engineer has selected two plans for comparison. A gravity plan that would divert water at a point $10$ miles up from a creek, that will be the source of the water supply and carried through a pipeline by gravity to the town. The other plan is to use a pumping station that would divert water at a point closer to town and pump it into the town. The pumping plant would be built in two stages, with $75\%$ of its capacity installed initially and the remaining $25\%$ installed $10$ years later. The engineer has assumed that each plan will last $40$ years and be worthless at the end of its life. Use the following provided data and an interest rate of $8\%,$ and determine the maximum that should be paid for the gravity plan. And must present results utilizing $2$ out of the $3$ computational techniques involving the use of equations, and$/$or compounding interest table, and$/$or spread sheets to show a checks and balance approach to the results.