Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03-DECEMBER 2010 STATEMENT
DECEMBER 2010 Financial Report CITY OF S CHERTZ Prepared By: The Finance Department JANUARY 27, 2011 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 2,687,185.94 - 3,954,144.77 5,032,233.97 - Franchises 1,521,000 11,783.80 - 382,498.15 398,372.61 - Permits 1,181,913 75,366.00 - 167,605.99 598,909.33 - Licenses 64,547 4,122.00 - 7,570.50 6,877.10 - Fees 3,073,872 168,401.03 - 552,982.07 727,262.38 (60. Fines 35,000 2,190.66 - 7,082.14 6,442.89 - Inter- Jurisdictional 405,672 20,715.06 - 197,867.01 96,269.30 - Fund Transfers 1,184,474 316,615.75 - 261,102.77 316,615.75 - Miscellaneous 507,284 84,193.90 - 63,662.89 163,347.57 (1,150. TOTAL REVENUES 18,886,418 3,370,574.14 - 5,594,516.29 7 „346,330.90 (1,210. EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 22,800 1,813.46 - 1,467.81 5,397.96 - Supplies 500 22.00 - 33.26 22.00 - City Support Services 20,500 11,838.24 - 8,320.70 11,948.24 150. Operations Support 300 - - 74.08 - - Staff Support 16,400 7,383.12 380.00 7,482.48 8,118.82 435.. Opertating Equipment - - - - - - TOTAL CITY COUNCIL 60,500 21,056.82 380.00 17,378.33 25,487.02 585. CITY MANAGER Personnel Services 718,457 52,793.46 - 154,948.83 162,809.81 - Supplies 2,400 57.99 - 282.19 57.99 262. City Support Services - - - - - - Operations Support - - - - - - Staff Support 25,550 4,871.66 438.80 3,681.80 8,442.49 1,671. Operating Equipment - - - - 133.43 - TOTAL CITY MANAGER 746,407.00 57,723.11 438.80 158,912.82 171,443.72 1,933. 1 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 18,635.04 - 48,549.40 57,178.40 - Supplies 3,200 47.60 - 151.67 391.29 246. City Support Services 1,000 - - - - - Operations Support 3,000 - - - - 1,166. Staff Support 4,200 677.51 33.44 1,121.82 1,071.95 184. Court Support 800 - - - - - Professional Services 88,100 5,355.00 - 11,832.73 12,180.00 22,881.: Maintenance Services 1,000 - - - - - Operating Equipment 2,000 250.00 - 441.98 500.00 - TOTAL MUNICIPAL COURT'' 353,503' 24,965.15 33.44 62,097!.60 71,321.64 24,477!.!: CUSTOMER RELATIONS -311 Personnel Services 88,928 6,286.53 - 37,685.37 19,879.44 - Supplies 500 - - - - Staff Support 1,105 - - - - - TOTAL CUSTOMER', RELATIONS -311 90,533', 6,286.53 - 37,685.37 19,879.44 - PLANNING &ZONING Personnel Services 134,105 9,949.33 - 29,900.02 31,168.04 - Supplies 4,500 - - 26.54 24.75 33.1 City Support Services - - - - - - Operations Support 2,300 - - - - - Staff Support 22,100 2,640.99 1,527.12 6,684.27 2,963.18 - Professional Services 142,300 - - - 9,060.06 - Operating Equipment 600 - - 217.65 - - TOTAL PLANNING & ZONING 305,905' 12,590.32 1,527.12 36,828.48 43,2116.03 33.1 LEGAL SERVICES Operations Support 13,000 - - 4,119.46 - - Professional Services 245,000 - - 26,141.46 - - TOTAL LEGAL SERVICES 258,000', - - 30,260.92 - - z CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 FACILITIES MAINTENANCE Personnel Services 630,024 46,213.02 - 140,793.91 159,212.24 - Supplies 59,900 6,981.22 638.43 13,040.95 14,414.57 11,465. Utility Services 93,600 5,785.59 - 16,758.18 11,136.08 - Operations Support - - - - - - Staff Support 7,712 1,640.90 403.00 2,097.93 3,360.26 1,084. Maintenance Services 111,950 4,363.20 6,471.04 22,559.30 46,096.95 9,348.: Rental /Leasing 2,000 456.96 - 568.35 456.96 - Operating Equipment - - - - - Capital Outlay 24,500 - - - - - TOTAL FACILITIES MAINTENANCE 929,686' 65,440.89 7, 512.47 195,818!.62 234,677.06 21,898''. CITY SECRETARY Personnel Services 167,842 12,641.66 - 37,473.92 38,970.94 - Supplies 1,550 29.95 - 50.45 85.80 20. City Support Services 9,780 1,400.00 - 4,003.11 1,400.00 - Operations Support - - - - - - Staff Support 5,700 539.96 295.00 284.40 1,130.40 548. TOTAL CITY SECRETARY 184,872' 14,611.57 295.00 41,811.88 41,587.14 568,. NON - DEPARTMENTAL Supplies 3,000 - - 1,211.98 - 195. City Support Services 369,000 30,581.03 760.00 203,916.65 190,923.57 1,744. Operations Support 114,000 7,802.26 - 43,805.34 16,311.82 - City Assistance 387,459 - - 199,684.92 96,864.87 - Professional Services 106,350 160.89 - 15,198.60 4,191.55 - Fund Chrgs /Transfrs -Spec Events Fnd 24,350 - - 49,100.00 - - Operating Equipment 500 - - - - Capital Outlay 7,000 - - 13,015.43 - - TOTAL NON- DEPARTMENTAL 1,1011,659' 38,544.118 760.00 525,932.92 308,291.81 1,939 PUBLIC AFFAIRS Personnel Services 131,096 10,453.44 - 39,857.17 32,905.45 - Supplies 2,450 30.08 - 1,240.30 45.05 84. Operations Support 47,500 566.11 - 16,166.68 2,565.47 530. Staff Support 3,750 205.29 - 1,413.74 662.87 - 3 101 GENERAL FUND FINANCIAL SUMMARY Professional Services Operating Equipment TOTAL PUBLIC AFFAIRS RECORDS MANAGEMENT Personnel Services Supplies Staff Support Professional Services Operating Equipment TOTAL RECORDS MANAGEMENT SCHERTZ TALES MAGAZINE Personnel Services Staff Support Professional Services TOTAL SCHERTZ TALES MAGAZINE ENGINEERING Personnel Services Supplies Staff Support Professional Services Maintenance Services Operating Equipment TOTAL ENGINEERING GIS Personnel Services Supplies Staff Support Professional Services TOTAL GIS TOTAL GENERAL GOVERNMENT CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 - - - 64,118.20 - - 6,000 - - 589.94 - - 190,796 11,254.92 - 123,386.03 36,178.84 614. 46,317 3,485.23 - 9,962.44 10,979.45 900 - - - - 1,500 - - - 85.00 15,000 791.00 - 1,667.05 1,368.00 63,717' 4,276.23 - 11,629;49 12,432.45' 126,426 9,811.56 1,000 - 252,500 21,477.15 379,926' 3,1,288.71 26,745.93 - - 23.: 57,185.36 8,527. 83,931.29 8,551 169,469 12,291.93 - 37,206.53 38,605.75 300 - - 33.05 8.35 2,213 - - 260.00 265.00 24,000 1,710.00 - 1,526.68 1,710.00 4,044 - - 1,200.00 2,145.29 200,026' 14,001.93 - 40,226;26 42,734.39' 117,358 8,876.24 - 25,422.42 26,570.20 3,300 - - - - 1,050 - - - 2,000 - - - - 123,708' 8,876.24 - 25,422.42 26,570.20 130. 4,899,238' 310,916.60 10,946.83 1,307,391.14 1 „117,751.03 60,731.' a CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 PUBLIC SAFETY POLICE Personnel Services 4,083,030 312,172.84 - 992,239.74 1,018,110.07 - Supplies 50,558 2,700.38 124.50 1,721.83 3,069.26 1,840. City Support Services 30,000 - - 26,534.00 - - Utility Services 100,000 7,099.72 - 15,534.29 13,888.25 - Operations Support 2,000 - - 21.50 98.00 - Staff Support 31,350 532.00 - 1,936.63 1,016.74 99. City Assistance 13,000 1,339.98 - 3,205.00 1,439.98 - Professional Services 8,000 - - 3.36 - - Maintenance Services 76,949 9,845.25 179.50 12,082.48 20,926.50 - Operating Equipment 63,996 6,442.26 5,196.00 10,592.00 15,080.16 11,646.: Capital Outlay 169,998 112,980.00 - 91,420.00 112,980.00 132,166. TOTAL POLICE 4,628,881 453,112.43 5,500.00 1,155,290''.83 1,186,608.96 145,752!. FIRE RESCUE Personnel Services 2,410,836 173,508.35 - 556,130.70 585,745.23 - Supplies 20,200 951.89 20.15 3,731.81 1,122.04 549. Utility Services 43,900 3,036.48 - 7,775.16 8,049.82 - Operations Support 1,100 - - 146.00 - - Staff Support 116,800 14,291.01 12,138.00 13,768.86 22,295.55 9,679. City Assistance 18,600 - 10,323.17 2,715.75 10,323.17 - Professional Services 18,140 - - - - 1,500. Maintenance Services 55,000 274.50 - 102.00 334.45 - Operating Equipment 44,400 9,754.23 604.50 4,050.00 11,148.10 1,289. TOTAL FIRE'' 2,728,976' 20!1,816.46 23,085.82 588, 420!.28 639,018.36 13,019.! INSPECTIONS Personnel Services 364,194 27,347.52 - 77,821.06 84,804.15 - Supplies 6,750 412.75 375.00 - 422.75 59. Utility Services 7,600 361.46 - 802.98 1,033.40 - Operations Support 3,200 - - 375.00 - 96. Staff Support 14,700 440.25 388.20 1,774.87 1,132.14 500. Professional Services 10,000 - - - - - Maintenance Services - - - - - - Operating Equipment - - - - - - TOTAL INSPECTIONS 406,444', 28,561.98 763.20 80,7731.91 87,392.44 656,. MARSHAL SERVICE 5 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 Personnel Services 513,250 27,278.51 - 89,649.62 94,500.16 - Supplies 6,450 - - 20.34 - - Utility Services 9,000 427.84 - 1,028.66 915.76 - Operations Support 4,000 95.00 - - 107.44 635. Staff Support 9,400 - - 2,254.14 473.61 - Professional Services - - - - - - Maintenance Services 12,400 1,137.00 - 1,041.00 1,359.00 - Operating Equipment 21,480 1,539.54 - - 3,863.58 5,640. Capital Outlay 65,600 1,154.29 - - 16,742.29 29,430. TOTAL MARSHAL SERVICE 641,580' 3!1,632.18 - 93, 993!.76 117,961.84 35,706!.' TOTAL PUBLIC SAFETY 8,405,881' 715,123.05 29,349.02 1,918,478.78 2,030,981.60 195,134.' PUBLIC ENVIRONMENT STREETS Personnel Services 604,591 43,578.69 - 157,967.47 162,495.33 - Supplies 6,300 378.78 28.15 1,166.19 1,581.38 819. Utility Services 101,900 8,383.92 - 18,933.86 17,546.78 532.. Operations Support 1,380 - - - - - Staff Support 9,265 980.07 84.08 1,298.20 1,064.15 638.1 Maintenance Services 155,400 6,524.81 16,620.12 15,363.40 34,289.47 9,384. Rental /Lease 200 - - - - - Operating Equipment 4,200 - - - - Capital Outlay 14,500 15,770.00 - - 17,870.00 - TOTAL STREETS 897,736' 75,616.27 16,732.35 194,729:12 234,847.11 11,375''. TOTAL PUBLIC ENVIRONMENT 897,736' 75,616.27 16,732.35 194,729.12 234,847.11 11,375.' 6 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 PARKS & RECREATION 16,700 - 53.39 (839.99) 343.35 - Utility Services 25,500 PARKS DEPARTMENT - 4,924.14 1,329.91 - Staff Support 925 - - 439.98 Personnel Services 489,640 34,985.10 - 104,971.05 113,279.39 - Supplies 40,555 5,977.39 - 15,326.99 10,856.61 2,352. City Support Services - - - - - - Utility Services 110,000 4,916.41 - 21,206.52 11,271.27 418. Operations Support 700 - 600.00 - 600.00 - Staff Support 7,686 1,374.32 202.35 2,944.16 2,422.82 1,122. Professional Services 35,000 - - - 8,045.00 - Maintenance Services 21,000 8,565.56 - 24,730.05 8,706.35 526. Rental /Leasing 30,531 5,377.37 3,491.50 360.43 14,129.83 1,900. Operating Equipment - 3,395.00 - 5,974.00 3,395.00 - CapitalOutlay 7,000 - - - - 2,204. TOTAL PARKS DEPARTMENT 742,112 64,591.15 4,293.85 175,513!.20 172,706.27 8,523!. SWIM POOL Supplies 16,700 - 53.39 (839.99) 343.35 - Utility Services 25,500 447.54 - 4,924.14 1,329.91 - Staff Support 925 - - 439.98 - - Maintenance Services 199,378 - - 2,795.19 - - Rental /Lease 500 - - - - - TOTAL SWIM POOL, 243,003' 447.54 53.39 7,319.32 1,673.26 - COMMUNITY /CIVIC CENTER Personnel Services 115,041 3,952.08 - 19,531.99 11,223.10 - Supplies 6,423 2,338.81 - 1,902.68 3,852.12 717. Utility Services 47,150 2,789.25 - 7,475.94 5,236.81 - Operations Support 15,282 - - 1,900.00 95.00 1,237. Staff Support 3,250 - - 142.69 - - Professional Services - 825.00 - - 825.00 - Operating Equipment 7,172 - - 26,554.16 100.00 - TOTAL COMMUNITY /CIVIC',CNTR 194,318' 9,905.1,4 - 57,507',.46 21,332.03 1,954,. 101GENERALFUND FINANCIAL SUMMARY SENIOR CITIZEN CENTER Supplies Utility Services City Assistonoo 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 O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31at 2O1O 2010'2011 CURRENT CURRENT PR|ORYEAR PR|ORYEAR Y�-D Y�-D BUDGET PERIOD EXPENSE Y�-DACTUAL ACTUAL ENCUME 124.57 174.42 174.42 942.50 174.42 1,067 174.42 1,179,433 75,118.25 4.347.24 241,407.05 195,085.98 10,477, 667,832 50,542.59 131.353.01 150.749.35 16,400 83.87 584.28 235.23 3.301.� 39,500 3.44810 9.110.00 0.240.43 2.500 745.00 4.185 18.00 23.25 1.071.54 18217 330. 2.100 200.08 2,005 3.500 2.800.25 400.00 65,000 3.750.00 47.30 11.07219 4.022.30 17,106. 801^017 68.342.62 10.570.61 156,949.01 178,329.54 22,809, 801.017 68.342.62 10.570.61 150.949.01 178.329.54 22,809." ^ 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: DECEMBER 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 22,663.82 - 68,285.57 73,587.97 - 24,900 639.91 42.00 3,177.67 2,105.79 2,403. 9,900 547.84 - 1,140.51 1,065.08 - 800 - - - - - 5,800 1,510.43 - 3,276.07 1,524.24 17. 13,000 521.61 - 1,167.40 1,559.59 - 14,500 1,343.50 - 2,005.00 2,912.00 - 6,100 195.00 - 390.00 591.78 1,755. 9,000 - - 17.90 - - 4,000 - - - - - 390,083 27,422.11 42.00 79,460.12 83,346.45 4,176,. 390,083' 27,422.11 42.00 79,460,.12 83,346.45 4,176,.1 261,085 19,721.22 - 41,074.92 57,493.69 - 1,500 346.30 - 129.06 346.30 57. 337,952 4,664.26 - 31,712.22 34,365.43 20,310. 147,131 10,793.99 - 29,419.62 18,609.18 273.. 10,400 885.27 1,813.95 2,176.38 2,904.47 324. 21,100 1,165.32 - 9,488.35 6,950.07 250. 135,836 4,804.94 - 34,954.91 22,793.01 1,522.1 45,809 - - - - - 960,813' 42,381.30 1,813.95 148,955;46 143,462.15 22,737.; 9 101 GENERAL FUND FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 13,425.22 - 53,957.44 42,010.96 - Supplies 1,700 - - - - - Human Services 46,122 7,421.16 - 12,826.24 9,983.40 1,863. Operations Support 12,545 811.86 266.28 4,284.50 1,078.14 1,065. Staff Support 11,982 1,571.96 - 5,593.34 8,337.96 - City Assistance 9,425 102.00 - 2,721.00 724.00 1,000. Operating Equipment 2,500 - - - - - TOTAL HUMAN RESOURCES 303,095 23,332.20 266.28 79,382.52 62,134.46 3,928) FINANCE Personnel Services 419,818 31,597.30 - 99,314.48 96,337.04 - Supplies 3,600 46.91 - 601.84 1,061.83 128. Operations Support 1,050 - - 155.80 - - Staff Support 13,370 615.00 - 2,282.00 1,155.00 379. Operating Equipment 1,000 - - - - - TOTAL FINANCE 438,838' 32,259.21 - 102,3541.12 98,553.87 507,.', PURCHASING & ASSET MGT Personnel Services 234,220 17,710.23 - 56,318.57 54,614.24 - Supplies 2,300 - - 239.14 - - Utility Services 1,200 41.18 - 67.90 41.18 - Operations Support 150 - - - - - Staff Support 6,900 1,171.35 - 2,389.94 1,606.81 893. Operating Equipment 150 - - - - - TOTAL PURCHASING &ASSET MGT 244,920' 18,922.76 - 59,015!.55 56,262.23 893. 10 101 GENERAL FUND FINANCIAL SUMMARY FLEET SERVICE Personnel Services Supplies City Support Services Utility Services Operations Support Staff Support Professional Services Maintenance Services Rental /Lease Operating Equipment TOTAL FLEET SERVICE TOTAL INTERNAL SERVICE MISC & PROJECTS CITY ASSISTANCE Utility Services Patient Assistance Children's Advocacy Assistance Library Capital Campaign Senior Citizen's Hot Meals TOTAL CITY ASSISTANCE TOTAL MISC &'PROJECTS TOTAL EXPENDITURES' REVENUE OVER(UNDER) EXPEND. CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 148,533 11,058.44 101,000 5,802.13 1,500 - 7,000 424.65 400 - 2,435 194.97 45,750 3,238.59 200 - 6,000 - 312,818' 20,718.78 - 37,821.04 39,985.95 - 4,544.98 22,649.18 22,034.88 6,376. - 1,500.00 1,500.00 - - 582.01 648.56 - - 276.40 490.77 140. 474.24 2,890.32 5,685.32 525.: 5,019.22 65,718.95 70,345.48 7,042. 2,260,484' 137,614.25 7,099.45 455,426,60 430,758.19 35,110,' 5,000 - - 5,000.00 5,000.00 - 5,000 - - - - - 42,000 - - - 10,500.00 31,500. 52,000 - - 5,000.00 15,500.00 31,500. 52,000 - 5,000.00 15,500.00 31,500,.'; 18,885,872' 1,410,153.15 79,087.50 4,358,841.82 4,287,399.90 371,315.1 546''' 3,058,931.00 m CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 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 2,331,487.11 - 3,628,190.36 3,981,902.32 000 - 411200 Advalorem Tax - Delinquent 50,000 6,586.91 - 24,157.14 14,812.67 000 - 411300 Advalorem Tax - P &I 50,000 1,506.91 - 6,751.44 3,784.06 000 - 411500 Sales Tax Revenue -Gen Fund 4,071,590 347,605.01 - 285,562.35 1,021,951.81 000 - 411600 Bingo Tax 4,500 - - 1,379.22 981.20 000 - 411700 Mixed Beverage Tax 32,000.00 - - 8,104.26 8,801.91 TOTAL Taxes 10,912,656 2,687,185.94 - 3,954,144.77 5,032,233.97', Franchises 000 - 421200 Center Point /Entex Energy 33,000 - - - - 000- 421220 City Public Service 275,000 - - 77,354.41 83,433.23 000 - 421240 Guadalupe Valley Elec Co -op 430,000 - - 141,613.56 124,838.75 000 - 421250 New Braunfels Utilities 30,000 - - - 7,403.70 000 - 421300 Time Warner -State Franchise 350,000 - - 81,775.18 87,894.73 000 - 421350 Time Warner -PEG Fee 62,000 - - 15,960.54 16,416.59 000 - 421460 AT &T Franchise Fee 220,000 - - 34,667.99 43,536.50 000 - 421465 AT &T PEG Fees 16,000 - 3,548.30 5,497.29 000 - 421480 Other Telecom Franchise 15,000 395.69 - 2,915.56 4,452.05 000 - 421500 Solid Waste Franchise Fee 90,000 11,388.11 - 24,662.61 24,899.77 TOTAL Franchises 1,5211,000 11;783.80 - 382,498.15 398,372.61' Permits 000 - 431100 Home Occupation Permit 770 140.00 - 175.00 140.00 000 - 431200 Building Permit 837,952 53,067.00 - 96,814.19 522,833.83 000 - 431300 Mobile Home Permit 671 40.00 - 40.00 40.00 000 - 431400 Signs Permit 8,596 - - 50.00 75.00 000 - 431500 Food Establishmnt Permit 15,000 800.00 - 10,975.00 8,395.00 000 - 431600 Garage Sale Permit 9,554 360.00 - 2,625.30 2,670.00 000 - 431700 Plumbing Permit 109,769 6,379.00 - 18,339.50 19,860.50 000 - 431750 Electrical Permit 63,062 3,740.00 - 11,775.50 12,960.00 000 - 431800 Mechanical Permit 84,211 6,020.00 - 14,854.00 17,280.00 000 - 431900 Solicitor /Peddler Permit - 10.00 - 180.00 70.00 000 - 431950 Animal /Pet Permit 2,000 5.00 - 600.00 930.00 12 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 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 - 432000 Cert. of Occupancy Prmt 6,578 450.00 - 550.00 1,750.00 246,533.28 000 - 432100 Security Alarm Permit 36,000 3,555.00 3,297.38 - 9,640.00 9,605.00 000 - 435000 Fire Permit 7,750 800.00 90 - 987.50 2,300.00 - - TOTAL Permits,', 1,181,913 75,366.00 Warrant Fees - 167,605.99 598,909.33' Licenses 22,537.30 000 - 451320 Civil Justice Fee -Court 500 000 - 441000 Alcohol Beverage License 6,100 90.00 - 892.50 225.00 Judicial Fee - City 000 - 442000 Contractors License 55,447 3,825.00 1,455.55 - 5,403.00 5,675.00 - 451400 000 - 444000 Pet License 3,000 207.00 - 1,275.00 977.10 000 TOTAL Licenses Teen Court Admin Fee 64,547 4,122.00 - 7,570.50 6,877.10' 180.00 Fees 000 - 451000 Municipal Court Fines 1,540,000 81,894.48 - 298,273.28 246,533.28 000 - 451100 Arrest Fee 60,000 3,297.38 - 11,802.34 11,131.73 000 - 451110 Expunction Fee 90 - - - - 000- 451200 Warrant Fees 187,500 7,103.30 - 31,121.50 22,537.30 000 - 451320 Civil Justice Fee -Court 500 5.01 - 17.43 000 - 451340 Judicial Fee - City 7,000 438.35 - 1,558.47 1,455.55 000 - 451400 Traffic Fine Costs TTL 30,000 1,671.10 - 6,065.26 5,714.23 000 - 451500 Teen Court Admin Fee 500 60.00 - 220.00 180.00 000 - 451510 Juvenile Case Mgmt Fee 60,000 3,667.41 - 12,977.38 12,153.82 000 - 451600 Technology Fund Fee 55,000 2,920.47 - 10,673.66 9,660.71 000 - 451700 Security Fee 40,000 2,190.37 - 8,014.34 7,245.53 000 - 451800 Time Payment Fee - City 5,000 367.41 - 777.82 1,167.14 000 - 451850 State Fines 10% Service Fee 70,000 - - 18,394.21 19,298.66 000 - 451900 DPS Payment- Local 12,250 636.00 - 2,510.66 1,958.09 000 - 452000 Child Safety Fee 8,000 947.63 - 1,923.89 3,166.17 000 - 452050 Indigent Defense Fee 22,500 1,418.71 - 4,986.79 4,741.08 000 - 452100 Platting Fees 66,000 7,000.00 - 12,250.00 20,500.00 000 - 452200 Site Plan Fee 26,400 1,500.00 - 6,649.45 5,500.00 000 - 452300 Plan Check Fee 375,000 27,022.50 - 44,513.91 262,515.41 000 - 452310 Miscellaneous Review Fee - - - - - 000- 452320 Tree Mitigation Admin Fee 11,220 - - 6,851.25 - 000- 452400 BOA/Zoning Fees 11,000 350.00 - 1,750.00 1,050.00 000 - 452500 Food Handler Class 8,000 320.00 - 1,290.00 790.00 000 - 452600 Specific Use /Zone Chng Fee 14,630 - - - - 000- 452610 Plat Recording Fee - - - - - 000- 452710 Zoning Ltr & Dev Rights - 75.00 - 300.00 225.00 13 Y -T -E ENCUM CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 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 000 - 453100 Reinspection Fees 49,000 3,600.00 - 11,075.00 13,425.00 000 - 453110 Swim Pool Inspection Fee - - - - - 000- 453120 Inspections Plan Review - - - 200.00 - 000- 453200 Mowing Fees - Inspections - 571.90 - 514.61 8,256.16 000 - 453211 Admin Fee - Inspections - 1,800.00 - 600.00 3,300.00 000 - 453215 3% Technology Fee - 1.98 - 530.68 1.98 000 - 453310 Misc Inspection Fee - - - 35.00 35.00 000 - 453500 SubContractor Reg. Fee - 2,295.00 - 4,705.00 3,600.00 000 - 453710 Foster Care - 100.00 - - 300.00 000 - 454100 Swim Pool Reservation Fee - - - - 000- 454200 Pool Gate Admission Fee 22,000 - - - - 000- 454300 Seasonal Pool Pass Fee 5,500 - - - - 000- 456500 Haz Mat Fees 2,500 - - - - 000- 456510 Fire Plan Review 800 - - - - 000- 456600 Fire Re- inspection Fee 450 100.00 - - 350.00 000 - 458100 Sale of Merchandise - - - - (29.58) 000 - 458300 Sale of Property /Auction 20,000 732.40 - 1,844.30 1,066.31 (6C 000 - 458400 Civic Center Rental Fees 226,000 8,330.51 - 34,439.52 29,042.75 000 - 458401 Capital Recovery Fee -Civic Cntr - 495.00 - - 910.00 000 - 458450 North Center Rental Fees 24,000 310.00 - - 1,371.00 000 - 458500 Community Center Rental Fees 32,000 1,000.92 - 4,981.00 3,698.92 000 - 458550 Pavilion Rental Fees - 390.00 - - 3,553.50 000 - 458560 Chamber of Comm rent - 1,950.00 - - 1,950.00 000 - 458570 Non - Resident SYSA League 18,000 - - - 7,060.00 000 - 458600 Ball Field Use - - - - - 000- 458650 NonResident User Fee -BVYA 9,000 - - - 1,410.00 000 - 458680 Tournament Fees - Soccer 14,000 - - - - 000- 458700 Vehicle Impoundment 5,000 - - 2,442.75 - 000- 459200 NSF Check Fee 100 - - 49.00 158.00 000 - 459300 Notary Fee 200 78.00 - 78.00 132.00 000 - 459400 Maps, Copies, UDC, & Misc F 200 - - 5.00 5.00 000 - 459600 Animal Adoption Fee 10,500 1,055.00 - 2,770.00 3,065.00 000 - 459700 Pet Impoundment Fee 17,500 1,947.00 - 4,257.00 5,438.01 000 - 459800 Police Reports Fee 6,532 758.20 - 1,551.00 1,622.20 TOTAL Fees 3,073,872 168,401.03 - 552,982.07 727,262.38 (60 14 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2010 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,190.66 - 7,082.14 6,442.89 TOTAL Fines 35,000 2,190.66 - 7,082.14 6,442.89' Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,078 1,756.48 - 5,269.44 5,269.44 000 - 473200 City of Seguin - Fire Contract 40,293 3,355.26 - 10,065.78 10,065.78 000 - 473300 Guad Co - Library 180,816 15,068.00 - 45,203.73 45,204.00 000 - 473400 Randolph AFB - Animal Cntrl 2,500 100.00 - 428.00 900.00 000 - 474200 Library Services - Cibolo - - - - - 000- 474210 Library Services -Selma 19,000 - - - - 000- 474250 Non - Resident Library Fees - - - - - 000- 474400 Dispatch Service - Cibolo 133,305 - - 133,305.00 33,326.25 000 - 474500 Dispatch Service - SCUCISD 2,080 - - 2,080.00 - 000- 474600 School Crossing Guard - Bexar 6,600 435.32 - 1,515.06 1,503.83 TOTAL Inter- Jurisdictional 405,672 20,715.06 - 197,867.01 96,269.30' Fund Transfers 000 - 480000 Indirect Costs - EMS 87,840 21,960.00 - 21,960.00 21,960.00 000 - 480100 Indirect Costs - Hotel /Motel 170,221 42,555.25 - 31,908.00 42,555.25 000 - 482100 Transfer From Reserves -Ct Tech - - - - 000- 482150 Transfer From Court Security 58,011 - - 000- 485000 Interfund Charge- Drainage 38,888 9,722.00 - 9,574.50 9,722.00 000 - 486000 Interfund Chrges -Admin W &S 624,777 156,194.25 - 159,736.97 156,194.25 000 - 486202 Transfer In -W &S - - - - - 000- 486317 Transfer From Park Fund - - - 4,133.27 - 000- 486322 Transfer -In - Library Grants 10,000 - - 000- 487000 Interfund Charges -Fleet 91,737 22,326.25 - 19,915.03 22,326.25 000 - 488000 Interfund Charges -413 53,000 13,858.00 - 13,875.00 13,858.00 000 - 490020 Transfer In -SEDC 50,000 50,000.00 - - 50,000.00 TOTAL Fund Transfers'' 1,184,474 316,615.75 '' - 261,102.77 316,615.75' Miscellaneous 000 - 491000 Interest Earned 5,000 - - 802.74 618.26 000 - 491200 Investment Income 26,000 2,787.78 - 7,610.28 7,578.38 000 - 491900 Unrealized Gain /Loss - (4,485.69) - (4,678.75) (8,707.26) 000 - 493120 Donations - Public Library - - - - - 000- 493130 Donations - Writing the Next Chap. 20,000 124.00 - 7,547.34 20,259.00 15 Y -T -E ENCUM 101 GENERAL FUND REVENUES 000 - 493400 Donation - Animal Control 000 - 493401 Donations -A/C Microchip 000 - 493402 Donations - Spay &Neuter 000 - 493403 Donations - Melvin Boeck A. S. 000 - 494481 LawEnforcemtOfficersStnd &Ed 000 - 495015 Contribution from SED 000 - 497000 Misc Income -Gen Fund 000 - 497005 Misc Income - Publications 000 - 497007 Misc Income - Schertz Artz 000 - 497020 Misc Income -Fleet Recycled 000 - 497100 Misc Income - Police 000 - 497200 Misc Income - Library 000 - 497210 Misc Income - Library Copier 000 - 497300 Misc Income - Animal Control 000 - 497400 Misc Income - Streets Dept. 000 - 497500 Misc Income -TML Insurance 000 - 497550 Misc Income -TML Reimbursemt 000 - 497600 Misc Income - Parks /Vending Mach. 000 - 497800 Misc Income -Pool Concessions 000 - 498000 Reimbursmnt -Gen Fund 000 - 498100 Reimbursmnt Fire - Training 000 - 498110 Reimbursmnt Fire - Emg. Acti -O TOTAL Miscellaneous TOTALREVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2010 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 3,670 678.78 - 1,265.92 1,842.30 3,000 140.00 - 785.00 570.00 12,000 2,004.50 - 3,423.00 5,450.00 3,800 - - - - 40,000 10,272.16 - (4,906.71) 20,615.90 240,000 11,292.00 - 35,421.00 28,958.00 400 - - 250.80 - 20,000 310.00 - 5,928.23 1,979.05 12,131 267.35 - 2,358.40 703.55 3,400 1,674.00 - 3,091.75 2,400 174.00 - 477.83 311.50 11,229 1,150.00 - 3,225.00 6,250.00 78,043 50,882.00 - - 50,882.00 (1,150 20,211 6,077.02 - 3,402.66 13,583.54 500 - - 750.15 404.53 5,500 - - - 33.00 - 846.00 - - 846.00 - - - - 8,078.07 507,284 84,193.90 '' - 63,662.89 163, 347.57 (1,150 18,886,418 3,370,574.14 - 5,594,516.29 7,346,330.90 (1,21Q 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 2,836,373.71 Cash in Investment Pools LOGIC Investment - General Fund 505,219.89 LOGIC Investment -Equip Replacement 73,201.29 LOGIC Investment -Veh Replacement 7,065.47 LOGIC Investment -Air Condi Replacment 122,187.25 CAPITAL ONE Investment - General Fund 1,323,850.01 Total Cash in Bank & Investment Pools $ 4,867,897.62' 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 13 %I _3% 23% $100,000 OCT NOV DEC JAN FEB MAR APR MAY JUN 2010 -11 339,709 329,696 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' By removing the $138,288.39 one time correction paid in the month of February the true sales tax percent is -1 18 -B CITY PUBLIC SERVICE $100,000 ... ......... ......... ......... ......... ......... ......... $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 OCT NOV DEC JAN FEB MAR APR MAY JUN 132010-11 83,433 - 2009 -10 77,354 61,468 63,276 ® 2008 -09 77,308 53,071 57,506 2007 -08 55,729 50,340 48,120 2006 -07 57,413 38,691 42,722 I :mil 106 - SPECIAL EVENTS FUND FINANCIAL SUMMARY REVENUE SUMMARY Fund Transfers Wilenchik Walk for Life TML Dinner Hal Balwin Scholarship Miscellaneous TOTALREVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental TOTAL GENERAL GOVERNMENT CULTURAL Other Events Festival of Angels Employee Appreciation Event 4th of July Jubilee National Night Out Wilenchik Walk for Life Blue Santa Schertz Fest TML Events Schertz Sweetheart Hal Baldwin Scholarship TOTAL CULTURAL TOTAL EXPENDITURES CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 - - 70.00 - 22,300.00 153.39 - 5,739.52 395.28 139,014.00 153.39 - 140,153.52 395.28 5,150.00 - - - - 5,150.00 - - - - 4,750.00 - - - - 24,250.00 9,611.48 - 9,240.33 10,111.48 1,165 5,000.00 - - - (76.87) 126 100.00 - - - - 30,500.00 - - - - 6,000.00 - - - - - - 455.59 306.07 455.91 2,700.00 - - - - 32,000.00 7,963.05 1,058.00 7,790.63 9,621.05 1,373 1,000.00 - - - - 106,300.00 17,574.53 1,513.59 17,337.03 20,111.57 2,664 111,450.00 17, 574.53 1,513.59 '' 117, 337.03 20,11,1.57 2,664 REVENUE OVER(UNDER) EXPEND '' 27,564.00'' 19 (19,71629)' SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 56,275.00 Cash in Investment Pools MBIA Special Events 66,473.34 Total Cash in Bank & Investment' Pools $,', 122,748.34 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: DECEMBER 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 - - 34,450.00 10,650.00 - 13,679,750 1,099,968.47 - 3,051,532.13 3,374,141.98 - 480,616 20,154.00 - 19,750.03 20,154.00 - 55,445 5,184.79 - 14,368.99 27,530.25 - 14,353,811 1,125,307.26 - 3,120,101.15'' 3,432,476.23 - NON DEPARTMENTAL Fund Charges /Transfers 31,000 TOTAL NON DEPARTMENTAL 31,000' BUSINESS OFFICE Personnel Services 458,640 31,151.13 - 81,252.45 105,210.34 - Supplies 6,650 213.97 - 689.25 306.63 6324 Operations Support 114,000 8,293.12 - 25,540.05 19,121.60 - Staff Support 7,850 373.42 - 126.98 863.87 136.4, Professional Services 9,000 (1,306.37) - 2,127.11 (1,262.96) - Fund Charges /Transfers 40,000 - - - - - Maintenance Services 12,000 1,200.00 - 1,200.00 1,200.00 - Operating Equipment 6,800 320.00 - - 6,285.62 314.0( TOTAL BUSINESS OFFICE 654,940 40,245.27 - 110,935.84'' 131,725.10 1,082.9'. W & S ADMINISTRATION Personnel Services 1,212,507 85,059.48 - 335,444.00 324,643.97 - Supplies 193,700 49,193.73 338.73 13,731.53 52,968.10 14,598.7( Human Services 338 - - - - 64.0( City Support Services 130,000 3,903.65 - 20,151.65 33,007.48 1,776.3: Utility Services 2,780,900 176,727.53 - 497,490.44 380,589.85 646.2' Operations Support 8,750 788.57 79.60 867.05 1,134.45 - Staff Support 33,000 4,582.88 1,339.00 5,406.67 7,056.33 1,614.2 City Assistance 1,912 - - 162.00 102.00 - Professional Services 150,094 1,025.00 9,870.00 22,956.14 8,469.08 - Fund Charges /Transfers 2,368,176 378,270.90 - 169,137.00 588,422.55 - Maintenance Services 4,838,250 580,928.02 116.41 1,323,784.95 1,038,470.19 6,616.4, Other Costs 25,000 28,291.85 - 23,671.50 28,911.85 - Debt Service 1,435,165 83,375.00 - 607,340.30 83,375.00 - Rental- Leasing 6,070 - - 509.66 662.53 - 21 22 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 10,468.99 3,420.00 (3,400.00) 10,468.99 Capital Outlay 58,000 650.00 22,432.00 - 23,082.00 55,670.0( Water Line Relocation - - - 357,740.77 - - TOTAL PUBLIC WORKS 13,254,862 1,403,265.60 37,5!95.74 3,374,993.66'' 2,581,364.37 80,985.9, MISC & PROJECTS PROJECTS FUND CHARGES /TRANSFERS - - - - - - TOTAL PROJECTS '' AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services 19,000 - - - - - Operations Support 500 - - - - - Professional Services 45,000 6,083.23 - 6,278.12 6,083.23 11,438.4E Maintenance Services 335,500 - - 91,201.10 22.35 TOTAL AVIATION HEIGHTS WTR IMP 400,000 6,083.23 - 97,,479.22 6,105.58 1,1,438.4E FM3009 RD &BRIDGE EXPANSION Professional Services - 11,221.30 19,137.50 - 30,358.80 - Maintenance Services - - - 111,134.99 29.03 - TOTAL FM3009 RD &BRIDGE EXPANSION - 11,221.30 19,138 1,11,135 30,387.83 - TOTALL'MISC &'PROJECTS 400,000 17,304.53 19,137.50 208,,614.21 36,493.41 1,1,438.4E TOTAL EXPENDITURES 14,340,802 1,460,815 56,733 3,6,94,544 2,749,583 93,50 -, — REVENUE OVER(UNDER)EXPENSES ** 13,009 682,893.35 22 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2010 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -I REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUN Franchises 000 - 421490 Tower Leasing 138,000 - - 34,450.00 10,650.00 TOTAL Franchises 138,000 - - 34,450.00 10,650.00' Fees 000 - 455200 Garbage Collection Fee 3,300,000 293,494.45 - 753,878.03 812,248.08 000 - 455600 Fire Line Fees 18,500 - - 995.00 18,430.00 000 - 455700 Recycle Fee Revenue 155,000 18,413.12 - 37,196.76 44,316.14 000 - 455800 W &S Line Constructn Reimbursemnt 50,000 1,829.00 - 4,214.00 6,583.95 000 - 457100 Sale of Water 7,200,000 545,686.21 - 1,446,856.92 1,704,350.60 000 - 457110 Edwards Water Lease 127,250 - - 779.80 59,507.50 000 - 457120 Water Transfer Charge -Selma 5,000 - - 780.18 - 000- 457130 Water Transfer Charge -U. C. 1,000 - - 3,914.06 - 000- 457200 Sale of Meters 86,000 4,960.74 - 12,213.95 23,010.30 000 - 457400 Sewer Charges 2,560,000 218,717.67 - 745,617.73 661,486.91 000 - 457500 Water Penalties 175,000 16,605.13 - 44,406.99 43,515.06 000 - 459200 NSF Check Fee -Water &Sewer 2,000 262.15 - 678.71 693.44 TOTAL Fees 13,679,750 1, 099, 968.47 - 3, 051, 532.13 3,374,141.98 Fund Transfers 000 - 486101 Transfer In- General Fund 400,000 - - - - 000- 486204 Interfnd Chrg- Drainage Bill 80,616 20,154.00 - 19,750.03 20,154.00 TOTAL Fund Transfers 480,616 20,154.00 - 19,750.03 20,154.00' Miscellaneous 000 - 490000 Misc Charges 15,000 4,141.88 - 9,153.11 4,381.88 000 - 491000 Interest Earned 500 437.30 - 162.21 970.57 000 - 491200 Investment Income 5,000 450.19 - 2,193.64 (9,101.10) 000 - 493130 Library Donations - - - 2.25 - 000- 493400 Donations - Christmas Activitise - 1,000.00 - - 1,000.00 000 - 497000 Misc Income -W &S 20,000 (844.58) - 2,857.78 (2,071.70) 000 - 497550 TML Reimbursements - - - - 2,291.34 000 - 498100 Reimbursement -EMS Loan 9,945 - - - - 000- 498110 Reimbursement -SSLGC - - - - 24,940.96 000 - 498200 W &S Project Reimbursement 5,000 - - - 5,118.30 TOTAL Miscellaneous 55,445 5,184.7,9 - 14,368.99 27,530.25', TOTAL REVENUES 14,353,811' 1,125,307.26 - 3,120,101.15 3,432,476.23' 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 800,937.68 Cash in Investment Pools Lone Star Investment -Water &Sewer 989,567.17 Lone Star Investment -W &S Customer Deposits 293,135.11 Lone Star Investment -W &S Equip Replacement 372,395.29 Lone Star Investment -W &S Veh Replacement 542,996.83 Schertz Bank & Trust - Certificate of Deposit 1,030,000.00 $ 3,228,094.40 Total Cash in Bank & Investment Pools $4, 029,032.08 24 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 5,115.00 - 1,070,223.43 769,371.37 Inter - Jurisdictional 1,432,345 121,575.58 - 428,341.06 469,515.81 Miscellaneous 334,850 18,968.36 - 39,439.93 44,116.20 TOTAL REVENUES 7,203,732 145,658.94 - 1,538,004.42 1,283,003.38 PUBLIC SAFETY SCHERTZ EMS Personnel Services 2,391,410 187,411.39 - 638,652.62 668,079.76 - Supplies 327,874 18,954.66 331.60 92,694.72 67,875.75 21,750.7E Human Services 847 - - - - 446.00 City Support Services 15,000 - - 12,725.71 10,902.09 - Utility Services 80,438 7,750.10 - 16,218.55 15,961.48 - Operations Support 30,000 7,522.93 - 6,575.37 22,509.79 1,170.85 Staff Support 75,600 11,325.97 171.35 32,180.38 16,991.92 14,007.34 City Assistance 7,753 558.00 - 1,008.05 630.00 500.00 Professional Services 137,890 4,682.88 160.00 28,408.14 31,968.41 3,062.4E Fund Charges/Transfers 3,576,092 29,475.00 - 1,160,604.62 29,475.00 - Maintenance Services 42,320 1,314.32 - 3,565.78 8,631.40 70.00 Debt Service 248,502 - - - - - Rental- Leasing 40,000 - - 2,307.03 836.33 - Operating Equipment 82,600 1,834.28 - 24,869.82 2,044.28 1,724.65 TOTAL PUBLIC SAFETY'' 7,056,326 270,829.53 662.95 2,019,81079' 875,906.21 42,732.13 TOTAL EXPENDITURES 7,056,326 270,829'_53 662.95 2,019,810.79' 875,906.21 42,732.13 "" REVENUE OVER(U,NDER)'EXPENSES " 147,406 407,097.17 2s CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2010 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 203 -EMS CURRENT CURRENT PRIOR YEAR PRIOR YEAR Y -T -D Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL ACTUAL ENCUMBR Fees 000 - 456100 Ambulance /Mileage Transprt 5,336,537 - - 1,067,908.43 756,536.37 - 000- 456110 Subscription Program Fees 100,000 5,115.00 - 2,315.00 12,835.00 - TOTAL Fees 5,436,537 5,115.00 - 1,070,223.43 769,371.37 - Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 286,126 68,250.58 - 71,531.61 136,501.16 - 000- 474300 Cibolo Support 219,699 53,325.00 - 53,325.00 106,650.00 - 000- 475100 Comal Co ESD #6 75,369 - - - 18,293.44 - 000- 475200 Live Oak Support 152,569 - - 37,031.25 37,031.25 - 000- 475300 Universal City Support 210,545 - - 51,103.13 51,103.13 - 000- 475400 Selma Support 64,689 - - 15,701.25 17,182.50 - 000- 475500 Schertz Support 399,083 - - 193,729.74 96,864.87 - 000- 475600 Santa Clara Support 10,851 - - 2,663.29 2,633.67 - 000- 475800 Marion Support 13,414 - - 3,255.79 3,255.79 - TOTAL Inter - Jurisdictional 1,432,345 121,575.55 - 428,341.06 469,515.81 - Miscellaneous 000 - 491000 Interest Earned - - - - - - 000- 491200 Investment Income - 60.12 - 68.98 187.31 - 000- 493203 Donations -EMS 6,000 600.00 - 456.00 850.00 - 000- 497000 Misc Income 150,000 15,173.83 - 24,791.95 26,217.80 - 000- 497100 Recovery of Bad Debt 100,000 3,404.41 - - 4,901.09 - 000- 497500 Misc Income -EMT Classes 78,850 (270.00) - 14,123.00 11,960.00 - TOTAL Miscellaneous 334,850 18,968.36 - 39,439.93 44,116.20 - TOTAL REVENUES 7,203,732 14,5,658.94 -_ 1,538,004.42 1,283,0,03.38 - 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ (439,533.72) Cash in Investment Pools LOGIC Investment -EMS MBIA Investment -EMS Note 2010 300,380.42 Total Cash in Bank & Investment Pools $ (139,153.30)' 27 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2010 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0- 2 0 1 1* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRENT Y -T -D I FINANCIAL SUMMARY BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR E REVENUE SUMMARY Fees 675,300 58,649.78 - 166,847.95 175,417.19 - 4 Miscellaneous 1,300 116.42 - 240.85 386.91 - _ TOTAL REVENUES 676,600 58,766.20 '' - 167,088180 175,804.10 - 5 PUBLIC WORKS DRAINAGE Personnel Services 361,183 25,901.41 - 87,031.47 95,557.77 - 2 Supplies 8,300 87.16 28.15 285.63 183.24 290.81 Human Services 100 - - - - - City Support Services 26,500 - - 432.27 1,345.04 487.14 Utility Services 12,888 886.95 - 2,861.20 2,134.11 304.13 Operations Support 2,458 - - - - - Staff Support 8,255 529.76 168.83 731.73 842.24 347.02 City Assistance 840 - - 102.00 15.00 - Professional Services 19,800 - - 4,038.35 - - Fund Charges/Transfers 195,449 32,662.25 - 32,324.53 32,662.25 - 1 Maintenance Services 22,000 - - 217.65 - 1,987.00 Other costs 100 - - - - 100.00 Debt Service 18,138 - - - - - Rental /Leasing 500 - - - - - _ TOTAL DRAINAGE 676,511'' 60,067.53 '' 196.98'' 128,024.83 132,739.65 3,516.10 5 TOTAL EXPENDITURES 676,511'' 60,067.53 '' 196.98'' 128,024.83 132,739.65 3,516.10 5 "" REVENUE OVER(UNDER) EXPEND 89' 2s 43,064.45 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: DECEMBER 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 413.76 671,800 58,236.02 675,300, 58,649.78, 100 49.29 600 57.89 600 9.24 1,300 1' 16.422 676,600 58,766.20 29 958.67 165,889.28 1166, 847,.95 1.40 187.11 52.34 240.85 1,038.12 174, 379.07 1,75,417.19 113.55 181.02 92.34 386.91 167,088.80 175,804.10 - L - 497 — 49� 50C DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking 144,458.34 Cash in Investment Pools Lone Star Investment - Drainage Maint Fund 282,636.46 Total Cash in Bank & Investment Pools $ 427,094.80 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: DECEMBER 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 27,603.73 - 70,614.23 64,284.36 - 5,550 60.10 - 165.62 149.81 390,550 '' 27,663.83 - 70,779.85 64,434.17 - 31,841 - - - - - 78,228 14,557.00 502.85 2,913.50 15,059.85 - 33,424 2,351.00 - - 2,351.00 1,000.00 2,500 - - 402.28 - - 231,485 42,555.25 - 117,152.00 42,555.25 - 502.85 120,467.78 59,966.10 1,000.00 377,478 59,463.25 TOTAL EXPENDITURES 377,478 59,463.25 502.85' 120,467.78 59,966.10 1,000.00 REVENUE OVER(UNDER)',EXPENDITURE 13,072' 4,468.07 31 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 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 27,603.73 - 70,614.23 64,284.36 - 320, TOTAL Taxes 385,000 27,603,73 - 70,,614.23 64,284.36 - 320, Miscellaneous 000 - 491000 Interest Earned 250 47.42 - 130.29 110.07 - 000- 491200 Investment Interest 300 12.68 - 35.33 39.74 - 000- 497000 Misc Income 5,000 - - - - - 5, TOTAL Miscellaneous 5,550 60.10 - 165.62 149.81 - 5, TOTAL REVENUES 390,550 27,663.83 - 70,779.85 64,434.17 - 326, 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 122,668.20 Cash in Investment Pools Federated Investment -Hotel /Motel 78,041.54 Total Cash in Bank '& Investment Pools $' 200,709.74' 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: DECEMBER 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 - - 38,823.75 - 405 81.58 - 163.25 230.92 80,405 81.58 - 38,987.00 230.92 - PARKLAND DEDICATION Maintenance Services- Landscape 8,000 - - - - - Operating Equipment 30,000 13,582.14 11,244.23 32,525.73 22,007.50 15,496.4 Capital Outlay 6,000 - - - - - TOTAL PARKLAND DEDICATION 44,000 13,582:14 11,244.23 32,525.73'' 22,007.50 15,496.4 TREE MITIGATION Fund Charges/Transfers Maintenance Services -Trees Capital Outlay TOTAL TREE MITIGATION TOTAL EXPENDITURES - - - 4,133.27 - - 36,000 688.00 3,133.00 26,750.00 14,986.00 3,678.0 36,000 688.00 3,133.00 30,883.27' 14,986.00 3,678.0 80,000 14,27014 14,377.23 63,409.00' 36,993.50 19,174.4 REVENUE OVER(UNDER) EXPEND' 405' 35 (36,762.58)' 36 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 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 ENCUMBRA Fees 000 - 458800 Parkland Dedication 40,000 - - - - 000- 458900 Tree Mitigation 40,000 - - 38,823.75 - TOTAL Fees '' 80,000 - - 38,823.75 - Miscellaneous 000 - 491000 Interest Earned 60 44.02 - 10.38 113.22 000 - 491200 Investment Interest 280 37.56 - 117.87 117.70 000 - 497000 Miscellaneous Income 65 - - 35.00 - TOTAL Miscellaneous 405 81.58 163.25 230.92' TOTAL REVENUES 80,405 81.58 - 38,987.00 230.92, 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $141,090.58 Cash in Investment Pools Federated Investment -Park Fund 38,811.58 Federated Investment -Tree Mitigation 192,287.31 Total in Investment Pool 231,098.89 Total Cash in Bank !& Investment' Pools $' 372,189.47'' 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: DECEMBER 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: DECEMBER 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: DECEMBER 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: DECEMBER 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 99,966.34 - 198,765.96 733,140.17 - 585,500 81,781.99 - 85,152.85 81,339.95 - 1,776,140 181,748.33 - 283,918.81 814,480.12 - 1,000 - - - - - 37,000 353.04 - - 707.20 - - - 8,428.00 - 8,428.00 38,000 353.04 8,428.00 - 9,135.20 - - - 53,183.36 90.00 53,183.36 - 600,000 - - - - - - 201,982.40 - 453,469.89 202,011.43 2,232.3 - - 225,148.72 29,487.92 225,148.72 - 600,000 201,982.40 278,332.08 483,047.81'' 480,343.51 2,232.3 638,000 202,335.44 286,760.08 483,047.81' 489,478.71 2,232.3' REVENUE OVER(UNDER) EXPENDITURES' 1,138,140' 41 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 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 ENCUMI Fees 191.45 - 1,628.33 000 - 491000 Interest Earned 000 - 455900 Capital Recovery - Water 904,200 65,760.00 250,000 000 - 455910 Capital Recovery -Waste Wtr 272,800 34,056.34 (5,425.99) 000 - 455911 Capital Recovery-Wste Wtr Zone 1 13,640 - 000 - 498200 000- 455913 Cap Recovery-North Sewer Tr - 150.00 585,500 TOTAL Fees 1,190,640 99,966.34', Fund Transfers 000 - 481000 Transfer from Reserves 000 - 486100 Transfer In TOTAL Fund Transfers Miscellaneous 191.45 - 1,628.33 000 - 491000 Interest Earned 2,000 39.67 000 - 491200 Investment Income 250,000 3,793.31 000 - 491900 Unrealized Gain /Loss -Cap One - (5,425.99) 000 - 498100 Reimbursmnt - FM 78 Project 50,000 12,500.00 000 - 498200 Re- imbursement -Water Meters 283,500 70,875.00 TOTAL Miscellaneous 585,500 81,781.99' - 144,412.98 467,083.34 - 54,352.98 265,606.83 - 198,765.96 733,140.17, - 149.55 191.45 - 1,628.33 8,621.98 - - (10,848.48) - 12,499.97 12,500.00 - 70,875.00 70,875.00 85,152.85 81,339.95 TOTAL,REVENUES 1,776,140 181,748.33 - 283,918.81 814,480.12 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 121,980.21 Cash in Investments: Lone Star Investment - Capital Recovery 261,362.76 Capital One - Investment 1,695,804.13 Schertz Bank & Trust - Certificate of Deposit 523,072.79 Total Cash in Bank & Investment !Pools $2,602,219.89 43 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2010 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 0 - 2 0 1 1 * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR PRIOR YEAR CURRRENT Y -T -D REVENUES BUDGET PERIOD EXPENSE Y -T -D ACTUAL Y -T -D ACTUAL ENCUMB Taxes 000 - 411900 Property Tax Revenue 3,368,794 1,172,739.83 - 1,931,231.65 1,994,284.22 - TOTAL Taxes, 3,368,794 1,172,739.83 - 1,931,231.65 1,994,284.22 - Fund Transfers 000 - 486000 Transfer From Reserves 243,000 - - - - - 000- 486103 Transfer In - - - - - - TOTAL Fund Transfers 243,000 - - - - -_ Miscellaneous 000 - 491000 Interest Earned 1,500 - - 570.19 224.83 - 000- 491200 Investment Earnings 1,500 25.90 - 564.69 81.16 - TOTAL Miscellaneous 3,000 25.90 - 1,134.88' 305.99 - TOTAL, REVENUES 3,614,794 1,172,765.73 - 1,932,366.53' 1,994,590.21 - 4s 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: DECEMBER 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 1,172,739.83 - 1,931,231.65 1,994,284.22 - 243,000 - - - - 3,000 25.90 - 1,134.88 305.99 - 3,614,794 1,172,765.73 - 1,932,366.53 1,994,590.21 - 3,200 - - - - - 3,611,124 - - - 4,664.58 - 3,614,324 - - - 4,664.158 TOTAL EXPENDITURES 3,614,324 - - - 4,664.58 - " REVENUE OVER(UNDER),EXPEND 470 1,989,925.63 44 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 - - - 4,664.58 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 - - - 4,664.58 TOTAL EXPENDITURES 3,614,324 '' - - - 4,664.58 46 TAX I &S CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $2,116,765.72 Cash in Investment Pools Federated Investment -Tax I &S 78,041.54 Total Cash in Bank & Investment' Pools $2,194,807.26 47 620 -SED CORPORATION FINANCIAL SUMMARY REVENUE SUMMARY Taxes Miscellaneous TOTAL REVENUES EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies Utility Service Maintenance Services Operating Equipment Capital Outlay TOTAL NONIDEPARTMENTAL' ECONOMIC DEVELOPMENT Personnel Services Supplies Human Services City Support Services Utility Services Operations Support Staff Support City Assistance Professional Services Fund Charges/Transfers Fund Replenish -Fund Balance Maintenance Services Debt Service Operating Equipment TOTAL ECONO DEVELOPMENT CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 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 173,802.50 - 142,781.17 510,975.88 - 108,000 6,209.16 - 2,159.23 4,338.34 - 2,143,795 1,80,011.66 - 144,940.40 515,314.22 - 21,000 2,452.72 623.28 2,676.51 5,821.77 1,813.11 85,800 4,680.23 - 15,395.88 8,966.37 - 67,300 7,027.61 5,965.50 10,172.09 24,798.34 1,695.89 8,498 - - 9,000.00 6,999.31 - - - 6,999.31 - - - 182,598 14,160.56 13,588.09 37,244.48 46,585.79 3,509.00 202,062 8,840.69 - 63,614.04 41,660.12 - 1,000 - - 131.75 153.03 319.63 100 - - - - - 34,500 590.00 623.92 11,277.71 4,580.24 425.88 4,850 328.88 - 1,121.33 615.01 - 76,100 7,356.16 3,242.89 21,163.92 11,477.69 5,642.28 97,000 5,919.97 1,782.11 73,724.94 56,139.83 3,354.53 80,000 - - - - - 349,000 14,080.00 21,340.80 69,089.57 41,418.80 - 105,432 63,858.00 - 13,875.00 63,858.00 - 216,000 - - - - - - - - 781.89 - - 792,432 - - - - - 1,500 - - 2,485.29 - - 1,959,976 100,973.70 26,989.72 257,265.44 219,902.72' 9,742.32 TOTAL EXPENDITURES 2,142,574 115,134.26 40,577.81 294,509.92 266,488.51'' 13,251.32'' " REVENUE'OVER(UNDER) EXPEND 1,221 '' 248825.71'.'' 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: DECEMBER 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 173,802.50 2,035,795 173, 802.50'' 1,000 - 12,000 6,209.16 15,000 - 80,000 - 108,000 6,209.16,', 142,781.17 510,975.88 142,781.17 51!0,975.88 - 289.82 - - 275.10 4,124.04 - 1,594.31 214.30 2,159.23 4,338.34 TOTAL REVENUES'' 2,143,795 180,011.66 - 144,940.40 51!5,314.22 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2010 Cash in Bank Claim on Operating Cash Pool- Checking $ 325,186.98 Cash in Investment Pools MBIA Investment - Economic Development Corp 15,179.72 MBIA- Investment -Sysco Infrastructure 150,341.03 MBIA- Investment -EDC Notes 2010 347,995.88 Schertz Bank & Trust - Certificate of Deposit 504,947.54 Schertz Bank & Trust - Certificate of Deposit 1,027,353.23 Total Cash in Bank & Investment Pools $ 2,371,004.38 50 4B SALES TAX By removing the $138,288.39 one time correction paid in the month of February the true sales tax perc 51 J.. S z N MI? Im M m IMEMEN. m I � RNA& mmmam, r=d awfAl'oe. v ti