Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01-OCTOBER 2010 STATEMENT1
OCTOBER 2010 Financial Report CITY OF S CHERTZ Prepared By: The Finance Department JANUARY 18, 2011 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME REVENUE SUMMARY Taxes 10,912,656 1,761,712.44 - 960,042.40 1,761,712.44 - Franchises 1,521,000 408.45 - 100,355.83 408.45 - Permits 1,181,913 452,957.83 - 68,348.49 452,957.83 - Licenses 64,547 1,640.10 - 1,695.00 1,640.00 - Fees 3,073,872 399,748.87 - 171,717.61 399,748.87 - Fines 35,000 1,960.33 - 2,357.79 1,960.33 - Inter- Jurisdictional 405,672 54,582.27 - 141,051.06 54,582.27 - Fund Transfers 1,184,474 - - 4,133.27 - - Miscellaneous 507,284 53,465.43 - 30,304.23 53,465.43 - TOTAL REVENUES 18,886,418 2,726,475.72 - 1,480,005168 2,726,475.62 - EXPENDITURE SUMMARY A III WKK0111► Is] I Personnel Services 22,800 1,771.04 - 374.77 1,771.04 - Supplies 500 - - 33.26 - 22. City Support Services 20,500 - - 160.00 - 60. Operations Support 300 - - 74.00 - - Staff Support 16,400 380.00 380.00 870.48 380.00 80. Opertating Equipment - - - - - - TOTAL CITY COUNCIL 60,500 2,151.04 380.00 1,512151 2,151.04 162. CITY MANAGER Personnel Services 718,457 45,455.91 - 42,129.55 45,455.91 - Supplies 2,400 - - 79.99 - 118. City Support Services - - - - - - Operations Support - - - - - - Staff Support 25,550 60.00 60.00 761.17 60.00 4,404. Operating Equipment - - - - - 133. TOTAL CITY MANAGER 746,407.00 45,515.91 60.00 42,970.71 45,515.91 4,656. 1 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME MUNICIPAL COURT Personnel Services 250,203 15,761.10 - 12,391.49 15,761.10 - Supplies 3,200 387.05 - - 387.05 47.1 City Support Services 1,000 - - - - - Operations Support 3,000 - - - - - Staff Support 4,200 33.44 33.44 787.00 33.44 76.1 Court Support 800 - - - - - Professional Services 88,100 3,228.75 - 3,937.50 3,228.75 27,580. Maintenance Services 1,000 - - - - - Operating Equipment 2,000 250.00 - 141.98 250.00 - TOTAL MUNICIPAL COURT'' 353,503' 19,660.34 33.44 17,257!.97 19,660.34 27,704!.!: CUSTOMER RELATIONS -311 Personnel Services 88,928 5,267.39 - 12,844.27 5,267.39 - Supplies 500 - - - - Staff Support 1,105 - - - - - TOTAL CUSTOMER', RELATIONS -311 90,533', 5,267.39 - 12,844.27 5,267.39 - PLANNING &ZONING Personnel Services 134,105 8,315.44 - 8,195.30 8,315.44 - Supplies 4,500 - - 17.90 - - Operations Support 2,300 - - - - - Staff Support 22,100 26.94 - 2,403.27 26.94 563. Professional Services 142,300 - - - - - Operating Equipment 600 - - 217.65 - - TOTAL PLANNING &' ZONING 305,905' 8,342.38 - 10,834!.12 8,342.38 563!. LEGAL SERVICES Operations Support 13,000 - - - - - Professional Services 245,000 - - - - - TOTAL LEGAL SERVICES '' 258,000' - - - - - z 101 GENERAL FUND FINANCIAL SUMMARY FACILITIES MAINTENANCE Personnel Services Supplies Utility Services Staff Support Maintenance Services Rental /Leasing Operating Equipment Capital Outlay TOTAL FACILITIES MAINTENANCE CITY SECRETARY Personnel Services Supplies City Support Services Staff Support TOTAL CITY SECRETARY NON - DEPARTMENTAL Supplies City Support Services Operations Support City Assistance Professional Services Fund Chrgs /Transfrs -Spec Events Fnd Operating Equipment Capital Outlay TOTAL NON'- DEPARTMENTAL PUBLIC AFFAIRS Personnel Services Supplies Operations Support Staff Support CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME 630,024 38,096.83 - 41,553.24 38,096.83 - 59,900 1,325.73 638.43 3,218.08 1,325.73 8,308. 93,600 5,000.87 - 2,048.33 5,000.87 - 7,712 1,424.40 403.00 401.04 1,424.40 452.. 111,950 37,262.76 6,121.04 14,793.90 37,262.76 2,965.1 2,000 - - - - - 24,500 - - - - - 929,686 83,110.59 7,162.47 62,014.59 83,110.59 11,726.'; 167,842 10,594.72 - 10,451.33 10,594.72 - 1,550 22.60 - - 22.60 - 9,780 - - 75.00 - - 5,700 590.44 295.00 570.00 590.44 136. 184,872' 1,1,207.76 295.00 11,096.33 11,207.76 136,. 3,000 - - 611.98 - - 369,000 59,848.47 - 166,250.98 59,848.47 10,868. 114,000 6,886.67 - 9,105.13 6,886.67 17.1 387,459 96,864.87 - 96,864.87 96,864.87 - 106,350 2,688.78 - 2,607.06 2,688.78 - 24,350 - - 49,100.00 - - 500 - - - - - 7,000 - - 4,133.27 - - 1,011,659' 166,288.79 - 328,673.29 166,288.79 10,885,.? 131,096 10,676.57 - 11,697.58 10,676.57 - 2,450 - - - - 45. 47,500 79.86 - 10,458.15 79.86 1,944. 3,750 105.08 - 168.32 105.08 - 3 101 GENERAL FUND FINANCIAL SUMMARY Professional Services Operating Equipment TOTAL PUBLIC AFFAIRS RECORDS MANAGEMENT Personnel Services Supplies Utility Services Staff Support Professional Services 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 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME - - - 13,925.29 - - 6,000 - - - - - 190,796 10,861.51 - 36,249.34 10,861.51 1,989) 46,317 2,936.99 - 2,166.60 2,936.99 900 - - - - - 85.00 - - 85.00 1,500 - - - - 15,000 286.00 - - 286.00 63,717' 3,307.99 - 2,166;60 3,307.99 126,426 6,995.53 1,000 - 252,500 2,865.44 379,926, 9,860.97, 6,995.53 - 2,865.44 117,814. 9,860.97 117,814. 169,469 10,215.99 - 10,360.44 10,215.99 300 - - - - 2,213 265.00 - 260.00 265.00 24,000 - - - - 4,044 2,145.29 - - 2,145.29 200,026' 12,626.28 - 10,620;44 12,626.28' 117,358 7,453.95 - 7,634.40 7,453.95 3,300 - - - - 1,050 - - - 2,000 - - - - 123,708' 7,453.95 - 7,634.40 7,453.95 4,899,238' 385,654.90 7,930.91 543,874.57 385,654.90 175,639. a 101 GENERAL FUND FINANCIAL SUMMARY PUBLIC SAFETY POLICE Personnel Services Supplies City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Maintenance Services Operating Equipment Capital Outlay TOTAL POLICE CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME 4,083,030 253,864.84 - 324,880.74 50,558 100.48 2,410,836 27.00 791.22 30,000 147,463.39 - - 26,534.00 100,000 6,788.53 20.15 - - 2,000 - - - 21.50 31,350 - - - 791.72 13,000 100.00 7,198.55 - 720.00 8,000 City Assistance - - - 76,949 1,958.50 Professional Services 179.50 10, 732.00 63,996 5,196.00 - 5,196.00 - 169,998 - - - 91,420.00 4,628,881 268,008.35 604.50 5,402.50 455,891;18 253, 864.84 - 100.48 1,464. 6,788.53 - - 386. 100.00 549. 1,958.50 5,540. 5,196.00 14,467. - 126,312. 268,008.35 148,719. FIRE RESCUE Personnel Services 2,410,836 147,463.39 - 167,940.97 147,463.39 Supplies 20,200 20.15 20.15 719.34 20.15 Utility Services 43,900 2,345.27 - 1,559.41 2,345.27 Operations Support 1,100 - - - - Staff Support 116,800 7,198.55 1,193.00 3,568.78 7,198.55 City Assistance 18,600 10,323.17 10,323.17 2,715.75 10,323.17 Professional Services 18,140 - - - - Maintenance Services 55,000 - - - - Operating Equipment 44,400 718.93 604.50 - 718.93 TOTAL FIRE'' 2,728,976' 168,069.46 12, 140.82 176,504!.25 168,069.46' INSPECTIONS Personnel Services 364,194 22,910.47 - 22,198.33 22,910.47 Supplies 6,750 - - - - Utility Services 7,600 671.94 - - 671.94 Operations Support 3,200 - - - - Staff Support 14,700 521.89 388.20 383.00 521.89 Professional Services 10,000 - - - - Maintenance Services - - - - - Operating Equipment - - - - - TOTAL INSPECTIONS 406,444', 24,104.30 388.20 22,581.33 24,104.30', 5 150. 1,304. 674. 2,129!. 610. PUBLIC ENVIRONMENT '. 311 V44K Personnel Services 604,591 CITY OF SCHERTZ - 61,419.89 34,425.64 REVENUE AND EXPENSE REPORT (UNAUDITED) Supplies 6,300 66.77 28.15 AS OF: OCTOBER 31st, 2010 1,356. Utility Services 101,900 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME 84.08 84.08 453.37 84.08 439. Maintenance Services MARSHAL SERVICE 15,833.63 13,435.12 4,649.72 15,833.63 7,924. Personnel Services 522,242 23,287.69 - 26,401.73 23,287.69 - Supplies 6,450 - - 20.34 - - Utility Services 9,000 487.92 - - 487.92 - Operations Support 4,000 - - - - - Staff Support 9,400 439.57 - 1,249.41 439.57 - Professional Services - - - - - - Maintenance Services 12,400 112.00 - 116.00 112.00 - Operating Equipment 21,480 2,324.04 - - 2,324.04 143. Capital Outlay 65,600 - - - - 40,406. TOTAL MARSHAL SERVICE 650,572' 26,651.22 - 27,787!.48 26,651.22 40,549''. TOTAL PUBLIC SAFETY 8,414,873' 486,833 17,931.52 682,764.24 486,833.33 192,068. PUBLIC ENVIRONMENT '. 311 V44K Personnel Services 604,591 34,425.64 - 61,419.89 34,425.64 - Supplies 6,300 66.77 28.15 313.02 66.77 1,356. Utility Services 101,900 8,523.27 - 385.09 8,523.27 313. Operations Support 1,380 - - - - - Staff Support 9,265 84.08 84.08 453.37 84.08 439. Maintenance Services 155,400 15,833.63 13,435.12 4,649.72 15,833.63 7,924. Rental /Lease 200 - - - - - Operating Equipment 4,200 - - - - Capital Outlay 14,500 - - - - - TOTAL STREETS 897,736' 58,933.39 13,547.35 67,221109 58,933.39 10,033.. TOTAL PUBLIC ENVIRONMENT 897,736' 58,933.39 13,547.35 6 67,221!09 58,933.39 10,033;. 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME PARKS & RECREATION PARKS DEPARTMENT Personnel Services 489,640 28,167.95 - 33,113.66 28,167.95 - Supplies 40,555 3,499.64 - 6,174.44 3,499.64 1,925. City Support Services - - - - - - Utility Services 110,000 5,722.87 - 2,219.05 5,722.87 265.. Operations Support 700 600.00 600.00 - 600.00 - Staff Support 7,686 1,038.50 202.35 764.08 1,038.50 184. Professional Services 35,000 - - - - 8,045. Maintenance Services 21,000 - - 6,727.19 - 58. Rental /Leasing 30,531 3,360.96 3,491.50 - 3,360.96 1,900. Operating Equipment - - - 5,974.00 - - CapitalOutlay 7,000 - - - - - TOTAL PARKS DEPARTMENT 742,112 42,389.92 4,293.85 54,972.42 42,389.92 12,379. SWIM POOL Supplies 16,700 53.39 53.39 (839.99) 53.39 144. Utility Services 25,500 882.37 - 1,110.89 882.37 - Staff Support 925 - - - - - Maintenance Services 199,378 - - 1,918.41 - - Rental /Lease 500 - - - - - TOTAL SWIM POOL 243,003 935.76 53.39 2,189.31 935.76 144. COMMUNITY /CIVIC CENTER Personnel Services 115,041 5,130.86 - 6,871.46 5,130.86 - Supplies 6,423 1,293.27 - 1,047.36 1,293.27 114. Utility Services 47,150 2,423.57 - 487.55 2,423.57 - Operations Support 15,282 95.00 - 1,000.00 95.00 - Staff Support 3,250 - - - - - Operating Equipment 7,172 - - 5,654.16 - - TOTAL COMMUNITY /CIVIC,CNTR '' 194,318' 8,942.70 - 15,060'.53 8,942.70 114'. 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: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME 1,179,433 52,268.38 4,347.24 72,222.26 52,268.38 12,639.: 667,832 41,633.87 - 33,755.23 41,633.87 16,400 - - 269.93 - 39,500 2,773.82 - 100.19 2,773.82 2,500 - - - - 4,185 18.92 - 63.44 18.92 2,100 - - 200.68 - 3,500 - - 2,400.00 - 65,000 272.36 47.36 26.59 272.36 801,017' 44,698.97 47.36 36,816.06 44,698.97 31 801,017' 44,698.97 47.36 36,816,.06 44,698.97 175,. 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: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME 302,083 19,775.25 - 22,132.88 14,521.03 19,775.25 - 24,900 42.00 42.00 864.06 37. 42.00 1,049. 9,900 517.24 - 1.94 147,131 517.24 - 800 - - - - - 5,800 - - 751.99 3,456.30 - 150. 13,000 - - - - - 14,500 - - 322.50 - - 240. 6,100 - - - - - 9,000 - - 17.90 - - 4,000 - - - - - 390,083 20,334.49 42.00 24,091.27 20,334.49 1,439,. 390,083' 20,334.49 42.00 24,091.27 20,334.49 1,439,.'; 263,447 14,521.03 - 14,380.75 14,521.03 - 1,500 - - - - 37. 323,602 22,287.17 - 22,743.17 22,287.17 6,759. 147,131 4,917.20 - 15,035.62 4,917.20 - 10,400 1,959.20 1,813.95 997.42 1,959.20 597. 21,100 4,054.75 - 3,456.30 4,054.75 165. 135,836 129.00 - 2,464.00 129.00 17,219.1 45,809 - - - - - 948,825' 47,868.35 1,813.95 59,077;26 47,868.35 24,778;' 9 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME HUMAN RESOURCES Personnel Services 218,821 11,282.60 - 14,723.93 11,282.60 - Supplies 1,700 - - - - - Human Services 46,122 1,230.12 - 6,452.10 1,230.12 - Operations Support 12,545 266.28 266.28 2,396.70 266.28 1,065. Staff Support 11,982 3,473.00 - - 3,473.00 1,589.1 City Assistance 9,425 - - 2,221.00 - - Operating Equipment 2,500 - - - - - TOTAL HUMAN RESOURCES 303,095 16,252.00 266.28 25,793.73 16,252.00 2,654) FINANCE Personnel Services 419,818 26,420.88 - 28,409.66 26,420.88 - Supplies 3,600 857.41 - 211.33 857.41 204. Operations Support 1,050 0.01 - 155.80 0.01 - Staff Support 13,370 - - - - 575. Operating Equipment 1,000 - - - - - TOTAL FINANCE 438,838' 27,278.30 - 28,776.79 27,278.30 779,.'; PURCHASING & ASSET MGT Personnel Services 234,220 14,827.64 - 18,585.31 14,827.64 - Supplies 2,300 - - 11.29 - - Utility Services 1,200 - - - - - Operations Support 150 - - - - - Staff Support 6,900 - - 27.69 - - Operating Equipment 150 - - - - - TOTAL PURCHASING &ASSET MGT 244,920' 14,827.64 - 18,624!.29 14,827.64 - 10 TOTAL EXPENDITURES' REVENUE OVER(UNDER) EXPEND. 18,882,876 1,181, 522.83 5!1, 045.83 1,577,656.67 1,181, 522.83 466, 356.' 3,542 1,544,952.79 m CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUME FLEET SERVICE Personnel Services 148,533 9,180.12 - 11,150.66 9,180.12 - Supplies 101,000 4,808.97 4,644.98 5,219.18 4,808.97 8,346.: City Support Services 1,500 - - - - - Utility Services 7,000 223.91 - - 223.91 - Operations Support 400 - - - - - Staff Support 2,435 295.80 - 75.69 295.80 124.: Professional Services - - - 1,904.58 - - Maintenance Services 45,750 1,564.28 474.24 45.00 1,564.28 1,177.: Rental /Lease 200 - - - - - Operating Equipment 6,000 - - - - - TOTAL FLEET SERVICE 312,818 16,073.08 5,119.22 18,395.11 16,073.08 9,648. TOTAL INTERNAL SERVICE 2,248,496' 122,299.37 7,199.45 150, 667!.18 122,299.37 37,861!..1 MISC & PROJECTS CITY ASSISTANCE Utility Services - - - - - Patient Assistance 5,000 - - - - 5,000.1 Children's Advocacy Assistance 5,000 - - - - - Library Capital Campaign - - - - - - Senior Citizen's Hot Meals 42,000 10,500.00 - - 10,500.00 31,500.1 TOTAL CITY' ASSISTANCE '' 52,000 10,500.00 - - 10,500.00 36,500.1 TOTAL MISC & PROJECTS 52,000', 10,500.00 - - 10,500.00 36,500,.1 TOTAL EXPENDITURES' REVENUE OVER(UNDER) EXPEND. 18,882,876 1,181, 522.83 5!1, 045.83 1,577,656.67 1,181, 522.83 466, 356.' 3,542 1,544,952.79 m CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31th, 2010 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -E REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUM Taxes 000 - 411100 Advalorem Tax - Current 6,704,566 1,406,160.47 - 1,277,006.27 1,406,160.47 000 - 411200 Advalorem Tax - Delinquent 50,000 3,700.12 - 7,457.51 3,700.12 000 - 411300 Advalorem Tax - P &I 50,000 966.83 - 1,684.87 966.83 000 - 411500 Sales Tax Revenue -Gen Fund 4,071,590 342,083.11 - (334,210.51) 342,083.11 000 - 411600 Bingo Tax 4,500 - - - - 000- 411700 Mixed Beverage Tax 32,000.00 8,801.91 - 8,104.26 8,801.91 TOTAL Taxes 10,912,656 1,761,712.44 - 960,042.40 1,761,712.44', Franchises 000 - 421200 Center Point /Entex Energy 33,000 - - - - 000- 421220 City Public Service 275,000 - - - - 000- 421240 Guadalupe Valley Elec Co -op 430,000 - - - - 000- 421250 New Braunfels Utilities 30,000 - - - - 000- 421300 Time Warner -State Franchise 350,000 - - 75,489.04 - 000- 421350 Time Warner -PEG Fee 62,000 - - 15,960.54 - 000- 421460 AT &T Franchise Fee 220,000 305.37 - 228.18 305.37 000 - 421465 AT &T PEG Fees 16,000 - - - 000- 421480 Other Telecom Franchise 15,000 103.08 - 737.83 103.08 000 - 421500 Solid Waste Franchise Fee 90,000 - - 7,940.24 - TOTAL Franchises 1,5211,000 408.45 - 100,355.83 408.45' Permits 000 - 431100 Home Occupation Permit 770 - - - - 000- 431200 Building Permit 837,952 418,616.83 - 36,602.19 418,616.83 000 - 431300 Mobile Home Permit 671 - - - - 000- 431400 Signs Permit 8,596 50.00 - - 50.00 000 - 431500 Food Establishmnt Permit 15,000 7,445.00 - 8,925.00 7,445.00 000 - 431600 Garage Sale Permit 9,554 1,490.00 - 1,115.30 1,490.00 000 - 431700 Plumbing Permit 109,769 7,436.00 - 7,381.00 7,436.00 000 - 431750 Electrical Permit 63,062 5,620.00 - 4,807.00 5,620.00 000 - 431800 Mechanical Permit 84,211 6,380.00 - 5,998.00 6,380.00 000 - 431900 Solicitor /Peddler Permit - - - 30.00 - 000- 431950 Animal /Pet Permit 2,000 625.00 - 360.00 625.00 12 101 GENERAL FUND REVENUES 000 - 432000 Cert. of Occupancy Prmt 000 - 432100 Security Alarm Permit 000 - 435000 Fire Permit TOTAL Permits Licenses 000 - 441000 Alcohol Beverage License 000 - 442000 Contractors License 000 - 444000 Pet License TOTAL Licenses Fees CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31th, 2010 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL 6,578 800.00 36,000 3,370.00 7,750 1,125.00 1,181,913 452,957.83, 6,100 30.00 55,447 1,150.00 3,000 460.10 64,547 1,640.10 250.00 800.00 2,355.00 3,370.00 525.00 1,125.00 68,348.49 452,957.83, - 60.00 30.00 - 1,028.00 1,150.00 - 607.00 460.00 - 1,695.00 1,640.00', 000 - 451000 Municipal Court Fines 1,540,000 104,765.10 - 94,539.50 104,765.10 000 - 451100 Arrest Fee 60,000 4,189.16 - 4,271.83 4,189.16 000 - 451110 Expunction Fee 90 - - - - 000- 451200 Warrant Fees 187,500 7,887.90 - 12,003.00 7,887.90 000 - 451320 Civil Justice Fee -Court 500 6.84 - 6.84 000 - 451340 Judicial Fee - City 7,000 546.23 - 563.32 546.23 000 - 451400 Traffic Fine Costs TTL 30,000 2,191.68 - 2,201.05 2,191.68 000 - 451500 Teen Court Admin Fee 500 60.00 - 140.00 60.00 000 - 451510 Juvenile Case Mgmt Fee 60,000 4,551.99 - 4,694.54 4,551.99 000 - 451600 Technology Fund Fee 55,000 3,621.27 - 3,897.11 3,621.27 000 - 451700 Security Fee 40,000 2,715.93 - 2,922.89 2,715.93 000 - 451800 Time Payment Fee - City 5,000 360.14 - 358.44 360.14 000 - 451850 State Fines 10% Service Fee 70,000 19,298.66 - - 19,298.66 000 - 451900 DPS Payment - Local 12,250 664.93 - 943.20 664.93 000 - 452000 Child Safety Fee 8,000 1,201.10 - 677.10 1,201.10 000 - 452050 Indigent Defense Fee 22,500 1,768.77 - 1,805.89 1,768.77 000 - 452100 Platting Fees 66,000 3,000.00 - 3,000.00 3,000.00 000 - 452200 Site Plan Fee 26,400 2,000.00 - 1,500.00 2,000.00 000 - 452300 Plan Check Fee 375,000 209,342.41 - 16,523.50 209,342.41 000 - 452320 Tree Mitigation Admin Fee 11,220 - - - - 000- 452400 BOA/Zoning Fees 11,000 700.00 - - 700.00 000 - 452500 Food Handler Class 8,000 430.00 - 330.00 430.00 000 - 452520 Fire Training Classes - - - - - 000- 452600 Specific Use /Zone Chng Fee 14,630 - - - - 000- 452610 Plat Recording Fee - - - - - 000- 452710 Zoning Ltr & Dev Rights - 75.00 - 150.00 75.00 13 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31th, 2010 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 - 453100 Reinspection Fees 49,000 4,325.00 - 2,975.00 4,325.00 000 - 453110 Swim Pool Inspection Fee - - - - - 000- 453120 Inspections Plan Review - - - - - 000- 453200 Mowing Fees - Inspections - 805.88 - 434.61 805.88 000 - 453211 Admin Fee - Inspections - 800.00 - - 800.00 000 - 453215 3% Technology Fee - - - 469.15 - 000- 453310 Misc Inspection Fee - (20.00) - 10.00 (20.00) 000 - 453500 SubContractor Reg. Fee - 810.00 - 1,345.00 810.00 000 - 453710 Foster Care - 150.00 - - 150.00 000 - 454100 Swim Pool Reservation Fee - - - - 000- 454200 Pool Gate Admission Fee 22,000 - - - - 000- 454300 Seasonal Pool Pass Fee 5,500 - - - - 000- 456500 Haz Mat Fees 2,500 - - - - 000- 456510 Fire Plan Review 800 - - - - 000- 456600 Fire Re- inspection Fee 450 200.00 - - 200.00 000 - 458300 Sale of Property /Auction 20,000 (29.58) - 964.98 (29.58) 000 - 458400 Civic Center Rental Fees 226,000 13,565.16 - 9,765.00 13,565.16 000 - 458401 Capital Recovery Fee -Civic Cntr - 400.00 - - 400.00 000 - 458450 North Center Rental Fees 24,000 1,061.00 - - 1,061.00 000 - 458500 Community Center Rental Fees 32,000 1,263.00 - 2,420.00 1,263.00 000 - 458550 Pavilion Rental Fees - 2,763.30 - - 2,763.30 000 - 458570 Non - Resident SYSA League 18,000 - - - - 000- 458600 Ball Field Use - - - - - 000- 458650 NonResident User Fee -BVYA 9,000 - - - - 000- 458680 Tournament Fees - Soccer 14,000 - - - - 000- 458700 Vehicle Impoundment 5,000 - - - - 000- 459200 NSF Check Fee 100 158.00 - 10.00 158.00 000 - 459300 Notary Fee 200 24.00 - 36.00 24.00 000 - 459400 Maps, Copies, UDC, & Misc F 200 - - 5.00 - 000- 459600 Animal Adoption Fee 10,500 1,360.00 - 747.50 1,360.00 000 - 459700 Pet Impoundment Fee 17,500 2,232.00 - 1,558.00 2,232.00 000 - 459800 Police Reports Fee 6,532 504.00 - 456.00 504.00 TOTAL Fees 3,073,872 399,748.87 '' - 171,717.61 399,748.87'' Fines 000 - 463000 Library Fines 35,000 1,960.33 - 2,357.79 1,960.33 TOTAL Fines 35,000 1,960.33 '' - 2,357:79 1,960.33'' 14 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31th, 2010 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,078 1,756.48 - 1,756.48 1,756.48 000 - 473200 City of Seguin - Fire Contract 40,293 3,355.26 - 3,355.26 3,355.26 000 - 473300 Guad Co - Library 180,816 15,068.00 - - 15,068.00 000 - 473400 Randolph AFB - Animal Cntrl 2,500 500.00 - - 500.00 000 - 474200 Library Services - Cibolo - - - - - 000- 474210 Library Services -Selma 19,000 - - - - 000- 474250 Non - Resident Library Fees - - - - - 000- 474400 Dispatch Service - Cibolo 133,305 33,326.25 - 133,305.00 33,326.25 000 - 474500 Dispatch Service - SCUCISD 2,080 - - 2,080.00 - 000- 474600 School Crossing Guard - Bexar 6,600 576.28 - 554.32 576.28 TOTAL Inter- Jurisdictional 405,672 54,582.27 '' - 141,051:06 54,582.27' Fund Transfers 000 - 480000 Indirect Costs - EMS 87,840 - - - - 000- 480100 Indirect Costs - Hotel /Motel 170,221 - - - - 000- 482100 Transfer From Reserves -Ct Tech - - - - 000- 482150 Transfer From Court Security 58,011 - - 000- 485000 Interfund Charge- Drainage 38,888 - - - - 000- 486000 Interfund Chrges -Admin W &S 624,777 - - - - 000- 486202 Transfer In -W &S - - - - - 000- 486314 Transfer in -Hotel /Motel - - - - - 000- 486317 Transfer From Park Fund - - - 4,133.27 - 000- 486322 Transfer -In - Library Grants 10,000 - - 000- 487000 Interfund Charges -Fleet 91,737 - - - - 000- 488000 Interfund Charges -413 53,000 - - - - 000- 490020 Transfer In -SEDC 50,000 - - - - TOTAL Fund Transfers,', 1,184,474 - - 4,133.27 - Miscellaneous 000 - 491000 Interest Earned 5,000 333.78 - 204.33 333.78 000 - 491200 Investment Income 26,000 2,003.25 - 2,419.64 2,003.25 000 - 491900 Unrealized Gain /Loss - 2,048.29 - 123.75 2,048.29 000 - 493120 Donations - Public Library - - - - - 000- 493130 Donations - Writing the Next Chap. 20,000 13,011.00 - 5,247.90 13,011.00 000 - 493400 Donation - Animal Control 3,670 900.00 - 255.44 900.00 000 - 493401 Donations -A/C Microchip 3,000 270.00 - 280.00 270.00 000 - 493402 Donations - Spay &Neuter 12,000 2,410.00 - 847.00 2,410.00 15 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31th, 2010 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 - 493403 Donations - Melvin Boeck A. S. - - - - - 000- 494481 LawEnforcemtOfficersStnd &Ed 3,800 - - - - 000- 495015 Contribution from SED - - - - - 000- 497000 Misc Income -Gen Fund 40,000 2,592.99 - 2,372.63 2,592.99 000 - 497005 Misc Income - Publications 240,000 12,021.00 - 11,458.00 12,021.00 000 - 497007 Misc Income - Schertz Artz - - - - - 000- 497020 Misc Income -Fleet Recycled 400 - - 250.80 - 000- 497100 Misc Income - Police 20,000 1,439.05 - 1,018.04 1,439.05 000 - 497200 Misc Income - Library 12,131 221.10 - 879.16 221.10 000 - 497210 Misc Income - Library Copier 3,400 536.75 - - 536.75 000 - 497300 Misc Income - Animal Control 2,400 137.50 - (23.50) 137.50 000 - 497400 Misc Income - Streets Dept. 11,229 2,375.00 - 1,075.00 2,375.00 000 - 497500 Misc Income -TML Insurance 78,043 - - - - 000- 497550 Misc Income -TML Reimbursemt 20,211 4,804.12 - 3,402.66 4,804.12 000 - 497600 Misc Income - Parks /Vending Mach. 500 250.53 - 493.38 250.53 000 - 497800 Misc Income -Pool Concessions - - - - - 000- 498000 Reimbursmnt -Gen Fund 5,500 33.00 - - 33.00 000 - 498110 Reimbursmnt Fire - Emg Acti -O - 8,078.07 - - 8,078.07 TOTAL Miscellaneous '' 507,284 53,465.43 '' - 30,30423 53,465.43' TOTAL REVENUES 18,886,418 2,726,475.72 '' - 1,480,005.68 2,726,475.62' 16 Y -T -E ENCUM GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,590,566.05 Cash in Investment Pools LOGIC Investment - General Fund 505,035.01 LOGIC Investment -Equip Replacement 73,174.50 LOGIC Investment -Veh Replacement 7,062.89 LOGIC Investment -Air Condi Replacment 122,142.54 CAPITAL ONE Investment - General Fund 1,329,840.75 Total Cash in Bank & Investment Pools $ 3,627,821.74' 17 ADVALOREM TAX $2,000,000 $1,500,000 $1,000,000 $500,000 $- $(500,000) OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 1,406,160 244,255 435,275 2009 -10 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792) 59,545 34,762 19,836 2008 -09 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 2007 -08 993,926 1,293,621 615,170 1,462,883 310,479 74,418 17,900 44,799 19,066 2006 -07 1,223,886 886,430 492,623 1,387,876 474,014 90,756 28,206 35,521 40,691 18 -A Sales Tax - General Fund $600,000 $500,000 $400,000 $300,000 $200,000 14% -2% 23% I i � ...... $100,000 OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 342,090 332,264 344,795 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 - 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 TOTAL CULTURAL TOTAL EXPENDITURES CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMI 85,614.00 - - 134,344.00 - 28,000.00 - - - - 2,100.00 - - - - 1,000.00 - - 30.00 - 22,300.00 78.59 - 41.92 78.59 139,014.00 78.59 - 134,415.92 78.59 5,150.00 - - - - 5,150.00 - - - - 4,750.00 - - - - 24,250.00 - - - - 5,000.00 - - - - 100.00 - - - - 30,500.00 - - - - 6,000.00 - - - - - 455.91 455.59 257.68 455.91 2,700.00 - - - - 32,000.00 1,058.00 1,058.00 534.24 1,058.00 1,000.00 - - - - 106,300.00 1,513.91 1,513.59 791.92 1,513.91', 106,300.00 1,513.91 1,513.59 '' 791.92 1,513.91 REVENUE OVER(UNDER) EXPEND '' 32,714.00'' 19 (1,435.32) SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 80,580.82 Cash in Investment Pools MBIA Special Events 66,446.65 Total Cash in Bank & Investment' Pools $,', 147,027.47 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: OCTOBER 31st, 2010 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 3,250.00 - 32,200.00 3,250.00 - 13,679,750 1,051,692.10 - 1,034,790.29 1,051,692.10 - 480,616 - - - - - 55,445 23,579.16 - 2,434.64 23,579.16 - 14,353,811 1,078,521.26 - 1,069,424.93'' 1,078,521.26 - NON DEPARTMENTAL Fund Charges /Transfers 31,000 TOTAL NON DEPARTMENTAL 31,000' BUSINESS OFFICE Personnel Services 458,640 30,807.54 - 17,790.00 30,807.54 - Supplies 6,650 - - 162.48 - 552.6E Operations Support 114,000 172.64 - 245.73 172.64 - Staff Support 7,850 490.45 - - 490.45 66.8, Professional Services 9,000 1,203.80 - 751.30 1,203.80 - Fund Charges /Transfers 40,000 - - - - - Maintenance Services 12,000 - - - - - Operating Equipment 6,800 365.62 - - 365.62 5,600.0( TOTAL BUSINESS OFFICE 654,940 33,040.05 - 18,949.51 '' 33,040.05 6,219.5( W & S ADMINISTRATION Personnel Services 1,215,503 101,902.45 - 104,521.45 101,902.45 - Supplies 193,700 2,551.51 497.93 2,886.91 2,551.51 50,360.4( Human Services 338 - - - - - City Support Services 130,000 26,818.42 - 19,311.65 26,818.42 - Utility Services 2,780,900 15,048.57 - 167,040.15 15,048.57 458.2( Operations Support 8,750 79.60 79.60 245.73 79.60 1,065.1: Staff Support 33,000 1,283.65 229.00 2,094.57 1,283.65 1,324.1! City Assistance 1,912 - - 102.00 - - Professional Services 150,094 - - 11,216.02 - 2,380.0( Fund Charges /Transfers 2,368,176 - - - - - Maintenance Services 4,838,250 312,309.99 116.41 379,240.89 312,309.99 1,794.11 Other Costs 25,000 - - - - - Debt Service 1,435,165 - - 108,004.79 - - Rental- Leasing 6,070 245.73 - - 245.73 - 21 22 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 - - (2,230.00) - Capital Outlay 58,000 22,432.00 22,432.00 - 22,432.00 55,670.01 Water Line Relocation - - - 188,791.38 - - TOTAL PUBLIC WORKS 13,257,858 482,671.92 23,3!54.94 981,225.54'' 482,671,92 113,052.0! MISC & PROJECTS PROJECTS FUND CHARGES /TRANSFERS - - - - - - TOTAL PROJECTS '' AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services 19,000 - - - - - Operations Support 500 - - - - - Professional Services 45,000 - - - - - Maintenance Services 335,500 22.35 - 90,974.77 22.35 - TOTAL AVIATION HEIGHTS WTR IMP 400,000 22.35 - 90,,974.77 22.35 - FM3009 RD &BRIDGE EXPANSION Professional Services - 19,137.50 19,137.50 - 19,137.50 - Maintenance Services - 29.03 - - 29.03 - TOTAL FM3009 RD &BRIDGE EXPANSION - 19,166.53 19,138 - 1,9,166.53 - TOTALL'MISC &'PROJECTS 400,000 19,188.88 19,137.50 90,974.77 19,188.88 - TOTAL EXPENDITURES 14,343,798 534,901 42,492 1,0,91,150 534,901 119,27, — REVENUE OVER(UNDER)EXPENSES ** 10,013 543,620.41 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 - 458300 Sale of Property /Auction 000 - 459200 NSF Check Fee -Water &Sewer TOTAL Fees Fund Transfers 000 - 486101 Transfer In- General Fund 000 - 486204 Interfnd Chrg- Drainage Bill 000 - 486411 Transfer In- Capital Recovery TOTAL Fund Transfers Miscellaneous 000 - 490000 Misc Charges 000 - 491000 Interest Earned 000 - 491200 Investment Income 000 - 493130 Library Donations 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 TOTALREVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -I BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUN 138,000 3,250.00 - 32,200.00 3,250.00 138,000 3,250.00 - 32,200.00 3,250.00' 3,300,000 257,294.17 - 255,081.01 257,294.17 18,500 18,430.00 - - 18,430.00 155,000 10,698.43 - 12,354.03 10,698.43 50,000 2,984.95 - 1,643.00 2,984.95 7,200,000 484,438.38 - 507,489.63 484,438.38 127,250 59,507.50 - - 59,507.50 5,000 - - - - 1,000 - - - - 86,000 13,163.57 - 4,858.65 13,163.57 2,560,000 191,002.23 - 236,926.51 191,002.23 175,000 14,021.58 - 16,181.46 14,021.58 2,000 151.29 - 256.00 151.29 13,679,750 1,051,692.10 1,034,790.29 1,051,692.10', 400,000 - - - - 80,616 - - - - 480,616' - - - 15,000 - - 572.03 - 500 186.00 - 66.63 186.00 5,000 (9,994.47) - 795.66 (9,994.47) - - - 0.97 - 20,000 1,037.03 - 999.35 1,037.03 - 2,291.34 2,291.34 9,945 - - - - - 24,940.96 - - 24,940.96 5,000 5,118.30 - - 5,118.30 55,445 23,579.16 - 2,434.64 23,579.16' 14,353,811' 1,078,521.26 - 1,069,424.93 1,078,521.26' 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $1,246,336.03 Cash in Investment Pools Lone Star Investment -Water &Sewer 989,164.98 Lone Star Investment -W &S Customer Deposits 293,015.97 Lone Star Investment -W &S Equip Replacement 372,243.94 Lone Star Investment -W &S Veh Replacement 542,776.14 Schertz Bank & Trust - Certificate of Deposit 1,030,000.00 $ 3,227,201.03 Total Cash in Bank & Investment Pools $ 4,473,537.06 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: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 392,715.00 - 368,980.00 392,715.00 - 1,432,345 279,689.65 - 227,100.25 279,689.65 - 334,850 23,712.43 - 17,153.48 23,712.43 - 7,203,732 696,117.08 - 613,233.73 696,117.08 - 2,391,410 195,939.01 7,838.02 327,874 7,838.02 847 - 15,000 7,005.04 - 80,438 8,001.87 8,001.87 30,000 286.00 - 75,600 1,838.25 286.00 7,753 212.67 - 137,890 19,475.25 1,838.25 3,576,092 8,316.28 - 42,320 1,656.50 248,502 - 40,000 836.33 19,475.25 82,600 - 7,056326 242,876.27 221,562.13 195,939.01 24.10 21,550.25 7,838.02 33,681.80 - 12,725.71 7,005.04 - - 1,338.42 8,001.87 - - 26.08 286.00 212.67 171.35 10,921.93 1,838.25 8,316.28 - 598.24 - - 160.00 19,503.70 19,475.25 5,767.00 - 600,306.45 - - - 2,550.77 1,656.50 - - - 836.33 - - 3,180.04 - 2,585.70 355.45 894,263.72 242,876.27 50,563.45 TOTAL EXPENDITURES 7,056326 242,876.27 355.45 894,263.72 242,876.27 50,563.45 REVENUE OVER(UNDER), EXPENSES " 147,406 453,240.81 2s 203 -EMS REVENUES Fees 000 - 456100 Ambulance /Mileage Transprt 000 - 456110 Subscription Program Fees TOTAL Fees Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 000 - 474300 Cibolo Support 000 - 475100 Comal Co ESD #6 000 - 475200 Live Oak Support 000 - 475300 Universal City Support 000 - 475400 Selma Support 000 - 475500 Schertz Support 000 - 475600 Santa Clara Support 000 - 475800 Marion Support TOTAL Inter - Jurisdictional Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Income 000 - 493203 Donations -EMS 000 - 497000 Misc Income 000 - 497100 Recovery of Bad Debt 000 - 497500 Misc Income -EMT Classes TOTAL Miscellaneous TOTAL'REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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,336,537 392,715.00 100,000 - 5,436537 392,715.00 286,126 - 219,699 53,325.00 75,369 18,293.44 152,569 37,031.25 210,545 51,103.13 64,689 17,182.50 399,083 96,864.87 10,851 2,633.67 13,414 3,255.79 1,432,345 279,689.65' - 66.75 6,000 250.00 150,000 10,137.16 100,000 1,048.52 78,850 12,210.00 334,850 23,712.43I' 7,203,732 696,117.08, - 368,980.00 392,715.00 - 26 368,980.00 392,715.00' 23,843.87 - - 53, 325.00 - 18,293.44 37,031.25 37,031.25 51,103.13 51,103.13 15,701.25 17,182.50 96,864.87 96,864.87 2,555.88 2,633.67 - 3,255.79 227,100.25 279,689.65' 27.21 66.75 6.00 250.00 12,330.27 10,137.16 - 1,048.52 4,790.00 12,210.00 17,1153.48 '' 23,712.431' 613,233.73 696,117.08, SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ (122,000.14) Cash in Investment Pools LOGIC Investment -EMS MBIA Investment -EMS Note 2010 300,259.86 Total Cash in Bank & Investment Pools $ 178,259.72' 27 204-DRAINAGE FINANCIAL SUMMARY REVENUE SUMMARY Fees Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services Supplies Human Services City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges/Transfers Maintenance Services Other costs Debt Service Rental /Leasing Operating Equipment TOTAL DRAINAGE i riTl �J�1�Ti7i rljl�� CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D I BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR E 675,300 51,114.96 - 55,476.16 51,114.96 - 6 1,300 147.35 - 99.41 147.35 - _ 676,600 51,262.31 '' - 55,575157 51,262.31 - 6 361,183 23,628.18 - 26,866.43 23,628.18 - 3 8,300 28.15 28.15 233.52 28.15 159.13 100 - - - - - 26,500 649.90 - 432.27 649.90 - 12,888 909.54 - 519.47 909.54 - 2,458 - - - - - 8,255 312.48 168.83 194.42 312.48 215.42 840 - - - - - 19,800 - - - - - 195,449 - - - - - 1 22,000 - - 67.50 - - 100 - - - - - 18,138 - - - - - 500 - - - - - 676,511' 25,528.25 196.98' 28,313.61 25,528.25 374.55 6 676,511' 25,528.25 196.98' 28,313.61 25,528.25 374.55 6 "" REVENUE OVER(UNDER) EXPEND 89' 2s 25,734.06' 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: OCTOBER 31st, 2010 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 352.24 671,800 50,762.72 675,300', 51,114.96, 100 27.35 600 66.14 600 53.86 1,300 147.35, 676,600 51,262.31' - 310.60 352.24 - 55,165.56 50,762.72 55,476,.16 51,114.96 - - 27.35 - 65.55 66.14 - 33.86 53.86 99.41 147.35 29 55,575;57 51,262.31 - 621 624 62` DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking 146,695.28 Cash in Investment Pools Lone Star Investment - Drainage Maint Fund 282,521.58 Total Cash in Bank & Investment Pools $ 429,216.86 30 314 -HOTEL TAX FINANCIAL SUMMARY REVENUE SUMMARY Taxes Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services City Support Services Operations Support Professional Services Fund Charges/Transfers Operating Equipment Capital Outlay TOTAL NON'DEPARTMENTAL' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 20,944.35 - 25,379.84 20,944.35 - 5,550 39.78 - 54.60 39.78 390,550 '' 20,984.13 - 25,434.44 20,984.13 - 31,841 - - - - - 78,228 502.85 502.85 - 502.85 - 33,424 - - - - - 2,500 - - - - - 231,485 - - 85,244.00 - - 377,478 502.85 502.85'' 85,244.00 502.85 - TOTAL EXPENDITURES 377,478 502.85 502.85'' 85,244.00 502.85 - REVENUE OVER(UNDER)',EXPENDITURE 13,072 20,481.28 31 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUI REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BAL Taxes 000 - 411800 Hotel Occupancy Tax 385,000 20,944.35 - 25,379.84 20,944.35 - 364, TOTAL Taxes 385,000 20,944.35 - 25, 379.84 20, 944.35 - 364, Miscellaneous 000 - 491000 Interest Earned 250 25.86 40.57 25.86 - 000- 491200 Investment Interest 300 13.92 - 14.03 13.92 - 000- 497000 Misc Income 5,000 - - - - - 5, TOTAL Miscellaneous 5,550 39.78 - 55 39.78 - 5, TOTAL REVENUES 390,550 20,984.13 - 25,434.44 20,984.13 - 369, 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 138,707.23 Cash in Investment Pools Federated Investment -Hotel /Motel 78,015.72 Total Cash in Bank '& Investment Pools' $'216,722.95' 33 HOTEL OCCUPANCY TAX 34 317 -PARK FINANCIAL SUMMARY REVENUE SUMMARY Parkland Dedication Fees Tree Mitigation Fees Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBI 40,000 - - - - - 40,000 - - - - - 405 71.47 - 63.74 71.47 - 80,405 71.47 - 63.74 71.47 - PARKLAND DEDICATION Maintenance Services- Landscape 8,000 - - - - - Operating Equipment 30,000 2,567.48 1,837.48 22,904.11 2,567.48 Capital Outlay 6,000 - - - - - TOTAL PARKLAND DEDICATION 44,000 2,567:48 1,837.48 22,904.11'' 2,567.48 - TREE MITIGATION Fund Charges/Transfers - - - - - - Maintenance Services -Trees 36,000 3,133.00 3,133.00 16,437.50 3,133.00 8,825.0 Capital Outlay - - - - - - TOTAL TREE MITIGATION 36,000 3,133.00 3,133.00 16,437.50' 3,133.00 8,825.0 TOTAL EXPENDITURES 80,000 5,700:48 4,970.48 39,341.61'' 5,700.48 8,825.!0 REVENUE OVER(UNDER) EXPEND' 405' 35 (5,629.01)' 36 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRAf Fees 000 - 458800 Parkland Dedication 40,000 - - - - 000- 458900 Tree Mitigation 40,000 - - - TOTAL Fees 80,000 - - - - Miscellaneous 000 - 491000 Interest Earned 60 30.26 - - 30.26 000 - 491200 Investment Interest 280 41.21 - 48.74 41.21 000 - 497000 Miscellaneous Income 65 - - 15.00 TOTAL Miscellaneous 405 71.47 63.74 71.47'' TOTAL'REVENUES 80,405 71.47 - _ 6,3.74 71.47 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $162,279.56 Cash in Investment Pools Federated Investment -Park Fund 38,798.73 Federated Investment -Tree Mitigation 192,223.67 Total in Investment Pool 231,022.40 Total Cash in Bank !& Investment' Pools $' 393,301.96'' 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: OCTOBER 31st, 2010 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBI 31,000 - - - - 25,000 - - - - - 56,000 - - - - - 56,000 - - - - - 56,000 - - - - - 56,000 - - - - - 38 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 318 - RECYCLING CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR Fund Transfers 000 - 486202 Transfer In -W &S 31,000 - - - - - TOTAL Fund Transfers 31,000 - - - - - Miscellaneous 000 - 490210 Sale of Recycle Material 25,000 - - - - - TOTAL Miscellaneous 25,000 - - - - TOTAL REVENUES 56,000 - - - 39 RECYCLE FUND CASH IN BANK AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking (58,365.47) Total Cash in Bank 40 $ (58,365.47)' 411 - CAPITAL RECOVERY FINANCIAL SUMMARY REVENUE SUMMARY Fees Fund Transfers Miscellaneous TOTALREVEN'UES' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Operations Support Professional Services Debt Service Capital Outlay TOTAL NON DEPARTMENTAL' MISC & PROJECTS Projects Schaefer RD Water Improvements Northcliffe Elevated Tnk Northcliffe Water Plant Town Creek Project Live Oak Water Plant Loop Feed Water Line Aviation Heights WTR IMP TOTALIMISC & PROJECTS ri11561rTM0 9:1091111". CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 492,336.49 - 69,851.32 492,336.49 - 585,500 3,481.39 - 524.74 3,481.39 - 1,776,140 495,817.88 - 70,376.06 495,817.88 - 1,000 - - - - - 37,000 - - - - - - 8,428.00 8,428.00 - 8,428.00 - 38,000 8,428.00 8,428.00 - 8,428.!00 - - 3,669.62 600,000 - - 29.03 - 97,366.50 600,000 101,065.15 638,000 109,493.15 REVENUE OVER(UNDER) EXPENDITURES' 1,138,140' 3,669.62 - 3,669.62 - 57,094.70 29.03 97,366.50 - 97,366.50 101,036.12 57,094.70'' 101,065.15 109,464.12 57,094.70' 109,493.115 41 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 ENCUMB Fees 000 - 455900 Capital Recovery - Water 904,200 319,123.34 - 47,041.66 319,123.34 000 - 455910 Capital Recovery -Waste Wtr 272,800 173,213.15 - 22,809.66 173,213.15 000 - 455913 Cap Recovery -North Sewer Tr 13,640 - - - - TOTAL Fees,', 1,190,640 492,336.49 - 69,851.32', 492,336,49,' Fund Transfers 250,000 000 - 481000 Transfer from Reserves - - - - - 000- 486100 Transfer In - - - - - TOTAL Fund Transfers - - - - - Miscellaneous 000 - 491000 Interest Earned 2,000 92.46 - 81.93 92.46 000 - 491200 Investment Income 250,000 1,383.84 - 442.81 1,383.84 000 - 497000 Misc Income - 2,005.09 - - 2,005.09 000 - 498100 Reimbursmnt - FM 78 Project 50,000 - - - - 000- 498200 Re- imbursement -Water Meters 283,500 - - - - TOTAL Miscellaneous 585,500 3,48139 - 524.74 3,481.39 TOTAL REVENUES '' 1,776,140 '495,817.88 - 70,376.06' 495,817.88 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: OCOTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 495,935.73 Cash in Investments: Lone Star Investment - Capital Recovery 261,256.53 Capital One - Investment 1,700,000.00 Schertz Bank & Trust - Certificate of Deposit 522,050.90 Total Cash in Bank & Investment !Pools $2,979,243.16 43 505 -TAX I &S FINANCIAL SUMMARY REVENUE SUMMARY Taxes Fund Transfers Miscellaneous TOTAL'REVENUES' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services Debt Service TOTAL GENERAL GOVERNMENT CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 696,064.54 - 679,087.83 696,064.54 - 243,000 - - - - - 3,000 28.42 - 435.02 28.42 - 3,614,794 696,092.96 - 679,522.85 696,092.96 - 3,200 - - - - - 3,611,124 - - - - - 3,614,324 - - - - TOTAL EXPENDITURES 3,614,324 - - - - - " REVENUE OVER(UNDER), EXPEND 470 696,092.96 44 505 -TAX I & S REVENUES Taxes 000 - 411900 Property Tax Revenue TOTAL Taxes Fund Transfers 000 - 486000 Transfer From Reserves 000 - 486103 Transfer In TOTAL Fund Transfers Miscellaneous 000 - 491000 Interest Earned 000 - 491200 Investment Earnings TOTAL Miscellaneous TOTAL,IREVENUES' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 696,064.54 - 679,087.83 696,064.54 3,368,794 696,064.54 - 679,087.83 696,064.54, 243,000 - - - - 243,000 - - - 1,500 - - 361.58 - 1,500 28.42 - 73.44 28.42 3,000 28.42 - 435.02 28,42' 3,614,794 696,092.96 - 679,522.85' 696,092''.96 45 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 505 -TAX I& S ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -I NON DEPARTMENTAL BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUN Professional Services 101 - 541500 Paying Agent 3,200 - - - - TOTAL Professional Services 3,200 - - - - Debt Service 101 - 555612 Schertz C O SR2001- Principal 210,000 - - - - 101- 555612.1 Schertz CO BOND, 2001 - Interest 141,318 - - - - 101- 555622 Schertz C O SR2003- Principal 190,000 - - - - 101- 555622.1 Schertz C O SR2003- Interest 60,820 - - - - 101- 555624 Comm Proj Bond -SR04- Principal 325,000 - - - - 101- 555624.1 Comm Proj Bond SR04- Interest 265,009 - - - - 101- 555626 LS &D SR2006- Principal - - - - - 101- 555626.1 LS &D SR2006- Interest 650,982 - - - - 101- 555628 CO Bond 2007 - Principal 99,567 - - - - 101- 555628.1 CO Bond 2007 - Interest 26,617 - - - - 101- 555629 GO Bond 2007 - Principal 275,000 - - - - 101- 555629.1 GO Bond 2007 - Interest 209,097 - - - - 101- 555630 GO Bond SR2008 Principal 355,000 - - - - 101- 555630.1 GO Bond SR2008 Interest 379,651 - - - - 101- 555631 GO Bond SR2009 Principal 140,000 - - - - 101- 555631.1 BO Bond SR2009 Interest 283,063 - - - - TOTAL Debt Service 3,61,1,124 - - - - TOTAL EXPENDITURES 3,614,324 46 TAX I &S CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 822,985.79 Cash in Investment Pools Federated Investment -Tax I &S 159,321.47 Total Cash in Bank & Investment' Pools $' 982,307.26 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2010 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 620 -SED CORPORATION CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR REVENUE SUMMARY Taxes 2,035,795 171,041.55 - (167,105.24) 171,041.55 - Miscellaneous 108,000 (2,178.58) - 1,765.04 (2,178.58) - TOTAL REVENUES 2,143,795 1,68,862.97 (165,340.20) 168,862.97 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies Utility Service Maintenance Services Operating Equipment Capital Outlay TOTAL NONDEPARTMENTAL 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 Debt Service Operating Equipment TOTAL ECONO DEVELOPMENT 21,000 822.28 235.28 1,478.42 822.28 85,800 3,705.28 - 2,015.27 3,705.28 67,300 7,498.34 1,965.50 8,765.75 7,498.34 8,498 6,999.31 - 9,000.00 6,999.31 - - 6,999.31 - - 182,598 19,025.21 9,200.109 21,259.44 19,025.21' 202,062 14,776.70 - 18,389.09 14,776.70 1,000 - - 72.40 - 100 - - - - 34,500 3,798.01 623.92 2,500.11 3,798.01 4,850 255.96 - 406.90 255.96 76,100 3,706.87 3,242.89 5,556.05 3,706.87 97,000 556.67 525.53 56,934.01 556.67 80,000 - - - - 349,000 21,340.80 21,340.80 1,720.35 21,340.80 105,432 - - - - 216,000 - - - - 792,432 - - - - 1,500 - - - - 1,959,976 44,435.01 25,733.14 85,578.91 44,435.01' 3,102.90 2,624.36 5,727.26 245.53 200.00 20.01 358.58 50,408.75 51,232.87 TOTAL EXPENDITURES 2,142,574 63,460.22 34,933.23 106,838.35 63,460.22'' 56,!960.13'' REVENUE OVER(UNDER) EXPEND 1,221 105,402.75'' 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: OCTOBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 171,041.55 2,035,795 171,041.55'' 1,000 - 12,000 (2,392.88) 15,000 214.30 80,000 - 108 000 (2,178.58)' - (167,105.24) 171,041.55 (167,105.24)'' 171,041.55' - 71.00 - - 99.73 (2,392.88) - 1,594.31 214.30 1,765.04 (2,178.58)', TOTAL REVENUES 2,143,795 168,862.97 - (165,340.20) 168,862.97 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ (39,095.35) Cash in Investment Pools MBIA Investment - Economic Development Corp 135,151.04 MBIA- Investment -Sysco Infrastructure 150,280.70 MBIA- Investment -EDC Notes 2010 1,251,082.75 Schertz Bank & Trust - Certificate of Deposit 504,512.14 Schertz Bank & Trust - Certificate of Deposit 1,021,810.26 Total Cash in Bank & Investment Pools $ 3,023,741.54 50 4B SALES TAX $250,000 $200,000 14% -2 %0 L..2 3% I � $150,000 $100,000 $50,000 $- 1 2 3 4 5 6 7 8 9 2010 -11 171,042 166,132 172,398 2009 -10 150,192 169,257 140,629 144,175 192,423 146,589 135,864 183,352 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 W,4 k \. w iow Lij _ �.:'.. r �°�