Loading...
07 Monthly Financial Report CITY OF PARIS, TEXAS CITY COUNCIL AGENDA REQUEST MEETING DATE: I September 24,2007 ~Action D Discussion Dlnformation DRefer to: SUBMITTED BY: I Gene Anderson, Finance Director DESCRIPTION: Monthly financial report for August 2007. BACKGROUND INFORMATION: Financial report with explanatory comments. FISCAL AUTHORITY: Information only. LEGAL REVIEW: I MANAGER'S RECOMMENDATION: City of Paris August 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,529,457 included $1,340,961 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 4.70% above this point last year. 3. Hotel taxes are up 13.28% from this time last year. 4. As reported previously, "Permits" are up 27.81 % at this point in the year due to Kimberly Clark's 20 million dollar expansion. This permit alone was over $45,000. 5. Court fines are up 12.34% from this time last year. 6. The "Leases & Grants" category is up 44.72% 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. 7. 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. 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 revenue is down 5.17% and sewer revenue is down 4.41 % compared to this time last year. It is believed that this is weather related. 10. Water & Sewer "Miscellaneous" revenues are now ahead of last year due to reduced utility charges offs ($30,839 less at this point) and some 2005-06 late fees were not posted until the 2006-07 fiscal year. 11. The City Council expense to date due to payments made to the Pace Group ($39,654) and higher than expected election costs ($25,470). 12. The City Manager expense to date is higher than expected due to the cost of the interim manager ($79,478). 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. The City also paid for related travel and lodging expenses. 13. The "General Expenses" category is higher than expected reflecting a higher than expected collection and remittance of hotel taxes and the recent upgrade of the City's phone system. 14. The $20,151 expense listed under "Contingency" is really the cost of the Charter update. 15. 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. 16. August sales taxes were posted in error to the sales tax to reduce property tax account. This will be corrected in the September report. Net to Date Comparison Description 2007 2006 Net to Date General Fund Taxes Collected 6,593,056.22 7,529,457.76 (936,401.54) Sales Tax 5,163,985.36 4,931,921.40 232,063.96 Hotel-Motel Tax 426,980.51 376,895.61 50,084.90 Franchise Fees 3,018,486.21 3,031,936.24 (13,450.03) Permits 101,866.82 79,701.50 22,165.32 Court Fines 360,046.44 320,472.10 39,574.34 Leases & Grants 507,026.03 350,347.69 156,678.34 Fees & Copies 14,695.59 14,782.81 (87.22) Lamar County Fire 1,650.00 1,350.00 300.00 Grants & Donations 17,576.07 210,638.01 (193,061.94) Sanitation Fees 1,199,246.57 1,208,107.68 (8,861 .11 ) EMS Fees 2,135,700.75 2,095,624.49 40,076.26 State Revenue 50,631.85 45,514.86 5,116.99 Miscellaneous Fees 261,156.59 223,983.54 37,173.05 Summer Programs 110,129.50 110,149.43 (19.93) General Fund Total Revenues 19,962.234.51 I 20,530,883.12 I \568,648.61' General Fund Total Expenditures c 16,606,064.04 I 16,375,253.39 230,810.65 Net to Date c 3,356,170.47 4,155,629.73 (799,459.26 PEDC Fund Sales Tax 1,032,797.02 986,384.26 46,412.76 Interest Earned 12,323.57 19,542.35 (7,218.78) Loan Payments 602,000.00 352,000.00 250,000.00 PEDC Fund Total Revenues 1,647.120.59 1,357,926.61 289,193.98 PEDC Fund Total Expenditures 1,045,158.17 884.986.94 I 160,171.23 Net to Date 601,962.42 I 472,939.67 129,022.75 I Water & Sewer Fund Sewer 4,386,626.61 4,589,167.64 (202,541.03) Water 6,533,351.79 6,890,013.31 (356,661.52) Interest Earned 163,911.78 127,867.84 36,043.94 Miscellaneous 240,718.88 193,113.71 47,605.17 W&S Fund Total Revenues 11,324,609.06 11,800,162.50 (475,553,44) W &S Fund Total Expenditures 7,031,668.60 6,128,869.10 902,799.50 Net to Date 4,292,940.46 5,671,293,40 (1,378,352.94 ) Capital Projects Fund Interest Earned 10,789.80 1,862.54 8,927.26 Auction Proceeds 102,194.92 0.00 102,194.92 Capital Projects Fund Revenues 112,984.72 I 1,862.54 111,122.18 Capital Projects Fund Expenditures 323,869.33 . . Net to Date (210,884.61) I 1.862.54 (212,747.15) WW&SS Rev Bond 2000 Construction Interest Earned 21,282.35 48,914.95 70,197.30 WW &SS Rev Bond 2000 Canst Revenues . I 21,282.35 , 48,914.95 I (27,632.60) WW &SS Rev Bond 2000 Canst Fund Expenditures 137,605.50 5,000.00 , . 132,605.50 Net to Date . (116,323.15) 43,914.95 (160,238.10) August Net to Date.xls 9/10/2007 Net to Date Comparison Description 2007 2006 Net to Date Special Funds Special Funds 32,241.59 25,379.24 6,862.35 Interest Earned 752.53 1,438.09 (685.56) Special Revenue Funds Revenue 32,994.12 26,817.33 , 6,176.79 Special Revenue Funds Expenditures 26,255.67 100,067.65 (73,811.98 Net to Date 6,738.45 (73,250.32) 79,988.77 Child Safety Fund Interest Earned 6.47 208.74 (202.27) Child Safe~FundRevenues 6.47 208.74 I' , . {202.27 Child Safety Fund Expenditures 230.81, I 7,705.60 I . (7,474.79 Net to Date (224.34 (7,496.86) I 7,272.52 Health Department Interest Earned 627.71 58.19 569.52 Fees & Grants 792,841.41 863,891.82 (71,050.41 ) Health Department Fund Revenues I 793,469.12 I .' 863,950.01 I (70,480.89 Health Department Fund Expenditures 762,119.38 733,385.89 28,733.49 · Net to Date 31;349.74 I 130,564.12 . (99,214.38 Grant Fund Grants 509,742.06 558,561.89 (48,819.83) Interest Earned 1,207.20 80.04 1 ,127.16 Grant Fund Revenues 510,949.26 I 558,641.93 (47,692.67 Grant Fund Expenditures 576,661.91 , 544,623.58 32,038.33 Net to Date . (65,712.65) . 14,018.35 I (79,731.00 Criminal Justice Fund Program Income 84.92 138,113.70 (138,028.78) Contributions 598,962.10 (598,962.10' Criminal Justice Div Grant Fd Revenues I 84.92 737,075.80 736,990.88 Criminal Justice Div Grant Fd Expenditures ' 563,885.45 563,885.45 Net to Date 84.92 173,190.35 173,105.43 Community Development Block Grant Interest Earned 1 ,773.32 2,162.51 (389.19 Grants 77,450.00 37,500.00 39,950.00 Community Dvl Block Grant Fd Revenues 79,223.32 39,662.51 39,560.81 Communi~ Dvl Block Grant Fd Exoenditures . 25,200.00 124,100.00 (98,900.00 Net to Date , 54,023.32 (84,437.49) 138,460.81 Tax & Rev CO 2000 Const Fund Interest Earned 4,986.98 11,451.55 (6,464.57 Grants (11,795.88) - (11,795.88 Tax & Rev CO 2000 Canst Fund Revenues . . (6,808.90) I 11,451.55 I . (18,260.45' Tax & Rev CO 2000 Const Fund Expenditures 52,993.09 1,221,195.72 (1,168,202.63\ Net to Date (59,801.99) . (1,209,744.17) 1,149,942.18 August Net to Date.xls 2 9/10/2007 Net to Date Comparison Description CO Series 2002 Construction Fd Interest Earned 2007 2006 Net to Date 93.05 99,226.02 (99,132.971 CO Series 2002 Construction Fd Revenues 99,226;02 I (99,132.97J co Series 2002 Construction Fd Expenditures . 8,246.48 3,020,759.98 I (3,012,513.50) Net to Date . (8,153.43) (2,921,533.96) 2,913,380.53 Revenue Bonds Sinking Funds Transfer to GO Refunding 2003 Interest Earned 439,000.00 73,193.34 130,000.00 63,474.81 309,000.00 9,718.53 Revenue Bonds Sinking Funds Revenues 512,193.34 193,474.81 I 318,718.53 Revenue Bonds Sinking Funds Expenditures 3,953,960.82 3,958,167.07 '4,206.251 Net to Date I (3,441,767.48) I (3,764,692.26) 322,924.78 Tax & Rev CO 20001&5 Fund Interest Earned 1,591.99 1,486.77 105.22 Tax & Rev CO 2000 I&S Fund Revenues I 1,591.99 ' ., Tax & Rev CO 2000 I&S Fund Expenditures 510,142.51 510,498.76' '. Net to Date (508,550.52) (509,011.99) Tax & Rev CO 20021&5 Fund Tax & Rev CO 2002 I&S Fund Revenues . 0.00" 0.00 0.00 Tax & Rev CO 2002 I&S Fund Expenditures 438,661.00 436,672.50 1,988.50 Net to Date '438,661.00J . 1436,672.501 (1,988.50) 2003 GO Refunding Bonds Interest Earned 105.22 (356.25) A~1.47 13,977.96 8,215.84 5,762.12 2003 GO Refunding Bonds Revenues 2003 GO Refunding Bonds Expenditures Net to Date . Employees Insurance Fund Claim Payment Refunds 13,977.96 I. 8,215.84 5,762.12 393,285.00 I nn _ 2,160.00 . (379,307.04), (382,909.16) 3,602.12 18,299.68 1,093,746.53 (1,075,446.85) Employees Insurance Fund Revenues . 18,299.68 1,093,746.53 (1,075,446.85 Employees Insurance Fund Expenditures .' Net to Date I 18,299.68 1,093,746.53 (1,075,446.851 Library Memorial Fund Interest Earned Memorial Donations 2,658.18 4,325.76 1,655.75 10,010.95 1,002.43 (5,685.19) Library Memorial Fund Revenues r . Library Memorial Fund Expenditures . Net to Date . . W B & Kathryn Vaughan Memorial Interest Earned 6,983.94 . 11,666.70 I 3,728.57 . 1,523.90 3,255.37 10,142.80 l4,682:7~ 2,204.67 i (6,887.43) 9,096.61 (9,096.61 ) W B & Kathryn Vaughan Memorial Revenues W B & Kathryn Vaughan Memorial Expenditures Net to Date . .' 9,096.61 . (9,096.61 \ . .' . . . . 9.096.61 (9,096.61) August Net to Date.xls 3 9/10/2007 Net to Date Comparison 2007 2006 Net to Date 2,929.76 250.00 23,656.40 20,726.64) 3,179.76 4,538.00 1,358.24 Donations 1,485.92 August Net to Date.xls 4 9/10/2007 Revenue Comparison August, 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 36,340.01 153,264.05 95.79 160,000.00 6,735.95 01-7030-00-00 Penalty & Interest 8,292.13 83,119.25 83.12 100,000.00 16,880.75 01-7031-00-00 Attorney Fees 8,685.60 43,399.93 108.50 40,000.00 (3,399.93) Subtotal: 53,317.74 6,593,056.22 101.21 6,514,245.00 (78,811.22) 01-7110-00-00 Municipal Sales Tax 3,705,928.84 87.20 4,250,000.00 544,071.16 01-7112-00-00 Sales Tax-Reduce Property Tax 531,574.37 1,458,056.52 137.16 1,063,000.00 (395,056.52) Subtotal: 531,574.37 5,163,985.36 97.20 5,313,000.00 149,014.64 01-7220-00-00 Hotel-Motel Occupancy Tax 26,658.59 426,980.51 131.38 325,000.00 (101,980.51 ) Subtotal: 26,658.59 426,980.51 131.38 325,000.00 (101,980.51) 01-7310-00-00 Southwestern Bell Telephone Co 46,014.61 181,095.48 109.76 165,000.00 (16,095.48) 01-7320-00-00 Atmos Gas 115,160.29 504,468.82 77.61 650,000.00 145,531.18 01-7330-00-00 TXU Electric 347,203.49 1,639,550.85 99.07 1,655,000.00 15,449.15 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 319,665.00 94.02 340,000.00 20,335.00 01-7390-00-00 Bingo 16,844.94 61,957.28 103.26 60,000.00 (1,957.28) 01-7395-00-00 Municipal ROW Use Fee 4,877.79 26,271.45 75.06 35,000.00 8,728.55 01-7396-00-00 Solid Waste Street Use Fee 18,213.52 213,071.50 94.70 225,000.00 11,928.50 Subtotal: 577,480.64 3,018,486.21 92.58 3,260,300.00 241,813.79 01-7410-00-00 House Moving - 450.00 450.00 01-7411-00-00 Concrete Permits 50.00 1,225.00 89.09 1,375.00 150.00 01-7412-00-00 Building Permits 5,705.90 89,184.82 148.64 60,000.00 (29,184.82) 01-7413-00-00 Sign Permits 75.00 2,475.00 49.50 5,000.00 2,525.00 01-7414-00-00 Electrical Permits 201.25 1,366.25 170.78 800.00 (566.25) 01-7416-00-00 Gas Inspections 100.00 2,425.00 60.63 4,000.00 1,575.00 01-7418-00-00 Plumbing Inspections 376.25 4,180.25 92.89 4,500.00 319.75 01-7420-00-00 Electrical Licenses 157.50 1,010.50 56.14 1,800.00 789.50 Subtotal: 6,665.90 101,866.82 130.72 77,925.00 (23,941.82) 01-7510-00-00 Court Fines & Costs 27,383.06 298,730.80 93.35 320,000.00 21,269.20 01-7511-00-00 Defensive Driving Course 400.00 5,278.50 164.95 3,200.00 (2,078.50) 01-7512-00-00 Warrant Service Fees {City} 2,360.21 19,497.83 55.71 35,000.00 15,502.17 01-7513-00-00 City Traffic Fees 423.06 4,060.50 106.86 3,800.00 (260.50) 01-7514-00-00 Arrest Fees 1,386.15 14,522.85 100.16 14,500.00 (22.85) August Revenues.xls 9/10/2007 Revenue Comparison August, 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 797.49 8,763.11 98.46 8,900.00 136.89 01-7517-00-00 State Judicial Fund due City 175.54 1,759.85 351.97 500.00 (1,259.85) 01-7520-00-00 Pound Fees 726.00 4,913.00 112.94 4,350.00 (563.00) 01-7521-00-00 Pound Incineration Fees 740.00 2,520.00 193.85 1,300.00 (1,220.00) Subtotal: 34,391.51 360,046.44 91.95 391,550.00 31,503.56 01-7620-00-00 Cox Field Leases-Terminal 300.00 3,300.00 91.67 3,600.00 300.00 01-7630-00-00 Cox Field Rent Hangar Storage 60.00 660.00 91.67 720.00 60.00 01-7631-00-00 Cox Field Rental T Hangars 5,558.00 56,507.00 102.74 55,000.00 (1,507.00) 01 -7632 -00-00 Cox Field Fuel Flowage Fee 669.91 6,427.76 80.35 8,000.00 1,572.24 01-7640-00-00 Leases & Rentals 6,550.30 77.98 8,400.00 1,849.70 01-7650-00-00 Interest Earned 36,174.64 409,785.09 455.32 90,000.00 (319,785.09) 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: 42,762.55 507,026.03 305.95 165,720.00 (341,306.03) 01-7712-00-00 Recording Legal Instruments 600.00 - (600.00) 01- 7713-00-00 Zoning & Subdivision Fees 800.00 2,770.66 98.95 2,800.00 29.34 01 -7715-00-00 Sale of Maps Copies Etc 719.18 9,299.93 124.00 7,500.00 (1,799.93) 01-7716-00-00 Tax Certificates 325.00 2,025.00 79.41 2,550.00 525.00 Subtotal: 1,844.18 14,695.59 114.36 12,850.00 (1,845.59) 01-7822-00-00 Lamar County Fire Contract 150.00 1,650.00 91.67 1,800.00 150.00 Subtotal: 150.00 1,650.00 91.67 1,800.00 150.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,205.69 1,194,989.62 90.19 1,325,000.00 130,010.38 01-8047-00-00 Brush Pickup Fee 703.00 4,256.95 56.76 7,500.00 3,243.05 Subtotal: 108,908.69 1,199,246.57 90.00 1,332,500.00 133,253.43 01 -81 53-00-00 Lamar Co-Emergency Medical SE 25,666.67 282,333.37 91.08 310,000.00 27,666.63 01-8154-00-00 Emergency Medical Service Fee~ 172,886.98 1,853,367.38 103.08 1,798,000.00 (55,367.38) Subtotal: 198,553.65 2,135,700.75 101.31 2,108,000.00 (27,700.75) 01-8260-00-00 State Shared Revenue 50,631.85 126.58 40,000.00 (10,631.85) Subtotal: 50,631.85 126.58 40,000.00 (10,631.85) 01 -8308-00-00 Birth Certificate Fee for TWC 102.60 169.20 - ( 169.20) 01-8309-00-00 Birth Certificate Fees 1 ,1 51 .40 15,897.30 109.64 14,500.00 (1,397.30) 01-8310-00-00 Death Certificate Fees 1,714.00 21,567.00 107.84 20,000.00 (1,567.00) August Revenues.xls 2 9/10/2007 Revenue Comparison August, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-8311-00-00 Library Copies 211.10 2,049.32 102.47 2,000.00 (49.32) 01-8312-00-00 Library Fines & Other 1,387.15 14,757.04 98.38 15,000.00 242.96 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 6,781.90 61.65 11,000.00 4,218.10 01-8331-00-00 Lot Clean Up 578.26 8,707.59 108.85 8,000.00 (707.59) 01-8333-00-00 Refund Landfill Fee-Demolition 5,772.06 - (5,772.06) 01-8350-00-00 Miscellaneous Revenue 4,571.33 168,130.17 420.33 40,000.00 (128,130.17) 01-8365-00-00 VCC Band Contribution 10,000.00 100.00 10,000.00 01-8366-00-00 Credit Card Convenience Fee 75.55 711.11 - (711.11) 01-8368-00-00 Library Card Fees 90.00 920.00 18.40 5,000.00 4,080.00 Subtotal: 9,881.39 261,156.59 192.74 135,500.00 (125,656.59) 01-8499-00-00 Water & Sewer Transfer 62,500.00 685,000.00 91.33 750,000.00 65,000.00 Subtotal: 62,500.00 685,000.00 91.33 750,000.00 65,000.00 01-8500-00-00 Pool Vending 2,458.35 8,963.53 94.35 9,500.00 536.47 01-8501-00-00 Pool Programs 337.50 18,657.75 130.47 14,300.00 (4,357.75) 01-8502-00-00 Pool Daily Fees 5,986.25 18,820.05 134.43 14,000.00 (4,820.05) 01-8503-00-00 Sports Complex 905.60 25,295.82 - (25,295.82) 01-8504-00-00 Softball 2,700.00 25,509.10 71.86 35,500.00 9,990.90 01-8505-00-00 Reservations 425.00 3,143.50 142.89 2,200.00 (943.50) 01-8506-00-00 Sponsorships 3,700.00 - (3,700.00) 01-8507-00-00 Special Events 6,039.75 57.52 10,500.00 4,460.25 Subtotal: 12,812.70 110,129.50 128.06 86,000.00 (24,129.50) Proaram number: 1,667,501.91 20,647,234.51 100.65 20,514,390.00 (132,844.51) Department number 1,667,501.91 20,647,234.51 100.65 20,514,390.00 (132,844.51) Fund number: 1 General Fund 1,667,501.91 20,647,234.51 100.65 20,514,390.00 (132,844.51 ) 02-7111-00-00 Economic Development Sales Ta 106,314.87 1,032,797.02 103.28 1,000,000.00 (32,797.02) Subtotal: 106,314.87 1,032,797.02 103.28 1,000,000.00 (32,797.02) 02-7650-00-00 Interest Earned 1,323.05 12,323.57 61.62 20,000.00 7,676.43 Subtotal: 1,323.05 12,323.57 61.62 20,000.00 7,676.43 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 352,000.00 91.67 384,000.00 32,000.00 02-8358-00-00 C-Tech Settlement 250,000.00 - (250,000.00) Subtotal: 32,000.00 602,000.00 156.77 384,000.00 (218,000.00) Program number: 139,637.92 1,647,120.59 117.32 1,404,000.00 (243,120.59) August Revenues.xls 3 9/10/2007 Revenue Comparison August, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Department number Revenues 139,637.92 1,647,120.59 117.32 1,404,000.00 (243,120.59) Fund number: 2 Economic Development Fund 139,637.92 1,647,120.59 117.32 1,404,000.00 (243,120.59) 10-7010-00-00 Sewer Charges 377,191.37 4,241,091.03 89.76 4,725,000.00 483,908.97 10-7011-00-00 Industrial Surcharges 9,392.27 110,825.15 79.16 140,000.00 29,174.85 10-7020-00-00 Sewer Taps 1,070.00 7,980.00 79.80 10,000.00 2,020.00 10-7022-00-00 Pro Rata Sewer Line Extension 1,837.63 26,730.43 //1;;'/':'://;;':/ 1,000.00 (25,730.43) Subtotal: 389,491.27 4,386,626.61 89.96 4,876,000.00 489,373.39 1 0-7130-00-00 Water Sales 655,616.59 6,510,931.79 90.05 7,230,000.00 719,068.21 1 0- 7140-00-00 Water Taps 2,390.00 22,420.00 112.10 20,000.00 (2,420.00) 10-7142-00-00 Pro Rata Water Line Extension - 2,520.00 2,520.00 Subtotal: 658,006.59 6,533,351.79 90.08 7,252,520.00 719,168.21 10-7650-00-00 Interest Earned 7,963.21 163,911.78 136.59 120,000.00 (43,911.78) Subtotal: 7,963.21 163,911.78 136.59 120,000.00 (43,911.78) 10-8350-00-00 Miscellaneous W&S 6,677 .38 111,325.38 139.16 80,000.00 (31,325.38) 10-8352-00-00 Sanitation Billing Fee 5,697.15 62,896.35 89.85 70,000.00 7,103.65 10-8354-00-00 Service Charges 6,020.00 58,395.00 89.84 65,000.00 6,605.00 10-8355-00-00 Brush Pickup Fees 37.00 224.05 22.41 1,000.00 775.95 10-8356-00-00 Bulk Water Sales 781.12 5,680.42 113.61 5,000.00 (680.42) 10-8357 -00-00 Sewer Dumping Fees 4,019.40 43,189.94 86.38 50,000.00 6,810.06 10-8358-00-00 W&S Charge Ofts (3,107.08) (52,562.42) 61.84 (85,000.00) (32,437.58) 10-8359-00-00 W&S Returned Check Fees 720.00 7,740.00 110.57 7,000.00 (740.00) 1 0-8360-00-00 W &S Copies 0.36 23.92 79.73 30.00 6.08 10-8366-00-00 Credit Card Convenience Fee 346.75 3,261.24 163.06 2,000.00 (1,261.24) 10-8367 -00-00 Deposits Billed 127.52 545.00 - (545.00) Subtotal: 21,319.60 240,718.88 123.43 195,030.00 (45,688.88) Program number: 1,076,780.67 11,324,609.06 91.01 12,443,550.00 1,118,940.94 Department number Revenues 1,076,780.67 11,324,609.06 91.01 12,443,550.00 1,118,940.94 Fund number: 10 Water & Sewer Fund 1,076,780.67 11,324,609.06 91.01 12,443,550.00 1,118,940.94 11-7650-00-00 Interest Earned 2,962.88 10,789.80 539.49 2,000.00 (8,789.80) 11-7651-00-00 Auction Proceeds 102,194.92 102,194.92 - (102,194.92) Subtotal: 105,157.80 112,984.72 h' :~. i/ ii iY Ii if 2,000.00 (110,984.72) Program number: 105,157.80 112,984.72 tU;'!!Nh'/!!! 2,000.00 (110,984.72) Department number 105,157.80 112,984.72 1m t! iYHJ!!! 2,000.00 (110,984.72) Fund number: 11 Capital Projects Fund 105,157.80 112,984.72 /;!/ ;!/f // !{h' 2,000.00 (110,984.72) August Revenues.xls 4 9/10/2007 Revenue Comparison August, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 12-7650-00-00 Interest Earned 547.20 21,282.35 - (21,282.35) Subtotal: 547.20 21,282.35 - (21,282.35) Program number: 547.20 21,282.35 - (21,282.35) Department number 547.20 21,282.35 - (21,282.35) Fund number: 12 WW &SS Rev Bond 2000 Const F 547.20 21,282.35 - (21,282.35) 20-7002-00-00 Municipal Court Tech Fee 1,207.05 12,325.42 102.71 12,000.00 (325.42) 20-7003-00-00 Court Security Fee 909.08 9,268.58 97.56 9,500.00 231.42 20-7004-00-00 Child Safety Fee 520.77 52.08 1,000.00 479.23 20-7005-00-00 Time Payment Fee 200.4 7 2,184.82 91.03 2,400.00 215.18 20-7007 -00-00 Judicial Forfeitures Fee 7,942.00 529.47 1,500.00 (6,442.00) Subtotal: 2,316.60 32,241.59 122.13 26,400.00 (5,841.59) 20-7650-00-00 Interest Earned 80.29 752.53 150.51 500.00 (252.53) Subtotal: 80.29 752.53 150.51 500.00 (252.53) Program number: Special Revenue 2,396.89 32,994.12 122.66 26,900.00 (6,094.12) Department number Special Revenue 2,396.89 32,994.12 122.66 26,900.00 (6,094.12) Fund number: 20 Special Revenue Fund 2,396.89 32,994.12 122.66 26,900.00 (6,094.12) 21-7650-00-00 Interest Earned 6.47 - (6.4 7) Subtotal: 6.47 - (6.4 7) Program number: Think Child Safety 6.47 - (6.47) Department number Child Safety Fund 6.47 - (6.4 7) Fund number: 21 Child Safety Fund 6.47 - (6.4 7) 22-7650-00-00 Interest Earned 97.74 627.71 - (627.71 ) Subtotal: 97.74 627.71 - (627.71 ) 22 -8151-00-00 Local Fees 1,898.00 39,619.30 82.59 47,973.00 8,353.70 22-8152-00-00 ORAS 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 12,631.85 131,661.63 86.87 151,558.00 19,896.37 22-8158-00-00 State of Texas-WIC 19,856.08 279,253.36 98.24 284,249.00 4,995.64 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 343.00 5,338.35 44.49 12,000.00 6,661.65 22 -8171-00-00 ORAS Local Fees 4,650.00 44,125.00 176.50 25,000.00 (19,125.00) 22-8172-00-00 Immunization Grant 4,524.03 76,356.48 152.64 50,023.00 (26,333.48) 22 -8174-00-00 Immunization Fees 1,922.00 14,712.00 58.85 25,000.00 10,288.00 22-8175-00-00 Prenatal Care Grant 1,768.66 16,953.26 84.77 20,000.00 3,046.74 August Revenues.xls 5 9/10/2007 Revenue Comparison August, 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 93.00 1,613.88 - (1,613.88) Subtotal: 47,686.62 792,841.41 90.53 875,801.00 82,959.59 Program number: Health Department 47,784.36 793,469.12 90.60 875,801.00 82,331.88 Department number Health Department 47,784.36 793,469.12 90.60 875,801.00 82,331.88 Fund number: 22 Health Department Fund 47,784.36 793,469.12 90.60 875,801.00 82,331.88 25-7001-00-00 Paris ISO School Officers 15,148.25 153,906.00 84.67 181,779.00 27,873.00 25-7002-00-00 No. Lamar ISO School Officers 15,116.00 153,597.42 84.68 181,392.00 27,794.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 20,729.24 86,264.59 87.73 98,326.00 12,061.41 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 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: 50,993.49 509,742.06 33.55 1,519,212.00 1,009,469.94 25-7650-00-00 Interest Earned 1,207.20 - (1,207.20) Subtotal: 1,207.20 - (1,207.20) Program number: 50,993.49 510,949.26 33.63 1,519,212.00 1,008,262.74 Department number Grant Fund 50,993.49 510,949.26 33.63 1,519,212.00 1,008,262.74 Fund number: 25 Grant Fund 50,993.49 510,949.26 33.63 1,519,212.00 1,008,262.74 26-7650-00-00 Interest Earned 21.59 84.92 - (84.92) Subtotal: 21.59 84.92 - (84.92) Program number: 21.59 84.92 - (84.92) Department number Drug Task Force Grant 21.59 84.92 - (84.92) Fund number: 26 Criminal Justice Div Grant Fd 21.59 84.92 - (84.92) 30-7650-00-00 Use of Monev Property Interest 163.23 1,773.32 - (1,773.32) Subtotal: 163.23 1,773.32 - (1,773.32) 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-7858-00-00 Revolving Loan Fund (1,200.00) (1,200.00) - 1,200.00 30-7860-00-00 Infrastructure Grant EastQate 46,500.00 - (46,500.00) Subtotal: (1,200.00) 77,450.00 - (77,450.00) Program number: (1,036.77) 79,223.32 - (79,223.32) Department number (1,036.77) 79,223.32 - (79,223.32) August Revenues.xls 6 9/10/2007 Revenue Comparison August, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Fund number: 30 Community Dvl Block Grant Fund (1,036.77) 79,223.32 - (79,223.32) 41-7650-00-00 Interest Earned 401.39 4,986.98 - (4,986.98) Subtotal: 401.39 4,986.98 - (4,986.98) 41-8303-00-00 Streetscape TxDot Reimburse (11,795.88) - 11,795.88 Subtotal: (11,795.88) - 11,795.88 Program number: 401.39 (6,808.90) - 6,808.90 Department number 401.39 (6,808.90) - 6,808.90 Fund number: 41 Tax & Rev CO 2000 Const Fund 401.39 (6,808.90) - 6,808.90 42-7650-00-00 Interest Earned 5.28 93.05 - (93.05) Subtotal: 5.28 93.05 - (93.05) Program number: 5.28 93.05 - (93.05) Department number 5.28 93.05 - (93.05) Fund number: 42 CO Series 2002 Construction Fd 5.28 93.05 - (93.05) 50-1135-00-00 Transfer to GO Refunding 2003 17,000.00 439,000.00 - (439,000.00) Subtotal: 17,000.00 439,000.00 - (439,000.00) 50-7650-00-00 Use of Money Property Interest 12,179.94 73,193.34 - (73,193.34 ) Subtotal: 12,179.94 73,193.34 - (73,193.34 ) Program number: 29,179.94 512,193.34 - (512,193.34) Department number 29,179.94 512,193.34 - (512,193.34) Fund number: 50 Revenue Bonds Sinking Funds 29,179.94 512,193.34 - (512,193.34) 55-7043-00-00 Tax & Rev COs 2000 I&S 2,779.22 499,147.78 97.84 510,145.00 10,997.22 Subtotal: 2,779.22 499,147.78 97.84 510,145.00 10,997.22 55-7650-00-00 Interest Earned 168.21 1,591.99 - (1,591.99) Subtotal: 168.21 1,591.99 - (1,591.99) Program number: 2,947.43 500,739.77 98.16 510,145.00 9,405.23 Department number 2,947.43 500,739.77 98.16 510,145.00 9,405.23 Fund number: 55 Tax & Rev CO 2000 I&S Fund 2,947.43 500,739.77 98.16 510,145.00 9,405.23 56-7044-00-00 Tax & Rev COs 2002 I&S 2,392.22 425,769.44 96.97 439,075.00 13,305.56 Subtotal: 2,392.22 425,769.44 96.97 439,075.00 13,305.56 Program number: 2,392.22 425,769.44 96.97 439,075.00 13,305.56 Department number Tax & Revenue 2002 2,392.22 425,769.44 96.97 439,075.00 13,305.56 Fund number: 56 Tax & Rev CO 2002 I&S Fund 2,392.22 425,769.44 96.97 439,075.00 13,305.56 58-7045-00-00 Cert. Of Oblig. 2003 I&S 2,144.20 381,630.06 96.91 393,785.00 12,154.94 Subtotal: 2,144.20 381,630.06 96.91 393,785.00 12,154.94 August Revenues.xls 7 9/10/2007 Revenue Comparison August, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 58-7650-00-00 Interest Earned 411.19 13,977.96 - (13,977.96) Subtotal: 411.19 13,977 .96 - (13,977.96) Program number: 2,555.39 395,608.02 1 00.46 393,785.00 (1,823.02) Department number NON-departmental 2,555.39 395,608.02 1 00.46 393,785.00 (1,823.02) Fund number: 58 2003 GO Refunding Bonds 2,555.39 395,608.02 100.46 393,785.00 (1,823.02) 71-8350-00-00 City Deposits 18,299.68 - (18,299.68) Subtotal: 18,299.68 - (18,299.68) Program 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 261.79 2,658.18 - (2,658.18) Subtotal: 261.79 2,658.18 - (2,658.18) 72-8313-00-00 Memorial Donations 280.00 4,325.76 - (4,325.76) Subtotal: 280.00 4,325.76 - (4,325.76) Program number: 541 .79 6,983.94 - (6,983.94 ) Department number 541 .79 6,983.94 - (6,983.94 ) Fund number: 72 Library Memorial Fund 541.79 6,983.94 - (6,983.94 ) 79-7650-00-00 Interest 176.85 2,929.76 - (2,929.76) 79-7651-00-00 Donation 250.00 - (250.00) Subtotal: 176.85 3,179.76 - (3,179.76) Program number: 176.85 3,179.76 - (3,179.76) Department number 176.85 3,179.76 - (3,179.76) Fund number: 79 Library Expendable Fund 176.85 3,179.76 - (3,179.76) 80-7650-00-00 Interest 1.22 1,485.92 - (1,485.92) Subtotal: 1.22 1,485.92 - (1,485.92) Program number: 1.22 1,485.92 - (1,485.92) Department number 1.22 1,485.92 - (1,485.92) Fund number: 80 Library Permanent Fund 1.22 1,485.92 - (1,485.92) August Revenues.xls 8 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7010-00-00 Current Taxes 5,941,532.96 100.65 5,903,225.00 (38,307.96) 01-7020-00-00 Delinquent Taxes 40,571.72 122,084.56 81.39 150,000.00 27,915.44 01-7030-00-00 Penalty & Interest 15,124.25 90,016.20 90.02 100,000.00 9,983.80 01-7031-00-00 Attorney Fees 11,419.73 34,862.73 87.16 40,000.00 5,137.27 01-7043-00-00 Tax & Rev CO 2000 I&S 4,823.99 511,904.74 - (511,904.74) 01-7044-00-00 Tax & Rev CO 20021&S 1,918.92 441,272.05 - (441,272.05) 01-7045-00-00 Cert of Oblig 2003 I&S 1,686.32 387,784.52 - (387,784.52' Subtotal: 75,544.93 7,529,457.76 121.58 6,193,225.00 (1,336,232.76) 01-7110-00-00 Municipal Sales Tax 439,533.52 3,945,537.14 101.69 3,880,000.00 (65,537.14) 01-7112-00-00 Sales Tax-Reduce Property Tax 109,883.37 986,384.26 101.69 970,000.00 (16,384.26) Subtotal: 549,416.89 4,931,921.40 101.69 4,850,000.00 (81,921.40) 01-7220-00-00 Hotel-Motel Occupancy Tax 44,299.73 376,895.61 125.63 300,000.00 (76,895.61 ) Subtotal: 44,299.73 376,895.61 125.63 300,000.00 (76,895.61 ) 01-7310-00-00 Southwestern Bell Telephone Co 43,861.43 173,081.28 104.90 165,000.00 (8,081.28) 01-7320-00-00 Atmos Gas 108,985.09 729,621.17 145.92 500,000.00 (229,621.17) 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 15,307.36 63,545.42 97.76 65,000.00 1 ,454.58 01-7395-00-00 Municipal ROW Use Fee 5,580.43 30,235.24 71.99 42,000.00 11,764.76 01-7396-00-00 Solid Waste Street Use Fee 18,415.26 232,536.56 105.70 220,000.00 (12,536.56) Subtotal: 192,149.57 3,031,936.24 103.15 2,939,300.00 (92,636.24 ) 01-7410-00-00 House Moving 1,822.00 2,122.00 424.40 500.00 (1,622.00) 01-7411-00-00 Concrete Permits 1,200.00 87.27 1,375.00 175.00 01-7412-00-00 Building Permits 1,351.00 60,752.00 110.46 55,000.00 (5,752.00) 01-7413-00-00 Sign Permits 125.00 5,600.00 140.00 4,000.00 (1,600.00) 01-7414-00-00 Electrical Permits 25.00 780.00 70.91 1,100.00 320.00 01-7416-00-00 Gas Inspections 130.00 3,427.50 94.42 3,630.00 202.50 01-7418-00-00 Plumbing Inspections 250.00 4,100.00 105.13 3,900.00 (200.00) 01-7420-00-00 Electrical Licenses 50.00 1,720.00 51.11 3,365.00 1,645.00 Subtotal: 3,753.00 79,701.50 109.38 72,870.00 (6,831.50) 01-7510-00-00 Court Fines & Costs 19,907.67 257,037.55 74.50 345,000.00 87,962.45 01-7511-00-00 Defensive Driving Course 200.00 2,690.00 63.44 4,240.00 1,550.00 August Revenues.xls 10 9/10/2007 Revenue Comparison August, 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,923.65 30,775.55 87.93 35,000.00 4,224.45 01-7513-00-00 Citv Traffic Fees 263.40 3,211.89 67.91 4,730.00 1,518.11 01-7514-00-00 Arrest Fees 939.15 12,505.48 76.84 16,275.00 3,769.52 01-7515-00-00 Judqements of Forfeiture 99.43 99.43 - (99.43) 01-7516-00-00 Time Payment Fees Retained 512.80 7,785.49 64.88 12,000.00 4,214.51 01-7517 -00-00 State Judicial Fund due City 112.50 901.71 - (901.71 ) 01-7520-00-00 Pound Fees 4,175.00 70.17 5,950.00 1 ,775.00 01-7521-00-00 Pound Incineration Fees 310.00 1,290.00 41.61 3,100.00 1,810.00 Subtotal: 24,268.60 320,472.10 75.18 426,295.00 105,822.90 01-7610-00-00 Cox Field Leases-Land - 240.00 240.00 01-7620-00-00 Cox Field Leases-Terminal 300.00 3,300.00 91.67 3,600.00 300.00 01-7630-00-00 Cox Field Rent Hangar Storage 60.00 660.00 91.67 720.00 60.00 01-7631-00-00 Cox Field Rental T Hanqars 5,069.00 55,790.31 1 01 .44 55,000.00 (790.31 ) 01-7632-00-00 Cox Field Fuel Flowaqe Fee 924.65 8,074.40 89.72 9,000.00 925.60 01-7640-00-00 Leases & Rentals 100.00 9,710.30 115.60 8,400.00 (1,310.30) 01-7650-00-00 Interest Earned 30,222.11 259,765.44 432.94 60,000.00 (199,765.44 ) 01-7684-00-00 Great Grant 13,047.24 - (13,047.24) Subtotal: 36,675.76 350,347.69 255.80 136,960.00 (213,387.69) 01-7712-00-00 Recording Legal Instruments 150.00 - (150.00) 01-7713-00-00 Zoninq & Subdivision Fees 2,000.00 71.43 2,800.00 800.00 01-771 5-00-00 Sale of Maps Copies Etc 1,149.78 10,340.31 172.34 6,000.00 (4,340.31 ) 01-7716-00-00 Tax Certificates 235.00 2,292.50 89.90 2,550.00 257.50 Subtotal: 1,384.78 14,782.81 130.25 11,350.00 (3,432.81 ) 01- 7 822 -00-00 Lamar County Fire Contract 1,350.00 75.00 1,800.00 450.00 Subtotal: 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 11 f:;'!;'!t'!!i!!.j 12,500.00 (198,138.01) 01-8046-00-00 Sanitation Fees 108,939.09 1,202,293.68 90.74 1,325,000.00 122,706.32 01-8047-00-00 Brush Pickup Fee 494.00 5,814.00 64.60 9,000.00 3,186.00 Subtotal: 109,433.09 1,208,107.68 90.56 1,334,000.00 125,892.32 01 -8153-00-00 Lamar Co-Emergencv Medical SE 24,667.00 303,293.29 1 02.46 296,000.00 (7,293.29) 01 -8154-00-00 Emerqency Medical Service Fees 182,495.80 1,792,331.20 106.23 1,687,200.00 (105,131.20) Subtotal: 207,162.80 2,095,624.49 105.67 1,983,200.00 (112,424.49) August Revenues.xls 11 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-8260-00-00 State Shared Revenue 45,514.86 126.43 36,000.00 (9,514.86) Subtotal: 45,514.86 126.43 36,000.00 (9,514.86) 01-8308-00-00 Birth Certificate Fee for TWC 210.60 381.60 - (381.60) 01-8309-00-00 Birth Certificate Fees 2,363.40 17,107.60 192.22 8,900.00 (8,207.60) 01-831 0-00-00 Death Certificate Fees 1,763.00 21,521.00 127.72 16,850.00 (4,671.00) 01-8311-00-00 Library Copies 194.00 2,023.32 76.35 2,650.00 626.68 01-8312 -00-00 Library Fines & Other 1,067.23 13,608.85 53.37 25,500.00 11,891.15 01-8325-00-00 Sale of City Property - 10,000.00 10,000.00 01-8330-00-00 Materials & Labor Sold 8,237.39 74.89 11,000.00 2,762.61 01-8331-00-00 Lot Clean Up 8,790.20 175.80 5,000.00 (3,790.20) 01-8332-00-00 Billed Electric 2,524.41 (18,696.76) (74.79) 25,000.00 43,696.76 01-8333-00-00 Refund Landfill Fee-Demolition 31,051.55 - (31,051.55) 01-8350-00-00 Miscellaneous Revenue 1,635.33 124,967.36 312.42 40,000.00 (84,967.36) 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 39.75 565.13 - (565.13) 01-8368-00-00 Librarv Card Fees 860.00 14,221.30 94.81 15,000.00 778.70 Subtotal: 10,657.72 223,983.54 131 .83 169,900.00 (54,083.54 ) 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 Vending 338.45 6,510.36 68.53 9,500.00 2,989.64 01-8501-00-00 Pool Proqrams 640.00 15,609.00 1 09. 1 5 14,300.00 (1,309.00) 01-8502-00-00 Pool Daily Fees 1,521.00 15,249.00 108.92 14,000.00 (1,249.00) 01-8503-00-00 Sports Complex 1,322.00 32,086.82 103.51 31,000.00 (1,086.82) 01-8504-00-00 Softball 300.00 23,010.00 64.82 35,500.00 12,490.00 01-8505-00-00 Reservations 320.00 4,265.00 193.86 2,200.00 (2,065.00) 01-8506-00-00 Sponsorships 150.00 235.00 - (235.00) 01-8507 -00-00 Special Events 35.00 13,184.25 125.56 10,500.00 (2,684.25) Subtotal: 4,626.45 110,149.43 94.15 117,000.00 6,850.57 Program number: 1,259,373.32 20,530,883.12 106.19 19,334,400.00 (1,196,483.12) Department number 1,259,373.32 20,530,883.12 106.19 19,334,400.00 (1,196,483.12) Fund number: 1 General Fund 1,259,373.32 20,530,883.12 106.19 19,334,400.00 (1,196,483.12) 02-7111-00-00 Economic Development Sales Ta 109,883.37 986,384.26 101.69 970,000.00 (16,384.26) August Revenues.xls 12 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Subtotal: 109,883.37 986,384.26 101.69 970,000.00 (16,384.26) 02-7650-00-00 Interest Earned 1 ,409.28 19,542.35 390.85 5,000.00 (14,542.35) Subtotal: 1,409.28 19,542.35 390.85 5,000.00 (14,542.35) 02-8351-00-00 Loan Payment Paris Packaginq 32,000.00 352,000.00 91.67 384,000.00 32,000.00 Subtotal: 32,000.00 352,000.00 91.67 384,000.00 32,000.00 Program number: 143,292.65 1,357,926.61 99.92 1,359,000.00 1,073.39 Department number Revenues 143,292.65 1,357,926.61 99.92 1,359,000.00 1,073.39 Fund number: 2 Economic Development Fund 143,292.65 1,357,926.61 99.92 1,359,000.00 1,073.39 10-7010-00-00 Sewer Charges 427,661.99 4,429,688.82 96.30 4,600,000.00 170,311.18 10-7011-00-00 Industrial Surcharges 14,420.46 121,240.14 80.83 150,000.00 28,759.86 10-7020-00-00 Sewer Taps 560.00 7,775.00 55.54 14,000.00 6,225.00 10-7022-00-00 Pro Rata Sewer Line Extension 2,315.37 30,463.68 II t'! f! [! ;'! [1 ;'1 1,000.00 (29,463.68) Subtotal: 444,957.82 4,589,167.64 96.31 4,765,000.00 175,832.36 1 0-71 30-00-00 Water Sales 874,767.39 6,875,727.43 102.62 6,700,000.00 (175,727.43) 10-7140-00-00 Water Taps 225.00 14,080.00 70.40 20,000.00 5,920.00 10-7142-00-00 Pro Rata Water Line Extension 205.88 8.17 2,520.00 2,314.12 Subtotal: 874,992.39 6,890,013.31 102.49 6,722,520.00 (167,493.31 ) 10-7650-00-00 Interest Earned 5,085.85 127,867.84 102.29 125,000.00 (2,867.84) Subtotal: 5,085.85 127,867.84 102.29 125,000.00 (2,867.84) 10-8350-00-00 Miscellaneous W &S 9,615.71 87,214.38 124.59 70,000.00 (17,214.38) 10-8352-00-00 Sanitation Billing Fee 5,733.64 63,278.65 90.40 70,000.00 6,721.35 10-8354-00-00 Service Charges 5,735.00 56,150.30 86.39 65,000.00 8,849.70 10-8355-00-00 Brush Pickup Fees 26.00 306.00 6.12 5,000.00 4,694.00 10-8356-00-00 Bulk Water Sales 443.62 3,591.69 35.92 10,000.00 6,408.31 10-8357 -00-00 Sewer Dumping Fees 3,649.56 45,504.60 130.01 35,000.00 (10,504.60) 10-8358-00-00 W &S Charge Ofts (9,787.54) (75,620.69) 88.97 (85,000.00) (9,379.31 ) 10-8359-00-00 W&S Returned Check Fees 960.00 8,805.00 125.79 7,000.00 (1,805.00) 10-8360-00-00 W &S Copies 2.40 58.42 194.73 30.00 (28.42) 1 0-8366-00-00 Credit Card Convenience Fee 255.36 2,920.36 224.64 1,300.00 (1,620.36) 10-8367 -00-00 Deposits Billed 525.00 725.00 - (725.00) 1 0-8368-00-00 Bulk Pickup Fees 180.00 - (180.00) Subtotal: 17,158.75 193,113.71 108.29 178,330.00 (14,783.71) Program number: 1,342,194.81 11,800,162.50 100.08 11,790,850.00 (9,312.50) Department number Revenues 1,342,194.81 11,800,162.50 100.08 11,790,850.00 (9,312.50) August Revenues.xls 13 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Fund number: 10 Water & Sewer Fund 1,342,194.81 11,800,162.50 100.08 11,790,850.00 (9,312.50) 11-7650-00-00 Interest Earned 230.42 1,862.54 - (1,862.54) Subtotal: 230.42 1,862.54 - (1,862.54) Program number: 230.42 1,862.54 - (1,862.54) Department number 230.42 1,862.54 - (1,862.54) Fund number: 11 Capital Projects Fund 230.42 1,862.54 - (1,862.54) 12-7650-00-00 Interest Earned 6,026.47 48,914.95 - (48,914.95) Subtotal: 6,026.47 48,914.95 - (48,914.95) Proqram number: 6,026.47 48,914.95 - (48,914.95) Department number 6,026.47 48,914.95 - (48,914.95) Fund number: 12 WW &SS Rev Bond 2000 Const F 6,026.47 48,914.95 - (48,914.95) 20-7002-00-00 Municipal Court Tech Fee 823.52 10,405.91 80.05 13,000.00 2,594.09 20-7003-00-00 Court Security Fee 625.26 7,972.13 79.72 10,000.00 2,027.87 20-7004-00-00 Child Safety Fee 50.00 747.77 74.78 1,000.00 252.23 20-7005-00-00 Time Payment Fee 152.36 2,095.12 82.16 2,550.00 454.88 20-7006-00-00 Conf Funds-Gamblinq PD Fee 1,535.48 - (1,535.48) 20-7007 -00-00 Judicial Forfeitures Fee 1,902.82 2,622.83 52.46 5,000.00 2,377.17 Subtotal: 3,553.96 25,379.24 80.44 31,550.00 6,170.76 20-7650-00-00 Interest Earned 490.05 1,438.09 - (1,438.09) Subtotal: 490.05 1,438.09 - (1,438.09) Program number: Special Revenue 4,044.01 26,817.33 85.00 31,550.00 4,732.67 Department number Special Revenue 4,044.01 26,817.33 85.00 31,550.00 4,732.67 Fund number: 20 Special Revenue Fund 4,044.01 26,817.33 85.00 31,550.00 4,732.67 21-7650-00-00 Interest Earned 1.93 208.74 - (208.74) Subtotal: 1.93 208.74 - (208.74) Program number: Think Child Safety 1.93 208.74 - (208.74) Department number Child Safety Fund 1.93 208.74 - (208.74) Fund number: 21 Child Safety Fund 1.93 208.74 - (208.74) 22-7650-00-00 Interest Earned 53.12 58.19 - (58.19) Subtotal: 53.12 58.19 - (58.19) 22 -81 51-00-00 Local Fees 3,386.25 28,176.25 33.01 85,349.00 57,172.75 22-8152-00-00 ORAS 10,510.92 110,298.00 91.92 120,000.00 9,702.00 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 156,076.82 71.60 218,000.00 61,923.18 August Revenues.xls 14 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 22 -8158-00-00 State of Texas-WIC 33,042.32 282,252.75 130.26 216,685.00 (65,567.75) 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 Prog Fees 572.00 9,232.50 307.75 3,000.00 (6,232.50) 22-8171-00-00 ORAS Local Fees 5,000.00 52,810.00 211 .24 25,000.00 (27,810.00) 22 -8172 -00-00 Immunization Grant 4,422.57 30,332.46 60.67 50,000.00 19,667.54 22 -8174-00-00 Immunization Fees 3,054.50 29,107.00 145.54 20,000.00 (9,107.00) 22 -817 5-00-00 Prenatal Care Grant 3,031.50 11,144.36 55.72 20,000.00 8,855.64 22-8176-00-00 Prenatal Care Fees 170.00 1,934.00 - (1,934.00) 22 -8177 -00-00 Family Planning Grant 70.00 0.65 10,781.00 10,711.00 22 -8178-00-00 Family Planning Fees 80.00 - (80.00) Subtotal: 63,190.06 863,891.82 89.17 968,815.00 104,923.18 Program number: Health Department 63,243.18 863,950.01 89.18 968,815.00 104,864.99 Department number Health Department 63,243.18 863,950.01 89.18 968,815.00 104,864.99 Fund number: 22 Health Department Fund 63,243.18 863,950.01 89.18 968,815.00 104,864.99 25-7001-00-00 Paris ISO School Officers 12,724.75 178,100.33 117.97 150,973.00 (27,127.33) 25-7002-00-00 No. Lamar ISO School Officers 12,678.58 199,984.38 132.95 150,425.00 (49,559.38) 25-7003-00-00 Violent Crimes Against Women 20,873.37 67,625.08 84.53 80,000.00 12,374.92 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 19,223.00 49,865.00 198.21 25,158.00 (24,707.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: 65,499.70 558,561.89 91.89 607,855.00 49,293.11 25-7650-00-00 Interest Earned 80.04 - (80.04) Subtotal: 80.04 - (80.04) Program number: 65,499.70 558,641.93 91.90 607,855.00 49,213.07 Department number Grant Fund 65,499.70 558,641.93 91.90 607,855.00 49,213.07 Fund number: 25 Grant Fund 65,499.70 558,641.93 91.90 607,855.00 49,213.07 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 553,997.10 - (553,997.10) Subtotal: 598,962.10 - (598,962.10) August Revenues.xls 15 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Program number: 737,075.80 - (737,075.80) 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 195.29 2,162.51 - (2,162.51 ) Subtotal: 195.29 2,162.51 - (2,162.51 ) 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 15,000.00 - (15,000.00) Subtotal: 37,500.00 10.62 352,980.00 315,480.00 Program number: 195.29 39,662.51 11.24 352,980.00 313,317.49 Department number 195.29 39,662.51 11.24 352,980.00 313,317.49 Fund number: 30 Community Dvl Block Grant Fund 195.29 39,662.51 11.24 352,980.00 313,317.49 41-7650-00-00 Interest Earned 11,451.55 - (11,451.55) Subtotal: 11,451.55 - (11,451.55) Program number: 11,451.55 - (11,451.55) Department number 11,451.55 - (11,451.55) Fund number: 41 Tax & Rev CO 2000 Const Fund 11,451.55 - (11,451.55) 42-7650-00-00 Interest Earned 116.10 26,133.86 - (26,133.86) 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: 116.10 99,226.02 - (99,226.02) Program number: 116.10 99,226.02 - (99,226.02) Department number 116.10 99,226.02 - (99,226.02) Fund number: 42 CO Series 2002 Construction Fd 116.10 99,226.02 - (99,226.02) 50-1135-00-00 Transfer to GO Refunding 2003 65,000.00 130,000.00 - (130,000.00) Subtotal: 65,000.00 130,000.00 - (130,000.00) 50-7650-00-00 Use of Money Property Interest 5,689.25 63,474.81 - (63,474.81 ) Subtotal: 5,689.25 63,474.81 - (63,474.81 ) ProQram number: 70,689.25 193,474.81 - (193,474.81 ) Department number 70,689.25 193,474.81 - (193,474.81 ) Fund number: 50 Revenue Bonds SinkinQ Funds 70,689.25 193,474.81 - (193,474.81 ) 55-7043-00-00 Tax & Rev COs 2000 I&S - 510,498.76 510,498.76 August Revenues.xls 16 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance Subtotal: - 510,498.76 510,498.76 55-7650-00-00 Interest Earned 161.65 1,486.77 - (1,486.77) Subtotal: 161.65 1,486.77 - (1,486.77) Program number: 161.65 1,486.77 0.29 510,498.76 509,011.99 Department number 161.65 1,486.77 0.29 510,498.76 509,011.99 Fund number: 55 Tax & Rev CO 2000 I&S Fund 161.65 1,486.77 0.29 510,498.76 509,011.99 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 373.53 8,215.84 - (8,215.84 ) Subtotal: 373.53 8,215.84 - (8,215.84) Program number: 373.53 8,215.84 2.10 391,625.00 383,409.16 Department number NON-departmental 373.53 8,215.84 2.10 391,625.00 383,409.16 Fund number: 58 2003 GO Refunding Bonds 373.53 8,215.84 2.10 391,625.00 383,409.16 70-8350-00-00 Claim Payment Refunds 1,093,746.53 - (1,093,746.53) Subtotal: 1,093,746.53 - (1,093,746.53) Program number: 1,093,746.53 - (1,093,746.53) Department number 1,093,746.53 - (1,093,746.53) Fund number: 70 Employees Insurance Fund 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 224.85 1,655.75 - (1,655.75) Subtotal: 224.85 1,655.75 - (1,655.75) 72 -8313-00-00 Memorial Donations 260.00 10,010.95 - (10,010.95) Subtotal: 260.00 10,010.95 - (10,010.95) Program number: 484.85 11,666.70 - (11,666.70) Department number 484.85 11,666.70 - (11,666.70) August Revenues.xls 17 9/10/2007 Revenue Comparison August, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Fund number: 72 Library Memorial Fund 484.85 11,666.70 - (11,666.70) 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 377.50 2,566.20 - (2,566.20) 79-7651-00-00 Donation 21,090.20 - (21,090.20) Subtotal: 377.50 23,656.40 - (23,656.40) Program number: 377.50 23,656.40 - (23,656.40) Department number 377.50 23,656.40 - (23,656.40) Fund number: 79 Library Expendable Fund 377.50 23,656.40 - (23,656.40) 80-7650-00-00 Interest 310.27 2,507.95 - (2,507.95) Subtotal: 310.27 2,507.95 - (2,507.95) Program number: 310.27 2,507.95 - (2,507.95) Department number 310.27 2,507.95 - (2,507.95) Fund number: 80 Library Permanent Fund 310.27 2,507.95 - (2,507.95) August Revenues.xls 18 9/10/2007 Departmental Expenditure Summary Comparison August, 2007 Current Percent Month Year Current YTD Unexpended Fund Expended Actual Budget Actual Balance 01 City Council 125.02 19,910.72 92,950.00 116,204.90 (23,254.90) 01 City Manager 94.44 16,516.43 155,064.00 146,444.20 8,619.80 01 City Attorney 81.91 29,528.15 369,581.00 302,740.08 66,840.92 01 Municipal Court 94.32 25,448.33 204,684.00 193,057.69 11,626.31 01 City Clerk 85.46 11,887.76 117,919.00 100,776.19 17,142.81 01 Accounting & Auditing 97.69 54,963.42 429,069.00 419,176.19 9,892.81 01 Police 85.06 528,054.03 5,229,669.00 4,448,227.07 781,441.93 01 Fire 81.64 346,360.34 3,506,050.00 2,862,205.69 643,844.31 01 Community Development 68.93 57,459.99 652,017.00 449,401.96 202,615.04 01 Engineering 83.08 50,651.39 453,399.00 376,675.83 76,723.17 01 Public Works 90.44 13,133.09 136,547.00 123,495.09 13,051.91 01 Parks,Recreation,& ROW 80.27 115,837.33 1,123,930.00 902,158.61 221,771.39 01 Sanitation 63.45 (49,829.76) 1,204,999.00 764,599.23 440,399.77 01 Streets & Highways 68.30 224,780.81 1,969,233.00 1,344,960.54 624,272.46 01 Traffic & Public Lighting 77.62 40,163.20 505,409.00 392,292.62 113,116.38 01 Garage 85.02 28,516.26 278,130.00 236,458.45 41,671.55 01 Emergency Medical Service 91.54 231,821.07 2,124,118.00 1,944,470.79 179,647.21 01 Cox Field Airport 43.90 11,248.13 254,592.00 111,754.69 142,837.31 01 Paris Band 91.67 (107.28) 20,850.00 19,112.16 1,737.84 01 Library 82.05 79,684.52 630,511.00 517,357.68 113,153.32 01 General Expenses 109.43 152,596.87 744,146.00 814,342.62 (70,196.62) Contingency 6.66 302,705.00 20,151.76 282,553.24 General Fund 80.98 1,988,624.80 20,505,572.00 16,606,064.04 3,899,507.96 02 PEDC 15.77 22,825.20 1,570,862.00 247,762.48 1,323,099.52 02 Debt 95.71 320,896.26 833,138.00 797,395.69 35,742.31 Economic Development Fund 43.48 343,721.46 2,404,000.00 1,045,158.17 1,358,841.83 10 Warehouse 88.77 10,451.16 103,642.00 91,999.84 11,642.16 10 W & S Billing and Collecting 91.39 133,485.90 1,582,316.00 1,446,127.62 136,188.38 10 Water Production 73.48 222,135.55 2,568,133.00 1,887,162.22 680,970.78 10 Water Distribution 85.57 138,317.74 1,277,370.00 1,092,985.66 184,384.34 10 Sewer Maintenance 83.85 53,333.72 618,733.00 518,804.75 99,928.25 10 Waste Water Treatment 89.14 184,720.40 1,907,130.00 1,699,934.24 207,195.76 10 Lift Stations 68.69 31,721.66 428,965.00 294,654.27 134,310.73 10 Debt - 3,956,855.00 3,956,855.00 Water & Sewer Fund 56.51 774,166.13 12,443,144.00 7,031,668.60 5,411,4 75.40 11 Police - 162,000.33 323,869.33 (323,869.33) Capital Projects Fund - 162,000.33 323,869.33 (323,869.33) 12 Streets - 17,620.20 (17,620.20) 12 Sewer Maintenance - 68,013.68 119,985.30 (119,985.30) WW &SS Rev Bond 2000 Cons - 68,013.68 137,605.50 (137,605.50) 20 Municipal Court 13.25 1,382.77 127,987.00 16,959.70 111,027.30 20 Police Department 206.58 2,467.22 4,500.00 9,295.97 (4,795.97) Special Revenue Fund 19.82 3,849.99 132,487.00 26,255.67 106,231.33 21 Emergency Medical Service - 230.81 (230.81 ) Child Safety Fund - 230.81 (230.81) 22 Health Department 87.02 104,862.02 875,801.00 762,119.38 113,681.62 Health Department Fund 87.02 104,862.02 875,801.00 762,119.38 113,681.62 25 Police 64.29 87,067.29 896,989.00 576,661.91 320,327.09 25 Airport - 622,223.00 622,223.00 August Department Expenditures.xls 9/10/2007 _._. .,-".........,~.,-,.. Departmental Expenditure Summary Comparison August, 2007 Current Percent Month Year Current YTD Unexpended Fund Expended Actual BudQet Actual Balance Grant Fund 37.96 87,067.29 1,519,212.00 576,661.91 942,550.09 26 Police - 130,224.00 130,224.00 Criminal Justice Div Grant Fd - 130,224.00 130,224.00 30 Community Development - 25,200.00 (25,200.00) Community Dvl Block Grant Fu - 25,200.00 (25,200.00) 41 City Council - 2,546.00 54,578.91 (54,578.91 ) 41 City Attornev - 2,370.18 2,370.18 (2,370.18) 41 Street Department - (3,956.00) 3,956.00 Tax & Rev CO 2000 Const Fun - 4,916.18 52,993.09 (52,993.09) 42 Police Department - 8,246.48 (8,246.48) CO Series 2002 Construction F - 8,246.48 (8,246.48) 50 Debt Service 99.93 3,956,855.00 3,953,960.82 2,894.18 Revenue Bonds Sinkinq Funds 99.93 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 Fund 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 Fund 99.91 439,075.00 438,661.00 414.00 58 Debt Service 99.87 393,785.00 393,285.00 500.00 2003 GO Refundinq Bonds 99.87 393,785.00 393,285.00 500.00 72 Library - 2,950.00 3,728.57 (3,728.57) Library Memorial Fund - 2,950.00 3,728.57 (3,728.57) 79 Library - 4,538.00 (4,538.00) Library Expendable Fund - 4,538.00 (4,538.00) August Department Expenditures.xls 2 9/10/2007 Departmental Expenditure Summary Comparison August, 2006 Current Unexpended I Percent Month Year Current YTD Fund Expended Actual BudQet Actual Balance 01 City Council 112.76 115,273.24 488,150.00 550,432.87 (62,282.87) 01 City Manager 88.34 16,362.75 156,047.00 137,843.84 18,203.16 01 City Attorney 66.46 17,377.87 367,644.00 244,344.88 123,299.12 01 Municipal Court 93.41 20,030.64 194,459.00 181,634.58 12,824.42 01 City Clerk 88.00 11,029.57 116,619.00 102,620.03 13,998.97 01 Accountino & Auditino 88.82 75,983.05 566,384.00 503,051.25 63,332.75 01 Police 85.99 490,334.92 4,938,182.00 4,246,288.87 691,893.13 01 Fire 87.92 326,451.06 3,185,514.00 2,800,617.09 384,896.91 01 Community Development 88.50 52,254.42 607,597.00 537,743.59 69,853.41 01 Engineerino 87.99 44,484.37 438,901.00 386,190.06 52,710.94 01 Public Works 93.70 12,988.98 127,374.00 119,343.32 8,030.68 01 Parks,Recreation,& ROW 92.84 110,096.64 1,044,122.00 969,312.31 74,809.69 01 Sanitation 82.86 146,166.16 1,392,436.00 1,153,747.51 238,688.49 01 Streets & Highways 87.76 138,034.19 1,419,075.00 1,245,399.12 173,675.88 01 Traffic & Public Liahting 103.88 41,109.93 424,170.00 440,618.93 (16,448.93) 01 Garage 86.64 21,820.33 228,4 73.00 197,941.07 30,531.93 01 Emergency Medical Service 94.13 212,366.96 1,957,083.00 1,842,228.52 114,854.48 01 Cox Field Airport 61.46 23,423.83 239,858.00 147,425.29 92,432.71 01 Paris Band 89.14 50.00 20,850.00 18,586.52 2,263.48 01 Library 91.38 63,325.76 601,777.00 549,883.74 51,893.26 Contingency - 280,982.00 280,982.00 General Fund 87.12 1,938,964.67 18,795,697.00 16,375,253.39 2,420,443.61 02 PEDC 38.37 78,698.58 950,983.00 364,915.63 586,067.37 02 Debt 62.42 37,178.13 833,138.00 520,071.31 313,066.69 Economic Development Fund 49.60 115,876.71 1,784,121.00 884,986.94 899,134.06 10 Warehouse 93.84 10,215.12 95,663.00 89,768.04 5,894.96 10 W & S Billing and Collecting 31.09 39,262.28 1,576,259.00 490,069.80 1,086,189.20 10 Water Production 102.66 235,236.04 2,063,489.00 2,118,449.29 (54,960.29) 10 Water Distribution 94.39 139,265.81 1,089,971.00 1,028,857.74 61,113.26 10 Sewer Maintenance 76.13 53,214.55 593,733.00 452,035.32 141,697.68 10 Waste Water Treatment 86.87 201,634.70 1,931,722.00 1,678,109.46 253,612.54 10 Lift Stations 73.80 29,876.95 368,004.00 271,579.45 96,424.55 Debt - 3,960,758.77 3,960,758.77 Water & Sewer Fund 52.48 708,705.45 11,679,599.77 6,128,869.10 5,550,730.67 12 Sewer Maintenance - 5,000.00 (5,000.00) WW &SS Rev Bond 2000 Cor - 5,000.00 (5,000.00) 20 Municipal Court 38.59 3,259.82 225,867.00 87,166.70 138,700.30 20 Police Department 69.36 404.95 18,600.00 12,900.95 5,699.05 Special Revenue Fund 40.93 3,664.77 244,467.00 100,067.65 144,399.35 21 Emergency Medical Service 77.06 250.00 10,000.00 7,705.60 2,294.40 Child Safety Fund 77.06 250.00 10,000.00 7,705.60 2,294.40 22 Health Department 75.60 87,437.52 970,111.00 733,385.89 236,725.11 Health Department Fund 75.60 87,437.52 970,111.00 733,385.89 236,725.11 25 Police 91.27 87,705.37 596,743.00 544,623.58 52,119.42 25 Community Developement - 12,500.00 12,500.00 Grant Fund 89.39 87,705.37 609,243.00 544,623.58 64,619.42 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 Community Development 32.49 7,500.00 381,980.00 124,100.00 257,880.00 August Department Expenditures.xls 3 9/10/2007 Departmental Expenditure Summary Comparison August, 2006 Current Unexpended I Percent Month Year Current YTD Fund Expended Actual Budqet Actual Balance Community Dvl Block Grant F 32.49 7,500.00 381,980.00 124,100.00 257,880.00 41 City Council - 344.09 63,750.58 (63,750.58) 41 Parks Department - (1,950.00) 1,950.00 41 Street Department - 1,933.56 1,159,395.14 (1,159,395.14) Tax & Rev CO 2000 Const FL - 2,277 .65 1,221,195.72 (1,221,195.72) 42 City Council - 10,208.85 (10,208.85) 42 Police Department - 10,911.99 3,010,551.13 (3,010,551.13) CO Series 2002 Construction - 10,911.99 3,020,759.98 (3,020,759.98) 50 Debt Service 99.94 300.00 3,960,758.77 3,958,167.07 2,591.70 Revenue Bonds Sinkinq Func 99.94 300.00 3,960,758.77 3,958,167.07 2,591.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 - 80.19 1,523.90 (1,523.90\ Library Memorial Fund - 80.19 1,523.90 (1,523.90) 79 Library - 17,874.60 (17,874.60) Library Expendable Fund - 17,874.60 (17,874.60) August Department Expenditures.xls 4 9/10/2007 -~.._"-'~