Loading...
HomeMy WebLinkAbout234-12 RESOLUTIONRESOLUTION NO. 234-12 A RESOLUTION ADOPTING THE 2013 ANNUAL BUDGET AND WORK PROGRAM BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF FAYETTEVILLE, ARKANSAS: Section 1: That the City Council of the City of Fayetteville, Arkansas hereby adopts the 2013 Annual Budget and Work Program. A copy of the Budget, marked Exhibit "A", is attached hereto and made a part hereof. PASSED and APPROVED this 4th day of December, 2012. APPROVED: ATTEST: Bv: %O ELD JOri� AN, Mayor By: SONDRA E. SMITH, City Clerk/Treasurer `,01t io e t • sem; FAYETTEVILLE: 2013 Adopted Annual Budget & Work Program ARKANSAS (Page Left Blank Intentionally) City of Fayetteville, Arkansas 2013 Annual Budget and Work Program City Council and Other Elected Officials Adella Gray, Ward 1 - Position 1 Brenda Boudreaux, Ward 1 - Position 2 Mark Kinion, Ward 2 - Position 1 Matthew Petty, Ward 2 - Position 2 Justin Tennant, Ward 3 - Position 1 Bobby Ferrell, Ward 3 - Position 2 Rhonda Adams, Ward 4 - Position 1 Sarah Lewis, Ward 4 - Position 2 Kit Williams, City Attorney Sondra Smith, City Clerk/Treasurer Rudy Moore, District Judge Submitted by Lioneld Jordan, Mayor Don Marr, Chief of Staff Paul A. Becker, Finance Director Greg Tabor, Acting Police Chief David Dayringer, Fire Chief Prepared by Kevin Springer, Budget Director Barbara Fell, Senior Financial Analyst Liz Hutchens, Financial Analyst Table of Contents Budget Message Budget Process & Policies Fund Summaries Personnel Summary Capital & Debt Appendix Index MISSION STATEMENT The City of Fayetteville's mission statement is a direct result of a volunteer team of employees charged with creating a mission statement that expressed the service core of City operations, reflected our beliefs concerning City services, and was easy to remember. All City employees were given an opportunity to provide input for the mission statement. The mission statement was then adopted by the City Council and is as follows: To protect and improve our quality of life by listening to and serving the people with pride and fairness. City of Fayetteville, Arkansas Table of Contents Budget Message: Transmittal Memo from the Mayor to Council I-II Budget Executive Summary III -XI Budget Resolution XII Budget Process and Policies: Budget Process 1-2 Budget Flowchart 3 Financial Policies: Revenue Policy 4 Expenditure Policy 5 Debt Policy 5 Reserve Policy 5 Investment and Cash Management Policy 6 Capital Improvement Policy 6 Financial Reporting Policy 6 • Administrative Procedures to Adjust the Approved Budget 7-8 Budget Organizational Structure 9-10 consolidated Fund - Department - Program Structure 11 Fund Summaries: Chart of Fund Types - Governmental 13 chart of Fund Types - Proprietary & Fiduciary 14 Sources and Uses of Funds 15 Multi -Year Comparison - Adopted Budget Expenditures 16 Governmental Funds: General Fund: Fund Description 17-25 Fund Summary 26 Category Summary 27-37 Special Revenue Funds: street Fund: Fund Description 39-40 Fund Summary 41 Category summary 42-43 Parking Fund: Fund Description 45 Fund Summary 46 Category Summary 47 community Development Block Grant Fund: Fund Description 49 Fund summary 50 Category Summary 51 Special State Grants Fund: Fund Description 53 Fund Summary 54 Category Summary 55 city of Fayetteville, Arkansas Table of Contents Energy Block Grant Fund: Fund Description 57 Fund Summary 58 Category Summary 59 Parks Development Fund: Fund Description 61 Fund Summary 62 category Summary 63 Impact Fee Fund: Fund Description 65 Fund Summary 66 category Summary 67 Drug Law Enforcement Fund: Fund Description 69 Fund Summary 70 Category Summary 71 Debt Service Funds: Fire Bond Fund: Fund Description 73 Fund Summary 74 Category Summary 75 TIF Bond Fund: Fund Description 77 Fund Summary 78 Category Summary 79 wastewater Improvements Sales Tax Bond Fund: Fund Description 81 Fund summary 82 category Summary 83 Capital Projects Funds: Replacement & Disaster Recovery Fund: Fund Description 85 Fund Summary 86 Category Summary 87 sales Tax Capital Improvements Fund: Fund Description 89 Fund Summary 90 category Summary 91 Capital Budget 92-93 wastewater System Improvements Project Fund: Fund Description 95 Fund Summary 96 Category Summary 97 Sales Tax Construction Bond Fund: Fund Description 99 Fund Summary 100 Category summary 101 City of Fayetteville, Arkansas Table of Contents Enterprise Funds: water & Sewer Fund: Fund Description 103-105 Operating Budget 106-107 Category Summary 108-111 Solid waste Fund: Fund Description 113-114 Operating Budget 115-116 Category Summary 117-118 Airport Fund: Fund Description 119-120 Operating Budget 121-122 Category summary 123 Town Center and Parking Facility Fund: Fund Description 124 Operating Budget 125 Category Summary 126 Trust Funds: Police Pension Fund: Fund Description 129 Operating Budget 130 Category Summary 131 Fire Pension Fund: Fund Description 133 Operating Budget 134 Category Summary 135 Internal Service Funds: Shop Fund: Fund Description 137 Operating Budget 138-139 Category Summary 140 Personnel Summary: Personnel Summary by organization Chart 141 Personnel Summary by Funding Source (FTE) 142 Personnel History by Funding Source (2004-2013) 143 Personnel Summary by Funding Source (Program) 144-146 Personnel Variation Summary 147 Personnel Summary by Activity (FTE) 148 Personnel History by Activity (2004-2013) 149 Personnel Summary by Activity (Program) 150-151 Personnel Detail by Activity &Division 152-164 Frozen Positions by Activity & Division 165-166 city of Fayetteville, Arkansas Table of Contents capital & Debt: capital Improvements Program Introduction 167-170 Capital Improvements Program Directional Information 171-173 Capital Projects Summary (2013) 174 Capital Projects Comprehensive Detail (2013) 175-179 Capital Budget (2013) 180-194 Debt Position 195 Description of outstanding Bonds 196-197 Schedule of Bonds outstanding 198 Debt Service Payment schedule 199 Legal Debt Margin Computation 200 Debt to Maturity schedule 201 Appendix: organizational chart 203 List of Elected Officials, Administrative officials, & Management staff 204 outside Agency Funding 205 Acronyms 206-208 Glossary 209-214 Index: Index 215-217 ave evi_le THE CITY OF FAYETTEVILLE, ARKANSAS ARKANSAS www.accessfayetteviRe,or. December 4, 2012 Members of City Council and Citizens of Fayetteville I am pleased to submit my adopted budget for 2013 for the City of Fayetteville. This budget has been prepared in accordance with the Arkansas Statutes and City Ordinances that require the Mayor, under the aldermanic form of government, to submit to the City Council the annual budget for approval. This budget allocates necessary funding for all municipal operations as well as necessary adjustments to the Capital Improvements Program for 2013. Once again, the budget was formulated in the context of my primary budget goals considering current economic conditions. 2013 Budgetary Goals My goals continue to be as follows: • To provide the same level of services to the public if possible • To retain the work force at the current level for necessary personnel but to evaluate the necessity of refilling open positions • To avoid increases in taxes to the citizen by keeping the millage rate the same as 201 1 • To continue to provide services to the citizen in the most efficient and effective manner possible • To fund needed Capital Improvements to the greatest extent possible • To scrutinize all City fund types for possible reductions • To present a General Fund operating budget that is balanced with operating revenue Telecommunications Device for the Deaf TDD (479) 521-1316 113 West Mountain Fayetteville, AR 72701 THE CITY OF FAYETf`EVILLE, ARKANSAS. Financial Environment The local economic conditions in Fayetteville have improved in fiscal 2012 when compared to the first two years of my administration. Sales taxes are up approximately 5.5% compared to prior year through the end of the third quarter of fiscal 2012. The City has also experienced an increase in building activity. Unemployment still remains at 4.9%, which does compare favorably to the rest of the State and Nation but still is high for Fayetteville historically. The specter of national economic problems loom. For these reasons, this budget has been formulated on conservative revenue and expenditure estimates. However, I am presenting a balanced budget for the General Fund. For 2013, we have forecasted all revenue sources to be equal to 2012 projections except for sales tax which we estimate at a 2.0% increase. Almost all positions frozen in the past will be continued. Many of the cuts made during the previous three years will remain in force. I have not included a full salary increase in my adopted budget. At the close of the 2012 fiscal year, I intend to analyze the City's financial position and if at all possible recommend a salary package that includes a full 4% for employees to the Council. Conclusion This budget is based on realistic revenue and expenditure estimates. I believe that it continues to provide for the best possible level of services while still guarding against possible weakening economic conditions. 2012 has been another busy year for the City and together we have accomplished a great deal. With the combined efforts of this Administration and City Council support, I am confident that we will meet the Challenges facing the City and continue to provide our citizens superior service levels. Lioneld Jordan, Mayor 11 Wt! ARKANSAS yettev lte.4rg; THE CITY OF FAYETTEVILLE, ARKANSAS December 4, 2012 Mayor Lioneld Jordan, Members of the City Council and Citizens of Fayetteville: The budget being presented is a 2013 operating budget. It does not include re -budgets that represent programs approved and appropriated in prior years which as of the end of fiscal 2012 remain uncompleted. Re -budgets also include amounts generated by previous bond issues in the Capital Project Funds which remain unspent as of December 31, 2012. Total rebudgets are likely to be in excess of $40,000,000. These re -budgets will be presented for addition to the 2013 operating budget early in the first quarter of 2013. In 2012, City and County Sales Taxes increased compared to 2011. By year end, total sales taxes are expected to be approximately 5.4% over prior year. Residential and commercial building has begun to increase but fees associated with permitting and construction will still be far below 2008 levels. Water and Sewer revenue collections have increased in fiscal 2012 due to unusually dry weather conditions during the summer months. Fuel and rent revenues at the airport are over 2011 collections. HMR revenue continues to increase and should finish the year up 7% over 2011 actuals. Other fund operations are relatively stable when compared to the prior year. The 2013 General Fund budget represents net expenditure increases from 2012 as an additional $1,917,800 was added compared to last year's budget. This was due to required increases because of pension obligations, insurance increases, maintenance contracts, and vehicle replacement charges. Also salary increases were approved in 2012. Certain positions (21.6 FTE's) continue to be frozen. Cost control measures began in 2009 and are being incorporated in the 2013 budget. A contingency of 2% has been included for a potential salary increase in the 2013 budget. For 2013, the General Fund budget has been formulated on the assumption that revenues in 2013 will be essentially flat compared to current 2012 estimates except for a 2% increase in sales taxes which has been incorporated in the revenue estimates. • Telecommunications Device for the Deaf TDD (479) 51.1315 113 West Mountain - Fayetteville, AR 72701 THE CITY OF FAYETTEVILLE, ARKANSAS 2013 ADOPTED BUDGET EXECUTIVE SUMMARY This budget is formulated with the Enterprise Funds being budgeted on an accrual basis except for depreciation, which is not included in the budget, and both capital expenditures and bond principal payments which are included in the expenditure budgets. Governmental funds are budgeted on the modified accrual basis. The total budget allocated by expenditure category is displayed in the following table. Summary of Fund Expenditures by Category (In Dollars) City of Fayetteville, Arkansas 2013 Operating Budget Summary of Fund Expenditures (In Dollars) Category Personnel Services Materials & Supplies Services & Charges Maintenance Fuel Internal Charges Purchased Water WWTP Operations Total Operating Expenses Transfers Out Debt Service Capital Total Expenses Adopted 2012 $ 42,466,864 $ 4,234,456 16,090,288 4,508,422 3,460,493 4,354,031 6,500,000 7,799,391 89, 413, 945 330,600 20,104,105 11,482,350 Adopted 2013 44,360,149 $ 4,045,956 16,998,320 3,839,885 3,711,194 4,689,118 6,600,000 8,334,574 92,579,196 2,653,000 20, 713, 204 18, 946, 600 Change In Dollars 1,893,285 (188,500) 908,032 (668,537) 250,701 335,087 100,000 535,183 2013 % of Total Budget 32.8% 3.0% 12.6% 2.8% 2.8% 3.5% 4.9% 6.2% 3,165,251 68.6% 2,322,400 609,099 7,464,250 2.0% 15.4% 14.0% $ 121,331,000 $ 134,892,000 $ 13,561,000 100.0% The 2013 Adopted Budget is in excess of $134.8 million. This is an increase when compared to 2012 of $13,561,000 or 11.2%. The majority of that increase is due to changes in capital programs, internal transfers, and personnel services costs. The total operating expenses are up $3,165,251 or 3.5%. IV THE CITY OF FAYETTEVILLE, ARKANSAS The following table indicates the percentage of total budget allocated by funds. Fund Totals as Percent of Total Budget Adopted 2012 Funding Source General Water & Sewer Sales Tax Bond Solid Waste Shop Sales Tax Capital Improvements Street Parks Development Police Pension Wastewater System Improvements Project Fire Pension Parking Impact Fee Airport Town Center Drug Law Enforcement Community Development Block Grant TIF Bond Replacement & Disaster Recovery Sales Tax Construction Bond Budget % of Total $ 34,139,200 30,908,000 16,372,400 9,950,100 8,231,500 6,702,600 4,706,600 2,358,000 1,633,000 97,600 1,470,000 1,101,800 921,000 768,000 695,200 544,000 589,000 100,000 41,000 2,000 Adopted 2013 Budget % of Total 28.2% $ 36,057,000 26.8% 25.5% 34,920,000 25.9% 13.5% 17,871,000 13.2% 8.2% 11,774,000 8.7% 6.8% 8,486,000 6.3% 5.5% 8,253,000 6.1% 3.9% 4,708,000 3.5% 1.9% 3,074,000 2.3% 1.3% 1,629,000 1.2% 0.1% 1,520,000 1.1% 1.2% 1,468,000 1.1% 0.9% 1,162,000 0.9% 0.8% 1,060,000 0.8% 0.6% 955,000 0.7% 0.6% 697,000 0.5% 0.4% 568,000 0.4% 0.5% 541,000 0.4% 0.1% 100,000 0.1% 0.0% 42,000 0.0% 0.0% 7,000 0.0% $ 121,331,000 100.0% $ 134,892,000 100.0% An examination of the overall budget indicated that the General Fund is the largest fund being 26.8% of the total. The Water and Sewer Fund is second at 25.9% of the total. The combination of these funds is 52.7% of the total budget. The Sales Tax Bond Fund (budget to repay outstanding bonds) is 13.2% of the budget. Thus the three largest funds represent 65.9% of the total operating budget. An important part of this budget document is the City's Financial Policies delineated in pages 4 through 8 which are incorporated as a part of the budget. These policies include the following: Revenue Policy Expenditure Policy Debt Policy Reserve Policy Investment & Cash Management Policy Capital Improvement Policy Financial Reporting Policy Administrative Procedures to Adjust the Approved Budget v THE CITY OF FAYETTEVILLE, ARKANSAS Overview of City's Major Funds: General Fund is the major operating fund of the City and is comprised of activities not accounted for specifically in other funds. The traditional functions of government are included in the General Fund which includes the following: general government services (Mayor's Administration, District Court, City Clerk and City Attorney), fire, police, finance, internal services, animal services, telecommunications, parks and recreation, cable, library funding, engineering, planning, and building safety. General Fund Revenue: The General Fund revenue budget was based on the following assumptions: • City Sales Tax is projected to increase at a rate of 2.0% over 2012 estimates. • County Sales Tax is projected to increase at a rate of 2.0% over 2012 estimates. • Franchise Fees are projected to be flat compared to 2012 estimated collections. • Property Taxes are projected to increase at a rate of 1.47% from 2012 collections based on assessed valuation. • Other revenues are expected to be essentially flat compared to the 2012 budget. • Maintaining the revenue split for City Sales Tax to 60% operations and 40% capital. Based on these revenue assumptions, the major revenue sources for the General Fund in 2013 are projected to be as follows: City's Share of County Sales Tax $1 1.6 million City Sales Tax 10.7 million Alcoholic Beverage Taxes 0.5 million Franchise Fees 5.1 million Intergovernmental Income 2.2 million Fines & Forfeitures 1.7 million Charges for Services 1.5 million Property Tax Millage 1.7 million Licenses & Permits 0.9 million Other 0.2 million Total $36.1 million VI THE CITY OF FAYETTEVILLE, ARKANSAS General Fund Expenditures: Payroll expenditures are based on full employment. The significant increases in General Fund for 2013 compared to 2012 are as follows: 2012 General Fund Adopted Expense Budget: Additions: $ 34,139,200 Salary & Wages Increase $ 407,770 Personnel Services Turnover 258,200 Salary Contingency 400,000 LOFPI Police Pension 86,184 LOFPI Fire Pension 71,320 Retirement 79,881 Health Insurance (Rate Increase) 182,457 Police Jail Contract 54,250 Granicus Services (Government Channel) 27,000 Wellness Program 40,000 Sustainable Communities Network 15,000 Motorpool Charges 52,658 Transfer to Outside Entities 120,142 Capital 27,500 Software Maintenance 25,620 Office Machine Maintenance 32,063 Other 37,755 Net Additions $ 1,917,800 2013 General Fund Adopted Budget $ 36,057,000 Major policy issues to be considered for General Fund in the future include: • The need to fund employee wages at a full step level. • Continue to explore an independent funding method for the Fayetteville Public Library. • Examination of the User Fee/Cost Reimbursement rates based on a cost analysis. • Continued examination the City's overall long term revenue stream to match required long term expenditures. VII THE CITY OF FAYETTEVILLE, ARKANSAS The Street Fund is primarily financed by turnback revenues received from the State of Arkansas and turnback monies received from the County Road Millage Tax. These monies are utilized to maintain and repair City streets, rights-of-way, drainage, traffic control and maintenance, and City owned sidewalks. State turnback comes from motor fuel taxes collected by the State (state turnback) and returned to the City on a per capita basis. The long term trend for state turnback is flat. A total of $3.4 million is projected for 2013. The City also receives 80% of the road millage levied by the Quorum Court on real and personal property located within the City. This should generate in excess of $1 million. The Street Fund budget is balanced for 2013 with revenues equaling expenditures. The Parking Fund has been established to account for the revenue and expense associated with the paid parking program. A revenue bond issue for the construction of a parking facility has been approved by the City Council but has not yet been issued. Net revenue from this fund would be pledged for payment of that bond issue. This fund has a budgeted surplus of $318,000 for 2013. The Parks Development Fund accounts for the revenue and expenditures of the Parks HMR tax approved by the voters in 1995 as modified by the 2012 referendum. The $3.1 million in planned expenditures for 2013 includes $1,263,000 in capital improvements. The fund is budgeted to break even for 2013. All projected revenues amounts are budgeted for this fund. The Impact Fee Fund accounts for the revenues and expenditures related to the collection of water, wastewater, police, and fire impact fees. All projected revenues are budgeted for this fund. The collection of these fees will be flat compared to 2012 estimated. The Sales Tax Capital Improvements Fund accounts for the revenue and expenditures of the City's sales and use taxes which are used for acquisition and improvement projects as well as equipment additions and replacements that are included in the City's five-year capital improvements program as adjusted. The 2013 planned expenditures include $8,245,000 in capital improvements. The Water & Sewer Fund accounts for the revenue sources as well as the operation and maintenance expenses of the City's water and sewer system. This includes water purchases from Beaver Water District, all water and sewer functions, the operation of the wastewater treatment plants, meter and backflow operations, and billing and collections. For 2013, the Water & Sewer Fund is projected to have operating gain of $5,909,000 excluding depreciation expense and before capital expenditures. The wastewater treatment plant operations are budgeted at $8.3 million, which represents over 31% of the total operating expenses. The water purchases budgeted for 2013 represent the second largest expenditure for operations in the fund at $6.6 million. This represents approximately 25% of total operating expenditures. This fund is budgeted to break even in 2013. VIII THE CITY OF FAYETTEVILLE, ARKANSAS The Solid Waste Fund is responsible for the operation of the City's solid waste collection and disposal, recycling program, and composting program. Revenues for the fund are obtained from fees levied for trash collection, recycling revenue, and container sales or leases. During the end of 2009, the operation of the transfer station was brought in house and is currently being operated by the City.. For 2013, the Solid Waste Fund is projected to have a loss of $2,277,000 primarily due to needed capital improvements. However, there are sufficient reserves to accommodate this deficit. The Airport Fund provides for the operation and maintenance of the City's municipal airport. The Airport Fund's revenue is generated from rents and leases. For 2013, the Airport Fund is projected to have an operating deficit of $47,000 before depreciation expense and capital expenditures. The total budget deficit I $181,000. The Shop Fund is an internal service fund that provides for the acquisition and maintenance of equipment and vehicles utilized by the City's operating divisions. The Shop Fund's source of revenue is from charges to other City operating funds based on equipment and vehicle usage. The Shop Fund will have a projected $839,000 loss for 2013 after capital expenditures of $3,865,000. This amount will come from fund balance which reflects the previous accumulation of funds for replacement of equipment and vehicles when needed. 2013 Capital Budget This plan contains a total of $23,056,000 for capital projects in 2013. A detail listing of all of the projects planned for 2013 are included under the Capital and Debt section. Debt Issues - 2012 In May of 2012, a refunding issue of $3,670,000 was executed by the City. That issue refunded the outstanding 2002B Water & Sewer Revenue Bonds. IX THE CITY OF FAYETTEVILLE, ARKANSAS Personnel Changes Below is a history of total positions by activity from 2004-2013. City of Fayetteville, Arkansas Personnel History by Activity (2004-2013) Activity 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 General Government 41.65 40.40 40.40 41.40 41.40 41.40 41.50 41.50 41.50 41.50 Finance & Internal Services 62.50 69.75 69.75 70.25 70.25 70.25 70.25 69.75 69.75 69.75 Police 157.63 167.63 170.63 171.63 171.63 171.63 171.63 171.60 171.60 171.60 Fire 101.00 104.00 109.00 113.00 114.00 114.00 114.00 114.00 114.00 114.00 Community Planning/Engineering 64.80 69.80 71.80 73.30 73.30 73.30 70.30 70.30 70.30 70.30 Transportation Services 79.00 91.50 91.50 93.50 93.50 93.50 96.00 95.00 96.00 96.00 Parks & Recreation 49.85 51.85 51.85 53.35 53.35 53.35 54.35 54.35 54.35 54.35 Business -Type 130.60 133.10 131.10 136.10 136.10 139.10 138.50 139.50 139.50 139.50 Total 687.03 728.03 736.03 752.53 753.53 756.53 756.53 756.00 757.00 757.00 Change from Prior Year 27.50 41.00 8.00 16.50 1.00 3.00 - (0.53) 1.00 X THE CITY OF FAYETTEVILLE, ARKANSAS CLOSING The funding contained in this budget is the result of a collaborative effort among all City Division Heads, Department Directors, and City financial Staff members. It is built on the policies, goals, and objectives outlined by the Mayor and City Council. It represents the financial and operational plan for the City of Fayetteville for 2013. The appropriations contained in this budget will provide for quality municipal services that meet the needs of the Citizens of Fayetteville and it is, hereby, submitted by the Mayor to the City Council for consideration and adoption. Respectfully submitted, Respectfully submitted, ti Paul A. Becker Kevin Springer Finance Director Budget Director XI RESOLUTION NO. 234-12 A RESOLUTION ADOPTING THE 2013 ANNUAL BUDGET AND WORK PROGRAM. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF FAYETTEVILLE, ARKANSAS: Section 1. That the City Council of the City of Fayetteville, Arkansas hereby adopts the 2013 Annual Budget and Work Program. A copy of the Budget, marked Exhibit "A" is attached hereto and made a part hereof. PASSED and APPROVED this the 4th day of December, 2012. APPROVED: ATTEST: B Y• By: -1 NELD JO N, Mayor SONDRA E. SMITH, City Clerk/Treasurer CITY OF FAYETTEVILLE, ARKANSAS THE BUDGET PROCESS The budgets of governmental funds (for example General Fund, Street Fund, and Parks Development Fund) are prepared on the modified accrual basis for revenues and expenditures. Under the modified accrual basis of accounting, revenues are recognized when they become both measurable and available. Expenditures are recorded when the related fund liability is incurred. The proprietary and trust fund types (Water & Sewer Fund, Solid Waste Fund, and Airport Fund) are budgeted on a full accrual basis except for depreciation which is excluded and both capital purchases and bond principal payments which are included as expenditures. Not only are expenditures recognized when the liability is incurred but revenues are recognized when they are due and owing to the City (for example, water user fees are recognized as revenue when bills are produced). Agency funds are not budgeted since they are custodial in nature and do not involve measurement of results of operations. The Comprehensive Annual Financial Report (CAFR) shows the status of the City's finances on the basis of "Generally Accepted Accounting Principles" (GAAP). This conforms to the way the City prepares its budget. Formal budgets exist for all funds and fund types, except agency funds and account groups, but the budget -to -actual comparison reports are prepared only for the governmental fund types (General, Special Revenue, and Capital Projects). The Annual Budget and Work Program is a fiscal plan which presents the services which will be provided to the community and the funds needed to perform these services. The type and level of service is defined by the use of program objectives, which are further defined by performance measures. The Mayor is responsible for formulating the fiscal plan and presenting it to the City Council for approval and adoption. The key steps and dates in this process for the 2013 Budget and Work Program are described below: Budget Preparation Package, June 2012 The budget preparation package was distributed to all Department Directors and Division Heads. The package included budget preparation software. In addition, target budgets were set for each fund and/or program. The target budget excluded service expansion requests and new personnel requests. These items are considered separately. Training was conducted on an individual basis with the Budget Staff and Department Directors and Division Heads, as requested. 2. Capital Requests, September - October 2012 Five Year Capital Improvements requests were submitted for review and prioritization. Approval of the requests were based on a review of prioritized lists by Department Directors and Budget staff to see if original cost and continuing costs were within the available funding range. Capital items with a cost that exceeds $10,000 should appear in the Five Year Capital Improvements Programs. 3. Budget Work Papers Submitted by Division Heads, July 2012 The Division Heads returned budget submissions requesting 2012 funding to the budget office. The budget office then verified that budget submissions were correct and within specified targets. 4. Analysis of Each Proposed Program Budget, July - August 2012 During this period, meetings were conducted with each Department Director. At these meetings, the submitted program budgets were evaluated in their entirety and additions and cuts were made to balance the funds with the service requirements. The 2013 Proposed Budget and Work Program was the result of this process. 5. Consideration and Approval of the Budget, Beginning to Adoption 2012 The proposed budget is discussed with the Mayor beginning in September and through November. The Mayor will present the comprehensive Proposed 2013 Budget and Work Program to the City Council on November 8. Public discussions were conducted in November and December. The 2013 Budget was adopted by City Council on December 4, 2012. 6. Implementing the 2013 Budget, January 2013 Work papers are created and distributed to allow each division head to split their budget into the projected funding level needed for each month. These work papers are collected and input into the computer system to assist in the control of the adopted budget throughout 2013. 7. Adjusting the 2013 Budget, Throughout 2013 The budget may be adjusted throughout 2013. Depending on the amount of the adjustment, approval may come from the Budget Director, Finance Director, Mayor or the City Council. A detailed explanation of the Budget Adjustment Policy is listed on pages 7 and 8. The public meetings throughout the budget process are considered to be an essential part of the budget process as they are designed to solicit feedback from the City Council and public on City operations and services. In accord with continuing efforts to apprise the public of City activities, the 2013 Budget and Work Program is made available for review by all interested persons at the Fayetteville Public Library and the City Clerk's Office. In addition, a downloadable version of the budget is found on the City's web site. Public notification of this information is made in a local newspaper and on the Cable Access Television channel. As always, the public is invited to attend all meetings, retreats, and hearings regarding consideration of the Budget. 2 CITY OF FAYETTEVILLE, ARKANSAS THE 2013 BUDGET PROCESS June July August September October November December Divisions develop budget requests Budget & Research develops revenue projections Analysis of budget requests by Budget & Research Meetings with Division Heads W Budget review with Mayor and Department Directors Prepare Proposed Budget Budget & Research revises revenue projections 2013 Proposed Budget Distribution (November 8) Consideration and approval of the budget by City Council CITY OF FAYETTEVILLE, ARKANSAS FINANCIAL POLICIES The purpose of this section is to present the policies that the City follows in managing its financial and budgetary affairs. These are general statements of policies, which represent long-standing principles, traditions, and practices that have guided the City in maintaining financial stability. REVENUE POLICY The City will strive to maintain a broad and diversified revenue base that will equitably distribute the burden of supporting City services and will protect the City from short-term fluctuations in any one revenue source. • The City will actively support economic and industrial development recruitment and retention efforts to provide for a solid revenue base. • The City will maintain timely collection systems and implement necessary enforcement strategies to collect revenues from available sources. The City will establish user fees and charges for services, when feasible, at levels related to the cost of providing the services. The City will review the fees and charges on a periodic basis to determine modifications needed to keep pace with the cost of providing the services. • The City will establish, when feasible, self- supporting enterprise funds and internal service funds in which a relationship between revenues and expenditures clearly exists. • The City will project revenues on a conservative basis so that actual revenues will consistently meet or exceed budgeted revenues. • The City will maintain a budgetary control system and will prepare reports that compare actual revenues to budgeted amounts. • The City will review annually and revise, where necessary, its cost allocation formula. • The City will limit the designation of General Fund revenues for specified purposes to maximize flexibility in budgeting and revenue utilization. EXPENDITURE POLICY • Basic and essential services provided by the City will receive first priority for funding. The City will establish performance measurements for all program areas, when feasible. These measures will reflect the demand, workload capability, and projected outcomes for the program to accomplish its objectives. The City will adopt a balanced budget, by fund, for all funds maintained by the City, in which total anticipated revenues must equal or exceed the budgeted expenditures for each fund. However, if this cannot be attained, the City will utilize unallocated fund reserves, which have been carried forward from prior years. • The City will maintain a budgetary control system to ensure adherence to the adopted budget and will prepare reports that compare actual expenditures to budgeted amounts. The City will refrain from budgeting non- recurring or one-time revenue for ongoing expenses. The City will provide access to medical, dental, life, and long-term disability insurance for its employees. The cost for these benefits will be a shared responsibility between the City and its employees. 4 The City will provide access to appropriate retirement plans for its employees. The City will make contributions for eligible employees at the percentage defined for each of the respective retirement plans. 174•3iZ971![41 • The City will maintain a policy of full disclosure on financial reports and bond prospectus. • The City will maintain communications with bond rating agencies and continue to strive for improvements in the City's bond rating. The City will pay for all capital projects and capital improvements on a pay-as- you-go basis using current revenues whenever possible. If a project or improvement cannot be financed with current revenues, long-term or short-term debt or capital leases will be recommended. • The City will refrain from issuing long-term debt for a period in excess of the expected useful life of the capital project. • The City will use special assessment revenue or other self-supporting bonds instead of general obligation bonds, when feasible. • The City will seek refinancing of outstanding debt if it is determined that the City will benefit by reduced interest expense over the remaining life of the bonds of at least 3% of the principal being refunded. • The City will require that General Fund and Street Fund debt service shall not exceed 10% of annual general and road tax revenu.es and the principle amount of General and Street Fund debt shall not exceed 5% of assessed taxable property. Outstanding short-term debt and Amendment 78 debt obligations combined shall not exceed 5% of the City's taxable real property. RESERVE POLICY The City will maintain a minimum reserve of sixty (60) days of annual regular general fund operating expenditures for the General Fund in Undesignated Fund Balance. The minimum unreserved General Fund Balance cannot be reduced without specific City Council Resolution. The City will maintain a minimum reserve of at least 10% of current year operating expenditures for the Street Fund in Undesignated Fund Balance. If existing reserves exceed the required level, such funds may be used to provide for non- recurring expenditures. The City will use monies in the 10% reserve only in times of emergency or fiscal and economic hardship. • The City will attempt to maintain a cash and investments balance of not less than 10% of current year operating expenditures for all Enterprise Funds. • The City will maintain a Shop Fund reserve necessary to fund the replacement and expansion of the City's vehicles and equipment. INVESTMENT AND CASH MANAGEMENT POLICY • The City will deposit all receipts on a timely basis. The City will strive to maximize the return on its investment portfolio without jeopardizing principal amounts. • The City will limit its investments to the types of securities provided for by Arkansas statutes. 5 • The City will diversify its investments by maturity date to protect against market fluctuations. • The City will purchase securities from qualified institutions based on competitive bids in an effort to obtain the highest available rates. CAPITAL IMPROVEMENT POLICY The City will prepare and update, as needed, a five-year Capital Improvements Program (CIP), which will provide for the orderly maintenance, replacement, and expansion of capital assets. • The CIP will identify long-range capital projects and capital improvements of all types, which will be coordinated with the annual operating budget to maintain full utilization of available revenue sources. When preparing the CIP, the City will seek to identify all viable capital projects and capital improvements required during the subsequent five-year period. These projects and improvements will be prioritized by year and by funding source. Every attempt will be made to match projects and improvements with available funding sources. Future operating costs associated with a project or an improvement will also be given consideration in the establishment of priorities. • The City will seek Federal, State, and other funding to assist in financing capital projects and capital improvements. • The City will seek input from the public by holding public hearings in relation to the establishment of projects and project priorities. The City will incorporate the reasonable findings and recommendations of the other City Boards, Commissions, Committees, and Citizen task forces, as they relate to capital projects and improvements. rl FINANCIAL REPORTING POLICY The City's accounting system will maintain records in accordance with accounting standards and principles outlined by the Governmental Accounting Standards Board (GASB), Financial Accounting Standards Board (FASB), and the State of Arkansas. The City will employ an independent accounting firm to perform an annual audit of the City's finances and make the annual audit available to all required and interested parties. The audit shall be completed and submitted to the State of Arkansas within 210 days of the close of the fiscal year. • The City will produce monthly and quarterly financial statements reporting the current periods' activity for all funds maintained by the City. • The City will maintain an internal audit function, which will be charged with adopting and routinely monitoring internal controls of the City. The City will prepare an annual budget document that provides a basic understanding of the City's planned financial operations for the coming fiscal year. Copies of the proposed and final budget will be made available to all interested parties and opportunities will be provided for citizen input prior to final decisions on the budget. The City will seek annual renewal of the Government Finance Officers Association's (GFOA) Certificate of Achievement for Excellence in Financial Reporting and the Distinguished Budget Presentation Award. CITY OF FAYETTEVILLE, ARKANSAS ADMINISTRATIVE PROCEDURES TO ADJUST THE APPROVED BUDGET PURPOSE: The procedures outlined in this section define, standardize, and set forth responsibilities for budget adjustments. DEFINITION AND EXPLANATION: During the fiscal year needs arise for expenditure budget adjustments to enable divisions to adapt to changing conditions. There are two types of expenditure budget adjustments which can be defined as follows: 1) Budget Adjustment - this is a transfer from one category within a fund budget to another category. The fund total does not change. 2) Budget Amendment - this is an addition to the overall budget total of the fund. It increases the total expenditure amount authorized for the fund. Any budget amendment must be supported by an increase in revenue or come from available fund balance. DEPARTMENT DIRECTORS AND DIVISION HEADS RESPONSIBILITIES: All Department Directors and Division Heads are mandated to stay within each operational program budget as adopted and to stay within the total budget for each capital project. Neither the Accounting or Purchasing Divisions will process payments or purchase orders, which will cause a program or capital project to be over the annual budget amount. Each operational division is grouped into programs (i.e. Engineering - Administration, Engineering - Plans & Specifications, Engineering - Right -of -Way, etc.). Budget adjustments will be required in the following instances: 1) When the budgeted amount per operational pro. rq am is exceeded (an offsetting adjustment must be made from another operational program or fund balance). 2) When the budgeted amount for a capital project is exceeded (an offsetting adjustment must be made from another capital project, another program, or fund balance). Requested adjustments to an operational program must be submitted on a budget adjustment form with sufficient justification for the need. Any changes in the personnel services category must meet the City's policy for raises, promotions, and staff increases. 7 BUDGET ADJUSTMENT APPROVAL PROCESS: Budget Amendments 1) All budget amendments must be approved by the City Council other than mandatory redemptions and other expenditures delegated to a Bond Trustee via a bond trust agreement. Budget Adjustments 1) Budget adjustments within categories, within divisions of a fund, can be made with the approval of the Budget Director (see page 10 for a division listing). 2) Budget adjustments between categories within a division of a fund can be made with the approval of the Budget Director and Finance Director. 3) Budget adjustments within the personnel services category between departments within a fund will be approved by the Budget Director, the Finance Director, and the Chief of Staff. 4) Budget adjustments between categories within an approved project will be approved by the Budget Director. 5) All other budget adjustments must be approved by the City Council. BUDGET AMENDMENT REPORTING: As a matter of practice, staff will provide information regarding Budget Amendments to the City Council on a quarterly basis. ro CITY OF FAYETTEVILLE, ARKANSAS BUDGET ORGANIZATIONAL STRUCTURE FUND In governmental accounting, a fund is a fiscal and accounting entity with a self -balancing set of accounts, created and maintained for a particular purpose. It has transactions subject to legal or administrative restrictions. A separate budget is provided for each fund. ACTIVITY Activities are the major groups of items which are functionally related, regardless of the Department or Division that is responsible. This type of classification provides a useful Budget summary that is consistent even though changes in the organizational structure may occur. DEPARTMENT Departments are the major organizational sub -divisions. They have a broad overall purpose. The City of Fayetteville is organized into eight operating departments: Police, Fire, Parks & Recreation, Utilities, Development Services, Communications & Marketing, Transportation Services, and Finance & Internal Services. Each Department, except Police and Fire, has a director who reports to the Chief of Staff. DIVISION Divisions are the major operational areas of the City. Each Division has been assigned to one of the Departments listed above according to the type of activity it performs. For example, the Solid Waste & Recycling Division is part of the Transportation Services Department. A listing of divisions is on the following page. PROGRAM Programs are the operating units within the Division. Each program represents a specific type of activity within its Division aimed at providing a service for which the City is responsible. For example, the Solid Waste & Recycling Division contains the following programs: Administration, Commercial Collections, Residential Collections, Commercial Drop Box Collections, Transfer Station, Recycling, and Composting. CATEGORY Within each program, each expenditure item is grouped into a category of related expenditures. The budget for each program is listed by categorical total. Examples of a category include: Personnel Services, Materials and Supplies, Services and Charges, Maintenance, Motor Pool Charges, Capital, Transfers to Outside Agencies, Cost Reimbursements, and Operating Transfers. 9 LISTING OF DEPARTMENTS AND DIVISIONS DEPARTMENT DIVISIONS General Government Mayors Administration City Council City Attorney City Prosecutor City Clerk/Treasurer Fayetteville District Court Library Chief of Staff Chief of Staff Sustainability & Strategic Planning Human Resources Internal Audit Police Department Police Central Dispatch Fire Department Fire Department Parks & Recreation Department Parks & Recreation Finance & Internal Services Department Information Technology Finance Director Accounting & Audit Billing & Collections Building Maintenance Budget & Research Purchasing Development Services Department Development Services Engineering City Planning Community Services Building Safety Animal Services Communications & Marketing Department Communications & Marketing Government Channel Transportation Services Department Transportation Services Aviation Fleet Operations Solid Waste & Recycling Utilities Department Utilities Director Parking & Telecommunications Water & Sewer Maintenance Wastewater Treatment Plant Consolidated Fund -Department -Program Structure Woslewoler System Improvement Prolecl Wastnnrarer Improvements Sales tax Bontl Soles Toe Conshuclion Bond Energy Sock Grant Replacement & Disaster Foe Bond Recovery Sales Tax Copilal improvements Police Pension Fund M. Pension fund 10Bond Special Slate Gronls Street fund CDBG Fund Parking Airport Drug Law Enforcement General Fund Parks Development Tao n Center Fund Water & Sewer Fund Shop Fund Solid Wosle Fund Impact Fee lroniporlolion cervices I Ulililies )peraliens & administration OII Street Parking Fghl-ol-Way Maintenance Entertainment District ,heel Maintenance )stooge Maintenance rattic Contort Maintenance heel & Trail Conslrucllon Development Services sdmin. & Planning Inuring Services edevelapment 'ublic Services 'ublic Facilities & Imp Police iranvporla� Police I Fire bdmieislralion Central Dispatch Prevention Chief of Stall nal Audit Ulililies Utilities Monogemeet Parks & Recreolion Swimming Pool General Govemmenl Moypis Adminislrolion Development Services Development Svs. Dir. an Resources Parks Adm./Reo. Frog. City Count Animal Polroi lays. Deveopment Lake Maintenance City attorney Animal Sheller sin. & Strategic Plan. Parks Maintenance City Prosecutor Velerinonpn/Clinic Yvonne Fichordson Cl, District Judge Building Safety Criminal Cases Code Enforcement Probation & Fines Planning & Dec. Mgml. Small Claims/Civil Cases Eng. Design Services City Clerk Eng. Opel. & Admin. - Library ROW Acquisition Miscellaneous Public Construction _ City Planning Parks & Recreation GO Development vks Development Capitol irks Development Greenspace & Internal SeMce e Director nling & Audit I & Research ng slion technology & Internal Se & Collections Communications & Marketing Communications Director Govemmenl Channel Transportation SeMces Vehicle Maintenance Capital Expenditures & Woslewoler Dir. Operations r Maintenance r.Cep. Expenditure r Purchased Oper. & Admin. sultan Mainl. Be & Pump Moinl. r Mains Mainl. lal Water Mains lal Expenditures Connections Mains Constr. Capital SeMce is Proj. Mgr. team Transportation S.Mces Dperotions & admin. Comrtcetolal Collections 2esidenlial Collections Commercial Drop Box trans fett gtat ion cecycfing Composting ielid Waste Projects (Page Left Blank Intentionally) INa City of Fayetteville, Arkansas Chart of Governmental Fund Types I City Fund Structure I Governmental General Fund N I Special Revenue Funds Parking Community Development Energy Block Grant Parks Development Impact Fee Drug Law Enforcement Special State Grants I Debt Service Funds Fire Bond TIF Bond Wastewater Improvements Sales Tax Bond I Capital Projects Funds icement & Disaster Recovery Tax Capital Improvements swater System Improvements Tax Construction Bond As noted by the chart above, the City utilizes all four (4) major Governmental fund types: General, Special Revenue, Debt Service, and Capital Projects. General Fund - General fund is the general operating fund of the City. It is used to account for all financial resources except those accounted for in other funds. Special Revenue Funds - Special Revenue funds are used to account for the proceeds of specific revenue sources, which are designated or required to finance particular functions or activities of the City. Debt Service Funds - Debt service funds are used to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest and related costs other than debt service payments made by enterprise funds. Capital Projects Funds - Capital projects funds are used to account for financial resources to be used for the acquisition and construction of assets of a relatively permanent nature other than those financed by proprietary funds. As a note of explanation for the following combined statements, the revenues are listed by major source and the expenditures are listed by major department or service. The operation transfers are listed both in and (out). 13 City of Fayetteville, .Arkansas Chart of Proprietary and Fiduciary Fund Types I City Fund Structure Proprietary Funds I Fiduciary Funds Enterprise Funds l I Internal Service Funds I Trust Funds I Agency Funds Water & Sewer LShop {—Police Pension {—Returned Check Solid Waste L Fire Pension L Payroll Airport Town Center As noted by the chart above, the City utilizes the Enterprise and Internal Service funds in the Proprietary fund type and the Trust and Agency funds in the Fiduciary fund type. Enterprise Funds - Enterprise funds are used to account for operations (A) that are financed and operated in a manner similar to private business enterprise, where the intent of the governing body is that the costs of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or (B) where the governing body has decided that periodic determination of revenues earned, expenses incurred and/or net income is appropriate for capital maintenance, public policy, management control, accountability or other purposes. Internal Service Funds - Internal service funds are used to account for the financing of goods or services provided by one division of the City to other divisions of the City, on a cost reimbursement basis. Trust Funds and Agency Funds - Trust funds and agency funds are used to account for assets held by the City in a trustee capacity or as an agent for individuals, private organizations, other governments and/or other funds. Trust funds are accounted for in essentially the same manner as proprietary funds since capital maintenance is critical. Agency funds are custodial in nature and do not involve measurement of results of operation. In reference to the following combined statements, the revenues are listed by major source and the expenses are listed by major department or service. Also shown are depreciation, non -operating revenue and (expenses), transfers in and (out), and net income. 14 City of Fayetteville, Arkansas Sources of Funds for 2013 $134,892,000 Sales Taxes Franchise Taxes Property Taxes $50,306,000 $5,307,200 $2,706,000 37.3% 3.9% Intergovernmental Fund Balance $8,851,500 $6,639,000 6.6% 4.9% Charges For Services " $12,985,880 Transfers In 9 6% $2,653,000 _ Other $1,369,210 1.0% Investments _— $691,110 0.5% Fines & Forfeitures $1,976,800 1.5% Solid Waste $9,269,300 Water Sales 6.9% $15,883,000 11.8% Sewer Service $16,254,000 12.0% Uses of Funds for 2013 $134,892,000 WWTP Operations Personnel Services $8,334,574 $44,360,149 32.8% Purchased Water $6,600,000 4.9% Internal Charges $4,689,1 18 3.5% Fuel $3,711,194 2.8% Transfers Out $2,653,000 2.0% Materials & Supplies $4,045,956 3.0% Services & Charges $16,998,320 12.6% Debt Service $20,713,204 Capital 15.4% $18,946,600 14.0% Maintenance $3,839,885 2.8% Note: The Sources of Funds chart includes revenues from all City funds. The Uses of Funds chart includes expenditures from all funds including capital expenditures in the Proprietary fund types. In compliance with GAAP, Proprietary fund balances do not reflect capital expenditures. 15 City of Fayetteville, Arkansas Multi -Year Comparison Budget Expenditures Adopted Adopted Adopted Adopted Adopted 2009 2010 2011 2012 2013 Major Funding Sources: General $ 35,801,900 $ 34,426,600 $ 33,885,500 $ 34,139,200 $ 36,057,000 Street 5,360,286 4,271,000 4,390,000 4,706,600 4,708,000 Parking 347,300 304,300 1,065,100 1,101,800 1,162,000 Community Development Block Grant 635,930 649,821 695,800 589,000 541,000 Parks Development 2,854,700 2,417,700 2,424,600 2,358,000 3,074,000 Drug Law Enforcement 444,464 462,200 494,000 544,000 568,000 Water & Sewer 29,668,929 31,269,400 30,901,000 30,908,000 34,920,000 Solid Waste 9,239,250 10,098,900 9,208,300 9,950,100 11,774,000 Airport 773,704 805,500 770,800 768,000 955,000 Shop 6,693,557 5,481,200 7,239,900 8,231,500 8,486,000 91,820,020 90,186,621 91,075,000 93,296,200 102,245,000 Other Funding Sources: Impact Fee 1,576,000 2,820,000 1,260,000 921,000 1,060,000 Fire Bond 804,000 802,400 424,800 0 0 TIF Bond 3,500 5,800 63,700 100,000 100,000 Sales Tax Bond 14,235,533 16,001,900 15,373,700 16,372,400 17,871,000 Replacement & Disaster Recovery 60,400 45,000 45,100 41,000 42,000 Sales Tax Capital Improvements 6,952,000 6,738,700 6,390,000 6,702,600 8,253,000 Wastewater System Improvements Project 3,000 0 0 97,600 1,520,000 Sales Tax Construction Bond 3,500 6,000 6,000 2,000 7,000 Town Center 699,935 693,544 702,700 695,200 697,000 Police Pension 1,761,757 1,689,800 1,692,800 1,633,000 1,629,000 Fire Pension 1,542,283 1,477,500 1,480,400 1,470,000 1,468,000 27,641,908 30,280,644 27,439,200 28,034,800 32,647,000 $ 119,461,928 $ 120,467,265 $ 118,514,200 $ 121,331,000 $ 134,892,000 This comparison of adopted budgets is included to show the scope and growth of City operations in a multi -year format. This presentation is traditional but continues to include interfund transfers. Rather than restating all of the budgets, it is recommended that emphasis be placed on the significant entries, which are the individual funds. A more detailed discussion of each individual fund is included in the specific section devoted to that fund. General Fund (1010) General Fund Revenues Total estimated revenue available in 2013 to support the General Fund is approximately $36.1 million. These overall General Fund Revenue projections are based on historical trend data, expected population increases, and current performance of the national, state, and local economies and statistical information. Sources of Funds for 2013 $36,057,000 Sales Tax $22,269,000 61.7% Property Tax fry $1,614,000 ✓, axF t 4.5% d v SyE � ➢�h f '. h, Alcoholic Beverage Tax Licenses & Permits $523,100 $902,200 1.5% a 2.5% Intergovernmental $2,239,000 Investment Earnings & 6.2% Miscellaneous $228,310 0.6% Franchise Fees $5,141,700 Fines & Forfeitures 14.3% $1,691,000 Charges for Services 4.7% $1,448,690 4.0% 17 Property Taxes: Property Tax revenue makes up 4.5% of total General Fund Revenue. The tax rate currently approved is 1.3 mils. 2013 revenue is projected to increase by 1.4% over 2012 estimated collections due to increased assessed value. 2006 marked the first year that Property Taxes were collected for General Fund operations since 1993 at which time the fax rate was at 3.8 mils. The City of Fayetteville has a discretionary limit of 5.0 mils, which is set by law. By law, millage decisions must be made by the end of October of each year by the City Council and filed with the County. Property Taxes $2.00 $1.80 $1.60 $1.40 $1.20 $1.00 $0.80 $0.60 $0.40 $0.20 $0.00 06 07 08 09 10 11 12 Est 13 Bud Year County Sales Tax: The largest source of General Fund revenue (32.0%) is the County Sales Tax. The City receives a prorated share (36.2%) of the 1% County Sales Tax based on population as of the most recent federal census. Sales Tax growth averaged 2.62% per year from 2001 to 2011. Budgeted 2013 revenue is projected to be 2.0% higher compared to current 2012 estimated collections. The 2013 projection is based on past trends in view of the losses incurred due to the 2010 census. County Sales Tax N $14.00 C O $12.00 $10.00 $8.00 $6.00 $4.00 $2.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year City Sales Tax: The second largest source of General Fund revenue is the City Sales Tax at 29.7% of total revenue. The 1% City sales tax revenue grew on average 3.3% annually between 2001 and 2011. However, 2012 revenue is estimated to be higher than 2011 actual by 6.1%. 2013 revenue is projected to be 2% higher compared to estimated 2012. The 1% City Sales Tax revenue is divided between General Fund operations and capital. The current split for 2013, which began with the 2008 budget, is 60% for General Fund and 40% for Sales Tax Capital Improvements Fund. Total City Sales Tax Collected by Fund $20.00 C O $18.00 $16.00 $14.00 $12.00 $10.00 $8.00 $6.00 $4.00 $2.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year Other Revenues: Other Revenues (Licenses & Permits, Intergovernmental, Charges for Services, and Fines & Forfeitures) as a whole make up 17.4% of total General Fund revenue. Licenses & Permits mainly consist of Building Permits which are projected to be less in 2013 compared to estimated 2012 revenue due to a slow down in permitting. Intergovernmental revenues consist of State Turnback and State/Federal grants and are projected to be less in 2013 compared to estimated 2012 revenue. Charges for Services consist primarily of parks and recreation fees, 911 reimbursements, and planning fees of which are expected to remain flat for 2013. Fines & Forfeitures revenues that consist of court fines are expected to be less over estimated 2012 revenue. General Fund - Other Revenue $8.0 0 0 $7.0 $6.0 $5.0 $4.0 $3.0 $2.0 $1.0 $0,0 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year 20 Franchise Fees: Franchise fees as a category makes up 14.3% of total General Fund revenue. The City collects franchise fees from all utility companies in Fayetteville for the use of City Rights -of -Way. All of the franchise fee agreements reflect a percentage of gross utility revenue generated. Although franchise fees are a direct cost of the utilities business, all utilities except AEP and the City of Fayetteville's Solid Waste and Water & Sewer Divisions show the fee as an additional item on the consumer's invoice. Currently, Souce Gas pays 3% of annual sales before taxes on residential and commercial customers and 1% on industrial customers. AT&T and Prairie Grove Telephone pay 4% of all access line billing. AT&T Video and Cox Communications pay 5% of annual gross sales on everything except internet access revenue. The Water & Sewer utility pays 4.25% and the Solid Waste utility pays 3% on annual gross sales. AEP Electric and Ozarks Electric Co -Op pay 3% of gross revenues on domestic customers and 1% on industrial consumers. The 2013 projections are expected to equal 2012 collections. Franchise Fees $6.00 C O $5.00 $4.00 $3.00 $2.00 $1.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year General Fund Expenses Total uses of funds in 2013 for the City's General Fund totals $36,057,000. The charts below show the total General Fund expenditure budget by operating department and expense category. 2013 Uses of Funds by Activity $36,057,000 \_Fayetteville Public Library ....9ii �w17711, qyu li Pf ll9i Ali° i� $1,672,600 Agencies 4.6/ 4.%Outside $1,034,669 2.9% General Government Finance & Internal $3,293,006 Fire Services 9.1% $8,790,855 $5,031,858 24.4% 14.0% 2013 Uses of Funds by Category $36,057,000 Parcnnnal carvirac Operating Transfers $233,000 0.6% Contingency/Savir $50,000 0.1% Cost ReimbursE $2,310,95., -6.3% nse I I L,CJ $40, 600 $2,689,370 0.,6 7.5% Materials & Supplies $1,121,223 3.1% Services & Charges $2,778,352 7.7% tenance )31,830 Personnel Services: Personnel Services represent the largest source (81.7%) of expense for the City's General Fund. Personnel Services include Salaries & Wages, Overtime, Insurance, Pension, and Worker's Compensation expenses. Since 2000, the Personnel Services category has averaged 4.75% per year from 2001 to 2011. An approximate 2.0% contingency amount has been included in this budget for wage increases. Personnel Services ®Benefits ■Salaries/Wages $30.00 C O $25.00 $20.00 $15.00 $10.00 $5.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year r�� r�nSJ9_S 23 Other Expenses: Other expenses represent 16.3% of the General Fund expenditures for 2013. Other expenses represent the Maintenance, Services & Charges, Materials & Supplies, and Motor Pool categories. The Services & Charges Category includes contract services, publications and dues, etc. and represents 7.7% of the total General Fund budget. The Materials & Supplies Category includes copier/printing charges, minor equipment, fuel, and office supplies and represents 3.1 % of the total General Fund budget. The Maintenance Category includes building and grounds maintenance, software maintenance, and various other small maintenance accounts and is 2.8% of the total General Fund budget. The Motorpool Category represents 2.6% of the total General Fund budget. Other Expenses n O 2 $6.0 $5.0 $4.0 $3.0 $2.0 $1.0 $0.0 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year Fc � 24 General Fund - Fund Balance The amount of minimum reserves to be maintained in undesignated fund balance for General Fund is sixty (60) days (or 16.5%) of annual regular general fund operating expenditures. The General Fund designation requirement was approved by the Fayetteville City Council on November 5, 2002 with Resolution 174-2002 and currently amounts to $5,949,405. General Fund Ending Undesignated Fund Balance & % of Expense y $14.0 O 0 $12.0 $10.0 $8.0 $6.0 $4.0 $2.0 100.0% 90.0% 80.0% 70.0% v 60.0% o. U) C c 50.0% v 0_ O 0 C 40.0% Ii) 30.0% 20.0% 10.0% $0.0 ..1._. �. e 0.0% 02 03 04 05 06 07 08 09 10. 11 12 Est 13 Bud Year PIN City of Fayetteville, Arkansas 2013 Operating Budget General Fund (1010) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Property Taxes $ 1,602,851 $ 1,523,000 $ 1,592,000 $ 1,614,000 Sales Tax - County 10,817,208 10,734,000 11,328,000 11,555,000 Sales Tax - City 9,901,966 9,815,000 10,504,000 10,714,000 Alcoholic Beverage Taxes 495,852 489,700 523,100 523,100 Franchise Fees 4,961,644 4,880,100 5,137,500 5,141,700 Licenses & Permits 850,735 728,400 1,150,400 902,200 Intergovernmental 2,680,643 2,676,365 2,510,700 2,239,000 Charges for Services 1,484,072 1,303,410 1,450,200 1,448,690 Fines & Forfeitures 2,045,492 1,649,066 1,759,300 1,691,000 Interest Earnings 47,071 62,300 48,100 40,900 Other 380,570 249,290 189,700 187,410 Transfer from Sales Tax Capital 1,000,000 0 0 0 Transfer from Special Grants 65 0 0 0 Total Revenues 36,268,169 34,1 10,631 36,193,000 36,057,000 Expenses: General Government Activity 3,082,776 3,476,001 3,305,837 3,293,006 - Outside Agencies 974,560 978,169 978,169 1,034,669 - Salary Contingency 0 141,473 0 473,858 - Personnel Services Turnover 0 (258,200) (116,727) 0 - Fayetteville Public Library 1,607,834 1,607,919 1,607,919 1,672,600 - Cost Reimbursements (2,304,002) (2,304,002) (2,304,002) (2,304,002) Finance and Internal Services Activity 4,487,734 4,975,884 4,768,227 5,031,858 Police Activity 12,174,210 13,172,820 12,957,272 12,330,883 Fire Activity 8,819,927 8,936,360 8,936,120 8,790,855 Community Planning & Engineering 3,454,620 3,775,849 3,602,969 3,687,659 Parks and Recreation Activity 1,641,805 1,798,937 1,727,248 1,812,614 Transfer to Shop 3,000 30,968 30,968 0 Transfer to Drug Grant 212,461 233,000 233,000 233,000 Total Expenses 34,154,925 36,565,178 35,727,000 36,057,000 Income / (Loss) $ 2,1 13,244 $ (2,454,547) $ 466,000 $ 0 Total Budget $ 35,727,000 $ 34,154,925 $ 36,565,178 $ 36,057,000 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 10,197,880 $ 12,152,954 $ 12,152,954 $ 12,618,954 Income / (Loss) 2,113,244 (2,454,547) 466,000 0 Designated Fund Balance Change (158,170) 0 0 0 Ending Undesignated Fund Balance $ 12,152,954 $ 9,698,407 $ 12,618,954 $ 12,618,954 26 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted General Government/Miscellaneous Activity: Mayor's Administration Program (0150): Personnel Services $ 199,226 $ 202,614 $ 202,354 $ 201,567 Materials and Supplies 4,310 5,150 3,487 5,150 Services and Charges 37,024 48,390 42,365 48,390 Maintenance 0 100 0 100 240,560 256,254 248,206 255,207 City Council Program (0160): Personnel Services 73,001 72,996 72,996 72,984 Materials and Supplies 321 40 40 525 Services and Charges 4,213 5,340 5,340 6,900 77,535 78,376 78,376 80,409 City Attorney Program (0210): Personnel Services 265,056 267,934 267,465 269,024 Materials and Supplies 1,305 2,900 2,900 3,400 Services and Charges 14,751 19,820 13,079 19,220 281,112 290,654 283,444 291,644 City Prosecutor Program (0310): Personnel Services 522,156 547,496 530,574 542,494 Materials and Supplies 10,907 12,799 12,626 9,804 Services and Charges 8,120 7,970 7,920 10,965 Maintenance 7,168 7,700 7,454 7,700 548,351 575,965 558,574 570,963 District Judge Program (0400): Personnel Services 158,988 159,651 159,279 166,095 Materials and Supplies 1,959 1,525 1,525 1,300 Services and Charges 6,361 9,266 9,266 9,445 Maintenance 11,123 12,160 12,160 11,799 Communications Program (0550): Personnel Services 203,287 207,994 204,614 208,718 Materials and Supplies 8,959 6,587 6,587 2,634 Services and Charges 1,643 1,697 1,650 5,650 Maintenance 0 3,000 3,000 3,000 213,889 219,278 215,851 220,002 27 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Government Channel Program (0600): Personnel Services 165,827 176,513 176,483 177,659 Materials and Supplies 8,427 11,210 10,528 9,300 Services and Charges 10,555 16,911 16,904 43,307 Maintenance 538 2,700 2,632 2,650 185,347 207,334 206,547 232,916 Chief of Staff Program (0700): Personnel Services 62,027 66,534 66,476 68,025 Materials and Supplies 1,171 2,228 1,029 1,900 Services and Charges 7,475 10,012 9,693 10,340 70,673 78,774 77,198 80,265 Internal Consulting Program (0750): Personnel Services 45,288 86,088 15,669 0 Materials and Supplies 88 300 8 0 Services and Charges 1,992 2,405 70 0 Maintenance 0 3,650 0 0 47,368 92,443 15,747 0 Internal Audit Program (1360): Personnel Services 86,027 90,020 79,698 90,937 Materials and Supplies 195 600 392 600 Services and Charges 3,309 2,936 1,711 2,936 89,531 93,556 81,801 94,473 City Clerk/Treasurer Program (1510): Personnel Services 258,479 287,387 267,912 300,841 Materials and Supplies 6,492 12,500 6,773 13,400 Services and Charges 39,097 65,625 62,033 34,600 Maintenance 10,696 13,100 13,100 13,225 314,764 378,612 349,818 362,066 28 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Criminal Cases Program (2010): Personnel Services 306,745 308,404 306,057 309,818 Materials and Supplies 6,141 7,588 6,856 7,588 Services and Charges 1,042 1,375 1,357 1,375 313,928 317,367 314,270 318,781 Probation & Fine Collection Program (2020): Personnel Services 20,984 19,894 19,286 20,126 Materials and Supplies 277 285 285 285 Services and Charges 710 1,080 680 1,080 21,971 21,259 20,251 21,491 Small Claims & Civil Cases Program (2030): Personnel Services 151,774 173,008 167,454 217,459 Materials and Supplies 1,495 3,600 3,600 3,600 Services and Charges 503 1,650 1,650 1,650 Maintenance 0 103 103 103 153,772 178,361 172,807 222,812 Library Program (5240): Services and Charges 16,775 16,860 16,860 17,899 Transfers To Outside Entities 1,591,059 1,591,059 1,591,059 1,654,701 1,607,834 1,607,919 1,607,919 1,672,600 Miscellaneous Program (6600): Personnel Services 0 (116,727) (116,727) 473,858 Materials and Supplies 1,381 13,700 13,700 23,144 Services and Charges 233,766 459,489 459,417 273,894 Cost allocation (2,304,002) (2,304,002) (2,304,002) (2,304,002) Maintenance 5,716 14,500 14,500 15,700 Transfers To Outside Entities 974,560 978,169 978,169 1,034,669 Capital 102,236 17,477 13,100 40,600 Miscellaneous 2,445 0 0 0 Operating Transfers 3,000 30,968 30,968 0 (980,898) (906,426) (910,875) (442,137) Total General Government/Miscellaneous Activity: $ 3,364,168 $ 3,672,328 $ 3,502,164 $ 4,170,131 29 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Finance & Internal Services Activity: Finance Director Program (1100): Personnel Services $ 139,373 $ 146,599 $ 146,599 $ 148,246 Materials and Supplies 134 180 180 250 Services and Charges 3,166 3,212 3,212 3,642 142,673 149,991 149,991 152,138 Human Resource Operations Program (1210): Personnel Services 394,497 374,502 365,071 348,109 Materials and Supplies 3,688 4,950 3,955 4,950 Services and Charges 3,026 6,670 2,923 6,670 Maintenance 0 150 0 150 401,211 386,272 371,949 359,879 Employee Benefits/Services Program (1220): Personnel Services 452,187 414,060 413,796 513,700 Materials and Supplies 3,508 50 0 50 Services and Charges 118,420 213,134 175,482 170,837 Maintenance 16,862 25,804 24,634 44,007 Contingency/Savings 0 122,517 122,517 0 590,977 775,565 736,429 728,594 Accounting & Audit Program (1310): Personnel Services 669,120 682,185 676,407 683,813 Materials and Supplies 7,554 10,000 7,972 10,000 Services and Charges 20,365 21,360 20,663 22,860 Maintenance 675 1,000 1,000 1,000 697,714 714,545 706,042 717,673 Budget & Research Program (1330): Personnel Services 249,725 256,924 256,532 258,336 Materials and Supplies 4,474 3,506 3,506 5,706 Services and Charges 1,690 4,740 4,740 2,540 Maintenance 3,105 1,800 1,800 1,800 258,994 266,970 266,578 268,382 Utilities Management Program (1380): Personnel Services 148,630 136,713 136,378 150,819 Materials and Supplies 5,515 15,008 14,474 15,105 Services and Charges 235,969 265,902 228,165 255,805 Motorpool Charges 3,325 3,359 3,359 3,301 Maintenance 12 75 75 75 393,451 421,057 382,451 425,105 30 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted General Maintenance Program (1410): Personnel Services 312,154 399,201 339,989 409,351 Materials and Supplies 8,506 8,953 8,431 8,953 Services and Charges 14,782 17,301 15,947 17,301 Motorpool Charges 13,279 13,044 13,042 11,647 Maintenance 19,325 25,326 15,751 25,326 368,046 463,825 393,160 472,578 Janitorial Program (1420): Personnel Services 174,046 180,378 172,919 196,135 Materials and Supplies 11,365 10,549 10,549 10,549 Services and Charges 10,285 12,639 12,215 12,955 Maintenance 0 400 47 400 195,696 203,966 195,730 220,039 Purchasing Program (1610): Personnel Services 219,169 230,238 229,277 232,168 Materials and Supplies 1,198 285 285 580 Services and Charges 19,112 20,523 20,523 20,228 239,479 251,046 250,085 252,976 Information Technology Program (1710): Personnel Services 816,543 880,902 855,350 940,012 Materials and Supplies 20,447 16,058 15,751 16,403 Services and Charges 32,547 47,332 47,332 44,591 Motorpool Charges 2,222 2,277 2,277 3,905 Maintenance 327,734 396,078 395,102 429,583 1,199,493 1,342,647 1,315,812 1,434,494 Total Finance & Internal Services Activity: $ 4,094,283 $ 4,554,827 $ 4,385,776 $ 4,606,753 31 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Police Activity: Central Dispatch Program (2600): Personnel Services $ 1,159,042 $ 1,168,710 $ 1,138,832 $ 1,186,595 Materials and Supplies 9,235 11,153 11,153 8,940 Services and Charges 41,575 45,586 45,249 53,923 Motorpool Charges 5,003 10,636 9,635 8,515 Maintenance 69,864 3,761 3,761 30,434 1,284,719 1,239,846 1,208,630 1,288,407 Police Support Services Program (2900): Personnel Services 2,091,464 2,143,997 2,131,625 2,153,145 Materials and Supplies 72,590 77,536 73,742 75,126 Services and Charges 422,677 439,069 437,702 496,551 Motorpool Charges 31,182 39,933 39,932 35,619 Maintenance 161,286 169,815 165,815 183,330 Operating Transfers 212,461 233,000 233,000 233,000 2,991,660 3,103,350 3,081,816 3,176,771 Police Projects Program (2920): Personnel Services 169,462 252,488 252,488 0 Materials and Supplies 96,723 59,713 59,713 0 Services and Charges 51,715 162,768 162,768 0 Motorpool Charges 0 227,512 227,512 0 Maintenance 3,798 11,980 11,980 0 Transfers To Outside Entities 88,921 105,654 105,654 0 Capital 77,906 215,878 215,878 0 488,525 1,035,993 1,035,993 0 Police Patrol Program (2940): Personnel Services 6,583,176 6,971,189 6,853,167 7,029,987 Materials and Supplies 312,967 327,224 315,953 338,057 Services and Charges 189,965 184,276 184,276 189,158 Motorpool Charges 499,750 525,892 492,387 521,752 Maintenance 35,909 18,050 18,050 19,751 7,621,767 8,026,631 7,863,833 8,098,705 Total Police Activity: $ 12,386,671 $ 13,405,820 $ 13,190,272 $ 12,563,883 32 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Fire Activity: Fire Prevention Program (3010): Personnel Services $ 386,077 $ 335,819 $ 335,819 $ 314,417 Materials and Supplies 22,302 24,855 24,631 28,355 Services and Charges 5,682 7,738 7,738 9,175 Motorpool Charges 19,430 31,071 31,071 35,084 433,491 399,483 399,259 387,031 Fire Operations Program (3020): Personnel Services 7,447,327 7,373,319 7,373,319 7,387,968 Materials and Supplies 188,097 183,398 183,382 137,729 Services and Charges 344,815 380,085 380,085 360,272 Motorpool Charges 98,283 100,293 100,293 145,869 Maintenance 116,943 114,093 114,093 100,423 Capital 0 33,649 33,649 0 Contingency/Savings 0 133,744 133,744 50,000 8,195,465 8,318,581 8,318,565 8,182,261 Fire Training Program (3030): Personnel Services 174,234 172,441 172,441 170,731 Materials and Supplies 7,970 8,739 8,739 10,134 Services and Charges 4,035 22,775 22,775 22,775 Motorpool Charges 4,732 14,341 14,341 17,923 190,971 218,296 218,296 221,563 Total Fire Activity: $ 8,819,927 $ 8,936,360 $ 8,936,120 $ 8,790,855 33 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted Community Planning & Engineering Activity: Animal Patrol/Emergency Response Program (2710): Personnel Services $ 268,401 $ 273,518 $ 271,292 $ 276,534 Materials and Supplies 18,247 18,025 18,025 18,030 Services and Charges 11,085 12,172 11,892 11,242 Motorpool Charges 26,270 25,953 25,953 26,641 Maintenance 551 980 841 1,312 324,554 330,648 328,003 333,759 Animal Shelter Program (2720): Personnel Services 246,541 260,058 257,992 260,016 Materials and Supplies 27,747 27,848 27,848 27,112 Services and Charges 49,198 46,364 46,244 47,131 Maintenance 9,602 11,156 10,700 11,156 333,088 345,426 342,784 345,415 Veterinarian/Clinic Program (2730): Personnel Services 129,004 132,350 132,346 137,635 Materials and Supplies 63,834 66,682 66,150 65,837 Services and Charges 2,414 2,531 1,791 3,276 Maintenance 84 450 450 450 195,336 202,013 200,737 207,198 Animal Services Projects Program (2740): Materials and Supplies 46,521 43,434 43,434 0 Services and Charges 1,889 6,141 6,141 0 Maintenance 22,597 68,225 68,225 0 71,007 117,800 117,800 0 Development Services Director Program (6200) Personnel Services 138,016 162,147 157,520 164,470 Materials and Supplies 534 500 500 550 Services and Charges 854 1,102 957 1,052 139,404 1 63, 749 158,977 1 66,072 34 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted Engineering Design Services Program (6210): Personnel Services 146,095 Materials and Supplies 7,034 Services and Charges 2,252 Moforpool Charges 4,619 Maintenance 3,385 163,385 Engineering Operations & Administration Program (6220): Personnel Services 468,001 Materials and Supplies 4,437 Services and Charges 15,974 Motorpool Charges 3,599 Maintenance 0 492,011 Engineering Land Acquisition Program (6230): Personnel Services 100,367 Materials and Supplies 568 Services and Charges 180 101,115 Engineering Public Construction Program (6240): Personnel Services 275,797 Materials and Supplies 11,009 Services and Charges 1,296 Moforpool Charges 15,753 303,855 165,612 165,612 179,597 8,740 8,223 9,022 2,350 2,190 2,350 4,709 4,709 4,692 362 362 80 181,773 181,096 195,741 503,046 503,046 510,991 6,818 6,154 6,823 18,690 14,420 19,415 3,067 3,067 3,424 950 950 150 532,571 527,637 540,803 104,901 104,237 106,636 1,200 904 970 830 630 830 106,931 105,771 108,436 303,848 281,771 291,404 13,064 11,188 13,464 2,925 2,693 2,825 16,079 16,078 18,201 335,916 311,730 325,894 City Planning Program (6300): Personnel Services 303,351 330,228 Materials and Supplies 18,216 17,723 Services and Charges 15,529 26,980 Motorpool Charges 5,923 5,567 Maintenance 0 350 343,019 380,848 304,703 344,272 15,078 17,165 12,988 23,451 5,566 5,911 338,410 391,149 35 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted Sustainability & Strategic Planning Program (6310): Personnel Services 191,966 190,248 159,848 199,897 Materials and Supplies 2,067 2,050 1,341 2,050 Services and Charges 3,718 11,1 12 10,310 7,040 Maintenance 3,698 0 0 0 201,449 203,410 171,499 208,987 Building Safety Program (6400): Personnel Services 423,781 433,599 414,764 437,217 Materials and Supplies 11,568 18,361 12,682 18,481 Services and Charges 16,585 18,717 16,483 18,397 Motorpool Charges 21,156 21,053 21,047 20,269 Maintenance 7,426 7,800 7,800 8,000 480,516 499,530 472,776 502,364 Code Compliance Program (6420): Personnel Services 260,948 313,666 284,181 304,789 Materials and Supplies 8,304 10,152 10,152 10,774 Services and Charges 19,922 34,446 34,446 29,675 Motorpool Charges 16,707 16,970 16,970 16,603 305,881 375,234 345,749 361,841 Total Community Planning & Engineering Activity: $ 3,454,620 $ 3,775,849 $ 3,602,969 $ 3,687,659 36 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) General Fund (1010) Actual Budgeted Estimated Budgeted Parks & Recreation Activity: Swimming Pool Program (5210): Personnel Services $ 71,963 $ 94,617 $ 78,612 $ 92,994 Materials and Supplies 14,408 13,626 13,626 17,245 Services and Charges 41,536 34,924 34,569 31,282 Motorpool Charges 1,258 1,159 1,157 967 Maintenance 4,215 6,073 5,973 4,584 133,380 150,399 133,937 147,072 Parks Administration/Recreation Programs Program (5220): Personnel Services 432,944 492,818 452,266 470,782 Materials and Supplies 75,024 81,762 80,268 85,766 Services and Charges 123,975 131,106 131,106 137,565 Motorpool Charges 5,803 5,826 5,825 5,747 Maintenance 19 0 0 0 637,765 711,512 669,465 699,860 Lake Maintenance Program (5250): Personnel Services 7,017 7,243 7,043 6,777 Materials and Supplies 2,447 2,623 2,623 1,911 Services and Charges 64,464 65,315 63,847 65,538 Motorpool Charges 465 439 437 342 Maintenance 1,585 288 288 1,200 75,978 75,908 74,238 75,768 Parks Maintenance Program (5260): Personnel Services 283,793 291,988 290,758 328,440 Materials and Supplies 65,990 68,153 67,568 69,548 Services and Charges 156,613 159,051 159,051 173,574 Motorpool Charges 56,404 63,010 63,010 63,857 Cost allocation (6,887) (6,988) (6,988) (6,988) Maintenance 106,465 127,052 127,052 110,047 662,378 702,266 700,451 738,478 Yvonne Richardson Community Center Program (5280): Personnel Services 100,364 105,759 98,037 1 16,026 Materials and Supplies 5,084 3,467 3,467 2,958 Services and Charges 22,759 42,598 40,625 26,775 Motorpool Charges 2,782 2,378 2,378 1,732 Maintenance 1,315 4,650 4,650 3,945 132,304 158,852 149,157 151,436 Total Parks & Recreation Activity: $ 1,641,805 $ 1,798,937 $ 1,727,248 $ 1,812,614 Total Fund $ 34,154,925 $ 36,565,178 $ 35,727,000 $ 36,057,000 37 (Page Left Blank Intentionally) Street Fund (2100) The Street Fund is primarily financed by turnback revenues received from the State of Arkansas and turnback monies received from the County Road Millage Tax. These monies are utilized to maintain and repair City streets, rights -of -way, drainage, traffic control and maintenance, and City owned sidewalks. Street Fund Revenues Revenues for Street Fund are primarily motor fuel taxes collected by the State of Arkansas (state turnback) and returned to the City on a per capita basis. The long term trend for state turnback is relatively flat. The per capita rate for Street Fund in 1995 was $41.00 and in 2012 the per capita rate is $44.85. Projections for 2013 are based on the per capita rate of $44.85 from the State and calculated based on the 2010 census population of 73,580. As the City continues to grow, additional revenue sources will need to be identified to fund Street Fund activities. The City receives 80% of the road millage levied by the Quorum Court on real and personal property located within the City. The current 2012 county levy is 1.1 mil, with a maximum of 3.0 mil. Sources of Funds for 2013 $ 4,708,000 State Turnback $3,420,000 77 ri% of $44 1.1 Investment Earni $15,100 0.3% Charges $125,000 2.7% 39 County Road Turnback $1,103,000 23.4% Street Fund Revenue History $5.00 $4.50 $4.00 $3.50 $3.00 $2.50 $2.00 $1.50 $1.00 $0.50 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year Street Fund Expenses The primary purpose of funds expended from the Street Fund relate to the maintenance, repair and construction of streets within the City of Fayetteville. Associated drainage maintenance activities as well as street sweeping are also programs supported by the Street Fund. Street Maintem $1,376,371 29.2% Right -of -Way Maintenance $303,796 6.5% Uses of Funds for 2013 $ 4,708,000 Administration $1,501,066 31.9% 40 Drainage Maintenance Traffic Engineering & Planning $601,935 12.8% alk Maintenance $340,407 7.2% City of Fayetteville, Arkansas 2013 Operating Budget Street Fund (2100) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Intergovernmental (Grants) $ 108,686 $ 278,814 $ 278,800 $ 0 State Turnback 3,456,606 3,495,000 3,420,000 3,420,000 County Road Turnback 1,080,040 1,065,000 1,102,700 1,103,000 Charges for Services 138,525 107,000 124,900 125,000 Investment Earnings 10,128 18,000 15,000 15,100 Other 40,015 21,600 44,700 44,900 Transfer from Replacement 11,056 79,915 79,900 0 Total Revenues 4,845,056 5,065,329 5,066,000 4,708,000 Expenses: Operations & Administration 1,752,864 1,724,704 1,707,044 1,501,066 Right -of -Way Maintenance 261,386 291,853 279,709 303,796 Street Maintenance 1,276,724 1,454,340 1,418,753 1,376,371 Drainage Maintenance 531,113 548,470 527,589 584,425 Traffic Engineering & Planning 515,245 580,315 577,012 601,935 Street & Trail Construction 36,312 0 0 0 Sidewalk Maintenance 475,985 589,897 589,893 340,407 Total Expenses 4,849,629 5,189,579 5,100,000 4,708,000 Income / (Loss) $ (4,573) $ (124,250) $ (34,000) $ 0 Total Budget $ 4,849,629 $ 5,100,000 $ 5,189,579 $ 4,708,000 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 2,344,517 $ 2,339,944 $ 2,339,944 $ 2,305,944 Income / (Loss) (4,573) (124,250) (34,000) 0 Ending Undesignated Fund Balance $ 2,339,944 $ 2,215,694 $ 2,305,944 $ 2,305,944 41 . City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Street Fund (2100) Actual Budgeted Estimated Budgeted Transportation Services Activity: Operations & Administration Program (4100): Personnel Services $ 572,842 $ 682,541 $ 665,170 $ 608,357 Materials and Supplies 29,370 39,416 39,416 38,563 Services and Charges 698,942 748,513 748,224 738,215 Motorpool Charges 3,360 4,264 4,264 4,898 Cost allocation 39,835 39,835 39,835 39,835 Maintenance 36,367 64,005 64,005 71,198 Capital 372,148 146,130 146,130 0 1,752,864 1,724,704 1,707,044 1,501,066 Right -of -Way Maintenance Program (4110): Personnel Services 164,307 192,735 180,591 199,328 Materials and Supplies 24,128 24,798 24,798 30,108 Services and Charges 40 0 0 0 Motorpool Charges 72,695 72,152 72,152 72,460 Maintenance 216 2,168 2,168 1,900 261,386 291,853 279,709 303,796 Street Maintenance Program (4120): Personnel Services 791,363 845,896 820,139 769,432 Materials and Supplies 267,192 415,079 405,249 356,123 Services and Charges 8,693 4,877 4,877 5,500 Motorpool Charges 760,879 859,291 859,291 887,633 Cost allocation (571,563) (680,974) (680,974) (656,281) Maintenance 11,930 9,596 9,596 13,964 Capital 8,230 575 575 0 1,276,724 1,454,340 1,418,753 1,376,371 Drainage Maintenance Program (4130): Personnel Services 355,470 353,447 332,566 354,828 Materials and Supplies 55,290 84,060 84,060 82,422 Services and Charges 9,484 14,250 14,250 6,750 Motorpool Charges 109,949 92,839 92,839 138,551 Maintenance 920 3,874 3,874 1,874 531,1 13 548,470 527,589 584,425 42 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Street Fund (2100) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Traffic Engineering & Planning Program (5315): Personnel Services 373,527 369,074 369,074 Materials and Supplies 62,962 1 1 1,291 107,988 Services and Charges 3,208 5,823 5,823 Motorpool Charges 49,844 48,527 48,527 Maintenance 25,704 45,600 45,600 515,245 580,315 577,012 Street & Trail Construction Program (5520): Personnel Services Materials and Supplies Motorpool Charges Cost allocation Maintenance Sidewalks Program (5530): Personnel Services Materials and Supplies Services and Charges Motorpool Charges Cost allocation Maintenance (1,005) 49,268 176,815 (226,083) 213,094 134,282 71,696 71,265 (17.7861 0 64,067 168,716 (232,783) 0 0 250,836 91,017 179,841 83,425 (17.7221 0 64,067 168,716 (232.7831 0 250,836 91,017 179,841 83,421 (17, 7221 367,216 116,27] 7,323 53,525 0 41,059 163,089 (204,148) 0 0 222,820 37,910 4,000 90,364 (16,687) 475,985 589,897 589,893 340,407 Total Transportation Services Activity: $ 4,849,629 $ 5,189,579 $ 5,100,000 $ 4,708,000 Total Fund $ 4,849,629 $ 5,189,579 $ 5,100,000 $ 4,708,000 43 (Page Left Blank Intentionally) 44 Parking Fund (2130) The Parking Fund accounts for funds received from meter revenues and parking lot rentals. These monies are expended for maintenance of parking lots. In 2010, a new program, Entertainment District Parking, was created that extended paid parking in the Dickson Street area. For 2013, this fund is expected to have a $318,000 surplus which will be designated toward the future building of a parking deck. In 2010, the City Council approved a $700,000 interfund loan from the Replacement and Disaster Recovery Fund to the Parking Fund for the purchase of equipment. This loan will be paid back from parking revenue within a five year period. At year end the remaining liability will be $382,026. 45 City of Fayetteville, Arkansas 2013 Operating Budget Parking Fund (2130) Actual Budgeted 2011 2012 Revenues: Estimated Budgeted 2012 2013 Downtown District Parking Revenue $ 455,871 $ 495,480 $ 504,820 $ 486,390 Entertainment District Parking Revenue 923,457 879,798 1,025,040 987,800 Investment Earnings 3,360 3,972 4,830 4,810 Other 410 250 2,510 1,000 Total Revenues 1,383,098 1,379,500 1,537,200 1,480,000 Expenses: Downtown District Parking 419,265 453,175 447,457 457,257 Entertainment District Parking 213,267 186,716 182,408 180,287 Entertainment District Parking Facility 0 255,900 255,900 0 Transfer to Walton Arts Center 289,000 289,000 289,000 295,222 Principal Payment 135,360 138,093 138,093 140,880 Interest Expense 11,873 9,142 9,142 6,354 Parking Lot Improvements 56,601 38,000 38,000 82,000 Total Expenses 1,125,366 1,370,026 1,360,000 1,162,000 Income / (Loss) $ 257,732 $ 9,474 $ 177,200 $ 318,000 Total Budget $ 1,125,366 $ 1,360,000 $ 1,370,026 $ 1,162,000 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ (337,768) $ 55,324 $ 55,324 $ 370,617 Income / (Loss) 257,732 9,474 177,200 318,000 Reduction of Interfund Loan Libility 135,360 138,093 138,093 140,880 Ending Undesignated Fund Balance $ 55,324 $ 202,891 $ 370,617 $ 829,497 *The negative Fund Balance is due to the interfund loan from the Replacement and Disaster Recovery Fund. 46 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Parking Fund (2130) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Transportation Services Activity: Off -Street Parking Program (9130): Personnel Services $ 188,361 $ 238,709 $ 238,709 $ 235,727 Materials and Supplies 48,216 52,170 46,459 46,205 Services and Charges 95,439 75,829 75,829 76,570 Motorpool Charges 1,899 1,832 1,825 1,805 Maintenance 33,519 42,050 42,050 55,950 Transfers To Outside Entities 35,242 41,000 41,000 41,000 Capital 44,453 29,585 29,585 30,000 447,129 481,175 475,457 487,257 Entertainment District Parking Program (9131): Personnel Services 99,930 79,037 79,037 79,137 Materials and Supplies 19,934 9,866 7,171 12,023 Services and Charges 57,781 64,552 63,613 57,732 Motorpool Charges 5,551 5,991 5,991 6,103 Maintenance 30,071 27,270 26,596 25,292 Debt Service 147,233 147,235 147,235 147,234 Transfers To Outside Entities 289,000 289,000 289,000 295,222 Capital 28,737 10,000 10,000 52,000 678,237 632,951 628,643 674,743 Entertainment District Parking Facility Program (9132): Services and Charges 0 255,900 255,900 0 0 255,900 255,900 0 Total Transportation Services Activity: $ 1,125,366 $ 1,360,000 $ 1,370,026 $ 1,162,000 Total Fund $ 1,125,366 $ 1,370,026 $ 1,360,000 $ 1,162,000 47 (Page Left Blank Intentionally) Community Development Block Grant Fund (2180) The Community Development Block Grant Fund accounts for the community development grant funds received from the Federal Department of Housing and Urban Development. 49 City of Fayetteville, Arkansas 2013 Operating Budget Community Development Block Grant Fund (2180) Actual Budgeted Estimated Budgeted )nl1 ')n1') ')n17 7n1'2 Revenues: Other CDBG Program Income Total Revenues Expenses: 448,964 $ 1,291,377 $ 1,291,400 $ 541,000 7,025 8,983 8,911 0 455,989 1,398,211 1,398,211 541,000 Administration & Planning 104,385 110,160 110,160 107,602 Housing Services 190,089 830,717 830,717 258,151 Redevelopment 18,025 187,791 187,791 41,247 Public Service 70,775 84,020 84,020 54,000 Public Facilities & Improvements 67,764 190,474 190,474 80,000 Total Expenses 451,038 1,403,162 1,403,162 541,000 Income / (Loss) $ 4,951 $ (4,951) $ (4,951) $ 0 Total Budget $ 451,038 $ 1,403,162 $ 541,000 1,403,162 $ FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 0 $ 4,951 $ 4,951 $ 0 Income / (Loss) 4,951 (4,951) (4,951) 0 Ending Undesignated Fund Balance $ 4,951 $ 0 $ 0 $ 0 50 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Community Development Block Grant Fund (2180) Actual Budgeted Estimated Budgeted Community Planning & Engineering Activity: Administration & Planning Program (4930): Personnel Services $ 91,619 $ 92,954 $ 92,954 $ 95,796 Materials and Supplies 975 1,541 1,541 3,491 Services and Charges 11,791 15,665 15,665 8,315 104,385 110,160 110,160 107,602 Housing Services Program (4940): Personnel Services 65,030 96,729 96,729 68,696 Materials and Supplies 2,249 45,967 45,967 3,428 Services and Charges 119,350 684,655 684,655 182,300 Motorpool Charges 3,460 3,366 3,366 3,727 190,089 830,717 830,717 258,151 Redevelopment Program (4945): Personnel Services 6,767 114,046 114,046 39,427 Materials and Supplies 3,314 21,040 21,040 1,820 Services and Charges 7,944 52,705 52,705 0 18,025 187,79] 187,791 41,247 Public Services Program (4970): Services and Charges 70,775 84,020 84,020 54,000 70,775 84,020 84,020 54,000 Public Facilities & Improvements Program (4990): Services and Charges 67,764 190,474 190,474 80,000 67,764 190,474 190,474 80,000 Total Community Planning & Engineering Activity: $ 451,038 $ 1,403,162 $ 1,403,162 $ 541,000 Total Fund $ 451,038 $ 1,403,162 $ 1,403,162 $ 541,000 51 (Page Left Blank Intentionally) 52 Special State Grants Fund (2230) The Special State Grants Fund accounts for the Arkansas Economic Development Commission Special State grant to purchase training equipment for NWACC. New grants which represent new grant programs funded by the State will be budgeted and accounted for in this fund. 53 City of Fayetteville, Arkansas 2013 Operating Budget Special State Grants Fund (2230) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Intergovernmental (Grants) $ 52,668 $ 0 $ 0 $ 0 Total Revenues 52,668 0 0 0 Expenses: NWACC Equipment Grant 55,399 0 0 0 Total Expenses 55,399 0 0 0 Income / (Loss) $ (2,731) $ 0 $ 0 $ 0 Total Budget $ 55,399 $ 0 $ 0 $ 0 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 2,731 $ 0 $ 0 $ 0 Income / (Loss) (2,731) 0 0 0 Ending Undesignated Fund Balance $ 0 $ 0 $ 0 $ 0 54 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Special State Grants Fund (2230) Actual Budgeted Estimated Budgeted Citywide Activity: NWACC Equipment Grant Program (8001): Services and Charges $ 52 $ 0 $ 0 $ 0 Capital 55,282 0 0 0 Operating Transfers 65 0 0 0 55,399 0 0 0 Total Citywide Activity: $ 55,399 $ 0 $ 0 $ 0 Total Fund $ 55,399 $ 0 $ 0 $ 0 55 Paae Left Blank Intentiona 56 Energy Block Grant Fund (2240) The Energy Block Grant Fund was received from the United States Department of Energy as part of the American Recovery and Reinvestment Act. These funds were used to 1) Develop a green house gas (GHG) credit inventory for community and municipal operations; 2) This is to help reduce municipal GHG emissions 20% below 2006 levels by 2012; and 3) This is to help reduce community GHG emissions 7% below 1990 levels. To achieve the above goals, funds were invested in 1) Upgrading five city -owned buildings for energy efficiency. As the energy savings is realized it will be reinvested in other municipal buildings. 2) The City will develop a Community Revolving Loan Fund targeting non-profit organizations to reduce GHG. These loans will be repaid using energy savings. 3) The City will retrofit approximately 230 street, pedestrian and trail lights with LEDs. 4) A solar photovoltaic system will be installed at the new Fayetteville District Court Building to provide visible examples of renewable energy. 57 City of Fayetteville, Arkansas 2013 Operating Budget Energy Block Grant Fund (2240) Actual Budgeted Estimated Budgeted Revenues: Intergovernmental (Grants) $ 28,130 $ 13,569 $ 13,600 $ 0 Energy Block Grant Funding 391,328 69,386 69,400 0 Investment Earnings 0 0 1,500 0 Other 0 0 15,300 0 Total Revenues 419,458 82,955 99,800 0 Expenses: Energy Block Grant 405,889 82,955 82,955 0 Total Expenses 405,889 82,955 82,955 0 Income / (Loss) $ 13,569 $ 0 $ 16,845 $ 0 Total Budget $ 405,889 $ 82,955 $ 82,955 $ 0 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 0 $ 13,569 $ 13,569 $ 30,414 Income / (Loss) 13,569 0 16,845 0 Ending Undesignated Fund Balance $ 13,569 $ 13,569 $ 30,414 $ 30,414 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Energy Block Grant Fund (2240) Actual Budgeted Estimated Budgeted Citywide Activity: - Energy Block Grant Program (9240): Materials and Supplies $ 12,170 $ 60,005 $ 60,005 $ 0 Services and Charges 287,765 22,950 22,950 0 Capital 105,954 0 0 0 405,889 82,955 82,955 0 Total Citywide Activity: $ 405,889 $ 82,955 $ 82,955 $ 0 Total Fund $ 405,889 $ 82,955 $ 82,955 $ 0 59 e Left Blank Intentional 60 Parks Development Fund (2250) The Parks Development Fund accounts for the revenue and expenditures of the Parks HMR tax approved by the voters in 1995. The $3.1 million in planned expenditures for 2013 includes $1,283,000 in capital improvements. In 2010, a Citywide referendum was held and voters approved the use of these funds for maintenance activities. The use of Park Development Funds for promotional activities is no longer permitted. Due to these changes program rearrangements were made between the Parks Development Fund and General Fund. The 1% HMR tax revenue has grown on average 5.7% annually since 2001. 2012 revenue was estimated approximately 7.65% higher than 2011. 2013 revenue is projected to be flat compared to estimated 2012. Parks Development Fund Hotel -Motel -Restaurant (HMR) Tax Revenue $3.00 C O 75 $2.50 $2.00 $1.50 $1.00 $0.50 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year 61 City of Fayetteville, Arkansas 2013 Operating Budget Parks Development Fund (2250) Actual Budgeted Estimated Budgeted onii onio onio Oni' Revenues: Hotel, Motel, and Restaurant Taxes $ 2,298,187 $ 2,278,000 $ 2,474,000 $ 2,475,000 Charges for Services 0 5,000 0 0 Greenspace Fees Contribution 123,818 100,438 241,700 563,000 Investment Earnings 21,321 44,000 34,200 34,000 Other 37,683 40,000 30,000 2,000 Total Revenues 2,481,009 2,467,438 2,779,900 3,074,000 Expenses: Parks Development Program 1,633,055 1,715,700 1,682,286 1,811,000 Parks Development Capital 832,522 4,768,698 4,768,698 700,000 Parks Development Greenspace Capital 121,575 123,016 123,016 563,000 Total Expenses 2,587,152 6,607,414 6,574,000 3,074,000 Income / (Loss) $ (106,143) $ (4,139,976) $ (3,794,100) $ 0 Total Budget $ 2,587,152 $ 6,607,414 $ 3,074,000 6,574,000 $ FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 4,788,077 $ 4,681,934 $ 4,681,934 $ 887,834 Income / (Loss) (106,143) (4,139,976) (3,794,100) 0 Ending Undesignated Fund Balance $ 4,681,934 $ 541,958 $ 887,834 $ 887,834 62 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Parks Development Fund (2250) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Parks & Recreation Activity: Parks Development Program (9250): Personnel Services $ 1,212,305 $ 1,274,720 $ 1,242,067 $ 1,344,159 Materials and Supplies 57,894 60,935 60,935 64,290 Services and Charges 56,968 59,495 58,822 65,261 Motorpool Charges 198,478 213,321 213,233 209,342 Cost allocation 87,948 87,948 87,948 87,948 Maintenance 19,462 19,281 19,281 20,000 Contingency/Savings 0 0 0 20,000 1,633,055 1,715,700 1,682,286 1,81 1,000 Parks Development Capital Program (9255): Materials and Supplies 13,376 36,083 36,083 0 Services and Charges 23,435 554,873 554,873 0 Maintenance 19,046 10,344 10,344 0 Debt Service 77,865 78,034 78,034 0 Capital 698,800 4,089,364 4,089,364 700,000 832,522 4,768,698 4,768,698 700,000 Parks Development Capital Greenspace Program (9256): Services and Charges 28,484 16,289 16,289 0 Maintenance 0 5,290 5,290 0 Capital 93,091 101,437 101,437 563,000 121,575 123,016 123,016 563,000 Total Parks & Recreation Activity: $ 2,587,152 $ 6,607,414 $ 6,574,000 $ 3,074,000 Total Fund $ 2,587,152 $ 6,607,414 $ 6,574,000 $ 3,074,000 63 Page Left Blank Intentional 64 Impact Fee Fund (2300) The Impact Fee Fund accounts for the revenues and expenditures related to the collection of the water, wastewater, police, and fire impact fees. The intent of impact fee requirements is to ensure the new developments bear a proportionate share of the cost of capacity improvements and ensure that the proportional share does not exceed the costs of the demand for additional capacity that is reasonably attributable to providing these services and facilities to the use and occupancy of the new developments. Impact fee collections have declined dramatically from 2007 levels because of the fall in new development due to economic conditions. Impact Fee Collections ti $2.50 O 0 $2.00 $1.50 $1.00 $0.50 $0.00 04 05 06 07 08 09 10 11 12 Est 13 Bud Year Water Wastewater ® Police ® Fire 65 City of Fayetteville, Arkansas 2013 Operating Budget Impact Fee Fund (2300) Actual Budgeted Estimated Budgeted Revenues: Water Impact Fee $ 437,844 $ 432,000 $ 621,000 $ 486,000 Wastewater Impact Fee 283,436 273,000 434,900 383,000 Police Impact Fee 103,029 94,000 268,000 85,000 Fire Impact Fee 86,756 80,000 231,600 73,000 Investment Earnings 30,632 42,000 33,700 33,000 Total Revenues 941,697 921,000 1,589,200 1,060,000 Expenses: Water Improvements 0 1,701,000 1,701,000 0 Wastewater Improvements 0 287,000 287,000 0 Police Improvements 1,484,811 416,623 416,600 86,000 Fire Improvements 776,861 271,058 271,000 74,000 Transfer to Water & Sewer 0 1,541,473 1,541,000 900,000 Transfer to Shop 0 50,430 50,400 0 Total Expenses 2,261,672 4,267,584 4,267,000 1,060,000 Income / (Loss) $ (1,319,975) $ (3,346,584) $ (2,677,800) $ 0 Total Budget $ 2,261,672 $ 4,267,584 $ 1,060,000 4,267,000 $ FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 6,576,764 $ 5,256,789 $ 5,256,789 $ 2,578,989 Income / (Loss) (1,319,975) (3,346,584) (2,677,800) 0 Ending Undesignafed Fund Balance $ 5,256,789 $ 1,910,205 $ 2,578,989 $ 2,578,989 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Impact Fee Fund (2300) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Citywide Activity: Impact Fee Expense Program (9300): Materials and Supplies $ 56,496 $ 35,900 $ 35,900 $ 0 Capital 2,205,176 2,639,781 2,639,700 160,000 Operating Transfers 0 1,591,903 1,591,400 900,000 2,261,672 4,267,584 4,267,000 1,060,000 Total Citywide Activity: $ 2,261,672 $ 4,267,584 $ 4,267,000 $ 1,060,000 Total Fund $ 2,261,672 $ 4,267,584 $ 4,267,000 $ 1,060,000 67 (Page Left Blank Intentionally) Drug Law Enforcement Fund (2930) The Drug Law Enforcement Fund accounts for drug law enforcement grant funds received from the U.S. Department of Justice, passed through the State of Arkansas, in association with Washington County; the Cities of Springdale, Prairie Grove, Lincoln, Elm Springs, Farmington, Greenland, Goshen, Johnson, Elkins, and West Fork; and the Fourth Judicial Prosecuting Attorney. Drug Law Enforcement Fund Revenue Sources y $700 cc O 0 $600 $500 $400 $300 $200 $100 $0 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud 69 Year City of Fayetteville, Arkansas 2013 Operating Budget Drug Law Enforcement Fund (2930) Actual Budgeted Estimated Budgeted Revenues: Drug Enforcement Grant $ 309,828 $ 395,008 $ 296,800 $ 321,200 Charges for Services 2,075 0 0 0 Fines & Forfeitures 48,473 14,800 15,100 13,800 Other 205 0 1,100 0 Transfer from General 212,461 233,000 233,000 233,000 Total Revenues 573,042 642,808 546,000 568,000 Expenses: Drug Enforcement 477,886 654,851 590,000 568,000 Total Expenses 477,886 654,851 590,000 568,000 Income / (Loss) $ 95,156 $ (12,043) $ (44,000) $ 0 Total Budget $ 590,000 $ 477,886 $ 654,851 $ 568,000 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 1 17,61 1 $ 212,767 $ 212,767 $ 168,767 Income / (Loss) 95,156 (12,043) (44,000) 0 Ending Undesignafed Fund Balance $ 212,767 $ 200,724 $ 168,767 $ 168,767 70 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Drug Law Enforcement Fund (2930) Actual Budgeted Estimated Budgeted Police Activity: Drug Enforcement Program (2960): Personnel Services $ 247,182 $ 342,509 $ 278,091 $ 300,916 Materials and Supplies 16,815 0 0 0 Services and Charges 213,889 312,342 311,909 267,084 477,886 654,851 590,000 568,000 Total Police Activity: Total Fund 71 (Page Left Blank Intentionally) 72 Fire Bond Fund (3360) The Fire Bond Fund accounts for the accumulation of resources for and the replayment of bond debt incurred for the construction of Fire States #3 and #5. Final payment was in 20]]. 73 City of Fayetteville, Arkansas 2013 Operating Budget Fire Bond Fund (3360) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Investment Earnings $ 905 $ 0 $ 0 $ 0 Transfer from Sales Tax Capital 163,397 0 0 0 Total Revenues 164,302 0 0 0 Expenses: Principal Payment 400,000 0 0 0 Interest Expense 17,000 0 0 0 Settlements 32,106 0 0 0 Professional Services 2,270 0 0 0 Total Expenses 451,376 0 0 0 Income / (Loss) $ (287,074) $ 0 $ 0 $ 0 Total Budget $ 451,376 $ 0 $ 0 $ 0 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 287,074 $ 0 $ 0 $ 0 Income / (Loss) (287,074) 0 0 0 Ending Undesignated Fund Balance $ 0 $ 0 $ 0 $ 0 74 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Fire Bond Fund (3360) Actual Budgeted Estimated Budgeted Citywide Activity: Fire Bond Expense Program (9360): Services and Charges Debt Service Total Citywide Activity: Total Fund $ 34.376$ 0 $ 0 $ 451,376 0 0 $ 451,376$ 0$ 0$ 0 0 0 0 (Page Left Blank Intentionally) 76 TIF Bond Fund (3370) The Tax Increment Financing (TIF) Bond Fund accounts for the accumulation of resources for and the payment of bond debt incurred for TIF capital project expenditures. 77 City of Fayetteville, Arkansas 2013 Operating Budget TIF Bond Fund (3370) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Property Taxes $ 148,688 $ 100,000 $ 100,000 $ 100,000 Investment Earnings 7 0 0 0 Total Revenues 148,695 100,000 100,000 100,000 Expenses: Principal Payment 75,000 95,000 95,000 76,300 Interest Expense 33,587 51,630 51,630 17,900 Professional Services 2,270 2,300 2,300 2,300 Paying Agent Fees 3,500 3,500 3,500 3,500 Total Expenses 114,357 152,430 152,430 100,000 Income / (Loss) $ 34,338 $ (52,430) $ (52,430) $ 0 Total Budget $ 114,357 $ 152,430 $ 100,000 152,430 $ FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 119,203 $ 153,541 $ 153,541 $ 101,1 1 1 Income / (Loss) 34,338 (52,430) (52,430) 0 Ending Undesignated Fund Balance $ 153,541 $ 101,1 1 1 $ 101,1 1 1 $ 101,1 1 1 78 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) TIF Bond Fund (3370) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Citywide Activity: TIF Bonds Expense Program (9370): Services and Charges $ 2,270 $ 2,300 $ 2,300 $ 2,300 Debt Service 112,087 150,130 150,130 97,700 114,357 152,430 15 2, 430 100,000 Total Citywide Activity: $ 114,357 $ 152,430 $ 152,430 $ 100,000 Total Fund $ 114,357 $ 152,430 $ 100,000 152,430 $ 79 Paae Left Blank Intentional Sales Tax Bond Fund (3440) The Sales Tax Bond Fund accounts for the accumulation of resources incurred for the City's wastewater treatment plants, and to the City's trail system. and the payment of bond debt sewerage and related facilities, to certain City streets, Sales Tax Bond (1.00%) Sales Tax Revenue $Jn nn C $i $8.0 $6.0( $4.00 $2.00 $0.00 Year - 11 12 Est 13 Bud City of Fayetteville, Arkansas 2013 Operating Budget Sales Tax Bond Fund (3440) Actual Budgeted 2011 Estimated Budgeted Revenues: 2012 2012 Sales Tax - 2013 City Investment Earnings $ 16.518,746 Transfer from Sales Tax Construction 678 500 $ 16.371,900 $ 17,520,300 $ 17,870,300 Total Revenues 2 530 700 16,519,426 16 0 70 0 Expenses: 17,520,900 17,871,000 Principal Payment Interest Expense 1 1,674,748 Professional Services 11,902 ,772 1 1,902,772 13,981,125 4,596,019 4,462,828 4,462,828 3 972 Paying Agent Fees 4,540 175 4,000 4,000 4,900 Total Expenses 12,750 2 800 16,288,057 16,372,400 2.800 12,800 Income / (Loss) 16,372,400 17,871,000 $ 231,369 $ Total 0 $ 1,148,500 $ 0 Budget $ 057$ 16,372,400 ---�_$ 16,372,400 $ 17,871,000 Beginning Undesignated Fund Balance FUND BALANCE ANq�ySIS Income / (Loss) $ 3,478.251 $ 3,709,620 Ending Undesignated Fund Balance 231.369 $ 3.709,620 $ 4 958 120 $ 3,709,620 0 1,148,500 $ 3$ 4,858,120 0 $ 4� 2Q City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Sales Tax Bond Fund (3440) Citywide Activity: Actual 2011 Budgeted 2012 Estimated 2012 Budgeted Sewer Bonds - Expense Program 2013 (9440): Services and Charges Debt Service 4,540 $ 4,000 $ 16,283,517 16,288,057 16,368, 00 4.000 $ 16.368,400 4,900 17,866,100 Total Citywide Activity: 2,400 16, 3 72, 400 17,871,000 Total Fund $ 16,288,057 $ 16,372,400 $ 16,372,400 $ 17,871,000 $ 16,288,057 $ 16,372400 �_$ 16,372,400 $ 17,871,000 83 Page Left Blank Intentiona Replacement & Disaster Recovery Fund (4270) The Replacement & Disaster Recovery Fund accounts for general government monies accumulated and used for the purchase of vehicles and equipment. By policy, the fund attempts to maintain a reserve of three million dollars for disaster recovery. In 2010, the City Council approved a $700,000 interfund loan from the Replacement and Disaster Recovery Fund to the Parking Fund for the purchase of equipment. This fund will be paid back from parking revenue within a five year period. Replacement & Disaster Recovery Fund Ending Fund Balance ti $5.00 C O $4.50 $4.00 $3.50 $3.00 $2.50 $2.00 $1.50 $1.00 $0.50 $0.00 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year City of Fayetteville, Arkansas 2013 Operating Budget Replacement & Disaster Recovery Fund (4270) Actual Budgeted 2011 2012 Revenues: Estimated Budgeted 2012 2n1� Intergovernmental (Grants) $ 78,084 $ 593,819 $ 593,800 $ 0 Federal Grants - Capital 203,097 0 250,200 0 Replacement Copier Revenue 32,531 51,219 41,600 Investment Earnings 26,348 27,750 31,000 40,000 31,000 Other 900 0 300 0 Total Revenues 340,960 672,788 916,900 71,000 Expenses: Audit Expense 1,700 1,750 1,750 2,000 FEMA Disaster Projects 39,823 461,970 461,970 0 Professional Services 0 Fixed Assets 6,210 6,210 0 Vehicles & Equipment 19,484 140,435 140,435 40,000 Transfer to Street 0 9,885 9,885 0 Transfer to Water & Sewer 11,056 79,915 79,915 0 Transfer to Sales Tax Capital 0 252,000 252,000 0 Transfer to Airport 0 139,378 139,378 0 Transfer to Shop 15,857 0 0 0 Total Expenses 37,434 6,000 6,000 0 125,354 1,097,543 1,097,543 42,000 Income / (Loss) $ 215,606_$ (424,755) $ (180,643) $ 29,000 Total Budget $ 125,354 $ 1,097,543 $ 1,097,543 $ 42,000 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 3,234,600 $ 3,450,206 $ 3,450,206 $ 3,269,563 Income / (Loss) 215,606 (424,755) (180,643) 29,000 Ending Undesignated Fund Balance $ 3,450,206 $ 3,025,451 $ 3,269,563 $ 3,298,563 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Replacement &Disaster Recovery Fund (4270) Actual Budgeted 7ntt I)nin Citywide Activity: Replacement Fund Expense Program (9270): Services and Charges $ Capital Operating Transfers FEMA Disaster Projects Program (9280): Materials and Supplies Services and Charges Operating Transfers Total Citywide Activity: Total Fund Estimated Budgeted ,)()1 7 On t o 1,700 $ 7,960 $ 7,960 $ 2,000 19,484 150,320 150,320 40,000 37,434 6,000 6,000 0 58,618 164,280 164,280 42,000 22,297 952 952 0 17,526 461,018 461,018 0 26,913 471,293 471,293 0 66,736 933,263 933,263 0 125,354 $ 1,097,543 $ 42,000 1,097,543 $ $ 125,354 $ 1,097,543 $ 1,097,543 $ 42,000 Page Left Blank Intentional Sales Tax Capital Improvements Fund (4470) The Sales Tax Capital Improvements Fund accounts for the revenue and expenditures of the City's sales and use tax which is used for acquisition and improvement projects as well as equipment additions and replacements that are included in the City's Five -Year Capital Improvements Program. The $8,253,000 in planned expenditures for 2013 includes $8,245,000 in capital improvements. Use of Fund balance of $1,000,000 is planned for 2013 The capital portion of City Sales Tax for 2012 is expected to be $459,400 over 201 1 collections. A 2% increase over 2012 estimated is forecasted for 2013. 1% City Sales Tax $20.00 C O $18.00 $16.00 $14.00 $12.00 $10.00 $8.00 $6.00 $4.00 $2.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year City of Fayetteville, Arkansas 2013 Operating Budget Sales Tax Capital Improvements Fund (4470) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Property Taxes $ 2 $ 0 $ 0 $ 0 Sales Tax - City 6,601,311 6,543,600 7,003,000 7,143,000 Intergovernmental (Grants) 2,750,051 4,932,149 4,932,200 0 Charges for Services 269,285 901,765 901,800 50,000 Sidewalk Fees 1,260 0 8,300 0 Investment Earnings 34,717 58,000 59,500 60,000 Other 42,195 78,340 102,600 0 Transfer from Replacement 0 139,378 139,400 0 Total Revenues 9,698,821 12,653,232 13,146,800 7,253,000 Expenses: Audit Expense 7,000 7,300 7,300 8,000 Sales Tax Capital Improvements 6,792,034 19,787,132 19,786,274 8,245,000 Transfer to Other Funds 0 39,508 0 0 Transfer to General 1,000,000 0 0 0 Transfer to Fire Bond 163,397 0 0 0 Transfer to Shop 0 45,426 45,426 0 Total Expenses 7,962,431 19,879,366 19,839,000 8,253,000 Income / (Loss) $ 1,736,390 $ (7,226,134) $ (6,692,200) $ (1,000,000) Total Budget $ 7,962,431 $ 19,879,366 $ 19,839,000 $ 8,253,000 FUND BALANCE ANALYSIS Beginning Undesignafed Fund Balance $ 7,151,003 $ 8,887,393 $ 8,887,393 $ 2,195,193 Income / (Loss) 1,736,390 (7,226,134) (6,692,200) (1,000,000) Ending Undesignafed Fund Balance $ 8,887,393 $ 1,661,259 $ 2,195,193 $ 1,195,193 90 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Sales Tax Capital Improvements Fund (4470) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Citywide Activity: Sales Tax Capital Improvements Program (9470): Materials and Supplies $ 531,104 $ 1,113,939 $ 1,1 13,939 $ 568,000 Services and Charges 777,404 1,340,853 1,340,853 91,000 Cost allocation 0 6,547 6,547 0 Maintenance 1,665,662 4,437,677 4,437,677 2,226,000 Transfers To Outside Entities 358,000 359,500 359,500 405,000 Capital 3,466,864 12,535,916 12,535,058 4,963,000 Operating Transfers 1,163,397 84,934 45,426 0 7,962,431 19,879,366 19,839,000 8,253,000 Total Citywide Activity: Total Fund $ 7,962,431 $ 19,879,366 $ 19,839,000 $ 8,253,000 $ 7,962,431 $ 19,879,366 $ 19,839,000 $ 8,253,000 City of Fayetteville, Arkansas Sales Tax Capital Improvements Fund Capital Budget Project Category Project Title Budgeted 2013 Bridge & Drainage Improvements Other Drainage Improvements $ 200,000 Stormwater Quality Mgt/Nutrient Reduction 160,000 360.000 Fire Improvements Fire Apparatus Purchases Fire Facility Maintenance Fire Information Technology Updates Information Technology Improvements Library Improvements Other Capital Improvements AccessFayetteville Technical Improvements Backup Storage Appliance Data Center Relocation Document Management Enterprise Data Warehouse System ERP Upgrade/Replacement Exchange/Office Upgrade Geographic Information System (GIS) Local Area Network (LAN) Upgrade Microcomputer / Printer Replacements Storage Area Network (SAN) Library Computer Replacements Library Materials Purchases Accounting Image Scanner & Check Scanner Audit Expense Building Improvements Legislative Management/Agenda Routing Regional Wayfinding Signage Program City Hall Audio -Visual Renovation Remote Meeting Recording Television Center Digital Conversion Television Center Equipment Telecommunications Systems Upgrades Citywide Building Insurance Appraisal Study 92 426,000 125,000 40,000 591.000 25,000 75,000 220,000 15,000 97,000 1,222,000 220,000 50,000 140,000 68,000 40,000 �►wFrwaaa 30,000 375,000 405.000 5,000 8,000 119,000 33,000 125,000 70,000 50,000 75,000 50,000 5,000 35,000 5/5,uuU City of Fayetteville, Arkansas Sales Tax Capital Improvements Fund Capital Budget Project Category Project Title Parks & Recreation Improvements Forestry, Safety & ADA Compliance Lights of the Ozarks Native Grasses Program Tree Escrow Police Improvements Police Technology Improvements Police Unmarked Vehicles Police Building Improvements Police Specialized Equipment Police Bulletproof Vests Police Patrol Vehicle Electronic Upgrades Police Equipment Replacement Street Improvements Street/ROW/Intersection Cost Shares Trail Improvements Trail Development Transportation Improvements In -House Pavement Improvements In -House Sidewalk Improvements 93 Budgeted 31,000 23,000 10,000 178,000 40,uuu 57,000 25,000 55,000 10,000 160,000 100,000 1,548,000 1,548,000 I ,04L,000 1,957,000 $ 8,253,000 (Page Left Blank Intentionally) 94 Wastewater System Improvements Project Fund (4480) The Wastewater System Improvements Project Fund accounts for the bond proceeds to construct and equip a new wastewater treatment plant. Appropriation of these funds will be provided through the rebudget process which will be considered by the City Council during the first quarter of 2013. 95 City of Fayetteville, Arkansas 2013 Operating Budget Wastewater System Improvements Project Fund (4480) Revenues: Investment Earnings $ Other Total Revenues Expenses: Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 7,054 $ 0 $ 10,400 $ 0 0 0 79,000 0 7,054 0 89,400 0 Professional Services 214,790 281,550 19,840 0 Wastewater System Improvements Project 1,203,102 24,449 21,214 0 Transfer to Other Funds 0 1,068,055 0 0 Transfer to Water & Sewer 0 0 0 1,520,000 Transfer to Shop 238,368 0 0 0 Total Expenses 1,656,260 1,374,054 41,054 1,520,000 Income / (Loss) $ (1,649,206) $ (1,374,054) $ 48,346 $ (1,520,000) Total Budget $ 1,656,260 $ 41,054 $ 1,374,054 $ 1,520,000 FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 3,120,860 $ 1,471,654 $ 1,471,654 $ 1,520,000 Income / (Loss) (1,649,206) (1,374,054) 48,346 (1,520,000) Ending Undesignated Fund Balance $ 1,471,654 $ 97,600 $ 1,520,000 $ 0 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Wastewater System Improvements Project Fund (4480) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Citywide Activity: Wastewater System Improvements Project Program (9480): Services and Charges $ 337,944 $ 281,550 $ 19,840 $ 0 Capital 1,079,948 24,449 21,214 0 Operating Transfers 238,368 1,068,055 0 1,520.000 1,656,260 1,374,054 41,054 1,520,000 Total Citywide Activity: $ 1,656,260 $ 1,374,054 $ 41,054 $ 1,520,000 Total Fund $ 1,656,260 $ 1,374,054 $ 41,054 $ 1,520,000 97 Paqe Left Blank Intentiona Sales Tax Construction Bond Fund (4520) The Sales Tax Construction Bond Fund accounts for the bond proceeds for improvements to the wastewater treatment plant, streets, and trail construction pursuant to the 2006 referendum. Appropriations of these funds will be provided through the re -budget process which will be considered by the City Council during the first quarter of 2013. City of Fayetteville, Arkansas 2013 Operating Budget Sales Tax Construction Bond Fund (4520) Actual Budgeted Estimated Budgeted Revenues: Investment Earnings $ 1,975 $ 2,000 $ 1,220 $ 1,200 Other 0 0 9,980 5,800 Total Revenues 1,975 2,000 11,200 7,000 Expenses: Audit Expense 3,480 4,000 2,000 7,000 2006A Sales Tax Construction Expense 2,408,250 1,329,942 1,329,942 0 2007A Sales Tax Construction Expense 1,149,296 3,702 3,702 0 Street Sales Tax Construction (2009) 1,307,295 8,326,079 8,326,079 0 Trails Sales Tax Construction (2009) 505,955 433,527 433,527 0 Transfer to Sales Tax Bond 2 65 65 0 Total Expenses 5,374,278 10,097,315 10,095,315 7,000 Income / (Loss) $ (5,372,303) $ (10,095,315) $ (10,084,115) $ 0 Total Budget $ 5,374,278 $ 10,097,315 $ 7,000 10,095,315 $ FUND BALANCE ANALYSIS Beginning Undesignated Fund Balance $ 17,167,314 $ 1 1,795,01 1 $ 1 1,795,01 1 $ 1,710,896 Income / (Loss) (5,372,303) (10,095,315) (10,084,115) 0 Ending Undesignated Fund Balance $ 11,795,011 $ 1,699,696 $ 1,710,896 $ 1,710,896 100 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Sales Tax Construction Bond Fund (4520) Actual Budgeted Estimated Budgeted Citywide Activity: 2006A Sales Tax Construction Expense Program (9520): Services and Charges $ 234,385 $ 500,442 $ 498,442 $ 7,000 Capital 2,177,345 833,500 833,500 0 Operating Transfers 2 0 0 0 2,41 1,732 1,333,942 1,331,942 7,000 2007A Sales Tax Construction Expense Program (9530): Services and Charges (45,562) 0 0 0 Capital 1,194,858 3,702 3,702 0 Operating Transfers 0 65 65 0 1,149,296 3,767 3,767 0 Street Sales Tax 2009 Program (9540): Services and Charges 1,135 0 0 0 Capital 1,306,160 8,326,079 8,326,079 0 1,307,295 8,326,079 8,326,079 0 Trails Sales Tax 2009 Program (9550): Services and Charges 76,752 30,491 30,491 0 Capital 429,203 403,036 403,036 0 505,955 433,527 433,527 0 Total Citywide Activity: $ 5,374,278 $ 10,097,315 $ 7,000 10,095,315 $ Total Fund $ 5,374,278 $ 10,097,315 $ 7,000 10,095,315 $ 101 (Page Left Blank Intentionally) 102 Water and Sewer Fund (5400) The Water & Sewer Fund accounts for the revenue sources as well as the operation and maintenance expenses of the City's water and sewer system. This includes water purchases from Beaver Water District, all water and sewer functions, the operation of the wastewater treatment plants, meter and backflow operations, and billing and collections. The 2013 Budget is predicated on a break even basis. Water & Sewer Fund Revenues For 2013, the Water & Sewer Fund is projected to have an operating gain of $5,909,000 before capital expenditures and depreciation expense. City Council approved water and sewer rate increases in 2008 which included incremental increases in 2009, 2010, and 2011. The revenue projections reflect the phased rate adjustments. Water usages in 2008 and 2009 were far under projections due to unusually wet conditions. In 2011 and 2012 usage was above projections due to drought conditions during the summer months. Therefore for fiscal 2013, usage projections are lower than estimated 2012 consumption. Sources of Funds for 2013 $34,920,000 Sewer Servira Chnruac Interest Income $10,000 0.0% Other Transfers In $353,000 $14,913,000 1.0% 42.7% 103 Water Sales: Water sales revenue is based on metered customer usage of water and is one of the primary sources of revenue for the Water & Sewer Fund. The budgeted revenue for 2013 shows a decrease over estimated 2012 revenue due to unusually dry conditions experienced during the summer months. $18.00 O $16.00 $14.00 $12.00 $10.00 $8.00 $6.00 $4.00 $2.00 $0.00 U2 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year Sewer Charges: Sewer service charge revenue is based on metered customer usage of water and is the other primary source of revenue for the Water & Sewer Fund. The budgeted revenue for 2013 is projected to be approximately $541,000 over estimated 2012. $18.00 $16.00 $14.00 $12.00 $10.00 $8.00 $6.00 $4.00 $2.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year 104 Water & Sewer Fund Expenses The wastewater treatment plant operations budgeted for 2013 represents the largest expenditure in the fund at $8.3 million. This represents 23.9% of the total operating expenses. The water purchases are budgeted at $6.6 million, which represents 18.9% of total operating expenditures. Water purchase rates increased two cents per 1,000 gallons in October 2012 and will increase the same rate in October 2013. Use of Funds for 2013 $34,920,000 Utilities Director Capital Expenditures $179,220 Utilities Project $6,824,000 0.5% Management 19.5% $309,478 Principal Payment 0.9% Water Purchased $1,505,000 $6,600,000 4.3% 18.9% Operations & Interest Expense Administration $402,874 1.2% $3,772,742 10.8% Meter Operations $1,516,710 " Water Transmission and 4.3% Distribution $2,193,229 Billing & Collections 6.3% 1 278 24 $ ' 5 Sewer Main Maintenance 3.7% Wastewater Treatment Plant $2,003,928 $8,334,574 5.7 23.9% Water Purchases $7.00 O a 2 $6.00 $5.00 $4.00 $3.00 $2.00 $1.00 $0.00 02 03 04 05 06 07 08 09 10 Year 105 City of Fayetteville, Arkansas 2013 Operating Budget Water & Sewer Fund (5400) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Water Sales $ 15,343,440 $ 14,129,900 $ 15,448,500 $ 14,913,000 Sewer Service Charges 15,651,577 15,339,000 15,712,880 16,254,000 Other 1,138,611 951,000 1,016,030 970,000 Interest Income 73,386 68,100 91,900 10,000 Other Non -Operating 418,529 420,000 294,690 353,000 Total Revenues 32,625,543 30,908,000 32,564,000 32,500,000 Expenses: Utilities Director 164,005 172,062 171,100 179,220 Utilities Project Management 224,088 372,303 293,091 309,478 Water Purchased 6,057,950 6,500,000 6,500,000 6,600,000 Operations & Administration 3,227,319 3,395,311 3,352,074 3,772,742 Water Transmission and Distribution 1,774,560 2,103,653 1,984,201 2,193,229 Sewer Main Maintenance 1,721,736 1,963,257 1,822,879 2,003,928 Wastewater Treatment Plant 7,515,149 7,766,607 7,716,860 8,334,574 Billing & Collections 1,042,808 1,206,355 1,177,714 1,278,245 Meter Operations 1,376,806 1,651,733 1,566,464 1,516,710 Interest Expense 543,763 595,228 595,228 402,874 Total Expenses 23,648,184 25,726,509 25,179.611 26.591.000 Budget Gain / (Loss) Before Capital Non -Operating Revenues / (Expenses): Intergovernmental (Grants) Gain/Loss Sale of Assets Transfer from Replacement Transfer from Impact Fee Fund Transfer from WWT Improvements Principal Payment Capital Expenditures Transfer to Shop Total Capital Revenues / (Expenses) Budget Gain / (Loss) Total Budget $ 8,977,359 $ 5,181,491 $ 7,384,389 $ 5,909,000 1,403,320 40,595 0 0 0 (1,270,000) (8,642,042) 0 12/) 2,738,975 0 126,000 1,437,582 0 (2,120,000) (18,845,861) (342,844) (17,006,148) 2,739,000 24,300 126,000 1,437,600 0 (2,120,000) (18,787,587) (276,644) (16,857,331) 0 0 0 900,000 1,520,000 (1,505,000) (6,824,000) 0 (J,YUY,uuu) $ 509,232 $ (11,824,657) $ (9,472,942) $ 0 $ 33,560,226 $ 47,035,214 $ 46,363,842 $ 34,920,000 106 City of Fayetteville, Arkansas 2013 Operating Budget Water & Sewer Fund (5400) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 ESTIMATED CHANGE IN NET ASSETS Beginning Total Net Assets Budget Gain / (Loss) Plus: Gain Capital Expenditures Plus: Capital Contribution Plus: Bond Principal Payment Less: Depreciation Expense Ending Total Net Assets $ 311,742,969 $ 324,250,798 $ 324,250,798 $ 324,561,294 509,232 (11,824,657) (9,472,942) 0 8,642,042 18,845,861 18,787,587 6,824,000 12,362,409 0 0 0 1,270,000 2,120,000 2,120,000 1,505,000 (10,275,854) (11,124,149) (11,124,149) (11,304,142) $ 324,250,798 $ 322,267,853 $ 324,561,294 $ 321,586,152 NET ASSET ANALYSIS Net Investment in Capital Assets $ 303,432,672 $ 313,274,384 $ 313,216,1 10 $ 310,240,968 Restricted for Prepaids/Debt Service 2,409,426 2,409,426 2,409,426 2,409,426 Unrestricted 18,408,700 6,584,043 8,935,758 8,935,758 Ending Total Net Assets $ 324,250,798 $ 322,267,853 $ 324,561,294 $ 321,586,152 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Water & Sewer Fund (5400) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Finance & Internal Services Activity: Billing & Collections Program (1810): Personnel Services $ 751,586 $ 794,168 $ 765,527 $ 814,808 Materials and Supplies 44,401 70,000 70,000 70,000 Services and Charges 331,175 420,387 420,387 469,937 Cost allocation (89,700) (89,700) (89,700) (89,700) Maintenance 5,346 11,500 11,500 13,200 1,042,808 1,206,355 1,177,714 1,278,245 Total Finance & Internal Services Activity $ 1,042,808 $ 1,177,714 $ 1,206,355 $ 1,278,245 Business -Type Activity: Utilities Director Program (1800): Personnel Services $ 133,176 $ 134,406 $ 134,406 $ 136,564 Materials and Supplies 696 4,300 4,300 4,300 Services and Charges 4,057 7,280 6,318 12,280 Cost allocation 26,076 26,076 26,076 26,076 164,005 172,062 171,100 179,220 Meter Reading Program (1820): Personnel Services 745,278 780,431 753,491 819,023 Materials and Supplies 58,812 64,069 64,069 66,869 Services and Charges 10,940 16,007 14,880 17,307 Motorpool Charges 51,932 58,433 58,433 66,643 Cost allocation 78,528 78,528 78,528 78,528 Maintenance 3,134 4,585 4,585 4,781 948,624 1,002,053 973,986 1,053,151 Meter Maintenance & Backflow Prevention Program (1830): Personnel Services 299,984 370,016 312,815 363,512 Materials and Supplies 34,068 23,759 23,759 45,259 Services and Charges 5,394 9,025 9,025 12,725 Motorpool Charges 13,848 16,486 16,485 16,575 Cost allocation 24,888 24,888 24,888 24,888 Maintenance 0 600 600 600 378,182 444,774 387,572 463,559 Meter Operations Capital Program (1840): Materials and Supplies 0 54,652 54,652 0 Services and Charges 50,000 150,000 150,000 0 Maintenance 0 254 254 0 Capital 957,596 569,133 569,133 431,000 Operating Transfers 0 A/, Inn n n 108 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Water & Sewer Fund (5400) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Water Purchased Program (3800): Services and Charges 6,057,950 6,500,000 6,057,950 6,500,000 6,500,000 6,600,000 6,500,000 6,600,000 Operations & Administration Program (4000): Personnel Services 678,667 769,203 725,966 928,218 Materials and Supplies 1 12,257 166,845 166,845 148,271 Services and Charges 1,463,957 1,464,379 1,464,379 1,707,322 Motorpool Charges 20,332 21,450 21,450 20,497 Cost allocation 883,152 883,152 883,152 883,152 Maintenance 68,954 90,282 90,282 85,282 Debt Service 8,101 21,000 21,000 21,000 Capital 0 72,190 72,190 0 3,235,420 3,488,501 3,445,264 3,793,742 Utilities Project Management Program (4020): Personnel Services 208,781 334,185 256,569 258,878 Materials and Supplies 4,219 13,608 13,608 10,608 Services and Charges 2,705 13,945 12,350 20,045 Motorpool Charges 6,965 6,965 6,964 6,947 Maintenance 1,418 3,600 3,600 13,000 224,088 372,303 293,091 309,478 Water Distribution Maintenance Program (4310): Personnel Services 623,862 Materials and Supplies 558,618 Services and Charges 122,564 Motorpool Charges 218,041 Cost allocation 74,688 Maintenance Water Storage & Pump Maintenance Program (4330): Personnel Services 136,052 Materials and Supplies 27,686 Cost allocation 9,696 Maintenance 97 173,531 109 764,184 662,769 828,935 677,994 677,994 677,994 146,851 14 6, 851 106,665 235,468 235,468 314,891 74,688 74,688 74,688 3,000 3,000 3,000 1,902,185 1,800,770 2,006,173 150,129 132,092 134,717 39,243 39,243 40,743 9,696 9,696 9,696 2,400 2,400 1,900 201,468 183,431 187,056 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Water & Sewer Fund (5400) Actual Budgeted Estimated Budgeted Sewer Mains Maintenance Program (4410): Personnel Services Materials and Supplies Services and Charges Motorpool Charges Cost allocation Maintenance WWTP Administration & SCADA Program (5100) Materials and Supplies 0 1,073 1,073 1,073 Services and Charges 1,000,971 1,064,535 1,064,534 1,553,870 Maintenance 0 585 585 842 1,000,971 1,066,193 1,066,192 1,555,785 921,836 1,070,710 358,085 354,192 66,129 116,304 292,488 338,719 77,832 77,832 5,366 5,500 1,721,736 1,963,257 930,334 1,041,362 354,192 354,192 116,304 123,954 338,717 397,088 77,832 77,832 5,500 9,500 1,822,879 2,003,928 WWTP East Side Operations Program (5110): Materials and Supplies 69,983 101,101 101,101 1 1 1,101 Services and Charges 3,138,505 3,350,633 3,327,687 3,521,730 Motorpool Charges 139,884 187,094 187,094 252,543 Cost allocation 47,820 47,820 47,820 47,820 Maintenance 230 14,153 14,153 8,153 3,396,422 3,700,801 3,677,855 3,941,347 WWTP West Side Operations Program (5120): Materials and Supplies 1 7,1 68 89,655 89,655 99,655 Services and Charges 1,785,657 1,504,1 10 1,480,677 1,398,410 Motorpool Charges 61,027 55,816 55,815 65,330 Cost allocation 47,544 47,544 47,544 47,544 Maintenance 0 3,548 3,548 3,549 1,91 1,396 1,700,673 1,677,239 1,614,488 WWTP Lab / IPP Program (5130): Services and Charges 459,731 480,654 480,654 472,01 1 459,731 480,654 480,654 472,011 WWTP Lift Station Maintenance Program (5140): Materials and Supplies 1 1,656 39,969 39,969 39,969 Services and Charges 656,662 723,097 719,731 705,617 Motorpool Charges 9,669 9,670 9,670 5,357 677,987 772,736 769,370 750,943 110 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Water & Sewer Fund (5400) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Capital Water Mains Program (5600): Services and Charges 1,659,816 906,990 906,990 0 Capital 2,175,159 6,726,312 6,726,312 1,335,000 3,834,975 7,633,302 7,633,302 1,335,000 Water & Sewer Connections Program (5620): Personnel Services 129,580 185,823 127,549 171,902 Materials and Supplies 61,880 87,014 87,014 87,014 Services and Charges 6,631 18,000 18,000 18,000 Motorpool Charges 23,096 24,048 24,048 30,496 Cost allocation 13,488 13,488 13,488 13,488 Maintenance 0 100 100 100 234,675 328,473 270,199 321,000 Water Capital 2009 Bonds Program (5640): Services and Charges 102,320 104,409 104,409 0 Capital 2,657,870 1,671,600 1,671,600 0 2,760,190 1,776,009 1,776,009 0 Sewer Mains Construction Program (5700): Services and Charges .170,264 881,578 881,578 0 Capital 574,521 4,907,785 4,907,785 1,660,000 744,785 5,789,363 5,789,363 1,660,000 Sewer Capital 2009 Bonds Program (5740): Capital 0 869,119 869,119 0 0 869,119 869,119 0 Wastewater Treatment Plant Capital Program (5800): Materials and Supplies 0 6,800 6,800 0 Services and Charges 38,500 38,500 38,500 0 Maintenance 30,142 250 250 0 Capital 109,821 1,808,272 1,808,272 3,077,000 Operating Transfers 0 276,644 276,644 0 178,463 2,130,466 2,130,466 3,077,000 Debt Service Program (6800): Debt Service 1,805,662 2,694,228 2,694,228 1,886,874 1,805,662 2,694,228 2,694,228 1,886,874 Total Business -Type Activity $ 32,517,418 $ 45,186,128 $ 45,828,859 $ 33,641,755 Total Fund $ 33,560,226 $ 46,363,842 $ 47,035,214 $ 34,920,000 Paqe Left Blank Intentional INK Solid Waste Fund (5500) The Solid Waste Fund is responsible for the operation of the City's solid waste collection and disposal, transfer station, recycling program, and composting program. Revenues for the fund are obtained from fees levied for trash collection, recycling revenue, and container sales or leases. During the end of 2009, the operation of the transfer station, which had previously been contracted out, was brought in house. This budget reflects changes needed to continue that operation at the City. After capital expenditures, the fund will have a loss of $2,277,000. However, there are more than sufficient reserves to accommodate the expenditures. Solid Waste Fund Revenues For 2013, the Solid Waste Fund sources of funds are budgeted at $1 1,774,000. Solid Waste fees make up the largest source of revenue (66.4%). Recycling Revenues Recycling revenue includes the sale of materials collected at curbside and at the recycling centers. The estimated revenue for that program is $532,100 for 2013. Also, a portion of the solid waste fees are attributable to recycling activity. That portion is estimated to be approximately $1,500,000 for 2012 and 2013. Sources of Funds for 2013 $11,774,000 Solid Waste Fees $7,813,500 66.4% Franchise Fee $165,500 1.4% $2,277,000 $62,200 19.4% 0.5% 113 Recycling Revenue $532,100 4.5% mercial Drop Box $569,400 4.8% ;fer Station 332,800 2.8% Solid Waste Fees: The 2012 revenue estimates are approximately $300,000 over 2011 actual collections. The 2013 revenues are projected to be relatively flat over 2012 estimates . $9.00 C $8.00 $7.00 $6.00 $5.00 $4.00 $3.00 $2.00 $1.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year Solid Waste Fund Expenses Expenses for the Solid Waste Fund are budgeted at $1 1,774,000 for 2013. The commercial collections program and related activity make up the largest segment of the budget. Use of Funds for 2013 $11,774,000 114 City of Fayetteville, Arkansas 2013 Operating Budget Solid Waste Fund (5500) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Franchise Fees $ 156,632 $ 183,100 $ 165,600 $ 165,500 Solid Waste Fees 7,557,057 7,372,500 7,859,300 7,813,500 Recycling Revenue 818,408 747,600 513,000 532,100 Commercial Drop Box 527,657 486,200 569,200 569,400 Transfer Station 290,777 262,000 332,700 332,800 Other 22,825 23,400 21,700 21,500 Interest Income 45,097 54,000 62,000 62,200 Total Revenues 9,418,453 9,128,800 9,523,500 9,497,000 Expenses: Operations & Administration 1,490,817 1,702,320 1,615,561 1,762,968 Commercial Collections 1,978,988 2,366,765 2,253,407 2,430,879 Residential Collections 1,537,432 1,753,972 1,691,754 1,926,699 Commercial Drop Box Collections 460,665 567,275 562,400 520,688 Transfer Station 850,049 996,413 992,580 872,553 Recycling 1,351,089 1,543,553 1,485,177 1,813,812 Composting 706,389 770,636 650,745 597,401 Solid Waste Projects 103,552 137,742 137,742 0 Total Expenses 8,478,981 9,838,676 9,389,366 9,925,000 Budget Gain / (Loss) Before Capital $ 939,472 $ (709,876) $ 134,134 $ (428,000) Non -Operating Revenues / (Expenses): Intergovernmental (Grants) 15,551 18,500 18,500 0 Capital Expenditures (549,651) (2,401,470) (2,401,470) (1,849,000) Total Capital Revenues / (Expenses) (534,100) (2,382,970) (2,382,970) (1,849,000) Budget Gain / (Loss) $ 405,372 $ (3,092,846) $ (2,248,836) $ (2,277,000) Total Budget $ 9,028,632 $ 11,790,836 $ 12,240,146 $ 11,774,000 City of Fayetteville, Arkansas 2013 Operating Budget Solid Waste Fund (5500) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 ESTIMATED CHANGE IN NET ASSETS Beginning Total Net Assets $ 11,038,769 $ 11,795,414 $ 11,795,414 $ 11,528,646 Budget Gain / (Loss) 405,372 (3,092,846) (2,248,836) (2,277,000) Plus: Gain Capital Expenditures 549,651 2,401,470 2,401,470 1,849,000 Less: Depreciation Expense (198,378) (419,402) (419,402) (500,210) Ending Total Net Assets $ 11,795,414 $ 10,684,636 $ 11,528,646 $ 10,600,436 NET ASSET ANALYSIS Net Investment in Capital Assets $ 2,477,295 $ 4,459,363 $ 4,459,363 $ 5,808,153 Unrestricted 9,318,119 6,225,273 7,069,283 4,792,283 Ending Total Net Assets $ 11,795,414 $ 10,684,636 $ 11,528,646 $ 10,600,436 116 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Solid Waste Fund (5500) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Business -Type Activity: Operations & Administration Program (5000): Personnel Services $ 492,743 $ 549,058 $ 464,309 $ 548,666 Materials and Supplies 28,836 48,365 46,455 43,340 Services and Charges 540,326 643,694 643,594 710,758 Motorpool Charges 2,633 3,577 3,577 4,496 Cost allocation 410,796 410,796 410,796 410,796 Maintenance 15,483 46,630 46,630 44,712 Debt Service 0 200 200 200 Capital 0 8,500 8,500 0 1,490,817 1,710,820 1,624,061 1,762,968 Commercial Collections Program (5010): Personnel Services 552,128 598,086 577,552 634,650 Materials and Supplies 213,660 359,443 348,899 388,434 Services and Charges 639,270 666,460 665,720 700,982 Motorpool Charges 505,176 673,772 592,232 639,009 Cost allocation 67,404 67,404 67,404 67,404 Maintenance 1,350 1,600 1,600 400 1,978,988 2,366,765 2,253,407 2,430,879 Residential Collections Program (5020): Personnel Services 607,619 609,827 547,610 594,493 Materials and Supplies 163,987 213,899 213,899 239,904 Services and Charges 328,571 340,211 340,211 366,695 Motorpool Charges 389,235 539,132 539,131 674,704 Cost allocation 47,868 47,868 47,868 47,868 Maintenance 152 3,035 3,035 3,035 Capital 0 5,572 5,572 0 1,537,432 1,759,544 1,697,326 1,926,699 Commercial Drop Box Collections Program (5030): Personnel Services 140,994 Materials and Supplies 28,371 Services and Charges 179,911 Motorpool Charges 102,113 Cost allocation 9,060 Maintenance 216 Capital 38,747 499,412 145,201 141,985 152,668 73,370 73,370 35,571 207,018 207,018 198,855 131,626 129,967 124,034 9,060 9,060 9,060 1,000 1,000 500 23,000 23,000 0 590,275 585,400 520,688 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Solid Waste Fund (5500) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Transfer Station Program (5040): Personnel Services 142,686 139,523 135,690 126,409 Materials and Supplies 13,194 17,153 17,153 18,583 Services and Charges 646,948 767,413 767,413 673,312 Motorpool Charges 42,597 43,500 43,500 43,925 Cost allocation 3,024 3,024 3,024 3,024 Maintenance 1,600 25,800 25,800 7,300 850,049 996,413 992,580 872,553 Recycling Program (5060): Personnel Services 709,552 800,302 755,494 924,395 Materials and Supplies 126,446 152,999 152,999 208,281 Services and Charges 33,298 25,685 25,685 125,500 Motorpool Charges 390,046 436,349 422,781 455,918 Cost allocation 87,732 87,732 87,732 87,732 Maintenance 4,015 40,486 40,486 11,986 Capital 0 8,392 8,392 0 1,351,089 1,551,945 1,493,569 1,813,812 Composting Program (5070): Personnel Services 397,678 426,171 307,902 292,142 Materials and Supplies 40,360 65,712 65,712 71,760 Services and Charges 958 3,559 3,559 4,100 Motorpool Charges 236,992 244,754 243,132 198,959 Cost allocation 29,940 29,940 29,940 29,940 Maintenance 461 500 500 500 706,389 770,636 650,745 597,401 Solid Waste Projects Program (5080): Materials and Supplies 3,535 8,802 8,802 0 Services and Charges 100,017 128,940 128,940 0 Capital 510,904 2,356,006 2,356,006 1,849,000 614,456 2,493,748 2,493,748 1,849,000 Total Business -Type Activity $ 9,028,632 $ 1 1,790,836 $ 12,240,146 $ 11,774,000 Total Fund $ 9,028,632 $ 11,790,836 $ 12,240,146 $ 11,774,000 Airport Fund (5550) The Airport Fund provides for the operation and maintenance of the City's municipal airport, Drake Field. The Airport Fund's revenue is generated from rents and leases. In 2013, the Airport Fund is projected to use reserves of $228,000. Airport Fund Revenues For 2013, the Airport Fund sources of funds are budgeted at $955,000. Rents and Leases make up the largest source of revenue (59.1 %). Sources of Funds for 2013 $955,000 Rents and Leases $564,700 Aviation Fuel $129,600 13.6% Other $7,100 0.7% 119 Tax on Fuel 25,600 2.7% lance Total Operating Revenue This chart shows all of the Airport Fund's operating revenues by type. Primary revenues are comprised of Rents and Leases. During the fourth quarter of 2001, the City took over the Fixed Based Operator (FBO) functions and sold aviation fuel as it became a General Aviation airport. The selling of fuel continued until the last part of 2005 when the City contracted the operation of the FBO to an external company. Currently the Airport Fund's major source of revenue is through the rental of corporate and private T -Hangars. A portion of the airport terminal building is leased to a fueling and line services operation, two pilot training schools, the U.S. Post Office, a florist, office space to a wildlife biologist, and an advertising firm. ti $1.40 O 0 $1.20 $1.00 $0.80 $0.60 $0.40 $0.20 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year ® Rents & Leases ®Aviation Fuel E7 Other D Fees O Sales Tax on Fuel 120 City of Fayetteville, Arkansas 2013 Operating Budget Airport Fund (5550) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Sales Tax - County $ 14,264 $ 12,700 $ 11,200 $ 12,300 Sales Tax - City 15,470 13,300 13,300 13,300 Rents & Leases 527,962 511,800 534,720 564,700 Aviation Fuel 114,865 119,500 143,400 129,600 Other 11,769 11,900 7,400 2,900 Interest Income 5,098 7,800 3,180 4,200 Total Revenues 689,428 677,000 713,200 727,000 Expenses: Airport Administration 503,163 543,607 528,965 523,019 Airport Maintenance 188,990 215,467 210,131 229,394 Airport Capital Expense 68,779 83,267 83,267 0 General Fund Loan Interest 20,007 6,523 6,523 6,057 General Fund Loan Principal 342,584 15,530 15,530 15,530 Transfer to Other Funds 0 11,380 11,380 0 Transfer to Shop 0 1,100 1,100 0 Total Expenses 1,123,523 876,874 856,896 774,000 Budget Gain / (Loss) Before Capital $ (434,095) $ (199,874) $ (143,696) $_(47,000) Non -Operating Revenues / (Expenses): Intergovernmental (Grants) 779,188 176,916 405,500 0 Transfer from Replacement 15,857 0 0 0 Capital Expenditures (594,839) (450,663) (450,663) (181,000) Total Capital Revenues / (Expenses) 200,206 (273,747) (45,163) (181,000) Budget Gain / (Loss) $ (233,889) $ (473,621) $ (188,859) $ (228,000) Total Budget $ 1,718,362 $ 1,327,537 $ 1,307,559 $ 955,000 WAI City of Fayetteville, Arkansas 2013 Operating Budget Airport Fund (5550) Beginning Total Net Assets Budget Gain / (Loss) Plus: Gain Capital Expenditures Plus: Bond Principal Payment Less: Depreciation Expense Ending Total Net Assets Actual Budgeted 2011 2012 ESTIMATED CHANGE IN NET ASSETS Estimated Budgeted 2012 2013 $ 15,036,327 $ 14,314,269 $ 14,314,269 $ 12,706,862 (233,889) (473,621) (188,859) (228,000) 594,839 450,663 450,663 181,000 342,584 15,530 15,530 15,530 (1,425,592) (1,884,741) (1,884,741) (1,695,553) $ 14,314,269 $ 12,422,100 $ 12,706,862 $ 10,979,839 NET ASSET ANALYSIS Net Investment in Capital Assets $ 13,852,019 $ 12,417,941 $ 12,417,941 $ 10,903,388 * Unrestricted 462,250 4,159 288,921 76,451 Ending Total Net Assets $ 14,314,269 $ 12,422,100 $ 12,706,862 $ 10,979,839 * Adjustment is due to a long term interfund loan from the General Fund recorded as a liability but not deducted from net investments in capital assets. 122 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Airport Fund (5550) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Business -Type Activity: Airport Administration Program (3940): Personnel Services $ 231,594 $ 235,952 $ 221,310 $ 228,791 Materials and Supplies 83,736 99,472 99,472 98,424 Services and Charges 177,262 197,588 197,588 185,235 Motorpool Charges 2,656 2,680 2,680 2,654 Cost allocation 7,915 7,915 7,915 7,915 Debt Service 362,591 22,053 22,053 21,587 865,754 565,660 551,018 544,606 Airport Maintenance Program (3950): Personnel Services 99,870 105,721 101,199 107,485 Materials and Supplies 10,838 14,887 14,887 17,619 Services and Charges 2,996 5,130 5,130 6,596 Motorpool Charges 27,149 30,465 29,651 31,637 Maintenance 48,137 59,264 59,264 66,057 Operating Transfers 0 1,100 1,100 0 188,990 216,567 211,231 229,394 Airport Capital Expense Program (3960): Services and Charges 36,085 83,267 83,267 0 Maintenance (512) 0 0 0 Capital 628,045 450,663 450,663 181,000 Operating Transfers 0 11,380 11,380 0 663,618 545,310 545,310 181,000 Total Business -Type Activity $ 1,718,362 $ 1,327,537 $ 1,307,559 $ 955,000 Total Fund $ 1,718,362 $ 1,307,559 $ 1,327,537 $ 955,000 Ip Pacae Left Blank Intentional 124 Town Center and Parking Facility Fund (5600) The Town Center and Parking Facility Fund accounts for the Town Center Building and the associated special obligation debt. Budgeted revenues and expenditures are balanced for 2013 on a cash basis. 125 City of Fayetteville, Arkansas 2013 Operating Budget Town Center Fund (5600) Actual Budgeted Estimated Budgeted 91111 ')012 2012 2013 Revenues: L.onlriounon trom Advertising/Promotion $ 682,161 $ Interest Income 29 Total Revenues AR? 1911 695,200 $ 695,200 $ 697,000 0 0 0 Expenses: Audit Expense 600 688 688 757 Principal Payment 575,000 590,000 590,000 610,000 Interest Expense 106,188 83,648 83,648 64,768 Town Center Expense 1,922 1,923 1,923 2,534 Paying Agent Fees 18,940 18,941 18,941 18,941 Total Expenses 702,650 695,200 695,200 697,000 Budget Gain / (Loss) $ (20,460) $ 0 $ 0 $ 0 Total Budget $ 702,650 $ 695,200 $ 695,200 $ 697,000 ESTIMATED CHANGE IN NET ASSETS Beginning Total Net Assets $ 3,058,784 $ 2,670,564 $ 2,670,564 $ 2,302,804 Budget Gain / (Loss) (20,460) 0 0 0 Less: Depreciation Expense (367,760) (367,760) (367,760) (367,760) Ending Total Net Assets $ 2,670,564 $ 2,302,804 $ 2,302,804 $ 1,935,044 126 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Town Center Fund (5600) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Citywide Activity: Town Center Expense Program (9600): Services and Charges $ 2,522 $ 2,61 1 $ 2,611 $ 3,291 Debt Service 700,128 692,589 692,589 693,709 702,650 695,200 695,200 697,000 Total Citywide Activity $ 702,650 $ 695,200 $ 695,200 $ 697,000 Total Fund $ 702,650 $ 695,200 $ 695,200 $ 697,000 127 Page Left Blank Intentiona 128 Police Pension Fund (6800) The Police Pension Fund accounts for the accumulation of resources for the pension benefit payments to qualified police personnel. Operations of this fund are controlled by the Police Pension Board. Revenues include insurance premium tax distributions, a special City property tax, and special fees and forfeitures. City of Fayetteville, Arkansas 2013 Operating Budget Police Pension Fund (6800) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Property Taxes $ 498,381 $ 469,000 $ 490,000 $ 496,000 State Insurance Turnback 269,745 283,000 233,900 251,900 Fines & Forfeitures 126,045 126,000 122,000 122,000 Investment Earnings 192,469 177,400 205,200 205,100 Gain/Loss on Sale of Investments 209,001 0 89,000 0 Gain/Loss in Fair Value of Investments (687) 0 0 0 Other 5,131 0 5,000 0 Total Revenues 1,300,085 1,055,400 1,145,100 1,075,000 Expenses: Audit Expense 3,500 3,600 3,600 4,000 Professional Services 0 623 623 0 Bank Service Charges 171 210 210 224 Benefit Payments 1,627,027 1,628,258 1,628,258 1,624,576 Materials and Supplies 0 309 309 200 Total Expenses 1,630,698 1,633,000 1,633,000 1,629,000 Budget Gain / (Loss) $ (330,613) $ (577,600) $ (487,900) $ (554,000) Total Budget $ 1,630,698 $ 1,633,000 $ 1,633,000 $ 1,629,000 ESTIMATED CHANGE IN NET ASSETS Beginning Total Net Assets $ 8,555,897 $ 8,225,284 $ 8,225,284 $ 7,737,384 Budget Gain / (Loss) (330,613) (577,600) (487,900) (554,000) Ending Total Net Assets $ 8,225,284 $ 7,647,684 $ 7,737,384 $ 7,183,384 130 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Police Pension Fund (6800) Actual Budgeted Estimated Budgeted Citywide Activity: Police Pension Expense Program (9800): Materials and Supplies $ 0 $ 309 $ 309 $ 200 Services and Charges 1,630,698 1,632,691 1,632,691 1,628,800 1,630, 698 1,633,000 1,633,000 1,629,000 Total Citywide Activity $ 1,630,698 $ 1,633,000 $ 1,633,000 $ 1,629,000 Total Fund $ 1,630,698 $ 1,633,000 $ 1,633,000 $ 1,629,000 131 (Page Left Blank Intentionally) 132 Fire Pension Fund (6810) The Fire Pension Fund accounts for the accumulation of resources for the pension benefit payments to qualified fire personnel. Operations of this fund are controlled by the Fire Pension Board. Revenues include the proceeds of a special City property tax and insurance premium tax distributions from the State. 133 City of Fayetteville, Arkansas 2013 Operating Budget Fire Pension Fund (6810) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Property Taxes $ 498,381 $ 469,000 $ 490,000 $ 496,000 State Insurance Turnback 161,155 161,600 265,200 278,400 Investment Earnings 110,157 96,900 147,800 125,600 Gain/Loss on Sale of Investments 144,724 0 90,700 0 Gain/Loss in Fair Value of Investments (6,698) 0 0 0 Other 34 0 0 0 Total Revenues 907,753 727,500 993,700 900,000 Expenses: Audit Expense 3,500 3,600 3,600 3,900 Professional Services 95 2,900 2,900 3,000 Bank Service Charges 132 250 250 140 Benefit Payments 1,462,291 1,462,794 1,462,794 1,460,777 Materials and Supplies 0 106 106 43 Services and Charges 225 350 350 140 Total Expenses 1,466,243 1,470,000 1,470,000 1,468,000 Budget Gain / (Loss) $ (558,490) $ (742,500) $ (476,300) $ (568,000) Total Budget $ 1,466,243 $ 1,470,000 $ 1,470,000 $ 1,468,000 ESTIMATED CHANGE IN NET ASSETS Beginning Total Net Assets $ 5,573,909 $ 5,015,419 $ 5,015,419 $ 4,539,1 19 Budget Gain / (Loss) (558,490) (742,500) (476,300) (568,000) Ending Total Net Assets $ 5,015,419 $ 4,272,919 $ 4,539,1 19 $ 3,971,1 19 134 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Fire Pension Fund (6810) Actual Budgeted Estimated Budgeted 7ntt Oni1) nnin nnin Citywide Activity: Fire Pension Expense Program (9810): Materials and Supplies $ 0 $ 106 $ 106 $ 43 Services and Charges 1,466,243 1,469,894 1,469,894 1,467,957 Total Citywide Activity $ 1,466,243 $ 1,470,000 $ 1,470,000 $ 1,468,000 Total Fund $ 1,466,243 $ 1,470,000 $ 1,470,000 $ 1,468,000 135 Paqe Left Blank Intentional 136 Shop Fund (9700) The Shop Fund is an internal service fund that provides for all the acquisition and maintenance of equipment and vehicles utilized by the City's operating divisions. The Shop Fund's source of revenue is from charges to other City operating funds based on equipment and vehicle usage. Increases in 2013 operational costs can be attributed to additional parts and supply purchases, fuel expense, insurance, and contract services for repairs that cannot be performed by staff. These operational increases are a result of fleet expansions and increased equipment usage. On a cash basis, expenditures will exceed revenues after capital for 2013. The shortfall will be covered by cash reserves which were accumulated in the prior periods for this purpose. Shop Fund Revenues Shop Charges (Replacement Charges, Motorpool Charges, Shop Overhead Charges, Shop Overhead Insurance Charges, and Fuel Charges) as a whole make up 99% of total Shop Fund revenue and are budgeted in 2013 at $7,573,400. Replacement Charges ($3,841,200) is the amount Fleet Operations collects to purchase replacement vehicles and equipment. Replacement charges for General Fund vehicles were waived in 2010 to reduce expenses due to the economy. However, necessary replacement charges were put back in the General Fund Budget for 2011. Motorpool Charges ($1,580,700), Shop Overhead Charges ($426,600) and Shop Overhead Insurance Charges ($128,300) are the monthly fees user divisions pay to the Shop Fund for the on -going maintenance that is provided for the life of the vehicles and equipment. Fuel Charges ($1,579,100) is the revenue received from charging out the cost of gasoline to the user divisions. Shop Charges $8.00 C O $7.00 $6.00 $5.00 $4.00 $3.00 $2.00 $1.00 $0.00 02 03 04 05 06 07 08 09 10 11 12 Est 13 Bud Year 137 City of Fayetteville, Arkansas 2013 Operating Budget Shop Fund (9700) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Revenues: Maintenance Charges $ 24,134 $ 27,600 $ 26,600 $ 17,500 Fuel Charges 1,472,180 1,806,000 1,579,000 1,579,100 Replacement Charges 2,780,156 3,373,000 3,146,400 3,841,200 Motor Pool Charges 1,450,045 1,595,500 1,575,500 1,580,700 Shop Overhead Charges 548,718 495,400 494,100 426,600 Shop Overhead Insurance 111,043 112,000 112,800 128,300 Shop Rental Pool Revenue 13,514 11,400 17,200 10,300 Other 45,984 0 22,700 0 Interest Income 41,654 69,500 63,200 63,300 Total Revenues 6,487,428 7,490,400 7,037,500 7,647,000 Expenses: Vehicle Maintenance 2,617,122 2,891,878 2,773,910 2,863,910 Gasoline/Diesel Expense 1,436,965 1,757,290 1,757,290 1,757,090 Transfer to Other Funds 0 11,198 0 0 Transfer to Water & Sewer 0 80,832 80,800 0 Total Expenses 4,054,087 4,741,198 4,612,000 4,621,000 Budget Gain / (Loss) Before Capital $ 2,433,341 $ 2,749,202 $ 2,425,500 $ 3,026,000 Non -Operating Revenues / (Expenses): Gain/Loss Sale of Assets 214,929 0 89,500 0 Transfer from General 3,000 29,570 29,600 0 Transfer from Replacement 37,434 6,000 6,000 0 Transfer from Impact Fee Fund 0 50,430 50,400 0 Transfer from WWT Improvements 238,368 0 0 0 Transfer from Water & Sewer 0 156,644 156,600 0 Transfer from Airport 0 0 1,100 0 Capital Expenditures (1,885,347) (6,439,482) (6,439,000) (3,865,000) Total Capital Revenues / (Expenses) (1,391,616) (6,196,838) (6,105,800) (3,865,000) Budget Gain / (Loss) Total Budget $ 1,041,725 $ (3,447,636) $ (3,680,300) $ (839,000) $ 5,939,434 $ 11,180,680 $ 11,051,000 $ 8,486,000 City of Fayetteville, Arkansas 2013 Operating Budget Shop Fund (9700) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 ESTIMATED CHANGE IN NET ASSETS Beginning Total Net Assets $ 16,967,298 $ 17,472,670 $ 17,472,670 $ 17,069,992 Budget Gain / (Loss) 1,041,725 (3,447,636) (3,680,300) (839,000) Plus: Gain Capital Expenditures 1,885,347 6,439,482 6,439,000 3,865,000 Less: Depreciation Expense (2,421,700) (3,161,378) (3,161,378) (3,259,133) Ending Total Net Assets $ 17,472,670 $ 17,303,138 $ 17,069,992 $ 16,836,859 NET ASSET ANALYSIS Net Investment in Capital Assets $ 8,096,930 $ 11,088,776 $ 10,855,630 $ 10,720,252 Restricted for Prepaids 79,069 79,069 79,069 79,069 Unrestricted 9,296,671 6,135,293 6,135,293 6,037,538 Ending Total Net Assets $ 17,472,670 $ 17,303,138 $ 17,069,992 $ 16,836,859 139 City of Fayetteville, Arkansas 2013 Operating Budget (Category Summary) Shop Fund (9700) Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 Transportation Services Activity: Vehicle Maintenance Program (1910): Personnel Services $ 1,033,515 $ 1,1 12,922 $ 1,013,940 $ 1,095,078 Materials and Supplies 2,220,364 2,576,725 2,576,725 2,586,805 Services and Charges 369,358 510,946 492,045 497,610 Motorpool Charges 61,945 62,404 62,401 56,615 Cost allocation 318,468 318,468 318,468 318,468 Maintenance 49,825 65,535 65,535 66,424 Operating Transfers 0 11,198 0 0 4,053,475 4,658,198 ' 4,529,1 14 4,621,000 Capital Expense Program (1920): Services and Charges 612 2,168 2,086 0 Capital 1,885,347 6,439,482 6,439,000 3,865,000 Operating Transfers 0 80,832 80,800 0 1,885,959 6,522,482 6,521,886 3,865,000 Total Transportation Services Activity Total Fund $ 5,939,434 $ 11,180,680 $ 1 1,051,000 $ 8,486,000 $ 5,939,434 $ 11,180,680 $ 11,051,000 $ 8,486,000 140 CITY OF FAYETTEVILLE, ARKANSAS PERSONNEL SECTION The Personnel Summary table below shows the authorized the full-time equivalent (FTE) listing for the City of Fayetteville by Organization Chart. The total amount shown includes 22.6 frozen FTE's. The subsequent pages provide a summary and a detail listing of personnel by Funding Source and Activity. In addition a schedule of frozen positions is listed that includes a 2013 Projected Savings. Total Full -Time Equivalent (FTE's): 757.00 City Attorney (3.00) City Prosecutor (9.00) Police Department (147.60) Dispatch (24.00) Internal Audit Department (1.00) Utilities Department (4.50) Parking/Telecom (9.00) Water/Sewer Operations (72.00) City Clerk/Treasurer (5.50) Chief of Staff (2.25) Communications & Marketing Department (3.00) 3overnment Channel (4.25) Development Services Department (2.00) Animal Services (15.80) Building Safety (10.00) City Planning (8.00) Community Services (10.50) Engineering (21.00) 141 Mayor (2.00) Human Resources (5.00) Parks & Recreation Department (54.35) Finance & Internal Services Department (1.25) Accounting & Audit (11.50) •Billing & Collections (17.00) Budget & Research (4.00) Building Maintenance (14.50) Information Technology (13.00) Purchasing (3.50) District Judge (1.00) District Court (10.50) Fire Department (114.00) Sustainability & Strategic Planning Department (3.00) Transportation Services Department (68.50) Aviation (6.00) Fleet Operations (18.50) Solid Waste & Recycling (57.00) City of Fayetteville, Arkansas Personnel Summary by Funding Source Full -Time Equivalent Basis Budgeted 2013 Fund Budgeted Budgeted 2011 2012 Active Frozen Total 1010 - General 470.55 470.60 449.00 21.60 470.60 2100 - Street 68.50 68.50 68.50 - 68.50 2130 -Parking 6.00 7.00 7.00 - 7.00 2180 - Community Development Block Grant 4.55 4.55 4.55 - 4.55 2250 - Parks Development 27.40 27.35 27.35 - 27.35 2930 - Drug Law Enforcement 4.00 4.00 4.00 - 4.00 5400 - Water & Sewer 93.50 93.50 93.50 - 93.50 5500 - Solid Waste 57.00 57.00 57.00 - 57.00 5550 - Airport 6.00 6.00 5.00 1.00 6.00 9700 -Shop 18.50 18.50 18.50 - 18.50 Total 756.00 757.00 734.40 22.60 757.00 Sho 18.: 2.4`. Airport 6.00 0.8% Solid 57 7. Wa Full -Time Equivalent Basis by Fund (757 FTE's) Enforcement [-arks Development 4.00 27.35 0.5% 3.6% 142 General 470.60 A2_3% Street 68.50 9.0% ng D 7 inity :nt Block Grant 4.55 0.6% City of Fayetteville, Arkansas Personnel History by Funding Source (2004-2013) Fund 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 General 442.43 464.63 474.63 483.13 482.33 482.33 480.13 470.55 470.60 470.60 Street 56.50 68.50 68.50 68.50 68.50 68.50 68.50 68.50 68.50 68.50 Parking - - - 1.00 1.00 1.00 3.50 6.00 7.00 7.00 Community Development Block Grant 3.95 4.75 4.75 4.75 4.75 4.75 4.55 4.55 4.55 4.55 Parks Development 18.05 19.05 19.05 20.05 21.85 21.85 21.85 27.40 27.35 27.35 Drug Law Enforcement 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 Water & Sewer 87.00 90.50 90.50 91.50 91.50 93.50 93.50 93.50 93.50 93.50 Solid Waste 49.60 50.60 51.60 55.60 55.60 56.60 56.00 57.00 57.00 57.00 Airport 8.50 8.50 5.50 5.50 5.50 5.50 6.00 6.00 6.00 6.00 Shop 17.00 17.50 17.50 18.50 18.50 18.50 18.50 18.50 18.50 18.50 Total 687.03 728.03 736.03 752.53 753.53 756.53 756.53 756.00 757.00 757.00 Change from Prior Year 27.50 41.00 8.00 16.50 1.00 3.00 - (0.53) 1.00 - 143 City of Fayetteville, Arkansas Personnel Summary by Funding Source / Program Budgeted 2013 Fund / Program Budgeted Budgeted 2011 2012 Active Frozen Total 1010 - GENERAL FUND: 0150- Mayor's Administration 2.00 2.00 2.00 - 2.00 0210 -City Attorney 3.00 3.00 3.00 - 3.00 0310 - City Prosecutor 9.00 9.00 9.00 - 9.00 0400 - District Judge 1.00 1.00 1.00 - 1.00 0550 - Communications 3.00 3.00 3.00 - 3.00 0600 - Government Channel 4.25 4.25 4.25 - 4.25 0700 - Chief of Staff 1.25 1.25 1.25 - 1.25 0750 - Internal Consulting 1.00 1.00 - 1.00 1.00 1100 - Finance Director 1.25 1.25 1.25 - 1.25 1210- Human Resource Operations 5.00 5.00 4.00 1.00 5.00 1310 - Accounting & Audit 11.50 11.50 11.00 0.50 11.50 1330 - Budget & Research 4.00 4.00 3.00 1.00 4.00 1360 - Internal Audit 1.00 1.00 1.00 - 1.00 1380 - Utilities Management 2.00 2.00 2.00 - 2.00 1410 - General Maintenance 8.00 8.00 7.50 0.50 8.00 1420 - Janitorial 6.50 6.50 6.50 - 6.50 1510- City Clerk/Treasurer 5.50 5.50 5.50 - 5.50 1610 -Purchasing 3.50 3.50 3.50 - 3.50 1710 - Information Technology 13.00 13.00 13.00 - 13.00 2010 - Criminal Cases 5.50 5.50 5.50 - 5.50 2020 - Probation & Fine Collection 1.00 0.50 0.50 - 0.50 2030 - Small Claims & Civil Cases 4.00 4.50 4.50 - 4.50 2600 - Central Dispatch 24.00 24.00 23.00 1.00 24.00 2710 - Animal Patrol/Emergency Response 5.50 5.50 5.50 - 5.50 2720 - Animal Shelter 8.30 8.30 8.30 - 8.30 2730 - Veterinarian/Clinic 2.00 2.00 2.00 - 2.00 2900 - Police Support Services 35.00 35.00 32.00 3.00 35.00 2940 - Police Patrol 108.60 108.60 104.50 4.10 108.60 3010 - Fire Prevention 5.00 5.00 5.00 - 5.00 3020 - Fire Operations 107.00 107.00 105.00 2.00 107.00 3030 - Fire Training 2.00 2.00 2.00 - 2.00 5210 - Swimming Pool 4.36 4.36 4.36 - 4.36 5220 - Parks Administration/Recreation Programs 8.40 8.40 7.40 - 7.40 5250 - Lake Maintenance 0.15 0.15 0.15 - 0.15 5260 - Parks Maintenance 11.04 11.09 10.09 2.00 12.09 5280 - Yvonne Richardson Community Center 3.00 3.00 3.00 - 3.00 6200 - Development Services Director 2.00 2.00 2.00 - 2.00 6210 - Engineering Design Services 6.00 6.00 5.00 1.00 6.00 6220- Engineering Operations & Administration 7.00 7.00 7.00 - 7.00 6230 - Engineering Land Acquisition 3.00 3.00 3.00 - 3.00 6240 - Engineering Public Construction 5.00 5.00 5.00 - 5.00 6300 - City Planning 8.00 8.00 6.00 2.00 8.00 6310 - Sustainability & Strategic Planning 3.00 3.00 3.00 - 3.00 6400 - Building Safety 10.00 10.00 7.50 2.50 10.00 6420 - Code Compliance 5.95 5.95 5.95 - 5.95 470.55 470.60 449.00 21.60 470.60 144 Fund / Program 2100 - STREET FUND: City of Fayetteville, Arkansas Personnel Summary by Funding Source / Program Budgeted 2013 Budgeted Budgeted 2011 2012 Active Frozen Total 4100 - Operations & Administration 8.00 8.00 8.00 - 8.00 4110 -Right-of-way Maintenance 4.00 4.50 4.50 - 4.50 4120 - Street Maintenance 24.50 23.00 23.00 - 23.00 4130 - Drainage Maintenance 7.00 7.50 7.50 - 7.50 5315 - Traffic Engineering & Planning 6.00 6.00 6.00 - 6.00 5520 - Street & Trail Construction 9.00 9.50 9.50 - 9.50 5530 -Sidewalks 10.00 10.00 10.00 - 10.00 68.50 68.50 68.50 - 68.50 2130 - PARKING FUND: 9130 - Off -Street Parking 3.00 4.50 4.50 - 4.50 9131 - Entertainment District Parking 3.00 2.50 2.50 - 2.50 6.00 7.00 7.00 - 7.00 2180 - COMMUNITY DEVELOPMENT BLOCK GRANT FUND: 4930 - Administration & Planning 1.75 1.75 1.75 - 1.75 4940 - Housing Services 1.80 1.80 1.80 - 1.80 4945 - Redevelopment 1.00 1.00 1.00 - 1.00 4.55 4.55 4.55 - 4.55 2250 - PARKS DEVELOPMENT FUND: 9250 - Parks Development 27.40 27.35 27.35 - 27.35 27.40 27.35 27.35 - 27.35 2930 - DRUG LAW ENFORCEMENT FUND: 2960 - Drug Enforcement 4.00 4.00 4.00 - 4.00 4.00 4.00 4.00 - 4.00 5400 - WATER & SEWER FUND: 1800 - Utilities Director 1.50 1.50 1.50 - 1.50 1810 - Billing & Collections 17.00 17.00 17.00 - 17.00 1820 - Meter Reading 15.00 15.00 15.00 - 15.00 1830 - Meter Maintenance & Backflow Prevention 6.00 6.00 6.00 - 6.00 4000 - Operations & Administration 10.00 10.00 11.00 - 11.00 4020 - Utilities Project Management 4.00 4.00 3.00 - 3.00 4310 - Water Distribution Maintenance 14.35 14.35 15.35 - 15.35 4330 - Water Storage & Pump Maintenance 2.00 2.00 2.00 - 2.00 4410 - Sewer Mains Maintenance 20.35 20.35 19.35 - 19.35 5620 - Water & Sewer Connections 3.30 3.30 3.30 - 3.30 93.50 93.50 93.50 - 93.50 Fund / Program 5500 - SOLID WASTE FUND: City of Fayetteville, Arkansas Personnel Summary by Funding Source / Program Budgeted 2013 Budgeted Budgeted 2011 2012 Active Frozen Total 5000 - Operations & Administration 6.25 4.25 5.00 - 5.00 5010 - Commercial Collections 11.70 10.40 11.00 - 11.00 5020 - Residential Collections 10.05 10.75 10.00 - 10.00 5030 - Commercial Drop Box Collections 2.70 2.70 2.50 - 2.50 5040 - Transfer Station 1.00 2.75 2.50 - 2.50 5060 - Recycling 17.70 17.60 20.00 - 20.00 5070 - Composting 7.60 8.55 6.00 - 6.00 57.00 57.00 57.00 - 57.00 5550 - AIRPORT FUND: 3940 - Airport Administration 3.00 3.00 3.00 - 3.00 3950 - Airport Maintenance 3.00 3.00 2.00 1.00 3.00 6.00 6.00 5.00 1.00 6.00 9700 - SHOP FUND: 1910 - Vehicle Maintenance 18.50 18.50 18.50 - 18.50 18.50 18.50 18.50 - 18.50 Total Positions - Citywide 756.00 757.00 734.40 22.60 757.00 146 City of Fayetteville, Arkansas Personnel Variation Summary (2013) Fund / Division Additions / (Deletions) No changes occurred 147 City of Fayetteville, Arkansas Personnel Summary by Activity Full -Time Equivalent Basis Budgeted 2013 Activity Budgeted Budgeted 2011 2012 Active Frozen Total General Government & Miscellaneous 41.50 41.50 40.50 1.00 41.50 Finance & Internal Services 69.75 69.75 66.75 3.00 69.75 Police 171.60 171.60 163.50 8.10 171.60 Fire 114.00 114.00 112.00 2.00 114.00 Community Planning & Engineering 70.30 70.30 64.80 5.50 70.30 Transportation Services 95.00 96.00 96.00 - 96.00 Parks & Recreation 54.35 54.35 52.35 2.00 54.35 Business -Type 139.50 139.50 138.50 1.00 139.50 Total 756.00 757.00 734.40 22.60 757.00 General Government Miscellaneou: 41.50 5.4% Business -Type 139.50 18.4% Parks & Recr 54.35 7.2% Full -Time Equivalent Basis by Activity (757 FTE's) Finance & Internal Services Police 171.60 69.75 C) 'rn 777% Services 9.3% 96.00 12.7% 148 Fire 114.00 15.1% y 9 City of Fayetteville, Arkansas Personnel History by Activity (2004-2013) Activity 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 General Government 41.65 40.40 40.40 41.40 41.40 41.40 41.50 41.50 41.50 41.50 Finance & Internal Services 62.50 69.75 69.75 70.25 70.25 70.25 70.25 69.75 69.75 69.75 Police 157.63 167.63 170.63 171.63 171.63 171.63 171.63 171.60 171.60 171.60 Fire 101.00 104.00 109.00 113.00 114.00 114.00 114.00 114.00 114.00 114.00 Community Planning/Engineering 64.80 69.80 71.80 73.30 73.30 73.30 70.30 70.30 70.30 70.30 Transportation Services 79.00 91.50 91.50 93.50 93.50 93.50 96.00 95.00 96.00 96.00 Parks & Recreation 49.85 51.85 51.85 53.35 53.35 53.35 54.35 54.35 54.35 54.35 Business -Type 130.60 133.10 131.10 136.10 136.10 139.10 138.50 139.50 139.50 139.50 Total 687.03 728.03 736.03 752.53 753.53 756.53 756.53 756.00 757.00 757.00 Change from Prior Year 27.50 41.00 8.00 16.50 1.00 3.00 - (0.531 1.00 - 149 City of Fayetteville, Arkansas Personnel Summary by Activity & Division Budgeted 2013 Activity / Division / Title Budgeted Budgeted 2011 2012 Active Frozen Total GENERAL GOVERNMENT & MISCELLANEOUS ACTIVITY: Mayors Administration Division 2.00 2.00 2.00 - 2.00 City Attorney Division 3.00 3.00 3.00 - 3.00 City Prosecutor Division 9.00 9.00 9.00 - 9.00 City Clerk/Treasurer Division 5.50 5.50 5.50 - 5.50 Fayetteville District Court Division 11.5O 11.50 11.50 - 11.50 Chief of Staff Division 1.25 1.25 1.25 - 1.25 Internal Audit Division 1.00 1.00 1.00 - 1.00 Internal Consulting Division 1.00 1.00 - 1.00 1.00 Communications & Marketing Division 3.00 3.00 3.00 - 3.00 Government Channel Division 4.25 4.25 4.25 - 4.25 Total General Government & Miscellaneous Activity 41.50 41.50 40.50 1.00 41.50 FINANCE & INTERNAL SERVICES ACTIVITY: Finance Director Division 1.25 1.25 1.25 - 1.25 Accounting & Audit Division 11.50 11.50 11.00 0.50 11.50 Billing & Collections Division 17.00 17.00 17.00 - 17.00 Building Maintenance Division 14.50 14.50 14.00 0.50 14.50 Budget & Research Division 4.00 4.00 3.00 1.00 4.00 Human Resources Division 5.00 5.00 4.00 1.00 5.00 Information Technology Division 13.00 13.00 13.00 - 13.00 Purchasing Division 3.50 3.50 3.50 - 3.50 Total Finance & Internal Services Activity 69.75 69.75 66.75 3.00 69.75 POLICE ACTIVITY: Police Division 147.60 147.60 140.50 7.10 147.60 Central Dispatch Division 24.00 24.00 23.00 1.00 24.00 Total Police Activity 171.60 171.60 163.50 8.10 171.60 FIRE ACTIVITY: Fire Division 114.00 114.00 112.00 2.00 114.00 Total Fire Activity 114.00 114.00 112.00 2.00 114.00 COMMUNITY PLANNING & ENGINEERING ACTIVITY: Sustainability & Strategic Planning Division 3.00 3.00 3.00 - 3.00 Development Services Division 2.00 2.00 2.00 - 2.00 Engineering Division 21.00 21.00 20.00 1.00 21.00 City Planning Division 8.00 8.00 6.00 2.00 8.00 Community Services Division 10.50 10.50 10.50 - 10.50 Building Safety Division 10.00 10.00 7.50 2.50 10.00 Animal Services Division 15.80 15.80 15.80 - 15.80 Total Community Planning & Engineering Activity 70.30 70.30 64.80 5.50 70.30 150 Activity / Division / Title TRANSPORTATION SERVICES ACTIVITY: City of Fayetteville, Arkansas Personnel Summary by Activity & Division Budgeted 2013 Budgeted Budgeted 2011 2012 Active Frozen Total Transportation Services Division 68.50 68.50 68.50 - 68.50 Fleet Operations Division 18.50 18.50 18.50 - 18.50 Parking & Telecommunications Division 8.00 9.00 9.00 - 9.00 Total Transportation Services Activity 95.00 96.00 96.00 - 96.00 PARKS & RECREATION ACTIVITY: Parks & Recreation Division 54.35 54.35 52.35 2.00 54.35 Total Parks & Recreation Activity 54.35 54.35. 52.35 2.00 54.35 BUSINESS -TYPE ACTIVITY: Utilities Director Division 4.50 4.50 4.50 - 4.50 Water & Sewer Maintenance Division 72.00 72.00 72.00 - 72.00 Solid Waste & Recycling Division 57.00 57.00 57.00 - 57.00 Aviation Division 6.00 6.00 5.00 1.00 6.00 Total Business -Type Activity 139.50 139.50 138.50 1.00 139.50 Total Positions - Citywide 756.00 757.00 734.40 22.60 757.00 151 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Activity / Division / Title Budgeted Budgeted 2011 2012 Active Frozen Total GENERAL GOVERNMENT & MISCELLANEOUS ACTIVITY: Mayors Administration Division: Mayor 1.00 1.00 1.00 - 1.00 Mayor's Office Administrator 1.00 1.00 1.00 - 1.00 2.00 2.00 2.00 - 2.00 City Attorney Division: City Attorney 1.00 1.00 1.00 - 1.00 Assistant City Attorney 1.00 1.00 1.00 - 1.00 Senior Secretary - City Attorney 1.00 1.00 1.00 - 1.00 3.00 3.00 3.00 - 3.00 City Prosecutor Division: Prosecuting Attorney 1.00 1.00 1.00 - 1.00 Deputy City Prosecutor 1.00 1.00 1.00 - 1.00 Office Manager/Hot Check Administrator 1.00 1.00 1.00 - 1.00 Senior Legal Assistant 2.00 2.00 2.00 - 2.00 Legal Assistant 1.00 1.00 1.00 - 1.00 Hot Check Program Clerk 1.00 1.00 1.00 - 1.00 Secretary - Prosecutor's Office 1.00 1.00 1.00 - 1.00 Law Clerk 0.50 0.50 0.50 - 0.50 Clerk 0.50 0.50 0.50 - 0.50 9.00 9.00 9.00 - 9.00 City Clerk/Treasurer Division: City Clerk/Treasurer 1.00 1.00 1.00 - 1.00 Document Management Manager 1.00 1.00 1.00 - 1.00 Deputy City Clerk 1.50 1.00 1.00 - 1.00 Senior Clerk Codifier - 1.00 1.00 - 1.00 Senior Secretary - City Clerk 1.00 1.00 1.00 - 1.00 Office & Records Assistant 0.50 - - - - Intern I 0.50 0.50 0.50 - 0.50 5.50 5.50 5.50 - 5.50 Fayetteville District Court Division District Judge 1.00 1.00 1.00 - 1.00 District Court Administrator 1.00 1.00 1.00 - 1.00 Court Services Officer 1.00 0.50 0.50 - 0.50 Lead Court Clerk 1.00 1.00 1.00 - 1.00 Deputy Court Clerk II 2.00 2.00 2.00 - 2.00 Deputy Court Clerk I 5.50 6.00 6.00 - 6.00 11.50 11.50 11.50 - 11.50 152 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division / Title 2011 2012 Active Frozen Total Chief of Staff Division: Chief of Staff 1.00 1.00 1.00 - 1.00 Administrative Assistant - Mayor's Office 0.25 0.25 0.25 - 0.25 1.25 1.25 1.25 - 1.25 Internal Audit Division: Internal Auditor 1.00 1.00 1.00 - 1.00 1.00 1.00 1.00 - 1.00 Internal Consulting Division: Director Internal Consulting 1.00 1.00 - 1.00 1.00 1.00 1.00 - 1.00 1.00 Communications & Marketing Division: Communications & Marketing Director 1.00 1.00 1.00 - 1.00 Community Outreach Coordinator 1.00 1.00 1.00 - 1.00 Administrative Assistant - Mayor's Office 1.00 1.00 1.00 - 1.00 3.00 3.00 3.00 - 3.00 Government Channel Division: Television Center Manager 1.00 1.00 1.00 - 1.00 Video Production Technician 3.25 2.25 2.25 - 2.25 Programming Coordinator - 1.00 1.00 - 1.00 4.25 4.25 4.25 - 4.25 Total General Government & Miscellaneous Activity 41.50 41.50 40.50 1.00 41.50 153 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Activity / Division / Title Budgeted Budgeted 2011 2012 Active Frozen Total FINANCE & INTERNAL SERVICES ACTIVITY: Finance Director Division: Finance Director 1.00 1.00 1.00 - 1.00 Administrative Assistant - Mayor's Office 0.25 0.25 0.25 - 0.25 1.25 1.25 1.25 - 1.25 Accounting & Audit Division: Accounting Director 1.00 1.00 1.00 - 1.00 Accounting Manager - Investment & Cash 1.00 1.00 1.00 - 1.00 Accounting Manager - Payroll & Pension 1.00 1.00 1.00 - 1.00 Contract/Grant Financial Accountant 1.00 1.00 1.00 - 1.00 Fixed Assets/Investment Coordinator 1.00 1.00 1.00 - 1.00 Accountant - Revenues 1.00 1.00 1.00 - 1.00 Accountant - Payroll 1.00 1.00 1.00 - 1.00 Accounting Clerk - Payables 1.00 1.00 1.00 - 1.00 Accounting Clerk - Receivable 1.00 1.00 1.00 - 1.00 Accounting Clerk - Cash 1.00 1.00 1.00 - 1.00 Accounting Clerk - Data Entry 1.00 1.00 1.00 - 1.00 Intern I 0.50 0.50 - 0.50 0.50 11.50 11.50 11.00 0.50 11.50 Billing & Collections Division: Billing & Collections Manager 1.00 1.00 1.00 - 1.00 Financial Analyst - Business Office 1.00 1.00 1.00 - 1.00 Billing & Collections Coordinator 1.00 1.00 1.00 - 1.00 Senior Customer Service Representative 4.00 4.00 4.00 - 4.00 Customer Service Representative I 10.00 10.00 10.00 - 10.00 17.00 17.00 17.00 - 17.00 Building Maintenance Division: Building Maintenance Project Manager 1.00 1.00 0.50 0.50 1.00 Building Maintenance Superintendent 1.00 1.00 1.00 - 1.00 HVAC Technician 1.00 1.00 1.00 - 1.00 Crew Leader - Building Services - 1.00 1.00 - 1.00 Crew Leader - Building Maintenance 2.00 1.00 1.00 - 1.00 Maintenance Worker II - Building Maintenance 1.00 1.00 1.00 - 1.00 Senior Secretary - Building Maintenance 1.00 1.00 1.00 - 1.00 Maintenance Worker I - Building Maintenance 1.00 1.00 1.00 - 1.00 Custodian 6.50 6.50 6.50 - 6.50 14.50 14.50 14.00 0.50 14.50 154 Activity / Division / Title Budget & Research Division: Budget Director Senior Research Analyst Financial Analyst - Budget Budget Analyst City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted 2011 2012 Active Frozen Total 1.00 1.00 1.00 - 1.00 1.00 1.00 1.00 - 1.00 1.00 1.00 1.00 - 1.00 1.00 1.00 - 1.00 1.00 Human Resources Division: Human Resources Director 1.00 1.00 1.00 - 1.00 Senior Human Resources Officer 1.00 1.00 1.00 - 1.00 Benefits Administrator 2.00 2.00 1.00 1.00 2.00 Human Resources Assistant 1.00 1.00 1.00 - 1.00 5.00 5.00 4.00 1.00 5.00 Information Technology Division: Information Technologies Director 1.00 1.00 1.00 - 1.00 Senior Programmer/Analyst 1.00 1.00 1.00 - 1.00 Network Engineer 1.00 1.00 1.00 - 1.00 GIS Coordinator 1.00 1.00 1.00 - 1.00 Systems Administrator 1.00 1.00 1.00 - 1.00 Database Administrator 1.00 1.00 1.00 - 1.00 Systems Analyst 1.00 1.00 1.00 - 1.00 Business Systems Analyst 1.00 1.00 1.00 - 1.00 GIS Technician 4.00 4.00 4.00 - 4.00 Help Desk Analyst 1.00 1.00 1.00 - 1.00 13.00 13.00 13.00 - 13.00 Purchasing Division: Purchasing Manager 1.00 1.00 1.00 - 1.00 Purchasing Agent 1.00 1.00 1.00 - 1.00 Purchasing Technician 1.00 1.00 1.00 - 1.00 Intern I 0.50 0.50 0.50 - 0.50 3.50 3.50 3.50 - 3.50 Total Finance & Internal Services Activity 69.75 69.75 66.75 3.00 69.75 155 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Activity / Division / Title Budgeted Budgeted 2011 2012 Active Frozen Total POLICE ACTIVITY: Police Division: Police Chief 1.00 1.00 1.00 - 1.00 Deputy Chief of Police 2.00 2.00 1.00 1.00 2.00 Police Captain 3.00 3.00 3.00 - 3.00 Support Services Manager 1.00 1.00 1.00 - 1.00 IT Manager - Police 1.00 1.00 1.00 - 1.00 Police Lieutenant 5.00 5.00 5.00 - 5.00 Systems Analyst 1.00 1.00 1.00 - 1.00 Police Sergeant 15.00 15.00 15.00 - 15.00 Police Corporal 53.00 58.00 55.00 - 55.00 Property/Evidence Manager 1.00 1.00 1.00 - 1.00 Senior Crime Scene Technician 1.00 1.00 1.00 - 1.00 Records Coordinator 1.00 1.00 1.00 - 1.00 Police Officer 42.00 37.00 36.00 4.00 40.00 Financial Coordinator - Police 1.00 1.00 1.00 - 1.00 Senior Police Support Specialist 2.00 2.00 2.00 - 2.00 Police Support Specialist 7.50 7.50 7.50 - 7.50 Senior Secretary - Police 5.00 5.00 4.00 1.00 5.00 Police Clerk 2.00 2.00 2.00 - 2.00 Transcriptionist 1.50 1.50 1.00 0.50 1.50 Police Clerk Imaging 0.50 0.50 0.50 - 0.50 Park Patrol 1.10 1.10 0.50 0.60 1.10 147.60 147.60 140.50 7.10 147.60 Central Dispatch Division: Dispatch Manager 1.00 1.00 1.00 - 1.00 Assistant Dispatch Manager 1.00 1.00 1.00 - 1.00 Dispatch Shift Supervisor 2.00 2.00 2.00 - 2.00 Dispatch Trainer 2.00 2.00 2.00 - 2.00 Dispatcher III 7.00 9.00 9.00 - 9.00 Dispatcher II 2.00 2.00 1.00 - 1.00 Dispatcher I 9.00 7.00 7.00 1.00 8.00 24.00 24.00 23.00 1.00 24.00 Total Police Activity 171.60 171.60 163.50 8.10 171.60 156 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division / Title 2011 2012 Active Frozen Total FIRE ACTIVITY: Fire Division: Fire Chief 1.00 1.00 1.00 - 1.00 Assistant Fire Chief 2.00 2.00 2.00 - 2.00 Fire Battalion Chief 3.00 3.00 3.00 - 3.00 Fire Battalion Chief - Fire Marshall 1.00 1.00 1.00 - 1.00 Fire Battalion Chief - Training Officer 1.00 1.00 1.00 - 1.00 IT Analyst - Fire 1.00 1.00 1.00 - 1.00 Fire Captain 30.00 30.00 30.00 - 30.00 Fire Captain - Assistant Fire Marshall 3.00 3.00 3.00 - 3.00 Fire Captain - Training Officer 1.00 1.00 1.00 - 1.00 Fire Captain- Safety Officer 1.00 1.00 - 1.00 1.00 Financial Analyst - Fire 1.00 1.00 1.00 - 1.00 Driver/Operator/Firefighter 27.00 27.00 27.00 - 27.00 Firefighter 40.00 40.00 39.00 1.00 40.00 Life Safety Education Specialist 1.00 1.00 1.00 - 1.00 Secretary - Fire 1.00 1.00 1.00 - 1.00 114.00 114.00 112.00 2.00 114.00 Total Fire Activity 114.00 114.00 112.00 2.00 114.00 1671 Activity / Division / Title City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted 2011 2012 Active Frozen Total COMMUNITY PLANNING & ENGINEERING ACTIVITY: Sustainability & Strategic Planning Division: Director Sustainability & Strategic Planning 1.00 1.00 1.00 - 1.00 Planner - Long Range 1.00 1.00 1.00 - 1.00 Designer & Project Coordinator 1.00 1.00 1.00 - 1.00 3.00 3.00 3.00 - 3.00 Development Services Division: Development Services Director 1.00 1.00 1.00 - 1.00 Office Manager - Development Services 1.00 1.00 1.00 - 1.00 2.00 2.00 2.00 - 2.00 Engineering Division: City Engineer 1.00 1.00 1.00 - 1.00 Assistant City Engineer 2.00 2.00 1.00 1.00 2.00 Staff Engineer 3.00 3.00 3.00 - 3.00 Review Engineer 1.00 1.00 1.00 - 1.00 Trails Coordinator 1.00 1.00 1.00 - 1.00 Surveyor 1.00 1.00 1.00 - 1.00 Land Agent II 1.00 1.00 1.00 - 1.00 Public Works Inspection Manager - 1.00 1.00 - 1.00 Land Agent I 2.00 2.00 2.00 - 2.00 CAD Drafter 2.00 2.00 2.00 - 2.00 PW Projects Inspector 5.00 4.00 4.00 - 4.00 Land Survey Technician 1.00 1.00 1.00 - 1.00 Engineering Services Coordinator 1.00 1.00 1.00 - 1.00 21.00 21.00 20.00 1.00 21.00 City Planning Division: Director of Current Planning 1.00 1.00 - 1.00 1.00 Senior Planner - Current Planning 1.00 1.00 1.00 - 1.00 Planner - Current Planning 2.00 2.00 2.00 - 2.00 Planning Technician - Current Planning 1.00 1.00 1.00 - 1.00 Residential Permits Coordinator - 1.00 1.00 - 1.00 Senior Planning Clerk 1.00 - - - - Development Coordinator 1.00 1.00 1.00 - 1.00 Permit Clerk 1.00 1.00 - 1.00 1.00 8.00 8.00 6.00 2.00 8.00 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division / Title 2011 2012 Active Frozen Total Community Services Division: Community Services Director 1.00 1.00 1.00 - 1.00 Code Compliance Administrator 1.00 1.00 1.00 - 1.00 Community Services Project Coordinator 1.00 1.00 1.00 - 1.00 Housing Manager 1.00 1.00 1.00 - 1.00 Code Compliance Officer 5.00 5.00 4.00 - 4.00 Administrative Assistant - Community Resources 1.00 1.00 1.00 - 1.00 Redevelopment Officer - - 1.00 - 1.00 Intern II 0.50 0.50 0.50 - 0.50 10.50 10.50 10.50 - 10.50 Building Safety Division: Building Official - Safety 1.00 1.00 - 1.00 1.00 Building Official- Plans Examiner 1.00 1.00 1.00 - 1.00 Inspector - Commercial & Residential 3.00 2.00 2.00 - 2.00 Inspector - Residential 2.00 3.00 3.00 - 3.00 Commercial Permits Coordinator - 1.00 1.00 - 1.00 Permit Technician 1.00 - - - - Inspections Clerk 1.50 1.50 - 1.50 1.50 Clerk Typist 0.50 0.50 0.50 - 0.50 10.00 10.00 7.50 2.50 10.00 Animal Services Division: Veterinarian 1.00 1.00 1.00 - 1.00 Animal Services Superintendent 1.00 1.00 1.00 - 1.00 Animal Services Program Manager 1.00 1.00 1.00 - 1.00 Animal Services Program Administrator 1.00 1.00 1.00 - 1.00 Animal Services Officer 3.00 3.00 3.00 - 3.00 Veterinary Assistant 1.00 1.00 1.00 - 1.00 Secretary - Animal Services 1.00 1.00 1.00 - 1.00 Shelter Attendant 6.80 6.80 6.80 - 6.80 15.80 15.80 15.80 - 15.80 Total Community Planning & Engineering Activity 70.30 70.30 64.80 5.50 70.30 159 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division / Title 2011 2012 Active Frozen Total TRANSPORTATION SERVICES ACTIVITY: Transportation Services Division: Transportation Services Director 1.00 1.00 1.00 - 1.00 Management Accounting Coordinator 1.00 1.00 1.00 - 1.00 Assistant Transportation Manager 2.00 2.00 2.00 - 2.00 Traffic Control Supervisor 1.00 1.00 1.00 - 1.00 Senior Field Operations Supervisor 2.00 2.00 2.00 - 2.00 Field Operations Supervisor - Transportation 2.00 2.00 2.00 - 2.00 Financial Coordinator - Operations 1.00 1.00 1.00 - 1.00 Traffic Signal Technician 3.00 3.00 3.00 - 3.00 Office Manager - Transportation 1.00 1.00 1.00 - 1.00 Crew Leader - Transportation 2.00 1.00 1.00 - 1.00 Maintenance Worker - Transportation Facility 1.00 1.00 1.00 - 1.00 Traffic Technician 2.00 2.00 2.00 - 2.00 Construction Lead Worker 6.00 7.00 7.00 - 7.00 Operations Assistant 2.00 2.00 2.00 - 2.00 Maintenance Worker IV - Construction 3.00 3.00 3.00 - 3.00 Maintenance Worker IV - Asphalt 5.00 7.00 6.00 - 6.00 Maintenance Worker IV - Concrete 2.00 1.00 1.00 - 1.00 Maintenance Worker IV - Drainage 3.00 3.00 3.00 - 3.00 Maintenance Worker IV - Right of Way 1.00 1.00 1.00 - 1.00 Maintenance Worker IV - Trails 2.00 1.00 1.00 - 1.00 Maintenance Worker III - Transportation 20.00 20.00 21.00 - 21.00 Clerk Typist 1.00 - - - - Maintenance Worker I - Transportation 4.50 5.50 5.50 - 5.50 68.50 68.50 68.50 - 68.50 Fleet Operations Division: Fleet Operations Superintendent 1.00 1.00 1.00 - 1.00 Fleet Services Support Manager 1.00 1.00 1.00 - 1.00 Fleet Operations Supervisor 1.00 1.00 1.00 - 1.00 Lead Equipment Mechanic 2.00 2.00 2.00 - 2.00 Fleet Warranty/Materials Coordinator 1.00 1.00 1.00 - 1.00 Equipment Mechanic III 3.00 3.00 3.00 - 3.00 Automotive Parts Specialist 1.00 1.00 1.00 - 1.00 Equipment Mechanic II 5.00 4.00 3.00 - 3.00 Equipment Mechanic I 2.00 3.00 4.00 - 4.00 Fleet Operations Clerk 1.00 1.00 1.00 - 1.00 Equipment Maintenance Worker 0.50 0.50 0.50 - 0.50 18.50 18.50 18.50 - 18.50 160 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division /Title 2011 2012 Active Frozen Total Parking & Telecommunications Division: Parking & Telecommunications Manager 1.00 1.00 1.00 - 1.00 Telecommunications Engineer 1.00 1.00 1.00 - 1.00 Field Operations Supervisor - Parking 1.00 1.00 1.00 - 1.00 Account Clerk - Parking 1.00 2.00 2.00 - 2.00 Parking Enforcement Officer 4.00 4.00 4.00 - 4.00 8.00 9.00 9.00 - 9.00 Total Transportation Services Activity 95.00 96.00 - 96.00 96.00 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division / Title 2011 2012 Active Frozen Total PARKS & RECREATION ACTIVITY: Parks & Recreation Division: Parks & Recreation Director 1.00 1.00 1.00 - 1.00 Parks Maintenance Superintendent 1.00 1.00 1.00 - 1.00 Recreation Superintendent 1.00 1.00 1.00 - 1.00 Park Planning Superintendent 1.00 1.00 1.00 - 1.00 Park Planner II 1.00 1.00 1.00 - 1.00 Parks Maintenance Supervisor 1.00 1.00 1.00 - 1.00 Horticulturist 2.00 2.00 2.00 - 2.00 Park Planner 1.00 1.00 1.00 - 1.00 Urban Forester 1.00 1.00 1.00 - 1.00 Financial Coordinator - Parks & Recreation 1.00 1.00 1.00 - 1.00 YRCC Director 1.00 1.00 1.00 - 1.00 Crew Leader - Athletic Fields 1.00 1.00 1.00 - 1.00 Recreation Programs Manager - Soccer 1.00 2.00 1.00 - 1.00 Maintenance Worker - Parks Facilities 2.00 2.00 2.00 - 2.00 Crew Leader - Forestry Services 1.00 1.00 1.00 - 1.00 Crew Leader - Grounds Maintenance 1.00 1.00 1.00 - 1.00 Crew Leader - Turf 1.00 1.00 1.00 - 1.00 Recreation Programs Manager - Softball 2.00 1.00 1.00 - 1.00 Recreation Programs Manager Youth Softball - - 1.00 - 1.00 Recreations Coordinator 1.00 1.00 1.00 - 1.00 Horticultural Assistant II 3.00 3.00 3.00 - 3.00 Senior Secretary - Parks & Recreation 1.00 1.00 1.00 - 1.00 Maintenance Worker IV - Parks 5.00 5.00 4.00 1.00 5.00 Recreation Programs Assistant II 0.20 0.60 0.60 - 0.60 Maintenance Worker III - Parks 4.00 4.00 4.00 - 4.00 Urban Forestry Secretary - 1.00 1.00 - 1.00 Secretary - Parks & Recreation 1.00 - - - - Maintenance Worker II - Parks 7.00 7.00 6.00 1.00 7.00 Maintenance Worker I - Parks 4.24 4.24 4.24 - 4.24 Urban Forestry Intern 0.50 0.50 0.50 - 0.50 Pool Manager 0.35 0.35 0.35 - 0.35 Assistant Pool Manager 0.40 0.40 0.40 - 0.40 YRCC Recreation Assistant 0.80 0.40 0.40 - 0.40 Camp Counselor 1.00 1.00 1.00 - 1.00 Site Supervisor 0.65 0.65 0.65 - 0.65 Lifeguard 3.01 3.01 2.88 - 2.88 Cashier 0.20 0.20 0.33 - 0.33 54.35 54.35 52.35 2.00 54.35 Total Parks & Recreation Activity 'F.,.] 54.35 54.35 52.35 2.00 54.35 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division / Title 2011 2012 Active Frozen Total BUSINESS -TYPE ACTIVITY: Utilities Director Division: Utilities Director 1.00 1.00 1.00 - 1.00 Construction & Contract Manager 1.00 1.00 1.00 - 1.00 Staff Engineer- Water & Wastewater 1.00 1.00 1.00 - 1.00 Administrative Assistant - Mayor's Office 0.50 0.50 0.50 - 0.50 Utilities Project Coordinator 1.00 1.00 1.00 - 1.00 4.50 4.50 4.50 - 4.50 Water & Sewer Maintenance Division: Water/Sewer Operations Manager . 1.00 1.00 1.00 - 1.00 Assistant Water/Sewer Operations Manager - 1.00 1.00 - 1.00 Capital Projects & Contracts Engineer 1.00 - - - - Water Services Supervisor 1.00 1.00 1.00 - 1.00 Water Services Technical Supervisor 1.00 1.00 1.00 - 1.00 Field Superintendent - Water & Wastewater 2.00 2.00 2.00 - 2.00 Field Service Representative 3.00 3.00 3.00 - 3.00 Lead Warehouse Attendant 1.00 1.00 1.00 - 1.00 Pump & Tank Technician 3.00 3.00 3.00 - 3.00 GIS Technician - Water/Sewer 1.00 1.00 1.00 - 1.00 Meter Operations Assistant 1.00 1.00 1.00 - 1.00 Backflow Prevention Operations Assistant 1.00 1.00 1.00 - 1.00 Crew Leader - Water/License 12.00 12.00 12.00 - 12.00 Office Manager - Water/Sewer 1.00 1.00 1.00 - 1.00 Backflow Prevention Technician 1.00 1.00 1.00 - 1.00 Water Field Service Representative 3.00 3.00 3.00 - 3.00 Maintenance Worker IV - Water/Sewer License 4.00 5.00 4.00 - 4.00 Meter Maintenance Technician 3.00 3.00 3.00 - 3.00 Operations Clerk - Water/Sewer 2.00 2.00 2.00 - 2.00 Warehouse Attendant - Water/Sewer 2.00 2.00 2.00 - 2.00 Meter Reader 9.00 9.00 9.00 - 9.00 Maintenance Worker IV - Water/Sewer No License 4.00 4.00 4.00 - 4.00 Maintenance Worker III - Water/Sewer 15.00 14.00 15.00 - 15.00 72.00 72.00 72.00 - 72.00 163 City of Fayetteville, Arkansas Personnel Detail by Activity & Division Budgeted 2013 Budgeted Budgeted Activity / Division / Title 2011 2012 Active Frozen Total Solid Waste & Recycling Division: Solid Waste Director 1.00 1.00 1.00 - 1.00 Solid Waste Operations Supervisor 1.00 1.00 1.00 - 1.00 Waste Reduction Coordinator 1.00 1.00 1.00 - 1.00 Solid Waste Commercial Representative 1.00 1.00 1.00 - 1.00 Office Manager - Solid Waste 1.00 1.00 1.00 - 1.00 Crew Leader II SW - 1.00 1.00 - 1.00 Crew Leader - Solid Waste 4.00 2.00 2.00 - 2.00 Relief Driver 3.00 4.00 4.00 - 4.00 Recycling Attendant - 1.00 1.00 - 1.00 Route Driver 40.00 40.00 40.00 - 40.00 Maintenance Worker III - Solid Waste 1.00 1.00 1.00 - 1.00 Secretary - Solid Waste 2.00 2.00 2.00 - 2.00 Scale House Attendant 1.00 1.00 1.00 - 1.00 Custodian - Solid Waste 1.00 - - - - 57.00 57.00 57.00 - 57.00 Aviation Division: Airport Director 1.00 1.00 1.00 - 1.00 Financial Coordinator - Airport 1.00 1.00 1.00 - 1.00 Lead Maintenance Worker 1.00 1.00 1.00 - 1.00 Maintenance Worker III - Airport 1.00 1.00 1.00 - 1.00 Administrative Assistant - Airport 1.00 1.00 1.00 - 1.00 Maintenance Worker II - Airport 1.00 1.00 - 1.00 1.00 6.00 6.00 5.00 1.00 6.00 Total Business -Type Activity 139.50 139.50 138.50 1.00 139.50 Total Positions - Citywide 756.00 757.00 734.40 22.60 757.00 City of Fayetteville, Arkansas Frozen Personnel Positions by Activity & Division Fund / Division Frozen Frozen Frozen Savings 2011 2012 2013 2013 1010 - GENERAL FUND: GENERAL GOVERNMENT & MISCELLANEOUS ACTIVITY: Fayetteville District Court Division: Deputy Court Clerk I 1.00 1.00 - $ - Internal Consulting Division: Director Internal Consulting - - 1.00 81,434 FINANCE & INTERNAL SERVICES ACTIVITY: Accounting & Audit Division: Intern I 0.50 0.50 0.50 1 1,668 Building Maintenance Division: Building Maintenance Project Manager 0.50 0.50 0.50 32,675 Budget & Research Division: Budget Analyst 1.00 1.00 1.00 54,221 Human Resources Division: Benefits Administrator 1.00 1.00 1.00 52,003 Information Technology Division: Database Administrator 1.00 1.00 - - POLICE ACTIVITY: Police Division: Deputy Chief of Police 1.00 1.00 1.00 77,504 Police Officer 4.00 4.00 4.00 224,465 Senior Secretary - Police 1.00 1.00 1.00 42,347 Transcriptionist 0.50 0.50 0.50 14,890 Park Patrol 0.60 0.60 0.60 12,091 Central Dispatch Division: Dispatcher I 1.00 1.00 1.00 47,833 FIRE ACTIVITY: Fire Division: Fire Captain - Safety Officer 1.00 1.00 1.00 85,243 Financial Analyst - Fire 0.50 0.50 - Firefighter 1.00 1.00 1.00 51,791 COMMUNITY PLANNING & ENGINEERING ACTIVITY: Engineering Division: Assistant City Engineer 1.00 1.00 1.00 95,664 City Planning Division: Director of Current Planning 1.00 1.00 1.00 95,664 Permit Clerk 1.00 1.00 1.00 39,101 Building Safety Division: Building Official - Safety 1.00 1.00 1.00 80,021 Inspections Clerk 1.50 1.50 1.50 59,292 165 City of Fayetteville, Arkansas Frozen Personnel Positions by Activity & Division Frozen Frozen Frozen Savings Fund/Division 2011 2012 2013 2013 PARKS & RECREATION ACTIVITY: Parks & Recreation Division: Maintenance Worker IV - Parks 1.00 1.00 1.00 42,347 Maintenance Worker II - Parks 1.00 1.00 1.00 38,350 Total Frozen Positions - General Fund 23.10 23.10 21.60 $ 1,238,604 5550 - AIRPORT FUND: BUSINESS -TYPE ACTIVITY: Aviation Division: Maintenance Worker II - Airport 1.00 1.00 1.00 $ 38,459 Total Frozen Positions - Airport Fund 1.00 1.00 1.00 $ 38,459 Total Frozen Positions - Citywide 24.10 24.10 22.60 $ 1,277,063 166 CITY OF FAYETTEVILLE, ARKANSAS CAPITAL IMPROVEMENTS PROGRAM Since 1988, the City of Fayetteville has produced a five year Capital Improvements Program (CIP). The CIP examines the infrastructure and capital needs of the City for the next five years. The CIP is reviewed and updated biennially to reflect the changing needs of the community and changes in available funding for financing capital projects. The CIP should be considered as a financial planning tool that lists the City's capital improvement projects and schedules the projects for funding and implementation. The CIP should also be considered one of the primary policy making instruments utilized by the Mayor and City Council. The City's practice has been to adopt the CIP for the forthcoming five year period and then incorporate the projects for the following two years into the next two budget processes. The subsequent pages provide a summary of the 2013 Capital Improvements Program listed by improvement area, followed by a listing of the capital projects which the City plans for 2013. 2013 Capital Improvements (By Funding Source) 2013 Projects 2013 Adopted Project Description 2013-2017 CIP Budget Parking Fund: Parking Lot Improvements & Overlays $ 30,000 $ Parking Revenue PCI Compliance Upgrade 52,000 82,000 Parks Development Fund: Community Park Improvements 700,000 Regional Park Development 563,000 1,263,000 Impact Fee Fund: Fire Impact Improvements 74,000 Police Impact Improvements 86,000 Wastewater Impact Improvements 400,000 Water Impact Improvements 500,000 1,060,000 Sales Tax Capital Improvements Fund: AccessFayetteville Technical Improvements 25,000 Accounting Image & Check Scanners 5,000 Audit Expense 7,000 Backup Storage Appliance 75,000 Building Improvements 119,000 30,000 52,000 82,000 700,000 563,000 1,263,000 74,000 86,000 400,000 500,000 1,060,000 25,000 5,000 8,000 75,000 119,000 167 2013 Capital Improvements (By Funding Source) 2013 Projects 2013 Adopted Project Description 2013-2017 CIP Budget City Hall Audio -Visual Renovation 70,000 70,000 Citywide Building Insurance Appraisal Study 35,000 35,000 Data Center Relocation 220,000 220,000 Document Management 15,000 15,000 Enterprise Data Warehouse System 97,000 97,000 ERP Upgrade/Replacement 0 1,222,000 Exchange/Office Upgrade 220,000 220,000 Fire Apparatus Purchases 426,000 426,000 Fire Facility Maintenance 125,000 125,000 Fire Information Technology Updates 40,000 40,000 Forestry, Safety & ADA Compliance 31,000 31,000 Geographic Information System (GIS) 50,000 50,000 In -House Pavement Improvements 1,842,000 1,842,000 Legislative Management/Agenda Routing 33,000 33,000 Library Computer Replacements 30,000 30,000 Library Material Purchases 375,000 375,000 Lights of the Ozarks 23,000 23,000 Local Area Network (LAN) Upgrade 140,000 140,000 Microcomputer Replacements 68,000 68,000 Native Grasses Program 10,000 10,000 Other Drainage Improvements 200,000 200,000 Police Building Improvements 25,000 25,000 Police Bulletproof Vests 10,000 10,000 Police Equipment Replacement 20,000 20,000 Police Patrol Vehicle Electronic Upgrades 160,000 160,000 Police Specialized Equipment 55,000 55,000 Police Technology Improvements 40,000 40,000 Police Unmarked Vehicles 57,000 57,000 Regional Wayfinding Signage Program 0 125,000 Remote Meeting Recording 50,000 50,000 Sidewalk Improvements 115,000 115,000 Storage Area Network (SAN) 40,000 40,000 Stormwater Quality Management/Nutrient Reduction 160,000 160,000 Street ROW / Intersection / Cost Shares 100,000 100,000 Telecommunication Systems Upgrades 5,000 5,000 Television Center Digital Conversion 75,000 75,000 Television Center Equipment 50,000 50,000 Trail Development 1,548,000 1,548,000 Tree Escrow 114,000 1 14,000 6,905,000 8,253,000 2013 Capital Improvements (By Funding Source) 2013 Projects 2013 Adopted Project Description 2013-2017 CIP Budget Water & Sewer Fund: Building Improvements - WWTP Business Office Improvements Business Office Printer Replacements Business Office Technology Improvements Disinfection System Replacement - WWTP Irrigation Reels - WWTP Phosphorus Standards - WWTP Plant Pumps & Equipment - WWTP Sanitary Sewer Rehabilitation Upgrade/Replace Lift Stations - WWTP W/S Relocations for Street Bond Projects Wastewater Treatment/Water Quality Imps. - WWTP Water Meters Water System Rehabilitation & Replacement Water/Sewer Equipment Expansions Water/Sewer Impact Fee Cost Sharing Solid Waste Fund: Compost Site Slab Expansion North / Central Recycling Drop Off Facility Recycling Baler Recycling Improvements Solid Waste Compactors Solid Waste Office & Transfer Station Expansion Solid Waste MadVac Airport Fund: Airport ARFF Personal Protective Gear Airport Ground Service Equipment Acquisiton Airport Roof Replacements Airport Self Serve Station Upgrade Airport Sprinkler System Replacement - White Hangar 169 56,000 20,000 30,000 30,000 1,000,000 151,000 50,000 200,000 1,210,000 100,000 500,000 0 313,000 1,010,000 38,000 275,000 4,983,000 416,000 66,000 538,000 28,000 126,000 635,000 40,000 1,849,000 31,000 0 41,000 10,000 65,000 147,000 56,000 20,000 30,000 30,000 1,000,000 151,000 50,000 200,000 1,210,000 100,000 500,000 1,520,000 313,000 1,010,000 38,000 275,000 6,503,000 416,000 66,000 0 28,000 126,000 1,173,000 40,000 1,849,000 31,000 34,000 41,000 10,000 65,000 181,000 2013 Capital Improvements (By Funding Source) 2013 Projects 2013 Adopted Project Description 2013-2017 CIP Budget Shop Fund: Backhoes/Loaders - Replacement 608,000 608,000 Construction Equipment - Replacement 437,000 437,000 Light/Medium Trucks - Replacement 604,000 604,000 Other Vehicles/Equipment - Replacement 969,000 969,000 Police/Passenger Vehicles - Replacement 329,000 329,000 Solid Waste Equipment - Replacement 1,151,000 651,000 Tractors/Mowers - Replacement 267,000 267,000 4,365,000 3,865,000 $ 20,654,000 $ 23,056,000 170 CITY OF FAYETTEVILLE, ARKANSAS CAPITAL IMPROVEMENTS PROGRAM DIRECTIONAL INFORMATION Introduction The Capital Improvements Program (CIP) for the City of Fayetteville examines the infrastructure and capital needs of the City for the next five years. The CIP will be reviewed and updated on an annual basis to reflect the changing needs of the community and changes in available monies for financing capital projects. The City's philosophy concerning the use of the CIP is that it should be considered as a financial planning tool that lists the City's capital improvement projects, places the projects in a priority order, and schedules the projects for funding and implementation. The CIP should be considered as a major policy tool for the Mayor and City Council. Capital Improvement Policy The CIP is approached as a valuable tool to be used in the development of responsible and progressive financial planning. The program is developed in accordance with the financial policies of the City. The policies and the CIP form the basis for making various annual capital budget decisions and support the City's continued commitment to sound, long-range financial planning and direction. The City's official Capital Improvements Policy is as follows: • The City will prepare a biennial update of a five year CIP, which will provide for the orderly maintenance, replacement, and expansion of capital assets. • The CIP will identify long-range capital projects and capital improvements of all types, which will be coordinated with the annual operating budget to maintain full utilization of available sources. When preparing the CIP, the City will seek to identify all viable capital projects and capital improvements required during the subsequent five year period. These projects and improvements will be prioritized by year and by funding source. Every attempt will be made to match projects and improvements with available funding sources. Future operating costs associated with a project or an improvement will also be given consideration in the establishment of priorities. • The City will seek Federal, State, and other funding to assist in financing capital projects and capital improvements. • The City will incorporate the reasonable findings and recommendations of the City's Boards, Commissions, Committees, and Citizens' task forces as they relate to capital projects and improvements. • The City will seek input on the establishment of projects and project priorities from the public by holding hearings. 171 What Projects Are in the CIP Projects and their cumulative component areas totaling $10,000 or more should be included in the CIP. Projects costing less than $10,000 are not considered capital and are normally funded through program operating budgets. Projects that cost between $5,000 and $10,000 are handled through the operating budget. Projects in the CIP can include: • obligations for labor and materials and contractors involved in completing a project • acquisition of land or structures • engineering or architectural services, professional studies, or other administrative costs • expenses for City vehicles and equipment • renovating or expanding City facilities, grounds, or equipment Financing The City finances capital improvements on essentially a pay-as-you-go basis utilizing revenue from the 1% City sales tax originally adopted in 1993, the 1% Parks Development (Hotel, Motel, Restaurant) sales tax adopted in 1996, and operating revenues from the Airport, Shop, Water & Sewer, and Solid Waste funds. The 1% City Sales Tax revenue is divided between General Fund operations and capital. The current split for 2013, which began with the 2008 budget, is 60% for General Fund and 40% for Sales Tax Capital Improvements Fund. Until 2008, the split as established in 2003 was equal. Prior to June 2003, the revenue was divided 75% for Sales Tax Capital Improvements Fund and 25% for General Fund. In addition, long-term debt is considered and utilized only when the City faces a project that is of such importance and sufficient financial magnitude as to warrant a bond issue. The CIP is not a financing document in and of itself. Rather, the CIP is utilized as a planning document that places projects in the annual budget whereby funds are appropriated for them by the City Council. Prior to actual initiation of project work, required contracts are presented to the Mayor or City Council, as appropriate, for final approval of expending funds. 172 Project Cost Determination All projects are costed using a "Basis of Cost Estimate" table that provides the estimated basis used for the requested funds. If two or more basis of cost estimates is used to calculate a funding request, the estimate that represents the majority of the estimated funds is used. Cost of Comparable Facility or Equipment (1 I Rule of Thumb Indicator, Unit Costs II I Cost Estimated by Engineer, Architect, or Vendor 11 I Preliminary Estimate 11 I Ball Park "Guesstimate" II Priority Selection of Projects The CIP will rely on priorities defined by the Mayor, City Council, community, and City staff. As always, criteria such as government imposed mandates, usefulness to the community, and impact on operational expenses will be reviewed in establishing priorities. A priority is assigned to each project by year and by funding source. Projects for which no funding is anticipated to be available will be placed on an "Unfunded Projects List," which will identify the cost of the project. This list identifies the project as being viable, but one for which no funding is presently available. Unfunded projects may be funded if actual revenue is above projected revenue, if costs on funded projects are below budget, or if another funding source is identified. The Parks and Recreation Advisory Board, Airport Board, City Council Street Committee, City Council Water & Sewer Committee, and City Council Equipment Committee meetings all provide committee and public input and guidance regarding parks, streets, bridge and drainage improvements, water and sewer improvements, and equipment purchases planned for the next five years. 173 City of Fayetteville, Arkansas 2013 Capital Projects Summary by Project Category Sales Tax Capital Special Improvement Revenue Enterprise Shop Project Category Fund Funds Funds Fund Total Airport Improvements $ 0 $ 0 $ 181,000 $ 0 $ 181,000 Bridge & Drainage Improvements 360,000 0 0 0 360,000 Fire Improvements 591,000 74,000 0 0 665,000 Information Technology Improvements 2,172,000 0 0 0 2,172,000 Library Improvements 405,000 0 0 0 405,000 Off -Street Parking Improvements 0 82,000 0 0 82,000 Other Capital Improvements 575,000 0 0 0 575,000 Parks & Recreation Improvements 178,000 1,263,000 0 0 1,441,000 Police Improvements 367,000 86,000 0 329,000 782,000 Solid Waste Improvements 0 0 1,849,000 651,000 2,500,000 Street Improvements 100,000 0 0 0 100,000 Trail Improvements 1,548,000 0 0 0 1,548,000 Transportation Improvements 1,957,000 0 0 0 1,957,000 Vehicles & Equipment 0 0 0 2,885,000 2,885,000 Wastewater Treatment Improvements 0 0 3,077,000 0 3,077,000 Water & Sewer Improvements 0 900,000 2,995,000 0 3,895,000 Water & Sewer Services Improvements 0 0 431,000 0 431,000 $ 8,253,000 $ 2,405,000 $ 8,533,000 $ 3,865,000 $ 23,056,000 174 CITY OF FAYETTEVILLE, ARKANSAS CAPITAL IMPROVEMENTS PROGRAM (2013-2017) Comprehensive Detail Budget Projected Projected Projected Projected Total Funding Source / Category / Division 2013 2014 2015 2016 2017 2013-2017 2130 - PARKING: Parking Improvements Parking & Telecommunications (D840) Parking Revenue PCI Compliance Upgrade . $52,000 Parking Lot Improvements and Overlays 30,000 Parking - Total 2250 - PARKS DEVELOPMENT: Parks & Recreation Improvements Parks & Recreation (D460) Community Park Improvements Regional Park Development Parks & Recreation Office Renovation Parks Development - Total 2300 - IMPACT FEE: Fire Improvements Fire Department (D300) Fire Impact Improvements Police Improvements Police (D200) Police Impact Improvements Water & Sewer Improvements Utilities Director (D900) Wastewater Impact Improvements Water Impact Improvements Impact Fee - Total 82,000 $0 $0 $0 $0 $52,000 31,000 32,000 33,000 34,000 160,000 31,000 32,000 33,000 34,000 212,000 82,000 31,000 32,000 33,000 34,000 212,000 700,000 683,000 700,000 673,000 420,000 3,176,000 563,000 0 0 87,000 360,000 1,010,000 0 37,000 40,000 0 0 77,000 1,263,000 720,000 740,000 760,000 780,000 4,263,000 1,263,000 720,000 740,000 760,000 780,000 4,263,000 74,000 77,000 80,000 83,000 86,000 400,000 74,000 77,000 80,000 83,000 86,000 400,000 86,000 88,000 90,000 92,000 94,000 450,000 86,000 88,000 90,000 92,000 94,000 450,000 400,000 400,000 400,000 400,000 400,000 2,000,000 500,000 500,000 500,000 500,000 500,000 2,500,000 900,000 900,000 900,000 900,000 900,000 4,500,000 1,060,000 1,065,000 1,070,000 1,075,000 1,080,000 5,350,000 175 CITY OF FAYETTEVILLE, ARKANSAS CAPITAL IMPROVEMENTS PROGRAM (2013-2017) Comprehensive Detail Funding Source / Category / Division Budget 2013 Projected 2014 Projected 2015 Projected 2016 Projected 2017 Total 2013-2017 4470 - SALES TAX CAPITAL IMPROVEMENTS: Bridge & Drainage Improvements Engineering (D610) Stormwater Quality Management 160,000 160,000 160,000 160,000 160,000 800,000 Other Drainage Improvements 200,000 200,000 200,000 200,000 200,000 1,000,000 360,000 360,000 360,000 360,000 360,000 1,800,000 Fire Improvements Fire Department (D300) Fire Apparatus Purchases 426,000 426,000 466,000 506,000 1,169,000 2,993,000 Fire Facility Maintenance 125,000 125,000 165,000 125,000 125,000 665,000 Fire Information Technology Updates 40,000 139,000 20,000 20,000 20,000 239,000 591,000 690,000 651,000 651,000 1,314,000 3,897,000 Information Technology Improvements Budget & Research (D540) Enterprise Data Warehouse System 97,000 0 0 0 0 97,000 Information Technology (D440) ERP Upgrade/Replacement 1,222,000 0 0 0 0 1,222,000 Exchange/Office Upgrade 220,000 150,000 150,000 0 0 520,000 Local Area Network (LAN) Upgrade 140,000 150,000 135,000 135,000 145,000 705,000 Data Center Relocation 220,000 0 0 0 0 220,000 Backup Storage Appliance 75,000 0 0 0 0 75,000 Microcomputer & Printer Replacements 68,000 90,000 75,000 75,000 75,000 383,000 Storage Area Network (SAN) 40,000 40,000 40,000 120,000 40,000 280,000 Geographic Information System (GIS) 50,000 70,000 75,000 75,000 80,000 350,000 AccessFayetteville Technical Improvements 25,000 100,000 30,000 30,000 30,000 215,000 Document Management 15,000 20,000 15,000 20,000 20,000 90,000 2,172,000 620,000 520,000 455,000 390,000 4,157,000 Library Improvements Library (D150) Library Materials Purchases 375,000 383,000 398,000 406,000 415,000 1,977,000 Library Computer Replacements 30,000 31,000 32,000 33,000 34,000 160,000 405,000 414,000 430,000 439,000 449,000 2,137,000 Other Capital Improvements Accounting & Audit (D510) Accounting Image Scanner & Check Sealer 5,000 5,000 0 0 0 10,000 Audit Expense 8,000 7,000 7,000 7,000 7,000 36,000 Building Maintenance (D530) Building Improvements 119,000 120,000 121,000 123,000 125,000 608,000 City Clerk/Treasurer (D130) Legislative Management/Agenda Routing 33,000 0 0 0 0 33,000 City Clerk Document Mgt Equipment 0 22,000 47,000 10,000 10,000 89,000 City Council iPads 0 7,000 0 0 0 7,000 Development Services (D600) Regional Wayfinding Signage Program 125,000 0 0 0 0 125,000 Government Channel (D710) City Hall Audio -Visual Renovation 70,000 100,000 100,000 0 0 270,000 Television Center Equipment 50,000 50,000 50,000 50,000 50,000 250,000 Television Center Digital Conversion 75,000 75,000 100,000 0 0 250,000 Remote Meeting Recording 50,000 0 0 0 0 50,000 Location Production System 0 65,000 0 0 0 65,000 Digital Signage Implementation 0 0 15,000 15,000 0 30,000 Parking & Telecommunications (D840) Telecommunication Systems Upgrades 5,000 5,000 5,000 5,000 5,000 25,000 Purchasing (D550) Citywide Building Insurance Appraisal Study 35,000 0 0 0 0 35,000 575,000 456,000 445,000 210,000 197,000 1,883,000 176 CITY OF FAYETTEVILLE, ARKANSAS CAPITAL IMPROVEMENTS PROGRAM (2013-2017) Comprehensive Detail Funding Source / Category / Division Budget 2013 Projected 2014 Projected 2015 Projected 2016 Projected 2017 Total 2013-2017 Parks & Recreation Improvements Parks & Recreation (D460) Forestry, Safety and ADA 31,000 31,000 31,000 31,000 31,000 155,000 Native Grasses Program 10,000 10,000 10,000 10,000 10,000 50,000 Lights of the Ozarks 23,000 23,000 23,000 23,000 23,000 115,000 Tree Escrow 114,000 62,000 25,000 11,000 7,000 219,000 Fayetteville Sr. Center Parking Lot/Drainage 0 58,000 0 0 0 58,000 178,000 184,000 89,000 75,000 71,000 597,000 Police Improvements Police (D200) Police Bulletproof Vests 10,000 11,000 42,000 10,000 10,000 83,000 Police Building Improvements 25,000 25,000 25,000 75,000 25,000 175,000 Police Technology Improvements 40,000 70,000 25,000 25,000 25,000 185,000 Police Unmarked Vehicles 57,000 72,000 72,000 72,000 126,000 399,000 Police Equipment Replacement 20,000 20,000 35,000 25,000 10,000 110,000 Police Specialized Equipment 55,000 64,000 32,000 28,000 85,000 264,000 Police Patrol Vehicle Electronic Upgrades 160,000 0 43,000 0 200,000 403,000 Police Network/Server Replacements 0 30,000 75,000 150,000 30,000 285,000 Police K-9 Replacement 0 10,000 10,000 0 0 20,000 Police Weapons Replacement 0 0 0 15,000 40,000 55,000 367,000 302,000 359,000 400,000 551,000 1,979,000 Street Improvements Engineering (D610) Street ROW/Intersection/Cost Sharing 100,000 100,000 100,000 100,000 100,000 500,000 100,000 100,000 100,000 100,000 100,000 500,000 Trail Improvements Transportation Services (D800) Trail Development 1,548,000 1,641,000 1,650,000 1,679,000 1,670,000 8,188,000 1,548,000 1,641,000 1,650,000 1,679,000 1,670,000 8,188,000 Transportation Improvements Transportation Services (D800) In -House Pavement Improvements 1,842,000 1,551,000 1,695,000 1,955,000 1,576,000 8,619,000 Sidewalk Improvements 115,000 520,000 639,000 740,000 525,000 2,539,000 Traffic Signal Improvements 0 150,000 150,000 150,000 150,000 600,000 1,957,000 2,221,000 2,484,000 2,845,000 2,251,000 11,758,000 Sales Tax Capital Improvements - Total 8,253,000 6,988,000 7,088,000 7,214,000 7,353,000 36,896,000 177 CITY OF FAYETTEVILLE, ARKANSAS CAPITAL IMPROVEMENTS PROGRAM (2013-2017) Comprehensive Detail Funding Source / Category / Division 5400 - WATER & SEWER: Wastewater Treatment Improvements Utilities Director (D900) Phosphorus Standards Management Wastewater Treatment Plant (D930) Disinfection System Replacement - W.W.T.P. Wastewater Treatment/Water Quality Irrigation Reels - W.W.T.P. Plant Pumps and Equipment - W.W.T.P. Upgrade/Replace Lift Stations - W.W.T.P. Building Improvements - W.W.T.P. Water & Sewer Improvements Water & Sewer Maintenance (D910) Water System Rehabilitation & Replacement Water/Sewer Relocate for Street Bonds Sanitary Sewer Rehabilitation Water/Sewer Impact Fee Cost Sharing Water/Sewer Equipment Expansions Baxter Water Tanks Painting Water & Sewer Services Improvements Billing & Collections (D520) Business Office Printer Replacements Business Office Improvements Information Technology (D440) Business Office Technology Improvements Water & Sewer Maintenance (D910) Water Meters Backflow Prevention Assemblies Water/Sewer Rate Study Water & Sewer - Total 5500 - SOLID WASTE: Solid Waste Improvements Solid Waste & Recycling (D920) Solid Waste Compactors 126,000 130,000 134,000 138,000 142,000 670,000 Solid Waste Office/Transfer Station Exp 1,173,000 0 0 0 0 1,173,000 Recycling Drop Off Facility (North/Central) 66,000 70,000 0 0 0 136,000 Recycling Improvements 28,000 0 0 0 0 28,000 Solid Waste Compost Site Slab. Expansion 416,000 0 0 0 0 416,000 Solid Waste MadVac 40,000 0 0 0 0 40,000 Recycling. Commercial Expansion (Organics) 0 0 390,000 0 0 390,000 Solid Waste Rate Study 0 0 0 0 133,000 133,000 1,849,000 200,000 524,000 138,000 275,000 2,986,000 Budget Projected Projected Projected Projected Total 2013 2014 2015 2016 2017 2013-2017 50,000 50,000 50,000 50,000 50,000 250,000 1,000,000 0 0 0 0 1,000,000 1,520,000 0 0 0 0 1,520,000 151,000 161,000 0 0 0 312,000 200,000 225,000 225,000 225,000 225,000 1,100,000 100,000 100,000 150,000 150,000 180,000 680,000 56,000 33,000 35,000 35,000 35,000 194,000 3,077,000 569,000 460,000 460,000 490,000 5,056,000 1,010,000 1,150,000 2,095,000 1,825,000 2,055,000 8,135,000 500,000 500,000 500,000 500,000 500,000 2,500,000 1,210,000 1,000,000 1,200,000 1,250,000 1,250,000 5,910,000 275,000 275,000 275,000 275,000 275,000 1,375,000 38,000 220,000 45,000 8,000 0 311,000 0 850,000 0 0 0 850,000 3,033,000 3,995,000 4,115,000 3,858,000 4,080,000 19,081,000 30,000 0 0 0 0 30,000 20,000 20,000 20,000 20,000 20,000 100,000 30,000 15,000 12,000 10,000 10,000 77,000 313,000 311,000 315,000 325,000 325,000 1,589,000 0 0 10,000 10,000 10,000 30,000 0 0 0 170,000 0 170,000 393,000 346,000 357,000 535,000 365,000 1,996,000 6,503,000 4,910,000 4,932,000 4,853,000 4,935,000 26,133,000 Solid Waste - Total 1,849,000 200,000 524,000 138,000 275,000 2,986,000 178 CITY OF FAYETTEVILLE, ARKANSAS CAPITAL IMPROVEMENTS PROGRAM (2013-2017) Comprehensive Detail Budget Projected Projected Projected Projected Total Funding Source / Category / Division 2013 2014 2015 2016 2017 2013-2017 5550 - AIRPORT: Aviation Improvements Aviation (D810) Airport Self Serve Station Upgrade 10,000 0 0 0 0 10,000 Airport Roof Replacements 41,000 60,000 0 0 0 101,000 Airport Ground Service Equipment 34,000 0 0 0 . 0 34,000 Airport Sprinkler Repl - White Hangar 65,000 0 0 0 0 65,000 Airport ARFF Personal Protective Gear 31,000 0 0 0 0 31,000 181,000 60,000 0 0 0 241,000 Airport - Total 181,000 60,000 0 0 0 241,000 9700 - SHOP: Vehicles & Equipment Improvements Fleet Operations (D830) Fleet - Police/Passenger Vehicles 329,000 300,000 336,000 312,000 283,000 1,560,000 Fleet - Solid Waste Vehicles/Equipment 651,000 931,000 598,000 1,345,000 1,085,000 4,610,000 Fleet - Construction Equipment 437,000 0 587,000 123,000 195,000 1,342,000 Fleet - Backhoes/Loaders 608,000 463,000 381,000 182,000 414,000 2,048,000 Fleet - Other Vehicles and Equipment 969,000 205,000 123,000 732,000 608,000 2,637,000 Fleet - Tractor/Mowers 267,000 161,000 179,000 248,000 57,000 912,000 Fleet - Light / Medium Utility Vehicles 604,000 760,000 740,000 762,000 596,000 3,462,000 Fleet - Heavy Utility Vehicles 0 105,000 233,000 825,000 399,000 1,562,000 3,865,000 2,925,000 3,177,000 4,529,000 3,637,000 18,133,000 Shop - Total All Funding Sources - Total 3,865,000 2,925,000 3,177,000 4,529,000 3,637,000 18,133,000 $23,056,000 $16,899,000 $17,563,000 $18,602,000 $18,094,000 $94,214,000 MI City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Parking Fund (2130) Parking Improvements (9130) Parking Lot Improvements and Overlays (06001): The City currently has 12 public parking $ 30,000 lots and one municipal parking deck that are in the Downtown Square and Dickson Street areas. These are all asphalt surface lots that periodically require general maintenance such as crack seal, seal coat, re -striping, pot hole patching, and bumper block replacement. These lots also require a complete asphalt overlay on a less frequent basis. This parking lot maintenance schedule will provide an overlay of one parking lot annually and general maintenance of the other lots as needed. Parking Improvements (9131) Parking Revenue PCI Compliance Upgrade (11009): The PCI DSS is a multifaceted security 52,000 standard that includes requirements for security management, policies, procedures, network architecture, software design and other critical protective measures. This comprehensive standard is intended to help organizations proactively protect customer account data. This upgrade to the existing PCI DSS Compliance is required to align content with the new PCI DSS version 2.0. Total Parking Fund Projects: 82,000 Parks Development Fund (2250) Parks Development Capital (92551 Community Park Improvements (13001): These projects are needed to improve and 700,000 expand facilities in order to meet the current needs of citizens. 2013: Wilson Park Improvements - remodel pool buildings; Walker Park - new concession stand. 2014: Lake Fayetteville Improvements - Lake Fayetteville softball complex drainage and remodel concession, restroom, and playground; Veterans Park - small pavilion and parking improvements. 2015: Gulley Park Improvements - trail and lighting replacement, new pavilion and restrooms, and additional parking. 2016: Wilson Park - remodel rock house, restrooms, and tennis and basketball courts; YRCC Improvements - flooring and outside facilities. 2017: White River Improvements - develop multi -use fields, remodel pump station, add parking lot, pavilion, sidewalks and improve river access. Regional Park Development (02002): This project is for the development of the Regional 563,000 Park which includes constructing soccer, softball and baseballs fields, playgrounds, pavilions, trails, volleyball, basketball and tennis courts, parking, roads, utility infrastructure, gardens, an amphitheater and more. Total Parks Development Fund Projects: 1,263,000 180 City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Impact Fee Fund (2300) Fire Improvements Fire Impact Improvements (07003): The purpose of this project is to accumulate funding for 74,000 fire projects that are associated with the increase in developments throughout the City. The funding for this project comes from impact fees collected from developments. Police Improvements Police Impact Improvements (07001): The purpose of this project is to accumulate funding 86,000 for police projects that are associated with the increase in developments throughout the City. The funding for this project comes from impact fees collected from developments. Water & Sewer Improvements Wastewater Impact Improvements (07004): The purpose of this project is to accumulate 400,000 funding for wastewater projects that are associated with the increase in developments throughout the City. The funding for this project comes from impact fees collected from developments. Water Impact Improvements (07002): The purpose of this project is to accumulate funding 500,000 for water projects that are associated with the increase in developments throughout the City. The funding for this project comes from impact fees collected from developments. Total Impact Fee Fund Projects: 1,060,000 Sales Tax Capital Improvements Fund (4470) Bridae & Drainaae Improvements: Stormwater Quality Management/Nutrient Reduction (02097): This project includes activities 160,000 required by the EPA National Pollutant Discharge Elimination System (NPDES) Phase II Stormwater Permit Regulations as administered by the Arkansas Department of Environmental Quality (ADEQ) and other projects focused on improving water quality. Other Drainage Improvements (02108): This project will fund drainage improvements where 200,000 needed. IE:1I City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Fire Improvements Fire Apparatus Purchases (03019): This project is for the replacement of fire apparatus that 426,000 are past a useful life and to acquire apparatus for expansion stations in the future. Given the number of apparatus in the current fleet, an annual replacement program is necessary to avoid having to purchase multiple apparatus in one fiscal year. Fire Facility Maintenance (02006): This project is for major repairs to existing facilities that 125,000 cannot be funded through the normal operating budget. Repairs include but are not limited to roofing, plumbing or drainage repairs and replacements, remodeling, fencing, driveway replacements, generators, stability assessments, fire escape replacements, and structural repairs to stations. This project allows for necessary repairs to the Fire Department's multiple fire stations, office locations, and facilities. Fire Information Technology Updates (10017): This project will allow for the replacement of 40,000 systems as they become technologically obsolete or inoperable without interrupting daily operations. With the computer devices in front line apparatus as well as all fire stations, staff is currently supporting over 80 computers and mobile devices. Information Technology Improvements AccessFayetteville Technical Improvements (04047): This project provides funding for 25,000 technical improvements, enhancements, third party applications, and maintenance of the AccessFayetteville website. AccessFayetteville utilizes a commercial Content Management System (CMS) that is configured and maintained by staff. The CMS allows end users to add, edit, and approve the content that is displayed on the website. Backup Storage Appliance (13003): Currently, all data is backed up to the existing tape 75,000 library. As the overall size of data increases, the reliability and speed of tape backup becomes problematic. The proposed backup appliance replaces the existing tape library with a more efficient disk -based backup solution allowing for reduced backup windows, longer data retention, and increased data integrity. Data Center Relocation (13006): This project is for the relocation of the City's primary data 220,000 center to the vacant Emergency Response Station(ERS) at Drake Field. For 2012/2013, $120,000 is slated in the Data Center Upgrade project for replacing the AC and UPS units. If funds are spent in the existing facility, it will be a sunk cost as staff will not be able to relocate those items. An additional $50,000 is required for the initial move/installation of all existing equipment into the ERS facility. This is a much better facility in the long term as it is owned by the City, it provides better physical security, and greater disaster recovery options. Document Management (02094): This project is to add additional scanners and licenses as 15,000 new applications are added to the Electronic Document Management System (EDMS). Each year several new applications are added to the system. Users that need to scan and index documents require a license. City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Enterprise Data Warehouse System (13007): This citywide Enterprise Content Management 97,000 (ECM) workflow solution combines the technologies of document imaging, document management and workflow which will enable the City to streamline business processes and accelerate the completion of critical business tasks by automating daily activities. Workflow is an electronic document routing system that enables users to process work more efficiently, faster and more accurately that with traditional paper processing. Workflow streamlines collaboration and accelerates the completion of critical business tasks. This project will involve the acquisition of a Share Point 2010 Enterprise system with Excel Services, Visio Services, Powerpivot server, and Reporting Services (SSRS). ERP Upgrade/Replacement (13008): This project is for upgrading/replacing the current 1,222,000 Financial, HR, and Utility Billing system with a commercial Enterprise Resource Planning (ERP) system. The City's current system was purchased in 1992 and has reached its end of life. Exchange/Office Upgrade (13009): As the City has grown, a current, robust, and 220,000 standardized email platform that can easily integrate with other applications within the City is needed. In addition to an aging email system, the City has several outdated versions of the productivity suite Microsoft Office. This leads to inefficiency and problems across the City regarding version incompatibility and functionality issues. By standardizing on the current version of Microsoft Office, the City will gain efficiency and collaboration through the new software. The City can obtain a Microsoft Enterprise Agreement that will bundle both the email and office upgrades to provide significant discounts and provide software assurance for the next five years. The Microsoft Enterprise Agreement would include upgrading all desktops to the current version of windows, client access licenses for Windows Server, Exchange Server, SharePoint Server, Lync Server, System Center Configuration Manager, and Microsoft Forefront. Geographic Information System (GIS) (02055): Geographic Information Systems (GIS) are 50,000 organized collections of computer hardware, software, geographic data, and personnel designed to efficiently capture, store, update, manipulate, analyze, and display all forms of geographically referenced information. This system provides necessary information for planning, engineering, Hansen, and public utility projects. Additionally, GIS provides applications to assist many other City divisions including Police, Fire, Transportation, and Parks & Recreation. This project is to upgrade and expand the City's base GIS computer hardware, software, and data collection systems to accommodate growth in the system's applications and user base. Local Area Network (LAN) Upgrade (02056): This project is to upgrade and expand the 140,000 City's Local Area Network (LAN)/Network infrastructure. The LAN is used by every division in the City across thirty locations connecting approximately 850 devices. While most components of the LAN are on a three to five year lifecycle, staff must also consider increases in the system's user base and advances in technology that create a need for hardware and operating system upgrades. In the next five years, staff will replace most of the existing servers, switches, and other network hardware. Staff also has plans to add technology that will increase the speed and reliability of the different aspects of the LAN. Specifically, a fault tolerant firewall, redundant and/or battery protected power supplies for all infrastructure equipment, a separate network for backups, network management and testing tools, WAN optimization hardware, additional monitoring and alerting, and tools to help manage and deploy security policy. City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Microcomputer & Printer Replacements (02057): This project is for the replacement of failing 68,000 and outdated personal computers (PCs) and AS/400 system and network printers. In order to make use of increased functionality of new PC software, PC hardware must be continuously evaluated and updated. This project will fund the continued rollout of virtual desktops allowing a standardized desktop to be deployed across the City. The workload for system printers has steadily decreased since the implementation of the Electronic Document Management System. This reduction has extended the life on most of the system printers. The life cycle for the large volume printers has increased from approximately five years to ten years. Storage Area Network (09031): This project provides storage for the City's increasing data 40,000 needs. In order to provide fast, reliable access to data, a centralized enterprise class storage system is required. As the City utilizes technology and applications to increase efficiencies and productivity, more data is produced. This project expands on an existing enterprise class storage system with an expected major upgrade after three (3) years. Library Improvements Library Materials Purchases (02049): This project provides library materials including 375,000 literature, non-fiction, reference resources, media, e -books, and parenting resources. The Fayetteville Public Library seeks to provide a collection of library materials at a level commensurate with benchmark cities and the national average for cities with a population of 50,000 to 99,000 and operating budgets of $3.5-$4.2 million. Over 1.2 million items were borrowed in 2011, a 20.2% increase over 2010. This upward trend is projected to continue, e.g. in the first two months of 2012 there has been 6.3% increase in circulation compared with 2011. Additionally, 031% increase in holds placed demonstrates unfilled demand. Library Computer Replacements (04004): This project provides rotational replacement of 30,000 computer resources. Public access computing is a core service ensuring all residents have computer and high speed connectivity. Uses include job searches; classes; email; research; shopping; writing; school assignments, etc. Usage grew at an average of 3% annually and 43 additional computing stations were added. The library must continually upgrade or replace public computing stations every three years to continue to provide quality access and support. Other Capital Improvements Accounting Image Scanner & Check Sealer (13002): This project is to purchase an image 5,000 scanner for EDMS and to replace the check folder/sealer for the Accounting & Audit Division. Staff currently utilizes the copier for scanning which wears out the document feeder. This scanner will delay the purchase of a new copier. The check folder/sealer is for the City's payroll checks and W2s and will be funded over a two year period. The current sealer was purchased in 2007 and needs to be replaced. Audit Expense: 8,000 Building Improvements (02046): This project consists of the repair and replacement of 119,000 damaged and worn roofs, HVAC systems, and provides for other improvements such as remodels to city owned buildings. City buildings are old and in need of constant repair. City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget City Hall Audio -Visual Renovation (13004): The audio/visual systems in the meeting rooms in 70,000 City Hall need to be replaced. The components and systems are no longer able to meet the needs of many people who do presentations in the meeting rooms. The systems are inconsistent from room to room and do not interact with any other systems, including video production and new technology cannot be integrated. The goal is to replace the A/V components with a system -based approach that will bring the installations up to date and allow for future expansion and capacity. This will make the operation of systems consistent from room to room and provide for better ergonomics and ease of use, integrate the systems with other presentation and distribution systems, and modernize the systems overall. Citywide Building Insurance Appraisal Study (13005): This project is for third party insurance 35,000 appraisals of city buildings and contents to update values. The City's buildings and contents were last evaluated and inspected for value and risk in 1999 which was conducted by the Arkansas Insurance Department. The department no longer has the manpower to provide this service. Legislative Management/Agenda Routing (13010): The City currently employs a paper- 33,000 based legislative management system whereby agenda items are developed, documented, managed and routed for approvals. The proposed system will replace the paper -based system by establishing an electronic, digital method to create, route, compile and archive all documents associated with agenda creation. It will also create an electronic 'portal' by which the staff, elected officials, and public can access legislative and agenda items, and all their supporting documentation, without using staff time. Approval routing becomes automatic without the need for staff involvement. Agenda creation, publication and distribution becomes automatic. The system will integrate with open -government systems already in place to provide more immediate and relevant access to meeting records, minutes, and video, and upgrades to allow the use of mobile devices for agenda management, agenda distribution and playback of video and audio Regional Wayfinding Signage Program (13013): The Regional Wayfinding Signage Program 125,000 will allow for approximately 62 wayfinding signs to be fabricated and installed within the City of Fayetteville in 2013. A partnership between the NWA Council and seven other participating cities will share funding from the A&P Commission, the City of Fayetteville, and from a grant from the Walton Family Foundation. The signs will identify pre -determined cultural, historic, civic and other public spaces within the City to guide travelers to destinations. This program is an economic development tool that assists with tourism and all seven cities within the region will have similarly designed wayfinding sign programs to provide a cohesive and recognizable standard throughout the region. Remote Meeting Recording (13014): This project is to purchase remote recording 50,000 technology that will streamline the entire workflow from recording to telecast for meetings that occur in Room 326 or Room 1 1 1 for telecast on the Government Channel. The current process requires an average of two to four hours of additional staff time to prepare each meeting for telecast. 185 City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Telecommunications Systems Upgrades (04001): In 2012, the City purchased the new Cisco 5,000 Telecommunications System. All equipment hardware and software will be covered under warranty for a five year period. These funds in the CIP will be utilized for any additional equipment needed for further improvements or expansions such as added positions, new features that are offered, etc. These funds will also cover the cost of additional licenses needed for cell phone users to integrate back into the system. Television Center Digital Conversion (13015): This project is to convert the Television Center 75,000 to digital technology. The video production and telecasting industry made the conversion to digital technology several years ago. The systems used are still old, analog technology which are non -replaceable should the equipment fail. Television Center Equipment (02061): The Television Center replaces equipment on an 50,000 ongoing basis. This equipment includes production technology, studio equipment, lighting, sound, signal processing, telecasting equipment, etc. The Center also provides small equipment support for the Audio/Visual needs of the Administration, replacing needed equipment when necessary, such as projectors, screens, PA systems, and other A/V support equipment. Parks & Recreation Improvements Forestry, Safety & ADA Compliance (02045): Funds in this project are used for new tree 31,000 plantings, tree replacements, the annual Celebration of Trees required for the Tree City designation, the cost for forestry equipment to remove and grind hazardous trees, and education. Funds are also used to reforest areas within parks to reduce the amount of turf that requires mowing. Additionally, funds are used to remodel parks where needed to improve safety and gain ADA compliance, such as swings, older play equipment and sidewalk connections. Lights of the Ozarks (02001): The Lights of the Ozarks display is an extremely popular yearly 23,000 event that takes place from Thanksgiving to New Years Eve. Approximately 500,000 lights are displayed around the down -town square where an estimated 200,000 people come to view the display. 2011 marked the first year that the light display was 100% LED lights. Native Grasses Program (02014): A prairie restoration project was initiated in 2010 at Lake 10,000 Fayetteville. Approximately 30 acres are being converted to desirable native prairie and oak savannah habitat. Project funds will be used to purchase grass and wildflower seeds, native plants and trees, and conduct prescribed burns and vegetative management. These funds will also be used to fund establishment of native plants in other park areas that are converted to low maintenance, natural areas or where invasive plant species are removed to enhance the environment and protect the City's historical heritage. Tree Escrow (08001): This project is used to plant trees in street rights -of -way with seasonal 114,000 staff or by contract and for the purchase of equipment to maintain the trees or to contract for maintenance of the trees. Funds in the project are contributed by developers to meet the requirements of the Tree Preservation and Protection Ordinance and must be used within seven years from receipt. City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Police Improvements Police Building Improvements (02047): This project covers the cost of major repairs: security 25,000 door lock systems; major plumbing and electrical issues; roof replacement; minor re -models for the main police facility; and buildings at the radio tower sites and warehouse. Police Bulletproof Vests (13011): This project provides the 50% local match and any shortfall 10,000 from federal funding for the purchase of bulletproof vests for new officers, the replacement of expired bulletproof vests for veteran officers, and new/replacement tactical bulletproof vests for the members of the Emergency Response Team. Police Equipment Replacement (11006): This project will allocate funds for the replacement 20,000 of police operating equipment such as a paper shredder, document scanners, uninterrupted power supplies, security/surveillance cameras, etc. Other specific replacement items are: 1) the addition of one document scan station with Electronic Document Management System (EDMS) license. 2) obsolete hand-held computers and thermal citation printers for E -ticketing. 3) hand-held traffic radar units. These radar units are essential for verification a vehicle was speeding in violation of the posted speed limit. 4) a digital transcorder for undercover narcotics investigations that is used for live audio recording of covert operations. This piece of equipment both transmits and records conversations during undercover buys. The recordings are used for evidentiary purposes in court after a suspect has been arrested. Police Patrol Vehicle Electronic Upgrades (13012): This project provides for the replacement 160,000 of various electronic equipment used in police patrol vehicles. Equipment to be replaced includes: 1) mobile computer terminals (MCT). Staff expects these MCTs to be obsolete and/or malfunctioning and are necessary to support ongoing Police Department operations. 2) replacement of the modem/routers that provide a secure, wireless network connection from the mobile data terminals to the department's internal network and Global Positioning System (GPS) tracking data to central dispatch's Automatic Vehicle Location System (AVL). 3) replacement of mobile video recorders (MVR). MVRs are an important component of each patrol unit by documenting evidence to support prosecution and makes citizen complaints more easily investigated. Police Unmarked Vehicles (06003): Unmarked vehicles are a necessity for a progressive 57,000 police department. The department utilizes unmarked vehicles for a variety of tasks including: gathering intelligence for investigation of narcotics, theft, vandalism, domestic terrorism, and civil disobedience; conducting pre -raid intelligence for the deployment of the Emergency Response Team; and conducting alcohol enforcement patrols and any activity that must be kept covert to be effective. The department is recommending a three year replacement for vehicles used in undercover capacities and a five year replacement for vehicles used less frequently in an undercover capacity. Investigators use the same vehicles to affect arrests and to conduct surveillance. City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Police Technology Improvements (06002): This is an on -going project for replacement of 40,000 obsolete or malfunctioning department desktop computers, software, printers, and other peripheral equipment. The replacement of video storage cabinets is added to this project for 2014. Patrol vehicles are equipped with video recording devices that capture traffic stops and other relevant events. This video is uploaded to dish -based storage cabinets of sufficient capacity to accommodate video uploads for a period of one year. Video is then accessible over the network by authorized personnel for review and dissemination per law enforcement requirements. Police Specialized Equipment (02062): This project is to replace outdated and/or 55,000 malfunctioning equipment used during police operations. Examples of this equipment include traffic control equipment, bicycle replacement, wireless remote surveillance cameras, crisis negotiation throw phone, ballistic shields, ERT equipment, and other items used in police operations. Tasers are issued to all patrol officers for a less -than -lethal alternative to subdue combative suspects. Tasers provide an increase in safety for both the officers and the combative suspects by minimizing the need for physical altercations. Street Improvements Street ROW/Intersection/Cost Sharing (02116): This project is to provide funding for the 100,000 acquisition of miscellaneous street rights -of -way, construction of miscellaneous street projects, and cost sharing for developer projects. Trail Improvements Trail Development (02016): The goal of this project is to provide funding to increase 1,548,000 production of the trails program. Funding provides resources for new trail development and asphalt replacement on existing trails. Transportation Improvements In -House Pavement Improvements (02052): This program provides for the systematic overlay 1,842,000 of existing asphalt streets and includes curb cuts, curb and guttering, pavement striping, and preparation costs for the overlays. The goal of this project is to overlay a minimum of 150,000 square yards of asphalt each year. Overlaying each street within a 15 year cycle is intended to optimize the longevity of roadways and minimize significant maintenance requirements resulting in fewer complete renovations at a substantially greater cost. Sidewalk Improvements (02053): The goal of this project is to continue to improve the 115,000 connectivity of the sidewalk system by constructing new sidewalk and repairing existing sidewalks. Total Sales Tax Capital Improvements Fund Projects: 8,253,000 City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Water & Sewer Fund (5400) Meter Operations Caoital (1840 Business Office Improvements (03038): This project is for various improvements in business 20,000 office hardware, safety features, and office configuration. Examples of specific improvements include the purchase of advanced communications capability to improve customer service and employee efficiency, and installation of an emergency alarm system to notify the Police Department in the event of an unsafe condition or a disruptive customer. This project should leverage technological improvements. Business Office Printer Replacements (13017): This project is to purchase one new IBM Blue 30,000 Bar Printer and one replacement printer for the Billing and Collections Division. The existing printer is aging and somewhat unreliable. The additional printer will be utilized in the front office area of Billing and Collections for more efficiency. Business Office Technology Improvements (13016): The purpose of this project is to upgrade 30,000 technology in the business office including: hardware and software for customer swipe and pay stations at each of the cash registers and a new customer counter; kiosks and software for customer self services applications; a camera surveillance system; and PC and cash register receipt printer replacements. Water Meters (02065): This project is for the replacement of old water meters that are no 313,000 longer repairable, expansion meters for new water service, and for purchasing new meters with technological advancements over older style meters. In addition, it includes replacing hand held and remote style meter reading mechanisms. Water/Sewer Equipment Expansions (13019): This project is for expansion equipment for the 38,000 Water/Sewer Operations Division. It includes two trailers, a trackhoe and trailer, replacement sewer camera equipment, computers for field crews/trucks, new equipment to meet evolving stormwater regulations, and other equipment as identified through time. Capital Water Mains (5600 W/S Relocations for Street Bond Projects (11011): This project is for various water and sewer 500,000 relocations for street bond projects where the street bond fund does not have sufficient funds to cover the utility relocations. Projects are to be paid first from any remaining water/sewer revenue bond funds, if available. Capacity increases should be paid from impact fee funds, if available. Water/Sewer Impact Fee Cost Sharing (04039): This project involves all cases where impact 275,000 fees are used to cost share with and thus supplement other funding sources to increase capacity in either the water distribution, pumping and storage system or the wastewater collection and treatment system. City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Water System Rehabilitation & Replacement (12009): This project provides for upgrading, 1,010,000 replacing, or rehabilitating existing water infrastructure consisting of water storage, pumping, and distribution assets system wide. Specific work will be determined based on the need to stop leaks, reduce water loss, increase local or area flow and/or pressure in areas with insufficient capacity, in order to meet current and projected future domestic, commercial and industrial flow, and fire flow demands. Projects may create loops, purchase easements, and replace or rehabilitate pipes, pump stations, and/or storage assets. This project may use water/sewer funds, impact fees, and cost shares where aoorooriate. Sewer Mains Construction (5700) Sanitary Sewer Rehabilitation (02017): This project analyzes, repairs, upgrades, and replaces 1,210,000 sewer collection system components to ensure adequate capacity and reduce storm and groundwater flows entering the system. Negotiations with ADEQ produced an agreement that as long as the City continues rehabilitation, no enforcement action will be initiated. Rehabilitation is required system wide and increases the capacity of the overall system by reducing demand used by infiltration and inflow. This project includes replacing, lining, and bursting existing sewer mains and manholes, upgrading lift stations, installing some main extensions and relief lines/capacity upgrades, upgrading the system model, purchasing easements, and sanitary sewer evaluation studies. All WSIP work was sized based on continuing the sewer rehabilitation program. As this may include capacity increases, impact fees may sometimes be spent. WWTP Capital (5800) Building Improvements - W.W.T.P. (02032): This project is for structural maintenance, repair, 56,000 and replacement of the existing buildings or parts of the buildings at both wastewater treatment plants. Disinfection System Replacement - W.W.T.P. (10008): This project will replace the ultraviolet 1,000,000 disinfection system that is the final treatment unit in the wastewater treatment process. It disinfects the treated wastewater, as required by our NPDES discharge permit, prior to discharging it to the environment. The existing system was installed at the Noland WWTP in 1999, and has become increasingly difficult and costly to maintain. The system was a first generation unit, and parts are no longer available and technical support is very difficult to obtain. Irrigation Reels - W.W.T.P. (11010): This project is for the replacement of twelve existing 151,000 irrigation reels at the Biosolids Management Site. The irrigation reels are used to apply treated wastewater to the land application site, as described in the State approved Waste Management Plan and the State Land Application Permit. The effluent irrigation helps to minimize discharge to the White River during the summer months, therefore reducing the nutrient loadings of ammonia and phosphorus to the receiving stream. It also helps to stimulate growth of the bermuda grass, therefore enhancing phosphorus uptake from the soil and increasing hay production. 190 City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Phosphorus Standards Management (10027): This project supports efforts by the City 50,000 operating independently or as part of a regional Northwest Arkansas team, relating to phosphorus and other potential changes to stream standards, water quality standards and regulations, and wastewater discharge requirements. Some of the funds may be paid into regional efforts coordinated through Northwest Arkansas Regional Planning, the Northwest Arkansas Council, or other similar cooperative efforts. Plant Pumps and Equipment - W.W.T.P. (02069): The project allows WWTP personnel to adapt 200,000 to the needs of each season and year and still maintain compliance. Many pieces of the WWTP equipment are essential to the wastewater treatment process. The equipment may suffer catastrophic failure and become unusable with little advance warning. The plant cannot operate and continue to produce permit complying effluent without adequate equipment. Upgrade/Replace Lift Stations - W.W.T.P. (02068): The lift stations provide a vital function in 100,000 the overall treatment of wastewater. The stations are exposed to extreme wear conditions and must be upgraded routinely. Additionally, new developments within the City increase the flow to various stations requiring additional or higher capacity equipment. Wastewater Treatment/Water Quality Improvements - W.W.T.P. (13018): This project 1,520,000 improves water quality in the streams that receive the City's wastewater treatment plant effluent. Specific projects could include, but are not limited to: replacing filters at the Noland WWTP; phosphorus removal facilities at either WWTP; minerals reduction efforts at the Noland WWTP; phosphorus/sediment removal at Lake Sequoyah (by dredging); phosphorus/sediment removal by stream bank restoration on the White River; and other similar projects. Total Water & Sewer Fund Projects: 6,503,000. Solid Waste Fund (5500) Solid Waste Improvements Recycling Drop Off Facility (North / Central) (13020): This project is to provide a recycling 66,000 drop off facility. Recycling drop offs provide the most cost effective option for expanding the recycling program to service multi -family and others not serviced through the curbside program. Expanding drop offs to other areas in the City will provide more convenient opportunities to recycle, expand recycling and environmental education opportunities, and increase volunteer opportunities. Drop off size can be functional in a 200' x 200' area; however, landscaping and educational components should be considered. This project could include a land purchase based on site availability. Recycling Improvements (03016): This project was initially to be used for recycling truck 28,000 modifications. The division is in greater need of replacing the conveyor belt feeding the recycling baler. Significant repairs have been experienced in 2012 resulting in downtime and recycling materials not being able to be processed daily as needed. This project would enable the purchase of the new conveyor belt for recycling processing. 112I City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Solid Waste Compactors (10001): This project is for the purchase of compactors. The drop 126,000 box program utilizes compactor boxes to efficiently handle solid waste from large quantity generators. Compactor boxes decrease the frequency of collection and are serviced with existing drop box trucks. The aesthetics are improved by having a compactor as opposed to multiple dumpsters to service. Many businesses desire this type of collection. The division is competitively pursuing accounts currently serviced by private franchised haulers. Five additional compactors are figured each year for years 2013 through 2017 for new service and replacement of aging units. Solid Waste Compost Site Slab Expansion (10002): This project is to concrete the current 416,000 composting pad to improve operations thereby increasing productivity and quality for the end product. Storm water improvements will be accomplished by engineered design for better storm water handling and compliance with the industrial storm water permit for the site administered through ADEQ. Increased waste diversion through composting of organic wastes would also be feasible and would require modifying the composting permit from a class "Y", designating yard waste only, to a class "O" for organics. Site construction will occur over a multi -year period to allow operations to continue. An organics composting operation requires frequent turning of rows which is presently hindered by rain events rendering the pad unusable for the compost row turner. Turning of rows allows more oxygen into the process thereby reducing odors, which will be a major concern when operating a class "O" facility. Solid Waste Office & Transfer Station Expansion (13021): This project is for the expansion of 1,173,000 the transfer station. The existing Transfer Station was built in 1996 so repairs and modifications will be needed in the future. The expansion would occur if a new recycling facility were built. A new roof for the facility is needed due to leaks and expansion would include a new floor, deconstruction and electrical replacement, new pumping system, and new walls and doors. Solid Waste Mad Vac (13022): This project purchases a replacement for the existing 40,000 MadVac unit that is currently used to clean the downtown and Dickson Street areas. Total Solid Waste Fund Projects: 1,849,000 192 City of Fayetteville, Arkansas 2013 Capital Budget 2013 Project Title & Description Budget Airport Fund (5550) Aviation Imorovemenfs Airport ARFF Personal Protective Gear Replacement (13023): This project is for replacement 31,000 of twelve sets of personal protection firefighting suits used by the Aircraft Rescue and Fire Fighting (ARFF) crews. Airport Ground Service Equipment Acquisition (13024): This project is for the acquisition of a 34,000 baggage belt loader and passenger stair equipment to serve Boeing 757 aircraft. The University of Arkansas' Athletic Department has recently elected to use Drake Field for charter flights transporting the football team and personnel. Due to the height of the loading door and the need for rapid loading of a large amount of heavy equipment, the airport has determined that a purchase of a belt loader and passenger stair is essential in order to provide the service required by the charter company. Manual loading can damage the pressurization seal of the loading compartment door. Airport Roof Replacements (13025): This project will replace roofs on four buildings. The 41,000 roofs to be replaced are the flat roof membranes on the buildings currently occupied by the Ozark Military Museum and the FAA Facilities Maintenance. These buildings were the original terminal and boarding area structures constructed in the 1960s. Spot maintenance has been performed to repair leaks but the roof exhibits enough deterioration that a new roof is warranted. The replacement or refurbishing of the standing seam metal roofs on buildings currently occupied by Devol Aviation Aircraft Maintenance and Wings Avionics Inc. are the other replacements. These roofs have required continued repair and maintenance annually. Tenant complaints of leaks that threaten damage to their customer's aircraft at times has created the impetus to consider a full-scale replacement or some other long-term solution to the problem. Airport Self Serve Station Upgrade (13026): This project will provide for replacing the existing 10,000 fuel dispensers with two new digital meter/dispensers to modernize the existing facility with newer more reliable technology. Airport Sprinkler System Replacement - White Hangar (13027): This project will replace the 65,000 fire protection sprinkler system in the historic white hangar. The existing system has been in a deteriorated condition for at least a decade. Repairs have been made as needed, fixing leaks and replacing sections of piping and the system is tested regularly to ensure its functionality.. However, due to the obsolete design as a "dry system," the piping is corroded throughout. The leaks and breaks that have occurred in the piping are almost exclusively due to this corrosion of the steel piping. The building is a unique historic structure that should be preserved. The fire protection sprinkler system is integral to protecting the building and its contents.. Total Airport Fund Projects: 181,000 193 City of Fayetteville, Arkansas 2013 Capital Budget Project Title & Description Shop Fund (9700) Fleet Operations Capital (1920) Backhoes/Loaders - Replacement (02076): The purpose of this project is to replace obsolete or high maintenance vehicles which are no longer suited for regular service. 2013 purchases include four backhoes, a skid steer loader, and two front end loaders. Construction Equipment - Replacement (02077): The purpose of this project is to replace obsolete or high maintenance vehicles which are no longer suited for regular service. 2013 purchases include a grader and a track dozer. Light/Medium Trucks - Replacement (02078): The purpose of this project is to replace obsolete or high maintenance vehicles which are no longer suited for regular service. 2013 purchases include seventeen trucks. Other Vehicles/Equipment - Replacement (02080): The purpose of this project is to replace obsolete or high maintenance vehicles which are no longer suited for regular service. 2013 purchases include a patch truck, a cement mixer, three sweepers, two trailers, a chipper, a sewer TV camera van, and an air compressor. Police/Passenger Vehicles - Replacement (02081): The purpose of this project is to replace obsolete or high maintenance vehicles which are no longer suited for service. 2013 purchases include two sedans, a mid -size sport utility, and seven police patrol units. Solid Waste Equipment - Replacement (02082): The purpose of this project is to replace obsolete or high maintenance sanitation vehicles which are no longer suited for solid waste collection or recycling. 2013 purchases include two front load trucks and one rear load truck. Tractors/Mowers - Replacement (02083): The purpose of this project is to replace obsolete or high maintenance vehicles which are no longer suited for regular service. 2013 purchases include two tractors, a round hay baler, a slope mower, two multi -deck mowers, and three zero turn mowers. Total Capital Improvements Program - 2013 Projects 'vi' 2013 Budget 608,000 437,000 604,000 969,000 329,000 651,000 267,000 Total Shop Fund Projects: 3,865,000 $ 23,056,000 City of Fayetteville's Debt Position The City of Fayetteville has established a practice and policy of paying for all capital projects and capital improvements on a pay-as-you-go basis using current revenues, whenever possible. If a project or improvement is of sufficient size and need that it cannot be financed with current revenues, long-term debt will be recommended. The basis for this policy is that the City has maintained a commitment to infrastructure improvement and maintenance. The City also considers the cost versus the benefits of debt financing. A recommendation is made only when the benefits outweigh the costs. The City's debt policy also states that the City will attempt to refinance outstanding debt if a determination is made that the City will benefit by reduced interest expense over the remaining life of the bonds. Like most municipalities, the City of Fayetteville borrows funds through tax exempt municipal bonds. The City carefully analyzes each proposed bond issue to determine the need for the improvement, its useful life, and current and future revenues available to provide debt service. Existing debt service requires resources from both general governmental resources and enterprise fund resources. Bond Ratings The City's debt policy says that the communications will be maintained with the bond rating agencies and that the City will continue to strive for improvements in the City's bond rating. Such communications are vitally important due to the fact that, generally speaking, the higher rating a city has the lower the interest rate that must be paid. As such, the City will periodically confer with the rating agencies to update them on the financial status of the City. The two major investment services for bond ratings are Standard & Poor's Corporation and Moody's Investor Service. The following schedule briefly describes the ratings provided by the respective agencies for municipal bonds. Moody's and Standard & Poor's Credit Ratings for Municipal Bonds Ratings Description Moody's Standard & Poor's Aaa AAA Best quality, extremely strong capacity to pay principal and interest. Aa AA High quality, very strong capacity to pay principal and interest. A-1 A Upper medium quality, and strong capacity A to pay principal and interest. Baa-1 BBB Medium grade quality, adequate capacity & Baa to pay principal and interest. Ba and BB and Speculative quality, low capacity lower lower to pay principal and interest. 195 Description of Outstanding Bonds Soecial Obliaation Bonds Sales & Use Tax Refunding and Capital Improvement Bonds, Series 2005B: The bonds are special obligations of the City payable from receipts from a three-quarter of one percent citywide sales and use tax. The proceeds of the bonds are for the purpose of financing a portion of the costs of certain improvements to the City's wastewater treatment plants and sewerage and related facilities. The original issue amount was $45,000,000. Property Tax Increment Interest Accretion Bonds (Highway 71 East Square Redevelopment District No. 1 Project), Series 2005: The bonds are special obligations of the City payable solely from the Property Tax Increment of the District and monies in the funds and accounts established under the Indenture. The proceeds of the bonds were issued for the purpose of financing the costs of acquisition of certain real property within the City, the demolition of existing structures thereon, site preparation in connection therewith and the construction of sidewalk and crosswalk improvements. The original issue amount was $3,725,000. Sales and Use Tax Capital Improvement Bonds, Series 2006A: The bonds are special obligations of the City secured by and payable solely from receipts from a one -quarter and a three-quarter of a one percent citywide sales and use tax. The proceeds of the bonds are for the purpose of financing a portion of the costs of certain improvements to the City's wastewater treatment plants, sewerage and related facilities, to certain City streets, and to the City's trail system. The original issue amount was $50,000,000. Sales and Use Tax Capital Improvement RLF, Series 2006: The City of Fayetteville issued Not to Exceed $20,000,000 Sales and Use Tax Bond Series 2006 through the Arkansas Natural Resources Commission bond program commonly referred to as the Revolving Loan Fund (RLF). The bonds were issued for financing a portion of the costs of improvements to the City's wastewater treatment plants, sewerage and related facilities. The 2006 bonds are special obligations of the City secured by and payable solely from receipts of the .75% city-wide sales and use tax approved by the voters to support the project. All $20,000,000 in bonds has been issued. Sales and Use Tax Capital Improvement Bonds, Series 2007A: The bonds are special obligations of the City secured by and payable solely from receipts from a one -quarter and a three-quarter of a one percent citywide sales and use tax. The proceeds of the bonds are for the purpose of financing the costs of certain improvements to the City's wastewater treatment plants, sewerage, and related facilities. The original issue amount was $14,340,000. Sales and Use Tax Capital Improvement Bonds, Series 2009A: The bonds are special obligations of the City secured by and payable solely from receipts from a one -quarter and a three-quarter of a one percent citywide sales and use tax. The proceeds of the bonds are for the purpose of financing a portion of the costs of certain improvements certain City streets and to the City's trail system. The original issue amount was $1 1,250,000. Revenue Bonds Hotel & Restaurant Gross Receipts Tax Refunding, Series 2003: These bonds are special obligations of the City and were issued for the purpose of refinancing the Hotel & Restaurant Gross Receipts Tax Refunding bonds, Series 1998. The bonds are payable solely from amounts received by the City from a 1% Hotel & Restaurant Gross Receipts tax. As a result of the refunding, the City has a projected net present value savings of approximately $334,000 over the remaining life of the bonds. The original issue amount was $6,335,000. Water & Sewer System Refunding, Series 2004: The bonds are payable solely from the net revenues derived from the operation of Fayetteville's water and sewer system. The proceeds of the bonds were used to refund Series 1999 water and sewer system bonds. The refunding was issued to take advantage of lower interest rates, to restructure existing bond covenants, and to mitigate any interest risk on the variable interest rate of the Series 1999 bond issue. The original issue amount was $6,090,000. Water & Sewer System, Series 2009A: The bonds are payable solely from the net revenues derived from the operation of Fayetteville's water and sewer system. The bonds do not constitute an indebtedness of the City within the meaning of any constitutional or statutory debt limitation or restriction. The issuance of the Series 2009 Bonds shall not directly, indirectly or contingently obligate the City to levy or pledge any taxes whatsoever or to make any appropriation for the payment of the Series 2009 Bonds. The original issue amount was $8,210,000. Water & Sewer System Refunding, Series 2012: The bonds are payable solely from the net revenues derived from the operation of Fayetteville's water and sewer system. The proceeds of the bonds were used to refund Series 2002B water and sewer system bonds. The refunding was issued to take advantage of lower interest rates, to restructure existing bond covenants, and to mitigate any interest risk on the variable interest rate of the Series 2000B bond issue. The original issue amount was $3,665,000. 197 City of Fayetteville, Arkansas Bonds Outstanding December 31, 2012 Outstanding Bond Due Interest Description Issue Dates Rates Amount Special Obligation Bonds Tax Increment Interest Accretion Bonds 2005 2006-2029 6.500% $ 3,250,000 Sales and Use Tax Capital Refunding & 2005 2009-2015 3.957-4.00% 10,215,000 Capital Improvement Bonds, Series 2005B Sales and Use Tax Capital Improvement 2006 2006-2021 3.00-5.00% 46,920,000 Bonds, Series 2006A Sales and Use Tax Capital Improvement 2006 2009-2018 3.00% 12,706,312 Revolving Loan Fund (RLF) 2006 Sales and Use Tax Capital Improvement 2007 2007-2026 4.20-4.47% 12,440,000 Bonds, Series 2007A Sales and Use Tax Capital Improvement 2009 2015-2021 3.00-3.85% 10,690,000 Bonds, Series 2009A 96,221,312 Revenue Bonds Hotel & Restaurant Gross Receipts Tax 2003 2004-2015 2.55-3.55% 1,885,000 Refunding, Series 2003 Water & Sewer System, Series 2009 2009 2009-2020 2.10-3.70% 8,210,000 Water & Sewer System Refunding, 2012 2012-2017 1.00-2.00% 3,530,000 Series 2012 13,625,000 $ 109,846,312 City of Fayetteville, Arkansas 2013 Debt Service Payment Schedule Outstanding Bond Description Issue Principal Interest Total Special Obligation Bonds Sales and Use Tax Capital Refunding & 2005 $ 8,530,000 $ 408,600 $ 8,938,600 Capital Improvement Bonds, Series 2005B Sales and Use Tax Capital Improvement Bonds, Series 2006A 2006 0 2,096,476 2,096,476 Sales and Use Tax Capital Improvement Revolving Loan Fund (RLF) 2006 2006 1,963,255 366,575 2,329,830 Sales and Use Tax Capital Improvement Bonds, Series 2007A 2007 0 550,870 550,870 Sales and Use Tax Capital Improvement 2009 0 389,626 389,626 Bonds, Series 2009A 10,493,255 3,812,147 14,305,402 Revenue Bonds Hotel & Restaurant Gross Receipts Tax Refunding, Series 2003 2003 610,000 64,768 674,768 Water & Sewer System, Series 2009 2009 820,000 250,233 1,070,233 Water & Sewer System, Series 2012 2012 685,000 63,750 748,750 2,115,000 378,751 2,493,751 $ 12,608,255 $ 4,190,898 $ 16,799,153 City of Fayetteville, Arkansas Computation of Legal Debt Margin December 31, 2012 General Obligation Debt Limit Debt margin is a calculation based on the assessed value of property located within the City limits. The debt limit is established by state statute and is limited to 20% of assessed value. 2012 Assessed Value Debt Limit - 20% of Assessed Value General Obligation Bonds Payable $ Less: Debt Service Fund _ Total Debt Applicable to Debt Limit Legal Debt Margin y 300 c 0 200 100 $ 1,266,554,709 253,310,942 $ 253,310,942 Debt Applicable to Debt Limit 2002-2012 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Enterprise Fund Debt Limit (Revenue Bond Debt) Enterprise fund debt is established by the cash flow for each enterprise fund. For example, the Water & Sewer Fund must be able to generate sufficient cash flows to meet normal operating and capital, as well as provide sufficient resources to meet the annual debt service requirements. Prior to issuing enterprise fund bonds, an analysis of current revenues and expenses is conducted to determine the revenues required to support a bond issue. Special Obligation Bond Debt Limit Special obligation bond debt is limited by the maximum amount of the special source (such as sales tax) can generate within terms of bond covenants.. * Note: The assessed value does not include City utilities. 200 City of Fayetteville, Arkansas Total Debt to Maturity Schedule - All Funds December 31, 2013 Principal Amount Maturity Beginning Ending Annual Debt Year Balance Additions Reductions Balance Interest Requirement 2013 $ 109,846,312 $ 0 $ 12,608,255 $ 97,238,057 $ 4,190,898 $ 16,799,153 2014 97,238,057 0 5,862,594 91,375,463 3,746,158 9,608,752 2015 91,375,463 0 12,863,727 78,51 1,736 3,561,684 16,425,411 2016 78,51 1,736 0 12,706,708 65,805,028 3,048,024 15,754,732 2017 65,805,028 0 13,226,592 52,578,436 2,530,694 15,757,286 2018 52,578,436 0 13,828,436 38,750,000 1,985,716 15,814,152 2019 38,750,000 0 12,040,000 26,710,000 1,436,010 13,476,010 2020 26,710,000 0 11,060,000 15,650,000 925,673 11,985,673 2021 15,650,000 0 7,400,000 8,250,000 564,358 7,964,358 2022 8,250,000 0 1,255,000 6,995,000 238,788 1,493,788 2023 6,995,000 0 1,315,000 5,680,000 176,038 1,491,038 2024 5,680,000 0 1,385,000 4,295,000 110,288 1,495,288 2025 4,295,000 0 1,045,000 3,250,000 51,426 1,096,426 2026 3,250,000 0 0 3,250,000 0 0 2027 3,250,000 0 0 3,250,000 0 0 2028 3,250,000 0 0 3,250,000 0 0 2029 3,250,000 0 3,250,000 0 12,469,103 15,719,103 $ 109,846,312 $ 0 $ 109,846,312 $ 0 $ 35,034,857 $ 144,881,169 201 (Page Left Blank Intentionally) 202 City of Fayetteville, Arkansas Organizational Chart Citizens of Fayetteville City Attorney Prosecutor Police Department Central Dispatch City Clerk/Treasurer I I Mayor I I City Council Office Administration Chief of Staff —Human Resources Sustainability & Strategic Internal Audit Department Planning Department District Judge District Court Fire Department Utilities Department Parking & Telecommunications Communications & LFinance Volunteer Services Department Government Channel & Internal Services Department -Accounting & Audit Transportation Services Department -Aviation Parks & Recreation Department Development Services Department -Animal Services Wastewater Treatment Plants Billing & Collections Fleet Operations Building Safety & Permits Water & Sewer Operations Budget & Research -Solid Waste & Recycling City Planning Building Maintenance Transportation Community Services Information Technology Engineering Purchasing 203 Officials of the City of Fayetteville, Arkansas Elected Officials Mayor Lioneld Jordan 479.575.8330 mayor@ci.fayetteville.ar.us Ward 1, Position I Adella Gray 479.442.4958 Wardl_posl@ci.fayetteville.ar.us Ward 1, Position 2 Brenda Boudreaux 479.442.3095 Ward1_pos2@ci.fayetteville.ar.us Ward 2, Position 1 Mark Kinion 479.521.7632 Ward2_post@ci.fayetteville.ar.us Ward 2, Position 2 Matthew Petty 479.442.5536 Ward2_pos2@ci.fayetteville.ar.us Ward 3, Position 1 Justin Tennant 479.973.5202 Ward3_post@ci.fayetteville.ar.us Ward 3, Position 2 Bobby Ferrell 479.442.3535 Ward3_pos2@ci.fayetteville.ar.us Ward 4, Position 1 Rhonda Adams 479.442.4612 Ward4_post@ci.fayetteville.ar.us Ward 4, Position 2 Sarah Lewis 479.442.5415 Ward4_pos2@ci.fayetteville.ar.us City Attorney Kit Williams 479.575.8313 kwilliams@ci.fayetteville.ar.us City Clerk/Treasurer Sondra Smith 479.575.8323 City_clerk@ci.fayetteville.ar.us District Judge Rudy Moore 479.587.3590 rmoore@ci.fayetteville.ar.us Management Staff Executive Staff Chief of Staff Don Marr 479.575.8330 dmarr@ci.fayetteville.ar.us Acting Police Chief Greg Tabor 479.587.3565 police@ci.fayetteville.ar.us Fire Chief David Dayringer 479.575.8365 fire@ci.fayetteville.ar.us Senior Department Directors Communications & Marketing Director Lindsley Smith 479.575.8330 ssmith@ci.fayetteville.ar.us Development Services Director Jeremy Pate 479.575.8265 jpate@ci.fayetteville.ar.us Finance Director Paul A. Becker 479.575.8330 pbecker@ci.fayetteville.ar.us Parks & Recreation Director Connie Edmonston 479.444.3471 parks_and_recreation@ci.fayetteville.ar.us Transportation Services Director Terry Gulley 479.575.8228 transportation@ci.fayetteville.ar.us Utilities Director David Jurgens 479.575.8330 djurgens@ci.fayetteville.ar.us Division Heads Accounting Director Marsha Hertweck 479.575.8281 accounting@ci.fayetteville.ar.us Billing & Collections Manager Rainy Loycox 479.521.1258 rlaycox@ci.fayetteville.ar.us Budget Director Kevin Springer 479.575.8347 budget_research@ci.fayetteville.ar.us Building Maintenance Superintendent Larry Rennie 479.575.8363 building_services@ci.fayetteville.ar.us City Engineer Chris Brown 479.575.8206 engineering@ci.fayetteville.ar.us City Prosecutor Casey Jones 479.575.8377 cjones@ci.fayetteville.ar.us Community Services Director Yolanda Fields 479.575.8260 community_services@ci.fayetteville.ar.us Director of Aviation Ray Boudreaux 479.718.7642 rboudreaux@ci.fayetteville.ar.us Dispatch Manager Kathy Stocker 479.587.3555 police@ci.fayetteville.ar.us District Court Administrator Deno Stockalper 479.587.3591 district_court@ci.fayetteville.ar.us Fleet Operations Superintendent Dennis Pratt 479.444.3495 fleet@ci.fayetteville.ar.us Government Channel Manager Fritz Gisler 479.444.3434 fgisler@ci.fayetteville.ar.us Human Resources Director Missy Leflar 479.575.8278 mleflar@ci.fayetteville.ar.us Information Technologies Director Scott Huddleston 479.575.8320 information_technology@ci.fayetteville.ar.us Internal Auditor Vicki Deaton 479.575.8261 vdeaton@ci.fayetteville.ar.us Parking & Telecommunications Manager Sharon Waters 479.575.8280 parking@ci.fayetteville.ar.us Purchasing Manager Peggy Vice 479.575.8256 purchasing@ci.fayetteville.ar.us Solid Waste & Recycling Manager Vacant 479.575.8398 solid_waste@ci.fayetteville.ar.us Sustainability & Strategic Plan. Director Peter Nierengarten 479.575.8272 jcoleman@ci.fayetteville.ar.us Water & Wastewater Operations Manager Vacant 479.575.8386 water_and_sewer_maintenance @ci.fayetteville.ar.us 204 City of Fayetteville, Arkansas 2013 Operating Budget Outside Agency Funding Actual Budgeted Estimated Budgeted 2011 2012 2012 2013 General Fund (1010): Ozark Regional Transit $ 254,000 $ 254,000 $ 254,000 $ 296,000 Fayetteville Boys & Girls Club 205,350 205,350 205,350 205,350 Public Access Provider Your Media 93,000 93,000 93,000 105,000 NWAEDD (Senior Center) 53,350 53,350 53,350 53,350 Razorback Transit 50,000 50,000 50,000 50,000 Arkansas Air & Military Museum 12,000 12,000 12,000 14,500 *NWA Regional Planning 36,936 40,469 40,469 40,469 *Central Emergency Medical Service 270,000 270,000 270,000 270,000 Total Outside Agency Funding $ 974,636 $ 978,169 $ 978,169 $ 1,034,669 * These Outside Agencies Have Interlocal Governmental Agreements. 205 LISTING OF ACRONYMS A&P.......................................................................................................................Advertising & Promotion ADA............................................................................................................Americans with Disabilities Act ADEQ...........................................................................Arkansas Department of Environmental Quality ADH......................................................................................................... Arkansas Department of Health AED..........................................................................................................Automated External Deliberator AEP.........................................................................................................................Arkansas Electric Power AHTD............................................................................. Arkansas Highway Transportation Department ARFF............................................................................................................... Aircraft Rescue Fire Fighting A/V............................................................................................................................................ Audio/Visual AVL................................................................................................................ Automatic Vehicle Location BOD........................................................................................................... Biochemical Oxygen Demand BIMS....................................................................................Budget & Information Management System CAD...................................................................................................................... Computer Aided Design CAFR....................................................................................... Comprehensive Annual Financial Report CALEA ................................................Commission on Accreditation for Law Enforcement Agencies CAT.............................................................................................................. Community Access Television CDBG..........................................................................................Community Development Block Grant CIP....................................................................................................I....... Capital Improvements Program CMS........................................................................................................... Content Management System COLA..................................................................................................................Cost of Living Adjustment CPI.............................................................................................................................Consumer Price Index CPR...........................................................................................Cardiovascular Pulmonary Resuscitation DDS.........................................................................................................................Data Security Standards DOT..............................................................................................................Department of Transportation DTF........................................................................................................................................ Drug Task Force DWI.......................................................................................................................Driving While Intoxicated ECM.......................................................................................................Enterprise Content Management ED......................................................................................................................... Economic Development EDMS.................................................................................. Electronic Document Management System EMS............................................................................................................... Emergency Medical Services EMT.......................................................................................................... Emergency Medical Technician EPA...................................................................................................... Environmental Protection Agency ERP................................................................................................................ Enterprise Resource Planning ERS................................................................................................................ Emergency Response Station FAA...........................................................................................................Federal Aviation Administration FAR................................................................................................................. Federal Aviation Regulation FASB.............................................................................................Financial Accounting Standards Board FBO............................................................................................................................. Field Based Operator FCC............................................................................................... Federal Communication Commission FEDC............................................................................... Fayetteville Economic Development Council FEMA................................................................................... Federal Emergency Management Agency FHWA...................................................................................................... Federal Highway Administration FOIA............................................................................................................... Freedom of Information Act FTE.................................................................................................................................. Full -Time Equivalent GA......................................................................................................................................General Aviation GAAP..................................................................................Generally Accepted Accounting Principles GASB................................................................................ Governmental Accounting Standards Board GFOA.................................................................................... Government Finance Officers Association 206 LISTING OF ACRONYMS, (continued) GHG...................................................................................................................................Greenhouse Gas GIS...........................................................................................................Geographic Information System GPS..................................................................................................................... Global Positioning System HIRL................................................................................................................. High Intensity Runway Lights HMI................................................................................................................ Human Machine Integration HMR................................................................................................................. Hotel/Motel Restaurant Tax HOME........................................................................................................................ HOME Grant Program HUD.......................................................................................................... Housing & Urban Development HVAC.................................................................................... Heating, Ventilation, and Air Conditioning IPP............................................................................................................Industrial Pretreatment Program ISO..................................................................................................International Standards Organization IT............................................................................................................................. Information Technology LAN............................................................................................................................... Local Area Network LED................................................................................................................................ Light Emitting Diode LOPFI...................................................................................................... Local Police and Fire Retirement MCT.................................................................................................................. Mobile Computer Terminal MDT............................................................................................................................Mobile Data Terminal MGD........................................................................................................................ Million Gallons per Day MLK...................................................................................................................................Martin Luther King MRF................................................................................................................... Materials Recovery Facility MUTCD................................................................................. Manual on Uniform Traffic Control Devices MVR........................................................................................................................ Mobile Video Recorder NPDES..........................................................................National Pollutant Discharge Elimination System NWA.............................................................................................................................. Northwest Arkansas NWACC...................................................................................Northwest Arkansas Community College NWAEDD............................................................Northwest Arkansas Economic Development District O&M.................................................................................................................Operation & Maintenance ORT............................................................................................................................Ozark Regional Transit PA........................................................................................................................................... Public Address PAPI.................................................................................................... Precision Approach Path Indicator PC.................................................................................................................................. Personal Computer PCI........................................................................................................................... Payment Card Industry PO......................................................................................................................................... Purchase Order PRAB................................................................................................... Parks & Recreation Advisory Board RFP..............................................................................................................................Request for Proposals ROW.......................................................................................................................................... Right -of -Way RLF...............................................................................................................................Revolving Loan Fund RTU.............................................................................................................................Remote Terminal Units SCADA........................................................................................Supervisory Control & Data Acquisition SQL.................................................................................................................Structured Query Language SSRS.............................................................................................................SQL Server Reporting Services TIF..........................................................................................................................Tax Increment Financing TSS............................................................................................................................ Total Suspended Solids UDC................................................................................................................ Unified Development Code UPS............................................................................................................... Uninterruptable Power Supply USACE..........................................................................................United States Army Corps of Engineers 207 LISTING OF ACRONYMS, (continued) UV..................................................................................................................................................Ultra Violet W&S, W/S.............................................................................................................................. Water & Sewer WAN.............................................................................................................................. Wide Area Network WSIP...................................................................................... Wastewater System Improvements Project WWT ........................................................................................................................ Wastewater Treatment WWTP ............................................................................................................ Wastewater Treatment Plant W/W W............................................................................................................................ Water/Wastewater YRCC..........................................................................................Yvonne Richardson Community Center GLOSSARY ACCOUNT GROUP. A self -balancing set of accounts which are not a fund or a fiscal entity. General Fixed Assets Account Group and General Long -Term Debt Account Group are such examples. ACCOUNTING SYSTEM. Records and procedures that discover, record, classify, and report information on the financial position and operations of a governmental unit or any of its funds. ACCRUAL. Revenue and expenses are recorded when they are incurred. AD VALOREM. A basis for levy of taxes upon property based on value. AGENCY FUND. A fund consisting of resources received and held by the governmental unit as an agent for others. APPROPRIATION. An authorization granted by the board to incur liabilities for specific purposes. ASSETS. Probable future economic benefits obtained or controlled by a particular entity as a result of past transactions or events. BALANCED BUDGET. A budget balanced by fund, for all funds maintained by the City, in which total anticipated revenues must equal or exceed the budgeted expenditures for each fund. BOND. A written promise to pay a specified sum of money, called the face value or principal amount, at a specified date or dates in the future, called the maturity date(s), together with periodic interest at a specified rate. BOND DISCOUNT. The excess of the face value of a bond over the price for which it is acquired or sold. BOND PREMIUM. The excess of the price at which a bond is acquired or sold over its face value. BONDED DEBT. The portion of indebtedness represented by outstanding bonds. BUDGET. A financial operating plan consisting of estimates of proposed expenditures for a given period and the proposed means of financing them. BUDGET CONTROL. The control or management of the approved Budget for the purpose of keeping expenditures within the limitations of available appropriations and available revenues. BUDGET DOCUMENT. The instrument used by the budget -making authority to present a comprehensive financial program to the appropriating body. BUDGET MESSAGE. A general discussion of the budget as presented in writing by the Mayor to the City Council. The. message contains an explanation of the principal budget items and recommendations regarding the financial policy for the coming year. CAPITAL BUDGET. This budget deals with large expenditures for capital items normally financed by borrowing. Usually capital items have long-range returns, useful life spans, are relatively expensive, and have physical presence such as buildings, roads, sewage systems, etc. 209 GLOSSARY, (continued) CAPITAL IMPROVEMENT. Any property, asset, or improvement with an estimated value greater than five thousand dollars, and estimated life or usefulness of one or more years, including land, interest therein and including constructions, enlargements, and renovations. CAPITAL IMPROVEMENT PROGRAM. An approach or technique for identifying and forecasting capital outlay decisions that a government expects to make over a five year period. CAPITAL OUTLAY. Expenditures that result in the acquisition of or addition to fixed assets. CAPITAL PROJECTS FUND. A fund created to account for all resources to be used for the acquisition or construction of designated fixed assets. CASH. Legal tender or coins that can be used in exchange for goods, debt, or services. This includes the value of assets that can be converted into cash immediately CONSTRUCTION WORK IN PROGRESS. The cost of construction work that has been started but not yet completed and placed in service. CONTINGENCY FUND. Funds set aside for unforeseen expenses of uncertain amounts or funds set aside for known expenses, such as salary increases, but uncertain amounts. CONTRACTUAL SERVICE. An agreement to perform a service or task by external organizational units. A group of accounts which cover the above as well as travel and training and other miscellaneous services. DEBT SERVICE. The amount of money necessary to pay interest on an outstanding debt, the principal of maturing material serial bonds, and the required contributions to a sinking fund for term bonds. DEBT SERVICE FUND. A fund established to finance and account for the payment of interest and principal on all general obligation debt, serial and term, other than that payable exclusively from special assessments and revenues from fiduciary and proprietary funds. DEMAND. Demand is the external factor that demonstrates the "need" for a program. Demand data enables decision -makers to adjust services and costs to respond to changes in direction for the service. DEPARTMENT. Departments are the major organizational subdivisions. They have a broad overall purpose. In the City of Fayetteville organization structure, each department is comprised of one or more divisions. DEPRECIATION. Expiration in the service life of fixed assets, attributable to wear and tear, deterioration, action of the physical elements, inadequacy, and obsolescence. DESIGNATED FUND. Funds created to account for assets set aside for a specific purpose. DIVISION. Divisions are the major functional sub -divisions and correspond roughly to the departmental hierarchy formerly used by the City. Each Division reports to one of more departments. 210 GLOSSARY, (continued) EFFECTIVENESS. Effectiveness data enables decision -makers to see that quality does not suffer as productivity increases, and that constituents are satisfied with services. ENCUMBRANCE. An account used to record the estimated amount of contracts, salary commitments and purchase orders that are chargeable to an appropriation. ENTERPRISE FUND. A fund established to finance and account for the acquisition, operation, and maintenance of governmental facilities and services which are entirely or predominantly self- supporting by user charges. EXPENDITURE. Accounts which are kept on either the accrual basis or modified accrual basis of accounting and designates the cost of goods delivered or services rendered, whether paid or unpaid, including expenses and capital outlays. EXPENSE. Charges incurred for operation, maintenance, interest, and other charges that will benefit the current year. FIDUCIARY FUND. Any fund held by a governmental unit as an agent or trustee. FISCAL YEAR. A 12 -month period of time to which the annual budget applies and at the end of which a governmental unit determines its financial position and the results of its operations. FIXED ASSET. Long-term assets that are intended to be held or used, such as land, buildings, machinery, furniture, and other equipment. FRANCHISE TAX. Fees levied on a corporation in return for granting a privilege sanctioning a monopoly or permitting the use of public property, usually subject to regulation set by the governing body. FULL-TIME EQUIVALENT POSITION (FTE). A part-time position converted to the decimal equivalent of a full-time position based on 2,080 hours per year. For example, a summer lifeguard working for four months, or 690 hours, would be equivalent to .33 of a full-time position. FUND. A fiscal and accounting entity with a self -balancing set of accounts recording cash and other financial resources, together with all related liabilities and residual equities, or balances, and changes therein, which are segregated for the purpose of carrying on specific activities or attaining certain objectives in accordance with special regulations, restrictions, or limitations. FUND BALANCE. Fund equity of a -fund or in Governmental Funds, the amount assets exceed liabilities. Unrestricted Fund Balance is available for appropriation. FUND EQUITY. The excess of assets over liabilities. A portion of the equity may be reserved, restricted or designated; the remainder is Fund Balance. GENERAL FIXED ASSETS ACCOUNT GROUP. A self -balancing group of accounts set up to account for the general fixed assets of a governmental unit. GENERAL FUND. A fund used to -account for all transactions of a governmental unit that are not accounted for in another fund, such as police and fire services. 211 GLOSSARY, (continued) GENERAL LONG-TERM DEBT ACCOUNT GROUP. A self -balancing group of accounts set up to account for long-term debt which is legally payable from general revenues. GOAL. A goal is a statement of desired conditions to be maintained or achieved through the efforts of an organization. Actual total achievement may be impossible, but the goal is a standard against which to measure progress toward ideal conditions. A goal is a definition of results toward which the work of the organization is directed. GOVERNMENTAL FUND. A generic classification adopted by the National Council on Governmental Accounting to refer to all funds other than proprietary and fiduciary funds. General fund, special revenue funds, capital projects funds, debt service funds, and special assessment funds are all examples of governmental fund types. GRANT. A contribution by one governmental unit to another unit. The contribution is usually made to aid in the support of a specified function or for the acquisition or construction of fixed assets. INCOME. A term used to represent the excess of revenues earned over the expenses incurred in carrying on an enterprise operation. INTERGOVERNMENTAL REVENUE. Revenue from other governments. Grants, entitlements, and shared revenues are types of intergovernmental revenue. INTERNAL SERVICE FUND. A fund established to finance and account for services and commodities furnished by a designated department to other departments. Amounts expended by the fund are reestablished from either operating earnings or by transfers from other funds. INVESTMENT. Securities held for the production of income in the form of interest and dividends. LIABILITY. Probable future sacrifices of economic benefits arising from present obligations of a particular entity to transfer assets or provide services to other entities in the future as a result of past transactions or events. LINE -ITEM. A detailed classification of an expense or expenditure classified by object within each Division. LONG-TERM DEBT. Debt with a maturity of more than one year after the date of issuance. MODIFIED ACCRUAL BASIS. Governmental funds use the modified accrual basis of accounting. Revenues are recognized in the period in which they become both available and measurable. Expenditures are recognized at the time a liability is incurred. NET INCOME. A term used in governmental enterprise to designate the excess of total revenues over total expenses. NONOPERATING EXPENSE. Proprietary fund expenses incurred in performance of activities not directly related to supplying the basic service by a governmental enterprise. NONOPERATING INCOME. Proprietary fund income that is not derived from the basic operations of such enterprises. 212 GLOSSARY, (continued) OBJECT CODE. Expenditure classification according to the types of items purchased or services obtained; for example, personnel services, materials and supplies, contractual service, and capital. OBJECTIVE. An objective is a decision about the amount of progress to be made within a specified period of time. It states in measurable and quantitative terms the results to be achieved within a specified time and plans the incremental steps to achieve the goal. OPERATING TRANSFER. Legally authorized interfund transfers from a fund receiving revenue to the fund that makes expenditures. ORDINANCE. A formal legislative enactment by the governing board of a municipality. If it is not in conflict with any higher form of law, such as a state statute or constitutional provision, it has the full force and effect of law within the boundaries of the municipality to which it applies. PERFORMANCE BUDGET. A budget which relates appropriations to work loads. By featuring unit measures, performance budgets are believed to express official and citizen interest in the managerial value of efficiency. PERFORMANCE MEASURES. Performance measures provide a means of identifying the level of service provided. Performance measures include a measurement of Demand, Workload, Productivity, and Effectiveness. PROGRAM. Operating units within a Division. Each program represents a specific type of activity within its Division aimed at providing a service for which the City is responsible. PROGRAM BUDGET. A budget which relates appropriations to goals. Budget makers practicing this approach strive to appropriate sums to non -organization, goal -oriented cost centers. Program budgeting is believed to express official and citizen interest in planning and in the effective use of resources. PROGRAM OBJECTIVES. A program objective is a decision about the amount of progress to be made within a specified period of time in reducing the gap between real conditions and the ideal conditions described in the Program Description. It states in measurable quantitative terms the results to be achieved within a specified time and plans the incremental steps to achieve them. PRODUCTIVITY. Unit cost (productivity data) enables decision -makers to measure efficiency, as opposed to total expenditures. Productivity unit costs can also be used to quickly estimate the cost of adding more service or savings realized from reductions in service. PROPRIETARY FUND. Sometimes referred to as "income -determination" or "commercial -type" funds. Examples are enterprise and internal service funds. RESERVE. An account that records a portion of the fund equity that must be segregated for some future use and which is not available for further appropriation or expenditure. RETAINED EARNINGS. The accumulated earnings of an enterprise or internal service fund that have been retained in the fund and that are not reserved for any specific purpose. 213 GLOSSARY, (continued) REVENUE. Additions to fund financial resources other than from interfund transfers and debt issue proceeds. SPECIAL REVENUE FUND. A fund established to account for revenues from specific taxes or other earmarked revenue sources that by law are designated to finance particular functions or activities of government. TAX. A compulsory charge levied by a governmental unit for the purpose of raising revenue. These revenues are used to pay for services or improvements provided for the general public benefit. UNRESERVED FUND BALANCE. The amount remaining in a fund that is not reserved for some future use and which is available for further appropriation or expenditure. USER CHARGE. A charged levied against users of a service or purchasers of a product of an enterprise or internal service funds. WORKLOAD. Workload data answers the question about how much service is being provided, as well as how output is meeting service demand. Workload data is also the basis, along with total expenditures, for unit cost or productivity indicators. 214 City of Fayetteville, Arkansas Index Acronyms....................................................................206-208 Administrative Procedures to Adjust the Approved Budget .........................7-8 Airport Fund: Category Summary..................................................123 Airport Fund: Fund Description ...............................................119-120 Airport Fund: Operating Budget..............................................121-122 Budget Executive Summary .....................................................III -XI BudgetFlowchart...................................................................3 Budget Organizational Structure................................................9-10 Budget Process..................................................................1-2 Budget Resolution...............................................................xii Capital Budget (2013) .......................................................180-194 Capital Improvement Policy........................................................6 Capital Improvements Program Directional Information ........................171-173 Capital Improvements Program Introduction...................................167-170 Capital Projects Comprehensive Detail (2013) ................................175-179 Capital Projects Summary (2013) .................................................174 Chart of Fund Types - Governmental...............................................13 Chart of Fund Types - Proprietary & Fiduciary....................................14 Community Development Block Grant Fund: Category Summary .........................51 Community Development Block Grant Fund: Fund Description .........................49 community Development Block Grant Fund: Fund Summary .............................50 Consolidated Fund - Department - Program Structure...............................11 DebtPolicy.......................................................................5 Debt Position...............'....................................................195 Debt Service Payment Schedule...................................................199 Debt to Maturity schedule .......................................................201 Description of outstanding Bonds............................................196-197 Drug Law Enforcement Fund: Category Summary......................................71 Drug Law Enforcement Fund: Fund Description......................................69 Drug Law Enforcement Fund: Fund Summary..........................................70 Energy Block Grant Fund: Category Summary........................................59 Energy Block Grant Fund: Fund Description........................................57 Energy Block Grant Fund: Fund Summary............................................58 ExpenditurePolicy................................................................5 Financial Reporting Policy.........................................................6 Fire Bond Fund: category Summary.................................................75 Fire Bond Fund: Fund Description.................................................73 Fire Bond Fund: Fund summary.....................................................74 Fire Pension Fund: category Summary.............................................135 Fire Pension Fund: Fund Description.............................................133 Fire Pension Fund: Operating Budget.............................................134 Frozen Positions by. Activity & Division. ..................................165-166 General Fund: Category Summary................................................27-37 General Fund: Fund Description................................................17-25 General Fund: Fund Summary.......................................................26 Glossary............................ .......................................209-214 Impact Fee Fund: Category Summary................................................67 Impact Fee Fund: Fund Description................................................65 Impact Fee Fund: Fund Summary....................................................66 Investment and Cash Management Policy.............................................6 Legal Debt Margin Computation ...................................................200 List of Elected officials, Administrative officials, & Management Staff......... 204 215 City of Fayetteville, Arkansas Index Multi -Year Comparison - Adopted Budget Expenditures..............................16 organizational chart............................................................203 outside Agency Funding ..........................................................205 Parking Fund: Category Summary...................................................47 Parking Fund: Fund Description ...................................................45 Parking Fund: Fund summary.......................................................46 Parks Development Fund: category Summary.........................................63 Parks Development Fund: Fund Description.........................................61 Parks Development Fund: Fund Summary.............................................62 Personnel Detail by Activity & Division.....................................152-164 Personnel History by Activity (2004-2013) .......................................149 Personnel History by Funding Source (2004-2013) .................................143 Personnel Summary by Activity (FTE).............................................148 Personnel Summary by Activity (Program).....................................150-151 Personnel Summary by Funding Source (FTE).......................................142 Personnel Summary by Funding Source (Program)...............................144-146 Personnel summary by organization chart.........................................141 Personnel Variation Summary .....................................................147 Police Pension Fund: Category Summary...........................................131 Police Pension Fund: Fund Description...........................................129 Police Pension Fund: Operating Budget ...........................................130 ......................130 Replacement & Disaster Recovery Fund: Category Summary ...........................87 Replacement & Disaster Recovery Fund: Fund Description ...........................85 Replacement & Disaster Recovery Fund: Fund summary...............................86 ReservePolicy....................................................................5 RevenuePolicy....................................................................4 sales Tax Capital Improvements Fund: capital Budget...........................92-93 Sales Tax capital Improvements Fund: Category Summary ............................91 sales Tax Capital Improvements Fund: Fund Description ............................89 sales Tax Capital Improvements Fund: Fund Summary................................90 Sales Tax Construction Bond Fund: Category summary..............................101 Sales Tax construction Bond Fund: Fund Description...............................99 Sales Tax Construction Bond Fund: Fund summary..................................100 schedule of Bonds outstanding ...................................................198 Shop Fund: Category Summary .....................................................140 Shop Fund: Fund Description .....................................................137 Shop Fund: Operating Budget.................................................138-139 Solid Waste Fund: Category Summary..........................................117-118 solid waste Fund: Fund Description..........................................113-114 Solid waste Fund: Operating Budget..........................................115-116 Sources and uses of Funds........................................................15 Special State Grants Fund: Category Summary......................................55 Special state Grants Fund: Fund Description......................................53 Special State Grants Fund: Fund Summary..........................................54 Street Fund: category Summary.................................................42-43 Street Fund: Fund Description.................................................39-40 Street Fund: Fund Summary........................................................41 TIF Bond Fund: Category Summary..................................................79 TIF Bond Fund: Fund Description..................................................77 TIF Bond Fund: Fund Summary......................................................78 216 City of Fayetteville, Arkansas Index Town Center and Parking Facility Fund: Category Summary .........................126 Town Center and Parking Facility Fund: Fund Description .........................124 Town Center and, Parking Facility Fund: operating Budget .........................125 Transmittal Memo from the Mayor to Council.....................................i-II wastewater Improvements Sales Tax Bond Fund: Category Summary ....................83 Wastewater Improvements Sales Tax Bond Fund: Fund Description ....................81 Wastewater Improvements sales Tax Bond Fund: Fund Summary ........................82 82 Wastewater System Improvements Project Fund: Category Summary ....................97 wastewater System Improvements Project Fund: Fund Description ....................95 wastewater System Improvements Project Fund: Fund summary .........................96 96 Water & Sewer Fund: Category Summary........................................108-111 water & Sewer Fund: Fund Description........................................103-105 water & Sewer Fund: Operating Budget........................................106-107 217 Left Blank Intentional Kevin Springer Submitted By City of Fayetteville Staff Review Form City Council Agenda Items and Contracts, Leases or Agreements 11/20/2012 City Council Meeting Date Agenda Items Only Budget & Research Division Action Reauired: Finance & Internal Services Department Approve a resolution adopting the Proposed 2013 Annual Budget & Work Program. N/A $ - Cost of this request Category / Project Budget Account Number Funds Used to Date Project Number Remaining Balance Budgeted Item Budget Adjustment Attached Departme irector Date A orney Date Pow . t ^ Finance and Internal Services Director Date Chief of S ff Date M or D e Program Category / Project Name Program / Project Category Name Fund Name Previous Ordinance or Resolution # Original Contract Date: Original Contract Number: 1 1-O2-1 ? Al 1 : 24 RCVD Received in City Clerk's Office ItA C -X I Received in Mayor's Office Revised January 15, 2009 �`, std a e ev! e FARKANSAS� TO: Mayor Jordan and City Council THRU: Don Marr, Chief of Staff FROM: Paul A. Becker, Finance Director Kevin Springer, Budget Director 9 DATE: November 2, 2012 CITY OF FAYETTEVILLE, ARKANSAS BUDGET& RESEARCH DIVISION 113 West Mountain • Fayetteville, AR 72701 P (479) 575-8347 SUBJECT: Proposed 2013 Annual Budget & Work Program Recommendation: Consider the Proposed 2013 Annual Budget & Work Program for adoption by the December 4, 2012 City Council meeting. Discussion: The Proposed 2013 Annual Budget & Work Program will be distributed to City Council on Thursday, November 8, 2012. Listed below is a schedule of hearing dates for the Proposed 2013 Annual Budget & Work Program. Saturday, November 10, 2012 Budget Discussion Meeting, Room 326 Tuesday, November 13, 2012 City Council Agenda Meeting, Room 326 Tuesday, November 20, 2012 City Council Meeting, Room 219 Tuesday, December 4, 2012 City Council Meeting, Room 219 Additional meetings to be scheduled if needed. If you have any questions concerning the Proposed 2013 Annual Budget & Work Program, please feel free to contact either Paul A. Becker at 575-8330 or Kevin Springer at 575-8226. Thank you for your attention to this matter. Telecommunications Device for the Deaf TDD (479) 521-1316 113 West Mountain - Fayetteville, AR 72701 RESOLUTION NO. A RESOLUTION ADOPTING THE 2013 ANNUAL BUDGET AND WORK PROGRAM BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF FAYETTEVILLE, ARKANSAS: Section 1: That the City Council of the City of Fayetteville, Arkansas hereby adopts the 2013 Annual Budget and Work Program. A copy of the Budget, marked Exhibit "A", is attached hereto and made a part hereof. PASSED and APPROVED this APPROVED: By: LIONELD JORDAN, Mayor day of ATTEST: By: 2012. SONDRA E. SMITH, City Clerk/Treasurer