Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07-APRIL 2011 STATEMENT
APRIL 2011 Financial Report CITY OF S CHERTZ Prepared By: The Finance Department March 31, 2011 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 346,129.34 - 7,895,364.43 9,209,873.97 Franchises 1,521,000 108,751.33 - 729,996.51 874,810.32 Permits 1,181,913 177,310.00 - 535,121.32 1,236,710.83 Licenses 64,547 3,747.50 - 23,726.50 24,045.60 Fees 3,073,872 222,652.33 - 1,489,836.31 1,682,942.02 (67. Fines 35,000 2,128.94 - 17,413.94 14,917.56 Inter- Jurisdictional 405,672 19,327.79 - 276,106.81 207,869.57 Fund Transfers 1,184,474 88,822.74 - 583,496.59 697,426.29 Miscellaneous 507,284 55,453.34 - 290,938.92 305,116.27 TOTAL REVENUES 18,886,418 1,024,323.31' - 11,842,001.33 14 „253,712.43 (67. EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 22,800 2,720.19 - 3,927.15 13,558.53 Supplies 500 119.94 - 98.87 239.97 City Support Services 20,500 - - 8,625.70 12,932.87 274 Operations Support 300 127.40 - 116.80 127.40 Staff Support 16,400 446.79 380.00 7,745.69 10,418.64 334 Opertating Equipment - - - - - TOTAL CITY COUNCIL 60,500'' 3,414.32' 380.00 20,514.21 37,277.41 608 CITY MANAGER Personnel Services 753,457 87,622.31 - 395,842.36 423,909.80 Supplies 1,226 39.98 - 673.14 711.05 31 City Support Services - - - 32.00 - Operations Support - - - - - Staff Support 25,150 2,114.50 438.80 8,510.83 16,053.43 467 Operating Equipment 1,574 - - - 1,393.36 899 TOTAL CITY MANAGER 781,407'' 89,77679' 438.8!0 405,058.33 442,067.64 1,398 1 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 27,076.90 - 128,341.27 140,464.80 Supplies 3,200 - - 345.70 644.76 203 City Support Services 1,000 - - - - Operations Support 3,000 - - 1,463.00 1,166.00 454 Staff Support 6,200 200.00 33.44 1,849.46 1,537.04 77 Court Support 800 - - - - Professional Services 84,600 3,479.00 - 29,131.48 28,679.00 13,693 Maintenance Services 2,500 250.00 - - 600.00 Operating Equipment 2,000 - - 141.98 500.00 TOTAL MUNICIPAL COURT'' 353,503'' 31,005.90 33.44 161,272.89 173,591.60 14,4281 CUSTOMER RELATIONS -311 Personnel Services 88,928 9,256.65 - 53,379.10 48,112.40 Supplies 500 - - - 49.84 36 Staff Support 1,105 - - - - 643 TOTAL CUSTOMER, RELATIONS -31,1 90,533,', 9,256.65', - 53,379.110 48,162.24 679', PLANNING & ZONING Personnel Services 134,105 14,726.35 - 73,322.60 76,254.95 Supplies 4,500 - - 69.90 117.04 142 City Support Services - - - - - Operations Support 2,300 - - 183.16 77.95 Staff Support 22,100 - 1,527.12 7,218.48 3,232.12 71 Professional Services 142,300 - - - 47,988.68 76 Operating Equipment 600 - - 217.65 1,055.00 TOTAL PLANNING &'ZONING 305,905'' 14,726.35' 1,527.12 81,011179 128,725.74 290 LEGAL SERVICES Operations Support 13,000 - - 7,624.24 8,117.96 Professional Services 245,000 - - 55,860.64 64,688.43 TOTAL LEGAL SERVICES 258,000,', - - 63,484.88 72,806.39 z CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 Personnel Services 630,024 67,075.56 - 330,671.99 364,451.43 Supplies 59,900 4,114.89 638.43 29,703.30 39,409.79 6,889 Utility Services 93,600 5,555.42 - 51,167.17 40,208.76 Operations Support - - - - - Staff Support 10,212 405.15 403.00 3,143.52 6,684.29 533 Maintenance Services 108,500 11,071.95 6,471.04 61,897.03 83,468.38 16,851 Rental /Leasing 2,000 - - 568.35 763.92 Operating Equipment 950 - - - 289.45 Capital Outlay 24,500 2,524.53 - - 2,524.53 TOTAL FACILITIES MAINTENANCE '' 929,686'' 90,747.50 7,512.47 477, 151:36 537,800.55 24,275 CITY SECRETARY Personnel Services 167,842 17,993.86 - 93,336.75 94,825.67 Supplies 1,550 31.02 - 304.42 1,049.97 City Support Services 6,788 - - 4,174.71 3,440.00 3,348 Operations Support - - - - - Staff Support 5,700 - 295.00 2,279.18 3,291.77 784 TOTAL CITY SECRETARY 1181,880' 18,024.88' 295.0,0 1100,095.06 102,607.41 4,132, NON - DEPARTMENTAL Supplies 3,000 143.99 - 4,781.60 395.35 City Support Services 361,407 - 760.00 287,862.86 246,823.36 Operations Support 115,500 7,035.83 - 68,441.63 76,614.14 440 City Assistance 390,552 96,864.87 - 426,747.67 326,077.60 Professional Services 99,521 25,859.03 - 43,809.08 79,567.90 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,001,830' 129,90372' 760.00 894,023!22 729,478.35 440 PUBLIC AFFAIRS Personnel Services 138,096 16,773.84 - 114,333.10 84,105.96 Supplies 2,450 - - 1,507.78 460.05 27 Operations Support 34,500 835.01 - 42,537.37 8,949.03 1,654 Staff Support 3,750 - - 1,873.01 1,084.90 139 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 TOTAL GENERAL GOVERNMENT 126,426 14,350.23 1,000 - 258,500 11,852.91 385,926' 26,203.14' 70,675.87 - 23 127,878.17 3,053 198,554.04 3,076', 169,469 CITY OF SCHERTZ - 91,306.05 93,940.38 REVENUE AND EXPENSE REPORT (UNAUDITED) - - 33.05 67.35 AS OF: APRIL 30th, 2011 - - 871.00 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 200,026' 26,918.42' - 97,820.78 112,485.47 55 - - - 133, 913.78 - 6,000 - - 1,399.71 1,894.78 1,383 184,796'' 17,608.85 - 295,564175 96,494.72 1,821' 46,317 5,037.55 - 25,108.88 26,531.90 900 - - - 75.00 11 1,500 - - 706.00 641.90 173 17,992 274.00 - 4,282.05 6,739.14 750 66,709' 5,311.55' - 30,096.93 33,987.94 934 126,426 14,350.23 1,000 - 258,500 11,852.91 385,926' 26,203.14' 70,675.87 - 23 127,878.17 3,053 198,554.04 3,076', 169,469 18,290.92 - 91,306.05 93,940.38 300 - - 33.05 67.35 55 2,213 - - 871.00 395.00 24,000 8,627.50 - 4,410.68 15,337.50 4,044 - - 1,200.00 2,745.24 200,026' 26,918.42' - 97,820.78 112,485.47 55 117,358 12,941.67 - 64,179.69 66,274.60 3,300 - - - 1,113.00 1,383 1,050 - - - - 2,000 - - - - 123,708'' 12,941.67' - 64,179169 67,387.60 1,383, 4,924,409,' 475,839.74', 10,946.83 2,743,652,99 2,781,427.10 53,525 a CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 488,466.32 - 2,351,080.49 2,448,829.57 Supplies 50,558 160.00 124.50 9,664.50 7,472.58 13,763 City Support Services 30,000 - - 32,003.00 - Utility Services 100,000 9,515.55 - 46,009.14 47,626.06 Operations Support 2,000 - - 152.50 98.00 Staff Support 31,350 2,038.58 - 5,800.43 5,867.23 1,040 City Assistance 13,000 - - 5,135.95 1,664.98 2,469 Professional Services 8,000 - - 4,803.36 - Maintenance Services 76,949 - 179.50 32,351.48 22,096.85 965 Operating Equipment 63,996 - 5,196.00 32,162.05 31,735.12 13,801 Capital Outlay 169,998 5,854.40 - 108,983.20 153,726.40 TOTAL POLICE 4,628,881'' 506,034.85 5,500.00 2,628,146,10 2,719,116.79 32,040 FIRE RESCUE Personnel Services 2,410,836 270,710.53 - 1,306,470.79 1,395,664.32 Supplies 20,200 1,422.90 20.15 5,061.39 4,655.89 219 Utility Services 43,900 4,347.19 - 21,349.62 23,275.85 Operations Support 1,100 - - 299.97 120.00 Staff Support 116,800 6,122.80 12,138.00 32,341.68 48,380.90 18,068 City Assistance 18,600 - 10,323.17 2,715.75 10,323.17 Professional Services 18,140 - - - 1,500.00 Maintenance Services 55,000 2,509.20 - 9,887.27 15,183.21 16,853 Operating Equipment 44,400 12,798.57 604.50 14,810.75 26,615.33 1,279 TOTAL FIRE '' 2,728,976'' 297,911.19' 23,085.82 1,392,937.22 1,525,718.67 36,4211 INSPECTIONS Personnel Services 364,194 39,897.92 - 193,970.87 207,197.60 Supplies 6,750 - 375.00 7.90 590.21 322 Utility Services 7,600 550.73 - 1,969.28 2,670.09 Operations Support 3,200 - - 375.00 439.87 Staff Support 14,700 83.20 388.20 3,211.07 2,303.15 355 Professional Services 10,000 - - 459.00 - Maintenance Services - - - - - Operating Equipment - - - - - TOTAL INSPECTIONS 406,444' 40,531.85' 763.20 1199,993,12 213,200.92 678 5 101 GENERAL FUND FINANCIAL SUMMARY MARSHAL SERVICE Personnel Services Supplies Utility Services Operations Support Staff Support Professional Services Maintenance Services Operating Equipment Capital Outlay TOTAL MARSHAL SERVICE TOTAL PUBLIC SAFETY' PUBLIC ENVIRONMENT STREETS Personnel Services Supplies Utility Services Operations Support Staff Support Maintenance Services Rental /Lease Operating Equipment Capital Outlay TOTALSTREETS TOTAL PUBLIC ENVIRONMENT' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 486,250 55,336.26 - 210,296.59 6,120 250,527.94 28.15 101,900 6,450 - - 1,146.65 - 166.30 9,265 493 9,000 1,053.29 - 3,136.69 16,620.12 3,878.55 - - 4,000 - - 375.00 14,500 367.49 - 1,078 9,400 - - 2,611.99 89,309.76' 1,552.24 405 12,400 1,064.85 - 2,020.53 7,453.85 21,480 2,472.91 - - 8,190.98 4,971 65,600 3,965.98 - - 45,526.27 9,723 614,580 63,89329' - 219,587.45 317,663.62 16,671' 8,378,881I' 908,371.18' 29,349.02 4,440,663.89 4,775,700.00 85,811'. 596,591 53,900.63 - 6,120 471.44 28.15 101,900 11,899.88 - 1,380 - - 9,265 903.76 84.08 155,400 22,134.05 16,620.12 200 - - 4,380 - - 14,500 - - 889,736'' 89,309.76' 16,732.35 889,736' 89,309.76' 16,732.35 6 341, 051.85 339, 807.41 2,608.62 2,945.83 437 48,919.72 57,075.21 1,017 - - 21 3,044.03 4,036.42 345 46,323.19 92,248.30 9,244 - 4,200.00 - 13,670.00 441, 947.41 513, 983.17 11,066 441,947.41 513,983.17 11,066' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 51,871.90 - 261,704.47 270,102.14 Supplies 40,355 272.47 - 34,404.65 19,685.06 2,985 City Support Services - - - - - Utility Services 110,000 16,797.54 - 49,788.28 61,503.83 933 Operations Support 700 - 600.00 - 880.80 Staff Support 7,686 259.80 202.35 5,663.23 5,801.97 268 Professional Services 53,278 1,900.00 - - 19,445.00 2,020 Maintenance Services 21,000 232.62 - 30,589.26 10,637.15 1,791 Rental /Leasing 30,531 - 3,491.50 857.75 23,760.56 3,225 Operating Equipment 200 - - 5,974.00 3,494.99 Capital Outlay 7,000 769.00 - - 2,893.50 TOTAL PARKS DEPARTMENT 746,612'' 72,10333 4,293.85 388, 984,64 418,205.00 11,223 SWIM POOL Supplies 16,700 4,081.63 123.66 3,662.92 4,970.18 174 Utility Services 25,500 773.01 - 11,773.15 6,354.72 Staff Support 925 - - 439.98 - Maintenance Services 199,378 568.83 - 3,180.06 4,780.77 Rental /Lease 500 - - - 378.00 TOTAL SWIM POOL 243,003' 5,423.47', 123.66 19,056,11 16,483.67 174 COMMUNITY /CIVIC CENTER Personnel Services 112,341 10,043.32 - 43,785.42 41,441.09 Supplies 6,423 - - 2,906.95 5,347.02 247 Utility Services 47,150 2,476.30 - 19,614.04 16,403.84 Operations Support 14,682 730.00 - 12,000.57 5,244.51 837 Staff Support 3,250 - - 300.16 250.00 370 Professional Services 600 - - - 925.00 Operating Equipment 7,172 - - 33,303.10 285.00 3,845 TOTAL COMMUNITY /CIVIC CNTR 1,91,618' 13,249.62' - 1,11,910'.24 69,896.46 5,300, 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: APRIL 30th, 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,81,233,' 90,776.42', 4,417.51 525,502.74 504,759.55 16,699 667,832 75,942.41 - 16,400 175.45 - 39,500 3,231.50 2,609.74 - 2,500 - 2,065.00 - 4,185 297.95 23.25 2,100 - - - 3,500 - 451,181.25 - 65,000 563.73 47.36 - - 10,500.00 801,017'' 80,211.04 10,570.61 340,440.54 386,347.98 7,846.01 5,158.65 803 27,676.09 21,843.74 745.00 70.00 2,609.74 998.46 302 200.68 2,065.00 2,896.25 1,200.00 32,286.33 22,997.42 14,781 - 10,500.00 414,700.64 451,181.25 15,887. 801,017' 80,211.04', 1,0,570.61, 414,700.64 451,181.25 15,887, 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: APRIL 30th, 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 33,214.88 - 151,591.77 174,676.23 1,500 24,900 2,328.33 42.00 8,976.26 9,867.92 1,024 9,900 999.73 - 4,618.43 5,413.47 - 60, 902.12 800 - - 263.00 - 3,285.68 5,800 - - 4,520.84 1,602.00 50 13,000 2,473.61 - 3,159.72 5,831.96 639 14,500 157.50 - 5,895.50 5,544.00 942 6,100 - (112.00) 1,008.48 1,926.78 1,414 9,000 40.80 - 277.90 563.21 146 4,000 - - - 3,995.00 390,083 39,214.85' (70.00) 180,311.90 209,420.57 4,216' 390,083' 39,214.85' (70.00) 180,311.90 209,420.57 4,216 261,085 26,633.95 - 128,540.21 147,356.01 1,500 - - 454.13 439.01 511 337,952 78,620.38 - 38,917.49 149,011.92 22,510 147,131 11,677.43 - 60, 902.12 69,447.24 1,729 10,400 - 1,813.95 2,503.04 3,285.68 1,944 21,100 872.71 - 17, 473.54 13,122.78 1,481 135,836 15,588.89 - 58,021.85 45,297.50 39,015 45,809 - - 10,527.00 - 35,880 960,813'' 133,39336' 1,813.95 317,339.38 427,960.14 103,071' 9 101 GENERAL FUND FINANCIAL SUMMARY HUMAN RESOURCES Personnel Services Supplies Human Services Operations Support Staff Support City Assistance Professional Services Operating Equipment TOTAL HUMAN RESOURCES FINANCE Personnel Services Supplies Operations Support Staff Support Maintenance Services Operating Equipment TOTAL FINANCE PURCHASING & ASSET MGT Personnel Services Supplies Utility Services Operations Support Staff Support Operating Equipment TOTAL PURCHASING &ASSET MGT CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 222,521 26,683.53 - 122,855.93 123,960.48 1,700 - - - 633.78 46,122 79.00 - 23, 054.01 17, 981.58 34 12,545 1,307.58 266.28 6,795.32 6,654.41 1,597 10,982 200.00 - 5,798.49 5,921.10 9,425 1,081.00 - 5,437.00 3,240.00 469 2,500 - - - - - - - 1,491.55 - 305,795, 29,351.11', 266.28 165,432,30 158,391.35 2,100 419,818 46,233.70 - 238,823.78 237,662.41 3,600 481.73 - 927.10 1,915.44 51 1,050 - - 155.80 - 13,370 151.16 74.30 4,685.39 5,642.61 1,082 630 - - - - 5,699 13.99 - - 880.68 197 444,167'' 46,880.58 74.30 244,592,07 246,101.14 1,331' 234,220 25,817.55 - 133,547.10 133,825.96 2,300 - - 300.87 234.58 186 1,200 53.72 - 218.42 185.42 150 - - - 60.68 6,900 73.70 - 3,639.30 3,254.27 1,188 150 - - - - 244,920' 25,944.97, - 137,705.69 137,560.91 1,375, 10 TOTAL MISC & PROJECTS' 52,000'' 10,500.00 - 10,000,00 36,714.21 10,500 TOTAL EXPENDITURES I' 18,885,872I' 1,962,207.13' 79,276.79 9,784,913165 10,424,749.76 328,534 REVENUE OVER(UNDER) EXPEND. 546'' 3,828,962.67' m CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 16,840.11 - 85,658.76 90,766.43 Supplies 101,000 11,038.04 4,701.70 58,603.84 61,175.78 6,442 City Support Services 1,500 - - 1,500.00 1,500.00 Utility Services 7,000 628.01 - 2,311.72 2,194.43 Operations Support 400 - - - 375.00 Staff Support 2,435 130.57 - 575.88 1,083.73 105 Professional Services - - - - - Maintenance Services 45,750 2,997.23 474.24 14,414.44 23,524.84 16,401 Rental /Lease 200 - - - 150.00 Operating Equipment 6,000 780.16 - - 780.16 TOTAL FLEET SERVICE 312,818,' 32,414.12', 5,175.94 1,63,064.64 181,550.37 22,949 TOTAL INTERNAL SERVICE 2,268,513'' 267,984.14 7,330.47 1,028,134.08 1,151,563.91 130,828' MISC & PROJECTS CITY ASSISTANCE Utility Services - - - - 214.21 Patient Assistance 5,000 - - 5,000.00 5,000.00 Children's Advocacy Assistance 5,000 - - 5,000.00 - Senior Citizen's Hot Meals 42,000 10,500.00 - - 31,500.00 10,500 TOTAL CITY ASSISTANCE 52,000' 10,500.00, - 10,000.00 36,714.21 10,500', TOTAL MISC & PROJECTS' 52,000'' 10,500.00 - 10,000,00 36,714.21 10,500 TOTAL EXPENDITURES I' 18,885,872I' 1,962,207.13' 79,276.79 9,784,913165 10,424,749.76 328,534 REVENUE OVER(UNDER) EXPEND. 546'' 3,828,962.67' m 101 GENERAL FUND REVENUES Taxes 37,341.36 000 - 411100 Advalorem Tax - Current 000 - 411200 Advalorem Tax - Delinquent 000 - 411300 Advalorem Tax - P &I 000 - 411500 Sales Tax Revenue -Gen Fund 000 - 411600 Bingo Tax 000 - 411700 Mixed Beverage Tax TOTAL Taxes AT &T Franchise Fee Franchises 37,341.36 000 - 421200 Center Point /Entex Energy 000 - 421220 City Public Service 000 - 421240 Guadalupe Valley Elec Co -op 000 - 421250 New Braunfels Utilities 000 - 421300 Time Warner -State Franchise 000 - 421350 Time Warner -PEG Fee 000 - 421460 AT &T Franchise Fee 000 - 421465 AT &T PEG Fees 000 - 421480 Other Telecom Franchise 000 - 421500 Solid Waste Franchise Fee TOTAL Franchises CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2011 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -E BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUM 6,704,566 37,341.36 275,000 50,000 11,758.06 99,914.05 50,000 5,105.79 350,000 4,071,590 283,300.36 - 4,500 - - 32,000.00 8,623.77 78.14 10,912,656 346,129.34' 1,52,1,000 33,000 - 275,000 - 430,000 99,914.05 30,000 - 350,000 - 62,000 - 220,000 - 16,000 - 15,000 78.14 90,000 8,759.14 1,52,1,000 108;751.33' 6,176,393.49 6,654,501.75 - 46,054.64 40,696.09 - 28,449.16 29,559.29 - 1,618,026.20 2,458,631.50 - 2,639.06 1,132.33 23,801.88 25,353.01 7,895,364.43 9,209,873.97 - 23,991.96 26,623.10 - 138,822.31 146,124.73 - 234,006.04 Home Occupation Permit 311,679.19 - 6,383.04 - 385.00 13,037.36 - 158,262.23 Building Permit 169,803.13 - 29,999.31 - 367,085.52 32,786.97 - 73,793.62 Mobile Home Permit 88,676.29 7,984.07 - 80.00 11,331.90 - 6,271.20 Signs Permit 13,466.03 50,482.73 61,281.62 729, 996.51 874, 81I 0.32 Permits 000 - 431100 Home Occupation Permit 770 35.00 - 385.00 280.00 000 - 431200 Building Permit 837,952 99,636.00 - 367,085.52 1,003,594.83 000 - 431300 Mobile Home Permit 671 - - 80.00 80.00 000 - 431400 Signs Permit 8,596 55.00 - 310.00 420.00 000 - 431500 Food Establishmnt Permit 15,000 1,025.00 - 11,750.00 13,520.00 000 - 431600 Garage Sale Permit 9,554 1,410.00 - 6,125.30 5,845.00 000 - 431700 Plumbing Permit 109,769 24,789.00 - 48,372.50 75,750.50 000 - 431750 Electrical Permit 63,062 23,840.00 - 30,715.50 49,860.00 000 - 431800 Mechanical Permit 84,211 22,460.00 - 40,854.00 53,880.00 000 - 431900 Solicitor /Peddler Permit - 60.00 - 570.00 320.00 000 - 431950 Animal /Pet Permit 2,000 - - 1,155.00 1,385.00 12 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 - - 3,150.00 3,000.00 000 - 432100 Security Alarm Permit 36,000 3,450.00 - 20,656.00 23,438.00 000 - 435000 Fire Permit 7,750 550.00 - 3,912.50 5,337.50 TOTAL Permits 1,181,913 177,310.00 - 535,121.32 1,236,710.83' Licenses - 30.00 - 000 - 441000 Alcohol Beverage License 6,100 1,572.50 - 2,267.50 2,782.50 000 - 442000 Contractors License 55,447 1,725.00 - 18,428.00 18,700.00 000 - 444000 Pet License 3,000 450.00 - 3,031.00 2,563.10 TOTAL Licenses 64,547 3,747.50 - 23,726.50 24,045.60', Fees 000 - 451000 Municipal Court Fines 1,540,000 97,578.64 - 726,720.01 632,751.11 000 - 451100 Arrest Fee 60,000 3,244.18 - 30,385.50 26,591.19 000 - 451110 Expunction Fee 90 - - 30.00 - 000- 451200 Warrant Fees 187,500 10,092.63 - 78,623.65 75,590.79 000 - 451320 Civil Justice Fee -Court 500 4.82 22.97 39.58 000 - 451340 Judicial Fee - City 7,000 435.58 - 3,956.61 3,548.82 000 - 451400 Traffic Fine Costs TTL 30,000 1,636.95 - 15,635.61 13,356.54 000 - 451500 Teen Court Admin Fee 500 - - 460.00 220.00 000 - 451510 Juvenile Case Mgmt Fee 60,000 3,639.56 - 32,956.58 29,587.83 000 - 451600 Technology Fund Fee 55,000 3,013.77 - 27,192.23 24,061.07 000 - 451700 Security Fee 40,000 2,260.33 - 20,406.32 18,054.81 000 - 451800 Time Payment Fee - City 5,000 364.03 - 2,347.12 3,749.65 000 - 451850 State Fines 10% Service Fee 70,000 16,062.05 - 50,640.93 49,510.11 000 - 451900 DPS Payment - Local 12,250 844.86 - 6,289.19 6,318.08 000 - 452000 Child Safety Fee 8,000 1,079.32 - 4,772.10 6,730.42 000 - 452050 Indigent Defense Fee 22,500 1,411.28 - 12,704.10 11,406.32 000 - 452100 Platting Fees 66,000 1,500.00 - 31,750.00 39,000.00 000 - 452200 Site Plan Fee 26,400 1,500.00 - 18,149.45 16,500.00 000 - 452300 Plan Check Fee 375,000 50,169.50 - 185,149.41 507,816.91 000 - 452310 Miscellaneous Review Fee - - - 3,900.00 - 000- 452320 Tree Mitigation Admin Fee 11,220 - - 9,468.75 - 000- 452400 BOA/Zoning Fees 11,000 - - 4,500.00 1,400.00 000 - 452500 Food Handler Class 8,000 460.00 - 2,980.00 4,760.00 000 - 452600 Specific Use /Zone Chng Fee 14,630 - - 4,000.00 11,000.00 000 - 452610 Plat Recording Fee - - - - - 000- 452710 Zoning Ltr & Dev Rights - 75.00 - 375.00 300.00 13 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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,475.00 - 27,143.02 25,650.00 000 - 453110 Swim Pool Inspection Fee - 150.00 - 975.00 825.00 000 - 453120 Inspections Plan Review - - - 833.00 - 000- 453200 Mowing Fees - Inspections - 1,087.69 - 1,979.56 10,970.60 000 - 453211 Admin Fee - Inspections - 200.00 - 5,000.00 4,300.00 000 - 453215 3% Technology Fee - - - 531.40 1.98 000 - 453310 Misc Inspection Fee - - - 40.00 40.00 000 - 453500 SubContractor Reg. Fee - 3,080.00 - 10,500.00 16,865.00 000 - 453710 Foster Care - 50.00 - 300.00 600.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 50.00 - 300.00 650.00 000 - 458100 Sale of Merchandise - - - - - 000- 458300 Sale of Property /Auction 20,000 247.54 - 6,101.89 2,446.09 (67 000 - 458400 Civic Center Rental Fees 226,000 8,690.00 - 105,515.50 70,217.75 000 - 458401 Capital Recovery Fee -Civic Cntr - - - - 1,060.00 000 - 458450 North Center Rental Fees 24,000 1,586.00 - - 5,187.00 000 - 458500 Community Center Rental Fees 32,000 1,679.10 - 17,488.00 9,529.02 000 - 458550 Pavilion Rental Fees - 1,780.00 - - 10,316.70 000 - 458560 Chamber of Comm rent - 1,950.00 - - 5,850.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 - - 79.00 328.00 000 - 459300 Notary Fee 200 33.00 - 153.00 255.00 000 - 459400 Maps, Copies, UDC, & Misc F 200 10.00 - 120.56 603.18 000 - 459600 Animal Adoption Fee 10,500 955.00 - 5,675.00 6,666.50 000 - 459700 Pet Impoundment Fee 17,500 2,664.50 - 9,567.00 12,481.01 000 - 459800 Police Reports Fee 6,532 592.00 - 3,545.10 3,524.20 TOTAL Fees 3,073,872 222,652.33 - 1,489,836.31 1,682,942.02 (67 14 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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,128.94 - 17,413.94 14,917.56 TOTAL Fines 35,000 2,128.94 - 17,413.94 14,9117.56' 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 - 23,486.82 23,486.82 000 - 473300 Guad Co - Library 180,816 15,068.00 - 105,475.37 105,476.00 000 - 473400 Randolph AFB - Animal Cntrl 2,500 100.00 - 758.00 1,300.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 804.53 - 3,975.70 3,927.93 TOTAL Inter- Jurisdictional 405,672 19,327.79 - 276,106.81 207,869.57' Fund Transfers 000 - 480000 Indirect Costs - EMS 87,840 7,320.00 - 43,920.00 51,240.00 000 - 480100 Indirect Costs - Hotel /Motel 170,221 14,185.08 - 63,816.00 99,295.58 000 - 482100 Transfer From Reserves -Ct Tech - - - - 000- 482150 Transfer From Court Security 58,011 - - 000- 485000 Interfund Charge- Drainage 38,888 3,191.50 - 19,149.00 22,635.50 000 - 486000 Interfund Chrges -Admin W &S 624,777 52,064.75 - 319,473.97 364,453.25 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 000 - 487000 Interfund Charges -Fleet 91,737 7,442.08 - 39,830.03 52,094.58 000 - 488000 Interfund Charges -413 53,000 4,619.33 - 27,750.00 32,335.33 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 88,822.74 - 583,496.59 697,426.29', Miscellaneous 000 - 491000 Interest Earned 5,000 29.73 - 3,469.26 1,527.59 000 - 491200 Investment Income 26,000 3,391.66 - 17,785.19 20,473.35 000 - 491900 Unrealized Gain /Loss - 1,328.48 - (5,451.25) (14,362.50) 15 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 000 - 493120 Donations - Public Library - - - - - 000- 493130 Donations - Writing the Next Chap. 20,000 2,743.00 - 10,288.46 24,587.00 000 - 493400 Donation - Animal Control 3,670 280.00 - 2,304.92 2,645.26 000 - 493401 Donations -A/C Microchip 3,000 120.00 - 1,825.00 1,465.00 000 - 493402 Donations - Spay &Neuter 12,000 1,248.75 - 6,387.00 9,905.32 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 1,107.44 - 40,166.31 29,119.38 000 - 497005 Misc Income - Publications 240,000 22,133.95 - 82,377.30 89,442.10 000 - 497007 Misc Income - Schertz Artz - - - - - 000- 497020 Misc Income -Fleet Recycled 400 - - 250.80 - 000- 497100 Misc Income - Police 20,000 310.00 - 11,852.34 14,906.13 000 - 497200 Misc Income - Library 12,131 15,344.40 - 6,127.59 16,995.50 000 - 497210 Misc Income - Library Copier 3,400 1,248.00 1,181.15 6,169.65 000 - 497300 Misc Income - Animal Control 2,400 - - 1,380.45 989.30 000 - 497400 Misc Income - Streets Dept. 11,229 975.00 - 6,550.00 9,500.00 000 - 497500 Misc Income -TML Insurance 78,043 (2.00) - 78,042.55 49,728.90 000 - 497550 Misc Income -TML Reimbursemt 20,211 4,804.01 - 18,779.40 22,447.21 000 - 497600 Misc Income - Parks /Vending Mach. 500 190.93 - 750.15 1,202.59 000 - 497800 Misc Income -Pool Concessions - - - - - 000- 498000 Reimbursmnt -Gen Fund 5,500 199.99 - 3,166.36 1,749.59 000 - 498100 Reimbursmnt Fire - Training - - - - 846.00 000 - 498105 Reimburmnt Police - DEA - - - - 3,785.61 000 - 498110 Reimbursmnt Fire - Emg. Acti -O - - - - 8,078.07 TOTAL Miscellaneous 507,284 55,453.34 - 290,938.92 305,11,6.27', TOTAL REVENUES 18,886,418 1,024,323.31 '' - 11,842,001.33 14,253,712.43' 16 Y -T -E ENCUM GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 294,966.10 Cash in Investment Pools LOGIC Investment - General Fund 4,007,355.00 LOGIC Investment -Equip Replacement 73,250.87 LOGIC Investment -Veh Replacement 7,070.25 LOGIC Investment -Air Condi Replacment 122,270.00 CAPITAL ONE Investment - General Fund 1,322,081.08 Total Cash in Bank & Investment Pools $ 5,949,243.56 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 37,341 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 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: APRIL 30th, 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 - - 28,926.25 30,461.91 2,100.00 - - 2,130.00 - 1,000.00 - - 185.00 23,525.00 22,300.00 13,924.41 - 6,019.38 435.95 1,39,014.00 13,924.41 - 171,604.63 54,422.86 5,150.00 - - - - 5,15000 - - - - 4,750.00 - - - - 13,250.00 - - 10,191.25 12,645.61 102 5,000.00 - - - 126.00 - - - 411.40 - 100.00 - - - - 30,500.00 - - 28,876.25 30,461.91 - - 455.59 306.07 455.91 - - - 3,974.40 - 42,945.00 7,584.96 1,058.00 16,449.39 27,750.50 1,445 9,355.00 8,298.46 - - 8,298.46 55 400.00 - - - 400.00 106,300.00 15,883.42 1,513.59 60,208.76 80,138.39 1,603 1' 11,450.00 15, 883.42 1,513.59 60, 208.76 80,138.39 1,603 REVENUE OVER(UNDER) EXPEND 27,564.00 19 (25,715.53)I SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 50,235.09 Cash in Investment Pools MBIA Special Events 66,514.01 Total Cash in Bank & Investment' Pools $,', 116,749.10 20 202 -WATER & SEWER FINANCIAL SUMMARY REVENUE SUMMARY Franchises Fees Fund Transfers Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2011 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR 138,000 54,475.38 - 138,734.41 164,765.87 - 13,679,750 1,003,605.19 - 6,837,237.26 7,615,480.71 - 503,886 6,718.00 - 39,500.03 47,026.00 - 55,445 61,183.59 - 92,027.10 266,036.05 - 14,377,081 1,125,982.16 - 7,107,498.80'' 8,093,308.63 - NON DEPARTMENTAL Fund Charges /Transfers 31,000 TOTAL NON DEPARTMENTAL 31,000' - 31,000.00 - 31,000 - BUSINESS OFFICE Personnel Services 4 458,640 4 42,867.16 - - 1 184,373.28 2 244,257.61 - - Supplies 6 6,050 - - - - 1 1,276.09 1 1,361.99 1 1,039.3 Operations Support 1 108,500 5 585.00 - - 5 57,000.36 3 39,720.65 - - Staff Support 8 8,450 9 93.64 - - 6 624.60 1 1,370.86 3 343.81 Professional Services 1 14,500 1 1,421.83 - - 9 9,780.58 7 7,206.50 - - Fund Charges /Transfers 4 40,000 - - - - - - - - - - Maintenance Services 1 12,000 4 420.00 - - 6 6,470.00 3 3,500.00 2 2,520.01 Operating Equipment 6 6,800 - - - - - - 6 6,117.62 - - TOTAL BUSINESS OFFICE 6 654,940 4 45,387.63 - - 2 259,524.91 '' 3 303,535.23 3 3,903.1! W & S ADMINISTRATION Personnel Services 1 1,212,507 1 124,729.04 - - 7 757,133.27 7 711,269.75 - - Supplies 2 213,520 2 2,537.76 3 338.73 9 93,208.75 9 90,659.66 8 8,719.3; Human Services 3 338 - - - - - - 6 64.00 - - City Support Services 7 77,826 8 87.50 - - 1 19,361.65 3 34,899.05 - - Utility Services 2 2,780,900 1 199,132.25 - - 1 1,315,672.11 1 1,105,825.47 1 1,611.7 Operations Support 8 8,750 2 256.01 7 79.60 1 1,506.61 1 1,906.70 4 44.01 Staff Support 3 33,000 8 895.99 1 1,339.00 8 8,637.94 1 12,340.07 2 2,268.1 - 21 22 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 18,280 - 3,420.00 (3,400.00) 12,675.09 2,500.01 Capital Outlay 58,000 - 52,432.00 - 133,169.40 - Water Line Relocation - - - 357,830.77 - - TOTAL PUBLIC WORKS 13,254,862 1,022,072.92 67,5!95.74 7,129,896.80'' 6,916,864.24 19,188.01, MISC & PROJECTS PROJECTS FUND CHARGES /TRANSFERS - - - - - - TOTAL PROJECTS '' AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services 3,862 - - - - - Operations Support 500 - - - - 248.0, Professional Services 62,988 3,743.14 - 29,368.53 41,348.45 - Maintenance Services 335,500 - - 145,754.08 303.28 - TOTAL AVIATION HEIGHTS WTR IMP 402,850 3,743.14 - 175,,122.61 41,651.73 248.0, FM3009 RD &BRIDGE EXPANSION Professional Services 23,270 - 19,137.50 14,708.06 30,358.80 - Maintenance Services 38 - - 695,900.72 37.74 - TOTAL FM3009 RD &BRIDGE EXPANSION 23,308 - 19,138 710,609 30,396.54 - TOTALL'MISC &'PROJECTS 426,158 3,743.14 19,137.50 885,,731.39 72,048.27 248.0, TOTAL EXPENDITURES 14,366,960 1,071,204 86,733 8,275,153 7,323,448 23,33? — REVENUE OVER(UNDER)EXPENSES ** 10,121 769,860.89 22 202 -WATER & SEWER REVENUES Franchises 000 - 421490 Tower Leasing TOTAL Franchises Fees 000 - 455200 Garbage Collection Fee 000 - 455600 Fire Line Fees 000 - 455700 Recycle Fee Revenue 000 - 455800 W &S Line Constructn Reimbursemnt 000 - 457100 Sale of Water 000 - 457110 Edwards Water Lease 000 - 457120 Water Transfer Charge -Selma 000 - 457130 Water Transfer Charge -U. C. 000 - 457200 Sale of Meters 000 - 457400 Sewer Charges 000 - 457500 Water Penalties 000 - 459200 NSF Check Fee -Water &Sewer TOTAL Fees Fund Transfers 000 - 486101 Transfer In- General Fund 000 - 486204 Interfnd Chrg- Drainage Bill TOTAL Fund Transfers'' Miscellaneous 000 - 490000 Misc Charges 000 - 491000 Interest Earned 000 - 491200 Investment Income 000 - 493130 Library Donations 000 - 493400 Donations - Christmas Activitise 000 - 496050 SSLG - SAWS Reservation 000 - 497000 Misc Income -W &S 000 - 497550 TML Reimbursements 000 - 498100 Reimbursement -EMS Loan 000 - 498110 Reimbursement -SSLGC 000 - 498200 W &S Project Reimbursement TOTAL' Miscellaneous TOTAL REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 138,000 54,475.38 - 138,734.41 164,765.87 138,000 54,475.38 - 138,734.41 164,765.87 3,300,000 252,907.31 18,500 - 155,000 15,548.66 50,000 1,893.11 7,200,000 500,532.73 127,250 - 5,000 - 1,000 - 86,000 8,400.43 2,560,000 211,209.41 175,000 12,970.28 2,000 143.26 13 679,750 1,003,605.19 423,270 - 80,616 6,718.00 503,886 6,718.00' 15,000 - 500 30.92 5,000 562.27 20,000 (1,183.90) 9,945 - - 25,699.30 5,000 36,075.00 55,445 61,183.59' 14 377, 081 1,125, 982.16 23 1,683, 853.90 1,853,681.97 18,190.00 18,430.00 85,392.64 119,317.03 16,511.76 17,889.92 3,187,471.08 3,763,767.18 34,340.05 153,410.82 780.18 1,339.20 3,914.06 1.28 35,220.02 50,598.32 1, 674, 577.10 1,541,193.61 95,558.84 94,525.90 1,427.63 1,325.48 6,837,237.26 7,615,480.71' - 39,500.03 47,026.00 39,500.03 47,026.00' - 11,064.71 4,331.88 - 264.42 1,128.31 - 34,044.48 7,451.85 - 5.13 - - - 1,000.00 - - 134,500.00 - 20,374.85 (2,175.38) - - 2,291.34 - 25,165.01 76,314.75 - 1,108.50 41,193.30 92,027.10 266,036.05' - 7,107,498.80 8,093,308.63' WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ (17,449.98) 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,790,740.22 293,362.62 372,684.31 543,418.26 1,044,420.00 $ 4,044,625.41 Total Cash in Bank & Investment Pools $ 4,027,175143 24 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 203 -EMS CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR REVENUE SUMMARY Fees 5,436,537 110.00 - 2,504,709.68 1,643,128.50 Inter - Jurisdictional 1,432,345 346,337.39 - 965,034.27 1,013,959.52 Miscellaneous 334,850 24,548.57 - 106,420.24 110,211.49 TOTAL REVENUES 7,203,732 370,995.96 - 3,576,164.19 2,767,299.51 PUBLIC SAFETY SCHERTZ EMS Personnel Services 2,391,410 277,202.99 - 1,503,520.94 1,559,383.12 - Supplies 327,874 28,016.44 382.34 185,860.75 164,690.04 60,481.1E Human Services 847 - - - 580.00 - City Support Services 15,000 72.10 - 14,850.78 10,974.19 - Utility Services 80,438 9,916.27 - 39,007.49 51,892.60 12.5C Operations Support 33,500 1,450.29 - 20,218.40 32,316.94 1,328.37 Staff Support 75,600 2,293.46 171.35 57,908.43 32,945.95 17,215.98 City Assistance 11,753 2,002.00 - 6,023.05 5,497.00 250.00 Professional Services 136,390 22,837.69 160.00 68,581.48 72,991.84 5,877.15 Fund Charges/Transfers 3,576,092 9,825.00 - 2,038,239.36 294,450.94 - Maintenance Services 42,320 197.39 - 22,411.34 20,369.91 1,410.00 Debt Service 248,502 - - 9,523.75 69,799.33 - Rental- Leasing 40,000 - - 4,011.03 1,682.20 - Operating Equipment 76,600 2,856.98 - 34,496.17 13,427.14 2,327.14 TOTAL PUBLIC SAFETY'' 7,056,326 356,670.61 713.69 4,004,652.97' 2,331,001.20 88,902.33 TOTAL EXPENDITURES 7,056,326 356,670'_61 713.69 4,004,652.97' 2,331,001.20 88,902.33 "" REVENUE OVER(U,NDER)'EXPENSES " 147,406 4,36,298.31 2s CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 - 491200 Investment Income - 42.39 - 99.97 370.84 000 - 456100 Ambulance /Mileage Transprt 5,336,537 6,000 - - 2,491,642.68 - 1,227.75 1,624,678.50 - 000- 456110 Subscription Program Fees 100,000 110.00 1,000.00 - 13,047.00 - 18,450.00 - 000- 459200 NSF Check Fee - - - - 20.00 - - - - TOTAL Fees 5,436,537 110.00 Misc Income - 2,504,709.68 14,897.27 1,643,128.50 - Inter - Jurisdictional 53,528.24 - 000- 497100 Recovery of Bad Debt 100,000 853.91 000 - 473500 Seguin /Guadalupe Co Support 286,126 47,687.74 000- - 166,907.09 Misc Income -EMT Classes 191,850.89 - 000- 474300 Cibolo Support 219,699 53,325.00 TOTAL Miscellaneous - 159,975.00 334,850 159,975.00 - 000- 475100 Comal Co ESD #6 75,369 37,253.44 - 18,293.44 37,920.00 - 000- 475200 Live Oak Support 152,569 37,031.25 - 3,576,164.19 - 111,093.75 - 111,093.75 - 000- 475300 Universal City Support 210,545 51,103.13 - 153,309.39 153,309.39 - 000- 475400 Selma Support 64,689 17,182.50 - 47,103.75 51,547.50 - 000- 475500 Schertz Support 399,083 96,864.87 - 290,594.61 290,594.61 - 000- 475600 Santa Clara Support 10,851 2,633.67 - 7,989.87 7,901.01 - 000- 475800 Marion Support 13,414 3,255.79 - 9,767.37 9,767.37 - TOTAL Inter - Jurisdictional 1,432,345 346,337.39 - 965,034.27 1,013,9159.52 - Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Income - 42.39 - 99.97 370.84 - 000- 493203 Donations -EMS 6,000 200.00 - 1,227.75 1,300.00 - 000- 493204 Donations - Dilworth Fund - 1,000.00 - - 1,000.00 - 000- 493205 Donations- Golf Tournament - 350.00 - - 350.00 - 000- 497000 Misc Income 150,000 14,897.27 - 62,268.23 53,528.24 - 000- 497100 Recovery of Bad Debt 100,000 853.91 - 1,879.29 9,122.41 - 000- 497500 Misc Income -EMT Classes 78,850 7,205.00 - 40,945.00 44,540.00 - TOTAL Miscellaneous 334,850 24,548.57 - 106,420.24 110,211.49 - TOTAL REVENUES 7,203,732 370,995.96 - 3,576,164.19 2,767,299.51 - 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ (52,360.17) Cash in Investment Pools LOGIC Investment -EMS MBIA Investment -EMS Note 2010 300,563.95 Total Cash in Bank & Investment Pools $ 248,203.78' 27 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 49,413.05 - 384,000.70 402,648.35 - 2 Miscellaneous 1,300 87.62 - 974.09 720.62 - _ TOTAL REVENUES 676,600 49,500.67 '' - 384,974.79 403,368.97 - 2 PUBLIC WORKS DRAINAGE Personnel Services 361,183 37,692.51 - 200,785.01 209,773.91 - 1 Supplies 8,300 133.42 28.15 1,080.41 747.60 517.76 Human Services 100 - - - - - City Support Services 26,500 - - 976.00 4,332.18 - Utility Services 12,888 1,483.20 - 6,651.27 6,299.19 593.79 Operations Support 2,458 - - - - - Staff Support 8,255 218.35 168.83 2,051.41 2,317.84 201.45 City Assistance 840 - - 102.00 15.00 - Professional Services 19,800 - - 5,197.10 10,000.00 - Fund Charges/Transfers 195,449 10,838.25 - 64,652.83 76,162.75 - 1 Maintenance Services 22,000 - - 4,663.26 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'' 50,365.73 '' 196.98'' 288,442.74 313,654.25 1,313.00 3 TOTAL EXPENDITURES 676,511'' 50,365.73 '' 196.98'' 288,442.74 313,654.25 1,313.00 3 "" REVENUE OVER(UNDER) EXPEND 89' 2s 89,714.72'' 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: APRIL 30th, 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 382.74 671,800 49,030.31 675,300, 49,413.05, 100 20.28 600 53.48 600 13.86 1,300 87.622 676,600 49,500.67 29 2,220.11 381,780.59 384, 000,.70 54.69 387.95 531.45 974.09 2,493.62 400,154.73 402,648.35, 186.32 400.38 133.92 720.62 384,974;79 403,368.97 - 271 272 27 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: APRIL 30ht, 2011 Cash in Bank Claim on Operating Cash Pool- Checking 205,941.48 Cash in Investment Pools Lone Star Investment - Drainage Maint Fund 282,855.82 Total Cash in Bank & Investment Pools $ 488,797.30 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: APRIL 30th, 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 24,278.96 - 143,148.19 156,743.21 - 55,000 - - - - - 5,550 23.42 - 237.45 250.07 445,550 24,302.38 - 143,385.64 156,993.28 - 31,841 - - - - - 2,526 819.90 - - 819.90 1,495.50 78,228 14,557.00 502.85 34,427.50 44,173.85 - 85,898 500.00 - - 6,452.88 - 2,500 - - 902.28 - - 231,485 14,185.08 - 149, 060.00 99,295.58 - 432,478 30,061.98 502.85 184,389.78 150,742.21 1,495.50 TOTAL EXPENDITURES 432,478 30,061.98 502.85' 184,389.78 150,742.21 1,495.50 REVENUE OVER(UNDER)'EXPENDITURE 13,072'' 6,251.07'' 31 32 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 24,278.96 - 143,148.19 156,743.21 - 228 TOTAL Taxes 385,000 24,278.96 - 143,148.19 1,56,743.21 - 228 Fund Transfers 000 - 481000 Transfer From Reserve 55,000 - - - - - 55 TOTAL Fund Transfers 55,000 - - - - - 55 Miscellaneous 000 - 491000 Interest Earned 250 13.83 - 169.65 165.29 - 000- 491200 Investment Interest 300 9.59 - 67.80 84.78 - 000- 497000 Misc Income 5,000 - - - - - 5 TOTAL Miscellaneous' 5,550 23_42 - 237.45'' 250.07 - 5 TOTALIREVENUES 445,550 24,302.38 - 143,385.64 156,993.28 - 288 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 124,406.16 Cash in Investment Pools Federated Investment -Hotel /Motel 78,086.58 Total Cash in Bank '& Investment Pools $' 202,492.74' 33 HOTEL OCCUPANCY TAX 2010 -11 27,689 25,112 23,231 19,619 22,667 36,728 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: APRIL 30th, 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 E 40,000 25,000.00 - 10,000.00 107,000.00 - 40,000 - - 53,756.25 - - 405 46.39 - 362.65 418.22 - 80,405 25,046.39 - 64,118.90 107,41!8.22 - PARKLAND DEDICATION Maintenance Services- Landscape 8,000 - - 1,286.36 12,234.00 - Operating Equipment 30,000 6,377.28 11,244.23 60,774.95 48,223.50 3,923.18 Capital Outlay 6,000 - - - 4,980.30 - _ TOTAL PARKLAND DEDICATION 44,000'' 6,377.28 11,244.23 '' 62,061.31 65,437.80 3,923.18 TREE MITIGATION Fund Charges/Transfers Maintenance Services -Trees Capital Outlay TOTAL TREE MITIGATION' TOTAL EXPENDITURES - - - 4,133.27 - - 36,000 - 3,133.00 29,693.67 18,171.00 789.50 36,000' - 3,1133.00 33,826.94 18,171.00 789.50 80,000 6,377.28 14,377.23 95,888.25 83,608.80 4,712.68 REVENUE OVER(U'NDER)'EXPEN!D 405' 35 23,80!9.42 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 36 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 ENCUMBRANCE 40,000 25,000.00 - 10,000.00 107,000.00 - 40,000 - - 53,756.25 - - 80,000 25,000.00 - 63,756.25'' 107,000.00 - 60 18.00 - 41.09 167.14 - 280 28.39 - 214.06 251.08 - 65 - - 107.50 - - 405 46.39 362.65'' 418.22 80,405 25,046.39 - 64,118.90 1,07,418.22 - 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $191,508.12 Cash in Investment Pools Federated Investment -Park Fund 38,833.99 Federated Investment -Tree Mitigation 192,398.28 Total in Investment Pool 231,232.27 Total Cash in Bank '& Investment Pools' $422,740.39'' 37 318 - RECYCLING FINANCIAL SUMMARY REVENUE SUMMARY Fund Transfer Miscellaneous TOTAL REVENUES' 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: APRIL 30th, 2011 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D E BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR B. 31,000 - - - 31,000.00 - 25,000 - - - - - 2 56,000'' - - - 31,000.00 - 56,000 - - 6,567.02 56,000'' - - 6,567.02 - - F 56,000'' - - 6,567.02 38 31,000.00 39 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2011 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 *** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 318 - RECYCLING CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BL REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BAI Fund Transfers 000 - 486202 Transfer In -W &S 31,000 - - - 31,000.00 - TOTAL Fund Transfers 31,000 - - - 31,000.00 - Miscellaneous 000 - 490210 Sale of Recycle Material 25,000 - - - - - 25 TOTAL Miscellaneous 25,000 - - - - - 25 TOTAL REVENUES 56,000 - - - 31,000 -_ 39 RECYCLE FUND CASH IN BANK AS OF: APRIL 30th, 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 TOTALREVENUES 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 TOTAL MISC & PROJECTSI' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 ENCUMBR I 1,190,640 337,960.47 - 600,057.72 1,588,442.86 - 585,500 33,401.97 - 100,056.10 200,225.34 1,776,140'' 371,362.44 '' - 700,113.82 11,788,668.20 - 1,000 - - - - - 26,800 350.04 - - 2,111.54 - - - - 118,896.50 - - - - 8,428.00 - 8,428.00 27,800'' 350.04 8,428.00'' 118,896.50 10,539.54 - 230,200 6,123.42 53,906.78 180.00 70,106.78 16,741.85 599,643 - - - - - - - - 19,759.00 - - - - - 556,765.33 204,531.74 - 88,252 36,964.47 225,148.72 147,012.34 344,233.90 9118,095'' 43,087.89 '' 279,055.50'' 723, 716.67 618,872.42 16,741.85 TOTAL EXPENDITURES 945,895 43,437.93 287,483.50 842,613.117 629,411.96 16,7411.85 REVENUE OVER(UNDER)',EXPENDITURES 830,245 1' 1,159,256 41 42 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 ENCUMBR Fees 000 - 455900 Capital Recovery - Water 904,200 151,636.40 - 406,999.53 944,231.74 - 000- 455910 Capital Recovery - Waste Wtr 272,800 186,324.07 - 192,608.19 643,611.12 - 000- 455911 Capital Recovery-Wste Wtr Zone 1 13,640 - - - - - 000- 455913 Cap Recovery-North Sewer Tr - - - 450.00 600.00 - TOTAL Fees', 1,190,640 337,960.47', - 600,057.72 1,588,442.86 - Fund Transfers 000 - 481000 Transfer from Reserves - - - - - - 000- 486100 Transfer In - - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000 - 491000 Interest Earned 2,000 57.27 - 1,092.32 331.60 - 000- 491200 Investment Income 250,000 3,412.95 - 3,088.81 22,229.36 - 000- 491900 Unrealized Gain /Loss -Cap One - 2,140.09 - - (16,877.28) - 000- 498100 Reimbursmnt - FM 78 Project 50,000 4,166.66 - 24,999.97 29,166.66 - 000- 498200 Re- imbursement -Water Meters 283,500 23,625.00 - 70,875.00 165,375.00 - TOTAL Miscellaneous 585,500 331,401.97' - 100,056.10 200,225.34 - TOTAL REVENUES,' 1,776,140 371 „362.44' - 700,113,.82 1,788,668.20 - 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 654,351.47 Cash in Investments: Lone Star Investment - Capital Recovery 561,663.48 Capital One - Investment 1,700,573.32 Schertz Bank & Trust - Certificate of Deposit 524,177.12 Total Cash in Bank & Investment Pools $3,440,765.39 43 505 -TAX I &S FINANCIAL SUMMARY REVENUE SUMMARY Taxes Fund Transfers Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services Debt Service TOTAL GENERAL (GOVERNMENT TOTAL EXPENDITURES' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 E 3,368,794 27,827.76 - 3,296,541.97 3,357,175.53 - 243,000 - - - - 3,000 132.99 - 2,142.19 15,177.27 3,614,794 27,960.75 - 3,29,8,684.16 3,372,352.80 - 3,200 - - 1,350.00 350.00 - 3,611,124 - - 2,445,857.55 2,558,340.59 - 1, 3,614,324 - - 2,447,207.55 2,,558,690.59 - 1,, 3,614,324 - - 2,447,207.55 2,558,690.59 - 11 "" REVENUE OVER(UNDER) EXPEND 470 44 813, 662.21 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: APRIL 30th, 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 27,827.76 - 3,296,541.97 3,357,175.53 3,368,794 27,827.76 - 3,296,541.97 3,357,175.53 243,000 - - - - 243,000 - - - - 1,500 2.40 - 1,137.33 14,411.81 1,500 130.59 - 1,004.86 765.46 3,000 132.99 - 2,142.19 15,177,27 3,614,794 27,960.75 - 3,298,684.16' 3,372,352.80 45 505 -TAX I & S GENERAL GOVERNMENT NON DEPARTMENTAL Professional Services 101 - 541500 Paying Agent TOTAL Professional Services Debt Service 101 - 555612 Schertz C O SR2001- Principal 101 - 555612.1 Schertz CO BOND, 2001 - Interest 101 - 555622 Schertz C O SR2003- Principal 101 - 555622.1 Schertz C O SR2003- Interest 101 - 555624 Comm Proj Bond -SR04- Principal 101 - 555624.1 Comm Proj Bond SR04- Interest 101 - 555626 LS &D SR2006- Principal 101 - 555626.1 LS &D SR2006- Interest 101 - 555628 CO Bond 2007 - Principal 101 - 555628.1 CO Bond 2007 - Interest 101 - 555629 GO Bond 2007 - Principal 101 - 555629.1 GO Bond 2007 - Interest 101 - 555630 GO Bond SR2008 Principal 101 - 555630.1 GO Bond SR2008 Interest 101 - 555631 GO Bond SR2009 Principal 101 - 555631.1 BO Bond SR2009 Interest TOTAL Debt Service TOTAL EXPENDITURES CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 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 3,200 3,200 210,000 141,318 190,000 60,820 325,000 265,009 650,982 99,567 26,617 275,000 209,097 355,000 379,651 140,000 283,063 3,611,124 3,614,324' 1,350.00 350.00 1,350.00 350.00 200,000.00 285,000.00 77,090.00 37,977.08 180, 000.00 190, 000.00 35,360.00 32,120.00 325,000.00 325,000.00 143,168.14 136,058.76 100,000.00 - 327,490.64 325,490.64 - 13,451.11 250,000.00 382,346.25 127, 331.56 - 235,000.00 355,000.00 198, 343.25 193, 490.50 80,000.00 140,000.00 167, 073.96 142, 406.25 2,445,857.55 2,558,340.59 - 2,447,207.55 2,558,690.59' 46 TAX I &S CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 17,118.00 Cash in Investment Pools MBIA Investment- Tax I &S 49,003.69 Federated Investment -Tax I &S 1,033,754.82 Total Cash in Bank & Investment' Pools $1,099,876.51 47 620 -SED CORPORATION FINANCIAL SUMMARY REVENUE SUMMARY Taxes Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies Utility Service Maintenance Services Operating Equipment Capital Outlay TOTAL NOINDEPARTMENTAL' 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: APRIL 30th, 2011 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BI BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR B� 2,035,795 141,650.18 - 809,015.63 1,229,315.75 - 8 108,000 103.35 - 25,770.47 5,310.75 - 1 2,143,795 141,753.53 - 834,786.10 1,234,626.50 - 9 23,000 2,416.80 623.28 8,770.02 14,421.53 728.75 85,800 2,421.88 - 39,556.93 30,431.91 - 65,300 3,196.77 5,965.50 29,558.31 37,685.15 1,229.06 8,498 - - 18,494.00 6,999.31 - - - 6,999.31 - - - 182,598 8,035.45 13,588.09 96,379.26 89,537.90 1,957.81 1' 202,062 21,719.92 - 157,951.60 87,987.66 - 1 1,000 19.99 - 405.70 560.22 - 100 - - - - 54.00 34,500 3,365.12 623.92 32,235.36 12,924.69 497.95 4,850 304.02 - 1,940.85 1,906.78 - 76,100 2,187.58 3,242.89 39,989.27 40,678.27 730.56 97,000 1,271.40 1,782.11 87,998.07 63,623.44 1,390.26 80,000 - - - - - 349,000 - 21,340.80 113,382.90 143,782.52 9,707.49 2 105,432 4,619.33 - 77,750.00 82,335.33 - 216,000 - - - - - 2 - - - 781.89 - - 792,432 - - 355,322.21 606,911.25 - 1 1,500 - - 229,231.18 - 83.27 1,959,976 33,487.36 26,989.72 1,096,989.03 1,040,710.16 12,463.53 9 TOTAL EXPENDITURES '' 2,142,574 41,522.81 40,577.81 1,193,368.29'' 1,130,248.06 14,421.34 1,0 "" REVENUE OVER(UNDER) EXPEND 1221'' 104,378.44'' 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: APRIL 30th, 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 141,650.18 2,035,795 141,650.18'' 1,000 28.96 12,000 74.39 15,000 - 80,000 - 108,000 103.35,', 809,015.63 1,229,315.75 809,015.63 1,229,315.75 - 323.59 92.12 - 15,918.57 4,864.83 - 9,528.31 353.80 25,770.47 5,310.75', TOTAL REVENUES'' 2,143,795 141,753.53 - 834,786.10 1,234,626.50 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool- Checking $ 174,898.96 Cash in Investment Pools MBIA Investment - Economic Development Corp 515,242.40 MBIA- Investment -Sysco Infrastructure - MBIA- Investment -EDC Notes 2010 153,535.90 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,376,476.06 50 4B SALES TAX $300,000 $250,000 _1 $200,000 14% -2% 240% 11 o 3% $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 141,650 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 - 4,-v � A ti�Z MItf*,t p MIT, w 19%OL .0 M dUSOk ZNT . . . . . . . . . . . .......... 41 . . . . . . . . . . . . . . . . . . . . T -cttma ;F�,, ■ sp IIW .�yam rl� T";l. AMOK L 11 1+ 1 i n • TO ■ ■ ■ x i m 1 1 Ir hiz i_ i., 1 L ■ ! �� i • .. 10 w'� err +tii • � �- � -�i � �� ► Lim f F . ur A, 6: r; W-MMM"our =r- U ` . � --m—jndmb6 snow —1� Noll �-- ..