Loading...
HomeMy WebLinkAbout01-19-2012 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA - REVISED AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JANUARY 19, 2012 - 6:00 P.M. 1. Determine Quorum 1 min* 2. Approval of Minutes from the following meetings: 5 min December 15, 2011 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion / Action: a. Airport Commerce Park 5 min b. Hangar L 15 min i. Public Hearing ii. Consider a resolution approving the plans and specifications for Phase 1 construction project. c. Terminal Building Brick Repair 15 min i. Public Hearing ii. Consider a resolution approving the plans and specification for the Terminal Brick Rehabilitation project d. FAA/IDOT Projects: AECOM / David Hughes 5 min i. Obstruction Mitigation ii. 7/25 Parallel Taxiway e. Care Ambulance 10 min i. Consider a resolution approving Commercial Business Agreement with Care Ambulance f. Airport "Operations" 15 min i. Strategic Plan- Implementation ii. Budget iii. Management 1. FY2011 Annual Report 2. Airport Operations Specialist Position a. Evaluation g. FBO / Flight Training Reports 5 min i. Jet Air / Air Care ii. Iowa Flight Training h. Subcommittee Report 2 min i. Subcommittee Assignments ii. For January — Infrastructure (Horan, Mascari, Tharp) iii. For February — Budget (Chair, Secretary, Tharp) i. Commission Members' Reports 2 min j. Staff Report 2 min 5. Set next regular meeting for February 16, 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 December 15, 2011 Page 1 MINUTES DRAFT IOWA CITY AIRPORT COMMISSION DECEMBER 15, 2011 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Minnetta Gardinier, Howard Horan, Rick Mascari, Jose Assouline, Steve Crane Members Absent: Staff Present: Sue Dulek, Michael Tharp Others Present: Matt Wolford, Philip Wolford, Jeff Edberg, David Hughes, Tim Busch, John Yeomans, Chuck McDonald, Daryl Smith, Eric Scott RECOMMENDATIONS TO COUNCIL: Approve Amendment #2 to listing agreement with Skogman Realty to extend the term of the listing agreement CALL TO ORDER: Chairperson Gardinier called the meeting to order at 6:02 P.M. APPROVAL OF MEETING MINUTES: Mascari moved and Assouline seconded a motion to approve the minutes from the November 17 meeting. Motion passed 5 -0 PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION /ACTION: A. Airport Farming Operations — John Yeomans stated he had given Tharp a lease agreement for the packet. Yeomans discussed the details of the lease agreement Crane asked if the price was changing, Tharp noted that the base rent increased from $25,000 to $31,000. Yeomans mentioned that the rates at Iowa City were similar to the rates at the Cedar Rapids airport. B. Airport Commerce Park — Edberg mentioned that the listing agreement was due to expire and that he has signed the amendment to extend the agreement. Edberg stated the purchase agreement for Lots 16 and 17 had been approved by City Council. Edberg stated he had contacted the individual that made a previous offer on Lot 17 to discuss moving to a different lot and that he was going to meet Monday with him. Edberg said he would be suggesting Lot #12. Assouline asked about leasing the other lots and the vetting process for lease offers. Edberg responded to his questions. i. Consider a resolution approving amendment #2 to listing agreement with Skogman Realty — Mascari moved and Horan seconded resolution # A11 -27. Motion passed 5 -0. C. Privately Constructed and Owned Corporate Hangar— Tharp stated that he and Gardinier had been involved in some discussions with a group interested in building their own hangar at the airport. Tharp noted the Airport Commission needed to set some policy decisions regarding privately constructed facilities. Tharp noted that one of these is a policy regarding self - fueling systems. Tharp stated that he had been researching Airport Commission December 15, 2011 Page 2 airports around the state. The pattern he saw was that if the airport had a full -time Fixed Base Operator then generally the self - fueling operations were not allowed. If there was not a full time FBO, then they were treated on a case -by -case basis. Tharp stated that there was one underground storage tank on the field that was attached to a building leased by the University of Iowa. Tharp commented that as the Airport Commission considered whether to allow more of these systems, they need to focus on the liability issues associated with the facilities. Tharp noted that today there are significantly more regulations in play and having some controls over the handling would be critical. Tharp noted that if the Airport Commission was to allow these self - fueling facilities they should be above ground systems. Members discussed different options regarding the storage tanks. Mascari asked about the possible location of the hangar. Tharp responded that the best area available now is just east of the university hangar. Gardinier questioned whether the Commission wanted to set the precedent of allowing these tanks or to consider giving priority to supporting the FBO on the field. Horan asked Wolford about how much fuel is in a typical delivery. Wolford responded to his experience with fueling. Wolford mentioned that Jet Air would be willing to work with any potential group to provide fuel services. Wolford mentioned Jet Air has a similar operation with the airline operating out of the Burlington Airport. Members continued to discuss the options of supporting the FBO versus self - fueling. Horan asked about development in the south area regarding folks putting in facilities there. Tharp noted that there are plans in place for service roads to serve the south area until a time that traffic might justify a second facility on the field. Gardinier stated that she would not like to see self - fueling systems. Mascari stated he agreed with Gardinier's position. Members agreed to a consensus not to allow self - fueling systems. Tharp mentioned the other item of concern was infrastructure to the area. Tharp noted that if there is a group that does lease ground getting taxiway infrastructure to the area would be something that needed to be done. The immediate apron area for any private hangar would be the responsibility of the hangar owner and part of their construction costs. Tharp noted that in the immediate future, they would be able to work within the Hangar L project to extend the taxiway to the area. Crane asked about how much cost they'd be looking at. Tharp mentioned he had asked Eric Scott to put some costs together and stated the estimate is about $80,000 to build the taxiway out to the building. Mascari asked about road access to the area. Tharp mentioned that initially the entrance point would be the common gate by the maintenance shop. He mentioned that phase 2 of the Hangar L project does finish the area with a parking area for direct access from the south. Gardinier restated she wanted to express that the Commission would be happy to have these facilities at the airport. D. Hangar L — i. Consider a resolution setting public hearing for plans and specification for Phase 1 construction — Tharp stated he had the plans and specifications in hand. Crane moved and Assouline seconded resolution #A11 -28. Motion passed 5 -0. E. Terminal Building Brick Repair — i. Consider a resolution setting public hearing for plans and specifications for the Terminal Brick Rehabilitation Repair Project — Tharp stated he had the plans and specifications in hand. Mascari moved and Crane seconded resolution #A11 -29. Motion passed 5 -0. F. FAA /IDOT Projects: AECOM — i. Runway 7/25 & 12/30 — Hughes stated that they did finally get closure of the grants for the previous work. Tharp noted they did get their final payment from FAA. Airport Commission December 15, 2011 Page 3 ii. Obstruction Mitigation — Hughes stated they were working with Dulek and the attorney for the Hargrave property to lower some light poles. iii. 7/25 Parallel Taxiway — Hughes stated they have hit winter shutdown. He stated the contractor needs to do some stabilization work to complete that process. Horan asked about when the project would be restarted. Hughes stated they'd be looking toward mid - March. Hughes stated the contractor has about 50 working days expired out of the 80 days allowed in the contract. a. Consider a resolution approving Task Order #8 with AECOM for design and construction services for Airport Electrical and Lighting Rehabilitation — Horan asked about what all was in the project. Tharp responded that the project would consist of LED light replacements for the entire airport's exterior lighting. Tharp noted that originally he had been working with the Public Works department, but due to the work and the knowledge AECOM has from previous electrical work, he wanted to pull it back and ask them for assistance. Horan moved and Assouline seconded resolution #A11 -29. Motion approved 5 -0. b. Consider a resolution approving Task Order #9 with AECOM for design services agreement for construction of Runway 7/25 parallel taxiway paving and lighting — Mascari moved and Crane seconded resolution #A11 -30. Motion approved 5 -0 G. 2011 Pavement Repairs i. Consider a Resolution Accepting Work for concrete replacement by All American Concrete - Hughes stated the repair work had been completed by All American concrete. Mascari stated he liked the work. Mascari moved and Horan seconded resolution #A11 -31. Motion approved 5 -0. H. FY2013 FAA Airport Improvement Program Application — Hughes handed out the summary sheets from the program application. Hughes stated the sheets go along with the comments from the last meeting. Gardinier asked about the Master Plan section and the process for it. Tharp noted this would be a large process for the 20 -year plan, with the last plan completed in 1996. Members discussed the application package items. Horan stated they need to begin planning for the south development now. Hughes stated that would also be a component of the master plan. I. Airport "Operations ": Tharp noted that there was some electrical repair work to still be done. i. Strategic Plan- Implementation — No discussion. ii. Budget — Crane asked about the land rental account noting the revenue planned and paid to date did not appear to be in line. Tharp noted that the bulk of the account is the farm lease payment. iii. Management — a. FY2011 Annual Report — Tharp noted that he had placed a draft of the report into the packet for review. He noted that with the budget schedule set up they could approve the report with revisions in January. Gardinier asked if Tharp would send the report electronically. Tharp noted he would send the electronic file to everyone. b. Consider a resolution approving contract amendment to Airport Maintenance Agreement with Jet Air — Mascari asked what services Jet Air provides to which Tharp responded. Tharp stated the desire to extend the contract in two parts. Tharp noted that if the contract were not renewed at the end of the year, the Airport would be scrambling to provide for winter services in the middle of the season. Tharp noted that Airport Commission December 15, 2011 Page 4 the other reason was to clean up and clarify some of the language in the contract to better outline the responsibilities of each party. Members discussed the extension. Mascari noted that the monthly maintenance generated by Jet Air should be completed by Tharp. Crane moved resolution #A11 -32 and seconded by Mascari. Motion carried 5 -0. c. Airport Operations Specialist Position 1. Evaluation Process - Tharp noted that he was due for evaluation in February, and he put this on the agenda for the Commission to have an opportunity to discuss the evaluation process. Gardinier asked if Tharp would send the evaluation form to her, and she would forward to members. [Shouldn't Mike forward this to members and request that their input be forwarded to Minnetta? then I would take their input and complete a review document. Can I communicate this to all of the Commission ?] J. FBO / Flight Training Reports — i. Jet Air / Air Care — Matt Wolford handed out the maintenance activity list. Wolford noted the hangar door seals were completed [on how many hangars? He mentioned that, and it's better than giving the impression that all hangar doors were completed.] prior to Thanksgiving. Wolford noted they were waiting for the tractor blade. Tharp noted he had talked with the equipment shop and that it was due yet within the week. Mascari asked about how the purchases work. Wolford noted they usually purchase via their business credit card and then give receipts to Tharp. Tharp noted that Jet Air does have some purchasing authority in the contract to allow them to purchase things on behalf of the airport. Wolford stated that they were working on some international aircraft sales. Philip Wolford stated they had sold 4 corporate jet aircraft recently. He stated that one went to Germany, but the others stayed locally. Philip Wolford mentioned that a number of previously frequent charter customers are looking at purchasing their own aircraft. Philip Woolford brought up the declared distances on the runway and how they impact the airport operations. Members discussed the runway distances with Wolford. Horan asked about the changes in the computer weather station. Tharp noted that the default website is set to the National Weather Service aviation site. Mascari stated that when the weather service was installed it was cutting edge, but now due to other technology, it wasn't as popular. Tharp noted the subscription cost was $2100 per year. iii. Iowa Flight Training Tharp noted that both instructors appeared to be flying a lot. Gardinier noted they had two simulators online for use. K. Subcommittee Reports Gardinier noted that no subcommittee was due to report. She noted that the infrastructure committee was due to report in January. L. Commission Members' Reports — Mascari thanked Dulek for her work on recent correspondence. M. Staff Report —Tharp noted that he had been in contact with the owner of Whirlybird Helicopters and that they were interested in having an opportunity to discuss with the Commission a return to operation. Airport Commission December 15, 2011 Page 5 SET NEXT REGULAR MEETING FOR: Members set the next meeting for January 19, 2012. ADJOURN: Gardinier moved to adjourn. Meeting adjourned at 7:40pm CHAIRPERSON DATE Airport Commission December 15, 2011 Page 6 Airport Commission ATTENDANCE RECORD 2011 Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time TERM N N N , `� 0 ,; W N � O O N \ NAME EXP. O \ \ O d7 N 0) \ \ C\ Rick 03/01/13 X X X X X X X X X/E X X X X X X X Mascari Howard 03/01/14 X X X X X X X X X X X X X X X X Horan M i n netta 03/01/15 X X X X X X X O/E X X X X X X X X Gardinier Jose 03/02/12 X X X X O/E O/E X X X X X X X X O/E X Assouline Steve Crane 03/02/14 O/E X X X X O/E X X X X X X O/E X O/E X Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time Marketing Services Report January 5, 2012 Skogman Realty 2530 Corridor Way, Suite #302 Coralville, Iowa 52241 Prepared by: Leff Edberg, CCIM, SIOR, green Prepared for: Gardinier, Minnetta Tharp, Michael Email: M.gardinier @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: IPW: http : / /It9ruppertrd.skogman.com/ Iowa City MLS: 20110622 Cedar Rapids MLS: 1100686 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. 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 MLS, 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 January 18, 2011 Airport lots. January 19, 2011 on Airport History Attend City Council meeting for approval of listing Agreement Obtain sales comparables for lots from, appraiser. Review legal records for Meet Howard Horan and Michael Tharp at airport conference room for briefing 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 Install site signs. January 23, 2011 Receive sign call on lot 17, 16. Make appointment to spec outbuilding for Dog Care business. January 29, 2011 Meet client and builder to plan a building on lot 17. Will meet again next week. February 9, 2011 Met client, went over building plans. Will meet lender next week and prepare purchase offer. February 11, 2011 Submit information on lots to Insites Magazine. February 17, 2011 Submit information to Press Citizen for Real Estate Guide Back Cover February 17, 2011 Call client regarding next meeting with lender. Client had surgery. 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 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, 1A 52246 19 350 5045 RESOLUTION NO. RESOLUTION APPROVING PLANS, SPECIFICATIONS, FORM OF CONTRACT, AND ESTIMATE ON COST FOR "TERMINAL BUILDING EXTERIOR ENVELOPE REPAIRS" CONSTRUCTION PROJECT AT THE IOWA CITY MUNICIPAL AIRPORT WIIERE S, 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, RE, EE IT RESOLVED BY THE IOWA CITY AIRPORT C 11 MSSI N THAT: T: 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% o (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 /aids for the construction of the alcove -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 t be received by the City of Iowa City, Iona at the Office of the City Clerk, at the City Mall, before 2:00pm on the 9hday of February, 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 Iona City Airport Terminal Building, 1 801 S. Riverside Drive, Iowa City, Iowa at 6 :0 pm on the 16th day of February 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 lay. lave, or if said rneetin is cancelled, at the next meeting of the Airport Commission thereafter as posted by the pity Clerk. Passed and approved this CHAIRPERSON ATTEST: SECRETARY day of It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays 2012. Approved By: 1; 1�� I - I 1 City Attorney's Office Absent the Resolution on be soul ine Crane Garrdinfer Horan Mars ari Prepared by: Michael Tharp, Operations specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 1 350 5045 RESOLUTION INTO. RESOLUTION APPROVING PLANS, SPECIFICATIONS, FORM OF CONTRACT, AND ESTIMATE N COST FOR 'HANGAR L PHASE 1" CONSTRUCTION PR JECT AT THE IOWA CITY M[UNICIPAL AIRPORT T 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. MOW, 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 The City Cleric 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 weeny and having a general circulation in the city. 4. Bids for the above -named project are to b received b the City of Iowa Cite, Iowa at the Office of the City Clerk, at the City Hall, before 2:00 pm on March 6, 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, 18 01 S. Riverside Drive, , Iowa Cit y, Iowa at pm on the 15th day of March 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 day of 2012. Approved By: CHAIRPERSON 5W ATTEST: SECRETARY City Attorney's Office It was moored by and seconded by adopted, and upon roll call there were: the Resolution be Ayes Nays Absent Assouline Crane Gardinier Horan Ma oari r� r� N 4J V H L%] r T� F� O �Q Q C V U O 0 O 69 O 0 0 a� a� bA a� a 0 H cn 0 i m Q X w c m 0 CO W Lf) LO cz 0 O O Q ^ O � � H cz O O O w O O O L O -5q � O M � Q) s3 O Q, U cz a O a1 O O 0o N o0 U) O a1 N N oo N 7t O r- N O N 0000 7t N O 110 06 vF bi) Oc LL fig bMF} N t O a_ bF3 bF3 N bF3 bF3 U Q a kn O o �n � O O 7 o �n �n O O O o� �n o o O o N 7t 00 O �n 0 0 a1 �1 V 1 bF3 oq � bF3 O 01 l� M 59 M .-� 00 69 69 bF3 � .-� 0 0 �1 �n � � � 00 3 b�} bq O CIO bF3 bF3 M b�} N ^ U s3 �O a t6 X t6 H a) 15 (6 � i cn .. LO c6 Q U a) L (6 (� ❑ a) .� E a) N a) N cn cn N U O :3 J m U >+ > O N N M O O M N O a) ? E *k U) O U O X .-. N >E N v��' cn L- '^, N A' N _ U d) W � jR W L p /� > `V L L) C Q O O p N N_ Q) cu .. VM I.J_ M `t X �' O a) �- N m ' U `-' E�_0 t6 O U O N O p cu a) a) O U m Cl) a) CA a LO w AW �� M 0) a O O c L) L) L) LL 0 d) m. L C L `- Y ~ O W AN U 1_ L L L O O U W �. N En m m m w wLp- a> a a O O O O O O O > 0 0 L H -::i 0 cn LL a -J U Y c1 O O O O O O O O O � .� +- o Q U G H O :3 U cn N N N N N N N N N N N N N N N N 0\O 00 M M kn kn O �-- a � � o � U U O 0 O 69 O 0 0 a� a� bA a� a 0 H cn 0 i m Q X w c m o1n2/2o12 DEVE: 0I.12.12 l]:43�3] Method: J Page 1 of 23 Page -. l Iowa City General Ledger System FY 2012 Revenue Reporting For the period 12'0I.11 to 12.3I.11 Estimated YTD Period Account Dmreun8 Revenue Revenue Remainder 11 ----'---------------------- --- ------------------------------ ------------ ------------ --- - ----- ------------ ------ 7600 Airport OTHER MI3C REVENUE 369100 Deinb of Expenses 75.00 -75.00 �teI OTHER MZ8C REVENUE IN7ER8OT REVENUES 381I00 Interest on Investments Total INTEREST REVENUES RENTS 382I00 Land Rental 382200 Building/Room Rental Total RENTS ROYALTIES G COMMISSIONS 384300 Vending Machine Comm 384900 Other Commissions Total ROYALTIES & COMMISSIONS TRANSFERS IR&NQF8RS FROM GOVERNMENTAL ACTIVITIES 30120 General Levy Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES Total TRANSFERS lotal Airport *** GRAND TOTAL **t ------------ ------------ ------------ 75.00 ------------ '75.00 ------ 6OO.00 53I.69 5.26 68.31 88.62 ------------ ------------ 600.00 ------------ 53I.69 ------------ 9.26 68.32 ------ 88.62 41968.00 11650.O? 8400.07 30317.93 27.76 231842.00 117984.00 18545.00 113848.00 50.89 ------------ ------ 27010.00 ----- ------ 129644.07 _______-___- 26945.07 144165.93 47.35 83.00 61.20 7.2O 21.80 73.73 20000.00 14539.30 153}.]0 5468.70 72.70 ------------ ------------ 20083.00 ----------- 14600.50 ------------ 1540.50 5482.50 ___ 72.70 100000.00 49999.98 033.33 50000.02 50.00 ------------ ------------ 100000.00 ------------ 49999.98 ------------ 8]3].32 50000.02 ------ 50.00 ------------ ------------ 100000.00 ------------ 49999.90 ------------ 8333.33 50000.02 ------ 50.00 ------------ ------------ 394493.00 ------------ 194851.24 ------------ 36824.16 199641.76 ------ 49.39 ------ 394403.00 ------ ------ 194851.24 ------ 36824.16 199041.78 --- 49 39 DXPE: 01.12.12 13:42:31 Method: l o1n2/2o12 Iowa City General Ledger em FY 2012 Expense Reporting For the period 12.01.11 t0 12.31.I1 Page 2 of 23 Page: I YTD Period Account AppropriaLed DxoaoditnzeB Expenditures Encumbrance Balance Used '--'~-~----------------------' 7600 Airport '------ ------- ------ ------ ------ ---' AIRPORT 960100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full. Time 1.00 I.08 412000 Perm Part Time 36370.00 I8394.80 3945.60 17975.20 50.58 413000 Temporary Employees 520.00 287.00 91,00 233.00 55.19 Total REGULAR SALARIES & WAGES --------- 36891.00 '''-'''''''' 1868130 ''-'-''-''- ------------ ------------ 4038.60 18209.20 '--'-' 50.64 OTHER WAGES 414500 Longevity Buy 244.00 243.75 .25 99.90 Total OTHER WAGES ''-''--'- 244.00 ------------ 243.75 -'------- -''-'-''-' ------------ .25 ''--'- 99.90 Total SALARIES & WAGES '------ 37135.00 -------' 18025.55 ''----- '-''''-''- ------------ 4036.60 18209.45 ------ 5O.96 EMPLOY9P BENEFITS QD0DP INSURANCE 42II00 Health Insurance 2598.00 1978.02 329.83 1619.08 55.00 421200 Dental Insurance 233.00 115.92 19.32 116.08 49.97 421300 Life Insurance 79.00 44.96 7.53 34.04 56.91 421400 Disability Insurance 1076.00 81.90 I3^68 94.10 46.53 Total GROUP INSURANCE ------------ 4085.00 ----''-'-- 3221.70 '--'---'-'- ' --'- ''''' ------------ 370.35 1863.30 -''''' 54.39 Q0CIA"15 SECURITY CONTRIBUTIONS 4%�lOO FICA 2841.00 1384.39 299.89 1446.61 4038 Total SOCIAL SECURITY CONTRIBUTIONS ------------ 2841.00 ------------ 1394.39 ------------ --'---'--'- ---''--'-- 299.89 1446.61 - 49.08 RETIREMENT CONTRIBUTIONS 423100 IDERS 2997.00 1527.31 335.76 1469.69 50.96 Total RETIREMENT CONTRIBUTIONS ------------ 2997.00 ------------ I527.21 ------------ ------------ ------------ 325.76 1469.69 ------ 50.96 ot8I EMPLOYEE ������ '----''- 9923.00 -'---'-- 6143.BENEFITS --'---- -----'' '-'---- 9y6.O0 4779.60 '--' 51.83 o1n2/2o12 EXPE: 0I.I2.I3 I3:42:31 Method: 1 Page 3 of 23 �A, Iowa City General Ledqer System FY 2012 Dzoauoa Reporting For the period 12.01.I1 to 12.31.11 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance W Used ---------------------------------------------- ------------ -------- ------ ----------- ------------ ------ 7600 lkirlpmzt. (CONTINUED) AIRPORT (CONTINUED) 560I00 Airport Operations (COXTINUQD) PBOPES8IONAL & TECHNICAL SERVICES 0FFICIAL/ADNI0OTRATIVE SERVICES 431020 Court Costs & 8ozviono 78.00 78.00 Total OFFICnuJ&DMIN8TDATIVD @RRVICE0 PD0PE8OIONAL SERVICES 432030 Annual Audit Total PDOPEQ8IONAL SERVICES DATA AND COMMUNICATION SERVICES 435056 Delivery Services 435057 Couriers 43506U Legal Publications Total DATA AND CDMMDNICkTION SERVICES TRAINING & EDUCATION 436030 Transportation 436050 Registration 436060 Lodging 436070 Miscellaneous Travel Expense 436080 Neula Total TRAINING & EDUCATION INSURANCE 437010 Comp Liability Insurance 437020 Fire & Casualty Insurance 437030 Worker's Comp Insurance 427041 Bonding & Other Insurance 437200 Loss Reserve Payment Total INSURANCE ------------ ------------ ------------ ------------ ------------ ------ 78.80 78.00 I202.00 1302.00 ------ ------ ------ ------ ------ --- 1202.00 2203.00 52.00 52.00 85.00 85.00 98.00 13.78 13.78 84.22 14.O6 ------------ ------------ 235.00 ----- ------ ----------- 13.78 13.78 ----------- 22I.22 ___ 5.86 700.00 122.10 577.90 17.44 400.00 235.00 175.00 56.25 5D0.010 221.62 268.38 46.32 30.00 '30.00 200.00 200.00 ------------ ------------ 1800.00 ------------ ------------ 608.72 ------------ 1191.28 ------ 33.82 4I48.00 3950.00 I98.00 95.33 12745.00 7153.00 5582.00 56.12 36.00 45.00 '9.00 125.00 901.00 001.00 5150.00 5I50.00 100.00 ------ ------ 2298O.00 ------ ----- 16298.00 - ------ 6683.00 --- 70.92 tXPE! 0I.l2]2 I3:42;3I Method: l o1n2/2o12 Iowa City General Ledger System BY 2012 Expense Reporting For the Deriod 12,,01.11 to 12,31,11 Page 4 of 23 Page; 3 Total PROFESSIONAL & TECDNICAL SERVICES REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building ReDaic & Raintena 442030 Structure Repair Maintenance O 442830 Be8tinq Equipment Repair G M8int 442840 Cooling Equipment Repair & Maint 442060 Electrical & Plumbing Repair & M 442078 Bldg Pest Control Services Total BUILDING REPAIR & MAINTENANCE SERVICE EQUIPMENT REPAIR & MAINTENANCE SERVICES 443050 Radio Equipment Repair & Maintoo 443068 Telecom Equipment ir 8 Maiot 443080 Other Equipment Repair & 14ainten Total EQUIPMENT REPAIR & MAINTENANCE SERVIC TECHNICAL SERVICES 445030 Nursery Service-Lawn and Plant C 445080 Oouw and Ice Removal --------------------------------- 58124.00 31862.18 YTD Pe�iod 54.8% 12085.00 Account Appropriated Expenditures Expenditures Encumbrance Balance I Used ------''~~-~~'^-----------'~~-'~--- 7600 Airport (C0NTINDDD) ------ ------ ------ ------ ----'-- --- AIRPORT (CONTINUED) 24.40 1000.00 813.32 I86.68 560I00 Airport Operations (CONTINUED) 1000.00 2232.13 907.65 -123213 222.21 PROFESSIONAL i TECHNICAL SERVICES (CONTINUED) 203.70 33.95 215.30 48.62 ------------ ------------ 2100400 UTILITY SERVICES -------- 2951.35 --_--------- 9811.17 ------ 53.29 283 .00 1127.42 438010 Qtormwater Utility Charges 7104.00 4734.66 789.11 2368.34 66.65 438930 Electricity 12903.00 7352.42 1246.35 5550.58 56.98 A638070 BeaLbu8 Fuel/Gas 6489.00 1112.97 654.40 5376.03 l7.l5 438080 Sewer Utility Charge 1654.00 546,71 94.64 1107.29 33.05 438098 Water Utility Charge 1454.00 547.78 89.80 906.22 37.67 08100 Refuse Collection Charges 1252.00 616.08 97.00 627.00 49.16 438110 Local Phone Service 907.00 907.00 438120 Long Distance Service 65.00 31.14 2.57 33.86 47.91 ToLaI UTILITY SERVICES '-----'- 31829.00 ---'-- 14941.68 -------- ----'-' '--'--- 2974.87 16887.32 -'-'- 46.94 Total PROFESSIONAL & TECDNICAL SERVICES REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building ReDaic & Raintena 442030 Structure Repair Maintenance O 442830 Be8tinq Equipment Repair G M8int 442840 Cooling Equipment Repair & Maint 442060 Electrical & Plumbing Repair & M 442078 Bldg Pest Control Services Total BUILDING REPAIR & MAINTENANCE SERVICE EQUIPMENT REPAIR & MAINTENANCE SERVICES 443050 Radio Equipment Repair & Maintoo 443068 Telecom Equipment ir 8 Maiot 443080 Other Equipment Repair & 14ainten Total EQUIPMENT REPAIR & MAINTENANCE SERVIC TECHNICAL SERVICES 445030 Nursery Service-Lawn and Plant C 445080 Oouw and Ice Removal --------------------------------- 58124.00 31862.18 2988.C3 3626L82 54.8% 12085.00 5443.24 848.75 6C42.76 45.03 5000.00 2135.44 795.00 2864.56 42.7I 1500 '00 366.00 366.00 1124.00 24.40 1000.00 813.32 I86.68 8I.33 1000.00 2232.13 907.65 -123213 222.21 419.00 203.70 33.95 215.30 48.62 ------------ ------------ 2100400 ------------ 11192.83 -------- 2951.35 --_--------- 9811.17 ------ 53.29 283 .00 1127.42 -844.42 398.38 454.00 454.00 5898.00 58.93 5839.08 1.00 ------------ 6635.00 ----------- ------------ 1186.34 ------ ___------------ 5448.66 _--- 17.88 37080.O0 22500.00 I8540.00 4500.00 4500.00 14580.00 60.68 14040.00 24.27 EXPE: 01.12.I2 13�42�31 Method: l o1n2/2o12 Towa City General Ledger System FY 2012 Expense Reporting Flor the period l%.Dl.11 to I2'31.II Page 5 of 23 Page: 4 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance & Used ---------------------- ---- -' 7600 Airport (CONTINUED) -- --- - ------ ------ ------ ------ - -- &IDD0DT (CONTINUED) 560100 Airport Operations (CONTINUED), REPAIR & MAINTB0&BC8 (CONTINUED) TECHNICAL SERVICES (CONTINUED) 445110 Testing Services 850.00 I25.00 725.00 I4.71 445140 Outside BziuCiuO 12?.OD 127.0O Total TECHNICAL SERVICES ------ 56597.00 -'----' 27125.00 -----' ----'-' ----'-- 4500.00 39472.00 ------ 47.93 INTR&'DQDARTK0NT SERVICES 446100 City Attorney Chazoebaok 5233.00 3007.37 884.53 3225.63 57.47 446130 ITS-PC/Peripheral Support Charge 400.00 408.00 100.00 446140 ITS-Computer Replacement Cbargeb 517.00 341.84 101.42 175.16 66.12 446I50 ITS-Application Development Foe 894.52 -894.52 446160 ITS-Network/Internet Cbargobaok 360.00 2I0.00 60.00 150.00 58.]3 44620 0 Photocopying Char8ebank 231.00 102.96 24.00 128.04 44'57 446220 Phone Service Chuzgohaok 692.00 444.51 247.49 64.24 4463QO Phone Equipment/Line Cbargebank I020.00 555.00 92.50 465 4 00 54.41 446330 Mail Chargeback 539.O0 210.29 47.47 318.71 39.75 446350 City Vehicle Replacement CbarSob 14397.00 8206.32 I363.72 6I90.68 57.00 446360 City Vehicle Rental CbazOebaCk 500.00 308.2I I91.79 61.64 446370 Puel ChurBebaok 3669.00 1361.I8 240.01 2307.82 37.I0 446380 Vehicle Repair 6 Maintenance Cba 15132.00 10718.2I 1049.58 44I3.79 70.83 446390 Auto Body Repair Cbargeback 234.00 224.00 Total INTRA'DQPARTMENT SERVICES ------------ 42904.00 -- ---' 26760.41 ------------ ------------ ------------ 3863.32 16I43.59 ' 62.37 MISCELLANEOUS SERVICES 6 CHARGES 449055 Perinitting Fees 65.00 65.00 449060 Dues & Memberships 675.00 525.00 275.00 158.00 77.78 449120 Equipment Rental 754.00 446.00 308.00 59.15 449350 Meals (non-travel) 38.46 '38.46 449388 Interest Expense 60060.00 28938.60 4823.10 3112I.40 48.18 Total MISCELLANEOUS SERVICES 6 CHARGES ------------ 61554.08 ------------ 29948.06 ------------ ------------ ------------ 5098.10 31605.94 --- 48.65 Total REPAIR 6 MAINTENANCE ------- _--- 188694.00 -------- 96212.64 ------------ ------------ ------------ 16412.67 92481.36 ------ 50.99 EXPE: 01,12.12 13:42;31 Method: 1 01/12/2012 Iowa City General Ledger System FY 2012 Expense Reporting For the period 12.01-11 to 12,31-11 Page 6 of 23 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance I Used ---------- W--"W"-WWWW ------------------------------- WW-ft 79.00 Airport (CONTINUED) --� --------- ------------ --------- ------------ ---- AIRPORT (CONTINUED 560100 Airport Operations (CONTINUED) OTHER PURCHASED SERVICES (CHANGE TO OFFICE SU GENERAL SUPPLIES 452010 Office Supplies 577.00 418.65 221.61 158-35 72,56 452030 Minor Office Equipment/Furniture X29.98 129.98 -129.98 Total GENERAL SUPPLIES -- - - - - - - - - - - 577.00 - - - - - - - - - - - 548. - - - - - - -- - -------- - - - - - - - - - - - - - - - 28.37 - - - - - - 95,0} BOOKS & PERIODICALS 454010 Reference Materials & Books 16.00 16.00 454020 Subscriptions 2099.00 546,00 1553.00 26,01 `I"otal BOOKS & PERIODICALS ---- 2115.00 ------------ 546.00 ------------ ------------ ------------ 1569.00 ------ 25.82 COMPUTER & PRINTING SUPPLIES 455120 M Computer Hardware 2600.00 1138.99 398.99 14961 01 43.81 To't'al COMPUTER & PRINTING SUPPLIES ---------- 2600.00 ------------ 1138.99 ------------ ------------ ------------ 398.99 1461.01 -- ft--- 43.81 Total OTHER PURCHAM SERVICES �CHANGE TO OFF ------ W ----- 5292.00 --------- 2233.62 ------------ ------------ ------------ 750.58 3058.38 ------ 42.21 OPERATING SUPPLIES AGRICULTURE SUPPLIES 461030 Plants & Trees 3000.00 3000.00 461040 Other Agriculture Chemicals 1500.00 1500.00 Total AGRICULTURE SUPPLIES ------------ 4500,00 ------------ ------------ ------------ ----- w ------ 4500.00 ------ REPAIR & MAIRTENANCE SUPPLIES 466030 Paint Supplies 23.00 23,00 466040 Plumbing Supplies 19.04 -1-9.04 466050 Electrical Supplies 1066.00 607.62 458.38 57.00 466060 Other Construction Supplies 119.00 119.00 466070 Other Maintenance Supplies 200.00 314.95 -114-95 157.48 Total REPAIR & MAINTENANCE SUPPLIES ------------ 1408.00 ------------ 941.61 ---- ft ------- ---------- ft - ------ ft ----- 466,39 ------ 66-88 EXPE: 01,12,12 13-442-131 Method: I 01/12/2012 lowa City General Ledger System FY 2012 Expense Reporting For the Period 12.01.11 to 12.31.11 Page 7 of 23 Pages 6 1 YTD Period ACCOUnt Appropriated Expenditures Expenditures Encumbrance Balance I Used ----------- ------------- --- ------------ ------------ ------------ ---- - ------ 1 Airpor.L (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) SURFACING MATERIALS 468030 Asphalt 103.00 103.00 468050 Sand 26.55 26.55 -26-55 Total SURFACING MATERIALS OTHER SUPPLIES & EQUIPMENT 469040 Traffic Control Improvement Supp 469190 141nor Equipment 469200 Tools 469260 Fire Ext & Refills 469320 Miscellaneous Supplies Total OTHER SUPPLIES & EQUIPMENT Total otal OPERATING SUPPLIES IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements 473020 Non-Contracted Improvements Total IMPROVEMENTS OTHER THAN BUILDING EQUIPMENT & FURNITURE VEIRICULAR EQUIPMENT (GREATER THAN $1,000) 474240 Tractors Total VEHICULAR EQUIPMENT (GREATER THAN $1, IT HARDWARE SOFTWARE (GREATER THAN $1,000) 476070 PC Hardware Total IT HARDWARE/SOFTWARE (GREATER THAN $1 Total EQUIPMENT & FURNITURE ------------ ------------ 103.00 ------------ 26.55 ------------ 26.55 ------------ 76.45 ------ 7 25 , 11 8 138.00 138.00 324.00 -324,00 76.00 581.17 3.50 -505.17 764.70 466,00 655,55 -189.55 140.68 552.00 170,40 58.95 381-60 30.E ------------ ------------ 1232.00 ------------ 1731,12 ------------ 62.45 ------------ -499.12 ------ 140.51 ------------ ------------ 7243.00 ------------ 2699.28 ------------ 89,00 ------------ 4543.72 ------ 37.27 20000.00 17100.00 1711-00,00 2900.00 85.50 9000.00 2822.00 6178,00 31.36 ------------ ------- 29000.00 ---- ------------ 19922.00 -------- 17100.00 --- ------------ 9078.00 - 68.70 4990.00 -4990.00 ------------ ------------ ------------ ------------ ------ ----- 4990,00 -4990.00 ------ 5025.81 -5025.81 ------------ ------------ ------------ 5025.81 ------------ - w ---------- -5025-81 ------ ------------ ------------ ------------ 505.81 ------------ ------------ 4990..00 -10015.81 ------ o1n2/2o12 FXP0! 01.12'I3 13;42;31 Method: 1 Page 8 of 23 Page: ? Inwu City Ceuer8I Ledger System FY 2012 Expense Reporting For the period 12,01.11 to 12.31.11 YTD Period Account Appropriated 8xppudituzea Expenditures En-cumbrance Balance I Used '''-'---~~''~~'-----''--- '-''' --''-~''~~— ''''''--- ------------ ---'-'''—' ------------ - 7600 Airport (CONTINUED) &IRP0DT (CONTINUED` 560I00 Airport Operations (CONTINUED) OTHER FINANCIAL DSRS 490150 Operating Subsidy 1I517.00 5758.50 959.75 5758.50 50.00 490190 Intezfuod Loan 46236.00 2I940.92 3656.82 23285.08 48.58 Total OTHER FINANCIAL USES ------------ ------------ 56753.00 ------------ 27699.42 ------------ 46I6.57 ------------ 29053.58 ------ 48.81 Total Airport Operations ------ 392164.00 ------ ------ 209723.90 ------ 46990.07 ------ 4990.00 177450.10 --- 54.75 7bta"l Airport ------------ -------- 392164.00 --- ------------ 209723.90 ------------ 46990.07 ------------ 499030 177450.10 ------ 54.75 01/12/2012 3X P3: 01.12.12 13:42:31 Method: I Page 9 of 23 Page; 8 Iowa City General Ledger System FY 2012 Expense Reporting For the period 12001.11 to 12.31.11 "TD Period Account Appropriated Expenditures Expenditures Encumbrance Balance W Used ----------------------------------------------------- - - ------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) ------------ ------------ ------------ ------------ ------------ ------ GRAND TOTAL 392164.00 209723.90 46990.07 4990.,00 177450.10 54.75 T8ID; 01.I2.12 13:44z15 Method: 4 o1n2/2o12 Iowa City General Ledger System Expenditures Detail FY 20I2 Detail Reporting For the period 12.01.11 to 12,31.11 Page 10 of 23 Pa3e; l Trans Date Trans Type Reom±# Source DeScriVti0u Debit Credit 760O Airport ------ ----- ------ ---- -----------------' ------ ------ 560100 Airport Operations 412000 Perm Dart Tinie 12.02.11 0I8 8vo I111300I0009 504957\CIC PAYROLL BECAy\yAYB0LL 02 II15.20 13.16.1I Old 8va 111214010009 505095 CIC PAYROLL REC&p\DAY80LL 16 13I5.20 12.30.11 Old Sys 111229010008 505234\CIC PAYROLL DECAP\yAYDOLL 0 1315.20 Total perm Part Time _____________ 3945.60 413000 Temporary Rmmloyeea I2.16.11 Old Sys 1112140I0089 505005\CZC BkYBOLL BQCAP\P&YROLL 16 81.00 Total Temporary Employees _______ __ _____ 9l.00 421100 Health Insurance 12.06.I1 Journal 111219I55355 009816 DEC HEALTH I08UD&HCE\ClC HEALTH INS 329.82 Total Health Insurance ------------ ------------ 329.83 42I200 Dental Insurance 12.06.I1 Journal 111219I55355 009815 DEC DENTAL I08UR&0CR\CIC DENTAL I08 19.32 Total Dental Insurance ------ —''----- 19.32 421300 Life Insurance 12.14.11 New Vouch 111215030050 06779944 Cheok:780922\MADI8O0 NATIONAL LIFE 7.53 Total WE! Insurance ------------ ------------ 7.53 422400 Disability Insurance 12.14.I1 New Vouch 111215030050 06780044 Cheok:700922�MXDI800 NATIONAL LIFE 13.68 Total Disability Insurance ------------ ------------ 13.68 422100 FICA 12.02.11 Old Sys 12I130020080 12020599\FICA\CITY CONTRIBUTION 96.16 12.I6.11 Old Sys I11214010009 12160509\FICA\CITY CONTRIBUTION 103.12 l2'30'11 Old Sys 1I1229010008 12300559\FZQ\CITY CONTRIBUTION I00.61 Total FICA _______ _________ 399.89 ��TD! 01,12.12 11/44/I5 Method: 4 o1n2/2o12 Iowa City General Ledger System Expenditures Detail FY 2012 Detail Reporting For the period I2.01.11 t0 l2.31.1l Page 11of23 Trans Date Trans Type Reoort# G0uroo Description Debit Credit ----------- 7600 Airport (CONTINUED) ---------- ------------ -------- ---------------------------------- -------- ---- ------------ 560I00 Airport Operations (CONTINUED) 423I00 IYER8 I2.02.II Old 8vu 1111300I0009 12020599\ZPE8S\CIIY CONTRIBUTION I06.14 I2.16.11 Old Sys 11I214010009 I2I60599\IDDBQ\CZTY CONTRIBUTION 113.48 12.30.11 Old Sys 111229010008 12300599\IPERS\CIIY CONTRIBUTION I06.14 ------------ ---- ------- Total HERS 335.76 435060 Legal Publications 12.21.11 New Vouch 111222030049 06780459 Checb�701210\I0WA CITY PRESS CITIZE I3.78 _____________ Total Lecal Publications 13M ~ 438010 Sormwater Utility Cbazqao 12.21.11 Journal 130I04I73721 009826 Total 8tormmaCez Utility Charges 438030 EIemtrioity I2.21.I1 New Vouch 12.2I.11 New Vouch I%.]I.lI New Vouch 12,21.11 New Vouch Total Electricity 438070 Heating Fuel/Gas 12.21.11 New Vouch I2.21.1I New Vouch 12.2'1,11 New Vouch Total Reat' Fuel/Gas 40080 Sewer Utility Cbazom 12.2I.11 Journal I2.3I.11 Journal I2.2I.I1 Journal 12.21.11 journal 057-085'03\ I%.2l.lI Dill D 789.I1 ------------ ?8g`11 111222030049 06780474 Cheok:70I196 FNEBOY\ELE 111222030049 06780596 Cheok�70I106 \MIDAMERICAN ENERGY\ELE 111222030049 06780598 Chect:,70l106\MID&NERIC&N ENRDQY\RLE 11122203CO49 06780599 Check.-701195\MIDAMERICAN ENRRGY�ELF 11I22203O049 06780506 Cbeck-.701185\mID&HDRICAN ENER0Y\QA8 111222030049 06780596 Cboch�701196\MIDANDDICAN 0NERQY\QDB I11322030049 06780597 Check:701I96\MID&NEDIC&N D0ERGY\GAS 12010417372I 009826 OS7'lI5-OU\SUWED\l2.2I.lI Bill Data 120I04I73721 009826 057-117'00\Rnwn» l2.2l.Il Bill Date 220104173721 009826 U57'II8-UJ\8EWDD\l2.21.1I Dill Date 120104173721 009826 057'130-00\8DWER\I2.2I.I1 Bill Date 165.39 797,40 68.6] 2l4.93 ------------ 1246.35 42.26 46D.]4 161.80 ------------ 654.40 44.06 26.13 12,14 22.3I 7RID: 01.12.12 13;44:15 Method, 4 o1n2/2o12 Iowa City Qwoozal Ledger System Expenditures DoC«iI FY 2012 Detail Reporting For the period 12.01.11 to 12.31.11 Page 12 of 23 paue! I Tran Dote Trans Type Depoxt# source Description Debit Credit -----' ----- ------ ---- -----------------' ------ ------ 7600 Airport (C0NTINDED� 560I00 Airport Operations (CONTINUED) 438080 Sewer Utility Charge 'CONTINUED) Iot�l Sewer Utility Charge ____________ 94.64 438090 Water Utility Charge 162.31.11 Journal 120I04I73721 009826 057'095-03\W&TEk\12.3I.1I Bill Date 7.61 12.2I.I1 Journal 120104173721 009826 057-115-00 I2?1.I1 Bill Date 43.38 12.21.11 Journal 120104173721 009826 057-I1?-00\RATER 12.3I.1I Bill Date 12.39 12.21.I1 Journal 120104I73721 009836 057-I18'03 K I2.21.I1 DiII Date 9.40 12.2I.11 Journal 120104173721 009826 057-I20'00\WATDR\12.21.I1 Bill Date 17.02 Total WaC8r Utility [harce ---__ --- 89.80 438100 B8fuoo Collection Charges 1L07.II New Vouch III208030I26 06779278 Chmok:700574 DISPOSAL SYSTEMS I 28.08 12.07.11 New V0oCb I11208030126 06779279 Cbenb�700574\ABC DISPOSAL 8Y8TRM@ I 69.00 lotul Refuse Collection Charges ____________ 97.00 438120 Long Distance Service I2.O4.I1 Ph Lon Dot 120104II3046 000I2019 DEC LONG DI8T CHQDD 3.57 Total Long Distance Service ____________ 3.57 442010 Other Building Repair & Maintenance 8or 12.I4.1I New Vouch 1II315030050 06779544 Cheok-700909\JDT AIR INC I0W\CL.P1A0I 500.00 12.I4.I1 New Vouch 11121500050 06779574 Cbeok,-,700935\0VER8EAD DOOR COMPANY 348.75 TnLuI Other Building Repair & Maintenance 3azvi ______ ____ ____ _______ 848.75 442020 Structure Repair 8 Maintenance Services 12.I4.1I New Vouch I1I215030050 06779492 Chenk-,700916\LIF8 TIME PENCE CO INC 795.00 Total Structure Repair & Maintenance Services ________ __________ 795.00 442030 Heating Equipment Repair & Maintenance 12.2I.11 New Vouch 111222030049 06780376 Cheok:701180\LAREW 0JPER COMPANY LL 366.00 Total Heating Equipment Repair & Maintenance Se _______ _________ 366.00 TRID; 01.I2.I2 13�44:15 Method: A o1n2/2o12 Iowa City General Ledger System Rxnend1tnzea Detail FY 2012 Detail Reporting For the period 12.0I.II to 12.31.11 Trans Page 13 of 23 Page: 4 Date Trans Type Beoort# Source Description Debit Credit ----------- ---------- ------------ -------- ______________________________ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 442060 Electrical G Plumbing Repair 6 Naintoua', 12.07.11 New Vouch 11130800126 06779172 CheCb�700579\ADVANCQD ELECTRICAL GE 907.65 Total Electrical & Plumbing Repair & Madotooauc 442070 Bldg Bost Control Services 12.14.11 Now Vouch 11I215030050 06779789 Cbeok-.700893\B&WKEYB PEST CONTROL l Total Bldg Peat Control Services 445080 8uon and Ice Removal 12.14.I1 New Vouch 111215030050 06779543 Cheob;700909\JET AIR INC IOW\MAINT Iot.aI Snow and Ioo Removal 446100 City Attorney Chargeback 12,31.1I Journal ____________ 907.65 33.95 ------------ 33,95 4500.00 ------------ 4500.00 I2U104lY372lO098l7 Oct-Dee CityAttymq\interdepartmen8O4.S2 ____________ Total Citv 8ttoruev Charqebaok 884.52 446140 ITS-Computer^ _~~Replacement ok 12.01.11 IT Denl 111222144720 000I3025 DEC ITS BEPL C8Q8CK Iotal ITS-Computer Replacement Cbarneback 44.6160 ITS-Network/Internet Cbuzgebuok 12.0I.II IT Int/Nwk 11I221133507 000I303I DEC ITS 0DTWUINTDNQT Total ITS-Network/Internet Chargebaok 446200 Photocopying Chargebaok 12.01`11 Copier Cbo I11229135858 0120004I NOV PHOTOCOPY CHARGE ","otaI Photocopying Chargeback 44.8300 Phone Equipment/Li-ne Cbazgebaok 12.04.11 Ph EguipmC 120104113046 000120I8 DEC BHON EQUIP CE0BK Total Phone Equipment/Line Cbargeback 101.42 ------------ ------------ 101,42 60.00 ------------ 60.O0 %4.00 ------------ 24.00 9%.S0 ____________ 92.50 T �ID; 0Ll2.12 I3;44;15 Method; A o1n2/2o12 Iowa City General Ledger System Expenditures Detail FY 20I7 Detail Reporting For the period 12.01-11 to I2.31.I1 Page 14 of 23 Pap: 5 ° Trans Date Trans Type Reoort# Source Description Dobit Credit -----' ----- ------ ---- --- --------------- ------ ------ 7600 Airport (CONTINUED) 560I00 Airport Operations (CONTINUED) 446320 Mail Chargeback 13.01.I1 Mail I11208I13648 0I200045 NOV POSTAL CHARGES 47.47 Total Mail Chargeback 446350 City Vehicle Replacement Cbazoeback I3.31.11 Q0 Repl 120I05145515 0O012006 DEC REPLACEMENT COST Total City Vehicle Replacement Chargeback 446370 PoeI Chazgaback 12'31.11 B0 Div 130105I45515 00012008 DEC DIVISION FUEL Total Fuel Charqeback 446380 Vehicle Repair & Maintenance Chargeback I2.31.II DO Div I20105145515 000I2008 DEC DIVISION SERVICE Total Vehicle Repair & Maintenance ChargabaCk 44906D Dues & Memberships 12.14.11 New Vouch 111215030050 06779636 Check:700850\AMEIRICAN ASSOCIATION 0 Total Dues 6 s 449360 Interest Rxoeooe 1.2.31.11 Journal 12.31.II Journal 12.31I1 Journal 12.31.11 Journal Tot,aI Interest Expense 4520I0 Office Supplies I2.21.11 P'Cazd I2.21.1I D'Card Total Office Supplies 1112I9155355 809813 Corp Hangar Loan Int\Deo Intarfuod II1219155355 009813 DI Hangar Loan Int o Intazfnud Lm 11I219155355 009813 8D T'Hunr .1jmao Iut o Iutorfuod Lo 1113I8155355 809813 8W T-Hoor Loan Int\Deo Iotarfuud Lo ------------ 4?.47 1363.72 ____________ 1363.72 240.01 ------------ 240.01 1049.58 ------------ 1049.58 275,00 ------------ 275.00 1770.03 1254,57 930.86 867.64 ____________ 482].10 I20I05093951 I8300487 STAPLES C0NTRA00710004\mIC8AEL THAD 158.63 130I0509395I I8300488 STAPLES 00I06260\MIC8ADL THAR 62.98 ____________ 2%l.61 TRID: 01,12.12 13:44:15 Method; 4 01/12/2012 Iowa City General Ledger Systeia EXpenditures Detail FY 2012 Detail Reporting For the period 12.01.11 to 12.31.11 Page 15 of 23 Page: 6 Trans Date Trans Type Reports Source Description Debit Credit ----------- 7600 Airport (CONTINUED) ---------- ------------ -------- -------------------------------- --------- ------------ 560100 Airport Operations (CONTINUED) 452030 Minor Office Equipment/Furniture 12.21.11 P•Card 120105093951 18300489 STAPL89222029668000\MICHAEL THARP 129.98 Total Minor Office Equipment/Furniture ------------ -- --------- 129.98 455120 Mist Computer Hardware 12,21,11 P-Card 120105093951 18300214 BUY.COM\GARY COHN 359.00 12.21-11 P-Card 120105093951 18300490 STAPLES 00106260\MICHAEL THAR 39.99 Total Misc Computer Hardware ------------ ------------ 398.99 468050 Sand 12.14.11 New Vouch 111215030050 06779530 Check:700947\5 & G MATERIALS\SAND 26.55 Total Sand ------------ ------------ 26.55 469200 Tools 12,14,11 New Vouch 111215030050 06779545 Check:700909\JET AIR INC 10W NOV MA ------------ 3.50 ------------ Total Tools 3.50 469320 Miscellaneous Supplies 12,14.11 New Vouch 111215030050 06779545 Check:700909\JET AIR INC IOW\NOV KA 58,95 ------------ ------------ Total Miscellaneous Supplies 58,95 473010 Contracted Improvements 12,21.11 New Vouch 111222030049 06780450 Check:701183 KRUSE TREE SERVICE INC 17100,00 Total Contracted IMDrovements 17100.00 490150 Operating Subsidy 12.31.11 Journal Total Operating Subsidy 490190 Interfund Loan 12.31-11 Journal 12.31. ,11 journal 12,31,11 Journal 111219155355 009609 Airport 1A ED Coord�Dec Budgeted 0 111219155355 009813 Corp Hangar Loan Prn�Dec Interfund 111219155355 O04813 U1 Hangar Loan Princ\Dec Interfund 111219155355 009813 SE T-Hngr Loan Princ\Dec Interfund 959.75 ------------ w ----------- 959.75 1229.97 1136.95 727.54 liR.TD1. 01.12.12 13-144:15 Method; 4 01/12/2012 .owa City General Ledger gystem Expendittreg Detail FY 2012 Detail Reporting For the period 12.01.11 to 12,31,11 Page 16 of 23 Page'. 7 Trans Date Trans Type Reput# Source Description Debit Credit ----------- ---------- ------------ -------- ---------- ------ ----- ------------ --- --------- 79.00 Airport (CONTINUED) V. 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) 12.3 1.11 Journal 111219155355 009813 SW T-Hngr Loan Princ Dec Interfund 562,36 Total Inter and Loan Total Airport Operations ------------ ------------ 3656.82 ------------ ------------ 46990.07 TRID; 01,12.12 13:44:15 Methoda. 4 01/12/2012 iowa City General Ledger System Expenditures Detail FY 2012 Detail Reporting For the period 12,01.11 to 12.31.11 Page 17 of 23 pager 8 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ -------- ----------------------------------- ------------ ------------ 7600 Airport NCO NTINUED) 560100 Airport Operations (CONTINUED) 490196 *Interfund Loan (CONTINUED) ------------ ------------ Total Airport 46990.07 TRID; 01;12,12 13-4415 Method: 4 01/12/2012 iaow C1 'ty General Ledger System Expenditures Detail FY 2012 Detail Reporting For the period 12,01.11 to 12-31.11 Page 18 of 23 Page: 9 TraBs Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ -------- ----------------------------------- ------------ ------------ 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Inter and Loan (CONTINUED) - - - - - - - - - - - - - - - - - - - - - - - - GRAND TJOTIAL 4 990.07 TRID;, 01.12.12 13:44:27 Method; 4 01/12/2012 Tow a My General Ledger System Revenues Detail FY 2012 Detail Reporting For the period 12,01.11 to 12.31.11 Page 19 of 23 Page: 1 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ -------- ----------------------------- ------------ --------- 7600 Airport 560100 Airport Operations 381100 Interest on Investments 12,31.11 Allocation 120109150054 Dec interest allocation 5.,26 Total. Interest nterest on Investments ------------ ------------ 5,26 382100 'Land Rental 12.06,11 Payment 111206093530 00020655 2-4\TOYOTA OF IOWA CITY PAYKEXT 7399.00 12,13.11 Payment 111213093316 00020858 1-25\BELL LARRY & SANDRA\PAYMENT 3010,00 12.14.11 Misc Pymt 111222132957 70-9\ARMY RESERVE\AIRPORT LEASE ---------- 701.07 Total Land Rental 8400.07 382200 Building/Room Rental 12.02.11 Payment 111202092113 60020836 2-4\DOWNES GREG\DEC 11\ HANGAR #51 172.00 12.02.11 Payment 111202111417 00020365 9-2\YEAGER DAN\OCT 11 HANGAR #'7 3.00 12.02.1-1 Payment, 111202111417 GOU020559 9-1\YEAGER DAN\NOV 11\HANGAR #17 151,00 1.2.05 ,1.1. Payment 111205092303 00020777 2-5\PITTON MIKE�DEC 11 HANGAR #26 151.00 1205.11 Payment 111205092303 00020781 2-3\8CHNELL TOM\DEC 11\HANGAR #62 178.00 12.,05.11 Payment 111205092303 00020793 2-4\8CHMEISER RUSS\DBC 11\HANGAR # 209.00 12.0-5.11 Payment 111205092303 00020832 2 -1\STEARMAN�DEC 11\HANGAR #47 172,00 12.06.11 Payment 111206093530 00020756 1 -23 FULLER SCOTT\DBC 11\HANGAR #3 172,00 12.06.11 Payment 111206093530 00020758 1-20�HEADINGTON MERLE & BEVERLY\DE 151,00 12.06.11 Payment 111206093530 00020778 1-13\DEMARIA JOSEPH\DEC ll\HANGkR 151,00 Payment 1112C6093530 00020828 1 -22�POWERS ROBERT\DEC 11�HANGAR # 144.00 1. 30741,.1,. Payment 111207092053 00020757 2-12�ANDERSEN JASON�DEC 11\HANGAR 144300 12.07.1]. Payment 111207092053 00020757 2 -12 ANDERSEN JASON\DEC 11\HANGAR 144,00 12.07.11 Payment 111207092053 00020782 2-11\BULLERS JONATHAN\DEC 11\HANGA 12.07.11 Payment 111207092053 00020788 2-9 MASCARI RICK�DBC 11\HANGAR #30 151.00 12.07.11 Payment 111207092053 00020789 1-11\BUTLER JOHN\DEC 11\HANGAR #36 172.00 12.07.1 - I Payment 111207092053 00020789 TLER JOHN\DEC 11\HANGAR #37 1-11\BUi 172.,00 12.,07.11 Paymeint 111207092053 00020810 1-10\GERR FRED\DEC 1.1. HANGAR #116 151-00 12,08.11 Payment 111208091056 00020790 1-12\HARTWIG RANDY�DEC 11\HANGAR # 172r00 1.2,08,11 Payment 111208091056 00020829 1-3�OPERATOR PERF ORMANCE LAB\DK. 11 4038.00 12.0L11 Payment 111208091056 00020829 1-3�OPERATOR PERFORMANCE LAB�DEC 11 615.00 12.09.11 Payment 111209091525 00020780 2-5�RA1EY CHARLES\DEC 11\HANGAR #1 144.00 TRID: 01,,12.12 13;44:28 WWI- 4 01/12/2012 Iowa City General Ledger System Revenues Detail FY 2012 Detail Reporting For the period 12,01-11 to 12-31.11 Page 20 of 23 Page; 2 Trans Date ----------- Trans Type --- Report# ------------ Source Description Debit ----------------------------------- ------------ Credit 7600 Airport 'CONTINUED) ----- -------- ------------ 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 12112.11 Payment 111212094607 00020751 2-9\ODGAARD JACOB\DEC 14\HANGAR #2 151A0 12.13.11 Payment 111213093316 00020766 1-9\RUYLE JOHN\DEC 11\HANGAR #33 358-00 12.13.11 Payment 111213093316 00020802 1-24\ZUBROD ROY\DEC 11 HANGAR #20 151.00 12.13,11 Payment 111213093316 00020825 1-21\ROOF KEITH\DEC 11\HANGAR #42 172.,00 12.14.11 Payment 111214091649 00020607 2-17\SAPPHIRE VISTAS LLC�NOV 11\HAN 15.1.0101, 12.114.11 Payment 111214091649 00020826 2-11\JET AIR INC\DEC 11\BUILDINGS D 3K"6.00 12.14.11 Payment 111214091649 00020834 2-17�SAPPHIRE VISTAS LLCjDFC 11 HAN 1E1. 00 12,14.11 Payment 111214091649 00020840 2-11\JET AIR\DEC 11\HANGAR #60 178.00 12.14.1- Payment 111214091649 00020840 2 -11\JET AIR\DEC 11\HANGAR #59 178,00 121.16.11 Payment 111216085735 00020371 2-6�FULL JERRY\OCT 11\HANGAR #45 2,04.0rv- A-2.16.11 Payment 111216085735 00020807 1-16\AEROHAWKS\DEC 11\HANGAR #19 151.00 12.16.11 Payment 111216094838 00020749 89-1\MILLER RICHARD\DEC 11\HANGAR 172,00 12116.11 Payment 111216094838 00020764 89-4\HINCKLEY HARRY\DEC 11\HANGAR 404100 12,16.11 Payment 111216094838 00020764 89-4�HINCKLZY HARRY\DEC 11\HANGAR 144.00 12.16.11 Payment 111216094838 00020767 89-5\VOS JEREMY\DEC 11\HARNGAR #64 196.00 12 16.11 Payment 111216094838 00020794 89-6\PISHBAUGH JUSTIN\DEC 11\HANGA 178.00 12,16.11 Payment 111216094838 00020797 89-7\PATTSCHULL RICHARD\DEC 11\HAN 234,00 12.16.11 Payment 111216094838 00020799 89-8\ALLENDER PATRICK\DEC !,.I\HANGA 172.00 12.16.11 Payment 111216094838 00020813 89-10\EDMONDS TERRY\DEC IMHARGAR 320.00 12.16.11 Payment 111216094838 00020822 89-14\SQUADRONS UP\DEC 11\RANGAR #5 172.00 12116,11 Payment 1.144.216094838 00020824 89-15 GURNETT DON\DEC 11\HANGAR #3 310.00 iz.16111 Payment 111216094838 00020833 89-16\8INGLETARY ROBERMEC 11\HAN 144,00 12. ,L6, n 'L Payment 111216094838 00020841 89-18 SWANSON NAOMI\DEC 11\HANGER 144.00 1216.11 Payment 111216094838 00020862 89-23\COHN GARY\DEC 11\RANGAR #22 1651-00 12,16,11 Payment 11121609483 00020865 89-25\MEADE JAMES N�DEC 11\HANGAR 172.00 12,20.1.1 Payment 111220091708 00020784 2-6\BULGARELLI DAVID\DEC 11\HANGAR 151.00 12.22,11 Payment 111222091424 00020867 2-3\ROHR BRIAN\DEC 11\HANGAR #27 151.00 12.27 ,11. Payment 111228074349 0001910 9-1\GRRR FRED\MAY il\HANGAR #16 148.00 12 29.11 Payment 111229092606 00020783 1-22�HALL ROERRT\DEC 11\HANGAR #6 144.00 12 29.11 Payment 111229052606 00020783 1-22\HALL ROBERT\DEC 11�RANGAR #12 151.00 12.29.1 Payment 111229092606 00021023 1-1 WILLIAMS KEITH & JEAN\JAN 12\ 151.00 12,291.11 Payment 111229092606 00021044 1-19\BRIIMLEY JAMES JAN 12\HANGAR # 151.00 ��ZD� 01.I2.12 13:44:28 Method/ 4 o1n2/2o12 Iowa City General Ledger System Revenues Detail FY 2012 Detail Dpportinq For the period 12.0I.1I C0 12.31.11 Page 21 of 23 Pap: ] Trans Date Trans Type ReoozL# Source Description Debit Credit ----------- 7600 Airport 'CONTINUED) ---------- ------------ -------- ----------------------------------- ------------ ------------ 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) I2.29.1I Payment 111229092606 00021054 1'28 H&LL ROBERT\JA0 I2\HANGAD #6 I44.00 12.29.I1 Payment II1229093606 00821064 l-20 BALL DDBDRT\JAN 12\H&NQAR #12 151.00 I2.29.II Payment 1I1229092606 00021062 I'14\N6226M INC\JAN 12\HANgAR #49 I72.00 I2.3D.11 Payment 11I230085553 00021022 2 25\FIDLQ HOW&DD\JA0 12\HANGAB #5 244.0UO 12.30.I1 Payment III230085553 00021028 2'8\8Z&DI0QTON MEBL8 6 BEVERLY\J&N I5I.00 12.30.11 Payment 111230085553 00031I41 2'11\P0LA8KI MIC8&EL\J&N I2\8A0Q&R 151.00 Total Build' /Room Rental 384200 Vendino Machine Comm 12.2I.11 MiDC Pvmt I1122I892437 Total Vending Machine Comm 384900 Other Commissions 12.16.I1 MiGc Pvmt I112I0085741 Total Other Commissions j93120 General Levy ____________ 18545.00 2'9\TD8 AMERICAN BOTTLING V 7.20 ____________ ?.%O 1'20 AVIATION FDEL8\FDRL CO 1533.30 ------ ------' l5]l]0 12,31.11 Journal 111219155355 009809 Ptax to kirport\Dec Budgeted Operat Total General Levy Total Airport Operations 8333.3] ____________ 83]3.33 ______ _______ 36824.16 TRID; 01,12,12 13:44428 Method: 4 01/12/2012 Iowa City General Ledger System Revenues Detail FY 2012 Detail Reporting For the period 12,,01.11 to 2, 31,x,1 Page 22 of 23 page! 4 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ---------- -------------------------------- ------------ ------------ JV00' Airport �CONTINUED) I& %, 560100 Airport Operations (CONTINUED) ------------ --------- ­ Total Airport 36824.16 7RID: 01.I2.12 I3:44:28 HetbVd: 4 o1n2/2o12 Iowa City General Ledger System Revenues Detail FY 2012 Detail Reporting For the mi0d 12.01.1I to 12.31.11 Page 23 of 23 Poam: 5 Trans DuCo Trans Tvno Renort# Source Description Debit Credit ----------- ---------- ------------ -------- ----------------------------------- ------------ ------------ 7600 Air�urt (CONTINUED) 560100 Airport Ooamtimm (CONTINUED', ____________ +�� GRAND TOTAL 36824.16