Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11-AUGUST 2011 STATEMENT
AUGUST 2011 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department September 28, 2011 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes10,912,656 473,090.32 9,491,931.97- 10,304,368.18 608,287.82- Franchises 1,521,000 375,873.37 1,412,687.76- 1,512,067.58 - Permits 1,181,913 93,993.60 947,870.59- 1,558,508.58 -(376,595.58) Licenses 64,547 1,100.00 38,522.50- 34,020.60 -30,526.40 Fees 3,073,872 227,389.56 2,411,090.64- 2,497,422.09 -576,449.91 Fines 35,000 2,133.19 28,003.72- 24,173.36 -10,826.64 Inter-Jurisdictional 405,672 29,276.10 381,117.57- 373,633.36 -32,038.64 Fund Transfers 1,282,660 88,620.07 840,466.09- 1,064,459.29 -218,200.32 Miscellaneous507,28461,642.89449,231.22499,899.09(543.62) - TOTAL REVENUES18,984,6041,353,119.1016,000,922.0617,868,552.13(543.62) - - EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,800 1,813.46 - 10,286.48 20,812.37 - Supplies500 7.95 - 164.23 397.80 114.09 (11.89) City Support Services14,500 - - 12,227.87 13,447.67 642.29 410.04 Operations Support300 29.60 - 221.67 190.95 - Staff Support22,400446.52380.00 9,673.7713,578.19824.82 Operating Equipment -- - - - - TOTAL CITY COUNCIL60,5002,297.53380.0032,574.0248,426.981,581.20 CITY MANAGE R Personnel Services 57,016.33753,457 - 609,300.83 649,495.59 -103,961.41 Supplies4,526 39.17 - 1,394.49 1,515.91 613.18 2,396.91 - - 66.47 - City Support Services - - Operations Support - - 178.00 - - - Staff Support 33,850 2,054.08 438.80 22,573.33 23,306.01 1,206.99 1,596.7049.99 Operating Equipment1,574 - - - TOTAL CITY MANAGER 59,109.58793,407 438.80 633,563.11 675,914.21 1,820.17 116,111.42 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services 18,794.71250,203 - 201,291.14 215,600.71 -34,602.29 Supplies3,200 - - 874.20 1,837.35 113.13 1,249.52 City Support Services1,000 293.00 - - 293.00 10.06 696.94 Operations Support3,000 - - 2,708.00 1,951.00 - Staff Support6,200 306.35 33.44 2,379.90 2,348.48 318.28 3,566.68 Court Support800 - - - - - Professional Services 84,600 4,200.00 48,664.23- 45,190.25 4,978.75 Maintenance Services 2,500 200.00 - - 800.00 - Operating Equipment2,000 900.00903.98103.89 - - TOTAL MUNICIPAL COURT 23,794.06353,503 33.44 256,821.45 268,920.79 5,524.11 79,091.54 CUSTOMER RELATIONS-311 Personnel Services88,928 6,325.75 - 78,091.65 73,415.41 -15,512.59 Supplies500 - - 81.95 380.33 - Staff Support1,105 1,069.97- - - - TOTAL CUSTOMER RELATIONS-311 90,533 6,325.75 78,173.60- 74,865.71 -15,667.29 PLANNING & ZONING Personnel Services 134,105 9,996.53 112,272.13- 118,177.78 -15,927.22 Supplies 4,500 - - 339.13 492.31 275.01 City Support Services - - - - - - Operations Support 2,300 - - 183.16 77.95 - Staff Support 22,100 1,041.50 1,527.12 7,617.03 4,747.25 6,917.05 Professional Services 142,300 3,377.62 - 21.00 66,236.08 198.07 Operating Equipment600 1,055.0054.98 - - - TOTAL PLANNING & ZONING 305,905 14,415.65 1,527.12 120,487.43 190,786.37 7,390.13 LEGAL SERVICES Operations Support 13,000 - - 7,991.61 9,199.04 - Professional Services245,00027,550.59163,160.84202,798.513,814.13 - TOTAL LEGAL SERVICES 258,000 27,550.59 171,152.45- 211,997.55 3,814.13 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services 47,987.84628,024 - 506,300.23 551,767.27 -76,256.73 Supplies59,900 3,267.18 638.43 45,662.38 55,266.49 3,986.61 1,285.33 Utility Services93,600 7,605.01 - 88,988.70 73,317.74 -20,282.26 - - - - Operations Support - - Staff Support 10,212 692.46 403.00 5,384.65 9,468.34 321.33 Maintenance Services 110,500 4,368.32 6,471.04 91,811.33 105,532.22 8,541.31 Rental/Leasing 2,000 - - 832.35 763.92 - Operating Equipment950409.00 1,685.651,687.55 - - 2,342.25 4,866.78- Capital Outlay24,500 - - TOTAL FACILITIES MAINTENANCE 929,686 66,672.06 7,512.47 740,665.29 802,670.31 12,849.25 CITY SECRETARY Personnel Services 12,289.50167,842 - 143,427.87 143,983.66 -23,858.34 Supplies1,550 50.09 - 793.85 1,365.19 16.45 168.36 City Support Services6,788 - - 4,574.71 6,788.22 - Operations Support - - - - - - Staff Support2,70014.00295.00 3,801.943,352.64275.00 TOTAL CITY SECRETARY 178,880 12,353.59 295.00 152,149.07 155,939.01 291.45 NON-DEPARTMENTA L Supplies 3,000 - - 4,786.32 405.35 10.00 City Support Services 349,407 3,272.21 760.00 375,324.25 285,383.67 4,964.02 Operations Support 115,500 10,485.22 107,542.32- 125,112.42 6,154.64 Staff Support 80.00 - - 80.00 - - City Assistance 390,552 - 523,612.54- 422,942.47 -(32,390.47) Professional Services 99,521 131.94 58,221.75- 48,464.92 -51,056.08 Fund Chrgs/Transfrs-Spec Events Fnd 122,536 98,185.61 49,192.21- 98,185.61 -24,350.00 Operating Equipment 500 - - 264.95 - - 36,124.51 - Capital Outlay7,000 - - - TOTAL NON-DEPARTMENTAL 1,088,016 112,154.98 760.00 980,574.441,155,068.85 11,128.66 97,072.51 PUBLIC AFFAIRS Personnel Services 15,904.51138,096 - 192,727.16 134,438.83 - Supplies2,450 33.38 - 2,087.02 953.81 769.77 726.42 Operations Support34,500 603.50 - 48,595.44 19,230.47 7,805.55 7,463.98 Staff Support3,750 106.32 - 4,347.16 2,230.45 167.42 1,352.13 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Professional Services - 254,418.44- - - - Operating Equipment3,500 2,737.182,926.20 - - - TOTAL PUBLIC AFFAIRS182,29616,647.71 505,101.42-159,590.748,742.74 RECORDS MANAGEMEN T Personnel Services46,3173,505.16 38,756.84-40,552.53 - Supplies 900 23.28 - 27.68 343.79 16.45 Staff Support 1,500 - - 729.09 845.14 - Professional Services 23,302 149.50 - 5,923.40 10,333.51 12,310.00 -- Operating Equipment - - - - TOTAL RECORDS MANAGEMENT 72,019 3,677.94 45,437.01- 52,074.97 12,326.45 SCHERTZ TALES MAGAZINE Personnel Services 9,860.38126,426 - - 110,117.39 -16,308.61 - - - 49.58 Opperations Support - - Staff Support 1,000 - - - 15.00 23.28 Professional Services261,00026,538.46 229,477.44-3,572.00 - TOTAL SCHERTZ TALES MAGAZINE388,42636,398.84- 339,659.41-3,595.28 ENGINEERING Personnel Services 169,469 12,348.58 139,542.52- 143,334.75 -26,134.25 Supplies 300 - - 59.38 242.15 68.07 Staff Support 2,213 248.12 - 1,164.10 1,124.12 353.00 Professional Services 24,000 - - 8,253.43 19,066.25 - Maintenance Services 4,044 - - 1,200.00 2,844.24 - -- Operating Equipment - - - - TOTAL ENGINEERING 200,026 12,596.70 150,219.43- 166,611.51 421.07 GIS Personnel Services 117,358 8,921.34 98,954.17- 101,959.97 -15,398.03 Supplies 3,300 - - 108.00 1,451.62 1,229.10 Staff Support 2,050 - - - - - Professional Services1,000 -250.00 - - - TOTAL GIS 123,708 8,921.34 99,312.17- 103,411.59 1,229.10 TOTAL GENERAL GOVERNMENT 5,024,905 402,916.32 10,946.83 4,140,725.30 4,231,443.59 70,713.74 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC SAFETY POLICE Personnel Services4,083,030 304,785.83 - 3,573,485.39 3,658,494.05 -424,535.95 Supplies49,058 4,549.79 124.50 15,612.91 21,827.43 13,271.09 14,083.98 City Support Services30,000 - - 32,003.00 - -30,000.00 Utility Services100,000 9,949.98 - 79,277.48 89,077.11 -10,922.89 Operations Support2,000 434.50 - 365.00 627.50 - Staff Support34,450 2,380.34 - 6,049.95 12,555.28 9,939.10 11,955.62 City Assistance13,000 2,153.00 - 5,235.95 5,056.18 1,364.66 6,579.16 Professional Services8,000 - - 4,903.36 6,830.16 400.00 769.84 Maintenance Services77,449 1,445.00 179.50 41,657.36 30,840.80 496.56 46,291.14 Operating Equipment65,596 5,435.59 5,196.00 36,081.00 54,101.46 7,665.80 9,024.74 Capital Outlay166,298114,837.60153,726.4012,554.80 - - TOTAL POLICE 4,628,881331,134.035,500.003,909,509.004,033,136.3745,692.01 FIRE RESCUE Personnel Services 2,410,836 166,844.01 1,963,803.08- 2,115,417.34 -295,418.66 Supplies 20,200 136.77 20.15 9,332.64 6,198.98 962.82 Utility Services 49,600 3,370.63 46,369.53- 43,207.90 - Operations Support 800 120.00 - 419.97 687.00 - Staff Support 108,800 7,058.98 12,138.00 59,674.39 84,084.06 20,383.43 City Assistance 18,600 7,108.46 10,323.17 2,997.75 17,885.71 10,848.60 Professional Services 14,240 - - 13,040.00- 1,200.00 Maintenance Services 53,500 318.98 22,435.71- 27,263.61 8,328.45 3,566.55604.5016,674.28 34,719.4512,742.45 Operating Equipment52,400 TOTAL FIRE 2,728,976 188,524.38 23,085.82 2,121,707.35 2,342,504.05 54,465.75 INSPECTIONS Personnel Services 364,194 27,770.91 301,129.59- 317,406.35 -46,787.65 Supplies 6,750 - 375.00 1,103.92 1,694.80 516.19 Utility Services 7,600 544.73 - 3,536.55 4,813.21 - Operations Support 3,200 629.00 - 415.00 1,467.87 - Staff Support 14,700 77.10 388.20 4,045.62 3,151.85 1,120.34 Professional Services 10,000 - - 5,240.47 - -10,000.00 Maintenance Services - - - - - - Operating Equipment -- - - - - TOTAL INSPECTIONS 406,444 29,021.74 763.20 315,471.15 328,534.08 1,636.53 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MARSHAL SERVICE Personnel Services 38,175.81486,250 - 317,962.02 402,892.54 -83,357.46 Supplies6,450 - - 1,200.77 1,633.87 205.82 4,610.31 Utility Services9,000 1,389.48 - 5,489.47 9,170.21 - Operations Support 4,000 - - 434.50 1,595.39 2,305.00 Staff Support 9,400 1,230.40 - 2,653.13 3,622.97 837.69 Professional Services - - - - - - Maintenance Services 12,400 241.00 - 4,420.53 9,965.85 - Operating Equipment21,480 13,117.11-7,903.83 - - 56,197.43- Capital Outlay65,600 - - - TOTAL MARSHAL SERVICE 614,580 41,036.69 332,160.42- 498,195.37 11,252.34 TOTAL PUBLIC SAFETY 8,378,881 589,716.84 29,349.02 6,678,847.92 7,202,369.87113,046.63 PUBLIC ENVIRONMENT STREETS Personnel Services596,591 40,350.45 - 507,112.83 498,365.10 -98,225.90 Supplies6,120 130.93 28.15 3,900.85 4,331.29 160.04 1,656.82 Utility Services101,900 10,166.67 - 94,989.37 100,285.84 855.71 758.45 Operations Support1,380 21.00 - - 21.00 - Staff Support9,265 554.12 84.08 5,595.02 6,585.04 317.40 2,446.64 Maintenance Services156,875 3,124.38 16,620.12 89,123.46 138,319.96 13,679.88 21,495.29 Rental/Lease200 - - - - - Operating Equipment 4,380 - - 116.00 4,379.99 - Capital Outlay14,500 14,475.96- - - - TOTAL STREETS 891,211 54,347.55 16,732.35 700,837.53 766,764.18 15,013.03 TOTAL PUBLIC ENVIRONMENT 891,211 54,347.55 16,732.35 700,837.53 766,764.18 15,013.03 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PARKS & RECREATION PARKS DEPARTMENT Personnel Services475,862 34,531.68 - 404,421.90 412,115.82 -63,746.18 Supplies37,055 2,427.51 - 56,403.13 28,359.58 3,741.05 4,954.39 - - 163.25 - City Support Services - - Utility Services 113,300 5,979.99 100,085.45- 109,103.07 855.71 Operations Support 700 - 600.00 - 880.80 - Staff Support 7,686 433.64 202.35 7,401.26 6,660.05 686.91 Professional Services 53,278 3,825.00 - 3,661.80 40,884.50 10,714.50 Maintenance Services 21,000 228.94 33,818.77- 19,737.38 966.32 Rental/Leasing 30,531 6,450.80 3,491.50 16,206.79 39,953.03 -(5,930.53) Operating Equipment 200 - - 5,974.00 3,494.99 (99.98) Capital Outlay7,000689.05 3,582.55- - - TOTAL PARKS DEPARTMENT746,61254,566.614,293.85628,136.35664,771.7716,864.51 SWIM POOL Supplies 16,700 4,349.34 123.66 20,377.33 15,740.19 38.32 Utility Services 25,500 1,771.00 20,935.56- 16,143.75 - Staff Support 925 - - 439.98 166.09 - Maintenance Services 199,378 63,127.93 193,523.82- 190,192.20 - 378.00300.00 Rental/Lease500 - - - TOTAL SWIM POOL 69,248.27243,003 123.66 235,576.69 222,620.23 38.32 20,468.11 COMMUNITY/CIVIC CENTER Personnel Services112,341 5,180.71 - 65,519.46 70,641.37 -41,699.63 Supplies6,923 531.12 - 5,253.07 7,291.27 1,469.32 (1,837.59) Utility Services47,150 3,655.88 - 37,690.33 32,849.08 113.05 14,187.87 Operations Support14,682 - - 17,131.97 7,924.26 1,690.95 5,066.79 Staff Support2,750 - - 702.45 614.47 402.63 1,732.90 Professional Services600 - - - 975.00 - Operating Equipment7,17233,303.10 285.005,991.60 - - TOTAL COMMUNITY/CIVIC CNTR 191,618 9,367.71 159,600.38- 120,580.45 9,667.55 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET SENIOR CITIZEN CENTER - - 855.89 - Supplies - - Utility Services - - 3,367.86 278.31 - - City Assistence - 14,850.00- - - - Maintenance Services -1,082.50 - - - - TOTAL SENIOR CITIZEN CENTER- 20,156.25-278.31 - - TOTAL PARKS & RECREATION 1,181,233 133,182.59 4,417.51 1,043,469.67 1,008,250.76 26,570.38 CULTURAL LIBRARY Personnel Services 52,163.20667,832 - 534,289.73 594,136.14 -73,695.86 Supplies16,400 89.95 - 12,687.96 10,674.43 3,775.15 1,950.42 Utility Services39,500 5,052.28 - 45,019.98 41,118.23 -(1,618.23) Operations Support2,500 - - 1,290.00 1,110.20 - Staff Support4,185 65.02 23.25 2,792.39 1,500.42 186.86 2,520.97 Professional Services2,100 - - 200.68 2,065.00 - Maintenance Services 3,500 - - 3,296.25 1,200.00 600.00 Operating Equipment 65,000 1,318.78 47.36 56,445.10 57,157.08 5,222.03 Capital Outlay10,500.00 10,500.00- - - - TOTAL LIBRARY 801,017 58,689.23 10,570.61 656,022.09 719,461.50 9,784.04 TOTAL CULTURAL 801,017 58,689.23 10,570.61 656,022.09 719,461.50 9,784.04 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICE S Personnel Services 19,860.75302,083 - 233,520.04 260,396.81 -41,686.19 Supplies24,900 765.93 42.00 18,563.48 17,309.28 1,028.33 6,604.39 Utility Services10,900 1,000.14 - 7,516.91 9,422.34 - Operations Support800 - - 263.00 - - Staff Support 5,800 - - 5,037.60 1,981.08 21.65 City Assistance 13,000 938.14 - 6,799.52 8,961.78 - Professional Services 14,500 1,203.50 13,091.20- 10,344.00 187.50 Maintenance Services 6,100 - (112.00) 2,077.05 3,364.61 390.00 Operating Equipment8,00078.18 866.164,498.52447.72 - 3,995.00- Capital Outlay4,000 - - - TOTAL ANIMAL SERVICES 390,083 23,846.64 (70.00) 287,734.96 320,273.42 2,075.20 TOTAL HEALTH 390,083 23,846.64 (70.00) 287,734.96 320,273.42 2,075.20 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 20,892.44261,085 - 198,796.08 230,201.12 -30,883.88 Supplies1,500 - - 562.10 1,090.52 - City Support Services 337,952 13,605.25 78,975.69 152,593.83 224,989.10112,315.18 Utility Services 147,131 4,596.10 104,096.90- 118,335.32 190.34 Staff Support 10,400 3,739.86 1,813.95 4,084.11 9,842.38 563.58 Professional Services - - - - - - Maintenance Services 21,100 - 25,465.83- 15,082.52 - Operating Equipment 135,836 4,521.88 84,363.82- 81,788.50 31,696.25 10,527.00 45,780.00 Capital Outlay45,809 - - - TOTAL INFORMATION TECHNOLOGY 960,813 47,355.53 80,789.64 580,489.67 727,109.46144,765.35 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services222,521 18,489.27 - 179,466.38 185,907.35 -36,613.65 Supplies769 - - 536.86 768.52 - Human Services 43,265 2,515.10 31,757.98- 34.0030,548.99 12,682.01 Operations Support11,946 - 266.28 13,867.39 9,317.21 1,646.40 1,248.67 Staff Support10,982 450.00 - 6,163.94 7,017.49 - City Assistance9,425 622.00 - 7,842.00 6,353.00 965.00 2,107.00 Professional Services190 - - - - - Operating Equipment4,387 -1,491.55 - - - TOTAL HUMAN RESOURCES 22,076.37303,485 266.28 241,126.10 239,912.56 2,645.40 61,193.32 FINANCE Personnel Services419,818 31,728.60 - 355,970.52 364,607.52 -55,210.48 Supplies3,600 - (99.58) 2,989.95 2,805.18 - Operations Support 1,050 - - 489.50 342.57 133.36 Staff Support 13,370 - 74.30 6,554.47 9,155.08 398.86 Maintenance Services 630 - - - - - 1,077.80- Operating Equipment5,699 - - - TOTAL FINANCE 444,167 31,728.60 (25.28) 366,004.44 377,988.15 532.22 PURCHASING & ASSET MGT Personnel Services 17,798.80234,220 - 202,867.54 205,021.16 -29,198.84 Supplies2,350 32.34 - 509.78 711.03 95.92 1,543.05 Utility Services1,150 - - 330.76 327.46 - Operations Support 150 - - - 60.68 - Staff Support 6,900 172.00 - 4,930.15 5,259.30 - Operating Equipment150 -- - - - TOTAL PURCHASING & ASSET MGT244,92018,003.14 208,638.23-211,379.6395.92 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services148,533 15,899.96 - 129,670.32 144,980.11 - Supplies101,000 11,567.46 4,701.70 93,001.32 104,594.82 7,184.87 (6,077.99) City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,000 547.34 - 5,668.35 4,544.59 - Operations Support 400 - - - 750.00 - Staff Support 2,935 203.08 - 1,404.04 2,005.70 40.76 Professional Services - - - - - - Maintenance Services 45,250 4,622.48 474.24 35,038.44 52,591.45 1,200.64 Rental/Lease200 -150.0035.00 - - 139.99 4,113.89- Operating Equipment6,000 - - TOTAL FLEET SERVICE 312,818 32,980.31 5,175.94 266,282.47 315,230.56 8,461.27 TOTAL INTERNAL SERVICE 2,266,203 152,143.95 86,206.58 1,662,540.91 1,871,620.36156,500.16 MISC & PROJECTS CITY ASSISTANC E Utility Services---214.21 - - Patient Assistance 5,000 - - 5,000.00 5,000.00 - Children's Advocacy Assistance 5,000 - - 5,000.00 5,000.00 - 42,000.00- Senior Citizen's Hot Meals42,000 - - - TOTAL CITY ASSISTANCE 52,000 - 10,000.00- 52,214.21 - COURT - RESTRICTED FUNDS Operating Equipment8,147.40 9,237.4059.984,380.00 - - TOTAL CITY ASSISTANCE - 59.98 9,237.40 4,380.00 (13,617.40) -8,147.40 TOTAL MISC & PROJECTS52,000 8,147 - 10,060 61,452 4,380 (13,831.61) TOTAL EXPENDITURES18,985,533 1,422,990.52 158,152.90 15,180,238.36 16,181,635.29 398,083.18 2,563,967.50 REVENUE OVER(UNDER) EXPEND.(929)1,686,916.84 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,704,566 13,773.01 6,266,346.83- 6,752,645.26 - (48,079.26) 000-411200Advalorem Tax - Delinquent 50,000 2,758.94 59,245.56- 49,264.12 - 000-411300Advalorem Tax - P&I 50,000 3,073.20 43,826.91- 43,050.27 - 000-411500Sales Tax Revenue-Gen Fund4,071,590 453,062.77 3,085,717.79- 3,424,223.84 - 647,366.16 000-411600Bingo Tax 4,500 422.40 - 4,651.28 1,554.73 - 000-411700Mixed Beverage Ta32,143.6033,629.96 x 32,000.00 - - - TOTAL Taxes10,912,656 473,090.32 9,491,931.97- 10,304,368.18 608,287.82 Franchises 000-421200Center Point/Entex Energy 33,000 10,966.36 23,991.96- 47,076.51 - (14,076.51) 000-421220City Public Service 275,000 95,887.36 282,814.38- 309,573.17 - (34,573.17) 000-421240Guadalupe Valley Elec Co-op 430,000 92,571.09 436,052.09- 404,250.28 - 25,749.72 000-421250New Braunfels Utilities 30,000 7,400.57 12,228.49- 26,460.65 - 000-421300Time Warner-State Franchise 350,000 83,980.24 328,880.83- 333,655.67 - 16,344.33 000-421350Time Warner-PEG Fee 62,000 16,796.04 62,904.94- 65,557.47 - (3,557.47) 000-421460AT&T Franchise Fee 220,000 31,123.95 157,235.35- 150,808.59 - 69,191.41 000-421465AT&T PEG Fees 16,000 6,224.79 18,167.37 23,758.36 - (7,758.36) 000-421480Other Telecom Franchise 15,000 24,708.69 16,671.45- 63,149.80 - (48,149.80) 000-421500Solid Waste Franchise Fee90,0006,214.2873,740.9087,777.08 - - TOTAL Franchises1,521,000375,873.37 1,412,687.76-1,512,067.58 - Permits 000-431100Home Occupation Permit 770 - - 490.00 280.00 - 000-431200Building Permit 837,952 59,519.00 653,407.79- 1,214,510.83 - (376,558.83) 000-431300Mobile Home Permit 671 - - 80.00 80.00 - 000-431400Signs Permit 8,596 60.00 - 505.00 750.00 - 000-431500Food Establishmnt Permit 15,000 3,975.00 23,625.00- 18,345.00 - (3,345.00) 000-431600Garage Sale Permit 9,554 1,110.00 11,195.30- 10,760.00 - (1,206.00) 000-431700Plumbing Permit 109,769 8,869.60 82,054.50- 107,597.25 - 000-431750Electrical Permit 63,062 4,580.00 53,995.50- 66,280.00 - (3,218.00) 000-431800Mechanical Permit 84,211 6,600.00 72,614.00- 77,940.00 - 000-431900Solicitor/Peddler Permit 850.00 - 940.00 2,790.00 - - (2,790.00) 000-431950Animal/Pet Permit 2,000 - - 1,980.00 1,630.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt6,5781,400.00-5,650.006,950.00 - 000-432100Security Alarm Permit 36,000 6,130.00 34,696.00- 42,158.00 - (6,158.00) 000-435000Fire Permit7,750900.00 8,437.506,637.50 - - TOTAL Permits1,181,91393,993.60 947,870.59-1,558,508.58 - (376,595.58) Licenses 000-441000Alcohol Beverage License 6,100 50.00 - 5,892.50 5,397.50 - 000-442000Contractors License 55,447 850.00 27,953.00- 24,550.00 - 30,897.00 000-444000Pet License3,000200.00 4,073.104,677.00 - - TOTAL Licenses 64,547 1,100.00 38,522.50- 34,020.60 - 30,526.40 Fees 000-451000Municipal Court Fines 1,540,000 88,698.15 1,112,755.49- 964,064.56 - 575,935.44 000-451100Arrest Fee 60,000 3,951.60 51,822.73- 41,547.74 - 18,452.26 000-451110Expunction Fee 90 - - 60.00 30.00 - 000-451200Warrant Fees 187,500 11,292.80 118,148.65- 121,053.17 - 66,446.83 000-451320Civil Justice Fee-Court 500 5.89 56.89 62.20 - 000-451321Civil Justice Fee-State 53.12 - - 1,154.21 - - (1,154.21) 000-451340Judicial Fee - City 7,000 536.38 - 6,704.27 5,574.19 - 000-451400Traffic Fine Costs TTL 30,000 1,991.65 27,058.63- 20,954.33 - 000-451500Teen Court Admin Fee 500 - - 460.00 280.00 - 000-451510Juvenile Case Mgmt Fee 60,000 4,474.83 55,889.65- 46,480.14 - 13,519.86 000-451600Technology Fund Fee 55,000 3,576.41 45,729.75- 37,576.51 - 17,423.49 000-451700Security Fee 40,000 2,682.31 34,302.75- 28,191.39 - 11,808.61 000-451800Time Payment Fee - City 5,000 378.55 - 4,061.45 5,210.22 000-451850State Fines 10% Service Fee 70,000 18,728.87 72,008.75- 68,238.98 - 000-451900DPS Payment - Local 12,250 916.00 - 9,605.30 9,857.96 - 000-452000Child Safety Fee 8,000 217.34 - 7,069.36 9,906.56 - (1,906.56) 000-452050Indigent Defense Fee 22,500 1,750.88 21,687.34- 18,002.71 - 000-452100Platting Fees 66,000 4,000.00 55,250.00- 61,500.00 - 000-452200Site Plan Fee 26,400 3,500.00 26,949.45- 25,500.00 - 000-452300Plan Check Fee 375,000 32,578.50 332,328.41- 620,774.41 - (245,774.41) 000-452310Miscellaneous Review Fee - 5,100.00 6,300.00 - 3,600.00 - (6,300.00) 000-452320Tree Mitigation Admin Fee 11,220 - - 9,468.75 7,680.00 - 000-452400BOA/Zoning Fees 11,000 - - 8,000.00 1,400.00 - 000-452500Food Handler Class 8,000 640.00 - 4,660.00 6,110.00 - 000-452600Specific Use/Zone Chng Fee 14,630 9,500.00 - 4,000.00 21,150.00 - (6,520.00) 000-452610Plat Recording Fee - -- - - - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452710Zoning Ltr & Dev Rights--450.00450.00 - - 000-453100Reinspection Fees 49,000 1,800.00 54,143.00- 36,605.00 - 12,395.00 000-453110Swim Pool Inspection Fee - - 1,200.00 1,050.00 - - (1,050.00) 000-453120Inspections Plan Review - - 833.00 - - - 000-453200Mowing Fees - Inspections 614.83 - 2,699.56 11,981.26 - - (11,981.26) 000-453211Admin Fee-Inspections - 9,600.00 7,700.00 - 1,000.00 - (7,700.00) 000-4532153% Technology Fee - - 531.40 1.98 - 000-453310Misc Inspection Fee - - 40.00 270.00 - 000-453500SubContractor Reg. Fee 15,996.50- 25,235.00 - 1,915.00 - (25,235.00) 000-453710Foster Care 50.00 - 450.00 850.00 - - 000-454100Swim Pool Reservation Fee - 669.84 - - - 000-454200Pool Gate Admission Fee 22,000 5,278.55 23,820.37- 22,720.35 - 000-454300Seasonal Pool Pass Fee 5,500 - - 5,421.50 7,046.00 - (1,546.00) 000-456500Haz Mat Fees2,500 - - 370.00 - - 000-456510Fire Plan Review 800 - - - - - 000-456600Fire Re-inspection Fee 450 50.00 - 450.00 900.00 - 000-458100Sale of Merchandise - - - 17.00 - - 000-458300Sale of Property/Auction 20,000 72.60 20,003.26- 28,557.55 - (8,557.55) 000-458400Civic Center Rental Fees 226,000 14,287.50 151,839.29- 115,627.50 - 110,372.50 000-458401Capital Recovery Fee-Civic Cntr 390.00 - - 1,680.00 - 000-458450North Center Rental Fees 24,000 2,152.00 - 10,412.00- 000-458500Community Center Rental Fees32,000 3,067.80 31,669.26- 18,164.82 - 13,835.18 000-458550Pavilion Rental Fees - 17,922.70- - 1,035.00 000-458560Chamber of Comm rent - - - 7,800.00 - - (7,800.00) 000-458570Non-Resident SYSA League 18,000 - 34,481.00- 7,060.00 - 10,940.00 000-458600Ball Field Use - - 288.63 1.76 - - 000-458650NonResident User Fee-BVYA9,000--5,980.009,090.00 - 000-458680Tournament Fees-Soccer 14,000 - - 3,650.00 2,400.00 - 11,600.00 000-458700Vehicle Impoundment 5,000 - - 2,442.75 - - 000-459200NSF Check Fee 100 - - 179.00 328.00 - 000-459300Notary Fee 200 24.00 - 249.00 357.00 - 000-459400Maps, Copies, UDC, & Misc F 200 10.00 - 125.56 618.18 - 000-459600Animal Adoption Fee 10,500 1,218.00 10,175.00- 11,021.50 - 000-459700Pet Impoundment Fee 17,500 829.00 14,593.00- 17,621.01 - 000-459800Police Reports Fee6,532522.00 5,334.205,562.10 - - TOTAL Fees 3,073,872 227,389.56 2,411,090.64- 2,497,422.09 - 576,449.91 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines35,0002,133.1928,003.7224,173.36 - - TOTAL Fines 35,000 2,133.19 28,003.72- 24,173.36 - 10,826.64 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,078 1,756.48 19,321.28- 19,321.28 - 000-473200City of Seguin - Fire Contract 40,293 3,355.26 36,907.86- 36,907.86 - 000-473300Guad Co - Library 180,816 15,068.00 165,747.01- 150,680.00 - 30,136.00 000-473400Randolph AFB-Animal Cntrl 2,500 200.00 - 2,508.00 1,900.00 - 000-474200Library Services - Cibolo - - - 17.50 - - 000-474210Library Services-Selma 19,000 - 14,940.00- - - 19,000.00 000-474250Non-Resident Library Fees - - - - - - 000-474400Dispatch Service - Cibolo 133,305 - 133,305.00- 133,305.00 - 000-474500Dispatch Service - SCUCISD 2,080 - - 2,080.00 - - 000-474600School Crossing Guard-Bexar6,6005,890.57 6,308.4211,042.15 - - 000-474610School Cross Guard-Guadalupe3,005.79 20,459.57- - - - TOTAL Inter-Jurisdictional 405,672 29,276.10 381,117.57- 373,633.36 - 32,038.64 Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.00 65,880.00-80,520.00 - 000-480100Indirect Costs - Hotel/Motel 170,221 14,185.08 95,724.00- 156,035.90 - 14,185.10 000-481000Transfer From Reserves 98,186 - - - - - 98,185.61 000-482100Transfer From Reserves-Ct Tech - - - - - 000-482150Transfer From Court Security 58,011 - - - 58,011.00 000-485000Interfund Charge-Drainage 38,888 3,191.50 28,723.50- 35,401.50 - 000-486000Interfund Chrges-Admin W&S 624,777 52,064.75 479,210.97- 572,712.25 - 52,064.75 000-486202Transfer In-W&S - 15,420.52- - - - 000-486317Transfer From Park Fund - - 4,133.27 - - - 000-486322Transfer-In - Library Grants 10,000 - - - 10,000.00 000-486402Transfer from City Wide Projects - - 25,372.05- - - (25,372.05) 000-487000Interfund Charges-Fleet 91,737 7,442.08 59,745.03- 81,862.90 - 000-488000Interfund Charges-4B 53,000 4,416.66 41,625.00- 50,001.97 - 000-489000Transfer In -- 3.80 12,552.72 - - (12,552.72) 000-490020Transfer In-SEDC50,000 50,000.0050,000.00 - - - TOTAL Fund Transfers 1,282,660 -88,620.07 840,466.09 1,064,459.29 - 218,200.32 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 5,000 46.50 - 4,612.80 1,643.52 - 000-491200Investment Income 26,000 2,938.66 26,171.62- 32,898.59 - (6,898.59) 000-491900Unrealized Gain/Loss - 1,462.50 (17,368.82) - (341.77) - 17,368.82 000-493000Donations-Others - - - 340.00 - - 000-493120Donations-Public Library - - 14.00 - - - 000-493130Donations-Writing the Next Chap.20,000 114.00 18,182.80- 25,168.00 - (5,168.00) 000-493400Donation - Animal Control 3,670 342.86 - 5,521.41 4,705.21 - (1,035.21) 000-493401Donations-A/C Microchip 3,000 125.00 - 2,882.50 2,075.00 - 000-493402Donations-Spay&Neuter 12,000 1,502.00 11,656.50- 14,629.58 - (2,629.58) 000-493403Donations-Melvin Boeck A. S. - - - - - - 000-493460Donations-Employee Picnic 300.00 - - 300.00 (543.62) - 000-493503Donations - Fire Rescue - - - 25.00 - - 000-494481LawEnforcemtOfficersStnd&Ed 3,800 - - 3,705.94 3,550.22 - 000-494482DOJ-PD GRANT 648.99 - - 648.99 - - 000-497000Misc Income-Gen Fund 40,000 2,585.98 70,965.28- 65,896.62 - (25,896.62) 000-497005Misc Income-Publications 240,000 19,841.00 137,568.25- 139,974.05 - 100,025.95 000-497007Misc Income-Schertz Artz - - 1,000.00 - - - 000-497020Misc Income-Fleet Recycled 400 - - 250.80 - - 000-497100Misc Income-Police 20,000 981.36 32,812.92- 22,858.49 - (2,858.49) 000-497200Misc Income-Library 12,131 408.75 - 7,689.74 18,253.95 - (6,122.95) 000-497210Misc Income-Library Copier 3,400 1,494.00 5,648.45 10,871.80 - (7,471.80) 000-497300Misc Income-Animal Control 2,400 - - 1,454.99 1,506.37 - 000-497400Misc Income-Streets Dept. 11,229 3,493.50 15,225.00- 19,913.70 - (8,684.70) 000-497500Misc Income-TML Insurance 78,043 - 78,042.55- 49,728.90 - 28,314.10 000-497550Misc Income-TML Reimbursemt20,211 693.23 20,079.50- 29,053.61 - (8,842.61) 000-497600Misc Income-Parks/Vending Mach.500 222.32 -1,117.312,016.23 - (1,516.23) 000-498000Reimbursmnt-Gen Fund5,5004,638.57 3,166.3610,387.46 - - 000-498100Reimbursmnt Fire - Training - - - 1,101.00 - - (1,101.00) 000-498105Reimburmnt Police - DEA - - - 3,785.61 - - (3,785.61) 000-498110Reimbursmnt Fire - Emg. Acti-O - 30,936.01- - 21,607.94 - (30,936.01) 000-498500Settlement - Litigation 25,000.00- - - - - TOTAL Miscellaneous507,284 61,642.89 - 449,231.22 499,899.09 (543.62) 7,928.53 TOTAL REVENUES18,984,604 1,353,119.10 - 16,000,922.06 17,868,552.13 (543.62) 1,116,595.10 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking686,437.39$ Cash in Investment Pools LOGIC Investment-General Fund2,009,068.02 LOGIC Investment-Equip Replacement73,289.92 LOGIC Investment-Veh Replacement7,074.02 LOGIC Investment-Air Condi Replacment122,335.19 CAPITAL ONE Investment-General Fund1,334,216.15 Total Cash in Bank & Investment Pools$4,354,670.95 17 ADVALOREM TAX $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $- $(500,000) OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 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 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 1,223,886 886,430 492,623 1,387,876 474,014 90,756 28,206 35,521 40,691 21,925 12,579 4,162 2006-07 18-A Sales Tax - General Fund $600,000 $500,000 -1% 16% 17% $400,000 24% 23% -2% 5% 13% 11% 3% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 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 212,505 239,854 229,587 248,693 313,084 228,070 222,035 276,537 250,602 272,411 312,562 263,674 2005-06 18-B CITY PUBLIC SERVICE $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 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 57,413 38,691 42,722 60,515 2006-07 18-C C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 85,614.00 134,344.00- - - - 85,614.00 Wilenchik Walk for Life 28,000.00 - 28,926.25 30,461.91 - - (2,461.91) TML Dinner 2,100.00 - - 3,974.40 - - 2,100.00 Hal Balwin Scholarship 1,000.00 - - 245.00 23,615.00 - (22,615.00) Miscellaneous22,300.00 7.75-6,424.98469.18 - TOTAL REVENUES139,014.00 7.75 - 173,914.63 54,546.09 - 84,467.91 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 - - 232.56 200.00 - 4,550.00 Festival of Angels 13,250.00 - 10,358.65 12,654.23 102.00 - Employee Appreciation Event 5,000.00 - - 1,758.45 126.00 - 4,874.00 4th of July Jubilee - 2,210.88 (1,420.64) 2,148.47 - (1,420.64) National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 30,500.00 - 29,059.36 30,461.91 - - Blue Santa - - - - - - Schertz Fest - 455.59 311.95 455.91 - - TML Events - - 4,036.67 - - - Schertz Sweetheart 42,945.00 5,643.98 1,058.00 27,509.36 44,385.85 (244.80) Hal Baldwin Scholarship9,355.00-1,000.0010,354.11 - -(999.11) Selma-Schertz 5K400.00- 400.00- - - TOTAL CULTURAL 4,223.34106,300.00 1,513.59 76,477.88 97,617.37 2,005.67 8,190.55 TOTAL EXPENDITURES111,450.00 4,223.34 1,513.59 76,477.88 97,617.37 2,005.67 13,340.55 REVENUE OVER(UNDER) EXPEND27,564.00 (43,071.28) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking33,346.11$ Cash in Investment Pools MBIA Special Events66,547.24 Total Cash in Bank & Investment Pools$99,893.35 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises138,00031,014.33 143,734.41-195,780.20 (57,780.20)- Fees13,679,7501,621,352.55 11,462,828.53-13,151,871.28 527,878.72- Fund Transfers503,8866,718.00 59,250.03-73,898.00 429,988.00- Miscellaneous28,013.9094,230.06307,349.84 55,445 - - TOTAL REVENUES14,377,0811,687,098.7811,760,043.0313,728,899.32 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers 31,000.00- 31,000 - - - TOTAL NON DEPARTMENTAL-31,000 31,000 - - - BUSINESS OFFICE Personnel Services458,64029,652.98 384,798.30-363,103.81 95,536.19- Supplies5,549384.71-3,477.683,120.60485.94 Operations Support108,50015,610.54 92,414.28-89,194.035,105.63 Staff Support7,450155.62-1,749.422,342.36395.58 Professional Services15,501(1,503.00) 15,417.47-6,627.81- Fund Charges/Transfers40,000---- 40,000.00- Maintenance Services12,000420.00 12,057.00-5,787.95- Operating Equipmen776.10 6,117.62 t 7,300 - - - TOTAL BUSINESS OFFICE44,720.85476,294.185,987.15 654,940 -510,690.25 W & S ADMINISTRATION Personnel Services1,212,50784,412.38 1,043,275.51-1,052,849.63 159,657.79- Supplies213,5206,136.95338.73136,580.82164,568.8719,814.51 Human Services338---64.00- City Support Services51,326- 19,729.65-38,874.0511,810.75 Utility Services2,798,900286,845.39 2,080,644.14-2,139,478.89855.71 Operations Support8,750555.0179.604,368.975,822.64- Staff Support33,0002,079.351,339.0015,665.1219,209.101,609.81 City Assistance1,912145.00-763.00441.00- Professional Services177,1687,943.729,870.00115,334.23181,261.89- Fund Charges/Transfers2,368,176163,226.56 956,407.00-1,997,033.20 371,142.80- Maintenance Services4,843,250651,181.69 4,574,430.64116.414,577,733.50304.35 Other Costs25,000920.00 23,671.50-29,831.85 (4,831.85)- Debt Service1,435,165262,851.66 2,008,915.39-1,343,096.40- Rental-Leasing6,070--2,902.622,508.53- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Operating Equipment21,780 3,420.00- 20,742.70(557.74) - 4,457.30 Capital Outla - 134,001.40 y 58,000 -52,432.00 -(23,569.40) 357,830.77- - - - Water Line Relocation 260,403 TOTAL PUBLIC WORKS13,515,2651,466,297.7167,595.74 11,707,517.6534,395.1311,339,961.62 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services3,862----- Operations Support500---248.04- Professional Services64,038240.08 29,368.53-56,972.38- Maintenance Services22,299.26169,404.94314,473.42 329,044 - - 22,539.34371,693.84 TOTAL AVIATION HEIGHTS WTR IMP 397,444 -198,773.47 -25,750.16 FM3009 RD&BRIDGE EXPANSION Professional Services79,5056,417.5019,137.5014,708.0655,278.65 43,363.85- Maintenance Services65,752.04696,831.0865,789.78 137,256 - - 72,169.5419,137.50711,539.14121,068.43 TOTAL FM3009 RD&BRIDGE EXPANSION 216,761 -114,830.07 TOTAL MISC & PROJECTS94,708.8819,137.50910,312.61492,762.27 614,205 -140,580.23 TOTAL EXPENDITURES14,815,4101,605,72786,73312,760,96412,707,57440,382 ** REVENUE OVER(UNDER)EXPENSES **(438,329)1,021,325.22 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 31,014.33143,734.41195,780.20 000-421490Tower Leasing138,000 - - TOTAL Franchises 138,000 31,014.33 143,734.41- 195,780.20 - (57,780.20) Fees 000-455200Garbage Collection Fee 3,300,000 295,920.48 2,739,169.40- 2,952,593.98 - 347,406.02 000-455600Fire Line Fees 18,500 - 18,190.00- 18,430.00 - 000-455700Recycle Fee Revenue 155,000 22,840.23 138,323.55- 202,199.55 - (47,199.55) 000-455800W&S Line Constructn Reimbursemnt50,000 1,988.00 31,811.58- 28,741.60 - 21,258.40 000-457100Sale of Water 7,200,000 987,843.82 5,662,581.40- 6,948,185.09 - 251,814.91 000-457110Edwards Water Lease 127,250 - 71,997.50- 192,995.00 - (65,745.00) 000-457120Water Transfer Charge-Selma 5,000 - - 780.18 2,668.48 - 000-457130Water Transfer Charge-U. C. 1,000 - - 3,914.06 1.28 - 000-457200Sale of Meters 86,000 4,912.74 63,116.76- 68,458.32 - 17,541.68 000-457400Sewer Charges 2,560,000 291,740.31 2,583,125.25- 2,576,693.39 - (16,693.39) 000-457500Water Penalties 175,000 15,786.97 147,155.17- 158,612.57 - 16,387.43 000-459200NSF Check Fee-Water&Sewer2,000320.002,663.682,292.02 - - TOTAL Fees13,679,7501,621,352.55 11,462,828.53-13,151,871.28 527,878.72 Fund Transfers 000-486101Transfer In- General Fund423,270---- - 423,270.00 6,718.0059,250.03 73,898.00 000-486204Interfnd Chrg-Drainage Bill80,616 - - TOTAL Fund Transfers 503,886 6,718.00 59,250.03- 73,898.00 - 429,988.00 Miscellaneous 000-490000Misc Charges 15,000 240.00 11,781.21- 6,672.28 - 000-491000Interest Earned 500 58.33 - 926.79 1,303.13 - 000-491200Investment Income 5,000 324.31 36,260.60- 9,094.16 - (4,094.16) 000-493130Library Donations - - 6.36 - - - 000-493400Donations-Christmas Activitise - - - 1,000.00 - - (1,000.00) 000-496050SSLG - SAWS Reservation - - 134,500.00- - - (134,500.00) 000-497000Misc Income-W&S 20,000 479.50 18,201.59- 8,069.12 - 11,930.88 000-497550TML Reimbursements - - - 2,291.34 - - (2,291.34) 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 25,165.01- 102,014.05 -25,699.30 - (102,014.05) 000-498200W&S Project Reimbursement5,0001,212.461,888.50 - - TOTAL Miscellaneous 55,445 28,013.90 94,230.06- 307,349.84 - (251,904.84) TOTAL REVENUES14,377,0811,687,098.78 11,760,043.03- 13,728,899.32 648,181.68 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking690,024.90$ Cash in Investment Pools Lone Star Investment-Water&Sewer857,351.03 Lone Star Investment-W&S Customer Deposits293,549.14 Lone Star Investment-W&S Equip Replacement372,921.26 Lone Star Investment-W&S Veh Replacement543,763.76 Lone Star Investment-Water/SSLGC SAWS134,607.47 Schertz Bank & Trust-Certificate of Deposit1,044,420.00 $3,246,612.66 Total Cash in Bank & Investment Pools3,936,637.56$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees5,436,537 60.00 4,091,995.99- 2,680,456.17 2,756,080.83- Inter-Jurisdictional1,432,345 45,437.54 1,338,647.77- 1,365,847.34 66,497.66- Miscellaneous13,417.90-168,247.41171,339.38 334,850 - TOTAL REVENUES 58,915.44 - 5,598,891.17 4,217,642.89 - 2,986,089.11 7,203,732 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,391,410183,942.69 2,261,281.89-2,336,201.2896.00 Supplies 17,518.95 382.34 279,067.79 267,878.03 40,880.25 327,874 Human Services - - 614.00 847 - - City Support Services 14,850.78- 10,974.19 15,000 - - 4,025.81 Utility Services 10,211.25 72,094.15- 98,093.82 80,438 - (17,655.82) Operations Support 2,441.13 29,027.05- 39,880.11 2,382.85 33,500 Staff Support 4,258.52 171.35 79,988.88 59,538.32 7,298.04 75,600 City Assistance 705.00 10,193.84- 11,781.80 500.00 13,753 Professional Services 5,562.96 160.00 109,141.69 107,632.80 1,978.46 136,390 Fund Charges/Transfers3,576,092 9,825.00 3,076,385.08- 333,750.94 - 3,242,341.06 Maintenance Services 27,735.10- 21,779.91 42,320 - - 20,540.09 Debt Service 170,714.17- 242,270.49 248,502 - - 6,231.51 Rental-Leasing - 9,315.13 3,604.76 36,395.24 40,000 - - Operating Equipment 9,222.70 44,013.22- 33,629.38 4,490.90 74,600 Capital Outlay-42,644.25 - - - - TOTAL PUBLIC SAFETY 243,688.20 713.69 6,226,453.02 3,567,629.83 57,626.50 3,431,783.36 7,056,326 TOTAL EXPENDITURE 243,688.20713.696,226,453.023,567,629.8357,626.50 S 7,056,326 ** REVENUE OVER(UNDER) EXPENSES 650,013.06 * 147,406 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt5,336,537 - - 4,078,928.99 2,661,756.17 - 2,674,780.83 49.88% 000-456110Subscription Program Fees100,000 60.00 - 13,047.00 18,700.00 18.70% - 81,300.00 20.00- 000-459200NSF Check Fee - - - - - TOTAL Fees5,436,537 60.00 4,091,995.99- 2,680,456.17 2,756,080.83- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.87 - 262,282.57 263,382.50 92.05% - 22,743.50 000-474300Cibolo Support219,699 213,300.00- 213,300.00 - - 6,399.00 000-475100Comal Co ESD #6 18,960.0075,369 36,586.88- 56,880.00 - 18,489.00 000-475200Live Oak Support 152,569 148,125.00- 148,125.00 - - 4,444.00 000-475300Universal City Support 210,545 204,412.52- 204,412.52 - - 6,132.48 000-475400Selma Support 64,689 62,805.00- 68,730.00 - - (4,041.00) 000-475500Schertz Support 399,083 387,459.48- 387,459.48 - - 11,623.52 000-475600Santa Clara Support 10,851 2,633.67 10,653.16- 10,534.68 - 000-475800Marion Support13,41413,023.1613,023.16 - - - TOTAL Inter-Jurisdictional1,432,345 45,437.54 1,338,647.77- 1,365,847.34 66,497.66- Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 34.76 - 222.49 520.97 - - (520.97) 000-493203Donations-EMS 6,000 - 1,252.75 11,450.00 - - (5,450.00) 000-493204Donations-Dilworth Fund - 1,000.00- - - - (1,000.00) 000-493205Donations- Golf Tournament - 4,430.00- - - - (4,430.00) 000-497000Misc Income 150,000 2,893.14 92,141.99- 74,496.00 - 75,504.00 000-497100Recovery of Bad Debt 100,000 30.00 10,712.36- 11,022.41 - 88,977.59 000-497500Misc Income-EMT Classes78,85063,917.8268,420.00 10,460.00 - - TOTAL Miscellaneous 334,850 13,417.90 168,247.41- 171,339.38 - 163,510.62 TOTAL REVENUES7,203,732 58,915.44 5,598,891.17- 4,217,642.89 2,986,089.11- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank $ (262,707.74) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010300,714.08 Total Cash in Bank & Investment Pools$38,006.34 27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 675,30067,727.30 621,419.56- 648,746.90 -26,553.10 Miscellaneous1,3001,442.90986.83 58.90 - - TOTAL REVENUES 67,786.20676,600622,862.46 -649,733.73 - 26,866.27 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 361,18326,382.51 302,009.01- 314,934.10 -46,248.90 Supplies 8,300 278.31 28.15 2,687.17 3,468.91 502.18 Human Services 100 - - - - -100.00 City Support Services 20,000 - 3,476.00 5,832.18 - -14,167.82 Utility Services 19,388 1,813.46 11,546.34- 15,585.27 855.71 Operations Support 2,458 - - - - -2,458.00 Staff Support 8,255 760.29 168.83 3,361.39 4,428.91 627.72 City Assistance 840 - 102.00 15.00 - -825.00 Professional Services 19,800 1,377.03 - 6,697.10 16,548.52 -3,251.48 Fund Charges/Transfers 195,44910,838.25 96,977.33- 119,515.75 -75,933.25 Maintenance Services 22,000 - 4,663.26 1,987.00 - -20,013.00 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 18,138 17,566.89- 18,137.56 100.00% - - Rental/Leasing500-- - - -500.00 Operating Equipment116.00- - - - - - TOTAL DRAINAGE 41,449.85676,511196.98449,302.49 1,985.61500,553.20174,168.75 TOTAL EXPENDITURE 41,449.85676,511196.98449,302.49 1,985.61500,553.20174,168.75 S ** REVENUE OVER(UNDER) EXPEND89149,180.53 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 3,547.53 3,966.71 3,500 349.53 -(466.71) 000-457600Drainage Fee 67,377.77-617,872.03644,780.19 -27,019.81 671,800 TOTAL Fees67,727.30 621,419.56-648,746.90 26,553.10- 675,300 Miscellaneous 000-491000Interest Earned - 201.58 235.74 100 7.98 -(135.74) 000-491200Investment Interest - 672.91 580.21 600 41.68 - 000-497000Misc Income-Drainage-568.41170.88 600 9.24 - TOTAL Miscellaneous - 1,442.90 986.83 1,300 58.90 -313.17 TOTAL REVENUES67,786.20 622,862.46-649,733.73 26,866.27- 676,600 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Ban k Claim on Operating Cash Pool-Checking 77,455.00 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,035.65 Total Cash in Bank & Investment Pools$360,490.65 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 385,000 47,468.17 274,340.61- 269,920.61 -115,079.39 Fund Transfers 55,000 - - - - -55,000 Miscellaneous 33.425,550-375.16959.28 - TOTAL REVENUES 47,501.59445,550-274,715.77270,879.89 - EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services 31,841 - - - - -31,841.00 Supplies 8,312 - - 2,315.40 1,388.92 - City Support Services 78,228 502.85 65,465.80 59,630.85 - -19,100.00 Operations Support 80,112 2,902.75 - 1,886.00 12,292.6814,047.52 Professional Services 2,500 - 902.28 2,500.00 - - -100.00% Fund Charges/Transfers 231,485 14,185.08 180,968.00- 156,035.90 -75,449.10 Operating Equipment - 542.98 - - - - -0.00% Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 17,087.83432,478502.85249,765.06232,774.83 L 15,436.44 TOTAL EXPENDITURE 17,087.83432,478502.85249,765.06232,774.83 S 15,436.44 REVENUE OVER(UNDER) EXPENDITURE13,072 38,105.06 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax385,000 47,468.17274,340.61269,920.61 -115,079.39 - TOTAL Taxes 385,00047,468.17 274,340.61- 269,920.61 - 115,079.39 Fund Transfers 000-481000Transfer From Reserve55,000 ---55,000.00 - - TOTAL Fund Transfers 55,000 - - - - - 55,000.00 Miscellaneous 000-491000Interest Earned250-246.65242.55 97.02% 2 2.87 - 000-491200Investment Interest 300 - 128.51 116.73 1 0.55 - 183.27 000-497000Misc Income -5,000-600.004,400.00 - - TOTAL Miscellaneous5,550-375.16959.28 3 3.42 - 4,590.72 TOTAL REVENUES 445,55047,501.59 274,715.77- 270,879.89 - 174,670.11 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking190,363.73$ Cash in Investment Pools Federated Investment-Hotel/Motel78,118.53 Total Cash in Bank & Investment Pools$268,482.26 33 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 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 18,245 18,817 18,521 15,970 17,948 19,220 24,257 22,590 22,959 25,887 27,316 26,568 2006-07 34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 40,000 220,000.00- 107,000.00 - -(67,000.00) Tree Mitigation Fees 40,000 53,756.25- 43,520.00 - -(3,520.00) Miscellaneous405-3,374.73596.50 52.06 - TOTAL REVENUES 52.0680,405-277,130.98151,116.50 - EXPENDITURE SUMMARY PARKLAND DEDICATION Maintenance Services-Landscape 8,000 - 1,621.36 28,399.00 - -(20,399.00) Operating Equipment 30,000 78,762.61 51,768.48 (10,902.45)378.20 -11,244.23 Capital Outlay6,000--4,980.30 - - TOTAL PARKLAND DEDICATION -44,00011,244.2380,383.9785,147.78 378.20 TREE MITIGATION Fund Charges/Transfers - 4,133.27 - - - - -0.00% Maintenance Services-Trees 36,000 78,285.67 31,869.55 -3,133.00 -7,263.45 Capital Outlay--- - - - - TOTAL TREE MITIGATION -36,0003,133.0082,418.9431,869.55 - TOTAL EXPENDITURE -80,00014,377.23162,802.91117,017.33 S 378.20 REVENUE OVER(UNDER) EXPEND40534,099.17 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 40,000 220,000.00- 107,000.00 (67,000.00)- - 000-458900Tree Mitigation -40,00053,756.25 -43,520.00 - TOTAL Fees 80,000 273,756.25- 150,520.00 (70,520.00)- - Miscellaneous 000-491000Interest Earned 60 6.15 - 203.42 214.61 (154.61)- 000-491200Investment Interest 280 45.91 - 393.81 381.89 (101.89)- 000-497000Miscellaneous Income652,777.50-- - - TOTAL Miscellaneous40552.06-3,374.73596.50 (191.50)- TOTAL REVENUES 80,405 52.06 277,130.98- 151,116.50 (70,711.50)- 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking$54,142.07 Cash in Investment Pools Federated Investment-Park Fund252,666.11 Federated Investment-Tree Mitigation126,221.96 Total in Investment Pool 378,888.07 Total Cash in Bank & Investment Pools$433,030.14 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer 31,000 - 31,000.00- - - - 100.00% Miscellaneous -25,000--- - 25,000.00 TOTAL REVENUES -56,000--31,000.00 - 25,000.00 EXPENDITURE SUMMARY NONDEPARTMENTAL Payable to Waste Contractor -56,000-33,453.88- - 56,000.00 TOTAL NONDEPARTMENTA -56,000-33,453.88- L - 56,000.00 TOTAL EXPENDITURE -56,000-33,453.88- S - 56,000.00 REVENUE OVER(UNDER) EXPEND31,000.00 - - 38 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S -31,000--31,000.00 - - TOTAL Fund Transfers31,000- 31,000.00- - - -100.00% Miscellaneous 000-490210Sale of Recycle Material25,000 ----25,000.00 - TOTAL Miscellaneous 25,000 - - - - -25,000.00 TOTAL REVENUES 56,000 - - 31,000 - - 25,000 39 RECYCLE FUND CASH IN BANK AS OF: AUGUST 31st, 2011 Cash in Bank (27,365.47) Claim on Operating Cash Pool-Checking $(27,365.47) Total Cash in Bank 40 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees1,190,640 173,350.04 1,245,996.20- 2,333,569.81 -(1,142,929.81) Fund Transfers - - - - 0.00% - - Miscellaneous 31,276.95585,500187,045.81322,619.69 - - TOTAL REVENUES 204,626.991,776,1401,433,042.01 -2,656,189.50 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Operations Support1,000---- -1,000.00 Professional Services 26,800 353.48 - 3,977.58 1,121,525.77 -(1,094,725.77) Fund Charges/Transfers - 100,000.00- -100,000.00 -(100,000.00) Debt Service - 118,896.50- - 0.00% - - Capital Outlay8,428.00-8,428.00 - - - TOTAL NON DEPARTMENTA 100,353.4827,8008,428.00122,874.08 -1,229,953.77(1,193,725.77) L MISC & PROJECTS Projects 230,2001,116.8653,906.7823,185.8692,698.20 136.79 Schaefer RD Water Improvements 599,643-- - - -599,643.00 Northcliffe Elevated Tnk-- 0.00% - - - - Northcliffe Water Plant- 0.00% - - -19,759.00 - Town Creek Project-- 0.00% - - - - Live Oak Water Plant38,106.38 -(166,425.36) -558,515.60 -(38,106.38) Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP -88,252225,148.72163,496.58344,233.90 A - TOTAL MISC & PROJECTS (165,308.50)918,095279,055.50764,957.04475,038.48 136.79 TOTAL EXPENDITURE (64,955.02)945,895287,483.50887,831.12 136.791,704,992.25 S REVENUE OVER(UNDER) EXPENDITURES830,245 951,197 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 904,200 95,352.00 809,636.19- 1,273,031.74 - (368,831.74) 000-455910Capital Recovery - Waste Wtr272,800 77,998.04 435,310.01- 836,139.78 - (563,339.78) 000-455911Capital Recovery-Wste Wtr Zone 113,640 - - - - - 13,640.00 000-455913Cap Recovery-North Sewer Tr1,050.00224,398.29 - - - - TOTAL Fees1,190,640173,350.04 1,245,996.20- 2,333,569.81 195.99% - (1,142,929.81) Fund Transfers 000-481000Transfer from Reserves - - - 0.00% - - - 000-486100Transfer In- - - - - - TOTAL Fund Transfers--- 0.00% - - - Miscellaneous 000-491000Interest Earned 2,000 45.19 - 3,165.62 482.72 - 1,517.28 000-491200Investment Income 250,000 3,331.71 - 4,630.22 35,637.89 - 214,362.11 000-491900Unrealized Gain/Loss-Cap One - (19,209.22)- -108.39 - 19,209.22 000-498100Reimbursmnt - FM 78 Project 50,000 4,166.66 37,499.97- 45,833.30 - 4,166.70 000-498200Re-imbursement-Water Meters283,500 23,625.00141,750.00259,875.00 - - TOTAL Miscellaneous 585,500 31,276.95 187,045.81- 322,619.69 - 262,880.31 TOTAL REVENUES1,776,140204,626.99 1,433,042.01- 2,656,189.50 - (880,049.50) 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking101,330.01$ Cash in Investments: Lone Star Investment-Capital Recovery Water452,499.32 Lone Star Investment-Capital Recovery Sewer280,317.51 Capital One-Investment1,709,014.62 Schertz Bank & Trust-Certificate of Deposit525,203.25 Total Cash in Bank & Investment Pools$3,068,364.71 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ****************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 9,955.873,368,794 - 3,358,237.97 3,417,743.66 101.45% -(48,949.66) Fund Transfers243,000 - - - - 0.00% -243,000.00 Miscellaneous3,000 10.083,327.5315,493.92 - - TOTAL REVENUES 9,965.953,614,7943,361,565.50 -3,433,237.58 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services3,200 400.00 - 2,750.00 1,150.00 35.94% -2,050.00 Debt Service3,611,124 -3,563,623.75 -3,625,353.50 - TOTAL GENERAL GOVERNMEN 400.003,614,3243,566,373.75 -3,626,503.50 T - TOTAL EXPENDITURE 400.003,614,3243,566,373.75 -3,626,503.50 S - ** REVENUE OVER(UNDER) EXPEND470(193,265.92) 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue3,368,7949,955.873,358,237.973,417,743.66 - - TOTAL Taxes3,368,7949,955.87 3,358,237.97-3,417,743.66 -(48,949.66) Fund Transfers 000-486000Transfer From Reserves243,000 - - - - -243,000.00 -- 000-486103Transfer In - - - - TOTAL Fund Transfers 243,000 - - - - -243,000.00 Miscellaneous 000-491000Interest Earned 1,500 1.52 - 1,692.74 14,436.81 -(12,936.81) 000-491200Investment Earnings1,5008.561,634.791,057.11 - - TOTAL Miscellaneous3,00010.08-3,327.5315,493.92 -(12,493.92) TOTAL REVENUES3,614,794 9,965.95 3,361,565.50- 3,433,237.58 -181,556.42 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 505-TAX I & S***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent3,200400.002,750.001,150.00 - - TOTAL Professional Services3,200400.00-2,750.001,150.00 -2,050.00 Debt Service 101-555612Schertz C O SR2001-Principal210,000 - - 200,000.00 285,000.00 -(75,000.00) 101-555612.1Schertz CO BOND, 2001-Interest141,318 - - 149,980.00 80,502.08 -60,815.92 101-555622Schertz C O SR2003-Principal190,000 - - 180,000.00 190,000.00 - 101-555622.1Schertz C O SR2003-Interest 60,820 - 67,480.00- 60,820.00 - 101-555624Comm Proj Bond-SR04-Principal325,000 - 325,000.00- 325,000.00 - 101-555624.1Comm Proj Bond SR04-Interest265,009 - 279,226.88- 265,008.13 - 101-555626LS&D SR2006-Principal - 100,000.00- - - - 101-555626.1LS&D SR2006-Interest 650,982 - 652,981.25- 650,981.25 - 101-555628CO Bond 2007-Principal 99,567 - 92,933.33- 99,709.25 - 101-555628.1CO Bond 2007-Interest 26,617 - 15,030.52- 26,523.79 - 101-555629GO Bond 2007-Principal 275,000 - 250,000.00- 275,000.00 - 101-555629.1GO Bond 2007-Interest 209,097 - 234,677.81- 209,096.25 - 101-555630GO Bond SR2008 Principal 355,000 - 235,000.00- 355,000.00 - 101-555630.1GO Bond SR2008 Interest 379,651 - 391,833.75- 379,650.25 - 101-555631GO Bond SR2009 Principal 140,000 - 80,000.00- 140,000.00 - 101-555631.1BO Bond SR2009 Interest -283,063309,480.21283,062.50 - - TOTAL Debt Service3,611,124- 3,563,623.75-3,625,353.50 -(14,229.50) TOTAL EXPENDITURES3,614,324 400.00 3,566,373.75- 3,626,503.50 -(12,179.50) 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking4,311.73$ Cash in Investment Pools MBIA Investment- Tax I&S88,579.87 Federated Investment-Tax I&S56.78 Total Cash in Bank & Investment Pools$92,948.38 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,035,795226,531.39 1,542,865.01- 1,712,111.92 - 323,683.08 Fund Transfers - - 100,000 -100,000 - (100,000) Miscellaneous 142.1978,00038,522.40 -15,661.25 - ,,,.,,. -,,. TOTALREVENUES211379532667358158138741182777317286 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 23,000 1,836.15 623.28 13,983.54 18,960.56 1,441.28 Utility Service 85,800 6,379.96 71,094.73- 57,286.68 - 28,513.32 Maintenance Services 65,300 1,510.26 5,965.50 36,668.69 56,113.50 10,275.58 Operating Equipment 8,498 18,494.00- 6,999.31 - - 1,498.69 Capital Outlay -6,999.31-- - - TOTAL NONDEPARTMENTA 9,726.37182,59813,588.09140,240.96 11,716.86139,360.0545,109.18 L ECONOMIC DEVELOPMEN T Personnel Services 202,062 8,631.37 222,262.40- 141,888.74 - 60,173.26 Supplies 2,000 176.68 - 572.32 884.02 1,183.19 103.36% Human Services 100 - - - 54.00 54.00% - City Support Services 33,500 623.92 41,975.99 16,659.44 2,230.47 - Utility Services 4,850 136.56 - 3,391.69 2,621.49 - 2,228.51 Operations Support 76,100 256.01 3,242.89 56,290.50 51,503.79 1,192.61 Staff Support 97,000 1,046.28 1,782.11 98,927.02 72,275.30 1,189.94 City Assistance 80,000 - - - - - 80,000.00 Professional Services 379,000 24,157.59 21,340.80 182,776.83 205,790.16 763.88 193,786.76 Fund Charges/Transfers 105,432 4,416.66 91,625.00- 100,001.97 - 5,430.03 Fund Replenish-Fund Balance 216,000 - - - - - 216,000.00 Maintenance Services - 781.89 - 0.00% - - - Debt Service 792,432 536,176.71- 792,432.00 100.00% - - Operating Equipment -1,500245,730.74 -1,112.82 - TOTAL ECONO DEVELOPMEN 38,821.151,989,97626,989.721,480,511.09 6,614.091,385,169.73625,181.90 T TOTAL EXPENDITURE 48,547.522,172,57440,577.811,620,752.05 18,330.951,524,529.78670,291.08 S ** REVENUE OVER(UNDER) EXPEND(58,779) 303,243.39 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,035,795226,531.391,542,865.011,712,111.92 - - TOTAL Taxes2,035,795226,531.39 1,542,865.01- 1,712,111.92 -323,683.08 Fund Transfers 000-486000Transfer In100,000.00 100,000.00- - - - TOTAL Fund Transfers- 100,000.00- -100,000.00 -(100,000.00) Miscellaneous 000-491000Interest Earned 1,000 52.59 - 645.17 241.83 - 000-491200Investment Earnings 12,000 89.60 27,123.92- 9,924.72 -2,075.28 000-497000Misc Income 15,000 10,753.31- 5,494.70 - -9,505.30 000-499000Transfer From Reserves50,000 -- - - - TOTAL Miscellaneous 78,000 142.19 38,522.40- 15,661.25 - TOTAL REVENUES2,113,795326,673.58 1,581,387.41- 1,827,773.17 -286,021.83 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking328,425.20$ Cash in Investment Pools MBIA Investment-Economic Development Corp1,015,561.45 MBIA-Investment-EDC Notes 2010- Schertz Bank & Trust-Certificate of Deposit506,068.72 Schertz Bank & Trust-Certificate of Deposit1,031,406.35 Total Cash in Bank & Investment Pools2,881,461.72$ 50 4B SALES TAX $300,000 $250,000 -1% 16% 17% $200,000 23% 24% 5% -2% 14% 11% 3% $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 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 139,231 152,929 133,224 140,960 179,416 118,361 125,387 159,802 150,107 153,348 191,371 149,102 2006-07 51 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING AUGUST 31st, 2011 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,757,497.52,789,429.46.1000,043,050.81,074,982.75,757,497.52,757,497.52 205522 TOTAL OPERATIONS2,757,497.52,789,429.46,043,050.81,074,982.75,757,497.52,757,497.52 25522 LOGIC General Fund2,009,068.02,008,801.98.138066.04,000,000.00,009,068.02 N/A,009,068.02 302122 G/F-Equipment Replacement73,289.9273,281.330.1380 -8.5973,289.92 N/A73,289.92 G/F-Vehicle Replacement7,074.02,073.19.1380 -.83,074.02 N/A,074.02 70077 G/F-Air Conditioner Replacement122,335.19122,320.850.1380 -14.34122,335.19 N/A122,335.19 ,155,948.62.138052.73-,156,201.35,156,201.35 SR2009 Bond-Street Projects(II)2,156,201.35 20222 TOTAL LOGIC4,367,968.50,367,425.9742.53,000,000.00,367,968.50,367,968.50 55144 LONESTA R Capital Recovery - Sewer280,317.51-0.1700 -280,317.51280,317.51 N/A280,317.51 Capital Recovery - Water452,499.3261,812.83.1700 -90,686.4952,499.32 N/A52,499.32 20144 Drainage Fund283,035.65282,993.970.1700 -41.68283,035.65 N/A283,035.65 GO SR2011 Animal Shelter2,267,230.22,266,896.34.1700 -33.88,267,230.22 N/A,267,230.22 20322 GO SR2011 Athletic Fields1,491,047.431,490,827.850.1700 -219.581,491,047.43 N/A1,491,047.43 GO SR2011 Soccer Fields1,511,486.80,511,264.21.1700 -22.59,511,486.80 N/A,511,486.80 10211 GO SR2011 Swimming Pool3,022,973.603,022,528.420.1700 -445.183,022,973.60 N/A3,022,973.60 W/S-Customer Deposits293,549.1493,505.91.1700 -3.2393,549.14 N/A93,549.14 20422 W/S-Equipment Repl/Cap.Imp372,921.26372,866.340.1700 -54.92372,921.26 N/A372,921.26 Water&Sewer857,351.0357,224.77.1700 -26.2657,351.03 N/A57,351.03 80188 W/S-Vehicle Replacement543,763.76543,683.680.1700 -80.08543,763.76 N/A543,763.76 34,587.65.17009.82-34,607.4734,607.47 Water/SSLG - SAWS134,607.47 10111 TOTAL LONESTA10,777,966.360,776,379.14 -,587.220,777,966.360,777,966.36 R1111 MBIA Tax I&S88,579.8769,032.030.1400 -19,547.8488,579.87 N/A88,579.87 Police Forfeiture359,074.8359,033.30.1400 -1.5359,074.83 N/A59,074.83 30433 Economic Development Corporation1,015,561.45715,477.570.1400 -300,083.881,015,561.45 N/A1,015,561.45 Special Events Fund66,547.246,539.49.1400 -.756,547.24 N/A6,547.24 60766 SEDC Tax Notes 2010-153,594.750.14005.72153,600.47-- 00,679.32.14004.76-00,714.0800,714.08 EMS Tax Notes 2010300,714.08 30333 TOTAL MBIA1,830,477.47,664,356.4619,721.4853,600.47,830,477.47,830,477.47 13111 FEDERATED SR2007a Bond-City Wide Projects867,634.71982,325.190.1400122.48114,812.96867,634.71 N/A867,634.71 Hotel Occupancy Tax78,118.538,107.98.1400 -0.558,118.53 N/A8,118.53 70177 Park Fund (Developers Fee)252,666.11252,632.000.1400 -34.11252,666.11 N/A252,666.11 Park Fund (Tree Mitigation)126,221.9626,210.16.1100 -1.8026,221.96 N/A26,221.96 10111 Tax I&S56.7856.770.1100 -0.0156.78 N/A56.78 4,670.29.1400.04-4,676.334,676.33 Library Board Fund44,676.33 40644 TOTAL FEDERATED1,369,374.42,484,002.3984.9914,812.96,369,374.42,369,374.42 11111 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,275,550.581,309,035.252.3700 375.610.261,308,659.90 N/A1,334,216.15 ,716,036.96.0700.35353.48,715,683.83,709,014.62 Capital One Capital Recovery1,641,101.68 12011 TOTAL CAPITAL ONE2,916,652.26,025,072.21 729.09.61,024,343.73,043,230.77 3033 52 City Portfolio By Investment Type Schertz Bank &Trust C.D.s 10% Operations Account Schertz Bank & Trust 5% Capital One Managed 9% FEDERATED Pool 21% MBIA Pool 16% LONESTAR Pool 13% 54 City Portfolio By Use Pooled-Daily Operations, $2,757,498 Designated Funds, $7,011,261 Special Revenue Funds, $5,907,038 Debt Service Fund $809,074.07 MONTHLY YIELDS 2.50 2.00 1.50 1.00 0.50 0.00 OCT-10NOV-10DEC-10JAN-11FEB-11MAR-11APR-11MAY-11JUN-11JUL-11AUG-11SEP-11 0.13000.18000.07000.15000.13000.05000.02000.04000.01000.16000.0100 1 Month T-Bill 0.11700.17000.12000.15000.15000.09000.04000.06000.03000.10000.0200 3 Month T-Bill 0.16500.21000.19000.17000.18000.17000.11000.12000.10000.16000.0500 6 Month T-Bill 0.61000.61000.58000.52000.53000.54000.45000.45000.44400.44090.4500 Schertz Portfolio 0.15000.15000.1500 JPMorgan Chase 0.25000.25000.25000.10000.10000.10000.10000.10000.10000.10000.1000 Schertz Bank&Trust 0.22940.22440.21380.20900.20840.21000.20000.17850.17450.14240.1380 LOGIC 0.28000.25000.24000.24000.24000.24000.23000.22000.20000.17000.1700 LoneStar 0.26000.24000.23000.22000.18000.17000.17000.16000.16000.14000.1400 MBIA 0.13000.21000.19000.19000.18000.18000.15000.12000.11000.10000.1400 Federated 2.22002.24002.24002.24002.24002.24002.21002.20002.20002.20002.2000 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:8/31/2011 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69130,550.5830,550.5830,550.583.000.01 Bank of Amer NA Disc Bank Accpt 10/17/201147.0065,000.0064,886.2564,801.570.000.00 General Elec Cap Corp Disc Com Paper3/12/2012194.0065,000.0064,891.2264,891.220.000.00 59,964.6059,964.60 JPMorgan Chase Disc Bank Accpt Note9/28/201128.0060,000.00 Total Cash & Equivalent20,550.5220,292.620,207.9 s28527 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012413.00150,000.00162,031.50157,173.006,750.00 Federal Home Loan Bks Cons Bds10/28/201158.00135,000.00135,000.00135,024.30337.00 Federal Home Ln Mtg Corp Disc Nts Dtd10/7/201137.00100,000.0099,746.5099,771.510.00 Federal Home Ln Mtg Corp Deb11/15/2013807.00170,000.00191,084.25186,921.808,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013755.00250,000.00250,000.00270,575.0010,937.00 250,505.00252,637.50 Federal Natl Mtg Assn 4/20/2012233.00250,000.00 Total Fixed Incom,055,000.01,088,367.2,102,103.11 e10513 Total Assets379.841,275,550.581,308,659.901,322,311.083 Cap Recovery Fun d Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #69141,101.6841,101.6841,101.684.000.01 Bank of Amer N A Disc Bankers Accp Prgm10/17/201147.0085,000.0084,851.2584,740.520.000.00 General Elec Cap Corp Disc Coml Paper3/12/2012194.0085,000.0084,857.7484,857.740.000.00 79,952.8079,952.80 JPMorgan Chase Disc Bank Accpt Note9/28/201128.0080,000.00 Total Cash & Equivalent91,101.6290,763.490,652.7 s28724 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012413.00250,000.00270,052.50261,955.0011,250.00 Federal Home Loan Bks Cons Bds10/28/201158.00175,000.00175,000.00175,031.50437.000.25 Federal Home Ln Mtg Corp Disc Nts10/7/201137.00125,000.00124,683.13124,714.370.000.00 Federal Home Ln Mtg Corp Deb11/15/2013807.00250,000.00281,006.25274,885.0012,187.004.34 Federal Natl Mtg Assn Nts10/15/2013776.00200,000.00223,001.60217,972.009,250.004.15 Federal Natl Mtg Assn10/30/2012426.00250,000.00250,192.50250,935.001,250.000.50 US Treasury Note12/15/2011106.00100,000.00100,984.38100,329.00 Total Fixed Incom,350,000.01,424,920.3,405,821.8 e106173 Total Assets388.241,641,101.681,715,683.831,696,474.613