Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10-JULY 2012 FINANCIAL STATEMENT
JULY 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department August 31, 2012 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725434,767.30 9,813,982.91-11,245,701.21 558,023.79 Franchises 1,617,000 149,133.98 810,273.29- 1,219,458.85 - 397,541.15 Permits 1,187,800 78,896.35 1,464,514.98- 894,506.60 - 293,293.40 Licenses 48,300 5,545.00 56,240.60- 58,962.50 - (10,662.50) Fees 3,324,727 265,195.08 2,246,910.51- 2,404,075.25 (157.00) Fines 30,000 2,690.04 22,040.17- 23,393.99 - Inter-Jurisdictional 571,245 100,597.84 344,357.26- 509,930.46 - 61,314.54 Fund Transfers 1,760,658 108,750.59 976,432.76- 1,100,618.69 - 660,039.31 Miscellaneous791,01056,557.54381,691.46479,647.99(8.90) - TOTAL REVENUES21,134,4651,202,133.7216,116,443.9417,936,295.54(165.90) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,366.30 - 18,998.91 17,173.69 - Supplies 700 15.99 - 389.85 595.14 - City Support Services 18,000 60.00 13,447.67- 7,604.38 - 10,395.62 Operations Support 100 - - 161.35 - - Staff Support19,900111.50 16,456.75 -13,131.67 - Operating Equipment -- - - - - TOTAL CITY COUNCIL61,5001,553.79 46,129.45-41,829.96 - 19,670.04 CITY MANAGE R Personnel Services 852,201 70,984.83 592,479.26- 666,716.41 - 185,484.59 Supplies4,731 130.33 - 1,476.74 2,854.82 100.00 1,776.18 - - - 45.00 Operations Support - - Staff Support 30,400 2,678.37 21,251.93- 23,561.83 23.33 Operating Equipment -1,596.70 - - - - TOTAL CITY MANAGER 887,332 73,793.53 616,804.63- 693,178.06 123.33 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services257,113 19,180.85 - 196,806.00 204,064.44 - 53,048.56 Supplies2,500 - - 1,837.35 1,318.87 83.08 1,098.05 City Support Services1,000 - - - - - Operations Support 3,000 948.00 - 1,951.00 2,506.00 - Staff Support 5,500 363.36 - 2,042.13 2,375.54 202.44 Court Support 800 - - - - - Professional Services 71,100 2,597.16 40,990.25- 43,241.22 6,941.73 Maintenance Services 2,200 200.00 - 600.00 1,499.94 - Operating Equipment1,000 497.14900.00 - - - TOTAL MUNICIPAL COURT 23,289.37344,213 - 245,126.73 255,503.15 7,227.25 81,482.60 CUSTOMER RELATIONS-311 Personnel Services109,700 7,744.45 - 67,089.66 80,204.95 - 29,495.05 Supplies300 - - 380.33 150.61 - Staff Support1,018 1,069.97636.20 - - - Operating Equipment500 213.00- - - - TOTAL CUSTOMER RELATIONS-311 111,518 7,744.45 68,539.96- 81,204.76 - 30,313.24 PLANNING & ZONING Personnel Services 139,925 10,277.90 108,181.25- 110,090.37 - 29,834.63 Supplies 2,753 196.90 - 492.31 1,092.08 20.93 Operations Support 535 - - 77.95 - - Staff Support 17,312 450.00 - 3,705.75 2,209.35 - 15,102.65 Professional Services 76,650 22,553.21 62,858.46- 61,301.06 11.99 Operating Equipment3,500 2,112.001,055.00 - - - TOTAL PLANNING & ZONING240,67533,478.01 176,370.72-176,804.8632.92 LEGAL SERVICES Operations Support13,000 631.92 - 9,199.04 701.77 26.05 12,272.18 Professional Services245,00036,210.83175,247.92317,865.72 - 31,238.27 TOTAL LEGAL SERVICES 258,000 36,842.75 184,446.96- 318,567.49 31,264.32 (91,831.81) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services643,323 46,326.01 - 503,779.43 473,946.78 - 169,376.22 Supplies66,535 6,477.86 - 51,999.31 57,750.94 2,956.30 5,827.76 Utility Services112,000 9,454.11 - 65,712.73 71,576.65 - 40,423.35 Staff Support13,179 697.89 - 8,775.88 8,859.86 332.29 3,986.85 Maintenance Services99,119 7,351.74 - 101,163.90 80,790.23 7,539.83 10,789.19 Rental/Leasing400 - - 763.92 331.59 - Operating Equipment3,396224.46 1,278.552,789.01 - - Capital Outlay24,500 -2,524.53 - - - TOTAL FACILITIES MAINTENANCE 962,452 70,532.07 735,998.25- 696,045.06 10,828.42 CITY SECRETAR Y Personnel Services 164,529 12,574.96 131,694.16- 131,089.55 - 33,439.45 Supplies1,250 93.33 - 1,315.10 878.08 - City Support Services 9,780 680.45 - 6,788.22 2,606.65 - Staff Support8,6051,051.20 6,106.903,787.94586.20 - TOTAL CITY SECRETARY 184,164 14,399.94 143,585.42- 140,681.18 586.20 NON-DEPARTMENTA L Supplies2,500--405.3510.71 - City Support Services 665,680 1,070.00 282,111.46- 247,110.75246,762.25 Operations Support 139,000 8,523.12 114,627.20- 114,905.81 5.90 Staff Support - - - 90.82 - - City Assistance 459,046 96,046.91 422,942.47- 481,160.88 - (22,114.88) Professional Services 174,650 6,001.32 53,374.12- 74,009.25 2,902.50 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,451,726 111,641.35 873,460.60- 917,288.22249,670.65 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services268,919 21,439.49 - 118,534.32 215,929.78 - 52,989.22 Supplies2,900 233.73 - 920.43 2,676.00 - Operations Support 34,585 960.61 18,626.97- 14,061.25 1,250.00 Staff Support 4,865 361.18 - 2,124.13 3,468.08 225.00 Operating Equipment300 -2,737.18 - - - TOTAL PUBLIC AFFAIRS 311,569 22,995.01 142,943.03- 236,135.11 1,475.00 RECORDS MANAGEMEN T Personnel Services 47,850 3,557.68 37,047.37- 38,207.17 - Supplies 750 50.00 - 320.51 259.47 - Staff Support 1,500 83.00 - 845.14 1,109.75 - Professional Services 15,000 180.50 10,184.01- 6,630.66 - Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,100 3,871.18 48,397.03- 46,207.05 - 18,892.95 SCHERTZ TALES MAGAZINE Personnel Services 129,161 9,986.56 100,257.01- 103,652.82 - 25,508.18 Supplies 200 - - - 45.00 60.84 Opperations Support 200 - - 49.58 - - Staff Support 1,500 350.60 - 15.00 619.82 426.97 Professional Services302,70023,405.97202,938.98228,977.648,852.86 - TOTAL SCHERTZ TALES MAGAZINE 433,761 33,743.13 303,260.57- 333,295.28 9,340.67 ENGINEERING Personnel Services 123,405 4,594.85 130,986.17- 56,651.15 - 66,753.85 Supplies 1,400 - - 242.15 375.05 - Utility Services 600 - - - 279.30 - Staff Support 2,013 183.95 - 876.00 313.95 - Professional Services 86,520 10,947.50 19,066.25- 70,675.00 - 15,845.00 Maintenance Services 4,044 - - 2,844.24 3,345.29 - Operating Equipment1,900 -- - - - Capital Outlay26,000 25,352.30- - - - TOTAL ENGINEERING 245,882 15,726.30 154,014.81- 156,992.04 - 88,889.96 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,079 9,210.61 - 93,038.63 96,798.97 - 25,280.03 Supplies3,500 470.70 - 1,451.62 1,450.37 - Staff Support 4,050 - - - - - Professional Services2,00014.00 14.00- - - TOTAL GIS 131,629 9,695.31 94,490.25- 98,263.34 - 33,365.66 TOTAL GENERAL GOVERNMENT 5,689,521 459,306.19 3,833,568.41- 4,191,995.56310,548.76 PUBLIC SAFETY POLICE Personnel Services4,524,327 348,987.78 - 3,353,708.22 3,528,280.93 - 996,046.07 Supplies36,244 1,862.39 - 17,277.64 24,912.64 110.94 11,220.42 City Support Services21,734 - - - 19,518.41 - Utility Services 123,456 10,464.35 79,127.13- 86,978.82 - 36,477.18 Operations Support 1,565 90.00 - 193.00 1,565.00 - Staff Support 58,781 6,622.11 10,174.94- 38,846.72 2,229.76 City Assistance 9,563 (2,132.00) - 2,903.18 2,539.74 1,252.51 Professional Services 9,692 - - 6,830.16 2,082.85 2,848.00 Maintenance Services 46,494 3,720.00 29,395.80- 38,068.23 294.50 Operating Equipment 75,992 7,370.59 48,665.87- 70,814.58 12,036.16 Capital Outlay155,077153,726.40142,521.25 - - - TOTAL POLICE 5,062,925376,985.22 3,702,002.34-3,956,129.1718,771.87 FIRE RESCUE Personnel Services 2,508,586 176,744.91 1,948,573.33- 2,000,499.95 - 508,086.05 Supplies 20,500 1,024.38 - 6,062.21 14,082.48 17.07 Utility Services 57,000 5,160.81 39,837.27- 38,729.20 - 18,270.80 Operations Support 800 130.00 - 567.00 453.39 - Staff Support 120,185 2,588.80 77,025.08- 102,000.88 1,325.87 City Assistance 18,600 - 10,777.25- 8,885.80 - Professional Services 18,140 - 13,040.00- 12,148.19 - Maintenance Services 56,000 10,752.76 26,944.63- 36,320.50 - 19,679.50 Operating Equipment58,3005,496.03 22,875.821,778.48 -31,152.90 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,893,111 201,897.69 2,153,979.67- 2,267,112.21 3,121.42 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services420,518 31,435.73 - 289,635.44 332,470.26 - 88,047.74 Supplies2,123 93.54 - 1,694.80 1,563.18 23.73 536.09 City Support Services400 - - - - - Utility Services 6,500 481.79 - 4,268.48 4,306.01 - Operations Support 1,500 286.00 - 838.87 561.00 - Staff Support 7,977 214.65 - 3,074.75 2,175.50 43.65 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 --47.61 - - TOTAL INSPECTIONS 450,018 32,511.71 299,512.34- 341,075.95 114.99 MARSHAL SERVICE Personnel Services 534,355 38,828.80 364,716.73- 410,159.94 - 124,195.06 Supplies 4,600 - - 1,633.87 2,470.40 89.98 Utility Services 12,000 1,626.46 - 7,780.73 11,126.30 - Operations Support 4,000 120.00 - 1,595.39 1,350.39 - Staff Support 15,400 1,030.34 - 2,392.57 6,281.28 354.00 Maintenance Services 30,700 750.00 - 9,724.85 3,784.00 - 26,916.00 Operating Equipment16,000543.62 12,102.04 -22,861.14 - Capital Outlay34,000 31,022.0546,453.40 - - - TOTAL MARSHAL SERVICE 651,055 42,899.22 457,158.68- 478,296.40 443.98 TOTAL PUBLIC SAFETY 9,057,109 654,293.84 6,612,653.03- 7,042,613.73 22,452.26 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services680,357 48,604.26 - 458,014.65 534,174.66 - 146,182.34 Supplies7,100 277.11 - 4,200.36 4,521.26 93.47 2,485.27 Utility Services113,900 9,518.57 - 90,119.17 93,666.60 337.40 19,896.00 Staff Support10,265 326.46 - 6,030.92 5,793.28 250.52 4,221.20 Maintenance Services270,800 10,908.20 - 135,195.58 128,769.35 7,180.26 134,850.39 Rental/Lease200 - - - - - Operating Equipment 4,200 - - 5,185.95 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,086,822 69,634.60 712,416.63- 770,411.14 7,861.65 TOTAL PUBLIC ENVIRONMENT1,086,82269,634.60 712,416.63-770,411.147,861.65 PARKS & RECREATION PARKS DEPARTMENT Personnel Services506,870 36,176.56 - 377,584.14 383,192.36 - 123,677.64 Supplies40,555 4,596.94 - 25,932.07 27,387.35 627.79 12,539.86 Utility Services113,000 15,922.42 - 103,123.08 104,658.29 337.40 8,004.31 Operations Support700 - - 880.80 - - Staff Support 8,573 398.29 - 6,226.41 6,873.77 157.86 Professional Services 62,610 5,496.50 37,059.50- 51,412.99 - 11,197.01 Maintenance Services 22,000 538.81 19,508.44- 14,176.77 50.00 Rental/Leasing 42,200 7,028.54 33,502.23- 33,334.93 9,676.20 Operating Equipment - - 6,197.93 - - - Capital Outlay -190.56 - - - - TOTAL PARKS DEPARTMENT 796,508 70,158.06 610,205.16- 621,036.46 10,849.25 SWIM POOL Supplies17,700 576.97 - 11,390.85 12,377.51 68.99 5,253.50 Utility Services25,500 3,729.04 - 14,372.75 17,177.69 - Staff Support 925 - - 166.09 750.00 - Maintenance Services 198,378 119,918.00 127,064.27- 132,822.63 61.32 Rental/Lease500 208.20378.00 - - - TOTAL SWIM POOL 124,224.01243,003 - 153,371.96 163,336.03 130.31 79,536.66 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services54,292 4,031.61 - 65,460.66 44,503.36 - Supplies 28,300 1,154.94 - 6,760.15 10,687.36 - 17,612.64 Utility Services 47,550 3,955.92 29,193.20- 28,088.89 - 19,461.11 Operations Support 15,158 - - 7,924.26 10,166.78 - Staff Support 3,342 20.00 - 614.47 1,101.48 - Professional Services 1,600 - - 975.00 150.00 - Operating Equipment5,000 4,999.70285.00 - - - TOTAL COMMUNITY/CIVIC CNTR155,242 -9,162.47 111,212.74 99,697.57 - 55,544.43 TOTAL PARKS & RECREATION1,194,753 203,544.54 - 874,789.86 884,070.06 10,979.56 299,703.38 CULTURAL LIBRARY Personnel Services 692,531 49,582.75 541,972.94- 553,022.19 - 139,508.81 Supplies14,000 44.92 - 10,584.48 7,996.16 - Utility Services 41,000 6,424.81 36,065.95- 35,259.65 - Operations Support 2,000 - - 1,110.20 1,157.00 - Staff Support 4,215 - - 1,435.40 1,538.18 - Professional Services 2,100 1,200.00 - 2,065.00 3,340.00 - (1,240.00) Maintenance Services 2,400 400.00 - 1,200.00 2,000.00 - Operating Equipment75,0005,325.45 64,137.4466,338.30192.11 - TOTAL LIBRARY 62,977.93833,246 - 660,772.27 668,450.62 192.11 164,603.27 TOTAL CULTURAL833,246 62,977.93 - 660,772.27 668,450.62 192.11 164,603.27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services296,439 19,280.66 - 240,536.06 220,247.38 - 76,191.62 Supplies25,000 2,770.39 - 16,543.35 17,495.63 1,173.24 6,331.13 Utility Services11,200 382.41 - 8,422.20 8,099.46 - Operations Support 500 - - - - - Staff Support 12,560 2,131.00 - 1,981.08 7,773.64 99.15 City Assistance 10,000 1,185.60 - 8,023.64 7,312.95 - Professional Services 13,500 639.00 - 9,140.50 7,878.00 - Maintenance Services 6,200 200.00 - 3,364.61 4,385.15 - Operating Equipment9,5002,945.16 4,639.148,415.34 - - TOTAL ANIMAL SERVICES384,89929,534.22 296,426.78-277,831.351,272.39 TOTAL HEALTH 384,899 29,534.22 296,426.78- 277,831.35 1,272.39 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 260,032 20,571.39 209,308.68- 225,854.12 - 34,177.88 Supplies2,000 - - 1,090.52 336.71 - City Support Services 360,854 19,329.60 211,383.85- 215,494.95142,329.65 Utility Services 164,949 10,592.29 113,739.22- 120,253.73 8,763.99 Staff Support 16,750 3,111.18 - 6,102.52 14,422.76 2,031.69 Professional Services 2,500 - - - - - Maintenance Services 12,500 - 15,082.52- 9,389.36 2,850.00 Operating Equipment 129,315 32,252.91 123,046.62- 99,915.27 1,928.75 Capital Outlay213,500 -- - - - TOTAL INFORMATION TECHNOLOGY1,162,400 85,857.37 - 679,753.93 685,666.90 157,904.08 318,829.02 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services296,750 22,609.87 - 167,418.08 197,087.44 - 99,662.56 Supplies1,329 - - 768.52 896.17 - Human Services 42,831 2,724.92 28,033.89- 31,236.15 - 11,594.85 Operations Support 13,346 768.00 - 9,317.21 5,670.25 - Staff Support 16,897 1,234.58 - 6,567.49 9,319.40 - City Assistance 9,860 77.00 - 5,731.00 5,391.50 - Operating Equipment5,575 4,302.13- - - - TOTAL HUMAN RESOURCES 27,414.37386,588 - 217,836.19 253,903.04 - 132,684.98 FINANCE Personnel Services429,810 35,868.39 - 332,878.92 355,782.73 - 74,027.27 Supplies3,600 - - 2,805.18 2,429.19 - Operations Support 850 - - 342.57 97.31 - Staff Support 15,805 - - 9,155.08 6,333.52 - Rental/Leasing 2,230 - - - 502.32 - Operating Equipment1,000 266.471,077.80 - - - TOTAL FINANCE 453,295 35,868.39 346,259.55- 365,411.54 - 87,883.46 PURCHASING & ASSET MG T Personnel Services 241,940 18,151.46 187,222.36- 192,771.85 - 49,168.15 Supplies1,103 80.92 - 678.69 776.87 5.96 320.17 Utility Services650 - - 327.46 419.85 - Operations Support 909 60.55 - 60.68 5.67 28.99 Staff Support 9,097 - - 5,087.30 4,104.15 - Operating Equipment7,591 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 261,290 18,292.93 193,376.49- 205,669.21 34.95 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,880 16,979.04 - 129,080.15 169,400.42 - 48,479.58 Supplies150,576 18,530.65 - 92,676.53 123,186.30 10,094.72 17,294.98 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 394.86 - 3,997.25 2,797.31 - Operations Support 25 - - 750.00 - - Staff Support 3,835 223.13 - 1,802.62 2,507.28 141.31 Maintenance Services 70,079 5,800.60 47,968.97- 36,195.35 249.20 Rental/Lease270 150.00269.80 - - - Operating Equipment5,000 4,931.793,973.90 - - - TOTAL FLEET SERVICE 456,365 41,928.28 281,899.42- 340,788.25 10,485.23 TOTAL INTERNAL SERVICE 2,719,938 209,361.34 1,719,125.58- 1,851,438.94168,424.26 MISC & PROJECTS CITY ASSISTANCE - - 492.52 281.17 Utility Services - - Patient Assistance 5,000 - - 5,000.00 2,500.00 - Children's Advocacy Assistance 5,000 - - 5,000.00 - - Senior Citizen's Hot Meals42,000 42,000.0042,000.00 - - - TOTAL CITY ASSISTANCE52,000- 52,492.52-44,781.17 - COURT - RESTRICTED FUNDS Operating Equipment750.00 15,019.001,090.003,340.00 - - TOTAL CITY ASSISTANCE 750.00 - 1,090.00 15,019.00 3,340.00 - TOTAL MISC & PROJECTS52,000750-53,58359,8003,340 TOTAL EXPENDITURES21,018,2881,689,402.66 14,763,335.08-15,746,611.57525,070.99 REVENUE OVER(UNDER) EXPEND.116,1772,189,683.97 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 26,509.36 6,722,442.36- 6,884,317.21 - 000-411200Advalorem Tax - Delinquent 50,000 3,014.54 43,557.99- 48,745.67 - 000-411300Advalorem Tax - P&I 50,000 3,300.90 41,441.26- 40,599.87 - 000-411500Sales Tax Revenue-Gen Fund4,784,071 394,335.37 2,971,161.07- 4,243,452.17 - 540,618.83 000-411600Bingo Tax 2,200 - - 1,750.27 - - 000-411700Mixed Beverage Ta33,000.007,607.1333,629.9628,586.29 x - - TOTAL Taxes11,803,725 434,767.30 9,813,982.91- 11,245,701.21 558,023.79 Franchises 000-421200Center Point/Entex Energy 36,000 2,485.24 27,235.78- 44,064.94 - (8,064.94) 000-421220City Public Service 330,000 33,146.47 185,874.73- 285,381.53 - 44,618.47 000-421240Guadalupe Valley Elec Co-op 440,000 48,523.41 186,840.44- 324,885.69 - 115,114.31 000-421250New Braunfels Utilities 55,000 6,135.56 11,656.38- 42,914.29 - 12,085.71 000-421300Time Warner-State Franchise 345,000 29,299.05 161,780.70- 281,304.87 - 63,695.13 000-421350Time Warner-PEG Fee 65,000 - 32,344.84- - - 65,000.00 000-421460AT&T Franchise Fee 185,000 17,447.06 76,453.51- 105,877.83 - 79,122.17 000-421465AT&T PEG Fees 26,000 12,036.28- - - 26,000.00 000-421480Other Telecom Franchise 35,000 6,275.04 34,487.83- 52,819.61 - (17,819.61) 000-421500Solid Waste Franchise Fee100,0005,822.1581,562.8082,210.09 - - TOTAL Franchises1,617,000149,133.98 810,273.29-1,219,458.85 - 397,541.15 Permits 000-431100Home Occupation Permit 500 35.00 - 280.00 280.00 - 000-431200Building Permit - 1,154,991.83- - - - 000-431205Building Permit - Residential 600,000 36,180.00 - 342,812.00- - 257,188.00 000-431210Building Permit - Commercial 300,000 10,600.00 - 193,737.00- - 106,263.00 000-431215Building Permit - General - 93,884.00- - 6,927.00 - (93,884.00) 000-431300Mobile Home Permit 200 50.00 - 80.00 250.00 - 000-431400Signs Permit 1,700 277.00 - 690.00 1,880.00 - 000-431500Food Establishmnt Permit 30,000 700.00 14,370.00- 14,650.00 - 15,350.00 000-431600Garage Sale Permit 8,600 1,200.00 - 9,650.00 9,305.00 - 000-431700Plumbing Permit 80,000 9,472.35 98,727.65- 96,551.10 - (16,551.10) 000-431750Electrical Permit 55,000 4,200.00 61,700.00- 38,910.00 - 16,090.00 000-431800Mechanical Permit 59,000 5,160.00 71,340.00- 44,860.00 - 14,140.00 000-431900Solicitor/Peddler Permit 70.00 - 1,940.00 1,270.00 - - 000-431950Animal/Pet Permit 2,000 600.00 - 1,630.00 2,075.00 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800500.00 5,550.00- 6,700.00 - (2,900.00) 000-432100Security Alarm Permit42,000 2,425.00 - 36,028.00 40,242.50 - 000-435000Fire Permit5,000500.00 7,100.007,537.50 - - TOTAL Permits 78,896.351,187,800 - 1,464,514.98 894,506.60 - 293,293.40 Licenses 000-441000Alcohol Beverage License 6,300 985.00 - 5,347.50 4,972.50 - 000-441300Mobile Home License - - - 80.00 - - 000-442000Contractors License 39,000 4,105.00 47,020.00- 50,060.00 - (11,060.00) 000-444000Pet License3,000455.00 3,850.003,873.10 - - TOTAL Licenses 48,300 5,545.00 56,240.60- 58,962.50 - (10,662.50) Fees 000-451000Municipal Court Fines 1,665,009 124,449.60 876,159.91- 1,209,764.05 - 455,244.95 000-451100Arrest Fee 50,694 6,625.54 37,596.14- 49,892.29 - 000-451110Expunction Fee 90 - - 30.00 - - 000-451200Warrant Fees 192,000 10,381.88 109,760.37- 113,326.48 - 78,673.52 000-451210Court - Claims & Judgements - - - 1,842.60 - - (1,842.60) 000-451320Civil Justice Fee-Court 75 10.53 56.31 78.09 - 000-451321Civil Justice Fee-State 95.29 - 507.55 705.04 - - 000-451340Judicial Fee - City 6,826 844.34 - 5,037.81 6,554.19 - 000-451400Traffic Fine Costs TTL 25,984 3,413.85 18,962.68- 25,658.49 - 000-451500Teen Court Admin Fee 260 - - 280.00 420.00 - 000-451510Juvenile Case Mgmt Fee 55,896 7,046.45 42,005.31- 54,662.67 - 000-451600Technology Fund Fee 45,601 5,643.19 34,000.10- 43,889.10 - 000-451700Security Fee 34,220 4,232.41 25,509.08- 32,916.88 000-451800Time Payment Fee - City 7,336 647.15 - 4,831.67 4,531.96 - 000-451850State Fines 10% Service Fee 72,470 20,788.13 49,510.11- 68,804.90 - 000-451900DPS Payment - Local 11,858 805.40 - 8,941.96 9,016.33 - 000-452000Child Safety Fee 12,243 673.22 - 9,689.22 23,430.27 - (11,187.27) 000-452050Indigent Defense Fee 21,655 2,751.26 16,251.83- 21,262.62 - 000-452100Platting Fees 98,000 3,500.00 57,500.00- 52,000.00 - 46,000.00 000-452200Site Plan Fee 74,000 - 22,000.00- 19,500.00 - 54,500.00 000-452300Plan Check Fee 465,000 25,864.50 588,195.91- 268,156.50 - 196,843.50 000-452310Miscellaneous Review Fee 13,500 300.00 - 2,700.00 6,000.00 - 000-452320Tree Mitigation Admin Fee 10,500 - - 7,680.00 11,090.25 - 000-452400BOA/Zoning Fees 4,000 - - 1,400.00 3,250.00 - 000-452500Food Handler Class 7,000 2,750.00 - 5,470.00 7,850.00 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452520Fire Training Classes400---- - 000-452600Specific Use/Zone Chng Fee 20,000 6,000.00 11,650.00- 30,500.00 - (10,500.00) 000-452710Zoning Ltr & Dev Rights 1,500 - - 450.00 1,800.00 - 000-453100Reinspection Fees 30,000 3,550.00 34,805.00- 33,100.00 - (3,100.00) 000-453110Swim Pool Inspection Fee 150.00 - 1,050.00 1,500.00 - - (1,500.00) 000-453200Lot Abatement 12,000 - 11,366.43- 1,766.58 - 10,233.42 000-453211Admin Fee-Inspections 7,480 2,000.00 - 6,700.00 7,540.00 - 000-453310Misc Inspection Fee - - 270.00 69.49 - - 000-453710Foster Care 500 50.00 - 800.00 650.00 - 000-454100Swim Pool Reservation Fee - - 55.00 - - 000-454200Pool Gate Admission Fee 25,000 8,584.00 17,441.80- 17,989.81 - 000-454300Seasonal Pool Pass Fee 5,500 515.00 - 7,046.00 5,034.50 - 000-456500Haz Mat Fees 800 - - - 6,984.73 (6,184.73) 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 50.00 - 850.00 650.00 - 000-458100Sale of Merchandise - - 17.00 36.50 - - 000-458300Sale of Property/Auction 22,000 120.44 28,484.95- 20,234.82 - 000-458400Civic Center Rental Fees 171,000 10,636.00 101,340.00- 95,058.25 - 75,941.75 000-458401Capital Recovery Fee-Civic Cntr 7,500 415.00 - 1,290.00 4,490.00 - 000-458450North Center Rental Fees 15,000 2,470.00 - 8,260.00 20,107.92 - (5,107.92) 000-458500Community Center Rental Fees 18,000 2,314.40 15,097.02- 24,911.12 - (6,911.12) 000-458550Pavilion Rental Fees 18,500 1,420.00 16,887.70- 15,757.00 (80.00) 000-458560Chamber of Comm rent 11,700 - - 7,800.00 5,850.00 - 000-458570Non-Resident SYSA League 12,000 - - 7,060.00 17,865.00 - (5,865.00) 000-458600Ball Field Use - - 1.76 - - - 000-458650NonResident User Fee-BVYA 11,000 - -9,090.00 8,860.00 - 000-458660BVYA Utility Reimbursement - - - 5,178.24 - - (5,178.24) 000-458670SYSA Utility Reimbursement - - - 4,926.73 - - (4,926.73) 000-458680Tournament Fees-Soccer 15,000 - - 2,400.00 7,625.00 - 000-458700Vehicle Impoundment 5,000 1,380.00 - - 1,380.00 - 000-459200NSF Check Fee 250 270.00 - 328.00 454.00 - 000-459300Notary Fee 300 66.00 - 333.00 330.00 - 000-459400Maps, Copies, UDC, & Misc F 400 5.00 - 608.18 73.10 - 000-459600Animal Adoption Fee 15,000 1,504.50 - 9,803.50 10,127.00 (77.00) 000-459700Pet Impoundment Fee 15,000 2,170.00 16,792.01- 13,229.25 - 000-459800Police Reports Fee6,500702.00 5,338.504,812.20 - - TOTAL Fees 265,195.083,324,727 - 2,246,910.51 2,404,075.25 (157.00) 920,808.75 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,690.0422,040.1723,393.99 - - TOTAL Fines30,0002,690.04 22,040.17-23,393.99 - Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 3,512.96 17,564.80- 17,564.80 - 000-473200City of Seguin - Fire Contract 40,263 3,355.26 33,552.60- 33,552.60 - 000-473300Guad Co - Library 180,000 15,901.33 135,612.00- 143,111.97 - 36,888.03 000-473400Randolph AFB-Animal Cntrl 1,000 - - 1,700.00 600.00 - 000-474200Library Services - Cibolo 20,000 20,000.00 - 17.50 20,000.00 - 000-474210Library Services-Selma 19,000 18,392.80 - 18,392.80- - 000-474400Dispatch Service - Cibolo 133,305 33,326.25 133,305.00- 133,305.00 - 000-474600School Crossing Guard-Bexar6,6002,911.57 5,151.5829,514.60 - -(22,914.60) 000-474610School Cross Guard-Guadalupe26,388.69 -3,197.67 -17,453.78 -(26,388.69) 000-474700School Officer Funding150,000 87,500.00- - - - TOTAL Inter-Jurisdictional571,245100,597.84 344,357.26-509,930.46 - 61,314.54 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 73,200.00- 73,200.00 - 14,640.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 141,850.82- 118,855.00 - 23,771.00 000-481000Transfer From Reserves 355,000 - - - - - 355,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 3,486.25 32,210.00- 34,862.50 - 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 520,647.50- 734,351.70 - 146,870.30 000-486106Transfer in-Special Events - - - 1,000.00 - - (1,000.00) 000-486317Transfer From Park Fund 13,000 - - - 5,819.26 - 000-486322Transfer-In - Library Grants - - 6,293.53 - - (6,293.53) 000-486402Transfer from City Wide Projects - 25,372.05- - - - 000-487000Interfund Charges-Fleet 98,484 8,207.00 74,420.82- 82,070.00 - 16,414.00 000-488000Interfund Charges-4B 53,000 4,416.67 45,585.31- 44,166.70 - 000-489000Transfer In -- 13,146.26-- - 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 108,750.59 976,432.76- 1,100,618.69 - 660,039.31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 35.15 - 1,597.02 270.51 - 000-491200Investment Income 30,000 3,839.94 29,959.93- 40,706.63 - (10,706.63) 000-491800Gain/Loss - - (6,057.33)- - - 000-491900Unrealized Gain/Loss (401.32) (17,027.05)- (17,609.52) - - 17,609.52 000-492100Proceeds-Sale of Land - - 57,867.85- - - (57,867.85) 000-493000Donations-Others - - 340.00 - - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap. 100.00 25,054.00- 5,206.34 - - (5,206.34) 000-493400Donation - Animal Control 1,200 810.03 - 4,362.35 4,229.63 - (3,029.63) 000-493401Donations-A/C Microchip 500 185.00 - 1,950.00 1,640.00 - (1,140.00) 000-493402Donations-Spay&Neuter 13,500 1,573.50 13,127.58- 10,968.00 - 000-493503Donations - Fire Rescue - - 25.00 - - - 000-494481LawEnforcemtOfficersStnd&Ed - - 3,550.22 50.00 - - 000-494482Grants - Police 175,510 - - - 2,893.77 - 172,616.23 000-495040Friends of N. Schertz Park - - - 3,074.00 - - (3,074.00) 000-495100Mobile Stage Rental Fees - - 2,850.00 - 1,300.00 - (2,850.00) 000-497000Misc Income-Gen Fund 81,000 23,866.52 - 5,606.15 54,943.03 (8.90) 000-497005Misc Income-Publications 290,000 19,791.00 120,133.05- 178,467.00 - 111,533.00 000-497007Misc Income-Schertz Artz (18.00) - - 2.00 - - 000-497100Misc Income-Police 25,000 1,527.78 21,877.13- 17,875.18 - 000-497200Misc Income-Library 19,000 373.35 17,845.20- 3,196.79 - 15,803.21 000-497210Misc Income-Library Copier 13,500 923.95 9,377.80 11,176.76 - 000-497300Misc Income-Animal Control 500 - - 1,506.37 105.00 - 000-497400Misc Income-Streets Dept. 20,000 2,058.03 16,420.20- 14,575.51 - 000-497500Misc Income-TML Insurance 78,000 - 49,728.90- 623.36 - 77,376.64 000-497550Misc Income-TML Reimbursemt20,000 - 28,360.38-16,712.47 - 000-497600Misc Income-Parks/Vending Mach.2,500 195.50 - 1,793.91 1,443.52 - 000-498000Reimbursmnt-Gen Fund5,000(417.00) 5,748.8930,676.92 - -(25,676.92) 000-498100Reimbursmnt Fire - Training 800 - - 1,101.00 - - 000-498105Reimburmnt Police - DEA 814.11 - 4,925.36 5,617.36 - - (5,617.36) 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 - - 9,328.07 38,143.21 - (26,143.21) 000-498500Settlement - Litigation25,000.00- - - - - TOTAL Miscellaneous791,010 56,557.54 - 381,691.46 479,647.99 (8.90) 311,370.91 TOTAL REVENUES21,134,465 1,202,133.72 - 16,116,443.94 17,936,295.54 (165.90) 3,198,335.36 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking789,283.38$ Cash in Investments LOGIC Investment-General Fund1,912,029.83 LOGIC Investment-Equip Replacement73,446.33 LOGIC Investment-Veh Replacement7,089.10 LOGIC Investment-Air Condi Replacment146,641.75 CAPITAL ONE Investment-General Fund1,340,883.99 Total Cash in Bank & Investments$4,415,956.22 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 2011-12 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 2010-11 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792) 59,545 34,762 19,836 29,955 5,346 3,535 2009-10 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 25,468 13,593 21,472 2008-09 993,926 1,293,621 615,170 1,462,883 310,479 74,418 17,900 44,799 19,066 24,241 6,294 10,447 2007-08 Sales Tax - General Fund $600,000 26% $500,000 40% -2% 25% 17% -3% 12% 23% $400,000 -2% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 415,822 461,400 365,083 347,395 535,930 398,080 408,851 2011-12 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2010-11 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 2009-10 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 2008-09 336,749 350,854 312,547 327,798 421,873 330,131 287,316 355,054 336,094 328,147 360,965 338,085 2007-08 278,463 305,857 266,440 281,920 358,831 236,723 250,774 319,604 300,214 306,696 382,743 298,203 2006-07 CITY PUBLIC SERVICE $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 96,392 76,414 77,398 - 2011-12 83,433 62,692 67,561 95,887 2010-11 77,354 61,468 63,276 80,716 2009-10 77,308 53,071 57,506 83,329 2008-09 55,729 50,340 48,120 86,572 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 62,100.00 51,250.00 - 51,250.00- - 10,850.00 Wilenchik Walk for Life 28,000.00 30,461.91- 26,451.06 - - 1,548.94 TML Dinner - - 194.69 - - - (194.69) Hal Balwin Scholarship 24,000.00 23,615.00- 16,327.00 - - 7,673.00 Miscellaneous175.0036.36- 1,399.20461.43 - TOTAL REVENUES114,275.00 51,286.36 - 54,538.34 95,621.95 - 18,653.05 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 - 200.00 10,340.89 (5,631.79)40.90 - Festival of Angels 14,250.00 12,645.61- 13,050.46 - - 1,199.54 Employee Appreciation Event 5,000.00 - 126.00 - - - 5,000.00 4th of July Jubilee - - 218.05 - - - (218.05) National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 22,571.06 30,461.91- 26,451.06 - 5,048.94 TML Events - - 194.69 - - - (194.69) Schertz Sweetheart 37,000.00 476.02 38,741.87- 20,923.10 15,326.90750.00 Hal Baldwin Scholarship11,000.00-10,354.114,767.40 - -6,232.60 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 23,047.08103,600.00 - 92,929.50 75,945.65 790.90 26,863.45 TOTAL EXPENDITURES108,750.00 23,047.08 - 92,929.50 75,945.65 790.90 32,013.45 REVENUE OVER(UNDER) EXPEND5,525.0019,676.30 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking66,449.79$ Cash in Investments MBIA Special Events46,673.94 Total Cash in Bank & Investments$113,123.73 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises - 69,317.83- - 30,619.87 - (69,317.83) Miscellaneous- 12.49- - - - TOTAL REVENUES 30,619.87 - - 69,330.32 - (69,330.32) - EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental- -- - - - TOTAL GENERAL GOVERNMENT - - - - - - - TOTAL EXPENDITURES - - - - - - - REVENUE OVER(UNDER) EXPEND69,330.32 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Franchises 000-421350Time Warner - PEG Fee - 47,530.32- -16,039.50 -(47,530.32) 000-421465T&T PEG Fee 21,787.51- A - 14,580.37 - - TOTAL Fund Transfers - 69,317.83- -30,620 -(69,317.83) Miscellaneous 000-491000Interest Earned--12.49 - - -(12.49) 000-491200Investment Income -- - - - - TOTAL Miscellaneous - - 12.49 - - -(12.49) TOTAL REVENUES- 69,330.32- -30,619.87 -(69,330.32) PEG FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank Cash Balance363,497.49$ Total Cash in Bank & Investments$363,497.49 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,000- 164,765.87-150,502.07 29,497.93- Fees14,164,2501,221,339.56 11,530,518.73-12,358,343.08 1,805,906.92- Fund Transfers634,6747,056.17 67,180.00-70,561.70 564,112.30- Miscellaneous3,618.73284,133.49393,239.95 103,260 - - TOTAL REVENUES15,082,1841,232,014.4612,046,598.0912,972,646.80 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers31,000.00- 27,366 - - - TOTAL NON DEPARTMENTAL- 27,366 - -31,000.00 -27,366.00 BUSINESS OFFICE Personnel Services383,89425,994.97 333,452.91-280,133.35 103,760.65- Supplies5,400416.25-2,735.893,566.46311.45 Human Services100---40.00- Operations Support106,00012,167.51 73,583.49-85,921.53 20,078.47- Staff Support6,705134.64-2,186.743,435.19185.73 Professional Services24,3952,367.05 14,642.05-18,342.61- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300520.00-5,367.955,800.0060.00 Operating Equipmen6,117.625,932.94 t 6,200 - - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE41,600.42403,172.08557.18 603,994 -438,086.65 W & S ADMINISTRATION Personnel Services1,184,89871,620.37 968,441.90-824,538.20 360,359.80- Supplies200,35911,443.58 158,431.92-115,618.292,207.68 Human Services1,00090.00-64.00216.00- City Support Services73,999- 38,874.05-34,379.59 39,619.41- Utility Services2,571,84434,294.94 1,852,633.50-2,396,191.74337.40 Operations Support8,750--5,267.635,978.01- Staff Support33,0001,011.32 17,129.75-14,414.911,905.51 City Assistance1,912189.00-296.00523.00- Professional Services213,00010,660.20 173,318.17-119,125.869,921.25 Fund Charges/Transfers2,657,007139,914.25 1,833,806.64-2,111,960.87 545,046.13- Maintenance Services5,560,627405,105.42 3,926,551.81-4,426,496.65118,107.90 Other Costs35,000- 28,911.85-30,956.44- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353109,561.22 1,080,244.74-206,429.57 1,023,923.43- Rental-Leasing6,07072.96-2,508.532,961.71289.50 Operating Equipment8,364572.23 22,682.70-4,036.03- Capital Outla113,606.66 y 114,000 - -132,061.40 - -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,900,183784,535.49 10,407,433.53132,769.24 3,359,980.23 -10,241,224.59 MISC & PROJECTS PROJECTS City Support Services29,000---- 29,000.00- Operations Support1,000----- Professional Services45,29011,700.00- 11,700.00- 33,590.00- Maintenance Services -- 312,750 - - - TOTAL PROJECTS11,700.00 11,700.00- 388,040 - -376,340.00 AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services------ Operations Support---248.04-- Professional Services25,210- 56,732.30-- 25,210.00- Maintenance Services292,174.16- 136,750 - - - - TOTAL AVIATION HEIGHTS WTR IMP 161,960 - -349,154.50 -161,960.00 FM3009 RD&BRIDGE EXPANSION Professional Services217.50 48,861.15-5,588.00 (5,588.00)- - Maintenance Services37.74 71,088.87 - - - - 217.5076,676.87 TOTAL FM3009 RD&BRIDGE EXPANSION - -48,898.89 -(76,676.87) TOTAL MISC & PROJECTS11,917.5088,376.87 550,000 -398,053.39 -461,623.13 TOTAL EXPENDITURES15,081,543838,05311,108,36510,898,982133,326 - ** REVENUE OVER(UNDER)EXPENSES **2,073,664.32 641 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 164,765.87150,502.07 000-421490Tower Leasing180,000 - - - TOTAL Franchises 180,000 - 164,765.87- 150,502.07 - 29,497.93 Fees 000-455200Garbage Collection Fee 3,400,000 276,270.05 2,656,673.50- 2,897,463.19 - 502,536.81 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 18,196.70 179,359.32- 208,491.31 - 32,508.69 000-455800W&S Line Constructn Reimbursemnt50,000 2,211.74 26,753.60- 20,907.44 - 29,092.56 000-457100Sale of Water 7,210,000 669,917.66 5,960,341.27- 6,249,165.74 - 960,834.26 000-457110Edwards Water Lease 166,250 - 192,995.00- 188,163.59 - (21,913.59) 000-457120Water Transfer Charge-Selma 5,000 - - 2,668.48 17,761.47 - (12,761.47) 000-457130Water Transfer Charge-U. C. 1,000 - - 1.28 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 5,669.00 63,545.58- 46,152.40 - 43,847.60 000-457400Sewer Charges 2,800,000 231,891.49 2,284,953.08- 2,559,255.53 - 240,744.47 000-457500Water Penalties 180,000 16,922.92 142,825.60- 146,742.44 - 33,257.56 000-459200NSF Check Fee-Water&Sewer2,000260.001,972.022,350.00 - - TOTAL Fees14,164,2501,221,339.56 11,530,518.73-12,358,343.08 1,805,906.92 Fund Transfers 000-481000Transfer In- Reserve550,000---- - 550,000.00 7,056.1767,180.00 70,561.70 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 634,674 7,056.17 67,180.00- 70,561.70 - 564,112.30 Miscellaneous 000-490000Misc Charges 10,000 230.07 - 6,432.28 638.12 - 000-491000Interest Earned 1,000 163.81 - 1,244.80 1,601.25 - 000-491200Investment Income 6,000 631.58 13,552.84 9,210.60 - (3,210.60) 000-493400Donations-Christmas Activities - - 1,000.00 750.00 - - 000-496050SSLG - SAWS Reservation - 134,500.00- 269,000.00 - - (269,000.00) 000-497000Misc Income-W&S - 7,604.18 34,166.37 -2,593.27 - (34,166.37) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 - 76,314.75- 77,873.61 - (1,558.61) 000-498200W&S Project Reimbursement41,193.30 - - - - - TOTAL Miscellaneous 103,260 3,618.73 284,133.49- 393,239.95 - (289,979.95) TOTAL REVENUES15,082,1841,232,014.46 12,046,598.09- 12,972,646.80 2,109,537.20 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking310,557.71$ Cash in Investments Lone Star Investment-Water&Sewer1,360,339.31 Lone Star Investment-W&S Customer Deposits294,234.58 Lone Star Investment-W&S Equip Replacement373,792.02 Lone Star Investment-W&S Veh Replacement545,033.46 Lone Star Investment-Water/SSLGC SAWS404,237.88 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $4,033,545.87 Total Cash in Bank & Investments4,344,103.58$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 480,532.50 2,738,356.17- 2,979,107.36 1,110,125.64(300.00) Inter-Jurisdictional1,438,836 291,321.46 1,320,409.80- 1,373,821.94 65,014.06- Miscellaneous5,082.43-99,961.4898,296.84 256,000 - TOTAL REVENUES 776,936.39 - 4,158,727.45 4,451,226.14 (300.00) 1,332,842.86 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,586,891193,096.12 2,152,266.27-2,123,536.42 463,354.58- Supplies 30,644.37 250,359.08- 263,854.10 15,406.99 327,239 Human Services 230.00 - 614.00 230.00 800 - City Support Services 10,974.19- 10,277.40 31,505 - - 21,227.60 Utility Services 11,865.09 87,882.57- 92,994.44 19,490.5615.00 112,500 Operations Support 2,767.90 37,438.98- 42,804.84 1,000.00 52,600 Staff Support 11,240.78 55,279.80- 58,065.08 9,391.32 72,400 City Assistance 1,076.00 11,076.80- 9,553.28 9,000 - (553.28) Professional Services 10,019.82 102,412.28- 106,975.94 4,045.06 152,140 Fund Charges/Transfers2,084,785 10,182.70 596,816.58- 753,161.90 - 1,331,623.10 Maintenance Services 1,552.35 21,779.91- 38,017.87 39,560 - 1,542.13 Debt Service 5,368.00 242,270.49- 11,231.00 111,176 - 99,945.00 Rental-Leasing - 3,604.76 - 20,000.00 20,000 - - Operating Equipment 171.99 24,406.68- 41,574.77109,331.65 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 278,215.12 - 3,597,182.39 3,552,277.04 139,190.02 2,022,128.94 5,713,596 TOTAL EXPENDITURE278,215.12-3,597,182.393,552,277.04139,190.02 S 5,713,596 ** REVENUE OVER(UNDER) EXPENSES 898,949.10 * 70,173 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 468,802.50 - 2,661,756.17 2,900,740.36 - 917,992.64 75.96% 000-456110Subscription Program Fees55,000 60.00 - 18,640.00 17,985.00 32.70% - 37,015.00 000-456120EMT Class - Fees95,200 11,670.00 - 57,960.00 57,156.00 (300.00) 38,344.00 59.72% 000-459200Paramedic Class Fees120,000 - - - - 000-456130Immunization Fees - 3,226.00- - - - (3,226.00) 000-459200NSF Check Fee -- - - - - - TOTAL Fees4,088,933480,532.50 2,738,356.17- 2,979,107.36 1,110,125.64(300.00) Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 239,538.63- 214,594.92 - - 71,531.08 000-474300Cibolo Support 222,018 55,524.98 213,300.00- 222,099.92 100.04% - 000-475100Comal Co ESD #6 20,726.4882,875 37,920.00- 75,997.10 - 6,877.90 000-475200Live Oak Support 148,125 40,082.38 148,125.00- 160,329.52 - (12,204.52) 000-475300Universal City Support 226,168 56,562.83 204,412.52- 227,101.32 - 000-475400Selma Support 16,910.8567,618 68,730.00- 67,643.40 100.04% - 000-475500Schertz Support 384,046 96,046.91 387,459.48- 384,187.64 - 000-475600Santa Clara Support 2,213.068,849 - 7,901.01 8,852.24 100.04% - 000-475800Marion Support13,0113,253.9713,023.1613,015.88 - - TOTAL Inter-Jurisdictional1,438,836291,321.46 1,320,409.80- 1,373,821.94 65,014.06- Miscellaneous 000-491000Interest Earned--- 0.00% - - - 000-491200Investment Income 62.14 - 486.21 549.94 - - 000-493203Donations-EMS 6,000 11,450.00- 895.00 - - 5,105.00 000-493204Donations-Dilworth Fund - 1,000.00 - 0.00% - - - 000-493205Donations- Golf Tournament - 4,430.00 15,550.00 - - - (15,550.00) 000-497000Misc Income 150,000 4,774.37 71,602.86- 77,260.08 - 72,739.92 000-497100Recovery of Bad Debt100,000245.9210,992.414,041.82 - - TOTAL Miscellaneous256,0005,082.43 99,961.48-98,296.84 - 157,703.16 TOTAL REVENUES5,783,769776,936.39 4,158,727.45- 4,451,226.14 1,332,842.86(300.00) SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank $ (343,454.35) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,297.67 $(42,156.68) Total Cash in Bank & Investments C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60056,607.40 581,019.60- 621,535.53 -88,064.47 Fund Transfers - - - - - - - 0.00% Miscellaneous900927.931,395.85 707.09 - - TOTAL REVENUES 57,314.49710,500581,947.53 -622,931.38 - 87,568.62 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 374,40420,169.78 288,552.55- 257,503.38 -116,900.62 Supplies 2,048.838,300 - 3,190.60 3,892.85 874.95 Human Services 325 - - - - -325.00 City Support Services 22,103 - 5,832.18 1,508.72 - -20,594.28 Utility Services 24,188 1,534.64 13,771.81- 16,341.86 337.40 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 281.01 - 3,668.62 3,285.79 806.06 City Assistance 840 - 15.00 72.00 - -768.00 Professional Services 20,698 15,171.49- 14,959.25 - -5,738.75 Fund Charges/Transfers 199,87611,785.92 108,677.50- 117,859.20 -82,016.80 Maintenance Services 22,000 - 1,987.00 42.12 - -21,957.88 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 17,564 1,632.07 18,137.56- 3,264.14 14,299.86 - Rental/Leasing562-561.29 99.87% - - - Operating Equipment-- - - - - - TOTAL DRAINAGE 37,452.25701,725459,104.31 2,018.41419,390.60280,315.99 - TOTAL EXPENDITURE 37,452.25701,725459,104.31 2,018.41419,390.60280,315.99 S - ** REVENUE OVER(UNDER) EXPEND8,775203,540.78 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 3,617.18 4,328.99 4,000 438.77 -(328.99) 000-457600Drainage Fee 56,168.63-577,402.42617,206.54 -88,393.46 705,600 TOTAL Fees56,607.40 581,019.60-621,535.53 88,064.47- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 227.76 72.92 100 7.94 - 000-491200Investment Interest - 538.53 658.97 109.83% 600 81.39 - 000-497000Misc Income-Drainage-161.64663.96 200 617.76 - TOTAL Miscellaneous - 927.93 1,395.85 900 707.09 -(495.85) TOTAL REVENUES57,314.49 581,947.53- 622,931.38 87,568.62- 710,500 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 155,320.83 Cash in Investments Lone Star Investment-Drainage Maint Fund383,739.61 Total Cash in Bank & Investments$539,060.44 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 40,448.46 222,452.44- 295,027.49 -95,726.51 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50062.90-925.86299.70 - TOTAL REVENUES 40,511.36411,386-223,378.30295,327.19 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - 2,315.40 1,826.50 - -673.50 City Support Services 12,907.0085,948 59,630.85- 61,628.00 -24,320.00 Operations Support 56,425 907.00 - 9,389.93 19,942.31 1,042.00 Professional Services 2,500 - 2,500.00 2,500.00 - - -100.00% Fund Charges/Transfers 193,876 63,135.50 141,850.82- 170,105.00 -23,771.00 Operating Equipment 55,337 9,349.99 - 32,090.22- 2,500.00 Capital Outlay -14,800--- - TOTAL NONDEPARTMENTA 86,299.49411,386-215,687.00288,092.03 L 3,542.00 TOTAL EXPENDITURE 86,299.49411,386-215,687.00288,092.03 S 3,542.00 7,235.16 REVENUE OVER(UNDER) EXPENDITURE - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 40,448.46222,452.44295,027.49 -95,726.51 - TOTAL Taxes 390,754 40,448.46 222,452.44- 295,027.49 - 95,726.51 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned3002.89-219.6888.07 - 211.93 000-491200Investment Interest 200 60.01 - 106.18 211.63 105.82% - (11.63) 000-497000Misc Income600.00- - - - - - TOTAL Miscellaneous50062.90-925.86299.70 - 200.30 TOTAL REVENUES 411,386 40,511.36 223,378.30- 295,327.19 - 116,058.81 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank $(19,584.69) Claim on Operating Cash Pool-Checking Cash in Investments MBIA - Hotel Tax250,092.96 Federated Investment-Hotel/Motel78,244.71 Total Cash in Bank & Investments$308,752.98 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 2011-12 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 2010-11 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 2009-10 17,549 20,134 18,461 17,255 15,138 19,297 19,548 24,769 29,695 32,336 37,633 45,428 2008-09 19,122 21,531 20,663 19,204 17,475 20,760 25,081 24,748 23,122 26,866 30,247 26,313 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,00030,000.00 107,000.00- 148,025.00 -101,975.00 Tree Mitigation Fees 75,000 43,520.00- 62,844.75 - -12,155.25 Miscellaneous600-544.44553.80 53.58 - TOTAL REVENUES 30,053.58325,600-151,064.44211,423.55114,176.45 - EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services - - 6,500.00 - - -(6,500.00) Fund Charges/Transfers 13,000 - - 5,819.26 - -7,180.74 Maintenance Services-Landscape 3,500 28,399.00- 135.88 - -3,364.12 Operating Equipment 32,000 56,748.78- 39,057.72 2,781.20 3,420.00 Capital Outlay -169,000--52,109.45108,490.55 8,400.00 TOTAL PARKLAND DEDICATION 3,420.00217,500-85,147.78103,622.31102,696.49 11,181.20 TREE MITIGATION Maintenance Services-Trees28,500 31,869.55- 3,923.00 13.76% 300.00 -24,577.00 Capital Outlay18,000 ---19,900.00 - TOTAL TREE MITIGATION 300.0046,500-31,869.5523,823.00 - TOTAL EXPENDITURE 3,720.00264,000-117,017.33127,445.31125,373.49 S 11,181.20 REVENUE OVER(UNDER) EXPEND 83,978.2461,600 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,00030,000.00 107,000.00- 148,025.00 101,975.00- 000-458900Tree Mitigation -75,00043,520.00 -62,844.75 - TOTAL Fees 325,00030,000.00 150,520.00- 210,869.75 114,130.25- Miscellaneous 000-491000Interest Earned 100 6.94 - 208.46 33.27 66.73- 000-491200Investment Interest 500 46.64 - 335.98 520.53 (20.53)- 000-497000Miscellaneous Income--- - - - TOTAL Miscellaneous60053.58-544.44553.80 46.20- TOTAL REVENUES 325,60030,053.58 151,064.44- 211,423.55 114,176.45- PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$156,281.71 Cash in Investments Federated Investment-Park Fund193,014.27 Federated Investment-Tree Mitigation126,431.41 Total in Investment Pool 319,445.68 Total Cash in Bank & Investments$475,727.39 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 170,786.92 2,160,219.77- 1,303,572.44 -1,421,827.56 Fund Transfers10,673,600 - - - - -10,673,600.00 Miscellaneous314,0004,386.58291,342.74236,650.71 - - TOTAL REVENUES13,713,000 175,173.502,451,562.511,540,223.15 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 335.01 1,121,172.29- 5,899.97 -16,100.03 Maintenance Services 10,000 - - - - -10,000.00 Fund Charges/Transfers - - - - - - Debt Service - - 108,671.00- - -(108,671.00) Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000335.011,129,600.29114,679.47 L - - MISC & PROJECTS Projects13,025,000-10,488.42 -91,581.34 -13,014,511.580.08% Schaefer RD Water Improvements599,643 -3,075.00 - - -596,568.00 Northcliffe Elevated Tnk -- - - - - Northcliffe Water Plant -- - - - - Town Creek Project -- - - - - Live Oak Water Plant- - - -204,531.74 - Loop Feed Water Line -- - - - - viation Heights WTR IMP344,233.90- A - - - - TOTAL MISC & PROJECTS13,624,643 -640,346.9813,563.42 - - TOTAL EXPENDITURE13,662,643 335.011,769,947.27128,242.89 S - - REVENUE OVER(UNDER) EXPENDITURES50,3571,411,980 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 97,935.00 1,177,679.74- 818,899.00 -660,701.00 000-455910Capital Recovery - Waste Wtr613,800 60,251.92 758,141.74- 434,273.44 -179,526.56 12,600.00224,398.2950,400.00 000-455913Cap Recovery-North Sewer Tr 632,000 - - TOTAL Fees2,725,400170,786.92 2,160,219.77-1,303,572.44 -1,421,827.56 Fund Transfers 000-481000Transfer from Reserves10,673,600---- -10,673,600.00 000-486202Transfer in-Water -- - - - - 000-486406Transfer in-Public Improvement -- - - - - TOTAL Fund Transfers10,673,600 - - - - -10,673,600.00 Miscellaneous 000-491000Interest Earned 500 12.44 - 437.53 252.20 - 000-491200Investment Income 30,000 5,053.13 32,306.18- 44,714.39 -(14,714.39) 000-491800Gain/Loss - - (7,055.28) - - -7,055.28 000-491900Unrealized Gain/Loss-Cap One (19,317.61)- (21,310.91) - (729.30) -21,310.91 000-497000Misc Income 50.31 - - 50.31 - - 000-498000Reimbursmnt - - 220,000.00- - -(220,000.00) 000-498100Reimbursmnt - FM 78 Project 41,666.64- - - - - 236,250.00- 000-498200Re-imbursement-Water Meters 283,500 - - - TOTAL Miscellaneous314,0004,386.58 291,342.74-236,650.71 -77,349.29 TOTAL REVENUES13,713,000 175,173.50 - 2,451,562.51 1,540,223.15 -12,172,776.85 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking281,310.21$ Cash in Investments Lone Star Investment-Capital Recovery Water2,009,775.79 Lone Star Investment-Capital Recovery Sewer566,071.56 Capital One-Investment1,717,989.01 Total Cash in Bank & Investments4,575,146.57$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 19,875.124,281,098 - 3,410,891.29 4,297,543.41 -(16,445.41) - - - - Fund Transfers - - Miscellaneous2,2501,908.7515,483.8411,763.21 - - TOTAL REVENUES 21,783.874,283,3483,426,375.134,309,306.62 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL - - 750.00 36,960.39 Professional Services - -(36,960.39) Debt Service 976,349.514,276,6673,625,353.504,051,274.03 - - TOTAL GENERAL GOVERNMEN 976,349.514,276,6673,626,103.504,088,234.42 T - - TOTAL EXPENDITURE 976,349.514,276,6673,626,103.504,088,234.42 S - - ** REVENUE OVER(UNDER) EXPEND6,682221,072.20 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET83.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 19,875.123,410,891.294,297,543.41 - - TOTAL Taxes4,281,09819,875.12 3,410,891.29-4,297,543.41 - (16,445.41) Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 12.14 14,435.29- 40.93 - 000-491200Investment Earnings1,5001,896.611,048.5519,838.35 - -(18,338.35) 000-497000Misc Income- (8,116.07) - - - - TOTAL Miscellaneous2,2501,908.75 15,483.84-11,763.21 - (9,513.21) TOTAL REVENUES4,283,348 21,783.87 3,426,375.13- 4,309,306.62 - (25,958.62) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent 750.001,150.00 - - - -(1,150.00) 35,810.39- 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services--750.0036,960.39 - -(36,960.39) Debt Service 101-555612Bond-GO Refunding 2010-Principal -240,000 - 285,000.00 240,000.00 - 101-555612.1Bond-GO Refunding 2010 Interest82,650 - 80,502.08- 42,525.00 -40,125.00 101-555622Schertz C O SR2003-Principal200,000 - 190,000.00- 200,000.00 - 101-555622.1Schertz C O SR2003-Interest 53,800 - 60,820.00- 7,432.50 -46,367.50 101-555624Comm Proj Bond-SR04-Principal315,000 - 325,000.00- 315,000.00 - 101-555624.1Comm Proj Bond SR04-Interest251,009 - 265,008.13- 13,796.88 -237,212.12 101-555626LS&D SR2006-Principal 100,000 - - 100,000.00- - 101-555626.1LS&D SR2006-Interest 648,982 323,490.61 650,981.25- 648,981.25 - 101-555628CO Bond 2007-Principal 102,900 102,900.00 99,709.25- 102,900.00 - 101-555628.1CO Bond 2007-Interest 22,625 11,312.21 26,523.79- 22,176.64 - 101-555629GO Bond 2007-Principal 225,000 - 275,000.00- 225,000.00 - 101-555629.1GO Bond 2007-Interest 198,922 97,069.50 209,096.25- 198,819.50 - 101-555630GO Bond SR2008 Principal 370,000 - 355,000.00- 370,000.00 - 101-555630.1GO Bond SR2008 Interest 364,679 178,519.25 379,650.25- 364,679.00 - 101-555631GO Bond SR2009 Principal 200,000 - 140,000.00- 200,000.00 - 101-555631.1BO Bond SR2009 Interest140,656.25 278,813 - -283,062.50 -138,156.25 101-555633GO SR2011 Principal 90,000.00- 90,000 - - - 101-555633.1GO SR2011 Interest186,118.75 532,286.46- 532,287 - - 101-555634GO SR2011A Refund Principal 140,000.00- - - - -(140,000.00) 76,939.19 97,020.55- 101-555634.1GO SR2011A Refund Interest - - - TOTAL Debt Service4,276,667976,349.51 3,625,353.50-4,051,274.03 -225,392.47 TOTAL EXPENDITURES4,276,667 976,349.51 3,626,103.50- 4,088,234.42 -188,432.08 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking201,610.15$ Cash in Investments MBIA Investment- Tax I&S110,314.17 Federated Investment-Tax I&S56.89 Total Cash in Bank & Investments$311,981.21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET83.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042197,168.23 1,485,580.53- 2,125,136.51 - 266,905.49 Fund Transfers - - - 0.00% - - - Miscellaneous 1,855.2517,20015,519.06 -23,035.46 - TOTAL REVENUES 199,023.482,409,2421,501,099.59 -2,148,171.97261,070.03 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies28,0001,341.14 17,124.41-23,191.90481.26 Utility Service 90,600 7,641.56 50,906.72- 59,180.16 - 31,419.84 Maintenance Services 62,200 1,393.40 54,603.24- 44,397.01 339.00 Operating Equipment - 6,999.31 - 0.00% - - - Capital Outlay --- - - - TOTAL NONDEPARTMENTA 10,376.10180,800129,633.68 820.26126,769.07 L - ECONOMIC DEVELOPMEN T Personnel Services 241,233 20,973.20 133,257.37- 190,421.03 - 50,811.97 Supplies 1,100 15.90 - 707.34 610.07 - Human Services 200 - - - - - City Support Services 42,772 997.20 16,659.44- 9,700.41 97.32 Utility Services 7,200 112.43 - 2,484.93 1,172.55 - 6,027.45 Operations Support 63,600 26,079.27 51,247.78- 47,422.32 12.00 Staff Support 112,800 1,863.86 71,229.02- 76,276.28 4,301.61 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 56,515.65 181,632.57- 183,295.34 23,605.21 Fund Charges/Transfers 105,985 4,665.42 95,585.31- 46,654.20 - 59,330.80 Fund Replenish-Fund Balance - - - 0.00% - - - Maintenance Services - - - 0.00% - - - Debt Service 795,154153,133.25 792,432.00- 766,147.75 29,006.25 - Operating Equipment -2,3501,112.82161.94 - - TOTAL ECONO DEVELOPMEN 264,356.181,975,8941,346,348.58 28,016.141,331,861.89616,015.97 T - TOTAL EXPENDITURE 274,732.282,156,6941,475,982.26 28,836.401,458,630.96669,226.64 S - ** REVENUE OVER(UNDER) EXPEND252,548 689,541.01 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 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,392,042197,168.231,485,580.532,125,136.51 - - TOTAL Taxes2,392,042197,168.23 1,485,580.53- 2,125,136.51 -266,905.49 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 8.05 - 189.24 134.94 - 000-491200Investment Earnings 15,000 519.12 - 9,835.12 7,170.18 -7,829.82 000-497000Misc Income 1,328.082,000 - 5,494.70 15,730.34 -(13,730.34) 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 1,855.25 15,519.06- 23,035.46 - TOTAL REVENUES2,409,242199,023.48 1,501,099.59-2,148,171.97 -261,070.03 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking110,077.27$ Cash in Investments MBIA Investment-Economic Development Corp2,476,072.33 Schertz Bank & Trust-Certificate of Deposit- Schertz Bank & Trust-Certificate of Deposit1,037,007.40 Total Cash in Bank & Investments3,623,157.00$ 4B SALES TAX $300,000 26% 40% $250,000 -2% 17% 25% 19% -3% -2% 23% $200,000 12% $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 207,911 230,700 182,541 173,698 267,965 199,040 204,426 2011-12 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2010-11 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 2009-10 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 155,080 185,494 159,088 2008-09 168,374 175,427 156,274 163,899 210,937 165,065 143,668 177,527 168,047 164,073 180,483 169,043 2007-08 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JULY 31st, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust3,244,632.24,233,208.79.0500,924,856.97,913,433.52,244,632.24,244,632.24 305533 TOTAL OPERATIONS3,244,632.24,233,208.79,924,856.97,913,433.52,244,632.24,244,632.24 35533 LOGIC General Fund1,912,029.83,811,540.26.237989.5700,000.00,912,029.83 N/A,912,029.83 204911 G/F-Equipment Replacement73,446.3373,431.500.2379 -14.8373,446.33 N/A73,446.33 G/F-Vehicle Replacement7,089.10,087.67.2379 -.43,089.10 N/A,089.10 70177 G/F-Air Conditioner Replacement146,641.75146,612.120.2379 -29.63146,641.75 N/A146,641.75 ,697,191.09.237942.93-,697,534.02,697,534.02 SR2009 Bond-Street Projects(II)1,697,534.02 10311 TOTAL LOGIC3,836,741.03,735,862.6478.3900,000.00,836,741.03,836,741.03 48933 LONESTA R Capital Recovery - Sewer566,071.56480,956.180.2500 -85,115.38566,071.56 N/A566,071.56 Capital Recovery - Water2,009,775.79,754,363.57.2500 -55,412.22,009,775.79 N/A,009,775.79 10222 Drainage Fund383,739.61383,658.220.2500 -81.39383,739.61 N/A383,739.61 GO SR2011 Animal Shelter2,139,316.06,155,857.37.250057.146,998.45,139,316.06 N/A,139,316.06 204122 GO SR2011 Athletic Fields1,482,792.101,482,477.590.2500 -314.511,482,792.10 N/A1,482,792.10 GO SR2011 Soccer Fields1,313,451.30,343,624.60.250084.640,457.94,313,451.30 N/A,313,451.30 102311 GO SR2011 Swimming Pool2,880,951.592,910,427.960.2500617.0530,093.422,880,951.59 N/A2,880,951.59 W/S-Customer Deposits294,234.5894,172.17.2500 -2.4194,234.58 N/A94,234.58 20622 W/S-Equipment Repl/Cap.Imp373,792.02373,712.740.2500 -79.28373,792.02 N/A373,792.02 Water&Sewer1,360,339.31,360,050.77.2500 -88.54,360,339.31 N/A,360,339.31 10211 W/S-Vehicle Replacement545,033.46544,917.850.2500 -115.61545,033.46 N/A545,033.46 04,152.14.25005.74-04,237.8804,237.88 Water/SSLG - SAWS404,237.88 40844 TOTAL LONESTA13,753,735.263,488,371.1642,913.917,549.813,753,735.263,753,735.26 R13711 MBIA Tax I&S110,314.171,264,090.910.2400223.261,154,000.00110,314.17 N/A110,314.17 Police Forfeiture359,771.5059,697.30.2400 -4.2059,771.50 N/A59,771.50 30733 Economic Development Corporation2,476,072.332,525,553.210.2400519.1250,000.002,476,072.33 N/A2,476,072.33 Hotel Tax250,092.9600,044.37.2400 -0,048.5950,092.96 N/A50,092.96 20522 Special Events Fund46,673.9466,662.580.240011.3620,000.0046,673.94 N/A46,673.94 01,235.53.24002.14-01,297.6701,297.67 EMS Tax Notes 2010301,297.67 30633 TOTAL MBIA3,544,222.57,717,283.900,938.67,224,000.00,544,222.57,544,222.57 45133 FEDERATED SR2007a Bond-City Wide Projects869,036.18868,909.290.1700 -126.89869,036.18 N/A869,036.18 Hotel Occupancy Tax78,244.718,233.29.1700 -1.428,244.71 N/A8,244.71 70177 Park Fund (Developers Fee)193,014.27192,986.090.1700 -28.18193,014.27 N/A193,014.27 Park Fund (Tree Mitigation)126,431.4126,412.95.1700 -8.4626,431.41 N/A26,431.41 10111 Tax I&S56.8956.880.1700 -0.0156.89 N/A56.89 4,741.95.1700.53-4,748.484,748.48 Library Board Fund44,748.48 40644 TOTAL FEDERATED1,311,531.94,311,340.45 -91.49,311,531.94,311,531.94 1111 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,268,117.661,336,037.952.9700 276.951,444.761,337,205.76 N/A1,340,883.99 ,747,413.07.1000,573.41355.01,748,631.47,717,989.01 Capital One Capital Recovery1,618,201.96 13111 TOTAL CAPITAL ONE2,886,319.62,083,451.02 631.96,018.17,085,837.23,058,873.00 3333 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS TOTAL CAPITAL ONE 7% 11% 9% TOTAL LOGIC TOTAL FEDERATED 13% 4% TOTAL MBIA 12% TOTAL LONESTAR 44% City Portfolio By Use Pooled-Daily Designated Funds, Operations, $7,429,352.75 $3,244,632.24 $10,787,319.13 Special Revenue Funds, Debt Service Fund, $8,848,330.54 $110,371.06 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-11NOV-11DEC-11JAN-12FEB-12MAR-12APR-12MAY-12JUN-12JUL-12AUG-12SEP-12 0.02000.02000.01000.04000.08000.05000.07000.03000.07000.0700 1 Month T-Bill 0.01000.01000.02000.06000.08000.07000.10000.07000.10000.1100 3 Month T-Bill 0.06000.06000.06000.08000.13000.15000.15000.14000.14000.1400 6 Month T-Bill 0.46000.52000.49000.50000.52000.53000.53000.51000.50000.5090 Schertz Portfolio 0.05000.05000.05000.05000.05000.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.40000.40000.40000.40000.40000.4000 CD 365 Days 0.80000.80000.30000.30000.30000.30000.30000.30000.30000.3000 CD 180 Days 0.25000.25000.10000.10000.1000 CD 90 Days 0.05000.05000.05000.0500 CD 28 Days 0.14700.18740.20850.25130.28600.29420.28640.26830.25140.2379 LOGIC 0.23000.25000.28000.31000.26000.27000.27000.24000.25000.2500 LoneStar 0.14000.15000.19000.21000.25000.24000.25000.26000.26000.2400 MBIA 0.09000.14000.13000.15000.22000.21000.19000.18000.18000.1700 Federated 2.32432.84002.83003.07003.07003.15003.15003.13003.03003.0400 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:7/31/2012 General Fund Assets P DueMaturitySharesCostMrk Value Cash & Equivalents Fidelity Inst Prime Mmkt Cl III #6918,117.668,117.668,117.662.000.01 JPMorgan Chase Disc Coml Paper9/21/201252.0040,000.00 39,940.3339,940.33 Total Cash & Equivalents8,117.6648,057.998,057.99 44 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014743.00125,000.00141,987.30138,383.756,875.00 Federal Home Loan Bks Cons Bds6/21/2013325.0080,000.0082,004.4081,193.601,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151233.00100,000.00116,185.00114,668.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/201278.0050,000.0054,010.5050,460.502,250.00 Federal Home Ln Mtg Corp Deb11/15/2013472.00170,000.00191,084.25180,296.908,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013420.00250,000.00250,000.00261,905.0010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014847.00200,000.00200,609.40202,020.001,500.00 Federal Natl Mtg Assn 7/28/20151092.00125,000.00132,828.63132,396.252,968.00 US Treasury Note11/30/20151217.0020,000.0020,680.4720,690.80275.00 US Treasury Note2/28/2014577.00100,000.0099,757.82100,075.00 Total Fixed Income,220,000.001,289,147.77,282,089.80 113 Total Assets54.03,268,117.661,337,205.76,330,147.79 6113 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #6913,201.963,201.963,201.961.000.01 JPMorgan Chase Disc Coml Paper9/21/201252.0080,000.0079,880.6779,880.67 Total Cash & Equivalents3,201.9683,082.633,082.63 88 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014743.00165,000.00187,423.24182,666.559,075.00 Federal Home Loan Bks Cons Bds6/21/2013325.00100,000.00102,505.50101,492.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151233.00200,000.00230,779.00229,336.009,750.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/201278.00150,000.00162,031.50151,381.506,750.00 Federal Home Ln Mtg Corp Deb11/15/2013472.00250,000.00281,006.25265,142.5012,187.00 Federal Natl Mtg Assn Nts10/15/2013441.00200,000.00223,001.60210,622.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014847.00220,000.00220,078.68222,222.001,650.00 Federal Natl Mtg Assn7/28/20151092.00135,000.00143,454.91142,987.953,206.00 US Treasury Note11/30/20151217.0015,000.0015,510.3515,518.10206.00 US Treasury Note/28/201477.0000,000.0099,757.8100,075.00 2511 Total Fixed Income,535,000.001,665,548.84,621,443.60 115 Total Assets643.011,618,201.961,748,631.471,704,526.235