Loading...
06-MARCH 2011 STATEMENTMARCH 2011 Financial Report CITY OF S CHERTZ Prepared By: The Finance Department April 21, 2011 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 517,890.89 - 7,542,680.24 8,861,066.43 Franchises 1,521,000 15,237.43 - 721,227.18 766,058.99 Permits 1,181,913 179,421.00 - 437,555.32 1,059,400.83 Licenses 64,547 3,880.00 - 20,830.50 20,298.10 Fees 3,073,872 277,611.75 - 1,258,768.60 1,460,514.23 Fines 35,000 2,272.78 - 14,976.13 12,788.62 Inter- Jurisdictional 405,672 19,542.61 - 256,670.32 188,541.78 Fund Transfers 1,184,474 291,987.80 - 583,496.59 608,603.55 Miscellaneous 507,284 25,188.46 - 239,089.86 249,520.64 TOTAL REVENUES 18,886,418 1,333,032.72' - 11,075,294.74 13,226,793.17 EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 22,800 1,813.46 - 3,107.37 10,838.34 Supplies 500 74.03 - 37.66 120.03 119 City Support Services 20,500 212.69 - 8,415.70 12,932.87 50 Operations Support 300 - - 74.08 - 127 Staff Support 16,400 554.60 380.00 7,562.59 9,971.85 60 Opertating Equipment - - - - - TOTAL CITY COUNCIL 60,500'' 2,654.78' 380.00 19,197.40 33,863.09 357 CITY MANAGER Personnel Services 718,457 58,474.27 - 316,496.34 336,287.49 Supplies 826 (683.73) - 606.09 671.07 39 City Support Services - - - 32.00 - Operations Support - - - - - Staff Support 25,550 2,610.25 438.80 6,414.60 13,938.93 1,248 Operating Equipment 1,574 1,079.94 - - 1,393.36 899 TOTAL CITY MANAGER 746,407'' 61,48073' 438.8!0 323,549.03 352,290.85 2,188 1 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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,737.96 - 102,049.25 113,387.90 Supplies 3,200 42.93 - 246.90 644.76 203 City Support Services 1,000 - - - - Operations Support 3,000 - - 673.00 1,166.00 Staff Support 6,200 187.65 33.44 1,829.99 1,337.04 141 Court Support 800 - - - - Professional Services 84,600 3,596.25 - 24,143.98 25,200.00 15,531 Maintenance Services 2,500 50.00 - - 350.00 Operating Equipment 2,000 - - 141.98 500.00 TOTAL MUNICIPAL COURT'' 353,503'' 22,614.79 33.44 129,085.10 142,585.70 15,8761 CUSTOMER RELATIONS -311 Personnel Services 88,928 6,325.78 - 44,334.05 38,855.75 Supplies 500 49.84 - - 49.84 13 Staff Support 1,105 - - - - 643 TOTAL CUSTOMER, RELATIONS -31,1 90,533,', 6,375.62', - 44,334!.05 38,905.59 656', PLANNING & ZONING Personnel Services 134,105 9,996.51 - 59,131.41 61,528.60 Supplies 4,500 43.68 - 64.30 117.04 City Support Services - - - - - Operations Support 2,300 - - 183.16 77.95 Staff Support 22,100 200.12 1,527.12 6,779.27 3,232.12 Professional Services 142,300 19,341.29 - - 47,988.68 76 Operating Equipment 600 - - 217.65 1,055.00 TOTAL PLANNING &'ZONING 305,905'' 29,581.60' 1,527.12 66,375179 113,999.39 76. LEGAL SERVICES Operations Support 13,000 - - 7,624.24 8,117.96 Professional Services 245,000 22,170.30 - 55,860.64 64,688.43 TOTAL LEGAL SERVICES 258,000,', 22,170.30', - 63,484.88 72,806.39 z 101 GENERAL FUND FINANCIAL SUMMARY FACILITIES MAINTENANCE Personnel Services Supplies Utility Services Operations Support Staff Support Maintenance Services Rental /Leasing Operating Equipment Capital Outlay TOTAL FACILITIES MAINTENANCE CITY SECRETARY Personnel Services Supplies City Support Services Operations Support Staff Support TOTAL CITY SECRETARY NON - DEPARTMENTAL CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 630,024 46,761.70 - 59,900 6,991.67 638.43 93,600 7,666.01 - 10,212 1,156.25 403.00 108,500 11,270.47 6,471.04 2,000 - - 950 289.45 - 24,500 - - 929,686 74,135.55 7,512.47 270,197.15 297,375.87 26,039.60 35,294.90 6,827 44,081.15 34,653.34 141 3,143.52 6,279.14 479 48,933.51 72,396.43 7,015 568.35 763.92 - 289.45 392,963.28 447,053.05 14,463 167,842 12,289.86 - 74,943.13 76,831.81 1,550 258.17 - 304.42 1,018.95 9,780 2,038.00 - 4,003.11 3,440.00 5,700 1,237.30 295.00 2,214.18 3,291.77 1184,872' 15,823.33' 295.0,0 81,464!.84 84,582.53 31 Supplies 3,000 55.92 - 2,318.32 251.36 City Support Services 361,407 34,292.24 760.00 283,190.52 246,823.36 Operations Support 115,500 26,997.82 - 68,345.09 69,519.49 236 City Assistance 390,552 32,390.29 - 329,882.80 229,212.73 Professional Services 104,850 4,208.09 - 58,519.77 51,407.93 100 Fund Chrgs /Transfrs -Spec Events Fnd 24,350 - - 49,100.00 - Operating Equipment 500 - - 264.95 Capital Outlay 7,000 - - 13,015.43 - TOTAL NON- DEPARTMENTAL 1,007,159' 97,944.36' 760.00 804,636!88 597,214.87 336 PUBLIC AFFAIRS Personnel Services 131,096 11,477.42 - 90,767.93 67,332.12 Supplies 2,450 330.18 - 1,507.78 460.05 22 Operations Support 41,500 1,526.03 - 32,108.89 8,114.02 1,180 Staff Support 3,750 82.03 - 1,580.24 1,084.90 27 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,921.97 3,300 - 1,050 - 2,000 - 123,708'' 8,921.97' TOTAL GENERAL GOVERNMENT 4,894,738,' 401,425.24 - 51, 554.25 53, 332.93 - - - 1,383 - 51, 554125 53, 332.93 1,383 1,0,946.83 2,324,161,53 2,302,055.60 39,899 a CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 - - - 117,184.11 - 6,000 1,894.78 - 1,089.90 1,894.78 184,796'' 15,310.44 - 244,238185 78,885.87 1,229 46,317 3,504.37 - 20,198.39 21,494.35 900 - - - 75.00 11 1,500 381.90 - 640.00 641.90 15,000 301.00 - 2,748.55 6,465.14 63,717' 4,187.27' - 23,586.94 28,676.39 11' 126,426 9,865.01 - - 56,325.64 1,000 - - - - 23 258,500 17,402.86 - - 116,025.26 2,650 385,926' 27,267.87, - - 172,350.90 2,673', 169,469 12,356.68 - 73,434.51 75,649.46 300 - - 33.05 8.35 55 2,213 - - 612.00 395.00 24,000 - - 4,410.68 6,710.00 4,044 599.95 - 1,200.00 2,745.24 200,026' 12,956.63' - 79,690.24 85,508.05 55 117,358 8,921.97 3,300 - 1,050 - 2,000 - 123,708'' 8,921.97' TOTAL GENERAL GOVERNMENT 4,894,738,' 401,425.24 - 51, 554.25 53, 332.93 - - - 1,383 - 51, 554125 53, 332.93 1,383 1,0,946.83 2,324,161,53 2,302,055.60 39,899 a CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 PUBLIC SAFETY POLICE Personnel Services 4,083,030 310,298.91 - 1,910,883.39 1,960,363.25 Supplies 50,558 1,457.52 124.50 7,644.43 7,312.58 834 City Support Services 30,000 - - 32,003.00 - Utility Services 100,000 8,479.10 - 37,437.40 38,110.51 Operations Support 2,000 - - 92.50 98.00 Staff Support 31,350 816.91 - 2,710.40 3,828.65 1,833 City Assistance 13,000 - - 5,135.95 1,664.98 Professional Services 8,000 - - 4,803.36 - Maintenance Services 76,949 8,145.35 179.50 32,351.48 29,071.85 Operating Equipment 63,996 3,997.91 5,196.00 27,175.56 31,735.12 8,306 Capital Outlay 169,998 - - 108,983.20 147,872.00 5,854 TOTAL POLICE 4,628,881'' 333,19570 5,500.00 2,169,220,67 2,220,056.94 16,828 FIRE RESCUE Personnel Services 2,410,836 179,819.27 - 1,061,015.11 1,124,953.79 Supplies 20,200 1,346.59 20.15 5,042.47 3,232.99 879 Utility Services 43,900 4,889.16 - 19,174.01 18,928.66 Operations Support 1,100 - - 299.97 120.00 Staff Support 116,800 15,513.78 12,138.00 30,264.50 42,258.10 7,385 City Assistance 18,600 - 10,323.17 2,715.75 10,323.17 Professional Services 18,140 300.00 - - 1,500.00 Maintenance Services 55,000 9,075.06 - 9,486.77 9,599.01 16,268 Operating Equipment 44,400 1,311.45 604.50 14,810.75 13,816.76 12,808 TOTAL FIRE '' 2,728,976'' 212,255.311' 23,085.82 1,142,809.33 1,224,732.48 37,3411 INSPECTIONS Personnel Services 364,194 27,550.36 - 155,031.32 167,299.68 Supplies 6,750 25.06 375.00 7.90 590.21 322 Utility Services 7,600 360.98 - 1,611.99 2,119.36 Operations Support 3,200 - - 375.00 439.87 Staff Support 14,700 337.64 388.20 2,261.07 2,219.95 355 Professional Services 10,000 - - 459.00 - Maintenance Services - - - - - Operating Equipment - - - - - TOTAL INSPECTIONS 406,444' 28,274.04' 763.20 1159,746,28 172,669.07 678 5 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 MARSHAL SERVICE Personnel Services 513,250 36,698.37 - 171,079.25 195,191.68 Supplies 6,450 - - 421.30 166.30 60 Utility Services 9,000 722.17 - 2,474.58 2,825.26 Operations Support 4,000 - - - 367.49 462 Staff Support 9,400 613.63 - 2,542.04 1,552.24 268 Professional Services - - - - - Maintenance Services 12,400 2,766.00 - 1,895.53 5,339.00 1,064 Operating Equipment 21,480 209.16 - - 5,718.07 5,188 Capital Outlay 65,600 - - - 41,560.29 14,810 TOTAL MARSHAL SERVICE'' 641,580'' 41,009.33 - 178,412.70 252,720.33 21,856 TOTAL PUBLIC SAFETY'' 8,405,881'' 614,734.38' 29,349.02 3,650,188,98 3,870,178.82 76,705. PUBLIC ENVIRONMENT STREETS Personnel Services 604,591 39,910.65 - 287,396.25 285,906.78 Supplies 6,300 681.78 28.15 2,026.48 2,459.39 667 Utility Services 101,900 4,027.07 - 43,748.16 45,175.33 1,237 Operations Support 1,380 - - - - Staff Support 9,265 721.36 84.08 2,881.38 2,932.66 604 Maintenance Services 155,400 12,934.10 16,620.12 42,108.02 70,114.25 7,825 Rental /Lease 200 - - - - Operating Equipment 4,200 - - - - CapitalOutlay 14,500 - - - 17,870.00 TOTAL STREETS 897,736'' 58,274.96' 16,732.35 378,160129 424,458.41 10,334, TOTAL PUBLIC ENVIRONMENT' 897,736' 58,274.96' 16,732.35 378,160.29 424,458.41 10,3341 6 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 475,862 35,337.31 - 210,264.69 218,230.24 Supplies 40,355 3,930.02 - 26,159.70 19,412.59 1,944 City Support Services - - - - - Utility Services 110,000 9,812.91 - 44,635.56 44,706.29 1,026 Operations Support 700 - 600.00 - 880.80 Staff Support 7,686 1,671.19 202.35 4,905.72 5,542.17 315 Professional Services 53,278 - - - 9,945.00 1,900 Maintenance Services 21,000 807.10 - 30,202.63 10,404.53 539 Rental /Leasing 30,531 5,315.07 3,491.50 733.42 31,360.56 3,225 Operating Equipment 200 - - 5,974.00 3,494.99 Capital Outlay 7,000 - - - 2,124.50 769 TOTAL PARKS DEPARTMENT 746,612'' 56,873.60 4,293.85 322,875:72 346,101.67 9,720 SWIM POOL Supplies 16,700 474.93 123.66 2,950.36 888.55 Utility Services 25,500 980.37 - 10,852.76 5,581.71 Staff Support 925 - - 439.98 - Maintenance Services 199,378 4,211.94 - 2,912.53 4,211.94 Rental /Lease 500 - - - 378.00 TOTAL SWIM,', POOL 243,003,' 5,667.24', 123.66 17,155,63 11,060.20 COMMUNITY /CIVIC CENTER Personnel Services 115,041 7,199.77 - 35,842.65 31,397.77 Supplies 6,423 396.01 - 2,906.95 5,347.02 44 Utility Services 47,150 3,302.57 - 16,145.85 13,927.54 Operations Support 14,682 260.00 - 11,571.41 4,514.51 1,567 Staff Support 3,250 - - 187.69 250.00 243 Professional Services 600 - - - 925.00 Operating Equipment 7,172 185.00 - 32,238.10 285.00 TOTAL COMMUNITY /CIVIC CNTR 194,318' 11,343.35, - 98,892'.65 56,646.84 1,855, 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: MARCH 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 - - - 124.57 - - - - 597.68 174.42 - - - 3,750.00 - - - - 1,082.50 - - - - 5,554,75 174.42 1,1,83,933,' 73,884.19', 4,417.51 444,478.75 413,983.13 11,576 667,832 51,810.29 - 16,400 1,795.76 - 39,500 3,973.18 - 2,500 70.00 - 4,185 210.69 23.25 2,100 - - 3,500 400.00 - 65,000 522.39 47.36 - - 10,500.00 801,017'' 58,782.31'' 10,570.61 269,742.07 310,405.57 5,154.37 4,983.20 338 23, 582.09 18, 612.24 745.00 70.00 1,278.54 700.51 83 200.68 2,065.00 2,896.25 1,200.00 22,498.48 22,433.69 9,531 - 10,500.00 326,097.48 370,970.21 9,953' 801,017 58,782.31' 10,570.61 326,097.48 370,970.21 9,953, 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: MARCH 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 302,083 22,723.64 - 124,239.31 141,461.35 35.52 - 411.73 24,900 429.19 42.00 7,921.96 - 43,067.49 7,539.59 28,272 763 9,900 1,261.44 - 3,987.25 10,400 4,413.74 1,813.95 2,399.05 3,285.68 800 - - 263.00 12,250.07 - 2,024.29 5,800 - - 3,979.37 - 1,602.00 - 13,000 737.37 - 3,159.72 74,004 3,358.35 9 14,500 1,228.00 - 5,607.50 5,386.50 6,100 390.00 (112.00) 823.75 1,176.78 1,170 9,000 522.41 - 277.90 522.41 40 4,000 - - - 3,995.00 390,083 27,292.05' (70.00) 150,259.76 169,455.72 1,974' 390,083' 27,292.05' (70.00) 150,259.76 169,455.72 1,974 261,085 16,601.61 - 104,181.20 120,722.06 1,500 35.52 - 411.73 439.01 337,952 19,374.81 - 43,067.49 70,391.54 28,272 147,131 20,620.16 - 48,924.73 57,769.81 10,400 98.55 1,813.95 2,399.05 3,285.68 231 21,100 1,000.00 - 16,970.13 12,250.07 135,836 2,024.29 - 45,666.02 29,708.61 45,501 45,809 - - 10,527.00 - 960,813' 59,754.94' 1,813.95 272,147,35 294,566.78 74,004 9 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 14,449.59 - 99,145.12 97,276.95 Supplies 1,700 633.78 - - 633.78 Human Services 46,122 3,070.66 - 21,340.89 17,902.58 34 Operations Support 12,545 1,925.54 266.28 5,399.55 5,346.83 1,597 Staff Support 11,982 676.14 - 5,798.49 5,721.10 200 City Assistance 9,425 87.00 - 5,013.00 2,159.00 581 Professional Services 2,500 - - - - Operating Equipment - - - 1,491.55 - TOTAL HUMAN RESOURCES 303,095,', 20,842.71', 266.28 138,188,60 129,040.24 2,412 FINANCE Personnel Services 419,818 31,703.06 - 199,595.36 191,428.71 Supplies 3,600 156.45 - 894.02 1,433.71 55 Operations Support 1,050 - - 155.80 - Staff Support 13,370 3,661.45 74.30 3,130.39 5,491.45 959 Operating Equipment 1,000 866.69 - - 866.69 TOTAL FINANCE 438,838'' 36,387.65 74.3!0 203,775.57 199,220.56 1,015' PURCHASING & ASSET MGT Personnel Services 234,220 17,799.54 - 108,357.43 108,008.41 Supplies 2,300 214.28 - 300.87 234.58 159 Utility Services 1,200 44.61 - 178.98 131.70 Operations Support 150 - - - 60.68 Staff Support 6,900 580.00 - 3,259.30 3,180.57 949 Operating Equipment 150 - - - - TOTAL PURCHASING &ASSET MGT 244,920'' 18,638.43' - 1,12,096.58 111,6115.94 1,108 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: MARCH 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,113.24 - 70,219.77 73,926.32 101,000 14,334.42 4,701.70 47,812.97 50,483.74 11,272 1,500 - - 1,500.00 1,500.00 7,000 345.68 - 2,058.59 1,566.42 400 - - - - 2,435 173.54 - 575.88 953.16 130 45,750 864.55 474.24 13,471.04 19,877.61 1,569 200 150.00 - - 150.00 6,000 650.00 - - 650.00 780 312,818,' 27,631.43', 5,175.94 1,35,638.25 149,107.25 13,752 2,260,484 163,255.16' 7,330.47 861,846.35 883,550.77 92,294' - 214.21 - - 214.21 5,000 - - 5,000.00 5,000.00 5,000 - - - - 42,000 - - - 21,000.00 21,000 52,000'' 214.21'' - 5,000100 26,214.21 21,000, 52,000' 214.21,', - 5,000.00 26,214.21 21,000, 18,885,872' 1,397,862.50' 79,276.79 8,140,193,14 8,460,866.87 263,7371 546''' 4,765,926.30 m CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 174,687.15 - 6,116,848.00 6,617,160.39 000 - 411200 Advalorem Tax - Delinquent 50,000 6,162.66 - 40,113.59 28,938.03 000 - 411300 Advalorem Tax - P &I 50,000 12,314.63 - 23,222.19 24,453.50 000 - 411500 Sales Tax Revenue -Gen Fund 4,071,590 324,575.32 - 1,344,152.55 2,172,652.94 000 - 411600 Bingo Tax 4,500 151.13 - 2,639.06 1,132.33 000 - 411700 Mixed Beverage Tax 32,000.00 - - 15,704.85 16,729.24 TOTAL Taxes 10,912,656 517,890.89 - 7,542,680.24 8,861,066.43', Franchises 000 - 421200 Center Point /Entex Energy 33,000 - - 23,991.96 26,623.10 000 - 421220 City Public Service 275,000 - - 138,822.31 146,124.73 000 - 421240 Guadalupe Valley Elec Co -op 430,000 - - 234,006.04 211,765.14 000 - 421250 New Braunfels Utilities 30,000 5,633.66 - 6,383.04 13,037.36 000 - 421300 Time Warner -State Franchise 350,000 - - 158,262.23 169,803.13 000 - 421350 Time Warner -PEG Fee 62,000 - - 29,999.31 32,786.97 000 - 421460 AT &T Franchise Fee 220,000 - - 73,568.24 88,676.29 000 - 421465 AT &T PEG Fees 16,000 - 7,984.07 11,331.90 000 - 421480 Other Telecom Franchise 15,000 418.56 - 6,258.24 13,387.89 000 - 421500 Solid Waste Franchise Fee 90,000 9,185.21 - 41,951.74 52,522.48 TOTAL Franchises 1,5211,000 15,237.43 - 721,227.18 766,058.99' Permits 000 - 431100 Home Occupation Permit 770 - - 350.00 245.00 000 - 431200 Building Permit 837,952 148,102.00 - 297,223.52 903,958.83 000 - 431300 Mobile Home Permit 671 - - 80.00 80.00 000 - 431400 Signs Permit 8,596 130.00 - 205.00 365.00 000 - 431500 Food Establishmnt Permit 15,000 1,100.00 - 11,600.00 12,495.00 000 - 431600 Garage Sale Permit 9,554 1,275.00 - 4,735.30 4,435.00 000 - 431700 Plumbing Permit 109,769 11,539.00 - 40,448.50 50,961.50 000 - 431750 Electrical Permit 63,062 5,060.00 - 25,455.50 26,020.00 000 - 431800 Mechanical Permit 84,211 6,080.00 - 33,434.00 31,420.00 000 - 431900 Solicitor /Peddler Permit - 20.00 - 410.00 260.00 000 - 431950 Animal /Pet Permit 2,000 - - 1,050.00 1,385.00 12 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 1,050.00 - 1,900.00 3,000.00 000 - 432100 Security Alarm Permit 36,000 3,665.00 - 17,901.00 19,988.00 000 - 435000 Fire Permit 7,750 1,400.00 - 2,762.50 4,787.50 TOTAL Permits,', 1,181,913 179,421.00 - 437,555.32 1,059,400.83' Licenses - 30.00 - 000 - 441000 Alcohol Beverage License 6,100 450.00 - 1,442.50 1,210.00 000 - 442000 Contractors License 55,447 3,000.00 - 16,953.00 16,975.00 000 - 444000 Pet License 3,000 430.00 - 2,435.00 2,113.10 TOTAL Licenses 64,547 3,880.00 - 20,830.50 20,298.10' Fees 000 - 451000 Municipal Court Fines 1,540,000 110,036.21 - 629,176.98 535,172.47 000 - 451100 Arrest Fee 60,000 4,852.35 - 25,108.36 23,347.01 000 - 451110 Expunction Fee 90 - - 30.00 - 000- 451200 Warrant Fees 187,500 14,520.90 - 67,933.75 65,498.16 000 - 451320 Civil Justice Fee -Court 500 7.21 14.42 34.76 000 - 451340 Judicial Fee - City 7,000 649.31 - 3,277.82 3,113.24 000 - 451400 Traffic Fine Costs TTL 30,000 2,445.14 - 12,770.17 11,719.59 000 - 451500 Teen Court Admin Fee 500 20.00 - 440.00 220.00 000 - 451510 Juvenile Case Mgmt Fee 60,000 5,390.75 - 27,295.12 25,948.27 000 - 451600 Technology Fund Fee 55,000 4,458.47 - 22,580.34 21,047.30 000 - 451700 Security Fee 40,000 3,343.83 - 16,947.41 15,794.48 000 - 451800 Time Payment Fee - City 5,000 580.88 - 2,143.24 3,385.62 000 - 451850 State Fines 10% Service Fee 70,000 - - 33,685.94 33,448.06 000 - 451900 DPS Payment- Local 12,250 1,218.99 - 5,409.19 5,473.22 000 - 452000 Child Safety Fee 8,000 1,149.68 - 3,897.09 5,651.10 000 - 452050 Indigent Defense Fee 22,500 2,067.37 - 10,502.36 9,995.04 000 - 452100 Platting Fees 66,000 8,500.00 - 25,750.00 37,500.00 000 - 452200 Site Plan Fee 26,400 7,500.00 - 16,649.45 15,000.00 000 - 452300 Plan Check Fee 375,000 74,847.00 - 149,332.41 457,647.41 000 - 452310 Miscellaneous Review Fee - - - 2,400.00 - 000- 452320 Tree Mitigation Admin Fee 11,220 - - 9,213.75 - 000- 452400 BOA/Zoning Fees 11,000 - - 3,800.00 1,400.00 000 - 452500 Food Handler Class 8,000 620.00 - 2,980.00 4,300.00 000 - 452600 Specific Use /Zone Chng Fee 14,630 3,500.00 - 4,000.00 11,000.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: MARCH 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 1,800.00 - 21,868.02 23,175.00 000 - 453110 Swim Pool Inspection Fee - 675.00 - 75.00 675.00 000 - 453120 Inspections Plan Review - - - 833.00 - 000- 453200 Mowing Fees - Inspections - 1,001.75 - 1,979.56 9,882.91 000 - 453211 Admin Fee - Inspections - 600.00 - 3,600.00 4,100.00 000 - 453215 3% Technology Fee - - - 531.40 1.98 000 - 453310 Misc Inspection Fee - - - 40.00 40.00 000 - 453500 SubContractor Reg. Fee - 4,125.00 - 8,895.00 13,785.00 000 - 453710 Foster Care - 100.00 - 200.00 550.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 - - 370.00 - 000- 456510 Fire Plan Review 800 - - - - 000- 456600 Fire Re- inspection Fee 450 100.00 - 200.00 600.00 000 - 458100 Sale of Merchandise - - - - - 000- 458300 Sale of Property /Auction 20,000 230.51 - 5,635.16 2,223.09 000 - 458400 Civic Center Rental Fees 226,000 14,482.50 - 88,607.25 61,727.75 000 - 458401 Capital Recovery Fee -Civic Cntr - 150.00 - - 1,060.00 000 - 458450 North Center Rental Fees 24,000 575.00 - - 3,601.00 000 - 458500 Community Center Rental Fees 32,000 1,804.40 - 13,426.00 7,849.92 000 - 458550 Pavilion Rental Fees - 2,478.00 - - 8,536.70 000 - 458560 Chamber of Comm rent - - - - 3,900.00 000 - 458570 Non - Resident SYSA League 18,000 - - 17,761.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 - - 69.00 328.00 000 - 459300 Notary Fee 200 60.00 - 117.00 222.00 000 - 459400 Maps, Copies, UDC, & Misc F 200 10.00 - 115.56 593.18 000 - 459600 Animal Adoption Fee 10,500 999.00 - 5,075.00 5,711.50 000 - 459700 Pet Impoundment Fee 17,500 2,192.50 - 8,184.00 9,816.51 000 - 459800 Police Reports Fee 6,532 520.00 - 3,106.10 2,932.20 TOTAL Fees 3,073,872 277,611.75 - 1,258,768.,60 1,460,514.23', 14 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 2,272.78 - 14,976.13 12,788.62 TOTAL Fines 35,000 2,272.78 - 14,976.13 12,788.62' 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 - 20,131.56 20,131.56 000 - 473300 Guad Co - Library 180,816 15,068.00 - 90,407.46 90,408.00 000 - 473400 Randolph AFB - Animal Cntrl 2,500 - - 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 - - 133,305.00 66,652.90 000 - 474500 Dispatch Service - SCUCISD 2,080 - - 2,080.00 - 000- 474600 School Crossing Guard - Bexar 6,600 1,119.35 - 3,162.38 3,123.40 TOTAL Inter- Jurisdictional 405,672 19,542.61 - 256,670.32 188,541.78' Fund Transfers 000 - 480000 Indirect Costs - EMS 87,840 21,960.00 - 43,920.00 43,920.00 000 - 480100 Indirect Costs - Hotel /Motel 170,221 42,555.25 - 63,816.00 85,110.50 000 - 482100 Transfer From Reserves -Ct Tech - - - - 000- 482150 Transfer From Court Security 58,011 - - 000- 485000 Interfund Charge- Drainage 38,888 9,722.00 - 19,149.00 19,444.00 000 - 486000 Interfund Chrges -Admin W &S 624,777 156,194.25 - 319,473.97 312,388.50 000 - 486202 Transfer In -W &S - - - 15,420.52 - 000- 486317 Transfer From Park Fund - - - 4,133.27 - 000- 486322 Transfer -In - Library Grants 10,000 - - 000- 486402 Transfer from City Wide Projects - 25,372.05 - - 25,372.05 000 - 487000 Interfund Charges -Fleet 91,737 22,326.25 - 39,830.03 44,652.50 000 - 488000 Interfund Charges -413 53,000 13,858.00 - 27,750.00 27,716.00 000 - 489000 Transfer In - - - 3.80 - 000- 490020 Transfer In -SEDC 50,000 - - 50,000.00 50,000.00 TOTAL Fund Transfers,', 1,184,474 291,987.80 - 583,496,59 608,603.55', Miscellaneous 000 - 491000 Interest Earned 5,000 - - 2,815.07 1,405.57 000 - 491200 Investment Income 26,000 3,453.98 - 15,232.68 17,081.69 000 - 491900 Unrealized Gain /Loss - (2,332.91) - (5,805.00) (15,690.98) 15 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 - 493000 Donations - Others - 340.00 - - 340.00 000 - 493120 Donations - Public Library - - - - - 000- 493130 Donations - Writing the Next Chap. 20,000 116.00 - 9,567.50 21,844.00 000 - 493400 Donation - Animal Control 3,670 15.00 - 2,040.92 2,365.26 000 - 493401 Donations -A/C Microchip 3,000 245.00 - 1,585.00 1,345.00 000 - 493402 Donations - Spay &Neuter 12,000 1,444.02 - 5,850.50 8,656.57 000 - 493403 Donations - Melvin Boeck A. S. - - - - - 000- 493503 Donations - Fire Rescue - - - - 25.00 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,800 - - 3,705.94 3,550.22 000 - 495015 Contribution from SED - - - - - 000- 497000 Misc Income -Gen Fund 40,000 996.60 - 10,665.12 28,011.94 000 - 497005 Misc Income - Publications 240,000 15,172.25 - 70,111.30 67,308.15 000 - 497007 Misc Income - Schertz Artz - - - - - 000- 497020 Misc Income -Fleet Recycled 400 - - 250.80 - 000- 497100 Misc Income - Police 20,000 717.00 - 9,280.22 14,596.13 000 - 497200 Misc Income - Library 12,131 341.55 - 5,894.25 1,651.10 000 - 497210 Misc Income - Library Copier 3,400 607.90 917.65 4,921.65 000 - 497300 Misc Income - Animal Control 2,400 262.00 - 1,289.45 989.30 000 - 497400 Misc Income - Streets Dept. 11,229 900.00 - 4,950.00 8,475.00 000 - 497500 Misc Income -TML Insurance 78,043 (1.00) - 78,042.55 49,730.90 000 - 497550 Misc Income -TML Reimbursemt 20,211 - - 18,779.40 17,643.20 000 - 497600 Misc Income - Parks /Vending Mach. 500 151.25 - 750.15 1,011.66 000 - 497800 Misc Income -Pool Concessions - - - - - 000- 498000 Reimbursmnt -Gen Fund 5,500 1,131.60 - 3,166.36 1,549.60 000 - 498100 Reimbursmnt Fire - Training - - - - 846.00 000 - 498105 Reimburmnt Police - DEA - 1,628.22 - - 3,785.61 000 - 498110 Reimbursmnt Fire - Emg. Acti -O - - - - 8,078.07 TOTAL Miscellaneous 507,284 25,188.46 - 239,089.86 249,520.64', TOTAL REVENUES 18,886,418 1,333,032.72 '' - 11,075,294.74 13,226,793.17' 16 Y -T -E ENCUM GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 647,067.30 Cash in Investment Pools LOGIC Investment - General Fund 4,506,648.15 LOGIC Investment -Equip Replacement 73,239.04 LOGIC Investment -Veh Replacement 7,069.11 LOGIC Investment -Air Condi Replacment 122,250.26 CAPITAL ONE Investment - General Fund 1,324,015.03 Total Cash in Bank & Investment Pools $ 6,802,539.15' 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 174,687 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 -10)10 $400,000 0 13/0 _2% 1 24% !ro 11 0 ° $300,000 $200,000 $100,000 OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 339,709 332,264 347,605 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: MARCH 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 ENCUM 85,614.00 - - 134,344.00 - 28,000.00 27,142.90 - 28,769.29 30,461.91 2,100.00 - - - - 1,000.00 - - 155.00 9,610.00 22,300.00 36,652.79 - 6,007.44 426.54 1,39,014.00 63,795.69 - 169,275.73 40,498.45 5,150.00 - - - - 5,15000 - - - - 4,750.00 - - - - 14,250.00 - - 10,191.25 12,645.61 102 5,000.00 - - - 126.00 100.00 - - - - 30,500.00 30,461.91 - 28,785.25 30,461.91 5,600.00 - - - - - - 455.59 306.07 455.91 2,700.00 - - - - 32,000.00 3,089.58 1,058.00 12,150.37 20,165.54 850 11,000.00 - - - - 1,271 400.00 - - - 400.00 106,300.00 33,551.49 1,513.59 51,432.94 64,254.97 2,224 111,450.00 33,551_49 1,513.59 51,432.94 64,254.97 2,224 REVENUE OVER(UNDER) EXPEND 27,564.00 19 (23,756.52)' SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 52,203.51 Cash in Investment Pools MBIA Special Events 66,504.60 Total Cash in Bank & Investment' Pools $,', 118,708.11 20 202 -WATER & SEWER FINANCIAL SUMMARY REVENUE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 Franchises 138,000 75,229.49 - 101,190.91 110,290.49 Fees 13,679,750 930,494.79 - 5,964,814.81 6,553,266.92 Fund Transfers 480,616 20,154.00 - 39,500.03 40,308.00 Miscellaneous 55,445 135,144.79 - 80,487.23 204,821.57 TOTALREVENUES 14,353,811 1,161,023.07 - 6,185,!992.98'' 6,908,686.98 �:1,�►1�]���1:I���J��ih�i /_1:x'1 NON DEPARTMENTAL Fund Charges /Transfers 31,000 31,000.00 - - 31,000.00 - TOTAL NON DEPARTMENTAL 31,000 311,000 - - 31,000 - BUSINESS OFFICE Personnel Services 458,640 32,417.08 - 153,438.63 201,390.45 - Supplies 6,550 201.98 - 1,276.09 1,361.99 447.5: Operations Support 108,500 14,718.31 - 49,225.10 40,994.90 - Staff Support 7,950 68.95 - 624.60 1,277.22 315.8 Professional Services 14,500 (1,398.10) - 11,145.01 3,283.34 - Fund Charges /Transfers 40,000 - - - - - Maintenance Services 12,000 420.00 - 3,950.00 3,080.00 2,940.01 Operating Equipment 6,800 40.00 - - 6,117.62 - TOTAL BUSINESS OFFICE 654,940 46,468.22 - 219,659.43'' 257,505.52 3,703.3: W & S ADMINISTRATION Personnel Services 1,212,507 83,232.69 - 621,883.53 586,540.71 - Supplies 193,700 9,418.45 338.73 88,760.23 87,884.90 2,614.7; Human Services 338 - - - 64.00 - City Support Services 102,926 211.98 - 21,461.65 34,811.55 - Utility Services 2,780,900 322,956.61 - 1,067,827.85 906,693.22 1,655.61 Operations Support 8,750 (431.69) 79.60 1,177.05 1,650.69 - Staff Support 33,000 2,566.55 1,339.00 8,334.46 11,729.08 1,865.8: City Assistance 1,912 - - 352.00 236.00 15.01 Professional Services 177,168 40,431.86 9,870.00 50,589.45 96,158.84 - Fund Charges /Transfers 2,368,176 382,526.20 - 353,694.52 1,180,900.40 - Maintenance Services 4,838,250 410,096.12 116.41 2,502,356.85 2,277,850.44 9,771.7 - Other Costs 25,000 - - 23,671.50 28,911.85 - Debt Service 1,435,165 83,375.00 - 1,200,302.92 534,900.62 - Rental- Leasing 6,070 - - 2,301.89 662.53 - 21 22 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 4,234.10 3,420.00 (3,400.00) 12,675.09 Capital Outlay 58,000 79,828.40 52,432.00 - 133,169.40 - Water Line Relocation - - - 357,830.77 - - TOTAL PUBLIC WORKS 13,254,862 1,418,446.27 67,5!95.74 6,297,144.67'' 5,894,839.32 16,923.0( MISC & PROJECTS PROJECTS FUND CHARGES /TRANSFERS - - - - - - TOTAL PROJECTS '' AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services 19,000 - - - - - Operations Support 500 - - - - - Professional Services 47,850 - - 29,368.53 22,128.57 - Maintenance Services 335,500 - - 145,754.08 10,018.78 - TOTAL AVIATION HEIGHTS WTR IMP 402,850 - - 175,,122.61 32,147.35 - FM3009 RD &BRIDGE EXPANSION Professional Services - - 19,137.50 14,708.06 30,358.80 - Maintenance Services - - - 615,355.22 37.74 - TOTAL FM3009 RD &BRIDGE EXPANSION - - 19,138 630,063 30,396.54 - TOTALL'MISC &'PROJECTS 402,850 - 19,137.50 805,185.89 62,543.89 - TOTAL EXPENDITURES 14,343,652 1,495,914 86,733 7,321,990 6,245,889 19,62E — REVENUE OVER(UNDER)EXPENSES ** 10,159 662,798.25 22 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 75,229.49 - 101,190.91 110,290.49 TOTAL Franchises 138,000 75,229.49 - 101,190.91 110,290.49' Fees 000 - 455200 Garbage Collection Fee 3,300,000 278,606.04 - 1,456,817.65 1,593,173.33 000 - 455600 Fire Line Fees 18,500 - - 18,190.00 18,430.00 000 - 455700 Recycle Fee Revenue 155,000 22,716.13 - 74,705.48 103,062.87 000 - 455800 W &S Line Constructn Reimbursemnt 50,000 2,281.02 - 14,193.76 15,996.81 000 - 457100 Sale of Water 7,200,000 340,122.61 - 2,757,051.47 3,215,085.48 000 - 457110 Edwards Water Lease 127,250 20,703.36 - 34,340.05 153,410.82 000 - 457120 Water Transfer Charge -Selma 5,000 - - 780.18 1,339.20 000 - 457130 Water Transfer Charge -U. C. 1,000 - - 3,914.06 1.28 000 - 457200 Sale of Meters 86,000 6,322.44 - 29,157.94 42,197.89 000 - 457400 Sewer Charges 2,560,000 249,816.77 - 1,492,077.97 1,327,831.40 000 - 457500 Water Penalties 175,000 9,706.42 - 82,302.62 81,555.62 000 - 459200 NSF Check Fee -Water &Sewer 2,000 220.00 - 1,283.63 1,182.22 TOTAL Fees 13,679,750 930,494.79 - 5,964,814.81 6,553,266.92' Fund Transfers 000 - 486101 Transfer In- General Fund 400,000 - - - - 000- 486204 Interfnd Chrg- Drainage Bill 80,616 20,154.00 - 39,500.03 40,308.00 TOTAL Fund Transfers 480,616 20,154.00 - 39,500.03 40,308.00' Miscellaneous 000 - 490000 Misc Charges 15,000 (100.00) - 9,987.16 4,331.88 000 - 491000 Interest Earned 500 - - 234.22 1,066.50 000 - 491200 Investment Income 5,000 546.37 - 33,629.95 6,889.58 000 - 493130 Library Donations - - - 4.17 - 000- 493400 Donations - Christmas Activitise - - - - 1,000.00 000 - 496050 SSLG - SAWS Reservation - 134,500.00 - - 134,500.00 000 - 497000 Misc Income -W &S 20,000 198.42 - 11,466.72 (991.48) 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 135,144.79 - 80,487.23 204,821.57' TOTAL REVENUES 14,353,811' 1,161,023.07 - 6,185,992.98 6,908,686.98' 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 56,683.62 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,428.55 293,307.16 372,613.85 543,315.52 1,044,420.00 $ 3,744,085.08 Total Cash in Bank & Investment Pools $3,800,768.70 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: MARCH 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 400,021.37 - 2,145,578.58 2,364,924.74 - 1,432,345 23,843.87 - 662,952.38 667,622.13 - 334,850 6,244.99 - 91,386.81 85,967.91 - 7,203,732 430,110.23 - 2,899,917.77 3,118,514.78 - 2,391,410 200,462.37 - 1,233,732.68 1,282,180.13 - 327,874 22,058.66 382.34 170,618.97 136,673.60 47,582.42 847 - - - 580.00 - 15,000 - - 14,850.78 10,902.09 - 80,438 10,441.45 - 28,700.25 41,976.33 40.00 31,500 3,057.38 - 20,185.78 30,179.66 720.00 75,600 3,113.39 171.35 51,816.26 30,652.49 12,766.62 7,753 479.00 - 2,733.05 3,495.00 2,252.00 136,390 6,217.12 160.00 44,001.49 49,929.46 19,529.47 3,576,092 29,475.00 - 1,867,100.15 58,950.00 - 42,320 2,401.36 - 21,597.84 18,072.52 197.39 248,502 - - 9,523.75 69,799.33 - 40,000 845.87 - 4,011.03 1,682.20 - 82,600 4,495.34 - 29,878.37 10,570.16 4,918.58 7,056,326 283,046.94 713.69 3,498,750.40 1,745,642.97 88,006.48 TOTAL EXPENDITURES 7,056326 283,046.94 713.69 3,498,750.40 1,745,642.97 88,006.48 REVENUE OVER(UNDER), EXPENSES " 147,406 1,372,871.81 2s CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 000 - 456100 Ambulance /Mileage Transprt 5,336,537 399,671.37 - 2,132,561.58 2,346,584.74 - 000- 456110 Subscription Program Fees 100,000 350.00 - 12,997.00 18,340.00 - 000- 459200 NSF Check Fee - - - 20.00 - - TOTAL Fees 5,436,537 400,021.37 - 2,145,578.58 2,364,924.74 - Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 286,126 23,843.87 - 143,063.22 144,163.15 - 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 23,843.87 -_ 662,952.38 667,622.13 - Miscellaneous 000 - 491000 Interest Earned - - - - - - 000- 491200 Investment Income - 44.61 - 98.17 328.45 - 000- 493203 Donations -EMS 6,000 - - 706.00 1,100.00 - 000- 497000 Misc Income 150,000 3,486.88 - 58,022.64 38,935.96 - 000- 497100 Recovery of Bad Debt 100,000 1,038.50 - 505.00 8,268.50 - 000- 497500 Misc Income -EMT Classes 78,850 1,675.00 - 32,055.00 37,335.00 - TOTAL Miscellaneous 334,850 6,244.99 - 91,386.81 85,967.91 - TOTAL REVENUES 7,203,732 430,110.23 - 2,899,917.77 3,118,514.78 - 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ (296,922.30) Cash in Investment Pools LOGIC Investment -EMS MBIA Investment -EMS Note 2010 300,521.56 Total Cash in Bank & Investment Pools $ 3,599.26'' 27 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 65,572.74 - 334,921.49 351,293.67 - 3 Miscellaneous 1,300 66.47 - 844.07 614.00 - _ TOTAL REVENUES 676,600 65,639.21 '' - 335,765.56 351,907.67 - 3 PUBLIC WORKS DRAINAGE Personnel Services 361,183 26,104.11 - 164,371.08 172,081.40 - 1 Supplies 8,300 144.94 28.15 1,000.18 614.18 188.63 Human Services 100 - - - - - City Support Services 26,500 - - 976.00 4,332.18 - Utility Services 12,888 580.01 - 5,125.84 4,815.99 712.20 Operations Support 2,458 - - - - - Staff Support 8,255 733.35 168.83 2,051.41 2,014.49 218.35 City Assistance 840 - - 102.00 15.00 - Professional Services 19,800 - - 5,197.10 10,000.00 - Fund Charges/Transfers 195,449 32,662.25 - 64,652.83 65,324.50 - 1 Maintenance Services 22,000 - - 4,542.46 1,987.00 - Other costs 100 - - 100.00 100.00 - Debt Service 18,138 - - 2,183.45 1,918.78 - Rental /Leasing 500 - - - - - _ TOTAL DRAINAGE 676,511'' 60,224.66 '' 196.98'' 250,302.35 263,203.52 1,119.18 4 TOTAL EXPENDITURES 676,511'' 60,224.66 '' 196.98'' 250,302.35 263,203.52 1,119.18 4 "" REVENUE OVER(UNDER) EXPEND 89' 2s 88,704.15'' 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: MARCH 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 289.98 671,800 65,282.76 675,300, 65,572.74, 100 - 600 57.23 600 9.24 1,300 66.47' 676,600 65,639.21' 29 1,938.17 332,983.32 334, 921,.49 31.83 334.65 477.59 844.07 2,110.88 349,182.79 351,293.67 147.04 346.90 120.06 614.00 335,765;56 351,907.67 - 322 324 324 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: MARCH 31 st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking 194,302.51 Cash in Investment Pools Lone Star Investment - Drainage Maint Fund 282,802.34 Total Cash in Bank & Investment Pools $ 477,104.85 30 314 -HOTEL TAX FINANCIAL SUMMARY REVENUE SUMMARY Taxes Fund Transfers Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services Supplies 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: MARCH 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 6,960.10 - 133,922.18 132,464.25 - 55,000 - - - - - 5,550 12.02 - 216.68 212.46 445,550 6,972.12 - 134,138.86 132,676.71 - 31,841 - - - - - 2,526 - - - - 78,228 - 502.85 32,027.50 29,616.85 - 85,898 - - - 5,952.88 - 2,500 - - 902.28 - - 231,485 42, 555.25 - 149, 060.00 85,110.50 - 432,478 42,555.25 502.85 181,989.78 120,680.23 - TOTAL EXPENDITURES 432,478 42,555.25 502.85' 181,989.78 120,680.23 - REVENUE OVER(UNDER)'EXPENDITURE 13,072'' 11,996.48'' 31 32 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BU REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BAL Taxes 000 - 411800 Hotel Occupancy Tax 385,000 6,960.10 - 133,922.18 132,464.25 - 252 TOTAL Taxes 3851,000 6,960.10 - 133 „922.18 1,32,464.25 - 252 Fund Transfers 000 - 481000 Transfer From Reserve 55,000 - - - - - 55 TOTAL Fund Transfers 55,000 - - - - - 55 Miscellaneous 000 - 491000 Interest Earned 250 - - 158.34 137.27 - 000- 491200 Investment Interest 300 12.02 - 58.34 75.19 - 000- 497000 Misc Income 5,000 - - - - - 5 TOTAL Miscellaneous'' 5,550 12.02 - 216.68'' 212.46 - 5 TOTALIREVENUES 445,550 6,972,.12 - 134,138.86 132,676.71 - 312 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 130,161.16 Cash in Investment Pools Federated Investment -Hotel /Motel 78,076.99 Total Cash in Bank '& Investment Pools $' 208,238.15' 33 HOTEL OCCUPANCY TAX 2010 -11 27,689 25,112 23,231 19,619 22,667 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: MARCH 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 82,000.00 - 10,000.00 82,000.00 40,000 - - 52,311.25 - 405 35.60 - 283.48 359.97 80,405 82,035.60 - 62,594.73 82,359.97 - PARKLAND DEDICATION Maintenance Services- Landscape 8,000 12,234.00 - 1,286.36 12,234.00 - Operating Equipment 30,000 4,486.27 11,244.23 47,066.73 41,846.22 3,923.1 Capital Outlay 6,000 - - - 4,980.30 - TOTAL PARKLAND DEDICATION 44,000 16,72027 11,244.23 48,353.09'' 59,060.52 3,923.1 TREE MITIGATION Fund Charges/Transfers Maintenance Services -Trees Capital Outlay TOTAL TREE MITIGATION TOTAL EXPENDITURES - - - 4,133.27 - - 36,000 - 3,133.00 26,922.42 18,171.00 - 36,000 - 3,133.00 31', 055.69' 18,171.00 80,000 16,72027 14,377.23 79,408.78' 77,231.52 3,923.1 REVENUE OVER(UNDER) EXPEND' 405' 35 5,128.45 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' TOTALREVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 ENCUMBRA 40,000 82,000.00 40,000 - 80,000 82,000.00 60 - 280 35.60 65 - 405 35.60 10,000.00 82,000.00 52,311.25 - 62,311.25 82,000.00 - 32.45 137.28 - 186.03 222.69 80,405 82,035.60 - 36 65.00 283.48 359.97' 62,594.73 82,359.97 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $172,855.54 Cash in Investment Pools Federated Investment -Park Fund 38,829.22 Federated Investment -Tree Mitigation 192,374.66 Total in Investment Pool 231,203.88 Total Cash in Bank '& Investment Pools' $404,059.42'' 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: MARCH 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 31,000.00 - - 31,000.00 25,000 - - - - - 56,000 31,000100 - - 31,000.00 - 56,000 - - 6,567.02 - - 56,000 - - 6,567.02'' - - 56,000 - - 6,567.02'' - - - 31,000.00 38 31, 000.00 39 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 31,000.00 - - 31,000.00 - TOTAL Fund Transfers 31,000 31,000.00 - - 31,000.00 - Miscellaneous 000 - 490210 Sale of Recycle Material 25,000 - - - - - TOTAL Miscellaneous 25,000 - - - - - TOTAL REVENUES 56,000 31,000 - - 31,00,0 - 39 RECYCLE FUND CASH IN BANK AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking (27,365.47) Total Cash in Bank 40 $ (27,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: MARCH 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 237,678.54 - 523,814.07 1,250,482.39 - 585,500 83,923.64 - 99,284.69 166,790.26 - 1,776,140 321,602.18 - 623,098.76 1,417,272.65 - 1,000 - - - - - 26,800 350.72 - - 1,761.50 - - - - 118,896.50 - - - - 8,428.00 - 8,428.00 - 27,800 350.72 8,428.00 118,896.50' 10,189.50 - 230,200 - 53,183.36 180.00 63,983.36 - 599,643 - - - - - - - - 456,089.61 204,531.74 - 88,252 - 225,148.72 101,228.90 313,030.67 - 918,095 - 278,332.08 557,498.51'' 581,545.77 - 945,895 350.72 286,760.08 676,395.01' 591,735.27 - REVENIUEOVER(UNDER) EXPENDITURES' 830,245' 41 825,537 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 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 124,944.00 000 - 455910 Capital Recovery -Waste Wtr 272,800 112,734.54 000 - 455911 Capital Recovery-Wste Wtr Zone 1 13,640 - 000- 455913 Cap Recovery-North Sewer Tr - - TOTAL 'Fees 1,190,640 237,678.54' Fund Transfers 000 - 481000 Transfer from Reserves 000 - 486100 Transfer In TOTAL Fund Transfers Miscellaneous 241.22 - 2,720.54 000 - 491000 Interest Earned 2,000 - 000- 491200 Investment Income 250,000 3,433.76 000 - 491900 Unrealized Gain /Loss -Cap One - (2,885.12) 000 - 498100 Reimbursmnt - FM 78 Project 50,000 12,500.00 000 - 498200 Re- imbursement -Water Meters 283,500 70,875.00 TOTAL Miscellaneous 585,500 83,923.64' - 355,848.07 792,595.34 - 167,666.00 457,287.05 - 523,814.07 1,250,482.39' - 689.18 241.22 - 2,720.54 18,816.41 - - (19,017.37) - 24,999.97 25,000.00 - 70,875.00 141,750.00 99, 284.69 166, 790.26' TOTAL,REVENUES 1,776,140 321,602.18 - 623,098.76 1,417,272.65 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 323,865.00 Cash in Investments: Lone Star Investment - Capital Recovery 561,557.29 Capital One - Investment 1,695,737.75 Schertz Bank & Trust - Certificate of Deposit 523,915.88 Total Cash in Bank & Investment Pools $3,105,075.92 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 TOTAL EXPENDITURES CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 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 93,061.69 - 3,259,277.42 3,329,347.77 - 243,000 - - - - - 3,000 151.59 - 1,849.04 15,044.28 - 3,614,794 93,213.28 - 3,261,126.46 3,344,392.05 - 3,200 350.00 - 1,350.00 350.00 - 3,611,124 - - 2,445,857.55 2,558,340.59 - 3,614,324 350.00 - 2,447,207.55 2,558,690.59 3,614,324 350.00 - 2,447,207.55 2,558,690.59 - — REVENUE OVER(UNDER),EXPEND 470 44 785,701.46 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: MARCH 31st, 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 93,061.69 - 3,259,277.42 3,329,347.77 3,368,794 93,061.69 - 3,259,277.42 3,329,347.77 243,000 - - - - 243,000 - - - 1,500 - - 942.38 14,409.41 1,500 151.59 - 906.66 634.87 3,000 151.59 - 11,849.04 15,044,28 3,614,794 93,21,3.28 - 3,2611,126.46 3,344,392.05 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: MARCH 31st, 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 350.00 350.00 - 1,350.00 1,350.00 10u.uu 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 350.00 - 2,447,207,55 2,558,690.59 46 TAX I &S CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 38,287.84 Cash in Investment Pools Federated Investment -Tax I &S 1,033,627.92 Total Cash in Bank & Investment' Pools $1,071,915.76 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: MARCH 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 163,626.77 - 672,076.28 1,087,665.57 - 108,000 532.36 - 23,254.55 5,181.83 - 2,143, 795 164,159.13 - 695, 330.83 1, 092, 847.40 - 21,000 1,862.01 623.28 7,261.26 12,004.73 2,097.04 85,800 5,687.37 - 35,094.79 28,010.03 - 67,300 4,815.82 5,965.50 28,172.95 34,488.38 1,998.08 8,498 - - 14,869.00 6,999.31 - - - 6,999.31 - - - 182,598 12,365.20 13,588.09 85,398.00 81,502.45 4,095.12 202,062 8,623.08 - 129,170.25 66,267.74 - 1,000 30.91 - 131.75 540.23 19.99 100 - - - - 54.00 34,500 565.45 623.92 13,978.85 9,559.57 3,409.59 4,850 599.04 - 1,333.39 1,602.76 12.00 76,100 571.35 3,242.89 33,753.00 38,490.25 3,237.13 97,000 311.98 1,782.11 86,172.12 62,352.04 1,695.95 80,000 - - - - - 349,000 47,536.80 21,340.80 110,878.98 143,782.52 178.67 105,432 13,858.00 - 77,750.00 77,716.00 - 216,000 - - - - - - - - 781.89 - - 792,432 - - 355,322.21 606,911.25 - 1,500 - - 158,665.59 - - 1,959,976 72,096.61 26,989.72 967,938.03 1,007,222.36' 8,607.33 TOTAL EXPENDITURES 2,142,574 84,461.81 40,577.81 1,053,336.03 1,088,724.81'' 12,702.45'' " REVENUE'OVER(UNDER) EXPEND 1,221 '' 4,122.59'.'' 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: MARCH 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 163,626.77 2,035,795 163, 626177 1,000 - 12,000 532.36 15,000 - 80,000 - 108,000 532.36', 672, 076.28 1, 087, 665.57 672,076.28 1,087,665.57 - 311.91 37.59 - 13,780.33 4,790.44 - 9,162.31 353.80 23,254.55 5,181.83 TOTAL REVENUES'' 2,143,795 164,159.13 - 695,330.83 1,092,847.40' 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 372,107.84 Cash in Investment Pools MBIA Investment - Economic Development Corp 215,189.62 MBIA- Investment -Sysco Infrastructure - MBIA- Investment -EDC Notes 2010 153,514.29 Schertz Bank & Trust - Certificate of Deposit 505,445.57 Schertz Bank & Trust - Certificate of Deposit 1,027,353.23 Total Cash in Bank & Investment Pools $ 2,273,610.55 50 4B SALES TAX $300,000 $250,000 -1 OYD $200,000 240% 14% -2% 11 0 $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 163,627 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 1E 51 j Cl a , f u g -gfy mPFyy Wxylyaa�Mh�@!@n 0, 040�`n.�I i A .. 's F��_�©:�q � S A .st'nQiFnrdelsaie s;Y!nCUSS �.a...mara AAg .. go-hit, coaditiamw 2gAawL = 2A ",AW4d7i 6.1-WO Ihm ru xI, , :.92 ' A r,; '0a 00 'sm - - ILIM,07.99 Awc mom Not" ati' A t,4K 0, 1-70 22,7 M f C20 ,514i Ow"WAge, Fu" r —U M2,14B411 0.24D B7- p za ryry" u _. puu CUM tt-a .0 lk. a', ��pp s.;(i' pg�pA a aft ,40.22 2�2e�� RR 5q!e iPS a.V� Om� Na ,e�� 06 AA4- RA'w.fMP c., ' ( a ��iGc{ wpuy bA�ft,. - ,u waftexism"W A A gam® #}Au;�y o IL, A , 1, P '4ly"b!'42R, ampAmwwrl- Fiit •r!w: _ __ Y'r L�`�IF,ifiP °W v. _ _ " .�. .�,. Cl , f u g -gfy mPFyy Wxylyaa�Mh�@!@n 0, 040�`n.�I i A .. 's F��_�©:�q r _. t Omparatum _ peala "Mktg ftad ",AW4d7i 6.1-WO Ihm ru xI, , :.92 ' A r,; '0a 00 'sm - - ILIM,07.99 Awc mom Not" ati' A t,4K 0, 1-70 22,7 M f C20 ,514i _ ,n Men _ C I _.. 3p13 4F ryry" Cl Ihm ru xI, , :.92 ' A r,; '0a 00 'sm - - ILIM,07.99 48,'MM, @Z Will 6".35 RABDO, lit aCEcu _ 4a,654.02 Cl 'r W ON A! sahertz Bank Ormft M � - 1! 1*,, " I offa M, N . 2 ■ \. Ia - - N1 Date b 3/31/2011 MA Avestv Yldality Inat Prime iki 16,631.33 Rank of Amer WL Dima Sant Azwt 4/11t2011 29 010 65,009.00 64,806.68 64,866.90 Corp, Disc Com Paper 7113/2011 MAO 05,000.00 64,80.72 64,005.72 ipmanan Ckme Disc cm Rape 011 ib 65,000.90 fif,90L 64,534. _ KqulvaleAtv 211,631.33 211,258.57 211,258.57 - - ftdaral Farm Cr Bks a - as Ba d i 40 i b i iib &31.50 ,d a @a @az R @° 1012R/2011 dd. 1, 35, 3db ii 135,000AG 135, id Eradaral Hme LD Ktg Corp Vigo mts 1'@ 10,1712M 190.00 100,00D.00 99,746.50 en .4, } rode roderal mm, a t" g OorP i' "z R 11/15/2013 960. i b L70, ow b i0 b 1SQ, 084.25 _ s ftdezal Natl Mtg Ason Msdu= k Nts 9/24/2013 900.00 250,000.00 250,DOO.00 269,74750 Federal 4 ,.,y, d } w6 d} at, bib }b d i' dd 249,401.25 Incme 1,055,00,0.00 ia> d b am v 24,5* ,WO. 00 7,424,920,36 r .0 Diso Bankers Aacp RrW 411912011 19AD 85, iii bi 04, B52. d» 84,652.05 Bloc Gap Corp Disc Gml n. p° 1,115/2011 MAD 85, i'ib ib =4 $4,145.95 Total i g Squivalentff 274,28 0.5,9 . dg i.., s Cr Bkz cow Systammide M1 x. " 1011,712M MAD i i b b i b 2-70,052.50 Federal @e a Loaa Us Camis .sI- 1,0/2B/2011 6.6 175,000.00 1,75, dib dd dd' Yed&ral Ross Mg Qorp Deb i 960.00 250,00LOO ibe i' #' ii 0 10,130/2012 MAD 230,00DA0 ISO, 192. 50 249,401.25 -* b am v 24,5* ,WO. 00 7,424,920,36 r .0