The URL can be used to link to this page

05-FEBRUARY 2013 FINANCIAL STATEMENT FEBRUARY 2013 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department April 2, 2013 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR REVENUE SUMMARY Taxes13,247,165 1,015,559.098,711,534.479,543,916.40- Franchises1,665,763175,537.22589,487.34673,520.47- Permits1,216,840342,702.46373,427.00628,308.46- Licenses70,2007,492.0029,192.5033,066.50- Fees2,997,169403,842.82985,024.151,275,583.98- Fines25,0002,577.1210,391.6911,361.55(59.95) Inter-Jurisdictional640,167137,690.47284,349.37292,072.93- Fund Transfers1,950,742208,760.82544,752.95845,556.39- Miscellaneous455,54732,017.31210,069.23161,914.40(258.70) TOTAL REVENUES22,268,5932,326,179.3111,738,228.7013,465,301.08(318.65) EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,6061,540.208,764.727,051.93- Supplies4005.49189.93494.06- City Support Services39,6151,189.30916.8638,474.56213.00 Operations Support500--294.97- Staff Support20,8501,641.4914,930.1511,008.951,327.47 Operating Equipment700---- TOTAL CITY COUNCIL84,6714,376.4824,801.6657,324.471,540.47 CITY MANAGER Personnel Services924,28070,262.80289,950.82350,798.91- Supplies4,100113.552,235.95465.04242.80 Operations Support100---- Staff Support39,5502,245.1913,982.2310,099.69725.34 Operating Equipment----- TOTAL CITY MANAGER968,03072,621.54306,169.00361,363.64968.14 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR MUNICIPAL COURT Personnel Services281,30019,562.5799,753.5398,711.94- Supplies3,000-832.01788.3874.51 City Support Services1,000---- Operations Support3,500-1,558.00898.00860.00 Staff Support7,10099.571,414.73887.83- Court Support800---- Professional Services65,2504,994.3022,000.0023,044.8417,274.84 Maintenance Services2,800100.00249.94350.001,650.00 Operating Equipment800-897.14-- TOTAL MUNICIPAL COURT365,55024,756.44126,705.35124,680.9919,859.35 CUSTOMER RELATIONS-311 Personnel Services107,8537,798.4536,231.0539,233.17- Supplies200-44.75-- Staff Support1,750---- Operating Equipment500-142.00-- TOTAL CUSTOMER RELATIONS-311110,3037,798.4536,417.8039,233.17- PLANNING & ZONING Personnel Services140,97310,314.1053,530.9752,507.41- Supplies2,85028.65686.04234.16121.18 Operations Support75068.13-138.13- Staff Support16,160-1,720.85686.4739.95 Professional Services25,15014,095.0013,144.2816,846.7662.54 Operating Equipment----- TOTAL PLANNING & ZONING185,88324,505.8869,082.1470,412.93223.67 LEGAL SERVICES Operations Support12,0002,005.19-2,745.211,001.62 Professional Services348,000-143,920.3082,293.7812.87 TOTAL LEGAL SERVICES360,0002,005.19143,920.3085,038.991,014.49 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR FACILITIES MAINTENANCE Personnel Services563,70339,111.94227,130.07229,163.77- Supplies65,8975,559.4527,606.0420,855.884,376.08 Utility Services106,4489,522.6731,408.1531,354.88- Staff Support12,099408.925,329.553,053.74598.67 Maintenance Services63,9539,986.0539,197.9639,149.164,948.50 Rental/Leasing459--458.25- Operating Equipment4,950---- Capital Outlay----- TOTAL FACILITIES MAINTENANCE817,50964,589.03330,671.77324,035.689,923.25 BUILDING 6-8 MAINTENANCE Supplies28,4001,209.80-6,357.061,769.42 Utility Services91,7006,682.76-24,202.79- Maintenance Services67,7003,270.71-12,957.565,563.13 Operating Equipment9,600--9,249.00- TOTAL FACILITIES MAINTENANCE197,40011,163.27-52,766.417,332.55 CITY SECRETARY Personnel Services168,50612,611.4762,400.8362,159.78- Supplies1,250311.11636.45371.6825.82 City Support Services7,500--2,307.78- Staff Support7,850671.933,027.272,458.67- TOTAL CITY SECRETARY185,10613,594.5166,064.5567,297.9125.82 NON-DEPARTMENTAL Supplies--10.71-- City Support Services407,7534,958.43168,395.27194,652.7436,470.00 Operations Support154,5003,307.2461,382.3038,302.8239.90 City Assistance699,433-192,093.82197,914.84- Professional Services165,2203,040.3622,210.2145,204.14- Fund Chrgs/Transfrs-Spec Events Fnd220,000---- Operating Equipment269---269.00 TOTAL NON-DEPARTMENTAL1,647,17511,306.03444,092.31476,074.5436,778.90 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR PUBLIC AFFAIRS Personnel Services286,25313,701.5298,959.77118,061.81- Supplies3,500-1,687.08985.0125.57 Operations Support27,1002,355.008,386.258,972.38890.35 Staff Support5,900265.001,198.81459.03- TOTAL PUBLIC AFFAIRS322,75316,321.52110,231.91128,478.23915.92 RECORDS MANAGEMENT Personnel Services48,1443,574.3518,863.4818,340.37- Supplies400-138.005.28- Staff Support1,560193.20340.00911.38- Professional Services12,000180.501,353.501,913.005,014.08 TOTAL RECORDS MANAGEMENT62,1043,948.0520,694.9821,170.035,014.08 SCHERTZ TALES MAGAZINE Personnel Services130,56010,023.6849,200.2249,035.98- Supplies200-45.0071.54- Opperations Support200---- Staff Support2,00586.5885.74286.6834.96 Professional Services300,70013,748.94116,056.01162,550.52625.00 Fund Charges/Transfers10,000---- TOTAL SCHERTZ TALES MAGAZINE443,66523,859.20165,386.97211,944.72659.96 ENGINEERING Personnel Services258,7099,722.2631,614.6449,443.54- Supplies1,100-134.8785.65116.93 Utility Services1,44065.2560.19244.98- Staff Support6,741-130.00150.00- Professional Services43,0007,855.0040,900.0022,422.50- Maintenance Services--3,345.29-- Operating Equipment5,216-1,737.31-- Capital Outlay--23,714.00-- TOTAL ENGINEERING316,20617,642.51101,636.3072,346.67116.93 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR GIS Personnel Services128,3569,658.9546,614.0547,592.16- Supplies2,800-552.02283.95- Staff Support2,725--765.00- Professional Services1,500---- TOTAL GIS135,3819,658.9547,166.0748,641.11- TOTAL GENERAL GOVERNMENT6,201,736308,147.051,993,041.112,140,809.4984,373.53 PUBLIC SAFETY POLICE Personnel Services4,677,560351,002.051,705,737.271,707,824.94- Supplies41,5934,413.708,259.0514,970.455,102.36 City Support Services25,800-19,518.4120,657.01- Utility Services133,7359,835.4434,926.3438,491.04- Operations Support1,750-720.001,380.95120.00 Staff Support57,2013,289.629,677.305,767.123,905.14 City Assistance9,765583.002,217.74(655.79)- Professional Services28,3371,200.00642.853,383.91- Maintenance Services49,7403,052.3510,811.9511,405.022,360.00 Operating Equipment138,10022,084.3827,106.1356,320.6423,414.84 Capital Outlay178,415-142,521.25137,290.50- TOTAL POLICE 5,341,996395,460.541,962,138.291,996,835.7934,902.34 FIRE RESCUE Personnel Services2,593,286189,930.041,015,499.461,067,139.09- Supplies16,200310.4811,499.421,028.50358.65 Utility Services51,5003,957.3818,091.8516,090.92655.20 Operations Support1,200-111.56481.29- Staff Support113,80027,757.8547,852.5860,511.791,084.59 City Assistance16,2002,325.948,366.303,150.94- Professional Services17,000-22.19-12,172.00 Maintenance Services49,9002,212.5010,692.717,456.991,107.58 Operating Equipment62,3791,454.9612,279.4015,567.553,778.38 Capital Outlay--31,116.00-- TOTAL FIRE 2,921,465227,949.151,155,531.471,171,427.0719,156.40 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR INSPECTIONS Personnel Services428,70031,907.30161,221.97160,006.40- Supplies2,638102.80595.48802.30205.99 Utility Services6,500542.041,599.521,902.88- Operations Support1,50098.13-384.1344.00 Staff Support6,60082.651,533.861,663.89293.80 Professional Services8,890---- Operating Equipment500---- TOTAL INSPECTIONS 455,32832,732.92164,950.83164,759.60543.79 MARSHAL SERVICE Personnel Services545,21940,082.89208,141.23207,325.51- Supplies4,300-1,442.48200.5545.00 Utility Services16,0001,565.084,058.335,014.19- Operations Support4,000-986.41-97.50 Staff Support11,600-4,543.67460.87150.00 Maintenance Services16,500(640.00)149.002,415.00660.00 Operating Equipment21,000-14,684.08-- Capital Outlay--25,545.00-- TOTAL MARSHAL SERVICE618,61941,007.97259,550.20215,416.12952.50 TOTAL PUBLIC SAFETY9,337,408697,150.583,542,170.793,548,438.5855,555.03 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR PUBLIC ENVIRONMENT STREETS Personnel Services688,83444,464.29269,424.22257,914.00- Supplies7,1001,034.522,056.432,638.15156.72 Utility Services121,9007,115.0940,745.1636,745.66- Staff Support10,265571.042,079.242,435.88257.60 Maintenance Services178,4003,270.0271,342.2228,605.145,835.70 Rental/Lease200---- Operating Equipment5,500-3,485.993,280.00- TOTAL STREETS 1,012,19956,454.96389,133.26331,618.836,250.02 TOTAL PUBLIC ENVIRONMENT1,012,19956,454.96389,133.26331,618.836,250.02 PARKS & RECREATION PARKS DEPARTMENT Personnel Services503,32736,517.71188,590.12190,689.54- Supplies41,9051,466.0415,608.139,004.088,098.87 Utility Services143,80012,281.5841,917.8670,266.3033.01 Operations Support350---- Staff Support8,823143.324,250.622,203.80787.82 Professional Services45,6102,461.0025,233.8319,252.50- Maintenance Services19,500260.909,259.184,757.732,840.73 Rental/Leasing44,0003,385.0016,257.2016,517.6525,993.35 Operating Equipment3,000700.00-1,004.97- TOTAL PARKS DEPARTMENT810,31557,215.55301,116.94313,696.5737,753.78 SWIM POOL Supplies20,700-560.94376.6748.94 Utility Services29,0001,454.706,898.876,376.28- Staff Support925-750.00-- Maintenance Services203,378-4,000.003,633.94- Rental/Lease500---- TOTAL SWIM POOL254,5031,454.7012,209.8110,386.8948.94 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR EVENT FACILITIES Personnel Services56,5354,035.5122,346.5619,349.20- Supplies27,000(3.04)6,302.194,015.921,688.48 Utility Services48,2003,952.6711,741.0113,273.25- Operations Support27,332-4,201.714,209.00892.00 Staff Support2,727350.99875.76676.61- Professional Services1,600-150.00-- Operating Equipment--6,190.70-- TOTAL COMMUNITY/CIVIC CNTR163,3948,336.1351,807.9341,523.982,580.48 TOTAL PARKS & RECREATION1,228,21267,006.38365,134.68365,607.4440,383.20 CULTURAL LIBRARY Personnel Services704,94049,250.29273,550.66246,082.91- Supplies12,0002,100.994,134.406,116.68986.99 Utility Services51,0004,152.6114,101.4514,686.32- Operations Support3,50017.65174.00367.7320.00 Staff Support4,040120.00761.59476.00- Professional Services2,225-2,140.002,140.00- Maintenance Services2,400200.00800.00600.00- Operating Equipment75,0004,714.2528,079.3719,066.429,194.87 TOTAL LIBRARY855,10560,555.79323,741.47289,536.0610,201.86 TOTAL CULTURAL855,10560,555.79323,741.47289,536.0610,201.86 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR HEALTH ANIMAL SERVICES Personnel Services300,10819,835.66107,218.2098,558.03- Supplies23,500903.197,772.236,335.671,933.18 Utility Services11,2001,345.003,332.843,464.44- Operations Support500155.95-155.95- Staff Support12,760706.183,070.762,459.04909.02 City Assistance13,500-3,603.232,208.082,018.48 Professional Services13,500-3,687.002,904.222,762.13 Maintenance Services7,280133.842,825.00493.84120.00 Operating Equipment9,000-1,374.38350.00- TOTAL ANIMAL SERVICES391,34823,079.82132,883.64116,929.277,742.81 TOTAL HEALTH391,34823,079.82132,883.64116,929.277,742.81 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services274,64021,240.37110,157.00102,810.65- Supplies3,00035.5068.84153.84- City Support Services395,7622,619.4775,266.6364,456.68184,764.31 Utility Services167,8667,790.6955,254.4951,250.1916,655.62 Staff Support18,250174.075,891.453,770.931,794.29 Professional Services2,500---- Maintenance Services8,000-5,732.44-2,850.00 Operating Equipment106,5008,865.6833,767.6020,332.6423,529.65 Capital Outlay----8,253.97 TOTAL INFORMATION TECHNOLOGY976,51840,725.78286,138.45242,774.93237,847.84 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR HUMAN RESOURCES Personnel Services311,71024,090.91100,633.18103,882.75- Supplies1,32910.85781.5754.0533.48 Human Services55,1565,298.4012,969.0414,259.35- Operations Support16,59669.781,607.413,913.38960.00 Staff Support14,8971,628.728,060.825,689.58319.00 City Assistance9,8601,007.001,854.503,106.00696.00 Operating Equipment--4,302.13-- TOTAL HUMAN RESOURCES409,54832,105.66130,208.65130,905.112,008.48 FINANCE Personnel Services443,30632,808.30181,434.45164,830.88- Supplies2,813295.112,031.101,343.09156.54 Operations Support987-97.31-- Staff Support16,060150.00988.671,885.45150.00 Rental/Leasing2,230---- Operating Equipment--266.47-- TOTAL FINANCE465,39633,253.41184,818.00168,059.42306.54 PURCHASING & ASSET MGT Personnel Services247,93619,237.0493,812.0394,058.55- Supplies95081.20131.63184.1755.03 Utility Services60050.13249.97123.54- Operations Support100-111.79-- Staff Support7,875260.002,262.201,082.501,005.00 Operating Equipment250-7,590.82-- TOTAL PURCHASING & ASSET MGT257,71119,628.37104,158.4495,448.761,060.03 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR FLEET SERVICE Personnel Services218,52813,014.6873,427.7369,412.52- Supplies143,65014,371.9561,220.5268,823.3311,705.68 City Support Services2,400-1,500.001,488.00400.00 Utility Services7,200259.261,252.771,281.53- Operations Support400---- Staff Support4,50090.45928.81508.9933.83 Maintenance Services65,7507,961.1721,291.3931,263.566,717.24 Rental/Lease200-269.80-- Operating Equipment5,0001,380.855,349.973,884.481,108.80 TOTAL FLEET SERVICE447,62837,078.36165,240.99176,662.4119,965.55 BUILDING MAINTENANCE Personnel Services75,1426,909.09-13,758.05- Supplies43---- Utility Services2,952294.81-294.81- Staff Support3568.49-138.488.49 Maintenance Services49,88812,766.34-16,423.803,965.72 Rental/Leasing1,400375.00-375.00- Capital Outlay60,000--10,642.5014,107.50 TOTAL PURCHASING & ASSET MGT189,78120,353.73-41,632.6418,081.71 TOTAL INTERNAL SERVICE2,746,582183,145.31870,564.53855,483.27279,270.15 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBR MISC & PROJECTS CITY ASSISTANCE Patient Assistance5,000-2,500.005,000.00- Children's Advocacy Assistance5,000---- Senior Citizen's Hot Meals42,00010,500.0021,000.0021,000.0021,000.00 TOTAL CITY ASSISTANCE52,00010,500.0023,500.0026,000.0021,000.00 COURT - RESTRICTED FUNDS Operating Equipment51,053--18,185.003,240.00 TOTAL CITY ASSISTANCE51,053--18,185.003,240.00 TOTAL MISC & PROJECTS103,05310,50023,50044,18524,240 TOTAL EXPENDITURES21,875,643 1,406,039.897,640,169.487,692,607.94508,016.60 13,675,018.52 REVENUE OVER(UNDER) EXPEND.392,9505,772,693.14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Taxes 000-411100Advalorem Tax - Current7,481,207637,567.766,717,781.567,169,772.01- 000-411200Advalorem Tax - Delinquent50,0001,986.5334,040.1324,489.39- 000-411300Advalorem Tax - P&I50,0005,362.0321,738.2013,675.16- 000-411500Sales Tax Revenue-Gen Fund5,637,958370,642.771,924,198.342,328,470.70- 000-411700Mixed Beverage Tax28,000.00-13,776.247,509.14- TOTAL Taxes 13,247,165 1,015,559.098,711,534.479,543,916.40- Franchises 000-421200Center Point/Entex Energy58,7637,606.5317,987.4428,066.38- 000-421220City Public Service375,00027,115.31128,609.86144,793.95- 000-421240Guadalupe Valley Elec Co-op430,00032,024.67161,788.22154,021.64- 000-421250New Braunfels Utilities50,0003,540.2718,527.7216,900.56- 000-421300Time Warner-State Franchise350,00029,815.22143,017.06132,278.25- 000-421460AT&T Franchise Fee190,00016,704.7674,753.7291,611.56- 000-421480Other Telecom Franchise110,00049,279.937,636.8961,469.92- 000-421500Solid Waste Franchise Fee102,0009,450.5337,166.4344,378.21- TOTAL Franchises1,665,763175,537.22589,487.34673,520.47- Permits 000-431100Home Occupation Permit490105.00210.00350.00- 000-431205Building Permit - Residential408,61812,147.00180,599.00148,374.00- 000-431210Building Permit - Commercial368,149306,219.0020,362.00317,738.00- 000-431215Building Permit - General118,7145,920.0045,736.0041,750.00- 000-431300Mobile Home Permit325150.0040.00250.00- 000-431400Signs Permit1,700649.00305.002,265.00- 000-431500Food Establishmnt Permit33,000-9,975.0012,445.00- 000-431600Garage Sale Permit8,160710.003,110.004,185.00- 000-431700Plumbing Permit117,3245,552.0046,805.0035,136.00- 000-431750Electrical Permit45,0203,220.0017,480.0021,060.00- 000-431800Mechanical Permit48,4401,640.0020,300.0016,920.00- 000-431900Solicitor/Peddler Permit1,000-250.00550.00- 000-431950Animal/Pet Permit2,000300.00715.00670.00- 000-432000Cert. of Occupancy Prmt10,900300.003,950.002,750.00- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR 000-432100Security Alarm Permit45,0004,880.0020,315.0019,230.00- 000-432300Grading/Clearing Permit-260.46-260.46- 000-435000Fire Permit8,000650.003,275.004,375.00- TOTAL Permits1,216,840342,702.46373,427.00628,308.46- Licenses 000-441000Alcohol Beverage License6,000540.001,962.502,227.50- 000-441300Mobile Home License200--160.00- 000-442000Contractors License60,0006,410.0025,245.0028,820.00- 000-444000Pet License4,000542.001,985.001,859.00- TOTAL Licenses70,2007,492.0029,192.5033,066.50- Fees 000-451000Municipal Court Fines1,610,000133,488.07424,727.96570,870.00- 000-451100Arrest Fee52,7345,752.4421,616.6925,308.70- 000-451110Expunction Fee120---- 000-451200Warrant Fees138,50020,093.5056,241.0068,876.91- 000-451210Court - Claims & Judgements--1,842.23-- 000-451320Civil Justice Fee-Court828.8233.7539.80- 000-451321Civil Justice Fee-State73779.08304.33358.01- 000-451340Judicial Fee - City7,022787.832,883.893,410.92- 000-451400Traffic Fine Costs TTL27,0112,954.8911,115.6912,946.17- 000-451500Teen Court Admin Fee50040.00320.00160.00- 000-451510Juvenile Case Mgmt Fee58,5826,570.4024,047.3128,464.92- 000-451600Technology Fund Fee47,1225,326.1819,357.7322,815.87- 000-451700Security Fee34,3403,994.6214,518.3517,111.88- 000-451800Time Payment Fee - City5,598695.142,366.652,537.99- 000-451850State Fines 10% Service Fee61,204-28,248.0244,273.32- 000-451900DPS Payment - Local10,9561,467.474,496.405,477.64- 000-452000Child Safety Fee23,0002,249.5512,593.949,006.14- 000-452050Indigent Defense Fee22,5242,581.579,265.7711,254.69- 000-452100Platting Fees77,0007,061.0026,500.0014,561.00- 000-452200Site Plan Fee30,0001,500.0010,500.008,000.00- 000-452300Plan Check Fee289,401161,256.50134,711.00249,044.50- 000-452310Miscellaneous Review Fee10,800-5,100.00-- 000-452320Tree Mitigation Admin Fee10,500-780.00-- 000-452400BOA/Zoning Fees6,500500.002,750.00500.00- 000-452500Food Handler Class3,0002,420.001,670.0013,000.00- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR 000-452520Fire Training Classes1,000---- 000-452600Specific Use/Zone Chng Fee47,7002,500.0019,850.008,500.00- 000-452710Zoning Ltr & Dev Rights2,100-1,050.00600.00- 000-453100Reinspection Fees39,5002,250.0015,825.0016,225.00- 000-453110Swim Pool Inspection Fee1,000---- 000-453200Lot Abatement5,00060.00710.834,077.79- 000-453211Admin Fee-Inspections7,480-3,140.00800.00- 000-453310Misc Inspection Fee250-19.49-- 000-453710Foster Care750150.00400.00550.00- 000-454100Swim Pool Reservation Fee--55.00-- 000-454200Pool Gate Admission Fee20,000---- 000-454300Seasonal Pool Pass Fee7,500---- 000-456500Haz Mat Fees1,500-3,000.00-- 000-456600Fire Re-inspection Fee750150.00400.00550.00- 000-458110Sale of Merchandise-GovDeal-9,028.27-9,028.27- 000-458300Sale of Property/Auction25,000-9,257.47855.12- 000-458400Civic Center Rental Fees132,20012,746.5040,142.2561,509.50- 000-458401Capital Recovery Fee-Civic Cntr4,800828.002,450.001,900.00- 000-458450North Center Rental Fees23,0001,875.009,357.927,145.00- 000-458500Community Center Rental Fees26,0005,134.869,769.2913,265.26- 000-458550Pavilion Rental Fees18,0001,545.004,344.504,480.00- 000-458560Chamber of Comm rent11,700-3,900.003,900.00- 000-458570Non-Resident SYSA League19,000-15,935.004,940.00- 000-458650NonResident User Fee-BVYA17,000-2,670.003,340.00- 000-458660BVYA Utility Reimbursement5,0001,326.133,195.721,326.13- 000-458670SYSA Utility Reimbursement7,500-2,098.92-- 000-458675Lions Futbol Utility Reimbursement-2,200.00-5,772.00- 000-458680Tournament Fees-Soccer3,000-7,625.00600.00- 000-458700Vehicle Impoundment5,7792,040.00-2,040.00- 000-459200NSF Check Fee250--490.00- 000-459300Notary Fee25030.00120.00144.00- 000-459400Maps, Copies, UDC, & Misc F250-58.105.00- 000-459600Animal Adoption Fee14,0001,330.005,380.506,698.50- 000-459700Pet Impoundment Fee14,0001,352.006,087.256,106.05- 000-459800Police Reports Fee8,677470.002,191.202,717.90- TOTAL Fees2,997,169403,842.82985,024.151,275,583.98- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Fines 000-463000Library Fines25,0002,577.1210,391.6911,361.55(59.95) TOTAL Fines25,0002,577.1210,391.6911,361.55(59.95) Inter-Jurisdictional 000-473100Bexar Co - Fire21,072-7,025.927,025.92- 000-473200City of Seguin - Fire Contract31,4523,355.2616,776.3016,776.30- 000-473300Guad Co - Library208,34317,361.9179,506.6585,348.97- 000-473400Randolph AFB-Animal Cntrl 1,000-600.001,400.00- 000-474200Library Services - Cibolo20,000---- 000-474210Library Services-Selma18,393---- 000-474400Dispatch Service - Cibolo133,30533,326.2566,652.5066,652.50- 000-474600School Crossing Guard-Bexar27,0002,963.9513,111.4113,628.20- 000-474610School Cross Guard-Guadalupe24,6023,183.1013,176.5911,241.04- 000-474700School Officer Funding155,00077,500.0087,500.0090,000.00- TOTAL Inter-Jurisdictional640,167137,690.47284,349.37292,072.93- Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.0036,600.0036,600.00- 000-480100Indirect Costs - Hotel/Motel157,51713,126.4259,427.5065,632.10- 000-481000Transfer From Reserves----- 000-485000Interfund Charge-Drainage49,7084,142.3317,431.2520,711.65- 000-486000Interfund Chrges-Admin W&S1,060,96388,413.58367,175.85442,067.90- 000-486106Transfer in-Special Events--1,000.00-- 000-486202Transfer In-W&S80,000---- 000-486322Transfer-In - Library Grants----- 000-487000Interfund Charges-Fleet112,7619,396.7541,035.0046,983.75- 000-488000Interfund Charges-4B243,35020,279.1722,083.35101,395.85- 000-489000Transfer In158,60366,082.57-132,165.14- 000-490020Transfer In-SEDC----- TOTAL Fund Transfers1,950,742208,760.82544,752.95845,556.39- C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************ 2 0 1 2 - 2 0 1 3 **************************************************** 101 GENERAL FUNDCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Miscellaneous 000-491000Interest Earned350-126.7230.49- 000-491200Investment Income45,0003,890.0218,968.2817,814.30- 000-491800Gain/Loss--443.67-- 000-491900Unrealized Gain/Loss(26,000)(2,694.90)(13,288.63)(14,452.60)- 000-492100Proceeds-Sale of Land--57,867.85-- 000-493120Donations-Public Library---7,500.00- 000-493130Donations-Writing the Next Chap.2,00050.004,806.34250.00- 000-493400Donation - Animal Control4,000-1,579.011,108.76- 000-493401Donations-A/C Microchip2,000130.00910.00725.00- 000-493402Donations-Spay&Neuter12,0001,160.005,517.006,730.89- 000-493503Donations - Fire Rescue---150.00- 000-494481LawEnforcemtOfficersStnd&Ed--50.00-- 000-494482Grants - Police2,997---- 000-495040Friends of N. Schertz Park--3,074.00885.00- 000-495100Mobile Stage Rental Fees2,000---- 000-497000Misc Income-Gen Fund50,000762.06(26,367.15)7,153.40(258.70) 000-497005Schertztales Advertising220,000-73,045.9575,774.00- 000-497007Misc Income-Schertz Artz--20.0010.00- 000-497100Misc Income-Police20,000310.002,382.954,941.76- 000-497150Misc Income-Fire Department---292.37- 000-497200Misc Income-Library4,000320.751,662.941,634.25- 000-497210Misc Income-Library Copier12,000898.655,485.465,431.55- 000-497300Misc Income-Animal Control200-105.00190.00- 000-497400Misc Income-Streets Dept.15,000797.807,019.487,992.60- 000-497500Misc Income-TML Insurance2,00013,573.21-13,573.21- 000-497550Misc Income-TML Reimbursemt15,000-5,795.914,938.66- 000-497600Misc Income-Vending Mach.2,000219.06742.35905.28- 000-498000Reimbursmnt-Gen Fund50,00011,080.5021,409.0215,757.08- 000-498100Reimbursmnt Fire - Training1,000---- 000-498105Reimburmnt Police - DEA-1,520.16569.872,578.40- 000-498110Reimbursmnt Fire - Emg. Acti-O20,000-38,143.21-- TOTAL Miscellaneous455,54732,017.31210,069.23161,914.40(258.70) TOTAL REVENUES 22,268,593 2,326,179.31 11,738,228.70 13,465,301.08(318.65) GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 720,234.55 Cash in Investments LOGIC Investment-General Fund6,463,991.86 LOGIC Investment-Equip Replacement73,522.92 LOGIC Investment-Veh Replacement102,570.01 LOGIC Investment-Air Condi Replacment146,794.67 CAPITAL ONE Investment-General Fund1,341,813.06 Total Cash in Bank & Investments$ 8,995,508.91 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 292,988636,9643,422,1072,180,145637,568 2011-12 1,540,041228,9242,439,1231,871,054635,71964,19027,87829,91918,03926,509 2010-11 1,406,160244,2552,331,4871,725,242735,329174,68737,34143,10815,12026,143 2009-10 1,277,0061,642,355702,8741,730,904562,689(32,792)59,54534,76219,83629,955 2008-09 703,3501,823,090757,6021,345,602699,462114,53710,51445,08736,65925,468 Sales Tax -General Fund $700,000 37% 24% $600,000 40% $500,000 2% 2% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 439,433575,041474,246424,191632,716 2011-12 428,995463,636339,192415,822461,400365,083347,395535,930398,080408,851 2010-11 339,709332,264347,605353,229470,399324,575283,300425,848408,664342,513 2009-10 300,384338,514281,259288,350477,063293,178273,874366,704350,314324,169 2008-09 332,597414,845371,763300,829434,646298,499282,410394,233317,296310,159 2007-08 336,749350,854312,547327,798421,873330,131287,316355,054336,094328,147 CITY PUBLIC SERVICE üïîðôððð üïððôððð üèðôððð üêðôððð üìðôððð üîðôððð üó ÑÝÌÒÑÊÜÛÝÖßÒÚÛÞÓßÎßÐÎÓßÇÖËÒÖËÔ îðïîóïí ïðïôììðçìôðëì îðïïóïî çêôíçîéêôìïìééôíçè îðïðóïï èíôìííêîôêçîêéôëêï îððçóïð ééôíëìêïôìêèêíôîéê îððèóðç ééôíðèëíôðéïëéôëðê C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 106-SPECIAL EVENTS FUNDCURRENTCURRENTPRIORCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Fund Transfers75,150.00----75,150.00 Wilenchik Walk for Life31,000.004,795.00440.004,905.00-26,095.00 Hal Balwin Scholarship24,000.00-60.0018,460.00- Miscellaneous1,150.005,105.97761.39947.27- TOTAL REVENUES131,300.009,900.971,261.3924,312.27-106,987.73 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00---- TOTAL GENERAL GOVERNMENT5,150.00---- CULTURAL Other Events4,265.00(248.00)-237.00959.64 Festival of Angels14,750.001,652.0913,050.4616,017.55-(1,267.55) Employee Appreciation Event6,485.00485.00-4,985.00- National Night Out150.00---- Wilenchik Walk for Life31,000.00700.002,380.00700.00-30,300.00 Schertz Sweetheart37,500.007,040.053,001.328,567.403,075.3425,857.26 Jazzfest20,000.00----20,000.00 Hal Baldwin Scholarship12,000.00-1,000.007,912.27-4,087.73 TOTAL CULTURAL126,150.009,629.1419,431.7838,419.224,034.9883,695.80 TOTAL EXPENDITURES131,300.009,629.1419,431.7838,419.224,034.9888,845.80 REVENUE OVER(UNDER) EXPEND-(14,106.95) SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 31,718.61 Cash in Investments MBIA Special Events46,729.34 Total Cash in Bank & Investments$ 78,447.95 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 110-PEG FUNDCURRENTCURRENTPRIORCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Franchises98,000.0023,182.9523,050.5848,102.73-49,897.27 Fund Transfers33,000.00----33,000.00 Miscellaneous--19.34-- TOTAL REVENUES131,000.0023,182.9523,069.9248,102.73-82,897.27 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental131,000.00-123.1920,181.96-110,818.04 TOTAL GENERAL GOVERNMENT131,000.00-123.1920,181.96-110,818.04 TOTAL EXPENDITURES131,000.00-123.1920,181.96-110,818.04 REVENUE OVER(UNDER) EXPEND-27,920.77 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ************************************************** 2 0 1 2 - 2 0 1 3 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Franchises 000-421350Time Warner - PEG Fee65,00014,529.5615,802.6329,490.36-35,509.64 000-421465AT&T PEG Fee33,0008,653.397,247.9518,612.37-14,387.63 TOTAL Franchises98,00023,18323,050.5848,102.73-49,897.27 Fund Transfers 000-481000Transfer In - Reserves33,000----33,000.00 TOTAL Fund Transfers33,000----33,000.00 Miscellaneous 000-491000Interest Earned--19.34-- TOTAL Miscellaneous--19.34-- TOTAL REVENUES131,00023,18323,069.9248,103-82,897.27 PEG FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Cash Balance$ 395,890.62 Total Cash in Bank & Investments$ 395,890.62 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWER CURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE REVENUE SUMMARY Franchises187,9202,500.0088,232.792,500.00-185,420.00 Permits-6,909.00-6,909.00- Fees 14,655,3761,138,606.026,353,754.746,282,607.53-8,372,768.47 Fund Transfers1,419,2989,941.5035,280.8549,707.50-1,369,590.50 Miscellaneous430,14824,757.54192,087.64209,855.06-220,292.94 TOTAL REVENUES16,692,7421,182,714.066,669,356.026,551,579.09-10,141,162.91 EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services436,69432,124.90139,903.57147,738.76-288,955.24 Supplies4,51727.332,007.24501.1585.94 Human Services183150.27-272.27- City Support Services1,000---- Operations Support110,00023,612.7637,600.4540,038.9012.22 Staff Support7,150281.60830.55376.09293.28 Professional Services23,0001,080.828,913.808,444.02- Fund Charges/Transfers20,000---- Maintenance Services11,0001,920.003,600.007,180.003,360.00 Operating Equipment2,30023.745,932.941,452.4435.66 TOTAL BUSINESS OFFICE615,84459,221.42198,788.55206,003.633,787.10406,053.27 W & S ADMINISTRATION Personnel Services1,184,01383,052.93437,661.53391,718.47-792,294.53 Supplies198,65061,007.1723,724.6694,253.567,872.06 Human Services1,000--141.00- City Support Services77,50050.0034,379.5934,412.40- Utility Services2,727,313204,089.871,141,386.021,263,972.43-1,463,340.21 Operations Support9,250256.011,515.831,024.04- Staff Support31,500777.467,539.818,905.511,671.13 City Assistance1,912468.55150.003,926.99- Professional Services212,4003,741.0186,718.1720,364.64900.00191,135.36 Fund Charges/Transfers3,137,047199,587.411,237,342.741,238,692.24-1,898,354.76 Maintenance Services5,586,250466,898.991,963,697.751,996,353.5640,550.043,549,346.40 Other Costs40,000-30,956.4429,541.85- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWER CURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE Debt Service1,353,89175,903.1396,868.35179,894.46-1,173,996.06 Rental-Leasing6,0701,521.382,516.681,963.5680.31 Operating Equipment6,400-12,000.00757.50- Capital Outlay188,000430.0070,000.0082,880.0014.98105,105.02 TOTAL PUBLIC WORKS 14,761,1951,097,783.915,146,457.575,348,802.2151,088.529,361,304.43 MISC & PROJECTS PROJECTS City Support Services64,354---- Operations Support952---- Professional Services27,748---- Maintenance Services1,065,193----1,065,193.00 TOTAL PROJECTS1,158,247----1,158,247.00 AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- Operations Support500---- Professional Services48,500---- Maintenance Services334,500----334,500.00 TOTAL AVIATION HEIGHTS WTR IMP400,500----400,500.00 TOTAL MISC & PROJECTS1,558,747----1,558,747.00 TOTAL EXPENDITURES16,935,7861,157,0055,345,2465,554,80654,87611,326,105 ** REVENUE OVER(UNDER)EXPENSES **(243,044)996,773.25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWERCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Franchises 000-421490Tower Leasing187,9202,500.0088,232.792,500.00- TOTAL Franchises187,9202,500.0088,232.792,500.00- Permits 000-432400Development Permit-6,909.00-6,909.00- TOTAL Permits-6,909.00-6,909.00- Fees 000-455200Garbage Collection Fee3,600,000305,821.311,482,049.351,485,141.11-2,114,858.89 000-455600Fire Line Fees20,000-19,690.0020,635.00- 000-455700Recycle Fee Revenue250,00020,933.07108,828.47110,918.77- 000-455800W&S Line Constructn Reimbursemnt30,0001,022.0012,558.837,319.82- 000-457100Sale of Water7,279,626537,444.643,105,828.433,103,686.72-4,175,939.28 000-457110Edwards Water Lease166,250-165,375.8555,232.85- 000-457120Water Transfer Charge-Selma20,000-13,657.9521,648.48- 000-457130Water Transfer Charge-U. C. 2,000-2,199.973,073.12- 000-457140Water Transfer Charge-Converse15,000--18,723.68- 000-457200Sale of Meters90,0002,650.0025,675.5819,357.05- 000-457400Sewer Charges3,000,000256,083.851,340,725.991,356,449.86-1,643,550.14 000-457500Water Penalties180,00014,411.1575,814.3279,121.07- 000-459200NSF Check Fee-Water&Sewer2,500240.001,350.001,300.00- TOTAL Fees 14,655,376 1,138,606.026,353,754.746,282,607.53-8,372,768.47 Fund Transfers 000-481000Transfer In- Reserve1,300,000----1,300,000.00 000-486100Transfer In----- 000-486204Interfnd Chrg-Drainage Bill119,2989,941.5035,280.8549,707.50- TOTAL Fund Transfers1,419,2989,941.5035,280.8549,707.50-1,369,590.50 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ****************************************************** 202-WATER & SEWERCURRENTCURRENTPRIOR YEARY-T-DY-T-D REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBR Miscellaneous 000-490000Misc Charges20011.5083.05785.80- 000-491000Interest Earned1,600-831.76269.13- 000-491200Investment Income12,000468.556,124.263,926.99- 000-493400Donations-Christmas Activities--750.00-- 000-496050SSLG - SAWS Reservation269,000-134,500.00134,500.00- 000-497000Misc Income-W&S40,00017.8624,099.2719,611.40- 000-498100Reimbursement-EMS Loan----- 000-498110Reimbursement-SSLGC107,34824,259.6325,699.3050,761.74- TOTAL Miscellaneous430,14824,757.54192,087.64209,855.06- TOTAL REVENUES 16,692,742 1,175,805.066,669,356.026,544,670.09- 10,148,071.91 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 382,716.28 Cash in Investments Lone Star Investment-Water&Sewer1,119,242.40 Lone Star Investment-W&S Customer Deposits294,594.38 Lone Star Investment-W&S Equip Replacement374,249.10 Lone Star Investment-W&S Veh Replacement545,699.95 Lone Star Investment-Water/SSLGC SAWS539,314.47 Schertz Bank & Trust-Certificate of Deposit1,060,132.25 $ 3,933,232.55 Total Cash in Bank & Investments$4,315,948.83 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 203-EMSCURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE REVENUE SUMMARY Fees296,650.961,296,434.22 1,859,293.93(300.00) 2,290,408.07 4,149,402 Inter-Jurisdictional24,118.24692,549.52716,466.62-770,256.38 1,486,723 Miscellaneous236,5004,015.2229,818.9831,837.55-204,662.45 TOTAL REVENUES324,784.422,018,802.722,607,598.10(300.00)3,265,326.90 5,872,625 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services209,268.801,056,357.40 1,061,890.84- 1,753,831.18 2,815,722 Supplies345,08912,671.76150,727.27114,015.8958,768.42172,304.69 Human Services800--132.00- City Support Services32,500-10,277.4013,888.85-18,611.15 Utility Services107,6009,403.9336,473.1142,069.4715.0065,515.53 Operations Support45,1521,946.3929,500.3331,398.661,482.8512,270.49 Staff Support60,9004,371.1328,469.0924,010.9515,539.4921,349.56 City Assistance9,2001,500.002,747.503,304.00250.005,646.00 Professional Services166,9362,259.2547,486.4054,772.299,405.67102,758.04 Fund Charges/Transfers31,871.07517,561.17323,763.11- 1,656,291.89 1,980,055 Maintenance Services53,7002,138.4723,235.5222,258.47620.0030,821.53 Debt Service110,545-5,863.0064,766.50-45,778.17 Rental-Leasing12,000----12,000.00 Operating Equipment117,00021,718.8940,923.0132,770.20126,510.40(42,280.60) Capital Outlay----- TOTAL PUBLIC SAFETY297,149.691,949,621.201,789,041.23212,591.833,855,565.63 5,857,199 TOTAL EXPENDITURES297,149.691,949,621.201,789,041.23212,591.833,855,565.63 5,857,199 ** REVENUE OVER(UNDER) EXPENSES **15,426818,556.87 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 203-EMSCURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE Fees 000-456100Ambulance/Mileage Transport3,908,602295,380.961,253,732.22 1,821,388.89- 2,087,213.11 000-456110Subscription Program Fees40,0001,620.0016,995.0017,195.00-22,805.00 000-456120EMT Class - Fees100,800(350.00)23,901.0020,400.00(300.00)80,700.00 000-459200Paramedic Class Fees100,000---100,000.00 000-456130Immunization Fees--1,806.00-- 000-456140Billing Fees - Alamo Heights---290.04-(290.04) 000-459200NSF Check Fee---20.00-(20.00) TOTAL Fees4,149,402296,650.961,296,434.22 1,859,293.93(300.00) 2,290,408.07 Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,12624,118.24119,219.40119,494.40-166,631.60 000-474300Cibolo Support228,830-111,049.96114,415.10-114,414.90 000-475100Comal Co ESD #685,418-34,544.1342,735.19-42,682.81 000-475200Live Oak Support165,188-80,164.7682,593.98-82,594.02 000-475300Universal City Support233,107-113,975.66116,553.70-116,553.30 000-475400Selma Support69,693-33,821.7034,846.60-34,846.40 000-475500Schertz Support395,830-192,093.82197,914.84-197,915.16 000-475600Santa Clara Support9,121-4,426.124,560.24-4,560.76 000-475800Marion Support13,410-3,253.973,352.57-10,057.43 TOTAL Inter-Jurisdictional1,486,72324,118.24692,549.52716,466.62-770,256.38 Miscellaneous 000-491200Investment Income50038.77232.01240.26-259.74 000-493203Donations-EMS4,000100.00595.00281.00-3,719.00 000-493204Donations-Dilworth Fund2,000----2,000.00 000-493205Donations- Golf Tournament----- 000-497000Misc Income130,0003,011.0628,101.9726,787.09-103,212.91 000-497100Recovery of Bad Debt100,000865.39890.004,529.20-95,470.80 TOTAL Miscellaneous236,5004,015.2229,818.9831,837.55-204,662.45 TOTAL REVENUES5,872,625324,784.422,018,802.72 2,607,598.10(300.00) 3,265,326.90 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank $ (233,874.57) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,655.00 Total Cash in Bank & Investments$ 67,780.43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Fees998,15785,904.24322,836.80426,118.24-572,038.76 Miscellaneous800164.46370.58851.07-(51.07) TOTAL REVENUES998,95786,068.70323,207.38426,969.31-571,987.69 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services447,40624,063.79133,529.05138,287.07-309,118.93 Supplies8,30022.46641.061,143.2870.887,085.84 Human Services325----325.00 City Support Services28,855-1,508.721,463.58-27,391.42 Utility Services27,4001,784.246,391.627,570.76-19,829.24 Operations Support2,460----2,460.00 Staff Support7,875272.821,082.771,073.9356.406,744.67 City Assistance840-57.0060.00-780.00 Professional Services65,800-6,806.252,100.00-63,700.00 Fund Charges/Transfers189,13615,694.6658,929.6078,473.30-110,662.70 Maintenance Services22,000--2,107.56134.2019,758.24 Other costs200-100.00100.00-100.00 Debt Service18,091-1,632.071,345.35-16,745.65 Rental/Leasing500----500.00 Capital Outlay139,90026,957.45-90,683.0434,988.3614,228.60 TOTAL DRAINAGE959,08868,795.42210,678.14324,407.8735,249.84599,430.29 TOTAL EXPENDITURES959,08868,795.42210,678.14324,407.8735,249.84599,430.29 ** REVENUE OVER(UNDER) EXPEND39,869102,561.44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *********************************************** 2 0 1 2 - 2 0 1 3 ************************************************* 204-DRAINAGECURRENTCURRENTPRIOR YEARY-T-DY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALACTUALENCUMBRBALANCE Fees 000-457500Drainage Penalties4,000712.222,133.243,178.19-821.81 000-457600Drainage Fee994,157320,703.56422,940.05-571,216.95 85,192.02 TOTAL Fees998,157322,836.80426,118.24-572,038.76 85,904.24 Miscellaneous 000-491000Interest Earned100-32.287.21-92.79 000-491200Investment Interest60064.46312.89390.00-210.00 000-497000Misc Income-Drainage100100.0025.41453.86-(353.86) TOTAL Miscellaneous 800164.46370.58851.07-(51.07) TOTAL REVENUES998,957323,207.38426,969.31-571,987.69 86,068.70 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking 151,461.54 Cash in Investments Lone Star Investment-Drainage Maint Fund484,281.47 Total Cash in Bank & Investments$ 635,743.01 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 **************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Taxes492,41732,145.9499,964.59109,010.63-383,406.37 Fund Transfers------ Miscellaneous30033.96106.10217.09-82.91 TOTAL REVENUES492,71732,179.90100,070.69109,227.72-383,489.28 EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies2,00033.961,826.50214.01-1,785.99 City Support Services68,378-35,814.0035,945.56-32,432.44 Operations Support99,1753,700.0012,135.298,086.00-91,089.00 Professional Services5,625--7,850.00-(2,225.00) Fund Charges/Transfers248,76713,126.4259,427.5065,632.10-183,134.90 Operating Equipment50,000-16,208.469,152.547,843.7533,003.71 Capital Outlay8,000----8,000.00 TOTAL NONDEPARTMENTAL481,94516,860.38125,411.75126,880.217,843.75347,221.04 TOTAL EXPENDITURES481,94516,860.38125,411.75126,880.217,843.75347,221.04 REVENUE OVER(UNDER) EXPENDITURE10,772(17,652.49) C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Taxes 000-411800Hotel Occupancy Tax492,41732,145.9499,964.59109,010.63-383,406.37 TOTAL Taxes492,41732,145.9499,964.59109,010.63- 383,406.37 Miscellaneous 000-491000Interest Earned150-47.953.08-146.92 000-491200Investment Interest15033.9658.15214.01-(64.01) TOTAL Miscellaneous30033.96106.10217.09-82.91 TOTAL REVENUES492,71732,179.90100,070.69109,227.72- 383,489.28 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 74,452.69 Cash in Investments MBIA - Hotel Tax220,365.23 Federated Investment-Hotel/Motel78,303.98 Total Cash in Bank & Investments$ 373,121.90 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 317-PARKCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Parkland Dedication Fees150,00030,000.0052,575.00161,000.00-(11,000.00) Miscellaneous127,18411.79281.0383.93-127,100.07 TOTAL REVENUES277,18430,011.7952,856.03161,083.93-116,100.07 EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services--13,000.00545.00-(545.00) Fund Charges/Transfers138,88477,000.00-77,000.00-61,884.00 Maintenance Services-Landscape------ Operating Equipment--27,979.651,210.00979.50(2,189.50) Capital Outlay107,600-23,416.00--107,600.00 TOTAL PARKLAND DEDICATION246,48477,000.0064,395.6578,755.00979.50166,749.50 TOTAL EXPENDITURES246,48477,000.0064,395.6578,755.00979.50166,749.50 REVENUE OVER(UNDER) EXPEND30,70082,328.93 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 317-PARKCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCE Fees 000-458800Parkland Dedication150,00030,000.0052,575.00161,000.00-(11,000.00) TOTAL Fees150,00030,000.0052,575.00161,000.00- (11,000.00) Miscellaneous 000-491000Interest Earned--7.602.48-(2.48) 000-491200Investment Interest30011.79273.4381.45-218.55 000-499100Transfer from Reserves126,884----126,884.00 TOTAL Miscellaneous127,18411.79281.0383.93-127,100.07 TOTAL REVENUES277,18430,011.7952,856.03161,083.93-116,100.07 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$69,753.82 Cash in Investments Federated Investment-Park Fund167,492.50 Total in Investment Pool167,492.50 Total Cash in Bank & Investments$237,246.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 319-TREE MITIGATIONCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Tree Mitigation Fees35,000-4,420.00--35,000.00 Miscellaneous61,7256.85-1,752.46-59,972.54 TOTAL REVENUES96,7256.854,420.001,752.46-94,972.54 EXPENDITURE SUMMARY TREE MITIGATION Fund Charges/Transfers------ Maintenance Services-Trees73,299-758.0033,300.00-39,998.94 Operating Equipment------ Capital Outlay23,226-19,900.0023,226.06-- TOTAL TREE MITIGATION96,525-20,658.0056,526.06-39,998.94 TOTAL EXPENDITURES96,525-20,658.0056,526.06-39,998.94 REVENUE OVER(UNDER) EXPEND200(54,773.60) C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 319-TREE MITIGATIONCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCE Fees 000-458900Tree Mitigation35,000-4,420.00--35,000.00 TOTAL Fees35,000-4,420.00--35,000.00 Miscellaneous 000-491000Interest Earned----- 000-491200Investment Interest2006.85-62.46-137.54 000-497000Misc Income---1,690.00-(1,690.00) 000-499000Transfer In Reserves61,525----61,525.00 TOTAL Miscellaneous61,7256.85-1,752.46-59,972.54 TOTAL REVENUES96,7256.854,420.001,752.46-94,972.54 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$64,432.38 Cash in Investments Federated Investment-Tree Mitigation97,183.59 Total in Investment Pool97,183.59 Total Cash in Bank & Investments$161,615.97 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ******************************************************* 2 0 1 2 - 2 0 1 3 ******************************************************* 411-CAPITAL RECOVERYCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Fees1,924,20074,892.00614,120.52449,031.00- 1,475,169.00 Fund Transfers1,542,674---- 1,542,674.00 Miscellaneous298,7501,311.246,359.284,733.72-294,016.28 TOTAL REVENUES3,765,62476,203.24620,479.80453,764.72-3,311,859.28 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000---5,000.00 Operations Support109-108.50--109.00 Professional Services450,0002,890.592,061.779,929.55-440,070.45 Fund Charges/Transfers----- Maintenance Services10,000----10,000.00 Debt Service206,515-108,671.00--206,515.00 TOTAL NON DEPARTMENTAL671,6242,890.59110,841.279,929.55-661,694.45 MISC & PROJECTS Water Projects1,680,000-10,488.422,759.64- 1,677,240.36 Sewer Projects1,414,00029,065.71-82,262.17-1,331,737.83 TOTAL MISC & PROJECTS3,094,00029,065.7110,488.4285,021.81-3,008,978.19 TOTAL EXPENDITURES3,765,62431,956.30121,329.6994,951.36-3,670,672.64 REVENUE OVER(UNDER) EXPENDITURES-358,813 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 **************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 411-CAPITAL RECOVERYCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Fees 000-455900Capital Recovery - Water1,173,60052,812.00422,259.00277,263.00-896,337.00 000-455910Capital Recovery - Waste Wtr667,20016,680.00168,461.52126,768.00-540,432.00 000-455913Cap Recovery-North Sewer Tr83,4005,400.0023,400.0045,000.00-38,400.00 TOTAL Fees1,924,20074,892.00614,120.52449,031.00-1,475,169.00 Fund Transfers 000-481000Transfer from Reserves1,542,674----1,542,674.00 000-486202Transfer in-Water----- TOTAL Fund Transfers1,542,674----1,542,674.00 Miscellaneous 000-491000Interest Earned250-117.3426.38-223.62 000-491200Investment Income40,0004,614.7420,239.4723,422.89-16,577.11 000-491800Gain/Loss--(554.28)-- 000-491900Unrealized Gain/Loss-Cap One(25,000)(3,303.50)(13,443.25)(18,715.55)-(6,284.45) 000-497000Misc Income----- 000-498200Re-imbursement-Water Meters283,500----283,500.00 TOTAL Miscellaneous298,7501,311.246,359.284,733.72-294,016.28 TOTAL REVENUES3,765,62476,203.24620,479.80453,764.72-3,311,859.28 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 474,009.05 Cash in Investments Lone Star Investment-Capital Recovery Water2,383,328.19 Lone Star Investment-Capital Recovery Sewer1,097,002.43 Capital One-Investment1,719,283.65 Total Cash in Bank & Investments$5,673,623.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ****************************************************** 2 0 1 2 - 2 0 1 3 **************************************************** 505-TAX I&SCURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Taxes5,032,646428,544.484,176,855.404,822,487.55-210,158.45 Fund Transfers55,000----55,000.00 Miscellaneous381,625346,200.871,975.55357,449.40-24,175.60 TOTAL REVENUES5,469,271774,745.354,178,830.955,179,936.95-289,334.05 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services42,350-36,210.39550.00-41,800.00 Debt Service5,159,586 2,036,516.893,074,924.523,890,041.02- 1,269,544.48 Other Financing Sources----- TOTAL GENERAL GOVERNMENT5,201,9362,036,516.893,111,134.913,890,591.02-1,311,344.48 TOTAL EXPENDITURES5,201,9362,036,516.893,111,134.913,890,591.02-1,311,344.48 ** REVENUE OVER(UNDER) EXPEND267,3361,289,345.93 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 505-TAX I & SCURRENTCURRENTPRIOR YEARCURRRENTY-T-DBUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Taxes 000-411900Property Tax Revenue5,032,646428,544.484,176,855.404,822,487.55-210,158.45 TOTAL Taxes5,032,646428,544.484,176,855.404,822,487.55-210,158.45 Fund Transfers 000-486401Transfer In Fund 40155,000----55,000.00 TOTAL Fund Transfers55,000----55,000.00 Miscellaneous 000-491000Interest Earned50-27.872.71- 000-491200Investment Earnings12,5002,194.6210,063.7313,440.44- 000-495015Contribution from SED369,075344,006.25-344,006.25-25,068.75 000-497000Misc Income--(8,116.05)-- TOTAL Miscellaneous381,625346,200.871,975.55357,449.40-24,175.60 TOTAL REVENUES5,469,271774,745.354,178,830.955,179,936.95-289,334.05 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 505-TAX I & S***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARCURRENTY-T-D NON DEPARTMENTALBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBR Professional Services 101-541500Paying Agent2,350-400.00-- 101-541502Cost of Bond Issuance40,000-35,810.39550.00- TOTAL Professional Services42,350-36,210.39550.00- Debt Service 101-555612Bond-GO Refunding 2010-Principal250,000250,000.00240,000.00250,000.00- 101-555612.1Bond-GO Refunding 2010 Interest77,12540,125.0042,525.0040,125.00- 101-555622Schertz C O SR2003-Principal210,000210,000.00200,000.00210,000.00- 101-555622.1Schertz C O SR2003-Interest3,8333,832.507,432.503,832.50- 101-555624Comm Proj Bond-SR04-Principal325,000325,000.00315,000.00325,000.00- 101-555624.1Comm Proj Bond SR04-Interest6,9106,906.2513,796.886,906.25- 101-555626LS&D SR2006-Principal200,000200,000.00100,000.00200,000.00- 101-555626.1LS&D SR2006-Interest642,982323,490.64325,490.64323,490.64- 101-555628CO Bond 2007-Principal109,534---- 101-555628.1CO Bond 2007-Interest18,499-10,864.439,249.07- 101-555629GO Bond 2007-Principal235,000-225,000.00235,000.00- 101-555629.1GO Bond 2007-Interest189,561-101,750.0097,109.43- 101-555630GO Bond SR2008 Principal385,000-370,000.00385,000.00- 101-555630.1GO Bond SR2008 Interest349,089-186,159.75178,519.25- 101-555631GO Bond SR2009 Principal510,000510,000.00200,000.00510,000.00- 101-555631.1BO Bond SR2009 Interest327,950167,162.50140,656.25167,162.50- 101-555633GO SR2011 Principal200,000-90,000.00200,000.00- 101-555633.1GO SR2011 Interest367,238-346,167.71186,118.75- 101-555634GO SR2011A Refund Principal70,000-140,000.0070,000.00- 101-555634.1GO SR2011A Refund Interest153,081-20,081.3676,948.25- 101-555635GO SR2012 Principal295,000--295,000.00- 101-555635.1GO SR2012 Interest233,784--120,579.38- TOTAL Debt Service5,159,586 2,036,516.893,074,924.523,890,041.02- 1,269,544.48 Other Financing Sources 101-556300Payment to Refund Debt----- TOTAL Other Financing Sources----- TOTAL EXPENDITURES5,201,9362,036,5173,111,1353,890,591- 1,311,344.48 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 6,921.58 Cash in Investments MBIA Investment- Tax I&S1,403,065.89 Federated Investment-Tax I&S56.94 Total Cash in Bank & Investments$1,410,044.41 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 ***************************************************** 2 0 1 2 - 2 0 1 3 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARCURRENTY-T-DBUDGET FINANCIAL SUMMARYBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE REVENUE SUMMARY Taxes2,820,260185,321.39963,284.531,164,235.37-1,656,024.63 Fund Transfers----- Miscellaneous17,450369.672,123.813,048.62-14,401.38 TOTAL REVENUES2,837,710185,691.06965,408.341,167,283.99-1,670,426.01 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies--12,447.00-- Utility Service--28,912.32-- Maintenance Services--26,488.69-- TOTAL NONDEPARTMENTAL--67,848.01-- ECONOMIC DEVELOPMENT Personnel Services294,59322,382.8579,488.91101,104.25-193,488.75 Supplies2,2006.97267.92103.6786.182,010.15 Human Services200---- City Support Services16,500182.217,698.291,451.3433.0915,015.57 Utility Services5,950108.05590.91444.15-5,505.85 Operations Support166,100798.1160,038.2656,465.542,996.62106,637.84 Staff Support20,25092.0010,796.713,666.55519.5816,063.87 City Assistance1,025,000-10,000.00587.95-1,024,412.05 Professional Services97,50032,889.5060,126.5086,402.77-11,097.23 Fund Charges/Transfers615,647364,553.9223,327.10446,744.60-168,902.40 Debt Service428,504-613,014.50275,526.75-152,977.25 Operating Equipment2,000219.97-334.24-1,665.76 TOTAL ECONO DEVELOPMENT2,674,444421,233.58865,349.10972,831.813,635.471,697,976.72 TOTAL EXPENDITURES2,674,444421,233.58933,197.11972,831.813,635.471,697,976.72 ** REVENUE OVER(UNDER) EXPEND163,266194,452.18 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: FEBRUARY 28th, 2013 *************************************************** 2 0 1 2 - 2 0 1 3 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARCURRENTY-T-D BUDGET REVENUESBUDGETPERIODY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCE Taxes 000-411500Sales Tax Revenue (4B)2,820,260185,321.39963,284.531,164,235.37-1,656,024.63 TOTAL Taxes2,820,260185,321.39963,284.531,164,235.37-1,656,024.63 Miscellaneous 000-491000Interest Earned200-85.6710.79- 000-491200Investment Earnings12,250369.673,274.213,037.83- 000-497000Misc Income5,000-(1,236.07)-- TOTAL Miscellaneous17,450369.672,123.813,048.62- TOTAL REVENUES2,837,710185,691.06965,408.341,167,283.99-1,670,426.01 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: FEBRUARY 28th, 2013 Cash in Bank Claim on Operating Cash Pool-Checking$ 188,546.02 Cash in Investments MBIA Investment-Economic Development Corp2,979,451.96 Schertz Bank & Trust-Certificate of Deposit1,038,541.60 Total Cash in Bank & Investments$ 4,206,539.58 4B SALES TAX $350,000 37% 24% $300,000 40% $250,000 2% 2% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJUL 2012-13 219,717287,520237,123212,096316,358 2011-12 214,497231,818169,596207,911230,700182,541173,698267,965199,040204,426 2010-11 171,042166,132173,802177,864235,199163,627141,650212,924204,332171,256 2009-10 150,192169,257140,629144,175238,531146,589136,939184,582175,160163,328 2008-09 166,298207,422185,879150,414217,323149,249141,205197,117158,648155,080 Ý × Ì Ç Ñ Ú Í Ý Ø Û Î Ì Æ ×ÒÊÛÍÌÓÛÒÌ ÎÛÐÑÎÌ ÚÑÎ ÓÑÒÌØ ÛÒÜ×ÒÙ ÚÛÞÎËßÎÇ îè¬¸ô îðïí ×ÒÊÛÍÌÓÛÒÌ ÐÑÑÔÍÐ¿®Þ»¹·²²·²¹Ü»°±·¬ñÛ²¼·²¹Û²¼·²¹ Ê¿´«»Þ±±µ Ê¿´«»Ç·»´¼Ð«®½¸¿»É·¬¸¼®¿©¿´Þ±±µ Ê¿´«»Óµ¬ Ê¿´«» ÑÐÛÎßÌ×ÑÒÍóÞßÒÕ ÝßÍØ Í½¸»®¬¦ Þ¿²µ ú Ì®«¬ ó Ð±±´»¼ Ý¿¸ ìôðìîôèçêòéê ëôêììôçíêòéîðòðëðð êôèèéôïèëòîê èôìèçôîîëòîî ìôðìîôèçêòéê ìôðìîôèçêòéê Í½¸»®¬¦ Þ¿²µ ú Ì®«¬ ó ÐÛÙ Ú«²¼ íçëôèçðòêî íèïôíêïòðêðòðððð ïìôëîçòëê ó íçëôèçðòêî íçëôèçðòêî ÌÑÌßÔ ÑÐÛÎßÌ×ÑÒÍ ìôìíèôéèéòíè êôðîêôîçéòéè êôçðïôéïìòèî èôìèçôîîëòîî ìôìíèôéèéòíè ìôìíèôéèéòíè ÔÑÙ×Ý Ù»²»®¿´ Ú«²¼ êôìêíôççïòèê ìôðêíôíêçòéïðòïëìí îôìððôêîîòïë ó êôìêíôççïòèê êôìêíôççïòèê ÙñÚóÛ¯«·°³»²¬ Î»°´¿½»³»²¬ éíôëîîòçî éíôëïìòîîðòïëìí èòéð ó éíôëîîòçî éíôëîîòçî ÙñÚóÊ»¸·½´» Î»°´¿½»³»²¬ ïðîôëéðòðï ïðîôëëéòèéðòïëìí ïîòïì ó ïðîôëéðòðï ïðîôëéðòðï ÙñÚóß·® Ý±²¼·¬·±²»® Î»°´¿½»³»²¬ ïìêôéçìòêé ïìêôéééòíïðòïëìí ïéòíê ó ïìêôéçìòêé ïìêôéçìòêé ÍÎîððç Þ±²¼óÍ¬®»»¬ Ð®±¶»½¬ø××÷ ïôêçîôîçèòéë ïôêçîôðçèòìððòïëìí îððòíë ó ïôêçîôîçèòéë ïôêçîôîçèòéë ÌÑÌßÔ ÔÑÙ×Ý èôìéçôïéèòîï êôðéèôíïéòëï îôìððôèêðòéð ó èôìéçôïéèòîï èôìéçôïéèòîï ÔÑÒÛÍÌßÎ Ý¿°·¬¿´ Î»½±ª»®§ ó Í»©»® ïôðçéôððîòìí èêêôçðëòèïðòïéðð îíðôðçêòêî ó ïôðçéôððîòìí ïôðçéôððîòìí Ý¿°·¬¿´ Î»½±ª»®§ ó É¿¬»® îôíèíôíîèòïç îôïïîôðíèòïððòïéðð îéïôîçðòðç ó îôíèíôíîèòïç îôíèíôíîèòïç Ü®¿·²¿¹» Ú«²¼ ìèìôîèïòìé ìèìôîïéòðïðòïéðð êìòìê ó ìèìôîèïòìé ìèìôîèïòìé ÙÑ ÍÎîðïï ß²·³¿´ Í¸»´¬»® îôðìëôçïïòèï îôðêëôïðèòêíðòïéðð îéìòïì ïçôìéðòçê îôðìëôçïïòèï îôðìëôçïïòèï ÙÑ ÍÎîðïï ß¬¸´»¬·½ Ú·»´¼ îôçèêôðïçòèê îôçèëôêîîòìððòïéðð íçéòìê ó îôçèêôðïçòèê îôçèêôðïçòèê ÙÑ ÍÎîðïï Í±½½»® Ú·»´¼ îôéëìôèìêòïè îôéêðôëðêòéçðòïéðð íêêòèë êôðîéòìê îôéëìôèìêòïè îôéëìôèìêòïè ÙÑ ÍÎîðïï Í©·³³·²¹ Ð±±´ êôïêìôçïðòèì êôîðëôìëçòêèðòïéðð èîìòëî ìïôíéíòíê êôïêìôçïðòèì êôïêìôçïðòèì ÙÑ ÍÎîðïî Ü±©²¬±©² ×³°®±ª»³»²¬ ïôðððôçìíòðð ïôðððôèðçòééðòïéðð ïííòîí ó ïôðððôçìíòðð ïôðððôçìíòðð ÉñÍóÝ«¬±³»® Ü»°±·¬ îçìôëçìòíè îçìôëëëòïéðòïéðð íçòîï ó îçìôëçìòíè îçìôëçìòíè ÉñÍóÛ¯«·°³»²¬ Î»°´ñÝ¿°ò×³° íéìôîìçòïð íéìôïççòîçðòïéðð ìçòèï ó íéìôîìçòïð íéìôîìçòïð É¿¬»®úÍ»©»® ïôïïçôîìîòìð îôðêçôððéòíððòïéðð îíëòïð çëðôðððòðð ïôïïçôîìîòìð ïôïïçôîìîòìð ÉñÍóÊ»¸·½´» Î»°´¿½»³»²¬ ëìëôêççòçë ëìëôêîéòíïðòïéðð éîòêì ó ëìëôêççòçë ëìëôêççòçë É¿¬»®ñÍÍÔÙ ó ÍßÉÍ ëíçôíïìòìé ëíçôîìîòêèðòïéðð éïòéç ó ëíçôíïìòìé ëíçôíïìòìé ÌÑÌßÔ ÔÑÒÛÍÌßÎ îïôéçðôíììòðè îîôíðíôîççòçì ëðíôçïëòçî ïôðïêôèéïòéè îïôéçðôíììòðè îïôéçðôíììòðè ÓÞ×ß Ì¿¨ ×úÍ ïôìðíôðêëòèç ïôèðîôèêéòìéðòïéðð ïçèòìî ìððôðððòðð ïôìðíôðêëòèç ïôìðíôðêëòèç Ð±´·½» Ú±®º»·¬«®» ííèôíèèòçè ííèôíìëòìêðòïéðð ìíòëî ó ííèôíèèòçè ííèôíèèòçè Û½±²±³·½ Ü»ª»´±°³»²¬ Ý±®°±®¿¬·±² îôçéçôìëïòçê îôêéçôðèîòîçðòïéðð íððôíêçòêé ó îôçéçôìëïòçê îôçéçôìëïòçê Ø±¬»´ Ì¿¨ îîðôíêëòîí îîðôííêòéèðòïéðð îèòìë ó îîðôíêëòîí îîðôíêëòîí Í°»½·¿´ Ûª»²¬ Ú«²¼ ìêôéîçòíì ìêôéîíòíéðòïéðð ëòçé ó ìêôéîçòíì ìêôéîçòíì ÛÓÍ Ì¿¨ Ò±¬» îðïð íðïôêëëòðð íðïôêïêòîíðòïéðð íèòéé ó íðïôêëëòðð íðïôêëëòðð ÌÑÌßÔ ÓÞ×ß ëôîèçôêëêòìð ëôíèèôçéïòêð íððôêèìòèð ìððôðððòðð ëôîèçôêëêòìð ëôîèçôêëêòìð ÚÛÜÛÎßÌÛÜ ÍÎîððé¿ Þ±²¼óÝ·¬§ É·¼» Ð®±¶»½¬ èêçôêçìòìì èêçôêííòïçðòðçðð êïòîë ó èêçôêçìòìì èêçôêçìòìì Ø±¬»´ Ñ½½«°¿²½§ Ì¿¨ éèôíðíòçè éèôîçèòìéðòðçðð ëòëï ó éèôíðíòçè éèôíðíòçè Ð¿®µ Ú«²¼ øÜ»ª»´±°»® Ú»»÷ ïêéôìçîòëð ïêéôìèðòéïðòðçðð ïïòéç ó ïêéôìçîòëð ïêéôìçîòëð Ð¿®µ Ú«²¼ øÌ®»» Ó·¬·¹¿¬·±²÷ çéôïèíòëç çéôïéêòéìðòðçðð êòèë ó çéôïèíòëç çéôïèíòëç Ì¿¨ ×úÍ ëêòçì ëêòçìðòðçðð ó ó ëêòçì ëêòçì Ô·¾®¿®§ Þ±¿®¼ Ú«²¼ ììôéèîòíé ììôééçòîîðòðçðð íòïë ó ììôéèîòíé ììôéèîòíé ÌÑÌßÔ ÚÛÜÛÎßÌÛÜ ïôîëéôëïíòèî ïôîëéôìîëòîé èèòëë ó ïôîëéôëïíòèî ïôîëéôëïíòèî ×ÒÊÛÍÌÓÛÒÌ ÓßÒßÙÛÜ ßÝÝÑËÒÌ Ý¿°·¬¿´ Ñ²» Ù»²»®¿´ Ú«²¼ ïôîèêôïêçòðð ïôíëïôéëîòçëîòèéðð íôëêíòìè îééòíë ïôíëëôðíçòðè ïôíìïôèïíòðê Ý¿°·¬¿´ Ñ²» Ý¿°·¬¿´ Î»½±ª»®§ Í»©»® ïôêìðôèïïòèç ïôéêîôîêïòêçîòèìðð ìôéîðòéç íëëòëç ïôéêêôêîêòèç ïôéïçôîèíòêë ÌÑÌßÔ ÝßÐ×ÌßÔ ÑÒÛ îôçîêôçèðòèç íôïïìôðïìòêì èôîèìòîé êíîòçì íôïîïôêêëòçé íôðêïôðçêòéï Ý·¬§ Ð±®¬º±´·± Þ§ ×²ª»¬³»²¬ Ì§°» ÌÑÌßÔ ÝßÐ×ÌßÔ ÑÒÛ ÌÑÌßÔ ÝòÜò êû ëû ÌÑÌßÔ ÑÐÛÎßÌ×ÑÒÍ ïðû ÌÑÌßÔ ÚÛÜÛÎßÌÛÜ íû ÌÑÌßÔ ÔÑÙ×Ý ÌÑÌßÔ ÓÞ×ß ïïû ÌÑÌßÔ ÔÑÒÛÍÌßÎ ìéû Ý·¬§ Ð±®¬º±´·± Þ§ Ë» Ü»·¹²¿¬»¼ Ú«²¼ô üïôçíðôëçéòéì Í°»½·¿´ Î»ª»²«» Ú«²¼ô üïðôêðíôêîíòëè Ü»¾¬ Í»®ª·½» Ú«²¼ô üïôìðíôïîîòèí Ð®±¶»½¬ô üïèôðëíôçíçòíë ÓÑÒÌØÔÇ Ç×ÛÔÜÍ íòëð íòðð îòëð îòðð ïòëð ïòðð ðòëð ðòðð ÑÝÌóïîÒÑÊóïîÜÛÝóïîÖßÒóïíÚÛÞóïíÓßÎóïíßÐÎóïíÓßÇóïíÖËÒóïíÖËÔóïí ï Ó±²¬¸ ÌóÞ·´´ ðòðçðððòïïðððòðîðððòðìðððòðéðð í Ó±²¬¸ ÌóÞ·´´ ðòïïðððòðèðððòðëðððòðéðððòïïðð ê Ó±²¬¸ ÌóÞ·´´ ðòïêðððòïíðððòïïðððòïîðððòïíðð Í½¸»®¬¦ Ð±®¬º±´·± ðòìíðððòíçëìðòìïîèðòíçðððòíéîé Í½¸»®¬¦ Þ¿²µúÌ®«¬ ðòðëðððòðëðððòðëðððòðëðððòðëðð ÝÜ íêë Ü¿§ ðòìððððòìððððòìððððòìððððòìððð ÝÜ ïèð Ü¿§ ðòíððððòíððððòíððððòíððððòíððð ÔÑÙ×Ýðòïçéïðòïèðìðòïéèëðòïëëíðòïëìí Ô±²»Í¬¿® ðòîíðððòîïðððòîïðððòïèðððòïéðð ÓÞ×ß ðòîïðððòïçðððòîïðððòïèðððòïéðð Ú»¼»®¿¬»¼ ðòïëðððòïíðððòïîðððòïððððòðçðð Ý¿°·¬¿´ Ñ²» îòèèððîòèéððîòèéððîòèêððîòèêðð Ý × Ì Ç Ñ Ú Í Ý Ø Û Î Ì Æ ×²ª»¬³»²¬ Î»°±®¬ Ý¿°·¬¿´ Ñ²» ß»¬ Ü¿¬»æîñîèñîðïí Ù»²»®¿´ Ú«²¼ ß»¬ Ý¿¸ ú Û¯«·ª¿´»²¬Ü«»Ó¿¬«®·¬§Í¸¿®»Ý±¬Ó®µ Ê¿´«» Ú·¼»´·¬§ Ð®·³» Ó³µ¬ Ð±®¬ Ú¼ ýêçðîêôïêçòððîêôïêçòððîêôïêçòðð Ì±¬¿´ Ý¿¸ ú Û¯«·ª¿´»²¬îêôïêçòððîêôïêçòððîêôïêçòðð Ú·¨»¼ ×²½±³» Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼èñïíñîðïìëíïòððïîëôðððòððïìïôçèéòíðïíìôêçèòéë Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼êñîïñîðïíïïíòððèðôðððòððèîôððìòìðèðôìíðòìð Ú»¼»®¿´ Ú¿®³ Ý® Þµ Ý±² Í§¬»³©·¼» Þ¼ïîñïêñîðïëïðîïòððïððôðððòððïïêôïèëòððïïîôîðêòðð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Ü»¾ïïñïëñîðïíîêðòððïéðôðððòððïçïôðèìòîëïéëôéðëòîð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß² Ó»¼«·³ ¬»®³ Ò¬çñîìñîðïíîðèòððîëðôðððòððîëðôðððòððîëëôçîîòëð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Î»º»®»²½» Ò¬ïïñîëñîðïìêíëòððîððôðððòððîððôêðçòìðîðïôêçèòðð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß² éñîèñîðïëèèðòððïîëôðððòððïíîôèîèòêíïíïôðíîòëð ËÍ Ì®»¿«®§ Ò±¬»ïïñíðñîðïëïððëòððêðôðððòððêïôçíêòéîêïôéîðòèð ËÍ Ì®»¿«®§ Ò±¬»ëñíïñîðïêïïèèòððëðôðððòððëîôìéêòëêëîôïèðòðð ËÍ Ì®»¿«®§ Ò±¬»îñîèñîðïìíêëòððïððôðððòððççôéëéòèîïððôðçðòðð Ì±¬¿´ Ú·¨»¼ ×²½±³»ïôîêðôðððòððïôíîèôèéðòðèïôíðëôêèìòïë Ì±¬¿´ ß»¬ëîìòïëïôîèêôïêçòððïôíëëôðíçòðèïôííïôèëíòïë Ý¿° Î»½±ª»®§ Ú«²¼ ß»¬ Ý¿¸ ú Û¯«·ª¿´»²¬Ü«»Ó¿¬«®·¬§Í¸¿®»Ý±¬Ó®µ Ê¿´«» Ú·¼»´·¬§ Ð®·³» Ó³µ¬ Ð±®¬ Ú¼ ýêçðëðôèïïòèçëðôèïïòèçëðôèïïòèç Ì±¬¿´ Ý¿¸ ú Û¯«·ª¿´»²¬ëðôèïïòèçëðôèïïòèçëðôèïïòèç Ú·¨»¼ ×²½±³» Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼èñïíñîðïìëíïòððïêëôðððòððïèéôìîíòîìïééôèðîòíë Ú»¼»®¿´ Ø±³» Ô±¿² Þµ Ý±² Þ¼êñîïñîðïíïïíòððïððôðððòððïðîôëðëòëðïððôëíèòðð Ú»¼»®¿´ Ú¿®³ Ý® Þµ Ý±² Í§¬»³©·¼» Þ¼ïîñïêñîðïëïðîïòððîððôðððòððîíðôééçòððîîìôìïîòðð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Ü»¾ïïñïëñîðïíîêðòððîëðôðððòððîèïôððêòîëîëèôíçðòðð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß² Ò¬ïðñïëñîðïíîîçòððîððôðððòððîîíôððïòêðîðëôëììòðð Ú»¼»®¿´ Ø±³» Ô² Ó¬¹ Ý±®° Î»º»®»²½» Ò¬ïïñîëñîðïìêíëòððîîðôðððòððîîðôðéèòêèîîïôèêéòèð Ú»¼»®¿´ Ò¿¬´ Ó¬¹ ß²éñîèñîðïëèèðòððïíëôðððòððïìíôìëìòçïïìïôëïëòïð ËÍ Ì®»¿«®§ Ò±¬»ïïñíðñîðïëïððëòððëðôðððòððëïôêðçòëéëïôìíìòðð ËÍ Ì®»¿«®§ Ò±¬»ëñíïñîðïêïïèèòððïîëôðððòððïíïôïçïòìïïíðôìëðòðð ËÍ Ì®»¿«®§ Ò±¬»îñîèñîðïìíêëòððïìëôðððòððïììôéêìòèìïìëôïíðòëð Ì±¬¿´ Ú·¨»¼ ×²½±³»ïôëçðôðððòððïôéïëôèïëòððïôêëéôðèíòéë Ì±¬¿´ ß»¬ëêìòëçïôêìðôèïïòèçïôéêêôêîêòèçïôéðéôèçëòêì