Loading...
HomeMy WebLinkAbout07-20-2017 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JULY 20, 2017 - 6:00 P.M. 1. Determine Quorum 2. Election of Officers a. Chairperson b. Secretary 3. Approval of Minutes from the following meetings: 2 min* June 27. 2017 4. Public Discussion - Items not on the agenda 5 min 5. Items for Discussion / Action: a. FAA/IDOT Projects: AECOM / David Hughes 15 min i. Obstruction Mitigation ii. South Taxiway Extension iii. North T -Hangar Restroom 1. Consider a resolution accepting bids and awarding contract b. Strategic Plan 60 min c. Airport "Operations" 15 min i. Budget ii. Management iii. Events 1. SERTOMA d. FBO / Flight Training Reports 15 min i. Jet Air e. Commission Members' Reports 2 min f. Staff Report 2 min g. 100 Year Anniversary Committee 5 min 6. Set next regular meeting for August 17, 2017 at 6:00 p.m. 7. New Hangar Tour 8. 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 If you will need disability -related accommodations in order to participate in this program/event, please contact Michael Tharp, Airport Operations Specialist, at 319-356-5045 or at michael-tharp(Diowa- city.org. Early requests are strongly encouraged to allow sufficient time to meet your access needs. Airport Commission Agenda & Info Packet Meeting Date: July 20, 2017 Page 2 of 36 June 27, 2017 Page 1 MINUTES DRAFT IOWA CITY AIRPORT COMMISSION JUNE 27, 2017 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Minnetta Gardinier, A. Jacob Odgaard, Chris Ogren Members Absent: Julie Bockenstedt, Robert Libby Staff Present: Michael Tharp, Eric Goers, Simon Andrew Others Present: Matt Wolford, David Hughes, Christopher Lawrence, Regenia Bailey RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM: Odgaard called the meeting to order at 6:01 P.M. APPROVAL OF MINUTES: Minutes from the May 25, 2017, meeting were reviewed first. Ogren stated that she had one small point, on the last page where the conversation is about the Young Eagles. It states, "Tharp noted .... with the EAA Chapter out of Cedar Rapids." Ogren stated that technically this Chapter is Iowa City and Cedar Rapids, and she suggested adding Iowa City. Gardinier moved to accept the minutes of the May 25, 2017, meeting as amended. Ogren seconded the motion. The motion carried 3-0; Bockenstedt and Libby absent. PUBLIC DISCUSSION: At this point, Chairperson Odgaard asked Tharp to introduce the newest Commission Member. Tharp stated that they had several guests present this evening and he proceeded to introduce Chris Lawrence, the newest Airport Commission Member. His term will start July 1. Tharp also introduced Simon Andrew from the City Manager's office. Ogren then introduced herself to Chris Lawrence, as did others present. ITEMS FOR DISCUSSION/ACTION: a. FAA/IDOT Projects: AECOM / David Hughes i. Obstruction Mitigation — Hughes noted that at the last meeting this item was being held up by the FAA's response. He stated that this issue has been resolved and they now will see if they have a grant application going back to the FAA, based on the original numbers presented and the independent fee estimate that they requested be done. Tharp stated that June 27, 2017 Page 2 Airport Commission Agenda & Info Packet Meeting Date: July 20, 2017 Page 3 of 36 due to a short turn -around time, it would be useful to authorize the Chair to sign the grant once it is received. 1. Consider a resolution authorizing Chair to sign grant offer — Odgaard moved to approve Resolution #A17-09, authorizing the Chair to sign the grant offer once received. Gardinier seconded the motion. The motion carried 3-0, Bockenstedt and Libby absent. Hughes spoke to what the plans are once they can move forward with this. He noted some general timeframes, including what would be due to the FAA at the end of September, along with a draft version of the EA for review mid to late October. That would be followed up with a public comment period, and then the final version of the EA shortly after the first of the year, with finish of the EA being anticipated by May of 2018. ii. South Taxiway Extension — Hughes stated that this is under construction currently, with the rock and storm sewer in place now. The next phase will be paving, according to Hughes. He noted that they had to make some adjustments with the apron they were planning for, and that they will be having Metro put some additional concrete in to adjust the grades. He then responded to Member questions regarding these adjustments and the project in general. iii. North T -Hangar Restroom — 1. Public Hearing — The public hearing was opened at 6:16 P.M. by the Chair. Tharp briefly reviewed this project, noting that it is to add a restroom to hangar B on the south side. The storage area that was there is being removed in order to do this. Tharp stated that the State is putting in 70% of the funds for this project. He then gave Members a brief rundown of the timeframes involved. The public hearing was closed at 6:20 P.M. 2. Consider a resolution authorizing plans, specifications, form of contract and authorizing bid — Gardinier moved to approve Resolution #A17-10, authorizing plans, specifications, form of contract, and authorizing bid. Ogren seconded the motion. The motion carried 3-0, Bockenstedt and Libby absent. b. Strategic Plan — Regenia Bailey started off the strategic planning session by stating that they would be holding off on the SWOT analysis until Jeff Davidson is able to join them. She noted that he had a previously scheduled trip and therefore is unable to attend this evening. Bailey stated that they would be focusing on the 'mission' and `vision' statements this evening, with the objective being to look at the current statements and decide if any changes are desired. Beginning the review, Bailey began with the mission statement portion, noting that basically it states the organization's reason or purpose. She added that ideally it should be both unifying and inspiring internally, as well as concise and clear. Externally the mission statement should be clarified. Moving on to the vision statement, Bailey stated that this is what is seen in the future, if the organization is successful. This is more aspirational in nature. Continuing, Bailey further clarified what these statements are meant to do. She shared with Members what the Airport's current statements are. Bailey then asked Members to start a discussion regarding their mission and vision statements and what they may propose changing. Gardinier stated that for the June 27, 2017 Page 3 Airport Commission Agenda & Info Packet Meeting Date: July 20, 2017 Page 4 of 36 vision statement, she would question 'meets the needs of its stakeholders.' She asked what 'its' refers to here, the City of Iowa City or the Airport. Gardinier believes the current vision statement is more of a mission statement, as Bailey had alluded to. Bailey asked if other Members agree that the current vision statement should become the new mission statement. Members then discussed some possible word changes to the statement. Bailey suggested clarifying wording where possible, in order to provide accurate information to anyone reading the strategic plan. Members continued to discuss the wording for the mission and vision statements, and how perceptions by the public should be taken into account. Ogren suggested the wording of 'directed by the Airport Commission,' rather than 'through the direction of.' Matt Wolford with FBO Jet Air also made some suggestions about moving wording around. Another suggestion was made to change 'area' to 'community.' Gardinier read the current version being discussed: The Iowa City Municipal Airport, directed by the Airport Commission, provides for safe, cost effective general aviation that creates and enriches...., as Members continued to discuss the wording. Ogren then suggested: The Iowa City Municipal Airport, directed by the Airport Commission, provides a safe, cost effective general aviation facility. The Airport creates and enriches economic, educational, etc. Tharp suggested using the full name of the Airport throughout the statement. Some Members agreed that they prefer the statement broken down into two sentences. Odgaard stated that he would almost prefer one sentence here. Bailey stated that she will draft this both ways, so that Members can think about it and then revisit it at the next meeting. Ogren then reviewed changes that Wolford had suggested, such as '....through providing a safe, cost effective general aviation,' portion being moved, which would eliminate the 'that creates' portion of the statement. Reading the statement suggestions again, Wolford stated: The Iowa City Municipal Airport, directed by the Airport Commission, creates and enriches the economic, educational, healthcare, cultural, and recreational opportunities for the greater Iowa City community through safe and cost effective general aviation.' Moving on to the current mission statement becoming the vision statement, Bailey noted that Ogren had said it was a pretty generic statement. Bailey added that in strategic planning, you do not always need to have a vision statement. Members continued their discussion on this issue, with Ogren asking if there is truly a need for a vision statement, that perhaps it is to continue to do the mission. Gardinier stated that she believes they do need it, that they should aspire to be more. Bailey asked the group what aspirations they may have for the Iowa City Municipal Airport, as it goes about its new mission basically. Odgaard responded that in a sense it is to make the Airport a more prominent community facility than it is today, in order to look forward to an even better facility. He believes the Airport should be more integrated with the community than it currently is. Ogren made the suggestion of: ....will continue to provide all of the things above in a way that is integral to the Iowa City community. Others agreed, noting that the Airport needs to be seen as an asset to the entire community, not just the aviation community. The discussion continued, with Members discussing just what it is the Airport is attempting to 'foster' in the community. Odgaard responded that he sees it as recognition of the University and fostering awareness of the potentials for the Airport, or something to that June 27, 2017 Page 4 Airport Commission Agenda & Info Packet Meeting Date: July 20, 2017 Page 5 of 36 effect. Bailey suggested `community pride,' and Odgaard agreed. Bailey asked if Members want to say something regarding the programming that takes place at the Airport. The suggestion was made `...fostering involvement of all ages,' and 'building a sense of community around the Airport.' The other Members were impressed with these suggestions. Bailey continued to ask Members if they had any other key words they wanted to add to the statement, and Members continued to discuss just what it is they want to convey to the public. Bailey stated that what she is hearing is that the group wants the Iowa City area to see the Iowa City Municipal Airport as an asset or integral to the community. Gardinier brought up a comment from the Pekin Municipal Airport: '...will serve as a crucial component of the Pekin and greater Peoria area transportation infrastructure and play a critical role in the advancement, growth, and economic development of the region.' This comes from a combined mission and vision statement, according to Gardinier. Odgaard spoke to how the Airport can be a driver for economic growth. Bailey suggested using: `....that supports or drives or contributes to the area's economic vitality,' or something along those lines. She stated that she and Davidson will work with these suggestions to come up with a draft for the next meeting. Regarding the public surveys, Bailey noted that they received 575 responses, with 80% from Iowa City. She relayed the various avenues used to get information about the survey out to the public. C. Airport Operations i. Budget — Tharp noted that the fiscal year is just about over. He stated that there aren't any real surprises in the budget and they should have a stable year-end. Odgaard asked if Tharp had prepared a graph like he did last year at this time, and Tharp stated that he will try to have this for the next meeting. 1. FY2018 Preview— Tharp noted that there are two key points in this budget — the initial funding for the 100 -year anniversary event and $5,000 for furniture replacement in the conference room. ii. Management — Tharp noted that they are currently working through the strategic planning process. iii. Events 1. Young Eagles — June 10 and 17 were Young Eagle events. Tharp noted that June 10 was the originally scheduled date, but this had to be cut short due to high winds. 2. SERTOMA — This event is planned for August 20. Tharp noted that this is a week earlier than normal. Mid -American Energy — Tharp stated that this came to the Commission last year, as well, but due to various reasons it was deferred. He noted that they now know the actual location of the gas line and would like to be able to recommend approval to the City Council. Tharp briefly responded to Member questions regarding this issue. i. Consider a resolution recommending Council approve a utility easement— Ogren moved approval of Resolution #A17-11, recommending the City Council approve a utility easement with Mid - American Energy. Odgaard seconded the motion. The motion carried 3-0, Bockenstedt and Libby absent. Airport Commission Agenda & Info Packet Meeting Date: July 20, 2017 Page 6 of 36 June 27, 2017 Page 5 e. North Commerce Park Outlot B — Tharp stated that Outlot B is the small parcel located between the Alexis Park Inn and Ruppert Road. Members briefly discussed the offer of $20,000, which Tharp noted is backed up by an appraisal. i. Consider a motion recommending Council accept purchase offer — Odgaard moved to recommend to the City Council acceptance of the purchase offer. Ogren seconded the motion. The motion carried 3- 0, Bockenstedt and Libby absent. FBO / Flight Training Reports i. Jet Air — Matt Wolford shared the monthly maintenance reports with the Commission. He stated that May continued with the usual types of maintenance being done — light bulb replacement, grass mowing, and trash pick up. In June they have been doing some weed control around the hangars. An expensive item noted was the filter replacements for the various fuel system components. Wolford noted that they were able to spread some grass seed around the new hangar area, in hopes that the rain will get it started. Moving on to Jet Air business, Wolford noted that the big news is the completion of the hangar. He stated that Jet Air is looking forward to being able to use the new space. The shop has been keeping busy, with Wolford noting the addition of another mechanic. Charter flights have been busy, as well, especially in the business sector. Wolford also noted an increase in the flight training. Wolford stated that he would like to show the Commission the new hangar sometime soon, and Odgaard suggested at the next meeting. Gardinier suggested that they consider adding a flat screen monitor to the main area of the terminal building that could be used to show recent student pilots who have earned their license, for example, or to do some marketing for the Airport. She added that she has seen these used at other airports around the country. Tharp and Wolford will work together on the flat screen monitor idea. Commission Members' Reports — Gardinier stated that this year's Air Race Classic was very successful. She earned third place this year, her best race yet. Ogren shared that they were at the EAA Chapter meeting this past weekend. She also stated that she was able to meet Congressman Dave Loebsack recently, along with Wolford and Tharp last week. Ogren noted that she will be gone for two weeks, should Tharp need an interim Chair during Odgaard's absence. Odgaard stated that he leaves Friday for Beijing and returns the following Friday. Staff Report — Tharp also noted Congressman Loebsack's visit and what they were able to briefly discuss. He then noted that he was able to speak with Bockenstedt recently and she asked that he extend her thanks to the Commission. Ogren stated that she wanted to add one more comment about the Loebsack visit. She noted that Tharp and Wolford were very impressive in their representation of the Airport. The discussion turned briefly to drones and the use of them in the immediate area. Gardinier asked if they have considered switching out the current hangar lights for LED ones. Tharp stated that they have not, as the bulbs are basically the renter's responsibility and the renter can put in LED bulbs if desired. Odgaard then spoke about the hangars up in Dubuque, June 27, 2017 Page 6 Airport Commission Agenda & Info Packet Meeting Date: July 20, 2017 Page 7 of 36 noting that they have a fresh coat of paint on them. He asked how often the Airport does this. Tharp noted that it does not happen very often, but that they do have a project to `reskin' the hangars on their list of projects for the future. Odgaard asked if this is something they should do prior to any 100 -year anniversary celebration. Members agreed that they should look into this further. 100 -year Anniversary Committee — Ogren stated that she has not yet received any responses on the form she sent out. Tharp stated that he is over 50% done with his portion. SET NEXT REGULAR MEETING FOR: The next regular meeting of the Airport Commission will be held on Thursday. July 20, 2017, at 6:00 P.M. in the Airport Terminal Building. ADJOURN: Ogren moved to adjourn the meeting at 7:52 P.M. Odgaard seconded the motion. The motion carried 3-0, Bockenstedt and Libby absent. CHAIRPERSON DATE June 27, 2017 Page 7 Airport Commission Agenda & Info Packet Meeting Date: July 20, 2017 Page 8 of 36 Airport Commission ATTENDANCE RECORD 2017 Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time TERM O O O O O O O O O O O O V co co w O N N W A N T NAME EXP. a) NO a) N ao 3 N 3 N O 3 -4 N 3 m 3 m 3 m 3 N O 3 N ui 3 N a) O O a) O T T T 0) T T V V V V V V Minnetta 07/01/19 O/ O/ Gardinier O/E X X X X X X X X X X E 'E X Chris 07/01/18 O Ogren / X X X E X X X X X X X X X X A.Jacob 07/01/18 01 Odgaard X X X X X X X X X X E X X X Julie 07/01/17 O O Bockensted / / O/ O/ t X X E X E X X X X X X E X E Robert 07/01/20 O Libby / O/ O/ X X E X X O O E X X X X X E Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time Anpod Comm asnn Agenda & Info Packet Meeting Data Ju1y20, 20Lj 07/14/2017 12:33 (CITY OF IOWA mtharp INVOICE LIST YEAR/PERIOD: 2017/12 TO 2017/12 ACCOUNT/VENDOR INVOICE CITY BY GL ACCOUNT PO YEAR/PR TYP S WARRANT CHECE P 1 apinvgla DESCRIPTION 76850110 Airport Operations 7600-70-70-850-850100-850110-000-0000-432050- Appraisal Services 010679 COOK APPRAISAL 2295 0 2017 12 INV P 1,800.00 062317 185390 Appraisal for Outlo ACCOUNT TOTAL 1,800.00 7600-70-]0-850-850100-850110-000-0000-43]010- Comp Liability Insurance 010046 AW WELT AMORISCO INS 161283 0 2017 12 INV P 2,810.00 063017 185623 6/26/17 INSURANCE R ACCOUNT TOTAL 2,810.00 7600-70-70-850-850100-850110-000-0000-438030- electricity 010319 MIDAMERICAN ENERGY 20170621103622 0 2017 12 INV P 1,584.36 062317 2726 MidAmBilling 062120 ACCOUNT TOTAL 1,584.36 7600-70-]0-850-850100-850110-000-0000-4380]0- Heating fuel/Gas 010319 MIDAMERICAN ENERGY 20170621103622 0 2017 12 INV P 42.58 062317 2726 MidAmBilling 062120 ACCOUNT TOTAL 42.58 7600-70-70-850-850100-850110-000-0000-438100- Refuse Collection Charges 010507 JOHNSON COUNTY REFUS 96974 0 2017 12 INV P 165.00 062317 185449 Refuse S Recycling 010507 JOHNSON COUNTY REFUS 96978 0 2017 12 INV P 30.00 062317 185449 Refuse S Recycling 195.00 ACCOUNT TOTAL 195.00 7600-70-70-850-850100-850110-000-0000-438110- Local Phone Service 011937 AUREON COPII4UNICATION 0789004025.2017.06 0 2017 12 INV P 85.71 061617 185018 JUN 2017 INV ACCOUNT TOTAL 85.71 7600-70-70-850-850100-850110-000-0000-442010- Other Building RGM Services 010856 JET AIR INC IOW IVI-17-001873 0 2017 12 INV P 510.00 060917 184824 Maintenance Reimhur 010856 JET AIR INC IOW IVI-17-001876 0 2017 12 INV P 600.00 060917 184824 Janitorial Services 1,110.00 ACCOUNT TOTAL 1,110.00 7600-70-70-850-850100-850110-000-0000-442020- Structure RSM Services 012238 OTIS ELEVATOR COI4PAN CER65338317 0 2017 12 INV P 180.00 063017 185751 elevator Service an ACCOUNT TOTAL 180.00 7600-70-]0-850-850100-850110-000-0000-4420]0- Bldg Pest Control Services 013610 STANDARD PEST CONTRO 33224 0 2017 12 INV P 30.00 060917 184901 Pest Control Servic ACCOUNT TOTAL 30.00 Anpotl Comm asnn Agenda & Info Packet Meeting Data Ju1y20, 20Lj 07/14/2017 12:33 (CITY OF IOWA CITY mtharp INVOICE LIST BY GL ACCOUNT YEAR/PERIOD: 2017/12 TO 2017/12 P 2 apinvgla ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CBECE DESCRIPTION 7600-70-70-850-850100-850110-000-0000-445030- Nursery Srvc-Lawn S Plant Care 010856 SET AIR INC IOW IVI-17-001873 0 2017 12 INV P 30.18 060917 184824 Maintenance Reimhur 010856 SET AIR INC IOW IVI-17-001875 0 2017 12 INV P 4,500.00 060917 184824 Grcundskeeping/Mowi 7600-70-70-850-850100-850110-000-0000-445110 010931 TANKNOLOGY INC 1210972 010931 TANKNOLOGY INC 1211426 4,530.18 ACCOUNT TOTAL 4,530.18 Testing Services 0 2017 12 INV P 413.50 062317 0 2017 12 INV P 628.50 062317 185527 Annual Line/Leak to 185527 3 Year Cathodic Pro ** END OF REPORT - Generated by Michael Tharp ** 1,042.00 ACCOUNT 'TOTAL 1,042.00 7600-70-70-850-850100-850110-000-0000-466050- Electrical Supplies 010856 SRT AIR INC IOW IVI-17-001873 0 2017 12 INV P 10.52 060917 184824 Maintenance Reimhur ACCOUNT TOTAL 10.52 7600-70-]0-850-850100-850110-000-0000-4660]0- Other Maintenance Supplies 010856 SRT AIR INC IOW IVI-17-001873 0 2017 12 INV P 54.91 060917 184824 Maintenance Reimhur ACCOUNT TOTAL 54.91 7600-70-70-850-850100-850110-000-0000-469360- Food and Beverages 010856 SRT AIR INC IOW IVI-17-001873 0 2017 12 INV P 738.10 060917 184824 Maintenance Reimhur ACCOUNT TOTAL 738.10 7600-70-70-850-850100-850110-000-0000-473020- Non -Contracted Improvements 014375 CUSTOM BUILDERS OF T 79766 0 2017 12 INV P 43,690.00 062317 185393 Shared Construction ACCOUNT TOTAL 43,690.00 ORG 76850110 TOTAL 57,903.36 FUND 7600 Airoort - _ - _ - - - - _ - _ - TOTAL._ - _ - _ - - - - - 57.903.36- - - - - - - - - - - - - - - - - - - - ** END OF REPORT - Generated by Michael Tharp ** Anpod Comm asnn Agenda & Info Packet Meeting Data July20, 201_ 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations (CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - JUNE 30, 2017 ORIGINAL TItAMFR3/ REVISED APPROP ADJSTMTS BUDGET YTD ACTUAL JOURNAL DETAIL 2017 12 TO AVAILABLE EMCU!ffiM ES BUDGET P 1 glytdhud 2017 12 PCT USED 369100 Reimb of expenses 850110 Airport Operations 76850110 369100 Reimb exo 0 0 0 -1,800.00 .00 1,800.00 100.0% 06/19/17CRP 1326846 REVS -1,800.00 ASI 381100 Interest on Investments 850110 Airport Operations 76850110 381100 Int Invest 0 0 0 221.25 .00 -221.25 100.0&* 382100 Land Rental 850110 Airport Operations 76850110 382100 Land Rent -48,000 0 -48,000 -45,123.15 .00 -2,876.85 94.0%* 06/07/17CRP 1323659 FINA -368.75 ARMED FORCES RESERVE 06/28/17GBI 104843 -325.00 LAND RENT 382200 Building/Room Rental 850110 Airport Operations 76850110 382200 BdnaRmRent -275,000 0 -275,000 -265,290.33 .00 -9,709.67 96.5%* 06/28/17GBI 410208 -217.00 HANGAR #46 06/28/17GBI 409163 -151.00 Hangar Rent #26 06/28/17GBI 314170 -151.00 HANGAR #11 06/28/17GBI 405558 -144.00 Hangar #2 Anpont Comm ceann Agenda & Info Packet Meeting Data July20, 20Lj 07/17/2017 14:36 CITY OF IOWA CITY P 2 mtharp YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TItANFR3/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBMANCES BUDGET USED 7 GBI 405441 -144.00 Hangar #10 7 GBI 319397 -358.00 HANGAR #33 7GBI 403578 -110.00 Office Rent (Bldg G) 7GHI 400059 -151.00 HANGAR #15 7 GBI 400246 -144.00 HANGAR #5 7GHI 100686 -210.00 HANGAR #57 7 GBI 105947 -179.00 HANGAR #38 7 GBI 105183 -151.00 HANGAR #27 7 GBI 105172 -332.00 HANGAR #56 7GBI 104275 -144.00 HANGAR #8 7GHI 104090 -4,606.00 D, e, F, H 7 GBI 104090 -500.00 Hangar M 7 GBI 104090 -144.00 HANGAR #1 7GHI 104090 -185.00 HANGAR #59 7 GBI 104090 -185.00 HANGAR #60 7 GBI 104090 -650.00 HANGAR #72 7 GBI 103824 -179.00 HANGAR #51 7 GBI 103759 -151.00 HANGAR #13 7 GBI 103636 -179.00 HANGAR #47 7 GBI 103584 -179.00 HANGAR #42 7 GBI 103583 -4,392.00 HANGAR #35 7 GBI 103583 -652.00 HANGAR #32 7GBI 103574 -144.00 HANGAR #9 7GHI 103503 -310.00 HANGAR #34 7 GBI 103319 -179.00 HANGAR #53 7 GBI 103078 -151.00 HANGAR #16 7 GBI 103026 -151.00 HANGAR #19 7 GBI 102700 -151.00 HANGAR #14 7 GBI 102618 -179.00 HANGAR #40 7 GBI 102617 -210.00 HANGAR #58 7 GBI 102612 -243.00 HANGAR #61 7 GBI 102608 -217.00 HANGAR #55 7 GBI 102608 -650.00 HANGAR #71 7 GBI 102606 -185.00 HANGAR #63 7 GBI 102601 -179.00 HANGAR #49 7 GBI 102597 -179.00 HANGAR #36 7 GBI 102597 -179.00 HANGAR #37 7 GBI 102596 -217.00 HANGAR #45 7 GBI 102592 -151.00 HANGAR #25 7 GBI 102592 -179.00 HANGAR #44 7 GBI 102592 -179.00 HANGAR #50 7 GBI 102592 -151.00 HANGAR #28 7 GBI 102586 -151.00 HANGAR #17 7 GBI 102580 -144.00 HANGAR #6 7GBI 102580 -151.00 HANGAR #30 7 GBI 102578 -151.00 HANGAR #22 7 GBI 102575 -185.00 HANGAR 462 Anpont Comm ceann Agenda & Info Packet Meeting Data July20, 20Lj 07/17/2017 14:36 OF IOWA CITY -179.00 P 3 mtharp (CITY YEAR-TO-DATE BUDGET REPORT -151.00 glytdbud -204.00 JULY 1, 2016 - JUNE 30, 2017 -404.00 HANGAR #31 FOR 2017 12 HANGAR #48 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 06/2'. 384900 /17GBI 102090 /17GHI 101765 /17GHI 101403 /17GHI 101368 /17GHI 101069 /17GBI 100798 /17GHI 100701 /17GHI 100685 /17GBI 100474 /17GBI 100354 /17GBI 100354 /17GBI 100354 /17GBI 100353 /17GBI 100111 /17GBI 100061 Other Commissions 850110 Airport Operations 76850110 384900 Oth C. 06/21/17CRP 1332822 REVS 393120 General Levy 850110 Airport Operations 76850110 393120 Gen Lew 06/30/17GM 060326 REJE#2 411000 Perm Full Time 850110 Airport Operations -36,500 -113,209 -151.00 HANGAR #24 -179.00 HANGAR #43 -151.00 HANGAR #23 -151.00 HARNGAR #21 -204.00 HANGAR #64 -404.00 HANGAR #31 -89.50 HANGAR #48 -89.50 HANGAR #48 -179.00 HANGAR #39 -151.00 HANGAR #12 -100.00 OFFICE SPACE RENT -144.00 HANGAR #7 / JUL 2017 -72.00 HANGAR #7 / 1/2 JUNE 2 -151.00 HANGAR #29 -179.00 HANGAR #54 -179.00 HANGAR #52 0 -36,500 -35,280.30 .00 -1,219.70 96.7%- -3,459.70 EASTERN AVIATION FUELS 0 -113,209 -113,209.00 .00 .00 100.0& -9,434.08 Ptax from Gen Fund Anpont Comm asnn Agenda & Info Packet Meeting Data July20, 20V, 07/17/2017 14:36 OF IOWA CITY P 4 mtharp (CITY YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TItANFE3/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP AEKSTMTS BUDGET YTD ACTUAL EMCUlIDRAMCES BUDGET USED 58,614 0 58,614 56,111.43 .00 2,502.57 95.7% 76850110 411000 Perri FT 06/09/11PRJ 1060317 060317 2,232.00 WARRANT=060317 RUN -1 06/23/17PRJ 1061717 061717 2,232.00 WARRANT -061717 RUN -1 413000 Temporary employees 850110 Airport Operations 76850110 413000 Temo enrol 500 0 500 664.50 .00 -164.50 132.9&* 06/23/17PRJ 1061717 061717 76.00 WARRANT -061717 RM -1 414500 Longevity Pay 850110 Airport Operations 76850110 414500 Longevity 500 0 500 500.00 .00 .00 100.0% 421100 Health Insurance 850110 Airport Operations 76850110 421100 Health Ins 5,227 0 5,227 5,050.56 .00 176.44 96.6% 06/09/17PRJ 1060317 060317 210.44 WARRANT=060317 RM -1 06/23/17PRJ 1061717 061717 210.44 WARRANT -061717 RM -1 421200 Dental Insurance 850110 Airport Operations Anpont Comm ceann Agenda & Info Packet Meeting Data July20, 20Lj 07/17/2017 14:36 OF IOWA CITY P 5 mtharp (CITY YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TItANFE3/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL EMCUlIDRAMCES BUDGET USED 338 0 338 356.88 .00 -18.88 105.6%* 76850110 421200 Dental Ins 06/09/11PRJ 1060317 060317 15.50 WARRANT=060317 RUN -1 06/23/17PRJ 1061717 061717 15.50 WARRANT -061717 RUN -1 421300 Life Insurance 850110 Airport Operations 76850110 421300 Life Ins 145 0 145 145.20 .00 -.20 100.1%* 06/23/11PRJ 1061717 061717 12.10 WARRANT -061717 RUN -1 421400 Disability Insurance 850110 Airport Operations 76850110 421400 DisbltyIns 252 0 252 249.48 .00 2.52 99.0% 06/23/17PRJ 1061717 061717 20.79 WARRANT -061717 RUN -1 422100 FICA 850110 Airport Operations 76850110 422100 FICA 4,514 0 4,514 4,338.08 .00 175.92 96.1% 06/09/11PRJ 1060317 060317 168.83 WARRANT=060317 RUN -1 06/23/11PRJ 1061717 061717 174.70 WARRANT -061717 RUN -1 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 423100 IPERS Anpod Comm asnn Agenda & Info Packet Meeting Data July20, 20V, CITY OF IOWA CITY P 6 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRARFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBMARCES BUDGET USED 850110 Airport Operations 76850110 423100 IPeRS 5,324 06/09/17PR 1060317 060317 06/23/17 PRS 1061717 061717 431020 Court Costs S Services 850110 Airport Operations 76850110 431020 CourtCosts 110 432020 Annual Audit 850110 Airport Operations 76850110 432020 Audit 552 432050 Appraisal Services 850110 Airport Operations 76850110 432050 Appraisal 0 06/15/17API VCH IN2295 0 5,324 5,114.79 199.32 206.11 0 110 .00 0 552 636.90 .00 209.21 96.1% WARRANT=060317 RUN -1 WARRANT -061717 RUN -1 00 110.00 .0% 00 -84.90 115.4%- 0 0 1,800.00 .00 -1,800.00 100.0* 1,800.00 COOK APPRAISA#185390 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operatione 435057 Couriers 850110 Airport Operations 76850110 435057 Couriers 435060 Legal Publications 850110 Airport Operations 76850110 435060 Legal Pubs 436030 Transportation 850110 Airport Operations 76850110 436030 Transport 436050 Registration 850110 Airport Operations Anpont Comm ceann Agenda & Info Packet Meeting Data July20, 20V, CITY OF IOWA CITY P 7 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRARFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBMARCES BUDGET USED 0 0 0 18.50 0 0 0 57.94 1,000 0 1,000 382.56 00 -18.50 100.08* 00 -57.94 100.08 00 617.44 38.38 76850110 436050 Reaistratn 1,000 0 1,000 349.00 .00 651.00 34.98 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 436060 Lodging 850110 Airport Operations Anpont Comm asnn Agenda & Info Packet Meeting Data July20, 20V, CITY OF IOWA CITY P 8 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRARFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCOlR3MARCES BUDGET USED 76850110 436060 Lodaina 500 0 500 460.21 .00 39.79 92.0% 436080 Meals 850110 Airport Operations 76850110 436080 Meals 200 0 200 25.00 .00 175.00 12.5% 437010 Comp Liability Insurance 850110 Airport Operations 76850110 437010 CompLialoty 22,886 0 22,886 6,969.53 .00 15,916.47 30.5% 06/28/17API VCR IN161283 2,810.00 AW WELT AMBRI#185623 437020 Fire S Casualty Insurance 850110 Airport Operations 76850110 437020 Fir&CasIns 12,524 0 12,524 12,011.00 .00 513.00 95.9% 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 437030 Worker's Comp Insurance 850110 Airport Operations 76850110 437030 WrkCom➢Ins 437041 Bonding S Other Insurance 850110 Airport Operations 76850110 437041 Bnd&OthIns 437200 Loss Reserve Payment 850110 Airport Operations 76850110 437200 LossRsvPav 438010 Sto.ter Utility Charges 850110 Airport Operations 76850110 438010 Stater 06/21/17UBB C -170621170621 Anpont Commasbn Agenda & Info Packet Meeting Data July20, 20V, CITY OF IOWA CITY P 9 YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRARFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBMARCES BUDGET USED 159 0 159 181.00 875 0 875 .00 5,000 0 5,000 5,000.00 14,911 0 14,911 18,932.64 1,57772 00 -22.00 113.8%* 00 875.00 .0% 00 .00 100.0% 00 -4,021.64 127.0%* Anpont Comm asnn Agenda & Info Packet Meeting Data July20, 20Lj 07/17/2017 14:36 CITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - JUNE FOR 2017 12 ACCOUNTS FOR: ORIGINAL TItAMFR3/ 76850110 Airport Operations APPROP ADJSTMTS 30, 2017 REVISED BUDGET YTD ACTUAL JOURNAL DETAIL 2017 12 TO AVAILABLE EMCU!ffiM ES BUDGET P 10 glytdhud 2017 12 PCT USED 438030 electricity 850110 Airport Operations 76850110 438030 electricty 20,198 0 20,198 16,999.53 .00 3,198.47 84.2% 06/21/17 API VCH IN20170621103622 993.43 MIDAMERICAN e#2726 06/21/11 API VCH IN20170621103622 1.08 MIDAMERICAN a#2726 06/21/11 API VCH IN20170621103622 50.36 MIDAMERICAN a#2726 06/21/11 API VCH IN20170621103622 188.23 MIDAMERICAN a#2726 06/21/11 API VCH IN20170621103622 333.75 MIDAMERICAN a#2726 06/21/11 API VCH IN20170621103622 1.08 MIDAMERICAN a#2726 06/21/11 API VCH IN20170621103622 1.08 MIDAMERICAN a#2726 06/21/17 API VCH IN20170621103622 1535 MIDAMERICAN e#2726 438050 Landfill Use 850110 Airport Operations 76850110 438050 Landfill 83 0 83 152.89 .00 -69.89 184.2%- 438070 Heating fuel/Gas 850110 Airport Operations 76850110 438070 Heatnafuel 4,227 0 4,227 2,675.16 .00 1,551.84 633k 06/21/17API VCH IN20170621103622 10.00 MIDAMERICAN a#2726 06/21/17API VCH IN20170621103622 10.00 MIDAMERICAN a#2726 06/21/17API VCH IN20170621103622 22.58 MIDAMERICAN a#2726 Anpod Commasbn Agenda & Info Packet Meeting Data July20, 20Lj 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - JUNE ORIGINAL TItAMFR3/ APPROP ADJSTMTS 30, 2017 REVISED BUDGET YTD ACTUAL P 11 glytdbud JOURNAL DETAIL 2017 12 TO 2017 12 AVAILABLE PCT EMCU!ffiM ES BUDGET USED 438080 Sewer Utility Charge 850110 Airport Operations 76850110 438080 Sewer 1,881 0 1,881 2,019.41 .00 -138.41 107.4&* 06/21/17UBB C -170621170621 186.74 438090 Water Utility Charge 850110 Airport Operations 76850110 438090 Water 1,984 0 1,984 2,188.27 .00 -204.27 110.3%* 06/21/17UBB C -170621170621 202.85 438100 Refuse Collection Charges 850110 Airport Operations 76850110 438100 Refuse 1,363 0 1,363 2,340.00 .00 -977.00 171.7%* 06/14/17API VCH IN96974 165.00 JOHNSON COUNT#185449 06/14/17API VCH IN96978 30.00 JOHNSON CIOUNT#185449 438110 Local Phone Service 850110 Airport Operations 76850110 438110 Loc Phone 1,322 0 1,322 1,028.52 .00 293.48 77.8% 06/06/17API VCH IN0789004025.2011.06 85.71 AUREON COMMIUN#185018 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 438120 Long Distance Service 850110 Airport Operations Anpod Comm ceann Agenda & Info Packet Meeting Data Ju1y20, 20V, CITY OF IOWA CITY P 12 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 438120 LD Phone 0 0 0 44.93 .00 -44.93 100.0%* 06/30/17GNI ISICHRGESAO 8.81 CH SUN LONG DIST CHGBK 442010 Other Building RWM Services 850110 Airport Operations 76850110 442010 OthBldgRW1 14,069 0 14,069 10,553.55 .00 3,515.45 75.0& 06/06/17API VCH INIVI-17-001876 600.00 SET AIR INC I#184824 06/06/17API VCH INIVI-17-001873 510.00 SET AIR INC I#184824 442020 Structure RWM Services 850110 Airport Operations 76850110 442020 Struct RWM 621 0 621 2,788.06 .00 -2,167.06 449.0%* 06/23/17API VCH INCER65338317 180.00 OTIS ELEVATOR#185751 442030 Heating equipment RWM Services 850110 Airport Operations 76850110 442030 Heatin RWI 3,000 0 3,000 2,162.59 .00 837.41 72.1& Anpont Commasbn Agenda & Info Packet Meeting Data July20, 20V, 07/17/2017 14:36 OF IOWA CITY 76850110 442040 C00linQR6M P 13 mtharp (CITY YEAR-TO-DATE BUDGET REPORT 850110 Airport Operations glytdbud 76850110 442060 ElecPlmR614 JULY 1, 2016 - JUNE 30, 2017 442070 Bldg Pest Control Services FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TItANFR3/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBMANCES BUDGET USED 442040 Cooling Equipment R6N Services 850110 Airport Operations 76850110 442040 C00linQR6M 1,083 442060 Electrical S Plumbing R6N Srvc 850110 Airport Operations 76850110 442060 ElecPlmR614 4,459 442070 Bldg Pest Control Services 850110 Airport Operations 76850110 442070 Pest Cntrl 242 06/01/17API VCH IM 3224 443050 Radio Equipment R614 Services 850110 Airport Operations 76850110 443050 Radio]ul 6R 0 0 1,083 1,584.00 0 4,459 1,085.34 0 242 569.52 30.00 0 0 112.50 00 -501.00 146.3%* 00 3,373.66 243& .00 -327.52 2353&* STANDARD PEST#184901 00 -112.50 100.0&* Anpont Comm ceann Agenda & Info Packet Meeting Data Ju1y20, 20V, 07/17/2017 14:36 OF IOWA CITY P 14 mtharp (CITY YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - JUNE 30, 2017 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 443080 Other equipment RWM Services 850110 Airport Operations 76850110 443080 Oth eg RWM 6,997 0 6,997 4,377.32 444060 Cahle S Electrical RWM Srvcs 850110 Airport Operations 76850110 444060 ChlElecRWl 403 0 403 337.00 445030 Nursery Srvc-Lawn S Plant Care 850110 Airport Operations 76850110 445030 Nursery 41,529 0 41,529 44,701.45 06/06/17 API VCH INIVI-17-001875 4,500.00 06/06/17 API VCH INIVI-17-001873 30.18 445080 Snow and Ice Removal 850110 Airport Operations 76850110 445080 SnowIceRem 29,000 0 29,000 23,780.19 00 2,619.68 62.6% ::BI�T�:B1t:RILR3 .00 -3,172.45 10].6&* SET AIR INC I#184824 SET AIR INC I#184824 00 5,219.81 82.0% Anpont Commasbn Agenda & Info Packet Meeting Data July20, 201_ 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations (CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT JULY 1, 2016 - JUNE ORIGINAL TItAMFR3/ APPROP ADJSTMTS 30, 2017 REVISED BUDGET YTD ACTUAL P 15 glytdbud JOURNAL DETAIL 2017 12 TO 2017 12 AVAILABLE PCT EMCU!ffiM ES BUDGET USED 445110 Testing Services 850110 Airport Operations 76850110 445110 Testing 2,000 0 2,000 2,307.00 .00 -307.00 115.4%* 06/15/17API VCB IN1210972 413.50 TANKNOLOGY IN#185527 06/15/17API VCB IN1211426 628.50 TANKNOLOGY IN#185527 445230 Other Operating Services 850110 Airport Operations 76850110 445230 OthOptoSVC 0 0 0 264.00 .00 -264.00 100.0&* 446100 City Attorney Chargehack 850110 Airport Operations 76850110 446100 Atty Chahk 6,465 0 6,465 6,465.00 .00 .00 100.0% 06/30/17GM 060592 SS/DB 6,465.00 FY17 City Atty Chghk 446120 ITS-Server/Storage Chghk 850110 Airport Operations 76850110 446120 ITS SrvCha 216 0 216 455.19 .00 -239.19 210.7%* 06/30/17GNI June 17 AO 36.08 Storage of files AIR 06/30/17GNI June 17 AO 3.74 Storage of email Anpont Comm asnn Agenda & Info Packet Meeting Data July20, 20V, 07/17/2017 14:36 OF IOWA CITY 216 P 16 mtharp (CITY YEAR-TO-DATE BUDGET REPORT glytdhud 0 JULY 1, 2016 - JUNE 30, 2017 0 3.96 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TItAMFR3/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL EMCU!ffiM ES BUDGET USED 446130 ITS-PC/Peripheral/Tahlet S/R 850110 Airport Operations 76850110 446130 ITS PC Cha 06/30/17GNI 30 -SUN -17A0 446160 ITS -Infrastructure Fee 850110 Airport Operations 76850110 446160 ITSNetwCha 446190 ITS -Software SAAS Chghk 850110 Airport Operations 76850110 446190 ITSSAASCha 06/30/17GNI June 17 AO 446200 Photocopying Chargehack 850110 Airport Operations 76850110 446200 Copy Chahk 6,909 0 6,909 12,695.70 1,08].60 8,761 0 8,761 8,761.00 216 0 216 166.50 18.50 0 0 0 3.96 .00 -5,786.94 183.8%* SUN ITS Repl Chghk 00 .00 100.0% .00 49.50 771& Office software 00 -3.96 100.0&* 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 446220 Phone Service Chargeback 850110 Airport Operations Anpont Commasbn Agenda & Info Packet Meeting Data July20, 20V, CITY OF IOWA CITY P 17 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRARFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCOlR3MARCES BUDGET USED 76850110 446220 PhoneChabk 800 0 800 .00 446300 Phone Equipment/Line Chgbk 850110 Airport Operations 76850110 446300 PhoneEaCho 1,378 0 1,378 1,350.00 06/30/17GNI ISICHRGESAO 112.50 446320 Mail Chargeback 850110 Airport Operations 76850110 446320 Mail Chabk 200 0 200 163.94 06/01/17GNI 06012017 AO 2.09 446350 City Vehicle Replacement Chgbk 850110 Airport Operations 76850110 446350 VehaenlCh4 18,244 0 18,244 19,654.54 06/30/17GNI June 2017TLA 1,816.39 00 800.00 .0% .00 28.24 98.0% CH JUN PHON EQUIP CHGE .00 36.06 82.0% MAY Mail Charges .00 -1,410.54 107.7&* JUN REPLACEMENT MST Anpont Commasbn Agenda & Info Packet Meeting Data July20, 20V, 07/17/2017 14:36 OF IOWA CITY 0 P is mtharp (CITY YEAR-TO-DATE BUDGET REPORT 06/30/17GNI June 2017TIA glytdbud JULY 1, 2016 - JUNE 30, 2017 270.13 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 446360 City Vehicle Rental Chargehack 850110 Airport Operations 76850110 446360 VehRentCha 272 0 272 .00 446370 Fuel Chargehack 850110 Airport Operations 76850110 446370 Fuel Chahk 5,258 0 5,258 2,839.91 06/30/17GNI June 2017TIA 270.13 446380 Vehicle R&M Chargehack 850110 Airport Operations 76850110 446380 VehRSMCha 27,733 0 27,733 11,615.82 06/30/17GNI June 2017TIA 1,692 39 449055 Permitting Fees 850110 Airport Operations 76850110 449055 PexmitFees 440 0 440 440.00 00 272.00 .0% .00 2,418.09 54.0% JUN DIVISION FUEL .00 16,117.18 41.9% JUN DIVISION SERVICE 00 .00 100.0% 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 449060 Dues S Memherships Anpod Comm asnn Agenda & Info Packet Meeting Data July20, 20V, CITY OF IOWA CITY P 19 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRARFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBMARCES BUDGET USED 850110 Airport Operations 76850110 449060 Dues6Memh 449120 equipment Rental 850110 Airport Operations 76850110 449120 equip Rent 452010 Office Supplies 850110 Airport Operations 76850110 452010 Off Supply 452030 Minor Office equip/FU.iture 850110 Airport Operations 1,185 0 1,185 1,225.00 0 0 0 290.97 357 0 357 321.36 00 -40.00 103.4%* 00 -290.97 100.0%* 00 35.64 90.0% 76850110 452030 Mina/Fu0 0 0 223.41 .00 -223.41 100.0%* Anpod Commasbn Agenda & Info Packet Meeting Data July20, 20V, 07/17/2017 14:36 OF IOWA CITY 131 P 20 mtharp (CITY YEAR-TO-DATE BUDGET REPORT 0 glytdbud JULY 1, 2016 - JUNE 30, 2017 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TItANFR3/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCU!ffiM ES BUDGET USED 452040 Sanitation S Indust Supplies 850110 Airport Operations 76850110 452040 SanitSuptol 454020 Subscriptions 850110 Airport Operations 76850110 454020 Subscript 455120 Misc Computer Hardware 850110 Airport Operations 76850110 455120 MiscHrdwr 461040 Other Agriculture Chemicals 850110 Airport Operations 131 0 131 .00 0 0 0 249.60 193 0 193 70.90 00 131.00 .0% 00 -249.60 100.0%. 00 122.10 36.7& 76850110 461040 OthA4 Chem 336 0 336 151.38 .00 184.62 45.1% 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 466040 Plumhing Supplies 850110 Airport Operations Anpod Comm asnn Agenda & Info Packet Meeting Data Ju1y20, 20V, CITY OF IOWA CITY P 21 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 466040 Plumhina 0 0 0 31.08 466050 electrical Supplies 850110 Airport Operations 76850110 466050 electrical 445 0 445 3,114.20 06/06/17API VCH INIVI-17-001873 10.52 466070 Other Maintenance Supplies 850110 Airport Operations 76850110 466070 Oth Maint 583 0 583 1,968.60 06/06/17API VCH INIVI-17-001873 54.91 467020 equipment RWM Supplies 850110 Airport Operations 76850110 467020 equip RWM 1,377 0 1,377 1,073.52 00 -31.08 100.0%* .00 -2,669.20 699.8%* SET AIR INC I#184824 .00 -1,385.60 337.7&* SET AIR INC I#184824 00 303.48 78.0& 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 467160 Other Vehicle R&M Supplies 850110 Airport Operations Anpod Commasbn Agenda & Info Packet Meeting Data July20, 20V, CITY OF IOWA CITY P 22 YEAR-TO-DATE BUDGET REPORT glytdbud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRARFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 467160 OthVehRSM 0 0 0 210.04 .00 -210.04 100.0&* 468030 Asphalt 850110 Airport Operations 76850110 468030 Asphalt 155 0 155 .00 .00 155.00 .0& 469040 Traffic Cntrl Imprvmt Supplies 850110 Airport Operations 76850110 469040 TrafficCnt 169 0 169 .00 .00 169.00 .0& 469190 Minor equipment 850110 Airport Operations 76850110 469190 MinorEquito 570 0 570 .00 .00 570.00 .0& 07/17/2017 14:36 mtharp FOR 2017 12 ACCOUNTS FOR: 76850110 Airport Operations 469200 Tools Anpod Comm asnn Agenda & Info Packet Meeting Data Ju1y20, 20V, CITY OF IOWA CITY P 23 YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 850110 Airport Operations 76850110 469200 Tools 469260 Fire ext S Refills 850110 Airport Operations 76850110 469260 FireExtRef 469320 Miscellaneous Supplies 850110 Airport Operations 76850110 469320 MiscSunnl 469360 Food and Beverages 850110 Airport Operations 76850110 469360 Food&Bever 06/06/17 API VCH INIVI-17-001873 400 0 400 244.89 324 0 324 506.20 0 0 0 9.99 0 0 0 816.93 738.10 00 155.11 61.2& 00 -182.20 156.2&* 00 -9.99 100.0&* .00 -816.93 100.0%* SET AIR INC I#184824 Anpont Comm asnn Agenda & Info Packet Meeting Data July20, 20Lj 07/17/2017 14:36 OF IOWA CITY 0 P 24 mtharp (CITY YEAR-TO-DATE BUDGET REPORT 260,000 glytdhud 207,468.87 JULY 1, 2016 - JUNE 30, 2017 TOTAL REVENUES -472,709 0 FOR 2017 12 -460,481.53 JOURNAL DETAIL 2017 12 TO 2017 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 473010 Contracted Improvements 850110 Airport Operations 76850110 473010 Cont Impr 473020 Non -Contracted Improvements 850110 Airport Operations 76850110 473020 NonConImnr 06/15/17 API VCH IN79766 490040 Capital Project funding 850110 Airport Operations 0 260,000 260,000 259,932.22 20,000 0 20,000 85,907.73 43,690.00 00 67.78 100.0% .00 -65,90773 429.5&* CUSTOM BUILDE#185393 76850110 490040 Cl PfundiR4 0 .00 -5,564.39 100.0%* .00 -47,468.87 129.7% .00 -12,227.47 .00 -35,241.40 0 0 5,564.39 TOTAL Airport Operations -100,000 260,000 160,000 207,468.87 TOTAL REVENUES -472,709 0 -472,709 -460,481.53 TOTAL EXPENSES 372,709 260,000 632,709 667,950.40 Anpont Comm ceann Agenda & Info Packet Meeting Data July20, 20Lj 07/17/2017 14:36 (CITY OF IOWA CITY P 25 mthaap YEAR-TO-DATE BUDGET REPORT glytdhud JULY 1, 2016 - JUNE 30, 2017 FOR 2017 12 JOURNAL DETAIL 2017 12 TO 2017 12 ORIGINAL TItANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUlIDRANCES BUDGET USED GRAND TOTAL -100,000 260,000 160,000 207,468.87 .00 -47,468.87 129.7% ** EMD OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet Meeting Date_ July 20, 2017 Pegs 36 of 36 Airport Fund Unassigned Cash Balance waccona 500,cwnc maccona waccona maccona 100,00]AO 0.00 2016 2015 2016 2017 2018 2019 2020 2021 2022 2023 2026 Actual Actual Reumd Budge Proje J Proje J Proje J Proje J Proje J Proje J Proje J