Loading...
10-JULY 2011 STATEMENT JULY 2011 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department August 26, 2011 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes10,912,656 383,447.28 9,058,565.97- 10,495,773.49 416,882.51- Franchises 1,521,000 6,022.72 1,081,850.90- 1,132,920.49 -388,079.51 Permits 1,181,913 55,154.00 841,170.32- 1,464,514.98 -(282,601.98) Licenses 64,547 2,067.50 35,575.00- 32,920.60 -31,626.40 Fees 3,073,872 163,813.58 2,176,084.82- 2,269,592.69 -804,279.31 Fines 35,000 2,481.86 25,802.16- 22,040.17 -12,959.83 Inter-Jurisdictional 405,672 56,728.86 360,245.66- 344,357.26 -61,314.74 Fund Transfers 1,282,660 90,095.08 840,466.09- 975,839.22 -306,820.39 Miscellaneous507,28421,766.19444,105.11430,911.08 - - TOTAL REVENUES18,984,604781,577.0714,863,866.0317,168,869.98 - - - EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,800 1,813.46 - 8,654.57 18,998.91 - Supplies500 - - 164.23 239.97 93.10 166.93 City Support Services20,500 52.99 - 12,227.87 13,447.67 - Operations Support300 - - 161.30 161.35 - Staff Support16,4001,351.40380.00 9,658.7713,131.67401.52 Operating Equipment -- - - - - TOTAL CITY COUNCIL60,5003,217.85380.0030,866.7445,979.57494.62 CITY MANAGE R Personnel Services 56,798.74753,457 - 556,217.53 592,479.26 -160,977.74 Supplies4,526 461.36 - 1,394.49 1,266.68 432.94 2,826.38 - - 32.00 - City Support Services - - Operations Support - - 178.00 - - - Staff Support 33,850 1,894.68 438.80 21,247.37 21,251.93 3,010.54 203.34 1,596.70- Operating Equipment1,574 - - TOTAL CITY MANAGER 59,358.12793,407 438.80 579,069.39 616,594.57 3,443.48 173,807.75 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services 18,808.99250,203 - 183,042.99 196,806.00 -53,397.00 Supplies3,200 240.97 - 874.20 938.31 113.13 2,148.56 City Support Services1,000 - - - - - Operations Support3,000 - - 2,253.00 1,951.00 - Staff Support6,200 - 33.44 2,072.33 2,042.13 280.80 3,910.51 Court Support800 - - - - - Professional Services 84,600 2,546.25 41,467.98- 40,990.25 7,761.25 Maintenance Services 2,500 - - - 600.00 - Operating Equipment2,000250.00 900.00903.98 - - TOTAL MUNICIPAL COURT 21,846.21353,503 33.44 230,614.48 244,227.69 8,155.18 101,153.57 CUSTOMER RELATIONS-311 Personnel Services88,928 6,325.73 - 71,913.51 67,089.66 -21,838.34 Supplies500 33.79 - 81.95 267.87 - Staff Support1,105 1,069.97- - - - TOTAL CUSTOMER RELATIONS-311 90,533 6,359.52 71,995.46- 68,427.50 -22,105.50 PLANNING & ZONING Personnel Services 134,105 9,996.53 102,535.17- 108,181.25 -25,923.75 Supplies 4,500 14.55 - 339.13 273.94 275.01 City Support Services - - - - - - Operations Support 2,300 - - 183.16 77.95 - Staff Support 22,100 225.00 1,527.12 7,392.03 3,705.75 225.00 Professional Services 142,300 5,506.98 - 62,858.46- 161.05 Operating Equipment600 1,055.0054.98 - - - TOTAL PLANNING & ZONING 305,905 15,743.06 1,527.12 110,504.47 176,152.35 661.06 LEGAL SERVICES Operations Support 13,000 74.88 - 7,624.24 9,199.04 - Professional Services245,00039,093.24130,327.37175,247.92 - - TOTAL LEGAL SERVICES 258,000 39,168.12 137,951.61- 184,446.96 -73,553.04 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services 47,663.83628,024 - 463,884.73 503,779.43 -124,244.57 Supplies59,900 1,955.54 638.43 42,144.25 51,344.95 5,488.99 3,704.49 Utility Services93,600 13,075.68 - 78,525.00 65,712.73 -27,887.27 - - - - Operations Support - - Staff Support 10,212 739.31 403.00 4,965.53 8,775.88 631.59 Maintenance Services 110,500 11,069.39 6,471.04 84,071.28 101,163.90 11,057.81 Rental/Leasing 2,000 - - 832.35 763.92 - Operating Equipment950 1,685.651,278.55409.00 - - 2,524.53- Capital Outlay24,500 - - - TOTAL FACILITIES MAINTENANCE 929,686 74,503.75 7,512.47 676,108.79 735,343.89 17,587.39 CITY SECRETARY Personnel Services 12,289.52167,842 - 130,905.09 131,694.16 -36,147.84 Supplies1,550 34.11 - 793.85 1,143.20 - City Support Services 6,788 - - 4,574.71 6,788.22 - Operations Support - - - - - - Staff Support5,700392.42295.00 3,787.943,097.64 - TOTAL CITY SECRETARY 181,880 12,716.05 295.00 139,371.29 143,413.52 -38,761.70 NON-DEPARTMENTA L Supplies 3,000 - - 4,786.32 405.35 - City Support Services 349,407 - 760.00 342,994.70 282,111.46 70.00 Operations Support 115,500 11,201.74 98,434.48- 114,627.20 108.18 Staff Support - - - - 80.00 - City Assistance 390,552 96,864.87 523,612.54- 422,942.47 -(32,390.47) Professional Services 99,521 176.01 55,778.72- 48,332.98 -51,188.02 Fund Chrgs/Transfrs-Spec Events Fnd 122,536 - 49,192.21- - -122,535.61 Operating Equipment 500 - - 264.95 - - 34,794.51 - Capital Outlay7,000 - - - TOTAL NON-DEPARTMENTAL 1,088,016 108,242.62 760.00 868,419.461,109,858.43 258.18 220,097.97 PUBLIC AFFAIRS Personnel Services 11,476.12138,096 - 173,152.53 118,534.32 -19,561.68 Supplies2,450 156.42 - 2,087.02 829.33 432.74 1,187.93 Operations Support34,500 3,133.18 - 47,435.56 18,626.97 1,197.55 14,675.48 Staff Support3,750 168.57 - 4,113.98 2,124.13 172.39 1,453.48 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Professional Services - 226,898.33- - - - Operating Equipment6,000 2,737.182,926.20 - - - TOTAL PUBLIC AFFAIRS184,79614,934.29 456,613.62-142,851.931,802.68 RECORDS MANAGEMEN T Personnel Services46,3173,505.15 35,344.85-37,047.37 - Supplies 900 11.78 - 27.68 244.05 - Staff Support 1,500 30.00 - 729.09 845.14 - Professional Services 17,992 1,509.87 - 5,637.40 10,184.01 - -- Operating Equipment - - - - TOTAL RECORDS MANAGEMENT 66,709 5,056.80 41,739.02- 48,320.57 -18,388.43 SCHERTZ TALES MAGAZINE Personnel Services 9,860.38126,426 - - 100,257.01 -26,168.99 49.58 - - 49.58 Opperations Support - - Staff Support 1,000 - - - 15.00 23.28 Professional Services258,50030,744.00 202,938.98-8,452.86 - TOTAL SCHERTZ TALES MAGAZINE385,92640,653.96- 303,260.57-8,476.14 ENGINEERING Personnel Services 169,469 12,348.59 127,483.40- 130,986.17 -38,482.83 Supplies 300 55.09 - 59.38 183.03 - Staff Support 2,213 259.00 - 1,130.00 876.00 248.12 Professional Services 24,000 675.00 - 8,203.43 19,066.25 - Maintenance Services 4,044 99.00 - 1,200.00 2,844.24 - -- Operating Equipment - - - - TOTAL ENGINEERING 200,026 13,436.68 138,076.21- 153,955.69 248.12 GIS Personnel Services 117,358 8,921.35 90,260.55- 93,038.63 -24,319.37 Supplies 3,300 309.97 - 108.00 1,422.97 1,113.00 Staff Support 1,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 123,708 9,231.32 90,368.55- 94,461.60 1,113.00 TOTAL GENERAL GOVERNMENT 5,022,595 424,468.35 10,946.83 3,813,138.06 3,825,855.87 42,239.85 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC SAFETY POLICE Personnel Services4,083,030 298,674.91 - 3,280,417.03 3,353,708.22 -729,321.78 Supplies49,058 1,562.31 124.50 14,298.81 16,581.72 11,529.35 21,071.43 City Support Services30,000 - - 32,003.00 - -30,000.00 Utility Services100,000 9,722.48 - 71,482.29 79,127.13 -20,872.87 Operations Support2,000 - - 365.00 193.00 - Staff Support34,450 1,327.03 - 6,466.98 10,174.94 9,788.11 14,486.95 City Assistance13,000 - - 5,235.95 2,903.18 3,446.25 6,650.57 Professional Services8,000 4,900.00 - 4,903.36 6,830.16 400.00 769.84 Maintenance Services77,449 - 179.50 41,657.36 29,395.80 1,941.56 46,291.14 Operating Equipment65,596 - 5,196.00 36,081.00 48,665.87 1,396.90 20,729.23 Capital Outlay166,298114,837.60153,726.40 - - - TOTAL POLICE 4,628,881316,186.735,500.003,607,748.383,701,306.4228,502.17 FIRE RESCUE Personnel Services 2,410,836 180,010.63 1,805,646.25- 1,948,573.33 -462,262.67 Supplies 20,200 563.68 20.15 8,562.40 5,620.30 190.05 Utility Services 43,900 5,639.78 41,809.30- 39,837.27 - Operations Support 1,100 - - 419.97 567.00 120.00 Staff Support 108,800 5,387.89 12,138.00 58,516.66 77,025.08 24,611.54 City Assistance 18,600 10,323.17- 2,715.75 10,777.25 7,147.46 Professional Services 18,140 - - 13,040.00- 1,200.00 Maintenance Services 55,000 1,575.00 18,234.44- 26,944.63 8,476.98 352.22604.5016,623.68 31,152.9015,959.00 Operating Equipment52,400 TOTAL FIRE 2,728,976 193,529.20 23,085.82 1,952,528.45 2,153,537.76 57,705.03 INSPECTIONS Personnel Services 364,194 27,479.26 274,339.90- 289,635.44 -74,558.56 Supplies 6,750 265.60 375.00 1,021.92 1,359.42 448.34 Utility Services 7,600 570.58 - 3,150.29 4,268.48 - Operations Support 3,200 - - 415.00 838.87 - Staff Support 14,700 208.00 388.20 3,879.22 3,074.75 946.70 Professional Services 10,000 - - 5,240.47 - -10,000.00 Maintenance Services - - - - - - Operating Equipment -- - - - - TOTAL INSPECTIONS 406,444 28,523.44 763.20 288,046.80 299,176.96 1,395.04 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MARSHAL SERVICE Personnel Services 38,062.93486,250 - 291,135.94 364,716.73 -121,533.27 Supplies6,450 60.79 - 1,200.77 1,153.74 205.82 5,090.44 Utility Services9,000 1,306.69 - 4,905.21 7,780.73 - Operations Support4,000 - - 434.50 1,595.39 2,305.00 99.61 Staff Support9,400 370.40 - 2,653.13 2,392.57 625.66 6,381.77 - - - - Professional Services - - Maintenance Services 12,400 1,305.00 - 3,532.53 9,724.85 161.00 Operating Equipment21,480 13,117.11-2,635.45 - - 6,047.40 56,197.43- Capital Outlay65,600 - - TOTAL MARSHAL SERVICE 614,580 47,153.21 303,862.08- 456,678.55 5,932.93 TOTAL PUBLIC SAFETY 8,378,881 585,392.58 29,349.02 6,152,185.71 6,610,699.69 93,535.17 PUBLIC ENVIRONMENT STREETS Personnel Services596,591 40,795.18 - 464,557.20 458,014.65 -138,576.35 Supplies6,120 417.04 28.15 3,713.44 4,191.63 294.22 1,662.30 Utility Services101,900 10,386.95 - 86,484.16 90,119.17 132.98 11,647.85 Operations Support1,380 - - - - 21.00 1,359.00 Staff Support9,265 815.69 84.08 5,135.46 6,030.92 299.02 3,019.14 Maintenance Services156,875 11,358.32 16,620.12 76,699.05 135,195.58 2,947.34 35,352.21 Rental/Lease200 - - - - - Operating Equipment 4,380 - - 116.00 4,379.99 - Capital Outlay14,500805.96 14,475.96- - - TOTAL STREETS 891,211 64,579.14 16,732.35 636,705.31 712,407.90 3,694.56 TOTAL PUBLIC ENVIRONMENT 891,211 64,579.14 16,732.35 636,705.31 712,407.90 3,694.56 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PARKS & RECREATION PARKS DEPARTMENT Personnel Services475,862 36,117.13 - 369,087.57 377,584.14 -98,277.86 Supplies40,355 1,355.32 - 48,642.87 25,527.08 2,305.94 12,522.00 - - 163.25 - City Support Services - - Utility Services 110,000 22,723.13 91,945.20- 103,123.08 132.98 Operations Support 700 - 600.00 - 880.80 - Staff Support 7,686 235.80 202.35 7,175.59 6,226.41 1,018.05 Professional Services 53,278 10,714.50 - 3,661.80 37,059.50 7,143.00 Maintenance Services 21,000 5,461.39 33,303.93- 19,508.44 536.21 Rental/Leasing 30,531 3,225.40 3,491.50 12,584.75 33,502.23 1,900.00 Operating Equipment 200 - - 5,974.00 3,494.99 (99.98) Capital Outlay7,000 2,893.50-689.05 - - TOTAL PARKS DEPARTMENT746,61279,832.674,293.85572,538.96609,800.1713,625.25 SWIM POOL Supplies 16,700 301.16 123.66 14,119.95 11,347.17 2,789.29 Utility Services 25,500 2,870.63 18,937.99- 14,372.75 -11,127.25 Staff Support 925 - - 439.98 166.09 - Maintenance Services 199,378 - 133,563.82- 127,064.27 1,293.63 378.00300.00 Rental/Lease500 - - - TOTAL SWIM POOL 3,171.79243,003 123.66 167,361.74 153,328.28 4,082.92 85,715.46 COMMUNITY/CIVIC CENTER Personnel Services112,341 8,379.94 - 60,085.95 65,460.66 -46,880.34 Supplies6,423 397.84 - 5,240.48 6,625.78 2,000.44 (2,203.22) Utility Services47,150 5,672.39 - 32,973.50 29,193.20 113.05 17,843.75 Operations Support14,682 1,125.00 - 16,993.11 7,924.26 20.95 6,736.79 Staff Support3,250 20.00 - 529.45 614.47 278.46 2,357.07 Professional Services600 - - - 975.00 - Operating Equipment7,17233,303.10 285.005,591.60 - - TOTAL COMMUNITY/CIVIC CNTR 191,618 15,595.17 149,125.59- 111,078.37 8,004.50 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET SENIOR CITIZEN CENTER - - 124.57 - Supplies - - Utility Services - - 3,348.96 278.31 - - City Assistence - 11,350.00- - - - Maintenance Services -1,082.50 - - - - TOTAL SENIOR CITIZEN CENTER- 15,906.03-278.31 - - TOTAL PARKS & RECREATION 1,181,233 98,599.63 4,417.51 904,932.32 874,485.13 25,712.67 CULTURAL LIBRARY Personnel Services 52,587.52667,832 - 486,215.71 541,972.94 -125,859.06 Supplies16,400 3,050.04 - 12,478.11 9,722.83 2,689.07 3,988.10 Utility Services39,500 5,142.28 - 39,850.27 36,065.95 - Operations Support2,500 1,040.20 - 1,290.00 1,110.20 - Staff Support4,185 54.00 23.25 2,750.39 1,435.40 123.43 2,649.42 Professional Services2,100 - - 200.68 2,065.00 - Maintenance Services 3,500 - - 3,096.25 1,200.00 - Operating Equipment 65,000 4,903.73 47.36 56,342.77 55,838.30 3,293.86 Capital Outlay10,500.00 10,500.00- - - - TOTAL LIBRARY 801,017 66,777.77 10,570.61 602,224.18 659,910.62 6,106.36 TOTAL CULTURAL 801,017 66,777.77 10,570.61 602,224.18 659,910.62 6,106.36 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICE S Personnel Services 18,968.77302,083 - 211,216.76 240,536.06 -61,546.94 Supplies24,900 1,829.22 42.00 16,562.57 15,772.54 785.69 8,383.77 Utility Services9,900 1,234.60 - 6,833.36 8,422.20 - Operations Support800 - - 263.00 - - Staff Support 5,800 29.08 - 5,037.60 1,981.08 - City Assistance 13,000 647.16 - 5,755.19 8,023.64 - Professional Services 14,500 958.50 11,059.20- 9,140.50 180.00 Maintenance Services 6,100 818.38 (112.00) 1,563.83 3,364.61 390.00 Operating Equipment9,000203.50 866.164,420.3478.18 - 3,995.00- Capital Outlay4,000 - - - TOTAL ANIMAL SERVICES 390,083 24,689.21 (70.00) 259,157.67 295,655.97 1,433.87 TOTAL HEALTH 390,083 24,689.21 (70.00) 259,157.67 295,655.97 1,433.87 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 20,267.66261,085 - 180,849.95 209,308.68 -51,776.32 Supplies1,500 - - 532.15 1,090.52 - City Support Services 337,952 33,005.05 148,970.49- 211,383.85 5,435.00 Utility Services 147,131 15,331.28 91,340.96- 113,739.22 37.50 Staff Support 10,400 (283.50) 1,813.95 3,776.89 6,102.52 3,818.60 Professional Services - - - - - - Maintenance Services 21,100 - 24,517.43- 15,082.52 - Operating Equipment 135,836 3,354.26 71,124.02- 77,266.62 31,988.08 10,527.00 45,780.00 Capital Outlay45,809 - - - TOTAL INFORMATION TECHNOLOGY 960,813 71,674.75 1,813.95 531,638.89 679,753.93 41,279.18 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services222,521 14,469.83 - 166,332.07 167,418.08 4,024.81 51,078.11 Supplies1,700 - - 536.86 539.32 - Human Services46,122 3,367.11 - 30,270.86 28,033.89 34.00 18,054.11 Operations Support12,545 1,065.12 266.28 12,802.27 9,317.21 2,445.44 1,048.63 Staff Support10,982 75.31 - 6,163.94 6,567.49 - City Assistance9,425 473.00 - 7,812.00 5,731.00 515.00 3,179.00 Professional Services2,500 - - - - - -1,491.55 Operating Equipment - - - - TOTAL HUMAN RESOURCES 19,450.37305,795 266.28 225,409.55 217,606.99 7,019.25 81,435.04 FINANCE Personnel Services419,818 31,795.33 - 323,814.44 332,878.92 -86,939.08 Supplies3,600 173.42 (99.58) 2,838.16 2,140.11 - Operations Support1,050 - - 155.80 342.57 133.36 574.07 Staff Support13,370 166.80 74.30 5,619.39 9,155.08 - Maintenance Services630 - - - - - 1,077.80- Operating Equipment5,699 - - - TOTAL FINANCE 444,167 32,135.55 (25.28) 332,427.79 345,594.48 133.36 PURCHASING & ASSET MGT Personnel Services 17,798.80234,220 - 185,585.94 187,222.36 -46,997.64 Supplies2,350 87.41 - 509.78 644.57 62.26 1,643.17 Utility Services1,150 80.68 - 330.76 327.46 - Operations Support 150 - - - 60.68 - Staff Support 6,900 - - 4,930.15 5,087.30 172.00 Operating Equipment150 -- - - - TOTAL PURCHASING & ASSET MGT244,92017,966.89 191,356.63-193,342.37234.26 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services148,533 15,931.41 - 118,388.63 129,080.15 -19,452.85 Supplies101,000 11,201.92 4,701.70 86,231.29 89,912.98 9,622.73 6,165.99 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,000 548.36 - 5,301.79 3,997.25 - Operations Support 400 375.00 - - 750.00 - Staff Support 2,935 256.75 - 1,286.69 1,802.62 178.72 Professional Services - - - - - - Maintenance Services 45,250 2,384.48 474.24 31,739.43 47,968.97 3,898.45 Rental/Lease200 -150.00 - - - 3,973.90-139.99 Operating Equipment6,000 - - TOTAL FLEET SERVICE 312,818 30,697.92 5,175.94 244,447.83 279,135.87 13,839.89 TOTAL INTERNAL SERVICE 2,268,513 171,925.48 7,230.89 1,525,280.69 1,715,433.64 62,505.94 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 - 10,500.00 42,000.00- Senior Citizen's Hot Meals42,000 - - TOTAL CITY ASSISTANCE 52,000 10,500.00 10,000.00- 52,214.21 - COURT - RESTRICTED FUNDS Operating Equipment 1,090.0059.9812,527.40 - - - TOTAL CITY ASSISTANCE - - 59.98 1,090.00 12,527.40 - TOTAL MISC & PROJECTS 52,000 10,500 - 10,060 53,304 12,527 TOTAL EXPENDITURES18,985,5331,446,932.16 79,177.21 13,903,683.9214,747,753.03247,755.82 REVENUE OVER(UNDER) EXPEND.(930)2,421,116.95 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,704,566 26,142.58 6,261,001.02- 6,738,872.25 - (34,306.25) 000-411200Advalorem Tax - Delinquent 50,000 2,813.83 55,923.47- 46,505.18 - 000-411300Advalorem Tax - P&I 50,000 3,701.31 41,656.82- 39,977.07 - 10,022.93 000-411500Sales Tax Revenue-Gen Fund4,071,590 342,512.61 2,664,156.99- 3,635,656.70 - 435,933.30 000-411600Bingo Tax 4,500 - - 3,684.07 1,132.33 - 000-411700Mixed Beverage Ta8,276.9532,143.6033,629.96 x 32,000.00 - - TOTAL Taxes10,912,656 383,447.28 9,058,565.97- 10,495,773.49 416,882.51 Franchises 000-421200Center Point/Entex Energy 33,000 - 23,991.96- 36,110.15 - (3,110.15) 000-421220City Public Service 275,000 - 202,098.02- 213,685.81 - 61,314.19 000-421240Guadalupe Valley Elec Co-op 430,000 - 349,689.22- 311,679.19 - 118,320.81 000-421250New Braunfels Utilities 30,000 6,022.72 12,228.49- 19,060.08 - 10,939.92 000-421300Time Warner-State Franchise 350,000 - 245,855.96- 249,675.43 - 100,324.57 000-421350Time Warner-PEG Fee 62,000 - 46,299.97- 48,761.43 - 13,238.57 000-421460AT&T Franchise Fee 220,000 - 114,263.25- 119,684.64 - 100,315.36 000-421465AT&T PEG Fees 16,000 - 12,782.24 17,533.57 - (1,533.57) 000-421480Other Telecom Franchise 15,000 - - 8,639.66 38,441.11 - (23,441.11) 000-421500Solid Waste Franchise Fee90,00066,002.1378,289.08 - - - TOTAL Franchises1,521,0006,022.72 1,081,850.90-1,132,920.49 - 388,079.51 Permits 000-431100Home Occupation Permit 770 - - 455.00 280.00 - 000-431200Building Permit 837,952 34,535.00 585,327.52- 1,154,991.83 - (317,039.83) 000-431300Mobile Home Permit 671 - - 80.00 80.00 - 000-431400Signs Permit 8,596 75.00 - 420.00 690.00 - 000-431500Food Establishmnt Permit 15,000 200.00 13,750.00- 14,370.00 - 000-431600Garage Sale Permit 9,554 1,200.00 10,015.30- 9,650.00 - 000-431700Plumbing Permit 109,769 5,539.00 73,089.50- 98,727.65 - 11,041.35 000-431750Electrical Permit 63,062 2,680.00 47,715.50- 61,700.00 - 000-431800Mechanical Permit 84,211 4,660.00 64,914.00- 71,340.00 - 12,871.00 000-431900Solicitor/Peddler Permit 770.00 - 930.00 1,940.00 - - (1,940.00) 000-431950Animal/Pet Permit 2,000 130.00 - 1,920.00 1,630.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt6,578750.00-4,900.005,550.00 - 000-432100Security Alarm Permit 36,000 4,015.00 31,766.00- 36,028.00 - 000-435000Fire Permit7,750600.00 7,537.505,887.50 - - TOTAL Permits1,181,91355,154.00 841,170.32-1,464,514.98 - (282,601.98) Licenses 000-441000Alcohol Beverage License 6,100 837.50 - 5,430.00 5,347.50 - 000-442000Contractors License 55,447 900.00 25,853.00- 23,700.00 - 31,747.00 000-444000Pet License3,000330.00 3,873.104,292.00 - - TOTAL Licenses 64,547 2,067.50 35,575.00- 32,920.60 - 31,626.40 Fees 000-451000Municipal Court Fines 1,540,000 78,312.53 1,007,622.13- 874,755.41 - 665,244.59 000-451100Arrest Fee 60,000 3,331.19 46,956.18- 37,596.14 - 22,403.86 000-451110Expunction Fee 90 - - 60.00 30.00 - 000-451200Warrant Fees 187,500 8,670.70 106,527.65- 109,760.37 - 77,739.63 000-451320Civil Justice Fee-Court 500 5.07 49.47 56.31 - 000-451321Civil Justice Fee-State 45.83 - - 1,101.09 - - (1,101.09) 000-451340Judicial Fee - City 7,000 445.46 - 6,080.08 5,037.81 - 000-451400Traffic Fine Costs TTL 30,000 1,686.56 24,536.71- 18,962.68 - 11,037.32 000-451500Teen Court Admin Fee 500 20.00 - 460.00 280.00 - 000-451510Juvenile Case Mgmt Fee 60,000 3,716.79 50,663.66- 42,005.31 - 17,994.69 000-451600Technology Fund Fee 55,000 2,958.91 41,404.12- 34,000.10 - 20,999.90 000-451700Security Fee 40,000 2,219.19 31,065.28- 25,509.08 - 14,490.92 000-451800Time Payment Fee - City 5,000 287.63 - 3,487.95 4,831.67 000-451850State Fines 10% Service Fee 70,000 - 72,008.75- 49,510.11 - 20,489.89 000-451900DPS Payment - Local 12,250 716.00 - 8,636.25 8,941.96 - 000-452000Child Safety Fee 8,000 365.36 - 6,907.89 9,689.22 - (1,689.22) 000-452050Indigent Defense Fee 22,500 1,449.20 19,643.49- 16,251.83 - 000-452100Platting Fees 66,000 6,500.00 43,250.00- 57,500.00 - 000-452200Site Plan Fee 26,400 500.00 26,449.45- 22,000.00 - 000-452300Plan Check Fee 375,000 19,549.50 296,140.41- 588,195.91 - (213,195.91) 000-452310Miscellaneous Review Fee - - 5,100.00 2,700.00 - - (2,700.00) 000-452320Tree Mitigation Admin Fee 11,220 - - 9,468.75 7,680.00 - 000-452400BOA/Zoning Fees 11,000 - - 7,300.00 1,400.00 - 000-452500Food Handler Class 8,000 260.00 - 3,860.00 5,470.00 - 000-452600Specific Use/Zone Chng Fee 14,630 - - 4,000.00 11,650.00 - 000-452610Plat Recording Fee - -- - - - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452710Zoning Ltr & Dev Rights75.00-375.00450.00 - - 000-453100Reinspection Fees 49,000 2,550.00 43,593.02- 34,805.00 - 14,195.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 - - 2,589.56 11,366.43 - - (11,366.43) 000-453211Admin Fee-Inspections 200.00 - 7,400.00 6,700.00 - - (6,700.00) 000-4532153% Technology Fee - - 531.40 1.98 - 000-453310Misc Inspection Fee 230.00 - 40.00 270.00 - 000-453500SubContractor Reg. Fee 15,111.50- 23,320.00 - 2,225.00 - (23,320.00) 000-453710Foster Care 150.00 - 450.00 800.00 - - 000-454100Swim Pool Reservation Fee - 669.84 - - - 000-454200Pool Gate Admission Fee 22,000 7,396.80 17,530.37- 17,441.80 - 000-454300Seasonal Pool Pass Fee 5,500 545.00 - 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 150.00 - 450.00 850.00 - 000-458100Sale of Merchandise - - - 17.00 - - 000-458300Sale of Property/Auction 20,000 2,152.16 19,160.62- 28,656.11 - (8,656.11) 000-458400Civic Center Rental Fees 226,000 6,385.00 135,985.49- 101,340.00 - 124,660.00 000-458401Capital Recovery Fee-Civic Cntr 90.00 - - 1,290.00 - 000-458450North Center Rental Fees 24,000 894.00 - - 8,260.00 000-458500Community Center Rental Fees32,000 1,856.70 28,308.26- 15,097.02 - 16,902.98 000-458550Pavilion Rental Fees - 16,887.70- - 2,825.00 000-458560Chamber of Comm rent - - 7,800.00 - 1,950.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 - - 139.00 328.00 - 000-459300Notary Fee 200 18.00 - 225.00 333.00 - 000-459400Maps, Copies, UDC, & Misc F 200 - - 125.56 608.18 - 000-459600Animal Adoption Fee 10,500 1,192.00 - 9,320.00 9,803.50 - 000-459700Pet Impoundment Fee 17,500 1,391.00 12,635.00- 16,792.01 - 000-459800Police Reports Fee6,532498.00 4,812.205,100.10 - - TOTAL Fees 3,073,872 163,813.58 2,176,084.82- 2,269,592.69 - 804,279.31 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines35,0002,481.8625,802.1622,040.17 - - TOTAL Fines 35,000 2,481.86 25,802.16- 22,040.17 - 12,959.83 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,078 1,756.48 17,564.80- 17,564.80 - 000-473200City of Seguin - Fire Contract 40,293 3,355.26 33,552.60- 33,552.60 - 000-473300Guad Co - Library 180,816 15,068.00 150,679.10- 135,612.00 - 45,204.00 000-473400Randolph AFB-Animal Cntrl 2,500 - - 2,408.00 1,700.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 33,326.25 133,305.00- 133,305.00 - 000-474500Dispatch Service - SCUCISD 2,080 - - 2,080.00 - - 000-474600School Crossing Guard-Bexar6,600 5,716.165,151.58 - - - 000-474610School Cross Guard-Guadalupe3,222.87 17,453.78- - - - TOTAL Inter-Jurisdictional 405,672 56,728.86 360,245.66- 344,357.26 - 61,314.74 Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.00 65,880.00-73,200.00 - 14,640.00 000-480100Indirect Costs - Hotel/Motel 170,221 14,185.08 95,724.00- 141,850.82 - 28,370.18 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- 32,210.00 - 000-486000Interfund Chrges-Admin W&S 624,777 52,064.75 479,210.97- 520,647.50 - 104,129.50 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- 74,420.82 - 17,316.18 000-488000Interfund Charges-4B 53,000 4,416.66 41,625.00- 45,585.31 - 000-489000Transfer In - 3.80 12,552.72 - 1,475.01 - (12,552.72) 000-490020Transfer In-SEDC50,000 50,000.0050,000.00 - - - TOTAL Fund Transfers 1,282,660 -90,095.08 840,466.09 975,839.22 - 306,820.39 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 5,000 12.04 - 4,552.98 1,597.02 - 000-491200Investment Income 26,000 3,041.07 24,532.17- 29,959.93 - (3,959.93) 000-491900Unrealized Gain/Loss - 408.75 (17,027.05) - (1,639.80) - 17,027.05 000-493000Donations-Others - - - 340.00 - - 000-493120Donations-Public Library - - 14.00 - - - 000-493130Donations-Writing the Next Chap.20,000 239.00 17,558.80- 25,054.00 - (5,054.00) 000-493400Donation - Animal Control 3,670 1,006.05 - 4,325.41 4,362.35 - 000-493401Donations-A/C Microchip 3,000 180.00 - 2,757.50 1,950.00 - 000-493402Donations-Spay&Neuter 12,000 1,108.50 10,565.00- 13,127.58 - (1,127.58) 000-493403Donations-Melvin Boeck A. S. - - - - - - 000-493503Donations - Fire Rescue - - - 25.00 - - 000-494481LawEnforcemtOfficersStnd&Ed 3,800 - - 3,705.94 3,550.22 - 000-495015Contribution from SED - - - - - - 000-497000Misc Income-Gen Fund 40,000 86.12 97,216.12- 55,965.52 - (15,965.52) 000-497005Misc Income-Publications 240,000 9,383.95 118,992.25- 120,133.05 - 119,866.95 000-497007Misc Income-Schertz Artz - - 1,000.00 - - - 000-497020Misc Income-Fleet Recycled 400 - - 250.80 - - 000-497100Misc Income-Police 20,000 900.00 30,365.80- 21,877.13 - (1,877.13) 000-497200Misc Income-Library 12,131 355.75 - 7,145.13 17,845.20 - (5,714.20) 000-497210Misc Income-Library Copier 3,400 1,071.15 4,293.55 9,377.80 - (5,977.80) 000-497300Misc Income-Animal Control 2,400 - - 1,581.49 1,506.37 - 000-497400Misc Income-Streets Dept. 11,229 575.00 13,050.00- 16,420.20 - (5,191.20) 000-497500Misc Income-TML Insurance 78,043 - 78,042.55- 49,728.90 - 28,314.10 000-497550Misc Income-TML Reimbursemt20,211 3,636.40 19,667.02- 28,360.38 - (8,149.38) 000-497600Misc Income-Parks/Vending Mach.500 431.19 - 913.49 1,793.91 - (1,293.91) 000-498000Reimbursmnt-Gen Fund5,5001,124.77-3,166.365,748.89 - 000-498100Reimbursmnt Fire - Training 255.00 - - 1,101.00 - - (1,101.00) 000-498105Reimburmnt Police - DEA - - - 3,785.61 - - (3,785.61) 000-498110Reimbursmnt Fire - Emg. Acti-O - - - 9,328.07 - - (9,328.07) 000-498500Settlement - Litigation 25,000.00- - - - - TOTAL Miscellaneous507,284 21,766.19 - 444,105.11 430,911.08 - 76,372.92 TOTAL REVENUES18,984,604 781,577.07 14,863,866.03-17,168,869.98 1,815,733.63 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking293,062.61$ Cash in Investment Pools LOGIC Investment-General Fund3,008,801.98 LOGIC Investment-Equip Replacement73,281.33 LOGIC Investment-Veh Replacement7,073.19 LOGIC Investment-Air Condi Replacment122,320.85 CAPITAL ONE Investment-General Fund1,332,184.67 Total Cash in Bank & Investment Pools$4,958,974.89 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 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 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 $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 83,433 62,692 67,561 - 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: JULY 31st, 2011 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET83.33% 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 37.89-6,063.18461.43 - TOTAL REVENUES139,014.00 37.89 - 173,552.83 54,538.34 - 84,475.66 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 200.00 - 232.56 200.00 - 4,550.00 Festival of Angels 13,250.00 - 10,358.65 12,645.61 102.00 - Employee Appreciation Event 5,000.00 - - 1,758.45 126.00 - 4,874.00 4th of July Jubilee - - 2,210.88 2,287.23- - 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 316.75 1,058.00 20,879.38 38,741.87 2,488.91 Hal Baldwin Scholarship9,355.00-1,000.0010,354.11 - -(999.11) Selma-Schertz 5K400.00- 400.00- - - TOTAL CULTURAL 516.75106,300.00 1,513.59 69,847.90 93,385.41 4,878.14 9,550.04 TOTAL EXPENDITURES111,450.00 516.75 1,513.59 69,847.90 93,385.41 4,878.14 14,700.04 REVENUE OVER(UNDER) EXPEND27,564.00 (38,847.07) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking37,564.82$ Cash in Investment Pools MBIA Special Events66,531.60 Total Cash in Bank & Investment Pools$104,096.42 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises138,000- 141,234.41-164,765.87 (26,765.87)- Fees13,679,750937,561.83 10,267,910.62-11,530,518.73 2,149,231.27- Fund Transfers503,8866,718.00 59,250.03-67,180.00 436,706.00- Miscellaneous4,760.1189,069.14274,617.69 55,445 - - TOTAL REVENUES14,377,081949,039.9410,557,464.2012,037,082.29 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers 31,000.00- 31,000 - - - TOTAL NON DEPARTMENTAL-31,000 31,000 - - - BUSINESS OFFICE Personnel Services458,64029,833.09 347,523.13-333,450.83 125,189.17- Supplies6,04956.90-3,422.982,735.89266.40 Operations Support108,50010,030.78 76,940.95-73,583.4911.18 Staff Support8,450163.33-1,659.902,186.74176.99 Professional Services14,501(1,459.76) 14,129.19-8,130.81- Fund Charges/Transfers40,000---- 40,000.00- Maintenance Services12,000840.00 11,417.00-5,367.95- Operating Equipmen776.10 6,117.62 t 6,800 - - - TOTAL BUSINESS OFFICE39,464.34431,573.33454.57 654,940 -455,869.25 W & S ADMINISTRATION Personnel Services1,212,50786,563.01 957,905.52-968,437.25 244,070.17- Supplies213,5206,961.75338.73102,874.88157,403.332,954.92 Human Services338---64.00- City Support Services51,326- 19,729.65-38,874.059,240.00 Utility Services2,798,900164,563.05 1,867,267.15-1,852,633.50132.97 Operations Support8,7502,196.3479.604,368.975,267.63- Staff Support33,000806.811,339.0014,024.2317,129.751,264.06 City Assistance1,912--763.00296.00- Professional Services177,1682,281.759,870.00109,968.84173,318.17675.00 Fund Charges/Transfers2,368,176270,380.04 848,013.13-1,833,806.64 534,369.36- Maintenance Services4,843,250259,417.43 4,124,308.00116.413,926,551.81147,666.46 Other Costs25,000- 23,671.50-28,911.85 (3,911.85)- Debt Service1,435,165461,969.14 1,283,677.92-1,080,244.74235,060.00 Rental-Leasing6,070--2,656.892,508.53- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% 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,255,139.3267,595.74 10,240,191.35396,993.419,716,502.71 2,945,676.40 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services3,862----- Operations Support500---248.04- Professional Services64,0381,282.05 29,368.53-56,732.30- Maintenance Services53,284.48169,404.94292,174.1624,343.97 329,044 - 54,566.53349,154.5024,343.97 TOTAL AVIATION HEIGHTS WTR IMP 397,444 -198,773.47 FM3009 RD&BRIDGE EXPANSION Professional Services79,5056,454.3419,137.5014,708.0648,861.15 49,781.35- Maintenance Services696,741.0837.74 137,256 - - - 6,454.34 711,44919,138 48,898.89 TOTAL FM3009 RD&BRIDGE EXPANSION 216,761 -186,999.61 TOTAL MISC & PROJECTS61,020.8719,137.50910,222.61398,053.3924,343.97 614,205 TOTAL EXPENDITURES14,815,4101,355,62586,73311,082,59511,100,818421,792 ** REVENUE OVER(UNDER)EXPENSES **(438,329)936,264.22 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 141,234.41164,765.87 000-421490Tower Leasing138,000 - - - TOTAL Franchises 138,000 - 141,234.41- 164,765.87 - (26,765.87) Fees 000-455200Garbage Collection Fee 3,300,000 216,969.53 2,482,299.21- 2,656,673.50 - 643,326.50 000-455600Fire Line Fees 18,500 - 18,190.00- 18,430.00 - 000-455700Recycle Fee Revenue 155,000 13,766.12 125,506.46- 179,359.32 - (24,359.32) 000-455800W&S Line Constructn Reimbursemnt50,000 5,218.68 29,343.58- 26,753.60 - 23,246.40 000-457100Sale of Water 7,200,000 509,168.35 4,983,160.36- 5,960,341.27 - 1,239,658.73 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 3,179.74 56,788.68- 63,545.58 - 22,454.42 000-457400Sewer Charges 2,560,000 170,794.41 2,359,592.09- 2,284,953.08 - 275,046.92 000-457500Water Penalties 175,000 18,265.00 133,976.99- 142,825.60 - 32,174.40 000-459200NSF Check Fee-Water&Sewer2,000200.002,361.511,972.02 - - TOTAL Fees13,679,750937,561.83 10,267,910.62-11,530,518.73 2,149,231.27 Fund Transfers 000-486101Transfer In- General Fund423,270---- - 423,270.00 6,718.0059,250.03 67,180.00 000-486204Interfnd Chrg-Drainage Bill80,616 - - TOTAL Fund Transfers 503,886 6,718.00 59,250.03- 67,180.00 - 436,706.00 Miscellaneous 000-490000Misc Charges 15,000 - 11,781.21- 6,432.28 - 000-491000Interest Earned 500 50.78 - 909.06 1,244.80 - 000-491200Investment Income 5,000 367.50 35,588.98- 8,769.85 - (3,769.85) 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 4,341.83 13,730.02- 2,871.37 - 17,128.63 000-497550TML Reimbursements - - - 2,291.34 - - (2,291.34) 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC - 25,165.01- 76,314.75 - - (76,314.75) 000-498200W&S Project Reimbursement5,0001,888.50 - - - TOTAL Miscellaneous 55,445 4,760.11 89,069.14- 274,617.69 - (219,172.69) TOTAL REVENUES14,377,081 949,039.94 - 10,557,464.20 12,037,082.29 - 2,339,998.71 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking570,494.21$ Cash in Investment Pools Lone Star Investment-Water&Sewer857,224.77 Lone Star Investment-W&S Customer Deposits293,505.91 Lone Star Investment-W&S Equip Replacement372,865.34 Lone Star Investment-W&S Veh Replacement543,683.68 Schertz Bank & Trust-Certificate of Deposit1,044,420.00 $3,111,699.70 Total Cash in Bank & Investment Pools3,682,193.91$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees5,436,537 256,907.43 3,709,574.09- 2,680,396.17 2,756,140.83- Inter-Jurisdictional1,432,345 282,606.41 1,314,803.90- 1,320,409.80 111,935.20- Miscellaneous14,811.04-150,820.35157,921.48 334,850 - TOTAL REVENUES 554,324.88 - 5,175,198.34 4,158,727.45 - 3,045,004.55 7,203,732 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,391,410195,855.78 2,077,944.53-2,152,258.59348.00 Supplies 21,236.16 382.34 269,273.78 249,034.62 49,274.65 327,874 Human Services - - 614.00 847 - - City Support Services 14,850.78- 10,974.19 15,000 - - 4,025.81 Utility Services 12,116.65 63,211.51- 87,882.57 80,438 - (7,444.57) Operations Support 561.72 28,989.47- 37,438.98 1,902.09 33,500 Staff Support 7,110.17 171.35 76,643.97 55,279.80 8,797.13 75,600 City Assistance 925.00 10,193.84- 11,076.80 250.00 11,753 Professional Services 5,613.19 160.00 104,277.66 102,069.84 2,128.46 136,390 Fund Charges/Transfers3,576,092 9,825.00 2,794,227.34- 323,925.94 - 3,252,166.06 Maintenance Services 27,735.10- 21,779.91 42,320 - - 20,540.09 Debt Service 172,471.16 - 9,523.75 242,270.49 248,502 - 6,231.51 Rental-Leasing 856.15 - 8,478.80 3,604.76 36,395.24 40,000 - Operating Equipment497.50-43,803.2224,406.6813,158.22 76,600 TOTAL PUBLIC SAFETY 427,068.48 713.69 5,529,153.75 3,322,617.17 75,858.55 3,658,563.97 7,056,326 TOTAL EXPENDITURE 427,068.48713.695,529,153.753,322,617.1775,858.55 S 7,056,326 ** REVENUE OVER(UNDER) EXPENSES 836,110.28 * 147,406 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt5,336,537 256,907.43 - 3,696,507.09 2,661,756.17 - 2,674,780.83 49.88% 000-456110Subscription Program Fees100,000 13,047.00- 18,640.00 - - 81,360.00 000-459200NSF Check Fee20.00- - - - - - TOTAL Fees5,436,537256,907.43 3,709,574.09- 2,680,396.17 2,756,140.83- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.87 - 238,438.70 239,538.63 83.72% - 46,587.37 000-474300Cibolo Support219,699 53,325.00 - 213,300.00 213,300.00 97.09% - 6,399.00 000-475100Comal Co ESD #675,369 36,586.88- 37,920.00 - - 37,449.00 000-475200Live Oak Support 152,569 37,031.25 148,125.00- 148,125.00 - 4,444.00 000-475300Universal City Support 210,545 51,103.13 204,412.52- 204,412.52 - 6,132.48 000-475400Selma Support 17,182.5064,689 62,805.00- 68,730.00 - (4,041.00) 000-475500Schertz Support 399,083 96,864.87 387,459.48- 387,459.48 - 11,623.52 000-475600Santa Clara Support 10,851 10,653.16- 7,901.01 - - 2,949.99 000-475800Marion Support13,4143,255.7913,023.1613,023.16 - - TOTAL Inter-Jurisdictional1,432,345282,606.41 1,314,803.90- 1,320,409.80 111,935.20- Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 35.70 - 146.43 486.21 - - (486.21) 000-493203Donations-EMS 10,000.006,000 - 1,227.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 4,160.34 85,065.99- 71,602.86 - 78,397.14 000-497100Recovery of Bad Debt 100,000 15.00 10,712.36- 10,992.41 - 89,007.59 000-497500Misc Income-EMT Classes78,850600.0053,667.8257,960.00 - - TOTAL Miscellaneous 334,850 14,811.04 150,820.35- 157,921.48 - 176,928.52 TOTAL REVENUES7,203,732554,324.88 5,175,198.34- 4,158,727.45 3,045,004.55- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank $ (290,055.74) Claim on Operating Cash Pool-Checking Cash in Investment Pools LOGIC Investment-EMS- MBIA Investment-EMS Note 2010300,679.32 Total Cash in Bank & Investment Pools$10,623.58 27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 675,30044,713.83 563,485.12- 581,019.60 -94,280.40 Miscellaneous1,3001,323.34927.93 57.06 - - TOTAL REVENUES 44,770.89676,600564,808.46 -581,947.53 - 94,652.47 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 361,18326,254.78 276,684.43- 288,551.59 -72,631.41 Supplies 1,837.208,300 28.15 2,368.48 3,190.60 387.84 Human Services 100 - - - - -100.00 City Support Services 20,000 - 3,476.00 5,832.18 - -14,167.82 Utility Services 19,388 3,203.00 10,404.01- 13,771.81 132.97 Operations Support 2,458 - - - - -2,458.00 Staff Support 8,255 218.35 168.83 3,082.20 3,668.62 359.70 City Assistance 840 - 102.00 15.00 - -825.00 Professional Services 19,800 49.85 - 6,697.10 15,171.49 -4,628.51 Fund Charges/Transfers 195,44910,838.25 96,977.33- 108,677.50 -86,771.50 Maintenance Services 22,000 - 4,663.26 1,987.00 - -20,013.00 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 16,218.7818,138 - 2,183.45 18,137.56 100.00% - Operating Equipment116.00- - - - - - TOTAL DRAINAGE 58,620.21676,511196.98406,854.26 880.51459,103.35216,723.70 TOTAL EXPENDITURE 58,620.21676,511196.98406,854.26 880.51459,103.35216,723.70 S ** REVENUE OVER(UNDER) EXPEND89122,844.18 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 3,205.24 3,617.18 3,500 449.70 -(117.18) 000-457600Drainage Fee 44,264.13-560,279.88577,402.42 -94,397.58 671,800 TOTAL Fees44,713.83 563,485.12-581,019.60 94,280.40- 675,300 Miscellaneous 000-491000Interest Earned - 177.62 227.76 100 6.91 -(127.76) 000-491200Investment Interest - 586.55 538.53 600 40.91 - 000-497000Misc Income-Drainage-559.17161.64 600 9.24 - TOTAL Miscellaneous - 1,323.34 927.93 1,300 57.06 -372.07 TOTAL REVENUES44,770.89 564,808.46-581,947.53 94,652.47- 676,600 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Ban k Claim on Operating Cash Pool-Checking 57,201.94 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund282,993.97 Total Cash in Bank & Investment Pools$340,195.91 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 385,000 35,029.39 259,407.73- 256,587.97 -128,412.03 Fund Transfers 55,000 - - - - -55,000 Miscellaneous 25.485,550-343.59925.86 - TOTAL REVENUES 35,054.87445,550-259,751.32257,513.83 - EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services 31,841 - - - - -31,841.00 Supplies 8,312 - - 2,315.40 - -5,996.60 City Support Services 12,332.0078,228 502.85 48,984.50 59,630.85 -19,100.00 Operations Support 80,112 - - 9,389.93 1,320.00 - Professional Services 2,500 - 902.28 2,500.00 - - -100.00% Fund Charges/Transfers 231,485 14,185.08 180,968.00- 141,850.82 -89,634.18 Operating Equipment - 542.98 - - - - -0.00% Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 26,517.08432,478502.85231,397.76215,687.00215,973.85 L 1,320.00 TOTAL EXPENDITURE 26,517.08432,478502.85231,397.76215,687.00215,973.85 S 1,320.00 REVENUE OVER(UNDER) EXPENDITURE13,072 41,826.83 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax385,000 35,029.39259,407.73256,587.97 -128,412.03 - TOTAL Taxes 385,00035,029.39 259,407.73- 256,587.97 - 128,412.03 Fund Transfers 000-481000Transfer From Reserve55,000 ---55,000.00 - - TOTAL Fund Transfers 55,000 - - - - - 55,000.00 Miscellaneous 000-491000Interest Earned250-232.68219.68 87.87% 1 9.03 - 000-491200Investment Interest 300 - 110.91 106.18 6 .45 - 193.82 000-497000Misc Income -5,000-600.004,400.00 - - TOTAL Miscellaneous5,550-343.59925.86 2 5.48 - 4,624.14 TOTAL REVENUES 445,55035,054.87 259,751.32- 257,513.83 - 188,036.17 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking159,960.52$ Cash in Investment Pools Federated Investment-Hotel/Motel78,107.98 Total Cash in Bank & Investment Pools$238,068.50 33 ôíè÷ðíùùçìûîùãèûä $50,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 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: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 40,000 196,000.00- 107,000.00 - -(67,000.00) Tree Mitigation Fees 40,000 53,756.25- 43,520.00 - -(3,520.00) Miscellaneous405-3,292.90544.47 38.87 - TOTAL REVENUES 38.8780,405-253,049.15151,064.47 - EXPENDITURE SUMMARY PARKLAND DEDICATION Maintenance Services-Landscape 16,165.008,000 - 1,621.36 28,399.00 -(20,399.00) Operating Equipment 30,000 68,149.73 51,768.48 (10,902.45)378.20 -11,244.23 Capital Outlay6,000--4,980.30 - - TOTAL PARKLAND DEDICATION 16,165.0044,00011,244.2369,771.0985,147.78 378.20 TREE MITIGATION Fund Charges/Transfers - 4,133.27 - - - - -0.00% Maintenance Services-Trees 36,000 3,133.00 67,964.67 31,869.55 3,240.00 -7,263.45 Capital Outlay--- - - - - TOTAL TREE MITIGATION 3,240.0036,0003,133.0072,097.9431,869.55 - TOTAL EXPENDITURE 19,405.0080,00014,377.23141,869.03117,017.33 S 378.20 REVENUE OVER(UNDER) EXPEND40534,047.14 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 40,000 196,000.00- 107,000.00 (67,000.00)- - 000-458900Tree Mitigation -40,00053,756.25 -43,520.00 - TOTAL Fees 80,000 249,756.25- 150,520.00 (70,520.00)- - Miscellaneous 000-491000Interest Earned 60 7.60 - 173.69 208.49 (148.49)- 000-491200Investment Interest 280 31.27 - 341.71 335.98 (55.98)- 000-497000Miscellaneous Income652,777.50-- - - TOTAL Miscellaneous40538.87-3,292.90544.47 (139.47)- TOTAL REVENUES 80,405 38.87 253,049.15- 151,064.47 (70,659.47)- 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking$54,135.92 Cash in Investment Pools Federated Investment-Park Fund252,632.00 Federated Investment-Tree Mitigation126,210.16 Total in Investment Pool 378,842.16 Total Cash in Bank & Investment Pools$432,978.08 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% 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: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% 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: JULY 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: JULY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees1,190,640 110,593.80 1,066,150.09- 2,160,219.77 -(969,579.77) Fund Transfers - - - - 0.00% - - Miscellaneous 29,379.68585,500186,309.46291,342.74 - - TOTAL REVENUES 139,973.481,776,1401,252,459.55 -2,451,562.51 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Operations Support1,000---- -1,000.00 Professional Services 26,800 353.88 - 3,977.58 1,121,172.29 -(1,094,372.29) Debt Service - 118,896.50- - 0.00% - - Capital Outlay8,428.00-8,428.00 - - - TOTAL NON DEPARTMENTA 353.8827,8008,428.00122,874.08 -1,129,600.29(1,093,372.29) L MISC & PROJECTS Projects 230,2001,051.9653,906.7819,825.8691,581.34 428.48 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 Plant204,531.74 - - -558,425.60 -(204,531.74) Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP -88,252225,148.72160,103.89344,233.90 A - TOTAL MISC & PROJECTS 1,051.96918,095279,055.50758,114.35640,346.98 428.48 TOTAL EXPENDITURE 1,405.84945,895287,483.50880,988.43 428.481,769,947.27 S REVENUE OVER(UNDER) EXPENDITURES830,245 681,615 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 904,200 72,336.00 702,588.75- 1,177,679.74 -(273,479.74) 000-455910Capital Recovery - Waste Wtr272,800 38,257.80 362,661.34- 758,141.74 -(485,341.74) 000-455911Capital Recovery-Wste Wtr Zone 113,640 - - - - -13,640.00 000-455913Cap Recovery-North Sewer Tr900.00224,398.29 - - - - TOTAL Fees 110,593.801,190,640 - 1,066,150.09 2,160,219.77 181.43% -(969,579.77) Fund Transfers 000-481000Transfer from Reserves - - - 0.00% - - - 000-486100Transfer In -- - - - - - TOTAL Fund Transfers--- 0.00% - - - Miscellaneous 000-491000Interest Earned 2,000 44.65 - 2,828.90 437.53 -1,562.47 000-491200Investment Income 250,000 3,348.97 - 4,230.59 32,306.18 -217,693.82 000-491900Unrealized Gain/Loss-Cap One - (19,317.61)- -(1,805.60) -19,317.61 000-498100Reimbursmnt - FM 78 Project 50,000 4,166.66 37,499.97- 41,666.64 -8,333.36 000-498200Re-imbursement-Water Meters283,500 23,625.00141,750.00236,250.00 - - TOTAL Miscellaneous 585,500 29,379.68 186,309.46- 291,342.74 -294,157.26 TOTAL REVENUES 139,973.481,776,140 - 1,252,459.55 2,451,562.51 138.03% -(675,422.51) 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking472,218.40$ Cash in Investments: Lone Star Investment-Capital Recovery261,812.83 Capital One-Investment1,706,215.21 Schertz Bank & Trust-Certificate of Deposit524,961.62 Total Cash in Bank & Investment Pools$2,965,208.06 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ****************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 16,493.663,368,794 - 3,352,599.45 3,407,787.79 101.16% -(38,993.79) Fund Transfers243,000 - - - - 0.00% -243,000.00 Miscellaneous3,000 86.983,144.9415,483.84 - - TOTAL REVENUES 16,580.643,614,7943,355,744.39 -3,423,271.63 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services3,200 - - 1,750.00 750.00 23.44% -2,450.00 Debt Service3,611,124 1,067,012.913,037,728.66 -3,625,353.50 - TOTAL GENERAL GOVERNMEN 1,067,012.913,614,3243,039,478.66 -3,626,103.50 T - TOTAL EXPENDITURE 1,067,012.913,614,3243,039,478.66 -3,626,103.50 S - ** REVENUE OVER(UNDER) EXPEND470(202,831.87) 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue3,368,79416,493.663,352,599.453,407,787.79 - - TOTAL Taxes3,368,79416,493.66 3,352,599.45-3,407,787.79 -(38,993.79) 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 19.99 - 1,692.74 14,435.29 -(12,935.29) 000-491200Investment Earnings1,50066.991,452.201,048.55 - - TOTAL Miscellaneous3,00086.98-3,144.9415,483.84 -(12,483.84) TOTAL REVENUES3,614,794 16,580.64 3,355,744.39- 3,423,271.63 -191,522.37 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 505-TAX I & S***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent3,2001,750.00750.00 - - - TOTAL Professional Services3,200--1,750.00750.00 -2,450.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 42,525.00 - 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 28,700.00 35,360.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 128,949.37 143,168.14- 265,008.13 - 101-555626LS&D SR2006-Principal - 100,000.00- - - - 101-555626.1LS&D SR2006-Interest 650,982 325,490.61 652,981.25- 650,981.25 - 101-555628CO Bond 2007-Principal 99,567 99,566.67 - 99,709.25- - 101-555628.1CO Bond 2007-Interest 26,617 13,215.26 - 26,523.79- - 101-555629GO Bond 2007-Principal 275,000 - 250,000.00- 275,000.00 - 101-555629.1GO Bond 2007-Interest 209,097 101,750.00 127,331.56- 209,096.25 - 101-555630GO Bond SR2008 Principal 355,000 - 235,000.00- 355,000.00 - 101-555630.1GO Bond SR2008 Interest 379,651 186,159.75 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 140,656.25283,063167,073.96283,062.50 - - TOTAL Debt Service3,611,1241,067,012.91 3,037,728.66-3,625,353.50 -(14,229.50) TOTAL EXPENDITURES3,614,3241,067,012.91 3,039,478.66- 3,626,103.50 -(11,779.50) 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking14,293.63$ Cash in Investment Pools MBIA Investment- Tax I&S69,032.03 Federated Investment-Tax I&S56.77 Total Cash in Bank & Investment Pools$83,382.43 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,035,795171,256.31 1,332,084.61- 1,817,828.35 - 217,966.65 Miscellaneous 356.03108,00037,851.30 -15,519.06 - ,,,.,,. -,,. TOTALREVENUES214379517161234136993591183334741310 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies23,000835.19623.2813,415.5717,124.411,270.61 Utility Service 85,800 12,570.45 63,159.59- 50,906.72 - 34,893.28 Maintenance Services 65,300 6,133.22 5,965.50 35,139.69 54,603.24 2,038.19 Operating Equipment 8,498 18,494.00- 6,999.31 - - 1,498.69 Capital Outlay -6,999.31-- - - TOTAL NONDEPARTMENTA 19,538.86182,59813,588.09130,208.85 3,308.80129,633.68 L ECONOMIC DEVELOPMEN T Personnel Services 202,062 8,612.55 210,556.04- 133,257.37 - 68,804.63 Supplies 2,000 - 414.89 560.22 239.92 - Human Services 100 - - - 54.00 54.00% - City Support Services 33,500 2,885.37 623.92 38,364.31 16,659.44 98.35 Utility Services 4,850 191.83 - 3,161.52 2,484.93 - 2,365.07 Operations Support 76,100 1,898.06 3,242.89 53,279.82 51,247.78 1,192.61 Staff Support 97,000 3,466.69 1,782.11 97,749.19 71,229.02 705.35 City Assistance 80,000 - - - - - 80,000.00 Professional Services 349,000 8,661.94 21,340.80 182,684.10 181,632.57 927.50 187,780.73 Fund Charges/Transfers 105,432 4,416.66 91,625.00- 95,585.31 - 9,846.69 Fund Replenish-Fund Balance 216,000 - - - - - 216,000.00 Maintenance Services - 781.89 - 0.00% - - - Debt Service 792,432185,520.75 355,322.21- 792,432.00 100.00% - Operating Equipment -1,500245,676.65 -1,112.82 - TOTAL ECONO DEVELOPMEN 215,653.851,959,97626,989.721,279,615.62 3,217.731,346,201.46637,546.53 T TOTAL EXPENDITURE 235,192.712,142,57440,577.811,409,824.47 6,526.531,475,835.14700,790.14 S ** REVENUE OVER(UNDER) EXPEND1,221 357,512.27 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,035,795171,256.311,332,084.611,817,828.35 - - TOTAL Taxes2,035,795171,256.31 1,332,084.61- 1,817,828.35 -217,966.65 Miscellaneous 000-491000Interest Earned 1,000 33.28 - 588.55 189.24 - 000-491200Investment Earnings 12,000 103.15 26,709.44- 9,835.12 -2,164.88 000-497000Misc Income 15,000 219.60 10,553.31- 5,494.70 -9,505.30 000-499000Transfer From Reserves80,000 -- - - - TOTAL Miscellaneous 108,000 356.03 37,851.30- 15,519.06 - TOTAL REVENUES2,143,795171,612.34 1,369,935.91- 1,833,347.41 -310,447.59 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking193,402.68$ Cash in Investment Pools MBIA Investment-Economic Development Corp715,477.57 MBIA-Investment-EDC Notes 2010153,594.75 Schertz Bank & Trust-Certificate of Deposit506,068.72 Schertz Bank & Trust-Certificate of Deposit1,031,406.35 Total Cash in Bank & Investment Pools2,599,950.07$ 50 4B SALES TAX $300,000 $250,000 -1% 16% 17% $200,000 23% 24% -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 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 JULY 31st, 2011 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,789,429.46,659,955.27.1000,747,509.61,618,035.42,789,429.46,789,429.46 204422 TOTAL OPERATIONS2,789,429.46,659,955.27,747,509.61,618,035.42,789,429.46,789,429.46 24422 LOGIC General Fund3,008,801.98,008,438.09.1424 -63.89,008,801.98 N/A,008,801.98 30333 G/F-Equipment Replacement73,281.3373,272.470.1424 -8.8673,281.33 N/A73,281.33 G/F-Vehicle Replacement7,073.19,072.33.1424 -.86,073.19 N/A,073.19 70077 G/F-Air Conditioner Replacement122,320.85122,306.060.1424 -14.79122,320.85 N/A122,320.85 ,155,687.87.142460.75-,155,948.62,155,948.62 SR2009 Bond-Street Projects(II)2,155,948.62 20222 TOTAL LOGIC5,367,425.97,366,776.82 -49.15,367,425.97,367,425.97 5655 LONESTA R Drainage Fund282,993.97282,953.060.1700 -40.91282,993.97 N/A282,993.97 GO SR2011 Animal Shelter2,266,896.34,266,568.61.1700 -27.73,266,896.34 N/A,266,896.34 20322 GO SR2011 Athletic Fields1,490,827.851,490,612.320.1700 -215.531,490,827.85 N/A1,490,827.85 GO SR2011 Soccer Fields1,511,264.21,511,045.72.1700 -18.49,511,264.21 N/A,511,264.21 10211 GO SR2011 Swimming Pool3,022,528.423,022,091.450.1700 -436.973,022,528.42 N/A3,022,528.42 W/S-Capital Recovery-Water261,812.8361,774.98.1700 -7.8561,812.83 N/A61,812.83 20322 W/S-Customer Deposits293,505.91293,463.480.1700 -42.43293,505.91 N/A293,505.91 W/S-Equipment Repl/Cap.Imp372,866.3472,812.43.1700 -3.9172,866.34 N/A72,866.34 30533 Water&Sewer857,224.771,291,228.670.1700173.10434,177.00857,224.77 N/A857,224.77 W/S-Vehicle Replacement543,683.6843,605.08.1700 -8.6043,683.68 N/A43,683.68 50755 Water/SSLG - SAWS134,587.6534,568.19.17009.46-34,587.6534,587.65 10111 TOTAL LONESTAR11,038,191.9711,470,723.991,644.98434,177.0011,038,191.9711,038,191.97 MBIA Tax I&S69,032.033,021.81.14000.224,000.009,032.03 N/A9,032.03 901266 Police Forfeiture359,033.30358,990.650.1400 -42.65359,033.30 N/A359,033.30 Economic Development Corporation715,477.5715,392.62.1400 -4.9515,477.57 N/A15,477.57 70877 Special Events Fund66,539.4966,531.600.1400 -7.8966,539.49 N/A66,539.49 SEDC Tax Notes 2010153,594.7553,576.55.1400 -8.2053,594.75 N/A53,594.75 10111 EMS Tax Notes 2010300,679.3200,643.62.14005.70-00,679.3200,679.32 30333 TOTAL MBIA1,664,356.461,688,156.85199.6124,000.001,664,356.461,664,356.46 FEDERATED SR2007a Bond-City Wide Projects982,325.1983,295.98.10001.16,051.9582,325.19 N/A82,325.19 908199 Hotel Occupancy Tax78,107.9878,101.530.1000 -6.4578,107.98 N/A78,107.98 Park Fund (Developers Fee)252,632.0052,611.15.1000 -0.8552,632.00 N/A52,632.00 20222 Park Fund (Tree Mitigation)126,210.16126,199.740.1000 -10.42126,210.16 N/A126,210.16 Tax I&S56.77,033,952.80.10006.81,033,962.846.77 N/A6.77 106155 Library Board Fund44,670.298,666.31.1000.98,000.004,670.294,670.29 403444 TOTAL FEDERATED1,484,002.392,522,827.51189.671,039,014.791,484,002.391,484,002.39 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,275,825.93,309,016.67.3700 275.9794.55,308,935.25 N/A,332,184.67 12111 Capital One Capital Recovery1,641,454.81,716,136.43.070054.41353.88,716,036.96,706,215.21 12211 TOTAL CAPITAL ONE2,917,280.743,025,153.10 629.85448.963,024,972.213,038,399.88 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,789,429 Designated Funds, $8,010,893 Special Revenue Funds, $5,849,191 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.1600 1 Month T-Bill 0.11700.17000.12000.15000.15000.09000.04000.06000.03000.1000 3 Month T-Bill 0.16500.21000.19000.17000.18000.17000.11000.12000.10000.1600 6 Month T-Bill 0.61000.61000.58000.52000.53000.54000.45000.45000.44400.4409 Schertz Portfolio 0.15000.15000.1500 JPMorgan Chase 0.25000.25000.25000.10000.10000.10000.10000.10000.10000.1000 Schertz Bank&Trust 0.22940.22440.21380.20900.20840.21000.20000.17850.17450.1424 LOGIC 0.28000.25000.24000.24000.24000.24000.23000.22000.20000.1700 LoneStar 0.26000.24000.23000.22000.18000.17000.17000.16000.16000.1400 MBIA 0.13000.21000.19000.19000.18000.18000.15000.12000.11000.1000 Federated 2.22002.24002.24002.24002.24002.24002.21002.20002.20002.2000 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:7/31/2011 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69130,825.9330,825.9330,825.933.000.01 Bank of Amer NA Disc Bank Accpt 10/17/201178.0065,000.0064,886.2564,821.160.000.00 General Elec Cap Corp Disc Com Paper3/12/2012225.0065,000.0064,891.2264,891.220.000.00 59,964.6059,964.60 JPMorgan Chase Disc Bank Accpt Note9/28/201159.0060,000.00 Total Cash & Equivalent20,825.9220,568.020,502.91 s2302 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012444.00150,000.00162,031.50157,511.256,750.00 Federal Home Loan Bks Cons Bds10/28/201189.00135,000.00135,000.00135,027.68337.00 Federal Home Ln Mtg Corp Disc Nts Dtd10/7/201168.00100,000.0099,746.5099,774.410.00 Federal Home Ln Mtg Corp Deb11/15/2013838.00170,000.00191,084.25186,801.958,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013786.00250,000.00250,000.00270,505.0010,937.00 250,505.00252,805.00 Federal Natl Mtg Assn 4/20/2012264.00250,000.00 Total Fixed Incom,055,000.01,088,367.2,102,425.2 e105193 Total Assets410.031,275,825.931,308,935.251,322,928.203 Cap Recovery Fun d Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #69141,454.8141,454.8141,454.814.000.01 Bank of Amer N A Disc Bankers Accp Prgm10/17/201178.0085,000.0084,851.2584,766.140.000.00 General Elec Cap Corp Disc Coml Paper3/12/2012225.0085,000.0084,857.7484,857.740.000.00 79,952.8079,952.80 JPMorgan Chase Disc Bank Accpt Note9/28/201159.0080,000.00 Total Cash & Equivalent91,454.81291,116.691,031.4 s2029 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012444.00250,000.00270,052.50262,518.7511,250.00 Federal Home Loan Bks Cons Bds10/28/201189.00175,000.00175,000.00175,035.88437.000.25 Federal Home Ln Mtg Corp Disc Nts10/7/201168.00125,000.00124,683.13124,717.980.000.00 Federal Home Ln Mtg Corp Deb11/15/2013838.00250,000.00281,006.25274,708.7512,187.004.34 Federal Natl Mtg Assn Nts10/15/2013807.00200,000.00223,001.60217,882.009,250.004.15 Federal Natl Mtg Assn10/30/2012457.00250,000.00250,192.50250,465.001,250.000.50 US Treasury Note12/15/2011137.00100,000.00100,984.38100,359.50 Total Fixed Incom,350,000.01,424,920.3,405,687.8 e106163 Total Assets418.411,641,454.811,716,036.961,696,719.353