Loading...
13 Monthly Financial Report l;8JAction CITY OF PARIS, TEXAS CITY COUNCIL AGENDA REQUEST MEETING DATE: I July 23,2007 D Discussion l;8Jlnformation DRefer to: SUBMITTED BY: I Gene Anderson, Finance Director DESCRIPTION: June 2007 financial report. BACKGROUND INFORMATION: Monthly report to Council with explanatory comments. FISCAL AUTHORITY: Information only. LEGAL REVIEW: I MANAGER'S RECOMMENDATION: City of Paris June 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,303,252 collected to date for current taxes exceeds the $5,930,582 collected at this same time last year. The 2005-06 "Taxes Collected" number of $7,413,402 included $1,327,091 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.72% above this point last year. 3. Hotel taxes are up 17.68% from this time last year. The most recent quarterly payment by local hotels would reflect the full hotel booking due to the archery tournament. 4. "Franchise Fees" are lower at this point of 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 this year due to Kimberly Clark's 20 million dollar expansion. This permit alone was over $45,000. 6. Court fines are up 11.76% from this time last year. 7. The "Leases & Grants" category is up 65.82% 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. 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. 9. Water & Sewer "Miscellaneous" revenues are now ahead oflast year due to reduced utility charges offs ($21,400.28 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, 10. The City Council expense to date is higher than expected due to payments made to the Pace Group and higher than expected election costs. 11. 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 ofthe City Manager. The City has to pay for each hour worked without the benefit of having someone who is a salaried exempt employee. 12. 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. 13. 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 $4,347,245.82. The Water & Sewer 2003 1& S Fund is due a reimbursement from the General Obligation 2003 I & S Fund which will reduce the expenditure amount to an amount equal to the budgeted amount. Net to Date Comparison DescriDtion 2007 2006 Net to Date General Fund Taxes Collected 6,487,109.44 7,413,402.51 (926,293.07) Sales Tax 4,198,013.69 3,970,732.42 227,281 .27 Hotel-Motel Tax 316,501.20 268,941.81 47,559.39 Franchise Fees 2,391,843.80 2,817,229.48 (425,385.68) Permits 88,431.42 69,617.50 18,813.92 Court Fines 293,646.24 262,737.85 30,908.39 Leases & Grants 435,398.47 262,571.10 172,827.37 Fees & Copies 10,700.79 11,132.87 (432.08) Lamar County Fire 1,350.00 1,200.00 150.00 Street Scape Grant 17,576.07 210,638.01 (193,061.94) Sanitation Fees 981,511.91 988,935.76 (7,423.85) EMS Fees 1,744,684.99 1,710,352.43 34,332.56 State Revenue 37,507.61 33,736.67 3,770.94 Miscellaneous Fees 230,552.08 220,683.79 9,868.29 Summer Proarams 75,113.02 75,023.72 89.30 General FundTot~IRevenues17,309.940.73o, 18,3J6,93~.921 (1.0~,;995.19) I General Fund Total Expenditures.' --:--" I .~$;S4~.747.t3.:' 12;951:9:~3;eo I.. 397:76~.~33 Netto Date .' ,'_'3;960;193~60 . ,5.364S52.121 .... t1~404. 758:52) PEDC Fund Sales Tax 839,602.70 794,146.48 45,456.22 Interest Earned 10,458.79 17,550.20 (7,091.41) Loan Payments 288,000.00 288,000.00 0.00 PEDC Fund Total Revenues == ' 1,138,061.49 I .1,099,696.68' :,.' 38,364.81 PEDC Fund Total Expenditures '. 640,403.86. 632.787.65..... 7,616.21 Net to Date . . 497.657;63" 406.90et03 30.748;60 Water & Sewer Fund Sewer Water Interest Earned Miscellaneous 3,624,632.62 5,278,058.37 146,765.83 197,494.89 3,704,302.52 5,235,913.67 94,602.14 154,888.67 (79,669.90) 42,144.70 52,163.69 42,606.22 was FundTotalJ~evenues . .. ,'. W&S Fund Total' Exoenditures '.' NettoDate .' Capital Projects Fund Interest Earned Auction Proceeds 1 9.246,951.71 .." 9.189.707.00....,57.244.7:1 " 5,793,598.72. .... . 4..869.60;1~27 I 923~997.45 g~453;352.99' 4;320. 1 <l5.73 866.752.74) 5,466.22 1,373.14 4,093.08 0.00 Caoital Proiects Fund Revenues 1==:;:5,466.22, 1,373.14 4,093.08 . Caoital Proiects.fund Expenditures ' ... I 1'51,946.92" .;,.... . ....... I Net to Date . . '146,480.70) 1.373.1'4 (147.853.84) WW&SS Rev Bond 2000 Construction Interest Earned 20,131 .75 36,115.10 56,246.85 WW&SS Rev Bond 2000 Const Revenues.20,13.1 .751.36,115.10 I 15,983.35) WW&SS Rev Bond 2000Cbi:1st Fund EXD.enditures '. '\;'1l,620.2~~' 5,000.001 .... .12.62lJ'.:20 NeftoDate ,.....,. /'...... '2.511.55L"3:f~115.101 .... 2&,603.551 June Net to Date.xls 7/6/2007 Net to Date Comparison Descriotion 2007 2006 Net to Date SDecial Funds Special Funds Interest Earned 27,730.55 595.42 20,072.77 867.99 7,657.78 (272.57) S,ecial Revenue , Funds Revenue . S jiCiatlievenue:l?bhds EXDenditures. ,.' Net to E>'ate . " Child Safety Fund Interest Earned , , . ~,4~;a25.9~j"" . 2,O;940~ilo6 7,3a5~21 ~18;297.85, :" >t95,41'1:';91 ~71,114:oa: 10,028~:1'2"1" "'(74.~71.1~ ""8~:499.2t 6.47 191.82 (185.35 Child$afet FundRevenues , ' ", ".6.47 ~ ' / 1,9Jl.82;i" ,1185.35' ChildSafef:FundExoenditures .' -2-' .... _696.5<!:L_4~'677.50" . a~981..00 Netto'oate ,.' _ '~690.0351----r4,485~68 3,795'i65 Health Department Interest Earned 467.07 467.07 Fees & Grants 672,371.31 734,119.44 (61,748.13 ,ldealtQ./Department Fund Revenues Health Department Fund EXDenditures . Netto Date ,. . Grant Fund = 'z 67~i838:38 ' ," 734, 119.44 {61,281;~),6 , 594,276.89L"'58S.i'l9.15" ,8,357.74< , , 78~61.49.' 148~200:49' (69,636..80 Grants Interest Earned 392,053.48 1,207.20 467,658.86 (75.605.38\ 1 ,207.20 Grant Fund Revenues ' " Grant Fund EXDenditures . . Netto Date' " .'. Criminal Justice Fund Program Income Contributions Interest Earned '. S' 393,260~681 '. " 467,658:8~.~74,398:18 . 43"1),841..5'1 ~411,e43~10 / , '26,1;98.47 (44;580.89) '56,015.76 I 100,596~65 138,113.70 598,962.10 (138,113.70 (598,962.10 42.44 42.44 Grr..inaTllastlill{ l!1II Granl ~ c//< '" - ,c_1IIIJIII'L//< 1II!f~ TI,1IIl3c:36 ~ CrimInal. Justice" Div Grant FdExDenditures < -----=--=--, . 563i88S:45 563,885.45 Netto Date, >. ' , ~42;44 I' 173J1'90.35 "17~;147.91 Community Development Block Grant Interest Earned Grants 1 ,445.42 78,650.00 1 ,803.63 30,000.00 (358.21 48,650.00 Community Dvl BlOCk Grant Fd'Revenues' .,' " 80,095.42 '31.803.6~: 48,291.79 Communitv,Dvl Block Grant Fd EXQ.enditures ';16.200:0~85,200:0~..J.- (69,000.0,0 Netto Date ,-:-"" " 63,895.4~53.396.371 .117,291.79 Tax & Rev CO 2000 Const Fund Interest Earned Grants 4,255.99 (11,795.88' 11,062.59 6,806.60\ (11,795.88 TaK& Rev CO 2000 Const Fund Revenues --:.::.== (:~s539.89) 11,062.59;,." ;{t8~602.48 Tax&(Re~eO 2000 ConstF~enditures "_::.:..J;4'3i800;9'ht,1,08~85~:?9 (1,044,0"52;a~ Net to Date . _..:;.,,2..::> I 51,340.80: 1;()76,791.20\J;025,450:<40 June Net to Date.xls 2 7/6/2007 Net to Date Comparison Description CO Series 2002 Construction Fd Interest Earned Forfeited Funds Special Revenue Contributions 2007 2006 Net to Date 83.62 25,887.28 10,502.00 62,590.16 (25,803.66 I CO Series 2002 constructioOFc:iRe.venues!iil" aa:621!j' 98'919A41' (98,89&a2 , 00 Sellies 2002ConsJb,ictionFcj"Exoenc1itures ".tr:~46.48S.,009.847.9>> ~,00j.60t.5i1: Netto Date " . . 8,162.86. 2,a;10,8681:S5 2,902,~'l05.69 Revenue Bonds Sinking Funds Transfer to GO RefundinQ 2003 Interest Earned 405,000.00 60,380.89 51,464.20 405,000.00 8,916.69 I Revenue Bonds..Sinking Funds Revenues" ,.'. . 465.380;89C1.... 51.~64.20;l.;A13,916.69. ReveriueBo!!2!:8rnking Funds Exoenditur~ 4,347.245.82. '3,951;867:;OZ: '3.'89.318.75 I Netto Date _ ,,' .... ---r (a~881.8a4.93 ." 3,906,402:87) 24;537~94 Tax & Rev CO 2000 1&5 Fund Tax & Rev cas 2000 1&8 493,495.23 Interest Earned 1,229.11 1,113.46 115.65 Tax & Rev CO 2000 1&8 Fund Revenues,." 1,229.11;: ,;\1 ,1t~;4~6 115,.65 vax. & Rev CO 2000 1&8 FundExP~ .', ':' 511}~42:51 _ 510.198.76. . ...., (356;25' NetaoDate " .< ~ 508,913.40 ~509.385.30 .' 471.90 Tax & Rev CO 2002 1&5 Fund Tax & Rev cas 2002 1&8 420,904.00 420,904.00 . Tax.& Rev CO 2002 I&S Fund Revenues'=+ip - .. *!; - P' ~1IIi!OIIIlII T axr.&,Rev CO 2002 1&$ Flmd. Exoenditlil'es,", .' . I ," 438,661,00, . 436;e72.5~'\\* 1,988.50: Netto Date . ' ..' (17,757.00. 436,672.50\ 418',915.50 2003 GO Refunding Bonds Cert Of Oblig. 2003 1&8 Interest Earned 377,269.04 11,935.25 7,435.83 377,269.04 4,499.42 I 2003:iG.6 RefUrid~ng,Bonds ReV enu~s ~< _,2llIl.. 111191', t8:1,768,46' I 2003 GO Refunding Bonds EXDendltures " , < -,;;;~, 391,125;''00 (39'1,125.00 I Nefto.,Date . . ... .... ,'c'389~204:29 t '. 383i689.17' 712,893;i6 Employees Insurance Fund Claim Pavment Refunds 1,093,698.93 (1,093,698.93' Em loveeslnsurance Fund Revenues " . ., 515'" .. - . " 1.093,69a.931 (1,093;698.93) I Em' .Iovees Insurance Fund,Exoenditures . . _ ' ,"'" ,- . },o <., moo NeftoDate.. .. '..' ..' ~. ',' - .."1.093.'698~093.,698.931 Library Memorial Fund Interest Earned Memorial Donations 2,191.18 3,720.76 1,179.29 9,464.95 1 ,011.89 (5,744.19) 'l!MMim."~...~- - ~I. 'l1!!'1l1~n" . 10.644.24Y" . . 4,732,30, ~1!Memorlalt~urid;ExDenditUres'.:' '.' " , ,,;~';;~586':51 . "1:,398.79,,:,812.28 Net to Date' '; ...' . .. - ,5,325~43 . , 9,24S,45 3;920:02 June Net to Date.xls 3 7/6/2007 Net to Date Comparison 2007 2006 Net to Date 9,096.61 WB&Kath W B & Kath . Net to Date Libra Interest Earned Donations June Net to Date.xls 4 7/6/2007 Revenue Comparison June, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7010-00-00 Current Taxes 14,904.95 6,303,252.75 101.43 6,214,245.00 (89,007.75) 01-7020-00-00 Delinquent Taxes 4,486.76 89,257.91 55.79 160,000.00 70,742.09 01-7030-00-00 Penalty & Interest 4,505.48 65,628.68 65.63 100,000.00 34,371.32 01-7031-00-00 Attorney Fees 1,437.99 28,970.10 72.43 40,000.00 11,029.90 Subtotal: 25,335.18 6,487,109.44 99.58 6,514,245.00 27,135.56 01-7110-00-00 Municipal Sales Tax 324,128.01 3,358,410.99 79.02 4,250,000.00 891,589.01 01-7112-00-00 Sales Tax-Reduce Property Tax 81,031.99 839,602.70 78.98 1,063,000.00 223,397.30 Subtotal: 405,160.00 4,198,013.69 79.01 5,313,000.00 1,114,986.31 01-7220-00-00 Hotel-Motel Occupancy Tax 316,501.20 97.39 325,000.00 8,498.80 Subtotal: 316,501.20 97.39 325,000.00 8,498.80 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 58,333.00 261,333.00 76.86 340,000.00 78,667.00 01-7390-00-00 BinQo 45,112.34 75.19 60,000.00 14,887.66 01-7395-00-00 Municipal ROW Use Fee 175.96 20,232.50 57.81 35,000.00 14,767.50 01-7396-00-00 Solid Waste Street Use Fee 18,909.79 176,023.37 78.23 225,000.00 48,976.63 Subtotal: 77,418.75 2,391,843.80 73.36 3,260,300.00 868,456.20 01-7410-00-00 House MovinQ - 450.00 450.00 01-7411-00-00 Concrete Permits 100.00 1,025.00 74.55 1,375.00 350.00 01-7412-00-00 Building Permits 4,786.00 78,373.42 130.62 60,000.00 (18,373.42) 01-7413-00-00 Sign Permits 225.00 1,900.00 38.00 5,000.00 3,100.00 01-7414-00-00 Electrical Permits 175.00 1,065.00 133.13 800.00 (265.00) 01-7416-00-00 Gas Inspections 100.00 2,150.00 53.75 4,000.00 1 ,850.00 01-7418-00-00 Plumbing Inspections 375.00 3,375.00 75.00 4,500.00 1 ,125.00 01-7420-00-00 Electrical Licenses 100.00 543.00 30.17 1,800.00 1,257.00 Subtotal: 5,861.00 88,431.42 113.48 77,925.00 (10,506.42) 01-7510-00-00 Court Fines & Costs 22,593.26 244,978.17 76.56 320,000.00 75,021.83 01-7511-00-00 Defensive Driving Course 270.00 4,638.50 144.95 3,200.00 (1,438.50) 01-7512-00-00 Warrant Service Fees {City} 1,560.09 14,817.65 42.34 35,000.00 20,182.35 01-7513-00-00 City Traffic Fees 326.75 3,302.05 86.90 3,800.00 497.95 01-7514-00-00 Arrest Fees 1,149.45 11,904.40 82.10 14,500.00 2,595.60 June Revenues.xls 7/6/2007 Revenue Comparison June, 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 785.48 6,972.92 78.35 8,900.00 1,927.08 01-7517-00-00 State Judicial Fund due City 144.72 1,424.55 284.91 500.00 (924.55) 01-7520-00-00 Pound Fees 633.00 3,828.00 88.00 4,350.00 522.00 01-7521-00-00 Pound Incineration Fees 460.00 1,780.00 136.92 1,300.00 (480.00) Subtotal: 27,922.75 293,646.24 75.00 391,550.00 97,903.76 01-7620-00-00 Cox Field Leases-Terminal 300.00 2,700.00 75.00 3,600.00 900.00 01-7630-00-00 Cox Field Rent Hangar StoraQe 60.00 540.00 75.00 720.00 180.00 01-7631-00-00 Cox Field Rental T Hangars 5,224.00 45,391.00 82.53 55,000.00 9,609.00 01-7632-00-00 Cox Field Fuel FlowaQe Fee 580.40 5,053.45 63.17 8,000.00 2,946.55 01-7640-00-00 Leases & Rentals 6,550.30 77.98 8,400.00 1,849.70 01-7650-00-00 Interest Earned 124,712.71 351,367.84 390.41 90,000.00 (261,367.84) 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: 130,877.11 435,398.47 262.73 165,720.00 (269,678.47 01-771 3-00-00 Zoning & Subdivision Fees 1,770.66 63.24 2,800.00 1,029.34 01-771 5-00-00 Sale of Maps Copies Etc 1,380.30 7,347.63 97.97 7,500.00 152.37 01-7716-00-00 Tax Certificates 437.50 1,582.50 62.06 2,550.00 967.50 Subtotal: 1,817.80 10,700.79 83.28 12,850.00 2,149.21 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 17,576.07 - (17,576.07) Subtotal: 17,576.07 - (17,576.07) 01-8046-00-00 Sanitation Fees 109,296.51 978,746.46 73.87 1,325,000.00 346,253.54 01-8047-00-00 Brush Pickup Fee 674.50 2,765.45 36.87 7,500.00 4,734.55 Subtotal: 109,971.01 981,511.91 73.66 1,332,500.00 350,988.09 01-81 53-00-00 Lamar Co-Emergency Medical Sl 25,666.67 231,000.03 74.52 310,000.00 78,999.97 01-81 54-00-00 Emergencv Medical Service Fees 158,974.28 1,513,684.96 84.19 1,798,000.00 284,315.04 Subtotal: 184,640.95 1,744,684.99 82.77 2,108,000.00 363,315.01 01-8260-00-00 State Shared Revenue 37,507.61 93.77 40,000.00 2,492.39 Subtotal: 37,507.61 93.77 40,000.00 2,492.39 01-8308-00-00 Birth Certificate Fee for TWC 97.20 469.80 - (469.80) 01-8309-00-00 Birth Certificate Fees 1,090.80 13,008.70 89.72 14,500.00 1 ,491.30 01-8310-00-00 Death Certificate Fees 1,561.00 17,167.00 85.84 20,000.00 2,833.00 01-8311-00-00 Library Copies 239.35 1,678.25 83.91 2,000.00 321.75 June Revenues.xls 2 7/6/2007 Revenue Comparison June, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-8312 -00-00 Library Fines & Other 1,878.38 11,302.85 75.35 15,000.00 3,697.15 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 1,612.90 16.13 10,000.00 8,387.10 01-8330-00-00 Materials & Labor Sold (2,793.02) 4,734.01 43.04 11,000.00 6,265.99 01-8331-00-00 Lot Clean Up (471.52) 4,468.12 55.85 8,000.00 3,531.88 01-8332-00-00 Billed Electric (3,398.89) (3,398.89) - 3,398.89 01-8333-00-00 Refund Landfill Fee-Demolition 5,772.06 - (5,772.06) 01-8350-00-00 Miscellaneous Revenue 14,018.28 158,307.62 395.77 40,000.00 (118,307.62) 01-8365-00-00 VCC Band Contribution 10,000.00 100.00 10,000.00 01-8366-00-00 Credit Card Convenience Fee 34.80 608.66 - (608.66) 01-8368-00-00 Library Card Fees 95.00 740.00 14.80 5,000.00 4,260.00 Subtotal: 13,964.28 230,552.08 170.15 135,500.00 (95,052.08) 01-8499-00-00 Water & Sewer Transfer 125,000.00 560,000.00 74.67 750,000.00 190,000.00 Subtotal: 125,000.00 560,000.00 74.67 750,000.00 190,000.00 01-8500-00-00 Pool Vending 3,375.80 3,647.90 38.40 9,500.00 5,852.10 01-8501-00-00 Pool Programs 14,234.50 14,519.50 101.54 14,300.00 (219.50) 01-8502-00-00 Pool Daily Fees 7,491.00 7,729.80 55.21 14,000.00 6,270.20 01-8503-00-00 Sports Complex 3,310.45 22,536.72 - (22,536.72) 01-8504-00-00 Softball 14,508.10 40.87 35,500.00 20,991.90 01-8505-00-00 Reservations 310.00 2,642.50 120.11 2,200.00 (442.50) 01-8506-00-00 Sponsorships 3,700.00 - (3,700.00) 01-8507 -00-00 Special Events 5,828.50 55.51 10,500.00 4,671.50 Subtotal: 28,721.75 75,113.02 87.34 86,000.00 10,886.98 Proqram number: 1,136,840.58 17,869,940.73 87.11 20,514,390.00 2,644,449.27 Department number 1,136,840.58 17,869,940.73 87.11 20,514,390.00 2,644,449.27 Fund number: 1 General Fund 1,136,840.58 17,869,940.73 87.11 20,514,390.00 2,644,449.27 02-7111-00-00 Economic Development Sales Ta 81,031.99 839,602.70 83.96 1,000,000.00 160,397.30 Subtotal: 81,031.99 839,602.70 83.96 1,000,000.00 160,397.30 02-7650-00-00 Interest Earned 522.87 10,458.79 52.29 20,000.00 9,541.21 Subtotal: 522.87 10,458.79 52.29 20,000.00 9,541.21 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 288,000.00 75.00 384,000.00 96,000.00 Subtotal: 32,000.00 288,000.00 75.00 384,000.00 96,000.00 Program number: 113,554.86 1,138,061.49 81.06 1,404,000.00 265,938.51 Department number Revenues 113,554.86 1,138,061.49 81.06 1,404,000.00 265,938.51 June Revenues.xls 3 7/6/2007 Revenue Comparison June, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance Fund number: 2 Economic Development Fund 113,554.86 1,138,061.49 81.06 1,404,000.00 265,938.51 10-7010-00-00 Sewer Charges 378,368.61 3,506,070.48 74.20 4,725,000.00 1,218,929.52 10-7011-00-00 Industrial Surchames 11,732.55 88,874.59 63.48 140,000.00 51,125.41 10-7020-00-00 Sewer Taps 560.00 6,910.00 69.10 10,000.00 3,090.00 10-7022-00-00 Pro Rata Sewer Line Extension 2,437.89 22,777.55 flh'!i;Y;'l!;,1! 1,000.00 (21,777.55) Subtotal: 393,099.05 3,624,632.62 74.34 4,876,000.00 1,251,367.38 1 0-7130-00-00 Water Sales 612,453.58 5,258,848.37 72.74 7,230,000.00 1,971,151.63 1 0- 7140-00-00 Water Taps 19,210.00 96.05 20,000.00 790.00 10-7142-00-00 Pro Rata Water Line Extension - 2,520.00 2,520.00 Subtotal: 612,453.58 5,278,058.37 72.78 7,252,520.00 1,974,461.63 10-7650-00-00 Interest Earned 12,141.93 146,765.83 122.31 120,000.00 (26,765.83) Subtotal: 12,141.93 146,765.83 122.31 120,000.00 (26,765.83) 10-8350-00-00 Miscellaneous W&S (498.64) 94,854.36 118.57 80,000.00 (14,854.36) 10-8352-00-00 Sanitation BillinQ Fee 5,752.45 51,513.01 73.59 70,000.00 18,486.99 10-8354-00-00 Service CharQes 5,315.00 46,350.00 71.31 65,000.00 18,650.00 10-8355-00-00 Brush Pickup Fees 35.50 145.55 14.56 1,000.00 854.45 10-8356-00-00 Bulk Water Sales 552.19 4,232.49 84.65 5,000.00 767.51 10-8357 -00-00 Sewer Dumping Fees 3,682.81 35,582.12 71.16 50,000.00 14,417.88 10-8358-00-00 W &S CharQe Ofts 1,308.31 (44,554.39) 52.42 (85,000.00) (40,445.61 ) 10-8359-00-00 W &S Returned Check Fees 780.00 6,330.00 90.43 7,000.00 670.00 1 0-8360-00-00 W&S Copies 0.36 20.20 67.33 30.00 9.80 1 0-8366-00-00 Credit Card Convenience Fee 278.77 2,590.77 129.54 2,000.00 (590.77) 10-8367 -00-00 Deposits Billed 45.78 430.78 - (430.78) Subtotal: 17,252.53 197,494.89 101.26 195,030.00 (2,464.89) Program number: 1,034,947.09 9,246,951.71 74.31 12,443,550.00 3,196,598.29 Department number Revenues 1,034,947.09 9,246,951.71 74.31 12,443,550.00 3,196,598.29 Fund number: 10 Water & Sewer Fund 1,034,947.09 9,246,951.71 74.31 12,443,550.00 3,196,598.29 11-7650-00-00 Interest Earned 3,554.71 5,466.22 273.31 2,000.00 (3,466.22) Subtotal: 3,554.71 5,466.22 273.31 2,000.00 (3,466.22) Program number: 3,554.71 5,466.22 273.31 2,000.00 (3,466.22) Department number 3,554.71 5,466.22 273.31 2,000.00 (3,466.22) Fund number: 11 Capital Projects Fund 3,554.71 5,466.22 273.31 2,000.00 (3,466.22) 12-7650-00-00 Interest Earned 776.46 20,131.75 - (20,131.75) Subtotal: 776.46 20,131.75 - (20,131.75) June Revenues.xls 4 7/6/2007 Revenue Comparison June, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Program number: 776.46 20,131.75 - (20,131.75) Department number 776.46 20,131.75 - (20,131.75) Fund number: 12 WW &SS Rev Bond 2000 Const F 776.46 20,131.75 - (20,131.75) 20-7002-00-00 Municipal Court Tech Fee 984.51 10,036.83 83.64 12,000.00 1,963.17 20-7003-00-00 Court Security Fee 742.88 7,551.17 79.49 9,500.00 1,948.83 20-7004-00-00 Child Safety Fee 50.00 520.77 52.08 1,000.00 479.23 20-7005-00-00 Time Payment Fee 195.61 1,736.78 72.37 2,400.00 663.22 20-7007 -00-00 Judicial Forfeitures Fee 3,172.10 7,885.00 525.67 1,500.00 (6,385.00) Subtotal: 5,145.10 27,730.55 105.04 26,400.00 (1,330.55) 20-7650-00-00 Interest Earned 77.23 595.42 119.08 500.00 (95.42) Subtotal: 77.23 595.42 119.08 500.00 (95.42) Program number: Special Revenue 5,222.33 28,325.97 105.30 26,900.00 (1,425.97) Department number Special Revenue 5,222.33 28,325.97 105.30 26,900.00 (1,425.97) Fund number: 20 Special Revenue Fund 5,222.33 28,325.97 105.30 26,900.00 (1,425.97) 21-7650-00-00 Interest Earned 6.47 - (6.47) Subtotal: 6.47 - (6.47) Program number: Think Child Safety 6.47 - (6.47) Department number Child Safety Fund 6.47 - (6.47) Fund number: 21 Child Safety Fund 6.47 - (6.47) 22-7650-00-00 Interest Earned 151.68 467.07 - (467.07) Subtotal: 151.68 467.07 - (467.07) 22 -8151-00-00 Local Fees 1,431.00 33,807.30 70.47 47,973.00 14,165.70 22-8152-00-00 ORAS 95,327.80 86.66 109,998.00 14,670.20 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 16,738.13 96,884.68 63.93 151,558.00 54,673.32 22-8158-00-00 State of Texas-WIC 240,111.21 84.47 284,249.00 44,137.79 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 616.00 4,530.35 37.75 12,000.00 7,469.65 22-8171-00-00 ORAS Local Fees 5,800.00 33,975.00 135.90 25,000.00 (8,975.00) 22 -8172 -00-00 Immunization Grant 12,090.94 66,465.34 132.87 50,023.00 (16,442.34) 22 -81 74-00-00 Immunization Fees 587.00 11,448.00 45.79 25,000.00 13,552.00 22-8175-00-00 Prenatal Care Grant 15,170.60 75.85 20,000.00 4,829.40 22-8176-00-00 Prenatal Care Fees 120.00 1,440.88 - (1,440.88) Subtotal: 37,383.07 672,371.31 76.77 875,801.00 203,429.69 June Revenues.xls 5 7/6/2007 Revenue Comparison June, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Program number: Health Department 37,534.75 672,838.38 76.83 875,801.00 202,962.62 Department number Health Department 37,534.75 672,838.38 76.83 875,801.00 202,962.62 Fund number: 22 Health Department Fund 37,534.75 672,838.38 76.83 875,801.00 202,962.62 25-7001-00-00 Paris ISO School Officers 15,148.25 123,609.50 68.00 181,779.00 58,169.50 25-7002-00-00 No. Lamar ISO School Officers 15,116.00 123,365.42 68.01 181,392.00 58,026.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 24,117 .50 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 32,774.83 14.38 227,999.00 195,224.17 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: 54,381.75 392,053.48 25.81 1,519,212.00 1,127,158.52 25-7650-00-00 Interest Earned 1 ,207.20 - (1,207.20) Subtotal: 1,207.20 - (1,207.20) Program number: 54,381.75 393,260.68 25.89 1,519,212.00 1,125,951.32 Department number Grant Fund 54,381.75 393,260.68 25.89 1,519,212.00 1,125,951.32 Fund number: 25 Grant Fund 54,381.75 393,260.68 25.89 1,519,212.00 1,125,951.32 26-7650-00-00 Interest Earned 21.57 42.44 - (42.44) Subtotal: 21.57 42.44 - (42.44) Program number: 21.57 42.44 - (42.44 ) Department number Drua Task Force Grant 21.57 42.44 - (42.44) Fund number: 26 Criminal Justice Div Grant Fd 21.57 42.44 - (42.44) 30-7650-00-00 Use of Money Property Interest 168.28 1,445.42 - (1,445.42) Subtotal: 168.28 1,445.42 - (1,445.42) 30-7855-00-00 ORCA Owner Occupied Rehab (5,350.00) (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 9,000.00 46,500.00 - (46,500.00) Subtotal: 3,650.00 78,650.00 - (78,650.00) Program number: 3,818.28 80,095.42 - (80,095.42) Department number 3,818.28 80,095.42 - (80,095.42) Fund number: 30 Community Dvl Block Grant Func 3,818.28 80,095.42 - (80,095.42) 41-7650-00-00 Interest Earned 426.00 4,255.99 - (4,255.99) Subtotal: 426.00 4,255.99 - (4,255.99) June Revenues.xls 6 7/6/2007 Revenue Comparison June, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budqet Balance 41-8303-00-00 Streetscape TxDot Reimburse (11,795.88) - 11 ,795.88 Subtotal: (11,795.88) - 11,795.88 Program number: 426.00 (7,539.89) - 7,539.89 Department number 426.00 (7,539.89) - 7,539.89 Fund number: 41 Tax & Rev CO 2000 Const Fund 426.00 (7,539.89) - 7,539.89 42-7650-00-00 Interest Earned 5.34 83.62 - (83.62) Subtotal: 5.34 83.62 - (83.62) Program number: 5.34 83.62 - (83.62) Department number 5.34 83.62 - (83.62) Fund number: 42 CO Series 2002 Construction Fd 5.34 83.62 - (83.62) 50-1135-00-00 Transfer to GO Refundinq 2003 35,000.00 405,000.00 - (405,000.00) Subtotal: 35,000.00 405,000.00 - (405,000.00) 50-7650-00-00 Use of Money Property Interest 6,717.57 60,380.89 - (60,380.89) Subtotal: 6,717.57 60,380.89 - (60,380.89) Program number: 41,717.57 465,380.89 - (465,380.89) Department number 41,717.57 465,380.89 - (465,380.89) Fund number: 50 Revenue Bonds Sinking Funds 41,717.57 465,380.89 - (465,380.89) 55-7043-00-00 Tax & Rev COs 2000 I&S 1,505.55 493,495.23 96.74 510,145.00 16,649.77 Subtotal: 1,505.55 493,495.23 96.74 510,145.00 16,649.77 55-7650-00-00 Interest Earned 239.18 1,229.11 - (1,229.11) Subtotal: 239.18 1,229.11 - (1,229.11 ) Program number: 1,744.73 494,724.34 96.98 510,145.00 15,420.66 Department number 1,744.73 494,724.34 96.98 510,145.00 15,420.66 Fund number: 55 Tax & Rev CO 2000 I&S Fund 1,744.73 494,724.34 96.98 510,145.00 15,420.66 56-7044-00-00 Tax & Rev COs 2002 I&S 1,295.91 420,904.00 95.86 439,075.00 18,171.00 Subtotal: 1,295.91 420,904.00 95.86 439,075.00 18,171.00 Program number: 1,295.91 420,904.00 95.86 439,075.00 18,171.00 Department number Tax & Revenue 2002 1,295.91 420,904.00 95.86 439,075.00 18,171.00 Fund number: 56 Tax & Rev CO 2002 I&S Fund 1,295.91 420,904.00 95.86 439,075.00 18,171.00 58-7045-00-00 Cert. Of Oblig. 2003 I&S 1,161.55 377,269.04 95.81 393,785.00 16,515.96 Subtotal: 1,161.55 377,269.04 95.81 393,785.00 16,515.96 58-7650-00-00 Interest Earned 2,091.01 11,935.25 - (11,935.25) Subtotal: 2,091.01 11,935.25 - (11,935.25) Program number: 3,252.56 389,204.29 98.84 393,785.00 4,580.71 June Revenues.xls 7 7/6/2007 Revenue Comparison June, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Department number NON-departmental 3,252.56 389,204.29 98.84 393,785.00 4,580.71 Fund number: 58 2003 GO RefundinQ Bonds 3,252.56 389,204.29 98.84 393,785.00 4,580.71 71-8350-00-00 City Deposits 18,299.68 18,299.68 - (18,299.68) Subtotal: 18,299.68 18,299.68 - ( 18,299.68) Program number: 18,299.68 18,299.68 - (18,299.68) Department number 18,299.68 18,299.68 - (18,299.68) Fund number: 71 Insurance Claims Fund 18,299.68 18,299.68 - ( 18,299.68) 72-7650-00-00 Interest Earned 263.17 2,191.18 - (2,191.18) Subtotal: 263.17 2,191.18 - (2,191.18) 72-8313-00-00 Memorial Donations 250.00 3,720.76 - (3,720.76) Subtotal: 250.00 3,720.76 - (3,720.76) Program number: 513.17 5,911.94 - (5,911.94) Department number 513.17 5,911.94 - (5,911.94 ) Fund number: 72 Library Memorial Fund 513.17 5,911.94 - (5,911.94) 79-7650-00-00 Interest 178.77 2,613.98 - (2,613.98) 79-7651-00-00 Donation 250.00 - (250.00) Subtotal: 178.77 2,863.98 - (2,863.98) ProQram number: 178.77 2,863.98 - (2,863.98) Department number 178.77 2,863.98 - (2,863.98) Fund number: 79 Library Expendable Fund 178.77 2,863.98 - (2,863.98) 80-7650-00-00 Interest 1.23 1,483.74 - (1,483.74 ) Subtotal: 1.23 1,483.74 - (1,483.74) Program number: 1.23 1,483.74 - (1,483.74) Department number 1.23 1,483.74 - (1,483.74) Fund number: 80 Library Permanent Fund 1.23 1,483.74 - (1,483.74) June Revenues.xls 8 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7010-00-00 Current Taxes 20,837.47 5,930,582.36 1 00.46 5,903,225.00 (27,357.36) 01-7020-00-00 Delinauent Taxes 6,052.94 67,204.11 44.80 150,000.00 82,795.89 01-7030-00-00 Penaltv & Interest 6,338.62 67,976.03 67.98 100,000.00 32,023.97 01-7031-00-00 Attornev Fees 1,758.35 20,548.12 51.37 40,000.00 19,451.88 01-7043-00-00 Tax & Rev CO 2000 I&S (2,162.02) 507,823.52 - (507,823.52) 01-7044-00-00 Tax & Rev CO 2002 I&S 4,223.34 436,062.20 - (436,062.20) 01-7045-00-00 Cert of Obliq 2003 I&S 3,711.42 383,206.17 - (383,206.17) Subtotal: 40,760.12 7,413,402.51 119.70 6,193,225.00 (1,220,177.51) 01-7110-00-00 Municipal Sales Tax 348,036.44 3,176,585.94 81.87 3,880,000.00 703,414.06 01-7112-00-00 Sales Tax-Reduce Property Tax 87,009.11 794,146.48 81.87 970,000.00 175,853.52 Subtotal: 435,045.55 3,970,732.42 81.87 4,850,000.00 879,267.58 01-7220-00-00 Hotel-Motel Occupancy Tax 268,941.81 89.65 300,000.00 31,058.19 Subtotal: 268,941.81 89.65 300,000.00 31,058.19 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 39,515.10 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 18.63 22,942.66 54.63 42,000.00 19,057.34 01-7396-00-00 Solid Waste Street Use Fee 22,409.69 193,276.26 87.85 220,000.00 26,723.74 Subtotal: 61,943.42 2,817,229.48 95.85 2,939,300.00 122,070.52 01-7410-00-00 House Moving 300.00 60.00 500.00 200.00 01- 7 411-00-00 Concrete Permits 200.00 1,000.00 72.73 1,375.00 375.00 01-7412-00-00 Buildinq Permits 11,363.00 54,465.00 99.03 55,000.00 535.00 01-7413-00-00 Sign Permits 450.00 5,225.00 130.63 4,000.00 (1,225.00) 01-7414-00-00 Electrical Permits 125.00 675.00 61.36 1,100.00 425.00 01-7416-00-00 Gas Inspections 300.00 3,122.50 86.02 3,630.00 507.50 01-7418-00-00 Plumbing Inspections 400.00 3,475.00 89.10 3,900.00 425.00 01-7420-00-00 Electrical Licenses 155.00 1,355.00 40.27 3,365.00 2,010.00 Subtotal: 12,993.00 69,617.50 95.54 72,870.00 3,252.50 01-7510-00-00 Court Fines & Costs 21,464.94 209,918.05 60.85 345,000.00 135,081.95 01-7511-00-00 Defensive Driving Course 160.00 2,260.00 53.30 4,240.00 1 ,980.00 June Revenues.xls 10 7/6/2007 Revenue Comparison June, 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} 1,339.13 25,955.56 74.16 35,000.00 9,044.44 01-7513-00-00 City Traffic Fees 221.30 2,723.27 57.57 4,730.00 2,006.73 01-7514-00-00 Arrest Fees 945.63 10,513.61 64.60 16,275.00 5,761.39 01-7516-00-00 Time Payment Fees Retained 654.34 6,547.35 54.56 12,000.00 5,452.65 01-7517 -00-00 State Judicial Fund due City 95.86 680.01 - (680.01 ) 01- 7 520-00-00 Pound Fees 365.00 3,240.00 54.45 5,950.00 2,710.00 01-7521-00-00 Pound Incineration Fees 900.00 29.03 3,100.00 2,200.00 Subtotal: 25,246.20 262,737.85 61.63 426,295.00 163,557.15 01-7610-00-00 Cox Field Leases-Land - 240.00 240.00 01-7620-00-00 Cox Field Leases-Terminal 300.00 2,700.00 75.00 3,600.00 900.00 01-7630-00-00 Cox Field Rent Hangar Storaoe 60.00 540.00 75.00 720.00 180.00 01-7631-00-00 Cox Field Rental T Hangars 6,136.09 44,997.31 81.81 55,000.00 10,002.69 01-7632-00-00 Cox Field Fuel Flowaoe Fee 713.05 6,113.00 67.92 9,000.00 2,887.00 01-7640-00-00 Leases & Rentals 100.00 9,510.30 113.22 8,400.00 (1,110.30) 01-7650-00-00 Interest Earned 41,083.35 185,663.25 309.44 60,000.00 (125,663.25) 01-7684-00-00 Great Grant 13,047.24 - (13,047.24) 01-7686-00-00 Cops In Schools-PISD & NLlSD (60,520.00) - Subtotal: (12,127.51) 262,571.10 191.71 136,960.00 (125,611.10) 01-7713-00-00 Zoning & Subdivision Fees 2,000.00 71.43 2,800.00 800.00 01-7715-00-00 Sale of Maps Copies Etc 516.36 7,075.37 117.92 6,000.00 (1,075.37) 01-7716-00-00 Tax Certificates 347.50 2,057.50 80.69 2,550.00 492.50 Subtotal: 863.86 11,132.87 98.09 11,350.00 217.13 01-7822-00-00 Lamar County Fire Contract 150.00 1,200.00 66.67 1,800.00 600.00 Subtotal: 150.00 1,200.00 66.67 1,800.00 600.00 01-7937-00-00 Streetscape- TXDOT Grant 198,842.13 210,638.01 - (210,638.01 ) 01-7941-00-00 Tx Hist Comm Grant & Donatiom - 12,500.00 12,500.00 Subtotal: 198,842.13 210,638.01 ;Y IlU I;::;:; i; 12,500.00 (198,138.01) 01-8046-00-00 Sanitation Fees 109,375.38 984,252.26 74.28 1,325,000.00 340,747.74 01-8047-00-00 Brush Pickup Fee 1,026.00 4,683.50 52.04 9,000.00 4,316.50 Subtotal: 110,401.38 988,935.76 74.13 1,334,000.00 345,064.24 01-8153-00-00 Lamar Co-Emergency Medical SE 24,667.00 253,959.29 85.80 296,000.00 42,040.71 01-81 54-00-00 Emergency Medical Service Fee~ 146,515.37 1,456,393.14 86.32 1,687,200.00 230,806.86 Subtotal: 171,182.37 1,710,352.43 86.24 1,983,200.00 272,847.57 01-8260-00-00 State Shared Revenue 33,736.67 93.71 36,000.00 2,263.33 June Revenues.xls 11 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Subtotal: 33,736.67 93.71 36,000.00 2,263.33 01-8308-00-00 Birth Certificate Fee for TWC 181.80 547.20 - (547.20 01-8309-00-00 Birth Certificate Fees 2,063.20 12,825.20 144.10 8,900.00 (3,925.20) 01-831 0-00-00 Death Certificate Fees 2,316.00 18,454.00 109.52 16,850.00 (1,604.00) 01-8311-00-00 Library Copies 153.15 1,584.82 59.81 2,650.00 1,065.18 01-8312 -00-00 Library Fines & Other 1,351.15 11,079.23 43.45 25,500.00 14,420.77 01-8325-00-00 Sale of City Property - 10,000.00 10,000.00 01-8330-00-00 Materials & Labor Sold 522.00 7,655.82 69.60 11,000.00 3,344.18 01-8331-00-00 Lot Clean Up 7,919.36 158.39 5,000.00 (2,919.36) 01-8332-00-00 Billed Electric (1,872.73) (20,569.49) (82.28) 25,000.00 45,569.49 01-8333-00-00 Refund Landfill Fee-Demolition 2,247.48 24,970.88 - (24,970.88) 01-8350-00-00 Miscellaneous Revenue (783.10) 143,420.19 358.55 40,000.00 (103,420.19 01-8354-00-00 EMS Golf Cart Donations 200.00 200.00 - (200.00) 01-8359-00-00 Special Proiects 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 13.50 475.28 - (475.28) 01-8368-00-00 Library Card Fees 1,350.60 12,116.30 80.78 15,000.00 2,883.70 Subtotal: 7,743.05 220,683.79 129.89 169,900.00 (50,783.79) 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 3,225.95 3,603.75 37.93 9,500.00 5,896.25 01-8501-00-00 Pool Programs 6,048.00 10,134.00 70.87 14,300.00 4,166.00 01-8502-00-00 Pool Daily Fees 6,509.00 6,935.00 49.54 14,000.00 7,065.00 01-8503-00-00 Sports Complex 2,971.89 27,289.47 88.03 31,000.00 3,710.53 01-8504-00-00 Softball 13,960.00 39.32 35,500.00 21,540.00 01-8505-00-00 Reservations 355.00 3,425.00 155.68 2,200.00 (1,225.00) 01-8507 -00-00 Special Events 13.75 9,676.50 92.16 10,500.00 823.50 Subtotal: 19,123.59 75,023.72 64.12 117,000.00 41 ,976.28 Program number: 1,072,167.16 18,316,935.92 94.74 19,334,400.00 1,017,464.08 Department number 1,072,167.16 18,316,935.92 94.74 19,334,400.00 1,017,464.08 Fund number: 1 General Fund 1,072,167.16 18,316,935.92 94.74 19,334,400.00 1,017,464.08 02-7111-00-00 Economic Development Sales Ta 87,009.11 794,146.48 81.87 970,000.00 175,853.52 Subtotal: 87,009.11 794,146.48 81.87 970,000.00 175,853.52 02-7650-00-00 Interest Earned 534.76 17,550.20 351.00 5,000.00 (12,550.20) June Revenues.xls 12 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budqet Balance Subtotal: 534.76 17,550.20 351.00 5,000.00 (12,550.20) 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 288,000.00 75.00 384,000.00 96,000.00 Subtotal: 32,000.00 288,000.00 75.00 384,000.00 96,000.00 Program number: 119,543.87 1,099,696.68 80.92 1,359,000.00 259,303.32 Department number Revenues 119,543.87 1,099,696.68 80.92 1,359,000.00 259,303.32 Fund number: 2 Economic Development Fund 119,543.87 1,099,696.68 80.92 1,359,000.00 259,303.32 10-7010-00-00 Sewer Charqes 421,724.47 3,578,176.22 77.79 4,600,000.00 1,021,823.78 10-7011-00-00 Industrial Surcharges 12,198.04 94,919.43 63.28 150,000.00 55,080.57 10-7020-00-00 Sewer Taps 350.00 6,195.00 44.25 14,000.00 7,805.00 10-7022-00-00 Pro Rata Sewer Line Extension 2,354.83 25,011.87 If !/!/;!;~I I! ;1 1,000.00 (24,011.87) Subtotal: 436,627.34 3,704,302.52 77.74 4,765,000.00 1,060,697.48 1 0- 7130-00-00 Water Sales 596,864.52 5,225,172.79 77.99 6,700,000.00 1,474,827.21 1 0-7140-00-00 Water Taps 1,050.00 10,535.00 52.68 20,000.00 9,465.00 10-7142-00-00 Pro Rata Water Line Extension 205.88 8.17 2,520.00 2,314.12 Subtotal: 597,914.52 5,235,913.67 77.89 6,722,520.00 1,486,606.33 10-7650-00-00 Interest Earned 27,927.39 94,602.14 75.68 125,000.00 30,397.86 Subtotal: 27,927.39 94,602.14 75.68 125,000.00 30,397.86 10-8350-00-00 Miscellaneous W&S 11,184.42 72,408.95 103.44 70,000.00 (2,408.95) 10-8352-00-00 Sanitation Billing Fee 5,756.60 51,802.78 74.00 70,000.00 18,197.22 10-8354-00-00 Service Charges 5,045.00 45,620.30 70.19 65,000.00 19,379.70 1 0-8355-00-00 Brush Pickup Fees 54.00 246.50 4.93 5,000.00 4,753.50 10-8356-00-00 Bulk Water Sales 280.69 2,877 .59 28.78 10,000.00 7,122.41 10-8357 -00-00 Sewer Dumping Fees 4,559.31 38,302.32 109.44 35,000.00 (3,302.32) 10-8358-00-00 W &S Charge Ofts 154.13 (65,954.67) 77.59 (85,000.00) (19,045.33) 10-8359-00-00 W &S Returned Check Fees 1,080.00 6,735.00 96.21 7,000.00 265.00 1 0-8360-00-00 W &S Copies 1.92 51.58 171.93 30.00 (21.58) 1 0-8366-00-00 Credit Card Convenience Fee 246.29 2,343.32 180.26 1,300.00 (1,043.32) 10-8367 -00-00 Deposits Billed 42.84 275.00 - (275.00) 1 0-8368-00-00 Bulk Pickup Fees 140.00 180.00 - (180.00) Subtotal: 28,545.20 154,888.67 86.86 178,330.00 23,441.33 Program number: 1,091,014.45 9,189,707.00 77.94 11,790,850.00 2,601,143.00 Department number Revenues 1,091,014.45 9,189,707.00 77.94 11,790,850.00 2,601,143.00 Fund number: 10 Water & Sewer Fund 1,091,014.45 9,189,707.00 77.94 11,790,850.00 2,601,143.00 11-7650-00-00 Interest Earned 220.63 1,373.14 - (1,373.14) June Revenues.xls 13 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Subtotal: 220.63 1,373.14 - (1,373.14) Program number: 220.63 1,373.14 - (1,373.14) Department number 220.63 1,373.14 - (1,373.14) Fund number: 11 Capital Proiects Fund 220.63 1,373.14 - (1,373.14) 12-7650-00-00 Interest Earned 5,770.30 36,115.10 - (36,115.10) Subtotal: 5,770.30 36,115.10 - (36,115.10) Program number: 5,770.30 36,115.10 - (36,115.10) Department number 5,770.30 36,115.10 - (36,115.10) Fund number: 12 WW &SS Rev Bond 2000 Const F 5,770.30 36,115.10 - (36,115.10) 20-7002-00-00 Municipal Court Tech Fee 708.84 8,687.88 66.83 13,000.00 4,312.12 20-7003-00-00 Court Security Fee 595.09 6,674.02 66.74 10,000.00 3,325.98 20-7004-00-00 Child Safety Fee 71.18 693.95 69.40 1,000.00 306.05 20-7005-00-00 Time Payment Fee 251.65 1,761.43 69.08 2,550.00 788.57 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,626.76 20,072.77 63.62 31,550.00 11,477.23 20-7650-00-00 Interest Earned 77.15 867.99 - (867.99) Subtotal: 77.15 867.99 - (867.99) Program number: 1,703.91 20,940.76 66.37 31,550.00 10,609.24 Department number 1,703.91 20,940.76 66.37 31,550.00 10,609.24 Fund number: 20 Special Revenue Fund 1,703.91 20,940.76 66.37 31,550.00 10,609.24 21-7650-00-00 Interest Earned 30.20 191.82 - (191.82) Subtotal: 30.20 191.82 - (191.82) Program number: 30.20 191.82 - (191.82) Department number 30.20 191.82 - (191.82) Fund number: 21 Child Safety Fund 30.20 191.82 - (191.82) 22 -8151-00-00 Local Fees 2,735.00 15,749.00 18.45 85,349.00 69,600.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 36,108.16 141,222.99 64.78 218,000.00 76,777.01 22-8158-00-00 State of Texas-WIC 19,745.84 229,938.84 106.12 216,685.00 (13,253.84) 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 547.00 8,185.50 272.85 3,000.00 (5,185.50) 22 -8171-00-00 ORAS Local Fees 5,725.00 43,575.00 174.30 25,000.00 (18,575.00) June Revenues.xls 14 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Descrif)tion Collected Collected Collected Budqet Balance 22-8172-00-00 Immunization Grant 11,881.58 16,721.35 33.44 50,000.00 33,278.65 22-8174-00-00 Immunization Fees 1,340.00 24,712.50 123.56 20,000.00 (4,712.50) 22-8175-00-00 Prenatal Care Grant 20.00 245.50 1.23 20,000.00 19,754.50 22-8176-00-00 Prenatal Care Fees 310.00 1,474.00 - (1,474.00) 22-8177 -00-00 Familv Planning Grant 70.00 0.65 10,781.00 10,711.00 22-8178-00-00 Familv Planning Fees 60.00 - (60.00) Subtotal: 78,412.58 734,119.44 75.78 968,815.00 234,695.56 Program number: 78,412.58 734,119.44 75.78 968,815.00 234,695.56 Department number 78,412.58 734,119.44 75.78 968,815.00 234,695.56 Fund number: 22 Health Department Fund 78,412.58 734,119.44 75.78 968,815.00 234,695.56 25-7001-00-00 Paris ISD School Officers 46.17 152,650.83 101.11 150,973.00 (1,677.83) 25-7002-00-00 No. Lamar ISD School Officers 85,877.16 174,627.22 116.09 150,425.00 (24,202.22) 25-7003-00-00 Violent Crimes Against 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 Ganq Resistance Ed.& Traininq 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: 85,923.33 467,658.86 76.94 607,855.00 140,196.14 Program number: 85,923.33 467,658.86 76.94 607,855.00 140,196.14 Department number Grant Fund 85,923.33 467,658.86 76.94 607,855.00 140,196.14 Fund number: 25 Grant Fund 85,923.33 467,658.86 76.94 607,855.00 140,196.14 26-7651-00-00 Program 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 348,669.53 553,997.10 - (553,997.10) Subtotal: 348,669.53 598,962.10 - (598,962.10) Program number: 348,669.53 737,075.80 - (737,075.80) Department number Drug Task Force Grant 348,669.53 737,075.80 - (737,075.80) Fund number: 26 Criminal Justice Div Grant Fd 348,669.53 737,075.80 - (737,075.80) 30-7650-00-00 Use of Monev Property Interest 241 .80 1,803.63 - (1,803.63) Subtotal: 241.80 1,803.63 - (1,803.63) 30-7855-00-00 ORCA Owner Occupied Rehab - 5,980.00 5,980.00 June Revenues.xls 15 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 30-7856-00-00 Owner Occupied Rehab 22,500.00 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 Eastaate 7,500.00 7,500.00 - (7,500.00) Subtotal: 30,000.00 30,000.00 8.50 352,980.00 322,980.00 ProQram number: 30,241 .80 31,803.63 9.01 352,980.00 321,176.37 Department number 30,241.80 31,803.63 9.01 352,980.00 321,176.37 Fund number: 30 Community Dvl Block Grant Fund 30,241 .80 31,803.63 9.01 352,980.00 321,176.37 41-7650-00-00 Interest Earned 356.03 11,062.59 - (11,062.59) Subtotal: 356.03 11,062.59 - (11,062.59) Program number: 356.03 11,062.59 - (11,062.59) Department number 356.03 11,062.59 - (11,062.59) Fund number: 41 Tax & Rev CO 2000 Const Fund 356.03 11,062.59 - (11,062.59) 42-7650-00-00 Interest Earned 232.69 25,887.28 - (25,887.28) 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: 232.69 98,979.44 - (98,979.44 ) Program number: 232.69 98,979.44 - (98,979.44 ) Department number 232.69 98,979.44 - (98,979.44) Fund number: 42 CO Series 2002 Construction Fd 232.69 98,979.44 - (98,979.44 ) 50-7650-00-00 Use of Money Property Interest 21 ,162.74 51,464.20 - (51,464.20) Subtotal: 21,162.74 51,464.20 - (51,464.20) Program number: 21,162.74 51,464.20 - (51,464.20) Department number 21,162.74 51,464.20 - (51,464.20) Fund number: 50 Revenue Bonds Sinking Funds 21,162.74 51,464.20 - (51,464.20) 55-7043-00-00 Tax & Rev COs 2000 I&S - 510,498.76 510,498.76 Subtotal: - 510,498.76 510,498.76 55-7650-00-00 Interest Earned 246.74 1,113.46 - (1,113.46) Subtotal: 246.74 1,113.46 - (1,113.46) Program number: 246.74 1,113.46 0.22 510,498.76 509,385.30 Department number 246.74 1,113.46 0.22 510,498.76 509,385.30 Fund number: 55 Tax & Rev CO 2000 I&S Fund 246.74 1,113.46 0.22 510,498.76 509,385.30 56-7044-00-00 Tax & Rev COs 2002 I&S - 437,672.50 437,672.50 Subtotal: - 437,672.50 437,672.50 June Revenues.xls 16 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Program number: - 437,672.50 437,672.50 Department number - 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 Oblio. 2003 I&S - 391,625.00 391,625.00 Subtotal: - 391,625.00 391,625.00 58-7650-00-00 Interest Earned 1,876.32 7,435.83 - (7,435.83) Subtotal: 1,876.32 7,435.83 - (7,435.83) Program number: 1,876.32 7,435.83 1.90 391,625.00 384,189.17 Department number 1,876.32 7,435.83 1.90 391,625.00 384,189.17 Fund number: 58 2003 GO Refunding Bonds 1,876.32 7,435.83 1.90 391,625.00 384,189.17 70-8350-00-00 Claim Payment Refunds 747.62 1,093,698.93 - (1,093,698.93) Subtotal: 747.62 1,093,698.93 - (1,093,698.93) Program number: 747.62 1,093,698.93 - (1,093,698.93) Department number 747.62 1,093,698.93 - (1,093,698.93) Fund number: 70 Employees Insurance Fund 747.62 1,093,698.93 - (1,093,698.93) 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 191.68 1,179.29 - (1,179.29) Subtotal: 191.68 1,179.29 - (1,179.29) 72 -8313-00-00 Memorial Donations 5,790.00 9,464.95 - (9,464.95) Subtotal: 5,790.00 9,464.95 - (9,464.95) Program number: 5,981.68 10,644.24 - (10,644.24 ) Department number 5,981.68 10,644.24 - (10,644.24) Fund number: 72 Library Memorial Fund 5,981.68 10,644.24 - (10,644.24) 77 -7650-00-00 Interest 9,096.61 - (9,096.61 ) Subtotal: 9,096.61 - (9,096.61 ) Program number: 9,096.61 - (9,096.61 ) Department number 9,096.61 - (9,096.61 ) Fund number: 77 W B & Kathrvn Vauohan Memori, 9,096.61 - (9,096.61 ) 79-7650-00-00 Interest 302.48 1,833.64 - (1,833.64 ) 79-7651-00-00 Donation 6,090.20 - (6,090.20) June Revenues.xls 17 7/6/2007 Revenue Comparison June, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance Subtotal: 302.48 7,923.84 - (7,923.84) ProQram number: 302.48 7,923.84 - (7,923.84 ) Department number 302.48 7,923.84 - (7,923.84) Fund number: 79 Library Expendable Fund 302.48 7,923.84 - (7,923.84) 80-7650-00-00 Interest 297.08 1,848.96 - (1,848.96) Subtotal: 297.08 1,848.96 - (1,848.96) Program number: 297.08 1,848.96 - (1,848.96) Department number 297.08 1,848.96 - (1,848.96) Fund number: 80 Librarv Permanent Fund 297.08 1,848.96 - (1,848.96) June Revenues.xls 18 7/6/2007 Departmental Expenditure Summary Comparison June, 2007 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Budget Actual Balance 01 City Council 91.78 10,670.74 92,950.00 85,310.90 7,639.10 01 City Manager 77.91 10,569.27 155,064.00 120,803.53 34,260.47 01 City Attorney 66.78 25,091.32 369,581.00 246,791.81 122,789.19 01 Municipal Court 75.93 19,148.64 204,684.00 155,417.87 49,266.13 01 City Clerk 68.40 8,144.87 117,919.00 80,657.49 37,261.51 01 Accounting & Auditing 77.62 36,460.17 429,069.00 333,057.17 96,011.83 01 Police 67.44 343,764.40 5,229,669.00 3,526,927.08 1,702,741.92 01 Fire 64.64 237,945.12 3,506,050.00 2,266,121.81 1,239,928.19 01 Community Development 55.49 37,451.54 652,017.00 361,798.93 290,218.07 01 Engineering 65.48 9,990.57 453,399.00 296,867.69 156,531.31 01 Public Works 73.39 9,714.45 136,547.00 100,213.64 36,333.36 01 Parks,Recreation,& ROW 71.36 119,921.78 1,123,930.00 802,009.18 321,920.82 01 Sanitation 60.53 56,287.46 1,204,999.00 729,361.82 475,637.18 01 Streets & Highways 52.58 68,812.72 1,969,233.00 1,035,463.95 933,769.05 01 Traffic & Public Lighting 68.01 65,855.18 505,409.00 343,713.14 161,695.86 01 Garage 67.83 19,466.71 278,130.00 188,660.44 89,469.56 01 Emergency Medical Service 73.14 152,483.07 2,124,118.00 1,553,611.72 570,506.28 01 Cox Field Airport 32.61 12,305.23 254,592.00 83,013.04 171,578.96 01 Paris Band 2.10 20,850.00 437.47 20,412.53 01 Library 62.05 39,306.81 630,511.00 391,244.99 239,266.01 01 General Expenses 84.41 17,748.62 744,146.00 628,111.70 116,034.30 01 Debt - 01 Contingency 6.66 302,705.00 20,151.76 282,553.24 General Fund 65.10 1,301,138.67 20,505,572.00 13,349,747.13 7,155,824.87 02 PEDC 12.80 29,385.64 1,570,862.00 201,082.56 1,369,779.44 02 Debt 52.73 37,178.13 833,138.00 439,321.30 393,816.70 Economic Development Fund 26.64 66,563.77 2,404,000.00 640,403.86 1,763,596.14 10 Warehouse 71.25 7,458.37 103,642.00 73,844.65 29,797.35 10 W & S Billing and Collecting 74.34 229,406.30 1,582,316.00 1,176,283.42 406,032.58 10 Water Production 60.86 192,539.37 2,568,133.00 1,562,872.95 1,005,260.05 10 Water Distribution 69.05 105,210.49 1,277,370.00 881,998.67 395,371.33 10 Sewer Maintenance 70.39 27,822.66 618,733.00 435,502.21 183,230.79 10 Waste Water Treatment 74.23 184,629.55 1,907,130.00 1,415,712.26 491,417.74 10 Lift Stations 57.67 28,008.08 428,965.00 247,384.56 181,580.44 10 Debt - 3,956,855.00 3,956,855.00 Contingency - Water & Sewer Fund 46.56 775,074.82 12,443,144.00 5,793,598.72 6,649,545.28 11 Police - 119,908.76 151,946.92 (151,946.92) Capital Projects Fund - 119,908.76 151,946.92 (151,946.92) 12 Streets - 17,620.20 (17,620.20) WW &SS Rev Bond 2000 Con - 17,620.20 (17,620.20) 20 Municipal Court 11.77 2,932.70 127,987.00 15,064.50 112,922.50 20 Police Department 71.85 4,500.00 3,233.35 1,266.65 Special Revenue Fund 13.81 2,932.70 132,487.00 18,297.85 114,189.15 21 Emergency Medical Service - 696.50 (696.50) Child Safety Fund - 696.50 (696.50) 22 Health Department 67.86 59,198.67 875,801.00 594,276.89 281,524.11 Health Department Fund 67.86 59,198.67 875,801.00 594,276.89 281,524.11 25 Police 48.81 51,592.29 896,989.00 437,841.57 459,147.43 June Department Expenditures.xls 1 7/6/2007 Departmental Expenditure Summary Comparison June, 2007 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Budget Actual Balance 25 Airport - 622,223.00 622,223.00 Grant Fund 28.82 51,592.29 1,519,212.00 437,841.57 1,081,370.43 26 Police - 130,224.00 130,224.00 Criminal Justice Div Grant Fd - 130,224.00 130,224.00 30 Community Development - 16,200.00 16,200.00) Community Dvl Block Grant F - 16,200.00 16,200.00) 41 City Council - 432.90 47,756.91 47,756.91 ) 41 Street Department - (3,956.00) 3,956.00 Tax & Rev CO 2000 Const FL - 432.90 43,800.91 43,800.91 ) 42 Police Department - 8,246.48 (8,246.48) CO Series 2002 Construction - 8,246.48 (8,246.48) 50 Debt Service 109.87 1,301,475.66 3,956,855.00 4,347,245.82 (390,390.82) Revenue Bonds Sinking Fund 109.87 1,301,475.66 3,956,855.00 4,347,245.82 (390,390.82) 55 Debt Service 100.00 134,105.63 510,145.00 510,142.51 2.49 Tax & Rev CO 2000 I&S Fun( 100.00 134,105.63 510,145.00 510,142.51 2.49 56 Debt Service 99.91 106,836.25 439,075.00 438,661.00 414.00 Tax & Rev CO 2002 I&S Func 99.91 106,836.25 439,075.00 438,661.00 414.00 58 Debt Service - 393,785.00 393,785.00 2003 GO Refunding Bonds - 393,785.00 393,785.00 72 Library - 43.07 586.51 (586.51 ) Library Memorial Fund - 43.07 586.51 (586.51 ) 79 Librarv - 4,538.00 (4,538.00) Library Expendable Fund - 4,538.00 (4,538.00) June Department Expenditures.xls 2 7/6/2007 Departmental Expenditure Summary Comparison June, 2006 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Budget Actual Balance 01 City Council 86.49 4,951.68 488,150.00 422,217.48 65,932.52 01 City ManaQer 70.39 11,766.47 156,047.00 109,841.36 46,205.64 01 City Attorney 57.96 13,358.17 367,644.00 213,096.93 154,547.07 01 Municipal Court 75.19 16,253.72 194,459.00 146,216.11 48,242.89 01 City Clerk 71.35 8,809.46 116,619.00 83,205.55 33,413.45 01 AccountinQ & AuditinQ 70.03 31,140.64 566,384.00 396,621.66 169,762.34 01 Police 68.23 353,480.65 4,938,182.00 3,369,232.99 1,568,949.01 01 Fire 70.59 226,297.92 3,185,514.00 2,248,527.03 936,986.97 01 Community Develooment 69.13 56,696.50 607,597.00 420,032.83 187,564.17 01 EngineerinQ 70.73 31,735.31 438,901.00 310,431.89 128,469.11 01 Public Works 74.90 (8,048.18) 127,374.00 95,398.37 31,975.63 01 Parks,Recreation,& ROW 71.19 147,323.25 1,044,122.00 743,341.26 300,780.74 01 Sanitation 62.28 112,432.75 1,392,436.00 867,270.65 525,165.35 01 Streets & HiQhways 69.13 188,122.54 1,419,075.00 981,032.35 438,042.65 01 Traffic & Public LiQhtinQ 84.07 77,135.30 424,170.00 356,600.10 67,569.90 01 GaraQe 69.07 16,575.27 228,4 73.00 157,812.95 70,660.05 01 Emergency Medical Service 75.47 229,168.24 1,957,083.00 1,477,041.39 480,041.61 01 Cox Field Airport 47.93 16,734.64 239,858.00 114,969.82 124,888.18 01 Paris Band 0.17 20,850.00 34.45 20,815.55 01 Library 72.96 54,915.77 601,777.00 439,058.63 162,718.37 ContinQency - 280,982.00 280,982.00 General Fund 68.91 1,588,850.10 18,795,697.00 12,951,983.80 5,843,713.20 02 PEDC 19.67 950,983.00 187,072.60 763,910.40 Debt 53.50 37,178.13 833,138.00 445,715.05 387,422.95 Economic Development Fund 35.47 37,178.13 1,784,121.00 632,787.65 1,151,333.35 10 Warehouse 74.88 8,574.45 95,663.00 71,630.41 24,032.59 10 W & S BillinQ and CollectinQ 27.08 41,293.77 1,576,259.00 426,831.77 1,149,427.23 10 Water Production 79.34 238,841.71 2,063,489.00 1,637,223.62 426,265.38 10 Water Distribution 71.15 127,726.20 1,089,971.00 775,482.19 314,488.81 10 Sewer Maintenance 61.63 29,729.69 593,733.00 365,903.18 227,829.82 10 Waste Water Treatment 71.24 221,630.69 1,931,722.00 1,376,179.56 555,542.44 10 Lift Stations 58.79 33,945.89 368,004.00 216,350.54 151,653.46 Debt - 3,960,758.77 3,960,758.77 Water & Sewer Fund 41.69 701,742.40 11,679,599.77 4,869,601.27 6,809,998.50 12 Sewer Maintenance - 5,000.00 (5,000.00) WW &SS Rev Bond 2000 Cor - 5,000.00 (5,000.00) 20 Municipal Court 36.71 1,556.73 225,867.00 82,915.91 142,951.09 20 Police Department 67.18 18,600.00 12,496.00 6,104.00 Special Revenue Fund 39.03 1,556.73 244,467.00 95,411.91 149,055.09 21 Emergency Medical Service 46.78 4,413.50 10,000.00 4,677 .50 5,322.50 Child Safety Fund 46.78 4,413.50 10,000.00 4,677.50 5,322.50 22 Health Department 60.40 61,580.33 970,111.00 585,919.15 384,191.85 Health Department Fund 60.40 61,580.33 970,111.00 585,919.15 384,191.85 25 Police 68.98 43,754.72 596,743.00 411,643.10 185,099.90 25 Community Developement - 12,500.00 12,500.00 Grant Fund 67.57 43,754.72 609,243.00 411,643.10 197,599.90 26 Police 433.01 175,297.09 130,224.00 563,885.45 (433,661.45) Criminal Justice Div Grant Fd 433.01 175,297.09 130,224.00 563,885.45 (433,661.45) 30 Community Develooment 22.31 7,500.00 381,980.00 85,200.00 296,780.00 June Department Expenditures.xls 3 7/6/2007 Departmental Expenditure Summary Comparison June, 2006 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Budget Actual Balance Community Dvl Block Grant F 22.31 7,500.00 381,980.00 85,200.00 296,780.00 41 City Council - 129.98 59,339.28 (59,339.28) 41 Parks Department - (1,950.00) 1,950.00 41 Street Department - 6,118.74 1,030,464.51 (1,030,464.51 ) Tax & Rev CO 2000 Const Fl - 6,248.72 1,087,853.79 (1,087,853.79) 42 Citv Council - 10,208.85 (10,208.85) 42 Police Department - 30,772.34 2,999,639.14 (2,999,639.14) CO Series 2002 Construction - 30,772.34 3,009,847.99 (3,009,847.99) 50 Debt Service 99.93 940,060.66 3,960,758.77 3,957,867.07 2,891.70 Revenue Bonds Sinking Func 99.93 940,060.66 3,960,758.77 3,957,867.07 2,891.70 55 Debt Service 100.00 142,036.88 510,498.76 510,498.76 Tax & Rev CO 2000 I&S Funl 100.00 142,036.88 510,498.76 510,498.76 56 Debt Service 99.77 111,236.25 437,672.50 436,672.50 1,000.00 Tax & Rev CO 2002 I&S Funl 99.77 111,236.25 437,672.50 436,672.50 1,000.00 58 Debt Service 99.87 391,125.00 391,625.00 391,125.00 500.00 2003 GO Refunding Bonds 99.87 391,125.00 391,625.00 391,125.00 500.00 72 Library - 48.40 1,398.79 (1,398.79) Library Memorial Fund - 48.40 1,398.79 (1,398.79) 79 Library - 17,874.60 (17,874.60) Library Expendable Fund - 17,874.60 (17,874.60) June Department Expenditures.xls 4 7/6/2007