Loading...
HomeMy WebLinkAbout06-21-2012 Airport CommissionAirport Commission Packet 6/21/12 Page 1 of 51 IOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JUNE 21, 2012 - 6:00 P.M. 1. Determine Quorum 1 min* 2. Approval of Minutes from the following meetings: 5 min May 17, 2012 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion / Action: a. Airport Commerce Park 5 min b. Terminal Building Brick Repair 5 min i. Consider a resolution accepting work for Terminal Building Exterior Repairs c. Hangar L 5 min d. FAA/IDOT Projects: AECOM / David Hughes 15 min i. Obstruction Mitigation ii. 7/25 Parallel Taxiway Grading & Drainage iii. 7/25 Parallel Taxiway Paving & Lighting 1. Public Hearing 2. Consider a resolution accepting plans and specifications for Runway 7/25 Parallel Taxiway Paving and Lighting for construction iv. Airport Electrical Rehab 1. Consider a resolution awarding contract for Airport Electrical Rehabilitation e. Aviation Authority 15 min f. Airport "Operations" 15 min i. Strategic Plan- Implementation ii. Budget iii. Management 1. Consider a motion to support the general concept of serving alcohol at events, with approval of the Iowa City Airport Commission, held at the Iowa City Municipal Airport. g. FBO /Flight Training Reports 5 min i. Jet Air ii. Iowa Flight Training h. Subcommittee Report 5 min i. For June: Infrastructure (Horan, Mascari, Tharp) ii. For July: No reports 2 min i. Commission Members' Reports 2 min j. Staff Report 2 min 5. Set next regular meeting for July 19, 2012 at 6:00 p.m. 6. Adjourn *The times listed in the agenda are the anticipated duration of that particular agenda item. The actual discussion may take more or less time than anticipated Airport Commission May 17, 2012 Page 1 MINUTES IOWA CITY AIRPORT COMMISSION MAY 17, 2012 — 6:00 P.M. AIRPORT TERMINAL BUILDING Airport Commission Packet 6/21/12 Page 2 of 51 DRAFT Members Present: Jose Assouline, Minnetta Gardinier, Howard Horan, Rick Mascari Staff Present: Sue Dulek, Michael Tharp Others Present: Jeff Edberg, David Hughes, Toby Myers RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None CALL TO ORDER: Chairperson Assouline called the meeting to order at 6:04 P.M. APPROVAL OF MEETING MINUTES: Minutes of the April 19, 2012, meeting were reviewed. Mascari moved to approve the minutes of the April 19, 2012, meeting as submitted; seconded by Horan. Motion carried 3 -0; Gardinier absent. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION /ACTION: a. Airport Commerce Park — Jeff Edberg addressed the Members, noting that he has been getting frequent calls on the lots but nothing solid yet. He then responded to Members' questions, noting that with summer approaching he hopes to see increased interest. Members asked about the option period and if Deery had indicated if they were going to exercise their options for additional lots. Edberg will check with Deery Brothers to see if they want to take advantage of being able to purchase an additional lot. Mascari discussed other ideas for uses, mentioning that when the lots were first marketed, a group was interested in putting in an IMAX theater in the area. A brief discussion ensued about the history of this and other ideas previously considered. b. Terminal Building Brick Repair — Tharp noted that this afternoon they did a completion walk- through, and there are just a few things left to complete — the planter, some touch- up work, the keypad area. Members briefly discussed the damage done to the door keypad, noting that it was damaged by the acid wash used during repairs. Tharp will look into this issue and let Members know what he finds out. c. Hangar L — Tharp stated that he is working with the contractor on this and they hope to have a groundbreaking schedule in the next week or so. d. FAA /IDOT Projects /AECOM: i. Obstruction Mitigation — David Hughes stated that they have done some additional survey work on this. Airport Commission Packet 6/21/12 Page 3 of 51 Airport Commission May 17, 2012 Page 2 ii. 7/25 Parallel Taxiway — The contractor will be starting back to work on this in the next few days, according to Hughes. Plans and specs have been reviewed by the FAA and are now ready for the public hearing to be set. 1. Consider a resolution setting a public hearing on plans, specifications, and form of contract for Runway 7/25 Parallel Taxiway Paving and Lighting — Mascari moved to consider Resolution #Al2 -18, setting a public hearing on plans, specifications, and form of contract for the Runway 7/25 Parallel Taxiway Paving and Lighting project; seconded by Gardinier. Motion carried 4 -0. Gardinier noted that she will be out of town for the next Commission meeting, June 21. Tharp added that all other Members will need to be present in order to meet a quorum, or the meeting needs to be rescheduled so more Members are able to attend. e. Airport Electrical Rehab — Hughes noted that he met with Tharp earlier today to go over these plans. He then briefly responded to Members' questions. f. AOPA Airport Support Network — Mascari noted that Members should have copies of the AOPA information that he received and sent to them. He briefly summarized the information, noting that federal grant money is shown to be 90% FAA, 5% state, and 5% local. Tharp noted that they typically have not had any luck getting the state's 5% match. Mascari continued, stating that the information from AOPA also talks about how they can promote the Airport. He stated that one of the ideas is to have an open house. The discussion continued, with Mascari summarizing some of the AOPA suggestions on such issues as being a good neighbor, noise reduction, and public education. Mascari added that he would like to see them move forward with promoting the Airport by using some of the AOPA suggestions. g. Aviation Authority — Assouline stated that he did meet with Jeff Davidson recently to talk about the Riverfront Crossings area. He shared with Members what he learned from this meeting, noting that Davidson is willing to come to a Commission meeting to speak about this, if the others are interested. The discussion continued, with Tharp laying out how this topic came up recently. Basically, if they were to switch to an aviation authority, it would require a lot of steps and information sharing, according to Tharp. Horan weighed in on the topic, stating that he is encouraging Tharp to share with others, such as the CVB and the Chamber, all that the Airport has accomplished. He believes that the Airport needs to be presented to be as strong and substantial as possible. The discussion continued, with Assouline stating that he believes Davidson could help them to review this matter, and that knowing the City's position on this would be good to know. Gardinier added that she felt the articles in the Corridor Business Journal were dismissive of the Iowa City Airport. Assouline added that he believes they should not take this too seriously. Members continued to discuss the issue, with Assouline noting that they need to educate themselves on the topic first, before they can educate others. Members continued to discuss the possibility of an aviation authority, with Dulek responding to questions and concerns. Gardinier suggested that someone from the Commission attend the Cedar Rapids' Airport meetings to see if the topic comes up. This, and talking to similar airports in the state that have gone to an authority, will help to educate the Members as they move forward. Tharp will make some phone calls to see what he can set up and will get additional information for the Commission to review. h. South Airport Development — Tharp stated that he did not have anything new to share, but he asked Assouline to share his conversation with Jeff Davidson from the Planning Airport Commission Packet 6/21/12 Page 4 of 51 Airport Commission May 17, 2012 Page 3 department. As a follow -up to Davidson's presentation, Assouline stated that he asked if there was anything new to share with the Commission regarding this. He stated that Davidson did share some maps and other possible plans for the area, and that he will share these with Members when he returns to do a follow -up with them. Members continued to discuss the various options for the area south of the Airport, and how development along the riverfront could play into this. L Airport "Operations ": L Strategic Plan — Implementation — Tharp briefly addressed their plan, stating that they may want to review this in the next month or so. ii. Budget — Tharp noted that they have about six weeks left in the current fiscal year. The budget will break even, as has been previously discussed. He added that he has looked into the bathroom issue that Gardinier brought up at the last meeting and they should be able to do this in- house. The project would include countertops and urinals, according to Tharp. Mascari then asked for some clarification on the Airport's total budget. iii. Management — None. j. FBO / Flight Training Reports: L Jet Air / Air Care — Toby Myers with Jet Air addressed the group next. He stated that they may be bringing more jets to the field soon. He added that their shop has been extremely busy lately, as business continues to improve. Jet Air is hoping to become a Cessna service center for Iowa, according to Myers, and has begun the process to do so. The discussion turned to a possible open house, with Jet Air being interested in hosting some type of event. 1. Public Hearing — Assouline opened the public hearing. Tharp briefly noted that this is for the ground lease with Jet Air for a piece of land on the east side of the University's building, where they will put up an 80 by 80 hangar, and after a 30 -year ground lease, the hangar will be turned over to the Airport. He also responded to Members' questions and concerns regarding this lease. Assouline closed the public hearing. 2. Consider a resolution approving ground lease with Jet Air, Inc. — Horan moved to consider Resolution #Al2 -19, approving a ground lease with Jet Air, Inc.; seconded by Mascari. Motion carried 4 -0. ii. Iowa Flight Training — None. k. Subcommittee Reports — Tharp stated that tonight is the Events Subcommittee's turn. Horan noted that they will have this ready for the next meeting. Gardinier has been talking with the Barnstormer's group about an event, and also a Young Eagle's event. Members briefly discussed what it would cost to have TV or radio advertisements for such events. Tharp will look into this further. Gardinier added that Tim Busch is interested in doing youth aviation events and suggested they contact him regarding this. I. Commission Members' Reports — Horan shared that he has had more flight time in the past month. Members briefly talked about how they might increase interest in the Commission position that is still open. Mascari asked what the problem was last month with the windsock lights. Tharp noted that they just needed to be replaced. He then asked if there are any hangars currently being used for something other than aircraft, such as storage. Tharp stated that as far as he knows there are no hangars being used just for storage, that he keeps fairly close tabs on who is on the field. Gardinier then Airport Commission Packet 6/21/12 Page 5 of 51 Airport Commission May 17, 2012 Page 4 brought up the huge key ring with keys to most of the hangars on it. She stated that they should remove old keys and those that belong to unknowns. m. Staff Report — Tharp stated that on July 17 and 18 there will be a training opportunity in Cedar Rapids for airport executives that he would like to attend. Tharp will also be taking part in some special training at the Airport next week. SET NEXT REGULAR MEETING FOR: The next regular meeting will be Thursday, June 21, 2012, at 6:00 P.M. at the Airport Terminal building. ADJOURN: The meeting adjourned at 7:55 P.M. Horan made the motion to adjourn the meeting at 7:55 P.M.; seconded by Mascari. Motion carried 4 -0. CHAIRPERSON DATE Airport Commission May 17, 2012 Page 5 Airport Commission Packet 6/21/12 Page 6 of 51 Airport Commission ATTENDANCE RECORD 2012 Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent /Excused NM = Not a Member at this time TERM O O O O O O O N W � � Ull O NAME EXP. m rn Cn O Cn m N N N N N N N N 03/01/13 X X X X X X Rick Mascari 03/01/14 X X X X X X Howard Horan Minnetta 03/01/15 X X X X X X Gardinier Jose 03/02/12 O/E X X X X X Assouline Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent /Excused NM = Not a Member at this time r Comme m '.T' t.ate Serv1— C—P Airport Commission Packet 6/21/12 Page 7 of 51 Marketing Services Report June 6, 2012 Skogman Realty 2530 Corridor Way, Suite #302 Coralville, Iowa 52241 Prepared by: Jeff Edberg, CCIM, SIOR, green Prepared for: Assouline, Jose Tharp, Michael Email: joeassouline @gmail.com Michael- Tharp @iowa- city.org Property: Ruppert Road, Iowa City- MASTER FILE Flyer: www. icrealestatetours. com /FlyerPDFs /RuppertRdLots.pdf Virtual Tour: Pro - Forma: PW: http : / /lt9ruppertrd.skogman.com/ Iowa City MLS: 20110622 Cedar Rapids MLS: 1100686 6/1/2012: Advertised in PC Real Estate Guide. 5/25/2012: Advertised in PC Real Estate Guide. 5/11/2012: Advertised in PC Real Estate Guide. 4/27/2012: Advertised in PC Real Estate Guide. 4/13/2012: Advertised in PC Real Estate Guide. 4/2/2012: Closing on Lot 16 & 17 4/2/2012: Ordered sign to be moved 3/30/2012: Advertised in PC Real Estate Guide. 3/16/2012: Advertised in PC Real Estate Guide. 3/2/2012: Advertised in PC Real Estate Guide. 3/1/2012: Advertised in printed In -Sites Magazine Airport Commission Packet 6/21/12 Page 8 of 51 2/24/2012: Advertised in PC Real Estate Guide. 2/10/2012: Advertised in PC Real Estate Guide. 1/30/2012: Submitted to In -Sites Publication for print magazine 1/27/2012: Advertised in PC Real Estate Guide. 1/18/2012: Presented to possible tenant for retail / service location 1/13/2012: Advertised in PC Real Estate Guide 12/30/2011: Advertised in PC Real Estate Guide. 12/16/2011: Advertised in PC Real Estate Guide. 12/2/2011: Advertised in PC Real Estate Guide. 11/25/2011: Advertised in PC Real Estate Guide. 11/18/2011: Signed Offer to Purchase Lot 16 & 17 11/11/2011: Advertised in PC Real Estate Guide. 10/28/2011: Advertised in Press Citizen Real Estate Guide. 10/26/2011: Advertised in 10/14 Press Citizen Real Estate Guide. 10/3/2011: Advertised in 9/30 Press Citizen Real Estate Guide. 9/30/2011: Jeff working with client on LOI for lot 16. 9/16/2011: Advertised in 9/16 Press Citizen Real Estate Guide. 9/15/2011: Submitted Lot information to prospective Buyer. 8/30/2011: Submitted for ad in 9/2/2011 Press Citizen Real Estate Guide. 8/19/2011: Advertised in Press Citizen Real Estate Guide. 8/8/2011: Listings advertised in 8/5/2011 Press Citizen Real Estate Guide. 7/29/2011: Submitted for ad in August Insights magazine. 7/26/2011: Call from Cedar Falls developer wanting the lot, site prep and grading done for free by the City. 7/19/2011: Listings to be advertised in 7/22/2011 Press Citizen Real Estate Guide. 7/11/2011: Listings advertised in 7/8/2011 Press Citizen Real Estate Guide. Airport Commission Packet 6/21/12 Page 9 of 51 7/6/2011: Attend June Commission meeting 6/24/2011: Listings advertised in Press Citizen Real Estate Guide. 6/14/2011: met with a client regarding building on the airport lots. 6/10/2011: Lots advertised in Press Citizen Real Estate Guide. 6/1/2011: Lots advertised in Press Citizen Real Estate Guide. 5/9/2011: Updated MILS, flyer, commence with Leasing data 5/1/2011: These new marketing reports reflect showings, advertising and significant marketing events for your listing. They will be sent monthly to help you stay in touch with the marketing progress we're making. We have started these reports on 5 -1 -2011, so no activity prior to that date will be reflected, but everythng after that date will be. Thank you for your assignment! January 10, 2011 Attend City Council meeting for approval of listing Agreement January 18, 2011 Obtain sales comparables for lots from, appraiser. Review legal records for Airport lots. January 19, 2011 Meet Howard Horan and Michael Tharp at airport conference room for briefing on Airport History January 20, 2011 Attend Airport Commission Meeting. January 21, 2011 Meet Tom Marcus, Sue Dulek, Dale Henning, Wendy Ford, Howard Horan and Michael Tharp at City Manager's conference room for progress meeting. January 22, 2011 January 23, 2011 Care business. January 29, 2011 February 9, 2011 purchase offer. February 11, 2011 February 17, 2011 Install site signs. Receive sign call on lot 17, 16. Make appointment to spec out building for Dog Meet client and builder to plan a building on lot 17. Will meet again next week. Met client, went over building plans. Will meet lender next week and prepare Submit information on lots to Insites Magazine. Submit information to Press Citizen for Real Estate Guide Back Cover February 17, 2011 Call client regarding next meeting with lender. Client had surgery. Airport Commission Packet 6/21/12 Page 10 of 51 February 17, 2011 Commission meeting. February 22, 2011 Promote site to potential industrial client March 4, 2011 New Real Estate Guide came out with ad on back cover March 9, 2011 Offer lot to industrial client for warehouse operation. March 10, 2011 Commission meeting. March 11, 2011 New Real Estate Guide came out with ad on back cover. March 15, 2011 Contacted party interested in lot 16, made an appointment to meet at their lender to pursue the financing on a building and an offer on lot #16. March 15, 2011 prepared and sent a new schedule for leasing rates to City and Commission. March 18, 2011 New Real Estate Guide came out with ad on back cover March 25, 2011 New Real Estate Guide came out with ad on back cover March 31, 2011 New Real Estate Guide came out with ad on back cover April 7, 2011 New Real Estate Guide came out with ad on back cover April 14, 2011 New Real Estate Guide came out with ad on back cover April 14, 2011 Commission meeting. April 15, 2011 Contacted dog business and suggested a lease scenario. They said they would consider it. I'll follow up. April 21, 2011 New Real Estate Guide came out with ad on back cover April 29, 2011 New Real Estate Guide came out with ad on back cover Airport Commission Packet 6/21/12 Page 11 of 51 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319 - 356 -5045 RESOLUTION NO. RESOLUTION ACCEPTING THE WORK FOR THE "TERMINAL BUILDING BRICK REHABILITATION" WHEREAS, the Commission's consultant for the above named project, VJ Engineering, has recommended that the work associated with the project, by T N T Tuckpointing & Building Restoration Inc LLC., be accepted as complete. WHEREAS, the final contract price is $ 97,450.00 which is established from the original contract cost of $93,850.00 plus $3600.00 from Change Order #1 NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION THAT: Said improvements are hereby accepted by the Iowa City Airport Commission. Passed and approved this day of 12011. CHAIRPERSON ATTEST: SECRETARY It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays Approved by City Attorney's Office Absent the Resolution be Assouline Crane Gardinier Horan Mascari Airport Commission Packet 6/21/12 Page 12 of 51 VJ engineering 463 northland avenue ne, suite 201 cedar rapids, Iowa 52402 ph: 319- 447 -2222 June 14, 2012 Iowa City Municipal Airport ATTN: Michael Tharp 1801 S. Riverside Dr Iowa City, IA 52246 Kumi Morris Architectural Services Coordinator Engineering Division City Hall City of Iowa City, IA 52240 RE: Iowa City Municipal Airport Terminal Building Exterior Envelope Repairs Dear Michael and Kumi, 2570 holiday road coralville, iowa 55241 ph: 319- 338 -4939 Enclosed is the final pay application for the project for the retainage amount of $4,872.50, the TSB checklist and sealant warranty. The 20 year color finish warranty for the sheet metal will be coming shortly. We recommend payment of the retainage for TNT Tuekpointing & Building Restoration, LLC of Stockton, IA. Sincerely, Darrell L. Smith, PE, RRC Airport Commission Packet 6/21/12 Page 13 of 51 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319 - 356 -5045 RESOLUTION NO. RESOLUTION AWARDING CONTRACT AND AUTHORIZING THE CHAIRPERSON TO SIGN AND THE SECRETARY TO ATTEST A CONTRACT FOR THE CONSTRUCTION OF AIRFIELD ELECTRICAL IMPROVEMENTS WHEREAS, Gerard Electric, Inc. has submitted the lowest bid of $72,952.00 for construction of the above named project. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION, THAT: 1. The quotes for the above named projected are accepted. 2. The contract for the construction of the above named project is hereby awarded to Gerard Electric, Inc. subject to the conditions: a. That awardee secures adequate performance and payment bond, insurance certificates, and contract compliance program statements. 3. The Chairperson is hereby authorized to sign and the Secretary to attest the contract for construction of the above -named project, subject to the condition that awardee secure adequate performance and payment bond, insurance certificates, and contract compliance program statements upon instruction from legal counsel. Passed and approved this day of 12012 CHAIRPERSON ATTEST: SECRETARY It was moved by adopted, and upon roll call there were: Ayes and seconded by Nays Approved by City Attorney's Office Absent the Resolution be Assouline Gardinier Horan Mascari A=COM June 13, 2012 Mr. Jose Assouline Airport Commission Chair Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 RE: Request for Proposal Airfield Electrical Rehabilitate Iowa City Municipal Airport IDOT Project No. 911201OW100 Contract No. 13167 AECOM Project No. 60242326 Dear Mr. Assouline: AECOM Airport Commissio%FegftIR"?e1 Page 14 of 51 500 SW 7" Street 515.244.4803 fax Suite 301 Des Moines, Iowa 50309 www.aecom.com We have reviewed the proposals received on June 12, 2012, for the above - mentioned project. One minor inconsistency was found in the bid from Advanced Electrical Services, Inc. and was considered to be a mathematical error in their base bid. A copy of the bid tabulation is attached. Three (3) bids were received. Gerard Electric, Inc. of Iowa City, Iowa, submitted the low bid total for the base and alternate bid in the amount of $72,952.00. The low bid submitted was higher than the Engineer's Estimate by an amount of $3,452.00. We recommend award of a contract for Airfield Electrical Rehabilitate, IDOT Project No. 911201OW100 to Gerard Electric, Inc. of Iowa City, Iowa, in the amount of $72,952.00. If you have any questions or need additional information, please feel free to call our office at your convenience. Yours sincerely, David B. Hughes, P.E. Enclosures: As noted L: \work \pro1ect \60242326 IOW Airfield Electrical Rehab \200_ Correspondence\201- 202_ incoming- Outgoing \JA061312.ltr.docx v rn m IL O N N E E O U 0 O Q Q H o 0 o O O O � O aco m ti ti a Q lfl ci I� n In� 3 O F, o O O O i U w F o u - O U m N c > Z a � F oo oo oo 00 00 00 V) O oo oo oo oo oo oo U O� N ci N N m - 3 Q ~ o F O O o O O o O O o v U - N - 3 v o N O °rn o 0 z F oo oo oo 00 00 00 V) O m o o N o U J rn oo oc oc rn N n 0 i o u y a+ W U 6 N 3 F O O O O O O o o N N Q O m ti i m oo oa 0 N F C N O m Q R o lo O OO y ?j 9 c N Z 7 R N p� 73 W 0 Z C` E� C Z V o U Z d y F oo oo oo 00 00 00 w�° o w a W c a= O 00 Oo oo oo oo o •o o U m N � n O N O N � m F O R d 0 a .ti lfl ci tp Q O O W E Q 0 Q - 0 F O O O v � c O O m O O c U N �Il N Z 0 } O ti O ti O ti FF_ Q Z F � N W H 7 m co m m o ~ Co v c c c `v a v c `v a v `o v o v c - =o - -o io -o on m p a - a-° n f0 p 0 - U c o a iu E = to .� `m Z .0 `v O m E O - o F IL ° a onn N > ~ v fA % O p J 0 o D .. W Z ti N ti A=COM June 14, 2012 Mr. David Gerard Gerard Electric, Inc. 1807 Stevens Drive Iowa City, Iowa 52240 RE: Airfield Electrical Rehabilitate Iowa City Municipal Airport IDOT Project No. 911201OW100 Contract No. 13167 AECOM Project No. 60155584 Dear Mr. Gerard. AECOM Airport Commissiorr,{9gl .tl §JZ1 /1?e1 Page 16 of 51 500 SW 7`h Street 515.244.4803 fax Suite 301 Des Moines, Iowa 50309 www.aecom.com Three proposals were submitted for the above referenced project. Your company was the low proposal for the base bid plus the alternate bid. The Iowa City Airport Commission is planning to award this contract at their commission meeting on June 21, 2012. Attached are Five (5) copies of the Contract and Bond Forms for your execution. Please execute Four (4) copies with original signatures and return to our office for further processing. Provide the required insurance certificates in accordance with Paragraph 8 of the proposal documents. If you have any questions or require any additional information, please do not hesitate to contact our office. Yours sincerely, David B. Hughes, P.E. Enclosures: As noted cc: Mr. Jose Assouline, Iowa City Municipal Airport (w /enclosures) LAwork \project \60242326 IOW Airfield Electrical Rehab \200_ Correspondence\ 201- 202_Incoming- Outgoing \DG0615121tr docx Airport Commission Packet 6/21/12 Page 17 of 51 FORM OF AGREEMENT THIS AGREEMENT is made and entered into by and between the Iowa City Airport Commission, 1801 South Riverside Drive, Iowa City, Iowa 52246, and Gerard Electric, Inc., 1807 Stevens Drive, Iowa City, Iowa 52240 ( "Contractor "). Whereas the Airport Commission has prepared certain plans, specifications, proposal and bid documents dated the 31st day of May, 2012, for the Airport Electrical Rehabilitate Project (State Contract No. 13167) at the Iowa City Municipal Airport ( "Project'), and WITNESSETH: That the Contractor for and in consideration of Seventy Seven Thousand Nine Hundred Fifty -Two and No /100 Dollars ($77,952.00), based on the unit bid prices payable as set forth in the Specifications constituting a part of this Contract, hereby agrees to construct in accordance with the Plans, Specifications and Special Provisions therefore, and in the location designated on the Proposal Documents, the various items of work awarded said Contractor on the 21 st day of June, 2012, as follows, being numbered 1 through 2 on base bid and 1 through 1 on additive alternate bid as shown in schedule of prices bid in the attached Proposal which is a part of this Contract. Whereas, said plans, specifications, proposal and bid documents accurately and fully describe the terms and conditions upon which the Contractor is willing to perform the Project. NOW, THEREFORE, IT IS AGREED: 1. The Airport Commission hereby accepts the attached proposal and bid documents of the Contractor for the Project, and for the sums listed therein. 2. This Agreement consists of the following component parts which are incorporated herein by reference: a. Addenda Numbers: One; b. "Standard Specifications for Highway and Bridge Construction," Series of 2009, Iowa Department of Transportation, as amended; C. Plans; d. Specifications and Supplementary Conditions; e. Performance and Payment Bond; Iowa Department of Transportation AG -1 Iowa City Municipal Airport IDOT No. 911201OW100 Airport Electrical Rehabilitate Contract No. 13167 AECOM Project No. 60242326 Airport Commission Packet 6/21/12 Page 18 of 51 f. Restriction on Non - Resident Bidding on Non - Federal -Aid Projects; g. Contract Compliance Program (Anti- Discrimination Requirements); h. Proposal and Bid Documents; and i. This Instrument. The above components are deemed complementary and should be read together. In the event of a discrepancy or inconsistency, the more specific provision shall prevail. 3. The names of subcontractors approved by Airport Commission, together with quantities, unit prices, and extended dollar amounts, are as follows (or shown on an attachment): Dvorak Painting. Iowa Citv. Iowa - Pavement Marking $8.000.00 4. Payments are to be made to the Contractor in accordance with the Supplementary Conditions. DATED this day of Jose Commission Chair ATTEST: Approved By: City Attorney's Office Iowa Department of Transportation IDOT No. 911201OW100 Contract No. 13167 AECOM Project No. 60242326 AG -2 Title Contractor ATTEST: 2012- (Company Official) Iowa City Municipal Airport Airport Electrical Rehabilitate Airport Commission Packet 6/21/12 Page 19 of 51 Proposal for AIRPORT ELECTRICAL REHABILITATE IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA IDOT PROJECT NO.911201OW100 CONTRACT NO. 13167 Iowa City Airport Commission Iowa City, Iowa Commissioners: 1. The undersigned, having familiarized (himself) (themselves) (itself) with the existing conditions on the project area affecting the cost of the work, and with the documents included in the request for proposal, as prepared by AECOM, hereby proposes to furnish all supervision, technical personnel, labor, materials, machinery, tools, appurtenances, equipment, and services, including utility and transportation services required to construct and complete the Airport Dort Electrical Rehabilitate project at the Iowa City Municipal Airport, all in accordance with the proposal documents at the following rates and prices:. BASE BID Item Estimated Unit Total NNo, Description Unit Quantity Bid Price Bid Price 1 Provide and Install LED Lighting LS 1 $ 45, 135. 0 $ 45, 135. 00 2 Hangar Electrical Receptacles LS 1 Total Base Bid $ SIXTY EIGHT THOUSAND, ONE HUNDRED TWENTY (written) TWO DOLLARS Additive Alternate Bid $ 22,987. 0 $ 22,987.00 Dollars ($68,122.00 ), (figures) Item Estimated Unit Total No. Description Unit Quantity Bid Price Bid Price 1 LED Lighting for Building D Maintenance Bay LS 1 $4,830.0 $ 4.830.00 TOTAL ADDITIVE ALTERNATE BID $4,830.00 TOTAL BASE BID, PLUS ADDITIVE ALTERNATE BID $ 72,952.00 2. It is the Airport Commission's intention to evaluate bids reviewing both the Base Bid and the Additive Alternate Bid. The Commission has limited funds available and will award only what Page 5 Airport Electrical Rehabilitate -- ]DOT Contract 13167 Iowa City Municipal Airport AECOM Project No. 60242326 Airport Commission Packet 6/21/12 Page 20 of 51 funding allows. The Commission reserves the right to award the contract based on the Base Bid only or the combination of the Base Bid and Additive Alternate Bid. 3. The undersigned further agrees that if awarded the Project, he will commence the work within ten (10) calendar days after the receipt of a "Notice to Proceed" and that he will substantially complete all work according to the terms of the entire contract prior to October 31, 2012. An extension of time may be allowed when extra or additional work is ordered by the Engineer. 4. In submitting this bid, it is understood that the right to reject any and all bids has been reserved and that this bid may not be withdrawn for a period of thirty (30) days from the opening thereof. Respectfully submitted, GERARD ELECTRIC, INC. Bidder ZD Signature DAVID A. GERARD PRESIDENT Title 1807 STEVENS DRIVE Address IOWA CITY, IOWA 52240 (Include Zip Code) 319- 337 -6434 Telephone No Page 6 Airport Electrical Rehabilitate - IDOT Contract 13167 Iowa City Municipal Airport AECOM Project No. 60242326 Page i m � $ z e 2k k; SO // $§ 3 $0 k F-1 / � \ U \ / $ � f / k 7 2 ) § ■ R I « r § 2 � a f 2 t; kg § [ \ k / K § § a 2 I 2 $ k @ ! a 2 ® a t $ a 2 � ; a § § ! i . k f / $ � 2 # a � ! t � k ! t / � # a | � _ k 2 # 2 � � ■ 2 , , § �| t` ■k §� / �a %m Eli 6! §a &� �N %§ V Airport Commission Packet 6/21/12 as 2 ye 2 »( m� §� of M m222 { k q ! � !k !� a � (� k� ai Jk Airport Electri aiRehabilitate - IDOT Contract 276 %w City Municipal Airport AEO¥ Project No. §R B 2 \ $ $2 ek �k § � ° § ° k@ S9 B § K) § § § S � � a � � § 2 m222 { k q ! � !k !� a � (� k� ai Jk Airport Electri aiRehabilitate - IDOT Contract 276 %w City Municipal Airport AEO¥ Project No. Hughes, David (Des Moines) From: Sent: To: Cc: Subject: Tracking: Airport Commission Packet 6/21/12 Page 22 of 51 Hughes, David (Des Moines) Thursday, June 07, 2012 3:12 PM Hughes, David (Des Moines) 'Michael Tharp' Iowa City Municipal Airport - Airport Electrical Rehabilitate Recipient Hughes, David (Des Moines) 'Michael Tharp' 'matt @neumillerelectric.com' 'David A Gerard' 'Bkuennen @priceindustrial.com' 'aesjake @msn.com' Read Read: 6/7/2012 3:12 PM All make the following revisions to the proposal package that you have been provided. 1. Revise Specification Section 26 5100 paragraph 1.05 to read as follows: 1.05 EXTRA MATERIALS A. Furnish extra materials described below that match products installed, are packaged with protective covering for storage, and are identified with labels describing contents. 1. Drivers: Furnish at least 1 of each type." 2. Revise Fixture Mounting Note on Sheet CE -3 for Building Designations "A, B & C" to read "Remove existing fixture arm and mounting hardware. Provide surface outlet box and channel supports mounted horizontally to inside of building. Channel should be minimum of 18 inches long and attached with stainless steel hardware." Please confirm receipt of this email. David B. Hughes, P.E. Transportation D 515.323.7919 VolP 2147919 david. hug hesRaecom.com AECOM 500 SW 7th Street Suite 301 Des Moines, Iowa 50309 T 515.323.7910 F 515.244.4803 www.aecom.com Airport Commission Packet 6/21/12 Page 23 of 51 PERFORMANCE BOND KNOW ALL MEN BY THESE PRESENTS: That we, Gerard Electric, Inc., 1807 Stevens Drive, Iowa City, Iowa 52240, as PRINCIPAL, also referred to as CONTRACTOR, and , as SURETY, are held and firmly bound unto Iowa City Airport Commission, 1801 S. Riverside Drive, Iowa City, Iowa 52246 as OWNER, in the full sum of full sum of Seventy Seven Thousand Nine Hundred Fifty -Two and No /100 Dollars ($77,952.00),for the payment of which, well and truly to be made, we bind ourselves, our heirs, executors, administrators, successors and assigns, jointly and severally, by these presents. WHEREAS, the above -bound Principal has entered into a contract with the OWNER dated the 21St day of June 2012, for Airport Electrical Rehabilitate, IDOT Project No. 911201OW100, Contract No. 13167. NOW, THEREFORE, the conditions of this obligation are such that if the above -bound PRINCIPAL shall faithfully and fully comply with the terms and conditions of said contract, including, but not limited to, any obligations created by way of warranties and /or guarantees for workmanship and materials which warranty and /or guarantee may extend for a period of time beyond completion of said contract, and such alternations or additions as may be made therein or in the plans and specifications, and shall indemnify and save the OWNER harmless against any claims for using any form of material, process, composition or anything which is patented, and likewise indemnify and save the OWNER harmless against all claims for damages by reason or any default or negligence, want of skill or care on the part of said PRINCIPAL or Agents in and about the performance of said contract, and shall comply with all laws pertaining to said work, and shall comply with and perform any and all warranties and /or guarantees provided for in said contact, then this obligation shall be void; otherwise of full force and effect. PROVIDED, further than upon either the default of the PRINCIPAL, or the failure of the said PRINCIPAL to promptly and efficiently prosecute said Work, in any respect, in accordance with the Contract Documents, the above bound SU RETY shall either remedy the default of the PRINCIPAL or shall take charge of said Work and complete the Contract at his own expense, pursuant to its terms, receiving, however, any balance of the funds in the hands of said OWNER due under said contract. It shall be the duty of the SURETY to give an unequivocal notice in writing to the OWNER within ten (10) days after receipt of a declaration of default of the SURETY'S election either to remedy the default or defaults promptly or to perform the contract promptly, time being of the essence. In said notice of election, the SURETY shall indicate the date on which the remedy or performance will commence, and it shall be the duty of the SURETY to give prompt notice in writing to the OWNER immediately upon completion of (a) the remedy and /or correction of each default, (b) the remedy and /or correction of each item of condemned work, (c) the furnishings of each omitted item of work, and (d) the performance of the contract. The SURETY shall not asset solvency of its PRINCIPAL as justification for its failure to promptly remedy the default or defaults or perform the contract. In the event said PRINCIPAL shall fail or delay the prosecution and completion of said Work and said SURETY shall also fail to act promptly as hereinabove provided, then the OWNER shall cause ten (10) days notice of such failure to be given, both to said PRINCIPAL and SURETY, and at the expiration of said ten (10) days, if said PRINCIPAL or SURETY do not proceed promptly to execute said Contract, the OWNER shall have the authority to cause said Work to be done and when the same is completed and the cost thereof estimated, the said PRINCIPAL and SURETY shall and hereby agree to pay any excess in the cost of said Work above the agreed price to be paid under said Contract. Upon completion of said Contract pursuant to its terms, if any funds remain due on said Contract, the same shall be paid to said PRINCIPAL and SURETY. Iowa Department of Transportation BD -1 Iowa City Municipal Airport IDOT No. 911201OW100 Airport Electrical Rehabilitate Contract No. 13167 AECOM Project No. 60242326 Airport Commission Packet 6/21/12 Page 24 of 51 The said PRINCIPAL and SURETY further agree as part of this obligation to pay all such damages of any kind to person or property that may result from a failure in any respect to perform and complete said Contract including, but not limited to, all repair and replacement costs necessary to rectify construction error, architectural and engineering costs and fees, all (but not limited to) consultant fees, all testing and laboratory fees, and all legal fees and litigation costs incurred by the OWNER. The decision of the OWNER, upon any disputed question connected with the execution of said Contract, or any failure or delay in the prosecution of the Work by said PRINCIPAL or SURETY, shall be final and conclusive. The SURETY agrees that, other than as is provided in this bond, it may not demand of the OWNER the OWNER shall (a) perform any thing or act, (b) give any notice, (c) furnish any clerical assistance, (d) render any service, (3) furnish any papers or documents, or (f) take any other action of any nature or description which is not required of the OWNER to be done under the contract documents. IN WITNESS WHEREOF, the SURETY and PRINCIPAL have executed this instrument under their several seals this day of , 2012, the name and corporate seal of each corporate party being hereto affixed and these presents duly signed by its undersigned representative, pursuant to authority of its governing body. In the Presence of: =41►[4l1l_LRI Witness By: SURETY: Witness By: NOTE: (a) Where the Performance Bond is executed by an attorney -in -fact, there shall be attached to each copy of the Bond a certified copy of Power of Attorney properly executed and dated. (b) Each copy of the Bond shall be countersigned by an authorized agent of the bonding company licensed to do business in the State of Iowa. The title of the person countersigning the Bond shall appear after his or her signature. (c) The seal of the bonding company shall be attached to each copy of the bond. (d) The Contractor's signature on the bond shall correspond with the signature in the contract. (e) The bond shall be accompanied by a corporate resolution (which may be combined with the corporate resolution granting the signing officer authority to execute contracts) granting the corporate officer who executes the Bond the authority to do so. (f) Surety companies executing bonds must appear on the Treasury Department's most current list (Circular 570 as amended) and be authorized to transact business in the State of Iowa. Iowa Department of Transportation BD -2 Iowa City Municipal Airport IDOT No. 911201OW100 Airport Electrical Rehabilitate Contract No. 13167 AECOM Project No. 60242326 Airport Commission Packet 6/21/12 Page 25 of 51 PAYMENT BOND KNOW ALL MEN BY THESE PRESENTS: That we, Gerard Electric, Inc., 1807 Stevens Drive, Iowa City, Iowa 52240, as PRINCIPAL, also referred to as CONTRACTOR, and SURETY, are held and firmly bound unto Iowa City Airport Commission, 1801 S. Riverside Drive, Iowa City, Iowa 52246 as OWNER, in the full sum of Seventy Seven Thousand Nine Hundred Fifty -Two and No /100 Dollars ($77,952.00), for the use and protection of said OWNER and all subcontractors and all persons supplying labor, materials, machinery and equipment for the performance of the work provided for in the contract hereinafter referred to, for the payment of which, well and truly to be made, we bind ourselves, our heirs, executors, administrators, successors and assigns, jointly and severally, by these presents. WHEREAS, the above -bound Principal has entered into a contract with the OWNER dated the 215 day of June 2012, for Airport Electrical Rehabilitate, IDOT Project No. 911201OW100, Contract No. 13167. NOW, THEREFORE, the condition of this obligation is such that if the above -bound PRINCIPAL shall promptly make payment to all claimants as hereinafter defined, for all labor and materials supplied in the prosecution of the work provided for in said Contract, then this obligation shall be void; otherwise, it shall remain in full force and effect, subject, however, to the following conditions: The said SURETY to this bond, for value received, hereby stipulates and agrees that no change or changes, extension of time or extensions of time, alteration of alterations or addition or additions to the terms of the contract or to the work to be performed thereunder, or the specifications or drawings accompanying same shall in any wise affect its obligation on this bond, and it does hereby waive notice of any such change or changes, extension of time or extensions of time, alteration or alterations or addition or additions to the terms of the contract or to the work or to the specifications or drawings. 2. A claimant is defined as any subcontractor and any person supplying labor, materials, machinery, or equipment in the prosecution of the work provided for in said contract. Signed and sealed this day of 2012- IN THE PRESENCE OF: PRINCIPAL: Witness By: SURETY: Witness By: NOTE: (a) Where the Payment Bond is executed by an attorney -in -fact, there shall be attached to each copy of the Bond a certified copy of Power of Attorney properly executed and dated. (b) Each copy of the Bond shall be countersigned by an authorized agent of the bonding company licensed to do business in the State of Iowa. The title of the person countersigning the Bond shall appear after his or her signature. Iowa Department of Transportation BD -3 Iowa City Municipal Airport IDOT No. 911201OW100 Airport Electrical Rehabilitate Contract No. 13167 AECOM Project No. 60242326 Airport Commission Packet 6/21/12 Page 26 of 51 (c) The seal of the bonding company shall be attached to each copy of the bond. (d) The Contractor's signature on the bond shall correspond with the signature in the contract. (e) The bond shall be accompanied by a corporate resolution (which may be combined with the corporate resolution granting the signing officer authority to execute contracts) granting the corporate officer who executes the Bond the authority to do so. (f) Surety companies executing bonds must appear on the Treasury Department's most current list (Circular 570 as amended) and be authorized to transact business in the State of Iowa. Iowa Department of Transportation BD -4 Iowa City Municipal Airport IDOT No. 911201OW100 Airport Electrical Rehabilitate Contract No. 13167 AECOM Project No. 60242326 Airport Commission Packet 6/21/12 Page 27 of 51 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 350 5045 RESOLUTION NO. RESOLUTION APPROVING PLANS, SPECIFICATIONS, FORM OF CONTRACT, AND ESTIMATE ON COST FOR " RUNWAY 7/25 PARALLEL TAXIWAY PAVING AND LIGHTING " CONSTRUCTION PROJECT AT THE IOWA CITY MUNICIPAL AIRPORT WHEREAS, notice of public hearing on the plans specifications, form of contract and estimate of cost for the above -named project was published as required by law, and the hearing thereon held. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION THAT: 1. The plans, specifications, form of contract and estimate of cost for the above -named project are hereby approved 2. The amount of bid security to accompany each bid for the construction of the above -named project shall be in the amount of 10% (ten percent) of bid payable to the Iowa City Airport Commission 3. The City Clerk is hereby authorized and directed to publish notice for the receipt of bids for the construction of the above -named project in a newspaper published at least once weekly and having a general circulation in the city. 4. Bids for the above -named project are to be received by the City of Iowa City, Iowa at the Office of the City Clerk, at the City Hall, before 2:00pm on the 10"' day of July, 2012, or at a later date and /or time as determined by the Commission Chairperson or their designee, and thereupon referred to the Airport Commission, for action upon said bids at its next meeting, to be held at the Iowa City Airport Terminal Building, 1801 S. Riverside Drive, Iowa City, Iowa at 6:00pm on the 19 day of July 2012, or at a later date and /or time as determined by the Commission Chairperson or designee, with notice of said later date and /or time to be published as required by law, or if said meeting is cancelled, at the next meeting of the Airport Commission thereafter as posted by the City Clerk. Passed and approved this CHAIRPERSON ATTEST: SECRETARY day of It was moved by and seconded by adopted, and upon roll call there were: 2012. Approved By: City Attorney's Office Ayes Nays Absent the Resolution be Assouline Gardinier Horan Mascari UVQt 06.14.12 13:09:00 Method: 3 Airport Commission Packet 6/21/12 Page 28 of 51 Page: l Iowa City General Ledger System FY 2012 Revenue Reporting For the period 05�01.12 to 05.11.12 Estimated YTD Period Account Revenue Revenue Revenue Remainder � ------`-~`--------`--------`--~^~----- - ------------ ------------ ---~~-~^- ------ -`- 761,10 Airport 0T8QD NISC REVENUE 369100 8eiNb UI Exoeooen 1155.52 -3155,52 Total OTHER NISC 88Y3QUD INTEREST DDVQ0UO8 38I100 Interest on Investments Total INTEREST DEVD0UDG R1N TS 382100 Land Rental 382200 Building/ROOM Rental Total RENTS ROYALTIES 6 C0@HI8SI00G 04100 Telephone CO00isGiVD 384200 Vending 0aCbio8 Comm 384980 Other Commissions Total ROYALTIES 6 COMMISSIONS 38LQ OF ASSETS 392100 Sale Of Land 392300 Sale of Equipment Total G&6E OF ASSETS TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES ]9]130 General Levy Total TD&08FDD8 FROM GOVERNMENTAL ACTIVITIES Total TRANSFERS Total Airport *** GRAND TOTAL e* ------------ ------------ ------------ 3155.53 ------------ -3155.52 ------ 600.00 ------ 1026]5 114.48 '426.35 171.06 600.00 ------ ------ 1026.35 114.48 ------ -426.35 --- 171.06 41968.80 43000.07 l000.00 '1032.07 102.46 231842.00 218138.50 27056.50 8M.50 94.11 ------------ ------------ 273810.00 ------------ 261188.57 ------------ 28056.50 12621.43 ------ 95.39 030 108.00 14.40 '25.08 130�12 20000.08 22544.50 1103.50 '2544.58 112.72 ------ 2800.00 ------ ------ 22652.50 1197.90 ------ -250.58 --- 112.79 400000.00 '400000.00 747.45 '747.46 ------------ ------------ ------------ 400747.45 ------------ -400747.45 ------ 100000.00 91666.63 8333.33 8]33.]7 91.67 ------ 108000.80 ------ ----^-~- 91666.63 033.33 ------ 8333.37 --- 91.67 ------------ ------------ 100000.00 ------------ 91666.63 ------------ 033.33 8333.37 ------ 91.67 ------ 394493.00 ------ ------ 780437.02 3770.21 ------ '305944.0 --- 197.0 ------ 394493.00 ============================ ------ ------ 780437.02 3770L21 ------ '05944.02 --- 197.83 DXDD/ 06.14.I2 I3;07:31 Method; l Airport Commission Packet 6/21/12 Page 29 of 51 Iowa City General Ledger System FY 2012 Qxueoa8 Reporting For the VBIiO0 05.0I.12 LV 05.31.12 Page; 1 YTD Period &CcnVUt Appropriated DxomuUi1or9e Expenditures Qo:umbcaouo Balance 0 Used '-.-'-__- _-'__- ___' -_' -'_ __' 7600 Airport ------------ ------------ ------------ ------------ ------------ ---' AIRPORT 560100 Airport OoeIat|OoG SALARIES & R&8ED RD8��A8 SALARIES & WAGES 421000 Perm Pull Time 1.00 1.00 41.2000 Perm Part Time 36370.00 32132.27 062.27 4237.73 8835 413000 Temporary Employees 520.00 381.50 138.50 73.37 Total REGULAR SALARIES & M&&Q8 -'----' 36891.00 '-----' 32513.77 ---'''-'- ---'--' '----'-- 3062.27 4]77.2] ---- 88.13 OTHER WAGES 4I4500 Longevity Day 244,00 243.75 .25 9938 Total OTHER N&QDX ________ 244.00 _______ 243.75 _______ ________ _______ .25 ____ 99.90 Total SALARIES & WAGES ------------ 37135.00 ------------ 32757.52 ------------ ------------ ------------ 3062.27 077.48 ------ 88.21 EMPLOYEE BENEFITS GROUP INSURANCE 421100 Health Insurance 3598.00 3628.03 329.02 -30.02 100.0 42100 Dental Insurance 232.00 212.52 10.32 19,48 91.60 421300 Life Insurance 79.00 82.82 7.74 '3.82 10434 01400 Disability IDSurRDC8 176.00 151.78 14.36 24.22 86.24 Total GROUP INSURANCE ______ 4085.00 ________ 4875.l4 _____ ____ _ ______ ________ 371.24 9.86 ____ 99.76 QO2I&I SECURITY CONTRIBUTIONS 02100 FICA 2841.00 2407.94 225.36 48.06 84.76 Total 8VCI&6 SECURITY CONTRIBUTIONS ------------ 284I.00 ------------ 2487.94 ------------ ------------ 225.36 ______ 433.06 __ 84.76 837I8DND0T CONTRIBUTIONS 423100 IB88G 2997.00 2643.57 247.12 353.43 88.21 Total DDTI8DND0T CONTRIBUTIONS _________ 2997.00 _______ 2643.67 ______ ______________ 247.12 353.43 ___ 88.21 Total 0BIL8Y8D BENEFITS ------ 9923.00 ------ 9126.65 ------ ------ 843.72 ------ 796.35 --- 91.97 QXPQ; 06.14.12 8:07:31 Method: I Airport Commission Packet 6/21/12 Page 30 of 51 D8q8: 2 Iowa City General Ledger System FY 2012 Expense Reporting FMr the period 05.01.12 to 05.31.12 YTD Period &CCOUDt Appropriated Expenditures Expenditures QDCumbr2OC8 Balance � Used -'''------- -' -- ------'-------'-^------- ------------ ------------ --'---' ------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560180 Airport Operations (CONTINUED) PROFESSIONAL 6 TECHNICAL SERVICES OFFICI&L/&DMI08TD&TIYQ 88DVICQ8 431020 Court Costs & Services 78.00 78.00 Total 0DFICIAL/&DMD0T8&TIVQ SERVICES p8UDQ8SIO0&L SERVICES 432020 &000ul Audit 432050 Appraisal Services 432D80 Other Professional Services Total BD0FED8I80AL SDDYICDG DATA AND COMMUNICATION GDDVIC8B 435056 Delivery Services 435057 Couriers 435060 Legal Publications Total DATA AND COMMUNICATION SERVICES TRAINING & EDUCATION 436030 Transportation 436050 Registration 436060 Lodging 436070 NiscellaueVoG Travel Qxpau8p 436080 Meals Total TRAINING & EDUCATION INSURANCE 437010 Comp Liability Insurance 437020 Fire 6 Casualty insurance 437030 Worker's CO0D IDGu[8DU8 437041 Bonding & Other Insurance 437200 Loss Reserve Payment Total I0SO8&0CQ ------ ------ ------ ------ ------ --- 78.00 78.00 1202.00 347.24 854.76 28.89 400.00 '400.00 56.63 -56.63 ------------ ------------ 1202.00 ------------ 803.87 ------------ ------------ ]98.1] ___ 66.88 52.00 13.70 38.0 26.35 8530 85.00 98.00 39.22 12.72 58.78 48.02 ------------ ------------ 235.00 ------------ 52.93 ------------ 12.72 ------------ 182.00 ------ 22.52 700.00 209]0 177.60 400.30 42.81 400.00 350.00 125.00 50.00 87.50 00.00 342.0 1l0.88 157.50 68,50 30.00 '30.0 200.00 0.00 ]].00 117,00 41.50 ------ ------ 1800.00 ------ 1105.20 ------ 446.48 ------ 694.88 --- 61.40 4148.00 3950.OU 198.00 95.23 12745.00 7153.00 5592.00 56.12 36.U0 45.00 -9.00 125.00 901.00 875.00 26.00 97.11 5150.00 5158.00 100.00 ------------ ------------ 22980.08 ------------ 17173.00 ------------ ------------ 5807.00 ------ 74.73 QXBQ: 06.14.12 1]:07:]1 Method; 1 Airport Commission Packet 6/21/12 Page 31 of 51 Iowa City General Ledger System FY 2012 Expense Reporting For the period 05.01.12 to 05.31.13 Page: ] Total UTILITY SERVICES Total VD0FESGIO0&6 & TECHNICAL SERVICES DDDAI8 6 8&I0T80&0CD BUILDING 8DD&I8 & MAINTENANCE SERVICES 442010 Other Building Repair & MaiDt880 442020 Structure Repair 6 Maintenance Q 442030 Heating Equipment Repair & Maint 442040 Cooling Equipment D8pDiz & Maiot 442060 Electrical & Plumbing Repair 6 M 442070 Bldg Pest Control 8GIricR8 Total BUILDING BDP&ID & MAINTENANCE SERVICE EQUIPMENT BEp&I8 & MAINTENANCE 88DVI{E8 443050 Radio Equipment Repair 6 0aiuteo 443060 Telecom Equipment Repair G 0aiut 441.080 Other Equipment Repair & Naiuten Total EQUIPMENT REPAIR & M&I0TQ0&0CQ 8DBVIC TECHNICAL 8QDVIC88 445030 Nursery Service-Lana and Plant C 445080 8uOw and Ice Removal ------ ------ 31829.00 ------ 29777.38 YTD Period --- 93.55 ______ ______ 58124.80 8CCVVDt Appropriated Expenditures Expenditures 8ncnmUza0C8 88l8DC8 I Used ------------------------------------------------------- 7600 Airport (CONTINUED) ------------ ------------ ------------ ------------ ------------ 2875.93 ------ &I8POR� (CONTINUED) 57.32 2500.00 915.00 585.00 560180 Airport Operations (CONTINUED) 1000.00 813.32 186.60 81.33 PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) 3848.05 39.92 -2848.05 384.81 419.00 UTILITY 8D8VIC8D 33.95 45.55 89.13 ------ ------ 21004.00 ------ 18217.99 438010 Dtuzmnatez Utility Charges 7I04.00 8680.21 789.1I '186.21 122.19 438830 Electricity 12903.00 13831.28 1026.62 '928.28 107.19 438870 Heating BVpl/R88 6489.00 4090.59 }9.]5 2398.41 83.04 438080 Sewer Utility Cb8z9u 165430 1022.93 105.42 631.87 61.85 438090 Water Utility Cbaz98 1454.00 100].]8 98.18 450.62 693l 438180 Refuse Collection Charges 125},0V I101.00 97.00 152.Q0 07.D7 438110 Local Phone Service 907.00 907.00 438120 Long Distance Service 65.00 47.99 3.96 17.01 73.83 Total UTILITY SERVICES Total VD0FESGIO0&6 & TECHNICAL SERVICES DDDAI8 6 8&I0T80&0CD BUILDING 8DD&I8 & MAINTENANCE SERVICES 442010 Other Building Repair & MaiDt880 442020 Structure Repair 6 Maintenance Q 442030 Heating Equipment Repair & Maint 442040 Cooling Equipment D8pDiz & Maiot 442060 Electrical & Plumbing Repair 6 M 442070 Bldg Pest Control 8GIricR8 Total BUILDING BDP&ID & MAINTENANCE SERVICE EQUIPMENT BEp&I8 & MAINTENANCE 88DVI{E8 443050 Radio Equipment Repair 6 0aiuteo 443060 Telecom Equipment Repair G 0aiut 441.080 Other Equipment Repair & Naiuten Total EQUIPMENT REPAIR & M&I0TQ0&0CQ 8DBVIC TECHNICAL 8QDVIC88 445030 Nursery Service-Lana and Plant C 445080 8uOw and Ice Removal ------ ------ 31829.00 ------ 29777.38 ------ 2159.64 ------ 2051.62 --- 93.55 ______ ______ 58124.80 ______ 48912.37 _______ 2618.84 ______ 9211.63 ___ 84.15 13085,00 9392.24 799.00 302,76 77.73 5800.08 2875.93 2124.07 57.32 2500.00 915.00 585.00 61.00 1000.00 813.32 186.60 81.33 1000.00 3848.05 39.92 -2848.05 384.81 419.00 37}.45 33.95 45.55 89.13 ------ ------ 21004.00 ------ 18217.99 ------ 872.87 ------ 2786.01 --- 86.74 20.00 1127.42 -844.42 398.38 454.00 454.00 5898.00 2196.0 3781.58 37.24 ------ ------ 6635.00 ------ 3323.84 ------ ------ 3311.16 --- 50.10 37080.00 31500.00 4500.80 18540.00 18000.00 5680.00 84.95 540.00 97.09 EXPE; 06.14,12 13;07:31 Method: I Airport Commission Packet 6/21/12 Page 32 of 51 Page: 4 lowa City General Ledger System FY 2012 Expense Reporting For the period 05,01,12 to 05.31.12 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance 11 Used ------------------------------------------------------- ------------ ------------ ------------ ------------ ------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) TECHNICAL SERVICES (CONTINUED) 445110 Testing Services 445140 Outside Printing Total TECHNICAL SERVICES INTRA-DEPARTMENT SERVICES 446010 Administrative Services 446100 City Attorney Chargeback 446130 ITS-PC/Peripheral Support Charge 446140 ITS-Computer Replacement Chargeb 446150 ITS-Application Development Fee 446160 ITS-Network/Internet Chargeback 446200 Photocopying Chargeback 446220 Phone Service Chargeback 446300 Phone Equipment/Line Chargeback 446320 Mail Chargeback 446350 City Vehicle Replacement Chargeb 446360 City Vehicle Rental Chargeback 446370 Fuel Chargeback 446380 Vehicle Repair & maintenance Cha 446390 Auto Body Repair Chargeback Total INTRA-DEPARTMENT SERVICES MISCELLANEOUS SERVICES & CHARGES 449055 Permitting Fees 449060 Dues & Memberships 449120 Equipment Rental 449350 Meals (non-travel) 449360 Interest Expense Total MISCELLANEOUS SERVICES & CHARGES 850.00 977.60 382.60 127.00 -127.60 115.01 127,00 ------------ ------------ 56597.00 ------------ 50477,60 ------------ 4882.60 ------------ 6119.40 - - - - -- 89.19 45.00 45.00 -45.00 5233.00 4674.35 558.65 89.32 400.00 1082.00 -682,00 270.50 517.00 848.94 101.42 -331.94 164.21 1752.52 -1752.52 360.00 510,00 60.00 -150.00 141.67 231.00 163,86 28,86 607.14 70.,14 692,00 938.25 82.29 -246.25 135.59 1020.00 1017.50 92,50 2.50 99,75 529.00 256.22 8.71 272.79 48.43 14397.00 15024.92 1363.72 -627.92 134.36 500.00 308.21 191,79 61.64 3669.00 3119.70 431.98 549.30 85.03 15132,00 15756.19 1134.95 -624.19 104.12 224.00 224.00 ------------ ------------ 42904.00 ------------ 45497.66 ------------ 3349.43 ------------ -2593.66 - - - - -- 106,05 65.00 65,00 100,00 675,00 1175.00 -500.00 174.07 754.00 446.00 308.00 59.15 38,46 -38.46 60060.00 53054.10 4823.10 7005.90 88,34 - ------------ ------------ 61554.00 ------------ 54778.56 ------------ 4823.10 ------------ 6775.44 - - - -- 88.99 DXB8: 06.I4.l2 13/07:32 Method; 1 Airport Commission Packet 6/21/12 Page 33 of 51 Page; 5 Iowa City General Ledger System 8Y 2012 Expense Reporting For the period 05.01.12 W 05.3I.12 YTD Period &UCVUnt ADDy0VIiULed Expenditures Expenditures DDCUmb[8VV8 Balance �, Used ---'~-''--'--''------------------- ------- ------------ - ---'~~- --'-'--- ------ --- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR 6 MAINTENANCE (CONTINUED) MISCELLANEOUS SERVICES & CHARGES (CONTINUED Total REPAIR & MAINTENANCE OTHER QK8C8&SDD SERVICES (CHANGE TO OFFICE GU GENERAL SUPPLIES 452010 Office Supplies 452030 Minor Office Equipment/Furniture Total GENERAL SUPPLIES BOOKS & PERIODICALS 454010 Reference Materials 6 8Vnk8 454020 Subscriptions Total BOOKS & PERIODICALS COMPUTER & PRINTING SUPPLIES 4551.30 MiBC Computer 8uzdw8z8 Total COMPUTER & PRINTING SUPPLIES Total OTHER PD8C8&XDD SERVICES (C8&8gQ TO OFF UDD0TI0G SUPPLIES AGRICULTURE SUPPLIES 461030 Dl8oto & Trees 461040 Other Agriculture Cb8mfC8l8 Total &8DICUL%D8Q SUPPLIES REPAIR 6 MAINTENANCE SUPPLIES 466030 Paint Supplies 466040 QlumbiDg 88pplieO 466050 Electrical Supplies 466060 Other COD8t[uCtiVD Supplies 466070 Other Maintenance Supplies ------------ ------------ 188694.80 ------------ 172295.65 ------------ 13928.00 ------------ 16398.35 ------ 91.31 577.00 613.84 41.97 '36.84 106.38 279.97 -279.97 ------------ ------------ 577.00 ------------ 893.81 ------------ 41.97 ------------ -316.81 ------ 154.91 l6.00 1-6.00 2099.00 605.95 59.95 1403.05 28.87 ------------ ------------ 2115.00 ------------ 605.95 ------------ 59.95 ------------ 109.05 ------ 28.65 200.00 2154.91 445.09 82.88 ------------ ------------ 2600.80 ------------ 2154.91 ------------ ------------ 445.09 ------ 82.88 ------------ ------------ 5292.00 ------------ 3654.67 ------- 101.92 ---- ------------ lQ?.]] ------ 0.06 3000.00 008.00 1500.00 48.14 48.14 1451.86 3.31 ------ ------ 400.00 ------ 48.14 ------ 48.14 ------- 4451.86 --- 1.07 23.0O 23.00 20.88 '20.88 1066.00 960.81 103.04 105.19 9U.l3 119.00 119.00 288.00 737.20 -537.28 368.60 EXPE; 06,14.12 13:07:32 Method: I Airport Commission Packet 6/21/12 Page 34 of 51 Iowa City General Ledger System FY 2012 Expense Reporting For the period 05.01.12 to 05.31.12 Page; 6 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balanc e S , *, Used ------------------------------------------------------- 7600 Airport (CONTINUED) ------------ ------------ ------------ ------------ ------------ - - - - -- AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) REPAIR & MAINTENANCE SUPPLIES (CONTINUED) Total REPAIR & MAINTENANCE SUPPLIES ------------ 1408.00 ------------ 1718.89 ------------ ------------ ------------ 102.04 -310.89 - - - - -- 122.08 EQUIPMENT REPAIR & MAINTENANCE SUPPLIES 467020 Equipment Repair & Maintenance S 64.19 64.19 -64,19 467160 Other Vehicle Repair & Maintenan 58.02 -58.02 Total EQUIPMENT REPAIR & MAINTENANCE SUPPLI ------------ ­ * --------- 122,21 -----­-­- ------------ ------------ 64.19 -122.21 ------ SURFACING MATERIALS 468030 Asphalt 103.00 103.00 468050 Sand 26.55 -26.55 Total SURFACING MATERIALS ------------ 103.00 ------------ 26.55 ------------ ------------ ------------ 76.45 - - - - -- 25,78 OTHER SUPPLIES & EQUIPMENT 469040 Traffic Control Improvement Supp 138.00 138.00 469190 Minor Equipment 324.00 -324M 469200 Tools 76.00 581.17 -505.17 764.70 469260 Fire Ext & Refills 466.00 655.55 -189.55 140.68 469320 Miscellaneous Supplies 552.00 260.22 ------------ ------------ 291.78 47,14 - - - - -- Total OTHER SUPPLIES & EQUIPMENT ------------ 1232.00 ------------ 1820.94 ------------ -588.94 147.80 - - - - -- Total OPERATING SUPPLIES ------------ 7243.00 ------------ 3736.73 ------------ ------------ ------------ 214.37 3506.27 51.59 IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements 20000.00 17100.00 2900.00 85.50 473020 Non-Contracted Improvements 9000.00 2822.00 ------------ ------------ 6178.00 31,36 - - - - -- Total IMPROVEMENTS OTHER THAN BUILDING ------------ 29000.00 ------------ 19922.00 ------------ 9078.00 68.70 QXPE; 06.14]2 13:07:32 Method; l Airport Commission Packet 6/21/12 Page 35 of 51 Page: 7 Iowa City General Ledger System K7 20I2 Expense DeDOzL1ng For the period 0.01.12 to 05,31�12 YID Period &CCVuot Appropriated Kzyeu0iLur8S Expenditures Encumbrance Balance I Used ''--'----'----- ---' -'--'---'''--- ------------ --'---- ------- --'---- --- -------- -- 76O0 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport 0DGC@tiO8o (CONTINUED) EQUIPMENT & yOD0ITUD8 VEHICULAR EQUIPMENT (88O&T8R THAN X1,000) 474240 Tractors 4990.00 '4990.00 Total VEHICULAR DQOIDNQ0T (GREATER THAN $l, FURNITURE 6 FIXTURES (Q8Q&TOD THAN $1.000) 475010 Furniture & Office Equipment Total FOD0ITDKD & FIXTURES (8DD&TQB THAN $l IT HARDWARE/SOFTWARE (GREATER THAN $1,000) 476070 PC 88Idn8Ie Total IT SOFTWARE (GREATER THAN $l Total EQUIPMENT & FURNITURE OTHER FINANCIAL U8QG 490150 Operating Subsidy 498190 IoterfuDd Loan Total OTHER FINANCIAL USES Total Airport Operations Total Airport ------ ------ ------ 4990.00 ------ ------ '4990.00 --- ]898.9] ]898.9} '3898.93 ------ ----^-- ------ 3890.93 -----^- ]898.9] ------' '098.93 --- 5025.81 -5025.81 ------ ------ ------ 5025.81 ------ ------ '502531 ------------ --- --- ------------ ------------ ------------ 13914.74 ------------ 3898.0 '13314.74 11517.00 10557.25 959.75 959.75 91.67 85236.00 40229.02 3656.82 5010.08 08.0 ------ 56753.00 ------ ------ 50782.27 ------ 4616.57 ------ 5970.73 --- 89.48 ------------ ------------ 392164,00 _ 355102.60 --------- ------------ 29284.62 ------------ 37061.40 ------ 90.55 --- ------ 392164.00 ------ ------ 355102.60 ------ 29284.62 ------ 37061.40 90.55 EXPE; 06,14,12 13:07.32 Method: 1 Airport Commission Packet 6/21/12 Page 36 of 51 Page: 8 Iowa City General Ledger System FY 2012 Expense Reporting For the period 05,01,12 to 05,31,12 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance '-. Usk ------------------------------------------------------- ------------ ------------ -- --- - - - - -- ------------ ------ - - - - -- - - - - -- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) ------------ ------------ ------------ ------------ ------------ - - - - -- GRAND TOTAL 392164,00 355102.60 29284,62 37061,40 90.55 Airport Commission Packet 6/21/12 Page 37 of 51 TRID; 00.14.12 13d2:27 Method: 4 Page: 1 Iowa City General Ledger System ExD80btUIe8 Detail FY 2012 Detail Reporting For the p9ziV4 05.01.12 to 05.31.12 Trans Date Trans Type Deoort# Source Description Debit Credit 7600 Airport 560100 Airport Operations 412008 Perm Part Time 05.04.12 0l8 Sys 12050201000 05,18.12 Old Sys 120516010014 Total Perm Part Time 421100 Health Insurance 05.08.12 Journal TVLaI Health Insurance 421200 Dental IuGur8DC8 05.08.12 Journal 506357 C PAYROLL 04 1681.67 506505�CIC PAYROLL 88C8Q\DAYDOlL 18 1380.60 ------------ ]062.27 120523160841 010096 MAY 88&LT8 I00UDA@CQ\CIC RQ&L7H INS 329.82 ____________ 329.8% 120523160841 018095 MAY DENTAL I08UD&0CQ\CIC DO07&L INS 19.32 ------------ — Total Dental Insurance 19.32 ------ ----- 421300 Life Insurance 05.23.12 New Vouch 12052400153 06789334 Cbeck:709003\NbDI30N NATIONAL LIFE 7otal Life Insurance 421400 Disability Insurance 05,23.12 New Vouch 120524030153 06789422 Cheek:709006\MADISON NATIONAL LIFE ?Ot:l Disabil ity IxSuzDnCe 422100 FICA 05.04.12 Old 8vG 1.20502010010 05.13.12 Old 8y: 1205I6010014 Total FICA 423100 TD0DG 06.04.12 Old Sys 120502010010 05.18.12 Old Sys 120516018814 Total. IgBDG 5040599 CONTRIBUTION 5180699\FIC&\CITY CONTRIBUTION 5040599\IBDD8 CITY CONTRIBUTION 5180599\IPERS\CITY CONTRIBUTION ?.?4 ------------ ?.74 14.]6 ------------ 14,36 l24.2D 101.16 ------ -----'^ 22S.]6 I]5.7l lll. 41 ____________ 247.13 Airport Commission Packet 6/21/12 Page 38 of 51 YRID; 86.14.12 13:12:27 Method: 4 D3oe: 2 Iowa City General Ledger System QupeDUiiUrCs Detail F7 2012 Detail Reporting For the p8ZiO8 05.01.22 to 05.31.12 Trans Date trans Type 8eDnrt# Source Description Debit Credit ------ ----- ------ ---- -----------------' ------ ------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 435060 Legal 9ohliC8LiCmG 05.16.12 New Vouch 12051700352 06788726 Che:k:708739\IOMA CITY PRESS CITI%D 12.72 Total Legal Publications 43600 Transportation 05.16.12 New Vouch Total Transportation 436050 Registration 05.22.13 D-Card Total Registration 436060 Lodging 05.22.12 P-Card Total Lodging 436080 Meals 05,16.12 ____________ 12.7% 12031700252 06788593 CbeCk:788865\TD&80, MIC8&QL\TD&VQL 177.60 ------------ 177.60 120605153929 18800579 8B 'IOWA SOYBEAN ASSOC T8&D 125.00 ------------ l%5.00 120605153929 18808580 88QK&T0N'D8S M0I8QG\MIC8AE6 TH&8P 110.88 ------------ 110.88 New Vouch 12051700252 06788593 CheCk:708865\7B&BQ, MICU&DLYTR&VDL 33.00 Total Meals 33.00 08010 OtOrmwatar Utility Charges 05.16.12 Journal 120523160841 0I0094 057'095'03\3TORNKTK\5.16I2 Dill Da 789.11 Total Xtormwatez Utility Charges ____________ 789.11 43800 Electricity 05.22.12 New Vouch 12052]0]0016 00900174 Checb:910008 00 ENERG 180 66.86 05.22.12 New Vouch 12052300016 00900220 Check:910008\MIDAMDDIC&0 E0DDQY\180 04.40 05.22.12 New Vouch 120523030016 00980221 �eCk;y10008 ID&HDDIC&0 � DNODGY\18V 45.30 05.22.12 New Vouch 12052300016 00900223 CbeVk:910008\MID&MDOIC&0 DNDDGY\180 220.06 Total Electricity ____________ 1026.62 Airport Commission Packet 6/21/12 Page 39 of 51 TRID- 06.14'12 13;12:27 Method: 4 Page: 3 Iowa City General Ledger System 8xpeDditUre5 Detail FY 2012 Detail Reporting For the period 05.01.12 to 05-2I.1-2 Trans Date Trans Type ReVuct# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations 438870 Heating Fuel 05.22.12 05.22.12 05.22,12 (CONTINUED) 'Gas New Vouch 12052030016 00900I99 CbeCk:918008 ID&MD8ICA0 ENERGY \180 15.50 New Vouch 120523030016 00900217 Cbe:k:910008\MIU&NDDICA0 DNODAY\180 10.0U New ?Vmcb 12052010016 00900222 Cbeeb:9I0008\HIDAMDRICAN ENDDAY\180 13.85 Total Heating Fuel/Gas 438080 Sewer Olilbn Charge 05.16.12 Journal 05.16.12 Journal 05.16.12 Journal 05.16.12 Journal Total Sewer Utility Charge 40090 Water Utility Charge 05.16.12 Journal 05.16.12 Journal 05.16.12 Journal 05.16.12 Journal 05.16.12 Journal I2052316084I 010094 857-120-00\SERQD\5.16.12 Dill Date I20523I0841 010094 057-118'03\8ONDD 5.l6.l2 Dill Date I20523I60841 810094 057-117-00\GEWE 5.l6.l% Bill Date 120523160841 010094 057-I15-00\SEWB8\5.16.12 Bill Date 12052316084I 010094 057-130-88 \5.16.12 Rill Date 120523160841 010004 057'118'03\WATDD 5.16.1J Dill Date 120523160841 010084 057'l1?-0O 5.16.12 Dill Date 120523160841 818094 857'115'00 R\5.16.12 Bill Date 120523160841 O10094 057-095'03\WATDB\5.16.12 Bill Data Total Water Utility 438100 DeIooe Collection Charges 05.23.12 080 Vouch I205240]015] 08789120 Cbecb:708897\k8C DISPOSAL SYSTEMS I 05.23.12 New Vouch 120528030153 067891]] Cbecb:708897W2 DISPOSAL SYSTEMS I Total Refuse Collection Charges 438120 LOoo UiGt8808 Service 05.0I.12 Ph Lon D8t 120601115800 80005019 MAY LONG DICT CHGBD Total 6muo Distance D8[viC8 442010 Other Building Repair 6 @aiDt8D0Dc9 GVr 05.08.12 New VDUCb 12058900019 06788132 ChgCb:708511\T & D ROOFING 6 GDQDT 05.08,13 New Vouch 120509030019 06788152 Cb8Ck,708466\JDT AIR INC I00&Y J8 ------------ ]9J5 %5.11 %U.l2 16.13 44.06 ------------ 105.42 19.12 15.38 12.39 43.]8 ?.91 ____________ 98.18 69.00 0.00 ____________ 97.00 3.96 _---------- ---- ____ 3.96 199.00 600.0O Airport Commission Packet 6/21/12 Page 40 of 51 7RID; VK . l4. D 13;12:27 MeCb08 � A Page: 4 Iowa City General Ledger System QzpouUztnr8S Detail FY 2012 Detail Reporting For the period 06.01.12 L0 05.31.12 Trans Date Trans Type 800ur # 8Qucoe Description Debit Credit ---- —' ----- ------ ---- ------------- ----- — ----- ------ 7600 Airport (CONTINUED) 568100 Airport Uoe13tiVD8 (CONTINUED) 442010 Other Building Repair & Maintenance 88/ Total Other Building & NaiotOoauC8 @azvi ------------ 799.00 442060 Dl8OiIiC8l & Plumbing Repair & MaiDtena 05.32.12 g'Cazd 120605I53329 I8800578 NB0ADDD I0m& CITY\0IC8&0L T8ADP 39.92 Total Electrical & Plumbing Repair & Naioteoauo --'---- ''-----' 39.92 442070 Bldg D8Gt Control Services 05.23.12 New Vouch 12052400153 06789069 CbeCb:708965\HAWKDYD PEST CONTROL I ]].95 Total Bldg Pest Control O8rviCOG ------- ------------ ]].95 445030 Nursery Service-Lawn and Plant CRI8 85.08.12 New Vouch 120509030019 06788151 CbeCb:708466\JDT AIR INC I8W\NOWI0g 4500.00 Total Nursery Derrilme'Lawo and Plant Care ______________ 4580.00 445110 Testing Services 05.0.12 New Vouch 12081030126 06789710 Cbeck:709841\T&8K0OLOGY I0C\LI0E AN 382.68 'Total Testing Services ---''- — ------- ' 382.60 446010 Administrative 88[vic8G 05.31.12 Journal 120604180033 010099 Doc 8vCG May\Iut8[d8pUItmGDt charge 45.00 Total Administrative Services _______ ________ 45.00 446140 ITS-Computer Replacement Cbarg8UaCk 05.01.12 IT 8Bpl 12051617,5144 00005825 MAY ITS DORL CO3QCK 10.43 ----''— Total ITS-Computer Replacement CbaroebaCb ----'—' 101.42 446160 ITS-Network/Internet CbaIg8ba:k 05.0I.12 IT Iot/Nwk 120504135537 0080501 MAY ITS 0DTW/INT8NQT 60.00 Total ITS-Network/Internet Chargeback 60.00 Airport Commission Packet 6/21/12 Page 41 of 51 TRID; 06.I4.12 13:12:27 Method: 4 Page: 5 Iowa City General Ledger System Expenditures Detail FY 2012 Detail Reporting For the period 05.01.12 to 05.31.12 Trans Date Trans Tvou D8onr # GVVrC8 Description Debit Credit ----------- ---------- ------------ -------- ----------------------------------- ------------ ------------ 7600 Airport (CONTINUED) 560100 Airport UnezatiVoG (CONTINUED) 446200 Photocopying Cbazgebaob 05.01-12 Copier Cbg 10524182918 00580045 &P8 PHOTOCOPY C8&KQO 28.86 Total Photocopying Chargeback 446220 Phone G8cviC8 Cbargebaci 05.31.12 QnCot Cbzg 120601161808 0000032 May Telecom Charges Total DhOo8 8eIriCo Cbazg:bock 446300 Phone Equipment/Line CbazgebaCb 05.01.12 Pb Qgutpmt 120601115800 00805018 MAY yOON EQUIP C8QDK Total Phone Equipment/Line Cburgabaok 446320 Mail ChazgebaCk 05.01.12 Mail 120512170826 00500057 APR POSTAL C8A88Q8 Total Mail Cborgebock 446350 City Vehicle Replacement Cbnrgebacb 05.31.12 Q8 Bogl 120604142759 00005006 MAY REPLACEMENT COOT Iot8l City Vehicle Replacement Cba[qebdCk 446370 Fuel CDar9Wback 05.31.13 Q0 Div 120604142759 00005008 MAY DIVISION PUD[ Total Fuel Cbargebuck 446380 Vehicle Repair & Maintenance Cbar88bacb 05.31.12 EO Div 128604142759 00005008 MAY DIVISION SERVICE Total Vehicle Repair 6 Maintenance Chargeback 449360 Interest 8xD8oGe 05.31.12 Journal 120523160841 018091 Dory 8aunaz Loan Iot\Na« Int8Ifund 05.31.12 Journal 120523160841 010091 OI Hangar Loan Iut\Nay IoterfVod Lo 05.31.12 Journal 120523160841 010091 8Q T'DDqr Loan Int\May IoterfVud Lo 05.31.12 Journal 120523160841 018891 OW %'8ugz Loan Iot\Nuy IoterIuud Lo ------------ %8.86 82.39 ____________ 82.29 92.50 ____________ 92.50 8.71 ____________ 8,72 l36].72 ------------ 1363.72 4]1.y8 ____________ 431.98 1134.95 ------ -----'' 1l]4.95 l77O.0 1254.57 930-86 867.64 Airport Commission Packet ,/21nu Page 42 of 51 TRID: 06.14.12 13;12;28 Method: 4 Page: 6 Iowa City Ceneral Ledger System Expenditures Detail FY 2�12 Detail Reporting For the period 05.0.12 to 05.31.12 Trans Date Trans Type 8eoVrt# Source Description Debit Credit ----------- ------ --- ------------ ----- _ ----------------------------------- ------------ ------------ 7608 Airport (CONTINUED) 560100 Airport 0uezatiuoS (CONTINUED) 449360 Interest Expense (CONTINUED'! Total Interest _____________ 4823.10 452010 Office Supplies 05.22.12 g'Cac8 120685153929 18800577 STAPLES 00106260\MICD&QL TB8R 41,97 Total Office Supplies ____________ 41.97 454020 Subscriptions 05.22.12 D'2Bzd 120605153929 18800501 CORRIDOR MEDIA g8OUD\MICDADL T88BP 59.95 Total Subscriptions ------------ ------------ 59.95 461-040 Other Agriculture Chemicals 05.08.12 New Vouch 130509030019 06188153 Cb;ck:700466\JOT AIR INC I0W\MAI0T 48.14 Total Other Agriculture Chemicals ------------ ------------ 48.14 466050 Electrical GuDolipg 05.22.12 New Vouch 12852030016 06788754 Check;7089I4\8LUEGI0BQG LLC\COUPLIN 102.04 Total Electrical Q000li8G ____________ 102.04 467020 Equipment Repair k Maintenance Supplies 05.08.12 New Vouch 120509830019 06788153 Cb8ck:708466\JOT AIR INC IOW\N&I0T 64.19 Total ------ Equipment Repair & Maintenance Supplies —'—'--''' 64.19 475010 Furniture 6 Office Equipment 05.08.12 New Vouch 120509030019 06788276 C&8Cb:708512\T&LLg8A8S BUSINESS 8DS 3879,08 05.11.12 B8w VO8Cb 120514038015 06780388 CUenk:708767\TALLGDAS8 BUSINESS 8D8 ______ 19.85 _ _______ Total Furniture & Office Equipment 3898.93 490I50 Operating Subsidy 05.31.12 Journal 120523160841 0I0087 Airport 10% OD Coord\8a- � Budgeted O 959.75 ' ------------ --- ____ Total Operating Subsidy 959,75 Airport Commission Packet ,/21nu Page 4aofn1 ',RID: 86.14.12 13:12:28 Method: 4 p@o8: 7 Iowa City QeoeraK ledger System Expenditures Detail PY 2012 Detail Reporting For the period 05.0.12 to 05.31.12 Trans Date T Trans Type D DeDU2t# S SnucC8 D Description D Debit Credit ------ - ----- - ------ - ---- - ------------------ - ------ - ------ Total Interfund Loan Total Airport Operations ------------ 3656.82 ____________ 29284.62 Airport Commission Packet ,/21nu Page 44m51 TQID: 06.14.12 13:12:28 Method: & Page: 8 iowa City General Ledger System Expenditures Detail FT 2012 Detail Reporting For the period 05.01.12 to 06.31.12 Trans Date Trans Type 8oDOrt# 80ucoe Description Debit Credit ----------- ---------- ------------ -------- ----------------------------------- ------------ ------------ 7600 Airport (CONTINUED) 560180 Airport 8neIatiV8B (CONTINUED) 490190 IUt8Ifuud Loan (CONTINUED) ------------ Total Airport 29284.62 Airport Commission Packet 6/21/12 Page 45 of 51 TDID: 06.14.12 13:12:28 Method: 4 Page: 9 Iona City General Cudo8r System 8roCoditUraG Detail FY 2012 Detail Reporting For the period 05.01.12 to 05.31.12 Trans Date Trans Type RemorL# D8uICe Description Debit Credit ------ ----- ------ ---- ------------------ ------ ------ 7600 Airport (CONTINUED) 560100 &igmct Operations (CONTINUED) 490190 Iut8IfDnd 60aO (CONTINUED) ____________ GD&08 TOTAL 29284.62 ============ Airport Commission Packet ,/21nu Page 46 of 51 TRID: 06.14.12 13:12:44 Method: 4 PaVe: 1 Iowa City General Ledger System B8Y8ou88 Detail FY 3012 Detail Reporting For the period 05.01.12 C0 05.31.12 Trans Date Trans Type ReDOrt4 Source Description Debit Credit -----' ----- ------ ---- -----------------' ------ ------ 7600 Airport 560100 Airport Operations 381100 Interest on Investments 05.31.12 8llVC8tiVu 13060808010 May interest allocation 114.48 Total Interest on Investments ____________ 114.48 382108 Land Rental 05.04.12 MiBC QvmL 12052210528 7�-0&D0BD FORCES 8DG8DVD\M&y RENT 350.00 05.17.12 Payment 12051709053 0002I938 1-17\BOLL Q08Y & S&BDR&\D&YH00T 300.00 05.38.13 NiOV Dy0t 120604140458 70'14\&RMED y0RC88 8883RVQ\kIRPORT __ ____ 350.00 ------------ Total Land Rental 1000.00 382200 Building/Room Rental 05.01.I2 Payment 120501092727 0002100 1'28\WIlLI&NG KEITH & JEAN\M&Y I2\ 151.00 05.01.12 Payment 120501092727 00021867 1'21\8ALL D08QDT\@&Y 12\8&0GAD #6 144.00 05.01.13 Payment 130501092727 00021867 1-21\O&LL 00QRT\0AY 13\8&NG&k #12 161.00 05.81.12 Payment 120501092727 00021874 1'25\8&RT0IQ D&0DY\MAY 12\8&NG88 # 172.00 05.01.12 Payment 130501092727 00021875 1-22\N6226W INC\MAY 12\8ANG&8 #49 172.00 05.01.12 Payment I20501092727 00021906 1'23 ROOF DDITH\M&Y 12\D&00AD #42 172.00 05.01.1.2 Payment 120501092727 00821909 1-20 POWERS RO80BT\M&Y 12\D&08&R # 144.08 05.01.12 Payment 120501093727 00021951 1'27\9OLA8KI MIC8&QL\M8Y 12\8AB8&8 15l.00 05.02.12 Payment 120502093351 00021834 1'28\&BDBRGQ0 J&8O0\K&Y 13 8&08AR 144.00 85.02.12 Payment 120582093351 00021834 1-28\AND8R8Q0 J&SO0\MAY 12\8&08&D 144.00 05.03.12 Payment 120503091444 0002I829 1'10\FID6D 8ORA8D\MAY 12\8A0CAR #S 172.00 05.03.12 Payment 120503091444 00021835 1'21\8Q&DIQ8T88 MQB6Q & 8DV3DLY\M& 151.08 05.83.12 Payment 120503091444 00021861 1-25 gITTO0 MIKE\M&Y 12\830QAD #26 151.00 05.03.12 Payment 12850091444 80021910 2'12\OPQRATOD PERFORMANCE L&8\M&Y l 4038.08 05.03.12 Payment 12050031444 00021910 2'12\OPERATOD PERFORMANCE Q0\0&Y l 615.00 05.04.12 Payment 120504093251 00021844 2'8 C&RD 8M8UL&NC8\NAY 12\OyyICO 100.00 05.04.12 Payment 128504093251 00021866 2'7\8U6LO8G JU08TBAQ\N&Y 12\B&NQ&R 144.00 05.07.12 Payment 128507091814 00021862 1'1I\DBMbRI8 J0S8D8\M6Y 12\O&0Q&D 151.00 05.07.12 Payment 120507091814 00021873 1'11\DUTLD3 J0R0 N&Y 12 R #36 172.00 05.87.12 Payment 120507091814 00021873 1-11 '8DTCOD JDD0\MAY 12\DA08&R #37 172.00 05.08.12 Payment 1120508093882 000218]] 2'10\yDLL3R &COTT`M&Y 12\8A0Q&R #3 172.00 05.08.12 QaYm8uC 120508093802 00021868 2'6\8ULQ&8DLQ D8VID\0AY 12\8&§8&R 151.00 Airport Commission Packet 6/21/12 Page 47 of 51 TRID: 06,14.12 13;12;45 Method: 4 Iowa City General Ledger System Revenues Detail FY 2012 Detail Reporting For the period 05,01.12 to 05.31.12 Trans Date Trans Type Report# Source Description 7600 Airport (CONTINUED) 560100 Airport Operations 382200 Building/Rool, 05,08.12 05,08.12 05,09.12 05.10.12 05.11,12 05.11.12 05.11.12 05.14.!2 05,14.12 05.14.12 05.14.12 05,14.12 05,15.12 05,15.12 05,15.12 05,15.12 05.15.12 05.15.12 05.15.12 05.!6.12 05.17.12 05-17.12 05.17.12 05,17.12 05.17.12 05.17.12 05,17.12 05,18.12 05.1.8.12 05.18.12 05,18.12 05.18,12 (CONTINUED) Rental (CONTINUED,! Payment 120508093802 Payment 120508093802 Payment 120509095047 Misc Pymt 120510092557 Payment 120511090716 Payment 120511090716 Payment 120511090716 Payment 120514100800 Payment 120514100800 Payment 120514100800 Payment 120514100800 Payment 120514100800 Payment 120515092132 Payment 120515092132 Payment 120515092132 Payment 120515092132 Payment 120515092132 Payment 120515105439 Payment 120515105439 Payment 120516095828 Payment 120517093853 Payment 120517093853 Payment 120517093853 Payment 120517093853 Payment 120517093853 Payment 120517093853 Payment 120517093853 Payment 120518105054 Payment 12051816054 Payment 120518105054 Payment 120518105054 Payment 120518105054 Page: 2 Debit Credit 00021869 2-11\IOWAAERO\MAY 12\HANGAR 443 172.00 00021672 2-8�MASCARI RICK\MAY 12\HANGAR #30 151.00 00021880 2-6\LACINA DAVE�MAY 12\HANGAR #57 202.00 2-20\TODD SHEPHERD\MAY RENT 111.50 00021276 2-8`SAPPHIRE VISTAS LLCjFEB 12�HANG 00021503 2-8\SAPPHIRE VISTAS LLCIMAR 12lHANG 151.00 00021670 2-8�SAPPHIRE VISTAS LLCIAPR 12\HANG 151,00 00021852 1-20\RUYLE JOHN\MAY 12\HANGAR #33 358,00 00021885 1-16\ZUBROD ROY\MAY 12\HANGAR #20 151.00 00021907 1-40\JET AIR INC\MAY 12\BUILDINGS D 4287.00 00021919 1-40\JET AIR\MAY 12\HANGAR #60 178,00 00021919 1-40\JET AIR\MAY 12 \HANGAR #59 178,00 00021270 2-20�JET AIR INC\FEB 12\BUILDINGS D 4287.00 00021282 2-20\JRT AIR\FES 12\HANGAR #60 178.00 00021282 2-20\JET AIR\FEB 12\HANGAR #59 178.00 00021465 2-16\FULL JERRY\MAR 12\HANGAR #45 204.00 00021828 2-22\ODGAARD JACOB\MAY 12`HANGAR # 151.00 00021459 9-2\YEAGER DAN\MAR 12 \HANGAR #17 151,00 00021626 9-1\YEAGER DAN\APR 12\HANGAR #17 151.00 00021947 2-1\ROHR BRIAN\MAY 12\HANGAR #27 151.00 00020232 1-21\DOUGLAS BRIAN\SEP 11\HANGAR # 141.00 00020444 1-21\DOUGLAS BRIAN\OCT 11\HANGAR # 144.00 00020637 1-21\DOUGLAS BRIAN\NOV 11\HANGAR # 144,00 00020863 1-21\DOUGLAS BRIAN\DEC 11\HANGAR # 144.00 00021699 1-21�DOUGLAS BRIAN\APR 12\HANGAR # 144.00 00021884 1-16\CHALKLEY BEN\MAY 12\HANGAR #1 151,00 00021943 1-21\DOUGLAS BRIAN\MAY 12\HANGAR # 233,00 00021826 89-1\MILLER RICHARD\MAY 12\HANGAR 172.00 00021843 89-6`YAMADA THORU\MAY 12\HANGAR #2 151.00 00021850 89-8\HINCKLEY HARRY\MAY 12\HANGAR 404.00 00021850 89-8�HINCKLEY HARRY\MAY 12\HANGAR 144,00 00021853 89-9�VOS JEREMY\MAY 12\HARNGAR #64 196.00 Airport Commission Packet 6/21/12 Page 48 of 51 IRIU: 06.14,12 13:12:45 Method: 4 Page: ] Iowa City General Ledger System Revenues Detail KY 20I2 Detail Reporting For the period 85.01.12 to 05.3I.12 Trans Date Trans ?voe Deport# Source Description Debit Credit ----------- 7600 Airport (CONTINUED) ---------- ------------ -------- ----------------------------------- ------------ ------------ 568100 Airport i0DS (CO0TI0OQD] 382200 Boildio9/Room Rental (CONTINUED) 05.18.12 Payment 120518105854 00021878 89'10\?I88B&UQH JOOTIN\MAY 12\8&N8 178.00 05.18.12 Payment 120518105054 0002I881 89'12\P&TT8C8U6L 8ICB&BD\M&Y 12\8d 234.00 05.18.12 Payment 120518105054 00821883 89'12\ALLD0DBD PATUICK\M&Y 12\DA0Q 172.00 05.I8.12 Payment 120518105854 00021896 89'14\BDMO0DS TE8RY\N&Y 13\O&0Q&D 320.00 05.18.12 Payment 120518105054 00021903 89-18\3QO&URONS OQ\NkY 12\BA0G&R #5 17Z,00 05.18.12 Payment 120518106054 00021905 89'19\0U80QIT DU0\M8Y 12\8&QG&8 #] 31030 05.18.12 Payment 12051810504 00021920 89'21 SW8030y B&OQI\MhY I2\8A0QDR 144.00 O5.I8.13 Payment 120518105054 00021942 89'26\C080 Q&8Y\N&Y 12\8A0Q&8 #41 172.88 05.18.12 Payment 12050105854 08021946 89 0\ME&DD JAMES 0\N&Y 12\8&0G&8 172.80 05.23.12 Payment 120523092441 00021883 2'5\0D I& PHY3 T8DDDY ASSOC\M&Y 12\ 282.00 05,29,12 Payment 120529094412 00022108 3-6\3C8MQISQR DD8S\JON 12\D80Q&D # 209.00 05.30.12 Payment 120530091146 00021879 3'3\VCKQ0F8LS JOHN / 0I080DTS\M&Y 1485.00 011.30.12 Payment 120530091146 00021879 3'3\OCK8NFOLS JOHN / WI0G0UTS\N&Y 110.00 05.30.12 Payment 120538091146 00022058 1'22\RILLI8MS KEITH & J8&0\JO0 12\ 151.00 05.30.12 Payment 120530091146 00022062 1-21\&0DQRGQN I&G00\JUN 12\8&0Q&8 144.00 05.30.12 Q8y08Dt 120530091146 00022062 1'21\80DED8ON JA&O0\JU8 12\8&NG&X 144.00 05.38.12 Payment 12050091146 00022008 1'18\BDUNLEY J8MDD\JU0 12\8&0G&D # 151.00 05.30.12 Payment 120538091146 00022098 1'17\8&LL DOBD8T\JU@ 12\D&8G&D #6 144.00 O5.30.12 Payment 120530091146 00022098 1'17\8&LL DO8BRT\JO0 12\D&0G&8 #12 151.00 05.30.12 Payment 120530091146 00022106 1'l6\06226W I0C\JU0 12\8&08&R #49 172,00 O5.31.12 Payment 120531891258 00022063 2-13`88&DI08TO0 NQDl8 6 88VQ86Y\JU 151.00 05.31.12 B3y08Dt 120531091258 00022111 2'10\LACI0& D&VQ\JU0 12\8&08A8 #57 282.00 05.31.12 Payment 130531091258 0802145 2-12'DO0N8S 08DG\JUN 12\8&08&B #51 -----'' 172.00 ------------ Total Building/Room Rental 27056.50 384100 Tel8DbOu2 CO00i8uinO 05.2I.12 MiGC py0t 120521093638 2-1\TH0 DMD8IC&0 BOTTLING COMPANY\V 14.40 05.31.12 JCuzoDl 120524174543 010098 5.21 American BoLtli\&cCmout code c 14.40 Total Telephone Commission --''—'''— ----'— 1440 14.40 Airport Commission Packet 6/21/12 Page 49 of 51 TBI : 06.14.12 8!12:45 Method: 4 Page: 4 Iowa City General Ledger System Revenues Detail FY %Ol% Detail Reporting For the period 05.01.12 CO 05.31.12 Trans Date Trans Tvno DeDurt# Source Description Debit Credit -----' ----- ------ ---- ------------------ ------ ------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 384200 Vending Machine Comm 05.3I.12 Journal 120524174543 0I0098 5.21 American Buttli\8OOouDt Co88 C 14.40 _______ _____ __ Total Vending Machine Comm 14.40 384900 0tb8I CON0iGGiOOG 05.10.12 MiGC py0t 128510092557 2'21\QASTDD0 &YI&TI00 FVDLB\8A8 COM 1183.50 —'--'—''----''— Total Other Commissions 110.50 30120 General Levy 05.31.12 Journal 128523I60841 010887 Dtax to &izpOrt\May Budgeted 0p8zat 83]3.]3 ------ '-'—''''''' Total General Levy 8333.33 ------------ Total Airport Operations 1440 37716.61 Airport Commission Packet 6/21/12 Page 50 of 51 TRID: 06.14,12 13:12:45 Method: 4 Page: 5 Iowa City General Ledger System Revenues Detail FY 2012 Detail Reporting For the period 05.01.12 to 05.31.12 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ -------- ----------------------------------- ------------ ------ - - - - -- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) ------------ ------ - - - - -- Total Airport 14.40 37716.6"- Airport Commission Packet 6/21/12 Page 51 of 51 TRID: 06.14.12 13:12:45 N8Lb0U: 4 Ddou: 8 Iowa City General Ledger System Revenues Detail FY 3012 Detail Reporting For the period 05.01,12 t0 05.31.12 Trans Date Trans Type 88QVrt# Source Description Debit Credit -----' ----- ------ ---- -----------------' ------ ------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED!) ------------ �+* GRAND TOTAL 14.40 37716.61 ============