Authority Rate Calculations

Home › Authority Rate Calculations

Summary Calculation of 2020 Water Rate

Below is a spreadsheet that projects costs for each member community for the year 2019 based on set water quantities. Also shown are actual costs for water consumed by each community in 2017. The difference and percentage change indicate the difference between 2017 actual's and 2018 projected usage.

	2019 Rate-Funded Costs	2019 Projected Sales	2019 Unit Rate per 1,000 gal
Fixed Costs	$9,403,836	2,473,000	$3.80
Operation & Maintenance	$2,860,667	2,473,503	$1.16
Total:	$12,264,503		$4.96
Rebate at $/1,000 gal			-

Member Community	2020 Projected		2019 Actual		Difference	Change
Member Community	Flow per 1,000 gals	Annual @$4.96	Flow per 1,000 gals	Annual @$4.99	Difference	Change
Allouez	410,000	$2,033,600	401,495	$2,003,460	$30,140	1.50%
Bellevue	390,000	$1,934,400	408,281	$2,037,322	($102,922)	-5.05%
De Pere	790,000	$3,918,400	751,968	$3,752,320	$166,080	4.43%
Howard	595,000	$2,951,200	594,129	$2,964,704	($13,504)	-0.46%
Lawrence	88,000	$436,480	88,631	$442,269	($5,789)	-1.31%
Ledgeview	200,000	$992,000	211,056	$1,053,169	($61,169)	-5.81%
Total:	2,473,000	$12,266,080	2,455,560	$12,253,244	$12,836	0.10%