Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12-SEPTEMBER 2012 FINANCIAL STATEMENT
SEPTEMBER 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department January 22, 2013 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725577,058.73 11,590,627.69-12,322,356.16 (518,631.16) Franchises 1,526,000 133,878.25 1,511,307.51- 1,567,035.04 - (41,035.04) Permits 1,187,800 110,283.77 1,638,900.78- 1,075,833.02 - 111,966.98 Licenses 48,300 4,615.00 62,013.10- 70,467.50 - (22,167.50) Fees 3,324,727 251,511.87 2,630,495.79- 2,929,743.03 - 394,983.97 Fines 30,000 2,596.03 26,078.81- 28,543.30 - Inter-Jurisdictional 571,245 90,487.42 455,705.89- 630,682.31 - (59,437.31) Fund Transfers 1,585,658 155,264.34 1,193,878.60- 1,361,764.87 - 223,893.13 Miscellaneous791,010294,174.06479,066.04886,598.75(17.90) - TOTAL REVENUES20,868,4651,619,869.4719,588,074.2120,873,023.98(17.90) - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,694.19 23,864.76- 20,917.33 - Supplies 700 102.11 - 691.89 697.25 - City Support Services 18,000 472.21 14,194.96- 8,141.59 - Utility Services - - 1,318.73 - - - Operations Support 100 7.20 - 190.95 7.20 - Staff Support19,900366.34 16,964.20325.26 -13,139.28 Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 2,642.05 53,400.57- 46,727.57 325.26 CITY MANAGE R Personnel Services853,06389,764.81 742,863.46-861,685.46 - (8,622.46) Supplies4,731 89.56 - 3,152.27 3,032.03 159.99 1,538.98 - - - 45.00 Operations Support - - Staff Support 30,400 1,276.44 27,913.16- 26,253.65 90.00 Operating Equipment -1,596.70 - - - - TOTAL CITY MANAGER 888,194 91,130.81 775,525.59- 891,016.14 249.99 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services259,269 28,343.60 245,788.82- 259,995.60 - Supplies 2,500 210.27 - 1,951.58 1,910.27 74.51 City Support Services 1,000 - - 303.06 1,000.00 - Operations Support 3,000 261.00 - 1,951.00 2,767.00 - Staff Support 5,500 147.53 - 3,159.35 2,763.61 - Court Support 800 - - - - - Professional Services 71,100 3,327.17 49,154.00- 51,944.63 1,144.18 Maintenance Services 2,200 350.00 - 1,000.00 1,849.94 - Operating Equipment1,000 497.141,003.89 - - - TOTAL MUNICIPAL COURT 32,639.57346,369 - 304,311.70 322,728.19 1,218.69 22,422.12 CUSTOMER RELATIONS-311 Personnel Services110,839 11,009.29 83,835.58- 102,582.61 - Supplies 300 128.76 - 398.19 279.37 - Staff Support1,01874.22 1,069.97710.42 - - Operating Equipment500 213.00- - - - TOTAL CUSTOMER RELATIONS-311 112,657 11,212.27 85,303.74- 103,785.40 - PLANNING & ZONING Personnel Services 140,707 13,994.28 134,525.35- 139,027.98 - Supplies 2,472 322.86 - 792.27 1,689.39 20.93 Operations Support 435 91.78 - 77.95 91.78 - Staff Support 17,412 6,340.75 11,115.75- 8,800.10 - Professional Services 76,931 8,279.12 83,965.11- 78,082.16 - (1,151.16) Operating Equipment3,500 2,112.001,055.00 - - - TOTAL PLANNING & ZONING241,45729,028.79 231,531.43-229,803.4120.93 LEGAL SERVICES Operations Support13,000 5,104.25 9,199.04- 6,483.81 - Professional Services245,000144,106.91331,155.55544,310.15 - - TOTAL LEGAL SERVICES 258,000 -149,211.16 340,354.59 550,793.96 - (292,793.96) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services649,236 64,464.55 617,207.71- 603,986.41 - 45,249.59 Supplies66,535 3,202.82 - 57,672.68 63,627.51 78.57 2,828.92 Utility Services112,000 18,250.55 - 97,064.39 99,751.73 - 12,248.27 Staff Support13,179 533.98 - 10,480.03 9,726.13 - Maintenance Services 99,119 10,548.50 110,319.03- 96,696.38 - Rental/Leasing 400 - - 763.92 331.59 - Operating Equipment3,3965,106.34 6,554.332,789.01 - - Capital Outlay24,500 5,106.34- - - - TOTAL FACILITIES MAINTENANCE 968,365 102,106.74 900,062.09- 882,015.10 78.57 CITY SECRETAR Y Personnel Services 165,391 16,855.57 164,231.64- 166,334.05 - Supplies 1,250 60.93 - 1,471.64 1,000.45 - City Support Services 9,780 - - 6,788.22 2,606.65 - Staff Support8,605700.40 7,393.504,076.94 - - TOTAL CITY SECRETARY 185,026 17,616.90 176,568.44- 177,334.65 - NON-DEPARTMENTA L Supplies2,500190.57-405.35201.28 - City Support Services 577,781 242,549.68 320,103.68- 494,267.70 36,400.00 Operations Support 139,000 30,311.25 140,986.56- 161,025.62 - (22,025.62) Staff Support - - 80.00 96.90 - - City Assistance 459,046 - 422,942.47- 481,160.88 - (22,114.88) Professional Services 174,650 11,672.87 58,103.25- 88,300.01 2,000.00 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 63,270.40 396,110.97- 63,270.40 - (52,420.40) Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,363,827 347,994.77 1,338,732.28- 1,288,322.79 38,400.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services271,136 30,591.15 160,520.83- 277,733.16 - (6,597.16) Supplies2,900 84.93 - 1,936.03 2,799.89 - Operations Support 34,585 4,101.22 25,532.94- 30,649.97 75.00 Staff Support 4,865 166.49 - 2,381.89 3,584.57 - Operating Equipment300 -2,737.18 - - - TOTAL PUBLIC AFFAIRS 313,786 34,943.79 193,108.87- 314,767.59 75.00 RECORDS MANAGEMEN T Personnel Services 48,281 4,919.09 46,158.52- 48,230.45 - Supplies 750 - - 360.24 259.47 - Staff Support 1,500 - - 845.14 1,109.75 - Professional Services 15,000 191.00 22,772.51- 7,003.66 - Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,531 5,110.09 70,136.41- 56,603.33 - SCHERTZ TALES MAGAZINE Personnel Services 129,900 13,254.07 126,115.55- 131,413.25 - (1,513.25) Supplies 200 69.99 - - 175.83 - Opperations Support 200 - - 3,266.98 - - Staff Support 1,500 166.44 - 15.00 1,249.08 - Professional Services302,70010,683.75253,832.30286,893.88 - - TOTAL SCHERTZ TALES MAGAZINE 434,500 24,174.25 383,229.83- 419,732.04 - 14,767.96 ENGINEERING Personnel Services 124,267 7,443.49 164,107.54- 70,807.73 - 53,459.27 Supplies 1,400 708.25 - 310.22 1,083.30 116.93 Utility Services 600 135.45 - - 474.62 - Staff Support 2,013 193.04 - 1,477.12 506.99 - Professional Services 85,220 17,094.96 25,069.25- 91,322.46 - (6,102.46) Maintenance Services 4,044 - - 2,844.24 3,345.29 - Operating Equipment3,2002,923.00 -4,561.30 - - Capital Outlay26,000 23,714.00- - - - TOTAL ENGINEERING 246,744 28,498.19 193,808.37- 195,815.69 116.93 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,941 15,330.93 116,459.19- 125,472.35 - (2,531.35) Supplies3,500 194.58 - 2,274.62 1,736.15 283.95 1,479.90 Staff Support4,050 - - - - - Professional Services2,000 14.00- - - - TOTAL GIS 132,491 15,525.51 118,733.81- 127,222.50 283.95 TOTAL GENERAL GOVERNMENT 5,618,447 891,834.89 5,164,807.72- 5,606,668.36 40,769.32 PUBLIC SAFETY POLICE Personnel Services4,552,349 503,124.88 4,165,944.45- 4,506,017.26 - 46,331.74 Supplies37,944 19,940.71 - 27,242.96 46,484.35 48.39 (8,588.74) City Support Services21,734 - - - 19,518.41 - Utility Services 123,456 23,620.25 107,990.37- 120,732.77 - Operations Support 1,565 - - 762.50 1,565.00 - Staff Support 47,827 2,651.92 22,036.74- 45,126.80 - City Assistance 10,563 4,588.61 - 6,230.83 9,733.34 - Professional Services 8,692 600.00 - 7,230.16 5,530.85 - Maintenance Services 46,494 5,534.50 32,028.80- 43,700.14 - Operating Equipment 97,801 13,791.72 58,572.87- 97,711.00 - Capital Outlay142,522153,726.40142,521.25 - - - TOTAL POLICE 5,090,947573,852.59 4,581,766.08-5,038,641.1748.39 FIRE RESCUE Personnel Services 2,521,468 212,333.11 2,412,029.36- 2,468,151.63 - 53,316.37 Supplies 20,500 2,033.02 - 8,104.76 16,913.31 - Utility Services 57,000 8,481.72 50,902.85- 50,353.26 - Operations Support 800 - - 687.00 552.03 - Staff Support 120,185 1,578.47 88,085.73- 103,614.25 (0.01) City Assistance 18,600 5,725.87 20,612.31- 14,611.67 - Professional Services 18,140 - 13,040.00- 12,148.19 - Maintenance Services 56,000 4,249.94 36,997.53- 42,081.04 - 13,918.96 Operating Equipment58,30013,102.73 40,412.30 -41,368.90 -17,887.70 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,905,993 247,504.86 2,671,828.44- 2,779,953.68 126,039.33(0.01) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services423,615 45,278.66 362,767.06- 423,245.18 - Supplies 2,123 255.03 - 2,182.94 1,997.75 - City Support Services 595 594.50 - - 594.50 - Utility Services 6,500 1,077.65 - 6,005.20 5,918.62 - Operations Support 1,305 - - 1,467.87 561.00 - Staff Support 7,977 661.84 - 4,486.90 3,770.64 - Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -239.0047.61 - - TOTAL INSPECTIONS 453,115 47,867.68 377,148.97- 436,087.69 47.61 MARSHAL SERVICE Personnel Services537,373 53,093.96 464,960.89- 520,009.91 - 17,363.09 Supplies4,600 72.00 - 1,811.23 3,090.93 - Utility Services 12,000 3,083.90 11,507.13- 15,363.08 - (3,363.08) Operations Support 4,000 - - 3,889.27 1,477.84 - Staff Support 15,400 301.05 - 4,460.66 7,372.33 - Maintenance Services 30,700 588.31 10,250.85- 7,922.31 - 22,777.69 Operating Equipment16,000388.00 12,490.04 -30,365.07 - Capital Outlay34,000 31,022.0546,453.40 - - - TOTAL MARSHAL SERVICE 654,073 57,527.22 573,698.50- 598,748.49 - 55,324.51 TOTAL PUBLIC SAFETY 9,104,128 926,752.35 8,204,441.99- 8,853,431.03 95.99 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services685,341 67,475.58 564,880.90- 668,662.64 - 16,678.36 Supplies7,100 173.07 - 4,491.33 4,755.24 - Utility Services 113,900 30,753.90 115,936.30- 137,725.15 - (23,825.15) Operations Support - - 21.00 - - - Staff Support 10,265 708.60 - 7,430.14 6,960.25 - Maintenance Services 270,800 15,590.75 148,204.74- 160,556.92 - 110,243.08 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - 5,185.95 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,091,806114,701.90 859,820.36-982,146.19 - 109,659.81 TOTAL PUBLIC ENVIRONMENT 1,091,806 114,701.90 859,820.36- 982,146.19 - 109,659.81 PARKS & RECREATION PARKS DEPARTMENT Personnel Services510,269 53,142.15 469,633.41- 488,159.61 - 22,109.39 Supplies40,555 3,308.29 - 32,100.10 31,454.67 351.27 8,749.06 Utility Services113,000 24,164.89 - 150,257.93 141,703.73 - (28,703.73) Operations Support700 - - 880.80 - - Staff Support 8,573 860.55 - 7,176.21 7,892.18 - Professional Services 62,610 11,727.16 44,861.00- 63,140.15 - Maintenance Services21,000 2,980.88 - 24,000.27 17,337.65 - Rental/Leasing 43,200 6,450.80 43,178.43- 39,785.73 3,225.40 Operating Equipment - - 6,886.98 - - - Capital Outlay -190.56 - - - - TOTAL PARKS DEPARTMENT799,907102,634.72 779,165.69-789,473.723,576.67 SWIM POOL Supplies 17,700 500.69 16,263.58- 16,423.25 48.94 Utility Services 25,500 5,873.26 23,311.64- 25,809.89 - Staff Support 925 - - 166.09 750.00 - Maintenance Services 198,378 - 190,192.20- 192,793.95 - Rental/Lease500 208.20378.00 - - - TOTAL SWIM POOL 6,373.95243,003 230,311.51- 235,985.29 48.94 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET EVENT FACILITIES Personnel Services54,416 5,306.02 76,185.44- 55,839.74 - (1,423.74) Supplies28,300 1,736.24 - 25,898.36 12,933.70 82.44 15,283.86 Utility Services47,550 8,103.27 - 42,896.74 40,465.53 - Operations Support 15,158 3,916.81 13,784.31- 14,826.09 - Staff Support 3,342 895.00 - 845.30 1,996.48 - Professional Services1,600 - - 975.00 150.00 - Operating Equipment5,000 4,999.702,031.60 - - - TOTAL COMMUNITY/CIVIC CNTR155,36619,957.34 162,616.75- 131,211.24 82.44 24,072.32 TOTAL PARKS & RECREATION1,198,276 128,966.01 1,172,093.95- 1,156,670.25 3,708.05 37,897.70 CULTURAL LIBRARY Personnel Services 698,102 68,357.38 680,860.67- 693,265.79 - Supplies 14,000 1,404.23 14,913.98- 9,425.39 - Utility Services 41,000 10,748.58 55,859.04- 51,106.62 - (10,106.62) Operations Support 2,000 - - 1,526.20 1,157.00 - Staff Support 4,215 16.53 - 1,719.99 1,554.71 - Professional Services 2,100 - - 2,065.00 3,340.00 - (1,240.00) Maintenance Services 2,400 400.00 - 1,800.00 2,400.00 - Operating Equipment75,0001,257.72 65,395.1673,092.7096.07 - TOTAL LIBRARY 82,184.44838,817 - 831,837.58 827,644.67 96.07 11,076.26 TOTAL CULTURAL838,817 82,184.44 831,837.58- 827,644.67 96.07 11,076.26 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services298,212 24,471.51 294,011.98- 270,685.44 - 27,526.56 Supplies25,000 3,622.92 - 20,320.79 23,307.81 600.00 1,092.19 Utility Services11,200 1,936.82 - 11,592.46 10,976.92 - Operations Support 500 - - - - - Staff Support 12,560 729.86 - 2,002.73 8,642.58 46.39 City Assistance 10,000 2,369.86 11,953.61- 10,958.17 - Professional Services 13,500 3,176.55 12,017.00- 12,482.30 240.00 Maintenance Services 6,200 240.00 - 3,890.83 4,625.15 - Operating Equipment9,500 4,639.149,507.24 - - - TOTAL ANIMAL SERVICES386,67236,547.52 365,296.64-346,317.51886.39 TOTAL HEALTH 386,672 36,547.52 365,296.64- 346,317.51 886.39 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 261,756 28,995.66 264,162.98- 285,642.31 - (23,886.31) Supplies2,000 (18.47) - 1,090.52 318.24 - City Support Services 360,854 35,539.31 430,295.66- 276,233.90123,140.00 Utility Services 164,949 34,706.64 142,264.52- 172,111.60 6,846.33 Staff Support 16,750 2,114.36 11,002.73- 16,537.12 599.20 Professional Services 2,500 - - - - - Maintenance Services 12,500 75.00 15,082.52- 9,464.36 2,850.00 Operating Equipment 129,315 25,620.69 166,861.57- 131,050.36 4,775.46 Capital Outlay38,50027,152.45 27,152.45-8,639.37 - TOTAL INFORMATION TECHNOLOGY 154,185.64989,124 1,030,760.50- 918,510.34146,850.36 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services298,343 29,899.03 210,088.95- 270,981.45 - 27,361.55 Supplies2,329 922.02 - 768.52 1,827.54 - Human Services 45,031 5,647.12 34,682.27- 40,511.97 - Operations Support 11,346 1,335.00 10,888.61- 7,773.25 - Staff Support 13,397 789.31 - 7,363.56 10,033.71 385.34 City Assistance 9,860 2,694.00 - 8,922.00 8,716.50 - Operating Equipment7,5751,588.14 6,289.27- - - TOTAL HUMAN RESOURCES 42,874.62387,881 272,713.91- 346,133.69 385.34 FINANCE Personnel Services432,396 48,123.27 416,663.72- 436,913.35 - (4,517.35) Supplies3,600 185.07 - 3,231.18 2,997.95 - Operations Support 850 - - 475.93 197.50 - Staff Support 15,805 650.00 10,197.39- 6,983.52 - Rental/Leasing 2,230 - - - 502.32 - Operating Equipment1,000 266.471,077.80 - - - TOTAL FINANCE 455,881 48,958.34 431,646.02- 447,861.11 - PURCHASING & ASSET MG T Personnel Services 243,664 26,544.58 233,936.98- 245,562.36 - (1,898.36) Supplies1,103 5,673.90 - 15,144.29 6,456.73 - (5,353.73) Utility Services650 - - 410.03 419.85 - Operations Support 909 (0.47) - 60.68 5.20 - Staff Support 9,097 420.00 - 6,029.30 4,524.15 - Operating Equipment7,591 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 263,014 32,638.01 255,581.28- 264,559.11 - (1,545.11) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services218,758 (4,913.08) 168,750.64- 186,524.62 - 32,233.38 Supplies150,576 (4,498.48) - 119,512.45 130,444.10 267.90 19,864.00 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 512.17 - 5,223.32 3,709.92 - Operations Support 25 - - 750.00 - - Staff Support 3,835 199.36 - 2,139.73 2,894.91 - Maintenance Services 70,079 19,659.40 54,764.30- 69,411.00 - Rental/Lease270 185.00269.80 - - - Operating Equipment5,000 4,113.894,931.79 - - - Capital Outlay -25,869.00 - - - - TOTAL FLEET SERVICE457,24310,959.37 382,808.33-399,686.14267.90 TOTAL INTERNAL SERVICE 2,553,143 289,615.98 2,373,510.04- 2,376,750.39147,503.60 MISC & PROJECTS CITY ASSISTANCE - - 492.52 281.17 Utility Services - - Patient Assistance 5,000 2,500.00 - 5,000.00 5,000.00 - Children's Advocacy Assistance 5,000 5,000.00 - 5,000.00 5,000.00 - Senior Citizen's Hot Meals42,000 42,000.0042,000.00 - - - TOTAL CITY ASSISTANCE52,0007,500.00 52,492.52-52,281.17 - COURT - RESTRICTED FUNDS Operating Equipment 15,019.0011,697.403,340.00 - - - TOTAL CITY ASSISTANCE - 11,697.40- 15,019.00 3,340.00 - TOTAL MISC & PROJECTS 52,000 7,500 - 64,190 67,300 3,340 TOTAL EXPENDITURES20,843,2892,478,103.09 19,035,998.20-20,216,928.57196,399.42 REVENUE OVER(UNDER) EXPEND.25,176656,095.41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 (2,941.23) 6,759,077.51- 6,887,503.10 - (3,049.10) 000-411200Advalorem Tax - Delinquent 50,000 1,247.32 47,639.71- 51,218.71 - (1,218.71) 000-411300Advalorem Tax - P&I 50,000 (6,387.11) 45,891.31- 36,174.06 - 13,825.94 000-411400Roll Back Property Tax 9,855.84 - - 9,855.84 - (9,855.84) 000-411500Sales Tax Revenue-Gen Fund4,784,071 575,283.91 4,702,216.53- 5,309,018.16 - (524,947.16) 000-411600Bingo Tax 2,200 - - 2,172.67 - - 000-411700Mixed Beverage Ta33,000.0033,629.9628,586.29 x - - - TOTAL Taxes11,803,725 577,058.73 11,590,627.69-12,322,356.16 (518,631.16) Franchises 000-421200Center Point/Entex Energy36,0003,797.52 39,306.12-52,073.49 - (16,073.49) 000-421220City Public Service 330,000 44,493.98 318,212.07- 366,987.06 - (36,987.06) 000-421240Guadalupe Valley Elec Co-op 440,000 32,108.07 417,556.53- 405,517.17 - 34,482.83 000-421250New Braunfels Utilities 55,000 6,135.56 28,642.73- 55,203.48 - 000-421300Time Warner-State Franchise 345,000 25,238.50 325,958.46- 329,900.47 - 15,099.53 000-421350Time Warner-PEG Fee - 49,140.88- - - - 000-421460AT&T Franchise Fee 185,000 20,777.91 173,534.63- 198,647.25 - (13,647.25) 000-421465AT&T PEG Fees 18,261.07- - - (7,765.29) - 000-421480Other Telecom Franchise 35,000 77.08 41,320.67- 55,721.08 - (20,721.08) 000-421500Solid Waste Franchise Fee100,0009,014.9299,374.35102,985.04 - - TOTAL Franchises 1,526,000 133,878.25 1,511,307.51- 1,567,035.04 - (41,035.04) Permits 000-431100Home Occupation Permit50070.00-280.00350.00 - 000-431200Building Permit - 1,255,381.83- 26.00 - - 000-431205Building Permit - Residential 600,000 52,423.00 - 418,487.00- - 181,513.00 000-431210Building Permit - Commercial 300,000 - - 203,101.00- - 96,899.00 000-431215Building Permit - General - 112,395.00- - 9,117.00 - (112,395.00) 000-431300Mobile Home Permit 200 - - 80.00 250.00 - 000-431400Signs Permit 1,700 369.00 - 900.00 2,934.00 - (1,234.00) 000-431500Food Establishmnt Permit 30,000 22,050.00 38,845.00- 42,875.00 - (12,875.00) 000-431600Garage Sale Permit 8,600 1,035.00 11,735.00- 11,680.00 - (3,080.00) 000-431700Plumbing Permit 80,000 9,875.09 113,743.25- 113,237.34 - (33,237.34) 000-431750Electrical Permit 55,000 4,800.00 68,860.00- 47,710.50 - 000-431800Mechanical Permit 59,000 4,720.00 82,600.00- 54,600.00 - 000-431900Solicitor/Peddler Permit 60.00 - 3,000.00 1,640.00 - - 000-431950Animal/Pet Permit 2,000 - - 1,630.00 2,175.00 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800350.00 7,300.00- 7,300.00 - (3,500.00) 000-432100Security Alarm Permit42,000 4,739.68 - 45,733.20 48,747.18 - (6,747.18) 000-435000Fire Permit5,000675.00 8,325.008,812.50 - - TOTAL Permits 110,283.771,187,800 - 1,638,900.78 1,075,833.02 - 111,966.98 Licenses 000-441000Alcohol Beverage License 6,300 465.00 - 5,555.00 5,497.50 - 000-441300Mobile Home License - - - 80.00 - - 000-442000Contractors License 39,000 3,970.00 52,095.00- 60,410.00 - (21,410.00) 000-444000Pet License3,000180.00 4,480.004,363.10 - - TOTAL Licenses 48,300 4,615.00 62,013.10- 70,467.50 - (22,167.50) Fees 000-451000Municipal Court Fines 1,665,009 113,899.25 1,048,404.09- 1,479,052.50 - 185,956.50 000-451100Arrest Fee 50,694 5,691.78 44,713.61- 63,266.74 - (12,572.74) 000-451110Expunction Fee 90 - - 30.00 30.00 - 000-451200Warrant Fees 192,000 11,609.70 129,281.17- 141,399.79 - 50,600.21 000-451210Court - Claims & Judgements (200.17) - - 1,642.43 - - (1,642.43) 000-451320Civil Justice Fee-Court 75 9.34 66.90 99.78 - 000-451321Civil Justice Fee-State 83.63 - 602.57 900.23 - - 000-451340Judicial Fee - City 6,826 747.54 - 5,995.46 8,299.88 - (1,473.88) 000-451400Traffic Fine Costs TTL 25,984 2,998.05 22,536.17- 32,623.27 - (6,639.27) 000-451500Teen Court Admin Fee 260 20.00 - 300.00 440.00 - 000-451510Juvenile Case Mgmt Fee 55,896 6,244.63 49,991.46- 69,234.94 - (13,338.94) 000-451600Technology Fund Fee 45,601 5,069.77 40,384.23- 55,633.85 - (10,032.85) 000-451700Security Fee 34,220 3,802.33 30,297.17- 41,725.43 - (7,505.43) 000-451800Time Payment Fee - City 7,336 419.49 - 5,700.69 5,389.25 - 000-451850State Fines 10% Service Fee 72,470 - 63,806.36- 68,804.90 - 000-451900DPS Payment - Local 11,858 918.00 10,499.63- 11,135.07 - 000-452000Child Safety Fee 12,243 1,258.54 11,207.20- 24,951.32 - (12,708.32) 000-452050Indigent Defense Fee 21,655 2,452.09 19,368.75- 26,957.49 - (5,302.49) 000-452100Platting Fees 98,000 8,500.00 61,500.00- 65,500.00 - 32,500.00 000-452200Site Plan Fee 74,000 4,500.00 30,000.00- 24,000.00 - 50,000.00 000-452300Plan Check Fee 465,000 61,514.00 611,382.41- 349,668.50 - 115,331.50 000-452310Miscellaneous Review Fee 13,500 - - 9,000.00 6,000.02 - 000-452320Tree Mitigation Admin Fee 10,500 - - 7,680.00 12,200.25 - (1,700.25) 000-452400BOA/Zoning Fees 4,000 - - 1,750.00 3,250.00 - 000-452500Food Handler Class 7,000 4,140.00 - 7,240.00 17,150.00 - (10,150.00) C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452520Fire Training Classes400---- - 000-452600Specific Use/Zone Chng Fee 20,000 - 21,150.00- 30,500.00 - (10,500.00) 000-452710Zoning Ltr & Dev Rights 1,500 150.00 - 600.00 1,950.00 - 000-453100Reinspection Fees 30,000 4,225.00 40,580.00- 40,200.00 - (10,200.00) 000-453110Swim Pool Inspection Fee - - 1,050.00 1,500.00 - - (1,500.00) 000-453200Lot Abatement 12,000 250.00 12,111.26- 2,798.43 - 000-453211Admin Fee-Inspections 7,480 1,000.00 - 7,900.00 8,940.00 - (1,460.00) 000-453310Misc Inspection Fee 200.00 - 270.00 269.49 - - 000-453710Foster Care 500 50.00 - 850.00 700.00 - 000-454100Swim Pool Reservation Fee - - 55.00 - - 000-454200Pool Gate Admission Fee 25,000 - 22,720.35- 23,949.31 - 000-454300Seasonal Pool Pass Fee 5,500 - - 7,046.00 5,034.50 - 000-456500Haz Mat Fees 800 - - - 6,984.73 - (6,184.73) 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 50.00 - 900.00 700.00 - 000-458100Sale of Merchandise - - 17.00 36.50 - - 000-458300Sale of Property/Auction 22,000 289.79 28,599.30- 20,740.93 - 000-458400Civic Center Rental Fees 171,000 4,486.38 153,558.89- 110,063.63 - 60,936.37 000-458401Capital Recovery Fee-Civic Cntr 7,500 585.00 - 2,266.00 5,225.00 - 000-458450North Center Rental Fees 15,000 134.41 12,815.29- 22,093.33 - (7,093.33) 000-458500Community Center Rental Fees 18,000 536.00 21,937.98- 26,481.22 - (8,481.22) 000-458550Pavilion Rental Fees 18,500 870.00 19,292.70- 17,577.00 - 000-458560Chamber of Comm rent 11,700 - - 7,800.00 7,800.00 - 000-458570Non-Resident SYSA League 12,000 (1,995.00) - 7,060.00 16,030.00 - (4,030.00) 000-458600Ball Field Use - - 1.76 - - - 000-458650NonResident User Fee-BVYA 11,000 - -9,090.008,860.00 - 000-458660BVYA Utility Reimbursement - - 9,517.56 - 4,339.32 - (9,517.56) 000-458670SYSA Utility Reimbursement - - - 6,578.61 - - (6,578.61) 000-458680Tournament Fees-Soccer 15,000 - - 2,400.00 7,625.00 - 000-458700Vehicle Impoundment 5,000 - - - 1,380.00 - 000-459200NSF Check Fee 250 110.50 - 328.00 649.50 - 000-459300Notary Fee 300 12.00 - 369.00 372.00 - 000-459400Maps, Copies, UDC, & Misc F 400 - - 618.18 78.10 - 000-459600Animal Adoption Fee 15,000 746.50 11,832.00- 12,609.00 - 000-459700Pet Impoundment Fee 15,000 1,368.00 19,618.01- 16,882.25 - (1,882.25) 000-459800Police Reports Fee6,500426.00 6,206.305,976.20 - - TOTAL Fees 251,511.873,324,727 - 2,630,495.79 2,929,743.03 - 394,983.97 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,596.0326,078.8128,543.30 - - TOTAL Fines30,0002,596.03 26,078.81-28,543.30 - Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 1,756.48 21,077.76- 21,077.76 - 000-473200City of Seguin - Fire Contract 40,263 3,355.26 40,263.12- 40,263.12 - 000-473300Guad Co - Library 180,000 15,901.33 195,884.00- 174,914.63 - 000-473400Randolph AFB-Animal Cntrl 1,000 - - 2,300.00 600.00 - 000-474200Library Services - Cibolo 20,000 - - 20,000.00- - 000-474210Library Services-Selma 19,000 - - 18,392.80- - 000-474400Dispatch Service - Cibolo 133,305 - 133,305.00- 133,305.00 - 000-474600School Crossing Guard-Bexar6,6003,442.4035,826.07 -14,207.84 -(29,226.07) 000-474610School Cross Guard-Guadalupe36,302.93 -3,531.95 -23,668.17 -(36,302.93) 000-474700School Officer Funding150,00062,500.0025,000.00150,000.00 - - TOTAL Inter-Jurisdictional571,24590,487.42 455,705.89-630,682.31 - (59,437.31) Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 87,840.00- 87,840.00 - 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 170,221.00- 142,626.00 - 000-481000Transfer From Reserves 180,000 - - - - - 180,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 - 38,887.75- 35,480.00 - 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 624,776.95- 881,222.04 - 000-486106Transfer in-Special Events - - - 1,000.00 - - (1,000.00) 000-486000Transfer In-W&S - 25,869.00- - - - 000-486317Transfer From Park Fund 13,000 - - - 5,819.26 - 000-486322Transfer-In - Library Grants - 13,028.67 6,293.53 - - (6,293.53) 000-486402Transfer from City Wide Projects - 25,372.05- - - - 000-487000Interfund Charges-Fleet 98,484 8,207.00 89,304.95- 98,484.00 - 000-488000Interfund Charges-4B 53,0004,416.67 55,431.97-53,000.04 - 000-489000Transfer In - 13,146.26- - - - 000-490020Transfer In-SEDC50,00050,000.0050,000.0050,000.00 - - TOTAL Fund Transfers 1,585,658 155,264.34 1,193,878.60- 1,361,764.87 - 223,893.13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 17.46 - 1,686.53 332.84 - 000-491200Investment Income 30,000 3,537.68 35,761.09- 47,914.66 - (17,914.66) 000-491800Gain/Loss - (9,810.33)- - (3,753.00) - 000-491900Unrealized Gain/Loss (20,468.45)- (19,284.88) - 1,159.39 - 19,284.88 000-492100Proceeds-Sale of Land - - 194,467.85- - - (194,467.85) 000-493000Donations-Others - - 340.00 - - - 000-493130Donations-Writing the Next Chap. 50.00 25,339.00- 5,331.34 - - (5,331.34) 000-493400Donation - Animal Control 1,200 90.96 - 5,324.21 4,473.09 - (3,273.09) 000-493401Donations-A/C Microchip 500 145.00 - 2,210.00 1,990.00 - (1,490.00) 000-493402Donations-Spay&Neuter 13,500 1,085.00 15,373.58- 14,875.50 - (1,375.50) 000-493503Donations - Fire Rescue - - 25.00 - - - 000-494481LawEnforcemtOfficersStnd&Ed - - 3,550.22 50.00 - - 000-494482Grants - Police 175,510 175,510.50 - 3,542.76 175,510.50 - 000-495040Friends of N. Schertz Park 75.00 - - 3,149.00 - - (3,149.00) 000-495100Mobile Stage Rental Fees - - - 2,850.00 - - (2,850.00) 000-497000Misc Income-Gen Fund 81,000 85,764.72 50,637.58- 72,780.16 (17.90) 000-497005Misc Income-Publications 290,000 19,291.00 152,832.25- 215,999.00 - 74,001.00 000-497007Misc Income-Schertz Artz - - - 2.00 - - 000-497100Misc Income-Police 25,000 281.00 23,366.19- 18,666.78 - 000-497150Misc Income-Fire Department 292.37 - - 292.37 - - 000-497200Misc Income-Library 19,000 305.25 (11,570.15)- 3,856.94 - 15,143.06 000-497210Misc Income-Library Copier 13,500 1,141.40 11,877.80 13,433.81 - 000-497300Misc Income-Animal Control 500 5.00 - 1,506.37 110.00 - 000-497400Misc Income-Streets Dept. 20,000 1,529.82 20,178.12- 18,280.33 - 000-497500Misc Income-TML Insurance 78,000 2,262.91 49,728.90- 14,333.37 - 63,666.63 000-497550Misc Income-TML Reimbursemt20,000 2,265.81 29,053.61-18,978.28 - 000-497600Misc Income-Parks/Vending Mach.2,500 174.46 - 2,263.29 1,755.13 - 000-498000Reimbursmnt-Gen Fund5,000500.0031,210.92 -10,434.53 -(26,210.92) 000-498100Reimbursmnt Fire - Training 800 - - 1,101.00 - - 000-498105Reimburmnt Police - DEA - 9,036.60 8,059.69 - 2,442.33 - (8,059.69) 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 - 30,936.01- 46,990.40 - (34,990.40) 000-498500Settlement - Litigation25,000.00- - - - - TOTAL Miscellaneous 791,010 -294,174.06 479,066.04 886,598.75 (17.90) (95,570.85) TOTAL REVENUES20,868,465 1,619,869.47 - 19,588,074.21 20,873,023.98 (17.90) (4,541.08) GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking407,803.16$ Cash in Investments LOGIC Investment-General Fund 862,606.24 LOGIC Investment-Equip Replacement 73,470.23 LOGIC Investment-Veh Replacement 102,496.45 LOGIC Investment-Air Condi Replacment 146,689.42 CAPITAL ONE Investment-General Fund1,341,456.41 Total Cash in Bank & Investments$3,081,103.75 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127.12 6,914.61 2011-12 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 2010-11 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792) 59,545 34,762 19,836 29,955 5,346 3,535 2009-10 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 25,468 13,593 21,472 2008-09 993,926 1,293,621 615,170 1,462,883 310,479 74,418 17,900 44,799 19,066 24,241 6,294 10,447 2007-08 Sales Tax - General Fund $700,000 $600,000 26% -2% $500,000 40% 19% 25% -3% 17% 12% 23% -2% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 415,822 461,400 365,083 347,395 535,930 398,080 408,851 575,414 440,250 2011-12 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2010-11 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 2009-10 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 2008-09 336,749 350,854 312,547 327,798 421,873 330,131 287,316 355,054 336,094 328,147 360,965 338,085 2007-08 278,463 305,857 266,440 281,920 358,831 236,723 250,774 319,604 300,214 306,696 382,743 298,203 2006-07 CITY PUBLIC SERVICE $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 96,392 76,414 77,398 103,230 2011-12 83,433 62,692 67,561 95,887 2010-11 77,354 61,468 63,276 80,716 2009-10 77,308 53,071 57,506 83,329 2008-09 55,729 50,340 48,120 86,572 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 62,100.00 (14,000.00) - 37,250.00- - 24,850.00 Wilenchik Walk for Life 28,000.00 30,461.91- 26,451.06 - - 1,548.94 TML Dinner - - 194.69 - - - (194.69) Hal Balwin Scholarship 24,000.00 23,685.00- 19,227.00 - - 4,773.00 Miscellaneous175.002,908.76-2,176.681,417.33 - TOTAL REVENUES114,275.00 (11,091.24) - 56,323.59 84,540.08 - 29,734.92 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.002,385.00-3,230.202,385.00 - TOTAL GENERAL GOVERNMENT5,150.00 2,385.00 - 3,230.20 2,385.00 - 2,765.00 CULTURAL Other Events 4,750.00 - 200.00 10,340.89 - - (5,590.89) Festival of Angels 14,250.00 950.00 12,654.23- 14,000.46 - 249.54 Employee Appreciation Event 5,000.00 - 1,104.84 - - - 5,000.00 4th of July Jubilee - 693.74 218.05 - - - (218.05) National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 30,461.91- 26,451.06 - - 5,048.94 Schertz Fest - 1,855.91 - - - - TML Events - - 194.69 - - - (194.69) Schertz Sweetheart 37,000.00 5,085.02 44,385.85- 27,075.06 - 9,924.94 Hal Baldwin Scholarship11,000.00-10,354.114,767.40 - -6,232.60 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 6,035.02103,600.00 - 102,110.59 83,047.61 -20,552.39 TOTAL EXPENDITURES108,750.00 8,420.02 - 105,340.79 85,432.61 - 23,317.39 REVENUE OVER(UNDER) EXPEND5,525.00(892.53) SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking46,173.69$ Cash in Investments MBIA Special Events46,692.07 Total Cash in Bank & Investments$92,865.76 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises 91,000.00 -7,765.29 23,287.45 92,518.90 - (1,518.90) Fund Transfers175,000.00 - 294,165.96- - -175,000.00 - 19.341.21 Miscellaneous - - - TOTAL REVENUES266,000.00 7,765.29 - 317,454.62 92,538.24 - 173,461.76 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental175,000.00 -- 123.19- - TOTAL GENERAL GOVERNMENT175,000.00 - - - 123.19 - 174,876.81 TOTAL EXPENDITURES175,000.00 - - - 123.19 - 174,876.81 REVENUE OVER(UNDER) EXPEND91,000.00 92,415.05 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Franchises 000-421350Time Warner - PEG Fee 16,039.50- 62,966.10 65,000 - -2,033.90 000-421465T&T PEG Fee 29,552.807,247.95 A 26,000 7,765.29 - - TOTAL Franchises 7,765 23,287.45- 92,518.90 91,000 -(1,518.90) Fund Transfers 000-481000Transfer In - Reserves--- 175,000 - -175,000.00 000-489000Transfer In294,165.96- - - - - TOTAL Fund Transfers 294,165.96- - 175,000 - -175,000.00 Miscellaneous 000-491000Interest Earned - 1.21 19.34 - - -(19.34) 000-491200Investment Income -- - - - - TOTAL Miscellaneous - 1.21 19.34 - - -(19.34) TOTAL REVENUES7,765-317,45592,538 266,000 -173,461.76 PEG FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Cash Balance386,698.56$ Total Cash in Bank & Investments$386,698.56 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,000(29,444.76) 229,294.53-184,016.40 (4,016.40)- Fees14,164,250 1,092,448.30 - 14,682,744.32 14,873,696.43 - (709,446.43) Fund Transfers634,674 35,386.18 - 80,616.00 113,004.05 - 521,669.95 (33,971.13)342,666.40401,863.51 Miscellaneous 103,260 - - TOTAL REVENUES15,082,1841,064,418.5915,335,321.2515,572,580.39 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers58,365.47- 27,366 - - - TOTAL NON DEPARTMENTAL- 27,366 - -58,365.47 -27,366.00 BUSINESS OFFICE Personnel Services386,33052,158.63 406,553.98-368,984.87 17,345.13- Supplies5,400970.37-3,509.064,754.1250.00 Human Services100---40.00- Operations Support106,0007,993.13 96,648.88-96,538.49- Staff Support6,705116.88-2,828.613,892.5643.30 Professional Services24,3952,436.63 18,196.63-23,383.49- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,3001,260.00-6,207.957,060.00- Operating Equipmen6,117.625,932.94 t 6,200 - - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE64,935.64510,586.4793.30 606,430 -540,062.73 W & S ADMINISTRATION Personnel Services1,191,35293,030.98 1,177,186.94-1,021,524.69 169,827.31- Supplies200,35912,079.15 147,210.62-135,448.2169.70 Human Services1,000380.00-64.00596.00- City Support Services65,1091,010.00 48,484.80-35,389.595,585.00 Utility Services2,571,844347,459.20 2,820,914.26-3,421,395.04 (849,551.04)- Operations Support8,750512.02-6,125.256,746.04- Staff Support33,0002,048.36 21,438.44-19,759.05 13,240.95- City Assistance1,912231.00-789.00769.00- Professional Services208,14048,069.98 219,877.99-249,432.20130.00 Fund Charges/Transfers2,657,0072,179,145.50 3,785,002.73-4,580,949.12 (1,923,942.12)- Maintenance Services5,563,827821,920.13 5,278,707.59-5,786,835.63 (223,008.63)- Other Costs35,000- 29,831.85-30,956.44- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353(117,273.82) 176,579.35-167,958.87 1,062,394.13- Rental-Leasing6,070254.24-2,508.533,215.95- Operating Equipment20,6962,412.50 25,182.70-20,107.19- Capital Outla(99,948.00)-- y 103,328 - -103,328.00 -- - - - Water Line Relocation - TOTAL PUBLIC WORKS13,897,7473,291,331.24 15,481,083.025,784.70 -13,739,904.05 MISC & PROJECTS PROJECTS City Support Services29,000---- 29,000.00- Operations Support1,000----- Professional Services45,290---- 45,290.00- Maintenance Services -- 312,750 - - - TOTAL PROJECTS-- 388,040 - - -388,040.00 AVIATION HEIGHTS WTR IMPROVEMNTS Operations Support------ Professional Services25,210---- 25,210.00- Maintenance Services -- 136,750 - - - -- TOTAL AVIATION HEIGHTS WTR IMP 161,960 - - -161,960.00 TOTAL MISC & PROJECTS-- 550,000 - - -550,000.00 TOTAL EXPENDITURES15,081,5433,356,26714,338,33215,991,6695,878 - ** REVENUE OVER(UNDER)EXPENSES **(419,089.10) 641 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises (29,444.76)229,294.53184,016.40 000-421490Tower Leasing180,000 - - TOTAL Franchises 180,000 (29,444.76) 229,294.53- 184,016.40 - (4,016.40) Fees 000-455200Garbage Collection Fee 3,400,000 251,393.63 3,279,901.31- 3,427,008.45 - (27,008.45) 000-455600Fire Line Fees 19,000 724.42 24,370.69- 20,414.42 - (1,414.42) 000-455700Recycle Fee Revenue 241,000 14,851.07 225,058.13- 244,053.82 - (3,053.82) 000-455800W&S Line Constructn Reimbursemnt50,000 2,166.00 30,089.60- 24,500.44 - 25,499.56 000-457100Sale of Water 7,210,000 597,944.96 7,816,709.86- 7,657,695.38 - (447,695.38) 000-457110Edwards Water Lease 166,250 - 199,612.50- 204,398.59 - (38,148.59) 000-457120Water Transfer Charge-Selma 5,000 - - 2,668.48 25,343.55 - (20,343.55) 000-457130Water Transfer Charge-U. C. 1,000 - - 1.28 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 8,184.58 69,147.00- 60,849.16 - 29,150.84 000-457400Sewer Charges 2,800,000 199,957.42 2,855,310.39- 3,023,567.38 - (223,567.38) 000-457500Water Penalties 180,000 16,886.22 177,199.29- 180,795.27 - 000-459200NSF Check Fee-Water&Sewer2,000340.002,675.792,870.00 - - TOTAL Fees14,164,2501,092,448.30 14,682,744.32-14,873,696.43 (709,446.43) Fund Transfers 000-481000Transfer In- Reserve550,000---- - 550,000.00 000-486100Transfer In - 28,330.01- -28,330.01 - (28,330.01) 7,056.1780,616.00 84,674.04 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 634,674 35,386.18 80,616.00- 113,004.05 - 521,669.95 Miscellaneous 000-490000Misc Charges 10,000 55.00 - 6,964.02 779.62 - 000-491000Interest Earned 1,000 142.35 - 1,509.02 1,868.29 - 000-491200Investment Income 6,000 3,661.19 17,816.77 13,470.29 - (7,470.29) 000-493400Donations-Christmas Activities - - 1,000.00 750.00 - - 000-495013Capital Contribution - W&S (26,428.00)- (35,862.14) -(35,862.14) - 35,862.14 000-496050SSLG - SAWS Reservation - 134,500.00- 269,000.00 - - (269,000.00) 000-497000Misc Income-W&S 60,593.44- 47,833.43 -(1,967.53) - (47,833.43) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 - 102,014.05- 104,024.02 - (27,709.02) 000-498200W&S Project Reimbursement42,405.76 - - - - - TOTAL Miscellaneous 103,260 (33,971.13) 342,666.40- 401,863.51 - (298,603.51) TOTAL REVENUES15,082,1841,064,418.59 15,335,321.25- 15,572,580.39 (490,396.39) WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking376,654.18$ Cash in Investments Lone Star Investment-Water&Sewer 924,369.37 Lone Star Investment-W&S Customer Deposits294,351.02 Lone Star Investment-W&S Equip Replacement373,939.94 Lone Star Investment-W&S Veh Replacement 545,249.14 Lone Star Investment-Water/SSLGC SAWS 404,397.85 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $3,598,215.94 Total Cash in Bank & Investments3,974,870.12$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 378,595.58 3,300,613.84- 3,521,402.69 567,530.31- Inter-Jurisdictional1,438,836 23,843.88 1,407,551.28- 1,445,353.58 (6,517.58)- Miscellaneous1,616.52-109,892.33110,881.85 256,000 - TOTAL REVENUES 404,055.98 - 4,818,057.45 5,077,638.12 - 706,130.88 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,600,871293,067.53 2,661,936.86-2,699,802.64 (98,931.64)- Supplies 16,378.43 272,857.36- 285,174.99 10,085.16 327,239 Human Services - 654.00 230.00 800 - - City Support Services 14,214.12- 10,277.40 17,525 - - 7,247.60 Utility Services 27,856.90 119,305.77- 131,839.35 (19,354.35)15.00 112,500 Operations Support 3,929.49 47,310.79- 48,482.65 52,600 - 4,117.35 Staff Support 2,146.18 61,675.13- 61,686.36 8,214.61 72,400 City Assistance 2,024.00 12,830.80- 11,751.28 9,000 - (2,751.28) Professional Services 11,387.44 115,071.38- 122,075.35 2,445.06 152,140 Fund Charges/Transfers2,084,785 869,232.59 1,420,804.76- 1,668,784.10 416,000.90- Maintenance Services 1,602.15 20,934.04- 39,633.52 39,560 - Debt Service 1,234.50 18,175.05- 12,465.50 111,176 - 98,710.50 Rental-Leasing - - - 20,000 - - Operating Equipment 1,433.35 39,076.07- 43,008.12108,529.00 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 1,230,292.56 - 4,804,846.13 5,135,211.26 129,288.83 449,095.91 5,713,596 TOTAL EXPENDITURE1,230,292.56-4,804,846.135,135,211.26129,288.83 S 5,713,596 ** REVENUE OVER(UNDER) EXPENSES (57,573.14) * 70,173 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 369,685.58 - 3,213,198.84 3,431,478.49 - 387,254.51 89.86% 000-456110Subscription Program Fees55,000 140.00 - 18,845.00 18,300.00 33.27% - 36,700.00 000-456120EMT Class - Fees95,200 8,770.00 - 68,570.00 68,001.00 - 27,199.00 000-459200Paramedic Class Fees 120,000 - - - - 000-456130Immunization Fees 3,623.20- - - - - TOTAL Fees4,088,933378,595.58 3,300,613.84- 3,521,402.69 567,530.31- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.88 - 286,126.44 286,126.56 100.00% - 000-474300Cibolo Support 222,018 213,300.00- 222,099.92 100.04% - - 000-475100Comal Co ESD #6 82,875 75,840.00- 75,997.10 - - 6,877.90 000-475200Live Oak Support 148,125 148,125.00- 160,329.52 - - (12,204.52) 000-475300Universal City Support 226,168 204,412.52- 227,101.32 - - 000-475400Selma Support 67,618 68,730.00- 67,643.40 100.04% - - 000-475500Schertz Support 384,046 387,459.48- 384,187.64 - - 000-475600Santa Clara Support 8,849 10,534.68- 8,852.24 100.04% - - 000-475800Marion Support13,01113,023.1613,015.88 - - - TOTAL Inter-Jurisdictional1,438,836 23,843.88 1,407,551.28- 1,445,353.58 (6,517.58)- Fund Transfers 000-486100Transfer In 29,930.14- - 29,930.14 - - TOTAL Fund Transfers - 29,930.14- -29,930.14 - (29,930.14) Miscellaneous 000-491200Investment Income 56.74 - 554.62 667.01 - - 000-493203Donations-EMS 6,000 11,750.00- 1,095.00 - - 4,905.00 000-493204Donations-Dilworth Fund - 1,000.00 - 0.00% - - - 000-493205Donations- Golf Tournament - 4,430.00 15,550.00 - - - (15,550.00) 000-497000Misc Income 150,000 1,159.43 80,735.30- 87,390.51 - 62,609.49 000-497100Recovery of Bad Debt100,000400.3511,422.416,179.33 - - TOTAL Miscellaneous 256,000 1,616.52 109,892.33- 110,881.85 - 145,118.15 TOTAL REVENUES5,783,769433,986.12 4,818,057.45- 5,107,568.26 676,200.74- SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank $ (359,306.03) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,414.74 $(57,891.29) Total Cash in Bank & Investments C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60051,263.08 714,443.31- 734,529.73 -(24,929.73) Fund Transfers - 23,297 4,034 -4,034 -(4,034) Miscellaneous900(21,437.40)1,572.71 87.55 - - TOTAL REVENUES 55,385.11710,500716,302.56 -740,136.92(29,636.92) - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 375,64636,648.85 345,713.93- 324,669.91 -50,976.09 Supplies 8,300 (309.47) - 3,971.09 4,551.78 -3,748.22 Human Services 325 12.00 - - 184.00 -141.00 City Support Services 20,861 - 5,832.18 1,508.72 - -19,352.28 Utility Services 24,188 2,802.04 19,875.23- 21,375.47 -2,812.53 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 266.88 - 5,208.20 3,705.12 750.00 City Assistance 132.00840 - 15.00 378.00 -462.00 Professional Services 20,698 5,800.00 16,699.53- 20,759.25 100.30% -(61.25) Fund Charges/Transfers 199,87637,606.60 172,474.95- 164,382.97 -35,493.03 Maintenance Services 22,000 - 2,030.67 42.12 - -21,957.88 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 17,564 (95.57) - 3,741.98 3,168.57 - Rental/Leasing 562 - - 561.29 99.87% - - Operating Equipment-- - - - - - TOTAL DRAINAGE 82,863.33701,725575,662.76 750.00545,387.20155,587.80 - TOTAL EXPENDITURE 82,863.33701,725575,662.76 750.00545,387.20155,587.80 S - ** REVENUE OVER(UNDER) EXPEND8,775194,749.72 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 4,360.85 5,169.63 4,000 4 57.26 - (1,169.63) 000-457600Drainage Fee 50,805.82-710,082.46 -729,360.10(23,760.10) 705,600 TOTAL Fees51,263.08 714,443.31-734,529.73 (24,929.73)- 709,600 Fund Transfers 000-486100Transfer In 10,496.27- 4,034.48 - 4 ,034.48 - (4,034.48) 000-486202Transfer In-Water-12,800.38 - - - - - TOTAL Fees 23,296.65-4,034.48 - 4 ,034.48 - (4,034.48) Miscellaneous 000-491000Interest Earned - 243.70 90.99 90.99% 100 8 .20 - 000-491200Investment Interest - 625.20 810.83 600 7 4.73 - (210.83) 000-495013Capital Contributions (22,492.00)- - - - - -0.00% 000-497000Misc Income-Drainage-185.70670.89 200 4.62 - TOTAL Miscellaneous (21,437.40)- 1,572.71 900 8 7.55 - (672.71) TOTAL REVENUES55,385.11 716,302.56- 740,136.92 (29,636.92)- 710,500 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 186,854.22 Cash in Investments Lone Star Investment-Drainage Maint Fund383,891.47 Total Cash in Bank & Investments$570,745.69 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 89,283.28 391,181.21- 470,290.28 -(79,536.28) Fund Transfers 20,132 - - - - -20,132 Miscellaneous50057.41-985.15419.54 - TOTAL REVENUES 89,340.69411,386-392,166.36470,709.82 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - 3,305.52 1,826.50 - -673.50 City Support Services 85,948 3,690.07 79,630.85- 65,318.07 -20,629.93 Operations Support 24,414.4656,425 65,368.37- 45,428.77 -10,996.23 Professional Services 2,500 - 2,500.00 2,500.00 - - -100.00% Fund Charges/Transfers 193,876 17,885.50 190,221.00- 199,876.00 -(6,000.00) Operating Equipment 20,022.7055,337 - 66,717.92- 2,500.00 Capital Outlay -14,800--- - TOTAL NONDEPARTMENTA 66,012.73411,386-341,025.74381,667.26 L 2,500.00 TOTAL EXPENDITURE 66,012.73411,386-341,025.74381,667.26 S 2,500.00 89,042.56 REVENUE OVER(UNDER) EXPENDITURE - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 89,283.28391,181.21470,290.28 -(79,536.28) - TOTAL Taxes 390,754 89,283.28 391,181.21- 470,290.28 - (79,536.28) Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned3000.87-260.9190.38 - 209.62 000-491200Investment Interest 200 56.54 - 124.24 329.16 164.58% - (129.16) 000-497000Misc Income600.00- - - - - - TOTAL Miscellaneous50057.41-985.15419.54 83.91% - TOTAL REVENUES 411,386 89,340.69 392,166.36- 470,709.82 - (59,323.82) HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking26,789.71$ Cash in Investments MBIA - Hotel Tax220,189.30 Federated Investment-Hotel/Motel78,265.90 Total Cash in Bank & Investments$325,244.91 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 46,551 29,807 2011-12 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 2010-11 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 2009-10 17,549 20,134 18,461 17,255 15,138 19,297 19,548 24,769 29,695 32,336 37,633 45,428 2008-09 19,122 21,531 20,663 19,204 17,475 20,760 25,081 24,748 23,122 26,866 30,247 26,313 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 78,053.00- 148,025.00 - -101,975.00 Tree Mitigation Fees 75,000 43,520.00- 69,134.75 - -5,865.25 Miscellaneous60048.77- 655.87638.59 - TOTAL REVENUES325,60048.77-122,211.59217,815.62 - EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services - 23,350.00- - - -(23,350.00) Fund Charges/Transfers 100,000.0013,000 - 105,819.26- -(92,819.26) Maintenance Services-Landscape 3,500 28,399.00- 135.88 - -3,364.12 Operating Equipment 32,000 2,781.20 57,028.78- 62,082.37 -(30,082.37) Capital Outlay169,000-- 23,416.00 - - TOTAL PARKLAND DEDICATION217,500102,781.20-85,427.78214,803.51 - TREE MITIGATION Maintenance Services-Trees 2,412.5028,500 - 33,944.55 6,335.50 -22,164.50 Capital Outlay18,000-- 19,900.00 - - TOTAL TREE MITIGATION46,5002,412.50-33,944.5526,235.50 - TOTAL EXPENDITURE264,000105,193.70-119,372.33241,039.01 S - REVENUE OVER(UNDER) EXPEND61,600(23,223.39) C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 78,053.00- 148,025.00 101,975.00 - 000-458900Tree Mitigation75,00043,520.0069,134.75 - - TOTAL Fees 325,000 121,573.00- 217,159.75 107,840.25 - Miscellaneous 000-491000Interest Earned 100 6.68 - 219.62 48.84 51.16 000-491200Investment Interest500418.97607.03 42.09 - TOTAL Miscellaneous 600 48.77 - 638.59 655.87 (55.87) TOTAL REVENUES 325,600 48.77 122,211.59- 217,815.62 107,784.38 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$51,774.78 Cash in Investments Federated Investment-Park Fund 167,411.05 Federated Investment-Tree Mitigation152,121.13 Total in Investment Pool 319,532.18 Total Cash in Bank & Investments$371,306.96 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 261,471.64 2,084,056.94- 1,686,256.32 -1,039,143.68 Fund Transfers10,673,600 487,342.00 46,539.29- 487,342.00 -10,186,258.00 Miscellaneous314,0001,415.19236,710.9719,302.39 - - TOTAL REVENUES13,713,000 750,228.832,367,307.202,192,900.71 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 355.21 66,189.20- 6,610.29 -15,389.71 Fund Charges/Transfers - 279,826.19- 218,391.10 - -(218,391.10) Maintenance Services 10,000 5,740.00 - - 5,740.00 -4,260.00 Debt Service - 226,030.34- 215,537.50 - -(215,537.50) Capital Outlay8,666.85- - - - - TOTAL NON DEPARTMENTA38,0006,095.21580,712.58446,387.39 L - - MISC & PROJECTS Projects13,025,000- -- - -13,025,000.000.00% Schaefer RD Water Improvements599,643 -- - - -599,643.00 viation Heights WTR IMP -- A - - - - TOTAL MISC & PROJECTS13,624,643 - -- - - TOTAL EXPENDITURE13,662,643 6,095.21580,712.58446,387.39 S - - REVENUE OVER(UNDER) EXPENDITURES50,3571,746,513 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600155,283.04 1,280,209.55- 1,038,730.04 -440,869.96 000-455910Capital Recovery - Waste Wtr613,800 98,988.60 803,807.78- 571,926.28 -41,873.72 7,200.00 75,600.0039.61 000-455913Cap Recovery-North Sewer Tr 632,000 - - TOTAL Fees2,725,400261,471.64 2,084,056.94-1,686,256.32 -1,039,143.68 Fund Transfers 000-481000Transfer from Reserves10,673,600---- -10,673,600.00 000-486202Transfer in-Water - 46,539.29487,342.00 -487,342.00 -(487,342.00) 000-486406Transfer in-Public Improvement -- - - - - TOTAL Fund Transfers10,673,600 487,342 - 46,539 487,342 -10,186,258.00 Miscellaneous 000-491000Interest Earned 500 17.18 - 496.08 398.24 - 000-491200Investment Income 30,000 4,733.22 39,009.22- 54,389.49 -(24,389.49) 000-491800Gain/Loss - (18,314.28)- - (11,259.00) -18,314.28 000-491900Unrealized Gain/Loss-Cap One (22,794.33)- (17,221.37) - 7,923.79 -17,221.37 000-495013Capital Contribution 220,000.00- - - - - 000-497000Misc Income - - 50.31 - - - -- 000-498200Re-imbursement-Water Meters 283,500 - - - TOTAL Miscellaneous 314,000 1,415.19 236,710.97- 19,302.39 -294,697.61 TOTAL REVENUES13,713,000 750,228.83 2,367,307.20- 2,192,900.71 -11,520,099.29 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking500,939.15$ Cash in Investments Lone Star Investment-Capital Recovery Water2,110,574.25 Lone Star Investment-Capital Recovery Sewer866,304.96 Capital One-Investment1,718,866.25 Total Cash in Bank & Investments5,196,684.61$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 5,544.194,281,098 - 3,433,642.49 4,308,574.95 -(27,476.95) - - 6,791.72 - Fund Transfers - - Miscellaneous2,2502,426.543,230,644.8115,784.97 - - TOTAL REVENUES 7,970.734,283,3486,671,079.024,324,359.92 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL 400.00 89,503.48- 37,760.39 Professional Services - -(37,760.39) Debt Service4,276,667-4,240,294.03 -3,862,562.10 -36,372.47 Other Financing Sources2,908,428- - - - - TOTAL GENERAL GOVERNMEN 400.004,276,6676,860,493.084,278,054.42 T - - TOTAL EXPENDITURE 400.004,276,6676,860,493.084,278,054.42 S - - ** REVENUE OVER(UNDER) EXPEND6,68246,305.50 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 5,544.193,433,642.494,308,574.95 - - TOTAL Taxes4,281,0985,544.19 3,433,642.49-4,308,574.95 - (27,476.95) Fund Transfers 000-486401Transfer In Fund 4016,791.72- - - - - TOTAL Fund Transfers - - 6,791.72 - - - Miscellaneous 000-491000Interest Earned7500.23-252.7841.42 - 000-491200Investment Earnings1,5002,426.311,067.0323,859.60 - -(22,359.60) 000-495015Contribution from SED- - - -364,325.00 000-497000Misc Income (8,116.05)- - - - -8,116.05 000-498000Proceeds From Refunding De2,865,000.00- b - - - - TOTAL Miscellaneous 2,250 2,426.54 3,230,644.81- 15,784.97 - (13,534.97) TOTAL REVENUES4,283,348 7,970.73 6,671,079.02- 4,324,359.92 - (41,011.92) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent400.00 1,150.001,950.00 - - -(1,950.00) 35,810.3988,353.48 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services400 89,503.48-37,760.39 - -(37,760.39) Debt Service 101-555612Bond-GO Refunding 2010-Principal 240,000 -- 285,000.00 240,000.00 - 101-555612.1Bond-GO Refunding 2010 Interest82,650 - 80,502.08- 82,650.00 - 101-555622Schertz C O SR2003-Principal200,000 - 190,000.00- 200,000.00 - 101-555622.1Schertz C O SR2003-Interest 53,800 - 60,820.00- 11,265.00 -42,535.00 101-555624Comm Proj Bond-SR04-Principal315,000 - 325,000.00- 315,000.00 - 101-555624.1Comm Proj Bond SR04-Interest251,009 - 265,008.13- 20,703.13 -230,305.87 101-555626LS&D SR2006-Principal 100,000 - - 100,000.00- - 101-555626.1LS&D SR2006-Interest 648,982 - 650,981.25- 648,981.25 - 101-555628CO Bond 2007-Principal 102,900 - 99,709.25- 102,900.00 - 101-555628.1CO Bond 2007-Interest 22,625 - 26,523.79- 22,176.64 - 101-555629GO Bond 2007-Principal 225,000 - 275,000.00- 225,000.00 - 101-555629.1GO Bond 2007-Interest 198,922 - 209,096.25- 198,819.50 - 101-555630GO Bond SR2008 Principal 370,000 - 355,000.00- 370,000.00 - 101-555630.1GO Bond SR2008 Interest 364,679 - 379,650.25- 364,679.00 - 101-555631GO Bond SR2009 Principal 200,000 - 435,000.00- 200,000.00 - 101-555631.1BO Bond SR2009 Interest278,812.50 278,813 - -352,387.50 - 101-555633GO SR2011 Principal 90,000.00- 90,000 - - - 101-555633.1GO SR2011 Interest 532,286.46- 532,287 - - - 101-555634GO SR2011A Refund Principal 140,000.00- - - - -(140,000.00) 101-555634.1GO SR2011A Refund Interest 97,020.55- - - - -(97,020.55) (127,116.40)- 101-555800Bond Premium - - - - TOTAL Debt Service4,276,667 - 3,862,562.10- 4,240,294.03 -36,372.47 Other Financing Sources -- - - - - 101-556300Payment to Refund Debt2,908,427.50- - - - - TOTAL Other Financing Sources - 2,908,427.50- - - - TOTAL EXPENDITURES 4004,276,667 - 6,860,493 4,278,054 -(1,387.92) TAX I&S CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking929.29$ Cash in Investments MBIA Investment- Tax I&S 132,254.65 Federated Investment-Tax I&S56.91 Total Cash in Bank & Investments$133,240.85 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042288,913.56 2,352,177.47- 2,659,193.60 - (267,151.60) Fund Transfers 976 - 100,000 976 - - Miscellaneous17,2001,382.5825,615.0125,068.63 - - TOTAL REVENUES 291,271.912,409,2422,477,792.482,685,238.00 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies28,0002,505.18 21,319.02-26,226.54352.06 Utility Service 94,300 16,284.16 80,782.47- 83,431.08 - 10,868.92 Maintenance Services 58,500 6,690.77 71,356.93- 52,367.98 - 6,132.02 Operating Equipment - 6,999.31 - - - - Capital Outlay -- - - - - TOTAL NONDEPARTMENTA180,80025,480.11180,457.73162,025.60352.06 L - ECONOMIC DEVELOPMEN T Personnel Services 242,092 27,624.02 156,230.81- 248,531.43 - (6,439.43) Supplies 1,100 120.50 - 2,087.00 730.57 17.48 Human Services 200 - - - - - City Support Services 41,913 (827.00) 19,269.72- 9,128.12 - 32,784.88 Utility Services 7,200 181.85 - 2,972.91 1,417.35 - 5,782.65 Operations Support 113,100 1,028.89 102,626.94- 101,297.22 12.00 Staff Support 63,300 3,848.41 24,718.02- 33,958.88 5,056.32 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 52,691.47 254,422.35- 245,481.01 19,217.71 Fund Charges/Transfers 105,985421,490.42 469,756.97- 472,810.04 - (366,825.04) Fund Replenish-Fund Balance - - - - - - Debt Service 795,154 428,107.00- 428,329.00 - - 366,825.00 Operating Equipment2,350210.451,372.08372.39 - - TOTAL ECONO DEVELOPMEN 506,369.011,975,8941,461,563.801,552,056.01 T - 24,303.51 TOTAL EXPENDITURE 531,849.122,156,6941,642,021.531,714,081.61 S - 24,655.57 ** REVENUE OVER(UNDER) EXPEND252,548971,156.39 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042288,913.562,352,177.472,659,193.60 - - TOTAL Taxes2,392,042288,913.56 2,352,177.47- 2,659,193.60 -(267,151.60) Fund Transfers 000-486000Transfer In975.77100,000.00975.77 - - - TOTAL Fund Transfers 100,000.00-975.77 -975.77 - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 7.83 - 280.40 148.65 - 000-491200Investment Earnings 15,000 1,356.29 12,797.75- 9,046.18 -5,953.82 000-497000Misc Income2,00018.4612,536.8615,873.80 - - TOTAL Miscellaneous 17,200 1,382.58 25,615.01- 25,068.63 - TOTAL REVENUES2,409,242291,271.91 2,477,792.48- 2,685,238.00 -(275,996.00) SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking194,666.01$ Cash in Investments MBIA Investment-Economic Development Corp2,677,096.00 Schertz Bank & Trust-Certificate of Deposit1,037,007.40 Total Cash in Bank & Investments3,908,769.41$ 4B SALES TAX $350,000 $300,000 26% -2% 40% $250,000 19% 17% 25% -3% 23% -2% 12% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 207,911 230,700 182,541 173,698 267,965 199,040 204,426 287,707 220,125 2011-12 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2010-11 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 2009-10 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 155,080 185,494 159,088 2008-09 168,374 175,427 156,274 163,899 210,937 165,065 143,668 177,527 168,047 164,073 180,483 169,043 2007-08 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING SEPTEMBER 30th, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust3,405,834.30,747,690.18.05002,327,396.361,669,252.24,405,834.30,405,834.30 201133 TOTAL OPERATIONS3,405,834.30,747,690.182,327,396.361,669,252.24,405,834.30,405,834.30 21133 LOGIC General Fund862,606.24,762,342.04.196464.2000,000.0062,606.24 N/A62,606.24 102988 G/F-Equipment Replacement73,470.2373,458.350.1964 -11.8873,470.23 N/A73,470.23 G/F-Vehicle Replacement102,496.45,090.29.1964 -5,406.1602,496.45 N/A02,496.45 70911 G/F-Air Conditioner Replacement146,689.42146,665.750.1964 -23.67146,689.42 N/A146,689.42 ,690,811.83.196472.94-,691,084.77,691,084.77 SR2009 Bond-Street Projects(II)1,691,084.77 10211 TOTAL LOGIC2,876,347.11,680,368.265,978.8500,000.00,876,347.11,876,347.11 39922 LONESTA R Capital Recovery - Sewer866,304.96566,185.340.2400 -300,119.62866,304.96 N/A866,304.96 Capital Recovery - Water2,110,574.25,010,179.76.2400 -00,394.49,110,574.25 N/A,110,574.25 20122 Drainage Fund383,891.47383,816.740.2400 -74.73383,891.47 N/A383,891.47 GO SR2011 Animal Shelter2,066,096.86,137,239.55.240014.111,556.80,066,096.86 N/A,066,096.86 204722 GO SR2011 Athletic Fields2,983,553.071,483,090.150.24001,500,462.92-2,983,553.07 N/A2,983,553.07 GO SR2011 Soccer Fields2,784,672.87,311,208.79.2400,500,428.656,964.57,784,672.87 N/A,784,672.87 101222 GO SR2011 Swimming Pool6,496,353.542,876,045.150.24003,625,980.765,672.376,496,353.54 N/A6,496,353.54 GO SR2012 Downtown Improvements1,000,116.12.2400,000,116.12-,000,116.12 N/A,000,116.12 -0111 W/S-Customer Deposits294,351.02294,293.720.2400 -57.30294,351.02 N/A294,351.02 W/S-Equipment Repl/Cap.Imp373,939.9473,867.15.2400 -2.7973,939.94 N/A73,939.94 30733 Water&Sewer924,369.371,360,612.740.2400256.63436,500.00924,369.37 N/A924,369.37 W/S-Vehicle Replacement545,249.1445,143.01.2400 -06.1345,249.14 N/A45,249.14 50155 Water/SSLG - SAWS404,397.8504,319.13.24008.72-04,397.8504,397.85 40744 TOTAL LONESTAR21,233,870.4613,746,001.238,028,562.97540,693.7421,233,870.4621,233,870.46 MBIA Tax I&S132,254.6525,396.02.2300 -,858.6332,254.65 N/A32,254.65 10611 Police Forfeiture359,911.33359,843.550.2300 -67.78359,911.33 N/A359,911.33 Economic Development Corporation2,677,096.00,676,592.04.2300 -03.96,677,096.00 N/A,677,096.00 20522 Hotel Tax220,189.30250,143.070.230046.2330,000.00220,189.30 N/A220,189.30 Special Events Fund46,692.076,683.31.2300 -.766,692.07 N/A6,692.07 40844 EMS Tax Notes 2010301,414.7401,358.00.23006.74-01,414.7401,414.74 30533 TOTAL MBIA3,737,558.093,760,015.997,542.1030,000.003,737,558.093,737,558.09 FEDERATED SR2007a Bond-City Wide Projects869,271.4969,156.99.1600 -14.5069,271.49 N/A69,271.49 80188 Hotel Occupancy Tax78,265.9078,255.590.1600 -10.3178,265.90 N/A78,265.90 Park Fund (Developers Fee)167,411.0567,389.00.1600 -2.0567,411.05 N/A67,411.05 10211 Park Fund (Tree Mitigation)152,121.13152,101.090.1600 -20.04152,121.13 N/A152,121.13 Tax I&S56.916.90.1600 -.016.91 N/A6.91 50055 Library Board Fund44,760.604,754.70.1600.90-4,760.604,760.60 40544 TOTAL FEDERATED1,311,887.081,311,714.27 -172.811,311,887.081,311,887.08 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,273,576.48,336,738.33.9000 277.21,985.44,342,446.56 N/A,341,456.41 12511 Capital One Capital Recovery Sewer1,617,469.01,741,679.97.8800,959.25355.21,743,284.01,718,866.25 12111 TOTAL CAPITAL ONE2,891,045.493,078,418.30 632.427,944.693,085,730.573,060,322.66 City Portfolio By Investment Type TOTAL C.D.s, TOTAL CAPITAL ONE, TOTAL OPERATIONS, $2,092,916.02, $2,891,045.49, $3,405,834.30, 6% 8% 9% TOTAL LOGIC, TOTAL FEDERATED, $2,876,347.11, $1,311,887.08, 8% 3% TOTAL MBIA, $3,737,558.09, 10% TOTAL LONESTAR, $21,233,870.46, 56% City Portfolio By Use Designated Funds, Operations, $1,929,063.61 $7,591,165.09 Special Revenue Funds, $9,796,056.80 Debt Service Fund, $132,311.56 Projects, $18,295,546.57 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-11NOV-11DEC-11JAN-12FEB-12MAR-12APR-12MAY-12JUN-12JUL-12AUG-12SEP-12 0.02000.02000.01000.04000.08000.05000.07000.03000.07000.07000.09000.0600 1 Month T-Bill 0.01000.01000.02000.06000.08000.07000.10000.07000.10000.11000.09000.1000 3 Month T-Bill 0.06000.06000.06000.08000.13000.15000.15000.14000.14000.14000.14000.1400 6 Month T-Bill 0.46000.52000.49000.50000.52000.53000.53000.51000.50000.50900.50520.4384 Schertz Portfolio 0.05000.05000.05000.05000.05000.05000.05000.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.40000.40000.40000.40000.40000.40000.40000.4000 CD 365 Days 0.80000.80000.30000.30000.30000.30000.30000.30000.30000.30000.30000.3000 CD 180 Days 0.25000.25000.10000.10000.1000 CD 90 Days 0.05000.05000.05000.0500 CD 28 Days 0.14700.18740.20850.25130.28600.29420.28640.26830.25140.23790.19270.1964 LOGIC 0.23000.25000.28000.31000.26000.27000.27000.24000.25000.25000.24000.2400 LoneStar 0.14000.15000.19000.21000.25000.24000.25000.26000.26000.24000.24000.2300 MBIA 0.09000.14000.13000.15000.22000.21000.19000.18000.18000.17000.16000.1600 Federated 2.32432.84002.83003.07003.07003.15003.15003.13003.03003.04003.03002.8900 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:9/30/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt Cl III #69113,576.4813,576.4813,576.48 Total Cash & Equivalent3,576.413,576.43,576.4 s18818 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014682.00125,000.00141,987.30137,418.756,875.00 Federal Home Loan Bks Cons Bds6/21/2013264.0080,000.0082,004.4080,987.201,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151172.00100,000.00116,185.00114,125.004,875.00 Federal Home Ln Mtg Corp Deb11/15/2013411.00170,000.00191,084.25179,027.008,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013359.00250,000.00250,000.00260,257.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014786.00200,000.00200,609.40201,846.001,500.00 Federal Natl Mtg Assn 7/28/20151031.00125,000.00132,828.63132,032.502,968.00 US Treasury Note11/30/20151156.0060,000.0061,936.7261,945.80825.00 US Treasury Note5/31/20161339.0050,000.0052,476.5652,434.00875.00 US Treasury Note2/28/2014516.00100,000.0099,757.82100,063.00 Total Fixed Income1,260,000.001,328,870.081,320,136.753 Total Assets678.541,273,576.481,342,446.561,333,713.233 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #69127,469.0127,469.0127,469.012.000.01 Total Cash & Equivalent7,469.0127,469.017,469.01 s22 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014682.00165,000.00187,423.24181,392.759,075.00 Federal Home Loan Bks Cons Bds6/21/2013264.00100,000.00102,505.50101,234.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151172.00200,000.00230,779.00228,250.009,750.00 Federal Home Ln Mtg Corp Deb11/15/2013411.00250,000.00281,006.25263,275.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013380.00200,000.00223,001.60209,224.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014786.00220,000.00220,078.68222,030.601,650.00 Federal Natl Mtg Assn7/28/20151031.00135,000.00143,454.91142,595.103,206.00 US Treasury Note11/30/20151156.0050,000.0051,609.5751,621.50687.00 US Treasury Note5/31/20161339.00125,000.00131,191.41131,085.002,187.00 /28/201416.0045,000.00144,764.8445,091.35 US Treasury Not e2511 Total Fixed Incom,590,000.01,715,815.0,675,799.3 e100105 Total Assets720.771,617,469.011,743,284.011,703,268.315