Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01-OCTOBER 2011 FINANCIAL STATEMENT
C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,7251,983,572.05 1,419,623.91-1,983,572.05 9,820,152.95- Franchises1,617,000 - - 8,228.02 - -1,617,000.00 Permits1,187,800 80,626.00 452,957.83- 80,626.00 -1,107,174.00 Licenses 31,300 1,565.00 - 1,640.10 1,565.00 -29,735.00 Fees3,341,727 156,623.82 399,748.87- 156,623.82 3,185,141.06(37.88) Fines 30,000 2,346.04 - 1,960.33 2,346.04 -27,653.96 Inter-Jurisdictional 571,245 26,484.21 54,582.27- 26,484.21 -544,760.79 Fund Transfers1,760,658 - - - - -1,760,658.00 Miscellaneous65,361.5453,473.7165,361.54(1.00) 615,500 - TOTAL REVENUES20,958,9552,316,578.662,392,215.042,316,578.66(38.88) - - EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,800 1,481.26 - 1,771.04 1,481.26 -21,318.74 Supplies500 - - - - 103.98 396.02 City Support Services20,500 269.98 219.98 - 269.98 172.73 20,277.27 - - - - Utility Services - - Operations Support 300 - - - - - Staff Support17,4002,800.011,950.00 380.002,800.01 5,104.02 -- Operating Equipment - - - - TOTAL CITY COUNCIL 4,551.2561,500 2,169.98 2,151.04 4,551.25 5,380.73 53,738.00 CITY MANAGER Personnel Services 749,726 45,733.92 45,455.91- 45,733.92 -703,992.08 Supplies 2,500 126.88 126.88 - 126.88 67.45 City Support Services - - - - - - Operations Support - - - - - - Staff Support 25,550 1,098.75 1,044.26 60.00 1,098.75 4,372.99 Operating Equipment -- - - - - TOTAL CITY MANAGER777,77646,959.551,171.1445,515.9146,959.554,440.44 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services 254,333 15,391.29 15,761.10- 15,391.29 -238,941.71 Supplies 2,500 99.00 99.00 387.05 99.00 76.19 City Support Services 1,000 - - - - - Operations Support 3,000 - - - - - Staff Support 5,500 385.20 285.20 33.44 385.20 55.61 Court Support 800 - - - - - Professional Services 71,100 4,882.50 - 3,228.75 4,882.5028,052.50 Maintenance Services 2,200 - - - - - -250.00 Operating Equipment1,000 - - - TOTAL MUNICIPAL COURT 341,433 20,757.99 384.20 19,660.34 20,757.9928,184.30 CUSTOMER RELATIONS-311 Personnel Services 108,506 5,089.28 - 5,267.39 5,089.28 -103,416.72 Supplies 300 - - - - - Staff Support1,100 -- - - - Operating Equipment500 -- - - - TOTAL CUSTOMER RELATIONS-311 110,406 5,089.28 - 5,267.39 5,089.28 -105,316.72 PLANNING & ZONING Personnel Services 216,383 8,169.56 - 8,315.44 8,169.56 -208,213.44 Supplies 2,700 156.45 156.45 - 156.45 4.34 Operations Support 750 - - - - - Staff Support 17,150 300.00 - 26.94 300.00 443.58 Professional Services 76,650 - - - - -76,650.00 -- Operating Equipment3,500 - - - TOTAL PLANNING & ZONING 317,133 8,626.01 156.45 8,342.38 8,626.01 447.92 LEGAL SERVICES Operations Support 13,000 - - - - -13,000.00 Professional Services -- 245,000 - - - TOTAL LEGAL SERVICES258,000 -- - - -258,000.00 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services 642,762 31,290.44 38,096.83- 31,290.44 -611,471.56 Supplies 57,100 1,574.19 743.00 1,325.73 1,574.19 5,427.54 Utility Services 111,000 - - 5,000.87 364.58- Operations Support - - - - - - Staff Support 10,179 108.24 - 1,424.40 108.24 385.00 Maintenance Services 107,450 673.05 273.05 37,262.76 673.05 7,248.92 Rental/Leasing 1,400 - - - - - Operating Equipment2,500 -- - - - -- Capital Outlay - - - 24,500 TOTAL FACILITIES MAINTENANCE 956,891 33,645.92 1,016.05 83,110.59 33,645.9213,426.04 CITY SECRETARY Personnel Services 163,417 9,811.60 10,594.72- 9,811.60 -153,605.40 Supplies 1,250 - - 22.60 - 76.92 City Support Services 9,780 - - - - - Staff Support8,605 -590.44684.40 - - TOTAL CITY SECRETARY 183,052 9,811.60 11,207.76- 9,811.60 761.32 NON-DEPARTMENTA L Supplies 2,500 - - - - 10.71 City Support Services 670,358 5,325.00 59,848.47- 5,325.00 -665,033.00 Operations Support 139,000 7,965.91 31.05 7,808.29 7,965.91 -131,065.14 Staff Support - - - - - - City Assistance 459,046 96,046.91 96,864.87- 96,046.91 -362,999.09 Professional Services 157,150 2,410.57 - 2,688.78 2,410.57 -154,739.43 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - -10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL1,438,904 111,748.39 31.05 167,210.41 111,748.39 1,327,175.9510.71 PUBLIC AFFAIR S Personnel Services 214,010 12,939.87 10,676.57- 12,939.87 -201,070.13 Supplies 2,900 57.81 - - 57.81 117.83 Operations Support 35,100 - - 79.86 962.02- Staff Support 4,350 196.44 196.44 105.08 196.44 524.10 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Operating Equipment300 -- - - - TOTAL PUBLIC AFFAIRS 13,194.12256,660 196.44 10,861.51 13,194.12 1,603.95 242,058.37 RECORDS MANAGEMEN T Personnel Services 47,294 2,858.77 - 2,936.99 2,858.77 -44,435.23 Supplies 750 - - - - - Staff Support 1,500 - - 85.00 - - Professional Services 15,000 - - 286.00 - -15,000.00 Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 64,544 2,858.77 - 3,307.99 2,858.77 -61,685.23 SCHERTZ TALES MAGAZIN E Personnel Services 128,605 8,077.96 - 6,995.53 8,077.96 -120,527.04 Supplies 200 - - - - - Opperations Support 2,767.08200 - - 2,767.08 -(2,567.08) Staff Support 1,500 - - - 104.14- Professional Services9,802.86 9,802.862,865.44 302,700 - 20,186.86 TOTAL SCHERTZ TALES MAGAZINE 433,205 20,647.90 - 9,860.97 20,647.9020,291.00 ENGINEERING Personnel Services 173,069 6,031.69 10,215.99- 6,031.69 -167,037.31 Supplies 400 - - 59.00 - 33.19 City Support Services - - - - - - Utility Services 600 - - - - - Staff Support 2,213 - - 265.00 - - Professional Services 39,000 1,425.00 - - 1,425.00 -37,575.00 Maintenance Services 4,044 - - 2,145.29 3,345.29- Operating Equipment -- - - - - Capital Outlay -- 26,000 - - 21,447.00 TOTAL ENGINEERING 245,326 7,456.69 12,685.28- 7,456.6924,825.48 GIS Personnel Services 120,967 7,299.12 - 7,453.95 7,299.12 -113,667.88 Supplies 3,500 - - - - - Staff Support 4,050 - - - - - -- Professional Services2,000 - - - TOTAL GIS 130,517 7,299.12 - 7,453.95 7,299.12 -123,217.88 TOTAL GENERAL GOVERNMENT5,575,347 292,646.59 5,125.31 386,635.52 292,646.5999,371.89 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC SAFETY POLICE Personnel Services4,509,076 266,138.82 - 253,864.84 266,138.82 -4,242,937.18 Supplies39,337 1,661.01 1,573.42 100.48 1,661.01 680.24 38,569.17 City Support Services35,000 - - - - -35,000.00 Utility Services123,456 - - 6,788.53 - -123,456.00 Operations Support1,500 - - - - 720.00 780.00 Staff Support58,372 2,515.60 1,672.59 - 2,515.60 350.00 57,178.99 City Assistance10,914 - - 100.00 - -10,914.00 Professional Services20,000 - - - - -20,000.00 Maintenance Services44,435 - - 1,958.50 - 5,540.00 38,895.00 Operating Equipment47,532 1,855.85 1,855.85 5,196.00 1,855.85 6,723.99 40,808.01 12,554.8012,554.80 12,554.80-142,521.25 Capital Outlay 145,500 TOTAL POLICE 5,035,122284,726.0817,656.66268,008.35284,726.08156,535.48 FIRE RESCUE Personnel Services2,495,242 149,147.62 147,463.39- 149,147.62 -2,346,094.38 Supplies 20,500 9,239.99 9,239.99 20.15 9,239.99 183.06 Utility Services 57,000 7.64 7.64 2,345.27 594.007.64 Operations Support 800 - - - - - Staff Support 120,185 22,703.10 17,875.59 7,198.55 22,703.10 9,623.77 City Assistance 18,600 2,758.50 2,758.50 10,323.17 2,758.50 104.92 Professional Services 18,140 - - - - -18,140.00 Maintenance Services 56,000 3,565.81 3,560.01 - 3,565.81 -55,994.20 Operating Equipment1,987.298,627.74 718.931,987.29 58,300 - -- Capital Outlay - - 31,116.00 35,000 TOTAL FIRE 2,879,767 189,409.95 42,069.47 168,069.46 189,409.9541,621.75 INSPECTIONS Personnel Services 417,182 24,657.57 22,910.47- 24,657.57 -392,524.43 Supplies 2,500 55.68 - - 55.68 103.19 Utility Services 6,500 - - 671.94 - - Operations Support 1,500 - - - - - Staff Support 8,000 551.76 168.56 521.89 551.76 241.13 Professional Services 10,000 - - - - -10,000.00 -- Operating Equipment1,000 - - - TOTAL INSPECTIONS 446,682 25,265.01 168.56 24,104.30 25,265.01 344.32 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MARSHAL SERVICE Personnel Services 529,908 31,639.64 23,287.69- 31,639.64 -498,268.36 Supplies 4,600 205.82 205.82 - 205.82 213.99 Utility Services 12,000 - - 487.92 - -12,000.00 Operations Support 4,000 - - - 1,081.41- Staff Support 15,400 2,257.08 410.00 439.57 2,257.08 43.70 Professional Services - - - - - - Maintenance Services 30,700 - - 112.00 - -30,700.00 Operating Equipment4,602.172,206.37 2,324.044,602.17814.20 16,000 -- Capital Outlay - - 25,545.00 34,000 TOTAL MARSHAL SERVICE 646,608 38,704.71 2,822.19 26,651.22 38,704.7127,698.30 TOTAL PUBLIC SAFETY9,008,179 538,105.75 62,716.88 486,833.33 538,105.75226,199.85 PUBLIC ENVIRONMENT STREETS Personnel Services674,240 40,461.97 - 34,425.64 40,461.97 -633,778.03 Supplies7,100 21.04 21.04 66.77 21.04 732.22 6,367.78 Utility Services113,900 4,380.56 - 8,523.27 4,380.56 569.92 108,949.52 - - - - Operations Support - - Staff Support 10,265 172.17 58.21 84.04 172.17 479.80 Maintenance Services 268,400 930.75 164.79 15,833.63 15,415.74930.75 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - - 3,166.95- Capital Outlay -- - - - - TOTAL STREETS 1,078,30545,966.49244.0458,933.3545,966.4920,364.63 TOTAL PUBLIC ENVIRONMENT1,078,305 45,966.49 244.04 58,933.35 45,966.4920,364.63 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PARKS & RECREATION PARKS DEPARTMENT Personnel Services503,534 28,794.84 - 28,167.95 28,794.84 -474,739.16 Supplies40,555 734.91 472.04 3,499.64 734.91 7,548.07 32,744.06 Utility Services113,300 0.20 - 5,722.87 0.20 133.50 113,166.30 Operations Support700 - - 600.00 - - Staff Support 8,573 60.93 60.93 1,038.50 1,901.6460.93 Professional Services 62,610 3,571.50 - - 3,571.50 -59,038.50 Maintenance Services 22,000 44.99 44.99 - 4,300.0144.99 Rental/Leasing 42,200 - - 3,360.96 - -42,200.00 Operating Equipment - - - - - - -- Capital Outlay - - - - TOTAL PARKS DEPARTMENT 793,472 33,207.37 577.96 42,389.92 33,207.3713,883.22 SWIM POOL Supplies 16,700 - - 53.39 123.65- Utility Services 25,500 - - 882.37 - -25,500.00 Staff Support 925 750.00 - - 750.00 - Maintenance Services 199,378 4,000.00 4,000.00 - 4,000.00 -199,378.00 -- Rental/Lease500 - - - TOTAL SWIM POOL 4,750.00243,003 4,000.00 935.76 4,750.00 123.65 242,129.35 COMMUNITY/CIVIC CENTER Personnel Services106,9773,027.36-5,130.863,027.36504.00 Supplies 7,300 1,127.61 1,127.61 1,293.27 1,127.61 235.19 Utility Services 47,550 4.65 - 2,423.57 4.65 -47,545.35 Operations Support 15,200 - - 95.00 382.61- Staff Support 3,300 439.45 439.45 - 439.45 35.00 Professional Services 1,600 150.00 150.00 - 150.00 - 398.88398.88 398.88- Operating Equipment5,000 - TOTAL COMMUNITY/CIVIC CNTR 186,927 5,147.95 2,115.94 8,942.70 5,147.95 1,156.80 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET TOTAL PARKS & RECREATION1,223,40243,105.326,693.9052,268.3843,105.3215,163.67 CULTURAL LIBRARY Personnel Services686,05042,882.17 41,633.87-42,882.17 -643,167.83 Supplies 14,000 136.54 86.59 - 136.54 186.42 Utility Services 41,000 - - 2,773.82 - -41,000.00 Operations Support 2,000 174.00 174.00 - 174.00 - Staff Support 4,215 104.32 58.97 18.92 104.32 - Professional Services 2,100 - - - - - Maintenance Services 2,400 400.00 - - 400.00 - Operating Equipment 75,000 188.08 175.10 272.36 11,014.61188.08 Capital Outlay -- - - - - TOTAL LIBRARY 826,765 43,885.11 494.66 44,698.97 43,885.1111,201.03 TOTAL CULTURAL 826,765 43,885.11 494.66 44,698.97 43,885.1111,201.03 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services 301,087 17,749.57 19,775.25- 17,749.57 -283,337.43 Supplies 25,000 319.99 319.99 42.00 319.99 1,370.74 Utility Services 11,200 - - 517.24 - -11,200.00 Operations Support 500 - - - - - Staff Support 5,800 655.48 34.48 - 655.48 1,060.00 City Assistance 10,000 - - - - -10,000.00 Professional Services 14,500 - - - - -14,500.00 Maintenance Services 6,200 2,340.00 - - 2,340.00 - Operating Equipment9,500723.93 -723.93159.95 - -- Capital Outlay - - - - TOTAL ANIMAL SERVICES 383,787 21,788.97 354.47 20,334.49 21,788.97 2,590.69 TOTAL HEALTH 383,787 21,788.97 354.47 20,334.49 21,788.97 2,590.69 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 257,808 16,557.52 14,521.03- 16,557.52 -241,250.48 Supplies 2,000 - - - - 58.04 City Support Services 372,354 450.00 22,287.17- 450.00 7,030.05 Utility Services 154,949 3,866.12 1,585.17 4,917.20 3,866.12 1,037.16 Staff Support 15,250 1,957.64 1,957.64 1,959.20 1,957.64 -15,250.00 Professional Services 2,500 - - - - - Maintenance Services 12,500 - - 4,054.75 - -12,500.00 Operating Equipment 129,315 3,207.62 1,638.41 129.00 3,207.62 2,690.61 Capital Outlay -- 213,500 - - - TOTAL INFORMATION TECHNOLOGY1,160,176 26,038.90 5,181.22 47,868.35 26,038.90 10,815.86 1,128,502.46 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services 295,638 12,923.08 11,282.60- 12,923.08 -282,714.92 Supplies 1,329 - - - - - Human Services 47,156 654.00 654.00 1,230.12 654.00 1,292.41 Operations Support 16,596 532.56 532.56 266.28 532.56 -16,596.02 Staff Support 14,897 550.72 550.72 3,473.00 550.72 5,692.69 City Assistance 9,860 - - - 435.00- Professional Services - - - - - - Operating Equipment390.03390.03 390.03- - - TOTAL HUMAN RESOURCES 15,050.39385,476 2,127.31 16,252.00 15,050.39 7,420.10 365,132.66 FINANCE Personnel Services428,074 27,357.38 - 26,420.88 27,357.38 -400,716.62 Supplies3,600 11.71 - 857.41 11.71 - Operations Support 850 - - 0.01 543.34- Staff Support 15,805 - - - 180.00- Maintenance Services 630 - - - - - 266.47266.47 266.47- Operating Equipment1,000 - TOTAL FINANCE 449,959 27,635.56 266.47 27,278.30 27,635.56 723.34 PURCHASING & ASSET MGT Personnel Services 240,272 14,494.09 14,827.64- 14,494.09 -225,777.91 Supplies 800 - - - - 18.12 Utility Services 750 - - - - - Operations Support 850 - - - - - Staff Support 9,450 65.00 65.00 - 65.00 256.80 Operating Equipment7,500 -- - - 7,500.00 TOTAL PURCHASING & ASSET MGT259,62214,559.0965.0014,827.6414,559.097,774.92 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,324 10,651.34 - 9,180.12 10,651.34 -206,672.66 Supplies109,600 2,972.15 2,509.56 4,808.97 2,972.15 21,228.03 87,909.38 City Support Services1,500 - - - - 1,500.00 - Utility Services7,200 - - 223.91 - - Operations Support 400 - - - - - Staff Support 3,835 637.81 613.73 295.80 637.81 48.30 Maintenance Services 65,750 1,583.76 1,583.76 1,564.28 1,583.76 2,528.22 Rental/Lease200 - 269.80- - - Operating Equipment5,000 -- - - - Capital Outlay -- - - - - TOTAL FLEET SERVICE 15,845.06410,809 4,707.05 16,073.08 15,845.06 25,574.35 374,096.64 TOTAL INTERNAL SERVICE2,666,042 99,129.00 12,347.05 122,299.37 99,129.00 52,308.57 2,526,951.32 MISC & PROJECTS CITY ASSISTANC E Utility Services---- - - Patient Assistance 5,000 - - - - - Children's Advocacy Assistance 5,000 - - - - - Senior Citizen's Hot Meals10,500.00- 42,000 - - 42,000.00 TOTAL CITY ASSISTANCE52,000- 10,500.00- 42,000.00- COURT - RESTRICTED FUND S Operating Equipment -- - - - - TOTAL CITY ASSISTANCE - - - - - - TOTAL MISC & PROJECTS 52,000 - - 10,500 42,000- TOTAL EXPENDITURES20,813,8271,084,627.23 87,976.311,182,503.411,084,627.23469,200.33 REVENUE OVER(UNDER) EXPEND.1,231,951.43 145,128 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,4541,540,041.13 1,406,160.47- 1,540,041.13 - 5,344,412.87 000-411200Advalorem Tax - Delinquent 50,000 5,571.51 - 3,694.70 5,571.51 - 44,428.49 000-411300Advalorem Tax - P&I 50,000 1,934.50 - 966.83 1,934.50 - 48,065.50 000-411500Sales Tax Revenue-Gen Fund4,784,071 428,994.84 - 428,994.84- - 4,355,076.16 000-411600Bingo Tax 2,200 - - - - - 000-411700Mixed Beverage Ta7,030.07 7,030.078,801.91 x 33,000.00 - - TOTAL Taxes11,803,7251,983,572.05 1,419,623.91- 1,983,572.05 - 9,820,152.95 Franchises 000-421200Center Point/Entex Energy 36,000 - - - - - 36,000.00 000-421220City Public Service 330,000 - - - - - 330,000.00 000-421240Guadalupe Valley Elec Co-op 440,000 - - - - - 440,000.00 000-421250New Braunfels Utilities 55,000 - - - - - 55,000.00 000-421300Time Warner-State Franchise 345,000 - - - - - 345,000.00 000-421350Time Warner-PEG Fee 65,000 - - - - - 65,000.00 000-421460AT&T Franchise Fee 185,000 - - - - - 185,000.00 000-421465AT&T PEG Fees 26,000 - - - - 26,000.00 000-421480Other Telecom Franchise 35,000 - - 103.08 - - 35,000.00 000-421500Solid Waste Franchise Fee100,000 -8,124.94 - - - TOTAL Franchises1,617,000--8,228.02- - 1,617,000.00 Permits 000-431100Home Occupation Permit 500 35.00 - - 35.00 - 000-431200Building Permit 418,616.83- 48,658.00 - 48,658.00 - (48,658.00) 000-431205Building Permit - Residential 600,000 - - - - - 600,000.00 000-431210Building Permit - Commercial 300,000 - - - - - 300,000.00 000-431300Mobile Home Permit 200 - - - - - 000-431400Signs Permit 1,700 140.00 - 50.00 140.00 - 000-431500Food Establishmnt Permit 30,000 7,325.00 - 7,445.00 7,325.00 - 22,675.00 000-431600Garage Sale Permit 8,600 1,290.00 - 1,490.00 1,290.00 - 000-431700Plumbing Permit 80,000 10,558.00 - 7,436.00 10,558.00 - 69,442.00 000-431750Electrical Permit 55,000 4,360.00 - 5,620.00 4,360.00 - 50,640.00 000-431800Mechanical Permit 59,000 4,860.00 - 6,380.00 4,860.00 - 54,140.00 000-431900Solicitor/Peddler Permit 120.00 - - 120.00 - - 000-431950Animal/Pet Permit 2,000 265.00 - 625.00 265.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800250.00-800.00250.00 - 000-432100Security Alarm Permit 42,000 2,090.00 - 3,370.00 2,090.00 - 39,910.00 000-435000Fire Permit5,000675.00 675.001,125.00 - - TOTAL Permits1,187,80080,626.00 452,957.83-80,626.00 - 1,107,174.00 Licenses 000-441000Alcohol Beverage License 6,300 90.00 - 30.00 90.00 - 000-442000Contractors License 22,000 1,175.00 - 1,150.00 1,175.00 - 20,825.00 000-444000Pet License3,000300.00 300.00460.10 - - TOTAL Licenses 31,300 1,565.00 - 1,640.10 1,565.00 - 29,735.00 Fees 000-451000Municipal Court Fines 1,665,009 74,075.55 104,765.10- 74,075.55 - 1,590,933.45 000-451100Arrest Fee 50,694 3,270.04 - 4,189.16 3,270.04 - 47,423.96 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 8,608.00 - 7,887.90 8,608.00 - 183,392.00 000-451320Civil Justice Fee-Court 75 4.96 6.84 4.96 - 000-451321Civil Justice Fee-State 45.06 - - 45.06 - - 000-451340Judicial Fee - City 6,826 433.95 - 546.23 433.95 - 000-451400Traffic Fine Costs TTL 25,984 1,668.67 - 2,191.68 1,668.67 - 24,315.33 000-451500Teen Court Admin Fee 260 100.00 - 60.00 100.00 - 000-451510Juvenile Case Mgmt Fee 55,896 3,625.93 - 4,551.99 3,625.93 - 52,270.07 000-451600Technology Fund Fee 45,601 2,954.84 - 3,621.27 2,954.84 - 42,646.16 000-451700Security Fee 34,220 2,216.16 - 2,715.93 2,216.16 - 32,003.84 000-451800Time Payment Fee - City 7,336 523.59 - 360.14 523.59 000-451850State Fines 10% Service Fee 72,470 - 19,298.66- - - 72,470.00 000-451900DPS Payment - Local 11,858 734.14 - 664.93 734.14 - 11,123.86 000-452000Child Safety Fee 12,243 2,933.98 - 1,201.10 2,933.98 - 000-452050Indigent Defense Fee 21,655 1,393.53 - 1,768.77 1,393.53 - 20,261.47 000-452100Platting Fees 98,000 1,500.00 - 3,000.00 1,500.00 - 96,500.00 000-452200Site Plan Fee 74,000 - - 2,000.00 - - 74,000.00 000-452300Plan Check Fee 465,000 25,897.50 209,342.41- 25,897.50 - 439,102.50 000-452310Miscellaneous Review Fee 13,500 - - - - - 13,500.00 000-452320Tree Mitigation Admin Fee 10,500 - - - - - 10,500.00 000-452400BOA/Zoning Fees 4,000 - - 700.00 - - 000-452500Food Handler Class 7,000 770.00 - 430.00 770.00 - 000-452520Fire Training Classes 400 - - - - - 000-452600Specific Use/Zone Chng Fee 20,000 2,850.00 -- 2,850.00 - 17,150.00 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452710Zoning Ltr & Dev Rights1,500150.00-75.00150.00 - 000-453100Reinspection Fees 30,000 4,475.00 - 4,325.00 4,475.00 - 25,525.00 000-453200Mowing Fees - Inspections 12,000 315.00 - 805.88 315.00 - 11,685.00 000-453211Admin Fee-Inspections 7,480 400.00 - 800.00 400.00 - 000-453310Misc Inspection Fee 19.49 - (20.00) 19.49 - 000-453500SubContractor Reg. Fee 17,000 815.00 - 810.00 815.00 - 16,185.00 000-453710Foster Care 500 150.00 - 150.00 150.00 - 000-454100Swim Pool Reservation Fee 55.00 - 55.00 - - 000-454200Pool Gate Admission Fee 25,000 - - - - - 25,000.00 000-454300Seasonal Pool Pass Fee 5,500 - - - - - 000-456500Haz Mat Fees 800 - - - - - 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 150.00 - 200.00 150.00 - 000-458100Sale of Merchandise - - (29.58) - - - 000-458300Sale of Property/Auction 22,000 1,280.18 - - 1,280.18 (37.88) 000-458400Civic Center Rental Fees 171,000 7,050.25 13,565.16- 7,050.25 - 163,949.75 000-458401Capital Recovery Fee-Civic Cntr 7,500 405.00 - 400.00 405.00 000-458450North Center Rental Fees 15,000 3,380.00 - 1,061.00 3,380.00 000-458500Community Center Rental Fees18,000 740.50 - 1,263.00 740.50 - 17,259.50 000-458550Pavilion Rental Fees 18,500 1,587.00 - 2,763.30 1,587.00 000-458560Chamber of Comm rent 11,700 - - - - - 11,700.00 000-458570Non-Resident SYSA League 12,000 - - - - - 12,000.00 000-458650NonResident User Fee-BVYA 11,000 - - - - - 11,000.00 000-458680Tournament Fees-Soccer 15,000 - - - - - 15,000.00 000-458700Vehicle Impoundment 5,000 - - - - - 000-459200NSF Check Fee 250 - - 158.00 - - 000-459300Notary Fee 300 6.00 - 24.00 6.00 - 000-459400Maps, Copies, UDC, & Misc F 400 - - - - - 000-459600Animal Adoption Fee 15,000 427.50 - 1,360.00 427.50 - 14,572.50 000-459700Pet Impoundment Fee 15,000 1,102.00 - 2,232.00 1,102.00 - 13,898.00 000-459800Police Reports Fee6,500510.00 510.00504.00 - - TOTAL Fees 3,341,727 156,623.82 399,748.87- 156,623.82 3,185,141.06(37.88) 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,346.04 2,346.041,960.33 - - TOTAL Fines 30,000 2,346.04 - 1,960.33 2,346.04 - 27,653.96 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 1,756.48 - 1,756.48 1,756.48 - 19,320.52 000-473200City of Seguin - Fire Contract 40,263 3,355.26 - 3,355.26 3,355.26 - 36,907.74 000-473300Guad Co - Library 180,000 15,901.33 15,068.00- 15,901.33 - 164,098.67 000-473400Randolph AFB-Animal Cntrl 1,000 - - 500.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- - - 133,305.00 000-474600School Crossing Guard-Bexar6,6002,726.46 576.282,726.46 - - 000-474610School Cross Guard-Guadalupe -2,744.68 -2,744.68 - - 000-474700School Officer Funding150,000 -- - - - TOTAL Inter-Jurisdictional 571,245 26,484.21 54,582.27- 26,484.21 - 544,760.79 Fund Transfers 000-480000Indirect Costs - EMS 87,840 - - - - - 87,840.00 000-480100Indirect Costs - Hotel/Motel 142,626 - - - - - 142,626.00 000-481000Transfer From Reserves 355,000 - - - - - 355,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 - - - - - 35,480.00 000-486000Interfund Chrges-Admin W&S 881,222 - - - - - 881,222.00 000-486317Transfer From Park Fund 13,000 - - - - - 13,000.00 000-487000Interfund Charges-Fleet 98,484 - - - - - 98,484.00 000-488000Interfund Charges-4B 53,000 - - - - - 53,000.00 000-490020Transfer In-SEDC50,000 -- - - - TOTAL Fund Transfers1,760,658---- - 1,760,658.00 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 - - 333.78 - - 000-491200Investment Income 30,000 2,916.47 - 2,003.25 2,916.47 - 27,083.53 000-491900Unrealized Gain/Loss - 2,048.29 (1,533.90) - (1,533.90) - 000-493000Donations-Others - - - - - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap. 114.00 13,011.00- 114.00 - - 000-493400Donation - Animal Control 1,200 55.02 - 900.00 55.02 - 000-493401Donations-A/C Microchip 500 100.00 - 270.00 100.00 - 000-493402Donations-Spay&Neuter 13,500 606.00 - 2,410.00 606.00 - 12,894.00 000-493503Donations - Fire Rescue - - - - - - 000-494481LawEnforcemtOfficersStnd&Ed - - - - - - 000-494482DOJ-PD GRANT - - - - - - 000-497000Misc Income-Gen Fund 81,000 99.37 - 2,601.27 99.37(1.00) 000-497005Misc Income-Publications 290,000 20,641.00 12,021.00- 20,641.00 - 269,359.00 000-497007Misc Income-Schertz Artz - - - - - - 000-497020Misc Income-Fleet Recycled - - - - - - 000-497100Misc Income-Police 25,000 468.90 - 1,439.05 468.90 - 24,531.10 000-497200Misc Income-Library 19,000 426.30 - 221.10 426.30 - 18,573.70 000-497210Misc Income-Library Copier 13,500 1,005.26 536.75 1,005.26 - 12,494.74 000-497300Misc Income-Animal Control 500 105.00 - 137.50 105.00 - 000-497400Misc Income-Streets Dept. 20,000 2,922.00 - 2,375.00 2,922.00 - 17,078.00 000-497500Misc Income-TML Insurance 78,000 - - - - - 78,000.00 000-497550Misc Income-TML Reimbursemt20,000 - - 4,804.12 - - 20,000.00 000-497600Misc Income-Parks/Vending Mach.2,500 232.10 - 250.53 232.10 - 000-498000Reimbursmnt-Gen Fund5,0007,908.00 33.007,908.00 - - 000-498100Reimbursmnt Fire - Training 800 - -- - - 000-498105Reimburmnt Police - DEA - - - - - - 000-498110Reimbursmnt Fire - Emg. Acti-O12,00029,296.02 29,296.028,078.07 - - TOTAL Miscellaneous 615,500 65,361.54 53,473.71- 65,361.54 550,139.46(1.00) TOTAL REVENUES20,958,9552,316,578.66 2,392,215.04-2,316,578.66 18,642,415.22(38.88) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking1,127,524.49$ Cash in Investment Pools LOGIC Investment-General Fund954,875.83 LOGIC Investment-Equip Replacement73,307.39 LOGIC Investment-Veh Replacement7,075.70 LOGIC Investment-Air Condi Replacment122,364.35 CAPITAL ONE Investment-General Fund1,334,449.06 Total Cash in Bank & Investment Pools$3,741,847.08 17 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 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 13% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 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 - - - - 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: OCTOBER 31st, 2011 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET8.33% 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 - - - - - 28,000.00 TML Dinner - - - - - - Hal Balwin Scholarship 24,000.00 - - - - - 24,000.00 Miscellaneous175.007.75- 7.7578.59 - TOTAL REVENUES114,275.00 7.75 - 78.59 7.75 - 114,267.25 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 - - 500.00- 13,750.00 - Employee Appreciation Event 5,000.00 - - - 4,950.0050.00 - 4th of July Jubilee - - - - - - National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 - - - - - 31,500.00 Blue Santa - - - - - - Schertz Fest - 455.91 - - - - TML Events - - - - - - Schertz Sweetheart 37,000.00 35.29 - 1,058.00 1,250.0035.29 Hal Baldwin Scholarship11,000.00- -- - -11,000.00 Selma-Schertz 5K- -- - - - TOTAL CULTURAL 35.29103,600.00 - 1,513.91 35.29 1,800.00 101,764.71 TOTAL EXPENDITURES108,750.00 35.29 - 1,513.91 35.29 1,800.00 106,914.71 REVENUE OVER(UNDER) EXPEND5,525.00(27.54) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking30,331.22$ Cash in Investment Pools MBIA Special Events66,562.49 Total Cash in Bank & Investment Pools$96,893.71 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET8.33% 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 - - - - - 28,000.00 TML Dinner - - - - - - Hal Balwin Scholarship 24,000.00 - - - - - 24,000.00 Miscellaneous175.007.75- 7.7578.59 - TOTAL REVENUES114,275.00 7.75 - 78.59 7.75 - 114,267.25 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 - - 500.00- 13,750.00 - Employee Appreciation Event 5,000.00 - - - 4,950.0050.00 - 4th of July Jubilee - - - - - - National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 - - - - - 31,500.00 Blue Santa - - - - - - Schertz Fest - 455.91 - - - - TML Events - - - - - - Schertz Sweetheart 37,000.00 35.29 - 1,058.00 1,250.0035.29 Hal Baldwin Scholarship11,000.00- -- - -11,000.00 Selma-Schertz 5K- -- - - - TOTAL CULTURAL 35.29103,600.00 - 1,513.91 35.29 1,800.00 101,764.71 TOTAL EXPENDITURES108,750.00 35.29 - 1,513.91 35.29 1,800.00 106,914.71 REVENUE OVER(UNDER) EXPEND5,525.00(27.54) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking30,331.22$ Cash in Investment Pools MBIA Special Events66,562.49 Total Cash in Bank & Investment Pools$96,893.71 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,000- 27,661.00-- 180,000.00- Fees14,164,2501,528,346.47 1,043,567.16-1,528,346.47 12,635,903.53- Fund Transfers484,674---- 484,674.00- Miscellaneous135,505.2823,579.16135,505.28 103,260 - - TOTAL REVENUES14,932,1841,663,851.751,094,807.321,663,851.75 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers -- 27,366 - - - TOTAL NON DEPARTMENTAL-- 27,366 - - -27,366.00 BUSINESS OFFICE Personnel Services380,00222,326.47 28,257.82-22,326.47 357,675.53- Supplies5,400418.33418.33-418.3357.82 Human Services100----- Operations Support114,000(1,820.00) (1,234.92)-(1,820.00)21.41 Staff Support7,10094.2694.26490.4594.2660.37 Professional Services16,0002,459.81-1,203.802,459.81 13,540.19- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300420.00--420.003,420.00 Operating Equipmen500.00 365.00500.00 500.00 5,432.06 767.94 t 6,200 -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE24,398.871,012.59 24,398.8729,082.15 8,991.66 567,724.06 600,102 W & S ADMINISTRATION Personnel Services1,178,78165,870.50 92,768.35-65,870.50 1,112,910.50- Supplies200,7003,852.083,858.872,551.513,852.081,462.35 Human Services1,000----- City Support Services144,008- 26,818.42--21.19 Utility Services2,634,344321,697.12 15,048.57-321,697.121,094.92 Operations Support8,750--79.60-- Staff Support33,000376.44267.841,283.65376.44560.08 City Assistance1,912----15.00 Professional Services187,400--- 1,140.00- Fund Charges/Transfers2,623,507107,153.48- 107,153.48- 2,516,353.52- Maintenance Services5,497,250215,616.299,690.25312,309.99215,616.2941,904.08 Other Costs35,000---- 35,000.00- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353---- 1,230,353.00- Rental-Leasing6,070--245.73-- Operating Equipment8,000----- Capital Outla 42,784.00- y 114,000 - -22,432.00 -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,904,075714,565.91 473,537.8213,816.96 714,565.91 88,981.62 13,114,344.435.68% MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,0001,750.791,750.79-1,750.79 48,000.00- Maintenance Services -- 334,500 - - - 1,750.791,750.79-1,750.79 TOTAL AVIATION HEIGHTS WTR IMP 400,000 -400,000.00 FM3009 RD&BRIDGE EXPANSION Professional Services-- 19,137.50--- Maintenance Services 29.03 - - - - - - TOTAL FM3009 RD&BRIDGE EXPANSION - - -19,166.53 - TOTAL MISC & PROJECTS1,750.791,750.7919,166.531,750.79 400,000 -400,000.00 TOTAL EXPENDITURES14,931,543740,71616,580521,787740,71697,973 ** REVENUE OVER(UNDER)EXPENSES **923,136.18 641 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 27,661.00 - 000-421490Tower Leasing180,000 - - - TOTAL Franchises 180,000 - 27,661.00- - - 180,000.00 Fees 000-455200Garbage Collection Fee 3,400,000 326,921.38 249,169.23- 326,921.38 - 3,073,078.62 000-455600Fire Line Fees 19,000 19,350.00 18,430.00- 19,350.00 - 000-455700Recycle Fee Revenue 241,000 23,060.81 10,698.43- 23,060.81 - 217,939.19 000-455800W&S Line Constructn Reimbursemnt50,000 4,171.08 - 2,984.95 4,171.08 - 45,828.92 000-457100Sale of Water 7,210,000 828,590.30 484,438.38- 828,590.30 - 6,381,409.70 000-457110Edwards Water Lease 166,250 6,617.50 59,507.50- 6,617.50 - 159,632.50 000-457120Water Transfer Charge-Selma 5,000 1,376.83 - - 1,376.83 - 000-457130Water Transfer Charge-U. C. 1,000 2,199.97 - - 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 5,065.00 13,163.57- 5,065.00 - 84,935.00 000-457400Sewer Charges 2,800,000 292,249.78 191,002.23- 292,249.78 - 2,507,750.22 000-457500Water Penalties 180,000 18,513.82 14,021.58- 18,513.82 - 161,486.18 000-459200NSF Check Fee-Water&Sewer2,000230.00151.29230.00 - - TOTAL Fees14,164,2501,528,346.47 1,043,567.16-1,528,346.47 - 12,635,903.53 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 - - 000-486204Interfnd Chrg-Drainage Bill84,674 - - - TOTAL Fund Transfers 484,674 - - - - - 484,674.00 Miscellaneous 000-490000Misc Charges 10,000 - - - - - 10,000.00 000-491000Interest Earned 1,000 147.74 - 186.00 147.74 - 000-491200Investment Income 6,000 430.83 (9,994.47)- 430.83 - 000-493400Donations-Christmas Activitise - - - - - - 000-496050SSLG - SAWS Reservation - 134,500.00- -134,500.00 - (134,500.00) 000-497000Misc Income-W&S 426.71 - 1,037.03 426.71 - - 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 - 24,940.96- - - 76,315.00 000-498200W&S Project Reimbursement5,118.30 - - - - - TOTAL Miscellaneous 103,260 135,505.28 23,579.16- 135,505.28 - (32,245.28) TOTAL REVENUES14,932,1841,663,851.75 1,094,807.32- 1,663,851.75 - 13,268,332.25 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking926,147.83$ Cash in Investment Pools Lone Star Investment-Water&Sewer857,655.05 Lone Star Investment-W&S Customer Deposits293,653.24 Lone Star Investment-W&S Equip Replacement373,053.50 Lone Star Investment-W&S Veh Replacement543,956.58 Lone Star Investment-Water/SSLGC SAWS134,655.20 Schertz Bank & Trust-Certificate of Deposit1,044,420.00 $3,247,393.57 Total Cash in Bank & Investment Pools4,173,541.40$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 20.00 244,035.15- 20.00 - 4,088,913.00 Inter-Jurisdictional1,438,836 216,209.24 268,046.57- 216,209.24 - 1,222,626.76 Miscellaneous5,456.93-23,712.435,456.93 256,000 - TOTAL REVENUES 221,686.17 - 535,794.15 221,686.17 - 5,562,082.83 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,572,989160,998.6868.00179,840.57160,998.68 - 2,412,058.32 Supplies 30,010.31 12,858.88 7,838.02 30,010.31 35,919.40 324,039 Human Services - - - 800 - - City Support Services - 7,005.04 - 45,407 - - 45,407.00 Utility Services 462.35 10.41 8,001.87 462.35 112,500 - 112,048.06 Operations Support 20,148.67 163.95 770.89 20,148.67 105.49 45,600 Staff Support 1,071.47 181.47 1,838.25 1,071.47 6,126.05 72,400 City Assistance - - 250.00- 9,000 - Professional Services 20,701.51 133.00 19,475.25 20,701.51 5,609.18 164,200 Fund Charges/Transfers2,084,785 147.74 123,973.61- 147.74 - 2,084,637.26 Maintenance Services 300.00 - 1,656.50 300.00 150.00 37,700 Debt Service - - - 111,176 - - 111,176.00 Rental-Leasing - 836.33 - 20,000.00 20,000 - - Operating Equipment 15,397.65 252.65 15,397.65- 15,014.78 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 249,238.38 13,668.36 351,236.33 249,238.38 63,174.90 5,414,851.08 5,713,596 TOTAL EXPENDITURE249,238.3813,668.36351,236.33249,238.38 S 5,713,596 63,174.90 ** REVENUE OVER(UNDER) EXPENSES (27,552.21) * 70,173 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 - - 244,035.15 - 0.00% -3,818,733.00 000-456110Subscription Program Fees55,000 20.00 - - 20.00 0.04% -54,980.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,933 20.00 244,035.15- 20.00 -4,088,913.00 Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 68,250.58 - 24,943.80 68,250.58 23.85% -217,875.42 000-474300Cibolo Support222,018 55,524.98 - 53,325.00 55,524.98 25.01% -166,493.02 000-475100Comal Co ESD #682,875 18,960.00 - (18,293.44) 18,960.00 22.88% -63,915.00 000-475200Live Oak Support148,125 37,031.25- - - -148,125.00 000-475300Universal City Support 226,168 56,562.83 51,103.13- 56,562.83 -169,605.17 000-475400Selma Support 16,910.8567,618 17,182.50- 16,910.85 -50,707.15 000-475500Schertz Support 384,046 96,864.87- - - -384,046.00 000-475600Santa Clara Support 8,849 - 2,633.67 - - -8,849.00 000-475800Marion Support13,0113,255.79- - - - TOTAL Inter-Jurisdictional1,438,836216,209.24 268,046.57- 216,209.24 -1,222,626.76 Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 34.80 - 66.75 34.80 - - 000-493203Donations-EMS 6,000 25.00 - 250.00 25.00 -5,975.00 000-493204Donations-Dilworth Fund - - - 0.00% - - - 000-493205Donations- Golf Tournament - - - 0.00% - - - 000-497000Misc Income 150,000 5,197.13 10,137.16- 5,197.13 -144,802.87 000-497100Recovery of Bad Debt 100,000 - 1,048.52 - - -100,000.00 000-497500Misc Income-EMT Classes200.0012,210.00200.00 - - - TOTAL Miscellaneous256,0005,456.93 23,712.43-5,456.93 -250,543.07 TOTAL REVENUES5,783,769221,686.17 535,794.15- 221,686.17 -5,562,082.83 26 27 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank $ (377,054.69) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010300,782.53 $(76,272.16) 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: OCTOBER 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60068,646.54 51,114.96- 68,646.54 -640,953.46 Fund Transfers - - - - - - - 0.00% Miscellaneous900147.3562.30 62.30 - - TOTAL REVENUES 68,708.84710,50051,262.3168,708.84641,791.16 - - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 371,06820,611.56 21,618.91- 20,611.56 -350,456.44 Supplies 8,300 100.40 - 28.15 100.40 264.22 Human Services 325 - - - - -325.00 City Support Services 35,899 - 649.90 - - -35,899.00 Utility Services 14,688 - 909.54 569.92- 14,118.08 - Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 279.98 31.34 312.48 279.98 7,977.2279.14 City Assistance 840 - - - 57.00 - Professional Services 19,800 - - - - -19,800.00 Fund Charges/Transfers 199,876 - - - - -199,876.00 Maintenance Services 22,000 - - - - -22,000.00 Other costs 100 - - - - -100.00 Debt Service 17,564 - - - 17,564.00 - - Rental/Leasing500-- - - -500.00 Operating Equipment-- - - - - - TOTAL DRAINAGE 20,991.94701,72531.3423,518.9820,991.94679,794.12 970.28 TOTAL EXPENDITURE 20,991.94701,72531.3423,518.9820,991.94679,794.12 S 970.28 ** REVENUE OVER(UNDER) EXPEND8,77547,716.90 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 352.24 386.72 4,000 386.72 -3,613.28 000-457600Drainage Fee 68,259.82-50,762.7268,259.82 -637,340.18 705,600 TOTAL Fees68,646.54 51,114.96-68,646.54 709,600 -640,953.46 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 27.35 100 - - -100.00 000-491200Investment Interest - 66.14 55.37 600 55.37 -544.63 000-497000Misc Income-Drainage-53.866.93 200 6.93 - TOTAL Miscellaneous - 147.35 62.30 900 62.30 -837.70 TOTAL REVENUES68,708.84 51,262.31- 68,708.84 710,500 -641,791.16 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Ban k Claim on Operating Cash Pool-Checking 111,738.15 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,136.01 Total Cash in Bank & Investment Pools$394,874.16 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 - - - - -390,754.00 Fund Transfers 20,132 - - - - -20,132 Miscellaneous5006.21-39.786.21 - TOTAL REVENUES 6.21411,386-39.786.21411,379.79 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 231.08 213.00 - 231.08 -2,481.92 City Support Services 85,948 - 502.85 - - -85,948.00 Operations Support 74,000 346.04 346.04 - 346.04 6,758.84 Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 193,876 - - - - -193,876.00 Operating Equipment 52,562 - - - - -52,562.00 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 577.12411,386559.04502.85577.12404,609.08 L 6,758.84 TOTAL EXPENDITURE 577.12411,386559.04502.85577.12404,609.08 S 6,758.84 (570.91) REVENUE OVER(UNDER) EXPENDITURE - 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 ---390,754.00 - - TOTAL Taxes 390,754 - - - - - 390,754.00 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned300-25.86- - - 300.00 000-491200Investment Interest 200 6.21 - 13.92 6.21 - 193.79 000-497000Misc Income-- - - - - - TOTAL Miscellaneous5006.21-39.786.21 - 493.79 TOTAL REVENUES 411,386 6.21 - 39.78 6.21 - 411,379.79 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking193,522.58$ Cash in Investment Pools Federated Investment-Hotel/Motel78,132.25 Total Cash in Bank & Investment Pools$271,654.83 33 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 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: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,00046,575.00 - 46,575.00- -203,425.00 Tree Mitigation Fees 75,000 - - - - -75,000.00 Miscellaneous- 35.4871.47 600 35.48 - TOTAL REVENUES46,610.48- 46,610.4871.47 325,600 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - - - -13,000.00 Maintenance Services-Landscape 3,500 - - - - -3,500.00 Operating Equipment 32,000 - 2,567.48 2,781.20- - Capital Outlay -- - 169,000 - 23,416.00 TOTAL PARKLAND DEDICATION-2,567.48- 217,500 - 26,197.20 TREE MITIGATION Maintenance Services-Trees28,500 - 3,133.00 390.00 390.00 -28,110.00 Capital Outlay19,900.00-- 19,900.00 18,000 - TOTAL TREE MITIGATION20,290.00-3,133.0020,290.00 46,500 - TOTAL EXPENDITURE20,290.00-5,700.4820,290.00 S 264,000 26,197.20 REVENUE OVER(UNDER) EXPEND26,320.48 61,600 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,00046,575.00 - 46,575.00- 203,425.00 000-458900Tree Mitigation75,000 -- - - TOTAL Fees 325,00046,575.00 - 46,575.00- 278,425.00 Miscellaneous 000-491000Interest Earned 100 - 30.26 - 100.00 - 000-491200Investment Interest 500 35.48 - 41.21 35.48 464.52 000-497000Miscellaneous Income -- - - - TOTAL Miscellaneous60035.48-71.4735.48 564.52 TOTAL REVENUES 325,60046,610.48 - 71.47 46,610.48 278,989.52 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking$70,806.00 Cash in Investment Pools Federated Investment-Park Fund252,710.49 Federated Investment-Tree Mitigation126,250.14 Total in Investment Pool 378,960.63 Total Cash in Bank & Investment Pools$449,766.63 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% 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: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% 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: OCTOBER 31st, 2011 Cash in Bank (27,365.47) Claim on Operating Cash Pool-Checking $(27,365.47) Total Cash in Bank 40 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 143,048.00 492,336.49- 143,048.00 -2,582,352.00 Fund Transfers10,673,600 - - - - -10,673,600.00 Miscellaneous314,0001,463.383,481.391,463.38 - - TOTAL REVENUES13,713,000 144,511.38495,817.88144,511.38 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - - -1,000.00 Professional Services 22,000 352.62 - - 352.62 -21,647.38 Maintenance Services 10,000 - - - - -10,000.00 Fund Charges/Transfers - - - - - - Debt Service - - - - - - Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000352.628,428.00352.62 L - - MISC & PROJECTS Projects13,025,00035,663.2535,663.253,669.6235,663.25 13,001,084.000.18%23,916.00 Schaefer RD Water Improvements599,643 -- - - -599,643.00 Northcliffe Elevated Tnk -- - - - - Northcliffe Water Plant -- - - - - Town Creek Project -- - - - - Live Oak Water Plant 29.03- - - - - Loop Feed Water Line -- - - - - viation Heights WTR IMP97,366.50- A - - - - TOTAL MISC & PROJECTS13,624,643 35,663.2535,663.25101,065.1535,663.25 23,916.00 TOTAL EXPENDITURE13,662,643 36,015.8735,663.25109,493.1536,015.87 S 23,916.00 REVENUE OVER(UNDER) EXPENDITURES50,357108,496 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 98,640.00 319,123.34- 98,640.00 -1,380,960.00 000-455910Capital Recovery - Waste Wtr613,800 44,408.00 173,213.15- 44,408.00 -569,392.00 - - - 000-455911Capital Recovery-Wste Wtr Zone 1 - - - -- 000-455913Cap Recovery-North Sewer Tr 632,000 - - - TOTAL Fees 2,725,400143,048.00 492,336.49- 143,048.00 -2,582,352.00 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 Earned500-92.46- - - 000-491200Investment Income 30,000 3,343.66 - 1,383.84 3,343.66 -26,656.34 000-491900Unrealized Gain/Loss-Cap One - 2,005.09 (1,880.28) - (1,880.28) -1,880.28 000-497000Misc Income - - - - - - 000-498100Reimbursmnt - FM 78 Project - - - - - - -- 000-498200Re-imbursement-Water Meters 283,500 - - - TOTAL Miscellaneous 314,000 1,463.38 - 3,481.39 1,463.38 -312,536.62 TOTAL REVENUES13,713,000144,511.38 495,817.88- 144,511.38 -13,568,488.62 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking352,218.42$ Cash in Investments: Lone Star Investment-Capital Recovery Water452,659.77 Lone Star Investment-Capital Recovery Sewer280,416.91 Capital One-Investment1,726,026.35 Schertz Bank & Trust-Certificate of Deposit525,424.85 Total Cash in Bank & Investment Pools$3,336,746.30 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ****************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 955,625.844,281,098 - 707,208.20 955,625.84 -3,325,472.16 - - - - Fund Transfers - - Miscellaneous2,2501,632.59 1,632.5928.42 - - TOTAL REVENUES 957,258.434,283,348707,236.62957,258.43 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL - - - - Professional Services - - Debt Service -4,276,667 -- - - TOTAL GENERAL GOVERNMEN -4,276,667 -- T - - TOTAL EXPENDITURE -4,276,667 -- S - - ** REVENUE OVER(UNDER) EXPEND6,682957,258.43 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098955,625.84707,208.20955,625.84 - - TOTAL Taxes4,281,098955,625.84 707,208.20-955,625.84 -3,325,472.16 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401 -- - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 - - - - - 000-491200Investment Earnings1,5001,632.59 1,632.5928.42 - - TOTAL Miscellaneous 2,250 1,632.59 - 28.42 1,632.59 - TOTAL REVENUES4,283,348 957,258.43 707,236.62- 957,258.43 -3,326,089.57 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 505-TAX I & S***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent -- - - - - TOTAL Professional Services---- - - Debt Service 101-555612Bond-GO Refunding 2010-Principal -240,000 - - - -240,000.00 101-555612.1Bond-GO Refunding 2010 Interest82,650 - - - - -82,650.00 101-555622Schertz C O SR2003-Principal200,000 - - - - -200,000.00 101-555622.1Schertz C O SR2003-Interest53,800 - - - - -53,800.00 101-555624Comm Proj Bond-SR04-Principal315,000 - - - - -315,000.00 101-555624.1Comm Proj Bond SR04-Interest251,009 - - - - -251,009.00 101-555626LS&D SR2006-Principal100,000 - - - - -100,000.00 101-555626.1LS&D SR2006-Interest648,982 - - - - -648,982.00 101-555628CO Bond 2007-Principal102,900 - - - - -102,900.00 101-555628.1CO Bond 2007-Interest22,625 - - - - -22,625.00 101-555629GO Bond 2007-Principal225,000 - - - - -225,000.00 101-555629.1GO Bond 2007-Interest198,922 - - - - -198,922.00 101-555630GO Bond SR2008 Principal370,000 - - - - - 101-555630.1GO Bond SR2008 Interest 364,679 - - - - -364,679.00 101-555631GO Bond SR2009 Principal 200,000 - - - - -200,000.00 101-555631.1BO Bond SR2009 Interest -- 278,813 - - -278,812.50 101-555633GO SR2011 Principal -- 532,287 - - -532,287.00 101-555633.1GO SR2011 Interest -- 90,000 - - - TOTAL Debt Service4,276,667---- -4,276,666.50 TOTAL EXPENDITURES4,276,667 - - - - -4,276,666.50 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking474,379.94$ Cash in Investment Pools MBIA Investment- Tax I&S88,600.01 Federated Investment-Tax I&S56.80 Total Cash in Bank & Investment Pools$563,036.75 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET8.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042214,497.42 - 214,497.42- - 2,177,544.58 Fund Transfers - - - - - - Miscellaneous17,200117.45256.65117.45 - - ,,,..,. TOTALREVENUES2409242214614872566521461487 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 21,000 947.23 579.81 822.28 947.23 1,786.29 Utility Service 87,500 134.25 - 3,705.28 134.25 - 87,365.75 Maintenance Services 72,300 4,118.88 432.25 7,498.34 4,118.88 11,768.93 Operating Equipment - 6,999.31 - - - - Capital Outlay -- - - - - TOTAL NONDEPARTMENTA180,8005,200.361,012.0619,025.215,200.36 L 13,555.22 ECONOMIC DEVELOPMEN T Personnel Services 240,677 19,803.91 13,444.49- 19,803.91 - 220,873.09 Supplies 1,100 - - - - - 1,100.00 Human Services 200 - - - - - City Support Services 43,328 1,363.42 1,363.42 3,798.01 1,363.42 1,067.60 Utility Services 7,200 27.40 - 255.96 27.40 - 7,172.60 Operations Support 63,600 4,813.35 4,813.35 3,707.92 4,813.35 - 63,600.00 Staff Support 112,800 937.31 937.31 556.67 937.31 - 112,800.00 City Assistance 300,000 - - - - - 300,000.00 Professional Services 303,500 201.14 201.14 21,340.80 201.14 - 303,500.00 Fund Charges/Transfers 105,985 - - - - - 105,985.00 Fund Replenish-Fund Balance 220,000 - - - - - 220,000.00 Maintenance Services - - - - - - Debt Service 795,154 - - - 795,154.00 - - Operating Equipment2,350 -- - - - TOTAL ECONO DEVELOPMEN 27,146.532,195,8947,315.2243,103.8527,146.531,067.60 T TOTAL EXPENDITURE 32,346.892,376,6948,327.2862,129.0632,346.89 S 14,622.82 ** REVENUE OVER(UNDER) EXPEND32,548182,267.98 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET8.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042214,497.42 214,497.42- - - TOTAL Taxes2,392,042214,497.42 - 214,497.42- -2,177,544.58 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous 42.35- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 - - - - - 000-491200Investment Earnings 15,000 117.45 - - 117.45 -14,882.55 000-497000Misc Income 2,000 - 214.30 - - -2,000.00 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 117.45 - 256.65 117.45 - TOTAL REVENUES2,409,242214,614.87-256.65214,614.87 -2,194,627.13 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking285,711.06$ Cash in Investment Pools MBIA Investment-Economic Development Corp1,015,792.62 Schertz Bank & Trust-Certificate of Deposit506,692.64 Schertz Bank & Trust-Certificate of Deposit1,031,406.35 Total Cash in Bank & Investment Pools2,839,602.67$ 50 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING OCTOBER 31st, 2011 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust3,905,998.83,827,392.01.0500,621,089.81,542,482.99,905,998.83,905,998.83 204333 TOTAL OPERATIONS3,905,998.83,827,392.01,621,089.81,542,482.99,905,998.83,905,998.83 24333 LOGIC General Fund954,875.8354,756.60.1470 -19.2354,875.83 N/A54,875.83 90199 G/F-Equipment Replacement73,307.3973,298.240.1470 -9.1573,307.39 N/A73,307.39 G/F-Vehicle Replacement7,075.70,074.82.1470 -.88,075.70 N/A,075.70 70077 G/F-Air Conditioner Replacement122,364.35122,349.070.1470 -15.28122,364.35 N/A122,364.35 ,210,951.39.147076.09-,211,227.48,211,227.48 SR2009 Bond-Street Projects(II)2,211,227.48 20222 TOTAL LOGIC3,368,850.75,368,430.12 -20.63,368,850.75,368,850.75 3433 LONESTA R Capital Recovery - Sewer280,416.91280,362.070.2300 -54.84280,416.91 N/A280,416.91 Capital Recovery - Water452,659.7752,571.25.2300 -8.5252,659.77 N/A52,659.77 40844 Drainage Fund283,136.01283,080.640.2300 -55.37283,136.01 N/A283,136.01 GO SR2011 Animal Shelter2,268,034.19,267,590.64.2300 -43.55,268,034.19 N/A,268,034.19 20422 GO SR2011 Athletic Fields1,491,576.161,491,284.460.2300 -291.701,491,576.16 N/A1,491,576.16 GO SR2011 Soccer Fields1,512,022.78,511,727.08.2300 -95.70,512,022.78 N/A,512,022.78 10211 GO SR2011 Swimming Pool3,024,045.563,023,454.160.2300 -591.403,024,045.56 N/A3,024,045.56 W/S-Customer Deposits293,653.2493,595.81.2300 -7.4393,653.24 N/A93,653.24 20522 W/S-Equipment Repl/Cap.Imp373,053.50372,980.540.2300 -72.96373,053.50 N/A373,053.50 Water&Sewer857,655.0557,487.32.2300 -67.7357,655.05 N/A57,655.05 80188 W/S-Vehicle Replacement543,956.58543,850.200.2300 -106.38543,956.58 N/A543,956.58 34,628.87.23006.33-34,655.2034,655.20 Water/SSLG - SAWS134,655.20 10211 TOTAL LONESTA11,514,864.951,512,613.04 -,251.911,514,864.951,514,864.95 R1211 MBIA Tax I&S88,600.0188,589.780.1400 -10.2388,600.01 N/A88,600.01 Police Forfeiture359,156.5759,115.02.1400 -1.5559,156.57 N/A59,156.57 30433 Economic Development Corporation1,015,792.621,015,675.170.1400 -117.451,015,792.62 N/A1,015,792.62 Special Events Fund66,562.496,554.74.1400 -.756,562.49 N/A6,562.49 60766 EMS Tax Notes 2010300,782.5300,747.73.14004.80-00,782.5300,782.53 30333 TOTAL MBIA1,830,894.221,830,682.44 -211.781,830,894.221,830,894.22 FEDERATED SR2007a Bond-City Wide Projects867,787.0867,718.07.0900 -9.0167,787.08 N/A67,787.08 80688 Hotel Occupancy Tax78,132.2578,126.040.0900 -6.2178,132.25 N/A78,132.25 Park Fund (Developers Fee)252,710.4952,690.39.0900 -0.1052,710.49 N/A52,710.49 20222 Park Fund (Tree Mitigation)126,250.14126,234.760.1400 -15.38126,250.14 N/A126,250.14 Tax I&S56.806.79.1400 -.016.80 N/A6.80 50055 Library Board Fund44,684.174,680.62.0900.55-4,684.174,684.17 40344 TOTAL FEDERATED1,369,620.931,369,506.67 -114.261,369,620.931,369,620.93 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,284,087.82,313,888.83.5000 275.93,807.14,319,420.04 N/A,334,449.06 12511 Capital One Capital Recovery1,648,653.17,715,378.76.19001,001.02353.43,726,026.35,709,076.72 12111 TOTAL CAPITAL ONE2,932,740.993,029,267.59 629.3616,808.163,045,446.393,043,525.78 52 City Portfolio By Investment Type Schertz Bank &Trust C.D.s 10% Operations Account Schertz Bank & Trust Capital One 5% Managed 9% FEDERATED Pool 21% MBIA Pool 16% LONESTAR Pool 13% 54 City Portfolio By Use Pooled-Daily Operations, $3,905,999 Designated Funds, $5,966,479 Special Revenue Funds, $5,915,955 Debt Service Fund Projects, $11,509,348 $809,074.07 MONTHLY YIELDS 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.0200 1 Month T-Bill 0.0100 3 Month T-Bill 0.0600 6 Month T-Bill 0.4600 Schertz Portfolio 0.0500 Schertz Bank&Trust 1.1000 CD 365 Days 0.8000 CD 180 Days 0.2500 CD 90 Days 0.0500 CD 28 Days 0.1470 LOGIC 0.2300 LoneStar 0.1400 MBIA 0.0900 Federated 2.3243 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:10/31/2011 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #691154,087.82154,087.82154,087.8215.000.01 General Elec Cap Corp Disc Com Paper3/12/2012133.0065,000.0064,891.2264,891.220.000.00 JPMorgan Chase Disc Bank Accpt Note3/1/2012122.0065,000.0064,941.4564,941.45 Total Cash & Equivalent84,087.8283,920.483,920.4 s22929 Fixed Income Federal Home Loan Bks Cons Bds6/21/2013599.0080,000.0082,004.4081,982.401,500.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012352.00150,000.00162,031.50156,048.006,750.00 Federal Home Ln Mtg Corp Deb11/15/2013746.00170,000.00191,084.25185,544.808,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013694.00250,000.00250,000.00268,927.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141121.00100,000.0099,874.4099,972.00750.00 Federal Natl Mtg Assn 4/20/2012172.00250,000.00250,505.00252,042.50 Total Fixed Incom,000,000.01,035,499.5,044,517.2 e105103 Total Assets450.051,284,087.821,319,420.041,328,437.693 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #691208,653.17208,653.17208,653.1730.000.01 General Elec Cap Corp Disc Coml Paper3/12/2012133.0085,000.0084,857.7484,857.740.000.00 84,923.4384,923.43 JPMorgan Chase Disc Bank Accpt Note3/1/2012122.0085,000.00 Total Cash & Equivalent78,653.1378,434.378,434.3 s37434 Fixed Income Federal Home Loan Bks Cons Bds6/21/2013599.00100,000.00102,505.50102,478.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012352.00250,000.00270,052.50260,080.0011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013746.00250,000.00281,006.25272,860.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013715.00200,000.00223,001.60216,578.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141121.00120,000.00119,849.28119,966.40900.00 Federal Natl Mtg Assn10/30/2012365.00250,000.00250,192.50250,810.001,250.00 US Treasury Note12/15/201145.00100,000.00100,984.38100,145.00 Total Fixed Incom,270,000.01,347,592.01,322,917.4 e10103 Total Assets450.401,648,653.171,726,026.351,701,351.743