Loading...
10-JULY 2015 FINANCIAL STATEMENTJULY 2015 Financial Report CITY OF Prepared By: The Finance Department JANUARY 11, 2016 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 16,700,082 583,568.89 14,037,186.08 15,130,038.13 - 1,570,043.87 90.60% Franchises 1,986,159 169,619.14 1,496,378.34 1,701,304.34 - 284,854.66 85.66% Permits 1,175,803 122,923.00 1,117,533.57 1,159,624.20 - 16,178.80 98.62% Licenses 91,229 7,345.00 72,867.50 69,080.00 - 22,149.00 75.72% Fees 2,814,366 257,362.30 2,424,566.24 2,212,669.25 - 601,696.75 78.62% Fines 31,000 2,616.38 26,314.23 25,396.10 - 5,603.90 81.92% Inter - Jurisdictional 720,892 84,580.74 499,064.05 636,257.93 - 84,634.07 88.26% Fund Transfers 1,835,754 141,042.08 1,460,968.30 1,410,420.80 - 425,333.20 76.83% Miscellaneous 462,650 38,862.44 371,222.86 359,154.55 (10.00) 103,505.45 77.63% TOTAL REVENUES 25,817,935 1,407,919.97 21,506,101.17 22,703,945.30 (10.00) 3,113,999.70 87.94% EXPENDITURE SUMMARY GENERALGOVERNMENT CITY COUNCIL Personnel Services 23,575 2,720.19 19,294.78 19,371.63 - 4,203.37 82.17% Supplies 1,800 93.38 476.41 608.25 - 1,191.75 33.79% City Support Services 40,600 240.05 40,592.63 29,309.29 - 11,290.71 72.19% Operations Support 400 - 279.38 219.93 - 180.07 54.98% Staff Support 21,300 676.37 12,784.78 10,932.55 - 10,367.45 51.33% TOTAL CITY COUNCIL 87,675' 3,729.99'' 73,427.98 60,441.65 - 27,233:35 68.94% CITY MANAGER Personnel Services 833,454 95,150.27 733,141.64 694,786.47 - 138,667.53 83.36% Supplies 3,000 330.48 2,722.05 2,529.51 159.98 310.51 89.65% City Support Services 2,540 - 1,762.50 2,535.46 - 4.54 99.82% Staff Support 28,480 6,283.46 16,532.37 18,871.37 3,996.42 5,612.21 80.29% Operating Equipment 725 (724.91) - 724.91 - 0.09 99.99% TOTAL CITY MANAGER 868,199 101,03930 754,158.56 719,447.72 4,156.40! 144,594.88 83.35% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 301,231 29,693.26 228,749.38 221,406.63 - 79,824.37 73.50% Supplies 3,500 64.33 1,156.35 793.57 142.35 2,564.08 26.74% 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 132.40 4,387.49 1,951.69 804.42 4,953.89 35.75% Court Support 560 - - 210.00 - 350.00 37.50% Professional Services 68,340 3,589.00 44,382.65 37,324.00 180.00 30,836.00 54.88% Maintenance Services 2,800 100.00 1,900.00 1,350.00 450.00 1,000.00 64.29% Operating Equipment 800 - 37.27 280.70 - 519.30 35.09% TOTAL MUNICIPAL COURT 390,441; 33,578.99 282,174.14 265,244.59 1,576.77 123,619.64 6834 %' CUSTOMER RELATIONS -311 Personnel Services 113,241 12,846.88 88,500.77 86,173.07 - 27,067.93 76.10% Supplies 200 - 121.35 164.70 - 35.30 82.35% Staff Support 750 - 171.00 453.48 - 296.52 60.46% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS -311 114,691 12,846.88 88,793.12 86,791.25 - 27,89975 75.67 %` PLANNING & ZONING Personnel Services 133,705 15,410.03 100,695.60 108,321.30 - 25,383.70 81.02% Supplies 4,875 - 834.06 1,289.85 624.90 2,960.25 39.28% Operations Support 99 - - 31.48 67.08 0.44 99.56% Staff Support 18,580 702.00 715.18 8,021.53 3,202.50 7,355.97 60.41% Professional Services 82 6.00 21.00 72.00 - 10.00 87.80% Operating Equipment 486 - - 486.00 - - 100.00% TOTAL PLANNING & ZONING 157,827 16,118.03 102,265.84 118,222.16 3,894.48 35,710.36 77.37% LEGAL SERVICES Operations Support 10,000 125.24 5,252.05 4,676.53 84.76 5,238.71 47.61% Professional Services 350,000 10,687.70 208,242.37 139,549.38 - 210,450.62 39.87% TOTAL LEGAL SERVICES 360,000' 10,812.94 213,494.42 144,225':91 84.76 215,689.33 40.09 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES Personnel Services 590,190 70,706.36 437,833.89 488,555.98 4,038.11 97,595.91 83.46% Supplies 60,004 4,180.10 44,758.81 40,277.94 7,701.51 12,024.55 79.96% Utility Services 99,880 9,488.91 68,925.97 69,704.20 - 30,175.80 69.79% Staff Support 11,749 645.50 7,812.03 6,820.31 471.48 4,457.21 62.06% Maintenance Services 31,900 120.00 13,309.16 26,654.65 223.89 5,021.46 84.26% Rental /Leasing 421 - - 420.75 - 0.25 99.94% Operating Equipment 10,800 3,360.00 9,807.24 3,360.49 - 7,439.51 31.12% TOTAL GENERAL SERVICES 804,944 88,500.87 582,447.10 635,794.32 12,434.99 156,714.69 80.53% BUILDING 6 -8 MAINTENANCE Supplies 25,250 3,794.79 21,438.34 21,370.20 2,104.96 1,774.84 92.97% Utility Services 89,235 7,649.37 56,915.37 53,631.26 - 35,603.74 60.10% Maintenance Services 63,700 9,223.82 40,538.24 47,391.24 2,104.72 14,204.04 77.70% Operating Equipment 23,000 22,027.00 20,503.10 22,027.00 - 973.00 95.77% TOTAL BUILDING 6 -8 MAINTENANCE 201,185 42,694.98 139,395.05 144,419.70 4,209.68 52,555.62 73.88% CITY SECRETARY Personnel Services 167,772 18,638.21 127,952.31 137,493.31 - 30,278.69 81.95% Supplies 1,200 82.75 531.77 659.91 - 540.09 54.99% City Support Services 9,700 - 9,576.38 2,638.27 - 7,061.73 27.20% Operations Support 150 - 50.00 - - 150.00 0.00% Staff Support 8,795 802.00 4,313.77 3,687.49 266.86 4,840.65 44.96% TOTAL CITY SECRETARY 187,617 19,522.96 142,424;23 144,478.98 266.86 42,871.1`6 77.15% NON - DEPARTMENTAL City Support Services 511,427 70.00 272,694.86 295,992.48 2,200.00 213,234.52 58.31% Operations Support 141,500 36,273.12 117,490.23 114,738.54 72.98 26,688.48 81.14% Staff Support 150 - 340.08 80.00 - 70.00 5133% City Assistance 1,243,779 116,422.01 899,82137 1,037,439.52 116,422.02 89,917.46 92.77% Professional Services 222,400 3,217.21 37,302.62 85,029.63 57,512.50 79,857.87 64.09% Fund Chrgs/Transfrs -Spec Events Fnd 572,800 - - - - 572,800.00 0.00% Operating Equipment 54,465 22,570.14 1,955.00 27,471.81 - 26,993.19 50.44% TOTAL NON- DEPARTMENTAL 2,746,521 178,552.48 1,329,604.16 1,560,751.98 176,207.50' 1,009,561.52 6124% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 257,970 28,569.77 152,084.70 199,633.91 - 58,336.09 77.39% Supplies 3,500 56.97 2,212.94 2,832.13 54.99 612.88 82.49% Operations Support 25,341 495.00 10,165.03 10,511.37 2,928.19 11,901.44 53.03% Staff Support 5,209 801.09 2,700.33 3,501.30 38.00 1,669.70 67.95% Professional Services 13,500 - 4,290.00 589.00 - 12,911.00 4.36% Operating Equipment 2,700 - 99.99 1,921.82 - 778.18 71.18% TOTAL PUBLIC AFFAIRS'- 308,220 29,922.83 171,552.99 218,989.53 3,021.18 86,209.29 72.03% RECORDS MANAGEMENT Personnel Services 52,174 5,458.87 38,876.08 41,665.29 - 10,508.71 79.86% Supplies 400 - 127.76 187.82 - 212.18 46.96% Staff Support 1,750 - 1,064.14 1,150.74 - 599.26 65.76% Professional Services 10,000 708.50 3,139.50 7,376.50 455.00 2,168.50 78.32% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 64,324' 6,16737 43,207.48 50,380.35 538.77 13,404.88 79.16 %' SCHERTZ MAGAZINE Personnel Services 137,208 15,458.62 105,531.85 113,199.16 - 24,008.84 82.50% Supplies 200 49.99 73.94 123.99 - 76.01 62.00% Opperations Support 100 - - - - 100.00 0.00% Staff Support 3,000 18.00 826.06 1,482.53 58.97 1,458.50 51.38% Professional Services 253,500 19,929.68 174,462.29 176,362.34 8,235.24 68,902.42 72.82% Fund Charges/Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - 455.00 - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 404,608 35,456.29` 281,349.14 291,168.02 8,294.21 105,145.77 74.01 %s ENGINEERING Personnel Services 187,058 21,413.41 126,407.24 152,030.66 - 35,027.34 81.27% Supplies 1,300 - 567.18 567.02 116.93 616.05 52.61% City Support Services 1,500 - 262.80 262.80 - 1,237.20 17.52% Utility Services 1,498 - 523.76 241.30 - 1,256.70 16.11% Staff Support 10,512 422.37 1,426.29 878.72 - 9,633.28 8.36% Professional Services 38,800 5,772.50 11,671.25 9,182.50 - 29,617.50 23.67% Operating Equipment 600 - 2,001.75 161.49 - 438.51 26.92% TOTAL ENGINEERING 241,268 27,608.28 142,860.27 163,324.49 116.93' 77,826.58 67.74 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS 2,987,869 317,837.22 2,128,288.85 2,351,039.19 - 636,829.81 78.69% Supplies 17,050 212.01 7,846.45 Personnel Services 135,495 15,515.23 103,602.21 113,159.06 58,700 3,887.39 - 22,335.94 - 83.52% 63.46% Supplies 2,910 - 1,000.61 134.41 - 515.59 - 2,910.00 109,100 0.00% 63,354.25 Staff Support 5,235 - 3,327.40 2,810.40 16,200 800.55 - 1,624.05 - 68.98% 7.03% Rental /Leasing 3,805 - - 10,013.00 - 14,987.00 - 3,805.00 62,932 0.00% 29,407.31 Operating Equipment 7,350 - - 3,080.81 14,000 2,983.88 - 4,269.19 0.00% 11,016.12 TOTAL GIS 154,795 1!5,515.23 107,930.22 119,050.27 55,587.67 800.55 5,671.53 34,944.18 Capital Outlay 77.43 %` TOTAL GENERAL GOVERNMENT 7,092,315` 622,067.42 4,455,084.70 4,722,730.92 TOTAL FIRE RESCUE 21!5,60108 2,153,981.00 2,332,705.82 69.63% 23,556.37 PUBLIC SAFETY 74.73 % -' POLICE Personnel Services 5,149,607 549,279.26 3,804,235.39 4,075,495.21 - 1,074,111.79 79.14% Supplies 47,646 1,968.00 25,767.75 25,127.51 7,778.80 14,739.69 69.06% City Support Services 26,750 - 26,721.66 24,151.52 - 2,598.48 90.29% Utility Services 127,140 7,954.53 97,404.19 62,037.26 - 65,102.74 48.79% Operations Support 2,950 58.96 1,850.53 2,066.71 58.96 824.33 72.06% Staff Support 109,923 5,243.32 65,894.30 75,234.11 30,485.64 4,203.25 96.18% City Assistance 8,723 1,754.12 5,828.15 4,848.16 429.54 3,445.30 60.50% Professional Services 48,058 2,886.07 28,712.35 32,313.92 1,174.00 14,570.08 69.68% Fund Charges/Transfers - - - - - - 0.00% Maintenance Services 57,632 5,655.80 35,587.15 30,088.61 396.70 27,146.69 52.90% Operating Equipment 123,281 11,327.04 92,587.42 66,526.72 33,416.67 23,337.61 81.07% Capital Outlay 228,155 7,223.69 128,505.24 79,017.78 148,864.32 272.90 99.88% TOTAL POLICE - 5,929,865 593,350.79 4,313,094.13 4,476,907.51 222,604.63 1,230,352.86 79.25% FIRE RESCUE Personnel Services 2,987,869 317,837.22 2,128,288.85 2,351,039.19 - 636,829.81 78.69% Supplies 17,050 212.01 7,846.45 5,097.70 1,258.25 10,694.05 37.28% Utility Services 58,700 3,887.39 40,145.10 37,249.74 - 21,450.26 63.46% Operations Support 650 - 953.37 134.41 - 515.59 20.68% Staff Support 109,100 4,144.06 63,354.25 49,836.13 16,003.57 43,260.30 60.35% City Assistance 16,200 19.86 - 1,138.38 - 15,061.62 7.03% Professional Services 25,000 9,853.00 13,218.00 10,013.00 - 14,987.00 40.05% Maintenance Services 62,932 2,275.70 29,407.31 24,705.62 - 38,226.38 39.26% Rental /Leasing 14,000 2,983.88 - 2,983.88 - 11,016.12 21.31% Operating Equipment 65,900 14,020.20 37,346.34 55,587.67 4,640.80 5,671.53 91.39% Capital Outlay 210,600 25,245.19 12,146.15 104,880.19 1,653.75 104,066.06 50.59% TOTAL FIRE RESCUE 3,568,001'! 380,478.51' 2,332,705.82 2,642,665.91 23,556.37 901,778.72 74.73 % -' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 512,538 51,861.25 358,712.85 376,718.45 - 135,819.55 73.50% Supplies 3,516 54.40 1,145.96 1,845.40 141.72 1,528.88 56.52% Utility Services 6,500 417.60 5,038.63 2,906.11 - 3,593.89 44.71% Operations Support 2,000 - 898.00 1,338.94 74.17 586.89 70.66% Staff Support 13,324 291.19 4,628.14 5,576.53 1,698.81 6,048.66 54.60% Professional Services 29,300 11,055.00 45.59 17,187.50 - 12,112.50 58.66% Operating Equipment 28,668 467.96 429.99 667.95 - 28,000.05 2.33% Capital Outlay - - - 20,435.82 - (20,435.82) 0.00% TOTAL INSPECTIONS 595,846 64,147.40s 370,899.16 426,676.70 1,914.70 167,254.60 71.93 %` MARSHAL'S OFFICE Personnel Services 583,782 61,806.02 454,057.82 467,243.78 - 116,538.22 80.04% Supplies 6,400 633.49 1,371.11 2,556.91 25.62 3,817.47 40.35% Utility Services 16,000 969.39 7,903.58 5,803.41 - 10,196.59 36.27% Operations Support 3,500 - 919.00 655.85 177.00 2,667.15 23.80% Staff Support 14,800 175.00 3,819.15 6,070.51 725.00 8,004.49 45.92% City Assistance 2,500 - - 979.60 - 1,520.40 39.18% Maintenance Services 17,700 550.20 5,211.14 3,968.20 - 13,731.80 22.42% Operating Equipment 19,700 627.72 7,689.47 12,424.59 718.91 6,556.50 66.72% Capital Outlay 8,000 - 28,566.00 - - 8,000.00 0.00% TOTAL MARSHAL'S OFFICE 672,382 64,761.82 509,537.27 499,702.85 1,646.53 171,032.62 74.56% TOTAL PUBLIC SAFETY 10,766,094 1,102,738.52 7,526,236.38 8,045,952.97 249,722.23 2,470,418.80 77.05% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 20,700 2,791.55 10,152.19 14,045.95 4,693.38 1,960.67 90.53% Utility Services 29,000 2,083.68 12,600.60 STREETS 359.76 16,770.21 42.17% Maintenance Services 203,378 120,177.45 61,567.91 124,452.89 3,803.78 75,121.33 63.06% Personnel Services 696,734 78,929.44 532,704.36 150,368.87 567,965.00 93,852.21 62.92°/x! - 128,769.00 81.52% Supplies 5,700 135.14 5,076.33 5,094.17 194.16 411.67 92.78% Utility Services 136,200 12,729.90 88,300.00 82,967.75 196.41 53,035.84 61.06% Staff Support 11,805 209.08 6,981.45 8,868.19 1,338.08 1,598.73 86.46% City Assistance 500 - - - - 500.00 0.00% Professional Services 33,225 - - 24,650.00 - 8,575.00 74.19% Maintenance Services 102,500 4,148.89 119,611.91 54,606.05 19,398.88 28,495.07 72.20% 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 96,152.45 860,777.61 770,549.21 21,127.53 223,487.26 77.99% TOTAL PUBLIC ENVIRONMENT 1,015,164 96,152.45 860,777.61 770,549.21 21,127.53 223,487.26 77.99 %' PARKS & RECREATION PARKS DEPARTMENT Personnel Services 470,301 53,691.59 373,442.95 347,110.56 - 123,190.44 73.81% Supplies 41,905 1,129.08 21,957.09 30,101.15 1,511.45 10,292.40 75.44% Utility Services 143,800 12,727.65 94,501.95 125,700.70 549.24 17,550.06 87.80% Operations Support 250 - - 876.00 - (626.00) 350.40% Staff Support 8,473 615.03 5,426.16 7,130.69 503.51 838.80 90.10% Professional Services 72,000 4,356.50 18,800.21 24,662.30 3,691.50 43,646.20 39.38% Maintenance Services 20,000 163.04 7,615.05 16,893.10 870.80 2,236.10 88.82% Rental /Leasing 39,600 3,019.16 28,942.57 31,007.49 6,038.32 2,554.19 93.55% Operating Equipment 2,000 - 1,043.45 1,648.92 693.58 (342.50) 117.13% Capital Outlay 60,000 - - 54,134.82 5,660.23 204.95 99.66% TOTAL PARKS DEPARTMENT 858,329 75,702.05 551,729.43 639,26513 19,518.63 199,544:64 7615% SWIM POOL Supplies 20,700 2,791.55 10,152.19 14,045.95 4,693.38 1,960.67 90.53% Utility Services 29,000 2,083.68 12,600.60 11,870.03 359.76 16,770.21 42.17% Maintenance Services 203,378 120,177.45 61,567.91 124,452.89 3,803.78 75,121.33 63.06% TOTAL SWIM POOL 253,078! 125,052.68s 84,320.70 150,368.87 8,856.92 93,852.21 62.92°/x! CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 58,642 5,746.27 42,327.59 45,048.49 - 13,593.51 76.82% Supplies 15,400 815.99 9,984.87 9,901.16 1,761.96 3,736.88 75.73% Utility Services 51,400 4,883.53 32,863.85 35,097.09 - 16,302.91 68.28% Operations Support 22,411 250.00 9,994.39 14,799.00 - 7,612.00 66.03% Staff Support 2,448 144.00 1,878.47 1,300.16 162.00 985.84 59.73% Professional Services 500 - 618.45 - - 500.00 0.00% Operating Equipment 5,000 - - 1,098.70 4,500.14 (598.84) 111.98% TOTAL EVENT FACILITIES 155,801 11,839.79' 97,667.62 107,244.60 6,424.10' 42,13230 72.96% SENIOR CITIZEN CENTER Supplies 7,650 618.32 5,046.22 5,087.08 470.29 2,092.63 72.65% 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 156.42 15,120.38 8,067.90 51.90 11,880.20 40.60% Professional Services 8,000 8,441.50 7,263.49 11,419.00 539.76 (3,958.76) 149.48% Maintenance Services 5,000 - 7,548.20 336.04 125.50 4,538.46 9.23% TOTAL SENIOR CITIZEN CENTER 46,390 9,216.24< 35,392.29 25,718.72 1,187.45? 19,483.83 58.00% TOTAL PARKS '& RECREATION 1,313,598 221,810.76 769,110.04 922,597.92 35,987.10! 355,012,98 72.97 %' CULTURAL LIBRARY Personnel Services 672,828 77,202.62 519,057.44 511,469.59 - 161,358.41 76.02% Supplies 13,500 782.80 8,737.16 10,817.93 35.55 2,646.52 80.40% Utility Services 56,500 4,881.47 33,999.83 33,086.28 - 23,413.72 58.56% Operations Support 3,000 115.99 633.84 632.11 860.00 1,507.89 49.74% Staff Support 6,345 21.00 2,736.76 2,271.34 - 4,073.66 35.80% Professional Services 2,300 - 2,190.00 2,175.00 - 125.00 94.57% Operating Equipment 88,000 5,967.81 67,996.88 74,006.36 6,784.57 7,209.07 91.81% TOTAL LIBRARY 842,473 88,971.69' 635,351;91 634,458.61 7,680.12 200,334.27 76.22% TOTAL CULTURAL 842,473 88,971.69 635,351.91 634,458.61 7,680A2 200,334.27 7622% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH 443,792 48,343.07 330,943.15 339,686.42 - 104,105.58 76.54% Supplies 3,500 124.31 1,686.59 949.46 ANIMAL SERVICES 2,443.72 30.18% City Support Services 581,743 45,527.10 307,115.89 362,152.33 6,213.55 213,377.12 63.32% Utility Services 253,722 Personnel Services 306,397 33,629.34 51.51 213,564.54 57.11% 231,101.11 - 1,233.39 - 74,062.50 - 75.83% Supplies 34,783 2,187.75 1,662.57 23,470.91 23,312.82 16,436.26 13,806.11 2,704.87 Maintenance Services 15,641.87 1,206.90 55.03% Utility Services 46,840 2,233.30 61.24% 15,805.93 291,571 24,608.89 267,007.38 359.57 46,171.20 21,871.54 67.19% 53.31% Operations Support 1,000 1,074,64810 - 678.00 544,207.20 516.39 92.85 390.76 60.92% Staff Support 11,390 - 4,572.90 2,447.70 1,208.66 7,733.64 32.10% City Assistance 17,550 1,386.01 6,497.70 8,912.62 1,077.04 7,560.34 56.92% Professional Services 26,500 1,772.50 20,341.78 15,672.30 1,550.00 9,277.70 64.99% Maintenance Services 23,200 180.00 3,282.40 6,609.80 1,005.62 15,584.58 32.83% Operating Equipment 11,500 1,082.43 2,659.44 1,491.91 - 10,008.09 12.97% Capital Outlay 24,100 - - - - 24,100.00 0.00% TOTAL ANIMAL SERVICES 503,260 42,471.33!' 290,873.60 307,796:98 9,232.00 186,231.02 6100 %' TOTAL HEALTH 503,260 42,471.33 290,873.60 307,796`98 9,232.00 186,231.02 63.00% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 443,792 48,343.07 330,943.15 339,686.42 - 104,105.58 76.54% Supplies 3,500 124.31 1,686.59 949.46 106.82 2,443.72 30.18% City Support Services 581,743 45,527.10 307,115.89 362,152.33 6,213.55 213,377.12 63.32% Utility Services 253,722 15,520.45 138,605.49 144,848.26 51.51 108,822.23 57.11% Operations Support - - - 50.00 - (50.00) 0.00% Staff Support 37,400 1,662.57 21,247.72 23,312.82 281.07 13,806.11 63.09% Maintenance Services 15,600 1,206.90 8,042.48 8,604.16 949.43 6,046.41 61.24% Operating Equipment 291,571 2,428.79 267,007.38 149,743.77 46,171.20 95,656.03 67.19% TOTAL INFORMATION TECHNOLOGY 1;,627,328 114,81119 1,074,64810 1,029,347.22 53,773.58, 544,207.20 66.56% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 310,863 19,708.59 234,920.63 213,969.52 - 96,893.48 68.83% Supplies 1,000 - 957.47 485.41 - 514.59 48.54% Human Services 67,000 36,859.93 31,565.06 79,883.54 4,707.17 (17,590.71) 126.25% Operations Support 10,500 - 7,188.04 3,150.17 575.00 6,774.83 35.48% Staff Support 15,120 190.00 10,529.21 13,171.75 240.00 1,708.25 88.70% City Assistance 10,000 538.00 4,356.21 6,808.75 398.00 2,793.25 72.07% Professional Services 9,200 1,489.50 1,250.00 7,447.00 - 1,753.00 80.95% Operating Equipment - - - - - - 0.00% TOTAL HUMAN RESOURCES 423,683 58,786.02'' 290,766.62 324,916.14 5,920.17 92,846.69 78.09% FINANCE Personnel Services 516,715 61,914.69 355,881.39 408,055.15 - 108,659.85 78.97% Supplies 6,750 916.03 2,151.17 5,221.47 605.10 923.43 86.32% Operations Support 1,940 - 834.00 3,887.60 - (1,947.60) 200.39% Staff Support 9,815 2,658.02 6,108.99 5,643.40 - 4,171.60 57.50% Operating Equipment 900 - - 895.86 - 4.14 99.54% TOTAL FINANCE 536,120' 65,488.74 364,975.55 423,703.48 605.10 111,811.42 79.14 %< PURCHASING & ASSET MGT Personnel Services 261,548 27,404.38 199,805.63 172,063.11 - 89,484.89 65.79% Supplies 1,200 94.19 371.18 542.39 113.96 543.65 54.70% City Support Services 800 - - 788.40 - 11.60 98.55% Utility Services 905 88.86 212.63 345.54 - 559.46 38.18% Operations Support 300 - - 95.97 - 204.03 31.99% Staff Support 6,165 1,035.83 3,354.13 4,064.54 - 2,100.46 65.93% Operating Equipment 2,550 - 1,840.63 1,245.00 374.99 930.01 63.53% TOTAL PURCHASING & ASSET MGT 273,468 28,621264 205,584.20 179,144.95 488.95 93,834.10 65.69°%> CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 313,447 32,122.31 168,709.71 211,536.51 - 101,910.49 67.49% Supplies 174,525 10,429.54 170,285.37 139,968.40 6,472.49 28,084.11 83.91% City Support Services 3,500 - 2,100.00 2,232.24 - 1,267.76 63.78% Utility Services 5,000 429.72 3,403.48 2,933.96 608.98 1,457.06 70.86% Operations Support 400 - - 75.03 - 324.97 18.76% Staff Support 4,500 136.72 2,003.79 4,654.23 43.56 (197.79) 104.40% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 73,750 3,806.28 85,436.27 69,151.64 4,609.23 (10.87) 100.01% 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 - - 40,496.92 - 24,503.08 62.30% TOTAL FLEET SERVICE 648,702 46,924.57 435,127.41 478,085.93 11,734.26 158,881.81 75.51 %' BUILDING MAINTENANCE Personnel Services 140,150 14,451.98 77,457.14 93,133.30 - 47,016.70 66.45% Supplies 1,043 - 230.63 616.84 67.39 358.77 65.60% Utility Services 2,350 282.29 2,369.65 1,803.74 - 546.26 76.75% Staff Support 2,900 58.00 1,737.34 1,617.75 22.72 1,259.53 56.57% Professional Services 6,240 596.02 9,745.00 1,271.02 1,637.60 3,331.38 46.61% Maintenance Services 93,132 5,079.12 80,301.51 83,349.42 2,891.45 6,891.13 92.60% Rental /Leasing 1,400 - - 296.75 - 1,103.25 21.20% Operating Equipment 5,500 - 3,712.50 1,438.43 - 4,061.57 26.15% Capital Outlay 43,510 934.43 - 934.43 34,674.00 7,901.57 81.84% TOTAL BUILDING' MAINTENANCE 296,225! 21,401.84'' 175,553.77 184,461.68 39,293.16' 72,470.16 75.54% TOTAL INTERNAL SERVICE 3,805,526' 336,037.62 2,546,656.25 2,619,659.40 111,815.22 1,074,051.38 71.78% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% 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 2,510,249.79- 17,167,578.49 18,060,424 01 653,007.28 6,797,548.71 7335% REVENUE OVER(UNDER) EXPEND. 306,955' 4,643,521.29 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 9,222,912 49,776.67 8,031,322.26 9,354,640.10 - (131,728.10) 101.43% 000 - 411200 Advalorem Tax - Delinquent 50,000 3,474.78 24,754.55 36,933.99 - 13,066.01 73.87% 000 - 411300 Advalorem Tax - P &I 50,000 7,273.25 39,540.97 41,980.19 - 8,019.81 83.96% 000 - 411500 Sales Tax Revenue -Gen Fund 7,346,170 511,553.08 5,901,620.35 5,652,930.83 - 1,693,239.17 76.95% 000 - 411600 Bingo Tax - - 30.62 - - - 0.00% 000 - 411700 Mixed Beverage Tax 31,000.00 11,491.11 39,917.33 43,553.02 - (12,553.02} 140.49% TOTAL Taxes 16,700,082 ' 583,568.89 14,037,186.08 15,130,038.13 - 1,570,043.87 90.60% Franchises 000 - 421200 Center Point/Entex Energy 87,202 4,418.07 69,261.80 68,056.89 - 19,145.11 78.05% 000 - 421220 City Public Service 649,940 84,226.93 538,146.13 617,668.46 - 32,271.54 95.03% 000 - 421240 Guadalupe Valley Elec Co -op 443,320 45,547.41 246,112.91 375,227.64 - 68,092.36 84.64% 000 - 421250 New Braunfels Utilities 60,697 5,958.65 50,547.51 35,325.01 - 25,371.99 58.20% 000 - 421300 Time Warner -State Franchise 275,000 22,580.27 233,440.75 226,288.64 - 48,711.36 82.29% 000 - 421460 AT &T Franchise Fee 250,000 21,722.19 202,334.49 245,386.95 - 4,613.05 98.15% 000 - 421480 Other Telecom Franchise 100,000 (20,685.06) 53,024.26 29,945.33 - 70,054.67 29.95% 000 - 421500 Solid Waste Franchise Fee 120,000 5,850.68 103,510.49 103,405.42 - 16,594.58 86.17% TOTAL Franchises 1,986,159 169;619.14 - 1,496,378.34 1,701,304.34 - 284,854.66 85.66 %' Permits 000 - 431100 Home Occupation Permit 420 35.00 525.00 420.00 - - 100.00% 000 - 431205 Building Permit - Residential 356,476 67,647.00 309,583.00 506,545.00 - (150,069.00) 142.10% 000 - 431210 Building Permit - Commercial 125,521 - 228,249.00 100,950.00 - 24,571.00 80.42% 000 - 431215 Building Permit - General 350,000 20,370.00 296,811.00 199,514.00 - 150,486.00 57.00% 000 - 431300 Mobile Home Permit 525 - 675.00 350.00 - 175.00 66.67% 000 - 431400 Signs Permit 11,920 1,123.00 6,890.00 7,830.00 - 4,090.00 65.69% 000 - 431500 Food Establishmnt Permit 48,000 - 28,565.00 56,580.00 - (8,580.00) 117.88% 000 - 431600 Garage Sale Permit 10,840 1,353.00 10,517.00 9,125.00 - 1,715.00 84.18% 000 - 431700 Plumbing Permit 100,851 12,540.00 82,030.55 105,601.40 - (4,750.40) 104.71% 000 - 431750 Electrical Permit 50,000 7,640.00 43,704.50 54,100.00 - (4,100.00) 108.20% 000 - 431800 Mechanical Permit 50,000 7,960.00 43,400.00 56,520.00 - (6,520.00) 113.04% 000 - 431900 Solicitor /Peddler Permit 1,000 40.00 1,160.00 1,450.00 - (450.00) 145.00% 000 - 431950 Animal /Pet Permit 2,000 115.00 1,515.00 1,295.00 - 705.00 64.75% 000 - 432000 Cert. of Occupancy Prmt 5,250 400.00 5,400.00 6,400.00 - (1,150.00) 121.90% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 45,000 1,990.00 33,170.00 31,561.00 - 13,439.00 70.14% 000 - 432300 Grading /Clearing Permit 3,000 350.00 3,832.52 4,184.80 - (1,184.80) 139.49% 000 - 435000 Fire Permit 15,000 1,360.00 21,506.00 17,198.00 - (2,198.00) 114.65% TOTAL Permits 1,175,803 122,923.00 1,117,533.57= 1,159,624.20 - 116,178.80 98.62% Licenses 000 - 441000 Alcohol Beverage License 7,000 1,280.00 6,502.50 5,695.00 - 1,305.00 81.36% 000 - 441300 Mobile Home License 160 - 160.00 160.00 - - 100.00% 000 - 442000 Contractors License 79,569 5,675.00 63,100.00 60,230.00 - 19,339.00 75.70% 000 - 444000 Pet License 4,500 390.00 3,105.00 2,995.00 - 1,505.00 66.56% TOTAL Licenses 91,229 - 7;345.00 72,867.50 69,080.00 - 22,149.00 75.72% Fees 000 - 451000 Municipal Court Fines 1,300,000 96,673.50 1,068,085.37 915,322.20 - 384,677.80 70.41% 000 - 451100 Arrest Fee 56,534 3,625.12 43,372.88 37,818.22 - 18,715.78 66.89% 000 - 451110 Expunction Fee 120 - - 60.00 - 60.00 50.00% 000 - 451200 Warrant Fees 150,000 12,640.30 117,384.41 106,155.56 - 43,844.44 70.77% 000 - 451210 Court - Claims & Judgements - - - 219.00 - (219.00) 0.00% 000 - 451320 Civil Justice Fee -Court 34 - 18.40 - - 34.00 0.00% 000 - 451321 Civil Justice Fee -State 288 - 165.94 - - 288.00 0.00% 000 - 451340 Judicial Fee - City 7,567 480.69 5,804.25 5,045.50 - 2,521.50 66.68% 000 - 451400 Traffic Fine Costs TTL 28,060 1,790.79 21,554.88 19,194.40 - 8,865.60 68.40% 000 - 451500 Teen Court Admin Fee 200 - 40.00 - - 200.00 0.00% 000 - 451510 Juvenile Case Mgmt Fee 63,062 4,005.70 48,383.66 42,061.19 - 21,000.81 66.70% 000 - 451520 Truancy Fee 4,586 696.94 4,535.14 7,355.11 (2,769.11) 160.38% 000 - 451600 Technology Fund Fee 50,872 3,293.60 39,007.55 32,430.79 - 18,441.21 63.75% 000 - 451700 Security Fee 38,160 2,470.20 29,255.62 25,487.11 - 12,672.89 66.79% 000 - 451800 Time Payment Fee - City 8,122 484.25 5,675.59 5,052.12 - 3,069.88 62.20% 000 - 451850 State Fines 10% Service Fee 90,736 14,090.12 68,504.06 60,449.08 - 30,286.92 66.62% 000 - 451900 DPS Payment - Local 12,053 893.33 9,144.03 7,942.32 - 4,110.68 65.89% 000 - 452000 Child Safety Fee 23,570 464.62 15,870.45 22,072.54 - 1,497.46 93.65% 000 - 452050 Indigent Defense Fee 8,852 - 5,099.02 - - 8,852.00 0.00% 000 - 452100 Platting Fees 47,500 13,500.00 52,750.00 56,000.00 - (8,500.00) 117.89% 000 - 452200 Site Plan Fee 30,000 9,500.00 23,500.00 23,500.00 - 6,500.00 78.33% 000 - 452300 Plan Check Fee 400,000 43,173.50 415,618.50 402,494.00 - (2,494.00) 100.62% 000 - 452310 Miscellaneous Review Fee 1,200 - 3,000.00 300.00 - 900.00 25.00% 000 - 452320 Tree Mitigation Admin Fee 10,000 615.00 40,192.50 34,162.50 - (24,162.50) 341.63% 000 - 452400 BOA/Zoning Fees 5,000 1,000.00 4,000.00 5,000.00 - - 100.00% 000 - 452500 Food Handler Class 20,000 (20.00) 14,930.00 8,820.00 - 11,180.00 44.10% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452520 Fire Training Classes 500 - - - - 500.00 0.00% 000 - 452600 Specific Use /Zone Chng Fee 25,800 4,150.00 13,450.00 4,150.00 - 21,650.00 16.09% 000 - 452710 Zoning Ltr & Dev Rights 1,050 150.00 450.00 1,500.00 - (450.00) 142.86% 000 - 453100 Reinspection Fees 26,900 4,325.00 28,470.98 31,961.00 - (5,061.00) 118.81% 000 - 453110 Swim Pool Inspection Fee 1,800 - 2,275.00 2,530.00 - (730.00) 140.56% 000 - 453200 Lot Abatement 7,000 - 6,281.42 1,210.00 - 5,790.00 17.29% 000 - 453211 Admin Fee - Inspections 6,600 1,200.00 7,792.65 6,400.00 - 200.00 96.97% 000 - 453310 Misc Inspection Fee 3,750 - 3,050.00 150.00 - 3,600.00 4.00% 000 - 453710 Foster Care 900 150.00 800.00 1,050.00 - (150.00) 116.67% 000 - 454200 Pool Gate Admission Fee 23,200 10,559.90 19,414.05 18,856.65 - 4,343.35 81.28% 000 - 454300 Seasonal Pool Pass Fee 4,900 666.00 5,933.15 5,932.10 - (1,032.10) 121.06% 000 - 456110 Senior Center Memberships 2,000 1,060.00 1,944.32 12,007.60 - (10,007.60) 600.38% 000 - 456120 Senior Center Meal Fee 16,000 - 8,138.00 5,905.61 - 10,094.39 36.91% 000 - 456500 Haz Mat Fees 12,000 - 810.35 - - 12,000.00 0.00% 000 - 456600 Fire Re- inspection Fee 750 150.00 800.00 1,000.00 - (250.00) 133.33% 000 - 458100 Sale of Merchandise - - 210.00 - - - 0.00% 000 - 458110 Sale of Merchandise- GovDeal 5,000 219.74 16,239.00 4,657.71 - 342.29 93.15% 000 - 458300 Sale of Property /Auction 2,000 - 16.82 1,968.75 - 31.25 98.44% 000 - 458400 Civic Center Rental Fees 142,000 12,737.00 144,051.25 149,500.50 - (7,500.50) 105.28% 000 - 458401 Capital Recovery Fee -Civic Cntr 5,500 800.00 6,890.00 10,005.00 - (4,505.00) 181.91% 000 - 458450 North Center Rental Fees 21,000 1,500.00 19,972.00 17,915.75 - 3,084.25 85.31% 000 - 458460 Senior Center Rental 7,000 2,500.00 7,589.00 22,352.00 - (15,352.00) 319.31% 000 - 458500 Community Center Rental Fees 26,000 1,175.00 18,569.07 23,862.53 - 2,137.47 91.78% 000 - 458550 Pavilion Rental Fees 17,500 1,490.00 14,607.50 14,035.00 - 3,465.00 80.20% 000 - 458560 Chamber of Comm rent 7,800 1,950.00 5,850.00 7,800.00 - - 100.00% 000 - 458570 Non - Resident SYSA League 8,000 - - - - 8,000.00 0.00% 000 - 458650 NonResident User Fee -BVYA 9,500 1,172.00 9,140.00 3,912.00 - 5,588.00 41.18% 000 - 458660 BVYA Utility Reimbursement 12,500 - 8,587.32 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,700.00 12,180.00 - 1,820.00 87.00% 000 - 458680 Tournament Fees - Soccer 500 - - - - 500.00 0.00% 000 - 458700 Vehicle Impoundment 8,000 - 7,680.00 7,330.00 - 670.00 91.63% 000 - 459200 NSF Check Fee 500 - 195.00 50.00 - 450.00 10.00% 000 - 459300 Notary Fee 300 36.00 222.00 168.00 - 132.00 56.00% 000 - 459400 Maps, Copies, UDC, & Misc F 100 - 99.70 75.00 - 25.00 75.00% 000 - 459600 Animal Adoption Fee 16,000 920.00 10,261.00 9,128.01 - 6,871.99 57.05% 000 - 459700 Pet Impoundment Fee 14,000 710.00 11,731.01 8,397.00 - 5,603.00 59.98% 000 - 459800 Police Reports Fee 6,000 364.00 4,453.40 4,636.90 - 1,363.10 77.28% TOTAL Fees 2,814,366 257;362.30 2,424,566.24? 2,212,669.25 - 601,696.75 78.62 %' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 31,000 2,616.38 26,314.23 25,396.10 - 5,603.90 81.92% TOTAL Fines 31,000 2,616.38 26,31423 25,396.10 - 5,60190 81.92% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,072 - 7,025.92 7,025.92 - 14,046.08 33.34% 000 - 473200 City of Seguin - Fire Contract 30,000 2,435.90 24,359.00 24,359.00 - 5,641.00 81.20% 000 - 473300 Guad Co - Library 208,000 35,325.66 190,981.01 194,291.13 - 13,708.87 93.41% 000 - 473400 Randolph AFB - Animal Cntrl 1,500 - 1,100.00 500.00 - 1,000.00 33.33% 000 - 474200 Library Services - Cibolo 25,000 - - 30,000.00 - (5,000.00) 120.00% 000 - 474210 Library Services -Selma 28,220 - 28,220.00 30,544.00 - (2,324.00) 108.24% 000 - 474400 Dispatch Service - Cibolo 160,000 40,000.00 66,652.50 120,000.00 - 40,000.00 75.00% 000 - 474600 School Crossing Guard - Bexar 40,000 3,372.77 30,661.68 31,959.28 - 8,040.72 79.90% 000 - 474610 School Cross Guard - Guadalupe 38,000 3,446.41 31,007.39 31,034.94 - 6,965.06 81.67% 000 - 474620 School Crossing Guard -Coma) 1,500 - 1,456.55 1,543.66 - (43.66) 102.91% 000 - 474700 School Officer Funding 155,100 - 117,600.00 165,000.00 - (9,900.00) 106.38% 000 - 474750 Crime Victim Liaison Agreement 12,500 - - - - 12,500.00 0.00% TOTAL Inter - Jurisdictional 720,892 84,580.74 499,06405` 636,257.93 - 84,634.07 88.26 %' Fund Transfers 000 - 480000 Indirect Costs - EMS 136,087 11,340.58 114,198.30 113,405.80 - 22,681.20 83.33% 000 - 480100 Indirect Costs - Hotel /Motel 66,405 5,533.75 121,154.20 55,337.50 - 11,067.50 83.33% 000 - 482150 Transfer From Court Security 27,249 - - - - 27,249.00 0.00% 000 - 485000 Interfund Charge- Drainage 57,130 4,760.83 43,166.70 47,608.30 - 9,521.70 83.33% 000 - 486000 Interfund Chrges -Admin W &S 1,152,350 96,029.17 960,291.70 960,291.70 - 192,058.30 83.33% 000 - 487000 Interfund Charges -Fleet 180,237 15,019.75 108,619.90 150,197.50 - 30,039.50 83.33% 000 - 488000 Interfund Charges -413 100,296 8,358.00 113,537.50 83,580.00 - 16,716.00 83.33% 000 - 489000 Transfer In 116,000 - - - - 116,000.00 0.00% TOTAL Fund Transfers 1,835,754 141;042.08 1,460,968.30; 1,410,420:80 - 425,333.20 76.83 %? CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 550 43.45 405.58 485.46 - 64.54 88.27% 000 - 491200 Investment Income 26,000 3,679.89 22,340.65 24,214.40 - 1,785.60 93.13% 000 - 491800 Gain /Loss - - (17,122.84) (4,400.01) - 4,400.01 0.00% 000 - 491900 Unrealized Gain /Loss (20,000) (1,954.00) 5,679.90 (1,456.15) - (18,543.85) 0.00% 000 - 492100 Proceeds -Sale of Land - - - 10,000.00 - (10,000.00) 0.00% 000 - 493120 Donations - Public Library 5,000 168.45 7,258.90 1,803.20 - 3,196.80 36.06% 000 - 493400 Donation - Animal Control 1,000 - 1,162.97 412.50 - 587.50 41.25% 000 - 493401 Donations -A/C Microchip 1,400 105.00 1,120.00 1,010.00 - 390.00 72.14% 000 - 493402 Donations - Spay &Neuter 10,000 862.50 8,813.95 8,644.00 - 1,356.00 86.44% 000 - 493403 Donations - Animal Adoption Trailer 9,000 679.00 2,000.00 9,824.52 - (824.52) 109.16% 000 - 493460 Donations -Parks - - - 500.00 - (500.00) 0.00% 000 - 493465 Donations - Senior Center 12,000 1,283.92 30,032.07 5,802.80 - 6,197.20 48.36% 000 - 493502 Donations -PD - - 2,400.00 500.00 - (500.00) 0.00% 000 - 493618 Donations - Veteran's Memorial - - - 2,250.00 - (2,250.00) 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed - 3,931.29 3,878.26 - (3,878.26) 0.00% 000 - 494482 Grants - Police, Fire, Gen Fund - - 5,499.84 - - - 0.00% 000 - 495060 Grant - Wellmed /Senior Center 3,500 - - - - 3,500.00 0.00% 000 - 495100 Mobile Stage Rental Fees 2,000 - 1,550.00 - - 2,000.00 0.00% 000 - 497000 Misc Income -Gen Fund 20,000 4,113.57 28,157.10 (11,106.21) (10.00) 31,116.21 - 55.58% 000 - 497005 Schertz Magazine Advertising 220,000 24,605.00 189,950.00 226,070.00 - (6,070.00) 102.76% 000 - 497100 Misc Income - Police 15,000 261.00 (30.60) 5,760.40 - 9,239.60 38.40% 000 - 497200 Misc Income - Library 4,000 450.50 3,818.14 4,887.20 - (887.20) 122.18% 000 - 497210 Misc Income - Library Copier 14,000 1,382.65 11,753.40 15,837.82 - (1,837.82) 113.13% 000 - 497300 Misc Income - Animal Control - - - 10.00 - (10.00) 0.00% 000 - 497400 Misc Income - Streets Dept. 18,000 1,975.00 7,343.70 16,707.85 - 1,292.15 92.82% 000 - 497500 Misc Income -TML Insurance 20,000 - 4,842.50 - - 20,000.00 0.00% 000 - 497550 Misc Income -TML Reimbursemt 20,000 - 20,341.42 3,503.99 - 16,496.01 17.52% 000 - 497600 Misc Income - Vending Mach. 2,000 161.40 1,912.01 1,885.07 - 114.93 94.25% 000 - 498000 Reimbursmnt -Gen Fund 60,000 - 11,376.80 17,085.27 - 42,914.73 28.48% 000 - 498100 Reimbursmnt Fire - Training 1,000 - 4,398.97 - - 1,000.00 0.00% 000 - 498105 Reimburmnt Police - DEA 6,200 1,045.11 4,655.49 8,044.18 - (1,844.18) 129.74% 000 - 498107 Reimburmnt Police - Event 7,000 - 3,500.00 7,000.00 - - 100.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 5,000 - 4,131.62 - - 5,000.00 0.00% TOTAL Miscellaneous 462,650 38,862.44 371,222.86 359,154.55 (10.00); 103,505.45 77.63% TOTAL'REVENUES 25,817,935 1,407,919.97 ` 21,506,101.17 22,703,945.30 (10.00) 3,113,999.70 87.94 %' GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 859,651.50 Cash in Investments LOGIC Investment - General Fund 7,843,205.76 LOGIC Investment -Equip Replacement 73,710.76 LOGIC Investment -Veh Replacement 306,920.11 LOGIC Investment -Air Condi Replacment 196,236.08 CAPITAL ONE Investment - General Fund 1,354,583.05 Total Cash in Bank & Investments $10,780,889.10 ` DEC JAN OCT NOV 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 82013 -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 62010-111 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 CITY PUBLIC SERVICE $250,000 00,000 $2 $1 $1 50,000 00,000 50,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014 -15 215,257 172,814 172,628 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 95,887 j CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 83.33% 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 18,802.00 - (52.00) 0.00% Miscellaneous 3,925.00 2.19 7,034.39 1,621.49 - 2,303.51 41.31% TOTAL REVENUES 153,800.00 2.19 172,483.11 34,349.03 - 119,450.97 15.22% 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 775.40 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 64.54 29,054.64 14,820.55 26.79 20,152.66 42.42% Jazzfest 20,000.00 - 14,504.83 20,020.00 - (20.00) 100.10% Hal Baldwin Scholarship 18,750.00 - 8,730.20 12,309.68 16.00 6,424.32 65.74% Other Events 14,000.00 177.25 52,877.26 5,460.35 300.00 8,239.65 41.15% TOTAL CULTURAL` 142,950.00 1,017.19 150425.80> 90,023.84 342.79 52,583.37 63.22% TOTAL' EXPENDITURES 153,800.00 1,017.19 150,425.80? 90,023.84 342.79 63,433.37 58.76% REVENUE OVER(UNDER) EXPEND - (55,674:81) SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 14,308.57 Cash in Investments Texas Class- Special Events 16,800.37 Total Cash in Bank & Investments $ 31,108.94 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 119,572.00 9,924.94 70,794.59 87,466.56 - 32,105.44 73.15% Fund Transfers 109,428.00 - - - - 109,428.00 0.00% Miscellaneous - - - 2.00 - (2.00) 0.00% TOTALREVENUES 229,000.00 9,924.94 70;794.59 87,468.56 - 141,531.44 38.20% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 229,000.00 3,170.49 51,893.44 71,451.26 2,762.70 154,786.04 32.41% TOTAL GENERAL GOVERNMENT 229,000.00 3,170.49 51,893.44 71,451 €26 2,762.70 154,786.04 32.41% MISC & PROJECTS Projects - - - 1,835.38 620.98 (2,456.36) 0.00% TOTAL MISC & PROJECTS - - - 1,835 38 620.98 (2,456.36) 0.00% TOTAL EXPENDITURES 229,000.00 3,170.49 51,893.44 73,286.64 3,38168 152,329.68 33.48% REVENUE OVER(UNDER) EXPEND - 14,181.92 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner - PEG Fee 78,772 6,524.94 39,361.58 44,820.12 - 33,951.88 56.90% 000 - 421465 AT &T PEG Fee 40,800 3,400.00 31,433.01 42,646.44 - (1,846.44) 104.53% TOTAL Franchises 119,572 9,924.94 70,794.59 87,466.56 32,105.44 73.15 %' Fund Transfers 000 - 481000 Transfer In - Reserves 109,428 - - - - 109,428.00 0.00% TOTAL Fund Transfers 109,428' - - - - 109,428.00 0.00 %` Miscellaneous 000 - 497000 Misc Income - - - 2.00 - (2.00} 0.00% TOTAL Miscellaneous - - - 2.00 - (2.00) 0.00% TOTAL REVENUES 229,000 9,924.94 70,794.59 87,468.56 - 141,531.44 38.20 %'s PEG FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Cash Balance $ 418,340.94 Total Cash in Bank & Investments $ 418,340.94 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 211,813 5,000.00 166,217.82 179,549.35 - 32,263.65 84.77% Permits 60,000.00 50.00 56,903.86 66,063.85 - (6,063.85) 110.11% Fees 17,169,500 1,489,237.09 13,585,812.97 13,964,342.41 - 3,205,157.59 8133% Fund Transfers 276,425 11,426.08 103,596.70 114,260.80 - 162,164.20 41.34% Miscellaneous 142,940 2,971.01 229,499.68 101,789.32 - 41,150.68 71.21% TOTAL REVENUES 17,860,678 1,508,684.18 14,142,031.03 14,426,005.73 - '' 3,434,672.27 80.77 %` EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 450,477 48,644.57 323,175.41 365,527.67 - 84,949.33 81.14% Supplies 4,600 441.92 3,596.50 2,589.50 471.81 1,538.69 66.55% 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 - 102.84 - 417.16 19.78% Operations Support 123,000 14,381.01 96,725.52 105,937.57 - 17,062.43 86.13% Staff Support 7,300 174.99 2,603.91 2,006.86 208.30 5,084.84 30.34% Professional Services 77,252 9,960.69 21,791.18 65,577.63 - 11,674.37 84.89% Maintenance Services 13,440 420.00 6,540.00 9,675.00 780.00 2,985.00 77.79% Operating Equipment 1,550 - - - - 1,550.00 0.00% TOTAL BUSINESS I OFFICE 702,420 74,074.60 454;549.47 '! 552,248.07 1,460.11 148,711.82 78.83 %' W & S ADMINISTRATION Personnel Services 1,255,365 122,219.27 902,604.69 943,705.53 111.00 311,548.47 75.18% Supplies 193,150 553.13 117,299.13 125,064.62 14,409.29 53,676.09 72.21% Human Services 1,000 - 389.95 476.00 - 524.00 47.60% City Support Services 103,403 697.22 61,051.99 36,399.78 - 67,003.22 35.20% Utility Services 3,454,440 369,883.60 2,526,578.68 2,486,020.89 1,726.24 966,692.87 72.02% Operations Support 9,250 4,573.92 2,214.69 7,524.61 31.85 1,693.54 81.69% Staff Support 31,150 2,193.10 21,566.54 17,572.83 1,783.29 11,793.88 62.14% City Assistance 1,900 96.00 708.25 1,206.00 - 694.00 6147% Professional Services 259,113 14,593.50 207,846.08 148,787.03 36,012.00 74,313.97 71.32% Fund Charges /Transfers 3,492,504 194,074.62 2,471,867.19 2,406,527.65 - 1,085,976.35 68.91% Maintenance Services 6,543,586 503,795.32 4,942,189.78 5,188,289.36 161,434.82 1,193,861.82 81.76% Other Costs 35,000 3,780.00 27,650.20 30,930.20 100.00 3,969.80 88.66% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 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 83.33% OF BUDGET Debt Service 1,534,512 187,677.59 400,847.15 399,437.30 - 1,135,074.70 26.03% 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 934.44 431,526.00 70,801.64 32,904.13 20,794.23 83.30% TOTAL PUBLIC WORKS 17,066,143 1,405,071.71 12,132,632.17 11,882,164.57 248,912.60 4,935,065.83 71.08% MISC & PROJECTS PROJECTS Fund Charges /Transfers - - - 945,227.88 - (945,227.88) 0.00% TOTAL PROJECTS - - - 945,227.88 - (945,227.88) 0.00% TOTAL MISC &'PROJECTS - - - 945,227.88 - (945,227.88) 0.00 %? TOTAL EXPENDITURES 17,768,563 1,479,146.31 12,587,181.64 13,379,640.52 250,372.71 4,1!38,549.77 76.71% - REVENUE OVER(UNDER)EXPENSES " 92,115 1,046,365.21 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 211,813 5,000.00 166,217.82 179,549.35 - 32,263.65 84.77% TOTAL Franchises 211,813 5,000.00 166,217 >82 179,549.35 - 32,263.65 8477 %' Permits 000 - 432400 Development Permit 60,000 50.00 56,903.86 66,063.85 - (6,063.85) 110.11% TOTAL Permits 60,000 50.00 56,903.86 66,063.85 - (6,063.85) 110.11% Fees 000 - 455200 Garbage Collection Fee 4,000,000 341,080.28 3,275,951.38 3,404,162.04 - 595,837.96 85.10% 000 - 455600 Fire Line Fees 25,000 - 23,985.00 25,630.00 - (630.00) 102.52% 000 - 455700 Recycle Fee Revenue 270,000 22,753.66 219,109.45 226,454.43 - 43,545.57 83.87% 000 - 455800 W &S Line Constructn Reimbursemnt 25,000 3,014.00 19,534.52 22,010.00 - 2,990.00 88.04% 000 - 457100 Sale of Water 8,100,000 711,516.10 6,250,167.63 6,088,495.52 - 2,011,504.48 75.17% 000 - 457110 Edwards Water Lease 127,000 2,128.25 310,930.58 139,645.25 - (12,645.25) 109.96% 000 - 457120 Water Transfer Charge -Selma 42,000 - 28,328.27 21,600.91 - 20,399.09 51.43% 000 - 457130 Water Transfer Charge -U. C. 8,000 - 12,351.39 4,911.69 - 3,088.31 61.40% 000 - 457140 Water Transfer Charge- Converse 30,000 - 22,971.15 20,164.70 - 9,835.30 67.22% 000 - 457200 Sale of Meters 90,000 9,541.00 45,187.46 72,419.02 - 17,580.98 80.47% 000 - 457400 Sewer Charges 4,250,000 379,450.43 3,205,695.15 3,757,513.82 - 492,486.18 88.41% 000 - 457500 Water Penalties 200,000 19,553.37 167,040.99 177,785.03 - 22,214.97 88.89% 000 - 458110 Sale of Merchandise - Gov Deals - - 180.00 - - - 0.00% 000 - 458300 Sale of Property /Auction - - - 1,575.00 - (1,575.00) 0.00% 000 - 458400 Building rental Fee - - 2,000.00 - - - 0.00% 000 - 459200 NSF Check Fee -Water &Sewer 2,500 200.00 2,380.00 1,975.00 - 525.00 79.00% TOTAL Fees 17,169,500 1,489,237.09 13,585,812.97 13,964,342.41 = 3,205,157.59 81.33% Fund Transfers 000 - 486204 Interfnd Chrg- Drainage Bill 137,113 11,426.08 103,59670 114,260.80 - 22,85220 83.33% 000 - 486411 Transfer In- Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 276,425 11,426.08 103,596.70 114,260.80 = 162,16420 41.34 %' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 490000 Misc Charges 700 25.00 391.50 496.00 - 204.00 70.86% 000 - 491000 Interest Earned 1,500 36.86 1,190.72 927.38 - 572.62 61.83% 000 - 491200 Investment Income 10,000 377.75 3,921.60 4,371.53 - 5,628.47 43.72% 000 - 496050 SSLG - SAWS Reservation - - 134,500.00 - - - 0.00% 000 - 497000 Misc Income -W &S 20,000 2,531.40 9,782.90 8,517.02 - 11,482.98 42.59% 000 - 498110 Reimbursement -SSLGC 110,740 - 79,637.00 87,477.39 - 23,262.61 78.99% 000 - 498300 Reimbursement -City Property - - 75.96 - - - 0.00% TOTAL Miscellaneous - 142,940 2,971.01 229,499.68 101,789.32 _ 41,150.68 71.21% TOTAL REVENUES 17,860,678 1,508,684.18 14,142,031.03 14,426,005.73 - 3,434,672.27 80.77 %`' WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ (46,65131) 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,771,327.67 295,669.26 177, 770.22 256,805.29 810,683.17 1,068,630.27 Total Cash in Bank & Investments $4,334,234.57 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNLY 31 st, 2015 2D14'2O15 2034EK8S CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY F000 8.418.343 480,09818 4,528.181.21 4,598,984.64 - 1.817.35838 71.68% Inter-Jurisdictional 1.601.070 362.080.24 1,523/48416 1.617.037.72 - (15.901.72) 101.00% Miscellaneous 169,500 1,480.79 94,025.10 46,582.09 - 122,917.91 27.48% TOTALREVENUES 8,186,919 844,259.19 6,145,700.47 6,262,604.45 - 1,924,314.55 76.50% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3.111.898 342/438.65 2.332,477.01 2.024.033.54 - 487.065A0 84.35% Supplies 386.700 11.039.86 247.731.64 284.92213 08.385�80 33.478.07 81.34% Human Services 1.000 - 343.00 674�50 - 325.50 67.45% City Support Services 35.052 - 17.020.32 14.017.51 - 20.434.49 41.70% Utility Services 135.305 9.307.78 105.471.31 84.280.54 - 51.018.40 02.29% Operations Support 00.027 7.230.31 48.055.80 50.50412 102.00 9.360.88 85.82% Staff Support 85.353 1.94915 00.050.94 05.783.60 8.20280 11.366.54 80.68% City Assistance 11.900 32D0 11.547.30 11.74773 - 15227 98.72% Professional Services 153.301 4.109.41 113.725.37 125.738.52 5.089.69 22.472.78 85.34% FundChangeo/Tmnafom 3.366.084 189.449.56 1.509.851.27 1.800.073.94 - 1.500.010.00 53.66% Maintenance Services 42.971 1.107.68 14.489.05 25.003.79 - 17.96721 58.19% Debt Service 270.820 10.217.93 0.331.91 12.383.35 - 258.436.05 4.57% Rental-Leasing 81.541 5.795.07 - 58.530.21 11.590A4 11.420.05 85.99% Operating Equipment 205.080 1.893.54 81.170.04 151.242.94 12.712.83 101.124.23 01.85% Capital Outlay -_138`382 -_' - -__50},74629 --__1,105.{X} -__86,53Kl71 i 37.47% TOTAL PUBLIC SAFET 8,151,501 585,290.94 4,555,682.96 5,373,148.71 107,188.32 2,671,163.97 67.23% TOTAL EXPENDITURES 8,151,501 585,290.94 4,555,682.96 5,373,148.71 107,188.32 2,671,163.97 67.23% REVENUE OVER(UNDER) EXPENSES 35,418 889,455.74 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNLY 31st, 2015 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 6,249,943 461,890.51 4,420,740.46 4,449,221.27 - 1,800,721.73 71.19% 000 - 456110 Subscription Program Fees 40,000 130.00 23,250.00 26,110.00 - 13,890.00 65.28% 000 - 456120 EMT Class - Fees 104,400 16,388.50 65,656.00 105,414.40 - (1,014.40) 100.97% 000 - 456130 Immunization Fees - - - 420.00 - (420.00) 0.00% 000 - 456140 Billing Fees - Alamo Heights 22,000 1,689.15 15,714.75 17,663.97 - 4,336.03 80.29% 000 - 458110 Sales of Merchandise - GovDeal - - 2,770.00 155.00 - (155.00) 0.00% 000 - 459200 NSF Check Fee - - 50.00 - - - 0.00% TOTAL Fees 6,416;343 480,098.16 4,528,181.21 4,598,984.64 1,817,,358.36 71.68% Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 286,126 23,843.88 262,282.68 262,282.68 - 23,843.32 91.67% 000 - 474300 Cibolo Support 261,370 65,348.25 253,756.80 261,393.00 - (23.00) 100.01% 000 - 475100 Comal Co ESD #6 95,217 23,362.50 75,907.00 92,859.60 - 2,357.40 97.52% 000 - 475200 Live Oak Support 179,608 47,392.50 174,376.80 189,570.00 - (9,962.00) 105.55% 000 - 475300 Universal City Support 247,353 61,843.88 241,548.80 247,375.52 - (22.52) 100.01% 000 - 475400 Selma Support 73,952 18,489.75 73,798.40 73,959.00 - (7.00) 100.01% 000 - 475500 Schertz Support 433,542 116,422.01 420,914.88 465,688.04 - (32,146.04) 107.41% 000 - 475600 Santa Clara Support 9,678 2,419.69 9,396.00 9,678.76 - (0.76) 100.01% 000 - 475800 Marion Support 14,230 3,557.78 11,512.80 14,231.12 - (1.12) 100.01% TOTAL Inter - Jurisdictional 1,601;076 362,680.24 1,523,494.16 1,617,037.72 - (15,961.72) 101.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNLY 31st, 2015 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned - 11.07 44.42 79.22 - (79.22) 0.00% 000 - 491200 Investment Income - 118.68 - 645.64 - (645.64) 0.00% 000 - 493203 Donations -EMS 2,000 - 80.00 710.00 - 1,290.00 35.50% 000 - 493204 Donations - Dilworth Fund 3,500 - - - - 3,500.00 0.00% 000 - 493205 Donations- Golf Tournament 9,000 - 15,525.00 7,380.00 - 1,620.00 82.00% 000 - 497000 Misc Income 145,000 708.41 74,681.56 29,594.00 - 115,406.00 20.41% 000 - 497100 Recovery of Bad Debt 10,000 642.63 3,643.12 8,173.23 - 1,826.77 81.73% 000 - 498300 Reimbursement- City Property - - 51.00 - - - 0.00% TOTAL Miscellaneous 169;500 1,480.79 94,02510 46,582.09 - 122,917.91 27.48 %` TOTAL REVENUES 8,186;919 844,259.19 6,145,700.47 6,262,604.45 - 1,924,314.55 76.50 %< SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JUNLY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 316,945.92 Cash in Investments Texas Class- Tax Note 2015 Ambulances 893,645.64 Total Cash in Bank & Investments $ 1,210,591.56 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 * * * * * * * * ** 2 0 14 - 2 0 1 5 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 456,029 49,764.19 292,431.23 372,392.38 132.52 Permits 3,000 440.00 3,040.00 2,540.00 460.00 84.67% Fees 1,155,500 91,490.93 856,431.54 902,217.15 - 253,282.85 78.08% Miscellaneous 25,700 217.54 955.33 26,510.85 - (810.85) 103.16% TOTAL REVENUES 1,184,200 92,148.47 860,426.87;' 931,268.00 - 252,932.00 78.64% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 456,029 49,764.19 292,431.23 372,392.38 132.52 83,504.10 81.69% Supplies 8,300 636.84 4,529.55 5,161.10 51.48 3,087.42 62.80% Human Services 325 - 61.00 - - 325.00 0.00% City Support Services 27,932 615.15 2,166.61 2,921.79 - 25,010.21 10.46% Utility Services 30,370 1,445.76 19,630.43 14,434.24 297.88 15,637.88 48.51% Operations Support 2,460 - - 64.97 - 2,395.03 2.64% Staff Support 8,116 350.52 4,115.57 3,987.29 57.06 4,071.65 49.83% City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 643.50 2,708.01 5,951.44 937.50 16,611.06 29.31% Fund Charges/Transfers 221,818 18,401.49 163,753.40 184,014.90 - 37,803.10 82.96% Maintenance Services 47,000 - 5,595.37 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 8,550.86 2,073.16 9,256.62 - 131,273.38 6.59% Rental /Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 - 11,303.80 4,091.64 - 1,408.36 74.39% Capital Outlay - 24,322.00 - - - 0.00% TOTAL DRAINAGE 973,420 80 408.31 !' 532,890.13 603,834.27 27 396.44 342,189.29 ? 64 .85 %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 56.85 16,800.00 137,784.59 44,478.30 (47,964.89) 135.72% TOTAL PROJECTS 146,198 56.85 39,040.00 143,514.68 52,478.30 (49,794.98) 134.06% TOTAL EXPENDITURES 1,119,618 80;465.16 571,930.13 747,348.95 79,874.74 292,394.31 73.88% " REVENUE OVER(UNDER) EXPEND' 64,582 1'83,919.05 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000 440.00 3,040.00 2,540.00 - 460.00 84.67% TOTAL Permits '` 3,000 440.00 3,040.00 2,540.00 - 460.00 84.67 %'! Fees 000 - 457500 Drainage Penalties 8,000 1,120.73 7,052.13 8,311.53 - (311.53) 103.89% 000 - 457600 Drainage Fee 1,147,500 90,370.20 849,379.41 893,905.62 - 253,594.38 77.90% TOTAL Fees 1,155,500 91,490.93 856,431.54 902,217.15 - 253,282.85 78.08 %' Miscellaneous 000 - 491000 Interest Earned 100 - 163.73 196.60 - (96.60) 196.60% 000 - 491200 Investment Interest 500 217.54 725.60 1,314.25 - (814.25) 262.85% 000 - 493204 Donations- Drainage Project 25,000 - - 25,000.00 - 100.00% 000 - 497000 Misc Income - Drainage 100 - 60.00 - - 100.00 0.00% 000 - 498300 Reimbursement- City Property - - 6.00 - - - 0.00% TOTAL Miscellaneous 25,700 217.54 955.33 26,510.85 - (810.85) 103.16 %' TOTAL REVENUES 1,1,84,200 92,148.47 860,426.87 931,268.00 252,932.00 78.64 %`i DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking 5,030.74 Cash in Investments Lone Star Investment-Drainage Maint Fund 1,006,563.28 Total Cash in Bank & Investments $ 1,011,594.02 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET I: ajoi,111 l�J�i►� /e1:�'1 Taxes 544,753 91,774.54 341,628.56 438,562.58 - 106,1 90.42 80.51% Miscellaneous 600 77.13 329.24 465.96 - 134.04 77.66% TOTAL REVENUES 545,353 91,851.67 341,957.80 439,028.54 - 1?06,324.46 80.50% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - - - - 2,500.00 0.00% City Support Services 61,500 1,333.30 59,128.00 32,508.88 - 28,991.12 52.86% Operations Support 69,500 154.65 20,780.66 15,265.15 - 54,234.85 21.96% Professional Services 5,825 - 2,800.00 3,000.00 1,875.00 950.00 83.69% Fund Charges/Transfers 126,405 5,533.75 262,876.20 78,837.50 - 47,567.50 62.37% Maintenance Services - - 23,462.00 - - - 0.00% Operating Equipment 37,000 1,890.20 8,665.59 5,818.24 3,712.60 27,469.16 25.76% TOTAL NONDEPARTMENTAL 302,730 8,911.90 377,712.45 135,429.77 5,587.60 161,712.63 46.58% TOTAL EXPENDITURES 302,730 8,911.90 '' 377,712.45 135,429.77 5,587.60 1161,712.63 46.58 %` REVENUE OVER(UNDER) EXPENDITURE 242,623 ` 303,598.77 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 2 0 14 - 2 0 1 5 314-HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411800 Hotel Occupancy Tax 544,753 91,774.54 341,628.56 438,562.58 - 106,190.42 80.51% TOTAL Taxes 544,753 91,774.54 341,628.56 438,562.58 - 106,190.42 80.51% Miscellaneous 000-491000 Interest Earned 100 10.76 92.56 104.44 - (4.44) 104.44% 000-491200 Investment Interest 500 66.37 236.68 361.52 - 138.48 72.30% TOTAL Miscellaneous 600 77.13 329.24 465.96 - 134.04 77.66% TOTAL REVENUES 545,353 91,851.67 341,957.80 439,028.54 - 106,324.46 80.50% HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 267,953.71 Cash in Investments Texas Class - Hotel Tax 499,548.36 Total Cash in Bank & Investments $ 767,502.07 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 - - - - -- - - - -� 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 36,728 28,215 34,157 45,854 53,433 42,181 32,294 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 100,000 - 120,150.00 18,000.00 - 82,000.00 18.00% Miscellaneous - 7.69 1923 87.60 - (87.60) 0.00% TOTAL REVENUES 100,000 7.69 120,169.23 18,087.60 - 81,912.40 18.09% 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,247.40);; CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 k********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 100,000 - 120,150.00 18,000.00 - 82,000.00 18.00% TOTAL Fees 100,000 - 120,150.00 1!8,000.00 - 82,000.00 18.00% Miscellaneous 000 - 491000 Interest Earned - 7.43 17.83 76.12 - (76.12) 0.00% 000 - 491200 Investment Interest - 0.26 1.40 11.48 - (11.48) 0.00% 000 - 497000 Misc Income - - - - - - 0.00% TOTAL Miscellaneous - 7.69 19.23 87.60 - (87.60) 0.00% TOTAL REVENUES 100,000 7.69 120,169.23 18,087,60 - 81,91!2.40 18.09 %I PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $165,543.81 Cash in Investments Texas Class- Park Fund 1,356.07 Total Cash in Bank & Investments $166,899.88 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 36,000 3,485.00 227,757.50 191,487.50 - (155,487.50) 531.91% Fund Transfers 176,939 - - - - 176,939 0.00% Miscellaneous 210 59.22 191.21 308.13 - (98.13) 146.73% TOTAL REVENUES 213,149 3,544.22 227,948.71 191,795.63 - 21,353.37 89.98% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 212,939 - 39,956.30 9,154.00 - 203,785.00 4.30% TOTAL TREE MITIGATION 212,939 39,956.30 9,154.00 203,785.00 4.30 %i TOTAL EXPENDITURES 212,939 - 39,956.30 9,154.00 - 203,785.00 4.30% REVENUE OVER(UNDER)'EXPEND 210 182,641.63 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 k********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 36,000 3,485.00 227,757.50 191,487.50 - (155,487.50) 531.91% TOTAL Fees 36,000 3,485.00 227,757.50 191,487.50 (155,487.50) 531.91 %j Fund Transfers 000 - 481000 Transfer In -Reserves 176,939 - - - - 176,939.00 0.00% TOTAL Fund Transfers 176,939 - - - - 176,939.00 0.00 %` Miscellaneous 000 - 491000 Interest Earned 90 6.48 114.85 124.61 - (34.61) 138.46% 000 - 491200 Investment Interest 120 52.74 7636 183.52 - (63.52) 152.93% TOTAL Miscellaneous 210 59.22 191.21 308.13 - (98.13) 146.73% TOTAL REVENUES 213,149 3,544.22 227,948.71 191,795.63' - 21,353.37 89.98 %< TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $144,313.79 Cash in Investments MBIA Investment-Tree Mitigation 397,532.95 Total Cash in Bank & Investments $541,846.74 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 880,200 134,964.00 673,353.00 982,480.30 - (102,280.30) 111.62% Fund Transfers - - - - - - 0.00% Miscellaneous 5,300 646.11 4,752.73 5,184.66 - 115.34 97.82% TOTAL REVENUES 885,500 135,610.11 678,105.73 987,664.96 - (102,164.96) 111.54% EXPENDITURE SUMMARY GENERAL GOVERNMENT Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 - - - - 109.00 0.00% Professional Services 80,000 - 1,000.00 1,000.00 625.00 78,375.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 450,000 - - - - 450,000.00 0.00% TOTAL NON DEPARTMENTAL 652,109 '' - 78,778.00 4,579.00 625.00 646,905.00 0.80% MISC & PROJECTS Water Projects - - - 85,186.10 186,732.71 (271,918.81) 0.00% TOTAL MISC & PROJECTS - - - 85,186.10 186,732.71 (271,918.81) 0.00% TOTAL EXPENDITURES 652,109 `; - 78,778.00 89,765.10 187,357.71 374,986.19 42.50 %< REVENUE OVER(UNDER) EXPENDITURES 233,391 897,899.86 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 880,200 134,964.00 673,353.00 982,480.30 - (102,280.30) 111.62% TOTAL Fees s 880,200 134,964.00 673,353.00 982,480.30 (102,280.30) 111.62% Miscellaneous 000 - 491000 Interest Earned 300 45.13 328.76 559.75 - (259.75) 186.58% 000 - 491200 Investment Income 5,000 600.98 4,423.97 4,624.91 - 375.09 92.50% TOTAL Miscellaneous 5,300 646.11 4,752.73 5,184.66 - 115.34 97.82% TOTAL REVENUES 885,500 135,610.11 678,10573 987,664.96 - (102,164.96) 111.54 %` CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $1,104,190.42 Cash in Investments Lone Star Investment - Capital Recovery Water 4,497,656.99 Total Cash in Bank & Investments $5,601i847.41 `' CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JULY 31 st, 2015 2O14'3U15 421 -CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL YT-DACTUAL ENCUK48R BALANCE BUDGET REVENUE SUMMARY Fees 000,400 75,456.00 364,493.90 558,751.44 - 41,648.56 03.00% Fund Transfers 559,407 - 77.778.00 - - 559.407.00 0.00% Miscellaneous 600 1,944.51 1000478 1518494 -_ /14,5V84�94 ) 2530.82% TOTA L REVENUES 1,160,497 77,400.51 452,276.68 573,936.38 - 586,560.62 49.46% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3.143 300.30 4.573.70 4.589.88 625.00 (2.071.80) 105.92% TOTAL NON DEPARTMENTAL 142,455 360.30 4,573.70 4,589.80 625.00 137,240.20 3.66% Sewer Projects _1,{18,}42 ______�_ - - _____-_ _1I18/042{}0 {.0}% TOTAL MISC & PROJECTS 1,018,042 - 1,018,042.00 0.00% TOTAL EXPENDITURES 1,160,497 360.30 4,57170 4,589.80 625.00 1,155,282.20 0.45% REVENUE OVER(UNDER) EXPENDITURES 569,346.58 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery- Waste Wtr 500,400 71,856.00 363,827.90 497,551.44 - 2,848.56 99.43% 000 - 455913 Cap Recovery-North Sewer Tr 100,000 3,600.00 666.00 61,200.00 - 38,800.00 61.20% TOTAL Fees 600,400 75,456.00 364,493.90 558,751.44 41,648.56 93.06% Fund Transfers 000 - 481000 Transfer from Reserves 559,497 - - - - 559,497.00 0.00% 000 - 486411 Transfer In -Cap Recovery Water - - 77,778.00 - - - 0.00% TOTAL Fund Transfers 559,497 77,778.00 - 559,497.00 0.00% Miscellaneous 000 - 491000 Interest Earned 100 30.54 194.10 344.81 - (244.81) 344.81% 000 - 491200 Investment Income 500 3,441.97 26,479.45 24,343.95 - (23,843.95) 4868.79% 000 - 491800 Gain /Loss - - (40,015.93) (10,238.49) - 10,238.49 0.00% 000 - 491900 Unrealized Gain/Loss-Cap One - (1,528.00) 23,347.16 734.67 - (734.67) 0.00% TOTAL Miscellaneous 600 1,944.51 10,004.78 15,184.94 - (14,584.94) 2530.82 %' TOTAL REVENUES 1,160,497 77,400.51s 452,276.68 573,936.38 - 586,560.62 49.46 %` CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 727,689.41 Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,953,559.96 Capital One-investment 1,735,332.32. Total Cash in Bank & Investments $4,416,581.69 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,338,513 34,831.61 5,276,889.71 5,397,879.55 - (59,366.55) 101.11% Miscellaneous 368,763 309.95 8,796,420.00 353,382.74 - 15,380.26 95.83% TOTAL REVENUES 5,707,276 35,141.56 14,073,309.71 5,751,262.29 - (43,986.29) 100.77% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 800.00 165,250.00 2,350.00 - 40,000.00 5.55% Debt Service 5,593,807 877,193.39 4,365,184.70 5,319,799.42 273,871.86 135.72 100.00% TOTAL GENERAL GOVERNMENT 5,636,1157 877,993.39 13,712,684.93 5,322,149.42 273,871.86 40,135.72 99.29% TOTAL EXPENDITURES 5,636,157 877,993.39 13,712,684.93 5,322,149.42 273,871.86 40,135.72 99.29 %` " REVENUE OVER(UNDER);EXPEND 71,1119 429,112.87 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411900 Property Tax Revenue 5,338,513 34,831.61 5,276,889.71 5,397,879.55 - (59,366.55) 101.11% TOTAL Taxes 5,338,513 34,831.61 5,276 889.71 5,397,879.55 (59,366.55) 101.11% Miscellaneous 000 - 491000 Interest Earned 75 - 49.94 7.16 - 67.84 9.55% 000 - 491200 Investment Earnings 1,500 309.95 1,301.31 2,306.83 - (806.83) 153.79% 000 - 495015 Contribution from SED 367,188 - 345,068.75 351,068.75 - 16,119.25 95.61% 000 - 498000 Proceeds From Refunding Det - - 8,450,000.00 - - - 0.00% TOTAL Miscellaneous 368,763 309.95 8,796 420.00 353,38274 - 15,380.26 95.83°% TOTAL REVENUES 5,707,276 35,14'1.56 14,073,309.71 5,751,26229 - _ (43,986.29) 10077 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 505 -TAX I& S k******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5 GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,350 800.00 1,750.00 2,350.00 - - 100.00% 101 - 541502 Cost of Bond Issuance 40,000 - 163,500.00 - - 40,000.00 0.00% TOTAL Professional Services 42,350 < <800.00 165,250.00 2,350.00 - 40,000.00 5.55 %' Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principa 265,000 - 260,000.00 265,000.00 - - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 63,525 - 37,000.00 33,750.00 29,775.00 - 100.00% 101 - 555626 LS &D SR2006- Principal 350,000 - 200,000.00 350,000.00 - - 100.00% 101 - 555626.1 LS &D SR2006- Interest 204,419 - 319,490.64 105,709.38 98,709.36 0.26 100.00% 101 - 555628 CO Bond 2007 - Principal 116,134 116,133.33 112,833.33 116,133.33 - 0.67 100.00% 101 - 555628.1 CO Bond 2007- Interest 9,582 4,790.61 14,105.86 9,581.22 - 0.78 99.99% 101 - 555629 GO Bond 2007 - Principal 255,000 - 245,000.00 255,000.00 - - 100.00% 101 - 555629.1 GO Bond 2007- Interest 169,618 82,098.68 179,321.52 169,367.15 - 250.85 99.85% 101 - 555630 GO Bond SR2008 Principal 420,000 - 430,000.00 420,000.00 - - 100.00% 101 - 555630.1 GO Bond SR2008 Interest 314,706 153,016.50 333,258.50 314,706.00 - - 100.00% 101 - 555631 GO Bond SR2009 Principal 535,000 - 590,000.00 535,000.00 - - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 298,800 - 160,787.50 153,412.50 145,387.50 - 100.00% 101 - 555633 GO SR2011 Principal 220,000 - 210,000.00 220,000.00 - - 100.00% 101 - 555633.1 GO SR2011 Interest 349,438 172,518.75 358,037.50 349,437.50 - 0.50 100.00% 101 - 555634 GO SR2011A Refund Principal 610,000 - 615,000.00 610,000.00 - - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 130,830 61,664.10 144,941.53 130,632.10 - 197.90 99.85% 101 - 555635 GO SR2012 Principal 295,000 - 285,000.00 295,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 206,444 100,363.75 219,283.76 206,443.13 - 0.87 100.00% 101 - 555636 Tax Note - SR2013 - Principal 165,000 - 160,000.00 165,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 7,543 3,400.00 11,222.38 7,542.50 - 0.50 99.99% 101 - 555637 Tax Note - SR 2013A - Principal 160,000 - 155,000.00 160,000.00 - - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 7,345 3,152.50 11,039.18 7,345.00 - - 100.00% 101 - 555638 Bond -GO 2014 Refund - Principal 50,000 - - 50,000.00 - - 100.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 358,322 147,637.50 - 358,321.94 - 0.06 100.00% 101 - 555639 Tax Note - SR2015 - Principal - 30,000.00 - 30,000.00 - (30,000.00) 0.00% 101 - 555639.1 Tax Note - SR2015 - Interest - 2,417.67 - 2,417.67 - (2,417.67) 0.00% 101 - 555900 Debt Service 32,101 - - - - 32,101.00 0.00% 101 - 555800 Bond Premium - - (686,137.00) - - - 0.00% TOTAL Debt Service 5,593,807 877,193.39 4,365,184.70 5,319,799.42 273,871.86 13512 100.00 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 505 -TAX I& S k******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5 GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Other Financing Sources 101 - 556300 Payment to Refund Debt - - 9,182,250.23 - - - 0.00% TOTAL Other Financing Sources - - 9,182,250.23 - - - 0.00% TOTAL EXPENDITURES 5,636,157 877 - ,993.39 13,712,684.93 5,322,149.42 273,872 40,135.72 99.29 %' TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 292,098.17 Cash in Investments IVIBIA Investment- Tax I&S 796,191.13 Total Cash in Bank & Investments $ 1,088,289.30 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 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 83.33% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,682,057 288,510.10 2,950,808.61 2,835,792.03 - 846,264.97 77.02% Miscellaneous 10,200 1,040.41 6,799.42 12,553.96 - (2,353.96) 123.08% TOTAL REVENUES 3,692,257 289,550.51 2,957,608.03 2,848,345.99 - 843,911.01 77.14% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 364,312 28,444.10 243,560.26 142,147.01 - 222,164.99 39.02% Supplies 1,050 89.64 464.13 590.74 31.39 427.87 59.25% Human Services 1,000 - - 135.00 - 865.00 13.50% City Support Services 16,545 - 1,174.29 1,114.09 4.00 15,426.91 6.76% Utility Services 4,120 170.65 1,522.43 786.00 - 3,334.00 19.08% Operations Support 147,145 2,646.15 94,637.96 55,231.29 1,083.71 90,830.00 38.27% Staff Support 18,250 163.98 5,185.43 2,098.81 1,545.47 14,605.72 19.97% City Assistance 1,025,000 25.97 501,524.63 25.97 50.94 1,024,923.09 0.01% Professional Services 92,500 - 16,132.41 7,021.95 5,533.05 79,945.00 13.57% Fund Charges /Transfers 471,280 8,674.33 459,624.55 437,812.05 - 33,467.95 92.90% Debt Service 430,608 156,115.25 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 196,330.07 1,751;536.33 1,077,940.93 8,248.56 1,487,620 51 42.20 %! MISC & PROJECTS PROJECTS 450,000 4,693.58 - 11,093.58 - 438,906.42 2.47% TOTAL MISC& PROJECTS 450,000 4,693.58 11,093.58 - 438,906.42 0.00% TOTAL EXPENDITURES 3,023;810 201,023.65 1,751,536.33 1,089,034.51 8,248.564 1,926,526.93 36.29% ** REVENUE OVER(UNDER) EXPEND 668;447 ' 1,759,311.48 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5 * * * * * * * * * * * * * * * * * * * * * * * * ** 620 -SED CORPORATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411500 Sales Tax Revenue (46) 3,682,057 288,510.10 2,950,808.61 2,835,792.03 - 846,264.97 77.02% TOTAL Taxes 3,682,057 288,510.10 2,950,808.61 2,835,792.03 - 846,264.97 77.02 %i Miscellaneous 000 - 491000 Interest Earned 200 6.92 262.24 146.84 - 53.16 73.42% 000 - 491200 Investment Earnings 10,000 1,033.49 6,537.18 9,946.40 - 53.60 99.46% 000 - 497000 Misc Income - - - 2,460.72 - (2,460.72} 0.00% TOTAL Miscellaneous 10,200 1,040:41 6,799.42 12,553.96 - (2,353.96) 123.08% TOTAL REVENUES 3,692,257 289,550!51 2,957,608.03 2,848,345.99 - 843,911.01 77.14% SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 84,603.67 Cash in Investments Texas Class Investment - Economic Development Corl 7,783,796.45 Schertz Bank & Trust - Certificate of Deposit 1,049,082.71 Total Cash in Bank & Investments $ 8,917,482.83 4B SALES TAX By Collection Month 41 ��� 9 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JULY 31st, 2015 C T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JULY 31st, 2015 INVESTMENT POOLS Beginning Deposits/ Interest Ending Ending Par Value Maturity Weighted OPERATIONS -BANK CASH Book Value Yiel Purchases Withdrawals Earns Book Value Mkt Value Date Avvva Mat. Schertz Bank & Trust - Pooled Cash 5,396,713.30 0.0500 7,598,270.19 6,602,374.15 259.78 6,392,869.12 6,392,869.12 6,392,869.12 N/A Schertz Bank & Trust - PEG Fund 421,511.43 0.0000 - 3,170.49 - 418,340.94 418,340.94 418,340.94 N/A TOTAL OPERATIONS - x:5,818,224.73 :7,598,270.19 ;x6,605,.544.64 c 259.78 >: 6 ;.811,210:06 6,811,21.0.06 66,811,210.06 - LOGIC General Fund 9,042,313.70 0.1265 - 1,200,000.00 892.06 7,843,205.76 7,843,205.76 7,843,205.76 N/A 45 Days G /F- Equipment Replacement 73,702.86 0.1265 - - 7.90 73,710.76 73,710.76 73,710.76 N/A 45 Days G /F- Vehicle Replacement 306,887.13 0.1265 - - 32.98 306,920.11 306,920.11 306,920.11 N/A 45 Days G/F -Air Conditioner Replacement 196,215.00 0.1265 - - 21.08 196,236.08 196,236.08 196,236.08 N/A 45 Days SR2009 Bond- Street Projects(II) 1,030,919.93 0.1265 - - 110.76 1,031,030.69 1,031,030.69 1,031,030.69 N/A 45 Days TOTAL SLOGIC 10,650,038.62 - `x1,200,000.00 1,064.78 9;451,103.40 '9,451,1031.40 - 9,451;103.40 LONESTAR Capital Recovery - Sewer 1,953,298.92 0.1600 - - 261.04 1,953,559.96 1,953,559.96 1,953,559.96 N/A 35 Days Capital Recovery - Water 4,497,056.01 0.1600 - - 600.98 4,497,656.99 4,497,656.99 4,497,656.99 N/A 35 Days Drainage Fund 1,006,428.78 0.1600 - - 134.50 1,006,563.28 1,006,563.28 1,006,563.28 N/A 35 Days Facilities Master Plan 145,270.72 0.1600 - - 19.41 145,290.13 145,290.13 145,290.13 N/A 35 Days GO SR2011 Animal Shelter 11,527.54 0.1600 - - 1.54 11,529.08 11,529.08 11,529.08 N/A 35 Days GO SR2011 Soccer Fields 210,188.65 0.1600 - - 28.09 210,216.74 210,216.74 210,216.74 N/A 35 Days GO SR2011 Swimming Pool 5,786,304.07 0.1600 - - 773.27 5,787,077.34 5,787,077.34 5,787,077.34 N/A 35 Days GO SR2012 Downtown Improvements 979,820.07 0.1600 - - 130.94 979,951.01 979,951.01 979,951.01 N/A 35 Days SE Elevated Water Tank 810,574.85 0.1600 - - 108.32 810,683.17 810,683.17 810,683.17 N/A 35 Days Sewer /CCMA Project 2,929,676.99 0.1600 - - 391.52 2,930,068.51 2,930,068.51 2,930,068.51 N/A 35 Days W /S- Customer Deposits 295,629.75 0.1600 - - 39.51 295,669.26 295,669.26 295,669.26 N/A 35 Days W /S- Equipment Repl /Cap.Imp 177,746.47 0.1600 - - 23.75 177,770.22 177,770.22 177,770.22 N/A 35 Days Water &Sewer 1,771,090.98 0.1600 - - 236.69 1,771,327.67 1,771,327.67 1,771,327.67 N/A 35 Days W /S- Vehicle Replacement 256,770.98 0.1600 - - 34.31 256,805.29 256,805.29 256,805.29 N/A 35 Days Water /SSLG - SAWS 103.40 0.1600 - - 0.01 103.41 103.41 103.41 N/A 35 Days TOTAL LONESTAR. = 20,831;488.18 - - 2,783.88' 20,834,272.06 20.,834,272.06 ::20,834,272.06 - TEXAS CLASS Tax I &S 2,982,890.18 0.1600 - 2,187,009.00 309.95 796,191.13 796,191.13 796,191.13 N/A 62 Days Police Forfeiture 244,245.06 0.1600 - - 32.48 244,277.54 244,277.54 244,277.54 N/A 62 Days Park Fund 1,355.81 0.1600 - - 0.26 1,356.07 1,356.07 1,356.07 N/A 62 Days Economic Development Corporation 7,782,762.96 0.1600 - - 1,033.49 7,783,796.45 7,783,796.45 7,783,796.45 N/A 62 Days Library Board 44,893.86 0.1600 - - 5.96 44,899.82 44,899.82 44,899.82 N/A 62 Days Tree Mitigation 397,480.21 0.1600 - - 52.74 397,532.95 397,532.95 397,532.95 N/A 62 Days Tax Note 2013 Fire Truck 4,933.88 0.1600 - - 0.62 4,934.50 4,934.50 4,934.50 N/A 62 Days Hotel Tax 499,481.99 0.1600 - - 66.37 499,548.36 499,548.36 499,548.36 N/A 62 Days Special Events Fund 16,798.18 0.1600 - - 2.19 16,800.37 16,800.37 16,800.37 N/A 62 Days Citywide Projects SR2007 725,952.25 0.1600 - - 96.44 726,048.69 726,048.69 726,048.69 N/A 62 Days Tax Notes 2015 EMS Ambulances 893,526.96 0.1600 - - 118.68 893,645.64 893,645.64 893,645.64 N/A 62 Days Tax Notes 2015 Drainage Equipment 625,386.79 0.1600 - - 83.04 625,469.83 625,469.83 625,469.83 N/A 62 Days Tax Notes 2015 Water Equipment 327,192.74 0.1600 - - 43.49 327,236.23 327,236.23 327,236.23 N/A 62 Days Tax Notes 2015 General Fund Equipme 238,140.49 0.1600 - - 31.64 238,172.13 238,172.13 238,172.13 N/A 62 Days TOTAL':: TEXAS 'CLASS 14,785,041.36 `- ;2,187,009.00 .'1,877.35` 12.:599,909:'7.1 12,599;:909:.71 .12,599:;:909.71 - E T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JULY 31st; 2015 INVESTMENT ANA,.D iNT Beginning Purchases Interest Ending Par Maturity A. =O Capital One General Fund Booms 1,368,979.81 yield Withdrawals 2.41.00 - 281.39 EBTIIEd 1,065.16 Book Valve 1,369,763.58 Mkt. Value 1,354.,583.05 Va 1,303,838.15 N /A. Avc Mat. 652 Days :Capital One Capital Recovery Sewer 1.,755,329.85 2..2000 - 360.30 754.48 1,755,724.03 1.,735;332.32 1,.681,288.68 N/A 660 Days TOTAL CAPITAL ONE 3,124,349.66 - 641.69 1!:,819.64 3,125,487.61 '.: 3,0,89,915.371 2,985,126.83 C. D. CERTIFICATES OF DEPOSIT SB &T- Water &Sewer 1,068.,630.27 0..7500 - - - 1,068,630.27 1,073,153.65 1,068,630,27" 1/7/2016 Ter 365 Days Schertz Economic Development Corp. 1,049,082.71 0.6000 - - - 1.,049,082.71 .1;050,013.95 1,049,082.71 12/5/2015 180 Days TOTAL C.D.s! 2,117,712.95 - 2,117,712.98 2,123,167.60 2,117,712.98 TOTAL PORTFOLIO 0.31 $ 7,805.43 $ 54 939, 695.82 $ 54,909,578.20 $ 54,.799,335.04 89 Days n City Manager /Executive Director Financz Di rect o.y?': _o0—Financial Analyst^e°°^ °' ""'""" TC TOTAL TEXAS CLASS 230 City Portfolio By Investment Type TOTAL C. D 38% TOTAL LOGIC 170 0 Special RevenUE Funds, $19,169,637.87 0 Debt I $7 City Portfolio By Use M Designated Funds, $1,373,746.41 E3 Operations, $18,853,480.19 j ects, $13,905,839.43 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 ....... ............................................................................... . ---- --- ------------------------------------- Dec 14 - - ----- Jan-15 ------------------ Feb -15 - --- -------- Mar-15 Apr -15 Jun-15 Jul -15 - - 5 Sep- - 15 MI Month T-Bill 0.0100 0.0400 F0.0300 0.0100 0.0200 0.0500 0.0000 0.0100 0.0200 0.0400 03 Month T-Bill 0.0100 0.0200 0.0400 0.0200 0.0200 0.0300 0A100 0.0100 0.0100 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 OSchertz Portfolio 0.2422 0.2371 0.2197 0.2265 0.2262 0.2283 0.2368 0.2339 0.3006 0.3148 WSchertz Bank&Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 GCD 365 Days 0.4000 0.4000 0.4000 0.7500 0.7500 0.7500 0.7500 0.7500 0.7500 0.7500 - ------- - - - - --------------- BCD 180 Days 0.6000 0.6000 0.3500 0.3500 - ----- 0.3500 0.3500 0.3500 0.3500 0.6000 0.6000 --- - ------------------------ GLOGIC - 0.0879 0.0871 0.0974 - --------------- 0.0843 0.0921 0.0999 - ------ 0.1130 0.1122 0.1249 - - ----------------------- ----------------- 0.1265 --- --------------------------- OLoneStar 0.1300 0.1400 0.1400 - -------- 0,1300 0.1300 0.1400 0A400 0.1500 0.1600 - ----------------------------------------------- - 0.1600 OMBIA 0.1000 0.1000 0.1000 0.1100 0.1100 0.1200 0.1400 0.1400 - -- - 0.1500 - - - - ------ - - ---------------- ------ ----------------- 0.1600 MCapital One 1.4135 1.3208 1A416 1.4858 1.4594 1.4575 1.4587 1A596 2.2923 2.2949 C I T Y OF S C H E R T Z Investment Report Capital One Assets Date: 7/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,288.68 76.00 28,838.15 28,838.15 28 838.15 33.00 0.11 Total Cash & Equivalents 66,288.68 76.00 0.II9- 28,838.15 28,838.15 28,838.15 33.00 0.110 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 138.00 200,000.00 230,779.00 203,416.00 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 138.00 100,000.00 116,185.00 101,708.00 4,875.00 4.79 1,093.00 Federal Natl Mtg Assn 1/30/2017 549.00 100,000.00 102,366.80 100,924.00 1,250.00 1.24 5,125.00 Federal Home LN Mtg Corp Reference Nts 11/17/2017 840.00 100,000.00 109,860.00 109,679.00 5,125.00 4.67 4.40 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 1048.00 275,000.00 305,095.45 304,727.50 13,406.00 4.40 US Treasury Note 3/15/2017 3/15/2017 593.00 100,000.00 99,835.94 100,328.00 750.00 0.75 US Treasury Note US Treasury Note 807.00 10/15/2017 807.00 100,000.00 99,875.00 100,250.00 875.00 0.87 10/31/2019 US Treasury Note 50,000.00 11/15/2017 838.00 100,000.00 99,425.78 100,250.00 875.00 0.87 838.00 US Treasury Note 99,425.78 11/30/2015 122.00 60,000.00 61,936.72 60,239.40 825.00 1.37 150,000.00 US Treasury Note 151,828.50 5/31/2016 305.00 190,000.00 197,094.74 192,316.10 3,325.00 1.73 99,175.78 US Treasury Note 750.00 2/28/2018 943.00 50,000.00 49,585.94 49,848.00 375.00 0.75 240,674.40 US Treasury Note 0.62 7/15/2017 715.00 100,000.00 99,664.06 100,391.00 875.00 0.87 Total Fixed Income Total Assets 1,275,000.00 1,340,925.43 1,320,661.00 32,556.00 2.47° Total Assets ! 651.99 1,303,838.15 1,369,763.58 1,349,499.15 32,589.00 2.41 %! Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 66,288.68 66,288.68 66,288.68 76.00 0.11 Total Cash & Equivalents 66,288.68 66,288.68 66,288.68 76.00 0.II9- Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 138.00 200,000.00 230,779.00 203,416.00 9,750.00 4.79 Federal Natl Mtg Assn 10/26/2017 818.00 125,000.00 124,588.38 125,178.75 1,093.00 0.87 Federal Home LN Mtg Corp Reference Nts 11/17/2017 840.00 100,000.00 109,860.00 109,679.00 5,125.00 4.67 Federal Home Mtg Corp Refrnce 8 6/13/2018 1048.00 200,000.00 221,887.60 221,620.00 9,750.00 4.40 Federal Home LN Mtg Corp 3/27/2019 1335.00 100,000.00 108,297.40 108,699.00 3,750.00 3.45 US Treasury Note 3/15/2017 593.00 150,000.00 149,753.91 150,492.00 1,125.00 0.75 US Treasury Note 10/15/2017 807.00 100,000.00 99,644.53 100,250.00 875.00 0.87 US Treasury Note 10/31/2019 1553.00 50,000.00 49,998.05 50,215.00 750.00 1.49 US Treasury Note 11/15/2017 838.00 100,000.00 99,425.78 100,250.00 875.00 0.87 US Treasury Note 5/31/2016 305.00 150,000.00 156,243.16 151,828.50 2,625.00 1.73 US Treasury Note 2/28/2018 943.00 100,000.00 99,175.78 99,696.00 750.00 0.75 US Treasury Note 7/15/2016 350.00 240,000.00 239,781.76 240,674.40 1,500.00 0.62 Total Fixed Income 1,615,000.00 1,689,435.35 1,661,998.65 37,968.00 2.289 Total Assets 659.`81 1,681,288.68 1,755,724.03 1,728,287.33 38,04`4.00 2.20 %F