Loading...
HomeMy WebLinkAbout10-11-2007 Airport Commissions IOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, OCTOBER 11, 2007-5:45P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: a. September 13, 2007; September 24, 2007 3. Public Discussion- Items not on the agenda 4. Items for Discussion/Action: a. Aviation Commerce Park b. Farmers National Company c. Hangar#56—Terry Edmonds d. FAA/IDOT Projects-Earth Tech—David Hughes i. Runway 7/25 ii. South Aviation Development Study iii. South Taxilane Rehab iv. Hangar A&B Doors 1. Consider a resolution accepting Hangar A&B Door as complete v. Jet A Fuel System/AvGas Upgrade • vi. Terminal Apron Rehab vii. Obstruction Mitigation e. Airport "Operations": Strategic Plan-Implementation; Budget; and Airport Management i. Hangar G Roof Repair ii. FY2009 Operations Budget t FBO Staff Report g. Subcommittees' Reports h. Commission Members' Reports i. Staff Report 5. Set next regular meeting for November 8, 2007 at 5:45 p.m. 6. Adjourn MINUTES DRAFT Iowa City Airport Commission September 13,2007 Iowa City Airport Terminal—5:45 PM Members Present: Howard Horan, Chair; Randy Hartwig; Greg Farris;Janelle Rettig Members Absent: John Staley Staff Present: Sue Dulek,Michael Tharp Others Present: Jay Honeck,David Hughes,Jim Druesicke, Peggy Slaughter, Randy Miller,John Yeomans,Phillip Woolford DETERMINE QUORUM: The meeting was called to order at 5:46 P.M.by Horan. RECOMMENDATIONS TO COUNCIL: APPROVAL OF MINUTES FROM THE AUGUST 9,AUGUST 13,AND SEPTEMBER 5,2007 MEETINGS: Hartwig noted a correction to the August 9th minutes clarifying the"self service"to include fuel pump. Hartwig moved to accept the minutes of August 9,August 13,and September 5, 2007 as amended; seconded by Farris. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: a. Aviation Commerce Park—Peggy Slaughter and Randy Miller introduced themselves to the Commission, as the new realtors who are working on the North Commerce Park land sales. Slaughter and Miller expressed a desire to re-market the lots as individual lots instead of a single lot. Slaughter and Miller gave a description of the marketing tools they would be using. Hartwig asked about the pricing model. Slaughter gave out copies of the pricing and what the proposed changes. Rettig commented that the new pricing model was$900,000 lower than the current pricing. Miller commented that this is a result of the land going from commercial retail back to more industrial, and that the previous model took into account a scenario that did not get completed. i. Consider a resolution approving amendment#7 to the listing agreement— Consider Resolution#A07-23 approving Amendment#7 to listing 1 V Airport Commission September 13,2007 Page 2 of 6 agreement; moved by Farris,seconded by Hartwig. Carried 4-0, Staley Absent. b. Ruppert Property—Moved to after item C . Dulek gave the commission a description of the property and background of this property. Dulek related that the owner had recently passed away and the estate had contacted her regarding interest in purchasing the land again. Horan noted this land is currently not able to be developed commercially due to its location at the end of the runway. Rettig commented that she was not in favor of paying commercial prices,but instead the land should be pursued as agricultural priced land. c. Land Lease With Westside Auto i. Public Hearing—Chairperson Horan opened the public hearing.No Comments. Chairperson Horan closed the public hearing. ii. Consider a Resolution Approving Lease with Westside Automotive— Dulek gave the commission a description of the lease. Westside Auto wishes to place a sign in the Runway Protection Zone in return for mowing and maintenance services for the rest of the runway protection zone. Rettig described that she was uncomfortable with a 20 year lease,but was favorable to a 10 year lease with options. Dreusicke gave the Commission a description of the sign placement. Tharp commented that he wasn't in favor of accepting the lease terms without having the airspace study completed. Consider Resolution#A7-24 approving Lease for Westside Auto; moved by Rettig, seconded by Farris. Carried 3-0; Hartwig recused,Staley Absent. d. University of Iowa/Operator Performance Labs i. Consider a Resolution Approving Letter of Intent(deferred from 8/9/07)— Tharp gave the commission copies of the letter as accepted by the University. Tharp described the letter and conditions to the commission. Tharp noted that the lease terms would be a 5 year lease with 5 year options. Tharp also noted the project costs were capped at$400,000,and described the formula that would be used to calculate the first rental term. Rettig asked about a previous number that had been considered and Tharp responded. Consider Resolution #A07-25 approving Letter of Intent; moved by Hartwig,seconded by Farris. Carried 4-0,Staley Absent. e. FAA/IDOT Projects—Earth Tech—David Hughes i. Runway 7/25 1. Update—Hughes commented that the airport received a grant offer of approximately$1.7 million. Hughes noted that he had met with the contractor and they are ready to begin when notice is given. Horan asked about the runway closure timing. Hughes responded that the runway would be closed on a daily basis for the installation of the new lighting 2 I Airport Commission September 13,2007 Page 3 of 6 system,and then later a full closure for approximately 5 days to remark and finish installation of the lighting. Rettig asked what the grant was finding,to which Hughes responded. Rettig asked about a piece of land that had an offer for sale on in the past.Hughes responded that the land in question could be sold after the new runway was open. 2. Consider a Resolution Accepting FAA Grant 3-19-0047-14 for paving/lighting project—Consider Resolution#A07-26 accepting FAA Grant 319-0047-14; moved by Rettig, seconded by Hartwig. Motion Approved 4-0,Staley Absent. ii. South Aviation Development Study—Hughes commented they are still waiting on a finalized willow creek study. Hughes commented they will be setting up a meeting with the new planning director to update him on the study. iii. South Taxilane Rehab—Hughes noted they met with the contractor to discuss the known issues. He commented he was waiting for a response from the contractor as a proposed fix. iv. Hangar A&B Doors—Hughes noted that the doors were in and that some of them need some corrective action. v. Jet A Fuel System/AvGas Upgrade—Hughes noted they had put together a packet for a competitive quote process and will incorporate changed suggested by Dulek. Dulek noted that this is a new process resulting from a change in the bidding laws. Hughes described the location of the Jet A pump for the commission. 1. Consider a Resolution Approving Competitive Quotation Process—Consider Resolution#A07-27 approving Competitive Quotation Process; moved by Rettig; seconded by Farris. Motion Approved 4-0, Staley Absent. vi. Terminal Apron Rehab—Hughes noted that they had received bids and 3 of 4 were under the engineers estimate. Hartwig asked about the timeline for the contract. Hughes noted the contract is 45 days and they would start around the 24th,and would place completion around Halloween. Rettig asked about the affects of on the planes being parked. Woolford noted they would begin making some temporary tie-down spots in the grass area. Rettig asked about fueling. Hughes noted the self serve system would be out of service for the duration of the construction. 1. Consider a Resolution Awarding Contract—Consider Resolution#A07-28 awarding contract; moved by Farris; seconded by Rettig. Motion Approved 4-0,Staley Absent. vii. Obstruction Mitigation—Hughes noted that some of the poles have been checked by the FAA and there was a new concern that • developed. Hughes noted they are continuing to work with Mid- American to get a proposal that is acceptable to everyone. 3 Airport Commission September 13,2007 Page 4 of 6 viii. 405 Approach Surveys—Hughes noted the survey data has been accepted by the FAA, and dates are in the system for 2008. Approaches are being designed for all the runway ends. f. Farmers National Company i. Management Agreement—Tharp noted that the contract with Farmers National for the farming management provides the airport commission an opportunity to cancel the contract by September 30. Tharp noted that he is recommending a continuation of the lease and that John Yeomans was present to give the commission an update on the rental plans. ii. Farm Operations Update—Yeomans commented that previously the lease had been variable based on the crop yields. This creates a situation where some government payments that the farmer could be eligible for doesn't currently allow for payments to be made. Rettig commented that she does not feel the airport should be eligible for government payments. Yeomans described the lease types noting that all the leases make the farmer eligible for some government payments. Rettig asked about the amount of money the government has paid to the airport or farmers renting the airport land. Yeomans described the current farm bill status and certain scenarios. Yeomans noted that without allowing farmers to collect eligible payments the farming operations would be difficult to maintain. g. Airport"Operations": Strategic Plan-Implementation;Budget; and Airport Management—A budget planning/CIP session was set for September 24th at 5:45 P.M. Rettig asked a question about page 5 of the budget,Fuel Charge- back. Tharp explained that this has been a change in how this item is listed. Rettig asked for clarification on several budget items,with Tharp responding to her questions. Hartwig also responded to some of the items,noting that they may want to consider stopping the magazine subscriptions as magazine are disappearing. Horan noted that they did have a Personnel meeting regarding a raise for Tharp. He will take the assembled comments and meet with Tharp to go over these. h. FBO Staff Report—Woolford spoke about the Sertoma event and how well it went. Tharp asked if anyone had any pictures from this event to share for the newsletter. Rettig stated that she believes Woolford should take part in the budget meeting,since the FBO is an important part of the Airport. Rettig also asked about the ground school and what the status is currently. Woolford responded to her questions, stating that they have 4 or 5 part-time flight instructors currently, some of whom work at the University. Rettig asked about military personnel,once they leave the service,participating in flight 4 C Airport Commission September 13, 2007 Page 5 of 6 school. A brief discussion ensued on this. Tharp responded to Hartwig's questions regarding signage. i. Subcommittees' Reports—None. j. Commission Members' Reports—Rettig noted that she feels they should figure out exactly what the regulations are for hangar space. Hartwig noted that he believes it would be a good idea for the newsletter to spotlight people at the Airport, and to have information on the bulletin board about the area. Hartwig also noted that he has talked with Tharp about directional signage at the Airport. Farris spoke briefly about the shelter area, stating that they are attempting to get the foundation poured and the posts installed in this season. He also noted that the information that Tharp gathered for the Council candidates was very helpful, and he thanked Tom for the tour. Horan noted that at 9:30, September 14,Dave Loebsack will be at the Airport for a press- type meeting,to explain the runway extension,and what the federal money does for the community. Horan also noted that in regards to hangars, leases, and the review,he would like to see Tharp publish this when he goes through each hangar. He stated that for this year their hangar policy is in place. Horan stated that he did some calling around to see what it costs to store a car or a boat, on a monthly basis. He stated that he is concerned about any hazardous materials that may be stored in hangars,but that he feels they shouldn't work too hard on this policy. k. Staff Report—Tharp noted that the FAA conference is in October,the 211d and 3rd in Kansas City. He will be attending,and asked if any other Members would like to join him. He briefly gave a run-down of the conference schedule. Rettig next brought up the topic of the parking policy, and stated that she would like to see this project finished as she is seeing vehicles that need to be removed, and also the room rental policy that they previously discussed. Dulek noted that the easement issue is on the City Council's upcoming meeting agenda,as is the public hearing regarding this. SET NEXT REGULAR MEETING FOR: September 24,2007 at 5:45 P.M.budget meeting;and regular meeting is October 11,2007 at 5:45 P.M. ADJOURN: Meeting adjourned at 7:55 P.M. 5 Airport Commission September 13,2007 Page 6 of 6 Airport Commission ATTENDANCE RECORD YEAR 2007 (Meeting Date) TERM 1/11 2/8 3/8 3/28 4/12 5/10 5/15 6/7 6/8 6/28 7/9 7/19 NAME EXP. Randy Hartwig 3/1/09 X X X X X X 0 X X X X X Greg Farris 3/1/13 O/E X X O/E X X X X O/E X X X John Staley 3/1/10 X X X X X X 0 X O/E O/E X X Howard Horan 3/1/08 X X X X X X X X X X X X Janelle Rettig 3/1/12 X X X X X X X X X X O/E O/E TERM 8/1 8/9 8/13 9/5 9/13 NAME EXP. Randy Hartwig 3/1/09 X X X X X Greg Farris 3/1/13 X X X X X John Staley 3/1/10 O/E X O/E O/E O/E Howard Horan 3/1/08 X X X X X Janelle Rettig 3/1/12 O/E X O/E O/E X KEY: X = Present 0 = Absent O/E= Absent/Excused NM= No meeting — = Not a Member 6 )119 MINUTES DRAFT Iowa City Airport Commission • September 24,2007 Iowa City Airport Terminal—5:45 PM Members Present: Howard Horan, Chair; Randy Hartwig; Greg Farris; Janelle Rettig Members Absent: John Staley Staff Present: Michael Tharp Others Present: Larry Swanson;Dan Yeager;Forrest Holly; Leslie Bingham; Phillip Woolford DETERMINE QUORUM: The meeting was called to order at 5:46 P.M.by Horan. PUBLIC DISCUSSION: Horan asked the attending public to give comments, or ideas they had come with. Swanson addressed the commission and gave a brief summary of his background. Swanson commented that he felt the communications coming from the airport were well done, and that he was being kept informed of projects and plans that the airport has. Holly commented on his desire to see WAAS approaches at the airport. Holly also commented that he's glad to see the airport commission attempting to increase the community stake in the airport. He also commented that he appreciated the development of the airport viewing area and hoped the commission would continue its activities. Yeager commented his desire to see the airport commission create more hangar space. He also commented that increasing the public awareness and ability to use the airport should be a priority. Yeager commented his desire to see a sidewalk system out to the airport as well as along the airport road. Rettig commented that there is a trail system planned for the area surrounding the airport however in the recent years its been unfunded. Yeager commented that making the airport a destination stop on the trail system would be a possible way to increase the non-aviation public's use of the facilities. Yeager also commented that a web cam at the airport could be used to show activity through the intemet and be another way to increase public awareness. ITEMS FOR DISCUSSION/ACTION: 1. Budget Work Session— FY 2009 and future Operation and Capital Improvement Plan Budgets— Horan asked each commissioner to speak 1 v Airport Commission September 24,2007 Page 2 of 4 regarding their thoughts of projects the airport commission should consider as they prepare future budgets. Hartwig commented that he divided his lists among airfield (runway) and landside projects. He commented that continuing with the FAA planned projects. Hartwig note that the airport is still continuing its study regarding the south land and that the interest in preserving land for the grass landing runway is still there. Hartwig noted that other projects that he'd like to see considered include a bike path/trail, continuing the replacement of access doors on Hangar C, continuing the currently budgeted areas, such as fencing and pavement repair. Screening for the dumpsters so they are not visible to taxing aircraft. Hartwig also noted that some other external security cameras to monitor areas of the airport would benefit security. Hartwig also noted asphalt areas around building D. Hartwig commented on aircraft space needs stating he felt the airport should consider some hangar space similar to Building F. Rettig commented on mechanical issues. Rettig stated that the air condition unit annual has repair issues and feels that a closer study needs to be done on the system. Rettig commented that the commission should look at all the mechanical items and figure out where they are in their life span and program some replacement costs. Rettig commented that she'd like to see landscaping work done in the areas around the terminal and replace our fencing around the outside perimeter that is viewable to the general public. Rettig commented that she'd like to see the conference room used more, and any necessary seating should be obtained. Rettig also commented that the commission should focus on hangar space needs and finding a way to increase the space needs that are currently in demand. Rettig commented about wildlife mitigation and the pond behind Wal-Mart. Rettig asked if there was something that could be done regarding this area. Farris commented regarding lighting around the apron. Farris commented he'd received requests to look at extending wireless intemet to the hangar areas, for tenants to do flight planning and weather retrieval. Farris commented that continued work on the viewing area should be considered. Horan noted that a maintenance building for the airport equipment should be considered. Horan noted that he also felt a large hangar would be appropriate. Horan commented the potential about rehabilitation of the south end of 18/36 as a possible taxiway or service area. Horan questioned about the willow creek study and would some of those costs be funded by the airport. Horan also commented about a taxiway route to the north commerce park for potential development of an aeronautical enterprise. Horan noted that the 12-30 parallel taxiway wasn't in the FM plan and that he felt it should be. Rettig discussed the potential for leasing the new hangar to the FBO and Woolford responded that Jet Air would be interested in renting the facility. Rettig asked that about the status of the National Guard. Tharp noted that he'd like to see the commission continue the rehabilitation of pavements that have been ongoing noting the areas that have been replaced and the 2 ' Airport Commission September 24, 2007 Page 3 of 4 areas that could still need attention. Tharp commented he felt there is a market for new space. Tharp also commented that maintenance staff has requested the purchase of a larger mower blade in order to cover more ground, and to mow the increased amounts of land that are being put back , into grassland. Woolford commented regarding a second lighted windsock located in the southern area for aircraft to be able to view. Horan asked for consensus on what would be in the capital budget for the next fiscal year. The Commission agreed that the capital budget expenses should be focused on a large hangar and that they should be able to budget some money for the operational items that had been proposed. ADJOURN: Meeting adjourned at 8:15 P.M. 3 1111 Airport Commission September 24, 2007 Page 4 of 4 Airport Commission ATTENDANCE RECORD YEAR 2007 (Meeting Date) TERM 1/11 2/8 3/8 3/28 4/12 5/10 5/15 6/7 6/8 6/28. 7/9 7/19 NAME EXP. Randy Hartwig 3/1/09 X X X X X X 0 X X X X X Greg Farris 3/1/13. O/E X X O/E X X X X O/E X X X John Staley 3/1/10 X X X X X X 0 X O/E O/E X X Howard Horan 3/1/08 X X X X X X X X X X X X Janelle Rettig 3/1/12 X X X X X X X X X X O/E O/E TERM 8/1 8/9 8/13 9/5 9/13 9/24 10/11 NAME EXP. Randy Hartwig 3/1/09 X X X X X X Greg Farris 3/1/13 X X X X X X John Staley 3/1/10 O/E X O/E WE O/E O/E Howard Horan 3/1/08 X X X X X X Janelle Rettig 3/1/12 O/E X O/E O/E X X KEY: X = Present O = Absent O/E= Absent/Excused NM= No meeting -- = Not a Member 4 Iowa City Airport Commission 8-23-2007 Iowa City Airport 1801 S Riverside Drive Iowa City, Iowa Dear Commissioners; I am the lessee of Hangar#56 and writing concerning the hangar lease renewal. Hangar#56 is a T hangar on the end of the building and is odd shaped creating some extra space in the back because of its location within the building. The extra space in the back is too small for a second aircraft. It is obvious the design of the building was for storage of land based vehicles in the rear since a garage door was installed on the side of the hangar for access tb this extra space rather than another hangar door. The rental rate I have been charged for Hangar#56 is considerably higher than the other Ts because of this extra space. I have been using the extra space to park some classic automobiles along with my aircraft to utilize the space I have been paying for. I believe I am using the space as designed for with an aircraft behind the hangar door and some land based vehicles behind the garage door. I would like to point out there is a corresponding garage door and storage space at the opposite end of the same hangar building. The difference is this space is partitioned off from other T hangar spaces and as such solely used for non aircraft storage. The terms of the new lease would raise my rental rate to $304 per month or$3,648 per year. $3,648 is an unreasonable cost for the city to ask me to pay for hangaring a single aircraft for one year if I am not allowed to use the extra space for other things. I have been a supporter of the Iowa City Airport for many years and almost always displayed my motor glider at the various events held there.My unusual motor glider lends diversity to the aircraft at the Iowa City Airport. I respectfully request to continue to use the extra hangar space as I have been.The hangar is always kept clean and there are no junk or other items in there. In fact the classic autos give a pleasant backdrop to my aircraft up front. 1 , Terry Edmonds �rr • Michael Tharp From: Hughes, David ( Des Moines)[David.Hughes©earthtech.com] Sent: Thursday, October 04, 2007 1:53 PM To: Howard Horan Cc: Michael Tharp; Sue Dulek; Eaton, Steve Subject: IOW Project Update Howard, Here's a summary of the projects as of October 2, 2007. Box Culvert(AIP-10) We will close out grant/project once Historic Booklet has been completed. ' Iowa City Airport—Public Historic Booklet(AIP-10) We are in the process of finalizing the layout on the Historic Documentation Pamphlet for the airport. The copy editor has made a final review of the document and their revisions are being incorporated in the text. Tallgrass Historians is working the SHPO to obtain higher resolution photographs to use in the document Engineering Services for Runway Grading (AIP-11) This grant is completed. Closeout documentation requires updated Exhibit "A"- Airport Property Map.We are working with City Legal to complete the closeout of this project South Airfield Planning Study(AIP-12) A meeting was held last week to discuss the study with city planning and obtain their comments on the draft report. Grading (AIP-13) Project has been completed with the exception of placing rip rap in the Willow Creek Stream channel just south of Highway 1. The utilities that were in the way have been relocated and contactor will complete as weather allows. Obstruction Mitigation (AIP-13) We have received completed airspace reviews of the proposed Mid-American / Mediacom relocation. We have been working with Mid-American to identify easement requirements on the airport property and the adjacent auto dealership. Mid-American is reviewing these along with coordination of installation of their line in Iowa DOT ROW. Once Mid-American has determined that easements are sufficient, the commission/city will have to act on these. Paving and Lighting (AIP-14) Contractor has started grading on this project. He anticipates beginning installation of drainage elements next week and then will move forward with rock base for construction of the pavement section. Contractor has received approvals on materials for airfield lighting and is awaiting delivery of these. We anticipate that contractor will start daily closures of runway in about 3 to 4 weeks to begin electrical work. Contractor is approximately 5% complete on the project. Taxilanes—South Area(2007 State Grant) We continue to work with the contractor to resolve outstanding items on this project 10/5/2007 T-Hangar A& B Doors (State Grant) Project is completed. Contractor has recently made adjustments to all doors. Final acceptance is on the agenda. Terminal Apron Rehabilitation (AIP Recapture) Contractor has started work on the apron including pavement removal and installation of storm sewer. Contractor should complete grading next week and construct rock base for pavement section. Contractor's schedule indicates beginning paving in this area in mid-October. Project is approximately 18%complete on this project. David B. Hughes, P.E. Earth Tech Des Moines, IA 515-244-1470 515-244-4803 fax 10/5/2007 EarthTech 500 S.W.7th Street p515.244.1470 Suite 301 F 515.244.4803 A tl/Cn International Ltd.Company Des Moines,IA 50309 www.earthtech.com October 4, 2007 Mr. Howard Horan Iowa City Airport Commission 1801 S.Riverside Drive Iowa City, IA 52246 RE: Replace Pedestrian Access Doors, Hangars"A"and"B" Iowa City Municipal Airport City of Iowa City,Iowa GAVI No.9I-05-0IOW-300 Earth Tech ID No.88056 Dear Mr.Horan: By this letter,we hereby state: 1. We have made a final review of the project on September 5, 2007 and subsequent review of the project on September 12, 2007. 2. To the best of our knowledge and belief, based on observations of Earth Tech staff during construction, the contractor,Liberty Doors,Inc has performed the work in accordance with the proposal requirements in effect for the above-referenced project. 3. The total cost of the completed work is $16,700.00. I hereby certify that this engineering document was prepared by me or under my "ot Es siON"'" direct personal supervision and that I am a duly licensed Professional Engineer a%0.""••••..4,-`'. under the laws of the state of Iowa. We .Z • "+• DAVID B :d5 ` Z • HUGHES -I 13037 1Z41A\3. kk-•4"''"--• 149 /01 David B.Hughes Date {oW,A• License No. 13037 My license renewal date is December 31,2007. Pages or sheets covered by this seal: L kworkpmjcct2S056lwpWanselUi I00407.IIr.doc STATEMENT OF COMPLETION AND FINAL ACCEPTANCE OF WORK AIRPORT PROJECTS Op♦,.MNMaLLm Contract# 07289 Project# 9I-05-OIOW-300 Airport Name Iowa City Municipal Airport Sponsor City of Iowa City Type of Project General Aviation Vertical Infrastructure (General Aviation Vertical Infrastructure or Airport Improvement Project) Description of Project Project involved replacement of pedestrian access doors in Hangars A and B at the Iowa City Municipal Airport. Project Complete and Recommended for Acceptance Signature Project Engineer or Project Manager Date: October 4 2007 Approved and Work Accepted on Behalf of the City/Aviation Authority/Airport Commission Name: Howard Horan Title: Airport Commission Chair Signature Date: October 11, 2007 Sponsor Representative Signature Date: Office of Aviation Program Manager EarthTech 500 S.W.7th Street p515.244.1470 Suite 301 F 515.244.4803 A tqo International Ltd.Company Des Moines, IA 50309 www.earthtech.com October 5, 2007 Mr. Howard Horan Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 RE: Jet-A Self Service Fueling System Iowa City Municipal Airport Iowa City,Iowa Earth Tech ID No. 88056 Dear Mr. Horan: We have reviewed the quotes received by the City of Iowa City on September 28, 2007, for the above- mentioned project. A copy of the quote tabulation is attached to this letter for reference. Two quotes were received. After receipt of quotes, we requested that company provide a detailed list of materials for review. Acterra Group of Marion, Iowa, was the low quote received in the amount of$80,458.41. The low bid was higher than the engineer's estimate by $4,958.41. Acterra Group also provided pricing for additional items that they had discussed previously with Jet Air including a nozzle with swivel and an impact valve for the sumps. These value added items add an additional $2,910.00 to Acterra Group's quote. We have reviewed these items and recommend these be added to the project. We would recommend award of a contract in the amount of$83,368.41 to Acterra Group for this project. If you have any questions or need additional information, please contact our office at your convenience. Very truly yours, Earth Tech David 13. Hughes,P.E. Enclosures: As noted Cc: Ms.Kay Thede, Iowa DOT(w/enclosure) L:work'projcce97670e puansc\HH100507.11r.doc TABULATION OF QUOTES IOWA CITY MUNICIPAL AIRPORT IOWA CITY,IOWA PROJECT:JET-A SELF SERVICE FUELING SYSTEM AND MODIFICATIONS TO EXISTING AV-GAS SELF SERVICE FUELING SYSTEM IDOT Project No.3-19.0047-14 Earth Tech No.88056 Date:September 28,2007 Engineer's Estimate $ 75,500.00 Aceterra Group Marion,Iowa $ 80,458.41 Illinois Oil Marketing Equipment Pekin, Illinois $ 113,437.00 Checked by: Earth Tech Inc. EarthTech Aly Jo WtuIiooaI LIQ Condo, • Monthly Expense Report - August 'O7 Check Requests During Month Approved Airport Funds CIP Funds Check Requests 9/4/2007 Van Meter Industrial(Light Bulbs Runway/1'erminal) $139.26 9/4/2007 Signs&Screenprinters(Number Decals Hangar A/B Doors) $47.85 9/4/2007 Dan's Overhead Door(Bldg H Door Repair) $1,087.00 9/4/2007 Jet Air(Management Fees) $750.00 9/17/2007 Stanley Roofing(Roof Repair-Hangar G) $6,930.00 9/17/2007 Banes Construction(Hangar A Retainage) $2,069.91 9/17/2007 Dan's Overhead Door(Bldg I Cable Repair) $1,419.50 9/27/2007 Frohwein Office Plus(Conference Room Chairs) $1,301.60 9/27/2007 HD Cline Co(Vehicle Maintenance Supplies) $264.83 9/27/2007 Gierke-Robinson Company(Column Tubing-Maintenance) $82.80 Airport Operating Expenses $11,974.99 City CIP Fund Expenses $2,117.76 Total Expenses $14,092.75 Capital Projects Construction Contracts Project Bid Amount Paid During Month Paid During FiscalYear Paid To Date %Paid Runway 7 Grading $950,154.00 $84,809.36 $643,271.56 67.7 South Economic Study-ALP Update $15,000.00 $12,434.12 $12,434.12 82.9 South T-Hangar Taxilane $140,794.15 $98,935.64 $98,935.64 70.3 HangarA-Concrete Floors $37,218.96 $2,069.91 $37,218.96 $37,218.96 100.0 Hangar A&B-Access Doors $16,700.00 West Terminal Apron $337,642.00 Runway 7-25 Paving $1,347,586.13 Pending Expenses Total Pending Expenses $0.00 $0.00 .4 EXPE: 10.05.07 12:10:03 Page: 1 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance 8 Used 7600 Airport AIRPORT 560100 Airport Operations SALARIES & WAGES REGULAR SALARIES & WAGES 411000 Perm Full Time 37314.00 10024.04 2875.20 27289.96 26.86 412000 Perm Part Time 21462.00 7542.14 2335.74 13919.86 35.14 413000 Temporary Employees 12000.00 3194.63 987.00 8805.37 26.62 Total REGULAR SALARIES & WAGES 70776.00 20760.81 6197.94 50015.19 29.33 OTHER WAGES 414100 Overtime Wages 1000.00 456.60 404.40 543.40 45.66 414500 Longevity Pay 1050.00 1050.00 Total OTHER WAGES 2050.00 456.60 404.40 1593.40 22.27 Total SALARIES & WAGES 72826.00 21217.41 6602.34 51608.59 29.13 EMPLOYEE BENEFITS GROUP INSURANCE 421100 Health Insurance _ 7141.00 1733.40 577.80 5407.60 24.27 421200 Dental Insurance 475.00 112.02 37.34 362.98 23.58 421300 Life Insurance 191.00 190.82 .18 99.91 421400 Disability Insurance 445.00 52.69 17.75 392.31 11.84 Total GROUP INSURANCE 8252.00 2088.93 632.89 6163.07 25.31 SOCIAL SECURITY CONTRIBUTIONS 422100 Fica 5595.00 1593.60 495.22 4001.40 28.48 Total SOCIAL SECURITY CONTRIBUTIONS 5595.00 1593.60 495.22 4001.40 28.48 RETIREMENT CONTRIBUTIONS 423100 Ipers 4425.00 1097.61 341.24 3327.39 24.80 Total RETIREMENT CONTRIBUTIONS 4425.00 1097.61 341.24 3327.39 24.80 UNION CONTRACT BENEFITS 424500 Monthly Cellular/PCS 300.00 75.00 25.00 225.00 25.00 EXPE: 10.05.07 12:10:03 Page: 2 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance ' Balance t Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) EMPLOYEE BENEFITS (CONTINUED) Total UNION CONTRACT BENEFITS 300.00 75.00 25.00 225.00 25.00 Total EMPLOYEE BENEFITS 18572.00 4855.14 1494.35 13716.86 26.14 PROFESSIONAL & TECHNICAL SERVICES OFFICIAL/ADMINSTRATIVE 431010 Filing Fee 61.00 61.00 431080 Recording Fees 7.00 7.00 Total OFFICIAL/ADMINSTRATIVE 68.00 68.00 PROFESSIONAL 432020 Annual Audit Expense 208.00 208.00 432060 Consultant Services 10000.00 617.32 9382.68 6.17 432070 Management Services 10000.00 2250.00 750.00 7750.00 22.50 Total PROFESSIONAL 20208.00 2867.32 750.00 17340.68 14.19 COMMUNICATIONS 433020 Local Phone Service 53.54 -53.54 433030 Long Distance Service 23.00 13.94 4.70 9.06 60.61 Total COMMUNICATIONS 23.00 67.48 4.70 -44.48 293.39 TECHNICAL SERVICES 435060 Legal Publications 341.00 12.16 12.16 328.84 3.57 Total TECHNICAL SERVICES 341.00 12.16 12.16 328.84 3.57 TRAINING & EDUCATION 436030 Transportation 1600.00 1600.00 436050 Registration 1700.00 175.00 175.00 1525.00 10.29 436060 Lodging 1300.00 1300.00 436080 Meals 425.00 425.00 Total TRAINING & EDUCATION 5025.00 175.00 175.00 4850.00 3.48 EXPE: 10.05.07 12:10:03 Page: 3 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) PROFESSIONAL & TECHNICAL SERVICES (CONTINUED) PROPERTY & LIABILITY INSURANCE 437010 Comp Liability Ins 8266.00 6400.00 1866.00 77.43 437020 Fire & Casualty Ins 14767.00 6803.27 6803.27 7963.73 46.07 437030 Worker's Comp Ins 74.00 78.00 78.00 -4.00 105.41 437042 Fidelity Bond 1097.00 1097.00 437200 Loss Reserve Payment 5000.00 5000.00 Total PROPERTY & LIABILITY INSURANCE 29204.00 13281.27 6881.27 15922.73 45.48 PUBLIC UTILITY SERVICES 438010 Stormwater Utility Charges 7251.00 1775.88 591.96 5475.12 24.49 438030 Electricity 14530.00 3879.59 1330.41 10650.41 26.70 438050 Landfill Use 40.00 40.00 438070 Heating Fuel/Gas 9291.00 155.43 48.30 9135.57 1.67 438080 Sewer Utility Charge 1976.00 487.18 207.36 1488.82 24.65 438090 Water Utility Charge 1600.00 441.78 183.39 1158.22 27.61 438100 Refuse Coll Charges 260.15 99.00 -260.15 Total PUBLIC UTILITY SERVICES 34688.00 7000.01 2460.42 27687.99 20.18 OTHER PROFESSIONAL SERVICES 439020 Plant Care 300.00 300.00 439030 Testing Services 1200.00 1200.00 Total OTHER PROFESSIONAL SERVICES 1500.00 1500.00 Total PROFESSIONAL & TECHNICAL SERVICES 91057.00 23403.24 10283.55 67653.76 25.70 REPAIR & MAINTENANCE VEHICLE REPAIR & MAINTENANCE 441010 Vehicle Repairs and Maintenance 1186.00 1186.00 Total VEHICLE REPAIR & MAINTENANCE 1186.00 1186.00 EXPE: 10.05.07 12:10:03 Page: 4 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance I Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) BUILDING REPAIR & MAINTENANCE 442010 Bldg Rep & Maint 3549.00 1965.30 655.10 1583.70 55.38 442020 Repair of Structure 9511.50 9436.50 -9511.50 442030 Repair of Heating Equip 1063.00 1063,00 442040 Repair of Cooling Equip 1000.00 91.00 909.00 9.10 442060 Repair of Electric/Plmbg 1306.00 14.66 1291.34 1.12 442070 Bldg Pest Control 108.00 101.85 33.95 6.15 94.31 Total BUILDING REPAIR & MAINTENANCE 7026.00 11684.31 10125.55 -4658.31 166.30 EQUIPMENT REPAIR & MAINTENANCE 443050 Radio Equipment Rep 104.00 104.00 443060 Telecom Equip Rep 500.00 500.00 443080 Other Repair & Maint 4040.00 206.00 3834.00 5.10 Total EQUIPMENT REPAIR & MAINTENANCE 4644.00 206.00 4438.00 4.44 TECHNICAL SERVICES 445060 Laundry Service 520.00 . 520.00 445070 Equipment Service 941.00 941.00 445140 Outside Printing 216.00 216.00 445230 Technical Services 3000.00 3000.00 Total TECHNICAL SERVICES 4677.00 4677.00 INTRA-DEPARTMENT SERVICES 446100 City Attorney Chgbk 5299.00 1521.23 702.51 3777.77 28.71 446130 ITS-PC/Peripheral Support 400.00 400.00 100.00 446140 ITS-Computer Replacement Chargeb 500.00 118.74 39.58 381.26 23.75 446160 ITS-Network/Internet Charge 720.00 90.00 30.00 630.00 12.50 446200 Photocopying Chargeback 219.00 129.96 34.02 89.04 59.34 446220 Phone Service-Department Chargeb 668.00 144.38 48.14 . 523.62 21.61 446300 Phone Equipment/Line Charge 840.00 217.50 72.50 622.50 25.89 446320 Mail Chargebacks 418.00 192.62 139.95 225.38 46.08 446350 City Vehicle Repl 12737.00 3003.90 1001.30 9733.10 23.58 EXPE: 10.05.07 12:10:04 Page: 5 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance t Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) REPAIR & MAINTENANCE (CONTINUED) INTRA-DEPARTMENT SERVICES (CONTINUED) 446370 Fuel Chargeback 1823.57 322.91 -1823.57 Total INTRA-DEPARTMENT SERVICES 21801.00 7641.90 2390.91 14159.10 35.05 MISCELLANEOUS SERVICES & CHARGES 449060 Dues & Memberships 400.00 400.00 449120 Equipment Rental 106.00 106.00 449140 Tools & Equip Rent 100.00 100.00 449360 Interest Expense 46930.00 11732.46 3910.82 35197.54 25.00 Total MISCELLANEOUS SERVICES & CHARGES 47536.00 11732.46 3910.82 35803.54 24.68 Total REPAIR & MAINTENANCE 86870.00 31264.67 16427.28 55605.33 35.99 OTHER PURCHASED SERVICES (CHANGE TO OFFICE SU GENERAL SUPPLIES 452010 Office Supplies 500.00 286.95 129.44 213.05 57.39 452030 Minor Off Equip/Furn 500.00 500.00 Total GENERAL SUPPLIES 1000.00 286.95 129.44 713.05 28.70 BOOKS & PERIODICALS 454020 Subscriptions 1926.00 1796.06 129.94 93.25 454040 Books, Magazines, Newpapers 67.00 78.97 -11.97 117.87 Total BOOKS & PERIODICALS 1993.00 1875.03 117.97 94.08 PRINTING & BINDING (SUPPLIES) 455120 Misc Computer Hardware 391.99 -391.99 Total PRINTING & BINDING (SUPPLIES) 391.99 -391.99 Total OTHER PURCHASED SERVICES (CHANGE TO OFF 2993.00 2553.97 129.44 439.03 85.33 EXPE: 10.05.07 12:10:04 Page: 6 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance t Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES AGRICULTURE SUPPLIES 461040 Ag Chemicals 258.00 258.00 Total AGRICULTURE SUPPLIES 258.00 258.00 BUILDING OPERATION/MAINTENANCE SUPPLIES 462020 Minor Sanitation Equipment 500.00 500.00 462030 Sanitation & Industrial Supplies 536.00 536.00 Total BUILDING OPERATION/MAINTENANCE SUPPLI 1036.00 1036.00 CHEMICAL & LAB SUPPLIES 463200 Other Chemicals & Supplies 216.40 108.20 -216.40 Total CHEMICAL & LAB SUPPLIES 216.40 108.20 -216.40 FUELS & LUBRICANTS 465050 Other Fuels 4225.00 4225.00 465060 Grease & Oil 32.00 54.98 54.98 -22.98 171.81 465070 Other Lubricants 35.00 35.00 465080 Fluids Gases & Other 19.00 19.00 Total FUELS & LUBRICANTS 4311.00 54.98 54.98 4256.02 1.28 REPAIR & MAINTENANCE SUPPLIES 466040 Plumbing Supplies 55.00 55.00 466050 Electrical Supplies 204.00 535.50 129.26 -331.50 262.50 466060 Other Construction Supplies 1000.00 1000.00 466070 Other Maintenance Supplies 572.00 77.85 77.85 494.15 13.61 Total REPAIR & MAINTENANCE SUPPLIES 1831.00 613.35 207.11 1217.65 33.50 EQUIPMENT REPAIR 467020 Minor Equipment Repair Material 76.00 39.99 36.01 52.62 467160 General Equipment 24.00 24.00 Total EQUIPMENT REPAIR 100.00 39.99 60.01 39.99 EXPE: 10.05.07 12:10:04 Page: 7 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period • Account Appropriated Expenditures Expenditures Encumbrance Balance I Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OPERATING SUPPLIES (CONTINUED) SURFACING MATERIALS 468030 Asphalt 1500.00 254.90 1245.10 16.99 Total SURFACING MATERIALS 1500.00 254.90 1245.10 16.99 IMPROVEMENT MATERIALS 469040 Traffic Control Improvement 300.00 300.00 469190 Tools & Minor Equipment 500.00 500.00 469260 Fire Ext. & Refills 491.00 491.00 469320 Miscellaneous Supplies & Equipme 413.53 -413.53 Total IMPROVEMENT MATERIALS 1291.00 413.53 877.47 32.03 Total OPERATING SUPPLIES 10327.00 1593.15 370.29 8733.85 15.43 IMPROVEMENTS OTHER THAN BUILDING IMPROVEMENTS OTHER THAN BUILDING 473010 Contracted Improvements 52000.00 1859.00 50141.00 3.58 Total IMPROVEMENTS OTHER THAN BUILDING 52000.00 1859.00 50141.00 3.58 EQUIPMENT & FURNITURE OPERATING EQUIPMENT 474420 Other Operating Equipment 971.00 2129.75 -1158.75 219.34 Total OPERATING EQUIPMENT 971.00 2129.75 -1158.75 219.34 FURNITURE & FIXTURES 475020 Office Furniture 1500.00 1500.00 Total FURNITURE & FIXTURES 1500.00 1500.00 Total EQUIPMENT & FURNITURE 2471.00 2129.75 341.25 86.19 EXPE: 10.05.07 12:10:04 • Page: 8 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance t Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES 490150 Operating Subsidy 7350.00 1837.50 612.50 5512,50 25.00 490190 Interfund Transfers Out-_ Fu 22190.00 5547.54 1849.18 16642.46 25.00 Total OTHER FINANCIAL USES 29540.00 7385.04 2461.68 22154.96 25.00 Total Airport Operations 366656.00 96261.37 37768.93 270394.63 26.25 Total Airport 366656.00 96261.37 37768.93 270394.63 26.25 EXPE: 10.05.07 12:10:04 Page: 9 Iowa City General Ledger System FY 2008 Expense Reporting For the period 09.01.07 to 09.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) AIRPORT (CONTINUED) 560100 Airport Operations (CONTINUED) OTHER FINANCIAL USES (CONTINUED) *** GRAND TOTAL *** 366656.00 96261.37 37768.93 270394.63 26.25 REVE: 10.05.07 12:10:36 Page: 1 Iowa City General Ledger System FY 2008 Revenue Reporting For the period 09.01.07 to 09.30.07 Estimated YTD Period Account Revenue Revenue Revenue Remainder 7600 Airport INTEREST REVENUES 381100 Interest on Investments 2249.00 4570.82 -2321.82 203.24 Total INTEREST REVENUES 2249.00 4570.82 -2321.82 203.24 RENTS 382100 Land Rental 42000.00 206.30 41793.70 .49 382200 Building/Room Rental 186267.00 42514.00 13121.50 143753.00 22.82 Total RENTS 228267.00 42720.30 13121.50 185546.70 18.72 ROYALTIES & COMMISSIONS 384200 Vending Machine Comm 123.00 92.48 18.00 30.52 75.19 384900 Other Commissions 21860.00 8168.80 8168.80 13691.20 37.37 Total ROYALTIES & COMMISSIONS 21983.00 8261.28 8186.80 13721.72 37.58 TRANSFERS TRANSFERS FROM GOVERNMENTAL ACTIVITIES 393120 General Levy 112000.00 20363.64 10181.82 91636.36 18.18 Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES 112000.00 20363.64 10181.82 91636.36 18.18 Total TRANSFERS 112000.00 20363.64 10181.82 91636.36 18.18 Total Airport 364499.00 75916.04 31490.12 288582.96 20.83 *1* GRAND TOTAL *** 364499.00 75916.04 31490.12 288582.96 20.83 TRID: 10.05.07 12:36:52 Page: 1 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport 560100 Airport Operations 411000 Perm Full Time 09.14.07 Old Sys 070912010006 477777\PAYROLL RECAP\PAYROLL 14-SEP 1437.60 09.28.07 Old Sys 070926010007 478079\PAYROLL RECAP\PAYROLL 28-SEP 1437.60 Total Perm Full Time 2875.20 412000 Perm Part Time 09.14.07 Old Sys 070912010006 477777\PAYROLL RECAP\PAYROLL 14-SEP 1150.30 09.28.07 Old Sys 070926010007 478079\PAYROLL RECAP\PAYROLL 28-SEP 1185.44 Total Perm Part Time 2335.74 413000 Temporary Employees 09.14.07 Old Sys 070912010006 477777\PAYROLL RECAP\PAYROLL 14-SEP 556.50 09.28.07 Old Sys 070926010007 478079\PAYROLL RECAP\PAYROLL 28-SEP 430.50 Total Temporary Employees 987.00 414100 Overtime Wages 09.14.07 Old Sys 070912010006 477777\PAYROLL RECAP\PAYROLL 14-SEP 404.40 Total Overtime Wages 404.40 421100 Health Insurance 09.12.07 Journal 070928163407 006185 SEP BCBS\Sep health insur old #9002 577.80 Total Health Insurance 577.80 421200 Dental Insurance 09.13.07 Journal 070928163407 006189 SEP DELTA DENTAL\Sep dental insuran 37.34 Total Dental Insurance 37.34 421400 Disability Insurance 09.12.07 New Vouch 070913030108 06870307 Check:608903\LAFAYETTE LIFE INSORAN 17.75 Total Disability Insurance 17.75 TRID: 10.05.07 12:36:52 Page: 2 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report8 Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 422100 Fica 09.14.07 Old Sys 070912010006 9140599\FICA\CITY CONTRIBUTION 266.55 09.28.07 Old Sys 070926010007 9280599\FICA\CITY CONTRIBUTION 228.67 Total Fica 495.22 423100 Ipers 09.14.07 Old Sys 070912010006 9143599\IPERS\CITY CONTRIBUTION 181.79 09.28.07 Old Sys 070926010007 9283599\IPERS\CITY CONTRIBUTION 159.45 Total Ipers 341.24 424500 Monthly Cellular/PCS 09.14.07 Old Sys 070912010006 477777\PAYROLL RECAP\PAYROLL 14-SEP 12.50 09.28.07 Old Sys 070926010007 478079\PAYROLL RECAP\PAYROLL 28-SEP 12.50 Total Monthly Cellular/PCS 25.00 432070 Management Services 09.11.07 New Vouch 070912030008 06870001 Check:608895\JET AIR INC\MANAGEMENT 750.00 Total Management Services 750.00 433030 Long Distance Service 09.02.07 Journal 071002165354 006218 SEP LONG DIST. CHG\CIC INFO SERVICE 4.65 09.26.07 New Vouch 070927030212 06870997 Check:610160\DTI\LONG DISTANCE SERV .05 Total Long Distance Service 4.70 435060 Legal Publications 09.18.07 New Vouch 070919030007 06870532 Check:609240\IOWA CITY PRESS CITIZH 12.16 Total Legal Publications 12.16 436050 Registration 09.21.07 P-Card 071004101405 13200744 THE MAIN EVENT\MICHAEL THARP 175.00 Total Registration 175.00 TRID: 10.05.07 12:36:52 Page: 3 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED( 437020 Fire & Casualty Ins 09.30.07 Journal 070928163407 006207 FY08 Property Ins\Insurance exp all 6803.27 Total Fire & Casualty Ins 6803.27 437030 Worker's Comp Ins 09.30.07 Journal 070928163407 006207 FY08 Work Comp Ins\Insurance exp al 78.00 Total Worker's Comp Ins 78.00 438010 Stormwater Utility Charges 09.19.07 Journal 070928163407 006184 057-095-03\STORMWT0.19.01 Bill Da 591.96 Total Stormwater Utility Charges 591.96 438030 Electricity 09.19.07 New Vouch 070920030026 06870694 Check:609262\MIDAMERICAN ENERGY\ELE 209.74 09.19.07 New Vouch 070920030026 06870791 Check:609260\MIDAMBRICAN ENERGY\ELE 939.54 09.19.07 New Vouch 070920030026 06870794 Check:609259\MIDAMBRICAN ENERGY\ELE 34.22 09.19.07 New Vouch 070920030026 06870795 Check:609259\MIDAMERICAN ENERGY\ELE 146.91 Total Electricity 1330.41 438070 Heating Fuel/Gas 09.19.07 New Vouch 070920030026 06870695 Check:609262\MIDAMBRICAN ENERGY\GAS 10.00 09.19.07 New Vouch 070920030026 06870713 Check:609261\MIDAMERICAN ENERGY\GAS 16.23 09.19.07 New Vouch 070920030026 06870792 Check:609260\MIDAMERICAN ENERGY\GAS 12.07 09.19.07 New Vouch 070920030026 06870793 Check:609260\MIDAMBRICAN ENERGY\GAS 10.00 Total Heating Fuel/Gas 48.30 438080 Sewer Utility Charge 09.19.07 Journal 070928163407 006184 057-120-00\SEWER\9.19.07 Bill Date 81.48 09.19.07 Journal 070928163407 006184 057-118-03\SEWER\9.19.07 Bill Date 60.96 09.19.07 Journal 070928163407 006184 057-117-00\SEWER\9.19.07 Bill Date 57.16 09.19.07 Journal 070928163407 006184 057-115-00\SEWER\9.19.07 Bill Date 7.76 Total Sewer Utility Charge 207.36 TRID: 10.05.07 12:36:52 Page: 4 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport )CONTINUED) 560100 Airport Operations )CONTINUED) 438090 Water Utility Charge 09.19.07 Journal 070928163407 006184 057-120-00\WATER\9.19.07 Bill Date 64.42 09.19.07 Journal 070928163407 006184 057-118.03\WATER\9.19.07 Bill Date 48.27 09.19.07 Journal 070928163407 006184 057-117-00\WATER\9.19.07 Bill Date 45.28 09.19.07 Journal 070928163407 006184 057-115-00\WATER\9.19.07 Bill Date 16.47 09.19.07 Journal 070928163407 006184 057-095-03\WATER\9.19.07 Bill Date 8.95 Total Water Utility Charge 183.39 438100 Refuse Coll Charges 09.18.07 New Vouch 070919030007 06870500 Check:609342\ALLIED WASTE SERVICES\ 74.00 09.18.07 New Vouch 070919030007 06870500 Check:609342\ALLIED WASTE SERVICES\ 25.00 Total Refuse Coll Charges 99.00 442010 Bldg Rep & Maint 09.12.07 New Vouch 070913030108 06870095 Check:608919\MIDWEST JANITORIAL SER 655.10 Total Bldg Rep & Maint 655.10 442020 Repair of Structure 09.11.07 New Vouch 070912030008 06869904 Check:608856\DAN'S OVERHEAD DOORS 1 1087.00 09.26.07 New Vouch 070927030212 06870839 Check:610109\STANLEY ROOFING CO\R00 6930.00 09.26.07 New Vouch 070927030212 06870983 Check:610056\DAN'S OVERHEAD DOORS 1 1419.50 Total Repair of Structure 9436.50 442070 Bldg Pest Control 09.18.07 New Vouch 070919030007 06870544 Check:609234\HAWREYE PEST CONTROL I 33.95 Total Bldg Pest Control 33.95 446100 City Attorney Chgbk 09.30.07 Journal 070928163407 006194 Aug City Atty chgbk\Sep interdepart 702.51 Total City Attorney Chgbk 702.51 TRIO: 10.05.07 12:36:52 Page: 5 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report() Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED( 446140 ITS-Computer Replacement Chargeback 09.01.07 Journal 070928163407 006190 I.S.-REPLACE CHG\ITS Sep replace ch 39.58 Total ITS-Computer Replacement Chargeback 39.58 446160 ITS-Network/Internet Charge 09.01.07 Journal 070928163407 006191 ITS-NW/INTERNET CHG\Sep internet ch 30.00 Total ITS-Network/Internet Charge 30.00 446200 Photocopying Chargeback 09.30.07 Journal 070928163407 006187 AUG PHOTOCOPY\Monthly photocopy chg 34.02 Total Photocopying Chargeback 34.02 446220 Phone Service-Department Chargebacks 09.13.07 Journal 070928163407 006192 Qwest Monthly Charge\ITS phone chgb 48.14 Total Phone Service-Department Chargebacks 48.14 446300 Phone Equipment/Line Charge 09.02.07 Journal 071002165354 006218 SEP PHONE EQUIP CHG\CIC INFO SERVIC 72.50 Total Phone Equipment/Line Charge 72.50 446320 Mail Chargebacks 09.01.07 Mail 070904144352 00900045 AUG POSTAL CHARGES 139.95 Total Mail Chargebacks 139.95 446350 City Vehicle Repl 09.30.07 EQ Repl 071002084634 00009006 SEP REPLACEMENT COST 1001.30 Total City Vehicle Repl 1001.30 446370 Fuel Chargeback 09.30.07 EQ Div 071002084634 00009008 SEP DIVISION FUEL 322.91 Total Fuel Chargeback 322.91 TRID: 10.05.07 12:36:52 Page: 6 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 449360 Interest Expense 09.30.07 Journal 070928163407 006181 Corp Hangar Loan Int\Sep Interfund 1952.63 09.30,07 Journal 070928163407 006181 Airprt SE Hangar Int\Sep Interfund 1007.05 09.30.07 Journal 070928163407 006181 Airprt SW Hangar-Int\Sep Interfund 951.14 Total Interest Expense 3910.82 452010 Office Supplies 09.21.07 P-Card 071004101405 13200743 STAPLES 00106260\MICHAEL THAR 67.97 09.21.07 P-Card 071004101405 13200745 STAPLES 00106260\MICHAEL THAR 48.99 09.21.07 P-Card 071004101405 13200746 STAPLES 00106260\MICHAEL THAR 12,48 Total Office Supplies 129.44 463200 Other Chemicals & Supplies 09.21.07 P-Card 071004101405 13200298 CONSUMERS COOPERATIVE\GERRY KAEFRIN 108.20 Total Other Chemicals & Supplies 108.20 465060 Grease & Oil 09.21.07 P-Card 071004101405 13200299 ORSCHELN IOWA CITY 90\GERRY KAEFRIN 54.98 Total Grease & Oil 54.98 466050 Electrical Supplies 09.11.07 New Vouch 070912030008 06869947 Check:608963\VAN METER INDUSTRIAL I 23.42 09.11.07 New Vouch 070912030008 06869948 Check:608963\VAN METER INDUSTRIAL I 105.84 Total Electrical Supplies 129.26 466070 Other Maintenance Supplies 09.21.07 P-Card 071004101405 13200300 LOWE'S #1688\GERRY KAEFRING 77.85 Total Other Maintenance Supplies 77.85 490150 Operating Subsidy 09.30.07 Journal 070928163407 006178 Econ Dev Coord 10%\Sep Budgeted Tra 612.50 Total Operating Subsidy 612.50 TRID: 10.05.07 12:36:52 Page: 7 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report8 Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Transfers Out-_ Fund 09.30.07 Journal 070928163407 006181 Corp Hangar Loan Prn\Sep Interfund 1047.37 09.30.07 Journal 070928163407 006181 Airprt SE Hangar Prn\Sep Interfund 322.95 09.30.07 Journal 070928163407 006181 Airprt SW Hangar-Prn\Sep Interfund 478.86 Total Interfund Transfers Out-_ Fund 1849.18 Total Airport Operations 37768.93 TRID: 10.05.07 12:36:52 Page: 8 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01,07 to 09,30,07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Transfers Out-_ Fund (CON Total Airport 37768.93 TRID: 10.05.07 12:36:52 Page: 9 Iowa City General Ledger System Expenditures Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 490190 Interfund Transfers Out- Fund (CON *** GRAND TOTAL *** 37768.93 TRID: 10.05.07 12:36:59 Page: 1 Iowa City General Ledger System Revenues Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit • Credit 7600 Airport 560100 Airport Operations 382200 Building/Room Rental 09.04.07 Payment 070904100752 00006753 1-9\POWERS ROBERT\Sep 07\HANGAR #9 121,00 09.04.07 Payment 070904112257 00006431 9-5\HALL ROBERT\Aug 07\HANGAR #6 121.00 09.05.07 Payment 070905103023 00006455 1-7\TEARSE DAVID\Aug 07\HANGAR #41 153.00 09.05.07 Payment 070905103023 00006698 1-6\BRUMLEY JAMES\Sep 07\HANGAR #2 132.00 09.05.07 Payment 070905103023 00006707 1-2\SCHNELL TOM\Sep 07\HANGAR #62 158.50 09.05.07 Payment 070905103023 00006709 1-10\HALL ROBERT\Sep 07\HANGAR #6 121.00 09.05.07 Payment 070905103023 00006710 1-11\BULGERELLI DAVID\Sep 07\HANGA 132.00 09.05.07 Payment 070905103023 00006733 1-8\TEARSE DAVID\Sep 07\HANGAR #41 153.00 09.05.07 Payment 070905103023 00006754 1-13\OPERATOR PERFORMANCE LAB\Sep 0 1330.00 09.05.07 Payment 070905103023 00006754 1-13\OPERATOR PERFORMANCE LAB\Sep 0 153.00 09.05.07 Payment 070905103023 00006759 1-5\SINGLETARY ROBERT\Sep 07\HANGA 121.00 09.06.07 Payment 070906094110 00006708 1-20\BULLERS JONATHAN\Sep 07\HANGA 121.00 09.06.07 Payment 070906094110 00006709 1-2\HALL ROBERT\Sep 07\HANGAR #6 121.00 09.06.07 Payment 070906094110 00006711 1-19\SHANKLIN DOUG\Sep 07\HANGAR # 153.00 09.06.07 Payment 070906094110 00006717 1-7\BUTLER JOHN\Sep 07\HANGAR #36 153.00 09.06.07 Payment 070906094110 00006717 1-7\BUTLER JOHN\Sep 07\HANGAR #37 153.00 09.06.07 Payment 070906094110 00006764 1-13\MELLECKER EDWARD\Sep 07\HANGA 132.00 09.07.07 Payment 070907092745 00006724 1-5\LACINA DAVE\Sep 07\HANGAR #57 180.50 09.07.07 Payment 070907092745 00006729 1-6\ALLENDER PATRICK\Sep 07\HANGAR 153.00 09.07.07 Payment 070907092745 00006737 1-1\EDMONDS TERRY\Sep 07\HANGAR #5 285.00 09.07.07 Payment 070907092745 00006765 1-4\DOWNES 6 ASSOCIATES\Sep 07\HANG 153.00 09.10.07 Payment 070910093525 00006725 1-6\PATTSCHULL RICHARD\Sep 07\HANG 208.00 09.10.07 Payment 070910093525 00006736 1-10\FARRIS GREG\Sep 07\HANGAR #29 132.00 09.11.07 Payment 070911092912 00006696 1-4\RUYLE JOHN\Sep 07\HANGAR #33 358.00 09.11.07 Payment 070911092912 00006716 1-10\MASCARI RICK\Sep 07\HANGAR #3 132.00 09.11.07 Payment 070911092912 00006726 1-14\ANDERSON MARK\Sep 07\HANGAR # 175.00 09.11.07 Payment 070911092912 00006749 1-6\FLOOD BRYAN\Sep 07\HANGAR #19 132.00 09,11.07 Payment 070911092912 00006752 1-12\JET AIR INC\Sep 07\BUILDINGS D 3926.00 09.11.07 Payment 070911092912 00006755 1-3\WIECHERT RONALD\Sep 07\HANGAR 132.00 09.11.07 Payment 070911092912 00006763 1-8\KRUSE DAVE\Sep 07\HANGAR #18 132.00 09.11.07 Payment 070911092912 00006775 1-13\JET AIR\Sep 07\HANGAR #60 158.50 09.11.07 Journal 070928163407 006172 AR/LF OVERPAY-HALL\ACCOUNT CODE COR 121.00 TRID: 10.05.07 12:36:59 Page: 2 Iowa City General Ledger System Revenues Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report& Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 09.12.07 Payment 070912085655 00006499 1-5\HERTZ CORPORATION\PAYMENT 100.00 09.12.07 Payment 070912085655 00006732 1-1\CHALKLEY BEN\Sep 07\HANGAR #14 132.00 09.12.07 Payment 070912085655 00006734 1-3\ZUBROD ROY\Sep 07\HANGAR #20 132.00 09.12.07 Payment 070912085655 00006751 1-2\ROOF KEITH\Sep 07\HANGAR 832 512.00 09.12.07 Payment 070912085655 00006770 1-8\ALEXIS PARK INN & SUITES\Sep 07 121.00 09.13.07 Payment 070913090223 00006442 1-1\FULL JERRY\Aug 07\HANGAR #45 186.00 09.13.07 Payment 070913090223 00006706 1-6\RANEY CHARLES\Sep 07\HANGAR #1 121.00 09.13,07 Payment 070913090223 00006723 1-2\OCKENFBLS TRANSFER\Sep 07\HANGA 186.00 09.14.07 Payment 070914091529 00006715 1-4\HALL DAN\Sep 07\HANGAR #27 132.00 09.14.07 Payment 070914091529 00006768 1-7\FLANAGAN JAMES\Sep 07\HANGAR 8 134.00 09.14.07 Payment 070914091529 00006768 1-7\FLANAGAN JAMES\Sep 07\CREDIT B 2.00 09.14.07 Payment 070919145045 00006750 89-1\GURNETT DON\Sep 07\HANGAR #34 310.00 09.18.07 Payment 070918100629 00006712 1-12\HOLLY FORREST\Sep 07\HANGAR 8 132.00 09.18.07 Payment 070918100629 00006727 1-13\TUCKER JIM\Sep 07\HANGAR #38 153.00 09.18.07 Payment 070918100629 00006772 1-2\VRANEK DOUGLAS\Sep 07\HANGAR 8 121.00 09.18.07 Payment 070918100629 00006782 1-4\SWANSON NAOMI\Sep 07\HANGER #8 121.00 09.19.07 Payment 070919093438 00006728 1-2\NE IA PAYS THERPY ASSOC\Sep 07\ 180.50 09.19.07 Payment 070919093438 00006728 1-2\NE IA PAYS THERPY ASSOC\Sep 07\ 158.50 09.19.07 Payment 070919093438 00006758 1-4\STEARMAN\Sep 07\HANGAR #47 153.00 09.19.07 Payment 070919093438 00006760 1-1\SAPPHIRE VISTAS LLC\Sep 07\RANG 132.00 Total Building/Room Rental 2.00 13123.50 384200 Vending Machine Comm 09.20.07 Old Sys 070921010005 9203034\AMERICAN BOTTLING\AIRPORT 18.00 Total Vending Machine Comm 18.00 384900 Other Commissions 09.27.07 Old Sys 070928010005 9273005\NEWTON HOME OIL CO\FLOWAGE 8168.80 Total Other Commissions 8168.80 • TRIP: 10.05.07 12:36:59 Page: 3 Iowa City General Ledger System • Revenues Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED( 560100 Airport Operations (CONTINUED) 393120 General Levy 09.30.07 Journal 070928163407 006178 Airport Prop Tx Supp\Sep Budgeted T 10181.82 Total General Levy 10181.82 Total Airport Operations 2.00 31492.12 TRID: 10.05.07 12:36:59 Page: 4 Iowa City General Ledger System Revenues Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) Total Airport 2.00 31492.12 TRID: 10.05.07 12:36:59 Page: 5 Iowa City General Ledger System Revenues Detail FY 2008 Detail Reporting For the period 09.01.07 to 09.30.07 • Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) *t* GRAND TOTAL *** 2.00 31492.12 DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 1 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder t , GA Account Description To Date Years To Date Month Budget In Budget Spent ttt*tt****ttttttttt**ttttt*******t***t t t tt ttt tt tttttt t*tttt tttttttt 3403 Airport North Commercial Park Old System $: 37410 ttttttttttttt**tttt ifttttttttttttttttttttttt*****tt*ttttttttttttttt RECEIPTS 560300 393140 AirCapAcq General Fund CIP Fu 33,603.73 33,603.73 560300 393240 AirCapAcq From Airport Operat 35,079.08 4,975.95 30,103.13 4,000.00 -26,103.13 752.6 560300 393411 AirCapAcq From 02 GO Bonds 16,161.72 16,161.72 TOTAL RECEIPTS 84,844.53 54,741.40 30,103.13 4,000.00 -26,103.13 752.6 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 Pica 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 387.00 262.00 125.00 -125.00 560300 431111 AirCapAcq Engineering Service 693.00 693.00 560300 432080 AirCapAcq Other Prof Services 24,894.78 24,894.78 -24,894.78 560300 435060 AirCapAcq Legal Publications 63.55 38.15 25.40 -25.40 560300 439010 AirCapAcq Abstracts 350.00 350.00 -350.00 560300 439060 AirCapAcq Other Prof Services 800.00 800.00 560300 445240 AirCapAcq Word Processing 12.36 12.36 560300 446100 AirCapAcq City Attorney Chgbk 41,948.73 37,150.99 4,707.95 4,000.00 -707.95 117.7 560300 446200 AirCapAcq Photocopying Chgbk 25.00 25.00 560300 473010 AirCapAcq Contracted Improve 13,417.80 13,417.80 TOTAL EXPENDITURES 84,905.71 54,712.79 30,103.13 4,000.00 -26,103.13 752.6 DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 2 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder t GIL Account Description To Date Years To Date Month Budget In Budget Spent NET FOR PROJECT -61.18 28.61 Cash Balance: Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 3 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent ittfttttttttffttttitttttttfttftttttffi i tt*ttttttitttttttittttttttft 3406 NE Property Development Old System #: 00000 ttttftttititttttttttitffttttfttttitt t t t t t t i ttt ttttttt ft f t t t t t ft fttt RECEIPTS 560300 393240 AirCapAcq From Airport Operat 1,082.00 1,082.00 -1,082.00 TOTAL RECEIPTS 1,082.00 1,082.00 -1,082.00 EXPENDITURES 560300 431080 AirCapAcq Recording Fees 32.00 32.00 -32.00 560300 432060 AirCapAcq Consultant Services 1,312.50 1,050.00 -1,050.00 TOTAL EXPENDITURES 1,344.50 1,082.00 -1,082.00 NET FOR PROJECT -262.50 Cash Balance: Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 4 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent ftttttttttttttt+tttttttttttart+****ttttttttttttttttttttttttttttttt 3415 Building B,C,K Roof Replacement GAVI-IOW Old System #: 37430 ***ittttttt******ttttttttttttttttttttttttttttttttt******tttttt**t** RECEIPTS 560300 334900 AirCapAcq Other State Grants 40,641.68 40,641.68 560300 393140 AirCapAcq General Fund CIP Fu 11,998.16 12,372.95 -374.79 374.79 560300 393411 AirCapAcq From 02 GO Bonds 6,807.04 6,807.04 TOTAL RECEIPTS 59,446.88 59,821.67 -374.79 374.79 EXPENDITURES 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 560300 472010 AirCapAcq Building Improvemen 560300 473010 AirCapAcq Contracted Improve 9,899.94 9,899.94 TOTAL EXPENDITURES 59,446.88 59,446.88 NET FOR PROJECT 374.79 -374.79 Cash Balance: Beginning Balance: 374.79 DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 5 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 • THROUGH 09.30.07 Total Project Prior Fiscal This Year • This This Year Remainder k G/L Account Description To Date Years To Date Month Budget In Budget Spent k*t#kkkkt it44it it tt#ttlittttti44441#t k 4ktt 4ttt k kttktt 44 k ktt kt 444 t l4 3416 Runway 7 Design, EA, Extension, FAA #10 Old System t: 37440 tttttittt tiIt ktt#ti itttt tuttutttttltttt tt t ttttit kitt t kitttt tt iitttt RECEIPTS • 560300 331100 AirCapAcq Federal Grants 1,290,457.00 1,163,207.00 114,033.00 227,851.00 113,818.00 50.1 560300 393140 AirCapAcq General Fund CIP Fu 560300 393411 AirCapAcq From 02 GO Bonds 19,243.93 19,243.93 560300 393414 AirCapAcq From 05 GO Bonds 40,613.05 144,338.90 -103,725.85 -98,327.00 5,398.85 105.5 TOTAL RECEIPTS 1,350,313.98 1,326,789.83 10,307.15 129,524.00 119,216.85 8.0 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 305,912.58 271,081.95 32,767.34 7,401.47 -32,767.34 560300 432060 AirCapAcq Consultant Services 24,608.21 24,608.21 560300 433044 AirCapAcq Advertising 16.29 16.29 560300 435060 AirCapAcq Legal Publications 227.63 208.83 18.80 -18.80 560300 446100 AirCapAcq City Attorney Chgbk 24.80 24.80 -24.80 560300 471021 AirCapAcq Temporary Easement 3,592.18 3,592.18 560300 471030 AirCapAcq Right-of-Way 33,952.62 33,952.62 560300 473010 AirCapAcq Contracted Improve 877,770.98 831,974.98 45,796.00 45,796.00 188,566.00 142,770.00 24.3 TOTAL EXPENDITURES 1,246,105.29 1,165,435.06 78,606.94 53,197.47 188,566.00 109,959.06 41.7 NET FOR PROJECT 104,208.69 161,354.77 -68,299.79 -53,197.47 Cash Balance: -11,257.15 Beginning Balance: 57,042.64 DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 6 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder 1. G/L Account Description To Date Years To Date Month Budget In Budget Spent ttitt tt ftttttttttttfitttftf it it ttttt f t t f t t f t t t t t t t ttttt********tttt 3417 Airport Obstruction Removal AIP-IOW(28(- Old System #: 37450 itiittttttttttttttttttttfttttttttttttttttttt ttt t t f i fit i f Olt itt it ttt RECEIPTS 560300 331100 AirCapAcq Federal Grants 560300 334900 AirCapAcq Other State Grants 113,449.04 113,449.04 560300 393140 AirCapAcq General Fund CIP Fu -11,550.65 -11,550.65 560300 393416 AirCapAcq From 07 GO Bonds TOTAL RECEIPTS 101,898.39 101,898.39 EXPENDITURES 560300 432070 AirCapAcq Management Services 61,866.49 61,866.49 560300 446100 AirCapAcq City Attorney Chgbk 560300 473010 AirCapAcq Contracted Improve 23,127.90 23,127.90 560300 473020 AirCapAcq Non-Contracted Impr 4,900.00 4,900.00 TOTAL EXPENDITURES 89,894.39 89,894.39 NET FOR PROJECT 12,004.00 12,004.00 Cash Balance: Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 7 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent **t*******t*********tktttt**k****ttk*ttt*****t**tt**ii************* 3419 Aviation Commerce Park Site Development Old System #: 00000 *******tit*kit*****tktttt**ttttt*ktttt t t*k it tt i ktt k kttt ti t ttit it t it RECEIPTS 560300 362100 AirCapAcq Contrib & Donations 560300 393240 AirCapAcq From Airport Operat 11,217.58 11,217.58 -11,217,58 560300 393414 AirCapAcq From 05 GO Bonds 46,374.63 46,374.63 15,000.00 15,000.00 TOTAL RECEIPTS 57,592.21 46,374.63 11,217.58 15,000.00 3,782.42 74.8 EXPENDITURES 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 5,767.24 15,000.00 3,782.42 74.8 TOTAL EXPENDITURES 57,592.21 46,374.63 11,217.58 5,767.24 15,000.00 3,782.42 74.8 NET FOR PROJECT -5,767.24 Cash Balance: Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 8 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent ******t***t***t********ttttt*tt tt t ti nt***iii*****tit************t* 3420 Runway 7 Grading FAA #11 & #12 Old System #: 37441 **********tit*******tt******H*t*************it t ttt H**t t i tt**t***i RECEIPTS 560300 331100 AirCapAcq Federal Grants 138,289.00 110,379.00 27,910.00 39,621.00 11,711.00 70.4 560300 393140 AirCapAcq General Fund CIP Fu 14,558.40 14,558.40 560300 393240 AirCapAcq From Airport Operat -6,664.00 -6,664.00 560300 393416 AirCapAcq From 07 GO Bonds TOTAL RECEIPTS 152,847.40 124,937.40 27,910.00 32,957.00 5,047.00 84.7 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 148,871.43 133,273.11 15,598.32 28,537.08 24,622.00 9,023.68 63.4 560300 473010 AirCapAcq Contracted Improve TOTAL EXPENDITURES 148,871.43 133,273.11 15,598.32 28,537.08 24,622.00 9,023.68 63.4 NET FOR PROJECT 3,975.97 -8,335.71 12,311.68 -28,537.08 Cash Balance: 3,975.97 Beginning Balance: -8,335.71 DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 9 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent tttiiittttttttttttttttttttttttttttttt*t t t t t ttttttt t ttt ti t tt tt t t t ttt 3421 Runway 7 Paving/Lighting FAA #14 Old System tO: 37444 ttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt RECEIPTS 560300 331100 AirCapAcq Federal Grants 132,611.00 2,129,425.00 2,129,425.00 560300 393416 AirCapAcq From 07 GO Bonds 77,787.83 1,613.18 112,075.00 110,461.82 1.4 TOTAL RECEIPTS 210,398.83 1,613.18 2,241,500.00 2,239,886.82 .1 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 139,591.31 32,263.58 -32,263.58 560300 435060 AirCapAcq Legal Publications 205.54 560300 473010 AirCapAcq Contracted Improve 2,241,500.00 2,241,500.00 TOTAL EXPENDITURES 139,796.85 32,263.58 2,241,500.00 2,209,236.42 1.4 NET FOR PROJECT 70,601.98 -30,650.40 Cash Balance: -30,650.40 Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 10 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder G/L Account Description To Date Years To Date Month Budget In Budget Spent ttftftftttfftffftfttttttttttt*******f f f f t t t t t t t t t f t t t t f f f f f t t t*t t tt 3422 Airport Taxilane/Apron Pavement Rehab 9I Old System #: 37496 ttttttttttttttttttttfttttttt*ttttttttttttttt fttt t f t t t f t t f t t t ft f f t tt RECEIPTS 560300 334900 AirCapAcq Other State Grants 128,110.96 128,110,96 128,111.00 .04 100.0 560300 393140 AirCapAcq General Fund CIP Fu 18,099.53 18,099.53 560300 393240 AirCapAcq From Airport Operat 45,222.46 45,222.46 36,805.00 -8,417.46 122.9 TOTAL RECEIPTS 191,432.95 18,099.53 173,333.42 164,916.00 -8,417.42 105.1 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 26,329.06 11,844.55 14,484.51 2,372.11 -14,484.51 560300 435060 AirCapAcq Legal Publications 92.78 92.78 -92.78 560300 473010 AirCapAcq Contracted Improve 165,011.11 165,011.11 32,786.00 171,171.00 6,159.89 96.4 TOTAL EXPENDITURES 191,432.95 11,844.55 179,588.40 35,158.11 171,171.00 -8,417.40 104.9 NET FOR PROJECT 6,254.98 -6,254.98 -35,158.11 Cash Balance: Beginning Balance: 6,254.98 DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 11 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % GSL Account Description To Date Years To Date Month Budget In Budget Spent tttttttttttttttttt+tttttttttt tttttttttttttttttttttttttttttttttttttt 3424 Hard Surface Floors Bldgs B & C #9I-05-0 Old System #: 37495 +ttttttt***fttttt+tttttttttttt**ttttttt+tttt+t**ttttttttttttttttttt RECEIPTS 560300 334900 AirCapAcq Other State Grants 47,672.12 43,528.82 4,143.30 15,829.00 11,685.70 26.2 560300 393140 AirCapAcq General Fund CIP Fu 21,428.00 21,428.00 560300 393240 AirCapAcq From Airport Operat 3,636.00 3,636.00 TOTAL RECEIPTS 69,100.12 64,956.82 4,143.30 19,465.00 15,321.70 21.3 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 8,889.83 8,889.83 560300 435060 AirCapAcq Legal Publications 84.45 84.45 560300 446100 AirCapAcq City Attorney Chgbk 49.59 49.59 -49.59 560300 472010 AirCapAcq Building Improvemen 560300 473010 AirCapAcq Contracted Improve 59,128.75 56,172.31 2,956.44 2,956.44 19,651.00 16,694.56 15.0 TOTAL EXPENDITURES 68,152.62 65,146.59 3,006.03 2,956.44 19,651.00 16,644.97 15.3 NET FOR PROJECT 947.50 -189.77 1,137.27 -2,956.44 Cash Balance: 947.50 Beginning Balance: -189.77 DF$GL CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 12 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent tttt**ttttttttttt tttttttttttttttttttt t t t t t t t t t t t t t t t t ttt**t t t t t t t tt 3425 FAA Runway 7 Grading/Obstr Mitigation #3 Old System #: 37443 *****ttttttttttttttttttttttttttttt+tttttttttttttttttttttttttttttttt RECEIPTS 560300 331100 AirCapAcq Federal Grants 788,077.00 671,800.00 1,647,826.00 976,026.00 40.8 560300 393140 AirCapAcq General Fund CIP Fu 8,555.21 8,555.21 560300 393416 AirCapAcq From 07 GO Bonds 114,124.46 27,396.46 86,728.00 59,331.54 31.6 TOTAL RECEIPTS 910,756.67 8,555.21 699,196.46 1,734,554.00 1,035,357.54 40.3 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 185,763.94 8,370.68 151,536.12 4,041.75 288,300.00 136,763.88 52.6 560300 435060 AirCapAcq Legal Publications 209.90 184.53 25.37 -25.37 560300 446100 AirCapAcq City Attorney Chgbk 64.47 64.47 -64.47 560300 449055 AirCapAcq Permitting Fees 300.00 300.00 -300.00 560300 473010 AirCapAcq Contracted Improve 643,281.56 558,472.20 146,908.05 1,446,254.00 887,781.80 38.6 TOTAL EXPENDITURES 829,619.87 8,555.21 710,398.16 150,949.80 1,734,554.00 1,024,155.84 41.0 NET FOR PROJECT 81,136.80 -11,201.70 -150,949.80 Cash Balance: -11,201.70 Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 10,05.07 12:12:57 Page: 13 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent ttttttttttfttttttttfttttftt4 ttttttftttttttt44444tttttttfttttttttttt 3431 Rehabilitate Hangar A 9I-07-0IOW-300 Old System g: 37375 fffftfttt tttttttfttf4t f4ftf4fffftttft t tttt t Ott 4t t4ttttt f tt t ttttt t tt RECEIPTS 560300 334900 AirCapAcq Other State Grants 35,965.00 3,262.00 49,300.00 46,038.00 6.6 560300 393240 AirCapAcq From Airport Operat 8,700.00 833.01 8,700.00 7,866.99 9.6 TOTAL RECEIPTS 44,665.00 4,095.01 58,000.00 53,904.99 7.1 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 7,082.67 5,470.41 -5,470.41 560300 435060 AirCapAcq Legal Publications 82.97 82.97 -82.97 560300 469320 AirCapAcq Misc Suppl & Equip 47.85 560300 473010 AirCapAcq Contracted Improve 37,218.96 58,000.00 58,000.00 TOTAL EXPENDITURES 44,432.45 5,553.38 58;000.00 52,446.62 9.6 NET FOR PROJECT 232.55 -1,458.37 Cash Balance: -1,458.37 Beginning Balance: • DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 14 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30,07 Total Project Prior Fiscal This Year This This Year Remainder A G/L Account Description To Date Years To Date Month Budget In Budget Spent *****************t*ttf*f tff ftftt***********f****ft************tiff* 3432 Rehabilitate South T Hangar Taxi Lanes 9 Old System #: 37497 • ***fft*f****t*fffff***tffftttft*tfttt t f f**tt ttfff tt ft ftt t t***fftff* RECEIPTS 560300 33490D AirCapAcq Other State Grants 87,408.00 9,652.00 111,510.00 101,858.00 8.7 560300 393240 AirCapAcq From Airport Operat 47,790.00 47,790.00 47,790.00 TOTAL RECEIPTS 135,198.00 9,652.00 159,300.00 149,648.00 6.1 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 25,847.96 17,013.91 -17,013.91 560300 435060 AirCapAcq Legal Publications 88.35 88.35 -88.35 560300 473010 AirCapAcq Contracted Improve 98,935.64 159,300.00 159,300.00 TOTAL EXPENDITURES 124,871.95 17,102.26 159,300.00 142,197.74 10.7 NET FOR PROJECT 10,326.05 -7,450.26 Cash Balance: -7,450.26 Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 10.05.07 12:12:57 Page: 15 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 09.30.07 Total Project Prior Fiscal This Year This This Year Remainder % GSL Account Description To Date Years To Date Month Budget In Budget Spent ttttttttttttttttttttttttt*tttttttttfttttttttftttttttttttttttttttttt 3433 West Terminal Apron Rehabilitation Old System d: 00000 tttttttttt*******ftttftfttttt ttt fit ft ft tttt f t}tttt f f tt*t tttft t tt ftt RECEIPTS 560300 393240 AirCapAcq From Airport Operat 5,889.21 4,093.33 440,600.00 436,506.67 .9 TOTAL RECEIPTS 5,889.21 4,093.33 440,600.00 436,506.67 .9 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 19,838.75 4,093.33 70,600.00 66,506.67 5.8 560300 435060 AirCapAcq Legal Publications 187.86 560300 473010 AirCapAcq Contracted Improve 370,000.00 370,000.00 TOTAL EXPENDITURES 20,026.61 4,093.33 440,600.00 436,506.67 .9 NET FOR PROJECT -14,137.40 Cash Balance: Beginning Balance: