Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
09-JUNE 2012 FINANCIAL STATEMENT
JUNE 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department August 17, 2012 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725483,380.75 9,392,499.25-10,696,328.27 1,107,396.73 Franchises 1,617,000 107,933.07 800,976.85- 1,106,816.74 - 510,183.26 Permits 1,187,800 87,039.50 1,409,360.98- 815,610.25 - 372,189.75 Licenses 48,300 4,887.50 51,948.10- 53,417.50 - (5,117.50) Fees 3,324,727 350,461.69 2,082,645.43- 2,138,880.17 1,185,921.83(75.00) Fines 30,000 2,789.28 19,558.31- 20,703.95 - Inter-Jurisdictional 571,245 25,785.66 287,628.40- 409,332.62 - 161,912.38 Fund Transfers 1,760,658 115,044.12 886,337.68- 991,868.10 - 768,789.90 Miscellaneous791,01055,432.62368,876.16423,090.45(27.90) - TOTAL REVENUES21,134,4651,232,754.1915,299,831.1616,656,048.05(102.90) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,366.30 17,185.45- 15,807.39 - Supplies 700 236.44 - 239.97 579.15 15.99 City Support Services 18,000 3,842.30 13,394.68- 7,544.38 - 10,455.62 Utility Services - - - - - - Operations Support 100 - - 161.35 - - Staff Support19,90060.36 16,345.25 -11,780.27 - Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 5,505.40 42,761.72- 40,276.17 15.99 CITY MANAGE R Personnel Services852,20170,955.78 535,680.52-595,731.58 - 256,469.42 Supplies4,731 122.71 - 805.32 2,724.49 56.80 1,949.71 - - - - City Support Services - - Operations Support - - - 45.00 - - Staff Support 30,150 3,185.61 19,357.25- 20,883.46 4,022.19 Operating Equipment -1,393.36 - - - - TOTAL CITY MANAGER 887,082 74,264.10 557,236.45- 619,384.53 4,078.99 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services257,113 19,180.84 177,997.01- 184,883.59 - 72,229.41 Supplies2,500 - - 1,596.38 1,318.87 161.62 1,019.51 City Support Services1,000 - - - - - Operations Support 3,000 - - 1,951.00 1,558.00 948.00 Staff Support 5,500 185.55 - 2,042.13 2,012.18 416.41 Court Support 800 - - - - - Professional Services 71,100 4,232.81 38,444.00- 40,644.06 8,064.70 Maintenance Services 2,200 900.00 - 600.00 1,299.94 - Operating Equipment1,000(550.00) 497.14650.0042.13 - TOTAL MUNICIPAL COURT 23,949.20344,213 - 223,280.52 232,213.78 9,632.86 102,366.36 CUSTOMER RELATIONS-311 Personnel Services109,700 7,744.45 60,763.93- 72,460.50 - 37,239.50 Supplies300 - - 346.54 150.61 24.64 124.75 Staff Support1,018 1,069.97636.20 - - - Operating Equipment500 213.00- - - - TOTAL CUSTOMER RELATIONS-311 111,518 7,744.45 62,180.44- 73,460.31 24.64 PLANNING & ZONING Personnel Services 139,925 10,277.89 98,184.72- 99,812.47 - 40,112.53 Supplies 2,700 51.08 - 477.76 895.18 130.52 Operations Support 750 - - 77.95 - - Staff Support 17,150 - - 3,480.75 1,759.35 43.06 Professional Services 76,650 194.56 57,351.48- 38,747.85 187.88 Operating Equipment3,500 2,112.001,055.00 - - - TOTAL PLANNING & ZONING240,67510,523.53 160,627.66-143,326.85361.46 LEGAL SERVICES Operations Support 13,000 69.85 - 9,124.16 69.85 - 12,930.15 Professional Services245,00039,737.49136,154.68281,654.8943.21 - TOTAL LEGAL SERVICES 258,000 39,807.34 145,278.84- 281,724.74 43.21 (23,767.95) 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services643,323 45,226.59 456,115.60- 427,620.77 - 215,702.23 Supplies66,535 5,333.05 - 49,389.41 51,273.08 5,938.20 9,323.72 Utility Services112,000 8,090.42 - 52,637.05 62,122.54 - 49,877.46 Staff Support13,179 236.30 - 8,036.57 8,161.97 662.16 4,354.87 Maintenance Services99,119 5,164.96 - 90,094.51 73,438.49 5,793.87 19,886.89 Rental/Leasing400 74.40 - 763.92 331.59 - Operating Equipment3,396 1,278.552,564.55224.46 - - Capital Outlay24,500 -2,524.53 - - - TOTAL FACILITIES MAINTENANCE 962,452 64,125.72 660,840.14- 625,512.99 12,618.69 CITY SECRETAR Y Personnel Services 164,529 12,574.94 119,404.64- 118,514.59 - 46,014.41 Supplies1,250 34.06 - 1,109.09 784.75 19.69 445.56 City Support Services9,780 24.00 - 6,788.22 1,926.20 - Staff Support8,605623.97 5,055.703,395.521,049.20 - TOTAL CITY SECRETARY 184,164 13,256.97 130,697.47- 126,281.24 1,068.89 NON-DEPARTMENTA L Supplies2,500--405.3510.71 - City Support Services 665,931 31,220.27 282,111.46- 246,040.75236,514.00 Operations Support 139,000 13,253.21 103,425.46- 106,382.69 - 32,617.31 Staff Support 90.82 - - 90.82 - - City Assistance 459,046 - 326,077.60- 385,113.97 - 73,932.03 Professional Services 174,650 2,496.65 50,913.56- 68,007.93 5,000.00 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,451,977 47,060.95 762,933.43- 805,646.87241,514.00 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services268,919 21,439.44 107,058.20- 194,490.29 - 74,428.71 Supplies2,900 481.96 - 672.91 2,442.27 71.86 385.87 Operations Support34,585 1,145.01 - 15,493.79 13,100.64 - 21,484.36 Staff Support4,865 1,658.51 - 1,955.56 3,106.90 611.39 1,146.71 - - - 9,611.24- Professional Services - Operating Equipment300 -2,737.18 - - - TOTAL PUBLIC AFFAIRS 311,569 24,724.92 127,917.64- 213,140.10 10,294.49 RECORDS MANAGEMEN T Personnel Services 47,850 3,560.62 33,542.22- 34,649.49 - 13,200.51 Supplies 750 - - 308.73 209.47 50.00 Staff Support 1,500 242.40 - 815.14 1,026.75 - Professional Services 15,000 148.50 - 8,674.14 6,450.16 - Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,100 3,951.52 43,340.23- 42,335.87 50.00 SCHERTZ TALES MAGAZINE Personnel Services 129,161 9,986.56 90,396.63- 93,666.26 - 35,494.74 Supplies 200 - - - 45.00 - Opperations Support 200 - - - - - Staff Support 1,500 153.14 - 15.00 269.22 329.42 Professional Services302,70024,246.85172,194.98205,571.67 - - TOTAL SCHERTZ TALES MAGAZINE 433,761 34,386.55 262,606.61- 299,552.15 329.42 ENGINEERING Personnel Services 123,405 4,642.19 118,637.58- 52,056.30 - 71,348.70 Supplies 400 50.00 - 127.94 375.05 - Utility Services 600 71.12 - - 279.30 - Staff Support 2,013 - - 617.00 130.00 183.45 Professional Services 89,220 - 18,391.25- 59,727.50 6,307.50 Maintenance Services 4,044 - - 2,745.24 3,345.29 - Operating Equipment200 -- - - - Capital Outlay26,000 25,352.30- - - - TOTAL ENGINEERING 245,882 4,763.31 140,519.01- 141,265.74 6,490.95 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,079 9,210.62 84,117.28- 87,588.36 - 34,490.64 Supplies3,500 - - 1,141.65 979.67 - Staff Support 4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 131,629 9,210.62 85,258.93- 88,568.03 - 43,060.97 TOTAL GENERAL GOVERNMENT 5,689,522 363,274.58 3,405,479.09- 3,732,689.37286,523.59 PUBLIC SAFETY POLICE Personnel Services4,524,327 339,141.85 3,055,033.31- 3,179,293.15 - 1,345,033.85 Supplies32,539 1,402.65 - 15,019.41 23,050.25 2,602.53 6,886.22 City Support Services21,734 - - - 19,518.41 - Utility Services 123,456 11,175.18 69,404.65- 76,514.47 - 46,941.53 Operations Support 1,565 90.00 - 193.00 1,475.00 90.00 Staff Support 58,781 6,251.28 - 8,847.91 32,224.61 6,438.78 City Assistance 8,200 1,851.00 - 2,903.18 4,671.74 - Professional Services 16,425 - - 1,930.16 2,082.85 - 14,342.15 Maintenance Services 46,494 900.00 29,395.80- 34,348.23 - 12,145.77 Operating Equipment 74,327 2,976.98 48,665.87- 50,889.19 18,972.57 Capital Outlay155,077153,726.40155,076.05 - - - TOTAL POLICE 5,062,925363,788.94 3,385,119.69-3,579,143.9528,103.88 FIRE RESCUE Personnel Services 2,508,586 177,720.85 1,768,562.70- 1,823,755.04 - 684,830.96 Supplies 20,500 46.23 - 5,056.62 13,058.10 93.73 Utility Services 57,000 4,081.94 34,197.49- 33,568.39 - 23,431.61 Operations Support 800 - - 567.00 323.39 245.00 Staff Support 120,185 961.54 71,637.19- 99,412.08 7,629.80 City Assistance 18,600 152.65 10,777.25- 8,885.80 - Professional Services 18,140 - 13,040.00- 12,148.19 - Maintenance Services 56,000 2,104.56 25,369.63- 25,567.74 9,043.01 Operating Equipment58,3001,337.99 17,379.791,301.88 -30,800.68 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,893,111 186,405.76 1,960,008.56- 2,065,214.52 18,313.42 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services420,518 31,435.71 262,156.17- 301,034.53 - 119,483.47 Supplies2,100 3.64 - 1,093.82 1,469.64 98.25 532.11 City Support Services400 - - - - - Utility Services 6,500 627.80 - 3,697.90 3,824.22 - Operations Support 1,500 231.00 - 838.87 275.00 286.00 Staff Support 8,000 112.65 - 2,866.75 1,960.85 214.65 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 --47.61 - - TOTAL INSPECTIONS 450,018 32,410.80 270,653.51- 308,564.24 646.51 MARSHAL SERVICE Personnel Services 534,355 38,395.40 326,653.81- 371,331.14 - 163,023.86 Supplies 4,600 431.94 - 1,092.95 2,470.40 - Utility Services 12,000 1,541.24 - 6,474.04 9,499.84 - Operations Support 4,000 109.98 - 1,595.39 1,230.39 120.00 Staff Support 15,400 146.28 - 2,022.17 5,250.94 585.19 Maintenance Services 30,700 130.00 - 8,419.85 3,034.00 150.00 Operating Equipment16,000640.00 11,558.42543.62 -22,861.14 Capital Outlay34,000 31,022.0540,406.00 - - - TOTAL MARSHAL SERVICE 651,055 41,394.84 409,525.35- 435,397.18 1,398.81 TOTAL PUBLIC SAFETY 9,057,109 624,000.34 6,025,307.11- 6,388,319.89 48,462.62 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services680,357 50,336.43 417,219.47- 485,570.40 - 194,786.60 Supplies7,100 238.77 - 3,774.59 4,244.15 321.80 2,534.05 Utility Services113,900 13,636.83 - 79,732.22 84,148.03 483.01 29,268.96 Staff Support10,265 179.81 - 5,215.23 5,466.82 189.65 4,608.53 Maintenance Services270,800 9,272.63 - 123,837.26 117,861.15 6,281.19 146,657.66 Rental/Lease200 - - - - - Operating Equipment 4,200 - - 4,379.99 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,086,822 73,664.47 647,828.76- 700,776.54 7,275.65 TOTAL PUBLIC ENVIRONMENT1,086,82273,664.47 647,828.76-700,776.547,275.65 PARKS & RECREATION PARKS DEPARTMENT Personnel Services506,870 35,602.16 341,467.01- 347,015.80 - 159,854.20 Supplies40,555 714.43 - 24,576.75 22,790.41 2,377.73 15,386.86 Utility Services113,000 11,109.82 - 80,399.95 88,735.87 483.00 23,781.13 Operations Support700 - - 880.80 - - Staff Support 8,573 179.24 - 5,990.61 6,475.48 398.29 Professional Services 62,610 9,663.42 26,345.00- 45,916.49 3,571.50 Maintenance Services 22,000 - 14,047.05- 13,637.96 2,393.00 Rental/Leasing 42,200 3,225.40 30,276.83- 26,306.39 16,375.66 Operating Equipment - - 6,197.93 - - - Capital Outlay -190.56225.00 - - - TOTAL PARKS DEPARTMENT 796,508 60,494.47 530,372.49- 550,878.40 25,824.18 SWIM POOL Supplies17,700 4,997.70 11,089.69- 11,800.54 3,348.00 2,551.46 Utility Services25,500 2,834.94 - 11,502.12 13,448.65 - 12,051.35 Staff Support925 - - 166.09 750.00 - Maintenance Services 198,378 - 127,064.27- 12,904.63 - 185,473.37 Rental/Lease500 208.20378.00 - - - TOTAL SWIM POOL 7,832.64243,003 150,200.17-39,112.023,348.00 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services54,292 4,031.61 57,080.72- 40,471.75 - 13,820.25 Supplies28,300 8.00 - 6,362.31 9,532.42 1,106.18 17,661.40 Utility Services47,550 3,157.11 - 23,520.81 24,132.97 - 23,417.03 Operations Support15,158 2,970.00 - 6,799.26 10,166.78 8.00 4,983.22 Staff Support3,342 - - 594.47 1,081.48 10.00 2,250.52 Professional Services1,600 - - 975.00 150.00 - Operating Equipment5,000 4,999.70285.00 - - - TOTAL COMMUNITY/CIVIC CNTR155,24210,166.72 95,617.57- 90,535.10 1,124.18 63,582.72 TOTAL PARKS & RECREATION1,194,753 78,493.83 776,190.23- 680,525.52 30,296.36 483,931.12 CULTURAL LIBRARY Personnel Services 692,531 50,848.34 489,385.42- 503,439.44 - 189,091.56 Supplies14,000 1,037.79 - 7,534.44 7,951.24 16.20 6,032.56 Utility Services41,000 3,555.28 - 30,923.67 28,834.84 - 12,165.16 Operations Support2,000 - - 70.00 1,157.00 - Staff Support 4,215 24.66 - 1,381.40 1,538.18 - Professional Services 2,100 - - 2,065.00 2,140.00 - Maintenance Services 2,400 - - 1,200.00 1,600.00 - Operating Equipment75,0007,417.34 58,811.9961,434.573,832.44 - TOTAL LIBRARY 62,883.41833,246 - 593,994.50 605,472.69 3,848.64 223,924.67 TOTAL CULTURAL833,246 62,883.41 593,994.50- 605,472.69 3,848.64 223,924.67 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services296,439 21,405.98 221,567.29- 200,966.72 - 95,472.28 Supplies25,000 2,267.12 - 13,943.32 14,725.24 1,930.16 8,344.60 Utility Services11,200 1,064.28 - 7,187.60 7,717.05 - Operations Support 500 - - - - - Staff Support 12,560 163.69 - 1,952.00 5,642.64 2,491.00 City Assistance 10,000 857.27 - 7,376.48 6,127.35 790.73 Professional Services 13,500 1,027.50 - 8,182.00 7,239.00 97.50 Maintenance Services 6,200 160.15 - 2,546.23 4,185.15 220.50 Operating Equipment9,500149.00 1,693.988,211.842,945.16 - TOTAL ANIMAL SERVICES384,89927,094.99 270,966.76-248,297.138,475.05 TOTAL HEALTH 384,899 27,094.99 270,966.76- 248,297.13 8,475.05 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 260,032 22,163.88 189,041.02- 205,282.73 - 54,749.27 Supplies2,000 10.49 - 1,090.52 336.71 - City Support Services 360,854 - 178,378.80- 196,165.35137,419.07 Utility Services 164,949 23,310.01 98,407.94- 109,661.44 6,935.20 Staff Support 16,750 235.27 - 6,386.02 11,311.58 467.80 Professional Services 2,500 - - - - - Maintenance Services 12,500 2,055.00 15,082.52- 9,389.36 35,783.20 Operating Equipment 129,315 15,312.01 119,692.36- 60,396.36 30,174.70 Capital Outlay213,500 7,266.00- - - - TOTAL INFORMATION TECHNOLOGY1,162,400 63,086.66 608,079.18- 599,809.53210,779.97 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services296,750 14,250.16 152,948.25- 174,477.57 - 122,272.43 Supplies1,329 57.30 - 768.52 896.17 - Human Services 42,831 3,336.62 24,666.78- 28,511.23 - 14,319.77 Operations Support 13,346 960.00 - 8,252.09 4,902.25 - Staff Support 16,897 (55.00) - 6,492.18 8,084.82 704.01 City Assistance9,860 715.00 - 5,258.00 5,314.50 - Operating Equipment5,575 4,302.13- - - - TOTAL HUMAN RESOURCES 19,264.08386,588 198,385.82- 226,488.67 704.01 FINANCE Personnel Services429,810 35,437.50 301,083.59- 319,914.34 - 109,895.66 Supplies3,600 98.61 - 2,631.76 2,429.19 - Operations Support 850 - - 342.57 97.31 - Staff Support 15,805 258.54 - 8,988.28 6,333.52 - Rental/Leasing 2,230 - - - 502.32 - Operating Equipment1,000 266.471,077.80 - - - TOTAL FINANCE 453,295 35,794.65 314,124.00- 329,543.15 - 123,751.85 PURCHASING & ASSET MG T Personnel Services 241,940 18,167.96 169,423.56- 174,620.39 - 67,319.61 Supplies1,103 310.64 - 591.28 695.95 76.98 330.07 Utility Services650 - - 246.78 419.85 - Operations Support 909 - - 60.68 (54.88) 60.55 Staff Support 9,097 100.00 - 5,087.30 4,104.15 - Operating Equipment7,591 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 261,290 18,578.60 175,409.60- 187,376.28 137.53 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,880 14,074.90 113,148.74- 152,421.38 - 65,458.62 Supplies150,576 6,125.50 - 78,360.23 104,655.65 18,067.91 27,852.44 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 216.97 - 3,448.89 2,402.45 - Operations Support 25 - - 375.00 375.00- Staff Support 3,835 81.84 - 1,545.87 2,284.15 58.24 Maintenance Services 70,079 3,692.95 45,584.49- 30,394.75 4,944.79 Rental/Lease270 150.00269.80 - - - Operating Equipment5,000 4,931.793,973.90 - - - TOTAL FLEET SERVICE 456,365 24,192.16 248,087.12- 298,859.97 23,445.94 TOTAL INTERNAL SERVICE 2,719,938 160,916.15 1,544,085.72- 1,642,077.60235,067.45 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,00010,500.00 42,000.0031,500.00 - - TOTAL CITY ASSISTANCE52,00010,500.00 41,992.52-44,781.17 - COURT - RESTRICTED FUNDS Operating Equipment14,269.00 14,269.001,090.004,090.00 - - TOTAL CITY ASSISTANCE - 1,090.00 14,269.00 4,090.00 - 14,269.00 TOTAL MISC & PROJECTS52,00024,769-43,08359,0504,090 TOTAL EXPENDITURES21,018,2891,415,096.77 13,306,934.69-14,057,208.91624,039.36 REVENUE OVER(UNDER) EXPEND.116,1762,598,839.14 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 18,039.28 6,696,299.78- 6,857,807.85 - 26,646.15 000-411200Advalorem Tax - Delinquent 50,000 2,666.65 - 4,744.16 45,731.13 - 000-411300Advalorem Tax - P&I 50,000 3,287.40 37,739.95- 37,298.97 - 12,701.03 000-411500Sales Tax Revenue-Gen Fund4,784,071 459,387.42 2,626,612.08- 3,734,511.16 - 1,049,559.84 000-411600Bingo Tax 2,200 - - 1,750.27 - - 000-411700Mixed Beverage Ta33,000.0025,353.0120,979.16 x - - - TOTAL Taxes11,803,725 483,380.75 9,392,499.25- 10,696,328.27 1,107,396.73 Franchises 000-421200Center Point/Entex Energy 36,000 2,731.32 27,235.78- 41,579.70 - (5,579.70) 000-421220City Public Service 330,000 33,146.48 185,874.73- 252,235.06 - 77,764.94 000-421240Guadalupe Valley Elec Co-op 440,000 32,515.58 186,840.44- 281,450.09 - 158,549.91 000-421250New Braunfels Utilities 55,000 4,736.88 - 5,633.66 36,778.53 - 18,221.47 000-421300Time Warner-State Franchise 345,000 29,633.83 161,780.70- 246,355.56 - 98,644.44 000-421350Time Warner-PEG Fee 65,000 - 32,344.84- - - 65,000.00 000-421460AT&T Franchise Fee 185,000 14,306.99 76,453.51- 115,618.72 - 69,381.28 000-421465AT&T PEG Fees 26,000 - 12,036.28 - 000-421480Other Telecom Franchise 35,000 (21,783.86) 34,487.83- 56,411.14 - (21,411.14) 000-421500Solid Waste Franchise Fee100,00012,645.8578,289.0876,387.94 - - TOTAL Franchises1,617,000107,933.07 800,976.85-1,106,816.74 - 510,183.26 Permits 000-431100Home Occupation Permit 500 - - 280.00 245.00 - 000-431200Building Permit - 1,120,456.83- - - - 000-431205Building Permit - Residential 600,000 43,566.00 - 306,632.00- - 293,368.00 000-431210Building Permit - Commercial 300,000 6,107.00 - 183,137.00- - 116,863.00 000-431215Building Permit - General - 86,957.00- - 8,015.00 - (86,957.00) 000-431300Mobile Home Permit 200 25.00 - 80.00 200.00 - 000-431400Signs Permit 1,700 174.00 - 615.00 1,603.00 - 000-431500Food Establishmnt Permit 30,000 650.00 14,170.00- 13,950.00 - 16,050.00 000-431600Garage Sale Permit 8,600 1,440.00 - 8,450.00 8,105.00 - 000-431700Plumbing Permit 80,000 9,525.00 93,188.65- 87,078.75 - (7,078.75) 000-431750Electrical Permit 55,000 5,460.00 59,020.00- 34,710.00 - 20,290.00 000-431800Mechanical Permit 59,000 6,180.00 66,680.00- 39,700.00 - 19,300.00 000-431900Solicitor/Peddler Permit 170.00 - 1,170.00 1,200.00 - - 000-431950Animal/Pet Permit 2,000 - - 1,500.00 1,475.00 - 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,80050.00-4,800.006,200.00 - (2,400.00) 000-432100Security Alarm Permit 42,000 4,902.50 32,013.00- 37,817.50 - 000-435000Fire Permit5,000775.00 6,600.006,937.50 - - TOTAL Permits 87,039.501,187,800 - 1,409,360.98 815,610.25 - 372,189.75 Licenses 000-441000Alcohol Beverage License 6,300 537.50 - 4,510.00 3,987.50 - 000-441300Mobile Home License - - - 80.00 - - 000-442000Contractors License 39,000 4,130.00 43,895.00- 45,955.00 - (6,955.00) 000-444000Pet License3,000220.00 3,395.003,543.10 - - TOTAL Licenses 48,300 4,887.50 51,948.10- 53,417.50 - (5,117.50) Fees 000-451000Municipal Court Fines 1,665,009 232,823.63 795,092.73- 1,085,314.45 - 579,694.55 000-451100Arrest Fee 50,694 6,220.13 34,264.95- 43,266.75 - 000-451110Expunction Fee 90 - - 30.00 - - 000-451200Warrant Fees 192,000 10,999.70 101,089.67- 102,944.60 - 89,055.40 000-451210Court - Claims & Judgements - - - 1,842.60 - - (1,842.60) 000-451320Civil Justice Fee-Court 75 9.87 51.24 67.56 - 000-451321Civil Justice Fee-State 89.62 - 461.72 609.75 - - 000-451340Judicial Fee - City 6,826 805.85 - 4,592.35 5,709.85 - 000-451400Traffic Fine Costs TTL 25,984 3,222.70 17,276.12- 22,244.64 - 000-451500Teen Court Admin Fee 260 - - 260.00 420.00 - 000-451510Juvenile Case Mgmt Fee 55,896 6,725.42 38,288.52- 47,616.22 - 000-451600Technology Fund Fee 45,601 5,307.72 31,041.19- 38,245.91 - 000-451700Security Fee 34,220 3,980.78 23,289.89- 28,684.47 - 000-451800Time Payment Fee - City 7,336 260.57 - 4,544.04 3,884.81 - 000-451850State Fines 10% Service Fee 72,470 - 49,510.11- 48,016.77 - 24,453.23 000-451900DPS Payment - Local 11,858 900.93 - 8,225.96 8,210.93 - 000-452000Child Safety Fee 12,243 1,497.28 - 9,323.86 22,757.05 - (10,514.05) 000-452050Indigent Defense Fee 21,655 2,651.00 14,802.63- 18,511.36 - 000-452100Platting Fees 98,000 2,000.00 51,000.00- 48,500.00 - 49,500.00 000-452200Site Plan Fee 74,000 1,500.00 21,500.00- 19,500.00 - 54,500.00 000-452300Plan Check Fee 465,000 27,852.00 568,646.41- 242,292.00 - 222,708.00 000-452310Miscellaneous Review Fee 13,500 - - 2,700.00 5,700.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,560.00 - 5,210.00 5,100.00 - 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452520Fire Training Classes400---- - 000-452600Specific Use/Zone Chng Fee 20,000 - 11,650.00- 24,500.00 - (4,500.00) 000-452710Zoning Ltr & Dev Rights 1,500 - - 375.00 1,800.00 - 000-453100Reinspection Fees 30,000 2,075.00 32,255.00- 29,550.00 - 000-453110Swim Pool Inspection Fee 300.00 - 1,050.00 1,350.00 - - (1,350.00) 000-453200Lot Abatement 12,000 60.00 11,366.43- 1,766.58 - 10,233.42 000-453211Admin Fee-Inspections 7,480 200.00 - 6,500.00 5,540.00 - 000-453310Misc Inspection Fee - - 40.00 69.49 - - 000-453710Foster Care 500 100.00 - 650.00 600.00 - 000-454100Swim Pool Reservation Fee - - 55.00 - - 000-454200Pool Gate Admission Fee 25,000 9,405.81 10,045.00- 9,405.81 - 15,594.19 000-454300Seasonal Pool Pass Fee 5,500 4,519.50 - 6,501.00 4,519.50 - 000-456500Haz Mat Fees 800 - - - 6,984.73 - (6,184.73) 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 100.00 - 700.00 600.00 - 000-458100Sale of Merchandise - - 17.00 36.50 - - 000-458300Sale of Property/Auction 22,000 329.90 26,410.94- 20,114.38 - 000-458400Civic Center Rental Fees 171,000 10,768.75 94,955.00- 84,422.25 - 86,577.75 000-458401Capital Recovery Fee-Civic Cntr 7,500 575.00 - 1,200.00 4,075.00 - 000-458450North Center Rental Fees 15,000 2,395.00 - 7,366.00 17,637.92 - (2,637.92) 000-458500Community Center Rental Fees 18,000 3,184.53 13,240.32- 22,596.72 - (4,596.72) 000-458550Pavilion Rental Fees 18,500 2,000.00 14,062.70- 14,337.00 (75.00) 000-458560Chamber of Comm rent 11,700 - - 5,850.00 5,850.00 - 000-458570Non-Resident SYSA League 12,000 1,930.00 - 7,060.00 17,865.00 - (5,865.00) 000-458600Ball Field Use - - 1.76 - - - 000-458650NonResident User Fee-BVYA 11,000 760.00 -9,090.008,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 - - - - - 000-459200NSF Check Fee 250 184.00 - 328.00 184.00 - 000-459300Notary Fee 300 36.00 - 315.00 264.00 - 000-459400Maps, Copies, UDC, & Misc F 400 - - 608.18 68.10 - 000-459600Animal Adoption Fee 15,000 485.00 - 8,611.50 8,622.50 - 000-459700Pet Impoundment Fee 15,000 1,160.00 15,401.01- 11,059.25 - 000-459800Police Reports Fee6,500486.00 4,636.504,314.20 - - TOTAL Fees 350,461.693,324,727 - 2,082,645.43 2,138,880.17 (75.00) 1,185,921.83 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,789.2819,558.3120,703.95 - - TOTAL Fines30,0002,789.28 19,558.31-20,703.95 - Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 - 15,808.32- 14,051.84 - 000-473200City of Seguin - Fire Contract 40,263 3,355.26 30,197.34- 30,197.34 - 10,065.66 000-473300Guad Co - Library 180,000 15,901.33 120,544.00- 127,210.64 - 52,789.36 000-473400Randolph AFB-Animal Cntrl 1,000 - - 1,700.00 600.00 - 000-474200Library Services - Cibolo 20,000 - - 17.50 - - 20,000.00 000-474210Library Services-Selma 19,000 - - - - - 19,000.00 000-474400Dispatch Service - Cibolo 133,305 - 99,978.75- 99,978.75 - 33,326.25 000-474600School Crossing Guard-Bexar6,6003,200.24 5,151.5826,603.03 - -(20,003.03) 000-474610School Cross Guard-Guadalupe23,191.02 -3,328.83 -14,230.91 -(23,191.02) 000-474700School Officer Funding150,000 87,500.00- - - - TOTAL Inter-Jurisdictional571,24525,785.66 287,628.40-409,332.62 - 161,912.38 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 65,880.00- 65,880.00 - 21,960.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 127,665.74- 106,969.50 - 35,656.50 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 29,018.50- 31,376.25 - 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 468,582.75- 660,916.53 - 220,305.47 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 - (6,293.53) 000-486402Transfer from City Wide Projects - 25,372.05- - - - 000-487000Interfund Charges-Fleet 98,484 8,207.00 66,978.74- 73,863.00 - 24,621.00 000-488000Interfund Charges-4B 53,000 4,416.67 41,168.65- 39,750.03 - 13,249.97 000-489000Transfer In- 11,671.25-- - - 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 115,044.12 886,337.68- 991,868.10 - 768,789.90 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 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 28.33 - 1,584.98 235.36 - 000-491200Investment Income 30,000 4,118.56 26,918.86- 36,866.69 - (6,866.69) 000-491800Gain/Loss - (6,057.33)- - (6,501.00) - 000-491900Unrealized Gain/Loss (15,387.25)- (17,208.20) - 3,748.60 - 17,208.20 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. 75.00 24,815.00- 5,106.34 - - (5,106.34) 000-493400Donation - Animal Control 1,200 476.00 - 3,356.30 3,419.60 - (2,219.60) 000-493401Donations-A/C Microchip 500 80.00 - 1,770.00 1,455.00 - 000-493402Donations-Spay&Neuter 13,500 449.50 12,019.08- 9,394.50 - 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 - - - 1,550.00 - - (1,550.00) 000-497000Misc Income-Gen Fund 81,000 13,536.81 14,470.92- 31,076.51 (9.90) 000-497005Misc Income-Publications 290,000 24,921.00 110,749.10- 158,676.00 - 131,324.00 000-497007Misc Income-Schertz Artz - - - 20.00 (18.00) - 000-497100Misc Income-Police 25,000 1,068.50 20,977.13- 16,347.40 - 000-497200Misc Income-Library 19,000 241.85 17,489.45- 2,823.44 - 16,176.56 000-497210Misc Income-Library Copier 13,500 1,034.50 8,306.65 10,252.81 - 000-497300Misc Income-Animal Control 500 - - 1,506.37 105.00 - 000-497400Misc Income-Streets Dept. 20,000 1,950.00 15,845.20- 12,517.48 - 000-497500Misc Income-TML Insurance 78,000 - 49,728.90- 623.36 - 77,376.64 000-497550Misc Income-TML Reimbursemt20,000 1,339.41 24,723.98-16,712.47 - 000-497600Misc Income-Parks/Vending Mach.2,500 133.66 - 1,362.72 1,248.02 - 000-498000Reimbursmnt-Gen Fund5,0007,185.09 4,624.1231,093.92 - -(26,093.92) 000-498100Reimbursmnt Fire - Training 800 - - 846.00 - - 000-498105Reimburmnt Police - DEA - 4,925.36 4,803.25 - 1,546.81 - (4,803.25) 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 - - 9,328.07 38,143.21 - (26,143.21) 000-498500Settlement - Litigation25,000.00- - - - - TOTAL Miscellaneous791,010 55,432.62 - 368,876.16 423,090.45 (27.90) 367,947.45 TOTAL REVENUES21,134,465 1,232,754.19 - 15,299,831.16 16,656,048.05 (102.90) 4,478,519.85 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking413,746.18$ Cash in Investments LOGIC Investment-General Fund 2,811,540.26 LOGIC Investment-Equip Replacement 73,431.50 LOGIC Investment-Veh Replacement 7,087.67 LOGIC Investment-Air Condi Replacment 146,612.12 CAPITAL ONE Investment-General Fund1,338,257.78 Total Cash in Bank & Investments$4,937,257.35 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 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% -3% 17% 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 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: JUNE 30th, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 62,100.00 - - - - - 62,100.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,585.00- 16,242.00 - - 7,758.00 Miscellaneous175.00114.30- 1,387.84453.54 - TOTAL REVENUES114,275.00 114.30 - 54,500.45 44,275.59 - 69,999.41 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 140.57 - 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 30,461.91- 3,880.00 - - 27,620.00 TML Events - - 194.69 - - - (194.69) Schertz Sweetheart 37,000.00 1,315.09 38,425.12- 20,447.08 16,215.11337.81 Hal Baldwin Scholarship11,000.003,767.40-10,354.114,767.40 -6,232.60 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 5,223.06103,600.00 - 92,412.75 52,898.57 378.71 50,322.72 TOTAL EXPENDITURES108,750.00 5,223.06 - 92,412.75 52,898.57 378.71 55,472.72 REVENUE OVER(UNDER) EXPEND5,525.00(8,622.98) SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking18,161.87$ Cash in Investments MBIA Special Events66,662.58 Total Cash in Bank & Investments$84,824.45 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 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises - 38,697.96- - - - (38,697.96) Miscellaneous- 12.49- - - - TOTAL REVENUES - - - 38,710.45 - (38,710.45) - EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental- -- - - - TOTAL GENERAL GOVERNMENT - - - - - - - TOTAL EXPENDITURES - - - - - - - REVENUE OVER(UNDER) EXPEND38,710.45 - 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 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Franchises 000-421350Time Warner - PEG Fee - 31,490.82- - - -(31,490.82) 000-421465T&T PEG Fee 7,207.14- A - - - - TOTAL Fund Transfers - 38,697.96- - - -(38,697.96) Miscellaneous 000-491000Interest Earned--12.49 - - -(12.49) 000-491200Investment Income -- - - - - TOTAL Miscellaneous - - 12.49 - - -(12.49) TOTAL REVENUES- 38,710.45- - - -(38,710.45) PEG FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Cash Balance332,877.62$ Total Cash in Bank & Investments$332,877.62 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 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,000- 164,765.87-150,502.07 29,497.93- Fees14,164,2501,444,644.80 10,592,956.90-11,137,003.52 3,027,246.48- Fund Transfers634,6747,056.17 60,462.00-63,505.53 571,168.47- Miscellaneous1,176.55280,310.35389,621.22 103,260 - - TOTAL REVENUES15,082,1841,452,877.5211,098,495.1211,740,632.34 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers31,000.00- 27,366 - - - TOTAL NON DEPARTMENTAL31,000- 27,366 - - -27,366.00 BUSINESS OFFICE Personnel Services383,89425,763.80 303,619.82-254,138.38 129,755.62- Supplies5,400782.77-2,678.993,150.21537.53 Human Services100---40.00- Operations Support106,0002,561.47 63,552.71-73,754.0230.20 Staff Support6,70543.30-2,023.413,300.55100.00 Professional Services24,3952,285.91 12,963.75-15,975.56- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300840.00-4,527.955,280.00580.00 Operating Equipmen6,117.625,932.94 t 6,200 - - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE32,277.25361,571.661,247.73 603,994 -395,484.25 W & S ADMINISTRATION Personnel Services1,184,89866,211.00 881,878.89-752,917.83 431,980.17- Supplies200,5203,850.67 150,441.58-104,174.718,194.13 Human Services1,00024.00-64.00126.00- City Support Services73,999- 38,874.05-34,379.59 39,619.41- Utility Services2,571,844353,614.79 1,688,070.45-2,361,896.80483.00 Operations Support8,750278.07-3,071.295,978.01- Staff Support33,000219.92 16,322.94-13,403.59731.64 City Assistance1,91237.00-296.00334.00- Professional Services213,00013,905.48 171,036.42-108,465.661,871.70 Fund Charges/Transfers2,657,007183,675.97 1,563,426.60-1,972,046.6262,500.00 Maintenance Services5,560,650632,557.77 3,667,134.38-4,021,391.2325,631.44 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: JUNE 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353- 618,275.60-96,868.35 1,133,484.65- Rental-Leasing6,070--2,508.532,888.7572.96 Operating Equipment8,180- 22,682.70-3,463.80574.41 Capital Outla113,606.66 y 114,000 - -132,061.40 - -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,900,1831,254,374.679,622,898.04100,059.28 -8,985,056.68 MISC & PROJECTS PROJECTS City Support Services29,000---- 29,000.00- Operations Support1,000----- Professional Services45,290---- 45,290.00- Maintenance Services -- 312,750 - - - TOTAL PROJECTS-- 388,040 - - -388,040.00 AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services------ Operations Support---248.04-- Professional Services25,210- 55,450.25-- 25,210.00- Maintenance Services238,889.68- 136,750 - - - - TOTAL AVIATION HEIGHTS WTR IMP 161,960 - -294,587.97 -161,960.00 FM3009 RD&BRIDGE EXPANSION Professional Services-- 42,406.81-5,370.50217.50 37.74 71,088.87 Maintenance Services - - - - 76,459.37 217.50 (76,676.87) TOTAL FM3009 RD&BRIDGE EXPANSION - - -42,444.55 TOTAL MISC & PROJECTS76,459.37217.50 550,000 - -337,032.52 TOTAL EXPENDITURES15,081,5431,286,6529,748,57310,060,929101,525 - ** REVENUE OVER(UNDER)EXPENSES **1,679,703.27 641 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 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% 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 307,757.72 2,439,703.97- 2,621,193.14 - 778,806.86 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 23,112.55 165,593.20- 190,294.61 - 50,705.39 000-455800W&S Line Constructn Reimbursemnt50,000 2,062.00 21,534.92- 18,695.70 - 31,304.30 000-457100Sale of Water 7,210,000 800,146.58 5,451,172.92- 5,579,248.08 - 1,630,751.92 000-457110Edwards Water Lease 166,250 8,117.50 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,910.00 60,365.84- 40,483.40 - 49,516.60 000-457400Sewer Charges 2,800,000 282,128.83 2,114,158.67- 2,327,364.04 - 472,635.96 000-457500Water Penalties 180,000 15,269.62 124,560.60- 129,819.52 - 50,180.48 000-459200NSF Check Fee-Water&Sewer2,000140.001,772.022,090.00 - - TOTAL Fees14,164,2501,444,644.80 10,592,956.90-11,137,003.52 3,027,246.48 Fund Transfers 000-481000Transfer In- Reserve550,000---- - 550,000.00 7,056.1760,462.00 63,505.53 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 634,674 7,056.17 60,462.00- 63,505.53 - 571,168.47 Miscellaneous 000-490000Misc Charges 10,000 - - 6,432.28 408.05 - 000-491000Interest Earned 1,000 157.28 - 1,194.02 1,437.44 - 000-491200Investment Income 6,000 604.63 13,185.34 8,579.02 - (2,579.02) 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 414.64 - 4,199.32 31,573.10 - - (31,573.10) 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 1,176.55 280,310.35- 389,621.22 - (286,361.22) TOTAL REVENUES15,082,1841,452,877.52 11,098,495.12- 11,740,632.34 3,341,551.66 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking581,206.85$ Cash in Investments Lone Star Investment-Water&Sewer 1,360,050.77 Lone Star Investment-W&S Customer Deposits294,172.17 Lone Star Investment-W&S Equip Replacement373,712.74 Lone Star Investment-W&S Veh Replacement 544,917.85 Lone Star Investment-Water/SSLGC SAWS 404,152.14 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $4,032,914.29 Total Cash in Bank & Investments4,614,121.14$ 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 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 272,963.25 2,480,848.74- 2,498,574.86 1,590,658.14(300.00) Inter-Jurisdictional1,438,836 23,843.88 1,037,803.39- 1,082,500.48 356,335.52- Miscellaneous18,825.53-85,750.4493,214.41 256,000 - TOTAL REVENUES 315,632.66 - 3,604,402.57 3,674,289.75 (300.00) 2,109,779.25 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,586,891195,514.26 1,956,410.49-1,930,440.30 656,439.7011.00 Supplies 25,088.91 227,798.46- 233,209.73 56,056.35 324,039 Human Services - 614.00 - 800 - - City Support Services 10,974.19- 10,277.40 31,505 - - 21,227.60 Utility Services 12,655.35 75,765.92- 81,129.35 31,355.6515.00 112,500 Operations Support 3,497.01 36,877.26- 40,036.94 2,895.00 52,600 Staff Support 2,576.85 48,169.63- 46,824.30 18,394.61 72,400 City Assistance 1,344.54 10,151.80- 8,477.28 96.00 9,000 Professional Services 8,333.25 96,585.87- 96,956.12 4,156.24 157,200 Fund Charges/Transfers2,084,785 351,135.56 586,991.58- 742,979.20 - 1,341,805.80 Maintenance Services 21,779.91- 36,465.52 112.35 37,700 - Debt Service 69,799.33- 5,863.00 111,176 - - 105,313.00 Rental-Leasing - 2,748.61 - 20,000 - - Operating Equipment 79.98 23,909.18- 41,402.78109,994.64 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 600,225.71 - 3,168,576.23 3,274,061.92 191,731.19 2,247,802.89 5,713,596 TOTAL EXPENDITURE600,225.71-3,168,576.233,274,061.92191,731.19 S 5,713,596 ** REVENUE OVER(UNDER) EXPENSES 400,227.83 * 70,173 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 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 272,963.25 - 2,404,848.74 2,431,937.86 - 1,386,795.14 63.68% 000-456110Subscription Program Fees55,000 18,640.00- 17,925.00 - - 37,075.00 000-456120EMT Class - Fees 95,200 57,360.00- 45,486.00 (300.00) - 000-459200Paramedic Class Fees 120,000 - - - - 000-456130Immunization Fees - 3,226.00- - - - (3,226.00) 000-459200NSF Check Fee -- - - - - - TOTAL Fees4,088,933272,963.25 2,480,848.74- 2,498,574.86 1,590,658.14(300.00) Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.88 - 215,694.76 214,594.92 - 71,531.08 000-474300Cibolo Support 222,018 159,975.00- 166,574.94 - - 55,443.06 000-475100Comal Co ESD #6 82,875 37,920.00- 55,270.62 - - 27,604.38 000-475200Live Oak Support 148,125 111,093.75- 120,247.14 - - 27,877.86 000-475300Universal City Support 226,168 153,309.39- 170,538.49 - - 55,629.51 000-475400Selma Support 67,618 51,547.50- 50,732.55 - - 16,885.45 000-475500Schertz Support 384,046 290,594.61- 288,140.73 - - 95,905.27 000-475600Santa Clara Support 8,849 - 7,901.01 6,639.18 - - 2,209.82 000-475800Marion Support13,0119,767.379,761.91 - - - TOTAL Inter-Jurisdictional1,438,836 23,843.88 1,037,803.39- 1,082,500.48 356,335.52- Miscellaneous 000-491000Interest Earned--- 0.00% - - - 000-491200Investment Income 64.72 - 450.51 487.80 - - 000-493203Donations-EMS 6,000 200.00 - 1,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 18,425.81 67,442.52- 72,485.71 - 77,514.29 000-497100Recovery of Bad Debt100,000135.0010,977.413,795.90 - - TOTAL Miscellaneous256,00018,825.53 85,750.44-93,214.41 - 162,785.59 TOTAL REVENUES5,783,769315,632.66 3,604,402.57- 3,674,289.75 2,109,779.25(300.00) SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank $ (430,106.67) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,235.53 $(128,871.14) 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: JUNE 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60066,669.99 536,305.77- 564,928.13 -144,671.87 Fund Transfers - - - - - - - 0.00% Miscellaneous900870.87688.76 89.16 - - TOTAL REVENUES 66,759.15710,500537,176.64 -565,616.89144,883.11 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 374,40423,070.40 262,297.77- 237,333.60 -137,070.40 Supplies 8,300 33.02 - 1,353.40 1,844.02 214.02 Human Services 325 - - - - -325.00 City Support Services 22,103 - 5,832.18 1,508.72 - -20,594.28 Utility Services 24,188 2,171.17 10,568.81- 14,807.22 483.00 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 281.82 - 3,450.27 3,004.78 829.55 City Assistance 840 - 15.00 72.00 - -768.00 Professional Services 20,698 15,121.64- 14,959.25 - -5,738.75 Fund Charges/Transfers 199,87611,785.92 97,839.25- 106,073.28 -93,802.72 Maintenance Services 22,000 42.12 - 1,987.00 42.12 -21,957.88 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 17,564 - 1,918.78 1,632.07 - - Rental/Leasing562-561.29 99.87% 561.29 - - Operating Equipment-- - - - - - TOTAL DRAINAGE 37,945.74701,725400,484.10 1,526.57381,938.35318,260.08 - TOTAL EXPENDITURE 37,945.74701,725400,484.10 1,526.57381,938.35318,260.08 S - ** REVENUE OVER(UNDER) EXPEND8,775183,678.54 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 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 3,167.48 3,890.22 4,000 437.96 -109.78 000-457600Drainage Fee 66,232.03-533,138.29561,037.91 -144,562.09 705,600 TOTAL Fees66,669.99 536,305.77-564,928.13 144,671.87- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 220.85 64.98 100 5.80 - 000-491200Investment Interest - 497.62 577.58 600 78.74 - 000-497000Misc Income-Drainage-152.4046.20 200 4.62 - TOTAL Miscellaneous - 870.87 688.76 900 89.16 -211.24 TOTAL REVENUES66,759.15 537,176.64- 565,616.89 144,883.11- 710,500 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 145,522.44 Cash in Investments Lone Star Investment-Drainage Maint Fund383,658.22 Total Cash in Bank & Investments$529,180.66 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 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 12,820.61 187,423.05- 254,579.03 -136,174.97 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50057.80-900.38236.80 - TOTAL REVENUES 12,878.41411,386-188,323.43254,815.83 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - 2,315.40 1,826.50 - -673.50 City Support Services 85,948 47,298.85- 48,721.00 - -37,227.00 Operations Support 74,000 1,886.00 - 9,389.93 19,035.31 1,354.00 Professional Services 2,500 - 2,500.00 2,500.00 - - -100.00% Fund Charges/Transfers 193,876 11,885.50 127,665.74- 106,969.50 -86,906.50 Operating Equipment 52,562 5,014.79 - 22,740.23- 11,849.99 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 18,786.29411,386-189,169.92201,792.54 L 13,203.99 TOTAL EXPENDITURE 18,786.29411,386-189,169.92201,792.54 S 13,203.99 53,023.29 REVENUE OVER(UNDER) EXPENDITURE - 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 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 12,820.61187,423.05254,579.03 -136,174.97 - TOTAL Taxes 390,754 12,820.61 187,423.05- 254,579.03 - 136,174.97 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned3003.56-200.6585.18 - 214.82 000-491200Investment Interest 200 54.24 - 99.73 151.62 75.81% - 000-497000Misc Income600.00- - - - - - TOTAL Miscellaneous50057.80-900.38236.80 - 263.20 TOTAL REVENUES 411,386 12,878.41 188,323.43- 254,815.83 - 156,570.17 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking76,263.45$ Cash in Investments MBIA - Hotel Tax200,044.37 Federated Investment-Hotel/Motel78,233.29 Total Cash in Bank & Investments$354,541.11 ôíè÷ð íùùçìûîùã èûä $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 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: JUNE 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 107,000.00- 118,025.00 - -131,975.00 Tree Mitigation Fees 75,000 43,520.00- 62,844.75 - -12,155.25 Miscellaneous- 500.22505.57 600 51.68 - TOTAL REVENUES-151,025.57181,369.97 325,600 51.68 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - 5,819.26 - -7,180.74 Maintenance Services-Landscape 3,500 12,234.00- 135.88 - -3,364.12 Operating Equipment 32,000 56,748.78- 25,373.72 2,781.20 4,636.52 Capital Outlay -- 68,873.45 169,000 - - TOTAL PARKLAND DEDICATION-68,982.78100,202.31 217,500 4,636.52 2,781.20 TREE MITIGATION Maintenance Services-Trees28,500 28,629.55- 3,623.00 300.00 - Capital Outlay-- 19,900.00 18,000 - - TOTAL TREE MITIGATION-28,629.5523,523.00 46,500 - 300.00 TOTAL EXPENDITURE-97,612.33123,725.31 S 264,000 4,636.52 3,081.20 REVENUE OVER(UNDER) EXPEND57,644.66 61,600 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 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 107,000.00- 118,025.00 131,975.00 - 000-458900Tree Mitigation75,00043,520.0062,844.75 - - TOTAL Fees 325,000 150,520.00- 180,869.75 144,130.25 - Miscellaneous 000-491000Interest Earned 100 5.52 - 200.86 26.33 73.67 000-491200Investment Interest 500 46.16 - 304.71 473.89 26.11 000-497000Miscellaneous Income -- - - - TOTAL Miscellaneous60051.68-505.57500.22 99.78 TOTAL REVENUES 325,600 51.68 151,025.57- 181,369.97 144,230.03 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$129,994.77 Cash in Investments Federated Investment-Park Fund 192,986.09 Federated Investment-Tree Mitigation126,412.95 Total in Investment Pool 319,399.04 Total Cash in Bank & Investments$449,393.81 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 161,585.76 2,049,625.97- 1,132,785.52 -1,592,614.48 Fund Transfers10,673,600 - - - - -10,673,600.00 Miscellaneous314,0001,525.43261,963.06232,264.13 - - TOTAL REVENUES13,713,000 163,111.192,311,589.031,365,049.65 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 354.94 1,120,818.41- 5,544.96 -16,455.04 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,000354.941,129,246.41114,324.46 L - - MISC & PROJECTS Projects13,025,000-10,488.42 -90,529.38 -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 -639,295.0213,563.42 - - TOTAL EXPENDITURE13,662,643 354.941,768,541.43127,887.88 S - - REVENUE OVER(UNDER) EXPENDITURES50,3571,237,162 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 92,421.00 1,105,343.74- 720,964.00 -758,636.00 000-455910Capital Recovery - Waste Wtr613,800 60,164.76 719,883.94- 374,021.52 -239,778.48 - - - 000-455911Capital Recovery-Wste Wtr Zone 1 - - - 9,000.00224,398.2937,800.00 000-455913Cap Recovery-North Sewer Tr 632,000 - - TOTAL Fees 2,725,400161,585.76 2,049,625.97- 1,132,785.52 -1,592,614.48 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 Earned50015.30-392.88239.76 - 000-491200Investment Income 30,000 4,967.53 28,957.21- 39,661.26 -(9,661.26) 000-491800Gain/Loss - - (7,055.28) - (6,501.00) -7,055.28 000-491900Unrealized Gain/Loss-Cap One (17,512.01)- (20,581.61) - 3,043.60 -20,581.61 000-497000Misc Income - - - - - - 000-498000Reimbursmnt - - 220,000.00- - -(220,000.00) 000-498100Reimbursmnt - FM 78 Project 37,499.98- - - - - 212,625.00- 000-498200Re-imbursement-Water Meters 283,500 - - - TOTAL Miscellaneous 314,000 1,525.43 261,963.06- 232,264.13 -81,735.87 TOTAL REVENUES13,713,000 163,111.19 2,311,589.03- 1,365,049.65 -12,347,950.35 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking450,510.85$ Cash in Investments Lone Star Investment-Capital Recovery Water1,754,363.57 Lone Star Investment-Capital Recovery Sewer480,956.18 Capital One-Investment1,714,547.79 Total Cash in Bank & Investments4,400,378.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 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75.00% FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 14,405.934,281,098 - 3,394,397.63 4,277,668.29 -3,429.71 - - - - Fund Transfers - - Miscellaneous2,2501,888.7615,396.869,854.46 - - TOTAL REVENUES 16,294.694,283,3483,409,794.494,287,522.75 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL 400.00 - 750.00 36,960.39 Professional Services - -(36,960.39) Debt Service -4,276,6672,558,340.593,074,924.52 - - TOTAL GENERAL GOVERNMEN 400.004,276,6672,559,090.593,111,884.91 T - - TOTAL EXPENDITURE 400.004,276,6672,559,090.593,111,884.91 S - - ** REVENUE OVER(UNDER) EXPEND6,6821,175,637.84 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 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET75.00% REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 14,405.933,394,397.634,277,668.29 - - TOTAL Taxes4,281,09814,405.93 3,394,397.63-4,277,668.29 - 3,429.71 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 0.49 14,415.30- 28.79 - 000-491200Investment Earnings1,5001,888.27 981.5617,941.74 - -(16,441.74) 000-497000Misc Income- (8,116.07) - - - - TOTAL Miscellaneous2,2501,888.76 15,396.86-9,854.46 - (7,604.46) TOTAL REVENUES4,283,348 16,294.69 3,409,794.49- 4,287,522.75 - (4,174.75) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75.00% NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent400.00 750.001,150.00 - - -(1,150.00) 35,810.39- 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services400-75036,960 - -(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 - 37,977.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 - 32,120.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 - 136,058.76- 13,796.88 -237,212.12 101-555626LS&D SR2006-Principal 100,000 - - 100,000.00- - 101-555626.1LS&D SR2006-Interest 648,982 - 325,490.64- 325,490.64 -323,491.36 101-555628CO Bond 2007-Principal 102,900 - - 142.58 - -102,900.00 101-555628.1CO Bond 2007-Interest 22,625 - 13,308.53- 10,864.43 -11,760.57 101-555629GO Bond 2007-Principal 225,000 - 275,000.00- 225,000.00 - 101-555629.1GO Bond 2007-Interest 198,922 - 107,346.25- 101,750.00 -97,172.00 101-555630GO Bond SR2008 Principal 370,000 - 355,000.00- 370,000.00 - 101-555630.1GO Bond SR2008 Interest 364,679 - 193,490.50- 186,159.75 -178,519.25 101-555631GO Bond SR2009 Principal 200,000 - 140,000.00- 200,000.00 - 101-555631.1BO Bond SR2009 Interest140,656.25 278,813 - -142,406.25 -138,156.25 101-555633GO SR2011 Principal 90,000.00- 532,287 - - -442,287.00 101-555633.1GO SR2011 Interest 346,167.71- 90,000 - - -(256,167.71) 101-555634GO SR2011A Refund Principal 140,000.00- - - - -(140,000.00) 20,081.36- 101-555634.1GO SR2011A Refund Interest - - - - TOTAL Debt Service4,276,667- 2,558,340.59-3,074,924.52 -1,201,741.98 TOTAL EXPENDITURES4,276,667 400.00 2,559,090.59- 3,111,884.91 -1,164,781.59 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking4,072.40$ Cash in Investments MBIA Investment- Tax I&S 1,264,090.91 Federated Investment-Tax I&S56.88 Total Cash in Bank & Investments$1,268,220.19 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 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET75% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042230,404.70 1,313,306.03- 1,869,151.53 - 522,890.47 Fund Transfers - - - - - - Miscellaneous17,2004,963.6315,163.0321,180.21 - - ,,,.,,.,,. TOTALREVENUES240924223536833132846906189033174 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 24,000 2,131.01 16,289.22- 22,731.89 1,281.34 Utility Service 87,500 7,107.48 38,336.27- 50,657.47 - 36,842.53 Maintenance Services 69,300 1,202.51 48,470.02- 43,003.61 738.40 Operating Equipment - 6,999.31 - - - - Capital Outlay -- - - - - TOTAL NONDEPARTMENTA180,80010,441.00110,094.82116,392.972,019.74 L - ECONOMIC DEVELOPMEN T Personnel Services 241,233 20,841.12 124,644.82- 169,447.83 - 71,785.17 Supplies 1,100 139.06 - 560.22 594.17 - Human Services 200 - - - - - City Support Services 42,772 985.31 13,774.07- 8,703.21 (185.00) Utility Services 7,200 67.77 - 2,293.10 1,060.12 - 6,139.88 Operations Support 63,600 3,357.97 49,349.72- 21,343.05 878.82 Staff Support 112,800 2,217.50 67,762.33- 74,412.42 5,366.73 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 29,777.29 172,970.63- 126,779.69 19,217.71 Fund Charges/Transfers 105,985 4,665.42 91,168.65- 41,988.78 - 63,996.22 Fund Replenish-Fund Balance - - - - - - Maintenance Services - - - - - - Debt Service 795,154 606,911.25- 613,014.50 - - Operating Equipment2,350(50.94)1,112.82161.94 - - TOTAL ECONO DEVELOPMEN 62,000.501,975,8941,130,547.611,067,505.71 T - 25,278.26 TOTAL EXPENDITURE 72,441.502,156,6941,240,642.431,183,898.68 S - 27,298.00 ** REVENUE OVER(UNDER) EXPEND252,548706,433.06 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 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET75% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042230,404.701,313,306.031,869,151.53 - - TOTAL Taxes2,392,042230,404.70 1,313,306.03- 1,869,151.53 -522,890.47 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 10.90 - 155.96 126.89 - 000-491200Investment Earnings 15,000 2,037.39 - 9,731.97 6,651.06 -8,348.94 000-497000Misc Income 2,915.342,000 - 5,275.10 14,402.26 -(12,402.26) 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 4,963.63 15,163.03- 21,180.21 - TOTAL REVENUES2,409,242235,368.33 1,328,469.06-1,890,331.74 -518,910.26 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking108,562.71$ Cash in Investments MBIA Investment-Economic Development Corp2,525,553.21 Schertz Bank & Trust-Certificate of Deposit- Schertz Bank & Trust-Certificate of Deposit1,037,007.40 Total Cash in Bank & Investments3,671,123.32$ 4B SALES TAX $300,000 26% 40% $250,000 -2% 17% 25% -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 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 JUNE 30th, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust3,233,208.79,696,676.16.0500,804,191.24,267,658.61,233,208.79,233,208.79 203333 TOTAL OPERATIONS3,233,208.79,696,676.16,804,191.24,267,658.61,233,208.79,233,208.79 23333 LOGIC General Fund2,811,540.26,310,869.52.251470.7400,000.00,811,540.26 N/A,811,540.26 306522 G/F-Equipment Replacement73,431.5073,416.330.2514 -15.1773,431.50 N/A73,431.50 G/F-Vehicle Replacement7,087.67,086.21.2514 -.46,087.67 N/A,087.67 70177 G/F-Air Conditioner Replacement146,612.12146,581.840.2514 -30.28146,612.12 N/A146,612.12 ,696,840.51.251450.58-,697,191.09,697,191.09 SR2009 Bond-Street Projects(II)1,697,191.09 10311 TOTAL LOGIC4,735,862.64,234,794.41,068.2300,000.00,735,862.64,735,862.64 51544 LONESTA R Capital Recovery - Sewer480,956.18480,857.480.2500 -98.70480,956.18 N/A480,956.18 Capital Recovery - Water1,754,363.57,754,003.53.2500 -60.04,754,363.57 N/A,754,363.57 10311 Drainage Fund383,658.22383,579.480.2500 -78.74383,658.22 N/A383,658.22 GO SR2011 Animal Shelter2,155,857.37,155,414.94.2500 -42.43,155,857.37 N/A,155,857.37 20422 GO SR2011 Athletic Fields1,482,477.591,482,173.350.2500 -304.241,482,477.59 N/A1,482,477.59 GO SR2011 Soccer Fields1,343,624.60,343,348.86.2500 -75.74,343,624.60 N/A,343,624.60 10211 GO SR2011 Swimming Pool2,910,427.962,909,830.670.2500 -597.292,910,427.96 N/A2,910,427.96 W/S-Customer Deposits294,172.1794,111.80.2500 -0.3794,172.17 N/A94,172.17 20622 W/S-Equipment Repl/Cap.Imp373,712.74373,636.050.2500 -76.69373,712.74 N/A373,712.74 Water&Sewer1,360,050.77,359,771.66.2500 -79.11,360,050.77 N/A,360,050.77 10211 W/S-Vehicle Replacement544,917.85544,806.020.2500 -111.83544,917.85 N/A544,917.85 69,575.51.250034,576.63-04,152.1404,152.14 Water/SSLG - SAWS404,152.14 20144 TOTAL LONESTA13,488,371.163,351,109.35 -37,261.813,488,371.163,488,371.16 R1111 MBIA Tax I&S1,264,090.911,247,797.960.2600 -16,292.951,264,090.91 N/A1,264,090.91 Police Forfeiture359,697.3059,620.05.2600 -7.2559,697.30 N/A59,697.30 30733 Economic Development Corporation2,525,553.212,325,047.760.2600 -200,505.452,525,553.21 N/A2,525,553.21 Hotel Tax200,044.3700,001.44.2600 -2.9300,044.37 N/A00,044.37 20422 Special Events Fund66,662.5866,648.280.2600 -14.3066,662.58 N/A66,662.58 01,170.81.26004.72-01,235.5301,235.53 EMS Tax Notes 2010301,235.53 30633 TOTAL MBIA4,717,283.90,500,286.30 -16,997.60,717,283.90,717,283.90 4244 FEDERATED SR2007a Bond-City Wide Projects868,909.29868,783.730.1800 -125.56868,909.29 N/A868,909.29 Hotel Occupancy Tax78,233.298,221.98.1800 -1.318,233.29 N/A8,233.29 70177 Park Fund (Developers Fee)192,986.09192,958.200.1800 -27.89192,986.09 N/A192,986.09 Park Fund (Tree Mitigation)126,412.9526,394.68.1800 -8.2726,412.95 N/A26,412.95 10111 Tax I&S56.8856.870.1800 -0.0156.88 N/A56.88 4,735.48.1800.47-4,741.954,741.95 Library Board Fund44,741.95 40644 TOTAL FEDERATED1,311,340.45,311,150.94 -89.51,311,340.45,311,340.45 1111 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,267,630.321,338,986.392.95003,862.686,811.121,336,037.95 N/A1,338,257.78 ,750,151.10.0900,487.70,225.73,747,413.07,714,547.79 Capital One Capital Recovery1,617,493.91 136911 TOTAL CAPITAL ONE2,885,124.23,089,137.490,350.386,036.85,083,451.02,052,805.57 31133 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS TOTAL CAPITAL ONE 6% 10% 9% TOTAL LOGIC TOTAL FEDERATED 15% 4% TOTAL MBIA 15% TOTAL LONESTAR 41% City Portfolio By Use Pooled-Daily Operations, Designated Funds, $3,233,208.79 $8,347,704.08 $10,862,640.04 Special Revenue Funds, Debt Service Fund, $8,556,362.12 $1,264,147.79 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.0700 1 Month T-Bill 0.01000.01000.02000.06000.08000.07000.10000.07000.1000 3 Month T-Bill 0.06000.06000.06000.08000.13000.15000.15000.14000.1400 6 Month T-Bill 0.46000.52000.49000.50000.52000.53000.53000.51000.5000 Schertz Portfolio 0.05000.05000.05000.05000.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.40000.40000.40000.40000.4000 CD 365 Days 0.80000.80000.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.2514 LOGIC 0.23000.25000.28000.31000.26000.27000.27000.24000.2500 LoneStar 0.14000.15000.19000.21000.25000.24000.25000.26000.2600 MBIA 0.09000.14000.13000.15000.22000.21000.19000.18000.1800 Federated 2.32432.84002.83003.07003.07003.15003.15003.13003.0300 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:6/30/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt Cl III #69127,630.3227,630.3227,630.322.000.01 39,940.3339,940.33 JPMorgan Chase Disc Coml Paper9/21/201283.0040,000.00 Total Cash & Equivalent7,630.367,570.67,570.6 s62565 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014774.00125,000.00141,987.30138,645.006,875.00 Federal Home Loan Bks Cons Bds6/21/2013356.0080,000.0082,004.4081,272.001,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151264.00100,000.00116,185.00114,496.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012109.0050,000.0054,010.5050,635.002,250.00 Federal Home Ln Mtg Corp Deb11/15/2013503.00170,000.00191,084.25180,789.908,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013451.00250,000.00250,000.00262,560.0010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014878.00200,000.00200,609.40201,500.001,500.00 Federal Natl Mtg Assn 7/28/20151123.00125,000.00132,828.63131,998.752,968.00 US Treasury Note2/28/2014608.00100,000.0099,757.8299,914.00 Total Fixed Income1,200,000.001,268,467.301,261,810.653 Total Assets666.131,267,630.321,336,037.951,329,381.303 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #69117,493.9117,493.9117,493.911.000.01 JPMorgan Chase Disc Coml Paper9/21/201283.0080,000.0079,880.6779,880.67 Total Cash & Equivalent7,493.9197,374.57,374.5 s9898 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014774.00165,000.00187,423.24183,011.409,075.00 Federal Home Loan Bks Cons Bds6/21/2013356.00100,000.00102,505.50101,590.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151264.00200,000.00230,779.00228,992.009,750.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012109.00150,000.00162,031.50151,905.006,750.00 Federal Home Ln Mtg Corp Deb11/15/2013503.00250,000.00281,006.25265,867.5012,187.00 Federal Natl Mtg Assn Nts10/15/2013472.00200,000.00223,001.60211,174.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014878.00220,000.00220,078.68221,650.001,650.00 Federal Natl Mtg Assn7/28/20151123.00135,000.00143,454.91142,558.653,206.00 /28/201408.0000,000.0099,757.819,914.00 US Treasury Not e2619 Total Fixed Incom,520,000.01,650,038.4,606,662.5 e109155 Total Assets663.351,617,493.911,747,413.071,704,037.135