Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Section XII - Enterprise Funds - Airport
FY2018 BUDGET PROJECTION •ENTERPRISE FUNDS •NANTUCKET MEMORIAL AIRPORT Town and County of Nantucket 16 Broad Street Nantucket, MA 02554 FY2018BudgetFY2018 BudgetAirport Enterprise Fund 1 FY2017ii d iAirport Enterprise Fund Review•Mission: “ThiifthNtktMilAi t(ACK)i tidti llfill–“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:–Continue development and implementation of air service development plan.–Replace Island Airlines service to Hyannis.–Explore alternate revenue generating options and expense reduction opportunities.–Continue Process Improvements–Address deficient capital needsI iti tidAliht•Initiatives and Accomplishments:–Held air service Focus Group and meeting with Cape Chambers–Increased service and larger aircraft by American, New destination (LGA) by Delta and extended season for JetBlue–Obtained FAA approval for Employee Housing projectpppygpj–Cape & Islands Airport Coalition formed–Expanded use of VEOCI software platform noise complaints, time off requests, lease management and multiple operational processes–Tower Rehabilitation CompletedAirfield ElectricalVaultFlightInformationDisplaySystem/PublicAddresssystem&InteractiveEmployee–Airfield Electrical Vault, Flight Information Display System/Public Address system & Interactive Employee Training system projects startedAirport Enterprise Fund2 FY2018ii d iAirport Enterprise Fund Overview •Priorities:–Safety & Security–Quality Service Delivery–Financial Sustainability–ImprovedAirServiceImproved Air Service•Significant Changes Year‐to‐Year–Significant reduction in fuel costs–Improved seasonal air service–Island Air Bankruptcy in December of 2015•Key Issues–Hyannis air service & freight replacement–ContinuedFerryCompetitionContinued Ferry Competition–Sustainable annual revenue base (non‐aeronautical)–Regulatory changes –Rules & Regulations and Minimum Standards Update–Funding the National System –FAA Funding/State FundingAirport Enterprise Fund3 FY2018 Budgetii dAirport Enterprise FundSUMMARYActual Actual Actual Actual FY2017BUDGETFY2018BUDGET$ INC/(DEC) % INC/(DEC) SUMMARYFY2014 FY2015 FY2016 FY2017 YTDFY2017 BUDGETFY2018 BUDGET FY18/FY17FY18/FY17Payroll‐Salary 2,903,502$ 3,069,266$ 3,038,229$ 1,539,234$ 3,152,950$ 3,306,200$ 153,250$ 4.9% Medicare P/R Tax Expense 42,013 44,439 44,054 22,324 45,700 47,900 2,200$ 4.8% MedicalInsurance539,062597,610678,045344,734676,913764,50087,587$12.9%Medical Insurance539,062 597,610 678,045 344,734 676,913 764,500 87,587$ 12.9% Barnstable County Retirement456,485 477,801 543,178 569,586 569,000 617,365 48,365$ 8.5% Utilities480,620 526,162 519,953 201,173 568,000 507,600 (60,400)$ (10.6%) Airport Fuel‐Since 2012 Reported in Fuel Revolver‐ ‐ ‐ ‐ ‐ ‐ ‐$ naRepairs & Maintenance262,884 377,823 353,810 150,087 457,650 535,400 77,750$ 17.0% Professional Services233,741 252,722 233,247 100,544 388,400 365,400 (23,000)$ (5.9%) Police Protection Services229,167 270,833 250,000 104,167 250,000 250,000 ‐$ ‐ Settlements/Personnel Contract Expense‐ ‐ ‐ ‐ ‐ ‐ ‐$ naGeneral Insurance & WC156,366 157,533 194,135 42,374 225,900 247,200 21,300$ 9.4% FBO Catering331,295 350,682 364,306 225,880 368,000 340,000 (28,000)$ (7.6%) Other Supplies96,104 97,912 81,940 55,340 89,700 91,100 1,400$ 1.6% Travel31,462 35,069 25,314 14,694 37,700 44,300 6,600$ 17.5% Debt Service1,163,846 1,264,551 1,226,899 553,936 1,234,312 1,195,171 (39,142)$ (3.2%) IndirectCosts329 096200 000245 719100 000200 000200 000‐$‐Indirect Costs329,096 200,000 245,719 100,000 200,000 200,000 $ Other 504,921 597,244 651,738 364,349 864,815 899,540 34,725$ 4.0% TOTAL AIRPORT7,760,564$ 8,319,647$ 8,450,568$ 4,388,423$ 9,129,040$ 9,411,675$ 282,636$ 3.1%4 AppendixAppendixAirport Enterprise Fund5 Town & County of Nantucket Town & County of Nantucket Organization Chart Organization Chart ––Airport Enterprise FundAirport Enterprise FundAirport Manager(T. Rafter)Compliance Manager (D. Sylvia)Office Manager(J.Torres)SMS Manager(Proposed)Environmental CoordinatorBi /FiAi tOtiSitTil(J. Torres)Admin. Assistant(M. Williams)(N. Karberg)Business/Finance Manager(J. Sandsbury)Finance AssistantAirportMaintenance Superintendant(J. Grangrade)Maintenance SupervisorAirport Operations Superintendant(P. Harimon)Operations SupervisorFBO SupervisorSecurity Terminal Coordinator(R. Tallman)Asst. Security/Terminal (D. Crooks)Receptionist (L. True)Supervisor(M. O'Neil)Maintenance Staff(6)p p(B. Buckley)Operations Specialists(6)pW. PerezFBO Staff(3)Custodial(4)y/Coordinator(J. Partida)Seasonal Staff(1)Seasonal Staff(10)Seasonal Staff(3)Seasonal Staff(1 FT –2 PT)6 FY 2018 Budget DetailAirport Enterprise Fund7 FY2018Airport Enterprise Fund Exceptions POSITIONSPOSITIONSAIRPORT ADMINISTRATION SALARY* $ 85,000 OPERATIONAL EXPENSES (1)EQUIPMENT RENTAL /FUEL TRUCK RENTAL 13,320 TRIENNIAL DRILL & SPECIAL EVENTS11,000 MISC PURCH:OPERATIONS 16,500 FIREFIGHTER SUITS5,000 REP&MAINT:BUILDING 51,900 REP&MAINT:AIRFIELD MAINTENCE 9,000 FUEL STORAGE FACILITY MAINT 31,000 REP&MAINT:THOMPSON HOUSE11,000 TRANS:SECURITY11 000TRANS:SECURITY 11,000 TRAVEL:TRANSPORTATION5,600 INS PREM:AUTO & LIABILITY 18,175 (1) Non‐controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded.WANNACOMET WATER ENTERPRISE8 FY2018Airport Enterprise Fund Exceptions (cont’d) Capital ProjectsReconstruct Apron Area 3/Replace Fence $ 2,200,000 5 Year CIP EA/EIR Permitting $ 450,000 ALP Update and SMS Narrative $ 250,000 Airport Equipment and Vehicles $ 198,000 Extension of Bag Belt$ 200,000 Fire Surpression for Fuel Farm $ 70,000 Fuel Farm Piping Replacement$ 436,100 Paint and Beads & Rubber & Markings$ 176,000 AiF iliUd$52 000Airport Facility Upgrades$ 52,000 (1) Non‐controllable expenses such as general insurance, medical insurance, pension costs and utilities are excluded.WANNACOMET WATER ENTERPRISE9 TOWN OF NANTUCKETNANTUCKET MEMORIAL AIRPORT ‐ ENTERPRISE FUNDACTUALBUDGETPROPOSED BUDGETFY2016FY2017FY2018REVENUE7,754,594 8,006,467 8,493,600 EXPENSES8,450,568 9,129,040 9,411,675 NET EARNINGS(695,974) (1,122,573) (918,075) Transfer from Retained Earnings828,843 1,122,573 218,075 NET EARNINGS132,869 ‐ (700,000) NET SOURCES/USES:Transfer from Airport Fuel Revolver1,041,151 ‐ 300,000 Transfer from Retained Earnings ‐ PFC‐ ‐ 400,000 Ending FB1,174,020 ‐ ‐ Certified Retained Earnings as of July 1, 20161,620,224 ACTUALPROJECTEDPROPOSED BUDGETAVIATION FUEL REVOLVERFY2016FY2017FY2018Fuel Sales5,300,000 4,000,000 4,000,000 Fuel Purchases3,578,424 4,000,000 4,000,000 ‐ ‐ ‐ Net Surplus (Deficit)1,721,576 ‐ ‐ Beginning FB1,091,151 1,771,576 1,771,576 Transfer to Airport Enterprise Fund(1,041,151) ‐ (300,000) Ending FB1,771,576 1,771,576 1,471,576 10 AIRPORT ENTERPRISE FUNDFY2018 BUDGET PROJECTIONREVENUEActual FY2014 Actual FY2015 Actual FY2016Actual FY2017 YTD FY2017 BUDGET FY2018 BUDGET $ INC/(DEC) FY18 /FY17 Budget % INC/(DEC) FY18 /FY17 Budget ORG OBJ Revenue:FBO Sales Income65482 42451FUEL SALES 2,077,737 1,971,243 1,113,093 780,502 2,000,000 2,000,000 ‐ ‐ 65482 42452FUEL SALES ‐ GAS & DIESEL ‐ 3,101 80 ‐ ‐ ‐ ‐ na6548243231GEN AVIATION LANDING FEE 518,754 552,130 650,541 571,912 550,000 700,000 150,000 27.3% 65482 43232GEN AVIATION RAMP FEES 1,218,202 1,344,062 1,689,798 1,435,607 1,350,000 1,800,000 450,000 33.3% 65482 43239FBO SUPPLIES AND SERVICES 43,009 32,567 37,588 26,351 38,000 35,000 (3,000) (7.9%) 65482 43704CATERING INCOME 398,490 429,173 451,344 279,261 415,000 400,000 (15,000) (3.6%) Total FBO Sales: 4,256,193 4,332,275 3,942,442 3,093,632 4,353,000 4,935,000 582,000 13.4%Rental Income65482 43606RENTAL FEES: EMP HOUSING 1,800 5,600 8,880 6,000 5,600 5,000 (600) (10.7%) 65482 43630RENTAL INCOME‐TERMINAL 369,088 607,645 548,510 229,091 371,640 465,000 93,360 25.1% 65482 43631RENTAL INCOME‐TOWER 133,122 144,216 133,122 55,468 133,000 133,000 ‐ ‐ 65482 43632RENTAL INCOME‐LAND 658,649 683,230 656,451 318,124 788,066 654,000 (134,066) (17.0%) 65482 43633RENTAL INCOME‐HANGAR 97,304 87,052 78,337 52,715 83,500 87,000 3,500 4.2% Totals Rentals: 1,259,963.30 1,527,743 1,425,300 661,398 1,381,806 1,344,000 (37,806) (2.7%) Fee Income65482 43709VIDEO CONFERENCE‐ ‐ 100 ‐ ‐ ‐ ‐ na65482 43705ART SALES COMMISSION 1,000 1,870 ‐ 1,200 1,400 ‐ (1,400) (100.0%) 65482 43706CONCESSION FEES 32,647 33,308 36,080 28,025 33,300 34,000 700 2.1% 65482 43707AUTO RENTAL COMMISSIONS 509,199 527,843 589,904 584,049 520,000 600,000 80,000 15.4% 65482 43233FREIGHT HANDLING FEE 63,345 57,862 64,807 46,880 91,757 75,000 (16,757) (18.3%) 65482 43238AIRLINE LANDING FEES 503,106 523,180 386,965 367,635 454,204 440,000 (14,204) (3.1%) 65482 43234RESERVED TIE DOWN FEES 49,825 53,900 49,700 16,800 48,800 49,700 900 1.8% Total Fees: 1,159,122 1,197,964 1,127,556 1,044,589 1,149,461 1,198,700 49,239 4.3%Vehicle Income65482 43236PARKING LOT FEES 316,027 306,203 275,950 138,920 311,000 200,000 (111,000) (35.7%) 65482 47701PARKING TICKETS 32,137 19,770 17,730 8,440 24,000 18,000 (6,000) (25.0%) 65482 44518TAXI PERMITS 19,500 22,700 27,300 1,600 25,000 25,000 ‐ ‐ Total Vehicles: 367,664 348,673 320,980 148,960 360,000 243,000 (117,000) (32.5%) Other Income65482 43634CUSTOMER FACILITY CHARGES 91,346 86,992 105,667 150,127 174,000 175,000 1,000 0.6% 65482 43235ANNUAL BUSINESS ACTIVITY FEE 23,750 58,500 64,500 13,500 23,750 43,500 19,750 83.2% 65482 42401PASSENGER FACILITY CHARGE(PFC)‐ 445,036 566,828 435,062 434,050 425,000 (9,050) (2.1%) 65482 48201INTEREST ON INVESTMENTS 22,789 22,909 41,091 22,389 23,000 29,000 6,000 26.1% 65482 43237FINGER PRINTING FEES 1,950 3,250 3,750 1,050 2,600 2,600 ‐ ‐ 65482 43708MISC INC 22,084 7,339 7,549 2,078 14,000 7,000 (7,000) (50.0%) 65482 45402FEDERAL REV ‐ LEO 90,820 90,820 133,570 52,298 90,800 90,800 ‐ ‐ 65482 48400MISC REVENUE 233,865 101 ‐ ‐ ‐ ‐ ‐ na65482 48436INS PROCEEDS‐ ‐ ‐ ‐ ‐ ‐ ‐ na65482 49000REFUNDS (65,462) (2,350) ‐ ‐ ‐ ‐ ‐ na65482 49104PREMIUM REVENUE ON DEBT101,870 ‐ 15,361 ‐ ‐ ‐ ‐ na65482 49701TRANSFER FROM GENERAL FUND 304,598 ‐ ‐ ‐ ‐ ‐ ‐ naTotal Other Income: 827,610 712,597 938,316 676,504 762,200 772,900 10,700 1.4%SUBTOTAL OPERATING REVENUE7,870,552 8,119,252 7,754,594 5,625,082 8,006,467 8,493,600 487,133 6.1%TRANSFER FROM GENERAL FUND‐ ‐ ‐ TOTAL REVENUE7,870,552 8,119,252 7,754,594 5,625,082 8,006,467 8,493,600 487,133 6.1%11 AIRPORT ENTERPRISE FUNDFY2018 BUDGET PROJECTIONSEXPENDITURESActual FY2014 Actual FY2015 Actual FY2016Actual FY2017 YTD FY2017 BUDGET FY2018 BUDGET $ INC/(DEC) FY18/FY17 % INC/(DEC) FY18/FY17 ORG OBJ65482 51100AIRPORT ADMINISTRATION SALARY* 1,115,598$ 1,069,422$ 1,057,727$ 526,139$ 1,003,400$ 1,107,600$ 104,200$ 10.4% 65482 51700LONGEVITY PAY 54,262$ 59,872$ 58,921$ 60,614$ 64,200 68,000 3,800$ 5.9% 65482 51122AIRPORT OPERATIONS SALARY* 717,075$ 782,913$ 692,759$ 327,931$ 714,724 722,324 7,600$ 1.1% 65482 51123AIRPORT MAINTENANCE SALARY* 851,402$ 928,447$ 872,487$ 414,600$ 958,476 969,576 11,100$ 1.2% 65482 51124AIRPORT SECURITY SALARY ‐$ 54,750$ 167,569$ 84,121$ 169,900 170,700 800$ 0.5% 65482 51200SALARY, SEASONAL 165,165$ 169,351$ 188,767$ 125,828$ 242,250 268,000 25,750$ 10.6% 65482 51701INS PREM:MEDICAL BLUE CROSS 539,062$ 597,610$ 678,045$ 344,734$ 676,913 764,500 87,587$ 12.9% 65482 51960COMPENSATION/UNEMPLOYMENT‐$ 4,511$ ‐$ ‐$ ‐ ‐ ‐$ na65482 51961MEDICARE P/R TAX 42,013$ 44,439$ 44,054$ 22,324$ 45,700 47,900 2,200$ 4.8% 65482 51770BARNSTABLE COUNTY RETIREMT FND 456,485$ 477,801$ 543,178$ 569,586$ 569,000 617,365 48,365$ 8.5% 65482 51900CONTRACTUAL OBLIGATIONS** ‐$ ‐$ ‐$ ‐ ‐ ‐$ naTOTAL PAYROLL EXPENSES 3,941,062$ 4,189,116$ 4,303,506$ 2,475,879$ 4,444,563$ 4,735,965$ 291,402$ 6.6% 65482 52501MISC PURCH:FBO CATERING 331,295$ 350,682$ 364,306$ 225,880$ 368,000 340,000 (28,000)$ (7.6%) 65482 52502MISC PURCH:FBO/PILOT SERVICES 18,529$ 31,646$ 12,686$ 8,960$ 31,600 33,500 1,900$ 6.0% 65482 52505EQUIPMENT RENTAL /FUEL TRUCK RENTAL 82,430$ 89,280$ 89,280$ 56,610$ 99,900 113,220 13,320$ 13.3% 65482 55802OTHER:CREDIT CARD COMM 207,394$ 246,228$ 205,644$ 186,086$ 256,000 225,000 (31,000)$ (12.1%) TOTAL FBO EXPENSES 640,449$ 717,835$ 671,917$ 477,536$ 755,500$ 711,720$ (43,780)$ (5.8%) 65482 52429TRIENNIAL DRILL & SPECIAL EVENTS‐$ 18,971$ ‐$ 9,138$ 1,000 12,000 11,000$ 1,100.0% 65482 52504PERSONNEL UNIFORMS 18,846$ 21,040$ 17,178$ 19,604$ 24,200 23,500 (700)$ (2.9%) 65482 53187TRAINING ARFF ‐$ 23,742$ 17,430$ 8,151$ 19,200 23,500 4,300$ 22.4% 65482 54109MISC PURCH:OPERATIONS ‐$ 10,594$ 47,739$ 9,171$ 18,000 34,500 16,500$ 91.7% 65482 54701OPS SILVER SUITS‐$ 3,476$ ‐$ ‐$ ‐ 5,000 5,000$ naTOTAL ARFF/OPERATIONS EXPENSES18,846$ 77,823$ 82,347$ 46,064$ 62,400$ 98,500$ 36,100$ 57.9% 65482 52403REP&MAINT:VEHICLE‐$ 13,786$ 84,590$ 7,391$ 22,000 23,800 1,800$ 8.2% 65482 52404REP&MAINT:BUILDING 111,544$ 185,750$ 77,912$ 74,983$ 178,000 229,900 51,900$ 29.2% 65482 52405REP&MAINT:EQUIPMENT 59,341$ 53,574$ 12,872$ 3,091$ 44,450 21,100 (23,350)$ (52.5%) 65482 52409REP&MAINT:AIRFIELD MAINTENCE 65,218$ 64,669$ 95,479$ 45,350$ 114,700 123,700 9,000$ 7.8% 65482 52411REP&MAINT:GROUNDS 10,623$ 17,307$ 16,805$ 9,971$ 21,000 22,100 1,100$ 5.2% 65482 52417PARKING LOT MAINT 9,568$ ‐$ 8,179$ 2,208$ 11,000 10,000 (1,000)$ (9.1%) 65482 52419NEW TOOLS & EQUIP 3,623$ 15,085$ 4,736$ 11,787$ 4,700 10,600 5,900$ 125.5% 65482 52420PKG LOT TOW FEES 400$ 195$ 100$ ‐$ 300 300 ‐$ ‐ 65482 52424FUEL STORAGE FACILITY MAINT 6,590$ 29,617$ 51,502$ 780$ 33,000 64,000 31,000$ 93.9% 65482 52430REP&MAINT:THOMPSON HOUSE‐$ 2,801$ 1,000$ 429$ 7,500 18,500 11,000$ 146.7% 65482 52906SNOW REMOVAL & MAINTENANCE‐$ 10,318$ 5,471$ 5,885$ 26,000 22,300 (3,700)$ (14.2%) 65482 52907PROPERTY:RUBBISH PICKUP 24,927$ 25,235$ 30,265$ 9,494$ 26,500 24,850 (1,650)$ (6.2%) 65482 53300ENVIRONMENTAL 39,661$ 28,264$ 15,708$ 959$ 15,200 22,000 6,800$ 44.7% 65482 53303TRANS:SECURITY 17,041$ 21,987$ 40,587$ 25,219$ 34,000 45,000 11,000$ 32.4% 65482 53804OTHER:FREIGHT 3,324$ 3,995$ 1,399$ 941$ 4,500 3,300 (1,200)$ (26.7%) 65482 54101ENERGY:GAS & DIESEL 71,905$ 67,505$ 42,448$ 18,633$ 70,000 44,100 (25,900)$ (37.0%) 65482 54214VEHICLE SUPPLIES‐$ 10,261$ 8,184$ 13,741$ 10,000 10,000 ‐$ ‐ 65482 54302BLDG&EQ:MAINT & SUPPLIES 36,320$ 26,954$ 12,742$ 7,669$ 23,000 12,200 (10,800)$ (47.0%) 65482 54501CUSTODIAL:CLEANING SUPPLY 29,671$ 30,769$ 32,240$ 15,425$ 32,000 34,000 2,000$ 6.3% TOTAL SERVICE AND MAINTENANCE 489,756$ 608,074$ 542,219$ 253,955$ 677,850$ 741,750$ 63,900$ 9.4% 65482 52101UTILITY:ELECTRICITY 286,172$ 346,825$ 378,151$ 137,666$ 372,000 341,000 (31,000)$ (8.3%) 65482 52103UTILITY:FUEL OIL 57,628$ 47,096$ 23,011$ 5,839$ 48,000 43,000 (5,000)$ (10.4%) 65482 52104UTILITY:PROPANE 8,810$ 6,402$ 4,400$ 731$ 7,000 7,000 ‐$ ‐ 65482 52105UTILITY:WATER 33,106$ 35,725$ 34,293$ 21,046$ 37,000 35,000 (2,000)$ (5.4%) 65482 52703RENT/LSE:POSTAGE METER 11,913$ 696$ 509$ 472$ 750 850 100$ 13.3% 65482 53100PROFESSIONAL SERVICES 189,741$ 178,752$ 191,847$ 77,944$ 347,000 322,000 (25,000)$ (7.2%) 65482 53103GENERAL:ADVERTISING 7,970$ 56$ 8,056$ 3,253$ 4,000 9,900 5,900$ 147.5% 65482 53157POLICE PROTECTION SERVICES (INDIRECT COSTS) 229,167$ 270,833$ 250,000$ 104,167$ 250,000 250,000 ‐$ ‐ 65482 53159MARKETING‐$ 3,856$ 2,631$ ‐$ 2,500 2,700 200$ 8.0% 65482 53165PROFESSIONAL SERVICES ‐ AIP PROJECTS ‐$ 8,370$ ‐$ 2,800$ ‐ 2,000 2,000$ na12 AIRPORT ENTERPRISE FUNDFY2018 BUDGET PROJECTIONSEXPENDITURESActual FY2014 Actual FY2015 Actual FY2016Actual FY2017 YTD FY2017 BUDGET FY2018 BUDGET $ INC/(DEC) FY18/FY17 % INC/(DEC) FY18/FY17 ORG OBJ65482 53175PROF SVCS: FLIGHT PLANNING (PASSUR) 44,000$ 50,600$ 26,400$ 19,800$ 26,400 26,400 ‐$ ‐ 65482 53176NOISE FLIGHT TRACKING SOFTWARE (EXCELIS)‐$ 15,000$ 15,000$ ‐$ 15,000 15,000 ‐$ ‐ 65482 53401COMM:TELEPHONE 22,999$ 22,610$ 37,649$ 17,258$ 34,000 37,500 3,500$ 10.3% 65482 53402COMM:POSTAGE 3,396$ 2,219$ 4,386$ 626$ 3,300 4,000 700$ 21.2% 65482 53403COMM: AIRPORT 18,020$ 15,657$ 17,490$ 6,896$ 17,000 16,300 (700)$ (4.1%) 65482 53803OTHER:LICENSES & TAXES 1,270$ 525$ 1,159$ 400$ 1,545 1,800 255$ 16.5% 65482 54201OFFICE SUPPLIES 26,490$ 14,842$ 24,038$ 6,718$ 20,000 24,300 4,300$ 21.5% 65482 54202OFFICE:EQUIPMENT 4,432$ 10,687$ 1,723$ 989$ 2,700 2,500 (200)$ (7.4%) 65482 54213RENT/LEASE:OFFICE EQUIPMENT ‐$ 15,689$ 15,030$ 6,375$ 16,000 15,700 (300)$ (1.9%) 65482 55101BOOKS/SUBSCRIPTIONS 4,466$ 3,165$ 3,633$ 1,575$ 4,000 4,100 100$ 2.5% 65482 55102MEMBERSHIPS & DUES 4,742$ 10,133$ 8,437$ 7,692$ 11,000 8,400 (2,600)$ (23.6%) 65482 57101TRAVEL:HOTEL/LODGING 17,261$ 9,205$ 5,976$ 2,975$ 11,000 9,500 (1,500)$ (13.6%) 65482 57102TRAVEL:TRANSPORTATION 978$ 20,300$ 14,289$ 8,432$ 20,700 26,300 5,600$ 27.1% 65482 57103TRAVEL:SEMINARS/CONFERENCES ‐ GENERAL7,061$ 3,802$ 4,024$ 2,450$ 4,500 5,300 800$ 17.8% 65482 57201TRAVEL:MEALS & ENTERTAINMENT6,162$ 1,761$ 1,025$ 837$ 1,500 3,200 1,700$ 113.3% 65482 57802OTHER:PROF DEVELOPMENT 20,871$ 9,909$ 2,128$ 1,740$ 11,000 7,000 (4,000)$ (36.4%) 65482 57803OTHER:BANK CHARGES (8,300)$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ naTOTAL ADMINISTRATIVE EXPENSES 998,355$ 1,104,714$ 1,075,287$ 438,680$ 1,267,895$ 1,220,750$ (47,145)$ (3.7%) 65482 57401INS PREM:AUTO & LIABILITY 156,366$ 146,447$ 188,982$ 42,374$ 213,400 231,575 18,175$ 8.5% 65482 57502INS: WORKMANS COMP‐$ 11,086$ 5,153$ ‐$ 12,500 15,625 3,125$ 25.0% 65482 59101DEBT SERV:PRINCIPAL 765,000$ 834,000$ 820,000$ 319,000$ 839,000 818,000 (21,000)$ (2.5%) 65482 59102DEBT SERVICE INTEREST 398,846$ 420,569$ 406,899$ 196,474$ 385,312 367,171 (18,142)$ (4.7%) 65482 59103ISSUE EXPENSE ‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 59105DEBT SERVICE BAN INTEREST ‐$ 9,982$ ‐$ 38,462$ 10,000 10,000 ‐$ ‐ 65482 59104DEBT SERVICE BAN PRINCIPAL ‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 59000DEBT SERVICE ‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 56202RETIREMENT‐SHOWN PROPERLY IN PAYROLL EXPENSES‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 57407INSURANCE CLAIM ‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 57600PERSONNEL CONTRACT EXPENSE‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 59501INDIRECTS 329,096$ 200,000$ 245,719$ 100,000$ 200,000 200,000 ‐$ ‐ 65482 58999FINCOM TRANSFER EXPENSE ‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 92004UNPAID BILLS‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 57601SETTLEMENTS ‐$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 59250INTEREST: GENERAL22,788$ ‐$ ‐$ ‐$ ‐ ‐ ‐$ na65482 59991REPAYMENT TO GENERAL FUND ‐$ ‐$ 108,538$ ‐$ 235,620 235,620 ‐$ ‐ 65482 59999CONTIGNCY RESERVE‐EXPENSE ‐$ ‐$ ‐$ ‐$ 25,000 25,000 ‐$ ‐ TOTAL OTHER EXPENSES 1,672,096$ 1,622,084$ 1,775,290$ 696,310$ 1,920,832$ 1,902,991$ (17,842)$ (0.9%) Total Other Expenses:3,819,502$ 4,130,531$ 4,147,061$ 1,912,544$ 4,684,477$ 4,675,711$ (8,767)$ (0.2%) TOTAL EXPENSES 7,760,564$ 8,319,647$ 8,450,568$ 4,388,423$ 9,129,040$ 9,411,675$ 282,636$ 3.1% TOTAL REVENUES (Includes GF Subsidy)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.13 Number of Positions in DepartmentFull-time 34Part-time 0Seasonal21Temporary0Vacancies0New Positions Requested1TOTAL OF ALL POSITIONS53Name, PositionJob Code Avg Hours Per WeekClass & Step as of 6/30/17(e.g., B -Step 3)FY2018 Step IncreaseDateFY2018 Projected SalaryLongevityPayOtherTotal byEmployeeRAFTER,T. - AIRPORT MANAGER AI01 40.00 CONTRACT 6/4/2018 159,300 3,200 - 162,500SANDSBURY, J. - BUSINESS FINANCE MANAGER AI04 40.00 NON-UNION 5/6/2018 87,400 - - 87,400CROOKS, D. - ADMINISTRATION ASSISTANT AI22 40.00 NON-UNION 11/15/2017 97,800 3,900 - 101,700ALLEN, M. - FBO CLERK AI06 40.00 UNION 11/30/2017 44,800 - - 44,800HEINTZ, L. - OPERATIONS OFFICE CLERK AI29 40.00 UNION 12/7/2017 77,200 3,100 - 80,300JOHNSON,C. - OPERATIONS OFFICE CLERK AI29 40.00 UNION 4/10/2018 47,600 - - 47,600TRUE, L. - OPERATIONS OFFICE CLERK AI29 40.00 UNION 5/6/2018 48,900 - - 48,900WILLIAMS,M.-OPERATIONS OFFICE CLERK AI25 40.00 NON-UNION 7/7/2017 53,500 - - 53,500SYLVIA, D. - ASST. AIRFIELD SUPERVISOR AI24 40.00 NON-UNION 1/3/2018 117,400 5,900 - 123,300TORRES, J. - OFFICE ADMINISTRATION AI20 40.00 NON-UNION 8/3/2017 105,900 3,200 - 109,100KARBERG, N.-ENVIRONMENTAL AI28 40.00 NON-UNION 2/11/2018 87,400 1,700 - 89,100PEREZ,W.- FBO SUPERVISOR AI29 40.00 SUPR-5 9/3/2017 63,200 - - 63,200SMS MANAGER/COORDINATOR 40.00 NON-UNION 85,000 - - 85,000VISITOR SERVICES - SUMMER AIDES NON-UNION 5,400 5,400PARTIDA, J. - OFFICE ASST. TO TERM AI21 40.00 NON-UNION 10/2/2017 65,300 2,000 - 67,300TALLMAN, R. - TERMINAL COORDINATOR AI26 40.00 NON-UNION 5/6/2018 105,400 4,200 - 109,600FALCONER, A. - OPERATIONS AI30 40.00 OPS-1 1/14/2018 68,700 - - 68,700MOONEY, T. - OPERATIONS AI30 40.00 OPS-5 5/9/2018 75,100 2,300 1,411 78,811WELLINGTON, F. - OPERATIONS AI30 40.00 OPS-5 7/22/2017 77,200 2,300 1,356 80,856NELSON, S.- OPERATIONS AI30 40.00 OPS-1 6/9/2018 61,100 - 972 62,072SPENCE, N.- OPERATIONS AI30 40.00 OPS-2 7/1/2017 58,700 - - 58,700HARIMON, P. - OPS SUPERINTENDENT AI33 40.00 SUPR-5 9/21/2017 100,600 3,000 3,851 107,451BUCKLEY, B. - OPERATIONS SUPV AI32 40.00 SUPR-5 5/22/2018 88,700 3,500 1,634 93,834SPENCE, D.- OPERATIONS AI30 40.00 OPS-1 12/9/2017 57,000 - - 57,000LIBURD, L. - MAINTENANCE AI40 40.00 M1-5 2/27/2018 74,600 3,000 - 77,600FY 2018 Personnel SpreadsheetNantucket Memorial Airport Enterprise FundORG: 6548214 GRANGRADE, J. - MAINT SUPERINTENDENTAI4040.00M1-58/2/2017 97,700 4,9001,634104,234ALLEN, G. - MAINTENANCEAI4040.00M1-54/18/2018 80,400 3,200-83,600O'NEIL, M. - MAINTENANCE SUPERVISORAI4040.00M3-59/8/2017 86,000 3,4001,43990,839PINEDA, N. - MAINTENANCEAI4040.00M1-510/2/2017 72,500 2,200-74,700HOLDGATE, R. - MAINTENANCEAI4040.00M3-56/11/2018 78,000 3,100-81,100EDWARDS, B. - MAINTENANCEAI4040.00M1-012/9/2017 48,500--48,500AGUIAR, M. - MAINTENANCEAI4040.00M1-010/6/2017 69,400--69,400FOWLER, P. - MAINTENANCEAI4040.00M1-54/10/2018 76,200 3,0001,40380,603MUHLER, T. - MAINTENANCEAI4040.00M1-51/6/2018 74,600 3,700-78,300DUGAN,J.- MAINTENANCEAI4040.00M1-39/9/2017 66,800--66,800RAY,L.- MAINTENANCEAI4040.00M1-54/15/2018 78,900 3,200-82,100SEASONAL (19 POSITIONS)SEAS 15-20 WKS @ 40HRS TOWN WARRANT 7/1/2017 252,000--252,000Total Prorated Salary (Administration) (Munis 51100)1,080,800$ Seasonal14,500.00reg hoursTotal Prorated Salary (Security)170,700$ $19.00Total Prorated Salary (Operations)587,100$ Total Prorated Salary (Maintenance)903,600$ Total Prorated Salary (Seasonal)252,000$ Total Longevity (Munis 51700)68,000$ 650.00OT hoursTotal Education (Munis 51600)‐$ 28.50Total Certification Pay (Operations) (Munis 515xx)9,224$ Total Certification Pay (Maintenance) (Munis 515xx)4,476$ Total Holiday Worked Pay (Admin/FBO) (Munis 518xx)3,300$ Total Holiday Worked Pay (Operations) (Munis 518xx)26,000$ Total Holiday Worked Pay (Maintenance) (Munis 518xx)12,500$ Shift Differential (Admin/FBO) (Munis 514xx)3,500$ Shift Differential (Operations) (Munis 514xx)15,000$ Shift Differential (Maintenance)(Munis 514xx)4,000$ Overtime (enter onMunis 513xx)20,000$ Overtime Operations (enter on Munis 513xx)85,000$ Overtime Maintenance (enter on Munis 513xx)45,000$ Overtime Seasonal (enter onMunis 513xx)16,000$ Contractual Obligation‐$ Promotional Increase‐$ Subtotal3,306,200$ Medicare (enter onMunis 51961)47,900$ Health Insurance764,500$ BCRS Retirement617,365$ Total4,735,965$ 15 **********************Issue Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsPurposeDate FY2017 FY2018 FY2019 FY2020 FY2021 FY2022 FY2023 FY2024 FY2025 FY2026 FY2027AIRPORT ENTERPRISEIMPROVEMENTS AND PROTECTION 2/15/2008 77,438 TERMINAL2/25/2011 300,569 301,669 301,944 297,744 302,144 299,644 301,894 300,294 298,494 301,494 298,863 PARKING LOT2/25/2011 44,406 43,506 42,456 46,556 45,156 43,406 46,656 45,056 43,456 46,856 REMODEL OF HANGARS6/7/2012 13,550 13,050 7,675 7,450 7,225 6,975 6,725 6,475 6,225 6,025 5,875 RAZE & REMOVE ANNEX6/7/2012 23,175 22,425 21,675 21,000 20,325 19,575 18,825 18,075 12,450 12,050 11,750 LANDSCAPE FENCE6/7/2012 24,188 23,438 22,688 22,013 21,338 20,588 19,838 19,088 18,338 17,738 17,288 ADMINISTRATION BUILDING6/7/2012 122,625 118,875 115,125 111,750 108,375 104,625 100,875 97,125 93,375 90,375 88,125 RAMP LIGHTS6/7/2012 32,700 31,700 30,700 29,800 28,900 27,900 26,900 25,900 24,900 24,100 23,500 RAMP ELECTRIFICATION6/7/2012 15,400 14,900 14,400 13,950 13,500 13,000 12,500 12,000 11,500 11,100 5,875 PARKING LOT6/6/201344,600 38,850 38,150 37,450 36,750 36,050 35,350 RW 336/6/2013 11,300 11,100 10,900 10,700 10,500 10,300 10,100 RAMP6/6/2013 44,700 43,900 38,150 37,450 36,750 36,050 35,350 RUNWAY6/6/2013 50,850 49,950 49,050 48,150 47,250 46,350 45,450 ADMINISTRATION BUILDING6/5/2014 230,100 227,100 224,100 219,600 215,100 210,600 206,100 201,600 197,100 192,600 188,100 RUNWAY RESURFACING6/5/2014 5,200 5,100 AIRPORT VEHICLES 16/5/2014 96,300 94,500 92,700 AIRPORT VEHICLES 26/5/201437,200 31,500 30,900 TAXIWAY DELTA WIDENING6/5/2014 5,200 5,100 ENVIRONMENTAL STEWARDSHIP10/22/2015 44,811 37,625 36,575 35,525 ‐ AIR VEHCLE REPLACE 144K 11'16 I11/9/2016‐ 54,658 52,300 45,900 ‐ ‐ ‐ ‐ ‐ ‐ ‐ AIR LOADER 58K 11'16 I11/9/2016‐ 16,224 11,600 11,300 6,050 5,875 5,625 5,375 5,125 ‐ ‐ TOTAL AIRPORT FUND1,224,311 1,185,170 1,141,088 996,338 899,363 880,938 872,188 730,988 710,963 702,338 639,375 16 **************************Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments Payments PaymentsFY2028 FY2029 FY2030 FY2031 FY2032 FY2033 FY2034 FY2035 FY2036 FY2037 FY2038 FY2039 FY2040300,788 302,038 302,588 297,688 302,281 301,181 299,306 301,956 298,894 5,725 5,572 5,416 5,253 5,084 11,450 11,144 10,831 10,506 10,169 16,838 16,378 15,909 15,422 5,084 85,875 83,578 81,234 78,797 76,266 22,900 22,288 21,663 21,013 20,338 5,725 5,572 5,416 5,253 5,084 183,600 179,100 174,600 170,100 165,075 160,050 155,025 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 632,900 625,669 617,656 604,031 589,381 461,231 454,331 301,956 298,894 ‐ ‐ ‐ ‐ 17