Loading...
Dubuque Regional Airport Fiscal Year 2018 Budget PresentationCopyright 2014 City of Dubuque Public Hearings # 5. IT EM T IT LE:Dubuque Regional Airport Fiscal Year 2018 Budget Presentation SUM MARY: SUGGEST ED DISPOSIT ION: ATTACHMENTS: Description Type Rec ommended FY18 Airport CIP Supporting Documentation Rec ommended FY18 Airport OP Supporting Documentation 163 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Perimeter Fence Improvements DEPARTMENT:51 FD/CIP NO:390-1497 $65,000 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS $10,000 Construction $15,000 $10,000 $10,000 $10,000 $10,000 $—$10,000 TOTAL $15,000 $10,000 $10,000 $10,000 $10,000 $— B. PROJECT FINANCING $10,000 Sales Tax Fund (20%)$15,000 $10,000 $10,000 $10,000 $10,000 $—$10,000 TOTAL $15,000 $10,000 $10,000 $10,000 $10,000 $— PROJECT DESCRIPTION This will provide for replacing damaged sections of the Airport perimeter fence and security gates. JUSTIFICATION The current Airport perimeter fence was replaced in 1994 and is 8 foot high with 3 strands of barb wire, encompasses the entire airfield area and is over 6 miles long. The fence provides necessary airfield security and wildlife control. The security gate by the existing fuel farm and maintenance building will be replaced in FY18. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 164 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Storm Drain Improvements DEPARTMENT:51 FD/CIP NO:390-2662 $63,500 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS $28,500 Construction $15,000 $20,000 $—$28,500 TOTAL $15,000 $20,000 $—$—$—$— B. PROJECT FINANCING $28,500 Sales Tax Fund (20%)$15,000 $20,000 $—$28,500 TOTAL $15,000 $20,000 $—$—$—$— PROJECT DESCRIPTION This will provide for storm drain improvements both on the airfield and land side areas. JUSTIFICATION Currently there are storm drains that were installed as long ago as the 1950's.These are causing sinkholes and are in need of replacement. There are currently drains needing improvements located on the airfield, next to the corporate hangar area, FAA offices, the University of Dubuque, Aircraft Tower and in the FBO parking lot. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 165 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Corporate Hangar Facilities Repair/ Replacement DEPARTMENT:51 FD/CIP NO:390-2008 $215,881 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS $9,218 $81,663 Construction $40,000 $40,000 $45,000 $9,218 $81,663 TOTAL $40,000 $—$40,000 $—$45,000 $— B. PROJECT FINANCING $9,218 $81,663 Sales Tax Fund (20%)$40,000 $40,000 $45,000 $9,218 $81,663 TOTAL $40,000 $—$40,000 $—$45,000 $— PROJECT DESCRIPTION This project provides for rehabilitation of existing corporate hangars and buildings. JUSTIFICATION Large corporate hangars, as well as, existing leased T-hangars, need structural repairs such as roofing, heating, flooring and door repairs/replacement. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Transportation Goal Seven: To support rail opportunities for both commercial/ industrial and passenger service, objective 7.5) Consider alternate route into port not affected by train traffic for truck freight and Infrastructure Goal Ten: To provide, maintain, and improve City- owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 166 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Replace Garage Doors on Joint Use Facility Building DEPARTMENT:51 FD/CIP NO:390-2715 $57,229 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Construction $18,700 $19,455 $19,074 $—$—TOTAL $18,700 $—$19,455 $19,074 $—$— B. PROJECT FINANCING Sales Tax Fund (20%)$18,700 $19,455 $19,074 $—$—TOTAL $18,700 $—$19,455 $19,074 $—$— PROJECT DESCRIPTION The Joint Use Facility is used by Maintenance staff on the lower level and Operations staff on the upper level. This building contains nine bays consisting of Aircraft Rescue Fire Fighting (ARFF) usage, joint use equipment storage and mechanic bays. JUSTIFICATION This project will include replacing three doors in FY18, three doors in FY20 and three doors in FY21. These doors are over 22' wide and 15' high and have reached their useful life. The new doors will provide an insulation value of R17.5 to be more energy-efficient than the current doors. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 167 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Upgrade Pavement Sensor Equipment and Software DEPARTMENT:51 FD/CIP NO:390-1691 $35,650 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Software $35,650 $—$—TOTAL $35,650 $—$—$—$—$— B. PROJECT FINANCING Sales Tax Fund (20%)$35,650 $—$—TOTAL $35,650 $—$—$—$—$— PROJECT DESCRIPTION This will provide for upgrading the pavement sensor equipment and software. JUSTIFICATION This system is used to monitor runway pavement temperature and atmospheric conditions during snow and ice events, as well as, extreme heat. Originally installed in the mid 1990's this system is out-of-date and we are no longer able to get replacement parts. By monitoring the pavement conditions we are able to keep the runways open for Airline and general aviation aircraft. This system also helps to reduce the amount of deicing products used on the pavement. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 168 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Auto Fuel Tank and Dispenser at Terminal DEPARTMENT:51 FD/CIP NO:390-2602 $89,125 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Equipment $57,925 Construction $31,200 $—$—TOTAL $89,125 $—$—$—$—$— B. PROJECT FINANCING State Grant $89,125 $—$—TOTAL $89,125 $—$—$—$— PROJECT DESCRIPTION This project will provide for locating an auto fuel tank and dispenser at the new terminal facility for use by the rental car agencies. JUSTIFICATION Currently the rental car agencies, who are located in the new terminal facility on Aviation Drive, have to leave the Airport and drive to the existing fueling station located on Airport Road. This would locate an auto fueling station next to their rental car parking spaces at their new location. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 169 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works New Terminal Entrance Road Monument/ Sign DEPARTMENT:51 FD/CIP NO:390-2716 $120,000 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Construction $120,000 $—$—TOTAL $120,000 $—$—$—$—$— B. PROJECT FINANCING Private Participant $120,000 $—$—TOTAL $120,000 $—$—$—$—$— PROJECT DESCRIPTION This will provide for the construction of a monument/sign at the entrance to the new terminal facility. JUSTIFICATION This project was bid as part of the new terminal land side paving project but was eliminated due to cost. This will provide an aesthetically pleasing gateway sign to the new terminal facility. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 170 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Replace Snow Removal Equipment (SRE)DEPARTMENT:51 FD/CIP NO:390- $1,740,750 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Equipment $1,740,750 $—$—TOTAL $—$1,740,750 $—$—$—$— B. PROJECT FINANCING FAA Entitlement Funds $1,000,000 FAA Discretionary Funds $566,675 GO Debt (Sales Tax Fund 20%)$174,075 $—$—TOTAL $—$1,740,750 $—$—$—$— PROJECT DESCRIPTION This will provide for replacing the current snow removal equipment used on the airfield for cleaning taxiways and runways during snow events. JUSTIFICATION This will replace the Airport's existing snow removal equipment including the broom, truck and loader used to maintain the airfield during snow events.The airfield is maintained 24/7 to keep the runways/taxiways clear for aircraft landings and takeoffs including the Airlines, corporate and general aviation aircraft RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 171 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Construct Airfield Lighting Vault DEPARTMENT:51 FD/CIP NO:390- $1,469,000 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Design & Engineering $235,000 Equipment $1,234,000 $—$—TOTAL $—$1,469,000 $—$—$—$— B. PROJECT FINANCING FAA Entitlement Funds $692,357 FAA Discretionary Funds $629,743 Sales Tax Fund (20%)$146,900 $—$—TOTAL $—$1,469,000 $—$—$—$— PROJECT DESCRIPTION This will provide for replacing the existing airfield lighting vault. JUSTIFICATION This will replace the Airport's existing airfield lighting vault which was installed when the airfield was originally constructed. The vault will be relocated to the existing maintenance facility. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 172 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Update Airport Layout Plan and GIS DEPARTMENT:51 FD/CIP NO:390- $341,825 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Design & Engineering $341,825 $—$—TOTAL $—$341,825 $—$—$—$— B. PROJECT FINANCING FAA Entitlement Funds $307,643 DRA Distribution $34,182 $—$—TOTAL $—$341,825 $—$—$—$— PROJECT DESCRIPTION This project will reflect the numerous projects that have occurred at the Airport since the Airport Master Plan was updated in 2005. JUSTIFICATION This will provide for updating the current Airport Master Plan including the Airport Layout Plan (ALOP) and GIS databases to reflect the numerous changes that have occurred in the last fifteen years (T-Hangar replacement, Paving replacement, Terminal Building Construction, etc.) per FAA requirements. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Regional Mobility. 173 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Replace Automatic Bi-fold doors on Dubuque Jet Center Building DEPARTMENT:51 FD/CIP NO:390 $30,000 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Construction $15,000 $15,000 $—$—TOTAL $—$15,000 $15,000 $—$—$— B. PROJECT FINANCING DRA Distribution $15,000 $15,000 $—$—TOTAL $—$15,000 $15,000 $—$—$— PROJECT DESCRIPTION This project will replace the four automatic bi-fold entrance doors on the Dubuque Jet Center. JUSTIFICATION These four entrance doors are over 15 years old and are used several times a day. Staff and customers of the Dubuque Jet Center and Administrative Offices enter and exit through these doors. Passengers, pilots and customers boarding general aviation and corporate aircraft, as well as, their luggage, and other items loaded onto and off of the aircraft go through these "hands free" doors. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 174 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Cap off old wells on Airport DEPARTMENT:51 FD/CIP NO:390 $28,000 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Construction $28,000 $—$—TOTAL $—$28,000 $—$—$—$— B. PROJECT FINANCING Sales Tax Fund (20%)$28,000 $—$—TOTAL $—$28,000 $—$—$—$— PROJECT DESCRIPTION This project will cap off the old wells no longer in use at the Airport. JUSTIFICATION The Airport buildings, including the new terminal building, were connected to City water services during 2016. Per Department of Natural Resources regulations, any wells no longer in service need to be decommissioned and capped. Two wells originally used to provide water to the Airport and its customers, one constructed in 1948 and the other in 1996, need to be capped to meet the DNR requirements. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 175 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Relocate Airport D-Marc from Old Terminal Building DEPARTMENT:51 FD/CIP NO:390- $186,000 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Construction $186,000 $—$—TOTAL $—$186,000 $—$—$—$— B. PROJECT FINANCING DRA Distribution $186,000 $—$—TOTAL $—$186,000 $—$—$—$— PROJECT DESCRIPTION The old terminal building, which is scheduled for demolition, is the D-Marc location for the Airport phones. JUSTIFICATION If the building is removed, the Airport phone system will need to be relocated to a new location. The two 400 pair feeder telephone cables going into and out of the old terminal building will be rerouted from the existing D-Marc to a new designated location. This project will include Century Link moving their D-Marc, the trenching of lines and pulling the new copper lines and constructing a new secure building for locating the D-Marc. This project must be completed before the building is demolished. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Resource Management. 176 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Pavement Condition Index (PCI)DEPARTMENT:51 FD/CIP NO:390-1060 $124,272 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS $77,272 Service Contract $47,000 $48,000 $—$77,272 TOTAL $—$—$47,000 $—$—$48,000 B. PROJECT FINANCING $71,360 FAA Discretionary Funds $42,300 $43,200 $4,262 DRA Distribution $4,700 $4,800 $1,650 Sales Tax Fund (20%) $—$77,272 TOTAL $—$—$47,000 $—$—$48,000 PROJECT DESCRIPTION This project provides for the Pavement Condition Index (PCI), which is a method used to obtain a value for airfield pavements through a visual survey of the pavement. JUSTIFICATION The PCI is a numerical rating of the pavement condition that can be used on both asphalt and concrete surfaces. This was adopted by the FAA to determine pavement conditions on areas financed by the FAA (namely airside) to assure they are being adequately maintained to reach their full life expectancy and to program the nationwide replacement of such pavements. This PCI is required every three years by the FAA. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Transportation Goal Six: To provide safe and efficient airport services to the community and the region, in coordination with the Airport Master Plan, objective 6.5) Implement the Airport Master Plan, through various funding resources, as available. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Resource Management. 177 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Security Camera and Monitoring Equipment Replacement DEPARTMENT:51 FD/CIP NO:390 $85,000 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Equipment $85,000 $—$—TOTAL $—$—$85,000 $—$—$— B. PROJECT FINANCING Sales Tax Fund (20%)$85,000 $—$—TOTAL $—$—$85,000 $—$—$— PROJECT DESCRIPTION This will provide for replacement of the security cameras and monitoring equipment of Airport buildings and facilities. JUSTIFICATION New cameras were purchased and installed for the new terminal building and connected to the City's milestone security camera system. This will replace the remaining old cameras and monitoring equipment securing the rest of the Airport buildings and facilities. The purchase of this new equipment will allow the entire Airport to be on the milestone system. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 178 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Asphalt Pavement Repair DEPARTMENT:51 FD/CIP NO:390-2664 $358,565 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS $14,815 Design & Engineering $17,960 $15,000 $147,590 Construction $178,200 $135,000 $—$162,405 TOTAL $—$—$—$—$196,160 $150,000 B. PROJECT FINANCING $162,405 DRA Distribution $196,160 $150,000 $—$162,405 TOTAL $—$—$—$—$196,160 $150,000 PROJECT DESCRIPTION This project provides for asphalt repairs at the Airport. JUSTIFICATION This will provide for asphalt repairs for all the Airport land side paved areas as needed. These projects are coordinated with the Engineering Department to determine which repairs are needed. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.2) Support accessibility to City-owned buildings, structures, facilities and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. 179 DEPARTMENT:STATE PROGRAM:PROJECT TITLE:PROGRAM:2C TOTAL PROJECT COST Airport Public Works Rehabilitate Taxiway Alpha DEPARTMENT:51 FD/CIP NO:390- $271,200 2016 ACTUAL EXP 2017 AMENDED BUDGET PROJECT BUDGET 2017-18 2018-19 2019-20 2020-21 2021-22 BEYOND 2022 A. EXPENDITURE ITEMS Design & Engineering $271,200 $342,500 Construction $3,197,188 $—$—TOTAL $—$—$—$—$271,200 $3,539,688 B. PROJECT FINANCING FAA Entitlement Funds $1,000,000 FAA Discretionary Funds $244,080 $2,185,719 Sales Tax Fund (20%)$27,120 $353,969 $—$—TOTAL $—$—$—$—$271,200 $3,539,688 PROJECT DESCRIPTION This will provide for rehabilitating Taxiway Alpha. Design will be completed in FY2019, Taxiway A-southeast in FY2020, Taxiway A-northwest in FY2021 and Taxiway A ramp in FY2022. JUSTIFICATION The preliminary design phase for the rehabilitation of Taxiway A including planning, schematic design and environmental assessment will be completed in FY19. Construction on Taxiway A - southeast including finish grading, drainage, under drains, paving, airfield lighting, marking and turfing will be completed in FY20. Construction on Taxiway A - northwest including finish grading, drainage, under drains, paving, airfield lighting, marking and turfing will be completed in FY21. Taxiway A - ramp construction will be completed in FY22 including finish grading, drainage, under drains, paving, airfield lighting, marking and turfing. RELATIONSHIP TO OTHER PROJECTS This project implements the Comprehensive Plan's Infrastructure Goal Ten: To provide, maintain, and improve City-owned buildings, structures, facilities, and properties, objective 10.1) Support maintaining and improving the energy efficiency and aesthetic qualities of City-owned buildings, structures, facilities, and properties. RELATIONSHIP TO SUSTAINABILITY PRINCIPLES This project implements the Sustainable Principle of Regional Economy and Reasonable Mobility. -107- Airport -108- This page intentionally left blank. -109- AIRPORT DEPARTMENT Budget Highlights FY 2016 Actual FY 2017 Budget FY 2018 Requested % Change From FY 2017 Budget Expenses Employee Expense 1,418,471 1,468,689 1,463,009 (0.4)% Supplies and Services 2,463,793 2,708,187 2,414,900 (10.8)% Machinery and Equipment 62,052 196,193 181,760 (7.4)% Total 3,944,316 4,373,069 4,059,669 (7.2)% Abated Debt 316,806 374,011 372,706 (0.3)% Total Expense 4,261,122 4,747,080 4,432,375 (6.6)% Resources Passenger Facility Charge 205,730 202,734 204,934 1.1 % Sales Tax 54,669 120,260 115,216 (4.2)% Operating Revenue 3,151,813 3,349,760 3,308,627 (1.2)% Total Revenue 3,412,212 3,672,754 3,628,777 (1.2)% Total Property Tax Support 848,910 1,074,326 803,598 (270,728) Percent Decrease (25.2)% Percent Self Supporting 80.9%79.7%82.3% Personnel - Authorized FTE 17.96 17.96 17.96 Improvement Package Summary 1 of 3 This improvement package provides funding for additional marketing funds.The consolidation of the airline industry continues to limit the number of air carriers while competition for their services by other airports continues to increase. Numerous surveys conducted show the demand for expanded air service exists within our service area, but without additional funds we will not have the ability to simultaneously market existing service and solicit expanded service. This would provide for additional funds for research materials and analysis to justify specific routes, airfares and frequencies. The FY 2017 adopted budget includes $95,250 of property tax funds for promotion expense. Related Cost:$25,000 Tax Funds Recurring Recommend - No Property Tax Impact:$0.0105 0.10% Activity: Airport Administration 2 of 3 This improvement package would provide funding for additional WiFi antennas. This would provide for additional WiFi capability at the Airport. Adding exterior antennas at strategic points around the airport would ensure a needed framework of connectivity and possible expansion into future technologies and -110- uses. This additional WiFi area will increase reliability for airfield operations, Dubuque Jet Center and airport staff. Related Cost:$8,500 Tax Funds Non-Recurring Recommend - No Property Tax Impact:$0.0036 0.03% Activity: Airport Operations 3 of 3 This improvement package would provide funding for a quick charge ground power unit for aircraft. These ground power units are designed to perform starting, powering up aircraft systems and maintenance functions. This is a combination power supply and battery pack for starting aircraft when no AC power source is available. When connected to AC power, the depleted aircraft batteries can be charged in a matter of hours with the built-in power supply/battery charger. This would be another service and additional revenue source provided by the Dubuque Jet Center. This will satisfy the ground power requirements of most business jets by providing on-board air conditioning and other high draw aircraft systems. Related Cost:$4,650 Tax Funds Non-Recurring Recommend - No Property Tax Impact:$0.002 0.02% Activity: FBO Operation Significant Line Items at Maintenance Level (Without Recommended Improvement Packages) Employee Expense 1. FY 2018 employee expense reflects a 2.0% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution is unchanged at 8.93% and the employee contribution is unchanged at 6.18% in FY 2018. 3. The City portion of health insurance expense is unchanged from $1,325 in FY 2017 to $1,325 in FY 2018 per month per contract. 4. The sick leave payout included in Airport’s budget decreased from $12,396 in FY 2017 to $7,349 in FY 2018. 5. Overtime decreased from $139,620 in FY 2017 to $134,775 in FY 2018. FY 2016 Actual was $103,285. Supplies & Services 6. Property Maintenance decreased from $78,782 in FY 2017 to $74,123 in FY 2018 based on FY 2016 Actual plus 2%. 7. Motor Vehicle Fuel decreased from $452,168 in FY 2016 to $375,335 in FY 2018 based on a three year average. FY 2016 Actual was $279,196. The FY 2018 three year average cost per gallon is $2.89 and the FY 2016 Actual average cost per gallon was -111- $2.01. The purchase of Motor Vehicle Fuel is offset by Motor Vehicle Fuel sales with net cost of $7,864 in FY 2018 compared to $30,108 in FY 2017 budget and -$3,444 FY 2016 Actual. FY 2018 estimated usage is as follows: Airport Administration 624 gallons; Airport Operations and Maintenance 23,167 gallons; and FBO Operations 360,420 gallons (which represents fuel to be sold to customers). 8. Aviation Fuel expense has decreased from $1,336,021 in FY 2017 to $1,130,394 in FY 2018 based on a three year average. In FY 2016 Actual gallons sold were 488,062 and the estimated amount expected to be sold in FY 2018 is 460,657 gallons. The FY 2018 three year average cost per gallon is $2.72 and the FY 2016 Actual average cost per gallon was $2.05. The purchase of Aviation Fuel is offset by Aviation Fuel sales with net revenue of $651,086 in FY 2018 compared to $588,526 FY 2017 budget and $696,909 FY 2016 Actual. 9. Promotion decreased from $120,250 in FY 2017 to $118,960 in FY 2018. Actual expenses in FY 2016 were $88,849. The subscription to Flightview was moved to subscription line item in FY 2018 (-$2,030). The budget in FY 2017 includes a State Air Sustainment grant of $25,000 and FY 2018 includes a State Air Sustainment grant of $28,000. Machinery & Equipment 10. Purchase of equipment for FY 2018 includes ($181,760): FBO Operations Conveyor Belt Luggage Loader $55,000 Scully Optic System for Jet 1 $3,500 Scully Optic System for LL1 $1,000 Scully Optic System for Jet 2 $3,500 2 Stage Walk Behind Snow Blower $2,800 Aircraft Towbars $2,000 Handheld Radios $1,000 Safety Equipment $220 Shop Equipment $300 Airport Operations Toro Zero Turn Mower $18,000 Case Tractor MTC/Loader $62,000 Kawaski Mule 3010 $22,000 Shop Equipment $3,290 Airfield Signage $5,000 Safety Equipment $1,200 Portable Radios $800 Terminal Building Maintenance Shop Equipment $150 Total $181,760 -112- Debt Service 11. FY 2018 debt service includes the following ($372,706): Amount Debt Series Source Purpose Final Payment Call Date $23,202 2017A Sales Tax 20%Airport Improvements 2030 2025 154,778 2012C PFC New Terminal 2032 2019 11,085 2012C Sales Tax 20%Airport Improvements 2032 2019 52,556 2012I General Fund T-Hangar Construction 2020 2018 64,596 2014B Sales Tax 20%Airport Improvements 2029 2021 44,554 2016C PFC Terminal Roads/Apron 2036 2024 21,935 Planned Sales Tax 20%Taxiway F 2038 $372,706 Total Airport Debt Service Revenue 12. TSA Rent increased from $42,000 in FY 2017 to $49,392 in FY 2018 due to the change in rent at the new terminal facility. 13. Car Rental decreased from $103,000 in FY 2017 to $100,738 in FY 2018 based on FY FY 2016 Actual of $100,738. 14. FAA Office rent increased from $25,000 in FY 2017 to $25,127 in FY 2018. 15. Advertising Displays increased from $4,700 in FY17 Budget to $86,400 in FY18 Budget. The Airport is now handling advertising in-house in the Terminal using digital monitors. 16. American decreased from $78,500 in FY 2017 to $77,612 in FY 2018 based on FY 2016 Actual of $77,612. 17. Aircraft Service fees increased from $52,000 in FY 2017 to $76,433 in FY 2018 based on FY 2016 Actual plus 2%. 18. Aviation Fuel Sales decreased from $1,924,547 in FY 2017 to $1,781,480 in FY 2018 based on a three year historical average. 19. Auto Gas Fuel Sales decreased from $422,060 in FY 2017 to $367,471 in FY 2018 based on a three year historical average. Miscellaneous 20. The Airport Department budget with abated debt is 82.3% self-supporting in FY 2018 versus the 80% self-supporting in FY 2017. -113- DUBUQUE REGIONAL AIRPORT The Dubuque Regional Airport provides quality, viable, competitive Airport services and facilities while promoting sustainable economic development within the region. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -114- DUBUQUE REGIONAL AIRPORT The Airport is supported by 17.96 full-time equivalent employees, which accounts for only 33.01% of the department expense as seen below. Overall, the departments’ expenses are expected to decrease by -6.63% in FY 2018 compared to FY 2017. Expenditures by Category by Fiscal Year -115- DUBUQUE REGIONAL AIRPORT Airport Administration Overview The Dubuque Regional Airport is owned by the City of Dubuque and is operated and managed by an Airport Commission as a department of the City of Dubuque. Airport Administration is responsible for the analysis, priorities, and the appropriate allocation of resources for the management and control of all Airport employees, facilities, property and legislative priorities. Dubuque Regional Airport currently has commercial airline service with American Airlines providing jet service through Chicago O’Hare International Airport and leisure flights with Sun Country Airlines to Laughlin, NV and Gulfport/Biloxi, MS. The Airport consists of 1,248 acres, two runways (6,500 x 100 and 6,325 x 150), air traffic control tower, airline and general aviation terminals, numerous corporate and private use hangars and a joint use facility, which includes airfield maintenance and 24 hour aircraft rescue firefighting staff. The University of Dubuque fields a fleet of approximately 24 light aircraft for their aviation program while other aircraft are based locally and are provided aircraft maintenance by privately operated company. Several large local companies also base their corporate aircraft fleet at the Airport. The commercial business park at the Airport currently has two long-term tenants. Administration Funding Summary 10051100 FY 2016 Actual FY 2017 Budget FY 2018 Requested Expenditures $970,012 $539,133 $534,883 Resources $694,827 $671,467 $779,625 Administration Position Summary FY 2018 Airport Manager 1.00 Airport Operations/Maint. Supervisor 1.00 Accountant 0.75 Marketing Coordinator 0.70 Total Full-Time Equivalent Employee’s 3.45 Highlights of the Past Year This past year was an exciting time at the Airport. A few of our accomplishments were: • Hosted the annual Mobile Aircraft Rescue Firefighting Training (MARFT) • Hosted the Iowa Public Airports Association Conference • Media Day at the New Terminal Facility • Grand Opening of the New Terminal Facility • Construction of a large corporate aircraft hangar • Started ground handling services for commercial airline charters -116- DUBUQUE REGIONAL AIRPORT The Airport hosted the Iowa Public Airports Association (IPAA) annual conference in May, 2016. IPAA provides information to, and represents the interests of, all of the public- use airports in Iowa. This was the first time in over 20 years of this event that it was held outside of Des Moines. 2016 Iowa Public Airports Association Conference ThThee The local media were given a preview of the New Terminal Facility on May 11, 2016 -117- DUBUQUE REGIONAL AIRPORT The Dubuque Regional Airport Commercial Airline Terminal was originally recommended for new construction in the 2005 Airport Master Plan. Since this time, the Dubuque Regional Airport Commission, along with Airport staff, their consulting engineers, and both public and private sectors have devoted their time and effort to completing this multi-year project. New Terminal Facility - Grand Opening/Ribbon Cutting June 9, 2016 Performance Measures Airport Administration - Activity Statement Provide quality, viable, competitive airport services and facilities while promoting sustainable economic development within the region. -118- DUBUQUE REGIONAL AIRPORT Goal: Economic Prosperity Outcome #1: Economic Development by continuing to promote the Airport provided services while providing the highest level of service and continued safe operation in full compliance with all applicable security regulations. • The Airport held their annual Open House/EAA Fly-In Breakfast in September with an estimated over 2,000 people in attendance. This event is hosted by the Airport with American Airlines, TSA, University of Dubuque and other Airport tenants providing staff and information to the public. Transportation Security Administration booth at Airport Open House According to the 2009 Economic Impact Report issued by the Iowa Office of Aviation the Dubuque Regional Airport has an annual economic impact of $34,386,200. -119- DUBUQUE REGIONAL AIRPORT Goal: Improved Connectivity Outcome #2: Continue to stabilize and expand commercial airline service for the Tri- State region to meet existing and future passenger traffic needs. Airport Staff met with American Airlines, Sun Country Airlines, Allegiant and Eastern Airlines for continued or expanded service. Dubuque Jet Center Overview The Airport Commission operates the Dubuque Jet Center which offers a Fixed Based Operation (FBO) to assist with all general aviation needs. The FBO normally operates 17 hours a day (24 hours with notice) providing sales of aviation fuel, ground handling, hangaring and concierge services for general aviation, corporations, and the commercial airlines. The FBO makes arrangements for catering, car rental, hotels, chartering services, recommends places to visit, restaurants to dine, directions to local facilities and attractions, as well as calls for reservations and shuttles. Dubuque Jet Center Funding Summary 10051200 FY 2016 Actual FY 2017 Budget FY 2018 Requested Expenditures $1,842,356 $2,535,976 $2,245,169 Resources $2,087,738 $2,530,707 $2,377,552 Dubuque Jet Center Position Summary FY 2018 Fixed Base Operations Supervisor 1.00 Asst. fixed Base Operations Supervisor 1.00 Accountant 0.25 Line Service Worker 3.53 Receptionist 1.50 Total Full-Time Equivalent Employees 7.28 -120- DUBUQUE REGIONAL AIRPORT Highlights of the Past Year Annual North American Trainers Association Formation Clinic in Dubuque Performance Measures Dubuque Jet Center - Activity Statement Provide the aviation community with a responsive and customer service driven Fixed Base Operation (FBO), which characterizes our slogan of "Hospitality is our Hallmark" by providing all aircraft, crew and passengers with competitive quality services in a safe, efficient, and hospitable manner. Goal: Financially Responsible & High Performance Organization Outcome #1: Maintain and operate a safe, responsive, efficient and hospitable oriented Fixed Base Operation to promote fueling and aviation ground handling services at Dubuque Jet Center. • • The FBO helps to support local and transient businesses by providing ground handling services for their aircraft and passengers. Ground handling services for the commercial charter airlines includes servicing the aircraft with fuel, lavatory services, light cleaning of interior of aircraft and deicing, as well as, loading and unloading of passenger baggage, and check-in and boarding of passengers. Dubuque Jet Center staff apply deicing fluid to a business jet. -121- DUBUQUE REGIONAL AIRPORT • Airport Fixed Base Operations Staff receive specialized training for fueling, ground handling, deicing and airfield operations. Airport employees began providing ground handling services for charters in May, 2016 • The Dubuque Jet Center helps with hangaring and fueling University of Dubuque aircraft. Construction was completed on this corporate aircraft hangar in June, 2016 Airport Operations and Maintenance Overview Airport Operations and Maintenance provides an Airport which is open to the flying public year- round by ensuring Airport safety and compliance and is responsible for meeting FAA Part 139 compliance standards for all the runways, taxiways, Navaids, fueling agents, firefighting, parking areas and roadways, as well as ensuring compliance with EPA, OSHA, DNR, FCC, Safety Management Systems (SMS), NFPA, Spill Prevention Control Program and Storm Water Pollution Prevention Plan, ADA, and TSA requirements. -122- DUBUQUE REGIONAL AIRPORT 24-hour coverage is provided by three Operations Specialists whose duties include aircraft rescue and firefighting services (ARFF), parking enforcement, medical first responder and security services for certified air carriers. Airport Maintenance is responsible for maintaining the Airport in an operationally safe, secure and efficient manner by providing for the maintenance of runways and taxiways, parking lots, entrance road, supervision of farm lease operations, weed and grass control, snow/ice removal on both landside and airside, monitoring water quality and wastewater treatment facility. The Airport is required to have an annual FAA inspection for Part 139 compliance. This incorporates everything the airport can control such as, pavement conditions, maintenance, emergency procedures, lighting, navigational aids, and equipment to maintain these items, as well as all the buildings necessary to house equipment and staff. The airport can’t control outside influences such as aircraft arrivals and departures. Operations and Maintenance Funding Summary FY 2016 Actual FY 2017 Budget FY 2018 Requested Expenditures $924,731 $1,063,381 $1,079,453 Resources $369,248 $147,586 $151,450 Operations and Maintenance Position Summary FY 2018 Airport Operations Specialist 3.00 Mechanic 1.00 Maintenance Worker 3.00 Laborer 0.23 Total FT Equivalent Employees 7.23 Performance Measures Airport Operations and Maintenance - Activity Statement Ensure continued safe operations of the Airport and all facilities while maintaining safety and security for regional travelers. Goal: Improved Connectivity Outcome #1: Ensure airport safety by maintaining Part 139 safety compliance. • Maintain a secure facility in full compliance with all applicable FAA and TSA security regulations and policies. -123- DUBUQUE REGIONAL AIRPORT • Extensive documentation utilizing all the Federal Aviation Administration guidelines for safety and security is maintained daily. This documentation includes an airport snow and ice plan, emergency evacuation plan, drivers program, and daily inspections of airside and landside facilities. Outcome #2: Maintain a safe airside and landside by providing a maintenance program for 28 miles of pavement, 450 acres of grass and six miles of security fence. • Maintaining a safe airside and landside includes mowing to remove visual and operational hazards for aircraft and maintaining the aesthetics of the grounds by keeping them properly trimmed, efficient snow removal in winter, pavement improvements to prevent deterioration of runways, taxiways and all landside road surfaces and maintain all airfield signage, lighting, pavement markings. -124- DUBUQUE REGIONAL AIRPORT Airport staff work on replacing an area of concrete on a taxiway Outcome #3: Airport Rescue and Fire Fighting (ARFF) • Provide 24 hour FAA Part 139 Aircraft Rescue Fire Fighting and First Responder Medical services. • Provide aircraft rescue and fire-fighting coverage, emergency medical, security, and law enforcement support in accordance with applicable FAA and TSA requirements. Triennial Mobile Aircraft Fire Fighting Training (MAFFT) was held in Dubuque in September of 2015. -125- Recommended Operating Revenue Budget - Department Total 51 - AIRPORT Fund Account Account Title FY15 Actual Revenue FY16 Actual Revenue FY17 Adopted Budget FY18 Recomm'd Budget 252 43110 INVESTMENT EARNINGS 1,948 2,698 0 2,698 100 43236 ADVERTISING DISPLAYS 3,917 11,702 4,700 86,400 100 43238 AIRCRAFT SERVICE FEE 51,203 76,433 52,000 76,433 100 43242 RENT, FARM LAND 67,136 67,136 67,136 71,000 100 43251 RENTS & CONCESSIONS 3,660 3,702 3,440 3,440 100 43253 PROMOTION ITEMS 17 473 50 473 100 43255 VENDING MACH COMMISSION 2,703 2,674 800 1,426 100 43257 RENTAL, TRAILER LOT 2,200 1,980 2,640 0 100 43271 T HANGAR RENT 70,365 69,733 71,040 75,000 100 43272 TSA RENT 37,704 37,495 42,000 49,392 100 43274 NORTH FARM HOUSE RNT 6,840 6,840 6,600 6,600 100 43275 CAR RENTAL 103,414 100,738 103,000 100,738 100 43276 FAA OFFICE RENT 31,670 25,127 25,000 25,127 100 43278 A.Y. MCDONALD 5,273 5,276 5,275 4,634 100 43279 UNIVERSITY OF DUBUQUE 73,043 95,337 80,675 95,337 100 43280 LANDING FEES 3,496 5,571 4,500 5,571 100 43282 SECURITY GATE FEES 30 0 0 0 100 43283 AIRLINE STORAGE/UPLIFT 21,802 29,155 27,825 29,155 100 43285 AMERICAN EAGLE 78,188 77,612 78,500 77,612 100 43286 HANGARING, GEN.AVIATION 82,808 89,886 83,000 89,886 100 43287 MAINT HANGAR RENT 18,544 16,947 18,545 18,604 100 43290 CORPORATE HANGAR 74,602 76,592 72,990 70,805 100 43291 COMMERCIAL LAND RENT 14,645 6,196 13,464 14,485 43 - USE OF MONEY AND PROPERTY 755,208 809,303 763,180 904,816 400 44100 BAB SUBSIDY NON GRANT 3,011 2,900 3,011 2,900 44 - INTERGOVERMENTAL 3,011 2,900 3,011 2,900 100 45701 STATE GRANTS 0 28,000 25,000 28,000 45 - STATE GRANTS 0 28,000 25,000 28,000 100 51340 LONG-TERM PARKING FEES 224,563 205,582 0 0 100 51505 PUBLIC SAFETY 78,450 78,450 78,450 78,450 100 51510 AVIATION FUEL SALES 1,787,937 1,576,310 1,924,547 1,781,480 100 51515 AUTO GAS FUEL SALES 319,572 282,640 422,060 367,471 100 51520 OIL 1,790 2,160 1,800 2,160 100 51525 FUEL FLOW 117,821 122,015 111,273 115,164 252 51535 RENTAL CAR FEE 61,275 57,540 61,000 57,540 100 51540 CHARTERS GROUND HANDLING 0 7,581 0 7,581 100 51926 PILOT SUPPLIES 152 270 200 270 100 51963 CATERING 13,258 16,629 15,000 16,629 51 - CHARGES FOR SERVICES 2,604,818 2,349,177 2,614,330 2,426,745 100 53204 IOWA FUEL TAX REFUND 0 2,442 3,000 2,442 100 53605 MISCELLANEOUS REVENUE 40 186 0 0 100 53620 REIMBURSEMENTS-GENERAL 24,912 22,943 5,250 6,862 53 - MISCELLANEOUS 24,952 25,571 8,250 9,304 400 59100 FR GENERAL 59,013 53,506 48,006 52,556 400 59350 FR SALES TAX CONSTRUCTION 39,832 54,669 120,260 115,216 400 59391 FR PASSENGER FACILITY 163,905 205,730 202,734 204,934 59 - TRANSFER IN AND INTERNAL 262,750 313,905 371,000 372,706 51 - AIRPORT TOTAL 3,650,739 3,528,856 3,784,771 3,744,471 -126- Recommended Operating Expenditure Budget - Department Total 51 - AIRPORT Fund Account Account Title FY15 Actual Expense FY16 Actual Expense FY17 Adopted Budget FY 18 Recomm'd Budget 100 61010 FULL-TIME EMPLOYEES 694,854 703,865 719,433 723,914 100 61020 PART-TIME EMPLOYEES 176,899 184,971 176,491 177,195 100 61030 SEASONAL EMPLOYEES 5,000 6,041 5,239 5,324 100 61050 OVERTIME PAY 86,130 103,285 139,620 134,775 100 61091 SICK LEAVE PAYOFF 9,767 12,396 12,396 7,349 100 61092 VACATION PAYOFF 5,142 0 0 0 100 61310 IPERS 85,986 89,136 92,942 92,978 100 61320 SOCIAL SECURITY 72,521 74,969 80,565 80,215 100 61410 HEALTH INSURANCE 171,360 193,644 190,800 190,798 100 61415 WORKMENS' COMPENSATION 50,467 47,919 48,373 48,580 100 61416 LIFE INSURANCE 618 621 1,439 1,331 100 61645 TOOL ALLOWANCE 200 200 200 200 100 61660 EMPLOYEE PHYSICALS 1,194 1,338 1,191 350 100 61665 OTHER MEDICAL COSTS 0 87 0 0 61 - WAGES AND BENEFITS 1,360,138 1,418,472 1,468,689 1,463,009 100 62010 OFFICE SUPPLIES 1,110 1,603 858 1,635 100 62011 UNIFORM PURCHASES 8,037 2,354 5,029 2,401 100 62013 UNIFORM MAINTENANCE 169 117 172 180 100 62030 POSTAGE AND SHIPPING 676 574 710 573 100 62032 FLAGS 32 2,646 500 1,000 100 62061 DP EQUIP. MAINT CONTRACTS 22,475 12,606 16,634 15,231 100 62062 JANITORIAL SUPPLIES 7,679 7,484 7,833 7,634 100 62064 ELECTRICAL SUPPLIES 10,950 5,857 11,168 5,974 100 62080 CREW CAR RENTAL 496 0 827 500 100 62090 PRINTING & BINDING 2,111 64 668 265 100 62110 COPYING/REPRODUCTION 628 669 633 668 100 62130 LEGAL NOTICES & ADS 1,010 428 919 436 100 62140 PROMOTION 100,102 88,849 120,250 118,960 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 5,379 8,177 5,466 8,340 100 62190 DUES & MEMBERSHIPS 3,785 4,463 3,861 4,052 100 62204 REFUNDS 455 84 0 0 100 62206 PROPERTY INSURANCE 36,823 37,043 38,451 32,277 100 62207 BOILER INSURANCE 96 96 96 0 100 62208 GENERAL LIABILITY INSURAN 66,833 69,266 72,260 74,491 100 62210 SALES TAX 178 206 182 210 100 62211 PROPERTY TAX 2,646 1,842 2,699 1,879 100 62230 COURT COSTS & RECORD FEES 0 0 50 0 100 62310 TRAVEL-CONFERENCES 7,828 6,673 9,248 9,118 100 62320 TRAVEL-CITY BUSINESS 3,811 4,319 6,000 4,405 100 62340 MILEAGE/LOCAL TRANSP 1,507 1,242 1,755 1,268 100 62360 EDUCATION & TRAINING 11,460 17,985 9,339 8,100 100 62411 UTILITY EXP-ELECTRICITY 117,878 119,355 131,042 124,129 100 62412 UTILITY EXP-GAS 28,706 17,820 33,081 19,602 100 62418 UTILITY EXP-REFUSE 3,527 3,591 4,471 3,663 100 62421 TELEPHONE 10,644 9,483 10,783 9,552 100 62424 RADIO/PAGER FEE 900 900 900 927 100 62431 PROPERTY MAINTENANCE 77,238 72,670 78,782 74,123 100 62436 RENTAL OF SPACE 1,961 1,137 1,798 1,854 100 62511 FUEL, MOTOR VEHICLE 316,658 279,196 452,168 375,335 100 62514 FUEL, AVIATION 1,092,164 879,402 1,336,021 1,130,394 100 62515 FUEL, AVIATION - FLOW 111,359 122,015 111,276 115,164 100 62516 FUEL, AVIATION - STORAGE 2,217 1,916 2,825 2,356 100 62521 MOTOR VEHICLE MAINT.22,797 18,932 19,755 19,310 100 62528 MOTOR VEH. MAINT. OUTSOUR 207 188 2,651 191 100 62611 MACH/EQUIP MAINTENANCE 20,786 47,263 35,489 31,826 100 62614 EQUIP MAINT CONTRACT 0 0 25,000 25,000 100 62615 MACH/EQUIP MAINT. OUTSOUR 531 500 924 510 -127- Recommended Operating Expenditure Budget - Department Total 51 - AIRPORT Fund Account Account Title FY15 Actual Expense FY16 Actual Expense FY17 Adopted Budget FY 18 Recomm'd Budget 100 62627 CAMERA MAINTENANCE 0 0 1,530 0 100 62636 DE-ICING PRODUCTS 45,856 30,498 46,773 31,108 100 62642 FOOD PRODUCTS 13,170 14,676 17,416 14,970 100 62645 SPECIAL EVENTS 0 16,999 0 1,000 100 62649 BEVERAGE/ICE 2,540 3,136 2,163 3,199 100 62664 LICENSE/PERMIT FEES 701 1,016 703 1,036 100 62666 CREDIT CARD CHARGE 21,689 25,744 14,870 18,908 100 62667 INTERNET SERVICES 1,008 1,452 1,354 1,772 100 62681 LUBRICATION PRODUCTS 888 1,304 1,913 1,330 100 62686 CRACKSEAL MATERIALS 0 0 500 0 100 62691 AIR SHOW EXPENSE 1,905 483 1,943 493 100 62692 LANDFILL FEES 299 371 305 378 100 62699 CASH SHORT AND OVER 0 125 0 0 100 62710 CONTRACTOR SERVICES 0 0 0 55,000 100 62713 LEGAL SERVICES 58,997 470,371 0 0 100 62726 AUDIT SERVICES 4,900 2,125 5,100 2,200 100 62733 CONTRACT CUSTODIAL 31,837 32,288 42,230 37,500 100 62747 MACH/EQUIPMENT RENTAL 385 385 593 393 100 62761 PAY TO OTHER AGENCY 7,200 7,331 5,200 9,000 100 62767 ENVIRON. TESTING/MON.6,972 6,476 3,020 3,080 62 - SUPPLIES AND SERVICES 2,302,196 2,463,795 2,708,187 2,414,900 100 71120 PERIPHERALS, COMPUTER 10,468 0 8,500 0 100 71156 FURNITURE 1,437 0 0 0 100 71227 SIGNAGE 0 3,620 7,500 5,000 100 71310 AUTO/JEEP REPLACEMENT 10,487 0 0 22,000 100 71313 TRACTOR-REPLACEMENT 0 0 0 62,000 100 71314 TRUCK-REPLACEMENT 0 0 32,000 0 100 71324 SWEEPER/SCRUBBER 0 17,964 0 0 100 71410 SHOP EQUIPMENT 2,232 3,855 3,740 3,740 100 71420 EARTH COMPACTOR 0 0 3,800 0 100 71421 HIGH PRESSURE SPRAY 3,500 0 0 0 100 71511 PUMPS 0 0 11,875 0 100 71517 LIGHTING EQUIPMENT 0 1,214 0 0 100 71550 MISCELLANEOUS EQUIPMENT 1,000 0 95,075 63,000 100 71611 MOWING EQUIPMENT 0 0 0 18,000 100 71616 SNOW BLOWER 0 0 0 2,800 100 71619 OTHER MAINT. EQUIPMENT 20,468 31,913 16,975 2,000 100 72113 OTHER SAFETY EQUIPMENT 580 1,374 9,820 1,420 100 72116 SAFETY EQUIP., FIRE DEPT 290 150 148 0 100 72410 PAGER/RADIO EQUIPMENT 32 1,115 2,000 1,800 100 72417 CAMERA RELATED EQUIPMENT 166 0 1,400 0 100 72418 TELEPHONE RELATED (267)847 3,360 0 71 - EQUIPMENT 50,393 62,052 196,193 181,760 400 74111 PRINCIPAL PAYMENT 172,856 213,731 244,645 259,164 400 74112 INTEREST PAYMENT 92,905 103,075 129,366 113,542 74 - DEBT SERVICE 265,761 316,806 374,011 372,706 252 91390 TO AIRPORT CONSTRUCTION 5,903 101,912 0 120,000 91 - TRANSFER TO 5,903 101,912 0 120,000 51 - AIRPORT TOTAL 3,984,391 4,363,037 4,747,080 4,552,375 -128- Recommended Expenditure Budget Report by Activity & Funding Source 51 - AIRPORT AIRPORT ADMIN. - 51100 FUNDING SOURCE: GENERAL Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget EQUIPMENT 5 1,440 0 SUPPLIES AND SERVICES 611,185 168,470 160,648 WAGES AND BENEFITS 358,822 369,223 374,235 AIRPORT ADMIN.970,012 539,133 534,883 FBO OPERATION - 51200 FUNDING SOURCE: GENERAL Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget EQUIPMENT 5,133 110,598 69,320 SUPPLIES AND SERVICES 1,434,154 2,032,986 1,779,611 WAGES AND BENEFITS 403,070 392,392 396,238 FBO OPERATION 1,842,356 2,535,976 2,245,169 AIRPORT OPERATIONS - 51300 FUNDING SOURCE: DEBT SERVICE Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget DEBT SERVICE 316,806 374,011 372,706 AIRPORT OPERATIONS 316,806 374,011 372,706 AIRPORT OPERATIONS - 51400 FUNDING SOURCE: CUSTOMER FACILITY CHARGE Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget EQUIPMENT 38,320 83,305 112,290 SUPPLIES AND SERVICES 229,832 273,002 274,627 TRANSFER TO 101,912 0 120,000 WAGES AND BENEFITS 656,579 707,074 692,536 AIRPORT OPERATIONS 1,026,643 1,063,381 1,199,453 TERMINAL, BLDG MAINT. - 51700 FUNDING SOURCE: GENERAL Account FY16 Actual Expense FY17 Adopted Budget FY18 Recomm'd Budget EQUIPMENT 18,595 850 150 SUPPLIES AND SERVICES 188,622 233,729 200,014 TERMINAL, BLDG MAINT.207,216 234,579 200,164 AIRPORT TOTAL $4,363,033.72 $4,747,080.00 $4,552,375.00 -129- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 51 AIRPORT DEPARTMENT FY 2016 FY 2017 FY 2018 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 3250 GE-41 AIRPORT MANAGER 1.00 $107,076 1.00 $109,388 1.00 $111,147 100 1995 GE-35 OPER/MAINT.SUPERVISOR 1.00 $79,101 1.00 $80,920 1.00 $82,122 100 1875 GE-33 FBO SUPERVISOR 1.00 $70,444 1.00 $71,965 1.00 $73,123 100 GE-30 ASSISTANT FBO SUPERVISOR 1.00 $59,926 1.00 $61,231 1.00 $62,504 100 460 GE-30 ACCOUNTANT 1.00 $61,688 1.00 $63,032 1.00 $64,045 100 2525 GD-10 MECHANIC 1.00 $56,632 1.00 $57,827 1.00 $56,498 100 2205 GD-06 MAINTENANCE WORKER 3.00 $152,147 3.00 $156,609 3.00 $154,166 100 1875 NA-13 AIRPORT OPER SPECIALIST 3.00 $113,728 3.00 $118,461 3.00 $120,309 TOTAL FULL TIME EMPLOYEES 12.00 $700,742 12.00 $719,433 12.00 $723,914 61020 Part Time Employee Expense 100 NA-44 RECEPTIONIST 1.50 $45,593 1.50 $47,232 1.50 $48,484 100 236 GE-28 MARKETING COORDINATOR 0.70 $36,973 0.70 $37,768 0.70 $38,376 100 1927 NA-27 LINE SERVICEWORKER 3.53 $92,634 3.53 $91,491 3.53 $90,335 TOTAL PART TIME EMPLOYEES 5.73 $175,200 5.73 $176,491 5.73 $177,195 61030 Seasonal Employee Expense 100 896 NA-11 LABORER 0.23 $5,129 0.23 $5,239 0.23 $5,324 TOTAL SEASONAL EMPLOYEES 0.23 $5,129 0.23 $5,239 0.23 $5,324 TOTAL AIRPORT 17.96 $881,071 17.96 $901,163 17.96 $906,433 -130- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2016 FY 2017 FY 2018 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Airport Administration-FT 10051100 61010 100 3250 GE-41 AIRPORT MANAGER 1.00 $107,076 1.00 $109,388 1.00 $111,147 10051100 61010 100 460 GE-30 ACCOUNTANT 0.75 $46,266 0.75 $47,274 0.75 $48,034 10051100 61010 100 1995 GE-35 OPER/MAINT.SUPERVISOR 1.00 $79,101 1.00 $80,920 1.00 $82,122 Total 2.75 $232,443 2.75 $237,582 2.75 $241,303 Airport Administration-PT 10051100 61020 100 236 GE-28 MARKETING COORDINATOR 0.70 $36,973 0.70 $37,768 0.70 $38,376 Total 0.70 $36,973 0.70 $37,768 0.70 $38,376 Airport Operations-FT 10051400 61010 100 2525 GD-10 MECHANIC 1.00 $56,632 1.00 $57,827 1.00 $56,498 10051400 61010 100 2205 GD-06 MAINTENANCE WORKER 3.00 $152,147 3.00 $156,609 3.00 $154,166 10051400 61010 100 1875 NA-13 AIRPORT OPER SPECIALIST 3.00 $113,728 3.00 $118,461 3.00 $120,309 Total 7.00 $322,507 7.00 $332,897 7.00 $330,973 Airport Operations-Seasonal and Part- Time10051400 61030 100 892 NA-03 LABORER 0.23 $5,129 0.23 $5,239 0.23 $5,324 Total 0.23 $5,129 0.23 $5,239 0.23 $5,324 FBO Operation-FT 10051200 61010 100 1875 GE-33 FBO SUPERVISOR 1.00 $70,444 1.00 $71,965 1.00 $73,123 10051200 61010 100 460 GE-30 ACCOUNTANT 0.25 $15,422 0.25 $15,758 0.25 $16,011 100 GE-30 ASSISTANT FBO SUPERVISOR 1.00 $59,926 1.00 $61,231 1.00 $62,504 Total 2.25 $145,792 2.25 $148,954 2.25 $151,638 FBO Operation-PT 10051200 61020 100 1927 NA-27 LINE SERVICEWORKER 3.53 $92,634 3.53 $91,491 3.53 $90,335 10051200 61020 100 NA-44 RECEPTIONIST 1.50 $45,593 1.50 $47,232 1.50 $48,484 Total 5.03 $138,227 5.03 $138,723 5.03 $138,819 TOTAL AIRPORT DEPARTMENT 17.96 $881,071 17.96 $901,163 17.96 $906,433 -131- Capital Improvement Projects by Department/Division AIRPORT CIP Number Capital Improvement Project Title FY 15 Actual Expense FY 16 Actual Expense FY 17 Adopted Budget FY 18 Recomm'd Budget 3901060 PAVEMENT CONDITION INDEX 0 0 42,622 0 3901448 FBO IMPROVEMENTS 5,690 0 0 0 3901497 AIRPORT FENCING/HAZARD ST 0 0 10,000 15,000 3901691 RUNWAY SENSOR UPDATE 0 0 0 35,650 3901723 AIRPORT IMPROVEMENTS 0 0 45,000 0 3901793 FIELD DRAIN REPLACEMENTS 7,930 0 0 0 3902008 HANGER REPAIRS/REPLACE 4,119 9,217 55,000 40,000 3902010 TERMINAL UTIL IMPROVEMENT 158,470 0 0 0 3902011 ONSITE WATER & WASTEWATER 1,017,995 800 0 0 3902125 PAINT HANGAR EXTERIORS 0 0 0 0 3902128 AIRPORT RUNWAY PAINTING 56,429 50,779 0 0 3902213 TERMINAL DESIGN & BUILD 804,938 370,718 0 0 3902214 OLD AIRLINE TERM ASSESS 2,040 0 0 0 3902215 REPLACE RUNWAY REGULATORS 0 0 0 0 3902316 NEW TERM FAC - RDS & APRN 253,210 1,202,424 0 0 3902403 HVAC JOINT USE BLDG 26,045 7,559 0 0 3902475 NEW TERM PARKING 1 & 2 29,448 239,525 0 0 3902531 NEW TERM FURNISH EQUIP 127,380 74,359 0 0 3902532 NEW TERM PASSENGER BRIDGE 57,355 35,868 0 0 3902533 NEW TERM TAXIWAY F 0 0 0 0 3902534 NEW TERM GUIDANCE SIGNAGE 31,694 1,259 0 0 3902535 NEW TERM LANDSCAPING 30,753 71,390 25,000 0 3902536 AUTO GAS TANK RPLC 91,769 0 0 0 3902538 AIRPORT WATER,SEWER, ELEC 6,171 0 0 0 3902602 ELECT FUEL TANK GUAGE SYS 0 0 0 89,125 3902603 FBO HANGAR SECURITY DOORS 0 22,282 0 0 3902660 DECOMMISS AIRPORT LAGOON 0 0 35,000 0 3902661 FBO RESTROOM UPDATE 0 0 11,845 0 3902662 AIRPORT STORM DRAIN IMPRO 0 0 28,500 15,000 3902664 AIRPORT ASPHALT REPAIR 0 0 162,405 0 3902715 REPLACE GARAGE DOORS JUF 0 0 0 18,700 3902716 NEW TERM ENTRANCE SIGN 0 0 0 120,000 39110391 UNDISTRIBUTED 164,884 220,075 0 0 39151900 AIRPORT CAPITAL IMPR.0 0 202,734 204,934 AIRPORT TOTAL 2,876,320 2,306,257 618,106 538,409 -132- PROGRAM/ DEPT PROJECT DESCRIPTION FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 TOTAL PAGE AIRPORT Public Works Perimeter Fence Improvements $15,000 $10,000 $10,000 $10,000 $10,000 $55,000 163 Storm Drain Improvements $15,000 $20,000 $—$—$—$35,000 164 Corporate Hangar Facilities Repair/Replacement $40,000 $—$40,000 $—$45,000 $125,000 165 Replace Garage Door $18,700 $—$19,455 $19,074 $—$57,229 166 Upgrade Pavement Sensor Equipment $35,650 $—$—$—$—$35,650 167 Auto Fuel Tank & Dispenser $89,125 $—$—$—$89,125 168 New Terminal Entrance Road Sign $120,000 $—$—$—$—$120,000 169 Replace Snow Removal Equipment (SRE)$—$1,740,750 $—$—$—$1,740,750 170 Construct Airfield Lighting Vault $—$1,469,000 $—$—$—$1,469,000 171 Update Airport Layout Plan and GIS $—$341,825 $—$—$—$341,825 172 Replace Doors at Jet Center $—$15,000 $15,000 $—$—$30,000 173 Cap Off Old Wells $—$28,000 $—$—$—$28,000 174 Relocate D-Marc to New Terminal $—$186,000 $—$—$—$186,000 175 Pavement Condition Index (PCI)$—$—$47,000 $—$—$47,000 176 Security Camera & Equipment $—$—$85,000 $—$—$85,000 177 Asphalt Pavement Repair $—$—$—$—$196,160 $196,160 178 Rehabilitate Taxiway A $—$—$—$—$271,200 $271,200 179 Total - Airport $333,475 $3,810,575 $216,455 $29,074 $522,360 $4,911,939 Airport Budget Presentation February 13, 2017 Airport :pnjmipsi' n pa Increase Commercial Air Service Operations Expand Corporate & Private Aviation Services Increase Visibility & Awareness of Airport Services Maintain Existing Facilities Expand Facilities to Attract New Business & Increase Service Level Increase & Diversify Revenue Streams INAUGURAL FLI AFW 484 TERM !!1!!!!! •• !!1!!!! :•:•:•::: :•:•:•:• :••••••:: Property Tax Support Corporate Purpose GO Bonds (T -Hangar Revenue/Sales Tax Const Fund): T -Hangar Construction (2020) $52,556 Airport Improvements (2032) $98,883 New Terminal Facility Projects (2038) $21,935 Passenger Facility Charge Revenue Bond (PFC Revenues): New Terminal Facility Complex (2036) $199,332 Prop Tax Suppolt: Recommended Actual Tax Tax Support Support FY14 19.10% FY15 20.20% FY16 19.10% FY17 20.30% FY18 17.70% 13.50% 12.30% 19.10% Success is about Planning, Partnerships a d People _:Ou o es Partnerships: Annual Legislative Staffers Visit American Airlines Group Convention & Visitors Bureau Chamber of Commerce County Departments & Surrounding Communities CPR/AED Training With Terminal Tenants Partn hips - Continued: Iowa Public Airports Assoc. (IPAA) Local Area Business Partnerships Table Mound entary School University of Dubuque Aviation !IT!, ••• • ••::: „ .•••••••...•••••••...•..Y. .......... . ••• :•. .•.•.•..... 0.0 University of Dubuque Flight School .•.•11 ,11 . • . • People: Airport Tours to Various Groups Annual Airport Open House Fly -In Breakfasts (EAA and UD) North American Trainers Association (NATA) Formation Clinic DUBUQUE REG�ONAL UR'5„0 Ili a;:;-hm�,7.wnn�4wpn�4w��w��wpn�4w�xr.�p�x; Airport Open House/Expo Fly -In Breakfasts FY2018 O&M Equipment Replacement Items: Tractor/Skid Loader $62,000 Conveyor Belt Luggage Loader $55,000 Maintenance Utility Vehicle Maintenance Mower $22,000 $18,000 FY2018 Re ; n m en ed pital Improvemen New Terminal Ent. Road Monument $120,000 Auto Fuel Tank/Dispenser at Terminal $ 89,125 Corporate Hangar Repairs $ 40,000 Upgrade Pavement Sensor Equipment $ 35,650 FY2018 Rmmend Capital Improvements (Continued): Replace JUF Bld Garage Doors $18,700 Storm Drain Improvements $15,000 Perimeter Fence Improvements $15,000 FY2018 Improvement Packages (Not Recommended): Additional Marketing Funds $25,000 Additional WIFI Antennas $ 8,500 /1- 7 01= T_ R LH,LLyzi 1_111_ PL. TImnks*for your port!