Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03-DECEMBER 2011 FINANCIAL STATEMENT
DECEMBER 2011 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department January 23, 2011 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,7252,782,930.46 4,363,018.36-5,475,605.33 - 6,328,119.67 Franchises 1,617,000 221.84 398,372.61- 428,099.69 - 1,188,900.31 Permits 1,187,800 63,248.00 598,909.33- 201,076.00 - 986,724.00 Licenses 31,300 4,202.50 - 6,877.10 7,287.50 - 24,012.50 Fees 3,341,727 156,508.79 725,763.50- 504,733.52 2,836,893.48100.00 Fines 30,000 1,712.53 - 6,442.89 5,572.56 - 24,427.44 Inter-Jurisdictional 571,245 24,074.61 96,269.30- 105,939.28 - 465,305.72 Fund Transfers 1,760,658 108,750.59 316,615.75- 326,251.77 - 1,434,406.23 Miscellaneous615,50034,976.70178,262.41187,445.08(178.90) - TOTAL REVENUES20,958,9553,176,626.026,690,531.257,242,010.73(78.90) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,813.46 - 5,397.96 5,137.80 - 17,662.20 Supplies500 76.00 - 22.00 95.98 - City Support Services 20,500 355.90 219.98 11,948.24 766.86 81.75 Utility Services - - - - - - Operations Support 300 - - - - - Staff Support17,4006,074.632,150.00 8,118.8214,278.851,027.80 Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 8,319.99 2,369.98 25,487.02 20,279.49 1,109.55 CITY MANAGE R Personnel Services749,72654,146.62 162,809.81-168,153.90 - 581,572.10 Supplies5,331 422.32 268.94 115.29 905.27 1,208.47 3,486.20 - - - - City Support Services - - Operations Support - - - - - - Staff Support 25,550 1,184.20 1,527.05 8,442.49 10,392.14 3,121.49 Operating Equipment -133.43 - - - - TOTAL CITY MANAGER 780,607 55,753.14 171,501.021,795.99 179,451.31 4,329.96 598,621.72 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services254,333 16,925.90 - 57,178.40 56,287.26 - 198,045.74 Supplies2,500 - 99.00 448.59 264.39 132.81 2,201.80 City Support Services1,000 - - - - - Operations Support 3,000 858.00 700.00 - 1,558.00 - Staff Support 5,500 492.32 285.20 821.95 1,162.57 41.09 Court Support 800 - - - - - Professional Services 71,100 4,097.50 12,180.00- 13,626.25 23,012.50 Maintenance Services 2,200 (17.31) - - 249.94 - Operating Equipment1,000100.00497.14 597.14500.00 - TOTAL MUNICIPAL COURT 22,456.41341,433 1,581.34 71,128.94 73,745.55 23,186.40 246,082.39 CUSTOMER RELATIONS-311 Personnel Services108,506 5,947.48 - 19,879.44 19,856.34 - 88,649.66 Supplies300 - - - - - Staff Support1,100 -- - - - Operating Equipment50050.00 50.00- - - TOTAL CUSTOMER RELATIONS-311 110,406 5,997.48 19,879.44- 19,906.34 - 90,499.66 PLANNING & ZONING Personnel Services 216,383 9,382.09 31,168.04- 30,929.87 - 185,453.13 Supplies 2,700 85.73 156.45 24.75 246.52 186.61 Operations Support 750 - - - - - Staff Support 17,150 (142.90) 548.55 2,963.18 1,720.85 43.06 Professional Services 76,650 6,910.38 1,366.40 9,060.06 8,276.78 - 69,739.62 Operating Equipment3,500 --2,112.00 - - TOTAL PLANNING & ZONING317,13316,235.302,071.4043,216.0341,174.022,341.67 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: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services642,762 37,871.58 - 159,212.24 131,152.77 - 511,609.23 Supplies57,100 6,579.69 1,224.76 14,414.57 14,932.60 7,567.54 35,824.62 Utility Services111,000 6,019.46 - 11,136.08 12,811.73 - 98,188.27 - - - - Operations Support - - Staff Support 11,179 1,152.87 41.35 3,360.26 2,235.88 2,558.16 Maintenance Services 106,450 8,480.06 673.05 46,096.95 18,935.43 9,364.47 Rental/Leasing 1,400 - - 456.96 - - Operating Equipment2,500 -- - - - Capital Outlay24,500 -- - - - TOTAL FACILITIES MAINTENANCE 956,891 60,103.66 1,939.16 234,677.06 180,068.41 19,490.17 CITY SECRETAR Y Personnel Services 163,417 11,427.31 38,970.94- 35,712.19 - 127,704.81 Supplies 1,250 161.08 - 85.80 175.80 67.09 City Support Services 9,780 - - 1,400.00 - - Staff Support8,6051,102.52 1,803.451,130.40231.00 - TOTAL CITY SECRETARY 183,052 12,690.91 41,587.14- 37,691.44 298.09 NON-DEPARTMENTA L Supplies 2,500 - - - 10.71 - City Support Services 665,127 39,667.21 1,294.02 190,923.57 168,395.27 - 498,025.75 Operations Support 139,000 28,344.98 1,076.05 19,170.54 42,659.59 52.31 Staff Support - - - - - - City Assistance 459,046 - 96,864.87- 96,046.91 - 362,999.09 Professional Services 157,150 2,948.13 - 8,491.08 7,748.35 - 149,401.65 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,433,673 70,960.32 2,370.07 315,450.06 314,860.83 1,121,129.9352.31 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services214,010 19,650.16 - 32,905.45 52,545.12 - 161,464.88 Supplies2,900 151.59 - 45.05 751.55 63.81 2,084.64 Operations Support35,100 5,658.25 4,989.75 2,565.47 6,620.27 705.81 32,763.67 Staff Support4,350 92.99 196.44 662.87 870.23 147.50 3,528.71 Operating Equipment300 -- - - - TOTAL PUBLIC AFFAIRS 256,660 25,552.99 5,186.19 36,178.84 60,787.17 917.12 RECORDS MANAGEMEN T Personnel Services 47,294 3,108.48 10,979.45- 10,721.76 - 36,572.24 Supplies 750 71.00 - - 71.00 - Staff Support 1,500 85.00 - 85.00 85.00 159.40 Professional Services 15,000 149.00 - 1,368.00 1,055.50 - 13,944.50 Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 64,544 3,413.48 12,432.45- 11,933.26 159.40 SCHERTZ TALES MAGAZINE Personnel Services 128,605 9,089.98 26,745.93- 27,738.22 - 100,866.78 Supplies 200 - - - - - Opperations Support 200 - - - - - Staff Support 1,500 12.83 - - 85.74 31.23 Professional Services302,70026,138.94 71,846.8257,185.368,352.86 - TOTAL SCHERTZ TALES MAGAZINE 433,205 35,241.75 83,931.29- 99,670.78 8,384.09 ENGINEERING Personnel Services 163,904 4,843.95 38,605.75- 18,984.41 - 144,919.59 Supplies 400 - - 67.35 33.19 32.50 City Support Services - - - - - - Utility Services 600 - - - - - Staff Support 2,213 130.00 - 265.00 130.00 - Professional Services 48,165 21,180.00 - 1,710.00 25,455.00 - 22,710.00 Maintenance Services 4,044 - - 2,145.29 3,345.29 - Operating Equipment -- - - - - Capital Outlay26,00023,714.00 23,714.00-1,737.31 - TOTAL ENGINEERING 245,326 49,867.95 42,793.39- 71,661.89 1,769.81 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services120,967 8,311.99 - 26,570.20 26,148.95 - 94,818.05 Supplies3,500 253.91 - - 253.91 293.46 2,952.63 Staff Support4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 130,517 8,565.90 26,570.20- 26,402.86 293.46 TOTAL GENERAL GOVERNMENT 5,572,947 375,159.28 17,314.13 1,124,832.88 1,137,633.35 62,365.21 PUBLIC SAFETY POLICE Personnel Services4,509,076 299,631.67 - 1,018,110.07 1,004,841.93 - 3,504,234.07 Supplies31,957 2,754.09 4,761.16 3,225.20 5,912.02 788.01 30,018.13 City Support Services35,000 - - - 19,518.41 - 15,481.59 Utility Services123,456 8,783.22 - 13,888.25 17,575.43 - 105,880.57 Operations Support1,500 - - 98.00 - 720.00 780.00 Staff Support58,372 1,864.71 1,732.17 1,016.74 4,844.89 1,223.05 54,036.23 City Assistance10,914 104.25 - 1,439.98 434.77 1,454.16 9,025.07 Professional Services20,000 642.85 - - 642.85 - 19,357.15 Maintenance Services44,435 5,540.00 - 14,851.50 5,540.00 - 38,895.00 Operating Equipment57,887 2,143.87 2,905.10 15,080.16 5,386.11 18,370.24 37,035.75 Capital Outlay142,52576,635.0012,554.80112,980.00155,076.05 - TOTAL POLICE 5,035,122398,099.6621,953.231,180,689.901,219,772.4622,555.46 FIRE RESCUE Personnel Services 2,495,242 174,741.71 585,745.23- 582,751.57 - 1,912,490.43 Supplies 20,500 248.17 9,239.99 1,207.63 10,144.53 563.30 Utility Services 57,000 4,716.60 7.64 8,049.82 9,003.08 - 48,004.56 Operations Support 800 - - - 115.00- Staff Support 120,185 4,335.40 19,618.33 22,295.55 31,481.01 12,356.49 City Assistance 18,600 8,122.00- 10,323.17 8,366.30 - 18,355.70 Professional Services 18,140 - - - 11,793.0022.19 Maintenance Services 56,000 1,053.53 3,710.01 3,409.45 4,859.34 2,594.36 Operating Equipment58,300 11,148.108,988.36 -15,553.04 -64,864.68 Capital Outlay35,000 -- - - 31,116.00 TOTAL FIRE 2,879,767 185,095.41 56,251.01 642,178.95 655,616.38 58,538.15 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services417,182 28,280.06 - 84,804.15 91,764.41 - 325,417.59 Supplies2,500 172.43 - 433.05 278.31 109.05 2,112.64 Utility Services6,500 475.07 - 1,033.40 857.47 - Operations Support 1,500 - - - - - Staff Support 8,000 200.64 581.37 1,132.14 1,402.91 - Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -- - - - TOTAL INSPECTIONS 446,68229,128.20581.3787,402.7494,303.10109.05 MARSHAL SERVICE Personnel Services 529,908 35,500.39 94,500.16- 121,810.91 - 408,097.09 Supplies 4,600 59.42 205.82 66.30 1,049.42 - Utility Services 12,000 862.71 - 915.76 2,136.11 - Operations Support 4,000 208.97 - 107.44 986.41 - Staff Support 15,400 577.29 410.00 473.61 3,342.67 500.00 Professional Services - - - - - - Maintenance Services 30,700 - - 1,884.00 4.00 - 30,696.00 Operating Equipment16,0001,047.702,206.37 3,863.585,649.873,041.26 Capital Outlay34,00031,022.05 31,022.0516,742.29 - - TOTAL MARSHAL SERVICE 646,608 69,278.53 2,822.19 118,553.14 166,001.44 3,541.26 TOTAL PUBLIC SAFETY 9,008,179 681,601.80 81,607.80 2,028,824.73 2,135,693.38 84,743.92 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services674,240 43,652.63 - 162,495.33 157,449.50 - 516,790.50 Supplies7,100 1,023.21 21.04 1,581.38 1,580.26 390.56 5,150.22 Utility Services113,900 8,531.75 - 17,546.78 21,956.88 - 91,943.12 - - - - Operations Support - - Staff Support 10,265 357.80 79.91 1,064.15 1,083.82 329.30 Maintenance Services 270,800 24,464.02 579.71 34,289.47 45,145.85 8,556.03 Rental/Lease 200 - - - - - Operating Equipment 4,200 804.00 - 4,200.00 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,080,70578,833.41680.66234,847.11230,702.309,275.89 TOTAL PUBLIC ENVIRONMENT 1,080,705 78,833.41 680.66 234,847.11 230,702.30 9,275.89 PARKS & RECREATION PARKS DEPARTMENT Personnel Services503,534 32,377.98 - 113,279.39 109,823.42 - 393,710.58 Supplies40,555 6,880.10 1,169.51 10,856.61 11,077.06 1,650.86 28,996.59 Utility Services113,000 3,885.08 - 11,271.27 15,988.21 - 97,011.79 Operations Support700 - - 600.00 - - Staff Support 8,573 1,324.76 60.93 2,422.82 3,172.56 945.55 Professional Services 62,610 3,850.00 - 8,045.00 7,421.50 - 55,188.50 Maintenance Services 22,000 685.39 44.99 8,706.35 5,037.24 1,112.01 Rental/Leasing 42,200 9,676.20 14,129.83- 13,031.80 29,028.60 Operating Equipment - - 3,395.00 - - - Capital Outlay -- - - - - TOTAL PARKS DEPARTMENT793,17258,679.511,275.43172,706.27165,551.7932,737.02 SWIM POOL Supplies 16,700 366.00 392.93 343.35 516.58 - 16,576.35 Utility Services 25,500 973.31 - 1,329.91 4,271.18 - 21,228.82 Staff Support 925 - - - 750.00 - Maintenance Services 199,378 4,000.00- - 4,000.00 - 199,378.00 Rental/Lease500 -- - - - TOTAL SWIM POOL 1,339.31243,003 4,392.93 1,673.26 9,537.76 - 237,858.17 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services106,977 4,424.50 - 11,223.10 13,733.59 - 93,243.41 Supplies7,300 949.89 1,127.61 3,852.12 2,312.69 480.34 5,634.58 Utility Services47,550 2,011.66 - 2,447.56 5,038.28 - 42,511.72 Operations Support15,200 1,090.80 - 95.00 1,398.61 787.15 13,014.24 Staff Support3,300 90.00 439.45 - 707.46 - Professional Services 1,600 - 150.00 825.00 150.00 - Operating Equipment5,0004,243.88 6,059.58100.00 - - TOTAL COMMUNITY/CIVIC CNTR186,927 5,960.948,566.85 18,542.78 29,400.21 1,267.49 162,220.24 TOTAL PARKS & RECREATION1,223,102 68,585.67 11,629.30 192,922.31 204,489.76 34,004.51 996,237.03 CULTURAL LIBRARY Personnel Services 686,050 49,431.16 156,749.35- 160,174.53 - 525,875.47 Supplies14,000 2,523.29 86.59 235.23 3,155.08 520.93 10,410.58 Utility Services41,000 2,802.00 - 6,240.43 6,689.37 - 34,310.63 Operations Support2,000 - 174.00 - 174.00 - Staff Support 4,215 - 58.97 182.17 167.45 375.00 Professional Services 2,100 2,140.00 - - 2,140.00 - Maintenance Services 2,400 - - 400.00 400.00 - Operating Equipment 75,000 12,230.59 2,366.43 14,522.36 15,585.54 7,235.92 Capital Outlay -- - - - - TOTAL LIBRARY 69,127.04826,765 2,685.99 178,329.54 188,485.97 8,131.85 632,833.17 TOTAL CULTURAL826,765 69,127.04 2,685.99 178,329.54 188,485.97 8,131.85 632,833.17 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services295,327 24,230.06 - 73,587.97 69,447.11 - 225,879.89 Supplies25,000 2,697.85 319.99 2,105.79 5,109.15 785.59 19,425.25 Utility Services11,200 488.24 - 1,065.08 1,238.96 - Operations Support 500 - - - - - Staff Support 11,560 420.40 34.48 1,524.24 1,855.88 508.76 City Assistance 10,000 1,021.13 - 1,559.59 2,516.82 - Professional Services 14,500 450.00 - 2,912.00 450.00 - 14,050.00 Maintenance Services 6,200 - - 966.78 2,340.00 220.50 Operating Equipment9,500379.99 -1,263.87110.51 - Capital Outlay -- - - - - TOTAL ANIMAL SERVICES383,78729,687.67354.4783,721.4584,221.791,625.36 TOTAL HEALTH 383,787 29,687.67 354.47 83,721.45 84,221.79 1,625.36 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 257,808 25,700.29 57,493.69- 64,693.38 - 193,114.62 Supplies 2,000 68.84 - 346.30 68.84 - City Support Services 372,354 7,340.21 34,365.43- 39,082.43 33,129.45 Utility Services 154,949 25,542.37 1,585.17 18,609.18 30,700.01 244.99 Staff Support 15,250 16.00 2,036.38 2,904.47 4,340.23 2,215.77 Professional Services 2,500 - - - - - Maintenance Services 12,500 4,657.74 - 6,950.07 4,657.74 1,074.70 Operating Equipment 129,315 3,282.46 4,911.44 22,793.01 10,925.07 7,397.30 Capital Outlay213,500 -- - - - TOTAL INFORMATION TECHNOLOGY1,160,176 66,607.91 8,532.99 143,462.15 154,467.70 44,062.21 970,179.08 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services295,638 14,560.54 - 42,010.96 47,673.59 - 247,964.41 Supplies1,329 598.97 - - 598.97 - Human Services 47,156 3,923.95 654.00 9,983.40 11,678.36 - 36,131.64 Operations Support 16,596 839.86 532.56 1,078.14 1,372.42 - 15,756.16 Staff Support 14,897 2,031.92 550.72 5,044.96 7,227.73 - City Assistance 9,860 276.00 - 724.00 791.00 249.00 Professional Services - - - - - - Operating Equipment4,162.83 4,162.83- - - - TOTAL HUMAN RESOURCES 22,231.24385,476 5,900.11 58,841.46 73,504.90 249.00 317,622.05 FINANCE Personnel Services426,474 33,037.70 - 96,337.04 103,652.89 - 322,821.11 Supplies3,600 450.73 - 1,148.68 505.97 483.57 2,610.46 Operations Support850 38.11 - - 581.45 59.20 209.35 Staff Support15,805 393.67 - 1,155.00 613.67 - 15,191.33 Rental/Leasing2,230 - - - - - Operating Equipment1,000266.47 266.47- - - TOTAL FINANCE449,95933,920.21266.4798,640.72105,620.45542.77 PURCHASING & ASSET MG T Personnel Services 240,272 16,372.29 54,614.24- 53,943.06 - 186,328.94 Supplies 800 - - 3.60 18.12 98.06 Utility Services 750 59.25 - 41.18 133.80 - Operations Support 850 - - - - - Staff Support 9,450 458.60 65.00 1,606.81 1,082.70 609.50 Operating Equipment7,5007,590.82 7,590.82- - - TOTAL PURCHASING & ASSET MGT 259,622 24,480.96 65.00 56,265.83 62,768.50 707.56 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,324 11,912.26 - 39,985.95 42,741.12 - 174,582.88 Supplies109,600 15,032.60 2,927.39 22,034.88 40,283.54 8,710.15 63,533.70 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 319.97 - 648.56 550.42 - Operations Support 400 - - - - - Staff Support 3,835 74.28 620.41 490.77 779.11 26.12 Maintenance Services 65,750 2,441.15 1,685.29 5,685.32 8,251.63 5,463.48 Rental/Lease200 -269.80 - - - Operating Equipment5,0003,164.28 -3,882.251,467.72 - Capital Outlay -- - - - - TOTAL FLEET SERVICE410,80932,944.545,233.0970,345.4898,257.8715,667.47 TOTAL INTERNAL SERVICE 2,666,042 180,184.86 19,997.66 427,555.64 494,619.42 61,229.01 MISC & PROJECTS CITY ASSISTANCE - - - - Utility Services - - Patient Assistance 5,000 - - 2,500.00 - - Children's Advocacy Assistance 5,000 2,500.00 - 2,500.00 2,500.00 - Senior Citizen's Hot Meals42,000 10,500.0010,500.00 - - 31,500.00 TOTAL CITY ASSISTANCE52,0002,500.00 15,500.00-13,000.0031,500.00 COURT - RESTRICTED FUNDS Operating Equipment -- - - - - TOTAL CITY ASSISTANCE - - - - - - TOTAL MISC & PROJECTS 52,000 2,500 - 15,500 13,000 31,500 TOTAL EXPENDITURES20,813,5271,485,679.73 134,270.01 4,286,533.66 4,488,845.97292,875.75 REVENUE OVER(UNDER) EXPEND.145,4282,753,164.76 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,4542,439,122.97 3,981,902.32- 4,208,088.46 - 2,676,365.54 000-411200Advalorem Tax - Delinquent 50,000 3,399.49 14,807.25- 19,408.38 - 30,591.62 000-411300Advalorem Tax - P&I 50,000 1,216.12 - 3,979.44 6,198.26 - 43,801.74 000-411500Sales Tax Revenue-Gen Fund4,784,071 339,191.88 352,546.24- 1,234,880.16 - 3,549,190.84 000-411600Bingo Tax 2,200 - - 981.20 - - 000-411700Mixed Beverage Ta 7,030.078,801.91 x 33,000.00 - - - TOTAL Taxes11,803,7252,782,930.46 4,363,018.36- 5,475,605.33 - 6,328,119.67 Franchises 000-421200Center Point/Entex Energy 36,000 - - - 9,978.35 - 26,021.65 000-421220City Public Service 330,000 - 83,433.23- 96,391.57 - 233,608.43 000-421240Guadalupe Valley Elec Co-op 440,000 - 124,838.75- 138,145.00 - 301,855.00 000-421250New Braunfels Utilities 55,000 - - 7,403.70 9,585.78 - 45,414.22 000-421300Time Warner-State Franchise 345,000 - 87,894.73- 80,197.52 - 264,802.48 000-421350Time Warner-PEG Fee 65,000 - 16,416.59- 16,039.50 - 48,960.50 000-421460AT&T Franchise Fee 185,000 - 43,536.50- 36,239.75 - 148,760.25 000-421465AT&T PEG Fees 26,000 - 5,497.29 7,247.95 - 18,752.05 000-421480Other Telecom Franchise 35,000 221.84 - 4,452.05 25,045.89 - 000-421500Solid Waste Franchise Fee100,00024,899.779,228.38 - - - TOTAL Franchises1,617,000221.84 398,372.61-428,099.69 - 1,188,900.31 Permits 000-431100Home Occupation Permit 500 35.00 - 140.00 70.00 - 000-431200Building Permit 522,833.83- 127,820.00 - 42,393.00 - (127,820.00) 000-431205Building Permit - Residential 600,000 - - - - - 600,000.00 000-431210Building Permit - Commercial 300,000 - - - - - 300,000.00 000-431300Mobile Home Permit 200 - - 40.00 - - 000-431400Signs Permit 1,700 25.00 - 75.00 220.00 - 000-431500Food Establishmnt Permit 30,000 - - 8,395.00 9,425.00 - 20,575.00 000-431600Garage Sale Permit 8,600 260.00 - 2,670.00 2,540.00 - 000-431700Plumbing Permit 80,000 6,095.00 19,860.50- 22,426.00 - 57,574.00 000-431750Electrical Permit 55,000 3,260.00 12,960.00- 10,000.00 - 45,000.00 000-431800Mechanical Permit 59,000 3,580.00 17,280.00- 12,180.00 - 46,820.00 000-431900Solicitor/Peddler Permit 60.00 - 70.00 190.00 - - 000-431950Animal/Pet Permit 2,000 15.00 - 930.00 595.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,8001,550.00-1,750.002,150.00 - 000-432100Security Alarm Permit 42,000 5,300.00 - 9,605.00 11,660.00 - 30,340.00 000-435000Fire Permit5,000675.00 1,800.002,300.00 - - TOTAL Permits1,187,80063,248.00 598,909.33-201,076.00 - 986,724.00 Licenses 000-441000Alcohol Beverage License 6,300 342.50 - 225.00 1,002.50 - 000-442000Contractors License 22,000 3,500.00 - 5,675.00 5,335.00 - 16,665.00 000-444000Pet License3,000360.00 950.00977.10 - - TOTAL Licenses 31,300 4,202.50 - 6,877.10 7,287.50 - 24,012.50 Fees 000-451000Municipal Court Fines 1,665,009 61,481.35 245,036.38- 214,618.83 - 1,450,390.17 000-451100Arrest Fee 50,694 4,036.08 11,131.73- 11,523.41 - 39,170.59 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 9,042.90 22,537.30- 27,298.00 - 164,702.00 000-451320Civil Justice Fee-Court 75 6.43 17.43 18.30 - 000-451321Civil Justice Fee-State 58.71 - - 165.42 - - 000-451340Judicial Fee - City 6,826 533.92 - 1,455.55 1,515.86 - 000-451400Traffic Fine Costs TTL 25,984 2,119.88 - 5,714.23 6,017.89 - 19,966.11 000-451500Teen Court Admin Fee 260 20.00 - 180.00 180.00 - 000-451510Juvenile Case Mgmt Fee 55,896 4,449.18 12,153.82- 12,641.95 - 43,254.05 000-451600Technology Fund Fee 45,601 3,521.76 - 9,660.71 10,215.90 - 35,385.10 000-451700Security Fee 34,220 2,641.32 - 7,245.53 7,661.98 - 26,558.02 000-451800Time Payment Fee - City 7,336 347.39 - 1,167.14 1,274.41 000-451850State Fines 10% Service Fee 72,470 - 19,298.66- 13,466.72 - 59,003.28 000-451900DPS Payment - Local 11,858 667.98 - 1,958.09 2,210.77 - 000-452000Child Safety Fee 12,243 2,515.70 - 3,166.17 8,306.04 - 000-452050Indigent Defense Fee 21,655 1,713.73 - 4,741.08 4,857.53 - 16,797.47 000-452100Platting Fees 98,000 5,000.00 20,500.00- 10,000.00 - 88,000.00 000-452200Site Plan Fee 74,000 1,500.00 - 5,500.00 6,000.00 - 68,000.00 000-452300Plan Check Fee 465,000 22,003.50 262,515.41- 67,056.00 - 397,944.00 000-452310Miscellaneous Review Fee 13,500 3,000.00 - - 3,000.00 - 10,500.00 000-452320Tree Mitigation Admin Fee 10,500 - - - - - 10,500.00 000-452400BOA/Zoning Fees 4,000 - - 1,050.00 1,500.00 - 000-452500Food Handler Class 7,000 220.00 - 790.00 1,210.00 - 000-452520Fire Training Classes 400 - - - - - 000-452600Specific Use/Zone Chng Fee 20,000 - -- 12,350.00 - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452710Zoning Ltr & Dev Rights1,500--225.00300.00 - 000-453100Reinspection Fees 30,000 4,275.00 13,425.00- 10,775.00 - 19,225.00 000-453200Mowing Fees - Inspections 12,000 - - 8,256.16 315.00 - 11,685.00 000-453211Admin Fee-Inspections 7,480 540.00 - 3,300.00 940.00 - 000-453310Misc Inspection Fee - - 35.00 19.49 - - 000-453500SubContractor Reg. Fee 17,000 2,090.00 - 3,600.00 4,130.00 - 12,870.00 000-453710Foster Care 500 50.00 - 300.00 250.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 - 350.00 250.00 000-458100Sale of Merchandise - - (29.58) - - - 000-458300Sale of Property/Auction 22,000 814.52 - 1,066.31 2,223.46 - 19,776.54 000-458400Civic Center Rental Fees 171,000 3,547.50 29,042.75- 18,841.50 100.00 000-458401Capital Recovery Fee-Civic Cntr 7,500 - - 910.00 675.00 - 000-458450North Center Rental Fees 15,000 1,168.00 - 1,371.00 5,671.00 - 000-458500Community Center Rental Fees18,000 1,112.69 - 3,698.92 3,804.49 - 14,195.51 000-458550Pavilion Rental Fees 18,500 100.00 - 3,553.50 2,117.00 - 16,383.00 000-458560Chamber of Comm rent 11,700 1,950.00 - 1,950.00 1,950.00 - 000-458570Non-Resident SYSA League 12,000 7,950.00 - 7,060.00 9,830.00 - 000-458600Ball Field Use - - 2,445.00 - 2,445.00 - (2,445.00) 000-458650NonResident User Fee-BVYA 11,000 - - 1,410.00 2,670.00 - 000-458660BVYA Utility Reimbursement - - - 3,195.72 - - (3,195.72) 000-458680Tournament Fees-Soccer 15,000 3,025.00 -- 3,025.00 - 11,975.00 000-458700Vehicle Impoundment 5,000 - - - - - 000-459200NSF Check Fee 250 - - 158.00 - - 000-459300Notary Fee 300 30.00 - 132.00 66.00 - 000-459400Maps, Copies, UDC, & Misc F 400 5.00 - 5.00 8.10 - 000-459600Animal Adoption Fee 15,000 994.00 - 3,065.00 3,214.50 - 11,785.50 000-459700Pet Impoundment Fee 15,000 996.25 - 5,438.01 3,481.25 - 11,518.75 000-459800Police Reports Fee6,500486.00 1,392.001,622.20 - - TOTAL Fees3,341,727156,508.79 725,763.50-504,733.52 2,836,893.48100.00 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0001,712.53 5,572.566,442.89 - - TOTAL Fines 30,000 1,712.53 - 6,442.89 5,572.56 - 24,427.44 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 - - 5,269.44 1,756.48 - 19,320.52 000-473200City of Seguin - Fire Contract 40,263 3,355.26 10,065.78- 10,065.78 - 30,197.22 000-473300Guad Co - Library 180,000 15,901.33 45,204.00- 47,703.99 - 132,296.01 000-473400Randolph AFB-Animal Cntrl 1,000 - - 900.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 - 99,978.75 000-474600School Crossing Guard-Bexar6,6002,358.74 1,503.837,582.82 - - 000-474610School Cross Guard-Guadalupe -5,203.96 -2,459.28 - - 000-474700School Officer Funding150,000 -- - - - TOTAL Inter-Jurisdictional 571,245 24,074.61 96,269.30- 105,939.28 - 465,305.72 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 21,960.00- 21,960.00 - 65,880.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 42,555.25- 35,656.50 - 106,969.50 000-481000Transfer From Reserves 355,000 - - - - - 355,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 3,486.25 - 9,722.00 10,458.75 - 25,021.25 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 156,194.25- 220,305.51 - 660,916.49 000-486317Transfer From Park Fund 13,000 - - - - - 13,000.00 000-487000Interfund Charges-Fleet 98,484 8,207.00 22,326.25- 24,621.00 - 73,863.00 000-488000Interfund Charges-4B 53,000 4,416.67 13,858.00- 13,250.01 - 39,749.99 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers1,760,658 -108,750.59 316,615.75 326,251.77 - 1,434,406.23 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 9.43 - 963.42 34.97 - 000-491200Investment Income 30,000 3,684.81 - 7,578.38 10,130.50 - 19,869.50 000-491800Gain/Loss - - - (19.83) - - 000-491900Unrealized Gain/Loss (8,707.26)- (7,159.05) - (2,815.90) - 000-492100Proceeds-Sale of Land - - 57,867.85- - - (57,867.85) 000-493000Donations-Others - - - - - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap. 164.00 20,259.00- 667.00 - - 000-493400Donation - Animal Control 1,200 297.00 - 1,842.30 594.02 - 000-493401Donations-A/C Microchip 500 145.00 - 570.00 520.00 - 000-493402Donations-Spay&Neuter 13,500 999.50 - 5,450.00 3,340.50 - 10,159.50 000-493503Donations - Fire Rescue - - - - - - 000-494481LawEnforcemtOfficersStnd&Ed - - - - - - 000-494482DOJ-PD GRANT - - - - - - 000-495040Friends of N. Schertz Park - - - 3,074.00 - - (3,074.00) 000-497000Misc Income-Gen Fund 81,000 1,348.26 24,172.20- 2,985.28 (178.90) 000-497005Misc Income-Publications 290,000 13,171.00 28,958.00- 48,928.00 - 241,072.00 000-497020Misc Income-Fleet Recycled - - - - - - 000-497100Misc Income-Police 25,000 569.00 12,992.43- 1,337.90 - 23,662.10 000-497200Misc Income-Library 19,000 271.05 - 703.55 1,040.49 - 17,959.51 000-497210Misc Income-Library Copier 13,500 996.50 3,091.75 3,627.26 - 000-497300Misc Income-Animal Control 500 - - 311.50 105.00 - 000-497400Misc Income-Streets Dept. 20,000 550.00 - 6,250.00 5,596.88 - 14,403.12 000-497500Misc Income-TML Insurance 78,000 - 50,882.00- - - 78,000.00 000-497550Misc Income-TML Reimbursemt20,000 3,296.89 13,583.54- 4,133.89 - 15,866.11 000-497600Misc Income-Parks/Vending Mach.2,500 106.63 -404.53552.38 - 000-498000Reimbursmnt-Gen Fund5,00012,183.53 33.0020,792.02 - -(15,792.02) 000-498100Reimbursmnt Fire - Training 800 - - 846.00 - - 000-498105Reimburmnt Police - DEA - - - - - - 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 29,296.028,078.07 - - - TOTAL Miscellaneous 615,500 34,976.70 178,262.41- 187,445.08 (178.90) TOTAL REVENUES20,958,9553,176,626.02 6,690,531.25- 7,242,010.73 13,717,023.17(78.90) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking539,072.88$ Cash in Investment Pools LOGIC Investment-General Fund2,906,445.51 LOGIC Investment-Equip Replacement73,331.67 LOGIC Investment-Veh Replacement7,078.04 LOGIC Investment-Air Condi Replacment146,412.83 CAPITAL ONE Investment-General Fund1,334,578.22 Total Cash in Bank & Investment Pools$5,129,169.41 17 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 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 -2% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 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: DECEMBER 31st, 2011 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET25% 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.00721.00- 736.73395.28 - TOTAL REVENUES114,275.00 721.00 - 395.28 736.73 - 113,538.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 12,402.22 10,111.48- 12,902.22 - 1,347.78 Employee Appreciation Event 5,000.00 - (76.87) - 4,950.0050.00 - 4th of July Jubilee 218.05 - 218.05 - - - National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 160.00 - - 160.00 - 31,340.00 Blue Santa - - - - - - Schertz Fest - 455.91 - - - - TML Events - - - - - - Schertz Sweetheart 37,000.00 1,163.92 - 9,621.05 2,546.24 33,953.76500.00 Hal Baldwin Scholarship11,000.00- -- - -11,000.00 Selma-Schertz 5K- -- - - - TOTAL CULTURAL 13,726.14103,600.00 218.05 20,111.57 15,826.51 550.00 87,441.54 TOTAL EXPENDITURES108,750.00 13,726.14 218.05 20,111.57 15,826.51 550.00 92,591.54 REVENUE OVER(UNDER) EXPEND5,525.00(15,089.78) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking11,776.18$ Cash in Investment Pools MBIA Special Events66,581.47 Total Cash in Bank & Investment Pools$78,357.65 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,000- 35,061.00-- 180,000.00- Fees14,164,2501,104,905.19 3,374,141.98-3,870,962.91 10,293,287.09- Fund Transfers484,6747,056.17 20,154.00-21,168.51 463,505.49- Miscellaneous16,861.7644,295.02185,098.47 103,260 - - TOTAL REVENUES14,932,1841,128,823.123,473,652.004,077,229.89 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers -- 27,366 - - - TOTAL NON DEPARTMENTAL-- 27,366 - - -27,366.00 BUSINESS OFFICE Personnel Services380,00225,672.33 102,662.70- -84,461.79 295,540.21 Supplies5,400 359.66 418.33 478.53 932.24 58.99 4,827.10 Human Services100 - - - - - 100.00 Operations Support114,000 7,216.79 - 14,663.46 20,847.89 22.36 93,129.75 Staff Support7,100 96.84 94.26 863.87 251.47 370.23 6,572.56 Professional Services16,000 1,509.79 395.00 2,632.12 5,867.22 - 10,527.78 Fund Charges/Transfers20,000 - - - - - 20,000.00 Maintenance Services9,300 1,920.00 - 1,200.00 2,760.00 2,680.00 3,860.00 Operating Equipmen5,432.94500.006,285.625,932.94 t 6,200 - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE42,208.351,407.59128,786.30121,053.553,131.58 600,102 W & S ADMINISTRATION Personnel Services1,178,78181,911.75 315,514.52-268,091.75 910,689.25- Supplies200,7009,847.274,458.8152,971.2116,155.661,689.85 Human Services1,000----- City Support Services144,0084,824.82 33,007.48-33,435.48139.61 Utility Services2,634,344322,690.30 380,589.85-929,897.40 1,704,446.60- Operations Support8,750747.83-1,134.451,003.81- Staff Support33,000852.88294.547,056.331,863.402,972.42 City Assistance1,912105.00-102.00120.0015.00 Professional Services187,4003,888.60-8,469.085,232.60 182,167.40- Fund Charges/Transfers2,623,507289,996.95 588,422.55-764,561.62 1,858,945.38- Maintenance Services5,497,250377,043.7612,287.431,038,470.191,048,635.97130,046.16 Other Costs35,000- 28,911.85-1,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: DECEMBER 31st, 2011 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353- 83,375.00-- 1,230,353.00- Rental-Leasing6,070429.30-662.53429.30186.00 Operating Equipment8,000- 11,118.99--- Capital Outla12,000.0082,000.0030,784.00 y 114,000 -22,432.00 -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,904,0751,104,338.4617,040.78 3,152,676.992,572,238.03 165,833.04 10,602,605.7523.74% MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,000 1,750.79-1,663.001,750.79 48,000.00- Maintenance Services22.35 - 334,500 - - - 1,685.351,750.79 TOTAL AVIATION HEIGHTS WTR IMP 400,000 -1,750.79 -400,000.00 FM3009 RD&BRIDGE EXPANSION Professional Services-- 30,358.80--- Maintenance Services 29.03 - - - - - - TOTAL FM3009 RD&BRIDGE EXPANSION - - -30,387.83 - TOTAL MISC & PROJECTS32,073.181,750.79 400,000 -1,750.79 -400,000.00 TOTAL EXPENDITURES14,931,5431,146,54720,1992,733,0983,275,481168,965 ** REVENUE OVER(UNDER)EXPENSES **801,748.56 641 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% 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 284,724.87 812,248.08- 899,360.74 - 2,500,639.26 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 20,289.45 44,316.14- 63,597.36 - 177,402.64 000-455800W&S Line Constructn Reimbursemnt50,000 1,870.00 - 6,583.95 7,180.08 - 42,819.92 000-457100Sale of Water 7,210,000 529,142.48 1,704,350.60- 1,998,200.14 - 5,211,799.86 000-457110Edwards Water Lease 166,250 1,565.60 59,507.50- 14,800.60 - 151,449.40 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 5,063.00 23,010.30- 13,152.00 - 76,848.00 000-457400Sewer Charges 2,800,000 246,364.05 661,486.91- 802,300.83 - 1,997,699.17 000-457500Water Penalties 180,000 15,685.74 43,515.06- 48,294.36 - 131,705.64 000-459200NSF Check Fee-Water&Sewer2,000200.00693.44810.00 - - TOTAL Fees14,164,2501,104,905.19 3,374,141.98-3,870,962.91 - 10,293,287.09 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 7,056.1720,154.00 21,168.51 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 484,674 7,056.17 20,154.00- 21,168.51 - 463,505.49 Miscellaneous 000-490000Misc Charges 10,000 2.05 - 4,381.88 27.05 - 000-491000Interest Earned 1,000 165.42 - 970.57 522.54 - 000-491200Investment Income 6,000 - (9,101.10)- 1,009.83 - 000-493400Donations-Christmas Activitise 750.00 - 1,000.00 750.00 - - 000-496050SSLG - SAWS Reservation - - 134,500.00- - - (134,500.00) 000-497000Misc Income-W&S 14,693.07- 22,589.75 -15,944.29 - (22,589.75) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 - 24,940.96- 25,699.30 - 50,615.70 000-498200W&S Project Reimbursement5,118.30 - - - - - TOTAL Miscellaneous 103,260 16,861.76 44,295.02- 185,098.47 - (81,838.47) TOTAL REVENUES14,932,1841,128,823.12 3,473,652.00- 4,077,229.89 - 10,854,954.11 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking289,314.51$ Cash in Investment Pools Lone Star Investment-Water&Sewer1,358,252.83 Lone Star Investment-W&S Customer Deposits293,783.29 Lone Star Investment-W&S Equip Replacement373,218.71 Lone Star Investment-W&S Veh Replacement544,197.49 Lone Star Investment-Water/SSLGC SAWS269,274.40 Schertz Bank & Trust-Certificate of Deposit1,044,420.00 $3,883,146.72 Total Cash in Bank & Investment Pools4,172,461.23$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 199,632.84 774,675.43- 704,325.70 - 3,384,607.30 Inter-Jurisdictional1,438,836 68,250.58 369,059.31- 491,052.75 - 947,783.25 Miscellaneous5,517.23-40,299.4226,293.34 256,000 - TOTAL REVENUES 273,400.65 - 1,184,034.16 1,221,671.79 - 4,562,097.21 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,572,989203,973.7668.00651,989.00636,028.92 1,937,017.0811.00 Supplies 30,438.12 13,149.22 67,882.94 88,331.49 30,461.15 324,039 Human Services - - - 800 - - City Support Services 10,902.09- 10,277.40 45,407 - - 35,129.60 Utility Services 11,717.82 10.41 15,961.48 19,968.17 92,527.2415.00 112,500 Operations Support 3,509.00 364.65 24,102.27 25,925.47 111.00 45,600 Staff Support 6,358.16 449.08 16,991.92 13,438.69 11,495.43 72,400 City Assistance 987.00 - 630.00 1,237.00 174.00 9,000 Professional Services 10,858.40 133.00 32,224.63 35,183.38 5,332.37 164,200 Fund Charges/Transfers2,084,785 16,992.01 309,070.96- 251,596.80 - 1,833,188.20 Maintenance Services 5,758.00 10,731.40- 6,208.00 10,800.00 37,700 Debt Service - - - 111,176 - - 111,176.00 Rental-Leasing - 836.33 - 20,000.00 20,000 - - Operating Equipment 4,361.25 820.75 2,044.28 35,408.71 8,130.81 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 294,953.52 14,995.11 1,143,367.30 1,123,604.03 66,530.76 4,538,456.32 5,713,596 TOTAL EXPENDITURE294,953.5214,995.111,143,367.301,123,604.03 S 5,713,596 66,530.76 ** REVENUE OVER(UNDER) EXPENSES 98,067.76 * 70,173 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 194,642.84 - 761,840.43 690,930.70 18.09% -3,127,802.30 000-456110Subscription Program Fees55,000 4,990.00 - 12,835.00 13,395.00 24.35% -41,605.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,933199,632.84 774,675.43- 704,325.70 -3,384,607.30 Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 68,250.58 - 72,631.54 204,751.74 71.56% -81,374.26 000-474300Cibolo Support222,018 106,650.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 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,864.87- 96,046.91 - -287,999.09 000-475600Santa Clara Support 8,849 - 2,633.67 2,213.06 - -6,635.94 000-475800Marion Support13,0113,255.79- - - - TOTAL Inter-Jurisdictional1,438,836 68,250.58 369,059.31- 491,052.75 -947,783.25 Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 49.56 - 187.31 120.25 - - 000-493203Donations-EMS 6,000 25.00 - 850.00 225.00 -5,775.00 000-493204Donations-Dilworth Fund - - - 0.00% - - - 000-493205Donations- Golf Tournament - - - 0.00% - - - 000-497000Misc Income 150,000 5,427.67 22,401.02- 12,333.09 -137,666.91 000-497100Recovery of Bad Debt 100,000 15.00 - 4,901.09 15.00 -99,985.00 000-497500Misc Income-EMT Classes11,960.0013,600.00 - - - - TOTAL Miscellaneous256,0005,517.23 40,299.42-26,293.34 -229,706.66 TOTAL REVENUES5,783,769273,400.65 1,184,034.16- 1,221,671.79 4,562,097.21- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank $ (514,088.06) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010300,867.98 $(213,220.08) 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: DECEMBER 31st, 2011 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60061,324.97 175,417.19- 192,211.52 -517,388.48 Fund Transfers - - - - - - - 0.00% Miscellaneous900386.91214.23 77.92 - - TOTAL REVENUES 61,402.89710,500175,804.10 -192,425.75518,074.25 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 371,06823,406.94 93,549.46- 83,373.30 -287,694.70 Supplies 8,300 - 183.24 319.62 129.48 - Human Services 325 - - - - -325.00 City Support Services 35,899 - 1,345.04 1,508.72 - -34,390.28 Utility Services 14,688 1,804.66 - 2,134.11 3,782.17 -10,905.83 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 126.02 43.02 842.24 515.20 7,792.3240.50 City Assistance 840 - 15.00 57.00 - -783.00 Professional Services 19,800 - - - - -19,800.00 Fund Charges/Transfers 199,87611,785.92 32,662.25- 35,357.76 -164,518.24 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 37,123.54701,72543.02130,731.34 169.98124,913.77576,684.27 TOTAL EXPENDITURE 37,123.54701,72543.02130,731.34 169.98124,913.77576,684.27 S ** REVENUE OVER(UNDER) EXPEND8,77567,511.98 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 1,038.12 1,253.61 4,000 441.26 -2,746.39 000-457600Drainage Fee 60,883.71-174,379.07190,957.91 -514,642.09 705,600 TOTAL Fees61,324.97 175,417.19-192,211.52 517,388.48- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 113.55 17.30 100 6.03 - 000-491200Investment Interest - 181.02 180.76 600 67.27 -419.24 000-497000Misc Income-Drainage-92.3416.17 200 4.62 - TOTAL Miscellaneous - 386.91 214.23 900 77.92 -685.77 TOTAL REVENUES61,402.89 175,804.10- 192,425.75 518,074.25- 710,500 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Ban k Claim on Operating Cash Pool-Checking 131,754.24 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,261.40 Total Cash in Bank & Investment Pools$415,015.64 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 54,466.47 30,148.83- 56,784.79 -333,969.21 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50028.71-149.8163.35 - TOTAL REVENUES 54,495.18411,386-30,298.6456,848.14354,537.86 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 213.00 - 231.08 - -2,481.92 City Support Services 85,948 843.00 15,059.85- 21,250.00 -64,698.00 Operations Support 74,000 500.00 346.04 2,351.00 7,587.29 -66,758.75 Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 193,876 11,885.50 42,555.25- 35,656.50 -158,219.50 Operating Equipment 52,562 8,164.98 6,645.00 14,809.98- -44,397.02 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 21,393.48411,3867,204.0459,966.1079,534.85339,055.19 L - TOTAL EXPENDITURE 21,393.48411,3867,204.0459,966.1079,534.85339,055.19 S - (22,686.71) REVENUE OVER(UNDER) EXPENDITURE - 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 54,466.4730,148.8356,784.79 -333,969.21 - TOTAL Taxes 390,754 54,466.47 30,148.83- 56,784.79 - 333,969.21 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned3008.69-110.0728.35 - 271.65 000-491200Investment Interest 200 20.02 - 39.74 35.00 - 165.00 000-497000Misc Income-- - - - - - TOTAL Miscellaneous50028.71-149.8163.35 - 436.65 TOTAL REVENUES 411,386 54,495.18 30,298.64- 56,848.14 - 354,537.86 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking200,670.07$ Cash in Investment Pools Federated Investment-Hotel/Motel78,161.04 Total Cash in Bank & Investment Pools$278,831.11 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: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 - 52,575.00- 6,000.00 -197,425.00 Tree Mitigation Fees 75,000 - - - - -75,000.00 Miscellaneous- 174.22230.92 600 86.24 - TOTAL REVENUES- 52,749.22230.92 325,600 6,086.24 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - - - -13,000.00 Maintenance Services-Landscape 3,500 - - - - -3,500.00 Operating Equipment 32,000 22,007.50- 2,680.00 5,046.20 2,680.00 Capital Outlay 50,281.10-- 50,281.10 169,000 1,742.35 TOTAL PARKLAND DEDICATION52,961.10-22,007.5052,961.10 217,500 6,788.55 TREE MITIGATION Maintenance Services-Trees28,500 14,986.00- 390.00 - -28,110.00 Capital Outlay-- 19,900.00 18,000 - - TOTAL TREE MITIGATION-14,986.0020,290.00 46,500 - - TOTAL EXPENDITURE52,961.10-36,993.5073,251.10 S 264,000 6,788.55 REVENUE OVER(UNDER) EXPEND(20,501.88) 61,600 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 6,000.00 - 52,575.00- 197,425.00 000-458900Tree Mitigation75,000 -- - - TOTAL Fees 325,000 6,000.00 -- 52,575.00 - 272,425.00 Miscellaneous 000-491000Interest Earned 100 0.75 - 113.22 6.78 93.22 000-491200Investment Interest 500 85.49 - 117.70 167.44 332.56 000-497000Miscellaneous Income -- - - - TOTAL Miscellaneous60086.24-230.92174.22 425.78 TOTAL REVENUES 325,600 6,086.24 - 230.92 52,749.22 272,850.78 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank ($7,845.32) Claim on Operating Cash Pool-Checking Cash in Investment Pools Federated Investment-Park Fund252,803.61 Federated Investment-Tree Mitigation126,288.98 Total in Investment Pool 379,092.59 Total Cash in Bank & Investment Pools$371,247.27 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *********************************************** 2 0 1 1 - 2 0 1 2 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer-- - 27,366 - - 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: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S27,366-- - - - TOTAL Fund Transfers27,366--- - -27,366.00 TOTAL REVENUES 27,366 - - - - - 27,366 39 RECYCLE FUND CASH IN BANK AS OF: DECEMBER 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: DECEMBER 31st, 2011 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET16.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 136,071.00 733,140.17- 363,111.00 -2,362,289.00 Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous314,000 948.5281,339.953,016.31 - - TOTAL REVENUES13,713,000 137,019.52814,480.12366,127.3113,346,872.69 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50- Professional Services 22,000 354.52 - 707.20 1,061.59 -20,938.41 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.529,135.201,061.59 L - 108.50 MISC & PROJECTS Projects13,025,000 35,663.25-58,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 Plant- 0.00% - - -202,011.43 - Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP229,568.95- A - - - - TOTAL MISC & PROJECTS13,624,643 -35,663.25489,763.7410,488.4213,649,817.83 - TOTAL EXPENDITURE13,662,643 354.5235,663.25498,898.9411,550.0113,686,647.74 S 108.50 REVENUE OVER(UNDER) EXPENDITURES50,357 354,577 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 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 98,919.00 467,083.34- 253,455.00 -1,226,145.00 000-455910Capital Recovery - Waste Wtr613,800 37,152.00 265,606.83- 109,656.00 -504,144.00 - - - 0.00% 000-455911Capital Recovery-Wste Wtr Zone 1 - - - 000-455913Cap Recovery-North Sewer Tr632,000 -450.00- - - TOTAL Fees 2,725,400136,071.00 733,140.17- 363,111.00 -2,362,289.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 Earned50022.58-191.4557.73 - 000-491200Investment Income 30,000 4,179.54 - 8,621.98 11,515.73 -18,484.27 000-491800Gain/Loss - - (1,012.16) - (984.38) -1,012.16 000-491900Unrealized Gain/Loss-Cap One (10,848.48)- (7,544.99) - (2,269.22) -7,544.99 000-497000Misc Income - - - 0.00% - - - 000-498100Reimbursmnt - FM 78 Project 12,500.00- - 0.00% - - - 000-498200Re-imbursement-Water Meters283,500 -70,875.00- - - TOTAL Miscellaneous314,000948.52 81,339.95-3,016.31 -310,983.69 TOTAL REVENUES13,713,000137,019.52 814,480.12- 366,127.31 2.67% -13,346,872.69 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 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: DECEMBER 31st, 2011 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 1,509,830.454,281,098 - 2,005,427.88 2,618,775.61 -1,662,322.39 - - - - Fund Transfers - - Miscellaneous2,2502,156.7914,490.575,612.39 - - TOTAL REVENUES 1,511,987.244,283,3482,019,918.452,624,388.00 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL - - 35,810.39 Professional Services -35,810.39 -(35,810.39) Debt Service4,276,667 -4,664.58- - - TOTAL GENERAL GOVERNMEN 35,810.394,276,6674,664.5835,810.39 T - - TOTAL EXPENDITURE 35,810.394,276,6674,664.5835,810.39 S - - ** REVENUE OVER(UNDER) EXPEND6,6822,588,577.61 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 1,509,830.452,005,427.882,618,775.61 - - TOTAL Taxes4,281,0981,509,830.45 2,005,427.88-2,618,775.61 - 1,662,322.39 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 11.38 14,409.41- 19.70 - 000-491200Investment Earnings1,5002,145.4181.16 5,592.69 - - TOTAL Miscellaneous 2,250 2,156.79 14,490.57- 5,612.39 - (3,362.39) TOTAL REVENUES4,283,3481,511,987.24 2,019,918.45- 2,624,388.00 - 1,658,960.00 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent -- - - - - 35,810.39 35,810.39- 101-541502Cost of Bond Issuance - - - TOTAL Professional Services35,810--35,810 - -(35,810.39) 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 - - - - - 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,664.58 - -4,276,666.50 TOTAL EXPENDITURES4,276,667 35,810.39 - 4,664.58 35,810.39 -4,240,856.11 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking46,193.62$ Cash in Investment Pools MBIA Investment- Tax I&S2,637,422.49 Federated Investment-Tax I&S56.82 Total Cash in Bank & Investment Pools$2,683,672.93 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET25% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042169,595.94 176,273.09- 617,440.08 - 1,774,601.92 Fund Transfers - - - - - - Miscellaneous17,2004,489.104,338.344,806.58 - - ,,,.,.,. TOTALREVENUES2409242174085041806114362224666 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 21,000 3,915.59 579.81 5,821.77 7,003.72 3,904.77 Utility Service 87,500 4,562.31 - 8,966.37 11,314.20 - 76,185.80 Maintenance Services 72,300 9,594.95 632.25 24,798.34 19,007.91 753.50 Operating Equipment - 6,999.31 - - - - Capital Outlay -- - - - - TOTAL NONDEPARTMENTA180,80018,072.851,212.0646,585.7937,325.834,658.27 L ECONOMIC DEVELOPMEN T Personnel Services 240,677 14,068.73 40,327.91- 51,910.39 - 188,766.61 Supplies 1,100 56.12 - 153.03 93.63 49.70 Human Services 200 - - - - - City Support Services 43,328 2,069.45 1,363.42 4,630.24 6,753.24 1,202.11 Utility Services 7,200 207.00 - 615.01 346.63 - 6,853.37 Operations Support 63,600 4,558.25 4,813.35 11,484.63 9,892.60 259.21 Staff Support 112,800 3,559.89 937.31 56,089.83 57,768.46 4,230.30 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 16,100.90 30,935.60 41,418.80 47,036.50 - 287,399.10 Fund Charges/Transfers 105,985 4,665.42 63,858.00- 13,996.26 - 91,988.74 Fund Replenish-Fund Balance 220,000 - - - - - 220,000.00 Maintenance Services - - - - - - Debt Service 795,154 - - - 795,154.00 - - Operating Equipment2,350 -- - - - TOTAL ECONO DEVELOPMEN 45,285.762,195,89438,049.68218,577.45197,797.715,741.32 T TOTAL EXPENDITURE 63,358.612,376,69439,261.74265,163.24235,123.54 S 10,399.59 ** REVENUE OVER(UNDER) EXPEND32,548387,123.12 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET25% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042169,595.94176,273.09617,440.08 - - TOTAL Taxes2,392,042169,595.94 176,273.09- 617,440.08 -1,774,601.92 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 21.41 - - 64.52 - 000-491200Investment Earnings 15,000 2,466.25 - 4,124.04 2,740.62 -12,259.38 000-497000Misc Income 2,001.442,000 - 214.30 2,001.44 - 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 4,489.10 - 4,338.34 4,806.58 - TOTAL REVENUES2,409,242174,085.04 180,611.43-622,246.66 -1,786,995.34 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking180,213.32$ Cash in Investment Pools MBIA Investment-Economic Development Corp1,616,169.73 Schertz Bank & Trust-Certificate of Deposit507,004.98 Schertz Bank & Trust-Certificate of Deposit1,035,475.46 Total Cash in Bank & Investment Pools3,338,863.49$ 50 4B SALES TAX $300,000 40% $250,000 13% -2% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 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 DECEMBER 31st, 2011 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,866,956.82,795,645.58.0500,397,677.45,326,366.21,866,956.82,866,956.82 207722 TOTAL OPERATIONS2,866,956.82,795,645.58,397,677.45,326,366.21,866,956.82,866,956.82 27722 LOGIC General Fund2,906,445.51,706,135.12.2085,500,310.3900,000.00,906,445.51 N/A,906,445.51 101322 G/F-Equipment Replacement73,331.6773,318.680.2085 -12.9973,331.67 N/A73,331.67 G/F-Vehicle Replacement7,078.04,076.79.2085 -.25,078.04 N/A,078.04 70177 G/F-Air Conditioner Replacement146,412.83146,386.900.2085 -25.93146,412.83 N/A146,412.83 ,211,568.08.208581.6650,000.00,861,949.74,861,949.74 SR2009 Bond-Street Projects(II)1,861,949.74 203311 TOTAL LOGIC4,995,217.79,144,485.57,500,732.2250,000.00,995,217.79,995,217.79 41644 LONESTA R Capital Recovery - Sewer280,541.10280,474.480.2800 -66.62280,541.10 N/A280,541.10 Capital Recovery - Water452,860.2452,752.69.2800 -07.5552,860.24 N/A52,860.24 40144 Drainage Fund283,261.40283,194.130.2800 -67.27283,261.40 N/A283,261.40 GO SR2011 Animal Shelter2,251,441.29,250,906.61.2800 -34.68,251,441.29 N/A,251,441.29 20522 GO SR2011 Athletic Fields1,480,517.811,480,166.210.2800 -351.601,480,517.81 N/A1,480,517.81 GO SR2011 Soccer Fields1,440,958.39,500,604.40.280053.990,000.00,440,958.39 N/A,440,958.39 103611 GO SR2011 Swimming Pool2,937,236.942,936,539.400.2800 -697.542,937,236.94 N/A2,937,236.94 W/S-Customer Deposits293,783.2993,713.52.2800 -9.7793,783.29 N/A93,783.29 20622 W/S-Equipment Repl/Cap.Imp373,218.71373,130.080.2800 -88.63373,218.71 N/A373,218.71 Water&Sewer1,358,252.83,357,930.27.2800 -22.56,358,252.83 N/A,358,252.83 10311 W/S-Vehicle Replacement544,197.49544,068.250.2800 -129.24544,197.49 N/A544,197.49 69,210.45.28003.95-69,274.4069,274.40 Water/SSLG - SAWS269,274.40 20622 TOTAL LONESTA11,965,543.892,022,690.49,853.400,000.001,965,543.891,965,543.89 R12611 MBIA Tax I&S2,637,422.491,110,214.900.19001,527,207.59-2,637,422.49 N/A2,637,422.49 Police Forfeiture359,258.6459,199.43.1900 -9.2159,258.64 N/A59,258.64 30533 Economic Development Corporation1,616,169.731,315,949.540.1900 -300,220.191,616,169.73 N/A1,616,169.73 Special Events Fund66,581.476,570.47.1900 -1.006,581.47 N/A6,581.47 60166 EMS Tax Notes 2010300,867.9800,818.42.19009.56-00,867.9800,867.98 30433 TOTAL MBIA4,980,300.313,152,752.761,827,547.55-4,980,300.314,980,300.31 FEDERATED SR2007a Bond-City Wide Projects868,106.8267,884.45.1300 -22.3768,106.82 N/A68,106.82 80288 Hotel Occupancy Tax78,161.0478,141.020.1300 -20.0278,161.04 N/A78,161.04 Park Fund (Developers Fee)252,803.6152,738.85.1300 -4.7652,803.61 N/A52,803.61 20622 Park Fund (Tree Mitigation)126,288.98126,268.250.1900 -20.73126,288.98 N/A126,288.98 Tax I&S56.826.81.1900 -.016.82 N/A6.82 50055 Library Board Fund44,700.634,689.18.13001.45-4,700.634,700.63 40144 TOTAL FEDERATED1,370,117.901,369,778.56 -339.341,370,117.901,370,117.90 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,269,927.41,321,773.26.0100 276.6650.33,322,246.93 N/A,334,819.91 13711 Capital One Capital Recovery1,630,820.22,729,754.25.6900,500.48,393.07,729,861.66,709,397.22 121111 TOTAL CAPITAL ONE2,900,747.633,051,527.512,250.811,669.733,052,108.593,044,217.13 52 City Portfolio By Investment Type Schertz Bank &Trust C.D.s 10% Operations Account Schertz Bank & Trust Capital One 5% Managed 9% LOGIC Pool FEDERATED Pool 21% MBIA Pool 16% LONESTAR Pool 13% 54 City Portfolio By Use Pooled-Daily Operations, $2,866,957 Designated Funds, $8,429,218 Special Revenue Funds, $9,052,232 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.02000.0100 1 Month T-Bill 0.01000.01000.0200 3 Month T-Bill 0.06000.06000.0600 6 Month T-Bill 0.46000.52000.4900 Schertz Portfolio 0.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.1000 CD 365 Days 0.80000.80000.3000 CD 180 Days 0.25000.25000.1000 CD 90 Days 0.05000.05000.0500 CD 28 Days 0.14700.18740.2085 LOGIC 0.23000.25000.2800 LoneStar 0.14000.15000.1900 MBIA 0.09000.14000.1300 Federated 2.32432.84002.8300 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:12/31/2011 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69114,927.4114,927.4114,927.411.000.01 General Elec Cap Corp Disc Com Paper3/12/201272.0065,000.0064,891.2264,891.220.000.00 JPMorgan Chase Disc Bank Accpt Note3/1/201261.0065,000.0064,941.4564,941.45 Total Cash & Equivalent44,927.41144,760.044,760.0 s1818 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014956.00125,000.00141,987.30140,968.756,875.00 Federal Home Loan Bks Cons Bds6/21/2013538.0080,000.0082,004.4081,818.401,500.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012291.00150,000.00162,031.50155,052.006,750.00 Federal Home Ln Mtg Corp Deb11/15/2013685.00170,000.00191,084.25184,239.208,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013633.00250,000.00250,000.00267,280.0010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141060.00100,000.0099,874.40100,176.00750.00 250,505.00251,345.00 Federal Natl Mtg Assn 4/20/2012111.00250,000.00 Total Fixed Incom,125,000.01,177,486.8,180,879.3 e105153 Total Assets497.981,269,927.411,322,246.931,325,639.433 Cap Recovery Fun d Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #69125,820.2225,820.2225,820.222.000.01 General Elec Cap Corp Disc Coml Paper3/12/201272.0085,000.0084,857.7484,857.740.000.00 JPMorgan Chase Disc Bank Accpt Note3/1/201261.0085,000.0084,923.4384,923.43 Total Cash & Equivalent95,820.2195,601.395,601.3 s12919 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014956.00165,000.00187,423.24186,078.759,075.00 Federal Home Loan Bks Cons Bds6/21/2013538.00100,000.00102,505.50102,273.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012291.00250,000.00270,052.50258,420.0011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013685.00250,000.00281,006.25270,940.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013654.00200,000.00223,001.60215,172.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141060.00220,000.00220,078.68220,387.201,650.00 0/30/201204.0050,000.00250,192.5050,650.00 Federal Natl Mtg Ass n1322 Total Fixed Incom,435,000.01,534,260.2,503,920.9 e107154 Total Assets561.821,630,820.221,729,861.661,699,522.344