Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02-NOVEMBER 2010 STATEMENT
NOVEMBER 2010 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department JANUARY 21, 2011 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMAR Y Taxes10,912,656 583,335.59 2,345,048.03 8,567,607.97- -2,954,484.43 Franchises 1,521,000 372,668.70 373,077.15 -373,800.02 -1,147,922.85 Permits 1,181,913 70,585.50 523,543.33 -113,805.99 -658,369.67 Licenses 64,547 1,115.00 4,187.50 2,755.10 - -61,791.90 Fees 3,073,872 159,122.28 558,860.85 -331,830.47 -2,515,011.15 Fines 35,000 2,291.90 4,638.90 4,252.23 - -30,747.77 Inter-Jurisdictional 405,672 20,971.97 75,554.24 -176,959.05 -330,117.76 Fund Transfers 1,184,474 4,133.27 - - - -1,184,474.00 Miscellaneou25,688.24 79,153.6769,604.94 s 507,284 - - TOTAL REVENUES18,886,4181,235,779.184,033,444.573,962,244.60 - - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,813.46 921.29 3,584.50 - -19,215.50 Supplies 500 33.26 22.00 - - - City Support Services 20,500 110.00 8,320.70 110.00 100.00 - Operations Support 300 74.08 - - - - Staff Support355.70380.00 2,680.90735.70 16,400 7,458.02 Opertating Equipment- - - - - - TOTAL CITY COUNCIL 60,500 2,279.16 380.00 12,030.23 4,430.20 7,580.02 CITY MANAGE R Personnel Services 718,457 64,560.44 110,016.35 -102,693.84 -608,440.65 Supplies 2,400 174.35 - - -200.24 City Support Services - - - - - - Operations Support - - - - - - Staff Support 25,550 3,510.83 438.80 1,067.39 3,570.83 4,615.50 Operating Equipment133.43- 133.43 - - - TOTAL CITY MANAGER 68,204.70746,407.00 438.80 103,935.58 113,720.61 4,815.74 628,309.45 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COUR T Personnel Services250,20322,782.2638,543.36 -31,292.95 -211,659.64 Supplies 3,200 (43.36) 133.03 343.69 47.60 - City Support Services 1,000 - - - - - Operations Support 3,000 - - - - - Staff Support 4,200 361.00 33.44 925.49 394.44 312.88 Court Support 800 - - - - - Professional Services 88,100 3,596.25 7,875.00 6,825.00 26,110.00 - Maintenance Services 1,000 - - - - - Operating Equipment 250.00291.98 2,000 - - - TOTAL MUNICIPAL COURT 353,503 26,696.15 33.44 40,518.45 46,356.49 26,470.48 CUSTOMER RELATIONS-311 Personnel Services 88,928 8,325.52 13,592.91 -27,563.66 -75,335.09 Supplies 500 - - - - - Staff Support- - 1,105 - - - TOTAL CUSTOMER RELATIONS-31190,5338,325.5213,592.91 -27,563.66 -76,940.09 PLANNING & ZONING Personnel Services 134,105 12,903.27 21,218.71 -20,200.44 -112,886.29 Supplies 4,500 24.75 17.90 24.75 33.61 - City Support Services - - - - - - Operations Support 2,300 - - - - - Staff Support 22,100 295.25 6,453.06 322.19 300.31 - Professional Services 142,300 9,060.06 9,060.06- - -133,239.94 Operating Equipment -217.65 600 - - - TOTAL PLANNING & ZONING 305,905 22,283.33 30,625.71 333.92 274,945.37 -26,889.05 LEGAL SERVICE S Operations Support 13,000 - - - - -13,000.00 Professional Services- - 245,000 - - - TOTAL LEGAL SERVICES258,000- - - - -258,000.00 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANC E Personnel Services630,02474,902.39112,999.22 -98,261.53 -517,024.78 Supplies 59,900 6,107.62 638.43 7,882.57 7,433.35 11,696.79 Utility Services 93,600 349.62 9,697.13 5,350.49 - -88,249.51 Operations Support - - - - - - Staff Support 7,712 294.96 403.00 745.29 1,719.36 1,433.42 Maintenance Services 111,950 4,470.99 6,471.04 17,684.94 41,733.75 1,650.49 Rental/Leasing 2,000 - - - -456.96 Operating Equipment - - - - - - Capital Outla- - y 24,500 - - - TOTAL FACILITIES MAINTENANCE929,68686,125.587,512.47134,271.46169,236.1715,237.66 CITY SECRETAR Y Personnel Services 167,842 15,734.56 26,329.28 -23,155.90 -141,512.72 Supplies 1,550 33.25 32.46 55.85 20.02 - City Support Services 9,780 75.00 - - - - Operations Support - - - - - - Staff Support 295.00 590.4469.40 5,700 - 883.58 TOTAL CITY SECRETARY 184,872 15,767.81 295.00 23,332.76 26,975.57 903.60 NON-DEPARTMENTA L Supplies 3,000 611.98 - - - - City Support Services 369,000 100,494.07 760.00 170,856.41 160,342.54 -209,417.46 Operations Support 114,000 1,622.89 8,509.56 16.10 -15,346.03 City Assistance 387,459 96,864.87 - -99,882.39 -290,594.13 Professional Services 106,350 1,341.88 9,886.08 4,030.66 - -102,319.34 Fund Chrgs/Transfrs-Spec Events Fnd 24,350 - -49,100.00 - -24,350.00 Operating Equipment 500 - - - - - Capital Outla -4,133.27 y 7,000 - - - TOTAL NON-DEPARTMENTAL1,011,659103,458.84760.00349,816.16269,747.6316.10 PUBLIC AFFAIR S Personnel Services 131,096 11,775.44 22,452.01 -26,062.65 -108,643.99 Supplies 2,450 14.97 1,240.30 14.97 30.08 - Operations Support 47,500 1,919.50 1,999.36 681.21 -13,769.30 Staff Support 3,750 352.50 1,271.63 457.58 205.29 - 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Professional Services - - -45,894.73 - - -589.94 Operating Equipment - - - 6,000 TOTAL PUBLIC AFFAIRS 190,796 14,062.41 24,923.92 916.58 -88,828.55 RECORDS MANAGEMEN T Personnel Services 46,317 4,557.23 6,562.86 7,494.22 - -38,822.78 Supplies 900 - - - - - Staff Support 1,500 - 85.00 - - - Professional Services 15,000 291.00 361.50 577.00 500.00 - Operating Equipment- - - - - - TOTAL RECORDS MANAGEMENT 4,848.2363,7176,924.368,156.22500.00 - SCHERTZ TALES MAGAZIN E Personnel Services 126,426 9,938.84 16,934.37- - -109,491.63 Staff Support 1,000 - 23.28 - - - 32,842.77- 35,708.21179,731.46 Professional Services - 252,500 TOTAL SCHERTZ TALES MAGAZINE 379,926 42,781.61 52,642.58- 179,754.74 - ENGINEERING Personnel Services 169,469 16,097.83 26,313.82 -25,185.51 -143,155.18 Supplies 300 8.35 - 8.35 - - Staff Support 2,213 260.00 265.00 - - - Professional Services 24,000 636.68 - - -1,440.00 Maintenance Services 4,044 1,200.00 2,145.29 - - - Operating Equipment- - - - - - TOTAL ENGINEERING 200,026 16,106.18 28,732.46 1,440.00 -27,282.19 GIS Personnel Services 117,358 10,240.01 17,693.96 -16,761.52 -99,664.04 Supplies 3,300 - - - - - Staff Support 1,050 - - - - - - - Professional Services - - - 2,000 TOTAL GIS 123,708 10,240.01 17,693.96 -16,761.52 -106,014.04 TOTAL GENERAL GOVERNMENT4,899,238 421,179.53 9,419.71 858,153.97 806,834.43 237,968.84 3,863,854.44 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC SAFETY POLICE Personnel Services4,083,030 452,072.39 705,937.23 -684,157.67 -3,377,092.77 Supplies50,558 268.40 124.50 904.05 368.88 3,757.03 46,556.59 City Support Services30,000 - -26,534.00 - -30,000.00 Utility Services 100,000 7,698.91 6,788.53 - - -93,211.47 Operations Support 2,000 98.00 21.50 98.00 - - Staff Support 31,350 484.74 1,563.87 484.74 631.00 - City Assistance 13,000 720.00 100.00 549.03 - - Professional Services 8,000 - - - - - Maintenance Services 76,949 9,122.75 179.50 10,732.00 11,081.25 -66,047.25 Operating Equipment 63,996 3,441.90 5,196.00 10,592.00 8,637.90 14,199.64 Capital Outla -91,420.00239,292.00 y 169,998 - - TOTAL POLICE 4,628,881 465,488.18 5,500.00 834,344.00 733,496.53258,428.70 FIRE RESCUE Personnel Services 2,410,836 264,773.49 412,236.88 -382,169.39 -1,998,599.12 Supplies 20,200 150.00 20.15 837.49 170.15 1,198.55 Utility Services 43,900 2,668.07 3,421.84 5,013.34 148.27 - Operations Support 1,100 146.00 - - - - Staff Support 116,800 805.99 1,193.00 11,108.39 8,004.54 10,832.45 City Assistance 18,600 2,715.75 10,323.17 -10,323.17 -18,600.00 Professional Services 18,140 - - - -1,500.00 Maintenance Services 55,000 59.95 - 59.95 - -54,940.05 Operating Equipment674.94604.50 1,393.874,050.00 44,400 10,059.41 TOTAL FIRE 2,728,976 269,132.44 12,140.82 404,448.86 437,201.90 23,738.68 INSPECTIONS Personnel Services 364,194 34,546.16 57,456.63 -54,231.54 -306,737.37 Supplies 6,750 10.00 - 10.00 97.10 - Utility Services 7,600 455.12 671.94 - - - Operations Support 3,200 375.00 - - - - Staff Support 14,700 170.00 388.20 1,290.00 691.89 716.80 Professional Services 10,000 - - - - -10,000.00 Maintenance Services - - - - - - Operating Equipment- - - - - - TOTAL INSPECTIONS 406,444 34,726.16 388.20 56,351.66 58,830.46 813.90 MARSHAL SERVIC E 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Personnel Services513,25043,933.9667,221.65 -62,929.30 -446,028.35 Supplies 6,450 20.34 - - - - Utility Services 9,000 529.00 487.92 - - - Operations Support 4,000 12.44 - 12.44 462.50 - Staff Support 9,400 34.04 1,708.48 473.61 - - Professional Services - - - - - - Maintenance Services 12,400 110.00 116.00 222.00 32.00 - Operating Equipment 2,324.04- 21,480 - - 2,722.94 Capital Outla15,588.00- 15,588.00 y 65,600 - 24,818.00 TOTAL MARSHAL SERVICE641,58059,678.4486,329.6628,035.44 -65,303.12 TOTAL PUBLIC SAFETY 8,405,881 829,025.22 18,029.02 1,360,447.641,315,858.55311,016.72 PUBLIC ENVIRONMENT STREETS Personnel Services604,591 84,491.00 118,916.64 -114,957.73 -485,674.36 Supplies6,300 1,135.83 28.15 528.31 1,202.60 601.07 4,524.48 Utility Services101,900 639.59 9,291.23 9,162.86 373.58 - Operations Support 1,380 - - - - - Staff Support 9,265 84.08 655.15 1,059.7484.08 - Maintenance Services 155,400 11,931.03 16,620.12 3,629.23 27,764.66 7,639.07 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - - - - Capital Outla2,100.00- 2,100.00 y 14,500 - 15,770.00 TOTAL STREETS 897,736 100,297.45 16,732.35 129,061.65 159,230.84 25,443.46 TOTAL PUBLIC ENVIRONMENT 897,736 100,297.45 16,732.35 129,061.65 159,230.84 25,443.46 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PARKS & RECREATION PARKS DEPARTMENT Personnel Services489,640 50,126.34 78,294.29 -71,015.98 -411,345.71 Supplies40,555 1,379.58 4,879.22 2,300.11 33,375.67 -11,196.51 - City Support Services - - - - - Utility Services 110,000 631.99 7,468.66 6,354.86 293.54 - Operations Support 700 600.00 - 600.00 - - Staff Support 7,686 10.00 202.35 1,502.08 1,048.50 1,632.11 Professional Services 35,000 8,045.00 8,045.00- - -26,955.00 Maintenance Services 21,000 140.79 7,333.94 140.79 8.48 - Rental/Leasing 30,531 5,391.50 3,491.50 124.33 8,752.46 1,900.00 Operating Equipment 5,974.00 - - - - - Capital Outla- - y 7,000 - - 2,164.55 TOTAL PARKS DEPARTMENT 742,112 65,725.20 4,293.85 104,615.50 108,115.12 8,298.79 SWIM POOL Supplies 16,700 289.96 53.39 (839.99) 343.35 -16,410.04 Utility Services 25,500 2,651.58 882.37 - - -24,617.63 Staff Support 925 - - - - - Maintenance Services 199,378 2,760.80 - - - -199,378.00 Rental/Lease- - 500 - - - TOTAL SWIM POOL243,003289.9653.394,572.391,225.72 -241,830.67 COMMUNITY/CIVIC CENTER Personnel Services 115,041 2,140.16 7,271.02 -13,625.02 -107,769.98 Supplies 6,423 220.04 2,616.61 1,513.31 1,418.78 - Utility Services 47,150 23.99 4,208.51 2,447.56 - -44,702.44 Operations Support 15,282 1,000.00 95.00 - - -15,187.00 Staff Support 3,250 68.20 - - - - Operating Equipment100.00 100.005,654.16 7,172 - - TOTAL COMMUNITY/CIVIC CNTR 194,318 2,484.19 11,426.89 1,418.78 -27,172.50 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET SENIOR CITIZEN CENTE R - - Supplies - - - - - Utility Services - - - - - - City Assistence - - - - - - - - Maintenance Services - - - - TOTAL SENIOR CITIZEN CENTER - - - - - - TOTAL PARKS & RECREATION 1,179,433 68,499.35 4,347.24 136,360.39 120,767.73 9,717.57 CULTURAL LIBRAR Y Personnel Services667,83264,572.89106,206.76 -89,199.58 -561,625.24 Supplies 16,400 151.36 420.25 151.36 2,701.50 - Utility Services 39,500 18.45 4,904.96 2,792.27 - -36,707.73 Operations Support 2,500 - - - - - Staff Support 4,185 145.25 23.25 891.54 164.17 39.00 Professional Services 2,100 200.68 - - - - Maintenance Services 3,500 400.00 2,400.00 400.00 - - Operating Equipment 65,000 47.36 156.44 272.36 7,873.47 - Capital Outla- - y - - - - TOTAL LIBRARY 801,017 65,287.95 70.61 98,173.45 109,986.92 10,613.97 TOTAL CULTURAL 801,017 65,287.95 70.61 98,173.45 109,986.92 10,613.97 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICE S Personnel Services 302,083 31,148.90 50,924.15 -49,801.36 -251,158.85 Supplies 24,900 1,423.88 42.00 1,943.31 1,465.88 1,319.74 Utility Services 9,900 633.31 517.24 - - - Operations Support 800 - - - - - Staff Support 5,800 13.81 2,581.07 13.81 467.86 - City Assistance 13,000 1,037.98 746.50 1,037.98 - -11,962.02 Professional Services 14,500 1,568.50 962.50 1,568.50 150.00 - Maintenance Services 6,100 396.78 - 396.78 1,950.00 - Operating Equipment 17.90 9,000 - - - - Capital Outla- - y 4,000 - - - TOTAL ANIMAL SERVICES 390,083 35,589.85 42.00 56,685.95 55,924.34 3,887.60 TOTAL HEALTH 390,083 35,589.85 42.00 56,685.95 55,924.34 3,887.60 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services261,085 23,251.44 37,772.47 -28,065.98 -223,312.53 Supplies1,500 112.50 - - -346.30 City Support Services 337,952 7,414.00 29,701.17 15,859.12 -23,093.17 Utility Services 147,131 2,897.99 7,815.19 -16,677.29 -139,315.81 Staff Support 10,400 60.00 1,813.95 2,046.42 2,019.20 1,023.52 Professional Services - - - - - - Maintenance Services 21,100 1,730.00 4,857.03 5,784.75 165.32 - Operating Equipment 135,836 17,859.07 3,756.50 17,988.07 4,926.27 - Capital Outla- - y 45,809 - - - TOTAL INFORMATION TECHNOLOGY 960,813 53,212.50 1,813.95 78,608.89 101,080.85 22,320.53 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCE S Personnel Services218,82117,303.1428,585.74 -38,240.12 -190,235.26 Supplies 1,700 - - - - - Human Services 46,122 1,332.12 8,574.36 2,562.24 - -43,559.76 Operations Support 12,545 266.28 3,365.38 266.28 1,597.68 - Staff Support 11,982 3,293.00 6,766.00- 1,589.65 - City Assistance 9,425 622.00 2,445.00 622.00 - - Operating Equipment- - 2,500 - - - TOTAL HUMAN RESOURCES 303,095 22,550.26 266.28 52,624.86 38,802.26 3,187.33 FINANC E Personnel Services 419,818 38,318.86 64,739.74 -67,208.69 -355,078.26 Supplies 3,600 157.51 211.33 1,014.92 46.91 - Operations Support 1,050 (0.01) 155.80 - - - Staff Support 13,370 540.00 240.00 540.00 575.00 - Operating Equipment- - 1,000 - - - TOTAL FINANCE438,83839,016.36 66,294.66 621.91 371,921.43 -67,815.82 PURCHASING & ASSET MG T Personnel Services 234,220 22,076.37 36,904.01 -39,037.04 -197,315.99 Supplies 2,300 239.14 - - - - Utility Services 1,200 31.53 - - - - Operations Support 150 - - - - - Staff Support 6,900 435.46 408.14 435.46 1,171.35 - Operating Equipment- - 150 - - - TOTAL PURCHASING & ASSET MGT 244,920 22,511.83 37,339.47 1,171.35 -39,715.85 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUN CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF D FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services148,533 19,747.39 28,927.51 -26,879.38 -119,605.49 Supplies101,000 11,423.78 4,644.98 14,090.84 16,232.75 4,635.23 84,777.00 City Support Services1,500 1,500.00 1,500.00 1,500.00 - - Utility Services 7,000 345.19 223.91 - - - Operations Support 400 - - - - - Staff Support 2,435 84.47 295.80 218.44 - - Professional Services - - - - - - Maintenance Services 45,750 882.45 474.24 (1,639.76) 2,446.73 2,363.95 Rental/Lease - 200 - - - - Operating Equipment- - 6,000 - - - TOTAL FLEET SERVICE312,81833,553.625,119.2241,260.1249,626.707,217.62 TOTAL INTERNAL SERVICE 2,260,484 170,844.57 7,199.45 280,025.54 293,143.94 34,518.74 MISC & PROJECTS CITY ASSISTANC E Utility Services - - - - - Patient Assistance 5,000 5,000.00 5,000.00 5,000.00 - - Children's Advocacy Assistance 5,000 - - - - - Library Capital Campaign - - - - - - Senior Citizen's Hot Meal- 10,500.00 s 42,000 - - 31,500.00 TOTAL CITY ASSISTANCE 52,000 5,000.00 5,000.00 15,500.00 31,500.00 - TOTAL MISC & PROJECTS 52,000 5,000.00 5,000.00 15,500.00 31,500.00 - TOTAL EXPENDITURES18,885,8721,695,723.92 55,840.38 2,923,908.592,877,246.75664,666.90 REVENUE OVER(UNDER) EXPEND.1,084,997.85 546 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,704,566 244,254.74 2,922,378.87- 1,650,415.21 - 5,054,150.79 000-411200Advalorem Tax - Delinquent 50,000 4,525.64 14,341.10- 8,225.76 - 41,774.24 000-411300Advalorem Tax - P&I 50,000 1,310.32 - 3,977.28 2,277.15 - 47,722.85 000-411500Sales Tax Revenue-Gen Fund4,071,590 332,263.69 - 4,303.70 674,346.80 - 3,397,243.20 000-411600Bingo Tax 4,500 981.20 - 1,379.22 981.20 - 000-411700Mixed Beverage Ta 8,801.918,104.26 x 32,000.00 - - - TOTAL Taxes10,912,656 583,335.59 2,954,484.43- 2,345,048.03 - 8,567,607.97 Franchises 000-421200Center Point/Entex Energy 33,000 - - - - - 33,000.00 000-421220City Public Service 275,000 83,433.23 77,354.41- 83,433.23 - 191,566.77 000-421240Guadalupe Valley Elec Co-op 430,000 124,838.75 141,613.56- 124,838.75 - 305,161.25 000-421250New Braunfels Utilities 30,000 7,403.70 - - 7,403.70 - 22,596.30 000-421300Time Warner-State Franchise 350,000 87,894.73 81,775.18- 87,894.73 - 262,105.27 000-421350Time Warner-PEG Fee 62,000 16,416.59 15,960.54- 16,416.59 - 45,583.41 000-421460AT&T Franchise Fee 220,000 43,231.13 34,667.99- 43,536.50 - 176,463.50 000-421465AT&T PEG Fees 16,000 5,497.29 3,548.30 5,497.29 - 10,502.71 000-421480Other Telecom Franchise 15,000 3,953.28 - 2,915.56 4,056.36 - 10,943.64 000-421500Solid Waste Franchise Fee90,00015,964.48- - - - TOTAL Franchises1,521,000372,668.70 373,800.02-373,077.15 - 1,147,922.85 Permits 000-431100Home Occupation Permit 770 - - 35.00 - - 000-431200Building Permit 837,952 51,150.00 59,869.19- 469,766.83 - 368,185.17 000-431300Mobile Home Permit 671 - - 40.00 - - 000-431400Signs Permit 8,596 25.00 - - 75.00 - 000-431500Food Establishmnt Permit 15,000 150.00 10,350.00- 7,595.00 - 000-431600Garage Sale Permit 9,554 820.00 - 2,335.30 2,310.00 - 000-431700Plumbing Permit 109,769 6,045.50 13,474.50- 13,481.50 - 96,287.50 000-431750Electrical Permit 63,062 3,600.00 - 9,035.50 9,220.00 - 53,842.00 000-431800Mechanical Permit 84,211 4,880.00 10,134.00- 11,260.00 - 72,951.00 000-431900Solicitor/Peddler Permit 60.00 - 180.00 60.00 - - 000-431950Animal/Pet Permit 2,000 300.00 - 555.00 925.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt6,578500.00-500.001,300.00 - 000-432100Security Alarm Permit 36,000 2,680.00 - 6,385.00 6,050.00 - 29,950.00 000-435000Fire Permit7,750375.00 1,500.00912.50 - - TOTAL Permits1,181,91370,585.50 113,805.99-523,543.33 - 658,369.67 Licenses 000-441000Alcohol Beverage License 6,100 105.00 - 892.50 135.00 - 000-442000Contractors License 55,447 700.00 - 2,328.00 1,850.00 - 53,597.00 000-444000Pet License3,000310.00 770.10967.00 - - TOTAL Licenses 64,547 1,115.00 - 4,187.50 2,755.10 - 61,791.90 Fees 000-451000Municipal Court Fines 1,540,000 59,873.70 168,927.53- 164,638.80 - 1,375,361.20 000-451100Arrest Fee 60,000 3,645.19 - 7,838.61 7,834.35 - 52,165.65 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 187,500 7,546.10 21,121.25- 15,434.00 - 172,066.00 000-451320Civil Justice Fee-Court 500 5.58 - 12.42 - 000-451340Judicial Fee - City 7,000 470.97 - 1,038.92 1,017.20 - 000-451400Traffic Fine Costs TTL 30,000 1,851.45 - 4,005.22 4,043.13 - 25,956.87 000-451500Teen Court Admin Fee 500 60.00 - 180.00 120.00 - 000-451510Juvenile Case Mgmt Fee 60,000 3,934.42 - 8,637.60 8,486.41 - 51,513.59 000-451600Technology Fund Fee 55,000 3,118.97 - 7,128.56 6,740.24 - 48,259.76 000-451700Security Fee 40,000 2,339.23 - 5,349.44 5,055.16 - 34,944.84 000-451800Time Payment Fee - City 5,000 439.59 - 543.56 799.73 - 000-451850State Fines 10% Service Fee 70,000 - 18,394.21- 19,298.66 50,701.34 000-451900DPS Payment - Local 12,250 657.16 - 1,663.46 1,322.09 - 10,927.91 000-452000Child Safety Fee 8,000 1,017.44 - 1,261.06 2,218.54 - 000-452050Indigent Defense Fee 22,500 1,553.60 - 3,322.58 3,322.37 - 19,177.63 000-452100Platting Fees 66,000 10,500.00 - 6,750.00 13,500.00 - 52,500.00 000-452200Site Plan Fee 26,400 2,000.00 - 4,149.45 4,000.00 - 22,400.00 000-452300Plan Check Fee 375,000 26,150.50 26,645.00- 235,492.91 - 139,507.09 000-452320Tree Mitigation Admin Fee 11,220 - - - - - 11,220.00 000-452400BOA/Zoning Fees 11,000 - - 1,750.00 700.00 - 10,300.00 000-452500Food Handler Class 8,000 40.00 - 900.00 470.00 - 000-452600Specific Use/Zone Chng Fee 14,630 - - - - - 14,630.00 000-452610Plat Recording Fee - - - - - - 000-452710Zoning Ltr & Dev Rights 75.00 - 225.00 150.00 - - 000-453100Reinspection Fees 49,000 5,500.00 -8,400.00 9,825.00 - 39,175.00 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-453110Swim Pool Inspection Fee---- - - 000-453120Inspections Plan Review - - 200.00 - - - 000-453200Mowing Fees - Inspections - 434.61 7,684.26 - 6,878.38 - (7,684.26) 000-453211Admin Fee-Inspections 700.00 - - 1,500.00 - - (1,500.00) 000-4532153% Technology Fee - - 482.68 - - 000-453300Solictor's Investigation - - - - - - 000-453310Misc Inspection Fee 55.00 - 35.00 35.00 - 000-453500SubContractor Reg. Fee 495.00 - 3,490.00 1,305.00 - - (1,305.00) 000-453710Foster Care 50.00 - - 200.00 - - 000-454100Swim Pool Reservation Fee - - - - - 000-454200Pool Gate Admission Fee 22,000 - - - - - 22,000.00 000-454300Seasonal Pool Pass Fee 5,500 - - - - - 000-456500Haz Mat Fees 2,500 - - - - - 000-456510Fire Plan Review800 - - - - - 000-456600Fire Re-inspection Fee 450 60.00 - - 250.00 - 000-458300Sale of Property/Auction 20,000 333.91 - 964.98 304.33 - 19,695.67 000-458400Civic Center Rental Fees 226,000 7,147.08 18,263.75- 20,712.24 - 205,287.76 000-458401Capital Recovery Fee-Civic Cntr 15.00 - - 415.00 - 000-458450North Center Rental Fees 24,000 - - - 1,061.00 000-458500Community Center Rental Fees32,000 1,435.00 - 3,865.00 2,698.00 - 29,302.00 000-458550Pavilion Rental Fees 400.00 - - 3,163.00 - 000-458570Non-Resident SYSA League 18,000 7,060.00 - - 7,060.00 - 10,940.00 000-458600Ball Field Use - - - - - - 000-458650NonResident User Fee-BVYA 9,000 1,410.00 - - 1,410.00 - 000-458680Tournament Fees-Soccer 14,000 - - - - - 14,000.00 000-458700Vehicle Impoundment 5,000 - - - - - 000-459200NSF Check Fee100--29.00158.00 - 000-459300Notary Fee 200 30.00 - 36.00 54.00 - 000-459400Maps, Copies, UDC, & Misc F 200 5.00 - 5.00 5.00 - 000-459600Animal Adoption Fee 10,500 650.00 - 1,325.00 2,010.00 - 000-459700Pet Impoundment Fee 17,500 1,259.01 - 3,366.00 3,491.01 - 14,008.99 000-459800Police Reports Fee6,532360.00 864.001,102.00 - - TOTAL Fees 3,073,872 159,122.28 331,830.47- 558,860.85 - 2,515,011.15 Fines 000-463000Library Fines35,0002,291.90 4,252.234,638.90 - - TOTAL Fines 35,000 2,291.90 - 4,638.90 4,252.23 - 30,747.77 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Inter-Jurisdictional 000-473100Bexar Co - Fire 21,078 1,756.48 - 3,512.96 3,512.96 - 17,565.04 000-473200City of Seguin - Fire Contract 40,293 3,355.26 - 6,710.52 6,710.52 - 33,582.48 000-473300Guad Co - Library 180,816 15,068.00 30,135.82- 30,136.00 - 150,680.00 000-473400Randolph AFB-Animal Cntrl 2,500 300.00 - 150.00 800.00 - 000-474200Library Services - Cibolo - - - - - - 000-474210Library Services-Selma 19,000 - - - - - 19,000.00 000-474250Non-Resident Library Fees - - - - - - 000-474400Dispatch Service - Cibolo 133,305 - 133,305.00- 33,326.25 - 99,978.75 000-474500Dispatch Service - SCUCISD 2,080 - - 2,080.00 - - 000-474600School Crossing Guard-Bexar6,600492.23 1,068.511,064.75 - - TOTAL Inter-Jurisdictional405,67220,971.97 176,959.05-75,554.24 - 330,117.76 Fund Transfers 000-480000Indirect Costs - EMS 87,840 - - - - - 87,840.00 000-480100Indirect Costs - Hotel/Motel 170,221 - - - - - 170,221.00 000-482100Transfer From Reserves-Ct Tech - - - - - 000-482150Transfer From Court Security 58,011 - - - 58,011.00 000-485000Interfund Charge-Drainage 38,888 - - - - - 38,888.00 000-486000Interfund Chrges-Admin W&S 624,777 - - - - - 624,777.00 000-486317Transfer From Park Fund - - 4,133.27 - - - 000-486322Transfer-In - Library Grants 10,000 - - - 10,000.00 000-487000Interfund Charges-Fleet 91,737 - - - - - 91,737.00 000-488000Interfund Charges-4B 53,000 - - - - - 53,000.00 000-490020Transfer In-SEDC50,000 -- - - - TOTAL Fund Transfers 1,184,474 - - 4,133.27 - - 1,184,474.00 Miscellaneous 000-491000Interest Earned5,000284.48-595.30618.26 - 000-491200Investment Income 26,000 2,787.35 - 5,012.57 4,790.60 - 21,209.40 000-491900Unrealized Gain/Loss - 4,748.75 (4,221.57) - (6,269.86) - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap.20,000 7,124.00 - 6,557.62 20,135.00 - 000-493400Donation - Animal Control 3,670 263.52 - 380.92 1,163.52 - 000-493401Donations-A/C Microchip 3,000 160.00 - 470.00 430.00 - 000-493402Donations-Spay&Neuter 12,000 1,035.50 - 1,659.50 3,445.50 - 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-493403Donations-Melvin Boeck A. S.---- - - 000-494481LawEnforcemtOfficersStnd&Ed 3,800 - - - - - 000-495015Contribution from SED---- - - 000-497000Misc Income-Gen Fund 40,000 7,750.75 - 9,286.93 10,343.74 - 29,656.26 000-497005Misc Income-Publications 240,000 5,645.00 27,107.00- 17,666.00 - 222,334.00 000-497007Misc Income-Schertz Artz - - - - - - 000-497020Misc Income-Fleet Recycled 400 - - 280.80 - - 000-497100Misc Income-Police 20,000 230.00 - 5,628.23 1,669.05 - 18,330.95 000-497200Misc Income-Library 12,131 215.10 - 1,609.01 436.20 - 11,694.80 000-497210Misc Income-Library Copier 3,400 881.00 - 1,417.75 - 000-497300Misc Income-Animal Control 2,400 - - 140.50 137.50 - 000-497400Misc Income-Streets Dept. 11,229 2,725.00 - 1,975.00 5,100.00 - 000-497500Misc Income-TML Insurance 78,043 - - - - 78,043.00 000-497550Misc Income-TML Reimbursemt20,211 2,702.40 - 3,402.66 7,506.52 - 12,704.48 000-497600Misc Income-Parks/Vending Mach.500 -154.00 750.15 404.53 - 000-497800Misc Income-Pool Concessions - - - - - - 000-498000Reimbursmnt-Gen Fund5,500 -33.00 - - - 000-498110Reimburmnt Fire - Emg. Acti-0 8,078.07- - - - - TOTAL Miscellaneous507,28425,688.24 69,604.94-79,153.67 - 428,130.33 TOTAL REVENUES18,886,4181,235,779.18 4,033,444.57- 3,962,244.60 - 14,924,173.40 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking1,027,305.76$ Cash in Investment Pools LOGIC Investment-General Fund505,128.16 LOGIC Investment-Equip Replacement73,188.00 LOGIC Investment-Veh Replacement7,064.19 LOGIC Investment-Air Condi Replacment122,165.07 CAPITAL ONE Investment-General Fund1,325,951.83 Total Cash in Bank & Investment Pools$3,060,803.01 17 ADVALOREM TAX $2,000,000 $1,500,000 $1,000,000 $500,000 $- $(500,000) OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,406,160 244,255 435,275 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 1,223,886 886,430 492,623 1,387,876 474,014 90,756 28,206 35,521 40,691 21,925 12,579 4,162 2006-07 18-A Sales Tax - General Fund $600,000 $500,000 $400,000 23% -3% 13% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 339,709 329,696 344,795 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 212,505 239,854 229,587 248,693 313,084 228,070 222,035 276,537 250,602 272,411 312,562 263,674 2005-06 By removing the $138,288.39 one time correction paid in the month of February the true sales tax percent is -11%. 18-B CITY PUBLIC SERVICE $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 83,433 - - - 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 57,413 38,691 42,722 60,515 2006-07 18-C C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 85,614.00 134,344.00- - - - 85,614.00 Wilenchik Walk for Life 28,000.00 - - - - - 28,000.00 TML Dinner 2,100.00 - - - - - 2,100.00 Hal Balwin Scholarship 1,000.00 - - - - - 1,000.00 Miscellaneous22,300.00163.39-5,334.02241.98 - TOTAL REVENUES139,014.00 163.39 - 139,678.02 241.98 - 138,772.02 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 24,250.00 500.00 - - 500.00 1,366.48 Employee Appreciation Event 5,000.00 (76.87) - - (76.87) - 5,076.87 4th of July Jubilee - - - - - - National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 30,500.00 - - - - - 30,500.00 Blue Santa 6,000.00 - - - - - 6,000.00 Schertz Fest 455.59 265.82 455.91 - - - TML Events 2,700.00 - - - - - 2,700.00 Schertz Sweetheart 32,000.00 600.00 1,058.00 5,542.38 1,658.00 2,191.06 Hal Baldwin Scholarship1,000.00- -- - - TOTAL CULTURAL 1,023.13106,300.00 1,513.59 5,808.20 2,537.04 3,557.54 101,719.01 TOTAL EXPENDITURES106,300.00 1,023.13 1,513.59 5,808.20 2,537.04 3,557.54 101,719.01 REVENUE OVER(UNDER) EXPEND32,714.00(2,295.06) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking74,309.53$ Cash in Investment Pools MBIA Special Events66,460.04 Total Cash in Bank & Investment Pools$140,769.57 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises138,0007,400.00 32,200.00-10,650.00 127,350.00- Fees13,679,7501,235,993.07 1,821,190.05-2,287,685.17 11,392,064.83- Fund Transfers480,616---- 161,232.00- Miscellaneous(2,610.02)8,495.2020,969.20 55,445 - - TOTAL REVENUES14,353,8111,240,783.051,861,885.252,319,304.37 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers -- 31,000 - - - TOTAL NON DEPARTMENTAL-- 31,000 - - -31,000.00 BUSINESS OFFICE Personnel Services458,64043,251.67 56,558.25-74,059.21 384,580.79- Supplies6,65092.66-577.7092.66588.40 Operations Support114,00010,655.84 14,981.21-10,828.484,126.28 Staff Support7,850--(43.87)490.45373.42 Professional Services9,000(1,160.39)-1,433.0243.41- Fund Charges/Transfers40,000---- 40,000.00- Maintenance Services12,000---- 12,000.00- Operating Equipmen5,600.00 5,965.62- t 6,800 - - TOTAL BUSINESS OFFICE58,439.7891,479.835,088.10 654,940 -73,506.31 W & S ADMINISTRATION Personnel Services1,212,507137,682.04 238,504.75-239,584.49 972,922.93- Supplies193,7001,222.86667.936,154.963,774.3753,486.57 Human Services338----- City Support Services130,0002,285.41 19,731.65-29,103.831,848.61 Utility Services2,780,900188,813.75 336,365.11-203,862.32 2,576,559.03478.65 Operations Support8,750266.2879.60245.73345.88532.56 Staff Support33,0001,189.801,339.004,320.632,473.454,411.97 City Assistance1,912102.00-102.00102.00- Professional Services150,0947,444.08 14,306.29-7,444.08 142,649.92- Fund Charges/Transfers2,368,176210,151.65- 210,151.65- 2,158,024.35- Maintenance Services4,838,250145,232.18116.41817,543.12457,542.173,793.90 Other Costs25,000620.00--620.00 24,380.00- Debt Service1,435,165- 315,985.06--- Rental-Leasing6,070416.80-509.66662.53- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Operating Equipment13,000- (3,400.00)- 5,020.99- Capital Outla - 22,432.00 55,670.00 2,330.00 y 58,000 -22,432.00 354,254.34- - - - Water Line Relocation - TOTAL PUBLIC WORKS13,254,862695,426.85 2,104,623.3024,634.94 1,178,098.77 125,243.25 11,976,155.349.65% MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services19,000---- 19,000.00- Operations Support500----- Professional Services45,000--- 4,420.23- Maintenance Services91,083.7822.35 335,500 - - - 22.354,420.23 TOTAL AVIATION HEIGHTS WTR IMP 400,000 - -91,083.78 FM3009 RD&BRIDGE EXPANSION Professional Services- 19,137.50- 19,137.50-11,221.30 29.03-30,809.24 Maintenance Services - - - 19,138 19,166.53-42,030.54 TOTAL FM3009 RD&BRIDGE EXPANSION - - TOTAL MISC & PROJECTS91,083.7819,188.8846,450.77 400,000 -19,137.50 TOTAL EXPENDITURES14,340,802753,86743,7722,269,2131,288,767176,782 1,030,536.89 ** REVENUE OVER(UNDER)EXPENSES ** 13,009 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWER CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 7,400.00 10,650.0032,200.00 000-421490Tower Leasing 138,000 - - TOTAL Franchises138,0007,400.00 32,200.00-10,650.00 -127,350.00 Fees 000-455200Garbage Collection Fee 3,300,000 274,971.12 479,581.44- 532,265.29 -2,767,734.71 000-455600Fire Line Fees 18,500 - - 18,430.00- - 000-455700Recycle Fee Revenue 155,000 15,204.59 20,816.84- 25,903.02 -129,096.98 000-455800W&S Line Constructn Reimbursemnt50,000 1,770.00 - 2,628.00 4,754.95 -45,245.05 000-457100Sale of Water 7,200,000 674,226.01 860,713.57- 1,158,664.39 6,041,335.61 000-457110Edwards Water Lease 127,250 - - 59,507.50- -67,742.50 000-457120Water Transfer Charge-Selma 5,000 - - 780.18 - - 000-457130Water Transfer Charge-U. C. 1,000 - - 3,914.06 - - 000-457200Sale of Meters 86,000 4,885.99 - 7,435.56 18,049.56 -67,950.44 000-457400Sewer Charges 2,560,000 251,767.01 415,440.69- 442,769.24 -2,117,230.76 000-457500Water Penalties 175,000 12,888.35 29,461.00- 26,909.93 -148,090.07 000-459200NSF Check Fee-Water&Sewer2,000280.00418.71431.29 - - TOTAL Fees 1,235,993.0713,679,750 - 1,821,190.05 2,287,685.17 - 11,392,064.83 Fund Transfers 000-486101Transfer In- General Fund 400,000 - - - - - 000-486204Interfnd Chrg-Drainage Bill80,616- - - - - TOTAL Fund Transfers480,616---- -161,232.00 Miscellaneous 000-490000Misc Charges 15,000 240.00 - 3,646.23 240.00 -14,760.00 000-491000Interest Earned 500 347.27 - 134.18 533.27 - 000-491200Investment Income 5,000 443.18 - 1,494.51 (9,551.29) -14,551.29 000-493130Library Donations - - 1.61 - - - 000-497000Misc Income-W&S 20,000 (3,640.47) - 3,218.67 (2,603.44) -22,603.44 000-497550TML Reimbursements - - 2,291.34- - -(2,291.34) 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC - - 24,940.96- - -(24,940.96) 000-498200W&S Project Reimbursement5,000-5,118.36 - - - TOTAL Miscellaneous 55,445 (2,610.02) - 8,495.20 20,969.20 - TOTAL REVENUES14,353,8111,240,783.05 1,861,885.25- 2,319,304.37 11,715,122.63 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking1,454,304.68$ Cash in Investment Pools Lone Star Investment-Water&Sewer989,364.50 Lone Star Investment-W&S Customer Deposits293,075.07 Lone Star Investment-W&S Equip Replacement372,319.02 Lone Star Investment-W&S Veh Replacement542,885.62 Schertz Bank & Trust-Certificate of Deposit1,030,000.00 $3,227,644.21 Total Cash in Bank & Investment Pools4,681,948.89$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees5,436,537 371,541.37 707,515.40- 764,256.37 - 4,672,280.63 Inter-Jurisdictional1,432,345 68,250.58 307,632.32- 347,940.23 - 1,084,404.77 Miscellaneous1,435.41-30,254.7125,147.84 334,850 - TOTAL REVENUES 441,227.36 - 1,045,402.43 1,137,344.44 - 6,066,387.56 7,203,732 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,391,410284,729.36 436,765.73-480,668.37 - 1,910,741.63 Supplies 41,083.07 314.10 57,747.78 48,921.09 23,885.58 327,874 Human Services - - - 847 - - City Support Services 3,897.05 12,725.71- 10,902.09 15,000 - 4,097.91 Utility Services 209.51 - 8,268.22 8,211.38 80,438 - 72,226.62 Operations Support 14,700.86 - 14,986.8626.08 7,111.61 30,000 Staff Support 3,827.70 171.35 16,732.35 5,665.95 22,088.26 75,600 City Assistance 72.00 - 598.24 72.00 7,753 - 7,681.00 Professional Services 7,810.28 160.00 21,116.92 27,285.53 1,494.46 137,890 Fund Charges/Transfers3,576,092 - 856,682.73- - - 3,576,092.00 Maintenance Services 5,660.58 - 3,565.78 7,317.08 42,320 - 35,002.92 Debt Service - - - 248,502 - - 248,502.00 Rental-Leasing - - 836.33 39,163.67 40,000 - - Operating Equipment210.00-18,559.34210.001,834.28 82,600 TOTAL PUBLIC SAFETY 362,200.41 645.45 1,432,788.88 605,076.68 56,414.19 6,395,480.58 7,056,326 TOTAL EXPENDITURE362,200.41645.451,432,788.88605,076.68 S 7,056,326 56,414.19 ** REVENUE OVER(UNDER) EXPENSES 532,267.76 * 147,406 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt5,336,537 363,821.37 - 707,515.40 756,536.37 14.18% -4,580,000.63 000-456110Subscription Program Fees100,0007,720.00 7,720.00- - - TOTAL Fees5,436,537371,541.37 707,515.40-764,256.37 -4,672,280.63 Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 68,250.58 - 47,687.74 68,250.58 23.85% -217,875.42 000-474300Cibolo Support219,699 53,325.00- 53,325.00 - -166,374.00 000-475100Comal Co ESD #6 75,369 - 18,293.44- - -57,075.56 000-475200Live Oak Support 152,569 37,031.25- 37,031.25 - -115,537.75 000-475300Universal City Support 210,545 51,103.13- 51,103.13 - -159,441.87 000-475400Selma Support 64,689 15,701.25- 17,182.50 - -47,506.50 000-475500Schertz Support 399,083 96,864.87- 96,864.87 - -302,218.13 000-475600Santa Clara Support 10,851 - 2,663.29 2,633.67 - -8,217.33 000-475800Marion Support13,4143,255.793,255.79 - - - TOTAL Inter-Jurisdictional1,432,345 68,250.58 307,632.32- 347,940.23 -1,084,404.77 Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 60.44 - 49.35 127.19 - - 000-493203Donations-EMS 6,000 - 6.00 250.00 - -5,750.00 000-497000Misc Income 150,000 906.81 19,036.36- 11,043.97 -138,956.03 000-497100Recovery of Bad Debt 100,000 448.16 - 1,496.68- -98,503.32 000-497500Misc Income-EMT Classes78,85020.0011,163.0012,230.00 - - TOTAL Miscellaneous 334,850 1,435.41 30,254.71- 25,147.84 -309,702.16 TOTAL REVENUES7,203,732441,227.36 1,045,402.43- 1,137,344.44 6,066,387.56- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank $ (357,036.39) Claim on Operating Cash Pool-Checking Cash in Investment Pools LOGIC Investment-EMS- MBIA Investment-EMS Note 2010300,320.30 $(56,716.09) 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, 2010 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 675,30065,652.45 97,042.85- 116,767.41 -558,532.59 Miscellaneous1,300170.50270.49 123.14 - - TOTAL REVENUES 65,775.59676,60097,213.35 -117,037.90559,526.36 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 361,18346,028.18 61,651.30- 69,656.36 -291,526.64 Supplies 8,300 67.93 28.15 233.52 96.08 279.30 Human Services 100 - - - - -100.00 City Support Services 26,500 695.14 - 432.27 1,345.04 24,667.82487.14 Utility Services 12,888 337.62 - 1,630.65 1,247.16 11,427.36213.48 Operations Support 2,458 - - - - -2,458.00 Staff Support 8,255 168.83 273.15 312.48 573.43 - City Assistance 840 15.00 - - 15.00 -825.00 Professional Services 19,800 - 4,068.35 - - -19,800.00 Fund Charges/Transfers 195,449 - - - - -195,449.00 Maintenance Services 22,000 - 67.50 - - -22,000.00 Other costs 100 - - - - -100.00 Debt Service 18,138 - - - 18,137.58 - - Rental/Leasing500-- - - - TOTAL DRAINAGE 47,143.87676,511196.9868,356.7472,672.12602,482.09 1,553.35 TOTAL EXPENDITURE 47,143.87676,511196.9868,356.7472,672.12602,482.09 S 1,553.35 ** REVENUE OVER(UNDER) EXPEND8944,365.78 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *********************************************** 2 0 1 0 - 2 0 1 1 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 629.51 624.36 3,500 272.12 -2,875.64 000-457600Drainage Fee 65,380.33-96,413.34116,143.05 -555,656.95 671,800 TOTAL Fees65,652.45 97,042.85-116,767.41 558,532.59- 675,300 Miscellaneous 000-491000Interest Earned - 1.08 64.26 100 36.91 - 000-491200Investment Interest - 126.32 123.13 600 56.99 -476.87 000-497000Misc Income-Drainage-43.1083.10 600 29.24 - TOTAL Miscellaneous - 170.50 270.49 1,300 123.14 -993.77 TOTAL REVENUES65,775.59 97,213.35-117,037.90 559,526.36- 676,600 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Ban k Claim on Operating Cash Pool-Checking 154,983.74 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund282,578.57 Total Cash in Bank & Investment Pools$437,562.31 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 385,000 15,736.28 47,521.47- 36,680.63 -348,319.37 Miscellaneous 49.935,550-147.6289.71 - TOTAL REVENUES 15,786.21390,550-47,669.0936,770.34353,779.66 - EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services31,841--- - -31,841.00 City Support Services 78,228 502.85 2,913.50 14,557.00502.85 - Operations Support 33,424 - - - - -33,424.00 Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 231,485 85,244.00- - - -231,485.00 Operating Equipment - - - - - - -0.00% Capital Outlay--- - - - - TOTAL NONDEPARTMENTA -377,478502.8588,157.50502.85362,921.00 L 14,557.00 TOTAL EXPENDITURE -377,478502.8588,157.50502.85362,921.00 S 14,557.00 REVENUE OVER(UNDER) EXPENDITURE13,072 36,267.49 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax385,000 15,736.2847,521.47 -36,680.63348,319.37 - TOTAL Taxes 15,736.28385,000 - 47,521.47 36,680.63 9.53% -348,319.37 Miscellaneous 000-491000Interest Earned 250 - 122.48 62.65 36.79 -187.35 000-491200Investment Interest 300 - 25.14 27.06 13.14 -272.94 000-497000Misc Income -5,000--5,000.00 - - TOTAL Miscellaneous 5,550 - 148 89.71 49.93 -5,460.29 TOTAL REVENUES 390,55015,786.21 47,669.09- 36,770.34 -353,779.66 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking154,480.30$ Cash in Investment Pools Federated Investment-Hotel/Motel78,028.86 Total Cash in Bank & Investment Pools$232,509.16 33 ôíè÷ð íùùçìûîùã èûä $50,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 27,689 25,112 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 18,245 18,817 18,521 15,970 17,948 19,220 24,257 22,590 22,959 25,887 27,316 26,568 2006-07 34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 40,000 - - - - -40,000.00 Tree Mitigation Fees 40,000 - - - - -40,000.00 Miscellaneous- 149.34112.34 405 77.87 - TOTAL REVENUES- 149.34112.34 80,405 77.87 - EXPENDITURE SUMMARY PARKLAND DEDICATION Maintenance Services-Landscape 8,000 - - - - -8,000.00 Operating Equipment 30,000 7,695.36 28,325.73 8,425.36 2,084.00 5,857.88 Capital Outlay-- - 6,000 - - TOTAL PARKLAND DEDICATION7,695.3628,325.738,425.36 44,000 5,857.88 2,084.00 TREE MITIGATION Fund Charges/Transfers6,000 3,133.00 11,958.00- 8,825.00 -(2,825.00) Maintenance Services-Trees 30,000 16,437.50- 2,340.00 688.00 2,340.00 Capital Outlay-- - - - - TOTAL TREE MITIGATION11,165.003,133.0016,437.5014,298.00 36,000 688.00 TOTAL EXPENDITURE17,022.8810,828.3644,763.2322,723.36 S 80,000 2,772.00 REVENUE OVER(UNDER) EXPEND(22,574.02) 405 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 40,000 - - - 40,000.00 - 000-458900Tree Mitigation40,000 -- - - TOTAL Fees 80,000 - - - 80,000.00 - Miscellaneous 000-491000Interest Earned 38.9460 - - 69.20 (9.20) 000-491200Investment Interest 280 38.93 - 87.34 80.14 199.86 000-497000Miscellaneous Income6525.00- - - TOTAL Miscellaneous40577.87-112.34149.34 255.66 TOTAL REVENUES 80,405 77.87 - 112.34 149.34 80,255.66 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking$163,506.70 Cash in Investment Pools Federated Investment-Park Fund38,805.27 Federated Investment-Tree Mitigation192,256.06 Total in Investment Pool 231,061.33 Total Cash in Bank & Investment Pools394,568.03$ 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *********************************************** 2 0 1 0 - 2 0 1 1 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer 31,000 - - - - -31,000.00 Miscellaneous-- - 25,000 - - TOTAL REVENUES-- - 56,000 - - EXPENDITURE SUMMARY NONDEPARTMENTAL Payable to Waste Contractor-- - 56,000 - - TOTAL NONDEPARTMENTA-- - L 56,000 - - TOTAL EXPENDITURE-- - S 56,000 - - REVENUE OVER(UNDER) EXPEND- - - - 38 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S31,000-- - - - TOTAL Fund Transfers31,000--- - -31,000.00 Miscellaneous 000-490210Sale of Recycle Material25,000-- - - - TOTAL Miscellaneous 25,000 - - - - -25,000.00 TOTAL REVENUES 56,000 - - - - - 56,000 39 RECYCLE FUND CASH IN BANK AS OF: NOVEMBER 30th, 2010 Cash in Bank (58,365.47) Claim on Operating Cash Pool-Checking $(58,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, 2010 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees1,190,640140,837.34 92,082.48- 633,173.83 -557,466.17 Fund Transfers - - - - - - Miscellaneous(3,923.43) (442.04)992.06 585,500 - - TOTAL REVENUES136,913.9193,074.54632,731.79 1,776,140 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Operations Support1,000--- - -1,000.00 Professional Services 37,000 354.16 - - 354.16 -36,645.84 Debt Service - - - - - - Capital Outlay8,428.00 8,428.00- - - - TOTAL NON DEPARTMENTA354.168,428.00 8,782.16- L 38,000 - MISC & PROJECTS Projects53,183.36 53,183.36- - 49,513.74 - Schaefer RD Water Improvements -- 600,000 - - -600,000.00 Northcliffe Elevated Tnk -- - - - - Northcliffe Water Plant -- - - - - Town Creek Project -- - - - - Live Oak Water Plant29.03 - - -301,469.89 - Loop Feed Water Line -- - - - - viation Heights WTR IMP127,782.22225,148.7229,487.92225,148.72 A - 1,663.00 TOTAL MISC & PROJECTS177,295.96278,332.08330,957.81278,361.11 600,000 1,663.00 TOTAL EXPENDITURE177,650.12286,760.08330,957.81287,143.27 S 638,000 1,663.00 REVENUE OVER(UNDER) EXPENDITURES 1,138,140 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 **************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 904,200 82,200.00 67,416.82- 401,323.34 -502,876.66 000-455910Capital Recovery - Waste Wtr272,800 58,337.34 24,665.66- 231,550.49 -41,249.51 000-455911Capital Recovery-Wste Wtr Zone 113,640 - - - - -13,640.00 000-455913Cap Recovery-North Sewer Tr300.00 300.00- - - - TOTAL Fees 140,837.341,190,640 - 92,082.48 633,173.83 -557,466.17 Fund Transfers 000-481000Transfer from Reserves - - - - - - 000-486100Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous 000-491000Interest Earned 2,000 59.32 - 115.74 151.78 -1,848.22 000-491200Investment Income 250,000 3,444.83 - 876.32 4,828.67 -245,171.33 000-491900Unrealized Gain/Loss-Cap One - - (5,422.49) -(7,427.58) -5,422.49 000-498100Reimbursmnt - FM 78 Project 50,000 - - - - -50,000.00 -- 000-498200Re-imbursement-Water Meters 283,500 - - - TOTAL Miscellaneous 585,500 (3,923.43) - 992.06 (442.04) -585,942.04 TOTAL REVENUES1,776,140136,913.91 93,074.54- 632,731.79 -1,143,408.21 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking249,086.06$ Cash in Investments: Lone Star Investment-Capital Recovery261,309.23 Capital One-Investment1,703,254.88 Schertz Bank & Trust-Certificate of Deposit522,391.31 Capital One1,698,524.86 Total Cash in Bank & Investment Pools4,434,566.34$ 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ****************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 125,479.853,368,794 - 1,552,351.21 821,544.39 -2,547,249.61 Fund Transfers243,000 - - - - -243,000.00 Miscellaneous3,000251.50749.85280.09 - - TOTAL REVENUES 125,731.353,614,7941,553,101.06821,824.48 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services3,200 - - - - -3,200.00 Debt Service3,611,124 4,664.58 4,664.58- - - TOTAL GENERAL GOVERNMEN 4,664.583,614,324 4,664.58- T - - TOTAL EXPENDITURE 4,664.583,614,324 4,664.58- S - - ** REVENUE OVER(UNDER) EXPEND470817,159.90 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue3,368,794 125,479.851,552,351.21821,544.39 - - TOTAL Taxes3,368,794125,479.85 1,552,351.21-821,544.39 - 2,547,249.61 Fund Transfers 000-486000Transfer From Reserves243,000 - - - - - 243,000.00 - - 000-486103Transfer In - - - - TOTAL Fund Transfers 243,000 - - - - - 243,000.00 Miscellaneous 000-491000Interest Earned 1,500 224.83 - 434.76 224.83 - 1,275.17 000-491200Investment Earnings1,50026.67315.09 55.26 - - TOTAL Miscellaneous3,000251.50-749.85280.09 - 2,719.91 TOTAL REVENUES3,614,794 125,731.35 1,553,101.06- 821,824.48 - 2,792,969.52 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 505-TAX I & S***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent -- 3,200 - - - TOTAL Professional Services3,200---- -3,200.00 Debt Service 101-555612Schertz C O SR2001-Principal210,000 - - - - -210,000.00 101-555612.1Schertz CO BOND, 2001-Interest141,318 4,664.58 - - 4,664.58 -136,653.42 101-555622Schertz C O SR2003-Principal190,000 - - - - -190,000.00 101-555622.1Schertz C O SR2003-Interest60,820 - - - - -60,820.00 101-555624Comm Proj Bond-SR04-Principal325,000 - - - - -325,000.00 101-555624.1Comm Proj Bond SR04-Interest265,009 - - - - -265,009.00 - - - - 101-555626LS&D SR2006-Principal - - 101-555626.1LS&D SR2006-Interest 650,982 - - - - -650,982.00 101-555628CO Bond 2007-Principal 99,567 - - - - -99,567.00 101-555628.1CO Bond 2007-Interest 26,617 - - - - -26,617.00 101-555629GO Bond 2007-Principal 275,000 - - - - -275,000.00 101-555629.1GO Bond 2007-Interest 209,097 - - - - -209,097.00 101-555630GO Bond SR2008 Principal 355,000 - - - - - 101-555630.1GO Bond SR2008 Interest 379,651 - - - - -379,651.00 101-555631GO Bond SR2009 Principal 140,000 - - - - -140,000.00 101-555631.1BO Bond SR2009 Interest -- 283,063 - - - TOTAL Debt Service3,611,1244,664.58--4,664.58 -3,606,459.42 TOTAL EXPENDITURES3,614,324 4,664.58 - - 4,664.58 -3,609,659.42 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking944,025.89$ Cash in Investment Pools Federated Investment-Tax I&S159,348.31 Total Cash in Bank & Investment Pools$1,103,374.20 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET17% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,035,795166,131.83 - 2,151.85 337,173.38 - 1,698,621.62 Miscellaneous108,000307.762,009.271,422.84 - - ,,,.,.,. TOTALREVENUES21437951664395941611233859622 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies21,0002,546.77623.281,624.293,369.051,372.13 Utility Service 85,800 580.86 - 8,878.98 4,286.14 - 81,513.86 Maintenance Services 67,300 10,272.39 1,965.50 9,770.47 17,770.73 3,111.50 Operating Equipment 8,498 - 9,000.00 6,999.31 - - 1,498.69 Capital Outlay 6,999.31 -- - - - TOTAL NONDEPARTMENTA182,59813,400.029,588.0929,273.7432,425.234,483.63 L ECONOMIC DEVELOPMEN T Personnel Services 202,062 18,042.73 41,872.12- 32,819.43 - 169,242.57 Supplies 1,000 153.03 - 83.21 153.03 172.50 Human Services 100 - - - - - City Support Services 34,500 192.23 623.92 8,333.38 3,990.24 200.00 Utility Services 4,850 30.17 - 649.69 286.13 55.30 Operations Support 76,100 414.66 3,242.89 7,773.47 4,121.53 3,599.71 Staff Support 97,000 49,663.19 525.53 62,898.43 50,219.86 5,995.22 City Assistance 80,000 - - - - - 80,000.00 Professional Services 349,000 5,998.00 21,340.80 34,367.74 27,338.80 14,080.00 Fund Charges/Transfers 105,432 - - - - - 105,432.00 Fund Replenish-Fund Balance 216,000 - - - - - 216,000.00 Maintenance Services - - - - - - Debt Service 792,432 - - - 792,432.00 - - Operating Equipment1,5002,323.91- - - - TOTAL ECONO DEVELOPMEN 74,494.011,959,97625,733.14158,301.95118,929.02 T 24,102.73 TOTAL EXPENDITURE 87,894.032,142,57435,321.23187,575.69151,354.25 S 28,586.36 ** REVENUE OVER(UNDER) EXPEND1,221187,241.97 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2010 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET17% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,035,795166,131.832,151.85337,173.38 - - TOTAL Taxes2,035,795166,131.83 - 2,151.85 337,173.38 -1,698,621.62 Miscellaneous 000-491000Interest Earned 1,000 - 224.39 - - -1,000.00 000-491200Investment Earnings 12,000 307.76 - 190.57 1,208.54 -30,791.46 000-497000Misc Income 15,000 - 1,594.31 214.30 - - 000-499000Transfer From Reserves80,000 -- - - - TOTAL Miscellaneous 108,000 307.76 - 2,009.27 1,422.84 - TOTAL REVENUES2,143,795166,439.59 - 4,161.12 338,596.22 -1,730,198.78 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2010 Cash in Bank Claim on Operating Cash Pool-Checking37,372.55$ Cash in Investment Pools MBIA Investment-Economic Development Corp15,176.68 MBIA-Investment-Sysco Infrastructure150,310.96 MBIA-Investment-EDC Notes 20101,251,334.61 Schertz Bank & Trust-Certificate of Deposit504,512.14 Schertz Bank & Trust-Certificate of Deposit1,021,810.26 Total Cash in Bank & Investment Pools2,980,517.20$ 50 4B SALES TAX $250,000 $200,000 -3% 23% 13% $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 171,042 166,132 172,398 2010-11 150,192 169,257 140,629 144,175 192,423 146,589 135,864 183,352 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 139,231 152,929 133,224 140,960 179,416 118,361 125,387 159,802 150,107 153,348 191,371 149,102 2006-07 51 I T Y O F S C H E R T Z C NVESTMENT REPORT I FOR MONTH ENDING NOVEMBER 30th, 2010 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE Valueook ValueieldurchasesWithdrawalsook ValueMkt Value BYPB OPERATIONS-BANK CASH JPMorgan Chase40.3717,747.58.15000.3717,747.580.37 N/A0.37 304344 Schertz Bank & Trust4,792,575.46,893,432.65.2500,642,472.90,743,330.09,792,575.46,792,575.46 403344 TOTAL OPERATIONS4,792,615.83,211,180.23,642,513.27,061,077.67,792,615.83,792,615.83 53444 LOGIC General Fund505,128.1605,035.01.2244 -3.1505,128.16 N/A05,128.16 50955 G/F-Equipment Replacement73,188.003,174.50.2244 -3.503,188.00 N/A3,188.00 70177 G/F-Vehicle Replacement7,064.19,062.89.2244 -.30,064.19 N/A,064.19 70177 G/F-Air Conditioner Replacement122,165.0722,142.54.2244 -2.5322,165.07 N/A22,165.07 10211 ,116,976.58.224459.36-,117,735.94,117,735.94 SR2009 Bond-Street Projects(II)4,117,735.94 40744 TOTAL LOGIC4,825,281.36,824,391.52 -89.84,825,281.36,825,281.36 4844 LONESTA R Drainage Fund282,578.5782,521.58.2500 -6.9982,578.57 N/A82,578.57 20522 SR2005-Public Improvement Bond43.763.75.2500 -.013.76 N/A3.76 40044 W/S-Capital Recovery-Water261,309.2361,256.53.2500 -2.7061,309.23 N/A61,309.23 20522 W/S-Customer Deposits293,075.0793,015.97.2500 -9.1093,075.07 N/A93,075.07 20522 W/S-Equipment Repl/Cap.Imp372,319.0272,243.94.2500 -5.0872,319.02 N/A72,319.02 30733 Water&Sewer989,364.5089,164.98.2500 -99.5289,364.50 N/A89,364.50 90199 W/S-Vehicle Replacement542,885.6242,776.14.250009.48-42,885.6242,885.62 50155 TOTAL LONESTA2,741,575.77,741,022.89 -52.88,741,575.77,741,575.77 R2522 MBIA Police Forfeiture278,650.1578,594.07.2400 -6.0878,650.15 N/A78,650.15 20522 Economic Development Corporation15,176.6835,151.04.24005.6420,000.005,176.68 N/A5,176.68 102111 Special Events Fund66,460.046,446.65.2400 -3.396,460.04 N/A6,460.04 60166 SEDC Sysco Infrastructure150,310.9650,280.70.2400 -0.2650,310.96 N/A50,310.96 10311 SEDC Tax Notes 20101,251,334.61,251,082.75.2400 -51.86,251,334.61 N/A,251,334.61 10211 00,259.86.24000.44-00,320.3000,320.30 EMS Tax Notes 2010300,320.30 30633 TOTAL MBIA2,062,252.74,181,815.0737.6720,000.00,761,932.44,761,932.44 24111 FEDERATED SR2007a Bond-City Wide Projects1,403,095.61,402,859.26.2100 -36.35,403,095.61 N/A,403,095.61 10211 Hotel Occupancy Tax78,028.868,015.72.2100 -3.148,028.86 N/A8,028.86 70177 Park Fund (Developers Fee)38,805.278,798.73.2100 -.548,805.27 N/A8,805.27 30633 Park Fund (Tree Mitigation)192,256.0692,223.67.2100 -2.3992,256.06 N/A92,256.06 10311 Tax I&S159,348.3159,321.47.2100 -6.8459,348.31 N/A59,348.31 10211 Library Board Fund30,630.180,625.02.2100.16-0,630.180,630.18 30533 TOTAL FEDERATED1,902,164.29,901,843.87 -20.42,902,164.29,902,164.29 1311 INVESTMENT MANAGED ACCOUNTPareginningndingndingMaturity BEE Valueook ValueieldAdditionsWithdrawalsook ValueMkt Value BYB Capital One IMA1,262,259.54,291,382.05.4200 275.93,147.91,295,254.03 N/A,325,951.83 12411 ,694,226.47.1100,172.82354.16,700,045.13,698,524.86 Capital One Capital Recovery1,625,612.21 12611 TOTAL CAPITAL ONE2,887,871.75,985,608.52 630.090,320.73,995,299.16,024,476.69 2123 52 City Portfolio By Investment Type Schertz Bank &Trust C.D.s 10% Operations Account JPMorgan Chase Capital One Managed 9% FEDERATED Pool 21% MBIA Pool 16% LONESTAR Pool 13% 54 City Portfolio By Use Pooled-Daily Operations, $4,792,616 Designated Funds, $5,594,860 Special Revenue Funds, $3,195,519 Projects, $6,922,521 Debt Service Fund $809,074.07 MONTHLY YIELDS 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-10NOV-10DEC-10JAN-11FEB-11MAR-11APR-11MAY-11JUN-11JUL-11AUG-11SEP-11 0.13000.1800 1 Month T-Bill 0.11700.1700 3 Month T-Bill 0.16500.2100 6 Month T-Bill 0.61000.6100 Schertz Portfolio 0.15000.1500 JPMorgan Chase 0.25000.2500 Schertz Bank&Trust 0.22940.2244 LOGIC 0.28000.2500 LoneStar 0.26000.2400 MBIA 0.13000.2100 Federated 2.36002.4200 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:11/30/2010 IMA ssets A Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69112,259.5412,259.5412,259.54 Bank of Amer NA Disc Bank Accpt 4/19/2011140.0065,000.0064,886.8864,886.88 General Elec Cap Corp Disc Com Paper/15/201127.005,000.0064,805.724,805.72 7266 JPMorgan Chase Disc Com Paper4/18/2011139.0065,000.0064,934.6464,934.64 Total Cash & Equivalents07,259.54206,886.7806,886.78 22 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012687.00150,000.00162,031.50161,015.25 Federal Home Loan Bks Cons Bds10/28/2011332.00135,000.00135,000.00134,810.33 Federal Home Ln Mtg Corp Disc Nts Dtd0/7/201111.0000,000.0099,746.509,750.40 1319 Federal Home Ln Mtg Corp Deb11/15/20131081.00170,000.00191,084.25190,214.70 Federal Natl Mtg Assn Meduim term Nts9/24/20131029.00250,000.00250,000.00274,531.25 Federal Natl Mtg Assn 4/20/2012507.00250,000.00250,505.00254,843.75 Total Fixed Income,055,000.001,088,367.25,115,165.68 11 Total Assets625.971,262,259.541,295,254.031,322,052.46 Cap Recovery Fund Assets Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #69120,612.2120,612.2120,612.21 Bank of Amer N A Disc Bankers Accp Prgm4/19/2011140.0085,000.0084,852.0884,852.08 General Elec Cap Corp Disc Coml Paper/15/201127.005,000.0084,745.954,745.95 7288 JPMorgan Chase Disc Coml Paper4/18/2011139.0085,000.0084,914.5384,914.53 Total Cash & Equivalents75,612.21275,124.7775,124.77 22 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012687.00250,000.00270,052.50268,358.75 Federal Home Loan Bks Cons Bds10/28/2011332.00175,000.00175,000.00174,754.13 Federal Home Ln Mtg Corp Disc Nts0/7/201111.0025,000.00124,683.1324,687.99 1311 Federal Home Ln Mtg Corp Deb11/15/20131081.00250,000.00281,006.25279,687.99 Federal Natl Mtg Assn Nts10/15/20131050.00200,000.00223,001.60221,406.00 Federal Natl Mtg Assn10/30/2012700.00250,000.00250,192.50249,727.50 US Treasury Note2/15/201180.0000,000.00100,984.3800,836.00 1311 Total Fixed Income,350,000.001,424,920.36,419,458.36 11 Total Assets633.371,625,612.211,700,045.131,694,583.13