Loading...
09-B Monthly Financial Report ~Action CITY OF PARIS, TEXAS CITY COUNCIL AGENDA REQUEST MEETING DATE: I April 23, 2007 D Discussion Dlnformation DRefer to: SUBMITTED BY: I Gene Anderson, Finance Director DESCRIPTION: March 2007 financial report. BACKGROUND INFORMATION: Monthly report to Council with explanatory comments. FISCAL AUTHORITY: Information only. LEGAL REVIEW: I MANAGER'S RECOMMENDATION: ..; 4 . -,. r' 11"'-'-'" - .~,.., ...~ City of Paris March 2007 Financial Report Comments On the "Net To Date Comparison", please note the following. 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. Current property tax collections are at 99.85%. The $6,204,647 collected to date for current taxes exceeds the $5,903,225 collected at the end of March 2006. The 2005-06 collected to date number of$7,233,888 includes 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 6% above last year at this mid-point ofthe budget year. 3. As reported previously, "Franchise Fees" are higher at this point ofthe year because TXU Energy now pays its franchise fees quarterly as opposed to annually. Also, a prorated share of the water and sewer utility franchise payment has been paid. 4. As reported previously, "Permits" are up this year due to Kimberly Clark's 20 million dollar expansion. This permit alone was over $45,000. 5. As reported previously, the "Leases" amount has been down because last year this category reflected leases and some grant revenue. The related grants were moved to the Grant Fund in March 2006 so this category is no longer distorted when compared to the previous year. 6. Sanitation fees are up 19% because no fees were transferred from the Water & Sewer Fund in March of 2006. 7. General Fund "Miscellaneous Fees" are down compared to last year because to date TML equity distributions to member cities of the Pool were larger in 2006 than they have been in 2007. These distributions represent refunds of premiums for general liability and worker's compensation coverage due to favorable experience history. 8. As reported previously, "Water Sales" are down because of decreased residential usage. The increased rainfall since October 2006 is the cause of decreased usage. 9. As previously reported, Water & Sewer Fund "Interest" is up due to the shortened period of investment which causes interest payments to be reported sooner than with longer term investments. 10. Water & Sewer "Miscellaneous Fees"at the end of March are down in 2007 due to some sanitation fees due the Water & Sewer Fund had not been transferred by the end of March 2006 and water charge offs for 2006 through March are greater than the same period in 2007. Net to Date Comparison March March Description 2007 2006 Net to Date General Fund Taxes Collected 6,318,966.46 7,233,888.02 (914,921.56) Sales Tax 2,835,064.64 2,673,585.88 161,478.76 Hotel-Motel Tax 199,640.60 178,343.70 21,296.90 Franchise Fees 1,512,786.83 745,395.39 767,391.44 Permits 69,305.92 47,983.50 21,322.42 Court Fines 207,972.36 189,188.41 18,783.95 Leases & Grants 213,765.62 200,206.15 13,559.47 Fees & Copies 7,130.29 7,932.35 (802.06) Lamar Countv Fire 900.00 750.00 150.00 Streetscape Grant 17,576.07 11,795.88 5,780.19 Sanitation Fees 653,652.09 549,079.93 104,572.16 EMS Fees 1,180,356.42 1,151,119.22 29,237.20 State Revenue 23,987.32 21,362.89 2,624.43 Miscellaneous Fees 132,750.32 167,393.65 (34,643.33) Summer Proqrams 23,376.87 18,758.84 4,618.03 General Fund Total Revenues 13,397,231.81 13,196,783.81 200,448.00 General Fund Total Expenditures 8,907,996.74 8,343,558.78 564,437.96 Net to Date 4,489,235.07 4,853,225.03 (363,989.96) PEDC Fund Sales Tax 567,012.91 534,717.17 32,295.74 Interest Earned 6,256.34 13,947.99 (7,691.65) Loan Pavments 192,000.00 192,000.00 0.00 PEDC Fund Total Revenues 765,269.25 740,665.16 24,604.09 PEDC Fund Total Expenditures 396,988.17 467,360.23 (70,372.06) Net to Date 368,281.08 273,304.93 94,976.15 Water & Sewer Fund Sewer 2,458,076.15 2,414,693.40 43,382.75 Water 3,487,129.19 3,591,761.52 (104,632.33) Interest Earned 100,758.58 64,030.02 36,728.56 Miscellaneous 147,462.30 198,732.41 (51,270.11 ) W&S Fund Total Revenues 6,193,426.22 6,269,217.35 (75,791.13) W&S Fund Total Expenditures 3,731,557.85 3,209,593.09 521,964.76 Net to Date 2,461,868.37 3,059,624.26 (597,755.89) Capital Projects Fund Interest Earned 1,350.09 745.87 604.22 Auction Proceeds 0.00 Caoital Proiects Fund Revenues 1,350.09 745.87 604.22 Caoital Proiects Fund Expenditures 0.00 Net to Date 1,350.09 745.87 604.22 WW&SS Rev Bond 2000 Construction Interest Earned 19,269.79 19,694.46 (424.67) WW&SS Rev Bond 2000 Canst Revenues 19,269.79 19,694.46 (424.67) WW&SS Rev Bond 2000 Canst Fund Exoenditure 17,620.20 5,000.00 12,620.20 March Net to Date 1 4/4/2007 Hr Net to Date Comparison Net to Date 1,649.59 14,694.46 ( 13,044.87 Special Funds Special Funds 18,385.99 14,804.01 3,581.98 Interest Earned 366.02 563.71 (197.69 Special Revenue Funds Revenue 18,752.01 15,367.72 3,384.29 Soecial Revenue Funds Expenditures 13,463.57 14,215.54 (751.97 Net to Date 5,288.44 1,152.18 4,136.26 Child Safety Fund Interest Earned 5.33 105.66 (100.33 Child Safety Fund Revenues 5.33 105.66 (100.33 Child Safety Fund Expenditures 224.00 224.00 0.00 Net to Date (218.67) (118.34) (100.33 Health Department Fees & Grants 482,527.03 440,679.18 41,847.85 Health Department Fund Revenues 482,527.03 440,679.18 41,847.85 Health Department Fund Expenditures 409,942.13 399,280.88 10,661.25 Net to Date 72,584.90 41,398.30 31,186.60 Grant Fund Grants 243,916.40 283,460.30 (39,543.90 Interest Earned 1,206.32 GrantFund Revenues 245,122.72 283,460.30 (38,337.58' Grant Fund Expenditures 283,638.71 278,651.18 4,987.53 Net to Date (38,515.99) 4,809.12 (43,325.11 ' Criminal Justice Fund Proqram Income 137,947.39 (137,947.39' Contributions 250,292.57 (250,292.57' Miscellaneous Revenue 0.00 Criminal Justice Div Grant Fd Revenues - 388,239.96 (388,239.96 Criminal Justice Div Grant Fd Expenditures 434.00 365,635.28 (365,201.28 Net to Date (434.00' 22,604.68 (23,038.68 Community Development Block Grant Interest Earned 954.47 1,146.82 (192.35' Grants 67,500.00 - 67,500.00 Community Dvl Block Grant Fd Revenues 68,454.47 1,146.82 67,307.65 Community Dvl Block Grant Fd Exoenditures 16,200.00 70,200.00 (54,000.00' Net to Date 52,254.4 7 (69,053.18' 121,307.65 Tax & Rev CO 2000 Canst Fund Interest Earned 2,916.31 9,132.75 (6,216.44 ' Grants (11,795.88) - (11,795.88' Tax & Rev CO 2000 Const Fund Revenues (8,879.57) 9,132.75 (18,012.32) Tax & Rev CO 2000 Const Fund Expenditures 45,888.01 916,142.67 (870,254.66) Net to Date (54,767.58) (907,009.92) 852,242.34 March Net to Date 2 4/4/2007 . r. Net to Date Comparison CO Series 2002 Construction Fd Interest Earned 66.51 22,669.25 (22,602.74) Sale of Scrap Metal/Forfeited Funds 10,502.00 (10,502.00) CO Series 2002 Construction Fd Revenues 66.51 33,171.25 (33,104.74) CO Series 2002 Construction Fd Expenditures 8,246.48 2,530,344.13 (2,522,097.65) Net to Date (8,179.97) (2,497,172.88) 2,488,992.91 Revenue Bonds Sinking Funds Transfer to GO RefundinCl 2003 300,000.00 300,000.00 Interest Earned 34,039.80 26,551.13 7,488.67 Revenue Bonds Sinking Funds Revenues 334,039.80 26,551.13 307,488.67 Revenue Bonds Sinking Funds Expenditures 3,045,160.66 3,017,196.91 27,963.75 Net to Date 72,711,120.86) (2,990,645.78) 279,524.92 Tax & Rev CO 2000 I&S Fund Tax & Rev COs 2000 I&S 483,615.94 483,615.94 Interest Earned 562.06 460.58 101.48 Tax & Rev CO 2000 I&S Fund Revenues 484,178.00 460.58 483,717.42 Tax & Rev CO 2000 I&S Fund Expenditures 376,036.88 368,461.88 7,575.00 Net to Date 108,141.12 (368,001.30\ 476,142.42 Tax & Rev CO 2002 I&S Fund Tax & Rev COs 2002 I&S 441,622.12 441,622.12 Tax & Rev CO 2002 I&S Fund Revenues 441,622.12 - 441,622.12 Tax & Rev CO 2002 I&S Fund Expenditures 331,824.75 325,436.25 6,388.50 Net to Date 109,797.37 (325,436.25) 435,233.62 2003 GO Refunding Bonds Cert. Of Oblig. 2003 I&S 369,646.99 369,646.99 Interest Earned 5,279.52 2,138.57 3,140.95 2003 GO Refunding Bonds Revenues 374,926.51 2,138.57 372,787.94 2003 GO Refundinq Bonds Expenditures 0.00 Net to Date 374,926.51 2,138.57 372,787.94 Employees Insurance Fund Claim Payment Refunds 876,611.38 (876,611.38) Employees Insurance Fund Revenues - 876,611.38 (876,611.38) Employees Insurance Fund Expenditures 0.00 Net to Date - 876,611.38 (876,611.38) Library Memorial Fund Interest Earned 1,352.62 635.84 716.78 Memorial Donations 2,726.33 2,839.95 (113.62) Library Memorial Fund Revenues 4,078.95 3,475.79 603.16 Library Memorial Fund Expenditures 429.83 441.47 (11.64) Net to Date 3,649.12 3,034.32 614.80 March Net to Date 3 4/4/2007 . T. Net to Date Comparison W B & Kathryn Vauahan Memorial Interest Earned - 9,096.61 (9,096.61 ) W B & Kathrvn Vaughan Memorial Revenues - 9,096.61 (9,096.61 ) W B & Kathryn Vaughan Memorial Expenditures 0.00 Net to Date - 9,096.61 (9,096.61 ) Library Expendable Fund Interest Earned 1,997.40 973.65 1,023.75 Donations 250.00 6,090.20 (5,840.20) Library Expendable Fund Revenues 2,247.40 7,063.85 (4,816.45) Library Expendable Fund Expenditures 17,874.60 (17,874.60) Net to Date 2,247.40 (10,810.75) 13,058.15 Library Permanent Fund Interest Earned 1,479.78 1,004.33 475.45 Donations 0.00 Library Permanent Fund Revenues 1,479.78 1,004.33 475.45 Library Permanent Fund Expenditures 0.00 Net to Date 1,479.78 1,004.33 475.45 March Net to Date 4 4/4/2007 '.r Revenue Comparison -1 March, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance 01-7010-00-00 Current Taxes 88,482.15 6,204,647.73 99.85 6,214,245.00 9,597.27 01-7020-00-00 Delinquent Taxes 6,605.73 58,227.34 36.39 160,000.00 101,772.66 01-7030-00-00 Penalty & Interest 11,536.41 37,293.06 37.29 100,000.00 62,706.94 01-7031-00-00 Attorney Fees 2,424.86 18,798.33 47.00 40,000.00 21,201.67 Subtotal: 109,049.15 6,318,966.46 97.00 6,514,245.00 195,278.54 01-7110-00-00 Municipal Sales Tax 309,794.92 2,268,051.73 53.37 4,250,000.00 1,981,948.27 01-7112-00-00 Sales Tax-Reduce Property Tax 77,448.73 567,012.91 53.34 1,063,000.00 495,987.09 Subtotal: 387,243.65 2,835,064.64 53.36 5,313,000.00 2,477,935.36 01-7220-00-00 Hotel-Motel Occupancy Tax 199,640.60 61 .43 325,000.00 125,359.40 Subtotal: 199,640.60 61.43 325,000.00 125,359.40 01-731 0-00-00 Southwestern Bell Telephone Co 89,965.05 54.52 165,000.00 75,034.95 01-7320-00-00 Atmos Gas 204,246.39 31.42 650,000.00 445,753.61 01-7330-00-00 TXU Electric 355,396.53 866,492.98 52.36 1,655,000.00 788,507.02 01-7340-00-00 Taxicabs 350.00 116.67 300.00 (50.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 116,667.00 34.31 340,000.00 223,333.00 01-7390-00-00 BinQo 13,137.59 28,624.95 47.71 60,000.00 31,375.05 01-7395-00-00 Municipal ROW Use Fee 65.47 13,902.64 39.72 35,000.00 21,097.36 01-7396-00-00 Solid Waste Street Use Fee 17,964.07 120,431.99 53.53 225,000.00 104,568.01 Subtotal: 386,563.66 1,512,786.83 46.40 3,260,300.00 1,747,513.17 01-7410-00-00 House Moving - 450.00 450.00 01-7411-00-00 Concrete Permits 275.00 775.00 56.36 1,375.00 600.00 01-7412-00-00 Building Permits 3,000.50 62,822.92 104.71 60,000.00 (2,822.92) 01-7413-00-00 Siqn Permits 90.00 1,200.00 24.00 5,000.00 3,800.00 01-7414-00-00 Electrical Permits 150.00 640.00 80.00 800.00 160.00 01-7416-00-00 Gas Inspections 175.00 1,600.00 40.00 4,000.00 2,400.00 01-7418-00-00 Plumbing Inspections 625.00 2,025.00 45.00 4,500.00 2,4 75.00 01-7420-00-00 Electrical Licenses 243.00 13.50 1,800.00 1,557.00 Subtotal: 4,315.50 69,305.92 88.94 77 ,925.00 8,619.08 01-7510-00-00 Court Fines & Costs 29,228.67 173,068.77 54.08 320,000.00 146,931.23 01-7511-00-00 Defensive Driving Course 2,508.50 3,978.50 124.33 3,200.00 (778.50) 01-7512-00-00 Warrant Service Fees {City} 1,578.00 10,311.04 29.46 35,000.00 24,688.96 01-7513-00-00 City Traffic Fees 432.22 2,183.65 57.46 3,800.00 1,616.35 01-7514-00-00 Arrest Fees 1,622.25 8,366.13 57.70 14,500.00 6,133.87 March Revenues 4/4/2007 Revenue Comparison March, 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 770.81 4,836.61 54.34 8,900.00 4,063.39 01-7517 -00-00 State Judicial Fund due City 194.04 982.66 196.53 500.00 (482.66) 01-7520-00-00 Pound Fees 545.00 2,925.00 67.24 4,350.00 1 ,425.00 01-7521-00-00 Pound Incineration Fees 1,320.00 101.54 1,300.00 (20.00) Subtotal: 36,879.49 207,972.36 53.12 391,550.00 183,577.64 01-7620-00-00 Cox Field Leases-Terminal 300.00 1,800.00 50.00 3,600.00 1 ,800.00 01-7630-00-00 Cox Field Rent Hangar Storage 60.00 360.00 50.00 720.00 360.00 01-7631-00-00 Cox Field Rental T Hangars 5,224.00 29,719.00 54.04 55,000.00 25,281.00 01-7632-00-00 Cox Field Fuel Flowage Fee 3,217.30 40.22 8,000.00 4,782.70 01-7640-00-00 Leases & Rentals 2,397.30 28.54 8,400.00 6,002.70 01-7650-00-00 Interest Earned 31,857.77 152,476.14 169.42 90,000.00 (62,476.14) 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: 37,441.77 213,765.62 128.99 165,720.00 (48,045.62) 01-7713-00-00 Zoning & Subdivision Fees 145.66 1,570.66 56.10 2,800.00 1,229.34 01-7715-00-00 Sale of Maps Copies Etc 614.74 4,617.13 61.56 7,500.00 2,882.87 01- 7716-00-00 Tax Certificates 207.50 942.50 36.96 2,550.00 1,607.50 Subtotal: 967.90 7,130.29 55.49 12,850.00 5,719.71 01-7822-00-00 Lamar County Fire Contract 150.00 900.00 50.00 1,800.00 900.00 Subtotal: 150.00 900.00 50.00 1,800.00 900.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,392.63 652,501.64 49.25 1,325,000.00 672,498.36 01 -8047-00-00 Brush Pickup Fee 228.00 1,150.45 15.34 7,500.00 6,349.55 Subtotal: 108,620.63 653,652.09 49.06 1,332,500.00 678,847.91 01-81 53-00-00 Lamar Co-Emergency Medical SE 25,666.67 154,000.02 49.68 310,000.00 155,999.98 01-81 54-00-00 Emergency Medical Service Fee:: 196,179.36 1,026,356.40 57.08 1,798,000.00 771,643.60 Subtotal: 221,846.03 1,180,356.42 55.99 2,108,000.00 927,643.58 01-8260-00-00 State Shared Revenue 23,987.32 59.97 40,000.00 16,012.68 Subtotal: 23,987.32 59.97 40,000.00 16,012.68 01-8308-00-00 Birth Certificate Fee for TWC 86.40 365.40 - (365.40) 01 -8309-00-00 Birth Certificate Fees 969.60 7,736.50 53.36 14,500.00 6,763.50 01-8310-00-00 Death Certificate Fees 1,140.00 10,557.00 52.79 20,000.00 9,443.00 01-8311-00-00 Library Copies 216.50 1,024.80 51.24 2,000.00 975.20 March Revenues 2 4/4/2007 Revenue Comparison March, 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,521.71 6,985.62 46.57 15,000.00 8,014.38 01-8314-00-00 Loan Star Libraries Grant 4,081.00 - (4,081.00) 01-8325-00-00 Sale of City Property - 10,000.00 10,000.00 01-8330-00-00 Materials & Labor Sold 258.15 4,237.89 38.53 11,000.00 6,762.11 01-8331-00-00 Lot Clean Up 1,414.56 4,261.60 53.27 8,000.00 3,738.40 01-8333-00-00 Refund Landfill Fee-Demolition 5,772.06 - (5,772.06) 01-8350-00-00 Miscellaneous Revenue 1,447.70 76,819.60 192.05 40,000.00 (36,819.60) 01-8365-00-00 VCC Band Contribution 10,000.00 100.00 10,000.00 01-8366-00-00 Credit Card Convenience Fee 139.95 448.85 - (448.85) 01-8368-00-00 Library Card Fees 30.00 460.00 9.20 5,000.00 4,540.00 Subtotal: 7,224.57 132,750.32 97.97 135,500.00 2,749.68 01-8499-00-00 Water & Sewer Transfer 250,000.00 33.33 750,000.00 500,000.00 Subtotal: 250,000.00 33.33 750,000.00 500,000.00 01-8500-00-00 Pool Vending 152.00 1.60 9,500.00 9,348.00 01-8501-00-00 Pool Programs - 14,300.00 14,300.00 01-8502-00-00 Pool Daily Fees - 14,000.00 14,000.00 01-8503-00-00 Sports Complex 1,337.73 6,198.87 - (6,198.87) 01-8504-00-00 Softball 6,637.00 9,987.00 28.13 35,500.00 25,513.00 01-8505-00-00 Reservations 265.00 860.00 39.09 2,200.00 1,340.00 01-8506-00-00 Sponsorships 1,800.00 - (1,800.00) 01-8507 -00-00 Special Events 3,090.00 4,379.00 41.71 10,500.00 6,121.00 Subtotal: 11,329.73 23,376.87 27.18 86,000.00 62,623.13 Program number: 1,311,632.08 13,647,231.81 66.53 20,514,390.00 6,867,158.19 Department number 1,311,632.08 13,647,231.81 66.53 20,514,390.00 6,867,158.19 Fund number: 1 General Fund 1,311,632.08 13,647,231.81 66.53 20,514,390.00 6,867,158.19 02-7111-00-00 Economic Development Sales Ta 77,448.73 567,012.91 56.70 1,000,000.00 432,987.09 Subtotal: 77,448.73 567,012.91 56.70 1,000,000.00 432,987.09 02-7650-00-00 Interest Earned 461.86 6,256.34 31.28 20,000.00 13,743.66 Subtotal: 461.86 6,256.34 31.28 20,000.00 13,743.66 02-8351-00-00 Loan Pavment Paris Packaging 64,000.00 192,000.00 50.00 384,000.00 192,000.00 Subtotal: 64,000.00 192,000.00 50.00 384,000.00 192,000.00 Program number: 141,910.59 765,269.25 54.51 1,404,000.00 638,730.75 Department number Revenues 141,910.59 765,269.25 54.51 1,404,000.00 638,730.75 Fund number: 2 Economic Development Fund 141,910.59 765,269.25 54.51 1,404,000.00 638,730.75 March Revenues 3 4/4/2007 Revenue Comparison i March, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 10-7010-00-00 Sewer Charges 381,240.46 2,382,495.45 50.42 4,725,000.00 2,342,504.55 10-7011-00-00 Industrial Surcharges 11,628.27 55,400.81 39.57 140,000.00 84,599.19 10-7020-00-00 Sewer Taps 1,020.00 4,770.00 47.70 10,000.00 5,230.00 10-7022-00-00 Pro Rata Sewer Line Extension 2,104.83 15,409.89 ;';'!;'!;' /;' I;' ;;' t! 1,000.00 (14,409.89) Subtotal: 395,993.56 2,458,076.15 50.41 4,876,000.00 2,417,923.85 10-7130-00-00 Water Sales 506,749.98 3,471,939.19 48.02 7,230,000.00 3,758,060.81 10-7140-00-00 Water Taps 4,570.00 15,190.00 75.95 20,000.00 4,810.00 10-7142-00-00 Pro Rata Water Line Extension - 2,520.00 2,520.00 Subtotal: 511,319.98 3,487,129.19 48.08 7,252,520.00 3,765,390.81 10-7650-00-00 Interest Earned 18,169.64 100,758.58 83.97 120,000.00 19,241.42 Subtotal: 18,169.64 100,758.58 83.97 120,000.00 19,241.42 10-8350-00-00 Miscellaneous W&S 9,619.26 77,297.37 96.62 80,000.00 2,702.63 10-8352-00-00 Sanitation Billing Fee 5,704.88 34,342.22 49.06 70,000.00 35,657.78 10-8354-00-00 Service Charges 5,310.00 28,660.00 44.09 65,000.00 36,340.00 1 0-8355-00-00 Brush Pickup Fees 12.00 60.55 6.06 1,000.00 939.45 10-8356-00-00 Bulk Water Sales 45.26 3,346.74 66.94 5,000.00 1,653.26 10-8357 -00-00 Sewer Dumping Fees 3,268.32 23,923.21 47.85 50,000.00 26,076.79 10-8358-00-00 W &S Charge Ofts (3,413.70) (26,566.17) 31.25 (85,000.00) (58,433.83) 1 0-8359-00-00 W &S Returned Check Fees 390.00 4,170.00 59.57 7,000.00 2,830.00 10-8360-00-00 W &S Copies 5.54 16.00 53.33 30.00 14.00 10-8366-00-00 Credit Card Convenience Fee 351.77 1,827.38 91.37 2,000.00 172.62 10-8367 -00-00 Deposits Billed 100.00 385.00 - (385.00) Subtotal: 21,393.33 147,462.30 75.61 195,030.00 47,567.70 Program number: 946,876.51 6,193,426.22 49.77 12,443,550.00 6,250,123.78 Department number Revenues 946,876.51 6,193,426.22 49.77 12,443,550.00 6,250,123.78 Fund number: 10 Water & Sewer Fund 946,876.51 6,193,426.22 49.77 12,443,550.00 6,250,123.78 11-7650-00-00 Interest Earned 252.02 1,350.09 67.51 2,000.00 649.91 Subtotal: 252.02 1,350.09 67.51 2,000.00 649.91 Program number: 252.02 1,350.09 67.51 2,000.00 649.91 Department number 252.02 1,350.09 67.51 2,000.00 649.91 Fund number: 11 Capital Projects Fund 252.02 1,350.09 67.51 2,000.00 649.91 12-7650-00-00 Interest Earned 38.38 19,269.79 - (19,269.79) Subtotal: 38.38 19,269.79 - (19,269.79) Program number: 38.38 19,269.79 - (19,269.79) March Revenues 4 4/4/2007 Revenue Comparison -j March, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Department number 38.38 19,269.79 - (19,269.79) Fund number: 12 WW &SS Rev Bond 2000 Const F 38.38 19,269.79 - (19,269.79) 20-7002 -00-00 Municipal Court Tech Fee 1,348.22 7,012.34 58.44 12,000.00 4,987.66 20-7003-00-00 Court Security Fee 1,013.03 5,278.35 55.56 9,500.00 4,221.65 20-7004-00-00 Child Safety Fee 50.00 345.77 34.58 1,000.00 654.23 20-7005-00-00 Time Payment Fee 189.92 1,203.13 50.13 2,400.00 1,196.87 20-7007 -00-00 Judicial Forfeitures Fee 401.70 4,546.40 303.09 1,500.00 (3,046.40) Subtotal: 3,002.87 18,385.99 69.64 26,400.00 8,014.01 20-7650-00-00 Interest Earned 68.57 366.02 73.20 500.00 133.98 Subtotal: 68.57 366.02 73.20 500.00 133.98 Program number: Special Revenue 3,071.44 18,752.01 69.71 26,900.00 8,147.99 Department number Special Revenue 3,071.44 18,752.01 69.71 26,900.00 8,147.99 Fund number: 20 Special Revenue Fund 3,071.44 18,752.01 69.71 26,900.00 8,147.99 21-7650-00-00 Interest Earned 1.00 5.33 - (5.33) Subtotal: 1.00 5.33 - (5.33) Program number: Think Child Safety 1.00 5.33 - (5.33) Department number Child Safety Fund 1.00 5.33 - (5.33) Fund number: 21 Child Safety Fund 1.00 5.33 - (5.33) 22 -81 51-00-00 Local Fees 2,944.00 26,481.30 55.20 47,973.00 21,491.70 22-8152-00-00 ORAS 53,955.99 49.05 109,998.00 56,042.01 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 18,289.29 71,174.44 46.96 151,558.00 80,383.56 22-8158-00-00 State of Texas-WIC 73,947.20 179,042.44 62.99 284,249.00 105,206.56 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 848.35 2,845.35 23.71 12,000.00 9,154.65 22-8171-00-00 ORAS Local Fees 3,750.00 18,975.00 75.90 25,000.00 6,025.00 22-8172-00-00 Immunization Grant 36,415.39 72.80 50,023.00 13,607.61 22-8174-00-00 Immunization Fees 1,222.00 7,258.00 29.03 25,000.00 17,742.00 22-8175-00-00 Prenatal Care Grant 4,314.72 12,083.09 60.42 20,000.00 7,916.91 22-8176-00-00 Prenatal Care Fees 93.00 1,085.88 - (1,085.88) Subtotal: 105,408.56 482,527.03 55.10 875,801.00 393,273.97 Program number: Health Department 105,408.56 482,527.03 55.10 875,801.00 393,273.97 Department number Health Department 105,408.56 482,527.03 55.10 875,801.00 393,273.97 Fund number: 22 Health Department Fund 105,408.56 482,527.03 55.10 875,801.00 393,273.97 March Revenues 5 4/4/2007 Revenue Comparison -j March, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance 25-7001-00-00 Paris ISD School Officers 15,148.25 78,164.75 43.00 181,779.00 103,614.25 25-7002-00-00 No. Lamar ISD School Officers 15,116.00 78,017.42 43.01 181,392.00 103,374.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 41,417.85 42.12 98,326.00 56,908.15 25-7006-00-00 Justice Assistance Grant 11,756.00 46.32 25,378.00 13,622.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 - 227,999.00 227,999.00 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: 30,264.25 243,916.40 16.06 1,519,212.00 1,275,295.60 25-7650-00-00 Interest Earned 81.04 1,206.32 - (1,206.32) Subtotal: 81.04 1,206.32 - (1,206.32) Program number: 30,345.29 245,122.72 16.14 1,519,212.00 1,274,089.28 Department number Grant Fund 30,345.29 245,122.72 16.14 1,519,212.00 1,274,089.28 Fund number: 25 Grant Fund 30,345.29 245,122.72 16.14 1,519,212.00 1,274,089.28 30-7650-00-00 Use of Money Property Interest 71.64 954.47 - (954.47) Subtotal: 71.64 954.47 - (954.47) 30-7856-00-00 Owner Occupied Rehab 37,500.00 - (37,500.00) 30-7860-00-00 Infrastructure Grant Eastgate 15,000.00 30,000.00 - (30,000.00) Subtotal: 15,000.00 67,500.00 - (67,500.00) Program number: 15,071.64 68,454.47 - (68,454.47) Department number 15,071.64 68,454.47 - (68,454.47) Fund number: 30 Community Dvl Block Grant Fund 15,071.64 68,454.47 - (68,454.47) 41-7650-00-00 Interest Earned 422.01 2,916.31 - (2,916.31) Subtotal: 422.01 2,916.31 - (2,916.31) 41-8303-00-00 Streetscape TxDot Reimburse (11,795.88) - 11 ,795.88 Subtotal: (11,795.88) - 11 ,795.88 Proaram number: 422.01 (8,879.57) - 8,879.57 Department number 422.01 (8,879.57) - 8,879.57 Fund number: 41 Tax & Rev CO 2000 Canst Fund 422.01 (8,879.57) - 8,879.57 42-7650-00-00 Interest Earned 5.29 66.51 - (66.51 ) Subtotal: 5.29 66.51 - (66.51 ) Program number: 5.29 66.51 - (66.51 ) Department number 5.29 66.51 - (66.51 ) March Revenues 6 4/4/2007 Revenue Comparison March, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Fund number: 42 CO Series 2002 Construction Fd 5.29 66.51 - (66.51 ) 50-1135-00-00 Transfer to GO Refunding 2003 35,000.00 300,000.00 - (300,000.00) Subtotal: 35,000.00 300,000.00 - (300,000.00) 50-7650-00-00 Use of Money Property Interest 247.76 34,039.80 - (34,039.80) Subtotal: 247.76 34,039.80 - (34,039.80) Program number: 35,247.76 334,039.80 - (334,039.80) Department number 35,247.76 334,039.80 - (334,039.80) Fund number: 50 Revenue Bonds Sinking Funds 35,247.76 334,039.80 - (334,039.80) 55-7043-00-00 Tax & Rev COs 2000 I&S 7,232.20 483,615.94 94.80 510,145.00 26,529.06 Subtotal: 7,232.20 483,615.94 94.80 510,145.00 26,529.06 55-7650-00-00 Interest Earned 109.28 562.06 - (562.06) Subtotal: 109.28 562.06 - (562.06) Program number: 7,341.48 484,178.00 94.91 510,145.00 25,967.00 Department number 7,341.48 484,178.00 94.91 510,145.00 25,967.00 Fund number: 55 Tax & Rev CO 2000 I&S Fund 7,341.48 484,178.00 94.91 510,145.00 25,967.00 56-7044-00-00 Tax & Rev COs 2002 I&S 6,225.13 441,622.12 100.58 439,075.00 (2,547.12) Subtotal: 6,225.13 441,622.12 100.58 439,075.00 (2,547.12) Program number: 6,225.13 441,622.12 100.58 439,075.00 (2,547.12) Department number Tax & Revenue 2002 6,225.13 441,622.12 100.58 439,075.00 (2,547.12) Fund number: 56 Tax & Rev CO 2002 I&S Fund 6,225.13 441,622.12 100.58 439,075.00 (2,547.12) 58-7045-00-00 Cert. Of Oblig. 2003 I&S 5,579.76 369,646.99 93.87 393,785.00 24,138.01 Subtotal: 5,579.76 369,646.99 93.87 393,785.00 24,138.01 58-7650-00-00 Interest Earned 2,019.21 5,279.52 - (5,279.52) Subtotal: 2,019.21 5,279.52 - (5,279.52) Program number: 7,598.97 374,926.51 95.21 393,785.00 18,858.49 Department number NON-departmental 7,598.97 374,926.51 95.21 393,785.00 18,858.49 Fund number: 58 2003 GO Refunding Bonds 7,598.97 374,926.51 95.21 393,785.00 18,858.49 72-7650-00-00 Interest Earned 255.91 1,352.62 - (1,352.62) Subtotal: 255.91 1,352.62 - (1,352.62) 72-8313-00-00 Memorial Donations 495.00 2,726.33 - (2,726.33 Subtotal: 495.00 2,726.33 - (2,726.33) Program number: 750.91 4,078.95 - (4,078.95) Department number 750.91 4,078.95 - (4,078.95) Fund number: 72 Library Memorial Fund 750.91 4,078.95 - (4,078.95) March Revenues 7 4/4/2007 Revenue Comparison ~ March, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 79-7650-00-00 Interest 196.54 1,997.40 - (1,997.40) 79-7651-00-00 Donation 250.00 - (250.00) Subtotal: 196.54 2,247.40 - (2,247.40) Program number: 196.54 2,247.40 - (2,247.40) Department number 196.54 2,247.40 - (2,247.40) Fund number: 79 Library Expendable Fund 196.54 2,247.40 - (2,247.40) 80-7650-00-00 Interest 1.22 1,479.78 - (1,479.78) Subtotal: 1.22 1,479.78 - (1,479.78) Program number: 1.22 1,479.78 - (1,479.78) Department number 1.22 1,479.78 - (1,479.78) Fund number: 80 Library Permanent Fund 1.22 1,479.78 - (1,479.78) March Revenues 8 4/4/2007 Revenue Comparison March, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7010-00-00 Current Taxes 137,135.13 5,817,363.23 98.55 5,903,225.00 85,861.77 01-7020-00-00 Delinquent Taxes 4,576.61 54,486.45 36.32 150,000.00 95,513.55 01-7030-00-00 Penalty & Interest 14,669.19 46,097.84 46.10 100,000.00 53,902.16 01-7031-00-00 Attorney Fees 1,286.02 16,187.89 40.47 40,000.00 23,812.11 01-7043-00-00 Tax & Rev CO 2000 I&S (185,307.95) 504,882.82 - (504,882.82) 01-7044-00-00 Tax & Rev CO 2002 I&S 115,219.52 423,075.86 - (423,075.86) 01-7045-00-00 Cert of Oblig 2003 I&S 101,253.52 371,793.93 - (371,793.93) Subtotal: 188,832.04 7,233,888.02 116.80 6,193,225.00 (1,040,663.02) 01-7110-00-00 Municipal Sales Tax 308,785.67 2,138,868.71 55.13 3,880,000.00 1 ,741,131.29 01-7112-00-00 Sales Tax-Reduce Property Tax 77,196.42 534,717.17 55.13 970,000.00 435,282.83 Subtotal: 385,982.09 2,673,585.88 55.13 4,850,000.00 2,176,414.12 01-7220-00-00 Hotel-Motel Occupancy Tax 178,343.70 59.45 300,000.00 121,656.30 Subtotal: 178,343.70 59.45 300,000.00 121,656.30 01-7310-00-00 Southwestern Bell Telephone Co 85,398.88 51.76 165,000.00 79,601.12 01-7320-00-00 Atmos Gas 384,567.09 76.91 500,000.00 115,432.91 01-7330-00-00 TXU Electric - 1,500,000.00 1,500,000.00 01-7340-00-00 Taxicabs 100.00 350.00 116.67 300.00 (50.00) 01-7350-00-00 TCA Cable 107,412.68 100.39 107,000.00 (412.68) 01-7360-00-00 Water Sewer Utility - 340,000.00 340,000.00 01-7390-00-00 Bingo 30,929.48 47.58 65,000.00 34,070.52 01-7395-00-00 Municipal ROW Use Fee 60.75 15,507.85 36.92 42,000.00 26,492.15 01-7396-00-00 Solid Waste Street Use Fee 19,341.69 121,229.41 55.10 220,000.00 98,770.59 Subtotal: 19,502.44 745,395.39 25.36 2,939,300.00 2,193,904.61 01-7410-00-00 House Moving 100.00 200.00 40.00 500.00 300.00 01- 7 411-00-00 Concrete Permits 50.00 600.00 43.64 1,375.00 775.00 01-7412-00-00 Building Permits 2,791.00 36,521.00 66.40 55,000.00 18,479.00 01-7413-00-00 Sign Permits 915.00 4,165.00 104.13 4,000.00 (165.00) 01-7414-00-00 Electrical Permits 125.00 375.00 34.09 1,100.00 725.00 01-7416-00-00 Gas Inspections 400.00 2,597.50 71.56 3,630.00 1,032.50 01-7418-00-00 Plumbing Inspections 775.00 2,475.00 63.46 3,900.00 1 ,425.00 01-7420-00-00 Electrical Licenses 150.00 1,050.00 31.20 3,365.00 2,315.00 Subtotal: 5,306.00 47,983.50 65.85 72,870.00 24,886.50 01-7510-00-00 Court Fines & Costs 29,907.80 150,423.12 43.60 345,000.00 194,576.88 01-7511-00-00 Defensive Driving Course 330.00 1,620.00 38.21 4,240.00 2,620.00 March Revenues 9 4/4/2007 Revenue Comparison March, 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} 4,098.63 20,232.58 57.81 35,000.00 14,767.42 01-7513-00-00 City Traffic Fees 380.63 1,903.02 40.23 4,730.00 2,826.98 01-7514-00-00 Arrest Fees 1,394.16 7,322.53 44.99 16,275.00 8,952.47 01-7516-00-00 Time Payment Fees Retained 781.37 4,593.00 38.28 12,000.00 7,407.00 01-7517-00-00 State Judicial Fund due City 121.50 369.16 - (369.16) 01-7520-00-00 Pound Fees 480.00 1,885.00 31.68 5,950.00 4,065.00 01-7521-00-00 Pound Incineration Fees 170.00 840.00 27.10 3,100.00 2,260.00 Subtotal: 37,664.09 189,188.41 44.38 426,295.00 237,106.59 01-7610-00-00 Cox Field Leases-Land - 240.00 240.00 01-7620-00-00 Cox Field Leases-Terminal 600.00 2,100.00 58.33 3,600.00 1,500.00 01-7630-00-00 Cox Field Rent Hangar Storage 120.00 420.00 58.33 720.00 300.00 01-7631-00-00 Cox Field Rental T Hangars 9,633.00 33,709.72 61.29 55,000.00 21,290.28 01-7632-00-00 Cox Field Fuel Flowage Fee 441.65 3,899.45 43.33 9,000.00 5,100.55 01-7640-00-00 Leases & Rentals 200.00 6,757.30 80.44 8,400.00 1,642.70 01-7650-00-00 Interest Earned 27,653.37 92,799.68 154.67 60,000.00 (32,799.68) 01-7672-00-00 Auto Theft Prevention Grant (9,560.25) - 01-7678-00-00 Violent Crimes Against Women (27,553.96) - 01-7684-00-00 Great Grant (10,519.06) - 01-7686-00-00 Cops In Schools-PISD & NLlSD (139,972.25) 60,520.00 - (60,520.00) Subtotal: (148,957.50) 200,206.15 146.18 136,960.00 (63,246.15) 01- 7713-00-00 Zoning & Subdivision Fees 200.00 1,600.00 57.14 2,800.00 1,200.00 01- 771 5-00-00 Sale of Maps Copies Etc 1,178.86 5,077 .35 84.62 6,000.00 922.65 01-7716-00-00 Tax Certificates 357.50 1,255.00 49.22 2,550.00 1 ,295.00 Subtotal: 1,736.36 7,932.35 69.89 11,350.00 3,417.65 01-7822-00-00 Lamar County Fire Contract 750.00 41.67 1,800.00 1,050.00 Subtotal: 750.00 41.67 1,800.00 1,050.00 01-7937 -00-00 Streetscape- TXDOT Grant 11,795.88 - (11,795.88) 01-7941-00-00 Tx Hist Comm Grant & Donations - 12,500.00 12,500.00 Subtotal: 11,795.88 94.37 12,500.00 704.12 01-8046-00-00 Sanitation Fees 546,590.93 41.25 1,325,000.00 778,409.07 01-8047-00-00 Brush Pickup Fee 2,489.00 27.66 9,000.00 6,511.00 Subtotal: 549,079.93 41.16 1,334,000.00 784,920.07 01-81 53-00-00 Lamar Co-Emergency Medical SE 56,623.29 179,958.29 60.80 296,000.00 116,041.71 01-81 54-00-00 Emergency Medical Service Fees 168,999.57 971,160.93 57.56 1,687,200.00 716,039.07 March Revenues 10 4/4/2007 Revenue Comparison March, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Bud(:let Balance Subtotal: 225,622.86 1,151,119.22 58.04 1,983,200.00 832,080.78 01-8260-00-00 State Shared Revenue 21,362.89 59.34 36,000.00 14,637.11 Subtotal: 21,362.89 59.34 36,000.00 14,637.11 01-8308-00-00 Birth Certificate Fee for TWC 136.80 403.20 - (403.20) 01-8309-00-00 Birth Certificate Fees 1,535.20 6,661.40 74.85 8,900.00 2,238.60 01-8310-00-00 Death Certificate Fees 2,417.00 11,630.00 69.02 16,850.00 5,220.00 01-8311-00-00 Library Copies 197.40 1,128.54 42.59 2,650.00 1,521.46 01-8312-00-00 Library Fines & Other 1,253.55 7,455.16 29.24 25,500.00 18,044.84 01-8325-00-00 Sale of City Property - 10,000.00 10,000.00 01-8330-00-00 Materials & Labor Sold 400.17 6,052.16 55.02 11,000.00 4,947.84 01-8331-00-00 Lot Clean Up 5,346.96 106.94 5,000.00 (346.96) 01-8332-00-00 Billed Electric (18,696.76) (74.79) 25,000.00 43,696.76 01-8350-00-00 Miscellaneous Revenue 99,125.52 137,982.96 344.96 40,000.00 (97,982.96) 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 30.05 395.23 - (395.23) 01-8368-00-00 Library Card Fees 715.00 9,029.80 60.20 15,000.00 5,970.20 Subtotal: 105,810.69 167,393.65 98.53 169,900.00 2,506.35 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 200.00 2.11 9,500.00 9,300.00 01-8501-00-00 Pool Programs - 14,300.00 14,300.00 01-8502-00-00 Pool Daily Fees - 14,000.00 14,000.00 01-8503-00-00 Sports Complex 3,007.25 8,040.59 25.94 31,000.00 22,959.41 01-8504-00-00 Softball 800.00 3,010.00 8.48 35,500.00 32,490.00 01-8505-00-00 Reservations 880.00 1,805.00 82.05 2,200.00 395.00 01-8507 -00-00 Special Events 2,625.75 5,703.25 54.32 10,500.00 4,796.75 Subtotal: 7,313.00 18,758.84 16.03 117,000.00 98,241.16 Program number: 828,812.07 13,196,783.81 68.26 19,334,400.00 6,137,616.19 Department number 828,812.07 13,196,783.81 68.26 19,334,400.00 6,137,616.19 Fund number: 1 General Fund 828,812.07 13,196,783.81 68.26 19,334,400.00 6,137,616.19 02-7111-00-00 Economic Development Sales Ta 77 ,196.42 534,717.17 55.13 970,000.00 435,282.83 Subtotal: 77,196.42 534,717.17 55.13 970,000.00 435,282.83 02-7650-00-00 Interest Earned 400.09 13,947.99 278.96 5,000.00 (8,947.99) March Revenues 11 4/4/2007 Revenue Comparison 1 March, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Subtotal: 400.09 13,947.99 278.96 5,000.00 (8,947.99) 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 192,000.00 50.00 384,000.00 192,000.00 Subtotal: 32,000.00 192,000.00 50.00 384,000.00 192,000.00 Program number: 109,596.51 740,665.16 54.50 1,359,000.00 618,334.84 Department number Revenues 109,596.51 740,665.16 54.50 1,359,000.00 618,334.84 Fund number: 2 Economic Development Fund 109,596.51 740,665.16 54.50 1,359,000.00 618,334.84 1 0-7010-00-00 Sewer CharQes 394,739.96 2,329,518.44 50.64 4,600,000.00 2,270,481.56 10-7011-00-00 Industrial Surcharges 8,523.76 63,752.58 42.50 150,000.00 86,247.42 10-7020-00-00 Sewer Taps 1,020.00 3,475.00 24.82 14,000.00 10,525.00 10-7022-00-00 Pro Rata Sewer Line Extension 3,870.61 17,947.38 JU! ;;:1 ifH!i 1,000.00 (16,947.38) Subtotal: 408,154.33 2,414,693.40 50.68 4,765,000.00 2,350,306.60 1 0- 7130-00-00 Water Sales 490,021.51 3,585,056.90 53.51 6,700,000.00 3,114,943.10 1 0- 7140-00-00 Water Taps 1,750.00 6,550.00 32.75 20,000.00 13,450.00 10-7142-00-00 Pro Rata Water Line Extension 25.77 154.62 6.14 2,520.00 2,365.38 Subtotal: 491,797.28 3,591,761.52 53.43 6,722,520.00 3,130,758.48 10-7650-00-00 Interest Earned 17,569.61 64,030.02 51.22 125,000.00 60,969.98 Subtotal: 17,569.61 64,030.02 51.22 125,000.00 60,969.98 10-8350-00-00 Miscellaneous W &S 9,526.40 43,447.28 62.07 70,000.00 26,552.72 10-8352-00-00 Sanitation BillinQ Fee 114,938.81 143,706.77 205.30 70,000.00 (73,706.77) 10-8354-00-00 Service Charges 6,925.40 30,579.06 47.05 65,000.00 34,420.94 10-8355-00-00 Brush Pickup Fees 220.00 351.00 7.02 5,000.00 4,649.00 1 0-8356-00-00 Bulk Water Sales 728.53 2,320.37 23.20 10,000.00 7,679.63 10-8357 -00-00 Sewer Dumping Fees 10,475.46 30,292.82 86.55 35,000.00 4,707.18 10-8358-00-00 W &S Charge Ofts (11,815.38) (57,648.24) 67.82 (85,000.00) (27,351.76) 10-8359-00-00 W&S Returned Check Fees 660.00 3,855.00 55.07 7,000.00 3,145.00 1 0-8360-00-00 W &S Copies 7.08 26.98 89.93 30.00 3.02 1 0-8366-00-00 Credit Card Convenience Fee 420.37 1,526.37 117.41 1,300.00 (226.37) 10-8367 -00-00 Deposits Billed (25.00) 275.00 - (275.00) Subtotal: 132,061.67 198,732.41 111 .44 178,330.00 (20,402.41 ) Program number: 1,049,582.89 6,269,217.35 53.17 11,790,850.00 5,521,632.65 Department number Revenues 1,049,582.89 6,269,217.35 53.17 11,790,850.00 5,521,632.65 Fund number: 10 Water & Sewer Fund 1,049,582.89 6,269,217.35 53.17 11,790,850.00 5,521,632.65 11-7650-00-00 Interest Earned 147.16 745.87 - (745.87) Subtotal: 147.16 745.87 - (745.87) March Revenues 12 4/4/2007 Revenue Comparison -1 March, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Program number: 147.16 745.87 - (745.87) Department number 147.16 745.87 - (745.87) Fund number: 11 Capital Projects Fund 147.16 745.87 - (745.87) 12-7650-00-00 Interest Earned 3,860.74 19,694.46 - (19,694.46) Subtotal: 3,860.74 19,694.46 - (19,694.46) Program number: 3,860.74 19,694.46 - (19,694.46) Department number 3,860.74 19,694.46 - (19,694.46) Fund number: 12 WW &SS Rev Bond 2000 Const F 3,860.74 19,694.46 - (19,694.46) 20-7002-00-00 Municipal Court Tech Fee 1,202.29 6,178.19 47.53 13,000.00 6,821.81 20-7003-00-00 Court Security Fee 911.51 4,712.70 47.13 10,000.00 5,287.30 20-7004-00-00 Child Safety Fee 25.00 467.65 46.77 1,000.00 532.35 20-7005-00-00 Time Payment Fee 195.24 1,189.98 46.67 2,550.00 1,360.02 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: 2,334.04 14,804.01 46.92 31,550.00 16,745.99 20-7650-00-00 Interest Earned 106.13 563.71 - (563.71 ) Subtotal: 106.13 563.71 - (563.71 ) Program number: 2,440.17 15,367.72 48.71 31,550.00 16,182.28 Department number 2,440.17 15,367.72 48.71 31,550.00 16,182.28 Fund number: 20 Special Revenue Fund 2,440.17 15,367.72 48.71 31,550.00 16,182.28 21-7650-00-00 Interest Earned 20.85 105.66 - (105.66) Subtotal: 20.85 105.66 - (105.66) Program number: 20.85 105.66 - (105.66) Department number 20.85 105.66 - (105.66) Fund number: 21 Child Safety Fund 20.85 105.66 - (105.66) 22 -81 51-00-00 Local Fees 534.00 2,162.00 2.53 85,349.00 83,187.00 22-8152-00-00 ORAS 300.00 300.00 0.25 120,000.00 119,700.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 57,250.49 26.26 218,000.00 160,749.51 22-8158-00-00 State of Texas-WIC 15,586.05 170,005.24 78.46 216,685.00 46,679.76 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 1,165.00 6,169.50 205.65 3,000.00 (3,169.50) 22 -8171-00-00 ORAS Local Fees 2,850.00 25,950.00 103.80 25,000.00 (950.00) 22-8172-00-00 Immunization Grant 42.00 4,839.77 9.68 50,000.00 45,160.23 March Revenues 13 4/4/2007 Revenue Comparison March, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 22-8174-00-00 Immunization Fees 366.00 20,734.50 103.67 20,000.00 (734.50) 22-8175-00-00 Prenatal Care Grant 115.00 0.58 20,000.00 19,885.00 22-8176-00-00 Prenatal Care Fees 105.00 705.00 - (705.00) 22-8177-00-00 Family Planning Grant 70.00 0.65 10,781.00 10,711.00 Subtotal: 20,948.05 440,679.18 45.49 968,815.00 528,135.82 Program number: 20,948.05 440,679.18 45.49 968,815.00 528,135.82 Department number 20,948.05 440,679.18 45.49 968,815.00 528,135.82 Fund number: 22 Health Department Fund 20,948.05 440,679.18 45.49 968,815.00 528,135.82 25-7001-00-00 Paris ISD School Officers 127,201.33 127,201.33 84.25 150,973.00 23,771.67 25-7002-00-00 No. Lamar ISD School Officers 88,750.06 88,750.06 59.00 150,425.00 61,674.94 25-7003-00-00 Violent Crimes Against Women 27,553.96 27,553.96 34.44 80,000.00 52,446.04 25-7004-00-00 Auto Theft Task Force 29,435.89 29,435.89 29.94 98,326.00 68,890.11 25-7005-00-00 Gang Resistance Ed.& Training 10,519.06 10,519.06 25.63 41,040.00 30,520.94 25-7006-00-00 Justice Assistance Grant - 25,158.00 25,158.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: 283,460.30 283,460.30 46.63 607,855.00 324,394.70 Proaram number: 283,460.30 283,460.30 46.63 607,855.00 324,394.70 Department number Grant Fund 283,460.30 283,460.30 46.63 607,855.00 324,394.70 Fund number: 25 Grant Fund 283,460.30 283,460.30 46.63 607,855.00 324,394.70 26-7651-00-00 Program Income 101,811.28 137,947.39 - (137,947.39) Subtotal: 101,811.28 137,947.39 - (137,947.39) 26-8246-00-00 City of Clarksville 44,965.00 - (44,965.00) 26-8250-00-00 State of Texas 205,327.57 - (205,327.57) Subtotal: 250,292.57 - (250,292.57) Program number: 101,811.28 388,239.96 - (388,239.96) Department number Drug Task Force Grant 101,811.28 388,239.96 - (388,239.96) Fund number: 26 Criminal Justice Div Grant Fd 101,811.28 388,239.96 - (388,239.96) 30-7650-00-00 Use of Money Property Interest 209.20 1,146.82 - (1,146.82) Subtotal: 209.20 1,146.82 - (1,146.82) 30-7855-00-00 ORCA Owner Occupied Rehab - 5,980.00 5,980.00 30-7857 -00-00 Home Buver Assistance Program - 244,500.00 244,500.00 30-7858-00-00 Revolving Loan Fund - 102,500.00 102,500.00 March Revenues 14 4/4/2007 Revenue Comparison March, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected BudQet Balance Subtotal: - 352,980.00 352,980.00 Program number: 209.20 1,146.82 0.33 352,980.00 351,833.18 Department number 209.20 1,146.82 0.33 352,980.00 351,833.18 Fund number: 30 Community Dvl Block Grant Fund 209.20 1,146.82 0.33 352,980.00 351,833.18 41-7650-00-00 Interest Earned 796.65 9,132.75 - (9,132.75) Subtotal: 796.65 9,132.75 - (9,132.75) ProQram number: 796.65 9,132.75 - (9,132.75) Department number 796.65 9,132.75 - (9,132.75) Fund number: 41 Tax & Rev CO 2000 Const Fund 796.65 9,132.75 - (9,132.75) 42-7650-00-00 Interest Earned 1,856.55 22,669.25 - (22,669.25) 42-7652-00-00 Forfeited Funds 10,502.00 - (10,502.00) Subtotal: 1,856.55 33,171.25 - (33,171.25) Program number: 1,856.55 33,171.25 - (33,171.25) Department number 1,856.55 33,171.25 - (33,171.25) Fund number: 42 CO Series 2002 Construction Fd 1,856.55 33,171.25 - (33,171.25) 50-7650-00-00 Use of Money Property Interest (332.30) 26,551.13 - (26,551.13) Subtotal: (332.30) 26,551.13 - (26,551.13) Program number: (332.30) 26,551.13 - (26,551.13) Department number (332.30) 26,551.13 - (26,551.13) Fund number: 50 Revenue Bonds Sinking Funds (332.30) 26,551.13 - (26,551.13) 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 51.49 460.58 - (460.58) Subtotal: 51.49 460.58 - (460.58) Program number: 51.49 460.58 0.09 510,498.76 510,038.18 Department number 51.49 460.58 0.09 510,498.76 510,038.18 Fund number: 55 Tax & Rev CO 2000 I&S Fund 51.49 460.58 0.09 510,498.76 510,038.18 56-7044-00-00 Tax & Rev COs 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 - 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 March Revenues 15 4/4/2007 Revenue Comparison March, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 58-7650-00-00 Interest Earned 961.32 2,138.57 - (2,138.57) Subtotal: 961 .32 2,138.57 - (2,138.57) Program number: 961 .32 2,138.57 0.55 391,625.00 389,486.43 Department number 961.32 2,138.57 0.55 391,625.00 389,486.43 Fund number: 58 2003 GO Refunding Bonds 961.32 2,138.57 0.55 391,625.00 389,486.43 70-8350-00-00 Claim Payment Refunds 519,020.42 876,611.38 - (876,611.38) Subtotal: 519,020.42 876,611.38 - (876,611.38) Program number: 519,020.42 876,611.38 - (876,611.38) Department number 519,020.42 876,611.38 - (876,611.38) Fund number: 70 Employees Insurance Fund 519,020.42 876,611.38 - (876,611.38) 72-7650-00-00 Interest Earned 127.24 635.84 - (635.84) Subtotal: 127.24 635.84 - (635.84) 72-8313-00-00 Memorial Donations 480.00 2,839.95 - (2,839.95) Subtotal: 480.00 2,839.95 - (2,839.95) Program number: 607.24 3,475.79 - (3,475.79) Department number 607.24 3,475.79 - (3,475.79) Fund number: 72 Library Memorial Fund 607.24 3,475.79 - (3,475.79) 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 201.75 973.65 - (973.65) 79-7651-00-00 Donation 6,090.20 - (6,090.20) Subtotal: 201.75 7,063.85 - (7,063.85) Program number: 201.75 7,063.85 - (7,063.85) Department number 201.75 7,063.85 - (7,063.85) Fund number: 79 Library Expendable Fund 201.75 7,063.85 - (7,063.85) 80-7650-00-00 Interest 198.15 1,004.33 - (1,004.33) Subtotal: 198.15 1,004.33 - (1,004.33) Program number: 198.15 1,004.33 - (1,004.33) Department number 198.15 1,004.33 - (1,004.33) Fund number: 80 Library Permanent Fund 198.15 1,004.33 - (1,004.33) March Revenues 16 4/4/2007 Departmental Expenditure Summary Comparison March, 2007 Current Percent Month Year Current Ytd Unexpended Fund Expended Actual Budget Actual Balance 01 City Council 26.90 4,980.90 92,950.00 25,002.46 67,947.54 01 City Manaqer 54.10 15,236.49 155,064.00 83,896.28 71,167.72 01 City Attorney 43.70 34,013.25 369,581.00 161,518.65 208,062.35 01 Municipal Court 52.47 24,858.71 204,684.00 107,395.71 97,288.29 01 City Clerk 47.09 11,164.48 117,919.00 55,532.23 62,386.77 01 Accountinq & Auditinq 53.94 37,567.11 429,069.00 231,457.29 197,611.71 01 Police 47.01 435,246.53 5,229,669.00 2,458,272.66 2,771,396.34 01 Fire 43.73 350,094.78 3,506,050.00 1,533,121.15 1,972,928.85 01 Community Development 37.75 62,784.37 652,017.00 246,130.55 405,886.45 01 Enqineerinq 45.95 48,539.58 453,399.00 208,343.32 245,055.68 01 Public Works 51.67 14,190.57 136,547.00 70,551.04 65,995.96 01 Parks,Recreation,& ROW 35.11 79,660.95 1,123,930.00 394,584.30 729,345.70 01 Sanitation 39.79 102,914.27 1,204,999.00 479,504.37 725,494.63 01 Streets & Hiqhways 35.82 125,050.76 1,969,233.00 705,383.75 1,263,849.25 01 Traffic & Public Liqhtinq 39.46 40,472.23 505,409.00 199,422.27 305,986.73 01 Garage 47.33 27,122.67 278,130.00 131,644.73 146,485.27 01 Emergency Medical Service 48.68 219,773.69 2,124,118.00 1,033,903.94 1,090,214.06 01 Cox Field Airport 19.22 14,195.93 254,592.00 48,921.05 205,670.95 01 Paris Band 0.09 20,850.00 18.24 20,831.76 01 Library 42.38 56,257.82 630,511.00 267,219.25 363,291.75 01 General Expenses 59.94 46,926.91 744,146.00 446,021.74 298,124.26 Contingency 6.66 4,223.06 302,705.00 20,151.76 282,553.24 General Fund 43.44 1,755,275.06 20,505,572.00 8,907,996.74 11,597,575.26 02 PEDC 4.41 1,570,862.00 69,201.26 1,501,660.74 Debt 39.34 141,896.26 833,138.00 327,786.91 505,351.09 Economic Development Fund 16.51 141,896.26 2,404,000.00 396,988.17 2,007,011.83 10 Warehouse 49.56 11,038.55 103,642.00 51,366.75 52,275.25 10 W & S Billinq and Collectinq 37.82 49,238.88 1,582,316.00 598,490.84 983,825.16 10 Water Production 37.87 204,600.27 2,568,133.00 972,523.56 1,595,609.44 10 Water Distribution 52.66 64,765.59 1,277,370.00 672,617.45 604,752.55 10 Sewer Maintenance 56.03 73,561.36 618,733.00 346,674.19 272,058.81 10 Waste Water Treatment 48.66 211,365.76 1,907,130.00 927,944.86 979,185.14 10 Lift Stations 37.75 33,872.23 428,965.00 161,940.20 267,024.80 Debt - 3,956,855.00 3,956,855.00 Water & Sewer Fund 29.99 648,442.64 12,443,144.00 3,731,557.85 8,711,586.15 12 Sewer Maintenance - 17,620.20 (17,620.20) WW &SS Rev Bond 2000 Con - 17,620.20 (17,620.20) 20 Municipal Court 7.99 785.46 127,987.00 10,230.22 117,756.78 20 Police Department 71.85 341.35 4,500.00 3,233.35 1,266.65 Special Revenue Fund 10.16 1,126.81 132,487.00 13,463.57 119,023.43 22 Health Department 46.81 93,919.83 875,801.00 409,942.13 465,858.87 Health Department Fund 46.81 93,919.83 875,801.00 409,942.13 465,858.87 25 Police 31.62 69,594.91 896,989.00 283,638.71 613,350.29 25 Community Developement - 622,223.00 622,223.00 Grant Fund 18.67 69,594.91 1,519,212.00 283,638.71 1,235,573.29 26 Police 0.33 130,224.00 434.00 129,790.00 Criminal Justice Div Grant Fd 0.33 130,224.00 434.00 129,790.00 30 Community Development - 7,500.00 16,200.00 (16,200.00) Community Dvl Block Grant F - 7,500.00 16,200.00 (16,200.00) March Department Expenditures 4/4/2007 ..r- Departmental Expenditure Summary Comparison March, 2007 Current Percent Month Year Current Ytd Unexpended Fund Expended Actual Budget Actual Balance 41 Citv Council - 1,220.00 46,844.01 (46,844.01 ) 41 Street Department - 1,288.00 (956.00) 956.00 Tax & Rev CO 2000 Const FL - 2,508.00 45,888.01 (45,888.01 ) 42 Police Department - 8,246.48 (8,246.48) CO Series 2002 Construction - 8,246.48 (8,246.48) 50 Debt Service 76.96 3,956,855.00 3,045,160.66 911,694.34 Revenue Bonds Sinkinq Fund 76.96 3,956,855.00 3,045,160.66 911,694.34 55 Debt Service 73.71 510,145.00 376,036.88 134,108.12 Tax & Rev CO 2000 I&S Fun( 73.71 510,145.00 376,036.88 134,108.12 56 Debt Service 75.57 439,075.00 331,824.75 107,250.25 Tax & Rev CO 2002 I&S Fun( 75.57 439,075.00 331,824.75 107,250.25 58 Debt Service - 393,785.00 393,785.00 2003 GO Refundinq Bonds - 393,785.00 393,785.00 72 Library - 19.35 429.83 (429.83) Library Memorial Fund - 19.35 429.83 (429.83) 79 March Department Expenditures 2 4/4/2007 Departmental Expenditure Summary Comparison March, 2006 Current Unexpended I Percent Month Year Current Ytd Fund Expended Actual Budget Actual Balance 01 City Council 62.33 5,854.68 488,150.00 304,259.95 183,890.05 01 City Manager 48.04 17,250.31 156,047.00 74,959.64 81,087.36 01 City Attorney 41.79 34,998.24 367,644.00 153,621.19 214,022.81 01 Municipal Court 50.62 26,462.57 194,459.00 98,440.66 96,018.34 01 City Clerk 47.77 12,255.08 116,619.00 55,709.49 60,909.51 01 Accounting & AuditinQ 48.50 32,886.41 566,384.00 274,714.66 291,669.34 01 Police 44.60 485,410.97 4,938,182.00 2,202,566.92 2,735,615.08 01 Fire 46.62 312,022.41 3,185,514.00 1,485,201.73 1,700,312.27 01 Community Development 42.07 71,584.82 607,597.00 255,614.23 351,982.77 01 EnQineering 48.87 48,325.87 438,901.00 214,504.11 224,396.89 01 Public Works 62.35 18,331.89 127,374.00 79,419.68 47,954.32 01 Parks,Recreation,& ROW 38.29 92,825.25 1,044,122.00 399,822.33 644,299.67 01 Sanitation 35.16 100,030.05 1,392,436.00 489,635.45 902,800.55 01 Streets & Highways 42.83 127,334.06 1,419,075.00 607,791.11 811,283.89 01 Traffic & Public Lighting 53.91 78,024.86 424,170.00 228,653.70 195,516.30 01 GaraQe 49.38 34,132.12 228,473.00 112,828.39 115,644.61 01 EmerQency Medical Service 47.84 209,714.58 1,957,083.00 936,214.41 1,020,868.59 01 Cox Field Airport 30.39 11,747.47 239,858.00 72,898.14 166,959.86 01 Paris Band 0.11 20,850.00 22.80 20,827.20 01 Library 49.30 61,495.56 601,777.00 296,680.19 305,096.81 Contingency - 280,982.00 280,982.00 General Fund 44.39 1,780,687.20 18,795,697.00 8,343,558.78 10,452,138.22 PEDC 14.11 33,603.86 950,983.00 134,179.57 816,803.43 02 Debt 39.99 147,290.01 833,138.00 333,180.66 499,957.34 Economic Development Fund 26.20 180,893.87 1,784,121.00 467,360.23 1,316,760.77 10 Warehouse 51.01 10,602.67 95,663.00 48,801.18 46,861.82 10 W & S Billing and CollectinQ 17.53 47,375.44 1,576,259.00 276,342.27 1,299,916.73 10 Water Production 53.76 353,668.02 2,063,489.00 1,109,257.57 954,231.43 10 Water Distribution 46.02 126,199.82 1,089,971.00 501,612.60 588,358.40 10 Sewer Maintenance 42.16 43,871.70 593,733.00 250,331.71 343,401.29 10 Waste Water Treatment 46.04 240,321.31 1,931,722.00 889,414.86 1,042,307.14 10 Lift Stations 36.37 37,283.69 368,004.00 133,832.90 234,171.10 Debt - 3,960,758.77 3,960,758.77 Water & Sewer Fund 27.48 859,322.65 11,679,599.77 3,209,593.09 8,470,006.68 12 Sewer Maintenance - 5,000.00 5,000.00 (5,000.06) WW &SS Rev Bond 2000 Con - 5,000.00 5,000.00 (5,000.00) 20 Municipal Court 6.29 1,791.01 225,867.00 14,215.54 211,651.46 20 Police Department - 18,600.00 18,600.00 Special Revenue Fund 5.82 1,791.01 244,467.00 14,215.54 230,251.46 21 EmerQency Medical Service 2.24 224.00 10,000.00 224.00 9,776.00 Child Safety Fund 2.24 224.00 10,000.00 224.00 9,776.00 22 Health Department 41.16 81,541.33 970,111.00 399,280.88 570,830.12 Health Department Fund 41.16 81,541.33 970,111.00 399,280.88 570,830.12 25 Police 46.70 58,642.81 596,743.00 278,651.18 318,091.82 25 Community Developement - 12,500.00 12,500.00 Grant Fund 45.74 58,642.81 609,243.00 278,651.18 330,591.82 26 Police 280.77 75,732.76 130,224.00 365,635.28 (235,411 .28) Criminal Justice Div Grant Fd 280.77 75,732.76 130,224.00 365,635.28 (235,411.28) 30 Community Development 18.38 381,980.00 70,200.00 311,780.00 March Department Expenditures 3 4/4/2007 -~.,.. '...,....----..... .~- Departmental Expenditure Summary Comparison March, 2006 Current Unexpended I Percent Month Year Current Ytd Fund Expended Actual Budget Actual Balance Community Dvl Block Grant F 18.38 381,980.00 70,200.00 311,780.00 41 City Council - 2,000.00 59,209.30 (59,209.30) 41 Parks Department - (1,950.00) 1,950.00 41 Street Department - 43,349.00 858,883.37 (858,883.37) Tax & Rev CO 2000 Const Fu - 45,349.00 916,142.67 (916,142.67) 42 City Council - 10,208.85 (10,208.85 42 Police Department - 254,462.34 2,520,135.28 (2,520,135.28 CO Series 2002 Construction - 254,462.34 2,530,344.13 (2,530,344.13 50 Debt Service 76.18 3,960,758.77 3,017,196.91 943,561.86 Revenue Bonds Sinking Fund 76.18 3,960,758.77 3,017,196.91 943,561.86 55 Debt Service 72.18 510,498.76 368,461.88 142,036.88 Tax & Rev CO 2000 I&S Func 72.18 510,498.76 368,461.88 142,036.88 56 Debt Service 74.36 437,672.50 325,436.25 112,236.25 Tax & Rev CO 2002 I&S Fun( 74.36 437,672.50 325,436.25 112,236.25 58 Debt Service - 391,625.00 391,625.00 2003 GO RefundinQ Bonds - 391,625.00 391,625.00 72 Library - 176.01 441 .47 (441.47) Library Memorial Fund - 176.01 441 .47 (441.47) 79 Library - 17,874.60 (17,874.60) Library Expendable Fund - 17,874.60 (17,874.60) March Department Expenditures 4 4/4/2007 -<_.. .....,.. .