Loading...
HomeMy WebLinkAbout01-08-2009 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JANUARY 8, 2009 - 5:45P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: December 11, 2008 3. Public Discussion - Items not on the agenda 4. Items for Discussion/Action: a. Aviation Commerce Park b. University of Iowa Aircare Facility c. Dane/Larson Land Sale Request d. Airport Safety - Traffic Pattern Operations e. FAA/IDOT Projects -AECOM — David Hughes i. Runway 7/25 ii. South Aviation Development Study iii. 2008 Pavement Rehab (North Taxilanes) iv. Obstruction Mitigation v. Building H — University of Iowa Hangar Expansion 1. Consider a resolution approving plans, specifications, form of contract, and estimate on cost for the Building H — University of Iowa Hangar Expansion vi. Corporate Hangar L f. Airport "Operations": Strategic Plan -Implementation; Budget; Management i. 2008 Annual Report ii. Maintenance Agreement with Jet Air g. Airport Commission Terms h. FBO Staff Report i. Subcommittees' Reports j. Commission Members' Reports k. Staff Report 5. Set next regular meeting for February 12, 2009 at 5:45 p.m. 6. Adjourn Iowa City Airport Commission December 11, 2008 Page 2 of 6 Agreement to be in place to hold the ground that the UI is interested in, until a closing or approval can be secured. Slaughter also noted that she is having a meeting next week with an interested party, someone whom she has had several meetings with and hopes to bring some further news soon. She added that a meeting with the City recently helped to answer some of this parry's questions, and she hopes they can move forward with a design process. Randy Miller also responded to Members' questions regarding this interested party. Rettig asked for some clarification on how the UI's Aircare facility is budgeted, to which Staley responded. A brief discussion ensued regarding leasing versus purchase, and Staley stated that they would be interested in purchasing, as leasing would not be advantageous in this case. Members continued to discuss how this facility would be laid out. i. Consider Resolution #A08-34 Approving Amendment #9 to the Listing Agreement with Iowa Realty - Farris reiterated what this process is, stating that the listing agreement is with the City but that it is up to the Airport Commission to decide if they want to continue the listing. Dulek clarified what this three -party agreement entails. She noted that whatever is decided tonight would go before the City Council on Tuesday. Horan moved to consider Resolution #A08-34 approving amendment #9 to the listing agreement with Iowa Realty; seconded by Hartwig. Carried 5-0. b. Dane/Larson Land Sale Request— Dave Larson noted that the person they needed to contact at the FAA is out of the office until Monday, at which time they will try to contact him again. He will let the Commission know what he finds out. c. University of Iowa Aircare Facility — moved to item A. d. Airport Safety — Traffic Pattern Operations — Tharp noted that they have had several months of discussion on this, as well as a public hearing, and also several email comments regarding the proposed changes. Tharp stated that it appears they should change the traffic patterns, and he recommended they vote on this tonight so they can begin the process that will be necessary over the next several months. Hartwig noted that they could do this next month, as well, and Tharp agreed. Rettig asked for some clarification on the change, and Tharp responded. He noted the various publication dates where this information would be released. Tharp noted that they will need to publicize this change as much as possible, and he briefly shared some of the mediums they will do this through. Rettig stated that she believes they should move ahead with this. Hartwig added that he agrees with the issue of having less air traffic over the residential areas. Tharp spoke briefly to some of the expenses they will encounter while making this traffic pattern change. Rettig moved to 2 Iowa City Airport Commission December 11, 2008 Page 3 of 6 adopt a right-hand approach pattern, effective March 12, 2009, on Runways 7-25 and 12-30; seconded by Staley. Carried 5-0. e. Engineering Consultant Selection - Farris noted briefly that basically this is the same agreement they had in the past. Dulek agreed, stating there is not much change and that each project will be done by a separate agreement. i. Consider Resolution #A08-35 Approving Master Engineering Services Agreement with Earth Tecb/AECOM - Staley moved to consider Resolution #A08-35 approving Master Engineering Services Agreement with Earth Tech/AECOM; seconded by Horan. Carried 5-0. £ FAA/IDOT Projects —AECOM —David Hughes i. Runway 7/25 — Hughes noted that with the winter weather the construction projects are fairly quiet. They are working with contractors on closing out projects so they can get closing documentation to the FAA. 1. Consider Resolution #A08-35 Approving Task Order #1 for Runway 7-25 and 12-30 Rehabilitation Project - Hughes noted that this is the project going through independent review, and that they expect the FAA's comments yet this week. Hartwig moved to consider Resolution #A08-35 approving Task Order #1 for Runway 7-25 and 12-30 rehabilitation project; seconded by Rettig. Carried 5-0. ii. South Aviation Development Study — Hughes stated that they hope to get this out yet this month, and are hoping to be able to get the Airport layout plan for the runway out, as well. He added that this has become a fairly extensive document now with all of the changes. The topic of a grass runway was briefly touched on, as well, with Hughes stating that the FAA is not in favor of a grass runway in Iowa City. Rettig voiced her concerns about the Airport getting boxed in by commercial development. iii. 2008 Pavement Rehab (North Taxilanes) — Hughes stated that they have one soft spot they need to repair, but will wait until spring to do this. iv. Obstruction Mitigation — Hughes stated that Mid American has done final billing on this, but he has not seen anything yet from Mediacom. V. Building H — University of Iowa Hangar Expansion — Hughes noted that bids have dropped back into reasonable rates again, so they should have better bids when they start the process after the first of the year. vi. Corporate Hangar L — Farris stated that they have had a couple discussions about this, but still nothing solid. Basically, they have been pursuing financing, and until something happens there, not Iowa City Airport Commission December 11, 2008 Page 4 of 6 much else can occur. He noted that CIP discussions begin with the City in January. The discussion turned to the economic stimulus that is forthcoming, and how this might play out in aviation funding. vii. FY2010 Federal Airport Improvement Program Application — Hughes stated that the application has been completed and is now ready for forwarding to the State and the FAA. Staley moved to approve the FY2010 Federal Airport Improvement Program Application; seconded by Horan. Carried 5-0. g. Airport "Operations"; Strategic Plan -Implementation; Budget; Management — Rettig asked for clarification on the second page, under Income, Other Misc. Revenue, reimbursement of expenses. She noted that it is a reimbursement from MidAmencan Energy. Tharp stated that he is not sure what this is, actually, but that he will check with Kevin O'Malley on this item. Rettig then questioned page three, under Expenses, sewer water and refuse - she asked if there is a leak or if they have been double -billed. Tharp stated that he would look into this, as well. Below this, under Building Repair and Maintenance Services, Rettig asked about the Mechanical Services Inc. charge of $1655.95 and why this amount is not on the front page. Tharp noted that this was the lift station charge, from several months back, and it just now was processed. Rettig also asked about the Dan's Overhead Door Company charges, to which Tharp responded. i. 2008 Annual Report - Farris talked briefly about this, noting that he contacted ITC about having a small review about their interaction with the Airport, to give the Annual Report a little more human interest to it. Rettig asked by what date they need to get additions or changes to Tharp for this. Tharp stated that by Christmas would be best, as he wants to have a final draft for review at the January meeting. ii. Maintenance Agreement with Jet Air - Tharp noted that he would recommend a special meeting next week to do final approval on this, in order to give Members time to review it. Hartwig noted that he would be fine with moving ahead, if Tharp wants to give them the highlights of the agreement. Tharp noted that the highlights are essentially that Jet Air would be performing the duties that Jerry used to perform, such as snow removal, mowing, light maintenance issues, light bulb replacement, and hangar door issues. The Airport would be responsible for any supplies needed for repairs and that type of thing. Farris noted that they have been having discussions with Jet Air, and if they move forward, the current agreement with Jet Air would be superseded by this agreement. Iowa City Airport Commission December 11, 2008 Page 5 of 6 Jet Air joined the discussion, stating that they would be interested in taking over items such as cleaning of the facilities, although he noted that he does not want to take the cleaning away from someone who may need a job. Farris then reviewed the agreement, pointing out some of the various issues involved with the cleaning duties. Discussion continued on how things like carpet cleaning and floor cleaning will be handled. Rettig asked if this is a one- or two-year agreement, and it was stated that it should be a one-year. Dulek reminded the Members that the snow removal contract ends December 31, as well. Rettig asked for some clarification on the agreement, questioning some of the expenses along the way. She questioned the use of temporary employees to help with some brush clean up and other miscellaneous items. Members continued to discuss what tasks Jet Air would take care of and what they need to take care of from City resources. Rettig suggested that they meet with the City Manager and Public Works to see what help they can get, so they know upfront how to budget for these types of things. Staley suggested they contact Jerry and see what he would suggest as far as contacts within the City. After some further discussion, it was decided to cover the snow agreement portion for another month while more information is gathered on this agreement. Rettig moved to authorize the Chair to sign a one -month extension of the temporary snow agreement with Jet Air; seconded by Horan. Carried 5-0. Farris stated that he will get a draft of this agreement to Members as soon as possible so they can review it. h. FBO Staff Report —Jet Air stated they have begun snow plowing already this season, and questioned if there was any sand available for the runway. Farris stated that he would add this to his list of items to ask the City Manager and Public Works about. i. Subcommittees' Reports —None. Commission Members' Reports — Hartwig shared a story about a biplane that was recently at the Airport. He also noted a bulletin about ground school, and Timmons responded to this. Horan stated that he received a compliment about how nice the Airport looks with the United hangar gone. Farris stated that he has heard this from several people, as well. k. Staff Report —None. SET NEXT REGULAR MEETING FOR: January 8, 2009 at 5:45 P.M. ADJOURN: Iowa City Airport Commission December 11, 2008 Page 6 of 6 Airport Commission ATTENDANCE RECORD YEAR 2008 (Meeting Dates) NAME TERM EXP. 1/10 2/14 3/6 3/13 4/10 428 518 522 6/9 6113 7/10 724 Randy Hartwig 3/l/09 X X X X X X X X O/E X X Greg Farris 3/l/13 X X X X X X X X X X X John Staley 3/l/10 X X X X X X X O/E O/E X X Howard Horan 3/1/14 X X — X X X X X X X X Janette Rettig 3/1/12 X X X X X X X O/E X X X (CONT.) TERM. EXP. 8/14 9/11 10/1 10/9 10/30 11/13 1120 12111 Randy Hartwig 3/l/09 X X X X X X X X Greg Farris 3/l/13 O/E X X X X X X X John Staley 3/l/10 X X X X X X X X Howard Horan 3/l/14 X X X X X X X X Janette Rettig 3/l/12 X X X O/E X X X X KEY: X = Present O = Absent O/E = Absent/Excused NM = No meeting — = Not a Member 0 Prepared by: Susan Dulek, Ass't. City Attorney, 410 E. Washington St.,. Iowa City, IA 52246 (319) 356-5030 RESOLUTION NO. RESOLUTION APPROVING PLANS, SPECIFICATIONS, FORM OF CONTRACT, AND ESTIMATE ON COST FOR THE BUILDING H - UNIVERSITY OF IOWA HANGAR EXPANSION 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; and WHEREAS, the above -named project went out for bid in June 2008 and the Commission rejected all bids on July 10, 2008 because they were too high; and WHEREAS, it is in the best interest of the airport to re -bid the project. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORTCOMNIISSION THAT: The plans, specifications, form of contract and estimate of cost for the above -named project are hereby approved with the following two exceptions: A. The following language is added to the Supplementary Instructions to Bidders and to the Supplementary Conditions respectively: To the extent that there is a conflict between the ALA Instructions to Bidders (AIA Document A701-1997) and Iowa Code chapters 26 and 573, Iowa law shall apply. To the extent that there is a conflict between the AIA General Conditions of the Contract for Construction (AIA Document A201-1997) and Iowa Code chapters 26 and 573, Iowa law shall apply. B. Pages ABA and AB-2 are amended such that bids will be received before 2:00 p.m. on February 5, 2009, that bids shall be opened at 2:00 p.m. on February 5, 2009, and that there shall be no pre -bid conference. 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 5`s day of February, 2009, 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 5:45pm on the 12th day of February 2009, 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: Ayes Nays 2009. Approved By: City Attorney's Office Absent the Resolution be Farris Hartwig Horan Rettig Staley I\ 111;W al Y The Iowa City Municipal Airport is located approximately 2 miles southwest of downtown Iowa City. The immediate controlling responsibility for the Iowa City Municipal Airport is given to the Iowa City Airport Commission. The Airport Commission consists of five voting members, who are directly responsible for the planning, operation, and budget of the Iowa City Municipal Airport. The Commission works collaboratively with Iowa City elected officials and staff to ensure safe, efficient, and effective use of the airport to support Iowa City and the surrounding area The Iowa City Municipal Airport is one of the busiest general aviation airports in the Iowa with approximately 35,000 flight operations annually. It is currently home to approximately 84 based aircraft located in 59 T-Hangars, and 6 corporate hangars. These aircraft are used for charter flights, corporate activity supporting local business, flight instruction, rental, pleasure, and charity purposes. Additionally, thousands of flights in and out of the airport support important community activities such as the organ transplant program and Air Ambulance flights at The University of Iowa Hospital and Clinics, as well as economic development for the area Local business which also utilize the airport include ITC Midwest, Kum and Go, Family Video, Lear Corporate, among many others Existing airport facilities include 2 runways, the terminal building, a maintenance facility, hangars and aircraft fueling facilities, aircraft parking, tie down apron and vehicle parking area Runway 7-25 serves as the primary runway with a length of 5004 feet. Runway 12-30 serves as a secondary crosswind runway and has a length of 3900 feet. The airport terminal building, built in 1951, includes a pilot's lounge with wireless internet access, a weather briefing room, a lobby, a classroom, vending machines, a meeting room, and administration facilities for airport management and a fixed based operator. The airport has a rotating beacon and lighted wind indicator. The airport is equipped with a remote communications outlet (RCO) and Automated Surface Observation System (ASOS). The airport has been an important element in the Iowa City community since 1918 and in 1944 was placed under the control of the Iowa City Airport Commission by public vote. Since that time the airport has remained under the governance of the Airport Commission with fiscal support from the City of Iowa City. The airport is included in the National Plan of Integrated Airport Systems (NPIAS). The NPIAS identifies the Iowa City Municipal Airport as a general aviation airport. As a designated NPIAS airport, the federal government currently provides funding annually for eligible capital improvement projects at the airport. The State Aviation System Plan identifies the Iowa City Municipal Airport as an Enhanced Service Airport. Enhanced Service airports are classified as airports which serve nearly all general aviation aircraft and are economic and transportation centers for the state. Several businesses and University of Iowa enterprises are stationed at the airport. Jet Air, Inc. is the fixed base operator with 26 employees, offering charter flights, flight instruction, aircraft sales, rental and service, fuel, and sale of aviation related Iowa City Municipal Airport — Annual Report 2008 Page 2 merchandise. Hertz Corporation serves local visitors and the surrounding area with rental cars available directly at the airport. Numerous faculty at the University of Iowa's College of Engineering use the airport for federally funded research on aviation technology and atmospheric weather phenomena. This research is primarily based out of the Operator Performance Laboratory located in building H. AIRPORT VISION STATEMENT "The Iowa City Municipal Airport, through the direction of the Airport Commission, will provide a safe, cost-effective general aviation airport that creates and enriches economic, educational, healthcare, cultural, and recreational opportunities for the greater Iowa City area.,, AIRPORT MISSION STATEMENT "The mission of the Iowa City Municipal Airport is to support the strategic goals of the City of Iowa City and meet the needs of stakeholders." 2008 AIRPORT ACTIVITES The Airport Commission continues to focus on meeting goals it laid out in its 2004 Strategic Plan, some of which will be mentioned in this report The Airport Operations Specialist and Commission Chairperson meet frequently with City department heads to discuss the airports needs and to maintain clear communication channels with other City projects occurring near the airport. In a continuing effort to develop the relationship with the community, numerous community events are held at the airport. Examples include the annual SERTOMA Fly - in pancake breakfast and show held August 24, 2008 which served around 2500 breakfasts in excellent weather conditions. The Iowa City Aerohawks held their annual winter radio controlled aircraft swap meet in January which is one of the largest meets in the Midwest. t J I "D" The Airport Commission and staff continue to maintain an efficient operating budget which provides the necessary services and repairs to support the airport infrastructure. FY2008 saw an operating expense budget $367,000. This is an increase $12,000 over the FY 2007 operations as was due primarily to increased personnel costs. Those costs helped to maintain winter operations through the near record snowfalls experienced in the winter. Revenues for the airport were up significantly due to a change in operation to the farm land rental, and an increase in T-Hangar rents. Airport revenues remained near 2007 Iowa City Municipal Airport — Annual Report 2008 Page 3 levels with final income above the projected values. Actual operations revenues totaled $402,000 which posted approximately $30,000 above projections. General Levy contributions toward operations maintained the $112,000 levels seen in recent years. Grant income remains a critical part of the airport capital improvement program. In FY2008 the airport received over $1,900,000 in grant money which is being used on projects at the airport for various improvements. These grants contribution funds to projects which fund the runway extension, as well as the major maintenance and rehabilitation of airport facilities. AIRPORT PROJECTS Major airport projects are funding with partnerships from either the Federal Aviation Administration, or the Iowa Department of Transportation. Federal grants contribute 95% of the project costs and are typically associated with major pavement rehabilitation and upgrades. State grants fund 70-85% of project costs, and are typically associated with minor pavement and facilities repairs and upgrades. On average for every $1 used as a local match by the airport, the airport is able to generate $20 dollars worth of work. FY2008 saw the completion of 2 major runway pavement projects. The extension of Runway 7-25 saw construction begin October 10, 2005 with a box culvert for Willow Creek. The extended runway was opened October 22, 2008 with a new length of 5004 feet and a new width of 100 feet. Phase 1 of the Existing Pavement rehab is also complete. This 3-phase project will completely reconstruct the existing runway pavements which are over 50 years old. Once complete Runway 12- 30 will be redefined as 3900 feet long and 75 feet wide. Rehabilitation of existing hangar facilities this year consisted of rehabilitation work to the north taxilanes accessing the north block of T-Hangars. This project replaced asphalt in the area that had become a concern to aircraft operations. This completes a phased approach of rehab with the T-hangar pavements. The Airport Viewing Area continues to be a work in progress. Phase 1 was completed with the installation of a covered shelter and walk way, as well as the some picnic tables Iowa City Municipal Airport — Annual Report 2008 Pagel for users to enjoy time outside, watching the aircraft which utilize the airport. Phase 2 will consist of the installation of a viewing tower to allow users better views of airport operations. AVIATION COMMERCE PARK The Airport, with city staff, continues efforts to sell land available in the North Airport Commerce Park. Funds received from the sale of this land are to be used to pay off City incurred debt for airport construction costs, and the costs associated with improvements of that land. A major sale of land too place, which saw nearly one-half the area sold. ITC Midwest occupies what was Lots 2, 3 and 4 as well as their associated oudots. The sales proceeds of $1.6 million reduced the infrastructure loan on area improvements and well as returned commercial land to the taxable land rolls. FUTURE AIRPORT ACTIVITIES/PROJECTS The Iowa City Municipal Airport continues to plan for the future. Utilizing state and federal grants, as well as local improvement money, the Airport continues to refurbish and replace existing facilities. Enhanced Global Positioning System (GPS) approaches are scheduled for Iowa City with the opening of the new runway. These approaches utilize the Wide Area Augmentation System (WAAS) and will benefit the Iowa City Municipal Airport with more precise approaches by aircraft. Pilots using this technology will be able to utilize the airport with lower weather minimums. These schedule publication dates are currently for January 2009. FAA Grant Applications are due annually in December and the airport will continue on its planned rehabilitation schedule by submitting applications for funds for phase 2 of the Iowa City Municipal Airport — Annual Report 2008 Page 5 existing runway rehabilitation plans. This would replace the remaining portion of the Runway 7-25 pavement, and section of Runway 12-30 which is northwest of 7-25. These pavements are over 50 years old and will be completely resurfaced. The Iowa City Airport Commission has received several comments from the public regarding space constraints. The Airport is examining different ways to ease the space constraints. Shortages are currently being felt in large aircraft storage, equipment storage, and small to mid -size aircraft storage. An economic study focusing on the potential development of the south area of the airport has been presented to various city staff members and final revisions have been submitted to FAA for concurrence in planning. Final approvals are expected in February 2008. The Airport Commission will continue to maintain and strengthen its relationship with City Council, staff, and the surrounding community by keeping a focus on the mutual goals for the Iowa City Municipal Airport. Iowa City Municipal Airport — Annual Report 2008 Page 6 Airport Staff Michael Tharp, C.M., Operations Specialist Airport Commission Greg Farris, Chairperson Janelle Rettig, Secretary Randall Hartwig Howard Horan John Staley Respectfully Submitted, Greg Farris, Chairman Iowa City Municipal Airport — Annual Report 2008 Paee 7 Monthly Expense Report - December'O8 Check Requests During Month Approved Check Requests 12/l2008 Earth Tech / AECOM (North Taxilane Rehab) 12/12008 Earth Tech / AECOM (Runway 7.25 Add Alternate) 12/12008 Earth Tech / AECOM (Runway 7-25 Paving and Lighting) 12/12008 Earth Tech / AECOM (Runway 7.25 Obstruction Mitigation) 12/12008 Earth Tech / AECOM (Runway 7.25 Reconstruct) 12/12008 Jet Am Inc (Snow Removal) 12/12008 Larew Cc (Boiler Repar Hangar #32) 12/12008 MidAmerican Energy (Wire Relocation - Obstruction Mitigation) 12/112008 Larew Cc (Boiler Repar Terminal) 12/112008 Larew Cc (Boiler Repar Bldg F) 12/I 12008 Larew Cc (Boiler Repar Terminal) 12/152008 Jet Air (Management Services) 12222008 Earth Tech / AECOM (North Taxilane Rehab) 12222008 Earth Tech / AECOM (Runway 7.25 Paving and Lighting) 12222008 Earth Tech / AECOM (Runway 7.25 Reconstruct) 12222008 Midwest Janitorial (December Services) 12222008 Iowa DNR (Underground Fuel Tank License Renewal) 12222008 Iowa Public Airports Association (Annual Dues) 1222009 Midwest Janitorial (November Services) Capital Projects Pending Expenses Airport Operating Expenses City CIP Fund Expenses Total Expenses Construction Contracts South Economic Study -ALP Update South T-Hangar Taxilane Runway 7-25 Paving United Hangar Runway 7-25 Reconstruct and Alternate North T-Hangar Taxilane Rehab Total Pending Expenses Airport Funds CIP Funds $8,483.52 $7,587.90 $22,606.63 $1,891.98 $24,873.15 $4,000.00 $786.80 $225,400.00 $155.00 $93.50 $155.00 $750.00 $508.10 $16,492.53 $10,481.13 $685.00 $65.00 $150.00 $685.00 $7,525.30 $318,324.94 $325,850.24 Project Bid Amount Paid During Month Paid During FiscalYear Paid To Date % Paid $15,000.00 $1,291.95 $13,726.07 91.5 $140,794.15 $98,935.64 $98,935.64 70.3 $1,347,586.13 $385,360.59 $1,341,228.72 99.5 $103,060.00 $94,562.69 $94,562.69 91.8 $1,449,848.70 $1,347,843.15 $1,347,843.15 93.0 $163,726.00 $153,843.43 $153,843.43 94.0 $0.00 $0.00 REVS: 01.05.09 11:42:20 Page: 1 Iowa City General Ledger System FY 2009 Revenue Reporting For the period 12.01.08 to 12.31.08 Estimated YTD Period Account Revenue Revenue Revenue Remainder 4 7600 Airport CONTRIB 6 DONATIONS 362100 Contrib 6 Donations Total CONTRIB 6 DONATIONS OTHER MISC REVENUE 369100 Reimb of Expenses 369900 Miscellaneous Other Income Total OTHER MISC REVENUE INTEREST REVENUES 381100 Interest on Investments Total INTEREST REVENUES RENTS 382100 Land Rental 382200 Building/Room Rental Total RENTS ROYALTIES 6 COMMISSIONS 384200 Vending Machine Comm 384900 Other Commissions Total ROYALTIES 6 COMMISSIONS TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES Total TRANSFERS Total Airport "' GRAND TOTAL «< ------------ 250.00 -250.00 ------------ ------------ 250.00 ------------ -250.00 ------ 7187.88 -7187.88 ------------ 30.00 30.00 -30.00 ------------ ------------ 7217.88 ------------ 30.00 -7217.88 ------ 1000.00 ------------ 769.74 230.26 76.97 ------------ 1000.00 ------------ 769.74 ------------ 230.26 .... -- 76.97 30700.00 1240.25 238.93 29459.75 4.04 226000.00 ------------ 109223.33 19095.00 116776.67 48.33 ------------ 256700.00 ------------ 110463.58 ------------ 19333.93 146236.42 ------ 43.03 168.00 28.80 7.20 139.20 17.14 20000.00 ------------ 12001.30 2352.30 7998.70 60.01 ------------ 20168.00 ------------ 12030.10 ------------ 2359.50 8137.90 ------ 59.65 130000.00 ------------ ------------ 64999.98 10833.33 65000.02 50.00 130000.00 ------------------------ ------------ 64999.98 ------------ 10833.33 65000.02 ------ 50.00 130000.00 ------------ ------------ ------------ 64999.98 ------------ 10833.33 65000.02 ------ 50.00 407868.00 ------------ ------------ ------------ 195731.28 ------------ 32556.76 212136.72 ------ 47.99 407868.00 ------------ 195731.28 ------------ 32556.76 212136.72 ------ 47.99 EXPE: 01.05.09 11:41:42 Iowa City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.08 Page: 1 YTD Period Account Appropriated Expenditures Expenditures encumbrance Balance % Used --------------------------------------- -------------- 7600 Airport ------------ ----------- ------------------------------------ ------ AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 38611.00 17790.38 1484.80 20820.62 46.08 412000 Perm Part Time 22603.00 12769.87 2153.47 9833.13 56.50 413000 Temporary Employees 10000.00 4888.39 45.50 5111.61 48.88 Total REGULAR SALARIES & WAGES ------------ 71214.00 ------------ 35448.64 ------------------------------------ 3683.77 35765.36 ------ 49.78 OTHER WAGES 414100 Overtime Wages 1000.00 473.28 526.72 47.33 414300 Term -Vacation Pay 1251.50 1251.50 -1251.50 414400 Term -Sick Leave 1720.57 1720.57 -1720.57 414500 Longevity Pay 1050.00 437.50 612.50 41.67 Total OTHER WAGES ------------ 2050.00 ------------ 3882.85 ------------------------------------ 2972.07 -1832.85 ------ 189.41 Total SALARIES & WAGES ------------ 73264.00 ------------ 39331.49 ------------ ------------ ------------ 6655.84 33932.51 ------ 53.68 EMPLOYEE BENEFITS GROUP INSURANCE 421100 Health Insurance 7280.00 3275.20 228.50 4004.80 44.99 421200 Dental Insurance 490.00 203.06 14.16 286.94 41.44 421300 Life Insurance 198.00 128.40 -68.92 69.60 64.85 421400 Disability Insurance 460.00 91.11 368.89 19.81 421500 Unemployment Compensation ------------ 560.00 ------------ -560.00 Total GROUP INSURANCE 8428.00 4257.77 ------------------------------------ 173.74 4170.23 ------ 50.52 SOCIAL SECURITY CONTRIBUTIONS 422100 FICA 5605.00 2945.07 497.75 2659.93 52.54 Total SOCIAL SECURITY CONTRIBUTIONS ------------ 5605.00 ------------ 2945.07 ------------------------ ------------ 497.75 2659.93 ------ 52.54 RETIREMENT CONTRIBUTIONS 423100 IPERS 4652.00 2099.94 233.92 2552.06 45.14 Total RETIREMENT CONTRIBUTIONS ------------ 4652.00 ------------ 2099.94 ------------------------------------ 233.92 2552.06 ------ 45.14 EXPB: 01.05.09 11:41:42 Account Iowa City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.08 YTD Period Appropriated Expenditures Expenditures ------------------------------------------------------- ------------------------------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) EMPLOYEE BENEFITS (CONTINUED) OTHER EMPLOYEE BENEFITS 424500 Monthly Cellular/PCS Allowance Total OTHER EMPLOYEE BENEFITS Total EMPLOYER BENEFITS PROFESSIONAL 6 TECHNICAL SERVICES PROFESSIONAL SERVICES 432020 Annual Audit 432060 Consultant Services 432070 Management Services Total PROFESSIONAL SERVICES DATA AND COMMUNICATION SERVICES 435056 Delivery Services 435060 Legal Publications Total DATA AND COMMUNICATION SBRVICBS TRAINING 6 EDUCATION 436030 Transportation 436050 Registration 436060 Lodging 436080 Meals Total TRAINING E EDUCATION INSURANCE 437010 Comp Liability Insurance 437020 Fire 6 Casualty Insurance 437030 Worker's Comp Insurance 437041 Bonding 6 Other Insurance 437042 Fidelity Bond 437200 Loss Reserve Payment Page: 2 Encumbrance Balance t Used ------------ ------------ ------ ------------ 137.50 12.50 -137.50 ------------ ------------ ------------ ------------ 137.50 ------------ 12.50 ------------ -137.50 ------ 18685.00 ------------ 9440.28 ------------ 917.91 ------------ 9244.72 ------ 50.52 554.00 554.00 5000.00 5000.00 9000.00 ------------ ------------ 4500.00 750.00 4500.00 50.00 14554.00 ------------ 4500.00 ------------ 750.00 ------------ 10054.00 ------ 30.92 36.98 -36.98 12.00 ------------------------ 190.46 ------------ -178.46 1587.1 12.00 227.44 ------------ ------------ -215.44 ------ 1895.3 900.00 400.00 500.00 150.00 1950.00 8578.00 5000.00 16893.00 9640.03 73.00 90.00 928.00 5000.00 900.00 400.00 500.00 150.00 ------- ------ 1950.00 3578.00 58.29 7252.97 57.07 -17.00 123.29 928.00 5000.00 EXPE: 01.05.09 11:41:42 Page: 3 Iowa City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.08 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used ------------------------------------------------------- ------------ ------------------------------------------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) INSURANCE (CONTINUED) ------------------------------------------------------------ ------ Total INSURANCE UTILITY SERVICES 438010 Stormwater Utility Charges 438030 electricity 438070 Heating Fuel/Gas 438080 Sewer Utility Charge 438090 Water Utility Charge 438100 Refuse Collection Charges 438110 Local Phone Service 438120 Long Distance Service 438130 Wireless Phone Service Total UTILITY SERVICES Total PROFESSIONAL & TECHNICAL SERVICES REPAIR & MAINTENANCE BUILDING REPAIR & MAINTENANCE SERVICES 442010 Other Building Repair & Maintena 442020 Structure Repair & Maintenance S 442030 Heating Equipment Repair & Maint 442040 Cooling Equipment Repair & Maint 442060 Electrical & Plumbing Repair & M 442070 Bldg Pest Control Services Total BUILDING REPAIR & MAINTENANCE SERVICE EQUIPMENT REPAIR & MAINTENANCE SERVICES 443050 Radio Equipment Repair & Mainten 443080 Other Equipment Repair & Mainten Total EQUIPMENT REPAIR & MAINTENANCE SERVIC 31472.00 14730.03 16741.97 46.80 7104.00 4251.76 591.96 2852.24 59.85 15530.00 5687.70 1145.48 9842.30 36.62 8680.00 1705.05 1259.98 6974.95 19.64 1475.00 931.76 183.22 543.24 63.17 1321.00 810.01 154.98 510.99 61.32 1200.00 594.00 606.00 49.50 264.00 358.49 55.27 -94.49 135.79 30.00 25.39 3.49 4.62 84.60 -3.45 3.45 ------------------------ 35604.00 ------------ 14360.70 ----------- 3394.38 ------------ 21243.30 ------ 40.33 ------------ ------------ 83592.00 ------------ 33818.17 ------------ 4144.38 ------------ 49773.83 ------ 40.46 7500.00 6517.27 1370.00 982.73 86.90 4000.00 4460.27 -460.27 111.51 500.00 1152.80 1035.30 -652.80 230.56 1959.00 449.23 1509.77 22.93 500.00 69.50 430.50 13.90 431.00 203.70 33.95 227.30 47.26 ------------------------ 14890.00 ------------ 12852.77 ------------ 2439.25 ------------ 2037.23 ------ 86.32 1600.00 1600.00 813.00 418.60 394.40 51.49 ------------ ------------ 2413.00 ------------ 418.60 ------------ ------------ 1994.40 ------ 17.35 R%PE: 01.05.09 11:41:42 Iowa City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.08 YTD Period Account Appropriated Expenditures Expenditures ------------------------------------------------------------------- ------------------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR E MAINTENANCE (CONTINUED) TECHNICAL SERVICES 445030 Nursery Service -Lawn and Plant C 300.00 445080 Snow and Ice Removal 4000.00 4000.00 445110 Testing Services 1900.00 622.60 445140 Outside Printing 139.00 374.00 445230 Other Technical Services 5121.00 Total TECHNICAL SERVICES INTRA-DEPARTMENT SBRVICRS 446100 City Attorney Chargeback 446130 IRS-PC/Peripheral Support Charge 446140 ITS -Computer Replacement Chargeb 446160 ITS-Network/Internet Chargeback 446200 Photocopying Chargeback 446220 Phone Service Chargeback 446280 Telecom Move/Add/Change Chargeba 446300 Phone Equipment/Line Chargeback 446320 Mail Chargeback 446350 City Vehicle Replacement Chargeb 446370 Fuel Chargeback 446380 Vehicle Repair 6 Maintenance Cha Total INTRA-DRPARTMBNT SBRVICRS MISCELLANEOUS SERVICES 6 CHARGES 449055 Permitting Fees 449060 Dues E Memberships 449120 Equipment Rental 449140 Tools Rental 449360 Interest Expense Total MISCRLLANEOUS SERVICES 6 CHARGES ------------ 7460.00 4036.00 400.00 633.00 360.00 455.00 612.00 913.00 706.00 14176.00 4861.00 3516.00 =II.140D1 525.00 250.00 250.00 Page: 4 Encumbrance Balance t Used ------ ------------ ---- 4996.60 4000.00 300.00 -4000.00 1277.40 32.77 -235.00 269.06 5121.00 -------- ------ 2463.40 66.98 1768.96 2267.04 43.83 400.00 100.00 316.68 52.78 316.32 50.03 180.00 30.00 180.00 50.00 157.20 297.80 34.55 208.84 48.14 323.16 47.20 44.00 -44.00 465.00 77.50 448.00 50.93 298.89 18.21 407.11 42.34 5806.50 8369.50 40.96 2741.84 2119.16 56.40 2137.67 ------------------- 1378.33 60.80 14605.58 ------------ 226.63 ------------ 16062.42 ••---- 47.62 65.00 65.00 400.00 150.00 61294.00 22947.50 -------- ------------ -- 62319.00 23412.50 3824.59 4039.59 -65.00 125.00 76.19 250.00 250.00 38346.50 37.44 ------ ------------ ------ 38906.50 37.57 EKPE: 01.05.09 11:41:42 Iowa City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.08 YTD Period Account Appropriated Expenditures Expenditures Encumbrance ------------------------------------------------------- ------------ ------------------------ ------------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) MISCELLANEOUS SERVICES & CHARGES (CONTINUED Total REPAIR & MAINTENANCE OTHER PURCHASED SERVICES (CHANGE TO OFFICE SO GENERAL SUPPLIES 452010 Office Supplies 452030 Minor Office Equipment/Furniture 452040 Sanitation & Industrial Supplies Total GENERAL SUPPLIES BOOKS & PERIODICALS 454020 Subscriptions 454040 Books, Magazines, Newpapers Total BOOKS & PERIODICALS COMPUTER & PRINTING SUPPLIES 455120 Misc Computer Hardware Total COMPUTER & PRINTING SUPPLIES Total OTHER PURCHASED SERVICES (CHANGE TO OFF OPERATING SUPPLIES AGRICULTURR SUPPLIES 461040 Other Agriculture Chemicals Total AGRICULTURE SUPPLIES CHEMICAL & LAB SUPPLIES 463200 Other Chemicals & Supplies Total CHEMICAL & LAB SUPPLIES Page: 5 Balance % Used --------- ------ --------- ------------------------------------ ------------ ------ 117750.00 56286.05 10705.47 61463.95 47.80 859.00 301.98 557.02 35.15 642.00 642.00 1821.00 1821.00 ------------------------------------------- ------------ ------ 3322.00 301.98 3020.02 9.09 1870.00 2036.00 -166.00 108.88 ------- ------------ ------------ ------------ 1870.00 2036.00 ------------ ------ -166.00 108.88 500.00 500.00 ------------------- ------------------------ 500.00 ------------ ------ 500.00 ------- ------------------------------------ 5692.00 2337.98 ------------ ------ 3354.02 41.07 364.00 364.00 ------------------------------- ------------ 364.00 ----------- ------ 364.00 199.98-199.98 ------------------------------------------------- ------ 199.98-199.98 EXPE: 01.05.09 11:41:42 Account --------------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) FUELS 6 LUBRICANTS 465020 Gasoline 465060 Lubricants Iova City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.09 YTD Period Appropriated Expenditures expenditures -------- ------------ ------------ ------------ Total FUELS 6 LUBRICANTS REPAIR 6 MAINTENANCE SUPPLIES 466020 Lumber/Eardvare 466030 Paint Supplies 466040 Plumbing Supplies 466050 Electrical Supplies 466060 Other Construction Supplies 466070 Other Maintenance Supplies Total REPAIR 6 MAINTENANCE SUPPLIES EQUIPMENT REPAIR 6 MAINTENANCE SUPPLIES 467020 Equipment Repair 6 Maintenance S 467160 Other Vehicle Repair 6 Maintenan Total EQUIPMENT REPAIR 6 MAINTENANCE SOPPLI SURFACING MATERIALS 468020 Concrete 468030 Asphalt 468050 Sand Total SURFACING MATERIALS OTHER SUPPLIES 6 EQUIPMENT 469040 Traffic Control Improvement Supp 469190 Minor Equipment 469210 First Aid/Safety Supplies 469260 Fire Ext 6 Refills 469320 Miscellaneous Supplies 469360 Food and Beverages 133.52 101.00 101.00 133.52 27.01 23.00 6.00 349.00 19.53 838.00 589.00 69.38 ------------ ------------ 1805.00 -------- 115.92 650.00 73.00 ------------------------ 723.00 -------- 153.00 600.00 54.00 ------------ --------- 807.00 -- -------- 106.00 888.00 99.00 57.00 111.00 53.95 11.64 Page: 6 Encumbrance Balance t Used -133.52 101.00 -32.52 132.20 -27.01 23.00 6.00 329.47 5.60 838.00 519.62 11.78 ------------ ------------ ------ 1689.08 6.42 650.00 73.00 ---------------- ------------ ------ 723.00 153.00 600.00 54.00 ---- ------------------------ ------ 807.00 106.00 789.00 11.15 57.00 111.00 -53.95 -11.64 EEPE: 01.05.09 11:41:42 Page: 7 Iowa City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.08 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance t Used ------------------------------------------------------------------------------------------------------- ------------ ------ 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) OTHER SUPPLIES & EQUIPMENT (CONTINUED) Total OTHER SUPPLIES & EQUIPMENT Total OPERATING SUPPLIES IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING (GREATER 473010 Contracted Improvements Total IMPROVEMENTS OTHER THAN BUILDING OTHER FINANCIAL USES 490150 Operating Subsidy 490160 Misc Transfers Out 490190 Interfund Loan Total OTHER FINANCIAL USES Total Airport Operations Total Airport ------------------------ 1162.00 164.59 ------------ ------------ 4962.00 614.01 32000.00 7234.00 -------- ------------ ---- 32000.00 7234.00 ------------- ------ 997.41 14.16 ------------ ---- ------- ------ 4347.99 12.37 24766.00 22.61 ----------- ------------ ------ 24766.00 22.61 8359.00 4179.48 696.58 4179.52 50.00 7187.88 7187.88 -7187.88 56426.00 11612.52 1935.42 44813.48 20.58 ------------------------ 64785.00 ------------ 22979.88 ------------ 9819.88 ------------ 41805.12 ------ 35.47 --------------------- 400730.00 ------------ 172041.86 ------------ 32243.48 --- -------- 228688.14 ------ 42.93 ------------------------ 400730.00 ------------ 172041.86 ------------ 32243.48 ------------ 228689.14 ------ 42.93 EYPE: 01.05.09 11:41:42 Account -•-------------------------------------- 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) *** GRAND TOTAL *** Iona City General Ledger System FY 2009 Expense Reporting For the period 12.01.08 to 12.31.08 YTD Period Appropriated expenditures Expenditures -------- ------------ ------------ ------------ Page: 8 Encumbrance Balance I Used ------------ ------------ ------------ ------------ ------------ ------ 400730.00 172041.86 32243.48 228688.14 42.93 ------------------------------------ ------------ ------------ ------ ------------------------------------------------------------ ------ TRID: 01.05.09 11:42:56 Page: 1 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------------------------------------------------- ------------ ------------ 7600 Airport 560100 Airport Operations 411000 Perm Full Time 12.05.09 Old Sys Total Perm Full Time 412000 Perm Part Time 12.05.08 Old Sys 12.19.08 Old Sys Total Perm Part Time 413000 Temporary employees 12.05.08 Old Sys Total Temporary Employees 414300 Term -Vacation Pay 12.05.08 Old Sys Total Term -Vacation Pay 414400 Term -Sick Leave 12.05.08 Old Sys Total Term -Sick Leave 421100 Health Insurance 12.10.08 Journal Total Health Insurance 421200 Dental Insurance 12.10.08 Journal Total Dental Insurance 421300 Life Insurance 12.01.08 Journal Total Life Insurance 081203010012 488206\CIC PAYROLL RECAP\PAYROLL 05 1484.80 ------------ ------------ 1484.80 081203010012 488206\CIC PAYROLL RECAP\PAYROLL 05 1068.46 081217010011 488448\CIC PAYROLL RECAP\PAYROLL 19 1085.01 ------------ ------------ 2153.47 081203010012 488206\CIC PAYROLL RECAP\PAYROLL 05 45.50 ------------ ------------ 45.50 081215010008 488206\CLERICAL RECAP\PAYROLL 05-DE 1251.50 ------------ ------------ 1251.50 081215010008 488206\CLERICAL RECAP\PAYROLL 05-DE 1720.57 ------------ ------------ 1720.57 081218135219 007348 DEC HEALTH INSURANCE\CIC HEALTH INS 228.50 ------------ ------------ 228.50 081218135219 007347 DEC DENTAL INSURANCE\CIC DENTAL INS 14.16 ------------------------ 14.16 081218135219 007349 DEC LIFE INSURANCE\CIC LIFE INSURAN 68.92 ------------------------ 68.92 TRID: 01.05.09 11:42:56 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Reports Source Description ----------- ------------------------------ ----------------------------- 7600 Airport (CONTINUED) 560106 Airport Operations (CONTINUED) 412100 FICA 12.05.08 Old Sys 081203010012 12.19.08 Old Sys 081217010011 Total FICA 423100 IPRRS 12.05.08 Old Sys 081203010012 12.19.08 Old Sys 081217010011 Total IPRRS 424500 Monthly Cellular/PCS Allowance 12.05.08 Old Sys 081203010012 Total Monthly Cellular/PCS Allowance 432070 Management Services 12050599\FICA\CITY CONTRIBUTION 12190599\FICA\CITY CONTRIBUTION 12053599\IPRRS\CITY CONTRIBUTION 12193599\IPRRS\CITY CONTRIBUTION Page: 2 Debit Credit ------------........... 193.57 304.18 ------------ ------------ 497.75 165.02 68.90 ------------------------ 233.92 488206\CIC PAYROLL RECAP\PAYROLL 05 12.50 ------------------------ 12.50 12.22.08 New Vouch 081223030012 06715408 Check:637578\JBT AIR INC\MONTHLY NA 750.00 Total Management Services ------------ ............ 750.00 438010 Stormwater Utility Charges 12.17.08 Journal 081218135219 007346 057-095-03\STORMNTR\12.17.08 Bill D 591.96 Total Stormwater Utility Charges ------------ ------------ 591.96 438030 Electricity 12.31.08 New Vouch 090101030124 06715773 Check:638271\MIDAMBRICAN BNBRGY\BLB 101.25 12.31.08 New Vouch 090101030124 06715791 Check:638272\MIDAMERICAN BNBRGY\RLB 159.28 12.31.08 New Vouch 090101030124 06715819 Check:638270\MIDAMBRICAN BNBRGY\ELB 70.39 12.31.08 New Vouch 090101030124 06715835 Check:638271\MIDAMBRICAN BNBRGY\BLB 814.56 Total Electricity ------------ ------------ 1145.48 438070 Heating Fuel/Gas 12.31.08 New Vouch 090101030124 06715772 Check:638271\MIDAMBRICAN HNHRGY\GAS 10.00 12.31.08 New Vouch 090101030124 06715789 Check:638272\MIDAMBRICAN BNBRGY\GAS 275.45 12.31.08 New Vouch 090101030124 06715820 Check:638270\MIDAMBRICAN RNERGY\GAS 260.80 TRID: 01.05.09 11:42:57 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Report# Source Description ----------- ---------- ------------ -------- ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 438070 Heating Fuel/Gas (CONTINUED) 12.31.08 New Vouch 090101030124 06715826 Check:638270\MIDAMERICAN ENERGY\GAS Total Heating Fuel/Gas 438080 Sewer Utility Charge 12.17.08 Journal 12.17.08 Journal 12.17.08 Journal 12.17.08 Journal Total Sewer Utility Charge 438090 Water Utility Charge 12.17.08 Journal 12.17.08 Journal 12.17.08 Journal 12.17.08 Journal 12.17.08 Journal Total Water Utility Charge 438110 Local Phone Service 12.09.08 New Vouch 081218135219 007346 057-120-00\SEWER\12.17.08 Bill Date 081218135219 007346 057-118-03\SEWBR\12.17.08 Bill Date 081218135219 007346 057-117-00\SBWBR\12.17.08 Bill Date 081218135219 007346 057-115-00\SEWER\12.17.08 Bill Date Page: 3 Debit Credit 713.73 ------------ 1259.98 67.00 56.03 52.04 8.15 ------------------ 183.22 081218135219 007346 057-120-00\WATER\12.17.08 Bill Date 50.51 081218135219 007346 057-118-03\WATER\12.17.08 Bill Date 42.29 081218135219 007346 057-117-00\WATER\12.17.08 Bill Date 39.30 081218135219 007346 057-115-00\WATBR\12.17.08 Bill Date 16.47 081218135219 007346 057.095-03\WATBR\12.17.08 Bill Date 6.41 081210030014 06714568 Check:637202\IOWA TELECOM COMMUNCIA Total Local Phone Service 438120 Long Distance Service 12.02.08 Ph Lon Dst 090102121757 00012019 DEC LONG DIST CNGBR 12.09.0E New Vouch 081210030014 06711569 Check:637183\DTI\LONG DISTANCE SERV Total Long Distance Service 442010 Other Building Repair & Maintenance Ser 12.10.08 New Vouch 081211030026 06714667 Check:637071\MIDWEST JANITORIAL SER 12.30.08 New Vouch 081231030010 06715574 Check:638273\MIDWEST JANITORIAL SER Total Other Building Repair & Maintenance Servi ------------ ------------ 154.98 55.27 ------------ ------------ 55.27 3.42 .07 ------------ ------------ 3.49 685.00 685.00 ------------------------ 1370.00 TRID: 01.05.09 11:42:57 Page: 4 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Report# ----------- Source Description Debit Credit ---------- ------------ 7600 Airport (CONTINUED) -------- ----------------------------------- ------------ ------------ 560100 Airport Operations (CONTINUED) 442030 Heating Equipment Repair & Maintenance 12.10.08 New Vouch 081211030026 06714666 Check:637058\LAREW COMPANY INC\RBPA 786.80 12.16.08 New Vouch 081217030007 06715101 Check:637341\LARBW COMPANY INC\THRM 93.50 12.16.08 New Vouch 081217030007 06715102 Check:637341\LARBW COMPANY INC\TERM 155.00 Total Heating Equipment Repair & Maintenance Se ------------ 1035.30 ------------ 442070 Bldg Pest Control Services 12.17.08 New Vouch 081218030204 06715236 Check:637322\HAWEEYE PEST CONTROL I 33.95 Total Bldg Pest Control Services ------------ 33.95 ------------ 445080 Snow and Ice Removal 12.12.08 New Vouch 081215030007 06714886 Check:637331\JET AIR INC\SNOW REMOV 4000.00 Total Snow and Ice Removal ------------ 4000.00 ------------ 446140 ITS -Computer Replacement Chargeback 12.01.08 IT Repl 081212150744 00012025 DEC ITS RBPL CHGBCE 52.78 Total ITS -Computer Replacement Chargeback ------------ 52.78 ------------ 446160 ITS-Network/Internet Chargeback 12.01.08 IT Int/Hwk 081204141412 00012031 DEC ITS NETW/INTRNET 30.00 Total ITS-Network/Internet Chargeback ------------ 30.00 ------------ 446220 Phone Service Chargeback 12.23.08 Qwest Chrg 081230082838 00012032 Dec Qwest Charges 48.14 Total Phone Service Chargeback ------------ 48.14 ------------ 446300 Phone Equipment/Line Chargeback 12.02.08 Ph Equipmt 090102121757 00012018 DEC PEON EQUIP CHGBE 77.50 Total Phone Equipment/Line Chargeback ------------ 77.50 ------------ 446320 Mail Chargeback 12.01.08 Mail 081209084234 01200046 NOV POSTAL CHARGES 19.21 TRID: 01.05.09 11:42:57 Iowa City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Reports Source Description Debit ----------- ---------- --------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) Total Mail Chargeback 449055 Permitting Fees 12.31.08 New vouch 090101030124 06715696 Check:638343\IOWA DEPARTMENT OF HAT Total Permitting Fees 449060 Dues 6 Memberships 12.30.08 New vouch 081231030010 06715573 Check:638258\I0WA PUBLIC AIRPORTS A Total Dues 6 Memberships 449360 Interest Expense 12.31.08 Journal 12.31.08 Journal 12.31.08 Journal Total Interest Expense 490150 Operating Subsidy 12.31.08 Journal Total Operating Subsidy 490160 Misc Transfers Out 12.01.08 Journal Total Misc Transfers Out 490190 Interfund Loan 12.31.08 Journal 12.31.08 Journal 12.31.08 Journal Total Interfund Loan 081218135219 007343 Corp Hangar Loan Int\Dec Interfund 081218135219 007343 Airprt SH Hangar Int\Dec Interfund 081218135219 007343 Airprt SW Hangar-Int\Dec Interfund 18.21 Page: 5 Credit 65.00 ------------ ------------ 65.00 150.00 ------------------------ 150.00 1904.56 991.02 929.01 ------------ 3824.59 081218135219 007341 Econ Dev Coord 10t\Dec Budgeted Tra 696.58 ------------ 696.58 081218135219 007351 MidAm reimburse Lot5\Apply Airport 7187.88 ------------ 7187.88 081218135219 007343 Corp Hangar Loan Prn\Dec Interfund 1095.44 081218135219 007343 Airprt SE Hangar Prn\Dec Interfund 338.98 081218135219 007343 Airprt SW Hangar-Prn\Dec Interfund 501.00 1935.42 ------------ Total Airport Operations 32312.40 68.92 TRID: 01.05.09 11:42:57 Iona City General Ledger System Expenditures Detail PY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Report# Source Description ----------- ------------------------------ ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) Total Airport Page: 6 Debit Credit ------------------------ 32312.40 68.92 TRID: 01.05.09 11:42:57 Iora City General Ledger System Expenditures Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Reportt Source Description ----------- ---------- ------------ -------- ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Loan (CONTINUED) Debit Page: 7 Credit ------------ ------------ +T� GRAND TOTAL +tt 32312.40 68.92 ------------------------ ------------------------ TRID: 01.05.09 11:43:05 Page: 1 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ ------------------------------------------------------- ------------ 7600 Airport 560100 Airport Operations 369900 Miscellaneous Other Income 12.09.08 Old Sys 081210010008 Total Miscellaneous Other Income 382100 Land Rental 12.03.08 Old Sys 081216010008 12093046\HERTZ CORPORATION\PARKING 30.00 ------------ ------------ 30.00 12031265\ARMED FORCES RESER\AIRPORT Total Land Rental 382200 Building/Room Rental 12.02.08 Payment 081202112245 00010354 1-38\BALL ROBBRT\SEP 08\HANGAR 16 12.02.08 Payment 081202112245 00011156 1-37\HALL ROBBRT\NOV 08\HANGAR 16 12.02.08 Payment 081202112245 00011156 1-37\RALL ROBERT\NOV 08\HANGAR 112 12.02.08 Payment 081202112245 00011191 1-16\BROGAN-COLBMAM KIM\NOV 08\HAN 12.02.08 Payment 081202112245 00011427 1-2\FIELD HOMARD\DBC 08\HANGAR #54 12.02.08 Payment 081202112245 00011438 1-17\BRUMLEY JAMBS\DBC 08\HANGAR # 12.02.08 Payment 081202112245 00011448 1-43\HALL ROBBRT\DEC 08\HANGAR #6 12.02.08 Payment 081202112245 00011448 1-43\HALL ROBERT\DBC 08\HANGAR 112 12.02.08 Payment 081202112245 00011456 1-39\BUTLER JOHH\DBC 08\HANGAR #36 12.02.08 Payment 081202112245 00011456 1-39\BUTLER JOHN\DBC 08\HANGAR #37 12.02.08 Payment 081202112245 00011462 1-25\OCKBNFBLS TRANSFER\DBC 08\HANG 12.02.08 Payment 081202112245 00011486 1-29\ROOF KBITH\DBC 08\HANGAR #32 12.02.08 Payment 081202112245 00011488 1-22\PONBRS ROBBRT\DBC 08\HANGAR # 12.02.08 Payment 081202112245 00011539 1-13\POLASKI MICHABL\DEC 08\HANGAR 12.03.08 Payment 081203094308 00011446 1-7\SCHNBLL TOM\DEC 08\HANGAR #62 12.03.08 Payment 081203094308 MUM 1-13\SCHMEISER BUSS\DBC 08\HANGAR 12.03.08 Payment 081203094308 00011515 1-12\LOST GARY\DHC 08\HANGAR #4 12.03.08 Payment 081203094308 00011515 1-12\LOST GARY\DEC 08\HANGAR #21 12.03.08 Payment 081203094308 00011534 1-14\ADVANCED INFONBERING\PAYMENT 12.03.08 New Vouch 081204030041 06714286 Check:636973\MIBCHERT, RONALD\RBIMB 12.04.08 Payment 081204091847 00011472 1-8\FARRIS GRBG\DBC 08\HANGAR #29 12.04.08 Payment 081204091847 00011497 1-9\DOMNBS 6 ASSOCIATES\DHC 08\RANG 12.05.08 Payment 081205100103 00011447 1-2\BULLERS JOMATHAN\DBC 08\HANGAR 12,08.08 Payment 081208090026 00011455 1-1\MASCARI RICK\DBC 08\HANGAR #30 6.00 238.93 238.93 137.00 68.79 72.21 148.00 168.00 148.00 141.00 148.00 168.00 168.00 204.00 512.00 141.00 148.00 174.00 204.00 141.00 148.00 110.00 148.00 168.00 141.00 148.00 TRID: 01.05.09 11:43:05 Page: 2 Iova City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 12.01.00 to 12.31.08 Trans Date Trans Type Report# Source Description Debit ------------ Credit ------------ ----------- 7600 Airport (CONTINUED) ---------- ------------ -------- ---------------------------------- 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 12.09.00 Payment 081209095457 00010336 1-23\HINKLEY HARRY\SEP 08\HANGAR # 299.45 12.09.08 Payment 081209095457 00010336 1-23\11INKLEY HARRY\SBP 08\HANGAR # 101.55 12.09.08 Payment 081209095457 00010679 1-24\HINKLEY HARRY\OCT 08\HANGAR # 404.00 12.09.08 Payment 081209095457 00010679 1-24\HINKLEY HARRY\OCT 08\EANGAR # 141.00 12.09.08 Payment 081209095457 00011139 1-25\HINKLEY HARRY\NOV 08\HANGAR # 404.00 12.09.08 Payment 081209095457 00011139 1-25\HINKLEY HARRY\NOV 08\HANGAR # 141.00 12.09.08 Payment 081209095457 00011431 1-26\HINKLEY HARRY\DEC 08\HANGAR # 1368.00 12.09.08 Payment 081209095457 00011431 1-26\HINKLBY HARRY\DBC O8\HANGAR # 141.00 12.09.08 Payment 081209095457 00011490 1-8\NIBCHERT RONALD\DRC 08\HANGAR 186.00 12.09.08 Payment 081209095457 00011507 1-30\HERTZ CORPORATION\DBC 08\OFFIC 300.00 12.10.08 Payment 081210092157 00011434 1-15\RUYLE JOHN\DBC 08\HANGAR #33 358.00 12.10.08 Payment 081210092157 00011449 1-9\BULGARBLLI DAVID\DBC 08\11ANGAR 148.00 12.10.08 Payment 081210092157 00011450 1-10\IONA CITY FLYING CLUB\DBC 08\H 168.00 12.10.08 Payment 081210092157 00011464 1-20\PATTSCHDLL RICHARD\DBC 08\RAN 229.00 12,10.08 Payment 081210092157 00011489 1-18\OPERATOR PERFORMANCE LAB\DBC 0 1330.00 12.10.08 Payment 081210092157 00011489 1-18\OPERATOR PERFORMANCE LAB\DBC 0 168.00 12.10.08 Payment 081210092157 00011501 1-8\ALBKIS PARK INN E SUITES\DBC 08 141.00 12.10.08 Payment 081210092157 00011502 1-5\VRANEK DOUGLAS\DBC 08\HANGAR # 141.00 12.11.08 Payment 081211091329 00011454 1-6\HALL DAN\DEC 08\HANGAR #27 148.00 12.11.08 Payment 081211091329 00011457 1-1\HARTNIG RANDY\DBC 08\HANGAR #3 168.00 12.11.08 Payment 081211091329 00011470 1-7\ZUBROD ROY\DBC 08\HANGAR 120 148.00 12.12.08 Payment 081212094338 00011445 1-10\RANDY CHARLBS\DEC 08\HANGAR # 141.00 12.12.08 Payment 081212094338 00011463 1-8\LACINA DAVB\DEC 08\HANGAR #57 198.00 12.12.08 Payment 081212094338 00011468 1-9\CHALKLBY BEN\DEC 08\HANGAR #14 148.00 12.12.08 Payment 081212094338 00011531 1-12\BOAR BRIAN\DBC 08\HANGAR #19 148.00 12.12.08 Payment 081212123058 00011425 89-1\MILLER RICRARD\DBC 08\HANGAR 168.00 12.12.08 Payment 081212123058 00011461 89-3\FISHBAUGH JUSTIN\DHC 08\HANGA 174.00 12.12.08 Payment 081212123058 00011466 89-4\ALLENDHR PATRICK\DEC 08\HANGA 168.00 12.12.08 Payment 081212123058 00011473 89-5\EDNONDS TERRY\DBC 08\EANGAR # 313.00 12.12.08 Payment 081212123058 00011482 89-9\SQUADRONS DP\DEC 08\HANGAR #53 168.00 12.12.08 Payment 081212123058 00011485 89-10\GURNBTT DON\DBC 08\HANGAR #3 310.00 12.12.08 Payment 081212123058 00011494 89-11\SI1GLETARY ROBBRT\DHC 08\HAN 141.00 TRID: 01.05.09 11:43:05 Page: 3 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Reports Source Description Debit Credit ----------- 7600 Airport (CONTINUED( ---------- ------------ -------- ----------------------------------- ------------ ------------ 560100 Airport Operations (CONTINUED( 382200 Building/Room Rental (CONTINUED) 12.12.08 Payment 081212123058 00011511 89-13\SWANSOM NAONI\D8C 08\HANGER 141.00 12.12.08 Payment 081212123058 00011529 89-15\MBADE JAMBS N\DEC 08\HANGAR 148.00 12.15.08 Payment 081215092014 00011167 1-3\FULL JBRRY\MOV 08\HANGAR 145 204.00 12.16.08 Payment 081216103441 00011535 1-17\YELDER ROY\D8C 08\HANGAR 118 148.00 12.17.08 Payment 081217094710 00011451 1-20\HOLLY FORREST\DEC 08\HANGAR Y 148.00 12.17.08 Payment 081217094710 00011487 1-14\JBT AIR INC\DEC 08\BUILDINGS D 3926.00 12.17.08 Payment 081217094710 00011495 1-23\SAPPHIRE VISTAS LLC\DEC 08\BAN 148.00 12.17.08 Payment 081217094710 00011505 1-15\JBT AIR\DEC 08\RANGAR 860 174.00 12.19.08 Payment 081219091409 00011499 1-2\FLANAGAN JAMBS\DBC O8\HANGAR 8 168.00 12.22.08 Payment 081222092844 00011465 1-5\NB IA PHYS THBRPY ASSOC\DBC 08\ 198.00 12.22.08 Payment 081222092844 00011465 1-5\NB IA PHYS THBRPY ASSOC\DEC 08\ 174.00 12.24.08 Payment 081224094137 00011469 1-3\TEARSE DAVID\DBC 08\RANGAR 841 168.00 12.30.09 Payment 081230093409 00011666 1-10\BRUMLEY JAMBS\JAN 09\HANGAR # 148.00 12.30.08 Payment 081230093409 00011688 1-14\SCHMBISER BUSS\JAN 09\HANGAR 204.00 12.30.08 Payment 081230093409 00011761 1-13\ADVANCED INFONERRING\PAYNRNT 110.00 12.31.08 Payment 081231091449 00011717 1-15\PONBRS ROBERT\JAN 09\HANGAR # 141.00 12.31.08 Payment 081231091449 00011743 1-17\LUST GARY\JAN 09\HANGAR 84 141.00 12.31.08 Payment 081231091449 00011743 1-17\LUST GARY\JAN 09\HANGAR 121 148.00 Total Building/Room Rental ------------ ------------ 6.00 19101.00 384200 Vending Machine Comm 12.19.08 Old Sys 081222010008 12193017\AMERICAN BOTTLING\VENDING 7.20 Total Vending Machine Comm ------------ ------------ 7.20 384900 Other Commissions 12.17.08 Old Sys 081218010008 12173004\NEWTON OIL\OCT AND NOV FLO 2352.30 Total Other Commissions ------------ ------------ 2352.30 393120 General Levy 12.31.08 Journal 081218135219 007341 Airport Prop Ts Supp\Dec Budgeted T 10833.33 Total General Levy 10833.33 TRID: 01.05.09 11:43:05 Iowa City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31,08 Trans Date Trans Type Reportf Source Description --------------------------------- -------- --------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) Total Airport Operations Page: 4 Debit Credit ----------------------- 6.00 32562.76 TRID: 01.05.09 11:43:05 Trans Date Trans Type ----------- ---------- 7600 Airport (CONTINDRD) 560100 Airport Operations (CONTINORD) Total Airport Iowa City General Ledger Systea Revenues Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Report# Source Description --------- -------- ----------------------- Page: 5 Debit Credit ------------ ............ 6.00 32562.76 TRID: 01.05.09 11:43:05 Iona City General Ledger System Revenues Detail FY 2009 Detail Reporting For the period 12.01.08 to 12.31.08 Trans Date Trans Type Reportt Source ----------- ---------- -------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) ttt GRAND TOTAL "t Page: 6 Description Debit Credit ----------------------------------------------- ------------ ------------ 6.00 32562.76 ------------------------ ------------ ------------