The URL can be used to link to this page

02-NOVEMBER 2014 FINANCIAL STATEMENT NOVEMBER 2014 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department FEBRUARY 27, 2015 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 16,665,690 787,589.43 1,890,913.29 1,670,772.71 - 14,994,917.29 10.03% Franchises 1,986,159 130,577.80 287,295.57 299,740.12 - 1,686,418.88 15.09% Permits 1,175,803 91,758.00 133,672.40 222,633.00 - 953,170.00 18.93%Licenses 91,229 3,605.00 8,797.50 7,675.00 - 83,554.00 8.41% Fees 2,814,366 156,035.98 420,142.10 394,245.79 - 2,420,120.21 14.01% Fines 31,000 2,167.18 4,652.88 4,551.72 (41.92) 26,490.20 14.55%Inter-Jurisdictional 708,392 90,421.79 62,314.87 100,670.48 - 607,721.52 14.21% Fund Transfers 1,759,754 141,042.08 292,193.66 282,084.16 - 1,477,669.84 16.03% Miscellaneous 462,650 32,195.94 77,700.47 259,045.18 - 203,604.82 55.99% TOTAL REVENUES 25,695,043 1,435,393.20 3,177,682.74 3,241,418.16 (41.92) 22,453,666.76 12.61% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 1,813.46 3,880.37 3,050.49 - 20,524.51 12.94% Supplies 1,800 - 192.45 - 25.35 1,774.65 1.41% City Support Services 40,600 - 3,704.51 - 5,426.30 35,173.70 13.37% Operations Support 400 - - - - 400.00 0.00%Staff Support 21,300 3,072.53 4,532.24 3,025.53 4,138.00 14,136.47 33.63% TOTAL CITY COUNCIL 87,675 4,885.99 12,309.57 6,076.02 9,589.65 72,009.33 17.87% CITY MANAGER Personnel Services 832,380 74,813.63 142,511.70 119,720.29 - 712,659.71 14.38% Supplies 3,000 - 332.07 153.47 16.21 2,830.32 5.66% City Support Services 2,770 1,362.50 1,162.50 1,362.50 - 1,407.50 49.19% Staff Support 27,975 1,645.03 1,556.89 2,635.41 1,147.12 24,192.47 13.52% Professional Services - - - - - - 0.00% TOTAL CITY MANAGER 866,125 77,821.16 145,563.16 123,871.67 1,163.33 741,090.00 14.44% *************************************************** 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: NOVEMBER 30th, 2014 1 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 MUNICIPAL COURT Personnel Services 301,231 28,585.28 43,337.04 42,999.14 - 258,231.86 14.27%Supplies 3,500 89.75 90.00 89.75 19.96 3,390.29 3.13% 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 145.63 427.20 145.63 721.89 6,842.48 11.25% Court Support 700 - - - - 700.00 0.00% Professional Services 68,200 4,552.50 8,603.41 7,167.50 27,937.50 33,095.00 51.47%Maintenance Services 2,800 50.00 50.00 200.00 1,600.00 1,000.00 64.29%Operating Equipment 800 - - - - 800.00 0.00% TOTAL MUNICIPAL COURT 390,441 33,423.16 52,597.65 50,602.02 30,279.35 309,559.63 20.72% CUSTOMER RELATIONS-311 Personnel Services 113,241 12,027.41 16,526.36 17,497.67 - 95,743.33 15.45% Supplies 200 - 13.46 - - 200.00 0.00%Staff Support 750 - - - - 750.00 0.00% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS-311 114,691 12,027.41 16,539.82 17,497.67 - 97,193.33 15.26% PLANNING & ZONING Personnel Services 133,705 12,041.72 17,684.49 18,945.34 - 114,759.66 14.17% Supplies 2,672 4.32 27.50 4.32 33.62 2,634.06 1.42% Operations Support 750 - - - - 750.00 0.00% Staff Support 19,950 302.33 21.03 363.80 65.00 19,521.20 2.15% Professional Services 300 - - - - 300.00 0.00%Operating Equipment 450 - - - - 450.00 0.00% TOTAL PLANNING & ZONING 157,827 12,348.37 17,733.02 19,313.46 98.62 138,414.92 12.30% LEGAL SERVICES Operations Support 10,000 37.44 - 37.44 84.76 9,877.80 1.22% Professional Services 350,000 330.00 - 330.00 - 349,670.00 0.09% TOTAL LEGAL SERVICES 360,000 367.44 - 367.44 84.76 359,547.80 0.13% 2 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 GENERAL SERVICES Personnel Services 578,049 62,216.32 94,357.27 97,886.13 - 480,162.87 16.93%Supplies 60,425 2,051.16 2,993.87 3,305.13 2,367.37 54,752.50 9.39% Utility Services 99,880 465.26 7,629.80 5,410.86 62.50 94,406.64 5.48% Staff Support 11,749 654.18 721.95 674.79 512.69 10,561.52 10.11%Maintenance Services 31,900 4,039.91 308.25 4,039.91 776.14 27,083.95 15.10%Operating Equipment 10,800 - 4,763.90 - - 10,800.00 0.00% Capital Outlay - - - - - - 0.00% TOTAL GENERAL SERVICES 792,803 69,426.83 110,775.04 111,316.82 3,718.70 677,767.48 14.51% BUILDING 6-8 MAINTENANCE Supplies 30,250 1,345.01 3,045.22 1,609.29 1,640.88 26,999.83 10.74% Utility Services 89,235 - 7,328.97 4,568.41 - 84,666.59 5.12% Maintenance Services 58,700 4,873.15 4,869.62 4,873.15 4,680.91 49,145.94 16.28% Operating Equipment 23,000 - - - 1,049.93 21,950.07 4.56% TOTAL BUILDING 6-8 MAINTENANCE 201,185 6,218.16 15,243.81 11,050.85 7,371.72 182,762.43 9.16% CITY SECRETARY Personnel Services 167,772 15,452.99 22,702.11 24,381.83 - 143,390.17 14.53% Supplies 1,200 41.46 87.96 246.36 53.59 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 192.10 721.06 432.10 - 8,362.90 4.91% TOTAL CITY SECRETARY 187,617 15,686.55 23,511.13 25,060.29 53.59 162,503.12 13.39% NON-DEPARTMENTAL City Support Services 860,000 - 146,823.64 140,262.23 41,742.20 677,995.57 21.16% Operations Support 141,500 5,364.86 8,484.45 15,660.49 - 125,839.51 11.07% Staff Support 150 80.00 - 80.00 - 70.00 53.33% City Assistance 1,243,779 - - - - 1,243,779.00 0.00% Professional Services 262,400 3,531.09 5,070.32 6,667.91 - 255,732.09 2.54%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 8,975.95 160,378.41 162,670.63 41,742.20 2,556,416.17 7.40% 3 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 PUBLIC AFFAIRS Personnel Services 257,970 21,921.44 27,784.40 32,841.54 - 225,128.46 12.73%Supplies 3,500 122.86 402.14 122.86 - 3,377.14 3.51% Operations Support 26,000 842.50 906.36 842.50 47.00 25,110.50 3.42% Staff Support 5,150 18.00 480.07 293.00 - 4,857.00 5.69%Professional Services 13,500 - 250.00 - - 13,500.00 0.00%Operating Equipment 2,100 - - - - 2,100.00 0.00% TOTAL PUBLIC AFFAIRS 308,220 22,904.80 29,822.97 34,099.90 47.00 274,073.10 11.08% RECORDS MANAGEMENT Personnel Services 51,106 6,051.52 7,941.31 8,748.40 - 42,357.60 17.12%Supplies 400 - - - 46.76 353.24 11.69% Staff Support 1,750 596.40 - 756.89 - 993.11 43.25% Professional Services 10,000 1,136.00 354.00 1,647.00 - 8,353.00 16.47% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 63,256 7,783.92 8,295.31 11,152.29 130.53 51,973.18 17.84% SCHERTZ MAGAZINE Personnel Services 137,208 12,809.24 19,017.13 20,382.58 - 116,825.42 14.86% Supplies 200 - - - - 200.00 0.00% Opperations Support 100 - - - - 100.00 0.00% Staff Support 3,000 18.00 33.00 18.00 - 2,982.00 0.60% Professional Services 253,500 19,093.57 22,980.48 23,006.27 7,844.24 222,649.49 12.17% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - - - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 404,608 31,920.81 42,030.61 43,406.85 7,844.24 353,356.91 12.67% ENGINEERING Personnel Services 282,558 14,311.25 14,091.48 23,005.11 - 259,552.89 8.14%Supplies 1,300 54.61 - 145.26 142.49 1,012.25 22.13% City Support Services 1,500 - - - - 1,500.00 0.00% Utility Services 1,498 41.66 193.63 41.66 - 1,456.34 2.78% Staff Support 10,512 24.85 - 24.85 - 10,487.15 0.24% Professional Services 38,800 - 6,958.75 - - 38,800.00 0.00% Operating Equipment 600 - - - - 600.00 0.00% TOTAL ENGINEERING 336,768 14,432.37 21,243.86 23,216.88 142.49 313,408.63 6.94% 4 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 GIS Personnel Services 135,495 13,504.26 19,262.42 20,992.08 - 114,502.92 15.49%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,504.26 19,262.42 20,992.08 - 133,802.92 13.56% TOTAL GENERAL GOVERNMENT 7,186,840 331,727.18 675,306.78 660,694.87 102,266.18 6,423,878.95 10.62% PUBLIC SAFETY POLICE Personnel Services 4,983,836 498,045.60 732,718.78 790,738.44 - 4,193,097.56 15.87% Supplies 47,646 11,305.42 2,160.97 11,305.42 4,423.91 31,916.67 33.01%City Support Services 26,750 - 26,721.66 23,151.52 - 3,598.48 86.55% Utility Services 148,064 8,825.96 11,190.49 8,825.96 - 139,238.04 5.96% Operations Support 2,950 - 38.75 - - 2,950.00 0.00%Staff Support 109,423 2,109.27 10,083.17 3,513.85 19,147.11 86,762.04 20.71% City Assistance 10,200 262.20 837.15 262.20 - 9,937.80 2.57% Professional Services 53,313 4,835.50 - 5,138.31 1,513.98 46,660.71 12.48%Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 53,790 1,002.74 9,972.50 1,002.74 2,956.22 49,831.04 7.36% Operating Equipment 108,868 3,628.35 1,378.03 3,878.35 9,676.75 95,312.90 12.45% Capital Outlay 218,754 30,000.00 - 30,000.00 25,175.00 163,579.00 25.22% TOTAL POLICE 5,763,594 560,015.04 795,101.50 877,816.79 62,892.97 4,822,884.24 16.32% FIRE RESCUE Personnel Services 2,890,145 293,409.31 423,419.37 470,303.77 85.00 2,419,756.23 16.28% Supplies 16,500 474.78 1,040.00 474.78 221.00 15,804.22 4.22% Utility Services 58,700 3,784.88 6,164.26 4,253.58 - 54,446.42 7.25% Operations Support 1,200 - - - - 1,200.00 0.00% Staff Support 115,700 3,243.56 9,830.67 7,464.95 11,907.63 96,327.42 16.74% City Assistance 16,200 - - - - 16,200.00 0.00% Professional Services 25,000 - - - - 25,000.00 0.00% Maintenance Services 58,932 617.54 1,005.55 617.54 5,880.73 52,433.73 11.03% Rental/Leasing 14,000 - - - - 14,000.00 0.00%Operating Equipment 65,900 344.99 126.13 344.99 875.21 64,679.80 1.85% Capital Outlay 210,600 - - - - 210,600.00 0.00% TOTAL FIRE RESCUE 3,472,877 301,875.06 441,585.98 483,459.61 18,969.57 2,970,447.82 14.47% 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 INSPECTIONS Personnel Services 530,804 44,429.47 68,116.47 66,760.51 - 464,043.49 12.58% Supplies 2,938 154.10 78.30 154.10 220.41 2,563.49 12.75% Utility Services 6,500 428.95 594.03 428.95 - 6,071.05 6.60%Operations Support 2,200 401.49 248.00 401.49 - 1,798.51 18.25% Staff Support 13,850 100.00 261.60 223.50 213.16 13,413.34 3.15% Professional Services - - - - - - 0.00%Operating Equipment 28,520 - - - - 28,520.00 0.00% TOTAL INSPECTIONS 584,812 45,514.01 69,298.40 67,968.55 433.57 516,409.88 11.70% MARSHAL'S OFFICE Personnel Services 570,071 63,637.02 89,486.33 96,385.08 - 473,685.92 16.91% Supplies 6,400 121.30 126.18 396.13 104.93 5,898.94 7.83% Utility Services 16,000 813.94 1,171.76 813.94 - 15,186.06 5.09% Operations Support 3,500 - 123.75 - 217.56 3,282.44 6.22% Staff Support 14,800 - 416.84 667.99 98.79 14,033.22 5.18% City Assistance 2,500 - - - - 2,500.00 0.00% Maintenance Services 17,700 - 180.00 - 650.00 17,050.00 3.67% Operating Equipment 19,700 90.98 178.25 90.98 4,931.47 14,677.55 25.49% Capital Outlay 8,000 - - - - 8,000.00 0.00% TOTAL MARSHAL'S OFFICE 658,671 64,663.24 91,683.11 98,354.12 6,002.75 554,314.13 15.84% TOTAL PUBLIC SAFETY 10,479,954 972,067.35 1,397,668.99 1,527,599.07 88,298.86 8,864,056.07 15.42% 6 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 PUBLIC ENVIRONMENT STREETS Personnel Services 691,780 71,906.31 114,387.76 122,707.02 - 569,072.98 17.74% Supplies 7,100 886.59 1,299.04 1,051.23 81.96 5,966.81 15.96% Utility Services 136,200 4,008.58 10,043.25 4,407.78 190.82 131,601.40 3.38%Staff Support 10,030 1,135.42 850.02 1,417.45 582.77 8,029.78 19.94% City Assistance 500 - - - - 500.00 0.00% Professional Services 40,000 - - - - 40,000.00 0.00%Maintenance Services 135,400 5,166.36 7,501.40 8,139.13 3,576.57 123,684.30 8.65% Rental/Lease 200 - - - 175.00 25.00 87.50% Operating Equipment 300 - - - - 300.00 0.00% Capital Outlay 28,000 - - - - 28,000.00 0.00% TOTAL STREETS 1,049,510 83,103.26 134,081.47 137,722.61 4,607.12 907,180.27 13.56% TOTAL PUBLIC ENVIRONMENT 1,049,510 83,103.26 134,081.47 137,722.61 4,607.12 907,180.27 13.56% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 533,103 44,578.71 76,803.92 69,910.02 - 463,192.98 13.11% Supplies 41,905 1,656.13 690.37 1,794.84 951.85 39,158.31 6.55%Utility Services 143,800 1,061.65 10,782.41 8,289.16 238.44 135,272.40 5.93% Operations Support 250 - - - - 250.00 0.00% Staff Support 8,473 778.96 612.39 921.76 614.83 6,936.41 18.14% Professional Services 72,000 2,461.00 2,461.00 2,461.00 3,691.50 65,847.50 8.55% Maintenance Services 20,000 29.80 24.00 29.80 141.36 19,828.84 0.86% Rental/Leasing 39,600 - 3,225.40 6,038.32 30,191.60 3,370.08 91.49% Operating Equipment 2,000 196.94 - 821.94 644.25 533.81 73.31%Capital Outlay 60,000 - - - - 60,000.00 0.00% TOTAL PARKS DEPARTMENT 921,131 50,763.19 94,599.49 90,266.84 36,473.83 794,390.33 13.76% SWIM POOL Supplies 20,700 253.62 27.74 253.62 3,997.46 16,448.92 20.54% Utility Services 29,000 - 1,889.03 1,217.04 - 27,782.96 4.20%Maintenance Services 203,378 - 461.49 - - 203,378.00 0.00% TOTAL SWIM POOL 253,078 253.62 2,378.26 1,470.66 3,997.46 247,609.88 2.16% 7 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 EVENT FACILITIES Personnel Services 58,642 4,769.53 7,428.20 7,618.48 - 51,023.52 12.99%Supplies 14,500 573.93 939.02 681.42 1,093.00 12,725.58 12.24% Utility Services 51,400 188.25 2,566.57 3,080.87 - 48,319.13 5.99% Operations Support 23,311 - 11.97 - 4,435.00 18,876.00 19.03%Staff Support 2,448 33.74 655.75 583.74 30.00 1,834.26 25.07% Professional Services 500 - 299.10 - - 500.00 0.00% Operating Equipment 5,000 - - - 431.26 4,568.74 8.63% TOTAL EVENT FACILITIES 155,801 5,565.45 11,900.61 11,964.51 5,989.26 137,847.23 11.52% SENIOR CITIZEN CENTER Supplies 7,650 401.28 - 540.99 877.03 6,231.98 18.54% Utility Services 4,240 - - - - 4,240.00 0.00% Operations Support 1,500 - - - - 1,500.00 0.00% City Assistence 20,000 2,228.63 - 2,228.63 1,551.30 16,220.07 18.90% Professional Services 8,000 250.00 - 250.00 - 7,750.00 3.13% Maintenance Services 5,000 158.58 393.92 239.08 80.50 4,680.42 6.39% TOTAL SENIOR CITIZEN CENTER 46,390 3,038.49 393.92 3,258.70 2,508.83 40,622.47 12.43% TOTAL PARKS & RECREATION 1,376,400 59,620.75 109,272.28 106,960.71 48,969.38 1,220,469.91 11.33% CULTURAL LIBRARY Personnel Services 672,828 59,157.52 108,646.32 90,788.77 - 582,039.23 13.49% Supplies 13,500 50.00 928.57 73.96 2,955.66 10,470.38 22.44% Utility Services 56,500 - 4,199.26 3,290.32 - 53,209.68 5.82%Operations Support 3,000 15.99 15.99 15.99 1,075.99 1,908.02 36.40% Staff Support 6,345 537.30 32.44 537.30 300.00 5,507.70 13.20% Professional Services 2,300 - - - 2,175.00 125.00 94.57% Operating Equipment 88,000 706.28 1,239.99 706.28 22,156.98 65,136.74 25.98% TOTAL LIBRARY 842,473 60,467.09 115,062.57 95,412.62 28,663.63 718,396.75 14.73% TOTAL CULTURAL 842,473 60,467.09 115,062.57 95,412.62 28,663.63 718,396.75 14.73% 8 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 HEALTH ANIMAL SERVICES Personnel Services 306,397 23,648.80 40,167.59 40,243.38 829.97 265,323.65 13.41% Supplies 37,883 504.86 716.49 1,683.37 3,197.51 33,002.12 12.88% Utility Services 46,840 696.40 920.66 1,420.29 - 45,419.71 3.03%Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 11,390 366.41 381.92 366.41 164.90 10,858.69 4.66% City Assistance 17,550 1,186.65 1,061.25 1,186.65 533.50 15,829.85 9.80%Professional Services 26,500 785.00 9,116.85 785.00 994.45 24,720.55 6.71% Maintenance Services 23,200 - 120.00 (268.84) 958.83 22,510.01 2.97% Operating Equipment 11,500 - - - - 11,500.00 0.00% Capital Outlay 21,000 - - - - 21,000.00 0.00% TOTAL ANIMAL SERVICES 503,260 27,188.12 52,484.76 45,416.26 6,679.16 451,164.58 10.35% TOTAL HEALTH 503,260 27,188.12 52,484.76 45,416.26 6,679.16 451,164.58 10.35% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 441,993 32,903.33 50,738.00 54,483.43 - 387,509.57 12.33% Supplies 3,500 124.62 132.11 124.62 59.35 3,316.03 5.26% City Support Services 598,643 18,863.74 42,149.91 72,716.74 6,735.50 519,190.76 13.27% Utility Services 236,822 6,160.23 25,345.23 18,045.30 3,060.16 215,716.54 8.91% Staff Support 37,400 509.39 2,524.41 1,404.39 1,115.38 34,880.23 6.74% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 15,600 1,529.90 - 2,419.22 614.17 12,566.61 19.44%Operating Equipment 291,571 8,344.86 15,600.68 10,648.36 4,923.95 275,998.69 5.34% TOTAL INFORMATION TECHNOLOGY 1,625,529 68,436.07 136,490.34 159,842.06 16,508.51 1,449,178.43 10.85% 9 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 HUMAN RESOURCES Personnel Services 310,863 29,016.64 39,163.38 44,776.34 - 266,086.66 14.40%Supplies 1,000 308.53 330.81 308.53 - 691.47 30.85% Human Services 64,000 2,543.45 2,593.21 2,831.54 1,966.78 59,201.68 7.50% Operations Support 14,000 - - - - 14,000.00 0.00%Staff Support 14,620 1,825.00 173.68 1,825.00 260.00 12,535.00 14.26% City Assistance 10,000 450.00 (81.25) 450.00 181.50 9,368.50 6.32% Professional Services 9,200 744.75 - 744.75 744.75 7,710.50 16.19%Operating Equipment - - - - - - 0.00% TOTAL HUMAN RESOURCES 423,683 34,888.37 42,179.83 50,936.16 3,153.03 369,593.81 12.77% FINANCE Personnel Services 516,715 47,381.49 67,747.40 71,718.01 - 444,996.99 13.88% Supplies 2,800 11.00 309.90 330.45 383.56 2,085.99 25.50% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 15,605 805.00 287.65 710.00 580.00 14,315.00 8.27% Maintenance Services - - - - - - 0.00% TOTAL FINANCE 536,120 48,197.49 68,344.95 72,758.46 963.56 462,397.98 13.75% PURCHASING & ASSET MGT Personnel Services 262,098 19,393.93 39,233.50 29,139.01 - 232,958.99 11.12% Supplies 1,200 - 6.06 - 114.41 1,085.59 9.53% Utility Services 500 67.48 - 67.48 - 432.52 13.50% Operations Support 300 - - - - 300.00 0.00% Staff Support 8,070 - 250.00 250.00 407.40 7,412.60 8.15% Operating Equipment 1,300 - - - - 1,300.00 0.00% TOTAL PURCHASING & ASSET MGT 273,468 19,461.41 39,489.56 29,456.49 521.81 243,489.70 10.96% 10 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 FLEET SERVICE Personnel Services 313,447 20,603.95 31,517.60 33,657.71 - 279,789.29 10.74%Supplies 174,525 8,754.67 27,972.83 15,862.49 6,178.71 152,483.80 12.63% City Support Services 3,500 - 2,100.00 - - 3,500.00 0.00% Utility Services 5,000 530.58 378.42 530.58 - 4,469.42 10.61%Operations Support 400 - - - - 400.00 0.00% Staff Support 4,500 72.86 144.24 110.08 475.02 3,914.90 13.00% City Assistance 180 - - - - 180.00 0.00%Maintenance Services 73,750 2,820.65 7,733.24 5,031.53 2,691.66 66,026.81 10.47%Rental/Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 1,740.00 - 1,840.00 292.08 6,067.92 26.00% Capital Outlay 65,000 - - - - 65,000.00 0.00% TOTAL FLEET SERVICE 648,702 34,522.71 69,846.33 57,032.39 9,637.47 582,032.14 10.28% BUILDING MAINTENANCE Personnel Services 136,524 12,919.49 16,523.82 19,140.94 - 117,383.06 14.02% Supplies 1,043 45.73 64.80 350.53 43.99 648.48 37.83%Utility Services 2,350 292.05 275.65 292.05 - 2,057.95 12.43% Staff Support 2,900 398.25 77.44 425.76 42.80 2,431.44 16.16% Professional Services 12,000 - 7,160.00 - - 12,000.00 0.00%Maintenance Services 71,132 956.68 16,079.63 1,424.32 3,048.96 66,658.72 6.29% 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 14,612.20 40,181.34 21,633.60 11,550.75 234,414.65 12.40% TOTAL INTERNAL SERVICE 3,775,101 220,118.25 396,532.35 391,659.16 42,335.13 3,341,106.71 11.50% 11 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 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 - 7,000.00 - - 45,000.00 0.00% TOTAL CITY ASSISTANCE 86,678 - 12,000.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 - 12,000 5,000 1,840 165,710.00 3.96% TOTAL EXPENDITURES 25,386,088 1,754,292.00 2,892,409.20 2,970,465.30 323,659.46 22,091,963.24 12.98% REVENUE OVER(UNDER) EXPEND.308,955 270,952.86 12 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 9,188,520 356,940.46 902,156.59 714,376.09 - 8,474,143.91 7.77%000-411200 Advalorem Tax - Delinquent 50,000 4,526.36 (4,612.87) 8,468.62 - 41,531.38 16.94% 000-411300 Advalorem Tax - P&I 50,000 1,380.49 5,194.50 3,444.64 - 46,555.36 6.89% 000-411500 Sales Tax Revenue-Gen Fund 7,346,170 424,742.12 977,589.34 933,058.11 - 6,413,111.89 12.70%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 787,589.43 1,890,913.29 1,670,772.71 - 14,994,917.29 10.03% Franchises 000-421200 Center Point/Entex Energy 87,202 6,620.12 9,956.18 13,240.24 - 73,961.76 15.18%000-421220 City Public Service 649,940 38,784.45 62,868.71 83,572.61 - 566,367.39 12.86% 000-421240 Guadalupe Valley Elec Co-op 443,320 33,052.76 59,264.06 66,105.52 - 377,214.48 14.91% 000-421250 New Braunfels Utilities 60,697 4,606.97 7,330.60 9,213.94 - 51,483.06 15.18% 000-421300 Time Warner-State Franchise 275,000 22,708.75 52,643.82 45,417.50 - 229,582.50 16.52% 000-421460 AT&T Franchise Fee 250,000 20,143.63 45,254.12 40,287.26 - 209,712.74 16.11% 000-421480 Other Telecom Franchise 100,000 3.72 24,359.07 22,263.49 - 77,736.51 22.26% 000-421500 Solid Waste Franchise Fee 120,000 4,657.40 25,619.01 19,639.56 - 100,360.44 16.37% TOTAL Franchises 1,986,159 130,577.80 287,295.57 299,740.12 - 1,686,418.88 15.09% Permits 000-431100 Home Occupation Permit 420 - - - - 420.00 0.00% 000-431205 Building Permit - Residential 356,476 21,905.00 40,096.00 89,570.00 - 266,906.00 25.13% 000-431210 Building Permit - Commercial 125,521 7,607.00 98.00 7,607.00 - 117,914.00 6.06% 000-431215 Building Permit - General 350,000 22,351.00 27,490.00 30,897.00 - 319,103.00 8.83% 000-431300 Mobile Home Permit 525 - 225.00 100.00 - 425.00 19.05% 000-431400 Signs Permit 11,920 96.00 1,777.00 500.00 - 11,420.00 4.19% 000-431500 Food Establishmnt Permit 48,000 22,870.00 22,925.00 47,600.00 - 400.00 99.17% 000-431600 Garage Sale Permit 10,840 408.00 2,934.00 2,326.00 - 8,514.00 21.46% 000-431700 Plumbing Permit 100,851 4,751.00 12,950.40 17,166.00 - 83,685.00 17.02% 000-431750 Electrical Permit 50,000 2,980.00 6,480.00 7,780.00 - 42,220.00 15.56% 000-431800 Mechanical Permit 50,000 2,900.00 6,380.00 8,360.00 - 41,640.00 16.72% 000-431900 Solicitor/Peddler Permit 1,000 60.00 10.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 1,300.00 1,950.00 2,000.00 - 3,250.00 38.10% ************************************************ 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: NOVEMBER 30th, 2014 13 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 000-432100 Security Alarm Permit 45,000 2,780.00 5,990.00 6,150.00 - 38,850.00 13.67% 000-432300 Grading/Clearing Permit 3,000 362.00 1,523.00 362.00 - 2,638.00 12.07% 000-435000 Fire Permit 15,000 1,388.00 2,639.00 1,995.00 - 13,005.00 13.30% TOTAL Permits 1,175,803 91,758.00 133,672.40 222,633.00 - 953,170.00 18.93% Licenses 000-441000 Alcohol Beverage License 7,000 60.00 917.50 765.00 - 6,235.00 10.93% 000-441300 Mobile Home License 160 - - - - 160.00 0.00% 000-442000 Contractors License 79,569 3,435.00 7,395.00 6,635.00 - 72,934.00 8.34% 000-444000 Pet License 4,500 110.00 485.00 275.00 - 4,225.00 6.11% TOTAL Licenses 91,229 3,605.00 8,797.50 7,675.00 - 83,554.00 8.41% Fees 000-451000 Municipal Court Fines 1,300,000 61,168.78 204,764.19 160,695.13 - 1,139,304.87 12.36% 000-451100 Arrest Fee 56,534 3,256.47 9,107.88 7,444.05 - 49,089.95 13.17% 000-451110 Expunction Fee 120 60.00 - 60.00 - 60.00 50.00% 000-451200 Warrant Fees 150,000 5,276.00 16,294.44 15,470.87 - 134,529.13 10.31% 000-451320 Civil Justice Fee-Court 34 - 14.19 - - 34.00 0.00% 000-451321 Civil Justice Fee-State 288 - 128.03 - - 288.00 0.00% 000-451340 Judicial Fee - City 7,567 421.59 1,181.20 973.67 - 6,593.33 12.87% 000-451400 Traffic Fine Costs TTL 28,060 1,728.77 4,677.06 3,865.45 - 24,194.55 13.78% 000-451500 Teen Court Admin Fee 200 - - - - 200.00 0.00%000-451510 Juvenile Case Mgmt Fee 63,062 3,512.96 9,833.52 8,118.67 - 54,943.33 12.87% 000-451520 Truancy Fee 4,586 641.41 - 1,447.87 - 3,138.13 31.57% 000-451600 Technology Fund Fee 50,872 2,814.69 7,844.95 6,483.02 - 44,388.98 12.74%000-451700 Security Fee 38,160 2,111.01 5,883.70 4,862.28 - 33,297.72 12.74% 000-451800 Time Payment Fee - City 8,122 325.47 1,068.45 911.69 - 7,210.31 11.22% 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 371.34 1,326.13 1,092.10 - 10,960.90 9.06% 000-452000 Child Safety Fee 23,570 1,889.98 4,498.19 4,994.05 - 18,575.95 21.19% 000-452050 Indigent Defense Fee 8,852 - 3,918.22 - - 8,852.00 0.00%000-452100 Platting Fees 47,500 8,000.00 4,000.00 17,000.00 - 30,500.00 35.79% 000-452200 Site Plan Fee 30,000 - 4,000.00 - - 30,000.00 0.00% 000-452300 Plan Check Fee 400,000 26,076.00 32,342.00 64,688.50 - 335,311.50 16.17% 000-452310 Miscellaneous Review Fee 1,200 300.00 - 300.00 - 900.00 25.00% 000-452320 Tree Mitigation Admin Fee 10,000 - 31,312.50 11,595.00 - (1,595.00) 115.95% 000-452400 BOA/Zoning Fees 5,000 500.00 1,500.00 500.00 - 4,500.00 10.00% 000-452500 Food Handler Class 20,000 1,220.00 3,450.00 2,240.00 - 17,760.00 11.20% 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 000-452520 Fire Training Classes 500 - - - - 500.00 0.00% 000-452600 Specific Use/Zone Chng Fee 25,800 1,000.00 650.00 1,000.00 - 24,800.00 3.88% 000-452710 Zoning Ltr & Dev Rights 1,050 450.00 - 750.00 - 300.00 71.43% 000-453100 Reinspection Fees 26,900 2,725.00 5,545.98 6,845.00 - 20,055.00 25.45% 000-453110 Swim Pool Inspection Fee 1,800 - - - - 1,800.00 0.00% 000-453200 Lot Abatement 7,000 - 375.00 - - 7,000.00 0.00% 000-453211 Admin Fee-Inspections 6,600 200.00 2,200.00 200.00 - 6,400.00 3.03% 000-453310 Misc Inspection Fee 3,750 - - - - 3,750.00 0.00% 000-453710 Foster Care 900 200.00 100.00 200.00 - 700.00 22.22% 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 160.00 - 355.00 - 1,645.00 17.75% 000-456120 Senior Center Meal Fee 16,000 1,326.00 - 3,160.50 - 12,839.50 19.75%000-456500 Haz Mat Fees 12,000 - - - - 12,000.00 0.00% 000-456600 Fire Re-inspection Fee 750 200.00 100.00 200.00 - 550.00 26.67% 000-458100 Sale of Merchandise - - - - - - 0.00%000-458110 Sale of Merchandise-GovDeal 5,000 237.00 512.06 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 16,984.00 25,569.25 25,540.75 - 116,459.25 17.99%000-458401 Capital Recovery Fee-Civic Cntr 5,500 425.00 790.00 425.00 - 5,075.00 7.73% 000-458450 North Center Rental Fees 21,000 1,977.00 3,565.00 4,170.75 - 16,829.25 19.86% 000-458460 Senior Center Rental 7,000 1,330.00 - 2,030.00 - 4,970.00 29.00%000-458500 Community Center Rental Fees 26,000 1,744.38 2,264.00 3,818.88 - 22,181.12 14.69% 000-458550 Pavilion Rental Fees 17,500 870.00 2,010.00 2,570.00 - 14,930.00 14.69% 000-458560 Chamber of Comm rent 7,800 - 1,950.00 - - 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 2,740.00 3,210.00 2,740.00 - 6,760.00 28.84% 000-458660 BVYA Utility Reimbursement 12,500 2,547.13 - 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 - - 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,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 18.00 36.00 30.00 - 270.00 10.00% 000-459400 Maps, Copies, UDC, & Misc F 100 10.00 - 10.00 - 90.00 10.00% 000-459600 Animal Adoption Fee 16,000 405.00 1,350.00 1,812.50 - 14,187.50 11.33% 000-459700 Pet Impoundment Fee 14,000 459.00 1,368.00 1,199.00 - 12,801.00 8.56% 000-459800 Police Reports Fee 6,000 354.00 774.20 834.90 - 5,165.10 13.92% TOTAL Fees 2,814,366 156,035.98 420,142.10 394,245.79 - 2,420,120.21 14.01% 15 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 Fines 000-463000 Library Fines 31,000 2,167.18 4,652.88 4,551.72 (41.92) 26,490.20 14.55% TOTAL Fines 31,000 2,167.18 4,652.88 4,551.72 (41.92) 26,490.20 14.55% Inter-Jurisdictional 000-473100 Bexar Co - Fire 21,072 1,756.48 3,512.96 3,512.96 - 17,559.04 16.67% 000-473200 City of Seguin - Fire Contract 30,000 2,435.90 4,871.80 4,871.80 - 25,128.20 16.24%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,181.26 5,831.65 6,199.10 - 33,800.90 15.50% 000-474610 School Cross Guard-Guadalupe 38,000 3,048.15 5,498.46 6,086.62 - 31,913.38 16.02% 000-474620 School Crossing Guard-Comal 1,500 - - - - 1,500.00 0.00% 000-474700 School Officer Funding 155,100 80,000.00 42,600.00 80,000.00 - 75,100.00 51.58% TOTAL Inter-Jurisdictional 708,392 90,421.79 62,314.87 100,670.48 - 607,721.52 14.21% Fund Transfers 000-480000 Indirect Costs - EMS 136,087 11,340.58 22,839.66 22,681.16 - 113,405.84 16.67% 000-480100 Indirect Costs - Hotel/Motel 66,405 5,533.75 24,230.84 11,067.50 - 55,337.50 16.67% 000-482150 Transfer From Court Security 27,249 - - - 27,249.00 0.00% 000-485000 Interfund Charge-Drainage 57,130 4,760.83 8,633.34 9,521.66 - 47,608.34 16.67% 000-486000 Interfund Chrges-Admin W&S 1,152,350 96,029.17 192,058.34 192,058.34 - 960,291.66 16.67% 000-486202 Transfer In-W&S 40,000 - - - - 40,000.00 0.00% 000-487000 Interfund Charges-Fleet 180,237 15,019.75 21,723.98 30,039.50 - 150,197.50 16.67% 000-488000 Interfund Charges-4B 100,296 8,358.00 22,707.50 16,716.00 - 83,580.00 16.67% TOTAL Fund Transfers 1,759,754 141,042.08 292,193.66 282,084.16 - 1,477,669.84 16.03% 16 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 Miscellaneous 000-491000 Interest Earned 550 46.92 41.83 63.63 - 486.37 11.57%000-491200 Investment Income 26,000 1,857.18 4,862.20 3,830.45 - 22,169.55 14.73% 000-491800 Gain/Loss - (609.40) (12.54) (609.40) - 609.40 0.00% 000-491900 Unrealized Gain/Loss (20,000) 930.65 (693.78) 2,127.50 - (22,127.50) 0.00%000-493120 Donations-Public Library 5,000 1,500.00 - 1,500.00 - 3,500.00 30.00% 000-493400 Donation - Animal Control 1,000 75.00 156.73 75.00 - 925.00 7.50% 000-493401 Donations-A/C Microchip 1,400 15.00 120.00 135.00 - 1,265.00 9.64%000-493402 Donations-Spay&Neuter 10,000 103.50 1,032.50 1,214.00 - 8,786.00 12.14% 000-493403 Donations-Animal Adoption Trailer 9,000 525.00 - 950.00 - 8,050.00 10.56% 000-493465 Donations-Senior Center 12,000 944.16 - 1,771.26 - 10,228.74 14.76% 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 3,309.47 17,085.02 3,474.39 - 16,525.61 17.37% 000-497005 Schertz Magazine Advertising 220,000 18,805.00 34,925.00 39,210.00 - 180,790.00 17.82% 000-497100 Misc Income-Police 15,000 1,378.50 636.40 193,950.00 - (178,950.00) 1293.00%000-497200 Misc Income-Library 4,000 558.55 744.65 1,107.80 - 2,892.20 27.70% 000-497210 Misc Income-Library Copier 14,000 1,429.05 2,149.60 3,131.77 - 10,868.23 22.37% 000-497400 Misc Income-Streets Dept.18,000 650.00 6,926.88 1,675.00 - 16,325.00 9.31% 000-497500 Misc Income-TML Insurance 20,000 - 1,221.18 - - 20,000.00 0.00% 000-497550 Misc Income-TML Reimbursemt 20,000 677.36 113.73 2,032.08 - 17,967.92 10.16% 000-497600 Misc Income-Vending Mach.2,000 - 432.27 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 - 1,963.54 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 462,650 32,195.94 77,700.47 259,045.18 - 203,604.82 55.99% TOTAL REVENUES 25,695,043 1,435,393.20 3,177,682.74 3,241,418.16 (41.92) 22,453,666.76 12.61% 17 Cash in Bank Claim on Operating Cash Pool-Checking 286,668.58$ Cash in Investments LOGIC Investment-General Fund 4,256,358.48 LOGIC Investment-Equip Replacement 73,658.57 LOGIC Investment-Veh Replacement 306,702.85 LOGIC Investment-Air Condi Replacment 196,097.17 CAPITAL ONE Investment-General Fund 1,350,336.31 Total Cash in Bank & Investments 6,616,403.80$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 GENERAL FUND 18 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 357,436 356,940 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 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% $- $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 16.67% 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 - 19,510.00 18,802.00 - (52.00) 0.00%Miscellaneous 3,925.00 8,563.27 6,729.21 137.55 - 3,787.45 1.91% TOTAL REVENUES 153,800.00 8,563.27 26,239.21 18,939.55 - 134,860.45 8.39% EXPENDITURE SUMMARY GENERAL GOVERNMENTNon 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 317.50 2,138.79 317.50 595.00 14,087.50 6.08% Employee Appreciation Event 15,000.00 - 360.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 - 1,031.38 - 120.70 34,879.30 0.34% Jazzfest 20,000.00 - - - - 20,000.00 0.00% Hal Baldwin Scholarship 18,750.00 8,085.68 8,630.20 8,085.68 - 10,664.32 43.12% Other Events 14,000.00 784.26 13,428.77 2,784.26 1,925.00 9,290.74 33.64% TOTAL CULTURAL 142,950.00 9,187.44 25,589.14 11,187.44 2,640.70 129,121.86 9.67% TOTAL EXPENDITURES 153,800.00 9,187.44 25,589.14 11,187.44 2,640.70 139,971.86 8.99% REVENUE OVER(UNDER) EXPEND - 7,752.11 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 22 Cash in Bank Claim on Operating Cash Pool-Checking 76,318.93$ Cash in Investments Texas Class- Special Events 16,786.43 Total Cash in Bank & Investments 93,105.36$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 SPECIAL EVENTS FUND 23 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 119,572.00 12,864.97 - 12,864.97 - 106,707.03 10.76% Fund Transfers 89,428.00 - - - - 89,428.00 0.00% TOTAL REVENUES 209,000.00 12,864.97 - 12,864.97 - 196,135.03 6.16% EXPENDITURE SUMMARY GENERAL GOVERNMENTNon Departmental 209,000.00 - 22,888.46 - 2,762.70 206,237.30 1.32% TOTAL GENERAL GOVERNMENT 209,000.00 - 22,888.46 - 2,762.70 206,237.30 1.32% TOTAL EXPENDITURES 209,000.00 - 22,888.46 - 2,762.70 206,237.30 1.32% REVENUE OVER(UNDER) EXPEND - 12,864.97 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 ************************************************** 2 0 1 4 - 2 0 1 5 ************************************************** 24 110-PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% 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,864.97 - 12,864.97 - 65,907.03 16.33% 000-421465 AT&T PEG Fee 40,800 - - - - 40,800.00 0.00% TOTAL Franchises 119,572 12,865 - 12,864.97 - 106,707.03 10.76% Fund Transfers000-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 12,864.97 - 12,864.97 - 196,135.03 6.16% 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: NOVEMBER 30th, 2014 25 Cash in Bank Cash Balance 478,429.15$ Total Cash in Bank & Investments 478,429.15$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 PEG FUND 26 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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,514.82 19,069.49 21,185.19 - 38,814.81 35.31% Fees 17,169,500 1,487,968.84 2,778,589.69 2,915,908.51 - 14,253,591.49 16.98% Fund Transfers 276,425 11,426.08 20,719.34 22,852.16 - 253,572.84 8.27%Miscellaneous 142,940 31,422.47 170,557.02 32,200.76 - 110,739.24 22.53% TOTAL REVENUES 17,860,678 1,541,332.21 2,988,935.54 2,992,146.62 - 14,868,531.38 16.75% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 446,006 46,793.19 59,257.21 71,689.11 - 374,316.89 16.07% Supplies 4,600 611.48 20.00 655.44 98.73 3,845.83 16.40% 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 5,006.65 14,637.10 15,006.65 - 107,993.35 12.20% Staff Support 7,300 - 90.08 42.56 353.48 6,903.96 5.43% Professional Services 62,000 5,760.49 4,250.26 10,845.35 - 51,154.65 17.49% Maintenance Services 13,440 420.00 5,040.00 940.00 4,100.00 8,400.00 37.50% Operating Equipment 1,550 - - - - 1,550.00 0.00% TOTAL BUSINESS OFFICE 682,347 58,591.81 83,294.65 100,010.11 4,552.21 577,784.68 15.32% W & S ADMINISTRATION Personnel Services 1,223,136 122,624.46 172,678.58 194,971.63 - 1,028,164.37 15.94% Supplies 195,150 2,670.81 12,245.05 3,663.50 11,304.81 180,181.69 7.67% Human Services 1,000 - - - - 1,000.00 0.00% City Support Services 150,103 - 30,813.04 35,027.56 - 115,075.44 23.34% Utility Services 3,454,440 208,753.52 412,278.83 464,370.11 395.96 2,989,673.93 13.45% Operations Support 9,250 262.50 239.49 280.74 13.19 8,956.07 3.18% Staff Support 31,150 4,089.34 1,089.38 4,424.52 935.94 25,789.54 17.21% City Assistance 1,900 - - - - 1,900.00 0.00% Professional Services 249,113 683.41 81,001.79 13,033.53 902.00 235,177.47 5.59% Fund Charges/Transfers 3,594,442 363,896.20 883,084.23 727,792.40 - 2,866,649.60 20.25% Maintenance Services 6,496,250 267,463.06 736,722.66 462,696.92 299,146.09 5,734,406.99 11.73% Other Costs 35,000 - - - 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: NOVEMBER 30th, 2014 27 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 2014 Debt Service 1,534,512 - 966.67 - - 1,534,512.00 0.00% Rental-Leasing 6,070 594.11 455.45 594.11 - 5,475.89 9.79% Operating Equipment 21,200 1,540.93 - 1,540.93 3,704.18 15,954.89 24.74% Capital Outlay 123,500 - - - - 123,500.00 0.00% TOTAL PUBLIC WORKS 17,126,216 972,578.34 2,331,575.17 1,908,395.95 343,552.37 14,874,267.68 13.15% TOTAL EXPENDITURES 17,808,563 1,031,170 2,414,870 2,008,406 348,105 15,452,052 13.23% ** REVENUE OVER(UNDER)EXPENSES **52,115 983,740.56 28 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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% Permits000-432400 Development Permit 60,000 10,514.82 19,069.49 21,185.19 - 38,814.81 35.31% TOTAL Permits 60,000 10,514.82 19,069.49 21,185.19 - 38,814.81 35.31% Fees 000-455200 Garbage Collection Fee 4,000,000 358,610.15 698,256.24 691,265.30 - 3,308,734.70 17.28% 000-455600 Fire Line Fees 25,000 22,355.00 23,985.00 25,920.00 - (920.00) 103.68% 000-455700 Recycle Fee Revenue 270,000 22,347.38 42,580.33 44,862.31 - 225,137.69 16.62% 000-455800 W&S Line Constructn Reimbursemnt 25,000 1,047.00 1,864.00 3,527.00 - 21,473.00 14.11% 000-457100 Sale of Water 8,100,000 658,564.01 1,237,605.11 1,358,099.24 - 6,741,900.76 16.77% 000-457110 Edwards Water Lease 127,000 - 82,124.07 - - 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 4,108.38 5,142.00 11,161.76 - 78,838.24 12.40% 000-457400 Sewer Charges 4,250,000 403,931.29 619,263.42 743,052.75 - 3,506,947.25 17.48% 000-457500 Water Penalties 200,000 16,980.63 35,965.60 37,570.15 - 162,429.85 18.79% 000-458110 Sale of Merchandise - Gov Deals - - - - - - 0.00% 000-458400 Building rental Fee - - 9,600.00 - - - 0.00%000-459200 NSF Check Fee-Water&Sewer 2,500 25.00 410.00 450.00 - 2,050.00 18.00% TOTAL Fees 17,169,500 1,487,968.84 2,778,589.69 2,915,908.51 - 14,253,591.49 16.98% Fund Transfers000-486204 Interfnd Chrg-Drainage Bill 137,113 11,426.08 20,719.34 22,852.16 - 114,260.84 16.67% 000-486411 Transfer In-Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 276,425 11,426.08 20,719.34 22,852.16 - 253,572.84 8.27% ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** AS OF: NOVEMBER 30th, 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 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET ******************************************************* 2 0 1 4 - 2 0 1 5 ****************************************************** AS OF: NOVEMBER 30th, 2014 REVENUE REPORT (UNAUDITED) C I T Y O F S C H E R T Z Miscellaneous 000-490000 Misc Charges 700 123.00 205.00 123.00 - 577.00 17.57% 000-491000 Interest Earned 1,500 131.48 253.49 255.36 - 1,244.64 17.02% 000-491200 Investment Income 10,000 247.59 268.91 496.19 - 9,503.81 4.96% 000-496050 SSLG - SAWS Reservation - - 134,500.00 - - - 0.00% 000-497000 Misc Income-W&S 20,000 2,231.27 9,156.99 2,637.08 - 17,362.92 13.19% 000-498110 Reimbursement-SSLGC 110,740 28,689.13 26,096.67 28,689.13 - 82,050.87 25.91% 000-498300 Reimbursement-City Property - - 75.96 - - - 0.00% TOTAL Miscellaneous 142,940 31,422.47 170,557.02 32,200.76 - 110,739.24 22.53% TOTAL REVENUES 17,860,678 1,541,332.21 2,988,935.54 2,992,146.62 - 14,868,531.38 16.75% 30 Cash in Bank Claim on Operating Cash Pool-Checking 1,619,047.24$ Cash in Investments Lone Star Investment-Water&Sewer 638,986.98 Lone Star Investment-W&S Customer Deposits 295,387.14 Lone Star Investment-W&S Equip Replacement 177,600.59 Lone Star Investment-W&S Veh Replacement 256,560.24 Lone Star Investment-Water/SSLGC SAWS 810,012.95 Schertz Bank & Trust-Certificate of Deposit 1,064,372.78 3,242,920.68$ Total Cash in Bank & Investments 4,861,967.92$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 WATER & SEWER 31 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,416,343 521,578.46 823,130.05 941,819.32 - 5,474,523.68 14.68% Inter-Jurisdictional 1,601,076 22,772.10 65,171.72 22,772.10 - 1,578,303.90 1.42%Miscellaneous 169,500 12,236.70 30,052.01 24,139.33 - 145,360.67 14.24% TOTAL REVENUES 8,186,919 556,587.26 918,353.78 988,730.75 - 7,198,188.25 12.08% 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 730,220.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 32 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000-456100 Ambulance/Mileage Transport 6,249,943 510,757.46 796,681.20 926,121.13 - 5,323,821.87 14.82% 000-456110 Subscription Program Fees 40,000 2,660.00 10,035.00 2,720.00 - 37,280.00 6.80% 000-456120 EMT Class - Fees 104,400 8,161.00 13,009.00 11,415.95 - 92,984.05 10.93% 000-456130 Immunization Fees - - - - - - 0.00% 000-456140 Billing Fees - Alamo Heights 22,000 - 3,379.85 1,407.24 - 20,592.76 6.40% 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 521,578.46 823,130.05 941,819.32 - 5,474,523.68 14.68% Inter-Jurisdictional 000-473500 Seguin/Guadalupe Co Support 286,126 - 47,687.76 - - 286,126.00 0.00% 000-474300 Cibolo Support 261,370 - - - - 261,370.00 0.00% 000-475100 Comal Co ESD #6 95,217 22,772.10 15,181.40 22,772.10 - 72,444.90 23.92% 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 - 2,302.56 - - 14,230.00 0.00% TOTAL Inter-Jurisdictional 1,601,076 22,772.10 65,171.72 22,772.10 - 1,578,303.90 1.42% C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 33 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% 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: NOVEMBER 30th, 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 - - - - 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 12,051.70 29,167.71 23,843.25 - 121,156.75 16.44%000-497100 Recovery of Bad Debt 10,000 185.00 884.30 285.00 - 9,715.00 2.75% TOTAL Miscellaneous 169,500 12,236.70 30,052.01 24,139.33 - 145,360.67 14.24% TOTAL REVENUES 8,186,919 556,587.26 918,353.78 988,730.75 - 7,198,188.25 12.08% 34 Cash in Bank Claim on Operating Cash Pool-Checking (193,380.87)$ Total Cash in Bank & Investments (193,380.87)$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 SCHERTZ EMS 35 204-DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OFFINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Permits 3,000 60.00 380.00 300.00 - 2,700.00 0.00%Fees 1,155,500 89,099.92 176,213.49 178,562.60 - 976,937.40 26.91%Miscellaneous 700 89.97 237.14 183.51 - 516.49 11.69% TOTAL REVENUES 1,159,200 89,249.89 176,830.63 179,046.11 - 980,153.89 26.92% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 453,529 50,597.65 61,417.77 77,926.75 - 375,602.25 17.18% Supplies 8,300 620.25 773.83 700.66 114.35 7,484.99 9.82%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 2,252.95 2,390.97 2,806.89 352.17 27,210.94 10.40% Operations Support 2,460 20.48 - 20.48 - 2,439.52 0.83% Staff Support 8,116 188.88 552.94 342.58 311.01 7,462.41 8.05%City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 198.00 - 198.00 - 23,302.00 0.84% Fund Charges/Transfers 221,818 18,401.49 32,750.68 36,802.98 - 185,015.02 16.59% Maintenance Services 22,000 68.00 (10,000.00) 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 72,347.70 90,052.80 121,172.98 777.53 826,469.49 12.86% 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 303.59 134,406.74 2.60% TOTAL PROJECTS 146,198 - - 3,287.67 8,303.59 134,606.74 7.93% TOTAL EXPENDITURES 1,094,618 72,347.70 90,052.80 124,460.65 9,081.12 961,076.23 12.20% ** REVENUE OVER(UNDER) EXPEND 64,582 54,585.46 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 36 204-DRAINAGE CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000-432400 Floodplain Permit 3,000 60.00 380.00 300.00 - 2,700.00 10.00% TOTAL Permits 3,000 60.00 380.00 300.00 - 2,700.00 10.00% Fees 000-457500 Drainage Penalties 8,000 767.74 1,412.13 1,547.63 - 6,452.37 19.35% 000-457600 Drainage Fee 1,147,500 88,332.18 174,801.36 177,014.97 - 970,485.03 15.43% TOTAL Fees 1,155,500 89,099.92 176,213.49 178,562.60 - 976,937.40 15.45% Miscellaneous 000-491000 Interest Earned 100 21.11 23.20 45.52 - 54.48 45.52% 000-491200 Investment Interest 500 68.86 153.94 137.99 - 362.01 27.60% 000-497000 Misc Income-Drainage 100 - 60.00 - - 100.00 0.00% TOTAL Miscellaneous 700 89.97 237.14 183.51 - 516.49 26.22% TOTAL REVENUES 1,159,200 89,249.89 176,830.63 179,046.11 - 980,153.89 15.45% 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: NOVEMBER 30th, 2014 37 Cash in Bank Claim on Operating Cash Pool-Checking 497,737.28 Cash in Investments Lone Star Investment-Drainage Maint Fund 605,856.85 Total Cash in Bank & Investments 1,103,594.13$ DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 38 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 544,753 54,180.47 31,158.94 82,817.11 - 461,935.89 15.20% Miscellaneous 600 31.64 61.91 64.04 - 535.96 10.67% TOTAL REVENUES 545,353 54,212.11 31,220.85 82,881.15 - 462,471.85 15.20% 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 400.00 4,865.00 400.00 1,886.00 67,214.00 3.29% Professional Services 5,825 - - - - 5,825.00 0.00% Fund Charges/Transfers 126,405 5,533.75 24,230.84 11,067.50 - 115,337.50 8.76% Maintenance Services - - - - - - 0.00% Operating Equipment 37,000 - 3,269.00 - 1,712.60 35,287.40 4.63% TOTAL NONDEPARTMENTAL 302,730 5,933.75 52,772.34 11,467.50 3,598.60 287,663.90 4.98% TOTAL EXPENDITURES 302,730 5,933.75 52,772.34 11,467.50 3,598.60 287,663.90 4.98% REVENUE OVER(UNDER) EXPENDITURE 242,623 71,413.65 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 **************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 39 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411800 Hotel Occupancy Tax 544,753 54,180.47 31,158.94 82,817.11 - 461,935.89 15.20% TOTAL Taxes 544,753 54,180.47 31,158.94 82,817.11 - 461,935.89 15.20% Miscellaneous 000-491000 Interest Earned 100 8.24 14.82 16.46 - 83.54 16.46% 000-491200 Investment Interest 500 23.40 47.09 47.58 - 452.42 9.52% TOTAL Miscellaneous 600 31.64 61.91 64.04 - 535.96 10.67% TOTAL REVENUES 545,353 54,212.11 31,220.85 82,881.15 - 462,471.85 15.20% 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: NOVEMBER 30th, 2014 40 Cash in Bank Claim on Operating Cash Pool-Checking 236,082.53$ Cash in Investments MBIA - Hotel Tax 299,234.42 Total Cash in Bank & Investments 535,316.95$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 HOTEL OCCUPANCY TAX FUND 41 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014-15 44,724 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 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 100,000 - 31,000.00 - - 100,000.00 0.00% Miscellaneous - 7.75 1.85 17.17 - (17.17) 0.00% TOTAL REVENUES 100,000 7.75 31,001.85 17.17 - 99,982.83 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.17 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 43 317-PARK CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458800 Parkland Dedication 100,000 - 31,000.00 - - 100,000.00 0.00% TOTAL Fees 100,000 - 31,000.00 - - 100,000.00 0.00% Miscellaneous 000-491000 Interest Earned - 7.68 0.80 17.06 - (17.06) 0.00% 000-491200 Investment Interest - 0.07 1.05 0.11 - (0.11) 0.00%000-497000 Misc Income - - - - - - 0.00% TOTAL Miscellaneous - 7.75 1.85 17.17 - (17.17) 0.00% TOTAL REVENUES 100,000 7.75 31,001.85 17.17 - 99,982.83 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: NOVEMBER 30th, 2014 44 Cash in Bank Claim on Operating Cash Pool-Checking $190,809.66 Cash in Investments Texas Class- Park Fund 1,354.79 Total Cash in Bank & Investments $192,164.45 CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 PARK FUND 45 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 36,000 - 177,437.50 63,605.00 - (27,605.00) 176.68% Fund Transfers 80,125 - - - - 80,125 0.00% Miscellaneous 210 20.67 34.38 43.42 - 166.58 20.68% TOTAL REVENUES 116,335 20.67 177,471.88 63,648.42 - 52,686.58 54.71% EXPENDITURE SUMMARY TREE MITIGATIONMaintenance 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,648.42 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 *************************************************** 2 0 1 4 - 2 0 1 5 *************************************************** 46 319-TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000-458900 Tree Mitigation 36,000 - 177,437.50 63,605.00 - (27,605.00) 176.68% TOTAL Fees 36,000 - 177,437.50 63,605.00 - (27,605.00) 176.68% Fund Transfers000-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 13.10 19.15 28.06 - 61.94 31.18%000-491200 Investment Interest 120 7.57 15.23 15.36 - 104.64 12.80% TOTAL Miscellaneous 210 20.67 34.38 43.42 - 166.58 20.68% TOTAL REVENUES 116,335 20.67 177,471.88 63,648.42 - 52,686.58 54.71% 34.38 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: NOVEMBER 30th, 2014 47 Cash in Bank Claim on Operating Cash Pool-Checking $325,498.83 Cash in Investments MBIA Investment-Tree Mitigation 97,354.70 Total Cash in Bank & Investments $422,853.53 CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 TREE MITIGATION FUND 48 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 880,200 60,147.00 80,685.00 171,639.00 - 708,561.00 19.50% Fund Transfers - - - - - - 0.00% Miscellaneous 5,300 470.59 979.15 950.18 - 4,349.82 17.93% TOTAL REVENUES 885,500 60,617.59 81,664.15 172,589.18 - 712,910.82 19.49% 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 172,589 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 49 411-CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455900 Capital Recovery - Water 880,200 60,147.00 80,685.00 171,639.00 - 708,561.00 19.50% TOTAL Fees 880,200 60,147.00 80,685.00 171,639.00 - 708,561.00 19.50% Miscellaneous 000-491000 Interest Earned 300 50.77 40.60 108.86 - 191.14 36.29%000-491200 Investment Income 5,000 419.82 938.55 841.32 - 4,158.68 16.83% TOTAL Miscellaneous 5,300 470.59 979.15 950.18 - 4,349.82 17.93% TOTAL REVENUES 885,500 60,617.59 81,664.15 172,589.18 - 712,910.82 19.49% 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: NOVEMBER 30th, 2014 50 Cash in Bank Claim on Operating Cash Pool-Checking 1,298,703.33$ Cash in Investments Lone Star Investment-Capital Recovery Water 3,693,873.40 Total Cash in Bank & Investments 4,992,576.73$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 CAPITAL RECOVERY WATER 51 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,400 22,538.88 44,090.88 74,510.88 - 525,889.12 12.41% Fund Transfers 559,497 - - - - 559,497.00 0.00% Miscellaneous 600 1,730.62 4,522.67 4,294.98 - (3,694.98) 715.83% TOTAL REVENUES 1,160,497 24,269.50 48,613.55 78,805.86 - 1,081,691.14 6.79% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,143 357.99 712.20 716.00 - 2,427.00 22.78%Fund Charges/Transfers 139,312 - - - - 139,312.00 0.00% TOTAL NON DEPARTMENTAL 142,455 357.99 712.20 716.00 - 141,739.00 0.50% 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.99 712.20 716.00 - 1,159,781.00 0.06% REVENUE OVER(UNDER) EXPENDITURES - 78,090 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 ******************************************************* 2 0 1 4 - 2 0 1 5 ******************************************************* 52 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Fees 000-455910 Capital Recovery - Waste Wtr 500,400 18,938.88 42,290.88 67,310.88 - 433,089.12 13.45% 000-455913 Cap Recovery-North Sewer Tr 100,000 3,600.00 1,800.00 7,200.00 - 92,800.00 7.20% TOTAL Fees 600,400 22,538.88 44,090.88 74,510.88 - 525,889.12 12.41% Fund Transfers000-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 29.54 16.45 63.54 - 36.46 63.54% 000-491200 Investment Income 500 2,235.08 6,784.61 4,532.84 - (4,032.84) 906.57% 000-491800 Gain/Loss - (78.68) (18,446.25) (78.68) - 78.68 0.00%000-491900 Unrealized Gain/Loss-Cap One - (455.32) 16,167.86 (222.72) - 222.72 0.00% TOTAL Miscellaneous 600 1,730.62 4,522.67 4,294.98 - (3,694.98) 715.83% TOTAL REVENUES 1,160,497 24,269.50 48,613.55 78,805.86 - 1,081,691.14 6.79% 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: NOVEMBER 30th, 2014 53 Cash in Bank Claim on Operating Cash Pool-Checking 744,167.58$ Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,452,013.41 Capital One-Investment 1,729,143.98 Total Cash in Bank & Investments 3,925,324.97$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 CAPITAL RECOVERY SEWER 54 505-TAX I&S CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,338,513 208,056.64 587,975.39 416,214.88 - 4,922,298.12 7.80% Miscellaneous 368,763 78.35 93.32 134.95 - 368,628.05 0.04% TOTAL REVENUES 5,707,276 208,134.99 588,068.71 416,349.83 - 5,290,926.17 7.30% 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 415,399.83 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: NOVEMBER 30th, 2014 ****************************************************** 2 0 1 4 - 2 0 1 5 **************************************************** 55 505-TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y-T-D BUDGET 16.67% 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,056.64 587,975.39 416,214.88 - 4,922,298.12 7.80% TOTAL Taxes 5,338,513 208,056.64 587,975.39 416,214.88 - 4,922,298.12 7.80% Miscellaneous 000-491000 Interest Earned 75 0.09 22.91 4.24 - 70.76 5.65%000-491200 Investment Earnings 1,500 78.26 70.41 130.71 - 1,369.29 8.71% 000-495015 Contribution from SED 367,188 - - - - 367,188.00 0.00% TOTAL Miscellaneous 368,763 78.35 93.32 134.95 - 368,628.05 0.04% TOTAL REVENUES 5,707,276 208,134.99 588,068.71 416,349.83 - 5,290,926.17 7.30% 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: NOVEMBER 30th, 2014 56 505-TAX I & S GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF NON DEPARTMENTAL BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Professional Services101-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: NOVEMBER 30th, 2014 ***************************************************** 2 0 1 4 - 2 0 1 5 ***************************************************** 57 Cash in Bank Claim on Operating Cash Pool-Checking 73,476.67$ Cash in Investments MBIA Investment- Tax I&S 1,001,099.59 Total Cash in Bank & Investments 1,074,576.26$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 2014 TAX I&S 58 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 3,682,057 212,370.89 488,794.69 466,528.63 - 3,215,528.37 12.67% Miscellaneous 10,200 2,830.19 371.60 3,328.72 - 6,871.28 32.63% TOTAL REVENUES 3,692,257 215,201.08 489,166.29 469,857.35 - 3,222,399.65 12.73% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 364,312 10,591.77 44,101.12 27,453.27 - 336,858.73 7.54% Supplies 1,050 - 134.38 - - 1,050.00 0.00% 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 93.64 203.83 111.14 10.00 3,998.86 2.94% Operations Support 147,145 1,070.74 51,044.15 50,570.74 94.98 96,479.28 34.43% Staff Support 18,250 138.00 1,506.66 286.32 - 17,963.68 1.57% City Assistance 1,025,000 - - - - 1,025,000.00 0.00% Professional Services 92,500 - - 331.50 92,168.50 0.36% Fund Charges/Transfers 471,280 8,674.33 22,911.16 17,348.66 - 453,931.34 3.68% 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 20,568.48 121,095.58 96,884.22 516.07 2,476,409.71 3.78% 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 20,568.48 121,095.58 96,884.22 516.07 2,926,409.71 3.22% ** REVENUE OVER(UNDER) EXPEND 668,447 372,973.13 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: NOVEMBER 30th, 2014 59 620-SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 16.67% 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 212,370.89 488,794.69 466,528.63 - 3,215,528.37 12.67% TOTAL Taxes 3,682,057 212,370.89 488,794.69 466,528.63 - 3,215,528.37 12.67% Miscellaneous 000-491000 Interest Earned 200 15.87 46.87 34.86 - 165.14 17.43% 000-491200 Investment Earnings 10,000 486.00 324.73 965.54 - 9,034.46 9.66%000-497000 Misc Income - 2,328.32 - 2,328.32 - (2,328.32) 0.00% TOTAL Miscellaneous 10,200 2,830.19 371.60 3,328.72 - 6,871.28 32.63% TOTAL REVENUES 3,692,257 215,201.08 489,166.29 469,857.35 - 3,222,399.65 12.73% 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: NOVEMBER 30th, 2014 60 Cash in Bank Claim on Operating Cash Pool-Checking 441,624.82$ Cash in Investments Texas Class Investment-Economic Development Corp 6,217,824.74 Schertz Bank & Trust-Certificate of Deposit 1,044,185.44 Total Cash in Bank & Investments 7,703,635.00$ CASH IN BANK AND INVESTMENTS AS OF: NOVEMBER 30th, 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 NOVEMBER 30th, 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,582,373.58 0.0500 5,364,747.44 4,675,547.69 319.84 8,271,893.17 8,271,893.17 8,271,893.17 N/A Schertz Bank & Trust - PEG Fund 465,564.18 0.0000 12,864.97 - - 478,429.15 478,429.15 478,429.15 N/A TOTAL OPERATIONS 8,047,937.76 5,377,612.41 4,675,547.69 319.84 8,750,322.32 8,750,322.32 8,750,322.32 - LOGIC General Fund 4,256,053.85 0.0871 - - 304.63 4,256,358.48 4,256,358.48 4,256,358.48 N/A 57 Days G/F-Equipment Replacement 73,653.28 0.0871 - - 5.29 73,658.57 73,658.57 73,658.57 N/A 57 Days G/F-Vehicle Replacement 306,680.91 0.0871 - - 21.94 306,702.85 306,702.85 306,702.85 N/A 57 Days G/F-Air Conditioner Replacement 196,083.12 0.0871 - - 14.05 196,097.17 196,097.17 196,097.17 N/A 57 Days SR2009 Bond-Street Projects(II)1,030,227.22 0.0871 - - 73.73 1,030,300.95 1,030,300.95 1,030,300.95 N/A 57 Days TOTAL LOGIC 5,862,698.38 - - 419.64 5,863,118.02 5,863,118.02 5,863,118.02 - LONESTAR Capital Recovery - Sewer 1,451,848.38 0.1400 - - 165.03 1,452,013.41 1,452,013.41 1,452,013.41 N/A 75 Days Capital Recovery - Water 3,693,453.58 0.1400 - - 419.82 3,693,873.40 3,693,873.40 3,693,873.40 N/A 75 Days Drainage Fund 605,787.99 0.1400 - - 68.86 605,856.85 605,856.85 605,856.85 N/A 75 Days Facilities Master Plan 95,143.52 0.1400 - - 10.81 95,154.33 95,154.33 95,154.33 N/A 75 Days GO SR2011 Animal Shelter 31,301.37 0.1400 - - 3.56 31,304.93 31,304.93 31,304.93 N/A 75 Days GO SR2011 Athletic Fields 98.05 0.1400 - - 0.01 98.06 98.06 98.06 N/A 75 Days GO SR2011 Soccer Fields 961,865.92 0.1400 - - 109.33 961,975.25 961,975.25 961,975.25 N/A 75 Days GO SR2011 Swimming Pool 5,981,817.82 0.1400 - - 679.93 5,982,497.75 5,982,497.75 5,982,497.75 N/A 75 Days GO SR2012 Downtown Improvements 979,797.32 0.1400 - - 111.37 979,908.69 979,908.69 979,908.69 N/A 75 Days Sewer/CCMA Project 1,997,326.25 0.1400 929,695.02 - 251.38 2,927,272.65 2,927,272.65 2,927,272.65 N/A 75 Days W/S-Customer Deposits 295,353.57 0.1400 - - 33.57 295,387.14 295,387.14 295,387.14 N/A 75 Days W/S-Equipment Repl/Cap.Imp 177,580.41 0.1400 - - 20.18 177,600.59 177,600.59 177,600.59 N/A 75 Days Water&Sewer 638,914.36 0.1400 - - 72.62 638,986.98 638,986.98 638,986.98 N/A 75 Days W/S-Vehicle Replacement 256,531.08 0.1400 - - 29.16 256,560.24 256,560.24 256,560.24 N/A 75 Days Water/SSLG - SAWS 809,920.89 0.1400 - - 92.06 810,012.95 810,012.95 810,012.95 N/A 75 Days TOTAL LONESTAR 17,976,740.51 929,695.02 - 2,067.69 18,908,503.22 18,908,503.22 18,908,503.22 - TEXAS CLASS Tax I&S 1,001,021.33 0.1000 - - 78.26 1,001,099.59 1,001,099.59 1,001,099.59 N/A 68 Days Police Forfeiture 339,016.74 0.1000 - - 26.47 339,043.21 339,043.21 339,043.21 N/A 68 Days Park Fund 1,354.72 0.1000 - - 0.07 1,354.79 1,354.79 1,354.79 N/A 68 Days Economic Development Corporation 6,217,338.74 0.1000 - - 486.00 6,217,824.74 6,217,824.74 6,217,824.74 N/A 68 Days Library Board 44,858.62 0.1000 - - 3.53 44,862.15 44,862.15 44,862.15 N/A 68 Days Tree Mitigation 97,347.13 0.1000 - - 7.57 97,354.70 97,354.70 97,354.70 N/A 68 Days Tax Note 2013 Fire Truck 4,930.11 0.1000 - - 0.37 4,930.48 4,930.48 4,930.48 N/A 68 Days Hotel Tax 299,211.02 0.1000 - - 23.40 299,234.42 299,234.42 299,234.42 N/A 68 Days Special Events Fund 16,785.16 0.1000 - - 1.27 16,786.43 16,786.43 16,786.43 N/A 68 Days Citywide Projects SR2007 803,463.00 0.1000 - - 62.77 803,525.77 803,525.77 803,525.77 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,825,389.04 - - 689.71 8,826,078.75 8,826,078.75 8,826,078.75 - C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING NOVEMBER 30th, 2014 64 65 TOTAL OPERATIONS 18% TOTAL LOGIC 12% TOTAL LONESTAR 40% TOTAL TEXAS CLASS 19% TOTAL CAPITAL ONE 6% TOTAL C.D.s 5% City Portfolio By Investment Type 66 Operations, $16,064,202.78 Projects, $13,622,051.33 Debt Service Fund, $1,001,099.59 Special Revenue Funds, $15,482,820.10 Designated Funds, $1,372,648.09 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 0.0400 3 Month T-Bill 0.0100 0.0200 6 Month T-Bill 0.0500 0.0700 Schertz Portfolio 0.2422 0.2371 Schertz Bank&Trust 0.0500 0.0500 CD 365 Days 0.4000 0.4000 CD 180 Days 0.6000 0.6000 LOGIC 0.0879 0.0871 LoneStar 0.1300 0.1400 MBIA 0.1000 0.1000 Capital One 1.4135 1.3208 MONTHLY YIELDS 68 C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:11/30/2014 General Fund Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 265,368.34 265,368.34 265,368.34 170.00 0.06 Total Cash & Equivalents 265,368.34 265,368.34 265,368.34 170.00 0.06% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 381.00 100,000.00 116,185.00 104,840.00 4,875.00 4.20 Federal Natl Mtg Assn 1/30/2017 792.00 100,000.00 102,366.80 101,458.00 1,250.00 1.22 US Treasury Note 3/15/2017 836.00 100,000.00 99,835.94 100,321.00 750.00 0.75 US Treasury Note 11/30/2015 365.00 60,000.00 61,936.72 60,726.60 825.00 1.33 US Treasury Note 5/31/2016 548.00 325,000.00 337,135.74 332,237.75 5,687.00 1.69 US Treasury Note 8/31/2016 640.00 275,000.00 277,401.37 277,964.50 2,750.00 0.99 US Treasury Note 7/15/2017 958.00 100,000.00 99,664.06 100,297.00 875.00 0.88 Total Fixed Income 1,060,000.00 1,094,525.63 1,077,844.85 17,012.00 1.55% Total Assets 506.79 1,325,368.34 1,359,893.97 1,343,213.19 17,182.00 1.26% Capital Recovery Assets Cash & Equivalents Due Maturity Shares Cost Mrk Value Projected Annual Income Current Yield Fidelity Prime Mmkt Port Fd #690 249,806.71 249,806.71 249,806.71 160.00 0.06 Total Cash & Equivalents 249,806.71 249,806.71 249,806.71 160.00 0.06% Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 381.00 200,000.00 230,779.00 209,680.00 9,750.00 4.22 Federal Natl Mtg Assn 12/21/2015 386.00 100,000.00 99,989.10 100,146.00 375.00 0.38 US Treasury Note 3/15/2017 836.00 150,000.00 149,753.91 150,481.50 1,125.00 0.75 US Treasury Note 11/30/2015 365.00 305,000.00 312,082.23 308,693.55 4,193.00 1.34 US Treasury Note 5/31/2016 548.00 350,000.00 364,567.38 357,794.50 6,125.00 1.68 US Treasury Note 7/15/2016 593.00 340,000.00 339,690.82 341,672.80 2,125.00 0.63 Total Fixed Income 1,445,000.00 1,496,862.44 1,468,468.35 23,693.00 1.58% Total Assets 439.03 1,694,806.71 1,746,669.15 1,718,275.06 23,853.00 1.37% 69