The URL can be used to link to this page

Home My WebLink About02-19-2015 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, FEBRUARY 19, 2015 - 6:00 P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: 2 min* January 15, 2015 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion /Action: a. Airport Strategic Plan 10 min b. Airport Commerce Park 15 min c. Airport Master Plan 20 min d. FAA/IDOT Projects: AECOM / David Hughes 10 min i. FY15 Obstruction Mitigation ii. Runway 7/25 Parallel Taxiway iii. Taxiway B lighting 1. Consider a resolution accepting work as complete iv. Fuel Tank Rehabilitation v. North T -hangar Electrical Service & LED lighting e. Airport "Operations" 30 min i. Strategic Plan -Implementation 1. Review of Strategic Plan ii. Budget 1. Annual Report iii. Management f. FBO / Flight Training Reports 10 min i. Jet Air g. Commission Members' Reports 2 min h. Staff Report 2 min Consider a motion to adjourn to executive session to evaluate the professional competency of individuals whose appointment, hiring, performance or discharge is being considered when necessary to prevent needless and irreparable injury to that individuals' reputations and those individuals requested a closed session Evaluation of Airport Operations Specialist 5. Set next regular meeting for March 19, 2015 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 2-19-2015 Page 2 of 67 Airport Commission January 15, 2015 Page 1 MINUTES DRAFT IOWA CITY AIRPORT COMMISSION JANUARY 15, 2015 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: David Davis, Minnetta Gardinier, A. Jacob Odgaard, Chris Ogren Members Absent: Jose Assouline Staff Present: Michael Tharp, Eric Goers Others Present: Matt Wolford, David Hughes, Melissa Underwood RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM: Chairperson Ogren called the meeting to order at 6:02 P.M. APPROVAL OF MINUTES: Ogren asked if everyone had had a chance to review the minutes. Odgaard moved to accept the minutes of the December 15, 2014, meeting as presented. Ogren seconded the motion. The motion carried 4-0, Assouline absent. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: a. Airport Commerce Park — Tharp stated that the two land sales are progressing. One is due to close by the end of this month, and the other has asked for a 30 -day extension. b. Airport Master Plan — Melissa Underwood gave Members a quick update. She stated that today she sent everyone the draft document of chapters 1 through 3. These sections have also received the FAA's comments. The next meeting will be the first week of February, where the first public open house will be planned, and hopefully held mid- to late -February. Underwood asked that Members send her emails if they have questions or comments they would like to share. Tharp noted that they will get the word out through every means possible so that the public is well aware of the open houses they plan to hold. Ogren suggested they have a Member or two present at these open houses. Gardinier asked if the number of commercial respondents is too low for the survey. Underwood stated that typically they see a 10 to 12% response and she thinks Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 3 of 67 Airport Commission January 15, 2015 Page 2 the response here is good. The conversation turned to the upcoming open house and how it will be laid out. Members also discussed the various departments at the University and what their uses are, or could be, at the Airport. Gardinier suggested they get feedback from these users as well. C. FAA/IDOT Projects: AECOM (David Hughes) — i. FY15 Obstruction Mitigation — Hughes stated that they have been working with the FAA the last few months as to the scoping on the basic EA for the environmental assessment. Ogren asked for some clarification on the 'part 77 surface' noted in the report. Hughes responded, stating that it is the approach surfaces to the Airport and is defined by a federal regulation. Basically it is the 'imaginary surfaces off the end of the runway,' according to Hughes. Hughes continued to explain this item and responded to Members' questions. Tharp stated that there will be more discussion regarding the obstructions once they get to that part of the process. The issue of landings and approaches at the Airport was also discussed at some length, with Gardinier recommending that they post clearly what is expected of pilots at this time due to the obstructions they are dealing with. Gardinier asked if they could approach the FAA with the issue of nighttime approaches, which impacts traffic at the Airport, and try to get things moved along faster. Hughes and Tharp both noted that once the environmental assessment is done, they can do just this. Tharp further detailed for Members how they will handle the obstructions on private property and how things have typically been handled in the past. 1. Consider a resolution approving contract with AECOM — Gardinier moved to consider Resolution #A15-01, approving contract with AECOM. Odgaard seconded the motion. The motion carried 4-0, Assouline absent. ii. Runway 7/25 Parallel Taxiway — Hughes stated that since the December meeting they have received the necessary paperwork from Metro Pavers. Gardinier asked if there will be checking of the pavement on a regular basis. Tharp stated that he will put a formal plan in place, and that he himself has been out there at least every other month taking a look around. Gardinier asked that they make this something formal. Gardinier asked how long the maintenance bond is for. Hughes and Tharp both thought it was a 10 -year period. Tharp stated that he will find the exact wording for Gardinier, however, before the next meeting. She asked that they summarize this at the next meeting and include this information. 1. Consider a resolution accepting work as complete — Ogren moved to consider Resolution #A15-02, accepting work as complete. Gardinier seconded the motion. The motion carried 4-0, Assouline absent. iii. Taxiway B lighting — Hughes stated that the contractor has ordered some parts for this and once they arrive, this project will be ready for completion, as well. Airport Commission January 15, 2015 Page 3 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 4 of 67 Gardinier asked if there wasn't a project they were going to be working up bids for, something early in the spring. Hughes stated that early on in the spring they have some state projects, and he briefly described those. d. Airport Operations — i. Strategic Plan- Implementation — 1. Review of Strategic Plan — Tharp began a review of the strategic plan, noting that it is a five-year plan that basically takes the Master Plan, and some of the things that have happened with the Airport before, and creates a more `digestible chunk of goals and objectives.' He noted that this plan was put together with the help of Jeff Davidson with the Economic Development office at the City. Tharp gave Members a brief history of the plan and how they got to this point. In relation to the first goal of communication with City Hall and the Council, Members spent some time on the topic of having Council Members visit the Airport. Tharp explained that they do invite the Council to various events and make an effort to get them out to the Airport. The second goal of looking at funding and developing adequate funding for the Airport was discussed next. Tharp stated that he often shares this information, that when he first arrived at the Airport the debt was around $3.5 million, and the operating levy was about $170,000, with an operating budget of about $400,000. This past budget cycle, Tharp noted that the operating levy was $29,000, debt is $600,000 pending the land sale purchase agreements, and the operating budget is still around $400,000. So in terms of about a decade, Tharp noted, operating budget and expenses have been streamlined and have remained flat for 10 years. During this time they have been able to put money back into the buildings with new flooring and new restrooms in the Terminal, and improved maintenance in some of the buildings. Increasing use of the Airport for aviation and other community uses — Tharp noted that one of the big things the Airport did from the last Master Plan was to increase part of the length of the runway, giving better take -off distances. This Master Plan is working on landing distances and trying to reclaim some of that area. The jet fuel 24-hour system was installed, thus eliminating the overnight phone calls, according to Tharp. Continuing, Tharp noted that the Airport still offers use of the conference room to the public. Odgaard asked if the public is aware of this, and Tharp noted that it is on the Library's web site as an alternate site. He added that they have not done any overt marketing of it though. Increasing usefulness of the Airport for economic development— Tharp noted that this addresses things like building hangars, building facilities that people will use. He noted that they have hosted such groups as the Chamber of Commerce with a luncheon. Members also spoke to having a flight tracker screen Airport Commission January 15, 2015 Page 4 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 5 of 67 put up in the Terminal building. Tharp then spoke to the idea of marketing `hangar lots' at the Airport, and having a hangar model designed beforehand that they would work from. Upgrading taxiways, runways, Airport infrastructure — Tharp stated that they are working with the state in their pavement condition index program. This occurs every three years and was last done in 2011. Tharp stated that they are working with both the state and the FAA on grant opportunities as they become available. He also noted the HVAC system upgrades, and budgeting for hangar maintenance. Lighting has been increased on the airfield, and there is now 24-hour access to the Terminal building. Odgaard asked how pilots would know this, and Wolford and Tharp responded. This led to a discussion about noise abatement, as well, and how to get this information out to the flying community. Lastly, Tharp covered `curb appeal, looks of the Airport,' noting that at one time a viewing area was being developed, and a shelter and sidewalk were installed. He stated that he occasionally does see people using the space. Members briefly discussed some of the plans that had been discussed in previous years, such as adding some educational pieces to the viewing area. Odgaard suggested they collaborate with the City's Parks and Recreation department to make the entire area an attractive recreational area. Tharp stated that he will check with Jeff Davidson to see if he can walk the Airport Commission through this process again. He will try to get something set up over the next few months. Gardinier asked Underwood how the strategic plan plays into the Master Plan at this point. She asked if it would be better to have them further along with the Master Plan before they embark on another five-year strategic plan. Underwood responded that actually it would be best to have them both in draft form together, as they can then play off each other. She noted the difference between a strategic plan and a master plan, in terms of the FAA. Gardinier asked how far behind they are in updating the strategic plan, noting that the minutes at the end of the plan are dated December 2009. Tharp noted that they are somewhat behind, but that the plan is referring to fiscal years, not calendar years. ii. Budget - 1. Annual Report — Tharp noted that he did do the budget presentation for the Council recently. He talked about what is happening at the Airport, and he noted that the Council was happy to hear about the land sales in the commerce park and the lowering of the Airport's debt. He noted that there are no anticipated changes to the budget from what was presented. Tharp stated that a draft of the Annual Report was ready for Airport Commission January 15, 2015 Page 5 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 6 of 67 review. He asked members to review the report for comments by February 12`n iii. Management — Tharp stated that his annual evaluation is due next month. He will need to meet with the Chair to begin this process. e. FBO/Flight Training Reports — i. Jet Air — Wolford addressed the Commission next. He shared the monthly reports with Members, noting some of the highlights. One of the bigger projects has been replacing light bulbs in various buildings and hangars. January brought snow removal, with drifting becoming a problem at times. Wolford noted that fuel prices continue to drop. He stated that Jet Air is now an official `145 repair station.' Flight training is up and going well already, according to Wolford. Commission Members' Reports — Odgaard asked about the lock issue on the gates, and Tharp noted that he did follow up with the fencing contractor, but has not yet heard back. He also asked about the door to the Terminal building, and Tharp noted that this has been fixed. Gardinier stated that she hasn't flown since November, but hopes to fly this coming Sunday. She also spoke to an email received regarding the Girl Scouts. She stated that she would like to do something to participate in the World Aviation Day for Girls event. Tharp stated that he can respond to this email to let them know of their interest to participate. Gardinier further explained what typically takes place on this particular day at participating airports. Ogren noted the Children's Museum's interest, as well. g. Staff Report — Ogren asked about the status of the new blinds. Tharp stated that he needs to follow up on this, but that it will be happening soon. Another project is a partnership the City has with the University, the Iowa Initiative for Sustainable Communities. As part of this, the Airport will be part of the class study, and Odgaard is one of the mentors in this project. Tharp further explained how the goal will be to look at the flood mitigation for the south area, and come up with a newer, revised concept plan for this area. Odgaard stated that he will probably bring about five students to the Airport for Tharp to give them an update on where things are and what they are looking at doing. SET NEXT REGULAR MEETING FOR Tharp will make sure that there is going to be a quorum for this meeting. If so, the next regular meeting of the Airport Commission will be held on Thursday, February 19, 2015, at 6:00 P.M. in the Airport Terminal Building. ADJOURN: Odgaard made a motion to adjourn the meeting at 7:55 P.M. Ogren seconded the motion. The motion carried 3-0, Davis and Assouline absent. Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 7 of 67 Airport Commission January 15, 2015 Page 6 CHAIRPERSON DATE Airport Commission January 15, 2015 Page 7 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 8 of67 Airport Commission ATTENDANCE RECORD 2014-2015 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 V W Co O N NAME EXP. \ (Jn N w \ - N \ 00 \ rn N o \ \ A A A _ A A A A A O Minnetta Gardinier 03/01/19 X O/E X X X O/E X X X Jose Assouline 03/01/16 X X X X X O/E X X O/E Chris Ogren 03/01/18 X X X X X X X X X A. Jacob Odgaard 03/01/17 NM NM X X X X O/E X X David Davis 03/01/17 NM NM NM O X X O/E X X Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 9 of 67 Iowa City Municipal Airport 2014 Annual Report Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 10 of 67 Executive Summary The Iowa City Municipal Airport is owned by the City of Iowa City, and operated by the Iowa City Airport Commission. The Mayor and City Council of Iowa City, Iowa appoint members of the Iowa City Airport Commission. The Iowa City Municipal Airport houses 93 aircraft, which are maintained in: 59 T -hangars, 1 maintenance facility, 6 corporate hangars, 1 corporate building, 1 Fixed Based Operation (FBO) maintenance hangar, and 1 FBO cold storage hangar. Two runways, of 5004 (Runway 7/25) and 3900 (Runway 12/30) feet, are used during approximately 36,000 operations annually. Based on a 2009 Iowa Department of Transportation Economic Impact Study, the Iowa City Municipal Airport contributes $11.2 million and 115 jobs in the local economy. Among Iowa's 100+ general aviation airports, it has the fourth largest economic impact in the State. The Iowa City Municipal Airport operations budget for FY14 shows income of $390,506 and expenses of $333.982. General levy support was reduced from $100,000 in FY 2013 to $72,342 in FY 2014. The Iowa City Municipal Airport received funds in FY2013 for capital projects from the Federal Aviation Administration and the Iowa Department of Transportation. These funds financed projects to maintain and enhance the facilities at the Iowa City Municipal Airport. FAA grant funds allowed the Airport to continue the development of the Runway 7/25 Parallel Taxiway. Iowa DOT funds were used to construct new box hangars and perform maintenance work on the terminal building Since January 1, 2010 the Iowa City Municipal Airport has received over $10,000,000 in grant funds from the Federal Aviation Administration and the Iowa Department of Transportation Office of Aviation, and has used these funds for construction and maintenance of the airport facilities. Beginning in 2002, the City of Iowa City and the Airport Commission collaborated to create and market the Aviation Commerce Park. Funds from the sale of lots have been used to pay previous airport related debt as well as construction of additional hangar units. As of January 2015, all lots are either under obligation to a purchase agreement, or have been sold. The Iowa City Airport Commission has completed its planned reconstruction and extension of the runways at the Iowa City Municipal Airport. Projects continue to focus on enhancing services and community involvement. The following projects are planned in the next 5 years: 1) A master plan update and obstruction mitigation project; 2) an expanded apron for parking during high traffic events; and 3) additional hangar space to better accommodate all sizes of aircraft using the Iowa City Municipal Airport. Iowa City Municipal Airport — Annual Report 2014 Page 2 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 11 of 67 AIRPORT BACKGROUND The Iowa City Municipal Airport is located approximately 2 miles southwest of downtown Iowa City. The Iowa City Airport Commission has immediate controlling responsibility for the Iowa City Municipal Airport. The Airport Commission consists of five voting members, who are directly responsible for the planning, operation, and budget management of the Iowa City Municipal Airport. The Commission works collaboratively with Iowa City's elected officials and staff to ensure safe, efficient, and effective use of the airport to support Iowa City and the surrounding area. The Iowa City Municipal Airport is one of the busiest general aviation airports in Iowa with over 35,000 flight operations annually. It is currently home to approximately 93 based aircraft located in 59 T -hangars, and 6 corporate hangars. These aircraft are used for charter flights, corporate activity supporting local business, flight instruction, rental, pleasure, and charity purposes. Additionally, thousands of flights in and out of the airport support important community activities such as the organ transplant program and Air Ambulance flights to and from The University of Iowa Hospital and Clinics, as well as economic development for the area. Local businesses that utilize the airport include Billion Auto Group, ITC Midwest, Kum & Go, Family Video, Lear Corporation, and many others. Existing airport facilities include two runways, the terminal building, a maintenance facility, hangars, aircraft fueling facilities, aircraft parking ramp, tie down apron, and vehicle parking area. Runway 7-25 serves as the primary runway with a length of 5004 feet. Runway 12-30 serves as a secondary crosswind runway with a length of 3900 feet. The airport terminal building, built in 1951, includes a pilot's lounge with wireless internet access, a weather briefing room, a lobby, a conference/class room, vending machines, a meeting room, and administration facilities for airport management and a fixed based operator. The airport has a rotating beacon and lighted wind indicator. The airport is equipped with a remote communications outlet (RCO) and Automated Surface Observation System (ASOS). The airport has been an important element in the Iowa City community since 1918 and in 1944 was placed under the control of the Iowa City Airport Commission by public vote. Since that time, the airport has remained under the governance of the Airport Commission with fiscal support from the City of Iowa City. The airport is included in the National Plan of Integrated Airport Systems (NPIAS). The NPIAS identifies the Iowa City Municipal Airport as a general aviation airport. This designation means that the federal government currently provides funding annually through the FAA for eligible capital improvement projects at the airport. The Iowa Department of Transportation Office of Aviation's Aviation System Plan identifies the Iowa City Municipal Airport as an Enhanced Service Airport. Enhanced Service airports are defined as airports that serve nearly all general aviation aircraft and are economic and transportation centers for the state. Several businesses and University of Iowa enterprises are stationed at the airport. Jet Air, Inc. is the fixed base operator, with 58 employees at Iowa City and their other locations. The Iowa City -based staff of 17 offers charter flights, flight instruction, aircraft sales, maintenance, fuel, and sale of aviation related merchandise. Numerous faculty members at the University Oflowa Iowa City Municipal Airport — Annual Report 2014 Page 3 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 12 of 67 College Of Engineering use the airport for federally funded research on aviation technology and atmospheric weather phenomena. This research is primarily based out of the Operator Performance Laboratory located in building H and includes 7 full-time staff and 5 full-time student workers. Care Ambulance operates a full time ambulatory service and patient transfers. They have partnered with Jet Air as Jet Air Care to provide medical transport flights to and from the Iowa City area. AIRPORT VISION STATEMENT "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." AIRPORT MISSION STATEMENT "The mission of the Iowa City Municipal Airport is to support the strategic goals of the City of Iowa City and to meet the needs of its stakeholders." AIRPORT AND THE COMMUNITY In a continuing effort to develop and maintain a relationship with the community, the airport hosts numerous community events throughout the year. Examples include: SERTOMA Fly -in Pancake Breakfast The SERTOMA fly -in pancake breakfast and car show headlines the annual events; this event raises funds for use by the Service to Mankind (SERTOMA) organization. The 2014 SERTOMA breakfast took place on August 24. During the event, volunteers served Iowa City Municipal Airport — Annual Report 2014 Page 4 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 13 of 67 FLYIOWA 2014 Fly Iowa is a state-wide aviation fair that promotes aviation in Iowa. The Iowa City Airport Commission partnered with Jet Air, Iowa Aviation Promotion Group, The Iowa Children's Museum, Fuel Inc., Experimental Aircraft Association (EAA) Chapter 33, and the University of Iowa Operator Performance Laboratory to host this event at the Iowa City Airport on June 28-29, 2014. In collaboration with the partner organizations, the commission presented educational and entertainment events at the airport.. This free event drew an estimated 4000 attendees. Attendees gather to watch the free airshow that took place on June 12014 L 1 The Iowa Children's Museum hosted educational activities for everyone as part of Fly Iowa 2014. Iowa City Municipal Airport — Annual Report 2014 Page 5 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 14 of 67 AIR RACE CLASSIC The Air Race Classic is a daytime, VFR (visual flight rules) race consisting of teams of female pilots flying a pre -determined route. The Air Race Classic traces its origins back to the First Women's Air Derby in 1929 when 20 pilots raced from Santa Monica, CA to Cleveland, OH, site of the National Air Races. The 2014 Air Race Classic began in Concord California, and finished at New Cumberland, Pennsylvania. This race took place June 16-19, 2014. The Iowa City Municipal Airport previously served as the start site for the Air Race in 2011. In 2014, the airport served as a stop site, which is a predetermined checkpoint along the route in which racers must pass before continuing to the finish. Several racers stopped at Iowa City for fuel and night time accommodations, and others continued on to their next destination on the race route. EAA YOUNG EAGLES The FAA Young Eagles program was launched in 1992 to give interested young people, ages 8 - 17, an opportunity to go flying in a general aviation airplane. These flights are offered free of charge and are made possible through the generosity of FAA member volunteers. As part of Fly Iowa, on June 29, 2014, the Iowa City Municipal Airport and Experimental Aircraft Association (EAA) Chapter 33 provided 102 aircraft rides to children between the ages of 8 and 17. Iowa City Municipal Airport — Annual Report 2014 Page 6 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 15 of 67 ECONOMIC IMPACT STUDY In 2009, the Iowa Department of Transportation conducted an Economic Impact Study for the general aviation airports in the state of Iowa. That study determined that the Iowa City Municipal Airport contributes 115 jobs and $11.2 million worth of economic activity. The 115 jobs which are linked to the Iowa City Municipal Airport distribute approximately $3.2 million in annual payroll. Based on economic activity, the Iowa City Municipal Airport ranks as the 4t' largest general aviation airport in Iowa (H)OT "Iowa Economic Impact of Aviation 2009") BUDGET Relative to the findings of the state's economic impact study, the Iowa City Municipal Airport provides an extremely good return for the city's investment in the airport. The Iowa City Airport Commission and staff continue to maintain an efficient operating budget, which provides the necessary services and repairs to support the airport infrastructure. In FY2014, the City of Iowa City contributed $72.342 towards operations at the Iowa City Municipal Airport. That was a reduction from FY13's $100,000 level. The Iowa City Municipal Airport operations budget for FY14 shows income of $640,219 and expenses of $508,372. The airport received $212,505 from a land sale transaction which it used to repaying airport debt as well as finance additional construction projects. The Iowa City Municipal Airport receives operating revenue primarily from three sources: rental income, fuel sales, and general levy support. The Airport Commission examines and occasionally adjusts T -hangar rental rates on an annual basis, comparing rates to those at airports within a one-hour drive time to the Iowa City area. Iowa City Municipal Airport — Annual Report 2014 Page 7 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 16 of 67 Airport usage information is best tracked from the fuel flowage fees for fuel purchased at the airport. FY2008 represents the pre -recession peak fuel commissions. That year the airport earned just over $21,000 in commissions. Following projects which have increased runway lengths and enhanced the usability of the airport, as well as a rebound in the charter and medical flight activities, the Iowa City Municipal Airport has, in the last three years, realized increased revenue from fuel flowages fees. FY2014 brought in over $27,000 from fuel commissions. This represents a 10% increase in the fuel commissions from FY2013. This boost is primarily reflective of an increase in the jet fuel commissions as the aviation gasoline market remains relatively flat when compared to previous years. Personal and hobby aviation continues to be hampered by high fuel prices and other economic challenges. The chart below tracks the fuel sales by type over a calendar year. Fuel Sales by Type 300000 250000 200000 m C 0 150000 ■ 100 LL M 100000 ■ Jet A ■ Total Gallons 50000 — 0 2008 2009 2010 2011 2012 2013 2014 Calendar Year Iowa City Municipal Airport —Annual Report 2014 Page 8 Fuel Sales Commission $30,000 $25,000 $20,000 11$15,000 ■ Estimated 3 r, -$10,o00 ■Actual $5000 ❑Difference WO $0 FY08 -$5,000 FY09 FY 0 FY FY12 FY13 FY14 -$10,000 Fiscal Year Airport usage information is best tracked from the fuel flowage fees for fuel purchased at the airport. FY2008 represents the pre -recession peak fuel commissions. That year the airport earned just over $21,000 in commissions. Following projects which have increased runway lengths and enhanced the usability of the airport, as well as a rebound in the charter and medical flight activities, the Iowa City Municipal Airport has, in the last three years, realized increased revenue from fuel flowages fees. FY2014 brought in over $27,000 from fuel commissions. This represents a 10% increase in the fuel commissions from FY2013. This boost is primarily reflective of an increase in the jet fuel commissions as the aviation gasoline market remains relatively flat when compared to previous years. Personal and hobby aviation continues to be hampered by high fuel prices and other economic challenges. The chart below tracks the fuel sales by type over a calendar year. Fuel Sales by Type 300000 250000 200000 m C 0 150000 ■ 100 LL M 100000 ■ Jet A ■ Total Gallons 50000 — 0 2008 2009 2010 2011 2012 2013 2014 Calendar Year Iowa City Municipal Airport —Annual Report 2014 Page 8 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 17 of 67 GRANT SUPPORTED AIRPORT PROJECTS Major airport projects are funded through partnerships with either the Federal Aviation Administration or the Iowa Department of Transportation. The 2011 FAA Reauthorization brought with it some stabilization as it provided funding for 2012-2015, but it also brought additional local costs for projects with federal participation. The reauthorization act ended a series of 22 continuing resolutions which had allowed the FAA to continue operating following the expiration of the previous authorization act in 2007. The change in the grant payment share which lowered the maximum FAA participation to 90% from 95% of eligible project costs had an impact as the local community now has to provide a higher percentage of the funds. Federal grants contribute 90% of the project costs and are typically associated with major pavement rehabilitation and upgrades. State grants fund 70-85% of project costs, and are typically associated with minor pavement and facility repairs and upgrades. The Iowa City Municipal Airport continues to work on its safety and capacity projects as planned. Funded by FAA grants, the Runway 7/25 Parallel Taxiway has been completed. This taxiway provides a safer more efficient way for aircraft to exit the runway system and transit to the terminal area. The Iowa Department of Transportation Office of Aviation also aided FY2014 projects. The Airport Commission leveraged local funding to obtain grants for additional taxiway lighting and pavement rehabilitation work around the North T - hangars and Terminal area. In 2014 with FAA grant support, the Iowa City Airport Commission began the process of updating the Airport Master Plan. A strategic document that lays out the goals and operation of the airport over a 20 year period, the last Master plan was completed in 1996. The new plan will look at existing conditions and future growth needs to establish a road map for the Airport Commission and community to continue operating the airport as a community resource. The Master Plan update is projected to be completed in the summer of 2015. Iowa City Municipal Airport — Annual Report 2014 Page 9 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 18 of 67 AVIATION COMMERCE PARK The Airport, along with City staff, continues efforts to develop land available in Aviation Commerce Park a/k/a North Airport Development. Funds received from the sale or lease of this land have been used to pay off City incurred debt for costs associated with the improvements of that land. The original loan for the infrastructure has been paid for by proceeds from the sale of parcels in this area. The Airport Commission and City Council entered into an agreement in FY2011 which memorializes a plan for further sales of Aviation Commerce Park land to be used to accelerate the payback of other building construction debt balances. In Fiscal Year 2014, a transaction sold lot 9 to Wry Developers, and the Commission continued to use those proceeds toward paying off other existing hangar construction loans. FUTURE AIRPORT ACTIVITIES/PROJECTS The Iowa City Municipal Airport continues to plan for the future. Utilizing state and federal grants, as well as local improvement money, the Airport continues to refurbish and replace existing facilities and expand operational capability. FAA Grant Pre -Applications are due annually in December. The Iowa City Airport Commission has submitted its application for funding which includes continued funding of the master plan update for the Iowa City Municipal Airport. This update will serve as the road map for federal projects over the next 20 years. Actions spelled out in the previous master plan written in 1996 are now virtually complete. Additional FAA projects will include additional obstruction mitigation and expansion of the aircraft parking area. Additional projects include ramp and parking enhancements as well as obstruction mitigation work to provide obstruction free aircraft approaches. In June, The Iowa Department of Transportation awarded the Iowa City Airport two grants for FY2015 projects at the airport. One will assist with electrical service line replacement and LED lighting additions to the North T -hangars, and the other will assist in rehabilitation work to the fuel storage system. State Grant Applications are due annually in the spring. The Airport has utilized funding from the Iowa DOT Office of Aviation to finance repairs to hangars, taxiways, and other infrastructure which would have a low priority on the FAA scale. The Iowa City Airport Commission continues to work to achieve the goals laid out in the 2011- 2015 Strategic Plan. This report provides incremental goals over the 5 year period which aligns with the broader objectives of the Airport Master Plan and the City's Strategic Plan. The Airport Commission will continue to maintain and strengthen its relationship with City Council, staff, and the surrounding community by keeping a focus on the mutual goals for the Iowa City Municipal Airport. Iowa City Municipal Airport — Annual Report 2014 Page 10 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 Page 19 of 67 Airport Staff Michael Tharp, C.M., Operations Specialist Airport Commission Christine Ogren, Chairperson Minnetta Gardinier, Secretary Joe Assouline David Davis Jacob Odgaard Respectfully Submitted, Christine Ogren, Chairperson Iowa City Municipal Airport — Annual Report 2014 Page 11 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:30 (CITY OF IOWA CITY IP 1 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2015/7 TO 2015/7 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S 76850110 Airport Operations 7600-70-70-850-850100-850110-000-0000-438030- 171.15 Electricity ACCOUNT TOTAL 010319 MIDAMERICAN ENERGY 20150128091226 2015 7 DIR P 2015 7 INV P ACCOUNT TOTAL 7600-70-70-850-850100-850110-000-0000-438070- 2015 7 INV P 500.00 Heating Fuel/Gas 013015 010319 MIDAMERICAN ENERGY 20150128091226 2015 7 DIR P ACCOUNT TOTAL 598.08 7600-70-70-850-850100-850110-000-0000-438100- 013015 ACCOUNT TOTAL Refuse Collection Charges 011001 ABC DISPOSAL SYSTEMS 738888 2015 7 INV P 011001 ABC DISPOSAL SYSTEMS 738889 2015 7 INV P 011001 ABC DISPOSAL SYSTEMS 738890 2015 7 INV P 2015 7 INV P ACCOUNT TOTAL 7600-70-70-850-850100-850110-000-0000-438110- ACCOUNT TOTAL 4,500.00 Local Phone Service 011937 ALLIANCE CONNECT 40010932 2015 7 INV P 011937 ALLIANCE CONNECT 40011390 2015 7 INV P 7600-70-70-850-850100-850110-000-0000-442010- 010358 OVERHEAD DOOR COMPAN W95937 010856 JET AIR INC IOW ivi-15-000005 7600-70-70-850-850100-850110-000-0000-442060- 010856 JET AIR INC IOW ivi-14-004207 7600-70-70-850-850100-850110-000-0000-442070- 012736 GENERAL PEST CONTROL 011315 7600-70-70-850-850100-850110-000-0000-445080- 010856 JET AIR INC IOW ivi-15-000006 7600-70-70-850-850100-850110-000-0000-449055- 010262 IOWA WORKFORCE DEVEL 140828 WARRANT CHECK DESCRIPTION 1,946.73 W012615 42358 MidAmBilling 012620 1,946.73 798.66 W012615 42358 MidAmBilling 012620 798.66 28.84 013015 132648 Pickup/Disposal of 28.84 013015 132648 Pickup/Disposal of 71.07 013015 132648 Pickup/Disposal of 128.75 128.75 85.53 012315 131947 DEC 2014 INV 85.62 012315 131947 JAN 2015 INV 132792 Hangar #49 Door Rep 132750 Janitorial Services 132750 Maintenance Reimbur 131999 Pest Control Servic 132750 Maintenance/Grounds 132747 Annual Boiler Inspe 171.15 ACCOUNT TOTAL 171.15 Other Building R&M Services 2015 7 INV P 683.75 013015 2015 7 INV P 500.00 013015 ACCOUNT TOTAL 1,183.75 Electrical & Plumbing R&M Srvc 2015 7 INV P 598.08 013015 ACCOUNT TOTAL 598.08 Bldg Pest Control Services 2015 7 INV P 33.95 012315 ACCOUNT TOTAL 33.95 Snow and Ice Removal 2015 7 INV P 4,500.00 013015 ACCOUNT TOTAL 4,500.00 Permitting Fees 2015 7 INV P 200.00 013015 132792 Hangar #49 Door Rep 132750 Janitorial Services 132750 Maintenance Reimbur 131999 Pest Control Servic 132750 Maintenance/Grounds 132747 Annual Boiler Inspe Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:30 (CITY OF IOWA CITY IP 2 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2015/7 TO 2015/7 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION ** END OF REPORT - Generated by Michael Tharp ** ACCOUNT TOTAL 200.00 7600-70-70-850-850100-850110-000-0000-449060- Dues & Memberships 010256 IOWA PUBLIC AIRPORTS IPAA 2015 Dues 2015 7 INV P 150.00 013015 132746 Annual Dues 011424 IOWA AVIATION PROMOT IAPG 2015 Dues 2015 7 INV P 500.00 013015 132737 Annual Dues 2015 ACCOUNT TOTAL 650.00 7600-70-70-850-850100-850110-000-0000-467020- Equipment R&M Supplies 010856 JET AIR INC IOW ivi-14-004207 2015 7 INV P 578.81 013015 132750 Maintenance Reimbur ACCOUNT TOTAL 578.81 ORG 76850110 TOTAL 10,789.88 FUND 7600 Airport TOTAL: 10,789.88 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 1 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 Airport Operations 362100 Contrib & Donations 850110 Airport Operations 76850110 362100 651 Contrib & Donat 0 0 0 -1,709.00 .00 1,709.00 100.0°% 2015/01/070130 07/10/2014 GNI -1,000.00 REF SC CA 2-15 HILLCREST HOLDINGS FL 2015/01/070184 07/15/2014 GNI -234.00 REF SC CA 1-10 FLY IOWA DONATIONS 2015/01/070184 07/15/2014 GNI -100.00 REF SC CA 1-11 JANET LARSON FLY IOWA 2015/01/070184 07/15/2014 GNI -250.00 REF SC CA 1-13 MINNETTA GARDINIER FL 2015/01/070184 07/15/2014 GNI -100.00 REF SC CA 1-12 MATT WOLFORD FLY IOWA 2015/02/080142 08/11/2014 GNI -25.00 REF SC CA 2-2 UNIVERSITY OF DUBUQUE 381100 Interest on Investments 850110 Airport Operations 76850110 381100 Interest on Invest -1,314 0 -1,314 117.47 .00 -1,431.47 -8.9%* 2015/01/070505 07/31/2014 GEN -77.73 REF SS Interest Allocation Entry 2015/01/070505 07/31/2014 GEN -21.88 REF SS Interest Allocation Entry 2015/01/070505 07/31/2014 GEN -1.93 REF SS Interest Allocation Entry 2015/01/070505 07/31/2014 GEN 119.54 REF SS Interest Allocation Entry 2015/01/070570 07/31/2014 GNI -166.60 REF NS InterRecble 2015/02/080531 08/31/2014 GEN -39.60 REF SS Interest Allocation Entry 2015/02/080531 08/31/2014 GEN -11.55 REF SS Interest Allocation Entry 2015/02/080531 08/31/2014 GEN -1.02 REF SS Interest Allocation Entry 2015/02/080531 08/31/2014 GEN 67.96 REF SS Interest Allocation Entry 2015/03/090592 09/30/2014 GEN -22.81 REF SS Interest Allocation Entry 2015/03/090592 09/30/2014 GEN -6.70 REF SS Interest Allocation Entry 2015/03/090592 09/30/2014 GEN -.59 REF SS Interest Allocation Entry 2015/03/090592 09/30/2014 GEN 43.24 REF SS Interest Allocation Entry 2015/04/100624 10/31/2014 GEN -88.07 REF SS Interest Allocation Entry 2015/04/100624 10/31/2014 GEN -21.19 REF SS Interest Allocation Entry 2015/04/100624 10/31/2014 GEN -1.85 REF SS Interest Allocation Entry 2015/04/100624 10/31/2014 GEN 150.17 REF SS Interest Allocation Entry 2015/05/110554 11/30/2014 GEN -91.05 REF SS Interest Allocation Entry 2015/05/110554 11/30/2014 GEN -22.24 REF SS Interest Allocation Entry 2015/05/110554 11/30/2014 GEN -1.96 REF SS Interest Allocation Entry Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 2 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ APPROP ADJSTMTS 0/2014 GEN 156.73 SC REF SS 1/2014 GEN -77.81 REF SS 1/2014 GEN -19.42 SC REF SS 1/2014 GEN -1.72 REF SS 1/2014 GEN 157.42 NLK REF SS 1/2015 GEN -88.70 REF SS 1/2015 GEN -22.35 REF SS 1/2015 GEN -1.97 REF SS 1/2015 GEN 211.15 REF SS 382100 Land Rental 850110 Airport Operations 76850110 382100 Land Rental 07/10/2014 GNI 07/15/2014 GNI 07/25/2014 GNI 08/12/2014 GNI 08/19/2014 GNI 08/28/2014 GNI 09/11/2014 GNI 09/29/2014 GBI 09/25/2014 GNI 10/21/2014 GBI 10/28/2014 GBI 10/07/2014 GNI 11/25/2014 GBI 11/25/2014 CRP 12/04/2014 GBI 12/24/2014 GBI 01/09/2015 CRP 01/22/2015 GBI 382200 Building/Room Rental 850110 Airport Operations -45,647 -325.00 REF SC -106.67 REF SC -350.00 REF SS -325.00 REF SC -106.67 REF SC -350.00 REF SC -394.87 REF NLK -325.00 REF -350.00 REF SC -106.67 REF -325.00 REF -350.00 REF SC -106.67 REF -350.00 REF 2090 -325.00 REF -325.00 REF -350.00 REF 4679 -325.00 REF 11 US TREAS JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED Interest Allocation Entry Interest Allocation Entry Interest Allocation Entry Interest Allocation Entry Interest Allocation Entry Interest Allocation Entry Interest Allocation Entry Interest Allocation Entry Interest Allocation Entry -45,647 -5,196.55 ARMED FORCES RESERVE 00 -40,450.49 11.4%* AR 00028678 2-7 BELL LARRY & AR 00028693 2-15 JET AIR JUL CA 70-4 ARMED FORCES RESERVE AR 00028829 2-16 BELL LARRY AR 00028843 3-18 JET AIR AUG CA 70-9 ARMED FORCES RESERVE AR CON BEG BAL LAND RENT CA 70-4 ARMED FORCES RESERVE GROUND LEASE LAND RENT CA 70-16 ARMED FORCES RESERVE GROUND LEASE ARMED FORCES RESERVE RENTAL LAND RENT LAND RENT LEASE PAYMENT LAND RENT Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 3 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 382200 Building/Room Rent -250,000 -250,000 -170,358.01 00 -79,641.99 68.1°% 07/02/2014 GNI -151.00 REF SC AR 00028612 2-16 BRUMLEY JAM 07/02/2014 GNI -151.00 REF SC AR 00028623 2-17 HALL ROBERT 07/02/2014 GNI -635.00 REF SC AR 00028655 2-4 OPERATOR PERF 07/02/2014 GNI -144.00 REF SC AR 00028623 2-17 HALL ROBERT 07/02/2014 GNI -144.00 REF SC AR 00028654 2-19 POWERS ROBE 07/02/2014 GNI -151.00 REF SC AR 00028622 2-18 HULLERS JON 07/02/2014 GNI -172.00 REF SC AR 00028629 2-15 N6226W INC J 07/02/2014 GNI -4,038.00 REF SC AR 00028655 2-4 OPERATOR PERF 07/07/2014 GNI -151.00 REF SC AR 00028558 1-25 FIELD HOWAR 07/07/2014 GNI -172.00 REF SC AR 00028660 2-16 DOWNES GREG 07/07/2014 GNI -172.00 REF SC AR 00028616 2-19 PITTON MIKE 07/08/2014 GNI -209.00 REF SC AR 00028632 3-14 OCKENFELS J 07/08/2014 GNI -172.00 REF SC AR 00028657 3-11 STEARMAN JUL 07/08/2014 GNI -650.00 REF SC AR 00028632 3-14 OCKENFELS J 07/08/2014 GNI -151.00 REF SC AR 00028624 3-7 BULGARELLI D 07/08/2014 GNI -604.00 REF SC AR 00028639 3-8 AEROHAWKS JUL 07/08/2014 GNI -178.00 REF SC AR 00028621 3-10 SCHNELL TOM 07/09/2014 GNI -151.00 REF SC AR 00028574 2-26 KURT STEVEN 07/09/2014 GNI -172.00 REF SC AR 00028690 2-27 GOREE JOHN 07/09/2014 GNI -209.00 REF SC AR 00028630 2-20 SCHMEISER R 07/09/2014 GNI -172.00 REF SC AR 00028656 3-8 WIECHERT RON 07/09/2014 GNI -209.00 REF SC AR 00028627 2-25 MASCARI RIC 07/10/2014 GNI -202.00 REF SC AR 00028584 2-16 D & D FLIGHT 07/10/2014 GNI -202.00 REF SC AR 00028190 2-10 NE IA PHYS T 07/10/2014 GNI -202.00 REF SC AR 00028634 2-10 NE IA PHYS T 07/10/2014 GNI -358.00 REF SC AR 00028605 2-6 RUYLE JOHN J 07/11/2014 GNI -151.00 REF SC AR 00028619 2-11 DEMARIA JOS 07/14/2014 GNI -151.00 REF SC AR 00028131 2-9 SHEPHERD TOD 07/15/2014 GNI -178.00 REF SC AR 00028664 2-15 JET AIR JUL 07/15/2014 GNI -650.00 REF SC AR 00028664 2-15 JET AIR JUL 07/15/2014 GNI -151.00 REF SC AR 00028572 2-19 SHEPHERD TO 07/15/2014 GNI -151.00 REF SC AR 00028686 2-10 ROHR BRIAN 07/15/2014 GNI -4,287.00 REF SC AR 00028652 2-15 JET AIR INC 07/15/2014 GNI -144.00 REF SC AR 00028664 2-15 JET AIR JUL 07/15/2014 GNI -178.00 REF SC AR 00028664 2-15 JET AIR JUL 07/16/2014 GNI -151.00 REF SC AR 00028636 2-7 CHALKLEY BEN 07/18/2014 GNI -172.00 REF SC AR 00028556 89-1 MILLER RICH 07/18/2014 GNI -151.00 REF SC AR 00028569 89-5 YAMADA THOR 07/18/2014 GNI -75.50 REF SC AR 00028588 89-9 WEIHE DOUGL 07/18/2014 GNI -75.50 REF SC AR 00028595 89-10 CLAIR SCOT 07/18/2014 GNI -144.00 REF SC AR 00028603 89-12 HINCKLEY H 07/18/2014 GNI -404.00 REF SC AR 00028603 89-12 HINCKLEY H 07/18/2014 GNI -196.00 REF SC AR 00028606 89-13 VOS JEREMY 07/18/2014 GNI -151.00 REF SC AR 00028607 89-14 FARKAS EDW 07/18/2014 GNI -172.00 REF SC AR 00028628 89-15 BUTLER JOB 07/18/2014 GNI -172.00 REF SC AR 00028628 89-15 BUTLER JOB Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 4 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 07/18/2014 GNI -178.00 REF SC AR 00028631 89-16 FISHBAUGH 07/18/2014 GNI -234.00 REF SC AR 00028633 89-17 PATTSCHULL 07/18/2014 GNI -172.00 REF SC AR 00028635 89-18 ALLENDER P 07/18/2014 GNI -320.00 REF SC AR 00028645 89-20 EDMONDS TE 07/18/2014 GNI -172.00 REF SC AR 00028650 89-24 SQUADRONS U 07/18/2014 GNI -310.00 REF SC AR 00028651 89-25 GURNETT DO 07/18/2014 GNI -172.00 REF SC AR 00028684 89-31 MEADE JAME 07/18/2014 GNI -172.00 REF SC AR 00028681 89-30 COHN GARY 07/18/2014 GNI -144.00 REF SC AR 00028665 89-27 SWANSON NA 07/22/2014 GNI -151.00 REF SC AR 00028642 1-15 GERR FRED J 07/22/2014 GNI -576.00 REF SC AR 00028120 1-17 ANDERSEN JA 07/28/2014 GNI -209.00 REF SC AR 00028781 1-12 SCHMEISER R 07/30/2014 GNI -151.00 REF SC AR 00028707 2-10 FIELD HOWAR 07/30/2014 GNI -172.00 REF SC AR 00028780 1-4 N6226W INC AU 07/30/2014 GNI -151.00 REF SC AR 00028763 1-5 BRUMLEY JAME 07/30/2014 GNI -151.00 REF SC AR 00028774 1-6 HALL ROBERT 07/30/2014 GNI -144.00 REF SC AR 00028774 1-6 HALL ROBERT 07/31/2014 GNI -172.00 REF SC AR 00028811 1-3 DOWNES GREG 08/01/2014 GNI -151.00 REF SS AR 00027167 2-15 SAPPHIRE VIS 08/01/2014 GNI -151.00 REF SS AR 00028658 2-15 SAPPHIRE VIS 08/01/2014 GNI -151.00 REF SS AR 00027700 2-15 SAPPHIRE VIS 08/01/2014 GNI -151.00 REF SS AR 00028214 2-15 SAPPHIRE VIS 08/01/2014 GNI -151.00 REF SS AR 00028000 2-15 SAPPHIRE VIS 08/01/2014 GNI -151.00 REF SS AR 00027419 2-15 SAPPHIRE VIS 08/01/2014 GNI -635.00 REF SS AR 00028806 2-4 OPERATOR PERF 08/01/2014 GNI -4,038.00 REF SS AR 00028806 2-4 OPERATOR PERF 08/01/2014 GNI -151.00 REF SS AR 00026334 2-15 SAPPHIRE VIS 08/01/2014 GNI -151.00 REF SS AR 00026543 2-15 SAPPHIRE VIS 08/01/2014 GNI -151.00 REF SS AR 00026901 2-15 SAPPHIRE VIS 08/05/2014 GNI -144.00 REF SS AR 00028805 1-28 POWERS ROBE 08/05/2014 GNI -209.00 REF SS AR 00028783 1-17 OCKENFELS J 08/05/2014 GNI -650.00 REF SS AR 00028783 1-17 OCKENFELS J 08/05/2014 GNI -151.00 REF SS AR 00028775 1-25 BULGARELLI 08/06/2014 GNI -172.00 REF SS AR 00028840 2-7 GOREE JOHN & 08/06/2014 GNI -172.00 REF SS AR 00028767 2-2 PITTON MIKE 08/08/2014 GNI -209.00 REF SC AR 00028778 2-6 MASCARI RICK 08/11/2014 GNI -202.00 REF SC AR 00028733 2-1 D & D FLIGHT 08/11/2014 GNI -358.00 REF SC AR 00028756 2-10 RUYLE JOHN 08/12/2014 GNI -172.00 REF SC AR 00028807 3-2 WIECHERT RON 08/12/2014 GNI -151.00 REF SC AR 00028836 2-20 ROHR BRIAN 08/12/2014 GNI -151.00 REF SC AR 00028770 2-9 DEMARIA JOSE 08/13/2014 GNI -202.00 REF SC AR 00028785 2-12 NE IA PHYS T 08/14/2014 GNI -151.00 REF SC AR 00028723 1-19 KURT STEVEN 08/15/2014 GNI -100.00 REF SC AR 00028570 2-10 CARE AMBULAN 08/15/2014 GNI -100.00 REF SC AR 00028719 2-10 CARE AMBULAN 08/15/2014 GNI -75.50 REF SC AR 00028737 89-10 WEIHE DOUG 08/15/2014 GNI -172.00 REF SC AR 00028705 89-1 MILLER RICH Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 5 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 08/15/2014 GNI -151.00 REF SC AR 00028718 89-6 YAMADA THOR 08/15/2014 GNI -75.50 REF SC AR 00028744 89-11 CLAIR SCOT 08/15/2014 GNI -144.00 REF SC AR 00028752 89-13 HINCKLEY H 08/15/2014 GNI -404.00 REF SC AR 00028752 89-13 HINCKLEY H 08/15/2014 GNI -196.00 REF SC AR 00028757 89-14 VOS JEREMY 08/15/2014 GNI -151.00 REF SC AR 00028758 89-15 FARKAS EDW 08/15/2014 GNI -172.00 REF SC AR 00028779 89-16 BUTLER JOH 08/15/2014 GNI -172.00 REF SC AR 00028779 89-16 BUTLER JOH 08/15/2014 GNI -178.00 REF SC AR 00028782 89-17 FISHBAUGH 08/15/2014 GNI -234.00 REF SC AR 00028784 89-18 PATTSCHULL 08/15/2014 GNI -172.00 REF SC AR 00028786 89-19 ALLENDER P 08/15/2014 GNI -320.00 REF SC AR 00028796 89-21 EDMONDS TE 08/15/2014 GNI -172.00 REF SC AR 00028801 89-25 SQUADRONS U 08/15/2014 GNI -310.00 REF SC AR 00028802 89-26 GURNETT DO 08/15/2014 GNI -144.00 REF SC AR 00028816 89-28 SWANSON NA 08/15/2014 GNI -172.00 REF SC AR 00028832 89-31 COHN GARY 08/15/2014 GNI -172.00 REF SC AR 00028835 89-32 MEADE JAME 08/18/2014 GNI -151.00 REF SC AR 00028773 2-6 BULLERS JONA 08/19/2014 GNI -178.00 REF SC AR 00028815 3-18 JET AIR AUG 08/19/2014 GNI -144.00 REF SC AR 00028815 3-18 JET AIR AUG 08/19/2014 GNI -151.00 REF SC AR 00028787 3-21 CHALKLEY BE 08/19/2014 GNI -178.00 REF SC AR 00028815 3-18 JET AIR AUG 08/19/2014 GNI -650.00 REF SC AR 00028815 3-18 JET AIR AUG 08/19/2014 GNI -4,287.00 REF SC AR 00028803 3-18 JET AIR INC 08/20/2014 GNI -151.00 REF SC AR 00028793 2-5 GERR FRED AU 08/21/2014 GNI -172.00 REF SC AR 00028808 1-8 STEARMAN AUG 08/21/2014 GNI -178.00 REF SC AR 00028772 1-9 SCHNELL TOM 08/27/2014 GNI -650.00 REF SC AR 00029214 2-11 OCKENFELS J 08/27/2014 GNI -209.00 REF SC AR 00029214 2-11 OCKENFELS J 08/27/2014 GNI -172.00 REF SC AR 00029211 2-10 N6226W INC S 08/28/2014 GNI -209.00 REF SC AR 00029212 1-22 SCHMEISER R 08/29/2014 GNI -172.00 REF SC AR 00029242 1-18 DOWNES GREG 09/02/2014 GNI -635.00 REF SC AR 00029237 2-6 OPERATOR PERF 09/02/2014 GNI -4,038.00 REF SC AR 00029237 2-6 OPERATOR PERF 09/03/2014 GNI -151.00 REF SC AR 00028242 2-49 ROHR BRIAN 09/04/2014 GNI -151.00 REF SC AR 00029194 2-5 BRUMLEY JAME 09/11/2014 GNI -14,695.00 REF NLK AR CON BEG HAL 09/19/2014 GNI -172.00 REF SC AR 00029137 89-1 MILLER RICH 09/19/2014 GNI -151.00 REF SC AR 00029150 89-6 YAMADA THOR 09/19/2014 GNI -75.50 REF SC AR 00029169 89-10 WEIHE DOUG 09/19/2014 GNI -75.50 REF SC AR 00029175 89-11 CLAIR SCOT 09/19/2014 GNI -144.00 REF SC AR 00029183 89-13 HINCKLEY H 09/19/2014 GNI -404.00 REF SC AR 00029183 89-13 HINCKLEY H 09/19/2014 GNI -196.00 REF SC AR 00029188 89-14 VOS JEREMY 09/19/2014 GNI -151.00 REF SC AR 00029189 89-15 FARKAS EDW 09/19/2014 GNI -172.00 REF SC AR 00029210 89-16 BUTLER JOH 09/19/2014 GNI -172.00 REF SC AR 00029210 89-16 BUTLER JOH Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 6 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 09/19/2014 GNI -178.00 REF SC AR 00029213 89-17 FISHBAUGH 09/19/2014 GNI -234.00 REF SC AR 00029215 89-18 PATTSCHULL 09/19/2014 GNI -172.00 REF SC AR 00029217 89-19 ALLENDER P 09/19/2014 GNI -320.00 REF SC AR 00029227 89-21 EDMONDS TE 09/19/2014 GNI -172.00 REF SC AR 00029232 89-25 SQUADRONS U 09/19/2014 GNI -172.00 REF SC AR 00029266 89-32 MEADE JAME 09/19/2014 GNI -172.00 REF SC AR 00029263 89-31 COHN GARY 09/19/2014 GNI -144.00 REF SC AR 00029247 89-28 SWANSON NA 09/19/2014 GNI -310.00 REF SC AR 00029233 89-26 GURNETT DO 09/26/2014 GBI -151.00 REF Hangar Rent #19 09/26/2014 GBI -179.00 REF Hangar Rent #40 09/26/2014 GBI -179.00 REF Hangar Rent #39 09/26/2014 GBI -151.00 REF Hangar Rent #23 09/26/2014 GBI -151.00 REF Hangar Rent #22 09/26/2014 GBI -179.00 REF Hangar Rent #36 09/26/2014 GBI -179.00 REF Hangar Rent #37 09/26/2014 GBI -100.00 REF OFFICE RENTAL 09/26/2014 GBI -151.00 REF Hangar Rent #14 09/26/2014 GBI -75.50 REF Hangar Rent #18 09/26/2014 GBI -75.50 REF Hangar Rent #18 09/26/2014 GBI -179.00 REF Hangar Rent #41 09/26/2014 GBI -210.00 REF Hangar Rent #57 09/26/2014 GBI -151.00 REF Hangar Rent #24 09/26/2014 GBI -144.00 REF Hangar Rent #5 09/26/2014 GBI -179.00 REF Hangar Rent #51 09/26/2014 GBI -332.00 REF Hangar Rent #56 09/26/2014 GBI -151.00 REF Hangar Rent #21 09/26/2014 GBI -151.00 REF Hangar Rent #29 09/26/2014 GBI -185.00 REF Hangar Rent #63 09/26/2014 GBI -151.00 REF Hangar Rent #16 09/26/2014 GBI -179.00 REF Hangar Rent #38 09/26/2014 GBI -310.00 REF Hangar Rent #34 09/26/2014 GBI -144.00 REF Hangar Rent #6 09/26/2014 GBI -151.00 REF Hangar Rent #30 09/26/2014 GBI -144.00 REF Hangar Rent #10 09/26/2014 GBI -404.00 REF Hangar Rent #31 09/26/2014 GBI -4,287.00 REF BUILDINGS D E F & H 09/26/2014 GBI -106.67 REF GROUND LEASE 09/26/2014 GBI -144.00 REF Hangar Rent #1 09/26/2014 GBI -185.00 REF Hangar Rent #59 09/26/2014 GBI -185.00 REF Hangar Rent #60 09/26/2014 GBI -650.00 REF Hangar Rent #72 09/26/2014 GBI -151.00 REF Hangar Rent #12 09/26/2014 GBI -217.00 REF Hangar Rent #45 09/26/2014 GBI -179.00 REF Hangar Rent #48 09/26/2014 GBI -179.00 REF Hangar Rent #52 09/26/2014 GBI -179.00 REF Hangar Rent #49 Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 7 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 09/26/2014 GBI -210.00 REF Hangar Rent #58 09/26/2014 GBI -217.00 REF Hangar Rent #55 09/26/2014 GBI -650.00 REF Hangar Rent #71 09/26/2014 GBI -635.00 REF Hangar Rent #32 09/26/2014 GBI -4,038.00 REF Hangar Rent #35 09/26/2014 GBI -243.00 REF Hangar Rent #61 09/26/2014 GBI -179.00 REF Hangar Rent #43 09/26/2014 GBI -144.00 REF Hangar Rent #9 09/26/2014 GBI -151.00 REF Hangar Rent #27 09/26/2014 GBI -358.00 REF Hangar Rent #33 09/26/2014 GBI -151.00 REF Hangar Rent #13 09/26/2014 GBI -217.00 REF Hangar Rent #46 09/26/2014 GBI -185.00 REF Hangar Rent #62 09/26/2014 GBI -151.00 REF Hangar Rent #26 09/26/2014 GBI -179.00 REF Hangar Rent #53 09/26/2014 GBI -179.00 REF Hangar Rent #47 09/26/2014 GBI -144.00 REF Hangar Rent #8 09/26/2014 GBI -204.00 REF Hangar Rent #64 09/26/2014 GBI -179.00 REF Hangar Rent #42 09/26/2014 GBI -151.00 REF Hangar Rent #20 09/26/2014 GBI -151.00 REF Hangar Rent #11 09/26/2014 GBI -151.00 REF Hangar Rent #17 09/26/2014 GBI -151.00 REF Hangar Rent #25 09/26/2014 GBI -151.00 REF Hangar Rent #25 09/26/2014 GBI -179.00 REF Hangar Rent #44 09/26/2014 GBI -179.00 REF Hangar Rent #50 10/16/2014 GBM 75.50 REF GB INVOICES 10/16/2014 GBI -75.50 REF Hangar Rent #18 10/21/2014 GBI -107.00 REF Hangar Rent #15 10/21/2014 GBI -151.00 REF Hangar Rent #19 10/21/2014 GBI -179.00 REF Hangar Rent #40 10/21/2014 GBI -179.00 REF Hangar Rent #39 10/21/2014 GBI -151.00 REF Hangar Rent #23 10/21/2014 GBI -151.00 REF Hangar Rent #22 10/21/2014 GBI -179.00 REF Hangar Rent #36 10/21/2014 GBI -179.00 REF Hangar Rent #37 10/21/2014 GBI -100.00 REF OFFICE SPACE RENT 10/21/2014 GBI -151.00 REF Hangar Rent #14 10/21/2014 GBI -75.50 REF Hangar Rent #18 10/21/2014 GBI -75.50 REF Hangar Rent #18 10/21/2014 GBI -179.00 REF Hangar Rent #41 10/21/2014 GBI -210.00 REF Hangar Rent #57 10/21/2014 GBI -151.00 REF Hangar Rent #24 10/21/2014 GBI -144.00 REF Hangar Rent #5 10/21/2014 GBI -179.00 REF Hangar Rent #51 10/21/2014 GBI -332.00 REF Hangar Rent #56 10/21/2014 GBI -151.00 REF Hangar Rent #21 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 8 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 10/21/2014 GBI -179.00 REF Hangar Rent #54 10/21/2014 GBI -185.00 REF Hangar Rent #63 10/21/2014 GBI -151.00 REF Hangar Rent #16 10/21/2014 GBI -179.00 REF Hangar Rent #38 10/21/2014 GBI -310.00 REF Hangar Rent #34 10/21/2014 GBI -144.00 REF Hangar Rent #6 10/21/2014 GBI -151.00 REF Hangar Rent #30 10/21/2014 GBI -144.00 REF Hangar Rent #10 10/21/2014 GBI -404.00 REF Hangar Rent #31 10/21/2014 GBI -4,287.00 REF D, E, F, H 10/21/2014 GBI -144.00 REF Hangar Rent #1 10/21/2014 GBI -185.00 REF Hangar Rent #59 10/21/2014 GBI -185.00 REF Hangar Rent #60 10/21/2014 GBI -650.00 REF Hangar Rent #72 10/21/2014 GBI -151.00 REF Hangar Rent #15 10/21/2014 GBI -151.00 REF Hangar Rent #12 10/21/2014 GBI -217.00 REF Hangar Rent #45 10/21/2014 GBI -179.00 REF Hangar Rent #48 10/21/2014 GBI -179.00 REF Hangar Rent #52 10/21/2014 GBI -179.00 REF Hangar Rent #49 10/21/2014 GBI -210.00 REF Hangar Rent #58 10/21/2014 GBI -217.00 REF Hangar Rent #55 10/21/2014 GBI -650.00 REF Hangar Rent #71 10/21/2014 GBI -635.00 REF Hangar Rent #32 10/21/2014 GBI -4,038.00 REF Hangar Rent #35 10/21/2014 GBI -243.00 REF Hangar Rent #61 10/21/2014 GBI -179.00 REF Hangar Rent #43 10/21/2014 GBI -144.00 REF Hangar Rent #9 10/21/2014 GBI -151.00 REF Hangar Rent #27 10/21/2014 GBI -358.00 REF Hangar Rent #33 10/21/2014 GBI -151.00 REF Hangar Rent #13 10/21/2014 GBI -217.00 REF Hangar Rent #46 10/21/2014 GBI -185.00 REF Hangar Rent #62 10/21/2014 GBI -151.00 REF Hangar Rent #26 10/21/2014 GBI -179.00 REF Hangar Rent #53 10/21/2014 GBI -179.00 REF Hangar Rent #47 10/21/2014 GBI -144.00 REF Hangar Rent #8 10/21/2014 GBI -204.00 REF Hangar Rent #64 10/21/2014 GBI -179.00 REF Hangar Rent #42 10/21/2014 GBI -151.00 REF Hangar Rent #20 10/21/2014 GBI -151.00 REF Hangar Rent #11 10/21/2014 GBI -151.00 REF Hangar Rent #17 10/21/2014 GBI -151.00 REF Hangar Rent #25 10/21/2014 GBI -151.00 REF Hangar Rent #28 10/21/2014 GBI -179.00 REF Hangar Rent #44 10/21/2014 GBI -179.00 REF Hangar Rent #50 11/26/2014 GBM 151.00 REF GB INVOICES Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 9 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 11/26/2014 GBM 72.00 REF GB INVOICES 11/26/2014 GBM 72.00 REF GB INVOICES 11/25/2014 GBI -151.00 REF Hangar Rent #19 11/25/2014 GBI -179.00 REF Hangar Rent #40 11/25/2014 GBI -179.00 REF Hangar Rent #39 11/25/2014 GBI -151.00 REF Hangar Rent #23 11/25/2014 GBI -144.00 REF Hangar Rent #5 11/25/2014 GBI -151.00 REF Hangar Rent #22 11/25/2014 GBI -179.00 REF Hangar Rent #36 11/25/2014 GBI -179.00 REF Hangar Rent #37 11/25/2014 GBI -100.00 REF OFFICE SPACE RENT 11/25/2014 GBI -151.00 REF Hangar Rent #14 11/25/2014 GBI -75.50 REF Hangar Rent #18 11/25/2014 GBI -75.50 REF Hangar Rent #18 11/25/2014 GBI -179.00 REF Hangar Rent #41 11/25/2014 GBI -210.00 REF Hangar Rent #57 11/25/2014 GBI -151.00 REF Hangar Rent #24 11/25/2014 GBI -179.00 REF Hangar Rent #51 11/25/2014 GBI -332.00 REF Hangar Rent #56 11/25/2014 GBI -151.00 REF Hangar Rent #21 11/25/2014 GBI -179.00 REF Hangar Rent #54 11/25/2014 GBI -185.00 REF Hangar Rent #63 11/25/2014 GBI -151.00 REF Hangar Rent #16 11/25/2014 GBI -179.00 REF Hangar Rent #38 11/25/2014 GBI -310.00 REF Hangar Rent #34 11/25/2014 GBI -144.00 REF Hangar Rent #6 11/25/2014 GBI -151.00 REF Hangar Rent #30 11/25/2014 GBI -151.00 REF Hangar Rent #30 / 11/25/2014 GBI -144.00 REF Hangar Rent #10 11/25/2014 GBI -404.00 REF Hangar Rent #31 11/25/2014 GBI -4,287.00 REF D, E, F, H 11/25/2014 GBI -144.00 REF Hangar Rent #1 11/25/2014 GBI -185.00 REF Hangar Rent #59 11/25/2014 GBI -185.00 REF Hangar Rent #60 11/25/2014 GBI -650.00 REF Hangar Rent #72 11/25/2014 GBI -151.00 REF Hangar Rent #15 11/25/2014 GBI -151.00 REF Hangar Rent #12 11/25/2014 GBI -217.00 REF Hangar Rent #45 11/25/2014 GBI -179.00 REF Hangar Rent #48 11/25/2014 GBI -179.00 REF Hangar Rent #52 11/25/2014 GBI -179.00 REF Hangar Rent #49 11/25/2014 GBI -210.00 REF Hangar Rent #58 11/25/2014 GBI -217.00 REF Hangar Rent #55 11/25/2014 GBI -650.00 REF Hangar Rent #71 11/25/2014 GBI -635.00 REF Hangar Rent #32 11/25/2014 GBI -4,038.00 REF Hangar Rent #35 11/25/2014 GBI -243.00 REF Hangar Rent #61 April 14 Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 10 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 11/25/2014 GBI -179.00 REF Hangar Rent #43 11/25/2014 GBI -144.00 REF Hangar Rent #9 11/25/2014 GBI -151.00 REF Hangar Rent #27 11/25/2014 GBI -358.00 REF Hangar Rent #33 11/25/2014 GBI -151.00 REF Hangar Rent #13 11/25/2014 GBI -217.00 REF Hangar Rent #46 11/25/2014 GBI -185.00 REF Hangar Rent #62 11/25/2014 GBI -151.00 REF Hangar Rent #26 11/25/2014 GBI -179.00 REF Hangar Rent #53 11/25/2014 GBI -179.00 REF Hangar Rent #47 11/25/2014 GBI -144.00 REF Hangar Rent #8 11/25/2014 GBI -204.00 REF Hangar Rent #64 11/25/2014 GBI -179.00 REF Hangar Rent #42 11/25/2014 GBI -151.00 REF Hangar Rent #20 11/25/2014 GBI -151.00 REF Hangar Rent #11 11/25/2014 GBI -151.00 REF Hangar Rent #17 11/25/2014 GBI -151.00 REF Hangar Rent #25 11/25/2014 GBI -151.00 REF Hangar Rent #28 11/25/2014 GBI -179.00 REF Hangar Rent #44 11/25/2014 GBI -179.00 REF Hangar Rent #50 12/01/2014 GBI -144.00 REF Hangar Rent - #5 12/23/2014 GBI -151.00 REF Hangar Rent #19 12/23/2014 GBI -179.00 REF Hangar Rent #40 12/23/2014 GBI -179.00 REF Hangar Rent #39 12/23/2014 GBI -151.00 REF Hangar Rent #23 12/23/2014 GBI -144.00 REF Hangar Rent #5 12/23/2014 GBI -151.00 REF Hangar Rent #22 12/23/2014 GBI -179.00 REF Hangar Rent #179 12/23/2014 GBI -179.00 REF Hangar Rent #37 12/23/2014 GBI -100.00 REF OFFICE SPACE RENT 12/23/2014 GBI -151.00 REF Hangar Rent #14 12/23/2014 GBI -75.50 REF Hangar Rent #18 12/23/2014 GBI -75.50 REF Hangar Rent #18 12/23/2014 GBI -179.00 REF Hangar Rent #41 12/23/2014 GBI -210.00 REF Hangar Rent #57 12/23/2014 GBI -151.00 REF Hangar Rent #24 12/23/2014 GBI -179.00 REF Hangar Rent #51 12/23/2014 GBI -332.00 REF Hangar Rent #56 12/23/2014 GBI -151.00 REF Hangar Rent #21 12/23/2014 GBI -179.00 REF Hangar Rent #54 12/23/2014 GBI -185.00 REF Hangar Rent #63 12/23/2014 GBI -151.00 REF Hangar Rent #16 12/23/2014 GBI -179.00 REF Hangar Rent #38 12/23/2014 GBI -310.00 REF Hangar Rent #34 12/23/2014 GBI -144.00 REF Hangar Rent #6 12/23/2014 GBI -151.00 REF Hangar Rent #30 12/23/2014 GBI -144.00 REF Hangar Rent #10 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 11 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 12/23/2014 GBI -404.00 REF Hangar Rent #31 12/23/2014 GBI -4,287.00 REF D, E, F, H 12/23/2014 GBI -106.67 REF GROUND LEASE 12/23/2014 GBI -144.00 REF Hangar Rent #1 12/23/2014 GBI -185.00 REF Hangar Rent #59 12/23/2014 GBI -185.00 REF Hangar Rent #60 12/23/2014 GBI -650.00 REF Hangar Rent #72 12/23/2014 GBI -151.00 REF Hangar Rent #15 12/23/2014 GBI -151.00 REF Hangar Rent #12 12/23/2014 GBI -217.00 REF Hangar Rent #45 12/23/2014 GBI -179.00 REF Hangar Rent #48 12/23/2014 GBI -179.00 REF Hangar Rent #52 12/23/2014 GBI -179.00 REF Hangar Rent #49 12/23/2014 GBI -210.00 REF Hangar Rent #58 12/23/2014 GBI -217.00 REF Hangar Rent #55 12/23/2014 GBI -650.00 REF Hangar Rent #71 12/23/2014 GBI -635.00 REF Hangar Rent #32 12/23/2014 GBI -4,038.00 REF Hangar Rent #35 12/23/2014 GBI -243.00 REF Hangar Rent #61 12/23/2014 GBI -179.00 REF Hangar Rent #43 12/23/2014 GBI -144.00 REF Hangar Rent #9 12/23/2014 GBI -151.00 REF Hangar Rent #27 12/23/2014 GBI -358.00 REF Hangar Rent #33 12/23/2014 GBI -151.00 REF Hangar Rent #13 12/23/2014 GBI -217.00 REF Hangar Rent #46 12/23/2014 GBI -185.00 REF Hangar Rent #62 12/23/2014 GBI -151.00 REF Hangar Rent #26 12/23/2014 GBI -179.00 REF Hangar Rent #53 12/23/2014 GBI -179.00 REF Hangar Rent #47 12/23/2014 GBI -144.00 REF Hangar Rent #8 12/23/2014 GBI -204.00 REF Hangar Rent #64 12/23/2014 GBI -179.00 REF Hangar Rent #42 12/23/2014 GBI -151.00 REF Hangar Rent #20 12/23/2014 GBI -151.00 REF Hangar Rent #11 12/23/2014 GBI -151.00 REF Hangar Rent #17 12/23/2014 GBI -151.00 REF Hangar Rent #25 12/23/2014 GBI -151.00 REF Hangar Rent #28 12/23/2014 GBI -179.00 REF Hangar Rent #44 12/23/2014 GBI -179.00 REF Hangar Rent #50 01/20/2015 GBI -151.00 REF Hangar Rent #19 01/20/2015 GBI -179.00 REF Hangar Rent #40 01/20/2015 GBI -179.00 REF Hangar Rent #39 01/20/2015 GBI -151.00 REF Hangar Rent #23 01/20/2015 GBI -144.00 REF Hangar Rent #5 01/20/2015 GBI -151.00 REF Hangar Rent #22 01/20/2015 GBI -179.00 REF Hangar Rent #36 01/20/2015 GBI -179.00 REF Hangar Rent #37 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 12 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 01/20/2015 GBI -100.00 REF OFFICE SPACE RENT 01/20/2015 GBI -151.00 REF Hangar Rent #14 01/20/2015 GBI -75.50 REF Hangar Rent #18 01/20/2015 GBI -75.50 REF Hangar Rent #18 01/20/2015 GBI -179.00 REF Hangar Rent #41 01/20/2015 GBI -210.00 REF Hangar Rent #57 01/20/2015 GBI -151.00 REF Hangar Rent #24 01/20/2015 GBI -179.00 REF Hangar Rent #51 01/20/2015 GBI -332.00 REF Hangar Rent #56 01/20/2015 GBI -151.00 REF Hangar Rent #21 01/20/2015 GBI -179.00 REF Hangar Rent #54 01/20/2015 GBI -185.00 REF Hangar Rent #63 01/20/2015 GBI -151.00 REF Hangar Rent #16 01/20/2015 GBI -179.00 REF Hangar Rent #38 01/20/2015 GBI -310.00 REF Hangar Rent #34 01/20/2015 GBI -144.00 REF Hangar Rent #6 01/20/2015 GBI -151.00 REF Hangar Rent #30 01/20/2015 GBI -144.00 REF Hangar Rent #10 01/20/2015 GBI -404.00 REF Hangar Rent #31 01/20/2015 GBI -4,287.00 REF D, E, F, H 01/20/2015 GBI -106.67 REF GROUND LEASE 01/20/2015 GBI -144.00 REF Hangar Rent #1 01/20/2015 GBI -185.00 REF Hangar Rent #59 01/20/2015 GBI -185.00 REF Hangar Rent #60 01/20/2015 GBI -650.00 REF Hangar Rent #72 01/20/2015 GBI -151.00 REF Hangar Rent #15 01/20/2015 GBI -151.00 REF Hangar Rent #12 01/20/2015 GBI -217.00 REF Hangar Rent #45 01/20/2015 GBI -179.00 REF Hangar Rent #48 01/20/2015 GBI -179.00 REF Hangar Rent #52 01/20/2015 GBI -179.00 REF Hangar Rent #49 01/20/2015 GBI -210.00 REF Hangar Rent #58 01/20/2015 GBI -217.00 REF Hangar Rent #55 01/20/2015 GBI -650.00 REF Hangar Rent #71 01/20/2015 GBI -635.00 REF Hangar Rent #32 01/20/2015 GBI -4,038.00 REF Hangar Rent #35 01/20/2015 GBI -243.00 REF Hangar Rent #61 01/20/2015 GBI -179.00 REF Hangar Rent #43 01/20/2015 GBI -144.00 REF Hangar Rent #9 01/20/2015 GBI -151.00 REF Hangar Rent #27 01/20/2015 GBI -358.00 REF Hangar Rent #33 01/20/2015 GBI -151.00 REF Hangar Rent #13 01/20/2015 GBI -217.00 REF Hangar Rent #46 01/20/2015 GBI -185.00 REF Hangar Rent #62 01/20/2015 GBI -151.00 REF Hangar Rent #26 01/20/2015 GBI -179.00 REF Hangar Rent #53 01/20/2015 GBI -179.00 REF Hangar Rent #47 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 13 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 GBI -144.00 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 01/20/2015 GBI -144.00 REF Hangar Rent #8 01/20/2015 GBI -204.00 REF Hangar Rent #64 01/20/2015 GBI -179.00 REF Hangar Rent #42 01/20/2015 GBI -151.00 REF Hangar Rent #20 01/20/2015 GBI -151.00 REF Hangar Rent #11 01/20/2015 GBI -151.00 REF Hangar Rent #17 01/20/2015 GBI -151.00 REF Hangar Rent #25 01/20/2015 GBI -151.00 REF Hangar Rent #28 01/20/2015 GBI -179.00 REF Hangar Rent #44 01/20/2015 GBI -179.00 REF Hangar Rent #50 02/11/2015 GBI -144.00 REF Hangar Rent #4 - OCT 14 02/11/2015 GBI -144.00 REF Hangar Rent #4 - NOV 14 02/11/2015 GBI -144.00 REF Hangar Rent #4 - DEC 14 02/11/2015 GBI -144.00 REF Hangar Rent #4 - JAN 15 02/11/2015 GBI -144.00 REF Hangar Rent #4 - FEB 15 384200 Vending Machine Commission 850110 Airport Operations 76850110 384200 Vending Machine Cc 384900 Other Commissions 850110 Airport Operations 76850110 384900 Other Commissions 2015/01/070378 07/28/2014 GNI 2015/02/080312 08/19/2014 GNI 2015/03/090526 09/30/2014 GNI 2015/05/110060 11/04/2014 GNI 2015/05/110294 11/19/2014 CRP 2015/05/110294 11/19/2014 CRP 2015/05/110294 11/19/2014 CRP 2015/06/120362 12/19/2014 CRP 2015/08/020215 02/12/2015 CRP -130 -25.000 -1,630.00 REF SC -2,392.10 REF SC -2,431.60 REF SC -3,179.50 REF SC -32,148.00 REF 1522 32,148.00 REF 1572 -3,214.80 REF 1573 -1,600.50 REF 3276 -2,415.00 REF 5830 0 -130 .00 0 -25.000 -16.863.50 EASTERN AVIATION FUE Reversal / 1522 EASTERN AVIATION FUE EASTERN AVIATION FUE EASTERN AVIATION 00 -129.60 .0°%* 00 -8.136.50 67.5°% CA 2-2 EASTERN AVIATION FUELS CA 3-19 EASTERN AVIATION FUEL CA 1-14 EASTERN AVIATION FUEL CA 1-10 EASTERN AVIATIONS FUE OTHER /216/1490 OTHER /216/ 1511 OTHER /216/1512 OTHER /257/2661 OTHER /333/4385 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 14 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 392100 Sale of Land 850110 Airport Operations 76850110 392100 Sale of Land 2015/04/100321 10/20/2014 GNI 2015/04/100321 10/20/2014 GNI 393120 General Levy 850110 Airport Operations 76850110 393120 General Lev 2015/01/070495 07/31/2014 GCR 2015/02/080496 08/31/2014 GCR 2015/03/090562 09/30/2014 GCR 2015/04/100573 10/31/2014 GCR 2015/05/110481 11/30/2014 GCR 2015/06/120540 12/31/2014 GCR 2015/07/010415 01/31/2015 GCR 411000 Perm Full Time 850110 Airport Operations 76850110 411000 Perm Full Time 2015/01/070104 07/11/2014 PRJ 2015/01/070457 07/25/2014 PRJ 2015/01/070582 07/11/2014 GNI 2015/02/080093 08/08/2014 PRJ 2015/02/080450 08/22/2014 PRJ 2015/02/080469 08/22/2014 PRJ 2015/02/080508 08/22/2014 GRV 2015/03/090093 09/05/2014 PRJ ORIGINAL TRANFRS/ APPROP ADJSTMTS 0 -212,893.00 REF SC -1,000.00 REF SC 68,415 -5,701.25 REF REJE#2 -5,701.25 REF REJE#2 -5,701.25 REF REJE#2 -5,701.25 REF REJE#2 -5,701.25 REF REJE#2 -5,701.25 REF REJE#2 -5,701.25 REF REJE#2 55,307 2,081.60 REF 070514 2,127.20 REF 071914 -1,338.17 REF NS 2,127.20 REF 080214 2,127.20 REF 081614 2,127.20 REF 081614 -2,127.20 REF 081614 2.127.20 REF 083014 0 0 -213,893.00 .00 213,893.00 100.0°% CA 1-11 WRY DEVELOPERS, INC S CA 1-11 WRY DEVELOPERS, INC S 0 -68,415 -39,908.75 .00 -28,506.25 58.3°%* Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund 0 55,307 32,651.43 .00 22,655.57 59.0°% WARRANT -070514 RUN -1 BIWEEKLY WARRANT -071914 RUN -1 BIWEEKLY PAYROLL WARRANT -080214 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY 82214 dupe entries 80450&80469 WARRANT -083014 RUN -1 BIWEEKLY JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 0 0 -213,893.00 .00 213,893.00 100.0°% CA 1-11 WRY DEVELOPERS, INC S CA 1-11 WRY DEVELOPERS, INC S 0 -68,415 -39,908.75 .00 -28,506.25 58.3°%* Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund Ptax from Gen Fund 0 55,307 32,651.43 .00 22,655.57 59.0°% WARRANT -070514 RUN -1 BIWEEKLY WARRANT -071914 RUN -1 BIWEEKLY PAYROLL WARRANT -080214 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY 82214 dupe entries 80450&80469 WARRANT -083014 RUN -1 BIWEEKLY Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 15 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 PRJ 2,127.20 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED -1 BIWEEKLY AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 09/19/2014 PRJ 2,127.20 REF 091314 WARRANT -091314 RUN -1 BIWEEKLY 10/03/2014 PRJ 2,127.20 07/25/2014 REF 092714 WARRANT -092714 RUN -1 BIWEEKLY 10/17/2014 PRJ 2,127.20 2015/02/080093 REF 101114 WARRANT -101114 RUN -1 BIWEEKLY 10/31/2014 PRJ 2,127.20 RUN REF 103114 WARRANT -102514 RUN -1 BIWEEKLY 11/14/2014 PRJ 2,127.20 WARRANT REF 110814 WARRANT -110814 RUN -1 BIWEEKLY 11/26/2014 PRJ 2,127.20 REF REF 112214 WARRANT -112214 RUN -1 BIWEEKLY 12/12/2014 PRJ 2,127.20 75.00 REF 120614 WARRANT -120614 RUN -1 BIWEEKLY 12/24/2014 PRJ 2,127.20 12/12/2014 REF 122014 WARRANT -122014 RUN -1 BIWEEKLY 01/09/2015 PRJ 2,127.20 2015/07/010242 REF 010315 WARRANT -010315 RUN -1 BIWEEKLY 01/23/2015 PRJ 2,127.20 RUN REF 011715 WARRANT -011715 RUN -1 BIWEEKLY 02/06/2015 PRJ 2,127.20 REF 013115 WARRANT -013115 RUN -1 BIWEEKLY 413000 Temporary Employees 850110 Airport Operations 76850110 413000 Temporary Employee 0 0 0 504.88 .00 -504.88 100.0°%* 2015/01/070457 07/25/2014 PRJ 39.88 REF 071914 WARRANT -071914 RUN -1 BIWEEKLY 2015/02/080093 08/08/2014 PRJ 71.25 REF 080214 WARRANT -080214 RUN -1 BIWEEKLY 2015/04/100007 10/03/2014 PRJ 97.50 REF 092714 WARRANT -092714 RUN -1 BIWEEKLY 2015/04/100548 10/31/2014 PRJ 120.00 REF 103114 WARRANT -102514 RUN -1 BIWEEKLY 2015/05/110420 11/26/2014 PRJ 75.00 REF 112214 WARRANT -112214 RUN -1 BIWEEKLY 2015/06/120165 12/12/2014 PRJ 60.00 REF 120614 WARRANT -120614 RUN -1 BIWEEKLY 2015/07/010242 01/23/2015 PRJ 41.25 REF 011715 WARRANT -011715 RUN -1 BIWEEKLY 414500 Longevity Pay 850110 Airport Operations 76850110 414500 Longevity Pay 325 0 325 325.00 .00 .00 100.0°%* 2015/05/110420 11/26/2014 PRJ 325.00 REF 112214 WARRANT -112214 RUN -1 BIWEEKLY Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 16 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 421100 Health Insurance 850110 Airport Operations 76850110 421100 Health Insurance 07/11/2014 PRJ 07/25/2014 PRJ 08/08/2014 PRJ 08/22/2014 PRJ 08/22/2014 PRJ 08/22/2014 GRV 09/05/2014 PRJ 09/19/2014 PRJ 10/03/2014 PRJ 10/17/2014 PRJ 11/14/2014 PRJ 11/26/2014 PRJ 12/12/2014 PRJ 12/24/2014 PRJ 01/09/2015 PRJ 01/23/2015 PRJ 02/06/2015 PRJ 421200 Dental Insurance 850110 Airport Operations 76850110 421200 Dental Insurance ORIGINAL TRANFRS/ APPROP ADJSTMTS 4.650 196.14 REF 070514 196.14 REF 071914 196.14 REF 080214 196.14 REF 081614 196.14 REF 081614 -196.14 REF 081614 196.14 REF 083014 196.14 REF 091314 196.14 REF 092714 196.14 REF 101114 196.14 REF 110814 196.14 REF 112214 196.14 REF 120614 196.14 REF 122014 196.14 REF 010315 196.14 REF 011715 196.14 REF 013115 JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 0 4.650 2.942.10 00 1.707.90 63.3°% WARRANT -070514 RUN -1 BIWEEKLY WARRANT -071914 RUN -1 BIWEEKLY WARRANT -080214 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY 82214 dupe entries 80450&80469 WARRANT -083014 RUN -1 BIWEEKLY WARRANT -091314 RUN -1 BIWEEKLY WARRANT -092714 RUN -1 BIWEEKLY WARRANT -101114 RUN -1 BIWEEKLY WARRANT -110814 RUN -1 BIWEEKLY WARRANT -112214 RUN -1 BIWEEKLY WARRANT -120614 RUN -1 BIWEEKLY WARRANT -122014 RUN -1 BIWEEKLY WARRANT -010315 RUN -1 BIWEEKLY WARRANT -011715 RUN -1 BIWEEKLY WARRANT -013115 RUN -1 BIWEEKLY 327 0 327 205.35 00 121.65 62.8°% 07/11/2014 PRJ 13.69 REF 070514 WARRANT -070514 RUN -1 BIWEEKLY 07/25/2014 PRJ 13.69 REF 071914 WARRANT -071914 RUN -1 BIWEEKLY 08/08/2014 PRJ 13.69 REF 080214 WARRANT -080214 RUN -1 BIWEEKLY 08/22/2014 PRJ 13.69 REF 081614 WARRANT -081614 RUN -1 BIWEEKLY 08/22/2014 PRJ 13.69 REF 081614 WARRANT -081614 RUN -1 BIWEEKLY 08/22/2014 GRV -13.69 REF 081614 82214 dupe entries 80450&80469 09/05/2014 PRJ 13.69 REF 083014 WARRANT -083014 RUN -1 BIWEEKLY 09/19/2014 PRJ 13.69 REF 091314 WARRANT -091314 RUN -1 BIWEEKLY 10/03/2014 PRJ 13.69 REF 092714 WARRANT -092714 RUN -1 BIWEEKLY 10/17/2014 PRJ 13.69 REF 101114 WARRANT -101114 RUN -1 BIWEEKLY 11/14/2014 PRJ 13.69 REF 110814 WARRANT -110814 RUN -1 BIWEEKLY Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 17 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 421200 Dental Insurance JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 421200 Dental Insurance 2015/05/110420 11/26/2014 PRJ 13.69 REF 112214 WARRANT -112214 RUN -1 BIWEEKLY 2015/06/120165 12/12/2014 PRJ 13.69 REF 120614 WARRANT -120614 RUN -1 BIWEEKLY 2015/06/120435 12/24/2014 PRJ 13.69 REF 122014 WARRANT -122014 RUN -1 BIWEEKLY 2015/07/010233 01/09/2015 PRJ 13.69 REF 010315 WARRANT -010315 RUN -1 BIWEEKLY 2015/07/010242 01/23/2015 PRJ 13.69 REF 011715 WARRANT -011715 RUN -1 BIWEEKLY 2015/08/020099 02/06/2015 PRJ 13.69 REF 013115 WARRANT -013115 RUN -1 BIWEEKLY 421300 Life Insurance 850110 Airport Operations 76850110 421300 Life Insurance 07/25/2014 PRJ 08/22/2014 PRJ 08/22/2014 PRJ 08/22/2014 GRV 09/19/2014 PRJ 10/17/2014 PRJ 11/26/2014 PRJ 12/24/2014 PRJ 01/23/2015 PRJ 421400 Disability Insurance 850110 Airport Operations 76850110 421400 Disability Insuran 2015/01/070457 07/25/2014 PRJ 2015/02/080450 08/22/2014 PRJ 2015/02/080469 08/22/2014 PRJ 2015/02/080508 08/22/2014 GRV 2015/03/090245 09/19/2014 PRJ 2015/04/100294 10/17/2014 PRJ 2015/05/110420 11/26/2014 PRJ 2015/06/120435 12/24/2014 PRJ 2015/07/010242 01/23/2015 PRJ 135 0 135 84.28 .00 50.72 62.4% 12.04 REF 071914 12.04 REF 081614 12.04 REF 081614 -12.04 REF 081614 12.04 REF 091314 12.04 REF 101114 12.04 REF 112214 12.04 REF 122014 12.04 REF 011715 WARRANT -071914 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY 82214 dupe entries 80450&80469 WARRANT -091314 RUN -1 BIWEEKLY WARRANT -101114 RUN -1 BIWEEKLY WARRANT -112214 RUN -1 BIWEEKLY WARRANT -122014 RUN -1 BIWEEKLY WARRANT -011715 RUN -1 BIWEEKLY 248 0 248 154.84 .00 93.16 62.4% 22.12 REF 071914 22.12 REF 081614 22.12 REF 081614 -22.12 REF 081614 22.12 REF 091314 22.12 REF 101114 22.12 REF 112214 22.12 REF 122014 22.12 REF 011715 WARRANT -071914 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY 82214 dupe entries 80450&80469 WARRANT -091314 RUN -1 BIWEEKLY WARRANT -101114 RUN -1 BIWEEKLY WARRANT -112214 RUN -1 BIWEEKLY WARRANT -122014 RUN -1 BIWEEKLY WARRANT -011715 RUN -1 BIWEEKLY Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 18 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 422100 FICA 850110 Airport Operations 76850110 422100 FICA 423100 IPERS 07/11/2014 PRJ 07/25/2014 PRJ 07/11/2014 GNI 08/08/2014 PRJ 08/22/2014 PRJ 08/22/2014 PRJ 08/22/2014 GRV 09/05/2014 PRJ 09/19/2014 PRJ 10/03/2014 PRJ 10/17/2014 PRJ 10/31/2014 PRJ 11/14/2014 PRJ 11/26/2014 PRJ 12/12/2014 PRJ 12/24/2014 PRJ 01/09/2015 PRJ 01/23/2015 PRJ 02/06/2015 PRJ 850110 Airport Operations 76850110 423100 IPERS 07/11/2014 PRJ 07/25/2014 PRJ 07/11/2014 GNI 08/08/2014 PRJ 08/22/2014 PRJ 08/22/2014 PRJ 08/22/2014 GRV 09/05/2014 PRJ 09/19/2014 PRJ ORIGINAL TRANFRS/ APPROP ADJSTMTS 4.219 157.72 REF 070514 164.29 REF 071914 -101.39 REF NS 166.64 REF 080214 161.24 REF 081614 161.24 REF 081614 -161.24 REF 081614 161.21 REF 083014 161.23 REF 091314 168.65 REF 092714 161.24 REF 101114 171.91 REF 103114 161.20 REF 110814 191.84 REF 112214 165.79 REF 120614 161.24 REF 122014 161.20 REF 010315 164.41 REF 011715 161.19 REF 013115 4,968 185.89 REF 070514 193.52 REF 071914 -119.50 REF NS 196.32 REF 080214 189.96 REF 081614 189.96 REF 081614 -189.96 REF 081614 189.96 REF 083014 189.96 REF 091314 JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 0 4.219 2.539.61 00 1.679.39 60.2°% WARRANT -070514 RUN -1 BIWEEKLY WARRANT -071914 RUN -1 BIWEEKLY PAYROLL WARRANT -080214 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY 82214 dupe entries 80450&80469 WARRANT -083014 RUN -1 BIWEEKLY WARRANT -091314 RUN -1 BIWEEKLY WARRANT -092714 RUN -1 BIWEEKLY WARRANT -101114 RUN -1 BIWEEKLY WARRANT -102514 RUN -1 BIWEEKLY WARRANT -110814 RUN -1 BIWEEKLY WARRANT -112214 RUN -1 BIWEEKLY WARRANT -120614 RUN -1 BIWEEKLY WARRANT -122014 RUN -1 BIWEEKLY WARRANT -010315 RUN -1 BIWEEKLY WARRANT -011715 RUN -1 BIWEEKLY WARRANT -013115 RUN -1 BIWEEKLY 0 4,968 2,989.90 .00 1,978.10 WARRANT -070514 RUN -1 BIWEEKLY WARRANT -071914 RUN -1 BIWEEKLY PAYROLL WARRANT -080214 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY WARRANT -081614 RUN -1 BIWEEKLY 82214 dupe entries 80450&80469 WARRANT -083014 RUN -1 BIWEEKLY WARRANT -091314 RUN -1 BIWEEKLY 60.2°% Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 19 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 10/03/2014 PRJ 10/17/2014 PRJ 10/31/2014 PRJ 11/14/2014 PRJ 11/26/2014 PRJ 12/12/2014 PRJ 12/24/2014 PRJ 01/09/2015 PRJ 01/23/2015 PRJ 02/06/2015 PRJ 431020 Court Costs & Services 850110 Airport Operations 76850110 431020 Court Costs & Sery 2015/05/110175 11/04/2014 API 432020 Annual Audit 850110 Airport Operations 76850110 432020 Annual Audit 432080 Other Professional Services 850110 Airport Operations ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 198.67 REF 092714 189.96 REF 101114 200.68 REF 103114 189.96 REF 110814 225.68 REF 112214 195.32 REF 120614 189.96 REF 122014 189.96 REF 010315 193.64 REF 011715 189.96 REF 013115 0 0 0 32.00 VND 010269 IN October Recording 1,131 0 76850110 432080 Other Professional 0 0 0 2015/04/100202 10/08/2014 API 150.00 VND 011210 IN J107966 2015/06/120485 12/22/2014 API 936.40 VND 010435 IN 0172686 JOURNAL DETAIL 2015 1 TO 2015 8 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED WARRANT -092714 RUN -1 BIWEEKLY WARRANT -101114 RUN -1 BIWEEKLY WARRANT -102514 RUN -1 BIWEEKLY WARRANT -110814 RUN -1 BIWEEKLY WARRANT -112214 RUN -1 BIWEEKLY WARRANT -120614 RUN -1 BIWEEKLY WARRANT -122014 RUN -1 BIWEEKLY WARRANT -010315 RUN -1 BIWEEKLY WARRANT -011715 RUN -1 BIWEEKLY WARRANT -013115 RUN -1 BIWEEKLY 32.00 JOHNSON COUNTY M .00 -32.00 100.0°%* October Recording 129155 00 1,130.55 .0°% 1,086.40 .00 -1,086.40 100.0°%* HAWKEYE TITLE SERVIC New Abstract for L 127617 STANLEY CONSULTANTS SPCC Plan Update 131445 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 20 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 76850110 432080 651 Other Professio 2015/01/070092 07/03/2014 API 2015/01/070092 07/03/2014 API 2015/01/070178 07/08/2014 API 2015/01/070178 07/08/2014 API 2015/01/070178 07/08/2014 API 2015/01/070548 07/11/2014 GNI 2015/01/070548 07/11/2014 GNI 2015/01/070549 07/18/2014 GNI 2015/01/070549 07/18/2014 GNI 2015/01/070549 07/18/2014 GNI 2015/03/090037 09/02/2014 API 2015/03/090037 09/02/2014 API 2015/03/090284 09/10/2014 API 2015/03/090601 09/05/2014 GNI 2015/03/090603 09/19/2014 GNI 2015/05/110075 11/03/2014 API 2015/06/120485 12/22/2014 API 435056 Delivery Services 850110 Airport Operations 76850110 435056 Delivery Services 2015/02/080494 08/21/2014 API 435060 Legal Publications 850110 Airport Operations 76850110 435060 Legal Publications 2015/01/070197 07/14/2014 API 2015/01/070549 07/18/2014 GNI 2015/06/120300 12/15/2014 API ORIGINAL TRANFRS/ APPROP ADJSTMTS 0 0 500.00 VND 013221 IN 1408281 2,500.00 VND 013222 IN 1121 650.00 VND 010856 IN IVI-14-001974 477.10 VND 013220 IN 10484 500.00 VND 013230 IN 504 -2,500.00 REF NS -500.00 REF NS -650.00 REF NS -500.00 REF NS -477.10 REF NS 800.00 VND 013313 IN 0003142 1,250.00 VND 013314 IN 1402 1,052.69 VND 013219 IN 77650 -1,250.00 REF NS -1,052.69 REF NS 800.00 VND 013101 IN F1yIowal 1,127.15 VND 011424 IN 1214-01 0 2,727.15 .00 -2,727.15 100.0°%* BLUM, RICHARD Fly Iowa - Air Bos 120254 MASSMAN, DARREL Fly Iowa Performer 120310 JET AIR INC IOW Fly Iowa - Perform 120517 VELOCITY GRAPHIX Fly Iowa - Volunte 120705 AHQUABI HOUSE PUBLIS Fly Iowa - Announc 120423 071114 071114 071814 071814 071814 FUEL INC Fly Iowa - VIP air 124541 NIELSEN, GRANT DAVID Fly Iowa - Perform 124625 HEARTLAND INN IOWA C Hotel Rooms for F1 125106 090514 091914 MOYE-ROWLEY DESIGN & Design of Fly Iowa 128975 IOWA AVIATION PROMOT Fly Iowa - Final P 131395 50 0 50 41.20 .00 8.80 82.4°%* 41.20 VND 090107 IN 58048 FEDEX 447138351 P -Card invoice for 50 0 31.90 VND 010238 IN 0002314549 -31.90 REF NS 25.30 VND 010238 IN 0002392854 50 25.30 .00 24.70 50.6% IOWA CITY PRESS CITI Publications 6/2/1 120511 071814 IOWA CITY PRESS CITI November publicati 130535 JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 0 0 500.00 VND 013221 IN 1408281 2,500.00 VND 013222 IN 1121 650.00 VND 010856 IN IVI-14-001974 477.10 VND 013220 IN 10484 500.00 VND 013230 IN 504 -2,500.00 REF NS -500.00 REF NS -650.00 REF NS -500.00 REF NS -477.10 REF NS 800.00 VND 013313 IN 0003142 1,250.00 VND 013314 IN 1402 1,052.69 VND 013219 IN 77650 -1,250.00 REF NS -1,052.69 REF NS 800.00 VND 013101 IN F1yIowal 1,127.15 VND 011424 IN 1214-01 0 2,727.15 .00 -2,727.15 100.0°%* BLUM, RICHARD Fly Iowa - Air Bos 120254 MASSMAN, DARREL Fly Iowa Performer 120310 JET AIR INC IOW Fly Iowa - Perform 120517 VELOCITY GRAPHIX Fly Iowa - Volunte 120705 AHQUABI HOUSE PUBLIS Fly Iowa - Announc 120423 071114 071114 071814 071814 071814 FUEL INC Fly Iowa - VIP air 124541 NIELSEN, GRANT DAVID Fly Iowa - Perform 124625 HEARTLAND INN IOWA C Hotel Rooms for F1 125106 090514 091914 MOYE-ROWLEY DESIGN & Design of Fly Iowa 128975 IOWA AVIATION PROMOT Fly Iowa - Final P 131395 50 0 50 41.20 .00 8.80 82.4°%* 41.20 VND 090107 IN 58048 FEDEX 447138351 P -Card invoice for 50 0 31.90 VND 010238 IN 0002314549 -31.90 REF NS 25.30 VND 010238 IN 0002392854 50 25.30 .00 24.70 50.6% IOWA CITY PRESS CITI Publications 6/2/1 120511 071814 IOWA CITY PRESS CITI November publicati 130535 02/13/2015 11:47 mtharp FOR 2015 08 Airport Commission Agenda & Info Packet Meeting Date 2-19-2015 ICITY OF IOWA CITY P 21 YEAR-TO-DATE BUDGET REPORT Iglytdbud JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 436030 Transportation 850110 Airport Operations 76850110 436030 Transportation 1,000 0 1,000 .00 .00 1,000.00 .0s 436050 Registration 850110 Airport Operations 76850110 436050 Registration 500 0 500 .00 .00 500.00 .0% 436060 Lodging 850110 Airport Operations 76850110 436060 Lodging 500 0 500 .00 .00 500.00 .0% 436080 Meals 850110 Airport Operations 76850110 436080 Meals 200 0 200 .00 .00 200.00 .0% Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 OF IOWA CITY 0 4,155 22 mtharp (CITY YEAR-TO-DATE BUDGET REPORT IP glytdbud FOR 2015 08 AW WELT AMBRISCO INS JOURNAL DETAIL 2015 1 TO 2015 8 759.00 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT Underground Fuel S APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 437010 Comp Liability Insurance 850110 Airport Operations 76850110 437010 Comp Liability Ins 2015/01/070155 07/11/2014 API 2015/01/070260 07/17/2014 API 437020 Fire & Casualty Insurance 850110 Airport Operations 76850110 437020 Fire & Casualty In 2015/06/120569 12/31/2014 GEN 437030 Worker's Comp Insurance 850110 Airport Operations 76850110 437030 Worker's Comp Insu 73 2015/06/120569 12/31/2014 GEN 151.00 REF SS 437041 Bonding & Other Insurance 850110 Airport Operations 76850110 437041 Bonding & Other In 1,030 0 73 151.00 .00 -78.03 206.9°%* #120396 AW Welt Work Comp 0 1.030 .00 .00 1.029.88 .0o 4,155 0 4,155 3,202.00 .00 952.81 77.1°°%* 2,443.00 VND 010046 IN 118144 AW WELT AMBRISCO INS FY15 INSURANCE PRE 120396 759.00 VND 012284 IN 8602487 PETROLEUM MARKETERS Underground Fuel S 120900 12,786 0 12,786 7,883.00 .00 4,902.75 61.7% 7,883.00 REF SS #120396 AW Welt Ambrisco 850110 Airport Operations 76850110 437030 Worker's Comp Insu 73 2015/06/120569 12/31/2014 GEN 151.00 REF SS 437041 Bonding & Other Insurance 850110 Airport Operations 76850110 437041 Bonding & Other In 1,030 0 73 151.00 .00 -78.03 206.9°%* #120396 AW Welt Work Comp 0 1.030 .00 .00 1.029.88 .0o Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 23 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 .00 6,505.45 ORIGINAL APPROP TRANFRS/ ADJSTMTS REVISED BUDGET YTD ACTUAL JOURNAL DETAIL 2015 1 TO AVAILABLE ENCUMBRANCES BUDGET 2015 8 PCT USED 437200 Loss Reserve Payment MIDAMERICAN ENERGY MidAmBilling 07292 38414 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 38414 20140730130510 MIDAMERICAN 850110 Airport Operations 07292 38414 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 38414 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 76850110 437200 Loss Reserve Pavme MidAmerican 5,000 0 5,000 5,000.00 ENERGY MidAmBilling .00 68649302 .00 100.0°%* 2015/05/110503 11/30/2014 GEN 5,000.00 REF SS Loss Reserve Chgbk 438010 Stormwater Utility Charges 850110 Airport Operations 76850110 438010 Stormwater Utilit 13,812 0 13,812 8,283.94 .00 5,527.65 60.0°% 2015/01/070481 07/16/2014 GNI 1,183.42 REF SC JE 011171 057-095-03 STORMWTR 2015/02/080507 08/27/2014 GNI 1,183.42 REF SC JE 011174 057-095-03 STORMWTR 2015/03/090578 09/24/2014 GNI 1,183.42 REF SC JE 011178 057-095-03 STORMWTR 2015/04/100557 10/22/2014 GNI 1,183.42 REF SC JE 011182 057-095-03 STORMWTR 2015/05/110479 11/26/2014 GNI 1,183.42 REF SC JE 011186 057-095-03 STORMWTR 2015/06/120548 12/24/2014 GNI 1,183.42 REF SC JE 011190 057-095-03 STORMWTR 2015/07/010431 01/28/2015 GNI 1,183.42 REF SC JE 011196 057-095-03 STORMWTR 438030 Electricity 850110 Airport Operations 76850110 438030 Electricitv 07/23/2014 API 07/29/2014 API 07/29/2014 API 07/29/2014 API 07/29/2014 API 07/29/2014 API 07/31/2014 GNI 08/25/2014 API 08/25/2014 API 16,956 34.20 VND 010319 IN 27.59 VND 010319 IN 739.82 VND 010319 IN 181.08 VND 010319 IN 944.19 VND 010319 IN 15.33 VND 010319 IN -1,537.49 REF NS 83.50 VND 010319 IN 388.04 VND 010319 IN 0 16,956 10,450.23 .00 6,505.45 61.6% 20140730124921 MIDAMERICAN ENERGY MidAmBilling 07232 47850 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 38414 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 38414 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 38414 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 38414 20140730130510 MIDAMERICAN ENERGY MidAmBilling 07292 38414 MidAmerican 20140828084539 MIDAMERICAN ENERGY MidAmBilling 08252 68649302 20140828084539 MIDAMERICAN ENERGY MidAmBilling 08252 68649302 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 24 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 08/25/2014 API 09/26/2014 API 09/26/2014 API 09/26/2014 API 09/26/2014 API 10/20/2014 API 10/20/2014 API 10/20/2014 API 10/20/2014 API 10/20/2014 API 11/21/2014 API 11/21/2014 API 11/21/2014 API 11/21/2014 API 11/21/2014 API 12/23/2014 API 12/23/2014 API 12/23/2014 API 12/23/2014 API 12/23/2014 API 12/29/2014 API 01/26/2015 API 01/26/2015 API 01/26/2015 API 01/26/2015 API 01/26/2015 API 01/26/2015 API 438050 Landfill Use 850110 Airport Operations ORIGINAL TRANFRS/ APPROP ADJSTMTS 406.56 VND 010319 IN 1,789.24 VND 010319 IN 28.61 VND 010319 IN 401.19 VND 010319 IN 182.71 VND 010319 IN 1,115.72 VND 010319 IN 13.12 VND 010319 IN 149.28 VND 010319 IN 137.38 VND 010319 IN 620.45 VND 010319 IN 12.17 VND 010319 IN 39.59 VND 010319 IN 248.97 VND 010319 IN 182.71 VND 010319 IN 644.33 VND 010319 IN 14.63 VND 010319 IN 78.27 VND 010319 IN 321.61 VND 010319 IN 301.80 VND 010319 IN 878.01 VND 010319 IN 1.99 VND 010319 IN 58.90 VND 010319 IN 96.49 VND 010319 IN 372.95 VND 010319 IN 399.19 VND 010319 IN 989.14 VND 010319 IN 86.60 VND 010319 IN 2.36 VND 010319 IN JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 20140828084539 MIDAMERICAN ENERGY 20140828084539 MIDAMERICAN ENERGY 20140929093311 MIDAMERICAN ENERGY 20140929093311 MIDAMERICAN ENERGY 20140929093311 MIDAMERICAN ENERGY 20140929093311 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20141231091914 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY MidAmBilling 08252 68649302 MidAmBilling 08252 68649302 MidAmBilling 09262 6143989 MidAmBilling 09262 6143989 MidAmBilling 09262 6143989 MidAmBilling 09262 6143989 MidAmBilling 10202 664983 MidAmBilling 10202 664983 MidAmBilling 10202 664983 MidAmBilling 10202 664983 MidAmBilling 10202 664983 MidAmBilling 11212 41 MidAmBilling 11212 41 MidAmBilling 11212 41 MidAmBilling 11212 41 MidAmBilling 11212 41 MidAmBilling 12232 MidAmBilling 12232 MidAmBilling 12232 MidAmBilling 12232 MidAmBilling 12232 MidAmBilling 12292544479861 MidAmBilling 01262 42358 MidAmBilling 01262 42358 MidAmBilling 01262 42358 MidAmBilling 01262 42358 MidAmBilling 01262 42358 MidAmBilling 01262 42358 76850110 438050 Landfill Use 217 0 217 37.80 .00 179.46 17.4% 2015/01/070021 07/01/2014 GNI 30.80 REF SC LA -CI CIC - Airport - 5090 2015/08/020022 02/02/2015 GNI 7.00 REF SC LA -CI CIC - Airport - 5090 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 25 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 438070 Heating Fuel/Gas 850110 Airport Operations 76850110 438070 Heating Fuel/Gas 07/29/2014 API 07/29/2014 API 07/29/2014 API 07/31/2014 GNI 08/25/2014 API 08/25/2014 API 08/25/2014 API 09/26/2014 API 09/26/2014 API 09/26/2014 API 10/20/2014 API 10/20/2014 API 10/20/2014 API 11/21/2014 API 11/21/2014 API 11/21/2014 API 12/23/2014 API 12/23/2014 API 12/23/2014 API 01/26/2015 API 01/26/2015 API 01/26/2015 API 438080 Sewer Utility Charge ORIGINAL TRANFRS/ APPROP ADJSTMTS 4.931 10.00 VND 010319 IN 41.76 VND 010319 IN 123.31 VND 010319 IN -137.93 REF NS 10.00 VND 010319 IN 18.69 VND 010319 IN 192.16 VND 010319 IN 10.00 VND 010319 IN 7.77 VND 010319 IN 16.88 VND 010319 IN 10.00 VND 010319 IN 16.04 VND 010319 IN 14.70 VND 010319 IN 17.90 VND 010319 IN 21.20 VND 010319 IN 80.46 VND 010319 IN 115.09 VND 010319 IN 127.07 VND 010319 IN 450.34 VND 010319 IN 124.48 VND 010319 IN 120.83 VND 010319 IN 553.35 VND 010319 IN 850110 Airport Operations 76850110 438080 Sewer Utility Char 1,362 2015/01/070481 07/16/2014 GNI 44.06 REF SC 2015/01/070481 07/16/2014 GNI 16.13 REF SC 2015/01/070481 07/16/2014 GNI 36.08 REF SC 2015/01/070481 07/16/2014 GNI 8.15 REF SC 2015/01/070481 07/16/2014 GNI 31.09 REF SC 2015/02/080507 08/27/2014 GNI 8.15 REF SC JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 0 4.931 1.944.10 20140730130510 MIDAMERICAN ENERGY 20140730130510 MIDAMERICAN ENERGY 20140730130510 MIDAMERICAN ENERGY MidAmerican 20140828084539 MIDAMERICAN ENERGY 20140828084539 MIDAMERICAN ENERGY 20140828084539 MIDAMERICAN ENERGY 20140929093311 MIDAMERICAN ENERGY 20140929093311 MIDAMERICAN ENERGY 20140929093311 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141029092847 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141124153255 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20141231083823 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 20150128091226 MIDAMERICAN ENERGY 0 1,362 1,199.36 JE 011171 JE 011171 JE 011171 JE 011171 JE 011171 JE 011174 00 2.986.94 39.4% MidAmBilling 07292 38414 MidAmBilling 07292 38414 MidAmBilling 07292 38414 MidAmBilling 08252 68649302 MidAmBilling 08252 68649302 MidAmBilling 08252 68649302 MidAmBilling 09262 6143989 MidAmBilling 09262 6143989 MidAmBilling 09262 6143989 MidAmBilling 10202 664983 MidAmBilling 10202 664983 MidAmBilling 10202 664983 MidAmBilling 11212 41 MidAmBilling 11212 41 MidAmBilling 11212 41 MidAmBilling 12232 MidAmBilling 12232 MidAmBilling 12232 MidAmBilling 01262 42358 MidAmBilling 01262 42358 MidAmBilling 01262 42358 .00 162.20 88.1°°%* 057-115-00 SEWER 057-118-03 SEWER 057-117-00 SEWER 057-114-01 SEWER 057-120-00 SEWER 057-114-01 SEWER Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 26 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 08/27/2014 GNI 8.15 REF SC JE 011174 057-115-00 SEWER 08/27/2014 GNI 48.05 REF SC JE 011174 057-117-00 SEWER 08/27/2014 GNI 24.11 REF SC JE 011174 057-118-03 SEWER 08/27/2014 GNI 126.65 REF SC JE 011174 057-120-00 SEWER 09/24/2014 GNI 44.06 REF SC JE 011178 057-115-00 SEWER 09/24/2014 GNI 36.48 REF SC JE 011178 057-120-00 SEWER 09/24/2014 GNI 36.08 REF SC JE 011178 057-117-00 SEWER 09/24/2014 GNI 8.15 REF SC JE 011178 057-114-01 SEWER 09/24/2014 GNI 28.10 REF SC JE 011178 057-118-03 SEWER 10/22/2014 GNI 36.08 REF SC JE 011182 057-117-00 SEWER 10/22/2014 GNI 8.15 REF SC JE 011182 057-115-00 SEWER 10/22/2014 GNI 8.15 REF SC JE 011182 057-114-01 SEWER 10/22/2014 GNI 28.10 REF SC JE 011182 057-118-03 SEWER 10/22/2014 GNI 40.87 REF SC JE 011182 057-120-00 SEWER 11/26/2014 GNI 112.69 REF SC JE 011186 057-120-00 SEWER 11/26/2014 GNI 44.06 REF SC JE 011186 057-115-00 SEWER 11/26/2014 GNI 71.99 REF SC JE 011186 057-118-03 SEWER 11/26/2014 GNI 40.07 REF SC JE 011186 057-117-00 SEWER 11/26/2014 GNI 8.15 REF SC JE 011186 057-114-01 SEWER 12/24/2014 GNI 8.15 REF SC JE 011190 057-114-01 SEWER 12/24/2014 GNI 8.15 REF SC JE 011190 057-115-00 SEWER 12/24/2014 GNI 48.65 REF SC JE 011190 057-120-00 SEWER 12/24/2014 GNI 40.07 REF SC JE 011190 057-118-03 SEWER 12/24/2014 GNI 32.09 REF SC JE 011190 057-117-00 SEWER 01/28/2015 GNI 8.15 REF SC JE 011196 057-114-01 SEWER 01/28/2015 GNI 44.06 REF SC JE 011196 057-115-00 SEWER 01/28/2015 GNI 36.08 REF SC JE 011196 057-117-00 SEWER 01/28/2015 GNI 32.09 REF SC JE 011196 057-118-03 SEWER 01/28/2015 GNI 40.07 REF SC JE 011196 057-120-00 SEWER 438090 Water Utility Charge 850110 Airport Operations 76850110 438090 Water Utility Char 1.306 0 1.306 1.251.26 00 54.41 95.8%* 2015/01/070481 07/16/2014 GNI 8.67 REF SC JE 011171 057-114-01 WATER 2015/01/070481 07/16/2014 GNI 15.21 REF SC JE 011171 057-095-03 WATER 2015/01/070481 07/16/2014 GNI 24.79 REF SC JE 011171 057-120-00 WATER 2015/01/070481 07/16/2014 GNI 13.01 REF SC JE 011171 057-118-03 WATER 2015/01/070481 07/16/2014 GNI 28.71 REF SC JE 011171 057-117-00 WATER 2015/01/070481 07/16/2014 GNI 45.55 REF SC JE 011171 057-115-00 WATER 2015/02/080507 08/27/2014 GNI 38.13 REF SC JE 011174 057-117-00 WATER Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 27 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ APPROP ADJSTMTS JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 08/27/2014 GNI 19.29 REF SC JE 011174 057-118-03 WATER 08/27/2014 GNI 99.37 REF SC JE 011174 057-120-00 WATER 08/27/2014 GNI 17.29 REF SC JE 011174 057-115-00 WATER 08/27/2014 GNI 22.90 REF SC JE 011174 057-095-03 WATER 08/27/2014 GNI 8.67 REF SC JE 011174 057-114-01 WATER 09/24/2014 GNI 28.71 REF SC JE 011178 057-117-00 WATER 09/24/2014 GNI 16.31 REF SC JE 011178 057-095-03 WATER 09/24/2014 GNI 45.55 REF SC JE 011178 057-115-00 WATER 09/24/2014 GNI 22.43 REF SC JE 011178 057-118-03 WATER 09/24/2014 GNI 8.67 REF SC JE 011178 057-114-01 WATER 09/24/2014 GNI 29.02 REF SC JE 011178 057-120-00 WATER 10/22/2014 GNI 32.48 REF SC JE 011182 057-120-00 WATER 10/22/2014 GNI 22.43 REF SC JE 011182 057-118-03 WATER 10/22/2014 GNI 17.29 REF SC JE 011182 057-115-00 WATER 10/22/2014 GNI 8.67 REF SC JE 011182 057-114-01 WATER 10/22/2014 GNI 28.71 REF SC JE 011182 057-117-00 WATER 10/22/2014 GNI 14.89 REF SC JE 011182 057-095-03 WATER 11/26/2014 GNI 45.55 REF SC JE 011186 057-115-00 WATER 11/26/2014 GNI 31.85 REF SC JE 011186 057-117-00 WATER 11/26/2014 GNI 8.67 REF SC JE 011186 057-114-01 WATER 11/26/2014 GNI 56.97 REF SC JE 011186 057-118-03 WATER 11/26/2014 GNI 89.00 REF SC JE 011186 057-120-00 WATER 11/26/2014 GNI 26.04 REF SC JE 011186 057-095-03 WATER 12/24/2014 GNI 86.96 REF SC JE 011190 057-095-03 WATER 12/24/2014 GNI 8.67 REF SC JE 011190 057-114-01 WATER 12/24/2014 GNI 17.29 REF SC JE 011190 057-115-00 WATER 12/24/2014 GNI 25.57 REF SC JE 011190 057-117-00 WATER 12/24/2014 GNI 31.85 REF SC JE 011190 057-118-03 WATER 12/24/2014 GNI 38.60 REF SC JE 011190 057-120-00 WATER 01/28/2015 GNI 27.14 REF SC JE 011196 057-095-03 WATER 01/28/2015 GNI 8.67 REF SC JE 011196 057-114-01 WATER 01/28/2015 GNI 45.55 REF SC JE 011196 057-115-00 WATER 01/28/2015 GNI 28.71 REF SC JE 011196 057-117-00 WATER 01/28/2015 GNI 25.57 REF SC JE 011196 057-118-03 WATER 01/28/2015 GNI 31.85 REF SC JE 011196 057-120-00 WATER 438100 Refuse Collection Charges 850110 Airport Operations 76850110 438100 Refuse Collection 1,211 0 1,211 754.14 00 456.89 62.3°% 2015/01/070158 07/11/2014 API 69.00 VND 011001 IN 696993 ABC DISPOSAL SYSTEMS SOLID WASTE SERVIC 120416 Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 28 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 07/18/2014 GNI 07/18/2014 GNI 08/15/2014 API 08/15/2014 API 09/19/2014 API 10/09/2014 API 10/09/2014 API 11/10/2014 API 11/10/2014 API 11/10/2014 API 12/05/2014 API 12/05/2014 API 01/15/2015 API 01/15/2015 API 01/15/2015 API 02/04/2015 API 02/04/2015 API 02/04/2015 API 76850110 438100 651 Refuse Collecti 2015/03/090284 09/10/2014 API 438110 Local Phone Service 850110 Airport Operations 76850110 438110 Local Phone Servic 07/15/2014 API 08/20/2014 API 08/20/2014 API 09/09/2014 API 09/19/2014 API 09/19/2014 API 10/09/2014 API 10/07/2014 API 11/12/2014 API 12/05/2014 API 01/14/2015 API 01/14/2015 API ORIGINAL TRANFRS/ APPROP ADJSTMTS 28.00 VND 011001 IN 696992 -69.00 REF NS -28.00 REF NS 69.00 VND 011001 IN 703925 28.00 VND 011001 IN 703924 71.07 VND 011001 IN 711073 71.07 VND 011001 IN 718546 28.84 VND 011001 IN 718544 71.07 VND 011001 IN 725113 28.84 VND 011001 IN 72511 28.84 VND 011001 IN 725112 71.07 VND 011001 IN 731947 28.84 VND 011001 IN 731945 28.84 VND 011001 IN 738888 28.84 VND 011001 IN 738889 71.07 VND 011001 IN 738890 71.07 VND 011001 IN 744942 28.84 VND 011001 IN 744940 28.84 VND 011001 IN 744941 0 0 182.03 VND 013231 IN 168124 JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED ABC DISPOSAL SYSTEMS SOLID WASTE SERVIC 120416 Pickup/Disposal of 071814 INV 40009580 ABC DISPOSAL SYSTEMS Pickup/Disposal of ABC DISPOSAL SYSTEMS Pickup/Disposal of 071814 Pickup/Disposal of ALLIANCE CONNECT OCT 2014 PHONE AND ALLIANCE CONNECT ABC DISPOSAL SYSTEMS Pickup/Disposal of 123207 ABC DISPOSAL SYSTEMS Pickup/Disposal of 123207 ABC DISPOSAL SYSTEMS Pickup/Disposal of 126762 ABC DISPOSAL SYSTEMS Pickup/Disposal of 127528 ABC DISPOSAL SYSTEMS Pickup/Disposal of 127528 ABC DISPOSAL SYSTEMS Pickup/Disposal of 129295 ABC DISPOSAL SYSTEMS Pickup/Disposal of 129295 ABC DISPOSAL SYSTEMS Pickup/Disposal of 129295 ABC DISPOSAL SYSTEMS Pickup/Disposal of 130194 ABC DISPOSAL SYSTEMS Pickup/Disposal of 130194 ABC DISPOSAL SYSTEMS Pickup/Disposal of 132648 ABC DISPOSAL SYSTEMS Pickup/Disposal of 132648 ABC DISPOSAL SYSTEMS Pickup/Disposal of 132648 ABC DISPOSAL SYSTEMS Pickup/Disposal of 133141 ABC DISPOSAL SYSTEMS Pickup/Disposal of 133141 ABC DISPOSAL SYSTEMS Pickup/Disposal of 133141 0 182.03 00 -182.03 100.0°%* HAWKEYE WASTE SYSTEM Dumpster - Fly Iow 125102 0 0 0 713.02 85.47 VND 011937 IN 40008725 85.47 VND 011937 IN 40009148 3.75 VND 011001 IN 708474 85.47 VND 011937 IN 40009580 24.19 VND 011001 IN 711072 28.84 VND 011001 IN 711071 28.84 VND 011001 IN 718545 85.47 VND 011937 IN 40010027 85.53 VND 011937 IN 00044658-6 28.84 VND 011001 IN 731946 85.62 VND 011937 IN 40011390 85.53 VND 011937 IN 40010932 00 -713.02 100.0°%* ALLIANCE CONNECT JUL 2014 INV 40008 ALLIANCE CONNECT AUG 2014 INV 40009 ABC DISPOSAL SYSTEMS Pickup/Disposal of ALLIANCE CONNECT INV 40009580 ABC DISPOSAL SYSTEMS Pickup/Disposal of ABC DISPOSAL SYSTEMS Pickup/Disposal of ABC DISPOSAL SYSTEMS Pickup/Disposal of ALLIANCE CONNECT OCT 2014 PHONE AND ALLIANCE CONNECT NOV 2014 INV ABC DISPOSAL SYSTEMS Pickup/Disposal of ALLIANCE CONNECT JAN 2015 INV ALLIANCE CONNECT DEC 2014 INV 120746 124210 124205 125047 126762 126762 127528 127541 129301 130194 131947 131947 Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 29 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 438120 Long Distance Service 850110 Airport Operations 76850110 438120 Long Distance Sery 2015/01/070456 07/01/2014 GNI 2015/02/080480 08/02/2014 GNI 2015/03/090538 09/02/2014 GNI 2015/04/100599 10/10/2014 GNI 2015/05/110537 11/05/2014 GNI 2015/06/120556 12/01/2014 GNI 2015/07/010534 01/04/2015 GNI 442010 Other Building R&M Services 850110 Airport Operations ORIGINAL TRANFRS/ APPROP ADJSTMTS 55 0 6.22 REF SS 4.08 REF SC 4.79 REF SC 4.79 REF SS .81 REF SC 8.38 REF SS 1.51 REF SC JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 55 30.58 00 24.42 55.6°% CH JUL LONG DIST CHGBK CH AUG LONG DIST CHGBK CH SEP LONG DIST CHGBK CH OCT LONG DIST CHGBK CH NOV LONG DIST CHGBK CH DEC LONG DIST CHGBK CH JAN LONG DIST CHGBK 76850110 442010 Other Building R&M 12,000 0 12,000 7,643.80 07/01/2014 API 267.50 JET AIR VND 010358 IN W87315 120298 07/01/2014 API 716.00 JET AIR VND 010358 IN W86787 120576 07/01/2014 API 5.29 VND 010856 IN IVI-14-001903 07/01/2014 API 10.23 VND 010856 IN IVI-14-001903 123320 07/01/2014 API 500.00 MARV'S GLASS VND 010856 IN IVI-14-001901 125161 07/01/2014 API 500.00 JET AIR VND 010856 IN IVI-14-001484 125129 07/08/2014 API 350.50 JET AIR VND 010358 IN W87736 07/11/2014 GNI -267.50 REF NS 07/11/2014 GNI -716.00 REF NS 07/11/2014 GNI -15.52 REF NS 07/11/2014 GNI -500.00 REF NS 07/18/2014 GNI -350.50 REF NS 08/08/2014 API 545.50 VND 010358 IN W89234 08/08/2014 API 907.50 VND 010358 IN W89233 08/08/2014 API 85.00 VND 010634 IN 94392 09/10/2014 API 893.58 VND 010358 IN W90928 09/10/2014 API 136.96 VND 010495 IN 139 09/10/2014 API 500.00 VND 010856 IN IVI-14-002687 09/10/2014 API 500.00 VND 010856 IN IVI-14-002685 09/24/2014 API 170.00 VND 010358 IN W86715 11/06/2014 API 500.00 VND 010856 IN IVI-14-003545 00 4,356.20 63.7°% OVERHEAD DOOR COMPAN Hangar H Door Repa 120324 OVERHEAD DOOR COMPAN Hangar 61 Repairs 120324 JET AIR INC IOW Maintenance Suppli 120298 JET AIR INC IOW Maintenance Suppli 120298 JET AIR INC IOW JULY JANITORIAL SE 120298 JET AIR INC IOW JUNE JANITORIAL SE 120298 OVERHEAD DOOR COMPAN Building H Garage 120576 071114 071114 071114 071114 071814 OVERHEAD DOOR COMPAN Hangar #53 Door Re 123320 OVERHEAD DOOR COMPAN Hangar #34 Door Se 123320 MARV'S GLASS SPECIAL Reinstall Gasket - 123303 OVERHEAD DOOR COMPAN Hangar #57 Door Se 125161 WEST BRANCH ROOFING Hangar #54 roof re 125263 JET AIR INC IOW janitorial service 125129 JET AIR INC IOW Janitorial Service 125129 OVERHEAD DOOR COMPAN Hangar Door #29 Re 127127 JET AIR INC IOW November Janitoria 129380 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 30 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 6/2014 API 500.00 IOW VND 010856 IN IVI-14-003071 VND 012238 IN 3/2014 API 500.00 150.00 VND 010856 IN IVI-14-003906 442030 Heating Equipment R&M Services AIR 3/2014 API 17.92 130540 VND 010856 IN IVI-14-003709 July Maintenance R 130540 3/2014 API 41.13 130713 VND 010856 IN IVI-14-003637 VND 010856 IN 3/2014 API 89.96 527.00 VND 010856 IN IVI-14-003637 442040 Cooling Equipment R&M Services 6/2014 API 72.50 VND 010606 IN 029533 6/2015 API 683.75 1,000 VND 010358 IN W95937 6/2015 API 500.00 VND 010856 IN ivi-15-000005 5/2015 API 500.00 VND 010856 IN IVI-15-000320 442020 Structure R&M Services 850110 Airport Operations 76850110 442020 Structure R&M Sery AIR 4,000 IOW 0 4,000 2015/04/100353 10/17/2014 API 150.00 VND 012238 IN CER653338 614 2015/06/120285 12/11/2014 API 150.00 VND 012238 IN CER65338 914 442030 Heating Equipment R&M Services AIR INC IOW July Maintenance R 130540 850110 Airport Operations AIR INC IOW July Maintenance R 130540 76850110 442030 Heating Equipment LOCK AND KEY 1,000 130713 0 1,000 2015/05/110243 11/06/2014 API 11.32 VND 010856 IN IVI-14-003544 Janitorial Service 2015/06/120403 12/16/2014 API 527.00 VND 010005 IN 9943496 Cleaning/Janitoria 442040 Cooling Equipment R&M Services 850110 Airport Operations 76850110 442040 Cooling Equipment 1,000 0 1,000 JOURNAL DETAIL 2015 1 TO 2015 8 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED JET AIR INC IOW September Janitori 129380 JET AIR INC IOW Janitorial Service 130295 JET AIR INC IOW Maintenance Reimbu 130295 JET AIR INC IOW July Maintenance R 130540 JET AIR INC IOW July Maintenance R 130540 DON'S LOCK AND KEY Terminal Door lock 130713 OVERHEAD DOOR COMPAN Hangar #49 Door Re 132792 JET AIR INC IOW Janitorial Service 132750 JET AIR INC IOW Cleaning/Janitoria 133225 300.00 .00 3,700.00 7.5% OTIS ELEVATOR COMPAN ELEVATOR SERVICE C 127954 OTIS ELEVATOR COMPAN ELEVATOR SERVICE C 130584 538.32 .00 461.68 53.8°% JET AIR INC IOW Maintenance Reimbu 129380 AAA MECHANICAL INC HVAC Preventive Ma 130674 LS 00 1,000.00 .0°% Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 31 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 442060 Electrical & Plumbing R&M Srvc 850110 Airport Operations 76850110 442060 Electrical & Plumb JET AIR 4,879 IOW 0 4,879 2015/01/070116 IOW 07/01/2014 API 6.48 IOW VND 010856 IN IVI-14-001903 JET 2015/01/070116 INC 07/01/2014 API 168.95 IN VND 010856 IN IVI-14-001903 INC 2015/01/070548 JUNE MAINTENANCE R 07/11/2014 GNI -175.43 REF NS -4.23 REF 2015/06/120170 12/03/2014 API 85.35 VND 010856 IN IVI-14-003709 2015/03/090284 2015/06/120170 12/03/2014 API 3.48 VND 010856 IN IVI-14-003709 2015/07/010379 JET AIR 01/26/2015 API 509.08 125129 VND 010856 IN ivi-14-004207 API 2015/07/010379 01/26/2015 API 89.00 IVI-14-003069 VND 010856 IN ivi-14-004207 IOW 2015/08/020139 129380 02/05/2015 API 68.90 11/06/2014 VND 010856 IN IVI-15-000353 010856 442070 Bldg Pest Control Services JET AIR INC IOW Maintenance Reimbu 129380 2015/06/120403 850110 Airport Operations 12/16/2014 API 995.00 VND 013552 IN 53118 76850110 442070 Bldg Pest Control 424 130785 0 424 2015/04/100185 10/09/2014 API 33.95 VND 012736 IN 010914 2015/06/120285 12/11/2014 API 33.95 VND 012736 IN 12114 2015/07/010212 01/13/2015 API 33.95 VND 012736 IN 011315 443080 Other Equipment R&M Services 850110 Airport Operations JOURNAL DETAIL 2015 1 TO 2015 8 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 755.81 JET AIR INC IOW JET AIR INC IOW .00 4,123.34 15.5°% Maintenance Suppli 120298 Maintenance Suppli 120298 Maintenance Reimbu 130295 Maintenance Reimbu 130295 Maintenance Reimbu 132750 Maintenance Reimbu 132750 Maintenance Reimbu 133225 101.85 .00 322.01 24.0°% GENERAL PEST CONTROL Pest Control Servi 127616 GENERAL PEST CONTROL Pest Control Servi 130521 GENERAL PEST CONTROL Pest Control Servi 131999 76850110 443080 071114 JET AIR INC IOW JET AIR INC IOW JET AIR INC IOW JET AIR INC IOW JET AIR INC IOW .00 4,123.34 15.5°% Maintenance Suppli 120298 Maintenance Suppli 120298 Maintenance Reimbu 130295 Maintenance Reimbu 130295 Maintenance Reimbu 132750 Maintenance Reimbu 132750 Maintenance Reimbu 133225 101.85 .00 322.01 24.0°% GENERAL PEST CONTROL Pest Control Servi 127616 GENERAL PEST CONTROL Pest Control Servi 130521 GENERAL PEST CONTROL Pest Control Servi 131999 76850110 443080 Other Equipment R& 3,000 0 3,000 5,048.26 .00 -2,048.26 168.3°%* 2015/01/070116 07/01/2014 API 4.23 VND 010856 IN IVI-14-001483 JET AIR INC IOW JUNE MAINTENANCE R 120298 2015/01/070548 07/11/2014 GNI -4.23 REF NS 071114 2015/03/090284 09/10/2014 API 1,562.63 VND 010856 IN IVI-14-002683 JET AIR INC IOW Maintenance Suppli 125129 2015/05/110243 11/06/2014 API 495.44 VND 010856 IN IVI-14-003069 JET AIR INC IOW Maintenance Reimbu 129380 2015/05/110243 11/06/2014 API 153.02 VND 010856 IN IVI-14-003544 JET AIR INC IOW Maintenance Reimbu 129380 2015/06/120403 12/16/2014 API 995.00 VND 013552 IN 53118 QT POD Service Agreement 130785 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 32 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 443080 Other Equipment R& 2015/06/120403 12/16/2014 API 895.50 VND 013552 IN 53119 2015/08/020139 02/05/2015 API 476.67 VND 010856 IN IVI-15-000353 2015/08/020139 02/05/2015 API 470.00 VND 011374 IN 67808 444060 Cable & Electrical R&M Srvcs 850110 Airport Operations 76850110 444060 Cable & Electrical 0 0 2015/01/070127 07/07/2014 API 320.34 Maintenance Suppli VND 011112 IN 131318 2015/01/070549 07/18/2014 GNI -320.34 JET REF NS INC 2015/08/020075 02/02/2015 API 389.00 VND 011112 IN 141909 445030 Nursery Srvc-Lawn & Plant Care 071114 850110 Airport Operations INC IOW Mowing/groundskeep JET 76850110 445030 Nursery Srvc-Lawn 2015/01/070116 07/01/2014 API 2015/01/070116 07/01/2014 API 2015/01/070116 07/01/2014 API 2015/01/070548 07/11/2014 GNI 2015/01/070548 07/11/2014 GNI 2015/03/090284 09/10/2014 API 2015/03/090284 09/10/2014 API 2015/05/110243 11/06/2014 API 2015/05/110243 11/06/2014 API 2015/06/120076 12/02/2014 API 2015/06/120170 12/03/2014 API 2015/06/120170 12/03/2014 API 2015/06/120170 12/03/2014 API 49,200 207.79 VND 010856 4,500.00 VND 010856 4,500.00 VND 010856 -207.79 REF NS 4,500.00 REF NS 4,500.00 VND 010856 4,500.00 VND 010856 4,500.00 VND 010856 4,500.00 VND 010856 4,100.00 VND 011702 16.95 VND 010856 43.69 VND 010856 -86.10 VND 010856 QT POD Service Agreement 130785 JET AIR INC IOW Maintenance Reimbu 133225 CARE AMBULANCE SERVI Share Cost of Wiri 133168 0 389.00 0 49, 20C IN IVI-14-001903 IN IVI-14-001992 IN IVI-14-001485 IN IVI-14-002686 IN IVI-14-002684 IN IVI-14-003546 IN IVI-14-003070 IN 180111414 IN IVI-14-003709 IN IVI-14-003709 IN IVI-14-003709 TRI CITY ELECTRIC 071814 TRI CITY ELECTRIC 00 -389.00 100.0%* INV 131318 120622 AIRPORT - CABLE FR 133071 26,574.54 .00 22,625.46 JET AIR INC IOW Maintenance Suppli JET AIR INC IOW JULY MAINTENACE/GR JET AIR INC IOW JUNE GROUNDSKEEPIN 071114 071114 JET AIR INC IOW Mowing/groundskeep JET AIR INC IOW Groundskeeping/Mow JET AIR INC IOW Groundskeeping/Mai JET AIR INC IOW Groundskeeping/Mai KRUSE TREE SERVICE I Gilbert Street Are JET AIR INC IOW Maintenance Reimbu JET AIR INC IOW Maintenance Reimbu JET AIR INC IOW Maintenance Reimbu 54.0°% 120298 120298 120298 125129 125129 129380 129380 103267 130295 130295 130295 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 33 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ APPROP ADJSTMTS REVISED BUDGET YTD JOURNAL DETAIL 2015 1 TO AVAILABLE ACTUAL ENCUMBRANCES BUDGET 2015 8 PCT USED 445080 Snow and Ice Removal 850110 Airport Operations 76850110 445080 Snow and Ice Remov 18,000 0 18,000 13,500.00 .00 4,500.00 75.0°°%* 2015/06/120170 12/03/2014 API 4,500.00 VND 010856 IN IVI-14-003905 JET AIR INC IOW Groundskeeping/Sno 130295 2015/07/010379 01/26/2015 API 4,500.00 VND 010856 IN ivi-15-000006 JET AIR INC IOW Maintenance/Ground 132750 2015/08/020139 02/05/2015 API 4,500.00 VND 010856 IN IVI-15-000319 JET AIR INC IOW Groundskeeping/Sno 133225 445110 Testing Services 850110 Airport Operations 76850110 445110 Testing Services 814 0 814 622.60 .00 191.62 76.5°%* 2015/01/070116 07/01/2014 API 382.60 VND 010931 IN 1032737 TANKNOLOGY INC Annual Line/Leak T 120349 2015/01/070548 07/11/2014 GNI -382.60 REF NS 071114 2015/08/020139 02/05/2015 API 622.60 VND 010931 IN 1042750 TANKNOLOGY INC 3 Year cathodic pr 133317 445140 Outside Printing 850110 Airport Operations 76850110 445140 Outside Printing 100 0 100 .00 .00 100.00 .0°% 76850110 445140 651 Outside Printin 0 0 0 122.96 .00 -122.96 100.0°%* 2015/01/070092 07/03/2014 API 36.50 VND 010373 IN 84543 PIP PRINTING Fly Iowa Poster Pr 120327 2015/01/070092 07/03/2014 API 26.50 VND 010373 IN 84502 PIP PRINTING Fly Iowa Poster pr 120327 2015/01/070092 07/03/2014 API 480.54 VND 010373 IN 84711 PIP PRINTING Fly Iowa Banner Pr 120327 2015/01/070092 07/03/2014 API 908.21 VND 010373 IN 84770 PIP PRINTING Fly Iowa - Wayfind 120327 2015/01/070548 07/11/2014 GNI -36.50 REF NS 071114 2015/01/070548 07/11/2014 GNI -26.50 REF NS 071114 2015/01/070548 07/11/2014 GNI -480.54 REF NS 071114 2015/01/070548 07/11/2014 GNI -908.21 REF NS 071114 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 34 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 76850110 445140 651 Outside Printin 2015/03/090037 09/02/2014 API 2,268.82 VND 013312 IN 121295 2015/03/090601 09/05/2014 GNI -2,268.82 REF NS 2015/05/110075 11/03/2014 API 122.96 VND 011424 IN 1014-01 446100 City Attorney Chargeback 850110 Airport Operations 76850110 446100 City Attorney Char 2,981 2015/03/090591 09/30/2014 GEN 1,055.61 REF SS 2015/06/120592 12/31/2014 GEN 1,470.69 REF SS 446130 ITS-PC/Peripheral Supprt Chgbk 850110 Airport Operations 76850110 446130 ITS-PC/Peripheral 800 2015/04/100406 10/01/2014 GNI 800.00 REF SC 446140 ITS -Computer Replacement Chgbk 850110 Airport Operations 76850110 446140 ITS -Computer Repla 2,867 2015/01/070057 07/01/2014 GNI 50.00 REF SC 2015/02/080474 08/01/2014 GNI 218.10 REF SC 2015/03/090150 09/01/2014 GNI 218.10 REF SC 2015/04/100198 10/01/2014 GNI 218.10 REF SC 2015/05/110442 11/01/2014 GNI 218.10 REF SC 2015/06/120126 12/01/2014 GNI 218.10 REF SC 2015/07/010109 01/01/2015 GNI 218.10 REF SC 2015/08/020109 02/01/2015 GNI 218.10 REF SC 0 JOURNAL DETAIL 2015 1 TO 2015 8 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED CEDAR GRAPICS IN Fly Iowa - Program 124515 090514 IOWA AVIATION PROMOT Expense Reimbursem 128926 2,981 2,526.30 .00 455.15 84.7°°%* Jul -Sep City Atty Chg Oct -Dec City Atty Chg 800 800.00 .00 .00 100.0°%* CH FY15 ITS ANNUAL CHGB 2,867 1,576.70 .00 1,289.97 55.0°% CH JUL ITS REPL CHGBCK CH AUG ITS REPL CHGBCK CH SEP ITS REPL CHGBCK CH OCT ITS REPL CHGBCK CH NOV ITS REPL CHGBCK CH DEC ITS REPL CHGBCK CH JAN ITS REPL CHGBCK CH FEB ITS REPL CHGBCK Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 OF IOWA CITY 35 mtharp (CITY YEAR-TO-DATE BUDGET REPORT IP glytdbud FOR 2015 08 100.0°%* JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT FY15 APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 446160 ITS-Network/Internet Chgbk 850110 Airport Operations 76850110 446160 ITS-Network/Intern 8,505 0 8,505 8,505.00 .00 .00 100.0°%* 2015/02/080503 08/01/2014 GNI 8,505.00 REF SS FY15 ITS NETWORK CHARGEBACK 446200 Photocopying Chargeback 850110 Airport Operations 76850110 446200 Photocopying Charg 71 0 71 .06 .00 71.10 .1°% 2015/01/070486 07/01/2014 GNI .06 REF SS Jun Copy Charges 446220 Phone Service Chargeback 850110 Airport Operations 76850110 446220 Phone Service Char 1,021 0 1,021 .00 .00 1,021.00 .0°% 446300 Phone Equipment/Line Chgbk 850110 Airport Operations 76850110 446300 Phone Equipment/Li 1,140 0 1,140 700.00 .00 440.00 61.4°% 2015/01/070456 07/01/2014 GNI 100.00 REF SS CH JUL PHON EQUIP CHGBK 2015/02/080480 08/02/2014 GNI 100.00 REF SC CH AUG PHON EQUIP CHGBK 2015/03/090538 09/02/2014 GNI 100.00 REF SC CH SEP PHON EQUIP CHGBK Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 36 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ APPROP ADJSTMTS 76850110 446300 Phone EauiPment/Li 2015 8 REVISED AVAILABLE 76850110 446320 2015/04/100599 YTD ACTUAL ENCUMBRANCES BUDGET 10/10/2014 GNI 100.00 07/01/2014 REF SS 2015/05/110537 REF SS 11/05/2014 GNI 100.00 GNI REF SC 2015/06/120556 SS 2015/03/090568 12/01/2014 GNI 100.00 5.55 REF SS 2015/07/010534 2015/04/100554 01/04/2015 GNI 100.00 REF SC 446320 Mail Chargeback 850110 Airport Operations 2015 1 TO 2015 8 REVISED AVAILABLE 76850110 446320 Mail Chargeback YTD ACTUAL ENCUMBRANCES BUDGET 323 2015/01/070487 07/01/2014 GNI 3.67 REF SS 2015/02/080501 08/01/2014 GNI .62 REF SS 2015/03/090568 09/01/2014 GNI 5.55 REF SS 2015/04/100554 10/01/2014 GNI 129.86 REF SS 2015/05/110485 11/01/2014 GNI 7.64 REF SS 2015/06/120550 12/01/2014 GNI .62 REF SS 446350 City Vehicle Replacement Chgbk 850110 Airport Operations 76850110 446350 City Vehicle Repla 16,757 2015/01/070491 07/31/2014 GNI 2,164.48 REF SC 2015/02/080491 08/31/2014 GNI 1,394.04 REF SC 2015/03/090560 09/30/2014 GNI 1,394.04 REF SC 2015/04/100579 10/31/2014 GNI 1,394.04 REF SC 2015/05/110538 11/30/2014 GNI 1,401.42 REF SC 2015/06/120534 12/31/2014 GNI 1,394.04 REF SC 2015/07/010535 01/31/2015 GNI 1,394.04 REF SC 446360 City Vehicle Rental Chargeback 850110 Airport Operations CH OCT PHON EQUIP CHGBK CH NOV PHON EQUIP CHGBK CH DEC PHON EQUIP CHGBK CH JAN PHON EQUIP CHGBK 0 323 147.96 .00 JUn Mail Charges JUL Mail Charges AUG Mail Charges SEP Mail Charges OCT Mail Charges NOV Mail Charges 174.89 45.8°% 0 16,757 10,536.10 .00 6,220.42 62.9°% CH JUL REPLACEMENT COST CH AUG REPLACEMENT COST CH SEP REPLACEMENT COST CH OCT REPLACEMENT COST CH NOV REPLACEMENT COST CH DEC REPLACEMENT COST CH JAN REPLACEMENT COST JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED CH OCT PHON EQUIP CHGBK CH NOV PHON EQUIP CHGBK CH DEC PHON EQUIP CHGBK CH JAN PHON EQUIP CHGBK 0 323 147.96 .00 JUn Mail Charges JUL Mail Charges AUG Mail Charges SEP Mail Charges OCT Mail Charges NOV Mail Charges 174.89 45.8°% 0 16,757 10,536.10 .00 6,220.42 62.9°% CH JUL REPLACEMENT COST CH AUG REPLACEMENT COST CH SEP REPLACEMENT COST CH OCT REPLACEMENT COST CH NOV REPLACEMENT COST CH DEC REPLACEMENT COST CH JAN REPLACEMENT COST Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 37 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 446370 Fuel Chargeback JOURNAL DETAIL 2015 1 TO 2015 8 ORIGINAL TRANFRS/ REVISED 2015/01/070491 AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 446360 City Vehicle Renta 500 0 500 117.00 .00 383.00 23.4°% 2015/05/110538 11/30/2014 GNI 117.00 REF SC CH NOV OPERATION COST 446370 Fuel Chargeback 850110 Airport Operations 76850110 446370 Fuel Chargeback 4,542 0 4,542 3,180.59 .00 1,361.82 70.0°°%* 2015/01/070491 07/31/2014 GNI 797.48 REF SC CH JUL DIVISION FUEL 2015/02/080491 08/31/2014 GNI 418.40 REF SC CH AUG DIVISION FUEL 2015/03/090560 09/30/2014 GNI 597.72 REF SC CH SEP DIVISION FUEL 2015/04/100579 10/31/2014 GNI 434.48 REF SC CH OCT DIVISION FUEL 2015/05/110538 11/30/2014 GNI 202.43 REF SC CH NOV DIVISION FUEL 2015/06/120534 12/31/2014 GNI 154.90 REF SC CH DEC DIVISION FUEL 2015/07/010535 01/31/2015 GNI 575.18 REF SC CH JAN DIVISION FUEL 446380 Vehicle R&M Chargeback 850110 Airport Operations 76850110 446380 Vehicle R&M Charge 9,023 0 9,023 15,602.24 .00 -6,579.26 172.9°%* 2015/01/070491 07/31/2014 GNI 2,518.27 REF SC CH JUL DIVISION SERVICE 2015/02/080491 08/31/2014 GNI 496.98 REF SC CH AUG DIVISION SERVICE 2015/03/090560 09/30/2014 GNI 3,018.53 REF SC CH SEP DIVISION SERVICE 2015/04/100579 10/31/2014 GNI 313.11 REF SC CH OCT DIVISION SERVICE 2015/05/110538 11/30/2014 GNI 646.60 REF SC CH NOV DIVISION SERVICE 2015/06/120534 12/31/2014 GNI 1,446.40 REF SC CH DEC DIVISION SERVICE 2015/07/010535 01/31/2015 GNI 7,162.35 REF SC CH JAN DIVISION SERVICE 449055 Permitting Fees 850110 Airport Operations Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 38 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 500.00 .0% YOTTY'S INC ORIGINAL APPROP TRANFRS/ ADJSTMTS REVISED BUDGET JOURNAL DETAIL 2015 1 TO AVAILABLE YTD ACTUAL ENCUMBRANCES BUDGET 2015 8 PCT USED 76850110 449055 Permitting Fees -73.54 100.0°%* AERO RENTAL 65 Equipment 0 65 440.00 .00 -375.00 676.9°%* 2015/03/090072 Fly Iowa 09/02/2014 API 175.00 Fly Iowa VND 010262 IN 23754 IOWA WORKFORCE DEVEL Permit Fee 124844 2015/06/120403 12/16/2014 API 65.00 VND 010243 IN 198602487-2015 CHUCK MCDONALD IOWA DEPART OF NATUR Annual Underground 130738 2015/07/010379 01/26/2015 API 200.00 VND 010262 IN 140828 IOWA WORKFORCE DEVEL Annual Boiler Insp 132747 449060 Dues & Memberships 850110 Airport Operations 76850110 449060 Dues & Memberships 1,200 0 1,200 1,185.00 .00 15.00 98.8°%* 2015/04/100564 10/21/2014 API 260.00 VND 010232 IN 65824 IOWA CITY CORALVILLE P -Card invoice for 2015/06/120403 12/16/2014 API 275.00 VND 012853 IN 672754 AMERICAN ASSOCIATION Annual Dues 130680 2015/07/010379 01/26/2015 API 150.00 VND 010256 IN IPAA 2015 Dues IOWA PUBLIC AIRPORTS Annual Dues 132746 2015/07/010379 01/26/2015 API 500.00 VND 011424 IN IAPG 2015 Dues IOWA AVIATION PROMOT Annual Dues 2015 132737 449120 Equipment Rental 850110 Airport Operations 76850110 449120 Equipment Rental 2015/01/070215 07/08/2014 API 2015/01/070549 07/18/2014 GNI 76850110 449120 651 Equipment Renta 2015/01/070092 07/03/2014 API 2015/01/070178 07/08/2014 API 2015/01/070215 07/08/2014 API 2015/01/070215 07/08/2014 API 2015/01/070548 07/11/2014 GNI 2015/01/070549 07/18/2014 GNI 2015/01/070549 07/18/2014 GNI 2015/01/070549 07/18/2014 GNI 2015/05/110075 11/03/2014 API 500 0 150.00 VND 011020 IN 131508G -150.00 REF NS 0 0 1,211.20 VND 010019 IN 82867 75.00 VND 013231 IN 165509 1,190.00 VND 010062 IN 30801 800.00 VND 011020 IN 131508G -1,211.20 REF NS -75.00 REF NS -1,190.00 REF NS -800.00 REF NS 73.54 VND 013472 IN F1yIowa2 500 .00 .00 500.00 .0% YOTTY'S INC Fly Iowa & Air Rac 120715 071814 0 73.54 .00 -73.54 100.0°%* AERO RENTAL Fly Iowa Equipment 120236 HAWKEYE WASTE SYSTEM Fly Iowa dumpster 120496 BLUE MOON SATELLITES Fly Iowa - Portabl 120438 YOTTY'S INC Fly Iowa & Air Rac 120715 071114 071814 071814 071814 CHUCK MCDONALD F1yIowa Reimbursem 128865 Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 39 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 449360 Interest Expense 850110 Airport Operations 76850110 449360 Interest Expense 2015/01/070496 07/31/2014 GEN 2015/01/070496 07/31/2014 GEN 2015/02/080497 08/31/2014 GEN 2015/02/080497 08/31/2014 GEN 2015/03/090563 09/30/2014 GEN 2015/03/090563 09/30/2014 GEN 2015/04/100574 10/31/2014 GEN 2015/04/100574 10/31/2014 GEN 2015/05/110482 11/30/2014 GEN 2015/05/110482 11/30/2014 GEN 2015/06/120542 12/31/2014 GEN 2015/06/120542 12/31/2014 GEN 2015/07/010416 01/31/2015 GEN 2015/07/010416 01/31/2015 GEN 452010 Office Supplies 850110 Airport Operations 76850110 452010 Office Suoolies 2015/01/070504 07/22/2014 GNI 2015/01/070541 07/22/2014 GNI 2015/02/080055 08/31/2014 API 2015/02/080207 08/31/2014 GRV 2015/04/100564 10/21/2014 API 454020 Subscriptions 850110 Airport Operations ORIGINAL TRANFRS/ APPROP ADJSTMTS 32,572 1,100.11 REF REJE#4 1,106.11 REF REJE#4 1,100.14 REF REJE#4 1,106.12 REF REJE#4 1,100.14 REF REJE#4 1,106.12 REF REJE#4 1,100.14 REF REJE#4 1,106.12 REF REJE#4 1,100.14 REF REJE#4 1,106.12 REF REJE#4 1,100.14 REF REJE#4 1,106.12 REF REJE#4 1,100.14 REF REJE#4 1,106.12 REF REJE#4 0 32,572 15,443.78 .00 317 0 171.36 REF SS -171.36 REF NS 171.36 VND 090215 IN 52180 -171.36 REF SS 24.99 VND 090002 IN 65889 Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int 17.128.22 47.4% 317 24.99 .00 291.64 7.9% July Pcard 6.30.14PCard OFFICEMAX CT*IN#1142 P -Card invoice for Period Correction July Pcard STAPLES 001062 P -Card invoice for JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 0 32,572 15,443.78 .00 317 0 171.36 REF SS -171.36 REF NS 171.36 VND 090215 IN 52180 -171.36 REF SS 24.99 VND 090002 IN 65889 Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int Corp Hangar Loan Int UI Hangar Loan Int 17.128.22 47.4% 317 24.99 .00 291.64 7.9% July Pcard 6.30.14PCard OFFICEMAX CT*IN#1142 P -Card invoice for Period Correction July Pcard STAPLES 001062 P -Card invoice for Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT FOR 2015 08 ORIGINAL TRANFRS/ APPROP ADJSTMTS REVISED BUDGET YTD IP JOURNAL DETAIL 2015 1 TO AVAILABLE ACTUAL ENCUMBRANCES BUDGET 40 glytdbud 2015 8 PCT USED 76850110 454020 Subscriptions 125 0 125 .00 .00 124.80 .0°% 455120 Misc Computer Hardware 850110 Airport Operations 76850110 455120 Misc Computer Hard 0 0 0 192.82 .00 -192.82 100.0°%* 2015/06/120337 12/16/2014 API 192.82 VND 011721 IN IN -000223627 SOUTHERN COMPUTER WA AIRPORT/MTHARP - H 130802 461040 Other Agriculture Chemicals 850110 Airport Operations 76850110 461040 Other Agriculture 122 0 122 154.05 .00 -32.12 126.3°%* 2015/01/070116 07/01/2014 API 78.42 VND 010856 IN IVI-14-001903 JET AIR INC IOW Maintenance Suppli 120298 2015/01/070116 07/01/2014 API 54.99 VND 010856 IN IVI-14-001483 JET AIR INC IOW JUNE MAINTENANCE R 120298 2015/01/070548 07/11/2014 GNI -78.42 REF NS 071114 2015/01/070548 07/11/2014 GNI -54.99 REF NS 071114 2015/03/090284 09/10/2014 API 74.54 VND 010856 IN IVI-14-002683 JET AIR INC IOW Maintenance Suppli 125129 2015/06/120234 12/03/2014 API 79.51 VND 010856 IN IVI-14-003637 JET AIR INC IOW July Maintenance R 130540 466040 Plumbing Supplies 850110 Airport Operations 76850110 466040 Plumbing Supplies 50 0 50 .00 .00 50.00 .0°% Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 41 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 466050 Electrical Supplies 850110 Airport Operations 76850110 466050 Electrical Supplie 2015/03/090284 09/10/2014 API 466070 Other Maintenance Supplies 850110 Airport Operations 76850110 466070 Other Maintenance 2015/01/070116 07/01/2014 API 2015/01/070504 07/22/2014 GNI 2015/01/070504 07/22/2014 GNI 2015/01/070541 07/22/2014 GNI 2015/01/070548 07/11/2014 GNI 2015/02/080055 08/31/2014 API 2015/02/080055 08/31/2014 API 2015/02/080207 08/31/2014 GRV 2015/02/080207 08/31/2014 GRV 2015/02/080494 08/21/2014 API 2015/02/080494 08/21/2014 API 2015/03/090284 09/10/2014 API 2015/05/110507 11/21/2014 API 2015/06/120170 12/03/2014 API 2015/06/120170 12/03/2014 API 2015/06/120234 12/03/2014 API 2015/08/020139 02/05/2015 API 467020 Equipment R&M Supplies 850110 Airport Operations 76850110 467020 Equipment R&M Supp ORIGINAL TRANFRS/ APPROP ADJSTMTS 967 0 967 11.00 .00 955.76 1.1% 11.00 VND 010856 IN IVI-14-002683 JET AIR INC IOW Maintenance Suppli 125129 563 0 563 21.78 VND 010856 IN IVI-14-001483 8.75 REF SS 19.97 REF SS -28.72 REF NS -21.78 REF NS 8.75 VND 010313 IN 52075 19.97 VND 010313 IN 52075 -8.75 REF SS -19.97 REF SS 7.18 VND 090566 IN 58100 32.76 VND 090566 IN 58100 192.90 VND 010856 IN IVI-14-002683 158.18 VND 010477 IN 69755 13.88 VND 010856 IN IVI-14-003709 -3.70 VND 010856 IN IVI-14-003709 14.02 VND 010856 IN IVI-14-003637 95.38 VND 010856 IN IVI-15-000353 510.60 .00 52.50 90.7°°%* JET AIR INC IOW JUNE MAINTENANCE R 120298 July Pcard July Pcard 6.30.14PCard 071114 MENARDS P -Card invoice for MENARDS P -Card invoice for Period Correction July Pcard Period Correction July Pcard STANLEY SECURITY P -Card invoice for STANLEY SECURITY P -Card invoice for JET AIR INC IOW Maintenance Suppli 125129 UTILITY EQUIPMENT CO P -Card invoice for JET AIR INC IOW Maintenance Reimbu 130295 JET AIR INC IOW Maintenance Reimbu 130295 JET AIR INC IOW July Maintenance R 130540 JET AIR INC IOW Maintenance Reimbu 133225 100 0 100 1.037.46 .00 -937.46 1037.5%* JOURNAL DETAIL 2015 1 TO 2015 8 REVISED AVAILABLE PCT BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 967 0 967 11.00 .00 955.76 1.1% 11.00 VND 010856 IN IVI-14-002683 JET AIR INC IOW Maintenance Suppli 125129 563 0 563 21.78 VND 010856 IN IVI-14-001483 8.75 REF SS 19.97 REF SS -28.72 REF NS -21.78 REF NS 8.75 VND 010313 IN 52075 19.97 VND 010313 IN 52075 -8.75 REF SS -19.97 REF SS 7.18 VND 090566 IN 58100 32.76 VND 090566 IN 58100 192.90 VND 010856 IN IVI-14-002683 158.18 VND 010477 IN 69755 13.88 VND 010856 IN IVI-14-003709 -3.70 VND 010856 IN IVI-14-003709 14.02 VND 010856 IN IVI-14-003637 95.38 VND 010856 IN IVI-15-000353 510.60 .00 52.50 90.7°°%* JET AIR INC IOW JUNE MAINTENANCE R 120298 July Pcard July Pcard 6.30.14PCard 071114 MENARDS P -Card invoice for MENARDS P -Card invoice for Period Correction July Pcard Period Correction July Pcard STANLEY SECURITY P -Card invoice for STANLEY SECURITY P -Card invoice for JET AIR INC IOW Maintenance Suppli 125129 UTILITY EQUIPMENT CO P -Card invoice for JET AIR INC IOW Maintenance Reimbu 130295 JET AIR INC IOW Maintenance Reimbu 130295 JET AIR INC IOW July Maintenance R 130540 JET AIR INC IOW Maintenance Reimbu 133225 100 0 100 1.037.46 .00 -937.46 1037.5%* Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 OF IOWA CITY INC IOW 42 mtharp (CITY YEAR-TO-DATE BUDGET REPORT IP glytdbud FOR 2015 08 120591 JOURNAL DETAIL 2015 1 TO 2015 8 071114 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 2015/01/070116 07/01/2014 API 2015/01/070178 07/08/2014 API 2015/01/070548 07/11/2014 GNI 2015/01/070549 07/18/2014 GNI 2015/06/120170 12/03/2014 API 2015/06/120170 12/03/2014 API 2015/07/010379 01/26/2015 API 467160 Other Vehicle R&M Supplies 850110 Airport Operations 76850110 467160 Other Vehicle R&M 2015/01/070116 07/01/2014 API 2015/01/070548 07/11/2014 GNI 2015/05/110243 11/06/2014 API 468030 Asphalt 850110 Airport Operations 76850110 468030 Asphalt 468050 Sand 850110 Airport Operations 76850110 468050 Sand 35.63 VND 010856 IN IVI-14-001903 85.50 VND 010384 IN 121613 -35.63 REF NS -85.50 REF NS 413.59 VND 010856 IN IVI-14-003904 45.06 VND 010856 IN IVI-14-003709 578.81 VND 010856 IN ivi-14-004207 0 0 0 20.12 VND 010856 IN IVI-14-001903 -20.12 REF NS 33.01 VND 010856 IN IVI-14-003544 JET AIR INC IOW Maintenance Suppli 120298 PYRAMID SERVICES INC Belt for ZTR Mower 120591 071114 071814 JET AIR INC IOW Maintenance Reimbu 130295 JET AIR INC IOW Maintenance Reimbu 130295 JET AIR INC IOW Maintenance Reimbu 132750 33.01 JET AIR INC IOW 071114 JET AIR INC IOW 50 0 50 .00 50 0 50 NN .00 -33.01 100.0°%* Maintenance Suppli 120298 Maintenance Reimbu 129380 00 50.00 .0°% 00 50.00 .0°% Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 43 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 469040 Traffic Cntrl Imprvmt Supplies 850110 Airport Operations JOURNAL DETAIL 2015 1 TO 2015 8 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 469040 Traffic Cntrl Impr 500 0 500 115.67 .00 384.33 23.1°% 2015/01/070116 07/01/2014 API 33.66 VND 010856 IN IVI-14-001903 JET AIR INC IOW Maintenance Suppli 120298 2015/01/070548 07/11/2014 GNI -33.66 REF NS 071114 2015/05/110243 11/06/2014 API 76.72 VND 010856 IN IVI-14-003544 JET AIR INC IOW Maintenance Reimbu 129380 2015/06/120170 12/03/2014 API 28.48 VND 010856 IN IVI-14-003709 JET AIR INC IOW Maintenance Reimbu 130295 2015/06/120234 12/03/2014 API 10.47 VND 010856 IN IVI-14-003637 JET AIR INC IOW July Maintenance R 130540 469190 Minor Equipment 850110 Airport Operations 76850110 469190 Minor Equipment 2015/01/070116 07/01/2014 API 2015/01/070548 07/11/2014 GNI 469200 Tools 850110 Airport Operations 76850110 469200 Tools 2015/06/120170 12/03/2014 API 469260 Fire Ext & Refills 850110 Airport Operations 500 0 500 84.79 VND 010856 IN IVI-14-001483 -84.79 REF NS 500 0 500 7.94 VND 010856 IN IVI-14-003709 .00 .00 500.00 .0°% JET AIR INC IOW JUNE MAINTENANCE R 120298 071114 7.94 .00 492.06 1.6% JET AIR INC IOW Maintenance Reimbu 130295 Airport Commission Agenda & Info Packet nn PP}inn na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 44 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 76850110 469260 Fire Ext & Refills 2015/05/110075 11/03/2014 API 469320 Miscellaneous Supplies 850110 Airport Operations 76850110 469320 651 Miscellaneous S 2015/06/120170 12/03/2014 API 473010 Contracted Improvements 850110 Airport Operations 76850110 473010 Contracted Improve 490190 Interfund Loan 850110 Airport Operations 76850110 490190 Interfund Loan 2015/01/070496 07/31/2014 GEN 2015/01/070496 07/31/2014 GEN 2015/02/080497 08/31/2014 GEN 2015/02/080497 08/31/2014 GEN 2015/03/090563 09/30/2014 GEN 2015/03/090563 09/30/2014 GEN 2015/04/100574 10/31/2014 GEN 2015/04/100574 10/31/2014 GEN 2015/04/100603 10/31/2014 GEN 2015/05/110482 11/30/2014 GEN 2015/05/110482 11/30/2014 GEN ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 750 0 750 313.35 VND 010191 IN 57148 0 0 0 405.47 VND 010856 IN IVI-14-003710 JOURNAL DETAIL 2015 1 TO 2015 8 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 313.35 .00 436.65 41.8°% HAWKEYE FIRE AND SAF Annual Extinguishe 128910 405.47 .00 -405.47 100.0°%* JET AIR INC IOW Final Fly -Iowa sup 130295 40,000 0 40,000 .00 .00 40,000.00 .0°% 32,126 1,899.89 REF REJE#4 1,285.43 REF REJE#4 1,899.86 REF REJE#4 1,285.40 REF REJE#4 1,899.86 REF REJE#4 1,285.40 REF REJE#4 1,899.86 REF REJE#4 1,285.40 REF REJE#4 149,725.10 REF SS 1,899.86 REF REJE#4 1,285.40 REF REJE#4 0 32,126 172,021.98 .00 -139,895.53 535.5°%* Corp Hangar Loan Prn UI Hangar Loan Princ Corp Hangar Loan Prn UI Hangar Loan Princ Corp Hangar Loan Prn UI Hangar Loan Princ Corp Hangar Loan Prn UI Hangar Loan Princ Sale of Commerce Park Lots Corp Hangar Loan Prn UI Hangar Loan Princ Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 45 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 08 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET JOURNAL DETAIL 2015 1 TO 2015 8 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 490190 Interfund Loan 2015/06/120542 12/31/2014 GEN 1,899.86 REF REJE#4 Corp Hangar Loan Prn 2015/06/120542 12/31/2014 GEN 1,285.40 REF REJE#4 UI Hangar Loan Princ 2015/07/010416 01/31/2015 GEN 1,899.86 REF REJE#4 Corp Hangar Loan Prn 2015/07/010416 01/31/2015 GEN 1,285.40 REF REJE#4 UI Hangar Loan Princ TOTAL Airport Operations 0 0 0 -69,159.69 .00 69,159.78 TOTAL REVENUES -390,506 0 -390,506 -447,811.34 .00 57,305.70 TOTAL EXPENSES 390,506 0 390,506 378,651.65 .00 11,854.08 GRAND TOTAL 0 0 0 -69,159.69 .00 69,159.78 ** END OF REPORT - Generated by Michael Tharp ** °s °s Airport Commission Agenda & Info Packet nn PPfin� na}P 9-19-9n15 02/13/2015 11:47 (CITY OF IOWA CITY IP 46 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud Field # Total Page Break Sequence 1 9 Y N Sequence 2 11 N N Sequence 3 6 N N Sequence 4 0 N N Report title: YEAR-TO-DATE BUDGET REPORT Includes accounts exceeding 0% of budget. Print totals only: N Print Full or Short description: F Print full GL account: N Format type: 1 Double space: N Suppress zero bal accts: Y Include requisition amount: N Print Revenues -Version headings: N Print revenue as credit: Y Print revenue budgets as zero: N Include Fund Balance: N Print journal detail: Y From Yr/Per: 2015/ 1 To Yr/Per: 2015/ 8 Include budget entries: N Incl encumb/liq entries: N Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Multiyear view: F Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Org 76850110 Object Project Rollup code Account type Account status REPORT OPTIONS Year/Period: 2015/ 8 Print MTD Version: N Roll projects to object: N Carry forward code: 1