Loading...
HomeMy WebLinkAbout04-18-2013 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, APRIL 18, 2013 - 6:00 P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: 2 min* March 21, 2013 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion / Action: a. Airport Commerce Park 5 min b. Fly Iowa 30 min c. FAA/IDOT Projects: AECOM / David Hughes 15 min i. 7/25 Parallel Taxiway Paving & Lighting ii. Airport Electrical Rehab iii. FY2014 Iowa DOT Grant Application iv. Roofing Rehabilitation 1. Consider a resolution approving engineering services agreement for design and bidding d. Airport "Operations" 20 min i. Strategic Plan -Implementation 1. Review of Strategic Plan ii. Budget iii. Management 1. Operations Specialist Evaluation e. FBO / Flight Training Reports 5 min i. Jet Air ii. Iowa Flight Training f. Subcommittee Reports 5 min i. For April: Economic Development ii. For May: Events g. Commission Members' Reports 2 min h. Staff Report 2 min i. Operations Specialist Evaluation i. Consider a motion to adjourn to executive session to evaluate the professional competency of individuals whose appointment, hiring, performance or discharge is being considered when necessary to prevent needless and irreparable injury to that individuals' reputations and those individuals requested a closed session 5. Set next regular meeting for May 16, 2013 at 6:00 p.m. 6. Adjourn *The times listed in the agenda are the anticipated duration of that particular agenda item. The actual discussion may take more or less time than anticipated Iowa City Airport Commission Agenda and Info Packet 4-19-2013 2 of 68 MINUTES DRAFT IOWA CITY AIRPORT COMMISSION MARCH 21, 2013 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Howard Horan, Chris Ogren, Minnetta Gardinier, Paul Hofineyer Members Absent: Jose Assouline Staff Present: Sue Dulek, Michael Tharp Others Present: Matt Wolford, Philip Wolford, Eric Scott, David Hughes RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None CALL TO ORDER: Tharp noted that due to chair's absence and the secretary's term having expired on February 28, he would act as temporary chair, and he called the meeting to order at 6:07 P.M. a. Hangar L/M Tour: Tharp asked the Commission to move the tour to the first item. Ogren moved to amend the agenda, seconded by Horan. Motion carried 4-0 (Assouline absent). Tharp escorted members and members of the public to the Hangar L and M buildings for a tour and description of the recently completed projects. Members then returned to the conference room for the remainder of the meeting. ELECTION OF OFFICERS: Tharp noted that they need to open the floor for nominations for Chair. Horan nominated Gardinier. Gardinier suggested they nominate Horan. Ogren asked how long Horan has been on the Commission. Horan noted that he has been on the Commission the last 19 years, with three years off at one point. Others asked if he would accept the Chair nomination, to which he responded that he would. Horan moved to nominate Gardinier for Chair; no second given. Motion died. Gardinier moved to nominate Horan for Chair; seconded by Ogren. Motion carried 3-0. (Assouline absent, Horan Abstained) At this point Horan asked for nominations for Secretary. Horan moved to nominate Ogren for Secretary; seconded by Gardinier. Motion carried 3-0. (Assouline absent Ogren Abstained). Ogren asked for a brief rundown of just what this position will entail, and Members responded. APPROVAL OF MEETING MINUTES: Minutes of the February 21, 2013, meeting were reviewed. Ogren stated that under item b, toward the bottom of page 1, "...when there were active," should read "...when they were active." Also, the last line of item b, "...when they a couple days away," should be "...when they are a couple days away." Moving to the last page, Ogren noted under j, "...let people know about these and upcoming availability for the Commission." She questioned what this was meant to be. Tharp stated that at this time they were talking about the open seats on the Commission and recruiting new Members. Tharp will review this to be sure. Ogren then noted Iowa City Airport Commission Agenda and Info Packet 4-19-2013 3 of 68 on page 2, under item e, she questioned it having David Hughes' name here since he was not able to make the meeting. Dulek noted that the agenda has his name on it and that the minutes are taken from this. She also noted that the wording does show Hughes was absent. Ogren moved to approve the minutes as amended; seconded by Horan. Motion carried 4-0, Assouline absent. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: b. Airport Commerce Park — Tharp noted that Edberg is not present this evening. Dulek added that Carousel Motors has submitted building plans now, so the last two lots are now beginning to see some progress. She added that there is one issue going before Council regarding an access easement, but that this will most likely move forward with no problems. Gardinier asked if there has been any interest in the remaining lots. Tharp stated that there has not been any, to his knowledge. C. Fly Iowa — Ogren stated that she believes they need to make an official decision on this event if they are going to host it or not. She asked new Member, Hofineyer, if he was familiar with this event and she briefly filled him in on what has taken place so far. Gardinier noted that McDonald did send her an email recently, asking if there was interest by Iowa City to host the 2014 Fly Iowa event. She stated that she responded that there was interest, but that they needed to get some solid commitments. She added that she believes each of them needs to take on some role to make this event happen. Horan asked if Gardinier and Ogren could identify the major tasks that need to be done. Members continued to discuss the Fly Iowa event, with Gardinier and Ogren asking others to step forward and play a part in the planning for this. Jet Air also verbalized their interest in taking a part in this. Gardinier added that raising money will also be an issue. She asked if Jet Air would be willing to contribute, such as they did with the Air Race Classic event. The conversation continued with members discussing what all will need to be done in order to host this event. Contacting local groups, such as the Barnstormers, is something that Gardinier has done to see if they would like to collaborate on this event. Gardinier stated that she did hear back from the Barnstormers group and that they would be interested in some capacity. Horan asked if they shouldn't break down the tasks so they can get a feel for just what they will need to do. There was a list around from the 2001 event that Tharp will attempt to locate. Gardinier began to break down some of the areas as she remembers them: youth aviation piece — Deb Dunkcase would be able to handle this piece. Media — they need to get people from the media involved, such as Chuck Peters who owns the Gazette, as he is a pilot. Other ideas for collaboration were to get someone from the City involved, as well as the Fire Department and Police Department, and others around the community from various backgrounds engaged, as well. Another idea was to contact Rockwell Collins and request flight simulators and possibly even a grant to help with the financing. Iowa City Airport Commission Agenda and Info Packet 4-19-2013 4 of 68 The discussion continued, with Members looking at every aspect of hosting the 2014 Fly Iowa event. Parking at the Fairgrounds with some type of shuttle to the Airport was one issue raised. Tharp stated that he could make some calls to see if the Fairgrounds was available. Members agreed that at this point they need to give an official `yes,' review the contract, and get a committee together for the Fly Iowa 2014 event. Tharp suggested having McDonald to the next meeting to answer Members' questions and to get things rolling. Gardinier suggested they wait another meeting, until they have time to review all of the data they have thus far. She will get this information together and can also create more of a committee structure for the next meeting, as well. Members agreed with this plan of action. d. FAA/IDOT Projects: AECOM / David Hughes i. 7/25 Parallel Taxiway Paving & Lighting — Hughes stated that hopefully one day soon it will stop snowing and the ground will thaw out. They have been in contact with the contractor and are getting things laid out, but it all depends on the weather. Horan asked what the next step is, and Hughes responded briefly. Gardinier stated that she noticed some cracks starting in the paving by her hangar. Hughes noted that this is something they need to discuss, as far as DOT maintenance money, as it does need some maintenance in this area. Jet Air will look into this further, to sweep away the chunks of asphalt. ii. Airport Electrical Rehab — On this item Hughes noted there are several punchlist items that need to be finished up before they can release this, but this is also weather -dependent. iii. FY2014 Iowa DOT Grant Application — Hughes stated that he has been working with Tharp on this. They have come up with a list of several items. This is due in early May. Tharp stated that by next meeting they will have this formalized. One of the main items is the fuel tank repainting and rehab; overlaying the north -south taxiway after the other rehabs are complete; and then rehabbing the pavement around the hangars. Tharp continued, explaining the various items that need to be addressed in this application. Ogren asked for some clarification of the local match amounts and Tharp explained how this is typically handled. Members continued to discuss the grant application and the projects that could be covered under this. Tharp stated that they will put together several options, depending on the money available, and should have something for Members to approve at the next meeting. The deadline is May 9`n e. Airport Operations i. Strategic Plan — Implementation — Tharp noted that he doesn't have anything new here to share. Going back to this topic, Gardinier asked if there has been a serious discussion regarding this plan lately. Tharp noted that there has not been. She suggested they review this yearly and perhaps move a project or two forward. Members agreed to add this to next month's agenda. ii. Budget — Tharp stated that they are doing well budget -wise. He added that with regards to the budget, they did go ahead with the fuel tank cleaning, as mentioned in last month's meeting. The estimate was $2,800 and the final bill was at $2,650, according to Tharp. Horan added that the accounting sheets are very difficult to read. Tharp stated that the City is updating a lot of its software and it should be online in July. iii. Management Iowa City Airport Commission Agenda and Info Packet 4-19-2013 5 of 68 1. Operations Specialist Evaluation —Tharp noted that since Assouline is not present, and he is the main one responsible for this year's review, that they defer one more meeting. Horan asked if Tharp had emailed this information to Hofineyer, stating that it would help him to understand the process they go through to do this. f. FBO / Flight Training Reports i. Jet Air — Matt and Philip Wolford were present from Jet Air. Matt reviewed the maintenance reports to date. For February, he noted the large snowstorms they have had and all of the work they've had to put into plowing and de-icing. A fuel vent on the AV tank was replaced due to some possible leakage. March has brought another snowstorm, and also a run on light bulbs around the Airport. Philip shared that there isn't much to report right now. With spring approaching, he hopes to see increased activity. ii. Iowa Flight Training — Gardinier suggested Tharp contact IFT to see how things are going since they have not heard from him in quite some time. g. Subcommittee Reports i. For March: Members began to review the various subcommittees, with new Members receiving some history on the various committees. Tharp explained who is typically on each subcommittee and how they work on items such as the budget, community liaison, and economic development. This led to a discussion about the Air Race Classic making Iowa City a stop in their 2014 event. Gardinier added that she thought this had been taken care of, and Tharp noted that he has been in touch with them, and plans are being finalized. Members continued to discuss the open seats on the subcommittees, with Ogren stating that she would be glad to sit on several. Horan switched himself around on several different committees. The discussion turned to how they might collaborate with area businesses, such as the motels on Riverside Drive, or even host a monthly steak fry or something similar to bring more traffic to the Airport. Tharp noted that they are looking at acquiring a grill and a picnic bench for the Airport. Gardinier suggested they revisit the viewing area plans and perhaps set these things up there. The newer Members joined in on the subcommittees, as well. h. Commission Members' Reports — Horan asked Hofineyer to share something about himself with the Committee. Hofineyer introduced himself, adding that he earned his private pilot's license while in college. After several years away from flying, last summer he got back into aviation and is currently just renting the 172 from Iowa Flight Training. Hofineyer continued, sharing that he has a chemical engineering background. He currently works at Rockwell Collins as a Senior Quality Engineer. Ogren shared the progress of their airplane that her husband is building at home. Gardinier stated that she just got back from a flight to Tennessee this past weekend. She shared a story of how when she was leaving for Tennessee the other day, she accidentally ran off the runway into some mud. Horan shared that he heard the City received an award recently for their "open government" and he congratulated the staff. Horan then shared that he returned safely to the ground with his 1Wh CFI (certified flight instructor) in three years. Horan now has somewhere around 45 flight hours under his belt. Staff Report — Tharp noted that the Iowa Aviation conference is next month — April 24`h and 25`h. The format has changed somewhat, so this year, according to Tharp, the 25`h is the day where everything is happening, and the 2Wh is the Iowa Public Airport Association's general meeting and a pilot seminar that evening. Iowa City Airport Commission Agenda and Info Packet 4-19-2013 6 of 68 He shared that he has been asked to be a speaker this year, and this sparked a discussion by Members on attending this year's conference. Tharp asked that Members let him know if they plan to attend. He will get the information about the meeting and the daily agendas to Members so they can make their decision about attending. Tharp then mentioned some zoning issues that have come up regarding building heights, the FAA, and that type of thing. Dulek further explained the history behind this and how the Airport Zoning and Board of Adjustment Commissions may need to be revived. Members were encouraged to talk to members in the community about serving on these newly revived committees. Dulek noted that there will be more on this issue in upcoming agendas. Gardinier added that she will draft an email and have Dulek review it before she sends it out to the EAA, for example, to recruit new committee members. SET NEXT REGULAR MEETING FOR: The next regular meeting will be Thursday, April 18, 2013, at 6:00 P.M. at the Airport Terminal building. ADJOURN: Horan adjourned the meeting at 8:01 P.M.; CHAIRPERSON DATE Iowa City Airport Commission Agenda and Info Packet 4-19-2013 7 of 68 Airport Commission ATTENDANCE RECORD 2013 TERM � o 0 A ( � � W � O _ IN)� � W ? EXP. co-4 �J1 IN) co rn N oao cn IN)IN) o IN)NAME N N N N N N N N N W W W W 03/01/13 Rick X X X X X X X X O/E O/E X NM Mascari 03/01/14 Howard Horan X X X X X X X X X X X X Minnetta 03/01/15 Gardinier X X O/E X X O/E X X O/E X X X Jose 03/02/16 Assouline X X X X X X X X X X O/E O/E Chris 03/01/14 Ogren NM NM NM NM X X X X X X X X Paul 03/01/17 Hofineyer NM NM NM NM NM NM NM NM NM NM NM X Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time _ {} o � & � 2 / \ k \ ƒ f 7 \ � l § a = k k \ \ ƒ ? 0 a a� Ss 4q� W i.i M :Q rej pa i. L �+ Iw «er u� Qa n 4-K t y At O Q emo O - Ct • • o 0 0 • r v Al 11 Mol 11 IM • u i �A • • o E § § \ \ j ® 2 / < E \ & a \ [ ) ^ }u \ i \ # a \ [ LU \ _ _ 2 \ 0 Cl ID � \ § E � _ < � v � � § § in ) ( r ID o m to k § k o 0 0 2[ & f N e - - w ¥ } C a U. tu § « § ( § d ( ) A k m § j o # m u \ k ) \ - 2 6 \ @ % § < 2 § / m \ \ _ a a a a a a 04 § � 41.0 op VI c, ZS 41-1 .,.o P� U 1 vup'AL3 vxol WOCIEV 4LOZ - S1J3f021d ltlI1N310d 1041 IMotlYNIVGI�INnIX AL3 tlMol 1210d211tl ltldIJINOW AlIJ tlM01 D ma., IMM31 0 3AW0 301 y3AIL w i A woow so na3mea noz\ryawA4^omuvo—IooAporrcmAsao'A, —.... o 1131 1 rvaaac om✓o, Iowa City Airport Commission Agenda and Info Packet 4-19-2013 15 of 68 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 350 5045 RESOLUTION NO. RESOLUTION APPROVING TASK ORDER NO. 11 WITH AECOM FOR DESIGN AND CONSTRUCTION RELATED SERVICES RELATING TO THE REHABILITATION OF BUILDING E (TERMINAL) AND BUILDING D (OFFICE) ROOFS WHEREAS, the Iowa City Airport Commission entered into a contract entitled "Professional Services Agreement" with Earth Tech (n/k/a 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 task orders for each project; WHEREAS, the Commission and AECOM have previously entered into Task Orders Nos. 1, 2, 3, 4, 5, 6, 7, 8, 9 and No. 10; WHEREAS, the Commission and AECOM now desire to enter into Task Order No. 11, a copy of which is attached. WHEREAS, it is in the best interest of the Commission to enter into Task Order No. 11. NOW, THEREFORE, BE IT RESOLVED BY THE AIRPORT COMMISSION OF THE CITY OF IOWA CITY: 1. The Chairperson is authorized and the Secretary to attest to Task Order No. 1. Passed and approved this day of 2013. CHAIRPERSON ATTEST: SECRETARY It was moved by and seconded by adopted, and upon roll call there were: Approved By: City Attorney's Office Ayes Nays Absent the Resolution be Assouline Gardinier Hofineyer Horan Ogren Iowa City Airport Commission Agenda and Info Packet 4-19-2013 16 of 68 AZICOM AECOM 319-232-1 fel 501 Sycamore Street 319-232-0270271 fax Suite 222 Waterloo, Iowa 50703 www.aeoom.com - REHABILITATE BUILDINGS E (TERMINAL) AND D (OFFICE) ROOFS IDOT GRANT NUMBER 911301OW300 CONTRACT NUMBER 14146 IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA TASK ORDER NO. 11 Project Description - See attachment and incorporated herein. Scope of Services - See attachment and incorporated herein. Compensation Compensation for services for this task order shall be a cost plus fixed fee not -to -exceed Twenty -Four Thousand Seven Hundred Dollars ($24,700.00). See attachment and incorporated herein. 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 Ap� rQved By �_ (-o 4 A - f 3 City Attomi�-' APPROVED AECOM TECHNICAL SERVICES, INC. Douglas W. Schindel, P.E. Iowa Operations Manager Date April 8, 2013 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 17 of 68 SCOPE OF SERVICES FOR REHABILITATE BUILDINGS E (TERMINAL) AND D (OFFICE) ROOFS IDOT GRANT NUMBER 911301OW300 CONTRACT NUMBER 14146 IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA PROJECT TASK ORDER NO. 11 Project Description The project is described as the Rehabilitation of Roofs on Buildings E (Terminal Building) and D (Office) as more specifically defined on the state application for funding at the Iowa City Municipal Airport, Iowa City, Iowa. The project involves the removal and replacement of all roofing materials in these areas. This project will be funded through an Iowa Department of Transportation grant. 11. Scope of Services The work to be performed by the Consultant shall encompass and include detailed work, services, materials, equipment and supplies necessary to develop final plans, specifications, and construction cost estimates, and provide limited construction -phase services. Work shall be divided into the following tasks: A. Design Phase Assumptions. a. Buildings will not be evaluated for loading imposed by new roofing system. It is assumed that the loading by the new EPDM (ethylene propylene diene terpolymer) single ply roofing system will impose similar loads to the building structure- b. Scope does not include evaluation of any existing water damage to the terminal building structure, as this evaluation requires removal of the roofing and/or building ceiling to evaluate- C. Building D does exhibit some signs of water damage in the main office area. Owner will provide access for evaluation of water damage extent. d. Owner will provide means for access to roof areas for field evaluation- 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. As part of this task, the following field investigations will be performed. a. Terminal Building. A field inventory of the existing building roofing system will be completed to define existing roof penetrations and flashing requirements. Iowa City Airport Commission Agenda and Info Packet 4-19-2013 18 of 68 b. Building D (Office). A field inventory of the existing building roofing system will be completed to define existing roof penetrations and flashing requirements. The office area will be reviewed to define the approximate extent of repairs necessary to repair water damage to the office ceiling. Existing base mapping will form the basis for the bidding documents. No additional topographic survey or property surveys are included in this task- 3- Design Documents. This task consists of the preparation of the final bid documents for this project. Plans and specifications will be prepared in compliance with current Iowa City Standards and Iowa DOT Standards. This task includes the preparation of the following: • Title Sheet and Schedule of Drawings • Legend, General Notes and Schedule of Quantities • General Project Layout • Terminal Building Roofing Replacement and Details • Building D Office Roofing Replacement and Details • Building D Ceiling Repair and Details 4. Proiect Specifications. This task consists of the preparation of specifications for the project. The specifications will be in compliance with current Iowa City Standards and Iowa Department of Transportation requirements in effect at the time the specifications are prepared- 5- Estimate of Probable Construction Cost. This task consists of the preparation of a detailed estimate of construction costs based upon the plans and specifications. This statement of probable construction cost prepared by the Consultant represents the Consultants best judgment as a design professional at the time the estimate is drawn- 6- 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- 7- Bid Assistance. This task consists of assisting the Commission in preparing a competitive quote package, answering quote document questions from bidders, preparing and issuing any required addenda, analyzing the quotes received and preparing a recommendation to the Commission for award of contract- 8- Proiect Administration During Design. This task consists of office administration and coordination of the project. Interoffice meetings, general day-to-day administrative responsibilities, and typing of interoffice memoranda and minutes of meetings are included in this task. Prepare up to 20 sets of contract documents for distribution to Commission, IDOT, plan rooms, suppliers and potential bidders. Iowa City Airport Commission Agenda and Info Packet 4-19-2013 19 of 68 B. Construction Phase 1. Shop Drawings and Submittals. This task consists of reviewing shop drawings and other submittals as required of the Contractor by the contract documents for conformance with the design concept of the Project and compliance with the information given in the contract documents- 2- Construction Assistance and Site Visits. This task consists of answering design interpretation questions from the Sponsor, Contractor, review staff and appropriate agencies. This task also includes includes field review by office staff at critical points as the construction progresses- 3- Pay Requests and Grant Administration. This task consists of the review and approval of contractor pay requests for work completed and coordination with the Iowa Department of Transportation for reimbursement of funds expended by the Iowa City Airport Commission related to this project- 4- Punch List. This task consists of conducting a review of the Project near completion and preparing a list of items (Punch List) to be completed or corrected- 5- Final Review. This task consists of performing a field observation of the completed Project before a final application for payment is processed for the Contractor- 6- Proiect Closeout. This task consists of assisting the Sponsor with Project completion and final closeout documentation from the Contractor for the Iowa Department of Transportation. 7. Record Drawings. This task consists of providing the Sponsor with a copy of Record Drawings of the construction plans for the Project based on the construction observation records of the review staff and Contractor showing those changes made during construction considered significant. A copy of the Record Drawings will be provided to the Sponsor- 8- Proiect Administration Durina Construction. This task consists of office administration and coordination of the project during construction. Interoffice meetings, general coordination with the Commission and the contractor, day-to-day administrative responsibilities, and typing of interoffice memoranda and minutes of meetings are included in this task. L:\work\ADMI MAGREE\PRORICTaskOrder11 RehabTerminalandRoofs.doc Iowa City Airport Commission Agenda and Info Packet 4-19-2013 20 of 68 Rehabilitate Buildings E (Terminal) and D (Office) Roofs Iowa City Municipal Airport Iowa City, Iowa IDOT GRANT NUMBER 911301OW300 CONTRACT NUMBER 14146 Design Services Staff Hour Estimate Item No. Description Project Prof Project Arch Prof CADD Operator Project Support Totals A DESIGN PHASE 1 Assignment of Pro ect Manager 2 Data Collection and Review 4 24 28 3 Preparation of Design Plans 1 Title Sheet & Schedule of Drawings 2 2 2 Legend, General Notes and Schedule of Quantities 1 2 1 4 1 6 3 General Project Layout 4 4 4 Terminal Building Roofing Replacement and Details 4 16 20 5 Building D Office Roofing Replacement and Details 4 16 20 6 Building D Ceiling Repairs and Details 2 4 6 4 Pro ect Specifications 4 4 8 8 24 5 Estimate of Probable Construction Cost 2 2 6 Quality Review 2 6 8 7 Bid Assistance 2 4 6 8 Project Administration 2 4 6 B CONSTRUCTION PHASE 1 Shop Drawings and Submittals 4 12 16 2 Construction Assistance and Site Visits 4 4 8 3 Pay Requests and Grant Administration 4 4 4 Punch List 4 4 5 Final Review 16 16 6 Project Close-out 2 4 6 7 Record Drawings 4 4 8 Pro ect Administration 2 4 6 Total Design Services 24 64 30 62 16 196 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 21 of 68 IV V. Rehabilitate Buildings E (Terminal) and D (Office) Roofs Iowa City Municipal Airport Iowa City, Iowa IDOT GRANT NUMBER 911301OW300 CONTRACT NUMBER 14146 Design Services Consultant Cost Summary Direct Labor Cost Category Hours Rate/Hour Amount Project Professional 24 $70.60 $1,694.40 Project Architect 64 $44.00 $2,816.00 Professional 30 $31.00 $930.00 CADD Operator 62 $28.00 $1,736.00 Project Support 16 $26.00 $416.00 $7,592.40 196 Payroll Burden and Overhead Provisional Costs 160.00% $12,147.84 Direct Project Expenses Category Units Rate/Unit Amount Mileage 2000 0.565 1,130.00 Per Diem 4 32.00 128.00 Lodging 2 77.00 154.00 Copier 3000 0.06 180.00 Plan Copier 200 0.50 100.00 GPS 0 25.00 0.00 Geodimeter 0 12.50 0.00 Miscellaneous, Other 308.00 $2,000.00 AECOM Estimated Actual Costs $21,740.24 Rounded $21,750.00 Subcontract Expense $0.00 $0.00 Estimated Actual Costs Fixed Fee Maximum Amount Payable $21,750.00 $2,950.00 $24,700.00 0 N N 4WAN ki i ru so s*AN I r Lf >- r r� V/ ow its W, U bq Ya, _ 0 FN / \� - L;j2 \ \ 0 \ - \ (f 2 \CL b! % §f j § ) E ) \ z f o&ƒ G o_ . - 0 ƒ t ( E a< \ \ » ) z § @ E o e; z # o & k /� \ } [ §\ ■ j o\ \ ){ lz u k\ ®® e£ &§ () §= § \ \{ (k k\ ) \\ 0-6 �) d2 �j \} f] §\\ §§ )/ }) §\ ix ([f rj k �`° }/ /o \) \k 2§j § § z §� & § k \ rrA T a R c 0 �a Q 0 J V N Y C N Y � O V y V O � O u w O °6 O 06 u V O Q Q E N ,--i Ni ri oo '1: Sri t Q 'O O O LL 6 N y O N D CD N M .Z3 CD c p N a + _n ° p Q y � V N Oc y N � ~ y O co Q Z3 O Q mu °V Q M O- Q N .c •� U O O O k i ro u ° \ \ § % 0 \ 0 E E 2 \ �CD �� %G \\ ( ~ �� ` t Q \� 3 — t > \ -0 — } \ 0 a) \ / \ 2 \ \ 5 S z Z3; ) \ \ ) ! \ ) } � \ } \ / / 0 / \ / \ a) \ © \ q / / 3 * M e & 2 . / /) / { ) / , ƒ ° r \ E E \ ! ) } — — = E ) \ , U } ©\< > \ /2�=2 22 mu \ 2 _ —{3 /\ ) * o = )\\\/� % CD =GJ2 c �mu mu CD c — : E o 9 f// \ \///}5/ ( § B � « t ■}° � a\. ,•. �.�� \ ■� �r> 0 »2®} - 5- a \ / ® { \ 2 /B\: - /0 2 /E \�\\ \\ » B25& - \ 1E \ \ ±m%- 0 #B2 / \ \ $ « , / \ § j :: i « a = \ \ cm ) 2 ■ / + Q f \ \ 2|/ y 2! m / f% g= a J ) \ / / \ \ / j ] j } B k k t i co d a.+ N N W O V v+ — a+ N O O� O u O a7 ' O 7 tp N O Y '� O o o �, o o° O Q T c t O Q V 1E io i ,O 0 O `=� ) Q 0- Y Y V Q no Y V Y vi H v Y Q O N O — w a)0 M O N .0 3 co Q O N c O C a+ v� 0- G > N N O N J lA V N V Y C N N Y N Y Q c G N Y= 3 y O V w Y co N U V vi w N V U N � c yi al V N .o Q Q o t t c Q 3 0 0 0 w A O U c C Q a)N -O V > u m .O O Q N Y Y t Y _ Q Y y pV (O N Y N M m N N 3 v N N N O N Q Q _p •.' O al -p .� tp a+ a+ N O cO cO N a+ O X LL N V O Q y d Q O� N O ''' C O N V O c) E O p N > C N N a N N N c U t N .`6 >, N Qc 3 O vi co co c c 'O N tp — N Y -p p c E Q vi p c O E E> Ln a7 O V A p L c N y L y r E ) N ''' V V t a+ .�, t CD Q t �O V Y VI lA N V Y Y 0 u_ � .� y T i F, c a) c-0 c a) a) T F V -O >� co O co V y O O N 7 O co 0, rn a) LL N a) J y O tp 7 Q a) rl � Q c° ; a o w Q oo a t> y CD M O p y V `^ pi +� Q y rn N N O C -p ri �n tp 7 - �, U ri al c U Y V O Q E — of > O t O Q N O O T `^ >, ''' O I� O O v O ''' O t y y c m Q O O O fl- al i 7 4 l.J t a7 0 -O a N Q 'O O a) > O m m tp C a) D¢ a) � 3� � O � p Y0 O p y V O C tp '6 off W i tp �.X CD LL Q ._ t ) a) CDc 3 O O O w a) a) p lA CD a) 'y y 0 a)-O — co a7 — cp O a O a 3 amu C CD y a Y a) O y a) O y V (a c CDi y' W LL 0 U N = t a) N �p '� O O N lA a) y Y 0) m W p O (a Q a) = a) N y y 0 N y c N �' p c ^� co > H > V C W v v v 'x = E t y co vi O p � y Q a) y y a) a) m lA V O -p O y y tp � w OV i a) m Oi y c° co N 4 '6 a) O Ln O p x 3 �, a7 co cod oo i N O N QZ;, x O 2- O LL ai O y �n a) V a) 0-0 a) IN 4,J a s o Q O Vmu Z3 le co .— Q '� cOYo V Q N O 'i T vi eC Q — N � co p 4 U° a .E o .° 3° o V 41 t �, .� — .� .O- eC ;, 'c V M c O Q N O U y O p O- Q v E 6 Z3 t m E v Ln y E CC V OV ate+ N uj C l.J ~ 30 ' j p o oZ o Q o o o a 3 a v w � y Y 3 v 0 3 O .X c .v V ICI F 0 i� .� o a 3 O .� v o) -c o 0) O O 3 O> N V m V ) 7 " O y �+ O O m tO K c- t C V w O V O O O Q c y 4 O -O O `^ 3 Z3 O vi �o co v, m co i O N M w H i y c V ^ m >, y O c- Q '6 �° O O >' N N Q Q N N N 3 c>o y co Z O O = N Q N Q co y �p N O K Q V N 4 V t d al -6 t6 O O- t N c c c w �: O Q c w Q ON O> x N c O c c t 'p c y N -O i lA y N Q >1 > a' 30 N y0 -O O > N 3 (o c Y y W Q y i� Z3 Oy y i V N co N= V co 0 N 41C V c—cz V t O y U Zi Q V O y tO _O z �I �O tO � � fl- � N � 0 c 0 O co .x N y NZ3N y Q y N y lA N N C c .N O N rn O t t c � ,0, O N 0) c ai Q co Q p 3 01 ,� y co " +� N d\ V mu+O' .>_ co O N c Q S N c c6 N N x O> > O w x rl V N tp y rl E O N N V tp > V 0 N /% § {} 0 {M \ ƒ\ \ / 5 \} »» G \{ f %® t 0 mu \� 0) \) \ \ \ ƒ / R =o } \ \ / \ c 2 ± � � f �\\ � / _ \ � 0) § \ \ 0 § /0 ® ® � 2t: • \ \\ \ \ 0 = 2 % o \ § \ \ E § ) / � { { \ \ ~ / E k / a } \ 3 0-0 ƒ . : \ \ ■§ / / / _ ' cm _ E - 2 3/ g : 2- _ &� { 3 { / \ 22 \ % \� \ _ - / / J \ ( E \ 7 / 2 \ ) G \ ® \ / § Eb \\- \ _\ \ 0 \ \ \ \ \ C \ % / \ / § 0-\ u w O w m w w 41 C > 7 ^ O 0 N al N C c m > N rt y L v N 0 N O O c C 0 C O I- C Q) '6 C Q C a0+ m �O m N Q d Z N ` 0 w m £ .m CL = N C p V m ._ C y Y m Y > Q C m m 0 O-.!:: +0+ cvo N C N V] M , 1� u m � 3 N � y Y N '3 O C T �6 Y � Q V al N C VI i Y 3 O 4 N fl- tp C � Q �6 Y V tp o 0) O � y Q t C 0) > Y 3 0 N � N 4 eC � O ❑ V] LEINEW is 1� u F El D ■ r F C u I � ui \ \ \ mu 3 \ \ \© / %— ® / 0 5 \ % / 23 e\ } \ k * \ } f ) » { \ \ \w \e /% & \ \ \ _ f\ f R(\ / 3- ) 4 , m : ( ( , \ ? z % \ _ \ 5 7 2 : ) { } { ) U f \ / / / \ p 7 > m - \ y \M X/ \ \ \ \ \� \ \ \ \ - a)\ \ \ 3\ 2 2 f f � 2 a 2 u<% z 5 e e e & . . . . . . . . . M rl Y O a y L � Q Y � Y d c mu> DO N OL N N N m O v p. 'y O 6) rw �I1 = N 6 _ Q N 4,5 y V a 0 v � f0 m y O V v Q io w v O m O ! , Im V= al Q Q N w 1�1 t6 C 3 V N 2 07 cm O N V C .� CL 3 Q Q Z3 O O Q N y O c ram, m O V Q N �+ > V 7 _ md y � � OW � � Q � w y to M cz V = CO 0 a O > .+ Q p O m o — o O v N v O p Q N i N .y 4W c lV,! o O v lJ 3 O N t w � 4 u Y O Y N w O i OZ3 o o Q V mu O Q H cZ3 G V aT+ t6 .V � i O V O V w Q N N E E 0 U 0 A M O O N 4 AliL m VAl A It N l��IIII in in N T N O - 0 - N O > a� N N N 0 U N N Ot m Ot O O n n Eo o O 0 = u T > > > C 'C n n a o E o ° m L E U > OO N O N �- Q a� as E E �� o L o 0 OI O O N E N 0 N C N E L d L N O J p E 045 m om,L�PL Q o '^ 0 m� u EO 0 U m 0 0 m Q 0 J N T> 0_ N 0 = � 0 E 0 N- O .L.. L` in N C L N D �` N 0 o Nd � •L.• - T N N m 4T E .. 0 m o E `E c— a ° oo Q 2 O N C C (p O m= -p 0 Y L oL.. C. 0. VI VI L L L L OI C N m 0 C�_ C FFUZ 'm > azoF m > -Z mx _ W OF °'FU f N M MNN N O J O U 3 N � 2 ga0 o..J U�m COJ ORZ IL 6 C W yyLU W F m N U � 'z3W �'z i C1 V7 C c o @ C1 E c D E R w a Ew0 YN N� co ` Z rn U _ ' m Z`rnq c r m ovIL w _ � C 0 tm m � 0 c OIL c u m m m Kmom v E 0 E 0 0 0 c 0 E m n �Mn LL 0 y .. Q G c IL R y W b N a �C a a p c E c U 2 5 IL ci tu W w LL O 'C R N £ N> E c m cm £ c MZ N G ME R R N V O) R N m o, E0 mgwzmRo O O.. �-NoPyd wo �O@ ;._'o m$Lc w�owa n5tcc3 N R N y OLl R E c ,L`rvy in iaD N @ 0 u M L N c N R 9 L oc D w Val ME 'l C. R�� N c . o D@@@° OM m c^ `w c E a> W 0 m `R i�o' 8rn N 0 > a 0cww£i..Rc `m ' EO^' >'j O R Z G R'c N D O. �.y E.; mew v R R> c O)'c z N a D mz, 3t0 c=O.>=mE c O=t@a,�Ro g-�00 £ EDoa'i 'omcN> R rnE6jZc..=U RRLE C `� C R~ C N c a@E N5-R rn T R @ 6� 0 N a E H M a rn. c >m r' £ £ N o 0 02 L a y ~ N.V G mN D�yao'cQ O N N �>p a R O 2 R R KUn@TO NinUsn� E R O E c CA AER�m 05 EmmDtoG > w'O ='c c c m V AD'm c O @ om 0 0 G R-a 0 v c u a E a d aR2 `m of 00 H L O C Y R C G O U R p, E 0e- w`w0�°LR w e N_ c U L cC Ra c.W c+a N r I =�c= E r @o000°U 0 e-EnRa00'Sc �NH=0o ... R OV"U"' �� w 5 3 wm�.Go `m pc L03�0@10VN o vo£, aai 'Sw A �+wEaE 0U5 R@ r.- N N c@ Z x a@ 3 r ._ L O 0ooOG m0 w2. L20 R2r< c F R L o a 3 R E'Y R c o c@ N 0 E a F c'S°A3�Ev N w0 mv� Noac �Sy� -,,,,L c °'mYoaE Jmc" E v c o m c m G m V m 5 r c£ S � g'miL'y s5 om ouwn y� 0 c)a0 r« cow O 0 00 m C tli '- C 6 0 omm amvo3YD >�L mE3�ii-mL Tali wt L O O y t S O d� O 0 O NC O N 'C c J m r am C 0 y0 T_- d 3 d m d C �a m TyajL W a`�r Gy_�0 j d O N_ 0 C d Z m..Y 0 c v cn'v8j=am Ty nm E o'm:'O£ Ev';g aJ$c£K Em O C O W 0 0 0 V m N'C w 'm p c c >� a 0c Qj U a 3 gEoo W C mn T c L j a g U c m w v m O m 0 ¢ �, Y w m 0 L N O N O m .O .. 0 U m V C U 0 0 C C E v w o x" a�i E 3 3m a. 'm O) TELm mG 0000"00 m m.s .L-ONNOggE��>-,r)—N WZE YmI 8G m U a0. ❑mog.� yy��x 0Ev {El 'm _o yLmvv v W vQ'o mrO L b'r�mmEWVL.rL+N_ wmocommomwa w uv, c3..O.0y.. mc9v�'k> cY t 'p N c N N O 0 C 0 r' ''pp j ... N O'o m e 0 D aY o m a m J Y L comEv.mm mcm u,n w3cu `mm Yyam E m:?cc mm'c c.omc > E v W98W Om.w.�0E3-L� v��'y omD2gac_NS NL=mt u oau m mv�cmm«._a v=main=m D m m w m 0 5 K t ZE o w m 3 Q a E O W a y 0 m m C � v c o �. 15 ffL 0c- 0'CE m0 Y momEv m wo Z `+maryrym n- e v m m m m p c o i JC a D r v w L O Q v E n E V N N v m L N(J p m« d EEmc v N 6mC= N e'W C 0O m 0>i r �mm 0O.T.-Qc��°of vm� m m c E�@$ S m m m.- m 5 0 N m v v m m 3' v c u> c m-m WS d CL.L..aN-'m dN m a N m 0 0 0- J 2 0 r 52-0''- m>cmovoawCOEUmtm y.� C m m f0NT tmm�'N'L'Nc aw GC.O E_ 1. Eo0`m Crl-=O pmmE�O- 0 c m w v a m0% 6!�mc m E N C O .Law> �6v ¢ .Nm O5m�mvmm"rnm=,0-Evu m O v5mmLmp_,6o=,C9L E0Lm o a. 0 m cfO crnoNvmi''m c m m c w n a m v c c m; 3 c n n wY Nvo Lmv'c'U E mm _a m�f6 O rm oc mm 0 m j gt O 0= Oawrm >Em m-aQcv3 K L o Jv mnv m rn o m v mJ>VQ0 mc O� ODW !nR Mommmm O L HxK m m r r W z ui w 0 J K IL IL Q 0 O N � 3 — L N W� 20 c mo `gi c m r v E C Em v m Q L c m m 3 m c v m aFFE >a O F 0 d «� 2 S v w i u J c E Z E Eac v 0 :5 Z c c O m0 C O L Tim W C L N X � W E r W O O $ U ° N W ¢ m 5 a o nc y v C v m o J a � > W m 3mm W N 0 O d C N L 3 �vF m o 5 0 t ° `O cc 0 w N N N i W W c 0 N N O O N m W N ¢ C ma O C 0.0 O � n c J c a ° N N T O O N N m U o N d D£ c O m E 3 N ) '0 v O O Ey`, W Uv m Q' c t v'N 0 O U 3 0 O a c m O i T r w 3 W E C O V W O E 0 N N W U N O 0 p U C L U J U O W N N m C O U ° U 2 5 a'� E> W O a W O O1 w c E U E m m W w W o— W O m m E W > W "O W L_ E W o .. C E N vii m= m v W m m w> 3 r c 2 E w v a v 5o O '._°- p O W W W U 2 v 0 N W O C' U E N o L m c o 3 m t W o o O n o m E f J N f 7 J f 7 Z f 7 E o f 7 f 7 0_ U N N N N N V V V V V a 0 U U v C O J U N U 2 a ¢ > m c O 16 N o � v ° ..5 w 42 'a N W J L c O W i v a Y > a w w w a U E V iA W° C O C m iA ¢ W W N Y o O. O O 11 C ry N yv. E 0.0 O L W E O LL "O O o. N L O 2°_ `O °O c° m C w U o v to O O N O N U° a C N- V) L W O a w N L O O iA y� W iA J W f7 ¢ C O W> �A W W m iA N c W S W W c W o L N c O `v J U J U 0 c W W L v L W C E E v J `W w O J m ry 'in u a w O w O._ c `v v N v N._ o Y W C p N W W E U W W U V v v C v U U C E W 0 0 0 3 W z W z¢ 6 W Z C O Z J m Z Z K Z J J IL Z m m J W O N (D N V V V V V M M M M N N N l � 0 0 0 7 \ § ) \\\ \\\\\\ \ \ * / j ƒ \. - _- \\\ \\\\j\\\\\\ \\\\ ; \ Iowa City Airport Commission Agenda and Info Packet 4-19-2013 Cl65[H7 REVS; 04.15,13 11:16:07 Method: 3 Page, 1 Iowa Cily General Ledger System FY 2013 Revenue Reporting For the period 03,01.13 to 03.31.13 Estimated YTD Period Account Revenue Revenue Revenue Remainder 8 --------------------------------------------------------------------------------------------------- ------ ----- ------ 7600 Airport INTEREST REVENUES 381100 Interest on Investments 1170.00 1100.86 42.56 69.14 94.09 Tota'_ INTEREST REVENUES RENTS 382100 Land Rental 382200 Building/Room Rental Total RENTS ROYALTIES & COMMISSIONS 384200 Vending Machine Comm 384900 Other Commissions Total ROYALTIES & COMMISSIONS SALE OF ASSETS 392100 Sale of Land I otal SALE OF ASSETS TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES Total TRANSFERS Total Airport "* GRAND TOTAL *** ------------ 1170.00 ------------ ------------ 1100,86 ------------ 42,56 69.14 ------ 94.09 40943.00 14537.03 756.67 26405.97 35.51 235283.00 179983.34 24168.00 55299.66 76.50 ------------ 276226.00 ------------ 194520.37 ------- - ---- 24924.67 ------------ 81705,63 ------ 70.42 97.00 100.80 10.80 -3.80 103.92 16931.00 19800.70 1600.70 -2869.70 116.95 ------------ 17028.00 ------------ 19901,50 ------------ 1611.50 ------------ -2873,50 ------ 116,88 336936.00 336936.00 100,00 ------------ 336936.00 ------------ 336936.00 ------------ ------------ ------ 100.00 100000.00 74999.97 8333.33 25000.03 75.00 ------------ 100000.00 ------------ 74999.97 ----------- 8333.33 ------------ 25000.03 ------ 75.00 ----------- 100000.00 ------------ 74999,97 ------------ 8333.33 ------------ 25000.03 ------ 75.00 ------------ 731360.00 ------------ 627458,70 ------------ 34912,06 ------------ 103901.30 ------ 85.79 ------------ 731360.00 ------------ ------------ ------------ ------------ ------------ 627458.70 ------------ ------------ ------------ 34912,06 ------------ ------------ ------------ 103901,30 ------ 85,79 ------ ------ Iowa City Airport Commission Agenda and Info Packet 4-19-2013 E,M[H7 EXPE: 04.15.13 11:15:39 Method: 1 Page: 1 Iowa City General Ledger System FY 2013 Expense Reporting For the period 03.01.13 to 03.31.13 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used ------------------------------------------------------ 7600 Airport ------------ ------------ ----------- ------------ ------------ --- -- AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 49474.00 35445.26 3787.20 14028.74 71.64 413000 Temporary Employees 301.39 25.38 -301.39 Total REGULAR SALARIES & WAGES ----------- ----------- 49474.00 35746.65 ---------------------- ------------ 3812.58 13727.35 ------ 72.25 OTHER WAGES 414500 Longevity Pay 244,00 325.00 -81.00 133.20 "otal OTHER WAGES ------------------------ 244.00 325.00 ------------ ------------ ------------ -81,00 ------ 133.20 Total SALARIES & WAGES ---------------------- 49718.00 36071.65 ------------ ------------ ------------ 3812.58 13646,35 ------ 72.55 EMPLOYEE BENEFITS GROUP INSURANCE 421100 Health Insurance 4525.00 3503.07 389.23 1021.93 77,42 421200 Dental Insurance 318.00 240.30 26.70 77.70 75.57 421300 Life Insurance 94.00 95.49 10.75 -1.49 101.59 421400 Disability Insurance 239.00 175.47 19.69 63.53 73.42 Total GROUP INSURANCE ----------------------- 5176.00 4014,33 ----------- ------------------------ 446.37 1161.67 ------ 77.56 SOCIAL SECURITY CONTRIBUTIONS 422100 FICA 3803.00 2731.96 288.60 1071.04 71.84 Total SOCIAL SECURITY CONTRIBUTIONS ------------ ------------ 3803.00 2731.06 ------------------------------------ 288.60 1071.04 ------ 71.84 RETIREMENT CONTRIBUTIONS 4231CC IPERS 4311.00 3127.47 330,56 1183.53 72.55 Total RETIREMENT CONTRIBUTIONS ------------------------ 4311.00 3127.47 ------------------------------------ 330.56 1183.53 ------ 72.55 Total EMPLOYEE EENEFITS ------------ ------------ 13290.00 9873.76 ------------ ------------ ------------ 1065.53 3416.24 ------ 74.29 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 C9I5[H7 ERPE: 04.15.13 11:15:39 Method: 1 Account --------------------------------------------- 7600 Airport (CONTINUED1 AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) PROFESSIONAL & TECHNICAL SERVICES OFFICIAL/ADMINSTRATIVE SERVICES 431020 Court Casts & Services Page: 2 Iowa City General Ledger System FY 2013 Expense Reporting For the period 03.01.13 to 03.31.13 YTD Period Appropriated Expenditures Expenditures Encumbrance Balance $ Used ------- ------------ ------------ ----------------------- ------------ ------ Total OFFICIAL;ADMINSTRATIVE SERVICES PROFESSIONAL SERVICES 432020 Annual Audit 432050 Appraisal Services Total PROFESSIONAL SERVICES DATA AND COMMUNICATION SERVICES 435056 Delivery Services 435057 Couriers L35060 Legal Publications Total DATA AND COMMUNICATION SERVICES TRAINING & EDUCATION 436030 Transportation 436050 Registration 436060 Lodging 436080 Meals Total TRAINING & EDUCATION INSURANCE 437010 Comp Liability Insurance 437020 Fire & Casualty Insurance 437030 Worker's Comp Insurance 437041 Banding & Other Insurance 437200 Loss Reserve Payment Total INSURANCE 67,00 ------------ 67,00 67.00 - ------------ ------------ ------ 67.00 2350.00 1130.55 1219.45 48.11 2600.00 -2600.00 ----------------------- 2350.00 ---------------------- 3730.55 ------------ -1380.55 ------ 158.75 15,00 :5.00 152.60 -152.60 12.00 13.05 -1.05 108.75 ------------ ------------ 27.00 ------------------------ 165,65 ------------ -138.65 ------ 613.52 700.00 24.00 676.00 3.43 400.00 425.00 -25,00 106.25 500.00 500.00 200.00 71.04 128.96 35.52 ------------------------ 1800.00 ------------ ------------ 520.04 ------------ 1279,96 ------ 28.89 4345.00 3530.00 815.00 81.24 13316.00 7354.00 5962.00 55.23 44.00 62,00 -18.00 140.91 910.00 875.00 35.00 96.15 5000.00 5000.00 100,00 ------------------------ 23615.00 ----------------------- 16821,00 ----------- 6794.00 ------ 71.23 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 611I5[H7 EXPE; 04,15.13 11;15;39 Method; 1 Account Page! 3 Iowa City General Ledger System FY 2013 Expense Reporting For the period 03.01.13 to 03.31.1E YT➢ Period Appropriated Expenditures Expenditures Encumbrance Balance % Used ---- -- ------------------------ ------ ---------------------------- ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED; PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) UTILITY SERVICES 438010 Stormwater Utility Charges 438030 Electricity 438050 Landfill Use 438070 Heating Euel/Gas 438080 Sewer Utility Charge 438090 Water Utility Charge 438100 Refuse Collection Charges 438120 Long Distance Service Total UTILITY SERV''-CES Total PROFESSIONAL & TECHN'--CAL 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 Res. Con.rol Services Total BUILDING REPAIR & MAINTENANCE SERVICE EQUIPMENT REPAIR & MAINTENANCE SERVICES 443080 Other Equipment Repair & Mainten 'otal EQUIPMENT REPAIR & MAINTENANCE SERVIC 'ECHNICAL SERVICES 445030 Nursery Service -Lawn and Plant C 445080 Snow and Ice Removal 445100 Towing 445110 Testing Services 7104.00 8876.34 986.26 -1772.34 124,95 14220.00 11977.52 1429,79 2242.48 84.23 17.00 208.82 -191,82 1228.3 6174.00 3712.46 823.58 2461.54 60.13 1319.00 869.23 144.22 449.77 65.90 1199.00 847.91 134.69 351.09 70.72 1166.00 873.00 97.00 293.00 74.87 46.00 30.93 2.01 15.07 67.24 ------------------------ 31245.00 27396.21 ------------ ------------ 3617.55 ----------- 3848.79 ------ 87.68 ------------------------ 59104.00 48633.45 ------------ ------------ 3617.55 ------------ 10470.55 ------ 82.28 12692.00 8206.15 774.00 44B5.85 64.66 4944.00 1381.24 3562.76 27.94 4919.00 2269.66 240.00 2649.34 46.14 865.00 4854.07 -3989,07 561.16 2229.00 3474.43 879.93 -1245.43 155.87 423.00 305.55 33.95 117.45 72.23 26072.00 20491.10 1926.88 5580.90 78.59 3210.00 10052.29 221.41 -6842,29 313.16 ------------------------------------ ------------ ------------ ------ 3210.00 10052.29 221.41-6842.29 313.16 32760.00 27505.81 5254.19 83.96 23400.00 13500.00 4500.00 9900.00 571.69 156.00 156,00 900.00 400.01] 500.00 44.44 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 6SF5[H7 EXPE: 04,15.13 11:15:39 Method: 1 Account ----------------- ----------------------------- 7600 Airport !CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) RE?AIR & MAINTENANCE (CONTINUED! TECHNICAL SERVICES (CONTINUE➢ 445140 Outside Printing 445230 Other Technical Services Page: 4 Iowa City General Ledger System FY 2013 Expense Reporting For the period 03.01.13 to 03.31.13 YTD Period Appropriated Expenditures Expenditures Encumbrance Balance R Used -------------------------------------------- ------------ -------•---- ------ 207.00 58.00 3729.00 176.00 149.00 28.02 3553.00 4.72 Total TECHNICAL SERVICES 61152.00 41639.81 4500,00 19512.19 68,09 INTRA-➢EPARTMENT SERVICES 446100 City Attorney Chargeback 3343,00 1949.86 569.00 1303,14 58.33 446130 ITS-PCB?eripheral Support Charge 416.00 800.00 -384.00 192.31 446140 ITS -Computer Replacement Chargeb 474.00 912.78 101.42 -438.78 192.57 446150 ITS -Application Development Fee 154.00 154.00 446160 ITS-Network/Internet Chargeback 360,00 540.00 60,00 -180.00 150.00 446200 Photocopying Chargeback 172.00 71,_6 100.84 41.37 446220 Phone Service Chargeback 1042.00 801,09 95.43 240.91 76.88 446300 Phone Equipment/Line Cbargeback 1083.00 832.50 92.50 250.50 76.87 446320 Mail Chargeback 381.00 268.74 112.26 70.54 446350 City Vehicle Replacement Chargeb 14943.00 12649.36 1363.72 2293.64 84.65 446360 City Vehicle Rental Chargeback 646.00 646.00 446370 Fuel Chargeback 4266.00 2721.96 262.66 1544,04 63,61 446380 Vehicle Repair & Maintenance Cha 12000.00 5854.26 682,73 6145.74 48,75 ------------ Total INTRA-DEPARTMENT SERVICES 39280.00 ----------- 27401.71 ------------ ------------ 3227.46 ------------ 11878.29 ------ 69.76 MISCELLANEOUS SERVICES & CHARGES 449055 ?ermitting Fees 65.00 190.00 -125.00 292.31 449060 Dues & Memberships 1175.00 925.00 250.00 78.72 449360 Interest Expense 55928.00 31575.23 2937.86 24352,77 56.46 ------------ Total MISCELLANEOUS SERVICES & CHARGES 57168.00 ------------ 32690.23 ------ ---- ------------ 2937.86 ------------ 24477.77 ------ 57.18 Total REPAIR ------------ & MAINTENANCE 186882.00 ------------ 132275.14 ------------ ------------ 12813.61 ------------ 59606.86 ------ 70.78 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 69Z.5[:il E%PE: 04.15.13 11:15:40 Method: L Iowa City General Ledger System FY 2013 Expense Reporting For the period 03.01.13 to 03.31.13 YTD Period Account Appropriated Expenditures Expenditures Encumbrance ---------------------------------------- -------------- - --- ------------------------------------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED( 560100 Airport Operations (CONTINUED) OTHER PURCHASED SERVICES (CHANGE TO OFFICE SU GENERAL SUPPLIES Page: 5 Balance I Used 452010 Office Supplies 392.00 287.35 104.65 73.30 452030 Minor Office Equipment/Furniture 118.00 118.00 452040 Sanitation & Industrial Supplies 240.00 240.00 Total GENERAL SUPPLIES BOORS & PERIODICALS 454020 Subscriptions Total BOORS & PERIODICALS COMPUTER & PRINTING SUPPLIES 455120 Misc Computer Hardware .otal COMPUTER & PRINTING SUPPLIES Total OTHER PURCHASED SERVICES (CHANGE TO OFF OPERATING SUPPLIES AGRICULTURE SUPPLIES 461040 Other Agriculture Chemicals Total AGRICULTURE SUPPLIES REPAIR & MAINT.ENANCE SUPPLIES 466040 Plumbing Supplies 466050 Electrical Supplies 466070 Other Maintenance Supplies Total REPAIR & MAINTENANCE SUPPLIES SURFACING MATERIALS 468030 Asphalt 468050 Sand Total SURFACING MATERIALS 750.00 287.35 462.65 38.31 33.00 33.00 ----------------------------------- ------------ ------------ ------ 33.00 33,00 757.00 757.00 757.00 757.00 ----- ------------ ----------------------- ------------ ----- 1540.00 287.35 1252.65 18.66 80.35 -80.35 ----------- ------------------------------------ ------------ ----- 90.35 -80.35 361,00 1337.57-976,57 370.52 1676.00 919.87 756.13 54.88 947.00 421.50 125.39 525.50 44.51 ------------------------------------ --- --- ---------------- ------ 2984.00 2678.94 125.39 305.06 89.78 45.59 -45.59 37.34 -37.34 ------------------------ ------------------------ ------------ ------ 82.93 -82.93 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 E%PE; 04,15,13 11:15:40 Method: 1 Iowa City General Ledger System FY 2013 Expense Reporting For the period 03,01,13 to 03,31,13 Page: 6 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 340.50 340.50 -340.50 469190 Minor Equipment 758.00 56.59 701,41 7.47 469200 Tools 42.00 515.65 241.80 -473.65 1227.7 469260 Fire Ext & Refills 500.00 418.35 81.65 83.67 469320 Miscellaneous Supplies 833.00 833,00 469360 Food and Beverages 58.08 -58.08 Total OTHER SUPPLIES & EQUIPMENT Total OPERATING SUPPLIES IMPROVEMENTS 0"HER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements 473020 Non -Contracted Improvements Total IMPROVEMENTS OTHER THAN BUILDING OTHER FINANCIAL USES 490040 Capital Project Funding 490150 Operating Subsidy 490190 7nterfund Loan Total OTHER FINANCIAL USES Total Airport Operations Total Airport 2133,00 1389.17 582.30 743.83 65.13 --------------------- 5117.00 ------------ 4231.39 ------------ 707.69 ------------ 885.61 ------ 82.69 20000.00 9515.00 9515.00 10485.00 47.58 9383.28 -9383.28 --------- ------------ 20000.00 ------------ 18898.28 ------------ 9515.00 ------------ 1101.72 ------ 94.49 4620,00 4620,00 100.00 11892.00 8919.00 991.00 2973.00 75.00 282682.00 266666.41 3883.15 16015.59 94.33 --------------------- 299194.00 ------------ 280205.41 ------------ 4874.15 ------------ 18988.59 ------ 93.65 --------------------- 634845.00 ------------ 530476.43 ------------ 36406,11 ------------ 104368,57 ------ 83.56 -------------------- 634845.00 ----------- 530476.43 --- --------- 36406.11 ----------- 104368.57 ------ 83.56 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 54 of 68 EXPE; 04,15.13 11;15;40 Metliod: 1 Page; 7 Iowa City General Ledger System FY 2013 Expense Reporting For the period 93.91.13 to 03.31.13 YT➢ Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used - — ---------------------------------------------------- ------------------------ --------- -------------------------- ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUE➢) 560100 Airport Operations (CONTINUE➢) OTHER FINANCIAL USES (CONTINUED) ------------ ------------ ------------ ------------ ------------ ------ GRAND TOTAL *** 634845.00 530476.43 36406.11 104368.57 83.56 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 6Y.Y+5[:I7 TRID; 04,15,13 11:17:16 Method: 4 ;raps Date Trans Type --------------------- 7600 Airport 560100 Airport Operations 411000 Perm Full Time 03.08.13 Old Sys 03.22.13 Old Sys Total Perm Full Time 413000 Temporary Employees 03.08.13 Old Sys Total Temporary Employees 421100 Health Insurance 03.12.13 Journal Total Health Insurance 421200 Dental insurance 03.12,13 Journal Iowa City General Ledger System Expenditures Detail FY 2013 Detail Reporting For the period 03.01.13 to 03.31.13 Report# Source Description 130306010022 509129�CIC PAYROLL RECAP�PAYROLL 08 130320010011 509228�CIC PAYROLL RECAP�PAYROLL 22 130306010022 509129�CIC PAYROLL RECAP�PAYROLL 08 130328101150 010745 MAR HEALTH INSURANCE�CIC HEALTH INS 130328101150 010744 MAR DENTAL INSURANCWIC DENTAL INS ^otal Dental Insurance 42i300 life Insurance 03.13.13 New Vouch 130314030214 06881961 Check:7254WMADISON NATIONAL LIFE Total Life Insurance 421400 Disability Insurance 03.13.13 New Vouch 130314030214 06881856 Check:7254WMADISON NATIONAL LIFE Total Disability Insurance 422100 FICA 03.08.13 Old Sys 130306010022 3080599�FICA�CITY CONTRIBUTION 03.22,13 Old Sys 130320010011 3220599\FICA�CITY CONTRIBUTION Total FICA 423100 IPERS 03.06.13 Old Sys 130306010022 3080599�IPERS�CITY CONTRIBUTION 03.22.13 Old Sys 130320010011 3220599�IPERS\CITY CONTRIBUTION Page: 1 Debit Credit ------------------------ 1893 .60 1893.60 --------------- 3787.20 25.38 ------- -------- 25,38 389.23 389.23 26.70 26.70 10.75 10.75 19.69 ------------ - ---------- 19.69 145.27 143.33 ------------ ------------ 288.60 166.38 164.16 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 61.=91.1:7 TRIE: 04.15.13 11:17:17 Method: 4 Trans Date Trans Type Iowa City General Ledger System Exuenditures Detail FY 2013 Detail Reporting For the period 03.01.13 to 03,31.13 Report# Source Description Page: 2 Debit Credit --------------------- ------------ ------------------------------------------- ------------------------ 7600 A_rport !CONTINUED) 560100 Airport Operations (CONTINUED) 423100 IPERS (CONTINUED) ------------ - -------- Total IPERS 330.56 438010 Stormwater Utility Charges 03.20.13 Journal 130328101150 010743 057-095-03�STORMWTR�3.20.13 Bill Da 986.26 Total Stormwater Utility Charges 438030 Electricity 03.20.13 New Vouch 03.20.13 New Vouch 03.20.13 New Vouch 03.20.13 New Vouch 03,20.13 New Vouch Total Electricity 438070 Heating Fuel,/Gas 03.20.13 New Vouch 03,20,13 New Vouch 03.20.13 New Vouch Total Beating Fuel,/Gas 438080 Sewer Utility Charge 03.20.13 Journal 03.20.13 Journal 03.20.13 Journal 03.20.13 Journal 03.28.13 Misc Pymt Total Sewer Utility Charge 438090 Water Utility Charge 03.20.13 Journal 03.20.13 Journal 03,20,13 Journal ------------------------ 986.26 130321030159 06786274 Check:7257WMIDAMERICAN ENERGY�HAN 73.06 130325030019 00902847 Check:910037�MIDAMERICAN ENBRGY�180 143.44 130325030019 00902908 Check:910037MDAMERICAN ENERGY�180 872.76 130325030019 00902910 Check:910037�MIDAMERICAN ENERGY�180 83.37 130325030019 00902912 Check:910037MDAMERICAN ENERGY�180 257.16 ------------------------ 1429.79 130325030019 00902867 Check:910037�MIDAMERICAN ENERGY�180 80.54 130325030019 00902909 Check:910037�MIDAMERICAN ENERGY�180 605.50 130325030019 00902911 Check:910037MDAMERICAN ENERGY�180 137.54 ------------ 823.58 ----------- 130328101150 010743 057-120-WSEWER�3.20.13 Bill Date 54.43 130328101150 010743 057-118-WSEWER�3.20.13 Bill Date 44.06 130328101150 010743 057-117-WSEWER�3.20.13 Bill Date 20.12 130328101150 010743 057-115-WSEWER�3,20.13 Bill Date 8.15 130328090611 1.8�AIRPORT COMMISSION�SEWER 057114 17.46 ------------ ------------ 144.22 130328101150 010743 057-120-00�WATER�3.20.13 Bill Date 41.09 130328101150 010743 057-118-03�WATER�3.20.13 Bill Date 33.32 130328101150 010743 057-117-WWATER�3.20.13 Bill Date 15.33 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 57 of 68 TP,ID: 04.15.13 11:17:17 Method: 4 Paae: 3 Iowa City General Ledger System Expenditures Detail PY 2013 Detail Reporting For the period 03.01.13 to 03.31,13 Trans Date Trans Type Repertk Source Description Debit Credit ----------- ---------- ------------ ------ 7600 Airport (CONTINUE➢) 560100 Airport Operations (CONTINUED; 438090 Water Utility Charge (CONTINUE➢ 03,20.13 Journal 130328101150 010743 03.20.13 Journal 130328101150 010743 03.20.13 Misc Pymt 130328090611 057-115-00\WATER\3.20.13 Bill Date 057-095-03\WATER\3.20.13 Bill Date 1-8\AIRPORT COMMISSION\WATER 057114 Total Water Utility Charge 438100 Refuse Collection Charges 03.13.13 New Vouch 130314030214 06780384 Check:725549\ABC DISPOSAL SYSTEMS I 03.13.13 New Vouch 130314030214 06780384 Check:725549\ABC DISPOSAL SYSTEMS I Total Refuse Collection Charges 438120 Long Distance Service 03,01.13 Ph Lon Est 130401111754 00003019 MAR LONG DIST CHGBK Total Long Distance Service 492010 Other Building Repair & Maintenance Ser 03.08.13 New Vouch 130311030017 06773955 Check:725487\OVERHEAD DOOR COMPANY 03.12.13 New Vouch 130313030023 06778316 Check:725459\JET AIR INC IOW\CLEANI Total Other Building Repair & Maintenance Servi 442030 Heating Equipment Repair & Maintenance 03.19.13 New Vouch 130320030019 06781398 Check:725671\EELLY HEATING & A/C IN Total Heating Equipment Repair & Maintenance Se 442060 Electrical & Plumbing Repair & Maintena 03,08.13 New Vouch 130311030017 06773917 Check:725465\LYNCH'S PLUMBING INC\P 03,12.13 New Vouch 130313030023 06776266 Check:725391\ADVANCED ELECTRICAL SE 03.12.13 New Vouch 130313030023 06778276 Check:725459\JBT AIR INC IOW\NAINT Total Electrical & Plumbinq Repair & Maintenanc 442070 Bldg Pest Control Services 03.13,13 New Vouch 130314030214 06790314 Check:7254491HAWREYE PEST CONTROL I 16.47 11.04 17.39 ------------ ------------ 134.69 61.00 28.00 - -------------------- 97.00 2 2.01 ------------ ------------ 2.01 174.00 600.00 ---------- -------- 774,00 240.00 240.00 215.00 557.25 106.68 ------------------------ 878.93 33.95 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 58 of 68 TRID; 04,15.13 11;17:17 Method: 4 Page: 4 Iowa City General Ledger System Expenditures Detail EY 2013 Detail Reporting For the period 03.01.13 to 03.31,11 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations !CONTINUED) Total Bldg Pest Control Services ------------ ------------ 33,95 443080 Other Equipment Repair & Maintenance Se 03.12.13 New Vouch 130313030023 06778276 Check:725459\JET AIR INC IOW�MAINT 221.41 Total Other Equipment Repair & Maintenance Sery ------------ 221.41 ------------ 445080 Snow and Ice Removal 03.12.13 New Vouch 130313030023 06778293 Check:725459�JET AIR INC IOW\SNOW R 4500.00 Total Snow and Ice Removal ------------ 4500.00 ------------ 446100 City Attorne, Chargeback 03.31.13 Journal 130404195333 010751 Jan -Mar CityAtty chg\1nterdepartmen 569.00 Total City Attorney Chargeback ------------ 50.00 ------------ 446140 ITS -Computer Replacement Chargeback 03.01.13 IT Repl 130312113510 00003025 MAR ITS REPL CHGBCE 101.42 Tot al 'IS -Computer Replacement Chargeback ------------ 101.42 ------------ 446160 ITS-Network(Internet Chargeback 03.01.13 IT Int/Nwk 130304131224 00003031 MAR ITS NETW;INTRNET 60.00 Total ITS-Network/Internet Chargeback ------------ 60.00 ------------ 446220 Phone Service Chargeback 03.31,13 Qwest Chrg 13040215351) 00003032 Mar Telecom Charges 95.43 Total Phone Service Chargeback ------------ 95.43 -- 416300 Phone Equipment/Line Chargeback 03.01.13 Ph Equipmt 130401111754 00003018 MAR PHON EQUIP CHGBx 92.50 Total Phone Equipment/Line Chargeback ------------ 92.50 -- ---------- 446350 City Vehicle Replacement Chargeback 03.31.13 EQ Repl 130404165142 00003006 MAR REPLACEMENT COST 1363.72 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 6XI5[:17 TRIO: 04.15.13 11:17:17 Method: 4 Iowa City General Ledger System Expenditures Detail FY 2013 Detail Reporting For the period 03.01.13 to 03.31.13 Trans Date Trans Type Report# Source Description ----------- ---------- ------------ -------- ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) Total City Vehicle Replacement Chargeback 446370 Fuel Chargeback 03.31.13 EQ Div 130404165142 00003008 MAR DIVISION FUEL Total Fuel Chargeback 446380 Vehicle Repair & Maintenance Chargeback 03.31.13 EQ Div 130404165142 00003008 MAR DIVISION SERVICE Total Vehicle Repair & Maintenance Chargeback 449360 Interest Expense 03,31.13 Journal 130328101150 010739 Corp Hangar Loan Int`Mar Interfund 03.31.13 Journal '30328101150 010739 DI Hangar Loan IrOar Interfund Lo 03.31.13 Journal 130328101150 010739 SW T-Hngr Loan Int`Mar Interfund Lo Total Interest Expense 466070 Other Maintenance Supplies 03.06.13 New Vouch 130311030017 06774343 Check:7255051SENECA COMPANIES\REPLA 03.12.13 New Vouch 130313030023 06778276 Check:725459IJET AIR INC IOW\MAINT Total Other Maintenance Supplies 469040 Traffic Control Improvement Supplies 03.12.13 New Vouch 130313030023 06778276 Check:725459`JET AIR INC IOW�MAINT Total Traffic Control Improvement Supplies 469200 Toole 03.12.13 New Vouch 130313030023 06778276 Check:725459\JET AIR INC TOWIMAINT Total Tools 473010 Contracted Improvements 03.20.13 New Vouch Total Contracted Improvements 130321030159 06787697 Check:725712\RANDY'S CARPETS & INTE Page: 5 Debit Credit ------------ ------------ _---------------- 1363 .72 262.66 ------------ ------------ 262.66 682.73 ------------ 682.73 1715.03 1204.79 18.04 ------------------------ 2937.86 109.43 15.96 ------------ ----- ------ 125.39 340.50 ------------------------ 340,50 241.80 ------------------------ 241.60 9515.00 ------------ ------------ 9515.00 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 [HRS[:17 TRID: 04.15.13 11:17:17 Method: 4 Iowa City General Ledger System Expenditures Detail FY 2013 Detail Reporting For the period 03.01.13 to 03,31.13 Trans Date Trans Type Report# Source Description ----------- --------- ------------ -------- ----------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 00150 Operating Subsidy 03.31.13 Journal 130328101150 010736 Airport 10$ ED Coord�Mar Budgeted 0 Total Operating Subsidy 590190 Interfund Loan 03.31.13 Journal 130328101150 010739 Corp Hangar Loan Prn�Mar Interfund 03.31.13 Journal 130328101150 010739 UI Hangar Loan Princ�Mar lnierfund 03.31.13 Journal 130328101150 010739 SW T-Hngr Loan Princ�Mar Interfund Total Interfund Loan Total Airport Operations Pace: 6 Debit Credit 991.00 ---------------------- 991.00 1294,97 1186.73 1411.45 3883.15 ------------------------ 36406.11 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 61 of 68 TRID: H. 15.13 11:17:17 Method: 4 Page: 7 Icwa City General Ledger System Expenditures Deta l FY 2013 Detail Reporting For the period 03.01.13 to 03.31.13 trans Date Trans Type Report# Source Description Debit Credit ------------ - -------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUE➢ ------------ ------------ Total Airport 36406.11 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 62 of 68 TRID: 04.15,13 11:17:17 Method: 4 Page: 8 Iowa City General Ledger System Expenditures Detail FY 2013 Detail Reporting For the period 03.01.13 to 03.31,13 Trans Date Trans Type Report# Source Description Debit Credit ------------- -- ------- -- 7600 Airport (CONTINUED; 560100 Airport Operations (CONTINUED; 490190 Intertund Loan (CONTINUED ------------------------ "' GRAND TOTAL ### 36406,11 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 1*11791*3 TRID: 04,15.13 11,17,30 Method: 4 Iowa City General Ledger System Revenues Detail FY 2013 Detail Reporting For the period 03.01.13 to 03.31.13 Page: 1 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------------------- ------------------------------------------------------- ------------ 7600 Airport 560100 Airport Operations 381100 Interest on Investments 03.31.13 Allocation 130409083111 Mar interest allocation 42.56 Total Interest on Investments 42.56 382100 Land Rental 03.14.13 Payment 130314091136 00024342 2-11\BELL LARRY & SANDRA�PAYMENT 300.00 03,21.13 Payment 130321090410 00024356 2-8`JET AIR`MAR 13\GROUND LEASE 106.67 03.2B.13 Misc Pymt 130402141302 70-6`ARME➢ FORCES RESERVE�02f13 LEA 350.00 Total Land Rental ---------- ------------ 756.E7 382200 Building/Room Rental 03.01.13 Payment 13030109324E 00024277 2-10�SCHNELL TOMAAR 13,HANGAR #62 178.00 03.01.13 Payment 13030109324E 00024318 2-11�STHARMWMAR 13IHANGAR #47 172.00 03.01.13 Payment 13030109324E 00024321 2-8�DOWNBS GREG�MAR 13�HANGAR #51 172.00 03.04.13 Payment 130304100522 00024272 1-14�PITTON MI%E�MAR 13�HANGAR #43 172.00 03.05.13 Payment 130305091655 00024008 1-27\SHEPHERD TODD & JULIR`FEB 13` 144.00 03.05.13 Payment 130305091655 00024248 1-19\FLUGZEUG LLC\MAR 13\HANGAR 442 172.00 03.05.13 Payment 130305091655 00024249 1-21`KURT STEVEN`MAR 13\HANGAR 412 151.00 03.C5.13 Payment 130305091655 00024279 1-22�HALL ROBERT`MAR 13�HANGAR #6 144.00 03,05.13 Payment 130305091655 00024279 1-22�HALL ROBERT\MAR 13\HANGAR #7 144.00 03.06.13 Payment 130306090146 00024268 2-9�BRUMLEY JAMES�MAR 13�HANGAR #2 151.00 03.06.13 Payment 130306090146 00024278 2.4�BULLERS JONATHAN�MAR 13,HANGAR 151.00 03.07.13 Payment 130307092123 00024285 2-10HARTWIG RANDYIMAR 13�HANGAR # 172.00 03.07,13 Payment 130307092123 00024354 1.5�GOREE JOHN & SUSAN�MAR 13\HANG 172.00 03.11.13 Payment 130311092512 00024283 1-13�MASCARI RICR�MAR 13�HANGAR #4 209.00 03.11.13 Payment 130311092512 00024284 1-11�BUTLFR JOHN�MAR 13�HANGAR 436 172.00 03.11.13 Payment 130311092512 00024284 1-11� UTLER JOENIMAR 13�EANGAR #37 172,CC 03.12.13 Payment 130312094525 00024350 2-1�ROHR BRIAN\MAR 13\HANGAR #27 151.00 03.12.13 Payment 130312094525 00024317 2-6�OPERATOR PERFORMANCE LAB�MAR 13 615.CC 03.12.13 Payment 130312094525 00024317 2-6�OPERATOR PERFORMANCE LAB�MAR 13 4C38.CC 03.12.13 Payment 13C312094525 00023358 2-7�OPERATOR PERFORMANCE LAB�NOV 12 615.00 03.12.13 Payment 130312094525 00023358 2-7�OPERATOR PERFORMANCE LAB�NOV 12 4038.00 03.12.13 Payment 130312094525 00024275 1-18,DEMARIA JOSEMMAR 13�HANGAR 151.00 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 RLl.S[H:7 TRID: 04.15.13 11:17:31 Method: 4 Iowa City General Ledger System Revenues Detail BY 2013 Detail Reporting For the period 03,01,13 to 03.31.13 Trans Date Trans Type Report# Source Description 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 03.12.13 Payment 130312094525 00024261 1-19\RUYLE JOHN\MAR WHANGAR 033 03.13.13 Payment 130313093040 00024292 1-1\NE IA PHYS THERPY ASSOC\MAR 13\ 03.13.13 Payment 130313093040 00024280 2-3\BULGARELLI DAVID\MAR 13\HANGAR 03.13.13 Payment 130313093040 00024231 1-18\FIELD HOWARD\MAR 13\HANGAR #5 03.14.13 Payment 130314091136 00024295 2-13\ZUBROD ROY�MAR 13�11ANGAR #20 03,15.13 Payment 130315095640 00024234 1-B\ANDERSEN JASON\MAR 13�HANGAR # 03,15,13 Payment 130315095640 00024234 1-8\ANDERSEN JASON\MAR 13�HANGAR # 03.15.13 Payment 130315121950 00024229 89-1\MILLER RICHARD\MAR 13\HANGAR 03.15.13 Payment 130315121950 00024242 89-6\YAMADA THORU\MAR 13\HANGAR 42 03,15.13 Payment 130315121950 00024259 89-9\HINCKLEY HARRY\MAR 13\HANGAR 03.15.13 Payment 130315121950 00024259 89-9\HINCKLEY HARRY\MAR 13\HANGAR 03.15.13 Payment 130315121950 00024263 89-10\VOS JEREMY\MAR 13\HARNGAR #6 03.15.13 Payment 130315121950 00024264 89-11�FARKAS BDWARD & LINDOAR 13 03.15.13 Payment 130315121950 00024288 89-12\FISHBAUGH JUSTIN\MAR WEANG 03.15.13 Payment 130315121950 00024291 89-13\PATTSCHULL RICHARD\MAR 13�HA 03.15.13 Payment 130315121950 00024293 89-14\ALLENDER PATRICK\MAR 13\HANG 03,15.13 Payment 130315121950 00024305 89-16\BDMONDS TERRY\MAR 13�HANGAR 03,15.13 Payment 130315121950 00024310 89-20`SQUADRONS UP`MAR 13�HANGAR #5 03.15.13 Payment 130315121950 00024312 89-21�GURNETT DON`MAR 13�HANGAR #3 03,15.13 Payment 130315121950 00024326 89-23`SWANSON NAOMI`MAR 13,HANGER 03.15.13 Payment 130315121950 00024345 89-28�COHN GARY\MAR 13\HANGAR 041 03.15.13 Payment 130315121950 00024348 89-30�MBADB JAMES N%R 13\HANGAR 03.19.13 Payment 130319092344 00024294 2-7�CHALKLEY BEN�MAR 13�EANGAR #14 03,20.13 Payment 130320092202 00024290 2-4�LACINA DAVE\MAR 13�HANGAR #57 03.21.13 Payment 130321090410 00024314 24\JET AIR INC�MAR 13�EUILDINGS D 03.21.13 Payment 130321090410 00024325 2-8�JET AIR`MAR 13,HANGAR 41 03.21.13 Payment 130321090410 00024325 2-BIDET AIR`MAR 13,HANGAR 459 03.21.13 Payment 130321090410 00024325 2-8,JET AIR\MAR 13,HANGAR #60 03.21.13 Payment 130321090410 00024325 2-9�JET AIR\MAR 13�EANGAR #72 03.26.13 Payment 130326093146 00024,313 1-11�ROOF KEITH\MAR 13�HANGAR #30 03.29.13 Pavment 130329092655 00024473 2-3�N6226W INC\APR 13I11ANGAR 449 03.29.13 Payment 130329092655 00024503 2-4�POWERS ROBERT\APR 13\HANGAR 49 Debit Page: 2 Credit 358.00 202.00 151.00 172.00 151.00 144.00 144.00 172.00 151.00 144.00 404.00 196.00 151.00 178,00 234.00 172.00 320,00 172,00 310,00 144,00 172.00 172.00 151.00 202.00 4287.00 144.00 178.00 178.00 650.00 15i.00 172.00 144.00 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 [:111179:17 TRI➢: C4.15.13 11:17:31 Method: 4 Pane: 3 Iowa City General Ledger System Revenues Detail FY 2013 Detail Reporting For the period 03.01.13 to 03.31.13 Trans Date Trans Type Report# Source Description Debit Credit ---------------------------------------------------------------------------------------------------- 76CC Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 03,29.13 Payment 130329092655 00024431 2-5�CARE AMBULANCE�APR 13\OFFICE 03.20,13 Payment 130321092655 00024508 2-6�DOWNES GREG�APR 13�HANGAR #51 03.29,13 Payment 130329092655 00024476 3-7`OCKENFBLS JOHN / WINGNUTS�APR 03.29.13 Payment 130329092655 00024476 3-7�CCKENFELS JOHN / WINGNUTS�APR 03,29,13 Payment 130321012655 00024476 3-7`OCKENFELS JOHN / WINGNUTS�APR Total Building/Room Rental 384200 Vending Machine Comm 03.29.13 Misc Pymt 130329092701 Total Vending Machine Comm 384900 Other Commissions 03.21.13 Misc Pymt 130321010416 1-16�AMERICAN BOTTLING CC�VENDING C 2-9�EASTERN AVIATION FUELS�FEB 13 F "otal Other Commissions 393120 General Levy 03.31.13 Journal 130328101150 010736 Ptax to AirporOlar Budgeted Operat Total General Levy Total Airport Operations 100.00 172.00 209,00 650.00 110.00 24168.00 10.80 ------------ 10.80 1600.70 1600.70 8333.33 ------------ ------------ 8333.33 ------------------------ 34912.06 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 66 of 68 TRID; 04.15.13 11:17:31 Method: 4 page; 4 Iowa City General Ledger System Revenues Detail FY 2013 Detail Reporting For the period 03.01.13 to 03.31.13 Trans Date Trans Tvpe Report# Source Description Debit Credit ----------- ---------- ------------------------------------------------------- ------------------------ 7600 Airport !CONTINUED) 560100 Airport Operations (CONTINUED) ------------ ------------ Total Airport 34912.06 Iowa City Airport Commission Agenda and Info Packet 4-19-2013 67 of 68 TRID: 04.15.13 11:17:31 Method: 4 Page: 5 Iowa City General Ledger System Revenues Detail FY 2013 Detail Reporting For the period 03.01.13 to 03.31.13 Trans Date Trans Type Report# 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED; "' GRAND TOTAL *** Source Description Debit Credit -------- ------------------------------- --------------------------- ------------ ------------ 34912.06 ------------ ------------ ----------------- ------- Iowa City Airport Commission Agenda and Info Packet 4-19-2013 68 of 68 Sub -committee List Iowa City Municipal Airport Commission Assignment Budget Community Liason Economic Development Events Infrastructure Last Updated: March 2013 Members Chair, Secretary, Ops Specialist Assouline, Ogren, Tharp Assouline, Horan, Tharp Gardinier, Hofineyer, Tharp Gardinier, Hofineyer, Tharp Reports Due August/February September/March October/April November/May January/June