Loading...
Section VIII - FY20 Airport Budget FY2020 BUDGET PROJECTION • ENTERPRISE FUNDS: AIRPORT FY2020 Budget Airport Enterprise Fund FY2019 Airport Enterprise Fund Review •Mission: –“The mission of the Nantucket Memorial Airport (ACK) is to provide operationally safe, economically sustainable and environmentally responsible air service to the residents, businesses and visitors to the island of Nantucket.” •Goals: –Construct temporary (structured awning) facility to accommodate increased seasonal traffic –Address Infrastructure improvements –pavement/taxiway Echo –Replace/upgrade Security systems (Access Control, CCTV, IT & Badging/ID) –Full depth reconstruction of Taxiway E and address safety area grading standards –Initiate Environmental Assessment/Environmental Impact Review –Continue implementation of air service development plan. –Continue expansion of non aeronautical revenue generation. –Evaluate Rates and Charges to ensure sufficient cost recovery •Initiatives and Accomplishments: –Constructed interim hold room expansion (tent) –Increased air service •Jet Blue added frequencies (up to 8 on peak days) •American added CLT Saturday service •United Extended season and converted to jet aircraft –Expanded use of VEOCI software platform to entire staff –Completed North Apron area 3 rehabilitation –Added fifth air carrier parking position –Reallocated airline ticketing and gate podiums –Additional tenants –4 Bunker Road, 1 Old FBO –Restaurant reopened Airport Enterprise Fund FY2020 Airport Enterprise Fund Overview •Priorities: –Safety & Security –Quality Service Delivery –Financial Sustainability –Improved Air Service •Significant Changes Year-to-Year –Significant increase in seasonal traffic –Impact of larger aircraft on infrastructure –Increase in fuel sales •Key Issues –Air Freight Services –Continued Ferry Competition –Rates & Charges –Cost Recovery –Regulatory changes –Rules & Regulations and Minimum Standards Update –Funding the National System –FAA Funding/State Funding –Legacy agreement issues (FMV etc.) Airport Enterprise Fund FY2020 Budget Airport Enterprise Fund SUMMARY Payroll-Salary 3,158,918$ 3,375,065$ 550,619$ 3,385,760$ 3,373,000$ (12,760)$ (0.4%) Medicare P/R Tax Expense 45,915 48,921 9,986 49,100 48,900 (200)$ (0.4%) Medical Insurance 741,775 740,911 154,288 847,500 905,000 57,500$ 6.8% Barnstable County Retirement 569,586 593,901 637,150 645,000 692,000 47,000$ 7.3% Utilities 477,998 512,658 105,909 537,300 567,100 29,800$ 5.5% Airport Fuel-Since 2012 Reported in Fuel Revolver - - - - - -$ na Repairs & Maintenance 496,694 376,221 66,625 586,700 667,300 80,600$ 13.7% Professional Services 264,670 315,052 99,021 417,150 387,022 (30,128)$ (7.2%) Police Protection Services 250,000 250,000 41,667 250,000 250,000 -$ - Settlements/Personnel Contract Expense - - - - - -$ na General Insurance & WC 146,574 158,888 16,116 200,000 174,800 (25,200)$ (12.6%) FBO Catering 288,507 309,807 168,611 330,000 297,000 (33,000)$ (10.0%) Other Supplies 105,020 94,844 17,362 93,500 105,300 11,800$ 12.6% Travel 35,594 24,466 10,715 38,500 35,100 (3,400)$ (8.8%) Debt Service 1,297,378 1,307,102 87,200 1,271,088 1,046,338 (224,750)$ (17.7%) Indirect Costs 200,000 200,000 - 200,000 200,000 -$ - Other 576,193 924,130 186,106 893,540 970,540 77,000$ 8.6% TOTAL AIRPORT 8,654,822$ 9,231,966$ 2,151,376$ 9,745,138$ 9,719,400$ (25,738)$ -0.3% Appendix Airport Enterprise Fund Town & County of Nantucket Organization Chart –Airport Enterprise Fund ACK Organizational Chart November 2018 FY 2020 Budget Detail Airport Enterprise Fund FY2020 Airport Enterprise Fund Exceptions (1) Non-controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded. WANNACOMET WATER ENTERPRISE POSITIONS n/a OPERATIONAL EXPENSES (1) 1)Airfield Maintenance: $85,000 2)New Tools & Equip: $7,200 3)Utilities: $26,000 CAPITAL EXPENSES: 1)Remove Pipeline Piles at GHYC: $116,000 2)Sanitary Sewer Upgrade: $102,420 3)Vehicle Maint & Replacement: $63,100 4)Paint and Beads & Rubber & Markings Removal: $321,000 5)Ecological Restoration Equipment: $119,200 6)Taxiway Echo: $19,100,000 7)Security Project: $2,093,000 ACTUAL BUDGET PROPOSED BUDGET FY2018 FY2019 FY2020 REVENUE 9,945,655 8,515,200 9,319,400 EXPENSES 9,231,966 9,745,138 9,719,400 NET EARNINGS 713,689 (1,229,938) (400,000) Transfer from Retained Earnings and/or PFC - 429,938 - NET EARNINGS 713,689 (800,000) (400,000) NET SOURCES/USES: Transfer from Airport Fuel Revolver 300,000 400,000 - Transfer from Retained Earnings - PFC 400,000 400,000 400,000 Transfer from Stabilization Fund 100,000 - Transfer to Capital Projects (540,847) - Ending FB 972,842 - - Certified Retained Earnings as of July 1, 2018 2,161,016 Less R/E for FY20 Budget (see above)- 2,161,016 ACTUAL PROJECTED PROPOSED BUDGET AVIATION FUEL REVOLVER FY2018 FY2019 FY2020 Fuel Sales 4,000,000 5,200,000 5,200,000 Fuel Purchases 3,942,037 5,200,000 5,200,000 Net Surplus (Deficit)57,963 - - Beginning FB 1,929,644 757,607 357,607 Transfer to Airport Enterprise Fund (300,000) (400,000) - Transfer to Airport Stabilization Fund (300,000) - - Transfer to Airport Capital Projects (630,000) - - Ending FB 757,607 357,607 357,607 NANTUCKET MEMORIAL AIRPORT - ENTERPRISE FUND TOWN OF NANTUCKET AIRPORT ENTERPRISE FUND FY2020 BUDGET PROJECTION REVENUE ORG OBJ REVENUE Actual FY2016 Actual FY2017 Actual FY2018 FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 FBO Sales Income 65482 42451 FUEL SALES 1,113,093 2,283,717 3,052,053 2,000,000 2,000,000 - - 65482 42452 FUEL SALES - GAS & DIESEL 80 - - -- - na 65482 43231 GEN AVIATION LANDING FEE 650,541 759,793 784,187 660,000 750,000 90,000 13.6% 65482 43232 GEN AVIATION RAMP FEES 1,689,798 1,880,605 1,900,744 1,750,000 1,850,000 100,000 5.7% 65482 43239 FBO SUPPLIES AND SERVICES 37,588 38,340 45,820 36,000 40,000 4,000 11.1% 65482 43704 CATERING INCOME 451,344 348,426 385,872 380,000 342,000 (38,000) (10.0%) Total FBO Sales:3,942,442 5,310,881 6,168,676 4,826,000 4,982,000 156,000 3.2% Rental Income 65482 43606 RENTAL FEES: EMP HOUSING 8,880 9,800 15,000 7,500 10,000 2,500 33.3% 65482 43630 RENTAL INCOME-TERMINAL 548,510 499,507 407,324 466,000 516,000 50,000 10.7% 65482 43631 RENTAL INCOME-TOWER 133,122 133,122 133,122 133,000 133,000 - - 65482 43632 RENTAL INCOME-LAND 656,451 682,916 767,458 762,000 1,168,000 406,000 53.3% 65482 43633 RENTAL INCOME-HANGAR 78,337 92,705 92,662 83,200 115,600 32,400 38.9% Totals Rentals:1,425,300 1,418,049 1,415,566 1,451,700 1,942,600 490,900 33.8% Fee Income 65482 43709 VIDEO CONFERENCE 100 - - -- - na 65482 43710 ADVERTISING REVENUE - 11,990 47,290 15,000 100,000 85,000 566.7% 65482 43705 ART SALES COMMISSION - 1,200 1,200 -- - na 65482 43706 CONCESSION FEES 36,080 38,166 39,969 35,500 60,000 24,500 69.0% 65482 43707 AUTO RENTAL COMMISSIONS 589,904 623,117 628,996 625,000 630,000 5,000 0.8% 65482 43233 FREIGHT HANDLING FEE 64,807 76,465 75,764 77,000 77,000 - - 65482 43238 AIRLINE LANDING FEES 386,965 447,397 441,032 455,000 480,000 25,000 5.5% 65482 Noise Abatement - - - -- - na 65482 42450 AIRPORT INCOME - - - -- - na 65482 43234 RESERVED TIE DOWN FEES 49,700 57,800 54,025 55,000 50,000 (5,000) (9.1%) 65482 48434 OTHER FEES - - - - - na Total Fees:1,127,556 1,256,134 1,288,277 1,262,500 1,397,000 134,500 10.7% Vehicle Income 65482 43236 PARKING LOT FEES 275,950 217,670 38,191 150,000 75,000 (75,000) (50.0%) 65482 47701 PARKING TICKETS 17,730 12,395 12,639 10,000 17,500 7,500 75.0% 65482 44518 TAXI PERMITS 27,300 22,800 22,300 25,000 22,000 (3,000) (12.0%) Total Vehicles:320,980 252,865 73,131 185,000 114,500 (70,500) (38.1%) Other Income 65482 43634 CUSTOMER FACILITY CHARGES 105,667 170,203 167,200 160,000 165,000 5,000 3.1% 65482 43235 ANNUAL BUSINESS ACTIVITY FEE 64,500 48,300 48,000 45,000 60,000 15,000 33.3% 65482 42401 PASSENGER FACILITY CHARGE(PFC)566,828 619,611 542,591 460,000 525,000 65,000 14.1% 65482 48201 INTEREST ON INVESTMENTS 41,091 50,016 64,634 25,000 25,000 - - 65482 43237 FINGER PRINTING FEES 3,750 2,950 2,950 2,200 2,500 300 13.6% 65482 43708 MISC INC 7,549 14,734 49,750 7,000 15,000 8,000 114.3% 65482 45402 FEDERAL REV - LEO 133,570 70,458 123,647 90,800 90,800 - - 65482 48100 SALE OF INVENTORY & FIXED - - 1,300 -- - na 65482 48400 MISC REVENUE - - 263 -- - na 65482 48436 INS PROCEEDS - - - -- - na 65482 48450 BOUNCED CHECKS - - (300) -- - na 65482 49000 REFUNDS - - (30) -- - na 65482 49104 PREMIUM REVENUE ON DEBT 15,361 48,123 - -- - na 65482 49701 TRANSFER FROM GENERAL FUND - - - -- - na Total Other Income:938,316 1,024,394 1,000,005 790,000 883,300 93,300 11.8% SUBTOTAL OPERATING REVENUE 7,754,594 9,262,323 9,945,655 8,515,200 9,319,400 804,200 9.4% TRANSFER FROM GENERAL FUND - - - TOTAL REVENUE 7,754,594 9,262,323 9,945,655 8,515,200 9,319,400 804,200 9.4% AIRPORT ENTERPRISE FUND FY2020 BUDGET PROJECTIONS EXPENDITURES ORG OBJ EXPENDITURES Actual FY2016 Actual FY2017 Actual FY2018 FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 65482 51100 AIRPORT ADMINISTRATION SALARY* 1,057,727$ 1,082,505$ 1,090,645 1,089,900 1,069,000$ (20,900)$ (1.9%) 65482 51700 LONGEVITY PAY 58,921$ 62,159$ 76,785 72,560 76,200 3,640$ 5.0% 65482 51122 AIRPORT OPERATIONS SALARY* 692,759$ 707,881$ 771,515 793,200 808,100 14,900$ 1.9% 65482 51123 AIRPORT MAINTENANCE SALARY* 872,487$ 934,123$ 967,571 990,300 974,200 (16,100)$ (1.6%) 65482 51124 AIRPORT SECURITY SALARY 167,569$ 178,998$ 255,245 157,800 161,500 3,700$ 2.3% 65482 51200 SALARY, SEASONAL 188,767$ 193,252$ 213,304 261,000 263,000 2,000$ 0.8% 65482 51701 INS PREM:MEDICAL BLUE CROSS 678,045$ 741,775$ 740,911 847,500 905,000 57,500$ 6.8% 65482 51960 COMPENSATION/UNEMPLOYMENT -$ -$ --- -$ na 65482 51961 MEDICARE P/R TAX 44,054$ 45,915$ 48,921 49,100 48,900 (200)$ (0.4%) 65482 51770 BARNSTABLE COUNTY RETIREMT FND 543,178$ 569,586$ 593,901 645,000 692,000 47,000$ 7.3% 65482 51900 CONTRACTUAL OBLIGATIONS** -$ -$ -21,000 21,000 -$ - TOTAL PAYROLL EXPENSES 4,303,506$ 4,516,194$ 4,758,798$ 4,927,360$ 5,018,900$ 91,540$ 1.9% 65482 52501 MISC PURCH:FBO CATERING 364,306$ 288,507$ 309,807 330,000 297,000 (33,000)$ (10.0%) 65482 52502 MISC PURCH:FBO/PILOT SERVICES 12,686$ 20,607$ 30,449 32,750 34,500 1,750$ 5.3% 65482 52503 MISC PURCH:S&M EQUIP -$ -$ --- -$ na 65482 52505 EQUIPMENT RENTAL /FUEL TRUCK RENTAL 89,280$ 113,220$ 106,220 113,220 107,370 (5,850)$ (5.2%) 65482 54102 ENERGY:AIRPORT FUEL -$ -$ --- -$ na 65482 55802 OTHER:CREDIT CARD COMM 205,644$ 224,687$ 268,241 230,000 250,000 20,000$ 8.7% TOTAL FBO EXPENSES 671,917$ 647,021$ 714,717$ 705,970$ 688,870$ (17,100)$ (2.4%) 65482 52429 TRIENNIAL DRILL & SPECIAL EVENTS -$ 11,655$ 14,663 -- -$ na 65482 52504 PERSONNEL UNIFORMS 17,178$ 20,484$ 22,175 24,200 23,500 (700)$ (2.9%) 65482 53187 TRAINING ARFF 17,430$ 19,104$ 14,181 26,000 28,700 2,700$ 10.4% 65482 54109 MISC PURCH:OPERATIONS 47,739$ 25,460$ 32,511 28,000 29,000 1,000$ 3.6% 65482 54701 FIRE FIGHTER SUITS -$ 1,359$ 2,270 5,000 5,000 -$ - TOTAL ARFF/OPERATIONS EXPENSES 82,347$ 78,061$ 85,800$ 83,200$ 86,200$ 3,000$ 3.6% 65482 52403 REP&MAINT:VEHICLE 84,590$ 14,797$ 28,571 28,000 26,300 (1,700)$ (6.1%) 65482 52404 REP&MAINT:BUILDING 77,912$ 298,562$ 130,331 213,200 195,800 (17,400)$ (8.2%) 65482 52405 REP&MAINT:EQUIPMENT 12,872$ 10,702$ 41,194 13,500 20,000 6,500$ 48.1% 65482 52409 REP&MAINT:AIRFIELD MAINTENCE 95,479$ 80,989$ 85,975 135,000 220,500 85,500$ 63.3% 65482 52411 REP&MAINT:GROUNDS 16,805$ 14,492$ 23,771 15,500 17,900 2,400$ 15.5% 65482 52417 PARKING LOT MAINT 8,179$ 7,106$ 2,247 -2,000 2,000$ na 65482 52419 NEW TOOLS & EQUIP 4,736$ 15,900$ 19,886 7,800 15,000 7,200$ 92.3% 65482 52420 PKG LOT TOW FEES 100$ -$ 200 300 300 -$ - 65482 52424 FUEL STORAGE FACILITY MAINT 51,502$ 43,280$ 56,414 155,200 160,000 4,800$ 3.1% 65482 52430 REP&MAINT:THOMPSON HOUSE 1,000$ 12,580$ 2,979 6,000 5,800 (200)$ (3.3%) AIRPORT ENTERPRISE FUND FY2020 BUDGET PROJECTIONS EXPENDITURES ORG OBJ EXPENDITURES Actual FY2016 Actual FY2017 Actual FY2018 FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 65482 52906 SNOW REMOVAL & MAINTENANCE 5,471$ 14,188$ 4,739 20,300 19,000 (1,300)$ (6.4%) 65482 52907 PROPERTY:RUBBISH PICKUP 30,265$ 21,275$ 34,426 30,000 28,700 (1,300)$ (4.3%) 65482 53300 ENVIRONMENTAL 15,708$ 8,262$ 6,381 16,000 30,000 14,000$ 87.5% 65482 53303 TRANS:SECURITY 40,587$ 44,078$ 31,969 45,800 40,000 (5,800)$ (12.7%) 65482 53804 OTHER:FREIGHT 1,399$ 2,219$ 3,474 4,300 3,000 (1,300)$ (30.2%) 65482 54101 ENERGY:GAS & DIESEL 42,448$ 39,897$ 48,920 47,900 53,000 5,100$ 10.6% 65482 54214 VEHICLE SUPPLIES 8,184$ 19,849$ 9,843 10,000 16,500 6,500$ 65.0% 65482 54302 BLDG&EQ:MAINT & SUPPLIES 12,742$ 25,074$ 26,009 19,200 25,000 5,800$ 30.2% 65482 54501 CUSTODIAL:CLEANING SUPPLY 32,240$ 31,664$ 25,102 32,500 31,000 (1,500)$ (4.6%) TOTAL SERVICE AND MAINTENANCE 542,219$ 704,912$ 582,432$ 800,500$ 909,800$ 109,300$ 13.7% 65482 52101 UTILITY:ELECTRICITY 378,151$ 325,011$ 331,670 366,000 375,000 9,000$ 2.5% 65482 52103 UTILITY:FUEL OIL 23,011$ 36,926$ 47,849 40,000 57,000 17,000$ 42.5% 65482 52104 UTILITY:PROPANE 4,400$ 5,327$ 10,314 6,000 6,000 -$ - 65482 52105 UTILITY:WATER 34,293$ 32,104$ 33,084 37,000 35,000 (2,000)$ (5.4%) 65482 52703 RENT/LSE:POSTAGE METER 509$ 885$ 649 850 850 -$ - 65482 53100 PROFESSIONAL SERVICES 191,847$ 223,270$ 272,152 375,000 344,122 (30,878)$ (8.2%) 65482 53103 GENERAL:ADVERTISING 8,056$ 10,718$ 16,757 13,500 17,500 4,000$ 29.6% 65482 53157 POLICE PROTECTION SERVICES (INDIRECT COSTS) 250,000$ 250,000$ 250,000 250,000 250,000 -$ - 65482 53159 MARKETING 2,631$ 683$ 3,314 2,800 2,800 -$ - 65482 53165 PROFESSIONAL SERVICES - AIP PROJECTS -$ -$ --- -$ na 65482 53175 PROF SVCS: FLIGHT PLANNING (PASSUR) 26,400$ 26,400$ 26,400 26,400 26,400 -$ - 65482 53176 NOISE FLIGHT TRACKING SOFTWARE (EXCELIS)15,000$ 15,000$ 16,500 15,750 16,500 750$ 4.8% 65482 53401 COMM:TELEPHONE 37,649$ 38,732$ 40,821 40,400 41,100 700$ 1.7% 65482 53402 COMM:POSTAGE 4,386$ 1,626$ 1,346 4,000 4,000 -$ - 65482 53403 COMM: AIRPORT 17,490$ 15,707$ 15,713 15,200 15,200 -$ - 65482 53803 OTHER:LICENSES & TAXES 1,159$ 640$ 977 700 1,000 300$ 42.9% 65482 54201 OFFICE SUPPLIES 24,038$ 12,533$ 14,003 24,000 17,800 (6,200)$ (25.8%) 65482 54202 OFFICE:EQUIPMENT 1,723$ 4,062$ 2,433 3,900 5,700 1,800$ 46.2% 65482 54213 RENT/LEASE:OFFICE EQUIPMENT 15,030$ 15,053$ 15,196 15,600 15,200 (400)$ (2.6%) 65482 55101 BOOKS/SUBSCRIPTIONS 3,633$ 2,559$ 4,236 5,100 4,900 (200)$ (3.9%) 65482 55102 MEMBERSHIPS & DUES 8,437$ 9,067$ 7,773 9,700 8,300 (1,400)$ (14.4%) 65482 57101 TRAVEL:HOTEL/LODGING 5,976$ 6,929$ 7,876 13,000 10,200 (2,800)$ (21.5%) 65482 57102 TRAVEL:TRANSPORTATION 14,289$ 21,569$ 9,660 15,200 14,900 (300)$ (2.0%) 65482 57103 TRAVEL:SEMINARS/CONFERENCES - GENERAL 4,024$ 4,715$ 5,335 6,300 6,300 -$ - 65482 57201 TRAVEL:MEALS & ENTERTAINMENT 1,025$ 2,380$ 1,595 4,000 3,700 (300)$ (7.5%) 65482 57802 OTHER:PROF DEVELOPMENT 2,128$ 2,785$ 3,312 6,000 4,400 (1,600)$ (26.7%) AIRPORT ENTERPRISE FUND FY2020 BUDGET PROJECTIONS EXPENDITURES ORG OBJ EXPENDITURES Actual FY2016 Actual FY2017 Actual FY2018 FY2019 BUDGET FY2020 BUDGET $ INC/(DEC) FY20/FY19 % INC/(DEC) FY20/FY19 65482 57803 OTHER:BANK CHARGES -$ -$ --- -$ na TOTAL ADMINISTRATIVE EXPENSES 1,075,287$ 1,064,681$ 1,138,966$ 1,296,400$ 1,283,872$ (12,528)$ (1.0%) 65482 57401 INS PREM:AUTO & LIABILITY 188,982$ 146,574$ 158,888 200,000 174,800 (25,200)$ (12.6%) 65482 57502 INS: WORKMANS COMP 5,153$ -$ --- -$ na 65482 59101 DEBT SERV:PRINCIPAL 820,000$ 839,000$ 818,000 867,000 680,000 (187,000)$ (21.6%) 65482 59102 DEBT SERVICE INTEREST 406,899$ 385,311$ 421,207 354,088 316,338 (37,750)$ (10.7%) 65482 59105 DEBT SERVICE BAN INTEREST -$ 73,067$ 67,895 50,000 50,000 -$ - 65482 57407 INSURANCE CLAIM -$ -$ --- -$ na 65482 59502 INDIRECTS 245,719$ 200,000$ 200,000 200,000 200,000 -$ - 65482 92004 UNPAID BILLS -$ -$ --- -$ na 65482 57601 SETTLEMENTS -$ -$ --- -$ na 65482 59991 REPAYMENT TO GENERAL FUND 108,538$ -$ 285,264 235,620 235,620 -$ - 65482 59999 CONTIGNCY RESERVE-EXPENSE -$ -$ -25,000 75,000 50,000$ 200.0% TOTAL OTHER EXPENSES 1,775,290$ 1,643,952$ 1,951,253$ 1,931,708$ 1,731,758$ (199,950)$ (10.4%) Total Other Expenses:4,147,061$ 4,138,628$ 4,473,168$ 4,817,778$ 4,700,500$ (117,278)$ (2.4%) TOTAL EXPENSES 8,450,568$ 8,654,822$ 9,231,966$ 9,745,138$ 9,719,400$ (25,738)$ (0.3%) TOTAL REVENUES (Includes GF Subsidy) (179,709)$ 333,463$ Estimated Use of retained Earnings* * Salary line items for Administration, Operations and Maintenance include Vacation, Sick Time, Personal time, Overtime, Shift Differentials, Holiday and Holiday Worked. Number of Positions in Department Full-time 33 Part-time 0 Seasonal 21 Temporary 0 Vacancies 2 New Positions Requested 0 TOTAL OF ALL POSITIONS 56 Name, Position Job Code Avg Hours Per Week Class & Step as of 6/30/19 (e.g., B -Step 3) FY2020 Step Increase Date FY2020 Projected Salary Longevity Pay Other Total by Employee RAFTER,T. - AIRPORT MANAGER AI01 40.00 CONTRACT 6/4/2020 171,000 3,500 -174,500 ALLEN, M. - FBO CLERK AI06 40.00 NON-UNION 11/30/2019 53,000 --53,000 CROOKS, D. - FINANCE ASSISTANT AI22 40.00 NON-UNION 11/15/2019 105,000 5,300 -110,300 KARBERG, N.- AIRPORT ASST. MANAGER AI28 40.00 NON-UNION 2/11/2020 100,000 2,000 -102,000 HEINTZ, L. - OPERATIONS OFFICE CLERK AI29 40.00 NON-UNION 12/7/2019 83,000 4,200 -87,200 PERALES,K.- OFFICE MANAGER AI20 40.00 NON-UNION 8/22/2019 71,000 2,200 -73,200 PEREZ,W.- FBO SUPERVISOR AI29 40.00 SUPR-5 9/3/2019 68,000 --68,000 PETROVA-POWERS,R. - OPERATIONS OFFICE CLERK AI29 40.00 NON-UNION 4/10/2020 51,000 --51,000 SANDSBURY, J. - BUSINESS FINANCE MANAGER AI04 40.00 NON-UNION 5/6/2020 99,000 2,000 -101,000 SYLVIA, D. - ASST. AIRFIELD SUPERVISOR AI24 40.00 NON-UNION 1/3/2020 126,000 6,300 -132,300 SYLVIA, L. - ADMIN ASSISTANT AI25 40.00 NON-UNION 10/15/2019 54,000 --54,000 TRUE, L. - OPERATIONS OFFICE CLERK AI29 40.00 NON-UNION 5/6/2020 56,000 --56,000 CULTURE & TOURISM - SUMMER AIDES NON-UNION 5,400 5,400 PARTIDA, J. - OFFICE ASST. TO TERM AI21 40.00 NON-UNION 10/2/2019 75,000 3,000 -78,000 VACANT - TERMINAL COORDINATOR NA 40.00 NON-UNION TBD 85,000 --85,000 FALCONER, A. - OPERATIONS AI30 40.00 OPS-1 1/14/2020 74,000 2,300 -76,300 MOONEY, T. - OPERATIONS AI30 40.00 OPS-5 5/9/2020 82,000 3,300 -85,300 WELLINGTON, F. - OPERATIONS AI30 40.00 OPS-5 7/22/2019 79,000 3,200 -82,200 NELSON, S.- OPERATIONS AI30 40.00 OPS-1 6/9/2020 66,000 2,000 -68,000 SPENCE, N.- OPERATIONS AI30 40.00 OPS-2 7/1/2019 70,000 --70,000 HARIMON, P. - OPS SUPERINTENDENT AI33 40.00 SUPR-5 9/21/2019 108,000 4,400 -112,400 BUCKLEY, B. - OPERATIONS SUPV AI32 40.00 SUPR-5 3/22/2020 95,000 3,800 -98,800 SPENCE, D.- OPERATIONS AI30 40.00 OPS-1 12/9/2019 66,000 --66,000 VACANT - OPERATIONS AI30 40.00 OPS-1 TBD 59,000 --59,000 LIBURD, L. - MAINTENANCE AI40 40.00 M1-5 2/27/2020 80,000 3,200 -83,200 GRANGRADE, J. - MAINT SUPERINTENDENT AI40 40.00 M1-5 8/2/2019 105,000 5,300 -110,300 ALLEN, G. - MAINTENANCE AI40 40.00 M1-5 4/18/2020 87,000 3,500 -90,500 O'NEIL, M. - MAINTENANCE SUPERVISOR AI40 40.00 M3-5 9/8/2019 92,000 4,600 -96,600 PINEDA, N. - MAINTENANCE AI40 40.00 M1-5 10/2/2019 78,000 3,100 -81,100 HOLDGATE, R. - MAINTENANCE AI40 40.00 M3-5 6/11/2020 84,000 3,400 -87,400 AGUIAR, M. - MAINTENANCE AI40 40.00 M1-0 10/6/2019 75,000 2,300 -77,300 FOWLER, P. - MAINTENANCE AI40 40.00 M1-5 4/10/2020 82,000 3,300 -85,300 BEAMISH, J-MAINTENANCE AI40 40.00 MS 6/11/2020 57,000 --57,000 BACKUS, JEB - MAINTENANCE MECHANIC AI40 40.00 M1-5 11/19/2019 65,000 --65,000 REED, D. - MAINTENANCE NA 40.00 M1-5 1/3/2020 56,000 --56,000 JOHNSON, C. - MAINTENANCE NA 40.00 M1-5 1/16/2020 56,000 --56,000 SEASONAL (20 POSITIONS)SEAS 15-20 WKS @ 40HRS TOWN WARRANT 7/1/2019 240,000 --240,000 Total Prorated Salary (Administration) (Munis 51100 )1,042,400$ Total Prorated Salary (Security)160,000$ Total Prorated Salary (Operations)699,000$ Total Prorated Salary (Maintenance)917,000$ Total Prorated Salary (Seasonal)240,000$ Total Longevity (Munis 51700)76,200$ Total Education (Munis 51600 )-$ Total Certification Pay (Operations) (Munis 515xx )-$ Total Certification Pay (Maintenance) (Munis 515xx)-$ Total Holiday Worked Pay (Admin/FBO) (Munis 518xx )7,500$ Total Holiday Worked Pay (Operations) (Munis 518xx )29,000$ Total Holiday Worked Pay (Maintenance) (Munis 518xx )13,000$ Shift Differential (Admin/FBO) (Munis 514xx )4,100$ Shift Differential (Operations) (Munis 514xx )10,100$ Shift Differential (Maintenance)(Munis 514xx )4,200$ Overtime Admin (enter on Munis 513xx )15,000$ Overtime Operations (enter on Munis 513xx)70,000$ Overtime Maintenance (enter on Munis 513xx)40,000$ Overtime Seasonal (enter on Munis 513xx )23,000$ Overtime Security (enter on Munis 513xx )1,500$ Contractual Obligation (1)21,000$ Promotional Increase -$ Subtotal 3,373,000$ Medicare (enter on Munis 51961 )48,900$ Health Insurance 905,000$ BCRS Retirement 692,000$ (1) Airport Manager housing stipend ($18,000 annually) plus $3,000 deferred compensation. Total 5,018,900$ FY 2020 Personnel Spreadsheet Nantucket Memorial Airport Enterprise Fund ORG: 65482 AIRPORT ENTERPRISE Waterfall Schedule- FY2020 Budget PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL Issue Payments Payments Payments Payments Payments Payments Payments Payments Purpose Date ORG OBJ FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 AIRPORT ENTERPRISE TOTAL DEBT 10,827,000.00 9,988,000.00 9,170,000.00 8,370,000.00 7,690,000.00 7,085,000.00 6,475,000.00 5,850,000.00 IMPROVEMENTS AND PROTECTION 2/15/2008 75,000.00 ------- TERMINAL 2/25/2011 130,000.00 135,000.00 140,000.00 140,000.00 150,000.00 155,000.00 165,000.00 170,000.00 PARKING LOT 2/25/2011 30,000.00 30,000.00 30,000.00 35,000.00 35,000.00 35,000.00 40,000.00 40,000.00 REMODEL OF HANGARS 6/7/2012 10,000.00 10,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 RAZE & REMOVE ANNEX 6/7/2012 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 LANDSCAPE FENCE 6/7/2012 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 ADMINISTRATION BUILDING 6/7/2012 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 RAMP LIGHTS 6/7/2012 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 RAMP ELECTRIFICATION 6/7/2012 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 PARKING LOT 6/6/2013 40,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 - RW 33 6/6/2013 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 - RAMP 6/6/2013 40,000.00 40,000.00 35,000.00 35,000.00 35,000.00 35,000.00 35,000.00 - RUNWAY 6/6/2013 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 45,000.00 - ADMINISTRATION BUILDING 6/5/2014 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 RUNWAY RESURFACING 6/5/2014 5,000.00 5,000.00 AIRPORT VEHICLES 1 6/5/2014 90,000.00 90,000.00 90,000.00 AIRPORT VEHICLES 2 6/5/2014 35,000.00 30,000.00 30,000.00 TAXIWAY DELTA WIDENING 6/5/2014 5,000.00 5,000.00 ENVIRONMENTAL STEWARDSHIP 10/22/2015 39,000.00 35,000.00 35,000.00 35,000.00 AIR VEHCLE REPLACE 144K 11'16 I 11/9/2016 49,551.00 50,000.00 45,000.00 AIR LOADER 58K 11'16 I 11/9/2016 13,449.00 10,000.00 10,000.00 5,000.00 5,000.00 5,000.00 5,000.00 TOTAL AIRPORT FUND 839,000.00 818,000.00 800,000.00 680,000.00 605,000.00 610,000.00 625,000.00 505,000.00 INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST Issue Payments Payments Payments Payments Payments Payments Payments Payments Purpose Date FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 AIRPORT ENTERPRISE TOTAL DEBT IMPROVEMENTS AND PROTECTION 2/15/2008 2,437.50 TERMINAL 2/25/2011 170,568.76 166,668.76 161,943.76 157,743.76 152,143.76 144,643.76 136,893.76 130,293.76 PARKING LOT 2/25/2011 14,406.26 13,506.26 12,456.26 11,556.26 10,156.26 8,406.26 6,656.26 5,056.26 REMODEL OF HANGARS 6/7/2012 3,550.00 3,050.00 2,675.00 2,450.00 2,225.00 1,975.00 1,725.00 1,475.00 RAZE & REMOVE ANNEX 6/7/2012 8,175.00 7,425.00 6,675.00 6,000.00 5,325.00 4,575.00 3,825.00 3,075.00 LANDSCAPE FENCE 6/7/2012 9,187.50 8,437.50 7,687.50 7,012.50 6,337.50 5,587.50 4,837.50 4,087.50 ADMINISTRATION BUILDING 6/7/2012 47,625.00 43,875.00 40,125.00 36,750.00 33,375.00 29,625.00 25,875.00 22,125.00 RAMP LIGHTS 6/7/2012 12,700.00 11,700.00 10,700.00 9,800.00 8,900.00 7,900.00 6,900.00 5,900.00 RAMP ELECTRIFICATION 6/7/2012 5,400.00 4,900.00 4,400.00 3,950.00 3,500.00 3,000.00 2,500.00 2,000.00 PARKING LOT 6/6/2013 4,600.00 3,850.00 3,150.00 2,450.00 1,750.00 1,050.00 350.00 RW 33 6/6/2013 1,300.00 1,100.00 900.00 700.00 500.00 300.00 100.00 RAMP 6/6/2013 4,700.00 3,900.00 3,150.00 2,450.00 1,750.00 1,050.00 350.00 RUNWAY 6/6/2013 5,850.00 4,950.00 4,050.00 3,150.00 2,250.00 1,350.00 450.00 ADMINISTRATION BUILDING 6/5/2014 80,100.00 77,100.00 74,100.00 69,600.00 65,100.00 60,600.00 56,100.00 51,600.00 RUNWAY RESURFACING 6/5/2014 200.00 100.00 AIRPORT VEHICLES 1 6/5/2014 6,300.00 4,500.00 2,700.00 AIRPORT VEHICLES 2 6/5/2014 2,200.00 1,500.00 900.00 TAXIWAY DELTA WIDENING 6/5/2014 200.00 100.00 ENVIRONMENTAL STEWARDSHIP 10/22/2015 5,811.00 2,625.00 1,575.00 525.00 AIR VEHCLE REPLACE 144K 11'16 I 11/9/2016 5,106.78 2,300.00 900.00 AIR LOADER 58K 11'16 I 11/9/2016 2,775.22 1,600.00 1,300.00 1,050.00 875.00 625.00 375.00 TOTAL AIRPORT FUND 385,311.02 367,169.52 341,087.52 316,337.52 294,362.52 270,937.52 247,187.52 225,987.52 MUNIS PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL PRINCIPAL Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 5,345,000.00 4,840,000.00 4,325,000.00 3,855,000.00 3,375,000.00 2,885,000.00 2,385,000.00 1,880,000.00 1,370,000.00 970,000.00 560,000.00 285,000.00 175,000.00 185,000.00 190,000.00 200,000.00 210,000.00 220,000.00 225,000.00 240,000.00 250,000.00 260,000.00 275,000.00 285,000.00 40,000.00 45,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 5,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 75,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 10,000.00 10,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 ------------ ------------ ------------ ------------ 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 5,000.00 505,000.00 515,000.00 470,000.00 480,000.00 490,000.00 500,000.00 505,000.00 510,000.00 400,000.00 410,000.00 275,000.00 285,000.00 INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST INTEREST Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments FY2025 FY2026 FY2027 FY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 123,493.76 116,493.76 108,862.50 100,787.50 92,037.50 82,587.50 72,687.50 62,281.26 51,181.26 39,306.26 26,956.26 13,893.76 3,456.26 1,856.26 1,225.00 1,025.00 875.00 725.00 571.88 415.63 253.13 84.38 2,450.00 2,050.00 1,750.00 1,450.00 1,143.75 831.25 506.25 168.75 3,337.50 2,737.50 2,287.50 1,837.50 1,378.13 909.08 421.88 84.38 18,375.00 15,375.00 13,125.00 10,875.00 8,578.13 6,234.38 3,796.88 1,265.63 4,900.00 4,100.00 3,500.00 2,900.00 2,287.50 1,662.50 1,012.50 337.50 1,500.00 1,100.00 875.00 725.00 571.88 415.63 253.13 84.38 47,100.00 42,600.00 38,100.00 33,600.00 29,100.00 24,600.00 20,100.00 15,075.00 10,050.00 5,025.00 125.00 205,962.52 187,337.52 169,375.00 152,900.00 135,668.77 117,655.97 99,031.27 79,381.28 61,231.26 44,331.26 26,956.26 13,893.76