Topic $5$: Annual Cash Flow Analysis

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.