Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02-NOVEMBER 2011 FINANCIAL STATEMENT
NOVEMBER 2011 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department January 17, 2011 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725706,044.97 1,675,784.40-2,692,674.87 - 9,111,050.13 Franchises 1,617,000 418,619.01 386,588.81- 427,877.85 - 1,189,122.15 Permits 1,187,800 57,202.00 523,543.33- 137,828.00 - 1,049,972.00 Licenses 31,300 1,520.00 - 2,755.10 3,085.00 - 28,215.00 Fees 3,341,727 178,832.22 558,861.15- 348,224.73 (611.43) Fines 30,000 1,513.99 - 4,252.23 3,860.03 - 26,139.97 Inter-Jurisdictional 571,245 55,380.46 75,554.24- 81,864.67 - 489,380.33 Fund Transfers 1,760,658 108,750.59 - 217,501.18- - 1,543,156.82 Miscellaneous615,50029,223.94 152,468.3869,897.77(331.00) - TOTAL REVENUES20,958,9551,557,087.183,297,237.034,065,384.71(942.43) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,843.08 - 3,584.50 3,324.34 - 19,475.66 Supplies500 19.98 - - 19.98 84.00 396.02 City Support Services20,500 140.98 219.98 110.00 410.96 275.75 20,033.27 - - - - Utility Services - - Operations Support 300 - - - - - Staff Support17,4005,404.212,150.00 735.708,204.223,365.35 Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 7,408.25 2,369.98 4,430.20 11,959.50 3,725.10 CITY MANAGE R Personnel Services749,72668,273.36 110,016.35-114,007.28 - 635,718.72 Supplies5,331 356.07 268.94 - 482.95 488.42 4,628.57 - - - - City Support Services - - Operations Support - - - - - - Staff Support 25,550 8,109.19 1,527.05 3,570.83 9,207.94 2,596.67 Operating Equipment -133.43 - - - - TOTAL CITY MANAGER 780,607 76,738.62 113,720.611,795.99 123,698.17 3,085.09 655,619.73 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services254,333 23,970.07 - 38,543.36 39,361.36 - 214,971.64 Supplies2,500 165.39 99.00 343.69 264.39 76.19 2,258.42 City Support Services1,000 - - - - - Operations Support 3,000 700.00 700.00 - 700.00 - Staff Support 5,500 285.05 285.20 394.44 670.25 121.16 Court Support 800 - - - - - Professional Services 71,100 4,646.25 - 6,825.00 9,528.75 24,823.75 Maintenance Services 2,200 267.25 - - 267.25 - Operating Equipment1,000497.14497.14 497.14250.00 - TOTAL MUNICIPAL COURT 30,531.15341,433 1,581.34 46,356.49 51,289.14 25,021.10 266,704.10 CUSTOMER RELATIONS-311 Personnel Services108,506 8,819.58 - 13,592.91 13,908.86 - 94,597.14 Supplies300 - - - - - Staff Support1,100 -- - - - Operating Equipment500 -- - - - TOTAL CUSTOMER RELATIONS-311 110,406 8,819.58 13,592.91- 13,908.86 - 96,497.14 PLANNING & ZONING Personnel Services 216,383 13,378.22 21,218.71- 21,547.78 - 194,835.22 Supplies 2,700 4.34 156.45 24.75 160.79 81.83 Operations Support 750 - - - - - Staff Support 17,150 1,563.75 548.55 322.19 1,863.75 83.06 Professional Services 76,650 1,366.40 1,366.40 9,060.06 1,366.40 - 76,650.00 Operating Equipment3,500 -- - - - TOTAL PLANNING & ZONING317,13316,312.712,071.4030,625.7124,938.72164.89 LEGAL SERVICES Operations Support 13,000 - - - - - 13,000.00 Professional Services245,000 --33.18 - - TOTAL LEGAL SERVICES 258,000 - - - - 33.18 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services642,762 61,990.75 - 112,999.22 93,281.19 - 549,480.81 Supplies57,100 6,778.72 1,124.76 7,433.35 8,352.91 5,217.70 44,654.15 Utility Services111,000 5,085.11 - 5,350.49 6,792.27 - 104,207.73 - - - - Operations Support - - Staff Support 11,179 974.77 41.35 1,719.36 1,083.01 990.60 Maintenance Services 106,450 9,782.32 673.05 41,733.75 10,455.37 11,747.82 Rental/Leasing 1,400 - - - - - Operating Equipment2,500 -- - - - Capital Outlay24,500 -- - - - TOTAL FACILITIES MAINTENANCE 956,891 84,611.67 1,839.16 169,236.17 119,964.75 17,956.12 CITY SECRETAR Y Personnel Services 163,417 14,473.28 26,329.28- 24,284.88 - 139,132.12 Supplies 1,250 14.72 - 55.85 14.72 62.20 City Support Services 9,780 - - - - - Staff Support8,605700.93 700.93590.44993.52 - TOTAL CITY SECRETARY 183,052 15,188.93 26,975.57- 25,000.53 1,055.72 NON-DEPARTMENTA L Supplies 2,500 10.71 - - 10.71 - City Support Services 665,127 123,403.06 1,294.02 160,342.54 128,728.06 289.80 Operations Support 139,000 6,348.70 1,076.05 10,319.30 14,314.61 4,899.26 Staff Support - - - - - - City Assistance 459,046 - 96,864.87- 96,046.91 - 362,999.09 Professional Services 157,150 2,389.65 - 6,142.06 4,800.22 - 152,349.78 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,433,673 132,152.12 2,370.07 273,668.77 243,900.51 5,189.06 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services214,010 19,955.09 - 22,452.01 32,894.96 - 181,115.04 Supplies2,900 542.15 - 14.97 599.96 33.06 2,266.98 Operations Support35,100 962.02 - 1,999.36 962.02 443.50 33,694.48 Staff Support4,350 580.80 196.44 457.58 777.24 117.99 3,651.21 Operating Equipment300 -- - - - TOTAL PUBLIC AFFAIRS 256,660 22,040.06 196.44 24,923.92 35,234.18 594.55 RECORDS MANAGEMEN T Personnel Services 47,294 4,754.51 - 7,494.22 7,613.28 - 39,680.72 Supplies 750 - - - - 71.00 Staff Support 1,500 - - 85.00 244.40- Professional Services 15,000 906.50 - 577.00 906.50 - 14,093.50 Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 64,544 5,661.01 - 8,156.22 8,519.78 315.40 SCHERTZ TALES MAGAZINE Personnel Services 128,605 10,570.28 16,934.37- 18,648.24 - 109,956.76 Supplies 200 - - - - - Opperations Support 200 - - - - - Staff Support 1,500 72.91 - - 72.91 31.23 Professional Services302,70033,137.94 45,707.8835,708.21 - 10,882.86 TOTAL SCHERTZ TALES MAGAZINE 433,205 43,781.13 52,642.58- 64,429.03 10,914.09 ENGINEERING Personnel Services 163,904 8,108.77 26,313.82- 14,140.46 - 149,763.54 Supplies 400 33.19 - 67.35 33.19 32.50 City Support Services - - - - - - Utility Services 600 - - - - - Staff Support 2,213 - - 265.00 - - Professional Services 48,165 2,850.00 - - 4,275.00 9,165.00 Maintenance Services 4,044 3,345.29 - 2,145.29 3,345.29 - Operating Equipment -- - - - - Capital Outlay26,000 -- - - 21,447.00 TOTAL ENGINEERING 245,326 14,337.25 28,791.46- 21,793.94 30,644.50 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services120,967 10,537.84 - 17,693.96 17,836.96 - 103,130.04 Supplies3,500 - - - - 580.39 2,919.61 Staff Support4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 130,517 10,537.84 17,693.96- 17,836.96 580.39 TOTAL GENERAL GOVERNMENT 5,572,947 468,120.32 12,224.38 810,814.57 762,474.07 99,279.19 PUBLIC SAFETY POLICE Personnel Services4,509,076 439,071.44 - 705,937.23 705,210.26 35.00 3,803,830.74 Supplies31,957 1,496.92 2,341.57 368.88 3,157.93 401.79 30,738.85 City Support Services35,000 19,518.41 - - 19,518.41 - 15,481.59 Utility Services123,456 8,792.21 - 6,788.53 8,792.21 - 114,663.79 Operations Support1,500 - - 98.00 - 720.00 780.00 Staff Support58,372 464.58 1,732.17 484.74 2,980.18 1,149.93 55,974.06 City Assistance10,914 330.52 - 100.00 330.52 - 10,583.48 Professional Services20,000 - - - - 642.85 19,357.15 Maintenance Services44,435 - - 11,081.25 - 5,540.00 38,895.00 Operating Equipment57,887 1,386.39 2,905.10 8,637.90 3,242.24 9,236.07 48,313.79 Capital Outlay142,52565,886.2512,554.80 78,441.05- 76,635.00 TOTAL POLICE 5,035,122536,946.7219,533.64733,496.53821,672.8094,360.64 FIRE RESCUE Personnel Services 2,495,242 258,862.24 412,236.88- 408,009.86 - 2,087,232.14 Supplies 20,500 656.37 9,239.99 170.15 9,896.36 161.12 Utility Services 57,000 4,278.84 7.64 5,013.34 4,286.48 - 52,721.16 Operations Support 800 - - - 115.00- Staff Support 120,185 4,442.51 19,618.33 8,004.54 27,145.61 13,662.27 City Assistance 18,600 5,607.80 8,122.00 10,323.17 8,366.30 - 18,355.70 Professional Services 18,140 22.19 - - 22.19 - 18,117.81 Maintenance Services 56,000 240.00 3,710.01 59.95 3,805.81 139.50 Operating Equipment58,3007,001.0715,553.04 1,393.878,988.36 -64,864.68 Capital Outlay35,000 -- - - 31,116.00 TOTAL FIRE 2,879,767 281,111.02 56,251.01 437,201.90 470,520.97 45,193.89 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services417,182 38,826.78 - 57,456.63 63,484.35 - 353,697.65 Supplies2,500 50.20 - 10.00 105.88 225.42 2,168.70 Utility Services6,500 382.40 - 671.94 382.40 - Operations Support 1,500 - - - - - Staff Support 8,000 650.51 581.37 691.89 1,202.27 46.99 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -- - - - TOTAL INSPECTIONS 446,68239,909.89581.3758,830.4665,174.90272.41 MARSHAL SERVICE Personnel Services 529,908 54,670.88 67,221.65- 86,310.52 - 443,597.48 Supplies 4,600 784.18 205.82 - 990.00 59.42 Utility Services 12,000 1,273.40 - 487.92 1,273.40 - 10,726.60 Operations Support 4,000 777.44 - 12.44 777.44 208.97 Staff Support 15,400 508.30 410.00 473.61 2,765.38 506.29 Professional Services - - - - - - Maintenance Services 30,700 4.00 - 222.00 4.00 - 30,696.00 Operating Equipment16,000 2,324.044,602.173,825.46 -2,206.37 Capital Outlay34,000 -15,588.00 - - 31,022.05 TOTAL MARSHAL SERVICE 646,608 58,018.20 2,822.19 86,329.66 96,722.91 35,622.19 TOTAL PUBLIC SAFETY 9,008,179 915,985.83 79,188.21 1,315,858.55 1,454,091.58175,449.13 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services674,240 73,334.90 - 118,916.64 113,796.87 - 560,443.13 Supplies7,100 536.01 21.04 1,202.60 557.05 964.46 5,599.53 Utility Services113,900 9,010.83 - 9,162.86 13,425.13 305.99 100,168.88 - - - - Operations Support - - Staff Support 10,265 553.85 79.91 84.08 726.02 157.05 Maintenance Services 270,800 19,751.08 579.71 27,764.66 20,681.83 23,335.90 Rental/Lease 200 - - - - - Operating Equipment 4,200 2,681.99 - - 2,681.99 1,044.14 Capital Outlay -2,100.00 - - - - TOTAL STREETS 1,080,705105,868.66680.66159,230.84151,868.8925,807.54 TOTAL PUBLIC ENVIRONMENT 1,080,705 105,868.66 680.66 159,230.84 151,868.89 25,807.54 PARKS & RECREATION PARKS DEPARTMENT Personnel Services503,534 48,650.60 - 78,294.29 77,445.44 - 426,088.56 Supplies40,555 3,462.05 1,169.51 4,879.22 4,196.96 6,816.33 30,711.22 Utility Services113,000 4,675.94 - 6,354.86 12,103.13 305.99 100,590.88 Operations Support700 - - 600.00 - - Staff Support 8,573 1,786.87 60.93 1,048.50 1,847.80 688.61 Professional Services 62,610 - - 8,045.00 3,571.50 - 59,038.50 Maintenance Services 22,000 4,306.86 44.99 140.79 4,351.85 379.14 Rental/Leasing 42,200 3,355.60 - 8,752.46 3,355.60 38,704.80 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL PARKS DEPARTMENT793,17266,237.921,275.43108,115.12106,872.2846,894.87 SWIM POOL Supplies 16,700 150.58 26.93 343.35 150.58 - 16,576.35 Utility Services 25,500 1,008.72 - 882.37 3,297.87 - 22,202.13 Staff Support 925 - - - 750.00 - Maintenance Services 199,378 4,000.00- - 4,000.00 - 199,378.00 Rental/Lease500 -- - - - TOTAL SWIM POOL 1,159.30243,003 4,026.93 1,225.72 8,198.45 - 238,831.48 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services106,977 6,281.73 - 7,271.02 9,309.09 - 97,667.91 Supplies7,300 235.19 1,127.61 1,513.31 1,362.80 401.87 6,662.94 Utility Services47,550 2,011.66 - 2,447.56 2,371.27 - 45,178.73 Operations Support15,200 307.81 - 95.00 307.81 177.80 14,714.39 Staff Support3,300 178.01 439.45 - 617.46 - Professional Services 1,600 - 150.00 - 150.00 - Operating Equipment5,0005,660.704,243.88 6,059.58100.00 - TOTAL COMMUNITY/CIVIC CNTR186,92714,675.105,960.9411,426.8920,178.01579.67 TOTAL PARKS & RECREATION 1,223,102 82,072.32 11,263.30 120,767.73 135,248.74 47,474.54 CULTURAL LIBRARY Personnel Services 686,050 67,861.20 106,206.76- 110,743.37 - 575,306.63 Supplies14,000 495.25 86.59 151.36 631.79 2,772.30 10,682.50 Utility Services41,000 2,545.01 - 2,792.27 3,887.37 - 37,112.63 Operations Support2,000 - 174.00 - 174.00 - Staff Support 4,215 63.13 58.97 164.17 167.45 - Professional Services 2,100 - - - 2,140.00- Maintenance Services 2,400 - - 400.00 400.00 - Operating Equipment 75,000 3,166.87 175.10 272.36 3,354.95 9,678.72 Capital Outlay -- - - - - TOTAL LIBRARY 74,131.46826,765 494.66 109,986.92 119,358.93 14,591.02 693,309.71 TOTAL CULTURAL826,765 74,131.46 494.66 109,986.92 119,358.93 14,591.02 693,309.71 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services295,327 27,467.48 - 50,924.15 45,217.05 - 250,109.95 Supplies25,000 2,091.31 319.99 1,465.88 2,411.30 1,524.86 21,383.83 Utility Services11,200 663.46 - 517.24 750.72 - 10,449.28 Operations Support500 - - - - - Staff Support 11,560 780.00 34.48 13.81 1,435.48 367.78 City Assistance 10,000 1,495.69 - 1,037.98 1,495.69 - Professional Services 14,500 - - 1,568.50 285.00- Maintenance Services 6,200 - - 396.78 2,340.00 - Operating Equipment9,500159.95 -883.88 - - Capital Outlay -- - - - - TOTAL ANIMAL SERVICES383,78732,657.89354.4755,924.3454,534.122,177.64 TOTAL HEALTH 383,787 32,657.89 354.47 55,924.34 54,534.12 2,177.64 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 257,808 22,435.57 37,772.47- 38,993.09 - 218,814.91 Supplies 2,000 - - - - 58.04 City Support Services 372,354 31,292.22 29,701.17- 31,742.22 7,783.50 Utility Services 154,949 1,291.52 1,585.17 7,815.19 5,157.64 1,841.40 Staff Support 15,250 2,366.59 2,036.38 2,019.20 4,324.23 2,215.77 Professional Services 2,500 - - - - - Maintenance Services 12,500 - - 5,784.75 1,500.74- Operating Equipment 129,315 4,434.99 4,911.44 17,988.07 7,642.61 8,295.84 Capital Outlay213,500 -- - - - TOTAL INFORMATION TECHNOLOGY1,160,176 61,820.89 8,532.99 101,080.85 87,859.79 21,695.29 1,059,153.91 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services295,638 20,189.97 - 28,585.74 33,113.05 - 262,524.95 Supplies1,329 - - - - 644.54 684.28 Human Services47,156 7,100.41 654.00 2,562.24 7,754.41 - 40,055.59 Operations Support16,596 - 532.56 266.28 532.56 - 16,596.02 Staff Support14,897 4,645.09 550.72 6,766.00 5,195.81 1,956.69 8,295.22 City Assistance9,860 515.00 - 622.00 515.00 - Professional Services - - - - - - Operating Equipment3,772.804,162.83 4,162.83- - - TOTAL HUMAN RESOURCES 36,223.27385,476 5,900.11 38,802.26 51,273.66 2,601.23 337,501.06 FINANCE Personnel Services426,474 43,257.81 - 64,739.74 70,615.19 - 355,858.81 Supplies3,600 43.53 - 1,014.92 55.24 450.73 3,094.03 Operations Support850 543.34 - - 543.34 59.20 247.46 Staff Support15,805 220.00 - 540.00 220.00 15.56 15,569.44 Rental/Leasing2,230 - - - - - Operating Equipment1,000266.47 266.47- - - TOTAL FINANCE449,95944,064.68266.4766,294.6671,700.24525.49 PURCHASING & ASSET MG T Personnel Services 240,272 23,076.68 36,904.01- 37,570.77 - 202,701.23 Supplies 800 18.12 - - 18.12 32.05 Utility Services 750 74.55 - - 74.55 - Operations Support 850 - - - - - Staff Support 9,450 559.10 65.00 435.46 624.10 458.60 Operating Equipment7,500 --7,500.00 - - TOTAL PURCHASING & ASSET MGT 259,622 23,728.45 65.00 37,339.47 38,287.54 7,990.65 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,324 20,177.52 - 28,927.51 30,828.86 - 186,495.14 Supplies109,600 22,278.79 2,927.39 16,232.75 25,250.94 7,556.24 79,720.21 City Support Services1,500 1,500.00 - 1,500.00 1,500.00 - Utility Services 7,200 230.45 - 223.91 230.45 - Operations Support 400 - - - - - Staff Support 3,835 67.02 620.41 295.80 704.83 36.12 Maintenance Services 65,750 4,226.72 1,685.29 2,446.73 5,810.48 1,456.24 Rental/Lease200269.80 -269.80 - - Operating Equipment5,000717.97 -717.972,924.68 - Capital Outlay -- - - - - TOTAL FLEET SERVICE410,80949,468.275,233.0949,626.7065,313.3311,973.28 TOTAL INTERNAL SERVICE 2,666,042 215,305.56 19,997.66 293,143.94 314,434.56 44,785.94 MISC & PROJECTS CITY ASSISTANCE - - - - Utility Services - - Patient Assistance 5,000 - - - - - Children's Advocacy Assistance 5,000 - - - - - Senior Citizen's Hot Meals42,00010,500.00 10,500.0010,500.00 - 31,500.00 TOTAL CITY ASSISTANCE52,00010,500.00 10,500.00-10,500.0031,500.00 COURT - RESTRICTED FUNDS Operating Equipment -- - - - - TOTAL CITY ASSISTANCE - - - - - - TOTAL MISC & PROJECTS 52,000 10,500 - 10,500 10,500 31,500 TOTAL EXPENDITURES20,813,5271,904,642.04 124,203.34 2,876,226.89 3,002,510.89441,065.00 REVENUE OVER(UNDER) EXPEND.145,4281,062,873.82 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 228,924.36 1,650,415.21- 1,768,965.49 - 5,115,488.51 000-411200Advalorem Tax - Delinquent 50,000 10,437.38 - 8,220.34 16,008.89 - 33,991.11 000-411300Advalorem Tax - P&I 50,000 3,047.64 - 2,424.51 4,982.14 - 45,017.86 000-411500Sales Tax Revenue-Gen Fund4,784,071 463,635.59 - 4,941.23 895,688.28 - 3,888,382.72 000-411600Bingo Tax 2,200 - - 981.20 - - 000-411700Mixed Beverage Ta 7,030.078,801.91 x 33,000.00 - - - TOTAL Taxes11,803,725 706,044.97 1,675,784.40- 2,692,674.87 - 9,111,050.13 Franchises 000-421200Center Point/Entex Energy 36,000 9,978.35 - - 9,978.35 - 26,021.65 000-421220City Public Service 330,000 96,391.57 83,433.23- 96,391.57 - 233,608.43 000-421240Guadalupe Valley Elec Co-op 440,000 138,145.00 124,838.75- 138,145.00 - 301,855.00 000-421250New Braunfels Utilities 55,000 9,585.78 - 7,403.70 9,585.78 - 45,414.22 000-421300Time Warner-State Franchise 345,000 80,197.52 87,894.73- 80,197.52 - 264,802.48 000-421350Time Warner-PEG Fee 65,000 16,039.50 16,416.59- 16,039.50 - 48,960.50 000-421460AT&T Franchise Fee 185,000 36,239.75 43,536.50- 36,239.75 - 148,760.25 000-421465AT&T PEG Fees 26,000 7,247.95 5,497.29 7,247.95 - 18,752.05 000-421480Other Telecom Franchise 35,000 24,793.59 - 4,056.36 24,824.05 - 10,175.95 000-421500Solid Waste Franchise Fee100,00013,511.669,228.38 - - - TOTAL Franchises1,617,000418,619.01 386,588.81-427,877.85 - 1,189,122.15 Permits 000-431100Home Occupation Permit 500 - - - 35.00 - 000-431200Building Permit 469,766.83- 85,427.00 - 36,769.00 - (85,427.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 55.00 - 75.00 195.00 - 000-431500Food Establishmnt Permit 30,000 2,100.00 - 7,595.00 9,425.00 - 20,575.00 000-431600Garage Sale Permit 8,600 990.00 - 2,310.00 2,280.00 - 000-431700Plumbing Permit 80,000 5,773.00 13,481.50- 16,331.00 - 63,669.00 000-431750Electrical Permit 55,000 2,380.00 - 9,220.00 6,740.00 - 48,260.00 000-431800Mechanical Permit 59,000 3,740.00 11,260.00- 8,600.00 - 50,400.00 000-431900Solicitor/Peddler Permit 10.00 - 60.00 130.00 - - 000-431950Animal/Pet Permit 2,000 315.00 - 925.00 580.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800350.00-1,300.00600.00 - 000-432100Security Alarm Permit 42,000 4,270.00 - 6,050.00 6,360.00 - 35,640.00 000-435000Fire Permit5,000450.00 1,125.001,500.00 - - TOTAL Permits1,187,80057,202.00 523,543.33-137,828.00 - 1,049,972.00 Licenses 000-441000Alcohol Beverage License 6,300 570.00 - 135.00 660.00 - 000-442000Contractors License 22,000 660.00 - 1,850.00 1,835.00 - 20,165.00 000-444000Pet License3,000290.00 590.00770.10 - - TOTAL Licenses 31,300 1,520.00 - 2,755.10 3,085.00 - 28,215.00 Fees 000-451000Municipal Court Fines 1,665,009 79,662.93 164,638.80- 153,137.48 - 1,511,871.52 000-451100Arrest Fee 50,694 4,217.29 - 7,834.35 7,487.33 - 43,206.67 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 9,647.10 15,434.00- 18,255.10 - 173,744.90 000-451320Civil Justice Fee-Court 75 6.91 12.42 11.87 - 000-451321Civil Justice Fee-State 61.65 - - 106.71 - - 000-451340Judicial Fee - City 6,826 547.99 - 1,017.20 981.94 - 000-451400Traffic Fine Costs TTL 25,984 2,229.34 - 4,043.13 3,898.01 - 22,085.99 000-451500Teen Court Admin Fee 260 60.00 - 120.00 160.00 - 000-451510Juvenile Case Mgmt Fee 55,896 4,566.84 - 8,486.41 8,192.77 - 47,703.23 000-451600Technology Fund Fee 45,601 3,739.30 - 6,740.24 6,694.14 - 38,906.86 000-451700Security Fee 34,220 2,804.50 - 5,055.16 5,020.66 - 29,199.34 000-451800Time Payment Fee - City 7,336 403.43 - 799.73 927.02 000-451850State Fines 10% Service Fee 72,470 - 19,298.66- 13,466.72 - 59,003.28 000-451900DPS Payment - Local 11,858 808.65 - 1,322.09 1,542.79 - 10,315.21 000-452000Child Safety Fee 12,243 2,856.36 - 2,218.54 5,790.34 - 000-452050Indigent Defense Fee 21,655 1,750.27 - 3,322.37 3,143.80 - 18,511.20 000-452100Platting Fees 98,000 3,500.00 13,500.00- 5,000.00 - 93,000.00 000-452200Site Plan Fee 74,000 4,500.00 - 4,000.00 4,500.00 - 69,500.00 000-452300Plan Check Fee 465,000 19,155.00 235,492.91- 45,052.50 - 419,947.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 1,500.00 - 700.00 1,500.00 - 000-452500Food Handler Class 7,000 220.00 - 470.00 990.00 - 000-452520Fire Training Classes 400 - - - - - 000-452600Specific Use/Zone Chng Fee 20,000 9,500.00 -- 12,350.00 - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452710Zoning Ltr & Dev Rights1,500150.00-150.00300.00 - 000-453100Reinspection Fees 30,000 2,025.00 - 9,825.00 6,500.00 - 23,500.00 000-453200Mowing Fees - Inspections 12,000 - - 7,684.26 315.00 - 11,685.00 000-453211Admin Fee-Inspections 7,480 - - 1,500.00 400.00 - 000-453310Misc Inspection Fee - - 35.00 19.49 - - 000-453500SubContractor Reg. Fee 17,000 1,225.00 - 1,305.00 2,040.00 - 14,960.00 000-453710Foster Care 500 50.00 - 200.00 200.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 800 - - - - - 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 50.00 - 250.00 200.00 000-458100Sale of Merchandise - - (29.58) - - - 000-458300Sale of Property/Auction 22,000 225.79 - 333.91 1,408.94 (175.43) 000-458400Civic Center Rental Fees 171,000 8,243.75 20,712.24- 15,294.00 (350.00) 000-458401Capital Recovery Fee-Civic Cntr 7,500 270.00 - 415.00 675.00 - 000-458450North Center Rental Fees 15,000 1,123.00 - 1,061.00 4,503.00 (75.00) 000-458500Community Center Rental Fees18,000 1,951.30 - 2,698.00 2,691.80 - 15,308.20 000-458550Pavilion Rental Fees 18,500 430.00 - 3,163.30 2,017.00 - 16,483.00 000-458560Chamber of Comm rent 11,700 - - - - - 11,700.00 000-458570Non-Resident SYSA League 12,000 1,880.00 - 7,060.00 1,880.00 - 10,120.00 000-458650NonResident User Fee-BVYA 11,000 2,670.00 - 1,410.00 2,670.00 - 000-458660BVYA Utility Reimbursement - - 3,195.72 - 3,195.72 - (3,195.72) 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 30.00 - 54.00 36.00 - 000-459400Maps, Copies, UDC, & Misc F 400 3.10 - 5.00 3.10 - 000-459600Animal Adoption Fee 15,000 1,793.00 - 2,010.00 2,220.50 (11.00) 000-459700Pet Impoundment Fee 15,000 1,383.00 - 3,491.01 2,485.00 - 12,515.00 000-459800Police Reports Fee6,500396.00 906.00864.00 - - TOTAL Fees 3,341,727 178,832.22 558,861.15- 348,224.73 (611.43) 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0001,513.99 3,860.034,252.23 - - TOTAL Fines 30,000 1,513.99 - 4,252.23 3,860.03 - 26,139.97 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 - - 3,512.96 1,756.48 - 19,320.52 000-473200City of Seguin - Fire Contract 40,263 3,355.26 - 6,710.52 6,710.52 - 33,552.48 000-473300Guad Co - Library 180,000 15,901.33 30,136.00- 31,802.66 - 148,197.34 000-473400Randolph AFB-Animal Cntrl 1,000 300.00 - 800.00 300.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 33,326.25- 33,326.25 - 99,978.75 000-474600School Crossing Guard-Bexar6,6002,497.62 1,068.515,224.08 - - 000-474610School Cross Guard-Guadalupe -2,744.68 - - - - 000-474700School Officer Funding150,000 -- - - - TOTAL Inter-Jurisdictional 571,245 55,380.46 75,554.24- 81,864.67 - 489,380.33 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 - 14,640.00- - 73,200.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 - 23,771.00- - 118,855.00 000-481000Transfer From Reserves 355,000 - - - - - 355,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 3,486.25 - - 6,972.50 - 28,507.50 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 - 146,870.34- - 734,351.66 000-486317Transfer From Park Fund 13,000 - - - - - 13,000.00 000-487000Interfund Charges-Fleet 98,484 8,207.00 - 16,414.00- - 82,070.00 000-488000Interfund Charges-4B 53,000 4,416.67 - - 8,833.34 - 44,166.66 000-490020Transfer In-SEDC50,000 -- - - - TOTAL Fund Transfers1,760,658 -108,750.59 - 217,501.18 - 1,543,156.82 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 10.49 - 618.26 25.54 - 000-491200Investment Income 30,000 3,529.22 - 4,790.60 6,445.69 - 23,554.31 000-491800Gain/Loss (19.83) - - (19.83) - - 000-491900Unrealized Gain/Loss (4,221.57)- (4,343.15) - (2,809.25) - 000-492100Proceeds-Sale of Land - - 57,867.85- - - (57,867.85) 000-493000Donations-Others - - - - - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap. 389.00 20,135.00- 503.00 - - 000-493400Donation - Animal Control 1,200 242.00 - 1,163.52 297.02 - 000-493401Donations-A/C Microchip 500 275.00 - 430.00 375.00 - 000-493402Donations-Spay&Neuter 13,500 1,735.00 - 3,445.50 2,341.00 - 11,159.00 000-493503Donations - Fire Rescue - - - - - - 000-494481LawEnforcemtOfficersStnd&Ed - - - - - - 000-494482DOJ-PD GRANT - - - - - - 000-495040Friends of N. Schertz Park - - 3,074.00 - 3,074.00 - (3,074.00) 000-497000Misc Income-Gen Fund 81,000 1,537.65 - 192.32 1,637.02 (231.00) 000-497005Misc Income-Publications 290,000 15,116.00 17,666.00- 35,757.00 (100.00) 000-497020Misc Income-Fleet Recycled - - - - - - 000-497100Misc Income-Police 25,000 300.00 - 2,564.57 768.90 - 24,231.10 000-497200Misc Income-Library 19,000 343.14 - 436.20 769.44 - 18,230.56 000-497210Misc Income-Library Copier 13,500 1,625.50 1,417.75 2,630.76 - 10,869.24 000-497300Misc Income-Animal Control 500 - - 137.50 105.00 - 000-497400Misc Income-Streets Dept. 20,000 2,124.88 - 5,100.00 5,046.88 - 14,953.12 000-497500Misc Income-TML Insurance 78,000 - - - - - 78,000.00 000-497550Misc Income-TML Reimbursemt20,000 837.00 - 7,506.52 837.00 - 19,163.00 000-497600Misc Income-Parks/Vending Mach.2,500 213.65 -404.53445.75 - 000-498000Reimbursmnt-Gen Fund5,000700.49 33.008,608.49 - - 000-498100Reimbursmnt Fire - Training 800 - - - - - 000-498105Reimburmnt Police - DEA - - - - - - 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 29,296.028,078.07 - - - TOTAL Miscellaneous 615,500 29,223.94 69,897.77- 152,468.38 (331.00) TOTAL REVENUES20,958,9551,557,087.18 3,297,237.03- 4,065,384.71 16,894,512.72(942.43) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking235,198.59$ Cash in Investment Pools LOGIC Investment-General Fund1,706,135.12 LOGIC Investment-Equip Replacement73,318.68 LOGIC Investment-Veh Replacement7,076.79 LOGIC Investment-Air Condi Replacment146,386.90 CAPITAL ONE Investment-General Fund1,334,578.22 Total Cash in Bank & Investment Pools$3,624,944.56 17 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 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% 13% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 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: NOVEMBER 30th, 2011 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET16.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 - - - - - 28,000.00 TML Dinner - - - - - - Hal Balwin Scholarship 24,000.00 - - - - - 24,000.00 Miscellaneous175.007.98- 15.73241.98 - TOTAL REVENUES114,275.00 7.98 - 241.98 15.73 - 114,259.27 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 - 500.00 500.00 9,500.00 Employee Appreciation Event 5,000.00 - (76.87) - 4,950.0050.00 - 4th of July Jubilee 218.05 218.05 - 218.05 - - 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 1,347.03 - 1,658.00 1,382.32 35,117.68500.00 Hal Baldwin Scholarship11,000.00- -- - -11,000.00 Selma-Schertz 5K- -- - - - TOTAL CULTURAL 2,065.08103,600.00 218.05 2,537.04 2,100.37 10,050.00 TOTAL EXPENDITURES108,750.00 2,065.08 218.05 2,537.04 2,100.37 10,050.00 96,817.68 REVENUE OVER(UNDER) EXPEND5,525.00(2,084.64) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking24,792.32$ Cash in Investment Pools MBIA Special Events66,570.47 Total Cash in Bank & Investment Pools$91,362.79 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,000- 35,061.00-- 180,000.00- Fees14,164,2501,246,939.63 2,274,173.51-2,766,057.72 11,398,192.28- Fund Transfers484,6747,056.17- 14,112.34- 470,561.66- Miscellaneous26,797.2828,972.64168,236.71 103,260 - - TOTAL REVENUES14,932,1841,280,793.082,338,207.152,948,406.77 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers -- 27,366 - - - TOTAL NON DEPARTMENTAL-- 27,366 - - -27,366.00 BUSINESS OFFICE Personnel Services380,00236,462.99 71,511.57-58,789.46 321,212.54- Supplies5,400154.25418.3392.66572.58328.67 Human Services100----- Operations Support114,00015,451.10-7,954.8613,631.1034.40 Staff Support7,10060.3794.26490.45154.63354.26 Professional Services16,0001,897.62395.002,127.114,357.43 12,037.57- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300420.00--840.003,100.00 Operating Equipmen500.005,965.62500.005,432.06 t 6,200 - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE54,446.331,407.59 78,845.2088,142.27 9,249.39 513,415.00 600,102 W & S ADMINISTRATION Personnel Services1,178,781120,309.50 230,455.04-186,180.00 992,601.00- Supplies200,7002,456.314,458.813,774.376,308.3910,350.11 Human Services1,000----- City Support Services144,00828,610.66 29,103.83-28,610.66147.99 Utility Services2,634,344285,341.67 203,862.32-607,207.10 2,026,330.91805.99 Operations Support8,750255.98-345.88255.98- Staff Support33,000634.08294.542,473.451,010.522,524.60 City Assistance1,91215.00-102.0015.00- Professional Services187,4001,344.00-7,444.081,344.002,083.60 Fund Charges/Transfers2,623,507289,996.94 210,151.65-474,564.67 2,148,942.33- Maintenance Services5,497,250455,975.9212,287.43457,542.17671,592.2155,679.75 Other Costs35,0001,250.00-620.001,250.00 33,750.00- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353---- 1,230,353.00- Rental-Leasing6,070--662.53-- Operating Equipment8,000----- Capital Outla70,000.0070,000.0042,784.00 y 114,000 -22,432.00 -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,904,0751,256,190.0617,040.78 2,048,338.531,168,969.32 114,376.04 11,758,401.2115.43% MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,000 1,750.79--1,750.79 48,000.00- Maintenance Services22.35 - 334,500 - - - 22.351,750.79 TOTAL AVIATION HEIGHTS WTR IMP 400,000 -1,750.79 -400,000.00 FM3009 RD&BRIDGE EXPANSION Professional Services-- 19,137.50--405.00 Maintenance Services 29.03 - - - - - - 405.00 (405.00) TOTAL FM3009 RD&BRIDGE EXPANSION - - -19,166.53 TOTAL MISC & PROJECTS19,188.881,750.79405.00 400,000 -1,750.79 TOTAL EXPENDITURES14,931,5431,310,63620,1991,276,3002,128,935124,030 ** REVENUE OVER(UNDER)EXPENSES **819,472.25 641 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 35,061.00 - 000-421490Tower Leasing180,000 - - - TOTAL Franchises 180,000 - 35,061.00- - - 180,000.00 Fees 000-455200Garbage Collection Fee 3,400,000 296,942.87 518,753.63- 614,635.87 - 2,785,364.13 000-455600Fire Line Fees 19,000 340.00 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 20,247.10 25,903.02- 43,307.91 - 197,692.09 000-455800W&S Line Constructn Reimbursemnt50,000 1,139.00 - 4,754.95 5,310.08 - 44,689.92 000-457100Sale of Water 7,210,000 640,467.36 1,158,664.39- 1,469,057.66 - 5,740,942.34 000-457110Edwards Water Lease 166,250 6,617.50 59,507.50- 13,235.00 - 153,015.00 000-457120Water Transfer Charge-Selma 5,000 - - - 1,376.83 - 000-457130Water Transfer Charge-U. C. 1,000 - - - 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 3,024.00 18,049.56- 8,089.00 - 81,911.00 000-457400Sewer Charges 2,800,000 263,687.00 442,769.24- 555,936.78 - 2,244,063.22 000-457500Water Penalties 180,000 14,094.80 26,909.93- 32,608.62 - 147,391.38 000-459200NSF Check Fee-Water&Sewer2,000380.00431.29610.00 - - TOTAL Fees14,164,2501,246,939.63 2,274,173.51-2,766,057.72 - 11,398,192.28 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 7,056.17- 14,112.34 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 484,674 7,056.17 - 14,112.34- - 470,561.66 Miscellaneous 000-490000Misc Charges 10,000 25.00 - 240.00 25.00 - 000-491000Interest Earned 1,000 173.11 - 533.27 357.12 - 000-491200Investment Income 6,000 579.00 - 1,009.83 - 000-493400Donations-Christmas Activitise - - - - - - 000-496050SSLG - SAWS Reservation - - 134,500.00- - - (134,500.00) 000-497000Misc Income-W&S 320.87 (4,151.23)- 6,645.46 - - (6,645.46) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 25,699.30 24,940.96- 25,699.30 - 50,615.70 000-498200W&S Project Reimbursement5,118.30 - - - - - TOTAL Miscellaneous 103,260 26,797.28 28,972.64- 168,236.71 - (64,976.71) TOTAL REVENUES14,932,1841,280,793.08 2,338,207.15- 2,948,406.77 - 11,983,777.23 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking444,092.72$ Cash in Investment Pools Lone Star Investment-Water&Sewer1,357,930.27 Lone Star Investment-W&S Customer Deposits293,713.52 Lone Star Investment-W&S Equip Replacement373,130.08 Lone Star Investment-W&S Veh Replacement544,068.25 Lone Star Investment-Water/SSLGC SAWS269,210.45 Schertz Bank & Trust-Certificate of Deposit1,044,420.00 $3,882,472.57 Total Cash in Bank & Investment Pools4,326,565.29$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 250,420.88 851,421.07- 504,692.86 - 3,584,240.14 Inter-Jurisdictional1,438,836 206,592.93 291,890.44- 422,802.17 - 1,016,033.83 Miscellaneous15,319.18-21,331.0620,776.11 256,000 - TOTAL REVENUES 472,332.99 - 1,164,642.57 948,271.14 - 4,835,497.86 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,572,989271,056.4868.00464,577.61432,055.16 - 2,141,001.84 Supplies 20,695.31 13,149.22 48,921.09 57,893.37 31,407.54 324,039 Human Services - - - 800 - - City Support Services 10,277.40 10,902.09- 10,277.40 45,407 - 35,129.60 Utility Services 7,788.00 10.41 8,211.38 8,250.35 103,859.07400.99 112,500 Operations Support 2,267.80 364.65 16,045.73 22,416.47 808.80 45,600 Staff Support 6,009.06 449.08 5,665.95 7,080.53 11,729.82 72,400 City Assistance 250.00 - 72.00 250.00 9,000 - 8,750.00 Professional Services 3,623.47 133.00 27,429.19 24,324.98 10,179.21 164,200 Fund Charges/Transfers2,084,785 118,481.33 276,890.57- 234,604.79 - 1,850,180.21 Maintenance Services 150.00 - 7,317.08 16,400.00450.00 37,700 Debt Service - - - 111,176 - - 111,176.00 Rental-Leasing - 836.33 - 20,000.00 20,000 - - Operating Equipment 15,649.81 820.75 210.00 31,047.46 4,974.70 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 456,248.66 14,995.11 867,079.02 828,650.51 75,901.06 4,824,039.54 5,713,596 TOTAL EXPENDITURE456,248.6614,995.11867,079.02828,650.51 S 5,713,596 75,901.06 ** REVENUE OVER(UNDER) EXPENSES 119,620.63 * 70,173 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 242,035.88 - 843,701.07 496,287.86 13.00% -3,322,445.14 000-456110Subscription Program Fees55,000 8,385.00 - 7,720.00 8,405.00 15.28% -46,595.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,933250,420.88 851,421.07- 504,692.86 -3,584,240.14 Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 68,250.58 - 48,787.67 136,501.16 47.71% -149,624.84 000-474300Cibolo Support222,018 53,325.00- 55,524.98 - -166,493.02 000-475100Comal Co ESD #6 82,875 (18,293.44)- 18,960.00 - -63,915.00 000-475200Live Oak Support 148,125 40,082.38 37,031.25- 40,082.38 -108,042.62 000-475300Universal City Support 226,168 51,103.13- 56,562.83 - -169,605.17 000-475400Selma Support 67,618 17,182.50- 16,910.85 - -50,707.15 000-475500Schertz Support 384,046 96,046.91 96,864.87- 96,046.91 -287,999.09 000-475600Santa Clara Support 2,213.068,849 - 2,633.67 2,213.06 -6,635.94 000-475800Marion Support13,0113,255.79- - - - TOTAL Inter-Jurisdictional1,438,836206,592.93 291,890.44- 422,802.17 -1,016,033.83 Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 35.89 - 127.19 70.69 - - 000-493203Donations-EMS 6,000 175.00 - 250.00 200.00 -5,800.00 000-493204Donations-Dilworth Fund - - - 0.00% - - - 000-493205Donations- Golf Tournament - - - 0.00% - - - 000-497000Misc Income 150,000 1,708.29 - 7,227.19 6,905.42 -143,094.58 000-497100Recovery of Bad Debt 100,000 - 1,496.68 - - -100,000.00 000-497500Misc Income-EMT Classes12,230.0013,600.00 - 13,400.00 - - TOTAL Miscellaneous256,00015,319.18 21,331.06-20,776.11 -235,223.89 TOTAL REVENUES5,783,769472,332.99 1,164,642.57- 948,271.14 -4,835,497.86 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank $ (397,435.33) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010300,818.42 $(96,616.91) 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: NOVEMBER 30th, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60062,240.01 116,767.41- 130,886.55 -578,713.45 Fund Transfers - - - - - - - 0.00% Miscellaneous900270.49136.31 69.30 - - TOTAL REVENUES 62,309.31710,500117,037.90 -131,022.86579,477.14 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 371,06839,354.80 67,648.05- 59,966.36 -311,101.64 Supplies 8,300 219.22 - 96.08 319.62 7,935.3845.00 Human Services 325 - - - - -325.00 City Support Services 35,899 1,508.72 - 1,345.04 1,508.72 -34,390.28 Utility Services 14,688 1,977.51 - 1,247.16 1,977.51 12,404.51305.98 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 109.20 43.02 312.48 389.18 7,903.7055.14 City Assistance 840 57.00 - 15.00 57.00 -783.00 Professional Services 19,800 - - - - -19,800.00 Fund Charges/Transfers 199,87611,785.92 - 23,571.84- -176,304.16 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 55,012.37701,72543.0270,663.8187,790.23613,571.67 406.12 TOTAL EXPENDITURE 55,012.37701,72543.0270,663.8187,790.23613,571.67 S 406.12 ** REVENUE OVER(UNDER) EXPEND8,77543,232.63 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 624.36 812.35 4,000 425.63 -3,187.65 000-457600Drainage Fee 61,814.38-116,143.05130,074.20 -575,525.80 705,600 TOTAL Fees62,240.01 116,767.41-130,886.55 578,713.45- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 64.26 11.27 100 6.56 - 000-491200Investment Interest - 123.13 113.49 600 58.12 -486.51 000-497000Misc Income-Drainage-83.1011.55 200 4.62 - TOTAL Miscellaneous - 270.49 136.31 900 69.30 -763.69 TOTAL REVENUES62,309.31 117,037.90- 131,022.86 579,477.14- 710,500 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Ban k Claim on Operating Cash Pool-Checking 106,389.08 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,194.13 Total Cash in Bank & Investment Pools$389,583.21 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 32,227.99 - 2,545.10 2,318.32 -388,435.68 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50019.33-89.7134.64 - TOTAL REVENUES 32,247.32411,386-2,634.812,352.96409,033.04 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 213.00 - 231.08 - -2,481.92 City Support Services 20,407.0085,948 - 502.85 20,407.00 -65,541.00 Operations Support 74,000 6,741.25 346.04 - 7,087.29 1,117.59 Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 193,876 11,885.50 - 23,771.00- -170,105.00 Operating Equipment 52,562 6,645.00 6,645.00 - 6,645.00 285.00 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 45,678.75411,3867,204.04502.8558,141.37359,046.08 L 1,402.59 TOTAL EXPENDITURE 45,678.75411,3867,204.04502.8558,141.37359,046.08 S 1,402.59 (55,788.41) REVENUE OVER(UNDER) EXPENDITURE - 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 32,227.992,545.102,318.32388,435.68 - - TOTAL Taxes 390,754 32,227.99 - 2,545.10 2,318.32 - 388,435.68 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned30010.56-62.6519.66 - 280.34 000-491200Investment Interest 200 8.77 - 27.06 14.98 - 185.02 000-497000Misc Income-- - - - - - TOTAL Miscellaneous50019.33-89.7134.64 - 465.36 TOTAL REVENUES 411,386 32,247.32 - 2,634.81 2,352.96 - 409,033.04 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking168,205.98$ Cash in Investment Pools Federated Investment-Hotel/Motel78,141.02 Total Cash in Bank & Investment Pools$246,347.00 33 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 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: NOVEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 - 46,575.00- - -203,425.00 Tree Mitigation Fees 75,000 - - - - -75,000.00 Miscellaneous600-149.3487.98 49.68 - TOTAL REVENUES 49.68325,600-149.3446,662.98278,937.02 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - - - -13,000.00 Maintenance Services-Landscape 3,500 - - - - -3,500.00 Operating Equipment 32,000 - 8,425.36 2,781.20- - Capital Outlay169,000 ----145,584.00 23,416.00 TOTAL PARKLAND DEDICATION -217,500-8,425.36-191,302.80 26,197.20 TREE MITIGATION Maintenance Services-Trees28,500 14,298.00- 390.00 - -28,110.00 Capital Outlay -18,000--19,900.00 - TOTAL TREE MITIGATION -46,500-14,298.0020,290.00 - TOTAL EXPENDITURE -264,000-22,723.3620,290.00217,512.80 S 26,197.20 REVENUE OVER(UNDER) EXPEND 26,372.9861,600 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 - 46,575.00- 203,425.00- - 000-458900Tree Mitigation -75,000--- - TOTAL Fees 325,000 - 46,575.00- 278,425.00- - Miscellaneous 000-491000Interest Earned 100 3.21 - 69.20 6.03 93.97- 000-491200Investment Interest 500 46.47 - 80.14 81.95 418.05- 000-497000Miscellaneous Income--- - - - TOTAL Miscellaneous60049.68-149.3487.98 512.02- TOTAL REVENUES 325,600 49.68 - 149.34 46,662.98 278,937.02- 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking$39,115.03 Cash in Investment Pools Federated Investment-Park Fund252,738.85 Federated Investment-Tree Mitigation126,268.25 Total in Investment Pool 379,007.10 Total Cash in Bank & Investment Pools$418,122.13 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.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: NOVEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.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: NOVEMBER 30th, 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: NOVEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 83,992.00 633,173.83- 227,040.00 -2,498,360.00 Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous314,000 590.28(442.04)2,067.79 - - TOTAL REVENUES13,713,000 84,582.28632,731.79229,107.7913,483,892.21 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50- Professional Services 22,000 354.45 - 354.16 707.07 -21,292.93 Maintenance Services 10,000 - - - - -10,000.00 Fund Charges/Transfers - - - - 0.00% - - Debt Service - - - - 0.00% - - Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000 354.458,782.16707.07 L - 108.50 MISC & PROJECTS Projects13,025,00023,916.0035,663.2553,183.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 Plant29.03- 0.00% - - - - Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP225,148.72- A - - - - TOTAL MISC & PROJECTS13,624,643 23,916.0035,663.25278,361.1110,488.4213,649,817.83 - TOTAL EXPENDITURE13,662,643 24,270.4535,663.25287,143.2711,195.4913,687,002.26 S 108.50 REVENUE OVER(UNDER) EXPENDITURES50,357 217,912 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 55,896.00 401,323.34- 154,536.00 -1,325,064.00 000-455910Capital Recovery - Waste Wtr613,800 28,096.00 231,550.49- 72,504.00 -541,296.00 - - - 0.00% 000-455911Capital Recovery-Wste Wtr Zone 1 - - - 000-455913Cap Recovery-North Sewer Tr632,000 -300.00- - - TOTAL Fees 2,725,400 83,992.00 633,173.83- 227,040.00 -2,498,360.00 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 Earned50021.02-151.7835.15 - 000-491200Investment Income 30,000 3,992.53 - 4,828.67 7,336.19 -22,663.81 000-491800Gain/Loss - - (27.78) - (27.78) - 000-491900Unrealized Gain/Loss-Cap One (5,422.49)- (5,275.77) - (3,395.49) -5,275.77 000-497000Misc Income - - - 0.00% - - - 000-498100Reimbursmnt - FM 78 Project - - - 0.00% - - - 000-498200Re-imbursement-Water Meters283,500 - -- - - TOTAL Miscellaneous314,000590.28-(442.04)2,067.79 -311,932.21 TOTAL REVENUES13,713,000 84,582.28 632,731.79- 229,107.79 1.67% -13,483,892.21 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking412,329.57$ Cash in Investments: Lone Star Investment-Capital Recovery Water452,752.69 Lone Star Investment-Capital Recovery Sewer280,474.48 Capital One-Investment1,709,100.74 Schertz Bank & Trust-Certificate of Deposit525,465.15 Total Cash in Bank & Investment Pools$3,380,122.63 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ****************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 153,319.324,281,098 - 832,688.05 1,108,945.16 25.90% -3,172,152.84 - - - - 0.00% Fund Transfers - - Miscellaneous 1,814.692,25014,464.673,455.60 - - TOTAL REVENUES 155,134.014,283,348847,152.72 -1,112,400.763,170,947.24 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL - - - - 0.00% Professional Services - - Debt Service -4,276,6674,664.58-4,276,666.50 - - TOTAL GENERAL GOVERNMEN -4,276,6674,664.58-4,276,666.50 T - - TOTAL EXPENDITURE -4,276,6674,664.58-4,276,666.50 S - - ** REVENUE OVER(UNDER) EXPEND6,682 1,112,400.76 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 153,319.32832,688.051,108,945.16 - - TOTAL Taxes4,281,098153,319.32 832,688.05-1,108,945.16 - 3,172,152.84 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- 8.32 - 000-491200Investment Earnings1,5001,814.6955.26 3,447.28 - - TOTAL Miscellaneous 2,250 1,814.69 14,464.67- 3,455.60 - (1,205.60) TOTAL REVENUES4,283,348 155,134.01 847,152.72- 1,112,400.76 - 3,170,947.24 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 505-TAX I & S***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% 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 - - 4,664.58 - -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 - - - - 370,000.00 - 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 Interest90,000 -- - - - TOTAL Debt Service4,276,667--4,664.58- -4,276,666.50 TOTAL EXPENDITURES4,276,667 - - 4,664.58 - -4,276,666.50 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking99,162.18$ Cash in Investment Pools MBIA Investment- Tax I&S1,110,214.90 Federated Investment-Tax I&S56.81 Total Cash in Bank & Investment Pools$1,209,433.89 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042231,817.79 - 2,470.59 447,844.14 - 1,944,197.86 Fund Transfers - - - 0.00% - - - Miscellaneous 175.6717,200(1,870.82)317.48 - - ,,,.. -,., TOTALREVENUES24092422319934659977448161621961 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 21,000 2,140.90 579.81 3,369.05 3,088.13 4,271.96 Utility Service 87,500 3,689.29 - 4,286.14 6,751.89 - 80,748.11 Maintenance Services 72,300 5,294.08 632.25 17,770.73 9,412.96 9,783.69 Operating Equipment - 6,999.31 - 0.00% - - - Capital Outlay --- - - - TOTAL NONDEPARTMENTA 11,124.27180,8001,212.0632,425.23 14,055.6519,252.98148,703.43 L ECONOMIC DEVELOPMEN T Personnel Services 240,677 18,037.75 31,487.22- 37,841.66 - 202,835.34 Supplies 1,100 37.51 - 153.03 37.51 105.82 Human Services 200 - - - - - City Support Services 43,328 3,320.37 1,363.42 3,990.24 4,683.79 4,613.11 Utility Services 7,200 112.23 - 286.13 139.63 25.99 Operations Support 63,600 521.00 4,813.35 4,126.54 5,334.35 2,616.56 Staff Support 112,800 53,271.26 937.31 50,219.86 54,208.57 3,827.35 City Assistance 300,000 10,000.00 - 10,000.00- - 290,000.00 Professional Services 303,500 30,734.46 30,935.60 27,338.80 30,935.60 - 303,500.00 Fund Charges/Transfers 105,985 4,665.42 - - 9,330.84 - 96,654.16 Fund Replenish-Fund Balance 220,000 - - - - - 220,000.00 Maintenance Services - - - 0.00% - - - Debt Service 795,154 - - - 795,154.00 - - Operating Equipment -2,350-- - - TOTAL ECONO DEVELOPMEN 120,700.002,195,89438,049.68117,601.82 11,188.83152,511.952,070,242.90 T TOTAL EXPENDITURE 131,824.272,376,69439,261.74150,027.05 25,244.48171,764.932,218,946.33 S ** REVENUE OVER(UNDER) EXPEND32,548 276,396.69 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET16.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042231,817.792,470.59447,844.14 - - TOTAL Taxes2,392,042231,817.79 - 2,470.59 447,844.14 -1,944,197.86 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 18.75 - - 43.11 - 000-491200Investment Earnings 15,000 156.92 (2,085.12)- 274.37 -14,725.63 000-497000Misc Income 2,000 - 214.30 - - -2,000.00 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 175.67 (1,870.82)- 317.48 - TOTAL REVENUES2,409,242231,993.46-599.77448,161.62 -1,961,080.38 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking380,124.04$ Cash in Investment Pools MBIA Investment-Economic Development Corp1,315,949.54 Schertz Bank & Trust-Certificate of Deposit506,692.64 Schertz Bank & Trust-Certificate of Deposit1,031,406.35 Total Cash in Bank & Investment Pools3,234,172.57$ 50 4B SALES TAX $300,000 40% $250,000 13% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 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 NOVEMBER 30th, 2011 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,795,645.58,905,998.83.0500,186,056.76,296,410.01,795,645.58,795,645.58 305622 TOTAL OPERATIONS2,795,645.58,905,998.83,186,056.76,296,410.01,795,645.58,795,645.58 35622 LOGIC General Fund1,706,135.1254,875.83.1874 -51,259.29,706,135.12 N/A,706,135.12 90711 G/F-Equipment Replacement73,318.6873,307.390.1874 -11.2973,318.68 N/A73,318.68 G/F-Vehicle Replacement7,076.79,075.70.1874 -.09,076.79 N/A,076.79 70177 G/F-Air Conditioner Replacement146,386.90122,364.350.1874 -24,022.55146,386.90 N/A146,386.90 ,211,227.48.187440.60-,211,568.08,211,568.08 SR2009 Bond-Street Projects(II)2,211,568.08 20322 TOTAL LOGIC4,144,485.57,368,850.75 -75,634.82,144,485.57,144,485.57 3744 LONESTA R Capital Recovery - Sewer280,474.48280,416.910.2500 -57.57280,474.48 N/A280,474.48 Capital Recovery - Water452,752.6952,659.77.2500 -2.9252,752.69 N/A52,752.69 40944 Drainage Fund283,194.13283,136.010.2500 -58.12283,194.13 N/A283,194.13 GO SR2011 Animal Shelter2,250,906.61,268,034.19.250063.067,590.64,250,906.61 N/A,250,906.61 204122 GO SR2011 Athletic Fields1,480,166.211,491,576.160.2500304.5111,714.461,480,166.21 N/A1,480,166.21 GO SR2011 Soccer Fields1,500,604.40,512,022.78.250008.701,727.08,500,604.40 N/A,500,604.40 103111 GO SR2011 Swimming Pool2,936,539.403,024,045.560.2500609.8688,116.022,936,539.40 N/A2,936,539.40 W/S-Customer Deposits293,713.5293,653.24.2500 -0.2893,713.52 N/A93,713.52 20622 W/S-Equipment Repl/Cap.Imp373,130.08373,053.500.2500 -76.58373,130.08 N/A373,130.08 Water&Sewer1,357,930.2757,655.05.2500 -00,275.22,357,930.27 N/A,357,930.27 80511 W/S-Vehicle Replacement544,068.25543,956.580.2500 -111.67544,068.25 N/A544,068.25 34,655.20.250034,555.25-69,210.4569,210.45 Water/SSLG - SAWS269,210.45 10122 TOTAL LONESTA12,022,690.491,514,864.9536,973.7429,148.202,022,690.492,022,690.49 R16111 MBIA Tax I&S1,110,214.9088,600.010.15001,021,614.89-1,110,214.90 N/A1,110,214.90 Police Forfeiture359,199.4359,156.57.1500 -2.8659,199.43 N/A59,199.43 30433 Economic Development Corporation1,315,949.541,015,792.620.1500 -300,156.921,315,949.54 N/A1,315,949.54 Special Events Fund66,570.476,562.49.1500 -.986,570.47 N/A6,570.47 60766 EMS Tax Notes 2010300,818.4200,782.53.15005.89-00,818.4200,818.42 30333 TOTAL MBIA3,152,752.761,830,894.221,321,858.54-3,152,752.763,152,752.76 FEDERATED SR2007a Bond-City Wide Projects867,884.4567,787.08.1400 -7.3767,884.45 N/A67,884.45 80988 Hotel Occupancy Tax78,141.0278,132.250.1400 -8.7778,141.02 N/A78,141.02 Park Fund (Developers Fee)252,738.8552,710.49.1400 -8.3652,738.85 N/A52,738.85 20222 Park Fund (Tree Mitigation)126,268.25126,250.140.1700 -18.11126,268.25 N/A126,268.25 Tax I&S56.816.80.1700 -.016.81 N/A6.81 50055 Library Board Fund44,689.184,684.17.1400.01-4,689.184,689.18 40544 TOTAL FEDERATED1,369,778.561,369,620.93 -157.631,369,778.561,369,778.56 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,269,453.74,319,400.21.0100 276.76,649.81,321,773.26 N/A,334,578.22 13211 Capital One Capital Recovery1,629,957.83,725,998.57.7100,110.13354.45,729,754.25,709,100.74 12411 TOTAL CAPITAL ONE2,899,411.573,045,398.78 631.216,759.943,051,527.513,043,678.96 52 City Portfolio By Investment Type Schertz Bank &Trust C.D.s 10% Operations Account Schertz Bank & Trust 5% Capital One Managed 9% LOGIC Pool FEDERATED Pool 21% MBIA Pool 16% LONESTAR Pool 13% 54 City Portfolio By Use Pooled-Daily Operations, $2,795,646 Designated Funds, $7,227,711 Special Revenue Funds, $7,219,208 Debt Service Fund $809,074.07 MONTHLY YIELDS 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.0200 1 Month T-Bill 0.01000.0100 3 Month T-Bill 0.06000.0600 6 Month T-Bill 0.46000.5200 Schertz Portfolio 0.05000.0500 Schertz Bank&Trust 1.10001.1000 CD 365 Days 0.80000.8000 CD 180 Days 0.25000.2500 CD 90 Days 0.05000.0500 CD 28 Days 0.14700.1874 LOGIC 0.23000.2500 LoneStar 0.14000.1500 MBIA 0.09000.1400 Federated 2.32432.8400 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:11/30/2011 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69114,453.7414,453.7414,453.741.000.01 General Elec Cap Corp Disc Com Paper3/12/2012103.0065,000.0064,891.2264,891.220.000.00 JPMorgan Chase Disc Bank Accpt Note3/1/201292.0065,000.0064,941.4564,941.45 Total Cash & Equivalent44,453.7144,286.4144,286.41 s141 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014987.00125,000.00141,987.30141,416.256,875.00 Federal Home Loan Bks Cons Bds6/21/2013569.0080,000.0082,004.4081,909.601,500.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012322.00150,000.00162,031.50155,613.006,750.00 Federal Home Ln Mtg Corp Deb11/15/2013716.00170,000.00191,084.25184,852.908,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013664.00250,000.00250,000.00268,090.0010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141091.00100,000.0099,874.40100,066.00750.00 250,505.00251,747.50 Federal Natl Mtg Assn 4/20/2012142.00250,000.00 Total Fixed Incom,125,000.01,177,486.8,183,695.2 e105153 Total Assets528.821,269,453.741,321,773.261,327,981.663 Cap Recovery Fun d Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #69124,957.8324,957.8324,957.832.000.01 General Elec Cap Corp Disc Coml Paper3/12/2012103.0085,000.0084,857.7484,857.740.000.00 JPMorgan Chase Disc Bank Accpt Note3/1/201292.0085,000.0084,923.4384,923.43 Total Cash & Equivalent94,957.8194,739.094,739.0 s13010 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014987.00165,000.00187,423.24186,669.459,075.00 Federal Home Loan Bks Cons Bds6/21/2013569.00100,000.00102,505.50102,387.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012322.00250,000.00270,052.50259,355.0011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013716.00250,000.00281,006.25271,842.5012,187.00 Federal Natl Mtg Assn Nts10/15/2013685.00200,000.00223,001.60215,862.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141091.00120,000.00119,849.28120,079.20900.00 Federal Natl Mtg Assn10/30/2012335.00250,000.00250,192.50250,695.001,250.00 US Treasury Note12/15/201115.00100,000.00100,984.38100,055.00 Total Fixed Incom,435,000.01,535,015.2,506,945.1 e105154 Total Assets530.051,629,957.831,729,754.251,701,684.154