Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05-FEBRUARY 2011 STATEMENT
FEBRUARY 2011 Financial Report CITY OF S CHERTZ Prepared By: The Finance Department March 28, 2011 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 1,214,903.42 - 7,137,456.75 8,341,974.74 Franchises 1,521,000 307,013.78 - 714,842.37 740,190.80 Permits 1,181,913 53,331.00 - 290,272.32 879,979.83 Licenses 64,547 3,546.00 - 17,272.50 16,418.10 Fees 3,073,872 195,626.76 - 980,669.21 1,182,902.48 (75. Fines 35,000 2,143.10 - 12,064.98 10,515.84 Inter- Jurisdictional 405,672 51,849.91 - 237,655.11 168,999.17 Fund Transfers 1,184,474 - - 261,527.09 316,615.75 Miscellaneous 507,284 16,105.15 - 207,165.25 210,904.19 TOTAL REVENUES 18,886,418 1,844,519.12' - 9,858,925.58 11,868,500.90 (75. EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 22,800 1,813.46 - 2,560.85 9,024.88 Supplies 500 - - 37.66 46.00 86 City Support Services 20,500 382.95 - 8,305.70 12,720.18 22 Operations Support 300 - - 74.08 - Staff Support 16,400 830.32 380.00 7,518.69 9,417.25 113 Opertating Equipment - - - - - TOTAL CITY COUNCIL 60,500'' 3,026.73' 380.00 18,496.98 31,208.31 222 CITY MANAGER Personnel Services 718,457 58,537.80 - 268,037.14 277,813.22 Supplies 826 77.04 - 327.62 1,354.80 1,435 City Support Services - - - 32.00 - Operations Support - - - - - Staff Support 25,550 1,353.47 438.80 5,261.71 11,363.68 668 Operating Equipment 1,574 179.99 - - 313.42 TOTAL CITY MANAGER 746;407.00'' 60,14830' 438.8!0 273,658.47 290,845.12 2,104 1 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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,802.62 - 86,933.64 94,649.94 Supplies 3,200 101.89 - 170.67 601.83 156 City Support Services 1,000 - - - - Operations Support 3,000 - - 673.00 1,166.00 Staff Support 4,200 129.17 33.44 1,740.99 1,149.39 157 Court Support 800 - - - - Professional Services 86,600 5,958.75 - 19,943.98 21,603.75 17,710 Maintenance Services 2,500 300.00 - - 300.00 Operating Equipment 2,000 - - 741.98 500.00 TOTAL MUNICIPAL COURT'' 353,503'' 25,292.43 33.44 110,204.26 119,970.91 18,0231 CUSTOMER RELATIONS -311 Personnel Services 88,928 6,351.92 - 39,588.35 32,529.97 Supplies 500 - - - - 63 Staff Support 1,105 - - - - TOTAL CUSTOMER, RELATIONS -31,1 90,533,', 6,351.92', - 39,588!.35 32,529.97 63', PLANNING & ZONING Personnel Services 134,105 10,395.22 - 50,693.84 51,532.09 Supplies 4,500 15.00 - 33.89 73.36 43 City Support Services - - - - - Operations Support 2,300 77.95 - 183.16 77.95 Staff Support 22,100 68.82 1,527.12 6,684.27 3,032.00 200 Professional Services 142,300 9,687.66 - - 28,647.39 18,452 Operating Equipment 600 - - 217.65 1,055.00 TOTAL PLANNING &'ZONING 305,905'' 20,244.65' 1,527.12 57,812181 84,4117.79 18,696. LEGAL SERVICES Operations Support 13,000 131.04 - 7,624.24 8,117.96 Professional Services 245,000 13,812.65 - 55,860.64 42,518.13 TOTAL LEGAL SERVICES 258,000,', 13,943.69', - 63,484.88 50,636.09 z CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 167,842 12,905.18 - 64,037.56 64,541.95 Supplies Personnel Services 630,024 45,786.62 - 235,925.57 250,614.17 9,780 Supplies 59,900 6,469.36 638.43 21,713.90 28,303.23 9,965 Utility Services 93,600 9,971.56 - 35,578.53 26,987.33 295.00 862.08 Operations Support - - - - - 68,759.20 Staff Support 7,712 700.26 403.00 2,578.84 5,122.89 1,141 Maintenance Services 111,950 8,196.08 6,471.04 39,287.09 61,125.96 10,450 Rental /Leasing 2,000 306.96 - 568.35 763.92 115,500 Operating Equipment - - - - - - CapitalOutlay 24,500 - - - - - 39,539.20 TOTAL FACILITIES MAINTENANCE'' 929,686'' 71,430.84 7,512.47 335,652.28 372,917.50 21,557 CITY SECRETARY Personnel Services 167,842 12,905.18 - 64,037.56 64,541.95 Supplies 1,550 15.00 - 74.45 760.78 206 City Support Services 9,780 2.00 - 4,003.11 1,402.00 Operations Support - - - - - Staff Support 5,700 216.67 295.00 862.08 2,054.47 1,355 TOTAL CITY SECRETARY 1184,872' 13,138.85' 295.0,0 68,977!.20 68,759.20 1,562, NON - DEPARTMENTAL Supplies 3,000 - - 2,291.18 195.44 55 City Support Services 361,407 1,184.46 760.00 245,278.91 212,531.12 3,272 Operations Support 115,500 (440.69) - 55,507.81 37,549.80 5,079 City Assistance 390,552 - - 199,684.92 196,822.44 11,676 Professional Services 104,850 27,985.86 - 39,539.20 46,805.23 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,007,159' 28,729.63' 760.00 604,417!45 493,904.03 20,083 PUBLIC AFFAIRS Personnel Services 131,096 11,501.68 - 78,204.44 55,854.70 Supplies 2,450 - - 1,429.98 129.87 179 Operations Support 47,500 833.58 - 30,087.89 6,587.99 1,204 Staff Support 3,750 320.00 - 1,497.74 1,002.87 3 101 GENERAL FUND FINANCIAL SUMMARY Professional Services Operating Equipment TOTAL PUBLIC AFFAIRS RECORDS MANAGEMENT Personnel Services Supplies Staff Support Professional Services Operating Equipment TOTAL RECORDS MANAGEMENT SCHERTZ TALES MAGAZINE Personnel Services Staff Support Professional Services TOTAL SCHERTZ TALES MAGAZINE' ENGINEERING Personnel Services Supplies Staff Support Professional Services Maintenance Services Operating Equipment TOTAL ENGINEERING GIS Personnel Services Supplies Staff Support Professional Services TOTAL GIS 117,358 8,947.24 3,300 - 1,050 - 2,000 - 123,708'' 8,947.24' TOTAL GENERAL GOVERNMENT 4,894,738,' 314,220.90 - 44,199.60 44,410.96 - 44,199160 44,410.96 1,0,946.83 1,913,081,00 1,895,298.88 86,272 a CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 - - - 96, 519.00 - 6,000 - - 589.94 - 1,927 190,796'' 12,655.26 - 208,328199 63,575.43 3,310 46,317 3,518.61 - 17,394.23 17,989.98 900 75.00 - - 75.00 1,500 175.00 - 640.00 260.00 15,000 4,505.14 - 2,027.55 6,164.14 25 63,717' 8,273.75' - 20,061.78 24,489.12 25 126,426 9,884.28 - - 46,460.63 1,000 - - - - 23 252,500 14,782.64 - - 98,622.40 379,926' 24,666.92, - - 145,083.03 23', 169,469 12,370.69 - 62,569.22 63,292.78 300 - - 33.05 8.35 2,213 - - 390.00 395.00 24,000 5,000.00 - 4,005.68 6,710.00 4,044 - - 1,200.00 2,145.29 599 200,026' 17,370.69' - 68,197.95 72,551.42 599 117,358 8,947.24 3,300 - 1,050 - 2,000 - 123,708'' 8,947.24' TOTAL GENERAL GOVERNMENT 4,894,738,' 314,220.90 - 44,199.60 44,410.96 - 44,199160 44,410.96 1,0,946.83 1,913,081,00 1,895,298.88 86,272 a CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 PUBLIC SAFETY POLICE Personnel Services 4,083,030 315,244.37 - 1,642,535.48 1,650,064.34 Supplies 50,558 1,385.44 124.50 5,526.14 5,855.06 2,033 City Support Services 30,000 - - 32,003.00 - Utility Services 100,000 8,165.86 - 30,601.99 29,631.41 Operations Support 2,000 - - 92.50 98.00 Staff Support 31,350 1,990.00 - 2,602.68 3,011.74 1,894 City Assistance 13,000 225.00 - 5,135.95 1,664.98 Professional Services 8,000 - - 4,803.36 - Maintenance Services 76,949 - 179.50 19,657.48 20,926.50 8,137 Operating Equipment 63,996 7,822.45 5,196.00 27,175.56 27,737.21 4,551 Capital Outlay 169,998 - - 108,983.20 147,872.00 97,274 TOTAL POLICE 4,628,881'' 334,83312 5,500.00 1,879,117.34 1,886,861.24 113,891' FIRE RESCUE Personnel Services 2,410,836 176,775.18 - 920,219.55 945,134.52 Supplies 20,200 129.07 20.15 3,845.33 1,886.40 1,324 Utility Services 43,900 3,361.55 - 15,294.79 14,039.50 54 Operations Support 1,100 120.00 - 146.00 120.00 Staff Support 116,800 3,909.79 12,138.00 29,797.60 26,744.32 14,239 City Assistance 18,600 - 10,323.17 2,715.75 10,323.17 Professional Services 18,140 - - - 1,200.00 300 Maintenance Services 55,000 189.50 - 6,403.77 523.95 6,599 Operating Equipment 44,400 299.08 604.50 8,801.02 12,505.31 8,886 TOTAL FIRE '' 2,728,976'' 184,784.17' 23,085.82 987,223.81 1,012,477.17 31,4031 INSPECTIONS Personnel Services 364,194 27,552.62 - 132,272.94 139,749.32 Supplies 6,750 - 375.00 - 565.15 164 Utility Services 7,600 391.52 - 1,315.52 1,758.38 Operations Support 3,200 439.52 - 375.00 439.87 Staff Support 14,700 249.60 388.20 1,924.47 1,882.31 337 Professional Services 10,000 - - - - Maintenance Services - - - - - Operating Equipment - - - - - TOTAL INSPECTIONS 406,444,', 28,633.26', 763.20 135,887,93 144,395.03 501', 5 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 MARSHAL SERVICE Personnel Services 513,250 33,729.73 - 147,877.09 158,493.31 Supplies 6,450 - - 370.95 166.30 Utility Services 9,000 754.29 - 2,037.43 2,103.09 Operations Support 4,000 247.61 - - 367.49 462 Staff Support 9,400 20.00 - 2,484.74 938.61 132 Professional Services - - - - - Maintenance Services 12,400 1,198.00 - 1,863.53 2,573.00 2,500 Operating Equipment 21,480 - - - 5,508.91 4,715 Capital Outlay 65,600 - - - 41,560.29 9,700 TOTAL MARSHAL SERVICE'' 641,580'' 35,949.63 - 154,633.74 211,711.00 17,510 TOTAL PUBLIC SAFETY'' 8,405,881'' 584,200.18' 29,349.02 3,1,56,862,82 3,255,444.44 163,306 PUBLIC ENVIRONMENT STREETS Personnel Services 604,591 40,131.64 - 253,542.48 245,996.13 Supplies 6,300 147.20 28.15 1,889.72 2,674.37 840 Utility Services 101,900 18,159.66 - 30,252.57 41,148.26 823 Operations Support 1,380 - - - - Staff Support 9,265 579.47 84.08 1,947.09 2,211.30 621 Maintenance Services 155,400 10,215.82 16,620.12 35,108.91 56,283.39 12,961 Rental /Lease 200 - - - - Operating Equipment 4,200 - - - - CapitalOutlay 14,500 - - - 17,870.00 TOTAL STREETS 897,736'' 69,233.79' 16,732.35 322,740177 366,183.45 15,247, TOTAL PUBLIC ENVIRONMENT' 897,736' 69,233.79' 16,732.35 322,740.77 366,183.45 15,2471 6 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 475,862 35,252.95 - 180,970.00 182,892.93 Supplies 40,355 2,668.70 - 22,793.39 15,482.57 3,869 City Support Services - - - - - Utility Services 110,000 17,897.83 - 37,389.35 34,893.38 647 Operations Support 700 280.80 600.00 - 880.80 Staff Support 7,686 680.57 202.35 4,075.15 3,870.98 1,691 Professional Services 53,278 1,900.00 - - 9,945.00 Maintenance Services 21,000 745.36 - 26,859.09 9,597.43 1,089 Rental /Leasing 30,531 602.15 3,491.50 609.09 26,045.49 8,475 Operating Equipment 200 99.99 - 5,974.00 3,494.99 Capital Outlay 7,000 568.56 - - 2,124.50 TOTAL PARKS DEPARTMENT 746,612'' 60,696.91'' 4,293.85 278,670.07 289,228.07 15,772 SWIM POOL Supplies 16,700 - 123.66 2,295.01 413.62 347 Utility Services 25,500 2,243.77 - 8,908.72 4,601.34 Staff Support 925 - - 439.98 - Maintenance Services 199,378 - - 2,795.19 - 3,726 Rental /Lease 500 378.00 - - 378.00 TOTAL SWIM POOL 243,003 2,621.77', 123.66 14,438,90 5,392.96 4,074 COMMUNITY /CIVIC CENTER Personnel Services 115,041 7,623.46 - 31,146.52 24,198.00 Supplies 6,423 426.67 - 2,401.77 4,951.01 403 Utility Services 47,150 3,204.42 - 13,127.52 10,624.97 Operations Support 15,282 3,066.01 - 7,187.87 4,254.51 837 Staff Support 3,250 - - 157.69 250.00 243 Professional Services - 100.00 - - 925.00 Operating Equipment 7,172 - - 30,818.10 100.00 TOTAL COMMUNITY /CIVIC CNTR 1,94,318' 14,420.56' - 84,839'.47 45,303.49 1,484, 101 GENERAL FUND FINANCIAL SUMMARY SENIOR CITIZEN CENTER Supplies Utility Services City Assistence Maintenance Services TOTAL SENIOR CITIZEN CENTER'' TOTAL PARKS &,',RECREATION CULTURAL LIBRARY Personnel Services Supplies Utility Services Operations Support Staff Support Professional Services Maintenance Services Operating Equipment Capital Outlay TOTAL LIBRARY TOTAL CULTURAL' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 - - - 124.57 - - - - 274.18 174.42 - - - 3,750.00 - - - - 1,082.50 - - - - 5,231 174.42 1,1,83,933 77,739.24', 4,417.51 383,179.69 340,098.94 21,331' 667,832 51,530.09 - 16,400 44.47 - 39,500 4,933.02 - 2,500 - - 4,185 180.00 23.25 2,100 - - 3,500 - - 65,000 4,914.51 47.36 - - 10,500.00 801,017'' 611,602.09' 10,570.61 227, 896.31 258, 595.28 4,078.30 3,187.44 2,114 19,499.80 14,639.06 745.00 - 1,221.54 489.82 217 200.68 2,065.00 2,896.25 800.00 16,432.41 21,911.30 3,671 - 10,500.00 272,970.29 312,187.90 6,002 801,017' 61,602.09' 10,570.61, 272,970.29 312,187.90 6,0022 s 101 GENERAL FUND FINANCIAL SUMMARY HEALTH ANIMAL SERVICES Personnel Services Supplies Utility Services Operations Support Staff Support City Assistance Professional Services Maintenance Services Operating Equipment Capital Outlay TOTAL ANIMAL SERVICES TOTAL HEALTH'' INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services Supplies City Support Services Utility Services Staff Support Professional Services Maintenance Services Operating Equipment Capital Outlay TOTAL INFORMATION TECHNOLOGY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 302,083 22,549.50 - 108,786.24 118,737.71 51,016.73 16,727 24,900 1,604.23 42.00 6,175.95 7,110.40 3,187.13 660 9,900 901.14 - 2,505.99 3,152.30 27,684.32 33,737 800 - - 70.00 - 5,800 59.90 - 3,716.78 1,602.00 13,000 460.86 - 1,966.22 2,620.98 65 14,500 210.00 - 3,667.00 4,158.50 180 6,100 - (112.00) 390.00 786.78 1,560 9,000 - - 17.90 - 186 4,000 - - - 3,995.00 390,083 25,785.63' (70.00) 127,296.08 142,163.67 2,652' 390,083' 25,785.6,3 261,085 1,500 337,952 147,131 10,400 21,100 135,836 45,809 960,813 26, 864.52 10,600.00 8,167.61 199.50 2,955.00 2,855.09 51,641.72 (70.00) 127,296.08 142,163.67 2,652 1,813.95 1,813.95 9 89,145.18 104,120.45 129.06 403.49 76 37,317.49 51,016.73 16,727 47,734.85 37,149.65 430 2,233.35 3,187.13 227 12, 591.72 11, 250.07 1,000 41,639.48 27,684.32 33,737 230,791:13 234, 811.84 52,198 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 14,487.95 - 87,980.48 82,827.36 Supplies 1,700 - - - - 633 Human Services 46,122 2,985.52 - 18,577.77 14,831.92 1,566 Operations Support 12,545 807.99 266.28 5,399.55 3,421.29 1,065 Staff Support 11,982 - - 5,658.34 8,337.96 663 City Assistance 9,425 - - 4,160.00 2,072.00 87 Professional Services 2,500 - - - - Operating Equipment - - - 1,491.55 - TOTAL HUMAN RESOURCES 303,095,', 18,281.46', 266.28 123,267,69 111,490.53 4,015 FINANCE Personnel Services 419,818 31,762.15 - 178,406.91 159,725.65 Supplies 3,600 128.58 - 696.30 1,277.26 125 Operations Support 1,050 - - 155.80 - Staff Support 13,370 - - 2,432.00 1,830.00 3,304 Operating Equipment 1,000 - - - - 866 TOTAL FINANCE 438,838'' 31,890.73 - 181,691.01 162,832.91 4,2961 PURCHASING & ASSET MGT Personnel Services 234,220 17,851.03 - 93,678.51 90,208.87 Supplies 2,300 - - 258.42 20.30 219 Utility Services 1,200 45.91 - 141.81 87.09 Operations Support 150 - - - 60.68 Staff Support 6,900 485.00 - 2,832.80 2,600.57 715 Operating Equipment 150 - - - - TOTAL PURCHASING & ASSET MGT 244,920'' 15,381.94' - 96,911154 92,977.51 934 10 TOTAL EXPENDITURES'' REVENUE OVER(UNDER) EXPEND. 18,885,872'' 1,273,878.08' 79,202.49 6,928,149194 7,060,965.89 386,8191 546''' 4, 807, 535.01 m CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 FLEET SERVICE Personnel Services 148,533 11,495.46 - 61,186.72 62,813.08 - Supplies 101,000 7,414.02 4,701.70 40,950.00 36,149.32 8,099. City Support Services 1,500 - - 1,500.00 1,500.00 - Utility Services 7,000 342.88 - 1,238.94 1,220.74 Operations Support 400 - - - - - Staff Support 2,435 194.97 - 361.50 779.62 150. Professional Services - - - - - - Maintenance Services 45,750 1,453.07 474.24 9,120.76 19,013.06 660. Rental /Lease 200 - - - - - Operating Equipment 6,000 - - - - 650. TOTAL FLEET SERVICE 312,818,' 20,900.40', 5,175.94 1,14,357.92 121,475.82 9,559,. TOTAL INTERNAL SERVICE 2,260,484'' 141,096.25 7,256.17 747,019.29 723,588.61 71,006!. MISC & PROJECTS CITY ASSISTANCE Utility Services - - - - - Patient Assistance 5,000 - - 5,000.00 5,000.00 Children's Advocacy Assistance 5,000 - - - - Library Capital Campaign - - - - - - Senior Citizen's Hot Meals 42,000 - - - 21,000.00 21,000. TOTAL CITY ASSISTANCE '' 52,000'' - - 5,000100 26,000.00 21,000. TOTAL MISC & PROJECTS 52,000' - - 5,000.00 26,000.00 21,000,. TOTAL EXPENDITURES'' REVENUE OVER(UNDER) EXPEND. 18,885,872'' 1,273,878.08' 79,202.49 6,928,149194 7,060,965.89 386,8191 546''' 4, 807, 535.01 m CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 735,329.05 - 6,018,767.49 6,442,473.24 000 - 411200 Advalorem Tax - Delinquent 50,000 4,171.84 - 34,206.79 22,775.37 000 - 411300 Advalorem Tax - P &I 50,000 5,003.80 - 15,163.67 10,938.07 000 - 411500 Sales Tax Revenue -Gen Fund 4,071,590 470,398.73 - 1,050,974.89 1,848,077.62 000 - 411600 Bingo Tax 4,500 - - 2,639.06 981.20 000 - 411700 Mixed Beverage Tax 32,000.00 - - 15,704.85 16,729.24 TOTAL Taxes 10,912,656 1,214,903.42 - 7,137,456.75 8,341,974.74', Franchises 000 - 421200 Center Point /Entex Energy 33,000 - - 23,991.96 26,623.10 000 - 421220 City Public Service 275,000 62,691.50 - 138,822.31 146,124.73 000 - 421240 Guadalupe Valley Elec Co -op 430,000 86,926.39 - 234,006.04 211,765.14 000 - 421250 New Braunfels Utilities 30,000 - - 6,383.04 7,403.70 000 - 421300 Time Warner -State Franchise 350,000 81,851.92 - 158,262.23 169,803.13 000 - 421350 Time Warner -PEG Fee 62,000 16,370.38 - 29,999.31 32,786.97 000 - 421460 AT &T Franchise Fee 220,000 44,834.42 - 73,568.24 88,676.29 000 - 421465 AT &T PEG Fees 16,000 5,834.61 7,984.07 11,331.90 000 - 421480 Other Telecom Franchise 15,000 8,504.56 - 5,876.63 12,969.33 000 - 421500 Solid Waste Franchise Fee 90,000 - - 35,948.54 32,706.51 TOTAL Franchises 1,5211,000 307,013.78 - 714,842.37 740,190.80' Permits 000 - 431100 Home Occupation Permit 770 35.00 - 245.00 245.00 000 - 431200 Building Permit 837,952 28,814.00 - 184,786.52 755,856.83 000 - 431300 Mobile Home Permit 671 - - 80.00 80.00 000 - 431400 Signs Permit 8,596 25.00 - 150.00 235.00 000 - 431500 Food Establishmnt Permit 15,000 400.00 - 11,600.00 11,395.00 000 - 431600 Garage Sale Permit 9,554 410.00 - 3,255.30 3,160.00 000 - 431700 Plumbing Permit 109,769 13,580.00 - 29,403.50 39,422.50 000 - 431750 Electrical Permit 63,062 2,360.00 - 17,035.50 20,960.00 000 - 431800 Mechanical Permit 84,211 2,920.00 - 22,834.00 25,340.00 000 - 431900 Solicitor /Peddler Permit - 70.00 - 280.00 240.00 000 - 431950 Animal /Pet Permit 2,000 255.00 - 960.00 1,385.00 12 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 50.00 - 1,050.00 1,950.00 000 - 432100 Security Alarm Permit 36,000 3,762.00 - 16,355.00 16,323.00 000 - 435000 Fire Permit 7,750 650.00 - 2,237.50 3,387.50 TOTAL Permits,', 1,181,913 53,331.00 - 290,272.32 879,979.83' Licenses - - - 000 - 441000 Alcohol Beverage License 6,100 340.00 - 1,132.50 760.00 000 - 442000 Contractors License 55,447 2,900.00 - 14,153.00 13,975.00 000 - 444000 Pet License 3,000 306.00 - 1,987.00 1,683.10 TOTAL Licenses 64,547 3,546.00 - 17,272.50 16,418.10' Fees 000 - 451000 Municipal Court Fines 1,540,000 105,597.70 - 508,622.93 425,136.26 000 - 451100 Arrest Fee 60,000 4,001.89 - 19,874.10 18,494.66 000 - 451110 Expunction Fee 90 - - - - 000- 451200 Warrant Fees 187,500 17,652.50 - 54,181.75 50,977.26 000 - 451320 Civil Justice Fee -Court 500 5.22 7.84 27.55 000 - 451340 Judicial Fee - City 7,000 548.94 - 2,605.56 2,463.93 000 - 451400 Traffic Fine Costs TTL 30,000 1,885.71 - 10,125.13 9,274.45 000 - 451500 Teen Court Admin Fee 500 20.00 - 340.00 200.00 000 - 451510 Juvenile Case Mgmt Fee 60,000 4,564.97 - 21,703.51 20,557.52 000 - 451600 Technology Fund Fee 55,000 3,833.02 - 17,963.59 16,588.83 000 - 451700 Security Fee 40,000 2,883.78 - 13,481.81 12,450.65 000 - 451800 Time Payment Fee - City 5,000 1,015.62 - 1,577.72 2,804.74 000 - 451850 State Fines 10% Service Fee 70,000 - - 33,685.94 33,448.06 000 - 451900 DPS Payment- Local 12,250 1,374.00 - 4,349.19 4,254.23 000 - 452000 Child Safety Fee 8,000 660.47 - 3,029.84 4,501.42 000 - 452050 Indigent Defense Fee 22,500 1,731.03 - 8,326.36 7,927.67 000 - 452100 Platting Fees 66,000 5,000.00 - 20,750.00 29,000.00 000 - 452200 Site Plan Fee 26,400 - - 13,649.45 7,500.00 000 - 452300 Plan Check Fee 375,000 14,704.50 - 93,651.91 382,800.41 000 - 452310 Miscellaneous Review Fee - - - 1,200.00 - 000- 452320 Tree Mitigation Admin Fee 11,220 - - 9,213.75 - 000- 452400 BOA/Zoning Fees 11,000 350.00 - 2,800.00 1,400.00 000 - 452500 Food Handler Class 8,000 700.00 - 2,220.00 3,680.00 000 - 452600 Specific Use /Zone Chng Fee 14,630 7,500.00 - - 7,500.00 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: FEBRUARY 28th, 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 2,775.00 - 18,718.02 21,375.00 000 - 453110 Swim Pool Inspection Fee - - - - - 000- 453120 Inspections Plan Review - - - 833.00 - 000- 453200 Mowing Fees - Inspections - - - 1,302.03 8,881.16 000 - 453211 Admin Fee - Inspections - 200.00 - 2,400.00 3,500.00 000 - 453215 3% Technology Fee - - - 531.40 1.98 000 - 453310 Misc Inspection Fee - - - 40.00 40.00 000 - 453500 SubContractor Reg. Fee - 2,315.00 - 7,845.00 9,660.00 000 - 453710 Foster Care - 50.00 - - 450.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 50.00 - - 500.00 000 - 458100 Sale of Merchandise - - - - - 000- 458300 Sale of Property /Auction 20,000 647.63 - 5,733.38 1,992.58 (7E 000 - 458400 Civic Center Rental Fees 226,000 9,027.50 - 61,043.59 47,245.25 000 - 458401 Capital Recovery Fee -Civic Cntr - - - - 910.00 000 - 458450 North Center Rental Fees 24,000 870.00 - - 3,026.00 000 - 458500 Community Center Rental Fees 32,000 771.60 - 8,310.00 6,045.52 000 - 458550 Pavilion Rental Fees - 1,795.00 - - 6,058.70 000 - 458560 Chamber of Comm rent - - - - 3,900.00 000 - 458570 Non - Resident SYSA League 18,000 - - 13,800.00 7,060.00 000 - 458600 Ball Field Use - - - - 1.76 000 - 458650 NonResident User Fee -BVYA 9,000 - - - 2,820.00 000 - 458680 Tournament Fees - Soccer 14,000 - - - 2,400.00 000 - 458700 Vehicle Impoundment 5,000 - - 2,442.75 - 000- 459200 NSF Check Fee 100 40.00 - 69.00 328.00 000 - 459300 Notary Fee 200 12.00 - 84.00 162.00 000 - 459400 Maps, Copies, UDC, & Misc F 200 578.18 - 60.56 583.18 000 - 459600 Animal Adoption Fee 10,500 942.50 - 4,175.00 4,712.50 000 - 459700 Pet Impoundment Fee 17,500 1,069.00 - 7,053.00 7,624.01 000 - 459800 Police Reports Fee 6,532 454.00 - 2,568.10 2,412.20 TOTAL Fees 3,073,872 195,626.76 - 980,669.21 1,182,902.48 (75 14 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2011 000 - 493120 Donations - Public Library 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 2,143.10 - 12,064.98 10,515.84 TOTAL Fines 35,000 2,143.10 - 12,064.98 10,5115.84' Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,078 - - 7,025.92 7,025.92 000 - 473200 City of Seguin - Fire Contract 40,293 3,355.26 - 16,776.30 16,776.30 000 - 473300 Guad Co - Library 180,816 15,068.00 - 75,339.55 75,340.00 000 - 473400 Randolph AFB - Animal Cntrl 2,500 100.00 - 558.00 1,200.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 33,326.65 - 133,305.00 66,652.90 000 - 474500 Dispatch Service - SCUCISD 2,080 - - 2,080.00 - 000- 474600 School Crossing Guard - Bexar 6,600 - - 2,570.34 2,004.05 TOTAL Inter- Jurisdictional 405,672 51,849.91 - 237,655.11 168,999.17' 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 - - - 420.52 - 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 - 489000 Transfer In - - - 3.80 - 000- 490020 Transfer In -SEDC 50,000 - - - 50,000.00 TOTAL Fund Transfers'' 1,184,474 - - 261,527.09 316,615.75' Miscellaneous 000 - 491000 Interest Earned 5,000 120.44 - 2,006.84 1,405.57 000 - 491200 Investment Income 26,000 3,264.33 - 12,686.33 13,627.71 000 - 491900 Unrealized Gain /Loss - (3,389.47) - (853.75) (13,358.07) 000 - 493120 Donations - Public Library 15 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 - 493130 Donations - Writing the Next Chap. 20,000 120.00 - 8,783.78 21,728.00 000 - 493400 Donation - Animal Control 3,670 301.00 - 1,682.92 2,350.26 000 - 493401 Donations -A/C Microchip 3,000 265.00 - 1,375.00 1,100.00 000 - 493402 Donations - Spay &Neuter 12,000 1,147.05 - 4,965.50 7,212.55 000 - 493403 Donations - Melvin Boeck A. S. - - - - - 000- 493503 Donations - Fire Rescue - - - - 25.00 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,800 - - 3,705.94 - 000- 495015 Contribution from SED - - - - - 000- 497000 Misc Income -Gen Fund 40,000 210.30 - 2,733.20 30,308.34 000 - 497005 Misc Income - Publications 240,000 11,213.95 - 56,941.30 52,135.90 000 - 497007 Misc Income - Schertz Artz - - - - - 000- 497020 Misc Income -Fleet Recycled 400 - - 250.80 - 000- 497100 Misc Income - Police 20,000 467.50 - 6,648.23 2,865.75 000 - 497200 Misc Income - Library 12,131 320.25 - 4,894.01 1,309.55 000 - 497210 Misc Income - Library Copier 3,400 953.00 - 4,313.75 000 - 497300 Misc Income - Animal Control 2,400 250.80 - 787.93 727.30 000 - 497400 Misc Income - Streets Dept. 11,229 325.00 - 4,175.00 7,575.00 000 - 497500 Misc Income -TML Insurance 78,043 - - 78,042.55 49,731.90 000 - 497550 Misc Income -TML Reimbursemt 20,211 - - 14,423.16 17,643.20 000 - 497600 Misc Income - Parks /Vending Mach. 500 151.00 - 750.15 860.41 000 - 497800 Misc Income -Pool Concessions - - - - - 000- 498000 Reimbursmnt -Gen Fund 5,500 385.00 - 3,166.36 418.00 000 - 498100 Reimbursmnt Fire - Training - - - - 846.00 000 - 498110 Reimbursmnt Fire - Emg. Acti -O - - - - 8,078.07 TOTAL Miscellaneous 507,284 16,105.15 - 207,16525 210,904.19' TOTAL REVENUES, 18,886,418 1,844,519.12 - 9,858,925.58 11,868,500.90, 16 Y -T -E ENCUM GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,161,207.44 Cash in Investment Pools LOGIC Investment - General Fund 4,005,889.60 LOGIC Investment -Equip Replacement 73,225.99 LOGIC Investment -Veh Replacement 7,067.85 LOGIC Investment -Air Condi Replacment 122,228.48 CAPITAL ONE Investment - General Fund 1,323,961.95 Total Cash in Bank & Investment Pools $ 6,81,5,809.79 17 ADVALOREM TAX $2,500,000 $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 2,331,487 1,725,242 735,329 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 -10)10 $300,000 $200,000 13% -3% 230Y(0 23 0 ..........::: 11 0) o $100,000 OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 339,709 329,696 344,795 353,229 470,399 324,575 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' 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 62,692 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: FEBRUARY 28th, 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 3,319.01 - 4,461.11 3,319.01 2,100.00 - - - - 1,000.00 - - 135.00 110.00 22,300.00 3,437.99 - 5,994.78 416.65 139,014.00 6,757.00 - 144,934.89 3,845.66 5,150.00 - - - - 5,150.00 - - - - 4,750.00 - - - - 24,250.00 22.98 - 10,191.25 12,645.61 102 5,000.00 - - - 126.00 100.00 - - - - 30,500.00 - - 740.00 - 865 5,600.00 - - - - - - 455.59 306.07 455.91 2,700.00 - - - - 32,000.00 5,565.00 1,058.00 9440.7 17,075.96 2,464 1,000.00 - - - - 400.00 - - - 400.00 106,300.00 5,587.98 1,513.59 11,237.32 30,703.48 3,431' 111,450_00 5,587.98 1,513.59 11,237.32 30,703.48 3,431' REVENUE OVER(UNDER) EXPEND 27,5641.00 19 (26, 857.82)', SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 50,112.10 Cash in Investment Pools MBIA Special Events 66,494.71 Total Cash in Bank & Investment' Pools $,', 116,606.81 20 202 -WATER & SEWER FINANCIAL SUMMARY REVENUE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 Franchises 138,000 - - 34,450.00 35,061.00 Fees 13,679,750 1,123,331.84 - 4,883,473.02 5,633,402.89 Fund Transfers 480,616 - - 19,750.03 20,154.00 Miscellaneous 55,445 631.31 - 104,883.14 68,972.77 TOTALREVENUES 14,353,811 1,123,963.15 - 5,042,1556.19'' 5,757,590.66 �:1,�►1�]���1:I���J��ih�i /_1:x'1 NON DEPARTMENTAL Fund Charges /Transfers 31,000 - - - - - TOTAL NON DEPARTMENTAL 31,000 - - - - - BUSINESS OFFICE Personnel Services 458,640 33,594.99 - 136,259.11 168,973.37 - Supplies 6,550 - - 1,214.54 1,160.01 188.9; Operations Support 108,500 8,527.84 - 39,225.10 34,120.28 10,000.01 Staff Support 7,950 90.96 - 513.64 1,208.27 - Professional Services 14,500 1,037.12 - 9,257.42 4,681.44 - Fund Charges /Transfers 40,000 - - - - - Maintenance Services 12,000 840.00 - 3,950.00 2,660.00 3,360.01 Operating Equipment 6,800 98.00 - - 6,077.62 - TOTAL BUSINESS OFFICE 654,940 44,188.91 - 190,419.81 '' 218,880.99 13,548.9', W & S ADMINISTRATION Personnel Services 1,212,507 102,730.31 - 541,196.64 503,308.02 - Supplies 193,700 10,217.80 338.73 21,186.22 78,466.45 9,642.0; Human Services 338 - - - 64.00 - City Support Services 105,000 483.25 - 20,991.65 34,599.57 50.01 Utility Services 2,780,900 133,503.15 - 839,827.70 583,736.61 115,289.4; Operations Support 8,750 - 79.60 1,177.05 2,082.38 - Staff Support 33,000 976.44 1,339.00 6,723.22 9,162.53 1,718.4, City Assistance 1,912 - - 315.00 236.00 - Professional Services 175,094 611.57 9,870.00 28,382.45 55,726.98 2,447.01 Fund Charges /Transfers 2,368,176 209,951.65 - 169,557.52 798,374.20 107,153.4 - Maintenance Services 4,838,250 445,375.77 116.41 2,050,913.20 1,867,754.32 9,780.8E Other Costs 25,000 - - 23,671.50 28,911.85 - Debt Service 1,435,165 69,335.63 - 1,116,927.92 451,525.62 - Rental- Leasing 6,070 - - 2,301.89 662.53 - 21 22 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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) 8,440.99 1,865.6E Capital Outlay 58,000 - 22,432.00 - 53,341.00 25,869.01 Water Line Relocation - - - 357,830.77 - - TOTAL PUBLIC WORKS 13,254,862 973,185.57 37,5!95.74 5,177,602.73'' 4,476,393.05 273,815.8! MISC & PROJECTS PROJECTS FUND CHARGES /TRANSFERS - - - - - - TOTAL PROJECTS '' AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services 19,000 - - - - - Operations Support 500 - - - - - Professional Services 47,850 3,213.38 - 29,368.53 22,128.57 - Maintenance Services 335,500 280.93 - 145,754.08 10,018.78 - TOTAL AVIATION HEIGHTS WTR IMP 402,850 3,494.31 - 175,,122.61 32,147.35 - FM3009 RD &BRIDGE EXPANSION Professional Services - - 19,137.50 - 30,358.80 - Maintenance Services - 8.71 - 547,202.99 37.74 - TOTAL FM3009 RD &BRIDGE EXPANSION - 8.71 19,138 547,203 30,396.54 - TOTALL'MISC &'PROJECTS 402,850 3,503.02 19,137.50 722,325.60 62,543.89 - TOTAL EXPENDITURES 14,343,652 1,020,878 56,733 6,0,90,348 4,757,818 287,36: — REVENUE OVER(UNDER)EXPENSES ** 10,159 999,772.73 22 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 35,061.00 TOTAL Franchises 138,000 - - 34,450.00 35,061.00' Fees 000 - 455200 Garbage Collection Fee 3,300,000 246,759.07 - 1,205,665.98 1,325,198.05 000 - 455600 Fire Line Fees 18,500 - - 18,190.00 18,430.00 000 - 455700 Recycle Fee Revenue 155,000 15,820.33 - 60,067.85 80,346.74 000 - 455800 W &S Line Constructn Reimbursemnt 50,000 1,112.00 - 10,022.76 13,715.79 000 - 457100 Sale of Water 7,200,000 646,527.27 - 2,269,875.09 2,874,962.87 000 - 457110 Edwards Water Lease 127,250 - - 4,573.80 132,707.46 000 - 457120 Water Transfer Charge -Selma 5,000 1,339.20 - 780.18 1,339.20 000 - 457130 Water Transfer Charge -U. C. 1,000 1.28 - 3,914.06 1.28 000 - 457200 Sale of Meters 86,000 2,991.74 - 18,271.98 35,875.45 000 - 457400 Sewer Charges 2,560,000 195,652.01 - 1,220,836.37 1,078,014.63 000 - 457500 Water Penalties 175,000 13,006.01 - 70,191.32 71,849.20 000 - 459200 NSF Check Fee -Water &Sewer 2,000 122.93 - 1,083.63 962.22 TOTAL Fees 13,679,750 1,123,331.84 - 4,883,473.02 5,633,402.89' 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 - - 9,615.86 4,431.88 000 - 491000 Interest Earned 500 38.42 - 162.21 1,066.50 000 - 491200 Investment Income 5,000 492.39 - 33,205.72 6,343.21 000 - 493130 Library Donations - - - 3.53 - 000- 493400 Donations - Christmas Activitise - - - - 1,000.00 000 - 497000 Misc Income -W &S 20,000 100.50 - 36,730.81 (1,893.91) 000 - 497550 TML Reimbursements - - - - 2,291.34 000 - 498100 Reimbursement -EMS Loan 9,945 - - - - 000- 498110 Reimbursement -SSLGC - - - 25,165.01 50,615.45 000 - 498200 W &S Project Reimbursement 5,000 - - - 5,118.30 TOTAL Miscellaneous 55,445 631.31 - 104,883.14 68,972.77', TOTAL REVENUES 14,353,811' 1,123,963.15 - 5,042,556.19 5,757,590.66' 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 418,956.94 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,490,126.91 293,247.80 372,538.44 543,205.56 1,044,420.00 $3,743,538.71 Total Cash in Bank & Investment Pools $4,162,495.65 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: FEBRUARY 28th, 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,170.00 - 1,750,012.93 1,552,333.37 - 1,432,345 68,250.58 - 639,108.51 865,262.05 - 334,850 18,504.04 - 72,939.88 80,643.42 - 7,203,732 88,924.62 - 2,462,061.32 2,498,238.84 - 2,391,410 213,469.99 - 1,076,034.27 1,081,717.76 - 327,874 10,172.33 382.34 151,904.17 114,614.94 40,824.47 847 134.00 - - 580.00 - 15,000 - - 14,850.78 10,902.09 - 80,438 7,584.30 - 27,930.84 31,534.88 - 31,500 504.41 - 18,376.49 24,260.65 815.48 75,600 6,223.13 171.35 39,867.90 27,539.10 12,869.75 7,753 - - 2,171.05 3,016.00 479.00 136,390 5,176.49 160.00 41,291.88 43,712.34 7,480.60 3,576,092 - - 1,620,247.66 29,475.00 - 42,320 5,629.76 - 18,967.16 15,671.16 2,401.36 248,502 - - 9,523.75 69,799.33 - 40,000 - - 4,011.03 836.33 - 82,600 1,497.50 - 28,021.32 6,074.82 7,947.19 7,056,326 250,391.91 713.69 3,053,198.30 1,459,734.40 72,817.85 TOTAL EXPENDITURES 7,056326 250,391.91 713.69 3,053,198.30 1,459,734.40 72',817.85 REVENUE OVER(UNDER), EXPENSES " 147,406 1,038,504.44 25 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 000 - 456100 Ambulance /Mileage Transprt 5,336,537 - - 1,742,140.93 1,534,343.37 - 000- 456110 Subscription Program Fees 100,000 2,170.00 - 7,852.00 17,990.00 - 000- 459200 NSF Check Fee - - - 20.00 - - TOTAL Fees 5,436,537 2,170.00 - 1,750,012.93 1,552,333.37 - Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 286,126 68,250.58 - 119,219.35 341,803.07 - 000- 474300 Cibolo Support 219,699 - - 106,650.00 106,650.00 - 000- 475100 Comal Co ESD #6 75,369 - - - 666.56 - 000- 475200 Live Oak Support 152,569 - - 74,062.50 74,062.50 - 000- 475300 Universal City Support 210,545 - - 102,206.26 102,206.26 - 000- 475400 Selma Support 64,689 - - 31,402.50 34,365.00 - 000- 475500 Schertz Support 399,083 - - 193,729.74 193,729.74 - 000- 475600 Santa Clara Support 10,851 - - 5,326.58 5,267.34 - 000- 475800 Marion Support 13,414 - - 6,511.58 6,511.58 - TOTAL Inter - Jurisdictional 1,432,345 6,8,250.58 -_ 639,108.51 865,262.05 - Miscellaneous 000 - 491000 Interest Earned - - - - - - 000- 491200 Investment Income - 40.56 - 98.17 283.84 - 000- 493203 Donations -EMS 6,000 - - 706.00 1,100.00 - 000- 497000 Misc Income 150,000 4,133.48 - 41,515.71 36,369.58 - 000- 497100 Recovery of Bad Debt 100,000 880.00 - - 7,230.00 - 000- 497500 Misc Income -EMT Classes 78,850 13,450.00 - 30,620.00 35,660.00 - TOTAL Miscellaneous 334,850 18,504.04 - 72,939.88 80,643.42 - TOTAL REVENUES 7,203,732 88,924.62 - 2,462,06132 2,498,238.84 - 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ (297,133.99) Cash in Investment Pools LOGIC Investment -EMS MBIA Investment -EMS Note 2010 300,476.95 Total Cash in Bank & Investment Pools $ 3,342.96'' 27 204-DRAINAGE FINANCIAL SUMMARY REVENUE SUMMARY Fees Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services Supplies Human Services City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges/Transfers Maintenance Services Other costs Debt Service Rental /Leasing TOTAL DRAINAGE TOTAL EXPENDITURES CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2011 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D I BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR E 675,300 49,716.16 - 271,886.84 285,720.93 - 3 1,300 77.46 - 364.10 547.53 - _ 676,600 49,793.62 '' - 272,250194 286,268.46 - 3 361,183 26,478.92 - 143,462.03 145,977.29 - 2 8,300 142.37 28.15 900.98 469.24 258.60 100 - - - - - 26,500 2,500.00 - 976.00 4,332.18 - 12,888 1,105.39 - 3,958.17 4,235.98 470.83 2,458 - - - - - 8,255 264.22 168.83 1,475.09 1,281.14 733.35 840 - - 102.00 15.00 - 19,800 10,000.00 - 5,197.10 10,000.00 - 195,449 - - 32,328.33 32,662.25 - 1 22,000 - - 4,257.95 1,987.00 - 100 100.00 - 100.00 100.00 - 18,138 - - 2,183.45 1,918.78 - 500 - - - - - _ 676,511'' 40,590.90 '' 196.98'' 1!94,941.10 202,978.86 1,462.78 4 676,511'' 40,590.90 '' 196.98'' 1!94,941.10 202,978.86 1,462.78 4 "" REVENUE OVER(UNDER) EXPEND 89' 2s 83,289.60'' 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: FEBRUARY 28th, 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 336.21 671,800 49,379.95 675,300, 49,716.16,', 100 16.64 600 51.58 600 9.24 1,300 77.46' 676,600 49,793.62 29 1,584.86 270,301.98 271, 886,.84 10.59 282.69 70.82 364.10 1,820.90 283,900.03 285,720.93, 147.04 289.67 110.82 547.53 272,250;94 286,268.46' - 387 — 3K 39C DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking 195,841.87 Cash in Investment Pools Lone Star Investment - Drainage Maint Fund 282,745.11 Total Cash in Bank & Investment Pools $ 478,586.98 30 314 -HOTEL TAX FINANCIAL SUMMARY REVENUE SUMMARY Taxes Fund Transfers Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services City Support Services Operations Support Professional Services Fund Charges/Transfers Operating Equipment Capital Outlay TOTAL NONDEPARTMENTAL' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 35,957.66 - 98,085.24 125,504.15 - 55,000 - - - - - 5,550 24.76 - 192.50 200.44 445,550 35,982.42 - 98,277.74 125,704.59 - 31,841 - - - - - 78,228 - 502.85 32,027.50 29,616.85 - 88,424 2,218.50 - - 5,952.88 - 2,500 - - 902.28 - - 231,485 - - 117,152.00 42,555.25 - 432,478'' 2,218.50 502.85'' 150,081.78 78,124.98 TOTAL EXPENDITURES 432,478'' 2,218.50 502.85'' 150,081.78 78,124.98 REVENUE OVER(UNDER)'EXPENDITURE 13,072 47,579.61 31 32 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 35,957.66 - 98,085.24 125,504.15 - 259, TOTAL Taxes 385,000 35,957.66 - 98,, 085.24 125, 504.15 - 259, Fund Transfers 000 - 481000 Transfer From Reserve 55,000 - - - - - 55, TOTAL Fund Transfers 55,000 - - - - - 55, Miscellaneous 000 - 491000 Interest Earned 250 13.77 - 141.89 137.27 - 000- 491200 Investment Interest 300 10.99 - 50.61 63.17 - 000- 497000 Misc Income 5,000 - - - - - 5, TOTAL Miscellaneous', 5,550 24.76 - 192.50 200.44 - 5, TOTAL REVENUES 445,550 35,982.42 - 98;277.74 125,704.59 - 319, 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 165,756.31 Cash in Investment Pools Federated Investment -Hotel /Motel 78,064.97 Total Cash in Bank '& Investment Pools' $'243,821.28' 33 HOTEL OCCUPANCY TAX 2010 -11 27,689 25,112 23,231 19,619 2009 -10 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 4 2008 -09 17,549 20,134 18,461 17,255 15,138 19,297 19,548 24,769 29,695 2007 -08 19,122 21,531 20,663 19,204 17,475 20,760 25,081 24,748 23,122 2006 -07 18,245 18,817 18,521 15,970 17,948 19,220 24,257 22,590 22,959 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: FEBRUARY 28th, 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 - - 10,000.00 - 40,000 - - 52,311.25 - 405 43.32 - 240.46 324.37 80,405 43.32 - 62,551.71 324.37 - PARKLAND DEDICATION Maintenance Services- Landscape 8,000 - - (71.64) - 12,234.0 Operating Equipment 30,000 6,871.65 11,244.23 36,231.98 37,359.95 5,881.9 Capital Outlay 6,000 - - - 4,980.30 - TOTAL PARKLAND DEDICATION 44,000 6,871'J65 11,244.23 36,160.34'' 42,340.25 18,115.9 TREE MITIGATION Fund Charges/Transfers Maintenance Services -Trees Capital Outlay TOTAL TREE MITIGATION TOTAL EXPENDITURES - - - 4,133.27 - - 36,000 195.00 3,133.00 26,750.00 18,171.00 - 36,000 195.00 3,133.00 30,883.27 18,171.00 80,000 7,066:65 14,377.23 67,043.61' 60,511.25 18,115.!9 REVENUE OVER(UNDER) EXPEND' 405' 35 (60,186.88)' 317 -PARK REVENUES Fees 000 - 458800 Parkland Dedication 000 - 458900 Tree Mitigation TOTAL Fees Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Interest 000 - 497000 Miscellaneous Income TOTAL Miscellaneous' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 ENCUMBRA 40,000 - - 10,000.00 - 40,000 - - 52,311.25 - 80,000 - - 62,311.25 - 60 10.77 - 22.33 137.28 280 32.55 - 163.13 187.09 65 - - 55.00 - 405 43.32 240.46 324.37 TOTAL REVENUES 80,405 43.32 62,551.71 324.37 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $107,575.81 Cash in Investment Pools Federated Investment -Park Fund 38,823.24 Federated Investment -Tree Mitigation 192,345.04 Total in Investment Pool 231,168.28 Total Cash in Bank !& Investment' Pools $338,744.09'' 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: FEBRUARY 28th, 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 - - 6,567.02 - - 56,000 - - 6,567.02'' - - 56,000 - - 6,567.02'' - - 38 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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: FEBRUARY 28th, 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 ri11561rTM0 9:1091111". CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 81,619.34 - 288,076.02 1,012,803.85 - 585,500 (624.69) - 15,193.98 82,866.62 - 1,776,140 80,994.65 - 303,270.00 1,095,670.47 - 1,000 - - - - - 29,800 351.62 - - 1,410.78 - - - - 118,896.50 - - - - 8,428.00 - 8,428.00 - 30,800 351.62 8,428.00 118,896.50' 9,838.78 - 7,200 10,800.00 53,183.36 180.00 63,983.36 - 600,000 - - - - - - 288.00 - 455,686.58 204,531.74 - 87,895 87,881.95 225,148.72 88,806.01 313,030.67 - 695,095 98,969.95 278,332.08 544,672.59'' 581,545.77 - 725,895 99,321.57 286,760.08 663,569.09' 591,384.55 - REVENUE OVER(UNDER) EXPENDITURES' 1,050,245' 41 504,2,86 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 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 46,032.00 - 209,129.84 667,651.34 000 - 455910 Capital Recovery -Waste Wtr 272,800 35,587.34 - 78,946.18 344,552.51 000 - 455911 Capital Recovery-Wste Wtr Zone 1 13,640 - - - - 000- 455913 Cap Recovery-North Sewer Tr - - - - 600.00 TOTAL Fees 1,190,640 81, 619.34 - 288, 076.02 1,012,803.85 Fund Transfers 000 - 481000 Transfer from Reserves 000 - 486100 Transfer In TOTAL Fund Transfers Miscellaneous 000 - 491000 Interest Earned 2,000 31.11 - 340.31 241.22 000 - 491200 Investment Income 250,000 3,368.48 - 2,353.70 15,382.65 000 - 491900 Unrealized Gain /Loss -Cap One - (4,024.28) - - (16,132.25) 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 TOTAL Miscellaneous 585,500 (624.69) - 15,193.98 82,866.62 TOTALREVENUES 1,776,140 80,994.65 - 303,270.00 1 „095,670.47' 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 389,595.35 Cash in Investments: Lone Star Investment - Capital Recovery 261,463.23 Capital One - Investment 1,695,915.07 Schertz Bank & Trust - Certificate of Deposit 523,634.70 Total Cash in Bank & Investment Pools $2,870,608.35 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: FEBRUARY 28th, 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 374,644.80 - 3,200,662.56 3,236,286.08 - 243,000 - - - - - 3,000 107.59 - 1,610.85 708.11 - 3,614,794 374,752.39 - 3,202,273.41 3,236,994.19 - 3,200 - - 1,000.00 - - 3,611,124 - - 2,445,857.55 2,558,340.59 - 3,614,324 - - 2,446,857.55 2,558,340.59 TOTAL EXPENDITURES 3,614,324 - - 2,446,857.55'' 2,558,340.59 - " REVENUE OVER(UNDER), EXPEND 470 678,653.60 44 505 -TAX I & S REVENUES Taxes 000 - 411900 Property Tax Revenue TOTAL Taxes Fund Transfers 000 - 486000 Transfer From Reserves 000 - 486103 Transfer In TOTAL Fund Transfers Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Earnings TOTAL Miscellaneous TOTAL'REVEN,UES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2011 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMB 3,368,794 374,644.80 - 3,200,662.56 3,236,286.08 3,368,794 374,644.80 - 3,200,662.56 3,236,286.08 243,000 - - - - 243,000 - - - 1,500 - - 784.43 224.83 1,500 107.59 - 826.42 483.28 3,000 107.59 - 11,610.85 708,11'' 3,614,794 374,752.39 - 3,202,273.41' 3,236,994,119' 4s 505 -TAX I & S GENERAL GOVERNMENT NON DEPARTMENTAL Professional Services 101 - 541500 Paying Agent TOTAL Professional Services' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2011 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -I BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUN 3,200 3,200 - 1,000.00 1,000.00 Debt Service 101 - 555612 Schertz C O SR2001- Principal 210,000 - - 200,000.00 285,000.00 101 - 555612.1 Schertz CO BOND, 2001 - Interest 141,318 - - 77,090.00 37,977.08 101 - 555622 Schertz C O SR2003- Principal 190,000 - - 180,000.00 190,000.00 101 - 555622.1 Schertz C O SR2003- Interest 60,820 - - 35,360.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 - - 143,168.14 136,058.76 101 - 555626 LS &D SR2006- Principal - - - 100,000.00 - 101- 555626.1 LS &D SR2006- Interest 650,982 - - 327,490.64 325,490.64 101 - 555628 CO Bond 2007 - Principal 99,567 - - - 13,451.11 101 - 555628.1 CO Bond 2007 - Interest 26,617 - - - - 101- 555629 GO Bond 2007 - Principal 275,000 - - 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 - - 235,000.00 355,000.00 101 - 555630.1 GO Bond SR2008 Interest 379,651 - - 198,343.25 193,490.50 101 - 555631 GO Bond SR2009 Principal 140,000 - - 80,000.00 140,000.00 101 - 555631.1 BO Bond SR2009 Interest 283,063 - - 167,073.96 142,406.25 TOTAL Debt Service 3,61,1,124 - - 2,445,857,55 2,558,340.59' TOTAL EXPENDITURES 3,614,324 - - 2,446,857,55 2,558,340.59 46 TAX I &S CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 33,091.57 Cash in Investment Pools Federated Investment -Tax I &S 931,776.33 Total Cash in Bank & Investment Pools $' 964,867.90' 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: FEBRUARY 28th, 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 235,199.37 - 525,487.44 924,038.80 - 108,000 93.98 - 15,616.72 4,649.47 - 2,143, 795 23!5,293.35 - 541,1, 04.16 928,688.27 - 21,000 2,286.99 623.28 5,576.87 10,142.72 1,165.26 85,800 8,586.50 - 29,307.20 22,322.66 - 67,300 1,218.33 5,965.50 25,731.45 29,672.56 5,374.79 8,498 - - 14,869.00 6,999.31 - - - 6,999.31 - - - 182,598 12,091.82 13,588.09 75,484.52 69,137.25 6,540.05 202,062 8,647.61 - 110,301.25 57,644.66 - 1,000 - - 131.75 509.32 30.91 100 - - - - - 34,500 4,241.38 623.92 13,053.98 8,994.12 437.46 4,850 90.01 - 1,243.19 1,003.72 50.00 76,100 17,388.64 3,242.89 31,252.67 37,908.71 748.42 97,000 2,813.77 1,782.11 75,879.61 62,040.06 1,497.98 80,000 - - - - - 349,000 29,104.55 21,340.80 106,377.51 96,245.72 597.06 105,432 - - 13,875.00 63,858.00 - 216,000 - - - - - - - - 781.89 - - 792,432 - - 355,322.21 606,911.25 - 1,500 - - 62,088.15 - - 1,959,976 62,285.96 26,989.72 770,307.21 935,115.56' 3,361.83 TOTAL EXPENDITURES 2,142,574 74,377.78 40,577.81 845,791.73 1,004,252.81'' 9,901.88'' " REVENUE'OVER(UNDER) EXPEND 1,221 '' (75,564.54)' 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: FEBRUARY 28th, 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 235,199.37 2,035,795 235,199.37 1,000 4.42 12,000 43.06 15,000 46.50 80,000 - 108,000 93.98', 525,487.44 924,038.80 525,487.44 924,038.80 - 290.14 37.59 - 13,732.27 4,258.08 - 1,594.31 353.80 15,616.72 4,649.47', TOTAL REVENUES'' 2,143,795 235,293.35 - 541,104.16 92!8,688.27 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 97,934.14 Cash in Investment Pools MBIA Investment - Economic Development Corp 15,184.52 MBIA- Investment -Sysco Infrastructure 150,389.40 MBIA- Investment -EDC Notes 2010 153,491.51 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,949,300.34 50 4B SALES TAX $300,000 $250,000 $200,000 14% -2% 24° 2 /o $150,000 $100,000 $50,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 171,042 166,132 173,802 177,864 235,199 2009 -10 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 1E 2008 -09 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 1E 2007 -08 168,374 175,427 156,274 163,899 210,937 165,065 143,668 177,527 168,047 1E 2006 -07 139,231 152,929 133,224 140,960 179,416 118,361 125,387 159,802 150,107 1 E 51 m Be NA .i� W �2yq it NOW& werAM111W 'ill-i-WoRg"M 21� "m I&M L ' m on.1 It tZ� lill�111111111�!111 I 1 '11 M .1, ft Vlk%ja r-A