ERMU Financials 11-09-2005 FINANCIAL INDEX
11111 Sep-05 FINANCIALS PAGE
I
COMBINED BALANCE SHEET 1
I
ELECTRIC INCOME STATEMENT 2
I
WATER INCOME STATEMENT 3
CASH FLOW BY MONTH 4
IGRAPH #1 ELECTRICAL PURCHASES 5
U
GRAPH#2 ELECTRIC SALES 6
GRAPH #3 ELECTRIC SALES/CUSTOMER CLASS 7
I GRAPH #4 WATER PRODUCTION 8
GRAPH #5 WATER SALES 9
DETAILED ELECTRIC P & L WITH BUDGET INFORMATION 10
I11
12
13
PDETAILED WATER P & L WITH BUDGET INFORMATION 14
15
I
16
DETAILED CASH FLOW ELECTRIC 17
IDETAILED CASH FLOW WATER 18
I
I
I
I
I.
ICOMBINED BALANCE SHEETS
NI Sep-05
ASSETS ELECTRIC WATER
I
CURRENT ASSETS
CASH &TEMPORARY INVESTMENTS 39,221.41 444,132.21
ACCOUNTS RECEIVABLE 1,838,452.11 424,387.72
I INVENTORIES 1,193,562.46 47,655.28
PREPAID ITEMS 25,130.25 5,704.47
CONSTRUCTION IN PROGRESS 45,018.93 465,780.99
TOTAL CURRENT ASSETS 3,141,385.16 1,387,660.67
IIRESTRICTED ASSETS
EMERGENCY RESERVE FUND 95,000.00
I CONSTRUCTION RESERVE FUND 1,161,178.57 1,000,000.00
TOTAL RESTRICTED ASSETS 1,256,178.57 1,000,000.00
FIXED ASSETS
I PRODUCTION 2,339,142.74 9,113,605.37
LFG PROJECT 3,048,596.31
TRANSMISSION 453,005.00
I DISTRIBUTION 21,101,387.47 17,182,783.45
GENERAL 9,164,784.08 714,380.93
FIXED ASSETS (COST) 36,106,915.60 27,010,769.75
LESS ACCUMULATED DEPRECIATION (13,399,087.80) (5,051,545.84)
I
TOTAL FIXED ASSETS, NET 22,707,827.80 21,959,223.91
OTHER ASSETS 23,500.97 97,456.33
PITOTAL ASSETS 27,128,892.50 24,444,340.91
LIABILITIES AND FUND EQUITY
I CURRENT LIABILITIES
ACCOUNTS PAYABLE 770,060.24 (7,650.26)
SALARIES AND BENEFITS PAYABLE 156,326.96 50,664.81
DUE TO CITY 35,515.28
I
DUE TO OTHER FUNDS 196,142.61 6,118.08
BONDS PAYABLE-CURRENT PORTION 124,919.00
TOTAL CURRENT LIABILITIES 1,282,964.09 49,132.63
I LONG TERM LIABILITIES
LFG PROJECT 2,434,127.70
DUE TO COUNTY 20,560.08
BONDS PAYABLE, LESS CURRENT PORTION 2,378,840.00 6,146,250.72
ITOTAL LONG TERM LIABILITIES 4,833,527.78 6,146,250.72
TOTAL LIABILITIES 6,116,491.87 6,195,383.35
IFUND EQUITY
CONTRIBUTED CAPITAL
RETAINED EARNINGS 21,012,400.63 18,248,957.56
ITOTAL FUND EQUITY 21,012,400.63 18,248,957.56
TOTAL LIABILITIES& FUND EQUITY 27,128,892.50 24,444,340.91
I.
I1
I
4
I
I
I
W M N 'O c1CA1
'i O'O, N- r-,Ce''C'r V N- IV 'VO(0,C0 O
'VIH r- N- CO N N- CD 'ILO,I ' e- N . M O CO C CAI' aIN,o,O)1 C' ,(olc N 'CIN
IR1U
IQ CD U1'CM,C'O) M'C C) 'CIVI`Kr O CDIC O CA'I` CIO OI O C,CA',- O O O O
10 co co N D) MSC' 'O O N O,I- CvICA co N ,A v AI co ^ C) AI CD' co IN,OED co U 'co 1
Cn' V'
QIP
IF
N',am c'�10O'f�, 'NRCD
'CIN- IcV'D' 'NI C
(O'c O'fr-!N cola!
I.-- N- r r N `-" e- O ,- N CO CD O CD V,CO 1 N .-'CD Ml.- LC),CD'N O e- ,CD .-1
CI1-!C'N'N- N- Q 'n 'O v:16 6'M M'M D A'Oicn A N-
MIO N N CO R O)
CAM
I '0 e- n Ni D) VI
O D r-'� � V,cD1 A1T'Q) 'ni l
M 10 Q) e-'O), CrN,
}
•
' I ' C II, ' ' ' 1I N
'
I
�
'w 'CA'W CD h O h O Q)
o N h.O'(D N m O A
'�'� (D r-.... cm �' N- CD m
'm 1 CD1C)'c 1O n'cI N c� V
� 'O 1� .- c N,.- MT N ,O'O)'D110 NO O D)
N-, CA O,N A N ,�
O N- D O'f�'N 7 1M
'N'NiO;O.M C r-- 'N
V VO N'Mlf� r- V MIIDM'Q) CDIO,M :CO r-- 7) Q o)
IIN- (ccV1NV `OROC'M 'CV cc''') vo'K D) fM`SmD)
,N N- OIM'N'N c, � 'CD R O N'o
M,(D AiV10 IN CO 'CD,C)Im O 7 O, C
'c'
'M.-
7�O �
W 'h Cn,O C'7 M I oIM' CA C'c'OD M, 'O M'C)10Q) O' NICo,I� .6.-cr.N F c - e- r- N COv e-ICf ,e- O C � e- e- 1-M N- M' T N IcI1-I
O. csi M co o) o) v�
2
W
W 1 '
Q O 01010 O'O' 'C O O o C C C C C o O O O O O C�iIC OI O'CI010'IO O CO„ ;0
NF” J . . .:. . .„.1. . . 11.,.,. . . . .
I. .
O CIO'OIC CC:C'O'O�O,10 O .O O IO
QII- N- N 'N e- C' 'N''(DIC I� IO,N C,C CAO 1, IV N:CA,CIO CD'OICV O CN'I-10 M I� .o c) r',
,_,L,., C)!
C'M N- D),N.
C M C,r-'C C'CD O O 'M N- C'O'O N O'N'O MICA O O M O N,
�lUt CA '�G) t` c C' D) 'O C IO,N�O'Oi0 O N ''h h,N O 1 10 CA O'r- N'OIV V f-1V' M;
Q F- O c (7) (D:N- V Q) Ic N c CA1O OjN M c �(D ,N- N- O O COIN- c1(D'M N 'h N 'CA I
V c N O CD,V 1 N- V N- CD e- O CA �'C m cco 107,0 C M;O r1r CD N O 'C O C
p 'V', -,o) N e- e- M `-",N CA r I� M, N 6C I1 cDIN'N ,-.co,.--,,-., Co e- V 'co IV
Z p m ,(N, r 1� oil I c CA'v: r-
W NI 0 CD
-
A , O I,N- V C C) V Oc I ' 1N- o) CnI CA CD 'c 1
CD N' V DAOV'CDC 0A D) 11._1,, ,,,,.„. coh co 'o) CA o) O e- O,a N N'CO M CO COCOD'W Q ' I 'co (D A O NcIA co1O co N'CDC100I- CA 'oA 'toPD1
CD I 1
J ,r- N- N- O e- CO C'CD V 'OD),C O .- O N N- NICD,0,00 CO 0,e-10D Q) CD N ,` N V I
W h,CD V M e- M 'e- N C 'CA,.1"..,CI O) '7.1 c N M,e-ICD1'- O OV;e-,N- CA -- N- O N,Q'C,O
p >_
'N-'C 'CCI C, 'N- C1e- A M',' O h CD' C N-'0'c CDININM A;.- A 'h'A N
, )' I v (Nr- o,M(nC) o) co ! v (oI�,� " v1o,�'�I a'°' � � `NA! 'N°)IN'Qw ..,.... ,_,..,1,_,..,.... ,_,..,1,_,.. ,_„,,,_,.,, 1NI '
C I N , -(
O CD O O D) CA' 'N'CI N ,-'.7H.0,0 1"O C IN- N- C') 0'0 C+)'0 N CA CO O ,O'CII 'O1: I
11a .- N M O 1- N' cA o' N CO NM'O (0.0 CA !CO N'CA CD 0 CO 0 O co O V CA M O ,coo, co,
IIW I C7)'N-'N- a,O V' CA co CA M (A'M'ID CA:CA M C 1 C,CAe-'CD CA O C Q) O �'M cD 'C'(D' N,
C,m 'OIC',M OIo) 'c'N-, N ,(P c,NIO C'M c h-
.,-
CD'M a-ICA c C,C N .-'O CD N CA N- CA N'
O 'f�IN 1e- AICD .- ,O .-- N r- t` CA R,r- co .!---
:
1 N- O,M''t'IM�NC CA �' '-,a N I�,N CA
p,W :CA CA N,C'CD M' 1C!0' D) CA co C'C f� M N- (D 1 CA'C :N N O1 C''V O)' 'O,N- I- N 'COIN
N N- e- N'o'r- � ,N" N. r- CA r- O CO N �''N �' '(D C r- C '1-
I
Ul ,_ ,- I , , , )- :-:-
o o w m
I
1 1 a) a) D ;Z 1 N
u'1rn w 1F
' I 1,....1m,,-9-:
a 'I OI
��' mI
d ad, ; rOji m
c)..1 tO
Ua o oaI O. _I!
l
c a c ~ E ~ I N 1-
I
'd' sl o!U; o', I I I 1 c o w
E I
a' c, o d,
III « IcI
D o `Ila) d cIa'' IcI NI �1 al 1 c,W (ni 'a'
N' Z` '121,�,U °)'N a).a).
N' Ili1 ,j11 c N' a•fa N W w
d 'U J L c O'er 'c >Iaiu.clI IcI '�laj; d c pi 11 Ic LL1, ISI
E.
o) U y Co >10 SIIGJG, �1' a' o c' a' w c'a '(AIV7 (nI 100,,
UI a) oI (A ` c d' ' U o' 1 'w 'w1 xI, m'a� x w Z
c' ,W. > >,rnm o,ul u �,d of �I E o'a �I �I WI 1LIh !
l fflP1
t >'. ,N �!S,73I2'c a-51 Oa� �,C71c U _y, dI lU
Iw >,'c'iI'cl..l ml o a) oI m o' c mai,o',a)' 'X�'�w w OIC D a U C9D Q1 I m U'IJ,UI(n �I wi_re 1 1 ' II ,
`' O 0 5''1 cI cIin 2'I,O a) E (Q' I ,J J Q
I
y;
d a
wl 0 ;L
IO, y, ,�Ic' I IZ E H'H w
:coaioi ,,a1$y U .r.� y,a'
DTIaA-JID In01(n'UIQI OOCl-
,
,)-.F-,0
2
NM 11111•rl MO UN NM EN NS MI IR I MN MI EN iirMN
WA
INCOME STATEMENT
ERMU Income Statement 2005 2005 2005 TOTAL 2004 2004
SEPTEMBER YEAR TO DATE BUDGET SEPTEMBER YEAR TO DATE
Water
REVENUE
Operating Revenue
Water Sales_ 201,039.70 1,086,611.54 1,443,534.00 168,640.95 962,807.51
Total Operating Revenue 201,039.70 1,086,611.54 1,443,534.00 168,640.95 962,807.51
Other Operating Revenue
Interest/Dividend Income 4,966.46 45,111.54 15,000.00 - 4,000.00
Customer Penalties 3,419.39 11,170.75 7,800.00 2,092.65 7,897.45
Connection Fees 74,557.79 666,701.99 471,200.00 94,296.0.0 730,124.89
Misc Revenue (61.78)
Total Other Revenue 82,943.64 722,922.50 494,000.00 96,388.65 742,022.34
REVENUE TOTAL 283,983.34 1,809,534.04 1,937,534.00 265,029.60 1,704,829.85
EXPENSES
Production Expense 804.75 27,113.10 10,000.00 2,003.76 11,087.87
Pumping Expense 23,362.88 240,355.50 258,818.00 38,056.74 201,296.78
Distribution Expense 12,173.90 130,210.19 165,043.00 11,494.88 125,970.10
Depreciation 60,000.00 530,000.00 600,000.00 15,500.00 141,000.00
Interest Expense 14,524.00 153,187.29 276,049.00 5,371.36 48,342.24
Other Operating Expense 994.40 5,314.56 10,092.00 785.42 7,018.53
Customer Accounts Expense 642.30 7,236.84 18,101.00 2,051.67 10,768.49
------- -- -
Administrative & General Expense 32,271.89 333,908.27 280,134.00 21,826.75 205,541.64
Total Expenses (before Operating Transfers) 144,774.12 1,427,325.75 1,618,237.00 97,090.58 751,025.65
TOTAL REVENUES 283,983.34 1,809,534.04 1,937,534.00 265,029.60 1,704,829.85
TOTAL EXPENSES 144,774.12 1,427,325.75 1,618,237.00 97,090.58 751,025.65
OPERATING TRANSFER - 20,000.00 30,868.00 - 27,708.00
NET INCOME PROFIT (LOSS) 139,209.22 362,208.29 288,429.00 167,939.02 926,096.20
W
I
11
1111110 too
I -
Lo
4 r I I I I
o
z
I I II I I
N0m o LiI
I
-1!u 1OO O d O N co r1N _ O
42 CI' °,-'1., omam
M 0mn o io14 OI N O N `-I O ° 0 r O
O. m I 0- 0- b OM M mO dTd h
I co
N OI IF? O N ,_-I
N
mO N b r NI M O �
m Ot m O r Qi m O m P
Nh m N OO4 O m m
or o m m O e ^ o o '1,i' -1a
— — ` I ' ' ^ N ^ N O .r
^ O m�D O
m O m 0 o oCO 0m rnm 1 mNNdvm m o m CD
mNam M mN�nornco o eoNION m O m mOm 1 m O m mm O m T CD I r
d' to O N d
III
-I d1 N N co O co m p, .d.. r m ` 1
3 �I
2 -__ 1 _ ___ _ —_-�—__ ___.__ - __ _ - _ _L
1-
m m ON d' d M `f m O
Z I n1 O m m . O
p m KI °2 o '4 o o m m
com 1 rn o0
7-1
'o I
m q Nm d N oo CV m CO m
al N ° m m o c0r.-- m
N III
I
LL=r-jIf
II
b
f m Im
)
m O O m O0 mCO
! b' V 4 a, m O
Lo
N i' O m
N d d O m O 4m ^ Om
CD. m m O N
N m CY
OIO. m
U f N co d ml N tV
m - 0 CO
COo N m1NO ' N
N
e m4 OI O O m
N m O b 111-4--I
CD
I mmO03
m m1.0m m m of lhN mbCO M `ONN m CO
N m0i a0 m .m1 0, M 01
1
r
CP !
O NI O N
O mO Oo m m O Of I Nr
—I O CO
CO CO CO m
CO m
e n o oo I CO m So m . m 9 m rI d 0,l CD m m CY 0
- _
CC
q
N ml o00
a' N CO m m m a, CO
- - - - N r -- ---__ -
Lu J u W H—
Z U FQ- Q 1 W rx I ! ti F! Z 1 Q N P-
w ? O Z W'I W p ZI W Z W Z 1
2 > 1- U_' >' - O 2 1- _U' > - 0 I 11
U j Li) pcn
o 91
W', w' w1cO
o N w,1
�I ZI U re
O i
W Z Z co Z SII K W
I.
VI z YI N z -- N . z Y p Y z r
a vCO, •,c w U z v
W uxwo w o Z , W F- x W W 0 1 Z Q o l z 0 ' er 6 2 ¢ 2 z O ofLLU O 3 U N N U w U U N! O WWI 2 } 'I ❑1' — [W�'' 2—If1 W W M N NI N W
• Q >1
1 re
a o 0 0 o o K 0- 8 0 0' .- o! I
0 0 0 l y o o U O 0 0 co O I U c,
4
I
4 ELk River Municipal Utilities Monthly Electrical
IDemand
I 50
45
I 2 40
2005 rw •c35
•
-a •
•
I 0 30
• , w w
C3 25 •�"" w 2004
I 20
15 I I I I I I I I
��/ `o``16. �ac�r PQM\ �a� ,�‘� �J\� PJ��S'����,o�� G'`60 ��ee' wee'
�0 �e< �° Oen
IMonths
N
Elk River Municipal Utilities Monthly Energy
111
Purchases
22,000
Ix 21,000
2 20,000
I
c 19,000
e18,000
co
2 17,000 �' •
I 3 16,000 . . w ,.
a 2004-y, •
15,000 , 2005 , • i
. - 4,
w ,d14,000
•
IC . ` f
w
W 13,000
12,000 ii,
43 oe
Month
I.
I
I I 5
I
4
IElk River Municipal Utilities Monthly Total Electric Load
22,000
I20,000
x
I 18,000 2005 '
c ' .
.0 16,000 '.
as
0 I
I 14,000 . - r
� � • ` `
r.
0
r ♦ ♦ w r
d 12,000 ti r "`
I W
10,000 2004/
I 8,000
�Jiz e,0/ facer PQM\ 4\ �Jce ,J�� P,)q veeec e'�o�ec o ec(, eee,,
IMonth sec O O
p
Elk River Municipal Utilities Monthly Electric Sales
I $1,800,000
$1,600,000
I $1,400,000 • •
'2
•
E $1,200,000r, • • •
~
I o $1,000,000 r rr
r
al
♦ .
r 0
r M
.01OMr
.
w $800,000
cZ $600,000
$400,000 2004
I $200,000
$0 I I I
I acacceo p � Je -1 �Jy .peres . e
,p
e
c J4<z> ‘'.•
3P �eo eo �ecc` eco
r/' <46) Month
5pO 43 Qeec
16
I
I lo
I
NO
ELk River Municipal Utilities Monthly Residential, Commerical
I & Industrial Loads
12,000
I10,000
Industrial
II 8,000 , , ` ♦ _
•
•
6,000 : VI1441 • . . ` - -
15
as 2006 ♦ ♦ r r r -
, ` ♦ ♦ . ,
o 4,000
2004
I 2,000 - - - • - • . - - _ -
r
Commerical
,a�Ng" e�`Ng' �,k PQM\ 4\ ,J�e \-\ P, 1- ���,o�c G��c eeec e
I Month e
O� O
�e.z O �O4 Oea
IP
Elk River Municipal Utilities Monthly Residential, Commerical
& Industrial Sales
I
$900,000
I $800,000
$700,000 hnduslriat
I
E cc
$600,000 2
O �
p $500,000 r r
` �
, , l° ♦ ` - r a 1
N $400,000 r ] rrr.:4101/4441/..:°!.°
r - r 0
• 0
Iin $300,000 \ 2006 2004
$200,000 ,-
II $100,000 - - a - - - -
Commerical
$0
I0 �`J0 ��cr �a� �.0 JAJS> ems, a'�o�ec e�Noec e�x?
Fe P Oe p �4° Oea
Month
‘111
I
7
I
No Elk River Municipal Utilities Monthly Water Pumpage
I 140
I A 120
C9
c 100 •
o • •
I80 .,
c r •
60 2006 II c.
0- 40 i .. •
E • • • • r
a 20 2004
II 0 , I , I I ,
,e, (<0"'
e�`Jel> �a�or PQM\ �a\ ,�o ��� PJ�Jy� �o��o` OG�o�oc �o��o` ao��o`
ICoQ ‘-‘° Oo
Month
I
IDElk River Municipal Utilities Peak Day Pumpage
I 6
5 - N.
I R •
c 4 •
'p
1
� 3 � •..\,,,,,s.....
>, 2006 •
i
o •
- �,,- .
to
a M� •
• . a • r • • 2004
1
I0 ,_ , , , , , , , ,
i c•\)?"
Q CoQ ‘'‘o 'Oe'
Month
I.
I
I S
I
iii•
Elk River Municipal Utilities Monthly Water Sales
I
140
I120
i
Co 100 0 �•
I
_ •
0 80 • •
•E
I
c 60 `
M r `
d y t
�a 40 - ' `
/• .. .
I
20 2005
I
0 2004,
J,b6 J1)6 �c'� Q�� a,\ Jae �J�� J5'c ,oe� ,Qee ,Qe ,oe
a ,Qc `D P Jg e� ° e0 of
Fe P �eQ� 06 �O O0G
I Month
IP
Elk River Municipal Utilities Monthly Water Sales
I
$300,000
I $250,000
I 2 $200,000
• •
o � • •
5 $150,000 ' •
I
N
•
•
_
N $100,000 i
i / ` _
I
$50,000
2006 2004
$0
I
Jit c�a1 fie§ PQM\ �a� ,Jce �J�� J�y� eec a�n ec s e` F�°e`
�a <<ib Q. e9�e O 04 00
C O
1411) Month
I
I 9
MB NOV1111 :37 ill. - - MIME LMIN/L A US PA/MT!. ESQ MI MI 1111 - dRle 1
all
Fiscal Year 200gwr Budget Fiscal YrE 2004
Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total
Revenue
ELECTRIC
ELECTRIC OPERATING R
61-0440-4411 ELECT SALES/ELK RIVER RES 524,448.73 4,124,850.90 83 46% 411,857.00 4,942,279.00 817,428.10 3,480,244.24 4,526,546.96
61-0440-4412 ELECT SALES/ER NON-DEMAND 128,096.61 1,191,687.05 84 68% 117,280.00 1,407,359.00 215,671 95 971,281.26 1,275,229 51
61-0440-4413 ELECT SALES/ER DEMAND 620,953.08 4,341,036.29 71.83% 503,650.00 6,043,797.00 1,702,760.71 4,289,527.20 5,648,048.79
61-0440-4414 ELECT SALES/ELK RIVER SEC LTS 2,210.68 20,196.37 74.57% 2,257.00 27,082 00 6,885 63 19,883.43 26,694 39
61-0440-4415 ELECT SALES/ER CITY DONATED 15,287 26 115,676.99 107.01 % 9,008.00 108,102.00 (7,574.99) 87,865.72 120,687.44
61-0440-4416 ELECT SALES/OTSEGO RES 73,748.61 549,858.43 80.31 % 57,058.00 684,696.00 134,837.57 490,228 46 633,900.55
61-0440-4417 ELECT SALES/OTSEGO NON-DEMAND 18,006.11 127,537.31 87.24% 12,182.00 146,188.00 18,650.69 109,528 57 141,065.14
61-0440-4418 ELECT SALES/OTSEGO DEMAND 29,659.74 125,609.13 96.62% 10,833.00 130,000.00 4,390.87 102,666.15 133,175.77
61-0440-4419 ELECT SALES/OTSEGO SEC LTS 722.84 6,467.20 71.09% 758.00 9,097.00 2,629.80 (1,294.87) 804.61
61-0440-4421 ELECT SALES/BIG LAKE RES 17,489.10 158,951.06 66.30% 19,978.00 239,741.00 80,789.94 149,575.69 194,656.99
61-0440-4422 ELECT SALES/BL NON-DEMAND 789.20 5,030.53 96.43% 435.00 5,217.00 186 47 4,218.81 5,332.20
61-0440-4423 ELECTRIC SALES/BL DEMAND 0.00 61.01 0.00% 0.00 0.00 (61.01) 0.00 0.00
61-0440-4424 ELECT SALES/BIG LAKE SEC LTS 137.70 1,260.80 71.07% 148.00 1,774.00 513.20 1,298.70 1,731.60
61-0440-4431 ELECT SALES/DAYTON RES 13,497.35 106,445.03 83.93% 10,569.00 126,831.00 20,385 97 96,999.49 123,160.31
61-0440-4432 ELECT SALES/DAYTON NON-DEMAND 1,743.79 13,455.94 81.06% 1,383.00 16,600.00 3,144.06 13,806.22 17,915.11
61-0440-4433 ELECT SALES/DAYTON DEMAND 0.00 0.00 0.00% 0.00 0.00 0.00 359.60 717.95
61-0440-4434 ELECT SALES/DAYTON SEC LTS 359.65 3,218.55 77.00% 348.00 4,180.00 961.45 2,873.45 3,590.15
61-0440-4441 PUBLIC ST&HWY LIGHTING/CITY 13,194.25 130,383.89 74.64% 14,556.00 174,678.00 44,294.11 126,769.65 170,801.09
61-0440-4511 SERVICE CHARGE 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00
61-0440-4550 SUB-STATION CREDIT 389.52 5,187.00 86.45% 500.00 6,000 00 813.00 4,630.45 7,464.81
61-0440-4551 GENERATION CREDIT 28,666.00 257,994.00 75.00% 28,666.00 343,992.00 85,998.00 257,573.25 285,794.82
61-0440-4552 DISPERSED GENERATION CREDIT (10,175.00) (48,262.50) 67.81 % (5,931.00) (71,176.00) (22,913.50)
(61,406.00) (61,406.00)
61-0440-4553 ADDITIONAL REVENUE/CIP 0.00 0.00 0.00% 1,250.00 15,000.00 15,000.00 0.00 0.00
61-0440-4554 RATE INCREASE 0.00 0.00 0.00% 16,750.00 201,000.00 201,000.00 0.00 0.00
TOTAL ELECTRIC OPERATING R 1,479,225 22 11,236,644 98 77.16% 1,213,535 00 14,562,437.00 3,325,792 02 10,146,629 47 13,255,912 19
INTEREST INCOME
61-0460-4691 INTEREST&DIVIDEND INCOME 5,193.31 17,508.10 350.16% 417.00 5,000.00 (12,508.10) 38,006.11 25,703.79
TOTAL INTEREST INCOME 5,193 31 17,508 10 350 16% 417 00 5,000 00 (12,508 10) 38,006 11 25,703 79
OTHER OPERATING REVE
61-0470-4700 SECURITY REVENUE 7,405.67 93,113.09 221.25% 3,507 00 42,085.00 (51,028.09) 27,056 34 38,719.93
61-0470-4701 CUSTOMER DELINQUENT PENALTIES 16,499.24 108,495.27 94.17% 9,601.00 115,212.00 6,716.73 107,174 10 118,910.23
61-0470-4702 DISCONNECT&RECONNECT CHARGE 16,597.00 375,901.66 107 40% 29,167.00 350,000.00 (25,901.66) 312,840.47 574,156.05
61-0470-4703 MISC ELEC REVENUE-TEMP CHG 0.00 3,300.00 165.00% 167.00 2,000.00 (1,300.00) 850.00 1,200.00
61-0470-4704 STREET LIGHT 0.00 24,589.21 122.95% 1,667.00 20,000.00 (4,589.21) 19,450.00 49,902.50
61-0470-4711 MERCH JOBBING&CONTRACT WORK (138.53) (138.53) 0.00% 0.00 0.00 138.53 0.00 0.00
61-0470-4715 NON-UTILITY OPERATIONS 736.20 1,125.80 45.03% 208 00 2,500.00 1,374.20 0.00 0 00
61-0470-4721 LFG PROJECT 58,723.36 531,001.24 75.86% 58,333.00 700,000.00 168,998.76 526,284 28 701,371.49
61-0470-4722 MISC NON-UTILITY 2,560.19 55,301.77 95.35% 4,833 00 58,000.00 2,698.23 17,563.56 35,228 21
61-0470-4723 GAIN ON DISPOSITION OF PROP 0.00 0.00 0.00% 0.00 0.00 0 00 0.00 0 00
61-0470-4724 SALES OF MERCHANDISE (22.86) 428 09 85.62% 42 00 500.00 71.91 (203.49) (755.81)
61-0470-4799 PRIOR PERIOD ADJUSTMENT 0.00 0 00 0.00% 0.00 0.00 0 00 0.00 0 00
61-0470-9998 PRIOR PERIOD ADJUSTMENT 0.00 0 00 0.00% 0 00 0.00 0 00 0.00 0.00
TOTAL OTHER OPERATING REVE 102,360 27 1,193,117.60 92 47% 107,525 00 1,290,297 00 97,179 40 1,011,015 26 1,518,732 60
TOTAL ELECTRIC 1,586,778 80 12,447,270 68 78 49% 1,321,477 00 15,857,734 00 3,410,463 32 11,195,650.84 14,800,348 58
0
OM NoviIII gr:37:0IM M. - INIELt.vorituspAryie99 ES NE EN N Nilo age 2 ollii
Fiscal Year 2005 Budget Fiscal Year 2004
Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total
Revenue (Continued)
TOTAL Revenue 1,586,778.80 12,447,270.68 78.49% 1,321,477.00 15,857,734.00 3,410,463.32 11,195,650.84 14,800,348.58
Expense
ELECTRIC
OPERATING & MTCE EXP
61-0540-5054 LFG MTCE 0.00 0 00 0.00% 1,250.00 15,000.00 15,000.00 0.00 0.00
61-0540-5461 OPERATING SUPERVISION 3,191.64 28,075.75 65.78% 3,557.00 42,680.00 14,604.25 29,519.98 40,190.63
61-0540-5462 INTERNAL COMBUST OPER/SALARIES 0.00 0.00 0 00% 524.00 6,285.00 6,285.00 0 00 0.00
61-0540-5471 DIESEL OIL FUEL 1,476.26 13,380.26 89.20% 1,250 00 15,000.00 1,619.74 0.00 778.31
61-0540-5472 NATURAL GAS 313.34 10,870.02 286.05% 317.00 3,800.00 (7,070.02) 3,636 18 5,842.28
61-0540-5481 LUBE OIL 0.00 6.12 0.47% 108.00 1,300.00 1,293.88 0.00 0.00
61-0540-5482 CHEMICALS 0.00 0 00 0.00% 0.00 0.00 0.00 0.00 0.00
61-0540-5483 STATION PWR&WTR CONSP/PLANT 2,613.24 22,600.59 75 29% 2,502.00 30,020.00 7,419 41 22,501.13 29,056.21
61-0540-5484 OTHER EXP/PLANT SUPPLIES-ETC 1,402.19 15,431.70 61 73% 2,083 00 25,000.00 9,568 30 22,854.94 29,374.69
61-0540-5491 MISC OTHER PWR GENERATION EXP 28 58 3,782.97 35.03% 900.00 10,800.00 7,017.03 7,731.54 11,715.41
61-0540-5521 MAINTENANCE OF STRUCTURE/PLANT 940.48 13,505.90 75.45% 1,492.00 17,900.00 4,394.10 10,858.03 19,940.33
61-0540-5531 MTCE OF ENGINES/GENERATORS-PL 1,717.29 17,847.23 39.66% 3,750.00 45,000.00 27,152.77 14,112.13 17,758 84
61-0540-5541 MTCE OF PLANT/LAND IMPROVEMENT 3,652.55 5,622.01 140.55% 333.00 4,000.00 (1,622.01) 3,481.57 3,823 91
61-0540-5551 PURCHASED POWER 716,884.28 7,539,853.78 79.26% 792,730.00 9,512,763.00 1,972,909.22 6,726,982.71 8,563,297.85
61-0540-5552 LFG PURCHASED GAS 8,195.99 76,464.16 85.91 % 7,417.00 89,009.00 12,544.84 73,457.39 141,782 67
61-0540-5561 PLANT STANDBY 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0 00
TOTAL OPERATING&MTCE EXP 740,415.84 7,747,440 49 78 91 % 818,213 00 9,818,557 00 2,071,116.51 6,915,135 60 8,863,561 13
LANDFILL GAS
61-0550-5051 LANDFILL GAS O&M 22,366.00 181,546.50 70.37% 21,500.00 258,000.00 76,453 50 156,388.13 219,178.10
61-0550-5052 LFG ADMIN 45.61 4,042.42 66.27% 508 00 6,100.00 2,057.58 5,079.31 5,364.56
61-0550-5053 LFG INSURANCE 0.00 15,080.00 88.19% 1,425.00 17,100.00 2,020.00 16,820.00 16,820.00
TOTAL LANDFILL GAS 22,411 61 200,668 92 71 36% 23,433 00 281,200 00 80,531.08 178,287 44 241,362 66
DISTRIBUTION EXPENSE
61-0580-5801 REMOVE EXISTING SERV&METERS 419.30 1,980.78 330 13% 50 00 600.00 (1,380.78) 917.98 1,349.56
61-0580-5831 TRANSFORMER EX/OVERHD&UNDER( 568.14 9,541.78 119.27% 667.00 8,000.00 (1,541.78) 5,799.31 9,448.54
61-0580-5851 MTCE OF SIGNAL SYSTEMS 337.67 653.48 21.78% 250.00 3,000.00 2,346.52 1,471.97 1,902 66
61-0580-5861 METER EXP-REMOVE&RESET 667.58 9,652.63 24.13% 3,333.00 40,000.00 30,347.37 7,769.79 10,330.32
61-0580-5871 TEMP SERVICE-INSTALL&REMOVE 542.90 4,269.53 79.07% 450.00 5,400.00 1,130.47 2,265.63 2,733.72
61-0580-5881 MISC DISTRIBUTION EXPENSE 9,820.44 101,006.86 77.70% 10,833.00 130,000.00 28,993.14 110,953.84 124,700.00
TOTAL DISTRIBUTION EXPENSE 12,356 03 127,105.06 67.97% 15,583.00 187,000.00 59,894.94 129,178.52 150,464 80
MAINTENANCE EXPENSE
61-0590-5911 MTCE OF STRUCTURES 161.05 412.25 25.77% 133.00 1,600.00 1,187.75 240.88 240.88
61-0590-5921 MTCE OF SUBSTATIONS 1,763.25 20,544.65 79.02% 2,167.00 26,000.00 5,455.35 20,561.45 25,534.28
61-0590-5922 MTCE OF SUBSTATION EQUIPMENT 156.28 1,314.19 38.65% 283.00 3,400.00 2,085.81 115.36 894.28
61-0590-5931 MTCE OF OVERHD LINES/TREE TRIM 2,026 14 93,167.01 93.17% 8,333.00 100,000.00 6,832.99 138,928.96 174,707.81
61-0590-5932 MTCE OF OVERHD LINES/STANDBY 2,845.12 24,851.94 95.31 % 2,173.00 26,074.00 1,222.06 20,867.14 25,593.05
61-0590-5933 MTCE OF OVERHEAD (3,215.14) 32,777.22 58.53% 4,667.00 56,000.00 23,222.78 27,090.45 33,595.00
61-0590-5941 MTCE OF UNDERGROUND/DISTRIB 6,892.95 77,773 03 120.58% 5,375.00 64,500.00 (13,273.03) 64,721.89 104,193.36
61-0590-5951 MTCE OF LINE TRANSFORMERS 2,249.26 12,932.45 80.83% 1,333 00 16,000.00 3,067.55 6,273.88 7,498.60
61-0590-5961 MTCE OF STREET LIGHTING 2,419 71 21,354.24 66.11 % 2,692 00 32,300.00 10,945.76 22,791.36 37,804.69
MIN Nov_ :37.0_ M M iELIVL/1U IS PIJTI.ESIMI Mil - Mil IIIIIII allPe 3
Fiscal Year 20031111" Budget Fiscal 2004
Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total
Expense (Continued)
ELECTRIC
MAINTENANCE EXPENSE
61-0590-5962 MTCE OF SECURITY LIGHTING 443.01 2,697.91 47.37% 475.00 5,695.00 2,997.09 3,603.79 6,426.97
61-0590-5971 MTCE OF METERS 5,078.80 47,328.90 111.36% 3,542.00 42,500.00 (4,828.90) 41,431.16 48,469.36
61-0590-5972 VOLTAGE COMPLAINTS 249.42 3,983.70 79.83% 416.00 4,990.00 1,006.30 3,850.28 6,179.63
61-0590-5981 SALARIES/TRANS&DISTRIBUTION 1,677 39 14,559.95 63.33% 1,916.00 22,990.00 8,430.05 16,601.27 21,981.73
61-0590-5991 MTCE OF OVERHEAD SERVICE/2NDRY 2,194 21 6,255.72 33.81 % 1,542.00 18,500.00 12,244.28 9,296.94 13,146.74
61-0590-5992 MTCE OF UNDERGROUND ELEC SERV 7,772.40 39,285.92 93 32% 3,508.00 42,100.00 2,814.08 26,859.59 38,351.38
61-0590-5995 TRANSPORTATION EXPENSE 7,551.49 70,764 05 48 78% 12,090.00 145,077.00 74,312.95 90,355.87 119,803.00
TOTAL MAINTENANCE EXPENSE 40,265.34 470,003 13 77 34% 50,645 00 607,726 00 137,722 87 493,590 27 664,420 76
DEPRECIATION/ELECTRI
61-0595-8031 DEPRECIATION/ELECTRIC 118,000.00 1,038,000.00 91.86% 94,167.00 1,130,000.00 92,000.00 643,350 00 1,427,091.00
TOTAL DEPRECIATION/ELECTRI 118,000 00 1,038,000.00 91.86% 94,167.00 1,130,000 00 92,000 00 643,350.00 1,427,091 00
INTEREST EXPENSE
61-0596-8071 INTEREST ON BONDS/LONG TERM 4,588.00 76,438.89 69.79% 9,127.00 109,522.00 33,083.11 3,161.97 87,544.63
TOTAL INTEREST EXPENSE 4,588.00 76,438 89 69 79% 9,127.00 109,522 00 33,083 11 3,161 97 87,544 63
OTHER OPERATING EXPE
61-0597-8161 COST&EXP MERCH JOBBING/ELEC 0.00 0.00 0 00% 0.00 0.00 0.00 0.00 0 00
61-0597-8172 SECURITY EXPENSE 19,429.83 112,102.27 747.35% 1,250.00 15,000.00 (97,102.27) 0.00 0 00
61-0597-8213 LOSS ON DISPOSITION OF PROP 0.00 2,626.29 26.26% 833.00 10,000.00 7,373.71 224.66 336.53
61-0597-8231 COST OF MERCHANDISE SOLD 0.00 0.00 0.00% 0.00 0.00 0.00 0 00 30,052.07
61-0597-8260 TRANSFER TO CITY FOR 99 BOND 0.00 0.00 0.00% 0 00 0.00 0.00 0.00 0.00
61-0597-8261 ELECTRICITY&LABOR DONATED 30,191.42 250,879.64 85.04% 24,583 00 295,000.00 44,120.36 217,628.40 294,698.18
61-0597-8262 TRANSFER TO CITY 3%ER REVENUE 30,000.00 270,000.00 72.61 % 30,988.00 371,857.00 101,857.00 142,000.00 340,564.28
61-0597-8263 OTHER DONATIONS 0.00 2,704.97 38.64% 583.00 7,000.00 4,295.03 6,220.83 7,888 29
61-0597-8266 2004 AMORTIZATION ISSUANCE 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0 00
61-0597-8281 AMORTIZATION OF DEBT DISCOUNT 10.00 90 00 68.18% 11.00 132.00 42.00 85.32 0.28
61-0597-8311 OTHER INTEREST EXPENSE 0.00 0.00 0.00% 0 00 0.00 0.00 0.00 0.00
61-0597-8341 INTEREST PD ON METER DEPOSITS 0.00 0.00 0.00% 0 00 0.00 0.00 0.00 0 00
61-0597-8399 OPERATING TRANSFER/OTHER FUNDS 0.00 0.00 0.00% 0.00 0 00 0.00 0.00 0.00
TOTAL OTHER OPERATING EXPE 79,631.25 638,403 17 91.33% 58,248.00 698,989.00 60,585.83 366,159 21 673,539 63
CUSTOMER ACCOUNTS EX
61-0900-9021 METER READING EXPENSE 5,452.20 62,128.48 107.12% 4,833.00 58,000.00 (4,128.48) 41,530.19 61,445.70
61-0900-9030 COLLECTING EXP DISC/RECONNECT 2,982.66 14,001.33 58.34% 2,000.00 24,000.00 9,998.67 18,184.43 22,203.10
61-0900-9041 CUSTOMER CHECKS RETURNED -NSF 0.00 603.53 0.00% 0.00 0.00 (603.53) 0 00 0.00
61-0900-9051 MISC CUSTOMER ACCTS EXP-COMP (1,096.12) (1,373.65) -5.72% 2,000.00 24,000.00 25,373.65 6,806.25 14,350 85
61-0900-9061 OUST BLGS NOT PD/SENT FOR COLL (174.19) 19,838.66 99.19% 1,667 00 20,000.00 161 34 23,684.79 23,136.04
TOTAL CUSTOMER ACCOUNTS EX 7,164 55 95,198 35 75 55% 10,500 00 126,000.00 30,801 65 90,205 66 121,135 69
ADMINISTRATIVE & GEN
61-0920-9201 SALARIES/OFFICE&COMMISSION 17,510.92 192,590.01 60.18% 26,667.00 320,000.00 127,409 99 223,681.63 293,406.22
61-0920-9211 OFFICE SUPPLIES&EXPENSE 3,904.61 64,396 33 107.33% 5,000.00 60,000.00 (4,396.33) 59,636.28 63,261.27
61-0920-9212 LT&WATER CONSUMPTION/OFFICE 1,123.79 8,034 33 157.54% 425.00 5,100.00 (2,934.33) 4,766.24 6,468.39
61-0920-9213 BANK CHARGES 532.43 5,400 40 92.50% 486.00 5,838.00 437.60 4,393.07 5,281.27
61-0920-9221 LEGAL FEES 0.00 2,188.28 27.35% 667.00 8,000 00 5,811.72 3,940 28 5,713.32
61-0920-9231 AUDITING FEES 0.00 10,942.50 91.19% 1,000.00 12,000.00 1,057 50 11,317.62 11,317.62
r"
MI Nom :37.0 - - Mit LKIIPIVAIR4 US PIJTI ESQ - - - UM. alk 4
Mil
Fiscal Year 20031.1r Budget Fiscal r 2004
Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total
Expense (Continued)
ELECTRIC
ADMINISTRATIVE & GEN
61-0920-9241 INSURANCE 1,177.88 72,042.03 60.14% 9,983.00 119,800.00 47,757.97 81,667.82 123,171.81
61-0920-9261 UTIL SH OF MEDICAUDENTAUDISA 16,677.85 152,171.19 77.84% 16,292.00 195,500 00 43,328.81 134,218.89 165,072.24
61-0920-9262 UTILITY SHARE OF PERA 7,944.10 101,124.33 116.64% 7,225.00 86,700.00 (14,424.33) 62,152.92 83,018.53
61-0920-9263 UTILITY SHARE OF FICA 10,226.36 95,461.30 86.78% 9,167.00 110,000.00 14,538.70 88,925.42 109,136.19
61-0920-9264 EMPLOYEES SICK PAY 3,802.16 30,584.15 76.46% 3,333.00 40,000.00 9,415.85 36,214.55 49,281.05
61-0920-9266 EMP VACATION/HOLIDAY PAY 12,834.04 93,094.60 68.96% 11,250 00 135,000.00 41,905.40 128,469.46 186,939.39
61-0920-9268 MISCELLANEOUS 0.00 36,951.45 369.51 % 833.00 10,000 00 (26,951.45) 0.00 (0 58)
61-0920-9269 CONSERVATION IMP PROGRAM (8,028.43) 110,661.23 75.80% 12,167.00 146,000 00 35,338.77 130,459.38 162,348.92
61-0920-9281 ENVIRONMENTAL COMPLIANCE 445.06 6,429.75 51.44% 1,042 00 12,500.00 6,070.25 10,225.34 14,601.54
61-0920-9291 CONSULTING FEES 9,897.04 39,047.03 130.16% 2,500.00 30,000.00 (9,047.03) 19,785 53 22,227.20
61-0920-9292 LFG PROJECT 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00
61-0920-9301 TELEPHONE 2,264.71 9,980.27 75.04% 1,108.00 13,300.00 3,319.73 7,295.59 10,104.73
61-0920-9302 ADVERTISING 2,958.79 12,796.44 60 94% 1,750.00 21,000 00 8,203.56 11,711.37 16,460.74
61-0920-9303 DUES&SUBSCRIPTIONS-FEES 1,811.55 32,532.38 116.19% 2,333.00 28,000 00 (4,532.38) 20,940 00 22,699.20
61-0920-9304 TRAVEL EXPENSE 66.70 4,168.75 104 22% 333.00 4,000 00 (168.75) 957.95 957.95
61-0920-9305 SCHOOLS&MEETINGS 2,273.81 50,871.81 73.25% 5,788 00 69,450.00 18,578.19 56,851.77 73,069.90
61-0920-9306 MISC GENERAL EXPENSE 0.01 49 50 0.69% 600.00 7,200.00 7,150.50 48.75 112.65
61-0920-9321 MTCE OF GEN PLANT/OFF HEATING 0.00 249.79 6.21 % 335.00 4,025.00 3,775.21 401.67 18,806.34
TOTAL ADMINISTRATIVE&GEN 87,423 38 1,131,767.85 7841 % 120,284.00 1,443,413.00 311,645 15 1,098,061 53 1,443,455 89
TOTAL ELECTRIC 1,112,256.00 11,525,025 86 80 02% 1,200,200 00 14,402,407.00 2,877,381.14 9,917,130 20 13,672,576 19
TOTAL Expense 1,112,256.00 11,525,025.86 80.02% 1,200,200.00 14,402,407.00 2,877,381.14 9,917,130.20 13,672,576.19
PROFIT/(LOSS) : 474,522.80 922,244.82 121,277.00 1,455,327.00 533,082.18 1,278,520.64 1,127,772.39
Date Range: 9/1/2005 To 9/30/2005
Report is for 61-0001-1071 through 61-9999-9999.
Active and Inactive accounts are included.
Report order=Fund
Transaction Source Code=Include All
mg Nov_irt38.11.111 M - MEL killiV AM U PIJTIENESMI NM OM MN - all
1 jail
Fiscal Year 200W' Budget Fiscal Mr2004
Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total
Revenue
WATER
INTEREST INCOME
62-0460-4691 INTEREST&DIVIDEND INCOME 4,966.46 43,611 54 363.43% 1,000.00 12,000.00 (31,611.54) 0.00 31,024.00
62-0460-4692 OTHER INT/MISC REVENUE 0.00 1,500 00 50.00% 250.00 3,000.00 1,500.00 4,000.00 4,000.00
TOTAL INTEREST INCOME 4,966 46 45,111.54 300.74% 1,250.00 15,000 00 (30,111.54) 4,000.00 35,024 00
OTHER OPERATING REVE
62-0470-4799 PRIOR PERIOD ADJUSTMENT 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00
62-0470-9998 PRIOR PERIOD ADJUSTMENT 0.00 0.00 0 00% 0 00 0.00 0.00 0.00 0.00
TOTAL OTHER OPERATING REVE 0 00 0 00 0 00% 0 00 0 00 0 00 0 00 0.00
SALES OF WATER
62-0610-6101 WATER SALES COMM&RES/COMPUT 201,039.70 1,086,611.54 75 27% 120,294.00 1,443,534.00 356,922.46 962,807.51 1,167,954.53
62-0610-6171 UNMETERED SALES 0.00 0 00 0 00% 0 00 0 00 0 00 0.00 0.00
TOTAL SALES OF WATER 201,039.70 1,086,611 54 75 27% 120,294.00 1,443,534 00 356,922.46 962,807 51 1,167,954 53
OTHER WATER REVENUE
62-0620-6300 SERVICES DONATED BY CITY 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00
62-0620-6301 CUSTOMER PENALTIES 3,419.39 11,170.75 143.21 % 650.00 7,800.00 (3,370.75) 7,897.45 7,897.45
62-0620-6401 WATER/ACCESS/CONNECTION FEES 67,220.00 613,805.00 145 73% 35,100.00 421,200.00 (192,605.00) 659,649.18 839,910 80
62-0620-6402 MISC CONNECTION FEES 7,337.79 52,896.99 105.79% 4,167.00 50,000.00 (2,896.99) 70,475.71 92,831.71
62-0620-6403 MISCELLANEOUS REVENUE 0 00 0.00 0 00% 0.00 0.00 0.00 0.00 0.00
62-0620-6405 CONTRIBUTIONS FROM DEVELOPERS 0.00 (61.78) 0 00% 0.00 0.00 61 78 0 00 1,495,953.00
TOTAL OTHER WATER REVENUE 77,977 18 677,810 96 141.51 % 39,917.00 479,000 00 (198,810 96) 738,022 34 2,436,592 96
NONOPERATING REVENUE
62-0790-7900 OPERATING TRANSFER FROM CITY 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0 00
TOTAL NONOPERATING REVENUE 0.00 0 00 0.00% 0 00 0 00 0.00 0.00 0 00
TOTAL WATER 283,983 34 1,809,534 04 93 39% 161,461.00 1,937,534 00 127,999 96 1,704,829 85 3,639,571 49
TOTAL Revenue 283,983.34 1,809,534.04 93.39% 161,461.00 1,937,534.00 127,999.96 1,704,829.85 3,639,571.49
Expense
WATER
OTHER OPERATING EXPE
62-0597-8260 TRANSFER TO CITY FOR 99 BOND 0.00 20,000.00 64.79% 2,572.00 30,868 00 10,868.00 27,708.00 33,897.00
62-0597-8399 OPERATING TRANSFER/OTHER FUNDS 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00
TOTAL OTHER OPERATING EXPE 0 00 20,000.00 64.79% 2,572.00 30,868.00 10,868 00 27,708.00 33,897 00
WATER PRODUCTION EXP
62-0700-7021 MTCE OF STRUCTURES 804.75 27,113.10 271.13% 833.00 10,000.00 (17,113.10) 11,087.87 29,341 95
TOTAL WATER PRODUCTION EXP 804 75 27,113 10 271 13% 833 00 10,000 00 (17,113 10) 11,087 87 29,341.95
PUMPING EXPENSE
62-0710-7101 SUPERVISION 2,039.08 16,395.76 67.15% 2,035.00 24,418.00 8,022.24 16,723.94 22,662.26
62-0710-7181 SUPPLIES&EXPENSE 15,032.89 118,762.34 64.02% 15,458.00 185,500.00 66,737.66 133,504 34 174,078 63
62-0710-7201 MTCE OF ELECT PUMPING EQUIP 74.22 4,637.42 103.05% 375.00 4,500.00 (137.42) 1,943 05 4,149.39
_ 62-0710-7220 MTCE OF WELLS 6,216.69 100,559.98 226.49% 3,700 00 44,400 00 (56,159.98) 49,125.45 81,336.83
-Nov_ :38.11.11. M Mit LMil VE /lU11 P/ JTI�ES� MI M. 1111 111111 all 2
Jail
Fiscal Year 200 Budget Fiscal W2004
Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total
Expense (Continued)
WATER
PUMPING EXPENSE
TOTAL PUMPING EXPENSE 23,362 88 240,355 50 92 87% 21,568 00 258,818.00 18,462 50 201,296 78 282,227.11
WATER DISTRIBUTION E
62-0730-7301 MTCE OF WATER MAINS 1,597.11 9,745 89 51.29% 1,583.00 19,000.00 9,254.11 17,045.39 26,134.94
62-0730-7311 MTCE OF WATER SERVICES 2,269.92 26,942.74 53.89% 4,167.00 50,000.00 23,057.26 33,281.75 40,785.67
62-0730-7321 MTCE OF CUSTOMERS SERVICE 2,936.01 27,706.88 97.22% 2,375.00 28,500.00 793.12 26,870.75 36,009.03
62-0730-7331 MTCE OF WATER HYDRANTS 0.00 3,472.69 43.14% 671.00 8,050.00 4,577.31 6,304.81 9,382.31
62-0730-7341 MISC WATER EXPENSE/INVENTORY 51.53 768.16 49.56% 129.00 1,550.00 781.84 186.19 155.69
62-0730-7391 WAGES/WATER 815.63 6,558.29 51.24% 1,067.00 12,800.00 6,241.71 6,689.57 9,064.89
62-0730-7395 TRANSPORTATION EXPENSE 2,818.56 32,316.38 195.86% 1,375 00 16,500.00 (15,816.38) 12,980.26 20,938 35
62-0730-7399 GENERAL EXP/WATER PERMIT 0.00 5,116.10 85 27% 500.00 6,000.00 883.90 5,746.00 5,746.00
TOTAL WATER DISTRIBUTION E 10,488 76 112,627 13 79 09% 11,867 00 142,400 00 29,772 87 109,104 72 148,216 88
WATER ACCOUNTING EXP
62-0740-7431 METER READING EXPENSE 1,685.14 17,583.06 77.65% 1,887.00 22,643.00 5,059.94 16,865.38 23,512.90
TOTAL WATER ACCOUNTING EXP 1,685.14 17,583.06 77.65% 1,887.00 22,643 00 5,059 94 16,865 38 23,512 90
DEPRECIATION EXPENSE
62-0745-7451 DEPRECIATION-WATER 60,000.00 530,000.00 88 33% 50,000.00 600,000 00 70,000.00 141,000.00 720,044 00
TOTAL DEPRECIATION EXPENSE 60,000.00 530,000 00 88.33% 50,000.00 600,000.00 70,000 00 141,000 00 720,044.00
INTEREST EXPENSE
62-0748-7481 INTEREST ON BONDS/LONG TERM 14,524.00 153,187.29 55.49% 23,004.00 276,049.00 122,861.71 48,342.24 256,206.96
TOTAL INTEREST EXPENSE 14,524 00 153,187 29 55.49% 23,004.00 276,049.00 122,861.71 48,342 24 256,206 96
OTHER OPERATING EXPE
62-0750-7562 COST&EXP MERCH JOBBING 0.00 0.00 0.00% 289.00 3,467.00 3,467.00 0 00 0 00
62-0750-7563 AMORTIZATION 1993 0.00 0.00 0.00% 0.00 0 00 0.00 923.28 5,652.62
62-0750-7564 AMORTIZATION 1994 0.00 0.00 0.00% 0.00 0.00 0 00 1,410.12 12,225.48
62-0750-7565 AMORTIZATION 1997 0 00 98.76 5.34% 154.00 1,850.00 1,751.24 1,100.79 1,741.41
62-0750-7566 AMORTIZATION 1998 132 00 1,188.00 98.18% 101.00 1,210 00 22.00 868 23 1,163.17
62-0750-7567 AMORTIZATION 2001 329.00 2,961.00 83 06% 297.00 3,565.00 604.00 2,716.11 3,555 69
62-0750-7568 AMORTIZATION 2003 533.40 1,066.80 0 00% 0 00 0.00 (1,066.80) 0.00 1,708.00
TOTAL OTHER OPERATING EXPE 994 40 5,314 56 52 66% 841 00 10,092 00 4,777 44 7,018 53 26,046 37
CUSTOMER ACCOUNTS EX
62-0900-9030 COLLECTING EXP DISC/RECONNECT 977.72 3,524.32 49.88% 589.00 7,066.00 3,541 68 5,512 29 6,554.91
62-0900-9051 MISC CUSTOMER ACCTS EXP-COMP 0 00 2,659.00 27.04% 820.00 9,835 00 7,176 00 5,256.20 9,744.93
62-0900-9061 CUST BLGS NOT PD/SENT FOR COLL 0.00 1,053.52 87.79% 100.00 1,200.00 146.48 0.00 0.00
TOTAL CUSTOMER ACCOUNTS EX 977.72 7,236 84 39.98% 1,509 00 18,101.00 10,864.16 10,768 49 16,299 84
ADMINISTRATIVE & GEN
62-0920-9201 SALARIES/OFFICE&COMMISSION 6,136.74 60,624.95 242.60% 2,082.00 24,990.00 (35,634.95) 11,022.24 27,930.15
62-0920-9211 OFFICE SUPPLIES&EXPENSE 1,268 41 21,509.84 102.43% 1,750.00 21,000.00 (509.84) 19,338.46 22,825.94
62-0920-9212 LT&WATER CONSUMPTION/OFFICE 374.59 2,747.17 92.19% 248.00 2,980.00 232.83 1,588.72 2,156.09
62-0920-9213 BANK CHARGES 177.47 1,590 82 95 83% 138.00 1,660.00 69.18 1,268.79 1,564.85
62-0920-9222 LEGAL FEES 0.00 127 58 5.10% 208.00 2,500.00 2,372.42 43.75 43 75
62-0920-9231 AUDITING FEES 0.00 3,647.50 70.14% 433 00 5,200 00 1,552 50 4,397.54 4,397 54
MN Nov_e:38:11111. - MI IMMELPRIV /1U P JTITTiES� 1.111 - .111 MN "Re 3
Fiscal Year 200 Budget Fiscal W2004
Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total
Expense(Continued)
WATER
ADMINISTRATIVE & GEN
62-0920-9241 INSURANCE 388.05 17,134.43 71.39% 2,000.00 24,000.00 6,865.57 17,495.93 23,528.55
62-0920-9251 WATER UTILITY CONTRIBUTION 0.00 0.00 0.00% 0 00 0.00 0.00 0.00 0.00
62-0920-9261 UTIL SH OF MEDICAL/DENTAL/DISA 5,559.29 50,486 69 86.94% 4,839.00 58,068.00 7,581.31 43,826.19 54,026.88
62-0920-9262 UTILITY SHARE OF PERA 5,645.51 22,237.62 81.95% 2,261.00 27,136.00 4,898.38 20,717.60 27,672 84
62-0920-9263 UTILITY SHARE OF FICA 1,298.40 23,571.00 82.42% 2,383 00 28,600.00 5,029.00 30,189.75 36,926 66
62-0920-9264 EMPLOYEES SICK PAY 1,267.39 10,476 33 261.91 % 333.00 4,000 00 (6,476.33) 3,581.24 7,470 61
62-0920-9267 EMP VACATION/HOLIDAY PAY 4,278 01 31,410.97 225 98% 1,158.00 13,900.00 (17,510.97) 13,058.66 36,528 60
•
62-0920-9269 CONSERVATION IMP PROGRAM 0 00 14,851.12 74.26% 1,667.00 20,000 00 5,148.88 0.00 0 00
62-0920-9292 LFG PROJECT 0.00 0 00 0.00% 0.00 0.00 0.00 0.00 0.00
62-0920-9293 CONSULTING 2,284.25 4,399.21 36.66% 1,000.00 12,000.00 7,600.79 12,762.34 18,318 33
62-0920-9301 TELEPHONE 754.90 3,495 87 99.88% 292.00 3,500.00 4.13 2,437.63 3,373.97
62-0920-9302 ADVERTISING 900.54 4,905 44 98.11 % 417.00 5,000.00 94.56 4,111.46 5,613.17
62-0920-9303 DUES&SUBSCRIPTIONS-FEES 3,868.05 23,679.93 364 31 % 542.00 6,500.00 (17,179.93) 9,849.11 10,604.41
62-0920-9304 TRAVEL EXPENSE 0.00 438.64 33.74% 108.00 1,300.00 861.36 199.50 199.50
62-0920-9305 SCHOOLS&MEETINGS 1,503.72 18,216.52 123.50% 1,229.00 14,750.00 (3,466 52) 10,181.84 15,070.44
62-0920-9307 MISC GENERAL EXPENSE 0.00 18,312.65 744 06% 88 00 1,050.00 (17,262.65) 16.25 2,482.07
62-0920-9321 MTCE OF GEN PLANT/OFF HEATING 0.00 43.99 2.20% 167.00 2,000.00 1,956.01 (545.36) 5,589.50
TOTAL ADMINISTRATIVE&GEN 35,705 32 333,908.27 119.20% 23,343 00 280,134.00 (53,774 27) 205,541 64 306,323 85
OPERATING TRANSFER 0
62-0999-9999 RESTATE BEGINNING RETAINED EAR 0.00 0.00 0.00% 0.00 0 00 0.00 0.00 0.00
TOTAL OPERATING TRANSFER 0 0 00 0 00 0 00% 0 00 0 00 0.00 0 00 0 00
TOTAL WATER 148,542 97 1,447,325 75 87.76% 137,424.00 1,649,105 00 201,779 25 778,733 65 1,842,116 86
TOTAL Expense 148,542.97 1,447,325.75 87.76% 137,424.00 1,649,105.00 201,779.25 778,733.65 1,842,116.86
PROFIT/(LOSS) : 135,440.37 362,208.29 24,037.00 288,429.00 (73,779.29) 926,096.20 1,797,454.63
Date Range: 9/1/2005 To 9/30/2005
Report is for 62-0001-1071 through 62-9999-9999.
Active and Inactive accounts are included.
Report order=
Transaction Source Code=Include All
■ -e. - II - _ 4 1
Cash Flows
Actual Actual Actual Actual Actual Actual Actual Actual Actual
Electric _ Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
REVENUE
Operating Revenue
Electric Sales 1,094,096 37 1,019,638 83 927,091 07 1,019,072 92 937,626.78 1,196,423 51 1,578,956 86 1,657,735 80 1,447,150 45 1,636,277 00 1,105,354 00 1,118,130 00 14,737,553 59
Public St&Hwy Lighting 14,922 54 14,841 22 14,358 03 14,694 58 14,800 32 14,281 08 14,694 10 14,597 77 13,194 25 14,500 00 14,500 00 14,500 00 173,883 89
Service Charge
Generation Credit 29,374 72 29,374 72 29,374 72 29,374 72 29,374 72 29,098 18 29,098.18 29,055 52 29,055 52 29,374 72 29,374 72 29,374 72 351,305 16
Dispersed Generation Credit (3,850 00) (3,850 00) (3,850 00) (2,000 00) (1,937 50) (2,562 50) (9,862 50) (10,175 00) (10,175 00) (48,262 50)
Additional Revenue/CIP&Rate Increase
1,134,543 63 1,060,004 77 966,973 82 1,061,142.22 979,864 32 1,237,240 27 1,612,886 64 1,691,214 09 1,479,225 22 1,680,151 72 1,149,228 72 1,162,004 72 15,214,480 14
Other Operating Revenue
Interest/Dividend Income 3,078 57 315 97 139 61 1,210 30 4,813 24 191 45 1,903 62 662.03 5,193 31 100 00 200 00 200 00 18,008 10
Customer Penalties 16,675.78 9,560 52 12,363 24 7,025 32 9,957 23 8,508 24 11,574 48 16,331 22 16,499 24 9,000 00 9,000 00 9,000 00 135,495 27
LFG Project 60,878 54 60,554 78 54,419 02 59,411 40 58,642 95 60,380 67 58,481 96 59,508 56 58,723 36 81,813 85 55,267 70 55,906 50 723,989 29
Connection Fees 29,121 28 50,662 10 36,772 05 63,915 18 55,476 77 38,502 32 20,670 00 64,184 96 16,597 00 29,000 00 29,000 00 29,000 00 462,901 66
Misc Revenue 44,371 67 17,246 12 25,393 49 17,822 02 11,237 50 18,290 98 7,896 56 25,107 32 10,540 67 15,000 00 20,000 00 25,000 00 237,906 33
154,125 84 138,339 49 129,087 41 149,384 22 140,127 69 125,873 66 100,526 62 165,794 09 107,553.58 134,913 85 113,467 70 119,106 50 1,578,300 65
1,288,669 47 1,198,344 26 1,096,061 23 1,210,526 44 1,119,992 01 1,363,113 93 1,713,413 26 1,857,008 18 1,586,778 80 1,815,065 57 1,262,696 42 1,281,111 22 16,792,780 79
EXPENSES
Purchased Power 754,532 57 670,528 36 613,674 34 575,453 84 576,306 33 1,202,888.70 1,267,977 77 1,229,914 17 725,080 27 785,135 00 621,277 00 618,635 00 9,641,403 35
Operating&Mtce Expense 13,114 47 18,693 27 16,649 51 14,218 56 15,195 68 19,235 23 3,849 82 9,722.62 15,335 57 18,000 00 18,000.00 18,000 00 180,014 73
Landfill Gas 19,859.43 19,836 00 20,053 43 35,138 93 23,301 93 19,864 93 20,328 50 19,874 16 22,411 61 19,836.00 19,836 00 19,836 00 260,176 92
Distribution Expense 15,445 72 15,885 99 11,276 06 12,375 31 11,624 38 14,047 90 7,263 91 26,829 76 12,356 03 15,000 00 15,000 00 15,000 00 172,105 06
Maintenance Expense 36,692.45 46,817 20 57,501 54 63,581 21 44,061 42 79,639 90 45,943 94 54,179 49 40,265 34 45,000 00 41,000.00 40,000 00 594,682 49
Depreciation 94,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000.00 118,000 00 118,000 00 118,000 00 1,392,000 00
Interest Expense 4,461 67 39,890 21 4,811 67 4,461 67 4,461 67 4,588 00 4,588 00 4,588 00 4,588 00 4,461 67 4,461 67 4,461 67 89,823 90
Other Operating Expense 15,124 64 4,834 94 13,967 31 10,362 28 11,048 37 13,398 21 14,915 61 12,077 15 19,439 83 10,000 00 15,000 00 20,000 00 160,168 34
Services to the City 56,520 07 56,128 92 54,265 95 56,935 34 57,812 81 56,261 99 64,264 21 60,854 12 60,191 42 55,000 00 55,000 00 55,000 00 688,234 83
Customer Accounts Expense 10,851 94 3,614.27 11,990 39 34,062 31 7,100 76 14,103 59 6,704.34 6,196.22 7,164 55 11,000 00 11,000.00 11,000 00 134,788 37
Administrative&General Expense 124,552 56 131,186 72 193,775 00 145,183 68 129,314 71 115,101 81 103,505 56 100,519 59 87,423 38 125,000 00 125,000 00 125,000 00 1,505,563 01
1,145,155.52 1,125,415 88 1,115,965 20 1,069,773 13 998,228 06 1,657,130 26 1,657,341 66 1,642,755 28 1,112,256 00 1,206,432 67 1,043,574 67 1,044,932 67 14,818,961 00
TOTAL REVENUES 1,288,669 47 1,198,344 26 1,096,061 23 1,210,526 44 1,119,992 01 1,363,113 93 1,713,413 26 1,857,008 18 1,586,778 80 1,815,065 57 1,262,696 42 1,281,111 22 16,792,780.79
TOTAL EXPENSES 1,145,15552 1,125,41588 1,115,96520 1,069,773 13 998,22806 1,657,13026 1,657,341 66 1,642,75528 1,112,25600 1,206,43267 1,043,57467 1,044,93267 14,818,961 00
NET INCOME PROFIT(LOSS) 143,513 95 72,928 38 (19,903 97) 140,753 31 121,763 95 (294,016 33) 56,071 60 214,252 90 474,522 80 608,632 90 219,121 75 236,178 55 1,973,819 79
Other Cash Items
Depreciation 94,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000 00 118,000.00 118,000 00 118,000 00 1,392,000 00
Accrued Interest 4,461 67 (8,923 34) 4,461.67 4,461 67 4,461 67 4,588 00 4,588.00 (39,145 12) 4,588 00 4,461 67 4,461 67 4,461 67 (3,072 77)
Payroll Liabilities (52,425 19) (97,771 52) (95,143 20) (52,638 30) (124,864 69) (77,860 60) (60,142 65) (11,543 65) (55,604 83) (70,000 00) (70,000 00) (70,000 00) (837,994 63)
Accounts Payable (221,126 67) (233,771 77) (237,710 88) (240,678 99) (305,700 32) (338,202 05) (384,356 27) (62,860 83) (258,905 69) (225,000.00) (225,000 00) (225,000 00) (2,958,313 47)
Capitalized Items (14,107 20) (130,784 58) (226,489 78) (210,992 10) (20,000.00) (15,000 00) (10,000 00) (627,373 66)
LTD&Bond Principal (144,394 67) (51,457 17) (10,409 83) (10,409 83) (10,409 83) (10,409 83) (10,409 83) (10,409.83) (10,409 83) (10,409 83) (10,409 83) (10,409 83) (299,950 14)
Accounts Receivable 68,436 18 246,734 39 310,781 62 143,790 35 326,052 44 98,811 00 345,991 82 42,606 45 76,342 03 322,273 45 530,923 00 151224 00 2,663,966 73
Inventory Purchases (4,082.56) (55,333 47) (92,852.00) (220,956 99) (201,650 45) (197,050 00) (56,066 45) (875 00) (66,161 55) (70,000 00) (90,000 00) (110,000 00) (1,165,028 47)
Change in Cash Balances (111,617 29) (23,701 70) (153,561 17) (117,678 78) (72,347 23) (696,139 81) 13,676 22 23,535 14 71,378 83 657,958 19 462,096 59 84,454 39 138,053 38
Cash Balance 2,250,238 48 2,226,536 78 2,072,975 61 1,955,296 83 1,882,949 60 1,186,809 79 1,200,486 01 1,224,021 15 1,295,399 98 1,953,358 17 2,415,454 76 2,499,909 15
■ i 1111106111111 i i i i i i 11. i i i i i i 11111 j... i
Cash Flows
Actual Actual Actual Actual Actual Actual Actual Actual Actual
Water Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
REVENUE
Operating Revenue
Water Sales 70,166 50 63,746 74 59,507.64 63,349 23 82,645.50 115,686 70 169,861 67 260,607 86 201,039 70 269,872 00 157,196.00 103,516 00 1,617,195 54
Total Operating Revenue 70,166 50 63,746 74 59,507.64 63,349 23 82,645 50 115,686 70 169,861 67 260,607.86 201,039 70 269,872 00 157,196.00 103,516 00 1,617,195 54
Other Operating Revenue -
Interest/Dividend Income 1,054 79 3,422 73 2,574.05 2,824 54 7,997 74 4,155 54 18,115.69 4,966 46 500 00 1,000.00 1,000.00 47,611 54
Customer Penalties 556.47 1,016 29 995 20 543.56 792.86 1,027.05 989 14 1,830.79 3,419 39 800 00 800.00 800.00 13,570 75
Connection Fees 97,430.00 47,940 00 36,345 00 96,437.50 141,951.20 70,521.00 51,473 00 50,046.50 74,557 79 28,000.00 28,000.00 28,000 00 750,701.99
Misc Revenue (61.78) (61.78)
Total Other Revenue 97,986.47 50,011.08 40,762 93 99,555.11 145,568.60 79,484 01 56,617 68 69,992.98 82,943 64 29,300 00 29,800.00 29,800 00 811,822 50
Total Revenue 168,152.97 113,757.82 100,270 57 162,904 34 228,214.10 195,170.71 226,479 35 330,600.84 283,983 34 299,172.00 186,996.00 133,316 00 2,429,018.04
EXPENSES -
Production Expense 1,242 18 2,219.04 1,013 04 1,460 62 1,278.36 1,237.00 13,745 95 4,112.16 804 75 800.00 800.00 800.00 29,513.10
Pumping Expense 14,514 36 21,860.91 26,259 66 36,652 07 30,563.23 28,419.88 15,400.32 32,811.09 23,362 88 21,000.00 21,000.00 21,000.00 292,844.40
Distribution Expense 12,559 12 12,983.87 18,137.84 15,241.71 13,433.38 15,142 61 14,534 79 15,562 76 12,173.90 9,000.00 12,000 00 20,000 00 170,769 98
Depreciation 50,000 00 60,000 00 60,000 00 60,000 00 60,000.00 60,000 00 60,000 00 60,000 00 60,000 00 60,000.00 60,000.00 60,000.00 710,000 00
Interest Expense 9,865 33 55,629.97 9,865.33 9,865 33 9,865.33 14,524 00 14,524 00 14,524.00 14,524 00 9,865 33 9,865 33 9,865 33 182,783 28
Other Operating Expense 537 76 483.00 461.00 461.00 461.00 461.00 461 00 994.40 994 40 500.00 500 00 500.00 6,814 56
Customer Accounts Expense 1,423.55 149.07 286 62 2,478 64 53.00 603.27 622.67 642 30 642.30 400.00 7,000 00 400 00 14,701 42
Administrative&General Expense 40,932 71 36,723 70 23,051 45 36,138 52 68,839.36 40,954.33 31,147.68 32,271.89 32,271.89 23,000 00 23,000 00 23,000 00 411,331 53
Total Expenses 131,075 01 190,049 56 139,074 94 162,297.89 184,493.66 161,342.09 150,436.41 160,918.60 144,774.12 124,565 33 134,165 33 135,565 33 1,818,758 27
Operating Transfer 20,000.00 20,000 00
TOTAL REVENUES 168,152.97 113,757.82 100,270 57 162,904 34 228,214.10 195,170 71 226,479.35 330,600 84 283,983 34 299,172 00 186,996.00 133,316.00 2,429,018.04
TOTAL EXPENSES 131,075 01 190,049 56 139,074 94 162,297 89 184,493 66 161,342 09 150,436.41 160,918 60 144,774 12 124,565 33 134,165 33 135,565.33 1,818,758 27
NET INCOME PROFIT(LOSS) 37,077.96 (96,291 74) (38,804 37) 606.45 43,720 44 33,828 62 76,042.94 169,682 24 139,209 22 174,606.67 52,830.67 (2,249.33) 590,259.77
Other Cash Items -
Depreciation 50,000.00 60,000.00 60,000 00 60,000 00 60,000.00 60,000 00 60,000.00 60,000 00 60,000 00 60,000 00 60,000.00 60,000.00 710,000 00
Accrued Interest 9,865 33 (88,787 71) 9,865 33 9,865 33 9,865.33 14,524 00 14,524.00 (111,001 01) 14,524.00 9,865 33 9,865.33 9,865.33 (87,159.41)
Payroll Liabilities (13,106.25) (14,442 88) (23,785 80) (13,159 58) (24,972 94) (15,572.12) (15,035.66) (6,076 94) (13,901 21) (13,000 00) (13,000 00) (13,000 00) (179,053 37)
Accounts Payable (29,062.20) (27,006 00) (8,638 25) (28,000.00) (12,521.74) 27,778.43 27,834 13 (108,774.53) (8,001.25) (48,000 00) (48,000.00) (262,391.41)
Capitalized Items (20,412.00) (10,143 00) (52,536.49) (86,598.46) (4,000.00) (42,755 04) (7,000 00) (7,000 00) (5,000 00) (235,444 99)
LTD&Bond Principal (441,256 96) (441,256 96)
Accounts Receivable (71,773 11) 188,995.72 (19,069 92) (97,950 35) 75,507.37 (29,129 86) (73,665.74) (90,014.09) 77,791 28 79,167 70 42,676.00 33,680 00 116,215 00
Inventory Purchases (1,200 00) (19,308.28) (25,221 50) (14,458.94) (19,682 05) (3,925.81) (1,958.87) 3,483 87 4,102.95 (5,000.00) (5,000 00) (5,000.00) (93,168 63)
Change in Cash Balances (38,610 27) (448,240 85) (45,654.51) (55,097 09) 63,901 66 (39,395 37) 83,685 10 11,153.16 172,951 71 290,638 45 92,372 00 30,296 00 118,000 00
Cash Balance 1,700,828 39 1,252,587 54 1,206,933 03 1,151,835 95 1,215,737 61 1,176,342 24 1,260,027.34 1,271,180.50 1,444,132 21 1,734,770 66 1,827,142 66 1,857,438.66
CV