Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
03-DECEMBER 2014 FINANCIAL STATEMENT
DECEMBER 2014 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department FEBRUARY 28, 2015 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 16,665,690 5,270,395.59 6,272,914.07 6,941,168.30 - 9,724,521.70 41.65% Franchises 1,986,159 125,916.69 301,383.41 425,656.81 - 1,560,502.19 21.43% Permits 1,175,803 91,833.00 193,355.40 314,466.00 - 861,337.00 26.74% Licenses 91,229 5,925.00 15,977.50 13,600.00 - 77,629.00 14.91% Fees 2,814,366 187,699.55 591,349.67 581,945.34 - 2,232,420.66 20.68% Fines 31,000 2,280.36 6,899.76 6,832.08 - 24,167.92 22.04% Inter-Jurisdictional 708,392 61,771.26 168,959.58 162,441.74 - 545,950.26 22.93% Fund Transfers 1,759,754 141,042.08 438,290.49 423,126.24 - 1,336,627.76 24.04% Miscellaneous 462,650 79,392.54 112,634.15 146,427.22 (40.00) 316,262.78 31.64% TOTAL REVENUES 25,695,043 5,966,256.07 8,101,764.03 9,015,663.73 (40.00) 16,679,419.27 35.09% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 2,620.83 5,693.83 5,671.32 - 17,903.68 24.06% Supplies 1,800 65.34 278.07 65.34 - 1,734.66 3.63% City Support Services 40,600 27,070.32 8,703.51 27,070.32 5,297.56 8,232.12 79.72% Operations Support 400 96.95 - 96.95 52.98 250.07 37.48% Staff Support 21,300 4,156.00 11,151.51 7,181.53 31.50 14,086.97 33.86% TOTAL CITY COUNCIL 87,675 34,009.44 25,826.92 40,085.46 5,382.04 42,207.50 51.86% CITY MANAGER Personnel Services 832,380 99,416.50 211,642.76 219,136.79 - 613,243.21 26.33% Supplies 3,000 16.21 395.03 169.68 - 2,830.32 5.66% City Support Services 2,770 - 1,162.50 1,362.50 - 1,407.50 49.19% Staff Support 27,975 1,132.12 3,715.43 3,767.53 340.81 23,866.66 14.69% Professional Services - - - - - - 0.00% TOTAL CITY MANAGER 866,125 100,564.83 216,915.72 224,436.50 340.81 641,347.69 25.95% *************************************************** 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: DECEMBER 31st, 2014 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 MUNICIPAL COURT Personnel Services 301,231 26,430.66 65,853.65 69,429.80 - 231,801.20 23.05% Supplies 3,500 - 158.50 89.75 87.35 3,322.90 5.06% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 - 90.00 - 1,928.00 2,572.00 42.84% Staff Support 7,710 461.89 1,381.38 607.52 311.20 6,791.28 11.92% Court Support 700 - - - - 700.00 0.00% Professional Services 68,200 3,390.00 13,624.49 10,557.50 26,422.50 31,220.00 54.22% Maintenance Services 2,800 250.00 100.00 450.00 1,350.00 1,000.00 64.29% Operating Equipment 800 - - - 17.76 782.24 2.22% TOTAL MUNICIPAL COURT 390,441 30,532.55 81,208.02 81,134.57 30,116.81 279,189.62 28.49% CUSTOMER RELATIONS-311 Personnel Services 113,241 10,466.64 24,483.98 27,964.31 - 85,276.69 24.69% Supplies 200 - 53.42 - - 200.00 0.00% Staff Support 750 - 71.00 - - 750.00 0.00% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 114,691 10,466.64 24,608.40 27,964.31 - 86,726.69 24.38% PLANNING & ZONING Personnel Services 133,705 13,604.78 27,146.11 32,550.12 - 101,154.88 24.34% Supplies 2,672 33.62 88.99 37.94 - 2,634.06 1.42% Operations Support 750 - - - - 750.00 0.00% Staff Support 19,950 - (61.20) 363.80 225.00 19,361.20 2.95% Professional Services 300 - - - - 300.00 0.00% Operating Equipment 450 - - - - 450.00 0.00% TOTAL PLANNING & ZONING 157,827 13,638.40 27,173.90 32,951.86 225.00 124,650.14 21.02% LEGAL SERVICES Operations Support 10,000 - 161.16 37.44 84.76 9,877.80 1.22% Professional Services 350,000 16,213.00 - 16,543.00 - 333,457.00 4.73% TOTAL LEGAL SERVICES 360,000 16,213.00 161.16 16,580.44 84.76 343,334.80 4.63% 2 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 GENERAL SERVICES Personnel Services 578,049 54,542.79 136,876.99 152,428.92 - 425,620.08 26.37% Supplies 60,425 2,444.10 8,136.81 5,749.23 4,037.42 50,638.35 16.20% Utility Services 99,880 8,143.12 14,456.03 13,553.98 1,151.07 85,174.95 14.72% Staff Support 11,749 257.04 1,632.94 931.83 612.20 10,204.97 13.14% Maintenance Services 31,900 972.25 378.25 5,012.16 223.89 26,663.95 16.41% Operating Equipment 10,800 - 4,763.90 - - 10,800.00 0.00% Capital Outlay - - - - - - 0.00% TOTAL GENERAL SERVICES 792,803 66,359.30 166,244.92 177,676.12 6,024.58 609,102.30 23.17% BUILDING 6-8 MAINTENANCE Supplies 30,250 1,392.81 7,297.07 3,002.10 1,512.19 25,735.71 14.92% Utility Services 89,235 6,370.73 14,328.85 10,939.14 662.26 77,633.60 13.00% Maintenance Services 58,700 4,468.89 7,004.54 9,342.04 1,520.99 47,836.97 18.51% Operating Equipment 23,000 - - - 1,049.93 21,950.07 4.56% TOTAL BUILDING 6-8 MAINTENANCE 201,185 12,232.43 28,630.46 23,283.28 4,745.37 173,156.35 13.93% CITY SECRETARY Personnel Services 167,772 17,600.75 35,134.89 41,982.58 - 125,789.42 25.02% Supplies 1,200 53.59 177.37 299.95 - 900.05 25.00% City Support Services 9,700 - - - - 9,700.00 0.00% Operations Support 150 - - - - 150.00 0.00% Staff Support 8,795 435.57 1,324.06 867.67 - 7,927.33 9.87% TOTAL CITY SECRETARY 187,617 18,089.91 36,636.32 43,150.20 - 144,466.80 23.00% NON-DEPARTMENTAL City Support Services 860,000 44,265.76 186,544.53 184,527.99 2,200.00 673,272.01 21.71% Operations Support 141,500 14,914.70 27,997.97 30,575.19 3,488.00 107,436.81 24.07% Staff Support 150 - 80.00 80.00 - 70.00 53.33% City Assistance 1,243,779 - 105,228.72 - - 1,243,779.00 0.00% Professional Services 262,400 5,197.83 8,992.80 11,865.74 - 250,534.26 4.52% 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 64,378.29 328,844.02 227,048.92 5,688.00 2,528,092.08 8.43% 3 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 PUBLIC AFFAIRS Personnel Services 257,970 25,248.71 42,097.86 58,090.25 - 199,879.75 22.52% Supplies 3,500 585.67 1,235.87 708.53 - 2,791.47 20.24% Operations Support 26,000 - 1,622.71 842.50 - 25,157.50 3.24% Staff Support 5,150 169.96 551.07 462.96 70.00 4,617.04 10.35% Professional Services 13,500 - 250.00 - - 13,500.00 0.00% Operating Equipment 2,100 1,709.93 99.99 1,709.93 211.89 178.18 91.52% TOTAL PUBLIC AFFAIRS 308,220 27,714.27 45,857.50 61,814.17 281.89 246,123.94 20.15% RECORDS MANAGEMENT Personnel Services 51,106 4,825.72 11,601.56 13,574.12 - 37,531.88 26.56% Supplies 400 46.76 - 46.76 - 353.24 11.69% Staff Support 1,750 47.72 - 804.61 - 945.39 45.98% Professional Services 10,000 529.00 1,207.50 2,176.00 - 7,824.00 21.76% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 63,256 5,449.20 12,809.06 16,601.49 83.77 46,570.74 26.38% SCHERTZ MAGAZINE Personnel Services 137,208 14,097.78 29,247.63 34,480.36 - 102,727.64 25.13% Supplies 200 - 73.94 - - 200.00 0.00% Opperations Support 100 - - - - 100.00 0.00% Staff Support 3,000 219.00 334.00 237.00 18.00 2,745.00 8.50% Professional Services 253,500 19,033.10 23,943.01 42,039.37 8,094.24 203,366.39 19.78% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - - - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 404,608 33,349.88 53,598.58 76,756.73 8,112.24 319,739.03 20.98% ENGINEERING Personnel Services 282,558 20,024.64 27,824.97 43,029.75 - 239,528.25 15.23% Supplies 1,300 25.56 300.51 170.82 150.16 979.02 24.69% City Support Services 1,500 - 262.80 - 262.80 1,237.20 17.52% Utility Services 1,498 41.66 257.28 83.32 - 1,414.68 5.56% Staff Support 10,512 - - 24.85 - 10,487.15 0.24% Professional Services 38,800 - 10,656.25 - - 38,800.00 0.00% Operating Equipment 600 - - - - 600.00 0.00% TOTAL ENGINEERING 336,768 20,091.86 39,301.81 43,308.74 412.96 293,046.30 12.98% 4 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 GIS Personnel Services 135,495 13,858.40 29,237.23 34,850.48 - 100,644.52 25.72% 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 13,858.40 29,237.23 34,850.48 - 119,944.52 22.51% TOTAL GENERAL GOVERNMENT 7,186,840 466,948.40 1,117,054.02 1,127,643.27 61,498.23 5,997,698.50 16.55% PUBLIC SAFETY POLICE Personnel Services 4,983,836 512,917.52 1,103,816.96 1,303,655.96 - 3,680,180.04 26.16% Supplies 47,646 708.02 6,150.33 12,013.44 4,947.43 30,685.13 35.60% City Support Services 26,750 - 26,721.66 23,151.52 - 3,598.48 86.55% Utility Services 148,064 7,661.40 20,792.86 16,487.36 - 131,576.64 11.14% Operations Support 2,950 284.94 236.73 284.94 - 2,665.06 9.66% Staff Support 109,423 15,249.98 19,525.35 18,763.83 10,600.27 80,058.90 26.84% City Assistance 10,200 95.00 2,212.15 357.20 896.00 8,946.80 12.29% Professional Services 53,313 261.37 1,393.30 5,399.68 3,163.84 44,749.48 16.06% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 53,790 2,956.22 16,590.25 3,958.96 2,940.00 46,891.04 12.83% Operating Equipment 108,868 5,644.55 39,672.96 9,522.90 6,192.05 93,153.05 14.43% Capital Outlay 218,754 25,175.00 128,505.24 55,175.00 - 163,579.00 25.22% TOTAL POLICE 5,763,594 570,954.00 1,365,617.79 1,448,770.79 28,739.59 4,286,083.62 25.64% FIRE RESCUE Personnel Services 2,890,145 313,728.45 630,352.10 784,032.22 - 2,106,112.78 27.13% Supplies 16,500 289.29 1,220.49 764.07 1,146.70 14,589.23 11.58% Utility Services 58,700 5,443.17 10,661.51 9,696.75 531.65 48,471.60 17.42% Operations Support 1,200 - 36.00 - 26.98 1,173.02 2.25% Staff Support 115,700 6,866.28 13,931.70 14,331.23 7,040.93 94,327.84 18.47% City Assistance 16,200 - - - - 16,200.00 0.00% Professional Services 25,000 160.00 - 160.00 - 24,840.00 0.64% Maintenance Services 58,932 5,996.70 4,311.31 6,614.24 1,402.97 50,914.79 13.60% Rental/Leasing 14,000 - - - - 14,000.00 0.00% Operating Equipment 65,900 754.41 3,923.19 1,099.40 1,058.39 63,742.21 3.27% Capital Outlay 210,600 - - - 67,290.00 143,310.00 31.95% TOTAL FIRE RESCUE 3,472,877 333,238.30 664,436.30 816,697.91 78,497.62 2,577,681.47 25.78% 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 INSPECTIONS Personnel Services 530,804 47,122.80 101,994.38 113,883.31 - 416,920.69 21.45% Supplies 2,938 144.71 205.04 298.81 189.31 2,449.88 16.61% Utility Services 6,500 312.86 1,065.92 741.81 - 5,758.19 11.41% Operations Support 2,200 8.99 316.00 410.48 - 1,789.52 18.66% Staff Support 13,850 118.80 487.13 342.30 762.99 12,744.71 7.98% Professional Services - - 45.59 - - - 0.00% Operating Equipment 28,520 - 429.99 - - 28,520.00 0.00% TOTAL INSPECTIONS 584,812 47,708.16 104,544.05 115,676.71 952.30 468,182.99 19.94% MARSHAL'S OFFICE Personnel Services 570,071 56,750.86 130,505.75 153,135.94 - 416,935.06 26.86% Supplies 6,400 104.93 231.11 501.06 104.93 5,794.01 9.47% Utility Services 16,000 566.56 1,845.73 1,380.50 - 14,619.50 8.63% Operations Support 3,500 - 123.75 - 217.56 3,282.44 6.22% Staff Support 14,800 98.79 416.84 766.78 1,326.95 12,706.27 14.15% City Assistance 2,500 - - - - 2,500.00 0.00% Maintenance Services 17,700 650.00 2,144.00 650.00 200.00 16,850.00 4.80% Operating Equipment 19,700 45.98 455.20 136.96 11,666.54 7,896.50 59.92% Capital Outlay 8,000 - 28,566.00 - - 8,000.00 0.00% TOTAL MARSHAL'S OFFICE 658,671 58,217.12 164,288.38 156,571.24 13,515.98 488,583.78 25.82% TOTAL PUBLIC SAFETY 10,479,954 1,010,117.58 2,298,886.52 2,537,716.65 121,705.49 7,820,531.86 25.38% 6 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 PUBLIC ENVIRONMENT STREETS Personnel Services 691,780 63,951.18 165,009.22 186,658.20 - 505,121.80 26.98% Supplies 7,100 147.51 2,270.12 1,198.74 488.55 5,412.71 23.76% Utility Services 136,200 2,817.74 20,735.99 7,225.52 88.54 128,885.94 5.37% Staff Support 10,030 772.25 2,009.53 2,189.70 1,038.29 6,802.01 32.18% City Assistance 500 - - - - 500.00 0.00% Professional Services 40,000 22,000.00 - 22,000.00 - 18,000.00 55.00% Maintenance Services 135,400 4,021.90 36,484.86 12,161.03 4,208.22 119,030.75 12.09% Rental/Lease 200 175.00 - 175.00 - 25.00 87.50% Operating Equipment 300 - 48.00 - - 300.00 0.00% Capital Outlay 28,000 - 5,900.00 - - 28,000.00 0.00% TOTAL STREETS 1,049,510 93,885.58 232,457.72 231,608.19 5,823.60 812,078.21 22.62% TOTAL PUBLIC ENVIRONMENT 1,049,510 93,885.58 232,457.72 231,608.19 5,823.60 812,078.21 22.62% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 533,103 38,939.53 115,384.80 108,849.55 - 424,253.45 20.42% Supplies 41,905 491.27 4,265.19 2,286.11 3,422.78 36,196.11 13.62% Utility Services 143,800 11,814.47 18,546.51 20,103.63 7,272.70 116,423.67 19.04% Operations Support 250 - - - - 250.00 0.00% Staff Support 8,473 281.26 765.05 1,203.02 3,424.65 3,845.33 54.62% Professional Services 72,000 2,461.00 6,862.21 4,922.00 6,152.50 60,925.50 15.38% Maintenance Services 20,000 141.36 336.07 171.16 24.30 19,804.54 0.98% Rental/Leasing 39,600 6,038.32 9,294.66 12,076.64 24,153.28 3,370.08 91.49% Operating Equipment 2,000 300.00 1,043.45 1,121.94 344.25 533.81 73.31% Capital Outlay 60,000 - - - - 60,000.00 0.00% TOTAL PARKS DEPARTMENT 921,131 60,467.21 156,497.94 150,734.05 44,794.46 725,602.49 21.23% SWIM POOL Supplies 20,700 3,937.50 27.74 4,191.12 59.96 16,448.92 20.54% Utility Services 29,000 2,563.74 2,878.03 3,780.78 350.24 24,868.98 14.24% Maintenance Services 203,378 - 461.49 - 400.00 202,978.00 0.20% TOTAL SWIM POOL 253,078 6,501.24 3,367.26 7,971.90 810.20 244,295.90 3.47% 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 EVENT FACILITIES Personnel Services 58,642 6,249.45 11,534.15 13,867.93 - 44,774.07 23.65% Supplies 14,500 19.00 2,893.93 700.42 3,798.60 10,000.98 31.03% Utility Services 51,400 3,573.10 5,658.16 6,653.97 365.42 44,380.61 13.66% Operations Support 23,311 4,435.00 11.97 4,435.00 - 18,876.00 19.03% Staff Support 2,448 - 655.75 583.74 65.00 1,799.26 26.50% Professional Services 500 - 299.10 - - 500.00 0.00% Operating Equipment 5,000 431.26 - 431.26 - 4,568.74 8.63% TOTAL EVENT FACILITIES 155,801 14,707.81 21,053.06 26,672.32 4,229.02 124,899.66 19.83% SENIOR CITIZEN CENTER Supplies 7,650 787.68 - 1,328.67 796.05 5,525.28 27.77% Utility Services 4,240 216.78 - 216.78 - 4,023.22 5.11% Operations Support 1,500 - - - - 1,500.00 0.00% City Assistence 20,000 2,254.20 - 4,482.83 2,937.96 12,579.21 37.10% Professional Services 8,000 310.00 - 560.00 - 7,440.00 7.00% Maintenance Services 5,000 - 393.92 239.08 86.96 4,673.96 6.52% TOTAL SENIOR CITIZEN CENTER 46,390 3,568.66 393.92 6,827.36 3,820.97 35,741.67 22.95% TOTAL PARKS & RECREATION 1,376,400 85,244.92 181,312.18 192,205.63 53,654.65 1,130,539.72 17.86% CULTURAL LIBRARY Personnel Services 672,828 62,226.49 162,222.44 153,015.26 - 519,812.74 22.74% Supplies 13,500 2,474.09 1,154.08 2,548.05 859.06 10,092.89 25.24% Utility Services 56,500 3,723.12 7,402.76 7,013.44 391.99 49,094.57 13.11% Operations Support 3,000 215.99 62.11 231.98 860.00 1,908.02 36.40% Staff Support 6,345 327.46 122.21 864.76 205.00 5,275.24 16.86% Professional Services 2,300 2,175.00 2,190.00 2,175.00 - 125.00 94.57% Operating Equipment 88,000 19,835.58 10,428.49 20,541.86 8,698.24 58,759.90 33.23% TOTAL LIBRARY 842,473 90,977.73 183,582.09 186,390.35 11,014.29 645,068.36 23.43% TOTAL CULTURAL 842,473 90,977.73 183,582.09 186,390.35 11,014.29 645,068.36 23.43% 8 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 HEALTH ANIMAL SERVICES Personnel Services 306,397 26,657.01 57,172.64 66,900.39 - 239,496.61 21.83% Supplies 37,883 4,402.42 2,359.02 6,085.79 1,290.06 30,507.15 19.47% Utility Services 46,840 3,193.78 1,980.26 4,614.07 76.45 42,149.48 10.01% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 11,390 164.90 856.42 531.31 42.83 10,815.86 5.04% City Assistance 17,550 703.00 1,512.47 1,889.65 663.00 14,997.35 14.55% Professional Services 26,500 1,222.00 14,951.14 2,007.00 767.10 23,725.90 10.47% Maintenance Services 23,200 958.83 360.00 689.99 180.00 22,330.01 3.75% Operating Equipment 11,500 - - - - 11,500.00 0.00% Capital Outlay 21,000 - - - - 21,000.00 0.00% TOTAL ANIMAL SERVICES 503,260 37,301.94 79,191.95 82,718.20 3,019.44 417,522.36 17.04% TOTAL HEALTH 503,260 37,301.94 79,191.95 82,718.20 3,019.44 417,522.36 17.04% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 441,993 38,270.38 78,454.33 92,753.81 - 349,239.19 20.99% Supplies 3,500 86.33 231.46 210.95 75.32 3,213.73 8.18% City Support Services 598,643 9,686.12 62,953.63 82,402.86 4,986.74 511,253.40 14.60% Utility Services 236,822 16,960.74 41,280.31 35,006.04 4,609.12 197,206.84 16.73% Staff Support 37,400 1,115.38 3,507.75 2,519.77 76.77 34,803.46 6.94% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 15,600 535.17 440.00 2,954.39 79.00 12,566.61 19.44% Operating Equipment 291,571 2,143.24 28,970.05 12,791.60 6,705.67 272,073.73 6.69% TOTAL INFORMATION TECHNOLOGY 1,625,529 68,797.36 215,837.53 228,639.42 16,532.62 1,380,356.96 15.08% 9 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 HUMAN RESOURCES Personnel Services 310,863 30,491.10 60,081.91 75,267.44 - 235,595.56 24.21% Supplies 1,000 61.26 344.77 369.79 - 630.21 36.98% Human Services 64,000 8,803.71 4,435.75 11,635.25 - 52,364.75 18.18% Operations Support 14,000 - 1,344.00 - - 14,000.00 0.00% Staff Support 14,620 370.00 424.38 2,195.00 270.24 12,154.76 16.86% City Assistance 10,000 201.50 786.00 651.50 385.00 8,963.50 10.37% Professional Services 9,200 1,489.50 - 2,234.25 - 6,965.75 24.29% Operating Equipment - - - - - - 0.00% TOTAL HUMAN RESOURCES 423,683 41,417.07 67,416.81 92,353.23 655.24 330,674.53 21.95% FINANCE Personnel Services 516,715 48,441.98 101,358.77 120,159.99 - 396,555.01 23.25% Supplies 2,800 194.95 387.56 525.40 347.30 1,927.30 31.17% Operations Support 1,000 - - - 1,899.84 (899.84) 189.98% Staff Support 15,605 30.00 1,127.65 740.00 700.00 14,165.00 9.23% Maintenance Services - - - - - - 0.00% TOTAL FINANCE 536,120 48,666.93 102,873.98 121,425.39 2,947.14 411,747.47 23.20% PURCHASING & ASSET MGT Personnel Services 262,098 16,442.91 58,399.08 45,581.92 - 216,516.08 17.39% Supplies 1,200 - 19.43 - 125.65 1,074.35 10.47% Utility Services 500 67.48 - 134.96 - 365.04 26.99% Operations Support 300 - - - - 300.00 0.00% Staff Support 8,070 437.40 1,165.25 687.40 60.00 7,322.60 9.26% Operating Equipment 1,300 - 1,821.69 - 560.75 739.25 43.13% TOTAL PURCHASING & ASSET MGT 273,468 16,947.79 61,405.45 46,404.28 746.40 226,317.32 17.24% 10 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 FLEET SERVICE Personnel Services 313,447 22,963.45 47,282.07 56,621.16 - 256,825.84 18.06% Supplies 174,525 7,617.11 47,764.52 23,479.60 27,594.29 123,451.11 29.26% City Support Services 3,500 2,232.24 2,100.00 2,232.24 - 1,267.76 63.78% Utility Services 5,000 324.81 723.89 855.39 - 4,144.61 17.11% Operations Support 400 - - - - 400.00 0.00% Staff Support 4,500 631.60 318.03 741.68 293.09 3,465.23 22.99% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 73,750 6,260.56 21,723.82 11,292.09 1,177.79 61,280.12 16.91% Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 292.08 - 2,132.08 - 6,067.92 26.00% Capital Outlay 65,000 - - - - 65,000.00 0.00% TOTAL FLEET SERVICE 648,702 40,321.85 119,912.33 97,354.24 29,065.17 522,282.59 19.49% BUILDING MAINTENANCE Personnel Services 136,524 10,615.49 23,988.86 29,756.43 - 106,767.57 21.80% Supplies 1,043 43.99 72.25 394.52 147.78 500.70 51.99% Utility Services 2,350 205.16 564.93 497.21 - 1,852.79 21.16% Staff Support 2,900 66.56 126.69 492.32 147.79 2,259.89 22.07% Professional Services 12,000 - 7,160.00 - - 12,000.00 0.00% Maintenance Services 71,132 13,538.53 24,480.25 14,962.85 6,784.02 49,385.13 30.57% 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 24,469.73 56,392.98 46,103.33 15,494.59 206,001.08 23.02% TOTAL INTERNAL SERVICE 3,775,101 240,620.73 623,839.08 632,279.89 65,441.16 3,077,379.95 18.48% 11 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 - 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 - 10,500.00 - - 45,000.00 0.00% TOTAL CITY ASSISTANCE 86,678 - 15,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 - 15,500 5,000 1,840 165,710.00 3.96% TOTAL EXPENDITURES 25,386,088 2,025,096.88 4,731,823.56 4,995,562.18 323,996.86 20,066,528.96 20.95% REVENUE OVER(UNDER) EXPEND.308,955 4,020,101.55 12 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 9,188,520 4,463,961.52 4,543,248.08 5,178,337.61 - 4,010,182.39 56.36% 000-411200 Advalorem Tax - Delinquent 50,000 6,088.82 4,850.32 14,557.44 - 35,442.56 29.11% 000-411300 Advalorem Tax - P&I 50,000 1,787.93 8,178.21 5,232.57 - 44,767.43 10.47% 000-411500 Sales Tax Revenue-Gen Fund 7,346,170 798,557.32 1,706,051.73 1,731,615.43 - 5,614,554.57 23.57% 000-411600 Bingo Tax - - - - - - 0.00% 000-411700 Mixed Beverage Tax 31,000.00 - 10,585.73 11,425.25 - 19,574.75 36.86% TOTAL Taxes 16,665,690 5,270,395.59 6,272,914.07 6,941,168.30 - 9,724,521.70 41.65% Franchises 000-421200 Center Point/Entex Energy 87,202 6,620.12 17,331.67 19,860.36 - 67,341.64 22.78% 000-421220 City Public Service 649,940 38,784.45 93,115.43 122,357.06 - 527,582.94 18.83% 000-421240 Guadalupe Valley Elec Co-op 443,320 33,052.76 - 99,158.28 - 344,161.72 22.37% 000-421250 New Braunfels Utilities 60,697 4,606.98 14,257.43 13,820.92 - 46,876.08 22.77% 000-421300 Time Warner-State Franchise 275,000 22,708.75 64,690.92 68,126.25 - 206,873.75 24.77% 000-421460 AT&T Franchise Fee 250,000 20,143.63 51,384.75 60,430.89 - 189,569.11 24.17% 000-421480 Other Telecom Franchise 100,000 - 24,397.77 22,263.49 - 77,736.51 22.26% 000-421500 Solid Waste Franchise Fee 120,000 - 36,205.44 19,639.56 - 100,360.44 16.37% TOTAL Franchises 1,986,159 125,916.69 301,383.41 425,656.81 - 1,560,502.19 21.43% Permits 000-431100 Home Occupation Permit 420 175.00 210.00 175.00 - 245.00 41.67% 000-431205 Building Permit - Residential 356,476 56,368.00 65,395.00 145,938.00 - 210,538.00 40.94% 000-431210 Building Permit - Commercial 125,521 - - 7,607.00 - 117,914.00 6.06% 000-431215 Building Permit - General 350,000 6,206.00 40,241.00 37,103.00 - 312,897.00 10.60% 000-431300 Mobile Home Permit 525 50.00 225.00 150.00 - 375.00 28.57% 000-431400 Signs Permit 11,920 236.00 2,525.00 736.00 - 11,184.00 6.17% 000-431500 Food Establishmnt Permit 48,000 1,350.00 25,095.00 48,950.00 - (950.00) 101.98% 000-431600 Garage Sale Permit 10,840 198.00 3,098.00 2,524.00 - 8,316.00 23.28% 000-431700 Plumbing Permit 100,851 10,693.00 18,694.40 27,859.00 - 72,992.00 27.62% 000-431750 Electrical Permit 50,000 4,840.00 9,960.00 12,620.00 - 37,380.00 25.24% 000-431800 Mechanical Permit 50,000 5,780.00 10,400.00 14,140.00 - 35,860.00 28.28% 000-431900 Solicitor/Peddler Permit 1,000 - 30.00 120.00 - 880.00 12.00% 000-431950 Animal/Pet Permit 2,000 - 205.00 100.00 - 1,900.00 5.00% 000-432000 Cert. of Occupancy Prmt 5,250 650.00 2,800.00 2,650.00 - 2,600.00 50.48% ************************************************ 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: DECEMBER 31st, 2014 13 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 000-432100 Security Alarm Permit 45,000 2,931.00 9,310.00 9,081.00 - 35,919.00 20.18% 000-432300 Grading/Clearing Permit 3,000 600.00 1,723.00 962.00 - 2,038.00 32.07% 000-435000 Fire Permit 15,000 1,756.00 3,444.00 3,751.00 - 11,249.00 25.01% TOTAL Permits 1,175,803 91,833.00 193,355.40 314,466.00 - 861,337.00 26.74% Licenses 000-441000 Alcohol Beverage License 7,000 480.00 2,027.50 1,245.00 - 5,755.00 17.79% 000-441300 Mobile Home License 160 80.00 - 80.00 - 80.00 50.00% 000-442000 Contractors License 79,569 5,180.00 13,280.00 11,815.00 - 67,754.00 14.85% 000-444000 Pet License 4,500 185.00 670.00 460.00 - 4,040.00 10.22% TOTAL Licenses 91,229 5,925.00 15,977.50 13,600.00 - 77,629.00 14.91% Fees 000-451000 Municipal Court Fines 1,300,000 83,644.66 295,281.39 244,339.79 - 1,055,660.21 18.80% 000-451100 Arrest Fee 56,534 3,829.00 13,421.93 11,273.05 - 45,260.95 19.94% 000-451110 Expunction Fee 120 - - 60.00 - 60.00 50.00% 000-451200 Warrant Fees 150,000 8,825.70 23,159.31 24,296.57 - 125,703.43 16.20% 000-451320 Civil Justice Fee-Court 34 - 18.40 - - 34.00 0.00% 000-451321 Civil Justice Fee-State 288 - 165.94 - - 288.00 0.00% 000-451340 Judicial Fee - City 7,567 494.04 1,733.83 1,467.71 - 6,099.29 19.40% 000-451400 Traffic Fine Costs TTL 28,060 1,972.87 6,823.69 5,838.32 - 22,221.68 20.81% 000-451500 Teen Court Admin Fee 200 - - - - 200.00 0.00% 000-451510 Juvenile Case Mgmt Fee 63,062 4,112.40 14,443.57 12,231.07 - 50,830.93 19.40% 000-451520 Truancy Fee 4,586 756.61 - 2,204.48 - 2,381.52 48.07% 000-451600 Technology Fund Fee 50,872 3,335.02 11,549.63 9,818.04 - 41,053.96 19.30% 000-451700 Security Fee 38,160 2,498.28 8,662.22 7,360.56 - 30,799.44 19.29% 000-451800 Time Payment Fee - City 8,122 429.58 1,634.21 1,341.27 - 6,780.73 16.51% 000-451850 State Fines 10% Service Fee 90,736 - 18,121.14 13,194.65 - 77,541.35 14.54% 000-451900 DPS Payment - Local 12,053 680.40 1,853.60 1,772.50 - 10,280.50 14.71% 000-452000 Child Safety Fee 23,570 3,328.12 6,747.78 8,322.17 - 15,247.83 35.31% 000-452050 Indigent Defense Fee 8,852 - 5,099.02 - - 8,852.00 0.00% 000-452100 Platting Fees 47,500 5,500.00 5,500.00 22,500.00 - 25,000.00 47.37% 000-452200 Site Plan Fee 30,000 3,500.00 4,000.00 3,500.00 - 26,500.00 11.67% 000-452300 Plan Check Fee 400,000 30,568.50 50,752.00 95,257.00 - 304,743.00 23.81% 000-452310 Miscellaneous Review Fee 1,200 - 600.00 300.00 - 900.00 25.00% 000-452320 Tree Mitigation Admin Fee 10,000 330.00 31,312.50 11,925.00 - (1,925.00) 119.25% 000-452400 BOA/Zoning Fees 5,000 1,000.00 1,500.00 1,500.00 - 3,500.00 30.00% 000-452500 Food Handler Class 20,000 920.00 4,190.00 3,160.00 - 16,840.00 15.80% 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 000-452520 Fire Training Classes 500 - - - - 500.00 0.00% 000-452600 Specific Use/Zone Chng Fee 25,800 - 650.00 1,000.00 - 24,800.00 3.88% 000-452710 Zoning Ltr & Dev Rights 1,050 - - 750.00 - 300.00 71.43% 000-453100 Reinspection Fees 26,900 2,775.00 8,770.98 9,620.00 - 17,280.00 35.76% 000-453110 Swim Pool Inspection Fee 1,800 - - - - 1,800.00 0.00% 000-453200 Lot Abatement 7,000 100.00 948.00 100.00 - 6,900.00 1.43% 000-453211 Admin Fee-Inspections 6,600 1,000.00 2,600.00 1,200.00 - 5,400.00 18.18% 000-453310 Misc Inspection Fee 3,750 - - - - 3,750.00 0.00% 000-453710 Foster Care 900 50.00 150.00 250.00 - 650.00 27.78% 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 667.60 - 1,022.60 - 977.40 51.13% 000-456120 Senior Center Meal Fee 16,000 2,075.01 - 5,235.51 - 10,764.49 32.72% 000-456500 Haz Mat Fees 12,000 - - - - 12,000.00 0.00% 000-456600 Fire Re-inspection Fee 750 50.00 150.00 250.00 - 500.00 33.33% 000-458100 Sale of Merchandise - - 210.00 - - - 0.00% 000-458110 Sale of Merchandise-GovDeal 5,000 - 1,209.64 672.01 - 4,327.99 13.44% 000-458300 Sale of Property/Auction 2,000 - 16.82 - - 2,000.00 0.00% 000-458400 Civic Center Rental Fees 142,000 10,093.75 38,756.00 35,634.50 - 106,365.50 25.09% 000-458401 Capital Recovery Fee-Civic Cntr 5,500 675.00 1,490.00 1,100.00 - 4,400.00 20.00% 000-458450 North Center Rental Fees 21,000 3,635.00 4,815.00 7,805.75 - 13,194.25 37.17% 000-458460 Senior Center Rental 7,000 1,100.00 - 3,130.00 - 3,870.00 44.71% 000-458500 Community Center Rental Fees 26,000 1,776.00 4,374.57 5,594.88 50.00 20,355.12 21.71% 000-458550 Pavilion Rental Fees 17,500 60.00 2,060.00 2,630.00 - 14,870.00 15.03% 000-458560 Chamber of Comm rent 7,800 1,950.00 1,950.00 1,950.00 - 5,850.00 25.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 2,740.00 - 6,760.00 28.84% 000-458660 BVYA Utility Reimbursement 12,500 - 5,000.30 5,100.50 - 7,399.50 40.80% 000-458670 SYSA Utility Reimbursement 1,500 - - - - 1,500.00 0.00% 000-458675 Lions Futbol Utility Reimbursement 14,000 3,516.00 - 5,860.00 - 8,140.00 41.86% 000-458680 Tournament Fees-Soccer 500 - - - - 500.00 0.00% 000-458700 Vehicle Impoundment 8,000 - 2,470.00 2,300.00 - 5,700.00 28.75% 000-459200 NSF Check Fee 500 - 40.00 - - 500.00 0.00% 000-459300 Notary Fee 300 6.00 102.00 36.00 - 264.00 12.00% 000-459400 Maps, Copies, UDC, & Misc F 100 - 5.00 10.00 - 90.00 10.00% 000-459600 Animal Adoption Fee 16,000 1,140.01 2,410.00 2,952.51 (50.00) 13,097.49 18.14% 000-459700 Pet Impoundment Fee 14,000 777.00 1,939.00 1,976.00 - 12,024.00 14.11% 000-459800 Police Reports Fee 6,000 528.00 1,452.20 1,362.90 - 4,637.10 22.72% TOTAL Fees 2,814,366 187,699.55 591,349.67 581,945.34 - 2,232,420.66 20.68% 15 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 Fines 000-463000 Library Fines 31,000 2,280.36 6,899.76 6,832.08 - 24,167.92 22.04% TOTAL Fines 31,000 2,280.36 6,899.76 6,832.08 - 24,167.92 22.04% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,072 1,756.48 5,269.44 5,269.44 - 15,802.56 25.01% 000-473200 City of Seguin - Fire Contract 30,000 2,435.90 7,307.70 7,307.70 - 22,692.30 24.36% 000-473300 Guad Co - Library 208,000 52,988.49 69,447.64 52,988.49 - 155,011.51 25.48% 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 - - 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 2,302.16 8,183.56 8,501.26 - 31,498.74 21.25% 000-474610 School Cross Guard-Guadalupe 38,000 2,288.23 7,931.24 8,374.85 - 29,625.15 22.04% 000-474620 School Crossing Guard-Comal 1,500 - - - - 1,500.00 0.00% 000-474700 School Officer Funding 155,100 - 42,600.00 80,000.00 - 75,100.00 51.58% TOTAL Inter-Jurisdictional 708,392 61,771.26 168,959.58 162,441.74 - 545,950.26 22.93% Fund Transfers 000-480000 Indirect Costs - EMS 136,087 11,340.58 34,259.49 34,021.74 - 102,065.26 25.00% 000-480100 Indirect Costs - Hotel/Motel 66,405 5,533.75 36,346.26 16,601.25 - 49,803.75 25.00% 000-482150 Transfer From Court Security 27,249 - - - 27,249.00 0.00% 000-485000 Interfund Charge-Drainage 57,130 4,760.83 12,950.01 14,282.49 - 42,847.51 25.00% 000-486000 Interfund Chrges-Admin W&S 1,152,350 96,029.17 288,087.51 288,087.51 - 864,262.49 25.00% 000-486202 Transfer In-W&S 40,000 - - - - 40,000.00 0.00% 000-487000 Interfund Charges-Fleet 180,237 15,019.75 32,585.97 45,059.25 - 135,177.75 25.00% 000-488000 Interfund Charges-4B 100,296 8,358.00 34,061.25 25,074.00 - 75,222.00 25.00% TOTAL Fund Transfers 1,759,754 141,042.08 438,290.49 423,126.24 - 1,336,627.76 24.04% 16 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 Miscellaneous 000-491000 Interest Earned 550 - 91.45 63.63 - 486.37 11.57% 000-491200 Investment Income 26,000 1,991.73 7,354.86 5,822.18 - 20,177.82 22.39% 000-491800 Gain/Loss - - (12,889.84) (609.40) - 609.40 0.00% 000-491900 Unrealized Gain/Loss (20,000) (4,219.33) 7,799.31 (2,091.83) - (17,908.17) 0.00% 000-493120 Donations-Public Library 5,000 3.00 - 1,503.00 - 3,497.00 30.06% 000-493400 Donation - Animal Control 1,000 - 186.82 75.00 - 925.00 7.50% 000-493401 Donations-A/C Microchip 1,400 100.00 245.00 235.00 (5.00) 1,170.00 16.43% 000-493402 Donations-Spay&Neuter 10,000 1,014.00 2,227.50 2,228.00 (35.00) 7,807.00 21.93% 000-493403 Donations-Animal Adoption Trailer 9,000 4,353.52 - 5,303.52 - 3,696.48 58.93% 000-493465 Donations-Senior Center 12,000 760.55 - 2,531.81 - 9,468.19 21.10% 000-493502 Donations-PD - - 2,400.00 - - - 0.00% 000-494481 LawEnforcemtOfficersStnd&Ed - - - - - - 0.00% 000-494482 Grants - Police, Fire, Gen Fund - 11,292.32 - 11,292.32 - (11,292.32) 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 9,674.83 22,139.07 13,149.22 - 6,850.78 65.75% 000-497005 Schertz Magazine Advertising 220,000 36,235.00 57,350.00 75,445.00 - 144,555.00 34.29% 000-497100 Misc Income-Police 15,000 174.00 856.40 2,113.50 - 12,886.50 14.09% 000-497200 Misc Income-Library 4,000 463.75 1,127.29 1,571.55 - 2,428.45 39.29% 000-497210 Misc Income-Library Copier 14,000 1,398.20 3,262.95 4,529.97 - 9,470.03 32.36% 000-497400 Misc Income-Streets Dept.18,000 891.75 7,506.46 2,566.75 - 15,433.25 14.26% 000-497500 Misc Income-TML Insurance 20,000 - 1,221.18 - - 20,000.00 0.00% 000-497550 Misc Income-TML Reimbursemt 20,000 - 5,764.63 2,032.08 - 17,967.92 10.16% 000-497600 Misc Income-Vending Mach.2,000 259.93 432.27 467.96 - 1,532.04 23.40% 000-498000 Reimbursmnt-Gen Fund 60,000 7,999.29 95.26 7,999.29 - 52,000.71 13.33% 000-498100 Reimbursmnt Fire - Training 1,000 - - - - 1,000.00 0.00% 000-498105 Reimburmnt Police - DEA 6,200 - 1,963.54 3,198.67 - 3,001.33 51.59% 000-498107 Reimburmnt Police - Event 7,000 7,000.00 3,500.00 7,000.00 - - 100.00% 000-498110 Reimbursmnt Fire - Emg. Acti-O 5,000 - - - - 5,000.00 0.00% TOTAL Miscellaneous 462,650 79,392.54 112,634.15 146,427.22 (40.00) 316,262.78 31.64% TOTAL REVENUES 25,695,043 5,966,256.07 8,101,764.03 9,015,663.73 (40.00) 16,679,419.27 35.09% 17 Cash in Bank Claim on Operating Cash Pool-Checking 626,396.18$ Cash in Investments LOGIC Investment-General Fund 7,756,760.75 LOGIC Investment-Equip Replacement 73,664.65 LOGIC Investment-Veh Replacement 306,728.21 LOGIC Investment-Air Condi Replacment 196,113.37 CAPITAL ONE Investment-General Fund 1,347,378.96 Total Cash in Bank & Investments 10,453,623.96$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 GENERAL FUND 18 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 357,436 356,940 4,463,962 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 638,904 505,026 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% -3% -9% $- $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 2014-15 215,257 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 $- $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 25% 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 - 20,910.00 18,802.00 - (52.00) 0.00% Miscellaneous 3,925.00 121.29 6,731.38 258.84 - 3,666.16 3.60% TOTAL REVENUES 153,800.00 121.29 27,641.38 19,060.84 - 134,739.16 8.45% 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 4,408.43 3,158.79 4,725.93 282.60 9,991.47 33.39% Employee Appreciation Event 15,000.00 - 5,280.92 - 5,503.12 9,496.88 36.69% 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 314.69 9,785.51 314.69 - 34,685.31 0.90% Jazzfest 20,000.00 - - - - 20,000.00 0.00% Hal Baldwin Scholarship 18,750.00 - 8,730.20 8,085.68 - 10,664.32 43.12% Other Events 14,000.00 1,925.00 16,059.21 4,709.26 - 9,290.74 33.64% TOTAL CULTURAL 142,950.00 6,648.12 43,014.63 17,835.56 5,785.72 119,328.72 16.52% TOTAL EXPENDITURES 153,800.00 6,648.12 43,014.63 17,835.56 5,785.72 130,178.72 15.36% REVENUE OVER(UNDER) EXPEND - 1,225.28 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 22 Cash in Bank Claim on Operating Cash Pool-Checking 69,790.81$ Cash in Investments Texas Class- Special Events 16,787.72 Total Cash in Bank & Investments 86,578.53$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 SPECIAL EVENTS FUND 23 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 119,572.00 - 23,215.15 12,864.97 - 106,707.03 10.76% Fund Transfers 109,428.00 - - - - 109,428.00 0.00% TOTAL REVENUES 229,000.00 - 23,215.15 12,864.97 - 216,135.03 5.62% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 229,000.00 15,444.66 29,700.01 15,444.66 2,762.70 210,792.64 7.95% TOTAL GENERAL GOVERNMENT 229,000.00 15,444.66 29,700.01 15,444.66 2,762.70 210,792.64 7.95% TOTAL EXPENDITURES 229,000.00 15,444.66 29,700.01 15,444.66 2,762.70 210,792.64 7.95% REVENUE OVER(UNDER) EXPEND - (2,579.69) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 24 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421350 Time Warner - PEG Fee 78,772 - 12,938.19 12,864.97 - 65,907.03 16.33% 000-421465 AT&T PEG Fee 40,800 - 10,276.96 - - 40,800.00 0.00% TOTAL Franchises 119,572 - 23,215.15 12,864.97 - 106,707.03 10.76% Fund Transfers 000-481000 Transfer In - Reserves 109,428 - - - - 109,428.00 0.00% TOTAL Fund Transfers 109,428 - - - - 109,428.00 0.00% TOTAL REVENUES 229,000 - 23,215.15 12,864.97 - 216,135.03 5.62% 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: DECEMBER 31st, 2014 25 Cash in Bank Cash Balance 462,984.49$ Total Cash in Bank & Investments 462,984.49$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 PEG FUND 26 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 211,813 - 2,500.00 - - 211,813.00 0.00% Permits 60,000.00 - 19,069.49 21,185.19 - 38,814.81 35.31% Fees 17,169,500 1,462,457.92 4,064,163.34 4,378,366.43 - 12,791,133.57 25.50% Fund Transfers 276,425 11,426.08 31,079.01 34,278.24 - 242,146.76 12.40% Miscellaneous 142,940 1,065.10 173,053.64 33,265.86 - 109,674.14 23.27% TOTAL REVENUES 17,860,678 1,474,949.10 4,289,865.48 4,467,095.72 - 13,393,582.28 25.01% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 446,006 43,018.16 88,596.98 114,707.27 - 331,298.73 25.72% Supplies 4,600 176.47 182.98 831.91 - 3,768.09 18.09% Human Services 183 - - - - 183.00 0.00% City Support Services 24,098 - - 831.00 - 23,267.00 3.45% Utility Services 170 - - - - 170.00 0.00% Operations Support 123,000 14,905.05 29,106.45 29,911.70 - 93,088.30 24.32% Staff Support 7,300 95.76 320.07 138.32 547.64 6,614.04 9.40% Professional Services 62,000 5,416.40 5,905.40 16,261.75 - 45,738.25 26.23% Maintenance Services 13,440 840.00 5,040.00 1,780.00 3,260.00 8,400.00 37.50% Operating Equipment 1,550 - - - - 1,550.00 0.00% TOTAL BUSINESS OFFICE 682,347 64,451.84 129,151.88 164,461.95 3,807.64 514,077.41 24.66% W & S ADMINISTRATION Personnel Services 1,223,136 110,777.69 255,435.71 305,749.32 - 917,386.68 25.00% Supplies 195,150 (1,234.67) 84,235.61 2,428.83 39,085.25 153,635.92 21.27% Human Services 1,000 - 165.95 - - 1,000.00 0.00% City Support Services 150,103 - 30,813.04 35,027.56 625.00 114,450.44 23.75% Utility Services 3,454,440 239,095.70 601,121.96 703,465.81 115,763.50 2,635,210.69 23.72% Operations Support 9,250 269.20 990.35 549.94 7.40 8,692.66 6.03% Staff Support 31,150 1,172.33 5,787.37 5,596.85 1,405.69 24,147.46 22.48% City Assistance 1,900 - 417.25 - - 1,900.00 0.00% Professional Services 249,113 6,445.63 105,920.97 19,479.16 - 229,633.84 7.82% Fund Charges/Transfers 3,594,442 413,896.20 1,350,310.85 1,141,688.60 - 2,452,753.40 31.76% Maintenance Services 6,496,250 907,337.30 1,298,441.56 1,370,034.22 2,109.20 5,124,106.58 21.12% Other Costs 35,000 27,150.20 27,150.20 27,150.20 - 7,849.80 77.57% ******************************************************* 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: DECEMBER 31st, 2014 27 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 Debt Service 1,534,512 - 966.67 - - 1,534,512.00 0.00% Rental-Leasing 6,070 115.50 455.45 709.61 2,077.68 3,282.71 45.92% Operating Equipment 21,200 4,984.20 3,623.91 6,525.13 9,054.98 5,619.89 73.49% Capital Outlay 123,500 - - - - 123,500.00 0.00% TOTAL PUBLIC WORKS 17,126,216 1,710,009.28 3,765,836.85 3,618,405.23 170,128.70 13,337,682.07 22.12% TOTAL EXPENDITURES 17,808,563 1,774,461 3,894,989 3,782,867 173,936 13,851,759 22.22% ** REVENUE OVER(UNDER)EXPENSES **52,115 684,228.54 28 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000-421490 Tower Leasing 211,813 - 2,500.00 - - 211,813.00 0.00% TOTAL Franchises 211,813 - 2,500.00 - - 211,813.00 0.00% Permits 000-432400 Development Permit 60,000 - 19,069.49 21,185.19 - 38,814.81 35.31% TOTAL Permits 60,000 - 19,069.49 21,185.19 - 38,814.81 35.31% Fees 000-455200 Garbage Collection Fee 4,000,000 341,588.02 1,040,673.52 1,032,853.32 - 2,967,146.68 25.82% 000-455600 Fire Line Fees 25,000 - 23,985.00 25,920.00 - (920.00) 103.68% 000-455700 Recycle Fee Revenue 270,000 22,545.62 63,934.85 67,407.93 - 202,592.07 24.97% 000-455800 W&S Line Constructn Reimbursemnt 25,000 2,134.00 2,882.00 5,661.00 - 19,339.00 22.64% 000-457100 Sale of Water 8,100,000 582,546.93 1,815,149.58 1,940,646.17 - 6,159,353.83 23.96% 000-457110 Edwards Water Lease 127,000 97,335.00 82,124.07 97,335.00 - 29,665.00 76.64% 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 6,286.38 7,662.00 17,448.14 - 72,551.86 19.39% 000-457400 Sewer Charges 4,250,000 390,712.06 951,215.25 1,133,764.81 - 3,116,235.19 26.68% 000-457500 Water Penalties 200,000 19,109.91 53,958.15 56,680.06 - 143,319.94 28.34% 000-459200 NSF Check Fee-Water&Sewer 2,500 200.00 785.00 650.00 - 1,850.00 26.00% TOTAL Fees 17,169,500 1,462,457.92 4,064,163.34 4,378,366.43 - 12,791,133.57 25.50% Fund Transfers 000-486204 Interfnd Chrg-Drainage Bill 137,113 11,426.08 31,079.01 34,278.24 - 102,834.76 25.00% 000-486411 Transfer In-Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 276,425 11,426.08 31,079.01 34,278.24 - 242,146.76 12.40% ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** AS OF: DECEMBER 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 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** AS OF: DECEMBER 31st, 2014 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 700 100.00 205.00 223.00 - 477.00 31.86% 000-491000 Interest Earned 1,500 55.94 380.89 311.30 - 1,188.70 20.75% 000-491200 Investment Income 10,000 317.75 268.91 813.94 - 9,186.06 8.14% 000-496050 SSLG - SAWS Reservation - - 134,500.00 - - - 0.00% 000-497000 Misc Income-W&S 20,000 591.41 11,526.21 3,228.49 - 16,771.51 16.14% 000-498110 Reimbursement-SSLGC 110,740 - 26,096.67 28,689.13 - 82,050.87 25.91% 000-498300 Reimbursement-City Property - - 75.96 - - - 0.00% TOTAL Miscellaneous 142,940 1,065.10 173,053.64 33,265.86 - 109,674.14 23.27% TOTAL REVENUES 17,860,678 1,474,949.10 4,289,865.48 4,467,095.72 - 13,393,582.28 25.01% 30 Cash in Bank Claim on Operating Cash Pool-Checking 1,057,130.30$ Cash in Investments Lone Star Investment-Water&Sewer 1,939,122.72 Lone Star Investment-W&S Customer Deposits 295,422.06 Lone Star Investment-W&S Equip Replacement 177,621.59 Lone Star Investment-W&S Veh Replacement 256,590.57 Lone Star Investment-Water/SSLGC SAWS 810,108.71 Schertz Bank & Trust-Certificate of Deposit 1,064,372.78 4,543,238.43$ Total Cash in Bank & Investments 5,600,368.73$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 WATER & SEWER 31 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,416,343 526,136.98 1,329,290.35 1,467,956.30 - 4,948,386.70 22.88% Inter-Jurisdictional 1,601,076 387,005.50 414,199.38 409,777.60 - 1,191,298.40 25.59% Miscellaneous 169,500 14,078.62 40,112.07 38,217.95 - 131,282.05 22.55% TOTAL REVENUES 8,186,919 927,221.10 1,783,601.80 1,915,951.85 - 6,270,967.15 23.40% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,036,899 342,251.82 676,834.69 836,738.06 - 2,200,160.94 27.55% Supplies 378,284 31,036.80 78,075.20 63,960.41 63,482.38 250,841.21 33.69% Human Services 1,000 324.00 - 324.00 - 676.00 32.40% City Support Services 110,052 - 17,826.32 14,617.51 - 95,434.49 13.28% Utility Services 154,500 11,407.37 23,547.63 21,913.86 - 132,586.14 14.18% Operations Support 62,555 1,990.80 28,568.57 25,552.68 1,302.97 35,699.35 42.93% Staff Support 85,786 8,150.37 17,335.53 11,999.99 29,371.88 44,414.13 48.23% City Assistance 11,900 978.50 79.39 1,149.50 1,958.75 8,791.75 26.12% Professional Services 147,080 7,744.16 41,638.95 34,859.36 7,673.39 104,547.25 28.92% Fund Charges/Transfers 3,366,084 23,739.50 357,086.08 402,679.59 - 2,963,404.41 11.96% Maintenance Services 59,500 860.00 4,540.58 860.00 2,327.79 56,312.21 5.36% Debt Service 270,820 - - - - 270,820.00 0.00% Rental-Leasing 81,541 - - - - 81,541.00 0.00% Operating Equipment 281,500 6,365.37 7,664.02 26,799.39 89,461.50 165,239.11 41.30% Capital Outlay 104,000 - - - - 104,000.00 0.00% TOTAL PUBLIC SAFETY 8,151,501 434,848.69 1,253,196.96 1,441,454.35 195,578.66 6,514,467.99 20.08% TOTAL EXPENDITURES 8,151,501 434,848.69 1,253,196.96 1,441,454.35 195,578.66 6,514,467.99 20.08% ** REVENUE OVER(UNDER) EXPENSES **35,418 474,497.50 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 32 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 6,249,943 508,873.48 1,290,159.13 1,434,994.61 - 4,814,948.39 22.96% 000-456110 Subscription Program Fees 40,000 4,605.00 17,650.00 7,325.00 - 32,675.00 18.31% 000-456120 EMT Class - Fees 104,400 9,807.50 16,534.00 21,223.45 - 83,176.55 20.33% 000-456130 Immunization Fees - - - - - - 0.00% 000-456140 Billing Fees - Alamo Heights 22,000 2,851.00 4,922.22 4,258.24 - 17,741.76 19.36% 000-458110 Sales of Merchandise - GovDeal - - - 155.00 - (155.00) 0.00% 000-459200 NSF Check Fee - - 25.00 - - - 0.00% TOTAL Fees 6,416,343 526,136.98 1,329,290.35 1,467,956.30 - 4,948,386.70 22.88% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 286,126 71,531.64 95,375.52 71,531.64 - 214,594.36 25.00% 000-474300 Cibolo Support 261,370 65,348.25 63,439.20 65,348.25 - 196,021.75 25.00% 000-475100 Comal Co ESD #6 95,217 - 22,772.10 22,772.10 - 72,444.90 23.92% 000-475200 Live Oak Support 179,608 47,392.50 43,594.20 47,392.50 - 132,215.50 26.39% 000-475300 Universal City Support 247,353 61,843.88 60,037.20 61,843.88 - 185,509.12 25.00% 000-475400 Selma Support 73,952 18,489.75 17,949.60 18,489.75 - 55,462.25 25.00% 000-475500 Schertz Support 433,542 116,422.01 105,228.72 116,422.01 - 317,119.99 26.85% 000-475600 Santa Clara Support 9,678 2,419.69 2,349.00 2,419.69 - 7,258.31 25.00% 000-475800 Marion Support 14,230 3,557.78 3,453.84 3,557.78 - 10,672.22 25.00% TOTAL Inter-Jurisdictional 1,601,076 387,005.50 414,199.38 409,777.60 - 1,191,298.40 25.59% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 33 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% 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: DECEMBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** Miscellaneous 000-491000 Interest Earned - - - 11.08 - (11.08) 0.00% 000-493203 Donations-EMS 2,000 490.00 - 490.00 - 1,510.00 24.50% 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 12,560.51 38,552.77 36,403.76 - 108,596.24 25.11% 000-497100 Recovery of Bad Debt 10,000 1,028.11 1,559.30 1,313.11 - 8,686.89 2.75% TOTAL Miscellaneous 169,500 14,078.62 40,112.07 38,217.95 - 131,282.05 22.55% TOTAL REVENUES 8,186,919 927,221.10 1,783,601.80 1,915,951.85 - 6,270,967.15 23.40% 34 Cash in Bank Claim on Operating Cash Pool-Checking (184,225.49)$ Total Cash in Bank & Investments (184,225.49)$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 SCHERTZ EMS 35 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000 340.00 620.00 640.00 - 2,360.00 0.00% Fees 1,155,500 89,829.75 265,130.54 268,392.35 - 887,107.65 40.45% Miscellaneous 700 71.63 333.81 255.14 - 444.86 16.25% TOTAL REVENUES 1,159,200 90,241.38 266,084.35 269,287.49 - 889,912.51 40.49% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 453,529 43,773.85 85,458.68 121,700.60 - 331,828.40 26.83% Supplies 8,300 197.45 939.01 898.11 314.88 7,087.01 14.61% Human Services 325 - - - - 325.00 0.00% City Support Services 30,432 - 2,166.61 2,306.64 - 28,125.36 7.58% Utility Services 30,370 1,503.86 4,144.64 4,310.75 361.07 25,698.18 15.38% Operations Support 2,460 - - 20.48 - 2,439.52 0.83% Staff Support 8,116 493.58 836.08 836.16 778.70 6,501.14 19.90% City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 - - 198.00 - 23,302.00 0.84% Fund Charges/Transfers 221,818 18,401.49 49,126.02 55,204.47 - 166,613.53 24.89% Maintenance Services 22,000 - (10,000.00) 68.00 125.00 21,807.00 0.88% Other costs 200 - - - 100.00 100.00 50.00% Debt Service 140,530 - - - - 140,530.00 0.00% Rental/Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 560.00 - 560.00 3,000.00 1,940.00 64.73% Capital Outlay - - - - - - 0.00% TOTAL DRAINAGE 948,420 64,930.23 132,671.04 186,103.21 4,679.65 757,637.14 20.12% PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 - - - - 1,000.00 0.00% Professional Services 7,700 5,133.00 7,630.00 5,133.00 8,000.00 (5,433.00) 170.56% Maintenance Services 134,298 - - 3,287.67 303.59 130,706.74 2.67% TOTAL PROJECTS 146,198 5,133.00 7,630.00 8,420.67 8,303.59 129,473.74 11.44% TOTAL EXPENDITURES 1,094,618 70,063.23 140,301.04 194,523.88 12,983.24 887,110.88 18.96% ** REVENUE OVER(UNDER) EXPEND 64,582 74,763.61 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 36 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000 340.00 620.00 640.00 - 2,360.00 21.33% TOTAL Permits 3,000 340.00 620.00 640.00 - 2,360.00 21.33% Fees 000-457500 Drainage Penalties 8,000 716.10 2,231.87 2,263.73 - 5,736.27 28.30% 000-457600 Drainage Fee 1,147,500 89,113.65 262,898.67 266,128.62 - 881,371.38 23.19% TOTAL Fees 1,155,500 89,829.75 265,130.54 268,392.35 - 887,107.65 23.23% Miscellaneous 000-491000 Interest Earned 100 - 38.52 45.52 - 54.48 45.52% 000-491200 Investment Interest 500 71.63 235.29 209.62 - 290.38 41.92% 000-497000 Misc Income-Drainage 100 - 60.00 - - 100.00 0.00% TOTAL Miscellaneous 700 71.63 333.81 255.14 - 444.86 36.45% TOTAL REVENUES 1,159,200 90,241.38 266,084.35 269,287.49 - 889,912.51 23.23% 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: DECEMBER 31st, 2014 37 Cash in Bank Claim on Operating Cash Pool-Checking 538,950.02 Cash in Investments Lone Star Investment-Drainage Maint Fund 605,928.48 Total Cash in Bank & Investments 1,144,878.50$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 38 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 544,753 32,606.01 44,468.61 115,423.12 - 429,329.88 21.19% Miscellaneous 600 24.18 94.64 88.22 - 511.78 14.70% TOTAL REVENUES 545,353 32,630.19 44,563.25 115,511.34 - 429,841.66 21.18% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - - - - 2,500.00 0.00% City Support Services 61,500 14,350.90 20,407.50 14,350.90 - 47,149.10 23.33% Operations Support 69,500 2,386.00 6,711.60 2,786.00 - 66,714.00 4.01% Professional Services 5,825 - - - - 5,825.00 0.00% Fund Charges/Transfers 126,405 5,533.75 36,346.26 16,601.25 - 109,803.75 13.13% Maintenance Services - - - - - - 0.00% Operating Equipment 37,000 - 3,269.00 - 1,712.60 35,287.40 4.63% TOTAL NONDEPARTMENTAL 302,730 22,270.65 66,734.36 33,738.15 1,712.60 267,279.25 11.71% TOTAL EXPENDITURES 302,730 22,270.65 66,734.36 33,738.15 1,712.60 267,279.25 11.71% REVENUE OVER(UNDER) EXPENDITURE 242,623 81,773.19 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 39 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411800 Hotel Occupancy Tax 544,753 32,606.01 44,468.61 115,423.12 - 429,329.88 21.19% TOTAL Taxes 544,753 32,606.01 44,468.61 115,423.12 - 429,329.88 21.19% Miscellaneous 000-491000 Interest Earned 100 - 23.32 16.46 - 83.54 16.46% 000-491200 Investment Interest 500 24.18 71.32 71.76 - 428.24 14.35% TOTAL Miscellaneous 600 24.18 94.64 88.22 - 511.78 14.70% TOTAL REVENUES 545,353 32,630.19 44,563.25 115,511.34 - 429,841.66 21.18% 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: DECEMBER 31st, 2014 40 Cash in Bank Claim on Operating Cash Pool-Checking 246,417.89$ Cash in Investments MBIA - Hotel Tax 299,258.60 Total Cash in Bank & Investments 545,676.49$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 HOTEL OCCUPANCY TAX FUND 41 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 44,724 42,229 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 $- $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 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 100,000 - 35,950.00 - - 100,000.00 0.00% Miscellaneous - 0.05 3.94 17.22 - (17.22) 0.00% TOTAL REVENUES 100,000 0.05 35,953.94 17.22 - 99,982.78 0.02% EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 32,405 - - - - 32,405.00 0.00% Capital Outlay 60,000 - - - - 60,000.00 0.00% TOTAL PARKLAND DEDICATION 92,405 - - - - 92,405.00 0.00% TOTAL EXPENDITURES 92,405 - - - - 92,405.00 0.00% REVENUE OVER(UNDER) EXPEND 7,595 17.22 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 43 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 100,000 - 35,950.00 - - 100,000.00 0.00% TOTAL Fees 100,000 - 35,950.00 - - 100,000.00 0.00% Miscellaneous 000-491000 Interest Earned - - 2.84 17.06 - (17.06) 0.00% 000-491200 Investment Interest - 0.05 1.10 0.16 - (0.16) 0.00% 000-497000 Misc Income - - - - - - 0.00% TOTAL Miscellaneous - 0.05 3.94 17.22 - (17.22) 0.00% TOTAL REVENUES 100,000 0.05 35,953.94 17.22 - 99,982.78 0.02% 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: DECEMBER 31st, 2014 44 Cash in Bank Claim on Operating Cash Pool-Checking $190,809.66 Cash in Investments Texas Class- Park Fund 1,354.84 Total Cash in Bank & Investments $192,164.50 CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 PARK FUND 45 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 36,000 1,870.00 177,437.50 65,475.00 - (29,475.00) 181.88% Fund Transfers 80,125 - - - - 80,125 0.00% Miscellaneous 210 7.80 55.22 51.22 - 158.78 24.39% TOTAL REVENUES 116,335 1,877.80 177,492.72 65,526.22 - 50,808.78 56.33% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services-Trees 116,125 300.00 - 300.00 24,300.00 91,525.00 21.18% TOTAL TREE MITIGATION 116,125 300.00 - 300.00 24,300.00 91,525.00 21.18% TOTAL EXPENDITURES 116,125 300.00 - 300.00 24,300.00 91,525.00 21.18% REVENUE OVER(UNDER) EXPEND 210 65,226.22 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 46 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 36,000 1,870.00 177,437.50 65,475.00 - (29,475.00) 181.88% TOTAL Fees 36,000 1,870.00 177,437.50 65,475.00 - (29,475.00) 181.88% 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 - 32.16 28.06 - 61.94 31.18% 000-491200 Investment Interest 120 7.80 23.06 23.16 - 96.84 19.30% TOTAL Miscellaneous 210 7.80 55.22 51.22 - 158.78 24.39% TOTAL REVENUES 116,335 1,877.80 177,492.72 65,526.22 - 50,808.78 56.33% 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: DECEMBER 31st, 2014 47 Cash in Bank Claim on Operating Cash Pool-Checking $327,068.83 Cash in Investments MBIA Investment-Tree Mitigation 97,362.50 Total Cash in Bank & Investments $424,431.33 CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 TREE MITIGATION FUND 48 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 880,200 82,152.00 112,959.00 253,791.00 - 626,409.00 28.83% Fund Transfers - - - - - - 0.00% Miscellaneous 5,300 436.71 1,502.73 1,386.89 - 3,913.11 26.17% TOTAL REVENUES 885,500 82,588.71 114,461.73 255,177.89 - 630,322.11 28.82% 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 255,178 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 49 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 880,200 82,152.00 112,959.00 253,791.00 - 626,409.00 28.83% TOTAL Fees 880,200 82,152.00 112,959.00 253,791.00 - 626,409.00 28.83% Miscellaneous 000-491000 Interest Earned 300 - 68.17 108.86 - 191.14 36.29% 000-491200 Investment Income 5,000 436.71 1,434.56 1,278.03 - 3,721.97 25.56% TOTAL Miscellaneous 5,300 436.71 1,502.73 1,386.89 - 3,913.11 26.17% TOTAL REVENUES 885,500 82,588.71 114,461.73 255,177.89 - 630,322.11 28.82% 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: DECEMBER 31st, 2014 50 Cash in Bank Claim on Operating Cash Pool-Checking 1,380,855.33$ Cash in Investments Lone Star Investment-Capital Recovery Water 3,694,310.11 Total Cash in Bank & Investments 5,075,165.44$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 CAPITAL RECOVERY WATER 51 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,400 62,603.76 139,316.04 137,114.64 - 463,285.36 22.84% Fund Transfers 559,497 - - - - 559,497.00 0.00% Miscellaneous 600 (2,484.14) 2,408.49 1,810.84 - (1,210.84) 301.81% TOTAL REVENUES 1,160,497 60,119.62 141,724.53 138,925.48 - 1,021,571.52 11.97% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,143 357.97 1,068.40 1,073.97 - 2,069.03 34.17% Fund Charges/Transfers 139,312 - - - - 139,312.00 0.00% TOTAL NON DEPARTMENTAL 142,455 357.97 1,068.40 1,073.97 - 141,381.03 0.75% 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 357.97 1,068.40 1,073.97 - 1,159,423.03 0.09% REVENUE OVER(UNDER) EXPENDITURES - 137,852 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 52 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455910 Capital Recovery - Waste Wtr 500,400 46,403.76 95,450.04 113,714.64 - 386,685.36 22.72% 000-455913 Cap Recovery-North Sewer Tr 100,000 16,200.00 43,866.00 23,400.00 - 76,600.00 23.40% TOTAL Fees 600,400 62,603.76 139,316.04 137,114.64 - 463,285.36 22.84% 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 - 27.63 63.54 - 36.46 63.54% 000-491200 Investment Income 500 2,316.97 9,958.64 6,849.81 - (6,349.81) 1369.96% 000-491800 Gain/Loss - - (35,444.29) (78.68) - 78.68 0.00% 000-491900 Unrealized Gain/Loss-Cap One - (4,801.11) 27,866.51 (5,023.83) - 5,023.83 0.00% TOTAL Miscellaneous 600 (2,484.14) 2,408.49 1,810.84 - (1,210.84) 301.81% TOTAL REVENUES 1,160,497 60,119.62 141,724.53 138,925.48 - 1,021,571.52 11.97% 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: DECEMBER 31st, 2014 53 Cash in Bank Claim on Operating Cash Pool-Checking 806,771.34$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,452,185.07 Capital One-Investment 1,726,130.21 Total Cash in Bank & Investments 3,985,086.62$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 CAPITAL RECOVERY SEWER 54 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,338,513 2,558,632.31 2,971,554.07 2,974,847.19 - 2,363,665.81 55.72% Miscellaneous 368,763 117.09 246.48 252.04 - 368,510.96 0.07% TOTAL REVENUES 5,707,276 2,558,749.40 2,971,800.55 2,975,099.23 - 2,732,176.77 52.13% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 - 550.00 950.00 - 41,400.00 2.24% Debt Service 5,593,807 - - - - 5,593,807.00 0.00% TOTAL GENERAL GOVERNMENT 5,636,157 - 550.00 950.00 - 5,635,207.00 0.02% TOTAL EXPENDITURES 5,636,157 - 550.00 950.00 - 5,635,207.00 0.02% ** REVENUE OVER(UNDER) EXPEND 71,119 2,974,149.23 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 ****************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 55 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 25% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 5,338,513 2,558,632.31 2,971,554.07 2,974,847.19 - 2,363,665.81 55.72% TOTAL Taxes 5,338,513 2,558,632.31 2,971,554.07 2,974,847.19 - 2,363,665.81 55.72% Miscellaneous 000-491000 Interest Earned 75 - 43.64 4.24 - 70.76 5.65% 000-491200 Investment Earnings 1,500 117.09 202.84 247.80 - 1,252.20 16.52% 000-495015 Contribution from SED 367,188 - - - - 367,188.00 0.00% TOTAL Miscellaneous 368,763 117.09 246.48 252.04 - 368,510.96 0.07% TOTAL REVENUES 5,707,276 2,558,749.40 2,971,800.55 2,975,099.23 - 2,732,176.77 52.13% 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: DECEMBER 31st, 2014 56 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF NON DEPARTMENTAL BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101-541500 Paying Agent 2,350 - 550.00 950.00 - 1,400.00 40.43% 101-541502 Cost of Bond Issuance 40,000 - - - - 40,000.00 0.00% TOTAL Professional Services 42,350 - 550.00 950.00 - 41,400.00 2.24% 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 - 550.00 950.00 - 5,635,207.00 0.02% C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: DECEMBER 31st, 2014 ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** 57 Cash in Bank Claim on Operating Cash Pool-Checking 316,651.29$ Cash in Investments MBIA Investment- Tax I&S 3,316,674.37 Total Cash in Bank & Investments 3,633,325.66$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 TAX I&S 58 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 3,682,057 384,267.52 853,025.88 850,796.15 - 2,831,260.85 23.11% Miscellaneous 10,200 1,711.53 1,954.17 5,040.25 - 5,159.75 49.41% TOTAL REVENUES 3,692,257 385,979.05 854,980.05 855,836.40 - 2,836,420.60 23.18% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 364,312 11,582.70 68,793.52 39,035.97 - 325,276.03 10.71% Supplies 1,050 155.12 182.03 155.12 92.24 802.64 23.56% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 16,545 - 1,174.29 1,114.09 - 15,430.91 6.73% Utility Services 4,120 103.68 388.10 214.82 - 3,905.18 5.21% Operations Support 147,145 341.99 52,976.89 50,912.73 27.00 96,205.27 34.62% Staff Support 18,250 1,050.00 2,304.86 1,336.32 - 16,913.68 7.32% City Assistance 1,025,000 - - - - 1,025,000.00 0.00% Professional Services 92,500 331.50 - 331.50 - 92,168.50 0.36% Fund Charges/Transfers 471,280 8,674.33 34,366.74 26,022.99 - 445,257.01 5.52% Debt Service 430,608 - - - - 430,608.00 0.00% Operating Equipment 2,000 - 19.99 - 79.59 1,920.41 3.98% TOTAL ECONO DEVELOPMENT 2,573,810 22,239.32 160,206.42 119,123.54 198.83 2,454,487.63 4.64% 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 22,239.32 160,206.42 119,123.54 198.83 2,904,487.63 3.95% ** REVENUE OVER(UNDER) EXPEND 668,447 736,712.86 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: DECEMBER 31st, 2014 59 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% 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 384,267.52 853,025.88 850,796.15 - 2,831,260.85 23.11% TOTAL Taxes 3,682,057 384,267.52 853,025.88 850,796.15 - 2,831,260.85 23.11% Miscellaneous 000-491000 Interest Earned 200 - 85.85 34.86 - 165.14 17.43% 000-491200 Investment Earnings 10,000 1,711.53 1,868.32 2,677.07 - 7,322.93 26.77% 000-497000 Misc Income - - - 2,328.32 - (2,328.32) 0.00% TOTAL Miscellaneous 10,200 1,711.53 1,954.17 5,040.25 - 5,159.75 49.41% TOTAL REVENUES 3,692,257 385,979.05 854,980.05 855,836.40 - 2,836,420.60 23.18% 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: DECEMBER 31st, 2014 60 Cash in Bank Claim on Operating Cash Pool-Checking 175,746.05$ Cash in Investments Texas Class Investment-Economic Development Corp 6,718,334.75 Schertz Bank & Trust-Certificate of Deposit 1,047,275.08 Total Cash in Bank & Investments 7,941,355.88$ CASH IN BANK AND INVESTMENTS AS OF: DECEMBER 31st, 2014 SED CORPORATION 61 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 247,750 319,452 252,513 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% -8.9% $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 4B SALES TAX 62