Loading...
Airport FY19 Budget PresentationCopyrighted February 8, 2018 City of Dubuque Public Hearings # 5. IT EM T IT LE:Dubuque Regional Airport FY2019 Budget Presentation SUM MARY: SUGGEST ED DISPOSIT ION: ATTACHMENTS: Description Type FY19 Airport Budget Recommendation Supporting Documentation -115- Airport -116- This page intentionally left blank. -117- AIRPORT DEPARTMENT Budget Highlights FY 2017 Actual FY 2018 Budget FY 2019 Requested % Change From FY 2018 Budget Expenses Employee Expense 1,466,385 1,462,887 1,470,242 0.5 % Supplies and Services 2,123,254 2,439,900 2,038,414 (16.5)% Machinery and Equipment 246,996 181,760 215,175 18.4 % Total 3,836,635 4,084,547 3,723,831 (8.8)% Abated Debt 644,007 372,706 359,000 (3.7)% Total Expense 4,480,642 4,457,253 4,082,831 (8.4)% Resources Passenger Facility Charge 202,865 204,934 202,034 (1.4)% Sales Tax 97,807 115,216 95,010 (17.5)% Operating Revenue 2,987,272 3,333,627 3,015,551 (9.5)% Total Revenue 3,287,944 3,653,777 3,312,595 (9.3)% Total Property Tax Support 1,192,698 803,476 770,236 (33,240) Percent Increase (4.1)% Percent Self Supporting 82.2%82.4%84.2% Personnel - Authorized FTE 17.96 17.96 17.96 Improvement Package Summary 1 of 1 This marketing increase would assist the Dubuque Regional Airport with the tools necessary to combat competitor airport marketing as well as support the continued effort in educational forums, develop new marketing media and continued solicitation of air carriers. As with all marketing, top of mind awareness is needed when consumers are preparing to make a purchase. Airport competition within our region for air travelers has become increasingly fierce, with other airports marketing in our area. The continued consolidation of the airline industry continues to limit air carrier choices. Numerous surveys by the Greater Dubuque Development Corporation and Dubuque Area Chamber of Commerce clearly demonstrate the demand and need for expanded air service at Dubuque. Related Cost:$25,000 Tax Funds Recurring Recommend - No Property Tax Impact:$0.01 0.09% Activity: Airport Administration -118- Significant Line Items at Maintenance Level (Without Recommended Improvement Packages) Employee Expense 1. FY 2019 employee expense reflects a 1.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution increased from 8.93% in FY 2018 to 9.44% in FY 2019. This resulted in an increase of City IPERS expense of $5,238 in the Airport. The employee contribution increased from 5.95% in FY 2018 to 6.29% in FY 2019. 3. The City portion of health insurance expense decreased from $1,325 in FY 2018 to $1,192.5 in FY 2019 per month per contract which results in annual savings of -$19,078 or -10.00%. 4. The sick leave payout included in Airport’s budget decreased from $7,349 in FY 2018 to $4,882 in FY 2019. 5. Overtime is unchanged from $134,775 in FY 2018 to $134,775 in FY 2019. FY 2017 actual was $113,982. Supplies & Services 6. Property Maintenance decreased from $74,123 in FY 2018 to $68,000 in FY 2019 based on a three-year average. 7. Motor Vehicle Fuel decreased from $375,335 in FY 2018 to $280,996 in FY 2019 based on a two-year average. FY 2017 actual was $282,928. The FY 2019 two year average cost per gallon is $2.00 and the FY 2017 actual average cost per gallon was $1.94. The purchase of Motor Vehicle Fuel is offset by Motor Vehicle Fuel sales with net revenue of $13,759 in FY 2019 compared to a cost of $7,864 in FY 2018 budget. In FY 2017 there was a net fuel revenue of $23,941. FY 2019 estimated usage is as follows: Airport Administration 155 gallons; Airport Operations and Maintenance 6,827 gallons; and FBO Operations 142,337 gallons (which represents fuel to be sold to customers). 8. Aviation Fuel expense decreased from $1,130,394 in FY 2018 to $901,431 in FY 2019 based on a two-year average. In FY 2017, 440,729 gallons were sold and the estimated amount to be sold in FY 2019 is 464,396 gallons. The FY 2019 two year average cost per gallon is $3.36 and the FY 2017 actual average cost per gallon was $3.30. The purchase of Aviation Fuel is offset by Aviation Fuel Sales with an estimated net revenue of $685,351 in FY 2019 compared to $651,086 FY 2018 budget and $673,793 FY 2017 actual. 9. Promotion decreased from $143,960 in FY 2018 to $90,151 in FY 2019 based on actual expenses in FY 2017 of $90,152. The budget in FY 2018 includes a State Air Sustainment grant of $28,000 and a non-recurring improvement package of $25,000. The FY 2019 budget includes a State Air Sustainment grant of $15,000. -119- The history of promotion spending is as follows: Fiscal Year Property Tax Air Service Sustainment Grant Total Promotion 2019 $75,151 $15,000 $90,151 2018 $115,960 $28,000 $143,960 2017 $95,250 $25,000 $120,250 2016 $92,990 $—$92,990 2015 $115,730 $—$115,730 2014 $119,669 $—$119,669 2013 $105,026 $—$105,026 2012 $130,090 $—$130,090 2011 $134,147 $20,000 $154,147 2010 $163,437 $—$163,437 Total Promotion $1,147,450 $88,000 $1,235,450 Machinery & Equipment 10. Purchase of equipment for FY 2019 includes ($215,175): Airport Administration Smart Phone (3)$1,440 FBO Operations Smart Phone (1)$480 Handheld Radios $600 Safety Equipment $220 Shop Equipment $200 Airport Operations Portable Generator $2,250 Wacker Vibrating Plate $5,000 Genie Lift $107,495 Floor Jack $650 John Deere Tractor $50,000 Chevy Pickup (2006)$35,000 Leaf Blower $750 Smart Phone (3)$1,440 Shop Equipment $3,000 Airfield Signage $5,000 Safety Equipment $1,000 Handheld Radios $500 Terminal Building Maintenance Shop Equipment $150 Total $215,175 -120- Debt Service 11. FY 2019 debt service includes the following ($359,000): Amount Debt Series Source Purpose Final Payment Call Date $26,050 2017A Sales Tax 20%Airport Improvements 2030 2025 $152,778 2012C PFC New Terminal 2032 2019 $10,885 2012C Sales Tax 20%Airport Improvements 2032 2019 $61,956 2012I General Fund T-Hangar Construction 2020 2018 $63,352 2014B Sales Tax 20%Airport Improvements 2029 2021 $43,979 2016C PFC Terminal Roads/Apron 2036 2024 $359,000 Total Airport Debt Service Revenue 12. TSA Rent increased from $49,392 in FY 2018 to $49,416 in FY 2019 based on FY 2017 actual of $49,160 plus 1%. 13. Car Rental decreased from $100,738 in FY 2018 to $95,904 in FY 2019 based on FY 2017 actual of $95,904. 14. FAA Office rent remains unchanged at $25,127 in FY 2019. 15. Advertising Displays decreased from $86,400 in FY18 Budget to $7,200 in FY19 Budget. The Airport is now handling advertising in-house at the terminal using digital monitors. 16. American Eagle increased from $77,612 in FY 2018 to $79,000 in FY 2019 due to no longer waiving landing fees after the move to the new terminal. 17. Aircraft Service fees increased from $76,433 in FY 2018 to $79,171 in FY 2019 based on FY 2017 actual. 18. Aviation Fuel Sales decreased from $1,781,480 in FY 2018 to $1,586,782 in FY 2019 based on a two-year historical average and is offset by Aviation Fuel expense. 19. Auto Gas Fuel Sales decreased from $367,471 in FY 2018 to $294,755 in FY 2019 based on a two-year historical average and is offset by Motor Vehicle Fuel. 20. Farm Land Rent increased from $78,000 in FY 2018 to $98,000 in FY 2019. Miscellaneous 21. The Airport Department budget with abated debt is 84.2% self-supporting in FY 2019 versus the 82% self-supporting in FY 2018. -121- 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 -122- DUBUQUE REGIONAL AIRPORT The Airport is supported by 17.96 full-time equivalent employees, which accounts for only 36.01% of the department expense as seen below. Overall, the departments’ expenses are expected to decrease by -8.40% in FY 2019 compared to FY 2018. Expenditures by Category by Fiscal Year -123- 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. 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 Airport tenants include commercial airline service with American Airlines providing regional jet service through Chicago O’Hare International Airport and leisure flights with Sun Country Airlines to Laughlin, NV and Gulfport/Biloxi, MS. The University of Dubuque fields a fleet of approximately 24 light aircraft for their aviation program. Multiple local companies base their corporate aircraft fleet at the Airport while other smaller general aviation aircraft are based locally and have aircraft maintenance services provided by a privately-owned company. Administration Funding Summary 10051100 FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $568,213 $559,883 $504,763 Resources $678,678 $779,625 $696,603 Administration Position Summary FY 2019 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: • Construction of an additional large corporate aircraft hangar • Construction of an access road between the general aviation side of the airfield and the commercial terminal side • July 3rd Aircraft on display for viewing • Passed annual Federal Aviation Administration Part 139 inspection with no discrepancies -124- DUBUQUE REGIONAL AIRPORT The newly constructed commercial airline terminal had its first year of operation. The first flight from the terminal was on June 9, 2016. Newest Corporate Aircraft Hangar Road Construction to provide access between Commercial Airline Terminal and General Aviation side of airfield -125- DUBUQUE REGIONAL AIRPORT July 3rd aircraft on display for viewing by the public 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. Performance Measures Airport Administration - Activity Statement Provide quality, viable, competitive airport services and facilities while promoting sustainable economic development within the region. -126- DUBUQUE REGIONAL AIRPORT Goal: Robust Local Economy 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 DID YOU KNOW? American Airlines enplanements at Dubuque Regional Airport have increased over 7% since 2014 -127- DUBUQUE REGIONAL AIRPORT Goal: Connected Community 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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $2,085,095 $2,245,169 $1,838,171 Resources $2,155,105 $2,395,552 $2,134,685 Dubuque Jet Center Position Summary FY 2019 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 -128- DUBUQUE REGIONAL AIRPORT Highlights of the Past Year The Dubuque Jet Center hosted the 11th annual formation clinic for the North American Trainer Association (NATA) members prior to the week-long Air Venture event in Oshkosh, WI. NATA is an independent, non-profit corporation dedicated to the restoration and safe flying of North American Trainers such as the AT-6/SNJ/Harvard, NA-64, NA-50, TB-25, TF-51 Mustang, and T-28 aircraft. In 1987, a formation flying program was started and has expanded to cover virtually all organizations who have members flying warbirds. Dubuque has continually been selected to host the T-6 aircraft. 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. -129- DUBUQUE REGIONAL AIRPORT Dubuque Jet Center staff apply deicing fluid to a business jet. • 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, 2017 -130- DUBUQUE REGIONAL AIRPORT Airport Operations and Maintenance Overview Dubuque Regional Airport Operations and Maintenance Staff provide 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, navigational aids, fueling agents, firefighting, parking areas and roadways, as well as ensuring compliance with EPA, OSHA, DNR, FCC, NFPA, Spill Prevention Control Program and Storm Water Pollution Prevention Plan, ADA, and TSA requirements. 24-hour coverage is provided by three Operations Specialists whose duties include aircraft rescue and firefighting services (ARFF), 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 areas including all Airport owned buildings, aircraft hangars and the Commercial Airline Terminal. 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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $972,279 $1,079,331 $1,159,213 Resources $153,489 $158,450 $184,263 Operations and Maintenance Position Summary FY 2019 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. -131- DUBUQUE REGIONAL AIRPORT Goal: Connected Community 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. • 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. Airport staff work on replacing an area of concrete on a taxiway -132- DUBUQUE REGIONAL AIRPORT 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. Did you know? Airport staff provides an average of one tour per week during the summer months for area preschool, Boy and Girl Scouts, University of Dubuque Career advancement and other. -133- Recommended Operating Revenue Budget - Department Total 51 - AIRPORT Fund Account Account Title FY16 Actual Revenue FY17 Actual Revenue FY18 Adopted Budget FY19 Recomm'd Budget 252 43110 INVESTMENT EARNINGS 2,698 2,349 2,698 2,349 400 43110 INVESTMENT EARNINGS 0 353 0 0 100 43236 ADVERTISING DISPLAYS 11,702 4,833 86,400 7,200 100 43238 AIRCRAFT SERVICE FEE 76,433 79,171 76,433 79,171 100 43242 RENT, FARM LAND 67,136 67,136 78,000 98,000 100 43251 RENTS & CONCESSIONS 3,702 7,474 3,440 10,500 100 43253 PROMOTION ITEMS 473 63 473 63 100 43255 VENDING MACH COMMISSION 2,674 2,108 1,426 2,108 100 43257 RENTAL, TRAILER LOT 1,980 2,040 0 2,400 100 43271 T HANGAR RENT 69,733 75,963 75,000 79,000 100 43272 TSA RENT 37,495 49,160 49,392 49,416 100 43274 NORTH FARM HOUSE RNT 6,840 6,620 6,600 6,620 100 43275 CAR RENTAL 100,738 95,904 100,738 95,904 100 43276 FAA OFFICE RENT 25,127 25,127 25,127 25,127 100 43278 A.Y. MCDONALD 5,276 4,634 4,634 5,200 100 43279 UNIVERSITY OF DUBUQUE 95,337 82,998 95,337 85,400 100 43280 LANDING FEES 5,571 7,959 5,571 7,959 100 43283 AIRLINE STORAGE/UPLIFT 29,155 33,575 29,155 25,701 100 43285 AMERICAN EAGLE 77,612 65,166 77,612 79,000 100 43286 HANGARING, GEN.AVIATION 89,886 96,925 89,886 96,925 100 43287 MAINT HANGAR RENT 16,947 20,139 18,604 19,335 100 43290 CORPORATE HANGAR 76,592 72,996 70,805 74,959 100 43291 COMMERCIAL LAND RENT 6,196 13,582 14,485 14,000 43 - USE OF MONEY AND PROPERTY 809,303 816,275 911,816 866,337 400 44100 BAB SUBSIDY NON GRANT 2,900 2,780 2,900 0 44 - INTERGOVERMENTAL 2,900 2,780 2,900 0 100 45701 STATE GRANTS 28,000 12,463 28,000 15,000 45 - STATE GRANTS 28,000 12,463 28,000 15,000 100 51178 CREDIT CARD FEE 0 (10,564)0 0 100 51340 LONG-TERM PARKING FEES 205,582 90 0 0 100 51505 PUBLIC SAFETY 78,450 78,450 78,450 78,450 100 51510 AVIATION FUEL SALES 1,576,310 1,597,253 1,781,480 1,586,782 100 51515 AUTO GAS FUEL SALES 282,640 306,869 367,471 294,755 100 51520 OIL 2,160 1,847 2,160 1,847 100 51525 FUEL FLOW 122,015 127,898 115,164 116,099 252 51535 RENTAL CAR FEE 57,540 59,127 57,540 59,127 100 51540 CHARTERS GROUND HANDLING 7,581 32,001 25,581 32,001 100 51926 PILOT SUPPLIES 270 68 270 68 100 51963 CATERING 16,629 15,247 16,629 15,247 100 51986 PLANE WASHING 0 350 0 0 51 - CHARGES FOR SERVICES 2,349,177 2,218,850 2,444,745 2,184,376 100 53204 IOWA FUEL TAX REFUND 2,442 70 2,442 70 100 53605 MISCELLANEOUS REVENUE 186 413 0 0 100 53620 REIMBURSEMENTS-GENERAL 22,943 11,244 6,862 11,244 53 - MISCELLANEOUS 25,571 11,727 9,304 11,314 400 54210 GO BOND PROCEEDS 0 285,482 0 0 400 54220 BOND DISCOUNT 0 9,196 0 0 54 - OTHER FINANCING SOURCES 0 294,678 0 0 400 59100 FR GENERAL 53,506 48,006 52,556 61,956 400 59350 FR SALES TAX CONSTRUCTION 54,669 97,807 115,216 95,010 400 59391 FR PASSENGER FACILITY 205,730 202,865 204,934 202,034 59 - TRANSFER IN AND INTERNAL 313,905 348,678 372,706 359,000 51 - AIRPORT TOTAL 3,528,856 3,410,773 3,769,471 3,436,027 -134- Recommended Operating Expenditure Budget - Department Total 51 - AIRPORT Fund Account Account Title FY16 Actual Expense FY17 Actual Expense FY18 Adopted Budget FY 19 Recomm'd Budget 100 61010 FULL-TIME EMPLOYEES 703,865 728,081 723,914 747,123 100 61020 PART-TIME EMPLOYEES 184,971 189,838 177,195 181,759 100 61030 SEASONAL EMPLOYEES 6,041 6,538 5,219 5,298 100 61050 OVERTIME PAY 103,285 113,982 134,775 134,775 100 61071 HOLIDAY PAY-OVERTIME 0 1,154 0 0 100 61091 SICK LEAVE PAYOFF 12,396 12,396 7,349 4,882 100 61092 VACATION PAYOFF 0 1,892 0 0 100 61310 IPERS 89,136 92,797 92,969 100,911 100 61320 SOCIAL SECURITY 74,969 78,109 80,207 82,145 100 61410 HEALTH INSURANCE 193,644 190,800 190,798 171,720 100 61415 WORKMENS' COMPENSATION 47,919 48,373 48,580 40,399 100 61416 LIFE INSURANCE 621 611 1,331 630 100 61645 TOOL ALLOWANCE 200 200 200 200 100 61660 EMPLOYEE PHYSICALS 1,338 1,616 350 400 100 61665 OTHER MEDICAL COSTS 87 0 0 0 61 - WAGES AND BENEFITS 1,418,472 1,466,387 1,462,887 1,470,242 100 62010 OFFICE SUPPLIES 1,603 1,013 1,635 1,013 100 62011 UNIFORM PURCHASES 2,354 3,264 2,401 3,264 100 62013 UNIFORM MAINTENANCE 117 377 180 221 100 62030 POSTAGE AND SHIPPING 574 688 573 689 100 62032 FLAGS 2,646 0 1,000 250 100 62061 DP EQUIP. MAINT CONTRACTS 0 0 0 10,100 100 62062 JANITORIAL SUPPLIES 12,606 16,268 15,231 5,475 100 62064 ELECTRICAL SUPPLIES 7,484 8,585 7,634 8,019 100 62080 CREW CAR RENTAL 5,857 11,175 5,974 9,327 100 62090 PRINTING & BINDING 0 0 500 0 100 62110 COPYING/REPRODUCTION 64 204 265 204 100 62130 LEGAL NOTICES & ADS 669 604 668 604 100 62140 PROMOTION 428 581 436 37 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 88,849 90,152 143,960 90,151 100 62190 DUES & MEMBERSHIPS 8,177 5,694 8,340 7,588 100 62204 REFUNDS 4,463 3,536 4,052 3,536 100 62206 PROPERTY INSURANCE 84 0 0 0 100 62207 BOILER INSURANCE 37,043 31,344 32,277 25,581 100 62208 GENERAL LIABILITY INSURAN 96 0 0 0 100 62210 SALES TAX 69,266 71,041 74,491 69,106 100 62211 PROPERTY TAX 206 201 210 201 100 62230 COURT COSTS & RECORD FEES 1,842 1,908 1,879 1,908 100 62310 TRAVEL-CONFERENCES 6,673 5,217 9,118 7,217 100 62320 TRAVEL-CITY BUSINESS 4,319 3,577 4,405 3,326 100 62340 MILEAGE/LOCAL TRANSP 1,242 1,704 1,268 1,583 100 62360 EDUCATION & TRAINING 17,985 14,200 8,100 14,201 100 62411 UTILITY EXP-ELECTRICITY 119,355 120,810 124,129 135,911 100 62412 UTILITY EXP-GAS 17,820 20,353 19,602 21,370 100 62418 UTILITY EXP-REFUSE 3,591 3,803 3,663 3,804 100 62421 TELEPHONE 9,483 9,062 9,552 9,061 100 62424 RADIO/PAGER FEE 900 0 927 0 100 62431 PROPERTY MAINTENANCE 72,670 68,589 74,123 68,000 100 62436 RENTAL OF SPACE 1,137 1,924 1,854 1,924 100 62511 FUEL, MOTOR VEHICLE 279,196 282,928 375,335 280,996 100 62514 FUEL, AVIATION 879,402 923,460 1,130,394 901,431 100 62515 FUEL, AVIATION - FLOW 122,015 127,977 115,164 116,099 100 62516 FUEL, AVIATION - STORAGE 1,916 2,215 2,356 2,215 100 62521 MOTOR VEHICLE MAINT.18,932 27,230 19,310 20,481 100 62528 MOTOR VEH. MAINT. OUTSOUR 188 1,874 191 300 100 62611 MACH/EQUIP MAINTENANCE 47,263 34,016 31,826 29,482 100 62614 EQUIP MAINT CONTRACT 0 3,680 25,000 3,680 -135- Recommended Operating Expenditure Budget - Department Total 51 - AIRPORT Fund Account Account Title FY16 Actual Expense FY17 Actual Expense FY18 Adopted Budget FY 19 Recomm'd Budget 100 62615 MACH/EQUIP MAINT. OUTSOUR 500 1,710 510 1,710 100 62627 CAMERA MAINTENANCE 0 0 0 2,790 100 62636 DE-ICING PRODUCTS 30,498 20,545 31,108 34,735 100 62642 FOOD PRODUCTS 14,676 13,314 14,970 13,720 100 62645 SPECIAL EVENTS 16,999 200 1,000 200 100 62649 BEVERAGE/ICE 3,136 2,345 3,199 2,673 100 62664 LICENSE/PERMIT FEES 1,016 1,069 1,036 1,069 100 62666 CREDIT CARD CHARGE 25,744 1,731 18,908 15,000 100 62667 INTERNET SERVICES 1,452 2,583 1,772 2,583 100 62681 LUBRICATION PRODUCTS 1,304 2,276 1,330 1,489 100 62686 CRACKSEAL MATERIALS 483 1,103 493 1,103 100 62691 AIR SHOW EXPENSE 371 170 378 170 100 62692 LANDFILL FEES 125 0 0 0 100 62699 CASH SHORT AND OVER 0 53,077 55,000 55,000 100 62710 CONTRACTOR SERVICES 0 417 0 0 100 62712 CONSULTING ENGINEERS 470,371 70,659 0 0 100 62713 LEGAL SERVICES 0 596 0 0 400 62713 LEGAL SERVICES 0 515 0 0 100 62726 AUDIT SERVICES 2,125 2,500 2,200 0 100 62731 MISCELLANEOUS SERVICES 0 1,369 0 0 100 62733 CONTRACT CUSTODIAL 32,288 38,187 37,500 38,187 100 62747 MACH/EQUIPMENT RENTAL 385 420 393 420 100 62761 PAY TO OTHER AGENCY 7,331 6,400 9,000 6,400 100 62767 ENVIRON. TESTING/MON.6,476 2,810 3,080 2,810 62 - SUPPLIES AND SERVICES 2,463,795 2,123,250 2,439,900 2,038,414 100 71227 SIGNAGE 3,620 7,870 5,000 5,000 100 71310 AUTO/JEEP REPLACEMENT 0 0 22,000 0 100 71313 TRACTOR-REPLACEMENT 0 0 62,000 50,000 100 71314 TRUCK-REPLACEMENT 0 106,050 0 35,000 100 71324 SWEEPER/SCRUBBER 17,964 0 0 0 100 71410 SHOP EQUIPMENT 3,855 4,417 3,740 3,350 100 71420 EARTH COMPACTOR 0 3,661 0 5,000 100 71517 LIGHTING EQUIPMENT 1,214 0 0 0 100 71550 MISCELLANEOUS EQUIPMENT 0 86,472 63,000 110,395 100 71611 MOWING EQUIPMENT 0 0 18,000 0 100 71615 LEAF BLOWER 0 0 0 750 100 71616 SNOW BLOWER 0 0 2,800 0 100 71619 OTHER MAINT. EQUIPMENT 31,913 15,065 2,000 0 100 72113 OTHER SAFETY EQUIPMENT 1,374 9,895 1,420 1,220 100 72116 SAFETY EQUIP., FIRE DEPT 150 0 0 0 100 72310 CONCESSION EQUIPMENT 0 8,805 0 0 100 72410 PAGER/RADIO EQUIPMENT 1,115 1,223 1,800 1,100 100 72418 TELEPHONE RELATED 847 3,540 0 3,360 71 - EQUIPMENT 62,052 246,998 181,760 215,175 400 74111 PRINCIPAL PAYMENT 213,731 526,429 259,164 258,343 400 74112 INTEREST PAYMENT 103,075 117,578 113,542 100,657 74 - DEBT SERVICE 316,806 644,007 372,706 359,000 252 91390 TO AIRPORT CONSTRUCTION 101,912 15,784 120,000 0 91 - TRANSFER TO 101,912 15,784 120,000 0 51 - AIRPORT TOTAL 4,363,037 4,496,426 4,577,253 4,082,831 -136- Recommended Expenditure Budget Report by Activity & Funding Source 51 - AIRPORT AIRPORT ADMIN. - 51100 FUNDING SOURCE: GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 1,821 —1,440 SUPPLIES AND SERVICES 197,714 185,648 125,306 WAGES AND BENEFITS 368,677 374,235 378,017 AIRPORT ADMIN.568,213 559,883 504,763 FBO OPERATION - 51200 FUNDING SOURCE: GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 194,540 69,320 1,500 SUPPLIES AND SERVICES 1,469,572 1,779,611 1,436,817 WAGES AND BENEFITS 420,982 396,238 399,854 FBO OPERATION 2,085,095 2,245,169 1,838,171 AIRPORT OPERATIONS - 51300 FUNDING SOURCE: DEBT SERVICE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget DEBT SERVICE 644,007 372,706 359,000 SUPPLIES AND SERVICES 2,480 —— AIRPORT OPERATIONS 646,488 372,706 359,000 AIRPORT OPERATIONS - 51400 FUNDING SOURCE: CUSTOMER FACILITY CHARGE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 41,543 112,290 212,085 SUPPLIES AND SERVICES 254,011 274,627 254,757 TRANSFER TO 15,784 120,000 — WAGES AND BENEFITS 676,725 692,414 692,371 AIRPORT OPERATIONS 988,062 1,199,331 1,159,213 TERMINAL, BLDG MAINT. - 51700 FUNDING SOURCE: GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 9,092 150 150 SUPPLIES AND SERVICES 199,476 200,014 221,534 TERMINAL, BLDG MAINT.208,568 200,164 221,684 AIRPORT TOTAL $4,496,426.03 $4,577,253.00 $4,082,831.00 -137- 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 2017 FY 2018 FY 2019 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 $109,388 1.00 $111,147 1.00 $113,932 100 1995 GE-35 OPER/MAINT.SUPERVISOR 1.00 $80,920 1.00 $82,122 1.00 $84,163 100 1875 GE-33 FBO SUPERVISOR 1.00 $71,965 1.00 $73,123 1.00 $74,878 100 GE-30 ASSISTANT FBO SUPERVISOR 1.00 $61,231 1.00 $62,504 1.00 $63,779 100 460 GE-30 ACCOUNTANT 1.00 $63,032 1.00 $64,045 1.00 $65,017 100 2525 GD-10 MECHANIC 1.00 $57,827 1.00 $56,498 1.00 $57,818 100 2205 GD-06 MAINTENANCE WORKER 3.00 $156,609 3.00 $154,166 3.00 $162,932 100 1875 NA-13 AIRPORT OPER SPECIALIST 3.00 $118,461 3.00 $120,309 3.00 $124,604 TOTAL FULL TIME EMPLOYEES 12.00 $719,433 12.00 $723,914 12.00 $747,123 61020 Part Time Employee Expense 100 NA-44 RECEPTIONIST 1.50 $47,232 1.50 $48,484 1.50 $50,380 100 236 GE-28 MARKETING COORDINATOR 0.70 $37,768 0.70 $38,376 0.70 $38,951 100 1927 NA-27 LINE SERVICEWORKER 3.53 $91,491 3.53 $90,335 3.53 $92,428 TOTAL PART TIME EMPLOYEES 5.73 $176,491 5.73 $177,195 5.73 $181,759 61030 Seasonal Employee Expense 100 896 NA-11 LABORER 0.23 $5,239 0.23 $5,219 0.23 $5,298 TOTAL SEASONAL EMPLOYEES 0.23 $5,239 0.23 $5,219 0.23 $5,298 TOTAL AIRPORT 17.96 $901,163 17.96 $906,328 17.96 $934,180 -138- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 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 $109,388 1.00 $111,147 1.00 $113,932 10051100 61010 100 460 GE-30 ACCOUNTANT 0.75 $47,274 0.75 $48,034 0.75 $48,763 10051100 61010 100 1995 GE-35 OPER/MAINT.SUPERVISOR 1.00 $80,920 1.00 $82,122 1.00 $84,163 Total 2.75 $237,582 2.75 $241,303 2.75 $246,858 Airport Administration-PT 10051100 61020 100 236 GE-28 MARKETING COORDINATOR 0.70 $37,768 0.70 $38,376 0.70 $38,951 Total 0.70 $37,768 0.70 $38,376 0.70 $38,951 Airport Operations-FT 10051400 61010 100 2525 GD-10 MECHANIC 1.00 $57,827 1.00 $56,498 1.00 $57,818 10051400 61010 100 2205 GD-06 MAINTENANCE WORKER 3.00 $156,609 3.00 $154,166 3.00 $162,932 10051400 61010 100 1875 NA-13 AIRPORT OPER SPECIALIST 3.00 $118,461 3.00 $120,309 3.00 $124,604 Total 7.00 $332,897 7.00 $330,973 7.00 $345,354 Airport Operations-Seasonal and Part-Time 10051400 61030 100 892 NA-03 LABORER 0.23 $5,239 0.23 $5,219 0.23 $5,298 Total 0.23 $5,239 0.23 $5,219 0.23 $5,298 FBO Operation-FT 10051200 61010 100 1875 GE-33 FBO SUPERVISOR 1.00 $71,965 1.00 $73,123 1.00 $74,878 10051200 61010 100 460 GE-30 ACCOUNTANT 0.25 $15,758 0.25 $16,011 0.25 $16,254 100 GE-30 ASSISTANT FBO SUPERVISOR 1.00 $61,231 1.00 $62,504 1.00 $63,779 Total 2.25 $148,954 2.25 $151,638 2.25 $154,911 FBO Operation-PT 10051200 61020 100 1927 NA-27 LINE SERVICEWORKER 3.53 $91,491 3.53 $90,335 3.53 $92,428 10051200 61020 100 NA-44 RECEPTIONIST 1.50 $47,232 1.50 $48,484 1.50 $50,380 Total 5.03 $138,723 5.03 $138,819 5.03 $142,808 TOTAL AIRPORT DEPARTMENT 17.96 $901,163 17.96 $906,328 17.96 $934,180 -139- Capital Improvement Projects by Department/Division AIRPORT CIP Number Capital Improvement Project Title FY 16 Actual Expense FY 17 Actual Expense FY 18 Adopted Budget FY 19 Recomm'd Budget 3901448 FBO IMPROVEMENTS —11,439 —— 3901489 SNOW BROOM AND BLOWER ———1,100,000 3901497 AIRPORT FENCING/HAZARD ST —1,026 15,000 — 3901691 RUNWAY SENSOR UPDATE ——35,650 — 3901723 AIRPORT IMPROVEMENTS —6,170 —— 3901893 EXTEND GENL AVIATION RAMP 4,180 49,116 —— 3902008 HANGER REPAIRS/REPLACE 9,217 74,595 40,000 — 3902009 TERMINAL SITEWORK 120,479 21,887 —— 3902011 ONSITE WATER & WASTEWATER 9,719 18,887 —— 3902125 PAINT HANGAR EXTERIORS —5,181 —— 3902128 AIRPORT RUNWAY PAINTING 50,779 ——— 3902213 TERMINAL DESIGN & BUILD 370,718 54,779 —— 3902214 OLD AIRLINE TERM ASSESS ———160,000 3902316 NEW TERM FAC - RDS & APRN 1,207,258 264,691 —— 3902403 HVAC JOINT USE BLDG 7,559 2,646 —— 3902475 NEW TERM PARKING 1 & 2 3,195,062 620,162 —— 3902531 NEW TERM FURNISH EQUIP 1,178,327 158,582 —— 3902532 NEW TERM PASSENGER BRIDGE 784,102 51,622 —— 3902534 NEW TERM GUIDANCE SIGNAGE 1,259 ——— 3902535 NEW TERM LANDSCAPING 71,390 ——25,000 3902537 ADMIN OFFICE 27,195 ——— 3902538 AIRPORT WATER,SEWER, ELEC —13,329 —— 3902602 ELECT FUEL TANK GUAGE SYS ——89,125 — 3902603 FBO HANGAR SECURITY DOORS 22,282 ——— 3902660 DECOMMISS AIRPORT LAGOON —670 —— 3902662 AIRPORT STORM DRAIN IMPRO —14,201 15,000 — 3902664 AIRPORT ASPHALT REPAIR —78,526 —— 3902715 REPLACE GARAGE DOORS JUF ——18,700 38,513 3902716 NEW TERM ENTRANCE SIGN ——120,000 — 3902751 AIRPORT CAP OLD WELLS ———28,000 3902752 AIRPORT JET CENTER DOORS ———30,000 3902753 AIRPORT WIRELESS NETWORK ———35,000 39110391 UNDISTRIBUTED 220,075 3,728 —— 39151900 AIRPORT CAPITAL IMPR.—202,865 204,934 202,034 AIRPORT TOTAL 7,279,602 1,654,100 538,409 1,618,547 -140- PROGRAM/ DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE AIRPORT Public Works Replace Snow Removal Equipment (SRE)$1,100,000 $650,750 $—$—$—$1,750,750 109 Relocate D-Marc to New Terminal/De- construct Old Terminal $160,000 $190,000 $—$—$—$350,000 110 Cap Off Old Wells $28,000 $—$—$—$—$28,000 111 Replace Garage Doors on Joint Use Facility $38,513 $—$—$—$—$38,513 112 Replace Doors at Jet Center $30,000 $—$—$—$—$30,000 113 Update Airport Wireless $35,000 $—$—$—$—$35,000 114 New Terminal Landscaping $25,000 $25,000 $—$—$—$50,000 115 Perimeter Fence Improvements $—$15,000 $10,000 $10,000 $—$35,000 116 Corporate Hangar Facilities Repair/ Replacement $—$25,000 $—$20,000 $—$45,000 117 Update Airport Layout Plan and GIS $—$460,361 $—$—$—$460,361 118 Construct Airfield Lighting Vault $—$—$1,469,000 $—$—$1,469,000 119 Pavement Condition Index (PCI) $—$—$47,000 $—$—$47,000 120 Rehabilitate Taxiway A $—$—$—$271,200 $3,539,688 $3,810,888 121 Extend Runway 18/36 $—$—$—$268,000 $—$268,000 122 Total - Airport $1,416,513 $1,366,111 $1,526,000 $569,200 $3,539,688 $8,417,512 Dubuque Regional Airport Airport Budget Presentation February 8, 2018 Airport Commission Goals : 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 DBQ Airport –2nd busiest in Iowa 3rd in region 0 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 Madison Des Moines Dubuque Cedar Rapids Peoria Rockford Moline Waterloo Sioux City 85,980 77,530 58,324 49,706 47,912 41,743 33,528 20,226 18,254 Total Control Tower Operations CY2017 OUR COMPETITION FOR ADDITIONAL SERVICE 200+ AIRPORTS WITH 50 SEAT REGIONAL JET AIRCRAFT AIRLINE MERGERS AIRLINE MARKET CONTRACTION IS OVER American Airlines Enplanements 5 Years of Continuous Growth CY Enplanements % Increase 2013 32,216 3.65% 2014 34,410 6.81% 2015 36,820 7.00% 2016 36,843 0.06% 2017 39,023 5.92% Budget Overview FY2019 O&M Airport Operating Budget: Revenues Property Tax Support Expenses Annual Debt Service* $3,312,595 $ 770,236 $4,082,831 $3,723,831 $ 359,000 $4,082,831 Property Tax Support: Recommended Actual Tax Tax Support Support FY16 19.10%19.10% FY17 20.30% 17.80% FY18 17.70%------- FY19 16.10%------- *Annual Debt Service Payments (FY2019) Corporate Purpose GO Bonds (T-Hangar Revenue/Sales Tax Const Fund): T-Hangar Construction (2020)$ 61,956 Airport Improvements (2032)$100,287 Passenger Facility Charge Revenue Bond(PFC Revenues): New Terminal Facility Complex (2036)$196,757 FY2019 O&M Equipment Replacement Items: Aerial Lift $107,495 Tractor $ 50,000 Maintenance Pickup $ 35,000 FY2019 Recommended Capital Improvements: Replace Snow Removal Equipment $1,100,000 (90% FAA Funded) Relocate Airport D-Marc/Deconstruct $ 160,000 Old Terminal Replace JUF Garage Doors $ 38,513 Update Airport WiFi $ 35,000 Replace Jet Center Doors $ 30,000 New Terminal Landscaping $ 25,000 Terminal Landscaping Native Plants will be ordered for Fall delivery/planting: Purple Love Grass Prairie Spiderwort Prairie Smoke FY2019 Items not approved Replace Overlook Site $50,000 MARKETING FUNDS RESTORATION $25,000 FY2019 Items not approved CID –Cedar Rapids Marketing -$441,000 DBQ -Dubuque Marketing -$75,000 + up to $28,000 from IDOT Grant MSN -Madison Marketing -$450,000 MLI –Quad Cities Marketing -$305,000 MLI DBQCID MSN MARKETING BUDGETS DUBUQUE REGIONAL AIRPORT MARKETING BREAKDOWN FY17 Traditional Marketing/ Social Media 44% Website 10% FlyDBQ Rewards Program25% Promotional 10% Air Service Consultants 11% GDDC Services Index 2017-Q4 Concerns From Business Leaders DBQ Air Passenger Service Overall 4.24 Out of 7.00 Not Dependable In Winter 2017 Overall Flight Completion Rate of 96.2% Needs More Flights/Hub Options Ongoing Meetings With Airlines Cost/Availability True Cost of Travel TRUE COST OF TRAVEL For Example –Round Trip to Phoenix 1 person -3/5/18 –3/8/18 DBQ MLI CID ORD Airfare $551 $496 $462 $312 Parking $ 0 $ 28 $ 28 $68 to $160 Mileage $ 11 $ 86 $ 88 $177 Tolls $ 0 $ 0 $ 0 $ 6 Total Cost $562 $610 $578 $563 -$655 Are you calculating true costs?Airfare + Parking + Mileage + Tolls -Productivity Community Outreach & People: Airport Tours to Multiple Groups Annual Airport Open House Fly-In Breakfasts (EAA and UD) North American Trainers Association (NATA) Formation Clinic University of Dubuque Flight School Terminal LEED Certification Airport Tours Annual Part 139 Certification Airport Open House/Expo Fly-In Breakfasts North American Trainer Association July 2nd Displays & July 3rd Air Show Staff Volunteering Thanks for your support!