Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05-FEBRUARY 2012 FINANCIAL STATEMENT
FEBRUARY 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department April 10, 2012 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725938,954.16 7,674,742.74-8,651,660.64 - 3,152,064.36 Franchises 1,617,000 119,923.54 424,900.64- 601,374.72 - 1,015,625.28 Permits 1,187,800 92,493.00 879,979.83- 373,427.00 - 814,373.00 Licenses 31,300 8,295.00 16,418.10- 29,192.50 - Fees 3,341,727 250,279.88 1,182,724.90- 982,800.43 (382.00) Fines 30,000 2,497.98 10,515.84- 10,391.69 - 19,608.31 Inter-Jurisdictional 571,245 96,219.79 170,661.04- 284,349.37 - 286,895.63 Fund Transfers 1,760,658 108,750.59 316,615.75- 544,752.95 - 1,215,905.05 Miscellaneous615,50032,626.47184,514.69249,945.89(8.90) - TOTAL REVENUES20,958,9551,650,040.4110,861,073.5311,727,895.19(390.90) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,813.46 - 9,024.88 8,764.72 - 14,035.28 Supplies500 - - 46.00 95.98 - City Support Services 17,500 50.00 219.98 12,720.18 916.86 31.75 Operations Support 300 - - - - - Staff Support20,4001,210.742,150.00 9,417.2515,851.961,289.94 Operating Equipment -- - - - - TOTAL CITY COUNCIL61,5003,074.202,369.9831,208.3125,629.521,321.69 CITY MANAGE R Personnel Services 836,400 60,012.06 277,813.22- 289,950.82 - 546,449.18 Supplies5,331 28.65 268.94 1,354.80 2,235.95 135.00 3,228.99 - - - - City Support Services - - Operations Support - - - - - - Staff Support 25,550 699.34 1,527.05 11,328.68 14,047.23 3,006.54 Operating Equipment -133.43 - - - - TOTAL CITY MANAGER 867,281 60,740.05 290,630.131,795.99 306,234.00 3,141.54 559,701.45 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services257,113 21,960.98 - 94,649.94 99,753.53 - 157,359.47 Supplies2,500 214.77 99.00 601.83 832.01 119.49 1,647.50 City Support Services1,000 - - - - - Operations Support 3,000 - 700.00 1,166.00 1,558.00 - Staff Support 5,500 136.07 285.20 1,149.39 1,414.73 51.93 Court Support 800 - - - - - Professional Services 71,100 3,832.50 21,603.75- 22,000.00 18,891.25 Maintenance Services 2,200 - - 300.00 249.94 - Operating Equipment1,000100.00497.14 847.14500.0042.13 TOTAL MUNICIPAL COURT 26,244.32344,213 1,581.34 119,970.91 126,655.35 19,104.80 200,034.19 CUSTOMER RELATIONS-311 Personnel Services109,618 8,856.52 - 32,529.97 36,231.05 - 73,386.95 Supplies300 17.11 - - 44.75 101.85 153.40 Staff Support1,100 -- - - - Operating Equipment500 192.00-71.00 - - TOTAL CUSTOMER RELATIONS-311 111,518 8,873.63 32,529.97- 36,467.80 172.85 PLANNING & ZONING Personnel Services 139,925 11,389.95 51,532.09- 53,530.97 - 86,394.03 Supplies 2,700 - 156.45 73.36 686.04 - Operations Support 750 - - 77.95 - - Staff Support 17,150 - 548.55 3,032.00 1,720.85 43.06 Professional Services 76,650 1,366.40- 28,647.39 13,144.28 1,976.60 Operating Equipment3,500 -1,055.002,112.00 - - TOTAL PLANNING & ZONING240,67511,389.952,071.4084,417.7969,082.144,131.66 LEGAL SERVICES Operations Support 13,000 - - 8,117.96 - - 13,000.00 Professional Services245,00083,028.92 143,920.3042,518.13133.88 - TOTAL LEGAL SERVICES 258,000 83,028.92 50,636.09- 143,920.30 133.88 113,945.82 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services648,323 49,269.70 - 250,614.17 227,130.07 - 421,192.93 Supplies57,100 3,922.08 1,224.76 28,303.23 27,606.04 5,382.14 25,336.58 Utility Services111,000 7,585.62 - 26,987.33 31,408.15 47.35 79,544.50 - - - - Operations Support - - Staff Support 11,179 505.03 41.35 5,122.89 5,329.55 588.13 Maintenance Services 106,450 7,064.61 673.05 61,125.96 40,197.96 1,214.03 Rental/Leasing 1,400 - - 763.92 - - Operating Equipment2,500 - 1,702.33- - - Capital Outlay24,500 -- - - - TOTAL FACILITIES MAINTENANCE 962,452 68,347.04 1,939.16 372,917.50 331,671.77 8,933.98 CITY SECRETAR Y Personnel Services 164,529 13,432.32 64,541.95- 62,400.83 - 102,128.17 Supplies 1,250 60.40 - 760.78 636.45 149.89 City Support Services 9,780 - - 1,402.00 - - Staff Support8,605952.82 3,027.272,054.47288.93 - TOTAL CITY SECRETARY 184,164 14,445.54 68,759.20- 66,064.55 438.82 NON-DEPARTMENTA L Supplies 2,500 - - 195.44 10.71 - City Support Services 525,970 1,294.02- 212,531.12 168,395.27 3,747.26 Operations Support 139,000 13,004.51 1,076.05 42,521.67 61,382.30 10.50 City Assistance 459,046 - 196,822.44- 192,093.82 - 266,952.18 Professional Services 174,650 1,902.30 47,269.84- 22,569.61 20,000.00 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,312,016 14,906.81 2,370.07 499,340.51 444,451.71 23,757.76 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services215,678 23,107.55 - 55,854.70 98,959.77 - 116,718.23 Supplies2,900 682.74 - 129.87 1,687.08 72.93 1,139.99 Operations Support35,100 696.17 4,989.75 6,587.99 8,536.25 1,038.67 30,514.83 Staff Support4,350 161.08 196.44 1,002.87 1,198.81 102.69 3,244.94 Operating Equipment300 -- - - - TOTAL PUBLIC AFFAIRS 258,328 24,647.54 5,186.19 63,575.43 110,381.91 1,214.29 RECORDS MANAGEMEN T Personnel Services 47,850 4,116.63 17,989.98- 18,863.48 - 28,986.52 Supplies 750 67.00 - 75.00 138.00 - Staff Support 1,500 255.00 - 260.00 340.00 159.40 Professional Services 15,000 149.00 - 6,164.14 1,353.50 - 13,646.50 Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,100 4,587.63 24,489.12- 20,694.98 159.40 SCHERTZ TALES MAGAZINE Personnel Services 129,161 10,542.59 46,460.63- 49,200.22 - 79,960.78 Supplies 200 45.00 - - 45.00 - Opperations Support 200 - - - - - Staff Support 1,500 - - - 85.74 61.57 Professional Services302,70023,610.63 116,056.0198,622.408,727.86 - TOTAL SCHERTZ TALES MAGAZINE 433,761 34,198.22 145,083.03- 165,386.97 8,789.43 ENGINEERING Personnel Services 164,460 7,635.64 63,292.78- 31,614.64 - 132,845.36 Supplies 400 - - 67.35 134.87 121.38 City Support Services - - - - - - Utility Services 600 - - - 60.19 - Staff Support 2,213 - - 395.00 130.00 - Professional Services 48,165 6,007.50 - 6,710.00 40,900.00 - Maintenance Services 4,044 - - 2,145.29 3,345.29 - Operating Equipment -- - - - - Capital Outlay26,000 25,451.31-299.99 - - TOTAL ENGINEERING 245,882 13,643.14 72,610.42- 101,636.30 421.37 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,079 10,322.68 - 44,410.96 46,614.05 - 75,464.95 Supplies3,500 - - - 552.02 - Staff Support 4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 131,629 10,322.68 44,410.96- 47,166.07 - 84,462.93 TOTAL GENERAL GOVERNMENT 5,476,519 378,449.67 17,314.13 1,900,579.37 1,995,443.37 71,721.47 PUBLIC SAFETY POLICE Personnel Services4,536,879 352,002.92 - 1,650,064.34 1,705,737.27 - 2,831,141.73 Supplies31,957 740.98 4,761.16 5,855.06 8,259.05 9,710.31 18,748.80 City Support Services35,000 - - - 19,518.41 - 15,481.59 Utility Services123,456 - - 29,631.41 34,926.34 - 88,529.66 Operations Support1,500 45.00 - 98.00 720.00 355.00 425.00 Staff Support58,372 2,651.01 1,732.17 3,011.74 9,677.30 7,025.00 43,401.87 City Assistance10,914 - - 1,664.98 2,217.74 283.00 8,413.26 Professional Services20,000 - - - 642.85 - 19,357.15 Maintenance Services44,435 - - 14,851.50 10,811.95 14,325.00 19,298.05 Operating Equipment57,887 4,579.98 2,905.10 27,737.21 14,551.33 27,071.61 19,169.16 Capital Outlay142,52512,554.80147,872.00155,076.05 - - TOTAL POLICE 5,062,925360,019.8921,953.231,880,786.241,962,138.2958,769.92 FIRE RESCUE Personnel Services 2,508,586 214,344.00 945,134.52- 1,015,499.46 - 1,493,086.54 Supplies 20,500 256.03 9,239.99 1,886.40 11,499.42 243.42 Utility Services 57,000 1,586.90 7.64 14,039.50 18,091.85 - 38,915.79 Operations Support 800 111.56 - 120.00 111.56 281.84 Staff Support 120,185 9,467.79 20,833.33 26,744.32 47,852.58 24,965.27 City Assistance 18,600 8,122.00- 10,323.17 8,366.30 - 18,355.70 Professional Services 18,140 - - 1,200.00 11,793.0022.19 Maintenance Services 56,000 2,970.21 3,710.01 3,598.95 10,692.71 6,219.75 Operating Equipment58,3003,291.0415,553.04 12,505.3112,279.403,198.33 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,893,111 232,027.53 57,466.01 1,015,552.17 1,155,531.47 46,701.61 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services420,518 34,766.88 - 139,749.32 161,221.97 - 259,296.03 Supplies2,500 28.65 - 565.15 595.48 59.20 1,845.32 Utility Services6,500 - - 1,758.38 1,599.52 - Operations Support 1,500 - - 439.87 - 44.00 Staff Support 8,000 43.65 581.37 1,882.31 1,533.86 72.75 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -- - - - TOTAL INSPECTIONS 450,01834,839.18581.37144,395.03164,950.83175.95 MARSHAL SERVICE Personnel Services 534,355 43,516.47 158,493.31- 208,141.23 - 326,213.77 Supplies 4,600 107.88 205.82 166.30 1,462.48 41.67 Utility Services 12,000 - - 2,103.09 4,058.33 - Operations Support 4,000 - - 367.49 986.41 - Staff Support 15,400 551.00 410.00 938.61 4,543.67 315.00 Professional Services - - - - - - Maintenance Services 30,700 - - 3,098.00 149.00 1,270.00 Operating Equipment16,000 5,508.919,207.0330.00 -2,206.37 Capital Outlay34,000 31,022.0541,560.29 - - - TOTAL MARSHAL SERVICE 651,055 44,175.35 2,822.19 212,236.00 259,570.20 1,656.67 TOTAL PUBLIC SAFETY 9,057,109 671,061.95 82,822.80 3,252,969.44 3,542,190.79107,304.15 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services680,357 56,149.78 - 245,996.13 269,424.22 - 410,932.78 Supplies7,100 61.75 21.04 1,792.61 2,056.43 504.39 4,560.22 Utility Services113,900 5,018.47 - 41,148.26 40,745.16 624.50 72,530.34 - - - - Operations Support - - Staff Support 10,265 356.61 79.91 2,411.30 2,079.24 412.47 Maintenance Services 270,800 8,137.20 579.71 57,180.15 71,342.22 13,336.22 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - 4,200.00 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,086,82269,723.81680.66366,398.45389,133.2614,877.58 TOTAL PUBLIC ENVIRONMENT 1,086,822 69,723.81 680.66 366,398.45 389,133.26 14,877.58 PARKS & RECREATION PARKS DEPARTMENT Personnel Services506,870 33,129.81 - 182,892.93 188,590.12 - 318,279.88 Supplies40,555 679.98 1,169.51 15,482.57 15,608.13 2,022.19 24,094.19 Utility Services113,000 6,760.43 - 34,893.38 39,818.94 2,993.10 70,187.96 Operations Support700 - - 880.80 - - Staff Support 8,573 426.71 3,870.9860.93 4,250.62 351.74 4,031.57 Professional Services62,610 2,299.83 - 9,945.00 25,233.83 - 37,376.17 Maintenance Services22,000 3,130.57 44.99 9,597.43 9,259.18 3,815.17 8,970.64 Rental/Leasing42,200 - - 26,045.49 16,257.20 26,424.85 (482.05) (45.00) - 5,428.93 (45.00) Operating Equipment - - Capital Outlay -190.56 - - - - TOTAL PARKS DEPARTMENT796,50846,382.331,275.43289,228.07298,973.0235,607.05 SWIM POOL Supplies 16,700 44.36 392.93 413.62 560.94 - 16,531.99 Utility Services 25,500 1,528.37 - 4,601.34 6,898.87 186.62 Staff Support 925 - - - 750.00 - Maintenance Services 199,378 4,000.00- - 4,000.00 7,275.00 Rental/Lease500 -378.00 - - - TOTAL SWIM POOL 1,572.73243,003 4,392.93 5,392.96 12,209.81 7,461.62 227,724.50 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services107,533 4,576.76 - 24,198.00 22,346.56 - 85,186.44 Supplies28,300 1,145.04 1,127.61 4,951.01 6,302.19 182.00 22,943.42 Utility Services47,550 3,044.17 - 10,624.97 11,741.01 - 35,808.99 Operations Support15,200 1,371.45 - 4,254.51 4,201.71 8.00 10,990.29 Staff Support3,300 153.30 439.45 250.00 875.76 - Professional Services 1,600 - 150.00 925.00 150.00 - Operating Equipment5,000530.004,243.88 6,589.58100.00 - TOTAL COMMUNITY/CIVIC CNTR208,48310,820.725,960.9445,303.4952,206.81190.00 TOTAL PARKS & RECREATION 1,247,994 58,775.78 11,629.30 339,924.52 363,389.64 43,258.67 CULTURAL LIBRARY Personnel Services 692,531 58,082.73 258,595.28- 273,550.66 - 418,980.34 Supplies14,000 168.00 86.59 3,187.44 4,134.40 129.78 9,822.41 Utility Services41,000 4,351.00 - 14,639.06 14,101.45 666.38 26,232.17 Operations Support2,000 - 174.00 - 174.00 - Staff Support 4,215 139.43 58.97 489.82 761.59 216.57 Professional Services 2,100 - - 2,065.00 2,140.00 - Maintenance Services 2,400 - - 800.00 800.00 400.00 Operating Equipment 75,000 11,871.85 2,366.43 32,411.30 28,079.37 9,851.55 Capital Outlay -- - - - - TOTAL LIBRARY 74,613.01833,246 2,685.99 312,187.90 323,741.47 11,264.28 500,926.24 TOTAL CULTURAL833,246 74,613.01 2,685.99 312,187.90 323,741.47 11,264.28 500,926.24 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services296,439 17,924.29 - 118,737.71 107,218.20 - 189,220.80 Supplies25,000 1,382.35 319.99 7,110.40 7,528.41 1,694.63 16,096.95 Utility Services11,200 354.00 - 3,152.30 3,332.84 - Operations Support 500 - - - - - Staff Support 11,560 201.51 34.48 1,602.00 3,070.76 959.27 City Assistance 10,000 2,867.91 - 2,620.98 5,384.73 - Professional Services 14,500 1,020.50 - 4,158.50 1,905.50 - 12,594.50 Maintenance Services 6,200 485.00 - 1,161.78 2,825.00 970.50 Operating Equipment9,500 3,995.001,374.38 - - - Capital Outlay -- - - - - TOTAL ANIMAL SERVICES384,89924,235.56354.47142,538.67132,639.823,624.40 TOTAL HEALTH 384,899 24,235.56 354.47 142,538.67 132,639.82 3,624.40 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 260,032 23,306.07 104,120.45- 110,157.00 - 149,875.00 Supplies2,000 - - 403.49 68.84 - City Support Services 372,354 15,723.00 51,016.73- 75,266.63 57,344.64 Utility Services 154,949 1,536.38 1,585.17 37,149.65 54,332.68 1,614.58 Staff Support 15,250 1,525.84 2,036.38 3,187.13 5,891.45 2,215.77 Professional Services 2,500 - - - - - Maintenance Services 12,500 - 11,250.07- 5,732.44 795.00 Operating Equipment 129,315 13,934.35 4,911.44 27,684.32 33,767.60 6,534.89 Capital Outlay213,500 -- - - - TOTAL INFORMATION TECHNOLOGY1,162,400 56,025.64 8,532.99 234,811.84 285,216.64 68,504.88 817,211.47 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services296,750 25,474.93 - 82,827.36 100,633.18 - 196,116.82 Supplies1,329 - - - 781.57 - Human Services 47,156 - 654.00 14,831.92 13,173.04 387.00 Operations Support 16,596 175.00 532.56 3,421.29 1,607.41 - 15,521.17 Staff Support 14,897 833.09 550.72 5,044.96 8,060.82 - City Assistance 9,860 129.50 - 2,072.00 1,650.50 1,066.00 Professional Services - - - - - - Operating Equipment139.304,162.83 4,302.13- - - TOTAL HUMAN RESOURCES 26,751.82386,588 5,900.11 108,197.53 130,208.65 1,453.00 260,826.48 FINANCE Personnel Services429,810 39,034.62 - 159,725.65 181,434.45 - 248,375.55 Supplies3,600 222.04 - 1,277.26 2,031.10 - Operations Support 850 - - - 97.31 - Staff Support 15,805 - - 1,830.00 988.67 2,025.00 Rental/Leasing 2,230 - - - - - Operating Equipment1,000266.47 266.47- - - TOTAL FINANCE453,29539,256.66266.47162,832.91184,818.002,025.00 PURCHASING & ASSET MG T Personnel Services 241,940 19,835.36 90,208.87- 93,812.03 - 148,127.97 Supplies 800 11.93 - 20.30 131.63 105.83 Utility Services 450 - - 87.09 249.97 - Operations Support 1,000 61.79 - 60.68 111.79 736.13 Staff Support 9,600 400.00 65.00 2,600.57 2,262.20 1,629.00 Operating Equipment7,500 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 261,290 20,309.08 65.00 92,977.51 104,158.44 2,470.96 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,880 16,403.86 - 62,813.08 73,427.73 - 144,452.27 Supplies109,600 11,735.09 2,927.39 36,178.32 60,845.52 15,964.42 35,717.45 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 - - 1,220.74 1,252.77 - Operations Support 400 375.00 - - 375.00 - Staff Support 3,835 48.40 620.41 779.62 928.81 412.29 Maintenance Services 65,750 11,400.43 1,685.29 19,013.06 21,291.39 1,436.44 Rental/Lease200 -269.80 - - - Operating Equipment5,000 -5,349.97 - - - Capital Outlay -- - - - - TOTAL FLEET SERVICE411,36539,962.785,233.09121,504.82165,240.9917,813.15 TOTAL INTERNAL SERVICE 2,674,938 182,305.98 19,997.66 720,324.61 869,642.72 92,266.99 MISC & PROJECTS CITY ASSISTANCE - - 174.42 86.17 Utility Services - - Patient Assistance 5,000 - - 5,000.00 2,500.00 - Children's Advocacy Assistance 5,000 - - - - - Senior Citizen's Hot Meals42,000 21,000.0021,000.00 - - 21,000.00 TOTAL CITY ASSISTANCE52,000- 26,174.42-23,586.1721,000.00 COURT - RESTRICTED FUNDS Operating Equipment -- - - - - TOTAL CITY ASSISTANCE - - - - - - TOTAL MISC & PROJECTS 52,000 - - 26,174 23,586 21,000 TOTAL EXPENDITURES20,813,5271,459,165.76 135,485.01 7,061,097.38 7,639,767.24365,317.54 REVENUE OVER(UNDER) EXPEND.145,4284,088,127.95 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 635,719.33 6,442,665.23- 6,717,781.56 - 166,672.44 000-411200Advalorem Tax - Delinquent 50,000 3,141.09 23,021.73- 34,040.13 - 15,959.87 000-411300Advalorem Tax - P&I 50,000 11,965.24 12,644.54- 21,738.20 - 28,261.80 000-411500Sales Tax Revenue-Gen Fund4,784,071 288,128.50 1,178,672.05- 1,864,324.51 - 2,919,746.49 000-411600Bingo Tax 2,200 - - 1,009.95 - - 000-411700Mixed Beverage Ta16,729.2413,776.24 x 33,000.00 - - - TOTAL Taxes11,803,725 938,954.16 7,674,742.74- 8,651,660.64 - 3,152,064.36 Franchises 000-421200Center Point/Entex Energy 36,000 2,362.88 17,748.73- 17,987.44 - 18,012.56 000-421220City Public Service 330,000 23,354.61 118,313.65- 117,209.79 - 212,790.21 000-421240Guadalupe Valley Elec Co-op 440,000 35,094.79 86,926.39- 161,788.22 - 278,211.78 000-421250New Braunfels Utilities 55,000 3,854.96 - 18,527.72- - 36,472.28 000-421300Time Warner-State Franchise 345,000 28,184.29 81,908.40- 143,017.06 - 201,982.94 000-421350Time Warner-PEG Fee 65,000 - 16,370.38- 16,039.50 - 48,960.50 000-421460AT&T Franchise Fee 185,000 14,984.14 45,445.16- 74,753.72 - 110,246.28 000-421465AT&T PEG Fees 26,000 - 5,834.61 7,247.95 000-421480Other Telecom Franchise 35,000 7,203.65 - 9,016.05 7,636.89 - 27,363.11 000-421500Solid Waste Franchise Fee100,0004,884.2243,337.2737,166.43 - - TOTAL Franchises1,617,000119,923.54 424,900.64-601,374.72 - 1,015,625.28 Permits 000-431100Home Occupation Permit 500 35.00 - 245.00 210.00 - 000-431200Building Permit - 755,856.83- - - - 000-431205Building Permit - Residential 600,000 43,015.00 - 180,599.00- - 419,401.00 000-431210Building Permit - Commercial 300,000 10,505.00 - 21,656.00- - 278,344.00 000-431215Building Permit - General - 44,442.00- - 12,102.00 - (44,442.00) 000-431300Mobile Home Permit 200 - - 80.00 40.00 - 000-431400Signs Permit 1,700 30.00 - 235.00 305.00 - 000-431500Food Establishmnt Permit 30,000 500.00 11,395.00- 9,975.00 - 20,025.00 000-431600Garage Sale Permit 8,600 250.00 - 3,160.00 3,110.00 - 000-431700Plumbing Permit 80,000 10,271.00 39,422.50- 46,805.00 - 33,195.00 000-431750Electrical Permit 55,000 4,040.00 20,960.00- 17,480.00 - 37,520.00 000-431800Mechanical Permit 59,000 4,900.00 25,340.00- 20,300.00 - 38,700.00 000-431900Solicitor/Peddler Permit - - 240.00 250.00 - - 000-431950Animal/Pet Permit 2,000 5.00 - 1,385.00 715.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,8001,250.00-1,950.003,950.00 - 000-432100Security Alarm Permit 42,000 4,840.00 16,323.00- 20,315.00 - 21,685.00 000-435000Fire Permit5,000750.00 3,275.003,387.50 - - TOTAL Permits1,187,80092,493.00 879,979.83-373,427.00 - 814,373.00 Licenses 000-441000Alcohol Beverage License 6,300 930.00 - 760.00 1,962.50 - 000-442000Contractors License 22,000 6,830.00 13,975.00- 25,245.00 - (3,245.00) 000-444000Pet License3,000535.00 1,985.001,683.10 - - TOTAL Licenses 31,300 8,295.00 16,418.10- 29,192.50 - Fees 000-451000Municipal Court Fines 1,665,009 121,156.63 424,960.66- 424,625.86 - 1,240,383.14 000-451100Arrest Fee 50,694 5,339.16 18,494.66- 21,611.69 - 29,082.31 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 17,180.00 50,977.26- 56,241.00 - 135,759.00 000-451210Court - Claims & Judgements - - - 1,842.23 - - (1,842.23) 000-451320Civil Justice Fee-Court 75 8.07 27.55 33.74 - 000-451321Civil Justice Fee-State 72.48 - - 304.24 - - 000-451340Judicial Fee - City 6,826 740.33 - 2,463.93 2,883.29 - 000-451400Traffic Fine Costs TTL 25,984 2,690.26 - 9,274.45 11,112.69 - 14,871.31 000-451500Teen Court Admin Fee 260 100.00 - 200.00 320.00 - 000-451510Juvenile Case Mgmt Fee 55,896 6,175.10 20,557.52- 24,042.31 - 31,853.69 000-451600Technology Fund Fee 45,601 4,967.67 16,588.83- 19,353.73 - 26,247.27 000-451700Security Fee 34,220 3,725.73 12,450.65- 14,515.35 19,704.65 000-451800Time Payment Fee - City 7,336 669.84 - 2,804.74 2,366.65 - 000-451850State Fines 10% Service Fee 72,470 - 33,448.06- 28,248.02 - 44,221.98 000-451900DPS Payment - Local 11,858 1,380.80 - 4,254.23 4,496.40 - 000-452000Child Safety Fee 12,243 2,512.70 - 4,501.42 12,593.94 - 000-452050Indigent Defense Fee 21,655 2,332.14 - 7,927.67 9,263.77 - 12,391.23 000-452100Platting Fees 98,000 9,500.00 29,000.00- 26,500.00 - 71,500.00 000-452200Site Plan Fee 74,000 4,500.00 - 7,500.00 10,500.00 - 63,500.00 000-452300Plan Check Fee 465,000 32,359.00 382,800.41- 134,711.00 - 330,289.00 000-452310Miscellaneous Review Fee 13,500 2,100.00 - - 5,100.00 - 000-452320Tree Mitigation Admin Fee 10,500 - - - 780.00 - 000-452400BOA/Zoning Fees 4,000 - - 1,400.00 2,750.00 - 000-452500Food Handler Class 7,000 140.00 - 3,680.00 1,670.00 - 000-452520Fire Training Classes 400 - -- - - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452600Specific Use/Zone Chng Fee 7,500.0020,000 - 7,500.00 19,850.00 - 000-452710Zoning Ltr & Dev Rights 1,500 - - 225.00 1,050.00 - 000-453100Reinspection Fees 30,000 3,000.00 21,375.00- 15,825.00 - 14,175.00 000-453200Mowing Fees - Inspections 12,000 - - 8,881.16 710.83 - 11,289.17 000-453211Admin Fee-Inspections 7,480 2,000.00 - 3,500.00 3,140.00 - 000-453310Misc Inspection Fee - - 40.00 19.49 - - 000-453500SubContractor Reg. Fee 17,000 - - 9,660.00 - - 17,000.00 000-453710Foster Care 500 150.00 - 450.00 400.00 - 000-454100Swim Pool Reservation Fee - - 55.00 - - 000-454200Pool Gate Admission Fee 25,000 - - - - - 25,000.00 000-454300Seasonal Pool Pass Fee 5,500 - - - - - 000-456500Haz Mat Fees 3,000.00800 - - 3,000.00 - (2,200.00) 000-456510Fire Plan Review 3,000 - - - - 000-456600Fire Re-inspection Fee 180 150.00 - 500.00 400.00 - 000-458100Sale of Merchandise - - - - - - 000-458300Sale of Property/Auction 22,000 324.17 - 1,992.58 9,257.47 - 12,742.53 000-458400Civic Center Rental Fees 171,000 7,142.00 47,245.25- 40,142.25 (250.00) 000-458401Capital Recovery Fee-Civic Cntr 7,500 1,600.00 - 910.00 2,450.00 - 000-458450North Center Rental Fees 15,000 1,655.00 - 3,026.00 9,357.92 - 000-458500Community Center Rental Fees18,000 1,880.30 - 6,045.52 9,769.29 - 000-458550Pavilion Rental Fees 18,500 1,372.50 - 6,058.70 4,344.50 - 14,155.50 000-458560Chamber of Comm rent 11,700 - - 3,900.00 3,900.00 - 000-458570Non-Resident SYSA League 12,000 - - 7,060.00 13,490.00 - (1,490.00) 000-458600Ball Field Use - - 1.76 2,445.00 - - (2,445.00) 000-458650NonResident User Fee-BVYA 11,000 - - 2,820.00 2,670.00 - 000-458660BVYA Utility Reimbursement - -- 3,195.72 - - (3,195.72) 000-458680Tournament Fees-Soccer 15,000 - - 2,400.00 7,625.00 - 000-458700Vehicle Impoundment 5,000 - - - - - 000-459200NSF Check Fee 250 - - 328.00 - - 000-459300Notary Fee 300 6.00 - 162.00 120.00 - 000-459400Maps, Copies, UDC, & Misc F 400 - - 583.18 58.10 - 000-459600Animal Adoption Fee 15,000 1,138.00 - 4,712.50 5,380.50 (132.00) 000-459700Pet Impoundment Fee 15,000 1,322.00 - 7,624.01 6,087.25 - 000-459800Police Reports Fee6,500390.00 2,191.202,412.20 - - TOTAL Fees 3,341,727 250,279.88 1,182,724.90- 982,800.43 (382.00) 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,497.9810,515.8410,391.69 - - TOTAL Fines30,0002,497.98 10,515.84-10,391.69 - 19,608.31 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 - - 7,025.92 7,025.92 - 14,051.08 000-473200City of Seguin - Fire Contract 40,263 3,355.26 16,776.30- 16,776.30 - 23,486.70 000-473300Guad Co - Library 180,000 15,901.33 75,340.00- 79,506.65 - 100,493.35 000-473400Randolph AFB-Animal Cntrl 1,000 300.00 - 1,200.00 600.00 - 000-474200Library Services - Cibolo 20,000 - - - - - 20,000.00 000-474210Library Services-Selma 19,000 - - - - - 19,000.00 000-474400Dispatch Service - Cibolo 133,305 33,326.25 66,652.90- 66,652.50 - 66,652.50 000-474600School Crossing Guard-Bexar6,6002,832.98 2,004.0513,111.41 - - 000-474610School Cross Guard-Guadalupe 1,661.8713,176.59 -3,003.97 - -(13,176.59) 000-474700School Officer Funding150,00037,500.00 87,500.00- - - TOTAL Inter-Jurisdictional571,24596,219.79 170,661.04-284,349.37 - 286,895.63 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 21,960.00- 36,600.00 - 51,240.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 42,555.25- 59,427.50 - 83,198.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 - 9,722.00 17,431.25 - 18,048.75 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 156,194.25- 367,175.85 - 514,046.15 000-486106Transfer in-Special Events - - - 1,000.00 - - (1,000.00) 000-486317Transfer From Park Fund 13,000 - - - - - 13,000.00 000-487000Interfund Charges-Fleet 98,484 8,207.00 22,326.25- 41,035.00 - 57,449.00 000-488000Interfund Charges-4B 53,000 4,416.67 13,858.00- 22,083.35 - 30,916.65 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 -108,750.59 316,615.75 544,752.95 - 1,215,905.05 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 49.91 - 1,405.57 126.72 - 000-491200Investment Income 30,000 4,620.81 13,627.71- 18,968.28 - 11,031.72 000-491800Gain/Loss 196.25 - - 443.67 - - 000-491900Unrealized Gain/Loss (13,358.07)- (13,288.63) - (3,987.83) - 13,288.63 000-492100Proceeds-Sale of Land - - 57,867.85- - - (57,867.85) 000-493000Donations-Others - - - - - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap. 52.00 21,728.00- 4,806.34 - - (4,806.34) 000-493400Donation - Animal Control 1,200 20.00 - 2,350.26 1,579.01 - 000-493401Donations-A/C Microchip 500 235.00 - 1,100.00 910.00 - 000-493402Donations-Spay&Neuter 13,500 1,270.00 - 7,212.55 5,517.00 - 000-493503Donations - Fire Rescue - - 25.00 - - - 000-494481LawEnforcemtOfficersStnd&Ed 50.00 - 3,550.22 50.00 - - 000-494482DOJ-PD GRANT - - - 2,893.77 - - (2,893.77) 000-495040Friends of N. Schertz Park - - - 3,074.00 - - (3,074.00) 000-497000Misc Income-Gen Fund 81,000 1,229.10 (12,802.15)- 10,615.74 (8.90) 000-497005Misc Income-Publications 290,000 14,831.95 52,135.90- 73,045.95 - 216,954.05 000-497007Misc Income-Schertz Artz 20.00 - - 20.00 - - 000-497100Misc Income-Police 25,000 403.91 13,879.13- 2,382.95 - 22,617.05 000-497200Misc Income-Library 19,000 285.40 - 1,309.55 1,662.94 - 17,337.06 000-497210Misc Income-Library Copier 13,500 1,230.40 4,313.75 5,485.46 - 000-497300Misc Income-Animal Control 500 - - 727.30 105.00 - 000-497400Misc Income-Streets Dept. 20,000 897.60 - 7,575.00 7,019.48 - 12,980.52 000-497500Misc Income-TML Insurance 78,000 - 49,731.90- - - 78,000.00 000-497550Misc Income-TML Reimbursemt20,000 1,662.02 17,643.20- 5,795.91 - 14,204.09 000-497600Misc Income-Parks/Vending Mach.2,500 95.76 -860.41742.35 - 000-498000Reimbursmnt-Gen Fund5,000617.00 418.0021,409.02 - -(16,409.02) 000-498100Reimbursmnt Fire - Training 800 - - 846.00 - - 000-498105Reimburmnt Police - DEA - - 2,157.39 569.87 - - 000-498110Reimbursmnt Fire - Emg. Acti-O12,0008,847.19 38,143.218,078.07 - - TOTAL Miscellaneous 615,500 32,626.47 184,514.69- 249,945.89 365,563.01(8.90) TOTAL REVENUES20,958,9551,650,040.41 10,861,073.53-11,727,895.19 (390.90) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking705,081.10$ Cash in Investment Pools LOGIC Investment-General Fund4,608,068.00 LOGIC Investment-Equip Replacement73,363.99 LOGIC Investment-Veh Replacement7,081.16 LOGIC Investment-Air Condi Replacment146,477.35 CAPITAL ONE Investment-General Fund1,335,566.21 Total Cash in Bank & Investment Pools$6,997,888.07 17 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 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 18-A Sales Tax - General Fund $600,000 $500,000 40% -2% 25% 17% $400,000 -2% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 415,822 461,400 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 18-B CITY PUBLIC SERVICE $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 96,392 - - - 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 18-C C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET41.67% 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 400.00 - 3,319.01 440.00 - 27,560.00 TML Dinner - - - - - - Hal Balwin Scholarship 24,000.00 - 110.00 60.00 - - 23,940.00 Miscellaneous175.00412.94- 761.39416.65 - TOTAL REVENUES114,275.00 812.94 - 3,845.66 1,261.39 - 113,013.61 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 - - - - - 4,750.00 Festival of Angels 14,250.00 12,645.61- 13,050.46 - - 1,199.54 Employee Appreciation Event 5,000.00 - 126.00 - 4,950.0050.00 - 4th of July Jubilee 218.05 - 218.05 - - - National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 2,220.00 - - 2,380.00 1,500.00 Blue Santa - - - - - - Schertz Fest - 455.91 - - - - TML Events - - - - - - Schertz Sweetheart 37,000.00 18.16 17,075.96- 3,001.32 33,498.68500.00 Hal Baldwin Scholarship11,000.00- -1,000.00 - -10,000.00 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 2,238.16103,600.00 218.05 30,703.48 19,649.83 2,050.00 82,118.22 TOTAL EXPENDITURES108,750.00 2,238.16 218.05 30,703.48 19,649.83 2,050.00 87,268.22 REVENUE OVER(UNDER) EXPEND5,525.00(18,388.44) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking9,027.86$ Cash in Investment Pools MBIA Special Events66,606.13 Total Cash in Bank & Investment Pools$75,633.99 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,00052,218.46 35,061.00-52,218.46 127,781.54- Fees14,164,2501,255,771.84 5,622,772.13-6,348,706.25 7,815,543.75- Fund Transfers484,6747,056.17 20,154.00-35,280.85 449,393.15- Miscellaneous962.7871,521.31200,092.87 103,260 - - TOTAL REVENUES14,932,1841,316,009.255,749,508.446,636,298.43 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers -- 27,366 - - - TOTAL NON DEPARTMENTAL-- 27,366 - - -27,366.00 BUSINESS OFFICE Personnel Services383,89429,824.07 168,975.45-139,903.57 243,990.43- Supplies5,400602.72418.331,160.012,007.24113.05 Human Services100----40.00 Operations Support114,0002,734.66 26,276.59-37,600.4510,000.00 Staff Support7,100425.8194.261,208.27830.551,016.50 Professional Services16,0001,661.82395.004,681.448,913.80- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300420.00-2,660.003,600.001,940.00 Operating Equipmen500.006,077.625,932.94 t 6,200 - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE35,669.081,407.59211,039.38198,788.5513,109.55 603,994 W & S ADMINISTRATION Personnel Services1,184,89885,083.72 503,312.67-437,661.53 747,236.47- Supplies200,7001,821.774,458.8178,589.4523,724.6662,183.46 Human Services1,000--64.00-40.00 City Support Services113,99950.00 34,599.57-34,379.59 79,619.41- Utility Services2,634,34442,484.24 583,736.61-1,141,386.0263,168.19 Operations Support8,750256.01-2,082.381,515.83- Staff Support33,0001,310.04294.548,962.537,539.811,456.82 City Assistance1,912--236.00150.00147.00 Professional Services187,4008,821.25 55,726.98-24,689.5116,580.54 Fund Charges/Transfers2,623,507183,675.97 798,374.20-1,237,342.74 1,386,164.26- Maintenance Services5,517,250427,374.3012,287.431,867,754.321,963,697.75168,711.73 Other Costs35,00029,706.44 28,911.85-30,956.44- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,35395,978.13 451,525.62-96,868.35 1,133,484.65- Rental-Leasing6,070--662.532,516.68- Operating Equipment8,000--9,548.99-- Capital Outla82,000.0030,784.00 y 114,000 - -52,233.00 -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,900,183876,561.87 4,476,320.7017,040.78 5,084,428.91 343,071.74 8,489,723.13 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,000 1,750.79-37,605.31- 49,750.79- Maintenance Services303.28 - 334,500 - - - 37,908.59- TOTAL AVIATION HEIGHTS WTR IMP 400,000 -1,750.79 -401,750.79 FM3009 RD&BRIDGE EXPANSION Professional Services-- 30,358.80-1,977.50 (1,977.50)- Maintenance Services 37.74 71,088.87 - - - - 73,066.37 TOTAL FM3009 RD&BRIDGE EXPANSION - - -30,396.54 -(73,066.37) TOTAL MISC & PROJECTS68,305.1373,066.37 400,000 -1,750.79 -328,684.42 TOTAL EXPENDITURES14,931,543912,23120,1994,755,6655,356,284356,181 ** REVENUE OVER(UNDER)EXPENSES **1,280,014.60 641 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 52,218.4635,061.00 52,218.46 000-421490Tower Leasing180,000 - - TOTAL Franchises 180,000 52,218.46 35,061.00- 52,218.46 - 127,781.54 Fees 000-455200Garbage Collection Fee 3,400,000 308,078.21 1,314,567.29- 1,482,049.35 - 1,917,950.65 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 24,854.31 80,346.74- 108,828.47 - 132,171.53 000-455800W&S Line Constructn Reimbursemnt50,000 3,926.75 13,715.79- 12,558.83 - 37,441.17 000-457100Sale of Water 7,210,000 582,756.24 2,874,962.87- 3,227,236.52 - 3,982,763.48 000-457110Edwards Water Lease 166,250 26,785.25 132,707.46- 41,585.85 - 124,664.15 000-457120Water Transfer Charge-Selma 5,000 - - 1,339.20 13,657.95 - (8,657.95) 000-457130Water Transfer Charge-U. C. 1,000 - - 1.28 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 5,955.00 35,875.45- 23,009.00 - 66,991.00 000-457400Sewer Charges 2,800,000 290,637.23 1,078,014.63- 1,340,725.99 - 1,459,274.01 000-457500Water Penalties 180,000 12,658.85 71,849.20- 75,814.32 - 104,185.68 000-459200NSF Check Fee-Water&Sewer2,000120.00962.221,350.00 - - TOTAL Fees14,164,2501,255,771.84 5,622,772.13-6,348,706.25 - 7,815,543.75 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 7,056.1720,154.00 35,280.85 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 484,674 7,056.17 20,154.00- 35,280.85 - 449,393.15 Miscellaneous 000-490000Misc Charges 10,000 10.00 - 4,431.88 83.05 - 000-491000Interest Earned 1,000 146.13 - 1,066.50 831.76 - 000-491200Investment Income 6,000 590.81 - 6,343.21 6,124.26 - 000-493400Donations-Christmas Activitise - - 1,000.00 750.00 - - 000-496050SSLG - SAWS Reservation - - 134,500.00- - - (134,500.00) 000-497000Misc Income-W&S 215.84 - 654.63 32,104.50 - - (32,104.50) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 - 50,615.45- 25,699.30 - 50,615.70 000-498200W&S Project Reimbursement5,118.30 - - - - - TOTAL Miscellaneous 103,260 962.78 71,521.31- 200,092.87 - (96,832.87) TOTAL REVENUES14,932,1841,316,009.25 5,749,508.44- 6,636,298.43 - 8,295,885.57 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking149,262.46$ Cash in Investment Pools Lone Star Investment-Water&Sewer1,358,886.42 Lone Star Investment-W&S Customer Deposits293,920.33 Lone Star Investment-W&S Equip Replacement373,392.81 Lone Star Investment-W&S Veh Replacement544,451.34 Lone Star Investment-Water/SSLGC SAWS269,400.01 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $3,895,959.53 Total Cash in Bank & Investment Pools4,045,221.99$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 253,811.52 1,361,658.58- 1,270,727.22 2,818,205.78- Inter-Jurisdictional1,438,836 30,752.07 643,778.26- 692,549.52 - 746,286.48 Miscellaneous5,075.70-79,575.3455,525.98 256,000 - TOTAL REVENUES 289,639.29 - 2,085,012.18 2,018,802.72 - 3,764,966.28 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,586,891209,421.07 1,081,725.4468.001,056,357.40 1,530,590.6011.00 Supplies 20,274.13 13,149.22 114,614.94 144,729.97 38,327.70 324,039 Human Services - 580.00 - 800 - - City Support Services 10,902.09- 10,277.40 31,505 - - 21,227.60 Utility Services 513.30 10.41 31,534.88 38,381.44 74,113.9715.00 112,500 Operations Support 1,570.08 364.65 27,122.28 29,500.33 907.45 45,600 Staff Support 6,266.71 449.08 27,539.10 26,729.09 13,487.28 72,400 City Assistance 862.50 - 3,016.00 2,747.50 637.00 9,000 Professional Services 11,673.37 133.00 43,712.34 53,302.22 5,713.11 164,200 Fund Charges/Transfers2,084,785 (64,165.77) 474,724.18- 204,856.19 - 1,879,928.81 Maintenance Services 17,027.52 17,771.16- 23,235.52 5,760.00 37,700 Debt Service 69,799.33- 5,863.00 111,176 - - 105,313.00 Rental-Leasing - 836.33 - 20,000.00 20,000 - - Operating Equipment 4,543.50 820.75 6,074.82 40,923.01 901.61 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 207,986.41 14,995.11 1,909,952.89 1,636,903.07 65,760.15 4,025,927.89 5,713,596 TOTAL EXPENDITURE207,986.4114,995.111,909,952.891,636,903.07 S 5,713,596 65,760.15 ** REVENUE OVER(UNDER) EXPENSES 381,899.65 * 70,173 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 252,891.52 - 1,343,668.58 1,253,732.22 - 2,565,000.78 32.83% 000-456110Subscription Program Fees55,000 920.00 - 17,990.00 16,995.00 30.90% -38,005.00 000-456120EMT Class - Fees95,200 - - - - -95,200.00 000-459200Paramedic Class Fees 120,000 - - - - -120,000.00 000-459200NSF Check Fee -- - - - - - TOTAL Fees4,088,933253,811.52 1,361,658.58- 1,270,727.22 2,818,205.78- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.24 - 120,319.28 119,219.40 41.67% -166,906.60 000-474300Cibolo Support222,018 106,650.00- 111,049.96 - -110,968.04 000-475100Comal Co ESD #6 82,875 6,908.83 - 666.56 34,544.13 -48,330.87 000-475200Live Oak Support 148,125 74,062.50- 80,164.76 - -67,960.24 000-475300Universal City Support 226,168 102,206.26- 113,975.66 - -112,192.34 000-475400Selma Support 67,618 34,365.00- 33,821.70 - -33,796.30 000-475500Schertz Support 384,046 193,729.74- 192,093.82 - -191,952.18 000-475600Santa Clara Support 8,849 - 5,267.34 4,426.12 - -4,422.88 000-475800Marion Support13,0116,511.583,253.97 - - - TOTAL Inter-Jurisdictional1,438,836 30,752.07 643,778.26- 692,549.52 -746,286.48 Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 58.70 - 283.84 232.01 - - 000-493203Donations-EMS 6,000 120.00 - 1,100.00 595.00 -5,405.00 000-493204Donations-Dilworth Fund - - - 0.00% - - - 000-493205Donations- Golf Tournament - - - 0.00% - - - 000-497000Misc Income 150,000 4,897.00 35,301.50- 29,907.97 -120,092.03 000-497100Recovery of Bad Debt 100,000 - 7,230.00 890.00 - -99,110.00 000-497500Misc Income-EMT Classes35,660.0023,901.00 - - - - TOTAL Miscellaneous256,0005,075.70 79,575.34-55,525.98 -200,474.02 TOTAL REVENUES5,783,769289,639.29 2,085,012.18- 2,018,802.72 3,764,966.28- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank $ (520,042.01) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010300,979.74 $(219,062.27) Total Cash in Bank & Investment Pools 27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60068,937.10 285,720.93- 322,836.80 -386,763.20 Fund Transfers - - - - - - - 0.00% Miscellaneous900547.53370.58 69.82 - - TOTAL REVENUES 69,006.92710,500286,268.46 -323,207.38387,292.62 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 374,40426,785.83 145,978.25- 133,529.05 -240,874.95 Supplies 8,300 91.96 - 469.24 641.06 241.59 Human Services 325 - - - - -325.00 City Support Services 32,563 - 4,332.18 1,508.72 - -31,054.28 Utility Services 14,688 - 4,235.98 6,391.62 624.50 - Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 466.83 43.02 1,281.14 1,082.77 7,203.1562.10 City Assistance 840 - 15.00 57.00 - -783.00 Professional Services 19,800 1,556.25 10,000.00- 6,806.25 -12,993.75 Fund Charges/Transfers 199,87611,785.92 32,662.25- 58,929.60 -140,946.40 Maintenance Services 22,000 - 1,987.00 - - -22,000.00 Other costs 100.00100 - 100.00 100.00 - - 100.00% Debt Service 17,564 - 1,918.78 1,632.07 15,931.93 - - Rental/Leasing500-- - - -500.00 Operating Equipment-- - - - - - TOTAL DRAINAGE 40,786.79701,72543.02202,979.82 928.19210,678.14490,161.69 TOTAL EXPENDITURE 40,786.79701,72543.02202,979.82 928.19210,678.14490,161.69 S ** REVENUE OVER(UNDER) EXPEND8,775112,529.24 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 1,820.90 2,133.24 4,000 362.07 -1,866.76 000-457600Drainage Fee 68,575.03-283,900.03320,703.56 -384,896.44 705,600 TOTAL Fees68,937.10 285,720.93-322,836.80 386,763.20- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 147.04 32.28 100 6.25 - 000-491200Investment Interest - 289.67 312.89 600 58.95 -287.11 000-497000Misc Income-Drainage-110.8225.41 200 4.62 - TOTAL Miscellaneous - 547.53 370.58 900 69.82 -529.42 TOTAL REVENUES69,006.92 286,268.46- 323,207.38 387,292.62- 710,500 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 171,107.03 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,393.53 Total Cash in Bank & Investment Pools$454,500.56 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 11,854.26 91,368.62- 99,964.59 -290,789.41 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50021.48-200.44106.10 - TOTAL REVENUES 11,875.74411,386-91,569.06100,070.69311,315.31 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 1,595.422,500 213.00 - 1,826.50 -886.50 City Support Services 85,948 29,616.85- 36,657.00 - -49,291.00 Operations Support 74,000 3,705.00 346.04 5,952.88 11,292.29 1,955.25 Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 193,876 11,885.50 42,555.25- 59,427.50 -134,448.50 Operating Equipment 52,562 999.60 6,645.00 15,809.58- -43,397.42 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 18,185.52411,3867,204.0478,124.98125,012.87291,621.92 L 1,955.25 TOTAL EXPENDITURE 18,185.52411,3867,204.0478,124.98125,012.87291,621.92 S 1,955.25 (24,942.18) REVENUE OVER(UNDER) EXPENDITURE - 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 11,854.2691,368.6299,964.59 -290,789.41 - TOTAL Taxes 390,754 11,854.26 91,368.62- 99,964.59 - 290,789.41 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned3007.99-137.2747.95 - 252.05 000-491200Investment Interest 200 13.49 - 63.17 58.15 - 141.85 000-497000Misc Income-- - - - - - TOTAL Miscellaneous50021.48-200.44106.10 - 393.90 TOTAL REVENUES 411,386 11,875.74 91,569.06- 100,070.69 - 311,315.31 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking198,391.45$ Cash in Investment Pools Federated Investment-Hotel/Motel78,184.19 Total Cash in Bank & Investment Pools$276,575.64 33 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 32,143 35,829 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 34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 - 52,575.00- - -197,425.00 Tree Mitigation Fees 75,000 - - 4,420.00 - -70,580.00 Miscellaneous600-324.37281.03 55.91 - TOTAL REVENUES 55.91325,600-324.3757,276.03268,323.97 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - - - -13,000.00 Maintenance Services-Landscape 3,500 - - - - -3,500.00 Operating Equipment 32,000 42,340.25- 5,872.2011,646.20 - Capital Outlay169,000 ---81,939.45 7,850.00 TOTAL PARKLAND DEDICATION -217,500-42,340.2587,811.65110,192.15 19,496.20 TREE MITIGATION Maintenance Services-Trees28,500 18,171.00- 758.00 1,380.00 26,362.00 7.50% 368.00 Capital Outlay18,000 ---19,900.00 - TOTAL TREE MITIGATION 368.0046,500-18,171.0020,658.00 1,380.00 TOTAL EXPENDITURE 368.00264,000-60,511.25108,469.65134,654.15 S 20,876.20 REVENUE OVER(UNDER) EXPEND (51,193.62)61,600 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 - 52,575.00- 197,425.00- - 000-458900Tree Mitigation -75,000- -4,420.00 - TOTAL Fees 325,000 - 56,995.00- 268,005.00- - Miscellaneous 000-491000Interest Earned 100 0.82 - 137.28 7.60 92.40- 000-491200Investment Interest 500 55.09 - 187.09 273.43 226.57- 000-497000Miscellaneous Income--- - - - TOTAL Miscellaneous60055.91-324.37281.03 318.97- TOTAL REVENUES 325,600 55.91 - 324.37 57,276.03 268,323.97- 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$21,356.95 Cash in Investment Pools Federated Investment-Park Fund192,864.97 Federated Investment-Tree Mitigation126,333.61 Total in Investment Pool 319,198.58 Total Cash in Bank & Investment Pools$340,555.53 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer -27,366--- - 27,366.00 TOTAL REVENUES -27,366--- - - EXPENDITURE SUMMARY NONDEPARTMENTAL Payable to Waste Contractor--- - - - - TOTAL NONDEPARTMENTA--- L - - - - TOTAL EXPENDITURE--- S - - - - REVENUE OVER(UNDER) EXPEND -27,366- 38 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S -27,366---27,366.00 - TOTAL Fund Transfers27,366--- - -27,366.00 TOTAL REVENUES 27,366 - - - - - 27,366 39 RECYCLE FUND CASH IN BANK AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking - Total Cash in Bank $ - 40 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 165,721.44 1,012,803.85- 610,520.52 -2,114,879.48 Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous314,000 730.2982,866.62226,359.28 - - TOTAL REVENUES13,713,000 166,451.731,095,670.47836,879.8012,876,120.20 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 646.11 - 1,410.78 2,061.77 -19,938.23 Maintenance Services 10,000 - - - - -10,000.00 Fund Charges/Transfers - - - - 0.00% - - Debt Service - - 108,671.00- - -(108,671.00) Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000 646.119,838.78110,841.27 L - - MISC & PROJECTS Projects13,025,000 35,663.25-63,983.3610,488.42 -13,050,174.83-0.19% Schaefer RD Water Improvements 599,643-- - - -599,643.00 Northcliffe Elevated Tnk-- 0.00% - - - - Northcliffe Water Plant-- 0.00% - - - - Town Creek Project-- 0.00% - - - - Live Oak Water Plant- 0.00% - - -204,531.74 - Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP307,269.43- A - - - - TOTAL MISC & PROJECTS13,624,643 -35,663.25575,784.5310,488.4213,649,817.83 - TOTAL EXPENDITURE13,662,643 646.1135,663.25585,623.31121,329.6913,576,976.56 S - REVENUE OVER(UNDER) EXPENDITURES50,357 715,550 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600109,620.00 667,651.34- 422,259.00 -1,057,341.00 000-455910Capital Recovery - Waste Wtr613,800 43,501.44 344,552.51- 168,461.52 -445,338.48 - - - 0.00% 000-455911Capital Recovery-Wste Wtr Zone 1 - - - 000-455913Cap Recovery-North Sewer Tr632,000 12,600.00600.0019,800.00 - - TOTAL Fees 2,725,400165,721.44 1,012,803.85- 610,520.52 -2,114,879.48 Fund Transfers 000-481000Transfer from Reserves10,673,600 - - - - 0.00% -10,673,600.00 000-486202Transfer in-Water -- - - - - -- 000-486406Transfer in-Public Improvement - - - - TOTAL Fund Transfers10,673,600---- 0.00% -10,673,600.00 Miscellaneous 000-491000Interest Earned50028.91-241.22117.34 - 000-491200Investment Income 30,000 4,704.44 15,382.65- 20,239.47 -9,760.53 000-491800Gain/Loss - - (554.28) - 214.50 - 000-491900Unrealized Gain/Loss-Cap One (16,132.25)- (13,443.25) - (4,217.56) -13,443.25 000-497000Misc Income - - - 0.00% - - - 000-498000Reimbursmnt - - 220,000.00- - -(220,000.00) 000-498100Reimbursmnt - FM 78 Project 12,500.00- - 0.00% - - - 000-498200Re-imbursement-Water Meters283,500 -70,875.00- - - TOTAL Miscellaneous 314,000 730.29 82,866.62- 226,359.28 -87,640.72 TOTAL REVENUES13,713,000166,451.73 1,095,670.47- 836,879.80 6.10% -12,876,120.20 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking733,265.93$ Cash in Investments: Lone Star Investment-Capital Recovery Water1,153,185.85 Lone Star Investment-Capital Recovery Sewer280,671.97 Capital One-Investment1,711,647.30 Schertz Bank & Trust-Certificate of Deposit- Total Cash in Bank & Investment Pools$3,878,771.05 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 397,977.134,281,098 - 3,246,480.30 4,176,855.40 97.57% -104,242.60 - - - - 0.00% Fund Transfers - - Miscellaneous 1,927.802,25014,892.6910,091.60 - - TOTAL REVENUES 399,904.934,283,3483,261,372.99 -4,186,947.00 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL - - 36,210.39- Professional Services - -(36,210.39) Debt Service 1,159,410.634,276,6672,558,340.59 -3,074,924.521,165,531.59 - TOTAL GENERAL GOVERNMEN 1,159,410.634,276,6672,558,340.59 -3,111,134.911,165,531.59 T - TOTAL EXPENDITURE 1,159,410.634,276,6672,558,340.59 -3,111,134.911,165,531.59 S - ** REVENUE OVER(UNDER) EXPEND6,682 1,075,812.09 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 397,977.133,246,480.304,176,855.40 - - TOTAL Taxes4,281,098397,977.13 3,246,480.30-4,176,855.40 - 104,242.60 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 - 14,409.41- 27.87 - 000-491200Investment Earnings1,5001,927.80483.28 10,063.73 - - TOTAL Miscellaneous 2,250 1,927.80 14,892.69- 10,091.60 - (7,841.60) TOTAL REVENUES4,283,348 399,904.93 3,261,372.99- 4,186,947.00 - 96,401.00 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent -400.00 - - - - 35,810.39- 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services---36,210 - -(36,210.39) Debt Service 101-555612Bond-GO Refunding 2010-Principal 240,000.00240,000 - 285,000.00 240,000.00 - 101-555612.1Bond-GO Refunding 2010 Interest82,650 42,525.00 37,977.08- 42,525.00 -40,125.00 101-555622Schertz C O SR2003-Principal200,000 200,000.00 190,000.00- 200,000.00 - 101-555622.1Schertz C O SR2003-Interest 53,800 7,432.50 32,120.00- 7,432.50 -46,367.50 101-555624Comm Proj Bond-SR04-Principal315,000 315,000.00 325,000.00- 315,000.00 - 101-555624.1Comm Proj Bond SR04-Interest251,009 13,796.88 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 200,000.00 140,000.00- 200,000.00 - 101-555631.1BO Bond SR2009 Interest 278,813140,656.25140,656.25 -142,406.25 -138,156.25 101-555633GO SR2011 Principal 532,287 90,000.00- - - -442,287.00 101-555633.1GO SR2011 Interest90,000 346,167.71- - - -(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,6671,159,410.63 2,558,340.59-3,074,924.52 -1,201,741.98 TOTAL EXPENDITURES4,276,6671,159,410.63 2,558,340.59- 3,111,134.91 -1,165,531.59 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking24,957.06$ Cash in Investment Pools MBIA Investment- Tax I&S1,142,110.50 Federated Investment-Tax I&S56.84 Total Cash in Bank & Investment Pools$1,167,124.40 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2011 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET41.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042145,249.55 589,336.01- 933,347.60 - 1,458,694.40 Fund Transfers - - - 0.00% - - - Miscellaneous 1,213.4717,2004,649.47 -2,123.81 - ,,,.,. -,., TOTALREVENUES24092421464630259398548935471411473 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 21,000 2,158.19 579.81 10,142.72 13,328.13 3,475.54 Utility Service 87,500 6,988.84 22,322.66- 28,031.19 59,459.359.46 Maintenance Services 72,300 2,115.97 632.25 29,672.56 25,488.69 7,596.92 Operating Equipment - 6,999.31 - 0.00% - - - Capital Outlay --- - - - TOTAL NONDEPARTMENTA 11,263.00180,8001,212.0669,137.25 11,081.9266,848.01104,082.13 L ECONOMIC DEVELOPMEN T Personnel Services 241,233 14,293.72 57,644.66- 79,488.91 - 161,744.09 Supplies 1,100 37.37 - 509.32 267.92 125.09 Human Services 200 - - 111.00- 55.50% - City Support Services 42,772 8,994.12 7,698.29 332.06 -1,363.42 Utility Services 7,200 - 1,003.72 590.91 - - 6,609.09 Operations Support 63,600 389.21 4,813.35 37,918.90 10,538.26 259.21 Staff Support 112,800 691.69 937.31 62,040.06 60,296.71 3,685.10 49,755.50 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 12,163.75 30,935.60 96,245.72 60,126.50 - 274,309.10 Fund Charges/Transfers 105,985 4,665.42 63,858.00- 23,327.10 - 82,657.90 Fund Replenish-Fund Balance - - - 0.00% - - - Maintenance Services - - - 0.00% - - - Debt Service 795,154337,818.75 606,911.25- 613,014.50 182,139.50 - Operating Equipment -2,350-- - - TOTAL ECONO DEVELOPMEN 370,059.911,975,89438,049.68935,125.75 4,512.46865,349.101,144,082.12 T TOTAL EXPENDITURE 381,322.912,156,69439,261.741,004,263.00 15,594.38932,197.111,248,164.25 S ** REVENUE OVER(UNDER) EXPEND252,548 3,274.30 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 29th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET41.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042145,249.55589,336.01933,347.60 - - TOTAL Taxes2,392,042145,249.55 589,336.01- 933,347.60 -1,458,694.40 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 6.94 - 37.59 85.67 - 000-491200Investment Earnings 15,000 252.78 - 4,258.08 3,274.21 -11,725.79 000-497000Misc Income 2,000 953.75 - 353.80 (1,236.07) -3,236.07 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 1,213.47 - 4,649.47 2,123.81 - TOTAL REVENUES2,409,242146,463.02 593,985.48-935,471.41 -1,473,770.59 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 29th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking165,797.01$ Cash in Investment Pools MBIA Investment-Economic Development Corp1,366,703.32 Schertz Bank & Trust-Certificate of Deposit507,004.98 Schertz Bank & Trust-Certificate of Deposit1,035,475.46 Total Cash in Bank & Investment Pools3,074,980.77$ 50 4B SALES TAX $300,000 40% $250,000 -2% 17% 25% -2% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 207,911 230,700 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 51 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING FEBRUARY 29th, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust3,003,816.63,151,224.79.0500,314,896.34,462,304.50,003,816.63,003,816.63 405633 TOTAL OPERATIONS3,003,816.63,151,224.79,314,896.34,462,304.50,003,816.63,003,816.63 45633 LOGIC General Fund4,608,068.00,807,092.25.2860 -00,975.75,608,068.00 N/A,608,068.00 30844 G/F-Equipment Replacement73,363.9973,347.320.2860 -16.6773,363.99 N/A73,363.99 G/F-Vehicle Replacement7,081.16,079.55.2860 -.61,081.16 N/A,081.16 70177 G/F-Air Conditioner Replacement146,477.35146,444.080.2860 -33.27146,477.35 N/A146,477.35 ,792,343.12.286007.24-,792,750.36,792,750.36 SR2009 Bond-Street Projects(II)1,792,750.36 10411 TOTAL LOGIC6,627,740.86,826,306.32 -01,434.54,627,740.86,627,740.86 5866 LONESTA R Capital Recovery - Sewer280,671.97280,613.580.2600 -58.39280,671.97 N/A280,671.97 Capital Recovery - Water1,153,185.8552,977.23.2600 -00,208.62,153,185.85 N/A,153,185.85 40711 Drainage Fund283,393.53283,334.580.2600 -58.95283,393.53 N/A283,393.53 GO SR2011 Animal Shelter2,234,527.24,252,022.93.260068.467,964.15,234,527.24 N/A,234,527.24 204122 GO SR2011 Athletic Fields1,481,208.431,480,900.290.2600 -308.141,481,208.43 N/A1,481,208.43 GO SR2011 Soccer Fields1,440,550.55,441,330.65.260099.90,080.00,440,550.55 N/A,440,550.55 102111 GO SR2011 Swimming Pool2,938,607.072,937,995.750.2600 -611.322,938,607.07 N/A2,938,607.07 W/S-Customer Deposits293,920.3393,859.19.2600 -1.1493,920.33 N/A93,920.33 20622 W/S-Equipment Repl/Cap.Imp373,392.81373,315.130.2600 -77.68373,392.81 N/A373,392.81 Water&Sewer1,358,886.42,358,603.73.2600 -82.69,358,886.42 N/A,358,886.42 10211 W/S-Vehicle Replacement544,451.34544,338.080.2600 -113.26544,451.34 N/A544,451.34 69,343.97.26006.04-69,400.0169,400.01 Water/SSLG - SAWS269,400.01 20522 TOTAL LONESTA12,652,195.551,968,635.1102,604.599,044.152,652,195.552,652,195.55 R17111 MBIA Tax I&S1,142,110.501,237,870.530.2500239.9796,000.001,142,110.50 N/A1,142,110.50 Police Forfeiture359,392.1159,322.02.2500 -0.0959,392.11 N/A59,392.11 30733 Economic Development Corporation1,366,703.321,266,450.540.2500 -100,252.781,366,703.32 N/A1,366,703.32 Special Events Fund66,606.136,593.19.2500 -2.946,606.13 N/A6,606.13 60166 EMS Tax Notes 2010300,979.7400,921.04.25008.70-00,979.7400,979.74 30533 TOTAL MBIA3,235,791.803,231,157.32100,634.4896,000.003,235,791.803,235,791.80 FEDERATED SR2007a Bond-City Wide Projects868,363.9568,214.08.2200 -49.8768,363.95 N/A68,363.95 80188 Hotel Occupancy Tax78,184.1978,170.700.2200 -13.4978,184.19 N/A78,184.19 Park Fund (Developers Fee)192,864.9792,831.68.2200 -3.2992,864.97 N/A92,864.97 10311 Park Fund (Tree Mitigation)126,333.61126,311.810.2200 -21.80126,333.61 N/A126,333.61 Tax I&S56.846.83.2200 -.016.84 N/A6.84 50055 Library Board Fund44,713.874,706.15.2200.72-4,713.874,713.87 40744 TOTAL FEDERATED1,310,517.431,310,291.25 -226.181,310,517.431,310,517.43 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,250,466.82,322,314.43.2400 349.96,330.50,326,294.97 N/A,335,566.21 13411 Capital One Capital Recovery1,610,345.20,729,347.19.0800,920.63433.77,733,834.05,711,647.30 13411 TOTAL CAPITAL ONE2,860,812.023,051,661.62 783.739,251.133,060,129.023,047,213.51 52 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS 8% TOTAL CAPITAL ONE 9% 9% TOTAL FEDERATED TOTAL LOGIC 4% 21% TOTAL MBIA 10% TOTAL LONESTAR 39% 54 City Portfolio By Use Pooled-Daily Operations, $3,003,816.63 Designated Funds, $10,124,316.58 $11,025,407.61 Special Revenue Funds, Debt Service Fund, $6,993,555.19 $1,142,167.34 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.0800 1 Month T-Bill 0.01000.01000.02000.06000.0800 3 Month T-Bill 0.06000.06000.06000.08000.1300 6 Month T-Bill 0.46000.52000.49000.50000.5200 Schertz Portfolio 0.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.4000 CD 365 Days 0.80000.80000.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.2860 LOGIC 0.23000.25000.28000.31000.2600 LoneStar 0.14000.15000.19000.21000.2500 MBIA 0.09000.14000.13000.15000.2200 Federated 2.32432.84002.83003.07003.0700 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:2/29/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69120,466.8220,466.8220,466.822.000.01 General Elec Cap Corp Disc Com Paper3/12/201212.0065,000.0064,891.2264,891.220.000.00 JPMorgan Chase Disc Bank Accpt Note3/1/20121.0065,000.0064,941.4564,941.45 Total Cash & Equivalent50,466.8150,299.450,299.4 s12919 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014896.00125,000.00141,987.30140,280.006,875.00 Federal Home Loan Bks Cons Bds6/21/2013478.0080,000.0082,004.4081,686.401,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151386.00100,000.00116,185.00114,531.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012231.00150,000.00162,031.50154,081.506,750.00 Federal Home Ln Mtg Corp Deb11/15/2013625.00170,000.00191,084.25183,311.008,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013573.00250,000.00250,000.00265,812.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141000.00100,000.0099,874.40100,996.00750.00 Federal Natl Mtg Assn 7/28/20151245.00125,000.00132,828.63132,560.00 Total Fixed Income1,100,000.001,175,995.481,173,258.404 Total Assets673.791,250,466.821,326,294.971,323,557.894 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #69120,345.2020,345.2020,345.202.000.01 General Elec Cap Corp Disc Coml Paper3/12/201212.0085,000.0084,857.7484,857.740.000.00 84,923.4384,923.43 JPMorgan Chase Disc Bank Accpt Note3/1/20121.0085,000.00 Total Cash & Equivalent90,345.2190,126.390,126.3 s10717 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014896.00165,000.00187,423.24185,169.609,075.00 Federal Home Loan Bks Cons Bds6/21/2013478.00100,000.00102,505.50102,108.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151386.00100,000.00116,185.00114,531.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012231.00250,000.00270,052.50256,802.5011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013625.00250,000.00281,006.25269,575.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013594.00200,000.00223,001.60213,928.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141000.00220,000.00220,078.68222,191.201,650.00 /28/2015245.0035,000.00143,454.9143,164.80 Federal Natl Mtg Ass n7111 Total Fixed Incom,420,000.01,543,707.6,507,470.1 e108105 Total Assets662.241,610,345.201,733,834.051,697,596.475