Loading...
HomeMy WebLinkAbout03-12-2009 Airport CommissionIOWA CITY AIRPORT MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, MARCH 12, 2009 - 7:OOP.M. 1. Determine Quorum 2. Election of Officers 3. Approval of Minutes from the following meetings: February 12, 2009; February 23, 2009; 4. Public Discussion - Items not on the agenda 5. Items for Discussion/Action: a. Iowa Concrete Paving Association — Paving Project Award Presentation b. Aviation Commerce Park / Uofl Aircare Facility c. Private Hangar Construction — Doug Moore d. Gilbert Street Land Parcel e. FAA/IDOT Projects - AECOM — David Hughes i. Runway 7/25 & 12130 1. Consider a resolution approving contract with AECOM for design services for Runway 12-30 Reconstruction 2. Hangar Rent Reimbursement ii. South Aviation Development Study iii. 2008 Pavement Rehab (North Taxilanes) iv. Obstruction Mitigation v. Building H — University of Iowa Hangar Expansion f. Airport "Operations": Strategic Plan -Implementation; Budget; Management I. Operations Specialist Evaluation g. FBO Staff Report h. Airport Commission Meeting Datelrime i. Subcommittees' Reports j. Commission Members' Reports k. Staff Report 6. Set next regular meeting for April 9, 2009 at 5:45 p.m. 7. Adjourn Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 350 5045 RESOLUTION NO. RESOLUTION APPROVING SUPPLEMENTAL AGREEMENT NO. 2 WITH AECOM FOR ENGINEERING SERVICES RELATING TO THE RUNWAY 12-30 RECONSTRUCTION PROJECT. WHEREAS, the Iowa City Airport Commission entered into a contract entitled "Professional Services Agreement" with AECOM on December 11, 2008 to provide engineering services Federal Airport Improvement Program Projects; WHEREAS, Part I(A) of said agreement provides that the parties will enter into supplemental agreements for each project; WHEREAS, the Commission and AECOM have previously entered into Supplemental Agreement No. 1; WHERAS, the Commission and AECOM now desire to enter into Supplemental Agreement No. 2, a copy of which is attached; and WHEREAS, it is in the best interest of the Commission to enter into Supplemental Agreement No. 2. NOW, THEREFORE, BE IT RESOLVED BY THE AIRPORT COMMISSION OF THE CITY OF IOWA CITY: The Chairperson is authorized to sign Supplemental Agreement No. 2 after concurrence with FAA. Passed and approved this CHAIRPERSON ATTEST: SECRETARY day of It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays 2009. Approved By: City Attorney's Office Absent the Resolution be Farris Horan Rettig Staley AECOM AECOM 500 SW 7th Street, Suite 301, Des Moines, Iowa 50309 w .aecom.com TASK ORDER NO. 2 REHABILITATION OF RUNWAY 12-30 PHASE II — FAA ECONOMIC RECOVERY FUNDS IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA FAA PROJECT NO.3-19-0047-19 (Proposed) Project Description - See attachment and incorporated herein. Scope of Services - See attachment and incorporated herein. Compensation A. Compensation for services for the Design Phase shall be a lump sum fee of One Hundred Forty - Three Thousand Dollars ($143,000.00). General Conditions Except as specifically amended by this agreement, services shall be provided in accordance with the Consultant Services Agreement for the Iowa City Municipal Airport between AECOM Technical Services, Inc., and the Iowa City Airport Commission dated December 22, 2008. APPROVED IOWA CITY AIRPORT COMMISSION L.,IwodMDMIMAGREETROFIICRunway7-25 Runway12-30.doc APPROVED AECOM TECHNICAL SERVICES, INC. By Joe A. Becker ' Date March 6. 2009 ATTACHMENT FOR REHABILITATION OF RUNWAY 12-30 (PHASE II) IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA FAA ECONOMIC RECOVERY FUNDS PROJECT DESCRIPTION The project is described as the Phase II of Rehabilitation of Runway 12-30 at the Iowa City Municipal Airport, Iowa City, Iowa. The project includes approximately 2,500 feet of Runway 12-30 that remains south of the work completed on AIP Project No. 3-19-0047-17. Based on the previously completed pavement evaluation, it is anticipated that the rehabilitation will be accomplished by reconstruction of the existing runways with Portland cement concrete pavement with grooving and marking. The work involved in the project will also include pavement removal, excavation, aggregate base course, storm sewer, subdrain, runway edge lighting and surface restoration. The final project will be designed around the maximum anticipated federal funding amount of $2,500,000.00. GENERAL PROJECT SCOPE The work to be performed by the Consultant shall encompass and include detailed work, services, materials, equipment and supplies necessary to provide preliminary design, develop final plans, develop specifications, provide construction cost estimates and provide bidding services. Construction -phase services will be determined after the project has been bid and prior to issuance of a federal grant. Work shall be divided into the following tasks: A. Design Phase Design Conference. This task consists of a pre -design conference called by the Iowa City Airport Commission (hereinafter referred to as Commission) and held between the Commission, the Consultant, the FAA and any other participating or regulatory governmental agency. The purpose of this conference is to define project requirements, finances, schedules, phasing and other pertinent data that affects the scope of work, design standards, presentation of preliminary and final plans, and documents. The requirements set forth in this design conference, including design schedule, will be confirmed in writing by the Consultant to the Commission, with copies to each participating unit of government. 2. Data Collection and Review. This task consists of the collection of existing data applicable to this project and related to the proposed work site. The Airport Master Plan, record drawings of completed projects, existing hydraulic or hydrologic studies, previous soil borings and soil data, and utility information will be compiled as background information for the project. 3. Subsurface Investigation. This task consists of completing pavement cores and collection of subsurface soils data on an approximate 400-foot grid along the southerly section of Runway 12-30. Subsurface investigations shall be completed in accordance with FAA Advisory Circular AC 150I5340-6E. Subsurface information will be collected for design and construction of the proposed improvements. Page 2 4. Field Survey. This task consists of a field survey to collect topographic, horizontal and vertical data to assist in the preparation of the plans for the project. Field data will be collected for the runways and the runway safety areas. Property surveys are not included in this task. 5. Base Mapping. This task consists of the preparation of a topographic map including features, elevations, utilities and contours of the project site. This map will be prepared from the field survey and record documents of completed projects. 6. Pavement Design. This task consists of summarizing the pavement evaluation, the determination of the design aircraft, rehabilitation recommendations for the runway pavement design and preparation of the final pavement design forms for the project. The final pavement design forms will be based on the design aircraft identified from the previous section. 7. Preparation of Design Plans. This task consists of the preparation of the final design plans for this project. The final plans will set forth in detail the requirements of the preliminary design phase, together with the common practice of design and ethical practice of professional engineers. Plans will be prepared in compliance with current Central Region Federal Aviation Administration requirements in effect at the time the plans are prepared. This task includes the preparation of the following: a. Title Sheet b. Legend and General Notes C. Schedule of Drawings d. Schedule of Quantities e. General Project Layout f. Safety and Sequencing Plans g. Existing Conditions h. Typical Sections i. Removal Plans j. Geometric Layout k. Grading and Drainage Plans I. Storm Sewer Profiles M. Storm Sewer Details n. Erosion Control Plans o. Paving Plans and Profiles P. Pavement Jointing Plans q. Pavement Surface Elevations r. Pavement Details s. Pavement Marking Plans t. Pavement Marking Details U. Runway Lighting Layout V. Runway Lighting Details W. Cross Sections 8. Final Project Specifications. This task consists of the preparation of specifications for the project. The specifications will be in compliance with current Central Region Federal Aviation Administration and Iowa Department of Transportation requirements in effect at the time the specifications are prepared. Page 3 9. Estimate of Probable Construction Cost. This task consists of the preparation of a detailed estimate of construction costs based upon the detailed plans and specifications. This statement of probable construction cost prepared by the Consultant represents the Consultant's best judgment as a design professional at the time the estimate is drawn. It is recognized, however, that neither the Consultant nor the Commission has any control over the cost of labor, materials or equipment; over the contractor's method of determining bid prices, or over competitive bidding or market conditions. Accordingly, the Consultant can not and does not guarantee that bids will not vary from any statement of probable construction cost or other cost estimates prepared by the Consultant. 10. Enaineerino Report. This task consists of the preparation of an engineering report that relates to the Commission and participating governmental agencies, the fundamental considerations and concepts used in design of the project. Deviation in design and construction standards will be included in the engineering report. 11. Quality Review. This task consists of the quality review of work elements on the project. During the course of this project, quality reviews will be conducted by senior technical personnel that are not directly involved in the project. 12. Conferences and Meetings. This task consists of conferences and meetings in addition to the design conference and the stakeholder meetings that will be attended by the Consultant for the purpose of coordination, information exchange and general understanding of the status and direction of the project. 13. DBE Program. This task consists of assisting the Sponsor in preparation of an update to DBE program for this project. 14. Grant Application. This task consists of assisting the Sponsor in preparation of grant application. 15. Bid Assistance. This task consists of assisting the Commission in advertising for and receiving bids, analyzing the bids received and preparing a recommendation to the Commission for award of contract. 16. Pre -Bid Conference. This task consists of attending and conducting a "Pre -Bid Conference" at the Project site for prospective bidders. 17. Bid Document Interpretation. This task consists of answering bid document interpretation questions from bidders, preparing and issuing any required addenda. 18. Proiect Administration. This task consists of office administration and coordination of the project. Interoffice meetings, general day -today administrative responsibilities, and typing of interoffice memoranda and minutes of meetings are included in this task. Prepare up to forty (40) sets of contract documents for distribution to Commission, FAA, plan rooms, suppliers and potential bidders. This task also includes providing one electronic copy of the plans and specifications that can be viewed in and printed from Adobe Acrobat. L:\vrork\ADM IN\AGREE\PRO F\ICAirPhl IEwnRecov.dm Rehabilitation of Runway 12-30 Phase II - FAA Economic Recovery Funds Iowa City Municipal Airport Iowa City, Iowa FAA Project No. 3-19-0047 -19 (Proposed) Design Services Staff Hour Estimate Item No. Description I Senior Prof Project Prof Staff Prof CADD Operator Senior echniciarrechniciar Project Support Totals 1 Desi n Conference 4 4 8 2 Data Collection and Review 12 16 28 3 Subsurface Investigation 8 8 16 4 Field Survey 10 80 24 114 5 Base Mapping 16 16 2 34 6 Pavement Design 4 4 8 7 Preparation of Design Plans a Title Sheet 2 2 b Legend and General Notes 2 2 4 c Schedule of Drawings 2 2 4 d Schedule of Quantities 2 2 4 e General Project La ut 2 2 4 f Safety and Sequencing Plans 4 8 8 20 Existing Conditions 8 12 20 h Typical Sections 4 8 12 24 i Removal Plans 2 12 12 26 Goeometric Layout 4 12 8 24 k Grading and Drainage Plans 4 16 40 64 124 1 Storm Sewer Profiles 8 32 40 80 m Storm Sewer Details 4 12 12 28 n Erosion Control Plans 4 12 16 32 o Paving Plans and Profiles 4 16 20 40 Bo Pavement Jointing Plans 8 16 16 40 Pavement Surface Elevations 16 16 40 72 r Pavement Details 4 8 12 s Pavement Marking Plans 8 12 16 36 t Pavement Marking Details 2 4 814 u RunwayLighting Layout 4 16 16 36 v Runway Lighting Details 4 8 16 28 w Cross Sections 4 24 24 52 8 Final Project Specifications 8 8 16 9 Estimate of Probable Construction Cost 4 8 8 6 26 10 Engineering Report 4 8 4 8 24 11 Quality Review 8 4 12 12 Conferences and Meetings 8 16 12 36 13 DBE Program 4 8 8 20 14 Grant Application 4 2 6 15 Bid Assistance 8 4 12 16 Pre -Bid Conference 8 8 17 Bid Document Interpretation 4 4 4 12 18 Project Administration 24 10 34 Total Design Services 60 180 1 350 430 90 30 40 1180 IV V. Rehabilitation of Runway 12-30 Phase II - FAA Economic Recovery Funds Iowa City Municipal Airport Iowa City, Iowa FAA Project No. 3-19-0047 - 19 (Proposed) Design Services Consultant Cost Summary Direct Labor Cost Category Hours Rate/Hour Amount Senior Professional 60 $79.00 $4,740.00 Project Professional 180 $64.00 $11,520.00 Staff Professional 350 $37.00 $12,950.00 CADD Operator 430 $25.00 $10,750.00 Senior Technician 90 $29.50 $2,655.00 Technician 30 $22.00 $660.00 Project Support 40 $19.50 $780.00 $44,055.00 1180 Payroll Burden and Overhead Provisional Costs 160.00% $70,488.00 Direct Project Expenses Cateoory Units Rate/Unit Amount Mileage 4200 0.550 2,310.00 Per Diem 0 35.00 0.00 Lodging 0 75.00 0.00 Copier 4000 0.06 240.00 Plan Copier 400 0.50 200.00 GPS 20 25.00 500.00 Geodimeter 40 12.50 500.00 Ground Penetrating Radai 0 700.00 0.00 Miscellaneous, Other 500.00 $4,250.00 Earth Tech Estimated Actual Costs $118,793.00 Rounded $118,800.00 Subcontract Expense Terracon Consultants - Soils $7,000.00 $7,000.00 Estimated Actual Costs $125,800.00 Fixed Fee $17,200.00 Maximum Amount Payable $143,000.00 MINUTES DRAFT Iowa City Airport Commission February 12, 2009 Iowa City Airport Terminal — 5:45 PM Members Present: Greg Farris, Howard Horan, Randy Hartwig, Janelle Rettig, John Staley Staff Present: Sue Dulek, Michael Tharp Others Present: David Hughes, Harrel Timmons, Phillip Woolford, Carl Richey, Minnetta Gardinier, Peggy Slaughter, Rick Mascari, Ron Duffe, Justin Fishbaugh RECOMMENDATIONS TO COUNCIL: None DETERMINE QUORUM: The meeting was called to order at 5:46 P.M. APPROVAL OF MINUTES FROM THE JANUARY 8 AND FEBRUARY 5, 2009 MEETINGS: Farris asked if anyone had any comments on the submitted minutes for the January 8 meeting. Staley approved the January 8, 2009 minutes as submitted, seconded by Hartwig. Carried 5-0. Farris then asked about the February 5 minutes. Staley and Rettig both noted that they were not at this meeting and therefore recused themselves from discussion and vote. Hartwig moved to approve the minutes of the February 5, 2009 meeting as submitted, seconded by Farris. Carried 3-0; Staley and Rettig abstaining. PUBLIC DISCUSSION: Rick Mascari spoke briefly to the Commission, thanking the Members for their service. He thanked Hartwig for his years as a Commissioner. ITEMS FOR DISCUSSION/ACTION: a. Aviation Commerce Park — University of Iowa Aircare Facility — Staley recused himself as a Commissioner and spoke as an employee of the Iowa City Airport Commission February 12, 2009 Page 2 of 6 University of Iowa Hospitals and Clinics. Peggy Slaughter addressed the Commission, stating that the designer has talked to her about additional information. Staley noted that they have had one estimate from Shive Hattery. This prompted some changes to be made, and they have resubmitted this to Shive Hattery for another estimate. Staley noted that they hope to have this new estimate within a week or so. Once they have this new estimate, Staley noted that they would be submitting this to the City to indicate their "intent to purchase and construct." Hartwig asked what the timeline is for this project. Staley responded that they hope to have it done by January of 2011. Slaughter continued, updating the Commission on the interested party that she has been working with. She also spoke about property currently listed adjacent to Lot 17, and she passed info around to the Members. Slaughter continued, discussing what types of businesses are currently in this area, and what types of possibilities they can now market for this area. The discussion continued, with Members and Slaughter discussing the possibilities for development. FAVIDOT Projects AECOM — Farris noted that David Hughes is currently in Alaska. Farris stated that he did not have any updates, and Tharp stated that he also had not received any updates on projects. i. Runway 7/25 —Tharp continued, noting that the biggest issue is the 7/25 and 12/30, and he asked if Farris wanted to talk about the discussion they had recently on this issue. Farris stated that Hughes was able to show them that this project will be three parts, which are the 12/30 rehab, the intersection, and then the 7/25. Tharp noted that Hughes' estimate for closure was three to four weeks for the "red area," three to four for the "blue area," and five to six weeks for the "yellow area" Tharp responded to questions about the funding of this project He explained the various funding streams anticipated Rick Mascan spoke to the Members about the closures, and asked if they had looked at other alternates to this. He suggested a two-phase approach and asked if the Commission would consider something like this. Mascari also suggested using a shorter runway or the reopening of 18/36. Members continued to discuss the runway projects, debating safety issues and other alternatives to closing runways. Rettig asked if they could send a letter requesting other options, and Tharp noted that they could do this. He stated that they could also talk to the FAA about what they would be comfortable allowing. Mascari also spoke to the ASOS equipment and runway closures. Farris noted that the runways may be closed during this period, but the Airport will remain open for helicopter traffic. He agreed that they could look at other options, but that safety is a major concern. Mascari asked again that the Airport look at every possibility for keeping the runway open during the construction period. 2 Iowa City Airport Commission February 12, 2009 Page 3 of 6 The discussion turned to the possibility of rental reimbursements for hangars during a shutdown period. Rettig stated that if the hangars are being used for something other than storage of aircraft being used currently, that this would be another matter. An audience member also spoke to the Commission Members regarding possible hangar rental reimbursements, stating that this would only apply to those who would have to leave the airfield and store their planes elsewhere in order to keep flying. Farris noted that they will discuss this issue finther, and he reiterated the "red, blue, yellow" plan that has been discussed so far. Members then began talking about what might happen if another wet spring occurs. This led to a discussion of how flexible they can be in completing this project. ii. South Aviation Development Study — Tharp stated that he is not sure of the status of this. It is most likely still with the FAA, according to Tharp and Farris. The final report is to be back yet this month. iii. 2008 Pavement Rehab (North Taxilanes) — Tharp stated that there is one touch-up on this project - a soft spot in the pavement. Hartwig stated that they should look into the heaving of pavement in this area before it becomes too big of a problem. iv. Obstruction Mitigation — Farris noted that he does not have an update on this. Dulek stated that she has an update. She noted that Hughes wanted to close out the United hangar demolition, but the contractor has not provided the necessary paperwork. After several months of no response, Hughes asked Dulek to send a letter. V. Building H — University of Iowa Hangar Expansion — Farris noted that bids came back. Tharp stated they had nine overall. He briefed Members on this, and stated that he is proposing that the $10,000 fence budget be used toward the gap on the over -budget amount. Tharp responded to Members' questions regarding this project, explaining some of the work that will he done in-house instead. Rettig asked for further clarification from Tharp, to which he responded. 1. Consider Resolution #A09-2 Accepting Bids and Awarding Contract for the Building H - University of Iowa Hangar Expansion With Deduct Alternates - Rettig moved to Consider Resolution #A09-2, Accepting Bids and Awarding Contract for the Building H - University of Iowa Hangar Expansion With Deduct Alternates; seconded by Horan. Carried 5-0. vi. Corporate Hangar L — Rettig asked where this item was in relation to the CIP plan, Tharp responded that this was in the FY2011 budget year. Rettig asked about the money in the current plan and Iowa City Airport Commission February 12, 2009 Page 4 of 6 if they could apply for the hangar under the upcoming program that Tharp has given copies of the email. Farris responded that they have $100,000 in the budget policy which they could use for FY10. b. Airport "Operations;" Strategic Plan -Implementation; Budget; Management — Farris noted that he has been at several City Council meetings recently, and he shared with Members that the Council is looking to make cuts in several areas. He noted that the Airport budget was presented at $130,000 for operations. After a review, he stated that the Council opted to drop this to $120,000. Members briefly discussed this, noting that they can make the necessary adjustments. Rettig spoke to the local match amount for the hangar project, asking which fiscal year it is in. Farris and Tharp responded to questions and concerns from Members. The discussion continued, with Members talking about ways for the Airport to become more self-sufficient in coming years. Farris noted that he also presented the Airport's Annual Report to the Council recently. Rettig asked if the Commission could get copies of this final report. Tharp noted that he would do that. The conversation turned to upcoming grant opportunities and how the Airport should approach these. The budget was discussed next. Rettig asked how they plan to handle Jet Air now doing the Airport's maintenance. She noted that it is under "Snow and Ice Removal" currently. She suggested they talk with Finance downtown on the best way to handle this account in the future. Tharp stated that he would do that. Tharp added that the door on the University's hangar is having a problem, and that someone is coming out this week to give an estimate. Hartwig asked where the traffic -pattern change notification is currently. Tharp noted that mailings go out next week, and that he has several things in the works. c. Airport Commission Terms - Farris noted that Tuesday's Council meeting addressed the change in the Airport Commission terms. Rettig asked for some clarification on this, stating that four years is probably a better term. Dulek addressed how this would work, giving the Members the best scenario for making this change. Rettig stated that she believes they should hold off for a year before doing this. An audience member added that having shorter terms allows for added viewpoints on the Commission. Members briefly discussed this, agreeing that having the change to a 4-year term go into effect March 1, 2010 rather than March 1, 2009 would be better. Rettig noted that at the next meeting they would need to elect new officers. She asked if the Members are still interested in going back to the "old school" way of doing this, rotating through Members. Horan stated that he was thinking of nominating Rettig for Chair. Members continued to discuss this, with Staley noting that he would not have the time to serve as Chair. MINUTES DRAFT Iowa City Airport Commission February 23, 2009 Iowa City Airport Terminal — 7:30 AM Members Present: Greg Farris, Howard Horan, Randy Hartwig, Janelle Rettig Staff Present: Sue Dulek Others Present: 2 University of Iowa journalism students RECOMMENDATIONS TO COUNCIL: None DETERMINE QUORUM: The meeting was called to order at 7:32 A.M. ITEMS FOR DISCUSSION/ACTION: ,1. Runway 7-25 and 12-30 Reconstruction -Consider a resolution accepting FAA Grant 3- 19-0047-17. Horan moved to consider Resolution No. 09-0302-23-09 Airport Comm Min Accepting Federal Aviation Administration Grant 3-19-0047-17 for the Rehabilitation of Runway 7/25 and 12/30 Intersection Part A; seconded by Hartwig. Farris explained that although the Commission applied for an approximate $2.4 million grant, the FAA intends to divide it into two grants, Part A and Part B. Farris said that the Commission will apply for Part B in a few months. Rettig stated that although there is always a chance that the FAA will not have the funds for Part B, she feels that the Commission has no choice but to accept part of the grant. Farris stated that Part A will cover the engineering services. Resolution carried 4-0. ADJOURN: The meeting adjourned at 7: 37 A.M. Airport Commission ATTENDANCE RECORD YEAR 2009 tMeetino nnte l NAME TERM EXP. 1/8 vs v12 vz3 Greg Farris 3/1/13 X X X X Randy Hartwig 3/l/09 X X X X Howard Horan 3/1/14 X X X X Janelle Rettig 3/1/12 X O/E X X John Staley 3/1/10 X O/E X O/E KEY: X = Present O = Absent O/E = Absent/Excused NM = No meeting — = Not a Member March 6, 2009 Iowa City Airport Commission Iowa City, Iowa Re: Vacant lot on S. Gilbert Street Dear Commission Members, I am requesting an opportunity to address you at your March meeting regarding the potential of entering into a land lease with the City/Commission for a bare parcel of land at 1555 (ish) S. Gilbert Street. This parcel is adjacent to a building as owned by my client, Larry Bell. We are interested in talking to you about a lease, and probably NOT a sale. This lot is approximately 9000 square feet, more or less. It is too small for use by any developer. We have not made any appraisal or any financial calculations, other than to say that both Mr. Bell, and the owners of the office building to the immediate north are interested in this lease idea. Our use would include several upgrades including the cost of hard -surface, signage etc, as required by City code. We look forward to a discussion on March 19. Best r C. Rex REALTOR Affiliates 2751 Oakdale Blvd. Suite 3 RALTOI ® Coralville, Iowa 52241 0 T'Y GIS Online �i 1534 vQ ..... 151 iG.101 R; C O N11 s )I stii" G' } C 1 80 , b027 ) < � � _ t1,06�� 'j v t AE jn'-,'A LLs" 10 1440680 IDYeR CITY 75a6 10153840( US5580 `r 112 N r—it9w �iC75365003 '� 'Se3T7i3 `Johnson County Ioa 200 Johnson ) 553e8QC2 .,aQ;; U"SiJf-,7'°` 242650 .Zh?sa '^ fi lf£i3 �1-, . n Legend '5060 414840 j Political VESTMENTS 264 � Boundaries Centerlines i Centerline Labels a Parcel Lines 1411=* Boom Pso ✓ l� �i RyM—f-Way '. � / Nislorim y 1G 9�3<1gLu7J i 4536702i5 '•JIi � )N �: titer '23 ,�®� 1F7 U.S. Department Of Transportation Central Region 901 Locust Federal Aviation Iowa, Kansas, Kansas city, Missouri 64109 Administration Missouri, Nebraska (916) 329-2600 March 6, 2009 Mr. Greg Farris Chairman Iowa City Airport Commission 1801 S. Riverside Dr Iowa City, IA 52246 Dear Mr. Farris: Iowa City Municipal Airport Potential AIP No. 3-19-0047-19 Initiation of Work for Proposed Project This is written confirmation of our phone conversation on March 05, 2009. As discussed the project listed below is being considered for funding under the American Recovery and Reinvestment Act of 2009. Rehabilitate Runway 12f30 (Phase 2) This work is identified on an approved Airport Capital Improvement Program (ACID) data sheet on file with our office, and the federal share is estimated to be $2,536,062. Economic Recovery (ER) funds are different from Airport Improvement Program funds in several ways that will alter how you manage this project. I encourage you to coordinate closely with me to ensure that we meet all of the legal requirements of this Act. However, all normal AT eligibility and statutory requirements still apply. As discussed on the phone it is our understanding that you will open bids on or about May 1 a, 2009. All ER grants must be based on bids. We caution you that this letter does not represent an official notification that your location has or will receive Federal funding. The official notification of Federal funding will be the congressional release of funds. Please see the attached pages for more information. If you have any questions please contact me at (816) 329-2629 or via email at donald.w.harper@faa.eov. Sincerely, Donald W. Harper State Airport Engineer (IA) Important Points • The Federal Share of this project is 100%. There are no local matching funds necessary. • Normal AIP eligibility and statutory requirements still apply, including Buy American Preference. • The statute identifies specific milestone dates that must be met, additional sponsor certifications, greatly increased oversight/reporting requirements, and additional special conditions, as outlined below. • We cannot mix AIP and ER funds. An ER grant must fund a distinct, complete, and useable unit of work. • We must obligate 100% of your available AIP entitlements in FY09 in order to issue an ER grant. Because you have a planned grant in FY09, this requirement should be easily met. • Unlike AIP funds, there is a very low probability that amendments can be funded. Any cost overruns (i.e. change orders, engineering amendments, etc) must be borne by you, the sponsor. • There are some changes to the Davis -Bacon Wage Rate requirements — see Attachment 4. Important Milestones • Within 15 days of the Grant Offer, you muxt execute the construction contract • Within 30 days of the Grant Offer, you must issue the Notice To Proceed • The grant must be executed and returned to the FAA no later than June 17, 2009 • All work must be completed and the grant closed out by February 16, 2011. Sponsor Certifications • Prior to the grant offer, you will have to certify and provide a copy of the bid tabulation and certify that the project is based on bids • Along with the bid tabulation, you must submit the sponsor certification in Attachment 1. This must be signed by a state governor, mayor of the municipality, or sponsor's chief executive; and attested by a lawyer. • Prior to the grant offer, you will have to identify and request any waivers to the Buy American Preference Requirements Sponsor Reporting Requirements • Within 10 days of the end of each quarter, you must submit a report to me meeting the requirements in Attachment 2 • You will also have to submit periodic reports 90 days, 180 days, I year, 2 years, and 3 years after the date of the legislation — see Attachment 3. Additional Special Conditions: As part of the grant, you will agree to: • Adhere to all additional reporting and transparency requirements • Execute the construction contract within 15 days of the Grant Offer • Issue a Notice to Proceed within 30 days of the Grant Offer • Make at least one ECHO drawdown every 30 days unless no eligible costs have been incurred • Comply with these conditions, or the FAA reserves the right to close the grant and recover all costs Attachment I Airport Sponsor Certifications The Sponsor hereby certifies to the following: 1. The funding request contained in this grant application is based upon competitive bids that were received on (date to be inserted) and the associated bid tabulation is hereby attached to this certification. 2. The Sponsor hereby acknowledges FAA's need to approve and issue, as appropriate, any waiver to the Buy American Preference Requirement.(BAPR) (49 USC 50101). Additionally, the Sponsor understands that any waiver request issued to the BAPR under the American Recovery and Reinvestment Act of 2009 requires specific information related to the waiver request, if granted, to be published in a Federal Register Notice. Accordingly, so as to not delay the processing of the subsequent Grant Offer and resulting contract documents between the Sponsor and the lowest responsible bidder, attached hereto are all Request for Waiver to the BAPR necessary to complete this project- 3. The Sponsor further certifies that it will issue a Notice to Proceed to the contractor (or equipment supplier in the case of equipment acquisition) within 30 days of acceptance of a Grant Offer. 4. Pursuant to Title XV, Subtitle A, section 1511 of the American Recovery and Reinvestment Act (Pub. L. 111-5 (Feb. 17, 2009) C ARRA'), I s, hereby certify that the infraSlrnehae investment funded by ARRA has received the full review and vetting required by law and that I accept responsibility that such investment is an appropriate use of taxpayer dollars. I further certify that the specific information required by section 1511 concerning each such investment (a description of the investment, the estimated total cost, and the amount of ARRA funds to used) is enclosed or is provided on the (Sponsor named website)website, available to the public at [http://... (insert link)..] and linked to Recovery.gov. I understand that the Sponsor making application for ARRA funding may not receive ARRA infrastructure investment funding unless this certification is made and posted. ' In accordance with section 1511 ofARRA, the Certifying Of icial may be either the Governor, mayor, or other chief executive, as appropriate. (SEAL) Attest: of Sponsor) (Signature ofS)7onstated Ofcial Representative — Must be Governor, Mayor or Chief Executive) By: ()ved Name ofSponsor's Designated Official Representative) Title: (Typed Title ofSponsor's Designated Ofcial Representative) CERTIFICATE OF SPONSOR'S ATTORNEY I acting as Attorney for the Sponsor do hereby certify: That in my opinion the Sponsor is empowered to certify to the above representations under the laws of the State of Further, I have examined representations and documentation as attached and Sponsor's official representative has been duly authorized and that the execution thereof is in all respects due and proper and in accordance with the laws of the said State. Dated at this day of Rv: (Signature of Sponsor's Attorney Attachment 2 Transparency and Oversight Requirements CERTIFICATIONS (Sec.1511) With respect to covered funds made available to State or local governments for infrastructure investments, the Governor, mayor, or other chief executive, as appropriate, shall certify that the infrastructure investment has received the full review and vetting required by law and that the chief executive accepts responsibility that the infrastructure investment is an appropriate use of taxpayer dollars. Such certification shall include a description of the investment, the estimated total cost, and the amount of covered funds to be used and shall be posted on a website and linked to the website established by section 1526. A State or local agency may not receive infrastructure investmentfundingfromfunds made available in this Act unless this certification is made and posted REPORTS ON USE OF FUNDS. (Sec. 1512) A section of the ARRA referred to as the "Jobs Accountability Act" sets forth certain reporting requirements. SPONSOR REPORTS —Airport sponsors ("recipients") are required not later than 10 days after the end of each calendar quarter to submit a report to the FAA that contains— (]) the total amount ofARRA funds received from the FAA; (2) the amount that was expended or obligated to projects or activities; and (3) a detailed list of all projects for which recavery funds were expended or obligated including — (A) the name of the project; (B) a description of the project; (C) an evaluation of the completion status of the project; (D) an estimate of the number ofjobs created and the number ofjobs retained by the project; and (E) the purpose, total cost, and rationale forf outing the infrastructure investment with funds made available, and name of the person to contact if there are concerns with the infrastructure investment. (4) Detailed information on any subcontracts or subgrams awarded by the sponsor to include the data elements required to comply with the Federal Funding Accountability and Transparency Act of2006 (Public Law 109-282), allowing aggregate reporting on awards below $25,000 or to individuals, as prescribed by the Director of the Office of Management and Budget. AGENCY REPORTS— Not later than 30 days after the end of each calendar quarter, the FAA shall make the information in reports submitted by the sponsor above publicly available by posting the information on a website. COMPLIANCE —As a condition of receipt offends under this Act, FAA shall require any sponsor receiving ER funds to provide the information required in SPONSOR REPORTS section above. REGISTRATION— Sponsors required to report information elements to comply with the Federal Funding Accountability and Transparency Act of2006 (Public Law 109-282) (as noted in SPONSOR REPORTS above, must register with the Central Contractor Registration database or complete other registration requirements as determined by the Director of the Office of Management and Budget. Attachment 3 General Reporting Requirements PERIODIC REPORTS (Sec 1201(c)) GENERAL — Notwithstanding any other provision of law, each sponsor shall submit to the FAA periodic reports on the use of the funds provided by the ARRA_ Such reports shall be collected and compiled by the FAA and transmitted to Congress. The sponsors shall take appropriate action to ensure the accuracy and consistency of such reports. CONTENTS OF REPORTS — For each grant receiving funding under the ARRA, the sponsor shall include in the periodic reports information tracking - (A) the amount of Federal funds appropriaie4 allocate4 obligated, and outlayed under the appropriation; (B) the number of projects that have been put out to bid under the appropriation and the amount of Federal funds associated with such projects; (C) the number of projects far which contracts have been awarded under the appropriation and the amount of Federal funds associated with such contracts; (D) the number ofprojects for which work has begun under such contracts and the amount of Federalfunds associated with such contracts; (E) the number of projects for which work has been completed under such contracts and the amount of Federal funds associated with such contracts; (F) the number of direct, on -project jobs created or sustained by the Federal funds provided far projects under the appropriation and, to the extent possible, the estimated indirect jobs created or sustained in the associated supplying industries, including the manber ofjob-years created and the total increase in employment since the date of enactment of this Act; and (G) for each covered program report information tracking the actual aggregate expenditures by the sponsor for projects eligible for funding under the program during the period beginning on the date of enactment of this Act through September 30, 2010, as compared to the level of such expenditures that were planned to occur during such period as of the date of enactment of this Act. TIMING OF REPORTS. —Each grant recipient shall submit the first of the periodic reports required under this subsection not later than 90 days after the date of enactment of this Act and shall submit updated reports not later than 180 days, I year, 2 years, and 3 years after such date of enactment. Attachment 4 Davis Bacon Act vs ARRA Wape Rate Requirements American Recovery and Reinvestment Davis -Bacon Act Requirements Act of 2009 (40 U.S.C. 276a-2762-7) Wage Rate Requirements Applies to "every contract... which requires or Applies to "all laborers and mechanics employed by involves the employment of mechanics and/or contractors and subcontractors;' laborers " Applies to contracts "to which the United States or the Applies to " ...projects funded directly by or assisted in District of Columbia is a party." whole or in part by and through the Federal Government' Workers must be "employed directly upon the site of No requirement for direct employment on the site of the work:' work. Applies to "every contract in excess of $2,000... " No minimum dollar value. Applies to "every contract... for construction, "Projects" (not specific to construction, alteration, and/or alteration, and/or repair, including painting and repair). decorating..:' Work conducted on "public buildings or public works No limitation to Public Buildings or Public Works of the of the United States or the District of Columbia" U.S. or D.C. Work conducted `within the geographical limits of the No geographical limits. States of the Union or the District of Columbia" Must pay wage rates not less than those determined by Must pay wage rates not less than those determined by the the Secretary of Labor to be prevailing for type of Secretary of Labor in accordance with 40 USC 3141 — work, labor category and location. 3148 (Wage Rate Requirements)• Monthly Expense Report - February'09 Check Requests During Month Approved Check Requests 2/22009 Blueglobes LLC (Runway Lights) 222009 Walker Welding (Snow Plow Blade) 2/32009 Hawkeye Fire & Safety (Fire Extinguisher Refill) 2/42009 Hangar H (Heating) 2142009 Jet Air (Parts Reimbursement - snow blower) 2/182009 Backflow Prevention Services (Annual Backilow tests) 2/192009 S&G Materials (Send) 2242009 AECOM Runway 7-25/12.30 Rehab Design 2242009 AECOM Runway 7.25 Reconstruct 2242009 AECOM Runway 7-25 Extension Paving & Lighting Capital Projects Pending Expenses Airport Operating Expenses City CIP Fund Expenses Total Expenses Construction Contracts South Economic Study - ALP Update South T-Hangar Taxilane Runway 7-25 Paving United Hangar Runway 7-25 Reconstruct and Alternate North T-Hangar Taxilane Rehab Total Pending Expenses Airport Funds CIP Funds $543.92 $308.25 $30.50 $505.00 $28.61 $582.50 $50.35 $20,916.00 $2,660.75 54,057.84 52,049.13 $27,634.59 $29,683.72 _Project Bid Amount Paid During Month Paid During FiscalYear Paid To Date %Paid $15,000.00 $1,291.95 $13,726.07 91.5 $140,794.15 $98,935.64 $98,935.64 70.3 $1,347,586.13 $385,360.59 $1,341,228.72 99.5 $103,060.00 $94,562.69 $94,562.69 91.8 $1,449,848.70 $1,347,843.15 $1,347,843.15 93.0 $163,726.00 $153,843.43 $153,843.43 94.0 $0.00 $0.00 E%PE: 03.09.09 11:04:37 Account -------------------------------- ---------- 7600 Airport AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 412000 Perm Part Time 413000 Temporary Employees Total REGULAR SALARIES & WAGES OTHER WAGES 414100 Overtime Wages 414300 Term -Vacation Pay 414400 Term -Sick Leave 414500 Longevity Pay Total OTHER WAGES Page: 1 Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 YTD Period Appropriated Expenditures Expenditures Encumbrance Balance o Used -------- ------------ ------------ ------------------------------------ ------ Total SALARIES & WAGES EMPLOYEE BENEFITS GROUP INSURANCE 421100 Health Insurance 421200 Dental Insurance 421300 Life Insurance 421400 Disability Insurance 421500 Unemployment Compensation Total GROUP INSURANCE SOCIAL SECURITY CONTRIBUTIONS 422100 FICA Total SOCIAL SECURITY CONTRIBUTIONS RETIREMENT CONTRIBUTIONS 423100 IPERS Total RETIREMENT CONTRIBUTIONS 38611.00 17790.38 20820.62 46.08 22603.00 18288.71 2206.80 4314.29 80.91 10000.00 4968.89 5031.11 49.69 ------------ ------------ 71214.00 ------------ 41047.98 ------------ 2206.80 ------------ 30166.02 ------ 57.64 1000.00 473.28 526.72 47.33 1251.50 -1251.50 1720.57 -1720.57 1050.00 437.50 612.50 41.67 ------------------------ 2050.00 ------------ 3882.85 ------------ ------------ -1832.85 ------ 189.41 ------------------------ 73264.00 ------------ 44930.83 ------------ 2206.80 ---------- 28333.17 ------ 61.33 7280.00 3789.32 285.62 3490.68 52.05 490.00 234.92 17.70 255.08 47.94 198.00 138.33 9.93 59.67 69.86 460.00 104.73 13.62 355.27 22.77 832.00 272.00 -832.00 ------------ ------------ 8428.00 ------------ 5099.30 ------------ 598.87 ------------ 3328.70 ------ 60.50 5605.00 3355.65 161.10 2249.35 59.87 ------------------------ 5605.00 ------------ 3355.65 ------------ 161.10 ------------ 2249.35 ------ 59.87 4652.00 2455.51 140.14 2196.49 52.78 ------------------------ 4652.00 ------------ 2455.51 ------------ 140.14 ------------ 2196.49 ------ 52.78 EXPE: 03.09.09 11:04:37 Page: 2 Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 YTD Period Account Appropriated Expenditures Expenditures encumbrance Balance 1 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 BBNBFITS Total EMPLOYEE BBNBFITS PROFESSIONAL i TECHNICAL SERVICES PROFESSIONAL SERVICES 432020 Annual Audit 432060 Consultant Services 432070 Management Services Total PROFESSIONAL SERVICES DATA AND COMMUNICATION SERVICES 435056 Delivery Services 435060 Legal Publications Total DATA AND COMMUNICATION SERVICES TRAINING i EDUCATION 436030 Transportation 436050 Registration 436060 Lodging 436080 Meals Total TRAINING i EDUCATION INSURANCE 437010 Comp Liability Insurance 437020 Fire i Casualty Insurance 437030 Mocker's Comp Insurance 437041 Bonding i Other Insurance 437042 Fidelity Bond 437200 Loss Reserve Payment ------------ ------------ ------------------------ 137.50 ------------ -137.50 ------ ------------ ------------ 18685.00 ------------ ------------ 11047.96 900.11 ------------ 7637.04 ------ 59.13 554.00 927.63 -373.63 167.44 5000.00 5000.00 9000.00 4500.00 4500.00 50.00 ------------------------ 14554.00 ------------ ------------ 5427.63 ------------ 9126.37 ------ 37.29 36.98 -36.98 12.00 190.46 -178.46 1587.1 ------------------------ 12.00 ------------ ------------ 227.44 ------------ -215.44 ------ 1895.3 900.00 900.00 400.00 400.00 500.00 500.00 150.00 150.00 ------------------------------------------------------- ------ 1950.00 1950.00 8578.00 5000.00 3578.00 58.29 16893.00 9640.03 7252.97 57.07 73.00 90.00 -17.00 123.29 928.00 875.00 875.00 53.00 94.29 5000.00 5000.00 E%PE: 03.09.09 11:04:37 Account Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 YTD Period Appropriated Expenditures Expenditures Encumbrance -------------------------- ----------------------------------------------- ------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) INSURANCE (CONTINUED) Total INSURANCE UTILITY SERVICES 438010 Stormwater Utility Charges 438030 Electricity 438070 Heating Fuel/Gas 438080 Sewer Utility Charge 438090 Water Utility Charge 438100 Refuse Collection Charges 438110 Local Phone Service 438120 Long Distance Service 438130 Wireless Phone Service Total UTILITY SERVICES Total PROFESSIONAL & TECHNICAL SERVICES REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building Repair & Maintena 442020 Structure Repair & Maintenance S 442030 Heating Equipment Repair & Maint 442040 Cooling Equipment Repair & Maint 442060 Electrical & Plumbing Repair & M 442070 Bldg Pest Control Services Total BUILDING REPAIR & MAINTENANCE SERVICE EQUIPMENT REPAIR & 1AINTENANCE SERVICES 443050 Radio Equipment Repair & Mainten 443080 Other Equipment Repair & Mainten ----------------------- ------------------------ 31472.00 15605.03 875.00 7104.00 5435.68 591.96 15530.00 8238.36 1224.80 8680.00 6059.51 1905.04 1475.00 1170.32 95.44 1321.00 1024.14 89.20 1200.00 767.00 74.00 264.00 517.84 79.54 30.00 34.56 5.94 -3.45 35604.00 23243.96 4065.92 ------------------------ -------------------- 83592.00 44504.06 4940.92 7500.00 7216.03 4000.00 4460.27 500.00 1657.80 505.00 1959.00 449.23 500.00 255.65 431.00 271.60 33.95 ------------------------ 14890.00 ------ ------ -------- 14310.58 538.95 1600.00 813.00 1299.30 880.78 Page: 3 Balance % Used --------- ------ 15866.97 49.58 1668.32 76.52 7291.64 53.05 2620.49 69.81 304.68 79.34 296.86 77.53 433.00 63.92 -253.84 196.15 -4.56 115.20 3.45 -------- ------ 12360.04 65.28 -------- ------ 39087.94 53.24 283.97 96.21 -460.27 111.51 -1157.80 331.56 1509.77 22.93 244.35 51.13 159.40 63.02 579.42 96.11 1600.00 -486.38 159.83 ------------ ------------------------------------------------ ------ Total EQUIPMENT REPAIR & MAINTENANCE SERVIC 2413.00 1299.39 880.78 1113.62 53.85 E%PE: 03.09.09 11:04:37 Page: 4 Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 YTD Period Account Appropriated expenditures Expenditures Encumbrance ---------------------------------------------------------------------------- - ---- ------- ------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR 6 MAINTENANCE (CONTINUED) TECHNICAL SERVICES 445030 Nursery Service -Lawn and Plant C 445080 Snow and Ice Removal 445110 Testing Services 445140 Outside Printing 445230 Other Technical Services Total TECHNICAL SBRVICBS INTRA-DEPARTMENT SBRVICBS 446100 City Attorney Chargeback 446130 ITS-PC/Peripheral Support Charge 446140 ITS -Computer Replacement Chargeb 446160 ITS-Network/Internet Chargeback 446200 Photocopying Chargeback 416220 Phone Service Chargeback 446280 Telecom Move/Add/Change Chargeba 446300 Phone Equipment/Line Chargeback 446320 Nail Chargeback 446350 City Vehicle Replacement Chargeb 446370 Fuel Chargeback 446380 Vehicle Repair 6 Maintenance Cha Total INTRA-DEPARTMENT SERVICES MISCELLANEOUS SBRVICBS 6 CHARGES 449055 Permitting Fees 449060 Dues 6 Memberships 449120 Equipment Rental 449140 Tools Rental 449360 Interest Expense Total MISCELLANEOUS SBRVICBS 6 CHARGES Balance t Used --------- ------ 300.00 300.00 12500.00 4500.00 -12500.00 1900.00 1205.10 582.50 694.90 63.43 139.00 374.00 -235.00 269.06 5121.00 5121.00 ------------------------ 7460.00 ------------ 14079.10 ---------- 5082.50 ------------ -6619.10 ------ 188.73 4036.00 1768.96 2267.04 43.83 400.00 400.00 100.00 633.00 422.24 52.78 210.76 66.70 360.00 240.00 30.00 120.00 66.67 455.00 232.26 222.74 51.05 612.00 385.12 48.14 226.88 62.93 44.00 -44.00 913.00 620.00 77.50 293.00 67.91 706.00 400.97 28.02 305.03 56.79 14176.00 9290.40 1161.30 4885.60 65.54 4961.00 3734.13 135.22 1126.87 76.82 3516.00 ------------ 3996.17 920.74 -480.17 113.66 ------------ 30668.00 ------------ 21534.25 ------------ 2453.70 ------------ 9133.75 ------ 70.22 65.00 -65.00 525.00 625.00 -100.00 119.05 250.00 250.00 250.00 250.00 61294.00 ----------- 30596.68 3824.59 30697.32 49.92 ------------ 62319.00 ------------ 31286.68 ------------- 3824.59 -------_-- 31032.32 ------ 50.20 EXPE: 03.09.09 11:04:37 Page: 5 Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 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 OTHER PURCHASED SERVICES (CHANGE TO OFFICE SO GENERAL SUPPLIES 452010 Office Supplies 452030 Minor Office Equipment/Furniture 452040 Sanitation & Industrial Supplies Total GENERAL SUPPLIES BOORS & PERIODICALS 454020 Subscriptions 454040 Books, Magazines, Newpapers Total BOOKS & PERIODICALS COMPUTER & PRINTING SUPPLIES 455110 Software 455120 Misc Computer Hardware Total COMPUTER & PRINTING SUPPLIES Total OTHER PURCHASED SERVICES (CHANGE TO OFF OPERATING SUPPLIES AGRICULTURE SUPPLIES 461040 Other Agriculture Chemicals Total AGRICULTURE SUPPLIES CHEMICAL & LAB SUPPLIES 463200 Other Chemicals & Supplies Total CHEMICAL & LAB SUPPLIES -------------------- ------------ ------------ ------------ ------ 117750.00 82509.99 12780.52 35240.01 70.07 859.00 461.83 397.17 53.76 642.00 642.00 1821.00 500.00 500.00 1321.00 27.46 ----------------------------------------------• ------------ -- 3322.00 961.83 500.00 2360.17 28.95 1870.00 2036.00 ------------ ------------ 1870.00 2036.00 -166.00 108.88 -166.00 108.88 91.00 91.00 -91.00 500.00 500.00 -------------------------- -- --------------------- --- 500.00 91.00 91.00 409.00 18.20 ------------ ------------ ----------•- ------------ ------------ ------ 5692.00 3088.83 591.00 2603.17 54.27 364.00 364.00 ------------ ------------ ------------ ------------------------ ------ 364.00 364.00 199.98 -199.9E ----------------------- ------------ ----•------------------- -- 199.98 -199.9E EXPE: 03.09.09 11:04:37 Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 YTD Period Account Appropriated Expenditures Expenditures 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) FUELS & LUBRICANTS 465020 Gasoline 465060 Lubricants Total FUELS & LUBRICANTS REPAIR & MAINTENANCE SUPPLIES 466020 Lumber/Hardware 466030 Paint Supplies 466040 Plumbing Supplies 466050 Electrical Supplies 466060 Other Construction Supplies 466070 Other Maintenance Supplies Total REPAIR & MAINTENANCE SUPPLIES EQUIPMENT REPAIR & MAINTENANCE SUPPLIES 467020 Equipment Repair & Maintenance S 467160 Other vehicle Repair & Maintenan Total EQUIPMENT REPAIR & MAINTENANCE SUPPLI SURFACING MATERIALS 468020 Concrete 468030 Asphalt 468050 Sand Total SURFACING MATERIALS OTHER SUPPLIES & EQUIPMENT 169040 Traffic Control Improvement Supp 469190 Minor Equipment 169210 First Aid/Safety Supplies 469260 Fire Ext & Refills 469320 Miscellaneous Supplies 469360 Food and Beverages Page: 6 Encumbrance Balance 4 Used ------------------------ ------ 133.52 -133.52 101.00 ------------------- 101.00 101.00 ----------------------- 133.52 ------------ -32.52 ------ 132.20 27.01 -27.01 23.00 23.00 6.00 6.00 349.00 19.53 329.47 5.60 838.00 838.00 589.00 ------------------- 69.38 519.62 11.78 1805.00 ------------------------ 115.92 ------------ 1689.08 ------ 6.42 650.00 650.00 73.00 ------- ------------ 73.00 723.00 ------------------------ ------------ 723.00 ------ 153.00 153.00 600.00 600.00 54.00 54.00 ------------ ------------ ------------ ------------------------ ------ 807.00 807.00 106.00 106.00 888.00 99.00 789.00 11.15 57.00 57.00 111.00 78.50 32.50 70.72 53.95 -53.95 85.53 -85.53 E%PE: 03.09.09 11:04:37 Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 YTD Period Account Appropriated Expenditures Expenditures Encumbrance ------------------------------------------------------------------- ------------------------------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) OTHER SUPPLIES & EQUIPMENT (CONTINUED) Total OTHER SUPPLIES & EQUIPMENT Total OPERATING SUPPLIES IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements Total IMPROVEMENTS OTBER THAN BUILDING OTHER FINANCIAL USES 490150 Operating Subsidy 490160 Misc Transfers Out 490190 Interfund Loan Total OTHER FINANCIAL USES Total Airport Operations Total Airport Page: 7 Balance o Used ------------ ------ ------------ ------------ 1162.00 ------------ 316.98 ------------ ------------ 845.02 ------ 27.28 ------------ ------------ 4962.00 ------------ 766.40 ------------ ------------ 4195.60 ------ 15.45 32000.00 8114.00 23886.00 25.36 ------------------------ 32000.00 ------------ 8114.00 ------------ ------------ 23886.00 ------ 25.36 8359.00 5572.64 696.58 2786.36 66.67 7187.88 -7187.88 56426.00 ------------ 15483.36 1935.42 40942.64 27.44 ------------ 64785.00 ------------ ------------ 28243.88 ------------ 2632.00 ------------ 36541.12 ------ 43.60 ------------ 400730.00 ------------ 223205.95 ------------ 24051.35 ------------ 177524.05 ------ 55.70 ------------------------ 400730.00 ------------ 223205.95 ------------ 24051.35 ------------ 177524.05 ------ 55.70 E%PE: 03.09.09 11:04:37 Account --------------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) "' GRAND TOTAL +t* Page: 8 Iowa City General Ledger System FY 2009 Expense Reporting For the period 02.01.09 to 02.28.09 YTD Period Appropriated Expenditures Expenditures Encumbrance Balance 1 Used -------- ------------------------ ------------ ------------------------ - ------------ ------------------------------------ ------------ ------ 400730.00 223205.95 24051.35 177524.05 55.70 RRVE: 03.09.09 11:05:24 Account ------------------------------------------ 7600 Airport CONTRIB & DONATIONS 362100 Contrib & Donations Page: 1 Iowa City General Ledger System FY 2009 Revenue Reporting For the period 02.01.09 to 02.28.09 Estimated YTD Period Revenue Revenue Revenue Remainder 8 --------------------------------- ------------------------ ------------ ---- Total CONTRIB & DONATIONS OTHER MISC REVENUE 369100 Reimb of Expenses 369900 Miscellaneous Other Income Total OTHER MISC REVENUE INTEREST REVENUES 381100 Interest on Investments Total INTEREST REVENUES RENTS 382100 Land Rental 382200 Building/Room Rental Total RENTS ROYALTIES & COMMISSIONS 384200 Vending Machine Comm 384900 Other Commissions Total ROYALTIES & COMMISSIONS TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES Total TRANSFERS Total Airport *** GRAND TOTAL ttt 250.00-250.00 ------------------------ ------------------------ ------ 250.00-250.00 7187.88-7187.88 -30.00 ------------ ------------ ------------ ------ 7187.88 -30.00-7187.88 1000.00 1077.48 79.63 -77.48 107.75 ----------------------- 1000.00 ------------ 1077.48 ------------ 79.63 -77.48 ------ 107.75 30700.00 1957.04 238.93 28742.96 6.37 226000.00 142645.33 12636.00 83354.67 63.12 ------------------------ 256700.00 ------------ 144602.37 ------------ 12874.93 112097.63 ------ 56.33 168.00 46.80 20000.00 12402.80 ----------------------- 20168.00 12449.60 10.80 121.20 27.86 7597.20 62.01 ----- ------------ ------ 10.80 7718.40 61.73 130000.00 96666.64 10833.33 43333.36 66.67 ------------------------ 130000.00 ------------ 86666.64 10833.33 ------------ 13333.36 ------ 66.67 ------------------------ 130000.00 ------------ 86666.64 10833.33 ------------ 43333.36 ------ 66.67 ------------------------ 407868.00 ------------ 252233.97 23768.69 ------------ 155634.03 ------ 61.84 ------------ ------------ 407868.00 ------------ 252233.97 ------------ 23769.69 155634.03 ------ 61.84 TRID: 03.09.09 11:06:04 Page: 1 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Trans Date Trans Type Report& Source Description Debit Credit ----------- ---------- ------------------------------------------------------------------------------- 7600 Airport 560100 Airport Operations 412000 Perm Part Time 02.13.09 Old Sys 090211010011 489344\CIC PAYROLL RBCAP\PAYROLL 13 02.27.09 Old Sys 090225010011 489585\CIC PAYROLL RECAP\PAYROLL 27 Total Perm Part Time 421100 Health Insurance 02.17.09 Journal 090220151604 007441 FEB HEALTH INSORANCB\CIC HEALTH INS Total Health Insurance 421200 Dental Insurance 02,17.09 Journal Total Dental Insurance 421300 Life Insurance 02.01.09 Journal 1103.40 1103.40 -------............ 2206.80 285.62 285.62 090220151604 007440 FEB DENTAL INSURANCE\CIC DENTAL INS 17.70 ------------ 17.70 090220151604 007442 FEB LIFE INSURANCB\CIC LIFE INSURAN 9.93 ------------ ------------ Total Life Insurance 9.93 421400 Disability Insurance 02.18.09 New Vouch 090219030013 06718795 Check:640489\NADISON NATIONAL LIFE 13.62 ------------------------ Total Disability Insurance 13.62 421500 Unemployment Compensation 02.11.09 New Vouch 090212030211 06718198 Check:640340\IOWA WORKFORCE DEVELOP 272.00 ------------ ------------ Total Unemployment Compensation 422100 FICA 02.13.09 Old Sys 090211010011 02.27.09 Old Sys 090225010011 Total FICA 423100 IPBRS 02.13.09 Old Sys 090211010011 02.27.09 Old Sys 090225010011 272.00 2130599\FICA\CITY CONTRIBUTION 80.55 2270599\FICA\CITY CONTRIBUTION 80.55 ------------ 161.10 2133599\IPERS\CITY CONTRIBUTION 70.07 2173599\IPBRS\CITY CONTRIBUTION 70.07 TRID: 03.09.09 11:06:04 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02,28.09 Trans Date Trans Type Report# Source Description --------------------- ------------ -------- ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 423100 IPERS (CONTINUED) Total IPBRS 437041 Bonding & Other Insurance 02.11.09 New Vouch 090212030211 06718098 Check:640317\AW WELT AMBRISCO INSUR Total Bonding & Other Insurance 438010 Stormwater Utility Charges 02.18.09 Journal 090220151604 007439 057-095-03\STORMWTR\2.18.09 Bill Da Total Stormwater Utility Charges 438030 Electricity 02.18.09 New Vouch 02.18.09 New Vouch 02.18.09 New Vouch 02.18.09 New Vouch Total Electricity 439070 Heating Fuel/Gas 02.18.09 New Vouch 02.18.09 New Vouch 02.18.09 New Vouch 02.18.09 New Vouch Total Heating Fuel/Gas 438080 Sewer Utility Charge 02.18.09 Journal 02.18.09 Journal 02.18.09 Journal 02.18.09 Journal 090219030013 06718674 Check:640498\MIDAMERICAN ENERGY\ELE 090219030013 06719711 Check:640497\MIDAMBRICAN ENERGY\ELE 090219030013 06718714 Check:640497\MIDAMERICAN ENERGY\ELE 090219030013 06718715 Check:640497\MIDAMBRICAN ENERGY\ELE Page: 2 Debit Credit ------------ ------------ 140.14 875.00 ------------------------ 875.00 591.96 ------------------ 591.96 99.32 799.77 117.21 208.50 ------------------------ 1224.80 090219030013 06718673 Check:640498\lIIDAMERICAN ENERGY\GAS 10.00 090219030013 06718683 Check:640497\MIDAIIERICAN BNBRGY\GAS 443.16 090219030013 06718712 Check:640497\MIDAMBRICAN ENERGY\GAS 1128.72 090219030013 06718713 Check:640497\MIDAMBRICAN ENERGY\GAS 323.16 ------------ ------------ 1905.04 090220151604 007439 057-120-00\SEWER\2.18.09 Bill Date 27.10 090220151604 007439 057-115-00\SEWER\2.18.09 Bill Date 8.15 090220151604 007439 057-117-00\SEWER\2.18.09 Bill Date 40.07 090220151604 007439 057-118-03\SEWER\2.18.09 Bill Date 20.12 ------------ Total Sewer Utility Charge 95.44 TRID: 03.09.09 11:06:04 Trans Date Trans Type ----------- ---------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 438090 Water Utility Charge 02.18.09 Journal 02.18.09 Journal 02.18.09 Journal 02.18.09 Journal 02.18.09 Journal Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Reports Source Description --------- -------- ----------------------- Debit 090220151604 007439 057-120.00\NATBR\2.18.09 Bill Date 20.61 090220151604 007439 057-118-03\WATER\2.18.09 Bill Date 15.38 090220151604 007439 057-095-03\WATER\2.18.09 Bill Date 6.41 090220151604 007439 057-115-00\WATBR\2.18.09 Bill Date 16.47 090220151604 007439 057-117-00\WATBR\2.18.09 Bill Date 30.33 Page: 3 Credit ------------ ............ Total Water Utility Charge 89.20 438100 Refuse Collection Charges 02.13.09 New Vouch 090216030021 06718428 Check:640571\ALLIED WASTE SERVICES\ 74.00 ------------------------ Total Refuse Collection Charges 74.00 438110 Local Phone Service 02.11.09 New Vouch 090212030211 06718102 Check:640339\IOWA TELECOM COMMUNCIA 79.54 Total Local Phone Service 438120 Long Distance Service 02.02.09 Ph Lon Dst 090302104830 00002019 FEB LONG DIST CHGBB Total Long Distance Service 412030 Heating Equipment Repair 6 Maintenance 02.11.09 New Vouch 090212030211 06718129 Check:640204\LA19 COMPANY INC\HANG Total Heating Equipment Repair 6 Maintenance Be 142070 Bldg Pest Control Services 02.11.09 New Vouch 090212030211 06718179 Check:640187\HANKBYE PEST COBTROL I Total Bldg Pest Control Services 443080 Other Equipment Repair 6 Maintenance Se 02.11.09 New Vouch 090212030211 06718111 Check:640200\JET AIR INC\RRPAIR TO 02.11.09 New Vouch 090212030211 06718112 Check:640273\WALKER WELDIMG\BLADE F 02.11.09 New Vouch 090212030211 06718239 Check:640153\BLUEGLOBES LLC\RUNWAY 02.11.09 New Vouch 090212030211 06718240 Check:640153\BLUBGLOBBS LLC\RUNWAY ------------ ------------ 79.54 5.94 ------------ ------------ 5.94 505.00 ------------ ------------ 505.00 33.95 ------------ ------------ 33.95 28.61 308.25 139.32 104.60 TRID: 03.09.09 11:06:04 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Trans Date Trans Type Report@ Source Description ----------- ---------- -------------------- ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 443D80 Other Equipment Repair & Maintenance Se Page: 4 Debit Credit ------------ ------------ Total Other Equipment Repair & Maintenance Sery 880.78 445080 Snow and Ice Removal 02.13.09 New Vouch 090216030021 06718361 Check:640479`JET AIR INC\SNOW REMOV 4500.00 ------------ ------------ Total Snow and Ice Removal 4500.00 445110 Testing Services 02.19.09 New Vouch 090220030125 06718823 Check:641188\BACEFLOW PREVENTION SE 582.50 ------------------------ Total Testing Services 582.50 446140 ITS -Computer Replacement Chargeback 02.01.09 IT Repl 090212144031 00002025 FEB ITS REPL CHGBCE 52.78 ------------ ------------ Total ITS -Computer Replacement Chargeback 52.78 446160 ITS-Network/Internet Chargeback 02.01.09 IT Int/Nwk 090203133515 00002031 FEB ITS NETW/INTRNET 30.00 Total ITS-Network/Internet Chargeback 446220 Phone Service Chargeback 02.13.09 Qwest Chrg 090213142619 00002032 Feb Qwest Charges Total Phone Service Chargeback 446300 Phone Equipment/Line Chargeback 02.02.09 Ph Equipmt 090302104830 00002018 FEB PEON EQUIP CHGBE Total Phone Equipment/Line Chargeback 446320 Mail Chargeback 02.01.09 Mail 090206124733 00200046 JAN POSTAL CHARGES Total Mail Chargeback 30.00 48.14 ----------------- 48.14 77.50 ------------------------ 77.50 28.02 ------------ ------------ 28.02 TRID: 03.09.09 11:06:04 Page: 5 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Trans Date Trans Type --------------------- Report# ------------ Source Description Debit Credit 7600 Airport (CONTINUED) -------- -- ----------------------------------- ------------ 560100 Airport Operations (CONTINUED) 446350 City Vehicle Replacement Chargeback 02.28.09 SQ Repl 090304111515 00002006 FEB REPLACEMENT COST 1161.30 Total City Vehicle Replacement Chargeback ------------ 1161.30 ------------ 446370 Fuel Chargeback 02.28.09 BQ Div 090304111515 00002008 FEB DIVISION FUEL 135.22 Total Fuel Chargeback ------------ 135.22 ------------ 446380 Vehicle Repair & Maintenance Chargeback 02.28.09 EQ Div 090304111515 00002008 FEB DIVISION SERVICE 920.74 Total Vehicle Repair & Maintenance Chargeback ------------ 920.74 ------------ 449360 Interest Expense 02.28.09 Journal 090220151604 007448 Corp Hangar Loan Int\Feb Interfund 1904.56 02.28.09 Journal 090220151604 007448 Airprt SE Hangar Int\Feb Interfund 991.02 02.28.09 Journal 090220151604 007448 Airprt SW Hangar-Int\Feb Interfund 929.01 Total Interest Expense ------------ 3824.59 ------------ 452040 Sanitation fi Industrial Supplies 02.13.09 New Vouch 090216030021 06718360 Check:640479\JET AIR INC\CLEANING S 500.00 Total Sanitation fi Industrial Supplies ------------ 500.00 ------------ 455110 Software 02.28.09 Journal 090220151604 007449 Adobe 8.0 Air Tharp\Interdepartment 91.00 Total Software ------------ 91.00 ------------ 490150 Operating Subsidy 02.28.09 Journal 090220151604 007444 Econ Dev Coord 101\Feb Budgeted Tra 696.58 Total Operating Subsidy ------------ 696.58 ------------ 490190 Interfund Loan 02.28.09 Journal 090220151604 007448 Corp Hangar Loan Prn\Feb Interfund 1095.44 02.28.09 Journal 090220151604 007448 Airprt SE Hangar Prn\Feb Interfund 338.98 TRID: 03.09.09 11:06:04 Page: 6 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ ---------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) 02.28.09 Journal 090220151604 007448 Airprt 811 Hangar-Prn\Feb Interfund 501.00 Total Interfund Loan Total Airport Operations 1935.42 ------------------------ 24051.35 TRID: 03.09.09 11:06:04 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28,09 Trans Date Trans Type Report! Source Description ----------- ------------------------------ -------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) Total Airport Page: 7 Debit Credit -------- ----- ------ 21051.35 TRID: 03.09.09 11:06:04 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Page: 8 Trans Date Trans Type Report# Source Description Debit Credit ----------- ----------------------------------------------------------------------------- ------------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) ------------ ------------ +++ GRAND TOTAL +++ 24051.35 ------------------------ ------------------------ TRID: 03.09.09 11:06:19 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Page: 1 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- -------------------- ------------------------ ----------- ------------ ------------ 7600 Airport 560100 Airport Operations 369900 Miscellaneous Other Income 02.28.09 Journal 090304160748 007459 HERTZ PARKING\ACCOUNT CODE CORRECTI Total Miscellaneous Other Income 381100 Interest on Investments 02.28.09 Allocation 090306114317 Feb interest allocation Total Interest on Investments 382100 Land Rental 02.24.09 Old Sys 090302010012 2241244\ARMY RESERVES\AIRPORT LEASE Total Land Rental 382200 Building/Room Rental 02.02.09 Payment 02,02.09 Payment 02.03.09 Payment 02.03.09 Payment 02.03.09 Payment 02.04.09 Payment 02.04.09 Payment 02.04.09 Payment 02.04.09 Payment 02,05.09 Payment 02.05.09 Payment 02.05.09 Payment 02.05.09 Payment 02.06.09 Payment 02.06.09 Payment 02.06.09 Payment 02.06.09 Payment 02.06.09 Payment 02.09.09 Payment 02.09.09 Payment 090202092824 00012029 1-3\LUST GARY\FEB 09\BANGAR #4 090202092824 00012029 1-3\LOST GARY\FRB 09\RANGAR #21 090203094214 00011960 1-20\SCHNELL TOM\FHB 09\HAHGAR #62 090203094214 00011978 1-31\PATTSCRULL RICHARD\FHB 09\HAN 090203094214 00012011 1-6\DOWNHS 6 ASSOCIATES\FHB 09\BAN G 090204090412 00011962 1-6\HALL ROBBRT\FHB 09\HANGAR 16 090204090412 00011962 1-6\HALL ROBERT\FHB 09\HANGAR #12 090204090412 00011971 1-17\HARTWIG RANDY\FHB 09\HANGAR # 090204090412 00011986 1-9\FARRIS GRHG\FHB 09\HAHGAR #29 090205110624 00011970 1-3\BUTLER JOHNVEB 09\HANGAR 136 090205110624 00011970 1-3\BUTLER JOHN\FHB 09\HANGAR #37 090205110624 00011976 1-1\OCKKNFELS TRANSFER\FEB 09\HANGA 090205110624 00012000 1-2\ROOF KEITH\FRB 09\11ANGAR #32 090206112513 00011952 1-2\BRUMLEY JANHS\FHB 09\HANGAR 12 090206112513 00011979 1-3\NE IA PHYS THRRPY ASSOC\FHB 09\ 090206112513 00011979 1-3\NE IA PHYS THERPY ASSOC\FRB 09\ 090206112513 00012004 1-10\OPERATOR PERFORMANCE LAB\FEB 0 090206112513 00012004 1-10\OPERATOR PERFORMANCE LAB\FEB 0 090209094219 00011483 1.5\BROGAN-COLEMAN KIN\DEC 08\HANG 090209094219 00011711 1-6\BROGAN-COLHMAN KIM\JAN 09\HANG 30.00 ------------------------ 30.00 79.63 ------------ ------------ 79.63 238.93 ------------------------ 238.93 141.00 148.00 174.00 229.00 168.00 141.00 148.00 168.00 148.00 168.00 168.00 204.00 512.00 148.00 198.00 174.00 1330.00 168.00 148.00 148.00 TRID: 03.09.09 11:06:19 Page: 2 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Trans Date ----------- Trans Type Report# ---------- Source Description Debit Credit 7600 Airport (CONTINUED) ------------ -------- ----------------------------------------------- ------------ 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 02.09.09 Payment 090209094219 00011941 1-8\FIELD HOWARD\FEB 09\HANGAR #54 168.00 02.10.09 Payment 090210094039 00011948 1-17\RUYLB JOHN\FEB 09\HANGAR 133 358.00 02.10.09 Payment 090210094039 00011969 1-21\MASCARI RICK\FEB 09\HANGAR #3 149.00 02.10.09 Payment 090210094039 00012003 1-13\POWERS ROBERT\FEB 09\HANGAR # 141.00 02.10.09 Payment 090210094039 00012005 1-14\WIECHHRT RONALD\FRB 09\HANGAR 192.00 02.10.09 Payment 090210094039 00012044 1-25\ROAR BRIAN\FEB 09\HANGAR #19 148.00 02.11.09 Payment 090211095357 00011959 1-25\RANEY CHARLHS\FRB 09\HANGAR # 141.00 02.11.09 Payment 090211095357 00011964 1-15\IOWA CITY FLYING CLUB\FEB 09\H 168.00 D2.11.09 Payment 090211095357 00011968 1-23\HALL DAN\FEB 09\11ANGAR #27 148.00 02.11.09 Payment 090211095357 00011982 1-26\CHALKLEY BEN\FHB 09\HANGAR #1 148.00 02.11.09 Payment 090211095357 00012015 1-14\ALEXIS PARK INN & SUITHS\F8B 0 141.00 02.11.09 Payment 090211095357 00012016 1-19\VRANEK DOUGLAS\FEB 09\HANGAR 141.00 02.11.09 Payment 090211095357 00012021 1-34\HERTZ CORPORATION\FEB 09\OFFIC 300.00 02.11.09 Old Sys 090212010008 2113045\HERTZ CORD\PARKING 330.00 02.12.09 Payment 090212091354 00011687 1-1\FULL JERKY\JAN 09\HANGAR #45 204.00 02.12.09 Payment 090212091354 00011963 1-8\BULGARELLI DAVID\FBB 09\HANGAR 148.00 02.12.09 Payment 090212091354 00011984 1-9\ZUBROD ROY\FEB 09\HANGAR #20 148.00 02.13.09 Payment 090213094718 00011939 89-1\MILLER RICHARD\FBB 09\HANGAR 168.00 02.13.09 Payment 090213094718 00011975 89-4\FISHBAUGH JUSTIN\FRB 09\HANGA 174.00 02.13.09 Payment 090213094718 00011980 89-5\ALLENDER PATRICK\FBB 09\RANGA 169.00 02.13.09 Payment 090213094718 00011987 89-6\EDMONDS TERRY\FEB 09\HANGAR # 313.00 02.13.09 Payment 090213094718 00011996 89-10\SQUA➢RONS UP\FEB 09\HANGAR #5 168.00 02.13.09 Payment 090213094718 00011999 89-11\GURNETT DON\FBB 09\HANGAR #3 310.00 02.13.09 Payment 090213094718 00012009 89-13\SINGLHTARY ROBHRT\FEB 09\HAN 141.00 02.13.09 Payment 090213094718 00012025 89-15\SWANSON NAOMI\FBB 09\HANGER 141.00 02.13.09 Payment 090213094718 00012042 89-17\MEADE JAMES N\FEB 09\HANGAR 148.00 02.13.09 Payment 090213102402 00011977 1-4\1,ACINA DAVE\FEB 09\HANGAR #57 198.00 02.17.09 Payment 090217093247 00011945 1-1\HINKLBY HARRY\F8B 09\11ANGAR #3 404.00 02.17.09 Payment 090217093247 00011945 1-1\HINKLBY HARRY\FEB 09\HANGAR #1 141.00 02.17.09 Payment 090217093247 00012048 1-13\YELDER ROY\FBB 09\HANGAR #18 148.00 02.18.09 Payment 090218093249 00011965 1-27\HOLLY FORREST\FEB 09\HANGAR # 148.00 02.19.09 Payment 090219092033 00011983 1-5\TBARSH DAVID\FBB 09\11ANGAR #41 168.00 TRID: 03.09.09 11:06:19 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Page: 3 Trans Date Trans Type Reportf Source Description Debit Credit ---------------------------------------------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 02.19.09 Payment 090219092033 00012013 1-21\FLANAGAN JANRS\FRB 09\HANGAR 02.23.09 Payment 090223091104 00012009 1-15\SAPPHIRB VISTAS LLC\FEB 09\HAN 02.24.09 Payment 090224093700 00012366 1-18\BRUMLRY JAMBS\MAR 09\HANGAR 8 02.25.09 Payment 090225095816 00012417 1-24\POMRRS ROBBRT\MAR 09\HANGAR 1 02.26.09 Payment 090226091947 00011961 1-8\BOLLHRS JONATHAN\FBB 09\HANGAR 02.26.09 Payment 090226091947 00012376 1-5\HALL ROBRRT\MAR 09\HANGAR H 02.26.09 Payment 090226091947 00012376 1-5\HALL ROBBRT\MAR 09\HANGAR #12 02.26.09 Payment 090226091947 00012388 1-3\SCHMBISER BUSS\MAR 09\HANGAR @ 02.26.09 Payment 090226091947 00012463 1-4\ADVANCED INFONBBRING\PAYMENT 02.26.09 Payment 090226091947 00012468 1-6\POLASKI MICHABL\MAR 09\HANGAR 02.27.09 Payment 090227091059 00012425 1-4\DOMNBS 6 ASSOCIATES\MAR 09\HANG 02.28.09 Journal 090304160748 007459 HERTZ PARKING\ACCOUNT CODE CORRBCTI Total Building/Room Rental 384200 Vending Machine Comm 02.20.09 Old Sys Total Vending Machine Comm 393120 General Levy 02.28.09 Journal Total General Levy Total Airport Operations 090223010009 2203017\AMBRICAN BOTTLING\VHNDING C 090220151604 007444 Airport Prop Tx Supp\Feb Budgeted T 168.00 148.00 148.00 141.00 141.00 141.00 148.00 204.00 110.00 148.00 168.00 30.00 12636.00 10.80 ------------ ------------ 10.80 10833.33 ------------------------ 10833.33 ------------ ------------ 30.00 23798.69 TRID: 03.09.09 11:06:19 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Trans Date Trans Type Report# -Source --------------------------------- ------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) Total Airport Page: 9 Description Debit Credit ---------------------------------------- --------- ------------ ------------ 30.00 23798.69 TRID: 03.09.09 11:06:19 Page: 5 Iowa City General Ledger System Revenues Detail Fy 2009 Detail Reporting For the period 02.01.09 to 02.28.09 Trans Date Trans Type Reportf Source Description Debit Credit --------------------------------- ------------------------------------------- ------------ ------------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) - GRAND TOTAL ------------ tft t*+ 30.00 23798.69