Loading...
HomeMy WebLinkAbout11-17-2016 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, NOVEMBER 17, 2016 - 6:00 P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: 2 min* October 20, 2016 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion / Action: a. Airport Master Plan 5 min i. Consider a resolution accepting work as complete b. FAA/IDOT Projects: AECOM / David Hughes 10 min i. Obstruction Mitigation ii. South Taxiway Extension iii. North T-Hangar Restroom iv. FY2018 FAA AIP Pre -Application c. Airport "Operations" 20 min i. Strategic Plan -Implementation 1. Aircraft Traffic Count collection 2. 2018 — 100 anniversary committee ii. Budget 1. FY2018 Budget Submittal iii. Management d. FBO / Flight Training Reports 20 min i. Jet Air e. Commission Members' Reports 2 min f. Staff Report 2 min 5. Set next regular meeting for December 15, 2016 at 6:00 p.m. 6. Adjourn *The times listed in the agenda are the anticipated duration of that particular agenda item. The actual discussion may take more or less time than anticipated Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 2 of 70 October 20, 2016 Page 1 MINUTES DRAFT IOWA CITY AIRPORT COMMISSION OCTOBER 20, 2016 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Julie Bockenstedt, Minnetta Gardinier, A. Jacob Odgaard, Chris Ogren Members Absent: Robert Libby Staff Present: Michael Tharp, Eric Goers Others Present: Matt Wolford, Carl Byers, David Hughes RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM: Chairperson Odgaard called the meeting to order at 6:02 P.M. APPROVAL OF MINUTES: Minutes of the September 15, 2016, meeting were reviewed. Ogren moved to accept the minutes of the September 15, 2016, meeting as presented. Odgaard seconded the motion. The motion carried 3-0, Bockenstedt abstained and Libby absent. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: a. Airport Master Plan — Tharp began the discussion, noting that the FAA has approved the Airport Master Plan. He stated that currently they are obtaining signatures that are needed to make this official and now things can move forward. Odgaard asked if Tharp could speak to those items that are now set in motion with the approval of the Master Plan. Tharp responded, stating that once the plan is released publicly, things that will change include the category of the Airport runways, landing distance available, and the accelerated start and stop distance on runway 7, not on 25 though. He added that this needs physical work before it can be changed. Another thing that will occur is what the Commission wants to do with the obstruction mitigation and the displaced threshold on runway 12-30. Basically the newly adopted Master Plan will allow these changes to occur. Tharp then responded to Member questions regarding these upcoming changes. Tharp then noted that typically they present newly adopted Master Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 3 of 70 October 20, 2016 Page 2 Plans to the City Council, and he stated that he has met with the City Manager's office in regards to this. The goal is to have the plan presented at the November 15 meeting. This would be a joint meeting of the Airport Commission and the City Council. b. FAA/IDOT Projects: AECOM / David Hughes - i. Obstruction Mitigation — Hughes addressed the Commission next, stating that he printed out the obstructions that came out of the Master Plan study. He noted that now it has to go through the environmental assessment process. The next step will be to go back to the FAA to see what they want this assessment report to contain. Tharp added that now that the Master Plan update is done, they know where the displaced threshold is going to be. There are approximately 15 trees, or objects, on the north, and approximately 25 on the south. Tharp then responded to Member questions regarding funding. ii. FY16 Apron Expansion — Hughes stated that all of the punchlist items are done. The recommendation is to accept the work as complete on this project. Hughes added that this project did come in slightly under the contract award amount. 1. Consider a resolution accepting work as complete — Ogren moved to consider Resolution #A16-26, accepting work as complete on the FY16 apron expansion. Gardinier seconded the motion. The motion carried 4-0, Libby absent. iii. South Taxiway Extension — Tharp stated that this is the task order for the design and construction monitoring services for the south taxiway extension. This is the extension that was agreed to when the ground lease was agreed to with Jet Air. 1. Consider a resolution approving task order with AECOM — Gardinier moved to consider Resolution #A16-27, approving the task order #5 with AECOM for this project. Ogren seconded the motion. The motion carried 4-0, Libby absent. iv. North T-Hanger Restroom — Tharp then spoke to the restroom project. He stated that when they put the initial budget together for this, they were anticipating just a single facility. Grant funding was sought and secured for this, and the task order prep began. Once this part began, it became apparent that two facilities would be needed, based on the code. Hughes added that they did confirm this and they do need 'male' and 'female' facilities. This led to a discussion by the Commission, with Tharp and Hughes responding to concerns. Members agreed that they should pursue the variance option before moving forward with this project. V. FY2018 FAA AIP Pre -Application — Tharp stated that each year they do an application packet for federal FAA funding. This is then sent to the State, who then gives a priority list to the FAA. He noted that he gave Members a copy of last year's application packet. Tharp stated that he wants to propose to the FAA that they also do the runway remarking for 12-30, and the work on 7-25, in the first year of funding. Ogren noted that on page 23 of last year's application, she thought she saw a mistake and she brought this up for Tharp's response. C. Airport "Operations" — Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 4 of 70 October 20, 2016 Page 3 i. Strategic Plan -Implementation — Tharp stated that he does not have anything new to add here at this time. ii. Budget — Tharp started on page 29, noting that the budget subcommittee met recently. He spoke to where they are at this point in the process, noting that the City is expecting a zero -growth budget for the upcoming fiscal year. This means the Airport budget is asking for $116,000, with the $16,000 for operational support and the $100,000 for capital improvement funding. Continuing, Tharp further clarified the budget items being proposed. Some discussion centered around the proposed anniversary celebration and whether the City would cover any of those expenses. Tharp then responded to Member questions regarding the proposed budget. Members had a fairly lengthy discussion about numbers — referring to the number of flights that come into the Airport, how much fuel is purchased, etc., and how they might keep better track of this. Members agreed that this objective should be seen as important, as far as keeping track of the numbers. Gardinier noted that there is a $100,000 budget surplus being shown and Tharp stated that he believes this isn't showing any of the capital transfers. He added that when he did this he did not have the grant matching money in the expenses item. Members briefly discussed this, noting that it might be a good idea to correct this, since the public and the City would be seeing the amount there. 1. FY2018 Budget Submittal Motion to approve submittal — Odgaard moved to approve submittal of the FY18 budget as discussed. Ogren seconded the motion. The motion carried 4-0, Libby absent. iii. Management — None. d. FBO / Flight Training Reports — i. Jet Air — Matt Wolford with Jet Air spoke next. He shared the monthly maintenance reports with Members, noting that in September they worked on mowing and grass removal, light bulb replacements, and changed out the AV gas self-service filter. He also noted that lightening took out some of the runway lights during a recent storm. For October, Wolford noted some of the maintenance items that were addressed. Speaking to Jet Air's business, Wolford stated that things have slowed down somewhat, but that they are still keeping everyone busy. He also spoke to an upcoming conference in Orlando that Jet Air will be attending. e. Commission Members' Reports — Ogren stated that she liked the invitation to the celebration of the building but that she is scheduled to be out of town then. Members briefly discussed this and who else should be invited to attend. Staff report— None. SET NEXT REGULAR MEETING FOR: The next regular meeting of the Airport Commission will be held on Thursday, November 17, 2016, at 6:00 P.M. in the Airport Terminal Building. Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 5 of 70 October 20, 2016 Page 4 ADJOURN: Ogren moved to adjourn the meeting at 7:47 P.M. Odgaard seconded the motion. The motion carried 4-0, Libby absent. CHAIRPERSON DATE Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 6 of 70 October 20, 2016 Page 5 Airport Commission ATTENDANCE RECORD 2016 TERM o O O O O O O O O O O N N W A 0 O V co co w O NAME EXP. 3 N m 3 co 3 N m N o m M m 0) m 0) m m a) a)M m 0) m 0) m 0) m 0) m Minnetta 031011 X X X X X X 0/ X X X X X Gardinier 79 E Jose 031011 X O/E X N N N N N N N N N N N Assouline 76 M M M M M M M M M M M Chris Ogren 031011 X X X X X O/ X X X O/ X X 18 E E A.Jacob 031011 X X X X X O/ X X X X X X Odgaard 78 E Julie 031011 X X X X O/ X X X O/ X O/ X Bockenstedt 17 E E E Robert Libby 031211 N NM NM N X X X X O/ X X O/ 20 M M E E Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time Airport Commission Agenda & Info Packet G11MADIOT Meeting Date: 11-17-16 Fonn 291111wJ (10-16) Page 7 of 70 Iowa City Municipal Airport Airport FEDERAL AIRPORT IMPROVEMENT PROGRAM (AIP) PRE -APPLICATION FFY 2018 CHECKLIST Please attach the following documents with your application: 3-19-0047 y_A_\CCTiti iffm ® Sponsor Identification Sheet for the Airport ® CIP Data Sheet (one for each project listed in the first 3 years of the CIP) and detailed cost estimate for each data sheet. ® 5-year Capital Improvement Program (CIP) ® Long Range Needs Assessment ❑ Verification of an updated ALP (when applying for new construction of buildings or airfield expansion) ❑ Verification of completed environmental processing in accordance with NEPA. ❑ Verification of completed land acquisition or signed purchase agreement. ❑ Verification of pavement maintenance program (when applying for pavement preservation or reconstruction) ® If requesting Federal assistance for snow removal equipment, please include an inventory of the existing equipment and calculations based on Chapters 4 & 5 of the Airport Winter Safety and Operations, Advisory Circular (AC) 150/5200-30 and the Airport Snow and Ice Control Equipment, AC 150/5220-20 showing the minimum equipment needed, along with the ACIP Data Sheet. Include a copy of a completed FAA Snow Plow Design Spreadsheet. ❑ If requesting Federal assistance for general aviation apron expansion, include a copy of a completed GA Apron Design spreadsheet. ❑ If requesting pavement reconstruction, submit an engineering report showing the need for the reconstruction as part of the CIP justification. ❑ For revenue -producing facilities (i.e., fueling facilities and hangars), please submit: 1) a statement that airside development needs are met or include a financial plan to fund airside needs over the next 3 years; 2) a statement that runway approach surfaces are clear of obstructions (the FAA Airport 5010 should show at least a 20:1 clear approach), and; 3) justification for the project. ® SAM (System for Award Management) registration is up-to-date. (www.sam.gov) Please scan and e-mail with support documents identified in checklist to shane.wright@dot.iowa.gov. Iowa Department of Transportation Office of Aviation 800 Lincoln Way Ames, IA 50010 Attn.: Program Manager E-mail: shane.wright@dot.iowa.gov FAX:515-233-7983 515-239-1048 www.iowadot.gov/aviation Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 8 of 70 4P10 IAWr Form 291111wd (10-16) FEDERAL AIRPORT IMPROVEMENT PROGRAM (AIP) U:7:ffe1»4[•7MAIIs] 010a Wlf III AIRPORT SPONSOR IDENTIFICATION AI rpo rt Name: Iowa City Municipal Airport Airport Sponsor Name: City of Iowa City, Iowa Contact Person: Mr. Jacob Odgaard Title Complete Mailing Address: 1801 S. Riverside Drive Iowa CRY IA 52246 State ZIP Code E-mail Address: jacob-odgaard(dmowa.edu U.S. Congressional District Number: Second Commission Chair Daytime Phone: FAX Number: 19)356-5045 19)351-1290 Please scan and e-mail with support documents identified in checklist to shane-wright@dot-iowa-gov- Iowa Department of Transportation Office of Aviation 800 Lincoln Way Ames, IA 50010 Attn-: Program Manager E-mail: shane-wright@dot-iowa-gov FAX 515-233-7983 515-239-1048 www.iowadot.gov/aviation Airpoep ri7l,4r$e1ng4g&ket Page 9 of 70 • Iowa City Municipal Airport SIG]IBM IOw N10I• 1 • Runway 12.30 Approach Surface Obstruction Mitigation - 2018 • • Environment Assessment Study • - SKETCH JUSTIFICATION: Removal of obstructions identified in the 2016 Master Plan associated with the FAR Part 77 and Approach Surfaces for Runway 12/30 and Runway 7/25. The first phase of the obstruction mitigation is the Environmental Assessment Study. COST ESTIMATE: (Attach detailed cost estimate) Federal(90%) $ 135,000 State $0 Local (10%) $ 15,000 Total $ 150,000 SPONSOR'S VERIFICATION: Date (see instruction sheet or point mouse over each date box for more information) For each and every project 11 ni2016 - Date of approved ALP with project shown as applicable - Date of environmental determination (ROD, FONSI, CE), or cite CE paragraph # (307-312) in Order 1050.1E - Date of land acquisition or signed purchase agreement 1112004 - Date of pavement maintenance program FAA USE ONLY • • - - Snow removal equipment inventory & sizing worksheet (for SIRE acquisition) - Apron sizing worksheet (for apron projects) Revenue producing facilities (for fuel farms, hangers, etc.) - Date statement submitted for completed airside development - Date statement submitted for runway approaches are clear of obstructions SPONSOR'S SIGNATURE: DATE: DRAFT PRINTED NAME: Jacob Odaaard TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 Ai rpoegri7i,s i9�$e'a,8� Ip fq,Pcket �,� t 4 gt Page 10 of 70 AIRPORT Iowa City Municipal• • LOCID LOCAL PRIORITY PROJECT Runway 25 Threshold Relocation Identify IFFYthat you co DESCRIPTIO desire to construct N IFFY: Oct. 1-Sept. 301 SKETCH r•'- i i i a i i • i JUSTIFICATION: An 808 foot displaced threshold is no longer necessary on the Runway 25 end due to the change in critical design aircraft. Therefore this project shifts the runway threshold to gain an additional 700 feet of takeoff and landing distance for pilots using Runway 25. COST ESTIMATE: (Attach detailed cost estimate) Federal(90%) $ 279,000 State $0 Local (10%) $ 31,000 Total $ 310,000 SPONSOR'S VERIFICATION: Date For each and every project 11I7I20' as applicable 1112004 SPONSOR'S SIGNATURE: or porn[ mouse over more - Date of environmental determination (ROD, FONSI, CE), or cite CE paragraph # (307-312) in Order 1050.1E - Date of land acquisition or signed purchase agreement - Date of pavement maintenance program - Snow removal equipment inventory & sizing worksheet (for SRE acquisition) - Apron sizing worksheet (for apron projects) Revenue producing facilities (for fuel farms, hangers, etc.) - Date statement submitted for completed airside development - Date statement submitted for runway approaches are clear of obstructions DATE: DRAFT PRINTED NAME: Jacob Odaaard TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 11 of 70 Iowa City Municipal Airport ACIP Data Sheet Cost Estimate Runway 25 Threshold Relocation November 7, 2016 Item Unit Quantity Unit Price Total Moblization LSUM 1 $ 26,300.00 $ 26,300.00 Relocate PAPI EACH 1 $ 75,000.00 $ 75,000.00 Flight Check EACH 1 $ 15,000.00 $ 15,000.00 Pavement Markings SFT 88,000 $ 125 $ 110,000.00 Taxiway Light Removal EACH 8 $ 75.00 $ 600.00 Runwav Licht Removal EACH 8 $ 75.00 $ 600.00 Runway Light EACH 16 $ 1,200.00 $ 19,200.00 Conduit SFT 1,700 $ 6.00 $ 10,200.00 Wiring LFT 3,400 $ 1.50 $ 5,150.00 Engineering, Legal, Administration $ 48,000.00 TOTAL $ 310,000.00 Airpoep ri7l,4r$e1ng4g&ket Page 12 of 70 • Iowa City Municipal Airport sisillm IOW N10I• 3 • Runway 12.30 Approach Surface Obstruction Mitigation - Property 2019 • • Easements and Acquistion Process • - SKETCH JUSTIFICATION: Removal of obstructions identified in the 2016 Master Plan associated with the FAR Part 77 and Approach Surfaces for Runway 12/30 and Runway 7/25. The second phase of the obstruction mitigation is the coordination/ negotiation with property owners for access easements and aviatigation easements. COST ESTIMATE: (Attach detailed cost estimate) Federal(90%) $ 170,100 State $0 Local (10%) $ 18,900 Total $ 189,000 SPONSOR'S VERIFICATION: Date (see instruction sheet or point mouse over each date box for more information) For each and every project 11 ni2016 - Date of approved ALP with project shown as applicable - Date of environmental determination (ROD, FONSI, CE), or cite CE paragraph # (307-312) in Order 1050.1E - Date of land acquisition or signed purchase agreement 1112004 - Date of pavement maintenance program FAA USE ONLY • • - - Snow removal equipment inventory & sizing worksheet (for SIRE acquisition) - Apron sizing worksheet (for apron projects) Revenue producing facilities (for fuel farms, hangers, etc.) - Date statement submitted for completed airside development - Date statement submitted for runway approaches are clear of obstructions SPONSOR'S SIGNATURE: DATE: DRAFT PRINTED NAME: Jacob Odaaard TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 13 of 70 Iowa City Municipal Airport ACIP Data Sheet Cost Estimate Obstruction Mitigation November 7. 2016 Item Unit Quantity Unit Price Total Access Easement EA 20 $ 4,500 $ 90,000 Avigation Easement EA 20 $ 1,200 $ 24,000 Property Agent, Legal, Administration LS 1 $ 75,000 $ 75,000 $189,000 Airpoep ri7i,4$e1ng4g&ket Page 14 of 70 • Iowa City Municipal Airport sisillm IOW N10I• 4 • Runway 12.30 Approach Surface Obstruction Mitigation - Property 2020 • • Easements and Acquistion Process • - SKETCH JUSTIFICATION: Removal of obstructions identified in the 2016 Master Plan associated with the FAR Part 77 and Approach Surfaces for Runway 12/30 and Runway 7/25. COST ESTIMATE: (Attach detailed cost estimate) Federal(90%) $ 234,000 State $0 Local (10%) $ 26,000 Total $ 260,000 SPONSOR'S VERIFICATION For each and every project as applicable 1_1_10R] =1101 2 I Wil Date (see Instruction sheet or point mouse over each date box Tor more Information) 11/7i2016 - Date of approved ALP with project shown - Date of environmental determination (ROD, FONSI, CE), or cite CE paragraph # (307-312) in Order 1050.1E - Date of land acquisition or signed purchase agreement 1112004 - Date of pavement maintenance program - Snow removal equipment inventory & sizing worksheet (for SIRE acquisition) - Apron sizing worksheet (for apron projects) - Revenue producing facilities (for fuel farms, hangers, etc.) - Date statement submitted for completed airside development - rlafa cfafamanf cnhmiffarl fnr ninu.au annrnachac ara claar of nhcfnicfinnc DATE: DRAFT PRINTED NAME: Jacob Odpaard TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 15 of 70 Iowa City Municipal Airport ACIP Data Sheet Cost Estimate Obstruction Mitigation November 7. 2016 Item Unit I Quantity I Unit Price I Total Tree Removal EA 1 35 1 $ 5,000 $ 175,000 Obstruction Lighting EA 5 $ 10,000 $ 50,000 Engineering, Legal, Administration LS 1 $ 35,000 $ 35,000 $260,000 Airpoep ri7l,4r$e1ng4g&ket Page 16 of 70 AIRPORT Iowa City Municipal• • LOCID � LOCAL PRIORITY PROJECT Runway 12 Threshold ■ Identify IFFYthat you DESCRIPTIO - co desire to construct N IFFY: Oct. 1-Sept. 301 SKETCH �w !0lctIIJI _TAINLF The Airport Master Plan completed in 2016 identified a threshold displacement on Runway 12 of 500 feet to minimize the number of potential obstructions to the Runway 12 Approach. The plan mitigated the impacts to the Runway 12/30 runway length by adding length to the Runway 30 end that is avaliable for takeoff but not landings. COST ESTIMATE: (Attach detailed cost estimate) Federal(90%) $ 356,400 State $0 Local (10%) $ 39,600 Total $ 396,000 SPONSOR'S VERIFICATION: Date (see instruction sheet or point mouse over each date box for more information) For each and every project 1117/2016 - Date of approved ALP with project shown as applicable - Date of environmental determination (ROD, FONSI, CE), or cite CE paragraph # (307-312) in Order 1050.1E - Date of land acquisition or signed purchase agreement 1112004 - Date of pavement maintenance program - Snow removal equipment inventory & sizing worksheet (for SRE acquisition) FAA USE ONLY • •- - Apron sizing worksheet (for apron projects) Revenue producing facilities (for fuel farms, hangers, etc.) - Date statement submitted for completed airside development - Date statement submitted for runway approaches are clear of obstructions SPONSOR'S SIGNATURE: DATE: DRAFT PRINTED NAME: Jacob Odpaard TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 17 of 70 Iowa City Municipal Airport ACIP Data Sheet Cost Estimate Runway 30 Threshold Relocation - Runway 12 Threshold Displacement November 7, 2016 Item Unit Quantity Unit Price Total Moblization LSUM 1 $ 30,440.00 $ 30,440.00 PCC Pavement, 6" SYD 2,500 $ 60.00 $ 150,000.00 Aggregate, 6" CYD 600 $ 35.00 $ 21,000.00 Subdrain LF 600 $ 1200. $ 7,200.00 Catch Basins EACH 2 $ 4,750.00 $ 9,500.00 Storm Sewer LF 200 $ 50.00 $ 10,000.00 Pavement Markings SFT 12,000 $ 2.00 $ 24,000.00 Excavation CYD 2,500 $ 10.00 $ 25,000.00 Runway Lighting EACH 20 $ 1,600.00 $ 32,000.00 Conduit LIFT 700 $ 6.00 $ 4,200.00 Wiring LIFT 1,000 $ 1.50 $ 1,500.00 Seeding ACRE 5 $ 4,000.00 $ 20,000.00 Engineering, Legal, Administration $ 61,160.00 111011 f_l 1111 Ai rpoegri7i,s i9�$e'a,8� Ip fq,Pcket �,� t 4 gt Page 18 of 70 AIRPORT Iowa City Municipal• • LOCID LOCAL PRIORITY PROJECT Airfield Pavement Maintenance Identify IFFYthat you co DESCRIPTIO desire to construct N IFFY: Oct. 1-Sept. 301 SKETCH JUSTIFICATION: The existing eastern section of Runway 7/25 was reconstructed in 2008. Many of the pavement joints are in need of replacement and resealing. There is also some corner spalling of concrete panels and corner breaks. In order to achieve a long life of any pavement continuous maintenace is required COST ESTIMATE: (Attach detailed cost estimate) Federal(90%) S 284.580 State $0 Local (10%u) S 31.620 Total $ 316.200 SPONSOR'S VERIFICATION: Date For each and every project 11I7I2016 as applicable FAA USE ONLY 1 11f2004 SPONSOR'S SIGNATURE: instruction sheet or point mouse over each date box for more - Date of approved ALP with project shown - Date of environmental determination (ROD, FONSI, CE), or cite CE paragraph # (307-312) in Order 1050.1E - Date of land acquisition or signed purchase agreement - Date of pavement maintenance program - Snow removal equipment inventory & sizing worksheet (for SRE acquisition) - Apron sizing worksheet (for apron projects) Revenue producing facilities (for fuel farms, hangers, etc.) - Date statement submitted for completed airside development - Date statement submitted for runway approaches are clear of obstructions DATE: DRAFT PRINTED NAME: Jacob Odpaard TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 19 of 70 Airfield Pavement Maintenance Iowa City Municipal Airport Iowa City, Iowa November 7, 2016 Item Unit Quantity Unit Price Total Mobilization LS 1 $ 18,000.00 $ 18,000 PCC Pavement, 8" SYD 200 $ 70.00 $ 14,000 Aggregate, 6" CYD 40 $ 30.00 $ 1,200 Pavement Removal SYD 200 $ 25.00 $ 5,000 Reseal Pavement Joints LF 75,000 $ 3.00 $ 225,000 Admin, Legal, Engineering LS $ 53,000 TOTAL $ 316,200 OPKM IiN11JT Forth 291112 (10-16) AirportName: Iowa City Municipal Airport Prepared By: AECOM Date Prepared: 11/07/16 Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 FIVE-YEAR AIRPORT CAPITAL IMPROVEMENT PROGRAM (CIP) Telephone: 319-356-5045 Page 20 of 70 E-mail Address: jacob-odgaard@uiowa.edu Date Approved: DRAFT Project Description Funding FY 2018 FY 2019 FY 2020 FY 2022 Source Obstruction Mitigation - Environmental Federal $ 135,000 $ $ 7$$ $ Assessment State $ $ $ $ Local $ 15,000 $ $ $ Total $ 150,000 $ $ $ Runway 25 Threshold Relocation Federal $ 279,000 $ $ $ $ State $ $ $ $ $ Local $ 31,000 $ $ $ $ Total $ 310,000 $ $ $ $ Obstruction Mitigation - Easement and Federal $ $ 170,100 $ $ $ Property Acquisitions State $ $ $ $ $ Local $ $ 18,900 $ $ $ Total $ $ 189,000 $ $ $ Airfield Obstruction Mitigation Federal $ $ $ 234,000 $ $ State $ $ $ $ $ Local $ $ $ 26,000 $ $ Total $ $ $ 260,000 $ $ Runway 12 Threshold Displacement - Federal $ $ $ $ 356,400 $ Runway 30 Threshold Relocation State $ $ $ $ $ Local $ $ $ $ 39,600 $ Total $ $ $ $ 396,000 $ Airfield Pavement Maintenance Federal $ $ $ $ $ 284,580 State $ $ $ $ $ Local $ $ $ $ $ 31,620 Total $ $ $ $ $ 316,200 (P/���� Airport Commission Agenda & Info Packet IOWADW Meeting Date: 11-17-16 Form 291113 (10-16) AIRPORT LONG RANGE NEEDS ASSESSMENT FFY 2023 — FFY 2027 AirportName: Iowa City Municipal Airport Page 21 of 70 Description of Project Funding Total (include estimated Fiscal Year) Source Estimated Cost Terminal Apron Expansion (2023) Federal: 1,125,000 $ 1,125,000 State: $ Local: 125,000 $ 125,000 Total: 1,250,000 $ 1,250,000 Pavement Maintenance- Runway 7/25 West & Runway 12/30 (2024) Federal: 337,500 $ 337,500 State: $ Local: 37,500 $ 37,500 Total: 375,000 $ 375,000 Taxilane Construction (2025) Federal: 211,500 $ 211,500 State: $ Local: 23,500 $ 23,500 Total: 235,000 $ 235,000 Environment Assessment (2026) Federal: 135,000 $ 135,000 State: $ Local: 15,000 $ 15,000 Total: 150,000 $ 150,000 Vehicle Parking in Terminal Area (2027) Federal: 540,000 $ 540,000 State: $ Local: 60,000 $ 60,000 Total: 600,000 $ 600,000 Federal: $ State: $ Local: $ Total: $ Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 22 of 70 AIRPORT COOPERATIVE RESEARCH PROGRAM 7���`ACRP REPORT 129 Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports Maria J. Moia W OOLPERT. INC. Indianapolis, IN Mary E. Johnson PURDUE UNIVERSITY West Lafayette, IN Subject Cuteguries Aviation • Planning and Forecasting Research sponsored by the Federal Aviation Administration TRANSPORTATION RESEARCH BOARD WASHINGTON, D.C. 2015 www.TRB.org Copyright National Academy of Sciences. All rights reserved. Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 AIRPORT COOPERATIVE RESEARCH PROGRAM ACRP REPORT 129 Page 23 of 70 Airports are vital national resources. They serve a key role in trans- portation of people and goods and in regional, national, and inter- national commerce. They are where the nation's aviation system connects with other modes of transportation and where federal respon- sibility for managing and regulating air traffic operations intersects with the role of state and local governments that own and operate most airports. Research is necessary to solve common operating problems, to adapt appropriate new technologies from other industries, and to introduce innovations into the airport industry. The Airport Coopera- tive Research program (ACRP) serves as one of the principal means by which the airport industry can develop innovative near -term solutions to meet demands placed on it. The need for ACRP was identified in TRB Special Report272: Airport Research Needs: Cooperative Solutions in 2003, based on a study spon- sored by the Federal Aviation Administration (FAA). The ACRP carries out applied research on problems that are shared by airport operating agencies and are not being adequately addressed by existing federal research programs. It is modeled after the successful National Coopera- tive Highway Research program and Transit Cooperative Research Pro- gram The ACRP undertakes research and other technical activities in a variety of airport subject areas, including design, construction, mainte- nance, operations, safety, security, policy, planning, human resources, and administration. The ACRP provides a forum where airport opera- tors can cooperatively address common operational problems. The ACRP was authorized in December 2003 as part of the Vision 100-Century ofAviation Reauthorization Act. The primaryparticipants in the ACRP are (1) an independent governing board, the ACRP Oversight Committee (ACC), appointed by the Secretary of the U.S. Department of Transportation with representation from airport operating agencies, other stakeholders, and relevant industry organizations such as the Airports Council International -North America (ACI-NA), the American Associa- tion of Airport Executives (AAAE), the National Association of State Aviation Officials (NASAO), Airlines for America (A4A), and the Airport Consultants Coined (ACC) as vital links to the airport community; (2) the TRB as program manager and secretariat for the governing board; and (3) the FAA as program sponsor. In October 2005, the FAA executed a contract with the National Academies formally initiating the program The ACRP benefits from the cooperation and participation of airport professionals, air carriers, shippers, state and local government officials, equipment and service suppliers, other airport users, and research orga- nizations. Each of these participants has different interests and respon- sibilities, and each is an integral part of this cooperative research effort. Research problem statements for the ACRP are solicited periodically but may be submitted to the TRB by anyone at any time. It is the responsibility of the AOC to formulate the research program by iden- tifying the highest priority projects and defining funding levels and expected products. Once selected, each ACRP project is assigned to an expert panel, appointed by the TRB. panels include experienced practitioners and research specialists; heavy emphasis is placed on including airport pro- fessionals, the intended users of the research products. The panels pre- pare project statements (requests for proposals), select contractors, and provide technical guidance and counsel throughout the life of the project. The process for developing research problem statements and selecting research agencies has been used by TRB in managing cooper- ative research programs since 1962. As in other TRB activities, ACRP project panels serve voluntarily without compensation. primary emphasis is placed on disseminating ACRP results to the intended end -users of the research: airport operating agencies, service providers, and suppliers. The ACRP produces a series of research reports for use by airport operators, local agencies, the FAA, and other interested parties, and industry associations may arrange for work- shops, training aids, field visits, and other activities to ensure that results are implemented by airport -industry practitioners. Project 03-27 ISSN 1935-9802 ISBN 978-0-309-30843-4 Library of Congress Control Number 2015932786 (0 2015 National Academy of Sciences. All rights reserved. COPYRIGHT INFORMATION Authors herein are responsible fur the authenticity of their materials and for obtaining written permissions from publishers car persons who own the copyright In any previouJy published car cepyrighted material used herein. Cooperative Research Programs (CRP) grants permission In reproduce material in this publication her dasanmm and noI-for-pm6t purposes. Permission is given with the understanding that none of the material will he used In imply'1'RB car FAA endorsement of a particular product, method, car practice. It is espected that those reproducing the material in this document her educational and and-Cnr-profit uses will give appropriate acknowledgment of the source of any reprinted or reproduced material. For other uses of the material, request permission from Cup. NOTICE The project that is the subject oflhis report was a par[ of the Airpnrt Cooperative Research Prognnm, conducted by the'1'runsportation Research hoard with the approval of the Governing Board of the National Research Council. The members of the technical panel selected In monitor this project and In review this report were chosen for their special competencies and with regard her appropriate balance. The rein[ was reviewed by the technical panel and accepted h,r publication according In procedures established and overseen by the'1'rarepor taboo Research Board and approved by the Governing Board of the National Research Council. The opinions and conclusions enpressed or implied in this report are those of the archers who performed the research and are not necessarily those of the'l emain rtaticar Research Board, the National Research Council, or the program sponsors. 'I he'1'ransporta than Research Board of the National Academies, the National Research Council, and the sponsors of the Airport Cooperative Research Program do nor endorse products car manufacturers. 'I race car manufacturer.' names appear herein solely because they are considered essential In the object of the repnrt Published wperts of the AIRPORT COOPERATIVE RESEARCH PROGRAM are available from. 'I muspentation Research Board Business Office 500 Fifth Street, NW Washington, DC 20MI and am be ordered through the Internet at hilpd/www.na[ional-academics.org/ trb/books Loco Printed in the United States MAa uim Copyright National Academy of Sciences. All rights reserved. Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 24 of 70 THE NATIONAL ACADEMIES Advisers to the Nation on Science, Engineering, and Medicine The National Academy of Sciences is a private, nonprofit, self-perpetuating society of distinguished scholars engaged in scientific and engineering research, dedicated to the furtherance of science and technology and to their use for the general welfare. Upon the authority of the charter granted to it by the Congress in 1863, the Academy has a mandate that requires it to advise the federal government on scientific and technical matters. Dr. Ralph J. Cicerone is president of the National Academy of Sciences. The National Academy of Engineering was established in 1964, under the charter of the National Academy of Sciences, as a parallel organization of outstanding engineers. It is autonomous in its administration and in the selection of its members, sharing with the National Academy of Sciences the responsibility for advising the federal government. The National Academy of Engineering also sponsors engineering programs aimed at meeting national needs, encourages education and research, and recognizes the superior achievements of engineers. Dr. C. D. Mote, Jr., is president of the National Academy of Engineering. The Institute of Medicine was established in 1970 by the National Academy of Sciences to secure the services of eminent members of appropriate professions in the examination of policy matters pertaining to the health of the public. The Institute ads under the responsibility given to the National Academy of Sciences by its congressional charter to be an adviser to the federal government and, upon its own initiative, to identify issues of medical care, research, and education. Dr. Victor J. Dzau is president of the Institute of Medicine. The National Research Council was organized by the National Academy of Sciences in 1916 to associate the broad community of science and technology with the Academy's purposes of furthering knowledge and advising the federal government. Functioning in accordance with general policies determined by the Academy, the Council has become the principal operating agency of both the National Academy of Sciences and the National Academy of Engineering in providing services to the government, the public, and the scientific and engineering communities. The Council is administered jointly by both Academies and the Institute of Medicine. Dr. Ralph J. Cicerone and Dr. C. D. Mote, Jr., are chair and vice chair, respectively, of the National Research Council. The Transportation Research Board is one of six major divisions of the National Research Council. The mission of the Transporta- tion Research Board is to provide leadership in transportation innovation and progress through research and information exchange, conducted within a setting that is objective, interdisciplinary, and multimodal. The Board's varied activities annually engage about 7,000 engineers, scientists, and other transportation researchers and practitioners from the public and private sectors and academia, all of whom contribute their expertise in the public interest. The program is supported by state transportation departments, federal agencies including the component administrations of the U.S. Department of Transportation, and other organizations and individu- als interested in the development of transportation. www.TRB.org www.national-academies.org Copyright National Academy of Sciences. All rights reserved. Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 25 of 70 COOPERATIVE RESEARCH PROGRAMS CRP STAFF FOR ACRP REPORT 129 Christopher W. Jenks, Director, Cooperative Research Programs Michael R. Salamone, ACRP Manager Joseph D. Navarrete, Senior Program Officer Terri Baker, Senior Program Assistant Eileen P. Delaney, Director of Publications Margaret B. Hagood, Editor ACRP PROJECT 03-27 PANEL Field of Policy and Planning Jack E. Thompson, Jr., C&S Companies, Orlando, FL (Chair) KerryL. Ahearn, Boulder City Airport, Boulder City, NV John J. Barker, City oftee's Summit Missouri, Lee's Summit, MO Peter D. Buchen, Minnesota DOT, Roseville, MN Richard Lamnan, Auburn -Lewiston Airport, Auburn, ME KayA. Thede, Clapsaddle-GarberAssociates, Inc, Ames, IA Tommy Dupree, FAA Liaison Richard A. Cunard, TRB Liaison AUTHOR ACKNOWLEDGMENTS The ACRP Project 03-27 research team was led by Woolpert, Inc. Subconsultants on this project were Purdue University's Aviation Technology Department and Hybrid-3, Inc. Maria J. Muia, Ph.D., senior aviation planner for Woolpert, Inc., was the project director and principal investigator. Mary E. Johnson, Ph.D., professor for Purdue University, was the authority on the statistical analysis. The aforementioned were contributing authors of the final report. Other individuals who contributed to the project through field testing, statistical analysis, surveying, and literature review were (listing here does not imply authorship of this document): Ryan McCroskey and Brad Cozza of Woolpert, Inc.; Joyce Brummett, Hybrid-3, Inc.; Anthony Erstad, Brian Dittman, Stewart W. Schreckengast, Jennifer Kirschner, Steven M. Leib, Scott R. Winter, Yue Liu, Denver Lopp, and Chien-tsung Lu of Purdue University; and Marcus Dial, Indiana Department of Transportation. The research team would like to thank the following airports for participating in this study: Indianapo- lis Executive Airport (TYQ); Purdue University Airport (LAE); Eagle Creek Airpark (EYE); and Paoli Municipal Airport (I42). Copyright National Academy of Sciences. All rights reserved. Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 26 of 70 FOREWORD By Joseph D. Navarrete Staff Officer Transportation Research Board ACRP Report 129. Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports provides a thorough review of techniques and technologies for estimating aircraft operations at airports without air traffic control towers. The report documents the indus- try's first comprehensive evaluation of the most common traffic estimation methods and is especially valuable to practitioners seeking to develop a statistically defensible estimate of aircraft activity for their non -towered airport. Aircraft operations counts are used as input for determining funding and design criteria at the nation's airports. They are also needed for developing the forecasts used to prepare airport master plans, aviation system plans, and environmental studies. Yet most airports don't have accurate activity records because they do not have an air traffic control tower, or because the tower does not operate 24 hours per day. Various techniques have therefore been used to obtain activity estimates at these facilities, including generic operations -per -based -aircraft ratios, guest logs, fuel sales, visual observation, automatic counters, acoustical counters, and video data capturing devices. However, no systematic review of these techniques has been undertaken. Research was needed to evaluate aircraft operations -counting estimation techniques and tech- nologies and to develop guidance to assist airport practitioners in selecting and using the most appropriate methods given available resources, accuracy requirements, and airport layout. The research, led by WoolpeM Inc., built on the results of ACRP Synthesis 4: Counting Aircraft Operations at Non -Towered Airports by reviewing recent literature and identifying new technologies. The research team then reached out to stakeholders to identify how oper- ations data are used, confirm the criteria practitioners consider when selecting a counting method, and determine the most common counting methods used by the industry. Next, a testing program was conducted to evaluate the accuracy of three methods, including: • Multiplying based aircraft by an estimated number of operations per based aircraft, • Applying a ratio of FAA flight plans to total operations, and • Expanding a sample count into an annual estimate through extrapolation. For the sampling method, the testing program also looked at the accuracy of different aircraft traffic counting technologies, including: • Automated acoustical counter, • Sound -level meter, • Security/trail cameras, and • Video image detection with a transponder receiver. Copyright National Academy of Sciences. All rights reserved. Evaluating Methods for Counting Aircraft Operations at Non -Towered Airports Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 27 of 70 The testing program involved installing counting systems at four airports for extended time periods to test their accuracy, reliability, and ease of use within the safety and opera- tional constraints typically found at airports. The research also evaluated sampling plans and methods of expanding samples to produce estimates of annual activity. The report summarizes the need for accurate aircraft operations counts and the chal- lenges to obtaining these counts at many airports. It describes the research approach used to identify, test, and evaluate various aircraft operations counting techniques. The report then presents the research findings and suggests areas for further research. The report includes appendices that provide statistical backup for the research effort, an example of estimating aircraft operations from sample counts, a copy of Statistical Sampling of Aircraft Operations at Non -Towered Airports (FAA-APO-85-7), and graphics illustrating where tested technolo- gies were placed at the study airports to help practitioners in positioning equipment at their facility. The research found that methods of estimating aircraft operations using ratios of based aircraft or instrument flight plans, while simple and inexpensive, could not be supported by the test results. Basing operations estimates on actual samples of activity produces results that are significantly more accurate and defensible, with the most accurate sampling approach based on four 2-week samples (i.e., one in each season). Finally, the research found that the selection of a counting technology needs to consider the airfield layout and fleet mix, among other factors. Copyright National Academy of Sciences. All rights reserved. Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 28 of 70 AIRPORT COOPERATIVE RESEARCH PROGRAM ACRP IS731W Counting Aircraft Operations at Non -Towered Airports A Synthesis of Airport Practice CONSULTANT MARIA J. MUTA Aerofinity, Inc. Indianapolis, Indiana SUBJECT AREAS Aviation Research Sponsored by the Federal Aviation Administration TRANSPORTATION RESEARCH BOARD WASHINGTON, D.C. 2007 w TRB.org Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 AIRPORT COOPERATIVE RESEARCH PROGRAM ACRP SYNTHESIS 4 Page 29 of 70 Airports are vital national resources. They serve a key role in transportation of people and goods and in regional, national, and international commerce. They are where the nation's aviation sys- tem connects with other modes of transportation and where federal responsibility for managing and regulating air traffic operations intersects with the role of state and local governments that own and operate most airports. Research is necessary to solve common oper- ating problems, to adapt appropriate new technologies from other industries, and to introduce innovations into the airport industry. The Airport Cooperative Research Program (ACRP) serves as one of the principal means by which the airport industry can develop innovative near term solutions to meet demands placed on it. The need for ACRP was identified in TRB Special Report 272.- Airport Research Needs: Cooperative Solutions in 2003, based on a study sponsored by the Federal Aviation Administration (FAA). The ACRP carries out applied research on problems that are shared by airport operating agencies and are not being adequately addressed by existing federal research programs. It is modeled after the successful National Cooperative Highway Research Program and Transit Cooperative Research Program. The ACRP undertakes research and other technical activities in a variety of airport subject areas, including design, construction, maintenance, operations, safety, Security, policy, planning, human resources, and adminis- tration. The ACRP provides a forum where airport operators can cooperatively address common operational problems. The ACRP was authorized in December 2003 as part of the Vision 100.Century of Aviation Reauthorization Act. The primary participants in the ACRP are (1) an independent governing board, the ACRP Oversight Committee (AOC), appointed by the Secretary of the U.S. Department of Transportation with representation from airport operating agencies, other stakeholders, and relevant indus- try organizations such as the Airports Council InternationalNorth America (ACI—NA), the American Association of Airport Execu- tives (AAAE), the National Association of State Aviation Officials (NASAO), and the Air Transport Association (ATA) as vital links to the airport community; (2) the TRB as program manager and see- retariat for the governing board; and (3) the FAA as program spon- sor. In October 2005, the FAA executed a contract with the National Academies formally initiating the program. The ACRP benefits from the cooperation and participation of air- port professionals, air carriers, shippers, state and local government officials, equipment and service suppliers, other airport users, and research organizations. Each of these participants has different interests and responsibilities, and each is an integral part of this cooperative research effort. Research problem statements for the ACRP are solicited period- ically but may be submitted to the TRB by anyone at any time. It is the responsibility of the AOC to formulate the research program by identifying the highest priority projects and defining funding levels and expected products. Onceselected, each ACRP project is assigned to an expert panel, appointed by the TRB. Panels include experienced practitioners and research specialists; heavy emphasis is placed on including airport professionals, the intended users of the research products. The panels prepare project statements (requests for proposals), select contractors, and provide technical guidance and counsel throughout the life of the project. The process for developing research problem statements and selecting research agencies has been used by TRB in managing coop- erative research programs since 1962. As in other TRB activities, ACRP project panels serve voluntarily without compensation. Primary emphasis is placed on disseminating ACRP results to the intended end -users of the research: airport operating agencies, Service providers, and suppliers. The ACRP produces a Series of research reports for use by airport operators, local agencies, the FAA, and other interested parties, and industry associations may arrange for work- shops, training aids, field visits, and other activities to ensure that results are implemented by airport industry practitioners. Project 11-03, Topic 10-01 ISSN 1935-9187 ISBN 978{1309-0979(f I Library of Congress Control Number 2007931659 0 2007 Transportation Research Board COPYRIGHT PERMISSION Authors herein are responsible for the authenticity of their materials and for obtaining written permissions from publishers or persons who own the copyright to any previously published or copyrighted material used herein. Cooperative Research Programs (CRP) grants permission to reproduce material in this publication for classroom and not -for -profit purposes. Permission is given with the understanding that none of the material will be used to imply TRB or FAA endorsement of a particularproduct, method, or practice. It is expected that those reproducing the material in this document for educational and not -for -profit uses will give appropriate acknowledgment of the source of any reprinted or reproduced material. For other uses of the material, request permission from CRP. NOTICE The project that is the subject of this report was a part of the Airport Cooperative Research Program conducted by the Transportation Research Board with the approval of the Governing Board of the National Research Council. Such approval reflects the Governing Board's judgment that the project concerned is appropriate with respect to both the purposes and resources of the National Research Council. The members of the technical advisory panel selected to monitor this project and to review this report were chosen for recognized scholarly competence and with due consideration for the balance of disciplines appropriate to the project. The opinions and conclusions expressed or implied are those of the research agency that performed the research, and while they have been accepted as appropriate by the technical panel, they are not necessarily those of the Transportation Research Board, the National Research Council, or the Federal Aviation Administration of the U.S. Department of Transportation. Each report is reviewed and accepted for publication by the technical panel according to procedures established and monitored by the Transportation Research Board Executive Committee and the Governing Board of the National Research Council. The Transportation Research Board of the National Academies, the National Research Council, and the Federal Aviation Administration (sponsor of the Airport Cooperative Research Program) do not endorse products or manufacturers. Tradeor manufacturers' names appear herein solely because they are considered essential to the clarity and completeness of the project reporting. puh(i.,hed repurtr frhe AIRPORT COOPERATIVE RESEARCH PROGRAM on, arad ble rrm. Transportation Research Board Business Office 500 Fifth Street, NW Washington, DC 20001 and can be ordered through the Internet at hnp:/Aw w.national-wademies.org/vb/bookstore Pant a in ter ueitea stairs of Amrdm Counting Aircraft Operations at Non -Towered Airports Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 30 of 70 THE NATIONAL ACADEMIES Advisers to the Nation on Science, Engineering, and Medicine The National Academy of Sciences is a private, nonprofit, self-perpetuating satiety of distinguished schol- ars engaged in scientific and engineering research, dedicated to the furtherance of science and technology and to their use for the general welfare. On the authority of the charter granted to it by the Congress in 1863, the Academy has a mandate that requires it to advise the federal government on scientific and techni- cal matters. Dr. Ralph I. Cicerone is president of the National Academy of Sciences. The National Academy of Engineering was established in 1964, under the charter of the National Acad- emy of Sciences, as a parallel organization of outstanding engineers. It is autonomous in its administration and in the selection of its members, sharing with the National Academy of Sciences the responsibility for advising the federal government. The National Academy of Engineering also sponsors engineering programs aimed at meeting national needs, encourages education and research, and recognizes the superior achieve- ments of engineers. Dr. William A. Wulf is president of the National Academy of Engineering. The Institute of Medicine was established in 1970 by the National Academy of Sciences to secure the services of eminent members of appropriate professions in the examination of policy matters pertaining to the health of the public. The Institute acts under the responsibility given to the National Academy of Sciences by its congressional charter to be an adviser to the federal government and, on its own initiative, to identify issues of medical care, research, and education. Dr. Harvey V Fineberg is president of the Institute of Medicine. The National Research Council was organized by the National Academy of Sciences in 1916 to associate the broad community of science and technology with the Academy's purposes of furthering knowledge and advising the federal government. Functioning in accordance with general policies determined by theAcad- emy, the Council has become the principal operating agency of both the National Academy of Sciences and the National Academy of Engineering in providing services to the government, the public, and the scientific and engineering communities. The Council is administered jointly by both the Academies and the Institute of Medicine. Dr. Ralph I. Cicerone and Dr. William A. Wulf are chair and vice chair, respectively, of the National Research Council. The Transportation Research Board is a division of the National Research Council, which serves the National Academy of Sciences and the National Academy of Engineering. The Board's mission is to promote innovation and progress in transportation through research. In an objective and interdisciplinary setting, the Board facilitates the sharing of information on transportation practice and policy by researchers and practitioners; stimulates research and offers research management services that promote technical excellence; provides expert advice on transportation policy and programs; and disseminates research results broadly and encourages their implementation. The Board's varied activities annually engage more than 5,000 engineers, scientists, and other transportation researchers and practitioners from the public and private sectors and academia, all of whom contribute their expertise in the public interest. The program is supported by state transportation departments, federal agencies including the component administrations of the U.S. Department of Transportation, and other organizations and individuals interested in the development of transportation. w .TRB.org www.national-academies.org Copyright National Academy of Sciences. All rights reserved. Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 31 of 70 ACRP COMMITTEE FOR PROJECT 11-03 CHAIR BURRSTEWART Pon of Seattle MEMBERS GARY C. CATHEY California Department of Transportation KEVIN C. DOLLIOLE UCG Associates BERTAFERNANDEZ Landrum & Brown JULIE KENFIELD Caner & Burgess, Inc CAROLYN MOTZ Hagerstown Regional Airpon FAA LIAISON LORI PAGNANELLI ACI-NORTH AMERICA LIAISON RICHARD MARCHI TRB LIAISON CHRISTINE GERENCHER COOPERATIVE RESEARCH PROGRAMS STAFF CHRISTOPHER W..JENKS, Director, Cooperative Research Programs CRAWFORD F. JENCKS, Deputy Director, Cooperative Research Programs EILEEN DELANEY, Director of Publications ACRP SYNTHESIS STAFF STEPHEN R. GODWIN, Director fir Studies and Special Programs ION WILLIAMS, Associate Director, IDEA and Synthesis Studies GAIL STABA, Senior Program Officer DON TIPPMAN, Editor CHERYL KEITH, Senior Program Assistant TOPIC PANEL PETER BUCHEN, Minnesota Department of Transportation CLIFF BURNEITE, Virginia Departmentof Aviation CHRISTINE GERENCHER, Transportation Research Board ANDREW KUBIK, California Department of Transportation MICHELLE McENANY, Iowa Department of Transportation CAROLYN MOTZ, Hagerstown Regional Airport LARRY WEBER, Oregon Department of Aviation DAVID CROSS, National Association of State Aviation Officials (Liaison) PETER LcBOFF, Federal Aviation Administration (Liaison) LORI PAGNANELLI, Federal Aviation Administration (Liaison) Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 32 of 70 FOREWORD Airport administrators, engineers, and researchers often face problems for which infor- By Staff mation already exists, either in documented form or as undocumented experience and Transportation practice. This information may he fragmented, scattered, and unevaluated. As a conse- Research Board quence, full knowledge of what has been learned about a problem may not be brought to bear on its solution. Costly research findings may go unused, valuable experience may he overlooked, and due consideration may not he given to recommended practices for solving or alleviating the problem. There is information on nearly every subject of concern to the airport industry. Much of it derives from research or from the work of practitioners faced with problems in their day-to-day work. To provide a systematic means for assembling and evaluating such useful information and to make it available to the entire airport community, the Airport Cooperative Research Program authorized the Transportation Research Board to undertake a continuing project. This project, ACRP Project 11-03, "Synthesis of Information Re- lated to Airport Practices," searches out and synthesizes useful knowledge from all available sources and prepares concise, documented reports on specific topics. Reports from this endeavor constitute an ACRP report series, Synthesis of Airport Practice. This synthesis series reports on current knowledge and practice, in a compact format, without the detailed directions usually found in handbooks or design manuals. Each report in the series provides a compendium of the best knowledge available on those measures found to he the most successful in resolving specific problems. PREFACE This synthesis project identifies and evaluates the different methods used by states, air- ports, and metropolitan planning agencies (MPOs), of counting and estimating aircraft op- erations at non -towered airports with the goal of identifying best practices. Also identified are any new technologies that can be used for these counts and estimates. Information used in this study was acquired through a literature review; a survey dis- tributed to all 50 state aviation agencies, and selected airports and MPOs; contacts with manufacturers of counting equipment and aviation trade organizations; and follow-up tele- phone interviews and e-mail correspondence, where appropriate. Maria Muia, Aerofinity, Inc., Indianapolis, Indiana, collected and synthesized the infor- mation and wrote the report. The members of the topic panel are acknowledged on the pre- ceding page. This synthesis is an immediately useful document that records the practices that were acceptable within the limitations of the knowledge available at the time of its preparation. As progress in research and practice continues, new knowledge will be added to that now at hand. Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 33 of 70 CONTENTS I SUMMARY 5 CHAPTER ONE INTRODUCTION Statement of Problem, 5 Purpose of Study, 5 Research Methodology, 5 Questionnaire Response Rate, 5 Definition of Terms, 6 7 CHAPTERTWO LITERATURE REVIEW Introduction,7 Conclusions from Literature Review. 7 8 CHAPTER THREE RESEARCH FINDINGS Introduction, 8 Aircraft Traffic Counting Technology, 8 Potential Crossover Technology, 9 Industry Trade Organizations Contacted, 9 Methods Used to Count and Estimate Airport Operations, 9 Accuracy and Efficiency, 10 Costs, 14 Uses of Data, 14 15 CHAPTER FOUR CONCLUSIONS AND 17 REFERENCES 18 BIBLIOGRAPHY vA� �» q Z113 0.01� u /:V` ul Y:Cw I11 11916111 I LI 10) 17 a /:Y Y [a] J 21 APPENDIX B QUESTIONNAIRE 26 APPENDIX LITERATURE REVIEW Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 34 of 70 COUNTING AIRCRAFT OPERATIONS AT NON -TOWERED AIRPORTS SUMMARY Annual aircraft operations estimates are used in aviation system planning, airport master planning, environmental studies, aviation forecasts, and to determine funding and design criteria for the nation's airports. At airports with air traffic control towers, aircraft opera- tions are tracked and recorded by the air traffic controller. Most airports in the United States, however, do not have air traffic control towers. These airports are generally known as non - towered airports, and they make up the vast majority of the airports open to the public for business. Accordingly, unlike with larger towered airports, these non -towered airports do not have readily available records on aircraft activity. Consequently, many state aviation agencies and some airports and metropolitan planning organizations (MPOs) have devel- oped aircraft traffic counting programs to track airport activity at their airports. However, many have not. For airports without air traffic control towers and/or with part-time towers, the number and type of operations may he based on the best guess of the airport manager or on prior -year counts, factored for assumed growth. It would he desirable to know and use the most accurate means of counting and estimating actual operations at these smaller air- ports. The corresponding operations data collected could then he included on FAA Airport Master Record Form 5010, because this form is often used as a source for these data in the system planning, master planning, forecasting, and funding operations. This synthesis project determines the practices for counting and estimating aircraft oper- ations at non -towered airports. A literature review was conducted to establish previous research and findings on counting and estimating aircraft operations at these airports. Addi- tionally, questionnaires were sent to all 50 state aviation agencies and selected airports and MPOs that were known to have traffic counting programs to determine their methods of counting and estimating aircraft operations at non -towered airports. A total of 61 question- naires were sent and 51 were returned, an 84% response rate. Crossover technology was researched and traffic counting manufacturers and aviation trade organizations were also contacted. This was done to help determine current and potential technology for counting and estimating aircraft operations and also to help obtain previous research completed on the topic. Through this synthesis report it was revealed that a variety of methods are being used across the country to count and estimate aircraft operations, and these methods vary in accuracy. These methods are: • Count traffic year-round, • Sample traffic and extrapolate annual operations, • Multiply a predetermined number of operations per based aircraft by the total aircraft based at the airport, • Perform regression analysis, and • Ask the airport manager or personnel associated with the airport The most common method used by the respondents to this study's questionnaire is also the most inaccurate of the methods currently in use, which is simply asking the airport Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 35 of 70 manager or other related airport personnel what they believe the annual aircraft operations are for their airport. The Texas Department of Transportation's 1994 Aircraft Activity Counter Report found that an airport's operations can he as much as doubled when esti- mated by the airport manager as opposed to sampling traffic with an acoustical counter and extrapolating the sample into an annual estimate. The most accurate method currently in use is to deploy an aircraft traffic counter(s) at an airport year-round, which in theory counts all traffic at the airport. Seven respondents used this method, four of which were airports. Another method believed to he accurate is to sample traffic with some type of aircraft counter for two weeks in each of the four seasons and to expand that sample into an annual count. The method relies on a valid extrapolation from the sample to annual operations. How- ever, only 6 of the remaining 12 respondents that sampled traffic actually did so for two weeks in each of the four seasons. The final six did not sample in all four seasons, making their results less accurate than those that sampled during all seasons or year-round. The method used to expand the sample count to an annual estimate was most often done with a seasonal or monthly adjustment factor. How the adjustment factor was determined for each respondent was not covered in this study's questionnaire and is recommended for further study. Previous research indicated that towered airports were not a valid way to develop adjustment factors for non -towered airports partially because of the availability of more instrument approaches at towered airports, which supposedly made them accessible during inclement weather. This may have been the case more than 20 years ago, but more and more non -towered airports have instrument approaches today. There are currently six different methods being used to sample aircraft traffic: • Acoustical, • Airport guest logs, • Fuel sales, • Pneumatic, • Video image detection, and • Visual. Use of airport guest logs and fuel sales, although helpful, will not track all traffic because not all pilots sign a guest log and because not all aircraft purchase fuel with each flight. Additionally, neither of these methods will account for touch-and-go operations. Of the equipment currently being used to sample traffic, the acoustical (including the sound - level meter and computerized acoustical) and video image detection systems offer acceptable levels of accuracy in detecting aircraft, both estimated by the manufacturers to he in the 90% range. The acoustical systems are generally less expensive than the video systems, although the video systems offer more information such as aircraft tail numbers. Visual sampling of traffic by a human observer is very accurate, but also very costly and time-consuming. In summary, it is believed that the most accurate and cost-effective way to estimate air- craft operations at a non -towered airport is to sample traffic for two weeks for each of the four seasons and extrapolate that sample into an annual estimate. This would he considered the best practice if year-round counts are not feasible. As stated earlier, the acoustical counter provides a cost-effective, efficient, and accurate way to collect the sample, whereas the video image detection system, although more costly, adds additional information that may he use- ful to the airport. Pneumatic counters and inductance loop counters have several serious limitations and would only he useful at airports that have a most simple configuration of one runway and one entry taxiway. Airport guest logs and fuel sales are also not recommended as a way to count traffic. Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 Page 36 of 70 The information received by the states, airports, and MPOs from their aircraft traffic counting programs is being used for a variety of purposes, including justification for airport improvement projects, justification for air traffic control towers, airport environmental documentation, forecasting, economic impact statements, performance measures, FAA Airport Master Record Form 5010 reporting, system planning, justification for navigational aids, and airport planning studies. Because the most common method for estimating aircraft operations (asking the airport manager or other airport personnel) may not he accurate, the information being used for these purposes may also he assumed not to be accurate. Addi- tionally, because the methods being used to count and estimate aircraft operations at non - towered airports vary in accuracy, the results are not comparable among the airports. As stated earlier, airport operations data are being used on FAA Airport Master Record 5010 forms. Each airport has an Airport Master Record that is produced under the guide- lines of the FAA Airport Safety Data Program. The information on the Airport Master Record is made available to the general public to use at their discretion. The FAA Order directs the airport inspector to record the total number of general aviation operations that occur at the airport. It further stipulates that the inspector is to use "FAA tower counts where available. If not available from FAA sources, use estimates based on discussion with airport management and/or the fixed base operators." State aviation agencies and the FAA should coordinate the collection and reporting of accurate airport operations data. This can he accomplished by: (1) encouraging widespread use of appropriate practices identified in the synthesis; (2) when such practices are used, including information in the Airport Master Record Form 5010; and (3) considering changing the format of Form 5010 to identify the counting practices used. Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 (CITY OF IOWA CITY IP 1 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2017/4 TO 2017/4 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S 76850110 Airport Operations WARRANT CHECK DESCRIPTION 7600-70-70-850-850100-850110-000-0000-438030- Electricity 010319 MIDAMERICAN ENERGY 20161014104803 0 2017 4 INV P 1,208.74 102116 ACCOUNT TOTAL 1,208.74 7600-70-70-850-850100-850110-000-0000-438070- Heating Fuel/Gas 010319 MIDAMERICAN ENERGY 20161014104803 0 2017 4 INV P 34.34 102116 ACCOUNT TOTAL 34.34 7600-70-70-850-850100-850110-000-0000-438110- Local Phone Service 011937 AUREON COMMUNICATION 0789004025.2016.10 0 2017 4 INV P 85.71 102116 ACCOUNT TOTAL 85.71 7600-70-70-850-850100-850110-000-0000-442010- Other Building R&M Services 010358 OVERHEAD DOOR COMPAN XW32552 0 2017 4 INV P 960.00 101416 010856 JET AIR INC IOW IVI-16-00381 0 2017 4 INV P 600.00 101416 ACCOUNT TOTAL 1,560.00 7600-70-70-850-850100-850110-000-0000-442020- Structure R&M Services 012238 OTIS ELEVATOR COMPAN CER65338616 0 2017 4 INV P 180.00 101416 ACCOUNT TOTAL 180.00 7600-70-70-850-850100-850110-000-0000-442070- Bldg Pest Control Services 010856 JET AIR INC IOW IVI-16-003839 0 2017 4 INV P 219.52 101416 013610 STANDARD PEST CONTRO 31043 0 2017 4 INV P 30.00 102116 ACCOUNT TOTAL 249.52 7600-70-70-850-850100-850110-000-0000-445030- Nursery Srvc-Lawn & Plant Care 010856 JET AIR INC IOW IVI-16-003840 0 2017 4 INV P 4,500.00 101416 014344 FORESTRY CONSULTING 160165 0 2017 4 INV P 2,750.00 102816 ACCOUNT TOTAL 7,250.00 7600-70-70-850-850100-850110-000-0000-445080- Snow and Ice Removal 013997 CRYOTECH DEICING TEC IN39320 0 2017 4 INV P 5,737.43 102816 ACCOUNT TOTAL 5,737.43 7600-70-70-850-850100-850110-000-0000-449055- Permitting Fees 010262 IOWA WORKFORCE DEVEL 46927 0 2017 4 INV P 175.00 101416 ACCOUNT TOTAL 175.00 1429 MidAmBilling 101920 1429 MidAmBilling 101920 167203 OCT 2015 INV 167104 Hangar #13 Door Rep 167060 Cleaning/Janitorial 167103 Elevator Service an 167060 Maintenance Reimbur 167372 Pest Control Servic 167060 Maintenance/Grounds 167947 Tree Removal West A 167932 NAAC (Pavement Deic 167059 fee Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 (CITY OF IOWA CITY IP 2 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2017/4 TO 2017/4 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION 7600-70-70-850-850100-850110-000-0000-449060- Dues & Memberships 010232 IOWA CITY CORALVILLE IlIG4767 0 2017 4 INV P 300.00 102816 167974 Annual Dues ACCOUNT TOTAL 300.00 7600-70-70-850-850100-850110-000-0000-466050- Electrical Supplies 010856 JET AIR INC IOW IVI-16-003839 0 2017 4 INV P 161.76 101416 167060 Maintenance Reimbur 011180 BLUEGLOBES LLC IOW-23344 0 2017 4 INV P 285.91 100716 166783 Light replacement p ACCOUNT TOTAL 447.67 7600-70-70-850-850100-850110-000-0000-466070- Other Maintenance Supplies 010856 JET AIR INC IOW IVI-16-003839 0 2017 4 INV P 54.12 101416 167060 Maintenance Reimbur ACCOUNT TOTAL 54.12 7600-70-70-850-850100-850110-000-0000-467020- Equipment R&M Supplies 010856 JET AIR INC IOW IVI-16-003839 0 2017 4 INV P 174.69 101416 167060 Maintenance Reimbur ACCOUNT TOTAL 174.69 7600-70-70-850-850100-850110-000-0000-469200- Tools 010856 JET AIR INC IOW IVI-16-003839 0 2017 4 INV P 69.99 101416 167060 Maintenance Reimbur ACCOUNT TOTAL 69.99 7600-70-70-850-850100-850110-000-0000-469260- Fire Ext & Refills 010191 HAWKEYE FIRE AND SAF 73051 0 2017 4 INV P 506.20 102816 167957 Annual Fire Extingu ACCOUNT TOTAL 506.20 7600-70-70-850-850100-850110-000-0000-473020- Non -Contracted Improvements 011246 BACHMEIER CARPET ONE CG601502 0 2017 4 INV P 1,596.20 102816 167917 Shades for bottom f 014375 CUSTOM BUILDERS OF T 77859 0 2017 4 INV P 16,725.12 100716 166795 Airport Share of Cc ACCOUNT TOTAL 18,321.32 ORG 76850110 TOTAL 36,354.73 FUND 7600 Airport TOTAL: 36,354.73 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 1 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 381100 Interest on Investments 850110 Airport Operations 76850110 381100 Interest on Invest 0 0 0 1,470.30 .00 -1,470.30 100.0%* 07/31/16 GNI 130359 SS 1,416.55 Rev IntRec JE#130359 07/31/16 GNI 130359 SS 252.74 Rev IntRec JE#130359 07/31/16 GEN 070971 SS -11.92 Interest Allocation En 07/31/16 GEN 070971 SS -2.59 Interest Allocation En 07/31/16 GEN 070971 SS -.28 Interest Allocation En 07/31/16 GEN 070971 SS 2.65 Interest Allocation En 382100 Land Rental 850110 Airport Operations 76850110 382100 Land Rental -48,000 0-48,000-3,357.40 .00-44,642.60 7.0%* 07/07/16 CRP 778119 FINA -368.75 US TREASURY 07/27/16 GBI 103098 -48.53 LAND RENT - JUN 2016 07/27/16 GBI 103098 -48.53 LAND RENT - JUL 2016 07/27/16 GBI 103098 -48.53 LAND RENT - AUG 2016 07/27/16 GBM 48.53 GB INVOICES 07/27/16 GBM 48.53 GB INVOICES 07/27/16 GBM 48.53 GB INVOICES 07/27/16 GBI 103098 -582.40 LAND RENT 07/27/16 GBI 104843 -325.00 LAND RENT 07/01/16 BUC -48,000 ORIGINAL BUDGET 2017 382200 Building/Room Rental 850110 Airport Operations 76850110 382200 Building/Room Rent-275,000 0-275,000-90,125.33 .00-184,874.67 32.8%* 07/08/16CRP 778166 FINA-125.33 VALLEY COLLECTION SERV 07/08/16CRP 778166 FINA-125.33 VALLEY COLLECTION SERV Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 2 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 07/26/16 GBM 151.00 GB INVOICES 07/26/16 GBI 314170 -151.00 Hangar Rent 07/27/16 GBI 314170 -151.00 HANGAR #11 07/27/16 GBI 405558 -144.00 Hangar #2 07/27/16 GBI 405441 -144.00 Hangar #7 07/27/16 GBI 319397 -358.00 HANGAR #33 07/27/16 GBI 403578 -110.00 Office Rent 07/27/16 GBI 400467 -179.00 Hangar Rent 07/27/16 GBI 400059 -151.00 HANGAR #15 07/27/16 GBI 400246 -144.00 HANGAR #5 07/27/16 GBI 100686 -210.00 HANGAR #57 07/27/16 GBI 105947 -179.00 HANGAR #38 07/27/16 GBI 105183 -151.00 HANGAR #27 07/27/16 GBI 105172 -179.00 HANGAR #48 07/27/16 GBI 104275 -144.00 HANGAR #8 07/27/16 GBI 104090 -4,287.00 D, E, F, H 07/27/16 GBI 104090 -106.67 GROUND LEASE 07/27/16 GBI 104090 -144.00 HANGAR #1 07/27/16 GBI 104090 -185.00 HANGAR #59 07/27/16 GBI 104090 -185.00 HANGAR #60 07/27/16 GBI 104090 -650.00 HANGAR #72 07/27/16 GBI 103824 -179.00 HANGAR #51 07/27/16 GBI 103759 -151.00 HANGAR #13 07/27/16 GBI 103636 -179.00 HANGAR #47 07/27/16 GBI 103584 -179.00 HANGAR #42 07/27/16 GBI 103583 -4,392.00 HANGAR #35 07/27/16 GBI 103583 -652.00 HANGAR #32 07/27/16 GBI 103574 -144.00 HANGAR #9 07/27/16 GBI 103503 -310.00 HANGAR #34 07/27/16 GBI 103319 -179.00 HANGAR #53 07/27/16 GBI 103098 -332.00 HANGAR #56 07/27/16 GBI 103078 -151.00 HANGAR #16 07/27/16 GBI 103026 -151.00 HANGAR #19 07/27/16 GBI 102700 -151.00 HANGAR #14 07/27/16 GBI 102618 -179.00 HANGAR #40 07/27/16 GBI 102617 -210.00 HANGAR #58 07/27/16 GBI 102612 -243.00 HANGAR #61 07/27/16 GBI 102608 -217.00 HANGAR #55 07/27/16 GBI 102608 -650.00 HANGAR #71 07/27/16 GBI 102606 -185.00 HANGAR #63 07/27/16 GBI 102603 -217.00 HANGAR #46 07/27/16 GBI 102601 -179.00 HANGAR #49 07/27/16 GBI 102597 -179.00 HANGAR #36 07/27/16 GBI 102597 -179.00 HANGAR #37 07/27/16 GBI 102596 -217.00 HANGAR #45 07/27/16 GBI 102592 -151.00 HANGAR #25 07/27/16 GBI 102592 -179.00 HANGAR #44 #11 - July (Bldg G) #41 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 3 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: 76850110 Airport Operations ORIGINAL APPROP TRANFRS/ ADJSTMTS REVISED BUDGET YTD ACTUAL JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT ENCUMBRANCES BUDGET USED 76850110 382200 Building/Room Rent 07/27/16 GBI 102592 -179.00 HANGAR #50 07/27/16 GBI 102592 -151.00 HANGAR #28 07/27/16 GBI 102586 -151.00 HANGAR #17 07/27/16 GBI 102580 -144.00 HANGAR #6 07/27/16 GBI 102580 -151.00 HANGAR #30 07/27/16 GBI 102578 -151.00 HANGAR #22 07/27/16 GBI 102575 -185.00 HANGAR #62 07/27/16 GBI 102466 -151.00 HANGAR #24 07/27/16 GBI 102090 -179.00 HANGAR #43 07/27/16 GBI 101765 -151.00 HANGAR #23 07/27/16 GBI 101403 -151.00 HARNGAR #21 07/27/16 GBI 101368 -204.00 HANGAR #64 07/27/16 GBI 101069 -144.00 HANGAR #10 07/27/16 GBI 101069 -404.00 HANGAR #31 07/27/16 GBI 100798 -75.50 HANGAR #18 07/27/16 GBI 100701 -75.50 HANGAR #18 07/27/16 GBI 100685 -179.00 HANGAR #39 07/27/16 GBI 100474 -151.00 HANGAR #12 07/27/16 GBI 100389 -151.00 HANGAR #26 07/27/16 GBI 100354 -100.00 OFFICE SPACE RENT 07/27/16 GBI 100353 -151.00 HANGAR #29 07/27/16 GBI 100111 -179.00 HANGAR #54 07/27/16 GBI 100061 -179.00 HANGAR #52 07/01/16 BUC -275,000 ORIGINAL BUDGET 2017 384900 Other Commissions 850110 Airport Operations 76850110 384900 Other Commissions -36,500 0 -36,500 -13,346.00 .00 -23,154.00 36.6%* 07/19/16CRP 770528 REVE -2,351.50 EASTERN AVIATION FUELS 07/01/16 BUC -36,500 ORIGINAL BUDGET 2017 393120 General Levy 850110 Airport Operations 76850110 393120 General Lev -113,209 0 -113,209 -37,736.36 .00 -75,472.64 33.3%* Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IOWA CITY P 4 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 07/31/16GEN 070909 REJE#2 -9,434.12 07/01/16 BUC -113,209 411000 Perm Full Time 850110 Airport Operations 76850110 411000 Perm Full Time 58,614 0 58,614 18,167.43 07/08/16 PRJ 1070216 070216 2,180.00 07/22/16 PRJ 1071616 071616 2,232.00 07/01/16 GNI REVERSE ND -1,868.57 07/01/16 BUC 58,614 413000 Temporary Employees 850110 Airport Operations 76850110 413000 Temporary Employee 500 0 500 217.50 07/22/16 PRJ 1071616 071616 56.25 07/01/16 BUC 500 414500 Longevity Pay 850110 Airport Operations 76850110 414500 Longevity Pay 500 0 500 .00 07/01/16 BUC 500 Ptax from Gen Fund ORIGINAL BUDGET 2017 00 40,446.57 31.0% WARRANT=070216 RUN-1 WARRANT-071616 RUN-1 FY16 PAYROLL ACCRUAL ORIGINAL BUDGET 2017 .00 282.50 43.5% WARRANT-071616 RUN-1 ORIGINAL BUDGET 2017 .00 500.00 .0% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 mtharp FOR 2017 04 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - OCTOBER 31, 2016 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 5 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 421100 Health Insurance 850110 Airport Operations 76850110 421100 Health Insurance 5,227 0 5,227 1,683.52 .00 3,543.48 32.2% 07/08/16 PRJ 1070216 070216 210.44 WARRANT-070216 RUN-1 07/22/16 PRJ 1071616 071616 210.44 WARRANT-071616 RUN-1 07/01/16 HOC 5,227 ORIGINAL BUDGET 2017 421200 Dental Insurance 850110 Airport Operations 76850110 421200 Dental Insurance 338 0 338 113.92 .00 224.08 33.7% 07/08/16 PRJ 1070216 070216 14.24 WARRANT-070216 RUN-1 07/22/16 PRJ 1071616 071616 14.24 WARRANT-071616 RUN-1 07/01/16 HOC 338 ORIGINAL BUDGET 2017 421300 Life Insurance 850110 Airport Operations 76850110 421300 Life Insurance 145 0 145 48.40 .00 96.60 33.4% 07/22/16 PRJ 1071616 071616 12.10 WARRANT-071616 RUN-1 07/01/16 HOC 145 ORIGINAL BUDGET 2017 421400 Disability Insurance 850110 Airport Operations Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 mtharp FOR 2017 04 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - OCTOBER 31, 2016 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 6 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 76850110 421400 Disability Insuran 252 0 252 83.16 .00 168.84 33.0% 07/22/16 PRJ 1071616 071616 20.79 WARRANT-071616 RUN-1 07/01/16 BUC 252 ORIGINAL BUDGET 2017 422100 FICA 850110 Airport Operations 76850110 422100 FICA 4,514 0 4,514 1,393.04 .00 3,120.96 30.9% 07/08/16 PRJ 1070216 070216 164.86 WARRANT-070216 RUN-1 07/22/16 PRJ 1071616 071616 173.20 WARRANT-071616 RUN-1 07/01/16 GNI REVERSE ND -141.31 FY16 PAYROLL ACCRUAL 07/01/16 BUC 4,514 ORIGINAL BUDGET 2017 423100 IPERS 850110 Airport Operations 76850110 423100 IPERS 5,324 0 5,324 1,641.79 .00 3,682.21 30.8% 07/08/16 PRJ 1070216 070216 194.67 WARRANT-070216 RUN-1 07/22/16 PRJ 1071616 071616 204.34 WARRANT-071616 RUN-1 07/01/16 GNI REVERSE ND -166.86 FY16 PAYROLL ACCRUAL 07/01/16 BUC 5,324 ORIGINAL BUDGET 2017 431020 Court Costs & Services 850110 Airport Operations 76850110 431020 Court Costs & Sery 110 0 110 .00 .00 110.00 .0% 07/01/16 BUC 110 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet 11/14/2016 13:22 CITY OF IONA CITY P 7 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 432020 Annual Audit 850110 Airport Operations 76850110 432020 Annual Audit 07/01/16 BUC 435057 Couriers 850110 Airport Operations 76850110 435057 Couriers 435060 Legal Publications 850110 Airport Operations 76850110 435060 Legal Publications 436030 Transportation 850110 Airport Operations 76850110 436030 Transportation 07/01/16 BUC 552 0 552 .00 552 0 0 0 18.50 Es 1,000 1,000 0 0 25.37 0 1,000 350.46 .00 552.00 .0% ORIGINAL BUDGET 2017 00 -18.50 100.0%* 00 -25.37 100.0%* .00 649.54 35.0% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 8 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 436050 Registration 850110 Airport Operations 76850110 436050 Registration 1,000 07/01/16 BUC 1,000 436060 Lodging 850110 Airport Operations 76850110 436060 Lodging 500 07/01/16 BUC 500 436080 Meals 850110 Airport Operations 76850110 436080 Meals 200 07/01/16 BUC 200 437010 Comp Liability Insurance 850110 Airport Operations 76850110 437010 Comp Liability Ins 22,886 07/01/16 BUC 22,886 0 1.000 250.00 0 500 320.26 0 200 25.00 0 22,886 3,284.53 .00 750.00 25.0% ORIGINAL BUDGET 2017 .00 179.74 64.1% ORIGINAL BUDGET 2017 .00 175.00 12.5% ORIGINAL BUDGET 2017 .00 19,601.47 14.4% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IOWA CITY P 9 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 437020 Fire & Casualty Insurance 850110 Airport Operations 76850110 437020 Fire & Casualty In 12,524 0 12,524 7,553.00 07/01/16 BUC 12,524 437030 Worker's Comp Insurance 850110 Airport Operations 76850110 437030 Worker's Comp Insu 159 0 159 181.00 07/01/16 BUC 159 437041 Bonding & Other Insurance 850110 Airport Operations 76850110 437041 Bonding & Other In 875 0 875 .00 07/01/16 BUC 875 437200 Loss Reserve Payment 850110 Airport Operations 76850110 437200 Loss Reserve Pavme 5,000 0 5,000 5,000.00 07/01/16 BUC 5,000 .00 4,971.00 60.3% ORIGINAL BUDGET 2017 .00 -22.00 113.8%* ORIGINAL BUDGET 2017 .00 875.00 .0% ORIGINAL BUDGET 2017 .00 .00 100.0% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 10 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: 76850110 Airport Operations 438010 Stormwater Utility Charges 850110 Airport Operations 76850110 438010 Stormwater Utility 07/20/16UBB C-160720160720 07/01/16 BUC 438030 Electricity 850110 Airport Operations 76850110 438030 Electricit 07/26/16 API VCH IN20160726091244 07/26/16 API VCR IN20160726091244 07/26/16 API VCR IN20160726091244 07/26/16 API VCR IN20160726091244 07/26/16 API VCR IN20160726091244 07/26/16 API VCR IN20160726091244 07/26/16 API VCR IN20160726091244 07/26/16 API VCH IN20160726091244 07/31/16 GNI REVERSAL KD 07/01/16 BUC ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 14.911 14,911 20.198 20.198 438050 Landfill Use 850110 Airport Operations 76850110 438050 Landfill Use 83 07/01/16 BUC 83 D1 JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 14,911 6,310.88 1,577.72 00 8.600.12 42.3% ORIGINAL BUDGET 2017 20,198 5,118.51 .00 15,079.49 25.3% 441.74 MIDAMERICAN E#325 14.90 MIDAMERICAN E#325 .39 MIDAMERICAN E#325 1,126.45 MIDAMERICAN E#325 .39 MIDAMERICAN E#325 .39 MIDAMERICAN E#325 32.23 MIDAMERICAN E#325 198.88 MIDAMERICAN E#325 -1,404.54 MIDAMERICANJULYPAYMENT ORIGINAL BUDGET 2017 83 94.50 .00 -11.50 113.9%* ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL P 11 glytdbud JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT ENCUMBRANCES BUDGET USED 438070 Heating Fuel/Gas 850110 Airport Operations 76850110 438070 Heating Fuel/Gas 4,227 0 4,227 109.43 .00 4,117.57 2.6% 07/26/16API VCH IN20160726091244 10.00 MIDAMERICAN E#325 07/26/16API VCH IN20160726091244 13.39 MIDAMERICAN E#325 07/26/16API VCH IN20160726091244 10.00 MIDAMERICAN E#325 07/31/16 GNI REVERSAL KD -26.75 MIDAMERICANJULYPAYMENT 07/01/16 HOC 4,227 ORIGINAL BUDGET 2017 438080 Sewer Utility Charge 850110 Airport Operations 76850110 438080 Sewer Utility Char 1,881 0 1,881 689.69 .00 1,191.31 36.7% 07/20/16UBB C-160720160720 181.20 07/01/16 HOC 1,881 ORIGINAL BUDGET 2017 438090 Water Utility Charge 850110 Airport Operations 76850110 438090 Water Utility Char 1,984 0 1,984 726.23 .00 1,257.77 36.6% 07/20/16UBB C-160720160720 192.49 07/01/16 HOC 1,984 ORIGINAL BUDGET 2017 438100 Refuse Collection Charges 850110 Airport Operations Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL P 12 glytdbud JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT ENCUMBRANCES BUDGET USED 76850110 438100 Refuse Collection 1,363 0 1,363 585.00 .00 778.00 42.9% 07/27/16API VCH IN87902 165.00 JOHNSON COUNT#161983 07/27/16API VCH IN87905 30.00 JOHNSON COUNT#161983 07/01/16 HOC 1,363 ORIGINAL BUDGET 2017 438110 Local Phone Service 850110 Airport Operations 76850110 438110 Local Phone Servic 1,322 0 1,322 343.11 .00 978.89 26.0% 07/18/16API VCH IN0789004025.2016.07 85.80 AUREON COMMUN#161617 07/01/16 HOC 1,322 ORIGINAL BUDGET 2017 438120 Long Distance Service 850110 Airport Operations 76850110 438120 Long Distance Sery 0 0 0 21.08 .00 -21.08 100.0%* 07/31/16 GNI ISICHARGERD 8.89 CH JUL LONG DIST CHGBK 442010 Other Building R&M Services 850110 Airport Operations 76850110 442010 Other Building R&M 14,069 0 14,069 3,457.50 .00 10,611.50 24.6% 07/11/16API VCH INIVI-16-002273 600.00 JET AIR INC I#160985 07/01/16 HOC 14,069 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 13 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 442020 Structure R&M Services 850110 Airport Operations 76850110 442020 Structure R&M Sery 621 07/01/16 HOC 621 442030 Heating Equipment R&M Services 850110 Airport Operations 76850110 442030 Heating Equipment 3,000 07/01/16 HOC 3,000 442040 Cooling Equipment R&M Services 850110 Airport Operations 76850110 442040 Cooling Equipment 1,083 07/01/16 HOC 1,083 442060 Electrical & Plumbing R&M Srvc 850110 Airport Operations 76850110 442060 Electrical & Plumb 4,459 07/01/16 HOC 4,459 0 621 180.00 0 3,000 M 0 1.083 528.00 0 4,459 M .00 441.00 29.0% ORIGINAL BUDGET 2017 .00 3,000.00 .0% ORIGINAL BUDGET 2017 .00 555.00 48.8% ORIGINAL BUDGET 2017 .00 4,459.00 .0% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 14 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 442070 Bldg Pest Control Services 850110 Airport Operations 76850110 442070 Bldg Pest Control 242 0 242 329.52 07/01/16 BUC 242 443080 Other Equipment R&M Services 850110 Airport Operations 76850110 443080 Other Equipment R& 6,997 0 6,997 2,320.67 07/01/16 BUC 6,997 444060 Cable & Electrical R&M Srvcs 850110 Airport Operations 76850110 444060 Cable & Electrical 403 0 403 .00 07/01/16 BUC 403 445030 Nursery Srvc-Lawn & Plant Care 850110 Airport Operations 76850110 445030 Nursery Srvc-Lawn 41,529 0 41,529 25,544.60 07/11/16API VCH INIVI-16-002274 4,500.00 07/01/16 BUC 41,529 .00 -87.52 136.2%* ORIGINAL BUDGET 2017 .00 4,676.33 33.2% ORIGINAL BUDGET 2017 .00 403.00 .0% ORIGINAL BUDGET 2017 .00 15,984.40 61.5% JET AIR INC I#160985 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 15 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 445080 Snow and Ice Removal 850110 Airport Operations 76850110 445080 Snow and Ice Remov 29,000 0 29,000 5,737.43 .00 23,262.57 19.8% 07/01/16 BUC 29,000 ORIGINAL BUDGET 2017 445110 Testing Services 850110 Airport Operations 76850110 445110 Testing Services 2,000 0 2,000 .00 .00 2,000.00 .0% 07/01/16 BUC 2,000 ORIGINAL BUDGET 2017 446100 City Attorney Chargeback 850110 Airport Operations 76850110 446100 City Attorney Char 6,465 0 6,465 .00 .00 6,465.00 .0% 07/01/16 BUC 6,465 ORIGINAL BUDGET 2017 446120 ITS-Server/Storage Chgbk 850110 Airport Operations 76850110 446120 ITS-Server/Storage 216 0 216 149.65 .00 66.35 69.3% 07/31/16 GNI July 2016KD 9.72 Storage of Email 07/01/16 BUC 216 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 16 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 446130 ITS-PC/Peripheral/Tablet S/R 850110 Airport Operations 76850110 446130 ITS-PC/Peripheral/ 6,909 0 6,909 4,022.90 .00 2,885.86 58.2% 07/01/16 BUC 6,909 ORIGINAL BUDGET 2017 446160 ITS -Infrastructure Fee 850110 Airport Operations 76850110 446160 ITS-Infrastucture 8,761 0 8,761 8,761.00 .00 .00 100.0% 07/01/16 BUC 8,761 ORIGINAL BUDGET 2017 446190 ITS -Software SAAS Chgbk 850110 Airport Operations 76850110 446190 ITS -Software SAAS 216 0 216 18.50 .00 197.50 8.6% 07/01/16 BUC 216 ORIGINAL BUDGET 2017 446220 Phone Service Chargeback 850110 Airport Operations 76850110 446220 Phone Service Char 800 0 800 .00 .00 800.00 .0% 07/01/16 BUC 800 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 17 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 446300 Phone Equipment/Line Chgbk 850110 Airport Operations 76850110 446300 Phone Equipment/Li 1,378 0 1,378 450.00 .00 928.24 32.7% 07/31/16 GNI ISICHARGEKD 112.50 CH JUL PHON EQUIP CHGB 07/01/16 BUC 1,378 ORIGINAL BUDGET 2017 446320 Mail Chargeback 850110 Airport Operations 76850110 446320 Mail Chargeback 200 0 200 159.16 .00 40.84 79.6% 07/01/16 BUC 200 ORIGINAL BUDGET 2017 446350 City Vehicle Replacement Chgbk 850110 Airport Operations 76850110 446350 City Vehicle Repla 18,244 0 18,244 6,317.00 .00 11,927.00 34.6% 07/31/16 GNI EQUIPMENTHBKEQ 1,817.79 JUL REPLACEMENT COST 07/01/16 BUC 18,244 ORIGINAL BUDGET 2017 446360 City Vehicle Rental Chargeback 850110 Airport Operations 76850110 446360 City Vehicle Renta 272 0 272 .00 .00 272.00 .0% 07/01/16 BUC 272 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 18 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 446370 Fuel Chargeback 850110 Airport Operations 76850110 446370 Fuel Chargeback 5,258 0 5,258 1,324.86 07/31/16 GNI EQUIPMENTHBKEQ 329.89 07/01/16 BUC 5,258 446380 Vehicle R&M Chargeback 850110 Airport Operations 76850110 446380 Vehicle R&M Charge 27,733 0 27,733 2,819.56 07/31/16 GNI EQUIPMENTHBKEQ 510.87 07/01/16 BUC 27,733 449055 Permitting Fees 850110 Airport Operations 76850110 449055 Permitting Fees 440 0 440 175.00 07/01/16 BUC 440 449060 Dues & Memberships 850110 Airport Operations 76850110 449060 Dues & Memberships 1,185 0 1,185 300.00 .00 3,933.14 25.2% JUL DIVISION FUEL ORIGINAL BUDGET 2017 .00 24,913.44 10.2% JUL DIVISION SERVICE ORIGINAL BUDGET 2017 .00 265.00 39.8% ORIGINAL BUDGET 2017 00 885.00 25.3% 11/14/2016 13:22 mtharp FOR 2017 04 ACCOUNTS FOR: 76850110 Airport Operations Airport Commission Agenda & Info Packet Meeting Date: 11-17-16 0000 CITY OF IONA CITY P 19 YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 JOURNAL DETAIL 2017 1 TO 2017 1 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 449060 Dues & Memberships 07/01/16 BUC 449120 Equipment Rental 850110 Airport Operations 76850110 449120 Equipment Rental 452010 Office Supplies 850110 Airport Operations 76850110 452010 Office Supplies 07/01/16 BUC 452030 Minor Office Equip/Furniture 850110 Airport Operations 76850110 452030 Minor Office Equip 452040 Sanitation & Indust Supplies 850110 Airport Operations 76850110 452040 Sanitation & Indus 07/01/16 BUC 1,185 0 0 0 232.67 357 0 357 253.86 357 0 0 0 223.41 131 0 131 131 LIES ORIGINAL BUDGET 2017 00-232.67 100.0%* .00 103.14 71.1% ORIGINAL BUDGET 2017 00-223.41 100.0%* .00 131.00 .0% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 20 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 455120 Misc Computer Hardware 850110 Airport Operations 76850110 455120 Misc Computer Hard 193 0 193 .00 07/01/16 HOC 193 461040 Other Agriculture Chemicals 850110 Airport Operations 76850110 461040 Other Agriculture 336 0 336 129.13 07/01/16 HOC 336 466050 Electrical Supplies 850110 Airport Operations 76850110 466050 Electrical Supplie 445 0 445 690.62 07/01/16 HOC 445 466070 Other Maintenance Supplies 850110 Airport Operations 76850110 466070 Other Maintenance 583 0 583 1,401.38 07/01/16 HOC 583 .00 193.00 .0% ORIGINAL BUDGET 2017 .00 206.87 38.4% ORIGINAL BUDGET 2017 .00-245.62 155.2%* ORIGINAL BUDGET 2017 .00-818.38 240.4%* ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet 11/14/2016 13:22 CITY OF IONA CITY P 21 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 467020 Equipment R&M Supplies 850110 Airport Operations 76850110 467020 Equipment R&M Supp 1,377 0 1,377 186.27 .00 1,190.73 13.5% 07/01/16 BUC 1,377 ORIGINAL BUDGET 2017 468030 Asphalt 850110 Airport Operations 76850110 468030 Asphalt 155 0 155 .00 .00 155.00 .0% 07/01/16 BUC 155 ORIGINAL BUDGET 2017 469040 Traffic Cntrl Imprvmt Supplies 850110 Airport Operations 76850110 469040 Traffic Cntrl Impr 169 0 169 .00 .00 169.00 .0% 07/01/16 BUC 169 ORIGINAL BUDGET 2017 469190 Minor Equipment 850110 Airport Operations 76850110 469190 Minor Equipment 570 0 570 .00 .00 570.00 .0% 07/01/16 BUC 570 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet 11/14/2016 13:22 CITY OF IONA CITY P 22 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 469200 Tools 850110 Airport Operations 76850110 469200 Tools 07/01/16 BUC 469260 Fire Ext & Refills 850110 Airport Operations 76850110 469260 Fire Ext & Refills 07/01/16 BUC 469360 Food and Beverages 850110 Airport Operations 76850110 469360 Food and Beverages 473010 Contracted Improvements 850110 Airport Operations 76850110 473010 Contracted Improve 400 400 324 324 rk I 0 400 244.89 0 324 506.20 A 0 78.83 0 259,932.22 .00 155.11 61.2% ORIGINAL BUDGET 2017 .00-182.20 156.2%* ORIGINAL BUDGET 2017 00 -78.83 100.0%* 00-259,932.22 100.0%* Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 23 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 JOURNAL DETAIL 2017 1 TO 2017 1 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 473020 Non -Contracted Improvements 850110 Airport Operations 76850110 473020 Non -Contracted Imp 20,000 07/01/16 BUC 20,000 490040 Capital Project Funding 850110 Airport Operations 76850110 490040 Capital Project Fu 0 TOTAL Airport Operations -100,000 TOTAL REVENUES -472,709 TOTAL EXPENSES 372,709 0 20.000 18.321.32 0 0 5,564.39 0-100,000 261,621.06 0-472,709-143,094.79 0 372,709 404,715.85 7,450.00-5,771.32 128.9%* ORIGINAL BUDGET 2017 .00-5,564.39 100.0%* 7,450.00-369,071.06-269.1% .00-329,614.21 7,450.00-39,456.85 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 13:22 CITY OF IONA CITY P 24 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - OCTOBER 31, 2016 FOR 2017 04 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED GRAND TOTAL-100,000 0-100,000 261,621.06 7,450.00-369,071.06-269.1% ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IONA CITY P 1 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110362100 651 Contrib & Donations 7600-70-70-850-850100-850110-000-0000-362100-651 76850110369100 Reimb of Expenses 7600-70-70-850-850100-850110-000-0000-369100 76850110369900 Miscellaneous Other Income 7600 -70-70 -850-850100- 850110- 000- 0000-369900- 76850110381100 Interest on Investments 7600-70-70-850-850100-850110-000-0000-381100 76850110382100 Land Rental 7600-70-70-850-850100-850110-000-0000-382100 76850110382200 Building/Room Rental 7600-70-70-850-850100-850110-000-0000-382200 76850110384100 Telephone Commission 7600-70-70-850-850100-850110-000-0000-384100 76850110384200 Vending Machine Commission 7600-70-70-850-850100-850110-000-0000-384200 76850110384900 Other Commissions 7600-70-70-850-850100-850110-000-0000-384900 76850110392100 Sale of Land 7600-70-70-850-850100-850110-000-0000-392100 76850110392300 Sale of Equipment 7600-70-70-850-850100-850110-000-0000-392300 76850110392400 Gain/Loss on Sale 7600-70-70-850-850100-850110-000-0000-392400 76850110393120 General Levy 7600-70-70-850-850100-850110-000-0000-393120 76850110393910 Misc Transfers In 7600-70-70-850-850100-850110-000-0000-393910 76850110411000 Perm Full Time 7600-70-70-850-850100-850110-000-0000-411000 76850110412000 Perm Part Time 7600-70-70-850-850100-850110-000-0000-412000 00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -48,000.00 -48,000.00 -48,000.00 .00 -275,000.00 -275,000.00 -275,000.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -36,500.00 -36,500.00 -36,500.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -113,209.00 -113,209.00 -109,687.00 -3.11 .00 .00 .00 .00 58,614.00 .00 59,426.00 1.39 .00 .00 .00 .00 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IONA CITY P 2 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110413000 Temporary Employees 7600-70-70-850-850100-850110-000-0000-413000 76850110414500 Longevity Pay 7600-70-70-850-850100-850110-000-0000-414500 76850110421100 Health Insurance 7600-70-70-850-850100-850110-000-0000-421100 76850110421200 Dental Insurance 7600-70-70-850-850100-850110-000-0000-421200 76850110421300 Life Insurance 7600-70-70-850-850100-850110-000-0000-421300 76850110421400 Disability Insurance 7600-70-70-850-850100-850110-000-0000-421400 76850110422100 FICA 7600-70-70-850-850100-850110-000-0000-422100 76850110423100 IPERS 7600-70-70-850-850100-850110-000-0000-423100 76850110424900 Other Post Employment Benefits 7600-70-70-850-850100-850110-000-0000-424900 76850110431020 Court Costs & Services 7600-70-70-850-850100-850110-000-0000-431020 76850110432020 Annual Audit 7600-70-70-850-850100-850110-000-0000-432020 76850110432050 Appraisal Services 7600-70-70-850-850100-850110-000-0000-432050 76850110432080 Other Professional Services 7600-70-70-850-850100-850110-000-0000-432080 76850110432080 651 Other Professional Services 7600-70-70-850-850100-850110-000-0000-432080-651 76850110435056 Delivery Services 7600-70-70-850-850100-850110-000-0000-435056 76850110435057 Couriers 7600-70-70-850-850100-850110-000-0000-435057 500.00 .00 500.00 .00 500.00 .00 325.00 -35.00 5,227.00 .00 5,051.00 -3.37 338.00 .00 391.00 15.68 145.00 .00 148.00 2.07 252.00 .00 256.00 1.59 4,514.00 .00 4,559.35 1.00 5,324.00 .00 5,380.65 1.06 .00 .00 .00 .00 110.00 110.00 .00 -100.00 552.00 552.00 650.00 17.75 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IOWA CITY P 3 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110435060 Legal Publications 7600-70-70-850-850100-850110-000-0000-435060 76850110436030 Transportation 7600-70-70-850-850100-850110-000-0000-436030 76850110436030 651 Transportation 7600-70-70-850-850100-850110-000-0000-436030-651 76850110436050 Registration 7600-70-70-850-850100-850110-000-0000-436050 76850110436060 Lodging 7600-70-70-850-850100-850110-000-0000-436060 76850110436060 651 Lodging 7600-70-70-850-850100-850110-000-0000-436060-651 76850110436070 Miscellaneous Travel Expense 7600-70-70-850-850100-850110-000-0000-436070 76850110436080 Meals 7600-70-70-850-850100-850110-000-0000-436080 76850110437010 Comp Liability Insurance 7600-70-70-850-850100-850110-000-0000-437010 76850110437010 651 Comp Liability Insurance 7600-70-70-850-850100-850110-000-0000-437010-651 76850110437020 Fire & Casualty Insurance 7600-70-70-850-850100-850110-000-0000-437020 76850110437030 Worker's Comp Insurance 7600-70-70-850-850100-850110-000-0000-437030 76850110437041 Bonding & Other Insurance 7600-70-70-850-850100-850110-000-0000-437041 76850110437200 Loss Reserve Payment 7600-70-70-850-850100-850110-000-0000-437200 76850110438010 Stormwater Utility Charges 7600-70-70-850-850100-850110-000-0000-438010 76850110438030 Electricity 7600-70-70-850-850100-850110-000-0000-438030 .00 .00 .00 .00 1.000.00 1.000.00 1.000.00 .00 .00 .00 .00 .00 1,000.00 1,000.00 1,000.00 .00 500.00 500.00 500.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 200.00 200.00 200.00 .00 22,886.00 22,886.00 23,000.00 .50 .00 .00 .00 .00 12,524.00 12,524.00 9,113.00 -27.24 159.00 159.00 180.00 13.21 875.00 875.00 870.00 -.57 5,000.00 5,000.00 5,000.00 .00 14,911.00 14,911.00 14,911.00 .00 20,198.00 20,198.00 19,433.00 -3.79 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IOWA CITY P 4 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110438050 Landfill Use 83.00 83.00 81.00 -2.41 7600-70-70-850-850100-850110-000-0000-438050 76850110438070 Heating Fuel/Gas 4,227.00 4,227.00 2,495.00 -40.97 7600-70-70-850-850100-850110-000-0000-438070 76850110438080 Sewer Utility Charge 1,881.00 1,881.00 1,576.00 -16.21 7600-70-70-850-850100-850110-000-0000-438080 76850110438090 Water Utility Charge 1,984.00 1,984.00 1,759.00 -11.34 7600-70-70-850-850100-850110-000-0000-438090 76850110438100 Refuse Collection Charges 1,363.00 1,363.00 1,651.00 21.13 7600-70-70-850-850100-850110-000-0000-438100 76850110438100 651 Refuse Collection Charges .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-438100-651 76850110438110 Local Phone Service 1,322.00 1,322.00 1,038.00 -21.48 7600-70-70-850-850100-850110-000-0000-438110- 76850110438120 Long Distance Service .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-438120 76850110442010 Other Building R&M Services 14,069.00 14,069.00 13,351.00 -5.10 7600-70-70-850-850100-850110-000-0000-442010 76850110442020 Structure R&M Services 621.00 621.00 1,000.00 61.03 7600-70-70-850-850100-850110-000-0000-442020 76850110442030 Heating Equipment R&M Services 3,000.00 3,000.00 4,000.00 33.33 7600-70-70-850-850100-850110-000-0000-442030 76850110442040 Cooling Equipment R&M Services 1,083.00 1,083.00 1,641.00 51.52 7600-70-70-850-850100-850110-000-0000-442040 76850110442060 Electrical & Plumbing R&M Srvc 4,459.00 4,459.00 3,000.00 -32.72 7600-70-70-850-850100-850110-000-0000-442060 76850110442070 Bldg Pest Control Services 242.00 242.00 371.00 53.31 7600-70-70-850-850100-850110-000-0000-442070 76850110443050 Radio Equipment R&M Services .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-443050 76850110443080 Other Equipment R&M Services 6,997.00 6,997.00 4,619.00 -33.99 7600-70-70-850-850100-850110-000-0000-443080 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IONA CITY P 5 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110444060 Cable & Electrical R&M Srvcs 403.00 403.00 .00 -100.00 7600 -70-70 -850-850100- 850110- 000- 0000-444060- 76850110445030 Nursery Srvc-Lawn & Plant Care 41,529.00 41,529.00 42,024.00 1.19 7600-70-70-850-850100-850110-000-0000-445030 76850110445080 Snow and Ice Removal 29,000.00 29,000.00 24,000.00 -17.24 7600-70-70-850-850100-850110-000-0000-445080 76850110445100 Towing .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-445100 76850110445110 Testing Services 2,000.00 2,000.00 1,028.00 -48.60 7600-70-70-850-850100-850110-000-0000-445110 76850110445140 Outside Printing .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-445140 76850110445140 651 Outside Printing .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-445140-651 76850110445230 Other Operating Services .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-445230 76850110446010 Administrative Services .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-446010 76850110446100 City Attorney Chargeback 6,465.00 6,465.00 7,030.00 8.74 7600-70-70-850-850100-850110-000-0000-446100 76850110446120 ITS-Server/Storage Chgbk 216.00 216.00 489.00 126.39 7600 -70-70 -850-850100- 850110- 000- 0000-446120- 76850110446130 ITS-PC/Peripheral/Tablet S/R 6,908.76 6,908.76 11,975.00 73.33 7600-70-70-850-850100-850110-000-0000-446130 76850110446140 ITS -Capital Replacement Chgbk .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-446140 76850110446150 ITS -Application Dvlp Fee Chgbk .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-446150 76850110446160 ITS-Infrastucture Fee 8,761.00 8,761.00 8,761.00 .00 7600-70-70-850-850100-850110-000-0000-446160 76850110446190 ITS -Software SAAS Chgbk 216.00 216.00 216.00 .00 7600-70-70-850-850100-850110-000-0000-446190- Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IONA CITY P 6 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110446200 Photocopying Chargeback .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-446200 76850110446220 Phone Service Chargeback 800.00 800.00 .00 -100.00 7600-70-70-850-850100-850110-000-0000-446220 76850110446300 Phone Equipment/Line Chgbk 1,378.24 1,378.24 1,371.00 -.53 7600-70-70-850-850100-850110-000-0000-446300 76850110446320 Mail Chargeback 200.00 200.00 202.00 1.00 7600-70-70-850-850100-850110-000-0000-446320 76850110446350 City Vehicle Replacement Chgbk 18,244.00 18,244.00 19,457.00 6.65 7600-70-70-850-850100-850110-000-0000-446350 76850110446360 City Vehicle Rental Chargeback 272.00 272.00 .00 -100.00 7600-70-70-850-850100-850110-000-0000-446360 76850110446370 Fuel Chargeback 5,258.00 5,258.00 3,375.00 -35.81 7600-70-70-850-850100-850110-000-0000-446370 76850110446380 Vehicle R&M Chargeback 27,733.00 27,733.00 27,268.00 -1.68 7600-70-70-850-850100-850110-000-0000-446380 76850110448040 City Sponsored Event .00 .00 5,000.00 .00 7600-70-70-850-850100-850110-000-0000-448040 76850110449055 Permitting Fees 440.00 440.00 520.00 18.18 7600-70-70-850-850100-850110-000-0000-449055 76850110449060 Dues & Memberships 1,185.00 1,185.00 1,185.00 .00 7600-70-70-850-850100-850110-000-0000-449060 76850110449100 651 Vehicle Rental .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-449100-651 76850110449120 Equipment Rental .00 .00 500.00 .00 7600-70-70-850-850100-850110-000-0000-449120 76850110449120 651 Equipment Rental .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-449120-651 76850110449280 Misc Services & Charges .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-449280- 76850110449350 Meals (non -travel) .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-449350 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IONA CITY P 7 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110449360 Interest Expense 7600-70-70-850-850100-850110-000-0000-449360 76850110449370 Depreciation Expense 7600-70-70-850-850100-850110-000-0000-449370 76850110452010 Office Supplies 7600-70-70-850-850100-850110-000-0000-452010 76850110452030 Minor Office Equip/Furniture 7600-70-70-850-850100-850110-000-0000-452030 76850110452040 Sanitation & Indust Supplies 7600-70-70-850-850100-850110-000-0000-452040 76850110454020 Subscriptions 7600-70-70-850-850100-850110-000-0000-454020 76850110455120 Misc Computer Hardware 7600-70-70-850-850100-850110-000-0000-455120 76850110461040 Other Agriculture Chemicals 7600-70-70-850-850100-850110-000-0000-461040 76850110465010 651 Other Fluids & Gases 7600-70-70-850-850100-850110-000-0000-465010-651 76850110466040 Plumbing Supplies 7600-70-70-850-850100-850110-000-0000-466040 76850110466050 Electrical Supplies 7600-70-70-850-850100-850110-000-0000-466050 76850110466070 Other Maintenance Supplies 7600-70-70-850-850100-850110-000-0000-466070 76850110467020 Equipment R&M Supplies 7600-70-70-850-850100-850110-000-0000-467020 76850110467160 Other Vehicle R&M Supplies 7600-70-70-850-850100-850110-000-0000-467160 76850110468030 Asphalt 7600-70-70-850-850100-850110-000-0000-468030 76850110468050 Sand 7600-70-70-850-850100-850110-000-0000-468050 .00 .00 .00 .00 .00 .00 .00 .00 357.00 357.00 372.00 4.20 .00 .00 .00 .00 131.00 131.00 .00 -100.00 .00 .00 .00 .00 193.00 193.00 .00 -100.00 336.00 336.00 538.00 60.12 .00 .00 .00 .00 .00 .00 500.00 .00 445.00 445.00 500.00 12.36 583.00 583.00 1,500.00 157.29 1,377.00 1,377.00 1,500.00 8.93 .00 .00 .00 .00 155.00 155.00 100.00 -35.48 .00 .00 100.00 .00 Airport Commission Agenda & Info Packet nneeHnn na}e11-17-1R 11/14/2016 15:54 CITY OF IONA CITY P 8 mtharp FINANCE BUDGET REQUESTS bgdeptrq BUDGET PROJECTION 18100 FY18 Operating Budget ORG OBJECT PROJ ACCOUNT DESCRIPTION CURRENT PROJECTED PERCENT ADJ BUDGET ACTUAL FINANCE CHANGE 76850110469040 Traffic Cntrl Imprvmt Supplies 169.00 169.00 7600 -70-70 -850-850100- 850110- 000- 0000-469040- 76850110469190 Minor Equipment 570.00 570.00 7600-70-70-850-850100-850110-000-0000-469190 76850110469200 Tools 400.00 400.00 7600-70-70-850-850100-850110-000-0000-469200 76850110469260 Fire Ext & Refills 324.00 324.00 7600-70-70-850-850100-850110-000-0000-469260 76850110469320 Miscellaneous Supplies .00 .00 7600-70-70-850-850100-850110-000-0000-469320 76850110469320 651 Miscellaneous Supplies .00 .00 7600-70-70-850-850100-850110-000-0000-469320-651 76850110469360 Food and Beverages .00 .00 7600-70-70-850-850100-850110-000-0000-469360 76850110473010 Contracted Improvements .00 .00 7600-70-70-850-850100-850110-000-0000-473010 76850110473020 Non -Contracted Improvements 20,000.00 20,000.00 7600-70-70-850-850100-850110-000-0000-473020 76850110474240 Tractors .00 .00 7600-70-70-850-850100-850110-000-0000-474240 76850110475010 Furniture & Office Equipment .00 .00 7600-70-70-850-850100-850110-000-0000-475010 76850110476070 PC Hardware .00 .00 7600-70-70-850-850100-850110-000-0000-476070 76850110490040 Capital Project Funding .00 .00 7600-70-70-850-850100-850110-000-0000-490040 76850110490150 Operating Subsidy .00 .00 7600-70-70-850-850100-850110-000-0000-490150 76850110490190 Interfund Loan .00 .00 7600-70-70-850-850100-850110-000-0000-490190 BUDGET CEILING: TOTALS: -100,000.00 -175,414.00 ** END OF REPORT - Generated by Michael Tharp ** 200.00 18.34 500.00 -12.28 .00 -100.00 500.00 54.32 .00 .00 .00 .00 .00 .00 .00 .00 15.000.00 -25.00 .00 .00 5,000.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -100,000.00 -100,000.00 .00