Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Memo - Enterprise Fund Budget Info
CITY OF HOPKINS FIN.ANCI1:: ARtMI1NT MEMORANDUM Date: October 21,2005 To: Mayor & City Council From: Christine Harkess, Finance Director Subject: Enterprise Fund Budget Information Attached is.a multitude of financial information as it relates to the water, sanitary sewer, storm sewer and refuse funds. At this work session I have the set the following goals: 1. Review 2006 Proposed Budgets 2. Review analysis of working capital 3. Review consumption and corresponding revenues for the past 8-9 years 4. Review revenue, expenditure and net income history for past 8-9 years 5. Evaluate rate structure and proposed rate increases for 2006. a. Sewer rate increase proposal of 0.25 from $2.25 to $2.50 b. Storm Sewer rate increase proposal of 0.50 from $4.00 to $4.50 6. Consider conducting a rate study on our water and sewer rates to set a long-term rate structure to meet operational goals of these funds. Materials, Supplies and Service! 540 Office Supplies 541 Uniforms/Clothing 542 General Supplies 543 Equipment & Vehicle Parts 544 Structural Supplies 545 Parts and Supplies 549 Motor Fuels & Lubricants 555 Chemicals 839 ,794 25,685 395 6,875 2,511 32,855 1,413 2,807 33,076 800 2,800 33,500 1,600 2,200 26,000 1,600 3,300 35,000 1,763 1,355 1,562 15,601 6,433 14,642 619 2,403 511 EXPENSES Salaries and Employee Benefits 500 Regular Employees 50 I Overtime-Regular Employees 503 Part-Time Employees 524 SL Converted/L TD 525 P .E.R.A. Contribution 526 F .LC.A. Contribution 527 Cafeteria Benefit Plan 530 Other Benefits 531 Workers' Compensation Ins 532 Unemployment Benefits 533 Deferred Compensation 535 Paid Leave Accrual TOTAL 1,814 3,876 312,759 2,397 4,476 311,098 572 4,663 294,690 308 2,358 305,097 510 2,060 262,831 2,203 275.878 5,257 19,432 1,621 12,433 17,619 28,265 214,946 7,497 220,230 9,743 205,404 12,034 221,314 8,836 4,575 85,137 8,100 18,000 1,388 11,558 16,294 28,623 $ $ $ $ $ 173,693 8,100 $ REVENUES 400 Water Service Charge 417 Connection Permits 370 Interest Earned 409 Other Service Charges 419 Antenna Lease 490 Transfer In TOTAL $ 166,108 1,060,698 826,430 10,500 38,860 8,486 10,314 CODE DEPARTMENT 1,152 1,562 1,085 12,389 1,900 1,300 900 9,300 2,515 1,500 1,300 13,300 2,515 1,600 1,300 14,000 4,721 4,761 1,554 12,716 17,804 32,697 $ 967,390 911,397 11,508 24,594 8,861 11,030 WATER $ $ REVENUE AND EXPENSE DETAIL SUMMARY Projected Actual 2005 3,671 7,475 1,843 11,846 16,156 31,026 $ 844,017 803,287 2,081 17,889 20,760 Actual 2002 Actual 2003 $ Actual 2004 $ $ Budget 2005 $ Budget 2006 FUND 703 Percent Change -6.88% -14.29% -31.03% -20.00% 20.00% #DIV/O! -7.36% 6.59% -10.00% 6.93% 15.12% 4.99% 3.67% #DIV/O! 14.38% #DIV/O! -100.00% 6.94% 4.96% 6.67% 5.26% #DIV/O! 50.00% 34.62% 3,341 1,000 2,020 12,504 16,450 36,966 4,000 20,000 1,298 10,040 15,519 27,611 $ 1,000,600 18,000 8,000 18,000 947,100 9,500 $ 1,131,200 1,063,200 14,000 29,000 10,000 15,000 $ 1,048,000 990,000 12,000 20,000 8,000 18,000 396 OPERATING INCOME TOTAL OPERATING EXP. $ $ 347,5 7 $ $ 203,074 764,316 $ $ 105,555 738,462 $ 278,323 $ $ 410,884 $ $ 289,305 -29.59% Materials, 560 Postage 563 Maint & Repair-EquipN ehic1es 565 Maint. & Repair-Structures 567 Maint. Other 580 Audit 581 Advertising and Publication 582 Expert & Professional Services 583 Other Contractual Services 584 Communications-Telephone LocI 586 Telephone - Cellular 587 Radio Contract 588 Legal 602 Heating Fuel - Gas 604 . Electricity 605 Disposal 622 Administrative Fee 623 Garage - Labor & Burden 630 Training 633 Dues and Memberships 635 Travel and Mileage 636 Conference Fees 637 Meals & Lodging 639 Subscriptions and Publications 644 Taxes & Licenses 651 Fleet Liability 652 General Liability 653 Property Insurance 658 Insurance Deductible TOTAL 713 181 $ 722,277 720,316 758,695 5.33% 400,422 9,393 769 17,206 1,249 453,218 555 575 18,499 1,509 443,771 515 593 20,522 1,751 417,180 600 875 10,160 1,350 457,485 18,800 ,350 800 1,000 400 5,000 875 482,817 20,116 ,445 1,000 1,000 300 5,750 936 7.00% 7.00% 7.00% #DIV/O! 5.54% -25.00% 15.00% 225 34 518 225 312 158,124 4,900 169,092 5,280 27 526 559 176 5,649 90,057 540 7,832 96,213 180 8,300 98,385 3,880 160,410 5,760 375 324 375 160,360 5,500 1,500 325 160,360 5,000 2,000 400 160,360 5,000 2,000 500 25.00% #DIV/O! 25.00% 11,400 99,500 8,500 102,000 0,000 102,000 #DIV/O 5,530 413 21,023 6,220 6,694 925 3,823 2,532 15,347 125 5,030 1,005 31,119 2,339 6,800 834 4,862 11,636 21,895 15,368 2,876 8,747 3,771 4,076 4,499 29,794 14,231 5536 396 9,700 2,065 585 18,000 100 3,200 12,000 22,500 800 5,535 250 7,600 1,700 700 5,535 1,900 30,000 4,950 26,100 24, I 00 8,900 3,700 800 5,545 1,500 36,000 5,050 26,100 25,500 17.11% 117.65% 14.29% #DlV/O! 7.65% 5.81% #DIV/O! 0.18% -21.05% 20.00% #DIV/O! EXPENSES, (cont.) Supplies and Services, (c1 2.02% CODE DEPARTMENT WATER REVENUE AND EXPENSE DETAIL SUMMARY Projected Actual 2005 Actual 2002 Actual 2003 Actual 2004 Budget 2005 Budget 2006 Percent Change FUND 703 CONSTRUCTION _MEMO Moline Treatment Plant SCADA System Well Rehab #5 & #6 Water Treatment Facility Repain Water Treatment Facility, Elmo 1 Repaint Moline Tower Blake Tower Watermeter Radio Read System CSAH 73/CSAH 5 County Road 3 Nine Mile cove Water Main Residential Street Improvements TOTAL MEMO-CAPITAL OUTLAY 740 Motor Vehicles 760 Computers 790 Other Equipment TOTAL $ 5; $ $ 500 4,627 ~ 5,121 96,108 iOf584 2,600 103,876 $ '$ $ $ 397 44,119 40,216 51,896 IT6,29l $ 5; $ $ 24,394 ~ 24,394 $ 5; $ $ 50,000 ~ 50,000 75,000 ~ (52,729) 100,000 200,000 $ $ $ 75,000 i69:S42 200,000 - (l05,458) 100,000 $ $ 75,000 ~ ~72.18% #DIV/O! #DIV lot #DlV/ot #DIV 10\ #DIV/O! #DIV/O! #DIV/O! ~100.00% _100.00% _100.00% #DIV 10 50,000 50,000 $ $ 17 ,000 22,000 39,000 #DIV 10! #DIV 10\ _56.00% -22.00% RETAINED EARNINGS CODE NON:OPERA TING ExPENSES 680 Depreciation 830 Interest expense 840 Fiscal Agents Fee 930 Transfer to pIR Fund TOTAL NON_OPERATING ExP- NET INCOME (LOSS) $ $ 4,220,092 $ (23,895) 214,744 96,443 225 371,412 $ 4,112,083 $ (108,009) 227,004 83,779 300 311,083 $ 3,960,777 $ (259,316) 234,863 84,773 235 45,000 364iIT $ 3,995,199 $ (116,884) 265,000 84,907 300 45,000 395,201 $ $ 3,979,928 $ 19,152 265,000 81,433 300 45,000 391,733 $ 3,898,472 $ DEPARTMENT Actual 2002 $ Actual 2003 $ Actual 2004 $ $ $ (96,727) 265,000 75,733 300 45,000 386,033 -2.05% _605.06% -1.46% -7.00% WATER REVENUE AND EXPENSE DETJ\IL sUJ\'1MARY Projected Actual 2005 Budget 2005 Budget 2006 percent Change FUND 703 R~te \ler 1000 gallonS 39'tl LaSt r'" Increase waS In 2001 for + $.1 0 1.20 + 0.20 rate incr Cash Balance 12-31 Bond -proceeds Bond -princillal lla)'t1\ents 911,526 1.20 1~9,530 1.20 \.20 1.40 100,000 6~5,9l~ 1.40 Retained Earnings 12-31 105,000 391,064 Water Uti\1ty Net Incorne(LOss) 4,220,092 100,000 110,000 5~0,~2~ 115,000 316,636 _35.16% "Water Utility Re-Venuc 'f ota1 "Water Utility E1t\lense 'fotal (23,~95) 4,261,522 (10~,009) 4,112,0~3 3,995,199 120,000 4.35% W "'"fER u'f\ll'f'{ SUM~Y 1,060,69~ 1,OM,593 $ 961,390 1,015,399 (259,316) (\ 16,8M) 4,\31,235 3,~9~,412 CODE M4,011 1,103,332 19,152 _5.63% ~"""""" ~ E1O'ErlSE DE'fML Sll~NlY ,~v """ V" PrOjected p....cwa\ p....ctUa\ 2004 2005 ~ DEY AR'fNlE~'f p....ctu.a\ 2002 p....cwa\ 2003 $ $ 1,000,600 1,111,4M $ \,\3\,200 1,112,049 (96,121) $ 1,04~,OOO 1,144,121 _605.06% _1.36% 2.94% VII ~ 'fER Budget 2005 Budget 2006 -percent Change Materials, Supplies and Services 540 Office Supplies 541 Uniforms/Clothing 542 General Supplies 543 Equipment & Vehicle Parts 544 Structural Supplies 549 Motor Fuels & Lubricants 560 Postage 563 Maint & Repair-EquipNehic1es 565 Maint & Repair- Structures 567 Maint & Repair-Other Improv. 580 Audit 1,092 1,208 520 7,457 49 3,127 3,961 2,819 71 11,202 5.577 404 3,472 5,077 3,786 4,649 4,144 1,607 406 314 2,652 4,196 3,998 2,882 11 9,990 5,640 13 1 1 ,038 104 319 168 3,620 5,555 4,638 3,500 9,450 1,550 700 160 11,075 21,100 5,640 11,000 1,000 6,300 4,500 24,600 500 2,200 1,400 820 21 , 1 00 5,640 2,700 1,400 900 11,500 1,000 6,800 4,500 24,600 500 74.19% 100.00% 462.50% 3.84% #DIV/O! 46.61% 28.57% 160.32% #DIV/O! 482.87% 1.53% 500 Regular Employees 501 Overtime-Regular Employees 503 Part-Time Employees 524 SL Converted/L TD 525 P.E.R.A. Contribution 526 F.I.C.A. Contribution 527 Cafeteria Benefit Plan 530 Other Benefits 531 Workers' Compensation Ins 535 Paid Leave Accrual TOTAL 2,667 (6,667) 173,411 4,317 1,544 171,229 2,953 (3,233) 187,935 2,812 2,194 155,570 3,240 2,098 254,953 3,030 2,162 261,497 7.75% -1.46% 68.09% EXPENSES Salaries and Employee Benefits $ 7,802 10,202 17,860 125,317 3,202 12,648 380 $ 336 7,285 9,810 16,354 126,446 5.137 $ 7,989 11,176 17,052 135,048 12,382 4,215 352 $ 110,186 7,135 2,200 386 6,417 8,880 15,360 $ 175,906 4,900 18,500 1,321 9,998 15,347 23,643 $ 181,046 4,900 17,100 1,362 11,157 15,640 25,100 64.31 % -31.32% 677.27% 252.85% 73.87% 76.13% 63.41% TOTAL 419 Hook-ups and Permits 370 Interest Earned $ 1,369,599 20,337 35,007 $ 1,350,813 17,913 26,559 $ 1,279,999 26,228 $ 1,294,200 24,500 $ 1 13,000 29,000 ,462,000 $ 1,437,500 70.00% 10.20% 11.07% REVENUES 400 Sewer Service Charge 418 Penalties 1,229,280 14,891 9,600 1,250,700 14,000 5.000 15,000 8,500 27,000 REVENUE AND EXPENSE DETAIL SUMMARY Projected Actual 2005 CODE $ 1,314,255 Actual 2002 $ 1,306,341 Actual 2003 $ Actual 2004 $ $ 1,420,000 Budget 2005 $ 1,387,000 10.90% Percent Change -4 DEPARTMENT SANITARY SEWER Budget 2006 FUND 707 405 NET INCOME (LOSS) NON-OPERATING EXPENSES 680 Depreciation 930 Transfers Out TOTAL NON-OPERATING EXP. $ $ (218,336) 146,070 166,108 312,178 $ $ (108,929) 93,628 93,628 $ $ (480,202) 396,057 50,000 446,057 $ $ (251 146,414 50,000 196,414 167) $ $ (307,052) 146,414 50,000 196,414 $ $ (333,227) 146,414 50,000 196,414 32.67% OPERATING INCOME (LOSS) $ 93,842 $ (15,302) $ (34,144) $ (54,753) $ (110,638) $ (136,813) 149.87% TOTAL OPERATING EXP. $ 1,275,757 $ 1,366,115 $ 1.314,143 $ 1,348,953 $ 1,572,638 $ 1,574,313 16.71 % 651 652 653 658 Property Insurance Insurance Deductible TOTAL Fleet Liability General Liability 1 102,346 401 14,468 595 1.194,886 16,649 711 1 126,209 411 13,406 827 1.193,383 EXPENSES, (cont.) Materials, Supplies and Services, (cont.) 581 Advertising, Publication, Printing 582 Expert & Professional Services 583 Other Contractual Services 584 Communications-Teleph/Alarms 587 Radio Contract 588 Legal 602 Heating Fuel - Gas 604 Electricity 618 MWCC Charges 622 Administrative Fee 623 Garage - Labor & Burden 630 Travel, Conferences, Schools 633 Dues and Memberships 636 Conferences 225 11,622 845,502 177,012 3.740 450 116 27 348 720 412 280 10,302 948,450 181,887 3.740 46 810 11,680 850,849 181,641 5.250 300 12,000 920,000 181,641 5,500 546 100 1,088 450 16,750 750 1,317,685 16,750 750 1,312,816 17,923 803 400 1,700 450 500 13,000 966,000 181,641 5,560 400 750 14,000 953,758 181,641 6,200 600 400 1,900 482 464 5,695 2,043 1,970 959 3,331 104 860 960 471 10,125 3,114 3,675 880 389 289 7,000 3,500 2,585 800 125 320 37,000 10,404 1,450 1,300 1,000 320 37,600 10,500 3,000 1,300 1,000 10.01% 2.73% 9.89% 300.00% 74.63% 7.00% 7.00% 7.00% #DIV/O 437.14% 200.00% 16.05% 62.50% 700.00% 150.00% 16.67% CODE REVENUE AND EXPENSE DETAIL SUMMARY Projected Actual 2005 Actual 2002 Actual 2003 Actual 2004 Budget 2005 Budget 2006 Percent Change ....... DEPARTMENT SANITARY SEWER FUND 707 Rate per 1000 gallons Last rate change waS in 2000 for a DECREASE of $.25 406 2.25 2.25 Cash Balance 12-31 Retained Earnings 12-31 935,594 2.25 2.25 2.25 Increase $0.25 Sewer Utility Net Incorne(Loss) 3,805,847 1,201,782 1,251,449 522,029 2.50 Sewer Utility Revenue Total Sewer Utility E1\.pense Total (218,336) 3,696,918 (108,929) 3,325,646 (480,202) 3,445,751 515,811 3,018,594 268,216 3,112,524 _48.62% 1,369,599 1,587,935 (251,167) 1,350,813 1,459,742 1,279,999 1,760,200 1,294,200 1,545,367 (307,052) (333,227) _9.67% Internal Loan to Storm Sewer 32.67% 1,462,000 1,769,052 SurnP purnP Inspection County Road #3 3rd St. No. - 11th tbrU 14th Ave. public Works Bldg. Design Residual E'luity Transfer to Storm Residential Utility Irnprovernents Lift Station ReconstrUction #7 TOTAL $ 350,000 100,408 ----.:-; 100,408 $ (350,000) 17,267 31,954 ~ 68,510 $ (350,000) $ 75,000 500,000 ~ 575,000 $ 75,000 500,000 ~ 575,000 $ 1,437,500 1,770,727 75,000 -----.: 75,000 11.07% 14.58% 00.00% ~60I -86.9 10 CONSTRUCTION _MEMO $ $ 19,290 CODE ::---:: MEMO-CAl'rrAL OUTL;\Y 740 Motor Vehicles 760 Cornputers 790 Other E'luiprnent TOTAL $ 500 - 500 $ $ $ $ $ 50,000 ~ 50,000 $ $ $ $ 50,000 ~ 50,000 DEI' A,RTNlENT SANITARY SEWER Actual 2002 $ Actual 2003 $ Actual 2004 $ $ $ $ 42,000 25,000 17,000 00.00% ~001 _16.0 10 .. REVENUE ,\NIl J'JO'J'l'lSJ' DJ'T,\IL suMJ'1A.R" Projected Actual 2005 Budget 2005 Budget 2006 percent _Chang~ FlH'lV 540 541 542 543 545 546 549 560 Postage 8,264 6,005 412 10,371 6,427 8,990 4,654 9,300 4,970 9,500 5,500 11 ,400 5,700 #DIV/O 20.00% 3.64% Medical Supplies Motor Fuels & Lubricants Office Supplies Uniforms/Clothing General Supplies Equipment & Vehicle Parts Container Parts 2,082 911 2,148 16,608 2,812 990 291 523 11,381 1,378 1,071 400 4,223 13,044 7,031 900 400 2,050 17,500 1.800 1,800 600 5,650 18,850 2,800 1,450 600 5,550 18,850 2,800 -1. 77% -19.44% Materials, Workers' Compensation Insurance Deferred Compensation Paid Leave Accrual TOTAL 500 Regular Employees 501 Overtime-Regular Employees 503 Part-Time Employees 524 SL Converted/L TD 525 P.E.R.A. Contribution 526 F.I.C.A. Contribution 527 Cafeteria Benefit Plan 530 Other Benefits 531 533 535 Supplies and Services 1,246 238,502 100 4,392 7 568 231,736 5,888 (2,681) 227,562 6,344 2,026 236,356 2,176 259,229 2,432 289,436 9,856 13,755 22,118 5,589 9,474 13,422 21,163 163,552 7,297 15.886 292 162,307 8,966 9,949 298 159,836 10,137 9,250 161,531 9,724 8,312 384 4,995 174,020 9,800 16,500 1,370 10,165 15,424 24,779 194,564 9,800 16,500 ,531 76% .65% 1.75% 20.63% 9.54% 17.38% #DIV/O! 27.47% #DIV/O 11 11 22, 349 9,399 13,203 181 9,496 14,140 24,399 6,367 12,262 16,895 29,085 EXPENSE Salaries and Employee Benefits 11 81% REVENUES 400 Charges for Services 356 County Grant 370 Interest Earned 409 Miscellaneous TOTAL $ 28,898 20,945 5,694 664,485 $ 23,394 13,378 5,209 552,702 $ 22,891 12,734 5,860 626,510 $ 23,000 12,000 5,700 717,250 $ 681,600 23,000 15,000 5,700 725,300 $ 695,100 23,000 12,500 5,700 736,300 1.52% -16.67% $ 608,948 $ 510,721 $ 585,025 $ 676,550 $ $ CODE . DEPARTMENT REFUSE REVENUE AND EXPENSE DETAIL SUMMARY Proj ected Actual 2005 Actual 2002 Actual 2003 Actual 2004 Budget 2005 Budget 2006 1.98% Percent Change FUND 717 DEY,\Rt~ REVtlS1\ CODE ---- ~ -:;;:.---- . E1CPENSE, (COnt.) ~eriJlIS> SUpplies and se"wees, (co.t.) 563 Wu-t. &. It<>Pair - B<\ui~eblCles 568 "print1:ng 580 Audit 58l M"ertisillg and fUbhcalion. 58~ ~ &. professional serv1Ces 583 Other Contractual services 584 C()1111l1onica1ions- te\epbl ~ 605 Disposal Charges 61\ E(\uipment Rental 622 Administrative fee 623 Garage. l.abor & Burden 630 Training 633. DueS and 1\11embershiPs 635 Travd{N1ileage 636 conference fees 631 1\11eals and l.odging 639 snbSCriPtions and yublications 6AA Ta1les & l.icenses 65 1 fleet l.iability 652 General l.iability 66~ RefU1l<ls and Reinlbnrsernents 'fO'f.M- to'fA\.> Oy~tU'lG 'EJO'E~S1\ OYERA-'fll'\G U'lCO~ (LOSS) pEf'f 48940 ~o~_OYERA-'fll'\G 680 Depreciation 930 'transfers out 'f01.M- 3,090 2,301 \,081 87,399 \ ,09 \ 126,986. 5,461 425 $ 92,592 22,460 81 $ ~ 396,546 8 91 'lOO 2,247 \2,036 85 63 635,048 29,437 3\,619 2,295 380 3,090 1'1\ 109,2A8 29 1\3,311 96,673 15,980 310 $ $ 389,601 216 'lOO 2,300 13 ,310 54 20 413 (68,6A1) 621,3A3 33,318 ----=:: 33,318 \02,7A7 2,865 131,377 3,400 2,141 522 205 350 620 500 96,788 21,080 423 $ 1,859 2,278 11 ,629 371 ~ 98,500 1,715 \19,200 3,200 500 32,122 $ 25,000 ~ 654,161 (28,250) 100 200 2,425 lA,530 50 \1\,781 23,000 1,124 ~ 127,500 $ 32,500 $ 25,000 ~ 65\,861 65,383 106,597 lOO 3,400 3,900 \0 111,787 28,500 \,130 300 $ $ 2,425 \A,530 600 100 500 300 458,K19 32,500 32,500 1,192 118,108 Actual 2002 j\ctua\ 2003 &,620 2,200 11,900 1\7,111 2,100 121,000 \1,900 250 3,390 3,900 200 \ 1 \,187 28,500 1,130 300 $ - ~ 10,43% 2000.00% _5.10% #D1\TJO\ 32,500 $ 25,000 ~ 600 700 500 150 200 2,595 15,541 758,252 (21,952) _50.00% #Dl\T/O\ 7.00% 1.00% #Dl\T/O\ 16.92% _405.23% 5.59% 2.\1% 1900.00% #Dl\T/O\ .0.29% ~".",_rt'" ,\lID E1U'E~SE p1\tML S~'\'. LV'" ~lW p prOjected j\ctua\ 2005 j\ctual ~ Budget 2005 Budget ~ fercent ~ Monthly Refuse rate Monthly Recycling rate $11-$14.45 $2.75 414 $11-$14.45 $2.75 $11-$14.45 $2.75 $11-$14.45 $2.75 $13.20-17.25 $2.75 $2.75 Cash Balance 12-31 607,953 564,704 321,322 384,120 319,514 333 168 4.27% Retained Earnings 12-31 1,016,291 981,023 895,650 903,533 870,342 824,081 -5.32% Refuse Utility Net Income(Loss) Refuse Utility Revenue Total Refuse Utility Expense Total (2,182) 664,485 666,667 (102,019) 552,702 654,721 (85,373) 626,510 711,883 7,883 717,250 709,367 (25,308) 725,300 750,608 (79,452) 736,300 815,752 213.94% 1.52% 8.68% REFUSE UTILITY SUMMARY DEPT 48950 CAPITAL OUTLAY - MEMO 760 Computers 790 Other Equipment TOTAL $ $ 8,070 8,070 $ $ 7,286 7,286 $ $ 215 132 $ $ 2,585 2,585 $ $ 9,000 9,000 $ $ 9,000 20,000 29,000 #DIV/O 122.22% 222.22% REFUSE FUND INCOME (LOSS) $ (2,182) $ (102,019) $ (85,373) $ 7,883 $ (25,308) $ (79,452) 213.94% TOTAL REFUSE UTILITY EXPENSE .. DEPARTMENT CODE REFUSE $ 666,667 REVENUE AND EXPENSE DETAIL SUMMARY Projected Actual 2005 Actual 2002 $ 654,721 Actual 2003 $ 711 Actual 2004 883 $ 709,367 $ 750,608 Budget 2005 $ 815,752 Budget 2006 8.68% Percent Change FUND 717 540 542 545 547 556 560 563 567 580 582 583 588 605 Expert & Professional Services Other Contractual Services Legal Services Disposal Charges 424 500 38 12 Postge Maint & Repair-EquipNehic1es Maint & Repair-Other Improv. Audit 1,555 3,200 550 ,218 ,877 520 1,000 1,000 20,000 550 20,000 Materials, Office Supplies General Supplies Parts and Supplies Street Maint. Material Sand/Gravel 1,045 357 88 294 185 4,926 852 1,075 476 330 ,710 500 500 2,915 200 600 1,000 2,000 4,000 2,000 2,000 1,000 2,000 4,000 2,000 2,000 2,800 1,000 20,000 550 20,000 #DIV/O #DlV /0 Supplies and Services 500 Regular Employees 501 Overtime-Regular Employees 503 Part-Time Employees 524 SL Converted/L TD 525 P.E.R.A. Contribution 526 F.LC.A. Contribution 527 Cafeteria Benefit Plan 531 Workers' Compensation Insurance 535 Paid Leave Accrual TOTAL 1,820 23,255 914 1,231 1,681 229 16,681 65 634 982 1,294 2,202 230 (1,129) 21,568 17,481 276 231 (126) 22,919 977 1,365 1,904 277 17,448 212 863 1,274 1,868 2,094 480 342 29,806 22,998 50 700 25,607 500 1,700 202 1,444 2,141 3,212 350 320 35,476 29,289 500 2,000 231 1,787 2,409 2,614 480 366 39,676 17.65% 14.36% 23.75% 12.52% -18.62% 37.14% 14.38% 11.84% EXPENSE Salaries and Employee Benefits $ $ $ $ $ $ 14.38% 409 370 417 Interest Earnings Miscellaneous TOTAL REVENUES $ 689,518 (19,334) 19,077 400 Storm Penalties 684,081 5,694 $ $ 623,761 5,209 23,843 37,553 690,367 $ $ 673,972 5,584 24,140 38,135 741,831 $ $ 660,900 5,400 22,000 688,300 $ 680,000 5,500 21,000 37,554 744,054 $ 697,500 4.76% -100.00% -6.26% 670,000 5,500 22,000 CODE "T DEPARTMENT REVENUES Sewer Charges STORM SEWER $ REVENUE AND EXPENSE DETAIL SUMMARY Projected Actual 2005 Actual 2002 Actual 2003 Actual 2004 $ Budget 2005 $ Budget 2006 -1.47% Percent Change FUND 740 MEMO--CAPITAL OUTLAY 760 Computers $ $ 425 $ $ $ $ 9,000 STORM Transfer Out TOTAL NON-OPERATING EXP. NON-OPERATING EXPENSES 680 Depreciation 582 Expert & Professional 588 Legal Services 665 Miscellaneous 820 Bond Interest 840 Fiscal Fee 930 SEWER NET INCOME $ $ 271,567 313.130 $ $ 281,085 312,315 $ 310,787 $ 253,397 $ 237,426 $ 214,446 -9.68% 140,939 440 112,511 667 $ 25,000 320,950 141,064 583 $ 25,000 319,430 133,870 560 $ 319,570 133,870 700 $ 25,000 308,870 123,170 700 -3.35% 165,422 30,533 3,119 64 #DIV /0 #DIV /0 #DIV/O - 7 .99% Services $ 171,751 $ $ 178,026 1,277 $ 185,000 $ 185,000 $ 185,000 OPERATING INCOME 584,697 593,400 631,737 572,827 556,996 523,316 -6.05% TOTAL OPERATING EXP. 652 General Liability 658 Insurance Deductible TOTAL $ 104,821 81,566 $ 96,967 $ 110,093 $ 115,473 $ 187,058 $ 174,184 -6.88% 73,845 1,564 75,399 67,517 1,850 87,174 400 77,232 1,441 85,667 77,232 400 1,800 151,582 1,800 134,508 7.00% #DIV/O! -11.26% 615 622 644 Taxes EXPENSE, (cont.) Materials, Supplies and Services, City Project Contracts Administrative Fees and licenses 20,000 77 ,232 1,926 77 ,232 -100.00% CODE . DEPARTMENT STORM SEWER (cont.) REVENUE AND EXPENSE DETAIL SUMMARY Projected Actual 2005 Actual 2002 Actual 2003 Actual 2004 Budget 2005 Budget 2006 Percent Change FUND 740 426 Cash Balance 12-31 Retained Earnings 12-31 Internal Loan. Bond proceeds Bond llrinci"pal llaytnents 383,149 1,MO,000 1,625,414 543,839 651,236 \,265,000 250,000 143,265 330,000 Sewer Utility Net Income(Loss) 325,000 561,682 3,491,358 296.25% 325,000 3,178,443 STO~ SEWER UTlLrfI' suMMARY Sewer Utility Revenue 'f otal Sewer Utility Expense 'fotal 211,56'7 281,085 4,089,230 310,'78'7 4,342,62'7 4,326,656 330,000 1.54% 689,518 4l'7,951 CODE ~'fR\lC'flON - l\'lEl\'lO Ex-celsior Blvd "Phase 11 Meadowbrooke Storm Sewer 'fhermotech Site - Storm Drainage Street Rehab/Maint. CSAH. '73/CSAH 5 "Nine Mile Creek hnllto\Tements }.\\e:y Uc<)11llU-\OO b\\<. \21\3 ave. S. Alley ReconstrUction South Park and Shady Oak pond 1'II""",e }.Ve.l2nd St.1lE and lli\\"'1' H.illtoP park Rnol1wood "pond lV1aintenan.ce 5th _ 8th 19th Ave. No. JustuS Lumber Central Park 1'IIisce\\aneoUS Sto"" Sewer \'!Oi""" DEl'1\.R'fl\'lErol'f 1'O'f AL 10,68'7 132,550 6,650 ~ (393,400) 26,952 29,2'76 189,654 '76,019 690,36'7 409,282 55,399 9,343 '7,938 ~ 161,262 96'7 '7,049 11,600 74\,831 431,044 ~~ 253,397 688,300 434,903 237,426 744,054 506,628 74,000 ~ 4,55'7,0'73 69'7,500 483,054 - 59,000 --fs9:OOO 214,446 5.33% _9.68% _6.26% _4.65% _20.27% _68.0'7% ~ DEI' A.R'fl\'lErol1' $ Actual 2002 $ Actual 2003 $ $ l'74,000 50,000 100,000 _42.53% _100.00% S'fORl\'l SEWER jJ.EVENIlE p.ND ElU'ENSE UET}.lL pro)ected Actual Actual 2004 2005 ~-- Budget Budget l'erceut ~~~ 200,000 #DlV /01 ANALYSIS OF NET INCOME WATER Total Operating Reveunes Total Operating Expenditures Operating Income (Loss) Non-Operating Expenses Depreciation, bond interest expense, transfers Net Income (Loss) Memo - Capital Outlay Memo - Construction Expenses SEWER Total Operating Reveunes Total Operating Expenditures Operating Income (Loss) Non-Operating Expenses Depreciation, transfers N t Income (Loss) Memo - Capital Outlay Memo - Construction Expenses 45,266 279,645 - 626,742 5,976 (10,565) 167,131 599,293 5,583 6,673 500 100,408 - 68,510 50,000 575,000 42,000 75,000 (321.105) 96,700 (218,336) (108,930) (480,201) (251.167) (333,227) 259,099 109,464 292,262 112.520 663.015 74,093 96.885 146,414 312,178 93,628 446,057 96,414 96,414 371,619 341,910 283,557 389,147 243,114 93,842 (15,302) (34,144) (54,753) (136,813) 1 1 ,249,930 1997 621,549 39,248 72,153 1 1 ,242,526 1998 ,584,436 376 - 143 1,206,811 1999 ,490,368 53,621 81,659 1,138,321 1 2000 527,468 10,143 188.508 1,225,776 2001 1,468,890 71.006 454,041 ,275,757 2002 1,369,599 5,127 202,584 1 1 ,366 2003 350,813 - 36,291 115 1 1 ,314 2004 ,279,999 143 ,348,953 Estimated 2005 ,294,200 50,000 322,271 1 ,574,313 Budget 2006 1,437,500 39,000 75,000 24,394 120,219 (2,204) (39,097) 207,484 (159,887) (23,895) (108,009) (259,316) ( 116,884) (96,728) 153,389 168,584 269,983 247,019 517,379 371 ,412 311,083 364,871 395,207 386,033 273,608 166,380 230,886 454,503 357,492 347,517 203,074 105,555 278,323 289,305 602,020 1997 875,628 678,782 1998 845, 62 670.177 1999 901,063 1 720,451 2000 174,954 695,922 2001 1 ,053,414 713 2002 1,060,698 181 764,316 2003 967,390 738,462 2004 844,017 722,277 Estimated 2005 1,000,600 758,695 Budget 2006 1,048,000 ANA\.. ''is\S Of NEl \NCOME S10RM SEWER l' ota\ operating Reveunes ,. otal operat\ng E)(penditures operating \ncome t\..oss) Non_Operating Re.enue (transfer In) Non_operating E)(penses Depreciation, transfers Net \nCOme t\..oss) Memo - capital outlaY Memo _ construction E)(penses Estimated Bud9 t 200'\ 2002 2003 2004 2005 2006 '\997 '\998 '\999 2000 689:5 ~ 8 '6'90:367 7'4t83~ ~o -i9-f.500 ~ 561:046 68f.323 7Ot757 723:825 469,938 ~23,082 '\ '\ 8,497 '\04,82'\ 96.967 ,\~0.093 ~'\5,475 '\14,'\84 88,1'\5 ~'\0,294 82,'\93 518,615 605,328 584,691 593,400 63'\ ,738 512,825 523,316 38'\ ,223 456,152 599,'\30 600,000 3~3'\30 3'\23'\5 320950 3~9430 308870 26506'\ 350256 286622 348282 363195 230,393 241,533 211,567 28'\,085 310,188 253,395 214,446 '\ '\ 6,'\ 62 106,496 9'\ 2,508 2~8 2,046 - - 9,000 - - ~o,6~2 ~ 59,000 ~48,266 ,\.~03,225 535,453 185,890 486.795 '\38,388 253,551 ANALYSIS OF NET INCOME REFUSE Total Operating Reveunes Total Operating Expenditures Operating Income (Loss) Non-Operating Expenses Depreciation, transfers Net Income (Loss) Memo - Capital Outlay BULK COLLECTION Total Operating Reveunes Total Operating Expenditures Operating Income (Loss) YARD WASTE/LEAF COLLECTION Total Operating Reveunes Total Operating Expenditures Operating Income (Loss) RECYCLE Total Operating Reveunes Total Operating Expenditures Operating Income (Loss) Estimated Budg t 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 - 555,513 646,606 628,867 634,771 634,764 664,485 552,702 626,511 717,250 736,300 538,901 579,320 571,782 593,444 642,533 635,047 621,344 654,760 651,867 758,502 16,612 67,286 57,085 41,327 (7,769) 29,438 (68,642) (28,249) 65,383 (22,202) 38,398 40,740 48,179 31,693 31 ,898 31,619 33,378 57,122 57,500 57,500 (21,786) 26,546 8,906 9,634 (39,667) (2,181) (102,020) (85,371 ) 7,883 (79,702) - 10,613 169,988 26,154 2,050 8,070 7,286 215,132 2,585 29,000 9,120 9,666 8,486 9,669 10,868 10,420 12,389 13,935 12,500 12,500 28,814 32,213 33,138 47,211 45,706 49,350 47,832 42,415 49,117 59,309 (19,694) (22,547) (24,652) (37,542) (34,838) (38,930) (35,443) (28,480) (36,617) (46,809) 4,150 4,051 4,133 2,307 2,415 7,160 7,357 8,024 10,200 20,000 33,323 48,708 54,562 65,508 80,419 88,186 77,377 82,601 57,453 90,810 (29,173) (44,657) (50,429) (63,201 ) (78,004) (81,026) (70,020) (74,577) (47,253) (70,810) 119,298 112,054 111,555 112,925 118,148 130,172 114,465 119,252 119,500 121,000 07,190 108,290 114,869 130,874 26,443 115,955 130,185 28,611 26,311 145,159 12,108 3,764 (3,314) (17,949) (8,295) 14,217 (15,720) (9,359) (6,811) (24,159) ANAL"S\S Of NET \NCOfoAE ~ i otal operating Reveunes iotal operating expenditures operati.ng \nCOme {LOSS) ~ iotal operating Reveunes iotal operating expenditures operating \nCOme {LOSS) Esti.mated Budget 1991 1998 1999 2000 2001 2002 2003 2004 ~ ~ ...;...--.; ~ "2:307 - ~ ~ ~ 4;\ 50 4,051 4.133 2.716 42.063 42,481 31.673 63.399 51,616 53,420 53,345 58,337 67,901 81,704 {31,9,\3) {38,430) {21,540) {6'\ ,092) {48,S40) {53,420) { 53,345) {58,331) {61,901) {8'\ ,704) 418,795 516,784 500,560 507,563 500.557 516.733 418,491 485.300 515.050 582.800 327.5'\ 1 347.628 337.540 286,452 338.349 328,136 312.605 342,796 351,085 381.520 9'\ ,284 169,'\56 163,020 221,1'\1 162,208 188,591 '\ 05,886 142,504 223,965 201 ,280 2000 Working Capital Beginning Year 492,016 Operating Revenues 1,065,766 Other 2,875 Interest 106,312 Transfer In 0 Bond Issuance 2,060,000 Total Sources 3,234,953 Operation Expense 679,075 Other Expense 41,450 Transfer Out Capital Outlay Capital Improvements 1,198,167 Principal Bond payment Capital Lease (PW Facility) Total Uses 1,918,692 Change in available funds 1,316,261 Inventory change (192) Working Capital Ending Year 1,808,085 Rate History 1984 $0.85 1993 $1.05 1997 $1.10 2000 $1.20 2005 $1.40 2010 $1.60 2015 $1.80 Notes - 2005 capital outlay - $220,000 Hennepin Co, $1625 Co Rd 73/5, Res Streets Income - 2005 base year - each year adds $45,000; 2010 rate increase in projections Balance 12/31/2010 $ 5,513 $75,000 ($297,000 rounded) 1,281,469 923,617 1,102,734 659,363 350,915 278,082 139,362 31,428 (74,767) 5,513 (240) (784) 1,952 (251 ) (526,376) 1,579,790 525,046 115,000 (357,068) 695,921 181,049 62,774 713,181 96,668 300,000 5,127 202,790 100,000 o ,417,766 177,165 1,090,225 o 136,832 105,000 o (443 24,394 289,006 110,000 45,000 1,287,137 120) (308,448) 50,000 297,000 115,000 45,000 1,309,048 (72,833) 10,000 75,000 120,000 45,000 1,064,356 (138,721) 44,700 105,000 125,000 45,000 146,481 (107,934) 1 45,000_ 129,357 10,000 105,000 130,000 (106,195) 31 00 75,000 140,000 45,000 143,064 80,28 22,200 75,000 45,000 45,000 151.809 764,315 84,078 733,729 85.008 720,316 81. 732 738,324 76,032 756,782 69,999 775,702 63,655 795,094 56,870 814,971 49,638 o 1,053,414 1,060,698 64,689 o 988,725 o 38,860 166,108 o 855,683 47 911,397 31,399 24,594 300,000 o 1,267,390 o 844,017 o 1,000,600 o 991,523 o 1,007,760 o 1,021,423 o ,036,869 o ,232,09'0 813,243 22,756 8,018 956,600 26,000 18,000 15,791 975,732 o 12,514 995,247 o 6,27 152 o ,414 035,455 o (3,365) 1,235,455 o 1,015 808,085 1,281,469 923,617 1.102,734 659,363 350,915 278,082 139,362 3 ,428 (74,767) 2001 2002 2003 2004 WATER FUND - WORKING CAPITAL PROJECTION 2005 2006 2007 2008 ~009 2010 Rate 2006 $2.50 rate 2008 $2.75 rate 2011 $3.00 rate DECREASE increase increase increase Notes - Bonds sold in 2008 with a 10 year payback at 3% average Payment = 50/50/75/75/1001100/125/125/150/150 nterest 1989 $1.75 1991 $2.00 1993 $2.50 1999 $2.25 Balance 12/31/2010 $ (663,972) Rate History 1983 $1.50 Working Capital Ending Year Inventory change Operation Expense Other Expense (interest on bonds) Transfer Out Capital Outlay Capital Improvements Principal Bond payment Capital Lease (PW Facility) Total Uses Change in available funds Transfer In Bond Issuance Total Sources Operating Revenues Other Interest Working Capital Beginning Year 2000 2001 2002 1,445,417 1,098,596 1,319,530 1,430,939 1,408,799 1,334,592 96,528 0 3,423 32,517 60,090 35,007 0 0 0 0 0 0 1,559,984 1,468,889 1,373,022 1,138,321 1,225,777 1,275,767 0 566,108 0 22,256 500 766,423 100,908 0 1,904,744 1,248,033 1,943,283 (344,760) 220,856 (570,261 ) (2,061) 78 319 1,098,596 1,319,530 749,588 1,064,939 (837) 654,635 1,337 464,882 107,662 (490,441) 174,498 (241.170) (663,972) 316,188 o 1,434,625 (411,641) 50,000 1,691,640 (189,753) 50,000 1,483,953 1 (357,220) 50,000 728,840 (598 50,000 1,953,648 103) 664,940 50,000 ,763,691 1 (415,668) o 68,510 o 327,497 10,000 75,000 50,000 75,000 o 51,500 275,000 10,000 95,000 36,400 75,000 50,000 50,000 874,221 (422,802) 10,000 75,000 50,000 50,000 862,649 ,632,821 30,000 ,649,149 28,500 1,366,115 26,559 400,000 o 1,750,813 1,314,143 26,228 o o 1,279,999 1,348,953 o 1,294,200 1,553,840 o 1,371,620 1,577,148 o 1,355,545 1,608,691 1,000,000 2,428,630 7,852 o o ,458,552 o ,439,847 1,324,254 o 1,253,771 o 1,250,700 19,000 24,500 20,920 1,350,700 o 4,845 1,350,700 o (22,070) 1,450,700 o ,450,700 o (10,853) 1,450,700 o 749,588 1,064,939 654,635 464,882 107,662 (490,441) 174,498 (241,1 70) 2003 2004 SEWER FUND - WORKING CAPITAL PROJECTION 2005 2006 2007 2008 2009 2010 2002 $2.75 recy 2005 $12.50, 14.60, 15.90, 2007 $3.25 recycling fee 2009 $13.85, 16.05,17.50, 2011 $3.75 recycling fee refuse Notes - Capital outlay for 2006/7 includes $10,000 each year for downtown garbage receptacles refuse Rate History 1989 $15.10 1991 $17.25 1995 $11.00-14.45 refuse $2.25 recycling fee cle fee Balance 12/31/2010 $ 443,766 Working Capital Ending Year 576,478 597,791 521,482 252,065 283,448 307,567 365,289 409,257 353,988 443,766 Inventory change 493 (55) (382) (2,010) Change in available funds Operation Expense Transfer Out Capital Outlay Capital Lease (PW Facility) Total Uses (15,820) 644,584 21,368 8,070 o 643,1 18 (75,927) 7,286 o 628,629 (267,407) 215,132 25,000 894,892 31,383 9,000 25,000 685,867 24,119 10,000 25,000 693,386 57,721 18,400 25,000 708,370 43,969 27,600 25,000 724,219 (55,269) 171,600 25,000 874,935 89,777 10,000 25,000 726,902 2,050 Total Operating Revenues Grants Interest Sources 642,534 570,272 29,105 29,387 628,764 635,048 614,643 28,898 20,945 664,486 621,343 515,930 23,394 13,378 552,702 654,760 12,734 627,485 591,860 22,891 651 682,250 23,000 12,000 717,250 867 658,386 682,250 22,500 12,755 717,505 664,970 730,250 22,000 13,841 766,091 671,619 768, 730,250 21,500 16,438 188 678,335 780,250 21,000 18,417 819,667 691,902 780,250 20,500 15,929 816,679 Working Capital Beginning Year 591,805 576,478 597,791 521,482 252,065 283,448 307,567 365,289 409,257 353,988 2001 2002 2003 2004 REFUSE FUND - WORKING CAPITAL PROJECTION 2005 2006 2007 2008 2009 2010 2006 $4.50 2009 $5.00 Notes - 2005 includes $200,000 to Hennepin Co, $105,000 for projects Rate increase is calcuated into 2006 and 2009 revenues Rate Histor er month 1989 $4.75 per quarter 1991 $6.00 per quarter 1992 $2.50 1993 $3.00 1998 $3.20 1999 $4.00 Balance 12/31/2010 $ 1,135,237 Working Capital Ending Year 1,608,070 (145,471 ) 1,062,480 935,339 718,736 754,537 289,953 1,198,544 1,017,485 1,135,237 Operation Expense Other Expense (interest on bonds) Other Expense (int on 2008 bonds) Transfer Out Capital Outlay Capital Improvements 1989 Principal Bond payment 1999 Principal Bond payment 2001 Principal Bond payment 2003 Principal Bond payment 2008 Principal Bond payment Lease Total Change in available funds 1,307,910 1,025,915 (1,753,541) 26,952 2,443,059 1,207,951 o 747,417 (127,141) 25,000 868,971 (216,603) 25,000 904,903 35.801 25,000 762,442 (464,584) 25,000 1,264,438 908,591 25,000 870,357 (181,058) Uses Capital 488,573 160,000 70,000 o 765,000 75,000 o 80,000 170,000 80,000 190,000 60,000 85,000 195,000 45.000 90,000 195,000 45,000 95,000 205,000 50,000 100,000 215,000 50,000 100,000 215,000 50,000 50,000 25,000 100,893 117,75 50,000 25,000 793,935 105,000 225,000 55,000 o o 329,205 o o o 253,557 o o 262,230 o o 305,000 o o 159,000 o 8,400 642,000 o o 252,000 o o 414,000 o o 100,000 118,498 188,844 105,523 141,379 130,682 113,178 110,094 141,647 115,473 134,430 117,782 130,660 120,138 118,900 122,541 105,816 124,992 91,901 30,000 128,116 77,319 28,500 Transfer In Bond Issuance Total Sources 1,610,000 2,333,825 689,518 1,265,000 1,955,368 741,830 688,300 798,243 799,854 1,000,000 1,778,948 919,834 911,687 (19,334) o o Operating Revenues Other Interest 47,333 o 676,492 o 690,075 18,777 37,553 23,844 o 43,137 24,140 660,900 5,400 22,000 760,900 5,000 32,343 760,900 5,000 33,954 o 760,900 5,000 13.048 860,900 5,000 53,934 860,900 5,000 45,787 628,971 674,553 Working Capital Beginning Year 300,160 1,608,070 (145,471) 1,062,480 935,339 718,736 754,537 289,953 198,544 1,017,485 2001 2002 2003 2004 STORM 2005 SEWER FUND - WORKING CAPITAL PROJECTION 2006 2007 2008 2009 2010 Rates were DECREASED in 1999 by $0.25 Sewer rates are scheduled to increase in 2006 to $2.50 Each February a sewer usage cap is set based on the winter period daily average usage. Each billing period the sewer charges are calculated using the lower of: 1) Actual usage x sewer rate or 2) Daily average in billing period x number of day in billing period x sewer rate 2005 through Sept SEWER 1997 1998 1999 2000 2001 2002 2003 2004 Adjusted Residential Gallons 481,331,764 492,093,478 525,016,400 478,707,479 512,908,882 461,197,377 418,089,834 413,755,353 310,646,697 Residential Revenues 969,290 992,619 1,015,512 937,101 998,659 1,032,433 942,930 930,646 698,947 2.01 2.02 1.93 1.96 1.95 2.24 2.26 2.25 2.25 Average Rate Per Gallon Rate 2.50 2.50 2.25 2.25 2.25 2.25 2.25 2.25 2.25 216,622,596 203,739,627 224,822,231 189,263,136 178,732,455 134,174,526 124,961,715 141,231,284 100,132,913 Adjusted Commercial Gallons Commercial Revenues 534,172 503,067 465,699 437,397 400,249 306,778 303,036 307,634 225,561 1,838 1,800 1,619 1,500 1,500 1,063 Flat Rate Sewer Total Commercial Revenues 534,172 503,067 465,699 439,235 402,049 308,397 304,536 309,134 226,624 2.. 9 2.26 Average Rate Per Gallon 2.47 2.47 2.07 2.32 2.25 2.30 2.44 2.25 2.25 2.25 2.25 2.25 2.25 Rate 2.50 2.50 2.25 Total Revenues 1,503,462 1,495,686 1,481,211 1,376,336 1,400,708 1,340,830 1,247,466 1,239,780 925,571 Adjusted Gallons 697,954,360 695,833,105 749,838,631 667,970,615 691,641,337 595,371,903 543,051,549 554,986,637 410,779,610 42,864,051 41,290,006 33,569,562 Sprinkling Gallons Total Gallons 697,954,360 695,833,105 749,838,631 710,834,666 732,931,343 628,941,465 543,051,549 554,986,637 410,779,610 Due to problems with new software and changes in the meters we had issues with meter reading calculations in the system resulting in adjustments to the recorded usage. Water rates were increased in 2005 2005 through Sept 1996 1997 1998 1999 2000 2001 2002 2003 2004 Residential Gallons 520,479,574 483,164,548 494,786,863 530,108,835 558,629,380 611,330,099 535,214,812 521,433,602 485,263,363 363,438,484 Commercial Gallons 255,494,126 233,957,844 208,635,854 212,844,930 209,644,458 176,063,592 136,056,954 137,157,068 146,953,827 107,641,448 Sprinkling Gallons 4,104,584 19,804,765 19,188,156 20,864,655 42,864,051 38,801,824 33,623,450 51,427,600 34,282,520 23,068,041 3,900,527 ,715,060 Total Gallons 780,078,284 736,927,157 726,511,400 765,533,480 811,137,889 826,195,515 704,895,216 710,018,270 666,499,710 494,147,973 - (10,853,559) (2,038,705) (925,000) Usage Adjustments 6,300,720 (13,355,423) (3,680,897) (11,589,499) (86,060,381 ) (87,595,105) Adjusted Usage 786,379,004 723,571,734 722,830,503 753,943,981 725,077 ,508 738,600,410 704,895,216 699,164,711 664,461,005 493,222,973 Rate 1.05 .10 1.10 1.10 1.20 1.20 1.20 1.20 1.20 1.40 Billed Revenues 834,537 809,519 801,914 957,942 972,826 991,088 845,874 852,020 799,108 691,667 - (1,332) (2,731 ) Billing Adjustments 6,460 (25,145) (5,725) (2,345) (103,799) (105,395) 840,997 784,374 796,189 955,597 869,027 885,693 845,874 850,688 796,377 691,667 WATER Gallons for Subtractive Service .05/1 Adjusted Revenues ANALYSIS OF RATES AND REVENUES .. Storm Sewer rat 2005 through Sept STORM SEWER 1997 1998 1999 2000 2001 2002 2003 2004 is scheduled for an increase in 2006 to $4.50 Rate 3~ 3~ 4~ 4~ 4~ 4~ 4.00 4.00 4.00 Billed Revenues 420,362 522,220 628,561 670,203 670,410 679,822 675,752 673,972 496,148 Average Monthly Revenues 35,030 43,518 52,380 55,850 55,868 56,652 56,313 56,164 55,128 Refuse rates were increased in 2005 Recycling rate is scheduled for an increase in 2007 1997 1998 1999 2000 2001 2002 2003 2004 2005 through Sept REFUSE Refus Rate 11.00; 13.25; 11.00; 13.25; 11.00; 13.25; 11.00; 13.25; 11.00; 13.25; 11.00; 13.25; 11.00; 13.25; 11.00; 13.25; 12.50; 14.60; 14.45 14.45 14.45 14.45 14.45 14.45 14.45 14.45 15.90 2.25 2.25 2.25 2.25 2.25 2.75 2.75 2.75 2.75 Recycle Rate 2,194 2,669 2,673 No. of Services 2,653 2,760 2,760 2,763 - 24 1,977 2,236 228 Additional Refuse Refuse 463,328 463,369 464,814 464,126 464,369 451,830 424,245 465,885 417,730 R cyclel Yard Waste 81,173 81,195 81,313 81,582 81,803 93,595 96,422 96,372 72,142 Bulk Pick-up 8,320 9,648 8,881 9,609 10,075 9,900 11,259 12,060 9,432 Carry Out 1,560 1 ,435 1,260 1,238 1,025 780 703 627 540 Brushl Yard Waste 5,647 8,107 4,942 2,265 2,540 2,545 4,414 4,624 5,375 Billed Revenue 560,028 563,754 561,210 558,820 559,836 558,650 539,020 581,804 505,447 (262) (478) (198) (83) (517) (244) (323) (178) (321 ) Billing Adiustments Adjusted Revenues 559,766 563,276 561,012 558,737 559,319 558,406 538,697 581,626 505,126 ANALYSIS OF RATES AND REVENUES ,. YARD W ASTE/BRUSH CURBSIDE PICK UP COMPARISON COMPANY ANNUAL CURBSIDE YARD WASTE CURBSIDE BRUSH FEE YARD RESTRICTIONS BRUSH RESTRICTIONS WASTE FEE FEE Waste $72.00 $3.00 per 40 pounds per $3.00 per 3' in length, 3" Management 65 gal cart bag - call in bag bundle - in diameter, tied & unlimited call in in bundles bag & brush approx. 2' in pick up Apr diameter thru Nov. BFI $69.00 $2.50 per 40 pounds per $2.50 per Same as Waste unlimited bag - call in bag bundle - Management pick up Apr, call in May, Oct, Nov: 10 bags/bundles per week June thru Sept Dick's $72.00 $4.00 per 40 pounds per $4.00 per 3' in length, 4" Apr. - Nov. bag - call in bag bundle - in diameter, tied 65 gal cart + Must use call in in bundles 10 compostable approx. 2' in bags/bundles bags diameter per week Hopkins N/A $1.00 per 40 pounds per $5-up to 15' in length bag bag 5cy, 6" in diameter $15-5 cy up to 18 cy $30-18 cy to one ton truck load