Loading...
Section XII - Enterprise Funds - AirportFY2018 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