Loading...
ERMU Financial 12-13-2005 FINANCIAL INDEX 10 Oct-05 FINANCIALS PAGE I COMBINED BALANCE SHEET . .. . 1 ELECTRIC INCOME STATEMENT .. 2 WATER INCOME STATEMENT 3 IPROFIT AND LOSS NARRATIVE 4 ICASH FLOW BY MONTH .. ... 5 GRAPH #1 ELECTRICAL PURCHASES 6 IGRAPH #2 ELECTRIC SALES .. ... 7 GRAPH #3 ELECTRIC SALES/CUSTOMER CLASS .. ....... 8 I GRAPH #4 WATER PRODUCTION 9 GRAPH#5 WATER SALES . . . 10 I DETAILED ELECTRIC P & L WITH BUDGET INFORMATION.. .:.: 11 12 13 ill . 14 DETAILED WATER P & L WITH BUDGET INFORMATION. ... ... 15 I 16 17 DETAILED CASH FLOW ELECTRIC 18 IDETAILED CASH FLOW WATER 19 I I ICOMBINED BALANCE SHEETS 1111/ Oct-05 ASSETS ELECTRIC WATER I CURRENT ASSETS CASH&TEMPORARY INVESTMENTS 492,048 50 633,538.61 ACCOUNTS RECEIVABLE 1,609,124 83 351,282.46 I INVENTORIES 1,136,907 03 46,447.44 PREPAID ITEMS 13,691 21 1,891 45 CONSTRUCTION IN PROGRESS 148,744 01 476,593 86 TOTAL CURRENT ASSETS 3,400,515 58 1,509,753.82 IRESTRICTED ASSETS EMERGENCY RESERVE FUND 95,000,00 I CONSTRUCTION RESERVE FUND 1,166,197 47 1,000,000.00 TOTAL RESTRICTED ASSETS 1,261,197 47 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 GENERAL 21,201,263.20 17,187,648.29 9,164,784 08 714,380.93 FIXED ASSETS (COST) 36,206,791.33 27,015,634.59 LESS ACCUMULATED DEPRECIATION (13,517,087 80) (5,111,545.84) ITOTAL FIXED ASSETS, NET 22,689,703 53 21,904,088.75 OTHER ASSETS 23,500.97 96,461.93 • TOTAL ASSETS 27,374,917 55 24,510,304.50 LIABILITIES AND FUND EQUITY I CURRENT LIABILITIES ACCOUNTS PAYABLE 600,505 44 4,914.36 SALARIES AND BENEFITS PAYABLE 164,202 84 53,203.36 DUE TO CITY 35,515 28 I DUE TO OTHER FUNDS 184,038 01 6,118.08 BONDS PAYABLE-CURRENT PORTION 124,919 00 TOTAL CURRENT LIABILITIES 1,109,180 57 64,235.80 I LONG TERM LIABILITIES LFG PROJECT 2,423,717.87 DUE TO COUNTY 20,560.08 BONDS PAYABLE, LESS CURRENT PORTION 2,378,850 00 6,146,250.72 ITOTAL LONG TERM LIABILITIES 4,823,127 95 6,146,250.72 TOTAL LIABILITIES 5,932,308 52 6,210,486.52 I FUND EQUITY CONTRIBUTED CAPITAL RETAINED EARNINGS 21,442,609 03 18,299,817.98 ITOTAL FUND EQUITY 21,442,609 03 18,299,817.98 TOTAL LIABILITIES& FUND EQUITY 27,374,917 55 24,510,304.50 No NE E INN isisi N mu lii EN um M M 1 NM Mir M ELECTRIC INCOME STATEMENT ERMU Income Statement 1 2005 2005 2005 TOTAL 2004 2004 r __ OCTOBER ;YEAR TO DATE! BUDGET OCTOBER YEAR TO DATE Electric 1 i___ 1 __ ' _ i _ REVENUE - -+- _ - -1-1_ L 1 1 _ 1 Operating Revenue L L �-_-- 1EIk River 1 I 1,153,921 45 , 10,831,692 06 � 12,420,517 00 1,0.26,394 91 9,787,331 04 'Elk River-City Donated _ 15,024 18 ! 130,701 171 108,102 00 1-I- 13,238 32 ! 101,104 04 Otsego _ 1 103,661 19 ' 913,133 26 1 969,981 00 1 80,366 14 781,494 45 Rural Big Lake +------ _ 18,6_12 45 , 183,91585 246,732 00 I 17,961 65 173,054 85 Damon I _ 11,677 56 _ 134,797 081 147,611 00rt I 11,82868 125,867 44 Public St&Hwy Lighting I 13,212 70 I 143,596 59 f 174,678 00 4 14,678 92 ! 141,448 57 [Service Charge 1 _ _ !Generation Credit j_ I 29,055 52_i_ 292,236 52 I 349,992 00 I 29,327 97 1 291,531 67 Dispersed Generation Credit ! _ (2,312 50)! (50,575 00) _(71,17600)r-; - 1 (61,406 00) Additional Revenue/CIP&Rate Increase I - I 216,000 00 I ' - I _ 1TotalOperating Revenue 1,342,852 55 12,579 497 53 1 14,562,437 00 1 1 1 193 796 59 1 11,340,426 06 Other Operating Revenue ' i - 7 - _ _ ----------1 - - LFG Project 700 000 00 : 5 84350 40,027 81 --- ----------____-- 5,00000 2,02170 InteresUDmdend Income 5,032 79 I 22,540 89 Customer Penalties 1_ (1,36434) 107,130 93 1 11_5,212 0_0_ (1,242 22) 105,931 88 T - _ 56,552 27 587,553 51 T 6, 583,127 78 !Connection Fees r 84,261 68 460,163 34 350,000 00 i_ ' 204,302 30 ' 517,142 77 Security L_ I 15,473 29 ! 108,586 38 142,085 00 _,I 2,774 89 1 29,831 23 Misc Revenue I I _ _ _T 19,810 09 ; 104,416 43 83,000 00 I I 22,641 40 , 60,301 47 Total Other Revenuer I 179,765 78 1,390,391 48 1,295,297 00 1 287,341 57 1 1,336,362 94 'REVENUE TOTAL 1,522,618 33i 13,969,889 01 1 15,857,734 00 I 1,481,138 1612,676,789 00 - - ! - -- Power 0 8,271,484 00 ! 9,601,77200 [EXPENSES { -- } Purchased Power I 655,166 06 571,090 61 f 7,371,530 71 Operating&Mtce Expense 10,070 20 ! 141,1_9_2 75 216,785_00_! 1 9,7_43 36 124,43886 Landfill Gas + 1 - -- ! - - 19,864 93_ 220,533 85 L 281,200 00 ! 19,526 89 1 197,814 33 Distribution Expense _ 12,500 16 139,605 22 1 _ 187,000 00 � 1 17,457 31 146,635 83 Maintenance Expense I 58,890 87 I 528,89400 607,726 00 1 ! 53,15504 I 546,745 31 Deprecation 18,000 001 1,156,00000 ! 1,130,000 00 1 i, 70,225 00-: 713,575 00 Interest Expense 4,588 001 81,026 894 109,522 00 I 351 33 T 3,513 30 Security - f- 9,423 62 1 121,52589 15,000 00 Other Operating Expense _ 1,319 15 1 4,035 44 17,132 00 _i1,452 21 d 7,98302 Services to the City 1 60,096 80 1 583,681 41� 666,857 00 F 147,917 24 407,545 64 Customer Accounts Ex rise + - -_--,_-_ � 6,738 99 10_1,93.7.34 126,000_00 10,588 28 ' 100,793 94 Administrative&General Expense + , 19� __ Pe 135 761 15 1,267,519 00 1,443,413 00 93,276 ! 1,191,337 72 Total Expenses(before Operating Transfers) ! 1,092,419 93 12,617,435 79 1 14,402,407 00 1 894,783 46 1 10,811,913 66 TOTAL RE-VENUES t � - IL1,522,618 33 13,969,889 01 15,857,734 00 ; -1 ,481,13816 12,676,789 00 -TOTAL EXPENSES ! 1,092,419 93[1 12,617,435 79 I 14,402,407 00 1 894,783 46 ' 10,811,913 66 OPERATING TRANSFER rt �- -- L i ._ • ' ---- L -- ----- `------ I-- - -98 4---It 5----21------ Iii- ----- ----- -- _ INET INCOME PROFIT(LOSS)I _____ 1- 430,198 40 1,352,453 22 1,455,327 00� 586,354 70 ', 1,864,875 34 - -- - ` --- -1 1 --- 1 L T N = MN I MO MI OM MR III NM ii. MN M M iii. iiiie E WATER INCOME STATEMENT ERMU Income Statement 1 1 2005 ! 2005 2005 TOTAL 1 2004 2004 i 1 ' 1 OCTOBER YEAR TO DATE I BUDGET , OCTOBER YEAR TO DATE -17 - Water 1 1 - - - iREVENUE Operating Revenue - - --_ - - 'Water Sales _ _ � I 113,426 39 1 1,200,037.93 ', i; 97,677 64 i 1,060,485 15 1 _ _ jTotal Operating Revenue 1 113,426 39 1 1,200,037.93 % 1,443,534.00 97,677.64 1,060,485.15 11 - - I` — -- - -1 = _ Operating Revenue 1 ! : 5,315.01 i 50,426 55 Interest/Dividend Income r 15,000.00 Other Customer Penalties _ _ 11,170.75 i 7,800.00 r 4,000.00 _ _ _ 7,897.45 'Connection Fees i _84,372 50 1 751,074.49 471,200.00 50,400.00 780,524.89 1 Misc Revenue I 1 1 (61.78)1 -7- 1 - Total Other Revenue 89,687.51 ! 812,610.01 494,000.00 __ 50,400.00 792,422.34 REVENUE 1 1 - _ TOTAL Jr- 203,113.90 i 2,012,647.94 , 1,937,534.00 148,077 64 1,852,907.49 --;-t-- -- 1 , EXPENSES t 1 - — - 1 ---i_i - --- --- ----- - --- -- Production Expense 11 1 1 629.42 ! 27,742.52-T 10,000 00 1 4,451.21 i 15,539.08 Pumping Expense 20,523.22 260,878.72 258,818.00 19,176.24 220,473.02, _ i 85 L165,043.00 .06 Distribution Expense _ _ 19,018.66 600,000.00 � � 15,500.00 137,318 16 Depreciation - _ _60,000.00 ; 590,000.00 '---_---156,5 0 P 156,500 00 Interest Expense 14,524.001 167,711.29 I 276,049.00 5,371.36 , 53,713 60 Other OperatingExpense _Id_ _ _ --- - - - -r---- ---- _ e _ 994.40 6,308.96 10,092.00 785A2 1 7,803.95 Customer Accounts Expense ___11_ 612.08 1 7,848 92 18,101.00 ! 2,031 03 _ 12,799 52 JE Administrative &General Expense 36,221.70 370,129 97 1 280,134.00 1 21,614 95 1 227,156.59 _i Total Expenses (before Operating Transfers) 152,523.48 1,579,849.23 ''1 1,618,237 00 80,278.27 831,303.92 TOTAL REVENUES 1 I 203,113 90 2,012,647.94 1,937,534.00 148,077 64 , 1 852 907.49 TOTAL EXPENSES - --- � --- --- r - r -,----- _ 152,5_2_3.48 1,579,849.23 ! 1,618,237.00 80,278 27 1 831,303.92 OPERATING TRANSFER 1 ! � _ I 0 0 68 - -_- 1_ _ 20,000 00 30,868.00 ; 1 - 27,708 00 1 t-- _-INET INCOME PROFIT(LOSS) ! 1 _ 50,590.42 412,798.71 288,429 00 ! I - 67,799 37 993,895.57 - - W 111 111, IPROFIT AND LOSS NARRATIVE I ELECTRIC October's Operating Revenue was much higher than the prior year due to an unseasonably warm month. Typically, this shoulder summer month would not see such an increase—it is up approximately $150,000. Other Operating Revenue has a considerable decrease from a year ago and it is seen in I the Connection Fees. There was approximately $120,000 received in last year over this year from construction being down. For whatever reason, people seem to pay their utility bills more timely in October (maybe they are just so glad to see a decrease) and so the Icustomer penalty income is way down in this month for both years. It is actually a negative number, indicating the reversal of even prior penalties to customers. IThe purchased power cost is higher than the prior year, again reflective of the increased usage over last year. Administrative expense is $20,000 higher than last year. There was a large quarterly payment made to MMUA for training, which is about half of the Iincrease. The remainder of the increase relates to the CIP program (some participation with the energy house) and the purchase of postage for the postage meter. • WATER The Operating Revenue is also up from a year ago due to the warmer October 2005 weather. In contrast to the electric side, water connection fees are increased over last year by 30%. I Distribution expense is up approximately $8,000 over last year and this is due to increased transportation expense and maintenance of the water mains. The largest expense for water continues to be depreciation, and interest expense is increased over last I year due to the larger accrual. Administrative expense is increased over last year for the same reasons noted above in electric. I I 4 mu WI eim mu im iiiiii mil mili 5 EN mis sim mil Nis ime mow IIIIII 2005 CASH FLOWS BY MONTH WITH COMPARISONS TO YEAR END 2004 I , I -- - - ' -- I L i ] Dec-04 Jan-05 I Feb-05 ' Mar-05 i Apr-05 May-OS Jun-05 ! Jul-05 Aug-05 1 Sep-05 Oct-05 ; Nov-05 I Dec-05 ELECTRIC L ],_ , 1- !- , . 1 -- TEMPORARY CASH l INVESTMENTS, I _ 1 i -1---- 1 61-0001-1361_11-EMP CASH/SAVINGS 219,831 00 219,831 00 1 13.F22946 j 134 229 46 I 13&22946 134,229 46 95,033 19 111,548 11 I 70 069 48 I 70 069 48 70 069 48 1 61-0001-1312 CHECKING 860,716 62 739,099 33 i 790,999 17 1 627,438 00 1 498 619 83 415,653 51 J251,290 R (266,010 77)j (97,446 71) (31,248 07) 421,579 02 1 _ 61-0001-1311 jPETTY CASH ' 400 00 400 00 1 400 00 i 400 00 400 00 400 00 400 00 1 400 00 1 400 00 I 400 00 400 00' I 1 , TOTAL1 1,080,947 62 959,330 33 1 925,628 63 I 762,067 46' 633,249 29 550,282 97 (155,856 84)1 (154,062 66)j (26,977 23)1 39,221 41 I 492,048 50' - I I , I RESTRICTED FUNDS/OR DESIGNATED I I 1 __L_1 -- ' 1 -71 ; 1 , _ _.---1 -7- -1 I T I 61-0001-1271'CONST RESERVE I 1185,908 15 1,195,908 15 j_ 1 205,908 15 1 1,215,908 15! 1,227,047 54 1237,666 63 1,247,666 634 1,259 548 67 1 1,155,998 38; 1 161 178 57 1,166 197 47 , 1 61-0001-1282'BOND EMERG RESER1d1 95,000 00 95,000 00 1 95,000 00 95,000 00' 95 000 CO 95,000 00 95,00000; 95 000 00 1 95,00000' 9500000 95 000 00' ! 1 1,280,908 15 1,290,908 15; 1,300,908 15; 1,310 908 15 1 1,322,047 54 1,332,666 63 1,342,666 63 1 1 354,548 67; 1,250,998 38' 1,256,178 57 1,261,19747' - J1 7 i - -- TOTAL 2,361.855 77 2250,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 1,224,021 15 I 1,295,399 98 1,753,245 97! • INCREASE/DECREASE PER MONTH (111,617 29)I (135,31899)! (288,880 76); (406,558 94) (478,906 17) (1,175,045 98); (1,161,369 76)1 (1,137,834 62)1 (1,066,455 79) (608,609 80)1 , FROM YR END 04 1 1 I1 1 i , 1 I , , _ ----i I T 1- L ,, _ ,,_ WATER 1 L TEMPORARY CASH&INVESTMENTS I I II II i I_1 _:_ -1-- 1 I . -f- , , 62-0001-1312'CHECKING (818 690 00)4_ (150,900 27)1 169,565 91)j (614,216 6:9 (481 864 10)1 (424,935 57)1 295,375 07, 368 432 82 1 241 160 12 1 134,149 74 q56,754 241( 1 q I 62-0001-1211 11SAVINGS 1 1,641,970 83 1 691,970 83 i 373,115 62 1 978,82935! 780,999 96 1, 777,973 09 1 ! - I 3002038 3 ,98247 890,292 85 I L I -____j_ 62-0007-1212;CHECKING 1 - 1 33,600 00 I 112,880 00 1 - - I - i 1 ! TOTAL 1 823,280 83 I 774,670 56! 316,429 71 364,612 74 299,135 86 I 353,037 52 I 295,375 07 I 368,432 82 1 271,180 50! 444,132 21 633,538 61 1 - 1 _ 7 1_ 1 1 I , 7 _____1 1 ; RESTRICTED FUNDS/OR DESIGNATED II 1 I -- 7- 7 62-0001-1271 1CONST RESERVE 1 916,157 83 926 157 83 j 936 157 83; 842,320 29 1 852 700 09 862 700 09 880 967 17 1 891,594 52 I 1 000 000 00! 1 000 000 00 I 1,000 000 00 1 - 1 , TOTAL 1,739,438 66 1 1,700 828 39! 1,252,587 54 1 1 206 933 03 I 1,151,835 95 1,215,737 61 1,176,342 24 I 1,260 027 34 1 1 271 180 50 1 1,444,132 21 1 633,538 61 I - INCREASE/DECREASE PER MONTH I I: i ' 1 I 1 4 - 1 1 „ 1 -, , _ FROM YR END 2004 1 (38,610 27)' (486,851 12)1 (532,505 63)1 (587,602 71)1 (523,701 05)1 (563 096 42)' (479 411 32), (468,258 16): (295,306 45)! (105,900 05)' ' I I i- ---1- -i- _ _ i --i 1 . -r 1- --1 L i -t- ----, _____ • -'-- l• -i- 1 , ,- -t, 1- 1 1 ' , j,-- _ ___ ____ - - --llH- --i-- ------ 4- J --41- 1- _, 1 -- _ a -----I- -- ---t- -I-- [ [ 1 --- _____I. ______1 1 al I 11111/ ELk River Municipal Utilities Monthly Electrical IDemand I 50 45 I 1 40 - C • 35 J/-2116 • -o I % 30 E w 25 0 • • . �1 2004 I 20 1 5 1 i I I I I I I I ��Ja� �ocJa6 �a�Gr PQM\ �`e- ��,e \O ��1����°.z G�o�& ���e � co ���� e P eQ Q GJ °G IMonths Ill Elk River Municipal Utilities Monthly Energy IPurchases 22,000 Ix 21,000 2 20,000 I .E 19,000 N 18,000 s RI 17,000 = ' • 16,000 . a >, 15,000 • , 2005 • ` ,1) 0 , *----60m` 14,000 ' . • 0 • W 13,000 ' 12,000 cc` �a�Ja� e'°�Jac1 �acc' PQM` \e" ���e �J\� P,,c; �eee� OG,,60 Jeee� Gee F C, \49 Oe 1111 Month I I ` Lf' I 114, _ Elk River Municipal Utilities Monthly Total Electric Load 22,000 ' 20,000 - 18,000 - 2005 ,• :a 16,000 • �' os o • ♦ I 0 14,000 - • . _ ♦ ♦ , • / • 0 • m 12,000 ik W 0 rt • 004• ' I 10,000 • 2 8,000 I I �Ja6 `Ja6 accp PQM\ �a� �J�e �\O J��y� �,oec �o�ec ��ec ��ec �a <<P v. Q,1/4e 00 o4e 0Ge IMonth1 5e Elk River Municipal Utilities Monthly Electric Sales 111 $1,800,000 $1,600,000 I $1,400,000 • • # ♦ • 04)11 E $1,200,000 ' • • I o $1,000,000 0, • • r, . ♦ M H $800,000 ♦ M o I v � $600,000 $400,000 2004 I $200,000 $0 I I- I I I I I � 6 6 �r a ,0 �� ec ,c1 vec e �§ PQ4\ \O e e � ez, Fe P ,0 oa ,eae Q 5e oce I Month 10 I I 7 I ELk River Municipal Utilities Monthly Residential, Commerical NO & Industrial Loads I 12,000 10,000 Industrial II 8,000 • �.- , , „ 2 • . I 6,000 ta . . • . o 4,000 z 2004 I 2,000 r �. ,Corytmerlcat I0 ,mac,. e,,,o �`�cG�` PQ �a� �J1/4e �J�� P\O �eckc) oG�9 �,, aAc• I �#Q ‘49 Oe Month I Elk River Municipal Utilities Monthly Residential, Commerical 11111 & Industrial Sales $900,000 I $800,000 $700,000 Industrial I e $600,000co - - Z . • • �Z • p $500,000 • • ~ . ` a w• $400,000 ,,,;�� r . ; /''. I m co• $300,000 2004 I $200,000 _ _ - $100,000 - - — 0 Commiriaal $0 I IJa6 ,,s 4,macer PQM �a� �J�e ���� J�J4� ��ec �o�,§ c��ec cc�°ec �a �e� �` Q' eQ'�e 00 o4e Oe I Month S O gi I Elk River Municipal Utilities Monthly Water Pumpage IS 140 I ..ct 120 c 100 •, • . 80 , ♦ c • • ' 60 2006 • I 03 40 \ .. E . . . 3 CL 20 - 2004 I0 I I I I I I I I I I I I � ec e. °,°`Jac1 bac PQM\ �aA ,J�e �J�� P J�JS� °�,o°c G�°pec e�vz °�'o 1 ��� Month I IElk River Municipal Utilities Peak Day Pumpage le 6 5 a • I To • c 4 ♦ ‘ 'o i • Ic xQOQ 0 ea a0 ` 1 2004 I 0 (</ �•� P , ,i.,..0 �� Geo e� �c` �eQ p " Oea Month I I. I I 9` I Elk River Municipal Utilities Monthly Water Sales IIII 140 -111 120 I 0 100 c 0 80 ♦ I 2 ♦ c 60' • •• • N • d R 40 • I co 7. . 0 20 2006 I0 - I I I I I I I I 20041 I c eQ \4o Oe Month I IPElk River Municipal Utilities Monthly Water Sales $300,000 I $250,000 I co 2 $200,000 • o � • c $150,000 y ` N i a) ♦ N $100,000 • ♦ I $50,000 2006. 2004 $0 I ac1 e�`Jac1 �acor PM\ �a� ,J�e ,J\� QJ�Je� �e�ve�oG�o�e� Je��e� Ge�vec I coeQ N4o Oe Month 10 I I tO PIP MIN MINI PR De 4 35 E M I,L VE LI.'. V IIIII MN NM IIIIII I= NMI A TIL S M ge 1 of, Fiscal Year 2005 Budget Fiscal Year 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 441,847 56 4,566,698 46 92 40% 411,857 00 4,942,279 00 375,580 54 3,855,928 41 4,526,546 96 61-0440-4412 ELECT SALES/ER NON-DEMAND 111,030 43 1,302,717 48 92 56% 117,280 00 1,407,359 00 104,641 52 1,101,618 08 1,275,229 51 61-0440-4413 ELECT SALES/ER DEMAND 598,811 78 4,939,848.07 81.73% 503,650 00 6,043,797 00 1,103,948 93 4,807,592 14 5,648,048 79 61-0440-4414 ELECT SALES/ELK RIVER SEC LTS 2,231.68 22,428 05 82.82% 2,257 00 27,082 00 4,653 95 22,192 41 26,694 39 61-0440-4415 ELECT SALES/ER CITY DONATED 15,024 18 130,701.17 120.91 % 9,008.00 108,102 00 (22,599 17) 101,104 04 120,687 44 61-0440-4416 ELECT SALES/OTSEGO RES 57,819.76 607,678 19 88 75% 57,058 00 684,696 00 77,017 81 545,615 35 633,900 55 61-0440-4417 ELECT SALES/OTSEGO NON-DEMAND 15,929 34 143,466 65 98 14% 12,182 00 146,188 00 2,721 35 124,665 29 141,065 14 61-0440-4418 ELECT SALES/OTSEGO DEMAND 29,191 14 154,800 27 119 08% 10,833 00 130,000 00 (24,800 27) 111,801 90 133,175 77 61-0440-4419 ELECT SALES/OTSEGO SEC LTS 720 95 7,188 15 79.02% 758.00 9,097.00 1,908 85 (588 09) 804 61 61-0440-4421 ELECT SALES/BIG LAKE RES 17,978 80 176,929.86 73.80% 19,978.00 239,741 00 62,811 14 166,867 94 194,656 99 61-0440-4422 ELECT SALES/BL NON-DEMAND 481 28 5,511 81 105 65% 435 00 5,217.00 (294 81) 4,743 91 5,332 20 61-0440-4423 ELECTRIC SALES/BL DEMAND 14 67 75 68 0 00% 0 00 0 00 (75 68) 0 00 0 00 61-0440-4424 ELECT SALES/BIG LAKE SEC LTS 137 70 1,398 50 78 83% 148 00 1,774 00 375 50 1,443 00 1,731 60 61-0440-4431 ELECT SALES/DAYTON RES 9,813 73 116,258 76 91 66% 10,569.00 126,831 00 10,572 24 106,838 38 123,160 31 61-0440-4432 ELECT SALES/DAYTON NON-DEMAND 1,504 18 14,960 12 90 12% 1,383 00 16,600 00 1,639.88 15,437 66 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,578 20 85 60% 348 00 4,180 00 601.80 3,231 80 3,590 15 61-0440-4441 PUBLIC ST&HWY LIGHTING/CITY 13,212 70 143,596.59 82 21 % 14,556 00 174,678 00 31,081 41 141,448 57 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,576 52 92 94% 500 00 6,000 00 423 48 5,339 17 7,464 81 61-0440-4551 GENERATION CREDIT 28,666 00 286,660 00 83 33% 28,666 00 343,992 00 57,332 00 286,192 50 285,794 82 61-0440-4552 DISPERSED GENERATION CREDIT (2,312 50) (50,575 00) 71 06% (5,931 00) (71,176 00) (20,601 00) (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,342,852 55 12,579,497 53 86 38% 1,213,535 00 14,562,437 00 1,982,939 47 11,340,426 06 13,255,912 19 INTEREST INCOME 61-0460-4691 INTEREST&DIVIDEND INCOME 5,032.79 22,540 89 450 82% 417 00 5,000 00 (17,540 89) 40,027 81 25,703 79 TOTAL INTEREST INCOME 5,032 79 22,540 89 450 82% 417 00 5,000 00 (17,540 89) 40,027 81 25,703 79 OTHER OPERATING REVE 61-0470-4700 SECURITY REVENUE 15,473 29 108,586 38 258 02% 3,507 00 42,085 00 (66,501 38) 29,831 23 38,719 93 61-0470-4701 CUSTOMER DELINQUENT PENALTIES (1,364 34) 107,130 93 92 99% 9,601 00 115,212 00 8,081 07 105,931 88 118,910 23 61-0470-4702 DISCONNECT&RECONNECT CHARGE 84,261 68 460,163 34 131 48% 29,167 00 350,000 00 (110,163 34) 517,142 77 574,156 05 61-0470-4703 MISC ELEC REVENUE-TEMP CHG 14,245 08 17,545 08 877 25% 167 00 2,000 00 (15,545 08) 1,100 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) 40,250 00 49,902 50 61-0470-4711 MERCH JOBBING&CONTRACT WORK 1,291 96 1,153 43 0.00% 0 00 0 00 (1,153 43) 0 00 0 00 61-0470-4715 NON-UTILITY OPERATIONS 0 00 1,125 80 45 03% 208 00 2,500 00 1,374 20 0 00 0 00 61-0470-4721 LFG PROJECT 56,552 27 587,553 51 83 94% 58,333 00 700,000 00 112,446 49 583,127 78 701,371 49 61-0470-4722 MISC NON-UTILITY 3,947 99 59,249.76 102.15% 4,833 00 58,000 00 (1,249 76) 19,949 27 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 325 06 753 15 150.63% 42 00 500 00 (253 15) (997 80) (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 174,732 99 1,367,850 59 106 01 % 107,525 00 1,290,297 00 (77,553 59) 1,296,335 13 1,518,732 60 TOTAL ELECTRIC 1,522,618 33 13,969,889 01 88 10% 1,321,477 00 15,857,734 00 1,887,844 99 12,676,789 00 14,800,348 58 "Rd De 43` ilill Mill ilLIMVEllitliDATTTILrES111.11 MI1,111MI --,r2Ol. 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,522,618.33 13,969,889.01 88.10% 1,321,477.00 15,857,734.00 1,887,844.99 12,676,789.00 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,700 92 31,776 67 74 45% 3,557 00 42,680 00 10,903 33 32,889 22 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 948 00 14,328 26 95 52% 1,250 00 15,000 00 671 74 0 00 778 31 61-0540-5472 NATURAL GAS 330 00 11,200 02 294 74% 317 00 3,800 00 (7,400 02) 3,680 36 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 1,741.85 24,342.44 81 09% 2,502 00 30,020 00 5,677 56 24,991 27 29,056 21 61-0540-5484 OTHER EXP/PLANT SUPPLIES-ETC 1,568.79 17,000 49 68.00% 2,083 00 25,000 00 7,999 51 24,542 26 29,374 69 61-0540-5491 MISC OTHER PWR GENERATION EXP 22 64 3,805 61 35 24% 900 00 10,800 00 6,994 39 7,997 14 11,715 41 61-0540-5521 MAINTENANCE OF STRUCTURE/PLANT 1,456 00 14,961 90 83 59% 1,492 00 17,900 00 2,938 10 11,769 40 19,940 33 61-0540-5531 MTCE OF ENGINES/GENERATORS-PL 156 00 18,003 23 40 01 % 3,750 00 45,000 00 26,996 77 15,087 64 17,758 84 61-0540-5541 MTCE OF PLANT/LAND IMPROVEMENT 146 00 5,768 01 144 20% 333 00 4,000 00 (1,768 01) 3,481 57 3,823.91 61-0540-5551 PURCHASED POWER 647,082 58 8,186,936 36 86.06% 792,730 00 9,512,763 00 1,325,826 64 7,289,895 24 8,563,297 85 61-0540-5552 LFG PURCHASED GAS 8,083 48 84,547.64 94 99% 7,417.00 89,009 00 4,461 36 81,635 47 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 665,236 26 8,412,676 75 85 68% 818,213 00 9,818,557 00 1,405,880 25 7,495,969 57 8,863,561 13 LANDFILL GAS 61-0550-5051 LANDFILL GAS O&M 19,836 00 201,382.50 78 06% 21,500 00 258,000 00 56,617 50 175,873 13 219,178 10 61-0550-5052 LFG ADMIN 28 93 4,071 35 66.74% 508 00 6,100 00 2,028 65 5,121 20 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,864 93 220,533 85 78 43% 23,433 00 281,200 00 60,666 15 197,814 33 241,362 66 DISTRIBUTION EXPENSE 61-0580-5801 REMOVE EXISTING SERV& METERS 0 00 1,980 78 330 13% 50 00 600 00 (1,380 78) 773 21 1,349 56 61-0580-5831 TRANSFORMER EX/OVERHD&UNDER( 787 61 10,329 39 129 12% 667 00 8,000 00 (2,329 39) 6,774.69 9,448 54 61-0580-5851 MTCE OF SIGNAL SYSTEMS 129 07 782 55 26 08% 250.00 3,000 00 2,217 45 1,471 97 1,902 66 61-0580-5861 METER EXP-REMOVE&RESET 562 44 10,215 07 25 54% 3,333 00 40,000 00 29,784 93 8,624 34 10,330 32 61-0580-5871 TEMP SERVICE-INSTALL&REMOVE 67 31 4,336 84 80 31 % 450 00 5,400 00 1,063 16 2,539 03 2,733 72 61-0580-5881 MISC DISTRIBUTION EXPENSE 10,953 73 111,960 59 86 12% 10,833 00 130,000 00 18,039 41 126,452 59 124,700 00 TOTAL DISTRIBUTION EXPENSE 12,500 16 139,605 22 74 66% 15,583 00 187,000 00 47,394 78 146,635 83 150,464 80 MAINTENANCE EXPENSE 61-0590-5911 MTCE OF STRUCTURES 96 63 508 88 31 80% 133 00 1,600 00 1,091 12 240 88 240 88 61-0590-5921 MTCE OF SUBSTATIONS 1,204.58 21,749 23 83 65% 2,167 00 26,000 00 4,250 77 22,691 69 25,534 28 61-0590-5922 MTCE OF SUBSTATION EQUIPMENT 320 94 1,635 13 48 09% 283 00 3,400 00 1,764 87 115 36 894 28 61-0590-5931 MTCE OF OVERHD LINES/TREE TRIM 3,578 93 96,745 94 96 75% 8,333.00 100,000 00 3,254 06 142,782 62 174,707.81 61-0590-5932 MTCE OF OVERHD LINES/STANDBY 3,836 14 28,688 08 110 03% 2,173.00 26,074 00 (2,614 08) 22,550 10 25,593.05 61-0590-5933 MTCE OF OVERHEAD 14,895 22 47,672 44 85 13% 4,667 00 56,000 00 8,327 56 33,018.66 33,595 00 61-0590-5941 MTCE OF UNDERGROUND/DISTRIB 7,787 01 85,560 04 132.65% 5,375 00 64,500 00 (21,060 04) 77,399 58 104,193 36 61-0590-5951 MTCE OF LINE TRANSFORMERS 478 50 13,410 95 83 82% 1,333 00 16,000 00 2,589 05 6,988 52 7,498 60 61-0590-5961 MTCE OF STREET LIGHTING 3,185 02 24,539 26 75.97% 2,692 00 32,300 00 7,760 74 25,027 03 37,804 69 N MIN OM Ell odDe 43I �LF VE MUS �A TIL ES ' ge3of4 Fiscal Year 2005 Budget Fiscal Year 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 1,051 65 3,749 56 65 84% 475 00 5,695 00 1,945 44 3,802 08 6,426 97 61-0590-5971 MTCE OF METERS 3,214.57 50,543 47 118 93% 3,542 00 42,500 00 (8,043 47) 44,391 86 48,469 36 61-0590-5972 VOLTAGE COMPLAINTS 759 49 4,743 19 95 05% 416 00 4,990 00 246 81 4,898 48 6,179 63 61-0590-5981 SALARIES/TRANS&DISTRIBUTION 1,936 32 16,496 27 71 75% 1,916 00 22,990 00 6,493 73 18,363 33 21,981 73 61-0590-5991 MTCE OF OVERHEAD SERVICE/2NDRY 1,143 96 7,399 68 40 00% 1,542.00 18,500.00 11,100 32 10,272.96 13,146 74 61-0590-5992 MTCE OF UNDERGROUND ELEC SERV 6,828 66 46,114 58 109 54% 3,508 00 42,100 00 (4,014.58) 30,705 29 38,351 38 61-0590-5995 TRANSPORTATION EXPENSE 8,573 25 79,337.30 54 69% 12,090.00 145,077 00 65,739 70 103,496 87 119,803 00 TOTAL MAINTENANCE EXPENSE 58,890 87 528,894 00 87 03% 50,645 00 607,726 00 78,832 00 546,745 31 664,420 76 DEPRECIATION/ELECTRI 61-0595-8031 DEPRECIATION/ELECTRIC 118,000 00 1,156,000 00 102.30% 94,167.00 1,130,000 00 (26,000 00) 713,575 00 1,427,091 00 TOTAL DEPRECIATION/ELECTRI 118,000 00 1,156,000 00 102 30% 94,167 00 1,130,000 00 (26,000 00) 713,575 00 1,427,091 00 INTEREST EXPENSE 61-0596-8071 INTEREST ON BONDS/LONG TERM 4,588.00 81,026 89 73 98% 9,127 00 109,522 00 28,495 11 3,513 30 87,544 63 TOTAL INTEREST EXPENSE 4,588 00 81,026 89 73 98% 9,127 00 109,522 00 28,495 11 3,513 30 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 9,423 62 121,525 89 810 17% 1,250 00 15,000 00 (106,525 89) 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 336 53 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,096 80 280,976 44 95 25% 24,583.00 295,000 00 14,023 56 245,545 64 294,698 18 61-0597-8262 TRANSFER TO CITY 3%ER REVENUE 30,000 00 300,000 00 80 68% 30,988 00 371,857 00 71,857 00 162,000.00 340,564 28 61-0597-8263 OTHER DONATIONS 1,309 15 4,014 12 57.34% 583 00 7,000 00 2,985 88 7,551 69 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 100 00 75 76% 11 00 132 00 32 00 94 80 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 70,839 57 709,242 74 101 47% 58,248 00 698,989 00 (10,253 74) 415,528 66 673,539 63 CUSTOMER ACCOUNTS EX 61-0900-9021 METER READING EXPENSE 6,153 16 68,281 64 117 73% 4,833 00 58,000 00 (10,281 64) 47,048 64 61,445 70 61-0900-9030 COLLECTING EXP DISC/RECONNECT 1,978 58 15,979 91 66 58% 2,000.00 24,000.00 8,020 09 20,504.33 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,102 36) (2,476 01) -10 32% 2,000 00 24,000 00 26,476 01 9,846 51 14,350 85 61-0900-9061 GUST BLGS NOT PD/SENT FOR COLL (290.39) 19,548.27 97.74% 1,667.00 20,000.00 451.73 23,394 46 23,136 04 TOTAL CUSTOMER ACCOUNTS EX 6,738 99 101,937 34 80 90% 10,500 00 126,000 00 24,062 66 100,793 94 121,135 69 ADMINISTRATIVE & GEN 61-0920-9201 SALARIES/OFFICE&COMMISSION 21,240.73 213,830 74 66 82% 26,667 00 320,000 00 106,169.26 246,464 65 293,406 22 61-0920-9211 OFFICE SUPPLIES&EXPENSE 15,181 69 79,578 02 132 63% 5,000 00 60,000 00 (19,578 02) 61,826 92 63,261.27 61-0920-9212 LT&WATER CONSUMPTION/OFFICE 1,016 53 9,050 86 177 47% 425 00 5,100 00 (3,950 86) 5,232 95 6,468 39 61-0920-9213 BANK CHARGES 529 96 5,930.36 101 58% 486.00 5,838 00 (92.36) 4,837 18 5,281 27 61-0920-9221 LEGAL FEES 2,372 63 4,560 91 57.01 % 667.00 8,000 00 3,439 09 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 CP .11 ME IIIII 1.111 MEI Mil OM Ell Mill MIMI MIN I= 11=41111 Rid Decem 5 4 35 L E L) AL UTILITIES g 4 ofrill Fiscal Year 2005 Budget Fiscal Year 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 12,145 17 84,187 20 70 27% 9,983 00 119,800 00 35,612 80 97,070 95 123,171 81 61-0920-9261 UTIL SH OF MEDICAL/DENTAL/DISA 17,154 88 169,326 07 86 61 % 16,292.00 195,500 00 26,173 93 146,269 01 165,072.24 61-0920-9262 UTILITY SHARE OF PERA 14,545 21 115,669.54 133 41 % 7,225 00 86,700 00 (28,969 54) 68,242 69 83,018 53 61-0920-9263 UTILITY SHARE OF FICA 10,128 62 105,579.92 95 98% 9,167.00 110,000 00 4,420 08 96,961 18 109,136 19 61-0920-9264 EMPLOYEES SICK PAY 3,163 00 33,747 15 84 37% 3,333 00 40,000 00 6,252.85 38,312 12 49,281 05 61-0920-9266 EMP VACATION/HOLIDAY PAY 6,074 95 99,169 55 73 46% 11,250.00 135,000 00 35,830 45 139,077 08 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 14,279.08 124,940 31 85 58% 12,167.00 146,000 00 21,059 69 133,918 66 162,348 92 61-0920-9281 ENVIRONMENTAL COMPLIANCE 1,892 92 8,322 67 66 58% 1,042 00 12,500 00 4,177 33 10,753 70 14,601.54 61-0920-9291 CONSULTING FEES 2,438 28 41,485.31 138 28% 2,500.00 30,000 00 (11,485.31) 20,284 28 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,005 44 10,985 71 82 60% 1,108 00 13,300 00 2,314.29 8,006 87 10,104 73 61-0920-9302 ADVERTISING (151 43) 12,645 01 60 21 % 1,750.00 21,000 00 8,354 99 13,613 81 16,460 74 61-0920-9303 DUES&SUBSCRIPTIONS-FEES 450 24 32,982 62 117 80% 2,333 00 28,000 00 (4,982 62) 20,940 00 22,699 20 61-0920-9304 TRAVEL EXPENSE 0 00 4,168.75 104 22% 333.00 4,000 00 (168 75) 957 95 957.95 61-0920-9305 SCHOOLS&MEETINGS 12,293 86 63,165 67 90.95% 5,788 00 69,450 00 6,284 33 62,847 59 73,069.90 61-0920-9306 MISC GENERAL EXPENSE (0.61) 48 89 0 68% 600 00 7,200.00 7,151 11 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 413 48 18,806 34 TOTAL ADMINISTRATIVE&GEN 135,761 15 1,267,519 00 87 81 % 120,284 00 1,443,413 00 175,894 00 1,191,337 72 1,443,455 89 TOTAL ELECTRIC 1,092,419 93 12,617,435 79 87 61 % 1,200,200 00 14,402,407 00 1,784,971 21 10,811,913 66 13,672,576 19 TOTAL Expense 1,092,419.93 12,617,435.79 87.61 % 1,200,200.00 14,402,407.00 1,784,971.21 10,811,913.66 13,672,576.19 PROFIT/ (LOSS) • 430,198.40 1,352,453.22 121,277.00 1,455,327.00 102,873.78 1,864,875.34 1,127,772.39 Date Range . 10/1/2005 To 10/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 ... Pit De 53 7A TILS_ ge1of3 INN ELK RIVER MU,NM NM 1111111 11111 MI � Fiscal Year 2005 Budget Fiscal Year 2004 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 5,315 01 48,926 55 407 72% 1,000 00 12,000 00 (36,926 55) 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 5,315 01 50,426 55 336 18% 1,250 00 15,000 00 (35,426 55) 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 113,426 39 1,200,037.93 83.13% 120,294 00 1,443,534.00 243,496 07 1,060,485 15 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 113,426 39 1,200,037 93 83 13% 120,294 00 1,443,534 00 243,496 07 1,060,485 15 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 0 00 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 80,002 50 693,807 50 164 72% 35,100 00 421,200 00 (272,607.50) 704,379 18 839,910 80 62-0620-6402 MISC CONNECTION FEES 4,370.00 57,266 99 114 53% 4,167.00 50,000 00 (7,266 99) 76,145 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 84,372 50 762,183 46 159 12% 39,917 00 479,000 00 (283,183 46) 788,422 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 203,113 90 2,012,647 94 103 88% 161,461 00 1,937,534 00 (75,113 94) 1,852,907 49 3,639,571 49 TOTAL Revenue 203,113.90 2,012,647.94 103.88% 161,461.00 1,937,534.00 (75,113.94) 1,852,907.49 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 629 42 27,742 52 277 43% 833 00 10,000 00 (17,742 52) 15,539 08 29,341 95 TOTAL WATER PRODUCTION EXP 629 42 27,742 52 277 43% 833 00 10,000 00 (17,742 52) 15,539 08 29,341 95 PUMPING EXPENSE 62-0710-7101 SUPERVISION 2,146 40 18,542 16 75 94% 2,035 00 24,418 00 5,875 84 18,659 78 22,662 26 62-0710-7181 SUPPLIES&EXPENSE 11,278 78 130,041 12 70 10% 15,458 00 185,500 00 55,458 88 146,929 94 174,078 63 62-0710-7201 MTCE OF ELECT PUMPING EQUIP 0 00 4,637 42 103 05% 375 00 4,500.00 (137 42) 2,971 74 4,149 39 62-0710-7220 MTCE OF WELLS 7,098 04 107,658.02 242 47% 3,700 00 44,400 00 (63,258 02) 51,911 56 81,336 83 ME Ell 1E1 MINI .... ... MIN Ell MINI MINI UM Pled Decem 5 39 ELK VE U,�'DA UTILITIES ge 2 of Fiscal Year 2005 Budget Fiscal Year 2004 Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total Expense (Continued) WATER PUMPING EXPENSE TOTAL PUMPING EXPENSE 20,523 22 260,878 72 100 80% 21,568 00 258,818 00 (2,060 72) 220,473 02 282,227 11 WATER DISTRIBUTION E 62-0730-7301 MTCE OF WATER MAINS 4,225 85 13,971 74 73 54% 1,583 00 19,000 00 5,028 26 17,586 35 26,134 94 62-0730-7311 MTCE OF WATER SERVICES 3,131 26 30,074 00 60 15% 4,167.00 50,000 00 19,926 00 36,661 97 40,785 67 62-0730-7321 MTCE OF CUSTOMERS SERVICE 2,742 18 30,449 06 106 84% 2,375 00 28,500 00 (1,949 06) 29,112 24 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,612 35 9,382 31 62-0730-7341 MISC WATER EXPENSE/INVENTORY 184 20 952 36 61 44% 129.00 1,550 00 597 64 476 19 155 69 62-0730-7391 WAGES/WATER 858 56 7,416 85 57.94% 1,067.00 12,800.00 5,383 15 7,463 90 9,064 89 62-0730-7395 TRANSPORTATION EXPENSE 6,182.67 38,499 05 233.33% 1,375 00 16,500 00 (21,999 05) 14,432 82 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 17,324 72 129,951 85 91 26% 11,867 00 142,400 00 12,448 15 118,091 82 148,216 88 WATER ACCOUNTING EXP 62-0740-7431 METER READING EXPENSE 1,693 94 19,277 00 85 13% 1,887 00 22,643.00 3,366 00 19,226 34 23,512 90 TOTAL WATER ACCOUNTING EXP 1,693 94 19,277 00 85 13% 1,887 00 22,643 00 3,366 00 19,226 34 23,512 90 DEPRECIATION EXPENSE 62-0745-7451 DEPRECIATION-WATER 60,000 00 590,000.00 98 33% 50,000 00 600,000 00 10,000 00 156,500 00 720,044 00 TOTAL DEPRECIATION EXPENSE 60,000 00 590,000 00 98 33% 50,000 00 600,000 00 10,000 00 156,500 00 720,044 00 INTEREST EXPENSE 62-0748-7481 INTEREST ON BONDS/LONG TERM 14,524 00 167,711.29 60 75% 23,004 00 276,049 00 108,337 71 53,713 60 256,206 96 TOTAL INTEREST EXPENSE 14,524 00 167,711 29 60 75% 23,004 00 276,049 00 108,337 71 53,713 60 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 1,031 45 5,652 62 62-0750-7564 AMORTIZATION 1994 0 00 0.00 0 00% 0 00 0 00 0 00 1,566 80 12,225 48 62-0750-7565 AMORTIZATION 1997 0 00 98 76 5 34% 154 00 1,850 00 1,751 24 1,223 10 1,741 41 62-0750-7566 AMORTIZATION 1998 132 00 1,320 00 109.09% 101 00 1,210 00 (110 00) 964 70 1,163 17 62-0750-7567 AMORTIZATION 2001 329 00 3,290 00 92 29% 297 00 3,565 00 275 00 3,017 90 3,555 69 62-0750-7568 AMORTIZATION 2003 533 40 1,600 20 0 00% 0 00 0 00 (1,600 20) 0 00 1,708 00 TOTAL OTHER OPERATING EXPE 994 40 6,308 96 62 51 % 841 00 10,092 00 3,783 04 7,803 95 26,046 37 CUSTOMER ACCOUNTS EX 62-0900-9030 COLLECTING EXP DISC/RECONNECT 612 08 4,136 40 58 54% 589 00 7,066.00 2,929 60 6,205 59 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 6,593 93 9,744 93 62-0900-9061 GUST 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 612 08 7,848 92 43 36% 1,509 00 18,101 00 10,252 08 12,799 52 16,299 84 ADMINISTRATIVE & GEN 62-0920-9201 SALARIES/OFFICE&COMMISSION 7,155 24 67,780 19 271 23% 2,082 00 24,990 00 (42,790 19) 12,282 96 27,930 15 62-0920-9211 OFFICE SUPPLIES&EXPENSE 4,228 55 25,738 39 122 56% 1,750 00 21,000 00 (4,738 39) 20,068 61 22,825 94 62-0920-9212 LT&WATER CONSUMPTION/OFFICE 338 84 3,086 01 103 56% 248 00 2,980 00 (106 01) 1,744 29 2,156 09 62-0920-9213 BANK CHARGES 176 66 1,767 48 106 47% 138 00 1,660 00 (107 48) 1,416 82 1,564 85 62-0920-9222 LEGAL FEES 790 87 918 45 36 74% 208 00 2,500 00 1,581 55 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 EMI M Ma M M N E M I MN MI ME MI PrintedDecemb 5605.39 PM ELK RIVER MUiWDAL UTILITIES ge3of3 Fiscal Year 2005 Budget Fiscal Year 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 3,899 52 21,033 95 87 64% 2,000 00 24,000 00 2,966 05 22,630 30 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 4,605 95 55,092 64 94 88% 4,839 00 58,068 00 2,975 36 47,842 89 54,026 88 62-0920-9262 UTILITY SHARE OF PERA 3,246.33 25,483 95 93 91 % 2,261 00 27,136 00 1,652.05 22,747 52 27,672 84 62-0920-9263 UTILITY SHARE OF FICA 1,379 36 24,950 36 87.24% 2,383 00 28,600 00 3,649 64 32,868 33 36,926 66 62-0920-9264 EMPLOYEES SICK PAY 2,132 68 12,609 01 315 23% 333 00 4,000 00 (8,609 01) 3,814 30 7,470 61 62-0920-9267 EMP VACATION/HOLIDAY PAY 2,024 99 33,435 96 240.55% 1,158 00 13,900 00 (19,535 96) 14,237 28 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 3,000 00 7,399 21 61 66% 1,000 00 12,000 00 4,600 79 14,384 59 18,318 33 62-0920-9301 TELEPHONE 335.15 3,831 02 109 46% 292 00 3,500 00 (331 02) 2,674 71 3,373 97 62-0920-9302 ADVERTISING 0 00 4,905 44 98 11 % 417 00 5,000 00 94 56 4,745 60 5,613 17 62-0920-9303 DUES&SUBSCRIPTIONS-FEES (180 59) 23,499 34 361 53% 542 00 6,500.00 (16,999 34) 9,849 11 10,604 41 62-0920-9304 TRAVEL EXPENSE 23 97 462.61 35 59% 108.00 1,300 00 837 39 199 50 199 50 62-0920-9305 SCHOOLS& MEETINGS 3,064 18 21,280 70 144 28% 1,229 00 14,750 00 (6,530 70) 11,733 67 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 (541 43) 5,589 50 TOTAL ADMINISTRATIVE&GEN 36,221 70 370,129 97 132 13% 23,343 00 280,134 00 (89,995 97) 227,156 59 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 152,523 48 1,599,849 23 97 01 % 137,424 00 1,649,105 00 49,255 77 859,011 92 1,842,116 86 TOTAL Expense 152,523.48 1,599,849.23 97.01 % 137,424.00 1,649,105.00 49,255.77 859,011.92 1,842,116.86 PROFIT/ (LOSS) . 50,590.42 412,798.71 24,037.00 288,429.00 (124,369.71) 993,895.57 1,797,454 63 Date Range 10/1/2005 To 10/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 J Cash Flows Actual 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,302,896 83 1,105,354 00 1,118,130 00 14.404,173 42 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 13,212 70 14,500 00 14,500 00 172,596 59 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,055 52 29,374 72 29,374 72 350,985 96 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) (2,312 50) (50,575 00) 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,342,852 55 1,149,228 72 1,162,004 72 14,877,180 97 Other Operating Revenue - InteresUDividend Income 3,078 57 315 97 139 61 1,210 30 4,813 24 191 45 1,903 62 662 03 5,193 31 5,032 79 200 00 200 00 22,940 89 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 (1,364 34) 9,000 00 9,000 00 125,130 93 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 56,552 27 55,267 70 55,906 50 698,727 71 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 84,261 68 29,000 00 29,000 00 518,163 34 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 35,283 38 20,000 00 25,000 00 258,189 71 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 179,765 78 113,467 70 119,106 50 1,623,152 58 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,522,618 33 1,262,696 42 1,281,111 22 16,500,333 55 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 655,166 06 621,277 00 618,635 00 9,511,434 41 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 10,070 20 18,000 00 18,000 00 172,084 93 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,864 93 19,836 00 19,836 00 260,205 85 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 12,500 16 15,000 00 15,000 00 169,605 22 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 58,890 87 41,000 00 40,000 00 608,573 36 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,588 00 4,461 67 4,461 67 89,950 23 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,742 77 15,000 00 20,000 00 160,911 11 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 60,096 80 55,000 00 55,000 00 693,331 63 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 6,738 99 11,000 00 11,000 00 130,527 36 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 135,761 15 125,000 00 125,000 00 1,516,324 16 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,092,419 93 1,043,574 67 1,044,932 67 14,704,948 26 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,522,618 33 1,262,696 42 1,281,111 22 16,500,333 55 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,112,256 00 1,092,419 93 1,043,574 67 1,044,932 67 14,704,948 26 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 430,198 40 219,121 75 236,178 55 1,795,385 29 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,588 00 4,588 00 4,588 00 (2,693 78) 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) (55,378 66) (55,000 00) (55,000 00) (793,373 29) 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) (173,783 52) (180,000 00) (180,000 00) (2,817,096 99) Capitalized Items (14,107 20) (130,784 58) (226,489 78) (210,992 10) (28,040 24) (15,000 00) (10,000 00) (635,413 90) 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 229,327.28 300,000 00 300,000 00 2,488,873 56 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) (56,655,44) (55,000 00) (1,000 00) (1,007,683 91) 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 457,845 99 326,299 92 402,356 72 120,046 84 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,753,245 97 2,079,545 89 2,481,902 61 OP ■ 1 I I 1 I M N 0 I NE I - I - 1111Nr r Cash Flows Actual 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 113,426 39 157,196.00 103,516 00 1,460,749 93 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 113,426 39 157,196 00 103,516 00 1,460,749 93 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 5,315 01 1,000 00 1,000 00 52,426 55 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 12,770 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 84,372.50 28,000 00 28,000 00 807,074 49 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 89,687 51 29,800 00 29,800 00 872,210 01 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 203,113 90 186,996 00 133,316 00 2,332,959 94 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 629 42 800 00 800 00 29,342.52 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 20,523 22 21,000 00 21,000 00 292,367 62 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 19,018 66 12,000 00 20,000.00 180,788.64 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 14,524 00 14,524 00 14,524 00 196,759.29 Other Operating Expense 537 76 483 00 461 00 461 00 461 00 461.00 461.00 994 40 994 40 994.40 500 00 500 00 7,308.96 Customer Accounts Expense 1,423 55 149 07 286 62 2,478.64 53 00 603 27 622 67 642 30 642 30 612 08 7,000 00 400 00 14,913.50 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 36,221.70 23,000.00 23,000 00 424,553.23 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 152,523 48 138,824 00 140,224 00 1,856,033.76 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 203,113 90 186,996 00 133,316 00 2,332,959.94 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 152,523 48 138,824 00 140,224 00 1,856,033.76 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 50,590 42 48,172 00 (6,908 00) 456,926.18 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 14,524 00 14,524 00 14,524 00 (73,183.40) 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,844 67) (13,000 00) (13,000 00) (179,898.04) 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) 12,564 62 (15,000 00) (15,000 00) (175,825.54) Capitalized Items (20,412 00) (10,143 00) (52,536.49) (86,598 46) (4,000 00) (42,755 04) 4,864 84 (7,000 00) (5,000 00) (223,580.15) 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 61,915.03 40,000 00 46,000 00 108,606 33 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 (1,207 84) (3,500 00) (1,000 00) (83,876 47) 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 189,406 41 124,196.00 79,616 00 97,911.95 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,633,538 61 1,757,734 61 1,837,350 61