Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04-JANUARY 2011 STATEMENT
JANUARY 2011 Financial Report CITY OF S CHERTZ Prepared By: The Finance Department February 18, 2011 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI REVENUE SUMMARY Taxes 10,912,656 2,092,339.60 - 6,082,675.60 7,124,573.57 Franchises 1,521,000 26,997.67 - 389,531.83 425,370.28 Permits 1,181,913 227,919.50 - 215,931.32 826,828.83 Licenses 64,547 5,995.00 - 14,065.50 12,872.00 Fees 3,073,872 260,133.45 - 749,759.15 987,396.03 (50. Fines 35,000 1,929.85 - 9,376.53 8,372.74 Inter- Jurisdictional 405,672 20,879.96 - 218,708.08 117,149.26 Fund Transfers 1,184,474 - - 261,102.77 316,615.75 Miscellaneous 507,284 31,106.41 - 98,771.17 194,799.04 TOTAL REVENUES 18,886,418 2,667,301.44' - 8,039,921.95 10,013,977.50 (50. EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 22,800 1,813.46 - 2,014.33 7,211.42 Supplies 500 24.00 - 37.66 46.00 86 City Support Services 20,500 388.99 - 8,320.70 12,337.23 35 Operations Support 300 - - 74.08 - Staff Support 16,400 468.11 380.00 7,482.48 8,586.93 748 Opertating Equipment - - - - - TOTAL CITY COUNCIL 60,500'' 2,694.56' 380.00 17,929.25 28,181.58 869 CITY MANAGER Personnel Services 718,457 56,465.61 - 208,808.24 219,275.42 Supplies 2,400 262.52 - 327.62 320.51 1,295 City Support Services - - - - - Operations Support - - - - - Staff Support 25,550 1,567.72 438.80 5,030.94 10,010.21 1,287 Operating Equipment - - - - 133.43 TOTAL CITY MANAGER 746;407.00'' 58,295.85' 438.8!0 214,166.80 229,739.57 2,582 1 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI MUNICIPAL COURT Personnel Services 250,203 18,668.92 - 66,421.23 75,847.32 Supplies 3,200 51.35 - 151.67 442.64 247 City Support Services 1,000 - - - - Operations Support 3,000 1,166.00 - 673.00 1,166.00 Staff Support 4,200 198.27 33.44 1,190.99 1,270.22 146 Court Support 800 - - - - Professional Services 88,100 3,465.00 - 16,006.48 15,645.00 20,833 Maintenance Services 1,000 - - - - Operating Equipment 2,000 - - 591.98 500.00 TOTAL MUNICIPAL COURT'' 353,503'' 23,549.54 33.44 85,035.35 94,871.18 21,227 CUSTOMER RELATIONS -311 Personnel Services 88,928 6,298.61 - 47,843.90 26,178.05 Supplies 500 - - - - Staff Support 1,105 - - - - TOTAL CUSTOMER, RELATIONS -31,1 90,533,', 6,298.61,', - 47,843!.90 26,178.05 PLANNING & ZONING Personnel Services 134,105 9,968.83 - 39,625.91 41,136.87 Supplies 4,500 33.61 - 33.89 58.36 City Support Services - - - - - Operations Support 2,300 - - 183.16 - Staff Support 22,100 - 1,527.12 6,684.27 2,963.18 215 Professional Services 142,300 9,899.67 - - 18,959.73 Operating Equipment 600 1,055.00 - 217.65 1,055.00 TOTAL PLANNING &'ZONING 305,905'' 20,957.11'' 1,527.12 46,744.88 64,173.14 215 LEGAL SERVICES Operations Support 13,000 7,986.92 - 7,624.24 7,986.92 Professional Services 245,000 28,705.48 - 26,141.46 28,705.48 TOTAL LEGAL SERVICES 258,000,', 36,692.40', - 33,765!.70 36,692.40 z CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI FACILITIES MAINTENANCE 3,000 - - 1,211.98 - 195 City Support Services Personnel Services 630,024 45,615.31 - 185,541.80 204,827.55 115,500 Supplies 59,900 7,419.30 638.43 19,280.97 21,833.87 11,559 Utility Services 93,600 5,879.69 - 25,668.85 17,015.77 - 18,748.63 Operations Support - - - - - - Staff Support 7,712 1,062.37 403.00 2,227.93 4,422.63 1,221 Maintenance Services 111,950 6,832.93 6,471.04 26,507.99 52,929.88 10,747 Rental /Leasing 2,000 - - 568.35 456.96 306 Operating Equipment - - - - - 11,447.57 CapitalOutlay 24,500 - - - - - 1,429.98 TOTAL FACILITIES MAINTENANCE'' 929,686'' 66,809.60 7,512.47 259, 795:89 301,486.66 23,836 CITY SECRETARY Staff Support 3,750 20.00 - 1,467.74 682.87 320 Personnel Services 167,842 12,665.83 - 49,872.91 51,636.77 Supplies 1,550 20.02 - (19.50) 105.82 78 City Support Services 9,780 - - 4,003.11 1,400.00 2 Operations Support - - - - - Staff Support 5,700 707.40 295.00 657.08 1,837.80 788 TOTAL CITY SECRETARY 1184,872' 13,393.25' 295.0,0 54,513!.60 54,980.39 868', NON - DEPARTMENTAL Supplies 3,000 - - 1,211.98 - 195 City Support Services 365,907 20,423.09 760.00 242,594.62 211,346.66 Operations Support 115,500 21,874.11 - 49,624.41 38,185.93 32 City Assistance 390,552 99,957.57 - 199,684.92 196,822.44 Professional Services 104,850 10,448.78 - 18,748.63 18,819.37 Fund Chrgs /Transfrs -Spec Events Fnd 24,350 - - 49,100.00 - Operating Equipment 500 - - - Capital Outlay 7,000 - - 13,015.43 - TOTAL NON- DEPARTMENTAL 1,011,659' 152,703.55' 760.00 573,979!99 465,174.40 227' PUBLIC AFFAIRS Personnel Services 131,096 11,447.57 - 56,207.70 44,353.02 Supplies 2,450 84.82 - 1,429.98 129.87 Operations Support 47,500 11,857.62 - 29,304.87 14,423.09 1,017 Staff Support 3,750 20.00 - 1,467.74 682.87 320 3 a CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI Professional Services - - - 77,516.82 - Operating Equipment 6,000 - - 589.94 - 1,470 TOTAL PUBLIC AFFAIRS 190,796'' 23,410.01'' - 166,517.05 59,588.85 2,807 RECORDS MANAGEMENT Personnel Services 46,317 3,491.92 - 13,374.42 14,471.37 Supplies 900 - - - - Staff Support 1,500 - - 210.00 85.00 175 Professional Services 15,000 291.00 - 2,027.55 1,659.00 4,214 Operating Equipment - - - - - TOTAL RECORDS MANAGEMENT '' 63,717'' 3,782.92 - 15,611.97 16,215.37 4,389 SCHERTZ TALES MAGAZINE Personnel Services 126,426 9,830.42 - - 36,576.35 Staff Support 1,000 - - - - 23 Professional Services 252,500 17,985.72 - - 75,171.08 2,722 TOTAL SCHERTZ TALES MAGAZINE 379,926' 27,816.14' - - 111,747.43 2,745', ENGINEERING Personnel Services 169,469 12,316.34 - 49,306.23 50,922.09 Supplies 300 - - 33.05 8.35 Staff Support 2,213 130.00 - 390.00 395.00 Professional Services 24,000 - - 1,526.68 1,710.00 Maintenance Services 4,044 - - 1,200.00 2,145.29 599 Operating Equipment - - - - - TOTAL ENGINEERING 200,026'' 12,44634' - 52,455.96 55,180.73 599 GIS Personnel Services 117,358 8,893.52 - 34,167.01 35,463.72 Supplies 3,300 - - - - Staff Support 1,050 - - - - Professional Services 2,000 - - - - TOTAL GIS 123,708'' 8,893.52' - 34,167.01 35,463.72 TOTAL GENERAL GOVERNMENT 4,899,238,' 457,743.40', 1,0,946.83 1,602,527,35 1,579,673.47 60,369 a 101 GENERAL FUND FINANCIAL SUMMARY PUBLIC SAFETY POLICE Personnel Services Supplies City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Maintenance Services Operating Equipment Capital Outlay TOTAL POLICE CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI 4,083,030 316,709.90 50,558 1,244.42 30,000 - 100,000 7,577.30 2,000 - 31,350 5.00 13,000 - 8,000 - 76,949 - 63,996 4,834.60 169,998 34,892.00 4,628,881 365,26322' - 1,292,042.60 1,334,819.97 124.50 1,922.92 4,313.68 2,221 - 32, 003.00 - 726,914.14 - 22,663.88 21,465.55 20,200 - 21.50 98.00 1,671.74 - 2,533.78 1,021.74 2,164 - 3,717.95 1,439.98 527 - 4,803.36 - - 179.50 12,082.48 20,926.50 Staff Support 5,196.00 11, 924.02 19, 914.76 12,374 - 91,420.00 147,872.00 97,274 5,500.00 1,475,135,49 1, 551, 872.18 114,034 FIRE RESCUE Personnel Services 2,410,836 182,614.11 - 726,914.14 768,359.34 Supplies 20,200 549.70 20.15 3,845.33 1,671.74 57 Utility Services 43,900 2,628.13 - 10,806.56 10,677.95 527 Operations Support 1,100 - - 146.00 - 120 Staff Support 116,800 538.98 12,138.00 16,724.55 22,834.53 12,136 City Assistance 18,600 - 10,323.17 2,715.75 10,323.17 Professional Services 18,140 1,200.00 - - 1,200.00 300 Maintenance Services 55,000 - - 1,955.30 334.45 3,694 Operating Equipment 44,400 1,058.13 604.50 4,896.00 12,206.23 332 TOTAL FIRE '' 2,728,976'' 188,589.05' 23,085.82 768,003.63 827,607.41 17,1681 INSPECTIONS Personnel Services 364,194 27,392.55 - 101,604.93 112,196.70 Supplies 6,750 132.10 375.00 - 554.85 164 Utility Services 7,600 333.46 - 1,026.93 1,366.86 Operations Support 3,200 - - 375.00 - 139 Staff Support 14,700 500.57 388.20 1,774.87 1,632.71 249 Professional Services 10,000 - - - - Maintenance Services - - - - - Operating Equipment - - - - - TOTAL INSPECTIONS 406,444,', 28,358.68', 763.20 104,781,73 115,751.12 553 5 101 GENERAL FUND FINANCIAL SUMMARY MARSHAL SERVICE Personnel Services Supplies Utility Services Operations Support Staff Support Professional Services Maintenance Services Operating Equipment Capital Outlay TOTAL MARSHAL SERVICE TOTAL PUBLIC SAFETY' PUBLIC ENVIRONMENT STREETS Personnel Services Supplies Utility Services Operations Support Staff Support Maintenance Services Rental /Lease Operating Equipment Capital Outlay TOTALSTREETS TOTAL PUBLIC ENVIRONMENT' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI 513,250 30,263.42 - 117,413.88 6,300 124,763.58 28.15 101,900 6,450 100.00 - 370.95 - 100.00 9,265 567.68 9,000 433.04 - 1,570.64 16, 620.12 1,348.80 - - 4,000 12.44 - - 119.88 - 635 9,400 445.00 - 2,452.89 62,102.55' 918.61 12,400 16.00 - 1,041.00 1,375.00 900 21,480 1,645.33 - - 5,508.91 4,715 65,600 24,818.00 - - 41,560.29 9,700 641,580 57,73323' - 122,849.36 175,695.07 15,950 8,405,881I' 639,944.18' 29,349.02 2,470,770.21 2,670,925.78 147,706 604,591 43,369.16 - 6,300 945.79 28.15 101,900 5,441.82 - 1,380 - - 9,265 567.68 84.08 155,400 11, 778.10 16, 620.12 200 - - 4,200 - - 14,500 - - 897,736'' 62,102.55' 16,732.35 897,736' 62,102.55' 16,732.35 6 203,087.19 205,864.49 1,700.17 2,527.17 315 26,872.30 22,988.60 532 1,339.02 1,631.83 619 32,308.16 46,067.57 12,098 - 17,870.00 265,306.84 296,949.66 13,565, 265,306.84 296,949.66 13,565' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI PARKS & RECREATION PARKS DEPARTMENT Personnel Services 489,640 34,360.59 - 140,951.45 147,639.98 Supplies 40,555 1,957.26 - 20,290.39 12,813.87 2,476 City Support Services - - - - - Utility Services 110,000 5,724.28 - 27,166.51 16,995.55 418 Operations Support 700 - 600.00 - 600.00 Staff Support 7,686 767.59 202.35 3,033.13 3,190.41 954 Professional Services 35,000 - - - 8,045.00 1,900 Maintenance Services 21,000 145.72 - 26,859.09 8,852.07 1,262 Rental /Leasing 30,531 11,313.51 3,491.50 484.76 25,443.34 7,052 Operating Equipment - - - 5,974.00 3,395.00 Capital Outlay 7,000 1,555.94 - - 1,555.94 568 TOTAL PARKS DEPARTMENT 742,112'' 55,824.89 4,293.85 224, 759:33 228,531.16 14,633 SWIM POOL Supplies 16,700 70.27 123.66 (839.99) 413.62 347 Utility Services 25,500 1,027.66 - 6,564.62 2,357.57 Staff Support 925 - - 439.98 - Maintenance Services 199,378 - - 2,795.19 - Rental /Lease 500 - - - - 378 TOTAL SWIM POOL 243,003' 1,097.93' 123.66 8,959.80 2,771.19 725 COMMUNITY /CIVIC CENTER Personnel Services 115,041 5,351.44 - 24,975.63 16,574.54 Supplies 6,423 672.22 - 2,052.68 4,524.34 471 Utility Services 47,150 2,183.74 - 10,736.85 7,420.55 Operations Support 15,282 1,093.50 - 6,487.87 1,188.50 2,827 Staff Support 3,250 250.00 - 157.69 250.00 243 Professional Services - - - - 825.00 Operating Equipment 7,172 - - 28,852.10 100.00 TOTAL COMMUNITY /CIVIC CNTR 1,94,318' 9,550.90' - 73,262.82 30,882.93 3,542 TOTAL CULTURAL' 801,017' 72,256.27' 10,570.61, 207,883.47 250,585.81 8,274, s CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI SENIOR CITIZEN CENTER - Supplies - - - 124.57 - Utility Services - - - - 174.42 City Assistence - - - 3,750.00 - Maintenance Services - - - 942.50 - TOTAL SENIOR CITIZEN CENTER '' - - - 4,817 174.42 TOTAL PARKS &,',RECREATION,' 1,1,79,433,' 66,473.72', 4,417.51 311,799.02 262,359.70 18,900. CULTURAL LIBRARY Personnel Services 667,832 50,315.84 - 175,407.10 207,065.19 - Supplies 16,400 2,907.74 - 1,232.50 3,142.97 1,553. Utility Services 39,500 3,465.61 - 13,388.20 9,706.04 - Operations Support 2,500 - - 745.00 - - Staff Support 4,185 127.65 23.25 1,086.54 309.82 346. Professional Services 2,100 2,065.00 - 200.68 2,065.00 - Maintenance Services 3,500 400.00 - 2,896.25 800.00 - Operating Equipment 65,000 12,974.43 47.36 12,927.20 16,996.79 6,374. Capital Outlay - - 10,500.00 - 10,500.00 - TOTAL LIBRARY 801,017'' 72,256.27 10,570.61 207,883147 250,585.81 8,274. TOTAL CULTURAL' 801,017' 72,256.27' 10,570.61, 207,883.47 250,585.81 8,274, s CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI HEALTH ANIMAL SERVICES Personnel Services 302,083 22,600.24 - 87,025.78 96,188.21 Supplies 24,900 3,400.38 42.00 5,151.31 5,506.17 673 Utility Services 9,900 1,186.08 - 1,700.48 2,251.16 Operations Support 800 - - 70.00 - Staff Support 5,800 17.86 - 3,646.07 1,542.10 59 City Assistance 13,000 600.53 - 1,966.22 2,160.12 Professional Services 14,500 1,036.50 - 3,509.50 3,948.50 210 Maintenance Services 6,100 195.00 - 390.00 786.78 1,560 Operating Equipment 9,000 - - 17.90 - 186 Capital Outlay 4,000 3,995.00 - - 3,995.00 TOTAL ANIMAL SERVICES 390,083 33,031.59' 42.00 103,477.26 116,378.04 2,689' TOTAL HEALTH 390,083' 33,031.59' 42.0,0 103,477.26 116,378.04 2,689 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 261,085 19,762.24 - 54,235.08 77,255.93 Supplies 1,500 57.19 - 129.06 403.49 76 City Support Services 337,952 6,051.30 - 36,617.49 40,416.73 25,514 Utility Services 147,131 10,372.86 - 39,588.42 28,982.04 215 Staff Support 10,400 83.16 1,813.95 2,233.35 2,987.63 344 Professional Services - - - - - Maintenance Services 21,100 1,345.00 - 9,488.35 8,295.07 2,955 Operating Equipment 135,836 2,036.22 - 36,052.41 24,829.23 10,205 Capital Outlay 45,809 - - - - TOTAL INFORMATION TECHNOLOGY 960,813'' 39,707.97' 1,813.95 178,344:16 183,170.12 39,310 9 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI HUMAN RESOURCES Personnel Services 218,821 26,328.45 - 72,840.01 68,339.41 Supplies 1,700 - - - - Human Services 46,122 1,863.00 - 16,654.65 11,846.40 2,580 Operations Support 12,545 1,535.16 266.28 5,399.55 2,613.30 782 Staff Support 11,982 - - 5,658.34 8,337.96 503 City Assistance 9,425 1,348.00 - 3,865.00 2,072.00 Operating Equipment 2,500 - - - - TOTAL HUMAN RESOURCES 303,095'' 31,074.61'' 266.28 104,417155 93,209.07 3,866 FINANCE Personnel Services 419,818 31,626.46 - 132,007.67 127,963.50 Supplies 3,600 - - 696.30 1,061.83 254 Operations Support 1,050 - - 155.80 - Staff Support 13,370 675.00 - 2,432.00 1,830.00 53 Operating Equipment 1,000 - - - - TOTAL FINANCE 438,838 32,301.46', - 1135,291!.77 130,855.33 307', PURCHASING & ASSET MGT Personnel Services 234,220 17,743.60 - 73,664.86 72,357.84 Supplies 2,300 16.70 - 258.42 16.70 214 Utility Services 1,200 - - 104.38 41.18 Operations Support 150 60.68 - - 60.68 Staff Support 6,900 508.76 - 2,484.94 2,115.57 970 Operating Equipment 150 - - - - TOTAL PURCHASING &ASSET MGT 244,920'' 18,329.74' - 76,512.60 74,591.97 1,1841 10 101 GENERAL FUND FINANCIAL SUMMARY FLEET SERVICE Personnel Services Supplies City Support Services Utility Services Operations Support Staff Support Professional Services Maintenance Services Rental /Lease Operating Equipment TOTAL FLEET SERVICE' TOTAL INTERNAL SERVICE MISC & PROJECTS CITY ASSISTANCE Utility Services Patient Assistance Children's Advocacy Assistance Library Capital Campaign Senior Citizen's Hot Meals TOTAL CITY ASSISTANCE TOTAL MISC & PROJECTS' TOTAL EXPENDITURES'' REVENUE OVER(UNDER) EXPEND. CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMI 148,533 11,331.67 - 48,524.78 51,317.62 101,000 6,700.42 4,701.70 30,100.99 28,735.30 6,711 1,500 - - 1,500.00 1,500.00 7,000 229.30 - 870.89 877.86 400 - - - - 2,435 93.88 - 285.82 584.65 234 45,750 11,874.67 474.24 3,425.31 17,559.99 1,242 200 - - - - 6,000 - - - - 312,818 30,229.94' 5,175.94 84,707,79 100,575.42 8,188 2,260,484' 151,643.72' 7,256.17 579,273.87 582,401.91 52,857 5,000 - - 5,000.00 5,000.00 5,000 - - - - 42,000 10,500.00 - - 21,000.00 21,000 52,000'' 10,500.00' - 5,000100 26,000.00 21,000, 52,000' 10,500.00' - 5,000.00 26,000.00 21,000, 18,885,872'' 1,493,695.43' 79,314.49 5,546,038102 5,785,274.37 325,3641 546''' 4,228,703.13'' m CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -E REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUM Taxes 000 - 411100 Advalorem Tax - Current 6,704,566 1,725,241.87 - 5,456,078.16 5,707,144.19 000 - 411200 Advalorem Tax - Delinquent 50,000 3,790.86 - 27,506.45 18,603.53 000 - 411300 Advalorem Tax - P &I 50,000 2,150.21 - 8,094.90 5,934.27 000 - 411500 Sales Tax Revenue -Gen Fund 4,071,590 353,229.33 - 573,912.02 1,375,181.14 000 - 411600 Bingo Tax 4,500 - - 1,379.22 981.20 000 - 411700 Mixed Beverage Tax 32,000.00 7,927.33 - 15,704.85 16,729.24 TOTAL Taxes 10,912,656 2,092,339.60 - 6,082,675.60 7,124,573.57' Franchises 000 - 421200 Center Point /Entex Energy 33,000 26,623.10 - - 26,623.10 000 - 421220 City Public Service 275,000 - - 77,354.41 83,433.23 000 - 421240 Guadalupe Valley Elec Co -op 430,000 - - 141,613.56 124,838.75 000 - 421250 New Braunfels Utilities 30,000 - - - 7,403.70 000 - 421300 Time Warner -State Franchise 350,000 56.48 - 81,775.18 87,951.21 000 - 421350 Time Warner -PEG Fee 62,000 - - 15,960.54 16,416.59 000 - 421460 AT &T Franchise Fee 220,000 305.37 - 34,895.63 43,841.87 000 - 421465 AT &T PEG Fees 16,000 - 3,548.30 5,497.29 000 - 421480 Other Telecom Franchise 15,000 12.72 - 3,616.48 4,464.77 000 - 421500 Solid Waste Franchise Fee 90,000 - - 30,767.73 24,899.77 TOTAL Franchises 1,5211,000 26,997.67 - 389,531.83 425,370.28' Permits 000 - 431100 Home Occupation Permit 770 70.00 - 245.00 210.00 000 - 431200 Building Permit 837,952 204,389.00 - 126,825.52 727,222.83 000 - 431300 Mobile Home Permit 671 40.00 - 40.00 80.00 000 - 431400 Signs Permit 8,596 135.00 - 75.00 210.00 000 - 431500 Food Establishmnt Permit 15,000 2,600.00 - 11,400.00 10,995.00 000 - 431600 Garage Sale Permit 9,554 80.00 - 2,895.30 2,750.00 000 - 431700 Plumbing Permit 109,769 5,982.00 - 24,958.50 25,842.50 000 - 431750 Electrical Permit 63,062 5,640.00 - 14,895.50 18,600.00 000 - 431800 Mechanical Permit 84,211 5,140.00 - 19,594.00 22,420.00 000 - 431900 Solicitor /Peddler Permit - 100.00 - 190.00 170.00 000 - 431950 Animal /Pet Permit 2,000 200.00 - 795.00 1,130.00 12 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL 000 - 432000 Cert. of Occupancy Prmt 6,578 150.00 - 800.00 1,900.00 000 - 432100 Security Alarm Permit 36,000 2,956.00 - 11,605.00 12,561.00 000 - 435000 Fire Permit 7,750 437.50 - 1,612.50 2,737.50 TOTAL Permits,', 1,181,913 227,919.50 - 2,15,931.32 826,828.83', Licenses - 451110 Expunction Fee 90 000 - 441000 Alcohol Beverage License 6,100 195.00 - 952.50 420.00 000 - 442000 Contractors License 55,447 5,400.00 - 11,503.00 11,075.00 000 - 444000 Pet License 3,000 400.00 - 1,610.00 1,377.00 TOTAL Licenses 64,547 5,995.00 - 14,065.50 12,872.00', Fees 000 - 451000 Municipal Court Fines 1,540,000 73,005.28 - 395,529.88 319,538.56 000 - 451100 Arrest Fee 60,000 3,361.04 - 15,260.57 14,492.77 000 - 451110 Expunction Fee 90 - - - - 000- 451200 Warrant Fees 187,500 10,787.46 - 39,547.75 33,324.76 000 - 451320 Civil Justice Fee -Court 500 4.90 2.33 22.33 000 - 451340 Judicial Fee - City 7,000 459.44 - 2,007.72 1,914.99 000 - 451400 Traffic Fine Costs TTL 30,000 1,674.51 - 7,813.12 7,388.74 000 - 451500 Teen Court Admin Fee 500 - - 260.00 180.00 000 - 451510 Juvenile Case Mgmt Fee 60,000 3,838.73 - 16,746.54 15,992.55 000 - 451600 Technology Fund Fee 55,000 3,095.10 - 13,742.69 12,755.81 000 - 451700 Security Fee 40,000 2,321.34 - 10,316.11 9,566.87 000 - 451800 Time Payment Fee - City 5,000 621.98 - 1,125.75 1,789.12 000 - 451850 State Fines 10% Service Fee 70,000 14,149.40 - 33,685.94 33,448.06 000 - 451900 DPS Payment- Local 12,250 922.14 - 3,174.39 2,880.23 000 - 452000 Child Safety Fee 8,000 674.78 - 2,372.84 3,840.95 000 - 452050 Indigent Defense Fee 22,500 1,455.56 - 6,435.54 6,196.64 000 - 452100 Platting Fees 66,000 3,500.00 - 16,250.00 24,000.00 000 - 452200 Site Plan Fee 26,400 2,000.00 - 12,149.45 7,500.00 000 - 452300 Plan Check Fee 375,000 105,670.60 - 58,705.41 368,186.01 000 - 452310 Miscellaneous Review Fee - - - - - 000- 452320 Tree Mitigation Admin Fee 11,220 - - 6,851.25 - 000- 452400 BOA/Zoning Fees 11,000 - - 2,450.00 1,050.00 000 - 452500 Food Handler Class 8,000 2,190.00 - 2,130.00 2,980.00 000 - 452600 Specific Use /Zone Chng Fee 14,630 - - - - 000- 452610 Plat Recording Fee - - - - - 000- 452710 Zoning Ltr & Dev Rights - - - 300.00 225.00 13 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -E REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUM 000 - 453100 Reinspection Fees 49,000 5,175.00 - 15,368.02 18,600.00 000 - 453110 Swim Pool Inspection Fee - - - - - 000- 453120 Inspections Plan Review - - - 658.00 - 000- 453200 Mowing Fees - Inspections - 625.00 - 1,189.61 8,881.16 000 - 453211 Admin Fee - Inspections - - - 2,000.00 3,300.00 000 - 453215 3% Technology Fee - - - 531.40 1.98 000 - 453310 Misc Inspection Fee - 5.00 - 35.00 40.00 000 - 453500 SubContractor Reg. Fee - 3,745.00 - 6,290.00 7,345.00 000 - 453710 Foster Care - 100.00 - - 400.00 000 - 454100 Swim Pool Reservation Fee - - - - 000- 454200 Pool Gate Admission Fee 22,000 - - - - 000- 454300 Seasonal Pool Pass Fee 5,500 - - - - 000- 456500 Haz Mat Fees 2,500 - - - - 000- 456510 Fire Plan Review 800 - - - - 000- 456600 Fire Re- inspection Fee 450 100.00 - - 450.00 000 - 458100 Sale of Merchandise - 29.58 - - - 000- 458300 Sale of Property /Auction 20,000 308.85 - 4,551.65 1,375.16 (5C 000 - 458400 Civic Center Rental Fees 226,000 9,175.00 - 52,228.34 38,217.75 000 - 458401 Capital Recovery Fee -Civic Cntr - - - - 910.00 000 - 458450 North Center Rental Fees 24,000 785.00 - - 2,156.00 000 - 458500 Community Center Rental Fees 32,000 1,575.00 - 6,142.00 5,273.92 000 - 458550 Pavilion Rental Fees - 710.00 - - 4,263.70 000 - 458560 Chamber of Comm rent - 1,950.00 - - 3,900.00 000 - 458570 Non - Resident SYSA League 18,000 - - - 7,060.00 000 - 458600 Ball Field Use - 1.76 - - 1.76 000 - 458650 NonResident User Fee -BVYA 9,000 1,410.00 - - 2,820.00 000 - 458680 Tournament Fees - Soccer 14,000 2,400.00 - - 2,400.00 000 - 458700 Vehicle Impoundment 5,000 - - 2,442.75 - 000- 459200 NSF Check Fee 100 130.00 - 69.00 288.00 000 - 459300 Notary Fee 200 18.00 - 78.00 150.00 000 - 459400 Maps, Copies, UDC, & Misc F 200 - - 35.00 5.00 000 - 459600 Animal Adoption Fee 10,500 705.00 - 3,570.00 3,770.00 000 - 459700 Pet Impoundment Fee 17,500 1,117.00 - 5,768.00 6,555.01 000 - 459800 Police Reports Fee 6,532 336.00 - 1,945.10 1,958.20 TOTAL Fees 3,073,872 260,133.45 - 749,759.15 987,396.03 (5C 14 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 15 Y -T -E ENCUM ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL Fines 000 - 463000 Library Fines 35,000 1,929.85 - 9,376.53 8,372.74 TOTAL Fines 35,000 1,929.85 - 9,376.53 8,372.74' Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,078 1,756.48 - 7,025.92 7,025.92 000 - 473200 City of Seguin - Fire Contract 40,293 3,355.26 - 13,421.04 13,421.04 000 - 473300 Guad Co - Library 180,816 15,068.00 - 60,271.64 60,272.00 000 - 473400 Randolph AFB - Animal Cntrl 2,500 200.00 - 558.00 1,100.00 000 - 474200 Library Services - Cibolo - - - - - 000- 474210 Library Services -Selma 19,000 - - - - 000- 474250 Non - Resident Library Fees - - - - - 000- 474400 Dispatch Service - Cibolo 133,305 - - 133,305.00 33,326.25 000 - 474500 Dispatch Service - SCUCISD 2,080 - - 2,080.00 - 000- 474600 School Crossing Guard - Bexar 6,600 500.22 - 2,046.48 2,004.05 TOTAL Inter- Jurisdictional 405,672 20,879.96 - 2,18,708.08 117,149.26' Fund Transfers 000 - 480000 Indirect Costs - EMS 87,840 - - 21,960.00 21,960.00 000 - 480100 Indirect Costs - Hotel /Motel 170,221 - - 31,908.00 42,555.25 000 - 482100 Transfer From Reserves -Ct Tech - - - - 000- 482150 Transfer From Court Security 58,011 - - 000- 485000 Interfund Charge- Drainage 38,888 - - 9,574.50 9,722.00 000 - 486000 Interfund Chrges -Admin W &S 624,777 - - 159,736.97 156,194.25 000 - 486202 Transfer In -W &S - - - - - 000- 486317 Transfer From Park Fund - - - 4,133.27 - 000- 486322 Transfer -In - Library Grants 10,000 - - 000- 487000 Interfund Charges -Fleet 91,737 - - 19,915.03 22,326.25 000 - 488000 Interfund Charges -413 53,000 - - 13,875.00 13,858.00 000 - 490020 Transfer In -SEDC 50,000 - - - 50,000.00 TOTAL Fund Transfers'' 1,184,474 - - 261,102.77 316,615.75' Miscellaneous 000 - 491000 Interest Earned 5,000 321.71 - 1,386.06 1,285.13 000 - 491200 Investment Income 26,000 2,785.00 - 10,164.18 10,363.38 000 - 491900 Unrealized Gain /Loss - (1,261.34) - (1,638.75) (9,968.60) 000 - 493120 Donations - Public Library - - - - - 000- 493130 Donations - Writing the Next Chap. 20,000 1,349.00 - 8,197.06 21,608.00 15 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL 000 - 493400 Donation - Animal Control 3,670 206.96 - 1,572.92 2,049.26 000 - 493401 Donations -A/C Microchip 3,000 265.00 - 1,105.00 835.00 000 - 493402 Donations - Spay &Neuter 12,000 615.50 - 4,075.00 6,065.50 000 - 493403 Donations - Melvin Boeck A. S. - - - - - 000- 493503 Donations - Fire Rescue - 25.00 - - 25.00 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,800 - - - - 000- 495015 Contribution from SED - - - - - 000- 497000 Misc Income -Gen Fund 40,000 9,482.14 - 4,773.55 30,098.04 000 - 497005 Misc Income - Publications 240,000 11,963.95 - 48,188.30 40,921.95 000 - 497007 Misc Income - Schertz Artz - - - - - 000- 497020 Misc Income -Fleet Recycled 400 - - 250.80 - 000- 497100 Misc Income - Police 20,000 419.20 - 6,118.23 2,398.25 000 - 497200 Misc Income - Library 12,131 285.75 - 3,775.96 989.30 000 - 497210 Misc Income - Library Copier 3,400 269.00 - 3,360.75 000 - 497300 Misc Income - Animal Control 2,400 165.00 - 671.93 476.50 000 - 497400 Misc Income - Streets Dept. 11,229 1,000.00 - 3,800.00 7,250.00 000 - 497500 Misc Income -TML Insurance 78,043 (1,150.00) - - 49,731.90 000 - 497550 Misc Income -TML Reimbursemt 20,211 4,059.66 - 5,580.78 17,643.20 000 - 497600 Misc Income - Parks /Vending Mach. 500 304.88 - 750.15 709.41 000 - 497800 Misc Income -Pool Concessions - - - - - 000- 498000 Reimbursmnt -Gen Fund 5,500 - - - 33.00 000 - 498100 Reimbursmnt Fire - Training - - - - 846.00 000 - 498110 Reimbursmnt Fire - Emg. Acti -O - - - - 8,078.07 TOTAL Miscellaneous 507,284 31,106.41 - 98,771.17 194,799.04' TOTAL REVENUES', 18,886,418 2,667,301.44 - 8,039,921.95 10,013,977.50' 16 Y -T -E ENCUM GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 4,111,989.41 Cash in Investment Pools LOGIC Investment - General Fund 505,309.59 LOGIC Investment -Equip Replacement 73,214.29 LOGIC Investment -Veh Replacement 7,066.72 LOGIC Investment -Air Condi Replacment 122,208.94 CAPITAL ONE Investment - General Fund 1,324,973.59 Total Cash in Bank & Investment Pools $ 6,144,762.54' 17 ADVALOREM TAX $2,000,000 $1,500,000 $1,000,000 $500,000 $- $(500,000) OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 1,406,160 244,255 435,275 1,725,242 2009 -10 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792) 59,545 34,762 19,836 2008 -09 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 2007 -08 993,926 1,293,621 615,170 1,462,883 310,479 74,418 17,900 44,799 19,066 2006 -07 1,223,886 886,430 492,623 1,387,876 474,014 90,756 28,206 35,521 40,691 18 -A Sales Tax - General Fund $600,000 $500,000 .. .......... .......... .......... .......... .......... .......... $400,000 _2 °0 $300,000 $200,000 13% -3% 23%1 i 2306 ,fl $100,000 OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 339,709 329,696 344,795 353,229 468,129 2009 -10 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 3: 2008 -09 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 3 2007 -08 336,749 350,854 312,547 327,798 421,873 330,131 287,316 355,054 336,094 3: :::°::2006 -07 278,463 305,857 266,440 281,920 358,831 236,723 250,774 319,604 300,214 31 2005 -06 212,505 239,854 229,587 248,693 313,084 228,070 222,035 276,537 250,602 2' By removing the $138,288.39 one time correction paid in the month of February the true sales tax percent is -1 18 -B CITY PUBLIC SERVICE $100,000 ... ......... ......... ......... ......... ......... ......... $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 OCT NOV DEC JAN FEB MAR APR MAY JUN 132010-11 83,433 - 2009 -10 77,354 61,468 63,276 ® 2008 -09 77,308 53,071 57,506 2007 -08 55,729 50,340 48,120 2006 -07 57,413 38,691 42,722 I :mil 106 - SPECIAL EVENTS FUND FINANCIAL SUMMARY REVENUE SUMMARY Fund Transfers Wilenchik Walk for Life TML Dinner Hal Balwin Scholarship Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental TOTAL GENERAL GOVERNMENT CULTURAL Other Events Festival of Angels Employee Appreciation Event 4th of July Jubilee National Night Out Wilenchik Walk for Life Blue Santa Schertz Fest TML Events Schertz Sweetheart Hal Baldwin Scholarship Selma - Schertz 5K TOTAL CULTURAL TOTAL EXPENDITURES CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMI 85,614.00 - - 134,344.00 - 28,000.00 - - 265.00 - 2,100.00 - - - - 1,000.00 - - 115.00 - 22,300.00 12.39 - 5,983.03 407.67 139,014.00 12.39 - 140,707.03 407.67 5,150.00 - - - - 5,150.00 - - - - 4,750.00 - - - - - 24,250.00 2,511.15 - 10,191.25 12,622.63 124. 5,000.00 202.87 - - 126.00 - 100.00 - - - - - 30,500.00 - - 244.20 - 767. 5,600.00 - - - - - - - 455.59 306.07 455.91 2,700.00 - - - - - 32,000.00 1,889.91 1,058.00 8,338.16 11,510.96 618. 1,000.00 - - - - - 400.00 - - - 400.00 - 106,300.00 4,603.93 1,513.59 19,079.68 25,115.50 1,510: 111,450.00 4,603.93 1,513.59 19,079.68 25,115.50 1,510. REVENUE OVER(UNDER) EXPEND 27,564.00 19 (24, 707.83)', SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 51,671.07 Cash in Investment Pools MBIA Special Events 66,485.73 Total Cash in Bank & Investment' Pools $,', 118,156.80 20 202 -WATER & SEWER FINANCIAL SUMMARY REVENUE SUMMARY Franchises Fees Fund Transfers Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR 138,000 - - 34,450.00 10,650.00 - 13,679,750 1,086,369.05 - 4,032,426.58 4,460,511.03 - 480,616 - - 19,750.03 20,154.00 - 55,445 40,751.35 - 70,500.56 68,281.60 - 14,353,811 1,127,120.40 - 4,157,127.17'' 4,559,596.63 - NON DEPARTMENTAL Fund Charges /Transfers 31,000 TOTAL NON DEPARTMENTAL 31,000' BUSINESS OFFICE Personnel Services 458,640 32,717.76 - 106,456.80 137,928.10 - Supplies 6,550 681.48 - 769.23 988.11 188.9; Operations Support 114,000 6,470.84 - 37,655.20 25,592.44 4,803.5 Staff Support 7,950 253.44 - 163.95 1,117.31 90.9E Professional Services 9,000 1,012.20 - 6,789.41 3,644.32 - Fund Charges /Transfers 40,000 - - - - - Maintenance Services 12,000 620.00 - 3,950.00 1,820.00 4,200.0( Operating Equipment 6,800 (306.00) - - 5,979.62 98.0( TOTAL BUSINESS OFFICE 654,940 41,449.72 - 155,784.59'' 177,069.90 9,381.4'. W & S ADMINISTRATION Personnel Services 1,212,507 85,067.84 - 432,290.75 409,711.81 - Supplies 193,700 15,132.74 338.73 20,612.75 68,245.54 13,177.4; Human Services 338 64.00 - - 64.00 - City Support Services 130,000 1,108.84 - 20,571.65 34,116.32 595.3; Utility Services 2,780,900 69,643.61 - 703,026.36 450,233.46 119,913.2; Operations Support 8,750 947.93 79.60 1,177.05 2,082.38 - Staff Support 33,000 1,129.76 1,339.00 5,671.99 8,186.09 1,233.1 City Assistance 1,912 134.00 - 297.00 236.00 - Professional Services 150,094 46,646.33 9,870.00 22,384.49 55,115.41 - Fund Charges /Transfers 2,368,176 - - 169,137.00 588,422.55 209,951.6; Maintenance Services 4,838,250 383,908.36 116.41 1,703,901.58 1,422,378.55 26,857.0! Other Costs 25,000 - - 23,671.50 28,911.85 - Debt Service 1,435,165 298,814.99 - 823,871.54 382,189.99 - Rental- Leasing 6,070 - - 2,301.89 662.53 - 21 22 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR Operating Equipment 13,000 - 3,420.00 (3,400.00) 10,468.99 Capital Outlay 58,000 30,259.00 22,432.00 - 53,341.00 25,869.01 Water Line Relocation - - - 357,830.77 - - TOTAL PUBLIC WORKS 13,254,862 932,857.40 37,5!95.74 4,283,346.32'' 3,514,366.47 397,596.81 MISC & PROJECTS PROJECTS FUND CHARGES /TRANSFERS - - - - - - TOTAL PROJECTS '' AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services 19,000 - - - - - Operations Support 500 - - - - - Professional Services 45,000 12,831.96 - 6,278.12 18,915.19 - Maintenance Services 335,500 9,715.50 - 91,291.10 9,737.85 - TOTAL AVIATION HEIGHTS WTR IMP 400,000 22,547.46 - 97,,569.22 28,653.04 - FM3009 RD &BRIDGE EXPANSION Professional Services - - 19,137.50 - 30,358.80 - Maintenance Services - - - 321,193.19 29.03 - TOTAL FM3009 RD &BRIDGE EXPANSION - - 19,138 321,193 30,387.83 - TOTALL'MISC &'PROJECTS 400,000 22,547.46 19,137.50 418,,762.41 59,040.87 - TOTAL EXPENDITURES 14,340,802 996,855 56,733 4,8,57,893 3,750,477 406,97! — REVENUE OVER(UNDER)EXPENSES ** 13,009 809,119.39 22 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -I REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUN Franchises 000 - 421490 Tower Leasing 138,000 - - 34,450.00 10,650.00 TOTAL Franchises 138,000 - - 34,450.00 10,650.00' Fees 000 - 455200 Garbage Collection Fee 3,300,000 258,910.88 - 991,487.34 1,071,158.96 000 - 455600 Fire Line Fees 18,500 - - 18,190.00 18,430.00 000 - 455700 Recycle Fee Revenue 155,000 19,534.47 - 49,671.68 63,850.61 000 - 455800 W &S Line Constructn Reimbursemnt 50,000 6,019.84 - 5,385.00 12,603.79 000 - 457100 Sale of Water 7,200,000 484,348.07 - 1,886,817.42 2,188,698.67 000 - 457110 Edwards Water Lease 127,250 73,199.96 - 779.80 132,707.46 000 - 457120 Water Transfer Charge -Selma 5,000 - - 780.18 - 000- 457130 Water Transfer Charge -U. C. 1,000 - - 3,914.06 - 000- 457200 Sale of Meters 86,000 9,796.67 - 15,359.98 32,806.97 000 - 457400 Sewer Charges 2,560,000 219,085.18 - 999,605.50 880,572.09 000 - 457500 Water Penalties 175,000 15,328.13 - 59,534.51 58,843.19 000 - 459200 NSF Check Fee -Water &Sewer 2,000 145.85 - 901.11 839.29 TOTAL Fees 13,679,750 1,086,369.05 - 4,032,426.58 4,460,511.03' Fund Transfers 000 - 486101 Transfer In- General Fund 400,000 - - - - 000- 486204 Interfnd Chrg- Drainage Bill 80,616 - - 19,750.03 20,154.00 TOTAL Fund Transfers 480,616 - - 19,750.03 20,154.00' Miscellaneous 000 - 490000 Misc Charges 15,000 50.00 - 9,153.11 4,431.88 000 - 491000 Interest Earned 500 57.51 - 162.21 1,028.08 000 - 491200 Investment Income 5,000 14,951.92 - 32,778.94 5,850.82 000 - 493130 Library Donations - - - 2.89 - 000- 493400 Donations - Christmas Activitise - - - - 1,000.00 000 - 497000 Misc Income -W &S 20,000 17.43 - 3,238.40 (2,054.27) 000 - 497550 TML Reimbursements - - - - 2,291.34 000 - 498100 Reimbursement -EMS Loan 9,945 - - - - 000- 498110 Reimbursement -SSLGC - 25,674.49 - 25,165.01 50,615.45 000 - 498200 W &S Project Reimbursement 5,000 - - - 5,118.30 TOTAL Miscellaneous 55,445, 40,751.3,5 - 70,500.56 68,281.60', TOTAL REVENUES 14,353,811' 1,127,120.40 - 4,157,127.17 4,559,596.63' 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 440,522.20 Cash in Investment Pools Lone Star Investment -Water &Sewer Lone Star Investment -W &S Customer Deposits Lone Star Investment -W &S Equip Replacement Lone Star Investment -W &S Veh Replacement Schertz Bank & Trust - Certificate of Deposit 1,489,855.07 293,194.30 372,470.48 543,106.47 1,044,420.00 $3,743,046.32 Total Cash in Bank & Investment Pools $4,183,568.52 24 203 -EMS FINANCIAL SUMMARY REVENUE SUMMARY Fees Inter - Jurisdictional Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services Supplies Human Services City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges/Transfers Maintenance Services Debt Service Rental- Leasing Operating Equipment TOTAL PUBLIC SAFETY'' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR 5,436,537 2,985.00 - 1,413,867.93 772,356.37 - 1,432,345 295,281.79 - 615,264.64 764,797.60 - 334,850 23,718.36 - 58,184.64 67,834.56 - 7,203,732 321,985.15 - 2,087,317.21 1,604,988.53 - 2,391,410 216,266.45 - 862,378.79 884,346.21 - 327,874 36,559.67 382.34 118,723.28 104,435.42 24,402.33 847 446.00 - - 446.00 134.00 15,000 - - 14,850.78 10,902.09 - 80,438 7,989.10 - 22,150.01 23,950.58 - 30,000 1,246.45 - 12,188.36 23,756.24 1,251.55 75,600 4,414.38 171.35 37,380.52 21,406.30 13,923.12 7,753 2,386.00 - 1,321.05 3,016.00 - 137,890 6,311.22 160.00 30,381.16 38,535.85 7,291.85 3,576,092 - - 1,397,517.95 29,475.00 - 42,320 1,410.00 - 16,657.16 10,041.40 5,670.00 248,502 69,799.33 - 9,523.75 69,799.33 - 40,000 - - 3,159.03 836.33 - 82,600 2,533.04 - 26,328.82 4,577.32 2,770.51 7,056,326 349,361.64 713.69 2,552,560.66 1,225,524.07 55,443.36 TOTAL EXPENDITURES 7,056326 349,361.64 713.69 2,552,560.66' 1,225,524.07 55,443.36 REVENUE OVER(UNDER), EXPENSES " 147,406 379,464.46 2s CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 203 -EMS CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR Fees - 55.97 - 84.91 243.28 - 000- 493203 Donations -EMS 000 - 456100 Ambulance /Mileage Transprt 5,336,537 - - 1,410,230.93 756,536.37 - 000- 456110 Subscription Program Fees 100,000 2,985.00 - 3,637.00 15,820.00 - TOTAL Fees 5,436,537 2,985.00 -_ 1,413,867.93 772,356.37 - Inter - Jurisdictional 22,210.00 - TOTAL Miscellaneous 334,850 23,718.36 000 - 473500 Seguin /Guadalupe Co Support 286,126 68,250.58 - 95,375.48 204,751.74 - 000- 474300 Cibolo Support 219,699 - - 106,650.00 106,650.00 - 000- 475100 Comal Co ESD #6 75,369 18,960.00 - - 37,253.44 - 000- 475200 Live Oak Support 152,569 37,031.25 - 74,062.50 74,062.50 - 000- 475300 Universal City Support 210,545 51,103.13 - 102,206.26 102,206.26 - 000- 475400 Selma Support 64,689 17,182.50 - 31,402.50 34,365.00 - 000- 475500 Schertz Support 399,083 96,864.87 - 193,729.74 193,729.74 - 000- 475600 Santa Clara Support 10,851 2,633.67 - 5,326.58 5,267.34 - 000- 475800 Marion Support 13,414 3,255.79 - 6,511.58 6,511.58 - TOTAL Inter - Jurisdictional 1,432,345 295,281.79 - 615,264.64 764,797.60 - Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Income - 55.97 - 84.91 243.28 - 000- 493203 Donations -EMS 6,000 250.00 - 706.00 1,100.00 - 000- 497000 Misc Income 150,000 11,713.48 - 30,573.73 37,931.28 - 000- 497100 Recovery of Bad Debt 100,000 1,448.91 - - 6,350.00 - 000- 497500 Misc Income -EMT Classes 78,850 10,250.00 - 26,820.00 22,210.00 - TOTAL Miscellaneous 334,850 23,718.36 - 58,184.64 67,834.56 - TOTAL REVENUES 7,203,732 32,1,985.15 -_ 2,087,317.21 1,604,9,88.53 - 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ (261,139.17) Cash in Investment Pools LOGIC Investment -EMS MBIA Investment -EMS Note 2010 300,436.39 Total Cash in Bank & Investment Pools $ 39,297.22' 27 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D I FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR E REVENUE SUMMARY Fees 675,300 58,721.13 - 222,850.11 234,138.32 - 4 Miscellaneous 1,300 83.16 - 303.56 470.07 - _ TOTAL REVENUES 676,600 58,804.29 '' - 223,153167 234,608.39 - 4 PUBLIC WORKS DRAINAGE Personnel Services 361,183 25,949.87 - 113,961.19 121,507.64 - 2 Supplies 8,300 143.63 28.15 472.62 326.87 264.97 Human Services 100 - - - - - City Support Services 26,500 487.14 - 976.00 1,832.18 - Utility Services 12,888 996.48 - 3,474.99 3,130.59 304.13 Operations Support 2,458 - - - - - Staff Support 8,255 174.68 168.83 1,023.94 1,016.92 388.95 City Assistance 840 - - 102.00 15.00 - Professional Services 19,800 - - 4,038.35 - - Fund Charges/Transfers 195,449 - - 32,324.53 32,662.25 - 1 Maintenance Services 22,000 1,987.00 - 4,557.95 1,987.00 - Other costs 100 100.00 - 100.00 100.00 - Debt Service 18,138 1,918.78 - 2,183.45 1,918.78 - Rental /Leasing 500 - - - - - _ TOTAL DRAINAGE 676,511'' 31,757.58 '' 196.98'' 163,215.02 164,497.23 958.05 5 TOTAL EXPENDITURES 676,511'' 31,757.58 '' 196.98'' 163,215.02 164,497.23 958.05 5 "" REVENUE OVER(UNDER) EXPEND 89' 2s 70,111.16'' 204-DRAINAGE REVENUES Fees 000 - 457500 Drainage Penalties 000 - 457600 Drainage Fee TOTAL Fees Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Interest 000 - 497000 Misc Income - Drainage TOTAL Miscellaneous TOTAL'REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BU BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR BAL 3,500 446.57 671,800 58,274.56 675,300, 58,721.13,', 100 16.85 600 57.07 600 9.24 1,300 83.16' 676,600 58,804.29 29 1,371.53 221,478.58 222, 850,.11 3.98 238.00 61.58 303.56 1,484.69 232,653.63 234,138.322 130.40 238.09 101.58 470.07 223,153.67 234,608.39 - L - 43E 441 441 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking 181,736.66 Cash in Investment Pools Lone Star Investment - Drainage Maint Fund 282,693.53 Total Cash in Bank & Investment Pools $ 464,430.19 30 314 -HOTEL TAX FINANCIAL SUMMARY REVENUE SUMMARY Taxes Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services City Support Services Operations Support Professional Services Fund Charges/Transfers Operating Equipment Capital Outlay TOTAL NON'DEPARTMENTAL' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR I 385,000 25,262.13 - 90,987.83 89,546.49 - 5,550 25.87 - 180.70 175.68 390,550'' 25,288.00 - 91,168.53 89,722.17 - 31,841 - - - - - 78,228 14,557.00 502.85 2,913.50 29,616.85 - 33,424 1,383.38 - - 3,734.38 - 2,500 - - 902.28 - - 231,485 - - 117,152.00 42,555.25 - 377,478 15,940.38 502.85'' 120,967.78 75,906.48 - TOTAL EXPENDITURES 377,478 15,940.38 502.85'' 120,967.78 75,906.48 - REVENUE OVER(UNDER)',EXPENDITURE 13,072 13,815.69 31 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUI REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BAL Taxes 000 - 411800 Hotel Occupancy Tax 385,000 25,262.13 - 90,987.83 89,546.49 - 295, TOTAL Taxes 385,000 25,262,13 - 90,, 987.83 89, 546.49 - 295, Miscellaneous 000 - 491000 Interest Earned 250 13.43 - 136.91 123.50 - 000- 491200 Investment Interest 300 12.44 - 43.79 52.18 - 000- 497000 Misc Income 5,000 - - - - - 5, TOTAL Miscellaneous 5,550 25.87 - 180.70 175.68 - 5, TOTAL REVENUES 390,550 25,288.00 - 91,168.53 89,722.17 - 300, 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 132,003.38 Cash in Investment Pools Federated Investment -Hotel /Motel 78,053.98 Total Cash in Bank '& Investment Pools $' 210,057.36' 33 HOTEL OCCUPANCY TAX 34 317 -PARK FINANCIAL SUMMARY REVENUE SUMMARY Parkland Dedication Fees Tree Mitigation Fees Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBI 40,000 - - - - 40,000 - - 38,823.75 - 405 50.13 - 202.39 281.05 80,405 50.13 - 39,026.14 281.05 - PARKLAND DEDICATION Maintenance Services- Landscape 8,000 - - (496.64) - - Operating Equipment 30,000 8,480.80 11,244.23 33,976.73 30,488.30 10,729.0 Capital Outlay 6,000 4,980.30 - - 4,980.30 - TOTAL PARKLAND DEDICATION 44,000 13,461'J10 11,244.23 33,480.09'' 35,468.60 10,729.0 TREE MITIGATION Fund Charges/Transfers Maintenance Services -Trees Capital Outlay TOTAL TREE MITIGATION TOTAL EXPENDITURES - - - 4,133.27 - - 36,000 2,990.00 3,133.00 26,750.00 17,976.00 195.0 36,000 2,990.00 3,133.00 30,883.27' 17,976.00 195.0 80,000 16,451':10 14,377.23 64,363.36' 53,444.60 10,924.!0 REVENUE OVER(UNDER) EXPEND' 405' 35 (53,163.55)' 36 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 317 -PARK CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRA Fees 000 - 458800 Parkland Dedication 40,000 - - - - 000- 458900 Tree Mitigation 40,000 - - 38,823.75 - TOTAL Fees '' 80,000 - - 38,823.75 - Miscellaneous 000 - 491000 Interest Earned 60 13.29 - 14.46 126.51 000 - 491200 Investment Interest 280 36.84 - 142.93 154.54 000 - 497000 Miscellaneous Income 65 - - 45.00 - TOTAL Miscellaneous 405 50.13 202.39 281.05' TOTAL REVENUES 80,405 50.13 - 39,026.14 281.05, 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $124,652.77 Cash in Investment Pools Federated Investment -Park Fund 38,817.77 Federated Investment -Tree Mitigation 192,317.96 Total in Investment Pool 231,135.73 Total Cash in Bank !& Investment' Pools $' 355,788.50'' 37 318 - RECYCLING FINANCIAL SUMMARY REVENUE SUMMARY Fund Transfer Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY NUNUEHAN I IVIEN 1 AL Payable to Waste Contractor TOTAL NONDEPARTMENTAL' TOTAL EXPENDITURES REVENUE OVER(UNDER)',EXPEND' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBI 31,000 - - - - 25,000 - - - - - 56,000 - - - - - 56,000 - - - - - 56,000 - - - - - 56,000 - - - - - 38 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 318 - RECYCLING CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR Fund Transfers 000 - 486202 Transfer In -W &S 31,000 - - - - - TOTAL Fund Transfers 31,000 - - - - - Miscellaneous 000 - 490210 Sale of Recycle Material 25,000 - - - - - TOTAL Miscellaneous 25,000 - - - - TOTAL REVENUES 56,000 - - - 39 RECYCLE FUND CASH IN BANK AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking (58,365.47) Total Cash in Bank 40 $ (58,365.47)' 411 - CAPITAL RECOVERY FINANCIAL SUMMARY REVENUE SUMMARY Fees Fund Transfers Miscellaneous TOTALREVEN'UES' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Operations Support Professional Services Debt Service Capital Outlay TOTAL NON DEPARTMENTAL' MISC & PROJECTS Projects Schaefer RD Water Improvements Northcliffe Elevated Tnk Northcliffe Water Plant Town Creek Project Live Oak Water Plant Loop Feed Water Line Aviation Heights WTR IMP TOTALIMISC & PROJECTS CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSES Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBI 1,190,640 198,044.34 - 238,539.09 931,184.51 - 585,500 2,151.36 - 85,551.23 83,491.31 - 1,776,140 200,195.70 - 324,090.32 1,014,675.82 - 1,000 - - - - - 37,000 351.96 - - 1,059.16 - - - - 118,896.50 - - - - 8,428.00 - 8,428.00 - 38,000 351.96 8,428.00 118,896.50' 9,487.16 - - - 53,183.36 180.00 53,183.36 - 600,000 - - - - - - 2,232.31 - 453,469.89 204,243.74 - - - 225,148.72 88, 806.01 225,148.72 - 600,000 2,232.31 278,332.08 542,455.90'' 482,575.82 - 638,000 2,584.27 286,760.08 661,352.40' 492,062.98 - REVENIUEOVER(UNDER) EXPENDITURES' 1,138,140' 41 522,613 42 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 411 - CAPITAL RECOVERY CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMI Fees 000 - 455900 Capital Recovery - Water 904,200 154,536.00 - 175,465.61 621,619.34 000- 455910 Capital Recovery - Waste Wtr 272,800 43,358.34 - 63,073.48 308,965.17 000- 455911 Capital Recovery-Wste Wtr Zone 1 13,640 - - - - 000- 455913 Cap Recovery-North Sewer Tr - 150.00 - - 600.00 TOTAL Fees 1,190,640 198, 044.34 - 238, 539.09 931,184.51 - Fund Transfers 000 - 481000 Transfer from Reserves - - - - - 000- 486100 Transfer In - - - - TOTAL Fund Transfers - - - - - Miscellaneous 000 - 491000 Interest Earned 2,000 18.66 - 182.47 210.11 000- 491200 Investment Income 250,000 3,392.19 - 1,993.79 12,014.17 000- 491900 Unrealized Gain /Loss -Cap One - (1,259.49) - - (12,107.97) 000- 498100 Reimbursmnt - FM 78 Project 50,000 - - 12,499.97 12,500.00 000- 498200 Re- imbursement -Water Meters 283,500 - - 70,875.00 70,875.00 TOTAL Miscellaneous 585,500 2,151.36 - 85,551.23 83,491.31 TOTALREVENUES 1,776,140 200,195.70 - 324,090.32 1 „014,675.82 - 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 317,924.57 Cash in Investments: Lone Star Investment - Capital Recovery 261,415.53 Capital One - Investment 1,697,251.22 Schertz Bank & Trust - Certificate of Deposit 523,353.67 Total Cash in Bank & Investment Pools $2,799,944.99 43 505 -TAX I &S FINANCIAL SUMMARY REVENUE SUMMARY Taxes Fund Transfers Miscellaneous TOTAL'REVENUES' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services Debt Service TOTAL GENERAL GOVERNMENT CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBF 3,368,794 867,357.06 - 2,897,710.15 2,861,641.28 - 243,000 - - - - - 3,000 294.53 - 1,446.57 600.52 - 3,614,794 867,651.59 - 2,899,156.72 2,862,241.80 - 3,200 - - - - - 3,611,124 - - 1,762,329.41 2,558,340.59 - 3,614,324 - - 1,762,329.41 2,558,340.59 TOTAL EXPENDITURES 3,614,324 - - 1,762,329.41 2,558,340.59 - " REVENUE OVER(UNDER), EXPEND 470 303,901.21 44 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRRENT Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMB Taxes 000 - 411900 Property Tax Revenue 3,368,794 867,357.06 - 2,897,710.15 2,861,641.28 - TOTAL Taxes,', 3,368,794 867,357.06 - 2,897,710.15 2,861,641,.28 - Fund Transfers 000 - 486000 Transfer From Reserves 243,000 - - - - - 000- 486103 Transfer In - - - - - - TOTAL Fund Transfers 243 „000 - - - - -_ Miscellaneous 000 - 491000 Interest Earned 1,500 - - 690.93 224.83 - 000- 491200 Investment Earnings 1,500 294.53 - 755.64 375.69 - TOTAL Miscellaneous 3,!000 294.53 - 1,446.57' 600.52 - TOTAL REVENUES 3,614,794 867,651.59 - 2,899,156.72' 2,862,241''.80 - 4s CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 505 -TAX I& S ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -I NON DEPARTMENTAL BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUN Professional Services 101 - 541500 Paying Agent 3,200 - - - - TOTAL Professional Services 3,200 - - - - Debt Service 101 - 555612 Schertz C O SR2001- Principal 210,000 285,000.00 - 200,000.00 285,000.00 101 - 555612.1 Schertz CO BOND, 2001 - Interest 141,318 33,312.50 - 77,090.00 37,977.08 101 - 555622 Schertz C O SR2003- Principal 190,000 190,000.00 - - 190,000.00 101 - 555622.1 Schertz C O SR2003- Interest 60,820 32,120.00 - - 32,120.00 101 - 555624 Comm Proj Bond -SR04- Principal 325,000 325,000.00 - - 325,000.00 101 - 555624.1 Comm Proj Bond SR04- Interest 265,009 136,058.76 - - 136,058.76 101 - 555626 LS &D SR2006- Principal - - - 100,000.00 - 101- 555626.1 LS &D SR2006- Interest 650,982 325,490.64 - 327,490.64 325,490.64 101 - 555628 CO Bond 2007 - Principal 99,567 13,451.11 - - 13,451.11 101 - 555628.1 CO Bond 2007 - Interest 26,617 - - - - 101- 555629 GO Bond 2007 - Principal 275,000 382,346.25 - 250,000.00 382,346.25 101 - 555629.1 GO Bond 2007 - Interest 209,097 - - 127,331.56 - 101- 555630 GO Bond SR2008 Principal 355,000 355,000.00 - 235,000.00 355,000.00 101 - 555630.1 GO Bond SR2008 Interest 379,651 193,490.50 - 198,343.25 193,490.50 101 - 555631 GO Bond SR2009 Principal 140,000 140,000.00 - 80,000.00 140,000.00 101 - 555631.1 BO Bond SR2009 Interest 283,063 142,406.25 - 167,073.96 142,406.25 TOTAL Debt Service 3,61,1,124 2,553,676.01,', - 1,762,329.41 2,558,340.59' TOTAL EXPENDITURES 3,614,324 '' 2,553,,676.01'' - 1,762,329:41 2,558,340.59' 46 TAX I &S CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 230,446.77 Cash in Investment Pools Federated Investment -Tax I &S 359,668.74 Total Cash in Bank & Investment Pools $' 590,115.51 47 620 -SED CORPORATION FINANCIAL SUMMARY REVENUE SUMMARY Taxes Miscellaneous TOTAL REVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies Utility Service Maintenance Services Operating Equipment Capital Outlay TOTAL NONIDEPARTMENTAL' ECONOMIC DEVELOPMENT Personnel Services Supplies Human Services City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges/Transfers Fund Replenish -Fund Balance Maintenance Services Debt Service Operating Equipment TOTAL ECONO DEVELOPMENT CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR 2,035,795 176,614.67 - 286,956.01 687,590.55 - 108,000 217.15 - 15,547.18 4,555.49 - 2,143,795 176,831.82 - 302,503.19 692,146.04 - 21,000 2,033.96 623.28 4,309.63 7,855.73 1,795.55 85,800 4,769.79 - 23,038.80 13,736.16 - 67,300 3,655.89 5,965.50 25,034.91 28,454.23 204.00 8,498 - - 14,869.00 6,999.31 - - - 6,999.31 - - - 182,598 10,459.64 13,588.09 67,252.34 57,045.43 1,999.55 202,062 8,669.14 - 85,519.80 50,329.26 - 1,000 356.29 - 131.75 509.32 - 100 - - - - - 34,500 122.50 623.92 12,267.18 4,702.74 1,583.38 4,850 298.70 - 1,243.19 913.71 - 76,100 9,042.38 3,242.89 26,270.02 20,520.07 1,655.56 97,000 3,136.46 1,782.11 75,295.30 59,276.29 2,173.41 80,000 - - - - - 349,000 25,722.37 21,340.80 94,982.05 67,141.17 2,356.01 105,432 - - 13,875.00 63,858.00 - 216,000 - - - - - - - - 781.89 - - 792,432 606,911.25 - 355,322.21 606,911.25 - 1,500 - - 2,485.29 - - 1,959,976 654,259.09 26,989.72 668,173.68 874,161.81' 7,768.36 TOTAL EXPENDITURES 2,142,574 664,718.73 40,577.81 735,426.02 931,207.24'' 9,767.91 " REVENUE'OVER(UNDER) EXPEND 1,221 '' (239,06120)' 4s 620 -SED CORPORATION REVENUES Taxes 000 - 411500 Sales Tax Revenue (413) TOTAL Taxes Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Earnings 000 - 497000 Misc Income 000 - 499000 Transfer From Reserves TOTAL Miscellaneous CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR 2,035,795 176,614.67 2,035,795 176, 614167 1,000 33.17 12,000 90.98 15,000 93.00 80,000 - 108;000 217.15 286, 956.01 687, 590.55 286, 956.01 687, 590.55 - 289.82 33.17 - 13,663.05 4,215.02 - 1,594.31 307.30 15,547.18 4,555.49', TOTAL REVENUES'' 2,143,795 176,831.82 - 302,503.19 692,146.04' 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 29,333.23 Cash in Investment Pools MBIA Investment - Economic Development Corp 15,182.54 MBIA- Investment -Sysco Infrastructure 150,369.05 MBIA- Investment -EDC Notes 2010 153,470.78 Schertz Bank & Trust - Certificate of Deposit 504,947.54 Schertz Bank & Trust - Certificate of Deposit 1,027,353.23 Total Cash in Bank & Investment Pools $ 1,880,656.37 50 4B SALES TAX By removing the $138,288.39 one time correction paid in the month of February the true sales tax perc 51 R NM ..A IN nvg Ie A 4 t; M. W 0 n m ;tee a I. a »/ 3\ i«« MCMA lammam mima mus;w"L.0 9 11 im