Loading...
HomeMy WebLinkAbout07-16-2009 Airport Commission • IOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JULY 16, 2009-6:00P.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. Adjoum 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 Gardiner 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. 1 • Iowa City Airport Commission June 18, 2009 Page 2 of 5 i. Consider a Motion Recommending Sale of Lot#1 -Koran moved to recommend that the City Council accept the full-price purchase offer on Lot#1; 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 Farms 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. FAA/IDOT 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 2 Iowa City Airport Commission June 18, 2009 Page 3 of 5 see about the funding timeframes. 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 FY 11 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 3 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. 4 Iowa City Airport Commission • June 18,2009 Page 5of5 Airport Commission ATTENDANCE RECORD YEAR 2009 (Meeting Dates) TERM 1/8 2/5 2/12 3/12 4/2 4/14 4/16 5/6 5/21 6/18 NAME EXP. Greg Farris 3/1/13 X X X X X X X X X X Minnetta 3/1/15 — — — X X X X O/E O/E O/E Gardinier 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 KEY: X = Present O = Absent O/E= Absent/Excused NM= No meeting — = Nota Member 5 Prepared by: Michael Tharp,Operations Specialist, 1801 S. Riverside Dr,Iowa City IA 52246 319-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 , 2009. CHAIRPERSON Approved by ATTEST: SECRETARY City Attorney's Office It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent Farris Gardinier Horan Rettig Staley MINUTES Draft Iowa City Airport Commission July 10,2009 Iowa City Airport Terminal—8:00 AM Members Present: Greg Farris, Howard Horan, John Staley, Janelle Rettig, Minnetta Gardinier 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-30. 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. Gardinier 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 funding 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 re-do 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, Gardinier seconded. Motion carried 5-0. The meeting adjourned at 9:00 A.M. CHAIRPERSON DATE Iowa City Airport Commission. July 10, 2009 Page 3 of 3 Airport Commission ATTENDANCE RECORD YEAR 2009 (Meeting Dates) TERM 1/8 2/5 2/12 3/12 4/2 4/14 4/16 5/6 5/21 6/18 NAME EXP. Greg Farris 3/1/13 X X X X X X X X X X Minnetta 3/1/15 — — — X X X X O/E O/E O/E Gardinier 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 TERM 1/8 2/5 2/12 3/12 4/2 4/14 4/16 5/6 5/21 6/18 NAME EXP. KEY: X = Present O = Absent O/E= Absent/Excused NM= No meeting — = Nota Member Prepared by: Michael Tharp,Operations Specialist, 1801 S.Riverside Dr, Iowa City IA 52246 319-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 , 2009. CHAIRPERSON Approved by ATTEST: SECRETARY City Attorney's Office It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent Farris Gardinier Horan Rettig Staley r CITY OF IOWA CITY • ' - 'I 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 o1 1 U.S. Bureau of Labor Statistics Databases, Tables & Calculators by Subject CPI Inflation Calculator Inflation Calculator $ 100.00 in 2008 has the same buying power as $99.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 20212-0001 www,bls.gov I Telephone: (202) 691-5200 I Do you have a Data question? http://data.b1s.gov/cgi-bin/print.pl/data/inflation_calculator.htm 7/7/2009 Historical Hangar Rates 2004/05 2005/06 2006/07 2007/08 2008/09 2009/10 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 C #21-22 $ 132.00 $ 132.00 $ 132.00 $ 144.00 $ 148.00 $ 148.00 Building I #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 T-Han•ar Income/Expense Re'ort IBuilding 1 Type I Current Income/Month Building Expenses/Month Income Net Gain/loss BuildingA T-hangar $ 1,410.00 BuildingA $ 102.25 $ 1,307.75 Building B T-hangar $ 1,480.00 Building B $ 196.51 $ 1,283.49 Building C T-hangar $ 1,480.00 Building C $ 328.72 $ 1,151.28 Building I T-hangar $ 1,716.00 Building I $ 2,401.88 $ (685.88) Building J T-hangar $ 1,752.00 Building J $ 572.49 $ 1,179.51 Building K T-hangar $ 1,826.00 Building K $ 2,849.66 $ (1,023.66) TOTALS $ 9,664.00 TOTALS $ 6,451.52 $ 3,212.48 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) Deleted:20o8 Deleted:2009 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: 1. 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 writing 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,rC;09, and shall end on the last {Deleted:2008 day of the month of September,2CO. 1Deletad:2009 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. 2 Home Built Fee. Tenant acknowledges the following: If the Tenant uses the Hangar Space to construct an"amateur built/home 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 www.eaa.orq.) 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. c. No commercial activity of any kind shall be conducted by Tenant in, from or around the Hangar Space without prior written approval of the Airport Commission as specified in paragraph 25. d. Tenant may perform maintenance, including painting, on aircraft described in Deleted:Tenant individually may Paragraph 1 in accordance with Federal Aviation Regulations (FARs). Tenant perform maintenance,including painting,on the arcr-aft described in will not perform maintenance, including painting, in any other hangar or Paragraph 1,as permitted by the anywhere on the airport. Tenant shall take steps to ensure maintenance work FAA,but shall not allow any other will not damage the Hangar Space, Airport or adjacent Hangar Space where the Person to do so in the Hangar Space. Tenant shall rat perform any other work is performed and will not emit offensive odors. maintenance,including painting,on any other Aircraft in the Hangar e. Tenant shall be responsible and liable for the conduct of its employees and Space prior where approon theval Airport, without prior written approval of the invitees, and of those doing business with it, in and around the Hangar Space. Airport. Tenant shall take steps to Tenant shall keep the Hangar Space clean and free of debris at all times. ensure that the performance of such maintenance work will not damage the Hangar Space or the Airport f. In utilizing the Hangar Space during the term of this Lease,Tenant shall comply where the work is performed and will with all applicable ordinances, rules, and regulations established by any federal, not emit offensive odors. 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 3 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. 6; SMOKEFREE AIR ACT Lease Provision Formatted:Font: 11 pt,Bold,Check spelling and grammar a. Jowa Smokefree Air Act, Smoking is prohibited throughout the Iowa City Municipa ` F0m, � ed cabs: 0.5", Airport, including the Hangar Space, \ Left r 1 Left+ 1.s",Lent Formatted:Font:11 pt,Check spelling and grammar A� Deleted: 7. Rights and Obligations of Tenant Formatted:Font: 11 pt,Check a. Tenant shall have at all times the right of ingress to and egress from the Hangar spelling and grammar Space, except as provided in Paragraph 13. To ensure this right, the Formatted:Justified,Indent: Commission shall make all reasonable efforts to keep adjacent areas to the Hanging: 0.33•,Outline numbered+ Level: i+Numbering Style:a,b,c, Hangar Space free and clear of all hazards and obstructions, natural or ...+Start at: 1+Alignment:Left+ manmade. Aligned at: 0.58"+Tab after: 0.83" +Indent at: 0.83",Tabs: 0.5",Left + 1",Left+ 1.5",Left b. Tenant shall be responsible to maintain the interior of the Hangar Space to > include services, maintainingall interior lights, cleaningof stoppages in Formatted:Font: pt, janitorial gunderline,,Check s spell ling and plumbing fixtures and drain lines, cleaning of snow within two (2) feet of the . i grammar apron adjoining the Hangar Space, disposing of any debris or waste materials, Formatted:Font:11 pt,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 Font:11 pt,Not Bold, completed. If such maintenance is not completed within a reasonable time Check spelling 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 Sponsor's 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 4 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 furfures 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 11c below,no"hazardous substance,"as defined in Iowa Code section 4556.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.legis.state.ia.us/IACODE.The. U.S. Code can be found online at www.findlaw.com/casecodefuscodes/index.html Federal regulations can be found online at http://www.access.gpo.gov/nava/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 non-"hazardous 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. 5 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 1/2 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. 16. Insurance. a. 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 6 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 term 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 event the 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 acts 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, riot, 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 profds 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 • 7 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, classifying, 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/she/it 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 8 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. 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 9 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. 27. 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 addition 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. 10 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: Date: TENANT: By: Title: Date: Approved: City Attorney's Office T Hangar Lease 9-07 Monthly Expense Report - June '09 Check Requests During Month Approved Airport Funds CIP Funds Check Requests 6/1/2009 Metro Pavers(Runway 7-25 Paving&Lighting Retainage) $67,045.60 6/1/2009 Septagon Constructino(Hangar H Expand) $105,893.74 6/1/2009 Pip Printing(May Newsletter) $58.00 6/1/2009 PMMIC(Underground Fuel Tank Insurance) $750.00 6/8/2009 Tanknology(Annual Line/Leak Test for Underground Fuel Tank) $357.60 6/8/2009 Van Meter Industrial(Lights for"X's") _ $144.29 6/8/2009 AECOM(Hangar H Expansion) $907.59 6/8/2009 Pip Printing(May Newsletter 2nd batch) $58.00 6/82009 Jet Air(Maintenance Contract) $5,286.54 6/16/2009 Overhead Door(hangar repair#21) $137.50 6/16/2009 Van Meter Industrial(Lights Bulbs-Stock) $262.33 6/18/2009 AECOM(Runway 12-30 Reconstruction-ARRA) $28,600.00 6/18/2009 AECOM(Runway 7-25&12-30) $17,430.00 6/18/2009 AECOM(South Airfield Study) $593.28 6/24/2009 Van Meter(Terminal Bldg Bulbs) $126.38 6/23/2009 Fastenal Company(reflective marker tape) $36.54 6/23/2009 Fed Ex $49.54 6/30/2009 Metro Pavers(Runway 7-25 Reconstruct-Prefinal) $13,501.56 6/30/2009 Metro Pavers(Runway 12-30 ARRA) $194,549.10 8/30/2009 Metro Pavers(Runway 7-25 Reconstruct-Add Alternate Prefinal) $2,970.95 6/30/2009 Septagon Constructino(Hangar H Expand) $81,537.80 $1,380,788.17 Airport Operating Expenses $7,266.72 City CIP Fund Expenses $513,029.62 Total Expenses $520,296.34 Capital Projects Construction Contracts Project Bid Amount Paid During Month Paid During FiscalYear Paid To Date %Paid South Economic Study-ALP Update $15,000.00 $593.28 $1,885.23 $14,319.35 95.5 South T-Hangar Taxilane $140,794.15 $98,935.64 $98,935.64 70.3 United Hangar $103,060.00 $94,562.69 $94,562.69 91.8 Runway 7-25 Reconstruct and Alternate $1,468,010.83 $16,472.51 $1,364,315.66 $1,364,315.66 92.9 North T-HangarTaxilane Rehab $163,726.00 $153,843.43 $153,843.43 94.0 Runway 7-25&12-30 Reconstruction $1,890,900.50 0.0 Runway 12-30 Reconstruction $1,522,771.00 $194,549.10 $194,549.10 $194,549.10 12.8 Hangar H Expand $350,840.00 $187,431.54 $187,431.54 $187,431.54 53.4 Pending Expenses Total Pending Expenses $0.00 $0.00 REVE: 07.13.09 11:39:46 Page: 1 Iowa City General Ledger System FY 2009 Revenue Reporting For the period 06.01.09 to 06.30.09 Estimated YTD Period Account Revenue Revenue Revenue Remainder % 7600 Airport CONTRIB & DONATIONS 362100 Contrib & Donations 250.00 -250.00 Total CONTRIB & DONATIONS 250.00 -250.00 OTHER MISC REVENUE 369100 Reimb of Expenses 28496.25 -28496.25 369900 Miscellaneous Other Income 200.00 -200.00 Total OTHER MISC REVENUE 28696.25 -28696.25 INTEREST REVENUES 381100 Interest on Investments 1000.00 1596.11 -596.11 159.61 Total INTEREST REVENUES 1000.00 1596.11 -596.11 159.61 RENTS 382100 Land Rental 30700.00 33005.50 634.93 -2305.50 107.51 382200 Building/Room Rental 226000.00 211039.33 13441.00 14960.67 93.38 Total RENTS 256700.00 244044.83 14075.93 12655.17 95.07 ROYALTIES & COMMISSIONS 384200 Vending Machine Comm 168.00 72.00 10.80 96.00 42.86 384900 Other Commissions 20000.00 19236.70 3777.60 763.30 96.18 Total ROYALTIES & COMMISSIONS 20168.00 19308.70 3788.40 859.30 95.74 TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy 130000.00 129999.96 10833.33 .04 100.00 Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES 130000.00 129999.96 10833.33 .04 100.00 Total TRANSFERS 130000.00 129999.96 10833.33 .04 100.00 Total Airport 407868.00 423895.85 28697.66 -16027.85 103.93 t** GRAND TOTAL *** 407868.00 423895.85 28697.66 -16027.85 103.93 EXPE: 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 t Used 7600 Airport AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 38611.00 17790.38 20820.62 46.08 412000 Perm Part Time 22603.00 21564.23 2283.60 -4961.23 121.95 413000 Temporary Employees 10000.00 5182.39 4817.61 51.82 Total REGULAR SALARIES & WAGES 71214.00 50537.00 2283.60 20677.00 70.96 OTHER WAGES 414100 Overtime Wages 1000.00 473.28 526.72 47.33 414300 Term-Vacation Pay 1251.50 -1251.50 414400 Term-Sick Leave 1720.57 -1720.57 414500 Longevity Pay 1050.00 437.50 612.50 41.67 Total OTHER WAGES 2050.00 3882.85 -1832.85 189.41 Total SALARIES & WAGES 73264.00 54419.85 2283.60 18844.15 74.28 EMPLOYEE BENEFITS GROUP INSURANCE 421100 Health Insurance 7280.00 4931.80 285.62 2348.20 67.74 421200 Dental Insurance 490.00 305.72 17.70 184.28 62.39 421300 Life Insurance 198.00 139.18 58.82 70.29 421400 Disability Insurance 460.00 160.65 14.10 299.35 34.92 421500 Unemployment Compensation 832.00 -832.00 Total GROUP INSURANCE 8428.00 6369.35 317.42 2058.65 75.57 SOCIAL SECURITY CONTRIBUTIONS 422100 FICA 5605.00 4050.64 166.96 1554.36 72.27 Total SOCIAL SECURITY CONTRIBUTIONS 5605.00 4050.64 166.96 1554.36 72.27 RETIREMENT CONTRIBUTIONS 423100 IPBRS 4652.00 3058.04 145.00 1593.96 65.74 Total RETIREMENT CONTRIBUTIONS 4652.00 3058.04 145.00 1593.96 65.74 EXPE: 07.13.09 11:40:16 Page: 2 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 I 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 Worker's 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 Page: 3 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) PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) INSURANCE (CONTINUED) 437200 Loss Reserve Payment 5000.00 5000.00 100.00 Total INSURANCE 31472.00 25522.03 4917.00 5949.97 81.09 UTILITY SERVICES 438010 Stormwater Utility Charges 7104.00 7803.52 591.96 -699.52 109.85 438030 Electricity 15530.00 12320.27 880.61 3209.73 79.33 438070 Heating Fuel/Gas 8680.00 7972.72 90.63 707.28 91.85 438080 Sewer Utility Charge 1475.00 1611.74 109.01 -136.74 109.27 438090 Water Utility Charge 1321.00 1428.79 101.31 -107.79 108.16 438100 Refuse Collection Charges 1200.00 1163.00 99.00 37.00 96.92 438110 Local Phone Service 264.00 836.50 79.79 -572.50 316.86 438120 Long Distance Service 30.00 55.64 4.85 -25.64 185.47 438130 Wireless Phone Service -3.45 3.45 Total UTILITY SERVICES 35604.00 33188.73 1957.16 2415.27 93.22 Total PROFESSIONAL & TECHNICAL SERVICES 83592.00 65642,69 7577.74 17949.31 78.53 REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building Repair & Maintena 7500.00 12603.86 137.50 -5103.86 168.05 442020 Structure Repair & Maintenance S 4000.00 4535.27 -535.27 113.38 442030 Heating Equipment Repair & Maint 500.00 1657.80 -1157.80 331.56 442040 Cooling Equipment Repair & Maint 1959.00 449.23 1509.77 22.93 442060 Electrical & Plumbing Repair & M 500.00 264.59 235.41 52.92 442070 Bldg Pest Control Services 431.00 407.40 33.95 23.60 94.52 Total BUILDING REPAIR & MAINTENANCE SERVICE 14890.00 19918.15 171.45 -5028.15 133.77 EQUIPMENT REPAIR & MAINTENANCE SERVICES 443050 Radio Equipment Repair & Mainten 1600.00 1600.00 443080 Other Equipment Repair & Mainten 813.00 1399.38 100.00 -586.38 172.13 EIRE: 07.13.09 11:40:16 Page: 4 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) EQUIPMENT REPAIR & MAINTENANCE SERVICES (CO Total EQUIPMENT REPAIR & MAINTENANCE SERVIC 2413.00 1399.38 100.00 1013.62 57.99 TECHNICAL SERVICES 445030 Nursery Service-Lawn and Plant C 300.00 4500.00 4500.00 -4200.00 1500.0 445080 Snow and Ice Removal 21500.00 -21500.00 445110 Testing Services 1900.00 1737.70 357.60 162.30 91.46 445140 Outside Printing 139.00 596.10 116.00 -457.10 428.85 445230 Other Technical Services 5121.00 5121.00 Total TECHNICAL SERVICES 7460.00 28333.80 4973.60 -20873.80 379.81 INTRA-DEPARTMENT SERVICES 446100 City Attorney Chargeback 4036.00 5812.36 -1776.36 144.01 446130 ITS-PC/Peripheral Support Charge 400.00 400.00 100.00 446140 ITS-Computer Replacement Chargeb 633.00 633.36 52.78 -.36 100.06 446160 ITS-Network/Internet Chargeback 360.00 360.00 30.00 100.00 446200 Photocopying Chargeback 455.00 336.60 20.64 118.40 73.98 446220 Phone Service Chargeback 612.00 577.68 48.14 34.32 94.39 446280 Telecom Move/Add/Change Chargeba 157.52 36.52 -157.52 446300 Phone Equipment/Line Chargeback 913.00 937.50 85.00 -24.50 102.68 446320 Mail Chargeback 706.00 509.77 15.79 196.23 72.21 446350 City Vehicle Replacement Chargeb 14176.00 13953.88 1161.30 222.12 98.43 446360 City Vehicle Rental Chargeback 143.00 -143.00 446370 Fuel Chargeback 4861.00 4644.92 425.85 216.08 95.55 446380 Vehicle Repair & Maintenance Cha 3516.00 6314.98 -2798.98 179.61 Total INTRA-DEPARTMENT SERVICES 30668.00 34781.57 1876.02 -4113.57 113.41 MISCELLANEOUS SERVICES & CHARGES 449055 Permitting Fees 65.00 -65.00 449060 Dues & Memberships 525.00 625.00 -100.00 119.05 449120 Equipment Rental 250.00 250.00 449140 Tools Rental 250.00 250.00 E%PE: 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 61294.00 45895.19 3824.74 15398.81 74.88 Total MISCELLANEOUS SERVICES & CHARGES 62319.00 46585.19 3824.74 15733.81 74.15 Total REPAIR & MAINTENANCE 117750.00 131018.09 10945.81 -13268.09 111.27 OTHER PURCHASED SERVICES (CHANGE TO OFFICE SU GENERAL SUPPLIES 452010 Office Supplies 859.00 610.79 248.21 71.10 452030 Minor Office Equipment/Furniture 642.00 642.00 452040 Sanitation & Industrial Supplies 1821.00 2000.00 -179.00 109.83 Total GENERAL SUPPLIES 3322.00 2610.79 711,21 78.59 BOOKS & PERIODICALS 454020 Subscriptions 1870.00 2036.00 -166.00 108.88 454040 Books, Magazines, Newpapers Total BOOKS & PERIODICALS 1870.00 2036.00 -166.00 108.88 COMPUTER & PRINTING SUPPLIES 455110 Software 91.00 -91.00 455120 Misc Computer Hardware 500.00 500.00 Total COMPUTER & PRINTING SUPPLIES 500.00 91.00 409.00 18.20 Total OTHER PURCHASED SERVICES (CHANGE TO OFF 5692.00 4737.79 954.21 83.24 OPERATING SUPPLIES AGRICULTURE SUPPLIES 461040 Other Agriculture Chemicals 364.00 424.41 286.54 -60.41 116.60 Total AGRICULTURE SUPPLIES 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 199.98 -199.98 Total CHEMICAL & LAB SUPPLIES 199.98 -199.98 FUELS & LUBRICANTS 465020 Gasoline 133.52 -133.52 465030 Diesel Fuel 373.88 -373.88 465060 Lubricants 101.00 101.00 Total FUELS & LUBRICANTS 101.00 507.40 -406.40 502.38 REPAIR & MAINTENANCE SUPPLIES 466020 Lumber/Hardware 27.01 -27.01 466030 Paint Supplies 23.00 23.00 466040 Plumbing Supplies 6.00 6.00 466050 Electrical Supplies 349.00 163.82 144.29 185.18 46.94 466060 Other Construction Supplies 838.00 838.00 466070 Other Maintenance Supplies 589.00 125.02 55.64 463.98 21.23 Total REPAIR & MAINTENANCE SUPPLIES 1805.00 315.85 199.93 1489.15 17.50 EQUIPMENT REPAIR & MAINTENANCE SUPPLIES 467020 Equipment Repair & Maintenance S 650.00 124.40 124.40 525.60 19.14 467160 Other Vehicle Repair & Maintenan 73.00 73.00 Total EQUIPMENT REPAIR & MAINTENANCE SUPPLI 723.00 124.40 124.40 598.60 17.21 SURFACING MATERIALS 468020 Concrete 153.00 153.00 468030 Asphalt 600.00 129.65 470.35 21.61 468050 Sand 54.00 58.35 -4.35 108.06 Total SURFACING MATERIALS 807.00 188.00 619.00 23.30 EXPE: 07.13.09 11:40:16 Page: 7 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) OTHER SUPPLIES & EQUIPMENT 469040 Traffic Control Improvement Supp 106.00 330.00 -224.00 311.32 469190 Minor Equipment 888.00 99.00 789.00 11.15 469200 Tools 104.88 45.90 -104.88 469210 First Aid/Safety Supplies 57.00 57.00 469260 Fire Ext & Refills 111.00 78.50 32.50 70.72 469320 Miscellaneous Supplies 451.65 -451.65 469360 Food and Beverages 85.53 -85.53 Total OTHER SUPPLIES & EQUIPMENT 1162,00 1149.56 45.90 12.44 98.93 Total OPERATING SUPPLIES 4962.00 2909.60 656.77 2052.40 58.64 IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements 70390.00 8114.00 62276.00 11.53 Total IMPROVEMENTS OTHER THAN BUILDING 70390.00 8114.00 62276.00 11,53 OTHER FINANCIAL USES 490150 Operating Subsidy 8359.00 8358.96 696.58 .04 100.00 490160 Misc Transfers Out 28486.25 -28486.25 490190 Interfund Loan 56426.00 23224.89 1935.27 33201.11 41.16 Total OTHER FINANCIAL USES 64785.00 60070.10 2631.85 4714.90 92.72 Total Airport Operations 439120.00 340527.65 24725.15 98592.35 77.55 Total Airport 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) +++ GRAND TOTAL +++ 439120.00 340527.65 24725.15 98592.35 77.55 REVS: 07.13.09 11:41:21 Page: 1 Iowa City General Ledger System FY 2009 Revenue Reporting Estimated YTD Period Account Revenue Revenue Revenue Remainder % 7600 Airport CONTRIB & DONATIONS 362100 Contrib & Donations 250.00 250.00 -250.00 Total CONTRIB & DONATIONS 250.00 250.00 -250.00 OTHER MISC REVENUE 369100 Reimb of Expenses 28496.25 28496.25 -28496.25 369900 Miscellaneous Other Income 200.00 200.00 -200.00 Total OTHER MISC REVENUE 28696.25 28696.25 -28696.25 INTEREST REVENUES 381100 Interest on Investments 1000.00 1596.11 1596.11 -596.11 159.61 Total INTEREST REVENUES 1000.00 1596.11 1596.11 -596.11 159.61 RENTS 382100 Land Rental 30700.00 33005.50 33005.50 -2305.50 107.51 382200 Building/Room Rental 226000.00 211039.33 211039.33 14960.67 93.38 Total RENTS 256700.00 244044.83 244044.83 12655.17 95.07 ROYALTIES & COMMISSIONS 384200 Vending Machine Comm 168.00 72.00 72.00 96.00 42.86 384900 Other Commissions 20000.00 19236.70 19236.70 763.30 96.18 Total ROYALTIES & COMMISSIONS 20168.00 19308.70 19308.70 859.30 95.74 TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy 130000.00 129999.96 129999.96 .04 100.00 Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES 130000.00 129999.96 129999.96 .04 100.00 Total TRANSFERS 130000.00 129999.96 129999.96 .04 100.00 Total Airport 407868.00 423895.85 423895.85 -16027.85 103.93 *** GRAND TOTAL *** 407868.00 423895.85 423895.85 -16027.85 103.93 EXPE: 07.13.09 11:42:09 Page: 1 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 38611.00 17790.38 17790.38 20820.62 46.08 412000 Perm Part Time 22603.00 27564.23 27564.23 -4961.23 121.95 413000 Temporary Employees 10000.00 5182.39 5182.39 4817.61 51.82 Total REGULAR SALARIES & WAGES 71214.00 50537.00 50537.00 20677.00 70.96 OTHER WAGES 414100 Overtime Wages 1000.00 473.28 473.28 526,72 47.33 414300 Term-Vacation Pay 1251.50 1251.50 -1251.50 414400 Term-Sick Leave 1720.57 1720.57 -1720.57 414500 Longevity Pay 1050.00 437.50 437.50 612.50 41.67 Total OTHER WAGES 2050.00 3882.85 3882.85 -1832.85 189.41 Total SALARIES & WAGES 73264.00 54419.85 54419.85 18844.15 74.28 EMPLOYEE BENEFITS GROUP INSURANCE 421100 Health Insurance 7280.00 4931.80 4931.80 2348.20 67.74 421200 Dental Insurance 490.00 305.72 305.72 184.28 62.39 421300 Life Insurance 198.00 139.18 139.18 58.82 70.29 421400 Disability Insurance 460.00 160.65 160.65 299.35 34.92 421500 Unemployment Compensation B32.00 832.00 -832.00 Total GROUP INSURANCE 8428.00 6369.35 6369.35 2058.65 75.57 SOCIAL SECURITY CONTRIBUTIONS 422100 FICA 5605.00 4050.64 4050.64 1554.36 72.27 Total SOCIAL SECURITY CONTRIBUTIONS 5605.00 4050.64 4050.64 1554.36 72.27 RETIREMENT CONTRIBUTIONS 423100 IPERS 4652.00 3058.04 3058.04 1593.96 65.74 Total RETIREMENT CONTRIBUTIONS 4652.00 3058.04 3058.04 1593.96 65.74 EXPE: 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 % 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 -137.50 Total OTHER EMPLOYEE BENEFITS 137.50 137.50 -137.50 Total EMPLOYEE BENEFITS 18685.00 13615.53 13615.53 5069.47 72.87 PROFESSIONAL & TECHNICAL SERVICES PROFESSIONAL SERVICES 432020 Annual Audit 554.00 927.63 927.63 -373.63 167.44 432060 Consultant Services 5000.00 5000.00 432070 Management Services 9000.00 4500.00 4500.00 4500.00 50.00 432080 Other Professional Services 500.00 500.00 -500.00 Total PROFESSIONAL SERVICES 14554.00 5927.63 5927.63 8626.37 40.73 DATA AND COMMUNICATION SERVICES 435056 Delivery Services 36.98 36.98 -36.98 435060 Legal Publications 12.00 226.96 226.96 -214.96 1891.3 Total DATA AND COMMUNICATION SERVICES 12.00 263.94 263.94 -251.94 2199.5 TRAINING & EDUCATION 436030 Transportation 900.00 136.40 136.40 763.60 15.16 436050 Registration 400.00 250.00 250.00 150.00 62.50 436060 Lodging 500.00 232.96 232.96 267.04 46.59 436080 Meals 150.00 121.00 121.00 29.00 80.67 Total TRAINING & EDUCATION 1950.00 740.36 740.36 1209.64 37.97 INSURANCE 437010 Comp Liability Insurance 8578.00 5000.00 5000.00 3578.00 58.29 437020 Fire & Casualty Insurance 16893.00 14557.03 14557.03 2335.97 86.17 437030 Worker's Comp Insurance 73.00 90.00 90.00 -17.00 123.29 437041 Bonding & Other Insurance 928.00 875.00 875.00 53.00 94.29 437042 Fidelity Bond 437200 Loss Reserve Payment 5000.00 5000.00 5000.00 100.00 EXPE: 07.13.09 11:42:09 Page: 3 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) PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) INSURANCE (CONTINUED) Total INSURANCE 31472.00 25522.03 25522.03 5949.97 81.09 UTILITY SERVICES 438010 Stormwater Utility Charges 7104.00 7803.52 7803.52 -699.52 109.85 438030 Electricity 15530.00 12320.27 12320.27 3209.73 79.33 438070 Heating Fuel/Gas 8680.00 7972.72 7972.72 707.28 91.85 438080 Sewer Utility Charge 1475.00 1611.74 1611.74 -136.74 109.27 438090 Water Utility Charge 1321.00 1428.79 1428.79 -107.79 108.16 438100 Refuse Collection Charges 1200.00 1163.00 1163.00 37.00 96.92 438110 Local Phone Service 264.00 836.50 836.50 -572.50 316.86 438120 Long Distance Service 30.00 55.64 55.64 -25.64 185.47 438130 Wireless Phone Service -3.45 -3.45 3.45 Total UTILITY SERVICES 35604.00 33188.73 33188.73 2415.27 93.22 Total PROFESSIONAL & TECHNICAL SERVICES 83592.00 65642.69 65642.69 17949.31 78.53 REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building Repair & Maintena 7500.00 12603.86 12603.86 -5103.86 168.05 442020 Structure Repair & Maintenance S 4000.00 4535.27 4535.27 -535.27 113.38 442030 Heating Equipment Repair & Maint 500.00 1657.80 1657.80 -1157.80 331.56 442040 Cooling Equipment Repair & Maint 1959.00 449.23 449.23 1509.77 22.93 442060 Electrical & Plumbing Repair & M 500.00 264.59 264.59 235.41 52.92 442070 Bldg Pest Control Services 431.00 407.40 407.40 23.60 94.52 Total BUILDING REPAIR & MAINTENANCE SERVICE 14890.00 19918.15 19918.15 -5028.15 133.77 EQUIPMENT REPAIR & MAINTENANCE SERVICES 443050 Radio Equipment Repair & Mainten 1600.00 1600.00 443080 Other Equipment Repair & Mainten 813.00 1399.38 1399.38 -586.38 172.13 Total EQUIPMENT REPAIR & MAINTENANCE SERVIC 2413.00 1399.38 1399.38 1013.62 57.99 EXPE: 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 o Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) TECHNICAL SERVICES 445030 Nursery Service-Lawn and Plant C 300.00 4500.00 4500.00 -4200.00 1500.0 445080 Snow and Ice Removal 21500.00 21500.00 -21500.00 445110 Testing Services 1900.00 1737.70 1737.70 162.30 91.46 445140 Outside Printing 139.00 596.10 596.10 -457.10 428.85 445230 Other Technical Services 5121.00 5121.00 Total TECHNICAL SERVICES 7460.00 28333.80 28333.80 -20873.80 379.81 INTRA-DEPARTMENT SERVICES 446100 City Attorney Chargeback 4036.00 5812.36 5812.36 -1776.36 144.01 446130 ITS-PC/Peripheral Support Charge 400.00 400.00 400.00 100.00 446140 ITS-Computer Replacement Chargeb 633.00 633.36 633.36 -.36 100.06 446160 ITS-Network/Internet Chargeback 360.00 360.00 360.00 100.00 446200 Photocopying Chargeback 455.00 336.60 336.60 118.40 73.98 446220 Phone Service Chargeback 612.00 577.68 577.68 34.32 94.39 446280 Telecom Move/Add/Change Chargeba 157.52 157.52 -157.52 446300 Phone Equipment/Line Chargeback 913.00 937.50 937.50 -24,50 102.68 446320 Mail Chargeback 706.00 509.77 509.77 196.23 72.21 446350 City Vehicle Replacement Chargeb 14176.00 13953.88 13953.88 222.12 98.43 446360 City Vehicle Rental Chargeback 143.00 143.00 -143.00 446370 Fuel Chargeback 4861.00 4644.92 4644.92 216.08 95.55 446380 Vehicle Repair & Maintenance Cha 3516.00 6314.98 6314.98 -2798.98 179.61 Total INTRA-DEPARTMENT SERVICES 30668.00 34781.57 34781,57 -4113.57 113.41 MISCELLANEOUS SERVICES & CHARGES 449055 Permitting Fees 65.00 65.00 -65.00 449060 Dues & Memberships 525.00 625.00 625.00 -100.00 119.05 449120 Equipment Rental 250.00 250.00 449140 Tools Rental 250.00 250.00 449360 Interest Expense 61294.00 45895.19 45895.19 15398.81 74.88 Total MISCELLANEOUS SERVICES & CHARGES 62319.00 46585.19 46585.19 15733.81 74.75 EXPE: 07.13.09 11:42:09 Page: 5 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) MISCELLANEOUS SERVICES & CHARGES (CONTINUED Total REPAIR & MAINTENANCE 117750.00 131018.09 131018.09 -13268.09 111.27 OTHER PURCHASED SERVICES (CHANGE TO OFFICE SU GENERAL SUPPLIES 452010 Office Supplies 859.00 610.79 610.79 248.21 71.10 452030 Minor Office Equipment/Furniture 642.00 642.00 452040 Sanitation & Industrial Supplies 1821.00 2000.00 2000.00 -179.00 109.83 Total GENERAL SUPPLIES 3322.00 2610.79 2610.79 711.21 78.59 BOOKS & PERIODICALS 454020 Subscriptions 1870.00 2036.00 2036.00 -166.00 108.88 454040 Books, Magazines, Newpapers Total BOOKS & PERIODICALS 1870.00 2036.00 2036.00 -166.00 108.88 COMPUTER & PRINTING SUPPLIES 455110 Software 91.00 91.00 -91.00 455120 Misc Computer Hardware 500.00 500.00 Total COMPUTER & PRINTING SUPPLIES 500.00 91.00 91.00 409.00 18.20 Total OTHER PURCHASED SERVICES (CHANGE TO OFF 5692.00 4737.79 4737.79 954.21 83.24 OPERATING SUPPLIES AGRICULTURE SUPPLIES 461040 Other Agriculture Chemicals 364.00 424.41 424.41 -60.41 116.60 Total AGRICULTURE SUPPLIES 364.00 424.41 424.41 -60.41 116.60 CHEMICAL & LAB SUPPLIES 463200 Other Chemicals & Supplies 199.98 199.98 -199.98 Total CHEMICAL & LAB SUPPLIES 199.98 199.98 -199.98 EXPE: 07.13.09 11:42:09 Page: 6 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) FUELS & LUBRICANTS 465020 Gasoline 133.52 133.52 -133.52 465030 Diesel Fuel 373.88 373.88 -373.88 465060 Lubricants 101.00 101.00 Total FUELS & LUBRICANTS 101.00 507.40 507.40 -406.40 502.38 REPAIR & MAINTENANCE SUPPLIES 466020 Lumber/Hardware 27.01 27.01 -27.01 466030 Paint Supplies 23.00 23.00 466040 Plumbing Supplies 6.00 6.00 466050 Electrical Supplies 349.00 163.82 163.82 185,18 46.94 466060 Other Construction Supplies 838.00 838.00 466070 Other Maintenance Supplies 589.00 125.02 125.02 463.98 21.23 Total REPAIR & MAINTENANCE SUPPLIES 1805.00 315.85 315.85 1489.15 17.50 EQUIPMENT REPAIR & MAINTENANCE SUPPLIES 467020 Equipment Repair & Maintenance S 650.00 124.40 124.40 525.60 19.14 467160 Other Vehicle Repair & Maintenan 73.00 73.00 Total EQUIPMENT REPAIR & MAINTENANCE SUPPLI 723.00 124.40 124.40 598.60 17.21 SURFACING MATERIALS 468020 Concrete 153.00 153.00 468030 Asphalt 600.00 129.65 129.65 470.35 21.61 468050 Sand 54.00 58.35 58.35 -4.35 108.06 Total SURFACING MATERIALS 807.00 188.00 188.00 619.00 23.30 OTHER SUPPLIES & EQUIPMENT 469040 Traffic Control Improvement Supp 106.00 330.00 330.00 -224.00 311.32 469190 Minor Equipment 888.00 99.00 99.00 789.00 11.15 469200 Tools 104.88 104.88 -104.88 469210 First Aid/Safety Supplies 57.00 57.00 469260 Fire Ext & Refills 111.00 78.50 78.50 32.50 70.72 469320 Miscellaneous Supplies 451.65 451.65 -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 % Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) OTHER SUPPLIES & EQUIPMENT (CONTINUED) 469360 Food and Beverages 85.53 85.53 -85.53 Total OTHER SUPPLIES & EQUIPMENT 1162.00 1149.56 1149.56 12.44 98.93 Total OPERATING SUPPLIES 4962.00 2909.60 2909.60 2052.40 58.64 IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements 70390.00 8114.00 8114.00 62276.00 11.53 Total IMPROVEMENTS OTHER THAN BUILDING 70390.00 8114.00 8114.00 62276.00 11.53 OTHER FINANCIAL USES 490150 Operating Subsidy 8359.00 8358.96 8358.96 .04 100.00 490160 Misc Transfers Out 28486.25 28486.25 -28486.25 490190 Interfund Loan 56426.00 23224.89 23224.89 33201.11 41.16 Total OTHER FINANCIAL USES 64785.00 60070.10 60070.10 4714.90 92.72 Total Airport Operations 439120.00 340527.65 340527.65 98592.35 77.55 Total Airport 439120.00 340527.65 340527.65 98592.35 77.55 EXPE: 07.13.09 11:42:09 Page: 8 Iowa City General Ledger System FY 2009 Expense Reporting YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) *** GRAND TOTAL *** 439120.00 340527.65 340527.65 98592.35 77.55 TRID: 07.13.09 11:42:43 Page: 1 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 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 2283.60 421100 Health Insurance 06.08.09 Journal 090616114015 007727 JUN HEALTH INSURANCE\CIC HEALTH INS 285.62 Total Health Insurance 285.62 421200 Dental Insurance 06.08.09 Journal 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 14.10 Total Disability Insurance 14.10 422100 FICA 06.05.09 Old Sys 090603010012 6050599\FICA\CITY CONTRIBUTION 83.48 06.19.09 Old Sys 090617010011 6190599\FICA\CITY CONTRIBUTION 83.48 Total FICA 166.96 423100 IPERS 06.05.09 Old Sys 090603010012 6053599\IPERS\CITY CONTRIBUTION 72.50 06.19.09 Old Sys 090617010011 6190599\IPERS\CITY CONTRIBUTION 72.50 Total IPERS 145.00 432080 Other Professional Services 06.16.09 New Vouch 090617030014 06725887 Check:647048\JET AIR INC IOW\JUNE 2 500.00 Total Other Professional Services 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 CITIZB 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\GARDINIER, MINNETTA\TR 55.00 Total Meals 55.00 437020 Fire & Casualty Insurance 06.09.09 New Vouch 090610030024 06725535 Check:646870\PETROLEUM MARKETERS MA 750.00 06.09.09 New Vouch 090610030024 06725547 Check:646882\SELECTIVE INSURANCE\FL 4167.00 Total Fire & Casualty Insurance 4917.00 438010 Stormwater Utility Charges 06.17.09 Journal 090622162749 007736 057-095-03\STORMWTR\6.17,09 Bill Da 591.96 Total Stormwater Utility Charges 591.96 438030 Electricity 06.17.09 New Vouch 090618030213 06726144 Check:647076\MIDAMERICAN ENERGY\ELE 744.78 06.17.09 New Vouch 090618030213 06726147 Check:647076\MIDAMERICAN ENERGY\ELE 53.71 06.24.09 New Vouch 090625030045 06726549 Check:647349\MIDAMERICAN ENERGY\ELE 82.12 Total Electricity 880.61 438070 Heating Fuel/Gas 06.17.09 New Vouch 090618030213 06726145 Check:647076\MIDAMERICAN ENERGY\GAS 42.11 06.17.09 New Vouch 090618030213 06726146 Check:647076\MIDAMERICAN ENERGY\GAS 23.17 06.24.09 New Vouch 090625030045 06726550 Check:647349\MIDAMERICAN ENERGY\GAS 10.00 06.24.09 New Vouch 090625030045 06726567 Check:647347\MIDAMERICAN ENERGY\GAS 15.35 TRID: 07.13.09 11:42:43 Page: 3 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) 438070 Heating Fuel/Gas )CONTINUED) Total Heating Fuel/Gas 90.63 438080 Sewer Utility Charge 06.17.09 Journal 090622162749 007736 057-115-00\SEWER\6.17.09 Bill Date 8.15 06.17.09 Journal 090622162749 007736 057-117-00\SEWER\6.17.09 Bill Date 48.05 06.17.09 Journal 090622162749 007736 057-118-03\SEWER\6.17.09 Bill Date 24.11 06.17.09 Journal 090622162749 007736 057-120-00\SEWER\6.17.09 Bill Date 28.70 Total Sewer Utility Charge 109.01 438090 Water Utility Charge 06.17.09 Journal 090622162749 007736 057-095-03\WATER\6.17.09 Bill Date 8.35 06.17.09 Journal 090622162749 007736 057-115-00\WATER\6.17.09 Bill Date 16.47 06.17.09 Journal 090622162749 007736 057-117-00\WATER\6.17.09 Bill Date 36.31 06.17.09 Journal 090622162749 007736 057-118-03\WATER\6.17.09 Bill Date 18.37 06.17.09 Journal 090622162749 007736 057-120-00\WATER\6.17.09 Bill Date 21.81 Total Water Utility Charge 101.31 438100 Refuse Collection Charges 06.17.09 New Vouch 090618030213 06726109 Check:647167\ALLIED WASTE SERVICES\ 74.00 06.17.09 New Vouch 090618030213 06726109 Check:647167\ALLIED WASTE SERVICES\ 25.00 Total Refuse Collection Charges 99.00 438110 Local Phone Service 06.22.09 New Vouch 090623030012 06726265 Check:647492\IOWA TELECOM COMMUNCIA 79.79 Total Local Phone Service 79.79 438120 Long Distance Service 06.01.09 Ph Lon Dst 090701160037 00006019 JUN LONG DIST CHGBE 4.85 Total Long Distance Service 4.85 TRID: 07.13.09 11:42:43 Page: 4 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) 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\HAWKEYE PEST CONTROL I 33,95 Total Bldg Pest Control Services 33.95 443080 Other Equipment Repair & Maintenance Se 06.30.09 Journal 090706183406 007750 HYDRANT MAINT FY09\CIC INTRA CITY C 100.00 Total Other Equipment Repair & Maintenance Sery 100.00 445030 Nursery Service-Lawn and Plant Care 06.16.09 New Vouch 090617030014 06725886 Check:647048\JET AIR INC IOW\JUNE 2 4500.00 Total Nursery Service-Lawn and Plant Care 4500.00 445110 Testing Services 06.16.09 New Vouch 090617030014 06725872 Check:647117\TANKNOLOGY INC\TEST UN 357.60 Total Testing Services 357.60 445140 Outside Printing 06.08.09 New Vouch 090609030010 06725281 Check:646736\PIP PRINTING\AIRPORT 58.00 06.16.09 New Vouch 090617030014 06725867 Check:647087\PIP PRINTING\AIRPORT 58.00 Total Outside Printing 116,00 446140 ITS-Computer Replacement Chargeback 06.01.09 IT Repl 090603141219 00006025 JUN ITS REPL CHUCK 52.78 Total ITS-Computer Replacement Chargeback 52.78 446160 ITS-Network/Internet Chargeback 06.01.09 IT Int/Nwk 090603105714 00006031 JUN ITS NETW/INTRNET 30.00 Total ITS-Network/Internet Chargeback 30.00 TRID: 07.13.09 11:42:43 Page: 5 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) 446200 Photocopying Chargeback 06.30.09 Journal 090629164712 007745 MAY PHOTOCOPY\CIC CENTRAL SERVICE C 20.64 Total Photocopying Chargeback 20.64 446220 Phone Service Chargeback 06.17,09 Qwest Chrg 090617124828 00006032 Jun Qwest Charges 48.14 Total Phone Service Chargeback 48.14 446280 Telecom Move/Add/Change Chargeback 06.30.09 IT Ann Sup 090707102316 00006024 JUN PHONE SERV 36.52 Total Telecom Move/Add/Change Chargeback 36.52 446300 Phone Equipment/Line Chargeback 06.01.09 Ph Equipmt 090701160037 00006018 JUN PEON EQUIP CHGBE 85.00 Total Phone Equipment/Line Chargeback 85,00 446320 Mail Chargeback 06.01.09 Mail 090603125447 00600051 MAY POSTAL CHARGES 15.79 Total Mail Chargeback 15.79 446350 City Vehicle Replacement Chargeback 06.30.09 EQ Repl 090707130029 00006006 JUN REPLACEMENT COST 1161.30 Total City Vehicle Replacement Chargeback 1161.30 446370 Fuel Chargeback 06.30.09 EQ Div 090707130029 00006008 JUN DIVISION FUEL 425.85 Total Fuel Chargeback 425.85 449360 Interest Expense 06.30.09 Journal 090616114015 007733 Corp Hangar Loan Int\June Interfund 1904.56 06.30.09 Journal 090616114015 007733 Airprt SE Hangar Int\June interfund 991.02 06.30.09 Journal 090616114015 007733 Airprt SW Hangar-Int\June Interfund 929.01 06.30.09 Journal 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 Report# 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\1nterfund loan .04 06.30.09 Journal 090709164858 007772 Airprt SE Hangar Int\1nterfund 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 MENARDS IOWA CITY\MICHAEL THARP 34.83 06.23.09 P-Card 090707102742 15300507 BEST LOCK\MICHAEL THARP 20.81 Total Other Maintenance Supplies 55.64 467020 Equipment Repair & Maintenance Supplies 06.19.09 New Vouch 090622030019 06726195 Cbeck:647403`VAN METER INDUSTRIAL I 72.14 06.23.09 P-Card 090707102742 15300505 NAPA AUTO PARTS IOWA C\MICHAEL 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 10%\June Budgeted Tr 696.58 Total Operating Subsidy 696.58 TRID: 07.13.09 11:42:43 Page: 7 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) 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 Page: 8 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) 490190 Interfund Loan (CONTINUED) Total Airport 24725.30 .15 TRID: 07.13.09 11:42:43 Page: 9 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) 490190 Interfund Loan (CONTINUED) **i GRAND TOTAL t{+ 24725.30 .15 TRID: 07.13.09 11:42:54 Page: 1 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 560100 Airport Operations 382100 Land Rental 06.12.09 Payment 090612093217 00013408 2-7\BELL LARRY & SANDRA\MAY 2009 P 96.00 06.12.09 Payment 090612093217 00013408 2-7\BELL LARRY & 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\SCEMEISER RUSS\JUN 09\HANGAR 204.00 06.02.09 Payment 090602101203 00013290 3-6\OCKENFBLS TRANSFER\JUN 09\HANGA 204.00 06.02.09 Payment 090602101203 00013365 3-14\ADVANCED INFONEERING\PAYMENT 110.00 06.03.09 Payment 090603111644 00013256 2-12\FIELD HOWARD\JUN 09\HANGAR #5 168.00 06.03.09 Payment 090603111644 00013292 1-32\PATTSCHULL RICHARD\JUN 09\HAN 229.00 06.03.09 Payment 090603111644 00013335 1-34\HERTZ CORPORATION\JUN 09\OFFIC 300.00 06.04.09 Payment 090604093537 00013275 2-8\BULLERS JONATHAN\JUN 09\HANGAR 141.00 06.04.09 Payment 090604093537 00013277 2-7\BULGARELLI DAVID\JUN 09\HANGAR 148.00 06.04.09 Payment 090604093537 00013300 2-2\FARRIS GREG\JUN 09\HANGAR #29 148.00 06.05.09 Payment 090605092933 00013011 3-4\LACINA DAVE\MAY 09\HANGAR #57 198.00 06.05.09 Payment 090605092933 00013274 3-10\SCHNELL TOM\JUN 09\HANGAR #62 174.00 06.05.09 Payment 090605092933 00013283 3-6\MASCARI RICK\JUN 09\HANGAR #30 148.00 06.05.09 Payment 090605092933 00013291 3-5\LACINA DAVE\JUN 09\HANGAR #57 198.00 06.08.09 Payment 090608094656 00013318 2-18\OPERATOR PERFORMANCE LAB\JUN 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\WIECHERT RONALD\JUN 09\HANGAR 192.00 06.10.09 Payment 090610092502 00013261 2-2\RUYLE JOHN\JUN 09\HANGAR #33 358.00 06.10.09 Payment 090610092502 00013278 2-11\IOWA CITY FLYING CLUB\JUN 09\H 168.00 06.10.09 Payment 090610092502 00013293 2-6\NE IA PHYS THERPY ASSOC\JUN 09\ 198.00 06.10.09 Payment 090610092502 00013293 2-6\NE IA PHYS THERPY ASSOC\JUN 09\ 174.00 06.10.09 Payment 090610092502 00013296 2-16\CHALKLEY BBN\JUN 09\HANGAR #1 148.00 06.10.09 Payment 090610092502 00013314 2-3\ROOF KEITH\JUN 09\HANGAR #32 512.00 06.11.09 Payment 090611091730 00013298 2-5\ZUBROD ROY\JUN 09\HANGAR #20 148.00 06.11.09 Payment 090611091730 00013330 2-7\VRANEK DOUGLAS\JUN 09\HANGAR # 141.00 06.12.09 Payment 090612093217 00013362 2-8\ROHR BRIAN\JUN 09\HANGAR #19 148.00 06.15.09 Payment 090615091435 00013279 2-19\HOLLY FORREST\JUN 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\TEARSE DAVID\JUN 09\HANGAR #4 168.00 06.16.09 Payment 090616094748 00013273 1-16\RANEY CHARLES\JUN 09\HANGAR # 141.00 06.16.09 Payment 090616094748 00013366 1-39\YELDER 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 JAMES\JUN 09\HANGAR # 168.00 06.17.09 Payment 090617093752 00013329 3-1\ALEXIS PARK 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\JUN 09\HANGA 174.00 06.19.09 Payment 090619115140 00013294 89-6\ALLENDER PATRICK\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\GURNETT DON\JUN 09\HANGAR #3 310.00 06.19.09 Payment 090619115140 00013322 89-14\SINGLETARY ROBERT\JUN 09\SAN 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\MEADE JAMES N\JUN 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\JUN 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 ROBERT\JUN 09\HANGAR #12 148.00 Total Building/Room Rental 13441.00 384200 Vending Machine Comm 06.19.09 Misc Pymt 090619094841 2-6\AMERICAN BOTTLING\VENDING COMMI 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 System Revenues Detail FY 2009 Detail Reporting For the period 06.01.09 to 06.30.09 Trans Date Trans Type Reports 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 Page: 5 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) *** GRAND TOTAL *** 28697.66 .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 BUDGETED EXPENDITURES Account Amount Notes 7600 560100 411000 Perm Full Time 39,802 7600 560100 412000 Perm Part Time 31,578 7600 560100 413000 Temporary Employees 10,000 7600 560100 414100 Overtime Wages 2,062 7600 560100 414500 Longevity Pay 1,050 Total Salaries & Wages 84,492 7600 560100 421100 Health Insurance 8,367 7600 560100 421200 Dental Insurance 525 7600 560100 421300 Life Insurance 240 7600 560100 421400 Disability Insurance 554 7600 560100 421500 Unemployment Comp 1,991 7600 560100 422100 FICA 6,487 7600 560100 423100 IPERS 5,639 7600 560100 424500 Monthly Cell/PCS 300 Total Employee Benefits 24,103 7600 560100 431020 Court Costs & Svcs 180 7600 560100 432020 Annual Audit 527 PKG_DETL: 07 .13 .09 11:44 Page: 2 • 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 432070 Management Services 9,000 See Form C. 7600 560100 435057 Couriers 28 7600 560100 435060 Legal Publications 44 7600 560100 436030 Transportation 900 See Form D. 7600 560100 436050 Registration 400 See Form D. 7600 560100 436060 Lodging 500 See Form D. 7600 560100 436080 Meals 150 See Form D. 7600 560100 437010 Comp Liability Ins 7,040 7600 560100 437020 Fire & Casualty Ins 12,067 7600 560100 437030 Worker's Comp Ins 86 7600 560100 437041 Bonding & Other Insu 936 7600 560100 437200 Loss Reserve Payment 5,000 7600 560100 438010 Stormwater Charges 7,104 7600 560100 438030 Electricity 15,074 7600 560100 438070 Heating Fuel/Gas 11,581 7600 560100 438080 Sewer Utility Charge 1,925 7600 560100 438090 Water Utility Charge 1,736 7600 560100 438100 Refuse Coll Charges 1,157 7600 560100 438110 Local Phone Service 454 7600 560100 438120 Long Distance Servic 55 Total Prof/Technical Svcs 75,944 7600 560100 442010 Other Bldg R & M Svc 8,951 7600 560100 442020 Structure R & M Svcs 4,000 Same as FY09. 1600 560100 442030 Heating Equip R & M 500 Same as FY09. 7600 560100 442040 Cooling Equip R & M 500 7600 560100 442060 Elect & Plumb R & M 500 Same as FY09. 7600 560100 442070 Bldg Pest Control 437 7600 560100 443080 0th Equip R&M Svcs 3,317 7600 560100 445030 Nursery-Lawn & Plant 300 Plant Care / replacements. 7600 560100 445110 Testing Services 1,280 7600 560100 445140 Outside Printing 166 7600 560100 446100 City Attorney Chgbk 6,360 7600 560100 446130 ITS-PC/Periph Supp 400 7600 560100 446140 ITS-Cmptr Repl Chgbk 633 7600 560100 446160 ITS-NW/Internet Chg 360 7600 560100 446200 Photocopying Chgbk 512 7600 560100 446220 Phone Svc Chgbk 618 7600 560100 446300 Phone Equip/Line Chg 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 Purhcased new mower deck. 7600 560100 446360 City Vehicle Rental 644 7600 560100 446370 Fuel Chgbk 8,506 7600 560100 446380 Vehicle Rep & Maint 4,017 7600 560100 446390 Auto Body Repair 109 7600 560100 449060 Dues & Memberships 625 No explanation provided. 7600 560100 449120 Equipment Rental 213 7600 560100 449140 Tools Rental 250 Same as FY09. 7600 560100 449360 Interest Expense 58,997 Total Repair & Maintenance 117,880 7600 560100 452010 Office Supplies 850 Same as FY09. 7600 560100 452030 Minor Off Equip/Furn 500 No explanation provided. 7600 560100 452040 Sanita & Indust Supp 533 7600 560100 454010 Reference Mat & Book 17 7600 560100 454020 Subscriptions 2,007 7600 560100 455120 Misc Comp Hardware 419 Total Office/EDP Supplies 4,326 7600 560100 461030 Plants & Trees 88 7600 560100 461040 Other Ag Chemicals 364 Same as FY09. 7600 560100 463200 Other Chem & Supplie 327 7600 560100 465060 Lubricants 138 7600 560100 466030 Paint Supplies 25 7600 560100 466040 Plumbing Supplies 25 7600 560100 466050 Electrical Supplies 742 7600 560100 466060 Other Construe Suppl 288 7600 560100 466070 Other Maint Supplies 288 7600 560100 467020 Equip R & M Supplies 149 7600 560100 467160 0th Veh R&M Supplies 376 7600 560100 468020 Concrete 243 7600 560100 468030 Asphalt 273 7600 560100 468050 Sand 50 7600 560100 469190 Minor Equipment 674 7600 560100 469260 Fire Ext & Refills 108 7600 560100 469320 Misc Supplies 484 Total Operating/Maint Supp 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 Notes 7600 560100 473020 Non-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 Seq Position Name FTE Salary Fringes 620 MWI - AIRPORT KAEFRING, GERALD T 1.00 39,802 12,744 621 AIRPORT OPERATIONS SPECIALIST THARP, 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 EMPLOYEES: 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: CAPITAL OUTLAY Seq Description Budget Notes 2 Runway Crack Sealing 20,000 1 Fencing 7,500 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 FTE Splits - Between Funds Budgeted in General Fund for Employee Benefits Econ Dev Coord, funding split w/ Enterprise Funds: 50/20/20/10 - GF/WW/Wtr/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