Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01-OCTOBER 2013 FINANCIAL STATEMENT
OCTOBER 2013 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department January 28, 2014 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 14,146,857 920,423.93 784,404.78 920,423.93 - 13,226,433.07 6.51% Franchises 1,738,605 144,353.07 115,132.82 144,353.07 - 1,594,251.93 8.30% Permits 1,007,062 90,312.40 75,192.00 90,312.40 - 916,749.60 8.97% Licenses 70,100 4,790.00 4,957.50 4,790.00 - 65,310.00 6.83% Fees 3,053,888 251,274.10 266,285.38 251,275.10 (50.00) 2,802,662.90 8.23% Fines 30,000 2,756.47 2,823.88 2,756.47 - 27,243.53 9.19% Inter-Jurisdictional 685,780 14,879.22 10,464.24 14,879.22 - 670,900.78 2.17% Fund Transfers 1,975,009 146,096.83 142,678.25 146,096.83 - 1,828,912.17 7.40%Miscellaneous 464,700 39,225.66 32,316.81 39,225.66 (87.00) 425,561.34 8.42% TOTAL REVENUES 23,172,001 1,614,111.68 1,434,255.66 1,614,112.68 (137.00) 21,558,025.32 6.97% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 2,066.91 1,065.03 2,066.91 - 21,508.09 8.77% Supplies 500 - 57.30 - 32.80 467.20 6.56% City Support Services 38,000 3,633.01 3,548.00 3,633.01 - 34,366.99 9.56% Operations Support 300 - - - - 300.00 0.00%Staff Support 20,700 1,120.15 823.00 1,120.15 541.01 19,038.84 8.02% TOTAL CITY COUNCIL 83,075 6,820.07 5,493.33 6,820.07 573.81 75,681.12 8.90% CITY MANAGER Personnel Services 944,883 50,772.51 52,212.58 50,772.51 - 894,110.49 5.37% Supplies 3,000 - - - - 3,000.00 0.00% City Support Services - 600.00 - 600.00 - (600.00) 0.00% Operations Support 100 - - - - 100.00 0.00% Staff Support 36,550 707.20 2,757.62 707.20 376.12 35,466.68 2.96% TOTAL CITY MANAGER 984,533 52,079.71 54,970.20 52,079.71 376.12 932,077.17 5.33% *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 MUNICIPAL COURT Personnel Services 309,881 15,488.31 14,884.24 15,488.31 - 294,392.69 5.00% Supplies 2,500 - 415.45 - - 2,500.00 0.00% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,000 90.00 - 90.00 404.00 3,506.00 12.35% Staff Support 7,340 286.00 - 286.00 304.30 6,749.70 8.04% Court Support 700 - - - - 700.00 0.00% Professional Services 65,200 5,028.17 4,405.25 5,028.17 59,971.78 200.05 99.69% Maintenance Services 2,800 - - - 450.00 2,350.00 16.07% Operating Equipment 800 - - - - 800.00 0.00% TOTAL MUNICIPAL COURT 394,221 20,892.48 19,704.94 20,892.48 61,130.08 312,198.44 20.81% CUSTOMER RELATIONS-311 Personnel Services 109,822 5,641.07 5,780.15 5,641.07 - 104,180.93 5.14% Supplies 200 - - - 19.97 180.03 9.99%Staff Support 1,750 - - - - 1,750.00 0.00% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 112,272 5,641.07 5,780.15 5,641.07 19.97 106,610.96 5.04% PLANNING & ZONING Personnel Services 133,060 7,062.02 7,887.19 7,062.02 - 125,997.98 5.31% Supplies 2,672 - - - - 2,672.00 0.00% Operations Support 750 - - - - 750.00 0.00% Staff Support 18,850 47.68 56.17 47.68 343.38 18,458.94 2.07%Professional Services 150 - - - - 150.00 0.00% TOTAL PLANNING & ZONING 155,482 7,109.70 7,943.36 7,109.70 343.38 148,028.92 4.79% LEGAL SERVICES Operations Support 12,000 - - - 122.20 11,877.80 1.02%Professional Services 438,000 - - - - 438,000.00 0.00% TOTAL LEGAL SERVICES 450,000 - - - 122.20 449,877.80 0.03% 2 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 FACILITIES MAINTENANCE Personnel Services 567,475 38,343.85 42,169.75 38,343.85 - 529,131.15 6.76% Supplies 65,450 549.44 2,795.25 549.44 3,389.55 61,511.01 6.02% Utility Services 99,300 5,696.10 - 5,696.10 - 93,603.90 5.74% Staff Support 12,147 - 24.00 - 1,132.58 11,014.42 9.32% Maintenance Services 43,250 128.25 6,194.15 128.25 180.00 42,941.75 0.71%Operating Equipment 24,050 - - - 4,763.90 19,286.10 19.81% TOTAL FACILITIES MAINTENANCE 811,672 44,717.64 51,183.15 44,717.64 9,466.03 757,488.33 6.68% BUILDING 6-8 MAINTENANCE Supplies 28,400 1,126.99 - 1,126.99 2,712.73 24,560.28 13.52% Utility Services 86,700 4,573.74 4.47 4,573.74 - 82,126.26 5.28% Maintenance Services 61,700 1,494.52 350.00 1,494.52 2,654.24 57,551.24 6.72% Operating Equipment 24,060 - - - 1,049.93 23,010.07 4.36% TOTAL BUILDING 6-8 MAINTENANCE 200,860 7,195.25 354.47 7,195.25 6,416.90 187,247.85 6.78% CITY SECRETARY Personnel Services 171,031 8,991.69 9,428.37 8,991.69 - 162,039.31 5.26% Supplies 1,200 - 23.80 - 50.89 1,149.11 4.24% City Support Services 9,500 - - - - 9,500.00 0.00% Operations Support 150 - - - - 150.00 0.00%Staff Support 7,995 470.83 18.00 470.83 158.80 7,365.37 7.88% TOTAL CITY SECRETARY 189,876 9,462.52 9,470.17 9,462.52 209.69 180,203.79 5.09% NON-DEPARTMENTAL City Support Services 448,259 146,823.64 132,598.26 146,823.64 32,200.00 269,235.36 39.94% Operations Support 128,000 8,746.86 6,432.32 8,746.86 - 119,253.14 6.83% Staff Support 100 - - - - 100.00 0.00% City Assistance 786,413 - 98,957.42 - - 786,413.00 0.00% Professional Services 148,650 2,399.00 22,269.88 2,399.00 - 146,251.00 1.61% Fund Chrgs/Transfrs-Spec Events Fnd - - - - - - 0.00%Operating Equipment - - - - - - 0.00% TOTAL NON-DEPARTMENTAL 1,511,422 157,969.50 260,257.88 157,969.50 32,200.00 1,321,252.50 12.58% 3 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 PUBLIC AFFAIRS Personnel Services 292,325 10,527.81 16,349.26 10,527.81 - 281,797.19 3.60% Supplies 3,500 78.54 - 78.54 148.90 3,272.56 6.50% Operations Support 27,050 - 1,868.79 - 219.95 26,830.05 0.81% Staff Support 5,240 - 9.24 - 453.62 4,786.38 8.66%Professional Services 15,000 - - - 250.00 14,750.00 1.67% TOTAL PUBLIC AFFAIRS 343,115 10,606.35 18,227.29 10,606.35 1,072.47 331,436.18 3.40% RECORDS MANAGEMENT Personnel Services 49,777 2,720.93 2,725.54 2,720.93 - 47,056.07 5.47% Supplies 400 - - - - 400.00 0.00% Staff Support 1,860 - - - - 1,860.00 0.00% Professional Services 17,000 183.50 191.00 183.50 - 16,816.50 1.08% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 69,037 2,904.43 2,916.54 2,904.43 83.77 66,048.80 4.33% SCHERTZ MAGAZINE Personnel Services 133,179 7,628.04 7,686.10 7,628.04 - 125,550.96 5.73% Supplies 200 - - - - 200.00 0.00% Opperations Support 200 - - - - 200.00 0.00% Staff Support 2,005 - - - 20.00 1,985.00 1.00%Professional Services 260,500 100.00 115,425.00 100.00 525.00 259,875.00 0.24% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - - - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 406,684 7,728.04 123,111.10 7,728.04 545.00 398,410.96 2.03% ENGINEERING Personnel Services 199,212 4,146.51 7,346.63 4,146.51 - 195,065.49 2.08% Supplies 1,100 - - - 193.93 906.07 17.63% City Support Services 1,380 - - - - 1,380.00 0.00% Utility Services 1,400 - - - - 1,400.00 0.00% Operations Support - - - - - - 0.00% Staff Support 8,580 - - - - 8,580.00 0.00% Professional Services 43,000 3,262.50 - 3,262.50 - 39,737.50 7.59% Operating Equipment 5,000 - - - - 5,000.00 0.00% TOTAL ENGINEERING 259,672 7,409.01 7,346.63 7,409.01 193.93 252,069.06 2.93% 4 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 GIS Personnel Services 131,043 7,443.79 7,456.49 7,443.79 - 123,599.21 5.68% Supplies 2,855 - - - 110.00 2,745.00 3.85% Staff Support 5,000 - - - - 5,000.00 0.00% Professional Services 3,805 - - - - 3,805.00 0.00% TOTAL GIS 142,703 7,443.79 7,456.49 7,443.79 110.00 135,149.21 5.29% TOTAL GENERAL GOVERNMENT 6,114,624 347,979.56 574,215.70 347,979.56 112,863.35 5,653,781.09 7.54% PUBLIC SAFETY POLICE Personnel Services 4,843,491 296,765.79 240,057.91 296,765.79 - 4,546,725.21 6.13% Supplies 31,492 850.07 19.95 850.07 523.71 30,118.22 4.36%City Support Services 23,800 26,721.66 20,657.01 26,721.66 - (2,921.66) 112.28% Utility Services 136,704 32.04 - 32.04 - 136,671.96 0.02% Operations Support 2,000 - - - 314.00 1,686.00 15.70% Staff Support 80,709 6,314.84 1,054.50 6,314.84 3,334.85 71,059.31 11.96% City Assistance 8,080 - - - 2,212.15 5,867.85 27.38% Professional Services 27,988 - 200.00 - - 27,988.00 0.00% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 46,540 6,000.00 690.00 6,000.00 1,482.50 39,057.50 16.08% Operating Equipment 110,514 139.95 - 139.95 35,777.82 74,596.23 32.50%Capital Outlay 147,600 - - - 128,505.24 19,094.76 87.06% TOTAL POLICE 5,458,918 336,824.35 262,679.37 336,824.35 172,150.27 4,949,943.38 9.32% FIRE RESCUE Personnel Services 2,679,088 159,126.56 204,507.17 159,126.56 - 2,519,961.44 5.94% Supplies 17,000 376.65 155.32 376.65 65.74 16,557.61 2.60% Utility Services 47,500 49.19 - 49.19 - 47,450.81 0.10% Operations Support 1,200 - - - - 1,200.00 0.00% Staff Support 116,600 5,552.25 11,644.77 5,552.25 372.09 110,675.66 5.08% City Assistance 16,200 - - - - 16,200.00 0.00% Professional Services 15,000 - - - - 15,000.00 0.00% Maintenance Services 63,760 135.80 169.75 135.80 69.75 63,554.45 0.32% Operating Equipment 66,600 - - - - 66,600.00 0.00% TOTAL FIRE RESCUE 3,022,948 165,240.45 216,477.01 165,240.45 507.58 2,857,199.97 5.48% 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 INSPECTIONS Personnel Services 451,630 25,126.52 24,512.62 25,126.52 - 426,503.48 5.56% Supplies 2,438 78.30 91.54 78.30 - 2,359.70 3.21% Utility Services 6,770 - - - - 6,770.00 0.00% Operations Support 1,700 - - - - 1,700.00 0.00% Staff Support 8,800 50.49 360.43 50.49 284.79 8,464.72 3.81% Operating Equipment 430 - - - - 430.00 0.00% TOTAL INSPECTIONS 471,768 25,255.31 24,964.59 25,255.31 284.79 446,227.90 5.41% MARSHAL SERVICE Personnel Services 557,097 32,257.25 32,944.08 33,257.25 - 523,839.75 5.97% Supplies 4,840 - 33.69 - - 4,840.00 0.00% Utility Services 16,000 - - - - 16,000.00 0.00% Operations Support 3,500 - - - 183.75 3,316.25 5.25% Staff Support 10,550 259.08 65.87 259.08 - 10,290.92 2.46% City Assistance - - - - - - 0.00% Maintenance Services 16,000 - 505.00 - - 16,000.00 0.00% Operating Equipment 8,000 - - 1,476.46 6,523.54 18.46% Capital Outlay 35,000 - - - 28,566.00 6,434.00 81.62% TOTAL MARSHAL SERVICE 650,987 32,516.33 33,548.64 33,516.33 30,226.21 587,244.46 9.79% TOTAL PUBLIC SAFETY 9,604,621 559,836.44 537,669.61 560,836.44 203,168.85 8,840,615.71 7.95% 6 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 PUBLIC ENVIRONMENT STREETS Personnel Services 681,227 51,615.04 52,709.62 51,615.04 - 629,611.96 7.58% Supplies 7,100 6.04 118.32 6.04 1,229.32 5,864.64 17.40% Utility Services 124,000 236.14 476.80 236.14 255.37 123,508.49 0.40% Staff Support 8,880 337.60 528.25 337.60 350.24 8,192.16 7.75% City Assistance 500 - - - - 500.00 0.00% Maintenance Services 175,400 2,861.05 2,091.98 2,861.05 7,059.89 165,479.06 5.66% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 3,200 - - - - 3,200.00 0.00%Capital Outlay 105,398 - - - 57,629.00 47,769.00 54.68% TOTAL STREETS 1,105,905 55,055.87 55,924.97 55,055.87 66,523.82 984,325.31 10.99% TOTAL PUBLIC ENVIRONMENT 1,105,905 55,055.87 55,924.97 55,055.87 66,523.82 984,325.31 10.99% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 500,980 29,497.18 32,306.05 29,497.18 - 471,482.82 5.89% Supplies 41,905 - 878.25 - 3,055.35 38,849.65 7.29% Utility Services 143,800 5,029.65 892.50 5,029.65 375.63 138,394.72 3.76% Operations Support 250 - - - - 250.00 0.00% Staff Support 8,473 - 395.23 - 379.40 8,093.60 4.48% Professional Services 33,250 - - - 5,417.50 27,832.50 16.29% Maintenance Services 23,000 - - - 24.00 22,976.00 0.10% Rental/Leasing 44,000 - - - - 44,000.00 0.00%Operating Equipment 1,000 - - - 344.25 655.75 34.43% TOTAL PARKS DEPARTMENT 796,658 34,526.83 34,472.03 34,526.83 9,596.13 752,535.04 5.54% SWIM POOL Supplies 20,700 - 194.50 - 27.74 20,672.26 0.13% Utility Services 29,000 1,728.07 101.80 1,728.07 - 27,271.93 5.96% Staff Support 925 - - - - 925.00 0.00% Maintenance Services 203,378 461.49 2,200.00 461.49 - 202,916.51 0.23% Rental/Lease 500 - - - - 500.00 0.00% TOTAL SWIM POOL 254,503 2,189.56 2,496.30 2,189.56 27.74 252,285.70 0.87% 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 EVENT FACILITIES Personnel Services 57,195 2,905.75 2,948.28 2,905.75 - 54,289.25 5.08% Supplies 17,000 272.57 10.92 272.57 348.48 16,378.95 3.65% Utility Services 48,800 2,214.30 - 2,214.30 - 46,585.70 4.54% Operations Support 15,200 - - - 11.97 15,188.03 0.08% Staff Support 2,727 - - - 605.75 2,121.25 22.21% Professional Services 1,600 199.10 - 199.10 - 1,400.90 12.44% TOTAL EVENT FACILITIES 142,522 5,591.72 2,959.20 5,591.72 966.20 135,964.08 4.60% TOTAL PARKS & RECREATION 1,193,683 42,308.11 39,927.53 42,308.11 10,590.07 1,140,784.82 4.43% CULTURAL LIBRARY Personnel Services 718,377 38,235.63 36,194.34 38,235.63 - 680,141.37 5.32% Supplies 12,000 80.95 828.71 80.95 823.75 11,095.30 7.54% Utility Services 50,000 3,519.98 - 3,519.98 - 46,480.02 7.04% Operations Support 3,500 - - - - 3,500.00 0.00% Staff Support 5,940 32.44 - 32.44 - 5,907.56 0.55% Professional Services 2,350 - - - 2,190.00 160.00 93.19% Maintenance Services 2,400 - - - - 2,400.00 0.00% Operating Equipment 80,130 74.88 98.96 74.88 8,263.14 71,791.98 10.41% TOTAL LIBRARY 874,697 41,943.88 37,122.01 41,943.88 11,276.89 821,476.23 6.08% TOTAL CULTURAL 874,697 41,943.88 37,122.01 41,943.88 11,276.89 821,476.23 6.08% 8 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 HEALTH ANIMAL SERVICES Personnel Services 317,626 16,535.74 16,128.35 16,535.74 - 301,090.26 5.21% Supplies 30,700 - 2,087.50 - 683.18 30,016.82 2.23% Utility Services 20,110 170.23 100.85 170.23 - 19,939.77 0.85% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 10,450 75.00 - 75.00 65.55 10,309.45 1.34% City Assistance 17,550 - - - 475.75 17,074.25 2.71% Professional Services 21,500 3,276.46 - 3,276.46 2,452.76 15,770.78 26.65% Maintenance Services 23,200 - - - - 23,200.00 0.00%Operating Equipment 12,000 - - - - 12,000.00 0.00% TOTAL ANIMAL SERVICES 454,136 20,057.43 18,316.70 20,057.43 3,677.24 430,401.33 5.23% TOTAL HEALTH 454,136 20,057.43 18,316.70 20,057.43 3,677.24 430,401.33 5.23% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 401,949 20,986.05 16,310.78 20,986.05 - 380,962.95 5.22% Supplies 1,500 54.49 - 54.49 77.62 1,367.89 8.81% City Support Services 442,927 28,260.42 6,840.00 28,260.42 40,210.12 374,456.46 15.46% Utility Services 184,038 11,106.29 - 11,106.29 308.83 172,622.88 6.20% Staff Support 22,000 650.00 254.31 650.00 1,557.46 19,792.54 10.03% Maintenance Services 12,500 - - - 79.00 12,421.00 0.63% Operating Equipment 196,500 1,510.23 - 1,510.23 11,489.54 183,500.23 6.62% TOTAL INFORMATION TECHNOLOGY 1,261,414 62,567.48 23,405.09 62,567.48 53,722.57 1,145,123.95 9.22% 9 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 HUMAN RESOURCES Personnel Services 310,989 15,103.25 15,460.02 15,103.25 - 295,885.75 4.86% Supplies 1,300 - - - 330.81 969.19 25.45% Human Services 62,900 200.00 1,267.00 200.00 2,403.21 60,296.79 4.14% Operations Support 14,500 - - - 960.00 13,540.00 6.62% Staff Support 14,819 - - - 133.17 14,685.83 0.90%City Assistance 10,000 - - - - 10,000.00 0.00% TOTAL HUMAN RESOURCES 414,508 15,303.25 16,727.02 15,303.25 3,827.19 395,377.56 4.62% FINANCE Personnel Services 452,672 24,697.80 24,990.32 24,697.80 - 427,974.20 5.46% Supplies 2,500 305.20 4.10 305.20 11.12 2,183.68 12.65% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 14,805 72.70 80.00 72.70 180.00 14,552.30 1.71% Operating Equipment - - - - - - 0.00% TOTAL FINANCE 470,977 25,075.70 25,074.42 25,075.70 191.12 445,710.18 5.36% PURCHASING & ASSET MGT Personnel Services 255,024 13,874.59 13,933.46 13,874.59 - 241,149.85 5.44% Supplies 1,200 - 35.19 - 39.15 1,160.85 3.26% Utility Services 600 - - - - 600.00 0.00% Operations Support 300 - - - - 300.00 0.00% Staff Support 7,985 250.00 - 250.00 - 7,735.00 3.13% Operating Equipment 2,050 - - - 1,821.69 228.31 88.86% TOTAL PURCHASING & ASSET MGT 267,159 14,124.59 13,968.65 14,124.59 1,860.84 251,174.01 5.98% 10 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 FLEET SERVICE Personnel Services 222,091 13,205.34 11,120.41 13,205.34 - 208,885.66 5.95% Supplies 169,025 6,170.45 18,773.53 6,170.45 23,344.01 139,510.54 17.46% City Support Services 3,500 2,100.00 - 2,100.00 - 1,400.00 60.00% Utility Services 5,000 - - - - 5,000.00 0.00% Operations Support 400 - - - - 400.00 0.00% Staff Support 4,500 73.89 - 73.89 67.80 4,358.31 3.15% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 70,750 378.34 5,681.54 378.34 2,332.52 68,039.14 3.83% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 5,000 - - - - 5,000.00 0.00% Capital Outlay 10,000 - - - - 10,000.00 0.00% TOTAL FLEET SERVICE 490,646 21,928.02 35,575.48 21,928.02 25,744.33 442,973.65 9.72% BUILDING MAINTENANCE Personnel Services 92,966 6,225.95 - 6,225.95 - 86,740.05 6.70% Supplies 1,043 - - - 62.57 980.43 6.00% Utility Services 4,350 - - - - 4,350.00 0.00% Staff Support 2,600 29.55 - 29.55 8.49 2,561.96 1.46% Professional Services 20,000 - - - 7,160.00 12,840.00 35.80% Maintenance Services 58,170 12,362.82 - 12,362.82 2,852.88 42,954.30 26.16% Rental/Leasing 1,400 - - - - 1,400.00 0.00% Operating Equipment - - - - - - 0.00% Capital Outlay 118,000 - - - 12,127.50 105,872.50 10.28% TOTAL BUILDING MAINTENANCE 298,529 18,618.32 - 18,618.32 22,211.44 257,699.24 13.68% TOTAL INTERNAL SERVICE 3,203,233 157,617.36 114,750.66 157,617.36 107,557.49 2,938,058.59 8.28% 11 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET *************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 5,000.00 - 5,000.00 - - 100.00% Transportation Assistance 22,000 - - - - 22,000.00 0.00% Children's Advocacy Assistance 5,000 - - - - 5,000.00 0.00%Senior Citizen's Hot Meals 42,000 3,500.00 10,500.00 3,500.00 - 38,500.00 8.33% TOTAL CITY ASSISTANCE 74,000 8,500.00 10,500.00 8,500.00 - 65,500.00 11.49% COURT - RESTRICTED FUNDS Operating Equipment 6,400 - - - 4,910.00 1,490.00 76.72% TOTAL CITY ASSISTANCE 6,400 - - - 4,910.00 1,490.00 76.72% TOTAL MISC & PROJECTS 80,400 8,500 10,500 8,500 4,910 66,990.00 16.68% TOTAL EXPENDITURES 22,631,299 1,233,298.65 1,388,427.18 1,234,298.65 520,567.71 20,876,433.08 7.75% REVENUE OVER(UNDER) EXPEND.540,702 379,814.03 12 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 7,839,691 363,588.83 292,988.31 363,588.83 - 7,476,102.17 4.64% 000-411200 Advalorem Tax - Delinquent 50,000 (10,791.21) 4,336.84 (10,791.21) - 60,791.21 -21.58% 000-411300 Advalorem Tax - P&I 50,000 2,462.11 2,622.62 2,462.11 - 47,537.89 4.92% 000-411500 Sales Tax Revenue-Gen Fund 6,179,166 554,578.47 476,947.87 554,578.47 - 5,624,587.53 8.97%000-411700 Mixed Beverage Tax 28,000.00 10,585.73 7,509.14 10,585.73 - 17,414.27 37.81% TOTAL Taxes 14,146,857 920,423.93 784,404.78 920,423.93 - 13,226,433.07 6.51% Franchises 000-421200 Center Point/Entex Energy 72,100 4,978.09 5,276.32 4,978.09 - 67,121.91 6.90% 000-421220 City Public Service 420,837 32,621.98 23,624.91 32,621.98 - 388,215.02 7.75% 000-421240 Guadalupe Valley Elec Co-op 400,000 29,632.03 32,977.45 29,632.03 - 370,367.97 7.41% 000-421250 New Braunfels Utilities 61,800 3,665.30 3,273.34 3,665.30 - 58,134.70 5.93% 000-421300 Time Warner-State Franchise 300,000 26,321.91 27,685.52 26,321.91 - 273,678.09 8.77% 000-421460 AT&T Franchise Fee 260,868 22,627.06 11,489.01 22,627.06 - 238,240.94 8.67% 000-421480 Other Telecom Franchise 115,000 24,506.70 2,132.25 24,506.70 - 90,493.30 21.31% 000-421500 Solid Waste Franchise Fee 108,000 - 8,674.02 - - 108,000.00 0.00% TOTAL Franchises 1,738,605 144,353.07 115,132.82 144,353.07 - 1,594,251.93 8.30% Permits 000-431100 Home Occupation Permit 490 - 105.00 - - 490.00 0.00% 000-431205 Building Permit - Residential 404,420 29,741.00 35,744.00 29,741.00 - 374,679.00 7.35% 000-431210 Building Permit - Commercial 120,000 - - - - 120,000.00 0.00% 000-431215 Building Permit - General 135,296 17,520.00 8,949.00 17,520.00 - 117,776.00 12.95% 000-431300 Mobile Home Permit 450 225.00 - 225.00 - 225.00 50.00% 000-431400 Signs Permit 4,582 815.00 630.00 815.00 - 3,767.00 17.79% 000-431500 Food Establishmnt Permit 45,000 19,265.00 6,570.00 19,265.00 - 25,735.00 42.81% 000-431600 Garage Sale Permit 12,000 2,142.00 1,700.00 2,142.00 - 9,858.00 17.85% 000-431700 Plumbing Permit 117,324 7,956.40 7,484.00 7,956.40 - 109,367.60 6.78% 000-431750 Electrical Permit 50,000 4,440.00 4,860.00 4,440.00 - 45,560.00 8.88% 000-431800 Mechanical Permit 50,000 3,900.00 4,320.00 3,900.00 - 46,100.00 7.80% 000-431900 Solicitor/Peddler Permit 1,000 - 240.00 - - 1,000.00 0.00% 000-431950 Animal/Pet Permit 2,000 105.00 190.00 105.00 - 1,895.00 5.25% 000-432000 Cert. of Occupancy Prmt 6,500 550.00 600.00 550.00 - 5,950.00 8.46% ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 13 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 000-432100 Security Alarm Permit 45,000 2,295.00 2,675.00 2,295.00 - 42,705.00 5.10% 000-432300 Grading/Clearing Permit 3,000 600.00 - 600.00 - 2,400.00 20.00% 000-435000 Fire Permit 10,000 758.00 1,125.00 758.00 - 9,242.00 7.58% TOTAL Permits 1,007,062 90,312.40 75,192.00 90,312.40 - 916,749.60 8.97% Licenses 000-441000 Alcohol Beverage License 5,500 800.00 627.50 800.00 - 4,700.00 14.55% 000-441300 Mobile Home License 200 - - - - 200.00 0.00% 000-442000 Contractors License 60,200 3,655.00 3,965.00 3,655.00 - 56,545.00 6.07% 000-444000 Pet License 4,200 335.00 365.00 335.00 - 3,865.00 7.98% TOTAL Licenses 70,100 4,790.00 4,957.50 4,790.00 - 65,310.00 6.83% Fees 000-451000 Municipal Court Fines 1,662,300 110,815.37 128,104.25 110,815.37 - 1,551,484.63 6.67% 000-451100 Arrest Fee 56,734 4,816.86 5,339.43 4,816.86 - 51,917.14 8.49% 000-451110 Expunction Fee 120 - - - - 120.00 0.00% 000-451200 Warrant Fees 148,500 8,533.72 13,243.45 8,533.72 - 139,966.28 5.75% 000-451210 Court - Claims & Judgements - (773.10) (388.00) (773.10) - 773.10 0.00% 000-451320 Civil Justice Fee-Court 97 7.33 8.37 7.33 - 89.67 7.56% 000-451321 Civil Justice Fee-State 885 66.63 75.25 66.63 - 818.37 7.53% 000-451340 Judicial Fee - City 8,562 620.05 713.92 620.05 - 7,941.95 7.24% 000-451400 Traffic Fine Costs TTL 32,246 2,462.61 2,710.10 2,462.61 - 29,783.39 7.64% 000-451500 Teen Court Admin Fee 200 - 40.00 - - 200.00 0.00% 000-451510 Juvenile Case Mgmt Fee 64,384 5,166.88 5,964.43 5,166.88 - 59,217.12 8.03% 000-451600 Technology Fund Fee 59,500 4,086.03 4,768.79 4,086.03 - 55,413.97 6.87% 000-451700 Security Fee 42,655 3,064.52 3,576.58 3,065.52 - 39,589.48 7.19% 000-451800 Time Payment Fee - City 6,238 611.30 386.41 611.30 - 5,626.70 9.80% 000-451850 State Fines 10% Service Fee 92,278 18,121.14 25,205.85 18,121.14 - 74,156.86 19.64% 000-451900 DPS Payment - Local 13,981 668.00 1,185.04 668.00 - 13,313.00 4.78% 000-452000 Child Safety Fee 22,076 2,392.37 1,438.12 2,392.37 - 19,683.63 10.84% 000-452050 Indigent Defense Fee 31,076 2,060.44 2,351.77 2,060.44 - 29,015.56 6.63% 000-452100 Platting Fees 52,500 2,500.00 3,000.00 2,500.00 - 50,000.00 4.76% 000-452200 Site Plan Fee 25,500 2,000.00 3,000.00 2,000.00 - 23,500.00 7.84% 000-452300 Plan Check Fee 262,264 22,889.00 20,922.50 22,889.00 - 239,375.00 8.73% 000-452310 Miscellaneous Review Fee 1,200 - - - - 1,200.00 0.00% 000-452320 Tree Mitigation Admin Fee 10,000 31,312.50 - 31,312.50 - (21,312.50) 313.13% 000-452400 BOA/Zoning Fees 3,500 500.00 - 500.00 - 3,000.00 14.29% 000-452500 Food Handler Class 26,400 2,120.00 2,800.00 2,120.00 - 24,280.00 8.03% 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 000-452600 Specific Use/Zone Chng Fee 25,800 - - - - 25,800.00 0.00% 000-452710 Zoning Ltr & Dev Rights 1,050 - 150.00 - - 1,050.00 0.00% 000-453100 Reinspection Fees 36,700 2,650.00 7,125.00 2,650.00 - 34,050.00 7.22% 000-453110 Swim Pool Inspection Fee 1,500 - - - - 1,500.00 0.00% 000-453200 Lot Abatement 7,000 - 3,377.79 - - 7,000.00 0.00% 000-453211 Admin Fee-Inspections 5,200 1,600.00 400.00 1,600.00 - 3,600.00 30.77% 000-453710 Foster Care 1,400 100.00 150.00 100.00 - 1,300.00 7.14% 000-454200 Pool Gate Admission Fee 22,400 - - - - 22,400.00 0.00% 000-454300 Seasonal Pool Pass Fee 5,100 - - - - 5,100.00 0.00% 000-456500 Haz Mat Fees 12,000 - - - - 12,000.00 0.00% 000-456600 Fire Re-inspection Fee 750 100.00 150.00 100.00 - 650.00 13.33% 000-458110 Sale of Merchandise-GovDeal 18,000 52.00 - 52.00 - 17,948.00 0.29% 000-458300 Sale of Property/Auction 2,000 - 170.38 - - 2,000.00 0.00% 000-458400 Civic Center Rental Fees 140,916 10,095.25 15,505.25 10,095.25 - 130,820.75 7.16% 000-458401 Capital Recovery Fee-Civic Cntr 5,000 - 722.00 - - 5,000.00 0.00% 000-458450 North Center Rental Fees 20,600 1,990.00 2,255.00 1,990.00 - 18,610.00 9.66% 000-458500 Community Center Rental Fees 27,026 994.00 2,712.40 994.00 - 26,032.00 3.68% 000-458550 Pavilion Rental Fees 18,500 1,680.00 1,855.00 1,680.00 - 16,820.00 9.08% 000-458560 Chamber of Comm rent 7,800 - - - - 7,800.00 0.00% 000-458570 Non-Resident SYSA League - - - - - - 0.00% 000-458650 NonResident User Fee-BVYA 5,000 3,210.00 3,340.00 3,210.00 - 1,790.00 64.20% 000-458660 BVYA Utility Reimbursement 8,400 - - - - 8,400.00 0.00% 000-458670 SYSA Utility Reimbursement - - - - - - 0.00% 000-458675 Lions Futbol Utility Reimbursement 14,000 - 1,172.00 - - 14,000.00 0.00% 000-458680 Tournament Fees-Soccer - - - - - - 0.00% 000-458700 Vehicle Impoundment 6,000 2,470.00 - 2,470.00 - 3,530.00 41.17% 000-459200 NSF Check Fee 650 20.00 - 20.00 - 630.00 3.08% 000-459300 Notary Fee 300 36.00 24.00 36.00 - 264.00 12.00% 000-459400 Maps, Copies, UDC, & Misc F 100 - 5.00 - - 100.00 0.00% 000-459600 Animal Adoption Fee 17,500 805.00 1,045.00 805.00 (50.00) 16,745.00 4.31% 000-459700 Pet Impoundment Fee 14,000 1,048.00 1,152.00 1,048.00 - 12,952.00 7.49% 000-459800 Police Reports Fee 6,000 382.20 528.30 382.20 - 5,617.80 6.37% TOTAL Fees 3,053,888 251,274.10 266,285.38 251,275.10 (50.00) 2,802,662.90 8.23% 15 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 Fines 000-463000 Library Fines 30,000 2,756.47 2,823.88 2,756.47 - 27,243.53 9.19% TOTAL Fines 30,000 2,756.47 2,823.88 2,756.47 - 27,243.53 9.19% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,072 1,756.48 1,756.48 1,756.48 - 19,315.52 8.34% 000-473200 City of Seguin - Fire Contract 30,000 2,435.90 3,355.26 2,435.90 - 27,564.10 8.12% 000-473300 Guad Co - Library 208,343 - - - - 208,343.00 0.00% 000-473400 Randolph AFB-Animal Cntrl 1,500 - - - - 1,500.00 0.00% 000-474200 Library Services - Cibolo 25,000 - - - - 25,000.00 0.00% 000-474210 Library Services-Selma 26,560 - - - - 26,560.00 0.00% 000-474400 Dispatch Service - Cibolo 133,305 - - - - 133,305.00 0.00% 000-474600 School Crossing Guard-Bexar 40,000 2,840.18 2,768.13 2,840.18 - 37,159.82 7.10% 000-474610 School Cross Guard-Guadalupe 40,000 2,746.66 2,584.37 2,746.66 - 37,253.34 6.87% 000-474620 School Crossing Guard-Comal - - - - - - 0.00% 000-474700 School Officer Funding 160,000 5,100.00 - 5,100.00 - 154,900.00 3.19% 000-474800 CPS CIED Funding - - - - - - 0.00% TOTAL Inter-Jurisdictional 685,780 14,879.22 10,464.24 14,879.22 - 670,900.78 2.17% Fund Transfers 000-480000 Indirect Costs - EMS 137,038 11,419.83 7,320.00 11,419.83 - 125,618.17 8.33% 000-480100 Indirect Costs - Hotel/Motel 145,385 12,115.42 13,126.42 12,115.42 - 133,269.58 8.33% 000-482100 Transfer From Reserves-Ct Tech 10,278 - - - - 10,278.00 0.00% 000-482150 Transfer From Court Security 42,569 - - - 42,569.00 0.00% 000-485000 Interfund Charge-Drainage 51,800 4,316.67 4,142.33 4,316.67 - 47,483.33 8.33% 000-486000 Interfund Chrges-Admin W&S 1,152,350 96,029.17 88,413.58 96,029.17 - 1,056,320.83 8.33% 000-486202 Transfer In-W&S 136,000 - - - - 136,000.00 0.00% 000-486314 Transfer In Hotel/Motel 33,000 - - - - 33,000.00 0.00% 000-487000 Interfund Charges-Fleet 130,344 10,861.99 9,396.75 10,861.99 - 119,482.01 8.33% 000-488000 Interfund Charges-4B 136,245 11,353.75 20,279.17 11,353.75 - 124,891.25 8.33% TOTAL Fund Transfers 1,975,009 146,096.83 142,678.25 146,096.83 - 1,828,912.17 7.40% 16 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ************************************************ 2 0 1 3 - 2 0 1 4 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 Miscellaneous 000-491000 Interest Earned 500 22.77 30.49 22.77 - 477.23 4.55% 000-491200 Investment Income 45,000 2,444.17 3,442.56 2,444.17 - 42,555.83 5.43% 000-491800 Gain/Loss - - - - - - 0.00% 000-491900 Unrealized Gain/Loss (26,000) (42.58) (3,110.40) (42.58) - (25,957.42) 0.00% 000-493120 Donations-Public Library 5,000 - - - - 5,000.00 0.00% 000-493130 Donations-Writing the Next Chap.- - 50.00 - - - 0.00% 000-493400 Donation - Animal Control 4,000 30.73 329.00 30.73 - 3,969.27 0.77% 000-493401 Donations-A/C Microchip 2,000 75.00 135.00 75.00 (5.00) 1,930.00 3.50% 000-493402 Donations-Spay&Neuter 14,000 627.50 707.00 627.50 (82.00) 13,454.50 3.90% 000-493502 Donations-PD - 2,400.00 - 2,400.00 - (2,400.00) 0.00% 000-493503 Donations - Fire Rescue - - 150.00 - - - 0.00% 000-495040 Friends of N. Schertz Park - - 685.00 - - - 0.00% 000-495100 Mobile Stage Rental Fees 2,000 - - - - 2,000.00 0.00% 000-497000 Misc Income-Gen Fund 20,000 4,862.43 - 4,862.43 - 15,137.57 24.31% 000-497005 Schertztales Advertising 220,000 18,775.00 17,741.00 18,775.00 - 201,225.00 8.53% 000-497007 Misc Income-Schertz Artz - - - - - - 0.00% 000-497100 Misc Income-Police 12,000 396.40 474.50 396.40 - 11,603.60 3.30% 000-497150 Misc Income-Fire Department - - 292.37 - - - 0.00% 000-497200 Misc Income-Library 4,000 428.00 398.75 428.00 - 3,572.00 10.70% 000-497210 Misc Income-Library Copier 13,000 1,337.75 1,542.20 1,337.75 - 11,662.25 10.29% 000-497300 Misc Income-Animal Control - - - - - - 0.00% 000-497400 Misc Income-Streets Dept.18,000 3,989.34 3,380.39 3,989.34 - 14,010.66 22.16% 000-497500 Misc Income-TML Insurance 25,000 - - - - 25,000.00 0.00% 000-497550 Misc Income-TML Reimbursemt 15,000 113.73 4,584.46 113.73 - 14,886.27 0.76% 000-497600 Misc Income-Vending Mach.2,200 170.16 165.09 170.16 - 2,029.84 7.73%000-498000 Reimbursmnt-Gen Fund 60,000 95.26 1,319.40 95.26 - 59,904.74 0.16% 000-498105 Reimburmnt Police - DEA 9,000 - - - - 9,000.00 0.00% 000-498107 Reimburmnt Police - Event - 3,500.00 - 3,500.00 - (3,500.00) 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 20,000 - - - - 20,000.00 0.00% TOTAL Miscellaneous 464,700 39,225.66 32,316.81 39,225.66 (87.00) 425,561.34 8.42% TOTAL REVENUES 23,172,001 1,614,111.68 1,434,255.66 1,614,112.68 (137.00) 21,558,025.32 6.97% 17 Cash in Bank Claim on Operating Cash Pool-Checking 11,593.50$ Cash in Investments LOGIC Investment-General Fund 3,059,348.45 LOGIC Investment-Equip Replacement 73,584.90 LOGIC Investment-Veh Replacement 211,073.20 LOGIC Investment-Air Condi Replacment 171,421.83 CAPITAL ONE Investment-General Fund 1,344,118.52 Total Cash in Bank & Investments 5,017,722.24$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 GENERAL FUND 18 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 363,589 2012-13 292,988 636,964 3,422,107 2,180,145 637,568 177,645 29,444 49,157 11,566 20,778 8,379 7,179.89 2011-12 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127 6,915 2010-11 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 2009-10 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 ADVALOREM TAX 19 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 481,247 2012-13 439,433 575,041 474,246 424,191 632,716 415,829 405,378 660,648 544,675 563,636 650,124 487,170 2011-12 428,995 463,636 339,192 415,822 461,400 365,083 347,395 535,930 398,080 408,851 575,414 440,250 2010-11 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2009-10 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 2008-09 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 10% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 Sales Tax - General Fund 20 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 2012-13 101,440 94,054 96,303 123,044 2011-12 96,392 76,414 77,398 103,230 2010-11 83,433 62,692 67,561 95,887 2009-10 77,354 61,468 63,276 80,716 $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 CITY PUBLIC SERVICE 21 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 103,525.00 - - - - 103,525.00 0.00% Wilenchik Walk for Life 25,000.00 - - - - 25,000.00 0.00% Hal Balwin Scholarship 13,800.00 - 18,085.00 8,175.00 - 5,625.00 0.00%Miscellaneous 4,775.00 14,902.10 8.43 6,727.10 - (1,952.10) 93.43% TOTAL REVENUES 147,100.00 14,902.10 18,093.43 14,902.10 - 132,197.90 8.44% EXPENDITURE SUMMARY GENERAL GOVERNMENTNon Departmental 5,150.00 - - - - 5,150.00 0.00% TOTAL GENERAL GOVERNMENT 5,150.00 - - - - 5,150.00 0.00% CULTURAL Festival of Angels 15,000.00 517.73 - 517.73 380.00 14,102.27 5.98% Employee Appreciation Event 12,000.00 - - - - 12,000.00 0.00% National Night Out 150.00 - - - - 150.00 0.00% Wilenchik Walk for Life 25,000.00 - - - - 25,000.00 0.00% Schertz Sweetheart 37,000.00 - 500.00 - 960.10 36,039.90 2.59% Jazzfest 25,000.00 - - - - 25,000.00 0.00% Hal Baldwin Scholarship 13,800.00 150.00 6,235.40 150.00 - 13,650.00 1.09% Other Events 14,000.00 - - - 1,267.36 12,732.64 9.05% TOTAL CULTURAL 141,950.00 667.73 6,735.40 667.73 2,607.46 138,674.81 2.31% TOTAL EXPENDITURES 147,100.00 667.73 6,735.40 667.73 2,607.46 143,824.81 2.23% REVENUE OVER(UNDER) EXPEND - 14,234.37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 ************************************************** 2 0 1 3 - 2 0 1 4 ************************************************** 22 Cash in Bank Claim on Operating Cash Pool-Checking 9,240.26$ Cash in Investments MBIA Special Events 26,764.06 Total Cash in Bank & Investments 36,004.32$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 SPECIAL EVENTS FUND 23 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 100,950.00 - - - - 100,950.00 0.00% Fund Transfers 260,550.00 - - - - 260,550.00 0.00% TOTAL REVENUES 361,500.00 - - - - 361,500.00 0.00% EXPENDITURE SUMMARY GENERAL GOVERNMENTNon Departmental 361,500.00 6,340.98 - 6,340.98 20,132.41 335,026.61 7.32% TOTAL GENERAL GOVERNMENT 361,500.00 6,340.98 - 6,340.98 20,132.41 335,026.61 7.32% TOTAL EXPENDITURES 361,500.00 6,340.98 - 6,340.98 20,132.41 335,026.61 7.32% REVENUE OVER(UNDER) EXPEND - (6,340.98) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 ************************************************** 2 0 1 3 - 2 0 1 4 ************************************************** 24 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 66,950 - - - - 66,950.00 0.00% 000-421465 AT&T PEG Fee 34,000 - - - - 34,000.00 0.00% TOTAL Franchises 100,950 - - - - 100,950.00 0.00% Fund Transfers000-481000 Transfer In - Reserves 260,550 - - - - 260,550.00 0.00% TOTAL Fund Transfers 260,550 - - - - 260,550.00 0.00% TOTAL REVENUES 361,500 - - - - 361,500.00 0.00% C I T Y O F S C H E R T Z ************************************************** 2 0 1 3 - 2 0 1 4 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 25 Cash in Bank Cash Balance 427,956.54$ Total Cash in Bank & Investments 427,956.54$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 PEG FUND 26 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 195,710 - - - - 195,710.00 0.00% Permits 12,000.00 15,982.04 - 15,982.04 - (3,982.04) 133.18% Fees 16,092,683 1,349,063.55 1,568,293.99 1,349,063.55 - 14,743,619.45 8.38% Fund Transfers 2,822,282 10,359.67 9,941.50 10,359.67 - 2,811,922.33 0.37%Miscellaneous 165,440 137,901.41 34,572.01 137,901.41 - 27,538.59 83.35% TOTAL REVENUES 19,288,115 1,513,306.67 1,612,807.50 1,513,306.67 - 17,774,808.33 7.85% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 446,455 22,700.89 18,719.35 22,700.89 - 423,754.11 5.08% Supplies 4,600 - 229.20 - 137.90 4,462.10 3.00% Human Services 183 - - - - 183.00 0.00% City Support Services 6,375 - - - - 6,375.00 0.00% Operations Support 117,000 10,095.03 3,778.46 10,095.03 49.12 106,855.85 8.67% Staff Support 7,100 50.00 - 50.00 43.30 7,006.70 1.31% Professional Services 24,000 1,849.23 1,816.05 1,849.23 - 22,150.77 7.71% Maintenance Services 13,440 - - - 5,720.00 7,720.00 42.56% Operating Equipment 2,547 - - - - 2,547.00 0.00% TOTAL BUSINESS OFFICE 621,700 34,695.15 24,543.06 34,695.15 5,950.32 581,054.53 6.54% W & S ADMINISTRATION Personnel Services 1,202,040 70,559.62 62,954.63 70,559.62 - 1,131,480.38 5.87% Supplies 195,150 907.80 5,185.28 907.80 77,971.05 116,271.15 40.42% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 98,100 30,763.26 32,459.83 30,763.26 49.78 67,286.96 31.41% Utility Services 3,339,800 223,386.11 233,339.35 223,386.11 60.40 3,116,353.49 6.69% Operations Support 9,250 239.49 256.01 239.49 - 9,010.51 2.59% Staff Support 28,200 430.84 381.56 430.84 490.06 27,279.10 3.27% City Assistance 1,900 - - - - 1,900.00 0.00% Professional Services 249,113 2,218.64 840.00 2,218.64 22,796.73 224,097.63 10.04% Fund Charges/Transfers 3,336,760 452,226.61 277,422.47 452,226.61 - 2,884,533.39 13.55% Maintenance Services 5,924,250 183,360.29 166,380.98 183,360.29 5,751.72 5,735,137.99 3.19% Other Costs 35,000 - - - - 35,000.00 0.00% ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 27 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 Debt Service 1,458,925 - - - - 1,458,925.00 0.00% Rental-Leasing 6,070 - - - - 6,070.00 0.00% Operating Equipment 6,400 - 237.50 - 399.98 6,000.02 6.25% Capital Outlay 451,380 - - - 134,032.00 317,348.00 29.69% TOTAL PUBLIC WORKS 16,343,338 964,092.66 779,457.61 964,092.66 241,551.72 15,137,693.62 7.38% MISC & PROJECTS PROJECTS Professional Services - 6,372.90 - 6,372.90 29.00 (6,401.90) 0.00% Fund Charges/Transfers 2,185,086 - - - - 2,185,086.00 0.00% TOTAL PROJECTS 2,185,086 6,372.90 - 6,372.90 29.00 2,178,684.10 0.29% TOTAL MISC & PROJECTS 2,185,086 6,372.90 - 6,372.90 29.00 2,178,684.10 0.29% TOTAL EXPENDITURES 19,150,124 1,005,161 804,001 1,005,161 247,531 17,897,432 6.54% ** REVENUE OVER(UNDER)EXPENSES **137,991 508,145.96 28 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 195,710 - - - - 195,710.00 0.00% TOTAL Franchises 195,710 - - - - 195,710.00 0.00% Permits000-432400 Development Permit 12,000 15,982.04 - 15,982.04 - (3,982.04) 133.18% TOTAL Permits 12,000 15,982.04 - 15,982.04 - (3,982.04) 133.18% Fees 000-455200 Garbage Collection Fee 3,600,000 345,342.45 329,570.74 345,342.45 - 3,254,657.55 9.59% 000-455600 Fire Line Fees 22,000 3,620.00 20,635.00 3,620.00 - 18,380.00 16.45% 000-455700 Recycle Fee Revenue 262,983 21,267.10 27,447.20 21,267.10 - 241,715.90 8.09% 000-455800 W&S Line Constructn Reimbursemnt 30,000 1,240.00 1,864.82 1,240.00 - 28,760.00 4.13% 000-457100 Sale of Water 8,043,200 638,256.80 813,388.63 638,256.80 - 7,404,943.20 7.94% 000-457110 Edwards Water Lease 127,000 - - - - 127,000.00 0.00% 000-457120 Water Transfer Charge-Selma 42,000 11,244.80 13,929.28 11,244.80 - 30,755.20 26.77% 000-457130 Water Transfer Charge-U. C. 5,000 6,704.32 1,766.40 6,704.32 - (1,704.32) 134.09% 000-457140 Water Transfer Charge-Converse 30,000 3,844.80 10,649.44 3,844.80 - 26,155.20 12.82% 000-457200 Sale of Meters 90,000 3,662.00 4,178.00 3,662.00 - 86,338.00 4.07% 000-457400 Sewer Charges 3,658,000 293,406.25 329,691.01 293,406.25 - 3,364,593.75 8.02% 000-457500 Water Penalties 180,000 15,520.03 15,033.47 15,520.03 - 164,479.97 8.62% 000-458400 Building rental Fee - 4,800.00 - 4,800.00 - (4,800.00) 0.00% 000-459200 NSF Check Fee-Water&Sewer 2,500 155.00 140.00 155.00 - 2,345.00 6.20% TOTAL Fees 16,092,683 1,349,063.55 1,568,293.99 1,349,063.55 - 14,743,619.45 8.38% Fund Transfers 000-481000 Transfer In- Reserve 2,185,086 - - - - 2,185,086.00 0.00% 000-486102 Transfer In-Equipment Reserves 102,500 - - - - 102,500.00 0.00% 000-486103 Transfer In-Vehicle Reserves 290,380 - - - - 290,380.00 0.00% 000-486204 Interfnd Chrg-Drainage Bill 124,316 10,359.67 9,941.50 10,359.67 - 113,956.33 8.33% 000-486411 Transfer In-Capital Recovery 120,000 - - - - 120,000.00 0.00% TOTAL Fund Transfers 2,822,282 10,359.67 9,941.50 10,359.67 - 2,811,922.33 0.37% ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** AS OF: OCTOBER 31st, 2013 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z 29 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 3 - 2 0 1 4 ****************************************************** AS OF: OCTOBER 31st, 2013 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 700 205.00 - 205.00 - 495.00 29.29% 000-491000 Interest Earned 2,000 126.51 151.50 126.51 - 1,873.49 6.33% 000-491200 Investment Income 12,000 268.91 525.10 268.91 - 11,731.09 2.24% 000-496050 SSLG - SAWS Reservation - 134,500.00 - 134,500.00 - (134,500.00) 0.00% 000-497000 Misc Income-W&S 40,000 2,800.99 7,393.30 2,800.99 - 37,199.01 7.00% 000-498110 Reimbursement-SSLGC 110,740 - 26,502.11 - - 110,740.00 0.00% TOTAL Miscellaneous 165,440 137,901.41 34,572.01 137,901.41 - 27,538.59 83.35% TOTAL REVENUES 19,288,115 1,513,306.67 1,612,807.50 1,513,306.67 - 17,774,808.33 7.85% 30 Cash in Bank Claim on Operating Cash Pool-Checking 480,261.45$ Cash in Investments Lone Star Investment-Water&Sewer 738,077.47 Lone Star Investment-W&S Customer Deposits 294,935.14 Lone Star Investment-W&S Equip Replacement 374,667.38 Lone Star Investment-W&S Veh Replacement 546,310.29 Lone Star Investment-Water/SSLGC SAWS 674,447.74 Schertz Bank & Trust-Certificate of Deposit 1,060,132.25 3,688,570.27$ Total Cash in Bank & Investments 4,168,831.72$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 WATER & SEWER 31 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 5,563,353 418,542.27 354,103.75 418,542.27 (25.00) 5,144,835.73 7.52% Inter-Jurisdictional 1,556,828 8,487.52 299,521.28 8,487.52 - 1,548,340.56 0.55%Miscellaneous 239,500 18,584.80 8,925.25 18,584.80 - 220,915.20 7.76% TOTAL REVENUES 7,359,681 445,614.59 662,550.28 445,614.59 (25.00) 6,914,091.49 6.05% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 2,848,462 183,567.05 185,668.08 183,567.05 - 2,664,894.95 6.44% Supplies 359,284 3,651.44 12,620.66 3,651.44 68,883.26 286,749.30 20.19% Human Services 800 - - - - 800.00 0.00% City Support Services 32,500 17,826.32 14,035.29 17,826.32 - 14,673.68 54.85% Utility Services 115,800 1,821.99 - 1,821.99 - 113,978.01 1.57% Operations Support 62,305 23,257.36 2,769.82 23,257.36 180.00 38,867.64 37.62% Staff Support 79,500 1,354.00 3,337.20 1,354.00 10,528.27 67,617.73 14.95% City Assistance 14,400 (286.03) - (286.03) 100.00 14,586.03 -1.29% Professional Services 137,016 16,511.86 29,604.43 16,511.86 19,517.74 100,986.40 26.30% Fund Charges/Transfers 2,662,073 - 86,950.10 - - 2,662,073.00 0.00% Maintenance Services 57,820 450.00 450.00 450.00 1,617.70 55,752.30 3.58% Debt Service 152,772 - - - - 152,772.00 0.00% Rental-Leasing 82,000 - - - - 82,000.00 0.00% Operating Equipment 188,500 - - - 23,650.46 164,849.54 12.55% Capital Outlay 80,000 - - - - 80,000.00 0.00% TOTAL PUBLIC SAFETY 6,873,232 248,153.99 335,435.58 248,153.99 124,477.43 6,500,600.58 5.42% TOTAL EXPENDITURES 6,873,232 248,153.99 335,435.58 248,153.99 124,477.43 6,500,600.58 5.42% ** REVENUE OVER(UNDER) EXPENSES **486,449 197,460.60 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 32 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 5,398,953 416,171.52 354,083.75 416,171.52 - 4,982,781.48 7.71% 000-456110 Subscription Program Fees 40,000 335.00 - 335.00 (25.00) 39,690.00 0.78% 000-456120 EMT Class - Fees 104,400 300.00 - 300.00 - 104,100.00 0.29% 000-456130 Immunization Fees - - - - - - 0.00% 000-456140 Billing Fees - Alamo Heights 20,000 1,710.75 - 1,710.75 - 18,289.25 8.55% 000-458110 Sales of Merchandise - GovDeal - - - - - - 0.00% 000-459200 NSF Check Fee - 25.00 20.00 25.00 - (25.00) 0.00% TOTAL Fees 5,563,353 418,542.27 354,103.75 418,542.27 (25.00) 5,144,835.73 7.52% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 286,126 - - - - 286,126.00 0.00% 000-474300 Cibolo Support 253,757 - 57,207.55 - - 253,756.80 0.00% 000-475100 Comal Co ESD #6 90,694 7,336.24 20,726.48 7,336.24 - 83,357.84 8.09% 000-475200 Live Oak Support 170,178 - 41,296.99 - - 170,177.76 0.00% 000-475300 Universal City Support 240,149 - 58,276.85 - - 240,148.80 0.00% 000-475400 Selma Support 71,798 - 17,423.30 - - 71,798.40 0.00% 000-475500 Schertz Support 420,915 - 98,957.42 - - 420,914.88 0.00% 000-475600 Santa Clara Support 9,396 - 2,280.12 - - 9,396.00 0.00% 000-475800 Marion Support 13,815 1,151.28 3,352.57 1,151.28 - 12,664.08 8.33% TOTAL Inter-Jurisdictional 1,556,828 8,487.52 299,521.28 8,487.52 - 1,548,340.56 0.55% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 33 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** Miscellaneous 000-491200 Investment Income - - 54.39 - - - 0.00% 000-493203 Donations-EMS 2,000 - 106.00 - - 2,000.00 0.00% 000-493204 Donations-Dilworth Fund 3,500 - - - - 3,500.00 0.00% 000-493205 Donations- Golf Tournament 4,000 - - - - 4,000.00 0.00% 000-497000 Misc Income 130,000 17,875.50 7,379.86 17,875.50 - 112,124.50 13.75% 000-497100 Recovery of Bad Debt 100,000 709.30 1,385.00 709.30 - 99,290.70 2.75% TOTAL Miscellaneous 239,500 18,584.80 8,925.25 18,584.80 - 220,915.20 7.76% TOTAL REVENUES 7,359,681 445,614.59 662,550.28 445,614.59 (25.00) 6,914,091.49 6.05% 34 Cash in Bank Claim on Operating Cash Pool-Checking (308,984.66)$ Total Cash in Bank & Investments (308,984.66)$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 SCHERTZ EMS 35 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits - 220.00 - 220.00 - (220.00) 0.00% Fees 1,041,000 87,356.40 84,254.73 87,356.40 - 953,643.60 13.17% Miscellaneous 1,700 150.29 94.20 150.29 - 1,549.71 9.57% TOTAL REVENUES 1,042,700 87,726.69 84,348.93 87,726.69 - 954,973.31 13.19% EXPENDITURE SUMMARY PUBLIC WORKSDRAINAGE Personnel Services 457,350 25,888.16 24,312.13 25,888.16 - 431,461.84 5.66% Supplies 8,300 105.98 37.86 105.98 661.17 7,532.85 9.24% Human Services 325 - - - - 325.00 0.00% City Support Services 26,500 2,166.61 1,482.13 2,166.61 - 24,333.39 8.18% Utility Services 29,500 40.98 476.80 40.98 578.88 28,880.14 2.10% Operations Support 2,460 - - - - 2,460.00 0.00% Staff Support 7,625 227.43 50.00 227.43 222.48 7,175.09 5.90% City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 - - - - 23,500.00 0.00% Fund Charges/Transfers 197,304 16,375.34 15,694.66 16,375.34 - 180,928.66 8.30% Maintenance Services 22,000 - - - - 22,000.00 0.00% Other costs 200 - - - - 200.00 0.00% Debt Service 18,574 - - - - 18,574.00 0.00% Rental/Leasing 500 - - - - 500.00 0.00% Operating Equipment 632 - - - - 632.00 0.00% Capital Outlay 243,398 - - - 24,322.00 219,076.00 9.99% TOTAL DRAINAGE 1,039,008 44,804.50 42,053.58 44,804.50 25,784.53 968,418.97 6.79% TOTAL EXPENDITURES 1,039,008 44,804.50 42,053.58 44,804.50 25,784.53 968,418.97 6.79% ** REVENUE OVER(UNDER) EXPEND 3,692 42,922.19 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 **************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** 36 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit - 220.00 - 220.00 - (220.00) 0.00% TOTAL Permits - 220.00 - 220.00 - (220.00) 0.00% Fees 000-457500 Drainage Penalties 5,000 569.54 463.48 569.54 - 4,430.46 11.39% 000-457600 Drainage Fee 1,036,000 86,786.86 83,791.25 86,786.86 - 949,213.14 8.38% TOTAL Fees 1,041,000 87,356.40 84,254.73 87,356.40 - 953,643.60 8.39% Miscellaneous 000-491000 Interest Earned 100 11.91 7.21 11.91 - 88.09 11.91% 000-491200 Investment Interest 600 78.38 82.37 78.38 - 521.62 13.06% 000-497000 Misc Income-Drainage 1,000 60.00 4.62 60.00 - 940.00 6.00% TOTAL Miscellaneous 1,700 150.29 94.20 150.29 - 1,549.71 8.84% TOTAL REVENUES 1,042,700 87,726.69 84,348.93 87,726.69 - 954,973.31 8.41% C I T Y O F S C H E R T Z *********************************************** 2 0 1 3 - 2 0 1 4 ************************************************* REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 37 Cash in Bank Claim on Operating Cash Pool-Checking 219,866.02 Cash in Investments Lone Star Investment-Drainage Maint Fund 604,929.79 Total Cash in Bank & Investments 824,795.81$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 38 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 485,000 - - - - 485,000.00 0.00% Fund Transfers 137,738 - - - - 137,738 0.00% Miscellaneous 550 31.69 52.56 31.69 - 518.31 5.76% TOTAL REVENUES 623,288 31.69 52.56 31.69 - 623,256.31 0.01% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,000 - - - - 2,000.00 0.00% City Support Services 65,128 20,407.50 7,500.00 20,407.50 - 44,720.50 31.33% Operations Support 75,500 500.00 1,400.00 500.00 - 75,000.00 0.66% Professional Services 5,625 - - - - 5,625.00 0.00% Fund Charges/Transfers 399,035 12,115.42 13,126.42 12,115.42 - 386,919.58 3.04% Operating Equipment 56,000 - - - 6,729.40 49,270.60 12.02% Capital Outlay 20,000 - - - - 20,000.00 0.00% TOTAL NONDEPARTMENTAL 623,288 33,022.92 22,026.42 33,022.92 6,729.40 583,535.68 6.38% TOTAL EXPENDITURES 623,288 33,022.92 22,026.42 33,022.92 6,729.40 583,535.68 6.38% REVENUE OVER(UNDER) EXPENDITURE - (32,991.23) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 **************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** 39 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411800 Hotel Occupancy Tax 485,000 - - - - 485,000.00 0.00% TOTAL Taxes 485,000 - - - - 485,000.00 0.00% Fund Transfers 000-481000 Transfer From Reserve 137,738 - - - - 137,738.00 0.00% TOTAL Fund Transfers 137,738 - - - - 137,738.00 0.00% Miscellaneous 000-491000 Interest Earned 50 8.12 3.08 8.12 - 41.88 16.24%000-491200 Investment Interest 500 23.57 49.48 23.57 - 476.43 4.71% TOTAL Miscellaneous 550 31.69 52.56 31.69 - 518.31 5.76% TOTAL REVENUES 623,288 31.69 52.56 31.69 - 623,256.31 0.01% C I T Y O F S C H E R T Z *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 40 Cash in Bank Claim on Operating Cash Pool-Checking 129,130.22$ Cash in Investments MBIA - Hotel Tax 298,926.14 Total Cash in Bank & Investments 428,056.36$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 HOTEL OCCUPANCY TAX FUND 41 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 40,023 2012-13 35,851 39,439 32,392 32,120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 2011-12 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 46,551 29,807 2010-11 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 2009-10 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 $- $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 HOTEL OCCUPANCY TAX 42 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 150,000 - - - - 150,000.00 0.00% Miscellaneous 300 1.10 23.29 1.10 - 298.90 0.37% TOTAL REVENUES 150,300 1.10 23.29 1.10 - 150,298.90 0.00% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services - - - - - - 0.00% Fund Charges/Transfers - - - - - - 0.00% Operating Equipment - - - - - - 0.00%Capital Outlay 40,000 - - - - 40,000.00 0.00% TOTAL PARKLAND DEDICATION 40,000 - - - - 40,000.00 0.00% TOTAL EXPENDITURES 40,000 - - - - 40,000.00 0.00% REVENUE OVER(UNDER) EXPEND 110,300 1.10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 43 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 150,000 - - - - 150,000.00 0.00% TOTAL Fees 150,000 - - - - 150,000.00 0.00% Miscellaneous 000-491000 Interest Earned - 0.36 2.48 0.36 - (0.36) 0.00%000-491200 Investment Interest 300 0.74 20.81 0.74 - 299.26 0.25% TOTAL Miscellaneous 300 1.10 23.29 1.10 - 298.90 0.37% TOTAL REVENUES 150,300 1.10 23.29 1.10 - 150,298.90 0.00% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 3 - 2 0 1 4 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 44 Cash in Bank Claim on Operating Cash Pool-Checking $4,283.30 Cash in Investments MBIA Investment-Park Fund 5,353.93 Total in Investment Pool 5,353.93 Total Cash in Bank & Investments $9,637.23 CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 PARK FUND 45 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 35,000 177,437.50 - 177,437.50 - (142,437.50) 506.96% Miscellaneous 104,525 15.66 18.91 15.66 - 104,509.34 0.01% TOTAL REVENUES 139,525 177,453.16 18.91 177,453.16 - (37,928.16) 127.18% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 139,525 - - - 24,300.00 115,225.00 17.42%Capital Outlay - - - - - - 0.00% TOTAL TREE MITIGATION 139,525 - - - 24,300.00 115,225.00 17.42% TOTAL EXPENDITURES 139,525 - - - 24,300.00 115,225.00 17.42% REVENUE OVER(UNDER) EXPEND - 177,453.16 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** 46 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 35,000 177,437.50 - 177,437.50 - (142,437.50) 506.96% TOTAL Fees 35,000 177,437.50 - 177,437.50 - (142,437.50) 506.96% Miscellaneous 000-491000 Interest Earned 50 8.03 - 8.03 - 41.97 16.06% 000-491200 Investment Interest 150 7.63 18.91 7.63 - 142.37 5.09% 000-497000 Misc Income - - - - - - 0.00%000-499000 Transfer In Reserves 104,325 - - - - 104,325.00 0.00% TOTAL Miscellaneous 104,525 15.66 18.91 15.66 - 104,509.34 0.01% TOTAL REVENUES 139,525 177,453.16 18.91 177,453.16 - (37,928.16) 127.18% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 3 - 2 0 1 4 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 47 Cash in Bank Claim on Operating Cash Pool-Checking $237,856.68 Cash in Investments MBIA Investment-Tree Mitigation 97,255.26 Total Cash in Bank & Investments $335,111.94 CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 TREE MITIGATION FUND 48 411-CAPITAL RECOVERY CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,449,960 80,700.00 97,032.00 80,700.00 - 1,369,260.00 5.57% Fund Transfers 1,425,609 - - - - 1,425,609.00 0.00% Miscellaneous 20,300 3,028.75 984.68 3,028.75 - 17,271.25 14.92% TOTAL REVENUES 2,895,869 83,728.75 98,016.68 83,728.75 - 2,812,140.25 2.89% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 - - - - 109.00 0.00% Professional Services 450,000 356.12 354.85 356.12 - 449,643.88 0.08% Fund Charges/Transfers 120,000 - - - - 120,000.00 0.00%Maintenance Services 1,000 - - - - 1,000.00 0.00% TOTAL NON DEPARTMENTAL 576,109 356.12 354.85 356.12 - 575,752.88 0.06% MISC & PROJECTS Water Projects 1,750,000 - - - - 1,750,000.00 0.00% Sewer Projects - 6,042.30 - 6,042.30 - (6,042.30) 0.00% Schaefer Road Water Improvements - - - - - - 0.00% TOTAL MISC & PROJECTS 1,750,000 6,042.30 - 6,042.30 - 1,743,957.70 0.35% TOTAL EXPENDITURES 2,326,109 6,398.42 354.85 6,398.42 - 2,319,710.58 0.28% REVENUE OVER(UNDER) EXPENDITURES 569,760 77,330 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 ******************************************************* 2 0 1 3 - 2 0 1 4 ******************************************************* 49 411-CAPITAL RECOVERY CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 880,200 46,944.00 64,548.00 46,944.00 - 833,256.00 5.33% 000-455910 Capital Recovery - Waste Wtr 500,400 28,356.00 21,684.00 28,356.00 - 472,044.00 5.67% 000-455913 Cap Recovery-North Sewer Tr 69,360 5,400.00 10,800.00 5,400.00 - 63,960.00 7.79% TOTAL Fees 1,449,960 80,700.00 97,032.00 80,700.00 - 1,369,260.00 5.57% Fund Transfers000-481000 Transfer from Reserves 1,425,609 - - - - 1,425,609.00 0.00% TOTAL Fund Transfers 1,425,609 - - - - 1,425,609.00 0.00% Miscellaneous 000-491000 Interest Earned 300 29.40 26.38 29.40 - 270.60 9.80% 000-491200 Investment Income 45,000 4,054.80 4,759.70 4,054.80 - 40,945.20 9.01% 000-491800 Gain/Loss - (9,144.38) - (9,144.38) - 9,144.38 0.00% 000-491900 Unrealized Gain/Loss-Cap One (25,000) 8,088.93 (3,801.40) 8,088.93 - (33,088.93) 0.00% TOTAL Miscellaneous 20,300 3,028.75 984.68 3,028.75 - 17,271.25 14.92% TOTAL REVENUES 2,895,869 83,728.75 98,016.68 83,728.75 - 2,812,140.25 2.89% C I T Y O F S C H E R T Z **************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 50 Cash in Bank Claim on Operating Cash Pool-Checking 576,219.01$ Cash in Investments Lone Star Investment-Capital Recovery Water 3,688,221.12 Lone Star Investment-Capital Recovery Sewer 1,449,791.58 Capital One-Investment 1,722,387.15 Total Cash in Bank & Investments 7,436,618.86$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 CAPITAL RECOVERY 51 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,204,493 231,403.00 199,903.71 231,403.00 - 4,973,090.00 4.45% Fund Transfers 1,069 - - - - 1,069.00 0.00% Miscellaneous 391,213 38.34 2,960.65 38.34 - 391,174.66 0.01% TOTAL REVENUES 5,596,775 231,441.34 202,864.36 231,441.34 - 5,365,333.66 4.14% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 - - - - 42,350.00 0.00%Debt Service 5,554,425 - - - - 5,554,425.00 0.00% TOTAL GENERAL GOVERNMENT 5,596,775 - - - - 5,596,775.00 0.00% TOTAL EXPENDITURES 5,596,775 - - - - 5,596,775.00 0.00% ** REVENUE OVER(UNDER) EXPEND - 231,441.34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 ****************************************************** 2 0 1 3 - 2 0 1 4 **************************************************** 52 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 5,204,493 231,403.00 199,903.71 231,403.00 - 4,973,090.00 4.45% TOTAL Taxes 5,204,493 231,403.00 199,903.71 231,403.00 - 4,973,090.00 4.45% Fund Transfers000-486000 Transfer From Reserves 1,069 - - - - 1,069.00 0.00% TOTAL Fund Transfers 1,069 - - - - 1,069.00 0.00% Miscellaneous 000-491000 Interest Earned 75 6.92 2.71 6.92 - 68.08 9.23%000-491200 Investment Earnings 25,000 31.42 2,957.94 31.42 - 24,968.58 0.13% 000-495015 Contribution from SED 366,138 - - - - 366,138.00 0.00% TOTAL Miscellaneous 391,213 38.34 2,960.65 38.34 - 391,174.66 0.01% TOTAL REVENUES 5,596,775 231,441.34 202,864.36 231,441.34 - 5,365,333.66 4.14% C I T Y O F S C H E R T Z ***************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 53 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF NON DEPARTMENTAL BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 2,350 - - - - 2,350.00 0.00% 101-541502 Cost of Bond Issuance 40,000 - - - - 40,000.00 0.00% TOTAL Professional Services 42,350 - - - - 42,350.00 0.00% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 260,000 - - - - 260,000.00 0.00%101-555612.1 Bond-GO Refunding 2010 Interest 70,750 - - - - 70,750.00 0.00% 101-555622 Schertz C O SR2003-Principal 200,000 - - - - 200,000.00 0.00% 101-555622.1 Schertz C O SR2003-Interest 634,982 - - - - 634,982.00 0.00% 101-555624 Comm Proj Bond-SR04-Principal 112,834 - - - - 112,834.00 0.00% 101-555624.1 Comm Proj Bond SR04-Interest 14,106 - - - - 14,106.00 0.00% 101-555626 LS&D SR2006-Principal 245,000 - - - - 245,000.00 0.00% 101-555626.1 LS&D SR2006-Interest 179,792 - - - - 179,792.00 0.00% 101-555628 CO Bond 2007-Principal 430,000 - - - - 430,000.00 0.00% 101-555628.1 CO Bond 2007-Interest 332,259 - - - - 332,259.00 0.00% 101-555629 GO Bond 2007-Principal 590,000 - - - - 590,000.00 0.00% 101-555629.1 GO Bond 2007-Interest 314,201 - - - - 314,201.00 0.00% 101-555630 GO Bond SR2008 Principal 210,000 - - - - 210,000.00 0.00% 101-555630.1 GO Bond SR2008 Interest 358,038 - - - - 358,038.00 0.00% 101-555631 GO Bond SR2009 Principal 615,000 - - - - 615,000.00 0.00% 101-555631.1 BO Bond SR2009 Interest 145,916 - - - - 145,916.00 0.00% 101-555633 GO SR2011 Principal 285,000 - - - - 285,000.00 0.00% 101-555633.1 GO SR2011 Interest 219,284 - - - - 219,284.00 0.00% 101-555634 GO SR2011A Refund Principal 160,000 - - - - 160,000.00 0.00% 101-555634.1 GO SR2011A Refund Interest 11,223 - - - - 11,223.00 0.00% 101-555635 GO SR2012 Principal 155,000 - - - - 155,000.00 0.00% 101-555635.1 GO SR2012 Interest 11,040 - - - - 11,040.00 0.00% TOTAL Debt Service 5,554,425 - - - - 5,554,425.00 0.00% TOTAL EXPENDITURES 5,596,775 - - - - 5,596,775.00 0.00% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 ***************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** 54 Cash in Bank Claim on Operating Cash Pool-Checking 259,029.92$ Cash in Investments MBIA Investment- Tax I&S 398,780.22 Total Cash in Bank & Investments 657,810.14$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 TAX I&S 55 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 3,095,036 277,289.24 238,473.94 277,289.24 - 2,817,746.76 8.96% Fund Transfers - - - - - - 0.00% Miscellaneous 10,175 348.17 10.79 348.17 - 9,826.83 3.42% TOTAL REVENUES 3,105,211 277,637.41 238,484.73 277,637.41 - 2,827,573.59 8.94% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 326,237 18,182.27 15,651.06 18,182.27 - 308,054.73 5.57% Supplies 1,250 - - - - 1,250.00 0.00% Human Services 200 - - - - 200.00 0.00% City Support Services 16,545 1,174.29 1,199.99 1,174.29 - 15,370.71 7.10% Utility Services 2,795 52.58 - 52.58 - 2,742.42 1.88% Operations Support 148,200 49,839.95 49,756.01 49,839.95 24.20 98,335.85 33.65% Staff Support 18,050 350.00 - 350.00 990.94 16,709.06 7.43% City Assistance 1,525,000 - - - - 1,525,000.00 0.00% Professional Services 102,500 - - - - 102,500.00 0.00% Fund Charges/Transfers 503,605 11,455.58 20,547.67 11,455.58 - 492,149.42 2.27% Debt Service 427,672 - - - - 427,672.00 0.00%Operating Equipment 2,500 - - - 19.99 2,480.01 0.80% TOTAL ECONO DEVELOPMENT 3,074,554 81,054.67 87,154.73 81,054.67 1,035.13 2,992,464.20 2.67% ** REVENUE OVER(UNDER) EXPEND 30,657 196,582.74 C I T Y O F S C H E R T Z ***************************************************** 2 0 1 3 - 2 0 1 4 ***************************************************** REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2013 56 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 8.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411500 Sales Tax Revenue (4B)3,095,036 277,289.24 238,473.94 277,289.24 - 2,817,746.76 8.96% TOTAL Taxes 3,095,036 277,289.24 238,473.94 277,289.24 - 2,817,746.76 8.96% Miscellaneous 000-491000 Interest Earned 175 23.44 10.79 23.44 - 151.56 13.39%000-491200 Investment Earnings 10,000 324.73 - 324.73 - 9,675.27 3.25% TOTAL Miscellaneous 10,175 348.17 10.79 348.17 - 9,827 3.42% TOTAL REVENUES 3,105,211 277,637.41 238,484.73 277,637.41 - 2,827,573.59 8.94% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) *************************************************** 2 0 1 3 - 2 0 1 4 *************************************************** AS OF: OCTOBER 31st, 2013 57 Cash in Bank Claim on Operating Cash Pool-Checking 267,893.39$ Cash in Investments MBIA Investment-Economic Development Corp 4,312,699.04 Schertz Bank & Trust-Certificate of Deposit 1,040,078.07 Total Cash in Bank & Investments 5,620,670.50$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2013 SED CORPORATION 58 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 240,623 2012-13 219,717 287,520 237,123 212,096 316,358 207,915 202,689 330,324 272,337 281,818 325,062 243,585 2011-12 214,497 231,818 169,596 207,911 230,700 182,541 173,698 267,965 199,040 204,426 287,707 220,125 2010-11 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2009-10 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 10% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 4B SALES TAX 59 INVESTMENT REPORT C I T Y O F S C H E R T Z FOR MONTH ENDING OCTOBER 31st, 2013 60 INVESTMENT POOLS Beginning Deposits/Interest Ending Ending Par Maturity Weighted Book Value Yield Purchases Withdrawals Earned Book Value Mkt Value Value Date Avg Mat. OPERATIONS-BANK CASH Schertz Bank & Trust - Pooled Cash 4,276,913.15 0.0500 9,842,204.58 9,469,214.87 194.01 4,650,096.87 4,650,096.87 4,650,096.87 N/A Schertz Bank & Trust - PEG Fund 434,297.52 0.0000 - 6,340.98 - 427,956.54 427,956.54 427,956.54 N/A TOTAL OPERATIONS 4,711,210.67 9,842,204.58 9,475,555.85 194.01 5,078,053.41 5,078,053.41 5,078,053.41 - LOGIC General Fund 3,059,041.07 0.1183 - 307.38 3,059,348.45 3,059,348.45 3,059,348.45 N/A 59 Days G/F-Equipment Replacement 73,577.50 0.1183 - - 7.40 73,584.90 73,584.90 73,584.90 N/A 59 Days G/F-Vehicle Replacement 211,051.98 0.1183 - - 21.22 211,073.20 211,073.20 211,073.20 N/A 59 Days G/F-Air Conditioner Replacement 171,404.60 0.1183 - - 17.23 171,421.83 171,421.83 171,421.83 N/A 59 Days SR2009 Bond-Street Projects(II)1,670,856.78 0.1183 - - 167.87 1,671,024.65 1,671,024.65 1,671,024.65 N/A 59 Days TOTAL LOGIC 5,185,931.93 - - 521.10 5,186,453.03 5,186,453.03 5,186,453.03 - LONESTAR Capital Recovery - Sewer 1,449,603.73 0.1500 - - 187.85 1,449,791.58 1,449,791.58 1,449,791.58 N/A 70 Days Capital Recovery - Water 3,687,743.23 0.1500 - - 477.89 3,688,221.12 3,688,221.12 3,688,221.12 N/A 70 Days Facilities Master Plan - 0.1500 95,000.00 - 8.73 95,008.73 95,008.73 95,008.73 N/A 70 Days Drainage Fund 604,851.41 0.1500 - - 78.38 604,929.79 604,929.79 604,929.79 N/A 70 Days GO SR2011 Animal Shelter 1,024,195.12 0.1500 - 194,210.88 131.91 830,116.15 830,116.15 830,116.15 N/A 70 Days GO SR2011 Athletic Fields 2,678,183.44 0.1500 - 1,332.38 347.06 2,677,198.12 2,677,198.12 2,677,198.12 N/A 70 Days GO SR2011 Soccer Fields 2,646,539.80 0.1500 - 298,081.79 341.72 2,348,799.73 2,348,799.73 2,348,799.73 N/A 70 Days GO SR2011 Swimming Pool 6,054,904.27 0.1500 - 9,892.49 784.61 6,045,796.39 6,045,796.39 6,045,796.39 N/A 70 Days GO SR2012 Downtown Improvements 1,001,854.83 0.1500 - - 129.83 1,001,984.66 1,001,984.66 1,001,984.66 N/A 70 Days Sewer/CCMA Project (0.00) 0.1500 3,000,000.00 15,000.00 274.54 2,985,274.54 2,985,274.54 2,985,274.54 N/A 70 Days W/S-Customer Deposits 294,896.92 0.1500 - - 38.22 294,935.14 294,935.14 294,935.14 N/A 70 Days W/S-Equipment Repl/Cap.Imp 24,632.04 0.1500 350,000.00 - 35.34 374,667.38 374,667.38 374,667.38 N/A 70 Days Water&Sewer 38,008.24 0.1500 700,000.00 - 69.23 738,077.47 738,077.47 738,077.47 N/A 70 Days W/S-Vehicle Replacement 46,258.36 0.1500 500,000.00 - 51.93 546,310.29 546,310.29 546,310.29 N/A 70 Days Water/SSLG - SAWS 324,373.55 0.1500 350,000.00 - 74.19 674,447.74 674,447.74 674,447.74 N/A 70 Days TOTAL LONESTAR 19,876,044.94 4,995,000.00 518,517.54 3,031.43 24,355,558.83 24,355,558.83 24,355,558.83 - TEXAS CLASS Tax I&S 398,748.80 0.0900 - - 31.42 398,780.22 398,780.22 398,780.22 N/A N/A Police Forfeiture 338,668.13 0.0900 - - 26.65 338,694.78 338,694.78 338,694.78 N/A N/A Park Fund 165,353.19 0.0900 - 160,000.00 0.74 5,353.93 5,353.93 5,353.93 N/A N/A Economic Development Corporation 4,112,374.31 0.0900 200,000.00 - 324.73 4,312,699.04 4,312,699.04 4,312,699.04 N/A N/A Library 44,811.78 0.0900 - - 3.55 44,815.33 44,815.33 44,815.33 N/A N/A Tree Mitigation 97,247.63 0.0900 - - 7.63 97,255.26 97,255.26 97,255.26 N/A N/A Tax Note 2013 Fire Truck 65,632.34 0.0900 - - 5.14 65,637.48 65,637.48 65,637.48 N/A N/A Hotel Tax 298,902.57 0.0900 - - 23.57 298,926.14 298,926.14 298,926.14 N/A N/A Special Events Fund 26,761.96 0.0900 - - 2.10 26,764.06 26,764.06 26,764.06 N/A N/A Citywide Projects SR2007 870,266.35 0.0900 - - 68.59 870,334.94 870,334.94 870,334.94 N/A N/A Tax Note 2013 A P25 785,306.88 0.0900 - - 61.91 785,368.79 785,368.79 785,368.79 N/A N/A TOTAL TEXAS CLASS 7,204,073.94 200,000.00 160,000.00 556.03 7,244,629.97 7,244,629.97 7,244,629.97 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING OCTOBER 31st, 2013 61 62 TOTAL OPERATIONS 11% TOTAL LOGIC 11% TOTAL LONESTAR 52% TOTAL TEXAS CLASS 15% TOTAL CAPITAL ONE 6% TOTAL C.D.s 5% City Portfolio By Investment Type 63 Operations, $11,283,192.23 Projects, $19,199,985.65 Debt Service Fund, $398,780.22 Special Revenue Funds, $13,559,887.00 Designated Funds, $2,594,578.40 City Portfolio By Use 64 OCT-13 NOV-13 DEC-13 JAN-14 FEB-14 MAR-14 APR-14 MAY-14 JUN-14 JUL-14 AUG-14 SEP-14 1 Month T-Bill 0.0300 3 Month T-Bill 0.0400 6 Month T-Bill 0.0800 Schertz Portfolio 0.2879 Schertz Bank&Trust 0.0500 CD 365 Days 0.4000 CD 180 Days 0.4000 LOGIC 0.1183 LoneStar 0.1500 MBIA 0.0900 Capital One 2.0347 0.00 0.50 1.00 1.50 2.00 2.50 MONTHLY YIELDS 65 C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:10/31/2013 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 10,684.12 10,684.12 10,684.12 5.00 0.05 Total Cash & Equivalents 10,684.12 10,684.12 10,684.12 5.00 0.05% Fixed Income Federal Home Loan Bks Cons Bds 8/13/2014 286.00 125,000.00 141,987.30 130,326.25 6,875.00 4.84 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 776.00 100,000.00 116,185.00 109,504.00 4,875.00 4.20 Federal Natl Mtg Assn 1/30/2017 1187.00 100,000.00 102,366.80 101,666.00 1,250.00 1.22 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 390.00 200,000.00 200,609.40 201,226.00 1,500.00 0.75 Federal Natl Mtg Assn 7/28/2015 635.00 125,000.00 132,828.63 129,518.75 2,968.00 2.23 US Treasury Note 11/30/2015 760.00 60,000.00 61,936.72 61,303.20 825.00 1.33 US Treasury Note 5/31/2016 943.00 325,000.00 337,135.74 335,754.25 5,687.00 1.69 US Treasury Note 8/31/2016 1035.00 75,000.00 75,205.07 75,952.50 750.00 1.00 US Treasury Note 9/15/2014 319.00 180,000.00 180,184.77 180,199.80 450.00 0.25 Total Fixed Income 1,290,000.00 1,348,439.43 1,325,450.75 25,180.00 1.87% Total Assets 673.35 1,300,684.12 1,359,123.55 1,336,134.87 25,185.00 1.85% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 9,610.23 9,610.23 9,610.23 5.00 0.05 Total Cash & Equivalents 9,610.23 9,610.23 9,610.23 5.00 0.05% Fixed Income Federal Home Loan Bks Cons Bds 8/13/2014 286.00 165,000.00 187,423.24 172,030.65 9,075.00 4.84 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 776.00 200,000.00 230,779.00 219,008.00 9,750.00 4.22 Federal Home Ln Mtg Corp Deb 11/15/2013 15.00 75,000.00 84,301.87 75,141.75 3,656.00 4.34 Federal Natl Mtg Assn 12/21/2015 781.00 100,000.00 99,989.10 99,976.00 375.00 0.38 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 390.00 220,000.00 220,078.68 221,348.60 1,650.00 0.75 Federal Natl Mtg Assn 7/28/2015 635.00 135,000.00 143,454.91 139,880.25 3,206.00 2.23 US Treasury Note 11/30/2015 760.00 230,000.00 235,465.04 234,995.60 3,162.00 1.34 US Treasury Note 5/31/2016 943.00 350,000.00 364,567.38 361,581.50 6,125.00 1.68 US Treasury Note 7/15/2016 988.00 175,000.00 174,471.68 175,595.00 1,093.00 0.63 Total Fixed Income 1,650,000.00 1,740,530.90 1,699,557.35 38,092.00 2.19% Total Assets 676.57 1,659,610.23 1,750,141.13 1,709,167.58 38,097.00 2.18% 66