Dewatering the Gilcrest Area $[10$ points$]$

The Gilcrest, Colorado area has encountered problems with high groundwater levels in the past $6$ years. The town would like to solve the groundwater problem by dewatering the upper portion of the aquifer, with a target of $10ft$ of drawdown at the center of the affected neighborhood. The following $3$ pumping wells will be used $($see map below$)$:

Irrigation well Pumping rate $=1,500ga\frac{l}{m}in$;$1,820ft$ from the center of the neighborhood

Gilcrest Park well Pumping rate $=900ga\frac{l}{m}in$;$375ft$ from the center of the neighborhood

Gilcrest well Pumping rate $=300ga\frac{l}{m}in$;$3,710ft$ from the center of the neighborhood

Aquifer $T$ and $S_y$ are estimated to be $12,600f\frac{t^2}{?}$ day and $0\mathrm{.}35,$ respectively.

Do the following:

a$)$ Provide a plot of drawdown $(ft)$ at the center of neighborhood. How long to achieve $10ft$ of drawdown? Of this drawdown, report the $\%$ contribution from each of the $3$ pumping wells.

b$)$ For the time found in a$),$ show a map of drawdown using the Theis$\_$DrawdownSimulator spreadsheet VBA program.