The URL can be used to link to this page

Home My WebLink About07-16-2009 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JULY 16, 2009 - 6:OOP.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: June 18, 2009; July 10, 2009 3. Public Discussion - Items not on the agenda 4. Items for Discussion/Action: a. Aviation Commerce Park b. FAA/IDOT Projects - AECOM —David Hughes i. Runway 7/25 & 12/30 ii. 2008 Pavement Rehab (North Taxilanes) 1. Consider a resolution accepting work for 2008 Pavement Rehabilitation iii. Obstruction Mitigation iv. Building H — University of Iowa Hangar Expansion c. Airport "Operations": Strategic Plan -Implementation; Budget; Management d. 2009-2010 T-Hangar Contracts and Fees e. Jet Air/ Iowa Flight Training i. Whirlybird Helicopters f. FBO Staff Report g. Subcommittees' Reports h. Commission Members' Reports i. Staff Report 5. Set next regular meeting for August 20, 2009 at 6:00 p.m. 6. Adjourn MINUTES DRAFT Iowa City Airport Commission June 18, 2009 Iowa City Airport Terminal — 6:00 PM Members Present: Greg Farris, Howard Horan, Janelle Rettig, John Staley Members Absent: Minnetta Gardinier Staff Present: Sue Dulek, Michael Tharp Others Present: Jay Honeck, John Yeomans, Peggy Slaughter, Randy Miller, David Hughes, Joe Merschman, Turk Regennitter, Reyna Wilkens, Tim Busch, Clint Simplot, Phillip Woolford RECOMMENDATIONS TO COUNCIL: The Commission recommends that Council accept the purchase offer on Lot 1 of Aviation Commerce Park. DETERMINE QUORUM: Chairperson Rettig called the meeting to order at 6:00 P.M. APPROVAL OF MINUTES FROM THE MAY 21, 2009 MEETING: Rettig asked if anyone had any changes to the May 21 minutes. Staley moved to approve the minutes of the May 21, 2009 meeting as submitted; seconded by Farris. Carried 4-0. PUBLIC DISCUSSION: Honeck stated that the Powder Puff Air Race is underway, which is where Gardinier is. ITEMS FOR DISCUSSION/ACTION: a. Aviation Commerce Park / U of I Aircare Facility - (Staley recused himself due to conflict of interest.) Peggy Slaughter addressed the Commission, stating that they now have a full -price offer. She noted that timing issues are the only concern at this point. Dulek noted that the public hearing on this has been set for the Council's June 30 meeting. Tharp recommended that someone be at this meeting and let the Council know that this is a highly supported project as it is aviation related. Slaughter asked that they let her know which meeting, the work session or the formal, they will be discussing this issue with the Council as the University would like to have their representative there, as well. Iowa City Airport Commission June 18, 2009 Page 2 of 5 i. Consider a Motion Recommending Sale of Lot #1 - Horan moved to recommend that the City Council accept the full -price purchase offer on Lot 91; seconded by Farris. Carried 3-0 (Staley recused himself due to a conflict of interest) b. Farmer's National / Merschman Seeds - i. Public Hearing - Rettig opened the public hearing. Joe Merschman spoke to the Commission, stating that he has the lease and is ready to sign it with Turk Regennitter, if the Commission approves it. He added that there is one correction to be made, and he addressed this briefly. Rettig asked for some clarification on the various parts of the lease, and Merschman explained the gate agreement portion. Tharp noted that it was all wrapped into one agreement. A brief discussion ensued on the gate locks and who all has keys for these locks. It was noted that Merschman has done a good job taking care of the weeds and brush around the area. Rettig then closed the public hearing. ii. Consider Resolution #A09-16 Approving Amendment to Lease and Gate Agreements - Staley moved to consider the resolution; seconded by Farris. Carried 4-0. iii. Consider a Motion Approving Regennitter Farms sublease to Merschman's Seeds - Farris moved to approve the Regennitter Fames sublease to Merschman's Seeds; seconded by Horan. Carried 4-0. c. Consider a motion to adjourn to executive session to discuss strategy with counsel in matters that are presently in litigation or where litigation is imminent or where its disclosure would be likely to prejudice or, disadvantage the position of the governmental body in that litigation. Farris moved to adjourn to executive session, seconded by Staley. Carried 4-0. d. FAAADOT Projects —AECOM —David Hughes addressed the Commission, and apologized for missing last month's meeting. He had been hospitalized and was unable to travel at the time. i. Runways 7/25 & 12/30 - Hughes stated that they have worked out final quantities with Metro, and have the final change order approved by the FAA on this project. Hughes then spoke about the economic stimulus funding and what has come through so far. This money will be for the southern portion of 12-30, and the contractor has started on this phase. Hughes then introduced Clint Simplot, one of the contractors on the runway project, who spoke briefly on the project and timeframes. Hughes noted that they need to be careful of timing as they don't want to run out of construction time before the winter season. The discussion continued, with Hughes noting that calls will be made to the State on Monday to Iowa City Airport Commission June 18, 2009 Page 3 of 5 see about the funding timehrames. Members discussed what they may need to do if they are unable to obtain funding for this year's construction season. 1. Consider a Resolution Accepting Work on Runway 7-25 Reconstruction (Phase 1) - Farris moved to consider Resolution #A09-17 accepting work on Runway 7-25 reconstruction (Phase 1); seconded by Staley. Carried 4- 0. ii. 2008 Pavement Rehab (North Taxilanes) — Hughes stated that they have started on the punch list for this and should finish up in the next few weeks, weather permitting. iii. Obstruction Mitigation — Hughes and Tharp both stated that they have not seen anything from Mediacom on this. iv. Building H — University of Iowa Hangar Expansion — Tharp noted that things are stalled somewhat and there is nothing new to report on this. e. Airport "Operations;" Strategic Plan -Implementation; Budget; Management — Rettig asked for clarification on a few budget items, and Tharp responded He then spoke about the memo that everyone has with this month's packet. He noted that the City Council is asking all departments to make reductions, and he and Rettig met recently to discuss ways to do this. Tharp further explained that beginning in FYI I and beyond, the Airport will be capped at $100,000 from the City. This led to a discussion about what the Airport has requested the past few years - $112,000 - and what this may mean in the future. Horan added that he stated earlier this week, regarding the sale of land versus leasing, that he would like to lease Airport land in order to "remove it from political sensitivity." He noted that the answer he received was that $100,000 would "not be politically sensitive." The discussion continued, with Members discussing the operating subsidy of the Airport. Tharp noted that they have bought new reflectors for the taxiways. i. Consider a Resolution Authorizing Chair to Sign Project Change Orders - The members discussed whether 5% is sufficient or whether it should be 10%. Staley moved to consider Resolution #A09-18 authorizing Chair to sign project change orders as indicated at 5%; seconded by Farris. Carried 4-0. f. Jet Air / Iowa Flight Training - Phillip Woolford spoke to the Commission regarding the need to better emphasize their flight training. They have been experimenting recently with Tim Busch doing their flight training, and so far it is working out well. He stated that they would like to have their FBO lease amended to allow subcontracting of flight training with Iowa Flight Training. Horan then asked Busch to speak briefly about this type of service. Busch gave the Members some history on how flight training has been changing in the industry. Rettig asked for some clarification on the agreement to Iowa City Airport Commission June 18, 2009 Page 4 of 5 subcontract. Members agreed that they are okay with this arrangement. Farris moved to authorize the Chair to enter into agreements to amend the FBO agreement to sublease space and to subcontract flight training to Iowa Flight Training and to enter into a business agreement with Iowa Flight Training; seconded by Staley. Carried 4-0. g. FBO Staff Report - Woolford addressed the Members regarding the new reflectors that Tharp mentioned earlier. He added that they are starting to see a slow increase in corporate business. Jet Air's charter business is still down, however. Woolford then spoke to the upcoming runway project, stating that he would rather see it done completely this year and not make it a two-year project. He added that it really needs to get done as the runway is getting pretty bad in spots. Woolford also addressed the Commission, stating that they had an open house a couple of weekends ago, and that this was quite a successful event. He added that during the runway closure they will be taking things up to the Cedar Rapids Airport. Rettig noted that the Airport now has a web page, a Facebook account, and a Twitter account, and she suggested Jet Air check these out. h. Subcommittees' Reports —None. i. Commission Members' Reports — Horan noted that he and Tharp attended the Economic Development Committee meeting earlier in the week, and that they did get some good ideas. It was suggested that the Airport look into federal funding for the Willow Creek mitigation project. Horan added that he would like to come up with some preliminary planning on the south airfield area and that he will share this with the Commission once he has worked up some ideas. Farris noted that there have been more pictures submitted for the newsletter. Rettig noted that she was in Alaska recently, and that many of their residents have pilot licenses. She noted the neighborhoods with planes parked behind the houses. j. Staff Report— Tharp reminded Members about the June 29, 6:30 P.M., City Council meeting to discuss the Airfield study. Rettig asked if they could add the discussion about Lot #1 at the same meeting. Dulek will look into this for the Commission. SET NEXT REGULAR MEETING: Staley noted that he may not be able to make the next meeting; he will let Tharp know. Thursday, July 16, 2009 at 6:00 P.M. ADJOURN: The meeting adjourned at 8:24 P.M. 11 Iowa City Airport Commission June 18, 2009 Page 5 of 5 Airport Commission ATTENDANCE RECORD YEAR 2009 (Meeting Dates NAME TERM EXP. 1/8 215 2/12 3/12 4/1, 1 4114 4116 516 5121 6118 Greg Farris 3/1/13 X X X X X X X X X X Minnetta Gardinier 3/l/15 — — — X X X X O/E O/E O/E Howard Horan 3/l/14 X X X X O/E O/E X X X X Janelle Rettig 3/1/12 X O/E X X X X X X X X John Staley 3/l/10 X O/E X X O/E O/E X X X X KEY: X = Present O = Absent O/E = Absent/Excused NM = No meeting — = Not a Member Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246319-350-5045 RESOLUTION NO. RESOLUTION ACCEPTING THE WORK FOR THE REHABILITATION OF THE 2008 PAVEMENT REHABILITATION (NORTH TAXILANES) WHEREAS, the Commission's consultant for the 2008 Pavement Rehabilitation (North Taxilanes, AECOM., has recommended that the work on the installation of concrete floors by Vieth Construction Company be accepted; and WHEREAS, the final contract price is $, which includes the original contract amount of $ from the original contract and $from change order # is the approved amount. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION THAT: Said improvements are hereby accepted by the Iowa City Airport Commission. Passed and approved this day of CHAIRPERSON ATTEST: SECRETARY It was moved by adopted, and upon roll call there were: Ayes and seconded by Nays Approved by City Attorney's Office Absent Farris Gardiner Horan Rettig Staley 2009. the Resolution be MINUTES Iowa City Airport Commission July 10, 2009 Iowa City Airport Terminal — 8:00 AM Drain Members Present: Greg Farris, Howard Horan, John Staley, Janelle Rettig, Minnetta Gardiner Others Present: Klay Johnson, Patrick Sheridan, Jim McCarragher Staff Present: Sue Dulek Others Present: None RECOMMENDATIONS TO COUNCIL: None DETERMINE QUORUM: The meeting was called to order at 8:06 A.M. ITEMS FOR DISCUSSION/ACTION: 1. Runway 7/25 & 12-30 a Discussion — Members discussed revising the construction plan as presented by the contractor. Tharp mentioned that the changes to the construction schedule would call for the runway intersection work to be moved forward and be completed between August 3-31". Tharp noted that this would have an impact on SERTOMA and introduced Jim McCarragher, who has served as the organizer of the event since Tharp had been here. Members discussed the effects of changing the schedule. Gardiner stated that she felt the Airport Commission had made some promises regarding protecting certain dates within the construction season. Rettig stated that it had always been the intention of the Commission to have the intersection work be one of the first phases done on the project, but they way the fimding was distributed from FAA, that it had changed those phases. Members discussed the impact of the closure on SERTOMA. McCarragher noted that some of the advertising had already been in place and noted that if they changed the fly -in component then SERTOMA would need to go back and redo some of that advertising. Tharp noted that with the runways closed it would prevent fixed wing traffic from coming in, but helicopters, like the Uofl Aircare helicopter would still be able to come in. Members discussed other features which might be used to replace some of the fixed wing traffic like hot air balloons or parachute jumpers. Iowa City Airport Commission July 10, 2009 Page 2 of 3 b. Consider a resolution amending Reconstruction Runway 7-25 (Phase 2) and Reconstruction Runway 12-30 reconstruction project contracts. Staley moved the resolution, seconded by Farris. Motion passed 5-0 2. Building H Expansion — Change Order - Tharp discussed with members the status of the project, stating last time they met Tharp was in the process of received the revised plans and the cost estimates from the engineer and contractor. Tharp noted that the change orders would increase the project cost by $80,000 and that he felt the engineering firm should be responsible for these charges. Members asked Tharp about the agreement with the University of Iowa, and Tharp responded. Members asked Tharp if he had received permission from the University to go above the previously agreed project cap, Tharp responded that he hadn't received permission, but was still discussing the matter with University. Rettig stated that she felt the Commission shouldn't put themselves on the hook for these costs without some other method of recouping them being in place. Members discussed different options regarding constructing the office portion and directed Tharp to gather more information. Members deferred the change orders for consideration at the July 16 meeting. ADJOURN: Farris moved to adjourn, Gardiner seconded. Motion carried 5-0. The meeting adjourned at 9:00 A.M. CHAIRPERSON FlY.N11-91 Iowa City Airport Commission. July 10, 2009 Page 3 of 3 Airport Commission ATTENDANCE RECORD YEAR 2009 (Meeting Dates) NAME TERM EXP. 1/8 2/5 2/12 3/12 4/2 4/14 4/16 516 5/21 6/18 Greg Farris 3/1/13 X X X X X X X X X X Minnetta Gardinier 3/1/15 — — — X X X X O/E O/E O/E Howard Horan 3/1/14 X X X X O/E O/E X X X X Janelle Rettig 3/1/12 X O/E X X X X X X X X John Staley 3/1/10 X O/E X X O/E O/E X X X X NAME TERM EXP. 1/8 2/5 2/12 3/12 4/2 4/14 4/16 5/6 5121 6/18 KEY: X = Present O = Absent O/E = Absent/Excused NM = No meeting — = Not a Member Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION RESOLUTION ACCEPTING THE WORK FOR THE REHABILITATION OF THE 2008 PAVEMENT REHABILITATION (NORTH TAXILANES) WHEREAS, the Commission's consultant for the 2008 Pavement Rehabilitation (North Taxilanes, AECOM., has recommended that the work on the installation of concrete floors by Vieth Construction Company be accepted; and WHEREAS, the final contract price is $, which includes the original contract amount of $ from the original contract and $from change order # is the approved amount. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION THAT: Said improvements are hereby accepted by the Iowa City Airport Commission. Passed and approved this CHAIRPERSON ATTEST: SECRETARY It was moved by adopted, and upon roll call there were: Ayes day of and seconded by Nays Approved by City Attorneys Office Absent Farris Gardiner Horan Rettig Staley 2009. the Resolution be ' r- CITY OF I O WA CITY -^� MEMORANDUM Date: July 13, 2009 To: Airport Commission From: Operations Specialist Re: 2009-2010 T-hangar Contracts and Rates The current lease agreements expire at the end of September 2009. In order to facilitate transitions to new leases the Airport Commission needs to approve the next lease template. This template will govern leases between Oct 1, 2009 and Sept 30, 2010. As part of the discussions rental rates for the hangars are also incorporated into the approval process. In anticipation of the discussions, I have researched area rates regarding hangars and along with the current economic climate and conditions have come to the following judgments: — Area Hangar Rates have not increased recently (over the past 12 months) — The Consumer Price Index (Inflation rate) for the period of 2008-2009 has fallen 0.67% — Iowa City T-Hangar Rates are either competitive or slightly higher than average depending on facility comparison. It is the recommendation of the staff that the T-Hangar rates for the 2009-2010 lease period should remain the same. Inflation Calculator: Bureau of Labor Statistics rage i of i U.S. Bureau of Labor Statistics Databases, Tables & Calculators by Subject CPI Inflation Calculator Inflation Calculator in 2008 has the same buying power as 599.33 in 2009 Calculate About this calculator About the CPI Inflation Calculator The CPI inflation calculator uses the average Consumer Price Index for a given calendar year. This data represents changes in prices of all goods and services purchased for consumption by urban households. This index value has been calculated every year since 1913. For the current year, the latest monthly index value is used. U.S. Bureau of Labor Statistics 2 Massachusetts Avenue, NE Washington, DC 202124=1 www,bls.gov 1 Telephone: (202) 691-5200 1 Do you have a Data question? http://data.bls.gov/cgi-bin/print.pi/data/mflation_calculator.htm 7n/2009 Historical Hangar Rates 2004/05 2005I06 2006I07 2007I08 2008/09 2009/1C Building A #1-10 $ 121.00 $ 121.00 $ 121.00 $ 137.00 $ 141.00 $ 141.00 Building B #11-20 $ 132.00 $ 132.00 $ 132.00 $ 144.00 $ 148.00 $ 148.00 Building #21-22 $ 132.00 $ 132.00 $ 132.00 $ 144.00 $ 148.00 $ 148.00 Building 1 #36-44 $ 143.00 $ 153.00 $ 153.00 $ 163.00 $ 168.00 $ 168.00 #45 $ 176.00 $ 186.00 $ 186.00 $ 198.00 $ 204.00 $ 204.00 Building J #46, 55 $ 176.00 $ 186.00 $ 186.00 $ 198.00 $ 204.00 $ 204.00 #47-54 $ 143.00 $ 153.00 $ 153.00 $ 163.00 $ 168.00 $ 168.00 Building K #56 $ 275.00 $ 285.00 $ 285.00 $ 304.00 $ 313.00 $ 313.00 #57,58 $ 170.50 $ 180.50 $ 180.50 $ 192.00 $ 198.00 $ 198.00 #59,60,62,63 $ 148.50 $ 158.50 $ 158.50 $ 169.00 $ 174.00 $ 174.00 #61 $ 198.00 $ 208.00 $ 208.00 $ 222.00 $ 229.00 $ 229.00 #64 $ 165.00 $ 175.00 $ 175.00 $ 186.00 $ 192.00 $ 192.00 $10 increase to Inflationary Recommendations south T's No Change Adjustment from Inflationary Adj No Change B and C were Actions as recommended as recommended adjusted down $5 as recommended Building B T-hangar $ 1,480.00 building rs y lab.oi 0 1,400.4v Building C T-hangar $ 1,480.00 Building C $ 328.72 $ 1,151.28 Building I T-hangar $ 1,716.00 Building 1 $ 2,401.88 $ (685.88) Building J T-hangar $ 1,752.00 Building J $ 572.49 $ 1,179.51 Buildinq K T-hanqar $ 1,826.00 Building K $ 2,849.66 $ (1,023.66) Annual Income $ 115,968.00 Notes Overview page has dynamic cells Depreciation Numbers from Fixed Asset file, based on Cost of Building divided by life expectancy T-HANGAR LEASE (2009-2010) Delemh 2.= Dare . i00i ) This T-HANGAR LEASE ("Lease") entered into by and between the Iowa City Airport Commission ("Commission") and ("Tenant") in Iowa City, Iowa. In consideration of the mutual covenants contained herein, and for other good and valuable consideration, the parties hereby agree as follows: Lease of the Hangar Space. The Commission hereby leases to Tenant hangar space in Hangar # (the "Hangar Space") located at the Iowa City Municipal Airport (the "Airport") and described as follows: T-hangar with a bifold door. The Hangar Space shall be used and occupied by Tenant principally for the storage or construction of the following aircraft: Aircraft Make & Model Aircraft Registration Number Aircraft Registered Owner Name Registered Owner Home and Business Telephone Numbers Email address of Tenant Tenant shall promptly notify the Commission in venting of any change in the information furnished above. Tenant may request permission to store a substitute aircraft in the Hangar Space by making a written request to the Commission. In the event Tenant is permitted to store a substitute aircraft in the Hangar Space, all provisions of this Lease applicable to the Aircraft shall also be applicable to the substitute aircraft. Tenant shall immediately notify the Commission upon sale of the aircraft listed above. Tenant shall have 90 days from sale date to replace aircraft; after which the Commission may terminate the lease. 2. Term. The term of this Lease shall commence on September 1, 2009, and shall end on the last day of the month of September, 2010. Provided Tenant is in compliance with all terms and conditions of this Lease, the Commission acknowledges that Tenant will likely be offered another one-year lease at the expiration of the term of this Lease, and Tenant acknowledges that rent will likely be increased under the subsequent one-year lease. If Tenant does not intend to execute another lease following the expiration of the term of this Lease, Tenant agrees to notify the Commission 45-days prior to the expiration of the existing term in order to facilitate the Commission in locating another tenant. In the event Tenant shall continue to occupy the Hangar Space beyond the term of this Lease without executing a Lease for another 12-month term, such holding over shall not constitute a renewal of this Lease but shall be a month -to -month tenancy only. 3. Rent For use of the Hangar Space, Tenant shall pay the Commission the amount of $ per month, payable in advance on the first day of each month. A 1.5% late fee (which is $ per day) for rent not received by the Commission will be charged after the fifteenth (15) day of each month. Deleted: 2008 Deleted: 2009 - Home Built Fee. Tenant acknowledges the following: If the Tenant uses the Hangar Space to construct an "amateur builtihome built" aircraft, Tenant shall pay a "home built fee" of $10.00 every month for electricity until the FAA issues an Airworthiness Certificate. The fee is due regardless of the number of days that the Hangar Space is used for said purpose in that particular month. Tenant shall make payment to the Commission by the last day of the succeeding calendar month. "Amateur built/home built" aircraft is defined as aircraft built by individuals and licensed by the Federal Aviation Administration (FAA) as "Experimental" (The parties acknowledge that this definition is adopted from the EAA web site wvvw.eaa.org .) 4. Security Deposit At the time of execution of this Lease, Tenant shall pay to the Commission in trust the sum of one month's rent to be held as a rental deposit. At the termination of the Lease, the Commission shall return the deposit to the Tenant less any amounts due to repair damage, conduct cleanup or owed to the Commission. If the Tenant renews the lease each year, the deposit will be held over for the next year. 5. Use of the Hangar Space. a. The Hangar Space shall be used primarily for storage or construction of the Aircraft consistent with FAR and the Minimum Standards. This provision is not to be construed as a prohibition for storage of maintenance materials, cleaning materials, tools, parts, spares, and other aircraft components. b. Tenant may park his/her car in the Hangar Space during such time that Tenant is using the Aircraft. G. No commercial activity of any kind shall be conducted by Tenant in, from or around the Hangar Spacewithout prior written approval of the Airport Commission as specified in paragraph 25. R e. Tenant shall be responsible and liable for the conduct of its employees and invitees, and of those doing business with it, in and around the Hangar Space. Tenant shall keep the Hangar Space clean and free of debris at all times. f. In utilizing the Hangar Space during the term of this Lease, Tenant shall comply with all applicable ordinances, rules, and regulations established by any federal, state or local government agency. g. Tenant shall dispose of used oil only in approved receptacles. Tenants may dispose of batteries only in approved methods (trash and dumpsters are not approved methods). h. At no time shall Tenant start or run his/her Aircraft engine(s) within the Hangar or Hangar Space. j. On the termination of this Lease, by expiration or otherwise, Tenant shall immediately surrender possession of the Hangar Space and shall remove, at its Deleted: Tenant individually may perform maintenance, including painting, on the aircraft described in Paragraph 1, as permitted by the FAA, but shall not allow any other person to do so in the Hangar Spam. Tenard shall not perform any other maintenance, indudmg painting, on any other Aircraft In the Hangar Space or anywhere on the Airport, Without prior written approval of the Airport. Tenant shall take steps to ensure that the performance of such maintenance work will not damage the Hangar Space or the Airport where the work is performed and will net emit offensive odors. I7 sole expense, the Aircraft and all other property therefrom, leaving the Hangar Space in the same condition as when received, ordinary wear and tear excepted. k. Tenant shall be liable for any and all damage to the Hangar or to the Hangar Space caused by Tenant's use, including, but not limited to, bent or broken interior walls, damage due to fuel spillage, or damage to doors due to Tenant's improper or negligent operation. SMOKEFREE AIR ACT Lease Provision Formatted: Fond: 11 K Bola. Check spelling and grammar a. Jowa Smokefree Air AcL Smoking is prohibited throughout the Iowa City Municl a Formaded: Justified, Tabs: 0.5•, Airport, including the Hangar Space Left+ 1•, Left+ 1.5, Left Formatted: Font: 11 pt, (heck \ spelling and grammar Rights and Obligations of Tenant \ Deleted: Formatted: Font: 11 pt, Qxxk a. Tenant shall have at all times the right of ingress to and egress from the Hangar ;,l spelling and grammar Space, except as provided in Paragraph 13. To ensure this right, the `' Formatted: 3usstiried, Indent Commission shall make all reasonable efforts to keepadjacent areas to the 1 Hanging: 0.33', Oudine numbered + Level: 1 + Nmloenng Style: a, It, c, Hangar Space free and dear of all hazards and obstructions, natural or ... + start at: L + Alignment: Left + manmade. Aligned at: o.se"+Tab after: 0.e3- + Indent at OMI, Tabs: O.S, Left + I', Left+ 1.5, Left b. Tenant shall be responsible to maintain the interior of the Hangar Space to include janitorial services, maintaining all interior lights, cleaning of stoppages in Formatted: Font: 11 M No undenbne, Check spelling and plumbing fixtures and drain lines, cleaning of snow within two (2) feet of the - grammar apron adjoining the Hangar Space, disposing of any debris or waste materials, lie, aned: Font, 11 M Check and maintaining any Tenant constructed structures and equipment. The spelling and grammar Commission shall be the sole judge of the due maintenance undertaken by the Deleted, Tenant, and may upon written notice, require specific maintenance work to be F, ,nay; Fo t:11 pt, Not Odd, completed. If such maintenance is not completed within a reasonable time Check sp 11 and grammar period, the Commission shall have the right to perform such due maintenance, Deleted: 12 and Tenant shall reimburse the Commission for the cost of such maintenance upon presentation of a billing. C. Tenant shall provide and maintain hand fire extinguisher for the interior of the Hangar Space of the building in accordance with applicable safety codes. Fire Extinguishers shall be at minimum, rated 2A, 10B:C as further defined by the NFPA 10: Standard for Portable Fire Extinguishers d. Tenant shall not store any materials outside the Hangar Space. e. Tenant shall promptly notify the Commission, in writing, of any repairs needed on the Hangar or to the Hangar Space. 8. Rights and Obligations of the Commission a. The Commission shall at all times operate and maintain the Airport as a public airport consistent with and pursuant to the Sponsors Assurances given by Authority to the United States Government under the Federal Airport Act. b. The Commission shall not unreasonably interfere with the Tenant's use and enjoyment of the Hangar Space. C. The Commission shall maintain and keep the Hangar and Hangar Space in good repair except for the maintenance obligations of Tenant set forth in the Lease. In no event, however, shall the Commission be required to maintain or repair damage caused by the negligent or willful act of Tenant, its agents, servants, invitees, or customer. However, if due to any negligent or willful act by the Tenant, its agents, servants, invitees or customer, there is a need for maintenance or repair of damage, then Tenant shall so such maintenance or repair in a prompt, reasonable manner, as approved by the Commission. d. Snow shall be removed from in front of Hangar Space to within at least two (2) feet of the Hangar. Snow removal closer than two (2) feet is the responsibility of the Tenant. e. The Commission shall ensure appropriate grounds keeping is performed year round. 9. Sublease/Assignment. Tenant shall not sublease the Hangar Space or assign this Lease without the prior written approval of the Commission. 10. Condition of Premises. Tenant shall accept the Hangar Space in its present condition without any liability or obligation on the part of the Commission to make any alterations, improvements or repairs of any kind on or about said Hangar Space. 11. Alterations. Tenant shall not install any factures or make any alterations, additions or improvements to the Hangar Space without the prior written approval of the Commission, or designee. All fixtures installed or additions and improvements made to the Hangar Space shall, upon completion of such additions and improvements, become Commission property and shall remain in the Hangar Space at the expiration or termination of this Lease, however terminated, without compensation or payment to Tenant. Fixtures include, but are not limited to, locks, brackets for window coverings, plumbing, light fixtures. luminaries, and any item permanently attached to the wall, floor, or ceiling of the Hangar Space by means of cement, plaster, glue, nails, bolts, or screws. 12. Hazardous Materials. a. With the exception of Paragraph 11 c below, no "hazardous substance," as defined in Iowa Code section 455B.411 (2005), may be stored, located, or contained in the Hangar Space without the Commission prior written approval. (The Iowa Code can be found online at www.leois.state.ia.us/IACODE . The. U.S. Code can be found online at www.findlaw.com/casecode/uscodes/index.html Federal regulations can be found online at httr)71/www,access.qpo.clov/nara/cfr/cfr-table- search.html. ) Petroleum products and their byproducts for personal use may be stored or present in the Hangar Space if said substances are contained in approved containers. b. With the exception of Paragraph 11c below, Tenant shall handle, use, store and dispose of fuel petroleum products, and all other nonhazardous substances" owned or used by it on the Airport in accordance with all applicable federal, state, local and airport statutes, regulations, rules and ordinances. No waste or disposable materials shall be released on the ground or in the storm sewers. Should such materials be spilled or escape from storage or in any way contaminate the Airport or property adjacent to the Airport through activities of the Tenant, the Tenant shall be responsible for the clean up, containment and otherwise abatement of such contamination at Tenant's sole cost and expense. Further, Tenant shall notify the Commission and appropriate governmental agency of such occurrence immediately. Should Tenant fail to do so, the Commission may take any reasonable and appropriate action in the Tenant's stead. The cost of such remedial action by the Commission shall be paid by the Tenant. c. Tenant may have the following materials stored in the Hangar Space. • 1 case of engine oil • 2 112 gallons gasoline for motorized tugs (but no aviation fuel or gasoline in drums) • 1 gallon of cleaning solvents 13, Special Events. During any special event at the Airport, including but not limited to the Sertoma Breakfast or Fly Iowa, Tenant acknowledges that the standard operating procedure at the Airport may be altered such that egress and ingress to the Hangar Space may be altered by the Commission in writing. Tenant's failure to comply with the altered procedure is a default of this Lease, and the Commission may proceed to terminate this Lease. 14, Airport Rules and Regulations. Tenant agrees to be subject to Airport rules and regulations upon adoption by the Commission or provide 30-days notice to terminate this Lease. Commission shall provide Tenant with a copy of said and regulations 30-days prior to their effective date. 15. Access and Inspection. The Commission has the right to enter and inspect the Hangar Space at any reasonable time during the term of this Lease upon at least 24 hours notice to the Tenant for any purpose necessary, incidental to or connected with the performance of its obligations under the Lease or in the exercise of its governmental functions. In the case of an emergency, the Commission may enter the Hangar Space without prior notice but will provide notice to the Tenant after the fact_ The Commission shall not, during the course of any such inspection, unreasonably interfere with the Tenant's use and enjoyment of the Hangar Space. At a minimum, the Hangar Space will be inspected annually. Upon execution of this Lease, the Tenant subsequently changes the lock to the Hangar Space, he or she shall provide shall provide notice to the Commission before he or she does so and shall provide a new key to the Commission within twenty-four hours of doing so. 1& Insurance. Tenant shall at its own expense procure and maintain general liability and casualty insurance in a company or companies authorized to do business in the State of Iowa, in the following amounts: Type of Coverage Comprehensive General (or Premises) Liability - Each Occurrence $1,000,000 b. Tenant's insurance carrier shall be A rated or better by A.M. Best. Tenant shall name the Commission and the City of Iowa City, as additional insured. The Commission and Tenant acknowledge that a Certificate of Insurance is attached to this Lease. Tenant shall provide fifteen (15) days notice to the Commission before cancellation of said insurance. C. It is the Tenant's responsibility to keep the insurance certificate current. If the Certificate of Insurance expires during the tens of the lease, the Tenant must provide a current certificate to the Commission within seven (7) days of when the Certificate expires. 17. Casualty. In the everifthe Hangar or Hangar Space, or the means of access thereto, shall be damaged by fire or any other cause, the rent payable hereunder shall not abate provided that the Hangar Space is not rendered untenantable by such damage. If the Hangar Space is rendered untenantable and Commission elects to repair the Hangar or Hangar Space, the rent shall abate for the period during which such repairs are being made, provided the damage was not caused by the ads or omissions of Tenant, its employees, agent or invitees, in which case the rent shall not abate. If the Hangar or Hangar Space is rendered untenantable and Commission elects not to repair the Hangar or Hangar Space, this Lease shall terminate. 18. Indemnity. Tenant agrees to release, indemnify and hold the Commission, its officers and employees harmless from and against any and all liabilities, damages, business interruptions, delays, losses, claims, judgments, of any kind whatsoever, including all costs, attorneys' fees, and expenses incidental thereto, which may be suffered by, or charged to, the Commission by reason of any loss or damage to any property or injury to or death of any person arising out of or by reason of any breach, violation or non- performance by Tenant or its servants, employees or agents of any covenant or condition of the Lease or by any act or failure to act of those persons. The Commission shall not be liable for its failure to perform this Lease or for any loss, injury, damage or delay of any nature whatsoever resulting therefrom caused by any act of God, fire, flood, accident, strike, labor dispute, dot, insurrection, war or any other cause beyond Commission's control. 19. Disclaimer of Liability. The Commission hereby disclaims, and Tenant hereby releases the Commission from any and all liability, whether in contract or tort (including strict liability and negligence) for any loss, damage or injury of any nature whatsoever sustained by Tenant, its employees, agents or invitees during the term of this Lease, including, but not limited to, loss, damage or injury to the Aircraft or other property of Tenant that may be located or stored in the Hangar Space, unless such loss, damage or injury is caused by the Commission's gross negligence or intentional willful misconduct. The parties hereby agree that under no circumstances shall the Commission be liable for indirect consequential, special or exemplary damages, whether in contract or tort (including strict liability and negligence), such as, but not limited to, loss of revenue or anticipated profits or other damage related to the leasing of the Hangar Space under this Lease. 20. Attorney Fees. If the Commission files an action in district court to enforce its rights under this Lease and if judgment is entered against the Tenant, Tenant shall be liable to and shall pay for the Commission's attorney fees incurred in enforcing the Lease and in obtaining the judgment. 21. Default. This Lease shall be breached if: (a) Tenant fails to make the rental payment; or (b) Tenant or the Commission fails to perform any other covenant herein and such default shall continue for five (5) days after the receipt by the other party of written notice. 22. Security. Tenant acknowledges that the FAA or another governmental entity or subdivision may enact laws or regulations regarding security at general aviation airports such that the Commission may not be able to comply fully with its obligations under this Lease, and Tenant agrees that the Commission shall not be liable for any damages to Tenant that may result from said non-compliance. 23. Thirty (30) Days Termination. Either party to this Lease shall have the right, with cause, to terminate this Lease by giving thirty (30) days' prior written notice to the other party. 24. Non -Discrimination. Tenant shall not discriminate against any person in employment or public accommodation because of race, religion, color, creed, gender identity, sex, national origin, sexual orientation, mental or physical disability, marital status or age. "Employment" shall include but not be limited to hiring, accepting, registering, ctassdying, promoting, or referring to employment. "Public accommodation" shall include but not be limited to providing goods, services, facilities, privileges and advantages to the public. 25. Doing Business at the Airport. Tenant acknowledges that he/sheld may only conduct business and engage in commercial activity at the Airport as provided in the Minimum Standards and only after written permission has been obtained from the Airport Commission. 26. FAA Provisions. a. Tenant, for itself, heirs, personal representatives, successors in interest, and assigns, as a part of the consideration hereof, does hereby covenant and agree as a covenant running with the land that in the event facilities are constructed, maintained, or otherwise operated on the said property described in this (license, lease, permit, etc.) for a purpose for which a Department of Transportation program or activity is extended or for another purpose involving the provision of similar services or benefits, the (licensee, lessee, permittee, etc.) shall maintain and operate such facilities and services in compliance with all other requirements imposed pursuant to 49 CFR Part 21, Nondiscrimination in Federally Assisted Programs of the Department of Transportation, and as said Regulations may be amended. b. Tenant, for itself, personal representatives, successors in interest, and assigned, as a part of the consideration hereof, does hereby covenant and agree as a covenant running with the land that: (1) no person on the grounds of race, color, or national origin shall be excluded from participation in, denied the benefits of, or be otherwise subject to discrimination in the use of said facilities, (2) that in the construction of any improvements on, over, or under such land and the furnishing of services thereon, no person on the grounds of race, color, or national origin shall be excluded from participation in, denied the benefits of, or otherwise be subject to discrimination, (3) that Tenant, shall use the premises in compliance with all other requirements imposed by or pursuant to 49 CFR Part 21, Nondiscrimination in Federally Assisted Programs of the Department of Transportation, and as said Regulations may be amended. C. It in understood and agreed that nothing herein contained shall be construed to grant or authorize the granting of an exclusive right within the meaning of Section 308 of the Federal Aviation Act of 1958. This Lease shall be subordinate to the provisions of any outstanding or future agreement between the Commission and the United States government or the Commission and the State of Iowa relative to the maintenance, operation, or development of the Iowa City Municipal Airport. Tenant acknowledges and agrees that the rights granted to Tenant in this Lease will not be exercised so as to interfere with or adversely affect the use, operation, maintenance or development of the Airport d. Tenant agrees to furnish service on a fair, equal and not unjustly discriminatory basis to all users thereof, and to charge fair, reasonable and not unjustly discriminatory prices for each unit or service; provided, that Tenant may make reasonable and non-discriminatory discounts, rebates, or other similar types of price reductions to volume purchasers. e. The Commission reserves the right (but shall not be obligated to Tenant) to maintain and repair the landing area of the airport and all publicly -owned facilities of the airport, together with the right to direct and control all activities of Tenant in this regard. f. The Commission reserves the right further to develop or improve the landing area and all publicly -owned air navigation facilities of the airport as it sees fit, regardless of the desires or views of Tenant, and without interferences or hindrance. g. The Commission reserves the right to take any action it considers necessary to protect the aerial approaches of the airport against obstructions, together with the right to prevent Tenant from erecting, or permitting to be erected, any building or other structure on the airport which in the opinion of the Commission would limit the usefulness of the airport or constitute a hazard to aircraft. h. During time of war or national emergency, the Commission shall have the right to enter into an agreement with the United States Government for military or naval use of part or all of the landing area, the publicly -owned air navigation facilities and/or other areas or facilities of the airport. If any such agreement is executed, the provisions of this instrument, insofar as they are inconsistent with the provisions of the agreement with the Government, shall be suspended. i. It is understood and agreed that the rights granted by this Lease will not be exercised in such a way as to interfere with or adversely affect the use, operation, maintenance or development of the airport. j. There is hereby reserved to the Commission, its successors and assigns, for the use and benefit of the public, a free and unrestricted right of flight for the passage of aircraft in the airspace above the surface of the premises herein conveyed, together with the right to cause in said airspace such noise as may be inherent in the operation of aircraft, now known or hereafter used for navigation of or flight in the air, using said airspace or landing at, taking off from, or operating on or about the airport. k. The Lease shall become subordinate to provisions of any existing or future agreement between the Commission and the United States of America or any agency thereof relative to the operation, development, or maintenance of the airport, the execution of which has been or may be required as a condition precedent to the expenditure of federal funds for the development of the airport. 2T Remedies Cumulative. The rights and remedies with respect to any of the terms and conditions of this Lease shall be cumulative and not exclusive, and shall be in addtion to all other rights and remedies available to either party in law or equity. 28. Notices. Any notice, for which provision is made in this Lease, shall be in writing, and may be given by either party to the other, in addition to any other manner provided by law, in any of the following ways: a. by personal delivery to the Commission Chairperson b. by service in the manner provided by law for the service of original notice, or C. by sending said Notice by certified or registered mail, return receipt requested, to the last known address. Notices shall be deemed to have been received on the date of receipt as shown on the return receipt. (1) If to the Commission, addressed to: Iowa City Airport Commission Iowa City Municipal Airport 1801 S. Riverside Drive Iowa City, IA 52246 (2) If to Tenant, addressed to: 28, Integration. This Lease constitutes the entire agreement between the parties, and as of its effective date supersedes all prior independent agreements between the parties related to the leasing of the Hangar Space. Any change or modification hereof must be in writing signed by both parties. 29. Waiver. The waiver by either party of any covenant or condition of this Lease shall not thereafter preclude such party from demanding performance in accordance with the terms hereof. 30. Successors Bound. This Lease shall be binding and shall inure to the benefit of the heirs, legal representatives, successors and assigns of the parties hereto. 31. Severability. td If a provision hereof shall be finally declared void or illegal by any court or administrative agency having jurisdiction over the parties to this Lease, the entire Lease shall not be void, but the remaining provisions shall continue in effect as nearly as possible in accordance With the original intent of the parties. IOWA CITY AIRPORT COMMISSION By: Title: TENANT: By: Tide: Approved: City Attorney's Office T Hangar Lease g Monthly Expense Report - June'O9 Check Requests During Mouth Approved Check Requests 6/12009 Metro Paven (Runway 7-25 Paving & Lighting Rctainage) &12009 Sepagon Construction (Hangar H Expand) 6112009 Pip Printing (May Newslemm) 6/l2009 PNIMIC (Underground Fuel Tank Insurance) 6182009 Tanlmology (Annual Line/Leak Test for Underground Fuel Tank) 610009 Van Meter Industrial (Lights forWs") _ 6/W009 AECOM (Hangar H Expansion) 6r82009 Pip Printing (May Ncwslerer 2nd batch) 6/82009 Jet Air (Maintenance Contract) 6/162009 Overhead Door (hangar repair 821) 6r162009 Van Meter Industrial (Lights Bulbs - Stock) 6/182009 AECOM (Runway 12-30 Reconstruction - ARRA) 6/182009 AECOM (Runway 7-25 & 12-30) 6/182009 AECOM (South Airfield Study) 6/242009 Van Meter (Terminal Bldg Bulbs) 6232009 Fastemd Company (reflective marker tape) 6232009 Fed Ex 6/302009 Metro Pavers (Runway 7-25 Reconstruct - Prefinal) 8/30/2009 Metro Pavers (Runway 12-30 ARRA) 8/302009 Metro Pavers (Runway 7-25 Reconstruct - Add Alternate Prefinal) 6/302009 Sepegon Construction (Hangar H Expand) Airport Operating Expenses City CIP Fund Expenses Total Expenses Capital Projects Construction Contracts Pending Expenses South Economic Study - ALP Update South T-Hangar Taxilane United Hangar Runway 7-25 Reconstruct and Alternate North T-Hangar Taxilane Rehab Runway 7-25 & 12-30 Reconstruction Runway 12-30 Reconstruction Hangar H Expand Airport Funds CIP Funds $67,045.60 $105,893.74 $59.00 $750.00 $357.60 5144.29 $907.59 558.00 $5,286.54 $137.50 $262.33 $28,600.00 $17,430.00 $593.28 5126.38 536.54 $49.54 $13,501.56 5194,549.10 52,970.95 $81,537.90 $7,266.72 $513,029.62 5520,296,34 $1,380,788.17 Project Bid Amount Paid During Month Paid During FiscalYear Paid To Date % Paid $15,000.00 5593.28 $1,895.23 $14,319.35 95.5 $140,794.15 $93,935.64 $98,935.64 70.3 $103,060.00 $94,562.69 $94,562.69 91.8 51,468,010.83 $16,472.51 $064,315.66 $1.364,315.66 92.9 $163,726.00 $153,843.43 $153,943.43 94.0 $1,890,900.50 0.0 $1,522,771.00 $194,549.10 $194,549,10 $194,549.10 12.6 5350,840.00 $187,431.54 $197,431.54 $197,431.54 53.4 Total Pending Expenses 50.00 50.00 REVE: 07.13.09 11:39:46 Iowa City General Ledger System FY 2009 Revenue Reporting For the period 06.01.09 to 06.30.09 Estimated Account Revenue ------------------------------------------------- 7600 Airport CONTRIB & DONATIONS 362100 Contrib & Donations Total CONTRIB & DONATIONS OTHER MISC REVENUE 369100 Reimb of Expenses 369900 Miscellaneous Other Income Total OTHER MISC REVENUE INTEREST REVENUES 381100 Interest on Investments Total INTEREST REVENUES RENTS 3821DD Land Rental 382200 Building/Room Rental Total RENTS ROYALTIES & COMMISSIONS 384200 Vending Machine Comm 384900 Other Commissions Total ROYALTIES & COMMISSIONS TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES Total TRANSFERS Total Airport *** GRAND TOTAL tt} Page: 1 YTD Period Revenue Revenue Remainder % --------- ----------- ------------ ------ 250.00 -250.00 ------------------------ ------------ 250.00 ------------ -250.00 •----- 28496.25 -28496.25 200.00 -200.00 ------------------------ ------------ 28696.25 ------------ -28696.25 ------ 1000.00 1596.11 -596.11 159.61 ------------------------ 1000.00 --•--------- 1596.11 ------------ -596.11 •----- 159.61 30700.00 33005.50 634.93 -2305.50 107.51 226000.00 211039.33 13441.00 14960.67 93.38 ------------------------ 256700.00 --- 244044.83 ----- --- ----- 14075.93 12655.17 95.07 168.00 72.00 10.80 96.00 42.86 20000.00 19236.70 3777.60 763.30 96.18 ------------------------ 20168.00 ------------ 19308.70 ------------ 3788.40 859.30 ------ 95.74 130000.00 129999.96 10033.33 .04 100.00 ------------------------ 130000.00 ------------ 129999.96 ------------ 10833.33 .04 ------ 100.00 ------------ -- 130000.00 •••• 129999.96 - ------ ------•-•--- 10833.33 .04 ------ 100.00 407868.00 423895.85 28697.66 -16027.85 103.93 ------------------------ 407868.00 ------------------------ ------------------------ ------------ 423895.85 ------------ ------------ ------------ 28697.66 ------------ ------------ -16027.85 ------ 103.93 ------ ------ E%PE: 07.13.09 11:40:16 Page: 1 Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used ------------------------------------------ 7600 Airport AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 412000 Perm Part Time 413000 Temporary Employees Total REGULAR SALARIES & WAGES OTHER WAGES 414100 Overtime Wages 414300 Term -Vacation Pay 414400 Term -Sick Leave 414500 Longevity Pay Total OTHER WAGES Total SALARIES & WAGES EMPLOYER BENEFITS GROUP INSURANCE 421100 Health Insurance 421200 Dental Insurance 421300 Life Insurance 421400 Disability Insurance 421500 Unemployment Compensation Total GROUP INSURANCE SOCIAL SECURITY CONTRIBUTIONS 422100 FICA Total SOCIAL SECURITY CONTRIBUTIONS RETIREMENT CONTRIBUTIONS 423100 IPBRS Total RETIREMENT CONTRIBUTIONS 3B611.00 17790.38 22603.00 27564.23 2283.60 10000.00 5182.39 -------------------- 71214.00 ------------ 50537.00 2283.60 20820.62 46.08 -4961.23 121.95 4817.61 51.82 -------- ------ 20677.00 70.96 1000.00 473.28 526.72 47.33 1251.50 -1251.50 1720.57 -1720.57 1050.00 437.50 612.50 41.67 ------------ ------------ 2050.00 ------------ 3882.85 ------------ ------------ -1832.85 ------ 189.41 ------------ ------------ 73264.00 ------------ 54419.85 ------------ 2283.60 ------------ 19844.15 ------ 74.28 7280.00 4931.80 285.62 2348.20 67.74 490.00 305.72 17.70 184.28 62.39 198.00 139.18 58.82 70.29 460.00 160.65 14.10 299.35 34.92 832.00 -832.00 ------------------------ 8428.00 ------------ 6369.35 ------------ 317.42 ------------ 2058.65 ------ 75.57 5605.00 4050.64 166.96 1554.36 72.27 ------------------------ 5605.00 ------------ 4050.64 ------------ 166.96 ------------ 1554.36 ------ 72.27 4652.00 3058.04 145.00 ------------------- ------ 4652.00 3058.04 145.00 1593.96 65.74 1593.96 65.74 EXPE: 07.13.09 11:40:16 Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 Page: 2 YTD Period Account Appropriated ------------ Expenditures ------------ Expenditures Encumbrance ------------ ------------------------ Balance t Used ------ ------------------------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) EMPLOYEE BENEFITS (CONTINUED) OTHER EMPLOYEE BENEFITS 424500 Monthly Cellular/PCS Allowance 137.50 ----------------------- -137.50 ------ Total OTHER EMPLOYEE BENEFITS ------------ ------------ 137.50 ------------ ------------------------ -137.50 ------ Total EMPLOYEE BENEFITS ------------ 18685.00 ------------ 13615.53 ------------ 629.38 5069.47 72.87 PROFESSIONAL & TECHNICAL SERVICES PROFESSIONAL SERVICES 432020 Annual Audit 554.00 927.63 -373.63 167.44 432060 Consultant Services 5000.00 5000.00 432070 Management Services 9000.00 4500.00 4500.00 50.00 432080 Other Professional Services 500,00 500.00 ------------ ------------------------ -500.00 ------ Total PROFESSIONAL SERVICES ------------ 14554.00 ------------ 5927.63 500.00 8626.37 40.73 DATA AND COMMUNICATION SERVICES 435056 Delivery Services 36.98 -36.98 435060 Legal Publications 12.00 226.96 12.18 ------------ ------------ -214.96 1891.3 ------ Total DATA AND COMMUNICATION SERVICES ------------ 12.00 ------------ 263.94 ------------ 12.18 -251.94 2199.5 TRAINING & EDUCATION 436030 Transportation 900.00 136.40 136.40 763.60 15.16 436050 Registration 400.00 250.00 150.00 62.50 436060 Lodging 500.00 232.96 267.04 46.59 436080 Meals 150.00 121,00 55.00 ------------------------ ------------ 29.00 80.67 ------ Total TRAINING & EDUCATION ------------ 1950.00 ------------ 740.36 191.40 1209.64 37.97 INSURANCE 437010 Comp Liability Insurance 8578.00 5000.00 3578.00 58.29 437020 Fire & Casualty Insurance 16893.00 14557.03 4917.00 2335.97 86.17 437030 Workers Comp Insurance 73.00 90.00 -17.00 123.29 437041 Bonding & Other Insurance 928.00 875.00 53.00 94.29 437042 Fidelity Bond EXPE: 07.13.09 11:40:16 Account Page: 3 Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 YTD Period Appropriated Expenditures Expenditures Encumbrance Balance o Used ------------ ------------ ---------- ------ ------------------------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) INSURANCE (CONTINUED) 437200 Loss Reserve Payment Total INSURANCE UTILITY SERVICES 438010 Stormwater Utility Charges 438030 Electricity 438070 Heating Fuel/Gas 438080 Sewer Utility Charge 43BD90 Water Utility Charge 43810D Refuse Collection Charges 438110 Local Phone Service 438120 Long Distance Service 438130 Wireless Phone Service Total UTILITY SBRVICBS Total PROFESSIONAL & TECHNICAL SERVICES REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building Repair & Maintena 442020 Structure Repair & Maintenance S 442030 Heating Equipment Repair & Maint 442040 Cooling Equipment Repair & Maint 442060 Electrical & Plumbing Repair & M 442070 Bldg Pest Control Services Total BUILDING REPAIR & MAINTENANCE SERVICE EQUIPMENT REPAIR & MAINTENANCE SERVICES 443050 Radio Equipment Repair & Mainten 443080 Other Equipment Repair & Mainten 5000.00 5000.00 100.00 ------ ------------------------ 31472,00 ------------ 25522.03 ------------ 4917.00 ------------ 5949.97 81.09 7104.00 7803.52 591.96 -699.52 109.85 15530.00 12320.27 880.61 3209.73 79.33 8680.00 7972.72 90.63 707.28 91.85 1475.00 1611.74 109.01 -136.74 109.27 1321.00 1428.79 101.31 -107.79 108.16 1200.00 1163.00 99.00 37.00 96.92 264.00 836.50 79.79 -572.50 316.86 30.00 55.64 4.85 -25.64 185.47 -3.45 3.45 ------------ ----------- 35604.00 ------------ 33188.73 ------------ 1957.16 ------------ 2415.27 ------ 93.22 ------------ ------------ 83592.00 ------------ 65642.69 ------------ 7577.74 ------------ 17949.31 ------ 78.53 7500.00 12603.86 137.50 -5103.86 168.05 4000.00 4535.27 -535.27 113.38 500.00 1657.80 -1157.80 331.56 1959.00 449.23 1509.77 22.93 500.00 264.59 235,41 52.92 431.00 407.40 33.95 23.60 94.52 ------------ ------------ 14890.00 ------------ 19918.15 ------------ 171.45 ------------ -5028.15 ------ 133.77 1600.00 1600.00 813.00 1399.38 100.00 -586.38 172.13 E%PE: 07.13.09 11:40:16 Account Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 YTD Period Appropriated Expenditures Expenditures ----------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) EQUIPMENT REPAIR & MAINTENANCE SERVICES (CO Total EQUIPMENT REPAIR & MAINTENANCE SERVIC TECHNICAL SERVICES 445030 Nursery Service -Lawn and Plant C 445080 Snow and Ice Removal 445110 Testing Services 445140 Outside Printing 445230 Other Technical Services Total TECHNICAL SERVICES INTRA-DEPARTMENT SERVICES 446100 City Attorney Chargeback 446130 ITS-PC/Peripheral Support Charge 446140 ITS -Computer Replacement Chargeb 446160 ITS-Network/Internet Chargeback 446200 Photocopying Chargeback 446220 Phone Service Chargeback 446280 Telecom Move/Add/Change Chargeba 446300 Phone Equipment/Line Chargeback 446320 Mail Chargeback 446350 City Vehicle Replacement Chargeb 446360 City Vehicle Rental Chargeback 446370 Fuel Chargeback 446380 Vehicle Repair & Maintenance Cha Total INTRA-DEPARTMENT SERVICES MISCELLANEOUS SERVICES & CHARGES 449055 Permitting Fees 449060 Dues & Memberships 449120 Equipment Rental 449140 Tools Rental Page: 4 Encumbrance Balance s Used ----------- ------------ ------ ------------ ------------ 2413.00 ------------ 1399.38 ----------- 100.00 - ------------ 1013.62 ------ 57.99 300.00 4500.00 4500.00 -4200.00 1500.0 21500.00 -21500.00 1900.00 1737.70 357.60 162.30 91.46 139.00 596.10 116.00 -457.10 428.85 5121.00 5121.00 ----------------------- 7460.00 ------------ 28333.80 ------------ 4973.60 ------------ -20873.80 ------ 379.81 4036.00 5812.36 -1776.36 144.01 400.00 400.00 100.00 633.00 633.36 52.78 -.36 100.06 360.00 360.00 30.00 100.00 455.00 336.60 20.64 118.40 73.98 612.00 577.68 48.14 34.32 94.39 157.52 36.52 -157.52 913.00 937.50 85.00 -24.50 102.68 706.00 509.77 15.79 196.23 72.21 14176.00 13953.88 1161.30 222.12 98.43 143.00 -143.00 4861.00 4644.92 425.85 216.08 95.55 3516.00 6314.98 -2798.98 179.61 ------------ ------------ 30668.00 ------------ 34781.57 ------------ 1876.02 ------------ -4113.57 ------ 113.41 65.00 -65.00 525.00 625.00 -100.00 119.05 250.00 250.00 250.00 250.00 EKPB: 07.13.09 11:40:16 Page: 5 Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 YTD Period Account Appropriated Expenditures Expenditures Encumbrance 'Balance t Used ------------------------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) MISCELLANEOUS SERVICES & CHARGES (CONTINUED 449360 Interest Expense Total MISCELLANEOUS SERVICES & CHARGES Total REPAIR & MAINTENANCE OTHER PURCHASED SERVICES (CHANGE TO OFFICE SO GENERAL SUPPLIES 452010 Office Supplies 452030 Minor Office Equipment/Furniture 452040 Sanitation & Industrial Supplies Total GENERAL SUPPLIES BOOKS & PERIODICALS 454020 Subscriptions 454040 Books, Magazines, Newpapers Total BOOKS & PERIODICALS COMPUTER & PRINTING SUPPLIES 455110 Software 455120 Misc Computer Hardware Total COMPUTER & PRINTING SUPPLIES Total OTHER PURCHASED SERVICES (CHANGE TO OFF OPERATING SUPPLIES AGRICULTURE SUPPLIES 461040 Other Agriculture Chemicals Total AGRICULTURE SUPPLIES 61294.00 45895.19 3824.74 15398.81 74.88 ----------- ----------- ------------ ------------ ------------ ------ 62319.00 46585.19 3824.74 15733.81 74.75 ------------ ----------------------- 117750.00 131018.09 10945.81 859.00 610.79 642.00 1821.00 2000.00 13268.09 111.27 248.21 71.10 642.00 179.00 109.83 ------------ ------------ ----------------------- ------------ ------ 3322.00 2610.79 711.21 78.59 1870.00 2036.00 166.00 108.88 ------------ ------------ ------------ ------------ ------------ ------ 1870.00 2036.00-166.00 108.88 91.00 500.00 -91.00 500.00 ------------ ------------ 500.00 ------------ ------------ 91.00 ------------ 409.00 ------ 18.20 ------------------------ 5692.00 ------------------------ 4737.79 ------------ 954.21 ------ 83.24 364.00 424.41 286.54 -60.41 116.60 ------------ ------------ 364.00 ------------ ------------ 424.41 286.54 ------------ -60.41 ------ 116.60 EXPE: 07.13.09 11:40:16 Page: 6 Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used ------------------------------------------------------------------------------------------------------- ------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) CHEMICAL & LAB SUPPLIES 463200 Other Chemicals & Supplies Total CHEMICAL & LAB SUPPLIES FUELS & LUBRICANTS 465020 Gasoline 465030 Diesel Fuel 465060 Lubricants Total FUELS & LUBRICANTS REPAIR & MAINTENANCE SUPPLIES 466020 Lumber/Hardware 466030 Paint Supplies 466040 Plumbing Supplies 466050 Electrical Supplies 466060 Other Construction Supplies 466070 Other Maintenance Supplies Total REPAIR & MAINTENANCE SUPPLIES EQUIPMENT REPAIR & MAINTENANCE SUPPLIES 467020 Equipment Repair & Maintenance S 467160 Other Vehicle Repair & Maintenan Total EQUIPMENT REPAIR & MAINTENANCE SUPPLI SURFACING MATERIALS 468020 Concrete 468030 Asphalt 468050 Sand Total SURFACING MATERIALS 199.98 -199.98 ------------------------ ------------ 199.98 ------------ ------------ -199.98 ------ 133.52 -133.52 373.88 -373.88 101.00 101.00 ------ ------------ ------------ 101.00 ------------ 507.40 ------------ ------------ -406.40 502.38 27.01 -27.01 23.00 23.00 6.00 6.00 349.00 163.82 144.29 185.18 46.94 838.00 838.00 589.00 125.02 55.64 463.98 ------------ 21.23 ------ ------------ ------------ 1805.00 ------------ 315.85 ------------ 199.93 1489.15 17.50 650.00 124.40 124.40 525.60 19.14 73.00 73.00 ------------------------ 723.00 ------------ 124.40 ------------ 124.40 ------------ 598.60 ------ 17.21 153.00 153.00 600.00 129.65 470.35 21.61 54.00 58.35 -4.35 108.06 ------ ------------------------ 807.00 ------------ 188.00 ------------ ------------ 619.00 23.30 E%PE: 07.13.09 11:40:16 Account Page: 7 Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 YTD Period Appropriated Expenditures Expenditures Encumbrance Balance t Used ------------------------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) OTHER SUPPLIES 6 EQUIPMENT 469040 Traffic Control Improvement Supp 469190 Minor Equipment 469200 Tools 469210 First Aid/Safety Supplies 469260 Fire Bat 6 Refills 469320 Miscellaneous Supplies 469360 Food and Beverages Total OTHER SUPPLIES 6 EQUIPMENT Total OPERATING SUPPLIES IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements Total IMPROVEMENTS OTHER THAN BUILDING OTHER FINANCIAL USES 490150 Operating Subsidy 490160 Misc Transfers Out 490190 Interfund Loan Total OTHER FINANCIAL USES Total Airport Operations Total Airport 106.00 330.00 -224.00 311.32 888.00 99.00 789.00 11.15 104.88 45.90 -104.88 57.00 57.00 111.00 78.50 31.50 70.72 451.65 -451.65 85.53 -85.53 ------ ------------ ------------ 1162.00 ------------ 1149.56 ------------ 45.90 ------------ 12.44 98.93 ------ ------------ ------------ 4962.00 ------------ 2909.60 ------------ 656.77 ------------ 2052.40 58.64 70390.00 8114.00 62276.00 ------------ 11.53 ------ ------------------------ 70390.00 ------------ 8114.00 ------------ 62276.00 11.53 8359.00 8358.96 696.58 .04 100.00 28486.25 -28486.25 56426.00 23224.89 1935.27 33201.11 ------------ 41.16 ------ ------------ ------------ 64785.00 ------------ 60070.10 ------------ 2631.85 4714.90 92.72 ------------------------ 439120.00 ------------ 340527.65 ------------ 24725.15 ------------ 98592.35 ------ 77.55 ------------------------ 439120.00 ------------ 340527.65 ------------ 24725.15 ------------ 98592.35 ------ 77.55 ERPE: 07.13.09 11:40:16 Page: 8 Iowa City General Ledger System FY 2009 Expense Reporting For the period 06.01.09 to 06.30.09 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance s Used ------------------------------------------------------- ------------ ------------------------------------ ------------ -- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) ------------ ----------------- ------- t+r GRAND TOTAL +++ 439120.00 340527.65 24725.15 98592.35 77.55 REVS: 07.13.09 11:41:21 Iowa City General Ledger System FY 2009 Revenue Reporting Estimated YTD Period Account Revenue Revenue Revenue --------------------------- ------------ ------------ ---------- ----------------------------------------- 7600 Airport CONTRIB & DONATIONS 362100 Contrib R Donations Total CONTRIB 8 DONATIONS OTHER RISC REVENUE 369100 Reimb of Expenses 369900 Miscellaneous Other Income Total OTHER RISC REVENUE INTEREST REVENUES 381100 Interest on Investments Total INTEREST REVENUES RENTS 382100 Land Rental 382200 Building/Room Rental Total RENTS ROYALTIES 6 COMMISSIONS 384200 Vending Machine Comm 384900 Other Commissions Total ROYALTIES 6 COMMISSIONS TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES Total TRANSFERS Total Airport *** GRAND TOTAL *** Page: 1 Remainder t ---------- ------ 250.00 250.00-250.00 ----------- ------------ ------------ ------------ -- 250.00 250.00-250.00 28496.25 28496.25-28496.25 200.00 200.00-200.00 ------------------------------------------------ ------ 28696.25 28696.25-28696.25 1000.00 1596.11 1596.11-596.11 159.61 ------------ ------------ ------------ ------------ ------ 1000.00 1596.11 1596.11-596.11 159.61 30700.00 33005.50 33005.50-2305.50 107.51 226000.00 211039.33 211039.33 14960.67 93.38 ------------------------------------ ------------ ------ 256700.00 244044.83 244044.83 12655.17 95.07 168.00 72.00 72.00 96.00 42.86 20000.00 19236.70 19236.70 763.30 96.18 ------------ ------------ ------------ ------------ ------ 20168.00 19308.70 19308.70 859.30 95.74 130000.00 129999.96 129995.96 .04 100.00 ------------ ------------ ------------ ------------ ------ 130000.00 129999.96 129999.96 .04 100.00 ------------ ------------ ------------ ------------ ------ 130000.00 129999.96 129999.96 .04 100.00 ----------- ------------ ------------ ------------ ------ 407868.00 423895.85 423895.05-16027.85 103.93 ------------ ------------ ------------ ------------ ------ 407868.00 423895.85 423895.85-16027.85 103.93 EXPE: 07.13.09 11:42:09 Account ---------------------------- ------------- 7600 Airport AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 412000 Perm Part Time 413000 Temporary Employees Total REGULAR SALARIES & WAGES OTHER WAGES 414100 Overtime Wages 414300 Term -Vacation Pay 414400 Term -Sick Leave 414500 Longevity Pay Total OTHER WAGES Total SALARIES & WAGES EMPLOYER BENEFITS GROUP INSURANCE 421100 Health Insurance 421200 Dental Insurance 421300 Life Insurance 421400 Disability Insurance 421500 Unemployment Compensation Total GROUP INSURANCE SOCIAL SECURITY CONTRIBUTIONS 422100 FICA Total SOCIAL SECURITY CONTRIBUTIONS RETIREMENT CONTRIBUTIONS 423100 IPERS Total RBTIRBMENT CONTRIBUTIONS Page: 1 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Appropriated Expenditures Expenditures Encumbrance Balance % Used -------- ------------ ------------ ------------ ------ 38611.00 17790.38 17790.38 20820.62 46.08 22603.00 27564.23 27564.23 -4961.23 121.95 10000.00 5182.39 5182.39 4817.61 ------------ 51.82 ------ -------- ------------ 71214.00 ------------ 50537.00 ------------ 50537.00 20677.00 70.96 1000.00 473.28 473.28 1251.50 1251.50 1720.57 1720.57 1050.00 437.50 437.50 2050.00 3882.85 3882.85 -------- ------------ ------------ 73264.00 54419.85 54419.85 526.72 47.33 -1251.50 -1720.57 612.50 41.67 -1832.85 189.41 - ------- ------ 18844.15 74.28 7280.00 4931.80 4931.80 2348.20 67.74 490.00 305.72 305.72 184.28 62.39 198.00 139.18 139.18 58.82 70.29 460.00 160.65 160.65 299.35 34.92 B32.00 832.00 -832.00 ------ ------------ ------------ 8428.00 ------------ 6369.35 ------------ 6369.35 ------------ 2058.65 75.57 5605.00 4050.64 4050.64 1554.36 ------------ 72.27 ------ ------------ ------------ 5605.00 ------------ 4050.64 ------------ 4050.64 1554.36 72.27 4652.00 30SS.04 3058.04 1593.96 ------------ 65.74 ------ ------------------------ 4652.00 ------------ 3058.04 ------------ 3058.04 1593.96 65.74 H%PE: 07.13.09 11:42:09 Page: 2 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance I Used ---------- --------------------- ------------ ------------ ------------------------------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) EMPLOYER BENEFITS (CONTINUED) OTHER EMPLOYEE BENEFITS 424500 Monthly Cellular/PCS Allowance Total OTHER EMPLOYEE BENEFITS Total EMPLOYER BENEFITS PROFESSIONAL & TECHNICAL SERVICES PROFESSIONAL SERVICES 432020 Annual Audit 432060 Consultant Services 432070 Management Services 432080 Other Professional Services Total PROFESSIONAL SERVICES DATA AND COMMUNICATION SERVICES 435056 Delivery Services 435060 Legal Publications Total DATA AND COMMUNICATION SERVICES TRAINING & EDUCATION 436030 Transportation 436050 Registration 436060 Lodging 436080 Meals Total TRAINING & EDUCATION INSURANCE 437010 Comp Liability Insurance 437020 Fire & Casualty Insurance 437030 Workers Comp Insurance 437041 Bonding & Other Insurance 437042 Fidelity Bond 437200 Loss Reserve Payment ' 137.50 137.50 -137.50 ------ ------------------------ ------------ 137.50 ------------ 137.50 ------------ -137.50 ------------ ------------ 18685.00 --- 13615.53 --------- ------------ 13615.53 ------------ 5069.47 ------ 72.87 554.00 927.63 927.63 -373.63 167.44 5000.00 5000.00 9000.00 4500.00 4500.00 4500.00 50.00 500.00 500.00 -500.00 ------------ 14554.00 ------------ ------------ 5927.63 ------------ 5927.63 ------------ 8626.37 ------ 40.73 36.98 36.98 -36.98 12.00 226.96 226.96 -214.96 1891.3 ------ ------------ 12.00 ------------ ------------ 263.94 ------------ 263.94 ------------ -251.94 2199.5 900.00 136.40 136.40 763.60 15.16 400.00 250.00 250.00 150.00 62.50 500.00 232.96 232.96 267.04 46.59 150.00 121.00 121.00 29.00 80.67 ------------ 1950.00 ------------ ------------ 740.36 ------------ 740.36 ------------ 1209.64 ------ 37.97 8578.00 5000.00 5000.00 3578.00 58.29 16893.00 14557.03 14557.03 2335.97 86.17 73.00 90.00 90.00 -17.00 123.29 928.00 875.00 875.00 53.00 94.29 5000.00 5000.00 5000.00 100.00 EXPE: 07.13.09 11:42:09 Iowa City General Ledger System FY 2009 Expense Reporting Page: 3 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance t Used ------------------------------------------------------------------- ------------ ------------------------------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) INSURANCE (CONTINUED) - -------- ------ Total INSURANCE UTILITY SERVICES 43BO10 Stormwater Utility Charges 438030 Electricity 438070 Heating Fuel/Gas 43BOBO Sewer Utility Charge 438090 Water Utility Charge 438100 Refuse Collection Charges 438110 Local Phone Service 438120 Long Distance Service 438130 Wireless Phone Service Total UTILITY SERVICES Total PROFESSIONAL & TECHNICAL SERVICES REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building Repair & Maintena 442020 Structure Repair & Maintenance S 442030 Heating Equipment Repair & Maint 442040 Cooling Equipment Repair & Maint 442060 Electrical & Plumbing Repair & M 442070 Bldg Pest Control Services Total BUILDING REPAIR & MAINTENANCE SERVICE EQUIPMENT REPAIR & MAINTENANCE SERVICES 443050 Radio Equipment Repair & Mainten 443080 Other Equipment Repair & Mainten Total EQUIPMENT REPAIR & MAINTENANCE SERVIC ------------ ------------ 31472.00 ------------ 25522.03 ------------ 25522.03 - -- 5949.97 81.09 7104.00 7803.52 7803.52 -699.52 109.85 15530.00 12320.27 12320.27 3209.73 79.33 8680.00 7972.72 7972.72 707.28 91.85 1475.00 1611.74 1611.74 -136.74 109.27 1321.00 1428.79 1428.79 -107.79 108.16 1200.00 1163.00 1163.00 37.00 96.92 264.00 836.50 836.50 -572.50 316.86 30.00 55.64 55.64 -25.64 185.47 -3.45 -3.45 3.45 ------------ ------------ 35604.00 ------------ 33188.73 ------------ 33188.73 ----------- 2415.27 ------ 93.22 ------ ------------------------ 83592.00 ------------ 65642.69 ------------ 65642.69 ------------ 17949.31 78.53 7500.00 12603.86 12603.86 -5103.86 168.05 4000.00 4535.27 4535.27 -535.27 113.38 500.00 1657.80 1657.80 -1157.80 331.56 1959.00 449.23 449.23 1509.77 22.93 500.00 264.59 264.59 235.41 52.92 431.00 407.40 407.40 23.60 ------------ 94.52 ------ ------------------------ 14890.00 ------------ 19918.15 ------------ 19918.15 -5028.15 133.77 1600.00 1600.00 813.00 1399.38 1399.38 -586.38 172.13 ------------------------ 2413.00 ------------ 1399.38 ------------ 1399.38 -- --------- 1013.62 ------ 57.99 E%PE: 07.13.09 11:42:09 Page: 4 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures expenditures Encumbrance Balance t Used ------------------------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR 6 MAINTENANCE (CONTINUED) TECHNICAL SERVICES 415030 Nursery Service -Lawn and Plant C 445080 Snow and Ice Removal 445110 Testing Services 445140 Outside Printing 445230 Other Technical Services Total TECHNICAL SERVICES INTRA-DEPARTMENT SERVICES 446100 City Attorney Chargeback 446130 ITS-PC/Peripheral Support Charge 446140 ITS -Computer Replacement Chargeb 446160 ITS-Retwork/Internet Chargeback 446200 Photocopying Chargeback 446220 Phone Service Chargeback 446280 Telecom Move/Add/Change Chargeba 446300 Phone Rquipment/Line Chargeback 446320 Mail Chargeback 446350 City Vehicle Replacement Chargeb 446360 City Vehicle Rental Chargeback 446370 Fuel Chargeback 446380 Vehicle Repair 6 Maintenance Cha Total INTRA-DEPARTMENT SERVICES MISCELLANEOUS SERVICES E CHARGES 449055 Permitting Fees 449060 Dues 6 Memberships 449120 Equipment Rental 449140 Tools Rental 449360 Interest Expense Total MISCELLANEOUS SERVICES 6 CHARGES 300.00 4500.00 4500.00 -4200.00 1500.0 21500.00 21500.00 -21500.00 1900.00 1737.70 1737.70 162.30 91.46 139.00 596.10 596.10 -457.10 428.85 5121.00 5121.00 ------------ ------ ------------------------ 7460.00 ------------ 28333.80 ------------ 28333.80 -20873.80 379.81 4036.00 5812.36 5812.36 -1776.36 144.01 400.00 400.00 400.00 100.00 633.00 633.36 633.36 -.36 100.06 360.00 360.00 360.00 100.00 455.00 336.60 336.60 118.40 73.98 612.00 577.68 577.68 34.32 94.39 157.52 157.52 -157.52 913.00 937.50 937.50 -24.50 102.68 706.00 509.77 509.77 196.23 72.21 14176.00 13953.88 13953.88 222.12 98.43 143.00 143.00 -143.00 4861.00 4644.92 4644.92 216.08 95.55 3516.00 6314.98 6314.98 -2798.98 179.61 ------------ ------------ 30668.00 ------------ 34781.57 ------------ 34781.57 -------_-- -4113.57 ------ 113.41 65.00 65.00 525.00 625.00 625.00 250.00 250.00 61294.00 45895.19 ------------------------ 62319.00 46585.19 45895.19 -65.00 -100.00 119.05 250.00 250.00 15398.81 74.88 -------- - --------------------- --- --- 46585.19 15733.81 74.75 EXPE: 07.13.09 11:42:09 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance ------------------------------------------------------- ------------------------------------ ------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) MISCELLANEOUS SERVICES & CHARGES (CONTINUED Total REPAIR & MAINTENANCE OTHER PURCHASED SERVICES (CHANGE TO OFFICE SO GENERAL SUPPLIES 452010 Office Supplies 452030 Minor Office Equipment/Furniture 452040 Sanitation & Industrial Supplies Total GENERAL SUPPLIES BOOKS & PERIODICALS 454020 Subscriptions 454040 Books, Magazines, Newpapers Total BOOKS & PERIODICALS COMPUTER & PRINTING SUPPLIES 455110 Software 455120 Misc Computer Hardware Total COMPUTER & PRINTING SUPPLIES Total OTHER PURCHASED SERVICES (CHANGE TO OFF OPERATING SUPPLIES AGRICULTURE SUPPLIES 461040 Other Agriculture Chemicals Total AGRICULTURE SUPPLIES CHEMICAL & LAB SUPPLIES 463200 Other Chemicals & Supplies Total CHEMICAL & LAB SUPPLIES Page: 5 Balance % Used --------- ------ --------- ------------ ------------ ------------------------ ------ 117750.00 131018.09 131018.09-13268.09 111.27 859.00 610.79 610.79 248.21 71.10 642.00 642.00 1821.00 2000.00 2000.00-179.00 109.83 ------------------------ ------------------------------------ ------ 3322.00 2610.79 2610.79 711.21 78.59 1870.00 2036.00 2036.00 -166.00 108.88 ------------------------ 1870.00 ------------ 2036.00 ------------ 2036.00 ------------ -166.00 ------ 108.88 91.00 91.00 -91.00 500.00 500.00 ------ ------------ ------------ 500.00 ------------ 91.00 ------------ 91.00 ------------ 409.00 18.20 ------ ------------------------ 5692.00 ------------ 4737.79 ------------ 4737.79 ------------ 954.21 83.24 364.00 424.41 424.41 -60.41 116.60 ------------ ------------ 364.00 ------------ 424.41 ------------ 424.41 ------------ -60.41 ------ 116.60 199.98 199.98 -199.98 ------ ------------------------ ------------ 199.98 ------------ 199.98 ------------ -199.98 E%PE: 07.13.09 11:42:09 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance ------------------------•------- ------------------------ ------------ ----------------------------------- 1600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) FUELS A LUBRICANTS 465020 Gasoline 465030 Diesel Fuel 465060 Lubricants Total FUELS 6 LUBRICANTS REPAIR 6 MAINTENANCE SUPPLIES 466020 Lumber/Hardware 466030 Paint Supplies 466040 Plumbing Supplies 466050 Electrical Supplies 466060 Other Construction Supplies 466070 Other Maintenance Supplies Total REPAIR 6 MAINTENANCE SUPPLIES EQUIPMENT REPAIR 6 MAINTENANCE SUPPLIES 467020 Equipment Repair 6 Maintenance S 467160 Other Vehicle Repair 6 Maintenan Total EQUIPMENT REPAIR 6 MAINTENANCE SUPPLI SURFACING MATERIALS 460020 Concrete 468030 Asphalt 468050 Sand Total SURFACING MATERIALS OTHER SUPPLIES 6 EQUIPMENT 469040 Traffic Control Improvement Supp 469190 Minor Equipment 469200 Tools 469210 First Aid/Safety Supplies 469260 Fire Ext 6 Refills 469320 Miscellaneous Supplies 101.00 ------------ 101.00 133.52 133.52 373.88 373.88 ------------------ 507.40 507.40 27.01 27.01 23.00 6.00 349.00 163.82 163.82 838.00 589.00 125.02 115.02 ------- ------------ ------------ 1805.00 315.85 315.85 650.00 73.00 723.00 153.00 600.00 54.00 ------------ 807.00 106.00 888.00 57.00 111.00 124.40 124.40 ------ ------------ 124.40 124.40 129.65 129.65 58.35 58.35 ------------------ 188.00 188.00 330.00 330.00 99.00 99.00 104.88 104.88 78.50 78.50 451.65 451.65 Page: 6 Balance 4 Used --------- ------ -133.52 -373.88 101.00 ----------------------- ------ -406.40 502.38 -27.01 23.00 6.00 185.18 46.94 838.00 463.98 21.23 ------- ------ 1489.15 17.50 525.60 19.14 73.00 -------- ------ 598.60 17.21 153.00 470.35 21.61 -4.35 108.06 619.00 23.30 -224.00 311.32 789.00 11.15 -104.88 57.00 32.50 70.72 -451.65 EXPE: 07.13.09 11:42:09 Page: 7 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance I Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) OTHER SUPPLIES & EQUIPMENT (CONTINUED) 469360 Food and Beverages Total OTHER SUPPLIES & EQUIPMENT Total OPERATING SUPPLIES IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements Total IMPROVEMENTS OTHER THAN BUILDING OTHER FINANCIAL USES 490150 Operating Subsidy 490160 Misc Transfers Out 490190 Interfund Loan Total OTHER FINANCIAL USES Total Airport Operations Total Airport 85.53 85.53 -85.53 ------ ------------ ------------ 1162.00 ------------ 1149.56 ------------ 1149.56 ------------ 12.44 ------------ 98.93 ------ ------------ ------------ 4962.00 ------------ 2909.60 ------------ 2909.60 2052.40 58.64 70390.00 8114.00 8114.00 62276.00 11.53 - ------------ ------------ 70390.00 ------------ 8114.00 ------------ 8114.00 ------------ 62276.00 11.53 8359.00 8358.96 8358.96 .04 100.00 28486.25 28486.25 -28486.25 56426.00 23224.89 23224.89 33201.11 --------- 41.16 ------ ------------------------ 64785.00 ------------ 60070.10 ------------ 60070.10 -- 4714.90 ------------ 92.72 ------ ------------ ------------ 439120.00 ------------ 340527.65 ------------ 340527.65 99592.35 ------------ 77.55 ------ ------------ ------------ 439120.00 ------------ 340527.65 ------------ 340527.65 98592.35 77.55 EEPE: 07.13.09 11:42:09 Account --------------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) "' GRAND TOTAL *** Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Appropriated Expenditures Expenditures ------------------ ------------ ------------ Page: 8 Encumbrance Balance 4 Used ------------ ------------ ------ ------------------------ ------------------------ ------------ ------ 439120.00 340527.65 340527.65 98592.35 77.55 TRID: 07.13.09 11:42:43 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Report# Source Description Debit ----------- ---------- ------------ ------------------------------------------- ------------ 7600 Airport 560100 Airport Operations 412000 Perm Part Time 06.05.09 Old Sys 090603010012 491337\CIC PAYROLL RECAP\PAYROLL 05 1141.80 06.19.09 Old Sys 090617010011 491610\CIC PAYROLL RECAP\PAYROLL 19 1141.80 Total Perm Part Time 421100 Health Insurance 06.08.09 Journal Total Health Insurance 421200 Dental Insurance 06.08.09 Journal 2283.60 090616114015 007727 JUN HEALTH INSURANCE\CIC HEALTH INS 285.62 285.62 Page: 1 Credit 090616114015 007726 JUN DENTAL INSURANCE\CIC DENTAL INS 17.70 ------------ ------------ Total Dental Insurance 17.70 421400 Disability Insurance 06.16.09 New Vouch 090617030014 06725812 Check:647070\MADISON NATIONAL LIFE Total Disability Insurance 422100 FICA 06.05.09 Old Sys 090603010012 06.19.09 Old Sys 090617010011 Total FICA 423100 IPERS 06.05.09 Old Sys 090603010012 06.19.09 Old Sys 090617010011 6050599\FICA\CITY CONTRIBUTION 6190599\FICA\CITY CONTRIBUTION 6053599\IPERS\CITY CONTRIBUTION 6190599\IPERS\CITY CONTRIBUTION Total IPERS 432080 Other Professional Services 06.16.09 New Vouch 090617030014 06725887 Check:647048\JBT AIR INC IOW\JUNK 2 Total Other Professional Services 14.10 ------------------------ 14.10 83.48 83.48 ------------------------ 166.96 72.50 72.50 --------------- 145.00 500.00 ------------ ------------ 500.00 TRID: 07.13.09 11:42:43 Page: 2 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------------------------------------------------- ------------ ------------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 435060 Legal Publications 06.17.09 New Vouch 090618030213 06726110 Check:647040\IOWA CITY PRESS CITIZE 12.18 ------------ ------------ Total Legal Publications 12.18 436030 Transportation 06.10.09 New Vouch 090611030034 06725704 Check:646838\GARDINIER, MINNETTA\TR 136.40 ------------ ------------ Total Transportation 136.40 436080 Meals 06.10.09 New Vouch 090611030034 06725704 Check:646838\GARDINIBR, MINNBTTA\TR 55.00 Total Meals 437020 Fire 6 Casualty Insurance 06.09.09 New Vouch 090610030024 06725535 Check:646870\PBTROLBUM MARKETERS MA 06.09.09 New Vouch 090610030024 06725547 Check:646882\SELECTIVE INSURANCE\FL Total Fire 6 Casualty Insurance 438010 Stormwater Utility Charges 06.17.09 Journal 090622162749 007736 057-095-03\STORMWTR\6.17.09 Bill Da Total Stormwater Utility Charges 438030 Electricity 06.17.09 New Vouch 06.17.09 New Vouch 06.24.09 New Vouch Total Electricity 438070 Heating Fuel/Gas 06.17.09 New Vouch 06.17.09 New Vouch 06.24.09 New Vouch 06.24.09 New Vouch 090618030213 06726144 Check:647076\MIDAMBRICAN BNBRGY\BLB 090618030213 06726147 Check:647076\MIDAMERICAN BNBRGY\BLB 090625030045 06726549 Check:647349\MIDAMBRICAN BNBRGY\BLE 090618030213 06726145 Check:647076\MIDAMBRICAN ENERGY\GAS 090618030213 06726146 Check:647076\MIDAMBRICAN ENBRGY\GAS 090625030045 06726550 Check:647349\MIDAMBRICAN ENERGY\GAS 090625030045 06726567 Check:647347\MIDAMBRICAN ENERGY\GAS 55.00 750.00 4167.00 ------------ ------------ 4917.00 591.96 ------------------------ 591.96 744.78 53.71 82.12 ----------------- ------ 880.61 42.11 23.17 10.00 15.35 TRID: 07,13.09 11:42:43 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Page: 3 Trans Date Trans Type Report@ Source Description Debit Credit ----------- ---------- ---------------------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations )CONTINUED) 438070 Heating Fuel/Gas )CONTINUED) Total Heating Fuel/Gas 438080 Sewer Utility Charge 06.17.09 Journal 06.17.09 Journal 06,17.09 Journal 06.17.09 Journal Total Sewer Utility Charge 438090 Water Utility Charge 06.17.09 Journal 06.17.09 Journal 06.17.09 Journal 06.17.09 Journal 06.17.09 Journal 090622162749 007736 057-115-00\SEWER\6.17.09 Bill Date 090622162749 007736 057-117-00\SEWER\6.17.09 Bill Date 090622162749 007736 057-118-03\SEWER\6.17.09 Bill Date 090622162749 007736 057-120-00\SEWER\6.17.09 Bill Date 090622162749 007736 057-095-03\WATER\6.17.09 Bill Date 090622162749 007736 057-115-00\WATER\6.17.09 Bill Date 090622162749 007736 057-117-00\WATER\6.17.09 Bill Date 090622162749 007736 057-118-03\WATER\6.17.09 Bill Date 090622162749 007736 057-120-00\WATER\6.17.09 Bill Date Total Water Utility Charge 438100 Refuse Collection Charges 06.17.09 New Vouch 090618030213 06726109 Check:647167\ALLIED WASTE SERVICES\ 06.17.09 New Vouch 090618030213 06726109 Check:647167\ALLIED WASTE SERVICES\ Total Refuse Collection Charges 438110 Local Phone Service 06.22.09 New Vouch 090623030012 06726265 Check:647492\IOWA TELECOM COMMUNCIA Total Local Phone Service 438120 Long Distance Service 06.01.09 Ph Lon Dst 090701160037 00006019 JUN LONG DIST CHGBE Total Long Distance Service ------------------------ 90.63 8.15 48.05 24.11 28.70 109.01 8.35 16.47 36.31 18.37 21.81 ------------ ------------ 101.31 TRID: 07.13.09 11:42:43 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Page: 4 Trans Date Trans Type Reportl Source Description Debit Credit ----------- ---------------------- ------------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 442010 Other Building Repair & Maintenance Ser 06.19.09 New Vouch 090622030019 06726188 Check:647360\OVERHEAD DOOR COMPANY 137.50 ------------ ------------ Total Other Building Repair & Maintenance Servi 137.50 442070 Bldg Pest Control Services 06.22.09 New Vouch 090623030012 06726264 Check:647318\HAWIEYE PEST CONTROL I 33.95 Total Bldg Pest Control Services 4430BO Other Equipment Repair & Maintenance Se 06.30.09 Journal 090706183406 007750 HYDRANT MAINT FY09\CIC INTRA CITY C Total Other equipment Repair & Maintenance Sery 445030 Nursery Service -Lawn and Plant Care 06.16.09 New Vouch 090617030014 06725886 Check:647048\JET AIR INC ION\JUNR 2 Total Nursery Service -Lawn and Plant Care 445110 Testing Services 06.16.09 New Vouch 090617030014 06725872 Check:647111\TANENOLOGY INC\TEST ON Total Testing Services 445140 Outside Printing 06.08.09 New Vouch 090609030010 06725281 Check:646736\PIP PRINTING\AIRPORT 06.16.09 New Vouch 090617030014 06725867 Check:647087\PIP PRINTING\AIRPORT Total Outside Printing 446140 ITS -Computer Replacement Chargeback 06.01.09 IT Repl 090603141219 00006025 JUN ITS REPL CHGBCE Total ITS -Computer Replacement Chargeback 446160 ITS-Network/Internet Chargeback 06.01.09 IT Int/Nwk 090603105714 00006031 JUN ITS NETW/INTRNET Total ITS-Network/Internet Chargeback ------------ ------------ 33.95 100.00 ------------ ------------ 100.00 4500.00 ------------------------ 4500.00 357.60 ------------ ------------ 357.60 58.00 58.00 ------------ ------------ 116.00 52.78 ------------------------ 52.78 30.00 ------------ ------------ 30.00 TRID: 07.13.09 11:42:43 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Page: 5 Trans Date Trans Type Report@ Source Description Debit Credit ---------------------------------------------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 446200 Photocopying Chargeback 06.30.09 Journal 090629164712 007745 MAY PHOTOCOPY\CIC CENTRAL SERVICE C 20.64 Total Photocopying Chargeback 446220 Phone Service Chargeback 06.17.09 Qwest Chrg 090617124828 00006032 Jun Qwest Charges Total Phone Service Chargeback 446280 Telecom Move/Add/Change Chargeback 06.30.09 IT Ann Sup 090707102316 00006024 JUN PHONE SERV Total Telecom Move/Add/Change Chargeback 446300 Phone equipment/Line Chargeback 06.01.09 Ph Equipmt 090701160037 0000601E JUN PHON EQUIP CHGBE Total Phone Equipment/Line Chargeback 446320 Mail Chargeback 06.01.09 Mail 090603125447 00600051 MAY POSTAL CHARGES Total Mail Chargeback 446350 City Vehicle Replacement Chargeback 06.30.09 RQ Repl 090707130029 00006006 JUN REPLACEMENT COST Total City Vehicle Replacement Chargeback 446370 Fuel Chargeback 06.30.09 EQ Div 090707130029 00006008 JUN DIVISION FURL Total Fuel Chargeback 449360 Interest Expense 06.30.09 Journal 06.30.09 Journal 06.30.09 Journal 06.30.09 Journal 20.64 46.14 ------------ ------------ 48.14 36.52 ------------------------ 36.52 85.00 ------------------------ 85.00 15.79 ------------------------ 15.79 1161.30 ------------------- 1161.30 425.85 425.85 ------------ ------------ 425.85 090616114015 007733 Corp Hangar Loan Int\June Interfund 1904.56 090616114015 007733 Airprt SE Hangar Int\June Interfund 991.02 090616114015 007733 Airprt SW Hangar-Int\June Interfund 929.01 090709164858 007772 Airprt SW Hangar Int\Interfund loan .06 TRID: 07.13.09 11:42:43 Page: 6 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Reportl Source Description Debit Credit ----------- ---------- ------------ ------------------------------------------------------- ------------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 449360 Interest Expense (CONTINUED) 06.30.09 Journal 090709164858 007772 Air Corp Hangar Prin\Interfund loan .04 06.30.09 Journal 090709164858 007772 Airprt SE Hangar Int\Interfund loan .05 ------------ ------------ Total Interest Expense 3824.74 461040 Other Agriculture Chemicals 06.16.09 New Vouch 090617030014 06725888 Check:647048\JET AIR INC IOW\AIRPOR 286.54 ------------ ------------ Total Other Agriculture Chemicals 286.54 466050 Electrical Supplies 06.16.09 New Vouch 090617030014 06725885 Check:647128\VAN METER INDUSTRIAL I 144.29 ------------ ------------ Total Electrical Supplies 144.29 466070 Other Maintenance Supplies 06.23.09 P-Card 090707102742 15300506 MBNARDS IOWA CITY\MICHABL THARP 34.83 06.23.09 P-Card 090707102742 15300507 BEST LOCK\MICHABL THARP ------------ 20.81 ------------ Total Other Maintenance Supplies 55.64 467020 Equipment Repair & Maintenance Supplies 06.19.09 New Vouch 090622030019 06726195 Check:647403\VAN METER INDUSTRIAL I 72.14 06.23.09 P-Card 090707102742 15300505 NAPA AUTO PARTS IOWA C\MICHABL THAR ------------ 52.26 ------------ Total Equipment Repair & Maintenance Supplies 124.40 469200 Tools 06.19.09 New Vouch 090622030019 06726194 Check:647403\VAN METER INDUSTRIAL I ------------ 45.90 ------------ Total Tools 45.90 490150 Operating Subsidy 06.30.09 Journal 090616114015 007731 Econ Dev Coord 101\June Budgeted Tr 696.58 ------------ Total Operating Subsidy 696.58 TRID: 07.13.09 11:42:43 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Page: 7 Trans Date Trans Type Report# Source -------- ----------------------------------- Description ------------ Debit Credit ------------ ----------- 7600 Airport (CONTINUED) ---------- ------------ 560100 Airport Operations (CONTINUED) 490190 Interfund Loan 06.30.09 Journal 090616114015 007733 Corp Hangar Loan Prn\June Interfund 1095.44 06.30.09 Journal 090616114015 007733 Airprt SE Hangar Prn\June Interfund 338.98 06.30.09 Journal 090616114015 007733 Airprt SW Hangar-Prn\June Interfund 501.00 06.30.09 Journal 090709164858 007772 Airprt SW Hangar Prn\Interfund loan .06 06.30.09 Journal 090709164858 007772 Air Corp Hangar Prin\Interfund loan .04 06.30.09 Journal 090709164858 007772 Airprt SE Hangar Prn\Interfund loan .05 Total Interfund Loan ------------------------ 1935.42 .15 ------------ ------------ Total Airport Operations 24725.30 .15 TRID: 07.13.09 11:42:43 Trans Date Trans Type ----------- ---------- - 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) Total Airport Iora City General Ledger Systei Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Report# Source Description Page: S Debit Credit ------------------------ 24725.30 .15 TRID: 07.13.09 11:42:43 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Report# Source Description --------------------- ------------ -------- ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) Debit ------- ------------ Page: 9 Credit ------------------------ +++ GRAND TOTAL +++ 24725.30 .15 ------------------------ ------------ ------------ TRID: 07.13.09 11:42:54 Trans Date Trans Type Iova City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Report# Source Description Page: 1 Debit Credit ----------- 7600 Airport ---------- ------------ -------- ----------------------------------------------- ............ 560100 Airport Operations 382100 Land Rental 06.12.09 Payment 090612093217 00013408 2-7\BELL LARRY 6 SANDRA\MAY 2009 P 96.00 06.12.09 Payment 090612093217 00013408 2-7\BILL LARRY 6 SANDRA\JUNE 2009 300.00 06.25.09 Misc Pymt 090702153837 70-15\ARMY RESERVE\AIRPORT LEASE ------------ 238.93 ------------ Total Land Rental 634.93 382200 Building/Room Rental 06.02.09 Payment 090602101203 00013288 3-15\SCHMEISBR ROSS\JUN 09\HANGAR 204.00 06.02.09 Payment 090602101203 00013290 3-6\OCZENFELS TRANSFER\JDN 09\HANGA 204.00 06.02.09 Payment 090602101203 00013365 3-14\ADVANCHD INFONHERING\PAYNENT 110.00 06.03.09 Payment 090603111644 00013256 2-12\FIRLD HONARD\JDN 09\HANGAR #5 168.00 06.03.09 Payment 090603111644 00013292 1-32\PATTSCEDLL RICRARD\JUN 09\RAN 229.00 06.03.09 Payment 090603111644 00013335 1-34\HERTZ CORPORATION\JDN 09\OFFIC 300.00 06.04.09 Payment 090604093537 00013275 2-8\BULLSIS JONATHAN\JON 09\HANGAR 141.00 06.04.09 Payment 090604093537 00013277 2-7\BOLGARBLLI DAVID\JDN 09\HANGAR 148.00 06.04.09 Payment 090604093537 00013300 2-2\FARRIS GREG\JDN 09\HANGAR 129 148.00 06.05.09 Payment 090605092933 00013011 3-4\LACINA DAVB\MAY 09\HANGAR 157 198.00 06.05.09 Payment 090605092933 00013274 3-10\SCHNELL TOM\JDN 09\HANGAR #62 171.00 06.05.09 Payment 090605092933 00013283 3-6\NASCARI RICE\JDN 09\HANGAR #30 148.00 06.05.09 Payment 090605092933 00013291 3-5\LACINA DAVB\JUN 09\HANGAR 157 198.00 06.08.09 Payment 090608094656 00013318 2-18\OPERATOR PERFORMANCR LAB\JDN 0 1330.00 06.08.09 Payment 090608094656 00013318 2-18\OPERATOR PERFORMANCE LAB\JUN 0 168.00 06.09.09 Payment 090609093208 00013319 2-6\NIBCHERT RONALD\JDN 09\1ANGAR 192.00 06.10.09 Payment 090610092502 00013261 2-2\ROYLE JOHN\JUN 09\HANGAR #33 358.00 06.10.09 Payment 090610092502 00013278 2.11\IOMA CITY FLYING CLUB\JDN 09\H 168.00 06.10.09 Payment 090610092502 00013293 2-6\NE IA PAYS THBRPY ASSOC\JUN 09\ 198.00 06.10.09 Payment 090610092502 00013293 2-6\NH IA PHYS THBRPY ASSOC\JDN 09\ 174.00 06.10.09 Payment 090610092502 00013296 2-16\CBALALEY BEN\JUN 09\HANGAR 11 148.00 06.10.09 Payment 090610092502 00013314 2-3\ROOF ZBITB\JUN 09\RANGAR 132 512.00 06.11.09 Payment 090611091736 00013298 2-5\ZOBROD ROY\JDN 09\HANGAR 120 148.00 06.11.09 Payment 090611091730 00013330 2-7\VRANEI DODGLAS\JUN 09\RANGAR # 141.00 06.12.09 Payment 090612093217 00013362 2-8\ROHR BRIAN\JUR 09\HANGAR 119 148.00 06.15.09 Payment 090615091435 00013279 2-19\HOLLY FORRBST\JOM 09\HANGAR # 148.00 TRID: 07.13.09 11:42:55 Page: 2 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Report# ------------ Source -------- Description Debit ----------------------------------- ------------ Credit ------------ ----------- 7600 Airport (CONTINUED) ---------- 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 06,15.09 Payment 090615091435 00013297 2-13\TRARSE DAVID\JUN 09\HANGAR #4 168.00 06.16.09 Payment 090616094748 00013273 1-16\RANGY CHARLES\JUN 09\HANGAR # 141.00 06.16.09 Payment 090616094748 00013366 1-39\YBLDBR ROY\JUN 09\HANGAR #18 148.00 06.17.09 Payment 090617093752 00013323 2.19\SAPPHIRE VISTAS LLC\JUN 09\HAN 148.00 06.17.09 Payment 090617093752 00013327 3-4\FLANAGAN JAMBS\JUN 09\HANGAR # 168.00 06.17.09 Payment 090617093752 00013329 3-1\ALEEIS PARR INN & SUITES\JUN 09 141.00 06.18.09 Payment 090618085339 00013007 2-2\FULL JERRY\MAY 09\HANGAR #45 204.00 06.19.09 Payment 090619115140 00013254 89-1\MILLER RICHARD\JUN 09\HANGAR 168.00 06.19.09 Payment 090619115140 00013289 89-5\FISHBAUGH JUSTIN\JDN 09\HANGA 174.00 06.19.09 Payment 090619115140 00013294 89-6\ALLRNDER PATRICR\JUN 09\HANGA 168.00 06.19.09 Payment 090619115140 00013301 89-7\BDMONDS TERRY\JUN 09\HANGAR # 313.00 06.19.09 Payment 090619115140 00013310 89-11\SQUADRONS UP\JUN 09\HANGAR #5 168.00 06.19.09 Payment 090619115140 00013313 89-12\GURNBTT DON\JUN 09\HANGAR #3 310.00 06.19.09 Payment 090619115140 00013322 89-14\SINGLETARY ROBERT\JDN 09\HAN 141.00 06.19.09 Payment 090619115140 00013339 89-16\SWANSON NAOMI\JUN 09\HANGER 141.00 06.19.09 Payment 090619115140 00013360 89-19\MEADS JAMBS N\JDN 09\HANGAR 148.00 06.23.09 Payment 090623093306 00013315 2-23\JET AIR INC\JUN 09\BUILDINGS D 3926.00 06.23.09 Payment 090623093306 00013333 2-22\JET AIR\JDN 09\HANGAR #60 174.00 06.26.09 Payment 090626093911 00013276 2-7\HALL ROBERT\JUN 09\HANGAR #6 141.00 06.26.09 Payment 090626093911 00013276 2-7\HALL ROBRRT\JUN 09\HANGAR #12 ------------ 148.00 ---- ------- Total Building/Room Rental 13441.00 384200 Vending Machine Comm 06.19.09 Misc Pymt 090619094841 2-6\AMRRICAN BOTTLING\VENDING COM14I ------------ 10.80 ------------ Total Vending Machine Comm 10.80 384900 Other Commissions 06.19.09 Misc Pymt 090619094841 2-5\NEWTON HOME OIL COMP\GAS COMMIS ------------ 3777.60 ------------ Total Other Commissions 3777.60 TRID: 07.13.09 11:42:55 Page: 3 Iowa City General Ledger Systea Revenues Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------------------------------------------------- ------------ ------------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 393120 General Levy 06.30.09 Journal 090616114015 007731 Airport Prop Tx Supp\June Budgeted 10833.33 ------------ ------------ Total General Levy 10833.33 ------------ ------------ Total Airport Operations 28697.66 TRID: 07.13.09 11:42:55 Page: 4 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ---------------------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) ------------ ------------ Total Airport 28697.66 TRID: 07.13.09 11:42:55 Trans Date Trans Type ----------- ---------- 7600 Airport (CONTINDRD) 560100 Airport Operations )CONTINORD) t** GRAND TOTAL Ott Iova City General Ledger Systes Revenues Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Reports Source Description - -------- -------- ----------------------- Page: 5 Debit Credit -------- ............ ------------ ------------ ------------------------ ------------------------ PKG_DETL: 07.13.09 11:44 Page: 1 2010 BUDGET DETAIL IN, SP1, TRO; SC 0,800, 600,0; PA 200,30, EA 600,65; GROUP: 560100 Airport Operations PACKAGE: Base Package PRIORITY: Account Amount Notes ---------------------------------------- ------------------------------------------------------------------------------------- ESTIMATED REVENUES Account Amount Notes ---------------------------------------- ------------ ----------------------------------- --------- 7600 560100 381100 Int on Investments -2,500 Due to land sale balance from Commerce Park. 7600 560100 382100 Land Rental-39,000 Last year had double farm payments. 7600 560100 382200 Building/Room Rental-229,000 Hangar Rentals & future UI expanded income. 7600 560100 384200 Vending Machine Comm -175 7600 560100 384900 Other Commissions-21,127 Total Transfers-291,802 7600 560100 393120 General Levy-120,000 ------------ TOTAL REVENUES:-411,802 Account 7600 560100 411000 Perm Full Time 7600 560100 412000 Perm Part Time 7600 560100 413000 Temporary Employees 7600 560100 414100 Overtime Wages 7600 560100 414500 Longevity Pay Total Salaries & Wages 7600 560100 421100 Health Insurance 7600 560100 421200 Dental Insurance 7600 560100 421300 Life Insurance 7600 560100 421400 Disability Insurance 7600 560100 421500 Unemployment Comp 7600 560100 422100 FICA 7600 560100 423100 IPERS 7600 560100 424500 Monthly Cell/PCS Total Employee Benefits 7600 560100 431020 Court Costs & Svcs 7600 560100 432020 Annual Audit BUDGETED EXPENDITURES Amount ------------ ------------------ 39,802 31,578 10,000 2,062 1,050 ------------ 84,492 8,367 525 240 554 1,991 6,487 5, 639 300 24,103 180 527 Notes PKG DETL: 07.13-09 11:44 Page: 2 IN, SP1, TRO; SC Account 0,800, 600,0; GROUP: PACKAGE: PRIORITY: Amount 2010 BUDGET DETAIL PA 200,30, EA 600,65; 560100 Airport Operations Base Package Notes ---------------------------------------- ------------ --------------------------------------------------------- 7600 560100 432070 Management Services 9,000 See Form C. 7600 560100 435057 Couriers 7600 560100 435060 Legal Publications 7600 560100 436030 Transportation 7600 560100 436050 Registration 7600 560100 436060 Lodging 7600 560100 436080 Meals 7600 560100 437010 Comp Liability Ins 7600 560100 437020 Fire & Casualty Ins 7600 560100 437030 Worker's Comp Ins 7600 560100 437041 Bonding & Other Insu 7600 560100 437200 Loss Reserve Payment 7600 560100 438010 Stormwater Charges 7600 560100 439030 Electricity 7600 560100 438070 Heating Fuel/Gas 7600 560100 438080 Sewer Utility Charge 7600 560100 438090 Water Utility Charge 7600 560100 438100 Refuse Coll Charges 7600 560100 438110 Local Phone Service 7600 560100 438120 Long Distance Servic Total Prof/Technical Svcs 7600 560100 442010 Other Bldg R & M Svc 7600 560100 442020 Structure R & M Svcs 7600 560100 442030 Heating Equip R & M 7600 560100 442040 Cooling Equip R & M 7600 560100 442060 Elect & Plumb R & M 7600 560100 442070 Bldg Pest Control 7600 560100 443080 Oth Equip R&M Svcs 7600 560100 445030 Nursery -Lawn & Plant 7600 560100 445110 Testing Services 7600 560100 445140 Outside Printing 7600 560100 446100 City Attorney Chgbk 7600 560100 446130 ITS-PC/Periph Supp 7600 560100 446140 ITS-Cmptr Repl Chgbk 7600 560100 446160 ITS-NN/Internet Chg 7600 560100 446200 Photocopying Chgbk 7600 560100 446220 Phone Svc Chgbk 7600 560100 446300 Phone Equip/Line Chg 28 44 900 See Form D. 400 See Form D. 500 See Form D. 150 See Form D. 7,040 12,067 86 936 5,000 7,104 15,074 11,581 1,925 1,736 1,157 454 55 75,944 8,951 4,000 Same as FY09 500 Same as FY09. 500 500 Same as FY09. 437 3,317 300 Plant Care / replacements. 1,280 166 6,360 400 633 360 512 618 1, 014 PKG_DETL: 07.13.09 11:44 Page: 3 2010 BUDGET DETAIL IN, SP1, TRO; SC 0,800, 600,0; PA 200,30, EA 600,65; GROUP: 560100 Airport Operations PACKAGE: Base Package PRIORITY: Account Amount Notes ---------------------------------------- ------------ ------------------------------------------------------------------------- 7600 560100 446320 Mail Chgbk 495 7600 560100 446350 City Vehicle Repl 14,176 Punccased new mower deck. 7600 560100 446360 City Vehicle Rental 7600 560100 446370 Fuel Chgbk 7600 560100 446380 Vehicle Rep & Maint 7600 560100 446390 Auto Body Repair 7600 560100 449060 Dues & Memberships 7600 560100 449120 Equipment Rental 7600 560100 449140 Tools Rental 7600 560100 449360 Interest Expense Total Repair & Maintenance 7600 560100 452010 Office Supplies 7600 560100 452030 Minor Off Equip/Furn 7600 560100 452040 Sanita & Indust Supp 7600 560100 454010 Reference Mat & Book 7600 560100 454020 Subscriptions 7600 560100 455120 Misc Comp Hardware Total Office/EDP Supplies 7600 560100 461030 Plants & Trees 7600 560100 461040 Other Ag Chemicals 7600 560100 463200 Other Chem & Supplie 7600 560100 465060 Lubricants 7600 560100 466030 Paint Supplies 7600 560100 466040 Plumbing Supplies 7600 560100 466050 Electrical Supplies 7600 560100 466060 Other Construc Suppl 7600 560100 466070 Other Maint Supplies 7600 560100 467020 Equip R & M Supplies 7600 560100 467160 Oth Veh R&M Supplies 7600 560100 468020 Concrete 7600 560100 468030 Asphalt 7600 560100 468050 Sand 7600 560100 469190 Minor Equipment 7600 560100 469260 Fire Ext & Refills 7600 560100 469320 Misc Supplies Total Operating/Maint Supp 644 8,506 4,017 109 625 No explanation provided. 213 250 Same as FY09. 58,997 ------------ 117,880 850 Same as FY09. 500 No explanation provided. 533 17 2,007 419 ------------ 4,326 88 364 Same as FY09. 327 138 25 25 742 288 288 149 376 243 273 50 674 108 484 ------------ 4,642 7600 560100 473010 Contracted Improve 20,000 PKG_DETL: 07.13.09 11:44 Page: 4 2010 BUDGET DETAIL IN, SP1, TRO; SC 0,800, 600,0; PA 200,30, EA 600,65; GROUP: 560100 Airport Operations PACKAGE: Base Package PRIORITY: Account Amount ---------------------------------------- ------ ---------------- 7600 560100 473020 Mon -Contracted Impro 7,500 ------------ Total Capital Outlay 27,500 7600 560100 490150 Operating Subsidy 9,781 7600 560100 490190 IntrFund Loan 58,723 Total Other Financial Uses 68,504 ------------ TOTAL EXPENDITURES: 407,391 PERSONNEL Notes ------------------------------------ Seq Position Name ---------------------------------------- FTE ----- Salary ---------- Fringes ---------- --- 620 ---------------------------------------- MWI - AIRPORT EAEFUNG, GRRALD T 1.00 39,802 12,744 621 AIRPORT OPERATIONS SPECIALIST TEARP, MICHAEL .75 31,578 8,671 751 TEMPORARY EMPLOYEE TEMP AIRPORT 560100 10,000 1,430 753 OVERTIME OVERTIME AIRPORT 560100 2,062 316 TOTAL ALL EMPLOYERS: ----- 1.75 ---------- 83,442 ---------- 23,161 PKG DETL: 07.13.09 11:44 Page: 5 2010 BUDGET DETAIL IN, SP1, TRO; SC 0,800, 600,0; PA 200,30, EA 600,65; GROUP: 560100 Airport Operations PACKAGE: Base Package PRIORITY: Seq Description --- ---------------------- 2 Runway Crack Sealing 1 Fencing CAPITAL OUTLAY Budget -------------------------- 20, 000 7,500 Notes ------------------------------------ BUDGET TRANSFERS Seq Account Transfer Notes --------------------------------------------- ----------------------------------------------- --------------- 9 7600 560100 393120 000-120,000 Operating Transfers - Support to GF, JCCOG, Library, Sr Ctr Cable Transfers to General Fund include $100,000 operating subsidy (separate from Admin Servs charge) plus the Library AV support. 5 7600 560100 490150 000 9,781 FTS Splits - Between Funds Budgeted in General Fund for Employee Benefits Econ Dev Coord, funding split wJ Enterprise Funds: 50/20/20/10 - GF/WWIWtr/Airport Right -of -Way Employee, funded by RUT: MWII Forestry - Brian Tack 1 7600 560100 490190 000 34,553 Loan Repayments - SCBA & Sr Ctr Sprnkler end in FY10 1 7600 560100 490190 000 4,232 Loan Repayments - SCBA & Sr Ctr Sprnkler end in FY10 1 7600 560100 490190 000 13,681 Loan Repayments - SCBA & Sr Ctr Sprnkler end in FY10 1 7600 560100 490190 000 6,257 Loan Repayments - SCBA & Sr Ctr Sprnkler end in FY10 Department Manager Signature Date