Loading...
13 Monthly Financial Report I:8JAction CITY OF PARIS, TEXAS CITY COUNCIL AGENDA REQUEST MEETING DATE: I August 13, 2007 o Discussion [8Jlnformation ORefer to: SUBMITTED BY: r Gene Anderson, Finance Director DESCRIPTION: July 2007 financial report. BACKGROUND INFORMATION: Monthly report to Council with explanatory comments. FISCAL AUTHORITY: Information only. LEGAL REVIEW: MANAGER'S RECOMMENDATION: ] ] City of Paris July 2007 Financial Report Comments Regarding the "Net to Date Comparison", please note the following comments. 1. As reported previously, there is a distortion in the "Taxes Collected" line item due to a change in how property tax collections for debt are handled this year compared to last year. The $6,313,273 collected to date for current taxes exceeds the $5,941,533 collected at this same time last year. The 2005-06 "Taxes Collected" number of$7,453,913 included $1,332,532 in collections for debt related Interest & Sinking Funds that were run through the General Fund on their way to the correct I&S Fund. In 2006-07, property tax collections for debt are deposited directly into the proper I&S Fund and no longer go through the General Fund. 2. Sales taxes are 5.70% above this point last year. 3. Hotel taxes are up 20.36% from this time last year. 4. "Franchise Fees" are 14.04% lower at this point in the year because TXU Energy now pays its franchise fees quarterly instead of annually as it did last year. The annual payment last year was paid in May. There will be one more quarterly payment in this fiscal year. A prorated share of the water and sewer utility franchise payment has been paid compared to last year when the annual payment was made in September 2006. However, this prorated payment is not sufficiently large to offset the 4th quarter payment forthcoming from TXU. 5. As reported previously, "Permits" are up 25.34% at this point in the year due to Kimberly Clark's 20 million dollar expansion. This permit alone was over $45,000. 6. Court fines are up 9.94% from this time last year. 7. The "Leases & Grants" category is up 48.00% this year because this category includes interest earned which is up over this same point last year. There were substantial interest payments received in June. 8. General Fund "Miscellaneous Fees" are up over last year because in July 2006 the City refunded Walgreens Pharmacy $23,617 in property taxes previously paid for the years 2004 and 2005. This was part of an agreed to settlement by the appraisal district over disputed property values. Because the refund was for years other than the then current year (2006), the refund was charged to "Miscellaneous Fees" so as not to distort the current taxes collected figure. 9. As previously reported, Water & Sewer Fund "Interest" is up due to the shortened period of investment which causes interest payments to be reported sooner than with longer term investments. 10. "Summer Programs" revenue is down 7.77% due to lower attendance at the pool. The attendance was adversely affected by the rainy weather in the early summer months. 11. Water revenue is down 2.32% and sewer revenue is down 3.54% compared to this time last year. It is believed that this is weather related. 12. Water & Sewer "Miscellaneous" revenues are now ahead oflast year due to reduced utility charges offs ($16,377 less at this point) and some 2005-06 late fees were not posted until the 2006-07 fiscal year. Regarding the departmental expenditure summary for the current year, 13. The City Council expense to date is higher than expected due to payments made to the Pace Group and higher than expected election costs ($25,470). 14. The City Manager expense to date is higher than expected due to the cost of the interim manager. The Texas First Group is paid an hourly rate based on the budgeted salary and benefit costs of the City Manager. The City has to pay for each hour worked without the benefit of having someone who is a salaried exempt employee. 15. The "General Expenses" category is higher than expected reflecting a higher than expected collection and remittance of hotel taxes and the fact that all city memberships (TML, COG, & Tx Coalition of Cities) have been paid for the year. 16. The Departmental Expenditure Summary Comparison contains a $3,956,855 line item that accounts for the Water & Sewer Fund debt due for the year. Money is transferred from the Water & Sewer Fund to various Interest & Sinking funds from which the debt payments are actually made. These transfers do not show up as expenditures. Debt payments made to date for the Water & Sewer Fund equal $3,953,960.82. Net to Date Comparison Descri tion General Fund 2007 Taxes Collected Sales Tax Hotel-Motel Tax Franchise Fees Permits Court Fines Leases & Grants Fees & Co ies Lamar Count Fire Grants & Donations Sanitation Fees EMS Fees State Revenue Miscellaneous Fees Summer Pro rams 6,539,738.48 4,632,410.99 400,321.92 2,441,005.57 95,200.92 325,654.93 464,263.48 12,851.41 1,500.00 17,576.07 1,090,337.88 1,937,147.10 50,631.85 251,275.20 97,316.80 Sewer Water Interest Earned Miscellaneous 3,997,135.34 5,875,345.20 155,948.57 219,399.28 July Net to Date.xls 2006 Net to Date 7,453,912.83 4,382,504.51 332,595.88 2,839,786.67 75,948.50 296,203.50 313,671.93 13,398.03 1,350.00 210,638.01 1,098,674.59 1,888,461.69 45,514.86 213,325.82 105,522.98 4,144,209.82 6,015,020.92 122,781.99 175,954.96 8/7/2007 Net to Date Comparison Description Special Funds 29,924.99 21,825.28 8,099.71 Interest Earned 672.24 948.04 _(275.80 _'<~' ~ -.ilIJ!IIl.' " M ~:~~nQ,;a8'" '" :. "96li. ~S8. " MJ~S.$~A.20 ., ~ '." h\ 8;\191'\55..tI.. , , :" , .I.13;~29:56:' ..\&1..S21 :It Child Safety Fund Interest Earned 6.47 206.81 200.34) S~ecial Funds 2007 2006 Net to Date , . ". Health D~artment Interest Earned Fees & Grants .,0 '." '. ; 6.4Z'[', '. .' '.. '206~at I.' .' .:': " (200;S4~ ':. 2S0:a.rr-:::,,::: '1;455.60', ": ~24.79: . .. "'2' 24,,?Jl ", ""'2'40 .,.~, "'0'24' '''5 . "" '\. t~'04HM..,' t '(.. O},r~~.... X"",),' .."'t.); 529.97 745,154.79 5.07 800,701.76 -'55,546.97 -.' '" '.' '0 ';' Grant Fund Grants Interest Earned ~7:4a&S~;16. 'SOOt7D6;'83, I." M 'k;l55;O~.OZ) "y,65,,251136~,;:;;: ;\6!lp.94&3;;;,:.' '", n.30S.99: i." Jl~42Z::~~ .':.. ; 1lj':h15S',46; 1\ " ',66,S3l.06 458,748.57 1,207.20 493,062.19 80.04 1,127.16 _. ", ---., . lIII!liI_'F )Fnlllll!llll;.IrJi . ..:.~,489:p94;62% .:. .~"~456:91:a;~t ;':.',o.,:32;67El.~~. v.". 29,63S.8S), '. . ....36;224.02 I, ., 65.S62.S7 Criminal Justice Fund Program Income _ 138,113.70 138,050.37 Contributions _ 598,962.10 598,962.10 Interest Earned 63.33 0.00 63.33 _... '>. "63'~33t. .t,t' '737'0'75'S<0' .... .iT"]-:l7rt012"4'7 . . .,. .... .... .... @"~ ..~ .v ". '< ' .... ",lIf. ',,~. '0 ". , \.1 'l! :..' ;"t;" . , , . \ .... ", .: '563taa:S:45..c ;. (o63,8SJ5'.45 .,., "':c~;J~3:33'. ./., n:$;190:3$".,.. ,1:13.12'7;02' Communi!)' Devel~ment Block Grant Interest Earned 1,610.09 1,967.22 1357.13 Grants 78,650.00 37,500.00 41,150.00 Tax & Rev CO 2000 Const Fund Interest Earned Grants . '80;260.09 .... ..:;a9.i461",22';.;:4.o.792.67 .. .':',2a;20PJ:JO . ".: 11'6.6Q,O:OOJ, 91;400.00 ;. I "S5;060}09... "" '7t;1'82.78 ., ."132,192.81 4,585.59 111,795.881 11,451.55 0.00 16,865.96 111,795.88 ,~ ~~, ., i.~10i2~; ";11~45~55; r '\' , '11.,S..661.&4- " .,.~~Ota'J1f .=4:;21:&f9J;'a:.!071t, 'i 1;, 1\1Q.8~~~,t6' ,... 5~2Sp;20:H;.. ;(;1;'201.466;52 U>M .;1.~S2;t7a:32., July Net to Date.xls 2 8/6/2007 Net to Date Comparison Description CO Series 2002 Construction Fd Interest Earned Sale of Scr~ Metal 2007 2006 Net to Date 87.77 0.00 99,109.92 ~99,022.15 0.00 Revenue Bonds 5inki'!9 Funds Transfer to GO RefundilJQ 2003 422,000.00 65,000.00 Interest Earned 61,013.40 57,785.56 _........." 483,a13;4{O". .'.1.22:~8~;Q6 .... . '.. <;r.9~~6'O:gz: < ...... 3.,g5~tS61,01.' <. ., . .. 3;i41Q;~Y :'42 .: (3;835:081 ,6~lL: . Tax & Rev CO 2000 1&5 Fund Tax & Rev COs 2000 I&S 496,368.56 Interest Earned 1,423.78 .. ',:",,':.al:l,( f' '.', 99"Jf!)9~'92Rt. . 99;022..1p ..: .:.' : 8(246;4&, ..: : "3;oa.Q:a4<~:9St .," a:O(l1iS01.sl "":u .. . ' . :. .., '.fj.. .", . I;,j ~. . . ..n 8fr15a:z.nt: 2,9'1~1i3~0'7 2..902:51~36 357,000.00 3,227.84 36Q:227,a4. . . '9f\'1ll '25. "J. N!~ .' .3S4i'134:0'Q 1,325.12 496,368.56 98.66 -',:.4 .;792.34'.;. ,.,<'<1..325.12.. . 496;4t>'1.22 ,,'/::5;10/142;51,t.:.. :,"5tO~98.Z~; ~y "':"104 . ,'35Et2~. .. .. J 12;350:(1,7. . 509,113.64/1 4.96.823.47 Tax & Rev CO 2002 1&5 Fund Tax & Rev COs 2002 I&S 423,377.22 423,377.22 2003 GO Refundina Bonds Cert Of Oblig. 2003 I&S Interest Earned . "423,371;22.. . . .. - .:.A23.37r,22 <.... .438;6&1.,;0.0",1,' ....43();6~,,5O:J'.L."'1;;98&50.. . ,. l15.2a3:.78u '. ,,~36t672.5GJI' '. ...421 ;388,;72 379,485.86 13,566.77 7,842.31 379,485.86 5,724.46 _. .:......~~aa:Q52;63...I.. .;~....j7::al2.31..:. ':raA~55,2~fO~32. .', "e9at26p:0(}"'8Qi1::r25~GQ., "'.'" d ",2r160;GQ. .', '. ';', /1Q,32.31',.\ .. 38.3,2&2:ae . .... 383,,050:32 . Employees Insurance Fund Claim Payment Refunds 18,299.68 1,093,746.53 (1,075,446.85 Libr~ Memorial Fund Interest Earned Memorial Donations ....:. '..,: ,~16,2~9:66 '..,.. .. ..,';09.,. .3.~6.....~5....3....", f,1.015'.4~(ta5 " .' " .'." ~ "" . ..,~.. .'. ",' ,;:0:00. ." %1B;29~;6W.1;098t:Z~53 '(1:i075;446.~5 2,396.39 4,045.76 1,430.90 9,750.95 965.49 (5,705.19 . ..,..,. ~ '. ':'.:. .."27:8 5"l!., ....44'. '>'7'<1... . " ... .'"R;6t:: <l4' .'.' '". .,.. .r-I.. ,t. .r "'..' 1(.7. )l., r. ", , Y' ..>1"'G ..<.:.,..,i5t66S.sa:.... "">;;:,'9;73a~14;) '.... '.' '" ... .4tQ;14;5"6 July Net to Date.xls 3 8/6/2007 Net to Date Comparison 2007 2006 9,096.61 Net to Date July Net to Date.xls 4 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance 01-7010-00-00 Current Taxes 6,313,272.99 101.59 6,214,245.00 (99,027.99) 01-7020-00-00 Delinquent Taxes 24,375.15 116,924.04 73.08 160,000.00 43,075.96 01-7030-00-00 Penalty & Interest 6,118.70 74,827.12 74.83 100,000.00 25,172.88 01-7031-00-00 Attorney Fees 4,682.73 34,714.33 86.79 40,000.00 5,285.67 Subtotal 35,176.58 6,539,738.48 100.39 6,514,245.00 (25,493.48) 01-7110-00-00 Municipal Sales Tax 347,517.85 3,705,928.84 87.20 4,250,000.00 544,071.16 01-7112-00-00 Sales Tax-Reduce Property Tax 86,879.45 926,482.15 87.16 1,063,000.00 136,517.85 Subtotal 434,397.30 4,632,410.99 87.19 5,313,000.00 680,589.01 01-7220-00-00 Hotel-Motel Occupancy Tax 83,820.72 400,321.92 123.18 325,000.00 (75,321.92) Subtotal 83,820.72 400,321.92 123.18 325,000.00 (75,321.92) 01-7310-00-00 Southwestern Bell Telephone Co 135,080.87 81.87 165,000.00 29,919.13 01-7320-00-00 Atmos Gas 389,308.53 59.89 650,000.00 260,691.47 01-7330-00-00 TXU Electric 1,292,347.36 78.09 1,655,000.00 362,652.64 01-7340-00-00 Taxicabs 300.00 100.00 300.00 01-7350-00-00 Suddenlink Cable 72,105.83 55.47 130,000.00 57,894.17 01-7360-00-00 Water Sewer Utility 29,166.00 290,499.00 85.44 340,000.00 49,501.00 01-7390-00-00 Bingo 45,112.34 75.19 60,000.00 14,887.66 01-7395-00-00 Municipal ROW Use Fee 1,161.16 21,393.66 61.13 35,000.00 13,606.34 01-7396-00-00 Solid Waste Street Use Fee 18,834.61 194,857.98 86.60 225,000.00 30,142.02 Subtotal 49,161.77 2,441,005.57 74.87 3,260,300.00 819,294.43 01-7410-00-00 House Moving - 450.00 450.00 01-7411-00-00 Concrete Permits 150.00 1,175.00 85.46 1,375.00 200.00 01-7412-00-00 Building Permits 5,105.50 83,478.92 139.13 60,000.00 (23,478.92) 01-7413-00-00 Sign Permits 500.00 2,400.00 48.00 5,000.00 2,600.00 01-7414-00-00 Electrical Permits 100.00 1,165.00 145.63 800.00 (365.00) 01-7416-00-00 Gas Inspections 175.00 2,325.00 58.13 4,000.00 1,675.00 01-7418-00-00 Plumbing Inspections 429.00 3,804.00 84.53 4,500.00 696.00 01-7420-00-00 Electrical Licenses 310.00 853.00 47.39 1,800.00 947.00 Subtotal 6,769.50 95,200.92 122.17 77,925.00 (17,275.92) 01-7510-00-00 Court Fines & Costs 26,369.57 271,347.74 84.80 320,000.00 48,652.26 01-7511-00-00 Defensive Drivinq Course 240.00 4,878.50 152.45 3,200.00 (1,678.50) 01-7512-00-00 Warrant Service Fees {city} 2,319.97 17,137.62 48.97 35,000.00 17,862.38 01-7513-00-00 City Traffic Fees 335.39 3,637.44 95.72 3,800.00 162.56 01-7514-00-00 Arrest Fees 1,232.30 13,136.70 90.60 14,500.00 1,363.30 July Revenues.xls 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7516-00-00 Time Payment Fees Retained 992.70 7,965.62 89.50 8,900.00 934.38 01-7517 -00-00 State Judicial Fund due City 159.76 1,584.31 316.86 500.00 (1,084.31 01-7520-00-00 Pound Fees 359.00 4,187.00 96.25 4,350.00 163.00 01-7521-00-00 Pound Incineration Fees 1,780.00 136.92 1,300.00 (480.00) Subtotal 32,008.69 325,654.93 83.17 391,550.00 65,895.07 01-7620-00-00 Cox Field Leases-Terminal 300.00 3,000.00 83.33 3,600.00 600.00 01-7630-00-00 Cox Field Rent Hangar Storage 60.00 600.00 83.33 720.00 120.00 01-7631-00-00 Cox Field Rental T Hangars 5,558.00 50,949.00 92.64 55,000.00 4,051.00 01-7632-00-00 Cox Field Fuel Flowage Fee 704.40 5,757.85 71.97 8,000.00 2,242.15 01-7640-00-00 Leases & Rentals 6,550.30 77.98 8,400.00 1,849.70 01-7650-00-00 Interest Earned 22,242.63 373,610.45 415.12 90,000.00 (283,610.45) 01-7651-00-00 Suddenlink Cable Tower Rental 12,000.00 - (12,000.00) 01-7672-00-00 Auto Theft Prevention Grant 11,795.88 - (11,795.88) Subtotal 28,865.03 464,263.48 280.15 165,720.00 (298,543.48) 01-7712-00-00 Recording Legal Instruments 600.00 600.00 - (600.00) 01-7713-00-00 Zoning & Subdivision Fees 200.00 1,970.66 70.38 2,800.00 829.34 01-7715-00-00 Sale of Maps Copies Etc 1,233.12 8,580.75 114.41 7,500.00 (1,080.75) 01-7716-00-00 Tax Certificates 117.50 1,700.00 66.67 2,550.00 850.00 Subtotal 2,150.62 12,851.41 100.01 12,850.00 (1.41) 01-7822-00-00 Lamar Coun!y Fire Contract 150.00 1,500.00 83.33 1,800.00 300.00 Subtotal 150.00 1,500.00 83.33 1,800.00 300.00 01-7937-00-00 Streetscape- TXDOT Grant 17,576.07 - (17,576.07) Subtotal 17,576.07 - (17,576.07) 01-8046-00-00 Sanitation Fees 108,037.47 1,086,783.93 82.02 1,325,000.00 238,216.07 01-8047-00-00 Brush Pickup Fee 788.50 3,553.95 47.39 7,500.00 3,946.05 Subtotal 108,825.97 1,090,337.88 81.83 1,332,500.00 242,162.12 01-8153-00-00 Lamar Co-Emergency Medical SE 25,666.67 256,666.70 82.80 310,000.00 53,333.30 01-8154-00-00 Emergency Medical Service Fee~ 166,795.44 1,680,480.40 93.46 1,798,000.00 117,519.60 Subtotal 192,462.11 1,937,147.10 91.90 2,108,000.00 170,852.90 01-8260-00-00 State Shared Revenue 13,124.24 50,631.85 126.58 40,000.00 (10,631.85) Subtotal 13,124.24 50,631.85 126.58 40,000.00 (10,631.85) 01-8308-00-00 Birth Certificate Fee for TWC (403.20) 66.60 - (66.60) 01-8309-00-00 Birth Certificate Fees 1,737.20 14,745.90 101.70 14,500.00 (245.90) 01-8310-00-00 Death Certificate Fees 2,686.00 19,853.00 99.27 20,000.00 147.00 July Revenues.xls 2 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance 01-8311-00-00 Library Copies 159.97 1,838.22 91.91 2,000.00 161.78 01-8312 -00-00 Library Fines & Other 2,067.04 13,369.89 89.13 15,000.00 1,630.11 01-8314-00-00 Loan Star Libraries Grant 4,081.00 - (4,081.00) 01-8325-00-00 Sale of City Property 1,612.90 16.13 10,000.00 8,387.10 01-8330-00-00 Materials & Labor Sold 2,047.89 6,781.90 61.65 11,000.00 4,218.10 01-8331-00-00 Lot Clean Up 3,661.21 8,129.33 101.62 8,000.00 (129.33) 01-8332 -00-00 Billed Electric 3,398.89 - 01-8333-00-00 Refund Landfill Fee-Demolition 5,772.06 - (5,772.06 01-8350-00-00 Miscellaneous Revenue 5,251.22 163,558.84 408.90 40,000.00 (123,558.84) 01-8365-00-00 VCC Band Contribution 10,000.00 100.00 10,000.00 01-8366-00-00 Credit Card Convenience Fee 26.90 635.56 - (635.56) 01-8368-00-00 Library Card Fees 90.00 830.00 16.60 5,000.00 4,170.00 Subtotal 20,723.12 251,275.20 185.44 135,500.00 (115,775.20) 01-8499-00-00 Water & Sewer Transfer 62,500.00 622,500.00 83.00 750,000.00 127,500.00 Subtotal 62,500.00 622,500.00 83.00 750,000.00 127,500.00 01-8500-00-00 Pool Vending 2,857.28 6,505.18 68.48 9,500.00 2,994.82 01-8501-00-00 Pool Programs 3,800.75 18,320.25 128.11 14,300.00 (4,020.25) 01-8502-00-00 Pool Daily Fees 5,104.00 12,833.80 91.67 14,000.00 1,166.20 01-8503-00-00 Sports Complex 1,853.50 24,390.22 - (24,390.22) 01-8504-00-00 Softball 8,301.00 22,809.10 64.25 35,500.00 12,690.90 01-8505-00-00 Reservations 76.00 2,718.50 123.57 2,200.00 (518.50) 01-8506-00-00 Sponsorships 3,700.00 - (3,700.00) 01-8507 -00-00 Special Events 211.25 6,039.75 57.52 10,500.00 4,460.25 Subtotal 22,203.78 97,316.80 113.16 86,000.00 (11,316.80) Program number: 1,092,339.43 18,979,732.60 92.52 20,514,390.00 1,534,657.40 Department number 1,092,339.43 18,979,732.60 92.52 20,514,390.00 1,534,657.40 Fund number: 1 General Fund 1,092,339.43 18,979,732.60 92.52 20,514,390.00 1,534,657.40 02-7111-00-00 Economic Development Sales Ta 86,879.45 926,482.15 92.65 1,000,000.00 73,517.85 Subtotal 86,879.45 926,482.15 92.65 1,000,000.00 73,517.85 02-7650-00-00 Interest Earned 541.73 11,000.52 55.00 20,000.00 8,999.48 Subtotal 541 .73 11,000.52 55.00 20,000.00 8,999.48 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 320,000.00 83.33 384,000.00 64,000.00 02-8358-00-00 C-Tech Settlement 250,000.00 250,000.00 - (250,000.00) Subtotal 282,000.00 570,000.00 148.44 384,000.00 (186,000.00) July Revenues.xls 3 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance Program number: 369,421.18 1,507,482.67 107.37 1,404,000.00 (103,482.67 Department number Revenues 369,421.18 1,507,482.67 107.37 1,404,000.00 (103,482.67 Fund number: 2 Economic Development Fund 369,421.18 1,507,482.67 107.37 1,404,000.00 (103,482.67 10-7010-00-00 Sewer Charges 357,829.18 3,863,899.66 81.78 4,725,000.00 861,100.34 10-7011-00-00 Industrial Surcharges 12,558.29 101,432.88 72.45 140,000.00 38,567.12 10-7020-00-00 Sewer Taps 6,910.00 69.10 10,000.00 3,090.00 10-7022-00-00 Pro Rata Sewer Line Extension 2,115.25 24,892.80 II !/:::::::: ;; 1,000.00 (23,892.80) Subtotal 372,502.72 3,997,135.34 81.98 4,876,000.00 878,864.66 1 0-7130-00-00 Water Sales 596,466.83 5,855,315.20 80.99 7,230,000.00 1,374,684.80 1 0-7140-00-00 Water Taps 820.00 20,030.00 100.15 20,000.00 (30.00 10-7142-00-00 Pro Rata Water Line Extension - 2,520.00 2,520.00 Subtotal 597,286.83 5,875,345.20 81.01 7,252,520.00 1,377,174.80 10-7650-00-00 Interest Earned 9,182.74 155,948.57 129.96 120,000.00 (35,948.57 Subtotal 9,182.74 155,948.57 129.96 120,000.00 (35,948.57) 10-8350-00-00 Miscellaneous W&S 9,793.64 104,648.00 130.81 80,000.00 (24,648.00) 10-8352-00-00 Sanitation Billing Fee 5,686.19 57,199.20 81.71 70,000.00 12,800.80 10-8354-00-00 Service Charges 6,025.00 52,375.00 80.58 65,000.00 12,625.00 1 0-8355-00-00 Brush Pickup Fees 41.50 187.05 18.71 1,000.00 812.95 10-8356-00-00 Bulk Water Sales 666.81 4,899.30 97.99 5,000.00 100.70 10-8357 -00-00 Sewer Dumping Fees 3,588.42 39,170.54 78.34 50,000.00 10,829.46 10-8358-00-00 W &S Charge Ofts (4,900.95) (49,455.34 ) 58.18 (85,000.00) (35,544.66) 10-8359-00-00 W&S Returned Check Fees 690.00 7,020.00 100.29 7,000.00 (20.00) 1 0-8360-00-00 W &S Copies 3.36 23.56 78.53 30.00 6.44 1 0-8366-00-00 Credit Card Convenience Fee 323.72 2,914.49 145.73 2,000.00 (914.49 10-8367 -00-00 Deposits Billed (13.30) 417.48 - (417.48 Subtotal 21,904.39 219,399.28 112.50 195,030.00 (24,369.28 Program number: 1,000,876.68 10,247,828.39 82.36 12,443,550.00 2,195,721.61 Department number Revenues 1,000,876.68 10,247,828.39 82.36 12,443,550.00 2,195,721.61 Fund number: 10 Water & Sewer Fund 1,000,876.68 10,247,828.39 82.36 12,443,550.00 2,195,721.61 11-7650-00-00 Interest Earned 2,360.70 7,826.92 391.35 2,000.00 (5,826.92) Subtotal 2,360.70 7,826.92 391.35 2,000.00 (5,826.92) Program number: 2,360.70 7,826.92 391.35 2,000.00 (5,826.92) Department number 2,360.70 7,826.92 391.35 2,000.00 (5,826.92) Fund number: 11 Capital Projects Fund 2,360.70 7,826.92 391.35 2,000.00 (5,826.92) July Revenues.xls 4 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance 12-7650-00-00 Interest Earned 603.40 20,735.15 - (20,735.15) Subtotal 603.40 20,735.15 - (20,735.15) ProQram number: 603.40 20,735.15 - (20,735.15) Department number 603.40 20,735.15 - (20,735.15) Fund number: 12 WW&SS Rev Bond 2000 ConstF 603.40 20,735.15 - (20,735.15) 20-7002-00-00 Municipal Court Tech Fee 1,081.54 11,118.37 92.65 12,000.00 881.63 20-7003-00-00 Court Security Fee 808.33 8,359.50 88.00 9,500.00 1,140.50 20-7004-00-00 Child Safety Fee 520.77 52.08 1,000.00 479.23 20-7005-00-00 Time Payment Fee 247.57 1,984.35 82.68 2,400.00 415.65 20-7007 -00-00 Judicial Forfeitures Fee 57.00 7,942.00 529.47 1,500.00 (6,442.001 Subtotal 2,194.44 29,924.99 113.35 26,400.00 (3,524.99) 20-7650-00-00 Interest Earned 76.82 672.24 134.45 500.00 (172.24 Subtotal 76.82 672.24 134.45 500.00 (172.24\ Program number: Special Revenue 2,271.26 30,597.23 113.74 26,900.00 (3,697.23) Department number Special Revenue 2,271.26 30,597.23 113.74 26,900.00 (3,697.231 Fund number: 20 Special Revenue Fund 2,271.26 30,597.23 113.74 26,900.00 (3,697.23) 21-7650-00-00 Interest Earned 6.47 - (6.47) Subtotal 6.47 - (6.47) Program number: Think Child Safety 6.47 - (6.4 7) Department number Child Safety Fund 6.47 - (6.4i"\ Fund number: 21 Child Safety Fund 6.47 - (6.4 7) 22-7650-00-00 Interest Earned 62.90 529.97 - (529.9i\ Subtotal 62.90 529.97 - (529.97) 22 -81 51-00-00 Local Fees 3,914.00 37,721.30 78.63 47,973.00 10,251.70 22 -8152 -00-00 ORAS 14,670.20 109,998.00 100.00 109,998.00 22-8155-00-00 Lamar County 36,605.08 48.81 75,000.00 38,394.92 22-8156-00-00 Primary Health Care Program 22,145.10 119,029.78 78.54 151,558.00 32,528.22 22 -8158-00-00 State of Texas-WIC 19,286.07 259,397.28 91.26 284,249.00 24,851.72 22 -8160-00-00 City of Paris 36,605.07 48.81 75,000.00 38,394.93 22-8170-00-00 Primary Health Care Prog Fees 465.00 4,995.35 41.63 12,000.00 7,004.65 22 -81 71-00-00 ORAS Local Fees 5,500.00 39,4 75.00 157.90 25,000.00 (14,475.00) 22-8172-00-00 Immunization Grant 5,367.11 71,832.45 143.60 50,023.00 (21,809.45) 22-8174-00-00 Immunization Fees 1,342.00 12,790.00 51.16 25,000.00 12,210.00 22-8175-00-00 Prenatal Care Grant 14.00 15,184.60 75.92 20,000.00 4,815.40 July Revenues.xls 5 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance 22-8176-00-00 Prenatal Care Fees 80.00 1,520.88 - (1,520.88) Subtotal 72,783.48 745,154.79 85.08 875,801.00 130,646.21 Program number: Health Department 72,846.38 745,684.76 85.14 875,801.00 130,116.24 Department number Health Department 72,846.38 745,684.76 85.14 875,801.00 130,116.24 Fund number: 22 Health Department Fund 72,846.38 745,684.76 85.14 875,801.00 130,116.24 25-7001-00-00 Paris ISD School Officers 15,148.25 138,757.75 76.33 181,779.00 43,021.25 25-7002-00-00 No. Lamar ISO School Officers 15,116.00 138,481.42 76.34 181,392.00 42,910.58 25-7003-00-00 Violent Crimes Against Women 12,374.92 13.40 92,388.00 80,013.08 25-7004-00-00 Auto Theft Task Force 65,535.35 66.65 98,326.00 32,790.65 25-7006-00-00 Justice Assistance Grant 12,208.00 48.11 25,378.00 13,170.00 25-7008-00-00 Grant Match-Police Department 22,185.46 24.73 89,727.00 67,541.54 25-7010-00-00 Felony Crimes Unit 36,430.84 69,205.67 30.35 227,999.00 158,793.33 25-7011-00-00 TXDOT-Airport Development - 516,667.00 516,667.00 25-7012-00-00 Grant Match-Airport Dev. Grant - 105,556.00 105,556.00 Subtotal 66,695.09 458,748.57 30.20 1,519,212.00 1,060,463.43 25-7650-00-00 Interest Earned 1,207.20 - (1,207.20) Subtotal 1,207.20 - (1,207.20) Program number: 66,695.09 459,955.77 30.28 1,519,212.00 1,059,256.23 Department number Grant Fund 66,695.09 459,955.77 30.28 1,519,212.00 1,059,256.23 Fund number: 25 Grant Fund 66,695.09 459,955.77 30.28 1,519,212.00 1,059,256.23 26-7650-00-00 Interest Earned 20.89 63.33 - (63.33) Subtotal 20.89 63.33 - (63.33\ Program number: 20.89 63.33 - (63.33) Department number Drug Task Force Grant 20.89 63.33 - (63.33) Fund number: 26 Criminal Justice Div Grant Fd 20.89 63.33 - (63.33) 30-7650-00-00 Use of Money Property Interest 164.67 1,610.09 - (1,610.09) Subtotal 164.67 1,610.09 - (1,610.09\ 30-7855-00-00 ORCA Owner Occupied Rehab (5,350.00) - 5,350.00 30-7856-00-00 Owner Occupied Rehab 37,500.00 - (37,500.00) 30-7860-00-00 Infrastructure Grant Eastgate 46,500.00 - (46,500.00) Subtotal 78,650.00 - (78,650.00) Program number: 164.67 80,260.09 - (80,260.09) Department number 164.67 80,260.09 - (80,260.09) Fund number: 30 Community Dvl Block Grant Fund 164.67 80,260.09 - (80,260.09) July Revenues.xls 6 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance 41-7650-00-00 Interest Earned 329.60 4,585.59 - (4,585.59) Subtotal 329.60 4,585.59 - (4,585.59' 41-8303-00-00 Streetscape TxDot Reimburse (11,795.88) - 11,795.88 Subtotal (11,795.88) - 11 ,795.88 Program number: 329.60 (7,210.29) - 7,210.29 Department number 329.60 (7,210.29) - 7,210.29 Fund number: 41 Tax & Rev CO 2000 Const Fund 329.60 (7,210.29) - 7,210.29 42-7650-00-00 Interest Earned 4.15 87.77 - (87.77) Subtotal 4.15 87.77 - (87.77) Program number: 4.15 87.77 - (87.77) Department number 4.15 87.77 - (87.77) Fund number: 42 CO Series 2002 Construction Fd 4.15 87.77 - (87.77 50-1135-00-00 Transfer to GO Refunding 2003 17,000.00 422,000.00 - (422,000.00) Subtotal 17,000.00 422,000.00 - (422,000.00) 50-7650-00-00 Use of Money Property Interest 632.51 61,013.40 - (61,013.40' Subtotal 632.51 61,013.40 - (61,013.40) Program number: 17,632.51 483,013.40 - (483,013.40 Department number 17,632.51 483,013.40 - (483,013.40) Fund number: 50 Revenue Bonds Sinking Funds 17,632.51 483,013.40 - (483,013.40) 55-7043-00-00 Tax & Rev COs 2000 I&S 1,842.08 496,368.56 97.30 510,145.00 13,776.44 Subtotal 1,842.08 496,368.56 97.30 510,145.00 13,776.44 55-7650-00-00 Interest Earned 194.67 1,423.78 - (1,423.78' Subtotal 194.67 1,423.78 - T1 ,423.78) Program number: 2,036.75 497,792.34 97.58 510,145.00 12,352.66 Department number 2,036.75 497,792.34 97.58 510,145.00 12,352.66 Fund number: 55 Tax & Rev CO 2000 I&S Fund 2,036.75 497,792.34 97.58 510,145.00 12,352.66 56-7044-00-00 Tax & Rev COs 2002 I&S 1,585.57 423,377.22 96.43 439,075.00 15,697.78 Subtotal 1,585.57 423,377.22 96.43 439,075.00 15,697.78 Program number: 1,585.57 423,377.22 96.43 439,075.00 15,697.78 Department number Tax & Revenue 2002 1,585.57 423,377.22 96.43 439,075.00 15,697.78 Fund number: 56 Tax & Rev CO 2002 I&S Fund 1,585.57 423,377.22 96.43 439,075.00 15,697.78 58-7045-00-00 Cert. Of Oblig. 2003 I&S 1,421.20 379,485.86 96.37 393,785.00 14,299.14 Subtotal 1,421.20 379,485.86 96.37 393,785.00 14,299.14 58-7650-00-00 Interest Earned 1,631.52 13,566.77 - (13,566.77) July Revenues.xls 7 8/6/2007 Revenue Comparison July, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance Subtotal 1,631.52 13,566.77 - (13,566.77 ProQram number: 3,052.72 393,052.63 99.81 393,785.00 732.37 Department number NON-departmental 3,052.72 393,052.63 99.81 393,785.00 732.37 Fund number: 58 2003 GO Refundina Bonds 3,052.72 393,052.63 99.81 393,785.00 732.37 71-8350-00-00 City Deposits 18,299.68 - (18,299.68) Subtotal 18,299.68 - (18,299.68 ProQram number: 18,299.68 - (18,299.68) Department number 18,299.68 - (18,299.68 Fund number: 71 Insurance Claims Fund 18,299.68 - (18,299.68 72-7650-00-00 Interest Earned 205.21 2,396.39 - 2,396.39 Subtotal 205.21 2,396.39 - (2,396.39) 72 -8313-00-00 Memorial Donations 325.00 4,045.76 - (4,045.76 Subtotal 325.00 4,045.76 - (4,045.76) Program number: Subtotal 530.21 6,442.15 - (6,442.15 Department number 530.21 6,442.15 - (6,442.15 Fund number: 72 Library Memorial Fund 530.21 6,442.15 - (6,442.15) 79-7650-00-00 Interest 138.93 2,752.91 - (2,752.91 79-7651-00-00 Donation 250.00 - (250.00) Subtotal 138.93 3,002.91 - (3,002.91 PrOQram number: 138.93 3,002.91 - 3,002.91 Department number 138.93 3,002.91 - (3,002.91 Fund number: 79 Library Expendable Fund 138.93 3,002.91 - (3,002.91 ) 80-7650-00-00 Interest 0.96 1,484.70 - 1,484.70) Subtotal 0.96 1,484.70 - 1,484.70) Program number: 0.96 1,484.70 - 1,484.70) Department number 0.96 1,484.70 - 1,484.76\ Fund number: 80 Library Permanent Fund 0.96 1,484.70 - (1,484.70) July Revenues.xls 8 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7010-00-00 Current Taxes 10,950.60 5,941,532.96 100.65 5,903,225.00 (38,307.96 01-7020-00-00 Delinquent Taxes 14,308.73 81,512.84 54.34 150,000.00 68,487.16 01-7030-00-00 Penalty & Interest 6,915.92 74,891.95 74.89 100,000.00 25,108.05 01-7031-00-00 Attorney Fees 2,894.88 23,443.00 58.61 40,000.00 16,557.00 01-7043-00-00 Tax & Rev CO 2000 I&S (742.77) 507,080.75 - (507,080.75 01-7044-00-00 Tax & Rev CO 2002 I&S 3,290.93 439,353.13 - (439,353.13) 01-7045-00-00 Cert of Oblig 2003 I&S 2,892.03 386,098.20 - (386,098.20 Subtotal: 40,510.32 7,453,912.83 120.36 6,193,225.00 (1,260,687.83) 01-7110-00-00 Municipal Sales Tax 329,417.68 3,506,003.62 90.36 3,880,000.00 373,996.38 01-7112-00-00 Sales Tax-Reduce Property Tax 82,354.41 876,500.89 90.36 970,000.00 93,499.11 Subtotal: 411,772.09 4,382,504.51 90.36 4,850,000.00 467,495.49 01-7220-00-00 Hotel-Motel Occupancy Tax 63,654.07 332,595.88 110.87 300,000.00 (32,595.88 Subtotal: 63,654.07 332,595.88 110.87 300,000.00 (32,595.88 01-7310-00-00 Southwestern Bell Telephone Co 129,219.85 78.32 165,000.00 35,780.15 01-7320-00-00 Atmos Gas 620,636.08 124.13 500,000.00 (120,636.08 01-7330-00-00 TXU Electric 1,655,638.79 110.38 1,500,000.00 (155,638.79 01-7340-00-00 Taxicabs 350.00 116.67 300.00 (50.00 01-7350-00-00 TCA Cable 146,927.78 137.32 107,000.00 (39,927.78 01-7360-00-00 Water Sewer Utility - 340,000.00 340,000.00 01-7390-00-00 Bingo 48,238.06 74.21 65,000.00 16,761.94 01-7395-00-00 Municipal ROW Use Fee 1,712.15 24,654.81 58.70 42,000.00 17,345.19 01-7396-00-00 Solid Waste Street Use Fee 20,845.04 214,121.30 97.33 220,000.00 5,878.70 Subtotal: 22,557.19 2,839,786.67 96.61 2,939,300.00 99,513.33 01-7410-00-00 House Moving 300.00 60.00 500.00 200.00 01-7411-00-00 Concrete Permits 200.00 1,200.00 87.27 1,375.00 175.00 01-7412-00-00 Building Permits 4,936.00 59,401.00 108.00 55,000.00 (4,401.00) 01-7413-00-00 Sign Permits 250.00 5,475.00 136.88 4,000.00 (1,475.00) 01-7414-00-00 Electrical Permits 80.00 755.00 68.64 1,100.00 345.00 01-7416-00-00 Gas Inspections 175.00 3,297.50 90.84 3,630.00 332.50 01-7418-00-00 Plumbing Inspections 375.00 3,850.00 98.72 3,900.00 50.00 01-7420-00-00 Electrical Licenses 315.00 1,670.00 49.63 3,365.00 1,695.00 Subtotal: 6,331.00 75,948.50 104.23 72,870.00 (3,078.50) 01-7510-00-00 Court Fines & Costs 27,211.83 237,129.88 68.73 345,000.00 107,870.12 01-7511-00-00 Defensive Driving Course 230.00 2,490.00 58.73 4,240.00 1,750.00 July Revenues.xls 10 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance 01-7512-00-00 Warrant Service Fees {City} 2,896.34 28,851.90 82.43 35,000.00 6,148.10 01-7513-00-00 City Traffic Fees 225.22 2,948.49 62.34 4,730.00 1,781.51 01-7514-00-00 Arrest Fees 1,052.72 11,566.33 71.07 16,275.00 4,708.67 01-7516-00-00 Time Payment Fees Retained 725.34 7,272.69 60.61 12,000.00 4,727.31 01-7517 -00-00 State Judicial Fund due City 109.20 789.21 - (789.21 ) 01-7520-00-00 Pound Fees 935.00 4,175.00 70.17 5,950.00 1,775.00 01-7521-00-00 Pound Incineration Fees 80.00 980.00 31.61 3,100.00 2,120.00 Subtotal: 33,465.65 296,203.50 69.48 426,295.00 130,091.50 01-7610-00-00 Cox Field Leases-Land - 240.00 240.00 01-7620-00-00 Cox Field Leases-Terminal 300.00 3,000.00 83.33 3,600.00 600.00 01-7630-00-00 Cox Field Rent Hangar Storage 60.00 600.00 83.33 720.00 120.00 01-7631-00-00 Cox Field Rental T Hangars 5,724.00 50,721.31 92.22 55,000.00 4,278.69 01-7632-00-00 Cox Field Fuel Flow~ge Fee 1,036.75 7,149.75 79.44 9,000.00 1,850.25 01-7640-00-00 Leases & Rentals 100.00 9,610.30 114.41 8,400.00 (1,210.30) 01-7650-00-00 Interest Earned 43,880.08 229,543.33 382.57 60,000.00 (169,543.331 01-7684-00-00 Great Grant 13,047.24 - (13,047.24) Subtotal: 51,100.83 313,671.93 229.02 136,960.00 (176,711.93) 01-7712-00-00 Recording Legal Instruments 150.00 150.00 - (150.00) 01-7713-00-00 ZoninQ & Subdivision Fees 2,000.00 71.43 2,800.00 800.00 01-7715-00-00 Sale of Maps Copies Etc 2,115.16 9,190.53 153.18 6,000.00 (3,190.53 ) 01-7716-00-00 Tax Certificates 2,057.50 80.69 2,550.00 492.50 Subtotal: 2,265.16 13,398.03 118.04 11,350.00 (2,048.03) 01-7822-00-00 Lamar County Fire Contract 150.00 1,350.00 75.00 1,800.00 450.00 Subtotal: 150.00 1,350.00 75.00 1,800.00 450.00 01-7937-00-00 Streetscape- TXDOT Grant 210,638.01 - (210,638.01) 01-7941-00-00 Tx Hist Comm Grant & Donations - 12,500.00 12,500.00 Subtotal: 210,638.01 II I/::::://;!I 12,500.00 (198,138.01 ) 01-8046-00-00 Sanitation Fees 109,102.33 1,093,354.59 82.52 1,325,000.00 231,645.41 01-8047-00-00 Brush Pickup Fee 636.50 5,320.00 59.11 9,000.00 3,680.00 Subtotal: 109,738.83 1,098,674.59 82.36 1,334,000.00 235,325.41 01-8153-00-00 Lamar Co-Emergency Medical SE 24,667.00 278,626.29 94.13 296,000.00 17,373.71 01-81 54-00-00 Emergency Medical Service Fees 153,442.26 1,609,835.40 95.42 1,687,200.00 77,364.60 Subtotal: 178,109.26 1,888,461.69 95.22 1,983,200.00 94,738.31 01-8260-00-00 State Shared Revenue 11,778.19 45,514.86 126.43 36,000.00 (9,514.86) July Revenues.xls 11 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance Subtotal: 11,778.19 45,514.86 126.43 36,000.00 (9,514.86 01-8308-00-00 Birth Certificate Fee for TWC (376.20) 171.00 - (171.00 01-8309-00-00 Birth Certificate Fees 1,919.00 14,744.20 165.67 8,900.00 (5,844.20 01-831 0-00-00 Death Certificate Fees 1,304.00 19,758.00 117.26 16,850.00 (2,908.00) 01-8311-00-00 Library Copies 244.50 1,829.32 69.03 2,650.00 820.68 01-8312 -00-00 Library Fines & Other 1,462.39 12,541.62 49.18 25,500.00 12,958.38 01-8325-00-00 Sale of City Property - 10,000.00 10,000.00 01-8330-00-00 Materials & Labor Sold 581.57 8,237.39 74.89 11,000.00 2,762.61 01-8331-00-00 Lot Clean Up 870.84 8,790.20 175.80 5,000.00 (3,790.20 01-8332-00-00 Billed Electric (651.68) (21,221.17) (84.89) 25,000.00 46,221.17 01-8333-00-00 Refund Landfill Fee-Demolition 6,080.67 31,051.55 - (31,051.55 01-8350-00-00 Miscellaneous Revenue (20,088.16) 123,332.03 308.33 40,000.00 (83,332.03 01-8354-00-00 EMS Golf Cart Donations 200.00 - (200.00) 01-8359-00-00 Special Projects 5.00 - (5.00) 01-8365-00-00 VCC Band Contribution - 10,000.00 10,000.00 01-8366-00-00 Credit Card Convenience Fee 50.10 525.38 - (525.38) 01-8368-00-00 Library Card Fees 1,245.00 13,361.30 89.08 15,000.00 1,638.70 Subtotal: (7,357.97) 213,325.82 125.56 169,900.00 (43,425.82) 01-8499-00-00 Water & Sewer Transfer - 750,000.00 750,000.00 Subtotal: - 750,000.00 750,000.00 01-8500-00-00 Pool VendinQ 2,568.16 6,171.91 64.97 9,500.00 3,328.09 01-8501-00-00 Pool Programs 4,835.00 14,969.00 104.68 14,300.00 (669.00) 01-8502-00-00 Pool Daily Fees 6,793.00 13,728.00 98.06 14,000.00 272.00 01-8503-00-00 Sports Complex 3,475.35 30,764.82 99.24 31,000.00 235.18 01-8504-00-00 Softball 8,750.00 22,710.00 63.97 35,500.00 12,790.00 01-8505-00-00 Reservations 520.00 3,945.00 179.32 2,200.00 (1,745.00 01-8506-00-00 Sponsorships 85.00 85.00 - (85.00 01-8507 -00-00 Special Events 3,472.75 13,149.25 125.23 10,500.00 (2,649.25 Subtotal: 30,499.26 105,522.98 90.19 117,000.00 11,477.02 Program number: 954,573.88 19,271,509.80 99.68 19,334,400.00 62,890.20 Department number 954,573.88 19,271,509.80 99.68 19,334,400.00 62,890.20 Fund number: 1 General Fund 954,573.88 19,271,509.80 99.68 19,334,400.00 62,890.20 02-7111-00-00 Economic Development Sales Ta 82,354.41 876,500.89 90.36 970,000.00 93,499.11 Subtotal: 82,354.41 876,500.89 90.36 970,000.00 93,499.11 July Revenues.xls 12 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance 02-7650-00-00 Interest Earned 582.87 18,133.07 362.66 5,000.00 (13,133.07) Subtotal: 582.87 18,133.07 362.66 5,000.00 (13,133.07) 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 320,000.00 83.33 384,000.00 64,000.00 Subtotal: 32,000.00 320,000.00 83.33 384,000.00 64,000.00 ProQram number: 114,937.28 1,214,633.96 89.38 1,359,000.00 144,366.04 Department number Revenues 114,937.28 1,214,633.96 89.38 1,359,000.00 144,366.04 Fund number: 2 Economic Development Fund 114,937.28 1,214,633.96 89.38 1,359,000.00 144,366.04 10-7010-00-00 Sewer Charges 423,850.61 4,002,026.83 87.00 4,600,000.00 597,973.17 10-7011-00-00 Industrial Surcharges 11,900.25 106,819.68 71.21 150,000.00 43,180.32 10-7020-00-00 Sewer Taps 1,020.00 7,215.00 51.54 14,000.00 6,785.00 10-7022-00-00 Pro Rata Sewer Line Extension 3,136.44 28,148.31 II//::::::!.'II 1,000.00 (27,148.3f) Subtotal: 439,907.30 4,144,209.82 86.97 4,765,000.00 620,790.18 1 0- 7130-00-00 Water Sales 775,787.25 6,000,960.04 89.57 6,700,000.00 699,039.96 1 0-7140-00-00 Water Taps 3,320.00 13,855.00 69.28 20,000.00 6,145.00 10-7142-00-00 Pro Rata Water Line Extension 205.88 8.17 2,520.00 2,314.12 Subtotal: 779,107.25 6,015,020.92 89.48 6,722,520.00 707,499.08 10-7650-00-00 Interest Earned 28,179.85 122,781.99 98.23 125,000.00 2,218.01 Subtotal: 28,179.85 122,781.99 98.23 125,000.00 2,218.01 10-8350-00-00 Miscellaneous W &S 5,189.72 77,598.67 110.86 70,000.00 (7,598.67) 10-8352-00-00 Sanitation BillinQ Fee 5,742.23 57,545.01 82.21 70,000.00 12,454.99 10-8354-00-00 Service CharQes 4,795.00 50,415.30 77.56 65,000.00 14,584.70 1 0-8355-00-00 Brush Pickup Fees 33.50 280.00 5.60 5,000.00 4,720.00 10-8356-00-00 Bulk Water Sales 270.48 3,148.07 31 .48 10,000.00 6,851.93 10-8357-00-00 Sewer Dumping Fees 3,552.72 41,855.04 119.59 35,000.00 (6,855.04 ) 1 0-8358-00-00 W &S Charge Ofts 121.52 (65,833.15) 77.45 (85,000.00) (19,166.85) 10-8359-00-00 W&S Returned Check Fees 1,110.00 7,845.00 112.07 7,000.00 (845.00) 1 0-8360-00-00 W &S Copies 4.44 56.02 186.73 30.00 (26.02) 1 0-8366-00-00 Credit Card Convenience Fee 321.68 2,665.00 205.00 1,300.00 (1,365.00) 10-8367 -00-00 Deposits Billed (75.00) 200.00 - (200.00) 1 0-8368-00-00 Bulk Pickup Fees 180.00 - (180.00) Subtotal: 21,066.29 175,954.96 98.67 178,330.00 2,375.04 ProQram number: 1,268,260.69 10,457,967.69 88.70 11,790,850.00 1,332,882.31 Department number Revenues 1,268,260.69 10,457,967.69 88.70 11,790,850.00 1,332,882.31 Fund number: 10 Water & Sewer Fund 1,268,260.69 10,457,967.69 88.70 11,790,850.00 1,332,882.31 July Revenues.xls 13 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 11-7650-00-00 Interest Earned 258.98 1,632.12 - (1,632.12 Subtotal: 258.98 1,632.12 - (1,632.12 ProQram number: 258.98 1,632.12 - (1,632.12 Department number 258.98 1,632.12 - (1,632.12 Fund number: 11 Capital Proiects Fund 258.98 1,632.12 - (1,632.12 12-7650-00-00 Interest Earned 6,773.38 42,888.48 - (42,888.48 Subtotal: 6,773.38 42,888.48 - (42,888.48) Program number: 6,773.38 42,888.48 - (42,888.48) Department number 6,773.38 42,888.48 - (42,888.48 Fund number: 12 WW &SS Rev Bond 2000 Const F 6,773.38 42,888.48 - (42,888.48) 20-7002-00-00 Municipal Court Tech Fee 894.51 9,582.39 73.71 13,000.00 3,417.61 20-7003-00-00 Court Security Fee 672.85 7,346.87 73.47 10,000.00 2,653.13 20-7004-00-00 Child SafetY Fee 3.82 697.77 69.78 1,000.00 302.23 20-7005-00-00 Time Payment Fee 181.33 1,942.76 76.19 2,550.00 607.24 20-7006-00-00 Conf Funds-Gambling PO Fee 1,535.48 - (1,535.48) 20-7007-00-00 Judicial Forfeitures Fee 720.01 14.40 5,000.00 4,279.99 Subtotal: 1,752.51 21,825.28 69.18 31,550.00 9,724.72 20-7650-00-00 Interest Earned 80.05 948.04 - (948.04 Subtotal: 80.05 948.04 - (948.04 Program number: Special Revenue 1,832.56 22,773.32 72.18 31,550.00 8,776.68 Department number Special Revenue 1,832.56 22,773.32 72.18 31,550.00 8,776.68 Fund number: 20 Special Revenue Fund 1,832.56 22,773.32 72.18 31,550.00 8,776.68 21-7650-00-00 Interest Earned 14.99 206.81 - (206.81 ) Subtotal: 14.99 206.81 - (206.81 ) Program number: Think Child Safety 14.99 206.81 - (206.81) Department number Child Safety Fund 14.99 206.81 - (206.81 ) Fund number: 21 Child Safety Fund 14.99 206.81 - (206.81 ) 22-7650-00-00 Interest Earned 5.07 5.07 - (5.07 Subtotal: 5.07 5.07 - (5.07) 22 -8151-00-00 Local Fees 9,041.00 24,790.00 29.05 85,349.00 60,559.00 22 -8152 -00-00 ORAS 99,787.08 83.16 120,000.00 20,212.92 22 -8155-00-00 Lamar County 76,188.84 76.19 100,000.00 23,811.16 22 -8156-00-00 Primary Health Care Program 14,853.83 156,076.82 71.60 218,000.00 61,923.18 22 -8158-00-00 State of Texas-WIC 19,271.59 249,210.43 115.01 216,685.00 (32,525.43 July Revenues.xls 14 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance 22 -8160-00-00 City of Paris 76,188.84 76.19 100,000.00 23,811.16 22-8170-00-00 Primary Health Care ProQ Fees 475.00 8,660.50 288.68 3,000.00 (5,660.50) 22 -81 71-00-00 ORAS Local Fees 4,235.00 47,810.00 191.24 25,000.00 (22,810.00) 22-8172-00-00 Immunization Grant 9,188.54 25,909.89 51.82 50,000.00 24,090.11 22 -81 74-00-00 Immunization Fees 1,340.00 26,052.50 130.26 20,000.00 (6,052.505 22-8175-00-00 Prenatal Care Grant 7,867.36 8,112.86 40.56 20,000.00 11,887.14 22-8176-00-00 Prenatal Care Fees 290.00 1,764.00 - (1,764.00) 22 -8177 -00-00 Family Planning Grant 70.00 0.65 10,781.00 10,711.00 22-8178-00-00 Family PlanninQ Fees 20.00 80.00 - (80.00) Subtotal: 66,582.32 800,701.76 82.65 968,815.00 168,113.24 ProQram number: Health Department 66,587.39 800,706.83 82.65 968,815.00 168,108.17 Department number Health Department 66,587.39 800,706.83 82.65 968,815.00 168,108.17 Fund number: 22 Health Department Fund 66,587.39 800,706.83 82.65 968,815.00 168,108.17 25-7001-00-00 Paris ISO School Officers 12,724.75 165,375.58 109.54 150,973.00 (14,402.58) 25-7002-00-00 No. Lamar ISO School Officers 12,678.58 187,305.80 124.52 150,425.00 (36,880.80) 25-7003-00-00 Violent Crimes AQainst Women 46,751.71 58.44 80,000.00 33,248.29 25-7004-00-00 Auto Theft Task Force 52,468.04 53.36 98,326.00 45,857.96 25-7005-00-00 Gang Resistance Ed.& Training 10,519.06 25.63 41,040.00 30,520.94 25-7006-00-00 Justice Assistance Grant 30,642.00 121.80 25,158.00 (5,484.00) 25-7007-00-00 THC Grant-Comm. Development - 7,500.00 7,500.00 25-7008-00-00 Grant Match-Police Department - 49,433.00 49,433.00 25-7009-00-00 Grant Match-Comm. Developmer - 5,000.00 5,000.00 Subtotal: 25,403.33 493,062.19 81.12 607,855.00 114,792.81 25-7650-00-00 Interest Earned 80.04 80.04 - (80.04) Subtotal: 80.04 80.04 - (80.04) ProQram number: 25,483.37 493,142.23 81.13 607,855.00 114,712.77 Department number Grant Fund 25,483.37 493,142.23 81.13 607,855.00 114,712.77 Fund number: 25 Grant Fund 25,483.37 493,142.23 81.13 607,855.00 114,712.77 26-7651-00-00 ProQram Income 138,113.70 - (138,113.70) Subtotal: 138,113.70 - (138,113.70) 26-8246-00-00 City of Clarksville 44,965.00 - (44,965.00) 26-8250-00-00 State of Texas 553,997.10 - (553,997.10) Subtotal: 598,962.10 - (598,962.10) ProQram number: 737,075.80 - (737,075.80) July Revenues.xls 15 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BUdget Balance Department number Drug Task Force Grant 737,075.80 - (737,075.80 Fund number: 26 Criminal Justice Div Grant Fd 737,075.80 - (737,075.80 30-7650-00-00 Use of Money Property Interest 163.59 1,967.22 - (1,967.22 Subtotal: 163.59 1,967.22 - (1,967.22 30-7855-00-00 ORCA Owner Occupied Rehab - 5,980.00 5,980.00 30-7856-00-00 Owner Occupied Rehab 22,500.00 - (22,500.00 30-7857-00-00 Home Buyer Assistance Program - 244,500.00 244,500.00 30-7858-00-00 Revolving Loan Fund - 102,500.00 102,500.00 30-7860-00-00 Infrastructure Grant Eastgate 7,500.00 15,000.00 - 15,000.00) Subtotal: 7,500.00 37,500.00 10.62 352,980.00 315,480.00 Program number: 7,663.59 39,467.22 11.18 352,980.00 313,512.78 Department number 7,663.59 39,467.22 11.18 352,980.00 313,512.78 Fund number: 30 Community Dvl Block Grant Fund 7,663.59 39,467.22 11.18 352,980.00 313,512.78 41-7650-00-00 Interest Earned 388.96 11,451.55 - 11,451.55) Subtotal: 388.96 11,451.55 - (11,451.55 Program number: 388.96 11,451.55 - 11,451.55) Department number 388.96 11,451.55 - 11,451.55) Fund number: 41 Tax & Rev CO 2000 Const Fund 388.96 11,451.55 - 11,451.55 42-7650-00-00 Interest Earned 130.48 26,017.76 - (26,017.76) 42-7652-00-00 Forfeited Funds 10,502.00 - (10,502.00 42-7653-00-00 Special Revenue Contributions 62,590.16 - (62,590.16) Subtotal: 130.48 99,109.92 - (99,109.92) Program number: 130.48 99,109.92 - (99,109.92 Department number 130.48 99,109.92 - (99,109.92 Fund number: 42 CO Series 2002 Construction Fd 130.48 99,109.92 - 99,109.92) 50-1135-00-00 Transfer to GO Refunding 2003 65,000.00 65,000.00 - (65,000.00) Subtotal: 65,000.00 65,000.00 - (65,000.00) 50-7650-00-00 Use of Money Property Interest 6,321.36 57,785.56 - (57,785.56) Subtotal: 6,321.36 57,785.56 - (57,785.56) Program number: 71,321.36 122,785.56 - (122,785.56) Department number 71,321.36 122,785.56 - (122,785.56) Fund number: 50 Revenue Bonds Sinking Funds 71,321.36 122,785.56 - (122,785.56 55-7043-00-00 Tax & Rev COs 2000 I&S - 510,498.76 510,498.76 Subtotal: - 510,498.76 510,498.76 July Revenues.xls 16 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 55-7650-00-00 Interest Earned 211.66 1,325.12 - (1,325.12) Subtotal: 211.66 1,325.12 - (1,325.12) Pr~gram number: 211.66 1,325.12 0.26 510,498.76 509,173.64 Department number 211.66 1,325.12 0.26 510,498.76 509,173.64 Fund number: 55 Tax & Rev CO 2000 I&S Fund 211.66 1,325.12 0.26 510,498.76 509,173.64 56-7044-00-00 Tax & Rev cas 2002 I&S - 437,672.50 437,672.50 Subtotal: - 437,672.50 437,672.50 Program number: - 437,672.50 437,672.50 Department number Tax & Revenue 2002 - 437,672.50 437,672.50 Fund number: 56 Tax & Rev CO 2002 I&S Fund - 437,672.50 437,672.50 58-7045-00-00 Cert. Of Oblig. 2003 I&S - 391,625.00 391,625.00 Subtotal: - 391,625.00 391,625.00 58-7650-00-00 Interest Earned 406.48 7,842.31 - (7,842.31 ) Subtotal: 406.48 7,842.31 - (7,842.31 ) Program number: 406.48 7,842.31 2.00 391,625.00 383,782.69 Department number NON-departmental 406.48 7,842.31 2.00 391,625.00 383,782.69 Fund number: 58 2003 GO Refunding Bonds 406.48 7,842.31 2.00 391,625.00 383,782.69 70-8350-00-00 Claim Payment Refunds 47.60 1,093,746.53 - (1,093,746.53) Subtotal: 47.60 1,093,746.53 - (1,093,746.53) Program number: 47.60 1,093,746.53 - (1,093,746.53) Department number 47.60 1,093,746.53 - (1,093,746.53) Fund number: 70 Employees Insurance Fund 47.60 1,093,746.53 - (1,093,746.53) 71-8350-00-00 City Deposits 21,128.88 - (21,128.88) Subtotal: 21,128.88 - (21,128.88) Program number: 21,128.88 - (21,128.88) Department number 21,128.88 - (21,128.88) Fund number: 71 Insurance Claims Fund 21,128.88 - (21,128.88) 72-7650-00-00 Interest Earned 251.61 1,430.90 - (1,430.90) Subtotal: 251.61 1,430.90 - (1,430.90) 72-8313-00-00 Memorial Donations 286.00 9,750.95 - (9,750.95) Subtotal: 286.00 9,750.95 - (9,750.95\ Program number: 537.61 11,181.85 - (11,181.85) Department number 537.61 11,181.85 - (11,181.85) Fund number: 72 Library Memorial Fund 537.61 11,181.85 - (11,181.85) July Revenues.xls 17 8/6/2007 Revenue Comparison July, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance 77-7650-00-00 Interest 9,096.61 - (9,096.61 Subtotal: 9,096.61 - (9,096.61 ProQram number: 9,096.61 - (9,096.61 Department number 9,096.61 - (9,096.61 Fund number: 77 W B & Kathryn Vaughan Memoric 9,096.61 - (9,096.61 ) 79-7650-00-00 Interest 355.06 2,188.70 - (2,188.70 79-7651-00-00 Donation 15,000.00 21,090.20 - (21,090.20 Subtotal: 15,355.06 23,278.90 - (23,278.90 ProQram number: 15,355.06 23,278.90 - (23,278.90) Department number 15,355.06 23,278.90 - (23,278.90' Fund number: 79 Library Expendable Fund 15,355.06 23,278.90 - (23,278.90) 80-7650-00-00 Interest 348.72 2,197.68 - (2,197.68) Subtotal: 348.72 2,197.68 - (2,197.68 Proqram number: 348.72 2,197.68 - (2,197.68) Department number 348.72 2,197.68 - (2,197.68) Fund number: 80 Library Permanent Fund 348.72 2,197.68 - (2,197.68' July Revenues.xls 18 8/6/2007 Departmental Expenditure Summary Comparison July, 2007 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Bud_get Actual Balance 01 City Council 103.60 10,983.28 92,950.00 96,294.18 (3,344.18) 01 City Manager 83.79 9,124.24 155,064.00 129,927.77 25,136.23 01 Ci!y Attorn~ 73.93 26,420.12 369,581.00 273,211.93 96,369.07 01 Municipal Court 81.89 12,191.49 204,684.00 167,609.36 37,074.64 01 City Clerk 75.38 8,230.94 117,919.00 88,888.43 29,030.57 01 Accounting & Auditing 84.88 31,155.60 429,069.00 364,212.77 64,856.23 01 Police 74.96 393,245.96 5,229,669.00 3,920,173.04 1,309,495.96 01 Fire 71.76 249,723.54 3,506,050.00 2,515,845.35 990,204.65 01 Communi!y Development 60.11 30,143.04 652,017.00 391,941.97 260,075.03 01 Engineerirlg 71.91 29,156.75 453,399.00 326,024.44 127,374.56 01 Public Works 80.82 10,148.36 136,547.00 110,362.00 26,185.00 01 Parks,Recreation,& ROW 69.96 (15,687.90) 1,123,930.00 786,321.28 337,608.72 01 Sanitation 67.59 85,067.17 1,204,999.00 814,428.99 390,570.01 01 Streets & H!ghwa~ 56.88 84,715.78 1,969,233.00 1,120,179.73 849,053.27 01 Traffic & Public Llghti~ 69.67 8,416.28 505,409.00 352,129.42 153,279.58 01 Garage 74.76 19,281.75 278,130.00 207,942.19 70,187.81 01 Emergency Medical Service 80.63 159,038.00 2,124,118.00 1,712,649.72 411,468.28 01 Cox Field Ai!:Qort 39.48 17,493.52 254,592.00 100,506.56 154,085.44 01 Paris Band 92.18 18,781.97 20,850.00 19,219.44 1,630.56 01 LibrC!'}' 69.42 46,428.17 630,511.00 437,673.16 192,837.84 01 General Expenses 88.93 33,634.05 744,146.00 661,745.75 82,400.25 01 Contingency 6.66 302,705.00 20,151.76 282,553.24 General Fund 71.29 1,267,692.11 20,505,572.00 14,617,439.24 5,888,132.76 02 PEDC 14.32 23,854.72 1,570,862.00 224,937.28 1,345,924.72 Debt 57.19 37,178.13 833,138.00 476,499.43 356,638.57 Economic Development Fund 29.18 61,032.85 2,404,000.00 701,436.71 1,702,563.29 10 Warehouse 78.68 7,704.03 103,642.00 81,548.68 22,093.32 10 W & S Billing and Collecting 82.96 136,358.31 1,582,316.00 1,312,641.72 269,674.28 10 Water Production 64.83 102,153.72 2,568,133.00 1,665,026.67 903,106.33 10 Water Distribution 74.74 72,669.25 1,277,370.00 954,667.92 322,702.08 10 Sewer Maintenance 75.23 29,968.82 618,733.00 465,471.03 153,261.97 10 Waste Water Treatment 79.45 99,501.58 1,907,130.00 1,515,213.84 391,916.16 10 Lift Stations 61.30 15,548.05 428,965.00 262,932.61 166,032.39 10 Debt - 3,956,855.00 3,956,855.00 Water & Sewer Fund 50.29 463,903.76 12,443,144.00 6,257,502.47 6,185,641.53 11 Police - 9,922.08 161,869.00 (161,869.00) Capital Projects Fund - 9,922.08 161,869.00 (161,869.00 12 Streets - 17,620.20 17,620.20 12 Sewer Maintenance - 51,971.62 51,971.62 51,971.62 WW &SS Rev Bond 2000 Con - 51,971.62 69,591.82 69,591.82) 20 Municipal Court 12.17 512.43 127,987.00 15,576.93 112,410.07 20 Police De~artment 151.75 3,595.40 4,500.00 6,828.75 12,328.75) 20 Parks-Main Street - Special Revenue Fund 16.91 4,107.83 132,487.00 22,405.68 110,081.32 21 Emergency Medical Service - (465.69) 230.81 (230.81) Child Safety Fund - 1465.691 230.81 (230.81 ) 22 Health Department 75.05 62,980.47 875,801.00 657,257.36 218,543.64 Health Department Fund 75.05 62,980.47 875,801.00 657,257.36 218,543.64 25 Police 54.58 51,753.05 896,989.00 489,594.62 407,394.38 July Department Expenditures.xls 8/6/2007 Departmental Expenditure Summary Comparison July, 2007 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Budget Actual Balance 25 Airport - 622,223.00 622,223.00 Grant Fund 32.23 51,753.05 1,519,212.00 489,594.62 1,029,617.38 26 Police - 130,224.00 130,224.00 Criminal Justice Div Grant Fd - 130,224.00 130,224.00 30 Communi~ Develc~Qment - 9,000.00 25,200.00 25,200.00 Community Dvl Block Grant F - 9,000.00 25,200.00 25,200.00 41 City Council - 4,276.00 52,032.91 52,032.91 ) 41 Street Department - 13,956.00) 3,956.00 Tax & Rev CO 2000 Const Fu - 4,276.00 48,076.91 48,076.91 42 Police D~artment - 8,246.48 (8,246.48) CO Series 2002 Construction - 8,246.48 {8,246.48) 50 Debt Service 99.93 (393,285.00) 3,956,855.00 3,953,960.82 2,894.18 Revenue Bonds Sinking Fund 99.93 (393,285.00) 3,956,855.00 3,953,960.82 2,894.18 55 Debt Service 100.00 510,145.00 510,142.51 2.49 Tax & Rev CO 2000 I&S Func 100.00 510,145.00 510,142.51 2.49 56 Debt Service 99.91 439,075.00 438,661.00 414.00 Tax & Rev CO 2002 I&S Func 99.91 439,075.00 438,661.00 414.00 58 Debt Service 99.87 393,285.00 393,785.00 393,285.00 500.00 2003 GO Refunding Bonds 99.87 393,285.00 393,785.00 393,285.00 500.00 72 Libr<!ry - 192.06 778.57 j778.57 Library Memorial Fund - 192.06 778.57 J]78.57 79 Library - 4,538.00 (4,538.00 Library Expendable Fund - 4,538.00 (4,538.00 July Department Expenditures.xls 2 8/6/2007 Departmental Expenditure Summary Comparison July, 2006 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Bu<!9...et Actual Balance 01 City Council 89.15 12,942.15 488,150.00 435,159.63 52,990.37 01 Ci~ Man~er 77.85 11,639.73 156,047.00 121,481.09 34,565.91 01 Ci~ Attorn~ 61.74 13,870.08 367,644.00 226,967.01 140,676.99 01 Munic~al Court 83.10 15,387.83 194,459.00 161,603.94 32,855.06 01 Ci!}t Clerk 78.54 8,384.91 116,619.00 91,590.46 25,028.54 01 Accountil'!fl & Auditi~ 75.40 30,446.54 566,384.00 427,068.20 139,315.80 01 Police 76.06 386,720.96 4,938,182.00 3,755,953.95 1,182,228.05 01 Fire 77.67 225,639.00 3,185,514.00 2,474,166.03 711,347.97 01 Community Development 79.90 65,456.34 607,597.00 485,489.17 122,107.83 01 E~neeri~ 77.86 31,273.80 438,901.00 341,705.69 97,195.31 01 Public Works 83.50 10,955.97 127,374.00 106,354.34 21,019.66 01 Parks,Recreation,& ROW 82.29 115,874.41 1,044,122.00 859,215.67 184,906.33 01 Sanitation 72.36 140,310.70 1,392,436.00 1,007,581.35 384,854.65 01 Streets & H~hw~ 78.03 126,332.58 1,419,075.00 1,107,364.93 311,710.07 01 Traffic & Public Ll9htil'!fl 94.19 42,908.90 424,170.00 399,509.00 24,661.00 01 Gar~e 77.09 18,307.79 228,473.00 176,120.74 52,352.26 01 Eme!Renq Medical Service 83.28 152,820.17 1,957,083.00 1,629,861.56 327,221.44 01 Cox Field Ai~ort 51.70 9,031.64 239,858.00 124,001.46 115,856.54 01 Paris Band 88.90 18,502.07 20,850.00 18,536.52 2,313.48 01 Libr~ry 80.85 47,499.35 601,777.00 486,557.98 115,219.02 01 Conti~en~ - 280,982.00 280,982.00 General Fund 76.81 1,484,304.92 18,795,697.00 14,436,288.72 4,359,408.28 02 PEDC 30.10 99,144.45 950,983.00 286,217.05 664,765.95 Debt 57.96 37,178.13 833,138.00 482,893.18 350,244.82 Economic Develo~ment Fund 43.11 136,322.58 1,784,121.00 769,110.23 1,015,010.77 10 Warehouse 83.16 7,922.51 95,663.00 79,552.92 16,110.08 10 W & S Billing and Collecting 28.60 23,975.75 1,576,259.00 450,807.52 1,125,451.48 10 Water Production 91.26 245,989.63 2,063,489.00 1,883,213.25 180,275.75 10 Water Distribution 81.62 114,109.74 1,089,971.00 889,591.93 200,379.07 10 Sewer Maintenance 67.17 32,917.59 593,733.00 398,820.77 194,912.23 10 Waste Water Treatment 76.43 100,295.20 1,931,722.00 1,476,474.76 455,247.24 10 Lift Stations 65.68 25,351.96 368,004.00 241,702.50 126,301.50 10 Debt - 3,960,758.77 3,960,758.77 Water & Sewer Fund 46.41 550,562.38 11,679,599.77 5,420,163.65 6,259,436.12 12 Sewer Maintenance - 5,000.00 15,000.00) WW &SS Rev Bond 2000 Cor - 5,000.00 ~5,000.00) 20 Municipal Court 37.15 990.97 225,867.00 83,906.88 141,960.12 20 Police Department 67.18 18,600.00 12,496.00 6,104.00 ~pecial Revenue Fund 39.43 990.97 244,467.00 96,402.88 148,064.12 21 Emergen9' Medical Service 74.56 2,778.10 10,000.00 7,455.60 2,544.40 Child Safe~Fund 74.56 2,778.10 10,000.00 7,455.60 2,544.40 22 Health Department 66.59 60,029.22 970,111.00 645,948.37 324,162.63 Health Department Fund 66.59 60,029.22 970,111.00 645,948.37 324,162.63 25 Police 76.57 45,275.11 596,743.00 456,918.21 139,824.79 25 Community Developement - 12,500.00 12,500.00 Grant Fund 75.00 45,275.11 609,243.00 456,918.21 152,324.79 26 Police 433.01 130,224.00 563,885.45 (433,661.45) Criminal Justice Div Grant Fd 433.01 130,224.00 563,885.45 (433,661.45) 30 Communi~ Devel~I>ment 30.53 31,400.00 381,980.00 116,600.00 265,380.00 July Department Expenditures.xls 3 8/6/2007 ,> _-__.~_M__._.,____,_'"~_._____. "-"__'_'_.________ .,' _.~__~~....__._'>>_~_.____~_____"__._.._._,_...~...~___.__.~.. Departmental Expenditure Summary Comparison July, 2006 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Budget Actual Balance Community Dvl Block Grant F 30.53 31,400.00 381,980.00 116,600.00 265,380.00 41 Ci!y Council - 4,067.21 63,406.49 (63,406.49) 41 Parks Department - (1,950.00) 1,950.00 41 Street Department - 126,997.07 1,157,461.58 11,157,461.58) Tax & Rev CO 2000 Const F~ - 131,064.28 1,218,918.07 (1,218,918.07) 42 City Council - 10,208.85 (10,208.85\ 42 Police Department - 2,999,639.14 (2,999,639.14) CO Series 2002 Construction - 3,009,847.99 (3,009,847.99) 50 Debt Service 99.93 3,960,758.77 3,957,867.07 2,891.70 Revenue Bonds Sinking Fu~ 99.93 3,960,758.77 3,957,867.07 2,891.70 55 Debt Service 100.00 510,498.76 510,498.76 Tax & Rev CO 2000 I&S Fun( 100.00 510,498.76 510,498.76 56 Debt Service 99.77 437,672.50 436,672.50 1,000.00 Tax & Rev CO 2002 I&S Fun( 99.77 437,672.50 436,672.50 1,000.00 58 Debt Service 99.87 391,625.00 391,125.00 500.00 2003 GO Refunding Bonds 99.87 391,625.00 391,125.00 500.00 72 Library - 44.92 1,443.71 (1,443.71 ) Library Memorial Fund - 44.92 1,443.71 (1,443.71 79 Library - 17,874.60 (17,874.60 Library Expendable Fund - 17,874.60 (17,874.60 July Department Expenditures.xls 4 8/6/2007