The URL can be used to link to this page

10/10/2016 - City Council SpecialSPECIAL CITY COUNCIL MEETING TUESDAY, OCTOBER 10, 2016 5:30 P.M. EAGAN ROOM—EAGAN MUNICIPAL CENTER AGENDA ROLL CALL AND ADOPTION OF THE AGENDA II. VISITORS TO BE HEARD III. JOINT MEETING WITH ADVISORY PARKS AND RECREATION COMMISSION • State of the Parks • Parks and Recreation Capital Improvement Plan IV. 2017 EAGAN CONVENTION AND VISITORS BUREAU BUDGET AND ANNUAL UPDATE ON ECVB PROGRAMMING V. 2017 ENTERPRISE AND SPECIAL REVENUE FUND BUDGETS VI. OTHER BUSINESS VII. ADJOURNMENT Agenda Information Memo October 10, 2016 Eagan Special City Council Workshop III. JOINT MEETING WITH ADVISORY PARKS AND RECREATION COMMISSION Direction For Consideration: No formal action required. Pending Council's direction, the CIP will be included on a future regular City Council consent agenda for formal action. Facts: ➢ Over the past couple of years Mayor and Council have asked for a presentation on our park system including user numbers and challenges. ➢ Annually the Advisory Parks and Recreation Commission (APrC) meets with the Council to discuss the five year capital improvement plan (CIP). ➢ The State of the Parks presentation to be given at the special meeting will address both the park system request as well as the CIP. ➢ The APRC has discussed the CIP over the past four months, which has included onsite tours of most of the items on the plan for 2017. ➢ Staff and APrC present a larger effort for CIP projects in 2017, 2018 and 2019 to help us get caught up on a growing list of park items. ➢ Discussions with APrC has resulted in a desire of maintaining a fund balance in the Park Dedication Fund of $1M over time and year over year will monitor and adjust CIP items accordingly to Park Dedication Fees and dedicated tax revenues received. ➢ Through the recent Master Plan update, Eagan Forward and past engagement efforts, the list of projects has grown over the past few years. ➢ As a reference for Council, in 2016 the budgeted amount of CIP projects was $650,000. Attachments: (1) III. -1 State of the Parks Presentation '� <; ,, E Y" f.' �: {F,. 3' v^r - � �'� ;: .� �"' ._ . , r _ _� �_ � x—� s ,, ._ _ _� , �. . _ ...� � 9.._�._ , �_��. � .., . M.r . ....� ._ _ .. =� ... w. , _ _.a__ � _ _ �... �, _ .�...� { 4> c sNO �: k.w - � �.� � t ,� ;� WIT, its a e a #9tAES�� : € MA MAY till W WIT, its a e a #9tAES�� s - � ' s� � b 4 mc X SE WC 2 j: 2! ly IV 0 (A 14 C) C) cl co c! 8 co co 7a 0 0 co 0 0 0 coo N 64 No 00 0) 0 cl 'E Ic 0 c D 0 13 c tu > 0) Agenda Information Memo October 10, 2016, Special Eagan City Council Meeting IV. 2017 EAGAN CONVENTION AND VISITORS BUREAU BUDGET AND ANNUAL UPDATE ON ECVB PROGRAMMING Action To Be Considered: To hear an overview of the 2017 marketing priorities and receive the Board -adopted 2017 ECVB budget and direct that it be placed on a future regular City Council meeting consent agenda for formal ratification. Facts: ➢ The Eagan CVB's 2017 budget process began early this summer, and has been reviewed by the ECVB Finance Committee which includes City of Eagan's Assistant Finance Director, Josh Feldman. The budget was also reviewed separately by City Liaison Tom Garrison as part of the ECVB Executive Committee. ➢ The budget was examined and approved by the ECVB's Board of Directors during their October 5 Board meeting. City Liaison Tom Garrison and Mayor Mike Maguire were present for the Board approval. ➢ While the ECVB Board operates independently from the City, Section 3.2 of the Operating Agreement with the City of Eagan requires the ECVB to submit its work plan and operating budget to the City Council for its "review and approval." ➢ Eagan's hospitality community continues to grow, and with the addition of more hotels on the immediate horizon, the ECVB anticipates being in a position to dedicate even more dollars to tourism marketing initiatives aimed at creating economic impact for our community. ➢ The ECVB's core mission of promoting Eagan as a preferred destination for leisure travelers, tour groups, meeting attendees and sports tournaments is backed by a comprehensive sales and promotional campaigns. In addition to promoting Eagan's major attractions, hotels and restaurants in a total of 14 different markets, in 2017 the Bureau will also be concentrating marketing and promotional efforts on enticing Canadians to venture south of the border to enjoy Eagan's amenities. ➢ The ECVB will once again play an active role in spearheading promotional efforts for Eagan's July 4th Funfest, Art Festival, Market Fest and Caponi Art Park while also working with officials from Cascade Bay and the Eagan Civic Arena on joint marketing efforts for 2017. ➢ Communications Director Garrison and ECVB President & CEO Brent Cory will make a very brief presentation and be available to answer any questions relative to the ECVB's 2017 budget. Attachments: (1) IV. -1 ECVB Budget Eagan Convention & Visitors Bureau Proposed 2017 Budget INCOME Lodging tax Other Utilization of reserves Total Income EXPENSES Personnel Other Marketing Travel & Entertainment Total Expenses Net income 2014 2015 2016 2017 Actual Actual Budget Budget $ 894,307 $ 905,379 $ 950,000 $ 950,000 2,073 8,492 12,000 21,100 100,000 75,000 75,000 25,000 996,380 988,871 1,037,000 996,100 276,341 298,395 308,750 320,000 124,816 131,330 129,000 128,250 538,030 548,509 570,500 520,100 28,264 24,571 28,750 27,750 967,451 1,002,805 1,037,000 996,100 $ 28,929 $ (13,934) $ - $ - Eagan Convention & Visitors Bureau Proposed 2017 Budget EXPENSES Personnel Expenses Salaries 237,367 250,324 257,000 267,000 3.9% Health Insurance 17,002 24,290 22,750 24,000 Budget vs. Budget Payroll Expenses (FICA, etc.) 2014 2015 2016 2017 Change SIMPLE Matching Funds Actual Actuals Budget Budget 2015 to 2016 INCOME 276,341 298,395 308,750 320,000 3.6% Tax Income $ 897,992 $ 905,379 $ 950,000 $ 950,000 0.0% Interest Income 2,073 1,088 500 500 0.0% Explore MN Tourism Coop - 6,584 8,000 15,600 95.0% Undesignated Reserves 100,000 75,000 75,000 25,000 -66.7% Misc. Income - - 3,500 5,000 42.9% Total Income 1,000,065 988,051 1,037,000 996,100 -3.9% EXPENSES Personnel Expenses Salaries 237,367 250,324 257,000 267,000 3.9% Health Insurance 17,002 24,290 22,750 24,000 5.5% Payroll Expenses (FICA, etc.) 18,843 20,210 21,500 22,000 2.3% SIMPLE Matching Funds 3,129 3,571 7,500 7,000 -6.7% Subtotal 276,341 298,395 308,750 320,000 3.6% Other Expenses Accounting 20,419 21,166 23;000 22,000 -4.3% Annual Meeting/Awards Program 6,293 4,693 5,000 5,000 0.0% Auto Expenses 589 523 2,000 2,000 0.0% Contract Labor 7,258 12,448 10,000 10,500 5.0% Depreciation 11,400 9,824 10,000 10,000 0.0% Donations 300 550 1,000 500 -50.0% Dues/Subscriptions 6,655 8,874 6,000 6,000 0.0% Education/Training 11,165 10,320 12,500 12,500 0.0% Equipment Lease 912 725 1,000 750 -25.0% Equipment Maintenance 2,896 5,848 500 1,000 100.0% Insurance 3,604 4,969 6,000 6,500 8.3% Legal Fees - - 1,000 1,000 0.0% Meetings 3,604 3,621 3,000 2,500 -16.7% Office Supplies/Equipment 9,970 9,276 7,000 7,000 0.0% Rent 33,582 32,759 34,000 34,000 0.0% Telephone 6,169 5,734 7,000 7,000 0.0% Subtotal 124,816 131,330 129,000 128,250 -0.6% Marketing Expenses Advertising 357,676 355,598 370,000 350,000 -5.4% FAM 1,646 3,949 5,000 5,000 0.0% Fulfillment House Services 6,481 9,912 6,000 5,600 -6.7% Postage 9,788 16,572 10,000 9,000 -10.0% Promotion 108,725 108,263 125,000 85,000 -32.0% Research 9,790 9,430 20,000 30,000 50.0% Telecommunications Services 6,717 7,387 7,000 6,000 -14.3% Trade Show 14,818 14,776 12,500 12,000 -4.0% Website/Mobile Technology 22,389 22,622 15,000 17,500 16.7% Subtotal 538,030 548,509 570,500 520,100 -8.8% Travel & Entertainment Transportation 7,886 9,742 12,000 10,000 Entertainment 246 28 750 750 0.0% Meals 3,623 2,541 3,000 3,500 16.7% Lodging 16,509 12,260 13,000 13,500 3.8% Subtotal 28,264 24,571 28,750 27,750 -3.5% Total Expenses 967,451 1,002,805 1,037,000 996,100 -3.9% Net Income $ 32,614 $ (14,754) $ - $ - Agenda Information Memo October 10, 2016, Eagan Special City Council Workshop V. 2017 ENTERPRISE AND SPECIAL REVENUE FUND BUDGETS Direction For Consideration: ➢ To provide direction to staff regarding the proposed 2017 fund budgets for: ENTERPRISE FUNDS: o Public Utilities (Water, Sanitary Sewer, Street Lighting, Storm Drainage and Water Quality) o Civic Arena o Cascade Bay o Community Center o AccessEagan/Fiber Infrastructure SPECIAL REVENUE FUND o E -TV ➢ To direct that the budgets be placed on a future City Council meeting Consent Agenda for formal ratification, or studied further. ➢ Ratify the AccessEagan policy recommendations of the Finance Committee as outlined below. Facts: GENERAL INFORMATION ➢ By definition, enterprise funds are established to account for self-supporting activities with revenues primarily from user fees at rates set by the City Council. ➢ The Budget Team—City Administrator Osberg, Assistant City Administrator Miller, Finance Director Pepper, Assistant Finance Director Feldman—met with the following responsible budget managers to review and discuss the respective budget proposals and operating issues: o Public Utilities Budgets - Public Works Director Matthys, Transportation Operations Engineer Plath, Utilities Superintendent Eaton, and Water Resources Manager Macbeth o Civic Arena and Cascade Bay - Parks and Recreation Director Pimental, Facilities Manager Vaughan o Community Center- Parks and Recreation Director Pimental, Community Center Manager Grange o AccessEagan - Communications Director Garrison and IT Manager Cook to review and discuss the respective proposals and operating issues. o E -TV — Communications Director Garrison and E -TV Studio Supervisor Ongstad ➢ Staff responsible for these budgets will be available at the meeting to expand on policy issues and respond to questions. ➢ 2017 highlights for each operating budget are included in the detail pages in the usual budget book format. Additional comments about each fund are noted below: PUBLIC UTILTIES (Water, Sanitary Sewer, Street Lighting, Storm Drainage and Water Quality) ➢ The City participates in an annual utilities rate survey by AE2S, an engineering consulting firm. In the 2015 survey, Eagan's combined rates for water, wastewater and stormwater ranked 2nd lowest among the 29 Twin Cities metro communities responding to the survey. Survey results for 2016 were unavailable at the time of print. ➢ User rates for the utilities are approved annually with the Fee Schedule adoption in December. An internal rate study of utilities rates based on Springsted's 20 year model has been completed. The following rate increases are proposed as a result of study: o Water: 5.00% o Sanitary sewer: 3.15% o Street lighting: 3.50% o Storm drainage/water quality: 1.75 % :41rJ��_�:�a►re� ➢ Comparable rates are included in the attachment for review and analysis. The Council will be asked to adopt all rates when the City-wide fee schedule is adopted in December. These rates include an increase a $5 increase in the prime -time and non- prime hourly ice rates. CASCADE BAY ➢ 2017 will be the 19th year that Cascade Bay will be operational. Total attendance for the facility amounts to just over 2.2 million patrons. In 2015, attendance count for the year totaled 119,382. In 2016 rose to 127,645. The facility's best year was in 2001 with 168,109 patrons. COMMUNITY CENTER ➢ The Community Center continues to serve Eagan's residents and businesses as a fitness center and event and meeting facility. 2017 will be the Community Center's 14th year of operation. ➢ From the Community Center's inception, it was recognized that fee revenues from operations would be insufficient to cover operating expenses. The budget has always been balanced by way of a transfer of antenna lease revenues from the Public Utilities fund. The 2017 budget calls for a use of $376,000 of antenna lease revenue or 20% of the proposed 2017 Community Center budget. This is a decrease of $95,600 over the 2016 budget. ➢ The 2017 levy for the Community Center bonds, which is excluded from the operating budget, is about $1.1 million. The bonds will be paid off in 2021. ACCESSEAGAN/FIBER INFRASTRUCTURE ➢ The proposed 2017 AccessEagan/Fiber Infrastructure fund budget is up less than 1.0% from 2016 and continues to build client base. ➢ In 2016, AccessEagan was able to expand its reach to the southern part of Eagan by entering into Joint Powers Agreements (JPA) with Dakota County at no cost to the City. After completion in early 2017, AccessEagan will have just over 40 miles of fiber infrastructure. The JPAs have the added benefit of allowing the City to connect two municipal sites along the way (Fire Station #1 and the Cliff booster station). ➢ Beginning this fall, and in early 2017, AccessEagan will expand its fiber network to northeast Eagan per direction, in two phases. In phase 1, AccessEagan has a contract to build out to a customer along the route to Lone Oak Drive and Waters Road. In phase 2, it will continue going up Lone Oak Drive and reaching the former Northwest Parkway which will be reconstructed as Vikings Parkway, bringing greater access and choice to this area in a cost-effective manner while the roadway is open. ➢ A three -fold strategy of facilitating installs generally 30-60 days faster than the industry average, emphasizing the importance of owning one's connection, and getting out early on new developments is bearing fruit, with four new customers this last year. ➢ Having recently signed DataBank as the first data center service provider on the AccessEagan network, 2017 emphasis is on a unique partnership which allows DataBank to offer Eagan businesses a pathway to the data center using AccessEagan's wholesale network, which strengthens the local Eagan business community's options for disaster recovery and managed services. Once customers are connected to the data center, they have a wide choice of different carriers and services. ➢ Additional priorities involve updating the AccessEagan website, which has already begun with an enhanced ability for Eagan businesses to enter their address into a database - driven map to determine if they are a good fit for utilizing AccessEagan wholesale fiber and to request a visit from an AccessEagan representative for further information. ➢ AccessEagan continues to have additional value as an economic development asset and feedback received from end users has been most positive. ➢ Staff continues to build expertise while improving service to existing customers. In addition, staff is able to better capture sales opportunities with improved internal and external partnerships. E -TV ➢ The proposed E -TV operational budget is up slightly from 2016. Franchise fee negotiations are ongoing are expected to continue into 2017. Attachments: (3) V-1 Metro Utility Rate Survey Results V-2 2017 Enterprise Fund Budgets V-3 2017 E -TV Budget MINNEAPOLIS/ST. PAUL METRO AREA Maple Grove, MN4 :r;; $27.26 Eagan, MN $34.25 Water Cottage Grove, MN _' y, k.r; $34.88 Wastewater Brooklyn Park, MN$35.20 Rosemount, MN W'.111, $3758 Spring Lake Park, MND $38.33 Oakdale, MN f $39.58 Eden Prairie, MNRjifflL y�-_ $4019 Ramsey, MN �� -.: , :} $41.47 Shakopee, MNr$42.81 Anoka, MN k uA. „ $44.38 Hopkins, MN�� $44.41 Champlin, MN�� $45.82 Minnetonka, MN$46.97 Fridley, MN _. $47.23 ry4ri c s Richfield, MN AW rrys $50.65 Columbia Heights, MN$52.70 Forest Lake, MND $53.32 Falcon Heights, MN's, ; $56.02 Mendota Heights, MN $56.41 $56.41 Victoria, MN' [I - K: } x$9"'3-£�rtPF1 s_ 1 .. t :. Prior Lake, MN$62.20 Robbinsdale, MN $62.62 West St. Paul, MN�� $68.21 Mahtomedi, MN �._ $68.29 Waconia, MN$69.53 Minneapolis, MN $71.64 New Hope, MN $76.81 Orono, MN rl $83.15 $0.00 $24.00 $48.00 $72.00 $96.00 $120.00 37 www.ae2s.coni l www.ae2snexus.com WZCity o bp 2017 Proposed Budget Operating Budget Enterprise Funds CI a�1811 2017 Proposed Budget Operating Budget Revenues: Service charges Connection permits Meter sales Other Total revenues Operating Expenses: Personal services Supplies, repairs, maint. Other services & charges Merchandise for resale Transfers Out MCES disposal charges Total operating expenses` Public Utilities Fund 2017 Budget Revenue and Expense Summary $ 5,135,500 $ 6,981,600 $ 721,700 $ 980,300 $ 1,550,700 $ 15,369,800 1,864,000 Sanitary Street Storm Water 394,700 Water Sewer Lighting Drainage Quality TOTALS $ 5;071,500 $ 6,963,600 $ 718,200 $ 980,300 $ 1,506,200 $ 15,239,800 8,000 8,000 - - - 16,000 40,000 - - - 40,000 16,000 10,000 3,500 44,500 74,000 $ 5,135,500 $ 6,981,600 $ 721,700 $ 980,300 $ 1,550,700 $ 15,369,800 1,864,000 718,900 10,100 115,700 394,700 3,103,400 454,300 85,000 - 11,900 47,800 599,000 1,881,100 430,800 592,200 310,300 214,600 3,429,000 21,300 - - - - 21,300 774,500 368,200 38,100 25,400 63,500 1,269,700 - 5,198,200 - - - 5,198,200 $4,995,200 $ 6,801,100 $ 640,400 $ 463,300 $ 720,600 $ 13,620,600 Net operating cash inflow(outflow 140,300 180,500 81,300 517,000 830,100 1,749,200 Capital 3,084,400 1,273,000 42,500 611,000 2,055,800 7,066,700 *Excluding depreciation expense Other non -departmental revenues: Interest income 230,000 Connection charges 380,000 Antenna lease revenue (excludes ECC allocatioi 664,600 Other 32,500 Total - non -dept revenue 1,307,100 Net cash inflow (outflow) $ (4,010,400) City of Eapn 2017 Proposed Budget Operating Budget 2017 Budget PUBLIC UTILITIES ENTERPRISE FUND Detail of Revenues Actual Actual Budget Budget Acct 2014 2015 2016 2017 DEPARTMENTAL: Water 4505 Water Service Fees $ 4,310,146 $ 4,378,428 $ 4,800,000 5,041,500 4506 Water Service Penalties 28,212 29,012 30,000 30,000 4507 Water Connection Permits 8,432 4,280 8,000 8,000 4509 Sale of Meters 65,076 41,500 40,000 40,000 4511 Sale of Property 12,234 - 2,000 2,000 4512 Water Turn Off/On Fee 13,524 12,632 9,000 12,000 4521 Constr Meter Permits 2,100 4,540 1,200 2,000 4536 Water Meter Surcharge - non-insp 8,550 6,300 0 4,448,274 4,476,692 4,890,200 5,135,500 Sanitary Sewer 4530 Sanitary Sewer Service Fees 6,364,722 6,223,240 6,726,000 6,932,600 4531 Sanitary Sewer Penalties 32,684 33,884 25,000 31,000 4532 San Sewer Connection Permits 9,000 5,116 8,000 8,000 4534 1/1 Surcharge - Non -inspection 43,950 18,900 3,000 10,000 4535 1/1 Surcharge - Non -correction 14,550 8,100 - 0 6,464,906 6,289,240 6,762,000 6,981,600 Street Lights 4550 Neighborhood Light Svc Fees 417,292 442,478 435,000 446,100 4551 Neighbrhd/Comm Lt Penalties 3,766 4,179 3,000 3,500 4560 Community Light Service Fees 252,836 270,275 256,000 272,100 673,894 716,932 694,000 721,700 Storm Drainage/Water Quality 4540 Storm Drainage Service Fees 1,414,162 1,562,052 2,440,000 2,486,500 4541 Storm Drainage Penalties 5,432 6,236 4,000 4,500 4226 Developer Escrow Reimbursmt 18,030 26,529 35,000 30,000 4672 Water Quality Dedication Fees 10,000 - 10,000 10,000 1,447,624 1,594,817 2,489,000 2,531,000 NON -DEPARTMENTAL: 4031 Assmt Penalties and Interest 9,765 6,011 5,000 6,000 4140 State Grants 62,344 66,800 - 0 4160 State PERA Aid 4,442 4,442 4,400 4,40.0 4176 County Cost Participation Agreement - _ - 0 City of Eapo 2017 Proposed Budget Operating Budget 2017 Budget PUBLIC UTILITIES ENTERPRISE FUND Detail of Revenues - cont'd Actual Actual Budget Budget Acct 2014 2015 2016 2017 4175 County Grants - 37,949 - - 4228 Eng / Financial Information 258 553 300 300 4230 Printed Material/Other Fees 222 504 - 0 4242 Maint Equipment and Personnel 3,781 9,361 8,900 8,900 4243 Manual Reading-Ded Bill Meters 630 1,040 600 600 4305 Equipment Rental - 230 - 0 4511 Sale of Property - Other - 9,340 - 0 4610 Interest on Investments 291,842 266,524 170,000 180,000 4612 Interest on Assessments 50,754 57,620 50,000 50,000 4613 Interest on Interfund Receivable - - - 0 4615 Change in Fair Value of Inv 207,183 (19,800) - 0 4617 Antenna Lease Admn Fees 3,000 28,800 100,000 3,000 4618 Site Survey / Eng Applic Review 8,250 4,600 4,300 4,300 4619 Antenna Lease Landscape Escow - 3,200 5,000 5,000 4620 Antenna Site Rent (excludes ECC) 619,072 613,610 528,400 664,600 4658 Vehicle Sales 22,661 - - 0 4675 Wetlands ConservAppl Fee - 600 - 0 4680 Connection Charge--Water 230,609 202,847 150,000 200,000 4685 Conn Chg--WaterTreatmt Plant 313,619 43,831 180,000 180,000 4691 Other Revenue 776 20,238 - 0 4822 Other Reimbursements 64,239 343,796 0 1,893;448 1,702,096 1,206,900 1,307,100 GRAND TOTAL $ 14.928.146 S 14.779.777 S 16.042.100 16.676.900 4-== 2017 Proposed Budget Operating Budget City of Eap Public Utilities — Water (61) Responsible Manager: Jon Eaton, Superintendent of Utilities PURPOSE & DESCRIPTION The purpose of the Public Utilities — Water Department is to: • Produce, treat, store and distribute safe and clean potable water for the City of Eagan. • Continuously monitor the quality of the drinking water supply and maintain compliance to all State and Federal requirements. • Provide skilled and trained personnel to operate and maintain the water supply/treatment/storage/distribution, sewer collection, and storm drainage conveyance systems. The Public Utilities — Water Department is responsible for the following functions: • Inspect and maintain the water distribution system, including point -of -use metering. • Inspect and maintain the storm water conveyance system and assist with natural resources water quality objectives. • Supply and treat all potable water needed within the City including sampling, testing and chemical treatment to assure water quality that meets or exceeds State and Federal health standards. Inspect and maintain storage facilities, wells, and pressure control stations. • Respond to customer needs on a daily basis and be available on a 24/7 basis for emergencies. • Assist other departments when needed. PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Estimate Target Water main breaks/Service Leaks 12 26 10 10 Millions of gallons of safe drinking water produced 2,879 2,885 3,100 3,100 Residential per capita usage 79 78 75 75 MN Dept. of Health samples collected 840 840 840 840 Backflow preventers tested 677 543 600 600 Meter service calls 742 889 800 800 Customer service calls 2,654 3,625 3,800 3,800 Hydrants flushed 661 661 600 600 Hydrants painted 535 585 600 600 Locates performed 9,173 9,106 8,400 8,400 - City ofEap 2017 Proposed Budget Operating Budget Public Utilities — Water (61) Responsible Manager: Jon Eaton, Superintendent of Utilities HIGHLIGHTS & CHANGES Overview: The 2017 proposed Water Utility budget shows an overall increase of $1,675,100 or 26.2% from the 2016 budget. The non -personnel operations budget (excludes labor and capital) increased by $200,400 or 7.4% with the majority of the overall increases outlined below. Capital improvements have a total cost of $3,084,400 for 2017, an increase of $1,218,600 over 2016. Highlight/Change 1: Interest in the reduction of groundwater demand, including municipal drinking water systems, has been heightened recently. With irrigation being one of the largest uses of water supplied by the City, all of it being treated groundwater, the City, along with Metropolitan Council Environmental Services staff, has investigated the capture or reuse of up to 1 million gallons of groundwater being dewatered daily as part of the operations of the Seneca Waste Water Treatment Plant for distribution as irrigation to the industrial area around the plant. The 2017 CIP includes the first phase of a 3 -year plan to construct a proposed collection and distribution system for this non -potable water. City staff believe the proposed cost can be significantly offset through the acquisition of substantial grants due to the attractive nature of the improvements in the current grant environment. Financial Impact: $1,000,000 CIP Service Level Impact: Provides opportunity to reduce current water production and enhance sustainability of groundwater supply utilized by City's water system. Highlight/Change 2: The Utility Building Operations/Repair line item (#6427) has increased $176,500. The expenses are for lighting upgrades and replacing failing infrastructure (HVAC controlling hardware, high service pump actuators and check valves, and repair of a significant filter cell leak at NWTP). Financial Impact: $176,500 increase. Service Level Impact: None, maintains current water production service level. Highlight/Change 3: Electrical (#6409) and natural gas (#6410) market pricing continue to hold steady but the utilities have increased their costs annually to cover operational increases. The budget uses a three-year actual expense average to determine the future budgeted expense. Financial Impact: $25,100 increase Service Level Impact: None. Highlight/Change 4: The City's obligation to complete a Comprehensive Guide Plan update includes the updates of the plans for the various utility systems within the city. In acknowledgement of the City's stewardship role with regards to its use of groundwater, the incorporation of a universal approach to the development of the comprehensive plans for all of the utilities systems, water, sanitary sewer, storm sewer, will require an enhanced comprehensive collective analysis of all of the utility systems, an effort not provided on previous comprehensive plans. Financial Impact: $150,000 Service Level Impact: Meets requirements of the Metropolitan Land Planning Act and provides enhanced management potential for providing sustainable groundwater usage. Y� City of Eapn 2017 Proposed Budget Operating Budget Public Utilities - Water (61) Responsible Manager: Jon Eaton, Superintendent of Utilities EXPENSE SUMMARY POSITION INVENTORY Personnel Actual Actual Budget Budget Expenses 2014 2015 2016 2017 Personal Services $ 1,482,886 $ 1,542,126 $ 1,771,400 $ 1,864,000 Parts and Supplies 383,384 383,809 450,800 454,300 Services and Other Charges 1,510,423 1,551,898 1,520,700 1,881,100 Merchandisefor Resale - - 21,300 21,300 Capital Outlay 1,247,960 1,341,177 1,865,800 3,084,400 Transfer Out 756,600 1,019,924 774,500 774,500 Total Operating Expenses $ 5,381,253 $ 5,838,934 $ 6,404,500 $ 8,079,600 Depreciation Expense $ 2,309,855 $ 2,372,122 2,271,700 2,271,700 POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Superintendent 0.67 0.67 0.67 0.67 1,394 Water Production/Treatment Supervisor 1 1 1 1 2,080 Utility Field Operations Supervisor 0.33 0.33 0.33 0.33 686 Utilities Inspector 1 1 1 1 2,080 GIS Specialist 1 0.92 1 1 2,080 GIS Coordinator 0.61 0.61 0.61 0.61 1,269 GIS Technician 1 1 1 1 2,080 Utility Technician 0.5 0.5 0.5 0.5 1,040 Water Treatment/Production Workers 4 4 4 4 8,320 System Maintenance Workers 3 5 5 5 10,400 Administrative Assistant (System Analyst) 1 1 0 0 - Clerical Tech IV 0 0 1 1 2,080 Public Works Director 0.24 0.24 0.24 0.24 499 UB/SA Accounta nt 0.61 0.61 0.61 0.61 1,269 UB/SA Clerk 0.61 0.61 0.61 0.61 1,269 Senior Instrumentation Technician 0 1 1 1 2,080 Total 15.57 18.49 18.57 18.57 38;626 2017 WORK PLAN Activity Routine 1 Water Admi nistration 2 Water Field Operation/Repair 3 Erosion control 4 GIS/GPS Administration 5 Treatment Plant/Production 6 Emergency call outs AP� City o gall 2017 Proposed Budget Operating Budget Public Utilities - Water (61) Responsible Manager: Jon Eaton, Superintendent of Utilities LINE ITEM DETAIL Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 1,060,070 $ 1,095,184 $ 1,216,600 $ 1,299,500 6112 OVERTIME -REGULAR 24,982 13,801 60,200 65,300 6130 SALARIES AND WAGES -TEMPORARY 34,452 39,750 32,500 32,800 6142 PERA-COORDINATED 77;493 83,332 95,800 102,400 6144 FICA 80,623 82,512 100,200 106,900 6151 HEALTH INSURANCE 167,227 185,706 232,100 220,000 6152 LI FE 1,727 1,629 - - 6154 DISABILITY - LONGTERM 3,247 3,124 - - 6155 WORKERS COMPENSATION 33,065 37,088 34,000 37,100 TOTAL PERSONAL SERVICES 1,482,886 1,542,126 1,771,400 1,864,000 PARTS & SUPPLIES 6210 OFFICE SUPPLIES $ 3,317 $ 2,566 $ 3,500 $ 3,500 6212 OFFICE SMALL EQUIPMENT 299 98 100 100 6215 REFERENCE MATERIALS 64 81 300 300 6220 OPERATING SUPPLIES -GENERAL 2,277 3,177 3,000 3,200 6222 MEDICAL/RESCUE/SAFETY SUPPLIES 2,274 3,362 5,400 5,800 6223 BUILDING/CLEANING SUPPLIES 2,374 3,274 4,000 4,000 6224 CLOTHING/PERSONAL EQUIPMENT 4,743 4,214 5,900 5,900 6230 REPAIR/MAINTENANCE SUPPLIES -GENERAL 1,786 2,955 5,000 5,000 6231 MOBILE EQUIP REPAIR PARTS 2,211 3,910 5,600 5,600 6232 SMALL EQUIPMENT REPAIR PARTS 294 797 500 500 6233 BUILDING REPAIR SUPPLIES 7,303 24,492 10,000 20,000 6235 FUEL, LUBRICANTS, ADDITIVES 19,529 18,190 28,900 28,900 6240 SMALLTOOLS 5,873 5,842 6,000 6,000 6244 CHEMICALS & CHEMICAL PRODUCTS 81,004 91,917 96,000 103,000 6250 LANDSCAPE MATERIAL & SUPPLIES - - 2,000 2,000 6255 STREET REPAIR SUPPLIES 5,140 13,321 15,000 15,000 6257 SIGNS & STRIPING MATERIAL - - 500 500 6260 UTILITYSYSTEM PARTS/SUPPLIES 127,657 84,594 136,000 139,500 6270 COMPUTER SOFTWARE 117,239 121,019 123,100 105,500 TOTAL PARTS & SUPPLIES 383,384 383,809 450,800 454,300 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES -GENERAL $ 188,387 $ 248,333 $ 205,800 $ 350,400 6311 LEGAL - 26,674 - - 6314 AUDITING 7,100 7,300 7,300 7,300 6323 TESTING SERVICES 9,709 9,033 10,800 10,800 6346 POSTAGE 2,652 2,000 3,100 3,100 6347 TELEPHONE SERVICE & LINE CHG 22,779 24,031 26,000 26,000 6351 PAGER SERVICE FEES 133 132 - - 6352 TELEPHONE CIRCUITS 1,629 1,629 1,800 1,800 6353 PERSONAL AUTO/PARKING 64 7 100 100 6355 CELLULAR TELEPHONE SERVICE 4,317 4,543 4,400 4,600 6356 ONE CALL SERVICE FEE - - 6,700 - 6357 ADVERTISING/PUBLICATIONS 40 100 6358 EMPLOYMENT ADVERTISING 100 6359 LEGAL NOTICE PUBLICATION - - 100 - 6370 GENERAL PRINTING AND BINDING 402 192 3,700 3,700 pw City of Eap 2017 Proposed Budget Operating Budget Public Utilities - Water (61) Responsible Manager: Jon Eaton, Superintendent of Utilities LINE ITEM DETAIL (CONT�D) SERVICES & OTHER CHARGES 6385INSURANCE 6408 ELECTRICITY -LI FT STATIONS 6409 ELECTRICITY-WELLS/BOOSTER STN 6410 NATURAL GAS SERVICE 6425 MOBILE EQUIPMENT REPAI R LABOR 6426 SMALL EQUIPMENT REPAIR 6427 BLDG OPERATIONS/REPAIR-LABOR 6429 STREET REPAI R -LABOR 6430 COMMUNICATION SYSTEM REPAIR 6432 UTILITYSYSTEM REPAIR -LABOR 6457 MACHINERY&EQUIPMENT RENTAL 6475 MISCELLANEOUS 6476 CONFERENCES AND SCHOOLS 6477 LOCAL MEETING EXPENSE 6478 TUITION AND BOOK REIMBURSEMENT 6479 DUES AND SUBSCRIPTIONS 6480 LICENSES, PERMITS AND TAXES 6487 VISA/MC BANK CHARGES 6805 TRANSFER OUT 6535 OTHER CONTRACTUAL SERVICES 6537 JANITORIAL SERVICE 6539 WASTE REMOVAL/SANITATION SERV 6569 MAINTENANCE CONTRACTS 6575 MCES DISPOSAL CHARGES OTHER SERVICES AND CHARGES MERCHANDISE FOR RESALE 6855 MERCHANDISE FOR RESALE MERCHANDISE FOR RESALE TOTAL OPERATING CAPITAL OUTLAY 6660 OFFICE FURNISHINGS & EQUIPMENT 6670 OTHER EQUIPMENT 6680 MOBILEEQUIPMENT CAPITAL OUTLAY CAPITAL/CONSTRUCTION PROJECTS 6630 RENEWAL& REPLACEMENT -OUTLAY 6700 CONSTRUCTION PROJECTS TOTAL CAPITAL TOTAL WATER DEPARTMENT DEPRECIATION 6488 DEPRECIATION EXPENSE Actual Actual Budget Budget 2014 2015 2016 2017 $ 79,600 $ 79,600 $ 79,600 79,600 3,170 10,501 - - 696,692 642,226 752,800 776,100 134,290 93,779 99,200 101,000 535 3,116 1,000 1,000 2,213 3,312 1,500 1,500 25,555 72,523 37,500 214,000 7,300 - 10,000 10,000 - - - 20,000 177,872 178,500 110,000 110,000 708 - 1,000 1,000 - 51 - - 12,591 11,261 23,000 27,200 47 40 200 200 - - 2,100 2,100 14,772 13,407 13,800 14,200 46,899 40,843 48,600 48,600 5,432 11,184 3,600 - 756,600 1,019,924 774,500 774,500 45,987 47,918 38,000 38,000 9,416 9,698 5,100 5,100 - 377 1,100 1,100 7,814 2,526 11,600 11,600 2,318 7,162 11,000 11,000 2,267,023 2,571,822 2,295,200 2,655,600 21,300 21,300 - 21,300 21,300 4,133,293 4,497,757 4,538,700 4,995,200 10.1 3,058 2,436 - - 7,094 2,236 13,900 13,900 - 2,095 38,000 60,000 10,152 6,767 51,900 73,900 1,234,650 1,268,465 1,263,900 459,000 3,158 65,945 550,000 2,551,500 1,237,808 1,334,410 1,813,900 3,010,500 1,247,960 1,341,177 1,865,800 3,084,400 65.3° $ 5,381,253 $ 5,838,934 $ 6,404,500 $ 8,079,600 26.2 21309,855 2,372,122 2,271,700 2,271,700 am7 2017 Proposed Budget Operating Budget City o Eap is I Public Utilities — Sewer (62) Responsible Manager: Jon Eaton, Superintendent of Utilities PURPOSE & DESCRIPTION The purpose of the Public Utilities — Sewer Department is to: • Provide uninterrupted sanitary sewer conveyance services for the City. • Meet all State and Federal standards in waste water management. • Provide skilled and trained personnel to operate and maintain the water distribution system, sewer collection/conveyance, and storm drainage conveyance systems. The Public Utilities — Sewer Department is responsible for the following functions: • Maintain sanitary sewer collection and conveyance system including pipes, manholes, and lift stations. • Report to all State and Federal agencies required by law. • To inspect and maintain the waste water collection system and ensure its sanitary conveyance to the Metropolitan Treatment Facility at Seneca. • To inspect and maintain the storm water conveyance system and assist with natural resources water quality objectives. • Respond to customer needs on a daily basis and be available on a 24/7 basis for emergencies. • Assist other departments as directed. PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Estimate Target Televised sewer pipe, in feet 23,336 29,251 80,000 80,000 Sewer pi pe jetted, in miles 61 46 100 100 Sewer pi pe rel i ned, i n feet 7,269 7,544 7,500 7,500 Sewer Connections 19,656 19,739 19,800 19,800 41 City of Hap 2017 Proposed Budget Operating Budget Public Utilities — Sewer (62) Responsible Manager: Jon Eaton, Superintendent of Utilities HIGHLIGHTS & CHANGES Overview: The proposed 2017 Sewer operating budget shows an overall increase of $393,200 or 6.1% from the 2016 budget. The majority of the increase comes from the estimated increase in MCES expense for sanitary water treatment and capital projects. Capital improvements have a total cost of $1,184,000 for 2017, an increase of $385,000 over 2016. Highlight/Change 1: The Metropolitan Council Environmental Services (MCES) operates and maintains the large, intercommunity sanitary sewers and related facilities (640 miles of pipe, 61 lift stations, 188 meter stations) necessary to collect and transport wastewater from community sewer systems to eight regional wastewater treatment plants in the Twin Cities area. The associated MCES Wastewater Disposal charges (#6575) are projected to increase from 2016 fees. The fees are established by MCES and allocated to cities for sewage treatment based on their proportionate share of the metro wide total flow. Financial Impact: $198,200 increase Service Level Impact: None. Highlight/Change 2: The City's obligation to complete a Comprehensive Guide Plan update includes the updates of the plans for the various utility systems within the city. In acknowledgement of the City's stewardship role with regards to its use of groundwater, the incorporation of a universal approach to the development of the comprehensive plans for all of the utilities systems, water, sanitary sewer, storm sewer, will require an enhanced comprehensive collective analysis of all of the utility systems, an effort not provided on previous comprehensive plans. Financial Impact: $79,000 Service Level Impact: Meets requirements of the Metropolitan Land Planning Act and provides enhanced potential for reducing groundwater usage through the use of alternative sources. City of Eap 2017 Proposed Budget Operating Budget Public Utilities - Sewer (62) Responsible Manager: Jon Eaton, Superintendent of Utilities EXPENSE SUMMARY POSITION INVENTORY Personnel Actual Actual Budget Budget Expense 2014 2015 2016 2017 Personal Services $ 552,482 $ 564,096 $ 667,000 $ 718,900 Parts and Supplies 53,537 44,265 83,900 85,000 Services and Other Charges 4,800,309 4,850,834 5,288,800 5,629,000 Capital Outlay 138,189 309,219 888,000 1,273,000 Transfer Out 360,000 344,000 368,200 368,200 Total $ 5,904,517 $ 6,112,414 $ 7,295,900 $ 8,074,100 Depreciation Expense $ 806,232 $ 795,344 753,400 753,400 POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Superintendent 0.33 0.33 0.33 0.33 686 Utilities Operations Supervisor 0.67 0.67 0.67 0.67 1,387 Utility Technician 0.5 0.5 0.5 0.5 1,040 System Maintenance Workers 4 4 4 4 8,320 Public Works Director 0.12 0.12 0.12 0.12 250 GIS Coordinator 0.29 0.29 0.29 0.29 603 UB/SA Clerk 0.29 0.29 0.29 0.29 603 UB/SAAccountant 0.29 0.29 0.29 0.29 603 Total 6.49 6.49 6.49 6.49 13,492 2017 WORK PLAN Activity Routine 1 Sanitary sewer administration 2 Sanitary sewer field operation/repairmaintenance 3 1 & I mitigation 4 Emergency call outs City of hap 2017 Proposed Budget Operating Budget Public Utilities - Sewer (62) Responsible Manager: Jon Eaton, Superintendent of Utilities LINE ITEM DETAIL Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 398,493 $ 408,159 $ 428,500 $ 476,800 6112 OVERTIME -REGULAR 11,695 4,011 22,900 24,800 6130 SALARIES AND WAGES -TEMPORARY 3,119 2,689 32,500 32,800 6142 PERA-COORDINATED 29,502 31,114 33,900 37,600 6144 FICA 29,973 30,516 37,000 40,900 6151 HEALTH INSURANCE 63,361 68,563 82,800 72,900 6152 LIFE 610 624 - - 6154 DISABILITY - LONGTERM 1,140 1,168 - 6155 WORKERS COMPENSATION 14,589 17,252 29,400 33,100 6157 RETIREE INSURANCE FUNDING - - - TOTALPERSONALSERVICES 552,482 564,096 667,000 718,900 PARTS & SUPPLIES 6210 OFFI CE SUPPLI ES $ 406 $ 900 $ 2,000 $ 2,000 6212 OFFICE SMALL EQUI PMENT 399 - - - 6215 REFERENCE MATERIALS 56 - 200 200 6222 MEDICAL/RESCUE/SAFETY SUPPLIES 2,603 607 2,600 3,100 6223 BUILDING/CLEANING SUPPLIES 11 49 300 300 6224 CLOTHING/PERSONAL EQUI PMENT 2,547 2,191 2,600 2,600 6230 REPAI R/MAI NTENANCE SUPPLI ES -GENERAL 302 2,291 2,500 2,500 6231 MOBILE EQUIP REPAIR PARTS 12,367 2,785 16,600 16,600 6232 SMALL EQUI PMENT REPAI R PARTS 48 2,444 500 500 6235 FUEL, LUBRICANTS, ADDITIVES 27,004 21,239 30,100 30,100 6240 SMALLTOOLS 1,250 7,050 3,000 3,000 6250 LANDSCAPE MATERIALS & SUPPLIES - - 2,000 2,000 6255 STREET REPAI R SUPPLIES - - 1,000 1,000 6260 UTILITY SYSTEM PARTS/SUPPLIES 5,944 4,109 20,500 20,500 6270 COMPUTER SOFTWARE 600 600 - 600 TOTAL PARTS & SUPPLIES 53,537 44,265 83,900 85,000 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES -GENERAL 23,470 21,980 80,800 169,400 6314 AUDITING 7,100 7,300 7,300 7,300 6346 POSTAGE 2,619 2,050 3,100 3,100 6347 TELEPHONE SERVICE & LINE CHG 7,071 7,482 7,800 7,800 6352 TELEPHONE CIRCUITS 3,870 3,400 4,200 4,200 6353 PERSONAL AUTO/PARKING - - 100 100 6355 CELLULAR TELEPHONE SERVICE 2,836 3,431 2,800 2,900 6356 ONE CALL SERVICE FEES 13,283 11,319 6,700 13,900 6357 ADVERTISING/PUBLICATIONS 55 - 100 - 6358 EMPLOYMENT ADVERTISING - - 100 - 6359 LEGAL NOTICE PUBLICATION - - 100 - 6385 INSURANCE 14,100 14,100 14,100 14,100 6405 ELECTRICITY 1,196 1,134 - - 2017 Proposed Budget Operating Budget City of EaPo Public Utilities - Sewer (62) Responsible Manager: Jon Eaton, Superintendent of Utilities LINE ITEM DETAIL (CONT'D) Actual Actual Budget Budget SERVICES & OTHER CHARGES 2014 2015 2016 2017 6408 ELECTRICITY -LIFT STATIONS 23,489 23,958 26,000 27,300 6425 MOBILE EQUIPMENT REPAIR LABOR 8,171 (224) 10,000 10,000 6426 SMALL EQUIPMENT REPAIR 77 217 1,500 1,500 6428 FIELD/OTHER EQUIPMENT REPAIR -LABOR - 420 - - 6429 STREET REPAI R -LABOR - 5,000 5,000 6430 COMM. SYSTEM REPAIR -LABOR - - 5,000 5,000 6432 UTI LI TY SYSTEM REPAI R - LAB OR 16,081 45,892 52,500 52,500 6440 I/I MITIGATION - SUMP PUMP .15,104 593 20,000 20,000 6441 I/I MITIGATION - OTHER 19,065 20,608 63,000 63,000 6457 MACHINERY AND EQUIPMENT - - 1,000 1,000 6476 CONFERENCES AND SCHOOLS 2,614 2,256 8,500 8,600 6477 LOCAL MEETING EXPENSES - - 200 200 6479 DUES AND SUBSCRIPTIONS 48 1,022 1,100 1,100 6480 LICENSES, PERMITS AND TAXES 440 36 600 600 6487 VISA/MC BANK CHARGES 5,432 11,184 2,400 2,400 6805 TRANSFER OUT 360,000 344,000 368,200 368,200 6535 OTHER CONTRACTUAL SERVICES 21,839 57,354 2,000 2,100 6537 CLEANING CONTRACTUAL SERVICES - - 5,100 5,100 6539 WASTE REMOVAL/SANITATION SERVICES - - 1,100 1,100 6569 MAI NTENANCE CONTRACTS 1,171 300 1,500 1,500 6575 MCES DISPOSAL CHARGES 4,611,178 4,615,022 4,955,100 5,198,200 SERVICES & OTHER CHARGES 5,160,309 5,194,834 5,657,000 5,997,200 TOTAL OPERATING 5,766,328 5,803,195 6,407,900 6,801,100 6.1% CAPITAL OUTLAY 6670 OTHER EQUIPMENT 267 5,723 - 9,000 6680 MOBILE EQUIPMENT - - 35,000 80,000 CAPITALOUTLAY 267 5,723 35,000 89,000 CAPITAL/CONSTRUCTION PROJECTS 6630 RENEWAL& REPLACEMENT (BUDGET ONLY) 137,809 303,259 853,000 684,000 6700 CONSTRUCTION PROJECTS 113 237 - 500,000 137,922 303,496 853,000 1,184,000 TOTAL CAPITAL 138,189 309,219 888,000 1,273,000 43.4% TOTAL SEWER DEPARTMENT $ 5,904,517 $ 6,112,414 $ 7,295,900 $ 8,074,100 10.7% DEPRECIATION 6488 DEPRECIATION EXPENSE $ 806,232 $ 795,344 $ 753,400 $ 753,400 lip� City of Eap 2017 Proposed Budget Operating Budget Public Utilities — Street Lighting (63) Responsible Manager: Tim Plath, Transportation Operations Engineer PURPOSE & DESCRIPTION The purpose of the Public Utilities — Street Lighting Department is to: • Provide adequate lighting for public safety on city streets and at signalized intersections within the City of Eagan. • Provide the electrical power for the traffic control signals within the City of Eagan. • Coordinate the maintenance of the street lighting system for optimal performance. • Administer the maintenance of the traffic control signals' operation and infrastructure. The Public Utilities — Street Lighting Department is responsible for the following functions: • Coordinate the installation of street lights on all streets within City jurisdiction, both private developments and public improvements. • Address maintenance needs of the street lighting system & traffic control signals within the City, including light replacement, pole repair/refurbishment. • Provide field surveying, preparation of feasibility studies, reports and staff support at Council meetings for public improvements for street lights. • Manage the reimbursement of electrical services for street lighting and traffic signals. • Update Capital Improvement Program for the City's street light and traffic control signals. • Coordinate/present Public Hearings/Final Assessment Hearings for City improvements for street lights. PERFORMANCE INDICATORS Description Street Lights maintained (city -owned) New street lights installed (city -owned) Upgrade existing street lights (utility -owned) Traffic signals (city, county & state) Newtraffic signals installed (city, county & state) 2014 2015 2016 2017 Actual Actual Estimate Target 393 393 392 392 0 0 0 0 9 0 8 8 69 70 70 70 0 1 0 0 10� City of Hap 2017 Proposed Budget Operating Budget Expenditure by Category Capital Outlay Services 1°Ja Public Utilities — Street Lighting (63) Responsible Manager: Tim Plath, Transportation Operations Engineer HIGHLIGHTS & CHANGES Overview: The proposed Street Lighting budget shows a decrease of $308,500, or 31.1%. The majority of the decrease is due to reduced project costs offset by a slight increase in projected electricity costs. Highlight/Change 1: Electricity- Street Lights (#6406) and Electricity — Signal Lights (#6407) show slight increases in costs due to anticipated increases in electricity rates. Financial Impact: Increase of $39,900 Service Level Impact: None Highlight/Change 2: Costs for Renewal and Replacement — Capital Outlay (#6630) are significantly decreased from 2016 due to the completion of the City's first large-scale LED retrofit project in the Central Area. Financial Impact: Decrease $347,500 Service Level Impact: None I tv City of hap 2017 Proposed Budget Operating Budget Public Utilities — Street Lighting (63) Responsible Manager: Tim Plath, Transportation Operations Engineer EXPENSE SUMMARY POSITION INVENTORY Personnel Actual Actual Budget Budget Expenditure 2014 2015 2016 2017 Personal Services 9,300 9,000 9,700 10,100 Parts and Supplies - - - - Services and Other Charges 480,947 486,269 553,600 592,200 Transfers Out 37,300 35,700 38,100 38,100 Capital Outlay - - 390,000 42,500 Total $ 527,547 $ 530,969 $ 991,400 $ 682,900 Depreciation Expense $ 12,797 $ 19,280 $ 19,300 $ 19,300 POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Public Works Director 0.01 0.01 0.01 0.01 21 UB/SAAccountant 0.03 0.03 0.03 0.03 62 UB/SA Clerk 0.03 0.03 0.03 0.03 62 GIS Coordinator 0.03 0.03 0.03 0.03 62 Total 0.10 0.10 0.10 0.10 208 2017 WORK PLAN Activit Routine 1 Coordinate the installation of street lights on City streets through private developments or public improvements 2 Address maintenance needs of the City's street lighting system & traffic control signals 3 Provide field surveying, feasibi I ity stud ies/reports and staffs upport at Counci I meetings for public improvements for street I ights 4 Manage the reimbursement of electrical services for street lighting and traffic signals 5 . Update Capita I Improvement Program for City's street I ight and traffic control signa Is 6 Coordinate/present Public Hearings/Final Assessment Hearings for City improvements for street lights Cly �� a��n 2017 Proposed Budget Operating Budget �.� Public Utilities - Street Lighting (63) Responsible Manager; Tim Plath, Transportation Operations Engineer LINE ITEM DETAIL Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 7,300 $ 7,100 $ 7,400 $ 7,700 6142 PERA-COORDINATED 500 400 600 600 6144 FICA 600 500 600 600 6151 HEALTH INSURANCE 900 1,000 1,100 1,200 TOTAL PERSONAL SERVICES 9,300 9,000 9,700 10,100 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES -GENERAL 8,118 3,238 5,000 5;000 6406 ELECTRICITY -STREETLIGHTS 417,104 425,020 450,000 486,900 6407 ELECTRICITY -SIGNAL LIGHTS 20,626 23,203 23,600 26,600 6411 UTILITY SYSTEM STREETLIGHT INSTALLATIONS - 18 - - 6432 UTILITY SYSTEM REPAIR -LABOR 12,354 18,067 68,000 66,700 6805 TRANSFER OUT 37,300 35,700 38,100 38,100 6535 OTHER CO NTRACTUAL S ERVI CES 22,745 16,723 7,000 7,000 OTHER SERVICES AND CHARGES 518,247 521,969 591,700 630,300 TOTAL OPERATING $ 527,547 $ 530,969 $ 601,400 $ 640,400 6.5% Acct CAPITAL OUTLAY 6630 RENEWAL AND REPLACEMENT -OUTLAY - - 390,000 42,500 CAPITALOUTLAY 390,000 42,500 TOTAL CAPITAL 390,000 42,500 -89.10% TOTAL STREET LIGHTING DEPARTMENT $ 527,547 $ 530,969 $ 991,400 $ 682,900 -31.1 6488 DEPRECIATION EXPENSE $ 12,797 $ 19,280 $ 19,300 $ 19,300 City of Eap 2017 Proposed Budget Operating Budget Public Utilities — Storm Drainage (64) Responsible Manager: Jon Eaton, Superintendent of Utilities PURPOSE & DESCRIPTION The purpose of the Public Utilities — Storm Drainage Department is to: • Maintain the City's collection and conveyance system for excess surface water runoff. The Public Utilities — Storm Drainage Department is responsible for the following functions: • Inspect and maintain drainage system consisting of pipes, ponds and pumping stations. • Maintain the inlets and outlets for ponds including the removal of any erosion/siltation that restricts the flow or limits ponding capacities. • Respond to.emergency pumping station alarms or resident calls during major peak events. • Assist with Water Quality programs and objectives as necessary to meet Federal, State, and City standards and reporting requirements. PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Estimate Target Televised storm pipes, in feet .0 890 1,000 1,000 Grease Trap Inspections 98 0 150 150 Construction inspections performed 149 208 125 125 Ponds inspected 427 174 250 250 Control structures checked 890 572 600 600 Qaal) 2017 Proposed Budget Operating Budget City Public Utilities — Storm Drainage (64) Responsible Manager: Jon Eaton, Superintendent of Utilities HIGHLIGHTS & CHANGES Overview: The proposed 2017 Storm Drainage budget shows an overall increase of $398,000 or 58.8% from the 2016 budget. The operations portion of the budget increased by 37.8%, with the significant increases highlighted below. Capital improvements have a total cost of $611,000 for 2017, an increase of $271,000 over 2016. Highlight/Change 1: Electrical and natural gas market pricing continue to hold steady but the greater variability in climate, especially extreme rain events, have increased the lift station usage_. The budget uses a three-year actual expense average to determine the future budgeted expense. Financial Impact: $2,700 increase Service Level Impact: None. Highlight/Change 2: The City's obligation to complete a Comprehensive Guide Plan update includes the updates of the plans for the various utility systems within the city. The storm drainage component of the plan update will require a complete revision of the associated model due to the recent Atlas 14 precipitation frequency revisions implemented for calculating storm event runoff. An example of the significance of this change is the 25% increase in the standard 1% (100 -year) storm event rainfall amount. The past value was 6" per 24hour period, where the new standard is 7.5". In acknowledgement of the City's stewardship role with regards to its use of groundwater, the incorporation of a universal approach to the development of the comprehensive plans for all of the utilities systems, water, sanitary sewer, storm sewer, will also require an enhanced comprehensive collective analysis of all of the utility systems, an effort not provided on previous comprehensive plans. Financial Impact: $115,000 Service Level Impact: Meets requirements of the Metropolitan Land Planning Act and brings storm drainage model up to current design standards (Atlas 14). " City of Eap 2017 Proposed Budget Operating Budget Public Utilities — Storm Drainage (64) Responsible Manager: Jon Eaton, Superintendent of Utilities EXPENDITURE SUMMARY POSITION INVENTORY Personnel Actual Actual Budget Budget Expenditure 2014 2015 2016 2017 Personal Services $ 117,578 $ 109,894 $ 107,600 $ 115,700 Parts and Supplies 7,808 3,259 9,700 11,900 Services and Other Charges 209,933 159,413 193,600 310,300 Transfers Out 25,100 23,700 25,400 25,400 Capital Outlay 43,619 136,228 340,000 611,000 Total $ 404,038 $ 432,494 $ 676,300 $ 1,074,300 Depreciation Expense $ 1,034,157 $ 1,034,157 $ 1,041,600 $ 1,041,600 POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Operations Maintenance Worker 1 1 1 1 2,080 Public Works Director 0.01 0.01 0.01 0.01 21 UB/SA Clerk 0.02 0.02 0.02 0.02 42 UB/SAAccountant 0.02 0.02 0.02 0.02 42 GIS Coordinator 0.02 0.02 0.02 0.02 42 Total 1.07 1.07 1.07 1.07 2,226 2017 WORK PLAN Activity Routine 1 Inspection/clean-up of structures 2 Liftstation maintenance 3 Weed harvesting 4 Water quality support 5 Aeration 6 Storm response NJ � �a�an 2017 Proposed Budget Operating Budget Public Utilities - Storm Drainage (64) Responsible Manager: Jon Eaton, Superintendent of Utilities LINE ITEM DETAIL TOTAL STORM DRAINAGE DEPARTMENT $ 404,038 $ 432,494 $ 676,300 $ 1,074,300 58.8% DEPRECIATION 6488 DEPRECIATION EXPENSE $ 1,034,157 $ 1,034,157 $ 1,041,600 $ 1,041,600 Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 75,949 $ 69,233 $ 59,300 $ 68,000 6112 OVERTIME -REGULAR 2,493 1,034 5,300 5,700 6130 SALARIES AND WAGES -TEMPORARY 10,838 13,225 13,200 13,300 6142 PERA-COORDINATED 5,503 5,222 4,800 5,500 6144 FICA 6,133 6,092 6,000 6,700 6151 HEALTH INSURANCE 13,338 11,717 13,400 10,200 6152 LIFE 131 110 - - 6154 DISABILITY - LONGTERM 244 203 - - 6155 WORKERS COMPENSATION 2,949 3,058 5,600 6,300 TOTAL PERSONAL SERVICES 117,578 109,894 107,600 115,700 PARTS & SUPPLIES 6210 OFFICE SUPPLIES - 60 - - 6224 CLOTHING/PERSONAL EQUIPMENT 447 604 700 700 6230 REPAIR/MTNSUPPLIES-GENERAL - 17 - 300 6233 BUILDING REPAIR SUPPLIES 17 - 6235 FUEL, LUBRICANTS, ADDITIVES - 6 400 6240 SMALLTOOLS 43 100 500 6255 STREET REPAIR SUPPLIES 1,128 - - 1,000 6260 UTILITY SYSTEM PARTS/SUPPLIES 6,190 2,455 9,000 9,000 TOTAL PARTS & SUPPLI ES 7,808 3,259 9,700 11,900 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES -GENERAL 4,477 3,018 5,000 120,000 6311 LEGAL - 333 - - 6385 INSURANCE 3,900 3,900 3,900 3,900 6408 ELECTRICITY -LI FT STATIONS 157,799 113,862 131,800 134,500 6428 FIELD/OTHER EQUIPMENT REPAIR -LABOR - - 1,000 - 6432 UTILITYSYSTEMREPAIR - LABOR 43,375 37,207 50,000 50,000 6457 MACHINERYAND EQUIPMENT 56 342 1,000 1,000 6476 CONFERENCES AND SCHOOLS 200 340 400 400 6480 LICENSES, PERMITSAND TAXES 126 - - - 6805 TRANSFER OUT 25,100 23,700 25,400 25,400 6539 WASTE REMOVAL/SANITATIONSERVICE - 500 500 6569 MAINTENANCE CONTRACTS - 411 - - OTHER SERVICES AND CHARGES 235,033 183,113 219,000 335,700 TOTAL OPERATING 360,419 296,266 336,300 463,300 37.8% CAPITAL CONSTRUCTION/PROJECTS 6630 RENEWAL AND REPLACEMENT -OUTLAY 43,619 136,228 340,000 611,000 TOTAL CAPITAL 43,619 136,228 340,000 611,000 79.7% TOTAL STORM DRAINAGE DEPARTMENT $ 404,038 $ 432,494 $ 676,300 $ 1,074,300 58.8% DEPRECIATION 6488 DEPRECIATION EXPENSE $ 1,034,157 $ 1,034,157 $ 1,041,600 $ 1,041,600 Icy of bap 2017 Proposed Budget Operating Budget Public Utilities — Water Quality (65) �� 5 Responsible Manager: Eric Macbeth, Water Resources Manager PURPOSE & DESCRIPTION The purpose of the Public Utilities — Water Quality Department is to: • Protect and improve natural, aesthetic, and recreational qualities of Eagan lakes and wetlands for enjoyment and use by residents of the City and region. The Public Utilities — Water Quality Department is responsible for the # R 3 following functions: �.� • Direct implementation of Eagan Water Quality Management Plan. • Ensure City compliance with Minnesota Wetland Conservation Act rules. • Coordinate City compliance with Minnesota storm -water discharge permit and impaired water regulations. • Monitor and manage water resources and other land use activities directly or indirectly affecting water resources. • Educate community about land and water issues relating to water quality, lakes, and wetlands. • Coordinate among city, county, state, and federal entities to protect and improve water resources. PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Estimate Target Lakes, wetlands monitored in long-term program 14 14 11 14 Lakes aerated in winter for fisheries 13 13 13 13 Lakes monitored for fish populations 2 2 3 1 Loads of aquatic plants removed from lakes 70 60 50 60 Lakes of study/planning efforts 12 12 0 0 Climb Theatre performances in K-12 schools 4 4 4 4 Youth Fishing Program participants 75 80 90 80 Biennial LakeFest attendees 300 0 300 0 r 2017 Proposed Budget Operating Budget Y City o Faun .... � Expenditure by Category Services and other charges 8%Nt � Parts and supplies Public Utilities — Water Quality (65) Responsible Manager: Eric Macbeth, Water Resources Manager HIGHLIGHTS & CHANGES Overview: The proposed 2017 Water Quality budget continues recent initiatives to increase emphasis on lake improvements and lake protection, while expanding capabilities to review plans, oversee implementation, and verify compliance with City of Eagan stormwater management regulations. The budget has an increase of $1,131,200 or 68.8%. Although it includes a one-time cost of $33,000 for professional services to update the 2007 Water Quality & Wetland Management Plan, as part of the City's comprehensive plan process, the proposed non -personnel operating budget is only up $11,400, or 1.6%, over 2016. Without this one- time cost, this budget would propose a $21,600 decrease (-3.0%), compared to last year. Highlight/Change 1: Chemicals & Chemical Products reduction is primarily related to the use of liquid alum for the Fish Lake system, based on historical, anticipated need. Financial Impact: $18,200 decrease (6244) Service Level Impact: None Highlight/Change 2: Professional Services -General increase is primarily due to a required update of the 2007 Water Quality & Wetland Management Plan, as part of the City's Comprehensive Plan Update 2040. Financial Impact: $14,000 increase (6310) Service Level Impact: Further refine and enhance Water Resources operations and management of City's surface water resources. 1�City of ERpn 2017 Proposed Budget Operating Budget Public Utilities - Water Quality (65) Responsible Manager: Eric Macbeth, Water Resources Manager EXPENDITURE SUMMARY Expenditure Personal Services Parts and Supplies Services and Other Charges Other Transfers Out Capital Outlay Total Depreciation Expense POSITION INVENTORY Personnel Water Resources Manager Water Resources Specialist Water Resources Technician Operations Support Specialist Clerical Technician Public Works Director UB/SA Accounta nt UB/SA Cl erk GIS Coordinator Total 2017 WORK PLAN Actual Actual Budget Budget 2014 2015 2016 2017 $ 366,103 $ 376,036 $ 391,800 $ 394,700 58,383 65,133 68,300 47,800 257,153 281,791 195,600 211,500 3,080 3,080 3,100 3,100 62,100 59,300 63,500 63,500 587,526 245,593 922,900 2,055,800 $ 1,334,345 $ 1,030,933 $ 1,645,200 $ 2,776,400 $ 97,838 $ 117,441 $ 95,700 $ 117,400 2014 2015 2016 2017 1 1 1 1 1 1 1 1 1 1 1 1 0.5 0.5 0.5 0.5 0.5 0.5 0 0 0.02 0.02 0.02 0.02 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 4.17 4.17 3.67 3.67 Activity Routine 1 Program administration/staff supervision/operations & clerical support 2 Monitor& manage water resources and relevant land use activities 3 Monitor/coordi nate requi red TMDL i mpl ementation pl ans 4 Enhance recreational fishing; assess ecological conditions 5 Manage grant projects/initiate new proposals 6 Public education/involvement 7 Public relations/customer service 8 Interagency coordination/partnerships 9 Professional development/training 10 Coordinate required Stormwater Pollution Prevention Plan Hours 2,080 2,080 2,080 1,040 42 104 104 104 7,634 Alb� City ofEap 2017 Proposed Budget Operating Budget Public Utilities - Water Quality (65) Responsible Manager: Eric Macbeth, Water Resources Manager LINE ITEM DETAIL Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 272,330 $ 275,298 $ 281,400 $ 287,800 6112 OVERTIME -REGULAR - 15 - - 6130 SALARIES AND WAGES -TEMPORARY 7,217 8,828 9,300 8,900 6142 PERA-COORDINATED 19,460 20,540 21,100 21,600 6144 FICA 18,866 19,717 22,200 22,700 6151 HEALTH INSURANCE 41,900 44,952 51,000 46,800 6152 U FE 440 416 - - 6154 DISABILITY -LONGTERM 857 820 - - 6155 WORKERS COMPENSATION 5,033 .5,450 6,800 6,900 TOTAL PERSONAL SERVICES 366,103 376,036 391,800 394,700 PARTS & SUPPLIES 6210 OFA CESUPPLIES - 111 - - 6215 REFERENCE MATERIALS - 90 - - 6220 OPERATING SUPPLIES -GENERAL 1,155 2,829 2,600 2,800 6222 MEDICAL/RESCUE/SAFETY SUPPLIES 9 - 100 - 6224 CLOTHING/PERSONAL EQUIPMENT 328 773 600 600 6227 RECREATION EQUIPMENT/SUPPLIES 1,749 1,775 2,200 2,600 6231 MOBILE EQUIP REPAIR PARTS 10,628 10,573 9,700 9,200 6232 SMALL EQUIPMENT REPAIR PARTS 1,094 472 700 700 6234 FIELD/OTHER EQUIPMENT REPAIR 2,256 3,763 1,500 2,500 6235 FUEL, LUBRICANTS, ADDITIVES 11,939 10,082 14,700 12,100 6240 SMALLTOOLS 360 286 400 400 6244 CHEMICALS & CHEMICAL PRODUCTS 7,683 9,612 33,800 15,600 6250 LANDSCAPE MATERIAL & SUPPLIES 7,515 9,894 500 500 6257 SIGNS & STRIPING MATERIAL 766 531 1,200 800 6260 UTILITY SYSTEM PARTS/ SUPPLIES 12,666 13,555 - - 6270 COMPUTER SOFTWARE 235 787 300 - TOTAL PARTS & SUPPLIES 58,383 65,133 68,300 47,800 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES -GENERAL 176,202 123,362 57,000 71,000 6323 TESTING SERVICES 18,229 15,824 18,800 22,300 6328 SPECIAL EVENTS/ADMISSION FEES 1,716 - 2,500 - 6346 POSTAGE 34 67 - 100 6353 PERSONAL AUTO/PARKING 40 33 100 100 6355 CELLULAR TELEPHONE SERVICE 1,716 2,453 2,100 2,000 6359 LEGAL NOTICE PUBLICATION - 600 - - 6370 GENERAL PRINTING AND BINDING 264 1,715 1,300 1,000 CityQfa�BIl 2017 Proposed Budget Operating Budget Public Utilities - Water Quality (65) Responsible Manager: Eric Macbeth, Water Resources Manager LINE ITEM DETAIL (CONT'D) Actual Actual Budget Budget Acct SERVICES & OTHER CHARGES 2014 2015 2016 2017 6385 INSURANCE 8,000 8,000 8,000 8,000 6405 ELECTRICITY 4,120 2,786 4,000 4,000 6425 MOBILE EQUIPMENT REPAIR -LABOR 928 - - 200 6426 SMALL EQUIPMENT REPAIR -LABOR - - 200 6475 MISCELLANEOUS 6 106 - - 6476 CONFERENCES AND SCHOOLS 2,614 4,354 7,100 7,500 6477 LOCAL MEETING EXPENSES 20 12 - - 6479 DUES AND SUBSCRI PTI ONS 3,630 31657 3,900 5,400 6480 LICENSES, PERMITS AND TAXES 644 228 600 400 6495 WATERSHED MANAGEMENT ASSESSMNT 38,990 43,950 41,200 42,200 6805 TRANSFER OUT 62,100 59,300 63,500 63,500 6535 OTHER CONTRACTUAL SERVICES - 74,644 48,100 46,200 6569 MAINTENANCECONTRACTS - 900 900 OTHER SERVICES AND CHARGES 319,253 341,091 259,100 275,000 OTHER 6860 COST SHARI NG PAYMENTS 3,080. 3,080 3,100 3,100 OTHER 3,080 3,080 3,100 3,100 TOTAL OPERATING 746,819 785,340 722,300 720,600 -0.2 Acct CAPITAL OUTLAY 6630 OTHER IMPROVEMENTS 185,054 3,550 910,000 2,043,500 6640 MACHINERY/EQUIPMENT 2,602 3,932 3,300 2,800 6660 OFFICE FURNISHINGS & EQUIPMENT - - 2,000 - 6670 OTHER EQUIPMENT 4,098 2,364 7,600 9,500 6700 CONTRUCTION PROJECTS 395,772 235,747 - CAPITAL OUTLAY 587,526 245,593 922,900 2,055,800 TOTAL CAPITAL 587,526 245,593 922,900 2,055,800 122.8% TOTAL WATER QUALITY DEPARTMENT $ 1,334,345 $ 1,030,933 $ 1,645,200 $ 2,776,400 68.8% 6488 DEPRECIATION EXPENSE $ 97,838 $ 117,441 $ 95,700 $ 117,400 City of ��a>i 2017 Proposed Budget Operating Budget � This page left intentionally blank * lily of Eap 2017 Proposed Budget Operating Budget Civic Arena Responsible Managers: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager PURPOSE & DESCRIPTION The purpose of the Civic Arena is to: • Provide a positive environment for residents and guests of all ages to gather. • Encourage and help build a sense of community through a wide range of recreational and social opportunities. • Provide a high level of service, accessibility and professionalism to expand revenue options to ensure the viability of this resource to the community. The Civic Arena is responsible for the following functions: • Provide a wide variety of ice and dry floor related recreational opportunities for the public to enjoy. • Capture a high level of revenue to offset operational costs, debt repayment and. expand the retained earnings capacity to accommodate future growth and expansion. • Protect the city's community investment by maintaining the integrity and value of the building and its amenities. • Create a welcoming atmosphere and solicit input from users to best determine how to meet existing needs and identify future growth opportunities. • On-going analysis of existing operation and research to find ways to expand the opportunities offered year round in order to maximize the capital investment. PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Estimate Target Participants in skate school program 2,007 1,998 2,000 2,000 Summer hockey rental hours (June 1 -Aug 31) 913 1,081 900 1,000 Adult league team registrations 56 56 56 56 Dry floor events 6 6 7 7 Prime ice rental hours (Oct 15 - March 15) 3,129 3,110 3,000 3,000 Clay of Eap 2017 Proposed Budget Operating Budget Civic Arena Responsible Managers: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager HIGHLIGHTS & CHANGES Overview: The proposed 2017 operating budget is up $38,700 or 4.2% from 2016. This is primarily due to routine increases in personnel and maintenance contracts. The budget also reflects a $5 increase in prime -time and non -prime hourly ice/turf rates, to increase revenue but remain competitive with other area ice rinks. Highlight/Change 1: Electricity Cost are set to increase based on 2015 actual expenditures. Budget Impact: Increase of $11,000 (6405) Service Level Impact: The arena increased service levels by installing ice on the East rink one additional month earlier. Highlight/Change 2: Professional Development opportunities exist for staff to attend conferences/trainings at a national level. Budget Impact: $2,900 increase in line 6476. Service Level Impact: Education and networking with colleagues and vendors may improve service levels at the Civic Arena. Highlight/Change 3: Merchandise for Resale expenditures and corresponding revenue at the concession stand are proposed to be adjusted to 2015 levels. Budget Impact: $6,000 decrease to merchandise for resale Service Level Impact: No service levels are expected to be impacted. Highlight/Change 4: Budgeted staff time is proposed to be reallocated based on actual time spent for full-time staff. Budget Impact: $23,000 increase for personal service expenditures. Service level impact: No service level impact is expected as the budget is being aligned with where the employee time is spent. Highlight/Change 5: Renewal & Replacement (R&R) projects are reviewed annually to make sure they are needed and appropriately scheduled. The R&R items in need of replacement this year are listed below. Two items are from previous years that were not replaced on scheduled year. • Rental skate replacement - $5,500 • Equipment washing machine - $55,000 • Community room furniture- $8,000 • Arena softball equipment - $5,000 Financial Impact: All items have been budgeted through the Renewal and Replacement fund for the Civic Arena. Service Level Impact: All R&R items are replacements of current equipment in order to continue the high level of service that has been established. City of Eap 2017 Proposed Budget Operating Budget Civic Arena Responsible Managers: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager POSITION INVENTORY- CIVIC ARENA Personnel 2014 2015 2016 2017 Hours Campus Facilities Manager 0.67 0.67 0.67 0.67 1,394 Campus Facilities Operations Coordinator 1.00 1.00 1.00 1.00 2,080 Campus Facilities Maintenance Coordinator 0.50 0.50 0.50 0.60 1,248 Custodian 0.50 0.50 0.50 0.70 1,456 Clerical Technician 0.20 0.20 0.20 0.20 416 Skating School Coordinator 1.00 1.00 0.80 0.80 1,664 Total 3.87 3.87 3.67 3.97 8,258 The Civic Arena and Cascade Bay share a number of staff. The Cascade Bay staff complement is shown below: POSITION INVENTORY -CASCADE BAY Personnel 2014 2015 2016 2017 Hours Campus Facilities Manager 0.33 0.33 0.33 0.33 686 Campus Facilities Operations Coordinator 1.00 1.00 1.00 1.00 2,080 Campus Facilities Maintenance Coordinator 0.50 0.50 0.50 0.40 832 Custodian 0.50 0.50 0.50 0.30 624 Clerical Technician 0.40 0.40 0.40 0.40 832 Total 2.73 2.73 2.73 2.43 5,054 2017 WORK PLAN Activity Routine 1 Respond to public comments or requests via phone or in person 2 Daily maintenance of iceand cleaning of building 3 Managethe building infrastructure to ensure efficient, safe and clean environment 4 Develop promotional materials for facility 5 Recruit, hire, train and supervise temporary and parttime employees 6 Provide work direction to ensure high level of customer serviceis maintained 7 Managestaffschedulingandtrainingtomeetthedemandsofthe building 8 Provide support to the day-to-day concessions operation 9 Establish and manage skate school program and auxilliary events 10 Provide inputand directions pertainingto policies, budgetand general operation of CA 11 Develop and managecapital improvements and long range planning 12 Develop and manage policies & procedures that best meetthe needs of the community 49b� City ofEap 2017 Proposed Budget Operating Budget Civic Arena Responsible Manager: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager RENTAL RATES Mezzanine Rental Hourly 8- hour rental Resident 27/hour 2017 proposed Hourly Rates Non-resident ( source of data on other cities: staff phone survey of proposed rates for upcoming year). 60/hour Ice time Non-resident w/outside F & B 67/hour $500/8 hours Prime Non -prime Off-peak notes Burnsville 220 195 (neg) 95 BV can negotiate the non -prime St.Thomas Ice Arena 220 155 (neg) Non- prime is flexible rate Lakeville 225 160 (neg) Apple Valley 215 160 (neg) non -prime and off peak are negotiable. Farmington 220 160 Eagan 215 150 (neg) 125 Inver Grove Heights 210 145 South St. Paul 205 155 (neg) volume discounting Richfield 210 155 going up on 4/1/2017 Rosemount 205 125 Turf/Dry Floor Concreate Arena Floor Full Floor 95/hour 55/hour $650/day 1/2 floor 60/hour 30/hour 350/day Less than 24/hour notice 100/hour Mezzanine Rental Hourly 8- hour rental Resident 27/hour $200/8 hours Non-resident 31/hour $225/8 hours Resident w/outside F & B 60/hour $440/8 hours Non-resident w/outside F & B 67/hour $500/8 hours Community Room Eagan Hockey N/C Eastview Hockey N/C Eagan Figure Skating Club N/C Rental 20/hour Training Center Rooms Prime 27/hour Non -prime 15/hour Board Room Rate 15/hour All Dav Rental (7am-1 am) $250/day $300/day $500/day $600/day City of Ea��a .�2017 Proposed Budget Operating Budget Civic Arena Responsible Manager: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager REVENUE SUMMARY Acct REVENUES 4304 OTHER REVENUE 4305 EQUIPMENT RENTAL 4310 PARK PROGRAM REVENUE NON -TAX 4311 PARK PROGRAM REVENUE 4312 CONCESSION SALES 4314 MERCHANDISE SALES - TAXABLE 4315 MERCHANDISE SALES - NON TAXABLE 4320 MARKETING REVENUE 4322 VENDING (CITY OWNED) 4323 VENDING (VENDORS) 4324 ROOM RENTAL 4325 ROOM RENTAL NON -TAX 4326 FACILITY/ICE RENTAL 4327 FACILITY RENTAL NON -TAX 4657 SALE OF CITY PROPERTY 4663 CONTRIBUTIONS AND DONATIONS SUBTOTAL TOTAL CIVIC ARENA REVENUES EXPENDITURE SUMMARY Expenditure Personal Services Parts and Supplies Services and Other Charges Merchandise for Resale Capital Outlay Debt Service Total Depreciation Expense Actual Actual Budget Budget 2014 2015 2016 2017 $ 5,881' $ 9,478' $ - $ - 13,416 14,135 13,000 14,000 139,975 134,164 130,900 133,000 133,596 136,102 130,500 128,500 51,507 47,699 58,000 47,600 7,357 8,220 8,000 8,000 1,408 1,362 - 1,400 17,537 19,200 20,000 20,000 12,495 14,222 14,000 14,000 3,055 3;830 4,000 3,800 22,754 23,317 20,000 23,700 7,087 14,444 4,000 14,000 107,972 117,855 150,000 126,000 518,063 555,273 526,000 555,000 - 29,452 - - 50,003'4 528 - - 1,092,106 1,129,281 1,078,400 1,089,000 $ 1,092,106 $ 1,129,281 $ 1,078,400 $ 1,089,000 1.0% Proposed Actual Actual Budget Budget 2014 2015 2016 2017 $ 567,545 $ 556,670 $ 553,700 $ 576,500 52,248 51,519 55,800 60,800 246,134 275,780 270,000 286,900 42,420 37,274 46,000 40,000 147,007 142,322 127,500 122;100 36,751 (27,190) 25,400 2,700 $ 1,092,105 $ 1,036,375 $ 1,078,400 $ 1,089,000 $ 429,406 $ 441,974 $ 413,500 $ 435,000 191-W City of Eap 2017 Proposed Budget Operating Budget Civic Arena Responsible Manager: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager EXPENSES DETAIL Continued on next page Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 272,797 $ 258,524 $ 239,000 $ 255,200 6112 OVERTIME -REGULAR - - - - 6130 SALARIES AND WAGES -TEMPORARY 169,534 175,199 200,000 189,300 6142 PERA-COORDINATED 27,028 26,403 17,900 19,100 6144 FICA 31,069 31,523 33,600 34,000 6151 HEALTH INSURANCE 58,660 54,875 54,200 69,800 6152 LIFE INSURANCE 541 467 - - 6154 DISABILITY- LONG TERM 969 862 6155 WORKERS COMPENSATION 6,947 8,817 9,000 9,100 TOTAL PERSONAL SERVICES 567,545 556,670 553,700 576,500 PARTS & SUPPLIES 6210 OFFICE SUPPLI ES 312 191 400 400 6220 OPERATI NG SUPPLI ES -GENERAL 21,803 21,162 20,000 22,000 6222 MEDICAL/RESCUE/SAFETY SUPPLI ES 403 476 500 500 6223 BUI LDI NG/CLEANI NG SUPPLI ES 3,910 4,610 5,600 5,600 6224 CLOTH I NG/PERSONAL EQUI PM ENT 384 905 1,000 2,000 6230 REPAI R/MAI NTENANCE SUPP-GENL 16,618 14,645 15,000 17,000 6233 BUI LDI NG REPAI R SUPPLI ES 7,299 7,821 10,000 10,000 6235 FUEL, LUBRICANTS, ADDITIVES - 28 100 100 6240 SMALLTOOLS 175 - 500 500 6241 SHOP MATERIALS 46 76 500 500 6244 CHEMICALS & CHEMICAL PRODUCTS 1,298 1,605 2,200 2,200 TOTAL PARTS & SUPPLI ES 52,248 51,519 55,800 60,800 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES -GENERAL - 5,170 100 100 6314 AUDITI NG 1,000 1,000 900 1,000 6315 FINANCIAL -NON -AUDIT 60 - - - 6346 POSTAGE 181 138 300 300 6347 TELEPHONE SERVICE&LI NECHG 1,350 633 2,500 2,500 6348 MATRIX SERVICE & REPAIR - - 200 - 6353 PERSONAL AUTO/PARKING 54 10 200 200 6355 CELLULAR TELEPHONE SERVICE 827 991 1,200 1,200 6357 GENERAL ADVERTISI NG 5,724 2,338 10,500 10,500 6370 GENERAL PRINTING AND BINDING 1,078 917 1,400 1,500 6385 INSURANCE 7,800 7,800 7,300 7,300 6405 ELECTRICITY 134,850 158,072 139,000 150,000 6410 NATURAL GAS SERVICE 8,359 9,101 8,600 9,000 6457 MACHINERYAND EQUIPMENT 3,729 2,056 3,000 3,000 Continued on next page City o �a�� 2017 Proposed Budget Operating Budget � Civic Arena Responsible Manager: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager EXPENSES DETAIL (CONT'D) TOTAL CIVIC ARENA $ 1,092,105 ._L1,036,375 $ 1,078,400 $ 1,089,000 1.0% 6488 DEPRECIATION & AMORTIZATION EXPENSE $ 429,406 $ 441,974 $ 413,500 $ 435,000 Actual Actual Budget Budget SERVICES & OTHER CHARGES 2014 2015 2016 2017 6476 CONFERENCES AND SCHOOLS $ 559 $ 2,943 $ 700 $ 3,600 6477 LOCAL MEETING EXPENSES 62 - 100 100 6479 DUES AND SUBSCRIPTIONS 1,147 1,140 1,100 1,100 6480 LICENSES, PERMITS AND TAXES 947 1,476 1,100 1,100 6482 AWARDS, JUDGEMENTS AND LOSSES 5,914 - - - 6487 VISA/MC BANK CHARGES 14,609 18,216 15,000 17,000 6515 INTERFUNDEXPENSES - 393 - - 6535 OTHER CO NTRACTUAL S ERVI CES 13,946 21,301 22,400 22,400 6539 WASTE REMOVAL/SANITATION SERV 4,719 3,630 5,600 5,600 6569 MAINTENANCE CONTRACTS 39,219 38,455 48,800 49,400 SERVICES AND OTHER CHARGES 246,134 275,780 270,000 286,900 MERCHANDISE FOR RESALE 6855 MERCHANDISE FOR RESALE 42,420 37,274 46,000 40,000 MERCHANDISE FOR RESALE 42,420 37,274 46,000 40,000 TOTAL OPERATING 908,347 921,243 925,500 964,200 4.2 CAPITAL OUTLAY 6630 OTHER IMPROVEMENTS 12,660 790 - - 6640 MACHINERY/ EQUIPMENT 11,892 1,140 - 6660 OFFICE FURNISHINGS & EQUIPMENT 2,255 2,564 1,700 1,900 6670 OTHER EQUIPMENT - 17,628 9,000 - CAPITALOUTLAY 26,807 22,122 10,700 1,900 RESERVE FOR RENEWAL & REPLACEMENT 120,200 120,200 116,800 120,200 120,200 120,200 116,800 120,200 TOTAL CAPITAL 147,007 142,322 127,500 122,100 -4.2 DEBTSERVICE 6491 INTEREST 1,451 1,451 - 6490 PRINCIPAL (LT and Current) 35,300 (28,641) 25,400 2,700 TOTAL DEBT SERVICE 36,751 (27,190) 25,400 2,700 -89.4% TOTAL CIVIC ARENA $ 1,092,105 ._L1,036,375 $ 1,078,400 $ 1,089,000 1.0% 6488 DEPRECIATION & AMORTIZATION EXPENSE $ 429,406 $ 441,974 $ 413,500 $ 435,000 kpity of Eap 2017 Proposed Budget Operating Budget This page left intentionally blank 401� City of Eapn 2017 Proposed Budget Operating Budget Aquatic Facility - Cascade Bay Responsible Manager: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager PURPOSE & DESCRIPTION The purpose of the Aquatic Facility is to: • Provide a positive environment for residents and guests of all ages to gather. • Encourage and help build a sense of community through a range of recreational and social opportunities. • Provide a high level of service accessibility and professionalism to expand revenue options to ensure the viability of this resource to the community. The Aquatic Facility is responsible for the following functions: • Provide a wide variety of water -related recreational opportunities for members and non-members. • Capture a high level of revenue to offset operational costs and expand the retained earnings capacity to accommodate future growth and expansion. • Protect the City's community investment by maintaining the integrity and value of the building and its amenities. • Create a welcoming atmosphere and solicit input from users to best determine how to meet existing needs and identify future growth opportunities. • On an ongoing basis, analyze existing operations and research ways to expand the recreational opportunities beyond the three-month pool season in order to maximize the capital investment. PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Estimate Target Season passes sold 2,411 2,497 3,000 3,000 Total attendance 94,608 119,382 105,000 110,000 Group admissions 14,925 14,770 15,000 15,000 Days facility is open 89 89 89 89 Paid rounds of golf 5,770 6,884 5,000 5,500 Private rentals 7 8 7 7 12017 Proposed Budget Operating Budget TI City of Eapn Expenditure by Category Parts and Supplies Personae....--� r 8% Services ANS- Services & 58°!o y Other % Ctaarges 16% Capital ? Outlay Merch, for tdesale 8.4% Aquatic Facility — Cascade Bay Responsible Manager: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager HIGHLIGHTS & CHANGES Overview: The proposed 2017 Cascade Bay operating budget reflects an increase of $10,600 or 1.1% from the 2016 budget. The 2017 budget is status quo for service and staffing levels. Highlight/Change 1: Staff development and education opportunity to stay connected with waterpark industry standards and vendors. Budget Impact: $1,800 increase (6476) Service Level Impact: Investing in staff education opportunities and improving vendor relationships at the national level may improve service offerings for Cascade Bay. Highlight/Change 2: Hire consultant to assist with review of pool infrastructure and capital replacement/enhancement plan. Budget Impact: $4,000 increase (6310) Service level impact: With a pool that is 17 years old, we have made investment in pump house/filter system last year. We are looking at next infrastructure discussion. Highlight/Change 3: Budgeted staff time is proposed to be reallocated based on actual time spent for full-time staff. Budget Impact: $23,000 decrease for personal service expenditures. Service level impact: No service level impact is expected as the budget is being aligned with where the employee time is spent. Highlight/Change 4: R&R projects are reviewed annually to make sure they are accurate and appropriately scheduled. The R&R items to be replaced this year are listed below. Several items slated for this year were previously scheduled for prior years, but the replacements were delayed due to the actual (good) condition of the items. • Perfect Fry- $4,150 • Rope and Netting - $4,000 • Video Security System - $9,000 • PA system - $5,000 Financial Impact: All items have been funded through the Renewal and Replacement account for the Aquatic Facility - Cascade Bay. Service Level Impact: All R&R items are replacements of current equipment that will continue service at current levels. � City of'Eayn 2017 Proposed Budget Operating Budget Aquatic Facility - Cascade Bay Responsible Managers: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager CASCADE BAY POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Campus Facilities Manager 0.33 0.33 0.33 0.33 686 Campus Facilities Operations Coordinator 1.00 1.00 1.00 1.00 2,080 Campus Facilities Maintenance Coordinator 0.50 0.50 0.50 0.40 832 Custodian 0.50 0.50 0.50 0.30 624 Clerical Technician 0.40 0.40 0.40 0.40 832 Total 2.73 2.73 2.73 2.43 5,054 Cascade Bay and the Civic Arena share a number of staff. The Civic Arena staff complement is shown below: CIVIC ARENA POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Campus Facilities Manager 0.67 0.67 0,67 0.67 1,394 Campus facilities Operations Coordinator 1.04 1.00 1;00 1.00 2,080 Campus Facilities Maintenance Coordinator 0.5o 0.50 0.50 0.60 1,248 Custodian 0.50 0.50 0.50 0.70 1,456 Clerical Technician 0.20 0.20 0.20 0.20 416 Skating School Coordinator 1.00 Loo Uo 0.80 1,664 Total 3.87 3.87 3,67 3.97 8,258 2017 WORK PLAN Activity Routine 1 Respond to public comments or requests via phoneor in person 2 Daily mainenance and cleaning of building and pool 3 Managethe building infrastructure to ensure efficient, safe and clean environment 4 Develop promotional materials for seasonal facility 5 Recruit, hire, train and supervise temporary and parttime employees 6 Provide work direction to ensure high level of customer service is maintained 7 Develop long range plans and strategies for expanded service 8 Manage staff scheduling and training to meet the demands of the building 4k City of Eapn 2017 Proposed Budget Operating Budget Aquatic Facility - Cascade Bay Responsible Managers: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager Acct REVENUES 4160 STATE P ERA Al D 4304 OTHER REVENUE - NON TAX 4310/11 PARK PROGRAM REVENUE 4312/13 CONCESSION SALES 4314/15 MERCHANDISE SALES 4316/17 GROUP SALES 4318/19 DAILYADMISSIONS 4320 MARKETING REVENUE (COKE) 4321 MEMBERSHIPS 4322/23 VENDING 4326/27 FACILITY RENTAL 4331 TRANSIT TAX EXEMPT REVENUE 4610 INTEREST INCOME 4822 OTHER REVENUE -cash short/over SUBTOTAL TOTAL AQUATIC FACILITY REVENUES REVENUE ESTIMATES Actual Actual Budget Budget 2014 2015 2016 2017 $ 404 $ 404 $ 400 $ 400 2,390 0 - - 16,015 16,233 27,000 17,000 190,009 247,062 205,000 220,000 12,567 16,507 12,300 17,000 115,726 107,741 110,000 122,000 463,901 652,862 546,400 560,800 $ 957,452 0 4,000 4,000 132,619 156,550 146,000 156,000 26 75 - - 12,550 11,476 12,000 12,000 211 840 - - 17,460 6,504 657 2,136 - - 964,534 1,218,392 1,063,100 1,109,200 $ 964,534 $ 1,218,392 $ 1,063,100 $ 1,109,200 4.3% EXPENDITURE SUMMARY Actual Actual Budget Budget Expenditure 2014 2015 2016 2017 Personal Services $ 564,075 $ 605,758 $ 633,900 $ 628,100 Parts and Supplies 66,240 85,699 82,300 87,800 Services and Other Charges 156,846 148,382 167,100 179,000 Merchandisefor Resale 96,042 122,310 .96,000 95,000 Capital Outlay 74,249 103,760 91,900 96,000 Total $ 957,452 $ 1,065,909 $ 1,071,200 $ 1,085,900 Depreciation Expense $ 308,960 $ 371,849 $ 351,500 $ 350,000 4_p� City 0f Eap 2017 Proposed Budget Operating Budget Aquatic Facility - Cascade Bay Responsible Managers: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager LINE ITEM DETAIL Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR 125,445 130,493 $ 169,800 $ 160,500 6112 SALARIES AND WAGES -OVERTIME - - - - 6130 SALARIES AND WAGES -TEMPORARY 352,070 379,689 350,000 355,000 6142 PERA-COORDINATED 9,633 9,552 12,700 12,000 6144 FICA 35,535 37,776 39,800 39,400 6151 HEALTH INSURANCE 24,616 27,371 38,300 38,100 6152 LIFE INSURANCE 186 243 - - 6154 DISABILITY - LONGTERM 350 473 - - 6155 WORKERS COMPENSATION 16,240 20,161 23,300 23,100 6157 RETIREE INSURANCE FUNDING - - - TOTAL PERSONAL SERVICES 564,075 605,758 633,900 628,100 PARTS & SUPPLIES 6210 OFFICE SUPPLIES 179 259 400 400 6211 OFFICE PRINTED MATERIAL/FORMS 774 410 700 700 6212 OFFICE SMALL EQUIPMENT - - 100 100 6215 REFERENCE MATERIALS 121 386 1,000 500 6220 OPERATING SUPPLIES -GENERAL 3,435 4,903 6,000 6,000 6222 MEDICAL/RESCUE/SAFETY SUPPLIES 487 412 2,000 2,000 6223 BUILDING/CLEANING SUPPLIES 5,526 6,507 6,000 6,500 6224 CLOTHING/PERSONAL EQUIPMENT 4,559 5,948 5,000 6,000 6230 REPAI R/MAI NTENANCE SUPP-GENL 3,318 4,565 5,000 5,000 6231 MOBILE EQUIPMENT REPAIR PARTS - 60 300 100 6232 SMALL EQUIPMENT REPAIR PARTS 80 108 500 500 6233 BUILDING REPAIR SUPPLIES 2,316 3,012 2,500 4,000 6235 FUEL, LUBRICANTS, ADDITIVES - 7 - - 6236 POOL REPAIR SUPPLIES - 47 3,000 3,000 6240 SMALLTOOLS 129 52 300 500 6243 HEATING OIL, PROPANE AND OTHER FUELS 454 462 500 500 6244 CHEMICALS & CHEMICAL PRODUCTS 43,431 56,092 47,000 50,000 6257 SIGNS & STRIPING MATERIALS 781 1,819 2,000 2,000 6270 COMPUTER SOFTWARE 650 650 - - TOTAL PARTS & SUPPLIES 66,240 85,699 82,300 87,800 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES 820 3,134 1,000 5,000 6314 AUDITING 1,100 1,100 1,100 1,100 6315 FINANCIAL NON -AUDIT 60 - 100 100 6346 POSTAGE 2,796 2,139 3,000 3,000 6347 TELEPHONE SERVICE & LI NE CHG 760 528 1,000 1,000 6353 PERSONAL AUTO/PARKING 18 5 200 200 6355 CELLULAR TELEPHONE SERVICE 858 989 1,500 1,500 6357 ADVERTISING/PUBLICITY/PROMOTION 166 565 4,000 5,000 6370 GENERAL PRINTING AND BIND] NG 184 859 1,200 1,200 6385 INSURANCE 29,500 29,500 29,500 29,500 49'b� City of Eap 2017 Proposed Budget Operating Budget Aquatic Facility - Cascade Bay Responsible Managers: Andrew Pimental, Director of Parks & Recreation Mark Vaughan, Campus Facilities Manager LINE ITEM DETAIL (CONT'D) Actual Actual Budget Budget Acct 2014 2015 2016 2017 6405 ELECTRICITY $ 39,210 $ 43,181 $ 46,000 $ 46,000 6410 NATURAL GAS SERVICE 42,429 31,562 35,000 36,000 6424 POOL REPAIR/ LABOR 4,100 1,920 6,000 6,000 6426 SMALL EQUIPMENT REPAIR LABOR - - 500 - 6427 BUILDING OPERATIONS REPAIR LABOR 694 248 600 - 6475 MISCELLANEOUS - - 100 100 6476 CONFERENCES AND SCHOOLS 229 194 700 2,500 6477 LOCAL MEETI NG EXPENSES 152 - 100 100 6479 DUES AND SUBSCRIPTIONS 271 179 300 300 6480 LICENSES, PERMITS AND TAXES 1,674 1,509 1,200 2,000 6487 VISA/MC BANK CHARGES 14,043 16,203 15,000 16,000 6535 OTHER CONTRACTUAL SERVICES 5,063 7,418 6,000 8,000 6539 WASTE REMOVAL/SANITATION SERV 2,812 2,733 3,000 3,000 6563 LANDSCAPING 4,612 4,110 5,000 5,000 6569 MAINTENANCE CONTRACTS 5,295 306 5,000 6,400 OTHER SERVICES AND CHARGES 156,846 148,382 167,100 179,000 MERCHANDISE FOR RESALE 6855 MERCHANDISE FOR RESALE 96,042 122,310 96,000 95,000 MERCHANDISE FOR RESALE 96,042 122,310 96,000 95,000 TOTAL OPERATING 883,203 962,149 979,300 989,900 1.1 CAPITAL OUTLAY 6640 MACHINERY/EQUIPMENT 1,276 12,345 - - 6660 OFFICE FURNISHINGS & EQUIPMENT 3,073 2,015 2,000 4,000 6670 OTHER EQUIPMENT - - - CAPITALOUTLAY 4,349 14,360 2,000 4,000 RESERVE FOR RENEWAL & REPLACEMENT 69,900 89,400 89,900 92,000 69,900 89,400 89,900 92,000 TOTAL CAPITAL OUTLAY 74,249 103,760 91,900 96,000 4.5 TOTAL AQUATIC FACILITY $ 957,452 $ 1,065,909 $ 1,071,200 $ 11085,900 1.37 6488 DEPRECIATION & AMORTIZATION $ 308,960 $ 371,849 $ 351,500 $ 350,000 41 City of Evan 2017 Proposed Budget Community Center Responsible Managers: Andrew Pimental, Director of Parks & Recreation Marshall Grange, Community Center Manager PURPOSE & DESCRIPTION The purpose of the Community Center is to: • Provide a positive environment for residents and guests of all ages to gather. • Encourage and help build a sense of community through a wide range of recreational and social opportunities. • Promote health and wellness in the community. • Maintain a high level of service, accessibility and professionalism to expand revenue options to ensure the viability of this resource to the community. Operating Budget The Community Center is responsible for the following functions: • Facilitate a wide variety of programs and classes for members and non-members. • Market and operate a wide range of meeting spaces and rental opportunities for the community. • Capture a high level of revenues to best offset the operational costs of the building. • Protect the City's community investment by maintaining the integrity and value of the building and its amenities. • Operate and maintain a quality fitness center and wellness programs. • Provide space, programming and opportunities for all ages. • Create a welcoming atmosphere and solicit input from users to best determine how to meet existing needs and identify future growth opportunities. PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Estimate Target Groups in the Blast 54 39 55 55 Birthday parties 321 345 325 330 Meetings 1175 1,229 1,125 1,150 Open gym program participants (POG/ $3open/BB & VB open) 14,757 11,510 15,000 15,000 Memberships -year round 1,711 1,750 1,750 1,800 Personal Training -hours 978 884 1,100 1,125 Weddings 78 63 85 80 Average attendance in building per day 980 1,026 1,200 1,200 City of Eap 2017 Proposed Budget Operating Budget Community Center Responsible Managers: Andrew Pimental, Director of Parks & Recreation Marshall Grange, Community Center Manager HIGHLIGHTS & CHANGES Overview The proposed 2017 Community Center operating expenditure budget is up $48,500 (2.9%) over 2016. The budget reflects status quo operations at the Community Center with increased expenses due largely to routine increases in personnel costs while maintaining the same staffing levels as 2016. The 2017 capital expenditure budget is down $78,500 (32.7%) compared to 2016 due to renewal and replacement items lasting longer as a result of best practices in preventative maintenance and care. The overall budget for 2017 is $1,885,800 which compared to $1,915,800 in 2016 represents a 1.6% overall decrease. Highlight/Change 1: Membership revenues are increased due to an increase in fees, programming and restructuring of membership plans that will include a family option and discounted rates for seniors. Financial Impact: (4321) $25,000 increase over 2016. Service Level Impact: Provide additional programs for community to be physically active while offering affordable membership plans with better options for families and seniors compared to past pricing. Highlight/Change 2: Merchandise for resale increased based on actuals from previous years. Financial Impact: (6855) $10,900 increase over 2016, however an overall decrease from years prior. Service Level Impact: Provide food and beverage options at concessions, fulfill food and beverage requests for small group meetings, provide locker room amenities for members, and additional clothing options for staff. These expenses are offset by revenues. Highlight/Change 3: Utility costs were lowered in the 2017 budget based on actuals from the previous two years, and further anticipated savings from energy management system. Financial Impact: (6410) $4,000 decrease in Natural Gas service. Service Level Impact: None as we will continue to maintain a comfortable building for guests. Highlight/Change 4: Additional investment in equipment is proposed to be purchased to offer register -for specialty classes in the Oasis: Financial Impact: (6670) $5,000 Service Level Impact: Increased programming will provide customer services based on needs expressed by current members and non-members. The programming will be aimed at non-members who may not be interested in committing to an on-going membership, however, are interested in select classes on an ala carte basis. Current fitness members, and those who may convert to members, will receive member discounted pricing thus providing value. Highlight/Change 5: Capital outlay expenses for 2017 is reduced by $78,500 versus 2016 appropriations. Due to several projects being pushed back an additional year or two due to quality preventative care and maintenance, these savings can be realized in 2017. Financial Impact: $78,500 decrease Service Level Impact: None. * City of Eap 2017 Proposed Budget Operating Budget Community Center Responsible Manager: Andrew Pimental, Director of Parks & Recreation Marshall Grange, Community Center Manager POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Community Center Manager 1 1 1 1 2,080 Manager on Duty (MOD) 2 0 0 0 - Rental Coordinator 1 1 1 1 2,080 Government Buildings Engineer 1 1 1 1 2,080 Fitness & Operations Supervisor 0 0 0 0 - Fitness Coordinator 0 0.75 1 1 2,080 Guest Services Specialist 0 2.35 2.35 2.35 4,888 Training/Office Support Specialist 0.75 0 0 0 - Lead Custodian/Maintenance 1 1 1 1 2,080 Custodial 3 3 3 3 6,240 Total 9.75 9.75 10.35 10.35 21,528 2017 WORK PLAN Activity Routine 1 Respond to public comments or requests via phone or in person 2 Provide support to the day-to-day fitness center 3 Daily ma 1 ntena nce a nd cleaning of building 4 Provide support to the day-to-day concessions operation 5 Register participants in recreation programs, memberships or daily admissions 6 Set up and change room configurations to accommodate multiple events 7 Develop promotional materials for specialized uses: Blast/Rentals/Fitness 8 Manage staff scheduling and trainingto meetthe demands of the building 9 Recruit,hire, train and supervise temporary and part-time employees 10 Provide work direction to ensure high level of customer service is maintained 11 Managethe building infrastructure to ensure efficient, safe and clean environment 12 Establish and manage fitness programs, classes and memberships 13 Coordinatethe rentals of all available spaces within the building 14 Provide input and directions pertaining to policies, budget and general operation of ECC 15 Develop and manage capital improvements and long-range planning 16 Develop and manage policies & procedures that best meet the needs of the community 17 Coordinate outdoor events with indoor activities City of Eapn 2017 Proposed Budget Operating Budget Community Center Responsible Manager: Andrew Pimental, Director of Parks & Recreation Marshall Grange, Community Center Manager REVENUE SUMMARY EXPENDITURE SUMMARY Actual Actual Budget Budget Acct REVENUES 2014 2015 2016 2017 4304 PERSONAL TRAINERS $ 49,386 $ 47,981 $ 55,000 $ 50,000 4305/4306 EQUIPMENT RENTAL 25,130 21,797 25,000 25,000 4310/4311 PARK PROGRAM REVENUE 9,552 22,791 15,000 23,000 4312/4313 CONCESSION SALES 101,264 72,653 75,000 72,000 4314/4315 MERCHANDISE SALES 1,277 1,728 1,000 2,500 4316/4317 GROUP SALES 37,195 51,102 37,000 50,000 4318 DAILYADMISSIONS 87,634 91,257 95,000 92,000 4320 MARKETING REVENUE (COKE) 245 - - - 4321 MEMBERSHIPS. 632,223 651,493 660,000 685,000 4322/23 VENDING (VENDORS) 3,265 2,591 2,000 800 4324/25 ROOM RENTALS 297,406 329,620 350,000 330,000 4326/27 FACILITY RENTAL 1,474 2,754 1,200 1,500 4328 CONTRACT REVENUE 100,860 101,111 112,000 100,000 4621 ECVB RENT 14,555 15,214 14,000 15,000 4657 SALE OF CITY PROPERTY - 6,066 - 4840 INTERNAL REVENUE 63,800 64,369 2,000 63,000 OTHER REVENUE 42,135 40,184 - - SUBTOTAL 1,467,401 1,522,711 1,444,200 1,509,800 OTHER FUNDING SOURCES TRANSFER I N -ANTENNA LEASE REVENUE 284,710 313,448 471,600 376,000 SUBTOTAL 284,710 313,448 471,600 376,000 TOTAL REVENUES $ 1,752,111 $ 1,836,159 $ 1,915,800 $ 1,885,800 -1.6% EXPENDITURE SUMMARY Actual Actual Budget Budget Expenditure 2014 2015 2016 2017 Personal Services $ 1,123,172 $ 1,147,290 $ 1,219,600 $ 1,265,200 Parts and Supplies 55,022 52,965 57,500 60,300 Services and Other Charges 362,496 356,155 374,400 363,600 Merchandisefor Resale 49,170 39,744 24,100 35,000 Capital Outlay 174,159 183,663 240,200 161,700 Total $ 1,764,019 $ 1,779,817 $ 1,915,800 $ 1,885,800 Depreciation Expense $ 531,108 $ 547,677 $ 485,500 $ 540,000 Debt Servi c 1,053,613 1,049,603 1,054,900 1,066,800 . Cly of Ealan 2017 Proposed Budget Operating Budget Community Center Responsible Manager: Andrew Pimental, Director of Parks & Recreation Marshall Grange, Community Center Manager LINE ITEM DETAIL Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 515,575 $ 551,162 $ 596,300 $ 617,400 6112 OVERTIME -REGULAR 37 113 - - 6130 SALARIES AND WAG ES -TEMPORARY 362,794 335,936 350,000 345,000 6131 OVERTIME -TEMPORARY - - - - 6142 PERA-COORDINATED 60,926 63,859 59,400 60,800 6144 FICA 63,196 64,558 72,400 73,600 6151 HEALTH INSURANCE 109,670 117,385 128,700 155,400 6152 LIFE INSURANCE 1,094 1,181 - - 6154 DISABILITY -LONGTERM 1,964 2,132 - - 6155 WORKERS COMPENSATION 7,916 10,964 12,800 13,000 6157 RETIREE INSURANCE FUNDING - - _ - TOTAL P ERSO NAL S ERVI CES 1,123,172 1,147,290 1,219,600 1,265,200 PARTS & SUPPLIES 6210 OFFICESUPPLIES 1,440 1,655 1,800 1,600 6211 OFFICE PRINTED MATERIAL/FORMS 1,359 1,188 1,400 1,200 6212 OFFICESMALLEQUIPMENT 64 80 500 500 6220 OPERATING SUPPLIES -GENERAL 10,283 5,804 6,500 8,000 6222 MEDICAL/RESCUE/SAFETY SUPPLIES 1,034 485 900 900 6223 BUILDING/CLEANING SUPPLIES 21,319 23,061 21,200 23,000 6224 CLOTHI NG/PERSONAL EQUI PMENT 188 2,361 2,000 2,000 6227 RECREATION EQUIPMENT SUPPLIES 3,297 1,503 3,600 3,600 6230 REPAIR/MAINTENANCESUPP-GENL 3,598 4,591 3,000 4,000 6232 SMALLEQUIPMENT REPAIR PARTS 5,268 2,865 4,000 3,000 6233 BUILDING REPAIRSUPPLIES 6,883 7,476 9,200 9,200 6240 SMALLTOOLS 213 143 500 500 6241 SHOP MATERIALS 239 226 600 600 6244 CHEMICALS& CHEMICAL PRODUCTS (615) 1,212 1,400 1,400 6257 SIGNS & STRIPING MATERIAL 74 - 300 300 6270 CO M P LITER SO FTWARE 378 315 600 500 TOTAL PARTS & SUPPLIES 55,022 52,965 57,500 60,300 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES 255 90 1,000 1,000 6314 AUDITI NG 2,200 2,300 2,200 2,300 6315 FINANCIAL NON -AUDIT 60 2,750 - - 6346 POSTAGE 388 922 1,000 1,000 6347 TELEPHONE SERVI CE & LINE CHG 3,946 3,707 4,000 4,100 6348 MATRIX SERVICE & REPAIR - - - - 6353 PERSONALAUTO/PARKING 549 287 600 300 6355 CELLULAR TELEPHONE SERVICE 1,533 1,531 1,600 1,600 6357 GENERAL ADVERTISI NG 5,332 13,882 17,000 15,000 6370 GENERAL PRINTING AND BINDING 52 156 5,000 1,000 6385 INSURANCE 28,300 28,300 28,300 28,300 6405 ELECTRICITY 164,887 166,310 164,000 164,000 6410 NATURAL GAS SERVICE 59,556 46,977 55,000 51,000 Alb� City of Eap 2017 Proposed Budget Operating Budget Community Center Responsible Manager: Andrew Pimental, Director of Parks & Recreation Marshall Grange, Community Center Manager LINE ITEM DETAIL (CONT'D) TOTAL OPERATING CAPITAL OUTLAY Actual Actual Budget Budget 6650 SERVICES & OTHER CHARGES 2014 2015 2016 2017 6426 SMALL EQUIPMENT REPAIR -LABOR $ - $ 2,813 $ - - 6475 MISCELLANEOUS 268 138 1,000 300 6476 CONFERENCES AND SCHOOLS 42 3,627 3,000 3,000 6477 LOCAL MEETING EXPENSES - - 1,000 1,000 6479 DUES AND SUBSCRIPTIONS 372 119 600 600 6480 LICENSES, PERMITS AND TAXES 2,793 2,022 2,000 2,000 6482 AWARDS, JUDGEMENTS, AND LOSSES 17,371 92 - - 6487 VISA BANK CHARGES 19,004 18,778 19,000 19,000 6535 OTHER CONTRACTUAL SERVICES 34,223 37,210 37;000 36,000 6539 WASTE REMOVAL/SANITATION SERV 8,298 7,769 8,500 8,500 6569 MAINTENANCE CONTRACTS 13,067 16,375 22,600 23,600 OTHER SERVICES AND CHARGES 362,496 356,155 374,400 363,600 MERCHANDISE FOR RESALE 6855 MERCHANDISE FOR RESALE 49,170 39,744 24,100 35,000 MERCHANDISE FOR RESALE 49,170 39,744 24,100 35,000 TOTAL OPERATING RESERVE FOR RENEWAL & REPLACEMENT TOTAL CAPITAL TOTAL COMMUNITY CENTER DEBT SERVICE 6490 PRINCIPAL 6491 INTEREST 6492 PAYING AGENT/BOND DESTRUCTION TOTAL DEBT SERVICE 6488 DEPRECIATION & AMORTIZATION 1,589,860 1,596,154 1,675,600 1,724,100 2.9 - CAPITAL OUTLAY 6630 OTHER IMPROVEMENTS 6640 MACHINERY/EQUIPMENT 6650 FURNITURE & FIXTURES 6660 OFFICE FURNISHINGS & EQUIPMENT 6670 OTHER EQUIPMENT 1,664 CAP I TAL OUTLAY RESERVE FOR RENEWAL & REPLACEMENT TOTAL CAPITAL TOTAL COMMUNITY CENTER DEBT SERVICE 6490 PRINCIPAL 6491 INTEREST 6492 PAYING AGENT/BOND DESTRUCTION TOTAL DEBT SERVICE 6488 DEPRECIATION & AMORTIZATION 1,589,860 1,596,154 1,675,600 1,724,100 2.9 - 3,331 2,600 - 4,387 5,732 2,800 1,800 - 6,911 1,000 2,000 1,664 3,241 4,000 5,900 10,108 6,448 8,000 5,000 16,159 25,663 18,400 14,700 158,000 158,000 221,800 147,000 174,159 183,663 240,200 161,700 -32.7 $ 1,764,019 $ 1,779,817 $ 1,915,800 $ 1,885,800 -1.6 840,000 855,000 875,000 900,000 213,188 194,153 179,400 166,300 425 450 500 500 1,053j613 1,049, 603 1,054,900 1,066, 800 $ 531,108 $ 547,677 $ 485,500 $ 540,000 City of Eap 2017 Proposed Budget Operating Budget AccessEagan/Fiber Infrastructure Fund (225) Responsible Managers: Tom Garrison, Director of Communications; Dianne Miller, Assistant City Administrator Dan Cook, IT Manager PURPOSE & DESCRIPTION The purpose of the AccessEagan — (Fiber Infrastructure) operation is to: p+ p� �a AGA ffi ACCEs ALAN • Respond to the City Council's goal of implementing leading technologies to support the evolving "infostructure" needs of Eagan's business community. • Support current and future needs of large and small Eagan businesses with a wide range of bandwidth options for business, commercial and institutional use through a high performance carrier class network. • Offer wholesale lit fiber open to any provider wishing to lease AccessEagan capacity to reach and serve Eagan businesses. (The City does not offer retail services.) • Ensure access in crowded rights of way to multiple carriers providing competitive services, and create additional security and redundancy to Eagan's fiber infrastructure. • The additional purpose of the Fiber Infrastructure fund is to keep track of all fiber and broadband planning investments in one place. The AccessEagan operation is responsible for the following functions: • Provide secure network bandwidth to carriers and providers for resale • Ensure and monitor on-going network operations • Continued analysis of existing operation for growth and other service opportunities • Provide all network equipment end-to-end, including customer premises equipment PERFORMANCE INDICATORS 2014 2015 2016 2017 Description Actual Actual Actual Target Customer Counts 2 5 10 17 Revenues Generated 13,805 50,378 101,700 95,100 Miles of Fiber installed 16 16 37 37 City of Hap 2017 Proposed Budget Operating Budget �. Capital Cot,st. Projects Expenditure by Category { Outlay 41°l 2f Personal i g n Services ' 26% Serv. and Other' ra its a -and Charges _ Supples 30%_ _ 1% AccessEagan/Fiber Infrastructure Fund (225) Responsible Managers: Tom Garrison, Director of Communications; Dianne Miller, Assistant City Administrator; Dan Cook, IT Manager HIGHLIGHTS & CHANGES Overview: The proposed 2017 AccessEagan budget is set to increase by $4,100 (1.0%) from the previous year's approved budget. Operational costs include equipment and maintenance costs, marketing expenses, afterhours support, fiber locates, and some legal and engineering support. While the vast majority of the expenses in the AccessEagan/Fiber Infrastructure Fund are for the open access network, it should be noted that the fund also accounts for inter -agency fiber lease arrangements and revenues. The City also receives revenue from separate conduit -only lease arrangements. Highlight/Change 1: The budget includes a $9,500 increase to fund the Dakota County Broadband Study Systems Plan. The CDA, County and Cities are putting together resources to evaluate a County -wide institutional network (INET) with the possibility of expanding it to a commercial network (CNET). Research is being done to evaluate everyone's resources and what it would take to interconnect this network. The funding will be used towards an Engineering Systems Plan and an Administrative Systems Plan. Based off this information, each entity should then be able to make an educated decision as to whether they would like to enter into a County -wide JPA. Financial Impact: $9,500 increase Service Level Impact: By partnering with the County in this Broadband Study, it offers more opportunities for building a County fiber ring to provide lower cost INET connections, increase customer base for CNET purposes by expanding AccessEagan's reach from within the City limits to extend to surrounding Dakota County cities. Highlight/Change 2: As part of the planned development in Northeast Eagan, the City has committed to extending AccessEagan fiber to reach the new development. This work will most likely take place in the spring of 2017. The City plans to coordinate this conduit installation with other City site improvements to reduce costs of the overall project. Financial Impact: $100,000 increase (6756) Service Level Impact: This expansion has potential of reaching a new customer base in the Northeast corner of Eagan, where the Vikings headquarters is being built. Highlight/Change 3: AccessEagan has decreased its fiber construction drop costs from the City's backbone to the customer premise by $50,000 from the 2016 budget. With the anticipation of bringing on seven new customers in 2017, it was anticipated the average build cost would be roughly $7,150. Some builds may cost more and some may cost less but on average this was a comfortable number to allocate to the builds. Financial Impact: $50,000 decrease (6756) Service Level Impact: The incentive provides a significant advantage to bring customers onto the network. Continued on next page 49rP City of Eap 2017 Proposed Budget Operating Budget AccessEagan/Fiber Infrastructure Fund (225) Responsible Managers: Tom Garrison, Director of Communications; Dianne Miller, Assistant City Administrator; Dan Cook, IT Manager HIGHLIGHTS & CHANGES (CONT'D) Highlight/Change 4: AccessEagan has contracts for existing lit services of $41,040 and fiber and conduit leases of $17,000 in 2017. It is projecting new revenues of $37,020 from new customers in 2017. This is assuming that AccessEagan brings on approximately six new circuits at a contracted speed of 100 Mbps and one 1Gbps circuit. While this is below our five-year estimate pace, AccessEagan staff felt it was necessary to be conservative in this projection. There are a lot of variables that could increase the revenue projections. Based off of some new developments in town with the CSM development ramping up into 2016, the DataBank Data Center in town, and new and continued efforts from our service providers, we are anticipating generating several new customers along the new routes. Financial Impact: $37,020 increase in revenues from existing contracts Service Level Impact: N/A POSITION INVENTORY Personnel 2013 2014 2015 2016 Hours IT Network Security Supervisor 0 0 1 1 2,080 Total 0.00 0.00 1.00 1.00 2,080 2017 WORK PLAN Activity Routine 1 Develop AccessEagan policies and procedures for Operational Guide 2 Establish AccessEagan Goals, Objectives, Standards and Controls 3 Build Relationships with Service Providers, Carriers, Data Centers and Eagan Businesses 4 Establish various Agreements With Service Providers to make operations flowseemlessly 5 Hire appropriate staff to be determined by network growth 6 Document all variances from original build outto ensure reliability and scalability 7 Update City Council on AccessEagan progress annually 8 Coordinate support issues with all vendors 9 Coordinate with internal departments to make operations flow smoothly 10 Maintain all equipment documentation for new installations of customers on the network * City of Eajan 2017 Proposed Budget Operating Budget AccessEagan/Fiber Infrastructure Fund (225) Responsible Managers: Tom Garrison, Director of Communications; Dianne Miller, Assistant City Administrator; Dan Cook, IT Manager REVENUE SUMMARY *Actual and Budgeted Revenue was reclassified for budget presentation to best represent service activity to the AccessEagan customers. EXPENDITURE SUMMARY Actual* Actual* Budget* Budget Acct REVENUES 2014 2015 2016 2017 4140 STATE GRANTS $ $ $ - $ 4615 CHANGE IN FAIR VALUE - 750 - - 4720 LIT FIBER SERVICES 2,361 16,505 24,400 75,200 4721 DARK FIBER SERVICES 7,158 7,282 66,700 8,700 4722 CONDUIT LEASES 8,100 9,019 9,000 11,200 4691 OTHER REVENUE - 40 - - 4822 OTHER REFUNDS AND REIMBURSEMENTS - 4980 TRANSFERS IN 1,000,000 350,000 - - TOTAL ACCESS EAGAN/FIBER REVENUE $ 1,017,619 $ 382,846 $ 100,100 $ 95,100 *Actual and Budgeted Revenue was reclassified for budget presentation to best represent service activity to the AccessEagan customers. EXPENDITURE SUMMARY Depreciation Expense CONSTRUCTION $ 124,790 $ 132,819 $ 125,000 $ 125,000 Drop Costs Relocations Expansion TOTAL CAPITAL PURCHASES $ 50,000 40,000 100,000 $ 190,000 Actual Actual Budget Budget Expenditure 2014 2015 2016 2017 Personal Services $ 3,811 $ 115,165 $ 122,200 $ 123,300 Parts and Supplies 144 750 5,700 2,900 Services and Other Charges 78,611 45,636 149,800 139,900 Capital Outlay 4,060 8,492 43,500 9,200 Construction Projects 3,230 1,990 140,000 190,000 Total $ 89,856 $ 172,033 $ 461,200 $ 465,300 Depreciation Expense CONSTRUCTION $ 124,790 $ 132,819 $ 125,000 $ 125,000 Drop Costs Relocations Expansion TOTAL CAPITAL PURCHASES $ 50,000 40,000 100,000 $ 190,000 City of Eap 2017 Proposed Budget Operating Budget AccessEagan/Fiber Infrastructure Fund (225) Responsible Managers: Tom Garrison, Director of Communications; Dianne Miller, Assistant City Administrator; Dan Cook, IT Manager LINE ITEM DETAIL Actual Actual Budget Budget Acct PERSONAL SERVICES 2014 2015 2016 2017 6110 SALARIES AND WAGES -REGULAR $ 3,289 $ 92,000 $ 91,500 $ 96,100 6142 PERA-COORDINATED 247 6,569 7,100 7,500 6144 FICA 252 6,658 7,000 7,400 6151 HEALTH INSURANCE - 9,056 16,000 11,700 6152 LIFE 122 - - 6154 DISABILITY - LONGTERM - 244 - - 6155 WORKERS COMPENSATION 23 516 600 600 TOTAL PERSONAL SERVICES 3,811 115,165 122,200 123,300 PARTS & SUPPLIES 6210 OFFICESUPPLIES 44 - - - 6220 OPERATING SUPPLIES - GENERAL 100 750 5,700 2,900 PARTS & SUPPLIES 144 750 5,700 2,900 SERVICES & OTHER CHARGES 6310 PROFESSIONAL SERVICES - GENERAL 11,983 9,159 36,400 32,100 6311 LEGAL 324 2,370 8,000 4,500 6312 ENGINEERING - - 10,000 10,000 6314 AUDITING 50 100 500 500 6346 POSTAGE - - 1,500 800 6350 LOGIS ITSERVICES 11,382 11,256 16,500 11,500 6355 CELLULAR TELEPHONE SERVICE - - 800 800 6370 GENERAL PRI NI NG AND BINDING 138 - - 6456 BUILDING RENTAL - 8,000 12,000 6476 CONFERENCES/MEETINGS/TRAINING - - 2,600 3,700 6569 OTHER CONTRACTUAL SERVICES 54,872 22,613 65,500 64,000 SERVICES & OTHER CHARGES 78,611 45,636 149,800 139,900 TOTAL OPERATING 82,566 161,551 277,700 266,100 -2.5 CAPITAL OUTLAY 6660 OFFICE FURNISHINGS & EQUIPMENT 4,060 31219 - - 6670 OTHER EQUIPMENT 5,273 43,500 9,200 CAPITALOUTLAY 4,060 8,492 43,500 9,200 CONSTRUCTION PROJECTS 6700 PROJECT- CONTRACT 2,540 1,990 - - 6756 BUILDING&STRUCTURES 690 - 140,000 190,000 CONTRUCTI0N PROJECTS 3,230 1,990 140,000 190,000 TOTAL CAPITAL 7,290 10,482 183,500 199,200 3.4 TOTAL FIBER INFRASTRUCTURE $ 89,856 $ 172,033 $ 461,200 $ 465,300 0.9 Non -personnel increase: 0.9% 6488 DEPRECIATION & AMORTIZATION $ 124,790 $ 132,819 $ 125,000 $ 125,000 m City of Eap 2017 Proposed Budget Operating Budget E -TV (197) Responsible Manager: Tom Garrison, Director of Communications PURPOSE & DESCRIPTION Eagan Television (E -TV) creates public, educational, and government cable TV programming through a partnership of volunteers and professional staff. E -TV also provides television production equipment facilities, and channel time to televise locally - produced programming. It is cable programming by the community, for the community. PERFORMANCE INDICATORS Description Monthly Staff Program Production Monthly Access Show Production New Vol unteers Outside Revenue Opportunities For Youth 12-18 Monthly Multipurpose Short Video Production 2014 2015 2016 2017 Actual Actual Estimate Target 20 21 24 30 24 20 30 30 180 188 200 200 $47,613 $21,102 $40,000 $40,000 150 144 150 180 NA NA NA 4 My of Eaph 2017 Proposed Budget Operating Budget Personal Services 67% Capital Outlay 4% Expenditure by Category Parts and Supplies 6% Services and Other Charges 23% E -TV (197) Responsible Manager: Tom Garrison, Director of Communications HIGHLIGHTS & CHANGES Overview: The proposed E -TV Eagan Television budget is programmed to increase $7,500 or 1.3%. The operational portion of the budget is set to increase at less than 1.0% or by $5,200. The E -TV budget is funded by non -taxpayer dollars. The sources of funding are franchise fees paid by Comcast and a small fee on local subscriber bills which supports capital equipment for Public, Educational and Governmental (PEG) public access facilities. Highlight/Change 1: Legal Counsel budget assumes lowered amount from 2016, but reflects ongoing expense for cable franchise negotiations and successful implementation of new franchise(s). This change assumes informal cable franchise negotiations with remaining applicant, Comcast. A formal process, as prescribed by law, would be more expensive. Financial Impact: Decrease of $17,500 (6391) Service Level Impact: No service impact is expected at this time. Highlight/Change 2: With a reorganization of assets within the same overall budgeted amounts, E -TV is creating more coverage opportunities and productivity by increasing our use of part time employees. Financial Impact: This would be an increase in Temporary/Seasonal Wages and an equal decrease in Salaries and Wages resulting in no additional funds. Service Level Impact: Improved. This will allow us to cover more events, increase our hours of operation with no additional funds as well as freeing our full time personal up more to concentrate on more complex productions and projects. Highlight/Change 3: With the increase of Hourly Employees from 1 to 2, we have increased the amount budgeted towards overtime to accommodate these changes. Financial Impact: This would be an increase in Overtime -Regular and an equal decrease in Salaries and Wages. Service Level Impact: Improved. This would allocate funds for both Hourly positions and slightly increase our yearly amount for each to accommodate increased demand for Weekend and Evening events without affecting weekday service levels. m My of EOPH 2017 Proposed Budget Operating Budget E -TV (197) Responsible Manager: Tom Garrison, Director of Communications EXPENDITURE SUMMARY POSITION INVENTORY Personnel Actual Actual Budget Budget Expenditure 2014 2015 2016 2017 Personal Services $ 377,745 $ 368,779 $ 388,900 $ 408,400 Parts and Supplies 20,890 23,418 30,100 33,900 Services and Other Charges 131,892 108,723 155,500 137,400 Capital Outlay 98,203 100,544 22,600 24,900 Total $ 628,730 $ 601,464 $ 597,100 $ 604,600 POSITION INVENTORY Personnel 2014 2015 2016 2017 Hours Studio Supervisor 1 1 1 1 2,080 Cl i ent Servi ces Coordinator 1 1 1 1 2,080 Govt Programming Coordinator 1 1 1 0 0 Prod ucti on/Progra mmi ng Assistant 0 0 0 1 2,080 Videographer/Editor 1 1 1 1 2,080 Total 4 4 4 4 8,320 WORK PLAN 2017 Activity Routine 1 Supervision of PEG channels for Eagan 2 Provide and maintain public access facilities 3 Plan & implement HD channel(s) conversion 4 Conclude franchiseagreement(s) 5 Provide coverage of community events& facilitate volunteer partnerships and co -productions 6 Provide coverage of all Eagan government meetings 7 Provide video production services to City of Eagan departments 8 Provide video production services to revenue generating clients 9 Assist Comcast customers with complaints 10 Providetraining for PAstudio and equipment use 11 Provide video production services to Thomson Reuters in exchangefor rent 12 Facilitate, organize and execute the playback of all PAshows, increasing interactivity Note: City may be managing morethan one cablefranchise City 0f Ealan 2017 Proposed Budget Operating Budget E -TV (197) Responsible Manager: Tom Garrison, Director of Communications Revenue 4689 PEG fees (total) Less: PEG fees used for Studio/Control Room Upgrade PEG fees used for Video Server HD Upgrade/Replac PEG fees used for Cyron Characer Generator Net PEG fees used for E -TV operations 4690 City contribution - from Cable Franchise Fees fund 4695 E -TV dubbing 4699 Class fees 4696 Dub/Rental/Paid production 4697 E -TV paid production XXXX Other Revenue Total Operating Revenues REVENUE SUMMARY Actual Actual Budget Budget 2014 2015 2016 2017 $ 368,677 $ 373,058 $ 375,000 $ 375,000 - - (14,100) (42,900) (135,100) (53,600) (32,500) (26,300) - - - (15,000) 368,677 373,058 193,300 237,200 381,857 371,528 360,300 417,200 1,671 1,117 3,000 3,000 11,665 9,830 15,000 15,000 25,637 4,375 20,000 22,000 8,640 40,235 2,000 - 798,147 800,143 593,600§ 4,400 16.98% Fund Source CIP(PEG)Studio/Control Room UpGrade CIP(PEG)Video Serverl HD UpGrade/Rep lacement CIP(PEG) Cyron Character Generator CIP(PEG)Shared Truck Design CAPITAL PURCHASES $ 42,900 $ 53,600 $ 26,300 $ 15,000 Total $ 137,800 M- City of Equ 2017 Proposed Budget Operating Budget E -N (197 ) Responsible Manager: Tom Garrison, Director of Communications LINE ITEM DETAIL 2014 2015 2016 2017 Actual Actual Budget Budget 6110 SALARIES AND WAGES -REGULAR 271,029 261,859 273,500 250,500 6112 OVERTIME - REGULAR 3,804 3,018 3,000 9,000 6130 SALARIES AND WAGES -TEMPORARY 16,540 16,514 20,000 40,000 6142 PERA-COORDINATED 20,835 21,291 22,200 22,500 6144 FICA 21,278 21,236 22,700 22,900 6151 HEALTH INSURANCE/VEBA 41,735 42,409 45,500 62,200 6155 WORKERS COMPENSATION 2,524 2,452 2,000 1,300 PERSONAL SERVICES 377,745 368,779 388,900 408,400 6210 OFFICE SUPPLIES 349 460 500 900 6212 OFFICE SMALL EQUIPMENT 305 140 500 300 6215 REFERENCE MATERIALS - 27 500 300 6220 OPERATING SUPPLIES - GENERAL 7,843 7,110 9,300 9,700 6224 CLOTHING/PERSONAL EQUIPMENT 154 - 1,000 1,500 6231 MOBI LE EQUIPMENT REPAI R - PARTS 348 1,733 2,000 2,000 6232 SMALL EQUIPMENT REPAIR - PARTS 2,485 1,738 2,000 2,000 6235 FUEL, LUBRICANTS, ADDITIVES 1,407 1,103 2,000 2,000 6270 COMPUTER SOFTWARE 7,999 11,107 12,300 15,200 PARTS & SUPPLIES 20,890 23,418 30,100 33,900 6310 PROFESSI ONAL SERVICES -GENERAL 4,195 1,240 2,500 2,500 6311 LEGAL 43,035 24,149 77,500 60,000 6313 PLANNING 25,555 22,086 - - 6314 AUDITING 100 100 6323 TESTINGSERVICES 637 - - - 6346 POSTAGE 92 500 500 6347 TELEPHONE SERVICE & LINE CHARGES - - 100 100 6353 PERSONAL AUTO/PARKING 85 13 100 100 6355 CELLULAR TELEPHONE SERVICE 2,440 3,641 4,200 4,200 6357 GENERAL ADVERTISING - 100 2,800 1,700 6370 GENERAL PRINTING AND BINDING 379 1,950 3,700 800 6385 INSURANCE 7,400 7,400 7,400 7,400 6405 ELECTRICITY 12,000 12,000 12,000 12,000 6425 MOBILE EQUIPMENT REPAIR - LABOR 497 1,220 1,500 2,000 6426 SMALL EQUIPMENT REPAIR - LABOR - 3,071 4,000 4,000 6457 MACHINERY&'EQUIPMENTRENTAL - - 200 200 6475 MISCELLANEOUS 4,627 3,941 5;000 5,000 6476 CONFERENCES AND SCHOOLS 3,396 2,543 4,600 7,000 6477 LOCALMEEIINGEXPENSES 716 206 200 200 6479 DUESAND SUBSCRIPTIONS 2,809 3,190 3,600 4,100 6480 LICENSES, PERMITS AND TAXES 16 - - - 6535 OTH ER CO NTRACTUAL SERVI CES - 82 - - 6569 MAINTENANCE CONTRACTS 23,913 21,791 25,600 25,600 OTHER SERVICES AND CHARGES 131,892 108,723 155,500 137,400 TOTAL OPERATING 530,527 500,920 574,500 579,700 0.9 6640 MACHINERY/EQUIPMENT 94,521 97,825 15,000 17,300 6660 OFFICE FURNISHINGS/EQUIPMENT 570 1,301 1,600 1,600 6680 MOBILE EQUIPMENT 3,112 1,418 6,000 6,000 TOTAL CAPITAL 98,203 100,544 22,600 24,900 10.2 TOTAL E -TV 628,730 601,464 597,100 604,600 1.3