Loading...
01-OCTOBER 2014 FINANCIAL STATEMENT OCTOBER 2014 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department February 11, 2015 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 16,665,690 374,867.29 923,641.65 7,402,883.66 - 9,262,806.34 44.42% Franchises 1,986,159 - 158,615.21 - - 1,986,159.00 0.00% Permits 1,175,803 130,875.00 90,312.40 130,875.00 - 1,044,928.00 11.13% Licenses 91,229 4,070.00 4,790.00 4,070.00 - 87,159.00 4.46% Fees 2,814,366 225,015.16 252,043.26 225,015.16 - 2,589,350.84 8.00% Fines 30,000 2,384.54 2,756.47 2,384.54 - 27,615.46 7.95% Inter-Jurisdictional 708,392 7,210.22 14,879.22 7,210.22 - 701,181.78 1.02% Fund Transfers 1,759,754 141,042.08 146,096.83 141,042.08 - 1,618,711.92 8.01% Miscellaneous 467,650 35,585.73 43,625.52 35,585.73 (48.50) 432,112.77 7.60% TOTAL REVENUES 25,699,043 921,050.02 1,636,760.56 7,949,066.39 (48.50) 17,750,025.11 30.93% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 1,237.03 2,066.91 1,237.03 - 22,337.97 5.25% Supplies 1,800 - - - - 1,800.00 0.00% City Support Services 40,600 - 3,633.01 - - 40,600.00 0.00% Operations Support 400 - - - - 400.00 0.00% Staff Support 21,300 18.00 1,120.15 18.00 2,135.03 19,146.97 10.11% TOTAL CITY COUNCIL 87,675 1,255.03 6,820.07 1,255.03 2,135.03 84,284.94 3.87% CITY MANAGER Personnel Services 832,380 44,906.66 50,772.51 44,906.66 - 787,473.34 5.39% Supplies 3,000 153.47 94.78 153.47 - 2,846.53 5.12% City Support Services 2,770 - 600.00 - 300.00 2,470.00 10.83% Staff Support 27,975 990.38 612.42 990.38 1,591.54 25,393.08 9.23% Professional Services - - - - - - 0.00% TOTAL CITY MANAGER 866,125 46,050.51 52,079.71 46,050.51 1,891.54 818,182.95 5.54% *************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 MUNICIPAL COURT Personnel Services 301,231 14,413.86 15,488.31 14,413.86 - 286,817.14 4.78% Supplies 3,500 - - - 19.96 3,480.04 0.57% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 - 90.00 - - 4,500.00 0.00% Staff Support 7,710 - 286.00 - 324.04 7,385.96 4.20% Court Support 700 - - - - 700.00 0.00% Professional Services 68,200 2,615.00 5,028.17 2,615.00 61,740.00 3,845.00 94.36% Maintenance Services 2,800 150.00 - 150.00 1,650.00 1,000.00 64.29% Operating Equipment 800 - - - - 800.00 0.00% TOTAL MUNICIPAL COURT 390,441 17,178.86 20,892.48 17,178.86 63,734.00 309,528.14 20.72% CUSTOMER RELATIONS-311 Personnel Services 113,241 5,470.26 5,641.07 5,470.26 - 107,770.74 4.83% Supplies 200 - - - - 200.00 0.00% Staff Support 750 - - - - 750.00 0.00% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 114,691 5,470.26 5,641.07 5,470.26 - 109,220.74 4.77% PLANNING & ZONING Personnel Services 133,705 6,903.62 7,062.02 6,903.62 - 126,801.38 5.16% Supplies 2,672 - - - - 2,672.00 0.00% Operations Support 750 - 199.88 - - 750.00 0.00% Staff Support 19,950 61.47 47.68 61.47 347.33 19,541.20 2.05% Professional Services 300 - - - - 300.00 0.00% Operating Equipment 450 - - - - 450.00 0.00% TOTAL PLANNING & ZONING 157,827 6,965.09 7,309.58 6,965.09 347.33 150,514.58 4.63% LEGAL SERVICES Operations Support 10,000 - - - 122.76 9,877.24 1.23% Professional Services 350,000 - - - - 350,000.00 0.00% TOTAL LEGAL SERVICES 360,000 - - - 122.76 359,877.24 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 GENERAL SERVICES Personnel Services 578,049 35,669.81 38,343.85 35,669.81 - 542,379.19 6.17% Supplies 60,425 1,253.97 549.44 1,253.97 2,051.16 57,119.87 5.47% Utility Services 99,880 4,945.60 5,696.10 4,945.60 - 94,934.40 4.95% Staff Support 11,749 20.61 - 20.61 840.31 10,888.08 7.33% Maintenance Services 31,900 - 128.25 - 4,683.70 27,216.30 14.68% Operating Equipment 10,800 - - - - 10,800.00 0.00% Capital Outlay - - - - - - 0.00% TOTAL GENERAL SERVICES 792,803 41,889.99 44,717.64 41,889.99 7,575.17 743,337.84 6.24% BUILDING 6-8 MAINTENANCE Supplies 30,250 264.28 1,126.99 264.28 1,345.01 28,640.71 5.32% Utility Services 89,235 4,568.41 4,573.74 4,568.41 - 84,666.59 5.12% Maintenance Services 58,700 - 1,494.52 - 8,839.57 49,860.43 15.06% Operating Equipment 23,000 - - - 1,049.93 21,950.07 4.56% TOTAL BUILDING 6-8 MAINTENANCE 201,185 4,832.69 7,195.25 4,832.69 11,234.51 185,117.80 7.99% CITY SECRETARY Personnel Services 167,772 8,928.84 8,991.69 8,928.84 - 158,843.16 5.32% Supplies 1,200 204.90 - 204.90 - 995.10 17.08% City Support Services 9,700 - - - - 9,700.00 0.00% Operations Support 150 - - - - 150.00 0.00% Staff Support 8,795 240.00 470.83 240.00 192.10 8,362.90 4.91% TOTAL CITY SECRETARY 187,617 9,373.74 9,462.52 9,373.74 192.10 178,051.16 5.10% NON-DEPARTMENTAL City Support Services 860,000 140,262.23 146,823.64 140,262.23 2,200.00 717,537.77 16.57% Operations Support 141,500 10,295.63 8,746.86 10,295.63 - 131,204.37 7.28% Staff Support 150 - - - - 150.00 0.00% City Assistance 1,243,779 - - - - 1,243,779.00 0.00% Professional Services 262,400 198.48 2,399.00 198.48 - 262,201.52 0.08% Fund Chrgs/Transfrs-Spec Events Fnd 203,000 - - - - 203,000.00 0.00% Operating Equipment 50,000 - - - - 50,000.00 0.00% TOTAL NON-DEPARTMENTAL 2,760,829 150,756.34 157,969.50 150,756.34 2,200.00 2,607,872.66 5.54% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 PUBLIC AFFAIRS Personnel Services 257,970 10,920.10 10,527.81 10,920.10 - 247,049.90 4.23% Supplies 3,500 - 78.54 - - 3,500.00 0.00% Operations Support 27,100 - - - 142.50 26,957.50 0.53% Staff Support 5,150 275.00 - 275.00 - 4,875.00 5.34% Professional Services 14,500 - - - - 14,500.00 0.00% Operating Equipment - - - - - - 0.00% TOTAL PUBLIC AFFAIRS 308,220 11,195.10 10,606.35 11,195.10 142.50 296,882.40 3.68% RECORDS MANAGEMENT Personnel Services 51,106 2,696.88 2,720.93 2,696.88 - 48,409.12 5.28% Supplies 400 - - - - 400.00 0.00% Staff Support 1,750 160.49 - 160.49 435.70 1,153.81 34.07% Professional Services 10,000 511.00 183.50 511.00 620.00 8,869.00 11.31% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 63,256 3,368.37 2,904.43 3,368.37 1,139.47 58,748.16 7.13% SCHERTZ MAGAZINE Personnel Services 137,208 7,573.34 7,628.04 7,573.34 - 129,634.66 5.52% Supplies 200 - - - - 200.00 0.00% Opperations Support 100 - - - - 100.00 0.00% Staff Support 3,000 - - - 18.00 2,982.00 0.60% Professional Services 253,500 3,912.70 100.00 3,912.70 8,085.24 241,502.06 4.73% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - - - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 404,608 11,486.04 7,728.04 11,486.04 8,103.24 385,018.72 4.84% ENGINEERING Personnel Services 282,558 8,693.86 4,146.51 8,693.86 - 273,864.14 3.08% Supplies 1,300 90.65 - 90.65 171.54 1,037.81 20.17% City Support Services 1,500 - - - - 1,500.00 0.00% Utility Services 1,498 - - - - 1,498.00 0.00% Staff Support 10,512 - - - 24.85 10,487.15 0.24% Professional Services 38,800 - 3,262.50 - - 38,800.00 0.00% Operating Equipment 600 - - - - 600.00 0.00% TOTAL ENGINEERING 336,768 8,784.51 7,409.01 8,784.51 196.39 327,787.10 2.67% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 GIS Personnel Services 135,495 7,487.82 7,443.79 7,487.82 - 128,007.18 5.53% Supplies 2,910 - - - - 2,910.00 0.00% Staff Support 5,235 - - - - 5,235.00 0.00% Rental/Leasing 3,805 - - - - 3,805.00 0.00% Operating Equipment 7,350 - - - - 7,350.00 0.00% TOTAL GIS 154,795 7,487.82 7,443.79 7,487.82 - 147,307.18 4.84% TOTAL GENERAL GOVERNMENT 7,186,840 326,094.35 348,179.44 326,094.35 99,014.04 6,761,731.61 5.92% PUBLIC SAFETY POLICE Personnel Services 4,983,836 292,692.84 296,765.79 292,692.84 - 4,691,143.16 5.87% Supplies 47,646 - 850.07 - 11,595.48 36,050.52 24.34% City Support Services 26,750 23,151.52 26,721.66 23,151.52 - 3,598.48 86.55% Utility Services 148,064 - 32.04 - - 148,064.00 0.00% Operations Support 2,950 - - - - 2,950.00 0.00% Staff Support 109,423 1,541.08 6,314.84 1,541.08 12,172.00 95,709.92 12.53% City Assistance 10,200 - - - 262.20 9,937.80 2.57% Professional Services 53,313 302.81 - 302.81 4,535.50 48,474.69 9.08% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 53,790 - 6,000.00 - 8,940.00 44,850.00 16.62% Operating Equipment 108,868 250.00 139.95 250.00 7,660.55 100,957.45 7.27% Capital Outlay 218,754 - - - 25,175.00 193,579.00 11.51% TOTAL POLICE 5,763,594 317,938.25 336,824.35 317,938.25 70,340.73 5,375,315.02 6.74% FIRE RESCUE Personnel Services 2,890,145 176,894.46 159,126.56 176,894.46 - 2,713,250.54 6.12% Supplies 16,500 - 376.65 - 302.44 16,197.56 1.83% Utility Services 58,700 453.50 49.19 453.50 528.00 57,718.50 1.67% Operations Support 1,200 - - - - 1,200.00 0.00% Staff Support 115,700 4,221.39 5,552.25 4,221.39 10,660.13 100,818.48 12.86% City Assistance 16,200 - - - 410.00 15,790.00 2.53% Professional Services 25,000 - - - - 25,000.00 0.00% Maintenance Services 58,932 - 135.80 - 953.30 57,978.70 1.62% Rental/Leasing 14,000 - - - - 14,000.00 0.00% Operating Equipment 65,900 - - - - 65,900.00 0.00% Capital Outlay 210,600 - - - - 210,600.00 0.00% TOTAL FIRE RESCUE 3,472,877 181,569.35 165,240.45 181,569.35 12,853.87 3,278,453.78 5.60% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 INSPECTIONS Personnel Services 533,804 22,331.04 25,126.52 22,331.04 - 511,472.96 4.18% Supplies 2,938 - 78.30 - 151.10 2,786.90 5.14% Utility Services 6,500 - - - - 6,500.00 0.00% Operations Support 2,200 - - - 410.48 1,789.52 18.66% Staff Support 10,850 123.50 50.49 123.50 313.16 10,413.34 4.02% Professional Services - - - - - - 0.00% Operating Equipment 28,520 - - - - 28,520.00 0.00% TOTAL INSPECTIONS 584,812 22,454.54 25,255.31 22,454.54 874.74 561,482.72 3.99% MARSHAL'S OFFICE Personnel Services 570,071 32,748.06 33,257.25 32,748.06 - 537,322.94 5.74% Supplies 6,400 274.83 - 274.83 121.30 6,003.87 6.19% Utility Services 16,000 - - - - 16,000.00 0.00% Operations Support 3,500 - - - 217.56 3,282.44 6.22% Staff Support 14,800 667.99 259.08 667.99 - 14,132.01 4.51% City Assistance 2,500 - - - - 2,500.00 0.00% Maintenance Services 17,700 - - - 200.00 17,500.00 1.13% Operating Equipment 19,700 - - - 90.98 19,609.02 0.46% Capital Outlay 8,000 - - - - 8,000.00 0.00% TOTAL MARSHAL'S OFFICE 658,671 33,690.88 33,516.33 33,690.88 629.84 624,350.28 5.21% TOTAL PUBLIC SAFETY 10,479,954 555,653.02 560,836.44 555,653.02 84,699.18 9,839,601.80 6.11% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 PUBLIC ENVIRONMENT STREETS Personnel Services 691,780 50,800.71 51,615.04 50,800.71 - 640,979.29 7.34% Supplies 7,100 164.28 6.04 164.28 888.22 6,047.50 14.82% Utility Services 136,200 399.20 236.14 399.20 550.80 135,250.00 0.70% Staff Support 10,030 282.03 337.60 282.03 1,033.42 8,714.55 13.12% City Assistance 500 - - - - 500.00 0.00% Professional Services 40,000 - - - - 40,000.00 0.00% Maintenance Services 135,400 2,972.77 2,861.05 2,972.77 4,395.36 128,031.87 5.44% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 300 - - - - 300.00 0.00% Capital Outlay 28,000 - - - - 28,000.00 0.00% TOTAL STREETS 1,049,510 54,618.99 55,055.87 54,618.99 6,867.80 988,023.21 5.86% TOTAL PUBLIC ENVIRONMENT 1,049,510 54,618.99 55,055.87 54,618.99 6,867.80 988,023.21 5.86% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 533,103 25,331.31 29,497.18 25,331.31 - 507,771.69 4.75% Supplies 41,905 138.71 - 138.71 1,734.44 40,031.85 4.47% Utility Services 143,800 7,330.95 5,029.65 7,330.95 231.64 136,237.41 5.26% Operations Support 250 - - - - 250.00 0.00% Staff Support 8,473 142.80 - 142.80 287.05 8,043.15 5.07% Professional Services 72,000 - - - 6,152.50 65,847.50 8.55% Maintenance Services 20,000 - - - 29.80 19,970.20 0.15% Rental/Leasing 39,600 6,038.32 - 6,038.32 30,191.60 3,370.08 91.49% Operating Equipment 2,000 625.00 - 625.00 541.19 833.81 58.31% Capital Outlay 60,000 - - - - 60,000.00 0.00% TOTAL PARKS DEPARTMENT 921,131 39,607.09 34,526.83 39,607.09 39,168.22 842,355.69 8.55% SWIM POOL Supplies 20,700 - - - 313.58 20,386.42 1.51% Utility Services 29,000 1,217.04 1,728.07 1,217.04 - 27,782.96 4.20% Maintenance Services 203,378 - 461.49 - - 203,378.00 0.00% TOTAL SWIM POOL 253,078 1,217.04 2,189.56 1,217.04 313.58 251,547.38 0.60% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 EVENT FACILITIES Personnel Services 58,642 2,848.95 2,905.75 2,848.95 - 55,793.05 4.86% Supplies 14,500 107.49 272.57 107.49 1,248.21 13,144.30 9.35% Utility Services 51,400 2,892.62 2,214.30 2,892.62 - 48,507.38 5.63% Operations Support 23,311 - - - - 23,311.00 0.00% Staff Support 2,448 550.00 - 550.00 - 1,898.00 22.47% Professional Services 500 - 199.10 - - 500.00 0.00% Operating Equipment 5,000 - - - - 5,000.00 0.00% TOTAL EVENT FACILITIES 155,801 6,399.06 5,591.72 6,399.06 1,248.21 148,153.73 4.91% SENIOR CITIZEN CENTER Supplies 7,650 139.71 - 139.71 427.95 7,082.34 7.42% Utility Services 4,240 - - - - 4,240.00 0.00% Operations Support 1,500 - - - - 1,500.00 0.00% City Assistence 20,000 - - - 2,058.60 17,941.40 10.29% Professional Services 8,000 - - - - 8,000.00 0.00% Maintenance Services 5,000 80.50 - 80.50 158.58 4,760.92 4.78% TOTAL SENIOR CITIZEN CENTER 46,390 220.21 - 220.21 2,645.13 43,524.66 6.18% TOTAL PARKS & RECREATION 1,376,400 47,443.40 42,308.11 47,443.40 43,375.14 1,285,581.46 6.60% CULTURAL LIBRARY Personnel Services 672,828 31,631.25 38,235.63 31,631.25 - 641,196.75 4.70% Supplies 12,000 23.96 80.95 23.96 85.55 11,890.49 0.91% Utility Services 56,500 3,290.32 3,519.98 3,290.32 - 53,209.68 5.82% Operations Support 3,000 - - - 860.00 2,140.00 28.67% Staff Support 6,345 - 32.44 - 537.30 5,807.70 8.47% Professional Services 2,300 - - - - 2,300.00 0.00% Operating Equipment 89,500 - 74.88 - 5,032.16 84,467.84 5.62% TOTAL LIBRARY 842,473 34,945.53 41,943.88 34,945.53 6,515.01 801,012.46 4.92% TOTAL CULTURAL 842,473 34,945.53 41,943.88 34,945.53 6,515.01 801,012.46 4.92% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 HEALTH ANIMAL SERVICES Personnel Services 306,397 16,594.58 16,535.74 16,594.58 - 289,802.42 5.42% Supplies 37,883 1,178.51 - 1,178.51 2,471.98 34,232.51 9.64% Utility Services 46,840 902.37 170.23 902.37 - 45,937.63 1.93% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 11,390 - 75.00 - 117.31 11,272.69 1.03% City Assistance 17,550 - - - 1,344.95 16,205.05 7.66% Professional Services 26,500 - 3,276.46 - 785.00 25,715.00 2.96% Maintenance Services 23,200 - - - 180.00 23,020.00 0.78% Operating Equipment 11,500 - - - 2,914.35 8,585.65 25.34% Capital Outlay 21,000 - - - - 21,000.00 0.00% TOTAL ANIMAL SERVICES 503,260 18,675.46 20,057.43 18,675.46 7,813.59 476,770.95 5.26% TOTAL HEALTH 503,260 18,675.46 20,057.43 18,675.46 7,813.59 476,770.95 5.26% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 441,993 21,580.10 20,986.05 21,580.10 - 420,412.90 4.88% Supplies 3,500 - 54.49 - 124.62 3,375.38 3.56% City Support Services 598,643 53,853.00 28,260.42 53,853.00 17,847.44 526,942.56 11.98% Utility Services 236,822 11,885.07 11,106.29 11,885.07 280.77 224,656.16 5.14% Staff Support 37,400 895.00 650.00 895.00 494.57 36,010.43 3.72% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 15,600 889.32 - 889.32 1,608.90 13,101.78 16.01% Operating Equipment 291,571 2,303.50 1,510.23 2,303.50 6,862.77 282,404.73 3.14% TOTAL INFORMATION TECHNOLOGY 1,625,529 91,405.99 62,567.48 91,405.99 27,219.07 1,506,903.94 7.30% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 HUMAN RESOURCES Personnel Services 310,863 15,759.70 15,103.25 15,759.70 - 295,103.30 5.07% Supplies 1,000 - - - 86.57 913.43 8.66% Human Services 64,000 288.09 200.00 288.09 3,611.59 60,100.32 6.09% Operations Support 14,000 - - - - 14,000.00 0.00% Staff Support 14,620 - - - 1,915.00 12,705.00 13.10% City Assistance 10,000 - - - 816.00 9,184.00 8.16% Professional Services 9,200 - - - 744.75 8,455.25 8.10% Operating Equipment - - - - - - 0.00% TOTAL HUMAN RESOURCES 423,683 16,047.79 15,303.25 16,047.79 7,173.91 400,461.30 5.48% FINANCE Personnel Services 516,715 24,336.52 24,697.80 24,336.52 - 492,378.48 4.71% Supplies 2,800 319.45 305.20 319.45 - 2,480.55 11.41% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 15,605 1,908.11 6,956.05 8,017.10 - 7,587.90 51.38% Maintenance Services - - - - - - 0.00% TOTAL FINANCE 536,120 26,564.08 31,959.05 32,673.07 - 503,446.93 6.09% PURCHASING & ASSET MGT Personnel Services 262,098 9,745.08 13,874.59 9,745.08 - 252,352.92 3.72% Supplies 1,200 - - - 81.34 1,118.66 6.78% Utility Services 500 - - - - 500.00 0.00% Operations Support 300 - - - - 300.00 0.00% Staff Support 8,070 250.00 250.00 250.00 250.00 7,570.00 6.20% Operating Equipment 1,300 - - - - 1,300.00 0.00% TOTAL PURCHASING & ASSET MGT 273,468 9,995.08 14,124.59 9,995.08 331.34 263,141.58 3.78% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 FLEET SERVICE Personnel Services 313,447 13,053.76 13,205.34 13,053.76 - 300,393.24 4.16% Supplies 174,525 7,107.82 6,170.45 7,107.82 9,207.95 158,209.23 9.35% City Support Services 3,500 - 2,100.00 - - 3,500.00 0.00% Utility Services 5,000 - - - - 5,000.00 0.00% Operations Support 400 - - - - 400.00 0.00% Staff Support 4,500 37.22 73.89 37.22 111.34 4,351.44 3.30% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 73,750 2,210.88 378.34 2,210.88 2,785.66 68,753.46 6.77% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 100.00 - 100.00 2,032.08 6,067.92 26.00% Capital Outlay 65,000 - - - - 65,000.00 0.00% TOTAL FLEET SERVICE 648,702 22,509.68 21,928.02 22,509.68 14,137.03 612,055.29 5.65% BUILDING MAINTENANCE Personnel Services 136,524 6,221.45 6,225.95 6,221.45 - 130,302.55 4.56% Supplies 1,043 304.80 - 304.80 4.15 734.05 29.62% Utility Services 2,350 - - - - 2,350.00 0.00% Staff Support 2,900 27.51 29.55 27.51 76.01 2,796.48 3.57% Professional Services 12,000 - - - - 12,000.00 0.00% Maintenance Services 71,132 467.64 12,362.82 467.64 1,279.68 69,384.68 2.46% Rental/Leasing 1,400 - - - - 1,400.00 0.00% Operating Equipment 1,500 - - - - 1,500.00 0.00% Capital Outlay 38,750 - - - 8,415.00 30,335.00 21.72% TOTAL BUILDING MAINTENANCE 267,599 7,021.40 18,618.32 7,021.40 9,774.84 250,802.76 6.28% TOTAL INTERNAL SERVICE 3,775,101 173,544.02 164,500.71 179,653.01 58,636.19 3,536,811.80 6.31% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 5,000.00 5,000.00 5,000.00 - - 100.00% Transportation Assistance 31,678 - - - - 31,678.00 0.00% Children's Advocacy Assistance 5,000 - - - - 5,000.00 0.00% Senior Citizen's Hot Meals 45,000 - 3,500.00 - - 45,000.00 0.00% TOTAL CITY ASSISTANCE 86,678 5,000.00 8,500.00 5,000.00 - 81,678.00 5.77% COURT - RESTRICTED FUNDS Fund Charges/Transfers - - - - - - 0.00% Operating Equipment 85,872 - - - 1,840.00 84,032.00 2.14% TOTAL CITY ASSISTANCE 85,872 - - - 1,840.00 84,032.00 2.14% TOTAL MISC & PROJECTS 172,550 5,000 8,500 5,000 1,840 165,710.00 3.96% TOTAL EXPENDITURES 25,386,088 1,215,974.77 1,241,381.88 1,222,083.76 308,760.95 23,855,243.29 6.03% REVENUE OVER(UNDER) EXPEND.312,955 6,726,982.63 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 9,188,520 357,435.63 363,588.83 357,435.63 - 8,831,084.37 3.89% 000-411200 Advalorem Tax - Delinquent 50,000 3,942.26 (10,791.21) 3,942.26 - 46,057.74 7.88% 000-411300 Advalorem Tax - P&I 50,000 2,064.15 2,462.11 2,064.15 - 47,935.85 4.13% 000-411500 Sales Tax Revenue-Gen Fund 7,346,170 508,315.99 557,796.19 508,315.99 - 6,837,854.01 6.92% 000-411600 Bingo Tax - - - - - - 0.00% 000-411700 Mixed Beverage Tax 31,000.00 11,425.25 10,585.73 11,425.25 - 19,574.75 36.86% TOTAL Taxes 16,665,690 883,183.28 923,641.65 883,183.28 - 15,782,506.72 5.30% Franchises 000-421200 Center Point/Entex Energy 87,202 6,620.12 4,978.09 6,620.12 - 80,581.88 7.59% 000-421220 City Public Service 649,940 44,788.16 32,621.98 44,788.16 - 605,151.84 6.89% 000-421240 Guadalupe Valley Elec Co-op 443,320 33,052.76 29,632.03 33,052.76 - 410,267.24 7.46% 000-421250 New Braunfels Utilities 60,697 4,606.97 3,665.30 4,606.97 - 56,090.03 7.59% 000-421300 Time Warner-State Franchise 275,000 22,708.75 26,321.91 22,708.75 - 252,291.25 8.26% 000-421460 AT&T Franchise Fee 250,000 20,143.63 22,627.06 20,143.63 - 229,856.37 8.06% 000-421480 Other Telecom Franchise 100,000 22,259.77 24,506.70 22,259.77 - 77,740.23 22.26% 000-421500 Solid Waste Franchise Fee 120,000 14,982.16 14,262.14 14,982.16 - 105,017.84 12.49% TOTAL Franchises 1,986,159 169,162.32 158,615.21 169,162.32 - 1,816,996.68 8.52% Permits 000-431100 Home Occupation Permit 420 - - - - 420.00 0.00% 000-431205 Building Permit - Residential 356,476 67,665.00 29,741.00 67,665.00 - 288,811.00 18.98% 000-431210 Building Permit - Commercial 125,521 - - - - 125,521.00 0.00% 000-431215 Building Permit - General 350,000 8,546.00 17,520.00 8,546.00 - 341,454.00 2.44% 000-431300 Mobile Home Permit 525 100.00 225.00 100.00 - 425.00 19.05% 000-431400 Signs Permit 11,920 404.00 815.00 404.00 - 11,516.00 3.39% 000-431500 Food Establishmnt Permit 48,000 24,730.00 19,265.00 24,730.00 - 23,270.00 51.52% 000-431600 Garage Sale Permit 10,840 1,918.00 2,142.00 1,918.00 - 8,922.00 17.69% 000-431700 Plumbing Permit 100,851 12,415.00 7,956.40 12,415.00 - 88,436.00 12.31% 000-431750 Electrical Permit 50,000 4,800.00 4,440.00 4,800.00 - 45,200.00 9.60% 000-431800 Mechanical Permit 50,000 5,460.00 3,900.00 5,460.00 - 44,540.00 10.92% 000-431900 Solicitor/Peddler Permit 1,000 60.00 - 60.00 - 940.00 6.00% 000-431950 Animal/Pet Permit 2,000 100.00 105.00 100.00 - 1,900.00 5.00% 000-432000 Cert. of Occupancy Prmt 5,250 700.00 550.00 700.00 - 4,550.00 13.33% ************************************************ 2 0 1 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 000-432100 Security Alarm Permit 45,000 3,370.00 2,295.00 3,370.00 - 41,630.00 7.49% 000-432300 Grading/Clearing Permit 3,000 - 600.00 - - 3,000.00 0.00% 000-435000 Fire Permit 15,000 607.00 758.00 607.00 - 14,393.00 4.05% TOTAL Permits 1,175,803 130,875.00 90,312.40 130,875.00 - 1,044,928.00 11.13% Licenses 000-441000 Alcohol Beverage License 7,000 705.00 800.00 705.00 - 6,295.00 10.07% 000-441300 Mobile Home License 160 - - - - 160.00 0.00% 000-442000 Contractors License 79,569 3,200.00 3,655.00 3,200.00 - 76,369.00 4.02% 000-444000 Pet License 4,500 165.00 335.00 165.00 - 4,335.00 3.67% TOTAL Licenses 91,229 4,070.00 4,790.00 4,070.00 - 87,159.00 4.46% Fees 000-451000 Municipal Court Fines 1,300,000 99,526.35 110,815.37 99,526.35 - 1,200,473.65 7.66% 000-451100 Arrest Fee 56,534 4,187.58 4,816.86 4,187.58 - 52,346.42 7.41% 000-451110 Expunction Fee 120 - - - - 120.00 0.00% 000-451200 Warrant Fees 150,000 10,194.87 8,533.72 10,194.87 - 139,805.13 6.80% 000-451320 Civil Justice Fee-Court 34 - 7.33 - - 34.00 0.00% 000-451321 Civil Justice Fee-State 288 - 66.63 - - 288.00 0.00% 000-451340 Judicial Fee - City 7,567 552.08 620.05 552.08 - 7,014.92 7.30% 000-451400 Traffic Fine Costs TTL 28,060 2,136.68 2,462.61 2,136.68 - 25,923.32 7.61% 000-451500 Teen Court Admin Fee 200 - - - - 200.00 0.00% 000-451510 Juvenile Case Mgmt Fee 63,062 4,605.71 5,166.88 4,605.71 - 58,456.29 7.30% 000-451520 Truancy Fee 4,586 806.46 - 806.46 - 3,779.54 17.59% 000-451600 Technology Fund Fee 50,872 3,668.33 4,086.03 3,668.33 - 47,203.67 7.21% 000-451700 Security Fee 38,160 2,751.27 3,064.52 2,751.27 - 35,408.73 7.21% 000-451800 Time Payment Fee - City 8,122 586.22 611.30 586.22 - 7,535.78 7.22% 000-451850 State Fines 10% Service Fee 90,736 - 18,121.14 - - 90,736.00 0.00% 000-451900 DPS Payment - Local 12,053 720.76 668.00 720.76 - 11,332.24 5.98% 000-452000 Child Safety Fee 23,570 3,104.07 2,392.37 3,104.07 - 20,465.93 13.17% 000-452050 Indigent Defense Fee 8,852 - 2,060.44 - - 8,852.00 0.00% 000-452100 Platting Fees 47,500 9,000.00 2,500.00 9,000.00 - 38,500.00 18.95% 000-452200 Site Plan Fee 30,000 - 2,000.00 - - 30,000.00 0.00% 000-452300 Plan Check Fee 400,000 38,612.50 22,889.00 38,612.50 - 361,387.50 9.65% 000-452310 Miscellaneous Review Fee 1,200 - - - - 1,200.00 0.00% 000-452320 Tree Mitigation Admin Fee 10,000 11,595.00 31,312.50 11,595.00 - (1,595.00) 115.95% 000-452400 BOA/Zoning Fees 5,000 - 500.00 - - 5,000.00 0.00% 000-452500 Food Handler Class 20,000 1,020.00 2,120.00 1,020.00 - 18,980.00 5.10% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 000-452520 Fire Training Classes 500 - - - - 500.00 0.00% 000-452600 Specific Use/Zone Chng Fee 25,800 - - - - 25,800.00 0.00% 000-452710 Zoning Ltr & Dev Rights 1,050 300.00 - 300.00 - 750.00 28.57% 000-453100 Reinspection Fees 26,900 4,120.00 2,650.00 4,120.00 - 22,780.00 15.32% 000-453110 Swim Pool Inspection Fee 1,800 - - - - 1,800.00 0.00% 000-453200 Lot Abatement 7,000 - - - - 7,000.00 0.00% 000-453211 Admin Fee-Inspections 6,600 - 1,600.00 - - 6,600.00 0.00% 000-453310 Misc Inspection Fee 3,750 - - - - 3,750.00 0.00% 000-453710 Foster Care 900 - 100.00 - - 900.00 0.00% 000-454200 Pool Gate Admission Fee 23,200 - - - - 23,200.00 0.00% 000-454300 Seasonal Pool Pass Fee 4,900 - - - - 4,900.00 0.00% 000-456110 Senior Center Memberships 2,000 195.00 - 195.00 - 1,805.00 9.75% 000-456120 Senior Center Meal Fee 16,000 1,834.50 - 1,834.50 - 14,165.50 11.47% 000-456500 Haz Mat Fees 12,000 - - - - 12,000.00 0.00% 000-456600 Fire Re-inspection Fee 750 - 100.00 - - 750.00 0.00% 000-458100 Sale of Merchandise - - - - - - 0.00% 000-458110 Sale of Merchandise-GovDeal 5,000 435.01 48.06 435.01 - 4,564.99 8.70% 000-458300 Sale of Property/Auction 2,000 - - - - 2,000.00 0.00% 000-458400 Civic Center Rental Fees 142,000 8,556.75 10,095.25 8,556.75 - 133,443.25 6.03% 000-458401 Capital Recovery Fee-Civic Cntr 5,500 - - - - 5,500.00 0.00% 000-458450 North Center Rental Fees 21,000 2,193.75 1,990.00 2,193.75 - 18,806.25 10.45% 000-458460 Senior Center Rental 7,000 700.00 - 700.00 - 6,300.00 10.00% 000-458500 Community Center Rental Fees 26,000 2,074.50 994.00 2,074.50 - 23,925.50 7.98% 000-458550 Pavilion Rental Fees 17,500 1,700.00 1,680.00 1,700.00 - 15,800.00 9.71% 000-458560 Chamber of Comm rent 7,800 - - - - 7,800.00 0.00% 000-458570 Non-Resident SYSA League 8,000 - - - - 8,000.00 0.00% 000-458650 NonResident User Fee-BVYA 9,500 - 3,210.00 - - 9,500.00 0.00% 000-458660 BVYA Utility Reimbursement 12,500 2,553.37 - 2,553.37 - 9,946.63 20.43% 000-458670 SYSA Utility Reimbursement 1,500 - - - - 1,500.00 0.00% 000-458675 Lions Futbol Utility Reimbursement 14,000 2,344.00 - 2,344.00 - 11,656.00 16.74% 000-458680 Tournament Fees-Soccer 500 - - - - 500.00 0.00% 000-458700 Vehicle Impoundment 8,000 2,300.00 2,470.00 2,300.00 - 5,700.00 28.75% 000-459200 NSF Check Fee 500 - 20.00 - - 500.00 0.00% 000-459300 Notary Fee 300 12.00 36.00 12.00 - 288.00 4.00% 000-459400 Maps, Copies, UDC, & Misc F 100 - - - - 100.00 0.00% 000-459600 Animal Adoption Fee 16,000 1,407.50 805.00 1,407.50 - 14,592.50 8.80% 000-459700 Pet Impoundment Fee 14,000 740.00 1,048.00 740.00 - 13,260.00 5.29% 000-459800 Police Reports Fee 6,000 480.90 382.20 480.90 - 5,519.10 8.02% TOTAL Fees 2,814,366 225,015.16 252,043.26 225,015.16 - 2,589,350.84 8.00% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 Fines 000-463000 Library Fines 30,000 2,384.54 2,756.47 2,384.54 - 27,615.46 7.95% TOTAL Fines 30,000 2,384.54 2,756.47 2,384.54 - 27,615.46 7.95% 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 2,435.90 2,435.90 - 27,564.10 8.12% 000-473300 Guad Co - Library 208,000 - - - - 208,000.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 28,220 - - - - 28,220.00 0.00% 000-474400 Dispatch Service - Cibolo 160,000 - - - - 160,000.00 0.00% 000-474600 School Crossing Guard-Bexar 40,000 3,017.84 2,840.18 3,017.84 - 36,982.16 7.54% 000-474610 School Cross Guard-Guadalupe 38,000 - 2,746.66 - - 38,000.00 0.00% 000-474620 School Crossing Guard-Comal 1,500 - - - - 1,500.00 0.00% 000-474700 School Officer Funding 155,100 - 5,100.00 - - 155,100.00 0.00% TOTAL Inter-Jurisdictional 708,392 7,210.22 14,879.22 7,210.22 - 701,181.78 1.02% Fund Transfers 000-480000 Indirect Costs - EMS 136,087 11,340.58 11,419.83 11,340.58 - 124,746.42 8.33% 000-480100 Indirect Costs - Hotel/Motel 66,405 5,533.75 12,115.42 5,533.75 - 60,871.25 8.33% 000-482150 Transfer From Court Security 27,249 - - - 27,249.00 0.00% 000-485000 Interfund Charge-Drainage 57,130 4,760.83 4,316.67 4,760.83 - 52,369.17 8.33% 000-486000 Interfund Chrges-Admin W&S 1,152,350 96,029.17 96,029.17 96,029.17 - 1,056,320.83 8.33% 000-486202 Transfer In-W&S 40,000 - - - - 40,000.00 0.00% 000-487000 Interfund Charges-Fleet 180,237 15,019.75 10,861.99 15,019.75 - 165,217.25 8.33% 000-488000 Interfund Charges-4B 100,296 8,358.00 11,353.75 8,358.00 - 91,938.00 8.33% TOTAL Fund Transfers 1,759,754 141,042.08 146,096.83 141,042.08 - 1,618,711.92 8.01% 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 4 - 2 0 1 5 **************************************************** C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 Miscellaneous 000-491000 Interest Earned 550 - 22.77 - - 550.00 0.00% 000-491200 Investment Income 26,000 1,973.27 2,444.17 1,973.27 - 24,026.73 7.59% 000-491800 Gain/Loss - - - - - - 0.00% 000-491900 Unrealized Gain/Loss (20,000) 1,196.85 (42.58) 1,196.85 - (21,196.85) 0.00% 000-493120 Donations-Public Library 5,000 - - - - 5,000.00 0.00% 000-493400 Donation - Animal Control 1,000 - 30.73 - - 1,000.00 0.00% 000-493401 Donations-A/C Microchip 1,400 120.00 75.00 120.00 - 1,280.00 8.57% 000-493402 Donations-Spay&Neuter 10,000 1,110.50 627.50 1,110.50 (48.50) 8,938.00 10.62% 000-493403 Donations-Animal Adoption Trailer 9,000 425.00 - 425.00 - 8,575.00 4.72% 000-493465 Donations-Senior Center 12,000 827.10 - 827.10 - 11,172.90 6.89% 000-493502 Donations-PD - - 2,400.00 - - - 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed - - - - - - 0.00% 000-494482 Grants - Police, Fire, Gen Fund - - - - - - 0.00% 000-495060 Grant-Wellmed/Senior Center 3,500 - - - - 3,500.00 0.00% 000-495100 Mobile Stage Rental Fees 2,000 - - - - 2,000.00 0.00% 000-497000 Misc Income-Gen Fund 20,000 928.62 9,462.29 928.62 - 19,071.38 4.64% 000-497005 Schertz Magazine Advertising 220,000 20,405.00 18,575.00 20,405.00 - 199,595.00 9.28% 000-497100 Misc Income-Police 20,000 561.00 396.40 561.00 - 19,439.00 2.81% 000-497200 Misc Income-Library 4,000 549.25 428.00 549.25 - 3,450.75 13.73% 000-497210 Misc Income-Library Copier 14,000 1,702.72 1,337.75 1,702.72 - 12,297.28 12.16% 000-497400 Misc Income-Streets Dept.18,000 1,025.00 3,989.34 1,025.00 - 16,975.00 5.69% 000-497500 Misc Income-TML Insurance 20,000 - - - - 20,000.00 0.00% 000-497550 Misc Income-TML Reimbursemt 20,000 1,354.72 113.73 1,354.72 - 18,645.28 6.77% 000-497600 Misc Income-Vending Mach.2,000 208.03 170.16 208.03 - 1,791.97 10.40% 000-498000 Reimbursmnt-Gen Fund 60,000 - 95.26 - - 60,000.00 0.00% 000-498100 Reimbursmnt Fire - Training 1,000 - - - - 1,000.00 0.00% 000-498105 Reimburmnt Police - DEA 6,200 3,198.67 - 3,198.67 - 3,001.33 51.59% 000-498107 Reimburmnt Police - Event 7,000 - 3,500.00 - - 7,000.00 0.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 5,000 - - - - 5,000.00 0.00% TOTAL Miscellaneous 467,650 35,585.73 43,625.52 35,585.73 (48.50) 432,112.77 7.60% - TOTAL REVENUES 25,699,043 921,050.02 1,636,760.56 7,949,066.39 (48.50) 17,750,025.11 30.93% 17 Cash in Bank Claim on Operating Cash Pool-Checking 273,333.30$ Cash in Investments LOGIC Investment-General Fund 4,256,053.85 LOGIC Investment-Equip Replacement 73,653.28 LOGIC Investment-Veh Replacement 306,680.91 LOGIC Investment-Air Condi Replacment 196,083.12 CAPITAL ONE Investment-General Fund 1,348,783.46 Total Cash in Bank & Investments 6,601,169.76$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 GENERAL FUND 18 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 357,436 2013-14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 20,939 10,460 7,446 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,180 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 ADVALOREM TAX 19 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 495,499 2013-14 481,247 657,271 554,578 416,261 728,443 487,933 541,476 781,057 692,446 448,577 680,332 547,431 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 3% $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 Sales Tax -General Fund 20 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 133,486 115,592 176,520 213,412 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 $- $50,000 $100,000 $150,000 $200,000 $250,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 106,125.00 - - - - 106,125.00 0.00% Wilenchik Walk for Life 25,000.00 - - - - 25,000.00 0.00% Hal Baldwin Scholarship 18,750.00 - 8,175.00 10,375.00 - 8,375.00 0.00% Miscellaneous 3,925.00 10,376.28 6,727.10 1.28 - 3,923.72 0.02% TOTAL REVENUES 153,800.00 10,376.28 14,902.10 10,376.28 - 143,423.72 4.60% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,850.00 - - - - 10,850.00 0.00% TOTAL GENERAL GOVERNMENT 10,850.00 - - - - 10,850.00 0.00% CULTURAL Festival of Angels 15,000.00 - 517.73 - 317.50 14,682.50 2.12% Employee Appreciation Event 15,000.00 - - - - 15,000.00 0.00% National Night Out 200.00 - - - - 200.00 0.00% Wilenchik Walk for Life 25,000.00 - - - - 25,000.00 0.00% Schertz Sweetheart 35,000.00 - - - - 35,000.00 0.00% Jazzfest 20,000.00 - - - - 20,000.00 0.00% Hal Baldwin Scholarship 18,750.00 - 150.00 - - 18,750.00 0.00% Other Events 14,000.00 2,000.00 - 2,000.00 77.23 11,922.77 14.84% TOTAL CULTURAL 142,950.00 2,000.00 667.73 2,000.00 394.73 140,555.27 1.68% TOTAL EXPENDITURES 153,800.00 2,000.00 667.73 2,000.00 394.73 151,405.27 1.56% REVENUE OVER(UNDER) EXPEND - 8,376.28 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 22 Cash in Bank Claim on Operating Cash Pool-Checking 108,670.76$ Cash in Investments Texas Class- Special Events 16,785.16 Total Cash in Bank & Investments 125,455.92$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 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 119,572.00 39,700.19 - 39,700.19 - 79,871.81 33.20% Fund Transfers 89,428.00 - - - - 89,428.00 0.00% TOTAL REVENUES 209,000.00 39,700.19 - 39,700.19 - 169,299.81 19.00% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 209,000.00 - 6,340.98 - 2,762.70 206,237.30 1.32% TOTAL GENERAL GOVERNMENT 209,000.00 - 6,340.98 - 2,762.70 206,237.30 1.32% TOTAL EXPENDITURES 209,000.00 - 6,340.98 - 2,762.70 206,237.30 1.32% REVENUE OVER(UNDER) EXPEND - 39,700.19 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 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 78,772 - - - - 78,772.00 0.00% 000-421465 AT&T PEG Fee 40,800 39,700.19 - 39,700.19 - 1,099.81 97.30% TOTAL Franchises 119,572 39,700 - 39,700.19 - 79,871.81 33.20% Fund Transfers 000-481000 Transfer In - Reserves 89,428 - - - - 89,428.00 0.00% TOTAL Fund Transfers 89,428 - - - - 89,428.00 0.00% TOTAL REVENUES 209,000 39,700.19 - 39,700.19 - 169,299.81 19.00% C I T Y O F S C H E R T Z ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 25 Cash in Bank Cash Balance 475,075.65$ Total Cash in Bank & Investments 475,075.65$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 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 211,813 - - - - 211,813.00 0.00% Permits 60,000.00 10,670.37 15,982.04 10,670.37 - 49,329.63 17.78% Fees 17,169,500 1,442,921.83 1,334,801.41 1,442,921.83 - 15,726,578.17 8.40% Fund Transfers 276,425 11,426.08 10,359.67 11,426.08 - 264,998.92 4.13% Miscellaneous 142,940 3,258.61 142,199.75 3,258.61 - 139,681.39 2.28% TOTAL REVENUES 17,860,678 1,468,276.89 1,503,342.87 1,468,276.89 - 16,392,401.11 8.22% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 446,006 24,895.92 22,700.89 24,895.92 - 421,110.08 5.58% Supplies 4,600 43.96 - 43.96 434.79 4,121.25 10.41% Human Services 183 - - - - 183.00 0.00% City Support Services 24,098 831.00 - 831.00 - 23,267.00 3.45% Utility Services 170 - - - - 170.00 0.00% Operations Support 123,000 10,000.00 10,095.03 10,000.00 - 113,000.00 8.13% Staff Support 7,300 42.56 50.00 42.56 43.30 7,214.14 1.18% Professional Services 62,000 - 1,849.23 - - 62,000.00 0.00% Maintenance Services 13,440 520.00 - 520.00 4,520.00 8,400.00 37.50% Operating Equipment 1,550 - - - - 1,550.00 0.00% TOTAL BUSINESS OFFICE 682,347 36,333.44 34,695.15 36,333.44 4,998.09 641,015.47 6.06% W & S ADMINISTRATION Personnel Services 1,223,136 72,347.17 70,559.62 72,347.17 - 1,150,788.83 5.91% Supplies 195,150 992.69 907.80 992.69 2,576.57 191,580.74 1.83% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 150,103 35,027.56 30,763.26 35,027.56 - 115,075.44 23.34% Utility Services 3,454,440 226,338.39 223,386.11 226,338.39 702.22 3,227,399.39 6.57% Operations Support 9,250 18.24 239.49 18.24 6.49 9,225.27 0.27% Staff Support 31,150 335.18 430.84 335.18 612.40 30,202.42 3.04% City Assistance 1,900 - - - - 1,900.00 0.00% Professional Services 249,113 12,350.12 2,218.64 12,350.12 - 236,762.88 4.96% Fund Charges/Transfers 3,594,442 135,574.18 452,226.61 135,574.18 - 3,458,867.82 3.77% Maintenance Services 6,496,250 195,233.86 232,208.93 195,233.86 2,340.29 6,298,675.85 3.04% Other Costs 35,000 - - - - 35,000.00 0.00% ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 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 4 - 2 0 1 5 ****************************************************** C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 Debt Service 1,534,512 - - - - 1,534,512.00 0.00% Rental-Leasing 6,070 - - - 125.00 5,945.00 2.06% Operating Equipment 21,200 - - - 1,899.98 19,300.02 8.96% Capital Outlay 103,500 - - - - 103,500.00 0.00% TOTAL PUBLIC WORKS 17,106,216 678,217.39 1,012,941.30 678,217.39 8,262.95 16,419,735.66 4.01% TOTAL EXPENDITURES 17,788,563 714,551 1,047,636 714,551 13,261 17,060,751 4.09% ** REVENUE OVER(UNDER)EXPENSES **72,115 753,726.06 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 211,813 - - - - 211,813.00 0.00% TOTAL Franchises 211,813 - - - - 211,813.00 0.00% Permits 000-432400 Development Permit 60,000 10,670.37 15,982.04 10,670.37 - 49,329.63 17.78% TOTAL Permits 60,000 10,670.37 15,982.04 10,670.37 - 49,329.63 17.78% Fees 000-455200 Garbage Collection Fee 4,000,000 347,637.31 331,080.31 347,637.31 - 3,652,362.69 8.69% 000-455600 Fire Line Fees 25,000 3,565.00 3,620.00 3,565.00 - 21,435.00 14.26% 000-455700 Recycle Fee Revenue 270,000 22,514.93 21,267.10 22,514.93 - 247,485.07 8.34% 000-455800 W&S Line Constructn Reimbursemnt 25,000 2,480.00 1,240.00 2,480.00 - 22,520.00 9.92% 000-457100 Sale of Water 8,100,000 699,535.23 638,256.80 699,535.23 - 7,400,464.77 8.64% 000-457110 Edwards Water Lease 127,000 - - - - 127,000.00 0.00% 000-457120 Water Transfer Charge-Selma 42,000 - 11,244.80 - - 42,000.00 0.00% 000-457130 Water Transfer Charge-U. C. 8,000 - 6,704.32 - - 8,000.00 0.00% 000-457140 Water Transfer Charge-Converse 30,000 - 3,844.80 - - 30,000.00 0.00% 000-457200 Sale of Meters 90,000 7,053.38 3,662.00 7,053.38 - 82,946.62 7.84% 000-457400 Sewer Charges 4,250,000 339,121.46 293,406.25 339,121.46 - 3,910,878.54 7.98% 000-457500 Water Penalties 200,000 20,589.52 15,520.03 20,589.52 - 179,410.48 10.29% 000-458110 Sale of Merchandise - Gov Deals - - - - - - 0.00% 000-458400 Building rental Fee - - 4,800.00 - - - 0.00% 000-459200 NSF Check Fee-Water&Sewer 2,500 425.00 155.00 425.00 - 2,075.00 17.00% TOTAL Fees 17,169,500 1,442,921.83 1,334,801.41 1,442,921.83 - 15,726,578.17 8.40% Fund Transfers 000-486204 Interfnd Chrg-Drainage Bill 137,113 11,426.08 10,359.67 11,426.08 - 125,686.92 8.33% 000-486411 Transfer In-Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 276,425 11,426.08 10,359.67 11,426.08 - 264,998.92 4.13% ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** AS OF: OCTOBER 31st, 2014 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 4 - 2 0 1 5 ****************************************************** AS OF: OCTOBER 31st, 2014 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 700 - 205.00 - - 700.00 0.00% 000-491000 Interest Earned 1,500 61.07 126.51 61.07 - 1,438.93 4.07% 000-491200 Investment Income 10,000 248.60 268.91 248.60 - 9,751.40 2.49% 000-496050 SSLG - SAWS Reservation - - 134,500.00 - - - 0.00% 000-497000 Misc Income-W&S 20,000 2,948.94 7,023.37 2,948.94 - 17,051.06 14.74% 000-498110 Reimbursement-SSLGC 110,740 - - - - 110,740.00 0.00% 000-498300 Reimbursement-City Property - - 75.96 - - - 0.00% TOTAL Miscellaneous 142,940 3,258.61 142,199.75 3,258.61 - 139,681.39 2.28% TOTAL REVENUES 17,860,678 1,468,276.89 1,503,342.87 1,468,276.89 - 16,392,401.11 8.22% 30 Cash in Bank Claim on Operating Cash Pool-Checking 1,110,505.34$ Cash in Investments Lone Star Investment-Water&Sewer 638,914.36 Lone Star Investment-W&S Customer Deposits 295,353.57 Lone Star Investment-W&S Equip Replacement 177,580.41 Lone Star Investment-W&S Veh Replacement 256,531.08 Lone Star Investment-Water/SSLGC SAWS 809,920.89 Schertz Bank & Trust-Certificate of Deposit 1,064,372.78 3,242,673.09$ Total Cash in Bank & Investments 4,353,178.43$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 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 6,416,343 420,240.86 418,542.27 420,240.86 - 5,996,102.14 6.55% Inter-Jurisdictional 1,601,076 - 8,741.98 - - 1,601,076.00 0.00% Miscellaneous 169,500 11,902.63 18,584.80 11,902.63 - 157,597.37 7.02% TOTAL REVENUES 8,186,919 432,143.49 445,869.05 432,143.49 - 7,754,775.51 5.28% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,036,899 192,827.74 183,567.05 192,827.74 - 2,844,071.26 6.35% Supplies 378,284 365.75 3,651.44 365.75 57,630.57 320,287.68 15.33% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 110,052 14,617.51 17,826.32 14,617.51 - 95,434.49 13.28% Utility Services 154,500 970.47 1,821.99 970.47 - 153,529.53 0.63% Operations Support 62,555 444.38 23,257.36 444.38 240.00 61,870.62 1.09% Staff Support 85,786 354.38 1,354.00 354.38 19,428.20 66,003.42 23.06% City Assistance 11,900 - - - 170.94 11,729.06 1.44% Professional Services 147,080 24,746.93 16,511.86 24,072.06 4,009.69 118,998.25 19.09% Fund Charges/Transfers 3,366,084 11,963.07 34,705.31 19,063.07 - 3,347,020.93 0.57% Maintenance Services 59,500 - 450.00 - 860.00 58,640.00 1.45% Debt Service 270,820 - - - - 270,820.00 0.00% Rental-Leasing 81,541 - - - - 81,541.00 0.00% Operating Equipment 281,500 5,795.07 - 5,795.07 95,440.14 180,264.79 35.96% Capital Outlay 104,000 - - - - 104,000.00 0.00% TOTAL PUBLIC SAFETY 8,151,501 252,085.30 283,145.33 258,510.43 177,779.54 7,715,211.03 5.35% TOTAL EXPENDITURES 8,151,501 252,085.30 283,145.33 258,510.43 177,779.54 7,715,211.03 5.35% ** REVENUE OVER(UNDER) EXPENSES **35,418 173,633.06 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 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 6,249,943 415,363.67 416,171.52 415,363.67 - 5,834,579.33 6.65% 000-456110 Subscription Program Fees 40,000 60.00 335.00 60.00 - 39,940.00 0.15% 000-456120 EMT Class - Fees 104,400 3,254.95 300.00 3,254.95 - 101,145.05 3.12% 000-456130 Immunization Fees - - - - - - 0.00% 000-456140 Billing Fees - Alamo Heights 22,000 1,407.24 1,710.75 1,407.24 - 20,592.76 6.40% 000-458110 Sales of Merchandise - GovDeal - 155.00 - 155.00 - (155.00) 0.00% 000-459200 NSF Check Fee - - 25.00 - - - 0.00% TOTAL Fees 6,416,343 420,240.86 418,542.27 420,240.86 - 5,996,102.14 6.55% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 286,126 - - - - 286,126.00 0.00% 000-474300 Cibolo Support 261,370 - - - - 261,370.00 0.00% 000-475100 Comal Co ESD #6 95,217 - 7,590.70 - - 95,217.00 0.00% 000-475200 Live Oak Support 179,608 - - - - 179,608.00 0.00% 000-475300 Universal City Support 247,353 - - - - 247,353.00 0.00% 000-475400 Selma Support 73,952 - - - - 73,952.00 0.00% 000-475500 Schertz Support 433,542 - - - - 433,542.00 0.00% 000-475600 Santa Clara Support 9,678 - - - - 9,678.00 0.00% 000-475800 Marion Support 14,230 - 1,151.28 - - 14,230.00 0.00% TOTAL Inter-Jurisdictional 1,601,076 - 8,741.98 - - 1,601,076.00 0.00% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 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, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** Miscellaneous 000-491000 Interest Earned - 11.08 - 11.08 - (11.08) 0.00% 000-493203 Donations-EMS 2,000 - - - - 2,000.00 0.00% 000-493204 Donations-Dilworth Fund 3,500 - - - - 3,500.00 0.00% 000-493205 Donations- Golf Tournament 9,000 - - - - 9,000.00 0.00% 000-497000 Misc Income 145,000 11,791.55 17,875.50 11,791.55 - 133,208.45 8.13% 000-497100 Recovery of Bad Debt 10,000 100.00 709.30 100.00 - 9,900.00 2.75% TOTAL Miscellaneous 169,500 11,902.63 18,584.80 11,902.63 - 157,597.37 7.02% TOTAL REVENUES 8,186,919 432,143.49 445,869.05 432,143.49 - 7,754,775.51 5.28% 34 Cash in Bank Claim on Operating Cash Pool-Checking 96,777.00$ Total Cash in Bank & Investments 96,777.00$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 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 3,000 240.00 220.00 240.00 - 2,760.00 0.00% Fees 1,155,500 89,462.68 87,356.40 89,462.68 - 1,066,037.32 13.48% Miscellaneous 700 69.13 150.29 69.13 - 630.87 4.40% TOTAL REVENUES 1,159,200 89,771.81 87,726.69 89,771.81 - 1,069,428.19 13.50% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 453,529 27,329.10 25,888.16 27,329.10 - 426,199.90 6.03% Supplies 8,300 80.41 105.98 80.41 620.98 7,598.61 8.45% Human Services 325 - - - - 325.00 0.00% City Support Services 30,432 2,306.64 2,166.61 2,306.64 - 28,125.36 7.58% Utility Services 30,370 553.94 40.98 553.94 749.13 29,066.93 4.29% Operations Support 2,460 - - - 20.48 2,439.52 0.83% Staff Support 8,116 153.70 227.43 153.70 189.68 7,772.62 4.23% City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 - - - - 23,500.00 0.00% Fund Charges/Transfers 221,818 18,401.49 16,375.34 18,401.49 - 203,416.51 8.30% Maintenance Services 22,000 - - - 68.00 21,932.00 0.31% Other costs 200 - - - - 200.00 0.00% Debt Service 140,530 - - - - 140,530.00 0.00% Rental/Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 - - - - 5,500.00 0.00% Capital Outlay - - - - - - 0.00% TOTAL DRAINAGE 948,420 48,825.28 44,804.50 48,825.28 1,648.27 897,946.45 5.32% PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 - - - - 1,000.00 0.00% Professional Services 4,000 - - - 8,000.00 (4,000.00) 200.00% Maintenance Services 137,998 3,287.67 - 3,287.67 303.59 134,406.74 2.60% TOTAL PROJECTS 146,198 3,287.67 - 3,287.67 8,303.59 134,606.74 7.93% TOTAL EXPENDITURES 1,094,618 52,112.95 44,804.50 52,112.95 9,951.86 1,032,553.19 5.67% ** REVENUE OVER(UNDER) EXPEND 64,582 37,658.86 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 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 3,000 240.00 220.00 240.00 - 2,760.00 8.00% TOTAL Permits 3,000 240.00 220.00 240.00 - 2,760.00 8.00% Fees 000-457500 Drainage Penalties 8,000 779.89 569.54 779.89 - 7,220.11 9.75% 000-457600 Drainage Fee 1,147,500 88,682.79 86,786.86 88,682.79 - 1,058,817.21 7.73% TOTAL Fees 1,155,500 89,462.68 87,356.40 89,462.68 - 1,066,037.32 7.74% Miscellaneous 000-491000 Interest Earned 100 - 11.91 - - 100.00 0.00% 000-491200 Investment Interest 500 69.13 78.38 69.13 - 430.87 13.83% 000-497000 Misc Income-Drainage 100 - 60.00 - - 100.00 0.00% TOTAL Miscellaneous 700 69.13 150.29 69.13 - 630.87 9.88% TOTAL REVENUES 1,159,200 89,771.81 87,726.69 89,771.81 - 1,069,428.19 7.74% C I T Y O F S C H E R T Z *********************************************** 2 0 1 4 - 2 0 1 5 ************************************************* REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 37 Cash in Bank Claim on Operating Cash Pool-Checking 506,012.81 Cash in Investments Lone Star Investment-Drainage Maint Fund 605,787.99 Total Cash in Bank & Investments 1,111,800.80$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 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 544,753 28,636.64 - 28,636.64 - 516,116.36 5.26% Miscellaneous 600 24.18 31.69 24.18 - 575.82 4.03% TOTAL REVENUES 545,353 28,660.82 31.69 28,660.82 - 516,692.18 5.26% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - - - - 2,500.00 0.00% City Support Services 61,500 - 20,407.50 - - 61,500.00 0.00% Operations Support 69,500 - 500.00 - 400.00 69,100.00 0.58% Professional Services 5,825 - - - - 5,825.00 0.00% Fund Charges/Transfers 126,405 5,533.75 12,115.42 5,533.75 - 120,871.25 4.38% Maintenance Services - - - - - - 0.00% Operating Equipment 37,000 - - - 1,712.60 35,287.40 4.63% TOTAL NONDEPARTMENTAL 302,730 5,533.75 33,022.92 5,533.75 2,112.60 295,083.65 2.53% TOTAL EXPENDITURES 302,730 5,533.75 33,022.92 5,533.75 2,112.60 295,083.65 2.53% REVENUE OVER(UNDER) EXPENDITURE 242,623 23,127.07 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 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 544,753 28,636.64 - 28,636.64 - 516,116.36 5.26% TOTAL Taxes 544,753 28,636.64 - 28,636.64 - 516,116.36 5.26% Miscellaneous 000-491000 Interest Earned 100 - 8.12 - - 100.00 0.00% 000-491200 Investment Interest 500 24.18 23.57 24.18 - 475.82 4.84% TOTAL Miscellaneous 600 24.18 31.69 24.18 - 575.82 4.03% TOTAL REVENUES 545,353 28,660.82 31.69 28,660.82 - 516,692.18 5.26% C I T Y O F S C H E R T Z *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 40 Cash in Bank Claim on Operating Cash Pool-Checking 158,963.47$ Cash in Investments MBIA - Hotel Tax 299,211.02 Total Cash in Bank & Investments 458,174.49$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 HOTEL OCCUPANCY TAX FUND 41 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2013-14 40,023 40,709 33,342 29,778 36,680 56,699 48,081 49,579 54,858 67,329 57,399 34,297 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 $80,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 100,000 - - - - 100,000.00 0.00% Miscellaneous - 0.04 1.10 0.04 - (0.04) 0.00% TOTAL REVENUES 100,000 0.04 1.10 0.04 - 99,999.96 0.00% EXPENDITURE SUMMARY PARKLAND DEDICATION Maintenance Services-Landscape - - - - - - 0.00% Capital Outlay 60,000 - - - - 60,000.00 0.00% TOTAL PARKLAND DEDICATION 60,000 - - - - 60,000.00 0.00% TOTAL EXPENDITURES 60,000 - - - - 60,000.00 0.00% REVENUE OVER(UNDER) EXPEND 40,000 0.04 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 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 100,000 - - - - 100,000.00 0.00% TOTAL Fees 100,000 - - - - 100,000.00 0.00% Miscellaneous 000-491000 Interest Earned - - 0.36 - - - 0.00% 000-491200 Investment Interest - 0.04 0.74 0.04 - (0.04) 0.00% 000-497000 Misc Income - - - - - - 0.00% TOTAL Miscellaneous - 0.04 1.10 0.04 - (0.04) 0.00% TOTAL REVENUES 100,000 0.04 1.10 0.04 - 99,999.96 0.00% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 44 Cash in Bank Claim on Operating Cash Pool-Checking $190,771.26 Cash in Investments Texas Class- Park Fund 1,354.72 Total Cash in Bank & Investments $192,125.98 CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 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 36,000 63,605.00 177,437.50 63,605.00 - (27,605.00) 176.68% Fund Transfers 80,125 - - - - 80,125 0.00% Miscellaneous 210 7.79 15.66 7.79 - 202.21 3.71% TOTAL REVENUES 116,335 63,612.79 177,453.16 63,612.79 - 52,722.21 54.68% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 116,125 - - - 24,600.00 91,525.00 21.18% TOTAL TREE MITIGATION 116,125 - - - 24,600.00 91,525.00 21.18% TOTAL EXPENDITURES 116,125 - - - 24,600.00 91,525.00 21.18% REVENUE OVER(UNDER) EXPEND 210 63,612.79 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 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 36,000 63,605.00 177,437.50 63,605.00 - (27,605.00) 176.68% TOTAL Fees 36,000 63,605.00 177,437.50 63,605.00 - (27,605.00) 176.68% Fund Transfers 000-481000 Transfer In - Reserves 80,125 - - - - 80,125.00 0.00% TOTAL Fund Transfers 80,125 - - - - 80,125.00 0.00% Miscellaneous 000-491000 Interest Earned 90 - 8.03 - - 90.00 0.00% 000-491200 Investment Interest 120 7.79 7.63 7.79 - 112.21 6.49% TOTAL Miscellaneous 210 7.79 15.66 7.79 - 202.21 3.71% TOTAL REVENUES 116,335 63,612.79 177,453.16 63,612.79 - 52,722.21 54.68% C I T Y O F S C H E R T Z ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 47 Cash in Bank Claim on Operating Cash Pool-Checking $325,411.06 Cash in Investments MBIA Investment-Tree Mitigation 97,347.13 Total Cash in Bank & Investments $422,758.19 CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 TREE MITIGATION FUND 48 411-CAPITAL RECOVERY WATER 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 880,200 111,492.00 46,944.00 111,492.00 - 768,708.00 12.67% Fund Transfers - - - - - - 0.00% Miscellaneous 5,300 421.50 498.81 421.50 - 4,878.50 7.95% TOTAL REVENUES 885,500 111,913.50 47,442.81 111,913.50 - 773,586.50 12.64% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 - - - - 109.00 0.00% Professional Services 80,000 - - - - 80,000.00 0.00% Maintenance Services 1,000 - - - - 1,000.00 0.00% Capital Outlay 450,000 - - - - 450,000.00 0.00% TOTAL NON DEPARTMENTAL 536,109 - - - - 536,109.00 0.00% TOTAL EXPENDITURES 536,109 - - - - 536,109.00 0.00% REVENUE OVER(UNDER) EXPENDITURES 349,391 111,914 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 49 411-CAPITAL RECOVERY WATER 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 111,492.00 46,944.00 111,492.00 - 768,708.00 12.67% TOTAL Fees 880,200 111,492.00 46,944.00 111,492.00 - 768,708.00 12.67% Miscellaneous 000-491000 Interest Earned 300 - 20.92 - - 300.00 0.00% 000-491200 Investment Income 5,000 421.50 477.89 421.50 - 4,578.50 8.43% TOTAL Miscellaneous 5,300 421.50 498.81 421.50 - 4,878.50 7.95% TOTAL REVENUES 885,500 111,913.50 47,442.81 111,913.50 - 773,586.50 12.64% C I T Y O F S C H E R T Z **************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 50 Cash in Bank Claim on Operating Cash Pool-Checking 1,238,800.79$ Cash in Investments Lone Star Investment-Capital Recovery Water 3,693,453.58 Total Cash in Bank & Investments 4,932,254.37$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 CAPITAL RECOVERY WATER 51 421-CAPITAL RECOVERY SEWER 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 600,400 51,972.00 33,756.00 51,972.00 - 548,428.00 8.66% Fund Transfers 559,497 - - - - 559,497.00 0.00% Miscellaneous 600 2,530.36 2,529.94 2,530.36 - (1,930.36) 421.73% TOTAL REVENUES 1,160,497 54,502.36 36,285.94 54,502.36 - 1,105,994.64 4.70% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,143 358.01 356.12 358.01 - 2,784.99 11.39% Fund Charges/Transfers 139,312 - - - - 139,312.00 0.00% TOTAL NON DEPARTMENTAL 142,455 358.01 356.12 358.01 - 142,096.99 0.25% MISC & PROJECTS Sewer Projects 1,018,042 - - - - 1,018,042.00 0.00% TOTAL MISC & PROJECTS 1,018,042 - - - - 1,018,042.00 0.00% TOTAL EXPENDITURES 1,160,497 358.01 356.12 358.01 - 1,160,138.99 0.03% REVENUE OVER(UNDER) EXPENDITURES - 54,144 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 52 421-CAPITAL RECOVERY SEWER 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-455910 Capital Recovery - Waste Wtr 500,400 48,372.00 28,356.00 48,372.00 - 452,028.00 9.67% 000-455913 Cap Recovery-North Sewer Tr 100,000 3,600.00 5,400.00 3,600.00 - 96,400.00 3.60% TOTAL Fees 600,400 51,972.00 33,756.00 51,972.00 - 548,428.00 8.66% Fund Transfers 000-481000 Transfer from Reserves 559,497 - - - - 559,497.00 0.00% TOTAL Fund Transfers 559,497 - - - - 559,497.00 0.00% Miscellaneous 000-491000 Interest Earned 100 - 8.48 - - 100.00 0.00% 000-491200 Investment Income 500 2,297.76 3,576.91 2,297.76 - (1,797.76) 459.55% 000-491800 Gain/Loss - - (9,144.38) - - - 0.00% 000-491900 Unrealized Gain/Loss-Cap One - 232.60 8,088.93 232.60 - (232.60) 0.00% TOTAL Miscellaneous 600 2,530.36 2,529.94 2,530.36 - (1,930.36) 421.73% TOTAL REVENUES 1,160,497 54,502.36 36,285.94 54,502.36 - 1,105,994.64 4.70% C I T Y O F S C H E R T Z **************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 53 Cash in Bank Claim on Operating Cash Pool-Checking 722,417.73$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,451,848.38 Capital One-Investment 1,727,965.92 Total Cash in Bank & Investments 3,902,232.03$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 CAPITAL RECOVERY SEWER 54 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,338,513 208,158.24 231,403.00 208,158.24 - 5,130,354.76 3.90% Miscellaneous 368,763 52.45 38.34 52.45 - 368,710.55 0.01% TOTAL REVENUES 5,707,276 208,210.69 231,441.34 208,210.69 - 5,499,065.31 3.65% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 400.00 - 400.00 - 41,950.00 0.94% Debt Service 5,593,807 - - - - 5,593,807.00 0.00% TOTAL GENERAL GOVERNMENT 5,636,157 400.00 - 400.00 - 5,635,757.00 0.01% TOTAL EXPENDITURES 5,636,157 400.00 - 400.00 - 5,635,757.00 0.01% ** REVENUE OVER(UNDER) EXPEND 71,119 207,810.69 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 ****************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 55 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,338,513 208,158.24 231,403.00 208,158.24 - 5,130,354.76 3.90% TOTAL Taxes 5,338,513 208,158.24 231,403.00 208,158.24 - 5,130,354.76 3.90% Miscellaneous 000-491000 Interest Earned 75 - 6.92 - - 75.00 0.00% 000-491200 Investment Earnings 1,500 52.45 31.42 52.45 - 1,447.55 3.50% 000-495015 Contribution from SED 367,188 - - - - 367,188.00 0.00% TOTAL Miscellaneous 368,763 52.45 38.34 52.45 - 368,710.55 0.01% TOTAL REVENUES 5,707,276 208,210.69 231,441.34 208,210.69 - 5,499,065.31 3.65% C I T Y O F S C H E R T Z ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** REVENUE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 56 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 400.00 - 400.00 - 1,950.00 17.02% 101-541502 Cost of Bond Issuance 40,000 - - - - 40,000.00 0.00% TOTAL Professional Services 42,350 400.00 - 400.00 - 41,950.00 0.94% Debt Service 101-555612 Bond-GO Refunding 2010-Principal 265,000 - - - - 265,000.00 0.00% 101-555612.1 Bond-GO Refunding 2010 Interest 63,525 - - - - 63,525.00 0.00% 101-555626 LS&D SR2006-Principal 350,000 - - - - 350,000.00 0.00% 101-555626.1 LS&D SR2006-Interest 204,419 - - - - 204,419.00 0.00% 101-555628 CO Bond 2007-Principal 116,134 - - - - 116,134.00 0.00% 101-555628.1 CO Bond 2007-Interest 9,582 - - - - 9,582.00 0.00% 101-555629 GO Bond 2007-Principal 255,000 - - - - 255,000.00 0.00% 101-555629.1 GO Bond 2007-Interest 169,618 - - - - 169,618.00 0.00% 101-555630 GO Bond SR2008 Principal 420,000 - - - - 420,000.00 0.00% 101-555630.1 GO Bond SR2008 Interest 314,706 - - - - 314,706.00 0.00% 101-555631 GO Bond SR2009 Principal 535,000 - - - - 535,000.00 0.00% 101-555631.1 BO Bond SR2009 Interest 298,800 - - - - 298,800.00 0.00% 101-555633 GO SR2011 Principal 220,000 - - - - 220,000.00 0.00% 101-555633.1 GO SR2011 Interest 349,438 - - - - 349,438.00 0.00% 101-555634 GO SR2011A Refund Principal 610,000 - - - - 610,000.00 0.00% 101-555634.1 GO SR2011A Refund Interest 130,830 - - - - 130,830.00 0.00% 101-555635 GO SR2012 Principal 295,000 - - - - 295,000.00 0.00% 101-555635.1 GO SR2012 Interest 206,444 - - - - 206,444.00 0.00% 101-555636 Tax Note - SR2013 - Principal 165,000 - - - - 165,000.00 0.00% 101-555636.1 Tax Note - SR2013 - Interest 7,543 - - - - 7,543.00 0.00% 101-555637 Tax Note - SR 2013A - Principal 160,000 - - - - 160,000.00 0.00% 101-555637.1 Tax Note - SR2013 - Interest 7,345 - - - - 7,345.00 0.00% 101-555638 Bond-GO 2014 Refund-Principal 50,000 - - - - 50,000.00 0.00% 101-555638.1 Bond-GO 2014 Refund-Interest 358,322 - - - - 358,322.00 0.00% 101-555900 Debt Service 32,101 - - - - 32,101.00 0.00% TOTAL Debt Service 5,593,807 - - - - 5,593,807.00 0.00% TOTAL EXPENDITURES 5,636,157 400.00 - 400.00 - 5,635,757.00 0.01% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** 57 Cash in Bank Claim on Operating Cash Pool-Checking (134,035.38)$ Cash in Investments MBIA Investment- Tax I&S 1,001,021.33 Total Cash in Bank & Investments 866,985.95$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 TAX I&S 58 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,682,057 254,157.74 278,898.10 254,157.74 - 3,427,899.26 6.90% Miscellaneous 10,200 498.53 348.17 498.53 - 9,701.47 4.89% TOTAL REVENUES 3,692,257 254,656.27 279,246.27 254,656.27 - 3,437,600.73 6.90% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 364,312 16,861.50 18,182.27 16,861.50 - 347,450.50 4.63% Supplies 1,050 - - - - 1,050.00 0.00% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 16,545 1,114.09 1,174.29 1,114.09 - 15,430.91 6.73% Utility Services 4,120 17.50 52.58 17.50 - 4,102.50 0.42% Operations Support 147,145 49,500.00 49,839.95 49,500.00 131.51 97,513.49 33.73% Staff Support 18,250 148.32 350.00 148.32 - 18,101.68 0.81% City Assistance 1,025,000 - - - - 1,025,000.00 0.00% Professional Services 92,500 - - - - 92,500.00 0.00% Fund Charges/Transfers 471,280 8,674.33 11,455.58 8,674.33 - 462,605.67 1.84% Debt Service 430,608 - - - - 430,608.00 0.00% Operating Equipment 2,000 - - - - 2,000.00 0.00% TOTAL ECONO DEVELOPMENT 2,573,810 76,315.74 81,054.67 76,315.74 131.51 2,497,362.75 2.97% MISC & PROJECTS PROJECTS 450,000 - - - - 450,000.00 0.00% TOTAL MISC & PROJECTS 450,000 - - - 450,000.00 0.00% TOTAL EXPENDITURES 3,023,810 76,315.74 81,054.67 76,315.74 131.51 2,947,362.75 2.53% ** REVENUE OVER(UNDER) EXPEND 668,447 178,340.53 C I T Y O F S C H E R T Z ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: OCTOBER 31st, 2014 59 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,682,057 254,157.74 278,898.10 254,157.74 - 3,427,899.26 6.90% TOTAL Taxes 3,682,057 254,157.74 278,898.10 254,157.74 - 3,427,899.26 6.90% Miscellaneous 000-491000 Interest Earned 200 18.99 23.44 18.99 - 181.01 9.50% 000-491200 Investment Earnings 10,000 479.54 324.73 479.54 - 9,520.46 4.80% TOTAL Miscellaneous 10,200 498.53 348.17 498.53 - 9,701.47 4.89% TOTAL REVENUES 3,692,257 254,656.27 279,246.27 254,656.27 - 3,437,600.73 6.90% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** AS OF: OCTOBER 31st, 2014 60 Cash in Bank Claim on Operating Cash Pool-Checking 145,127.96$ Cash in Investments Texas Class Investment-Economic Development Corp 6,217,338.74 Schertz Bank & Trust-Certificate of Deposit 1,044,185.44 Total Cash in Bank & Investments 7,406,652.14$ CASH IN BANK AND INVESTMENTS AS OF: OCTOBER 31st, 2014 SED CORPORATION 61 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 247,750 319,452 2013-14 240,623 328,635 277,289 208,130 364,222 243,967 270,738 390,528 346,223 224,288 340,166 273,715 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 3.0% -2.8% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 4B SALES TAX 62 INVESTMENT REPORT C I T Y O F S C H E R T Z FOR MONTH ENDING OCTOBER 31st, 2014 63 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 7,875,162.00 0.0500 4,915,568.30 5,208,691.74 335.02 7,582,373.58 7,582,373.58 7,582,373.58 N/A Schertz Bank & Trust - PEG Fund 425,863.99 0.0000 39,700.19 - - 465,564.18 465,564.18 465,564.18 N/A TOTAL OPERATIONS 8,301,025.99 4,955,268.49 5,208,691.74 335.02 8,047,937.76 8,047,937.76 8,047,937.76 - LOGIC General Fund 4,955,687.32 0.0879 - 700,000.00 366.53 4,256,053.85 4,256,053.85 4,256,053.85 N/A 56 Days G/F-Equipment Replacement 73,647.80 0.0879 - - 5.48 73,653.28 73,653.28 73,653.28 N/A 56 Days G/F-Vehicle Replacement 306,658.02 0.0879 - - 22.89 306,680.91 306,680.91 306,680.91 N/A 56 Days G/F-Air Conditioner Replacement 196,068.48 0.0879 - - 14.64 196,083.12 196,083.12 196,083.12 N/A 56 Days SR2009 Bond-Street Projects(II)1,030,150.32 0.0879 - - 76.90 1,030,227.22 1,030,227.22 1,030,227.22 N/A 56 Days TOTAL LOGIC 6,562,211.94 - 700,000.00 486.44 5,862,698.38 5,862,698.38 5,862,698.38 - LONESTAR Capital Recovery - Sewer 1,451,682.69 0.1300 - - 165.69 1,451,848.38 1,451,848.38 1,451,848.38 N/A 82 Days Capital Recovery - Water 3,693,032.08 0.1300 - - 421.50 3,693,453.58 3,693,453.58 3,693,453.58 N/A 82 Days Drainage Fund 605,718.86 0.1300 - - 69.13 605,787.99 605,787.99 605,787.99 N/A 82 Days Facilities Master Plan 95,132.66 0.1300 - - 10.86 95,143.52 95,143.52 95,143.52 N/A 82 Days GO SR2011 Animal Shelter 31,297.80 0.1300 - - 3.57 31,301.37 31,301.37 31,301.37 N/A 82 Days GO SR2011 Athletic Fields 98.04 0.1300 - - 0.01 98.05 98.05 98.05 N/A 82 Days GO SR2011 Soccer Fields 961,756.15 0.1300 - - 109.77 961,865.92 961,865.92 961,865.92 N/A 82 Days GO SR2011 Swimming Pool 5,981,135.17 0.1300 - - 682.65 5,981,817.82 5,981,817.82 5,981,817.82 N/A 82 Days GO SR2012 Downtown Improvements 979,685.50 0.1300 - - 111.82 979,797.32 979,797.32 979,797.32 N/A 82 Days Sewer/CCMA Project 1,997,098.31 0.1300 - - 227.94 1,997,326.25 1,997,326.25 1,997,326.25 N/A 82 Days W/S-Customer Deposits 295,319.86 0.1300 - - 33.71 295,353.57 295,353.57 295,353.57 N/A 82 Days W/S-Equipment Repl/Cap.Imp 177,560.14 0.1300 - - 20.27 177,580.41 177,580.41 177,580.41 N/A 82 Days Water&Sewer 638,841.45 0.1300 - - 72.91 638,914.36 638,914.36 638,914.36 N/A 82 Days W/S-Vehicle Replacement 256,501.80 0.1300 - - 29.28 256,531.08 256,531.08 256,531.08 N/A 82 Days Water/SSLG - SAWS 809,828.46 0.1300 - - 92.43 809,920.89 809,920.89 809,920.89 N/A 82 Days TOTAL LONESTAR 17,974,688.97 - - 2,051.54 17,976,740.51 17,976,740.51 17,976,740.51 - TEXAS CLASS Tax I&S 624,188.70 0.1000 376,780.18 - 52.45 1,001,021.33 1,001,021.33 1,001,021.33 N/A 68 Days Police Forfeiture 338,989.42 0.1000 - - 27.32 339,016.74 339,016.74 339,016.74 N/A 68 Days Park Fund 1,354.68 0.1000 - - 0.04 1,354.72 1,354.72 1,354.72 N/A 68 Days Economic Development Corporation 5,916,859.20 0.1000 300,000.00 - 479.54 6,217,338.74 6,217,338.74 6,217,338.74 N/A 68 Days Library Board 44,854.94 0.1000 - - 3.68 44,858.62 44,858.62 44,858.62 N/A 68 Days Tree Mitigation 97,339.34 0.1000 - - 7.79 97,347.13 97,347.13 97,347.13 N/A 68 Days Tax Note 2013 Fire Truck 4,929.76 0.1000 - - 0.35 4,930.11 4,930.11 4,930.11 N/A 68 Days Hotel Tax 299,186.84 0.1000 - - 24.18 299,211.02 299,211.02 299,211.02 N/A 68 Days Special Events Fund 16,783.88 0.1000 - - 1.28 16,785.16 16,785.16 16,785.16 N/A 68 Days Citywide Projects SR2007 803,398.17 0.1000 - - 64.83 803,463.00 803,463.00 803,463.00 N/A 68 Days Tax Note 2013 A P25 62.47 0.1000 - - - 62.47 62.47 62.47 N/A 68 Days TOTAL TEXAS CLASS 8,147,947.40 676,780.18 - 661.46 8,825,389.04 8,825,389.04 8,825,389.04 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING OCTOBER 31st, 2014 64 65 TOTAL OPERATIONS 17% TOTAL LOGIC 13% TOTAL LONESTAR 39% TOTAL TEXAS CLASS 19% TOTAL CAPITAL ONE 7% TOTAL C.D.s 5% City Portfolio By Investment Type 66 Operations, $15,359,538.19 Projects, $12,690,961.36 Debt Service Fund, $1,001,021.33 Special Revenue Funds, $15,479,929.88 Designated Funds, $1,372,518.73 City Portfolio By Use 67 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.60 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 1 Month T-Bill 0.0100 3 Month T-Bill 0.0100 6 Month T-Bill 0.0500 Schertz Portfolio 0.2422 Schertz Bank&Trust 0.0500 CD 365 Days 0.4000 CD 180 Days 0.6000 LOGIC 0.0879 LoneStar 0.1300 MBIA 0.1000 Capital One 1.4135 MONTHLY YIELDS 68 C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:10/31/2014 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 64,894.75 64,894.75 64,894.75 37.00 0.06 Total Cash & Equivalents 64,894.75 64,894.75 64,894.75 37.00 0.06% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 411.00 100,000.00 116,185.00 105,237.00 4,875.00 4.20 Federal Natl Mtg Assn 1/30/2017 822.00 100,000.00 102,366.80 101,184.00 1,250.00 1.22 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 25.00 200,000.00 200,609.40 200,084.00 1,500.00 0.75 US Treasury Note 3/15/2017 866.00 100,000.00 99,835.94 100,211.00 750.00 0.75 US Treasury Note 11/30/2015 395.00 60,000.00 61,936.72 60,768.60 825.00 1.33 US Treasury Note 5/31/2016 578.00 325,000.00 337,135.74 332,111.00 5,687.00 1.69 US Treasury Note 8/31/2016 670.00 275,000.00 277,401.37 277,772.00 2,750.00 0.99 US Treasury Note 7/15/2017 988.00 100,000.00 99,664.06 100,156.00 875.00 0.88 Total Fixed Income 1,260,000.00 1,295,135.03 1,277,523.60 18,512.00 1.43% Total Assets 534.57 1,324,894.75 1,360,029.78 1,342,418.35 18,549.00 1.36% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 29,338.22 29,338.22 29,338.22 17.00 0.06 Total Cash & Equivalents 29,338.22 29,338.22 29,338.22 17.00 0.06% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 411.00 200,000.00 230,779.00 210,474.00 9,750.00 4.22 Federal Natl Mtg Assn 12/21/2015 416.00 100,000.00 99,989.10 100,174.00 375.00 0.38 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 25.00 220,000.00 220,078.68 220,092.40 1,650.00 0.75 US Treasury Note 3/15/2017 866.00 150,000.00 149,753.91 150,316.50 1,125.00 0.75 US Treasury Note 11/30/2015 395.00 305,000.00 312,082.23 308,907.05 4,193.00 1.34 US Treasury Note 5/31/2016 578.00 350,000.00 364,567.38 357,658.00 6,125.00 1.68 US Treasury Note 7/15/2016 623.00 340,000.00 339,690.82 341,380.40 2,125.00 0.63 Total Fixed Income 1,665,000.00 1,716,941.12 1,689,002.35 25,343.00 1.48% Total Assets 468.00 1,694,338.22 1,746,279.34 1,718,340.57 25,360.00 1.45% 69