Loading...
ERMU Financials 10-11-2005 FINANCIAL INDEX 110 Aug-05 FINANCIALS PAGE I COMBINED BALANCE SHEET 1 IELECTRIC INCOME STATEMENT 2 I WATER INCOME STATEMENT 3 CASH FLOW BY MONTH 4 I GRAPH #1 ELECTRICAL PURCHASES 5 I 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 11 12 13 MDDETAILED WATER P & L WITH BUDGET INFORMATION 14 15 I 16 DETAILED CASH FLOW ELECTRIC 17 IDETAILED CASH FLOW WATER 18 COMBINED BALANCE SHEETS 116 Aug-05 I ASSETS ELECTRIC WATER CURRENT ASSETS CASH &TEMPORARY INVESTMENTS (26,977.23) 271,180.50 ACCOUNTS RECEIVABLE 2,016,944.95 502,179.00 I INVENTORIES 1,174,477.20 43,266.90 PREPAID ITEMS 26,294.39 6,092.52 CONSTRUCTION IN PROGRESS 74,913.97 467,570.30 TOTAL CURRENT ASSETS 3,265,653.28 1,290,289.22 IRESTRICTED ASSETS EMERGENCY RESERVE FUND 95,000.00 I CONSTRUCTION RESERVE FUND 1,155,998.38 1,000,000.00 TOTAL RESTRICTED ASSETS 1,250,998.38 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 DISTRIBUTION 20,899,784.00 17,176,596.72 I GENERAL 9,155,697.08 714,380.93 FIXED ASSETS(COST) 35,896,225.13 27,004,583.02 LESS ACCUMULATED DEPRECIATION (13,281,087.80) (4,991,545.84) I TOTAL FIXED ASSETS, NET 22,615,137.33 22,013,037.18 OTHER ASSETS 23,500.97 98,450.73 leTOTAL ASSETS 27,155,289.96 24,401,777.13 LIABILITIES AND FUND EQUITY I CURRENT LIABILITIES ACCOUNTS PAYABLE 1,217,060.29 101,124.27 SALARIES AND BENEFITS PAYABLE 191,449.75 50,664.81 DUE TO CITY 35,515.28 ' DUE TO OTHER FUNDS 195,170.11 6,118.08 BONDS PAYABLE-CURRENT PORTION 124,919.00 TOTAL CURRENT LIABILITIES 1,764,114.43 157,907.16 LONG TERM LIABILITIES I LFG PROJECT 2,444,537.53 DUE TO COUNTY 20,560.08 BONDS PAYABLE, LESS CURRENT PORTION 2,378,830.00 6,146,250.72 I TOTAL LONG TERM LIABILITIES 4,843,927.61 6,146,250.72 TOTAL LIABILITIES 6,608,042.04 6,304,157.88 I FUND EQUITY CONTRIBUTED CAPITAL RETAINED EARNINGS 20,547,247.92 18,097,619.25 I TOTAL FUND EQUITY 20,547,247.92 18,097,619.25 TOTAL LIABILITIES& FUND EQUITY 27,155,289.96 24,401,777.13 I IP I I 116 I I I IWV CO U) CO U) U) M O OO f` N N- N- U) 'N- M M co'O V co co (- co co ''I U) 0) O Q V V U) V r O co V C),(0 7',.-,U) .- O (O',CO 0 0 N- O,UJ, M U) U) 0 N O•N N- .-,a3,.-11) U) N U) 0) U) UD N- 0 0) N- N- N 'N N I 011(O.0) U)'0_I N- 'V 0 N- O (D 0 CO a s 0o'U) N- U) r OIV r` •I'' N V N (D N I�'7'(O (Ni NI 1'"O,'- N N NI 0 I C O CO 0 O N (D 'aD7/: '' MU),N- NI(p flap (0 NO'O N- N- U) ..:N I U) 0,N�'- '- .N,'� p M N O U) O M N r`,n IN- M O N- OO 'CO O a M N O N- 'O M OIM', I(O N O r` O M O .- M O co au U) O N M V 0 N i O'U) .- V I.� N 00 0 V 0 V CO c0 U)�� N 00 V N 0) 00 .- r sr u7 M O O CO O 00 Q N- aV O O .- O 10 0 '� I a M 0 V UD 0) N- O N- '�',.- W CO ',O N- .f V�O M N- O O M ' CO N'O au V VIS' O 00 UJ U) N O O O 0 CO N N V 00 O O O N N-• 1. N- V 0 M 0 O M V OO 0)'CO N- U) 0) 00 CO 0 V U) O 0 U) �_ U) V' O) O U) U) 'U) CO N- M .1 M R y U) 0 N O N M M N- U) U) (O U) U) CO 0 V 00 'N U) N U) N- O 00 M O O O O N U) M U) Cl I-- M M M U) V (O UO O CO co co'U) co U) N M 0)'e} U)O M'0) o O O U) Ti'V N- Ti- 0) M O C'I O,N N (D U) UO Mai 0) O O 'O (G O N (15'c,) M N C) .- CO N .- '- N v 0) N�U)M N N- '- N h- N.- 0) 0 O Q r co O li M co M co I W Q H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 OIO 010 0 O 0'0 0 0 0 0 0 O O 00 MO J 0 0 0 0 0 0 O O O O 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0:0 O O O OQ HN- N N O N (D O h0.N 1O'O,U) O I- VNU) OO (D O N O N N- O _M r` 7 N- N',F W O O) M r O N- O MO O'O OI O O 1M f• N O O N O N O M U) O O M ONO U) r O,r• O U) O O V ON'OOOON ,fes (� f�1N'O f�',O U).0, - 0 O V V I� VMF 0OCO',O O n 7, O U) N U) N O O NM U) r` �O r` f`IO O'U) � O',UO M N N- NU) U) N 0 (O V V (- - N- O .- O U) V a0 O U) O oo O O M O �- r (DN C O U)10 U)O m 7 O N Cl N U) .- N-'CO I O U),N N .-- (O CO .- . V CO�V 'Q O N 1- ,OI r s- U N I W .- M N- O M 7 ' OO O , U) O M CO(D N V N CO N- C7 M 0) O 0) .f 0) G O O N- co N o W Q 'U) N n V N- CO R U7 N- r O CO O t,M .- O (D C) M 0,N 0 00,7 N;.- O,M N- CO n .- 0) V h CO Cr) U) (,- 0) .1'(O,r;.f h,. N N- N N- 0) N- O OJN (O M,M'co co O. N W 0 N M CO CO N M .-10),N-,0 0.N- N- 0) co co U) V co O U) h O 0) co h 0) 0)'I 0) 10) I O O U) M co co U) ,- .- U) V MO N co N-, O V I N W,N,r` h O,Co co N- co O co co e{,(') O p i- 00 O N- (O (- N: R N N N O U) M O M'00 V OO .-'N N M ap (D M 10 C') (: III N O O N V O 7 'M N U) O N- U) W CO 0 UJ O 0 N. N NI N- O O co V O O O U) Q' M U) .- (NCO N- ..4.N.- M O 00 .- r ,- sr 0 V O V W �7 V Q 00 O O U). '- O O O IW U) U) O O n N 0 Cr) CO N (D U) et'CO O ICO N- N',O (O O,O 0,N. CO N N O CO 03'001 'O 'N- CO N,(O M N- U) 0 0 O N U) O'O,,N O e- '-,(O '- N- 7 0 0.U) U) .- N U)N - N CO I F U) 00 (o'N N N-. N'U) R_ �N C),V,(C .- V 00 V_ N R O OIG (C (O.0 CD;O U) IN U) N Cl) O O V O co.co U) N- I U);M,0 00 OIC O O N N- N N- 0'CO 0 N- U) O,� U) 'O U)• U) Leo,17) W co co f� 7 U) O'.- N '(O M U) �'OI� I- IO O 1� CO OD'.- O,U),O CO U)f� O f� N. 0'O N O N- 0) Q)0 �(D O V ��M N r 'O 010 (o'V a VI' 'O U) O N (- N, _R 0 ....- CO M N N v O (O UO U) U) N N (O IU) 0 V U) C Q V r (C 00 N - (D CDS U)1 N1 Q 1 I d O,I C' >a' m 0 7wF 177 '„c !Z' I a) w `N c c CtI wrl I r ' «. (0 a LI 1 o �''O' OII 1 0 (./.)-(15.! C S 1010-0.FO-' I ,oE” H . O,O I F' I N�m co, ' I 'co d -5-2 ( l, y 'LL 01 'O I m o0 e o o, Q!0, 'C' ti ) — , 'a @ 2U ao ocLL ' am c w 241o, O �I c j d U • C �I n a)' c 'xla)I 4)I' �'1 V,SI DIw. 2, JasILSC'o. �o• Iof of a): tX m 'U o Dm. Z O'> > O,m C f Nyi vNl�' p wIcI� rn— o , � o . ,> oN m� yNnv .w:>'- -,c,:-: ' 'a) vO.� ,�' >' 0 o,O:U,iZ''a) 1::c11.2.2-61'1� Oai ocd,„,(-)s3-11:91 tY;� w'w,0 O d;n O Qml�'U.�,U,( 2 ,- bL'IL1 Q' o_ , �i I a a) NnZ, U'x cCW w'WQ ?U 7m (n,�N � a, C'oZZlF-' Fc' CoowIWal Lo, I>~ W03 > aZz m0 ,c 01 l � _a xQ1w ,1 ; (Dl�.,oo o,y'LIO - E,N' '� JIQ ` 8iCm �Iaic d of 19. ,Q,Q•� I:2! rot'ffal ' dv. oO. a 111 _ �+I OI O' Inv �,ail�I� , ila' ,,,,,w; ,OI ' alOI_1'0,210'�Ico 0 (A'UaIF-'i- 0 7 I MI6 MN NM NS M IIIIII I Ell MI MI N = V IMO IIIIII 1111114011M MN WA R INCOME STATEMENT E R_M_ U Income Statement 2005 2005 2005 TOTAL 2004 2004 AUGUST YEAR TO DATE BUDGET AUGUST YEAR TO DATE Water REVENUE Operating Revenue Water Sales 260,607.86 885,571.84 1,443,534.00 201,649.15 794,166.56 Total Operating Revent. 260,607.86 885,571.84 1,443,534.00 201,649.15 794,166.56 Other Operating Revenue Interest/Dividend Income 18,115.69 40,145.08 15,000.00 - _ 4,000.00 Customer Penalties 1,830.79 7,751.36 7,800.00 1,018.99 5,804.80 Connection Fees 50,046.50 592,144.20 471,200.00 59,431.30 635,828.89 Misc Revenue (61.78) - Total Other Revenue 69,992.98 639,978.86 494,000.00 60,450.29 645,633.69 REVENUE TOTAL 330,600.84 1,525,550.70 1,937,534.00 262,099.44 1,439,800.25 EXPENSES Production Expense - - - 4,112.16 26,308.35 10,00.0.00 2,237.82 9,084.11 Pumping Expense 32,811.09 216,992.62 258,818.00 _ 18,552.60 163,240.04 Distribution Expense 15,562.76 118,036.29 165,043.00 11,401.83 114,475.22 Depreciation 60,000.00 470,000.00 600,000.00 15,500.00 125,500.00 Interest Expense_ 14,524.00 138,663.29 276,049.00 5,371.36 42,970.88 Other Operating Expense 994.40 4,320.16 10,092.00 785.42 6,233.11 Customer Accounts Expense 642.30 6,259.12 18,101.00 843.61 8,716.82 Administrative & General Expense 32,271.89 314,100.89 280,134.00 22,226.92 183,714.89 Total Expenses (before Operating Transfers) 160,918.60 1,294,680.72 1,618,237.00 76,919.56 653,935.07 TOTAL REVENUES 330,600.84 1,525,550.70 1,937,534.00 262,099.44 1,439,800.25 TOTAL EXPENSES 160,918.60 1,294,680.72 1,618,237.00 76,919.56 653,935.07 OPERATING TRANSFER - 20,000.00 30,868.00 - 27,708.00 NET INCOME PROFIT (LOSS) 169,682.24 210,869.98 288,429.00 185,179.88 758,157.18 :Al 11111 11111.11IIII MI MN IIIIII _ ., -,,,, . _. .... ,...., -, -, - ir. Mill 2005 CASH FLOWS BY MONTH WIT PARISONS TO YEAR END 2004 I I Dec-04 Jan-05 Feb-05 I Mar-05 Apr-05 I May-05 Jun-05 f Jul-05 Aug-05 Sep-05 1 Oct-05 Nov-05 Dec-05 - - ELECTRIC j b 1 t TEMPORARY CASH INVESTMENTS� 61-0001-1361 TEMP CASH/SAVINGS, 219,831 00 219,831 00 134,22946 134,229 46 1 - 134,22946 134,229461 95,03319 111,54811 70,06948__ 61-0001-1312 CHECKING 860,716 62 739,099 33 790,999 17 6.27,438 00 498,619 83 415,653 514 (251.2 90 0) L266,010 77) (97,446 711 -I- 61-0001-1311 61-0001-1311 PETTY CASH 400 00 400 00 400 00 400 00 400 00 400 00 400 00 400 00 400 00 TOTAL 1,080,947 62 959,330 33 925,628 63 762,067 46 633,249 29 550,282 97 (155,856 84) (154,062 66) (26,977 23) - - - RESTRICTED FUNDS/OR DESIGNATED 61-0001-1271 CONST RESERVE 1,185,90815 1,195,90815 1,205,90815 I 1,215,90815 I 1,227,04754, 1,237,66663 I 1,247,66663 1 1,259,54867 1,155,99838 I _61-0001-1282 BOND EMERG RESER\., 95,000 00 95,000 00' 95,000 00 1 95,000 00, 95,000 00 I 95,000 00 95,000 00 95,000 00 I 95,000 00 1 1,280,908 15 1,290,908 15' 1,300,908 15 1 1,310,908 15 1.322,047 54 1,332,66663 1,342,66663 1,354,548 67 1,250,998381 y TOTAL 2,361,855 77 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, - - - INCREASE/DECREASE PER MONTH L I (111,61729)1 (135,318 99)1 (288,86016) (106,55894)_ (178,906 17) (1,175,01598) (1,161,369 75) (1,137,834 62)1 I FROM YR END 04 I I • L 1WATER _- --- - --- -- --�--- - --- TEMPORARY CASH&INVESTMENTS j 62-0001-1312 CHECKING (818.690 00) (150,900 27) (169,565 91) (614,216 61) (481,864 10) ,I :L9,3_5 4,93557)1 295,37507 368,43282 241,16012 1 - 62-0001-1211 SAVINGS _ 1,641,970 83 891,970 83 373,115 62 978,829 35 780,999 96 777,973 09 I - 30,0.20 38 62-0001-1212 CHECKING - 33,600 00 112,880 00 - - - - - 11 TOTAL 823,280 83 774,670 56 316,429 71 , 364,612 74 299,135 86 353,037 52 295,375 07 368,432 82 I 271,180 50 - - - - I I RESTRICTED FUNDS/OR DESIGNATED - - 62-0001-1271 CONST RESERVE 916,157 83 926,157 83 936,157 83• 842,320 29 852,700 09 862,700 09 880,967 17 891,594 52 1,000,000 00 I I I � TOTAL, 1,73943866 1,700,82839 1,252,58754 1,206,933 03 1,151,83595 1,215.73761 1,176,34224 1,260,02734 1,271,18050 - - - - INCREASE/DECREASE PER MONTH_ H _ FROM (38,610 (486,851 - - YR END 2004 -1I27 486,851 12 _ ) ( ) (532,50563) (587,60271), (523,70105) (563,09642); (Q9,11132)� (468,25816)1 F- I lam ELk River Municipal Utilities Monthly Electrical IDemand I 50 = 35M1 r .. t it 0"1s *, .n.yz .. ,,,.. 09 E 30Y. I m 25 ' r 20 ��Jlb. �`Ja6 ���6r PQM\ �a� ,��e �\� J��S'�,1/46c% 069 G�oo6c ����C ���PC I 40 P e9 ‘.o o o, �� co � o IMonths II Elk River Municipal Utilities Monthly p t y Energy IPurchases 22,000 121,000 �. . a 20,000 ti.F it C 19,000 - t„ r IH 18,000 . 17,000 UM • 16,000 .rte * r. ,r . : • 0. >. 15,000 +6 . �.r,t • fit'* m 14,000 # W V'4' C 13,000 S' ` * "` I 12,000 , , , ,a�J�c1 o�`Jac1 ���er PQM\ �. \ ,J�e ��\� P,0 tiecc• OGN0 �ecc• ae�vec u coeQ �o Oe ' Month I 1411 Elk River Municipal Utilities Monthly Total Electric Load I22,000 20,000 18,000 2 2005 . # c I -0 16,000 o r * s 14,000 „ .. .„ r ' . I m 12,0000' "' " w fj 10,000I ", 8,000 , II ,�„. e�`Jac1 4,,k PQM\ �a� ,Jce ,0 ..0 °�,o°c / / / Month I Elk River Municipal Utilities Monthly Electric Sales 111/ $1,800,000 , II $1,600,000 $1,400,000 - - - - • # w • w. i e $1,200,000as # • r 44. ...444 p° $1,000,000 . .� • ” ~ .- y W CNF • - I .N $800,000 - d N $600,000 W ,. ..: I $400,000 $200,000 ' 2004 ' $0 r 1 , ��.§" �,e' 6 PQM\ �a� )J�e �J�� ,e) eeec OG eeec eeec e P Q'` p °� e° ' Month 5e I I 111111 ELk River Municipal Utilities Monthly Residential, Commerical & Industrial Loads I 12,000 ;�, k"' ,�' f'Y '-7--,2,:ir' :u I 10,000 ‘.:' .« Xzf""'-',-,�. ;,v:,.: „• '. , 'tet'; ,.Y�.,�;,ryt `� 4 Y�t+r ' r±...i.;'�$"'=r��'S�'i i y.F s _ ...7 l'.-',:'10,01110111111".!,.:'„:‘,%...",,;A,%02', ti;v}C �"'M.x '..t:}j^-*,4., ,y,K: `� ;: 'k 'YF `i,_':A 8,000 ���+ ,. ,! " _ 6,000 • ,►. '++.',,ry .ut h '''' , '.x'•• '''' ;" '+ ''k• 3 4,000 ..' ; ' "._�: .;1 -,i .'.'-' '';,.:.1-- ., •, - ,••::'‘'.,, ,• t•-:: 'V' 2,000 \ ".---',• ., : -\", �,' ,, .�4 �. "6:'„r•�; x f.�.,.nwx';� y�y * aM' Mf'.� rt: . cr \Ma� ,Jce ,� ��S� �& � r� �6I �.g' K.P �e� � • F� PQ � 'e� Go � e ��9'` O ‘49O�a I Month 110 Elk River Municipal Utilities Monthly Residential, Commerical & Industrial Sales $900,000 $800,000 , . k: s 2.. : Ri ,; ' ,,: 'e'Kr. ri.... ,,_:.' :;'4"y • ?; 'X- - - • r gh,Vi�s'-n ' Z'`-, . .:.''"4 ' ite. _ i- 'D rt cc, 7$700,00 .� , . .r I ^r `> ; , y;.,;1. 0y•w, �`:-e: +; , ,—` $600,000 _ +T: ;s ^r ;� ,,�•;•, 4" ' , : _' ,•� .m • • .° $500,000 . :- •' -•d; - ' ' • , ,.. • ,p • d ^, Y 3 3i „fit n• 1i•- .: :•i: - , ,• ,--, «u�:.h `° $300,000 .' - -,,--.,•,,,,,,,.;,,,,.-,,%•,;_--- • •.,, .• ., ,' t•. I $200,000 ,. _,' -:n` -'. •r4--,: - ----*--"',•--7-----41,3': z ,. '".-: xrw,. $100,000 •� , • . .'�' `�"`� iJai �� �`G'c PQM\ �aA ,Joy A°�� .oe� �opm .oe� .p�c Sao Fe40° 4 V- eQNOF Oc' o eco` b�� _ . . O Month I i'I I 111, Elk River Municipal Utilities Monthly Water Pumpage I 140 120 CO• 100 o * 4* ` a •- e 80 f 4l . , 7,• 60 MKS ea `rf 'k a 40 f • . . • • • w. r a• 20 = 0 I o°�� `J�c1 ac�r PQM\ vat v§4 J�JS� cc'Oec �o�e cc`oec ccxec �a dee �` Q' eQ�e 06 owe e�'e I g � O Month I Elk River Municipal Utilities Peak Day Pumpage ID 6 5 # ♦‘ To i C9 # .: , ',4 ' j ,� , I o +► + +. 3 j 11. . I to o Y 2 av 4,U4• • . • - 0 - b 1 I . ar c\ `°� �e J\ Jyt oe` oe oe` oe` 1 ,�c�a (,z, �.a` QQ �° QUA eQtieF o°moo o eF ��F g � O Month I 1 I' I 8. I 111) Elk River Municipal Utilities Monthly Water Sales I 140 I 120 el 100 - - t • C7 r 114 0 80 1► I At h m °. m 40 N. . . • in .. • f • ,wl 1 20 2006 e" 0 I I , , , 1 I I I � �(.N f' <46° oc# 4.ecor P9 4\ �J�e �J�� P,0 ,1/4e no a',o�ec �e��ec Ge�.�ec coeQ O N-o Oe I Month 1111/ Elk River Municipal Utilities Monthly Water Sales I $300,000 -- $250,000 1 e $200,000 ,,,, , I 75 o $150,000 . fA y $100,000 + t ' w *I ott 46 0 $50,000 \ 2005 71184 I $0 �a�J0 e'°cJeb6 ��cGr PcP 40 �J�e ,J\ J�Jy� e�oec OG�o4k �e�,oec oe��ec 111 P 5eQ` \o Month 1 11 i 9 111.1017011111:15 dinMa M Mit I_ARVERINIU111PAT,TIL S- - MI - 1111111 dilli 1 o1 Fiscal Year 2005 Budget Fiscal Yer 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 679,064.95 3,600,402.17 72.85% 411,857.00 4,942,279.00 1,341,876.83 3,037,537.37 4,526,546.96 61-0440-4412 ELECT SALES/ER NON-DEMAND 140,174.58 1,063,590.44 75.57% 117,280.00 1,407,359.00 343,768.56 861,508 76 1,275,229.51 61-0440-4413 ELECT SALES/ER DEMAND 641,348 21 3,706,533.21 61.33% 503,650.00 6,043,797 00 2,337,263.79 3,747,221.31 5,648,048.79 61-0440-4414 ELECT SALES/ELK RIVER SEC LTS 2,217.97 17,985.69 66.41 % 2,257.00 27,082.00 9,096.31 17,614 00 26,694.39 61-0440-4415 ELECT SALES/ER CITY DONATED 16,308.85 100,389 73 92.87% 9,008.00 108,102.00 7,712.27 72,068.43 120,687.44 61-0440-4416 ELECT SALES/OTSEGO RES 87,767.61 476,109.82 69.54% 57,058.00 684,696.00 208,586.18 430,107 31 633,900.55 61-0440-4417 ELECT SALES/OTSEGO NON-DEMAND 22,746 40 109,531.20 74.92% 12,182.00 146,188.00 36,656.80 92,449.36 141,065.14 61-0440-4418 ELECT SALES/OTSEGO DEMAND 20,104.84 95,949.39 73.81 % 10,833.00 130,000.00 34,050.61 70,467.55 133,175.77 61-0440-4419 ELECT SALES/OTSEGO SEC LTS 727.40 5,744 36 63.15% 758.00 9,097.00 3,352.64 (2,082.67) 804.61 61-0440-4421 ELECT SALES/BIG LAKE RES 26,784.77 141,461.96 59.01 % 19,978.00 239,741.00 98,279.04 131,654.04 194,656.99 61-0440-4422 ELECT SALES/BL NON-DEMAND 870 13 4,241.33 81.30% 435 00 5,217.00 975.67 3,477.69 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,123.10 63 31 % 148.00 1,774 00 650.90 1,154.40 1,731.60 61-0440-4431 ELECT SALES/DAYTON RES 17,227.83 92,947.68 73.28% 10,569.00 126,831.00 33,883.32 84,553.81 123,160.31 61-0440-4432 ELECT SALES/DAYTON NON-DEMAND 1,894.91 11,712.15 70.56% 1,383.00 16,600.00 4,887.85 11,736.64 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 2,858.90 68.39% 348.00 4,180.00 1,321.10 2,515.10 3,590.15 61-0440-4441 PUBLIC ST&HWY LIGHTING/CITY 14,597.77 117,189.64 67.09% 14,556.00 174,678.00 57,488.36 113,612.45 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 4,797.48 79.96% 500.00 6,000.00 1,202.52 3,921.73 7,464.81 61-0440-4551 GENERATION CREDIT 28,666.00 229,328.00 66.67% 28,666.00 343,992.00 114,664.00 228,954.00 285,794.82 61-0440-4552 DISPERSED GENERATION CREDIT (10,175.00) (24,537.50) 34 47% (5,931.00) (71,176.00) (46,638 50) (47,451 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,691,214 09 9,757,419.76 67 00% 1,213,535 00 14,562,437 00 4,805,017 24 8,861,379 88 13,255,912 19 INTEREST INCOME 61-0460-4691 INTEREST&DIVIDEND INCOME 662.03 12,314.79 246.30% 417.00 5,000 00 (7,314 79) 37,585.41 25,703.79 TOTAL INTEREST INCOME 662 03 12,314 79 246 30% 417 00 5,000 00 (7,314 79) 37,585 41 25,703 79 OTHER OPERATING REVE 61-0470-4700 SECURITY REVENUE 11,996.04 85,707.42 203.65% 3,507.00 42,085.00 (43,622.42) 23,719.12 38,719.93 61-0470-4701 CUSTOMER DELINQUENT PENALTIES 16,331.22 91,996 03 79.85% 9,601.00 115,212.00 23,215.97 87,746.91 118,910.23 61-0470-4702 DISCONNECT&RECONNECT CHARGE 64,184.96 359,304.66 102.66% 29,167.00 350,000 00 (9,304 66) 294,640.47 574,156 05 61-0470-4703 MISC ELEC REVENUE-TEMP CHG 1,100.00 3,300.00 165.00% 167.00 2,000.00 (1,300.00) 800.00 1,200.00 61-0470-4704 STREET LIGHT 9,600.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 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0 00 61-0470-4715 NON-UTILITY OPERATIONS 0.00 389.60 15.58% 208.00 2,500.00 2,110.40 0.00 0.00 61-0470-4721 LFG PROJECT 59,508.56 472,277.88 67.47% 58,333.00 700,000.00 227,722.12 467,277.69 701,371.49 61-0470-4722 MISC NON-UTILITY 2,506 39 52,741.58 90.93% 4,833.00 58,000.00 5,258.42 16,834.01 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 (95.11) 450 95 90.19% 42.00 500.00 49.05 (206.44) (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 165,132.06 1,090,757.33 84 54% 107,525 00 1,290,297 00 199,539 67 910,261 76 1,518,732 60 TOTAL ELECTRIC 1,857,008 18 10,860,491.88 68 49% 1,321,477 00 15,857,734 00 4,997,242.12 9,809,227 05 14,800,348.58 0 IIIIIId 0111,111111111:15 Mill M E SLI VEM!UIPA�TIL S.. all 111112 o Fiscal Year 200 Budget Fiscal W 2004 Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total Revenue (Continued) TOTAL Revenue 1,857,008.18 10,860,491.88 68.49% 1,321,477.00 15,857,734.00 4,997,242.12 9,809,227.05 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,580.73 24,884.11 58.30% 3,557.00 42,680.00 17,795 89 27,086.73 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 0.00 0.00 0.00% 1,250.00 15,000 00 15,000.00 0 00 778 31 61-0540-5472 NATURAL GAS 262.90 10,556.68 277.81 % 317.00 3,800.00 (6,756.68) 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,653.66 19,987.35 66.58% 2,502.00 30,020.00 10,032.65 16,948.40 29,056.21 61-0540-5484 OTHER EXP/PLANT SUPPLIES-ETC 1,341.67 14,029.51 56.12% 2,083.00 25,000.00 10,970.49 20,708.50 29,374.69 61-0540-5491 MISC OTHER PWR GENERATION EXP 62 26 3,754.39 34.76% 900.00 10,800.00 7,045 61 7,431.10 11,715.41 61-0540-5521 MAINTENANCE OF STRUCTURE/PLANT 1,586.00 12,565.42 70.20% 1,492.00 17,900.00 5,334.58 10,177.33 19,940.33 61-0540-5531 MTCE OF ENGINES/GENERATORS-PL 104.00 16,129.94 35.84% 3,750 00 45,000.00 28,870.06 12,833 04 17,758.84 61-0540-5541 MTCE OF PLANT/LAND IMPROVEMENT 131.40 1,969.46 49.24% 333.00 4,000.00 2,030.54 2,201.35 3,823.91 61-0540-5551 PURCHASED POWER 1,221,360.88 6,822,969.50 71.72% 792,730.00 9,512,763.00 2,689,793.50 6,064,090.07 8,563,297.85 61-0540-5552 OTHER PURCHASED POWER 8,553 29 68,268.17 76.70% 7,417.00 89,009.00 20,740.83 64,972.60 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 1,239,636 79 6,995,120 65 71 24% 818,213 00 9,818,557 00 2,823,436 35 6,230,085 30 8,863,561.13 LANDFILL GAS 61-0550-5051 LANDFILL GAS EXP 19,836.00 159,180.50 61.70% 21,500.00 258,000.00 98,819.50 136,903.13 219,178.10 61-0550-5052 LFG ADMIN 38.16 3,996.81 65.52% 508.00 6,100.00 2,103.19 5,055 88 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 19,874 16 178,257.31 63 39% 23,433 00 281,200 00 102,942 69 158,779 01 241,362 66 DISTRIBUTION EXPENSE 61-0580-5801 REMOVE EXISTING SERV&METERS 29.41 1,561.48 260.25% 50.00 600.00 (961.48) 368.62 1,349.56 61-0580-5831 TRANSFORMER EX/OVERHD&UNDER( 3,220 07 8,973.64 112.17% 667.00 8,000.00 (973.64) 4,921 16 9,448.54 61-0580-5851 MTCE OF SIGNAL SYSTEMS 0.00 315.81 10.53% 250.00 3,000.00 2,684.19 1,136.16 1,902.66 61-0580-5861 METER EXP-REMOVE&RESET 875.97 8,985.05 22.46% 3,333.00 40,000.00 31,014.95 7,078.23 10,330.32 61-0580-5871 TEMP SERVICE-INSTALL&REMOVE 465.42 3,726.63 69.01 % 450.00 5,400.00 1,673.37 2,332.91 2,733.72 61-0580-5881 MISC DISTRIBUTION EXPENSE 22,238.89 91,186 42 70 14% 10,833.00 130,000.00 38,813.58 102,908.95 124,700.00 TOTAL DISTRIBUTION EXPENSE 26,829.76 114,749.03 61.36% 15,583 00 187,000.00 72,250.97 118,746 03 150,464.80 MAINTENANCE EXPENSE 61-0590-5911 MTCE OF STRUCTURES 0.00 251.20 15.70% 133.00 1,600.00 1,348.80 206.34 240.88 61-0590-5921 MTCE OF SUBSTATIONS 1,957.32 18,781.40 72.24% 2,167.00 26,000 00 7,218.60 18,922.12 25,534.28 61-0590-5922 MTCE OF SUBSTATION EQUIPMENT 0.00 1,157.91 34.06% 283.00 3,400.00 2,242.09 115.36 894.28 61-0590-5931 MTCE OF OVERHD LINES/TREE TRIM 3,987.33 91,140.87 91.14% 8,333.00 100,000 00 8,859.13 131,249.94 174,707.81 61-0590-5932 MTCE OF OVERHD LINES/STANDBY 2,016.84 22,006.82 84.40% 2,173.00 26,074.00 4,067.18 16,794.93 25,593 05 61-0590-5933 MTCE OF OVERHEAD 4,426.68 35,992.36 64.27% 4,667.00 56,000.00 20,007.64 19,477.34 33,595.00 61-0590-5941 MTCE OF UNDERGROUND/DISTRIB 18,726.00 70,880.08 109.89% 5,375.00 64,500.00 (6,380.08) 58,374.65 104,193.36 61-0590-5951 MTCE OF LINE TRANSFORMERS 1,361.17 10,683.19 66.77% 1,333.00 16,000.00 5,316.81 5,738.54 7,498 60 61-0590-5961 MTCE OF STREET LIGHTING 4,588.40 18,934.53 58 62% 2,692.00 32,300.00 13,365.47 21,482.44 37,804.69 111111d Oc .1111:15 Mill 11111 11.11 MitAIRIVER1111U PAIFIRTILLS Ili3 oi' Fiscal Year 20034.' 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 (130.40) 2,254.90 39.59% 475.00 5,695 00 3,440.10 3,452.83 6,426.97 61-0590-5971 MTCE OF METERS 5,917.25 42,250.10 99.41 % 3,542.00 42,500.00 249.90 36,502 40 48,469.36 61-0590-5972 VOLTAGE COMPLAINTS 588.58 3,734.28 74.84% 416.00 4,990 00 1,255.72 3,439.98 6,179.63 61-0590-5981 SALARIES/TRANS&DISTRIBUTION 1,871.93 12,882 56 56.04% 1,916.00 22,990.00 10,107.44 15,327.09 21,981 73 61-0590-5991 MTCE OF OVERHEAD SERVICE/2NDRY 142.24 4,061.51 21.95% 1,542.00 18,500.00 14,438.49 7,858.18 13,146.74 61-0590-5992 MTCE OF UNDERGROUND ELEC SERV 5,579.27 31,513.52 74.85% 3,508.00 42,100.00 10,586.48 22,773.71 38,351 38 61-0590-5995 TRANSPORTATION EXPENSE 3,146.88 63,212.56 43.57% 12,090.00 145,077.00 81,864.44 82,853.94 119,803.00 TOTAL MAINTENANCE EXPENSE 54,179 49 429,737.79 70 71 % 50,645.00 607,726 00 177,988.21 444,569 79 664,420.76 DEPRECIATION/ELECTRI 61-0595-8031 DEPRECIATION/ELECTRIC 118,000 00 920,000.00 81.42% 94,167.00 1,130,000 00 210,000 00 573,125.00 1,427,091.00 TOTAL DEPRECIATION/ELECTRI 118,000 00 920,000.00 81 42% 94,167.00 1,130,000.00 210,000 00 573,125 00 1,427,091 00 INTEREST EXPENSE 61-0596-8071 INTEREST ON BONDS/LONG TERM 4,588.00 71,850 89 65.60% 9,127.00 109,522.00 37,671.11 2,810.64 87,544.63 TOTAL INTEREST EXPENSE 4,588.00 71,850 89 65 60% 9,127 00 109,522 00 37,671 11 2,810 64 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 EXPENSE-NON-UTILITY OPERATIONS 11,906.57 92,672.44 617.82% 1,250.00 15,000.00 (77,672.44) 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,854.12 220,688.22 74.81 % 24,583.00 295,000 00 74,311.78 187,077.53 294,698.18 61-0597-8262 TRANSFER TO CITY 3%ER REVENUE 30,000 00 240,000.00 64.54% 30,988.00 371,857.00 131,857.00 140,000.00 340,564.28 61-0597-8263 OTHER DONATIONS 160.58 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 80.00 60 61 °A 11.00 132.00 52.00 75.84 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 72,931.27 558,771 92 79 94% 58,248 00 698,989 00 140,217 08 333,598 86 673,539 63 CUSTOMER ACCOUNTS EX 61-0900-9021 METER READING EXPENSE 5,319.58 56,676.28 97.72% 4,833 00 58,000.00 1,323.72 36,894 29 61,445.70 61-0900-9030 COLLECTING EXP DISC/RECONNECT 2,002.72 11,018.67 45.91 % 2,000.00 24,000.00 12,981.33 15,619.40 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 (933.70) (277.53) -1 16% 2,000.00 24,000.00 24,277.53 5,042.09 14,350.85 61-0900-9061 OUST BLGS NOT PD/SENT FOR COLL (192 38) 20,012.85 100.06% 1,667.00 20,000.00 (12.85) 23,735.79 23,136.04 TOTAL CUSTOMER ACCOUNTS EX 6,196 22 88,033 80 69 87% 10,500 00 126,000.00 37,966 20 81,291.57 121,135 69 ADMINISTRATIVE &GEN 61-0920-9201 SALARIES/OFFICE&COMMISSION 17,864.11 175,079.09 54.71 % 26,667.00 320,000.00 144,920.91 200,367.00 293,406 22 61-0920-9211 OFFICE SUPPLIES&EXPENSE 3,279.11 60,491.72 100.82% 5,000.00 60,000.00 (491.72) 53,704.57 63,261.27 61-0920-9212 LT&WATER CONSUMPTION/OFFICE 2,214.00 6,910 54 135.50% 425.00 5,100.00 (1,810.54) 2,259.02 6,468.39 61-0920-9213 BANK CHARGES 586.68 4,867 97 83.38°A, 486.00 5,838.00 970.03 3,891.56 5,281.27 61-0920-9221 LEGAL FEES (46.00) 2,188.28 27.35% 667.00 8,000.00 5,811.72 2,530.48 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 Mild Oc .15 FINN Ilii M 1/111.L01111VEIIUIPAILINTILRS11/11 IIIII II. ill. 111.11 all 4 AIM Fiscal Year 2005 Budget Fiscal Y 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 559.81 70,864.15 59 15% 9,983.00 119,800.00 48,935.85 79,922.01 123,171.81 61-0920-9261 UTIL SH OF MEDICAUDENTAUDISA 17,286 36 135,493.34 69.31 % 16,292.00 195,500.00 60,006.66 116,460.76 165,072.24 61-0920-9262 UTILITY SHARE OF PERA 3,968.07 95,714.14 110.40% 7,225.00 86,700.00 (9,014.14) 55,844.37 83,018.53 61-0920-9263 UTILITY SHARE OF FICA 10,149.72 85,234.94 77.49% 9,167.00 110,000.00 24,765.06 80,621.03 109,136.19 61-0920-9264 EMPLOYEES SICK PAY 2,210.41 26,781.99 66.96% 3,333.00 40,000.00 13,218.01 33,543.91 49,281.05 61-0920-9266 EMP VACATION/HOLIDAY PAY 6,495.37 80,260.56 59.45% 11,250.00 135,000.00 54,739.44 113,213.31 186,939.39 61-0920-9268 MISCELLANEOUS 10.00 36,951.45 369.51 % 833.00 10,000.00 (26,951.45) 0.00 (0.58) 61-0920-9269 CONSERVATION IMP PROGRAM 12,729.15 118,689 66 81.29% 12,167.00 146,000.00 27,310.34 128,399.54 162,348.92 61-0920-9281 ENVIRONMENTAL COMPLIANCE 528.50 5,984.69 47.88% 1,042.00 12,500 00 6,515.31 8,419.71 14,601 54 61-0920-9291 CONSULTING FEES 8,843.39 29,149 99 97.17% 2,500.00 30,000.00 850.01 18,735 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 1,429.51 7,715.56 58.01 % 1,108.00 13,300.00 5,584.44 6,773.35 10,104.73 61-0920-9302 ADVERTISING 481.00 9,837.65 46.85% 1,750.00 21,000.00 11,162 35 11,166.57 16,460.74 61-0920-9303 DUES&SUBSCRIPTIONS-FEES 5,206.31 30,720.83 109.72% 2,333.00 28,000.00 (2,720.83) 19,335.00 22,699.20 61-0920-9304 TRAVEL EXPENSE 882.18 4,102.05 102.55% 333.00 4,000.00 (102.05) 957.95 957.95 61-0920-9305 SCHOOLS&MEETINGS 5,841.91 48,598.00 69.98% 5,788.00 69,450.00 20,852.00 52,200.38 73,069.90 61-0920-9306 MISC GENERAL EXPENSE 0.00 49.49 0 69% 600.00 7,200.00 7,150.51 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 100,519.59 1,046,878 38 72 53% 120,284.00 1,443,413.00 396,534 62 1,000,114 09 1,443,455 89 TOTAL ELECTRIC 1,642,755 28 10,403,399.77 72.23% 1,200,200 00 14,402,407.00 3,999,007.23 8,943,120 29 13,672,576 19 TOTAL Expense 1,642,755.28 10,403,399.77 72.23% 1,200,200.00 14,402,407.00 3,999,007.23 8,943,120.29 13,672,576.19 PROFIT/ (LOSS) : 214,252.90 457,092.11 121,277.00 1,455,327.00 998,234.89 866,106.76 1,127,772.39 Date Range: 8/1/2005 To 8/31/2005 Report is for 61-0001-1071 through 61-0999-9999. Active and Inactive accounts are included. Report order=Fund Transaction Source Code=Include All W MIL oc :42 AM NM M LF VE U PPIRTILPES� ail 1.11 111. 1.111 all 1 ono Fiscal Year 200 Budget Fiscal W2004 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 18,115.69 38,645.08 322.04% 1,000.00 12,000.00 (26,645.08) 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 18,115 69 40,145.08 267 63% 1,250 00 15,000 00 (25,145.08) 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 260,607.86 885,571.84 61.35% 120,294.00 1,443,534 00 557,962.16 794,166.56 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 260,607 86 885,571 84 61.35% 120,294 00 1,443,534 00 557,962.16 794,166.56 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 1,830.79 7,751.36 99.38% 650.00 7,800.00 48 64 5,804.80 7,897.45 62-0620-6401 WATER/ACCESS/CONNECTION FEES 42,477 50 546,585.00 129.77% 35,100.00 421,200.00 (125,385.00) 573,383.18 839,910.80 62-0620-6402 MISC CONNECTION FEES 7,569.00 45,559.20 91.12% 4,167.00 50,000.00 4,440.80 62,445.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 51,877 29 599,833 78 125.23% 39,917 00 479,000 00 (120,833 78) 641,633 69 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 330,600 84 1,525,550 70 78.74% 161,461.00 1,937,534 00 411,983.30 1,439,800 25 3,639,571 49 TOTAL Revenue 330,600.84 1,525,550.70 78.74% 161,461.00 1,937,534.00 411,983.30 1,439,800.25 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 4,112 16 26,308 35 263.08% 833.00 10,000.00 (16,308.35) 9,084.11 29,341.95 TOTAL WATER PRODUCTION EXP 4,112 16 26,308 35 263.08% 833.00 10,000 00 (16,308 35) 9,084.11 29,341.95 PUMPING EXPENSE 62-0710-7101 SUPERVISION 2,039.08 14,356.68 58.80% 2,035.00 24,418.00 10,061 32 15,285.14 22,662.26 62-0710-7181 SUPPLIES&EXPENSE 16,481.11 103,729.45 55.92% 15,458.00 185,500.00 81,770.55 100,496.74 174,078 63 62-0710-7201 MTCE OF ELECT PUMPING EQUIP 1,112.38 4,563.20 101.40% 375.00 4,500.00 (63 20) 1,846 57 4,149 39 62-0710-7220 MTCE OF WELLS 13,178.52 94,343.29 212.48% 3,700.00 44,400.00 (49,943.29) 45,611.59 81,336 83 r -d ocin :42 Inn IIIIIMI Mit LIMIPVERN1U f PILISTILzSIIIII 111111 RIM 11111 ail 0.2 ollill Fiscal Year 2005 Budget Fiscal Ye 2004 Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total Expense (Continued) WATER PUMPING EXPENSE TOTAL PUMPING EXPENSE 32,811 09 216,992.62 83.84% 21,568.00 258,818.00 41,825 38 163,240.04 282,227 11 WATER DISTRIBUTION E 62-0730-7301 MTCE OF WATER MAINS 2,473.50 8,148.78 42.89% 1,583.00 19,000.00 10,851.22 16,150.19 26,134.94 62-0730-7311 MTCE OF WATER SERVICES 3,234 77 24,672.82 49.35% 4,167.00 50,000.00 25,327.18 30,226.43 40,785.67 62-0730-7321 MTCE OF CUSTOMERS SERVICE 4,552.74 24,770.87 86.92% 2,375.00 28,500.00 3,729.13 24,017.09 36,009.03 62-0730-7331 MTCE OF WATER HYDRANTS 1,422.38 3,472.69 43.14% 671.00 8,050.00 4,577.31 6,256.57 9,382 31 62-0730-7341 MISC WATER EXPENSE/INVENTORY 90.24 716 63 46.23% 129.00 1,550.00 833.37 186.19 155 69 62-0730-7391 WAGES/WATER 815 63 5,742.66 44.86% 1,067.00 12,800.00 7,057 34 6,114.05 9,064.89 62-0730-7395 TRANSPORTATION EXPENSE 1,234.46 29,497.82 178.77% 1,375.00 16,500.00 (12,997.82) 11,359 95 20,938 35 62-0730-7399 GENERAL EXP/WATER PERMIT 5 10 5,116 10 85.27% 500.00 6,000.00 883.90 5,736.00 5,746.00 TOTAL WATER DISTRIBUTION E 13,828 82 102,138 37 71 73% 11,867.00 142,400.00 40,261.63 100,046 47 148,216.88 WATER ACCOUNTING EXP 62-0740-7431 METER READING EXPENSE 1,733.94 15,897.92 70.21 % 1,887.00 22,643.00 6,745.08 14,428.75 23,512.90 TOTAL WATER ACCOUNTING EXP 1,733 94 15,897.92 70.21 % 1,887.00 22,643.00 6,745.08 14,428 75 23,512 90 DEPRECIATION EXPENSE 62-0745-7451 DEPRECIATION-WATER 60,000.00 470,000.00 78.33% 50,000.00 600,000.00 130,000.00 125,500.00 720,044.00 TOTAL DEPRECIATION EXPENSE 60,000 00 470,000 00 78 33% 50,000.00 600,000 00 130,000.00 125,500 00 720,044 00 INTEREST EXPENSE 62-0748-7481 INTEREST ON BONDS/LONG TERM 14,524.00 138,663.29 50.23% 23,004.00 276,049.00 137,385.71 42,970.88 256,206.96 TOTAL INTEREST EXPENSE 14,524.00 138,663 29 50 23% 23,004.00 276,049 00 137,385.71 42,970 88 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 815.11 5,652.62 62-0750-7564 AMORTIZATION 1994 0.00 0.00 0.00% 0.00 0.00 0 00 1,253 44 12,225 48 62-0750-7565 AMORTIZATION 1997 0.00 98.76 5.34% 154.00 1,850.00 1,751.24 978.48 1,741.41 62-0750-7566 AMORTIZATION 1998 132.00 1,056.00 87.27% 101.00 1,210.00 154.00 771 76 1,163.17 62-0750-7567 AMORTIZATION 2001 329 00 2,632 00 73 83% 297.00 3,565.00 933.00 2,414.32 3,555 69 62-0750-7568 AMORTIZATION 2003 533.40 533.40 0.00% 0.00 0.00 (533.40) 0 00 1,708.00 TOTAL OTHER OPERATING EXPE 994 40 4,320 16 42 81 % 841 00 10,092.00 5,771 84 6,233 11 26,046 37 CUSTOMER ACCOUNTS EX 62-0900-9030 COLLECTING EXP DISC/RECONNECT 589 30 2,546.60 36.04% 589.00 7,066.00 4,519.40 4,710.62 6,554.91 62-0900-9051 MISC CUSTOMER ACCTS EXP-COMP 53.00 2,659.00 27.04% 820.00 9,835.00 7,176.00 4,006.20 9,744 93 62-0900-9061 OUST 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 642 30 6,259 12 34 58% 1,509 00 18,101.00 11,841 88 8,716 82 16,299 84 ADMINISTRATIVE & GEN 62-0920-9201 SALARIES/OFFICE&COMMISSION 6,069.71 54,488.21 218.04% 2,082.00 24,990.00 (29,498 21) 9,671 91 27,930.15 62-0920-9211 OFFICE SUPPLIES&EXPENSE 1,932.82 20,241.43 96.39% 1,750.00 21,000.00 758.57 17,366.54 22,825.94 62-0920-9212 LT&WATER CONSUMPTION/OFFICE 738.01 2,372.58 79.62% 248.00 2,980.00 607.42 752.99 2,156.09 62-0920-9213 BANK CHARGES 196.56 1,413.35 85.14% 138.00 1,660.00 246.65 1,101.62 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 r 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 v1 mid O :42 me um Ns lot LEITIvEirtiU%AJTI Fif,Esm am - ei3 AP Fiscal Year 2005 Budget Fiscal Ye 2004 Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total Expense (Continued) WATER ADMINISTRATIVE &GEN 62-0920-9241 INSURANCE 0.00 16,746 38 69 78% 2,000.00 24,000.00 7,253.62 16,913.99 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 MEDICAUDENTAUDISA 5,762.12 44,927.40 77.37% 4,839.00 58,068.00 13,140.60 38,712.33 54,026.88 62-0920-9262 UTILITY SHARE OF PERA 2,074.72 32,490.05 119.73% 2,261.00 27,136.00 (5,354.05) 18,614.75 27,672.84 62-0920-9263 UTILITY SHARE OF FICA 1,796.43 22,272.60 77.88% 2,383.00 28,600.00 6,327 40 27,421 62 36,926.66 62-0920-9264 EMPLOYEES SICK PAY 736.80 9,208 94 230.22% 333.00 4,000.00 (5,208.94) 3,284.51 7,470.61 62-0920-9267 EMP VACATION/HOLIDAY PAY 2,165.12 27,132.96 195.20% 1,158.00 13,900.00 (13,232.96) 11,363.54 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 800.00 2,114.96 17.62% 1,000.00 12,000.00 9,885.04 12,132.34 18,318.33 62-0920-9301 TELEPHONE 516.76 2,740.97 78.31 % 292.00 3,500.00 759.03 2,290.97 3,373.97 62-0920-9302 ADVERTISING 222.59 4,004.90 80.10% 417.00 5,000.00 995.10 3,929.86 5,613.17 62-0920-9303 DUES&SUBSCRIPTIONS-FEES 7,092.60 19,811.88 304.80% 542.00 6,500.00 (13,311.88) 6,212.51 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 2,167.65 16,712.80 113.31 % 1,229.00 14,750.00 (1,962.80) 9,833.73 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 32,271 89 314,100.89 112 13% 23,343 00 280,134 00 (33,966 89) 183,714 89 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 160,918.60 1,314,680 72 79.72% 137,424 00 1,649,105 00 334,424.28 681,643 07 1,842,116 86 TOTAL Expense 160,918.60 1,314,680.72 79.72% 137,424.00 1,649,105.00 334,424.28 681,643.07 1,842,116.86 PROFIT/ (LOSS) : 169,682.24 210,869.98 24,037.00 288,429.00 77,559.02 758,157.18 1,797,454.63 Date Range: 8/1/2005 To 8/31/2005 Report is for 62-0001-1071 through 62-0999-9999. Active and Inactive accounts are included. Report order= Transaction Source Code=Include All i - woe we - - M E M 11 IIIIII - NM M OM IIIIII MN 4. .... Cash Flows 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,552,167.00 1,636,277 00 1,105,354 00 1,118,130 00 14,842,570 14 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 14,500 00 14,500 00 14,500 00 14,500 00 175,189 64 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,374.72 29,374 72 29,374 72 29,374 72 351,624 36 Dispersed Generation Credit (1,937 50) (2,562 50) (9,862 50) (10,175 00) (24,537 50) Additional Revenue/CIP&Rate Increase - 1,138,393 63 1,063,854 77 970,823 82 1,063,142 22 979,864 32 1,237,240 27 1,612,886 64 1,691,214 09 1,596,041 72 1,680,151 72 1,149,228.72 1,162,004 72 15,344,846 64 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 100 00 100 00 200 00 200 00 12,914 79 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 9,000 00 9,000 00 9,000 00 9,000 00 127,996 03 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 77,608 35 81,813 85 55,267 70 55,906 50 742,874 28 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 29,000 00 29,000 00 29,000 00 29,000 00 475,304 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 25,000 00 15,000 00 20,000 00 25,000 00 252,365 66 154,125 84 138,339 49 129,087 41 149,384 22 140,127 69 125,873 66 100,526 62 165,794 09 140,708 35 134,913 85 113,467 70 119,106 50 1,611,455 42 1,292,519 47 1,202,194 26 1,099,911.23 1,212,526 44 1,119,992 01 1,363,113 93 1,713,413 26 1,857,008 18 1,736,750 07 1,815,065 57 1,262,696 42 1,281,111 22 16,956,302 06 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 1,303,437 00 785,135 00 621,277 00 618,635 00 10,219,760 08 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 18,000 00 18,000 00 18,000 00 18,000 00 182,679 16 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 19,836 00 19,836 00 19,836 00 19,836 00 257,601 31 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 15,000 00 15,000 00 15,000 00 15,000 00 174,749 03 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 50,000 00 45,000 00 41,000 00 40,000 00 604,417.15 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,461 67 4,461 67 4,461 67 4,461 67 89,697 57 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 20,000 00 10,000 00 15,000.00 20,000 00 160,728 51 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 55,000 00 55,000 00 55,000 00 55,000 00 683,043 41 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 11,000 00 11,000 00 11,000 00 11,000 00 138,623 82 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 125,000 00 125,000 00 125,000 00 125,000 00 1,543,139 63 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,739,734 67 1,206,432 67 1,043,574 67 1,044,932 67 15,446,439 67 TOTAL REVENUES 1,292,519 47 1,202,194 26 1,099,911.23 1,212,526 44 1,119,992 01 1,363,113 93 1,713,413 26 1,857,008.18 1,736,750 07 1,815,065 57 1,262,696 42 1,281,111 22 16,956,302 06 TOTAL EXPENSES 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,739,734 67 1,206,432 67 1,043,574 67 1,044,932 67 15,446,439 67 NET INCOME PROFIT(LOSS) 147,363 95 76,778 38 (16,053 97) 142,753 31 121,763 95 (294,016 33) 56,071 60 214,252.90 (2,984 60) 608,632 90 219,121 75 236,178 55 1,509,862 39 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,461 67 4,461 67 4,461 67 4,461 67 (3,199 10) 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) (70,000 00) (70,000 00) (70,000 00) (70,000 00) (852,389 80) Accounts Payable (224,976 67) (237,621 77) (241,560 88) (242,678.99) (305,700.32) (338,202 05) (384,356 27) (62,860 83) (325,000 00) (225,000 00) (225,000 00) (225,000 00) (3,037,957 78) Capitalized Items (14,107 20) (130,784 58) (226,489 78) (150,000 00) (20,000 00) (15,000 00) (10,000 00) (566,381.56) 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 643,068 80 577,290 00 789,923 00 251,224 00 3,844,710 05 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) (50,000 00) (70,000 00) (90,000 00) (110,000 00) (1,148,866 92) 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 157,136 04 912,974 74 721,096 59 184,454 39 837,827 14 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,381,157 19 2,294,131 93 3,015,228 52 3,199,682 91 ■ MIVP - M M - - M 3 - - .... - - - -4.... .... Cash Flows 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 176,886.00 269,872 00 157,196.00 103,516 00 1,593,041.84 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 176,886 00 269,872 00 157,196 00 103,516 00 1,593,041.84 Other Operating Revenue - InteresUDividend Income 1,054.79 3,422 73 2,574 05 2,824 54 7,997.74 4,155 54 18,115 69 500.00 500 00 1,000 00 1,000 00 43,145 08 Customer Penalties 556.47 1,016.29 995 20 543 56 792 86 1,027.05 989.14 1,830 79 800 00 800.00 800 00 800.00 10,951.36 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 28,000 00 28,000 00 28,000 00 28,000 00 704,144 20 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 29,300.00 29,300 00 29,800.00 29,800 00 758,178 86 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 206,186 00 299,172 00 186,996 00 133,316 00 2,351,220 70 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 800 00 800.00 800 00 800.00 29,508 35 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 21,000 00 21,000 00 21,000 00 21,000.00 290,481.52 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 8,000 00 9,000 00 12,000.00 20,000 00 166,596.08 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 9,865 33 9,865.33 9,865.33 9,865.33 178,124 61 Other Operating Expense 537.76 483.00 461.00 461 00 461 00 461.00 461.00 994.40 500 00 500 00 500 00 500 00 6,320 16 Customer Accounts Expense 1,423 55 149.07 286.62 2,478 64 53.00 603.27 622 67 642 30 400 00 400 00 7,000 00 400 00 14,459 12 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 23,000 00 23,000 00 23,000 00 23,000.00 402,059.64 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 123,565 33 124,565 33 134,165 33 135,565 33 1,797,549.48 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 206,186 00 299,172 00 186,996 00 133,316 00 2,351,220 70 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 123,565 33 124,565 33 134,165 33 135,565 33 1,797,549 48 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 82,620.67 174,606 67 52,830 67 (2,249.33) 533,671 22 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) 9,865 33 9,865 33 9,865 33 9,865.33 (91,818.08) 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) (14,500.00) (13,000 00) (13,000 00) (13,000 00) (179,652.17) Accounts Payable (29,062.20) (27,006.00) (8,638.25) (28,000.00) (12,521 74) 27,778.43 27,834 13 (28,000.00) (28,000 00) (28,000 00) (28,000 00) (161,615.63) Capitalized Items (20,412 00) (10,143.00) (52,536 49) (86,598 46) (4,000 00) (42,755.04) (10,000 00) (7,000 00) (7,000 00) (5,000.00) (245,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) 151,721 86 35,014 00 180,676.00 121,680 00 371,991.88 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 (5,000.00) (5,000 00) (5,000 00) (5,000 00) (102,271.58) 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 246,707.86 226,486 00 250,372.00 138,296.00 393,603.70 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,517,888.36 1,744,374 36 1,994,746 36 2,133,042 36 00