Search

Authority Rate Calculations

Summary Calculation of 2018 Water Rate

Below is a spreadsheet that projects costs for each community for the year 2018 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. 

  2018 Budgeted Cost 2018 Projected Sales  2018 Unit Rate per 1,000 gal
 Fixed Costs  $9,412,777
 2,482,000 
 $3.79 
 Operation &
 Maintenance 
 $2,860,742 
 2,482,000 
 $1.15 
 Total: 
 $12,215,482 
   $4.94
Maximum impact at 3% increase   $4.56
Rebate at $/1,000 gal   $0.38





Member

Community
2018 
Projected
2017
 Actual




Difference
 



Change

Flow per 1,000 gals

Annual

@$4.94

Flow per 1,000
gals

Annual @$4.89
 Allouez  410,000  $2,025,400 379,384 
 $1,855,188 
 $170,212
 9.17% 
 Bellevue  415,000  $2,050,100 378,715
 $1,851,916 
 $198,184
 10.70% 
 De Pere  800,000  $3,952,000 769,396
 $3,762,346 
$189,654
 5.04% 
 Howard  610,000  $3,013,400 572,804
$2,801,012 
 $212,388 
 7.58% 
 Lawrence  82,000  $405,080 86,545 
$423,205 
 ($18,125) 
 -4.28% 
 Ledgeview 
 165,000  $815,100 161,454 
 $789,510 
 $25,590
 3.24% 
 Total:  2,482,000 $12,261,080  2,348,298 
 $11,483,177
 $777,903 
 6.77% 








3100 Eaton Road
Bellevue, WI 54311
(920) 593-1695

Waveville