Loading...
HomeMy WebLinkAbout01-11-2007 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JANUARY 11, 2007 - 5:45P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: December 14, 2006 3. Public Discussion - Items not on the agenda 4. Items for Discussion/Action: A. FAA/IDOT Projects - Earth Tech — David Hughes a. Runway 7/25 b. South Aviation Development Study c. South Taxilane Rehab d. HangarA Rehab e. Terminal Apron Rehab f. Obstruction Mitigation g. 405 Approach Surveys B. Aviation Commerce Park C. Parking Policy ' a. Consider a resolution adopting Parking Policy D. Airport "Operations": Strategic Plan -Implementation; Budget; and Airport Management E. FBO Staff Report F. Subcommittees' Reports 5. Commission Members' Reports 6. Staff Report 7. Set next regular meeting for February 08, 2007 at 5:45 p.m. 8. Adjourn MINUTES Iowa City Airport Commission December 14, 2006 Iowa City Airport Terminal — 5:45 PM Members Present: Randy Hartwig, Chair; John Staley; Janelle Rettig; Howard Horan, Greg Farris (arrived at 5:49) Staff Present: Sue Dulek, Michael Tharp Others Present: David Hughes, Earth Tech; Jay Honeck; Phillip Woolford, Jet Air; Rick Mascari DETERMINE QUORUM: Chairperson Hartwig called the meeting to order at 5:47 PM. RECOMMENDATIONS TO COUNCIL: Item B.a. — Aviation Commerce Park; Recommend to City Council to accept offer for Lot No. 5 of the North Commerce Park, by IWI Motorparts. Item B.b. — Resolution amending listing agreement with Iowa Realty; Resolution A06-29 approved extending the listing agreement for one year and adopted the latest pricing model. Commission recommends City Council accept the proposed agreement amendment. APPROVAL OF MINUTES FROM THE NOVEMBER 9, 2006, MEETING: Hartwig noted that on the first page of the minutes, about halfway down, where it says, "Hughes stated they did have maintained contact..." that this should be "...did maintain contact." Also noted was on page 2, under c.2., there it stated "...he asked for a move...", that this should be "...he asked for a motion." On page 3, 7 lines down, where it states "...Tharp stated that he spoke with Blum...", that it should have Blum's first name, Dick, added. Hartwig also noted that at the bottom of this same paragraph, where it states "Rettig asked the other Airport Commission members if they are all in consensus that they are not...", that this should state something to the effect that they are not interested in that entire parcel going to this. Rettig stated that perhaps it should say "commercial development" or "private commercial development on all 63 acres." Also, right above this, where it states "...which Horan responded that he feels once the 7-25 project...", that the second "he feels" should be removed. Rettig noted that on page 4, where it says "...Tharp stated that Roof does plan to hang up his maintenance shop plague," it should be reworded to say Roof closed his maintenance shop. Hartwig noted that "plague" is wrong, and he feels they could reword this to say "Roof discontinued his business." Rettig also noted on page 5, at the bottom under Commission Members' Reports, that it needs to be clarified that it is the University Gothic Tower that will be pink and blue, and not the Airport's tower. Staley noted that under J, Subcommittees' Reports, it states "Cleaning Committee," and he asked if this shouldn't be "Company." M Staley moved to accept the minutes of the November 9, 2006 meeting as amended; seconded by Horan. Motion carried 5-0. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: A. FAA/IDOT Projects — Earth Tech — David Hughes a. Runway 7/25 — Hughes noted that everyone should have received his update in their packets for this meeting. He noted that they are "behind the scenes again," versus actually being on the site. Hughes gave the Members updates on various projects, such as the obstruction mitigation project. Currently, they are identifying property owners that will be affected by this, and then they will need to contact those involved. Hughes stated that they are also working on the approach survey and will be getting this information to the FAA shortly. Hughes stated that they have received recently some good news from the FAA regarding upcoming projects. The Project Initiation letter arrived to begin planning work on the runway extension paving. Hughes next addressed the south area taxi lanes, stating that they did get their field survey completed on this. Regarding T-Hangar A rehabilitation, which is a State grant, Hughes stated that they need to get this survey completed still. Hughes next addressed the north area and the State grant for those taxi lanes. He said the contractor has completed his punch list, made repairs to the hangar, and now the Commission needs to accept this project as complete. Rettig asked if AIP-10 was part of a grant or not. Hughes stated that this was part of the Environmental Assessment portion of a grant that was done several years ago. The discussion continued with Members asking various questions of Hughes. b. Taxi -lane North Tee's and Parking Lot Rehab — (see above discussion) i. Consider a resolution accepting the North T-Hangar Taxi lane and North Parking lot rehabilitation as completed. Rettig moved to consider Resolution A06-28; seconded by Staley. Carried 5-0. c. South Aviation Development — (see above discussion) d. JJR Davis Drainage — Hughes noted that some time back, Davis requested a drainage easement to get to their basin. Since this initial request, Hughes stated Davis has reexamined this and now possibly may want to purchase this property. Once the runway is extended, Hughes stated that this area would not be required for a safety area. Members asked for Hughes to point this out on the map for better clarification. Hughes explained the area in question and how the drainage is set up in this area. The topic of leasing land versus selling it was briefly discussed, as well. Hughes continued by explaining the Willow Creek situation, stating that this study will be completed some Airport Commission December 14, 2006 Page 3 of 7 time in late January. Rettig asked questions of Hughes regarding the stormwater runoff laws, stating that they need more information on this issue. Hughes stated that the FAA will not release the land until the extension work has been completed. B. Aviation Commerce Park — Hartwig stated that he would like to defer this issue, as Harry Wolf will not be arriving until later in the meeting. Staley moved to defer Item B until Harry Wolfs arrival; seconded by Horan. Carried 5-0. Harry Wolf arrived at the meeting. He stated that he has some news for the Commission. He presented a new plat of the Commerce Park, stating that it is a consolidation of two plats and is what they are using for their marketing purposes. Wolf next addressed the purchase offer on Lot No. 5. He explained how the pricing was arrived at for this parcel and what the buyer will be obligated to do. He stated that he recommends approval of the offer. (TAPE ENDS) Discussion continued with Rettig asking how this one sale will affect the Airport's revenue, and how it will affect the Airport's rental agreement with the School District. Rettig noted that of the parcels, this was the only one that had revenue generating activities that would disappear with the sale. Members discussed the budgetary effects of the proposed sale. Rettig stated that the revenue from the leases on that parcel had been figured into 2008's budget and would leave a shortfall if there is nothing to replace it. Members continued to discuss the effects of having movement on the land with regards to the airport's budget. Wolf responded to Members' questions regarding the potential buyer for this land. Hartwig noted that at the public hearing set by city council for this sale offer, the Commission would have another opportunity to stress their concerns regarding the effects of the sale on the airport's budget. Rettig stated that she is in favor of selling this lot, but wanted her concerns regarding revenue to be noted. She also noted that they would need to actually sell off more than half of the land before the airport would get any money from these land sales. a. Recommendation to City Council on purchase offer for Lot No. 5 of the North Commerce Park by IWI Motorparts — Horan moved to recommend to the City Council acceptance of the purchase offer on Lot No. 5; seconded by Farris. Carried 5-0. b. Consider a resolution approving amendment to listing agreement with Iowa Realty — Hartwig stated that this is in regards to the listing agreement they currently have with Iowa Realty. Wolf briefly explained the wording and pricing model issues on this. Rettig moved to consider Resolution A06-29 approving amendment to the listing agreement with Iowa Realty; seconded by Horan. Carried 5-0. Airport Commission December 14, 2006 Page 4 of 7 C. Grass Runway — Tharp stated that since the last discussion on this, several issues have arisen, one being that they would eliminate almost all of the farmable land that they have, if they were to put in this grass runway. He continued, stating that if the Members decide to proceed with this runway, it would not be until the spring of 2008. This would give them time to discuss the impact with those involved, Rick Mascari spoke to the Members regarding this, stating that there is a very low percentage of pilots who would use this strip. He questioned the expense of creating this runway, versus opening up 18-36 again, which he feels would be a much more usable runway. Horan stated that he would like to continue looking into this issue, with perhaps another location working better. The issue of the ASOS location was also discussed and how this plays into the location of runways. (TAPE ENDS) The discussion continued with Members discussing the southern portion of the Airport property and how they want to handle the development of this area Staley asked Tharp to point out the areas that are farmable now and what they would lose by adding a grass runway. The discussion turned to the history of various runways. D. Jet Air Management Agreement — Hartwig stated that he has discussed this agreement with both Philip and Harrel. Rettig asked if this agreement would begin in January and run for a year. Hartwig stated that the Members need to decide if they want the agreement to run on a calendar year or the fiscal year. Rettig moved to accept the Management Agreement as written; seconded by Horan. Discussion then continued, with Dulek noting that the Risk Manager will have to give approval on this agreement, as well. Staley moved to amend the motion to state, "Pending approval by the Iowa City Risk Manager, that Item 5 is acceptable." Seconded by Farris. Carried 5-0. Hartwig stated that they now need to vote on Rettig's motion. Motion carried 5-0. E. Parking Policy a. Consider a Resolution adopting Parking Policy — Staley asked for clarification on the actual Resolution, stating that in one part it says "Iowa City Municipal Parking Policy," and in another it states "Iowa City Municipal Airport Parking Policy." He asked if they were adopting the City's parking policy. Members agreed that it would be the "Iowa City Municipal Airport" policy. Members asked Tharp questions regarding his research into what other airports do in regards to parking policies. The discussion continued, with Rettig asking various questions about how this policy will be implemented, and stating that they need to work on the signage somewhat. Tharp also discussed long-term parking issues with the Members. Changes to the parking policy were discussed at length, with Members deciding that anybody parking for more than 14 days is to park in long -tens parking, and not in front of the terminal; and also, the Airport needs to Airport Commission December 14, 2006 Page 5 of 7 give permission to the person wanting to leave a vehicle that length of time. Next, various wording for the signage was discussed by the Commission. (return to Item B — Aviation Commerce Park) F. Janitorial Services — Farris spoke to the Members regarding the submitted proposal. He stated that they had three proposals submitted, and that the decision was made to stay with Midwest. He explained some of the additional items in the proposal that are not currently being done. Tharp fielded Members' questions regarding this proposal and what currently takes place, as well. Rettig asked questions regarding the budget and this increase in janitorial service. (TAPE ENDS) Members continued to ask questions regarding the cleaning of various areas within the Airport. Rettig stated that she feels all areas that are the Airport's responsibility should be cleaned and maintained in this agreement. a. Consider a resolution accepting the proposal submitted by Midwest Janitorial Services for janitorial services at the Iowa City Municipal Airport — Rettig moved to consider Resolution A06-30 accepting the proposal submitted by Midwest Janitorial Services — pending clarification of the typographical error; seconded by Staley. Carried 5-0. G. Airport Operations: Strategic Plan -Implementation; Budget; and Airport Management — In regards to the Strategic Plan, Hartwig acknowledged the work of Tharp and Farris on the newsletter, and stated that the City Manager commented favorably on this. In regards to the Budget, Rettig asked where they are in the FY08 Budget process. Tharp noted that he and Hartwig met with the City Manager last month on this. Hartwig stated that they explained why they are requesting what they are, and that next will be a City Council meeting where all of the Commissions and Boards meet with the Council to explain their budget requests. a. 2006 Annual Report — Rettig stated that she has a suggestion for an addition to this report. A brief discussion ensued, with Rettig stating she would read through it again and make any additional suggestion. H. Subcommittees' Reports — Farris stated that he has not been able to do anything further on the viewing area project, but hopes to have some information for the Members in the next few meetings. Hartwig noted that he needs to talk to Parks and Rec about this area, as well. I. FBO Staff Report — Hartwig noted that this is an opportunity for Jet Air to address the Commission. Woolford spoke to the Members regarding the self- Airport Commission December 14, 2006 Page 6 of 7 serve pump and the problems they have with it. He stated that they need to upgrade this pump, and he briefly explained the advantages of this. Woolford stated that a new dispenser would be able to handle both Avgas, which was currently provided and Jet fuel, should the Commission want to have a self- service Jet fuel dispenser. A discussion ensued, with Members questioning the cost for this replacement. Rettig suggested that they look into grant funding for this project. (TAPE ENDS) COMMISSION MEMBERS' REPORTS — Hartwig stated that he received a letter inviting them to the opening of the Mormon Trek extension this coming week. He stated that anyone interested is welcome to join him at the intersection of Dane Road and Mormon Trek for the ribbon cutting. Rettig stated that she would try to make this. Horan stated that he shared some photos with Hughes on the grading project and would do so with the Commission, as well. Farris thanked Tharp his work putting the newsletter together. STAFF REPORT — None. SET NEXT REGULAR MEETING FOR: January 11, 2007 at 5:45 P.M. ADJOURN — Meeting adjourned at 7:56 P.M. Airport Commission December 14, 2006 Page 7 of 7 Airport Commission ATTENDANCE RECORD YEAR 2006 (Meeting Date) NAME TERM EXP. 1/12 2/9 3/9 4/13 511 5111 5131 6/8 6/16 6/23 6/27 7/13 Daniel Clay 3/1/08 -- -- -- --- --- -- --- --- -- --- --- --- Randy Hartwig 3/l/09 X X X X X X X X X O/E X X Greg Farris 3/l/07 O X X X X X X X X X O/E O/E John Staley 3/1/06 X X X X X X O/E X X O/E X X Howard Horan 3/1/08 X X X X X X X X X X X X Janette Rettig 3/l/12 --- --- X X X X X X X X X X ............ 7/27 8/10 9/14 9/18 10/12 11/9 12/14 Randy Hartwig 3/l/09 X X X X X X X Greg Farris 3/l/07 O/E X X X X X X John Staley 3/l/10 X X X X X X X Howard Horan 3/1/08 X X X X X X X Janelle Rettig 3/1/12 O/E X X X X X X KEY: X = Present O = Absent O/E = Absent/Excused NM = No meeting --- = Not a Member Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION NO. RESOLUTION TO ADOPT PARKING POLICY. WHEREAS, the Iowa City Airport Commission wishes to adopt a parking policy for vehicles located at the Iowa City Municipal Airport. WHEREAS, the Parking Policy will become effective immediately following resolution, NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION, THAT: 1. The Iowa City Municipal Airport Parking Policy is adopted, a copy of which is attached. Passed and approved this day of 2007. ATTEST: SECRETARY It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays Approved by City Attorney's Office Absent the Resolution be Farris Hartwig Horan Rettig Staley IOWA CITY MUNICIPAL AIRPORT VEHICLE PARKING POLICY DEFINITIONS: VEHICLE: Any device in, upon or by which a person or property is or may be transported or drawn upon a highway or street, excepting devices moved by human power or used exclusively upon stationary rails or tracks, and shall include, but not be limited to, motor vehicle, automobile, truck, trailer, motorcycle, tractor, buggy, wagon or any combination thereof, whether or not licensed for the current year. (1978 Code §24-102; amd. 1994 Code; Ord. 00-3954, 12-19-2000; Ord. 01-3963, 4-3-2001) INOPERABLE/OBSOLETE VEHICLE: Any device in, upon or by which a person or property is or may be transported or drawn upon a highway or street, excepting devices moved by human power or used exclusively upon stationary rails or tracks, and shall include, but not be limited to, motor vehicle, automobile, truck, trailer, motorcycle, tractor, buggy, wagon or any combination thereof, and not licensed for the current year as required by law and/or which exhibits any one of the following characteristics: A. Any vehicle or part of a vehicle with a broken windshield or any other broken glass. B. Any vehicle or part of a vehicle with a broken or loose fender, door, bumper, hood, wheel, steering wheel, trunk top or tailpipe. C. Any vehicle lacking an engine or one or more wheels or other structural parts which renders such vehicle totally inoperable. D. Any vehicle or part of a vehicle which is a habitat for rats, mice or snakes or any other vermin or insects. E. Any vehicle or part of a vehicle which, because of its defective or obsolete condition, constitutes a threat to the public health and safety. F. Any vehicle that is not capable of moving in both forward and reverse gears. SHORT TERM — Any period lasting not longer than 14 days LONG TERM — Any period lasting 14 or more days TRANSIENT LONG TERM — Vehicles located at the airport for the purposes of transporting frequent aircraft passengers to and from the Iowa City Municipal Airport Parking at the Iowa City Municipal Airport will be restricted to Airport Users, Guests, and members of the public using facilities located at the Iowa City Municipal Airport. The Iowa City Airport has 3 areas surrounding the Terminal Building which have parking spaces marked. These areas are separated into 3 categories: Long- term, Short-term, and FBO / Staff. Proximity to each other results in the capabilities of overflow from one area being contained in either of the other lots. See attached map for layout The following are the fees and requirements to park vehicles at the Iowa City Municipal Airport: Short Term: Vehicles parked in designate short term area. No fee Long Term: Parking 14 days or more requires check -in with Airport or FBO personnel, which will included Vehicle License plate number, Owners Name, Contact Number. No Fee Transient Long Term: Vehicles stored at the airport for purposes of transporting frequent visitors shall be registered with Airport or FBO personnel. Registration shall include License Plate Number, Name of Vehicle Owner, Primary Contact, Address, and Spare Keys to move the vehicle for Snow Removal or Construction. Fees due at the time of registration will be $20 per month or $200/year. A parking placard will be issued by the Airport Operations Specialist. The parking placard will be placed in a viewable location inside the registered vehicle. The Airport reserves the right to tow, at the owner's expense, any vehicles parked in violation of this policy. Southlti rive C9 J OQ 0 x _.. x - 1 B1 Long-term Permanent Viewing Area Short Term FBO Staff C Bldg D Parking Area Layout 0 Bldg H Bldg I F Bldg J Bldg F Bldg K Monthly Expense Report - December '06 Check Requests During Month Approved Check Requests 12/4/2006 Jet Air Inc (Management Services) 12/52006 Commercial Towel Service (Cleaning Services) 12/7/2006 Earth Tech Inc (North Taxilanes / Parking Lot) 12/7/2006 Earth Tech Inc (Willow Creek - Final Billing) 12/13/2006 Larew, Company (Heat Repair- Terminal Building 12/14/2006 CJ Moyna & Sons (Grading Contract) Req. 48 12/182006 Midwest Janitorial Service (Cleaning Services) 12/202006 Earth Tech Inc (South Econ Study & ALP Update) 1220/2006 Earth Tech Inc (Willow Creek) 12/272006 Iowa DNR - Underground Fuel Tank License / Registration Capital Projects Pending Expenses Airport Operating Expenses City CIP Fund Expenses Total Expenses Construction Contracts Airport Budget City Budget $1,500.00 $88.44 $644.32 $688.28 $191.50 542,917.96 $188.70 $1,353.45 $4,350.80 $65.00 $1,968.64 $50,019.81 $51,988.45 Project Bid Amount Paid During Month Paid During Year Paid To Date % Paid Runway 7 Grading $950,154.00 $42,917.96 $558,462.20 $558,462.20 58.8 North T-Hangar Taxilanes(project accepted complete 12/14106) $165,010.72 $127.274.66 $160,150.66 $160,150.66 97.1 Terminal Parking Lot (project accepted complete 12114/06) $21,689.49 $16,498.45 $21,038.54 $21.038.54 97.0 South Economic Study - ALP Update $15,000.00 $1,353.45 $7,081.34 $7,081.34 47.2 Total Pending Expenses $0.00 $0.00 E%PE: 01.04.07 12:41:50 Iowa City General Ledger System Budget to Actuals expenditures Summary FY 2007 expense Reporting For the period 12,01.06 to 12.31.06 YTD Period Page: 1 Account Appropriated expenditures Expenditures encumbrance Balance t Used ------------ 7600 Airport 560100 Airport Operations PERSONNEL 411000 Perm Full Time 412000 Perm Part Time 413000 Temporary Employees 414100 Overtime Wages 414500 Longevity Pay 421100 Health Insurance 421200 Dental Insurance 421300 Life Insurance 421400 Disability Insurance 421500 Unemployment Compensation 422100 Pica 423100 Ipers 424500 Monthly Cellular/PCS Total PERSONNEL SERVICES 431080 Recording Fees 432020 Annual Audit 432060 Consultant Services 432070 Management Services 433020 Local Phone Service 433030 Long Distance Service 435060 Legal Publications 436030 Transportation 436050 Registration 436060 Lodging 436070 Misc Travel 436080 Meals 437010 Comp Liability Ins 437020 Fire & Casualty Ins 437030 Worker's Comp Ins 437200 Loss Reserve Payment 36197.00 18068.52 2784.00 18128.48 49.92 20935.00 10981.42 1629.36 9953.58 52.45 4426.00 -4426.00 313.20 -313.20 1050.00 1050.00 100.00 11218.00 3305.52 550.92 7912.48 29.47 461.00 224.04 37.34 236.96 48.60 182.00 177.35 4.65 97.45 423.00 129.72 21.72 293.28 30.67 8544.00 8544.00 4983.00 2609.23 328.29 2373.77 52.36 3745.00 1842.00 255.21 1903.00 49.19 150.00 25.00 -150.00 ------------------------------------ 87738.00 43277.00 5631.84 7.00 139.00 12000.00 2259.00 8000.00 9000.00 63.89 24.00 13.09 11.47 650.00 332.20 775.00 200.00 875.00 1221.81 40.00 250.00 76.00 11936.00 7797.75 15515.00 10831.93 293.00 66.00 5000.00 1500.00 26.78 44461.00 49.33 7.00 138.00 9741.00 18.83 -1000.00 112.50 -63.89 10.91 54.54 -11.47 317.80 51.11 575.00 25.81 -346.81 139.64 -40.00 174.00 30.40 4138.25 65.33 4683.07 69.82 227.00 22.53 5000.00 H%PE: 01.04.07 12:41:50 Account Iowa City General Ledger System Budget to Actuals Expenditures Summary FY 2007 Expense Reporting For the period 12.01.06 to 12,31.06 YTD Period Appropriated Expenditures Expenditures ------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) SERVICES (CONTINUED) 438010 Stormwater Utility Charges 438030 electricity 438070 Heating Fuel/Gas 438080 Sewer Utility Charge 438090 Hater Utility Charge 439030 Testing Services 439060 Other Prof Services 441010 Vehicle Repairs and Maintenance 442010 Bldg Rep & Maint 442020 Repair of Structure 442030 Repair of Heating equip 442040 Repair of Cooling equip 442060 Repair of Electric/Plmbg 442070 Bldg Pest Control 443010 Equip Rep & Maint 443050 Radio Equipment Rep 443060 Telecom equip Rep 443070 Misc Comm equip Rep 443080 Other Repair & Maint 445060 Laundry Service 445070 Equipment Service 445090 Hauling 445140 Outside Printing 445230 Technical Services 446100 City Attorney Chgbck 446130 ITS-PC/Peripheral Support 446140 ITS -Computer Replacement Chargeb 446150 ITS -Application Development Fees 446160 ITS-Network/Internet Charge 446200 Photocopying Chgback 446220 Phone Service - Department Charg 446300 Phone Equipment/Line Charge 6512.00 15212.00 5539.00 1946.00 1342.00 956.00 1402.00 3500.00 207.00 252.00 30.00 250.00 100.00 1865.00 4074.00 763.00 863.00 301.00 458.00 2465.00 3818.00 875.00 600.00 510.00 192.00 484.00 963.00 3551.76 6183.92 539.50 729.11 682.63 357.60 141.40 2173.01 1629.81 281.50 1175.58 97.97 203.70 1236.64 1788.00 6688.00 444.00 1496.96 1670.05 400.00 118.74 300.00 217.50 288.72 325.00 591.96 126.20 206.01 141.70 129.34 191.50 33.95 74.00 277.14 39.58 30.00 64.14 48.12 Page: 2 Encumbrance Balance 9 Used ------------ ------------ ----- 2960.24 54.54 9028.08 40.65 4999.50 9.74 1216.89 37.47 659.37 50.87 598.40 37.41 -141.40 -771.01 154.99 1870.19 46.57 207.00 -29.50 111.71 -1175.58 -67.97 326.57 46.30 81.48 -1236.64 100.00 77.00 95.87 -6688.00 4074.00 763.00 419.00 51.45 301.00 458.00 968.04 60.73 2147.95 43.74 475.00 45.71 -118.74 600.00 210.00 58.82 -25.50 113.28 195.28 59.65 638.00 33.75 E%PE: 01.04.07 12:41:50 Page: 3 Iowa City General Ledger System Budget to Actuals expenditures Summary FY 2007 expense Reporting For the period 12,01.06 to 12.31.06 YTD Period Account Appropriated expenditures expenditures encumbrance Balance t Used --------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) SERVICES (CONTINUED) 446320 Mail Chargebacks 446350 City Vehicle Repl. 449060 Dues & Memberships 449140 Tools & Equip. Rent. 449360 Interest Expense Total SERVICES SUPPLIES 452010 Office Supplies 452030 Minor Off Equip/Furn 454020 Subscriptions 461040 Ag Chemicals 462020 Minor Sanitation Equip 462030 Sanit. & Ind. Supp, 465020 Gasoline 465050 Other Fuels 465060 Grease & Oil 465070 Other Lubricants 466020 Lumber/hardware 466040 Plumbing Supplies 466050 Electrical Supplies 466060 Bldg. & Improv. Mat. 467020 Minor Equip. Rep Mat 468020 Concrete 468030 Asphalt 468050 Sand 469040 Traffic Ctrl. Improv 469190 Tools & Minor Equip. 469210 First Aid/safety Sup 469320 Misc Supplies Total SUPPLIES 178.00 405.11 82.50 15098.00 5279.98 385.00 300.00 150.00 500.00 48157.00 24078.66 4013.11 ------------------------------------ 175260.00 94697.99 7726.03 -227.11 227.59 9818.02 34.97 85.00 77.92 500.00 24078.34 50.00 -------- ------ 80562.01 54.03 112.00 520.62 39.94 -408.62 464.84 500.00 500.00 193.00 108.00 85.00 55.96 127.00 234.95 -107.95 185.00 1000.00 857.94 142.06 85.79 292.00 859.71 242.99 -567.71 294.42 38.00 38.00 2582.00 1659.62 922.38 64.28 12.90 -12.90 34.00 34.00 167.00 167.00 35.00 3.01 31.99 8.60 203.76 -203.76 1113.00 1113.00 21.00 21.00 144.00 -144.00 1830.00 246.01 1583.99 13.44 47.00 47.00 228.00 228.00 883.00 257.14 625.86 29.12 54.39 -54.39 477.00 477.00 ------- ------------ 9679.00 ------------------------ 5162.05 282.93 ------------ 4516.95 ------ 53.33 EXPE: 01,04.07 12:41:50 Iowa City General Ledger System Budget to Actuals Expenditures Summary FY 2007 Expense Reporting For the period 12.01.06 to 12.31.06 Page: 4 YTD Period Account Appropriated Expenditures Expenditures encumbrance ------------ Balance 4 Used ------ ------------------------------------------------------ 7600 Airport (CONTINUED) ------------ ------------ ------------------------ 560100 Airport Operations (CONTINUED) CAPITAL OUTLAY 473010 Contracted Improvements 20000.00 21038.41 -8048.46 -1038.41 105.19 473020 Non -contracted Impr. 12463.00 12958.00 -495.00 103.97 474420 Other Oper. Equip. ------------ 99.98 ------------ ------------------------------------ -99.98 ------ Total CAPITAL OUTLAY 32463.00 34096.39 -8048.46 -1633.39 105.03 OTHER FINANCIAL USES 490150 Operating Subsidy 6259.00 6259.00 490190 Interfund Transfers Out-_ Fu 43543.00 21770.82 3628.47 21772.18 50.00 Total OTHER FINANCIAL USES ------------ 49802.00 ------------ 21770.82 --------- -- ------------ ------------ 3628.47 28031.18 ------ 43.71 Total Airport Operations ------------ 354942.00 ------------ ------------ 199004.25 ------------ ------------------------ ------------ 9220.81 ------------------------------------ 155937.75 ------ 56.07 ------ Total Airport 354912.00 199004.25 9220.81 155937.75 56.07 GRAND TOTAL +++ ------------ 354942.00 ------------ ------------ ------------ 199004.25 ------------ ------------ ------------------------ ------------ 9220.81 ------------------------------------ ------------------------------------ 155937.75 ------ 56.07 ------ ------ REVE: 01.04.07 12:41:57 Account ---------------------------------------- 7600 Airport 560100 Airport Operations MISCELLANEOUS REV. 369100 Reimb of Expenses Total MISCELLANEOUS REV. USE OF MONEY & PROP. 381100 Interest on Investments 382100 Land Rental 392200 Building/Room Rental 384200 Vending Machine Comm 384900 Other Commissions Total USE OF MONEY & PROP. OTHER FINANCING SOURCES 393120 General Levy Total OTHER FINANCING SOURCES Total Airport Operations Total Airport *** GRAND TOTAL *** Page: 1 Iowa City General Ledger System Budget to Actuals Revenues Summary FY 2007 Revenue Reporting For the period 12.01.06 to 12.31.06 Estimated YTD Period Revenue Revenue Revenue Remainder % --------------------- ------------------------------------ ------------ ------ 220.00 30.00 190.00 13.64 ------------------------ 220.00 ------------ 30.00 ------------ 190.00 ------ 13.64 800.00 337.65 462.35 42.21 37085.00 9943.22 -902.18 27241.78 26.54 174629.00 89158.00 16303.00 85471.00 51.06 132.30 -132.30 15000.00 11724.60 2804.10 3275.40 78.16 227514.00 111195.77 18204.92 116318.23 48.87 109000.00 54499.98 9083.33 54500.02 50.00 ------------------------ 109000.00 -------- 54499.98 ---------------- 9083.33 54500.02 ------ 50.00 ------------------------ 336734.00 ------------ 165725.75 ------------ 27289.25 171008.25 ------ 49.22 ------------------------ 336734.00 ----------- 165725.75 ------------ 27288.25 171008.25 ------ 49.22 ------------------------ 336734.00 ------------------------ ------------------------ ------------ 165725.75 ------------ ------------ ------------ 27288.25 ------------ ------------ 171008.25 ------ 49.22 ------ ------ TRID: 01.04.07 12:42:22 Page: 1 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 12,01.06 to 12.31.06 Trans ➢ate Trans Type Report# Source Description Debit Credit ----------- ---------- 7600 Airport ------------ ------------------------------------------------------- ------------ 560100 Airport Operations 411000 Perm Full Time 12.08.06 Old Sys 061206010007 470912\PAYROLL RECAP\PAYROLL 08-DEC 1392.00 12.22.06 Old Sys 061220010008 471251\PAYROLL RECAP\PAYROLL 22-DEC 1392.00 Total Perm Full Time ------------ ------------ 2784.00 412000 Perm Part Time 12.09.06 Old Sys 061206010007 470912\PAYROLL RECAP\PAYROLL 08-DEC 781.20 12.22.06 Old Sys 061220010008 471251\PAYROLL RECAP\PAYROLL 22-DEC 848.16 Total Perm Part Time ------------ ------------ 1629.36 421100 Health Insurance 12.12.06 Journal 061213083034 005449 dec BCBS\Dec health insurance old # 550.92 Total Health Insurance ------------ ------------ 550.92 421200 Dental Insurance 12.12.06 Journal 061213083034 005450 DEC DELTA DENTAL\Dec dental insuran 37.34 Total Dental Insurance ------------ ------------ 37.34 421400 Disability Insurance 12.12.06 New Vouch 061213030010 06855403 Check:591623\ASSURANT EMPLOYEE BENS 21.72 Total Disability Insurance ------------ ------------ 21.72 422100 Fica 12.08.06 Old Sys 061206010007 12080599\FICA\CITY CONTRIBUTION 161.58 12.22.06 Old Sys 061220010008 12220599\FICA\CITY CONTRIBUTION 166.71 Total Fica ------------ ------------ 328.29 423100 Ipers 12.08.06 Old Sys 061206010007 471233\IPERS\CITY CONTRIBUTION 125.68 12.22.06 Old Sys 061220010008 471564\IPERS\CITY CONTRIBUTION 129.53 Total Ipers ------------ ------------ 255.21 TRID: 01.04.07 12:42:22 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Trans Date Trans Type Report# Source Description ----------- ---------- ------------ -------- ----------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 424500 Monthly Cellular/PCS Page: 2 Debit Credit 12.08.06 Old Sys 061206010007 470912\PAYROLL RECAP\PAYROLL 08-DEC 12.50 12.22.06 Old Sys 061220010008 471251\PAYROLL RECAP\PAYROLL 22-DBC 12.50 Total Monthly Cellular/PCS 432070 Management Services 12.11.06 New Vouch Total Management Services 433020 Local Phone Service 12.06.06 New Vouch 061212030004 06855065 Check:591686\JET AIR INC\FEE 061207030048 06854994 Check:591492\IOWA TELECOM COMMUNCIA Total Local Phone Service 438010 Stormwater Utility Charges 12.20.06 Journal 061222101347 005458 057-095-03\STORMWTR\12.20.06 Bill D Total Stormwater Utility Charges 438030 electricity 12.20.06 New Vouch Total Electricity 438070 Heating Fuel/Gas 12.20.06 New Vouch 12.20.06 New Vouch Total Heating Fuel/Gas 438080 Sewer Utility Charge 12.20.06 Journal 12.20.06 Journal 12.20.06 Journal 12.20.06 Journal 061221030050 06855788 Check:591999\MIDAMERICAN ENERGY\ELE 061221030050 06855787 Check:591999\MIDAMERICAN ENERGY\GAS 061221030050 06855806 Check:591996\MIDAMBRICAN ENERGY\GAS 061222101347 005458 057-115-00\SEWER\12.20.06 Bill Date 061222101347 005458 057-117-00\SBWBR\12.20.06 Bill Date 061222101347 005458 057-118-03\SBNER\12.20.06 Bill Date 061222101347 005458 057-120-00\SEWER\12.20.06 Bill Date ----------- --- 25.00 1500.00 ------------ ------------ 1500.00 26.78 ------------ ------------ 26.78 591.96 ------------------------ 591.96 126.20 -------------------- 126.20 10.00 10.00 196.01 ------------ ------------ 206.01 41.96 45.76 24.94 29.04 Total Sewer Utility Charge 141.70 TRID: 01.04.07 12:42:22 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 12,01.06 to 12.31.06 Page: 3 Trans Date Trans Type Report# Source -------- Description ----------------------------------- ------------ Debit Credit ------------ ----------- 7600 Airport (CONTINUED( ---------- ------------ 560100 Airport Operations (CONTINUED( 438090 Water Utility Charge 12.20.06 Journal 061222101347 005458 057-095-03\WATER\12.20.06 Bill Date 6.41 12.20.06 Journal 061222101347 005458 057-115-00\WATER\12.20.06 Bill Date 43.38 12.20.06 Journal 061222101347 005458 057-117-00\WATER\12.20.06 Bill Date 36.31 12.20.06 Journal 061222101347 005458 057-118-03\WATER\12.20.06 Bill Date 20.09 12.20.06 Journal 061222101347 005458 057-120-00\WATER\12.20.06 Bill Date 23.15 ------------ ------------ Total Water Utility Charge 129.34 442030 Repair of Heating Equip 12,20.06 New Vouch 061221030050 06855697 Check:591986\LAREW COMPANY INC\HEAT 191.50 ------------ ------------ Total Repair of Heating Equip 191.50 442070 Bldg Pest Control 12.06.06 New Vouch 061207030048 06954861 Check:591354\HAWXEYE PEST CONTROL I 33.95 ------------------------ Total Bldg Pest Control 33.95 445070 Equipment Service 12.12.06 New Vouch 061213030010 06855281 Check:591769\ALLIED WASTE SERVICES\ 74.00 Total Equipment Service ------------ ------ 74.00 445230 Technical Services 12.11.06 New Vouch 061212030004 06855069 Check:591642\CTS TEXTILE LEASING\CL 29.48 12.11.06 New Vouch 061212030004 06855070 Check:591642\CTS TEXTILE LEASING\CL 29.48 12.11.06 New Vouch 061212030004 06855071 Check:591642\CTS TEXTILE LEASING\CL 29.48 12,27.06 New Vouch 061228030053 06855993 Check:592733\MIDWEST JANITORIAL SER 188.70 Total Technical Services ------------ ------ 277.14 446140 ITS -Computer Replacement Chargeback 12.01.06 Journal 061213083034 005440 I.S.-REPLACE CHG\ITS Dec replace ch 39.58 Total ITS -Computer Replacement Chargeback 39.58 TRID: 01.04.07 12:42:22 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Trans Date Trans Type Report# Source Description Debit ----------- ----------------------------------------------------------------- ------------ - 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED( 446160 ITS-Network/Internet Charge 12.01.06 Journal 061213083034 005441 ITS-NW/INTERNET CHG\Dec internet ch 30.00 Total ITS-Network/Internet Charge 30.00 446200 Photocopying Chgback 12.31.06 Journal 061222101347 005456 NOV PHOTOCOPY\Monthly photocopy chg 64.14 Page: 4 Credit Total Photocopying Chgback 64.14 446220 Phone Service - Department Chargebacks 12.19.06 Journal 061222101347 005459 Qwest Monthly Charge\ITS phone chgb 48.12 ------------------------ Total Phone Service - Department Chargebacks 48.12 446320 Mail Chargebacks 12.01.06 Journal 061213083034 005439 NOV POSTAL CHARGES\Monthly postal c 82.50 Total Mail Chargebacks 449060 Dues E Memberships 12.21.06 P-Card Total Dues E Memberships 449360 Interest Expense 12.31.06 Journal 12.31.06 Journal 12.31.06 Journal 12.31.06 Journal Total Interest Expense 452010 Office Supplies 12.21.06 P-Card ------------------------ 82.50 061229113134 ICCCVB\MICHASL THARP 150.00 ------------------------ 150.00 061213083034 005447 Corp Hangar Loan Int\Dec Interfund 1988.45 061213083034 005447 Airprt S-T HangarInt\Dec Interfund 40.28 061213083034 005447 Airprt SE Hangar Int\Dec Interfund 1017.02 061213083034 005447 Airprt SW Hangar-Int\Dec Interfund 967.36 ------------ ------------ 4013.11 061229113134 STAPLES 00106260\MICHASL THAR 39.94 Total Office Supplies 39.94 TRID: 01.04.07 12:42:22 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Page: 5 Trans Date Trans Type Report# Source Description Debit Credit ----------- ----------------------------------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 462030 Sanit. & Ind, Supp. 12.21.06 P-Card 061229113134 CORP EXPR 800-582-4774\MICHAEL THAR 242.99 ------------ ------------ Total Sanit. & Ind. Supp. 242.99 473010 Contracted Improvements 12.31.06 Journal 070103112124 005464 #591110 IL Pelling\Correct Acct Cod 8048.46 ------------ ------------ Total Contracted Improvements 8048.46 490190 Interfund Transfers Out-_ Fund 12.31.06 Journal 061213083034 005447 Corp Hangar Loan Prn\Dec Interfund 1011.55 12.31.06 Journal 061213083034 005447 Airprt S-T HangarPrn\Dec Interfund 1841.30 12.31.06 Journal 061213083034 005447 Airprt SE Hangar Prn\Dec Interfund 312.98 12.31.06 Journal 061213083034 005447 Airprt SW Hangar-Prn\Dec Interfund ------------ 462.64 ------------ Total Interfund Transfers Out --Fund 3628.47 Total Airport Operations 17269.27 8048.46 TRID: 01.04.07 12:42:22 Trans Date Trans Type Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Report# Source Description ----------- ---------------------- - 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Transfers Out-_ Fund (CON Total Airport Page: 6 Debit Credit ------------------------ 17269.27 8048.46 TRID: 01.04.07 12:42:22 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Trans Date Trans Type Report# Source Description ----- ---- ---- ---- ------- ----- ---------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Transfers Out-_ Fund (CON Page: 7 Debit Credit ------------------------ *** GRAND TOTAL *** 17269.27 8048.46 ------------------------ ------------------------ TRID: 01.04.07 12:42:29 Trans Date Trans Type Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Report@ Source Description ----------- ---------- ------------------- ---------------------------------- 7600 Airport 560100 Airport Operations 382100 Land Rental 12.01.06 Payment 061201092822 00004305 1-20\IC COM14 SCHOOL DIST\DEC 06\LAN 12.05.06 New Vouch 061206030004 06854613 Check:591527\WAL MART STORES INC\DU 12.27.06 Old Sys 070103010014 12271214\ARMY RESERVES\AIRPORT LEAS Total Land Rental 382200 Building/Room Rental 12.01.06 Payment 061201092822 00004304 1-10\MILLER RICHARD\DEC 06\HANGAR 12.01.06 Payment 061201092822 00004344 1-12\FISHBAUGH JUSTIN\DEC 06\HANGA 12.01.06 Payment 061201092822 00004345 1-16\OCEENFELS TRANSFER\DEC 06\HANG 12.01.06 Payment 061201092822 00004370 1-11\SQUADRONS DP\DBC 06\HANGAR #53 12.01.06 Payment 061201092822 00004377 1-6\POWERS ROBERT\DBC 06\HANGAR @9 12.01.06 Payment 061201092822 00004407 1-23\HERTZ CORPORATION\DEC 06\OFFIC 12.04.06 Payment 061204095304 00004382 1-5\STEARMAN\DEC 06\HANGAR #47 12.04.06 Payment 061204095304 00004388 1-2\MELLEC%BR BDWARD\DEC 06\HANGAR 12.04.06 Payment 061204095304 00004389 1-3\DOWNSS & ASSOCIATES\DEC 06\HANG 12.05.06 Payment 061205094231 00004333 1-10\SHANELIN DOUG\PAYMENT 12.05.06 Payment 061205094231 00004340 1-19\HARTWIG RANDY\DBC 06\HANGAR & 12.05.06 Payment 061205094231 00004343 1-7\SCHMEISER BUSS\DEC 06\HANGAR $ 12.05.06 Payment 061205094231 00004373 1-13\GURNBTT DON\DEC 06\HANGAR #34 12.06.06 Payment 061206092322 00004328 1-10\RANDY CHARLES\DEC 06\HANGAR @ 12.06.06 Payment 061206092322 00004383 1-9\SINGLBTARY ROBBRT\DBC 06\HANGA 12.07.06 Payment 061207093626 00003517 1-18\YEAGER DAN\SEPT 06\HANGAR #17 12.07.06 Payment 061207093626 00003517 1-18\YEAGER DAN\SEPT 06\HANGAR 026 12.07.06 Payment 061207093626 00003759 1-17\YBAGBR DAN\OCT 06\HANGAR 017 12.07.06 Payment 061207093626 00003759 1-17\YEAGER DAN\OCT 06\HANGAR 426 12.07.06 Payment 061207093626 00004123 1-19\YBAGBR DAN\NOV 06\HANGAR 417 12.07.06 Payment 061207093626 00004123 1-19\YEAGER DAN\NOV 06\HANGAR 026 12.07.06 Payment 061207093626 00004348 1-5\ANDERSON MAR%\DEC 06\HANGAR @6 12.07.06 Payment 061207093626 00004359 1-8\EDMONDS TERRY\DEC 06\HANGAR 05 12.08.06 Payment 061208092316 00004351 1-9\ALLBNDBR PATRICR\DEC 06\HANGAR 12.09.06 Payment 061208092316 00004374 1-4\ROOF, EBITH\DBC 06\HANGAR 832 12,09.06 Payment 061208092316 00004375 1-6\JET AIR INC\DBC 06\BUILDINGS D Page: 1 Debit Credit 353.92 1875.00 618.90 1875.00 972.82 153.00 158 186 153 121 100 153 132 153 153 153 186 310 121 121 132 132 50 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 132.00 132.00 132.00 132.00 175.00 285.00 153.00 512.00 3500.00 TRID: 01.04.07 12:42:29 Page: 2 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Trans Date Trans Type Report# Source Description Debit Credit ----------- 7600 Airport (CONTINUED) ---------- ------------ -------- ----------------------------------------------- ------------ 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 12.08.06 Payment 061208092316 00004378 1-2\OPERATOR PERFORMANCE LAB\DEC 06 1330.00 12.08.06 Payment 061208092316 00004378 1-2\OPERATOR PERFORMANCE LAB\DBC 06 153.00 12.08.06 Payment 061208092316 00004402 1-5\JET AIR\DEC 06\HANGAR #60 158.50 12.11.06 Payment 061211092920 00004124 1-3\ZIMMBRMAN GRBG\NOV 06\HANGAR # 132.00 12.11.06 Payment 061211092920 00004124 1-3\ZIMMBRMAN GREG\NOV 06\HANGAR # 132.00 12.11.06 Payment 061211092920 00004124 1-3\ZIMMBRMAN GRBG\NOV 06\HANGAR # 153.00 12.11.06 Payment 061211092920 00004124 1-3\ZIMMBRMAN GRBG\NOV 06\HANGAR # 153.00 12.11.06 Payment 061211092920 00004336 1-2\ZIMMBRMAN GRBG\DEC 06\HANGAR # 132.00 12.11.06 Payment 061211092920 00004336 1-2\ZIMMBRMAN GREG\DEC 06\HANGAR # 132.00 12,11.06 Payment 061211092920 00004336 1-2\ZIMMBRMAN GREG\DEC 06\HANGAR # 153.00 12.11.06 Payment 061211092920 00004336 1-2\ZIMMBRMAN GRBG\DEC 06\HANGAR # 153.00 12.12.06 Payment 061212094418 00004203 1-13\SWANSON, NAOMI\NOV 06\AIRPORT 121.00 12.12.06 Payment 061212094418 00004317 1-29\RUYLE JOHN\DEC 06\HANGAR #33 358.00 12.12.06 Payment 061212094418 00004332 1-3\BULGBRELLI DAVID\DEC 06\HANGAR 132.00 12.12.06 Payment 061212094418 00004338 1-5\MASCARI RICE\DEC 06\HANGAR #30 132.00 12.12.06 Payment 061212094418 00004387 I-2\KRUSE DAVE\DEC 06\HANGAR #18 132.00 12.12.06 Payment 061212094418 00004414 1-12\SWANSON, NAOMI\DEC 06\AIRPORT 121.00 12.13.06 Payment 061213093744 00003217 1-3\FARRIS GRBG\AUG 06\HANGAR #29 132.00 12.13.06 Payment 061213093744 00004330 1-5\BULLERS JONATHAN\DEC 06\HANGAR 121.00 12.13.06 Payment 061213093744 00004334 1-9\HOLLY FORRBST\DEC 06\HANGAR #1 132.00 12.13.06 Payment 061213093744 00004339 1-8\BUTLER JOHN\DBC 06\HANGAR #36 153.00 12.13.06 Payment 061213093744 00004339 1-8\BUTLER JOHN\DEC 06\HANGAR 137 153.00 12.13.06 Payment 061213093744 00004354 1-6\CRALKLEY BEN\DEC 06\HANGAR #14 132.00 12.13.06 Payment 061213093744 00004356 1-1\ZUBROD ROY\DEC 06\HANGAR 920 132.00 12.13.06 Payment 061213093744 00004379 1-7\WIECHERT RONALD\DEC 06\HANGAR 132.00 12.13.06 Payment 061213093744 00004395 1-2\ALEKIS PARE INN & SUITES\DBC 06 121.00 12.14.06 Payment 061214090925 00004337 1-5\HALL DAN\DBC 06\HANGAR #27 132.00 12.14.06 Payment 061214090925 00004350 1-3\NE IA PHYS THERPY ASSOC\DEC 06\ 180.50 12.14.06 Payment 061214090925 00004350 1-3\NE IA PAYS THERPY ASSOC\DZC 06\ 158.50 12.14.06 Payment 061214090925 00004355 1-7\TEARSE DAVID\DEC 06\HANGAR 141 153.00 12.18.06 Payment 061218092250 00004137 1-6\TUCKER JIM\NOV 06\HANGAR #38 153.00 12.18.06 Payment 061218092250 00004372 1-7\FLOOD BRYAN\DEC 06\HANGAR #19 132.00 TRID: 01.04.07 12:42:29 Page: 3 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Trans Date Trans Type Report# Source Description Debit Credit ----------- 7600 Airport (CONTINUED) ---------- ------------ -------- ----------------------------------------------- ------------ 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 12.18.06 Payment 061218092250 00004384 1-13\SAPPHIRE VISTAS LLC\DEC 06\HAN 132.00 12.18.06 Payment 061218092250 00004393 1-2\FLANAGAN JAMES\DEC 06\HANGAR # 132.00 12.18.06 Payment 061218092250 00004399 1-5\VRANSK DOUGLAS\DEC 06\HANGAR # 121.00 12.19.06 Payment 061219092737 00004329 1-12\SCHNELL TOM\DEC 06\HANGAR #4 158.00 12.19.06 Payment 061219092737 00004346 1-3\LACINA DAVE\DEC 06\HANGAR #57 180.50 12.20.06 Payment 061220094203 00003540 1-5\FARRIS GREG\SEPT 06\HANGAR #29 132.00 12.20.06 Payment 061220094203 00003782 1-4\FARRIS GREG\OCT 06\HANGAR #29 132.00 12.20.06 Payment 061220094203 00004146 1-3\FARRIS GREG\NOV 06\11ANGAR #29 132.00 12.20.06 Payment 061220094203 00004358 1-2\FARRIS GREG\DEC 06\11ANGAR #29 132.00 12.27.06 Payment 061227095249 00004130 1-6\FULL JSRRY\NOV 06\HANGAR #45 186.00 12.27.06 Old Sys 061228010005 12273013\GARY LUST MOUNTAIN\HANGER 121.00 12.28.06 Payment 061228094152 00004347 1-12\PATTSCHULL RICHARD\DEC 06\HAN 209.00 12.28.06 Payment 061228094152 00004536 1-11\MILLER RICHARD\JAN 07\HANGAR 153.00 12.28.06 Payment 061228094152 00004563 1-10\HALL ROBSRT\JAN 07\HANGAR #6 121.00 12.28.06 Payment 061228094152 00004575 1-9\SCHMEISER RUSS\JAN 07\HANGAR # 186.00 12.29.06 Payment 061229092708 00004551 1-4\BRUMLBY JAMES\JAN 07\HANGAR #2 132.00 12.29.06 Payment 061229092708 00004576 1-3\FISHBAUGH JUSTIN\JAN 07\HANGAR 158.50 12.29.06 Payment 061229092708 00004608 1-8\POWERS ROBERT\JAN 07\HANGAR #9 ------------ 121.00 ------------ Total Building/Room Rental 16303.00 384900 Other Commissions 12.20.06 Old Sys 061221010006 12203036\NEWTON HOME OIL\NOV 06 FLO 2804.10 Total Other Commissions ----------- ------------ 2904.10 393120 General Levy 12.31.06 Journal 061213083034 005443 Airport Prop Tx Supp\Dec Budgeted T 9083.33 Total General Levy ------------ ------------ ------------ 9083.33 Total Airport Operations ------------ 1875.00 29163.25 TRID: 01,04.07 12:42:29 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Page: 4 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ ------------------------------------------------------------------- 7600 Airport (CONTINUED( 560100 Airport Operations (CONTINUED( ------------ ------------ Total Airport 1875.00 29163.25 TRID: 01,04.07 12:42:29 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 12.01.06 to 12.31.06 Page: 5 Trans Date Trans Type Report# Source Description Debit Credit ----------- ---------- ------------ ------------------------------------------------------------------- 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) ------------------------ ttt GRAND TOTAL ++t 1875.00 29163.25 ------------ ------------ ------------------------ DF$GL_CUSTOM:CIPPROJ: 01.04.07 12:43:41 Page: 1 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Total Project Prior Fiscal This Year This This Year Remainder t G/L Account Description To Date Years To Date Month Budget In Budget Spent ------------- ------------ ----------------------------- ------------ ------------ ------------------------------------ ----- ttttYttttt4tt}ttf t4+tt44tt+t#t#Ttlt}4!4#4t##tt ttYtttt4#4444tlttttt# 3403 Airport North Commercial Park Old System #: 37410 titlttt}+ttt++ttYttt+ttttttttttttttttttttttttt+t+ttttt+ttttttttt+t+ RECEIPTS 560300 393140 AirCapAcq General Fund CIP Fu 33,603.73 33,603.73 560300 393240 AirCapAcq From Airport Operat 4,989.50 4,975.95 13.55 -13.55 560300 393411 AirCapAcq From 02 GO Bonds 16,161.72 16,161.72 ------------------------------------ ------------------------ ----------- ----- TOTAL RECEIPTS 54,754.95 54,741.40 13.55 -13.55 EXPENDITURES 560300 411000 AirCapAcq Perm Full Time 1,644.72 1,644.72 560300 413000 AirCapAcq Temporary Employees 152.00 152.00 560300 422100 AirCapAcq Fica 134.52 134.52 560300 423100 AirCapAcq Ipers 103.30 103.30 560300 431040 AirCapAcq Shorthand Reporter 278.95 278.95 560300 431080 AirCapAcq Recording Fees 262.00 262.00 560300 431111 AirCapAcq Engineering Service 693.00 693.00 560300 435060 AirCapAcq Legal Publications 51.70 38.15 13.55 -13.55 560300 439060 AirCapAcq Other Prof Services 800.00 800.00 560300 445240 AirCapAcq Nord Processing 12.36 12.36 560300 446100 AirCapAcq City Attorney Chgbk 37,150.99 37,150.99 560300 446200 AirCapAcq Photocopying Chgbk 25.00 25.00 560300 473010 AirCapAcq Contracted Improve 13,417.80 13,417.80 ------------ TOTAL EXPENDITURES ------------ 54,726.34 ------------------------ ------------ ----------- 54,712.79 13.55 -13.55 NET FOR PROJECT 28.61 28.61 DF$GL_CUSTOM:CIPPROJ: 01.04.07 12:43:41 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Page: 2 Total Project Prior Fiscal This Year This This Year Remainder t G/L Account Description To Date Years To Date Month Budget In Budget Spent ----------------------------------------------------------------------------------- ------------------------------ ----- Cash Balance: Beginning Balance: +t;tt}tttttttttttttfttttttttt;tttttttttttttt;tttt;;trttttttt;tttttt 3406 NB Property Development Old System $: 00000 tttiittt##ititi#t#4f}t#i4tffititti4i tf i#tttttkt#4itif!lititt t}}};}f EXPENDITURES 560300 432060 AirCapAcq Consultant Services 1,050.00 1,050.00 ------------ ------------ ------------ -- TOTAL EXPENDITURES 1,050.00 1,050.00 ------------------------------------ -- NET FOR PROJECT-1,050.00-1,050.00 Cash Balance:-1,050.00 Beginning Balance: f ti tttttit}tttt tlitttitt+fittttt titttttt ti tttttittttttttttitttttttt 3414 Runway 7 Extension Old System 0: 37490 tftttt}+f t4k4ff ttiktf kff titttitttt+i++}tttttttt#if ttttitttttt#t#i#t RECEIPTS 560300 331100 AirCapAcq Federal Grants 560300 393411 AirCapAcq From 02 GO Bonds 560300 393414 AirCapAcq From 05 GO Bonds TOTAL RECEIPTS -1,050.00 - ------------ ----------- ----- -1,050.00 DF$GL CUSTOM:CIPPROJ: 01.04.07 12:43:41 GAL Account ------------- EXPENDITURES Page: 3 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Total Project Prior Fiscal This Year This This Year Remainder % Description To Date Years To Date Month Budget In Budget Spent -------------------- ------------------------------------ ------------------------ ------------ ----- 560300 431111 AirCapAcq Engineering Service 560300 435060 AirCapAcq Legal Publications 560300 473010 AirCapAcq Contracted Improve ------------ ------------ ............ TOTAL EXPENDITURES NET FOR PROJECT Cash Balance: Beginning Balance: ttt}tti}t}}tt}titt tttt t#ttt}ttii iiti t t t t t t t t t t t t t i t t t i t}t t ti t tt t t it 3415 Building B,C,X Roof Replacement GAVI-IOW Old System #: 37430 it}iLitttttkttt#iti#iittttt#itt#1}ttttit#tttit#t#tittttt#}kkktk##ti RECEIPTS 560300 334900 AirCapAcq Other State Grants 560300 393140 AirCapAcq General Fund CIP Fu 560300 393411 AirCapAcq From 02 GO Bonds TOTAL RECEIPTS EXPENDITURES 40,641.68 40,641.68 12,372.95 12,372.95 6,807.04 6,807.04 ------------ ------------------------------------ -- 59,821.67 59,821.67 560300 431111 AirCapAcq Engineering Service 6,221.54 6,221.54 560300 432060 AirCapAcq Consultant Services 350.00 350.00 560300 433044 AirCapAcq Advertising 465.50 465.50 560300 442010 AirCapAcq Bldg Rep & Maint 42,509.90 42,509.90 9,358.00 9,358.00 3,636.00 3,636.00 --------- ----------- ----- 12,994.00 12,994.00 DF$GL_CUSTOM:CIPPROJ: 01.04.07 12:43:41 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Page: 4 Total Project Prior Fiscal This Year This This Year Remainder % GJL Account Description To Date Years To Date Month Budget ------------ In Budget Spent ------------ ----- ------------------------------------------ 560300 472010 AirCapAcq Building Improvemen ------------ ----------------------- ------------ 560300 473010 AirCapAcq Contracted Improve 9,899.94 9,899.94 13,369.00 13,369.00 TOTAL EXPENDITURES ------------ 59,446.88 ------------ ------------ 59,446.88 ------------------------ 13,369.00 ----------- ----- 13,369.00 NET FOR PROJECT ------------ 374.79 ------------------------ 374.79 ------------ Cash Balance: 374.79 Beginning Balance: 374.79 tttttitft#f#t}itt{4kttf4ittttttT}}ttttt};}}tttttf tki ttt#ffff;;tt44k 3416 Runway 7 Design, EA, FAA #10 Old System #: 37440 tt#t}4ftf}tt tf tff tff T}it};}ff44tttf}4}tttk4ff}tf }ttttttttttttf tT#fT RECEIPTS 560300 331100 AirCapAcq Federal Grants 560300 393140 AirCapAcq General Fund CIP Fu 560300 393411 AirCapAcq From 02 GO Bonds 560300 393414 AirCapAcq From 05 GO Bonds TOTAL RECEIPTS EXPENDITURES 560300 431111 AirCapAcq Engineering Service 560300 432060 AirCapAcq Consultant Services 560300 433044 AirCapAcq Advertising 560300 435060 AirCapAcq Legal Publications 560300 471021 AirCapAcq Temporary Basement 560300 471030 AirCapAcq Right -of -Way 560300 473010 AirCapAcq Contracted Improve 1,272,429.00 1,163,207.00 109,222.00 4,001.00 227,851.00 118,629.00 47.9 19,243.93 19,243.93 144,338.90 144,338.90-98,327.00-98,327.00 ------------ ------------------------------------ ----------------------- ----- 1,436,011.83 1,326,789.83 109,222.00 4,001.00 129,524.00 20,302.00 84.3 287,648.86 271,081.95 16,566.91 688.28-16,566.91 24,608.21 24,608.21 16.29 16.29 227.63 208.83 18.80 -18.80 3,592.18 3,592.18 33,952.62 33,952.62 877,770.98 831,974.98 45,796.00 189,566.00 142,770.00 24.3 DF$GL_CUSTOM:CIPPROJ: 01.04.07 12:43:41 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Page: 5 Total Project Prior Fiscal This Year This This Year Remainder t GAL Account Description To Date --- ---------------------------------------- Years ------------ To Date ------------ ------------ Month Budget In Budget Spent ------------------------ ----- ------------ TOTAL EXPENDITURES 1,227,816.77 ------------ 1,165,435.06 ------------------------ 62,381.71 ------------ ----------- - 688.28 188,566.00 126,184.29 33.1 ------------ NET FOR PROJECT 208,195.06 ------------ 161,354.77 ------------------------ 46,840.29 3,312.72 Cash Balance: 103,882.93 Beginning Balance: 57,042.64 fittttllT+tt}tffttttt4ftttttYitt4tttttt}tt444444ttt}f tttttttt4ttitt 3419 Aviation Commerce Park Site Development Old System q: 00000 +ttftt+tttttftttt+tt++++t+t++t+tft+t+tt+ttttttttt++t+t++++f+tt+fttt RECEIPTS 560300 362100 AirCapAcq Contrib 6 Donations 560300 393414 AirCapAcq From 05 GO Bonds TOTAL RECEIPTS EXPENDITURES 46,374.63 46,374.63 ------------ ------------ ------------------------ - 46,374.63 46,374.63 560300 432050 AirCapAcq Appraisal Services 2,800.00 2,800.00 560300 432060 AirCapAcq Consultant Services 54,792.21 43,574.63 11,217.58 ------------ ------------ ------------ ------------ TOTAL EXPENDITURES 57,592.21 46,374.63 11,217.58 NET FOR PROJECT-11,217.58-11,217.59 Cash Balance: Beginning Balance: -11,217.58 -11,217.58 -- ---------- -11,217.58 DF$GL CUSTOM:CIPPROJ: 01,04.07 12:43:41 Page: 6 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Total Project Prior Fiscal This Year This This Year Remainder G/L Account Description To Date Years To Date Month Budget In Budget Spent ------------------------------------------------------------------ ------------------------------------------------ ----- ++ttt++t++++ttttt+t+ttt+ttt+t+rrf++t++t+t+++ttt}t+}+tttt++f++++ttt+ 3420 Runway 7 Grading FAA #11 6 #12 Old System #: 37441 4tttfN}tttktf 4kkff#tf tttttfftlt+tttitttttttt44}}t}fff};}tt tYttttft RECEIPTS 560300 331100 AirCapAcq Federal Grants 560300 393140 AirCapAcq General Fund CIP Fu 560300 393416 AirCapAcq From 07 GO Bonds TOTAL RECEIPTS 135,057.00 110,379.00 24,678.00 4,156.00 39,621.00 14,943.00 62.3 14,558.40 14,558.40 -6,664.00 -6,664.00 ---------- ------------ 149,615.40 ------------------------ 124,937.40 24,678.00 ----------------------- 4,156.00 32,957.00 ----- 8,279.00 74.9 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 143,518.65 133,273.11 560300 473010 AirCapAcq Contracted Improve ------------ ....... TOTAL EXPENDITURES 143,518.65 133,273.11 ------------------------ --- NET FOR PROJECT 6,096.75-8,335.71 Cash Balance: 6,096.75 Beginning Balance:-8,335.71 tt+};}fft4Ytf it t}tttttttit}tttttitttttttt4ltkt}}}}}}f4}}t tt}t}f tttf 3421 Runway 7 Paving/Lighting FAA 114 Old System #: 00000 4f}tttf tttttf tttt}}t4t}ff}tttttttf ttf4}f t4}f tf tltkfffffffti}tlitttt RECEIPTS 10,245.54 1,353.45 24,622.00 14,376.46 41.6 10,245.54 1,353.45 24,622.00 14,376.46 41.6 --------- ------------ 14,432.46 2,802.55 560300 331100 AirCapAcq Federal Grants 2,129,425.00 2,129,425.00 DF$GL_CUSTOM:CIPPROJ: 01.04.07 12:43:41 Page: 7 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent ------------- ---------------------------------------- ------------------------ ------------------------------------ ----- 560300 393416 AirCapAcq From 07 GO Bonds 112,075.00 112,075.00 ------------ ------------------------ ----------------------------------- ----- TOTAL RECEIPTS 2,241,500.00 2,241,500.00 EXPENDITURES 560300 473010 AirCapAcq Contracted Improve 2,241,500.00 2,241,500.00 ----------------------------------------------------------------------- ----- TOTAL EXPENDITURES 2,241,500.00 2,241,500.00 NET FOR PROJECT Cash Balance: Beginning Balance: tf}f}f 4tk!}}}}}}kft#}k4tkkt}f}4tf4tttitf t}}}4tt#}4}}ttttt tf tint liT 3422 Airport Taxilane/Apron Pavement Rehab 91 Old System 0: 37496 ttttttt4ltt}ttf tlit}tttttt tilt}}t}}tttt ttti of f}}}tit}}}tttTTTTlf tt RECEIPTS 560300 334900 AirCapAcq Other State Grants 40,093.60 40,093.60 2,794.44 128,111.00 88,017.40 31.3 560300 393140 AirCapAcq General Fund CIP Fu 18,099.53 18,099.53 36,805.00 36,805.00 560300 393240 AirCapAcq From Airport Operat ------------------------ ------------ ------------ ------------ ---------- TOTAL RECEIPTS 58,193.13 18,099.53 40,093.60 2,794.44 164,916.00 124,822.40 24.3 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 26,329.06 11,844.55 14,484.51 644.32-14,484.51 560300 435060 AirCapAcq Legal Publications 92.78 92.78 -92.78 DF$GL_CUSTOM:CIPPROJ: 01.04.07 12:43:41 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Page: 8 Total Project Prior Fiscal This Year This This Year Remainder I G/L Account Description To Date Years To Date Month Budget In Budget ------------ Spent ----- ------------- ---------------------------- 560300 473010 AirCapAcq Contracted ------------ Improve 160,060.79 ------------ ------------ ----------- 160,060.79 9,048.46 ------------ 171,171.00 11,110.21 93.5 TOTAL EXPENDITURES ------------ 186,482.63 ------- --- 11,844.55 ------------------------ 174,638.08 8,692.78 --------- -- 171,171.00 ----------- -3,467.08 ----- 102.0 NET FOR PROJECT ------------ -128,289.50 ------------ 6,254.98 ------------ ------------ -134,544.48 -5,898.34 Cash Balance:-128,289.50 Beginning Balance: 6,254.98 tttfttttt+t+t}t+}}}}t}t+ttttt+}+}tttt+ft++tttftttf}ft}+tttttttt+tt+ 3424 Hard Surface Floors Bldgs B 6 C #9I-05-0 Old System #: 37495 t#ti ttf}4ttttttttt}tikt ttt444t44}i#}ktti}tf 4t4t#ltttttltTt444#itttt RECEIPTS 560300 334900 AirCapAcq Other State Grants 47,672.12 43,528.82 4,143.30 6,471.00 2,327.70 64.0 560300 393140 AirCapAcq General Fund CIP Fu 21,428.00 21,428.00 560300 393240 AirCapAcq From Airport Operat ------------ ----------------------------------------------------------- ----- TOTAL RECEIPTS 69,100.12 64,956.82 4,143.30 6,471.00 2,327.70 64.0 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 560300 435060 AirCapAcq Legal Publications 560300 472010 AirCapAcq Building Improvemen 560300 473010 AirCapAcq Contracted Improve TOTAL EXPENDITURES 8,889.83 8,889.83 84.45 84.45 59,128.75 56,172.31 2,956.44 68,103.03 65,146.59 2,956.44 ------------ ------------ ------------ - NET FOR PROJECT 997.09-189.77 1,186.86 6,281.00 3,324.56 47.1 -------- ----------- ----- 6,281.00 3,324.56 47.1 DF$GL_CUSTOM:CIPPROJ: 01,04.07 12:43:41 Iowa'City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 12.31.06 Page: 9 Total Project Prior Fiscal This Year This This Year Remainder V G/L Account Description To Date Years To Date Month Budget In Budget Spent ------------- ----------------------------- ------------ ------------------------ ------------------------ ------------ ----- Cash Balance: 997.09 Beginning Balance:-189.77 tt t44tf ttttttt#tit#tt4ittttiiiit++t4}if tf+4444f tt4t4tfft}tt++i+}+++ 3425 FAA Obstruction Removal #3-19-0047-13-20 Old System #: 37443 44 tf#t#1f##t#tttt###iki4t}##t4}tittttttf tttttit#tktti#}t#}ttttt4f t} RECEIPTS 560300 331100 AirCapAcq Federal Grants 494,388.00 560300 393140 AirCapAcq General Fund CIP Fu 8,555.21 560300 393416 AirCapAcq From 07 GO Bonds TOTAL RECEIPTS 502,943.21 EXPENDITURES 494,388.00 261,667.00 1,647,826.00 1,153,438.00 30.0 8,555.21 86,728.00 86,728.00 -------------------------------------------- ----------- ----- 8,555.21 494,388.00 261,667.00 1,734,554.00 1,240,166.00 28.5 560300 431111 AirCapAcq Engineering Service 116,050.32 8,370.68 107,679.64 17,397.86 288,300.00 180,620.36 37.4 560300 435060 AirCapAcq Legal Publications 209.90 184.53 25.37 -25.37 560300 449055 AirCapAcq Permitting Fees 300.00 300.00 -300.00 560300 473010 AirCapAcq Contracted Improve 558,472.20 --------•--------------- 558,472.20 ------------ 91,967.79 ------------ 1,446,254.00 887,781.80 38.6 ----------------------- ----- TOTAL EXPENDITURES 675,032.42 8,555.21 666,477.21 109,365.65 1,734,554.00 1,068,076.79 38.4 NET FOR PROJECT --------- ------------ -172,099.21 ------------ -172,089.21 ------------ 152,301.35 Cash Balance:-172,089.21 Beginning Balance: