Loading...
HomeMy WebLinkAbout10-20-2016 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, OCTOBER 20, 2016 - 6:00 P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: 2 min* September 15, 2016 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion / Action: a. Airport Master Plan 15 min b. FAA/IDOT Projects: AECOM / David Hughes 10 min i. Obstruction Mitigation ii. FY16 Apron Expansion 1. Consider a resolution accepting work as complete iii. South Taxiway Extension 1. Consider a resolution approving task order with AECOM iv. North T-Hangar Restroom v. FY2018 FAA AlP Pre -Application c. Airport "Operations" 20 min i. Strategic Plan -Implementation 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 November 17, 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: 10-20-16 Page 2 of 69 MINUTES IOWA CITY AIRPORT COMMISSION SEPTEMBER 15, 2016 — 6:00 P.M. AIRPORT TERMINAL BUILDING DRAFT Members Present: Minnetta Gardinier, Robert Libby, A. Jacob Odgaard, Chris Ogren Members Absent: Julie Bockenstedt Staff Present: Michael Tharp, Eric Goers Others Present: Matt Wolford, Bruce Hostager, Carl Byers, Todd Allen RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM: Chairperson Odgaard called the meeting to order at 6:05 P.M. APPROVAL OF MINUTES: Minutes of the August 18, 2016, meeting were reviewed first. Ogren noted that she was not at this meeting, but that in reading the minutes she questioned the spelling of former Mayor Regenia Bailey's name. Tharp noted that he would look into this. After some discussion, it was noted that this is the correct spelling. Libby moved to accept the minutes of the August 18, 2016, meeting as presented. Gardinier seconded the motion. The motion carried 3-0, Ogren abstaining and Bockenstedt absent. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: a. Airport Master Plan — Tharp stated that Carl Byers planned to be present for this discussion but that he had another meeting to attend first. He suggested they hold this topic for later in the meeting, in hopes of Byers attendance. Tharp stated that the plan is still with the FAA being reviewed at this time and that unfortunately it is moving slower than expected. Members agreed to hold off on this topic for now, until Byers' arrival. Gardinier asked for clarification on circling, and Tharp noted that there is still no circling allowed. b. FAA/IDOT Projects: AECOM / David Hughes - Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 3 of 69 i. FY16 Apron Expansion —Tharp stated that Todd Allen is present from AECOM. He noted that there is not much to update here. The close out on the apron project is not ready yet, but should be by the next meeting. ii. FY15 Obstruction Mitigation — Tharp noted that there is no change on this issue, as they are still awaiting the final master plan approvals. He then introduced Allen to the Commission. C. Airport Operations - i. Strategic Plan — Implementation — Tharp stated that he is a bit behind on this and is still completing the RFP process. He noted that he is having difficulty finding another airport in Iowa that is similar in doing a strategic plan, and that those outside of the state are more in line with the Cedar Rapids Airport. Gardinier noted that the Marion Airport should have a strategic plan that would be similar in nature. Tharp will check into this. ii. Budget — Tharp stated that he does not have much to add here. He noted that the blinds for downstairs have been ordered and he is awaiting their arrival. He added that a hangar door was recently repaired and that it took several attempts to fix this. iii. Management — 1. FAA Unmanned Aircraft — Part 107 — Tharp stated that he put this on the agenda as he wanted to give Members some insight into what the FAA has done with Part 107. He further explained what the process is to obtain a drone certificate. Basically it takes the 'approval' of such a certificate away from the airports. He added that in this meeting's packet there are several pages further explaining what the drone program entails. The DOT has put together a map showing the space that drones can be operated in without having to notify anyone. Members shared their concerns about drones being flown close to the Airport. Gardinier suggested the Airport educate the public on what good drone etiquette is and suggested using the Public Library to hold such an event. It was suggested that this information also be posted in the Airport terminal for people to see. Odgaard asked Tharp if he has had many calls about the drone rules and Tharp responded that he has had several calls, especially in the last few weeks. Gardinier also suggested having the Aero Hawks post this at their field. d. FBO / Flight Training Reports - i. Jet Air — Matt Wolford with Jet Air addressed the Members regarding the monthly maintenance reports. He noted that in August they finished the ceiling tile replacement downstairs. He also spoke to some of the other maintenance items that crews addressed over the past month. Ogren asked if they have been able to catch any groundhogs yet and Wolford noted that traps have been set but that he doesn't believe any have been caught yet. Members spoke briefly to the game day traffic at the Airport and fuel sales. Wolford then addressed the upcoming hangar construction, giving Members a brief rundown of timeframes and responding to their questions. e. Commission Members' Reports — Libby noted that he missed a recent disaster drill planning meeting but that Tharp was in attendance. Tharp spoke to the Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 4 of 69 meeting, stating that things are moving forward and that they are still looking at a May 201" date for this drill. He added that they are still getting the scenario planned but that things are moving ahead. Tharp then noted that Carl Byers had arrived at the meeting, and he asked if Byers had any updates on the master plan. Byers stated that the plan is still being reviewed, and that once they receive it from the FAA they can move to the next phase. Gardinier noted that she saw the "Sully" movie recently and she highly recommended it to Members. She noted that she is planning to fly to Lexington, if the weather cooperates, where she will give a talk about the Air Race Classic. Staff report — Tharp spoke briefly to the Sertoma event. He stated that everything went well from what he has heard. He also noted an upcoming reception that will be held for Henry Fisk, the architect who did the Airport terminal building. Tharp also noted that the Airport grounds will be used for parking for the upcoming Cyclo-cross event being held at the Fairgrounds. Gardinier asked if anyone knows how they would go about having a banner in the downtown area for the Airport's upcoming anniversary. Goers stated that they should check with the City Manager's office on this. Odgaard asked if Members would like to create a subcommittee to deal with this anniversary. SET NEXT REGULAR MEETING FOR: The next regular meeting of the Airport Commission will be held on Thursday, October 20, 2016, at 6:00 P.M. in the Airport Terminal Building. ADJOURN: Ogren moved to adjourn the meeting at 7:05 P.M. Gardinier seconded the motion. The motion carried 4-0, Bockenstedt absent. CHAIRPERSON DATE Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 5 of 69 Airport Commission ATTENDANCE RECORD 2016 TERM o 0 0 0 0 0 0 0 0 0 0 N N W A N T V w co w NAME EXP. N zi N N m m m m m m m m m m m Minnetta 031011 X X X X X X O/ X X X X Gardinier 79 E Jose 031011 X O/ X N N N N N N N N Assouline 76 E M M M M M M M M Chris Ogren 031011 X X X X X O/ X X X O/ X 18 E E A.Jacob 031011 X X X X X O/ X X X X X Odgaard 78 E Julie 031011 X X X X O/ X X X O X O/ Bockenstedt 17 E / E E Robert Libby 031211 N NM NM N X X X X O X X 20 M M / E Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 6 of 69 NM = Not a Member at this time Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 7 of 69 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION RESOLUTION ACCEPTING THE WORK FOR THE 2016 TERMINAL APRON EXPANSION WHEREAS, the Commission's consultant for the 2016 Terminal Apron Expansion, AECOM, has reported that the work associated with this project has been completed by All American Concrete Inc., and has recommended that we accept the work as complete; and WHEREAS, the final contract price is $191,242.97, which is established from the original contract cost of $191,487.30 and-$244.33 from Change Order #1 to adjust final constructed quantities. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION THAT: 1. Said improvements are hereby accepted by the Iowa City Airport Commission. Passed and approved this _ day of _, 2016. CHAIRPERSON ATTEST: SECRETARY It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays Approved by -- /_ City Attorneys Office Absent the Resolution be Bockenstedt Gardinier Libby Odgaard Ogren Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 8 of69 JA COM October 14, 2016 Mr. Jacob Odgaard Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 SUBJECT: Expand Aircraft Parking Apron Iowa City Municipal Airport Iowa City, Iowa Iowa DOT AIP Project 911601OW100 Contract No. 17452 AECOM ID No. 60446968 Dear Mr. Odgaard: By this letter, we hereby state: AECOM 515.323.7910 tel 500 SW 7th Street 515.244.4803 fax Suite 301 Des Moines, Iowa 50309 www.aecom.com 1. We have made a final review of the project and recommend acceptance- 2- To the best of our knowledge and belief, based on observations of AECOM staff during construction, the contractor, All American Concrete, Inc. has performed the work in accordance with the contract requirements in effect for the above -referenced project- 3- The total cost of the completed work is $ 191,242.97. I hereby certify that this engineering document was prepared by me or under my direct personal supervision and that I am a duly licensed Professional Engineer under the laws of the state of Iowa. C!� 3 • 10/14/16 David B. Hughes Date License No. 13037 My license renewal date is December 31, 2017. Pages or sheets covered by this seal: \\nscomi fp001no aemm net. mm\Data\Projects\6044696810W Terminal Apron Expan sion\600_ Construction _Support\620_Correspon den ce\J0101416 In docx Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 9 of 69 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 350 5045 RESOLUTION NO. RESOLUTION APPROVING PROJECT TASK ORDER NO. 5 WITH AECOM FOR SERVICES RELATING TO TERMINAL APRON EXPANSION WHEREAS, the Iowa City Airport Commission entered into a contract entitled "Consultant Services Agreement" with AECOM on May 15, 2014 to provide engineering services for Federal Airport Improvement Program Projects; and WHEREAS, Part I(A) of said agreement provides that the parties will enter into supplemental agreements for each project; and WHEREAS, the Commission and AECOM have previously entered into Project Task Orders Nos. 1, 2, 3 and 4; and WHEREAS, the Commission and AECOM now desire to enter into Project Task Order No. 5, a copy of which is attached; and WHEREAS, it is in the best interest of the Commission to enter into Project Task Order No. 5 NOW, THEREFORE, BE IT RESOLVED BY THE AIRPORT COMMISSION OF THE CITY OF IOWA CITY: 1. The Chairperson is authorized to sign Project Task Order No. 5. Passed and approved this CHAIRPERSON ATTEST: SECRETARY day of It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays 2016. Approved By: City Attorney's Office the Resolution be Absent Bockenstedt Gardinier Libby Odgaard Ogren Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 10 of 69 TAXILANE EXTENSION IDOT PROJECT NO. 9I170IOW100 CONTRACT NO. 18553 IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA PROJECT TASK ORDER NO. 5 Project Description: See attachment and incorporated herein. Scope of Services: See attachment and incorporated herein. Compensation Compensation for Engineering Services shall be a cost plus fixed fee not -to -exceed Nineteen Thousand Six Hundred Dollars ($19,600.00). See attachment and incorporated herein. General Conditions Except as specifically amended by this Individual Project Agreement, Services shall be provided in accordance with the Consultant Services Agreement for the Iowa City Municipal Airport, entered between AECOM Technical Services, Inc. ("ATS"), and the Iowa City Airport Commission ("Client'), dated May 15, 2014. APPROVED: IOWA CITY AIRPORT COMMISSION APPROVED: AECOM TECHNICAL SERVICES, INC. Douglas W. Schindel, P.E. Associate Vice President Date Date October 12, 2016 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 11 of 69 TAXILANE EXTENSION IDOT PROJECT NO. 9I170IOW100 CONTRACT NO. 18553 IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA Project Description The project is described as a 170-foot extension of the east -west taxilane in the south t-hangar area at the Iowa City Municipal Airport, Iowa City, Iowa. The project involves the removal of the installation of subdrains, storm sewer, pavement subbase and new concrete pavement. The bid documents for this project will be prepared in accordance with current Iowa Department of Transportation standards as if this project was directly funded by an IDOT AIP grant. Scope of Services The work to be performed by the Consultant shall encompass and include detailed work, services, materials, equipment and supplies necessary to develop final plans, specifications, construction cost estimates, and provide limited construction -phase services. Work in this project shall be divided into the following tasks: A. Design Phase Services Design Conference. This task consists of a pre -design conference called by the Iowa City Airport Commission (hereinafter referred to as Commission) and held between the Commission, the Consultant, and any other participating or regulatory governmental agency. The purpose of this conference is to define project requirements, finances, schedules, phasing and other pertinent data that affects the scope of work, design standards, presentation of preliminary and final plans and documents. 2. Data Collection and Review. This task consists of the collection of existing data applicable to this project and related to the proposed work site. This task includes subsurface investigation by others to define the suitability of the soils for pavement foundation. Afield survey to define features and topography is also included in this task. Property surveys are not included in this task- 3- Base Mapping. This task consists of the preparation of a topographic map including features, elevations, utilities and contours of the project site. This map will be prepared from the field survey and record documents of completed projects- 4- Final Design Documents. This task consists of the preparation of the final design documents for this project. The final plans will set forth in detail the requirements of the design phase, together with the common practice of design and ethical practice of professional engineers. Plans will be prepared in compliance with current Iowa Department of Transportation, Aviation Department requirements in effect at the time the plans are prepared. This task includes the preparation of the following: a. Title Sheet b. Legend and General Notes c Schedule of Drawings d. Schedule of Quantities e. General Project Layout Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 12 of 69 f. Safety and Sequencing Plans g. Existing Conditions and Removal Plans h. Typical Sections i. Geometric Layout j. Grading and Drainage Plans k. Erosion Control Plans I. Storm Sewer Plans and Profiles M. Pavement Jointing Plans n. Pavement Joint Details o. Cross Sections 5. Final Project Specifications. This task consists of the preparation of specifications for the project. The specifications will be in compliance with current Iowa Department of Transportation requirements in effect at the time the specifications are prepared- 6- Estimate of Probable Construction Cost. This task consists of the preparation of a detailed estimate of construction costs based upon the detailed plans and specifications. This statement of probable construction cost prepared by the Consultant represents the Consultant's best judgment as a design professional at the time the estimate is drawn. It is recognized, however, that neither the Consultant nor the Commission has any control over the cost of labor, materials or equipment; over the contractor's method of determining bid prices; or over competitive bidding or market conditions. Accordingly, the Consultant cannot and does not guarantee that bids will not vary from any statement of Probable Construction Cost or other cost estimates prepared by the Consultant- 7- Engineering Report. This task consists of the preparation of an engineering report that relates to the Commission and participating governmental agencies, the fundamental considerations and concepts used in design of the project. Deviation in design and construction standards will be included in the engineering report- 8- Quality Review. This task consists of the quality review of work elements on the project. During the course of this project, quality reviews will be conducted by senior technical personnel that are not directly involved in the project- 9- Conferences and Meetings. This task consists of meetings that will be attended by the Consultant for the purpose of coordination, information exchange and general understanding of the status and direction of the project. A progress meeting will be held at approximately the 60 percent design completion to review the progress and define the final project requirements. 10. Bid Assistance. This task consists of assisting the Commission in advertising for and receiving bids, answering bid document interpretation questions from bidders, analyzing the bids received, and preparing a recommendation to the Commission for award of contract. 11. Pre -Bid Conference. This task consists of attending and conducting a Pre -Bid Conference at the project site for prospective bidders. 12. Project Administration During Design. This task consists of office administration and coordination of the project. Interoffice meetings, general day-to-day administrative responsibilities, and typing of interoffice memoranda and minutes of meetings are included in this task. Prepare up to 10 sets of contract documents for distribution to Commission, IDOT, plan rooms, suppliers and potential bidders. Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 13 of 69 B. Limited Construction -Phase Services 1. Assignment of Construction Manager. This task consists of assigning a project engineer who will coordinate project activities and will be the principal liaison between the Sponsor, Consultant and regulatory agencies. 2. Assemble Construction Documents. This task consists of assisting the Sponsor in assembling the contract documents for execution by the Contractor and the Sponsor. 3. Pre -Construction Conference. This task consists of attending and conducting a pre -construction conference with representatives of the Contractor, Sponsor, Consultant, FAA and affected utilities- 4- Shop Drawings and Submittals. This task consists of reviewing shop drawings and other submittals as required of the Contractor by the contract documents for conformance with the design concept of the project and compliance with the information given in the contract documents- 5- Construction Assistance. This task consists of answering design interpretation questions from the Sponsor, Contractor, review staff and appropriate agencies. 6. Pay Applications. This task consists of preparing and processing monthly applications for payment to the Contractor and forwarding to the Sponsor for execution with recommendations for approval and payment- 7- Testing of Materials. This task consists of providing field testing and materials testing in accordance with the project specifications. A subconsultant will provide quality assurance testing for establishing Proctor values for the embankment and backfill materials. Contractor will provide acceptance testing for Portland cement concrete. 8. Site Visits. This task consists of providing periodic site visits to the construction site by design personnel at appropriate stages of construction to review the quality of the work and to determine, in general, whether the work conforms with the contract documents- 9- Change Orders. This task consists of coordinating with the Sponsor and Contractor in preparing and processing contract change orders. 10. Construction Observation. This task consists of limited on -site construction review at key critical construction operations to observe construction operations to determine compliance with contract documents. Site reviews will be documented in a construction journal. All coordination with airport tenants related to this project will be the responsibility of the Owner. Staffing requirements may be adjusted during the project in relation to the level of construction activity. 11. Non -Compliance Reporting. This task consists of reporting to the Sponsor any work believed to be unsatisfactory, faulty or defective or does not conform to the contract documents, and advising the Sponsor of any work that should be corrected or rejected. 12. Contractor Modifications. This task consists of reviewing, evaluating and making recommendations to the Sponsor on suggestions for modifications that have been made by the Contractor. Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 14 of 69 13. Proiect Files. This task consists of maintaining files for correspondence, reports of the job conferences, shop drawings, and sample submissions, reproductions of original contract documents including addenda, change orders, field modifications, additional drawings issued subsequent to the execution of the contract, Engineer clarifications and interpretations of the contract documents, progress reports and other project -related documents. 14. Field Representative Reports. This task consists of the resident field representative keeping a diary, log book or report for those times on site, recording hours on the job site; weather conditions; data relative to questions of extras or deductions; list of visiting officials and representatives of manufacturers, fabricators, suppliers and distributors; activities; decisions, observations in general and specific observations in more detail when necessary, as in the case of observing test procedures. 15. Punch List. This task consists of conducting a review of the project near completion and preparing a list of items (Punch List) to be completed or corrected. 16. Final Review. This task consists of performing a field observation of the completed project before a final application for payment is processed for the Contractor. 17. Proiect Closeout, This task consists of assisting the Sponsor with project completion and final closeout documentation from the Contractor by providing a statement covering the following. a. Final construction report- b. Brief narrative of work accomplished, as well as any excluded items. c. Summary of key milestone dates - Receipt of Bids, NTP, Substantial Completion, Contract Date, Final Inspection, Final Acceptance. d. Summary of final contract quantities. e. Explanation of underruns and overruns. f. Final inspection report, including signature of consultant. 18. Record Drawings. This task consists of providing the Sponsor with a copy of Record Drawings of the construction plans for the project based on the construction observation records of the review staff and Contractor showing those changes made during construction considered significant. Two copies of the Record Drawings in electronic and reproducible format will be provided to the Sponsor. Electronic drawings shall be in MicroStation V8 format. Task does not include updating of the Airport Layout Plans. 19. Proiect Administration During Construction. This task consists of office administration and coordination of the project. Interoffice meetings, general day-to- day administrative responsibilities, and typing of interoffice memoranda and minutes of meetings are included in this task. 0 \Administration\AGREE\PROF\IOW TO5 Taxilane Extension.doc Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Extension of Taxilane Iowa City Municipal Airport Iowa City, Iowa Project No. 911701OW100 Engineering Services Consultant Cost Summary Direct Labor Cost Page 15 of 69 Category Hours Rate/Hour Amount Senior Professional 10 $80.00 $800.00 Project Professional 20 $57.00 $1,140.00 Staff Professional 48 $44.50 $2,136.00 Professional 0 $36.45 $0.00 CADD Operator II 28 $33.80 $946.40 CADD Operator 1 0 $24.45 $0.00 Senior Technician 8 $34.60 $276.80 Technician 32 $25.60 $81920 Project Support 16 $29.90 $478.40 $6,596.80 162 Payroll Burden and Overhead Costs 139.14% $9,178.79 Direct Project Expenses Category Units Rate/Unit Amount Mileage 1000 0.540 540.00 Per Diem 0 50.00 0.00 Lodging 0 90.00 0.00 B/W Copies 2000 0.06 120.00 Color Copies 100 022 2200. Plan Copier 20 0.50 10.00 EDM Equipment 2 12.50 25.00 GPS Equipment 0 25.00 0.00 Nuclear Density Guage 0 40.00 0.00 Miscellaneous, Other 700.00 $1,417.00 AECOM Estimated Actual Costs $17,192.59 Rounded $17,200.00 Subcontract Expense Estimated Actual Costs Fixed Fee (15%of Items I & 11) Rounded Maximum Amount Payable $17,200.00 $2,400.00 $19,600.00 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 16 of 69 Extension of Taxilane Iowa City Municipal Airport Iowa City, Iowa Project No. 911701OW100 Engineering Services Staff Hour Estimate Item No. Description Senior Prof Project Prof Staff Prof Prof CADD Operator II CADD Operator I Senior Technician Technician Project Support Totals A DESIGN PHASE SERVICES 1 Design Conference 2 2 4 2 Data Collection and Review 4 4 3 Base Mapping 2 2 8 12 4 Final Design Documents 1 Ttie Sheet 1 1 2 Legend and General Notes I 1 1 1 3 Scheduleof Drawins 1 1 4 Schedule of Quantities 2 1 3 5 General Project layout 1 1 2 6 Safety and Sequencing Plans 2 4 6 7 Existing Conditions and Removal Plans 2 2 4 B Typical Sections 1 2 3 9 Geometric Layout 2 2 10 Grading and Drainage Plans 4 4 11 Erosion Control Plans 1 2 3 12 Storm Sewer Plans and Profiles 1 2 3 13 Pavement Jointing Plans I 1 1 2 3 14 Pavement Joint Details 2 2 15 Cross Sections 4 4 5 Final Project Specifications 4 4 8 6 Estimate of Probable Construction Cost 2 2 7 En neering Report 2 2 8 Quality Review 2 2 9 Conferences and Meetings 2 2 10 Bid Assistance 4 4 11 Pre -Bid Conference 2 2 12 Project Administration 2 1 1 2 4 Total Design Services 4 20 24 0 24 0 8 0 8 88 B LIMITED CONSTRUCTION PHASE SERVICES 1 Assignment of Construction Manager 0 2 Assemble Construction Documents 0 3 Pre -Construction Conference 2 2 4 Shop Drawingsand Submittals 4 4 5 Construction Assistance 4 4 6 Pay Applications 2 1 1 1 2 7 Testing of Materials 8 Site Visits 4 4 9 Change Orders 2 2 10 Construction Observation 24 24 11 Non -Compliance Reporting 4 4 12 Contractor Modifications 2 2 13 Project Files 4 4 14 Project Representative Reports 4 4 15 Punch List 2 2 16 Final Review 2 2 17 Project Closeout 2 2 18 Record Drawings 1 4 4 19 Project Administration 4 4 8 Total Construction Phase Services 6 0 24 0 4 0 0 32 8 74 Total Engineering Services 10 20 46 0 28 0 8 1 32 I 16 162 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 17 of 69 Airports included in the National Plan of Integrated Airports (NPIAS) are eligible to apply for federal Airport Improvement Program (AIP) funds. General aviation and small commercial service airports are required to submit preapplications for federal AIP funding through the Iowa Department of Transportation's Office of Aviation, including projects funded with nonprimary entitlement funds. All applications must include the following documents (forms are available on the Office of Aviation website http://www.iowadot.gov/aviation/managersandsponsors/forms.html ): • Federal Airport Improvement Pre -application (Sponsor Identification Sheet and Checklist, Form 291111) • Capital Improvement Program (CIP) data sheet for each project desired in IFFY 2018, IFFY 2019, and IFFY 2020. • 5-year Capital Improvement Plan (CIP) (Form 291112) Please include anticipated state funded projects in your CIP if known. • Long Range Needs Assessment (Form 291113) • A Completed NEPA determination (either Categorical Exclusion or date of Finding of No Significant Impact) Additional application documents are required for these specific projects: • Snow plow equipment projects — Contact Jeff Deitering for a copy of the snow equipment sizing spreadsheet and include a copy of the completed spreadsheet. Also 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-30D http://www.faa.gov/documentLibrary/media/Advisory Circular/150-5200-30D.pdf and the Airport Snow and Ice Control Equipment, AC 150/5220-20A http://www.faa.gov/regulations policies/advisory circulars/index.cfm/go/document.information/docum entid/1025787 showing the minimum equipment needed, along with the CIP Data Sheet. • General aviation (GA) apron expansion — Contact Jeff Deitering for a copy of the Apron Sizing spreadsheet and include a copy of a completed spreadsheet with any apron expansion application. • Revenue -producing facilities (fuel facilities including self -serve pumps and hangars) — Only nonprimary entitlement funding can be used. Submit: (1) justification of existing need for the project, including a waiting list if requesting a new hangar; (2) a statement that airside development needs are met or a financial plan to fund airside needs over the next 3 years (not eligible for discretionary funding), and; (3) evidence that runway approach surfaces are clear from obstructions (the FAA 5010 form must show at least 20:1 clear approach.) • Runway reconstruction — Submit an engineering report showing the need for the reconstruction as part of the CIP justification. First Due Date: November 7, 2016 — Email Draft 5-year CIP (Form 291112) to: aeff cleitering@faa.gov for comment Final Due Date: December 12, 2016 — Email signed application to shane.wright@dot.iowa.gov or send one copy of signed application package to: Iowa DOT Office of Aviation at the address below See page 2 for additional project information and links to additional information on the AIP program. Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 18 of 69 To be considered for federal AIP funds for IFFY 2018, the following requirements must be met: 1. The proposed project must be shown on a current Airport Layout Plan (ALP) that has been approved by the FAA. 2. The project must be reasonable, justified, necessary and eligible for federal participation. Provide necessary justification with the application. Each major work item must be on a separate CIP data sheet signed by the sponsor and dated. The CIP data sheet should include adequate justification and detailed cost estimate. http://www.faa.gov/airports/central/aip/cip/ 3. The FAA must have made an environmental determination on the proposed project. 4. In order for a land acquisition reimbursement project to be considered for funding, the land must be acquired or a purchase agreement must already be negotiated. 5. The sponsor must have the necessary 10%matching share available. The FAA considers the first two years of the CIP as work the sponsor is committed to accomplishing should funding become available. To assure that the limited AIP funds are used during the fiscal year obligated, the FAA has adopted the policy that actual grants must be based upon bids and submitted by May 1 of the year programmed. 6. The sponsor must be willing to sign the grant assurances required for airport funding. http://www.faa.gov/airports/aip/grant assurances/media/aimort-sponsor-assurances-aip.pdf 7. Airports with a pavement replacement or new pavement AIP project approved after January 1, 1995, must implement a pavement maintenance program to ensure the pavement is properly maintained at the airport. Pavement maintenance programs should be submitted to Dan Wilson, P.E, FAA Airports Division, ACE-621F, 901 Locust, Kansas City, MO 64106-2325 Eligible Projects Ineligible Projects Aircraft hangars (NPE only, includes renovation) Terminal rehabilitation/maintenance Airfield drainage Development that exceeds FAA Standards Airfield lighting Development for exclusive use Airfield signage Improvements for commercial enterprises Apron construction/rehabilitation Industrial park development Environmental studies Landscaping Fuel farms, new and documented capacity enhancement (NPE only, includes self service pumps) Fuel farm repairs or replacement General aviation terminal buildings (NPE Only, limited eligibility) Marketing plans Land acquisition Office equipment Certain Navaids (e.g. REILs, PAPIs) Training Planning studies Airport operational costs Runway construction/rehabilitation Replacement perimeter fencing Safety area improvements Snow removal equipment Maintenance equipment and vehicles (mowers) Snow removal equipment storage Artwork Taxiway construction/rehabilitation Weather observation stations (Basic AWOS only) Wildlife fencing (requires wildlife hazard assessment) Security fences and access control (unless required by FAR 1542) Additional Information on the Federal AIP program can be found at the following websites: FAA Central Region htto://www.faa.gov/airports/central/aip/sponsor guide/ or Iowa DOT Office of Aviation htto://www.iowadot.gov/aviation/managersandsoonsors/federalfunding.htmi. Airport Commission Agenda & Info Packet 010WADOT Meeting Date: 10-20-16 Page 19 of 69 Form 291111wd (09-15) Iowa City Municipal low Airport FAA Identifier FEDERAL AIRPORT IMPROVEMENT PROGRAM (AIP) PRE -APPLICATION FFY 2017 CHECKLIST Please attach the following documents with your application: ® 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 15015220-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: 10-20-16 Page 20 of 69 0IOWADOT FO" 291111wd (09-15) FEDERAL AIRPORT IMPROVEMENT PROGRAM (AIP) PRE -APPLICATION FFY 2017 AIRPORT SPONSOR IDENTIFICATION Airport Name: Iowa City Municipal Airport Airport Sponsor Name: City of Iowa City, Iowa Contact Person: Ms. Minnetta Gardinier Title: Complete Mailing Address: 1801 South Riverside Drive Iowa City IA 52246 City State ZIP Code E-mail Address: m.gardinier@gmlail.com U.S. Congressional District Number: Second (2nd) Commission Chair Daytime Phone: 319-356-5045 FAX Number: 319-351- 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 e1SPage 21 of 69 CPDATAHEET Iowa City Municipal Airport � IOw Runway 12-30 Approach Surface Obstruction Mitigation 2017 Removal of obstructions identified in the 2015 Master Plan associated with the Runway 12130 approach surfaces. Removal of these obstructions requires acquisition of avigation easements, removal of trees and replacement of the trees with lower growing species. COST ESTIMATE: (Attach detailed cost estimate) $ 720,000 SPONSOR'S VERIFICATION: For each and every project as applicable State $0 Local Instruction sheet or pi I%) $ 80,000 mouse over each Total $ 800,000 r more - Date of approved ALP with project shown - Date of environmental determination (ROD, FONSI, CE), or cite CE paragraph # (307-312) in Order 1050.1 E - Date of land acquisition or signed purchase agreement USE ONLY 11/2004 - Date of pavement maintenance program a - 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 SPONSOR'S SIGNATURE: PRINTED NAME: Minnetta Gardinier TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 DATE: Agc ZO/S-- Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 22 of 69 Iowa City Municipal Airport ACIP Data Sheet Cost Estimate Runway 12-30 Obstruction Mitigation November 4, 2015 Item Unit I Quantity I Unit Price I Total Tree Removal EA 98 $ 4,500 $ 441,000 Tree Replacement EA 98 $ 1,500 $ 147,000 Avigation Easement EA 52 $ 1,200 $ 62,400 Engineering, Legal, Administration LS 1 $ 149,600 $ 149,600 $800,000 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 23 of 69 C1P DATA SHEET Iowa City Municipal Airport logy 2 Runway 25 Threshold Relocation s W F i i d Y JUSTIFICATION: 2018 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,100 State $0 Local (10%) $ 80,000 Total $ 310,000 SPONSOR'S VERIFICATION: Date (see instruction sheet or point mouse over each date box for more information) For each and every project 611412001 - 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.1 E 1112004 - Date of land acquisition or signed purchase agreement - 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 - Dare statement submitted for runway approaches are clear of obstructions SPONSOR'S SIGNATURE: 01 PRINTED NAME: Minnetta Gardinier TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 24 of 69 Iowa City Municipal Airport ACIP Data Sheet Cost Estimate Runway 25 Threshold Relocation November 4, 2015 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 SIFT 88,000 $ 1.25 $ 110,000.00 Taxiway Light Removal EACH 8 $ 75.00 $ 600.00 Runway Light Removal EACH 8 $ 75.00 $ 600.00 Runway Li ht I EACH 1 16 $ 1,200.001 $ 19.200.00 Conduit SFT 1,700 $ 6.00 $ 10,200.00 Wiring LIFT 3,4001 $ 1.50 $ 5,100.00 Engineering, Legal, Administration 1 1 $ 48,000.00 TOTAL $ 310,000.00 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 25 of 69 CIP DATA SHEET AIRPORT LOCID LOCAL PRIORITY PROJECT Airfield Pavement Maintenance Identify FFYthat you co DESCRIPTIO desire to construct N (FFY: Oct. 1-Sept. 30) 5KETGH: The existing eastern section of Runway 7126 was reconstructed in 2008. Many of the pavement joints are in need of replacement and resealing. There is also some corner spelling 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%) $ 284,580 State $0 Local (10%) $ 31,620 Total $ 316,200 SPONSOR'S VERIFICATION: Date (see instruction sheet or point mouse over each date box for more information) For each and every project 6/1412001 - 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.1 E - Date of land acquisition or signed purchase agreement FAA USE ONLY 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 - Date statement submitted for runwav aooroaches are clear of obstructions SPONSOR'S SIGNATURE: DATE:G PRINTED NAME: Minnetta Gardinier TITLE: Airport Commission Chair PHONE NUMBER: (319) 356-5045 FAA USE ONLY Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 26 of 69 Airfield Pavement Maintenance Iowa City Municipal Airport Iowa City, Iowa November 4, 2015 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 Airport Commission Agenda 8, Info Packet G%IOWADOT Meeting Date: 10-20-16 Page 27 of 69 Form 291112 (10-15) FIVE-YEAR AIRPORT CAPITAL IMPROVEMENT PROGRAM (CIP) Airport Name: Iowa City Municipal Airport Prepared By: Iowa City Municipal Airport / AECOM Date Prepared: 11/04/15 Telephone: 319-356-5045 E-mail Address: m.gardinierna,gmail.com Date Approved: 11/19/15 Project Description Funding FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Source Runway 12-30 Approach Surface Federal $ 720,000 $ $ $ $ Obstruction Mitigation State $ $ $ $ $ Local $ 80,000 $ $ $ $ Total $ 800,000 $ $ $ $ Runway 25 Threshold Relocation Federal $ $ 279,100 $ $ $ State $ $ $ $ $ Local $ $ 31,000 $ $ $ Total $ $ 310,000 $ $ $ Environmental Assessment - Runway 7 Federal $ $ $ 135,000 $ $ Extenstion State $ $ $ $ $ Local $ $ $ 15,000 $ $ Total $ $ $ 150,000 $ $ Airfield Pavement Maintenance Federal $ $ $ 284,580 $ $ State $ $ $ $ $ Local $ $ $ 31,620 $ $ Total $ $ $ 316,200 $ $ Runway 7 Extension Federal $ $ $ $ 1,459,800 $ State $ $ $ $ $ Local $ $ $ $ 162,200 $ Total $ $ $ $ 1,622,000 $ Terminal Apron Expansion Federal $ $ $ $ $ 1,125,000 State $ $ $ $ $ Local $ $ $ $ $ 125,000 Total $ $ $ $ $ 1,250,000 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 AIRPORT LONG RANGE NEEDS ASSESSMENT FFY 2021 - FFY 2025 Airport Name: Iowa City Municipal Airport Page 28 of 69 Description of Project Funding Total include estimated Fiscal Year Source Estimated Cost Pavement Maintenance - Runway 7/25 West & Runway 12/30 (2022) Federal: 337,500 $ 337,500 State: $ Local: 37,500 $ 37,500 Total: 375,000 $ 375,000 Snow Removal Equipment Storage Building (2023) Federal: 540,000 $ 540,000 State: $ Local: 60,000 $ 60,000 Total: 600,000 $ 600,000 Taxilane Construction (2024) Federal: 211,500 $ 211,500 State: $ Local: 23,500 $ 23,500 Total: 235,000 $ 235,000 Vehicle Parking in Terminal Area (2025) Federal: 540,000 $ 540,000 State: $ Local: 60,000 $ 60,000 Total: 600,000 $ 600,000 Environmental Assessment - Runway 7 Stopway (2026) Federal: 135,000 $ 135,000 State: $ Local: 15,000 $ 15,000 Total: 150,000 $ 150,000 Runway 7 Stopway (2027) Federal: 1,062,000 $ 1,062,000 State: $ Local: 118,000 $ 118,000 Total: 1,180,000 $ 1,180,000 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 29 of 69 Date: October 14, 2016 To: Airport Commission From: Airport Operations Specialist Re: FY2018 Budget Submittal The budget subcommittee (Chairperson, Secretary, and Airport Operations Specialist) met to discuss the FY2018 budget submittal during the past couple of weeks. Following those discussion we are presenting our recommendation for the FY2018 budget. The highlights of the budget are: Projected Revenues: $475,500 (rounded) Projected Expenses: $475,300 (rounded) General Levy Support Ask: $116,000 CIP Funding: $100,000 Operations support Funding: $16,000 Special Projects/Funds $10,000 for 100 year Anniversary Event (to be planned) $10,000 for furniture replace ment/additions to conference room $15,000 HVAC and Other Airport Hangar needs This budget is very similar to the budget we've had in the last couple of years. Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:44 CITY OF IOWA CITY mtharp NEXT YEAR BUDGET DETAIL REPORT PROJECTION: 18100 FY18 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY 850110 Airport Operations 76850110 382100 - Land Rental UNIT COST 2018 DIVISION 2017 - Increased land rent due to additional hangar construction 2016 - Anticipate loss of revenue due to Gilbert Street Lease 76850110 382200 - Building/Room Rental Building Rentals 76850110 384900 - Other Commissions Fuel Sales Commissions 76850110 413000 - Temporary Employees Costs for Airport Commission Minute Writer 76850110 432020 - Annual Audit 76850110 436030 - Transportation Travel to Des Moines and Kansas City Aviation Conferences - 76850110 436050 - Registration Des Moines and Kansas City Aviation Conferences - Seeing increased registration fees 76850110 436060 - Lodging Des Moines and Kansas City Aviation Conferences 76850110 436080 - Meals Des Moines and Kansas City Aviation Conferences 76850110 437010 - Comp Liability Insurance Pollution policy, $19,000 (est), every 3 years, 2015/2018/2021 48,000.00 -275,000.00 -36,500.00 500.00 650.00 1,000.00 1,000.00 500.00 200.00 23,000.00 P 1 bgnyrpts Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:44 CITY OF IOWA CITY mtharp NEXT YEAR BUDGET DETAIL REPORT PROJECTION: 18100 FY18 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY 76850110 437020 - Fire & Casualty Insurance 76850110 437030 - Worker's Comp Insurance 76850110 437041 - Bonding & Other Insurance added normal expenses 76850110 437200 - Loss Reserve Payment Anticipate Loss Reserve Payment 76850110 438010 - Stormwater Utility Charges 76850110 438030 - Electricity 76850110 438050 - Landfill Use Avg Landfill Use 76850110 438070 - Heating Fuel/Gas 76850110 438080 - Sewer Utility Charge 76850110 438090 - Water Utility Charge 76850110 438100 - Refuse Collection Charges 76850110 438110 - Local Phone Service 76850110 442010 - Other Building R&M Services 76850110 442020 - Structure R&M Services 2017 included one time costs for terminal window related repairs UNIT COST 2018 DIVISION 9,113.00 180.00 870.00 5,000.00 14,911.00 19.433.00 81.00 2,495.00 1,576.00 1,759.00 1.651.00 1.038.00 13,351.00 1,000.00 P 2 bgnyrpts Airport Commission Agenda & Info Packet nn PPfin� na}Pin-9n-1F 10/14/2016 15:44 CITY OF IONA CITY P 3 mtharp NEXT YEAR BUDGET DETAIL REPORT bgnyrpts PROJECTION: 18100 FY18 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2018 DIVISION 76850110 442030 - Heating Equipment R&M Services 4,000.00 Avg Expenses - FY15 had larger charges at start of HVAC maintenance contract 2017 - Replaced HVAC Control units in terminal and maintenance shop 76850110 442040 - Cooling Equipment R&M Services 1,641.00 Avg Expenses 76850110 442060 - Electrical & Plumbing R&M Srvc 3,000.00 Avg Expenses 2017 - Previous expenses included water heater replc 76850110 442070 - Bldg Pest Control Services 371.00 76850110 443080 - Other Equipment R&M Services 4,619.00 76850110 445030 - Nursery Srvc-Lawn & Plant Care 42,024.00 76850110 445080 - Snow and Ice Removal 24,000.00 Snow removal portion of maintenance contract and deicing supplies (18,000 for contract, 6,000 for materials) 76850110 445110 - Testing Services 1,028.00 FY2017- 3 year UST Cathodic Protection testing due Annual Line/Leak testing for UST Annual Backflow Testing Services 76850110 446100 - City Attorney Chargeback 7,030.00 76850110 446320 - Mail Chargeback 202.00 76850110 446350 - City Vehicle Replacement Chgbk 19,457.00 Airport Commission Agenda & Info Packet nn PPfin� na}Pin-9n-1F 10/14/2016 15:44 CITY OF IONA CITY P 4 mtharp NEXT YEAR BUDGET DETAIL REPORT bgnyrpts PROJECTION: 18100 FY18 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2018 DIVISION 76850110 446370 - Fuel Chargeback 3,375.00 76850110 446380 - Vehicle R&M Chargeback 27,268.00 76850110 448040 - City Sponsored Event 10,000.00 2018 is 100 year anniversary of airport 76850110 449055 - Permitting Fees 520.00 Avg Annual Fees (previous year had 5 year stormwater permit) 76850110 449060 - Dues & Memberships 1,185.00 Iowa Public Airports Association Iowa Aviation Promotion Group ICCVB 76850110 449120 - Equipment Rental 500.00 Avg equipment rental 76850110 452010 - Office Supplies 372.00 76850110 461040 - Other Agriculture Chemicals 538.00 76850110 466040 - Plumbing Supplies 500.00 Avg Supplies Costs 76850110 466050 - Electrical Supplies 500.00 Avg costs 76850110 466070 - Other Maintenance Supplies 1,500.00 Avg Costs 76850110 467020 - Equipment R&M Supplies 1,500.00 FY16&17 had increased costs associated with fuel tank repairs prior to rehab project Airport Commission Agenda & Info Packet nn PPfin� na}Pin_9n_18 10/14/2016 15:44 CITY OF IONA CITY P 5 mtharp NEXT YEAR BUDGET DETAIL REPORT bgnyrpts PROJECTION: 18100 FY18 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2018 DIVISION 76850110 468030 - Asphalt 100.00 Avg Asphalt Expense 76850110 468050 - Sand 100.00 Avg Sand Expense 76850110 469040 - Traffic Cntrl Imprvmt Supplies 200.00 FY17 included new walkway construction 76850110 469190 - Minor Equipment 500.00 Minor Equipment Purchases FY17 included purchase of solid material spreader for runway deiciing 76850110 469260 - Fire Ext & Refills 500.00 FY16 included multiple exterior cabinet replacements 76850110 473020 - Non -Contracted Improvements 15,000.00 $15,000 HVAC upgrades and other hangar needs 76850110 475010 - Furniture & Office Equipment 10,000.00 Chair replacement and seating capacity enhancement for Airport conference romm TOTAL UNDEFINED PROJECT-78,662.00 TOTAL Airport Operations-78,662.00 TOTAL Airport-78,662.00 TOTAL REVENUE-359,500.00 TOTAL EXPENSE 280,838.00 GRAND TOTAL-78,662.00 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:45 CITY OF IONA CITY mtharp NEXT YEAR BUDGET DETAIL REPORT PROJECTION: 18150 1801 Salary Projection with Temp/OT ACCOUNTS FOR: Airport VENDOR QUANTITY 850110 Airport Operations 76850110 411000 - Perm Full Time 76850110 413000 - Temporary Employees 76850110 414500 - Longevity Pay 76850110 421100 - Health Insurance 76850110 421200 - Dental Insurance 76850110 421300 - Life Insurance 76850110 421400 - Disability Insurance 76850110 422100 - FICA 76850110 423100 - IPERS UNIT COST 2018 DIVISION 59,426.00 500.00 325.00 5.051.00 391.00 148.00 256.00 4,559.25 5,380.65 TOTAL UNDEFINED PROJECT 76,036.90 TOTAL Airport Operations 76,036.90 TOTAL Airport 76,036.90 TOTAL REVENUE .00 TOTAL EXPENSE 76,036.90 GRAND TOTAL 76,036.90 ** END OF REPORT - Generated by Michael Tharp ** P 1 bgnyrpts Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 36 of 69 The Iowa City Municipal Airport, through the direction of the Airport Commission, will provide a safe, cost-effective general aviation airport that creates and enriches economic, educational, health care, cultural, and recreational opportunities for the greater Iowa City area. The Iowa City Airport Commission is a five member commission of Iowa City residents. The Airport Commission duties are as follows: To exercise all the powers granted to cities and towns under Chapter 330 of the Code of Iowa, except the power to sell said airport. To annually certify the amount of taxes within the limitations of the Statutes of the State of Iowa to be levied for airport purposes. All funds derived from taxation or otherwise for airport purposes shall be under the full and absolute control of the Airport Commission, deposited with the City Treasurer, and disbursed only on the written warrants or order of the Airport Commission. • The Iowa City Municipal Airport has secured over $21.7 million in outside grant funding for improvement projects since 2007 • The University of Iowa Center for Computer Aided Design continued to conduct research at their Operator Performance Laboratory at the Airport • The Airport annually hosts the SERTOMA fly-in/drive-in pancake breakfast and car show • The Iowa Department of Transportation estimates that the Airport has an economic impact of over $11 million on the Iowa City area annually Recent Accomplishments: Completed Airport Master Plan update Expanded Aircraft Parking Apron Completed 2 agreements for private hangar construction Staffing: Upcoming Challenges: Obstruction Mitigation obligations Grant funding for projects Use of general levy dollars for matching funds FY2016 FY2017 FY2018 Total FTE's 1.00 1.00 1.00 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 37 of 69 Staffing Level Change Summary: None proposed Service Level Change Summary: None proposed Financial Highlights: Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 38 of 69 Reasenua CONTRIB & BONAl10NS AIRfORTFYI8 PROPOSED SUBMITTAL TO BE DISCUSSED FY2818 FlNANCE PROJECTIONS (Budges as receivetl hand Finanem Del FCNiff R-e Current Budges Year Fri R-e Aauds FY2815 R-e Aauds FY2814 R-ne RepoNng FY2813 R-ne RepoNng M2100 Di&Donations When wm whao whato Taal CONTRIB B DONA11ONS WHO 0.0 So.08 W.88 W.88 W.88 0.0 OTHER dill REVENUE 369103 Reimbof Exenses Se. $2andsh. whato 53,pddhod whato 36930]10-daneous Olberli-i- Se. $1,had.00 What 51,745h0d whato 5.Pi. Taal OTHER MISC REVENUE 0.0 53,750A0 0.0 53,705.80 W.08 W.08 $10.0 IWRFSTRE UES 381103 Interxtonlusestmmts Se. S,1,430hustp Se. S,1,4323l3 198JN 5]]83 51,23,20 Taa INTEREST REVENUES 50.00 U"Ll1.00 50.00 11,0.323R 51,98].M $5]].83 51,23620 Hill 38z1031antl Dental BOW.W 690.W BOW.W 691.99 7938.30 So 108.6D 5.7h. 382203 Buildi Room Rental 5275,030h. 5255,590thend 5275,030h. 5255,mona9 515,Aal.d3 S250382.83 5.1,AmI14 Taal RENTS 5323,000.00 5300,280.00 5323,000.00 5300,281&8 5323,682.16 $300A91A3 S289}053R ROYALTIES AND COMMISSIONS 3811W Tde bone Commission dOA33 Veneta, Machin, Commission Se. 5,2. 579n. 512gese 381903 anercommesions 36sW.ao 33 a4o.ao 5,iiedon. 527,112,40 26969.9a za5.31 Taa ROYALTIESANOCOMMISSONS 536,500.00 533,040.00 536,500.00 533,040.10 $27,44480 $27,049.10 $24,6%31 SAIC0F)a6 ET5 3921W Saleoflantl Se. Se. 930B43 W 212.5h. 5"li'Otun. 3923W SaleoflEui ment Se. Se. Taal SALEOFASSETS 50.00 50.00 50.00 50.00 5930,spl S212,505.00 5336,936D0 TRANSFEM 393120 General Penn 51.th. 5113,209hod 5121,929h. LL.aO 572,142h. 1W D33W Taal TRANSFERS S116,000.00 50.00 S113,209.00 S121,W11M W8,415m $n,342.00 $100,000.00 TaaIREVENUE SL75,500.00 5341,500.00 UT?,709.00 SHO,M36 $134839].1] W11,809.70 $752,282A9 simiUrlevekof Expenses PERSONNEL FY2016 Eapersa ACWaz FY2015 Eaper¢a ACWaz FY2014 BWga WAaualz MExpeaditura RiCiOUBWgatu Aauaz MExpeaditura 411003 perm Eull Time $plA..W $pieO..W $53,614.W $ Pim.94 $55,44286 $S2,61].z9 $49,9ss.1O 41A300 perm PaOTime 413OW Tares, Emplonseas $]SOm $50]m $50]m $]2]50 $31633 $1,W3.53 $Lz4.64 414103 Wenime Wa 4143W TermNaaron Any 414430 TermSinkleave 41pdO Thai Pa/ $50]m $3ssm $50]m $3ssm $3ssm $3ssm $3ssm 421100 HefHnlnnranre $SA51W $SA51W $S,227.00 $4,46].84 $utta.36 $4,650.48 $Dtut.]6 4212m hontal In umna, $391m $391m $338m $331. $3.2al $32684 $3z0A0 421333 Life Insurance $14Bm $14Bm $141m $140]B $144AB $13ss1 $1.. 42. o¢ab.11 Insurance $256m $256m $sszm $24212 $.. $25027 $23s.98 4212300 onemoluYmmtcomcensabn 422100 HCA $Cihi ss $4$s9.ss $4$14.W $4,3813s $L,292.ss $4,105.54 $3,339.9s 423100 IPERS $5,3&].6s $5,3&].6s $5324.00 $5,..13 $SASz.93 $ Pii $4393.57 4. Mon[bly Cellubr/P Albvance Taal PERSONNEL S]6,46130 S]6,03630 S]5,414m ST2,63130 W1,3]5.1] M,450.15 S64,264m RVICS '^ Al Ramennel numbes rani W war Pram France Budget Workshess 431010 Fee cuM [s&Servvss Co 43Cm $1m 10 W. $110m $98m 43. erwass 1010 om ee 43offlue RecordingDoes 40P20 AnnualAudit $6Am $6Am $szm 63A $53.0 $1,8.83 $1,10.5 40tnAppanl a $z,Hp.W 43AJA Man emeen-rvcx O 43Apd Olberh otesnonalSmba $4,626.50 $]SSO.W on. 433030 Long D ista-e er 435056 inn DyS 43505s sarvrax Saes $41z9 W. Couriers 4110. courlea $z329 $1839 $13. 4350W L alportation 519m $19]33 $13m Transportation $1,W1W 51,00000 SLz6.]0 W. W. $13].]6 $63ss rroluniolu)i 43WW Registration on $1,W1W 51, 5349m $198m $1.m 436060 Lodging $50]m an 55W_00 $42]m 5122 51zz C8 $232m $116AB 43W701. Meals neonsTavalEmarse $On0 43 Meals $zWm 52oD.DD $]sm s21W $11D.w hdpn 4.2. compLlablllty Insurance $z3,W1W $4,149.W 5zz,88600 $3,9s111 1$1,..92 521,]96.1R $34m $3AO1.14 $10PD.W 4YADN Fre&CasCamY l nuance $9,113m $9,113m $12$z000 $171. 5151. $11,2. $10653.W 43]030 Workeis Compinsurarca $1mm $1mm $159W $1]lm $62m 4YAK1 mntlin&(hber Insurance $BIOm $BIOm W. 5ez9m Sam W. W. W. W. 437200 FRlaity BOM 43RW Loss Payment $S,W3.W W. $S,W3.W $S,W3.W $S,W3.W $5350.W $ddxhaoh 43W10 aramm tees $14,911.W $14,911.W $20... $1"a"To4 $14,2..o4 $13A51 $11put Dormwaeru0lity 43W3a ElMfillU $19A33.W $19A33.W $33. .W $13,13E 36 $19,z35.8.4 $16A66.33 $16A41.3z 43WSO Landfill $81m $81m $83m $]SA3 W. $35.64 $zO43z Fu 43W]D Heati Fael/Gaz $2395.00 $2395.00 $4227m $2A21.17 $m1 $13,1237.62 $]6 43WW sewer Utility Ca $1376.W $1376.W $1mW $1.81 $1.. $z3]s.]3 $1,0.6 43W90 Water W, Castillo $1,759.00 $1,759.00 $11984.W $1,9... $2336.71 $1,254.97 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 39 of 69 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 40 of 69 mNNza 0]SO1N 0]502N 0]HFIa Orxm HN o9mua N983sa 0901fA N9819a rnfir0er nFm OffsFumN m Grea rl an Off- FUM.M V H..—re T"CGRTALOUTIAT 525Wm S0.00 0]00AIU S!]15M $1889838 N96NlH9aU ]$2$18.511.65 d Hm —MFUMm lO] .O] Gs3.19 35 G93.30 c In and LwOut InreaunaloanT" OTHER RNANCIAL USES $100000.Ip $0.00 50.00 $ 808.11 $1"8193 $295 u5T4a IXPEN5E5 S1]5229.90 53100]820 UOSW5.61 51015 ]5I.91 1182891.00 %17808.16 BudgHS r luz/Belici/ WO.10 $2I021.10 S100000.00 S551u.n 53026 M $128918.70 S111070JO Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 41 of 69 GOALS, OBJECTIVES, and PERFORMANCE MEASURES Strategic Plan Goal: A Solid Financial Foundation Department Goal: Develop and maintain adequate funding mechanisms for airport operations and improvements; increase revenue generated by airport operations. Department Objective: Accelerate loan repayments through the sale of airport land for development. Annual review of hangar rates to maximize revenue. Performance Measures: FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 Revenue Generated through Airport $400,000 $336,936 $212,505 $930,843 $0 Land Sales Inter -Fund Loan Re revenue iy`zrz`��y`zrzK��y`zrz���y`zrztii�y`zrz�� [eIaTTF1��1Tf[.7tihS4- rfitTi1;�E�[rIrxrIrIr1E�[rIrxrIrIrlE�f��c>:y�E3�:ifb'fE�Yi�Y�1■ Strategic Plan Goal Department Goal: Department Objective: Performance Measures: Strategic Economic Development Activities Increase the usefulness of the Airport for economic development. On an annual basis, track the number of flights by type. Allow for privately funded hangar construction. Fuel Flowage, as a Proxy for Airport Activity FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 Jet Fuel Sold 153 65 202 307 27617 263, Av Gas Sold 9525 70 89 634 74097 64 133 819851 469 Total Gallons Sold 224,514 228,983 276,404 281,750 310,084 FY 2012 1 FY 2013 1 FY 2014 1 FY 2015 1 FY 2016 Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 Page 42 of 69 Based Aircraft 84 85 85 85 92 Number of Aircraft Based at IOW Airport Commission Agenda & Info Packet nn PPfin� na}Pin-9n-1F 10/14/2016 15:48 (CITY OF IOWA CITY IP 1 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2017/3 TO 2017/3 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION 76850110 Airport Operations 7600-70-70-850-850100-850110-000-0000-435060- Legal Publications 010238 IOWA CITY PRESS CITI 2727566 0 2017 3 INV P 25.37 091616 165570 Publications 8/1/16 ACCOUNT TOTAL 25.37 7600-70-70-850-850100-850110-000-0000-436060- Lodging 091112 MARRIOTT HOTEL 158822 0 2017 3 INV P 320.26 Pcard P-Card invoice for ACCOUNT TOTAL 320.26 7600-70-70-850-850100-850110-000-0000-438030- Electricity 010319 MIDAMERICAN ENERGY 20160921110733 0 2017 3 DIR P 1,785.05 W092116 371 MidAmBilling 092120 ACCOUNT TOTAL 1,785.05 7600-70-70-850-850100-850110-000-0000-438070- Heating Fuel/Gas 010319 MIDAMERICAN ENERGY 20160921110733 0 2017 3 DIR P 34.59 W092116 371 MidAmBilling 092120 ACCOUNT TOTAL 34.59 7600-70-70-850-850100-850110-000-0000-438100- Refuse Collection Charges 010507 JOHNSON COUNTY REFUS 89499 0 2017 3 INV P 165.00 093016 166568 Refuse & Recycling 010507 JOHNSON COUNTY REFUS 89502 0 2017 3 INV P 30.00 093016 166568 Refuse & Recycling 195.00 ACCOUNT TOTAL 195.00 7600-70-70-850-850100-850110-000-0000-438110- Local Phone Service 011937 AUREON COMMUNICATION 0789004025.2016.09 0 2017 3 INV P 85.80 091616 165500 SEP 2016 INV ACCOUNT TOTAL 85.80 7600-70-70-850-850100-850110-000-0000-442010- Other Building R&M Services 010358 OVERHEAD DOOR COMPAN XW30636 0 2017 3 INV P 97.50 090916 165429 Blown Fuse Replacem 010856 JET AIR INC IOW IVI-16-003265 0 2017 3 INV P 600.00 090916 165374 Cleaning/Janitorial ACCOUNT TOTAL 697.50 7600-70-70-850-850100-850110-000-0000-442070- Bldg Pest Control Services 013610 STANDARD PEST CONTRO 29747 0 2017 3 INV P 30.00 092316 165987 Pest Control Servic ACCOUNT TOTAL 30.00 7600-70-70-850-850100-850110-000-0000-443080- Other Equipment R&M Services 010508 DAN'S OVERHEAD DOORS 448528 0 2017 3 INV P 190.24 093016 166512 Repairs to Vehicle 010856 JET AIR INC IOW IVI-16-003262 0 2017 3 INV P 43.89 090916 165374 Maintenance Reimbur ACCOUNT TOTAL 234.13 Airport Commission Agenda & Info Packet nn PPfin� na}Pin-9n-1F 10/14/2016 15:48 (CITY OF IOWA CITY IP 2 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2017/3 TO 2017/3 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION 7600-70-70-850-850100-850110-000-0000-445030- Nursery Srvc-Lawn & Plant Care 010856 JET AIR INC IOW IVI-16-003264 0 2017 3 INV P 4,500.00 090916 165374 Groundskeeping/Main ACCOUNT TOTAL 4,500.00 7600-70-70-850-850100-850110-000-0000-449120- Equipment Rental 010856 JET AIR INC IOW IVI-16-003262 0 2017 3 INV P 232.67 090916 165374 Maintenance Reimbur ACCOUNT TOTAL 232.67 7600-70-70-850-850100-850110-000-0000-452010- Office Supplies 090215 OFFICEMAX CT*IN#1142 158770 0 2017 3 INV P 253.86 Pcard P-Card invoice for ACCOUNT TOTAL 253.86 7600-70-70-850-850100-850110-000-0000-461040- Other Agriculture Chemicals 010856 JET AIR INC IOW IVI-16-003262 0 2017 3 INV P 129.13 090916 165374 Maintenance Reimbur ACCOUNT TOTAL 129.13 7600-70-70-850-850100-850110-000-0000-466050- Electrical Supplies 010856 JET AIR INC IOW IVI-16-003262 0 2017 3 INV P 42.00 090916 165374 Maintenance Reimbur ACCOUNT TOTAL 42.00 7600-70-70-850-850100-850110-000-0000-466070- Other Maintenance Supplies 010856 JET AIR INC IOW IVI-16-003262 0 2017 3 INV P 1,308.09 090916 165374 Maintenance Reimbur ACCOUNT TOTAL 1,308.09 7600-70-70-850-850100-850110-000-0000-469200- Tools 010856 JET AIR INC IOW IVI-16-003262 0 2017 3 INV P 174.90 090916 165374 Maintenance Reimbur ACCOUNT TOTAL 174.90 7600-70-70-850-850100-850110-000-0000-473010- Contracted Improvements 010319 MIDAMERICAN ENERGY Gas Extension - Airp 0 2017 3 INV P 9,932.22 091616 165600 Extend Gas Utility ACCOUNT TOTAL 9,932.22 ORG 76850110 TOTAL 19,980.57 FUND 7600 Airport TOTAL: 19,980.57 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IONA CITY P 1 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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,032.40 .00-44,967.60 6.3%* 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-68,058.33 .00-206,941.67 24.7%* 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 nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IONA CITY P 2 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IONA CITY P 3 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 -9,368.00 .00 -27,132.00 25.7%* 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 -28,302.28 .00 -84,906.72 25.Oo* Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IOWA CITY P 4 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 13,703.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 176.25 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 44,910.57 23.4% WARRANT=070216 RUN-1 WARRANT-071616 RUN-1 FY16 PAYROLL ACCRUAL ORIGINAL BUDGET 2017 .00 323.75 35.3% WARRANT-071616 RUN-1 ORIGINAL BUDGET 2017 .00 500.00 .0% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 mtharp FOR 2017 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 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,262.64 .00 3,964.36 24.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 85.44 .00 252.56 25.3% 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 36.30 .00 108.70 25.0% 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 nn PPfin� na}Pin-qn-lF 10/14/2016 15:47 mtharp FOR 2017 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 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 62.37 .00 189.63 24.8% 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,052.15 .00 3,461.85 23.3% 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,239.47 .00 4,084.53 23.3% 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 10/14/2016 15:47 CITY OF IONA CITY P 7 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 10/14/2016 15:47 CITY OF IONA CITY P 8 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 mtharp FOR 2017 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 31, 2016 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 9 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 437020 Fire & Casualty Insurance 850110 Airport Operations 76850110 437020 Fire & Casualty In 12,524 0 12,524 7,553.00 .00 4,971.00 60.3% 07/01/16 BUC 12,524 ORIGINAL BUDGET 2017 437030 Worker's Comp Insurance 850110 Airport Operations 76850110 437030 Worker's Comp Insu 159 0 159 181.00 .00 -22.00 113.8%* 07/01/16 BUC 159 ORIGINAL BUDGET 2017 437041 Bonding & Other Insurance 850110 Airport Operations 76850110 437041 Bonding & Other In 875 0 875 .00 .00 875.00 .0% 07/01/16 BUC 875 ORIGINAL BUDGET 2017 437200 Loss Reserve Payment 850110 Airport Operations 76850110 437200 Loss Reserve Pavme 5,000 0 5,000 5,000.00 .00 .00 100.0% 07/01/16 BUC 5, 000 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IONA CITY P 10 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 ACCOUNTS FOR: 76850110 Airport Operations 438010 Stormwater Utility Charges ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 850110 Airport Operations 76850110 438010 Stormwater Utility 14,911 07/20/16UBB C-160720160720 07/01/16 BUC 14,911 438030 Electricity 850110 Airport Operations 76850110 438030 Electricity 20,198 07/26/16 API VCH IN20160726091244 07/26/16 API VCH IN20160726091244 07/26/16 API VCH IN20160726091244 07/26/16 API VCH IN20160726091244 07/26/16 API VCH IN20160726091244 07/26/16 API VCH IN20160726091244 07/26/16 API VCH IN20160726091244 07/26/16 API VCH IN20160726091244 07/31/16 GNI REVERSAL KD 07/01/16 BUC 20,198 438050 Landfill Use 850110 Airport Operations 76850110 438050 Landfill Use 83 07/01/16 BUC 83 JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 0 14,911 4,733.16 1,577.72 0 20.198 0 83 3,909.77 441.74 14.90 .39 1,126.45 .39 .39 32.23 198.88 -1,404.54 M .00 10,177.84 31.7% ORIGINAL BUDGET 2017 00 16,288.23 19.4% MIDAMERICAN E#325 MIDAMERICAN E#325 MIDAMERICAN E#325 MIDAMERICAN E#325 MIDAMERICAN E#325 MIDAMERICAN E#325 MIDAMERICAN E#325 MIDAMERICAN E#325 MIDAMERICANJULYPAYMENT ORIGINAL BUDGET 2017 .00 83.00 .0% ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 75.09 .00 4,151.91 1.8% 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 541.81 .00 1,339.19 28.8% 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 570.37 .00 1,413.63 28.7% 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 nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IONA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 257.40 .00 1,064.60 19.5% 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 12.66 .00 -12.66 100.0%* 07/31/16 GNI ISICHARGEKD 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 1,897.50 .00 12,171.50 13.5% 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 10/14/2016 15:47 CITY OF IONA CITY P 13 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 0 621 .00 .00 621.00 .0% 07/01/16 HOC 621 ORIGINAL BUDGET 2017 442030 Heating Equipment R&M Services 850110 Airport Operations 76850110 442030 Heating Equipment 3,000 0 3,000 .00 .00 3,000.00 .0% 07/01/16 HOC 3, 000 ORIGINAL BUDGET 2017 442040 Cooling Equipment R&M Services 850110 Airport Operations 76850110 442040 Cooling Equipment 1,083 0 1,083 528.00 .00 555.00 48.8% 07/01/16 HOC 1,083 ORIGINAL BUDGET 2017 442060 Electrical & Plumbing R&M Srvc 850110 Airport Operations 76850110 442060 Electrical & Plumb 4,459 0 4,459 .00 .00 4,459.00 .0% 07/01/16 HOC 4,459 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet nn PPfin� na}Pin-9n-1F 10/14/2016 15:47 CITY OF IONA CITY P 14 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 80.00 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 18,294.60 07/11/16API VCH INIVI-16-002274 4,500.00 07/01/16 BUC 41,529 .00 162.00 33.1% ORIGINAL BUDGET 2017 .00 4,676.33 33.2% ORIGINAL BUDGET 2017 .00 403.00 .0% ORIGINAL BUDGET 2017 .00 23,234.40 44.1% JET AIR INC I#160985 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet 10/14/2016 15:47 CITY OF IONA CITY P 15 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 445080 Snow and Ice Removal 850110 Airport Operations 76850110 445080 Snow and Ice Remov 29,000 0 29,000 .00 .00 29,000.00 .0% 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 27.84 .00 188.16 12.9% 07/31/16 GNI July 2016KD 9.72 Storage of Email 07/01/16 BUC 216 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet 10/14/2016 15:47 CITY OF IONA CITY P 16 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 446130 ITS-PC/Peripheral/Tablet S/R 850110 Airport Operations 76850110 446130 ITS-PC/Peripheral/ 6,909 0 6,909 2,949.30 .00 3,959.46 42.7% 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 .00 .00 8,761.00 .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 .00 .00 216.00 .0% 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 nn PPfin� na}Pin-9n-1F 10/14/2016 15:47 CITY OF IONA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 31, FOR 2017 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET 2016 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 337.50 .00 1,040.74 24.5% 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 36.33 .00 163.67 18.2% 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 4,752.23 .00 13,491.77 26.0% 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 nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 mtharp FOR 2017 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IONA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 31, 2016 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 18 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 446370 Fuel Chargeback 850110 Airport Operations 76850110 446370 Fuel Chargeback 5,258 0 5,258 1,049.27 .00 4,208.73 20.0% 07/31/16 GNI EQUIPMENTHBKEQ 329.89 JUL DIVISION FUEL 07/01/16 BUC 5,258 ORIGINAL BUDGET 2017 446380 Vehicle R&M Chargeback 850110 Airport Operations 76850110 446380 Vehicle R&M Charge 27,733 0 27,733 2,278.44 .00 25,454.56 8.2% 07/31/16 GNI EQUIPMENTHBKEQ 510.87 JUL DIVISION SERVICE 07/01/16 BUC 27,733 ORIGINAL BUDGET 2017 449055 Permitting Fees 850110 Airport Operations 76850110 449055 Permitting Fees 440 0 440 .00 .00 440.00 .0% 07/01/16 BUC 440 ORIGINAL BUDGET 2017 449060 Dues & Memberships 850110 Airport Operations 76850110 449060 Dues & Memberships 1,185 0 1,185 .00 .00 1,185.00 .0% 10/14/2016 15:47 mtharp FOR 2017 03 ACCOUNTS FOR: 76850110 Airport Operations Airport Commission Agenda & Info Packet Meeting Date: 10-20-16 CITY OF IONA CITY P 19 YEAR-TO-DATE BUDGET REPORT Iglytdbud JULY 1, 2016 - SEPTEMBER 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 nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IONA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES P 20 glytdbud 2017 1 TO 2017 1 AVAILABLE PCT BUDGET USED 455120 Misc Computer Hardware 850110 Airport Operations 76850110 455120 Misc Computer Hard 193 0 193 .00 .00 193.00 .0% 07/01/16 HOC 193 ORIGINAL BUDGET 2017 461040 Other Agriculture Chemicals 850110 Airport Operations 76850110 461040 Other Agriculture 336 0 336 129.13 .00 206.87 38.4% 07/01/16 HOC 336 ORIGINAL BUDGET 2017 466050 Electrical Supplies 850110 Airport Operations 76850110 466050 Electrical Supplie 445 0 445 242.95 .00 202.05 54.6% 07/01/16 HOC 445 ORIGINAL BUDGET 2017 466070 Other Maintenance Supplies 850110 Airport Operations 76850110 466070 Other Maintenance 583 0 583 1,347.26 .00 -764.26 231.1%* 07/01/16 HOC 583 ORIGINAL BUDGET 2017 Airport Commission Agenda & Info Packet 10/14/2016 15:47 CITY OF IONA CITY P 21 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 11.58 .00 1,365.42 .8% 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 10/14/2016 15:47 CITY OF IONA CITY P 22 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 0 400 174.90 400 324 0 324 .00 324 0 0 0 78.83 0 0 0 259,932.22 .00 225.10 43.7% ORIGINAL BUDGET 2017 .00 324.00 .0% ORIGINAL BUDGET 2017 00 -78.83 100.0%* 00-259,932.22 100.0%* Airport Commission Agenda & Info Packet nn PPfin� na}Pin_gn_lF 10/14/2016 15:47 CITY OF IONA CITY P 23 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 ACCOUNTS FOR: 76850110 Airport Operations 473020 Non -Contracted Improvements 850110 Airport Operations 76850110 473020 Non -Contracted Imp 07/01/16 BUC TOTAL Airport Operations TOTAL REVENUES TOTAL EXPENSES ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET JOURNAL DETAIL 2017 1 TO 2017 1 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 20,000 0 20,000 .00 20, 000 -100,000 0 -100,000 235,199.21 -472,709 0 -472,709 -107,290.71 372.709 0 372.709 342.489.92 7,450.00 12,550.00 37.3% ORIGINAL BUDGET 2017 7,450.00-342,649.21-242.6% .00-365,418.29 7.450.00 22.769.08 Airport Commission Agenda & Info Packet nn PPfin� na}Pin-qn-1F 10/14/2016 15:47 CITY OF IONA CITY P 24 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - SEPTEMBER 31, 2016 FOR 2017 03 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 235,199.21 7,450.00-342,649.21-242.6% ** END OF REPORT - Generated by Michael Tharp ** JOIN US FOR... Airport Commission Agenda &Info Packet \\.J11/ Meeting Date: 10-20-16 Page 69 of 69 A reception to honor Henry L. fisk, architect of record for the Iowa City Municipal Airport, 1801 S. Werside Dr. Iowa City, and many other mid-century modern gems in the area from P3462. HENRY FISK Thursday Nov 3, 2 016 5:30-7pm Iowa City Airport: I 01 South Riverside Drive, Iowa City, IA 52246 Short Program of Speakers at 6:15pm Learn about mid-century architecture and preservation in Johnson County fnjoy slides of fisk, and fisk/Wehner designs by architect Roland Wehner. MEET OUR SPONSORS: UICCU,1y THRIVING AMIDST CHAOS ® COMMUNITY thriving � MAD MODERN FURNISHINGS CREDIT UNION Liz LIZ FIRMSTONE, REALTOR' NEW PIONEER CO-OP