Loading...
10-C Financial Update for December 2007 CITY OF PARIS, TEXAS CITY COUNCIL AGENDA REQUEST MEETING DATE: I January 14, 2008 IZIAction 0 Discussion Dlnformation DRefer to: SUBMITTED BY: I Gene Anderson, Finance Director DESCRIPTION: Monthly financial report for December 2008. BACKGROUND INFORMATION: Financial Report with explanatory comments. FISCAL AUTHORITY: Information only. LEGAL REVIEW: MANAGER'S RECOMMENDATION: Net to Date Comparison December December Description 2007 2006 Net to Date General Fund Taxes Collected 1,256,801.82 1,161,267.22 95,534.60 Sales Tax 1,345,244.07 1,428,017.42 (82,773.35 Hotel-Motel Tax 104,565.42 102,267.67 2,297.75 Franchise Fees 752,780.63 676,025.99 76,754.64 Permits 19,984.25 13,574.92 6,409.33 Court Fines 100,239.12 79,674.20 20,564.92 Leases & Grants 31,940.21 109,710.03 (77,769.82 Fees & Copies 3,883.92 3,192.03 691.89 Lamar County Fire 450.00 450.00 - Grants & Donations 23,058.08 17,576.07 5,482.01 Sanitation Fees 330,547.38 326,981.74 3,565.64 EMS Fees 679,187.31 535,456.52 143,730.79 State Revenue 14,259.18 11,967.04 2,292.14 Miscellaneous Fees 69,684.50 71,577.71 (1,893.21 ) Summer Programs 7,385.50 10,539.59 (3,154.09) General Fund Total Revenues 4,740,011.39 4,548,278.15 191,733.24 General Fund Total Expenditures 4,885,612.60 4,250,186.79 635,425.81 Net to Date (145,601.21) 298,091.36 (443,692.57) PEDC Fund Sales Tax 269,048.80 285,603.4 7 ( 16,554.67\ Interest Earned 3,840.69 3,737.07 103.62 Loan Payments 114,000.00 96,000.00 18,000.00 PEDC Fund Total Revenues 386,889.49 385,340.54 1,548.95 PEDC Fund Total Expenditures 185,321.91 119,986.32 65,335.59 Net to Date 201,567.58 265,354.22 (63,786.64 , Water & Sewer Fund Sewer 1,208,752.12 1,256,773.82 (48,021.70) Water 1,974,686.91 1,887,085.88 87,601.03 Interest Earned 32,545.82 44,849.60 (12,303.78) Miscellaneous 116,645.32 78,153.44 38,491.88 W&S Fund Total Revenues 3,332,630.17 3,266,862.74 65,767.43 W&S Fund Total Expenditures 1,732,026.00 1,733,972.44 (1,946.44) Net to Date 1,600,604.17 1,532,890.30 67,713.87 Capital Projects Fund Interest Earned 2,316.84 661.56 1,655.28 Capital Proiects Fund Revenues 2,316.84 661.56 1,655.28 Capital Proiects Fund Expenditures 63,087.17 63,087.17 Net to Date 2,316.84 661.56 1,655.28 WW&SS Rev Bond 2000 Construction Interest Earned 156.73 19,164.93 (19,008.20) WW&SS Rev Bond 2000 Canst Revenues 156.73 19,164.93 (19,008.20) WW&SS Rev Bond 2000 Canst Fund Expenditure 40,788.70 17,620.20 23,168.50 Net to Date (40,631.97f 1,544.73 (42,176.70) December Net to Date.xls 1/8/2008 I T Net to Date Comparison December December Description 2007 2006 Net to Date S~ecial Funds Special Funds 32,687.04 8,632.52 24,054.52 Interest Earned 81.81 144.49 (62.681 Special Revenue Funds Revenue 32,768.85 8,777.01 23,991.84 Special Revenue Funds Expenditures 24,350.66 12,075.23 12,275.43 Net to Date 8,418.19 13,298.22) 11,716.41 Child Safety Fund Interest Earned 2.61 (2.61 Child Safety Fund Revenues - 2.61 (2.61 Child Safety Fund Expenditures - Net to Date - 2.61 (2.61 Health Department Fees & Grants 160,886.24 251,226.07 (90,339.83 Health Department Fund Revenues 160,886.24 251,226.07 (90,339.83) Health Department Fund Expenditures 212,547.60 206,706.84 5,840.76 Net to Date (51,661.36) 44,519.23 (96,180.59\ Grant Fund Grants 231,260.23 163,360.60 67,899.63 Interest Earned 619.47 (619.47) - Grant Fund Revenues 231,260.23 163,980.07 67,280.16 Grant Fund Expenditures 148,794.07 115,905.95 32,888.12 Net to Date 82,466.16 48,074.12 34,392.04 Criminal Justice Fund Interest Earned 20.55 20.55 Criminal Justice Div Grant Fd Revenues 20.55 - 20.55 Criminal Justice Div Grant Fd Expenditures - Net to Date 20.55 - 20.55 Community Development Block Grant Interest Earned 286.62 550.03 (263.41 ) Grants 37,500.00 (37,500.00) Community Dvl Block Grant Fd Revenues 286.62 38,050.03 (37,763.41 Community Dvl Block Grant Fd Expenditures 7,500.00 (7,500.00 Net to Date 286.62 30,550.03 (30,263.41 Tax & Rev CO 2000 Canst Fund Interest Earned 354.42 1,583.91 (1,229.49) Grants (11,795.88) 11,795.88 Tax & Rev CO 2000 Canst Fund Revenues 354.42 (10,211.97) 10,566.39 Tax & Rev CO 2000 Canst Fund Expenditures 210.00 16,107.56 (15,897.56) Net to Date 144.42 (26,319.53 ) 26,463.95 December Net to Date.xls 2 1/3/2008 Net to Date Comparison December December Description 2007 2006 Net to Date CO Series 2002 Construction Fd Interest Earned 5.32 52.06 (46.74 CO Series 2002 Construction Fd Revenues 5.32 52.06 (46.74) CO Series 2002 Construction Fd Expenditures 8,246.48 (8,246.48) Net to Date 5.32 (8,194.42' 8,199.74 Revenue Bonds Sinking Funds Transfer to GO Refunding 2003 51,000.00 195,000.00 (144,000.00) Interest Earned 15,500.00 13,995.90 1,504.10 Revenue Bonds Sinking Funds Revenues 66,500.00 208,995.90 (142,495.90 Revenue Bonds Sinking Funds Expenditures 2,982,275.66 3,045,160.66 (62,885.00 Net to Date (2,915,775.66) (2,836,164.76) (79,610.90 Tax & Rev CO 2000 I&S Fund Transfer to Tax & Rev CO 2000 102,608.82 91,713.05 10,895.77 Interest Earned 173.90 352.44 (178.54\ Tax & Rev CO 2000 I&S Fund Revenues 102,782.72 92,065.49 10,717.23 Tax & Rev CO 2000 I&S Fund Expenditures 383,105.63 376,036.88 7,068.75 Net to Date (280,322.91 ) (283,971.39' 3,648.48 Tax & Rev CO 2002 I&S Fund Transfer to Tax & Rev CO 2002 82,637.42 75,068.86 7,568.56 Tax & Rev CO 2002 I&S Fund Revenues 82,637.42 75,068.86 7,568.56 Tax & Rev CO 2002 I&S Fund Expenditures 336,836.25 331,824.75 5,011.50 Net to Date (254,198.83) (256,755.89) 2,557.06 2003 GO Refunding Bonds Transfer to GO Refunding 2003 67,236.04 67,286.52 (50.48 Interest Earned 520.18 1,394.88 (874.70 2003 GO Refunding Bonds Revenues 67,756.22 68,681.40 (925.181 2003 GO Refunding Bonds Expenditures 92,000.00 92,000.00 Net to Date (24,243.78) 68,681.40 (92,925.18 Library Memorial Fund Interest Earned 261.95 656.75 (394.80) Memorial Donations 1,452.90 1,386.33 66.57 Library Memorial Fund Revenues 1,714.85 2,043.08 (328.23) Library Memorial Fund Expenditures 456.72 157.12 299.60 Net to Date 1,258.13 1,885.96 j627.83) Library Expendable Fund Interest Earned 70.31 484.17 1413.86) Donations 5,000.00 250.00 4,750.00 Library E~endable Fund Revenues 5,070.31 734.17 4,336.14 Library Expendable Fund Expenditures 31,278.50 31,278.50 Net to Date (26,208.19) 734.17 (26,942.361 December Net to Date.xls 3 1/3/2008 Net to Date Comparison December December Description 2007 2006 Net to Date Library Permanent Fund Interest Earned 1.23 890.80 (889.57) Library Permanent Fund Revenues 1.23 890.80 (889.57' Library Permanent Fund Expenditures - Net to Date 1.23 890.80 (889.57) December Net to Date.xls 4 1/3/2008 Revenue Comparison December, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7010-00-00 Current Taxes 688,623.68 1,228,677.74 19.80 6,207,127.00 4,978,449.26 01-7020-00-00 Delinquent Taxes 1,703.68 12,917.60 8.07 160,000.00 147,082.40 01-7030-00-00 Penalty & Interest 746.82 9,106.92 9.90 92,000.00 82,893.08 01-7031-00-00 Attorney Fees 509.91 6,099.56 13.56 45,000.00 38,900.44 Subtotal 691,584.09 1,256,801.82 19.32 6,504,127.00 5,247,325.18 01-7110-00-00 Municipal Sales Tax 345,367.72 1,076,195.27 24.05 4,475,000.00 3,398,804.73 01-7112-00-00 Sales Tax-Reduce Property Tax 86,341.92 269,048.80 24.05 1,118,750.00 849,701.20 Subtotal 431,709.64 1,345,244.07 24.05 5,593,750.00 4,248,505.93 01-7220-00-00 Hotel-Motel Occupancy Tax 104,565.42 24.84 421,000.00 316,434.58 Subtotal 104,565.42 24.84 421,000.00 316,434.58 01-7310-00-00 Southwestern Bell Telephone Co 48,436.52 27.68 175,000.00 126,563.48 01-7320-00-00 Atmos Gas 93,746.09 19.91 470,815.00 377,068.91 01-7330-00-00 TXU Electric 433,323.47 433,323.47 25.24 1,716,840.00 1,283,516.53 01-7340-00-00 Taxicabs 300.00 85.71 350.00 50.00 01-7350-00-00 Suddenlink Cable - 130,000.00 130,000.00 01-7360-00-00 Water Sewer Utility 29,166.66 87,499.98 25.74 340,000.00 252,500.02 01-7390-00-00 Bingo 19,454.83 32.43 60,000.00 40,545.17 01-7395-00-00 Municipal ROW Use Fee 321.06 6,206.63 22.17 28,000.00 21,793.37 01-7396-00-00 Solid Waste Street Use Fee 18,865.06 63,813.11 26.59 240,000.00 176,186.89 Subtotal 481,676.25 752,780.63 23.82 3,161,005.00 2,408,224.37 01-7410-00-00 House Moving 100.00 22.22 450.00 350.00 01- 7411-00-00 Concrete Permits 75.00 300.00 21.82 1,375.00 1,075.00 01-7412-00-00 Building Permits 12,299.75 17,034.25 34.07 50,000.00 32,965.75 01-7413-00-00 Sign Permits 50.00 500.00 15.63 3,200.00 2,700.00 01-7414-00-00 Electrical Permits 75.00 350.00 35.00 1,000.00 650.00 01-7416-00-00 Gas Inspections 200.00 400.00 14.55 2,750.00 2,350.00 01-7418-00-00 Plumbing Inspections 275.00 900.00 20.00 4,500.00 3,600.00 01-7420-00-00 Electrical Licenses 100.00 400.00 26.67 1,500.00 1,100.00 Subtotal 13,074.75 19,984.25 30.85 64,775.00 44,790.75 01-7510-00-00 Court Fines & Costs 20,979.39 84,010.33 26.25 320,000.00 235,989.67 01-7511-00-00 Defensive Driving Course 350.00 1,110.00 22.20 5,000.00 3,890.00 01-7512-00-00 Warrant Service Fees {City} 1,130.25 5,001.00 25.01 20,000.00 14,999.00 01-7513-00-00 City Traffic Fees 366.10 1,372.79 36.13 3,800.00 2,427.21 01-7514-00-00 Arrest Fees 1,156.72 4,546.78 31.36 14,500.00 9,953.22 December Revenues.xls 1/3/2008 Revenue Comparison December, 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 562.96 2,286.49 25.69 8,900.00 6,613.51 01-7517-00-00 State Judicial Fund due City 149.57 572.73 38.18 1,500.00 927.27 01-7520-00-00 Pound Fees 355.00 1,149.00 22.98 5,000.00 3,851.00 01-7521-00-00 Pound Incineration Fees 190.00 10.00 1,900.00 1,710.00 Subtotal 25,049.99 100,239.12 26.34 380,600.00 280,360.88 01-7620-00-00 Cox Field Leases-Terminal 900.00 25.00 3,600.00 2,700.00 01-7630-00-00 Cox Field Rent Hangar Storage 180.00 25.00 720.00 540.00 01-7631-00-00 Cox Field Rental T Hangars 16,674.00 30.32 55,000.00 38,326.00 01-7632-00-00 Cox Field Fuel Flowage Fee 781.01 2,005.93 25.07 8,000.00 5,994.07 01-7640-00-00 Leases & Rentals - 8,400.00 8,400.00 01-7650-00-00 Interest Earned 6,180.28 2.36 262,000.00 255,819.72 01-7651-00-00 Sudden link Cable Tower Rental 6,000.00 50.00 12,000.00 6,000.00 Subtotal 781.01 31,940.21 9.13 349,720.00 317,779.79 01-7712-00-00 Recording Legal Instruments 50.00 50.00 - (50.00) 01-7713-00-00 Zoning & Subdivision Fees 1,000.00 35.71 2,800.00 1,800.00 01-7715-00-00 Sale of Maps Copies Etc 450.44 2,266.42 30.22 7,500.00 5,233.58 01-7716-00-00 Tax Certificates 5.00 567.50 25.80 2,200.00 1,632.50 Subtotal 505.44 3,883.92 31.07 12,500.00 8,616.08 01-7822 -00-00 Lamar County Fire Contract 150.00 450.00 25.00 1,800.00 1,350.00 Subtotal 150.00 450.00 25.00 1,800.00 1,350.00 01-7937-00-00 Streetscape- TXDOT Grant 7,654.48 23,058.08 - (23,058.08) Subtotal 7,654.48 23,058.08 - (23,058.08) 01-8046-00-00 Sanitation Fees 108,949.84 325,982.63 24.60 1,325,000.00 999,017.37 01-8047-00-00 Brush Pickup Fee 2,246.75 4,564.75 114.12 4,000.00 (564.75) Subtotal 111,196.59 330,547.38 24.87 1,329,000.00 998,452.62 01-8153-00-00 Lamar Co-Emergency Medical SE 26,308.33 91,830.37 29.09 315,700.00 223,869.63 01-8154-00-00 Emergency Medical Service Fee~ 168,302.29 587,356.94 31.75 1,850,000.00 1,262,643.06 Subtotal 194,610.62 679,187.31 31.36 2,165,700.00 1,486,512.69 01-8260-00-00 State Shared Revenue 14,259.18 31.69 45,000.00 30,740.82 Subtotal 14,259.18 31.69 45,000.00 30,740.82 01-8308-00-00 Birth Certificate Fee for TWC 82.80 250.20 - (250.20) 01-8309-00-00 Birth Certificate Fees 929.20 2,807.80 16.52 17,000.00 14,192.20 01-8310-00-00 Death Certificate Fees 2,537.00 5,892.00 29.46 20,000.00 14,108.00 01-8311-00-00 Library Copies 257.05 657.06 32.85 2,000.00 1,342.94 December Revenues.xls 2 1/3/2008 Revenue Comparison December, 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,112.66 3,599.25 24.00 15,000.00 11,400.75 01-8325-00-00 Sale of City Property - 10,000.00 10,000.00 01-8330-00-00 Materials & Labor Sold 3,120.00 5,586.67 55.87 10,000.00 4,413.33 01-8331-00-00 Lot Clean Up 1,806.67 22.58 8,000.00 6,193.33 01-8332-00-00 Billed Electric (1,738.09) 300.28 - (300.28) 01-8350-00-00 Miscellaneous Revenue 2,855.94 38,373.57 85.28 45,000.00 6,626.43 01-8359-00-00 Special Projects 5.00 - (5.00) 01-8365-00-00 VCC Band Contribution 10,000.00 100.00 10,000.00 01-8366-00-00 Credit Card Convenience Fee 47.40 196.00 - (196.00) 01-8368-00-00 Library Card Fees 45.00 210.00 42.00 500.00 290.00 Subtotal 9,248.96 69,684.50 50.68 137,500.00 67,815.50 01-8499-00-00 Water & Sewer Transfer 62,500.00 187,500.00 25.00 750,000.00 562,500.00 Subtotal 62,500.00 187,500.00 25.00 750,000.00 562,500.00 01-8500-00-00 Pool Vending 145.50 1.53 9,500.00 9,354.50 01-8501-00-00 Pool Programs 400.00 2.80 14,300.00 13,900.00 01-8502-00-00 Pool Daily Fees - 14,000.00 14,000.00 01-8503-00-00 Sports Complex 1,513.95 - (1,513.95) 01-8504-00-00 Softball 1,400.00 3.94 35,500.00 34,100.00 01-8505-00-00 Reservations 410.00 18.64 2,200.00 1,790.00 01-8506-00-00 Sponsorships 200.00 - (200.00) 01-8507 -00-00 Special Events 818.05 3,316.05 31.58 10,500.00 7,183.95 Subtotal 818.05 7,385.50 8.59 86,000.00 78,614.50 Program number: 2,030,559.87 4,927,511.39 23.46 21,002,477.00 16,074,965.61 Department number 2,030,559.87 4,927,511.39 23.46 21,002,477.00 16,074,965.61 Fund number: 1 General Fund 2,030,559.87 4,927,511.39 23.46 21,002,477.00 16,074,965.61 02-7111-00-00 Economic Development Sales Ta 86,341.92 269,048.80 25.32 1,062,500.00 793,451.20 Subtotal 86,341.92 269,048.80 25.32 1,062,500.00 793,451.20 02-7650-00-00 Interest Earned 288.90 3,840.69 19.20 20,000.00 16,159.31 Subtotal 288.90 3,840.69 19.20 20,000.00 16,159.31 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 96,000.00 25.00 384,000.00 288,000.00 02-8355-00-00 Bitco Law Suit Settlement 12,000.00 - (12,000.00) 02-8358-00-00 C- Tech Settlement 6,000.00 - (6,000.00) Subtotal 32,000.00 114,000.00 29.69 384,000.00 270,000.00 Program number: 118,630.82 386,889.49 26.38 1,466,500.00 1,079,610.51 December Revenues.xls 3 1/3/2008 Revenue Comparison December, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Department number Revenues 118,630.82 386,889.49 26.38 1,466,500.00 1,079,610.51 Fund number: 2 Economic Development Fund 118,630.82 386,889.49 26.38 1,466,500.00 1,079,610.51 10-7010-00-00 Sewer Charges 377,604.92 1,158,918.54 23.82 4,865,420.00 3,706,501.46 10-7011-00-00 Industrial Surcharges 17,548.59 42,322.06 33.06 128,000.00 85,677.94 10-7020-00-00 Sewer Taps 1,020.00 2,170.00 21.70 10,000.00 7,830.00 10-7022-00-00 Pro Rata Sewer Line Extension 1,701.61 5,341.52 53.42 10,000.00 4,658.48 Subtotal 397,875.12 1,208,752.12 24.11 5,013,420.00 3,804,667.88 1 0- 7130-00-00 Water Sales 590,170.33 1,971,471.91 25.50 7,730,993.00 5,759,521.09 10-7140-00-00 Water Taps 25.00 3,215.00 16.08 20,000.00 16,785.00 Subtotal 590,195.33 1,974,686.91 25.48 7,750,993.00 5,776,306.09 10-7650-00-00 Interest Earned 6,248.22 32,545.82 27.12 120,000.00 87,454.18 Subtotal 6,248.22 32,545.82 27.12 120,000.00 87,454.18 10-8350-00-00 Miscellaneous W &S 7,272.63 46,432.28 46.43 100,000.00 53,567.72 10-8352-00-00 Sanitation Billing Fee 5,734.21 17,143.00 24.49 70,000.00 52,857.00 10-8354-00-00 Service CharQes 16,045.00 49,665.00 76.41 65,000.00 15,335.00 10-8355-00-00 Brush Pickup Fees 118.25 240.25 48.05 500.00 259.75 10-8356-00-00 Bulk Water Sales 747.77 2,277.46 45.55 5,000.00 2,722.54 10-8357 -00-00 Sewer Dumping Fees 4,073.52 11,545.88 23.09 50,000.00 38,454.12 10-8358-00-00 W &S Charge Offs (2,241.42) (14,300.52) 19.07 (75,000.00) (60,699.48) 10-8359-00-00 W&S Returned Check Fees 870.00 2,430.00 34.71 7,000.00 4,570.00 10-8360-00-00 W&S Copies 0.72 2.40 30.00 29.28 10-8366-00-00 Credit Card Convenience Fee 383.20 1,198.75 39.96 3,000.00 1,801.25 10-8367 -00-00 Deposits Billed (322.00) 12.50 - (12.50) Subtotal 32,681.16 116,645.32 51.72 225,530.00 108,884.68 Program number: 1,026,999.83 3,332,630.17 25.42 13,109,943.00 9,777,312.83 Department number Revenues 1,026,999.83 3,332,630.17 25.42 13,109,943.00 9,777,312.83 Fund number: 10 Water & Sewer Fund 1,026,999.83 3,332,630.17 25.42 13,109,943.00 9,777,312.83 11-7650-00-00 Interest Earned 2,316.84 3.71 62,500.00 60,183.16 Subtotal 2,316.84 3.71 62,500.00 60,183.16 Program number: 2,316.84 3.71 62,500.00 60,183.16 Department number 2,316.84 3.71 62,500.00 60,183.16 Fund number: 11 Capital Projects Fund 2,316.84 3.71 62,500.00 60,183.16 12-7650-00-00 Interest Earned 156.73 - (156.73) Subtotal 156.73 - (156.73) December Revenues.xls 4 1/3/2008 Revenue Comparison December, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Program number: 156.73 - (156.73) Department number 156.73 - (156.73) Fund number: 12 WW &SS Rev Bond 2000 Const F 156.73 - (156.73) 20-7002-00-00 Municipal Court Tech Fee 1,009.36 3,874.17 32.29 12,000.00 8,125.83 20-7003-00-00 Court Security Fee 758.06 2,911.40 30.65 9,500.00 6,588.60 20-7004-00-00 Child Safety Fee 85.59 496.18 82.70 600.00 103.82 20-7005-00-00 Time Payment Fee 140.74 571.36 23.81 2,400.00 1,828.64 20-7006-00-00 Conf Funds-Gambling PD Fee 2,691.98 - (2,691.98) 20-7007 -00-00 Judicial Forfeitures Fee 1,166.75 22,141.95 221 .42 10,000.00 (12,141.95) Subtotal 3,160.50 32,687.04 94.75 34,500.00 1,812.96 20-7650-00-00 Interest Earned 81.81 16.36 500.00 418.19 Subtotal 81.81 16.36 500.00 418.19 Program number: Special Revenue 3,160.50 32,768.85 93.63 35,000.00 2,231.15 Department number Special Revenue 3,160.50 32,768.85 93.63 35,000.00 2,231.15 Fund number: 20 Special Revenue Fund 3,160.50 32,768.85 93.63 35,000.00 2,231.15 22-8151-00-00 Local Fees 2,805.00 7,907.25 19.77 40,000.00 32,092.75 22-8152-00-00 ORAS - 109,998.00 109,998.00 22-8155-00-00 Lamar County - 73,523.00 73,523.00 22-8156-00-00 Primary Health Care Program 21,928.19 14.47 151,558.00 129,629.81 22-8158-00-00 State of Texas-WIC 55,241.18 86,823.95 31.35 276,939.00 190,115.05 22-8160-00-00 City of Paris - 73,522.00 73,522.00 22-8170-00-00 Primary Health Care Prog Fees 445.00 748.00 12.47 6,000.00 5,252.00 22-8171-00-00 ORAS Local Fees 3,125.00 14,050.00 41.32 34,000.00 19,950.00 22-8172-00-00 Immunization Grant 25,815.16 27.24 94,786.00 68,970.84 22-8174-00-00 Immunization Fees 1,110.00 2,714.00 18.09 15,000.00 12,286.00 22-8175-00-00 Prenatal Care Grant 680.69 3.40 20,000.00 19,319.31 22-8176-00-00 Prenatal Care Fees 28.00 219.00 10.95 2,000.00 1,781.00 Subtotal 62,754.18 160,886.24 17.93 897,326.00 736,439.76 Program number: Health Department 62,754.18 160,886.24 17.93 897,326.00 736,439.76 Department number Health Department 62,754.18 160,886.24 17.93 897,326.00 736,439.76 Fund number: 22 Health Department Fund 62,754.18 160,886.24 17.93 897,326.00 736,439.76 25-7001-00-00 Paris ISD School Officers 45,444.75 24.05 188,936.00 143,491.25 25-7002-00-00 No. Lamar ISD School Officers 45,348.00 24.02 188,771.00 143,423.00 25-7003-00-00 Violent Crimes Against Women - 94,553.00 94,553.00 December Revenues.xls 5 1/3/2008 Revenue Comparison December, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 25-7004-00-00 Auto Theft Task Force - 113,854.00 113,854.00 25-7006-00-00 Justice Assistance Grant 12,989.00 74.09 17,532.00 4,543.00 25-7008-00-00 Grant Match-Police Department 99,064.00 99,064.00 100.00 99,064.00 25-7010-00-00 Felony Crimes Unit 28,414.48 12.46 227,999.00 199,584.52 25-7011-00-00 TXDOT -Airport Development - 279,660.00 279,660.00 25-7012-00-00 Grant Match-Airport Dev. Grant - 59,000.00 59,000.00 25-7013-00-00 Texas Historical Commission - 9,000.00 9,000.00 25-7014-00-00 TX Pk & W-Recreation Trail - 100,000.00 100,000.00 25-7018-00-00 Grant Match-Fire Dept - 8,000.00 8,000.00 25-7019-00-00 FEMA - 72,000.00 72,000.00 Subtotal 99,064.00 231,260.23 15.86 1,458,369.00 1,227,108.77 Program number: 99,064.00 231,260.23 15.86 1,458,369.00 1,227,108.77 Department number Grant Fund 99,064.00 231,260.23 15.86 1,458,369.00 1.227,108.77 Fund number: 25 Grant Fund 99,064.00 231,260.23 15.86 1,458,369.00 1,227,108.77 26-7650-00-00 Interest Earned 20.55 - (20.55) Subtotal 20.55 - (20.55) Program number: 20.55 - (20.55) Department number Drug Task Force Grant 20.55 - (20.55) Fund number: 26 Criminal Justice Div Grant Fd 20.55 - (20.55) 30-7650-00-00 Use of Money Property Interest 117.88 286.62 - (286.62) Subtotal 117.88 286.62 - (286.62) Program number: 117.88 286.62 - (286.62) Department number 117.88 286.62 - (286.62) Fund number: 30 Community Dvl Block Grant Fund 117.88 286.62 - (286.62) 41-7650-00-00 Interest Earned 354.42 - (354.42) Subtotal 354.42 - (354.42) Program number: 354.42 - (354.42) Department number 354.42 - (354.42) Fund number: 41 Tax & Rev CO 2000 Const Fund 354.42 - (354.42) 42-7650-00-00 Interest Earned 5.32 - (5.32) Subtotal 5.32 - (5.32) Program number: 5.32 - (5.32) Department number 5.32 - (5.32) Fund number: 42 CO Series 2002 Construction Fd 5.32 - (5.32) December Revenues.xls 6 1/3/2008 Revenue Comparison December, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 50-1135-00-00 Transfer to GO Refunding 2003 17,000.00 51,000.00 - (51,000.00) Subtotal 17,000.00 51,000.00 - (51,000.00) 50-7650-00-00 Use of Money Property Interest 15,500.10 - (15,500.10) Subtotal 15,500.10 - (15,500.10) Program number: 17,000.00 66,500.10 - (66,500.10) Department number 17,000.00 66,500.10 - (66,500.10) Fund number: 50 Revenue Bonds Sinking Funds 17,000.00 66,500.10 - (66,500.10) 55-7043-00-00 Tax & Rev cas 2000 I&S 57,051.71 102,608.82 20.17 508,775.00 406,166.18 Subtotal 57,051.71 102,608.82 20.17 508,775.00 406,166.18 55-7650-00-00 Interest Earned 173.90 - (173.90) Subtotal 173.90 - (173.90) Program number: 57,051.71 102,782.72 20.20 508,775.00 405,992.28 Department number 57,051.71 102,782.72 20.20 508,775.00 405,992.28 Fund number: 55 Tax & Rev CO 2000 I&S Fund 57,051.71 102,782.72 20.20 508,775.00 405,992.28 56-7044-00-00 Tax & Rev cas 2002 I&S 45,947.39 82,637.42 18.78 440,075.00 357,437.58 Subtotal 45,947.39 82,637.42 18.78 440,075.00 357,437.58 Program number: 45,947.39 82,637.42 18.78 440,075.00 357,437.58 Department number Tax & Revenue 2002 45,947.39 82,637.42 18.78 440,075.00 357,437.58 Fund number: 56 Tax & Rev CO 2002 I&S Fund 45,947.39 82,637.42 18.78 440,075.00 357,437.58 58-7045-00-00 Cert. Of Oblig. 2003 f&S 37,384.02 67,236.04 16.99 395,705.00 328,468.96 Subtotal 37,384.02 67,236.04 16.99 395,705.00 328,468.96 58-7650-00-00 Interest Earned 520.18 - (520.18) Subtotal 520.18 - (520.18) Program number: 37,384.02 67,756.22 17.12 395,705.00 327,948.78 Department number NON-departmental 37,384.02 67,756.22 17.12 395,705.00 327,948.78 Fund number: 58 2003 GO Refunding Bonds 37,384.02 67,756.22 17.12 395,705.00 327,948.78 72-7650-00-00 Interest Earned 261.95 - (261.95) Subtotal 261.95 - (261.95) 72-8313-00-00 Memorial Donations 560.00 1,452.90 - (1,452.90) Subtotal 560.00 1,452.90 - (1,452.90) Program number: 560.00 1,714.85 - (1,714.85) Department number 560.00 1,714.85 - (1,714.85) Fund number: 72 Library Memorial Fund 560.00 1,714.85 - (1,714.85) 79-7650-00-00 Interest 70.31 - (70.31) December Revenues.xls 7 1/3/2008 Revenue Comparison December, 2007 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 79-7651-00-00 Donation 5,000.00 - (5,000.00) Subtotal 5,070.31 - (5,070.31 ) Program number: 5,070.31 - (5,070.31) Department number 5,070.31 - (5,070.31) Fund number: 79 Library Expendable Fund 5,070.31 - (5,070.31) 80-7650-00-00 Interest 1.23 - (1.23 ) Subtotal 1.23 - (1.23 ) Program number: 1.23 - (1.23) Department number 1.23 - (1.23) Fund number: 80 Library Permanent Fund 1.23 - (1.23 ) December Revenues.xls 8 1/3/2008 Revenue Comparison December, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-7010-00-00 Current Taxes 506,853.11 1,108,966.77 17.85 6,214,245.00 5,105,278.23 01-7020-00-00 Delinquent Taxes 3,158.47 30,055.71 18.79 160,000.00 129,944.29 01-7030-00-00 Penalty & Interest 2,102.63 12,478.00 12.48 100,000.00 87,522.00 01-7031-00-00 Attorney Fees 1,523.62 9,766.74 24.42 40,000.00 30,233.26 Subtotal: 513,637.83 1,161,267.22 17.83 6,514,245.00 5,352,977.78 01-7110-00-00 Municipal Sales Tax 342,988.03 1,142,413.95 26.88 4,250,000.00 3,107,586.05 01-7112-00-00 Sales Tax-Reduce Property Tax 85,747.00 285,603.47 26.87 1,063,000.00 777,396.53 Subtotal: 428,735.03 1,428,017.42 26.88 5,313,000.00 3,884,982.58 01-7220-00-00 Hotel-Motel Occupancy Tax 102,267.67 31.47 325,000.00 222,732.33 Subtotal: 102,267.67 31.47 325,000.00 222,732.33 01-7310-00-00 Southwestern Bell Telephone Co 45,058.81 27.31 165,000.00 119,941.19 01-7320-00-00 Atmos Gas 81,508.22 12.54 650,000.00 568,491.78 01-7330-00-00 TXU Electric 454,593.18 457,470.45 27.64 1,655,000.00 1,197,529.55 01-7340-00-00 Taxicabs 350.00 350.00 116.67 300.00 (50.00) 01-7350-00-00 TCA Cable - 130,000.00 130,000.00 01-7360-00-00 Water Sewer Utility - 340,000.00 340,000.00 01-7390-00-00 Bingo 15,487.36 25.81 60,000.00 44,512.64 01-7395-00-00 Municipal ROW Use Fee 57.75 7,119.88 20.34 35,000.00 27,880.12 01-7396-00-00 Solid Waste Street Use Fee 17,682.59 69,031.27 30.68 225,000.00 155,968.73 Subtotal: 472,683.52 676,025.99 20.74 3,260,300.00 2,584,274.01 01-7410-00-00 House Moving - 450.00 450.00 01- 7411-00-00 Concrete Permits 75.00 250.00 18.18 1,375.00 1,125.00 01-7412-00-00 Building Permits 2,492.00 10,546.92 17.58 60,000.00 49,453.08 01-7413-00-00 Sign Permits 225.00 665.00 13.30 5,000.00 4,335.00 01-7414-00-00 Electrical Permits 75.00 100.00 12.50 800.00 700.00 01-7416-00-00 Gas Inspections 475.00 875.00 21.88 4,000.00 3,125.00 01-7418-00-00 Plumbing Inspections 325.00 950.00 21.11 4,500.00 3,550.00 01-7420-00-00 Electrical Licenses 55.00 188.00 1 0.44 1,800.00 1,612.00 Subtotal: 3,722.00 13,574.92 17.42 77,925.00 64,350.08 01-7510-00-00 Court Fines & Costs 19,975.94 65,868.72 20.58 320,000.00 254,131.28 01-7511-00-00 Defensive Driving Course 280.00 910.00 28.44 3,200.00 2,290.00 01-7512-00-00 Warrant Service Fees {City} 865.52 4,827.05 13.79 35,000.00 30,172.95 01-7513-00-00 City Traffic Fees 269.44 853.97 22.4 7 3,800.00 2,946.03 01-7514-00-00 Arrest Fees 1,013.17 3,269.62 22.55 14,500.00 11,230.38 December Revenues.xls 9 1/3/2008 Revenue Comparison December, 2006 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 599.35 1,963.95 22.07 8,900.00 6,936.05 01-7517-00-00 State Judicial Fund due City 119.02 380.89 76.18 500.00 119.11 01- 7 520-00-00 Pound Fees 800.00 1,100.00 25.29 4,350.00 3,250.00 01-7521-00-00 Pound Incineration Fees 500.00 38.46 1,300.00 800.00 Subtotal: 23,922.44 79,674.20 20.35 391,550.00 311,875.80 01-7620-00-00 Cox Field Leases-Terminal 300.00 900.00 25.00 3,600.00 2,700.00 01-7630-00-00 Cox Field Rent Hangar Storage 60.00 180.00 25.00 720.00 540.00 01-7631-00-00 Cox Field Rental T Hangars 5,224.00 15,547.00 28.27 55,000.00 39,453.00 01-7632-00-00 Cox Field Fuel Flowage Fee 771.75 2,181.00 27.26 8,000.00 5,819.00 01-7640-00-00 Leases & Rentals - 8,400.00 8,400.00 01-7650-00-00 Interest Earned 36,208.65 79,106.15 87.90 90,000.00 10,893.85 01-7672-00-00 Auto Theft Prevention Grant 11,795.88 - (11,795.88) Subtotal: 42,564.40 109,710.03 66.20 165,720.00 56,009.97 01-7713-00-00 Zoning & Subdivision Fees 200.00 425.00 15.18 2,800.00 2,375.00 01-7715-00-00 Sale of Maps Copies Etc 877.10 2,254.53 30.06 7,500.00 5,245.47 01-7716-00-00 Tax Certificates 117.50 512.50 20.10 2,550.00 2,037.50 Subtotal: 1,194.60 3,192.03 24.84 12,850.00 9,657.97 01-7822-00-00 Lamar County Fire Contract 150.00 450.00 25.00 1,800.00 1,350.00 Subtotal: 150.00 450.00 25.00 1,800.00 1,350.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 133,827.94 326,353.79 24.63 1,325,000.00 998,646.21 01-8047-00-00 Brush Pickup Fee 142.50 627.95 8.37 7,500.00 6,872.05 Subtotal: 133,970.44 326,981.74 24.54 1,332,500.00 1,005,518.26 01-8153-00-00 Lamar Co-Emergency Medical Se 25,666.67 77,000.01 24.84 310,000.00 232,999.99 01-81 54-00-00 Emergency Medical Service Fees 100,068.99 458,456.51 25.50 1,798,000.00 1,339,543.49 Subtotal: 125,735.66 535,456.52 25.40 2,108,000.00 1,572,543.48 01-8260-00-00 State Shared Revenue 11,967.04 29.92 40,000.00 28,032.96 Subtotal: 11,967.04 29.92 40,000.00 28,032.96 01-8308-00-00 Birth Certificate Fee for TWC 133.20 324.00 - (324.00) 01-8309-00-00 Birth Certificate Fees 1,494.80 3,636.00 25.08 14,500.00 10,864.00 01-8310-00-00 Death Certificate Fees 2,794.00 5,744.00 28.72 20,000.00 14,256.00 01-8311-00-00 Library Copies 156.80 474.40 23.72 2,000.00 1,525.60 01-8312 -00-00 Library Fines & Other 784.47 2,993.05 19.95 15,000.00 12,006.95 December Revenues.xls 10 1/3/2008 Revenue Comparison -; December, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 01-8314-00-00 Loan Star Libraries Grant 4,081.00 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 1,161.85 3,392.77 30.84 11,000.00 7,607.23 01-8331-00-00 Lot Clean Up 864.78 10.81 8,000.00 7,135.22 01-8332-00-00 Billed Electric (1,325.72) (1,325.72) - 1,325.72 01-8350-00-00 Miscellaneous Revenue 7,274.77 41,024.43 102.56 40,000.00 (1,024.43) 01-8365-00-00 VCC Band Contribution 10,000.00 100.00 10,000.00 01-8366-00-00 Credit Card Convenience Fee 64.30 189.00 - (189.00) 01-8368-00-00 Library Card Fees 50.00 180.00 3.60 5,000.00 4,820.00 Subtotal: 16,669.47 71,577.71 52.83 135,500.00 63,922.29 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 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 403.89 3,723.59 - (3,723.59) 01-8504-00-00 Softball 1,200.00 3,350.00 9.44 35,500.00 32,150.00 01-8505-00-00 Reservations 20.00 235.00 10.68 2,200.00 1 ,965.00 01-8506-00-00 Sponsorships 1,800.00 - (1,800.00) 01-8507 -00-00 Special Events 498.00 1,279.00 12.18 10,500.00 9,221.00 Subtotal: 2,121.89 10,539.59 12.26 86,000.00 75,460.41 Program number: 1,765,107.28 4,548,278.15 22.17 20,514,390.00 15,966,111.85 Department number 1,765,107.28 4,548,278.15 22.17 20,514,390.00 15,966,111.85 Fund number: 1 General Fund 1,765,107.28 4,548,278.15 22.17 20,514,390.00 15,966,111.85 02-7111-00-00 Economic Development Sales Ta 85,747.00 285,603.47 28.56 1,000,000.00 714,396.53 Subtotal: 85,747.00 285,603.47 28.56 1,000,000.00 714,396.53 02-7650-00-00 Interest Earned 491.60 3,737.07 18.69 20,000.00 16,262.93 Subtotal: 491.60 3,737.07 18.69 20,000.00 16,262.93 02-8351-00-00 Loan Payment Paris Packaging 32,000.00 96,000.00 25.00 384,000.00 288,000.00 Subtotal: 32,000.00 96,000.00 25.00 384,000.00 288,000.00 Program number: 118,238.60 385,340.54 27.45 1,404,000.00 1,018,659.46 Department number Revenues 118,238.60 385,340.54 27.45 1,404,000.00 1,018,659.46 Fund number: 2 Economic Development Fund 118,238.60 385,340.54 27.45 1,404,000.00 1,018,659.46 1 0- 7 01 0-00-00 Sewer Charges 503,889.08 1,221,451.44 25.85 4,725,000.00 3,503,548.56 1 December Revenues.xls 11 1/3/2008 Revenue Comparison 1 December, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 10-7011-00-00 Industrial Surcharges 7,639.39 27,701.07 19.79 140,000.00 112,298.93 10-7020-00-00 Sewer Taps 560.00 5.60 10,000.00 9,440.00 10-7022-00-00 Pro Rata Sewer Line Extension 2,179.83 7,061.31 706.13 1,000.00 (6,061.31 ) Subtotal: 513,708.30 1,256,773.82 25.78 4,876,000.00 3,619,226.18 10-7130-00-00 Water Sales 657,971.27 1,883,935.88 26.06 7,230,000.00 5,346,064.12 10-7140-00-00 Water Taps 1,600.00 3,150.00 15.75 20,000.00 16,850.00 10-7142-00-00 Pro Rata Water Line Extension - 2,520.00 2,520.00 Subtotal: 659,571.27 1,887,085.88 26.02 7,252,520.00 5,365,434.12 10-7650-00-00 Interest Earned (123.75) 44,849.60 37.38 120,000.00 75,150.40 Subtotal: (123.75) 44,849.60 37.38 120,000.00 75,150.40 10-8350-00-00 Miscellaneous W &S 7,912.76 42,810.13 53.51 80,000.00 37,189.87 10-8352-00-00 Sanitation Billing Fee 7,043.58 17,176.53 24.54 70,000.00 52,823.47 10-8354-00-00 Service Charges 5,045.00 13,375.00 20.58 65,000.00 51,625.00 10-8355-00-00 Brush Pickup Fees 7.50 33.05 3.31 1,000.00 966.95 10-8356-00-00 Bulk Water Sales 1,489.87 2,690.05 53.80 5,000.00 2,309.95 10-8357 -00-00 Sewer Dumping Fees 3,350.83 12,370.23 24.74 50,000.00 37,629.77 10-8358-00-00 W &S Charge Ofts (4,869.55) (13,342.24) 15.70 (85,000.00) (71,657.76) 10-8359-00-00 W &S Returned Check Fees 630.00 2,070.00 29.57 7,000.00 4,930.00 1 0-8360-00-00 W &S Copies 1.34 5.90 19.67 30.00 24.10 1 0-8366-00-00 Credit Card Convenience Fee 177.05 566.00 28.30 2,000.00 1,434.00 10-8367 -00-00 Deposits Billed 323.79 398.79 - (398.79) Subtotal: 21,112.17 78,153.44 40.07 195,030.00 116,876.56 Program number: 1,194,267.99 3,266,862.74 26.25 12,443,550.00 9,176,687.26 Department number Revenues 1,194,267.99 3,266,862.74 26.25 12,443,550.00 9,176,687.26 Fund number: 10 Water & Sewer Fund 1,194,267.99 3,266,862.74 26.25 12,443,550.00 9,176,687.26 11-7650-00-00 Interest Earned 295.53 661.56 33.08 2,000.00 1,338.44 Subtotal: 295.53 661.56 33.08 2,000.00 1,338.44 Program number: 295.53 661.56 33.08 2,000.00 1 ,338.44 Department number 295.53 661.56 33.08 2,000.00 1,338.44 Fund number: 11 Capital Projects Fund 295.53 661.56 33.08 2,000.00 1,338.44 12-7650-00-00 Interest Earned 7,648.42 19,164.93 - (19,164.93) Subtotal: 7,648.42 19,164.93 - (19,164.93) Program number: 7,648.42 19,164.93 - (19,164.93) Department number 7,648.42 19,164.93 - (19,164.93) December Revenues.xls 12 1/3/2008 Revenue Comparison December, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Fund number: 12 WW &SS Rev Bond 2000 Const F 7,648.42 19,164.93 - (19,164.93) 20-7002-00-00 Municipal Court Tech Fee 835.91 2,729.80 22.75 12,000.00 9,270.20 20-7003-00-00 Court Security Fee 625.41 2,050.82 21.59 9,500.00 7,449.18 20-7004-00-00 Child Safety Fee 145.77 14.58 1,000.00 854.23 20-7005-00-00 Time Payment Fee 150.01 487.83 20.33 2,400.00 1,912.17 20-7007 -00-00 Judicial Forfeitures Fee 261.60 3,218.30 214.55 1,500.00 (1,718.30) Subtotal: 1,872.93 8,632.52 32.70 26,400.00 17,767.48 20-7650-00-00 Interest Earned 72.56 144.49 28.90 500.00 355.51 Subtotal: 72.56 144.49 28.90 500.00 355.51 Program number: Special Revenue 1,945.49 8,777.01 32.63 26,900.00 18,122.99 Department number Special Revenue 1,945.49 8,777.01 32.63 26,900.00 18,122.99 Fund number: 20 Special Revenue Fund 1,945.49 8,777.01 32.63 26,900.00 18,122.99 21-7650-00-00 Interest Earned 1.17 2.61 - (2.61 ) Subtotal: 1.17 2.61 - (2.61 ) Program number: Think Child Safety 1.17 2.61 - (2.61 ) Department number Child Safety Fund 1.17 2.61 - (2.61) Fund number: 21 Child Safety Fund 1.17 2.61 - (2.61 ) 22 -81 51-00-00 Local Fees 1,922.50 17,038.75 35.52 47,973.00 30,934.25 22-8152-00-00 ORAS - 109,998.00 109,998.00 22-8155-00-00 Lamar County 36,605.08 48.81 75,000.00 38,394.92 22-8156-00-00 Primary Health Care Program 22,106.83 37,633.88 24.83 151,558.00 113,924.12 22-8158-00-00 State of Texas-WIC 51,768.70 79,203.50 27.86 284,249.00 205,045.50 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 137.00 1,000.00 8.33 12,000.00 11,000.00 22-8171-00-00 ORAS Local Fees 1,475.00 9,750.00 39.00 25,000.00 15,250.00 22-8172-00-00 Immunization Grant 21,781.54 43.54 50,023.00 28,241.46 22 -81 74-00-00 Immunization Fees 398.00 2,996.00 11.98 25,000.00 22,004.00 22-8175-00-00 Prenatal Care Grant 7,768.37 38.84 20,000.00 12,231.63 22-8176-00-00 Prenatal Care Fees 161.50 843.88 - (843.88) Subtotal: 77,969.53 251,226.07 28.69 875,801.00 624,574.93 Program number: Health Department 77,969.53 251,226.07 28.69 875,801.00 624,574.93 Department number Health Department 77,969.53 251,226.07 28.69 875,801.00 624,574.93 Fund number: 22 Health Department Fund 77,969.53 251,226.07 28.69 875,801.00 624,574.93 25-7001-00-00 Paris ISO School Officers 15,148.25 47,868.25 26.33 181,779.00 133,910.75 December Revenues.xls 13 1/3/2008 Revenue Comparison December, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance 25-7002-00-00 No. Lamar ISD School Officers 15,116.00 47,785.42 26.34 181,392.00 133,606.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 21,390.55 21.76 98,326.00 76,935.45 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 163,360.60 10.75 1,519,212.00 1,355,851.40 25-7650-00-00 Interest Earned 409.25 619.47 - (619.47) Subtotal: 409.25 619.47 - (619.47) Program number: 30,673.50 163,980.07 10.79 1,519,212.00 1,355,231.93 Department number Grant Fund 30,673.50 163,980.07 10.79 1,519,212.00 1,355,231.93 Fund number: 25 Grant Fund 30,673.50 163,980.07 10.79 1,519,212.00 1 ,355,231.93 30-7650-00-00 Use of Money Propertv Interest 208.59 550.03 - (550.03) Subtotal: 208.59 550.03 - (550.03) 30-7856-00-00 Owner Occupied Rehab 37,500.00 - (37,500.00) Subtotal: 37,500.00 - (37,500.00) Program number: 208.59 38,050.03 - (38,050.03) Department number 208.59 38,050.03 - (38,050.03) Fund number: 30 Community Dvl Block Grant Fund 208.59 38,050.03 - (38,050.03) 41-7650-00-00 Interest Earned 703.31 1,583.91 - (1,583.91 ) Subtotal: 703.31 1,583.91 - (1,583.91 ) 41-8303-00-00 Streetscape TxDot Reimburse (11,795.88) - 11,795.88 Subtotal: (11,795.88) - 11,795.88 Program number: 703.31 (10,211.97) - 10,211.97 Department number 703.31 (10,211.97) - 10,211.97 Fund number: 41 Tax & Rev CO 2000 Canst Fund 703.31 (10,211.97) - 10,211.97 42-7650-00-00 Interest Earned 6.20 52.06 - (52.06) Subtotal: 6.20 52.06 - (52.06) Program number: 6.20 52.06 - (52.06) Department number 6.20 52.06 - (52.06) Fund number: 42 CO Series 2002 Construction Fd 6.20 52.06 - (52.06) 50-1135-00-00 Transfer to GO Refunding 2003 65,000.00 195,000.00 - (195,000.00) December Revenues.xls 14 1/3/2008 Revenue Comparison December, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Subtotal: 65,000.00 195,000.00 - (195,000.00) 50-7650-00-00 Use of Money Property Interest 614.49 13,995.90 - (13,995.90) Subtotal: 614.49 13,995.90 - (13,995.90) Program number: 65,614.49 208,995.90 - (208,995.90) Department number 65,614.49 208,995.90 - (208,995.90) Fund number: 50 Revenue Bonds Sinking Funds 65,614.49 208,995.90 - (208,995.90) 55-7043-00-00 Tax & Rev COs 2000 I&S 43,513.43 91,713.05 17.98 510,145.00 418,431.95 Subtotal: 43,513.43 91,713.05 17.98 510,145.00 418,431.95 55-7650-00-00 Interest Earned 180.13 352.44 - (352.44 ) Subtotal: 180.13 352.44 - (352.44) Program number: 43,693.56 92,065.49 18.05 510,145.00 418,079.51 Department number 43,693.56 92,065.49 18.05 510,145.00 418,079.51 Fund number: 55 Tax & Rev CO 2000 I&S Fund 43,693.56 92,065.49 18.05 510,145.00 418,079.51 56-7044-00-00 Tax & Rev COs 2002 I&S 45,064.50 75,068.86 17.10 439,075.00 364,006.14 Subtotal: 45,064.50 75,068.86 17.10 439,075.00 364,006.14 Program number: 45,064.50 75,068.86 17.10 439,075.00 364,006.14 Department number Tax & Revenue 2002 45,064.50 75,068.86 17.10 439,075.00 364,006.14 Fund number: 56 Tax & Rev CO 2002 I&S Fund 45,064.50 75,068.86 17.10 439,075.00 364,006.14 58-7045-00-00 Cert. Of Oblig. 2003 I&S 30,099.61 67,286.52 17.09 393,785.00 326,498.48 Subtotal: 30,099.61 67,286.52 17.09 393,785.00 326,498.48 58-7650-00-00 Interest Earned 696.52 1,394.88 - (1,394.88) Subtotal: 696.52 1,394.88 - (1,394.88) Program number: 30,796.13 68,681.40 17.44 393,785.00 325,103.60 Department number NON-departmental 30,796.13 68,681 .40 17.44 393,785.00 325,103.60 Fund number: 58 2003 GO Refunding Bonds 30,796.13 68,681.40 1 7.44 393,785.00 325,103.60 72-7650-00-00 Interest Earned 294.08 656.75 - (656.75) Subtotal: 294.08 656.75 - (656.75) 72-8313-00-00 Memorial Donations 580.00 1,386.33 - (1,386.33) Subtotal: 580.00 1,386.33 - (1,386.33) Program number: 874.08 2,043.08 - (2,043.08) Department number 874.08 2,043.08 - (2,043.08) Fund number: 72 Library Memorial Fund 874.08 2,043.08 - (2,043.08) 79-7650-00-00 Interest 484.17 1,083.84 - (1,083.84) 79-7651-00-00 Donation 250.00 250.00 - (250.00) December Revenues.xls 15 1/3/2008 Revenue Comparison December, 2006 Current Current Year Current Month Year Percent Year Budget Account Number Description Collected Collected Collected Budget Balance Subtotal: 734.17 1,333.84 - (1,333.84) Program number: 734.17 1,333.84 - (1,333.84) Department number 734.17 1,333.84 - (1,333.84) Fund number: 79 Library Expendable Fund 734.17 1,333.84 - (1 ,333.84) 80-7650-00-00 Interest 397.94 890.80 - (890.80) Subtotal: 397.94 890.80 - (890.80) Program number: 397.94 890.80 - (890.80) Department number 397.94 890.80 - (890.80) Fund number: 80 Library Permanent Fund 397.94 890.80 - (890.80) i -! December Revenues.xls 16 1/3/2008 Departmental Expenditure Summary December, 2007 Current Percent Month Year Current Ytd Unexpended Fund Expended Actual Budget Actual Balance 01 City Council 24.23 3,346.19 89,025.00 21,566.21 67,458.79 01 City Manager 18.78 14,034.82 218,825.00 41,090.08 177,734.92 01 City Attorney 19.02 9,766.89 359,928.00 68,459.64 291,468.36 01 Municipal Court 24.25 12,074.83 217,623.00 52,781.54 164,841.46 01 City Clerk 20.30 8,066.99 125,351.00 25,440.42 99,910.58 01 Accounting & Auditing 24.50 38,063.47 454,299.00 111,319.34 342,979.66 01 Police 26.70 399,617.17 5,538,653.00 1,478,671.33 4,059,981.67 01 Fire 20.74 235,999.95 3,558,146.00 737,836.25 2,820,309.75 01 Community Development 22.54 35,657.90 675,250.00 152,224.76 523,025.24 01 Engineering 22.01 34,000.24 466,251.00 102,623.05 363,627.95 01 Public Works 23.21 10,507.39 139,331.00 32,331.53 106,999.47 01 Parks,Recreation,& ROW 16.44 50,648.76 1,095,038.00 180,021.26 915,016.74 01 Sanitation 22.57 78,389.78 1,200,499.00 270,887.57 929,611.43 01 Streets & Highways 24.38 83,103.96 1,754,712.00 427,771.84 1,326,940.16 01 Traffic & Public Lighting 21.18 44,399.79 491,517.00 104,078.30 387,438.70 01 Garage 21.38 20,749.47 302,893.00 64,745.78 238,147.22 01 Emergency Medical Service 27.19 169,086.41 2,266,627.00 616,176.29 1,650,450.71 01 Cox Field Airport 10.76 7,984.40 205,562.00 22,126.65 183,435.35 01 Paris Band 1.51 20,850.00 315.55 20,534.45 01 Library 22.06 47,344.49 632,568.00 139,518.47 493,049.53 01 General Expenses 22.28 18,530.94 1,057,586.00 235,626.74 821,959.26 01 Contingency - 50,000.00 50,000.00 General Fund 23.35 1,321,373.84 20,920,534.00 4,885,612.60 16,034,921.40 02 PEDC 4.42 32,242.14 1,671,432.00 73,787.52 1,597,644.48 02 Debt 14.03 37,178.13 795,068.00 111,534.39 683,533.61 Economic Development Fund 7.51 69,420.27 2,466,500.00 185,321.91 2,281,178.09 10 Warehouse 23.67 7,729.24 106,789.00 25,273.73 81,515.27 10 W & S Billing and Collecting 22.34 118,563.96 1,645,422.00 367,588.91 1,277,833.09 10 Water Production 18.31 149,554.73 2,405,993.00 440,627.58 1,965,365.42 10 Water Distribution 16.70 86,067.39 1,545,739.00 258,203.90 1,287,535.10 10 Sewer Maintenance 14.99 33,871.43 797,977.00 119,618.51 678,358.49 10 Waste Water Treatment 20.71 139,037.71 2,155,253.00 446,235.66 1,709,017.34 10 Lift Stations 16.23 23,660.91 459,016.00 74,477.71 384,538.29 10 Debt - 3,955,300.00 3,955,300.00 Water & Sewer Fund 13.25 558,485.37 13,071,489.00 1,732,026.00 11,339,463.00 11 Police - 385.00 63,087.17 (63,087.17) 11 Community Development - 120,000.00 120,000.00 11 Streets & Highways - 250,000.00 250,000.00 11 Traffic & Public Lighting - 25,000.00 25,000.00 Capital Projects Fund 15.97 385.00 395,000.00 63,087.17 331,912.83 12 Streets - 16,037.40 40,788.70 (40,788.70) WW &SS Rev Bond 2000 Con - 16,037.40 40,788.70 (40,788.70) 20 Municipal Court 10.49 9,386.58 154,412.00 16,191.66 138,220.34 20 Police Department 39.42 942.20 20,700.00 8,159.00 12,541.00 Special Revenue Fund 13.91 10,328.78 175,112.00 24,350.66 150,761.34 22 Health Department 23.69 63,825.95 897,326.00 212,547.60 684,778.40 Health Department Fund 23.69 63,825.95 897,326.00 212,547.60 684,778.40 25 Police 15.99 49,408.91 930,709.00 148,794.07 781,914.93 25 Fire Department - 80,000.00 80,000.00 December Department Expenditures.xls 1/3/2008 Departmental Expenditure Summary December, 2007 Current Percent Month Year Current Ytd Unexpended Fund Expended Actual Budget Actual Balance 25 Community Development - 9,000.00 9,000.00 25 Parks & ROW - 100,000.00 100,000.00 25 Airport - 338,660.00 338,660.00 Grant Fund 10.20 49,408.91 1,458,369.00 148,794.07 1,309,574.93 41 City Council - 210.00 (210.00) Tax & Rev CO 2000 Canst FL - 210.00 (210.00) 50 Debt Service 75.40 2,981,275.66 3,955,300.00 2,982,275.66 973,024.34 Revenue Bonds SinkinQ Fund 75.40 2,981,275.66 3,955,300.00 2,982,275.66 973,024.34 55 Debt Service 75.30 383,105.63 508,775.00 383,105.63 125,669.37 Tax & Rev CO 2000 I&S Fun( 75.30 383,105.63 508,775.00 383,105.63 125,669.37 56 Debt Service 76.54 336,836.25 440,075.00 336,836.25 103,238.75 Tax & Rev CO 2002 I&S Func 76.54 336,836.25 440,075.00 336,836.25 103,238.75 58 Debt Service 23.25 92,000.00 395,705.00 92,000.00 303,705.00 2003 GO RefundinQ Bonds 23.25 92,000.00 395,705.00 92,000.00 303,705.00 72 Library - 28.19 456.72 (456.72) Library Memorial Fund - 28.19 456.72 (456.72) 79 Library - 31,278.50 (31,278.50) Library Expendable Fund - 31,278.50 (31,278.50) December Department Expenditures.xls 2 1/3/2008 -,-." ..~.u_..,_.u_._._._'_.....,."_.~__~,,__~..__~ -_"__"__""~'_'_.n, .____._.~_._.,'u Departmental Expenditure Summary December, 2006 Current Unexpended I Percent Month Year Current Ytd Fund Expended Actual Budget Actual Balance 01 City Council 12.53 3,555.01 92,950.00 11,650.43 81,299.57 01 City Manager 22.44 10,721.67 155,064.00 34,791.30 120,272.70 01 City Attorney 17.74 24,235.89 369,581.00 65,562.33 304,018.67 01 Municipal Court 23.98 11,120.70 204,684.00 49,073.44 155,610.56 01 City Clerk 22.80 8,655.47 117,919.00 26,879.38 91,039.62 01 Accounting & Auditing 27.36 33,533.27 429,069.00 117,390.41 311,678.59 01 Police 22.38 368,113.63 5,229,669.00 1,170,142.39 4,059,526.61 01 Fire 19.98 223,964.34 3,506,050.00 700,620.52 2,805,429.48 01 Community Development 18.21 34,994.46 652,017.00 118,730.99 533,286.01 01 El}9ineering 21.23 31,366.46 453,399.00 96,266.96 357,132.04 01 Public Works 24.71 11,899.06 136,547.00 33,737.78 102,809.22 01 Parks,Recreation,& ROW 18.43 64,349.84 1,123,930.00 207,095.85 916,834.15 01 Sanitation 17.01 71,264.94 1,204,999.00 204,918.21 1,000,080.79 01 Streets & Highways 16.39 66,166.03 1,969,233.00 322,744.36 1,646,488.64 01 Traffic & Public Lighting 21.90 65,270.45 505,409.00 110,673.37 394,735.63 01 GarC!ge 23.21 25,060.03 278,130.00 64,555.05 213,574.95 01 Emergency Medical Service 24.57 169,504.12 2,124,118.00 521,800.56 1,602,317.44 01 Cox Field Airport 6.14 (4,521.18) 254,592.00 15,624.75 238,967.25 01 Paris Band 0.04 20,850.00 8.91 20,841.09 01 Library 20.47 35,254.84 630,511.00 129,038.33 501,472.67 01 General Expenses 33.45 30,261.15 744,146.00 248,881.47 495,264.53 01 Contingency - 302,705.00 302,705.00 General Fund 20.73 1,284,770.18 20,505,572.00 4,250,186.79 16,255,385.21 02 PEDC 2.91 18,284.12 1,570,862.00 45,630.06 1,525,231.94 02 Debt 8.93 833,138.00 74,356.26 758,781.74 Economic Development Fund 4.99 18,284.12 2,404,000.00 119,986.32 2,284,013.68 10 Warehouse 24.23 7,693.36 103,642.00 25,106.96 78,535.04 10 W & S Billing and Collecting 6.93 34,004.54 1,582,316.00 109,709.78 1,472,606.22 10 Water Production 20.25 223,892.89 2,568,133.00 519,974.46 2,048,158.54 10 Water Distribution 27.69 186,162.54 1,277,370.00 353,637.24 923,732.76 10 Sewer Maintenance 27.68 50,711.40 618,733.00 171,239.00 447,494.00 10 Waste Water Treatment 24.33 177,419.81 1,907,130.00 463,979.05 1,443,150.95 10 Lift Stations 21.06 28,730.17 428,965.00 90,325.95 338,639.05 10 Debt - 3,956,855.00 3,956,855.00 Water & Sewer Fund 13.94 708,614.71 12,443,144.00 1,733,972.44 10,709,171.56 12 Streets - 17,620.20 (17,620.20) WW &SS Rev Bond 2000 Con - 17,620.20 (17,620.20) 20 Municipal Court 6.36 1,050.25 127,987.00 8,141.23 119,845.77 20 Police Department 87.42 3,584.00 4,500.00 3,934.00 566.00 S2ecial Revenue Fund 9.11 4,634.25 132,487.00 12,075.23 120,411.77 22 Health Department 23.60 54,304.63 875,801.00 206,706.84 669,094.16 Health Department Fund 23.60 54,304.63 875,801.00 206,706.84 669,094.16 25 Police 12.92 38,650.86 896,989.00 115,905.95 781,083.05 25 Airport - 622,223.00 622,223.00 Grant Fund 7.63 38,650.86 1,519,212.00 115,905.95 1,403,306.05 26 Police - 130,224.00 130,224.00 Criminal Justice Div Grant Fd - 130,224.00 130,224.00 30 Community Development - 7,500.00 (7,500.00) Community Dvl Block Grant F - 7,500.00 (7,500.00) December Department Expenditures.xls 3 1/3/2008 _._,._.."._._.,..._..".~_..~....,."-,--..~---,.._,___,_, '.'___'m"_~_, Departmental Expenditure Summary December, 2006 Current Unexpended I Percent Month Year Current Ytd Fund Expended Actual Budget Actual Balance 41 City Council - 13,472.00 18,351.56 (18,351.56) 41 Street Department - (2,244.00) 2,244.00 Tax & Rev CO 2000 Canst Fu - 13,472.00 16,107.56 (16,107.56) 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,044,160.66 3,956,855.00 3,045,160.66 911,694.34 Revenue Bonds Sinking Fund 76.96 3,044,160.66 3,956,855.00 3,045,160.66 911,694.34 55 Debt Service 73.71 376,036.88 510,145.00 376,036.88 134,108.12 Tax & Rev CO 2000 I&S Fun( 73.71 376,036.88 510,145.00 376,036.88 134,108.12 56 Debt Service 75.57 331,236.25 439,075.00 331,824.75 107,250.25 Tax & Rev CO 2002 I&S Fun( 75.57 331,236.25 439,075.00 331,824.75 107,250.25 58 Debt Service - 393,785.00 393,785.00 2003 GO Refunding Bonds - 393,785.00 393,785.00 72 Library - 157.12 (157.12) Library Memorial Fund - 157.12 (157.12) December Department Expenditures.xls 4 1/3/2008 ..- ,.^_________^~."h_._..__......___"_.__