Loading...
11-AUGUST 2015 FINANCIAL STATEMENTCITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 16,700,082 503,388.27 14,551,375.42 15,633,426.40 - 1,066,655.60 93.61% Franchises 1,986,159 183,970.79 1,636,679.20 1,885,275.13 - 100,883.87 94.92% Permits 1,175,803 106,158.85 1,223,112.57 1,265,783.05 - (89,980.05) 107.65% Licenses 91,229 4,452.00 76,831.50 73,532.00 - 17,697.00 80.60% Fees 2,814,366 195,553.71 2,635,001.06 2,408,222.96 - 406,143.04 85.57% Fines 31,000 2,616.87 29,318.97 28,012.97 - 2,987.03 90.36% Inter - Jurisdictional 720,892 9,672.43 520,938.92 645,930.39 - 74,961.61 89.60% Fund Transfers 1,835,754 141,042.08 1,607,065.13 1,551,462.88 - 284,291.12 84.51% Miscellaneous 462,650 35,616.36 426,305.71 394,770.91 (10.00) 67,889.09 85.33% TOTAL REVENUES 25,817,935 1,182,471.36 22,706,628.48 23,886,416.69 (10.00) 1,931,528.31 92.52 %d EXPENDITURE SUMMARY GENERALGOVERNMENT CITY COUNCIL Personnel Services 23,575 1,813.46 22,014.97 21,185.09 - 2,389.91 89.86% Supplies 1,800 - 476.41 608.25 - 1,191.75 33.79% City Support Services 40,600 113.00 40,100.32 29,422.29 - 11,177.71 72.47% Operations Support 400 - 286.13 219.93 - 180.07 54.98% Staff Support 21,300 1,110.00 13,149.78 12,042.55 - 9,257.45 56.54% TOTAL CITY COUNCIL 87,675 3,036.46 76,027:61 63,478.11 - 24,196.89 72.40 %i' CITY MANAGER Personnel Services 833,454 64,176.99 823,563.85 758,963.46 - 74,490.54 91.06% Supplies 3,000 81.62 2,722.05 2,611.13 304.98 83.89 97.20% City Support Services 2,540 - 1,762.50 2,535.46 - 4.54 99.82% Staff Support 28,480 5,030.72 17,204.68 23,902.09 1,738.28 2,839.63 90.03% Professional Services - - 1,200.00 - - - 0.00% Operating Equipment 725 - - 724.91 - 0.09 99.99% TOTAL CITY MANAGER 868,199' 69,289.33 846,45108 788,737.05 2,043.26 77,418:69 91.08 %s' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 301,231 20,643.68 257,060.00 242,050.31 - 59,180.69 80.35% Supplies 3,500 94.40 1,497.26 887.97 254.16 2,357.87 32.63% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 - 1,561.00 1,928.00 - 2,572.00 42.84% Staff Support 7,710 322.32 4,932.11 2,274.01 951.90 4,484.09 41.84% Court Support 560 - - 210.00 - 350.00 37.50% Professional Services 68,340 4,068.75 47,772.65 41,392.75 - 26,947.25 60.57% Maintenance Services 2,800 550.00 1,900.00 1,900.00 - 900.00 67.86% Operating Equipment 800 - 37.27 280.70 - 519.30 35.09% TOTAL MUNICIPAL COURT 390,441= 25,679.151 314,760.29 290,923.74 1,206.06 98,311.20 74.82 %' CUSTOMER RELATIONS -311 Personnel Services 113,241 9,005.17 100,833.65 95,178.24 - 18,062.76 84.05% Supplies 200 - 121.35 164.70 - 35.30 82.35% Staff Support 750 31.03 171.00 484.51 - 265.49 64.60% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS -311 114,691 9,036.20 101,126.00 95,827.45 - 18,86155 8155% PLANNING & ZONING Personnel Services 133,705 10,712.40 115,078.06 119,033.70 - 14,671.30 89.03% Supplies 4,875 1,724.52 962.29 3,014.37 706.34 1,154.29 76.32% Operations Support 99 67.08 - 98.56 - 0.44 99.56% Staff Support 18,580 3,365.50 1,961.68 11,387.03 3,013.76 4,179.21 77.51% Professional Services 82 - 21.00 72.00 - 10.00 87.80% Operating Equipment 486 - - 486.00 - - 100.00% TOTAL PLANNING & ZONING 157,827r 15,869.50` 118,023.03 134,091.66 3,720.10 20,015:24 87.32% LEGAL SERVICES Operations Support 10,000 425.09 5,585.27 5,101.62 84.76 4,813.62 51.86% Professional Services 350,000 11,874.59 228,398.50 151,423.97 - 198,576.03 43.26% TOTAL LEGAL SERVICES 360,000! 12,299.68' 233,983.77 156,525.59 84.76' 203,389.65 4150 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES 167,772 12,776.46 147,741.28 150,269.77 - 17,50223 89.57% Personnel Services 590,190 43,049.40 494,463.32 531,605.38 1,553.96 57,030.66 90.34% Supplies 60,004 6,357.59 47,515.26 46,635.53 6,327.82 7,040.65 88.27% Utility Services 99,880 8,362.31 77,861.19 78,066.51 - 21,813.49 78.16% Staff Support 11,749 260.83 8,777.07 7,081.14 1,225.26 3,442.60 70.70% Maintenance Services 31,900 259.99 13,434.16 26,914.64 1,170.84 3,814.52 88.04% Rental /Leasing 421 - - 420.75 - 0.25 99.94% Operating Equipment 10,800 - 16,499.44 3,360.49 880.00 6,559.51 39.26% Capital Outlay - - 5,289.35 - - - 0.00% TOTAL GENERAL SERVICES 804,944 58,290.12 663,839.79 694,084.44 11,157.88' 99,701.68 87.61% BUILDING 6 -8 MAINTENANCE 1,243,779 - 899,821.37 1,037,439.52 116,422.02 89,917.46 92.77% Supplies 25,250 2,179.94 22,013.86 23,550.14 810.47 889.39 96.48% Utility Services 89,235 8,073.65 64,165.98 61,704.91 - 27,530.09 69.15% Maintenance Services 63,700 2,120.69 41,724.19 49,511.93 685.42 13,502.65 78.80% Operating Equipment 23,000 - 20,503.10 22,027.00 - 973.00 95.77% TOTAL BUILDING 6 -8 MAINTENANCE 201,185 12,374.28 148,407.113 156,793.98 1,495.89 42,895.13 78.68% CITY SECRETARY Personnel Services 167,772 12,776.46 147,741.28 150,269.77 - 17,50223 89.57% Supplies 1,200 97.14 559.27 757.05 - 442.95 63.09% City Support Services 9,700 - 9,576.38 2,638.27 115.00 6,946.73 28.38% Operations Support 150 - 50.00 - - 150.00 0.00% Staff Support 8,795 171.86 4,496.77 3,859.35 160.00 4,775.65 45.70% TOTAL CITY SECRETARY 187,617 113,045.46 162,423.70 157,524.44 275..00 29,817.56 84.11% NON - DEPARTMENTAL City Support Services 511,427 9,522.50 279,256.22 305,514.98 2,200.00 203,712.02 60.17% Operations Support 141,500 (719.82) 127,604.73 114,018.72 5,009.32 22,471.96 84.12% Staff Support 150 - 440.86 80.00 - 70.00 53.33% City Assistance 1,243,779 - 899,821.37 1,037,439.52 116,422.02 89,917.46 92.77% Professional Services 222,400 19,062.61 41,253.35 104,092.24 29,450.00 88,857.76 60.05% Fund Chrgs/Transfrs -Spec Events Fnd 572,800 - - - - 572,800.00 0.00% Operating Equipment 54,465 - 1,955.00 27,471.81 - 26,993.19 50.44% TOTAL NON- DEPARTMENTAL 2,746,521 27,86529 1,350,33153 1,588,617.27 153,081.34' 1,004,822.39 6141 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 257,970 19,379.19 174,325.25 219,013.10 - 38,956.90 84.90% Supplies 3,500 54.99 2,304.19 2,887.12 208.63 404.25 88.45% Operations Support 25,341 2,936.19 10,615.03 13,447.56 22.43 11,871.01 53.15% Staff Support 5,209 51.38 2,942.41 3,552.68 18.00 1,638.32 68.55% Professional Services 13,500 - 4,290.00 589.00 - 12,911.00 4.36% Operating Equipment 2,700 - 99.99 1,921.82 590.00 188.18 93.03% TOTAL PUBLIC AFFAIRS'- 308,220 22,42115! 194,576.87 241,411.28 839.06 65,969.66 78.60% RECORDS MANAGEMENT Personnel Services 52,174 3,809.77 44,118.63 45,475.06 - 6,698.94 87.16% Supplies 400 72.24 141.32 260.06 - 139.94 65.02% Staff Support 1,750 37.13 1,064.14 1,187.87 - 562.13 67.88% Professional Services 10,000 1,003.50 3,329.50 8,380.00 - 1,620.00 83.80% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 64,324 4,922.64' 48,653.59 55,302.99 83.77 8,937.24 86.11 %% SCHERTZ MAGAZINE Personnel Services 137,208 10,646.77 120,379.45 123,845.93 - 13,362.07 90.26% Supplies 200 - 73.94 123.99 - 76.01 62.00% Opperations Support 100 - - - - 100.00 0.00% Staff Support 3,000 58.97 826.06 1,541.50 675.00 783.50 73.88% Professional Services 253,500 19,627.22 175,212.29 195,989.56 300.00 57,210.44 77.43% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - 455.00 - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 404,608 30,332.96` 296,946.74 321,500`.98 975.00' 82,132.02 7910 %s ENGINEERING Personnel Services 187,058 14,607.66 139,384.74 166,638.32 - 20,419.68 89.08% Supplies 1,300 - 738.40 567.02 144.43 588.55 54.73% City Support Services 1,500 - 262.80 262.80 - 1,237.20 17.52% Utility Services 1,498 51.22 523.76 292.52 - 1,205.48 19.53% Staff Support 10,512 275.00 1,426.29 1,153.72 285.48 9,072.80 13.69% Professional Services 38,800 18,486.66 11,671.25 27,669.16 - 11,130.84 71.31% Operating Equipment 600 - 2,001.75 161.49 - 438.51 26.92% TOTAL ENGINEERING 241,268 33,420.545 156,008.99 196,745.03 429.91'' 44,093.06 81.72 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS 2,987,869 221,157.02 2,431,254.84 2,572,196.21 - 415,672.79 86.09% Personnel Services 135,495 10,684.54 118,065.93 123,843.60 - 11,651.40 91.40% Supplies 2,910 - 1,000.61 - 430.00 2,480.00 14.78% Staff Support 5,235 1,601.10 3,817.28 4,411.50 - 823.50 84.27% Rental /Leasing 3,805 - - - - 3,805.00 0.00% Operating Equipment 7,350 - - 3,080.81 2,796.60 1,472.59 0.00% TOTAL GIS 154,795 12,285.64` 122,883.82 131,335.91 3,226.60' 20,232.49 86.93 %` TOTAL GENERAL GOVERNMENT 7,092,315 350,169.00 4,834,445.94 5,072,899.92 178,618.63 1,840,796.45 74.05% PUBLIC SAFETY 14,000 1,316.94 - 4,300.82 - 9,699.18 30.72% POLICE 65,900 - 40,605.71 55,587.67 5,310.98 5,001.35 92.41% Personnel Services 5,149,607 369,298.99 4,305,476.65 4,444,794.20 - 704,812.80 86.31% Supplies 47,646 5,746.94 27,870.79 30,874.45 11,465.23 5,306.32 88.86% City Support Services 26,750 - 26,721.66 24,151.52 - 2,598.48 90.29% Utility Services 127,140 9,210.94 110,095.91 71,248.20 281.66 55,610.14 56.26% Operations Support 2,950 58.96 1,963.46 2,125.67 475.00 349.33 88.16% Staff Support 109,923 8,706.77 68,287.58 83,940.88 28,981.38 (2,999.26) 102.73% City Assistance 8,723 418.54 5,828.15 5,266.70 313.79 3,142.51 63.97% Professional Services 48,058 2,091.79 29,867.65 34,405.71 - 13,652.29 71.59% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 57,632 6,182.70 40,032.36 36,271.31 1,222.38 20,138.31 65.06% Operating Equipment 123,281 9,871.42 101,935.82 76,398.14 30,576.59 16,306.27 86.77% Capital Outlay 228,155 137,850.17 128,505.24 216,867.95 17,065.95 (5,778.90) 102.53% TOTAL POLICE - 5,929,865 549,437.22` 4,846,585.27 5,026,344.73 90,381.98 813,138.29 86.29% FIRE RESCUE Personnel Services 2,987,869 221,157.02 2,431,254.84 2,572,196.21 - 415,672.79 86.09% Supplies 17,050 647.49 8,539.40 5,745.19 5,509.14 5,795.67 66.01% Utility Services 58,700 3,002.78 44,707.72 40,252.52 608.94 17,838.54 69.61% Operations Support 650 230.00 953.37 364.41 - 285.59 56.06% Staff Support 109,100 8,991.64 65,646.88 58,827.77 25,662.99 24,609.24 77.44% City Assistance 16,200 - - 1,138.38 12,564.51 2,497.11 84.59% Professional Services 25,000 - 14,102.00 10,013.00 45.00 14,942.00 40.23% Maintenance Services 62,932 3,622.57 31,399.29 28,328.19 13,596.19 21,007.62 66.62% Rental /Leasing 14,000 1,316.94 - 4,300.82 - 9,699.18 30.72% Operating Equipment 65,900 - 40,605.71 55,587.67 5,310.98 5,001.35 92.41% Capital Outlay 210,600 - 12,146.15 104,880.19 1,653.75 104,066.06 50.59% TOTAL FIRE RESCUE 3,568,001'! 238,968.44` 2,649,355:36 2,881,634.35 64,951.50 621,415.1`5 82.58 % -' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 512,538 39,669.88 400,044.11 416,388.33 - 96,149.67 81.24% Supplies 3,516 228.74 1,485.06 2,074.14 214.82 1,227.04 65.10% Utility Services 6,500 457.44 5,598.10 3,363.55 - 3,136.45 51.75% Operations Support 2,000 465.17 898.00 1,804.11 45.96 149.93 92.50% Staff Support 13,324 2,001.59 4,744.23 7,578.12 2,196.56 3,549.32 73.36% Professional Services 29,300 3,722.50 45.59 20,910.00 - 8,390.00 71.37% Operating Equipment 28,668 - 429.99 667.95 - 28,000.05 2.33% Capital Outlay - - - 20,435.82 - (20,435.82) 0.00% TOTAL INSPECTIONS 595,846 46,545.32 413,245.08 473,222.02 2,457.34 120,166.64 79.83 %` MARSHAL'S OFFICE Personnel Services 583,782 42,655.37 513,778.35 509,899.15 - 73,882.85 87.34% Supplies 6,400 145.54 1,379.85 2,702.45 - 3,697.55 42.23% Utility Services 16,000 819.76 8,937.63 6,623.17 - 9,376.83 41.39% Operations Support 3,500 408.00 995.00 1,063.85 199.98 2,236.17 36.11% Staff Support 14,800 358.32 5,174.01 6,428.83 1,430.35 6,940.82 53.10% City Assistance 2,500 - - 979.60 - 1,520.40 39.18% Maintenance Services 17,700 1,900.00 5,391.14 5,868.20 300.00 11,531.80 34.85% Operating Equipment 19,700 419.90 7,837.37 12,844.49 1,762.01 5,093.50 74.14% Capital Outlay 8,000 - 28,566.00 - - 8,000.00 0.00% TOTAL MARSHAL'S OFFICE 672,382 46,706.89 572,059.35 546,409.74 3,692.34 122,279.92 81.81% TOTAL PUBLIC SAFETY 10,766,094 881,657.87 8,481,245.06 8,927,610.84 161,483.16 1,677,000.00 84.42 %d CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 20,700 420.48 10,152.19 14,466.43 4,606.42 1,627.15 92.14% STREETS 29,000 1,844.86 14,584.37 13,714.89 359.76 14,925.35 48.53% Personnel Services 696,734 53,636.91 601,522.49 621,601.91 - 75,132.09 89.22% Supplies 5,700 342.89 5,863.94 5,437.06 120.10 142.84 97.49% Utility Services 136,200 12,586.91 93,665.67 95,554.66 447.28 40,198.06 70.49% Staff Support 11,805 1,630.44 7,149.23 10,498.63 85.54 1,220.83 89.66% City Assistance 500 - - - - 500.00 0.00% Professional Services 33,225 550.00 2,350.00 25,200.00 - 8,025.00 75.85% Maintenance Services 102,500 8,376.20 122,132.16 62,982.25 25,952.24 13,565.51 86.77% Rental /Lease 200 - 414.72 175.00 - 25.00 87.50% Operating Equipment 300 - 44,159.84 237.56 - 62.44 79.19% Capital Outlay 28,000 - 63,529.00 25,985.49 - 2,014.51 92.81% TOTAL STREETS 1,015,164 77,123.35' 940,787.05 847,672.56 26,605.16 140,886.28 86.12 %' TOTAL PUBLIC ENVIRONMENT 1,015,164 77,123.35 940,787.05 847,672.56 26,60516' 140,886.28 86.12% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 470,301 35,691.65 415,502.99 382,802.21 - 87,498.79 81.40% Supplies 41,905 1,474.90 24,680.20 31,576.05 2,143.15 8,185.80 80.47% Utility Services 143,800 9,283.53 104,257.07 134,984.23 486.03 8,329.74 94.21% Operations Support 250 - - 876.00 - (626.00) 350.40% Staff Support 8,473 532.32 5,330.20 7,663.01 318.57 491.42 94.20% Professional Services 72,000 - 24,952.71 24,662.30 3,691.50 43,646.20 39.38% Maintenance Services 20,000 1,864.36 14,423.15 18,757.46 850.00 392.54 98.04% Rental /Leasing 39,600 3,019.16 28,942.57 34,026.65 3,019.16 2,554.19 93.55% Operating Equipment 2,000 425.09 1,043.45 2,074.01 344.25 (418.26) 120.91% Capital Outlay 60,000 5,660.23 - 59,795.05 - 204.95 99.66% TOTAL PARKS DEPARTMENT 858,329 57,951.24 619,132.34 697,216.97 10,852.66 1150,259.37 82.49% SWIM POOL Supplies 20,700 420.48 10,152.19 14,466.43 4,606.42 1,627.15 92.14% Utility Services 29,000 1,844.86 14,584.37 13,714.89 359.76 14,925.35 48.53% Maintenance Services 203,378 3,986.95 181,504.46 128,439.84 400.00 74,538.16 63.35% TOTAL SWIM POOL 253,078! 6,252.29 206,241.02 156,621.16 5,366.18! 91,090.66 64.01 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 58,642 - 48,476.90 45,048.49 - 13,593.51 76.82% Supplies 15,400 1,235.80 10,386.84 11,136.96 2,218.56 2,044.48 86.72% Utility Services 51,400 4,591.49 36,838.20 39,688.58 - 11,711.42 77.22% Operations Support 22,411 250.00 9,994.39 15,049.00 250.00 7,112.00 68.27% Staff Support 2,448 162.00 2,066.47 1,462.16 - 985.84 59.73% Professional Services 500 - 618.45 - - 500.00 0.00% Operating Equipment 5,000 3,833.81 - 4,932.51 1,999.40 (1,931.91) 138.64% TOTAL EVENT FACILITIES 155,801 10,073.10 108,381.25 117,317.70 4,467.96` 34,01534 7817% SENIOR CITIZEN CENTER Supplies 7,650 534.08 5,852.89 5,621.16 245.07 1,783.77 76.68% Utility Services 4,240 - 414.00 216.78 - 4,023.22 5.11% Operations Support 1,500 - - 591.92 - 908.08 39.46% City Assistence 20,000 582.28 17,390.88 8,650.18 365.58 10,984.24 45.08% Professional Services 8,000 767.09 11,053.28 12,186.09 280.50 (4,466.59) 155.83% Maintenance Services 5,000 - 7,548.20 336.04 125.50 4,538.46 9.23% TOTAL SENIOR CITIZEN CENTER 46,390' 1,88145< 42,259:25 27,602.17 1,016.65' 17,771.1!8 61.69% TOTAL PARKS '& RECREATION 1,313,598 76,160.08 976,013.86 998,758.00 21,703.45! 293,136.55 77.68 %' CULTURAL LIBRARY Personnel Services 672,828 53,616.92 585,308.39 565,086.51 - 107,741.49 83.99% Supplies 13,500 214.19 9,816.56 11,032.12 568.11 1,899.77 85.93% Utility Services 56,500 5,464.79 39,239.07 38,551.07 - 17,948.93 68.23% Operations Support 3,000 15.99 849.83 648.10 860.00 1,491.90 50.27% Staff Support 6,345 77.00 2,750.76 2,348.34 - 3,996.66 37.01% Professional Services 2,300 - 2,190.00 2,175.00 - 125.00 94.57% Operating Equipment 88,000 5,525.75 70,106.14 79,532.11 6,501.32 1,966.57 97.77% TOTAL LIBRARY 842,473 64,914.64` 710,260.75 699,373.25 7,929.43 135,170.32 83.96% TOTAL CULTURAL 842,473 64,914.64 710,260.75 699,373.25 7,929.43 1'35,170.32 83.96% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH 443,792 35,798.54 377,751.39 375,484.96 - 68,307.04 84.61% ANIMAL SERVICES 3,500 116.82 1,826.55 1,066.28 449.73 1,983.99 43.31% Personnel Services 306,397 24,448.95 244,449.12 255,550.06 - 50,846.94 83.40% Supplies 34,783 2,468.47 28,297.64 18,904.73 2,332.75 13,545.52 61.06% Utility Services 46,840 2,127.81 18,124.37 26,736.70 359.57 19,743.73 57.85% Operations Support 1,000 92.85 678.00 609.24 - 390.76 60.92% Staff Support 11,390 906.07 4,572.90 3,353.77 1,199.96 6,836.27 39.98% City Assistance 17,550 1,637.54 8,584.70 10,550.16 - 6,999.84 60.11% Professional Services 26,500 1,622.70 23,674.38 17,295.00 - 9,205.00 65.26% Maintenance Services 23,200 1,353.94 3,498.60 7,963.74 2,075.25 13,161.01 43.27% Operating Equipment 11,500 - 2,659.44 1,491.91 - 10,008.09 12.97% Capital Outlay 24,100 - - - 22,588.15 1,511.85 93.73% TOTAL ANIMAL SERVICES 503,260 34,658.33 334,539.15 342,455.31 28,555.68 132,249.01 7172% TOTAL HEALTH 503,260 34,658.33 334,539.15 342,455.31 28,555.68' 132,249.01 73.72 %' INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 443,792 35,798.54 377,751.39 375,484.96 - 68,307.04 84.61% Supplies 3,500 116.82 1,826.55 1,066.28 449.73 1,983.99 43.31% City Support Services 581,743 5,446.98 321,151.34 367,599.31 16,715.55 197,428.14 66.06% Utility Services 253,722 15,845.49 148,187.57 160,693.75 5,915.80 87,112.45 65.67% Operations Support - - - 50.00 - (50.00) 0.00% Staff Support 37,400 2,714.84 21,938.63 26,027.66 1,361.36 10,010.98 73.23% Maintenance Services 15,600 1,420.43 8,082.47 10,024.59 1,531.30 4,044.11 74.08% Operating Equipment 291,571 17,259.01 274,382.77 167,002.78 84,102.75 40,465.47 86.12% TOTAL INFORMATION TECHNOLOGY 1;,627,328 78,602.11; 1,153,320.72 1,107,949 33 110,076.49 409,302.18 74.85 %'' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 310,863 13,027.81 266,992.64 226,997.33 - 83,865.67 73.02% Supplies 1,000 - 1,028.67 485.41 82.50 432.09 56.79% Human Services 67,000 7,737.95 36,008.24 87,621.49 - (20,621.49) 130.78% Operations Support 10,500 1,470.00 7,983.04 4,620.17 895.00 4,984.83 52.53% Staff Support 15,120 571.00 10,797.37 13,742.75 390.00 987.25 93.47% City Assistance 10,000 935.50 4,831.03 7,744.25 - 2,255.75 77.44% Professional Services 9,200 744.75 2,739.50 8,191.75 - 1,008.25 89.04% Operating Equipment - - 846.08 - - - 0.00% TOTAL HUMAN RESOURCES 423,683 24,487.01 331,226.57 349,403.15 1,367.50 72,91235 82.79% FINANCE Personnel Services 516,715 33,089.85 406,057.16 441,145.00 - 75,570.00 85.37% Supplies 6,750 501.23 2,363.67 5,722.70 145.62 881.68 86.94% Operations Support 1,940 (1,949.84) 834.00 1,937.76 - 2.24 99.88% Staff Support 9,815 795.00 6,108.99 6,438.40 149.00 3,227.60 67.12% Operating Equipment 900 - - 895.86 - 4.14 99.54% TOTAL FINANCE'' 536,120 32,436.24 415,363.82 456,139.72 294.62 79,685:66 85.14% PURCHASING & ASSET MGT Personnel Services 261,548 18,411.84 216,629.72 190,474.95 - 71,073.05 72.83% Supplies 1,200 3.36 389.17 545.75 145.89 508.36 57.64% City Support Services 800 - - 788.40 - 11.60 98.55% Utility Services 905 190.26 286.41 535.80 91.10 278.10 69.27% Operations Support 300 - - 95.97 - 204.03 31.99% Staff Support 6,165 213.50 3,376.10 4,278.04 1,201.23 685.73 88.88% Operating Equipment 2,550 374.99 1,840.63 1,619.99 550.48 379.53 85.12% TOTAL PURCHASING & ASSET MGT 273,468 19,193.95' 222,522.03 198,338.90 1,988.70! 73,140.40 7125% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 313,447 21,537.05 187,563.31 233,073.56 - 80,373.44 74.36% Supplies 174,525 14,864.70 181,924.16 154,833.10 8,317.52 11,374.38 93.48% City Support Services 3,500 154.00 2,100.00 2,386.24 - 1,113.76 68.18% Utility Services 5,000 973.48 3,843.56 3,907.44 - 1,092.56 78.15% Operations Support 400 - - 75.03 - 324.97 18.76% Staff Support 4,500 281.89 2,044.10 4,936.12 31.62 (467.74) 110.39% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 73,750 4,604.22 86,478.07 73,755.86 1,649.13 (1,654.99) 102.24% Rental /Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 - 3,188.79 7,037.00 - 1,163.00 85.82% Capital Outlay 65,000 21,872.00 - 62,368.92 - 2,631.08 95.95% TOTAL FLEET SERVICE 648,702 64,287.34 467,141.99 542,373.27 9,998.27 96,330.46 85.15 %' BUILDING MAINTENANCE Personnel Services 140,150 10,697.10 87,566.45 103,830.40 - 36,319.60 74.09% Supplies 1,043 67.39 325.60 684.23 - 358.77 65.60% Utility Services 2,350 212.61 2,788.40 2,016.35 - 333.65 85.80% Staff Support 2,900 84.64 1,766.40 1,702.39 20.64 1,176.97 59.41% Professional Services 6,240 5,506.58 9,745.00 6,777.60 - (537.60) 108.62% Maintenance Services 93,132 12,814.35 98,989.75 96,163.77 1,457.78 (4,489.55) 104.82% Rental /Leasing 1,400 170.25 - 467.00 - 933.00 33.36% Operating Equipment 5,500 - 3,712.50 1,438.43 3,721.91 339.66 9182% Capital Outlay 43,510 - - 934.43 34,674.00 7,901.57 81.84% TOTAL BUILDING' MAINTENANCE 296,225! 29,55192< 204,894.10 214,014.60 39,874.33' 42,336.07 85.71 %' TOTAL INTERNAL SERVICE 3,805,526' 248,559.57 2,794,469.23 2,868,218.97 163,599.91 773,707.12 79.67% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 - 5,000.00 5,000.00 - - 100.00% Transportation Assistance 31,678 - 22,020.00 31,678.00 - - 100.00% Children's Advocacy Assistance 5,000 - - - - 5,000.00 0.00% Senior Citizen's Hot Meals 45,000 - 55,628.00 - - 45,000.00 0.00% TOTAL CITY ASSISTANCE 86,678 - 82,648.00 36,678.00 - 50,000.00 42.32% COURT - RESTRICTED FUNDS Fund Charges /Transfers - - - - - - 0.00% Operating Equipment 85,872 - 840.00 - 1,840.00 84,032.00 2.14% TOTAL CITY ASSISTANCE 85,872 - 840.00 - 1,840.00! 84,032.00 2.14 %' TOTAL MISC & PROJECTS 172,550 - 83,488 36,678 1,840` 134,032.00 22.32% TOTAL` EXPENDITURES 25,510,980 1,733,242.84 19,155,249.04 19,793,666.85 590,335.42 5,126,977.73 79.90% REVENUE OVER(UNDER) EXPEND. 306,955 ! 4,092,749.84 GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,251,296.25 Cash in Investments LOGIC Investment - General Fund 7,444,075.09 LOGIC Investment -Equip Replacement 73,719.22 LOGIC Investment -Veh Replacement 306,955.39 LOGIC Investment -Air Condi Replacment 196,258.65 CAPITAL ONE Investment - General Fund 1,353,996.80 Total Cash in Bank & Investments $10,772,883.24 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014 -15 357,436 356,940 4,463,962 2,741,991 1,198,153 85,775 44,720 25,398 30,488 49,777 14,839 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 292444 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 Sales Tax - General Fund $250,000 00,000 $L $1 $1 50,000 00,000 50,000 g OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014 -15 215,257 172,814 172,628 227,438 02013 -14 -------------------------- 133,486 ---- - --- -- - - - - -- ------ _ 115,592 176,520 ___ -------------------------------------- 213,412 -------------------------------------- - - -- -- -- - - - - -- -- - - - - -- 2012 -13 101,440 94,054 96,303 123,044 02011 -12 96,392 76,414 77,398 103,230 02010-11 83,433 62,692 67,561 1 95,887 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31 st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 106,125.00 - 118,222.00 - - 106,125.00 0.00% Wilenchik Walk for Life 25,000.00 - 23,464.72 13,925.54 - 11,074.46 55.70% Hal Baldwin Scholarship 18,750.00 - 23,762.00 19,102.00 - (352.00) 0.00% Miscellaneous 3,925.00 302.50 7,035.68 1,623.99 - 2,301.01 41.38% TOTAL REVENUES 153,800.00 302.50 172,484.40 34,651.53 - 119,148.47 15.36% 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 - 10,283.94 12,331.93 - 2,668.07 82.21% Employee Appreciation Event 15,000.00 - 11,510.21 11,155.79 - 3,844.21 74.37% National Night Out 200.00 - - - - 200.00 0.00% Wilenchik Walk for Life 25,000.00 - 23,464.72 13,925.54 - 11,074.46 55.70% Schertz Sweetheart 35,000.00 26.79 33,502.64 14,847.34 2,750.00 17,402.66 50.28% Jazzfest 20,000.00 - 14,504.83 20,020.00 - (20.00) 100.10% Hal Baldwin Scholarship 18,750.00 16.00 8,730.20 12,325.68 - 6,424.32 65.74% Other Events 14,000.00 859.97 52,877.26 6,320.32 470.00 7,209.68 48.50% TOTAL CULTURAL 142,950.00 902.76 154,873.80> 90,926.60 3,220.00 48,803.40 65.86% TOTAL' EXPENDITURES 153,800.00 902.76 154,873.80 90,926.60 3,220.00 59,653.40 61.21% REVENUE OVER(UNDER) EXPEND - {56,275:07} SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 13,705.81 Cash in Investments Texas Class- Special Events 16,802.87 Total Cash in Bank & Investments $ 30,508.68 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 119,572.00 9,964.33 70,794.59 97,430.89 - 22,141.11 81.48% Fund Transfers 109,428.00 - - - - 109,428.00 0.00% Miscellaneous - - - 2.00 - (2.00) 0.00% TOTALREVENUES 229,000.00 9,964.33 70;794.59 97,432.89 - 131,567.11 42.55% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 229,000.00 3,170.49 51,893.44 74,62175 8,537.95 145,840.30 36.31% TOTAL GENERAL GOVERNMENT 229,000.00 3,170.49 51,893.44 74,621.75 ;8,537.95 145,840.30 36.31% MISC & PROJECTS Projects - 620.98 - 2,456.36 - (2,456.36) 0.00% TOTAL MISC & PROJECTS - 620.98 2,456.36 - (2,456.36) 0.00 %` TOTAL EXPENDITURES 229,000.00 3,791.47 51;893.441 77,078.11 8,537.95 143,383.94 37.39 %' REVENUE OVER(UNDER) EXPEND - 20,354.78 ? PEG FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Cash Balance $ 427,294.23 Total Cash in Bank & Investments $ 427,294.23 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31, 2015 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 211,813 - 170,080.88 179,549.35 - 32,263.65 84.77% Permits 60,000.00 - 56,903.86 66,063.85 - (6,063.85) 110.11% Fees 17,169,500 1,733,260.24 15,174,688.21 15,697,602.65 - 1,471,897.35 91.43% Fund Transfers 276,425 11,426.08 113,956.37 125,686.88 - 150,738.12 45.47% Miscellaneous 142,940 27,517.03 232,049.25 129,306.68 - 13,633.32 90.46% TOTAL REVENUES 17,860,678 1,772,203.35 15,747,678.57 = 16,198,209.41 - '' 1,662,468.59 90.69 %` EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 450,477 32,215.07 369,064.72 397,742.74 - 52,734.26 88.29% Supplies 4,600 593.01 3,829.53 3,182.88 169.00 1,248.12 72.87% Human Services 183 - 116.95 - - 183.00 0.00% City Support Services 24,098 - - 831.00 - 23,267.00 3.45% Utility Services 520 51.42 - 154.26 51.42 314.32 39.55% Operations Support 123,000 4,820.72 104,022.00 110,758.29 - 12,241.71 90.05% Staff Support 7,300 366.73 2,657.11 2,373.11 43.30 4,883.59 33.10% Professional Services 77,252 5,219.90 25,036.52 70,797.53 - 6,454.47 91.64% Maintenance Services 13,440 840.00 6,540.00 10,515.00 - 2,925.00 78.24% Operating Equipment 1,550 - - - - 1,550.00 0.00% TOTAL BUSINESS OFFICE 702,420 44,106.85 511,266.83 596,354.81 263.72 105,801.47 84.94 %' W & S ADMINISTRATION Personnel Services 1,255,365 85,671.42 1,031,778.38 1,029,376.95 111.00 225,877.05 82.01% Supplies 193,150 18,900.92 118,690.18 143,965.54 8,053.18 41,131.28 78.71% Human Services 1,000 - 389.95 476.00 - 524.00 47.60% City Support Services 103,403 - 62,051.99 36,399.78 - 67,003.22 35.20% Utility Services 3,454,440 426,032.48 2,932,981.91 2,912,053.37 394.10 541,992.53 84.31% Operations Support 9,250 31.85 2,470.70 7,556.46 412.20 1,281.34 86.15% Staff Support 31,150 2,276.80 23,331.92 19,849.63 683.36 10,617.01 65.92% City Assistance 1,900 - 708.25 1,206.00 - 694.00 6147% Professional Services 259,113 12,419.50 217,873.77 161,206.53 19,027.90 78,878.57 69.56% Fund Charges /Transfers 3,492,504 353,099.47 2,607,144.53 2,759,627.12 - 732,876.88 79.02% Maintenance Services 6,543,586 556,099.78 5,318,490.51 5,744,389.14 117,443.56 681,753.30 89.58% Other Costs 35,000 100.00 27,650.20 31,030.20 - 3,969.80 88.66% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31, 2015 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER FINANCIAL SUMMARY CURRENT BUDGET CURRENT PERIOD PRIOR YEAR Y -T -D ACTUAL Y -T -D ACTUAL Y -T -D ENCUMBR BUDGET BALANCE 91.67% OF BUDGET Debt Service 1,534,512 21,237.50 424,984.65 420,674.80 - 1,113,837.20 27.41% Rental- Leasing 6,070 - 2,684.95 3,091.21 - 2,978.79 50.93% Operating Equipment 21,200 - 15,606.90 16,329.92 399.98 4,470.10 78.91% Capital Outlay 124,500 650.00 431,526.00 71,451.64 32,904.13 20,144.23 83.82% TOTAL PUBLIC WORKS 17,066,143 1,476,519.72 13,218,364.79 ` 13,358,684.29 179,429.41 3,528,029.30 79.33% MISC & PROJECTS PROJECTS Fund Charges /Transfers - - - 945,227.88 - (945,227.88) 0.00% TOTAL PROJECTS - - - 945,227.88 - (945,227.88) 0. o% TOTAL MISC &'PROJECTS - - - 945,227.88 - (945,227 88) 0.00 %` TOTAL EXPENDITURES 17,768,563 1,520,626.57 13,729,631.62 14,900,266.98 179,693.13 2,688,602.89 84.87 %' " REVENUE OVER(UNDER)EXPENSES " 92,115 1,297,942.43 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 256,618.57 Cash in Investments Lone Star Investment -Water &Sewer Lone Star Investment -W &S Customer Deposits Lone Star Investment -W &S Equip Replacement Lone Star Investment -W &S Veh Replacement Lone Star Investment - Water /SSLGC SAWS Schertz Bank & Trust - Certificate of Deposit 1,571,582.69 295, 712.49 177, 796.21 256,842.84 327,284.88 1,068,630.27 $ 3,697,849.38 Total Cash in Bank & Investments $ 3,954,467.95 '' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,416,343 512,823.67 4,909,297.43 5,111,808.31 50.00 1,304,484.69 79.67% Inter - Jurisdictional 1,601,076 (44,406.70) 1,556,080.02 1,572,631.02 - 28,444.98 98.22% Miscellaneous 169,500 1,845.27 101,106.76 48,427.36 - 121,072.64 28.57% TOTALREVENUES 8,186,919 470,26224 6,566,484.21 6,732,866.69 50.00 1,454,00231 82.24 %' EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,111,899 231,045.55 2,664,236.50 2,855,879.09 - 256,019.91 91.77% Supplies 386,786 35,887.59 266,210.32 320,809.72 55,554.82 10,421.46 97.31% Human Services 1,000 477.00 424.00 1,151.50 - (151.50) 115.15% City Support Services 35,052 - 17,826.32 14,617.51 - 20,434.49 41.70% Utility Services 135,305 8,728.50 118,027.91 93,015.04 702.88 41,587.08 69.26% Operations Support 112,328 5,338.36 79,928.67 90,610.00 2,631.67 19,086.33 83.01% Staff Support 85,353 4,223.28 68,639.73 70,006.88 8,707.82 6,638.30 92.22% City Assistance 11,900 32.00 11,547.30 11,888.73 - 11.27 99.91% Professional Services 107,000 8,102.13 88,858.13 105,133.13 2,218.95 (352.08) 100.33% Fund Charges/Transfers 3,366,084 265,875.41 1,876,451.76 2,071,949.35 - 1,294,134.65 61.55% Maintenance Services 42,971 1,720.00 15,344.05 26,723.79 4,800.00 11,447.21 73.36% Debt Service 270,820 - 6,331.91 12,383.35 - 258,436.65 4.57% Rental- Leasing 81,541 5,795.07 - 64,325.28 5,795.07 11,420.65 85.99% Operating Equipment 265,080 5,471.04 82,222.04 156,713.98 20,427.92 87,938.10 66.83% Capital Outlay 138,382 - - 50,74619 890,501.84 (802,866.13) 680.18% TOTAL PUBLIC SAFETY 8,151,501 572,695.93 5,296,048.64 5,945,953.64 i' 991,340.97 1,214,206.39 85.10 %` TOTAL EXPENDITURES 8,151,501 572,695493 5,296,048.64 5,945,953.64 991,340.97 1,214,206.39 85.10°% *„ REVENUE OVER(UNDER) EXPENSES 35,418 786,913.05 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 173,285.79 Cash in Investments Texas Class- Tax Note 2015 Ambulances 893,778.50 Total Cash in Bank & Investments $ 1,067,064.29 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 * * * * * * * * ** 2 0 14 - 2 0 1 5 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 456,029 34,038.26 339,737.50 406,430.64 12.52 Permits 3,000 220.00 3,340.00 2,760.00 - 240.00 92.00% Fees 1,155,500 91,834.96 945,567.18 994,052.11 - 161,447.89 86.03% Miscellaneous 25,700 222.83 1,047.57 26,733.68 - (1,033.68} 104.02% TOTAL REVENUES 1,184,200 92;277.79 949,954.75 1,023,545.79 - 160,654.21 '! 86.43% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 456,029 34,038.26 339,737.50 406,430.64 12.52 49,585.84 89.13% Supplies 8,300 51.48 4,758.06 5,212.58 - 3,087.42 62.80% Human Services 325 - 61.00 - - 325.00 0.00% City Support Services 27,932 - 2,166.61 2,921.79 984.25 24,025.96 13.98% Utility Services 30,370 1,182.90 22,193.57 15,617.14 396.95 14,355.91 52.73% Operations Support 2,460 - - 64.97 7.45 2,387.58 2.94% Staff Support 8,116 176.42 4,325.82 4,163.71 59.46 3,892.83 52.04% City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 396.88 2,925.48 6,348.32 - 17,151.68 27.01% Fund Charges/Transfers 221,818 18,401.49 180,128.74 202,416.39 - 19,401.61 91.25% Maintenance Services 47,000 - 6,012.27 1,457.90 25,920.00 19,622.10 58.25% Other costs 200 - 200.00 100.00 - 100.00 50.00% Debt Service 140,530 - 2,073.16 9,256.62 - 131,273.38 6.59% Rental /Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 591.01 11,303.80 4,682.65 - 817.35 85.14% Capital Outlay - 24,322.00 - - - 0.00% TOTAL DRAINAGE 973,420 54,838.44 600,208.01 658,672.71 27,380.63 287,366.66 70.48 %S PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 - - 591.34 - 408.66 59.13% Professional Services 7,700 - 22,240.00 5,138.75 8,000.00 (5,438.75) 170.63% Maintenance Services 134,298 - 16,800.00 137,784.59 44,478.30 (47,964.89) 135.72% TOTAL PROJECTS 146,198 39,040.00 143,514.68 52,478.30: (49,794.98) 134.06 %'< TOTAL EXPENDITURES 1,119,618 54,838.44 639,248.01 802,187.39 79,858.93 237,571.68 78.78 %< " REVENUE OVER(UNDER) EXPEND' 64,582 ! 221,358.40 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking 232,957.14 Cash in Investments Lone Star Investment - Drainage Maint Fund 806,683.02 Total Cash in Bank & Investments $ 1,039,640.16 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Iy: w: ak, Lei .� 1► i► Ie1:�'1 Taxes 544,753 11,046.94 457,078.17 449,609.52 - 95,143.48 82.53% Miscellaneous 600 86.65 361.05 552.61 - 47.39 92.10% TOTAL REVENUES 545,353 11,13159 457,439.22 450,162.13 - 95,190.87 82.55 %` EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - - - - 2,500.00 0.00% City Support Services 61,500 18,154.80 66,786.10 50,663.68 - 10,836.32 82.38% Operations Support 69,500 450.00 25,652.48 15,715.15 1,386.00 52,398.85 24.61% Professional Services 5,825 - 2,800.00 3,000.00 - 2,825.00 51.50% Fund Charges/Transfers 126,405 5,533.75 274,991.62 84,371.25 - 42,033.75 66.75% Maintenance Services - - 23,462.00 - - - 0.00% Operating Equipment 37,000 - 8,665.59 5,81824 3,712.60 27,469.16 25.76% TOTAL NONDEPARTMENTAL 302,730 ` 24,138.55 402,357.79 159,568.32 5,098.60 138,063.08 54.39% TOTAL EXPENDITURES 302,730 24,138.55 402,357.79 159,568.32 5,098.60 138,063.08 54.39 %` REVENUE OVER(UNDER) EXPENDITURE 242,623 290,593.81 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 254,874.46 Cash in Investments Texas Class - Hotel Tax 499,622.65 Total Cash in Bank & Investments $ 754,497.11 HOTEL OCCUPANCY TAX $80,000 $70,000 - - -- - - - - - - - - - - - - $60,000 $50,000 $40,000 -- - - - - - - - - - - $30,000 $20,000 - - - - - - - - - - - - - - - - - $10,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014 -15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 201314 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 1 36,728 28,215 34,157 45,854 53,433 42,181 32,294 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 100,000 - 132,150.00 18,000.00 - 82,000.00 18.00% Miscellaneous - 8.21 2,806.28 95.81 - (95.81) 0.00% TOTAL REVENUES 100,000 8.21 134,956.28 18,095.81 - 81,904.19 18.10% EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges /Transfers 32,405 - - 32,405.00 - - 100.00% Capital Outlay 60,000 - - 10,930.00 7,184.49 41,885.51 30.19% TOTAL PARKLAND DEDICATION 92,405 - - 43,335.00 7,184.49 41,885.51 54.67 %'' TOTAL EXPENDITURES 92,405 - - 43,335.00 7,184.49 41,885.51 54.67% REVENUE OVER(UNDER);EXPEND 7,595 (25,239.19); PARK FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $165,551.76 Cash in Investments Texas Class- Park Fund 1,356.33 Total Cash in Bank & Investments $166,908.09 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 30th, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 36,000 - 241,272.50 191,487.50 - (155,487.50) 531.91% Fund Transfers 176,939 - - - - 176,939 0.00% Miscellaneous 210 64.18 210.02 372.31 - (162.31) 177.29% TOTAL REVENUES 213,149 64.18 241,482.52 191,859.81 - 21,289.19 90.01% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 212,939 62,645.92 39,956.30 71,799.92 - 141,139.08 33.72% TOTAL TREE MITIGATION 212,939 62,645.92 39,95630 71,799.92 141,139.08 33.72% TOTAL EXPENDITURES 212,939 (62,581.74) 39,956.30 71,799.92 - (119,849.89) REVENUE OVER(UNDER);EXPEND 210 ` 120,059.89 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 30th, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $81,672.95 Cash in Investments MBIA Investment-Tree Mitigation 397,592.05 Total Cash in Bank & Investments $479,265.00 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: AUGUST 30th, 2015 2O14'3U15 411 -CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL Y�-DACTUAL ENCUK48R BALANCE BUDGET REVENUE SUMMARY Fees 00,200 114,426.00 732�33.00 1.096.906.30 - (210.00.30) 124.62% Miscellaneous 5,3K00 712.97 523771 589703 �_ (5}7.63) 111.28% TOTALREVENUES 885,500 115,138.97 737,270.71 1,102,803.93 (217,303.93 124.54% EXPENDITURE SUMMARY GENERAL GOVERNMENT Supplies 5,000 5i000.00 0.00% Operations Support 100 109.00 0.00% Professional Services 80.000 1.000.00 1.000.08 025.00 79.000.00 2.03% Fund Charges/Transfers 116.000 77.778.00 3.579.00 112.421.00 3.09% Maintenance Services 1.000 1.000�00 0.00% Capital Outlay 45[\00} -_ - - -_ 4{0\000Ix} 0JI0% TOTAL NUN DEPARTMENTAL ' .'. 4,579.00 625.00 647,530.00 0.80% � Water Projects -_ -_ - 8518610 186J32.71 _(271,91i8.81) {.0}% TOTAL 8C 8` . '''''''''''- ' ---------- .----------_ ---------' ------------ |.OI086 ---' . TOTAL EXPENDITURES 652,109 - 78,778.00 89,765.10 187,357.71 375,611.19 42.50% REVENUE OVER(UNDER) EXPENDITURES 233,391 1,013,038.83 CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: AUGUST 30th, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,218,671.82 Cash in Investments Lone Star Investment - Capital Recovery Water 4,498,314.56 Total Cash in Bank & Investments $ 5,716,986.38 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 30th, 2015 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,400 80,592.00 417,615.38 639,343.44 - (38,943.44) 106.49% Fund Transfers 559,497 - 77,778.00 - - 559,497.00 0.00% Miscellaneous 600 (148.88) 11,954.77 15,036.06 - (14,436.06) 2506.01% TOTAL REVENUES 1,160,497 80,443.12! 507,348.15 654,379.50 - 506,117.50 56.39% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,143 360.30 4,932.26 4,949.86 - (1,806.86) 157.49% Fund Charges /Transfers 139,312 - - - - 139,312.00 0.00% TOTAL NON DEPARTMENTAL 142,455 ` 360.30 ` 4,932.26 4,949.86 - 137,505.14 3.47% 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 360.30 < 4,932.26 4,949.86 - 1,155,547.14 0.43% REVENUE OVER(UNDER) EXPENDITURES - 649,429.64 CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: AUGUST 30th, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 808,318.57 Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,953,845.58 Capital One-Investment 1,734,500.60 Total Cash in Bank & Investments $ 4,496,664.75 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 30th, 2015 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 91.67% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,338,513 12,035.05 5,286,790.76 5,409,914.60 - (71,401.60) 101.34% Miscellaneous 368,763 132.70 8,817,552.19 353,515.44 - 15,247.56 95.87% TOTAL REVENUES 5,707,276 12,167.75 14,104,342.95 5,763,430.04 - (56,154.04) 100.98% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 400.00 165,650.00 2,750.00 - 39,600.00 6.49% Debt Service 5,593,807 273,871.86 4,657,056.56 5,593,671.28 273,871.86 (273,736.14) 104.89% TOTAL GENERAL GOVERNMENT 5,636,157 274,271.86 14,004,956.79 5,596,421.28 273,871.86 (234,136.14) 104.15% TOTAL EXPENDITURES 5,636,157 274,271.86 14,004;95619 5,596,421.28 273,871.861 (234,136.14) 104.15% " REVENUE OVER(UNDER) EXPEND 71,119 ' 167,008.76 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: AUGUST 30th, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 29,875.65 Cash in Investments IVIBIA Investment- Tax I&S 796,309.54 Total Cash in Bank & Investments $ 826,185.19 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 91.67% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,682,057 261,421.16 3,200,261.80 3,088,884.15 - 593,172.85 83.89% Miscellaneous 10,200 1,147.64 7,249.97 13,701.54 - (3,501.54) 134.33% TOTAL REVENUES 3,692;257 262,568.80 3,207,51177 3,102,585.69 - 589,67131 84.03 %' EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 364,312 19,781.31 275,139.69 161,928.32 - 202,383.68 44.45% Supplies 1,050 15.41 470.89 606.15 15.98 427.87 59.25% Human Services 1,000 - - 135.00 - 865.00 13.50% City Support Services 16,545 4.00 1,174.29 1,118.09 - 15,426.91 6.76% Utility Services 4,120 122.45 1,736.59 908.45 51.42 3,160.13 23.30% Operations Support 147,145 1,505.70 95,383.53 56,736.99 278.01 90,130.00 38.75% Staff Support 18,250 917.19 6,092.31 3,016.00 628.28 14,605.72 19.97% City Assistance 1,025,000 50.94 501,524.63 76.91 - 1,024,923.09 0.01% Professional Services 92,500 4,533.05 17,438.91 11,555.00 - 80,945.00 12.49% Fund Charges /Transfers 471,280 8,674.33 492,148.88 446,486.38 - 24,793.62 94.74% Debt Service 430,608 - 427,671.25 430,609.25 - (1.25) 100.00% Operating Equipment 2,000 - 38.99 368.77 - 1,631.23 18.44% TOTAL ECONO DEVELOPMENT 2,573,810 35,604.38 1,818,819.96 1,113,545.31 973.69 1,459,291.00 43.30 %' MISC & PROJECTS PROJECTS 450,000 215,445.80 - 247,364.89 - 202,635.11 54.97% TOTAL MISC& PROJECTS 450,000 215,445.80 247,364.89 - 202,635.11 0.00 %' TOTAL EXPENDITURES 3,023,810 251,050.18 1,818,819.96 1,360,910.20 973.69 1,661,926.11 45.04% " REVENUE OVER(UNDER) EXPEND 668,447 1,741,675.49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 392,712.56 Cash in Investments Texas Class Investment-Economic Development Corl 7,584,933.45 Schertz Bank & Trust-Certificate of Deposit 1,049,082.71 Total Cash iin Bank & Investments $ 9,026,728.72 4B SALES TAX By Collection Month 41 ��� C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING AUGUST 31st, 2015 I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING AUGUST 31st, 2015 . INVESTMENT POOLS Beginning Book Value Yiel Deposits/ Purchases Withdrawals Interest Earne Ending Book Value Ending Mkt Value Par Value Maturity Date Weighted Avva Mat. OPERATIONS -BANK CASH Schertz Bank & Trust - Pooled Cash 6,392,869.12 0.0500 5,677,313.51 5,141,708.02 299.44 6,928,774.05 6,928,774.05 6,928,774.05 N/A Schertz Bank & Trust - PEG Fund 418,340.94 0.0000 12,744.76 620.98 - 430,464.72 430,464.72 430,464.72 N/A TOTAL OPERATIONS :::6,811,210.06 ::15,690;058.27 ;:55,142;329.00 299.44. 7.,359,238.77 I7 „359,238 =.77 ;:7,359,238.77 - LOGIC General Fund 7,843,205.76 0.1354 - 400,000.00 869.33 7,444,075.09 7,444,075.09 7,444,075.09 N/A 41 Days G /F- Equipment Replacement 73,710.76 0.1354 - - 8.46 73,719.22 73,719.22 73,719.22 N/A 41 Days G /F- Vehicle Replacement 306,920.11 0.1354 - - 35.28 306,955.39 306,955.39 306,955.39 N/A 41 Days G/F -Air Conditioner Replacement 196,236.08 0.1354 - - 22.57 196,258.65 196,258.65 196,258.65 N/A 41 Days SR2009 Bond- Street Projects(II) 1,031,030.69 0.1354 - - 118.57 1,031,149.26 1,031,149.26 1,031,149.26 N/A 41 Days TOTAL SLOGIC ;`9,451,103.40 - '. 400,000.00 (:1,054.21': 9.,052,157.61 9,052,157(.61 - 9,052,157.61 - LONESTAR Capital Recovery - Sewer 1,953,559.96 0.1700 - - 285.62 1,953,845.58 1,953,845.58 1,953,845.58 N/A 41 Days Capital Recovery - Water 4,497,656.99 0.1700 - - 657.57 4,498,314.56 4,498,314.56 4,498,314.56 N/A 41 Days Drainage Fund 1,006,563.28 0.1700 - 200,000.00 119.74 806,683.02 806,683.02 806,683.02 N/A 41 Days Facilities Master Plan 145,290.13 0.1700 - - 21.24 145,311.37 145,311.37 145,311.37 N/A 41 Days GO SR2011 Animal Shelter 11,529.08 0.1700 - - 1.69 11,530.77 11,530.77 11,530.77 N/A 41 Days GO SR2011 Soccer Fields 210,216.74 0.1700 - - 30.73 210,247.47 210,247.47 210,247.47 N/A 41 Days GO SR2011 Swimming Pool 5,787,077.34 0.1700 - - 846.09 5,787,923.43 5,787,923.43 5,787,923.43 N/A 41 Days GO SR2012 Downtown Improvements 979,951.01 0.1700 - - 143.27 980,094.28 980,094.28 980,094.28 N/A 41 Days SE Elevated Water Tank 810,683.17 0.1700 - - 118.52 810,801.69 810,801.69 810,801.69 N/A 41 Days Sewer /CCMA Project 2,930,068.51 0.1700 - - 428.39 2,930,496.90 2,930,496.90 2,930,496.90 N/A 41 Days W /S- Customer Deposits 295,669.26 0.1700 - - 43.23 295,712.49 295,712.49 295,712.49 N/A 41 Days W /S- Equipment Repl /Cap.Imp 177,770.22 0.1700 - - 25.99 177,796.21 177,796.21 177,796.21 N/A 41 Days Water &Sewer 1,771,327.67 0.1700 - 200,000.00 255.02 1,571,582.69 1,571,582.69 1,571,582.69 N/A 41 Days W /S- Vehicle Replacement 256,805.29 0.1700 - - 37.55 256,842.84 256,842.84 256,842.84 N/A 41 Days Water /SSLG - SAWS 103.41 0.1700 - - 0.02 103.43 103.43 103.43 N/A 41 Days TOTAL LONESTAR. = 20,834;272.06 _ _- 400.;000.00 :3,014.67: 20,437,286.73 - 20,437,286.73 ::20,437,286.73 TEXAS CLASS Tax I &S 796,191.13 0.1600 - - 118.41 796,309.54 796,309.54 796,309.54 N/A 62 Days Police Forfeiture 244,277.54 0.1600 - - 36.33 244,313.87 244,313.87 244,313.87 N/A 62 Days Park Fund 1,356.07 0.1600 - - 0.26 1,356.33 1,356.33 1,356.33 N/A 62 Days Economic Development Corporation 7,783,796.45 0.1600 - 200,000.00 1,137.00 7,584,933.45 7,584,933.45 7,584,933.45 N/A 62 Days Library Board 44,899.82 0.1600 - - 6.70 44,906.52 44,906.52 44,906.52 N/A 62 Days Tree Mitigation 397,532.95 0.1600 - - 59.10 397,592.05 397,592.05 397,592.05 N/A 62 Days Tax Note 2013 Fire Truck 4,934.50 0.1600 - - 0.68 4,935.18 4,935.18 4,935.18 N/A 62 Days Hotel Tax 499,548.36 0.1600 - - 74.29 499,622.65 499,622.65 499,622.65 N/A 62 Days Special Events Fund 16,800.37 0.1600 - - 2.50 16,802.87 16,802.87 16,802.87 N/A 62 Days Citywide Projects SR2007 726,048.69 0.1600 - 220,000.00 86.99 506,135.68 506,135.68 506,135.68 N/A 62 Days Tax Notes 2015 EMS Ambulances 893,645.64 0.1600 - - 132.86 893,778.50 893,778.50 893,778.50 N/A 62 Days Tax Notes 2015 Drainage Equipment 625,469.83 0.1600 - - 93.00 625,562.83 625,562.83 625,562.83 N/A 62 Days Tax Notes 2015 Water Equipment 327,236.23 0.1600 - - 48.65 327,284.88 327,284.88 327,284.88 N/A 62 Days Tax Notes 2015 General Fund Equipme 238,172.13 0.1600 - - 35.43 238,207.56 238,207.56 238,207.56 N/A 62 Days TOTAL':: TEXAS 'CLASS 12,599;:90:9.71 '- - 420,000,00 1,832.20:. 12,181,741.91 12 „181,741:.91 12,181,741.91 - I T Y 0 F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING AUGUST 31st, 2015 INVESUZNT Beginning Purchases Interest Withdrawal, Ending Book Value Mkt Value Par Vali;e Maturity AvQ Mat. MANAGEZ--Z,rCOL7NT Capital One General Fund Book. 1,369,763.58 ylald 2.4200 Earn,A 281.15 190.32 1,369,672.75 1,353,996.80 1,303,747.32 Date N/A 622 Days Capital One Capital Recovery Sewer 1,755,724.03 2.2100 - 360.06 381.61 1,755,745.58 1,734,500.60 1,681,310.23 N/A 630 Days TOTAL CAPITAL ONE 3,125,487A1 - 641.21 571.93 3,125,418.33 3,088,497.40 2,985,057.55 - C. D. CERTIFICATES OF DEPOSIT SB&T-Water&Sewer 1,068,630.27 0.7500 - - - 1,068,630.27 1,073,834.35 1,068,630.27 1/7/2016 To 365 Days Schertz Economic Development Corp. 1,049,082.71 0.6000 - - 1,049,082.71 1,050,548.55 1,049,082.71 12/5/2015 180 Days TOTAL C.D.s 2,117,712.98 - - 2,117,712.98 2,124,382.90 2,117,712.98 TOTAL PORTFOLIO 0.33 $ 6,772.45 $ 54,273,556.33 $ 54,243,305.32 $ 54,133,195.55 89 Days TC TOTAL TEXAS CLASS 220 City Portfolio By Investment Type TOTAL C. D 38% TOTAL LOGIC 170 0 Special RevenUE Funds, $18,771,710.66 $7 City Portfolio By Use M Designated Funds, $1,373,929.37 E3 Operations, $18,802,727.70 ects, $13,687,826.36 2.50 2.00 1.50 1.00 0.50 0.00 MONTHLY YIELDS 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 I Apr_ -15 May -15 Jun -15 Jul -15 Aug -15 Sep -15 01 Month T -Bill 0.0100 0.0400 0.0300 0.0100 0.0200 0.0500 0.0000 0.0100 0.0200 0.0400 0.0000 03 Month T -Bill 0.0100 0.0200 0.0400 0.0200 0.0200 0.0300 0.0100 0.0100 0.0100 0.0800 0.0800 06 Month T -Bill 0.0500 0.0700 0.1200 0.0700 0.0700 0.1400 0.0600 0.0600 0.1100 0.1400 0.2700 DSchertz Portfolio 0.2422 0.2371 0.2197 0.2265 0.2262 0.2283 0.2368 0.2339 0.3006 0.3148 0.3258 BSchertz Bank &Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 BCD 365 Days BCD 180 Days ®LOGIC 0.4000 0.6000 0.0879 0.4000 0.6000 0.0871 0.4000 0.3500 0.0974 0.7500 0.3500 0.0843 0.7500 0.3500 0.0921 0.7500 --- - -- 0.3500 0.0999 0.7500 -- - 0.3500 0.1130 0.7500 - __ - 0.3500 0.1122 0.7500 __ - -- 0.6000 0.1249 0.7500 - -- -- ------------------------ 0.6000 0.1265 0.7500 -- - - - - -- --- - - - - -- 0.6000 0.1354 DLoneStar 0.1300 0.1400 0.1400 0.1300 0.1300 1 0.1400 0.1400 0.1500 0.1600 0.1600 0.1700 DMBIA 0.1000 0.1000 0.1000 0.1100 0.1100 0.1200 0.1400 0.1400 0.1500 0.1600 0.1600 BCapital One 1.4135 1.3208 1.4416 1.4858 1.4594 1.4575 1.4587 1.4596 2.2923 2.2949 2.3005 C I T Y OF S C H E R T Z Investment Report Capital One Assets Date: 8/31/2015 General Fund Assets Capital Recovery Assets Projected Projected Annual Current Annual Current Cash & Equivalents Shares Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 66,310.23 87.00 28,747.32 28,747.32 28 747.32 38.00 0.13 Total Cash & Equivalents 66,310.23 87.00 0.130 28,747.32 28,747.32 28,747.32 38.00 0.130 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 107.00 200,000.00 230,779.00 202,756.00 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 107.00 100,000.00 116,185.00 101,378.00 4,875.00 4.81 1,093.00 Federal Natl Mtg Assn 1/30/2017 518.00 100,000.00 102,366.80 101,076.00 1,250.00 1.24 5,125.00 Federal Home LN Mtg Corp Reference Nts 11/17/2017 809.00 100,000.00 109,860.00 109,180.00 5,125.00 4.69 4.42 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 1017.00 275,000.00 305,095.45 303,385.50 13,406.00 4.42 US Treasury Note 3/15/2017 3/15/2017 562.00 100,000.00 99,835.94 100,209.00 750.00 0.75 US Treasury Note US Treasury Note 776.00 10/15/2017 776.00 100,000.00 99,875.00 100,106.00 875.00 0.87 10/31/2019 US Treasury Note 50,000.00 11/15/2017 807.00 100,000.00 99,425.78 100,058.00 875.00 0.87 807.00 US Treasury Note 99,425.78 11/30/2015 91.00 60,000.00 61,936.72 60,192.60 825.00 1.37 150,000.00 US Treasury Note 151,581.00 5/31/2016 274.00 190,000.00 197,094.74 192,002.60 3,325.00 1.73 99,175.78 US Treasury Note 750.00 2/28/2018 912.00 50,000.00 49,585.94 49,759.50 375.00 0.75 240,523.20 US Treasury Note 0.62 7/15/2017 684.00 100,000.00 99,664.06 100,283.00 875.00 0.87 Total Fixed Income Total Assets 1,275,000.00 1,340,925.43 1, 317, 630. 20 32,556.00 2.47° Total Assets ! 621.68 1,303,747.32 1,369,672.75 1,346,377.52 32,594.00 2.42 %< Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 66,310.23 66,310.23 66,310.23 87.00 0.13 Total Cash & Equivalents 66,310.23 66,310.23 66,310.23 87.00 0.130 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 107.00 200,000.00 230,779.00 202,756.00 9,750.00 4.81 Federal Natl Mtg Assn 10/26/2017 787.00 125,000.00 124,588.38 125,145.00 1,093.00 0.87 Federal Home LN Mtg Corp Reference Nts 11/17/2017 809.00 100,000.00 109,860.00 109,180.00 5,125.00 4.69 Federal Home Mtg Corp Refrnce 8 6/13/2018 1017.00 200,000.00 221,887.60 220,644.00 9,750.00 4.42 Federal Home LN Mtg Corp 3/27/2019 1304.00 100,000.00 108,297.40 108,363.00 3,750.00 3.46 US Treasury Note 3/15/2017 562.00 150,000.00 149,753.91 150,313.50 1,125.00 0.75 US Treasury Note 10/15/2017 776.00 100,000.00 99,644.53 100,106.00 875.00 0.87 US Treasury Note 10/31/2019 1522.00 50,000.00 49,998.05 50,157.50 750.00 1.50 US Treasury Note 11/15/2017 807.00 100,000.00 99,425.78 100,058.00 875.00 0.87 US Treasury Note 5/31/2016 274.00 150,000.00 156,243.16 151,581.00 2,625.00 1.73 US Treasury Note 2/28/2018 912.00 100,000.00 99,175.78 99,519.00 750.00 0.75 US Treasury Note 7/15/2016 319.00 240,000.00 239,781.76 240,523.20 1,500.00 0.62 Total Fixed Income 1,615,000.00 1,689,435.35 1,658,346.20 37,968.00 2.299 Total Assets 629.97 1,681,310.23 1,755,745.58 1,724,656.43 38,055.00 2.21%