5.9 ERMUSR 10-11-2005 111
16
Elk River ------
II
--1
Municipal Utilities
13069 Orono Parkway phone: 763.441.2020
Elk River,MN 55330 Fax.763.441.8099
October 4, 2005
' To: Elk River Municipal Utilities Commission
Jerry Takle
John Dietz
' Jim Tralle
From: Bryan Adams
' Subject: Proposed 2006 Expense Budgets
Attached for your review, are the proposed 2005 electric and water expense budgets. The
important assumptions for each budget are as follows.
Water
Water Sales growth... 2.3%
WAC Fees-increase from... $421,200 to $475,000
' Unit WAC fee remains unchanged at... $1750/unit
Water Rate Increase... 8.3%
s` Step raised from... $1.30/unit to $1.35/unit
II
2nd Step raised from... $2.50/unit to $3.00/unit
Expense budget increase from last year... 24
' Electric
Electric Sales Increase... 7%
' Connect fees... $350,000
Connect unit fees... Same as last year
Rate Increase... $253,000 or 1.7%
' Expense budget increase w/o
purchase power costs 6.98%
Transfer to City in Cash & Services $703,983
or 5.12% of Elk River Sales Revenue
IELK RIVER MUNICIPAL UTILITIES
SUMMARY OF YEAR 2006
III BUDGETS
I
IELECTRIC BUDGET SUMMARY 2006
ELECTRIC REVENUE $ 17,179,742
IELECTRIC EXPENDITURES 16,150,123
IELECTRIC NET FOR CAPITAL 1,029,619
DEBT RETIREMENT 350,000
IGROSS 679,619
CAPITAL EQUIPMENT/CONSTRUCTION 5,260,000
I
BONDING 4,000,000
INET (580,381)
DEPRECIATION 1,520,000
0 NET TO RESERVES 939,619
WATER BUDGET SUMMARY 2006
IWATER REVENUE 1,610,754
WATER EXPENDITURES 2,067,663
IWATER NET FOR CAPITAL (456,909)
I WATER FEES GENERATED (FOR EXISTING& 475,000
FUTURE BOND PMTS)
DEBT RETIREMENT 410,000
IGROSS (391,909)
CAPITAL PROJECTS FROM CASH 482,000
I
NET (873,909)
1 DEPRECIATION 750,000
11) NET TO RESERVES (123,909)
BUDGET SUMMARYSheetI(6)
2005 SUMMARY BUDGET WITH 2004
COMPARISONS
ELECTRICIll 2004 2005 2006
BUDGET BUDGET BUDGET
UNIT SALES-KWH 170,127,535 180,087,092 191,031,000
REVENUE
OPERATING REVENUE
ELK RIVER 10,991,656 12,420,517 13,440,937.33 15,006,732 15,034,332
I ELK RIVER-CITY DONATED 72,000 108,102 116,983.23 27,600
OTSEGO 892,415 969,981 1,049,670 79
RURAL BIG LAKE 203,313 246,732 267,002 52 13,892,943
DAYTON 145,598 147,611 159,738.13
PUBLIC ST&HWY LIGHTING 161,090 174,678 180,000
ITOTAL OPERATING REVENUE 12,466,072 14,067,621 15,214,332
CIP 32,500 15,000
RATE INCREASE 639,000 201,000 253,000
I
13,137,572 14,283,621 15,467,332
OTHER OPERATING REVENUE
INTEREST/DIVIDEND INCOME 9,000 5,000 10,500
CUSTOMER PENALTIES 102,732 115,212 136,000
I CONNECTIONS 300,000 350,000 350,000
MISCELLANEOUS REVENUE 64,725 59,909 213,750
GENERATION CREDIT 341,880 343,992 277,160
LANDFILL GAS PROJECT 656,696 700,000 725,000
TOTAL OTHER REVENUE 1,475,033 1,574,113 1,712,410
I REVENUE TOTAL 14,612,605 15,857,734 17,179,742
EXPENSE
OPERATING&MTCE PURCHASED POWER 8,747,862 9,512,763 10,246,000
LFG FUEL 89,878 89,009 103,000
I OTHER OPERATING&MTCE 192,746 239,985 220,900
LFG 233,822 258,000 300,620
DISTRIBUTION 186,010 187,000 163,100
MAINTENANCE 587,142 607,726 708,430
111 DEPRECIATION 1,130,000 1,130,000 1,520,000
INTEREST 21,453 109,522 200,000
OTHER OPERATING&MTCE 32,132 32,132 153,120
SERVICES TO THE CITY 290,000 295,000 322,500
CUSTOMER ACCOUNTS 116,500 126,000 152,000
I ADMINISTRATIVE&GENERAL 1,342,754 1,443,413 1,653,462
TOTAL(BEFORE OPERATING TRANSFER 12,970,299 14,030,550 15,743,132
TOTAL REVENUES 14,612,605 15,857,734 17,179,742
I TOTAL EXPENSES 12,970,299 14,030,550 15,743,132
OPERATING TRANSFER TO CITY 329,750 371,857 407,000
NET INCOME PROFIT(LOSS) 1,312,556 1,455,327 1,029,610
I
I
I
I
I
IP
1 Electric2005BU DGETSUM MARY
11.11 11111.1111111 IIIIII MINI IIIII Mill MI IMADGAIM OM Mil NM 111111 dill IIIIII
ACCOUNT#I i3ESCRIPTION 2000 2001 I 2002 w2003 RY 2003 2004 2004 I 2005 6
ACTUAL I ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET ESTIMATED BUDGET
61-0440-4411 E.R RESIDENTIAL 2,863,234 3,157,284 3,572,011 4,028,374 3,900,647 ! 4,160,603 4,526,5471 4,942,279 _ 5,272,455
61-04404416 OTSEGO RESIDENTIAL 504,698 492,690 582,183 607,479 561,981 634,816 633,901 684,696 730,438
61-0440-4421 B.L.RESIDENTIAL 161,239 170,330 181,835 186,228 199,067 197,100 194,657- 239,741 255,757
61-0440-4431 DAYTON RESIDENTIAL 102,125 108,412 110,294 119,116 105,060 126,963 123,160 126,831 135,304
TOTAL RESIDENTIAL 3,631,296 3,928,716 4,446,323 4,941,197 4,766,755 5,119,482 5,478,265 5,993,547 6,393,954
61-0440-4417 ,OTSEGO NON DEMAND 82 484 91 075 71 008 105 337 _ 123 907 1,274,973 _ 141 065 fI 146 188
81,275,230 1,407,359 1, 33
110,084
1,211,657 1,433,165
61-0440-4415 E.R CITY DONATED 73,900 69,346 74,904 69,934 71,224 72,000 120,687 108,102
--- - - 1,257,602 61-0440-4422 .NON-DEMAND
B 61-0440-4412 L NON DEMAND 1 082 8150 1 054,366 1 115,018 5,322 4,290 4,408 5,332_ 5,217 148,869
I 124,920
5,313
61-0440-4432 DAYTON NON-DEMAND 14,535 12,197 14,975 15,606 14,332 14,573 17,915 t 16,600 16,904
TOTAL NON-DEMAND 1,261,924 1,235,686 1,285,453 1,407,856 1,471,355 1,490,874 1,560,229 1,683,466 1,714,335
4,1787 16,069 6
6,768,443
1 - 121,392 - 17,090 123,640 133,176 130,000
61-0440-4413 E.R.DEMAND 3,946,153 4,244,754 4,840,934 . 5,313,368 5,185,928 5,531,366 5,648,049 6,043,797
61-0440-4418 OTSEGO DEMAND 17,336 I 130,000
61-0440-4423 B L.DEMAND I -
61-0440-4433 DAYTON DEMAND - 82
0 71795
TOTAL DEMAND 3,963,489 4,254,466 4,857,085 1 5,434,760 5.203.018 I 5,655,006 5,781,943 6,173,797 6,898,443
61-0440-4414 E R SECURITY LTS 21,673 23,003 23,124 � 24,927 - 25,681 1 24,714 26,694 27,082 17,741
61-0440-4434 DAYTON SECURITY LTS 4,139
61-0440-4419 OTSEGO SECURITY LTS 8,511 8,433 8,850 8,972 5,757 9,039 805 9,097 5,959
61-0440-4424 B L.SECURITY LTS 1,797 1,753 1,545 1,78.1 1,476 , 1,8051; 1,732 1,774 1,162
4,063 4,035 4,148 4,038 4,062 3,590 4,180 2,738
TOTAL SECURITY LTS 36,120 37,252 37,554 39,827 36,952 39,620 32,821 42,133 27,600
61-0440-4441 'PUBLIC ST/HWY LIGHTING 143,439 146,558 156,863 167,212 158,988 161,090 170,801 174,678 180,000
TOTAL SALES 9,036,268 9,602,678 10,783,278 2,108,458 11,637,068 12,466,072 13,024,059 14,067,621 15,214,332
REVENUE INCREASE FOR CIP 4 32,500 15,000
RATE INCREASE 639,000' 201,000 253,000
-- - - - '-- - -- _.. -- -- I-- - --- - -- -1------ -- -- - -----4 -- -- -- --- 3
TOTAL SALES WITH CIP/RATE INCREASE 13,137,572 13,024,059 11,283,621 15,467,332
I I
61-0440-4511 SERVICE CHARGE 13,690 12,506 11,132
61-0440-4550 SUB-STATION CREDIT -- _ _ 6,000 7,465 - 6,000
4,000
61-0440-4551 GENERATION CREDIT 334,050 337,838 341,578 339,151 341,550 - 341,880 285,795 343,992 345,048
61-0440-4552 DISPERSED' GENERATION
16 537 (27,728)
(35,100) (58,116) (31,050) (57,760) (61,406) (71,176) (71,888)
61-0440-4553 PCA or RATE ADJ
61-0440-4553 FUEL COST ADJUSTMENT '
ES - , 7 , 0- - 6 - 1
INC
61-0460-4691 INTEREST INCOME 95,256 95,128 76,637 54,707 18,126 ' 9,000 25,704 _ 5,000 10,500
61-0470-4700 OTHER OPERATING REV 22,374 ` 46,888 36,609 38,728 42,085 42,085 38,720 _ 42,085 125,000
61-0470-4701 CUST DEL PENALTIES 71,916 92,686 ! 100,684 100,759 100,328 102,732 118,910 115212 ; 136,000
- -
61-0470-4702 CONNECTIONS 459,11 95 519,811 i 576,769 562,505 250,000 300,000 i 574,156 350,000 ' 350,000
61-0470-4703 MISC/TEMP CHG 4,534 940 950 5.00 2,000 2,000 1,200 2,000 _ 4,000
61-0470-4711 MERCH JOBBING/CONTRA 26,852
18,600 20,000 20,000 49,903 20,000 25,000_
61-0470-4715 NON-UTILITY OPERATIONS 1,7_8_0 4,321
61-0470-4704 STREET LIGHTS � 87,075 - 66,000
2,500 2,500 2,500 1,000
61-0470-4721 LFG 44,922 706,405 650,244 656,696 7.01,371 700,000 725,000
61-0470-4722 MISC NON-UTILITY 8,967 8,952 55,778 64,382 7,500 49,400 35,228 58,000 58,000
61-0470-4724 GAIN
ON DISP OF PROP
SALES (204) -
1,690 6,646 (116) 500 500 (756) 500 750
TOTAL OTHER 995,021 1,180,107 1,298,323 1,838,635 1,403,783 1,475,033 1,776,290 1,574,113 1,712,410
TOTAL REVENUE 10,031,289 10,782,785 12,081,601 I 13,829,488 13,040,851 14,612,605 14,800,3491 15,857,734 17,179,742
- -- I } -
1
BUDGET COMPARISON 1 200610/07/05
OM 11111161111111 11111 MIN MIMI MINIMIMI IMA DG� IMO NMI IIMI Mil ION MIMI 4111111 MINI
W ITI4
ACCOUNT# • DESCRIPTION 2000 2001 2002 2003 2003 2004 2004 2005 _ 2006
ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET BUDGET
OPERATING/MTCE 1
61-0540-5461 OPERATING SUPERVISION 33,466 35,280 28,898 35,618 _ 30,617 38,640 40,191 42,680 71,650
61-0540-5462 INT COMBUST SALARIES 237 5,627 L
_ 6,102 6,285 6,285
61-0540-5471 DIESEL OIL FUEL 6,464 8,376 15,000 15,000 778
- 15,000 25,000
61-0540-5472 NATURAL GAS 1,599 ;_ 3,029 2,825 4,495 3,800 3,800 5,842 3,800 11,700
61-0540-5481 ILUBE OIL 142 1,300 1 1,300 1,300 1,30.0_
61-0540-5482 CHEMICALS
61-0540-5483 STATION PWR/WTR PLANT 19,502 21,689 19,778 29,740 24,600 30,021 29,056 . 30,020 32,000
61-0540-5484 PLANT SUPPLIES 7,601 8,136 8,538 28,385 9,000 I 20,000 29,375 25,000 26,750
61-0540-5491 MISC OTHER GEN EXP 13,688 10,373 8,611 12,235 10,800_ 10,800 11,715 1 10,800 5,000
61-0540-5521 MTCE STRUCTURE PLANT 31,804 26,255 17,994 36,028 15,750 I 17,900 19,940 I 17,900 _ _ 18,500
61-0540-5531 MTCE ENGINES/GEN 35,386 39,2.36 54,280 33,429 45,00 45,000 17,759 45,000. I 25,000
61-054.0-5541 MTCE PLANT/LAND IMP 767 86 1,477 21,487` 1,500 4,000 3,824 1 4,000 4,000
PURCHASED POWER
'PURCHASED
CREDIT
61-0540-5551 POWER PURCHASED 5,497,606 6,035,913 6,849,629 7,664,354111 7,464,86.5 8,747,862 8,563,298 9,512,763 10,246,000
61-0540-5552 OTHER PURCHASED POWER 122,567 89,878 141,783 I 89,009 103,000
61-0540-5561 PLANT STANDBY i
61-0550-5051 LANDFILL GAS EXP 33,844 ! 232,308 233,822 219,178 258,000 265,000
61-0550-5052 LFG ADMIN _ 611 5,365 6,100 4,620
61-0550-5053 LFG INSURANCE 16,820 1 17,100 16,000
1- -
61-0540-5054 1LFG MTCE I 15,000 15,000
TOTAL 5,648,262 I 6,188,372 6,997,657 8,221,256 7,628,334 9,264,308' 9,104,924 1 10084,757 10870520
I
DISTRIBUTION
61-0580-5801 REMOVE EXISTING SERV _ 755 143 197 542 600 i 600 1,350 600 2,000
61-0580-5831 TRANSFORMER OH/URD 5,775 9,625 9,332 6,282 8,000 _ 8,000 9,449 8,000 12,000
61-0580-5851 MTCE SIGNAL SYSTEMS , 1,014 1,026 478 483 2,010 _ 2,010 1,903 3,000 3,000
61-0580-5861 METER EXPENSE 10,797 8,399 10,430 23,399 10,900 } 40,0001_ 10,330 , 40,000 11,600
61-0580-5871 ,TEMP SERVICES 3,525 1,893 1,073 671 5,400 5,400 2,734 5,400 f 4,500
61-0580-5881 MISC DIST 86,617 114,461 130,248 135,433 117,841 130,000 124,700 130,000 130,000
TOTAL 108,48300 135,547 151,758 166,810 144,751 186,010 150,465 187,000 163,100
MAINTENANCE
61-0590-5911 MTCE STRUCTURES 684 225 1,729 96,238 1,600 1,600 2411,600 1,000
61-0590-5921 MTCE SUB-STATIONS 22,339 16,958 16,110 27,150 18,900 2.6,000 25,534 i_ 26,000 1 26,000
61-0590-5922 MTCE SUB-STATION EQUIP 245 1,781 320 6,714 3,400 3,400 894 3,400 I 3,400
61-0590-5931 1MTCE OHfTREE TRIM 132,927 1, 161,440 167,176 87,719 85,000 89,000 174,708 100,000 , 1.75,000
61-0590-5932 MTCE OF OH/STANDBY 1 18,546 15,000 21,000 25,593 26,074 I 26,750
61-0590-5933 MTCE OF OVERHEAD 58,837 70,000 71,000 33,595 56,000 57,680
- --
61-0590-5941 MTCE URD 6.1,264 61,968 59,278+ 62,691 64,500 64,500 104,19364,500 9.0,000_
61-0590-5951 MTCE LINE TRANSFORMER _ 5,788 4,980 8,572 13,637 5,890 16,000 _ 7,499 16,000 15,000
61-0590-5961 MTCE ST LIGHTING 13,900 ' 19,184 28,561 3.3,053 20,000 _ _ 20,000 _ 37,805 3.2,300 30,000
61-0590-5962 MTCE SECURITY LTG 5,144 1,812 3,993 I 3,232 5,695 5,695 6,427 5,695 3,500
61-0590-5971 'MTCE METERS 1 13,636 20,728 29,709 t 4.6,751 34,176 38,500 48,469 42,500 50,000
61-0590-5972 VOLTAGE COMPLAINTS 5,648 2,568 3,572 2,297 4,990 I 4,990 6,180 4,990 5,000
61-0590-5981 SALARIES T&D 17,501 18,451 18,703 19,363 j 19,500 20,780 21,982 22,990 38,000
61-0590-5991 MTCE OH/2NDRY 9,217 14,703 16,626 ' 12,756 18,500 18,500 13,147 18,500 _ 15,000
61-0590-5992 MTCE URD ELECT SERV 40,796 49,615 ; 51,255 42,884 42,100 i 42,100 38,351 ' 42,100 42,100
61-0590-5995 TRANSPORTATION EXP I 103,717 99,138 I 109,676 130,373 145,077 j 145,077 119,803 145,077 130,000
TOTAL 432,806 473,551 515,280 662,2424 554,328 588,142 664,421 f 607,726, 708,430
- J
-- - --- --- -- - --- - -- -- -- --- -- - - --- --
-
--
BUDGET COMPARISON 2 200610/07/05
O O X010 0 00101
OIO IOIO O O O,N
a 010 0 0 o 0000010011.0� 0�I01 U)I010 0 0 OI Io I010l0'0j0 0 N 'N I
010 0 0 o 0,0 U) 010 0 (A N O'M,Nt0 0 0 0 0 :0 0 0 0 0 0 N Q ,M
ILLI 0h0 1.. O LIC ' N 1 i 0j01 O O N ()JO •- O O CD 1--.. NN
'11U)I1"0'10 O O 0U), I�IU)10 017 O p.
N j''
1 CD 010; ,-4-1,-,i_ 1 N N- Ubi 1 '0 ' OI(DI N 7 I NIU) O U)'U)IC) 00 (D N- C),'-1 U)'0 O N'O N1r- N (plc-51.-14 1,� O
Q I(IN, M 7 N (DINT 7 N M OIC a-'N NICD M a LI) N (D '- .- '7 1� - u) am
I I^
IM ice' � i �' tiiss
o
lls (o,m 1 3
j
0 1 W I I
1 1 I 1'
N I '
W I I
OIN 0 0 O h OIN 1 X010 O,'o' o O O O m 0,0 O O O�O OHO O,OO 10 0 0 0 O O N ', N
10 UU) � O 'O 00010 M 10 0 O O e l O O O CO O O'a0 UO,�IO O O'O OU) O MIO O O V CV C)1 I-W oof �,0 Li) N- 06
105'7 17'0 N 1oiolUiuiU)( 0) vi(D,00'Uio'(D (NO M cri o r
M10 .-- NIM Uq'N 1N N'. 'CVale- O) 00 �IV M '- MI e- N N '(D !elm'
1 h_
N103 1 I 11 I 1I ,
I
•
IU) In --H a0,7'N0 'O M 1 (D�� t0 NI M 00'N N 0) (D1e-II(N 0) N'1s U)II�rC)1U) OIM 1(O'N 'O)
— IQ)17 IM UA O) O O1 7 0 OMI,„ 0 0 0,00 x'00 N- M O M,`-'IR O N O (D CP'0 h .,0 rn r
J
00 M O O'IU) 00 05 7 N M T-1 - 7 N a N'�t--,M N,010 .,N M M UD N ,-- ,t010) 0 .-100c60
v• 4 N- N- 1646r--- ro N ''7 C') 'M,M UD LI),to)II.--IN- U) M C)IC) N N 7IN OICDIN M 0D o ao
I
N ap' M M 7 UD N N 41:0 M O UD 0 7 O) 0 N N 1� 0)
O F
•7..,
!NM
N N: ,... .r- I ^ t0
N U �I 1 I�
I
Q
1 I 1 I
f- O M ,o:
,0 000 (N M 0:0 0 0 1 0 0 .4- 0 . 00001,,0010 0 10 o j 0 0 010 0 10�0 o I- 0)
I
W O U) o O' O U) O M 010 0 0 ' O N- O O O 0 00 O tD O O O 000'0000000 (N 7
O V 00 1 'O h 0 O,U) 400' -
, . I(D �,1p O'O Q) O'er D) D) O O U) O O M O O O V (9'2 O
�T O O 1 O O 0) 1� a0 N '.1-,N, 0) U) N 4) Q) U) a0 U) a0 O) (D N O 7 M a0 1,7 a0 N- 7 `+
O MIN .- N ( U) N N,� .N 7 i0 0) N- M N 7 �!M COI,-;NIN CO ^ M
N
I- I , ,
- - - - - - i l r --_I -_ 1 - 1 •�
W 0,�, O O O N N O OlO r� M O o O O O (D O O O'O Oj 0*o (D (_D OIOIO O O LA �4N
;0,- 0,70M 0o MO 0'0 v) 0 0 0 0 O,O 00,OIr 0 0 0, M1010 O 10 010 0 0 N r..IP
`- 10'0; N " 011'- of N- CO 0 ,a 1 0 UD 0 010 NI;CM 011�'O1I0) 01 7 U) 7 4) 01 010,0 7 N O m ih
W 0 7, 1 O N N- N I- (D N'a, ' U) U) M 7 051-- co 1 N co 700 7 c, N (D Q) N N 17 00 I- Ni 1^ 0
NI r u) WO; `D 01-' ,- U) M 0 W N- I�I M N ,- ,- ,-- MINN j (D ;NIA
it G O 0 iN'IM .- N r I VI ^ gin
NIm •
> ' ll • 1 I I
0 m-. —.I 1 1 - -I )
17 0 0 1 I j M 7 M 7 'O0) W Q7,U)'00NICOMQ) O (DO0) NONLi) N- 0 7O U) N M r a U)10 : :: ,
O U) 7IN r N,O r aO.�,O O O W O 41 W 7 aO O r n n 7 vWO (DU)', N 01Oro OI M O M M (D � �.M r .-.,WO U) O � O OIQ) (O N U) OI(A ^ (()I
(,.) QI� n7 U) 1� 7 t\ 177 Q) Q) (D 7 7 0 7 17 N (DIM ao tD M I:N 7 W 1-1! rhQ F_- O 00 7 N M 1 U) N 'N 7 1.-.,- N- NICD U) U) .- '- M (")I.- .- .- N O - N
2 0
g N V ISI I I I 1� I I I r
3 Q 1
— 4 1
7_,O CO N17 0'MI N q'; _M'0) N U) N- 7 MNA- U) N 0 (n 0070) UA,7 (D,011U) 0 7 IP 0)
7 0 1s- UDM T- 10 1 p 7 "- Ow( 00'0) 01410,00) M-,,-,00 '7 M'(D U)1 U) .-1 U)'W (D 1 v 7
J 0)'0 0) MNN . 0)' ',o U)1M Oa0 0i n00) 7M'UD NMMUD10) 0 '(Dr- WO000N ,-10) U) 0)
N,Q Q),M aO IW 41 7 'o N 00 .UD U) 0 I 00 UD M 7'7Ir- 000 0)1UD UD co NIU) 0SO MID) 0) 7'M,C) N N
IIIM'- 00 a0 r ^ U) N M (f) O m r 004 M (D I N i.- .- ,N [D 7
•
0 N N
N Q ! � �I 1 IO
f�!�4) co,_ co O N- U) 71 1N N 014) 10) 0) 0 1 co co OIN co'CD N,00 U) 71(D UD M�00 O'N'N- U2') 'N'O M �O
' OI O 1U) UD Q7 N IM ,p
NN 'N q) co 4) .- co 0)'O 1 UD I0) U),7'00 O O N O,W O N N N n v W
1 '�„� 7101;0 10 N 7 M l- IN ni N UD U) a U' MIN00 CO 0't`�� O Is-'04100
I� W 7,N- U) 711 U)�O N r
I Q N 7 co t� N Un U) Q n 7 M O 7 M:M 7 UD a0 M D) (D 1 Q) O O) Q7 00 0 n'1'-' 0 (D
1 0 DO) N N 7 N '- I N M O 1� U) U) N N 1 .-1,N U) .- UN)
Q I II
— 1 — i t -- I
7,_O ID) 017 CO 'M .IM UD (O � 0 UD M 00 N 0 001N CINI 'r` O1 I- M ,UD M 7 O v M
N 1.- Un'.- 7 7 M 1,41) UD 00 7'0 0 0)1.- U) M;N UD M N M 0 0 U) N C UD N 7 N
J X10 HT O 0) 7,01 CO: to 4) W 0 .-1c6 O'OD M U)'7'N'O.� N O 00 N- IUD O CO �,N N 7.c�
O',4 !0 IUA 1U) 0 O UD co IN 00 7 i0 7 0 U0 N,7 7 0'00 MIN 0 00100 O OO .- 00 O co N!N It 1I
I
IG = 1,:,; r N;M I� M NIM' .- to UD ao M N M N U),
01,...
NN 1� wNI r N
00
N Q Z
I a 11 IW I •
1 1
IO � (� �, x
W I2.m a Ip1 101w JI
m'� ° - - I- a, d ¢ d W
z Z iwl0 m 0'Q w I- p1(w Z 1 w1 Co >- a�0 1 0 '00 w
O r w (nz , 1w w U ¢ �; ~ cri
z N
M 1061:1- 1:i7 = 0,- 00 W Z QIO Z z W10 Z p (n -1J U w IZ
I
is X z1Z
Ow',U p U z d'r- U z X w12 � E w �I x' u- u.1w J ¢ lit' z
�, W O OIL11'- CCO ¢ OX W F- U W �p d UL (� � ¢ 0 (3'r:21203 U'(j w1 -1 IX
-'JIB m w O z w '
< 60 m 0_ 0 (n x wwlz' :n
U � �1m x m � F F O ¢ zLI--- u-1 W Q p w w (n w U ZI z _ cn w, w
C/) W Qpa w'O4Iz,z:_z c, wt= > (n wO a (+ - a1z °� w
IW X Z Z LL Ip1 V - Q' (n ll (n ¢ U Z_ _ _ } O J,� Z J (/1 -ID JIJ WI Q 1 1
011- W x0 w wxLL z,
HUz0w10OOF (n11- ccpQ Q U ui OW Hl- wt- U zl� ¢ - J O ¢ x w ICS Q
❑ O d F1m a Njm w z x O x a a WIO cnl� o ¢'� ¢ w 17:117: P: U1Q O zi0
S902 .0 (-)lw ,o O
In wIz O X O () J1-- 0 0 ZI (A i- w 0 J m,J ¢ � =I> > m > 2 U,w UIJ I- ¢ p 0) 2 2 L
1 N M NIM '- D) (� O Z N M N M 7 ,-CO Q) N N M 7 U) UD
M 1 n 1 UD N- M UD (D UD 00 7 0) N,M 7 U) O O N CO 7 1(.0 UD (D CO (D UD CO 00 0) O) 0,0 10 0 0 0 N
Z O'O � N N N N N N M M M 00000 z1N N N N N N N N N'N N N1 N I N N N N,M'M 1 M M M,M M I
O a0' O CD ao aV W aD a0 M W 00 m Q) O 10 a1 011 O 0) D) 0) 0) o D) m 10) 4) D7 0)1 m 0) D) D)'D7,0 O O 0)'0) m
I
0 � ^ ^ r"t` N-'N- ^ ^ t\ 010 0 0110 010101,010 0 0 0 0 O'O olo,o O 0 OIO1010 0 010 0
IO Q1 O) Q) 010 010)141 0)10 D1 m'a1
00000
Q N NIN N CV N (Ni N 1 N NIN N N NiN N N N'N N N N N
U U) U) N U) O c() U) U) u) U) CO Un U) O Q) Q) m 0 4) 0),0)10) 0) D) D) 0),0) 0) a) 0) 0) 01 01 D) O,D) 4) 0) 4) 0) D) 0
V o 01010'0 0 0'0110 0 0 oio
99999
919919,9999'999999999'9999,9919
Q1 tD'(D,OIO O tD tD�(D O;(D,O'O O, ! (D.(D tD!O O ,UDlc°;CO (DI(D6 (D UD MUD CO UD¢ (D,UD CD IUD CO'UD DI(.01(0 (0,O , ,
_ IMI•— MI ME In I= Ell IMAIDGE1.11 lilli Mill Mill Mill MN ilM all 111111
ELECTRIC 2000 2001 2002 W2003 RV 2003 2004 2004 20051
ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST BUDGET ACTUAL BUDGET � CQ6
ESTIMATED BUDGET
TOTAL REVENUES 10,031,289 10,782,785 _ 12,081,601 13,829,489 13,040,851 14,612,605 14,800,349 15,857,734 17,179,742
,6
14,387,407 ' 16,150,132
TOTAL EXPENSES 8,544,923 . 9,289,359 10,479,654 12,247,514 I _--_-- _-
1_ � 13,698,079
PROFIT(LOSS) 1,486,366 . 1,493,426 1,601,947 � 1,581,975 1,281,079 1,311,556
1,102,269 1,470,327 1,029,610
-
1 11
- - -
} I
f- -- -
BUDGET COMPARISON 4 200610/07/05
I
2005 SUMMARY BUDGET WITH 2004
ICOMPARISONS
WATER 2004 2005 2006
BUDGET BUDGET BUDGET
I
UNIT SALES -GALLONS 634,994,000 726,000,000 684,241,000
REVENUE
I OPERATING REVENUE
WATER SALES 1,137,369 1,443,534 1,538,804
WAC FEES 360,000 421,200 475,000
METER/CONNECTIONS 42,500 50,000 50,000
I
TOTAL OPERATING REVENUE 1,539,869 1,914,734 2,063,804
OTHER Of DAYTON
INTEREST/DIVIDENT/MISC INCOME 15,000 15,000 12,600
I CUSTOMER PENALTIES 7,600 7,800 9,350
TOTAL OPERATING REVENUE 22,600 22,800 21,950
REVENUE TOTAL 1,562,469 1,937,534 2,085,754
I EXPENSE
PUMPING 212,394 258,818 367,950
DISTRIBUTION 127,174 142,400 177,850
I DEPRECIATION 310,000 600,000 750,000
INTEREST 243,804 306,917 245,000
OTHER OPERATING & MTCE 18,163 20,092 16,762
CUSTOMER ACCOUNTS 32,867 40,744 45,675
I ADMINISTRATIVE/GENERAL 194,563 280,134 435,426
TOTAL EXPENSE 1,138,965 1,649,105 2,038,663
NoTOTAL REVENUES 1,562,469 1,937,534 2,085,754
TOTAL EXPENSES 1,138,965 1,649,105 2,038,663
OPERATING TRANSFER(99 BOND) 33,897 30,868 29,000
I
NET INCOME PROFIT(LOSS) 389,607 257,561 18,091
I
I
I
I
I
I
IP
1 Water2005BUDGETSUMMARY
mu ow ini No
lin owNom gm ism um um uguLAT2OLGE,m onsumEN
ACCOUNT# ESCRIPTION 2000 2001 I 2002 W2003 RV
2003 2004 2004 i 2005 , el
ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET I ACTUAL I BUDGET , ESTIMATED BUDGET
O 114,955 3 079 , 3 000 0 0
62-0460-4691 (INTEREST INCOME 79,975 55,149 22,079 12,000 12,0000 I 31,024 12,000 12,600
.
62-0460-4692 OTHER INT/MISC _ 4000' 3,000 -
62-0610-6101 WATER SALES 75.5,462 550,035 834,562 1,047,561 I 1,020,000 1,137,369 1,167,955 1,443,534 1,538,80.4
62-0610-6171 UNMETERED SALES I 70 ---1--
62-0620-6300 ,SERV DONATED BY CITY
62-0620-6301 CUSTOMER PENALTIES~ 6,702 5,055 8,303 6,3417 7,200 7,600 7,897 7,800 _ _ 9,350
62-0620-6401 WAC FEES 501,519 477,083 3.97,425 666,231 300,000 360,000 839,911 421,200 _ 475,000
62-0620-6402 MISC CONNECTION FEES 23,176 i 26,076 41,870 84,203 32.960 42,500 92,832 50,000 50,000
TOTAL REVENUES 1,366,880 1,113,468 1,433,930 1,829,421 1,372,160 1,562,469 3,639,571 I 1,937,534
62-0620-6403 MISC REVENUES 46 36,815
--_-
62-0620-6405 CONTRIBUTIONS DEVELOPERS 1 1,495,953
2,085,754
-
F
H
- :_- {
Y--- - - -- --- -- - _ _
- _
_
1 - I j -
BUDGET COMPARISON 5 200610/07/05
mu ID NE ENI um ism tim me AT GEjimi on sim Inui mu am _e ...
WITM RY
AMOUNT# - DESCRIPTION 2000 2001 [ 2002 2003 2003 2004 _ 2004 2003 I 2006
ACTUAL ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET ESTIMATED BUDGET
--- I -- I - i -- 20,000 - ------ - - -
28,361 t 30,468 33,897 30,868 29,000
-- (99 BOND) - - -- - --- --- - -- -
62-0597-8260 OPERATING TRANSFER 23,893 L T- I i- --
MAINTENANCE
62-0700-7021 +MTCE OF STRUCTURES 373 907 19,244 5,950 10,000 29,342 10,000 10,300
25,950 40,468 63,239 40,868 39,300
PUMPING t
62-0710-7101 SUPERVISION 19,199l 13,723 21,581 21,410 21,732 21,990 22,662 24,418 50,000
62-0710-7181 SUPPLIES/EXPENSE 128,512 137,540 191,310 183,951 152,504 152,504 174,079 185,500 191,000
62-0710-7201 MTCE PLUMPING EQUIP 442 4,109 3,230 1,274 4,500 4,500 4,149 4,500 6,950
f
62-0710-7220 MTCE OF WELLS 43,819 19,546
42,752 204,893 33,400 33,400 81,337 44,400 120,000
TOTAL -- - 191,972 174,918 -- 258,873 411,527 212,136! 212,394 282,227 258,818- - - 367,950
-- T - -- 5 9,351
62.0730-7301 MTCE WATER MAINS 14,2551 8,453 ' 31,9371 12,700 _ 13,400 L 26,135
DISTRIBUTION _
- 510,000 22,000
62
0730-7311 MTCE WATER
f - - }62-0730-7321 MTCE CUSTOMER SERVICE 23,024 13,588 48,006 13,638 20,250 20,250 � 36,009 28,500 --- 40,000
I 40,000
62-0730-7331 MTCE WATER HYDRANTS 3,787 5,992 5,257 4,117 8,050 8,050 9,382 8,050 7,500
62-0730-7341 MTCE WATER EXPENSE 3,256 389 1,550 1,550 156 ; 1,550 __ 1,550
62-0730-7391 WAGES I 8,021 5,489 9,459 8,564 12,701 , 12,814 9,065 1.2,800 19,600
5 ] T
3,547 476 [ 6,000 6,000 5,746
TOTAL 103,639 75,289 98,319 123,251 , 112,271 r 127,174 148,217 16,50042,4 41,200
62-0730-7395 TRANSPORTATION 7,720 7,346 18,512 24,791 14,020 15,110 20,938
62-0730-7399 GENERAL EXP/PERMITS 5,077 3,194 6,000 6,000
-- --- -- - --- ------ - I -- - - - -- --- 142,400 --- -- 177,850
62-0745-7451 DEPRECIATION 185,2.661 194,614 292,559 585,354 I 260,000 310,000 720,044 600,0.0.0 750,000
62-0750-7568 AMORTIZATION 03 1708
62-0748-7481 INT ON BONDS/LONG TERM 131,158 � 42,971 ', 263,391 268,835 _360,335 213,336 256,207 276,049 245,000
- _
_ 34671 0
62-0750-7563AMORTIZATION ORTIZATION 93 1,298 86.5 1,298 1,298 1,298 1,298 5,653 1 -
62-00750-7564 ;AMORTIZATION 94 1,793 1,195 1,593 1,593 1 1,764 1,764 12,225 I -
62-0750-7565 IAMORTIZATION 97 1,441 960 1,741 1,741 1,318 1,318 1,741 i 1,850 1,742
62-0750-7566 tAMORTIZATION 98 1,101 734 1,163 1,163 ' 1,670 1,670 1,163 1,210 ! 1,164
62-0750-7567 'AMORTIZATION 2001 3,556 3,556 ' 2,113 3,556 3,565 3,556
TOTAL 322,056565,302
241,340 863,539 626,385 531,499
--- -_- -----_ 1,002,297, _-- 886,141 __--_ 1,001,462
62-0740-7431 METER READING 10,931 8,139 13,635 15,633 13,568 15,934 23,513 2.2,643 24,175
62-0900-9030 COLLECTION EXP 752 936 2,847 6,638 2,891 1 5,898 6,555 I 7,066 5,000
62-0900-9051 MISC CUSTOMER EXP 5,631 4,641 f 7,101 10,748 5,810 9,835 9,745 1 9,835 14,000
62-0900-9061 WRITE-OFFS 0
1,20
,500
TOTAL 17,314 1,2003,4632,867 1,2000,7425,67
l 23,469 39,813 40,744 45,675
1 1 23, 83 33,020 --- -----1 -- --- - --- --
- -
BUDGET COMPARISON 6 200610/07/05
um Nob ummeii ammil mumAT GE1_ ausi um Ns _r ism
WITH RY
ACCOUNT# I DESCRIPTION 2000 2001 2002 2003 2003 2004 2004 2005 2006
I YR TO DATE ACTUAL ACTUAL ACTUAL BUDGET BUDGET ACTUAL BUDGET ESTIMATED BUDGET
ADMINISTRATIVE/GENERAL EXPENSE { _
62-0920-9201 SALARIES/ADMINS 12,570 8,881 14,398 16,9331 22,995 22,995 27,930 24,990.00 68,000.00
6 - 21 -
16,315 14,103! 16,218 22,826 21,000 29,000
6 -0920-9211 OFFICE SUPPLIES/EXP 6,143 6,321 14,511
62-0920-9212 LT/WATER CONSUMP OFFI( 227 I 242 ! 1,070 3,428 780 2,980 2,156 ! 2,980 3,500
62-0920-9213 BANK CHARGES 913 1,280T 2,2001 2,939 J 1,590 1,640 _ 1,565- 1,660 2,980
62-0920-92224EGAL FEES _ 825 1,253 2,091 I 2,487 2,500 2,500 44 ' 2,500 2,500
62-0920-9251 ;WAD - -I 3 - -
62-0920-9231 AUDIT 2,750 2,200 2,561 I 3,376 3,000 3,300 4,398.1 5,200 _ 5,200
62-0920-9241 INSURANCE 16,808 16,500 14,756 I 39,330 . 16,800 24,000 28,232 24,000 25,00.0_
62-0920-9262 UTIL SH PERA 3,405 1 1,370' 4,917 19,500
62-0920-9261 UTIL SH INSURANCE 9,849 L 14,127 28,605 40,405 0,306
'WATER UTIL CONT
20,100
26,320 ' 54,027 58,068 71,408
62-0920-9263 SICK PAY 9,009 8,267 25,522 19,735 13,041 17,644 36,927 27,600+ 34,953
--- --- ------
17,644 _ 36,927 28,600 34,913
62-0920-9263 UTIL SH FICA
6,236 2,853 7,838_1 9,868 3,800 3,800 7,471 4,000 12,575
62-0920-9292 ICONSULLTINGON IMP PROGRAM
62-0920-9267 VAC/HOLIDAY PAY 13,621 9,971 16,297 I 18,258 _ 12,500 13,100 40,326 13,900 1 37,000
62-0920-9269
19,873 8,858 9,948 23,332 12,000 - �
- -- I - - -- ---- - - 15,000
- - I 20,000
12,000 18,318 12,000 I 10,000
62-0920-9301 TELEPHONE 703 1,456 3,831 ' 4,380 2,650 3,500 3,374 3,500 I 4,400_
62-0920-9302 ADVERTISING 4,852 3,887 5,798 1,000 5,000
5,327 5,000 5,000 5,613 ' 5,000 5,750
62-0920-9303 DUES/SUBSCRIPTIONS 4,1451 5,172 10,595 5,892 5,500 10,604 6,500 31,000
62-0920-9304 1,320 1
62-0920-9307 M18 SCHOOLS/MEETINGS
INGS 4,330 1,033 11,447 � 6,695 11,600
070 1,750 0,250
62-0920-9305 11,600 15,070 14,750 20,250
1,050 j 2,482 j 1,050 2,000
62-0920-9321 'MTCE GEN PLANT/OFF HTG 25 990 491 14,241 1,000 1,000 5,5901 2,000 1,500
TOTAL 116,480 103,997 180,034 261,818 156,695 194,563 314,824 280,134 435,425 75
TOTAL EXPENSE 751,834 609,260 1,127,017 1,712,399 1,136,906 1,138,9651 1,850,617 1,649,105 2,067,663
I
WATER 1_
TOTAL REVENUES 1,366,879 1,113,466 1,189,471 1,372,160] 1,562,469 i 3,639,571 1,937,534 2,085,754
TOTAL EXPENSES j 767,335_ 557,852 684,597 1,156,906 1,138,965 1,850,617 I 1,649,105 2,067,663
PROFIT(LOSS) r 599,544 555,614 504,874 215,254 423,504 Y 1,788,955 I 288,429 ' 18,091
-- I -_ --- 4 - ---_- -_ - I- - __ -- -__' --{
4
DUO�CT COM(V RIEON 7 200610'07/06