The URL can be used to link to this page

ORD 1021 09/11/2012 0F \ * £ X. PS "City of Choice" ORDINANCE NO. 10 21 AN ORDINANCE BY THE CITY COUNCIL OF THE CITY OF CIBOLO, GUADALUPE COUNTY, TEXAS, ADOPTING THE BUDGET FOR FISCAL YEAR 2012-13, BEGINNING OCTOBER 1, 2012, AND ENDING SEPTEMBER 30, 2013 AND REVISING THE BUDGET FOR THE PRECEDING FISCAL YEAR ENDING SEPTEMBER 30,2012. WHEREAS, in accordance with the City Charter, it is necessary to adopt a budget for the Fiscal Year 2012-13; and WHEREAS, a Proposed Budget for the period commencing October 1, 2012 and ending September 30, 2013 has been prepared by the City Manager in accordance with Article VII of the City Charter, and the City Council has considered the City Manager's Proposed Budget; and WHERAS, the Proposed Budget will raise more total property taxes than last year's budget by $600,886 (11.8%) and of that amount $658,115 is tax revenue to be raised from new property added to the tax roll this year. WHEREAS, a public hearing on the Proposed Budget was held on September 11, 2012 after due and proper notice of said hearing having been given in accordance with the City Charter, NOW THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CIBOLO,TEXAS: SECTION 1. The Proposed Budget herein presented and attached to this Ordinance for all funds for the fiscal year commencing October 1,2012 and ending September 20, 2013, is hereby approved and adopted. SECTION 2. The"Revised"budget herein presented and attached to this Ordinance for all funds for the fiscal year ending on September 30, 2012 is hereby revised. SECTION 3. The City Manager is hereby authorized to contract for expenditures without further approval of the City Council for all budgeted items not exceeding the limits set by the City Council. SECTION 4. This Ordinance shall take effect and shall be in full force at 12:00 a.m. on October 1, 2012. PASSED AND APPROVED AND ADOPTED THIS 11TH DAY OF SEPTEMBER, 2012. APPROVED: 11 ►�,� yor J 'ferartman ATTEST: Peggy Cimics, City Secretary ti • !, • 4r o fa C I -4 0 ,,,,,,,,,,,A.,, A �� ''�� O -,.., < ... .... .. C .. � O .... * . ,,_ .. _ .. .. .. .. _ Alt . _, * 1"'' k N ... ... ,.... ,0 -..,, . ..lot c ..„„„,..._7* S "City of Choice" 2012-2013 PROPOSED BUDGET This budget will raise more total property taxes than last year's budget by $600,886 (11.8%) and of that amount $658,115 is tax revenue to be raised from new property added to the tax roll this year. o ' •cry A ow r% 0 =z, ,.� . •aiinnnixnNi• n��+,� "City of Choice" Proposed 2012 and 2013 Budget City of Cibolo,Texas Executive Summary City Manager's Office August 1,2012 The proposed budget for 2012/2013 is attached for your review.. In preparing this year's proposed budget city staff was mindful of the obligation we have as public servants to be responsible stewards of the community and its resources. Additionally, we understand the importance of being prudent in the allocation of public funds. One of our primary goals is to continue to maintain, enhance and preserve the quality of life we currently enjoy in Cibolo,Texas. The city has experienced rapid growth in its population and the city has increased its city limits over the last several years. As a result of annexation, the city has placed itself in a better position to protect itself from the encroachment of other cities adjacent to Cibolo and improved its ability to manage future development. According to our city engineer, in 2009 the amount of square miles within our city was 12.56 square miles. In 2012, the amount of square miles within our city limits is approximately 27.02 square miles. Therefore; in the last three years we more than doubled our city limits (increase by 14.46 square miles). This increase in land size equals to a 115% increase growth factor. The city's population has also grown substantially. In 2009 our city population, according to the annual auditor's report was 18,050. By April 2013, staff believes our population will grow to approximately 25.,300 and we project growth will continue at a 3 percent to a 3.5 percent rate of growth annually. The city's population over a three year period reflects a 40 percent population increase. With growth come opportunities and challenges.The City of Cibolo staff continues to remain focused on meeting the current needs of the community while keeping one eye looking towards the future. The following administrative goals, strategies, and financial policies were considered by our management team in building the proposed budget. 1. Provide sufficient funding to meet current operational and staffing levels. 2. Begin addressing the addition of public safety personnel to help improve the city's service levels within annexed areas of the city. 1 3. Address and work towards the completion of currently approved and funded capital improvement projects. 4. Set aside funding for the continued development and training of our workforce. 5. Implement an organizational pay plan for all full time city employees to maintain salaries at a competitive level within our market region. 6. Develop a business plan to address the financing of long term potable water needs of the community. 7. Continue to keep the city's park system and the city's maintained right of way corridors appealing while seeking opportunities to enjoin the city's walking and jogging corridor system. The city continues to enjoy one of the lowest property tax rates in our immediate region. The following tax chart compares the City of Cibolo tax rate to its neighbors as of July 2012. I am pleased to report that the proposed general fund budget is built without a tax rate increase. 0__ 0 w _0 0_^ a, _ rn 0.600000 u, v �, o cr. 0.500000 0 0 O m al i 0.400000 �^, l l 0.300000111 / / / 1 0.200000 . . 0.100000 ■ ■ \Na opo ��y • ``oc oat ��ti J�� e's" ``wJ o�� o�G0 `aJ� c.,' ,,,> �\,esyr �� o�� a� `•kaJ 0''6 2 Combined Operating Accounts The combined operating budgets when compared to the prior year reflect a 14.4% increase in proposed combined expenditures. 4.4% of the proposed increase is set aside to address land acquisition associated with drainage improvements. Budget comparison of the four major operating funds Fund type Current Year Proposed $ Difference General fund $ 7,235,933 $ 8,461,722 $ 1,225,789 Utility fund $ 7,859,431 $ 8,689,059 $ 829,628 Drainage Utility District $ 323,967 $ 399,867 $ 75,900 $15,419,331 $17,550,648 $ 2,131,317 Economic Development fund $ 190,954 $ 303,967 $ 113,013 Total Combined Operating Funds $15,610,285 $17,854,615 $ 2,244,330 Proposed Budget by Operating Fund General fund 47.4% Economic development Drainage utility fund district 1.7% 2.2% Of that 14.4% increase: • $1,053,724, or 6.8%are one-time capital and related land acquisition costs; • $525,000, or 3.4%is related to new debt service in the utility fund; • $453,298, or 2.9%, is related to the funding of six employees in public safety; • $225,000, or 1.4% is related to an expected 9.6% increase passed on from one of our water suppliers;and • $124,338 or 0.8% is related to implementation of an employee pay plan and general cost of living increases • ($375,000) or (2.4%) is a decrease related to the prior year funding of Cibolo Valley Local Government Corporation. While issuance of debt will likely occur in fiscal year 2013, the first debt payment is projected in fiscal year 2014. • All other increases total approximately 1.5%. 3 General Fund The general fund accounts for primary operations of the City including administration, public safety, and street and park maintenance. General Fund Revenue Highlights Major revenue sources of the general fund include property and sales taxes,franchise fees and permits. A summary of all general fund revenue sources for fiscal year 2012-2013 as compared to fiscal year 2011-2012 is as follows: Revenue Category Current Year Proposed $ Difference %change General and Franchise Taxes $ 4,475,800 $ 5,109,200 $ 633,400 14.2% Permits and Fees $ 1,439,200 $ 1,633,500 $ 194,300 13.5% Animal control $ 12,300 $ 20,800 $ 8,500 69.1% Court and Alarm Permits $ 230,900 $ 335,600 $ 104,700 45.3%* Interest and Miscellaneous $ 47,100 $ 13,213 ($ 33,887) (71.9%) Parks and Grants $ 100,500 $ 25,500 ($ 75,000) (74.6%) Intergovernmental and Transfers $ 762,752 $ 701,719 ($ 61,033) ( 8.0%) Total revenues $ 7,068,552 $ 7,839,532 $ 770,980 10.9% *proposed impact from funding a traffic control officer General Fund Proposed Revenues Animal control - - 0.3% Permits and Fees Court and Alarm 20.8% Permits General and4.3% Franchise Taxes Intergovernit m t 65.2% and Transfers Interest and 9.0% Miscellaneous 0.2% Parks and Grants 0.3% 4 The overall increase in general and franchise taxes is comprised of the following: Revenue Category Current Year Proposed $ Difference %change Property taxes $ 3,270,000 $ 3,759,300 $ 489,300 15.0% Sales taxes $ 536,800 $ 656,100 $ 119,300 22.2% Franchise fees $ 669,000 $ 693,800 $ 24,800 3.7% Total taxes and franchise fees $ 4,475,800 $ 5,109,200 $ 633,400 14.2% The anticipated increase in property taxes is a result of new property added to the tax appraisal rolls for 2012 and not from a tax rate increase. Certified values show an increase of approximately$150 million in new property; approximately 50%of the increase is related to real property and new annexations and 50% of the increase is related to personal commercial property. Additionally, we are projecting a sales tax increase of approximately 22% over the current year original sales tax projections. Our current year's revenue for the last several months has averaged 21.7% over last year's monthly allocations for the same time period and we are projecting to end the year at approximately 16.5% over our original fiscal year 2012 projections. For fiscal year 2013, we are projecting a moderate increase of 5%over the current year. We have also seen an increase in permit activity in the current year, new home permits are proposed to be slightly over 300, which is a 10% increase over the prior year figure of 272 building permits. We project the building activity to continue and have budgeted a 5%increase for fiscal year 2013. Court and alarm permits are up approximately 10% this year from what was originally budgeted. We have budgeted an increase in this area due to the proposed addition of a traffic officer within the police department. Decreases in interest and grants revenue is a reflection of the current economy. Revenues from interfund transfers remain relatively constant, with the difference coming from a decrease in transfers from street and maintenance funds. 5 General Fund Expenditure Highlights A summary of expenditures by department for fiscal year 2012-2013 as compared to fiscal year 2011- 2012 is as follows: Department Current Year Proposed $ Difference %change City Council $ 8,900 $ 7,550 ($ 1,350) ( 15.2%) City Administration $ 663,575 $ 655,919 ($ 7,656) ( 1.2%) Police $ 2,003,379 $ 2,468,999 $ 465,620 23.2% Police ISD Program $ 139,631 $ 145,282 $ 5,651 4.0% Municipal Court $ 138,767 $ 146,115 $ 7,348 5.3% Community Development $ 731,707 $ 786,875 $ 55,168 7.5% Public Works $ 878,599 $ 889,346 $ 10,747 1.2% Animal Control $ 110,755 $ 127,322 $ 16,567 15.0% Parks $ 430,986 $ 444,806 $ 13,820 3.2% Economic Development $ 124,675 $ -0- ($ 124,675) (100.0%) Finance $ 283,295 $ 287,806 $ 4,511 1.6% Information Technology $ -0- $ 119,632 $ 119,632 Fire $ 1,218,081 $ 1,432,524 $ 214,443 17.6% Non-Departmental $ 401,083 $ 218,980 ($ 182,103) ( 45.4%) Grant expenditures $ 102,500 $ -0- ($ 102,500) (100.0%) Land acquisition costs/Drainage $ -0- $ 380,000 $ 380,000 Old school building renovation $ -0- $ 125,000 $ 125,000 Employee cost of living adjustment $ -0- $ 54,953 $ 54,953 Employee pay plan implementation $ -0- $ 46,772 $ 46,772 Interfund Transfers $ -0- $ 123,841 $ 123,841 Total Expenditures $ 7,235,933 $ 8,461,722 $1,225,789 16.9% General Fund Proposed Expenditures Municipal Court Police-15D Program 1.7% 1.7% Community Development Public Works Police 9.3%ae 10.5% Animal Control 1.590 m 29.2% Parks ormation Technology 1.4% City Administration Fire 7.8% 16.9% Larnd acquisition costs 4.5% City Council 0.1% InterfundTransfers� I 1.5% Employee Pay- Non-Departmental Adjustments Renovate school building 2.6% 1.2% 1.5% 6 The primary reasons for significant increases in expenditures are to meet the growth of the organization and to start to phase-in public services for properties annexed into the city. • Police Department—To provide funding for replacement or upgrade of four police units,and Net Motion software and the addition of three police officers. • Animal Control —To provide funding for a full time animal control officer from a part time position. • Fire Department—To provide funding for the addition of three fire personnel. • Land acquisition Costs-To provide funding for anticipated land acquisition settlement costs associated with drainage improvements in the next budget cycle. If the expense were to occur prior to October 1St,we will see a reduction in our general fund reserves by this same amount to fund the obligation currently. • Old school building renovation — To provide funding to renovate the old school building transferred from SCUCISD to accommodate community development staff. • Employee Pay Plan—To provide funding for a pay plan for all full-time employees. The City does not currently have a pay plan in place for its workforce of approximately 100 employees. This proposed pay plan would allow for an employee to be eligible to receive a 2.5% increase in salary annually on their anniversary date of hire. The plan does not guarantee an increase for the employee since the proposed plan will be performance-based. For example, an employee whose performance is below average will not receive a pay increase, whereas, an employee who is rated at a higher level may receive a salary increase from 1%to 2.5%depending on their performance level. • Interfund transfers—To relocate the general fund portion of the revenues and expenses for the economic development department of the city to be part of the Economic Development Fund. In doing this,the Economic Development Fund will perform as a separate and distinct cost center, thereby allowing staff to easily identify all revenues and expenses for the activity without having to look in two or more locations. 7 Utility Fund and Drainage Utility Fund The Utility fund and the drainage utility fund account for the revenues and expenses related to the acquisition and distribution of water resources, collection and disposal of wastewater and refuse, and maintenance of drainage ways of the City. The proposed utility fund and the city's drainage fund budgets reflect increases in revenues and proposed expenses. The following chart shows the revenue distribution for the combined utility funds: Revenue Category Current Year Proposed $ Difference %change Water Services $ 3,428,400 $ 3,699,100 $ 270,700 7.9% Wastewater Services $ 1,892,900 $ 2,139,900 $ 247,000 13.0% Garbage and recycling services $ 1,595,000 $ 1,600,900 $ 5,900 0.4% Other fees $ 503,600 $ 461,000 ($ 42,600) ( 8.5%) Interest and miscellaneous $ 42,500 $ 38,700 ($ 3,800) ( 8.9%) Total utility fund $ 7,462,400 $ 7,939,600 $ 477,200 6.4% Drainage services $ 380,178 $ 408,000 $ 27,822 7.3% Interest and miscellaneous $ -0- $ 80 $ 80 Total drainage utility district $ 380,178 $ 408,080 $ 27,902 7.3% Combined Utility Fund Proposed Revenues Other fees Wastewater Garbage and 5.5% services recycling 25.6% °•=° Interest and Miscellaneous Drainage fees -water 4.9% 0.5% Interest and Water services Miscellaneous- 44.3% drainage 0.0% 8 Utility Fund Revenue Highlights The Utility fund revenues are projected to increase by 6.5%. This increase is attributed to growth and raising water and sewer utility rates to pay for the increased cost to purchase treated potable water,the treatment of waste water effluent, to secure a long term supply of drinking water, and expand our capital infrastructure. Of these items, the need to secure future water is the most costly and, one could argue,the most needed. Staff is projecting a 3% increase in revenues associated with new growth and residential usage and a 4% increase due to the planned increase in water and wastewater rates. In preparing this year's utility fund budget, staff took into consideration the recommendations as proposed within the most recent water rate study. The water rate study which was adopted by the City Council in 2011 calls for a planned increase in rates to generate a 4% revenue increase. The planned increase is due to a planned bond issuance for capital improvement and expansion through the creation of Cibolo Valley Local Government Corporation and to improve the City's water distribution system along Interstate Highway 35 and to begin to address improving water distribution into properties south of the city to Interstate Highway 10. Utility Fund Expenditure Highlights The Utility fund proposed expenditures for the following budget years are designed to meet our current level of service and to address our most significant issues. The most significant additional cost of the utility fund is the increase in debt service payments to improve and expand our current utility infrastructure. The projects being considered have the potential to make a significant impact to our growing City. By expanding our water infrastructure to undeveloped but marketable areas, our City becomes more appealing to business looking to develop or relocate in our area. With new business development comes an additional financial resource to further improve our City. Secondly, our current water provider, Canyon Regional Water Authority, is projecting a 9.6% increase in their rates effective in the next budget cycle which affects our expenditures significantly. Additionally, the City anticipates one-time land acquisition costs that make up approximately 3.3% of the total operating budget which will draw down its operating reserves. Lastly, although the current year will not require much additional funding for our participation in the Cibolo Valley Local Government Corporation (CVLGC), a significant cost to consider in the short-term future of Cibolo is the cost of securing long term water resources. The CVLGC is an intergovernmental corporation created to fund the acquisition and transmission of additional water resources to the participating cities of Cibolo,Schertz,Selma, Converse and Seguin,Texas. In order to proceed to the next level of commitment with the CVLGC, cities participating will be required to contract for the construction of water wells and the construction of a distribution transmission line to service its clients. The estimated cost for this commitment will be between $32 million dollars to $50 9 million dollars in new revenue debt or through a contractual obligation. Future budgets will bear our share of the cost of the debt obligation and our participation in the operations. The following chart shows the expenditures for the utility fund: Expenditure Category Current Year Proposed $ Difference % change Utility Administration $ 6,049,860 $ 6,066,789 $ 16,929 0.3% Debt Service $ 494,374 $ 1,031,781 $ 537,407 108.7% Utility Operations $ 998,849 $ 959,903 ($ 38,946) ( 3.9%) Land acquisition costs/Drainage $ -0- $ 300,000 $ 300,000 Employee cost of living adjustment $ -0- $ 8,073 $ 8,073 Employee pay plan implementation $ -0- $ 5,739 $ 5,739 Interfund Transfers $ 316,348 $ 316,774 $ 426 0.1% Total Utilities Administration $ 7,859,431 $ 8,689,059 $ 829,628 10.6% Utility Fund Proposed Expenditures Utility Debt Service Administration 11.9% 69.8% Utility Operations 11.0% Land acquisition Costs 3.5% Employee pay adjustments Interfund transfers 0.2% 3.6% 10 Economic Development Fund In order to show all economic development activities together in a separate and distinct cost center, staff relocated the general fund portion of the revenues and expenses for the economic development department of the city to be part of the Economic Development Fund. Doing so allows staff to easily identify all revenues and expenses for the economic development division without having to look in two or more locations. Economic Development Fund Revenue Highlights Sales taxes make up more than half of the funding source for economic development activities. We are projecting a slight increase in sales taxes as a result of the population growth in the City and the improving economy. The other 43%of total revenues in the fund is a transfer from the general fund. In moving all costs into the economic development fund,the City will recognize a transfer from the general fund for the portion of costs, including salaries and benefits, which have historically been funded from the general fund. Economic Development Fund Expenditure Highlights Although the percentage change from fiscal year 2012 to fiscal year 2013 looks significant, there is very little difference besides the shift to one cost center. Capital Programs The projects which are listed below outline this year's capital outlay program within operating funds: Description Department Justification/Replacement Projected cost General fund: 2012 Chevrolet Tahoe Police 2000 Ford Explorer 33,421.00 2012 Chevrolet Tahoe Police 2006 Crown Vic 40,716.00 2012 Chevrolet Tahoe Police 2006 Crown Vic 40,716.00 upgrade unit to covert traffic unit Police upgrade 16,740.00 Net Motion software Police Mandate 30,000.00 Improvement to school building Comm Dev Shortage of space 125,000.00 2012 Chevrolet Colorado Comm Dev 2003 PT Cruiser 17,381.00 (2) 2012 Full Size Trucks 50%funded Streets PW Director/Crew truck 26,000.00 VOIP Phone system for city hall IT Efficiency 17,750.00 Land acquisition costs NonDept Settlement 380,000.00 727,724.00 Utility funds: 2012 Full Size Truck 50%funded Utilities PW Director 13,000.00 2012 Full Size Truck 50%funded Drainage Crew truck 13,000.00 Land acquisition costs NonDept Settlement 300,000.00 326,000.00 11 Impact Fees In the development process, the City imposes impact fees to recover costs related to the impact of new development on existing infrastructure. Those impact fees are calculated based on a professional engineering study contracted by the City and updated as often as deemed necessary. Categories of impact fees and the related revenues are as follows: Impact Fee category Current Year Proposed $ Difference %change Water Impact Fees $ 400,000 $ 483,000 $ 83,000 20.8% Wastewater Impact Fees $ 180,000 $ 262,500 $ 82,500 45.8% Traffic Impact Fees $ 150,000 $ 252,000 $ 102,000 68.0% Drainage Impact Fees $ 150,000 $ 131,250 ($ 18,750) ( 12.5%) Park Land Fees $ 120,000 $ 90,000 ($ 30,000) ( 25.0%) Total fees $ 1,000,000 $ 1,218,750 $ 218,750 21.9% Impact Fee Proposed Revenue Breakdown Park Land Fees Drainage Impact 7.4% Fees 10.8% • Water Imps' Fep Traffic Impact 39.6 Fees 20.7% Wastewater Impact Fees 21.5% Projects that are expected to be completed in the current fiscal year or anticipated for funding for the coming fiscal year include: • Water line extension from Weidner to Green Valley Road; • Water line extension on Main and Schaeffer Road; • Wastewater line extension and lift station along FM1103; • Funding for the city share of the upsized wastewater line for Turning Stone development; • Traffic signals at Cibolo Valley Drive and Borgfeld Road; • Funding for city share of the drainage channel improvements for Turning Stone development; • Funding for city matching funds for Schlather Park; and • Updating our impact fee study. 12 In addition, a committee of interested community members and stakeholders has been appointed to work with City Council and staff to identify and prioritize additional city-wide capital improvement projects. This planning exercise which was undertaken by appointed citizens within the following four committees: Planning and Zoning Commission, Economic Development Board, Streets and Drainage Commission and the Parks Commission. These individuals spent many hours and evenings of their personal time working with our staff to identify a recommended Capital Improvement Plan to be considered and reviewed over a five-year period. The list of the recommended, prioritized capital improvements as proposed by the Committee is attached to this budget for Council consideration, possible modification, and future adoption. This plan, once adopted by City Council, will become the planning guide the City Council will consider when addressing community wide capital improvement projects on an annual basis. Consideration for future funding of this CIP plan should be kept in mind as well. The proposed budget as presented is designed to meet the current operational needs of the organization, to anticipate additional growth within the southern portion of the city and to start increasing the presence of city services within annexed areas. We look forward to:working with Council in the next several weeks to finalize and adopt a fiscal year 2012-2013 budget that will continue to move the City forward. Respectfully Zoe r. }f erreYa. Awvuv Ma rqu.erk City Manager Finance Director 13 8/1/2012 CITY OF CIBOLO,TEXAS EXHIBIT A BUDGET SUMMARY GENERAL FUND 2010-2011 ORIGINAL REVISED %CHANGE PROPOSED $CHANGE %CHANGE ACTUAL BUDGET BUDGET FROM ORIGINAL BUDGET FROM ORIGINAL FROM ORIGINAL BEGINNING FUND BALANCE 4,050,956 3,519,621 3,519,621 3,807,047 REVENUES: GENERAL AND FRANCHISE TAXES 4,250,154 4,475,800 4,607,763 2.9% 5,109,200 633,400 14.2% PERMITS AND FEES 1,452,530 1,439,200 1,555,779 8.1% 1,633,500 194,300 13.5% ANIMAL CONTROL 14,378 12,300 20,849 69.5% 20,800 8,500 69.1% COURT AND ALARM PERMITS 222,614 230,900 252,432 9.3% 335,600 104,700 45.3% INTEREST AND MISCELLANEOUS 45,993 47,100 60,464 28.4% 13,213 (33,887) -71.9% PARKS AND GRANTS 117,598 100,500 102,377 1.9% 25,500 (75,000) -74.6% INTERGOVERNMENTALANDTRANSFERS 351,907 762,752 700,354 -8.2% 701,719 (61,033) -8.0% SUBTOTAL REVENUES 6,455,173 7,068,552 7,300,018 3.3% 7,839,532 770,980 10.9% TOTAL AVAILABLE 10,506,129 10,588,173 10,819,639 11,646,579 EXPENDITURES: CITY COUNCIL 6,007 8,900 5,668 -36.3% 7,550 (1,350) -15.2% CITY ADMINISTRATION 824,330 663,575 675,346 1.8% 655,919 (7,656) -1.2% POLICE 1,873,242 2,003,379 1,998,654 -0.2% 2,468,999 465,620 23.2% POLICE-ISD PROGRAM - 139,631 135,631 -2.9% 145,282 5,651 4.0% MUNICIPAL COURT 125,289 138,767 140,855 1.5% 146,115 7,348 5.3% COMMUNITY DEVELOPMENT 629,500 731,707 689,650 -5.7% 786,875 55,168 7.5% PUBLIC WORKS 752,980 878,599 806,991 -8.2% 889,346 10,747 1.2% ANIMAL CONTROL 87,558 110,755 111,110 0.3% 127,322 16,567 15.0% PARKS 456,935 430,986 383,983 -10.9% 444,806 13,820 3.2% ECONOMIC DEVELOPMENT 98,667 124,675 114,983 -7.8% - (124,675) -100.0% FINANCE 288,740 283,295 283,107 -0.1% 287,806 4,511 1.6% INFORMATION TECHNOLOGY - - - 119,632 119,632 FIRE 1,521,176 1,218,081 1,180,995 -3.0% 1,432,524 214,443 17.6% NON-DEPARTMENTAL 187,921 401,083 359,698 -10.3% 218,980 (182,103) -45.4% GRANT EXPENDITURES 9,383 102,500 90,920 -11.3% - (102,500) -100.0% SUBTOTAL EXPENDITURES 6,861,729 7,235,933 6,977,592 -3.6% 7,731,156 495,223 6.8% OTHER FINANCING USES 242,916 - 35,000 123,841 123,841 ADDITIONAL LAND ACQUISITION COSTS 380,000 OLD SCHOOL BUILDING RENOVATION 125,000 EMPLOYEE COST OF LIVING ADJUSTMENT 42,818 EMPLOYEE PAY PLAN 58,907 242,916 - 35,000 730,566 CHANGE IN RESERVED FUND BALANCE 118,137 - - - ENDING FUND BALANCE 3,519,621 3,352,240 3,807,047 3,184,857 Fund Balance as a%of expenditures 49.5% 46.3% 54.3% 37.6% 15 8/1/2012 CITY OF CIBOLO,TEXAS EXHIBIT B BUDGET SUMMARY UTILITY FUND 2010-2011 CURRENT REVISED %CHANGE PROPOSED $CHANGE %CHANGE ACTUAL BUDGET BUDGET FROM ORIGINAL BUDGET FROM ORIGINAL FROM ORIGINAL BEGINNING FUND BALANCE 2,572,294 3,362,884 3,362,884 3,548,254 REVENUES: UTILITY SERVICES 7,538,483 7,419,900 7,462,882 0.6% 7,900,900 481,000 6.5% INTEREST,TRANSFERS,MISCELLANEOUS 1,233,399 42,500 42,668 0.4% 38,700 (3,800) -8.9% SUBTOTAL REVENUES 8,771,883 7,462,400 7,505,550 0.6% 7,939,600 477,200 6.4% TOTAL AVAILABLE 11,344,177 10,825,284 10,868,434 11,487,854 EXPENDITURES: UTILITIES ADMINISTRATION 5,512,964 6,049,860 5,719,675 -5.5% 6,066,789 16,929 0.3% UTILITIES OPERATIONS 906,393 998,849 799,490 -20.0% 959,903 (38,946) -3.9% DEBT SERVICE 223,115 494,374 494,374 0.0% 1,031,781 537,407 108.7% SUBTOTAL EXPENDITURES 6,642,472 7,543,083 7,013,539 -7.0% 8,058,473 515,390 6.8% OTHER FINANCING USES 193,687 316,348 306,642 -3.1% 316,774 426 0.1% ADDITIONAL LAND ACQUISITION COSTS 300,000 EMPLOYEE COST OF LIVING ADJUSTMENT 8,073 EMPLOYEE PAY PLAN 5,739 193,687 316,348 306,642 630,586 CHANGE IN INVESTED IN CAPITAL ASSETS (1,145,134) - - - ENDING FUND BALANCE 3,362,884 2,965,853 3,548,254 2,798,795 FB as a%of expenditures 49.2% 37.7% 48.5% 32.2% 17 7/18/2012 CITY OF CIBOLO,TEXAS EXHIBIT C BUDGET SUMMARY DRAINAGE UTILITY DISTRICT 2010-2011 ORIGINAL REVISED %CHANGE REQUESTED $CHANGE %CHANGE ACTUAL BUDGET BUDGET FROM ORIGINAL BUDGET FROM ORIGINAL FROM ORIGINAL BEGINNING FUND BALANCE - 144,909 144,909 218,603 REVENUES: DRAINAGE SERVICES 265,913 380,178 397,580 4.6% 408,000 27,822 7.3% INTEREST,TRANSFERS,MISCELLANEOUS 1,507,905 - 81 80 80 SUBTOTAL REVENUES 1,773,818 380,178 397,661 4.6% 408,080 27,902 7.3% TOTAL AVAILABLE 1,773,818 525,087 542,570 626,683 EXPENDITURES: DRAINAGE OPERATIONS 125,626 367,309 323,767 -11.9% 392,882 25,573 7.0% SUBTOTAL EXPENDITURES 125,626 367,309 323,767 -11.9% 392,882 25,573 7.0% OTHER FINANCING USES - - 200 1,586 1,586 EMPLOYEE COST OF LIVING ADJUSTMENT 2,924 EMPLOYEE PAY PLAN 2,475 - - 200 6,985 CHANGE IN INVESTED IN CAPITAL ASSETS (1,503,283) - - - ENDING FUND BALANCE 144,909 157,778 218,603 226,816 FB as a%of expenditures 115.3% 43.0% 67.5% 56.7% 19 IMPACT FEES FY 2011/2012 EXHIBIT 0 ;-!--,'-Water."Impact:'<' Wastewater ':Traffielmpact"; Drainage Impact l,:',?"-' 'n`.7-;„, purpose:.'::,..'' : . - Feesr";; Impact Fees Fees r;`=:' Fees ''Parkland Feel, Total Fund: .' Y'.22,- ,.. 24 .<<---..,,29/30,'::. 31 %.32.'%-``- Beginning balance 10/1/11 ;$;if;,. 990,704, $ 1,348,395 ?$_'S,,1..,▪,568,602 $ 629,743 ,5;'&.,)y _938,054' $ 4,475,498 Revenues-FY12 r. .lf". ..:'., Impact fees-projected :5:":;,-..,...-. 460,000 $ 250,000 $'•%r,';=240,000' $ 125,000 $= =`,j,-,90,004 $ 1,165,000 Interest .'$;i -650' $ 1,100 -$.: .e x625'. $ 600:$-r?:..,:;=---600 $ 3,575 Total Revenues .`$'�e:.;`460,650, $ 251,100,$,i ;;'-.',;:240,625, $ 125,600 :5;?,-',,, %90,600 $ 1,168,575 Total Available FY12 '$•,`- 1,451,354. $ 1,599,495 '$?'rE,..-%809,227. $ 755,343 ;0."`-";;`1;028,654 $ 5,644,073 Proposed Projects -''r`;'r;,...r'l-- --h+,,J'..a - - Y (570,162) Water line ext Weidner to Green Valley ,$;,�.,i`(570,462) ' .a;:-- - � $ Water line-Maln/Schaeffer Road a$,;'::, ,(90,900) y, = °' $ (90,000) Sewer line/lift station along FM1103 * $ (360,000); _- _ ,i �-',L4:a $ (360,000) Wastewater line upsizing-Turning Stone PIA _ ;, $ (195,000).;_?y.;-:, `"= $ (195,000) Traffic signals at CVD and Borgfeld-design - '$," ,x.(15,000) _ $ (15,000) Drainage Improvements-Turning Stone PIA ;: - • - $ (181,000)�, $ (181,000) Schlather Park Drainage , ;-}, a $ (24,000)i- t ,.• /^'Y":, $ (24,000) Schlather Park �:j i-- -;n;;`? _ - ;?',;l (7,42,000) $ (742,000) Transfer to General fund-Schlater Park grant match _- - - $---,(25,000) $ (25,000) Total projects ,$.'.•;:,'(660;16 " 2) $ (555,000) $�.a" '(15;000) $ (205,000)r$:5::::,-(767;000) $ (2,202,162) ,: � Projected ending fund balance 9/30/12 $'s;'-• 791;192 $ 1,044,495 c,$.S-, ?'794,227 $ 550,343 .$ r,.-•'.261;654 $ 3,441,911 IMPACT FEES FY 2012/2013 .,:Water Impact°- Wastewater Traffic Impact: Drainage Impact ;,;`d'":;.:Y" :;° pose Pur: .. Fees� Impact Fees Fees t(Park Land,Fe6s'1 Total e ��f¢es•..; -Fund:-. '22`-�`;;;:,' 24 :.:7-t:=-29/30:,..,e 31 .r32..r4c:;:, Beginning balance 10/1/12 $'-'„,'_:`,791,192; $ 1,044,495 $..;_'',,794,227. $ 550,343 :$-:,;LY, 5261,654 $ 3,441,911 4_ Revenues-FY13 `5 " -I.-' .,.'-' Impact fees(5%increase over PY) $,i' 483,000 $ 262,500" $-•',;' 252,000 $ 131,250 $"-..� '90;000 $ 1,218,750 Interest :5y: %715 $ 1,210'S-:"--',.:-7,-.5"'"',"688 $ 660 '5,.' "' 660 $ 3,933 Total Revenues :$;'el'i:-:483,715 5 263,710.,5 !252,688: $ 131,910 $,.".: ,,,..190,660 $ 1,222,683 Total Available FY13 ;$;t._.11;274,907 $ 1,308,205 $_- 4,046,915.. $ 682,253 -`5:,_`.`s". -352,314. $ 4,664,593 Proposed Projects '..r - .? ,',..,;'''.:.;-',`"'f'.. ' :s;.--C:,."7;= Impact fee study ;$;•�$ 421:290) 5 (21,250) 5=_'.-(21,2,5,0) $ (21,250)'5_, :,. .i„--: $ (85,000) Borgfeld Engineering/Surveying 5':'_,'(55,950)i 5= $ (55,950) (150,010) - � $ (150,000) Traffic signals at CVD and Borgfeld-design ,-, Green Valley Road Improvents-Turning Stone PIA _ ;Ss.;t'(500,000) :;,,,,:-,..,,s, $ (500,000) Park Improvements-Turning Stone PIA - - ?_. 5. - `(190,000) $ (190,000) Total projects '$?""x`,.;;(21,250) $ (21,250):_$'•,%;`"'(7271200) $ (21,250);$;/:='.r;:;(190,000) $ (980,950) ,;q_.'.P..' Projected ending fund balance 9/30/13 $r? 1;253,657 $ , 1,286,955 �5ri--r4'!319,715". $ 661,003 ,.$ %162,314 $ 3,683,643 8/9/2012 21 BOND FUNDS FY 2011/2012 EXHIBIT E ,),..7.77,,.......^ 2008 Certificates of,,,--1006 lievenue, 2007 General j:.2002 General,, 2009 General -,'2009 Genera-g, 2011 General 1:2011 General,., zou Certficates of,,-;-., i.„ggv,- 'nd hs"'''.2,004,20n,bfoies, Obligation ',','-"idondd', •'''''. Obligation bonds -01Stygdilin bonds,•Obligation bonds ..'Obligiikiibondi, Obligation bonds c,bbligstioribon:dij. Obligation .2 •. , Town Creek 41:raindge ,-.,. MultEvent CR 1/24r1flkaiteirsateS Water/Wastewater,j Pad°Statign,,. Fire Station Ciglidn,.idildirDSnid Regsonal Detention d ,6all Fidlist:d Water/Wastewater: ',-Tote( 55 Beginning balance 10/1/111;i:17i,f?44,851$ 2,766/i i-":844,085 5 171579 5,3- ..7-7-..-13 5 143,523:5-7:i, ,,..238,822 $ 1354119 5.-:„77130D073 5 - .57,...,79,581,641 .. 7._• .7.. '1,127--;I'.::-::.''.•• Revenues-FY12 _ ,ii, .'.,. ;/,:?3::-':',1.j.=:,' • Forgveness of debt 11.1come 7.5.:-7,,7...;-7,i4:„,..--7 5 131735:577..:47....,.'!..-7•;'' ";:::'“").77"C:','-,'.'-' 5,7":1-.51173/ Settlement proceeds -5',....,-'''i,' ,."-',::'',.5 112.5001115C0 Interest ,5"-: 2;-,, 300 5 234 5. i 43s s 173 144 52.'7,.,,,,315 5 10,142 1--8 7...1.1134•5 Total Revenues Roe 3' :..,J-933 $ 245,469 1•,',..k..",-,:435.5 173 5 .! ''':':-—40 5 144 17.:".8:' :.".115 $ 14142 57 r .:-N1.,p,4, $ . .$-7 ,262,171 Total Avalaible FY 12 :5 ...0145,133.-$ 241235 5,,,"<":.441410 5 171,752 5. :;''.'„.....:91 $ 143,667.5 7.7'.7.- "239337 $ 1360,260.5 '310/357 $ - /..-:'.::141/1912 Proposed Projects: :',,.,,. .. . ;,,.77.7, '.1• .7 ,... ,,, ' ',,e--. ,'; Town Creek West Channel Improvements '$".;;;,,'"'(*307) :/,',7,.':,;(154.807) Muhl event center litigation settlement - ...;, 1,,,,.-,i-$ (15,003),',..,r.",--':'3 : '2, ,,,- , .,,., CS. ,.- -$'°- C115030 .,. • ,,,, s,"'•''' • ;•,,.2 ,,,,,,j c $ "-.:2''''.4 224 Police Station improvements/equipment : '-4::-8. ' '5::: 'cil,45.234 "'" ,r',''Xi.. Flre5tation Improvements/equipment "i... - '68 631) .- '-•%,-•,'',, ' --"-:77:' Complete°bolo Valley Drive g„ 7,.. (4,8,35) .ei. , ..,,.., 1,--.:lop,885) :..,,,-4,- f;-1,,, ._,. . • ' :--- -- -,-..- ..... Engineering work related to traffic signais ::::,; 8...: 7 $":::::•:,-,417193) 1.7,.. '(11030) ''`r' 7."y: -, crosswalk/signals .,,,, '' ...;-;r.i '.:;:':7--7'. -''''1,.7 2 <' `'...:-.7 •$,...57i,212(3,730) (5;750) ;" Sidewalk work on CVO(Io there additional?) ,::::';,i 7" ' P'i'-'.., -<'eif13) i 7).7'. • ... ,,(3545)„... Engineedng design-Town Creek Beg Det :„......!..i =.7j7 - . -;•::: C- :"V,777 2•L..: -'i- ,--: : :.-,.;:' ••:3-.....,1 5 (5C0,033)'77 ._,..;„,",-,:.„„- $::'.:.,.;:(5?20!() Total projects ;,3 r y:(184107)5 (15,003)5. '' 77'--", $ - $---..„,' 43,224 5 (38,631)5..6."165,280)S (50/C00)1...Y, $ - .'„4:',2. :0-'7''; '.:•'.."...-,c.""--i.f. : '''','.77:-_,...'''7,'":, Projected ending fund balance 9/30/12 .1:,;.,-,7-,.31,326.$ 233,235 -1,..t:445:210 5 171752 $),- r..,7.13,9/7 5 105,036:$";;-T.173,857,$ 4,860,260 7$i,..:130/25/5 - $.„,,,,Y 8;369:318 BOND FUNDS FY 2012/2013 "--..,....,-,,,..---• 2008 Certificates of 7„."2006Revenue 2007 General d 2096eneral--, 2009 General :: 2D33General-- 2011 General s.2012 General-r 2012 Certificates 20067on 000 ss Notei- Obfigaton '.1.:.bonds ' Obligator!bonds ObliOqin IIrssid: Obligation bonds -/OiSligatioolsonk Obligation bort& 01SlIgstiO'n tiddistj Obligation: T War o.,Creek ',Drainage-.'-', MuinEvent CR : er/Wa;tewatoi Water/Wastewater. POuce 510 on' are Ration 7E11;oiis Valls:yr/4 Regional Detention ; 438 Feidr,2,:Water/Wastewater.. .,Teta Fond:"..:,-..- 67, ,: . 2 0 51 ,.. ,-:5--...-..:.) 53 54 99 ,-. .. „...... Beginning balance 10/1/12 1.0'.'14329 $ 233,235 $ .5.",445,380$ 171,752 $.::: .'v13,337.$ 105,036.$.-...-' '1718/7.$ 4160260 5 -1,301257 $ - 11,1614118 -.. '.?7,-.• '',,..:,..: ,,...,. .;,-7,.....7.."":"7.-7- -, Revenues-FY13 5CUCG0contribution for traffic signal - "$:','3', .' '2' 0 - $,-,.?., '.75000 $ 75003 „ . . Bond Proceeds - 1..."--7,::::,-.:...",--"'„.$ $ $ 7000000 $ 746000 Inter. 257 1. , -77-_-473 5 190 5,7,.:'.......7 11 5 150 18,-., ':147-5 11,156'5"..' ..5.02 $ Total Revenues 1,',::?..,:/30,$ 158 1 i 7 --;.75,347 $ 11,156.$:...7." ,,5702 $ 1030,030,1- 2,9.93,640 Total Available FY13 $'",,..,7:<.60,654 $ 231492,5 --,7:445,7755.5 . 171141 1..- -13,321 $ 101194;57,..'...249206$ 4,871416'5..!'.:.1310.959 $ 7.030,000 5'C714461148 Proposed Projects Town Creek Regional Oetention 2,f' Sig„I- S,„.;, C.. $ (4,871,416) ,:-.,,,,c,,-,,- ; eJ;,,,1-(4,871:410) m Booster Pup Stations(has not started) %•;- ,,,-::', ;5,• (445 250)5 (171750) .' 3':.. -' :.A.". ...7'':: 8-6,7'(647000) , Police Station HVAC system r,..:5-,-,. , - -$::-.....,'111328) ... 7.,:t.77f. .1.:. (11/38) . , . , $' 7r7;(46•PC9) Fire Station-matching funds for radio grant 77.7i:::4:7, .:77.7i.„. ,77i...77.. , .„_, Traffic sIgnaD on CVD and Green Valley ..-7.:.;"': 4'-:',..r...,.7., , ,5/„7","(150100) .5':-'1454030) Intersection on CVD and Green Valley?? .7„..Y.0 7:,•,,, ':..;,'' ',7•/c.,:; :5 ''''.(25,900 k: ':.,:-:, ,_, .-,(2:5460) Additional sidewalk work on CVD??? $,...7.: '(74046) Land acquisition/ball field construction C.7.--i.4.,':-,, :-,7 :1,7„(1510,959) 1'.......7(1314859) .,.,..,,'.'','•.'•-•,•;' : ._,.V.,,";..:* 3 (500,030)1 .,..-:(503.00D) Green Valley CCN issues '.,.:',"-,-..'.'..,:c..: ''. : 'r4f-,..- . ,--;:. $ (1504003)$- ,;(81E0,000) Water Infrastructure-1E135 site -. .• Water Infrastructure-1010 site ...,: ',....!. ...1..• ,• ._'••:.-,-',"'f,,,,,,s, -.„ ., 2 ,,j'C_,„`$ (2,500,003)S.t.,,'-'(Z500,000) Total projects - ' $''''''-i-.(445,250)5 (171,750)5',,!,i.(13,328).5 (40,020)5,-74249,030)$ (4,871,416)$ -(3,310,959)$ (6,503,00)$,.S.(15,604703) .5'; Projected ending fund balance 9/30/13 17,, _.5:60154.$ 233,492•3,11. Lr"'5e3 $ 191 $i,-7...,':i '-.' $ 65,194.17-.7.;.27:7,:214 $ (0)$.-",' : ..0-$ 500,000 1:-i,11di24i 23 8/9/2012 O TO$$\<4,40.40.:\ /� i exA`' "City of Choice" GENERAL FUND The General fund is the general operating fund of the city and is always classified as a major fund. The general fund is used to account for all financial resources except those required to be accounted for in another fund. Major revenue sources include property taxes, charges for services, intergovernmental revenues, and investment of idle funds. Primary expenditures are for general administration, law enforcement,fire suppression,code enforcement,street maintenance and park maintenance. 25 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 GENERAL FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET BEGINNING FUND BALANCE 4,050,956 3,519,621 3,519,621 3,807,047 REVENUES: GENERAL AND FRANCHISE TAXES 4,250,154 4,475,800 4,607,763 5,109,200 PERMITS AND FEES 1,452,530 1,439,200 1,555,779 1,633,500 ANIMAL CONTROL 14,378 12,300 20,849 20,800 COURT AND ALARM PERMITS 222,614 230,900 252,432 335,600 INTEREST AND MISCELLANEOUS 45,993 47,100 60,464 13,213 PARKS AND GRANTS 117,598 100,500 102,377 25,500 INTERGOVERNMENTAL AND TRANSFERS 351,907 762,752 700,354 701,719 SUBTOTAL REVENUES 6,455,173 7,068,552 7,300,018 7,839,532 TOTAL AVAILABLE 10,506,129 10,588,173 10,819,639 11,646,579 EXPENDITURES: CITY COUNCIL 6,007 8,900 5,668 7,550 CITY ADMINISTRATION 824,330 663,575 675,346 655,919 POLICE 1,873,242 2,003,379 1,998,654 2,468,999 POLICE-ISD PROGRAM - 139,631 135,631 145,282 MUNICIPAL COURT 125,289 138,767 140,855 146,115 COMMUNITY DEVELOPMENT 629,500 731,707 689,650 786,875 PUBLIC WORKS 752,980 878,599 806,991 889,346 ANIMAL CONTROL 87,558 110,755 111,110 127,322 PARKS 456,935 430,986 383,983 444,806 ECONOMIC DEVELOPMENT 98,667 124,675 114,983 - FINANCE 288,740 283,295 283,107 287,806 INFORMATION TECHNOLOGY - - - 119,632 FIRE 1,521,176 1,218,081 1,180,995 1,432,524 NON-DEPARTMENTAL 187,921 401,083 359,698 218,980 GRANT EXPENDITURES 9,383 102,500 90,920 - SUBTOTAL EXPENDITURES 6,861,729 7,235,933 6,977,592 7,731,156 OTHER FINANCING USES 242,916 - 35,000 123,841 ADDITIONAL LAND ACQUISITION COSTS 380,000 OLD SCHOOL BUILDING RENOVATION 125,000 EMPLOYEE COST OF LIVING ADJUSTMENT 54,953 EMPLOYEE PAY PLAN 46,772 242,916 - 35,000 730,566 CHANGE IN RESERVED FUND BALANCE 118,137 - - - ENDING FUND BALANCE 3,519,621 3,352,240 3,807,047 3,184,857 27 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG REVENUES 01-31100-00-00 PROPERTYTAXES-CURRENT 3,008,579.85 3,228,000.00 3,257,831.86 3,715,000.00 487,000.00 15.1% 01-31120-00-00 DELINQUENT TAXES 20,318.80 30,000.00 28,260.18 28,300.00 (1,700.00) -5.7% 01-31130-00-00 PENALTY&INTEREST 12,023.69 12,000.00 16,403.80 16,000.00 4,000.00 33.3% 01-31200-00-00 SALES TAX 543,647 72 532,800.00 621,500.00 652,600.00 119,800.00 22.5% 01-31220-00-00 MIXED BEVERAGE TAX 3,554.58 4,000.00 3,136.16 3,500.00 (500.00) -12.5% 01-31310-00-00 FRANCHISE FEE-ELECTRIC 285,622.10 283,000.00 297,680.67 305,100.00 22,100.00 7.8% 01-31315-00-00 FRANCHISE FEE-PHONE 53,523.63 54,000.00 51,250.00 49,200.00 (4,800.00) -8.9% 01-31320-00-00 FRANCHISE FEE-CABLE 301,358.24 308,000.00 271,750.00 278,500.00 (29,500.00) -9.6% 01-31321-00-00 FRANCHISE FEE-CABLE(PEG) 2,987.24 - 40,300.00 41,300.00 41,300.00 01-31325-00-00 FRANCHISE FEE-GAS 3,003.50 10,000.00 2,500.00 2,500.00 (7,500.00) -75.0% 01-31330-00-00 FRANCHISE FEE-GVSUD 15,534.89 14,000.00 17,150.00 17,200.00 3,200.00 22.9% GENERAL AND FRANCHISE TAXES 4,250,154.24 4,475,800.00 4,607,762.67 5,109,200.00 633,400.00 14.2% 01-32100-00-00 PLUMBING PERMITS 101,870.75 128,700.00 106,652.68 112,000.00 (16,700.00) -13.0% 01-32150-00-00 ELECTRICAL PERMITS 81,684.55 73,700.00 91,995.41 96,600.00 22,900.00 31.1% 01-32200-00-00 BUILDING PERMITS 69,932.31 72,100.00 109,568.29 115,000.00 42,900.00 59.5% 01-32250-00-00 BUILDING PERMITS-NEW HOME 550,728.00 550,000.00 584,866.07 614,100.00 64,100.00 11.7% 01-32255-00-00 SIGN PERMITS 2,650.00 2,800.00 5,187.50 5,400.00 2,600.00 92.9% 01-32260-00-00 TREE AFFIDAVIT 25.00 - - - - 01-32270-00-00 SITE DEVELOPMENT FEES-BI 47,268.98 34,700.00 41,626.66 43,700.00 9,000.00 25.9% 01-32300-00-00 CONTRACTOR PERMITS 22,876.15 23,800.00 24,107.14 25,300.00 1,500.00 6.3% 01-32350-00-00 REINSPECTION FEES 96,900.00 87,500.00 95,223.21 100,000.00 12,500.00 14.3% 01-32400-00-00 SUBDIVISION PLAT FEES 57,757.05 62,300.00 42,267.86 44,400.00 (17,900.00) -28.7% 01-32425-00-00 PLAT RECORDING FEES - - 1,607.14 1,700.00 1,700.00 01-32435-00-00 SITE PLANS - 15,700.00 - - (15,700.00) -100.0% 01-32500-00-00 HEATING&A/C PERMITS 66,821.50 62,100.00 68,408.04 71,800.00 9,700.00 15.6% 01-32600-00-00 PLAN CHECKS 330,220.43 321,900.00 337,990.61 354,900.00 33,000.00 10.3% 01-32630-00-00 ZONING FEES - - 12,773.57 13,400.00 13,400.00 01-32650-00-00 VARIANCE FEES 2,140.00 3,900.00 - - (3,900.00) -100.0% 01-32655-00-00 CONSULTANT FEES 21,655.00 - 33,504.46 35,200.00 35,200.00 PERMITS AND FEES 1,452,529.72 1,439,200.00 1,555,778.64 1,633,500.00 194,300.00 13.5% 01-33100-00-00 ANIMAL REGISTRATION 4,751.60 5,300.00 3,836.57 3,800.00 (1,500.00) -28.3% 01-33115-00-00 ANIMAL CONTROL DONATIONS 229.00 200.00 577.71 600:00 400.00 200.0% 01-33125-00-00 TRAP RENTALS 38.00 - 109.71 100.00 100.00 01-33150-00-00 BOARDING FEES 420.00 - 3,021.43 3,000.00 3,000.00 01-33200-00-00 IMPOUND FEES 8,076.20 6,800.00 8,408.57 8,400.00 1,600.00 23.5% 01-33300-00-00 ANIMAL ADOPTION FEES 520.00 - 3,260.57 3,300.00 3,300.00 01-33350-00-00 REIMBURSABLE VET COSTS 343.57 - 1,634.40 1,600.00 1,600.00 ANIMAL CONTROL 14,378.37 12,300.00 20,848.97 20,800.00 8,500.00 69.1% 01-34100-00-00 FINES 174,684.45 200,000.00 211,658.43 293,700.00 93,700.00 46.9% 01-34105-00-00 WARRANT FEES 14,734.00 15,000.00 16,776.00 16,800.00 1,800.00 12.0% 01-34110-00-00 TIME PAY FEES 341.30 400.00 456.72 500.00 100.00 25.0% 01-34310-00-00 CASH OVER/SHORT 3.00 - 7.10 - - 01-34510-00-00 COURT SECURITY FEES 4,279.00 - - - - 01-34540-00-00 CREDIT CARD FEES 5,218.16 4,500.00 7,213.65 8,300.00 3,800.00 84 4% 01-34600-00-00 REPORTS AND OTHER 974.00 1,000.00 1,512.00 1,500.00 500.00 50.0% 01-34900-00-00 ALARM FEES 22,380.00 10,000.00 14,808.20 14,800.00 4,800.00 48.0% COURT AND ALARM PERMITS 222,613.91 230,900.00 252,432.10 335;600.00 104,700.00 45.3% 01-35100-00-00 INTEREST 6,604.64 8,600.00 4,129.97 4,100.00 (4,500.00) -52.3% 01-35300-00-00 MISCELLANEOUS RECEIPTS 24,064.84 22,800.00 679.71 500.00 (22,300.00) -97.8% 01-35315-00-00 NSF FEES 250.00 200.00 225.00 225.00 25.00 12.5% 01-35325-00-00 COBRA ADMIN FEE 140.63 - - - - 01-35335-00-00 CINGULAR TOWER RENTAL 8,388.00 8,400.00 8,388.00 8,388.00 (12.00) -0.1% 01-35340-00-00 A/C-TRAP RENTAL 232.00 100.00 - - (100.00) -100.0% 28 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG 01-35500-00-00 INSURANCE PROCEEDS - - 10,793.61 - - 01-36410-00-00 MISC.OVER/SHORT (6.35) - (169.90) - - 01-36415-00-00 SALE OF ASSETS 6,318.75 5,000.00 35,000.00 - (5,000.00) -100.0% 01-36420-00-00 SALE OF MATERIALS - 2,000.00 1,417.46 - (2,000.00) -100.0% INTEREST AND MISCELLANEOUS 45,992.51 47,100.00 60,463.85 13,213.00 (33,887.00) -71.9% 01-36100-00-00 PARK/PAVILION RENTALS 4,462.00 6,900.00 5,381.00 7,000.00 100.00 1.4% 01-36105-00-00 MULTI-EVENT CENTER RENTAL 13,745.00 10,300.00 9,725.00 9,500.00 (800.00) -7.8% 01-36115-00-00 PARK DONATIONS 85.00 - 40.00 - - 01-36123-00-00- GRANT-AACOG GRANT 8,945.33 - -. - - 01-36124-00-00 GRANT-BULLET PROOF VEST - - - - - 01-36125-00-00 CDJ GRANT SF-08-A10-17645-03 76,296.00 - - - - 01-36126-00-00 GRANT PARK 438.00 20,000.00 20,000.00 - (20,000.00) -100.0% 01-36127-00-00 GRANT-SECO GRANT - 57,500.00 57,500.00 - (57,500.00) -100.0% 01-36250-00-00 CIBOLOFEST 9,646.24 - - - - 01-36300-00-00 PARK-BALLFIELD RENTAL 3,980.00 5,800.00 9,731.00 9,000.00 3,200.00 55.2% PARKS AND GRANTS 117,597.57 100,500.00 102,377.00 25,500.00 (75,000.00) -74.6% 01-38100-00-00 INTERGOVTL XFER-SCUCISD 25,000.00 150,000.00 150,000.00 150,000.00 - 0.0% 01-38150-00-00 INTERGOVTL-CIBOLO CREEK MUN.AUTH., 3,975.00 3,800.00 4,759.62 5,000.00 1,200.00 31.6% 01-38402-00-00 GARBAGE TRANSFERS 193,686.79 199,000.00 187,023.67 190,000.00 (9,000.00) -4.5% 01-38502-00-00 TRANSFER FROM UTILITY FUND - 124,952.00 119,617.85 126,774.00 1,822.00 1.5% 01-38505-00-00 TRANSFER FROM ECONOMIC DEV.COR 12,000.00 10,000.00 6,000.00 6,000.00 (4,000.00) -40.0% 01-38532-00-00 TRANSFER FROM PARK LAND FEES - 25,000.00 25,000.00 - (25,000.00) -100.0% 01-38538-00-00 TRANSFER FROM CHILD SAFETY 15,785.00 15,785.00 01-38539-00-00 TRANSFER FROM STREET/MAINT.TAX 117,245.00 250,000.00 200,000.00 200,000.00 (50,000.00) -20.0% 01-38540-00-00 TRANSFER FROM DUD - - 7,953.21 8,160.00 8,160.00 INTERGOVERNMENTAL AND TRANSFERS 351,906.79 762,752.00 700,354.34 701,719.00 (61,033.00) TOTAL REVENUE 6,455,173.11 7,068,552.00 7,300,017.58 7,839,532.00 832,013.00 10.9% 29 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 41—City Council Function: The City Council operates under a City Council Manager form of government. The City Council is composed of Mayor and seven councilmen that are elected at large for staggered two-year terms. The Council is charged with the responsibilities of enacting local legislation, adopting the budget,setting policies and appointing the city manager. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2O12-2013 Mayor 1 1 1 Council Members 7 7 7 8 8 8 30 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG CITY COUNCIL 01-52630-41-00 CONFERENCE TRAVEL 1,434.89 2,500.00 921.89 1,600.00 (900.00) -36.0% 01-52820-41-00 TELEPHONE 1,295.88 1,300.00 1,400.00 1,200.00 (100.00) -7.7% SERVICES,UTILITIES AND TRAINING 2,730.77 3,800.00 2,321.89 2,800.00 (1,000.00) -26.3% 01-53210-41-00 OFFICE SUPPLIES - 500.00 453.89 400.00 (100.00) -20.0% 01-53215-41-00 PRINTING - 500.00 105.00 250.00 (250.00) -50.0% 01-53610-41-00 MEETING EXPENSE 135.94 800.00 800.00 800.00 - 0.0% 01-53760-41-00 AWARDS/COMMUNITY EVENTS 3,140.06 3,300.00 1,986.95 3,300.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 3,276.00 5,100.00 3,345.84 4,750.00 (350.00) -6.9% TOTAL CITY COUNCIL 6,006.77 8,900.00 5,667.73 7,550.00 (1,350.00) -15.2% 31 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 42—Administration Function: Administration includes the City Manager,City Secretary and other administrative personnel. The City Manager is appointed by Council and serves as the Chief Administrative Officer of the City. The City Manager is responsible to the City Council for the execution of the laws and the administration of the government and all departments of the City. He sees that all state laws and City ordinances are effectively enforces. He prepares and recommends to the council the annual budget and capital program and provides information to the Council to facilitate its ability to make informed policy decisions in the best interest of the community. The City Secretary is also appointed by Council, but works administratively for the City Manager. The City Secretary serves as custodian of all official records of the City Council. The City Secretary's Office coordinates preparation of Council agendas and the official minutes, prepares legal notices for publication and posting, maintains the City seal and attests all city documents, is responsible for oaths of office, maintains boards, commission agendas and minutes and receives bids. The City Secretary oversees all City elections and also serves as the Human Resources Director. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 City Manager 1 1 1 City Secretary/Human Resources 1 1 1 Assistant City Secretary 1 1 1 Administrative Assistant 1 1 1 4 4 4 32 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG ADMINISTRATION 01-51010-42-00 SALARIES 294,276.72 252,361.00 237,105.61 273,269.00 20,908.00 8.3% 01-51011-42-00 LONGEVITY PAY 1,680.00 1,920.00 1,920.00 2,160.00 240.00 12.5% 01-51012-42-00 CAR ALLOWANCE - 6,000.00 3,750.00 9,000.00 3,000.00 50.0% 01-51015-42-00 OVERTIME 519.22 - - - - 01-51016-42-00 PHONE ALLOWANCE 2,560.00 3,120.00 1,095.00 1,620.00 (1,500.00) -48.1% 01-51020-42-00 UNEMPLOYMENT TAX 299.10 360.00 1,049.09 1,044.00 684.00 190.0% 01-51030-42-00 SOCIAL SECURITY/MEDICARE 20,318.30 20,150.00 18,559.81 21,883.00 1,733.00 8.6% 01-51040-42-00 RETIREMENT 31,895.01 26,906.00 24,526.88 25,988.00 (918.00) -3.4% 01-51060-42-00 HEALTH-LIFE INSURANCE 19,211.92 18,658.00 16,560.12 27,495.00 8,837.00 47.4% 01-51070-42-00 WORKERS COMPENSATION 825.36 700.00 674.88 760.00 60.00 8.6% SALARIES AND BENEFITS 371,585.63 330,175.00 305,241.39 363,219.00 33,044.00 10.0% 01-52095-42-00 MEDICAL EXAMS 3,895.50 4,000.00 4,750.00 5,000.00 1,000.00 25.0% 01-52200-42-00 DATA PROCESSING 187.28 200.00 - - (200.00) -100.0% 01-52610-42-00 CONTRACT SERVICES 39,299.69 22,000.00 1,234.76 1,200.00 (20,800.00) -94.5% 01-52616-42-00 OTHER EMPLOYMENT COSTS - - 5,552.73 - - 01-52620-42-00 PUBLICATIONS 2,451.72 2,800.00 2,803.56 2,500.00 (300.00) -10.7% 01-52625-42-00 ADVERTISING/LEGAL NOTICES 15,325.31 14,000.00 7,161.37 8,000.00 (6,000.00) -42.9% 01-52630-42-00 TRAVEL AND TRAINING 6,021.10 8,000.00 8,530.78 8,000.00 - 0.0% 01-52635-42-00 DUES,FEES AND PERMITS 5,993.94 6,250.00 5,193.03 6,000.00 (250.00) -4.0% 01-52650-42-00 GENERAL LIABILITY INSURANCE - - - - - 01-52670-42-00 GUADALUPE CO.APPRAISAL/ASSESS - - - - - 01-52680-42-00 LEGAL SERVICES 331,282.90 200,000.00 282,097.75 200,000.00 - 0.0% 01-52710-42-00 PROFESSIONAL SERVICES 12,613.25 50,000.00 26,000.00 25,000.00 (25,000.00) -50.0% 01-52720-42-00 AUDIT SERVICES - - - - - 01-52810-42-00 UTILITIES - - - - - 01-52815-42-00 CPS-STREET LIGHT UTILITIES - - - - - 01-52820-42-00 TELEPHONE - - - - - 01-52850-42-00 NEWSLETTER 9,749.47 4,500.00 12,210.35 15,000.00 10,500.00 233.3% SERVICES,UTILITIES AND TRAINING 426,820.16 311,750.00 355,534.33 270,700.00 (41,050.00) -13.2% 01-53210-42-00 OFFICE SUPPLIES 3,604.40 4,000.00 3,448.03 4,000.00 - 0.0% 01-53220-42-00 JANITORAL SUPPLIES - - - - - 01-53225-42-00 OFFICE MACHINERY AND EQUIPMENT 2,215.99 - - - - 01-53230-42-00 OTHER SUPPLIES 2,737.85 3,000.00 3,000.00 3,000.00 - 0.0% 01-53240-42-00 POSTAGE 426.57 650.00 477.33 500.00 (150.00) -23.1% 01-53410-42-00 BUILDING MAINTENANCE - - - - - 01-53640-42-00 ELECTION 9,938.29 10,000.00 3,500.00 10,000.00 - 0.0% 01-53760-42-00 AWARDS - 2,000.00 2,000.00 2,000.00 - 0.0% 01-53800-42-00 EMPLOYEE AWARDS PROGRAM - 2,000.00 2,145.00 2,500.00 500.00 25.0% GENERAL SUPPLIES AND REPAIRS 18,923.10 21,650.00 14,570.36 22,000.00 350.00 1.6% 01-54900-42-00 NON CAPITAL OUTLAY<$9,999 7,000.90 - - - - 01-54910-42-00 CAPITAL OUTLAY - - - - - CAPITAL AND NON-CAPITAL OUTLAY 7,000.90 - - - - 01-55720-42-00 GARAGE-FALL AND SPRING CLEANUP - - - - - OTHER EXPENSES - - - - - TOTAL ADMINISTRATION 824,329.79 663,575.00 675,346.08 655,919.00 (7,656.00) -1.2% 33 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 43—Police Department Function: The police department is responsible for the protection of life and property as well as the enforcement of local, state and federal laws. The overall goal of the police department is to foster community partnerships and joint problem solving techniques within the community that will preserve the quality of life for our residents. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Police Chief 1 1 1 Assistant Police Chief 0 0 0 Patrol Lieutenant 1 1 2 CID Sergeant 1 1 1 Corporal Investigator 1 1 1 Corporal Special Services 0 0 0 Patrol Sergeant 3 6 6 Patrol Corporal 3 0 0 Patrol Officer 12 12 13 Traffic Officer 0 0 1 Warrant Officer 1 1 1 School Resource Officer 0 2 2 Clerk 2 2 2 Crossing Guards 6 6 6 31 33 36 Proposed Capital: 3-2012 Chevrolet Tahoes $ 114,853.00 Upgrade unit to covert traffic unit $ 16,740.00 Net Motion Software $30,000.00 $161,593.00 34 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG POLICE DEPARTMENT 01-51010-43-00 SALARIES 1,005,714.39 1,158,816.00 1,144,252.58 1,185,104.00 26,288.00 2.3% 01-51011-43-00 LONGEVITY 10,200.00 13,480.00 12,840.00 15,840.00 2,360.00 17.5% 01-51013-43-00 CERTIFICATE PAY 19,080.00 26,000.00 22,880.00 29,120.00 3,120.00 12.0% 01-51015-43-00 OVERTIME 50,524.69 32,500.00 43,123.41 50,000.00 17,500.00 53.8% 01-51016-43-00 PHONE ALLOWANCE 4,960.00 -5,280.00 6,460.00 6,000.00 720.00 13.6% 01-51017-43-00 ON-CALL PAY 1,851.48 2,080.00 2,240.00 4,160.00 2,080.00 100.0% 01-51020-43-00 UNEMPLOYMENT TAX 2,516.35 2,507.00 10,472.65 7,323.00 4;816.00 192.1% 01-51030-43-00 SOCIALSECURITY-MEDICARE 82,003.18 94,719.00 93,321.14 98,702.00 3,983.00 4.2% 01-51040-43-00 RETIREMENT 114,227.09 123,855.00 123,565.73 114,717.00 (9,138.00) -7 4% 01-51060-43-00 HEALTH-LIFE INSURANCE 108,469.86 131,923.00 124,222.77 132,104.00 181.00 0.1% 01-51070-43-00 WORKERS COMPENSATION 29,522.04 27,009.00 25,588.06 28,186.00 1,177.00 4.4% SALARIES AND BENEFITS 1,429,069.08 1,618,169.00 1,608,966.34 1,671,256.00 53;087.00 3.3% 01-52200-43-00 DATA PROCESSING 204.93 - - - - 01-52610-43-00 CONTRACT SERVICES 27,583.50 28,960.00 29,652.91 30,000.00 1,040.00 3.6% 01-52620-43-00 PUBLICATIONS-DUES-FEES 897.43 750.00 250.00 750.00 - 0,0% 01-52630-43-00 TRAVEL AND TRAINING 10;035.20 10,000.00 9,931.38 11,000.00 1,000.00 10.0% 01-52635-43-00 DUES,FEES AND PERMITS 2,466.70 3,000.00 2,176.40 3,000.00 - 0.0% 01-52710-43-00 PROFESSIONAL SERVICES 4,272.57 5,000.00 4,245.50 5,000.00 - 0.0% 01-52780-43-00 MEDICAL&LAB - 500.00 - 500.00 - 0.0% 01-52810-43-00 UTILITIES 47,827.05 52,000.00 44,385.48 42,000.00 (10,000.00) -19.2% 01-52820-43-00 TELEPHONE 6,403.93 14,200.00 15,165.31 15,000.00 800.00 5.6% SERVICES,UTILITIES AND TRAINING 99,691.31 114,410.00 105,806.98 107,250.00 (7,160.00) -6.3% 01-53090-43-00 UNIFORM REPLACEMENT 15,842.80 12,800.00 13,398.92 13,000.00 200.00 1.6% 01-53210-43-00 OFFICE SUPPLIES 7,066.71 6,000.00 6,093.58 6,500.00 500.00 8.3% 01-53240-43-00 POSTAGE 1,707.09 2,000.00 1,029.51 1,500.00 (500.00) -25.0% 01-53250-43-00 OFFICER'S EQUIPMENT-SUPPLIES 15,541.54 16,000.00 15,957.26 16,000.00 - 0.0% 01-53260-43-00 CRIME PREVENTION SUPPLIES 5,126.95 2,500.00 2,319.00 2,500.00 - 0.0% 01-53280-43-00 MINOR TOOLS&EQUIPMENT 286.48 1,000.00 975.15 1,000.00 - 0.0% 01-53410-43-00 BUILDING MAINTENANCE (750.94) 2,500.00 2,847.07 4,000.00 1,500.00 60.0% 01-53430-43-00 OFFICE EQUIPMENT MAINTENANCE .206.06 1,000.00 368.10 1,000.00 - 0.0% 01-53450-43-00 VEHICLE OPERATION - - - - - 01-53455-43-00 VEHICLE FUEL 64,127.08 68,000.00 83,721.95 84,000.00 16,000.00 23.5% 01-53470-43-00 VEHICLE REPAIRS 16,884.67 22,500.00 23,865.44 24,000.00 1,500.00 6.7% 01-53610-43-00 MEETING EXPENSES 500.00 500.00 GENERAL SUPPLIES AND REPAIRS 126,038.44 134,300.00 150,575.98 154,000.00 19,700.00 14.7% 01-54900-43-00 NON CAPITAL OUTLAY<$9,999 7,731.50 - - 9,000.00 9,000.00 01-54910-43-00 CAPITAL OUTLAY - - - 161,593.00 161,593.00 01-54930-43-00 COMMUNICATION EQUIPMENT 1,468.00 - - - - CAPITAL AND NON-CAPITAL OUTLAY 9,199.50 - - 170,593.00 170,593.00 01-55743-43-00 PUBLIC SAFETY DISPATCH 133,305.00 135,000.00 133,305.00 147,500.00 12,500.00 9.3% 01-55770-43-00 JAIL COST - 1,500.00 - 1,500.00 - 0.0% 01-55800-43-00 GRANTS 75,938.97 - - - - OTHER EXPENSES 209,243.97 136,500.00 133,305.00 149,000.00 12,500.00 9.2% SUBTOTAL POLICE ADMINISTRATION 1,873,242.30 2,003,379.00 1,998,654.30 2,252,099.00 21,560.00 12.4% 35 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG POLICE LIEUTENANT SALARY AND BENEFITS 75,765.93 EQUIPMENT AND SUPPLIES 11,272.00 POLICE OFFICER SALARY AND BENEFITS 56,410.22 EQUIPMENT AND SUPPLIES 8,521.00 TRAFFIC OFFICER SALARY AND BENEFITS 56,410.22 EQUIPMENT AND SUPPLIES 8,521.00 SUBTOTAL ADDITIONAL PERSONNEL - - - 216,900.37 216,900.37 TOTAL POLICE ADMINISTRATION 1,873,242.30 2,003,379.00 1,998,654.30 2,468,999.37 465,620.37 23.2% 36 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG POLICE DEPARTMENT-ISD PROGRAM 01-51010-43-01 SALARIES - 81,099.00 81,747.38 85,930.00 4,831.00 6.0% 01-51011-43-01 LONGEVITY - 240.00 480.00 720.00 480.00 200.0% 01-51013-43-01 CERTIFICATE PAY - - 520.00 2,080.00 2,080.00 01-51015-43-01 OVERTIME - 7,500.00 5,680.17 7,500.00 - 0.0% 01-51020-43-01 UNEMPLOYMENT - 180.00 728.00 522.00 342.00 190.0% 01-51030-43-01 SOCIALSECURITY-MEDICARE - 6,796.00 6,765.38 7,362.00 566.00 8.3% 01-51040-43-01 TMRS - 9,075.00 8,988.40 8,743.00 (332.00) -3.7% 01-51060-43-01 HEALTH-LIFE INSURANCE - 10,543.00 10,061.28 10,558.00 15.00 0.1% 01-51070-43-01 WORKERS COMPENSATION - 2,038.00 1,000.00 2,207.00 169.00 8.3% SALARIES AND BENEFITS - 117,471.00 115,970.61 125,622.00 8,151.00 6.9% 01-52610-43-01 CONTRACT SERVICES - 2,500.00 - - (2,500.00) -100.0% 01-52630-43-01 CONFERENCE/TRAVEL/TRAINING - 2,500.00 2,500.00 2,500.00 - 0.0% 01-52820-43-01 TELEPHONE - 960.00 133.57 960.00 - 0.0% SERVICES,UTILITIES AND TRAINING - 5,960.00 2,633.57 3,460.00 (2,500.00) -41.9% 01-53090-43-01 CLOTHING - 2,200.00 1,500.00 2,200.00 - 0.0% 01-53250-43-01 OFFICER'S EQUIPMENT-SUPPLIES - 3,000.00 2,936.85 5,500.00 2,500.00 83.3% 01-53455-43-01 VEHICLE FUEL - 4,000.00 6,509.03 6,500.00 2,500.00 62.5% 01-53470-43-01 VEHICLE REPAIR - 2,000.00 1,115.41 2,000.00 - 0.0% GENERAL SUPPLIES AND REPAIRS - 11,200.00 12,061.29 16,200.00 5,000.00 44.6% 01-54900-43-01 NON CAPITAL OUTLAY<$9,999 - 5,000.00 4,966.00 - (5,000.00) -100.0% CAPITAL AND NON-CAPITAL OUTLAY - 5,000.00 4,966.00 - (5,000.00) -100.0% TOTAL POLICE DEPARTMENT-ISD PROGRAM - 139,631.00 135,631.47 145,282.00 5,651.00 4.0% 37 CITY OF CIBOLO,TEXAS 7/18/2012 PROPOSED BUDGET FISCAL YEAR 2012-2013 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %DIG MUNICIPAL COURT 01-51010-44-00 SALARIES 56,556.23 60,457.00 60,410.77 60,734.00 277.00 0.5% 01-51011-44-00 LONGEVITY 1,200.00 1,440.00 1,440.00 1,680.00 240.00 16.7% - 01-51015-44-00 OVERTIME - - 01-51016-44-00 PHONE ALLOWANCE - - 01-51020-44-00 UNEMPLOYMENT TAX 144.01 180.00 713.12 522.00 342.00 190.0% 01-51030-44-00 SOCIALSECURITY-MEDICARE 4,357.97 4,735.00 4,550.26 4,775.00 40.00 0.8% 01-51040-44-00 RETIREMENT 6,112.44 6,323.00 6,298.67 5,670.00 (653.00) -10.3% 01-51060-44-00 HEALTH-LIFE INSURANCE 10,044.70 10,488.00 10,028.28 10,488.00 - 0.0% 01-51070-44-00 WORKERS COMPENSATION 157.32 164.00 151.28 166.00 2.00 1.2% SALARIES AND BENEFITS 78,572.67 83,787.00 83,592.38 84,035.00 248.00 0.3% 01-52420-44-00 JUDGE-PROSECUTOR 38,361.61 41,000.00 43,224.84 39,000.00 (2,000.00) -4.9% 01-52425-44-00 JURY FEES 114.00 600.00 422.00 600.00 - 0.0% 01-52610-44-00 CONTRACT SERVICES - 5,000.00 5,139.83 14,300.00 9,300.00 186.0% 01-52620-44-00 PUBLICATIONS 50.00 200.00 - - (200.00) -100.0% 01-52630-44-00 TRAVEL AND TRAINING 1,261.78 2,000.00 1,694.35 1,750.00 (250.00) -12.5% 01-52635-44-00 DUES,FEES AND PERMITS 80.00 80.00 80.00 80.00 - 0.0% SERVICES,UTILITIES AND TRAINING 39,867.39 48,880.00 50,561.02 55,730.00 6,850.00 14.0% 01-53210-44-00 OFFICE SUPPLIES 1,653.57 1,400.00 1,878.24 1,800.00 400.00 .28.6% 01-53215-44-00 PRINTING 923.55 1,000.00 644.00 650.00 (350.00) -35.0% 01-53225-44-00 OFFICE MACHINERY AND EQUIPMENT 367.75 200.00 326.70 200.00 - 0.0% 01-53240-44-00 POSTAGE 1,561.92 1,500.00 1,671.19 1,500.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 4,506.79 4,100.00 4,520.13 4,150.00 50.00 .13% 01-55425-44-00 CREDIT CARD MACHINE FEES .2,342.56 2,000.00 2,181.51 2,200.00 200.00 10.0% OTHER EXPENSES 2,342.56 2,000.00 2,181.51 2,200.00 200.00 10.0% TOTAL MUNICIPAL COURT 125,289.41 138,767.00 140,855.04 146,115.00 7,348.00 .5.3% 39 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 45—Community Development Services Function: Community Development Services is responsible for administration of the City's Zoning Ordinance, Subdivision Regulations and State statutory and regulatory requirements. Specific areas of responsibility include: annexation, applications for rezoning or property,subdivision of land,variances to development requirements,construction permits and inspections, and code enforcement. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Community Development Director 1 1 1 Senior Planner 1 1 1 Assistant Planner 1 1 1 Infrastructure Inspector * 1 1 1 Senior Building Inspector 1 1 1 Building Inspector 2 2 2 Code Enforcement Officer 1 1 1 Administrative Assistant 1 1 1 Receptionist/Clerk 1 1 1 10 10 10 Proposed Capital: Improvement to School Building $125,000.00 Chevrolet Colorados 2-2012 $ 17,381.00 $142,381.00 * The infrastructure inspector position is funded 50%from community development and 50%from utilities operations. 40 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG COMMUNITY DEVELOPMENT 01-51010-45-00 SALARIES 392,324.78 418,484.00 402,277.20 429,252.00 10,768.00 2.6% 01-51011-45-00 LONGEVITY 3,720.00 4,560.00 4,380.00 5,520.00 960.00 21.1% 01-51015-45-00 OVERTIME - 1,000.00 833.79 1,000.00 - 0.0% 01-51016-45-00 PHONE ALLOWANCE 3,000.00 3,120.00 3,080.00 3,360.00 240.00 7.7% 01-51020-45-00 UNEMPLOYMENT TAX 768.04 855.00 3,233.06 2,610.00 1,755.00 205.3% 01-51030-45-00 SOCIALSECURITY-MEDICARE 29,088.84 32,678.00 30,514.05 33,594.00 916.00 2.8% 01-51040-45-00 RETIREMENT 42,146.77 43,635.00 41,787.51 39,895.00 (3,740.00) -8.6% 01-51060-45-00 HEALTH-LIFE INSURANCE 42,632.60 50,089.00 44,436.53 50,115.00 26.00 0.1% 01-51070-45-00 WORKERS COMPENSATION 3,671.28 3,486.00 3,217.22 3,557.00 71.00 .2.0% SALARIES AND BENEFITS 517,352.31 557,907.00 533,759.36 568,903.00 10,996.00 2.0% 01-52200-45-00 DATA PROCESSING SOFTWARE 561.84 - - - - 01-52610-45-00 CONTRACT SERVICES 12,777.74 12,600.00 11,589.24 12,600.00 - 0.0% 01-52620-45-00 PUBLICATIONS 744.40 500.00 164.50 4,854.00 4,354.00 870.8% 01-52630-45-00 TRAVEL AND TRAINING 2,123.00 6,500.00 4,554.97 6,500.00 - 0.0% 01-52635-45-00 DUES,FEES AND PERMITS 1,488.88 1,750.00 1,577.00 2,000.00 250.00 14.3% 01-52680-45-00 LEGAL SERVICES 9,788.05 5,000.00 7,453.74 5,000.00 - 0.0% 01-52700-45-00 SITE DEVELOPMENT FEES - - 29,768.04 32,744.84 32,744.84 01-52710-45-00 PROFESSIONAL SERVICES 67,843.55 115,000.00 73,927.25 73,000.00 (42,000.00) -36.5% 01-52740-45-00 GIS/CAD MAPPING SERVICES - - - 25,000.00 25,000.00 01-52810-45-00 UTILITIES - 5,500.00 - 5,500.00 - 0.0% 01-52820-45-00 TELEPHONE 1,586.05 4,500.00 4,709.18 5,000.00 500.00 11.1% SERVICES,UTILITIES,AND TRAINING 96,913.51 151,350.00 133,743.92 172,198.84 20,848.84 13.8% 01-53090-45-00 UNIFORM REPLACEMENT 650.61 1,800.00 1,123.08 1,800.00 - 0.0% 01-53210-45-00 OFFICE SUPPLIES 1,578.43 1,500.00 .1,718.68 1,850.00 350.00 23.3% 01-53215-45-00 PRINTING - 250.00 310.00 500.00 250.00 100.0% 01-53225-45-00 OFFICE MACHINERY AND EQUIPMENT 619.54 800.00 1,080.65 4,500.00 3,700.00 462.5% 01-53230-45-00 OTHER SUPPLIES - 150.00 75.00 300.00 150.00 100.0% 01-53240-45-00 POSTAGE 1,119.51 1,500.00 1,178.39 1,500.00 - 0.0% 01-53280-45-00 MINOR TOOLS AND EQUIPMENT 33.08 500.00 350.99 500.00 - 0.0% 01-53410-45-00 BUILDING MAINTENANCE - 2,000.00 170.00 2,000.00 - 0.0% 01-53450-45-00 VEHICLE OPERATION - - - - - 01-53455-45-00 VEHICLE FUEL 7,204.18 _ 8,800.00 6,950.70 8,000.00 (800.00) -9.1% 01-53470-45-00 VEHICLE REPAIRS 1,976.54 2,500.00 4,178.31 3,000.00 500.00 20.0% 01-53610-45-00 MEETING EXPENSES - 250.00 . , 51.91 250.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 13,181.89 20,050.00 17,187.71 24,200.00 4,150.00 20.7% 01-54900-45-00 NON CAPITAL OUTLAY<$9,999 - - 2,356.46 1,692.00 1,692.00 01-54910-45-00 CAPITAL OUTLAY - - - 17,381.00 17,381.00 CAPITAL AND NON-CAPITAL OUTLAY - - 2,356.46 19,073.00 19,073.00 01-55425-45-00 CREDIT CARD MACHINE FEES 2,052.41 2,400.00 2,602.53 2,500.00 100.00 4.2% OTHER EXPENSES 2,052.41 2,400.00 2,602.53 2,500.00 100.00 4.2% TOTAL COMMUNITY DEVELOPMENT 629,500.12 731,707.00 689,649.98 786,874.84 55,167.84 7.5% 41 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 46—Public Works Function: The primary responsibility of Public Works is to maintain the best possible road infrastructure for the City. This includes maintenance of road surfaces, right-of-way safety, mowing right-of-way frontage,school zone safety,sidewalks,traffic control signals, and street signs. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Public Works/Utilities Director 0 1 1 Fire Chief/Public Works/Utilities 1 0 0 Superintendent 1 1 0 Infrastructure Inspector 0 0 0 Foreman 0 1 1 Crew Leader 1 1 2 Labor III—Mechanic 1 1 1 Labor II—Street Sweeper 1 0 0 Labor1,11, Ill 8 7 7 13 12 12 Proposed Capital: Ford F150 Truck(1/2 funded from Public Works/Utilities) $ 13,000.00 Ford F150 Truck(1/2 funded from Public Works/Drainage) $ 13,000.00 $26,000.00 42 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG PUBLIC WORKS 01-51010-46-00 SALARIES 310,139.01 312,685.00 320,377.42 352,749.00 40,064.00 12.8% 01-51011-46-00 LONGEVITY 2,520.00 3,360.00 2,640.00 3,900.00 540.00 16.1% 01-51015-46-00 OVERTIME 785.63 1,500.00 1,139.06 1,600.00 100.00 6.7% 01-51016-46-00 PHONE ALLOWANCE 1,600.00 1,380.00 1,750.00 2,520.00 1,140.00 82.6% 01-51020-46-00 UNEMPLOYMENT TAX 1,203.28 945.00 3,459.49 3,132.00 2,187.00 231.4% 01-51030-46-00 SOCIAL SECURITY/MEDICARE 22,998.09 24,398.00 24,310.00 27,599.00 3,201.00 13.1% 01-51040-46-00 RETIREMENT 33,269.20 32,578.00 31,895.40 32,776.00 198.00 0.6% 01=51060-46-00 HEALTH-LIFE INSURANCE 51,573.67 53,728.00 51,539.45 60,314.00 6,586.00 12.3% 01-51070-46-00 WORKERS COMPENSATION 22,555.32 19,025.00 19,490.95 22,956.00 3,931.00 20.7% 01-51099-46-00 SALARY SAVINGS - - - (10,000.00) (10,000.00) SALARIES AND BENEFITS 446,644.20 449,599.00 456,601.77 497,546.00 47,947.00 10.7% 01-52610-46-00 CONTRACT SERVICES 195.55 250.00 - 200.00 (50.00) -20.0% 01-52612-46-00 CONTRACT MAINTENANCE SIDEWALKS - - - 50,000.00 50,000.00 01-52615-46-00 CONTRACT MAINTENANCE STREETS 121,202.47 250,000.00 200,000.00 150,000.00 (100,000.00) -40.0% 01-52625-46-00 DUES AND FEES 120.00 - - - - 01-52630-46-00 CONFERENCE/TRAVEL/TRAINING 498.00 1,000.00 405.23 1,000.00 - 0.0% 01-52635-46-00 DUES,FEES AND PERMITS - 500.00 - - (500.00) -100.0% 01-52720-46-00 ENGINEERING SERVICES 1,290.00 5,000.00 11,600.00 8,000.00 3,000.00 60.0% 01-52810-46-00 UTILITIES 10,069.06 7,500.00 2,822.37 3,500.00 (4,000.00) -53.3% 01-52820-46-00 TELEPHONE 786.56 1,000.00 483.34 1,000.00 - 0.0% SERVICES,UTILITIES AND TRAINING 134,161.64 265,250.00 215,310.94 213,700.00 (51,550.00) -19.4% 01-53090-46-00 UNIFORMS 6,878.17 9,000.00 6,992.36 8,000.00 (1,000.00) -11.1% 01-53095-46-00 SAFETY SUPPPLIES AND EQUIPMENT 1,766.73 2,500.00 2,888.19 2,000.00 (500.00) -20.0% 01-53210-46-00 OFFICE SUPPLIES 357.06 750.00 329.88 600.00 (150.00) -20.0% 01-53220-46-00 JANITORIAL SUPPLIES - 500.00 200.00 200.00 (300.00) -60.0% 01-53225-46-00 OFFICE MACHINERY AND EQUIPMENT 538.49 - 34.47 100.00 100.00 01-53230-46-00 OTHER SUPPLIES - - 273.19 200.00 200.00 01-53275-46-00 MAINTENANCE SUPPLIES-STREETS 59,141.82 60,000.00 50,392.32 60,000.00 - 0.0% 01-53276-46-00 DRAINAGE MAINTENANCE - - - - - 01-53277-46-00 RENTAL 291.20 5,000.00 2,443.14 5,000.00 - 0.0% 01-53280-46-00 MINOR TOOLS AND EQUIPMENT 4,803.64 5,000.00 3,051.33 4,000.00 (1,000.00) -20.0% 01-53410-46-00 BUILDING MAINTENANCE 1,368.41 1,500.00 820.17 1,500.00 - .0.0% 01-53440-46-00 MACHINERY MAINTENANCE 12,620.50 15,000.00 21,739.90 15,000.00 - 0.0% 01-53450-46-00 VEHICLE OPERATION - - - - - 01-53455-46-00 VEHICLE FUEL 35,780.18 40,000.00 31,255.26 35,000.00 (5,000.00) -12.5% 01-53470-46-00 VEHICLE REPAIRS 12,123.79 15,000.00 7,267.11 7,500.00 (7,500.00) -50.0% 01-53530-46-00 SIGNS MAINTENANCE 10,166.55 8,000.00 7,239.38 8,000.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 145,836.54 162,250.00 134,926.70 147,100.00 (15,150.00) :93% 01-54900-46-00 NON CAPITAL OUTLAY<$9,999 - - - - - 01-54910-46-00 CAPITAL OUTLAY 25,063.64 - - 26,000.00 26,000.00 01-54930-46-00 COMMUNICATION EQUIPMENT 1,274.10 1,500.00 151.26 5,000.00 3,500.00 233.3% CAPITAL AND NON-CAPITAL OUTLAY 26,337.74 1,500.00 151.26 31,000.00 29,500.00 1966.7% TOTAL PUBLIC WORKS 752,980.12 878,599.00 806,990.67 889,346.00 10,747.00 1.2% 43 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 47—Animal Control Function: The primary responsibilities of Animal Control are to protect public health and welfare while enforcing humane treatment of animals in accordance with city ordinances and county, state and federal regulations; provide safe, humane shelter for unwanted, stray, abused or impounded animals; and to educate the public about responsible animal care. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Animal Control Officer 1 1 1 Part-Time Animal Control Officer* 0 1 1 1 2 2 * Upgrade to Full Time in FY 13 44 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CNG ANIMAL CONTROL 01-51010-47-00 SALARIES 40,249.85 47,644.00 47,504.54 47,956.00 312.00 0.7% 01-51011-47-00 LONGEVITY 120.00 240.00 240.00 360.00 120.00 50.0% 01-51014-47-00 ON CALL PAY 2,165.77 2,080.00 2,160.00 4,160.00 2,080.00 100.0% 01-51015-47-00 OVERTIME 5,224.81 3,000.00 3,717.37 3,000.00 - 0.0% 01-51016-47-00 PHONE ALLOWANCE 480.00 680.00 480.00 480.00 (200.00) -29.4% 01-51020-47-00 UNEMPLOYMENT TAX 191.26 180.00 717.28 522.00 342.00 190.0% 01-51030-47-00 SOCIAL SECURITY MEDICARE 3,600.52 4,104.00 4,125.73 4,281.00 177.00 4.3% 01-51040-47-00 RETIREMENT 4,202.57 3,807.00 3,756.07 3,106.00 (701.00) -18.4% 01-51060-47-00 HEALTH-LIFE INSURANCE 5,372.44 5,250.00 5,195.38 5,251.00 1.00 0:0% 01-51070-47-00 WORKERS COMPENSATION 951.60 1,270.00 1,161.69 1,324.00 54.00 4.3% SALARIES AND BENEFITS 62,558.82 68,255.00 69,058.06 70,440.00 2,185.00 3.2% 01-52630-47-00 TRAVEL AND TRAINING - 1,000.00 709.00 1,000.00 - 0.0% 01-52710-47-00 PROFESSIONAL SERVICES 4,922.48 6,000.00 3,940.83 7,500.00 1,500.00 25.0% 01-52810-47-00 UTILITIES 2,201.37 2,750.00 3,553.93 2,750.00 - 0.0% SERVICES,UTILITIES AND TRAINING 7,123.85 9,750.00 8,203.76 11,250.00 1,500.00 15.4% 01-53090-47-00 UNIFORMS 1,019.65 500.00 500.90 500.00 - 0.0% 01-53095-47-00 SAFETY SUPPLIES/EQUIPMENT - 500.00 460.85 500.00 - .0.0% 01-53210-47-00 OFFICE SUPPLIES - 500.00 387.56 750.00 250.00 .50.0% 01-53225-47-00 OFFICE MACHINERY AND EQUIPMENT 1,903.77 500.00 462.45 1,200.00 700.00 140.0% 01-53270-47-00 OPERATING SUPPLIES 4,593.57 3,000.00 5,732.40 5,000.00 2,000.00 66.7% 01-53410-47-00 BUILDING MAINTENANCE 373.49 750.00 401.75 750.00 - 0.0% 01-53450-47-00 VEHICLE OPERATION - - - - - 01-53455-47-00 VEHICLE FUEL 1,973.73 2,500.00 2,120.33 3,000.00 500.00 .20.0% 01-53470-47-00 VEHICLE REPAIR 90.22 1,000.00 1,307.14 1,250.00 250.00 25.0% GENERAL SUPPLIES AND REPAIR 9,954.43 9,250.00 11,373.38 12,950.00 3,700.00 40.0% 01-54900-47-00 NON CAPITAL OUTLAY<$9,999 7,920.73 11,500.00 10,496.75 - (11,500.00) -100.0% 01-54910-47-00 CAPITAL OUTLAY - 12,000.00 11,978.00 - (12,000.00) -100.0% 01-54930-47-00 COMMUNICATION EQUIPMENT - - - - - CAPITAL AND NON-CAPITAL OUTLAY 7,920.73 23,500.00 22,474.75 - (23,500.00) -100.0% SUBTOTAL ANIMAL CONTROL 87,557.83 110,755.00 111,109.95 94,640.00 (16,115.00) -14.6% FULL TIME OFFICER SALARY AND BENEFITS - - - 26,682.14 26,682.14 EQUIPMENT AND SUPPLIES - - - 6,000.00 6,000.00 SUBTOTAL ADDITIONAL PERSONNEL - - - 32,682.14 32,682.14 TOTAL ANIMAL CONTROL 87,557.83 110,755.00 111,109.95 127,322.14 16,567.14 15.0% 45 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 48—Parks Function: The primary responsibility of Parks is to maintain all city parks and facilities. This includes maintenance of all city facilities and Main Street to include mowing, landscape maintenance,special turf maintenance and general repairs and maintenance. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Crew Leader 1 1 1 Labor I and ll * 6 6 6 7 7 7 *The Parks department budget also includes 1 seasonal part-time position. 46 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG PARKS 01-51010-48-00 SALARIES 173,118.47 190,269.00 161,749.69 193,045.00 2,776.00 1.5% 01-51011-48-00 LONGEVITY 1,200.00 2,400.00 960.00 1,800.00 (600.00) -25.0% 01-51015-48-00 OVERTIME 1,853.17 5,000.00 2,617.43 5,000.00 - 0.0% 01-51016-48-00 PHONE ALLOWANCE 480.00 480.00 480.00 480.00 - 0.0% 01-51020-48-00 UNEMPLOYMENT TAX 1,129.81 720.00 2,432.84 2,088.00 1,368.00 190.0% 01-51030-48-00 SOCIALSECURITY-MEDICARE 12,830.78 15,158.00 12,283.62 15,325.00 167.00 1.1% 01-51040-48-00 RETIREMENT 18,221.42 19,135.00 16,083.18 16,638.00 (2,497.00) -13.0% 01-51060-48-00 HEALTH/LIFE INSURANCE 32,106.69 36,636.00 29,088.13 36,637.00 1.00 0.0% 01-51070-48-00 WORKERS COMPENSATION 5,466.96 4,988.00 4,592.60 5,043.00 55.00 1.1% 01-51099-46-00 SALARY SAVINGS - - - (3,000.00) (3,000.00) SALARIES AND BENEFITS 246,407.30 274,786.00 230,287.49 273,056.00 (1,730.00) -0.6% 01-52610-48-00 CONTRACT SERVICES - - 85.60 100.00 100.00 01-52625-48-00 ADVERTISING 416.62 - - - - 01-52630-48-00 TRAVEL AND TRAINING 864.00 2,000.00 581.74 1,000.00 (1,000.00) -50.0% 01-52710-48-00 PROFESSIONAL SERVICES - 5,000.00 - 1,000.00 (4,000.00) -80,0% 01-52810-48-00 UTILITIES 78;445.95 50,000.00 49,546.10 55,000.00 5,000.00 10.0% 01-52820-48-00 TELEPHONE 1,179.52 1,500.00 1,158.32 1,200.00 (300.00) -20.0% SERVICES,UTILITIES AND TRAINING 80,906.09 58,500.00 51,371.76 58,300.00 (200.00) -0.3% 01-53090-48-00 UNIFORMS 4,991.22 5,000.00 4,639.42 5,000.00 - 0.0% 01-53095-48-00 SAFETY SUPPLIES AND EQUIPMENT 1,364.09 2,500.00 2,042.33 2,000.00 (500.00) -20.0% 01-53210-48-00 OFFICE SUPPLIES 574.82 500.00 150.00 250.00 (250.00) -50.0% 01-53277-48-00 RENTAL - 1,500.00 761.25 1,500.00 - 0.0% 01-53280-48-00 MINOR TOOLS AND EQUIPMENT 4,037.51 3,500.00 2,046.08 2,000.00 (1,500.00) -42.9% 01-53370-48-00 PARK MAINTENANCE/REPAIR 10,547.80 7,000.00 9,655.06 10;000.00 3,000.00 42.9% 01-53380-48-00 BOTANICAL SUPPLIES 22,795.17 15,000.00 12,472.90 15,000.00 - 0.0% 01-53390-48-00 PARK SUPPLIES 5,340.17 1,500.00 1,346.96 1,500.00 - 0.0% 01-53400-48-00 CIBOLOFEST EXPENSE 8,530.93 - - - - 01-53410-48-00 BUILIDING MAINTENENACE 1,190.18 1,500.00 1,220.83 1,500.00 - 0.0% 01-53440-48-00 MACHINERY MAINTENANCE - - 148.35 - - 01-53445-48-00 MACHINERY REPAIR 6,774.12 6,000.00 9,402.32 6,000.00 - 0.0% 01-53450-48-00 VEHICLE OPERATION - - - - - 01-53455-48-00 VEHICLE FUEL 14,191.54 17,700.00 13,194.60 15,000.00 (2,700.00) -15.3% 01-53470-48-00 VEHICLE REPAIR 5,352.58 4,000.00 2,614.14 3,000.00 (1,000.00) -25.0% GENERAL SUPPLIES AND REPAIRS 85,690.13 65,700.00 59,694.24 62,750.00 (2,950.00) -4.5% 01-54900-48-00 NON CAPITAL OUTLAY<$9,999 20,107.40 - 6,797.08 7,000.00 7,000.00 01-54910-48-00 CAPITAL OUTLAY 22,749.00 - - - - 01-54930-48-00 COMMUNICATION EQUIPMENT 1,075.51 - 50.00 .5,000.00 5,000.00 CAPITAL AND NON-CAPITAL OUTLAY 43,931.91 - 6,847.08 12,000.00 12,000.00 PARKS&FACILITY MAINTENANCE 456,935.43 398,986.00 348,200.57 406,106.00 7,120.00 1.8% 47 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG MULTI-EVENT CENTER - 01-52610-48-02 CONTRACT SERVICES - 1,500.00 - 200.00 (1,300.00) -86.7% 01-52810-48-02 UTILITIES - 10,000.00 17,034.03 17,000.00 7,000.00 70.0% SERVICE,UTILITIES AND TRAINING - 11,500.00 17,034.03 17,200.00 5,700.00 49.6% 01-53277-48-02 RENTAL - 500.00 - - (500.00) -100.0% 01-53370-48-02 PARK MAINTENANCE/REPAIR - 1;000.00 484.51 1,000.00 - 0.0% 01-53380-48-02 BOTANICAL SUPPLIES - 15,000.00 6,348.52 10,000.00 (5,000.00) -33.3% 01-53390-48-02 PARK SUPPLIES - 3,500.00 - - (3,500.00) -100.0% 01-53410-48-02 BUILDING MAINTENANCE - 500.00 366.84 500.00 - 0.0% GENERAL SUPPLIES AND REPAIRS - 20,500.00 7,199.87 11,500.00 (9,000.00) -43.9% MULTI-EVENT FACILITY - 32,000.00 24,233.90 28,700.00 (3;300.00) -10.3% SCHLATHER PARK 01-52810-48-03 UTILITIES - - 11,548.06 10,b00.00 10,000.00 SERVICE,UTILITIES AND TRAINING - - 11,548.06 10,000.00 10,000.00 SCHLATHER PARK - - 11,548.06 10,000.00 10,000.00 PARKS AND FACILITY MAINTENANCE 456,935.43 430,986.00 383,982.53 444,806.00 13,820.00 3.2% 49 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 49-Economic Development Function: The primary responsibility of Economic Development is to attract retain, and expand desirable jobs and development for Cibolo that enhances quality of life. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Economic Development Director* 1 1 0 *position was moved to the Economic Development fund to consolidate cost centers. 50 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG ECONOMIC DEVELOPMENT 01-51010-49-00 SALARIES 68,461.62 77,500.00 77,499.78 - (77,500.00) -100.0% 01-51011-49-00 LONGEVITY - 120.00 120.00 - (120.00) -100.0% 01-51016-49-00 PHONE ALLOWANCE 600.00 720.00 720.00 - (720.00) -100.0% 01-51020-49-00 UNEMPLOYMENT TAX 261.00 90.00 261.00 - (90.00) -100.0% 01-51030-49-00 SOCIAL SECURITY-MEDICARE 5,283.21 5,993.00 5,995.10 - (5,993.00) -100.0% 01-51040-49-00 RETIREMENT 7,429.40 8,002.00 7,985.50 - (8,002.00) -100.0% 01-51060-49-00 HEALTH-LIFE INSURANCE 4,547.56 5,342.00 5,090.75 - (5,342.00) -100.0% 01-51070-49-00 WORKERS COMPENSATION 194.64 208.00 188.99 - (208.00) -100.0% SALARIES AND BENEFITS 86,777.43 97,975.00 97,861.12 - (97,975.00) -100.0% 01-52620-49-00 PUBLICATIONS - - - - - 01-52630-49-00 TRAVEL AND TRAINING 1,873.86 3,500.00 52.50 - (3,500.00) -100.0% 01=52635-49-00 DUES,FEES AND PERMITS 4,300.00 - 617.00 - - 01-52710-49-00 PROFFESIONAL SERVICES - - - - - 01-52750-49-00 MARKETING&BUSINESS SERVICES 4,449.24 15,000.00 15,000.00 - (15,000.00) -100.0% SERVICES,UTILITIES AND TRAINING 10,623.10 18,500.00 15,669.50 - (18,500.00) -100.0% 01-53210-49-00 OFFICE SUPPLIES 837.96 800.00 456.26 - (800.00) -100.0% 01-53215-49-00 PRINTING - 5,000.00 - - (5,000.00) -100.0% 01-53225-49-00 OFFICE MACHINERY AND EQUIPMENT 3.27 - - - - 01-53240-49-00 POSTAGE 3.30 400.00 32.30 - (400.00) -100.0% 01-53455-49-00 VEHICLE FUEL 367.71 1,500.00 883.69 - (1,500.00) -100.0% 01-53470-49-00 VEHICLE REPAIR 54.00 500.00 80.25 - (500.00) -100.0% GENERAL SUPPLIES AND REPAIR 1,266.24 8,200.00 1,452.50 - (8,200.00) -100.0% TOTAL ECONOMIC DEVELOPMENT 98,666.77 124,675.00 114,983.12 - (124,675.00) -100.0% 51 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 50-Finance Function: The primary responsibility of Finance is to maintain the City's accounting and financial systems including accounts payable, accounts receivable, payroll, cash management, and fixed assets. The department is also responsible for purchasing and utility billing and collections. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Finance Director 1 1 1 Finance Assistant 1 1 1 Purchasing Agent 1 1 1 3 3 3 52 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG FINANCE 01-51010-50-00 SALARIES 153,182.35 141,990.00 141,345.68 141,991.00 1.00 0.0% 01-51011-50-00 LONGEVITY 360.00 720.00 720.00 1,080.00 360.00 50.0% 01-51016-50-00 PHONE ALLOWANCE 600.00 720.00 720.00 720.00 - 0.0% 01-51020-50-00 UNEMPLOYMENT 332.49 270.00 998.37 783.00 513.00 190.0% 01-51030-50-00 SOCIAL SECURITY-MEDICARE 11,672.55 10,972.00 10,817.94 11,000.00 28.00 0.3% 01-51040-50-00 TMRS 16,343.03 14,651.00 14,552.43 13,063.00 (1,588.00) -10.8% 01-51060-50-00 HEALTH-LIFE INSURANCE 14,144.77 15,836.00 15,130.73 15,837.00 1.00 0.0% 01-51070-50-00 WORKERS COMPENSATION 397.20 386.00 349.53 382.00 (4.00) -1.0% SALARIES AND BENEFITS 197,032.39 185,545.00 184,634.68 184,856.00 (689.00) -0.4% 01-52200-50-00 DATA PROCESSING 187.28 - - - - 01-52610-50-00 CONTRACT SERVICES 3,811.06 5,000.00 3,937.14 5,000.00 - 0.0% 01-52616-50-00 EMPLOYMENT COSTS 1,694.50 - - - - 01-52630-50-00 CONFERENCE/TRAVEL/TRAINING 2,877.94 3,000.00 3,258.55 3,600.00 600.00 20.0% 01-52635-50-00 DUES,FEES AND PERMITS 335.00 750.00 135.00 350.00 (400.00) -53.3% 01-52670-50-00 GCAD/GCTAC 61,623.46 62,500.00 61,178.58 62,500.00 - 0.0% 01-52710-50-00 DEVELOPMENT REVIEW 10,500.00 12,000.00 15,750.00 15,000.00 3,000.00 25.0% 01-52720-50-00 AUDIT SERVICES 7;755.00 11,500.00 .11,306.25 12,000.00 500.00 4.3% SERVICES,UTILITIES AND TRAINING 88,784.24 94,750.00 95,565.52 98,450.00 3,700.00 3.9% 01-53210-50-00 OFFICE SUPPLIES 1,605.44 1,500.00 .1,906.49 2,000.00 500.00 33.3% 01-53225-50-00 OFFICE MACHINERY/EQUIPMENT 400.00 500.00 - 1,500.00 1,000.00 200.0% 01-53240-50-00 POSTAGE 917.85 1,000.00 1,000.00 1,000.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 2,923.29 3,000.00 2,906.49 4,500.00 1,500.00 50.0% FINANCE 288,739.92 283,295.00 283,106.69 287,806.00 4,511.00 1.6% 53 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 51—Information Technology Function: The Information technology budget was created to reflect expenses that are technology related. These costs benefit all city departments. Expenses were previously charged to the city non- departmental budget. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 IT Administrator 0 0 1 Proposed Capital: VOIP Phone System for City Hall $17,750.00 54 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CNG INFORMATION TECHNOLOGY 01-51010-51-00 SALARIES - - - 47,008.00 47,008.00 01-51011-51-00 LONGEVITY - - - 240.00 240.00 01-51016-51-00 PHONE ALLOWANCE - - - 480.00 480.00 01-51020-51-00 UNEMPLOYMENT - - - 261.00 261.00 01-51030-51-00 SOCIALSECURITY-MEDICARE - - - 3,651.00 3,651.00 01-51040-51-00 TMRS - - - 4,336.00 4,336.00 01-51060-51-00 HEALTH-LIFE INSURANCE - - - 5,279.00 5,279.00 01-51070-51-00 WORKERS COMPENSATION - - - 127.00 127.00 SALARIES AND BENEFITS - - - 61,382.00 61,382.00 01-52610-51-00 CONTRACT SERVICES - - - 21,000.00 21,000.00 01-52630-51-00 CONFERENCE/TRAVEL/TRAINING - - - 3,500.00 3,500.00 01-52635-51-00 DUES,FEES AND PERMITS - - - 500.00 500.00 01-52710-51-00 PROFESSIONAL SERVICES - - - 5,000.00 5,000.00 01-52820-51-00 TELEPHONE - - - - - SERVICES,UTILITIES AND TRAINING - - - 30,000.00 30,000.00 01-53210-51-00 OFFICE SUPPLIES - - - 1,000.00 1,000.00 01-53225-51-00 OFFICE MACHINERY AND EQUIPMENT - - - 5,000.00 5,000.00 01-53230-51-00 OTHER SUPPLIES - - - 2,000.00 2,000.00 01-53240-51-00 POSTAGE - - - - - 01-53277-51-00 RENTAL - - - - 01-53280-51-00 MINOR TOOLS&EQUIPMENT - - - 1,000.00 1,000.00 01-53410-51-00 BUILDING MAINTENANCE - - - - - 01-53430-51-00 OFFICE EQUIPMENT REPAIR - - - 1,500.00 1,500.00 GENERAL SUPPLIES AND REPAIRS - - - 10,500.00 10,500.00 01-54900-51-00 NON CAPITAL OUTLAY<$9,999 - - - - - 01-54910-51-00 CAPITAL OUTLAY - - - 17,750.00 17,750.00 CAPITAL AND NON-CAPITAL OUTLAY - - - 17,750.00 17,750.00 TOTAL INFORMATION TECHNOLOGY - - - 119,632.00 119,632.00 55 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 53—Fire Department Function: The primary responsibility of the Fire Department, in conjunction with the Cibolo Volunteer Fire Department, is to provide continuous fire protection to the City of Cibolo and areas of Guadalupe County. The Fire Department budget includes funding for the Cibolo Volunteer Fire Department and Schertz Emergency Medical Services contract. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Fire Chief/Public Works/Utilities 1 1 1 Fire Marshall 1 1 1 Fire Apparatus Operator 3 3 3 Firefighter 7 7 7 Fire Lieutenants 0 0 3 12 12 15 56 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG FIRE DEPARTMENT 01-51010-53-00 SALARIES 381,380.92 492,334.00 460,289.00 456,843.00 (35,491.00) -7.21% 01-51011-53-00 LONGEVITY 2,160.00 3,480.00 3,480.00 4,800.00 1,320.00 37.93% 01-51014-53-00 ON CALL PAY - - - - - 01-51015-53-00 OVERTIME 35,989.89 40,000.00 43,905.76 42,300.00 2,300.00 5.75% 01-51016-53-00 PHONE ALLOWANCE 1,200.00 1,200.00 1,200.00 1,200.00 - 0.00% 01-51020-53-00 UNEMPLOYMENT TAX 1,329.02 990.00 4,388.30 3,132.00 2,142.00 216.36% 01-51030-53-00 SOCIAL SECURITY-MEDICARE 31,891.28 38,562.00 38,566.20 38,643.00 81.00 0.21% 01-51040-53-00 RETIREMENT 44,233.79 51,492.00 50,515.33 44,451.00 (7,041.00) -13.67% 01-51060-53-00 HEALTH-LIFE INSURANCE 46,316.43 57,910.00 53,898.44 57,989.00 79.00 0.14% 01-51070-53-00 WORKERS COMPENSATION 7,844.52 9,173.00 8,669.21 9,850.00 677.00 7.38% SALARIES AND BENEFITS 552,345.85 695,141.00 664,912.24 659,208.00 (35,933.00) -5.17% 01-52610-53-00 CONTRACT SERVICES 4,550.98 13,000.00 8,917.43 13,000.00 - 0.00% 01-52620-53-00 PUBLICATIONS 46.30 300.00 152.50 200.00 (100.00) -33.33% 01-52630-53-00 TRAVEL AND TRAINING 2,096.82 3,000.00 2,519.89 2,500.00 (500.00) -16.67% 01-52635-53-00 DUES,FEES AND PERMITS 2,155.00 3,100.00 1,815.00 2,500.00 (600.00) -19.35% 01-52710-53-00 PROFESSIONAL SERVICES - - - - - 01-52780-53-00 MEDICAL&LAB - 2,000.00 2,000.00 2,000.00 - 0.00% 01-52810-53-00 UTILITIES 15,908.63 15,000.00 13,275.57 15,000.00 - 0.0.0% 01-52820-53-00 TELEPHONE 2,013.28 2,040.00 2,863.26 3,000.00 960.00 47.06% SERVICES,UTILITIES AND TRAINING 26,771.01 38,440.00 31,543.65 38,200.00 (240.00) -0.62% 01-53090-53-00 CLOTHING 5,936.87 8,000.00 6,086.18 8,000.00 - 0.00% 01-53095-53-00 SAFETY SUPPLIES AND EQUIPMENT 3,584.50 3,000.00 2,999.43 3,000.00 - 0.00% 01-53210-53-00 OFFICE SUPPLIES 1,204.65 1,000.00 804.70 1,000.00 - 0.00% 01-53215-53-00 PRINTING 202.80 300.00 300.00 300.00 - 0.00% 01-53220-53-00 JANITORAL SUPPLIES 524.16 500.00 246.32 400.00 (100.00) -20.00% 01-53225-53-00 OFFICE MACHINERY AND EQUIPMENT 515.49 - - - - 01-53240-53-00 POSTAGE 206.48 200.00 195.69 200.00 - 0.00% 01-53250-53-00 OFFICER'S EQUIPMENT-SUPPLIES - - - - - 01-53280-53-00 MINOR TOOLS AND EQUIPMENT 3,962.85 3,000.00 2,999.02 3,000.00 - 0.00% 01-53450-53-00 VEHICLE OPERATION - - - - - 01-53455-53-00 VEHICLE FUEL 15,203.88 15,000.00 17,408.89 16,000.00 1,000.00 6.67% 01-53470-53-00 VEHICLE REPAIR 852.84 3,500.00 3,499.17 3,500.00 - 0.00% GENERAL SUPPLIES AND REPAIRS 32,194.52 34,500.00 34,539.40 35,400.00 900.00 2.61% 01-54900-53-00 NON CAPITAL OUTLAY<$9,999 5,069.49 - - 39,000.00 39,000.00 01-54910-53-00 CAPITAL OUTLAY 475,655.30 - - - - 01-54930-53-00 COMMUNICATION EQUIPMENT 839.95 - - 2,000.00 2,000.00 CAPITAL AND NON-CAPITAL OUTLAY 481,564.74 - - 41,000.00 41,000.00 01-55742-53-00 SCHERTZ EMS CONTRACT 213,300.00 235,000.00 235,000.00 230,000.00 (5,000.00) -2.13% 01-55745-53-00 CIBOLO VOL FIRE DEPARTMENT 215,000.04 215,000.00 215,000.00 225,000.00 10,000.00 4.65% OTHER EXPENSES 428,300.04 450,000.00 450,000.00 455,000.00 5,000.00 1.11% SUBTOTAL FIRE DEPARTMENT 1,521,176.16 1,218,081.00 1,180,995.29 1,228,808.00 10,727.00 0.88% FIRE LIEUTENANT(3) SALARY AND BENEFITS - - - 190,215.75 190,215.75 EQUIPMENT AND SUPPLIES - - - 13,500.00 13,500.00 SUBTOTAL ADDITIONAL PERSONNEL. - - - 203,715.75 203,715.75 TOTAL FIRE DEPARTMENT 1,521,176.16 1,218,081.00 1,180,995.29 1,432,523.75 214,442.75 17.60% 57 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 General Fund 99—Non-Departmental Function: The non-departmental budget was created to reflect expenses that are not department specific, but benefit all city departments. Expenses were previously charged to the city administration budget. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 IT Administrator* 0 1 0 *moved to a separate departmental budget 58 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG NON-DEPARTMENTAL 01-51010-99-00 SALARIES - 47,000.00 47,154.90 - (47,000.00) -100.0% 01-51011-99-00 LONGEVITY - 120.00 120.00 - (120.00) -100.0% 01-51016-99-00 PHONE ALLOWANCE - 720.00 480.00 - (720.00) -100.0% 01-51020-99-00 UNEMPLOYMENT - 90.00 362.00 - (90.00) -100.0% 01-51030-99-00 SOCIALSECURITY-MEDICARE - 3,660.00 3,653.03 - (3,660.00) -100.0% 01-51040-99-00 TMRS - 4,887.00 4,868.22 - (4,887.00) -100.0% 01-51060-99-00 HEALTH-LIFE INSURANCE - 5,279.00 5,041.93 - (5,279.00) -100.0% 01-51070-99-00 WORKERS COMPENSATION - 127.00 114.73 - (127.00) -100.0% SALARIES AND BENEFITS - 61,883.00 61,794.81 - (61,883.00) -100.0% 01-52610-99-00 CONTRACT SERVICES 49,054.21 61,500.00 42,358.87 41,400.00 (20,100.00) -32.7% 01-52630-99-00 CONFERENCE/TRAVEL/TRAINING - 2,500.00 - - (2,500.00) -100.0% 01=52635-99-00 DUES,FEES AND PERMITS - 500.00 575.74 225.00 (275.00) -55.0% 01-52650-99-00 GENERAL LIABILITY INSURANCE 47,098.31 46,800.00 63,161.63 65,000.00 18,200.00 38.9% 01-52710-99-00 DEVELOPMENT REVIEW 710.00 - - - 01-52810-99-00 UTILITIES 29,463.72 32,000.00 30,309.55 30,000.00 (2,000.00) -6.3% 01-52815-99-00 CPS-STREET LIGHT UTILITIES 1,150.46 1,000.00 982.68 1,000.00 - 0.0% 01-52820-99-00 TELEPHONE 27,753.08 22,800.00 .17,206.47 18,000.00 (4,800.00) -21.1% SERVICES,UTILITIES AND TRAINING 155,229.78 167,100.00 154,594.94 155,625.00 (11,475.00) -6.9% 01-53220-99-00 JANITORAL SUPPLIES 38.98 100.00 87.98 100.00 - 0.0% 01-53230-99-00 OTHER SUPPLIES 2,942.80 7,000.00 11,185.03 3,000.00 (4,000.00) -57.1% 01-53240-99-00 POSTAGE - - 50.71 50.00 50.00 01-53277-99-00 RENTAL - - 205.00 205.00 205.00 01-53410-99-00 BUILDING MAINTENANCE 6,860.26 20,000.00 11,810.01 20,000.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 9,842.04 27,100.00 23,338.73 23,355.00 (3,745.00) -13.8% 01-54910-99-00 CAPITAL OUTLAY 2,849.48 125,000.00 99,970.00 15,000.00 (110,000.00) -88.0% CAPITAL AND NON-CAPITAL OUTLAY 2,849.48 125,000.00 99,970.00 15,000.00 (110,000.00) -88.0% 01-55730-99-00 LIBRARY DONATIONS 20,000.00 20,000.00 20,000.00 25,000.00 5,000.00 25.0% 01-55980-99-00 XFER TO CAPITAL REPLACEMENT 242,915.60 - 35,000.00 - - 01-55985-99-00 TRANSFER OUT-EDC - - - 123,841.00 123,841.00 01-55986-99-00 TRN SALES TAX TO DEBT SERVICE - - - - - 01-55987-99-00 TRANSFER OUT-2007 GO TAX - - - - - OTHER EXPENSES 262,915.60 20,000.00 55,000.00 148,841.00 128,841.00 644.2% 01-52615-99-70 CONTRACT MAINTENANCE 8;945.33 - - - - 01-54900-99-72 NON.CAPITAL OUTLAY<$9,999 438.00 - - - - 01-54910-99-72 CAPITAL OUTLAY-NIEMIETZPARK - 45,000.00 32,765.36 - (45,000.00) -100.0% 01-54910-99-73 CAPITAL OUTLAY-HVAC CITY HAL - 57,500.00 58,155.00 - (57,500.00) -100.0% GRANT EXPENSES 9,383.33 102,500.00 90,920.36 - (102,500.00) -100.0% TOTAL NON-DEPARTMENTAL 440,220.23 503,583.00 485,618.84 342,821.00 (160,762.00) -31.9% 59 OF C's o: *0 4- ,d * tr 10* I. .a .e I $ 9.£ x As "City of Choice" DEBT SERVICE FUND The Debt Service fund is used to account for ad valorem taxes assessed and collected for the purpose of servicing long-term debt of the governmental funds. 61 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 i DEBT SERVICE FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET BEGINNING FUND BALANCE 86,224 200,495 200,495 198,448 REVENUES: PROPERTY TAXES 1,901,616 2,104,500 2,131,160 2,291,700 INTEREST,TRANSFERS,MISCELLANEOUS 1,008,188 117,817 116,759 120,034 SUBTOTAL REVENUES 2,909,803 2,222,317 2,247,919 2,411,734 TOTAL AVAILABLE 2,996,027 2,422,812 2,448,414 2,610,182 EXPENDITURES: DEBT SERVICE 1,872,071 2,207,842 2,248,466 2,283,626 OTHER FINANCING USES 923,461 2,500 1,500 1,500 SUBTOTAL EXPENDITURES 2,795,532 2,210,342 2,249,966 2,285,126 ENDING FUND BALANCE 200,495 212,470 198,448 325,057 62 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG DEBT SERVICE FUND REVENUES 03-31100-00 PROPERTY TAXES-CURRENT 1,884,353.91 2,084,500.00 2,105,579.82 2,265,000.00 180,500.00 9% 03-31120-00 PROPERTYTAXES-DELINQUENT 10,748.58 15,000.00 16,367.39 17,200.00 2,200.00 15% 03-31130-00 PROPERTY TAXES-PENALTY AND INT 6,513.37 5,000.00 9,212.60 9,500.00 4,500.00 90% 03-35100-00 INTEREST 783.50 1,500.00 442.08 450.00 (1,050.00) -70% 03-35242-00 TRANSFER FROM ECONOMIC DEV COR 87,404.00 116,317.00 116,317.00 119,584.00 3,267.00 3% 03-35250-00 BOND PROCEEDS 920,000.00 - - - - 03-35300-00 TRANS FROM GENERAL FUND - - - - - TOTAL REVENUE 2,909,803.36 2,222,317.00 2,247,918.89 2,411,734.00 189,417.00 9% EXPENDITURES 03-50100-00 BOND ISSUANCE COSTS 30,592.28 - - - - 03-50200-00 PAYMENT TO ESCROW AGENT 891,668.75 - - - 03-52725-00 PAYING AGENT FEES 900.00 2,500.00 1,500.00 1,500.00 (1,000.00) -40% 03-59010-00 2001 SERIES-PRINCIPAL 65,000.00 - - - - 03-59011-00 2001 SERIES-INTEREST 1,543.75 - - - - 03-59030-00 2003 CERT OF OBLIGATION-PRINC 85,000.00 85,000.00 85,000.00 90,000.00 5,000.00 6% 03-59031-00 2003 CERT OF OBLIGATION-INTRST 23,875.00 20,475.00 20,475.00 17,200.00 (3,275.00) -16% 03-59070-00 2007 GENERAL OBLIG-PRINCIPAL 300,000.00 320,000.00 320,000.00 330,000.00 10,000.00 3% 03-59071-00 2007 GENERAL OBLIG-INTEREST 331,264.18 317,475.00 317,475.00 302,850.00 (14,625.00) -5% 03-59080-00 2008 CERT OF OBLIG-PRINCIPAL 20,000.00 50,000.00 50,000.00 55,000.00 5,000.00 10% 03-59081-00 2008 CERT OF OBLIG-INTEREST 67,397.51 66,317.00 66,317.00 64,584.25 (1,732.75) -3% 03-59090-00 2009 GENERAL OBLIG-PRINCIPAL 505,000.00 175,000.00 175,000.00 180,000.00 5,000.00 3% 03-59091-00 2009 GENERAL OBLIG-INTEREST 432,217.50 423,718.00 423,717.50 418,830.00 (4,888.00) -1% 03-59100-00 2010 GO REFUNDING BDS-PRINC 25,000.00 80,000.00 80,000.00 85,000.00 5,000.00 6% 03-59101-00 2010 GO REFUNDING BDS-INTRST 15,773.34 22,951.00 22,951.00 21,731.25 (1,219.75) -5% 03-59110-00 2011 GENERAL OBLIG-PRINCIPAL - 320,000.00 435,000.00 475,000.00 155,000.00 48% 03-59111-00 2011 GENERAL OBLIG-INTEREST - 326,906.00 252,530.00 243,430.00 (83,476.00) -26% 03-50000-41 BOND REFUNDING FEES 300.00 - - - - TOTAL EXPENDITURES 2,795,532.31 2,210,342.00 2,249,965.50 2,285,125.50 74,783.50 3% TOTAL DEBT SERVICE 114,271.05 11,975.00 (2,046.61) 126,608.50 114,633.50 957% 63 DEBT SERVICE SCHEDULES 0 f.. Cl .Abb A 01111 - SkJ .. ...„ .. .. 1. 0 4go r -= 0 .... ... ..... * ... _ .... _ 4 = / Alp .4: 4- - if. s. At no •.0„,—,001--- 7* ,r,, •„ k S Ls* A 'City of of Choice" 65 City of Cibolo,Texas Debt Service Summary For Fiscal Year Ending September 30,2013 General Fund Debt Service GO Imp.& GO Ref FY Ending CO's Series Ref.Bonds GO Bonds Bonds Series GO Bonds Total Debt 30-Sep 2003 Series 2007 Series 2009 2010 Series 2011 Service 2013 $107,200 $632,850 $598,830 $106,731 $718,430 $2,164,041 2014 $113,750 $637,550 $598,355 $105,269 $575,280 $2,030,204 2015 $109,938 $631,575 $597,255 $103,569 $578,380 $2,020,717 2016 $106,000 $634,925 $595,518 $106,549 $576,330 $2,019,322 2017 $102,000 $632,488 $598,518 $104,195 $579,130 $2,016,331 2018 $629,375 $973,030 $106,500 $576,780 $2,285,685 2019 $635,363 $973,730 $103,484 $579,280 $2,291,857 2020 $635,338 $973,430 $100,230 $576,053 $2,285,051 2021 $629,525 $977,030 $96,772 $575,700 $2,279,027 2022 $632,813 $974,180 $578,625 $2,185,618 2023 $634,975 $974,500 $576,175 $2,185,650 2024 $626,238 $977,723 $578,350 $2,182,311 2025 $626,600 $973,785 $578,950 $2,179,335 2026 $630,725 $972,620 $577,938 $2,181,283 2027 $623,725 $973,935 $580,100 $2,177,760 2028 $973,450 $575,400 $1,548,850 2029 $976,488 $579,900 $1,556,388 2030 $578,500 $578,500 2031 $576,300 $576,300 Totals $538,888 $9,474,065 $14,682,377 $933,298 $11,115,601 $36,744,229 Utility System Debt Service Water Meters Sales Tax Debt Service Revenue GO Imp& Revenue FY Ending Bonds Ref Bonds Total Debt FY Ending Bonds Series FY Ending 30- CO's Series 30-Sep Series 2006 Series 2007 Service 30-Sep 2006 Sep 2008 2013 $163,639 $278,900 $442,539 2013 $63,242 2013 $119,584 2014 $165,281 $251,700 $416,981 2014 $61,003 2014 $122,567 2015 $166,720 $254,725 $421,445 2015 $63,663 2015 $120,350 2016 $172,853 $257,300 $430,153 2016 $61,221 2016 $132,739 2017 $212,867 $215,438 $428,305 Totals $249,129 2017 $134,637 2018 $211,864 $214,250 $426,114 2018 $131,325 2019 $210,657 $212,838 $423,495 2019 $132,818 2020 $214,145 $216,088 $430,233 2020 $134,028 2021 $212,328 $214,000 $426,328 2021 $134,948 2022 $210,307 $216,575 $426,882 2022 $135,569 2023 $212,981 $213,813 $426,794 2023 $135,873 2024 $210,350 $210,825 $421,175 2024 $135,869 2025 $212,414 $212,500 $424,914 2025 $130,693 2026 $209,172 $213,725 $422,897 2026 $135,224 2027 $209,613 $209,613 2027 $134,337 Totals $2,785,578 $3,392,290 $6,177,868 2028 $133,159 Totals $2,103,720 66 BOND DEBT SERVICE City of Cibolo,Texas Certificates of Obligation,Series 2003 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 2/1/2013 90,000 3.500% 9,387.50 99,387.50 8/1/2013 7,812.50 7,812.50 9/30/2013 107,200.00 2/1/2014 100,000 3.750% 7,812.50 107,812.50 8/1/2014 5,937.50 5,937.50 9/30/2014 113,750.00 2/1/2015 100,000 3.875% 5,937.50 105,937.50 8/1/2015 4,000.00 4,000.00 9/30/2015 109,937.50 2/1/2016 100,000 4.000% 4,000.00 104,000.00 8/1/2016 2,000.00 2,000.00 9/30/2016 106,000.00 2/1/2017 100,000 4.000% 2,000.00 102,000.00 9/30/2017 102,000.00 490,000.00 48,887.50 538,887.50 538,887.50 CO's, S-2003, Pg 3 of 15 67 BOND DEBT SERVICE City of Cibolo,Texas Revenue Bonds,Series 2006 Annual Debt Period Ending Principal Coupon Interest Debt Service Service 2/1/2013 135,000 4.070% 47,313.75 182,313.75 8/1/2013 44,566.50 44,566.50 9/30/2013 226,880.25 2/1/2014 140,000 4.070% 44,566.50 184,566.50 8/1/2014 41,717.50 41,717.50 9/30/2014 226,284.00 2/1/2015 150,000 4.070% 41,717.50 191,717.50 8/1/2015 38,665.00 38,665.00 9/30/2015 230,382.50 2/1/2016 160,000 4.070% 38,665.00 198,665.00 8/1/2016 35,409.00 35,409.00 9/30/2016 234,074.00 2/1/2017 145,000 4.070% 35,409.00 180,409.00 8/1/2017 32,458.25 32,458.25 9/30/2017 212,867.25 2/1/2018 150,000 4.070% 32,458.25 182,458.25 8/1/2018 29,405.75 29,405.75 9/30/2018 211,864.00 2/1/2019 155,000 4.070% 29,405.75 184,405.75 8/1/2019 26,251.50 26,251.50 9/30/2019 210,657.25 2/1/2020 165,000 4.070% 26,251.50 191,251.50 8/1/2020 22,893.75 22,893.75 9/30/2020 214,145.25 2/1/2021 170,000 4.070% 22,893.75 192,893.75 8/1/2021 19,434.25 19,434.25 9/30/2021 212,328.00 2/1/2022 175,000 4.070% 19,434.25 194,434.25 8/1/2022 15,873.00 15,873.00 9/30/2022 210,307.25 2/1/2023 185,000 4.070% 15,873.00 200,873.00 8/1/2023 12,108.25 12,108.25 9/30/2023 212,981.25 2/1/2024 190,000 4.070% 12,108.25 202,108.25 8/1/2024 8,241.75 8,241.75 9/30/2024 210,350.00 2/1/2025 200,000 4.070% 8,241.75 208,241.75 8/1/2025 4,171.75 4,171.75 9/30/2025 212,413.50 2/1/2026 205,000 4.070% 4,171.75 209,171.75 9/30/2026 209,171.75 2,325,000.00 709,706.25 3,034,706.25 3,034,706.25 Rev Bonds, S-2006, Pg 4 of 15 68 DETAILED BOND DEBT SERVICE City of Cibolo,Texas Revenue Bonds,Series 2006 Utility System Annual Debt Period Ending Principal Coupon Interest Debt Service Service 2/1/2013 80,000 4.070% 42,633.25 122,633.25 8/1/2013 41,005.25 41,005.25 9/30/2013 163,638.50 2/1/2014 85,000 4.070% 41,005.25 126,005.25 8/1/2014 39,275.50 39,275.50 9/30/2014 165,280.75 2/1/2015 90,000 4.070% 39,275.50 129,275.50 8/1/2015 37,444.00 37,444.00 9/30/2015 166,719.50 2/1/2016 100,000 4.070% 37,444.00 137,444.00 8/1/2016 35,409.00 35,409.00 9/30/2016 172,853.00 2/1/2017 145,000 4.070% 35,409.00 180,409.00 8/1/2017 32,458.25 32,458.25 9/30/2017 212,867.25 2/1/2018 150,000 4.070% 32,458.25 182,458.25 8/1/2018 29,405.75 29,405.75 9/30/2018 211,864.00 2/1/2019 155,000 4.070% 29,405.75 184,405.75 8/1/2019 26,251.50 26,251.50 9/30/2019 210,657.25 2/1/2020 165,000 4.070% 26,251.50 191,251.50 8/1/2020 22,893.75 22,893.75 9/30/2020 214,145.25 2/1/2021 170,000 4.070% 22,893.75 192,893.75 8/1/2021 19,434.25 19,434.25 9/30/2021 212,328.00 2/1/2022 175,000 4.070% 19,434.25 194,434.25 8/1/2022 15,873.00 15,873.00 9/30/2022 210,307.25 2/1/2023 185,000 4.070% 15,873.00 200,873.00 8/1/2023 12,108.25 12,108.25 9/30/2023 212,981.25 2/1/2024 190,000 4.070% 12,108.25 202,108.25 8/1/2024 8,241.75 8,241.75 9/30/2024 210,350.00 2/1/2025 200,000 4.070% 8,241.75 208,241.75 8/1/2025 4,171.75 4,171.75 9/30/2025 212,413.50 2/1/2026 205,000 4.070% 4,171.75 209,171.75 9/30/2026 209,171.75 2,095,000.00 690,577.25 2,785,577.25 2,785,577.25 Rev Bonds, S-2006, Pg 5 of 15 69 DETAILED BOND DEBT SERVICE City of Cibolo,Texas Revenue Bonds,Series 2006 Water Meters Annual Debt Period Ending Principal Coupon Interest Debt Service Service 2/1/2013 55,000 4.070% 4,680.50 59,680.50 8/1/2013 3,561.25 3,561.25 9/30/2013 63,241.75 2/1/2014 55,000 4.070% 3,561.25 58,561.25 8/1/2014 2,442.00 2,442.00 9/30/2014 61,003.25 2/1/2015 60,000 4.070% 2,442.00 62,442.00 8/1/2015 1,221.00 1,221.00 9/30/2015 63,663.00 2/1/2016 60,000 4.070% 1,221.00 61,221.00 9/30/2016 61,221.00 230,000 19,129 249,129 249,129 Rev Bonds, S-2006, Pg 6 of 15 70 BOND DEBT SERVICE City of Cibolo,Texas GO Improvement&Refunding Bonds,Series 2007 Annual Debt Period Ending Principal Coupon Interest Debt Service Service 2/1/2013 500,000 4.500% 211,500.00 711,500.00 8/1/2013 200,250.00 200,250.00 9/30/2013 911,750.00 2/1/2014 500,000 4.500% 200,250.00 700,250.00 8/1/2014 189,000.00 189,000.00 9/30/2014 889,250.00 2/1/2015 520,000 4.500% 189,000.00 709,000.00 8/1/2015 177,300.00 177,300.00 9/30/2015 886,300.00 2/1/2016 550,000 4.500% 177,300.00 727,300.00 8/1/2016 164,925.00 164,925.00 9/30/2016 892,225.00 2/1/2017 530,000 4.500% 164,925.00 694,925.00 8/1/2017 153,000.00 153,000.00 9/30/2017 847,925.00 2/1/2018 550,000 4.500% 153,000.00 703,000.00 8/1/2018 140,625.00 140,625.00 9/30/2018 843,625.00 2/1/2019 580,000 4.500% 140,625.00 720,625.00 8/1/2019 127,575.00 127,575.00 9/30/2019 848,200.00 2/1/2020 610,000 4.500% 127,575.00 737,575.00 8/1/2020 113,850.00 113,850.00 9/30/2020 851,425.00 2/1/2021 630,000 4.500% 113,850.00 743,850.00 8/1/2021 99,675.00 99,675.00 9/30/2021 843,525.00 2/1/2022 665,000 4.500% 99,675.00 764,675.00 8/1/2022 84,712.50 84,712.50 9/30/2022 849,387.50 2/1/2023 695,000 4.500% 84,712.50 779,712.50 8/1/2023 69,075.00 69,075.00 9/30/2023 848,787.50 2/1/2024 715,000 4.500% 69,075.00 784,075.00 8/1/2024 52,987.50 52,987.50 9/30/2024 837,062.50 2/1/2025 750,000 4.500% 52,987.50 802,987.50 8/1/2025 36,112.50 36,112.50 9/30/2025 839,100.00 2/1/2026 790,000 4.500% 36,112.50 826,112.50 8/1/2026 18,337.50 18,337.50 9/30/2026 844,450.00 2/1/2027 815,000 4.500% 18,337.50 833,337.50 9/30/2027 833,337.50 9,400,000.00 3,466,350.00 12,866,350.00 12,866,350.00 GO Imp. and Ref. Bonds, S-2007, Pg 7 of 15 71 DETAILED BOND DEBT SERVICE City of Cibolo,Texas GO Improvement&Refunding Bonds,Series 2007 General Fund Projects Annual Debt Period Ending Principal Coupon Interest Debt Service Service 2/1/2013 160,000 4.500% 75,037.50 235,037.50 8/1/2013 71,437.50 71,437.50 9/30/2013 306,475.00 2/1/2014 170,000 4.500% 71,437.50 241,437.50 8/1/2014 67,612.50 67,612.50 9/30/2014 309,050.00 2/1/2015 175,000 4.500% 67,612.50 242,612.50 8/1/2015 63,675.00 63,675.00 9/30/2015 306,287.50 2/1/2016 185,000 4.500% 63,675.00 248,675.00 8/1/2016 59,512.50 59,512.50 9/30/2016 308,187.50 2/1/2017 190,000 4.500% 59,512.50 249,512.50 8/1/2017 55,237.50 55,237.50 9/30/2017 304,750.00 2/1/2018 200,000 4.500% 55,237.50 255,237.50 8/1/2018 50,737.50 50,737.50 9/30/2018 305,975.00 2/1/2019 210,000 4.500% 50,737.50 260,737.50 8/1/2019 46,012.50 46,012.50 9/30/2019 306,750.00 2/1/2020 220,000 4.500% 46,012.50 266,012.50 8/1/2020 41,062.50 41,062.50 9/30/2020 307,075.00 2/1/2021 225,000 4.500% 41,062.50 266,062.50 8/1/2021 36,000.00 36,000.00 9/30/2021 302,062.50 2/1/2022 240,000 4.500% 36,000.00 276,000.00 8/1/2022 30,600.00 30,600.00 9/30/2022 306,600.00 2/1/2023 250,000 4.500% 30,600.00 280,600.00 8/1/2023 24,975.00 24,975.00 9/30/2023 305,575.00 2/1/2024 260,000 4.500% 24,975.00 284,975.00 8/1/2024 19,125.00 19,125.00 9/30/2024 304,100.00 2/1/2025 270,000 4.500% 19,125.00 289,125.00 8/1/2025 13,050.00 13,050.00 9/30/2025 302,175.00 2/1/2026 285,000 4.500% 13,050.00 298,050.00 8/1/2026 6,637.50 6,637.50 9/30/2026 304,687.50 2/1/2027 295,000 4.500% 6,637.50 301,637.50 9/30/2027 301,637.50 3,335,000.00 1,246,387.50 4,581,387.50 4,581,387.50 GO Imp. and Ref. Bonds, S-2007, Pg 8 of 15 72 DETAILED BOND DEBT SERVICE City of Cibolo,Texas GO Improvement&Refunding Bonds,Series 2007 Public Works Project Annual Debt Period Ending Principal Coupon Interest Debt Service Service 2/1/2013 65,000 4.500% 30,712.50 95,712.50 8/1/2013 29,250.00 29,250.00 9/30/2013 124,962.50 2/1/2014 70,000 4.500% 29,250.00 99,250.00 8/1/2014 27,675.00 27,675.00 9/30/2014 126,925.00 2/1/2015 70,000 4.500% 27,675.00 97,675.00 8/1/2015 26,100.00 26,100.00 9/30/2015 123,775.00 2/1/2016 75,000 4.500% 26,100.00 101,100.00 8/1/2016 24,412.50 24,412.50 9/30/2016 125,512.50 2/1/2017 80,000 4.500% 24,412.50 104,412.50 8/1/2017 22,612.50 22,612.50 9/30/2017 127,025.00 2/1/2018 80,000 4.500% 22,612.50 102,612.50 8/1/2018 20,812.50 20,812.50 9/30/2018 123,425.00 2/1/2019 85,000 4.500% 20,812.50 105,812.50 8/1/2019 18,900.00 18,900.00 9/30/2019 124,712.50 2/1/2020 90,000 4.500% 18,900.00 108,900.00 8/1/2020 16,875.00 16,875.00 9/30/2020 125,775.00 2/1/2021 95,000 4.500% 16,875.00 111,875.00 8/1/2021 14,737.50 14,737.50 9/30/2021 126,612.50 2/1/2022 100,000 4.500% 14,737.50 114,737.50 8/1/2022 12,487.50 12,487.50 9/30/2022 127,225.00 2/1/2023 105,000 4.500% 12,487.50 117,487.50 8/1/2023 10,125.00 10,125.00 9/30/2023 127,612.50 2/1/2024 105,000 4.500% 10,125.00 115,125.00 8/1/2024 7,762.50 7,762.50 9/30/2024 122,887.50 2/1/2025 110,000 4.500% 7,762.50 117,762.50 8/1/2025 5,287.50 5,287.50 9/30/2025 123,050.00 2/1/2026 115,000 4.500% 5,287.50 120,287.50 8/1/2026 2,700.00 2,700.00 9/30/2026 122,987.50 2/1/2027 120,000 4.500% 2,700.00 122,700.00 9/30/2027 122,700.00 1,365,000.00 510,187.50 1,875,187.50 1,875,187.50 GO Imp. and Ref. Bonds, S-2007, Pg 9 of 15 73 DETAILED BOND DEBT SERVICE City of Cibolo,Texas GO Improvement&Refunding Bonds,Series 2007 Utility System Debt Period Annual Debt Ending Principal Coupon Interest Debt Service Service 2/1/2013 170,000 4.500% 56,362.50 226,362.50 8/1/2013 52,537.50 52,537.50 9/30/2013 278,900.00 2/1/2014 150,000 4.500% 52,537.50 202,537.50 8/1/2014 49,162.50 49,162.50 9/30/2014 251,700.00 2/1/2015 160,000 4.500% 49,162.50 209,162.50 8/1/2015 45,562.50 45,562.50 9/30/2015 254,725.00 2/1/2016 170,000 4.500% 45,562.50 215,562.50 8/1/2016 41,737.50 41,737.50 9/30/2016 257,300.00 2/1/2017 135,000 4.500% 41,737.50 176,737.50 8/1/2017 38,700.00 38,700.00 9/30/2017 215,437.50 2/1/2018 140,000 4.500% 38,700.00 178,700.00 8/1/2018 35,550.00 35,550.00 9/30/2018 214,250.00 2/1/2019 145,000 4.500% 35,550.00 180,550.00 8/1/2019 32,287.50 32,287.50 9/30/2019 212,837.50 2/1/2020 155,000 4.500% 32,287.50 187,287.50 8/1/2020 28,800.00 28,800.00 9/30/2020 216,087.50 2/1/2021 160,000 4.500% 28,800.00 188,800.00 8/1/2021 25,200.00 25,200.00 9/30/2021 214,000.00 2/1/2022 170,000 4.500% 25,200.00 195,200.00 8/1/2022 21,375.00 21,375.00 9/30/2022 216,575.00 2/1/2023 175,000 4.500% 21,375.00 196,375.00 8/1/2023 17,437.50 17,437.50 9/30/2023 213,812.50 2/1/2024 180,000 4.500% 17,437.50 197,437.50 8/1/2024 13,387.50 13,387.50 9/30/2024 210,825.00 2/1/2025 190,000 4.500% 13,387.50 203,387.50 8/1/2025 9,112.50 9,112.50 9/30/2025 212,500.00 2/1/2026 200,000 4.500% 9,112.50 209,112.50 8/1/2026 4,612.50 4,612.50 9/30/2026 213,725.00 2/1/2027 205,000 4.500% 4,612.50 209,612.50 9/30/2027 209,612.50 2,505,000.00 887,287.50 3,392,287.50 3,392,287.50 GO Imp. and Ref. Bonds, S-2007, Pg 10 of 15 74 DETAILED BOND DEBT SERVICE City of Cibolo,Texas GO Improvement&Refunding Bonds,Series 2007 Refunding Bonds Period Annual Debt Ending Principal Coupon Interest Debt Service Service 2/1/2013 105,000 4.500% 49,387.50 154,387.50 8/1/2013 47,025.00 47,025.00 9/30/2013 201,412.50 2/1/2014 110,000 4.500% 47,025.00 157,025.00 8/1/2014 44,550.00 44,550.00 9/30/2014 201,575.00 2/1/2015 115,000 4.500% 44,550.00 159,550.00 8/1/2015 41,962.50 41,962.50 9/30/2015 201,512.50 2/1/2016 120,000 4.500% 41,962.50 161,962.50 8/1/2016 39,262.50 39,262.50 9/30/2016 201,225.00 2/1/2017 125,000 4.500% 39,262.50 164,262.50 8/1/2017 36,450.00 36,450.00 9/30/2017 200,712.50 2/1/2018 130,000 4.500% 36,450.00 166,450.00 8/1/2018 33,525.00 33,525.00 9/30/2018 199,975.00 2/1/2019 140,000 4.500% 33,525.00 173,525.00 8/1/2019 30,375.00 30,375.00 9/30/2019 203,900.00 2/1/2020 145,000 4.500% 30,375.00 175,375.00 8/1/2020 27,112.50 27,112.50 9/30/2020 202,487.50 2/1/2021 150,000 4.500% 27,112.50 177,112.50 8/1/2021 23,737.50 23,737.50 9/30/2021 200,850.00 2/1/2022 155,000 4.500% 23,737.50 178,737.50 8/1/2022 20,250.00 20,250.00 9/30/2022 198,987.50 2/1/2023 165,000 4.500% 20,250.00 185,250.00 8/1/2023 16,537.50 16,537.50 9/30/2023 201,787.50 2/1/2024 170,000 4.500% 16,537.50 186,537.50 8/1/2024 12,712.50 12,712.50 9/30/2024 199,250.00 2/1/2025 180,000 4.500% 12,712.50 192,712.50 8/1/2025 8,662.50 8,662.50 9/30/2025 201,375.00 2/1/2026 190,000 4.500% 8,662.50 198,662.50 8/1/2026 4,387.50 4,387.50 9/30/2026 203,050.00 2/1/2027 195,000 4.500% 4,387.50 199,387.50 9/30/2027 199,387.50 2,195,000.00 822,487.50 3,017,487.50 3,017,487.50 GO Imp. and Ref. Bonds,S-2007, Pg 11 of 15 75 BOND DEBT SERVICE City of Cibolo,Texas Certificates of Obligation,Series 2008 Period Annual Debt Ending Principal Coupon Interest Debt Service Service 2/1/2013 55,000 3.410% 32,761.00 87,761.00 8/1/2013 31,823.25 31,823.25 9/30/2013 119,584.25 2/1/2014 60,000 3.600% 31,823.25 91,823.25 8/1/2014 30,743.25 30,743.25 9/30/2014 122,566.50 2/1/2015 60,000 3.790% 30,743.25 90,743.25 8/1/2015 29,606.25 29,606.25 9/30/2015 120,349.50 2/1/2016 75,000 3.930% 29,606.25 104,606.25 8/1/2016 28,132.50 28,132.50 9/30/2016 132,738.75 2/1/2017 80,000 4.070% 28,132.50 108,132.50 8/1/2017 26,504.50 26,504.50 9/30/2017 134,637.00 2/1/2018 80,000 4.210% 26,504.50 106,504.50 8/1/2018 24,820.50 24,820.50 9/30/2018 131,325.00 2/1/2019 85,000 4.290% 24,820.50 109,820.50 8/1/2019 22,997.25 22,997.25 9/30/2019 132,817.75 2/1/2020 90,000 4.370% 22,997.25 112,997.25 8/1/2020 21,030.75 21,030.75 9/30/2020 134,028.00 2/1/2021 95,000 4.450% 21,030.75 116,030.75 8/1/2021 18,917.00 18,917.00 9/30/2021 134,947.75 2/1/2022 100,000 4.530% 18,917.00 118,917.00 8/1/2022 16,652.00 16,652.00 9/30/2022 135,569.00 2/1/2023 105,000 4.630% 16,652.00 121,652.00 8/1/2023 14,221.25 14,221.25 9/30/2023 135,873.25 2/1/2024 110,000 4.680% 14,221.25 124,221.25 8/1/2024 11,647.25 11,647.25 9/30/2024 135,868.50 2/1/2025 110,000 4.730% 11,647.25 121,647.25 8/1/2025 9,045.75 9,045.75 9/30/2025 130,693.00 2/1/2026 120,000 4.780% 9,045.75 129,045.75 8/1/2026 6,177.75 6,177.75 9/30/2026 135,223.50 2/1/2027 125,000 4.830% 6,177.75 131,177.75 8/1/2027 3,159.00 3,159.00 9/30/2027 134,336.75 2/1/2028 130,000 4.860% 3,159.00 133,159.00 9/30/2028 133,159.00 1,480,000.00 623,717.50 2,103,717.50 2,103,717.50 CO's, S-2008, Pg 12 of 15 76 BOND DEBT SERVICE City of Cibolo,Texas General Obligation Bonds,Series 2009 Period Annual Debt Ending Principal Coupon Interest Debt Service Service 2/1/2013 180,000 3.000% 210,765.00 390,765.00 8/1/2013 208,065.00 208,065.00 9/30/2013 598,830.00 2/1/2014 185,000 3.000% 208,065.00 393,065.00 8/1/2014 205,290.00 205,290.00 9/30/2014 598,355.00 2/1/2015 190,000 3.500% 205,290.00 395,290.00 8/1/2015 201,965.00 201,965.00 9/30/2015 597,255.00 2/1/2016 195,000 3.500% 201,965.00 396,965.00 8/1/2016 198,552.50 198,552.50 9/30/2016 595,517.50 2/1/2017 205,000 3.500% 198,552.50 403,552.50 8/1/2017 194,965.00 194,965.00 9/30/2017 598,517.50 2/1/2018 595,000 4.000% 194,965.00 789,965.00 8/1/2018 183,065.00 183,065.00 9/30/2018 973,030.00 2/1/2019 620,000 4.000% 183,065.00 803,065.00 8/1/2019 170,665.00 170,665.00 9/30/2019 973,730.00 2/1/2020 645,000 4.000% 170,665.00 815,665.00 8/1/2020 157,765.00 157,765.00 9/30/2020 973,430.00 2/1/2021 675,000 4.000% 157,765.00 832,765.00 8/1/2021 144,265.00 144,265.00 9/30/2021 977,030.00 2/1/2022 700,000 4.100% 144,265.00 844,265.00 8/1/2022 129,915.00 129,915.00 9/30/2022 974,180.00 2/1/2023 730,000 4.200% 129,915.00 859,915.00 8/1/2023 114,585.00 114,585.00 9/30/2023 974,500.00 2/1/2024 765,000 4.300% 114,585.00 879,585.00 8/1/2024 98,137.50 98,137.50 9/30/2024 977,722.50 2/1/2025 795,000 4.400% 98,137.50 893,137.50 8/1/2025 80,647.50 80,647.50 9/30/2025 973,785.00 2/1/2026 830,000 4.500% 80,647.50 910,647.50 8/1/2026 61,972.50 61,972.50 9/30/2026 972,620.00 2/1/2027 870,000 4.600% 61,972.50 931,972.50 8/1/2027 41,962.50 41,962.50 9/30/2027 973,935.00 2/1/2028 910,000 4.500% 41,962.50 951,962.50 8/1/2028 21,487.50 21,487.50 9/30/2028 973,450.00 2/1/2029 955,000 4.500% 21,487.50 976,487.50 9/30/2029 976,487.50 10,045,000.00 4,637,375.00 14,682,375.00 14,682,375.00 GO Bonds,S-2009, Pg 13 of 15 77 BOND DEBT SERVICE City of Cibolo,Texas General Obligation Refunding Bonds,Series 2010 Period Annual Debt Ending Principal Coupon Interest Debt Service Service 2/1/2013 85,000 1.590% 11,203.50 96,203.50 8/1/2013 10,527.75 10,527.75 9/30/2013 106,731.25 2/1/2014 85,000 1.850% 10,527.75 95,527.75 8/1/2014 9,741.50 9,741.50 9/30/2014 105,269.25 2/1/2015 85,000 2.150% 9,741.50 94,741.50 8/1/2015 8,827.75 8,827.75 9/30/2015 103,569.25 2/1/2016 90,000 2.460% 8,827.75 98,827.75 8/1/2016 7,720.75 7,720.75 9/30/2016 106,548.50 2/1/2017 90,000 2.770% 7,720.75 97,720.75 8/1/2017 6,474.25 6,474.25 9/30/2017 104,195.00 2/1/2018 95,000 3.050% 6,474.25 101,474.25 8/1/2018 5,025.50 5,025.50 9/30/2018 106,499.75 2/1/2019 95,000 3.300% 5,025.50 100,025.50 8/1/2019 3,458.00 3,458.00 9/30/2019 103,483.50 2/1/2020 95,000 3.550% 3,458.00 98,458.00 ' 8/1/2020 1,771.75 1,771.75 9/30/2020 100,229.75 2/1/2021 95,000 3.730% 1,771.75 96,771.75 9/30/2021 96,771.75 815,000.00 118,298.00 933,298.00 933,298.00 2010 Refunding, Pg 14 of 15 78 BOND DEBT SERVICE City of Cibolo,Texas General Obligation Bonds,Series 2011 Period Annual Debt Ending Principal Coupon Interest Debt Service Service 2/1/2013 475,000 2.000% 124,090.00 599,090.00 8/1/2013 119,340.00 119,340.00 9/30/2013 718,430.00 2/1/2014 340,000 2.000% 119,340.00 459,340.00 8/1/2014 115,940.00 115,940.00 9/30/2014 575,280.00 2/1/2015 350,000 2.000% 115,940.00 465,940.00 8/1/2015 112,440.00 112,440.00 9/30/2015 578,380.00 2/1/2016 355,000 2.000% 112,440.00 467,440.00 8/1/2016 108,890.00 108,890.00 9/30/2016 576,330.00 2/1/2017 365,000 2.000% 108,890.00 473,890.00 8/1/2017 105,240.00 105,240.00 9/30/2017 579,130.00 2/1/2018 370,000 2.000% 105,240.00 475,240.00 8/1/2018 101,540.00 101,540.00 9/30/2018 576,780.00 2/1/2019 380,000 2.000% 101,540.00 481,540.00 8/1/2019 97,740.00 97,740.00 9/30/2019 579,280.00 2/1/2020 385,000 2.300% 97,740.00 482,740.00 8/1/2020 93,312.50 93,312.50 9/30/2020 576,052.50 2/1/2021 395,000 3.000% 93,312.50 488,312.50 8/1/2021 87,387.50 87,387.50 9/30/2021 575,700.00 2/1/2022 410,000 3.000% 87,387.50 497,387.50 8/1/2022 81,237.50 81,237.50 9/30/2022 578,625.00 2/1/2023 420,000 3.000% 81,237.50 501,237.50 8/1/2023 74,937.50 74,937.50 9/30/2023 576,175.00 2/1/2024 435,000 3.000% 74,937.50 509,937.50 8/1/2024 68,412.50 68,412.50 9/30/2024 578,350.00 2/1/2025 450,000 3.500% 68,412.50 518,412.50 8/1/2025 60,537.50 60,537.50 9/30/2025 578,950.00 2/1/2026 465,000 3.500% 60,537.50 525,537.50 8/1/2026 52,400.00 52,400.00 9/30/2026 577,937.50 2/1/2027 485,000 4.000% 52,400.00 537,400.00 8/1/2027 42,700.00 42,700.00 9/30/2027 580,100.00 2/1/2028 500,000 4.000% 42,700.00 542,700.00 8/1/2028 32,700.00 32,700.00 9/30/2028 575,400.00 2/1/2029 525,000 4.000% 32,700.00 557,700.00 8/1/2029 22,200.00 22,200.00 9/30/2029 579,900.00 2/1/2030 545,000 4.000% 22,200.00 567,200.00 8/1/2030 11,300.00 11,300.00 9/30/2030 578,500.00 2/1/2031 565,000 4.000% 11,300.00 576,300.00 9/30/2031 576,300.00 8,215,000.00 2,900,600.00 11,115,600.00 11,115,600.00 2011 GO Bonds, Pg 15 of 15 79 ) * ,. x A "City of Choice" WATER AND SEWER FUND The Water-Sewer fund accounts for revenues and expenses related to the distribution of water resources and collection and disposal of waste water and refuse. 81 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 UTILITY FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET BEGINNING FUND BALANCE 2,572,294 3,362,884 3,362,884 3,548,254 REVENUES: UTILITY SERVICES 7,538,483 7,419,900 7,462,882 7,900,900 INTEREST,TRANSFERS, MISCELLANEOUS 1,233,399 42,500 42,668 38,700 SUBTOTAL REVENUES 8,771,883 7,462,400 7,505,550 7,939,600 TOTAL AVAILABLE 11,344,177 10,825,284 10,868,434 11,487,854 EXPENDITURES: UTILITIES ADMINISTRATION 5,512,964 6,049,860 5,719,675 6,066,789 UTILITIES OPERATIONS 906,393 998,849 799,490 959,903 DEBT SERVICE 223,115 494,374 494,374 1,031,781 SUBTOTAL EXPENDITURES 6,642,472 7,543,083 7,013,539 8,058,473 OTHER FINANCING USES 193,687 316,348 306,642 316,774 ADDITIONAL LAND ACQUISITION COSTS 300,000 EMPLOYEE COST OF LIVING ADJUSTMENT 8,073 EMPLOYEE PAY PLAN 5,739 193,687 316,348 306,642 630,586 CHANGE IN INVESTED IN CAPITAL ASSETS (1,145,134) - - - ENDING FUND BALANCE 3,362,884 2,965,853 3,548,254 2,798,795 82 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/14/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $01FF %CHG REVENUES 02-31100-00-00 WATER SALES-RESIDENTIAL 2,969,449.05 2,865,600.00 2,818,333.22 3,015,600.00 150,000.00 5.2% 02-31110-00-00 WATER SALES-COMMERCIAL 616,568.89 562,800.00 638,784.62 683,500.00 120,700.00 21.4% 02-31200-00-00 WASTE WATER-RESIDENTIAL 1,759,791.08 1,776,000.00 1,880,109.12 2,011,700.00 235,700.00 13.3% 02-31210-00-00 WASTEWATER-COMMERCIAL 122,235.88 116,900.00 119,853.78 128,200.00 11,300.00 9.7% 02-31300-00-00 GARBAGE COLLECTION-RESIDENTIAL 926,237.32 946,300.00 983,243.91 1,032,400.00 86,100.00 9.1% 02-31310-00-00 GARBAGE COLLECTION-COMMERCIAL 456,194.63 474,700.00 364,630.29 382,900.00 (91,800.00) -19.3% 02-31400-00-00 LATE FEES 183,079.12 179,700.00 129,572.77 102,000.00 (77,700.00) -43.2% 02-31420-00-00 ADMINISTRATIVE PENALTY - - 12,825.00 18,000.00 18,000.00 02-31600-00-00 RECYCLING FEES-A/R 170,078.37 174,000.00 176,783.91 185,600.00 11,600.00 6.7% 02-31700-00-00 WATER ACQUISITION FEE 231,816.00 231,300.00 237,497.14 244,600.00 13,300.00 5.8% 02-31900-00-00 ACCOUNT SETUP FEES - - 22,630.00 24,000.00 24,000.00 02-32100-00-00 CONNECT FEES 53,767.13 48,800.00 6,300.00 2,400.00 (46,400.00) -95.1% 02-32200-00-00 METER INSTALLATION FEES 10,920.00 9,800.00 11,000.00 11,000.00 1,200.00 12.2% 02-32250-00-00 METER SALES 38,346.00 34,000.00 42,119.00 40,000.00 6,000.00 17.6% 02-32260-00-00 HYDRANT METER RENTAL - - 15,878.57 16,000.00 16,000.00 02-32500-00-00 TAP FEES - - 3,321.00 3,000.00 3,000.00 UTILITY SERVICES 7,538,483.47 7,419,900.00 7,462,882.34 7,900,900.00 481,000.00 6.5% 02-34540-00-00 CREDIT CARD FEES 20,929.94 16,800.00 26,819.88 30,200.00 13,400.00 79.8% 02-35100-00-00 INTEREST 3,107.96 3,800.00 2,034.60 2,000.00 (1,800.00) -47.4% 02-35270-00-00 WATER IMPACT FEE TRF/DEBT - - - - - 02-35300-00-00 MISC RECEIPTS 20,401.29 15,900.00 2,263.28 2,300.00 (13,600.00) -85.5% ( ) 02-35315-00-00 NSF FEES 6,158.80 6,000.00 4,175.00 4,200.00 (1,800.00) -30.0% 1 02-35410-00-00 CASH OVER/SHORT (38.17) 10.35 - 02-35500-00-00 CONTRIBUTED CAPITAL 1,182,839.44 - - - - 02-36550-00-00 INSURANCE PROCEEDS - - 1,715.00 - - 02-36415-00-00 SALE OF ASSETS - - 5,650.00 - - INTEREST,TRANSFERS,MISCELLANEOUS 1,233,399.26 42,500.00 42,668.11 38,700.00 (3,800.00) -8.9% TOAL REVENUES 8,771,882.73 7,462,400.00 7,505,550.46 7,939,600.00 477,200.00 6.4% 83 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 0 Water-Sewer Fund 42—Utilities Administration Function: Utilities administration is responsible for the billing and collection of over 6,000 utility accounts. The tasks include billing,collection, and customer relations. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Utility Administrator 1 1 1 Assistant Utility Administrator 0 1 1 Clerk 1 1 1 Receptionist 1 0 0 3 3 3 84 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG UTILITY ADMINISTRATION 02-51010-42-00 SALARIES 72,545.11 103,204.00 101,170.23 112,359.00 9,155.00 8.9% 02-51011-42-00 LONGEVITY 4,080.00 1,920.00 1,920.00 2,280.00 360.00 18.8% 02-51020-42-00 UNEMPLOYMENT TAX 144.00 270.00 843.79 783.00 513.00 190.0% 02-51030-42-00 SOCIALSECURITY-MEDICARE 6,371.06 8,042.00 7,879.59 8,770.00 728.00 9.1% 02-51040-42-00 RETIREMENT 8,917.98 10,738.00 10,545.30 10,415.00 (323.00) -3.0% 02-51060-42-00 HEALTH-LIFE INSURANCE 11,334.97 15,757.00 13,016.87 15,777.00 20.00 0.1% 02-51070-42-00 WORKERS COMPENSATION 260.28 279.00 267.73 305.00 26.00 9.3% SALARIES AND BENEFITS 103,653.40 140,210.00 135,643.51 150,689.00 10,479.00 7.5% 02-52610-42-00 CONTRACT SERVICES 20,275.39 25,000.00 22,894.33 23,000.00 (2,000.00) -8.0% 02-52626-42-00 ADVERTISING - - - - - 02-52630-42-00 TRAVEL AND TRAINING 154.56 750.00 725.00 1,000.00 250.00 33.3% 02-52640-42-00 BILLING SERVICE-DATA PROSE 15,236.74 15,500.00 14,970.64 15,000.00 (500.00) -3.2% 02-52650-42-00 GENERAL LIABILITY INSURANCE 31;225.56 35,000.00 22,381.44 25,000.00 (10,000.00) -28.6% 02-52680-42-00 LEGAL SERVICES 2,823.35 10,000.00 6,866.39 6,000.00 (4,000.00) -40.0% 02-52710-42-00 PROFESSIONAL SERVICES 41,635.63 10,000.00 - 15,000.00 5,000.00 50.0% 02-52720-42-00 AUDIT SERVICES 5,170.00 6,900.00 7,093.75 7,500.00 600.00 8.7% SERVICES,UTILITIES AND TRAINING 116,521.23 103,150.00 74,931.55 92,500.00 (10,650.00) -10.3% 02-53210-42-00 OFFICE SUPPLIES 1,644.91 1,750.00 2,500.40 2,000.00 250.00 14.3% 02-53225-42-00 OFFICE MACHINERYAND EQUIPMENT 2,631.48 1,500.00 2,266.66 2,900.00 1,400.00 93.3% 02-53230-42-00 OTHER SUPPLIES - - - - - 02-53240-42-00 POSTAGE 34,198.04 34,500.00 35,392.54 37,200.00 2,700.00 7.8% 02-53410-42-00 BUILDING MAINTENANCE - - 11.17 - - GENERAL SUPPLIES AND REPAIRS 38,474.43 37,750.00 40,170.77 42,100.00 4,350.00 11.5% 02-54900-42-00 NON CAPITAL OUTLAY<$9,999 - - - - - CAPITAL AND NON-CAPITAL OUTLAY - - - - - 02-55000-42-00 DEPRECIATION - - - - - 02-55002-42-00 AMORTIZED BOND ISSUE COST - - - - - 02-55425-42-00 CREDIT CARD MACHINE FEES 19,767.70 21,600.00 23,572.02 24,800.00 3,200.00 14.8% 02-55720-42-00 FALL/SPRING CLEANUP-BEXARWASTE 14,977.45 30,000.00 .22,020.53 28,000.00 (2,000.00) -6.7% 02-55732-42-00 GBRA 148,493.58 150,000.00 153,900.00 169,000.00 19,000.00 12.7% 02-55735-42-00 GENERAL FUND-ADMIN FEES - 117,348.00 119,617.85 126,774.00 9,426.00 8.0% 02-55761-42-00 BEXAR MET LEASE CONTRACT 335,290.52 336,000.00 342,438.88 353,000.00 17,000.00 5.1% 02-55764-42-00 REGIONAL WTR DEV GRP 100.00 300.00 100.00 300.00 - 0.0% 02-55766-42-00 CIBOLO CREEK MUNICIPAL AUTH. 1,124,675.80 1,161,000.00 1,190,851.78 1,250,400.00 89,400.00 77% 02-55767-42-00 BEXAR WASTE CONTRACT 1,343,186.20 1,381,850.00 1,300,910.88 1,366,000.00 (15,850.00) -1.1% 02-55768-42-00 REFUSE TRANSFER TO GENERAL 193,686.79 199,000.00 187,023.67 190,000.00 (9,000.00) -4.5% 02-55769-42-00 CANYON REGIONAL WATER AUTH. 2,153,842.05 2,188,000.00 2,185,080.44 2,465,000.00 277,000.00 '12.7% 02-55770-42-00 CIBOLO VALLEY LOCAL GOVT CORP - 500,000.00 250,054.30 125,000.00 (375,000.00) =75.0% 02-55900-42-00 CHARGE OFF WATER ACCOUNTS 113,981.51 - - - - OTHER EXPENSES 5,448,001.60 6,085,098.00 5,775,570.35 6,098,274.00 13,176.00 0.2% 02-52725-00-00 BOND FEES - 1,000.00 1,000.00 1,000.00 - 0.0% 02-59061-00-00 2006 TEN YEAR REVENUE BOND 62,407.02 60,379.00 60,379.00 63,242.00 2,863.00 4.7% 02-59063-00-00 2006 20-YEAR REVENUE BOND 39,169.22 166,895.00 166,895.00 163,639.00 (3,256.00) -2.0% 02-59071-00-00 2007 GENERAL OBLIGATION BOND 121,538.65 266,100.00 266,100.00 278,900.00 12,800.00 4.8% 02-59071-00-00 2012 REVENUE BONDS - - - 525,000.00 525,000.00 DEBT SERVICE 223,114.89 494,374.00 494,374.00 1,031,781.00 537,407.00 108.7% TOTAL UTILITY ADMINISTRATION 5,929,765.55 6,860,582.00 6,520,690.18 7,415,344.00 554,762.00 8.1% 85 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 Water-Sewer Fund 46—Utilities Operations Function: Utilities operations ensures the health and well being of the citizens of Cibolo by providing a safe supply of water and maintaining the distribution system and maintaining wastewater avenues. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Public Works Director** 0 1 1 Fire Chief/Public Works/Utilities 1 0 0 Superintendent *** 1 1 1 Infrastructure Inspector * 1 1 1 Foreman 1 1 1 Crew Leader 0 2 2 Labor 1,11, III 6 5 5 Meter Technician 1 1 1 12 12 12 Proposed Capital: Ford F150 Truck(1/2 funded from Public Works/Utilities) $ 13,000.00 * The infrastructure inspector position is funded 50%from community development and 50%from utilities operations. ** A public works/utilities director is funded in the proposed budget 50%from the public works department,35% from the water-sewer fund and 15%from the drainage utility district. *** Superintendent is funded 67%from water-sewer fund and 33%by the drainage utility district. 86 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG UTILITY OPERATIONS 02-51010-46-00 SALARIES 279,682.60 324,726.00 288,686.24 338,897.00 14,171.00 4.4% 02-51011-46-00 LONGEVITY 1,680.00 3,160.00 1,780.00 3,042.00 (118.00) -3.7% 02-51014-46-00 ON-CALL PAY 2,091.48 2,080.00 3,120.00 4,160.00 2,080.00 100.0% 02-51015-46-00 OVERTIME 6,466.25 12,000.00 8,019.62 12,000.00 - 0.0% 02-51016-46-00 PHONE ALLOWANCE 1,200.00 2,046.00 1,605.00 2,172.00 126.00 6.2% 02-51020-46-00 UNEMPLOYMENT TAX 945.87 902.00 3,321.97 3,132.00 2,230.00 247.2% 02-51030-46-00 SOCIAL SECURITY-MEDICARE 20,846.89 26,317.00 22,456.10 27,561.00 1,244.00 4.7% 02-51040-46-00 RETIREMENT 30,621.80 35,141.00 30,764.63 32,731.00 (2,410.00) -6.9% 02-51060-46-00 HEALTH-LIFE INSURANCE 41,847.64 51,645.00 44,595.69 55,216.00 3,571.00 6.9% 02-51070-46-00 WORKERS COMPENSATION 7,585.08 9,924.00 9,520.90 10,810.00 886.00 8.9% SALARIES AND BENEFITS 392,967.61 467,941.00 413,870.15 489,721.00 21,780.00 4.7% 02-52510-46-00 LABORATORY FEES 6,708.00 7,000.00 7,382.91 7,000.00 - 0.0% 02-52610-46-00 CONTRACT SERVICES 375.00 100.00 1,500.00 1,700.00 1,600.00 1600.0% 02-52630-46-00 TRAVEL AND TRAINING 4,767.00 5,658.00 2,747.24 3,200.00 (2,458.00) -43.4% 02-52635-46-00 DUES,FEES AND PERMITS 701.00 1,000.00 812.00 815.00 (185.00) -18.5% 02-52710-46-00 PROFESSIONAL SERVICES 21,624.25 82;000.00 22,863.70 25,000.00 (57,000.00) -69.5% 02-52740-42-00 GIS/CAD MAPPING SERVICES - - - 25,000.00 25,000.00 02-52810-46-00 UTILITIES 34,938.31 37,000.00 28,290.34 30,000.00 (7,000.00) -18.9% 02-52820-46-00 TELEPHONE 1,858.99 2,000.00 1,742.10 1,860.00 (140.00) -7.0% SERVICES,UTILITIES AND TRAINING 70,972.55 134,758.00 65,338.29 94;575.00 (40,183.00) -29.8% 02-53090-46-00 UNIFORMS 4,452.35 6,200.00 4,941.90 5,500.00 (700.00) -11.3% 02-53095-46-00 SAFETY SUPPLIES AND EQUIPMENT 4,430.55 6,000.00 5,893.66 4,500.00 (1,500.00) -25.0% 02-53210-46-00 OFFICE SUPPLIES 759.37 600.00 600.00 600.00 - 0.0% 02-53220-46-00 JANITORIAL SUPPLIES 261.96 400.00 200.00 200.00 (200.00) -50.0% 02-53225-46-00 OFFICE MACHINERY AND EQUIPMENT 3,317 45 1,500.00 2,682.77 500.00 (1,000.00) -66.7% 02-53230-46-00 OTHER SUPPLIES 1,855.41 750.00 1,276.80 500.00 (250.00) -33.3% 02-53240-46-00 POSTAGE 10.05 50.00 106.36 75.00 25.00 50.0% 02-53271-46-00 MAIN REPAIR WATER 5,041.26 30,000.00 25,326.45 30,000.00 - 0.0% 02-53272-46-00 MAIN REPAIR SEWER 3,888.34 30,000.00 20,074.45 30,000.00 - 0.0% 02-53280-46-00 MINOR TOOLS AND EQUIPMENT 9,131.92 2,500.00 2,503.20 2,000.00 (500.00) -20.0% 02-53410-46-00 BUILDING MAINTENANCE 176.83 500.00 624.91 1,500.00 1,000.00 200.0%. 02-53415-46-00 TOWER SITE MAINTENANCE 6,118.21 1,000.00 997.00 1,000.00 - 0.0% 02-53440-46-00 MACHINERY MAINTENANCE 6,646.44 4,000.00 1,794.14 4,000.00 - 0.0% 02-53450-46-00 VEHICLE OPERATION - - - - - 02-53455-46-00 VEHICLE FUEL 26,703.70 32,000.00 26,403.82 30,000.00 (2,000.00) -6.3% 02-53470-46-00 VEHICLE REPAIRS 8,084.11 7,500.00 8,080.48 7,500.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 80,877.95 123,000.00 101,505.94 117,875.00 (5,125.00) -4.2% 02-54900-46-00 NON CAPITAL OUTLAY<$9,999 3,766.64 6,650.00 7,220.09 11,500.00 4,850.00 72.9% 02-54910-46-00 CAPITAL OUTLAY 31,363.77 55,000.00 - 13,000.00 (42,000.00) -76.4% 02-54916-46-00 WATER LINE PROJECTS 23,151.51 200,000.00 153,095.10 160,000.00 (40,000.00) -2a0% 02-54930-46-00 COMMUNICATION EQUIPMENT 587 45 1,500.00 100.00 6,000.00 4,500.00 300.0% 02-54955-46-00 WATER METERS - 10,000.00 3;360.39 7,500.00 (2,500.00) -25.0% 02-54999-46-00 CONTRA CAPITAL ACCOUNT (31,363.77) - - - - CAPITAL AND NON-CAPITAL OUTLAY 27,505.60 273,150.00 163,775.58 198,000.00 (75,150.00) -27.5% 02-55000-46-00 DEPRECIATION 334,069.53 - - - - OTHER EXPENSES 334,069.53 - - - - 02-59120-46-00 2012 LEASE PRINCIPAL - - 54,800.00 56,715.79 56,715.79 02-59121-46-00 2012 LEASE INTEREST - - 200.00 3,016.16 3,016.16 DEBT SERVICE - - 55,000.00 59,731.95 59,731.95 TOTAL UTILITY OPERATIONS 906,393.24 998,849.00 799,489.96 959,902.95 (38,946.05) -3.9% 87 -A-4,0 °f �,. 0 r ° T£ xAs "City of Choice" DRAINAGE UTILITY DISTRICT The Drainage Utility District was created in 2011 to account for revenues and expenses related to the maintenance of drainage ways of the City. 89 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 DRAINAGE UTILITY DISTRICT 2010-2011 ORIGINAL REVISED REQUESTED ACTUAL BUDGET BUDGET BUDGET BEGINNING FUND BALANCE - 144,909 144,909 218,603 REVENUES: DRAINAGE SERVICES 265,913 380,178 397,580 408,000 INTEREST,TRANSFERS, MISCELLANEOUS 1,507,905 - 81 80 SUBTOTAL REVENUES 1,773,818 380,178 397,661 408,080 TOTAL AVAILABLE 1,773,818 525,087 542,570 626,683 EXPENDITURES: DRAINAGE OPERATIONS 125,626 367,309 323,767 392,882 SUBTOTAL EXPENDITURES 125,626 367,309 323,767 392,882 OTHER FINANCING USES - - 200 1,586 EMPLOYEE COST OF LIVING ADJUSTMENT 2,924 EMPLOYEE PAY PLAN 2,475 - - 200 6,985 CHANGE IN INVESTED IN CAPITAL ASSETS (1,503,283) - - - ENDING FUND BALANCE 144,909 157,778 218,603 226,816 90 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/14/2012 'i 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF o CHG REVENUES 40-32900-00 DRAINAGE FEES-RESIDENTIAL 222,429.60 329,661.00 343,102.63 352,000.00 22,339.00 6.8% 40-32910-00 DRAINAGE FEES-COMMERCIAL 43,483.50 50,517.00 54,477.21 56,000.00 5,483.00 10.9% 40-35105-00 INTEREST 62.98 - 80.85 80.00 80.00 40-35200-00 TRANSFER IN FROM CP FUND 559,371.40 - - - - 40-35500-00 CONTRIBUTED CAPITAL 948,470.55 - - - - TOTAL REVENUES 1,773,818.03 380,178.00 397,660.68 408,080.00 27,902.00 7.3% ( ) I 91 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 Drainage Utility District 46—Drainage Utility District Function: The primary responsibility of the drainage utility district is to maintain drainage ways in the City. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Public Works Director** 0 1 1 Superintendent*** 0 1 1 Crew Leader 1 1 1 Labor II—Street Sweeper 0 1 1 0 Labor 1,11, III 2 3 3 3 7 7 Proposed Capital: Ford F150 Truck(1/2 funded from Public Works/Drainage) $13,000.00 ** A public works/utilities director is funded in the proposed budget 50%from the public works department,35% from the water-sewer fund and 15%from the drainage utility district. *** Superintendent is funded 67%from water-sewer fund and 33%by the drainage utility district. (2) 92 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG DRAINAGE UTILITY DISTRICT 40-51010-46 SALARIES 46,228.49 152,055.00 139,584.40 158,078.00 6,023.00 4.0% 40-51011-46 LONGEVITY 960.00 2,000.00 1,400.00 2,058.00 58.00 2.9% 40-51015-46 OVERTIME - 2,000.00 1,000.00 2,000.00 - 0.0% 40-51016-46 PHONE ALLOWANCE 160.00 774.00 624.00 828.00 54.00 7.0% 40-51020-46 UNEMPLOYMENT TAX 106.41 494.00 1,800.19 1,827.00 1,333.00 269.8% 40-51030-46 SOCIALSECURITY-MEDICARE 3,353.40 11,997.00 10,690.57 12,467.00 470.00 3.9% 40-51040-46 RETIREMENT 4,922.01 16,020.00 14,463.63 14,805.00 (1,215.00) -7.6% 40-51060-46 HEALTH-LIFE INSURANCE 7,735.22 28,332.00 24,688.56 28,721.00 389.00 1.4% 40-51070-46 WORKERS COMPENSATION - 9,033.00 8,854.64 10,370.00 1,337.00 14.8% SALARIES AND BENEFITS 63,465.53 222,705.00 203,105.99 231,154.00 8,449.00 3.8% 40-52610-46 CONTRACT SERVICES 1,030.00 - - - - 40-52615-46 CONTRACT DRAINAGE MAINTENANCE - - 12,000.00 12,000.00 12,000.00 40-52630-46 TRAVEL AND TRAINING 86.00 2,500.00 713.08 750.00 (1,750.00) -70.0% 40-52635-46 DUES,FEES AND PERMITS - - 100.00 100.00 100.00 40-52650-46 GENERAL LIABILITY INSURANCE - - 2,970.32 3,250.00 3,250.00 40-52680-46 LEGAL SERVICES 175.00 2,500.00 184.00 2,000.00 (500.00) -20.0% 40-52720-46 ENGINEERING SERVICES 5,313.25 10,000.00 24,633.64 10,000.00 - 0.0% 40-52810-46 UTILITIES - 7,500.00 2,631.56 3,500.00 (4,000.00) -53.3% 40-52820-46 TELEPHONE 97.81 400.00 427.27 650.00 250.00 62.5% SERVICES,UTILITIES AND TRAINING 6,702.06 22,900.00 43,659.87 32,250.00 9,350.00 40.8% 40-53090-46 UNIFORMS 1,231.13 1,200.00 3,354.43 3,500.00 Z300.00 191.7% 40-53095-46 SAFETY SUPPLIES AND EQUIPMENT 651.79 1,400.00 1,676.47 1,000.00 (400.00) -28.6% 40-53230-46 OTHER SUPPLIES 861.36 1,000.00 731.40 500.00 (500.00) -50.0% 40-53276-46 DRAINAGE MAINTENANCE 20,850.35 60,000.00 10,115.52 30,000.00 (30,000.00) -50.0% 40-53277-46 EQUIPMENT RENTAL - 1,500.00 341.25 1,500.00 - 0.0% 40-53280-46 MINOR TOOLS AND EQUIPMENT - 2,500.00 2,988.45 2,500.00 - 0.0% 40-53410-46 BUILDING MAINTENANCE 176.83 - 1,105.67 1,500.00 1,500.00 40-53440-46 MACHINERY MAINTENANCE 1,769.29 4,000.00 2,828.51 4,000.00 - 0.0% 40-53455-46 VEHICLE FUEL 755.23 12,000.00 13,492.81 14,000.00 2,000.00 16.7% 40-53470-46 VEHICLE REPAIRS 1,266.12 500.00 2,613.29 500.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 27,562.10 84,100.00 39,247.80 59,000.00 (25,100.00) -29.8% 40-54900-46 NON-CAPITAL OUTLAY - - - 14,500.00 14,500.00 40-54910-46 CAPITAL OUTLAY 23,337.00 30,000.00 - 13,000.00 (17,000.00) -56.7% 40-54930-46 COMMUNICATION EQUIPMENT - - - 5,000.00 5,000.00 40-54999-46 CONTRA CAPITAL ACCOUNT (23,337.00) - - - - CAPITAL AND NON-CAPITAL OUTLAY - 30,000.00 - 32,500.00 2,500.00 8.3% 40-55000-46 DEPRECIATION 27,896.17 - - - - 40-55735-46 TRANSFER TO GENERAL/ADMIN - 7,604.00 7,953.21 8,161.60 557.60 7.3% OTHER EXPENSES 27,896.17 7,604.00 7,953.21 8,161.60 557.60 7.3% 40-59120-46 2012 LEASE PRINCIPAL - - 29,800.00 29,816.85 29,816.85 40-59121-46 2012 LEASE INTEREST - - 200.00 1,585.67 1,585.67 DEBT SERVICE - - 30,000.00 31,402.52 31,402.52 TOTAL DRAINAGE UTILITY DISTRICT 125,625.86 367,309.00 323,966.87 394,468.12 27,159.12 7.4% 93 o c... c,. * 14 1 I Nttt4,....0) T£ X A'.5 "City of Choice" ECONOMIC DEVELOPMENT CORPORATION The Economic Development Corporation was incorporated on April 11, 2007 in accordance with The Development Corporation Act of 1979 and governed by Section 48 to promote commercial, industrial, and manufacturing enterprises in the City of Cibolo. 95 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 ECONOMIC DEVELOPMENT FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET BEGINNING FUND BALANCE 141,353 173,818 173,818 186,581 REVENUES: SALES TAX 136,003 133,600 155,800 163,700 INTEREST,TRANSFERS,MISCELLANEOUS 189 250 12,917 124,041 SUBTOTAL REVENUES 136,192 133,850 168,717 287,741 TOTAL AVAILABLE 277,545 307,668 342,535 474,322 EXPENDITURES: ECONOMIC DEVELOPMENT 16,322 72,150 39,637 180,981 OTHER FINANCING USES 87,404 116,317 116,317 119,584 SUBTOTAL EXPENDITURES 103,726 188,467 155,954 300,565 EMPLOYEE COST OF LIVING ADJUSTMENT - - - 1,363 EMPLOYEE PAY PLAN - - - 2,039 - - - 3,402 ENDING FUND BALANCE 173,818 119,201 186,581 171,718 97 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 Economic Development Fund 42-Economic Development Function: The primary responsibility of Economic Development is to attract retain,and expand desirable jobs and development for Cibolo that enhances quality of life. Personnel Schedule: Position Title FY 2010-2011 FY2011-2012 FY2012-2013 Economic Development Director* 0 0 1 *This position was funded in the general fund in prior years. 98 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET $DIFF %CHG ECONOMIC DEVELOPMENT CORPORATION REVENUES 05-31200-00 SALES TAX 136,002.72 133,600.00 155,800.00 163,700.00 30,100.00 22.5% 05-35105-00 INTEREST 188.79 250.00 189.14 200.00 (50.00) -20.0% 05-35210-00 INTERGOV'TL REV-GUADALUPE CO - - 12,727.43 - - 05-35290-00 TRANSFER FROM GENERAL FUND - - - 123,841.00 123,841.00 TOTAL REVENUE 136,191.51 133,850.00 168,716.57 287,741.00 153,891.00 115.0% EXPENDITURES 05-51010-42 SALARIES - - - 77,500.00 77,500.00 05-51011-42 LONGEVITY - - - 240.00 240.00 05-51016-42 PHONE ALLOWANCE - - - 720.00 720.00 05-51020-42 UNEMPLOYMENT TAX - - - 261.00 261.00 05-51030-42 SOCIAL SECURITY-MEDICARE - - - 6,002.00 6,002.00 05-51040-42 RETIREMENT - - - 7,128.00 7,128.00 05-51060-42 HEALTH-LIFE INSURANCE - - - 5,342.00 5,342.00 05-51070-42 WORKERS COMPENSATION - - - 208.00 208.00 SALARIES AND BENEFITS - - - 97,401.00 97,401.00 05-02627-42 PROMOTIONAL PRIOR YEAR UNEXPEN - - - - - 05-52620-42 PUBLICATIONS - - - 500.00 500.00 05-52625-42 ADVERTISING AND MARKETING 104.00 20,000.00 26,181.11 - (20,000.00) -100.0% 05-52630-42 TRAVEL AND TRAINING - 3,000.00 2,021.36 7,280.00 4,280.00 142.7% 05-52635-42 DUES,FEES AND PERMITS - 3,500.00 3,000.00 4,500.00 1,000.00 28.6% 05-52680-42 LEGAL SERVICES 4,125.62 1;500.00 1,637.02 5,000.00 3,500.00 233.3% 05-52714-42 BUSINESS DEVELOPMENT 3.7.36 - - - - 05-52750-42 MARKETING AND BUSINESS SVCS - 35,000.00 - 50,000.00 15,000.00 42.9% SERVICES,UTILITIES AND TRAINING 4,266.98 63,000.00 32,839.49 67,280.00 4,280.00 6.8% 05-53090-42 CLOTHING AND UNIFORMS - - - - - 05-53210-42 OFFICE SUPPLIES - 250.00 - 1,400.00 1,150.00 460.0% 05-53215-42 PRINTING - 1,500.00 500.00 6,500.00 5,000.00 333.3% 05-53240-42 POSTAGE - 500.00 - - (500.00) -100.0% 05-53455-42 VEHICLE FUEL - - - 1,250.00 1,250.00 05-53470-42 VEHICLE REPAIR - - - 250.00 250.00 05-53610-42 MEETINGS EXPENSE 55.23 900.00 297.25 900.00 - 0.0% GENERAL SUPPLIES AND REPAIRS 55.23 3,150.00 797.25 10,300.00 7,150.00 227.0% 05-55735-42 CIBOLO PROFESSIONAL SERVICES 12,000.00 6,000.00 6,000.00 6,000.00 - 0.0% 05-55910-42 2008 CO-SALES TAX NOTES 87,404.00 116,317.00 116,317.00 119,584.00 3,267.00 2.8% OTHER EXPENSES 99,404.00 122,317.00 122,317.00 125,584.00 3,267.00 2.7% TOTAL EXPENDITURES 103,726.21 188,467.00 155,953.74 300,565.00 112,098.00 59.5% TOTAL ECONOMIC DEVELOPMENT CORP 32,465.30 (54,617.00) 12,762.83 (12,824.00) 41,793.00 -76.5% 99 ° * . *. 4s rex AS "City of Choice" SPECIAL REVENUE FUNDS Special revenue funds are used to account for revenue restricted to a specific purpose. Special revenue funds maintained by the City of Cibolo are Grant funds, Cibolofest, Impact fees, Court Technology and Security, Police Seizure and Education, Child Safety and Street Drainage Maintenance Tax. 101 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 GRANT FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved Fund balance - - - - Total Beginning fund balance - - - - Revenues 156,442 268,558 268,558 189,000 Other financing sources - - - - Total available 156,442 268,558 268,558 189,000 Expenditures 156,442 268,558 268,558 189,000 Reserved.fund balance - - - - Ending fund balance - - - - 102 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET GRANTS FUND REVENUES 20-36115-00 PARK DONATIONS - 25,000 25,000 - 20-36123-00 GRANT-AACOG - - - 189,000 20-36126-00 TPWD GRANT 156,442 243,558 243,558 - TOTAL REVENUES 156,442 268,558 268,558 189,000 EXPENDITURES 20-57500-48-71-63 SCHLATHER PARK ENGINEERING 55,775 18,076 - - 20-57600-48-71-63 SCHLATHER PARK CONSTRUCTION 100,667 250,482 268,558 - 20-54910-43-00-00 CAPITAL OUTLAY - - - 189,000 TOTAL EXPENDITURES 156,442 268,558 268,558 189,000 TPWD GRANT FUND - - - - 103 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 CIBOLOFEST 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for special events - - - 6,976 Total Beginning fund balance - - - 6,976 Revenues - 15,000 16,740 15,000 Other financing sources - - - - ' Total available - 15,000 16,740 21,976 Expenditures - 15,000 9,764 15,000 Reserved for special events - - 6,976 6,976 Ending fund balance - - 6,976 6,976 104 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET CIBOLOFEST REVENUES 21-36250-00-00 CIBOLOFEST - 15;000 16,740 15,000 TOTAL REVENUES - 15,000 16,740 15,000 EXPENDITURES 21-53400-48-00 CIBOLOFEST EXPENSE - 15;000 9,764 15,000 TOTAL EXPENDITURES - 15,000 9,764 15,000 TOTAL CIBOLOFEST - - 6,976 - 105 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 WATER IMPACT FEES 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Restricted net assets 572,209 990,704 990,704 791,192 Total Beginning net assets 572,209 990,704 990,704 791,192 Revenues 418,495 401,000 460,650 483,715 Other financing sources - - - - Total available 990,704 1,391,704 1,451,354 1,274,907 Expenditures - 570,162 660,162 21,250 Restricted net assets 990,704 821,542 791,192 1,253,657 Ending net assets 990,704 821,542 791,192 1,253,657 Waterline Projects: Impact Fee Study - - - 21,250 Weidner to Green Valley Road - 570,162 570,162 - Main/Schaeffer - - 90,000 - - 570,162 660,162 21,250 106 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET WATER IMPACT FEES REVENUES 22-32300-00 IMPACT FEES-WATER 417,517 400,000 460,000 483,000 22-35100-00 INTEREST 978 1,000 650 715 TOTAL REVENUES 418,495 401,000 460,650 483,715 EXPENDITURES 22-52710-00-00 IMPACT FEE STUDY - - - 21,250 22-54916-00-22 WATERLINE PROJECTS(WEIDNER TO GVD) - 570,162 570,162 - 22-54916-00-22 WATERLINE PROJECTS(MAIN/SCHAFFER) - - 90,000 - TOTAL EXPENDITURES - 570,162 660,162 21,250 WATER IMPACT FEES 418,495 (169,162) (199,512) 462,465 107 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 WASTEWATER IMPACT FEES 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Restricted net assets 1,144,038 1,348,395 1,348,395 1,044,495 Total Beginning net assets 1,144,038 1,348,395 1,348,395 1,044,495 Revenues 204,357 182,500 251,100 263,710 Other financing sources - - - - Total available 1,348,395 1,530,895 1,599,495 1,308,205 Expenditures - 195,000 555,000 21,250 Restricted net assets 1,348,395 1,335,895 1,044,495 1,286,955 Ending net assets 1,348,395 1,335,895 1,044,495 1,286,955 Wastewater Proiects: Impact Fee Study - - - 21,250 Turning Stone upsize agreement - 195,000 195,000 - FM 1103 expansion - - 360,000 - - 195,000 555,000 21,250 108 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET WASTEWATER IMPACT FEES REVENUES 24-32400-00 IMPACT FEES-WASTE WATER 202,763 180,000 250,000 262,500 24-35100-00 INTEREST 1,594 2,500 1,100 1,210 TOTAL REVENUES 204,357 182,500 251,100 263,710 EXPENDITURES 24-52710-00-00 IMPACT FEE STUDY - - - 21,250 24-54917-46-01 SEWER LINE PROJECTS-TURNING STONE - 195,000 195,000 - 24-54917-46-31. SEWER LINE PROJECTS-FM1103 - - 360,000 - TOTAL EXPENDITURES - 195;000 555,000 21,250 WASTE WATER IMPACT FEES 204,357 (12,500) (303,900) 242,460 109 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 TRAFFIC IMPACT FEES 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for capital improvement - 95,878 95,878 335,978 Total Beginning fund balance - 95,878 95,878 335,978 Revenues 95,878 150,005 240,100 252,110 Other financing sources - - - - Total available 95,878 245,883 335,978 588,088 Expenditures - - - 521,250 Reserved for capital improvement 95,878 245,883 335,978 66,838 Ending fund balance 95,878 245,883 335,978 66,838 Traffic Projects: Impact Fee Study - - - 21,250 Green Valley Rd Improv - - - 500,000 - - 521,250 no CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET TRAFFIC IMPACT FEES REVENUES 29-32750-00 IMPACT FEES-TRAFFIC 95,856 150,000 240,000 252,000 29-35100-00 INTEREST 22 5 100 110 TOTAL REVENUES 95,878 150,005 240,100 252,110 EXPENDITURES 30-52710-00-00 IMPACT FEE STUDY - - - 21,250 30-57600-00-51 CONST-GREEN VALLEY RD IMPROV - - - 500,000 TOTAL EXPENDITURES - - - 521,250 TRAFFIC IMPACT FEES 95,878 150,005 240,100 " 252,110 111 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 STREET IMPACT FEES 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for capital improvement 548,518 472,724 472,724 458,249 Total Beginning fund balance 548,518 472,724 472,724 458,249 Revenues 716 900 525 578 Other financing sources - - - - Total available 549,234 473,624 473,249 458,827 Expenditures 76,510 55,950 15,000 227,300 Reserved for capital improvement 472,724 417,674 458,249 231,527 Ending fund balance 472,724 417,674 458,249 231,527 Street Projects: Impact Fee Study - - - 21,250 Borgfeld Rd Improvements 76,510 55,950 - 56,050 Traffic signal-Borgfeld/CVD - - 15,000 150,000 76,510 55,950 15,000 227,300 112 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/14/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET STREET IMPACT FEES REVENUES 30-32700-00 IMPACT FEES-STREET - - - - 30-35100-00 INTEREST 716 900 525 578 TOTAL REVENUES 716 900 525 578 EXPENDITURES 30-52710-00-00 IMPACT FEE STUDY - - - 21,250 30-57500-00-51 ENGINEERING-BORGFELD 56,050 55,950 - 56,050 30-57525-00-51 SURVEYING-BORGFELD 20,460 - - - 30-57600-00-51 CONSTRUCTION-SIGNAL AT BORGFELD - - 15,000 150,000 TOTAL EXPENDITURES 76,510 55,950 15,000 227,300 STREET IMPACT FEES (75,794) (55,050) (14,475) (226,722) I. 113 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 'r DRAINAGE IMPACT FEES 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for capital improvement 588,879 629,743 629,743 550,343 Total Beginning fund balance 588,879 629,743 629,743 550,343 Revenues 40,864 151,000 125,600 131,910 Other financing sources - - - Total available 629,743 780,743 755,343 682,253 Expenditures - 205,000 205,000 21,250 Reserved for capital improvement 629,743 575,743 550,343 661,003 Ending fund balance 629,743 575,743 550,343 661,003 0 Drainage Improvement Projects: Impact Fee Study - - - 21,250 Turning stone development agreeme - 181,000 181,000 - Schlater Park drainage -. 24,000 24,000 - - 205,000 205,000 21,250 o 114 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011. CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET DRAINAGE IMPACT FEES REVENUES 31-32800-00 IMPACT FEES-DRAINAGE 40,093 150;000 125,000 131,250 31-35100-00 INTEREST 771 1,000 600 660 31-35235-00 USE OF FUND BALANCE - - - - TOTAL REVENUES 40,864 151,000 125,600 131,910 EXPENDITURES 31-52710-00-00 IMPACT FEE STUDY - - - 21,250 31-54927-00-01 DRAINAGE IMPROVEMENTS-TURNING STONI - 181,000 181,000 - 31-57600-48-63 CONSTRUCTION COSTS-SCHLATHER DRAINP - 24,000 24,000 - TOTAL EXPENDITURES - 205,000 205,000 21,250 DRAINAGE IMPACT FEES 40,864 (54,000) (79,400) 110,660 115 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 PARK LAND FEES 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Total Beginning fund balance 813,315 938,054 938,054 264,857 Revenues 124,739 121,200 90,600 90,660 Other financing sources - - - - Total available 938,054 1,059,254 1,028,654 355,517 Expenditures - 767,000 763,797 - Ending fund balance 938,054 292,254 264,857 355,517 116 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET PARK LAND FEES REVENUES 32-35100-00 INTEREST 1,139 1,200 600 660 32-36215-00 BUILDER PARK LAND FEES 123,600 120,000 90,000 90,000 TOTAL REVENUES 124,739 121,200 90,600 90,660 EXPENDITURES 32-55735-48 TRANSFER TO GENERAL FUND - 25,000 - - 32-57500-48-63 ENGINEERING-SCLATHER PARK - - 18,076 - 32-57600-48-63 CONSTRUCTION-SCHLATHER PARK - 742,000 736,764 - 32-57650-48-63 TESTING-SCHLATHER PARK - - 8,957 - TOTAL EXPENDITURES - 767,000 763,797 - PARK LAND FEES 124,739 (645,800) (673,197) 90,660 117 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 COURT TECHNOLOGY 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for court technology 6,635 1,383 1,383 842 Total Beginning fund balance 6,635 1,383 1,383 842 Revenues 6,841 6,505 7,724 7,500 Other financing sources - - - - Total available 13,476 7,888 9,107 8,342 Expenditures 12,093 6,500 8,265 7,500 Reserved for court technology 1,383 1,388 842 842 Ending fund balance 1,383 1,388 842 842 118 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET COURT TECHNOLOGY REVENUES 33-34520-00 COURT TECHNOLOGY FEES 6,838 6,500 7,724 7,500 33-35100-00 INTEREST 3 5 - - 33-35235-00 USE OF FUND BALANCE - - - TOTAL REVENUES 6,841 6,505 7,724 7,500 EXPENDITURES 33-52610-44 CONTRACT SERVICES 10,776 6,500 8,265 7,500 33-53225-44 OFFICE MACHINERY AND EQUIPMENT 1,317 - - - TOTAL EXPENDITURES 12,093 6,500 8,265 7,500 COURT TECHNOLOGY FEES (5,252) 5 (541) - 119 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 COURT SECURITY 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for court security 34,750 34,320 34,320 31,704 Total Beginning fund balance 34,750 34,320 34,320 31,704 Revenues 5,179 5,070 5,836 5,070 Other financing sources - - - - Total available 39,929 39,390 40,156 36,774 Expenditures 5,609 8,800 8,452 8,800 Reserved for court security 34,320 30,590 31,704 27,974 Ending fund balance 34,320 30,590 31,704 27,974 120 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET COURT SECURITY REVENUES 34-34510-00 COURT SECURITY FEES 5,128 5;000 5,818 5,000 34-35100-00 INTEREST 51 70 18 70 34-35235-00 USE OF FUND BALANCE - - - - TOTAL REVENUES 5,179 5,070 5,836 5,070 EXPENDITURES 34-52610-00 CONTRACT SERVICES - - - - 34-55775-00 COURT SECURITY 4,279 - - - 34-52610-44 CONTRACT SERVICES 1,330 1,800 1,452 1,800 34-55735-44 TRANSFER TO GENERAL FUND - 7;000 7,000 7,000 TOTAL EXPENDITURES 5,609 8,800 8,452 8,800 COURT SECURITY FEES (430) (3,730) (2,616) (3,730) 121 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 POLICE SEIZURE FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Police seizure 3,766 3,771 3,771 3,772 Total Beginning fund balance 3,766 3,771 3,771 3,772 Revenues 5 10 1 - Other financing sources - - - - Total available 3,771 3,781 3,772 3,772 Expenditures - 3,750 - 3,750 Reserved for Police Seizure 3,771 31 3,772 22 Ending fund balance 3,771 31 3,772 22 122 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET POLICE SEIZURE FUND REVENUES 35-34750-00 PD FORFEITURE ACCOUNT - - - - 35-35100-00 INTEREST 5 10 1 - 35-35235-00 USE OF FUND BALANCE - - - - TOTAL REVENUES 5 10 1 - EXPENDITURES 35-53250-43 OFFICERS EQUIPMENT AND SUPPLIES - - - 3,750 35-55790-43 ASSET FORFEITURE EXPENSES - 3,750 - - TOTAL EXPENDITURES - 3,750 - 3,750 POLICE SEIZURE FUNDS 5 (3,740) 1 (3,750) 123 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 POLICE EDUCATION 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Police education 17,614 18,760 18,760 17,052 Total Beginning fund balance 17,614 18,760 18,760 17,052 Revenues 1,971 30 9 10 Other financing sources - - - - Total available 19,585 18,790 18,769 17,062 825 19,000 1,717 7,500 Reserved for Police Education 18,760 (210) 17,052 9,562 Ending fund balance 18,760 (210) 17,052 9,562 124 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET POLICE EDUCATION REVENUES 36-34730-00 LEOSE FUND 1,946 - - - 36-35100-00 INTEREST 25 30 9 10 TOTAL REVENUES 1,971 30 9 10 EXPENDITURES 36-52630-43 TRAVEL AND TRAINING - - - 7,500 36-55790-43 POLICE EDUCATION 825 19,000 1,717 TOTAL EXPENDITURES 825 19,000 1,717 7,500 POLICE EDUCATION FUNDS 1,146 (18,970) (1,708) (7,490) 125 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 POLICE SPECIAL FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Police special 5,155 5,654 5,654 5,657 Total Beginning fund balance 5,155 5,654 5,654 5,657 Revenues 610 10 3 - Other financing sources - - - - Total available 5,765 5,664 5,657 5,657 Expenditures 111 5,700 - 5,645 Reserved for Police Special 5,654 (36) 5,657 12 Ending fund balance 5,654 (36) 5,657 12 126 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET POLICE SPECIAL FUND REVENUES 37-34720-00 POLICE DONATIONS 500 - - - 37-34721-00 ANIMAL DONATIONS 103 - - - 37-35100-00 INTEREST 7 10 3 - TOTAL REVENUES 610 10 3 - EXPENDITURES 37-53250-43 OFFICER EQUIPMENT AND SUPPLIES - - - 5,000 37-55790-43 POLICE EXPENDITURES .111 5,700 - - 37-53250-47 OPERATING SUPPLIES-ACO - - - 645 TOTAL EXPENDITURES 111 5,700 - 5,645 POLICE SPECIAL FUND 499 (5,690) 3 (5,645) 127 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 CHILD SAFETY FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for child safety - 12,369 12,369 22,807 Total Beginning fund balance - 12,369 12,369 22,807 Revenues 12,369 - 17,938 15,010 Other financing sources - - - - Total available 12,369 12,369 30,307 37,817 Expenditures - - 7,500 15,785 Reserved for child safety 12,369 12,369 22,807 22,033 Ending fund balance 12,369 12,369 22,807 22,033 128 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET CHILD SAFETY FUND REVENUES 38-34505-00 CHILD SAFETY PROGRAM 12,365 - 17,929 15,000 38-35100-00 INTEREST 4 - 9 10 TOTAL REVENUES 12,369 - 17,938 15,010 EXPENDITURES 38-54900-00 NONCAPITAL OUTLAY - - 7,500 - 38-55735-00 TRANSFER TO GENERAL FUND - - - 15,785 TOTAL EXPENDITURES - - 7,500 15,785 CHILD SAFETY PROGRAM 12,369 - 17,938 15,010 129 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 STREET MAINTENANCE TAX FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Street Maintenance 213,958 233,039 233,039 189,100 Total Beginning fund balance 213,958 233,039 233,039 189,100 Revenues 136,326 134,000 156,061 164,000 Other financing sources - - - - Total available 350,284 367,039 389,100 353,100 Expenditures - - - - Other financing uses 117,245 250,000 200,000 200,000 Reserved for Street Maintenance 233,039 117,039 189,100 153,100 Ending fund balance 233,039 117,039 189,100 153,100 130 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 8/1/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET STREET MAINTENANCE TAX FUND REVENUES 39-31200-00 SALES TAX-STREET/MAINT 136,003 133,600 155,800 163,600 39-35105-00 INTEREST 323 400 261 400 TOTAL REVENUES 136,326 134,000 156,061 164,000 EXPENDITURES 39-52615-00 STREET MAINT CONT-TRAN GEN F. - - - - 39-55735-00 TRANSFER TO GENERAL FUND 117,245 250,000 200,000 200,000 TOTAL EXPENDITURES 117,245 250,000 200,000 200,000 STREET/DRAIN MAI NT TAX 19,081 (116,000) (43,939) (36,000) 131 C/, Ilk tY Ko -V It ) * Tex. AS "City of Choice" CAPITAL PROJECTS FUNDS Capital Projects funds account for the financial resources to be used for the acquisition and construction of major capital projects and is principally financed by the sale of bonds and tax notes. 133 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 CAPITAL REPLACEMENT FUND 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for IT replacement - 59,427 59,427 27,773 Reserved for Capital replacement - 98,044 98,044 67,149 Total Beginning fund balance - 157,471 157,471 94,922 Revenues 294 - 168 120 Other financing sources 242,916 - 35,000 - Total available 243,210 157,471 192,639 95,042 Expenditures: IT equipment 5,664 33,000 31,717 13,500 Capital replacement 80,074 - 66,000 - 85,738 33,000 97,717 13,500 Reserved for IT replacement 59,427 26,427 27,773 14,308 Reserved for Capital replacement 98,044 98,044 67,149 67,234 Ending fund balance 157,471 124,471 94,922 81,542 134 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET CAPITAL REPLACEMENT FUND REVENUES 06-35105-00 INTEREST 294 - 168 120 06-3524x-00-00 TRANSFER IN FROM GENERAL FUND 242,916 - 35,000 - TOTAL REVENUE 243,210 - 35,168 120 EXPENDITURES 06-53225-42-00 OFFICE MACHINERY AND EQUIPMENT - 7,000 5,363 - 06-53225-44-00 OFFICE MACHINERY AND EQUIPMENT - 13,000 10,909 7,500 06-53225-45-00 OFFICE MACHINERY AND EQUIPMENT - 7,000 7,833 6,000 06-53225-46-00 OFFICE MACHINERY AND EQUIPMENT 2,832 - 3,300 - 06-53225-48-00 OFFICE MACHINERY AND EQUIPMENT 1,416 - - - 06-53225-49-00 OFFICE MACHINERY AND EQUIPMENT 1,416 - - - 06-53225-50-00 OFFICE MACHINERY AND EQUIPMENT - 6,000 4,312 - 06-54910-43 CAPITAL OUTLAY 17,964 - - - 06-54910-45 CAPITAL OUTLAY 15,688 - - - 06-54910-46 CAPITAL OUTLAY 27,184 - 66,000 - 06-54910-49 CAPITAL OUTLAY 19,238 - - TOTAL EXPENDITURES 85,738 33,000 97,717 13,500 CAPITAL AND IT REPLACEMENT FUND 157,471 (33,000) (62,549) (13,380) 135 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2006 TAX NOTES 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for capital projects 744,009 244,831 244,831 60,324 Total Beginning fund balance 744,009 244,831 244,831 60,324 Revenues 890 - 300 330 Other financing sources - - - - Total available 744,899 244,831 245,131 60,654 Expenditures 500,068 244,807 184,807 - Reserved for capital projects 244,831 24 60,324 60,654 Ending fund balance 244,831 24 60,324 60,654 136 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2006 TAX NOTES REVENUES 07-35105-00 INTEREST 890 - 300 330 TOTAL REVENUE 890 - 300 330 EXPENDITURES 07-57400-00-42 LAND ACQUISITION/EASEMENT 93,875 - - - 07-57500-00-42 DRAINAGE PROJECT-ENGINEERING 66,033 14,967 14,967 - 07-57550-00-42 SCHLATHER PARK/TOWN CREEK ARCH - - - - 07-57600-00-42 TOWN CREEK WEST CHANNEL CONST 340,160 229,840 169,840 - TOTAL EXPENDITURES 500,068 244,807 184,807 - 2006 TAX NOTES (499,178) (244,807) (184,507) 330 137 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2008 CERTIFICATES OF OBLIGATION-MULTI-EVENT CENTEF 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for capital projects 2,593 2,766 2,766 233,235 Total Beginning fund balance 2,593 2,766 2,766 233,235 Revenues 173 245,265 245,469 257 Other financing sources - - - - Total available 2,766 248,031 248,235 233,492 Expenditures - 2,750 15,000 - Reserved for capital projects 2,766 245,281 233,235 233,492 Ending fund balance 2,766 245,281 233,235 233,492 138 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2008 CERTIFICATES OF OBLIGATION-MULTI-EVENT CENTER REVENUES 09-35105-00 INTEREST 173 30 234 257 09-35900-00 FORGIVENESS OF DEBT INCOME - 132,735 132,735 - 09-36500-00 SETTLEMENT PROCEEDS - 112,500 112,500 - TOTAL REVENUE 173 245,265 245,469 257 EXPENDITURES 09-52610-00 CONTRACT SERVICES - 2,750 - - 09-55100-41 CONSTRUCTION/DESIGN - - 15,000 - • TOTAL EXPENDITURES - 2,750 15,000 - 2008 CO'S-MULTI EVENT VENUE 173 242,515 230,469 257 139 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2006 REVENUE BONDS 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for capital projects 447,394 444,845 444,845 445,280 Total Beginning fund balance 447,394 444,845 444,845 445,280 Revenues 560 500 435 479 Other financing sources - - - - Total available 447,954 445,345 445,280 445,759 Expenditures 3,109 481,163 - 445,250 Reserved for capital projects 444,845 (35,818) 445,280 509 Ending fund balance 444,845 (35,818) 445,280 509 140 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2006 REVENUE BONDS REVENUES 12-35105-00 2006 REVENUE BOND INTEREST 560 500 435 479 TOTAL REVENUE 560 500 435 479 EXPENDITURES 12-54945-41 BOOSTER STATION REPLACEMENT - 481,163 - 445,250 12-55000-41 BOND ISSUANCE COST 3,109 - - - TOTAL EXPENDITURES 3,109 481,163 - 445,250 2006 REVENUE W/WW PROJECTS (2,549) (480,663) 435 (444,771) 141 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2007 GO BONDS-WATER/WASTEWATER PROJECTS 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for capital projects 172,907 171,580 171,580 171,752 Total Beginning fund balance 172,907 171,580 171,580 171,752 Revenues 222 275 173 190 Other financing sources - - - - Total available 173,129 171,855 171,752 171,942 Expenditures 1,549 131,837 - 171,750 Reserved for capital projects 171,580 40,018 171,752 192 Ending fund balance 171,580 40,018 171,752 192 142 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2007 GO BONDS-WATER/WASTEWATER PROJECTS REVENUES 14-35105-00 GO BOND INTEREST 222 275 173 190 TOTAL REVENUE 222 275 173 190 EXPENDITURES 14-54945-41 BOOSTER STATION REPLACEMENT - 131,837 - 171,750 14-55005-42 BOND ISSUANCE COST 1,549 - - - TOTAL EXPENDITURES 1,549 131,837 - 171,750 2007 GO W/WW PROJECTS (1,327) (131,562) 173 (171,560) 143 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2009 GO BONDS-POLICE STATION 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Police Station 312,498 83 83 13,318 Total Beginning fund balance 312,498 83 83 13,318 Revenues 291 - 11 10 Other financing sources 836 - - - Total available 313,625 83 94 13,328 Expenditures 313,542 - (13,224) 13,328 Other financing uses - - - - Reserved for Police Station 83 83 13,318 - Ending fund balance 83 83 13,318 - 144 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 CURRENT 2011-2012 PROPOSED 2012-2013 Account Number Description ACTUAL BUDGET BUDGET PROPOSED 2009 GO BONDS-POLICE STATION REVENUES 50-35100-00 INTEREST 291 - 11 10 50-35300-00 MISCELLANEOUS RECEIPTS 836 - - - TOTAL REVENUE 1,127 - 11 10 EXPENDITURES 50-53225-00 OFFICE MACHINERY AND EQUIPMENT 58,058 - 3,000 - 50-55100-00-15 PD-ENGINEERING SERVICES 1,684 - 4,571 13,328 50-55100-00-20 PD-CONSTRUCTION 253,800 - (20,795) - TOTAL EXPENDITURES 313,542 - (13,224) 13,328 2009 BONDS-POLICE STATION (312,415) - 13,235 (13,318) 145 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2009 GO BONDS-FIRE STATION 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Fire Station 357,043 143,523 143,523 85,158 Total Beginning fund balance 357,043 143,523 143,523 85,158 Revenues 450 - 144 158 Other financing sources - - - - Total available 357,493 143,523 143,667 85,316 Expenditures 213,970 143,523 58,509 40,000 Other financing uses - - - - Reserved for Fire Station 143,523 - 85,158 45,316 Ending fund balance 143,523 - 85,158 45,316 146 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2009 GO BONDS-FIRE STATION REVENUES 51-35100-00 INTEREST 450 - 144 158 TOTAL REVENUE 450 - 144 158 EXPENDITURES 51-53225-00 OFFICE MACHINERY&EQUIPMENT 60,492 143;523 19,878 40,000 51-55100-00-15 FD-ENGINEERING SERVICES 1,462 - 571 - 51-55100-00-20 FD-CONSTRUCTION 152,016 - 38,060 - TOTAL EXPENDITURES 213,970 143,523 58,509 40,000 2009 BONDS-FIRE DEPARTMENT (213,520) (143,523) (58,365) (39,842) 147 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2009 GO BONDS-CIBOLO VALLEY DRIVE 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Cibolo Valley Drive 2,927,647 238,822 238,822 173,857 Total Beginning fund balance 2,927,647 238,822 238,822 173,857 Revenues 2,589 - 315 75,347 Other financing sources - - - - Total available 2,930,236 238,822 239,137 249,204 Expenditures: Cibolo Valley Drive North 1,423,799 - 42,772 25,000 Cibolo Valley Drive South 1,208,311 - 4,113 - Ancillary Projects 59,304 - 18,395 224,000 Other financing uses - - - - Reserved for Cibolo Valley Drive 238,822 238,822 173,857 204 Ending fund balance 238,822 238,822 173,857 204 148 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2009 GO BONDS-CIBOLO VALLEY DRIVE REVENUES 52-35100-00-00 INTEREST 2,589 - 315 347 52-38100-00-00 INTERGOVERNMENTAL REVENUE-SCUCISD - - - 75,000 TOTAL REVENUE 2,589 - 315 75,347 EXPENDITURES - - - - 52-55200-00-00 CIBOLO VALLEY DRIVE TRAFFIC SIGNALS - - 14,750 150,000 52-55300-00-00 DRAINAGE-TOWN CREEK DETENTION 59,304 - - - 52-57500-00-00 ENGINEERING COSTS-SIDEWALKS 3,645 74,000 ANCILLARY PROJECTS 59,304 - 18,395 224,000 52-55100-00-10-15 CIBOLO VALLEY DR-NORTH-ENG. 9,531 - 535 - 52-55100-00-10-20 CIBOLO VALLEY DR-NORTH-CONST. 1,378,260 - 27,714 25,000 52-55100-00-10-25 CIBOLO VALLEY DR-NORTH-TESTING 37,083 - - - 52-55100-00-10-30 EASMENTS/SURVEY/ACQUISITION (1,075) - 14,523 - NORTH-CIBOLO VALLEY DR 1,423,799 - 42,772 25,000 52-55100-00-20-15 CIBOLO VALLEY DR-SOUTH-ENG. 4,956 - - - 52-55100-00-20-20 CIBOLO VALLEY DR-SOUTH-CONST. 1,142,805 - (46) - 52-55100-00-20-25 CIBOLO VALLEY DR-SOUTH-TESTING 28,767 - 559 - 52-55100-00-20-30 EASMENTS/SURVEY/ACQUISITION 31,783 3,600 - SOUTH-CIBOLO VALLEY DR 1,208,311 - 4,113 - CIBOLO VALLEY DR 2,691,414 - 65,280 249,000 TOTAL EXPENDITURES 2,691,414 - 65,280 249,000 2009 BOND-CIBOLO VALLEY DR (2,688,825) - (64,965) (173,653) 149 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2011 GO BONDS-TOWN CREEK REGIONAL DETENTION 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Capital - 5,350,119 5,350,119 5,203,161 Total Beginning fund balance - 5,350,119 5,350,119 5,203,161 Revenues 119 30,000 10,142 11,155 Other financing sources 5,445,487 - - - Total available 5,445,606 5,380,119 5,360,261 5,214,316 Expenditures Town Creek Detention - 1,500,000 157,100 5,214,316 Other financing uses 95,487 - - - Reserved for Capital 5,350,119 3,880,119 5,203,161 - Ending fund balance 5,350,119 3,880,119 5,203,161 - 150 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2011 GO BONDS-TOWN CREEK REGIONAL DETENTION REVENUES 53-35100-00-00 INTEREST 119 30,000 10,142 11,155 53-35350-00-00 BOND PROCEEDS 5,350,000 - - - 53-35351-00-00 BOND PREMIUM 95,487 - - - TOTAL REVENUE 5,445,606 30,000 10,142 11,155 EXPENDITURES 53-51060-00-00 BOND ISSUANCE COSTS 95,487 - - - 53-57400-00-00-41 EASMENTS/SURVEY/ACQUISITION - - 7,100 - 53-57500-00-00-41 TOWN CREEK REG DETENTION-ENG. - 500,000 150,000 350,000 53-57600-00-00-41 TOWN CREEK REG DETENTION-CONST. - 1,000,000 - 4,864,316 53-57650-00-00-41 TOWN CREEK REG DETENTION-TESTING - - - - TOTAL EXPENDITURES 95,487 1,500,000 157,100 5,214,316 2011 BOND-TOWN CREEK REG DETENTION 5,350,119 (1,470,000) (146,958) (5,203,161) 151 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2011 GO BONDS-BALLFIELDS 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Capital - 3,300,073 3,300,073 3,305,257 Total Beginning fund balance - 3,300,073 3,300,073 3,305,257 Revenues 73 15,000 5,184 5,702 Other financing sources 3,359,022 - - - Total available 3,359,095 3,315,073 3,305,257 3,310,959 Expenditures Ballfields - 1,500,000 - 3,310,959 Other financing uses 59,022 - - - Reserved for Capital 3,300,073 1,815,073 3,305,257 - Ending fund balance 3,300,073 1,815,073 3,305,257 - 152 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/17/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2011 GO BONDS-BALLFIELDS REVENUES 54-35100-00-00 INTEREST 73 15,000 5,184 5,702 54-35350-00-00 BOND PROCEEDS 3,300,000 - - - 54-35351-00-00 BOND PREMIUM 59,022 - - - TOTAL REVENUE 3,359,095 15,000 5,184 5,702 EXPENDITURES 54-51060-00-00 BOND ISSUANCE COSTS 59,022 - - - 54-57400-00-00-61 EASMENTS/SURVEY/ACQUISITION - 1,500,000 - 1,500,000 54-57500-00-00-61 BALLFIELD CONSTRUCTION - - - 1,810,959 TOTAL EXPENDITURES 59,022 1,500,000 - 3,310,959 2011 BOND-PROPOSITION 4 3,300,073 (1,485,000) 5,184 (3,305,257) 153 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2012 CERTIFICATES OF OBLIGATION-WATER PROJECTS 2010-2011 CURRENT REVISED PROPOSED ACTUAL BUDGET BUDGET BUDGET Reserved for Capital - - - - Total Beginning fund balance - - - - Revenues - - - - Other financing sources - - - 7,000,000 Total available - - - 7,000,000 Expenditures Water system projects - - - 7,000,000 Other financing uses - - - - Reserved for Capital - - - - Ending fund balance - - - - 154 CITY OF CIBOLO,TEXAS PROPOSED BUDGET FISCAL YEAR 2012-2013 7/18/2012 2010-2011 CURRENT REVISED PROPOSED Account Number Description ACTUAL BUDGET BUDGET BUDGET 2012 CERTIFICATES OF OBLIGATION-WATER PROJECTS REVENUES 55-35100-00-00 INTEREST - - - - 55-35350-00-00 BOND PROCEEDS - - - 7,000,000 55-35351-00-00 BOND PREMIUM - - - - TOTAL REVENUE - - - 7,000,000 EXPENDITURES 55-51060-00-00 BOND ISSUANCE COSTS - - - - 55-57400-00-00-XX EASMENTS/SURVEY/ACQUISITION - - - 1,000,000 55-57500-00-00-XX ENGINEERING - - - 500,000 55-57600-00-00-XX CONSTRUCTION - - - 5,475,000 55-57650-00-00-XX TESTING - - - 25,000 TOTAL EXPENDITURES - - - 7,000,000 2011 BOND-TOWN CREEK REG DETENTION - - - - 155 © r C,$ `t0�iJI1111010/1111/4945,447 0 re-% 0 it $ 41;x * _ * Lf: ;% Y 4 * 7*'n�i/nunaJU+ "City of Choice" 5-YEAR CAPITAL IMPROVEMENTS PROGRAM CITIZENS ADVISORY COMMITTEE REPORT TO THE CIP ADVISORY COMMITTEE AND TO THE CIBOLO CITY COUNCIL July 18, 2012 157 TABLE OF CONTENTS Introduction 3 Organization 3 Process 3 Findings 4 Recommendation 6 Conclusion 6 Appendix 7 -Capital Improvements Program Detail Report City of Cibolo 5-Year CIP Page 2 158 INTRODUCTION This document is the annual report to the Cibolo CIP Advisory Committee and the City Council of the 5-Year Capital Improvements Program (CIP) Citizens' Advisory Committee. The report contains the Committee's recommendations on priority and phasing of Cibolo's capital improvement projects. It is important to note that this report is a living document. The information on each project is the best the Committee has been able to obtain as of the date of this report. However, as more information becomes available and events continue to transpire, project information, timing, and priorities will require updating. ORGANIZATION The Citizens Advisory Committee is comprised citizens of the City of Cibolo who are members of the following standing Boards and Commissions of the City of Cibolo: - Streets and Drainage Commission - Planning and Zoning Commission - Parks and Recreation Commission - Economic Development Corporation PROCESS This year's Committee began with the 2007 CIP report as a baseline and reviewed progress of each listed project since the date that report was submitted to the Council. We also conducted an orientation for all members at the first meeting in 2012. Staff reviewed the Goals and Objectives of the 2005 City of Cibolo Comprehensive Plan and the steps that had been taken by the City of Cibolo to address those Goals and Objectives. Staff also reviewed the Opportunities and Challenges that will influence the future of the City of Cibolo. Staff indicated that the City grew at a rate of 58% per year between 2000 and 2012, adding approximately 1,700 new citizens per year. Staff also pointed out that the boundaries of Cibolo now extended from 1-35 to 1-10 and from Cibolo Creek to Seguin. Staff also described that population and water demand projections and forecasts indicated that the needs of the region, including Cibolo, would increase exponentially between FY 2014-2020 and that recent development activity suggested that those needs we beginning to become evident. City of Cibolo 5-Year CIP Page 3 159 Staff also described that the cities of Cibolo and Schertz coordinating with Cibolo Creek Municipal Authority (COMA) regarding the future wastewater treatment plant needs to develop territory in each city south of FM 78. During the CIP process, staff continued to update the Committee about updates made to the Future Land Use Map and to the Future Thoroughfare Plan. Staff carefully explained how those updated land use assumptions and traffic improvements related to regional land use and traffic plans of adjoining jurisdictions and TxDOT. During the review process, the Committee, staff and City Engineer collected input from all city committees, citizens, staff and City Council members. This input was prioritized using an objective ranking system and independent rankings by Committee members and staff to determine those projects that needed the greatest priority in the CIP rankings. It ( should be noted that the Committee gave additional priority to those projects that were approved by the citizens of Cibolo in the 2008 bond election that had not been completed or initiated because additional funding was required. The Committee reviewed the submitted projects and discussed rankings using all available information. The discussions were open and constructive, and the members considered a wide variety of city needs in determining our recommended priorities in the attached Project List. The approved, recommended Project List is based on the members' assessment of need without consideration of cost, although the members understand that funding will affect how the city implements the list. FINDINGS The Committee found tremendous progress has been achieved since the 2007 CIP was adopted. The Council, staff, and citizens faced up to daunting needs in public safety and health, conducted the necessary research, built an actionable plan, and committed the resources through a variety of funding methods. As a result, Cibolo has a new Fire Station, Police Station, recreational facilities, downtown improvements and completed substantial traffic and drainage projects. This year's report focuses on water and sanitary sewer infrastructure needs of the City to expand commercial and industrial opportunities for the City along 1-10, 1-35, FM 78 and FM 1103. Funding should be provided to participate in regional water and wastewater treatment projects as City of Cibolo 5-Year CIP Page 4 160 soon as these opportunities arise and as soon as the City of Cibolo is asked to contribute a pro-rata share for the completion of a regional wide project. City participation on regionally based projects will be critical to minimize the expense of projects on the taxpayers in Cibolo. Regional coordination, cooperation and alliances will be essential for all projects, but even more so for water and wastewater treatment projects. Additional attention was provided to improve mobility along the Green Valley Road corridor and between FM 1103 to 1-10. High priority was given to complete drainage improvements that were already partially funded to Town Creek to protect property, create economic opportunities and to sustain quality of life, especially for "Old Town" Cibolo. The Committee also acknowledges the need for expanded emergency response facilities along FM 1103 and 1-10 due to the city's continued growth. Green spaces, parks, and recreation facilities are very important issues, and the Committee is convinced that these types of projects must receive priority for the city to achieve the opportunities and lifestyle our citizens need. This was evident by the approval of projects in the 2008 bond election. Additional ClP funding for parks and recreation projects is only proposed to address funding shortfalls between the funding approved by the voters in 2008 and the actual cost of approved projects. As the city continues to grow and expand, a critical need to expand • governmental facilities will begin to emerge. These needs will include city maintenance facilities, animal control and communication facilities. The City owns properties that can be expanded or redeveloped to better utilize the assets the City currently control, but may need to consider the purchase of new property at strategic locations to properly deliver high levels of service to all areas of the community. • City of Cibolo 5-Year CIP Page 5 161 RECOMMENDATION The 5-Year Capital Improvements Program (CIP) Citizens Advisory Committee recommends the City council approve the attached 2012 Project List to complete those park and recreation and drainage { improvements that the voters approved in the 2008 bond election and the other high priority projects designed to facilitate and fuel the economic growth and development of Cibolo. CONCLUSION In conclusion, the Committee acknowledges that Cibolo still has numerous critical projects necessary to address each of the infrastructure, public safety and quality of life issues facing the city in order to achieve levels of service typically found in top-grade communities of this size. However, the task can be achieved over time with creativity, persistence, and the long-term dedication of the citizens and their government. The Committee thanks the many members of Council, staff, and the community who contributed their own expertise and resources to build this plan. Without their dedication and perseverance, we could not have produced this CIP. Dick Hetzel CIP Committee Chair City of Cibolo 5-Year CIP Page 6 162 �yy rix 0P "City of Choice" APPENDIX 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAIL REPORT City of Cibolo 9 1 1 City of Cibolo 5-Year CIP Page 7 163 1 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year I at 7%for the year.and,Year 2 at 3%.Year 3 at 2%.and Year 4&5 at 1%compounded monthly CIP Ranking. - Project Project Description Annual Proposed Mainten- Funding once Year 1 Offline Regional Detention(in Construct a regional detention facility bow ' r= ' '_' --:- '' + ' C of FM 78 t6 -'py Funded town Creek/Central Park) Phase 1 Is 1.5 Million for land acquisition/engineering fees and 3.5 Million for construction. If this project is built first,the Coon Ci Council _ Lane levee&°.P e regional detention projects will not be required. `-" '' "- through , g p 1 q �,« - - Bond Sales city 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost FY 2011 Gonturgency differential 2012 Bond,'IMPaCt fees,privdte funds,park fuflds,A B`fundt 4 ter" grants Project Project DescripHon Annual Proposed Mainten- Funding once Year City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%cim) cost Contingency differential �I G Ir i_d, Ip• 1. CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 3 Water Storage&Distribution Provide water storage and distribution facilities along IH 35 and IH 10 __ City Council Project Funding Source Base Cost+ :2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year j Project Funding Year 10% (7%/year.: 3% 1sp. (27.c/m) (1%c/m) (1%c/m) cost Contingency "F. differential CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 4 Extend Sanitary Sewer along Extend Sanitary Sewer Main along the entire length of FM 78 between Santa Clara and Schertz __ Entire Length of FM 78 City Council Project funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 165 2012-17 CIP Draft 2 11111111110 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year 1 at 7%for the year and.Year 2 at 3%,Year 3 at 2%,and Year 4&5 at 1%compounded monthly. CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 5 Extend Sanitary Sewer Service Extend Sanitary Sewer Service along South Main Sheet and Haeckerville Road south of FM 78 -_ South of FM 78 City Council Project Funding Source Base cost' 2-2M3r-: 4' 2014-2015 2015-2016 2016.2017 5-year c•p, tFutOtrviiYear 107: ' /Year) " (2%c/m) (1%c/m) (1%c/m) cost Contingency differential MEM CIP Ranking Project Project Description Annual Proposed Mainten- Funding ance Year 6 Borgfeld Road Widen to full build out(4 lanes)between Schertz&Main Street,including the widening of the Dietz Creek bridge. __ City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 7 Lower Seguin Road to Drainage and associated street improvements to Haeckerville Road between FM 78 and Lower Seguin Road,potentially to Haeckerville Road include the realignment of the intersection of Haeckerville&Lower Seguin Roads.The road interchange may need to be broken out of this project into a secondary Phase II Improvement. City Council Project Funding`SioUrce ' Bose Cost+ ' 3` 2013-200"45,18-1805 ''2(j`T5.2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%aim) (2,%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 8 Tolle Road Drainage Channelization and possible crossings;dredging,ditches,culverts,and associated drainage Improvements on Tolle Road from Improvements Weil Road to FM 78. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 20T5-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential.. $0 166 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year 1 at 7%for the year,and,Year 2 at 3%.Year 3 at 2%.and Year 4&5 at 1%compounded monthly. CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 9 Town Creek West Drainage Construct channel Improvement along the main stream of Town Creek Facility City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 11111111111111 $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 10 Water Storage and Distribution Provide water storage and distribution improvements In vicinity of the intersection of Lower Seguin Road and Haeckerville Road. City Council Project Funding Source Base Cost+ 13 2013-2014 2014-2015 2015-2016 2016-2017 5-year . - Project Funding Year 10% 1.�- ) (3%c/m) (2%c/m) (1%c/m) (1%c/m) co Contingency differ- _-__MEM CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 11 Public Safety Facilities I Wiedner Road&IH-10 substations,dispatch,including facilities and equipment emergency operation management and remodeling of existing facilities.Project may need to be phased over a 5.7 year time horizon. City CouncilAlj ,: Boyce; .. ;,-n Base Cost+ 2012-2013 -2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year" 10% (7%/year) ` 3%c/m) (2%On) (1%c/m) (1%c/m) . cost ncy differential CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 12 Expand Available Water Placeholder for capital improvement expenses(CRWA Plant,purchase water rights,ties to other systems,additional water I Sources treatment capacity,cultivate regional partnerships,purchase water wells etc)as opportunities materialize. City Council Project FundkigSOurce"`. " Base Cost+ ='"2012-2013 -"2013.2014 -2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential: Mil $0 167 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year 1 at 7%for the year.and,Year 2 at 3%.Year 3 at 2%.and Year 4&5 at 1%compounded monthly CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 13 Community and Future facility/facllftes and 20-50 acres of land acquisition.Project may be combined with a community center,which would Neighborhood Park require 5-20 acres of land acquisition. Partial funding for this project was approved by the voters In the 2008 Bond Election. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential. $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding ance Year 14 Sports Complex Sports Complex-Multi-Sport(softball/baseball,soccer and football) City Council Project Funding Source Base Cost+ "2012-2013 2013-2014 2014-2015 2015-2016 2016-2017- 5-year Project funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 1111111111111 CIP Ranking Project Project Description Annual Proposed Mainten- Funding ance Year 15 Green Valley Road West of FM Widen to 4 lanes and bridge Town Creek West floodplain __ 1103 City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding ance Year 16 Town Creek East Phase 2 Channelizatlon thru Rosenthal,Gatewood and Medallion to 1103;Detention on Rosenthal and Saddle Creek Ranch City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential FM 1103 ROW Acquisition 10Acquire ROW to realign to 1103 from BrtteMRoad I IH- 10 and to upgrade the intersections of FM 1103 with Brite&Weil Roads. 168 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year I at 7%for the year,and.Year 2 at 3%,Year 3 at 2%,and Year 4&5 at 1%compounded monthly. CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 17 FM 1103 to Wiedner Road Constructs channel improvement along Town Creek's mainstream,north and upstream of FM 1103 toward Wiedner Road. City CouncilMir Project Funding Source Base Cost+ ``2012-2013 '4= 2016 2016-2017 5-year Project Funding Year - 10% (7%/year) o C. /m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 18 South of FM 78 Extend sanitary sewer servives to 111 10 __ City Council Project Funding Source Base Cost+ 2012-2013 2013.2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% {7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 1111.1 CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 19 Extend Sanitary Sewer Main Extend sanitary sewer to provide service to development on IH 35 North to 1-35 City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (T%c/m) (1%c/m) cost Contingency differential __ $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding ance Year 20 Green Valley Road East of FM Widen to 86'ROW F.Pavement Standard,in concert with required traffic improvements being Installed by Enclave of Turning 1103 Stone,Heights of Cibolo and Landmark Pointe. WCity Council' Project Funding Source " ''Base Cost+ `2013-2014 2014-2015 2015-2016 2016-2017 5-year oject Funding Yea 10" (7%/yearj (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 169 2012-17 CIP Draft 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT 41111111111111M1 , Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year 1 at 7%for the year,and,Year 2 at 3%.Year 3 at 2%,and Year 4&5 at 1%compounded monthly. CIP Ranking Project Project Description Annual Proposed Mainten- Funding ance Year 21 Upgrade Existing Detention Several existing residential detention ponds are designed to detain 100-year storm events but do not provide detention for 5 ponds to detain 5&25 year and 25 year storm events. storm events City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 22 Wiedner Road Realignment ROW acquisition,new Wiedner Road pavement section between Gatewood and FM 1103 Phase 1 City Council Project Funding Source Base Cost` 3'`'2013-2014 2014-2015 2015-2016 2016.2017 5-year Project Funding Year 10°' • (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Continge �� differential $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 23 Wiedner Road Drainage -Improve existing drainage conditions between Town Creek Road&FM 1103 and realign Wiedner Road to provide safe east- improvements west access City Council Project Funding Source Base Cost+ 2012-2013 2013.2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency "°�- differential CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 24 Old Town Provide underground storm drainage systems;underground dry utilities;and outfalls City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 170 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year 1 at 7%for the year,and.Year 2 at 3%.Year 3 at 2%,and Year 4&5 at 1%compounded monthly CIP Ranking Project Project Description Annual Propo -- Moisten- Fundi once Yea 25 Public Works Expansion and Expand existing facilities and purchase infrastructure crBBcal infrashxucture makdenance equipment - Facilities City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2014-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 26 Downtown Parking Possible building removal,land acquisition and Union Pacific Coordination to provide landscaped downtown parking facilities. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 27 Wastewater Extension Extend sanitary sewer facilities along and toward FM 1103&Green Valley Road"In progress" __ City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%clm) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Annual Propo -- Mainten- Fundi once Yea 28 Water CCN Acquisitions Purchase strategic GVSUD Infrastructure&and undeveloped CCN areas in the Cibolo City Limits&ETJ. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/rn) (1%c/m) cost Contingency differential $0 171 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT • Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year 1 at 7%for the year and,Year 2 at 3%,Year 3 at 2%,and Year 4&5 at 1%compounded monthly CIP Ranking Project Project Description Annual Proposed Mainten- Funding once Year 29 Old Wiederstein Road Joint Venture with Schertz to provide traffic signals and other Intersection Improves at the Intersections of Old Wlsdersfeln Road and Clbolo Valley Drive&Dean Road. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014.2015 . 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%cr m) (1%c/m) (1%elm) cost Contingency differential $0 -TOTAL ESTIMATED CIP ----_ 172 2012-17 CIP Draft 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year 1 at 7%for the year.and.Year 2 at 3%,Year 3 at 2%.and Year 4&5 at 1%compounded monthly. ACCESSORY PROJECT LIST AND PROJECTS OUTSIDE 5-YEAR CIP WINDOW FOR FUTURE CONSIDERATION CIP Project Project Description Proposed Previously Funding Year Ranked 30 Lower Seguin Road Improee Lower Seguihip with Road o UDC r sheet sty may ---- � require partnership with Schertz&Guadalupe County to upgrade the Cibolo Creek low water crossing. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Proposed Funding Year 31 Animal Control Expanded Facilities,possibly as a joint venture with Schertz City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2917 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 111111111111 $0 CIP Ranking Project Project Description Proposed Funding Year 32 Green Valley Road Drainage Grade channel bottom behind Charleston Parke&at floodplain ---_ City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 . 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential OMEN $0 173 2012-17 DIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year 1 at 7%for the year.and,Year 2 at 3%.Year 3 at 2%.and Year 4&5 at 1%compounded monthly. CIP Ranking Project Project Description Proposed Funding Year 33 Old School Building Expand City services,pon a community meeting room and provide additional downtown parking and green space. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017. 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 34 Buffalo Crossing Unit 1 Provide outfall from the FM 1103 enhance into Buffalo Crossing ____ Entrance to Town Creek East. City Council 11,i Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year • - 10% (7%/yeor) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differentiae $0 CIP Ranking Project Project Description Proposed Funding Year 35 Neighborhood Infrastructure esPak street,utility,drainage ,utility improvements to Upgrades Falcon. Crest,Park Valley,Crystal Valley,Cibolo North,Five Leaf Park& Four Leaf Park neighborhoods. City Council Project Funding Sours"'-'--`-5� -'>fdiea' *'`' - 2013-2014 2014-2015 2015-2016 2016-2017 5-yea0 Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential') CIP Ranking Project Project Description Proposed Funding Year 36 Industrial Street Reconstruction Upgrade and/or reconstruct industrial park streets,signals&turning ____ radii designs to heavy duty Industrial street standards. City Council Project Funding Soued1WIRMplose Cost+ 2012-2013 2013-2014 2014.2015 2015-2016 2016-2017 5-year Project Funding Year -" 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 174 2012-17 CIP Draft 2 VEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year I at 7%for the year.and.Year 2 at 3%.Year 3 at 2%,and Year 4&5 at 1%compounded monthly. CIP Ranking Project Project Description Proposed Funding Year 37 Industrial Park Drainage Upgrade drainageconveyance fies in allprojects. parks in conjunction with the Industrial street upgrade projects. City Council Project Funding Source _Mase Cost+ 2012- r • 5 20154016 20164017 5-year Project Funding Year 10% (7%/year) (3%c/ 'c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Proposed Funding Year 38 Neighborhood and Land acquisition(appx.20 acres)and a 15,000 square foot recreation Community Center Facilities facility that includes Indoor gym,offices,meeting rooms,fitness equipment,2-outdoor half basketball courts,playground,sand volleyball,landscaping&parking to provide indoor&outdoor park L recreation programs,trails and fitness areas. City Council .. :.-_. ;naio.r:.a Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Proposed Funding Year 39 Main Snterct a g 1103 Intercdevelopments tIm occuring may be partially or totally funded O 1.111. Interchange developments occuring In the vicinity of this interchange&TxDOi. ' City Council "%sjectFunding!Some Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 S-year Project Funding Year 107, (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Proposed Funding Year 40 City Wide Communications Radio system for all department&and dark fiber Installation. -_____ City Council Project funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 175 2012-17 CIP Dreg 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year 1 at 7%for the year,and,Year 2 at 3%,Year 3 at 2%,and Year 4&5 at 1%compounded monthly CIP Ranking Project Project Description Proposed Funding Year 41 Wledner Road Realignment ROW acquisition/new sheet section from Gatewood to Town Creek -- Phase 2 Road City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential $0 CIP Ranking Project Project Description Proposed Funding Year 42 Greenbelt/Linear Parks Develop lineal park network and develop a hike&bike trail network. ____ City Council Project Funding Source Base Cost+ _ 1;3 2013-2014 2014-2015- 2015-2016 2016-2017 .. 5-year Project Funding Year 10% ) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 43 Sewer CCN Acquisition Purchase and/or negotiate for the release of GVSUD sanitary sewer CCN within the City of Cibolo. City Council Project Funding Source Bose Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 176 2012-17 CIP Draft 2 IIIIIIIIINIIIIIIIIIIIIIIIIMIIIIIIIIIMIIIMIVPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year 1 at 7%for the year,and,Year 2 at 3%,Year 3 at 2%.and Year 4&5 at 1%compounded monthly CIP Ranking Project Project Description Proposed Funding Year 44 Critical Sheet Lighting !Provide critical lighting at various locations the need lightning for ;public safety concerns,such as subdivision enhances off of highways and arterial streets and areas where accidents may be occuring.This covers the expense for tightis to be Installed by GVEC at City request. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 45 Uniform Platform City Software Soeg at includes,tb but,s not limited,inspections t creating a Sprogr platform to _-_- Integrated utility billing,court,inspections and GIS programs. CBy Council `> Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015.2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential MEM CIP Ranking Project Project Description Proposed Funding Year 46 Doble Blvd Reconstruction standards. Dobls Boulevard and cul-de-sacs to City pavement ____-- standards. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 47 Dobie Blvd(Creek/Drainage) Stabilize drainage channel improvements and drainage conveyance. I ---- City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%cirri) (1%c/m) cost Contingency differential 177 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency. Year 1 at 7%for the year.and.Year 2 at 3%.Year 3 at 2%,and Year 4&5 at 1%compounded monthly. CIP Ranking Project Project Description Proposed Funding Year 48 Pavement Management Technical pavement condition analysis to determine road life, Program maitenance recommendations,road life/replacement expectancy ;and timing for critical improvements. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year ject Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential MEM CIP Ranking Project Project Description Proposed Funding Year 49 Existing Parks(All Parks) Provide additional park facility 8 equipment upgrades. ____ City CouncilMiitt.l. PI ProjectFunding Source Base Cost 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%aim) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 50 City Hall Expansion-Phase 1 6,400 SF City Hall wings&parking tar multiple uses. __-___ ....r..,� ._ CBy CouncB "`'` Project Funding Source Base Cost+ 2012.2073 2013.2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%elm) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 178 2012-17 CIP Draft 2 PROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year 1 at 7%for the year,and,Year 2 at 3%.Year 3 at 2%,and Year 4&Sat 1%compounded monthly. CIP Ranking Project Project Description Proposed Funding Year $j Expand Cr DrainagekRRat Dietz Partnerraiwith tcher &Dietz rPeeks to expand RR bridge to improventmust RR Bridge drainage outfall from Dietz Creek to Cibolo Creek. Improvement must take in account downstream impacts. City Council Project Funding Source Base Cost+ `2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 52 SctaeRef Road Road ing&elevatingpartnership i the low z water crossing Ct unty. Creek; may require partnership with ScherK&Guadalupe County. City Council Project Funding 71"'—` Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 53 Deer Creek Low Water Install signage,lighting and/or crossing guards to improve public Crossing safety at this low water crossing City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%con) cost Contingency differential 179 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year I at 7%for the year,and.Year 2 at 3%.Year 3 at 2%,and Year 4&5 at 1%compounded monthly CIP Ranking Project Project Description Proposed Funding Year 54 Schlather Sheet Alley Upgrade alley to City pavement standards. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contngencyirmisdifferential CIP Ranking Project Project Description Proposed Funding Year 55 Traffic Signals-FM 78 78 atm rovekerntse Road and Main Sheet intersections a .Funding for these ---- improvements may required by developers as a condition of TIA approval for development projects. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/rn) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential CIP Ranking Project Project Description Proposed Funding Year 56 Traffic Signal-FM 1103 FM 1103 at Weidner,Orth,Buffalo Crossing,Steele&Haeckerville Road Extension intersections.Funding for these improvements may required by developers as a condRion of TIA approval for development projects. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%elm) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential MEM CIP Ranking Project Project Description Proposed Funding Year 57 Country Lane RR Grade ad heiterEliminate/Relocate do or Redesign ign Country Luiree Raartnersh Grade Crossing ---- Crossing and the intersection with FM 78.May require partnership with Guadalu•-Coun and Union Pacific Railroad. City Council Project Funding Source Base Cost* 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/rn) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 180 2012-17 CIP Draft 2 2012-2017 CAPITAL IMPROVEMENTS PLAN DETAIL REPORT Updated July 26,2012 Key: Cost projections based on Base Cost including 10%contingency Year 1 at 7%for the year,and.Year 2 at 3%,Year 3 at 2%.and Year 4&5 at 1%compounded monthly CIP Ranking Project Project Description Proposed Funding Year 58 Quiet Zones Requires rood improvementsat all railroad grade crossings and will ---- require partnership with Union Pacific Railroad. City Council Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year 10% (7%/year) (3%c/m) (2%aim) (1%c/m) (1%c/m) cost Contingency - differential CIP Ranking Project Project Description Proposed Funding Year 59 Country Lane Levee Construct a levwn .Country Lane with the participation o it the ---. affected landowner.This project is not needed if the Priority 1 project for Offline Regional Detention is built. City Council r . ecuFunding Source Ras e Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year Project Funding Year _ 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential MIMI CIP Ranking Project Project Description Proposed Funding Year 60 Town Creeke Oention Regional Construct is online regional f Priority along Town Creek(mRegiosheam). ---- Detention This project is not needed if Priority 1 project for Offline Regional Detention is built. „ City Council s- Project Funding Source Base Cost+ 2012-2013 2013-2014 2014-2015 2015-2016 2016-2017 5-year ect Funding Year 10% (7%/year) (3%c/m) (2%c/m) (1%c/m) (1%c/m) cost Contingency differential 181 2012-17 CIP Draft 2 FUND STRUCTURE Currently the City maintains the following funds: GOVERNMENTAL Major Funds 01 -General Fund Special Revenue Funds 20- TPWD Grant Fund 21 - Cibolofest Fund 29-Traffic Impact Fee Fund 30- Street Impact Fee Fund 31 - Drainage Impact Fee Fund 32- Park Land Fees Fund 33- Court Technology Fund 34- Court Security Fund 35- Police Seizure Fund 36- Police Education Fund 37- Special Police Fund 38- Child Safety Fund 39- Street Maintenance Fund Capital Projects 06- Capital and IT Replacement Fund 07- 2006 Tax Note Fund 09- 2008 Multi Event Venue 50- 2009 Bond Police Station 51 - 2009 Bond Fire Station 52- 2009 Bond Cibolo Valley Drive 53- 2011 Town Creek Regional Detention 54- 2011 Proposition 4 183 Debt Service 03- Debt Service Fund PROPRIETARY FUNDS Business-Type Activities 02- Water/Waste Water Fund 12- Water/Waste Water 2006 Bond Fund 14- Water/Waste Water 2007 Bond Fund 22- Water Impact Fee Fund 24- Waste Water Impact Fee Fund 40-Drainage Utility District COMPONENT UNIT 05- Economic Development Corporation CHART OF ACCOUNTS& ACCOUNT CLASSIFICATION SYSTEM ASSETS REVENUE Fund Source Code Fund Source Code XX - 1XXXX XX - 3XXXX LIABILITIES & FUND BALANCES EXPENDITURE Fund Source Code Fund Object Code Department XX - 2XXXX XX -5XXXX -40 to 99 Note: Account numbers always begin with two digits for the Fund. Assets begin with "1". Liabilities and Fund Balances begin with "2". Revenues begin with "3". Expenditures will be preceded by department beginning with "40 to 99"followed by a four digit object code beginning with "5". 184 OBJECT CODE CLASSIFICATION EXPLANATION FOR EXPENDITURES 51010 Salaries Salaries and wages paid to employees filling council approved positions based on approved salary pay scale. 51011 Longevity Pay Additional compensation based on years of services paid to regular full-time employees at a rate of$10 per month for each full year. This is paid once yearly in September for employees employed for 1 year or more. 51012 Car Allowance Allowances to City Employees for expenses incurred in the performance of official duties such as use of private vehicle. This dollar allowance is received through payroll. 51013 Certificate Pay A fixed amount set by the City for approved certifications held by full-time employees. 51015 Overtime Pay received by employees for hours exceeding their regular workweek in accordance with federal wage and hour laws. 51016 Phone Allowance Monthly reimbursement to approved employees for use of personal cell phones while performing official City duties. 51017 On Call Pay A fixed amount set by the City per week paid to selected employees for being on-call to handle emergency issues during the week. 51020 Unemployment Tax Texas unemployment compensation act requires contribution by employers for payment to eligible unemployed individuals. Cost incurred is a percentage calculated each January by the state and is based on wages for each employee up to$9,000 during the calendar year. 51030 Social Security/Medicare City's portion of mandatory contributions into the Federal Social Security System. At the total rate of 7.65%. This is divided so that 6.2%goes to OASDI and 1.45%goes to Medicare. 51040 TMRS City's participation to Texas Municipal Retirement System (TMRS) for all positions performing 1000 hours plus per fiscal year. The City's portion of the rate changes in January of each year and is 11.04%as of January 1,2011. 51060 Health-Life Insurance Includes the City's portion of life, health, dental, and vision coverage available to full time employees. The City does not pay for dependent insurance. 51070 Worker's Comp Charges paid to Texas Municipal League Intergovernmental Risk Pool (TML) for insurance coverage relating to on-the-job injuries. 52095 Medical Exams Costs directly related for pre-employment/on-the-job accidents for physicals and drug screen. 52200 Data Processing Includes supplies and software for the operation of a computer. 185 52420 Judge and Prosecutor Fees paid for professional services for Municipal Court appearances. 52510 Utility Lab Fees The cost of required chemical analysis of the City's drinking water supply performed by an outside agency. 52610 Contract Services Includes all contractual agreements including leasing of equipment,software annual fees,contract supplies,and janitorial services. 52611 Inspections Services Contract Fees paid to outside firm for assisting in plan review/inspections of new homes. 52615 Contract Maintenance Streets Fees paid to outside contractors for street repair and maintenance as determined by council. 52620 Publications Cost for subscriptions, professional publications and reference books. 52625 Advertising Cost for publication of all legal advertising, public notices, and recruiting. 52630 Travel and Training Travel costs, lodging and meals while attending outside training and educational functions. This account will include tuition and registration of all professional meeting and seminars. 52635 Dues and Fees Costs pertaining to annual memberships, dues, and licenses with professional organizations and associations. 52640 Billing Service-Data Prose Cost related to printing and sending of the City's water bills by the service Data Prose. 52650 General Liability Insurance Premiums paid to TML for general comprehensive liability, automobile/automobile physical damage liability, law enforcement liability, errors and omissions. 52670 GCAD/GCTAC Professional fees paid to Guadalupe County Appraisal District (GCAD) to account for the cost of obtaining the legally mandated appraisal services necessary to value property for ad valorem tax purposes. Professional fees paid to Guadalupe County Tax Assessor Collector (GCTAC) to account for the cost of collection/processing statements for ad valorem taxes for the City. 52680 Legal Services Any costs for legal services provided by attorneys, other than those reimbursed by insurance. 52710 Professional Services To include professional services performed for urban &regional planning, engineering, architectural, information technology,financial services, and those not relating to other specified categories. 52720 Audit Services Fees paid for professional services pertaining to the annual auditing of the city's financial records. 52720 Bond Paying Agent Fees Yearly administration fees paid to the various investment companies servicing bond payments and bond issuance costs amortized over the life of the bond. 186 52750 Marketing and Business Development Includes promotion of City culture, positioning and positive recognition in the region,state & nation, through market research and development, new business development and retention, tourism, advertising, promotion, and public/press relations. 52780 Medical and Lab Costs related to performing any required chemical/crime scene analysis for police and fire investigations. 52810 Utilities Costs for water, electricity, gas for city facilities. 52815 CPS-Street Light Utilities Cost of electricity for street lights and traffic signals. 52820 Telephone Costs related to telephone service, pagers, cell, and other communications services. 52850 Newsletter Costs related for printing and postage of quarterly newsletter for the City. 53090 Uniform and Clothing Costs to maintain/replace uniforms, badges, belts, boots, hats, etc., required to be worn in the course of an employees'job. 53095 Safety Supplies/Equipment Equipment and supplies necessary for safety such as gloves, safety vests, first aid kits, glasses,ice, dehydration drinks, traffic/safety cones, barricades, hard hats, and rain slickers. 53210 Office Supplies Supplies for general office use such as paper, pads, pens, pencils,ink cartridges, etc. 53215 Printing Costs associated with printing of card stock, door hangers,forms, business cards, etc. 53220 Janitorial Supplies All materials and cleaning supplies purchased for cleaning City facilities. In addition to paper products purchased for bathrooms and kitchens. 53225 Office Machinery and Equipment Includes items such as office furniture, file cabinets,computers, printers,fax machines, and electronic equipment approved by the City. Items with values of less than$9,999. 53230 Other Supplies Additional materials and supplies needed for the operations of the city no relating to other specified categories. Includes costs for in-house projects to promote employee relations. 53240 Postage All materials related to postage and delivery for city business. i.e., postage, courier service, express mail, invoiced shipping charges. 53250 Officer's Equipment-Supplies Costs for replacement of equipment and supplies for police department as needed. 53260 Crime Prevention Supplies Cost for supplies for crime prevention. 187 53270 Operating Supplies Costs for supplies used in specific operations. 53271 Main Repair Water Maintain and repair of water system lines, hydrants,water towers, pumps.To include supplies such as pipe, clamps, fittings,and rock. 53272 Main Repair Sewer Maintain and repair of sewer system lines, lift stations, and pumps.To include supplies such as pipe, clamps,fittings, and rock. 53275 Maintenance Supplies-Street Maintenance of city dedicated streets,roadways, and sidewalks, including hot mix asphalt, gravel, rock,rebar, concrete,form boards 53276 Maintenance Drainage Maintenance of city dedicated drainage ditches including top soil,sod, base, and seed. 53277 Rental Costs associated with rental of equipment needed to perform city work. 53280 Minor Tools and Equipment Articles normally of small unit value costing less than$1,000,which includes items such as testers, chain saw blades,shovels,weed eater heads,small hand tools, and batteries. 53410 Building Maintenance Materials for building repairs in addition to keys, key card, lettering, glass,signs, light bulbs, and alarm repairs. 53430 Office Equipment Repair All costs for maintenance and repair of office equipment to include maintenance contracts. 53440 Machinery Maintenance Includes supplies used in normal operation and routine maintenance of machinery/equipment. i.e.: oil change, radiator flush,wiper blades,flat repair. 53445 Machinery Repair Includes expenses incurred for major repair of machinery/equipment and purchase of new tires. 53450 Vehicle Operation Expense Includes supplies used in normal operation and routine maintenance of motor vehicles. i.e.:oil change, radiator flush,wiper blades,flat repair. 53455 Vehicle Fuel Fuel costs for vehicle and machinery/equipment operations. 53470 Vehicle Repairs Includes expenses incurred for major repair of vehicles and purchase of new tires. 53530 Signs Maintenance Includes all materials/services used in replacement/addition/maintenance of signs,signals, and street markings. 53610 Meeting Expense All materials and expenses used for Official City Meetings. 188 53620 Youth Council Items approved for expenditure by City for the youth organization. 53760 Awards Annual employee awards,council awards, proclamations, resolutions, plaques, etc. 53640 Election All costs related to the holding of city elections,such as location rental, printing of ballots,supplies etc. 54900 Non/Capital Outlay An expenditure that is an acquisition or an improvement (as distinguished from a repair) not included in other line items that is less than$9,999 and will have a life of more than one year. 54910 Capital Outlay An expenditure that is an acquisition or an improvement (as distinguished from a repair) of$10,000 or more that will have a life of more than one year. 54916 Water Line Projects Costs associated with specific water line projects to be performed by a third party or in house. 54917 Sewer Line Projects Costs associated with specific sewer line projects to be performed by a third party or in house. 54930 Communication Equipment All materials and services required for the proper maintenance and repair of communication equipment including the purchase of new equipment. 54955 New Meters Includes the purchase of new radio read water meters for replacement and new service. 55425 Credit Card Machine Fees Administrative and collection fees paid to Merchant Services for acceptance of credit card payments for city services. 55720 Fall/Spring Cleanup Semi-annual service provided to city residents to dispose of brush and materials. 55730 Library Donations Annual fee paid to City of Schertz to defray costs allowing for city residents use of library. 55732 GBRA Guadalupe-Blanco River Authority-contract provider for long-term raw water to the City of Cibolo. 55735 Transfer to General/Admin Transfer from the Water/Sewer Fund to the General Fund to pay for a share of administrative costs, insurance, utilities, and the benefit from other services. 55742 Schertz EMS Contract Annual fee paid to Schertz EMS to provide for emergency services to city residents. 55743 Public Safety Dispatch Annual fee paid to Schertz Police Department to provide dispatch services to the city. 55745 Cibolo Volunteer Fire Department Contract Annual fee paid to Cibolo Volunteer Fire Department to help defray their cost and to provide services to the city. 189 55762 Green Valley SUD Green Valley Special Utility District-contracted to provide an emergency supply of water to the City of Cibolo of up to 1 million gallons of water per day. 55763 Cibolo/Schertz Annual Line Maintenance Fee Fees paid to the City of Schertz annually through an interlocal agreement for homes which are connected to a sewer service line owned by the City of Schertz. 55767 Bexar Waste Contract Fees paid for refuse services provided to City by outside contract services. 55768 Refuse Transfer to General General Administration fee retained by City on refuse fees collected for services. 55769 CRWA Canyon regional Water Authority-a special district that provides treated water to the City of Cibolo for that portion of the community that falls within the Cibolo Water CCN. 57400 Land Acquisition Capital payments made for the purchase or use of land. 57500 Engineering Services Payments made for professional engineering services on a capital project. 57525 Surveying Payments made for surveying services on a capital project. 57550 Architectural Design Payments made for architectural services on a capital project. 57600 Construction Capital payments made for the construction of a capital project. 57650 Testing Payments made for the testing services on a capital project. 59xxx Debt Service Payments Payments made to service our debt obligations. 190