Loading...
ERMU Financials 09-13-2005 I FINANCIAL INDEX II. Jul-05 FINANCIALS PAGE COMBINED BALANCE SHEET 1 I ELECTRIC INCOME STATEMENT 2 I WATER INCOME STATEMENT 3 IPROFIT AND LOSS NARRATIVE 4 CASH FLOW BY MONTH 5 I GRAPH #1 ELECTRICAL PURCHASES 6 I GRAPH #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 P 14 DETAILED WATER P & L WITH BUDGET INFORMATION 15 16 I 17 DETAILED CASH FLOW ELECTRIC 18 IDETAILED CASH FLOW WATER 19 I I lid 1 I COMBINED BALANCE SHEETS Jul-05 ‘111/ ASSETS ELECTRIC WATER I CURRENT ASSETS CASH &TEMPORARY INVESTMENTS (153,150.48) 368,432.82 ACCOUNTS RECEIVABLE 1,974,338.50 412,164.91 INVENTORIES 1,174,398.19 46,750.77 I PREPAID ITEMS 26,294.39 6,092.52 CONSTRUCTION IN PROGRESS 3,389.44 329,925.77 TOTAL CURRENT ASSETS 3,025,270.04 1,163,366.79 I RESTRICTED ASSETS EMERGENCY RESERVE FUND 95,000.00 CONSTRUCTION RESERVE FUND 1,259,548.67 891,594.52 ITOTAL RESTRICTED ASSETS 1,354,548.67 891,594.52 FIXED ASSETS PRODUCTION 2,339,142.74 9,113,605.37 I LFG PROJECT 3,048,596.31 TRANSMISSION 453,005.00 DISTRIBUTION 20,791,981.45 17,171,521.85 I GENERAL 9,155,590.15 714,345.29 FIXED ASSETS(COST) 35,788,315.65 26,999,472.51 LESS ACCUMULATED DEPRECIATION (13,163,087.80) (4,931,545.84) TOTAL FIXED ASSETS, NET 22,625,227.85 22,067,926.67 IOTHER ASSETS 23,500.97 99,445.13 TOTAL ASSETS 27,028,547.53 24,222,333.11 P LIABILITIES AND FUND EQUITY CURRENT LIABILITIES I ACCOUNTS PAYABLE 1,281,096.09 74,774.45 SALARIES AND BENEFITS PAYABLE 202,993.40 56,741.75 DUE TO CITY 35,515.28 DUE TO OTHER FUNDS 193,995.14 6,118.08 I BONDS PAYABLE-CURRENT PORTION 124,919.00 TOTAL CURRENT LIABILITIES 1,838,518.91 137,634.28 LONG TERM LIABILITIES I LFG PROJECT 2,454,947.36 DUE TO COUNTY 20,560.08 BONDS PAYABLE, LESS CURRENT PORTION 2,378,820.00 6,146,250.72 TOTAL LONG TERM LIABILITIES 4,854,327.44 6,146,250.72 ITOTAL LIABILITIES 6,692,846.35 6,283,885.00 FUND EQUITY I CONTRIBUTED CAPITAL RETAINED EARNINGS 20,335,701.18 17,938,448.11 TOTAL FUND EQUITY 20,335,701.18 17,938,448.11 ITOTAL LIABILITIES&FUND EQUITY 27,028,547.53 24,222,333.11 I. I .... E -•- N I M MN ME E = OM E - ir ELECTRIC I E STATEMENT ERMU Income Statement 2005 2005 2005 TOTAL 2004 2004 JULY YEAR TO DATE BUDGET JULY YEAR TO DATE Electric REVENUE Operating Revenue Elk River 1,405,429.67 6,925,705.80 12,420,517.00 1,158,015.91 6,325,823 56 Elk River-City Donated 16,710.39 84,080.88 108,102.00 14,184 05 55,862.80 Otsego 115,507.10 555,988 52 969,981.00 98,008 76 526,412 05 Rural Big Lake 24,611.52 119,094 80 246,732 00 18,915.96 111,977 89 Dayton 16,698 18 88,036 34 147,611 00 13,598.85 82,037 09 Public St&Hwy Lighting 14,694.10 102,591.87 174,678 00 14,128.79 99,081.76 Service Charge - - Generation Credit 29,098.18 205,069.96 349,992.00 29,079.55 203,540.86 Dispersed Generation Credit (9,862 50) (14,362.50) (71,176.00) (13,775.00) (33,67.6.00) Additional Revenue/CIP&Rate Increase - 216,000 00 - Total Operating Revenue 1,612,886.64 8,066,205.67 14,562,437 00 1,332,156.87 7,371,060 01 Other Operating Revenue Interest/Dividend Income 1,903.62 11,652.76 5,000 00 361.71 37,221 14 Customer Penalties11,574.48 75,664.81 115,212.00 11,676.10 63,395.80 LFG Protect 58,481.96 412,769.32 700,000.00 58,439.75 407,727.41 Connection Fees 2.0,670 00 295,119.70 350,000.00 33,977.38 262,183.99 Misc Revenue (Includes Security) 7,896.56 142,071.34 125,085.00 3,833.62 53,985.60 Total Other Revenue 100,526 62 937,277.93 1,295,297.00 108,288.56 ' 824,513.94 REVENUE TOTAL 1,713,413 26 9,003,483.60 15,857,734.00 1,440,445 43 8,195,573.95 EXPENSES Purchased Power 1,267,977.77 5,661,361 91 9,601,772 00 1,157,019.04 5,155,221.43 Operating&Mtce Expense 3,849.82 99,195 69 216,785.00 14,118 93 91,640.84 Landfill Gas 20,328.50 158,383 15 281,200.00 20,261 42 139,259.58 Distribution Expense 7,263.91 87,919 27 187,000.00 21,664.20 108,816.26 Maintenance Expense 45,943.94 375,558.30 607,726.00 61,721.03 392,914.39 Depreciation 118,000.00 802,000.00 1,130,000.00 70,225.00 502,900 00 Interest Expense 4,588.00 67,262.89 109,522 00 351.33 2,459 31 Other Operating Expense (Includes Security) 14,915.61 83,651.36 32,132.00 5,459 93 6,450.25 Services to the City 64,264 21 402,189 29 666,857 00 28,578 03 256,172.51 Customer Accounts Expense 6,704.34 81,837.58 126,000 00 7,787.73 _ 74,805 27 Administrative&General Expense 103,505 56 938,578 79 1,443,413.00 135,659 58 909,576 61 Total Expenses(before Operating Transfers) 1,657,341 66 8,757,938 23 14,402,407.00 1,522,846.22 7,640,216.45 TOTAL REVENUES 1,713,413 26 9,003,483.60 15,857,734.00 1,440,445 43 8,195,573.95 TOTAL EXPENSES 1,657,341.66 8,757,938.23 14,402,407.00 1,5.2.2,846.22 7,640,216.45 OPERATING TRANSFER NET INCOME PROFIT(LOSS) 56,071 60 245,545.37 1,455,327.00 (82,400.79) 555,357 50 I _ —A&_ 1.1 M. _ _ _ MIN 112 I= NM M _ _ _ C _ 111, WR INCOME STATEMENT ERMU Income Statement 2005 2005 2005 TOTAL 2004 2004 JULY YEAR TO DATE BUDGET JULY YEAR TO DATE Water REVENUE Operating Revenue Water Sales 169,861.67 624,963.98 1,443,534.00 157,695.77 592,517.41 Total Operating RevenL. 169,861.67 624,963.98 1,443,534.00 157,695.77 592,517.41 Other Operating Revenue Interest/Dividend Income 4,155.54 22,029.39 15,000.00 (2,000.00) 4,000.00 Customer Penalties 989.14 5,920.57 7,800.00 1,018.99 4,785.81 Connection Fees 51,4.73.00 542,097.70 471,200.00 6.4,48.0.0.0 576,397.59 Misc Revenue (61.78) - Total Other Revenue 56,617.68 569,985.88 494,000.00 63,498.99 585,183.40 REVENUE TOTAL 226,479.35 1,194,949.86 1,937,534.00 221,194.76 1,177,700.81 EXPENSES Production Expense 13,745.95 22,196.19 10,000.00 2,147.16 6,846.29 Pumping Expense 15,400.32 173,670.43 258,818.00 30,001.65 144,687.44 Distribution Expense 14,534.79 102,473.53 165,043.00 17,202.25 103,073.39 Depreciation 60,000.00 410,000.00 600,000.00 15,500.00 110,000.00 Interest Expense 14,524.00 124,139.29 276,049.00 5,371.36 37,599.52 Other Operating Expense 461.00 3,325.76 10,092.00 785.42 5,447.69 Customer Accounts Expense 622.67 5,616.82 18,101.00 908.30 7,873.21 Administrative & General Expense 31,147.68 281,829.00 280,134.00 24,903.66 161,487.97 Total Expenses (before Operating Transfers) 150,436.41 1,123,251.02 1,618,237.00 96,819.80 577,015.51 TOTAL REVENUES 226,479.35 1,194,949.86 1,937,534.00 2.21,194.76 1,177,700.81 TOTAL EXPENSES 150,43.6.41 1,123,251.02 1,618,237.00 9.6,819.8.0 577,015.51 OPERATING TRANSFER - 20,000.00 30,868.00 - 21,519.00 NET INCOME PROFIT (LOSS) 76,042.94 51,698.84 288,429.00 124,374.96 579,166.30 I Ili I PROFIT AND LOSS NARRATIVE ELECTRIC IThe Operating Revenue for July 2005 reflects a much warmer month than the prior year. Revenues are up $300,000 and kilowatt hours are up 4,500,000 from a year ago. IOther Operating Revenue has a slight decrease from a year ago. Connection Fees are down in July 2005 as compared to the prior year by $13,000, while Miscellaneous I Revenue is up $4,000 and Interest Income is up $1,600 (due to the maturity of 2 Certificates of Deposit.) I The purchased power cost is also up from a year ago due to the warmer weather. The margin is much better though ($344,000 this year compared to $175,000 last year) and this is directly reflected in the bottom line. Most of the expenses are down from last year I with the exception of Depreciation, Interest, and Services to the City, all of which have consistently been higher this year due to larger monthly accruals. Other Operating Expense is also higher due to the Security Systems expenses component of this item. IWATER The Operating Revenue is up slightly from a year ago. The number of gallons used is PI down by 4,000,000 from the prior year but the unit cost is increased and so the revenues are still higher. I Other Operating Revenue has a slight decrease from a year ago just as in the Electric Department. From the prior year, Connection Fees are down $13,000 and Interest Income is up $6,000 (due to the maturity of 2 Certificates of Deposit.) IProduction expense for July 2005 is $11,000 over July last year due to the maintenance of the Hillside Water Tower. The largest expense for water continues to be depreciation. I Interest expense is increased over July last year due to the larger accrual, and Administrative expense is increased over July last year due to the 25% sharing of overhead costs being consistently applied. 1 :IF 1 '4 1411/ I Q it I'', ---i- — — — f - 1 I-:- j Ci 1—r - -- - -- -- ---- --- – +-- jII I 4 � 1 o CI. .., IN I 1I O m0 b' O t0 O m m N �M I ' m O O N m', O m m N N d p Yf d O m d O d m b M M I O N 0 4 b. o,' Y o v+ o u� d co d . o o 11 N -0 S'I V O1 8 O O •- co- m O Oi 0 ^ ill N O (NJ N b M A m N n Lu yy I T �' O O m - ---i b O b Obi O O .- N -f M O O m 1 m O m O H N O N b M Ot O m O b O d �Si O d Ot O C O I N d m N N m h bN O co 315 Q YI M 0oiO Mm rno ^ o m m Lo o FN o b o I a f N OON m, b Ob Mr,....-_, O r O 4 �I e m o a m co n T d_-! - O b - ! : : : ! N ^I b M. 0) t7 : : , f d N NM O m? O N N ON OI N O 0 N 2. 9 N m d N 8' 8 8 N a cc SII N m I 00 ¢ `- a N ° n rn do e 1 m N m ._ b � O — « - � .- b NI cn en U. QOO m a O N m b MI O� N _ N O. '`.4:3 O m O m b O CO N I N I ,^ N M O �O O O O m . O DIb VS Q N d d O O� O O� O� m N m M CO d' N b' b O N N d m. d N 0- f4 U M I N m mCO .- m d O m N <`; N N b 0 M CO N O ^1 N O m N -t b n 0 CO ' 0 CO aa COd Rd . 0 CO r F1 m o m I QGll m a. o m d' Oi - O T m o rno b 0- o O• m cc N m N b .- mNN O M N ma mM N MNOi mb 74 COM p O N I ^ o M1 o M OOO ul Ton m O O ^b Or N CO O N ol- O O O O pMd N IN m M m0 tO NON ‘7,, rI �. m O I I YQ 01 co,Oo �I O M r d O rNNml OO o m tIm' db O >zI' °! z �1 2 O w z o > o 2. oI 1 r- I 1 w Z1a N, w w I w = N o wl w w ON WlE. 01 ca QIre w' w a > 0 0 re 1 w a ' ? < Z ryryry- UI wa Ur' xw ' F J i SI wI OI �j• I - ' 1 E Wz 01 d . iq) z z wzwI 2 Qw _ Qm U 1hItL Ww ,_' � W _, _ N t— 71 ' i 0 0 0 0 a o 0 0 f o 0 0 n H m o o j o o o o o o im cc W U OLL Of o o o C o W' a o 01 o ro o o o W ��Ii Y CV pi O' p ?I LL 5 I 110 ELk River Municipal Utilities Monthly Electrical Demand I 50 I 45 2 40 I - 35 2005 - - . 'v C ' 30 as • tv 25 % - - CI . w 2004 20 I 15 i 1 I l I I I I 1 1 ���, �`�e. 6c• PQM` \,V ��� ,��� �J� ����e ��o��` �,���I e'e GP O Months I PO Elk River Municipal Utilities Monthly Energy Purchases I22,000 1 = 21,000 I1 20,000 .= 19,000 N 18,000 I217,000 �. . ,„3 16,000 a. 15,000 a •2005 - - - 2004 �, ' I cn 14,000 ` - - • i c . ' w 13,000 I12,000 �J4.\ cJ0 Jacor PQM` 0\ ,Ne) ���� JAI". 0'06 OG�oVec ,��'06 ��N0c I (<6' P eft 4o 00 Month • I 110 Elk River Municipal Utilities Monthly Total Electric Load I22,000 20,000 I 18,000 ` 2005 16,000 r �. I 0 _ ` u14,000 •, . 0 • I • + I •0 I I 0 Id 12,000 .. ' 1w • 2004 10,000 I8,000 I I I 1 I I I �Jac1 ��c1 a�Gr PQM\ tae ,Jc.O ,,-1J�,S; ���c �o��c �,°0i F�°ck I es. t<ma P °9 .\-\°O° o o 0dB Month c' 1 pElk River Municipal Utilities Monthly Electric Sales $1,800,000 I $1,600,000 • $1,400,000 • • • I eev 4,-- + • $1,200,000 rpps , + , G $1,000,000 • • . • a $800,000 • ' • v) $600,000 2004 I $400,000 $200,000 I $0 , 1 I I I I I c � M �a � J4.# Q `). .0e43e e I � F0 P4oG ,0 � c,0Q \-\0 00 Month t I 111. ELk River Municipal Utilities Monthly Residential, Commerical 1 & Industrial Loads 12,000 I10,000 Industrial , I 1 8,000 ` - ' . . . - . ` • E 6,000 : + \ • ' , . • . + MI . I y c 2005 - ' R - e. ' 4000 3 , ' 2004 I 2,000 - _ . . . . Commerical �0 0 ��6 Q� �`q� �J� N \ Jew ,peg ,Qe' ,oe� ,Q6 �• Few 4• \'' 049 049 Ode oA°� 'CP I g O Month p Elk River Municipal Utilities Monthly Residential, Commerical I & Industrial Sales $900,000 I $800,000 $700,000 Industrial I 12 $600,000 . '�t . .:° . ` . - _ - p $500,000 - • $400,000 - U4I� / ` ` , ' iiiilltA tI 43 o $300,000 2005 • 2004 $200,000 $100,000 ---"---7-' ' ',--4.:••.'." . r '' ` - Commerical $0 I I , 1 I 1 , 1 I , I I0 0 ccr QMa . \ N>4. �c ,, ,o'; � �0 �aPso � eoe aFe Q' eG -0ce coo9 \4,o 46 110 - — Month 1 I I 1411 Elk River Municipal Utilities Monthly Water Pumpage 140 • 120 — 100 c ++ 1 £ 40 _ .I d ,r r r . • A r. �. rt 20 ... )a�Ja6 ��`Jac1 �a��r PQM\ �a� )J�° )J�� P�Jy� tie���` a�o�ec e pec pec e9I oe I Month Elk River Municipal Utilities Peak DayPumpage p I 6 1 Tti5 � #^ 0 4 -0: • c x 1 s . C 3 ' ' *, , ICI I 0 c•\)aA �cJac1 �a`" N-V17.\' )J\ J(1, eF�e` 0���0` �F�e` c�e� qa P coeQt 0 0° eco 1411 Month I I I Ill/ Elk River Municipal Utilities Monthly Water Sales I 140 I 120 100 ,.E . I ° 80 i __ 60 •ca " •. Ts cn 40 . III i • INI . w 1 20 ' / , , Q��<< P PJ0 �e9'0 O°�o �oJ�F O000c�` I Month • Elk River Municipal Utilities Monthly Water Sales I $300,000 $250,000 .r ea $200,000 , $150,000 , •,. - I CD M $100,000 I $50,000 - r $0 a� .o`er 4 J e �` �� e� Fo P So9� p ‘4° Oou Month _ed sillI9:16 M I - E Milk IVP M11111.1 U7 I ET. IMMINMAlike ARP Fiscal Year Budget Fiscal ear 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 609,818.07 2,921,337.22 59.11 % 411,857.00 4,942,279.00 2,020,941.78 2,509,866.59 4,526,546.96 61-0440-4412 ELECT SALES/ER NON-DEMAND 137,316 17 923,415.86 65.61 % 117,280.00 1,407,359.00 483,943 14 684,524.31 1,275,229 51 61-0440-4413 ELECT SALES/ER DEMAND 656,033.95 3,065,185.00 50.72% 503,650.00 6,043,797.00 2,978,612 00 3,116,048.79 5,648,048 79 61-0440-4414 ELECT SALES/ELK RIVER SEC LTS 2,261.48 15,767.72 58.22% 2,257 00 27,082.00 11,314 28 15,383.87 26,694.39 61-0440-4415 ELECT SALES/ER CITY DONATED 16,710.39 84,080.88 77.78% 9,008.00 108,102.00 24,021.12 55,862.80 120,687 44 61-0440-4416 ELECT SALES/OTSEGO RES 77,158 43 388,342.21 56 72% 57,058.00 684,696.00 296,353 79 353,081.54 633,900 55 61-0440-4417 ELECT SALES/OTSEGO NON-DEMAND 21,242 66 86,784.80 59 37% 12,182.00 146,188.00 59,403.20 74,439.73 141,065.14 61-0440-4418 ELECT SALES/OTSEGO DEMAND 16,378.61 75,844 55 58 34% 10,833.00 130,000.00 54,155.45 93,719.00 133,175.77 61-0440-4419 ELECT SALES/OTSEGO SEC LTS 727.40 5,016 96 55 15% 758 00 9,097.00 4,080.04 5,171.78 804 61 61-0440-4421 ELECT SALES/BIG LAKE RES 23,647.75 114,677 19 47.83% 19,978 00 239,741.00 125,063.81 108,345.94 194,656.99 61-0440-4422 ELECT SALES/BL NON-DEMAND 826.07 3,371.20 64 62% 435 00 5,217.00 1,845.80 2,621.85 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 985.40 55.55% 148.00 1,774.00 788.60 1,010.10 1,731.60 61-0440-4431 ELECT SALES/DAYTON RES 14,583.18 75,719.85 59.70% 10,569.00 126,831.00 51,111.15 69,709.46 123,160.31 61-0440-4432 ELECT SALES/DAYTON NON-DEMAND 1,765.85 9,817.24 59.14% 1,383.00 16,600.00 6,782.76 9,811.28 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 349.15 2,499.25 59.79% 348.00 4,180.00 1,680.75 2,156.75 3,590.15 61-0440-4441 PUBLIC ST&HWY LIGHTING/CITY 14,694.10 102,591.87 58.73% 14,556.00 174,678.00 72,086.13 99,081.76 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 432.18 4,407.96 73.47% 500.00 6,000.00 1,592.04 3,206.11 7,464.81 61-0440-4551 GENERATION CREDIT 28,666.00 200,662.00 58.33% 28,666.00 343,992.00 143,330.00 200,334.75 285,794.82 61-0440-4552 DISPERSED GENERATION CREDIT (9,862.50) (14,362.50) 20.18% (5,931.00) (71,176.00) (56,813.50) (33,676.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,612,886 64 8,066,205.67 55 39% 1,213,535 00 14,562,437 00 6,496,231 33 7,371,060 01 13,255,912.19 INTEREST INCOME 61-0460-4691 INTEREST&DIVIDEND INCOME 1,903.62 11,652.76 233.06% 417.00 5,000.00 (6,652.76) 37,221.14 25,703.79 TOTAL INTEREST INCOME 1,903.62 11,652 76 233 06% 417 00 5,000 00 (6,652 76) 37,221 14 25,703 79 OTHER OPERATING REVE 61-0470-4700 OTHER OPERATING REVENUE 5,344.35 73,711.38 175.15% 3,507.00 42,085.00 (31,626.38) 21,067.28 38,719.93 61-0470-4701 CUSTOMER DELINQUENT PENALTIES 11,574.48 75,664.81 65.67% 9,601.00 115,212.00 39,547.19 63,395.80 118,910.23 61-0470-4702 DISCONNECT&RECONNECT CHARGE 20,670.00 295,119.70 84.32% 29,167.00 350,000.00 54,880.30 262,183.99 574,156.05 61-0470-4703 MISC ELEC REVENUE-TEMP CHG 0.00 2,200.00 110.00% 167.00 2,000.00 (200.00) 800.00 1,200.00 61-0470-4704 STREET LIGHT 0.00 14,989.21 74.95% 1,667.00 20,000.00 5,010.79 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 58,481.96 412,769.32 58.97% 58,333.00 700,000.00 287,230.68 407,727.41 701,371.49 61-0470-4722 MISC NON-UTILITY 2,370.19 50,235.09 86.61 % 4,833.00 58,000.00 7,764.91 12,874.76 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 182.02 546.06 109.21 % 42.00 500.00 (46.06) (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 98,623 00 925,625 17 71 74% 107,525.00 1,290,297.00 364,671.83 787,292 80 1,518,732 60 TOTAL ELECTRIC 1,713,413 26 9,003,483 60 56 78% 1,321,477 00 15,857,734 00 6,854,250 40 8,195,573 95 14,800,348 58 -ed SiElell9:16:1110 NM E - EL IV MII- U I IE� II= NM e 211. Fiscal Year 20 Budget Fiscal ear 2004 Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total Revenue (Continued) TOTAL Revenue 1,713,413.26 9,003,483.60 56.78% 1,321,477.00 15,857,734.00 6,854,250.40 8,195,573.95 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 1,833 09 21,303.38 49.91 % 3,557.00 42,680.00 21,376.62 24,015.09 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 244.85 10,293.78 270.89% 317.00 3,800.00 (6,493.78) 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 0.00 14,627.43 48.73% 2,502.00 30,020.00 15,392.57 16,948.40 29,056.21 61-0540-5484 OTHER EXP/PLANT SUPPLIES-ETC 543 48 12,687.84 50.75% 2,083.00 25,000.00 12,312.16 17,176.47 29,374.69 61-0540-5491 MISC OTHER PWR GENERATION EXP 0.00 3,692.13 34.19% 900.00 10,800.00 7,107.87 7,192.06 11,715.41 61-0540-5521 MAINTENANCE OF STRUCTURE/PLANT 806.00 10,979.42 61.34% 1,492.00 17,900.00 6,920 58 9,381.37 19,940.33 61-0540-5531 MTCE OF ENGINE5/GENERATORS-PL 364.00 16,025.94 35.61 % 3,750.00 45,000.00 28,974.06 11,377.42 17,758.84 61-0540-5541 MTCE OF PLANT/LAND IMPROVEMENT 58.40 1,838.06 45.95% 333.00 4,000.00 2,161.94 1,913.85 3,823.91 61-0540-5551 PURCHASED POWER 1,259,221.27 5,601,608.62 58.89% 792,730.00 9,512,763.00 3,911,154.38 5,098,780.83 8,563,297.85 61-0540-5552 OTHER PURCHASED POWER 8,756 50 59,714 88 67.09% 7,417.00 89,009.00 29,294.12 56,440 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,271,827.59 5,752,777.60 58 59% 818,213 00 9,818,557.00 4,065,779.40 5,246,862.27 8,863,561 13 LANDFILL GAS 61-0550-5051 LANDFILL GAS EXP 20,328.50 139,344 50 54.01 % 21,500.00 258,000.00 118,655.50 117,418.13 219,178.10 61-0550-5052 LFG ADMIN 0.00 3,958.65 64.90% 508.00 6,100 00 2,141.35 5,021.45 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 20,328 50 158,383.15 56.32% 23,433 00 281,200 00 122,816 85 139,259 58 241,362 66 DISTRIBUTION EXPENSE 61-0580-5801 REMOVE EXISTING SERV&METERS 69.04 1,532.07 255.34% 50.00 600.00 (932.07) 336.22 1,349.56 61-0580-5831 TRANSFORMER EX/OVERHD&UNDER( 510.16 5,753.57 71.92% 667.00 8,000.00 2,246.43 4,324 93 9,448.54 61-0580-5851 MTCE OF SIGNAL SYSTEMS 102.25 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 945.42 8,109.08 20.27% 3,333.00 40,000.00 31,890.92 5,965.90 10,330.32 61-0580-5871 TEMP SERVICE-INSTALL&REMOVE 403.81 3,261.21 60.39% 450.00 5,400.00 2,138.79 2,302.11 2,733.72 61-0580-5881 MISC DISTRIBUTION EXPENSE 5,233.23 68,947.53 53.04% 10,833 00 130,000.00 61,052.47 94,750.94 124,700.00 TOTAL DISTRIBUTION EXPENSE 7,263 91 87,919 27 47.02% 15,583.00 187,000.00 99,080 73 108,816 26 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,157.92 16,824.08 64.71 % 2,167.00 26,000.00 9,175.92 17,381.28 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 4,190.91 87,153.54 87.15% 8,333.00 100,000.00 12,846.46 129,376.56 174,707.81 61-0590-5932 MTCE OF OVERHD LINES/STANDBY 2,086.46 19,989.98 76.67% 2,173.00 26,074.00 6,084.02 15,360.45 25,593.05 61-0590-5933 MTCE OF OVERHEAD 3,673.08 31,565.68 56.37% 4,667.00 56,000.00 24,434.32 12,502.04 33,595 00 61-0590-5941 MTCE OF UNDERGROUND/DISTRIB 3,910.88 52,154.08 80.86% 5,375.00 64,500.00 12,345.92 47,294.61 104,193.36 61-0590-5951 MTCE OF LINE TRANSFORMERS 646.24 9,322.02 58.26% 1,333.00 16,000.00 6,677.98 5,598 08 7,498.60 61-0590-5961 MTCE OF STREET LIGHTING 3,791.59 14,346.13 44.42% 2,692.00 32,300.00 17,953.87 16,643.60 37,804.69 imird S 9.16._ E NM EL IVIRIM IU 1 IE� Mill IIM � ale 31111 Fiscal Year 20I- Budget Fiscal ear 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 223 56 2,385.30 41.88% 475 00 5,695 00 3,309.70 3,130.56 6,426 97 61-0590-5971 MTCE OF METERS 11,987.02 36,332.85 85.49% 3,542.00 42,500.00 6,167.15 30,726.05 48,469 36 61-0590-5972 VOLTAGE COMPLAINTS 467.73 3,145.70 63.04% 416.00 4,990.00 1,844.30 2,978.20 6,179.63 61-0590-5981 SALARIES/TRANS&DISTRIBUTION 792.11 11,010.63 47.89% 1,916.00 22,990.00 11,979.37 13,722.21 21,981 73 61-0590-5991 MTCE OF OVERHEAD SERVICE/2NDRY 544.18 3,919.27 21.19% 1,542.00 18,500.00 14,580.73 7,241.81 13,146.74 61-0590-5992 MTCE OF UNDERGROUND ELEC SERV 6,852.06 25,934.25 61.60% 3,508.00 42,100.00 16,165.75 18,243.12 38,351.38 61-0590-5995 TRANSPORTATION EXPENSE 5,620 20 60,065.68 41 40% 12,090.00 145,077.00 85,011.32 72,394.12 119,803.00 TOTAL MAINTENANCE EXPENSE 45,943 94 375,558 30 61.80% 50,645 00 607,726 00 232,167.70 392,914 39 664,420 76 DEPRECIATION/ELECTRI 61-0595-8031 DEPRECIATION/ELECTRIC 118,000.00 802,000.00 70.97% 94,167.00 1,130,000.00 328,000.00 502,900.00 1,427,091 00 TOTAL DEPRECIATION/ELECTRI 118,000 00 802,000 00 70 97% 94,167 00 1,130,000 00 328,000.00 502,900 00 1,427,091 00 INTEREST EXPENSE 61-0596-8071 INTEREST ON BONDS/LONG TERM 4,588.00 67,262.89 61.42% 9,127.00 109,522.00 42,259.11 2,459.31 87,544.63 TOTAL INTEREST EXPENSE 4,588 00 67,262.89 61 41 % 9,127 00 109,522.00 42,259.11 2,459 31 87,544.63 OTHER OPERATING EXPE 61-0597-8161 COST&EXP MERCH JOBBING/ELEC 0.00 0.00 0.00"A, 0.00 0.00 0.00 0.00 0.00 61-0597-8172 EXPENSE-NON-UTILITY OPERATIONS 14,905.61 80,765.87 538.44% 1,250.00 15,000.00 (65,765.87) 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 31,909.02 189,834.10 64.35% 24,583.00 295,000.00 105,165.90 156,172 51 294,698.18 61-0597-8262 TRANSFER TO CITY 3%ER REVENUE 30,000.00 210,000.00 56.47% 30,988.00 371,857.00 161,857.00 100,000.00 340,564.28 61-0597-8263 OTHER DONATIONS 2,355.19 2,544.39 36.35% 583.00 7,000.00 4,455.61 6,159.23 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 70 00 53.03% 11.00 132.00 62.00 66.36 0.28 61-0597-8311 OTHER INTEREST EXPENSE 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0 00 61-0597-8341 INTEREST PD ON METER DEPOSITS 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0 00 61-0597-8399 OPERATING TRANSFER/OTHER FUNDS 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00 TOTAL OTHER OPERATING EXPE 79,179 82 485,840 65 69.51 % 58,248 00 698,989.00 213,148 35 262,622 76 673,539 63 CUSTOMER ACCOUNTS EX 61-0900-9021 METER READING EXPENSE 5,529.13 51,356.70 88.55% 4,833.00 58,000.00 6,643.30 32,090.08 61,445.70 61-0900-9030 COLLECTING EXP DISC/RECONNECT 2,065.77 9,015.95 37.57% 2,000 00 24,000.00 14,984.05 13,003.68 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 0.00 656.17 2.73% 2,000.00 24,000.00 23,343.83 5,880.47 14,350 85 61-0900-9061 CUST BLGS NOT PD/SENT FOR COLL (890.56) 20,205.23 101.03% 1,667.00 20,000 00 (205.23) 23,831.04 23,136.04 TOTAL CUSTOMER ACCOUNTS EX 6,704.34 81,837.58 64 95% 10,500.00 126,000.00 44,162 42 74,805 27 121,135 69 ADMINISTRATIVE &GEN 61-0920-9201 SALARIES/OFFICE&COMMISSION 20,570.48 157,214.98 49.13% 26,667.00 320,000.00 162,785.02 177,887.35 293,406.22 61-0920-9211 OFFICE SUPPLIES&EXPENSE 8,076.68 57,212 61 95.35% 5,000.00 60,000.00 2,787.39 49,482.28 63,261.27 61-0920-9212 LT&WATER CONSUMPTION/OFFICE (17.10) 4,696.54 92.09% 425.00 5,100.00 403.46 2,259 02 6,468.39 61-0920-9213 BANK CHARGES 565.34 4,281.29 73.33% 486.00 5,838.00 1,556.71 3,454.49 5,281.27 61-0920-9221 LEGAL FEES 0.00 2,234.28 27.93% 667.00 8,000.00 5,765.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 W 1.1d SeMe 16:_ 11.1 IIIII = EL <IVPRIM IS IPIRFUTM Er' M Mil MI iiiii illge 4 all Fiscal Year 200r.' 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 79.36 70,304.34 58.68% 9,983.00 119,800 00 49,495.66 79,922.01 123,171.81 61-0920-9261 UTIL SH OF MEDICAUDENTAUDISA 16,086.57 118,206.98 60.46% 16,292.00 195,500 00 77,293.02 98,696.46 165,072.24 61-0920-9262 UTILITY SHARE OF PERA 11,005.28 91,746.07 105.82% 7,225.00 86,700.00 (5,046.07) 49,622.81 83,018.53 61-0920-9263 UTILITY SHARE OF FICA 10,286.62 75,085.22 68.26% 9,167 00 110,000.00 34,914.78 72,286.77 109,136.19 61-0920-9264 EMPLOYEES SICK PAY 1,216.55 24,571.58 61.43% 3,333.00 40,000.00 15,428.42 29,835 18 49,281.05 61-0920-9266 EMP VACATION/HOLIDAY PAY 15,881.51 73,765.19 54.64% 11,250.00 135,000.00 61,234.81 102,747 87 186,939.39 61-0920-9268 MISCELLANEOUS (10,930.58) 36,941.45 369.41 % 833.00 10,000.00 (26,941.45) 0.00 (0.58) 61-0920-9269 CONSERVATION IMP PROGRAM 13,822.55 105,960.51 72.58% 12,167.00 146,000 00 40,039.49 121,603.40 162,348.92 61-0920-9281 ENVIRONMENTAL COMPLIANCE 556.32 5,456.19 43.65% 1,042.00 12,500.00 7,043.81 7,762.55 14,601.54 61-0920-9291 CONSULTING FEES 5,681.05 20,306.60 67.69% 2,500.00 30,000.00 9,693.40 17,704.67 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 843.17 6,286.05 47.26% 1,108.00 13,300.00 7,013.95 6,021.81 10,104.73 61-0920-9302 ADVERTISING 1,595.95 9,356.65 44.56% 1,750.00 21,000.00 11,643.35 9,794.17 16,460.74 61-0920-9303 DUES&SUBSCRIPTIONS-FEES 436.00 25,514.52 91.12% 2,333.00 28,000.00 2,485.48 17,867.60 22,699.20 61-0920-9304 TRAVEL EXPENSE 0.00 3,219.87 80.50% 333.00 4,000.00 780.13 957.95 957.95 61-0920-9305 SCHOOLS&MEETINGS 7,749.81 42,756.09 61.56% 5,788.00 69,450.00 26,693 91 47,534.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 238.99 18,806.34 TOTAL ADMINISTRATIVE&GEN 103,505 56 946,358.79 65 56% 120,284 00 1,443,413.00 497,054 21 909,576 61 1,443,455 89 TOTAL ELECTRIC 1,657,341 66 8,757,938 23 60.81 % 1,200,200 00 14,402,407 00 5,644,468.77 7,640,216.45 13,672,576 19 TOTAL Expense 1,657,341.66 8,757,938.23 60.81 % 1,200,200.00 14,402,407.00 5,644,468.77 7,640,216.45 13,672,576.19 PROFIT/(LOSS) : 56,071.60 245,545.37 121,277.00 1,455,327.00 1,209,781.63 555,357.50 1,127,772.39 Date Range: 7/1/2005 To 7/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 _edSMIc9:161.111 imii im MI ELI\ M I U1 IE� MI ge 11101. Fiscal Year 20 Budget Fiscal ear 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 4,155 54 20,529.39 171.08% 1,000.00 12,000 00 (8,529.39) 0.00 31,024 00 62-0460-4692 OTHER INT/MISC REVENUE 0.00 1,500.00 50.00% 250.00 3,000 00 1,500 00 4,000.00 4,000 00 TOTAL INTEREST INCOME 4,155 54 22,029 39 146 86% 1,250.00 15,000.00 (7,029 39) 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 169,861.67 624,963.98 43.29% 120,294.00 1,443,534.00 818,570.02 592,517.41 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 169,861 67 624,963 98 43.29% 120,294 00 1,443,534.00 818,570.02 592,517 41 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 989.14 5,920.57 75.90% 650.00 7,800.00 1,879.43 4,785.81 7,897.45 62-0620-6401 WATER/ACCESS/CONNECTION FEES 47,500.00 504,107.50 119.68% 35,100.00 421,200 00 (82,907.50) 521,046.88 839,910 80 62-0620-6402 MISC CONNECTION FEES 3,973.00 37,990.20 75.98% 4,167.00 50,000.00 12,009.80 55,350.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 52,462 14 547,956 49 114 40% 39,917 00 479,000 00 (68,956 49) 581,183 40 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 226,479.35 1,194,949 86 61.67% 161,461.00 1,937,534 00 742,584.14 1,177,700.81 3,639,571 49 TOTAL Revenue 226,479.35 1,194,949.86 61.67% 161,461.00 1,937,534.00 742,584.14 1,177,700.81 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 21,519.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 21,519 00 33,897 00 WATER PRODUCTION EXP 62-0700-7021 MTCE OF STRUCTURES 13,745.95 22,196.19 221.96% 833.00 10,000.00 (12,196.19) 6,846.29 29,341.95 TOTAL WATER PRODUCTION EXP 13,745.95 22,196 19 221.96% 833.00 10,000.00 (12,196.19) 6,846 29 29,341 95 PUMPING EXPENSE 62-0710-7101 SUPERVISION 536.60 12,317.60 50 44% 2,035.00 24,418.00 12,100.40 13,558.58 22,662.26 62-0710-7181 SUPPLIES&EXPENSE 2,906 83 76,737.24 41.37% 15,458.00 185,500 00 108,762.76 95,148.30 174,078.63 62-0710-7201 MTCE OF ELECT PUMPING EQUIP 1,682.32 3,450.82 76.68% 375.00 4,500.00 1,049.18 1,580.44 4,149 39 62-0710-7220 MTCE OF WELLS 10,274.57 81,164.77 182.80% 3,700.00 44,400.00 (36,764.77) 34,400.12 81,336.83 01 Milled 511111 9:161 11111 MN M EMIR IV. MI U ilillIIIIIMIIE. Alike 2I Fiscal Year 20 Budget Fiscal ear 2004 Account Account Name Current Year To Date %Used Current Total Remaining Year To Date Total Expense (Continued) WATER PUMPING EXPENSE TOTAL PUMPING EXPENSE 15,400 32 173,670 43 67 10% 21,568 00 258,818 00 85,147.57 144,687 44 282,227 11 WATER DISTRIBUTION E 62-0730-7301 MTCE OF WATER MAINS 1,532.22 5,675.28 29.87% 1,583.00 19,000.00 13,324.72 15,372.59 26,134.94 62-0730-7311 MTCE OF WATER SERVICES 2,688 22 21,438.05 42.88% 4,167.00 50,000.00 28,561.95 26,851.03 40,785.67 62-0730-7321 MTCE OF CUSTOMERS SERVICE 2,811 11 20,218.13 70.94% 2,375.00 28,500.00 8,281.87 22,942.29 36,009.03 62-0730-7331 MTCE OF WATER HYDRANTS 1,124.75 2,050.31 25.47% 671.00 8,050.00 5,999 69 5,799.12 9,382.31 62-0730-7341 MISC WATER EXPENSE/INVENTORY 53.06 626.39 40.41 % 129.00 1,550.00 923.61 186.19 155.69 62-0730-7391 WAGES/WATER 214.64 4,927.03 38.49% 1,067.00 12,800.00 7,872.97 5,423.43 9,064 89 62-0730-7395 TRANSPORTATION EXPENSE 4,426.42 28,263.36 171.29% 1,375.00 16,500.00 (11,763.36) 8,684.59 20,938.35 62-0730-7399 GENERAL EXP/WATER PERMIT 0.00 5,111.00 85.18% 500.00 6,000.00 889.00 5,736.00 5,746 00 TOTAL WATER DISTRIBUTION E 12,850.42 88,309 55 62 02% 11,867.00 142,400.00 54,090 45 90,995 24 148,216 88 WATER ACCOUNTING EXP 62-0740-7431 METER READING EXPENSE 1,684.37 14,163.98 62.55% 1,887.00 22,643.00 8,479.02 12,078.15 23,512.90 TOTAL WATER ACCOUNTING EXP 1,684 37 14,163 98 62 55% 1,887 00 22,643 00 8,479 02 12,078 15 23,512 90 DEPRECIATION EXPENSE 62-0745-7451 DEPRECIATION-WATER 60,000.00 410,000.00 68.33% 50,000.00 600,000.00 190,000.00 110,000.00 720,044.00 TOTAL DEPRECIATION EXPENSE 60,000 00 410,000 00 68.33% 50,000 00 600,000.00 190,000.00 110,000.00 720,044 00 INTEREST EXPENSE 62-0748-7481 INTEREST ON BONDS/LONG TERM 14,524.00 124,139.29 44.97% 23,004.00 276,049.00 151,909.71 37,599.52 256,206.96 TOTAL INTEREST EXPENSE 14,524.00 124,139.29 44 97% 23,004 00 276,049 00 151,909.71 37,599 52 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 706.94 5,652.62 62-0750-7564 AMORTIZATION 1994 0.00 0.00 0.00% 0 00 0.00 0.00 1,096.76 12,225.48 62-0750-7565 AMORTIZATION 1997 0.00 98.76 5.34% 154.00 1,850.00 1,751.24 856.17 1,741.41 62-0750-7566 AMORTIZATION 1998 132.00 924 00 76.36% 101 00 1,210.00 286 00 675.29 1,163.17 62-0750-7567 AMORTIZATION 2001 329.00 2,303.00 64.60% 297.00 3,565.00 1,262.00 2,112.53 3,555.69 62-0750-7568 AMORTIZATION 2003 0.00 0.00 0.00% 0 00 0.00 0.00 0.00 1,708.00 TOTAL OTHER OPERATING EXPE 461 00 3,325.76 32 95% 841.00 10,092 00 6,766.24 5,447 69 26,046 37 CUSTOMER ACCOUNTS EX 62-0900-9030 COLLECTING EXP DISC/RECONNECT 622.67 1,957.30 27.70% 589.00 7,066.00 5,108.70 3,920.01 6,554.91 62-0900-9051 MISC CUSTOMER ACCTS EXP-COMP 0.00 2,606.00 26 50% 820.00 9,835 00 7,229.00 3,953.20 9,744.93 62-0900-9061 CUST BLGS NOT PD/SENT FOR COLL 0.00 1,053.52 87.79% 100.00 1,200.00 146.48 0 00 0.00 TOTAL CUSTOMER ACCOUNTS EX 622.67 5,616 82 31 03% 1,509 00 18,101 00 12,484 18 7,873 21 16,299 84 ADMINISTRATIVE & GEN 62-0920-9201 SALARIES/OFFICE&COMMISSION 6,931.83 48,418 50 193.75% 2,082.00 24,990.00 (23,428.50) 8,427.15 27,930.15 62-0920-9211 OFFICE SUPPLIES&EXPENSE 2,656.65 18,308.61 87.18% 1,750.00 21,000 00 2,691.39 15,989 50 22,825.94 62-0920-9212 LT&WATER CONSUMPTION/OFFICE 0.00 1,634 57 54.85% 248.00 2,980.00 1,345.43 752.99 2,156.09 62-0920-9213 BANK CHARGES 188.45 1,216.79 73.30% 138.00 1,660.00 443.21 996.93 1,564.85 62-0920-9222 LEGAL FEES 0.00 127.58 5.10% 208.00 2,500.00 2,372.42 43.75 43.75 62-0920-9231 AUDITING FEES 0.00 3,647.50 70.14% 433.00 5,200.00 1,552.50 4,397.54 4,397.54 wird slow=9:161 E MO i E tliik I\Mi. MII- U iiIE� Allige31.11 Fiscal Year 20 Budget Fiscal ear 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,362.18 39,165.28 67 45% 4,839.00 58,068.00 18,902.72 32,790.93 54,026.88 62-0920-9262 UTILITY SHARE OF PERA 2,624.56 30,415.33 112.08% 2,261.00 27,136.00 (3,279.33) 16,540 89 27,672.84 62-0920-9263 UTILITY SHARE OF FICA 1,516.13 20,476.17 71.60% 2,383.00 28,600 00 8,123.83 24,643.54 36,926.66 62-0920-9264 EMPLOYEES SICK PAY 405.52 8,472.14 211.80% 333.00 4,000.00 (4,472.14) 2,679.47 7,470.61 62-0920-9267 EMP VACATION/HOLIDAY PAY 5,293.84 24,967.84 179 62% 1,158.00 13,900.00 (11,067.84) 10,200.71 36,528.60 62-0920-9269 CONSERVATION IMP PROGRAM 265.25 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 429.79 1,314.96 10.96% 1,000.00 12,000.00 10,685.04 7,395.84 18,318.33 62-0920-9301 TELEPHONE 309 10 2,224.21 63.55% 292.00 3,500.00 1,275.79 2,050 93 3,373.97 62-0920-9302 ADVERTISING 531.97 3,782.31 75.65% 417.00 5,000.00 1,217.69 3,472.40 5,613.17 62-0920-9303 DUES&SUBSCRIPTIONS-FEES 0 00 12,719.28 195.68% 542.00 6,500.00 (6,219.28) 5,402.91 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 4,632.41 14,545.15 98.61 % 1,229.00 14,750.00 204.85 9,118.11 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 31,147.68 281,829 00 100.61 % 23,343.00 280,134.00 (1,695.00) 161,487.97 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 150,436 41 1,143,251.02 69.33% 137,424.00 1,649,105 00 505,853 98 598,534 51 1,842,116 86 TOTAL Expense 150,436.41 1,143,251.02 69.33% 137,424.00 1,649,105.00 505,853.98 598,534.51 1,842,116.86 PROFIT/(LOSS) : 76,042.94 51,698.84 24,037.00 288,429.00 236,730.16 579,166.30 1,797,454.63 Date Range: 7/1/2005 To 7/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 lb am mil ENmamuum .. 5 .. ENNoumi - .. .. Cash Flows 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,334,215 00 1,552,167 00 1,636,277.00 1,105,354 00 1,118,130 00 14,519,049 34 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,500 00 14,500 00 14,500 00 14,500 00 14,500 00 175,091 87 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,374 72 29,374 72 29,374 72 29,374 72 29,374 72 351,943 56 Dispersed Generation Credit (1,937 50) (2,562 50) (9,862 50) (14,362 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,378,089 72 1,596,041.72 1,680,151 72 1,149,228 72 1,162,004 72 15,031,722 27 Other Operating Revenue - Interest/Dividend Income 3,078 57 315 97 139 61 1,210 30 4,813 24 191 45 1,903 62 100 00 100 00 100 00 200 00 200 00 12,352 76 Customer Penalties 16,675 78 9,560 52 12,363 24 7,025 32 9,957 23 8,508.24 11,574 48 9,000 00 9,000 00 9,000 00 9,000 00 9,000 00 120,664 81 LFG Protect 60,878 54 60,554 78 54,419 02 59,411 40 58,642 95 60,380.67 58,481 96 66,710 75 77,608 35 81,813 85 55,267.70 55,906 50 750,076.47 Connection Fees 29,121 28 50,662 10 36,772 05 63,915 18 55,476 77 38,502 32 20,670 00 29,000.00 29,000 00 29,000 00 29,000.00 29,000 00 440,119 70 Misc Revenue 44,371 67 17,246 12 25,393 49 17,822 02 11,237.50 18,290 98 7,896 56 20,000 00 25,000 00 15,000 00 20,000 00 25,000 00 247,258 34 154,125 84 138,339 49 129,087 41 149,384.22 140,127 69 125,873 66 100,526 62 124,810.75 140,708 35 134,913 85 113,467 70 119,106 50 1,570,472 08 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,502,900 47 1,736,750 07 1,815,065 57 1,262,696 42 1,281,111.22 16,602,194 35 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,172,833 00 1,303,437 00 785,135 00 621,277 00 618,635 00 10,162,678 91 Operating&Mtce Expense 13,114 47 18,693 27 16,649 51 14,218 56 15,195 68 19,235.23 3,849 82 20,000.00 18,000 00 18,000 00 18,000 00 18,000.00 192,956 54 Landfill Gas 19,859.43 19,836 00 20,053 43 35,138 93 23,301 93 19,864 93 20,328 50 19,836 00 19,836 00 19,836 00 19,836 00 19,836 00 257,563 15 Distribution Expense 15,445 72 15,885 99 11,276 06 12,375 31 11,624 38 14,047 90 7,263 91 17,500 00 15,000 00 15,000 00 15,000 00 15,000 00 165,419 27 Maintenance Expense 36,692.45 46,817 20 57,501 54 63,581 21 44,061 42 79,639 90 45,943 94 60,000.00 50,000 00 45,000 00 41,000 00 40,000 00 610,237 66 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 24,461.67 4,461.67 4,461 67 4,461 67 4,461 67 109,571 24 Other Operating Expense 15,124 64 4,834 94 13,967 31 10,362.28 11,048.37 13,398 21 14,915 61 15,000 00 20,000 00 10,000 00 15,000 00 20,000 00 163,651 36 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 55,000 00 55,000 00 55,000 00 55,000 00 55,000 00 677,189 29 Customer Accounts Expense 10,851 94 3,614 27 11,990 39 34,062 31 7,100 76 14,103 59 6,704 34 11,000 00 11,000 00 11,000 00 11,000 00 11,000 00 143,427.60 Administrative&General Expense 124,552 56 131,186 72 193,775 00 145,183 68 129,314 71 115,101 81 103,505 56 125,000 00 125,000 00 125,000 00 125,000 00 125,000 00 1,567,620 04 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,638,630 67 1,739,734 67 1,206,432 67 1,043,574 67 1,044,932 67 15,442,315 06 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,502,900 47 1,736,750 07 1,815,065 57 1,262,696 42 1,281,111 22 16,602,194 35 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,638,630 67 1,739,734 67 1,206,432.67 1,043,574 67 1,044,932 67 15,442,315 06 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 (135,730.20) (2,984 60) 608,632 90 219,121 75 236,178 55 1,159,879 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 (50,338 33) 4,461 67 4,461 67 4,461 67 4,461 67 (14,392 31) Payroll Liabilities (52,425 19) (97,771 52) (95,143 20) (52,638 30) (124,864 69) (77,860.60) (60,142 65) (80,000 00) (70,000 00) (70,000 00) (70,000 00) (70,000 00) (920,846 15) Accounts Payable (224,976 67) (237,621 77) (241,560 88) (242,678.99) (305,700 32) (338,202 05) (384,356 27) (325,000 00) (325,000 00) (225,000 00) (225,000 00) (225,000.00) (3,300,096 95) Capitalized Items (14,107 20) (130,784 58) (250,000 00) (150,000 00) (20,000 00) (15,000 00) (10,000.00) (589,891 78) 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 726,741 86 319,548 00 577,290 00 789,923 00 251,224 00 4,205,324 66 Inventory Purchases (4,082.56) (55,333 47) (92,852 00) (220,956 99) (201,650.45) (197,050 00) (56,066 45) (41,000.00) (50,000 00) (70,000 00) (90,000 00) (110,000 00) (1,188,991 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 (47,736 50) (166,384 76) 912,974.74 721,096 59 184,454 39 443,034 70 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,152,749 51 986,364 75 1,899,339 49 2,620,436 08 2,804,890 47 W ■ w 1111111111 MO w - EN M ■N I N■ 11 1•11 - 1 MI el EN Cash Flows 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 179,327 00 176,886.00 269,872 00 157,196 00 103,516 00 1,511,760 98 Total Operating Revenue 70,166 50 63,746 74 59,507 64 63,349 23 82,645 50 115,686 70 169,861 67 179,327 00 176,886.00 269,872 00 157,196 00 103,516 00 1,511,760 98 Other Operating Revenue - Interest/Dividend Income 1,054 79 3,422 73 2,574.05 2,824 54 7,997 74 4,155.54 1,000 00 500.00 500 00 1,000.00 1,000 00 26,029.39 Customer Penalties 556.47 1,016.29 995 20 543 56 792 86 1,027.05 989 14 800 00 800.00 800 00 800 00 800.00 9,920 57 Connection Fees 97,430 00 47,940.00 36,345 00 96,437 50 141,951 20 70,521.00 51,473 00 28,000 00 28,000 00 28,000.00 28,000 00 28,000 00 682,097 70 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 29,800 00 29,300 00 29,300 00 29,800 00 29,800.00 717,985 88 Total Revenue 168,152 97 113,757 82 100,270 57 162,904 34 228,214 10 195,170.71 226,479 35 209,127.00 206,186,00 299,172.00 186,996.00 133,316.00 2,229,746 86 EXPENSES - Production Expense 1,242.18 2,219 04 1,01304 1,460 62 1,278 36 1,237 00 13,745 95 800 00 800 00 800.00 800 00 800.00 26,196.19 Pumping Expense 14,514.36 21,860.91 26,259 66 36,652.07 30,563 23 28,419 88 15,400 32 21,000.00 21,000.00 21,000.00 21,000.00 21,000.00 278,670 43 Distribution Expense 12,559.12 12,983.87 18,137 84 15,241 71 13,433 38 15,142.61 14,534 79 11,000 00 8,000.00 9,000.00 12,000.00 20,000.00 162,033 32 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 9,865.33 9,865 33 9,865 33 9,865.33 9,865.33 173,465 94 Other Operating Expense 537.76 483.00 461.00 461 00 461.00 461.00 461.00 500.00 500.00 500.00 500.00 500.00 5,825 76 Customer Accounts Expense 1,423.55 149.07 286 62 2,478 64 53 00 603 27 622.67 400.00 400 00 400.00 7,000.00 400 00 14,216.82 Administrative&General Expense 40,932.71 36,723.70 23,051.45 36,138.52 68,839 36 40,954.33 31,147 68 23,000.00 23,000 00 23,000.00 23,000.00 23,000 00 392,787.75 Total Expenses 131,075.01 190,049 56 139,074 94 162,297 89 184,493 66 161,342 09 150,436 41 126,565.33 123,565.33 124,565.33 134,165.33 135,565 33 1,763,196 21 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 209,127 00 206,186.00 299,172 00 186,996 00 133,316.00 2,229,746.86 TOTAL EXPENSES 131,075.01 190,049 56 139,074 94 162,297 89 184,493 66 161,342.09 150,436 41 126,565 33 123,565 33 124,565 33 134,165.33 135,565 33 1,763,196 21 NET INCOME PROFIT(LOSS) 37,077.96 (96,291 74) (38,804.37) 606.45 43,720 44 33,828.62 76,042.94 82,561.67 82,620 67 174,606.67 52,830 67 (2,249 33) 446,550 65 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 (42,134 67) 9,865 33 9,865.33 9,865.33 9,865 33 (22,951.74) Payroll Liabilities (13,106 25) (14,442.88) (23,785 80) (13,159.58) (24,972 94) (15,572 12) (15,035 66) (14,500.00) (14,500 00) (13,000.00) (13,000 00) (13,000.00) (188,075.23) Accounts Payable (29,062.20) (27,006.00) (8,638 25) (28,000.00) (12,521.74) 27,778.43 (28,000 00) (28,000.00) (28,000 00) (28,000.00) (28,000.00) (217,449.76) Capitalized Items (20,412 00) (10,143 00) (52,536 49) (86,598.46) (4,000.00) (50,000 00) (10,000.00) (7,000 00) (7,000 00) (5,000 00) (252,689.95) 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) 88,534.67 70,441 00 35,014 00 180,676.00 121,680 00 469,259 78 Inventory Purchases (1,200.00) (19,308 28) (25,221 50) (14,458 94) (19,682 05) (3,925.81) (1,958.87) (5,000 00) (5,000.00) (5,000 00) (5,000.00) (5,000 00) (110,755.45) 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 91,461.67 165,427.00 226,486.00 250,372 00 138,296.00 392,631.35 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,351,489.01 1,516,916.01 1,743,402 01 1,993,774.01 2,132,070 01 9