Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
05-10-2007 Airport Commission
IOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, MAY 10, 2007 - 5:45P.M. 1. Determine Quorum 3. Approval of Minutes from the following meetings: April 12, 2007 4. Public Discussion - Items not on the agenda 5. Items for Discussion/Action: A) Aviation Commerce Park B) JJR Davis- Drainage Easement C) Tom Schnell—University of Iowa—Operator Performance Labs D) Grass Runway E) Airport Disadvantaged Business Enterprise (DBE) FY07 Goal for U.S. DOT assisted contracts I) Public Comment II) Consider a Resolution adopting the Disadvantaged Business Enterprise Program F) FAA/IDOT Projects- Earth Tech—David Hughes I) Runway 7/25 II) South Aviation Development Study III) South Taxilane Rehab a. Consider a resolution awarding contract for the Rehabilitation of South Taxilanes IV) Hangar A Rehab a. Consider a Resolution awarding contract for the Installation of concrete Floors in Hangar Building A V) Hangar A& B Doors a. Consider a Resolution awarding contract for the replacement of access doors on Hangar Buildings A and B VI) Terminal Apron Rehab VII) Obstruction Mitigation VIII) 405 Approach Surveys G) Airport Viewing Area H) Airport Commission Meeting Schedule I) Airport "Operations": Strategic Plan-Implementation; Budget; and Airport Management J) FBO Staff Report K) Subcommittees' Reports L) Commission Members' Reports M) Staff Report 6. Set next regular meeting for June 14, 2007 at 5:45 p.m. 7. Adjourn MINUTES DRAFT Iowa City Airport Commission April 12,2007 Iowa City Airport Terminal—5:45 PM Members Present: Howard Horan, Chair; Randy Hartwig; John Staley; Janelle Rettig, Greg Farris Members Absent: Staff Present: Sue Dulek,Michael Tharp Others Present: Tom Schnell, Dave Larsen, Gary and Sharon Lust DETERMINE QUORUM: Chairperson Horan called the meeting to order at 5:47 P.M. RECOMMENDATIONS TO COUNCIL: APPROVAL OF MINUTES FROM THE FOLLOWING MEETINGS: March 8, 2007 and March 28,2007: Hartwig noted that Karin Franklin had not been at the meeting on March 8th. Rettig recommended striking a sentence from Item B on the March 8 minutes. Dulek recommended to include the closing of the public hearings on the March 28 minutes. Staley moved to accept the minutes as amended of the March 8 and March 28,2007, meetings; seconded by Rettig. Carried 5-0. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: A) Aviation Commerce Park—Horan noted that Harry Wolf wasn't in attendance, and gave a brief update. He noted a closing date for Lot 5 of April 17. Dulek commented that there was some minor title objections, and those would require some city staff to sign off on. B) ER Davis—Drainage Easement—Tharp noted that Dave Larsen gave them some preliminary plats to review and gave a quick overview of where they are now. Tharp stated that they now have an offer for the easement. Hartwig stated that according to David Hughes and Earth Tech, there shouldn't be any problems with this easement and what has been proposed. Horan asked what-the-Commission needs to do at this point, and Tharp stated that they need to get the FAA's approval,which would encompass a fair market appraisal of the land,first. After this,the Commission could then discuss the offer. Rettig brought up some concerns that she has on the proposed drainage easement. She stated that 1 she would like to have more information on just how this drainage easement will affect things in the future. Dave Larsen then addressed some of Rettig's concerns regarding the drainage, and how things are currently being handled with run-off to the creek. He also reminded the Commission of David Hughes' comment at the last meeting,when he stated that this easement would actually improve the hydrology of this area. Larsen then gave the Members some history on this particular drainage easement and how they were waiting for specific things to get done by the Airport before they could proceed. Horan asked for more specifics on why this easement has become an issue at this time. The discussion continued, with Rettig stating her concerns again, and saying that they need something to show them that this will not create any problems in the future. Tharp addressed Members' questions about how they should proceed at this point in getting FAA approval. Dulek noted that Mr. Larsen would be responsible for the cost of engaging an engineer for this project, as well as obtaining an appraisal. Rettig stated that there are basically three major concerns: flash flooding, back-up flooding, and wildlife, which have to do directly with the capacity of the creek and how the run-off will affect the area. Horan stated that he feels they don't currently have everything they need in order to address this, at this point. Members agreed, with Rettig stating that once they have this information, she does not see a problem moving forward. (TAPE ENDS) The discussion continued, with Larsen asking Dulek for some clarification on costs incurred for this proposed sale. Horan restated for the Members the contingencies as he sees them: hydrology report(buyer pays);the appraisal (buyer pays); and the Willow Creek Study results. C) Dean Thornberry—Proposal for Hangar Construction—Tharp stated that the subcommittee has met to discuss Dean Thomberry's offer. Tharp also stated that the subcommittee understood the offer to be that Thornberry would loan the necessary funds to the airport,to be repaid over time. He gave the Members some details about what they have found so far, and that the option of extending an existing hangar was also researched. Hartwig stated that according to what they found out, it would be at least a 6-month delay before they could even begin building. This led to Members discussing the best options for them at this time. Rettig stated that they should survey all of their tenants, especially the larger ones, and do some creative thinking about what they would like to see in the future, and then put together a comprehensive plan of what they would like to see. She would prefer to do some planning before they spend$300,000 to $600,000 on a new hangar. Tharp spoke to the perception aspect of the Airport—that the airport currently has a debt load and they do not want to seek an increase in the subsidies they receive. The discussion continued regarding how they could provide more hangars, while still covering their • debt load. Horan asked if the Members were all in agreement that for now they do not want to proceed with the Thomberry proposal. This led to a 2 r r brief discussion about the feasibility study being done. Members then discussed how a donation to the Airport would be handled. D) Tom Schnell—University of Iowa—Operator Performance Labs—Schnell addressed the Commission, stating that they have been looking for extra space due to the need to expand one of their labs. Horan commented that he and Tharp had talked with Schnell about his future needs regarding the use of the hangar. Schnell expressed his needs for more hangar space, as well as,more office space for the purposes of consolidating research groups,which are currently in 2 locations. Horan gave a summary of what had been discussed regarding the expansion. Horan also stated that part of this discussion covered how to fund the expansion plans,to which it had • been optioned that.the Airport would fund the expansion costs,which repayments made from an increase in rent. Schnell commented that he was happy to be at the airport, and that the current lease only has a few years left, so that there could be a renegotiation of a new lease to cover the additional costs for a longer term. Horan noted that part of the building is rented by Jet Air for the purposes of storing their fuel trucks for security and inclement weather. Members asked Schnell questions regarding space needs and what he sees for expansion. Members agreed to continue working with Schnell to get cost estimates for the possible expansion. E) Westside Automotive, LLC—Temporary Lease --Dulek gave Members the background on this lease, stating that while construction takes place on the Hagan Parcel,the buyers would like a temporary lease to keep the equipment on the piece of land that remains airport property. Dulek also mentioned that because the sale hasn't fully closed,the resolution would add that the lease would be contingent on closing. I) Consider a Resolution authorizing a Temporary Lease Agreement with Westside Automotive LLC for use of a vacant parcel of land by tenant during the construction of a building— Rettig moved to recommend Resolution#A07-08 as stated above; seconded by Hartwig. Carried 5-0. F) FAA/MOT Projects—Earth Tech—David Hughes—Tharp noted that David Hughes was away and not able to attend. Tharp stated that the South Taxilanes, and Hangar A were in the bidding process. G) Airport"Operations": Strategic Plan-Implementation; Budget; and Airport Management—Rettig asked about an item in the budget. The item of `interest on investments' showed a negative. Tharp said he'd look into that. H) FBO Staff Report—Rettig asked some questions of Woolford regarding the number of flight instruction students Jet Air had. Woolford responded that he would get back to the commission with numbers. I) Subcommittees' Reports—Farris reported that he and Tharp had meet with Terry Robinson to talk about the Viewing Area. Farris said they are continuing to plan for the development of the area and were looking for input for safety clearances on equipment and placement ideas. Rettig asked questions regarding the plans, stating that part of the justification of 3 expenses was that the Airport would raise matching funds. Farris responded that they would have some layout plans at the next meeting. J) Commission Members' Reports—Horan and Rettig commented that they had attended the Iowa Aviation Conference and gave a report on what they viewed. K) Staff Report—Tharp commented that he also attended the Iowa Aviation Conference, and that he had been able to have some quick discussions with members of the FAA and the Iowa DOT. Tharp announced that the Iowa City Airport had been selected for one of the sites of the American Barnstormers Tour in the summer of 2008. Tharp commented that this is a group of flyers that operates several aircraft from the"Golden Age"of aviation and that their planes date back to the 1920's. Tharp introduced Gary Lust as a member of the group who was in attendance. Lust gave a description of the organization and what typically occurs at each event stop. SET NEXT REGULAR MEETING FOR MAY 10, 2007,AT 5:45 P.M. ADJOURN: Meeting adjourned at 8:11 P.M. 4 r Airport Commission ATTENDANCE RECORD YEAR 2007 (Meeting Date) TERM 1/11 2/8 3/8 3/28 4/12 NAME EXP. Randy Hartwig 3/1/09 X X X X X Greg Farris 3/1/07 O/E X X O/E X John Staley 3/1/10 X X X X X Howard Horan 3/1/08 X X X X X Janelle Rettig 3/1/12 X X X X X KEY: X = Present O = Absent O/E= Absent/Excused NM= No meeting = Nota Member 5 May 1,2007 Mr.David Larsen Representative of the Dane Family 277 Hickory Street Katona, Iowa 52247 Subject:Value Finding Appraisal for Iowa City Airport property on which permanent drainage easements are proposed. It is located near the intersection of Dane Road and the future Dane farm Lane(on the south edge of the airport property), Iowa City,Iowa 52242. Dear Mr. Larson: At your request, we have on, May 1, 2007, inspected the above referenced property. There is no official legal description of the parent tract on which the easements are proposed, however the legal descriptions of the acquisitions are included in the Description of the Acquisition section of this report. The purpose of the inspection and appraisal is to estimate just compensation(based on fee simple interest) for the proposed drainage easements as of May 1, 2007. The intended use of this appraisal is to fulfill compliance with FAA requirements concerning changing land use within an FAA regulated property (Iowa City Airport). As the Iowa City Airport is under the jurisdiction of the FAA, a release must be granted by the FAA for the drainage easement to be established. The FAA requires an appraisal as part of the process of "releasing" or changing the use of the subject property. The function of this appraisal is to assist in facilitating this release,or change in use from the FAA. In order to provide an estimate of just compensation for the subject area,we took the following steps: 1. We have defined and described only a portion (not the entirety) of the IC airport as the subject property. We have estimated the area of the parent tract at approximately 45 acres. 2. We estimated the market value of the 45 acres based on comparable sales. 3. We applied the per acre value arrived at in the Sales Comparison Approach to the area of the proposed drainage easements(1.22 acres)to establish just compensation. May 1,2007 Mr.Larsen Page 2 The value opinions reported are qualified by certain definitions, limiting conditions and certifications that set forth in the body of the report. A copy of the plat showing the proposed drainage easements are included in the report,along with other supporting data. Based on our analysis the estimate of just compensation for the proposed drainage easements as of May 1, 2007 is: Fourteen Thousand One Hundred Dollars $14,100 This report was prepared for the benefit of and our professional fee billed to Mr.David Larsen acting as a representative of John Dane, the property owner. It is intended only for your use and for use by appropriate regulatory authorities. It may not be distributed to or relied upon by other persons or entities without written permission. We received verbal authorization for this appraisal from David Larsen, who is the representative of the Dane Family. If you have any questions concerning the report,please contact us. Sincerely, COOK APPRAISAL, LLC Kyran J.Cook,MM State of Iowa Certified General Real Property Appraiser#CG01332 Rochelle L. Wolfe, M.A. State of Iowa Certified General Real Property Appraiser#CG02354 RLW/skk-270056 Michael Tharp 5/2/2007 Airport Operations Specialist Iowa City Municipal Airport 1801 S.Riverside Drive Iowa City, Iowa 52246 Dear Michael Please find attached all requested information. 1. Signed and Certified plans 2.Letter from the Engineer answering all the questions and documents supporting conclusions. 3.This letter explaining that John Dane will abide and follow the Advisory Circular AC No: 150/5200-33A(attached)in connection with the Easement being requested and the Detention Facility adjoining the Easement. If there are any questions,please contact me at 319-656-5271 or 319-936-0558 cell. Thank you, Face too or J� Davis Fo ddition. •J adae--1 David . -nce;Larsen �Mrafi M IOWA CITY IOWA I CEDAR RAPIDS IOWA OFFICE: 319-351-8282 OFFICE: 319-841-5188 MApril 16, 2007 5479-006 Airport Commission City of Iowa City n 410 East Washington Street Iowa City,Iowa 52240 Dear Chairperson, I am a licensed civil engineer and I prepared the construction plans for JJR Davis 4th Addition. I certify that the construction plans were prepared by me or under my direct supervision and that the drainage ditch and storm water basin were designed in accordance with City of Iowa City Storm Water Regulations. It is my understanding that Iowa City Engineering staff have concurred that my design of these features is in accordance with City regulations. The representative of the property owners,Dave Larsen,has presented me with some concerns the Commission has about the proposed drainage ditch and storm water basin and I will try to address them below. The first concern that was brought up was whether the drainage ditch was properly designed. I have designed the proposed drainage channel to convey the 100 year runoff from the proposed subdivision area as well as additional area that is tributary to the proposed drainage channel. The channel will convey the runoff from this size of storm safely to the proposed storm water basin. The second concern is whether the basin will hold water for longer than 48 hours. The basin is designed such that it will be drained in less than 48 hours after the rain stops assuming Willow Creek has receded into its banks and normal water level as well. If the water elevation in Willow Creek remains high,there will still be water in the basin until the level of the water in Willow Creek drops. The level in the basin will not be any higher than the level of Willow Creek within 48 hours of the end of the storm. The drainage ditch and storm water basin are designed to attenuate the impact of"flash floods". This was another of your concerns that was brought forth by Mr. Larsen. These drainage systems are designed to detain the large flows from large storms and release them at a lower rate that is more similar to the runoff from the current undeveloped area. Therefore,the large flows can be released in a controlled manner to Willow Creek without adverse impact on Willow Creek and downstream properties. I trust that the above explanations and the attached signed and sealed construction plans are adequate to allow for the proposed easements on airport property to be secured by the property owners. Sincerely, ' 5(1 g Scott Pottorff,P.E. tri MMS Consultants, Inc. 1917 SOUTH GILBERT STREET • IOWA CITY•IOWA 52240 WEBSITE: WWW.MMSCONSULTANTS.NET EMAIL: MMS@MMSCONSULTANTS.NET I JJR DAVIS FOURTH ADDITION DRAINAGE CALCULATIONS Iowa City, Iowa September 15, 2005 Revised November 8, 2006 INTRODUCTION JJR Davis Fourth Addition is a 6.68 acre commercial subdivision that is located east of Mormon Trek Boulevard and south of Highway 1 on the southwest side of Iowa City. This subdivision drains to the northeast toward Willow Creek. There will be a dry bottomed storm water basin constructed adjacent to Willow Creek that will provide storm water management for Carousel Ford, JJR Davis Second and Third Additions as well as this development. The purpose of these calculations is to show that the storm water basin for this development is designed in accordance with Iowa City Design Standards. The 100-year drainage system is analyzed using Hydraflow computer software utilizing the SCS TR-20 Unit Hydrograph method to calculate the peak runoff and runoff volume. 100-YEAR DRAINAGE SYSTEM The hydrologic characteristics of the development area that drains to the basin are as follows: DA=27.89 acres Channel Length=2100 ft Channel Slope=(742-660)/2100 = 3.90% Tp= 0.2042hr CN= 92 for commercial areas From the Hydrologic Studies form,the required storm water storage is 217.43 acre-inches and the allowable release rate is 4.18 cfs. The maximum volume that can be stored 4.5 inches per acre. With 27.89 acres,this makes the storage volume requirement 125.51 acre- inches. The proposed storm water basin will be sized to provide 131.25 acre-inches. There is 17.77 acres of offsite area that drain to the proposed storm water basin. The hydrological characteristics of the area are as follows: DA= 17.77 acres Channel Length= 1700 ft Channel Slope=(720-660)/1700= 3.50% Curve Number: 69 for pasture areas in fair condition 100-year 24-hour precip. =7.13 inches This produces a peak runoff of 51.03 cfs The runoff from this offsite area will be allowed to pass through the basin without storm water management. r The allowable release rate for the basin will be the allowable release rate from the subdivision plus the 100 year offsite runoff rate Allowable Release Rate=4.18 cfs+ 51.03 cfs= 55.21 cfs The 100 year runoff from the subdivision area that drains to the basin is 186.46 cfs (Hydrograph#2). The 100 year runoff from the offsite area is 51.03 cfs (Hydrograph#3). These two hydrographs were combined to get the total runoff to the proposed basin. The total runoff to the basin is 224.41 cfs (Hydrograph#4). The 100 year elevation in Willow Creek according to Earthtech's revised flood study for the airport and Mormon Trek Boulevard is 661.0. This elevation was used as a tailwater elevation when the outlet from the basin was analyzed. The attached spreadsheet shows the outlet pipe analysis that was used in the model. Routing the 100 year runoff through the basin produces the following (Hydrograph#5): Qpeak= 18.05 cfs Maximum Stored Runoff Volume= 149.72 Acre-inches Maximum Water Elevation=663.29 The runoff from the basin is less than the allowable release rate of 55.21 cfs T:\5400\5479006\5479006dcl.doc HYDROLOGIC . STUDIES C117--- D R✓1 > WM- C(Cif 0 4 7/45--705-- PROJECT DATE LOCATION LAND USE (SOIL COVER) N % USE PRODUCT BASIN AREA a7. fq AC Co W1 1"'-e r f p`cp if CN—.�2Z CHANN 2 ©3NGTH � FT SOIL TYPE B CLIMATE FACTOR 1 .19 CHANNEL SLOPE 9.50 LAG TIME 42.o in.. HRS. (Tp SUMMATION = 100% 7.72975- •1RXZ) Q = A : XYYXZ -7-'549 )c ' T X (FREQUENCY) "Q" C.F.S. (FREQUENCY.) TIME 'Tp 5 10 25 50 100 Z 5 10 25 50 100 0.2 / ¶-71) 0-6' 52.z8 0.5 2.'S- Z.9 c- 1 973! 1.0 1 1.9& I 1,570g- 1.5 s:°s1.5 /,Yee 1 tY.6 2.0 149 1 39so 2.5 I 0,99 1 32.gs ' 3.0 e"SS I • ; 26 z) 4.0 0.-6 °I I zZ.90 5.0 o,5---6 I /1.57 6.0 I 6,N,1 1 /6.2.6 7.0 1 d, q3 ) 11.17 8.0 ,/ 0.38' r Ilzel - FREQ. RELEASE RATE STORAGE 5 Y.IB' lzssl 10 25 50 cri Ii 100 F- - Z a _ _ 0 I 2 3 4 5 6 7 8 9 10 II 12 13 14 15 16 17 TIME (HOURS) zr FIGURE A ® 3 hPv . -Pc i I LENGTH OF CHANNEL vs. I LAG TIME °Tp' M Tc = f-67 . 1 . / 5 / / ITp = 0.00236 (L/r).64 ///: / I I I o,o ZI p • � •1 02 crii 5 I Cc 03 _ �� �O 4.p L. Z( . w F o I J .1 / �l � _ /// ! 05 / / ./ . . / , .01 100 1,000 10,000 100,01 CHANNEL LENGTH (FEET) FIGURE A LAG TIME 'Tp' VS. ' Z ' Lo- 0.9 - 0.8 0.75- 0.7 0.6 0.50- 0.4 0.3 0.25- OS 0.15 Z 0.10- • 0.09 0.08 0:075- 0.07 0.06 0.050- Y • 0.04 0.03 0.025- 0.02 .025-0.02 - 0.15 • 0'010^I ro t- Rag N N I tel v. I (0. 1": Iron I - I I I I 1 I I I too 0 0 0 0 o 0 to 0 o 0 0 0 do o to o too O 0 to O O o 00— N to _ _ N O N en d' tri r O N O O O O 0 T/TP CO V CA Cn a W N•N.F'' r r 0 0 0 0 0 0 Fa• rt el O 0 0 0 0 0 (n o Ult.) o V Ln a W N 1-11-, o ff O 0000000.0v1 o rn00o0O' ' p w H. in W W W W W W W W W CO N CO CO N r r OG• ^ w w o VD CO V CA f n a N N 0 Co V C n N O co a L0 N r.la•5 ;� • Vl D1 VD OA Co r CO O r LID V a a W O N r`-' Y• r `p'id • P l 00000rr1.-, NtV N W acnaiV ton r rt W O N• a [nUVIDrWUOW Va4> 00rr`-' 0 0 to fn W W O a r Orr V r co 00000 ,7 . G o 0 0 0 0 0 o r r r r N N W W a a (n n .H F h a to o . a s Ln a V MD r W a`Co N V a Co W V (n`-' Ln Fh pcs • N Va N a:Ln O W cn 0a N) OO W W (!n0 Fh• b 'r1 0 . 0 0 0 0 0 0 0 r r r r N N lv 41 W Nr. w Ht • u D n H ' W a a Ln CA V l D O W °I V r CA V 0 0 l0" O rt • Ch O CA N a \O r LO W O V r O V l W O o 0 'rl H w n 0 0 0 0 0 0 0 o r r r r r N N N r n Co X rt 41 W W a in ON V Co o r W a to O r o Oa`-' Hi H OW OOW Na W CO in co co in a W V 00 0 _ H X 000000000orrrrrro.-, ooZ.Fh N N W W a in 111 V CO VD O N CA In (n N CO-' CD H on V Fa Lnl,.7 CO VD O W'a V V 0\ 00 L n 0 C1-:4: w 0 O 0 0 0 0.0 0 0 0 0 0 o r r o 0 On r 0 . w 1 . N CO N CO W a a l n CA V CO CO o o l D a 0� U'l rt "; ON VI CO a r U in cn 0O VD 00 W 00 0 CD w . H . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o On -1 . tD O Fa r N NNW W a a Into a1 - a\ Olin O' -' H CA V o N CA r a r - i N co V l 0 in - O O (D . ^ G O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 r a cD o cn �-- r-rrr N NN W 41 LA a'a a a (N CD 0`---' f1 . W a l n V o a CA r Ln CO N V CA 041 0 0 • CD o 0 0 0 0 0 0 0 0 0 0 0 0 0 0'O r a • CD r r r r r r N CO N CO N N N Fa 0 P • ID Or N Ln V wr4l (n V CO CA LA V 00 TIME Q AVERAGE Q Q x T HOURS CES CFS-HR 0.0 0.00 41.14 8.23 0.2 82 .28 90.10 27.03 0.5 97.91 81.48 40.74 1.0 65.05 56.76 28.38 1.5 48.46 43 .98 21.99 2 .0 39.50 36.18 18.09 2.5 32.86 30.54 15.27 3 .0 28.21 25.56 25.56 4. 0 22 .90 20.75 20.75 5.0 18 .59 17.43 17.43 6.0 16.26 15.27 15.27 7. 0 14.27 13 .44 13 .44 8. 0 12 .61 VOLUME = 252.15 ACRE-INCHES REL. RATE 4.34 CFS STORAGE 217.43 ACRE-INCHES 1YinryIc) rAsiN 2W17e ?RD P v r p E 5 17% i G i-r I o uu rote- A To r A-1-- or 772'1 Fc <-6, ow AC c Ng-cis EL AcG -a o f-r i PA-1^-16 ( , r 1 c --70-1P-' � t Loy A-c-- 7 cYITh / V PP-iv 3 w. HA , {3Y-, 57N `169 Ac ?o55Y1„.e: ltiGfAcI fl "t' = 6, f 3 Ac--- -ND c--ND I) f I 0 AiPit H 19 Ac piorive FrofFr-TP At E ( 6 (r-5',,org 1 rib 1U - 13A-5 I W its c_ g c ria y- c ,Phe0 A-tyj W1Th SQMG. C1-Art)tA'PDYft0 Rt._ VA-Nc f`toecn F'' Co p ,- f 5 -r-kg- }' `i' Mir SkS € ,j/ Hydrograph Plot Hydraflow Hydrographs by Intelisolve Wednesday,Nov 8 2006,5:48 PM Hyd. No. 2 RUNOFF FROM DEVELOPMENT Hydrograph type = SCS Runoff Peak discharge = 186.42 cfs Storm frequency = 100 yrs Time interval = 1 min Drainage area = 27.890 ac Curve number = 92 Basin Slope = 3.9 % Hydraulic length = 2100 ft Tc method = LAG Time of conc. (Tc) = 18.82 min Total precip. = 7.13 in Distribution = Type II Storm duration = 24 hrs Shape factor = 484 Hydrograph Volume=625,986 tuft RUNOFF FROM DEVELOPMENT Q (cfs) Hyd. No. 2-- 100 Yr Q (cfs) 210.00 210.00 180.00 180.00 150.00 150.00 120.00 120.00 90.00 90.00 60.00 60.00 30.00 30.00 0.00 0.00 0 2 5 7 9 12 14 16 19 21 23 26 Time (hrs) — Hyd No. 2 Hydrograph Plot Hydraflow Hydrographs by Intelisolve Wednesday,Nov 8 2006, 5:48 PM Hyd. No. 3 OFFSITE Hydrograph type = SCS Runoff Peak discharge = 51.00 cfs Storm frequency = 100 yrs Time interval = 1 min Drainage area = 17.770 ac Curve number = 69 Basin Slope = 3.5 % Hydraulic length = 1700 ft Tc method = LAG Time of conc. (Tc) = 35.67 min Total precip. = 7.13 in Distribution = Type II Storm duration = 24 hrs Shape factor = 484 Hydrograph Volume=234,892 cuft OFFSITE Q (cfs) Hyd. No. 3-- 100 Yr Q (cfs) 60.00 60.00 50.00 A 50.00 40.00 , 40.00 30.00 30.00 r\ 20.00 20.00 10.00 10.00 j---K 0.00 — Th0.00 0 3 5 8 10 13 15 18 20 23 25 Time (hrs) — Hyd No. 3 Hydrograph Plot Hydraflow Hydrographs by Intel'solve Wednesday, Nov 8 2006,5:49 PM Hyd. No. 4 TOTAL TO BASIN Hydrograph type = Combine Peak discharge = 224.32 cfs Storm frequency = 100 yrs Time interval = 1 min Inflow hyds. = 2, 3 Hydrograph Volume=860,878 tuft TOTAL TO BASIN Q (cfs) Hyd. No. 4-- 100 Yr Q (cfs) 240.00 240.00 210.00 210.00 180.00 180.00 150.00 150.00 120.00 120.00 90.00 90.00 60.00 J 60.00 30.00 30.00 0.00 —i_ 0.00 0 2 5 7 9 12 14 16 19 21 23 26 Time (hrs) — Hyd No. 4 — Hyd No. 2 — Hyd No. 3 AREA AVERAGE DELTA VOLUME VOLUME ELEVATION (FTA2) AREA VOLUME (FTA2) AC-IN 653.5 0 0 0 311 155 654 621 155 0.04 6,691 13,382 656 12,761 13,537 3.72 28,213 56,425 658 43,664 69,962 19.24 61,978 123,956 660 80,292 193,918 53.33 97,100 194,199 662 113,907 388,117 106.73 120,811 241,622 664 127,715 629,739 173.18 129,480 64,740 664.5 131,244 694,479 190.98 Pond Report Hydraflow Hydrographs by Intelisolve Wednesday,Nov 8 2006, 5:44 PM Pond No. 1 - BASIN Pond Data Pond storage is based on known contour areas. Average end area method used. Stage/Storage Table Stage(ft) Elevation(ft) Contour area(sgft) Incr.Storage(cult) Total storage(cult) 0.00 653.50 00 0 0 0.50 654.00 621 155 155 2.50 656.00 12,761 13,382 13,537 4.50 658.00 43,664 56,425 69,962 6.50 660.00 80,292 123,956 193,918 7.50 661.00 97,100 88,696 282,614 8.50 662.00 113,907 105,504 . 388,118 10.50 664.00 127,715 241,622 629,740 Culvert/Orifice Structures Weir Structures [A] [B] [C] [D] [A] [B] [C] [D] Rise(in) = 0.00 0.00 0.00 0.00 Crest Len(ft) = 0.00 0.00 0.00 0.00 Span(in) = 0.00 0.00 0.00 0.00 Crest El.(ft) = 0.00 0.00 0.00 0.00 No.Barrels = 0 0 0 0 Weir Coeff. = 0.00 0.00 0.00 0.00 Invert El.(ft) = 0.00 0.00 0.00 0.00 Weir Type = - -- --- -- Length(ft) = 0.00 0.00 0.00 0.00 Multi-Stage = No No No No Slope(%) = 0.00 0.00 0.00 0.00 N-Value = .000 .000 .000 .000 Orif.Coeff. = 0.00 0.00 0.00 0.00 Multi-Stage = n/a No No No Exfiltration= 0.000 in/hr(Wet area) Tailwater Elev.= 0.00 ft Note:Culvert/Orifice outflows have been analyzed under Inlet and outlet control. Stage/Storage/Discharge Table Stage Storage Elevation Clv A Clv B Clv C Clv D Wr A Wr B Wr C Wr D Exfil Total ft cuft ft cfs cfs cfs cfs cfs cfs cfs cfs cfs cfs 0.00 0 653.50 -- -- -- -- -- -- -- -- -- 0.00 0.50 155 654.00 -- - - - - - - - -- 0.00 2.50 13,537 656.00 -- - - -- - - - - - 0.00 4.50 69,962 658.00 --- - - - - - - - - 0.00 6.50 193,918 660.00 -- - - - - - --- - -- 0.00 7.50 282,614 661.00 -- -- - - - -- - - -- 0.00 8.50 388,118 662.00 - - - - - - - - -- 1228 10.50 629,740 664.00 --- - - - - - - - - 21.26 THIS SPREADSHEET DETERMINES THE CAPACITY OF PROJ NO: 5479-006 AN OUTLET PIPE FOR A STORM WATER BASIN DATE: 12/05/05 INLET CONTROL WHERE: H= HEAD MEASURED FROM CENTROID OF PIPE AT INLET Q=CA(2GH)^0.5 C= 0.6 G= 32.2 OUTLET CONTROL WHERE: K=1.5+29*(N^2)*L/(R^(4/3)) Q=A(2GH/K)^0.5 R=D/4 H= HEAD MEASURED FROM CROWN OF PIPE AT OUTLET OR FROM TAILWATER ELEVATION PIPE DIA. (IN) 24 AREA= 3.14159 FTA2 MANNINGS n 0.013 K= 4.216944 PIPE LENGTH (FT) 220 SLOPE= 0.01 FT/FT INVERT IN 653.50 INVERT OUT 651.30 TAILWATER ELEV 661.00 INLET CONTROL OUTLET CONTROL CONTROLLING WS ELEV H Q H Q DISCHARGE 654.00 -0.5 #NUMI -7 #NUM! #NUM! 656.00 1.5 18.53 -5 #NUM! #NUMI • 658.00 3.5 28.30 -3 #NUMI #NUM! 660.00 5.5 35.48 -1 #NUMI #NUMI 662.00 7.5 41.43 1 12.28 12.28 664.00 9.5 46.62 3 21.26 21.26 -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUMI -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUMI #NUMI -654.5 #NUMI -661 #NUM! #NUMI -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUMI #NUM! -654.5 #NUMI -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUMI -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUMI -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUMI #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! -654.5 #NUM! -661 #NUM! #NUM! Hydrograph Plot Hydraflow Hydrographs by Intelisolve Wednesday, Nov 8 2006, 5:46 PM Hyd. No. 5 ROUTE THRU POND Hydrograph type = Reservoir Peak discharge = 18.05 cfs Storm frequency = 100 yrs Time interval = 1 min Inflow hyd. No. = 4 Max. Elevation = 663.29 ft Reservoir name = BASIN Max. Storage = 543,496 cuft Storage Indication method used. Hydrograph Volume=578,255 cult ROUTE THRU POND Q (cfs) Hyd. No. 5 -- 100 Yr Q (cfs) 240.00 240.00 210.00 _-- 210.00 180.00 180.00 150.00 150.00 — 120.00 120.00 90.00 90.00 60.00 60.00 30.00 30.00 0.00 0.00 0 3 6 10 13 16 19 22 25 29 32 35 Time (hrs) — Hyd No. 5 ' — Hyd No. 4 1111111111 Req. Stor= 543,496 cuft DRAINAGE CALCULATIONS JJR DAVIS FOURTH ADDITION Iowa City, Iowa October 2, 2006 Revised November 9, 2006 INTRODUCTION JJR Davis Fourth Addition is a 4 lot commercial subdivision in Iowa City, Iowa. It lies east of Mormon Trek Boulevard and south of Highway 1 on the southwest side of Iowa City. The storm water basin has been-designed in accordance with the Iowa City Storm Water Management Ordinance. The 5 and 100 year runoff is proposed to be conveyed from the developed area to the basin via a drainage swale along the south side of the relocated farm access lane on the Iowa City Airport property. The proposed swale will be a minimum of 2 feet in depth and be a trapezoidal shape with an 8 foot wide bottom and 4:1 side slopes. The longitudinal slope of the swale is about 3.5%to 5.8% at the same slope of the access drive. The swale is deeper in depth and has a flatter longitudinal slope at the west end where the storm sewer outlets and gets steeper as it approaches the culverts on the east end of the swale. The runoff will then be piped under the access drive to the basin with 2 48" diameter culverts under the access lane. These culverts have been sized to convey the 100 year flow without overtopping the access lane. There is a low point in the access lane that will be the overland flow route to the basin in the event that the culverts become overwhelmed or incapacitated. The 100 year runoff from the developed area and the offsite area that drains to the drainage swale is 224.41 cfs. The attached spreadsheet shows the capacity of the proposed drainage swale. This swale will be lined with permanent erosion control mat due to the relatively high velocities in this swale. The swale has the capacity to convey the 100 year runoff from the developed area and offsite area that drains to it. The two culverts under the access lane at the east end of the swale have the capacity to convey the 100 year storm as well. PROJECT : Gni- p5 tin-I A-DDITIONSTATION : CULVERT DESIGN FORM SHEET OF DESIGNER/DATE: REVIEWER/DATE : HYDROLOGICAL DATA EL 111) ROADWAY ELEVATION : 66S,e3 (II) hd' ti 0 METHOD: 'a• LI DRAINAGE AREA: 0 STREAM SLOPE: ����_---------.......... ...... — G▪ ❑ CHANNEL SHAPE: < H— o In ❑ ROUTING: 0 OTHER: 9 (� I FALL OR101 Temu BED RTW DESIGN FLOWS/TAILWATER EC (1C HI) • R.I. (YEARS) FLOWIe1Q TW NI) /,eI t� Sys — FALL/ 6 sb•op Uf )07 I S. „c, Q O L.gO0 ELa: (It) 100 7/GrS 6s'b,r0 L..® $3 tqN CULVERT DESCRIPTION: TOTAL FLOW HEADWATER CALCULATIONS cc MATERIAL- SHAPE-SIZE-ENTRANCE FLOW BREL INLET CONTROL OUTLET CONTROL ;a um— to r o a .+o COMMENTS (e 0AI Q/N HWII/D NW' FALL ELhi TW da dot° ha F• H EL ho Z4W Iw 1•1 (II (2) 13) (4) (S) 2 (el „. 171 (B) s w o a Nk° clntArgei-r () 117s IA 5.36 0 I,3( 0 Sac 3,633b3 0•s 2.I% tv.sn66y4c L{r1r<ULv elf( (4 I,zS 14( 5i3(, U Wb1T 0 3-$ 31)3 3,4 Oj' z'if 42bykt,.79 • TECHNICAL FOOTNOTES: l4) ELh• HWI+ELIIINVERT OF (6) 4•TW or(d0,D/2)(WHICHEVER IS GREATER) 11) USE 0/NB FOR BOX CULVERTS INLET CONTROL SECTION) (7) H•Ct Awt (29 n2 LI/RL33]V2/2q 12) HWI/D•HW /D OR HWI/D FROM DESIGN CHARTS 15)TW BASED ON DOWNSTREAM (6)ELho EL,t Ht ha 13)FALL=HW -(ELhd-EL 1 FALL IS ZERO CONTROL OR FLOW DEPTHIN I- hd- AI i CHANNEL. FOR CULVERTS ON GRADE • SUBSCRIPT DEFINITIONS : COMMENTS/DISCUSSION : CULVERT BARREL SELECTED : a.APPROXIMATE 1:CULVERT FACE SIZE: H.DESIGN HEADWATER M.HEADWATER IN INLET CONTROL SHAPE: ho.HEADWATER IN OUTLET CONTROL I. INLET CONTROL SECTION • o. OUTLET MATERIAL: R at SIREAMBED AT CULVERT FACE- 1w TAILWATER ENTRANCE: C HART 1 O - 180 — 10,000 — 168 — 8,000 EXAMPLE (1) (2) (3) 6. - 156 — 6 000 0042 Inches (3.5 feet) 5,000 00 120 de — 144 _ —4,000 lit ! NM — 132 - D fool r - ' — 4. 3,000 8) 2.5 5.6 _ 5 e .4. — 120 - (2) 2.1 9.4 - - -- 2,000 (3) 2.2 9.9 �4• - — 108 = — °D In Int - - 96 — 1,000 i- 3. - - — 800 — 84 — 600 //�--- — 2.-2— _- 500 — 400 — 2. - la — 72 _ 300 E+ / _ —1.5 — 1.5 to _ it - - - - 60 p :1- /200 A imlmwimmE .- z z _ / w o - Sa c / a - - - S W �w - 100 z - - > / •K — 90 = 4../. = - 60 a - _ I.o _I.° 2 0 _ W o 0— SO HW SCALE ENTRANCE ¢ _�0 - - r — 40 0 TYPE — 9 1--- 96 — 30 111 Sewn edge with Wt .9 hnavelt 3 — .9 - — 33 0 - G _ 2O (21 Grocn earlwith e2 G — 30 - headwall = — .8 _ .8 (3) Groan fed — .8 _ —2T - drsleeflad _ - —• IO —___=_T —.7- - 24 _ 8 _ 6 To wee seals (2)or(3)project - - 21 _55 horizontally to scale(t),thtn - — 4 use straight Inclined lint through D and 0 scales,or renrrr it —.6 - — 3 illustrated. —.6 —.6 — IB _ - 2 _ — IS .5 _ — 5 —.5 — 1.0 — 12 HEADWATER DEPTH FOR HEADWATER SCALES 2&3 CONCRETE PIPE CULVERTS REVISED MAY1964 WITH INLET CONTROL BUREAU OF Flint ROA05 JAN.463 181 r 0 CHART 4 3 -.1111imw_�_ 2 ■ ■ ■ ■■� Via- 35' 1 Via- de CANNOT EXCEED TOP OF PIPE .1sed — .0'bIA. 0 0 10 20 30 40 50 60 70 BO 90 100 DISCHARGE-O-CFS 6 B 5 --- 7 ii2e I- <— WV i u.1F LL 4 / U Et, —' 6la ti 79' .rF o a 3 de CANNOT EXCEED TOP OF PIPE = W 7, g a ow J O a O2 , ''DU. � J Q P 0 100 200 300 400 500 600 700 BOO 900 1000 v DISCHARGE-Q-CFS 0 U 14 12 10 B - 6 dc CANNOT EXCEED TOP OF PIPE /7717'..e.................. 9 4 014. 0 1000 2000 3000 4000 DISCHARGE-Q-CFS BUREAU OF PUBLIC ROADS JAN: 1964 CRITICAL DEPTH CIRCULAR PIPE 184 O CHART 5 F-2000 / \\ 1 N NW _ —÷ no —4 z au "�""�' Slow So—o. ARr 1000 e — — SUBMERGED OUTLET CULVERT FLOWING FULL _5 — i— a 6®® —120 For outlet crown not nbm.rp.d,compels NW by —.6 m.Ihods described in tee design procedure -600 - -108 -500 -96C_ -400 -84 / - -300 / -72 . - - -66 7E/b0 C F'. _ -200 _g0 % `00 FyG,ry -2 -54 - / W . .- ,4os 00 4 1.n -3 ----- a F _ ® -100 = 42 00 X00 �� w -4 -80 /2 /• R' x cD / C —36 . Sp0 s00 —5 V w -60 W -33 61,00 500 _6 ® -50 I- - - W--30 0 -40 >: g0_ 0 -8 _ • G -27 e. 0 _ . 0 'N -10 —30 O —24 - -21 20 _ -18 -20 _10 --15 • —8 —6 I.-12 • —5 —4 - HEAD FOR . CONCRETE PIPE CULVERTS FLOWING FULL • BUREAU OF PUBLIC ROADS JAN. 1903 p n =0.012 185 FLOW THROUGH TRAPEZOIDAL DRAINAGE SWALE Q= (1.49 *A* R^(2/3) * S^(112))/N 0.035 s= 0.035 ft/ft BOTTOM= 8 ft SIDE SLOPE 0.25 ft/ft WETTED HYDRAULIC DEPTH AREA PERIMETER RADIUS AR(2/3) Q velocity 0.1 0.8400 8.8246 0.0952 0.1751 1.39 1.66 0.2 1.7600 9.6492 0.1824 0.5661 4.51 2.56 0.3 2.7600 10.4739 0.2635 1.1344 9.04 3.27 0.4 3.8400 11.2985 0.3399 1.8701 14.89 3.88 0.5 5.0000 12.1231 0.4124 2.7704 22.06 4.41 0.6 6.2400 12.9477 0.4819 3.8357 30.55 4.90 0.7 7.5600 13.7723 0.5489 5.0683 40.37 5.34. 0.9 9.9876 15.1742 0.6582 7.5573 60.19 6.03 1.0 12.0000 16.2462 0.7386 9.8054 78.09 6.51 1.1 13.6400 17.0708 0.7990 11.7450 93.54 6.86 1.2 15.3600 17.8955 0.8583 13.8726 110.49 7.19 1.3 17.1600 18.7201 0.9167 16.1929 128.97 7.52 1.4 19.0400 19.5447 0.9742 18.7108 149.02 7.83 1.5 21.0000 20.3693 1.0310 21.4313 170.69 8.13 1.6 23.0400 21.1939 1.0871 24.3592 194.01 8.42 1.7 25.1600 22.0186 1.1427 27.4995 219.02 8.70 1.8 27.3600 22.8432 1.1977 30.8571 245.76 8.98 1.9 29.6400 23.6678 1.2523 34.4370 274.27 9.25 2.0 32.0000 24.4924 1.3065 38.2439 304.59 9.52 2.1 34.4400 25.3170 1.3603 42.2828 336.76 9.78 2.2 36.9600 26.1417 1.4138 46.5584 370.81 10.03 2.3 39.5600 26.9663 1.4670 51.0755 406.79 10.28 2.4 42.2400 27.7909 1.5199 55.8391 444.72 10.53 2.5 45.0000 28.6155 1.5726 60.8536 484.66 10.77 2.6 47.8400 29.4401 1.6250 66.1239 526.64 11.01 2.7 50.7600 30.2648 1.6772 71.6547 570.69 11.24 2.8 53.7600 31.0894 1.7292 77.4505 616.85 11.47 2.9 56.8400 31.9140 1.7810 83.5159 665.15 11.70 3.0 60.0000 32.7386 1.8327 89.8556 715.64 11.93 3:1 63.2400 33.5633 1.8842 96.4740 768.36 12.15 3.2 66.5600 34.3879 1.9356 103.3757 823.32 12.37 3.3 69.9600 35.2125 1.9868 110.5652 880.58 12.59 3.4 73.4400 36.0371 2.0379 118.0469 940.17 12.80 3.5 77.0000 36.8617 2.0889 125.8251 1002.12 13.01 3.6 80.6400 37.6864 2.1398 133.9044 1066.47 13.23 3.7 84.3600 38.5110 2.1905 142.2890 1133.24 13.43 APR. 23. 2001 2: 12PM MCCOMAS LACINA NO, 2347 P. 1/1 i, a �_�•�� Lt McComas-Lacina Construction LC General Contractors Date 4-23-2007 Tom Schnell Iowa City,la 52240 RE:Building H Remodel®Iowa City Airport Preliminary site investigation on the building expansion phase 1&2. The site is assumed to be uncontaminated and sub-grade clean of any utilities,old structures,unsuitable soils or hidden/latent problems. ArchitecturalfEngineering Fees average 7 to 12 percent of the building costs and are required with City of Iowa City. City Permits are around 4 Percent.This must be figured an top cite budgets below: Budget on Phase 1: 60 by 30 Feet Hanger expansion®$70.00 sqft(No Doors)(1800 sqft) $ 126,000.00 70 by 20 Feet Office Exp.Shell Only®$70 sqft(1400sgft) $ 98,000.00 Interior Build-out®$35 sqft(1400 sqft) $ 49,000.00 No Exterior Landscaping,utilities or sidewalks figured. Budget for Phase 2: 60 by 20 Lower Garage and Ceiling Remodel®$35 sqft(1200 sgft) $ 42,000.00 • 60 by 20 2°d Pir.Interior Remodel®$40.00 silt(1200 sqft) $ 48,000.00 4 by 30 feet Int,Steps&Grating®$30.00sgft(184 sgft) $ 5,888.00 Phase I is for the Expansion Hanger insulated shell complete with inert gas heat,foundation and slab with no specialized slab coatings and no doors and an insulated shell and interior build out for offices with interior doors&exterior windows.No exterior landscaping, additional sidewalks are figured. One hour fire Separation is included. Phase 2 is modifying the wash bay into a lower level garage and adding a second level for offices with grated stairs and hallway from the hanger. One hour fire separation included. Thank you for allowing us to bid this project. Sincerely, 1211.1 [�J Mark A.Johnson Estimator&Project Manager 1310 Highland Court Iowa City,lows 52240 Telephone:(319)338-1125 FAX:(319)31R-5964 • 1 Prepared by: Michael Tharp, Operations Specialist, 1801 S.Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION NO. RESOLUTION ADOPTING FY 2007 DISADVANTAGED BUSINESS ENTERPRISE GOALS FOR FY07 U.S. DOT ASSISTED CONTRACTS. WHEREAS, the Federal Aviation Administration (FAA) requires that airports have a disadvantaged business enterprises (DBE) policy which contains DBE goals that must be used when the airport plans to award $250,000 or more in prime contracts funded by Airport Improvement Program grants; and WHEREAS, the Iowa City Airport Commission plans to award contracts over the $250,000 threshold in FY07; and WHEREAS, the Iowa City Airport Commission should adopt the attached DBE goals for FY07 assisted contracts. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION, THAT: 1. The attached DBE goals for FY07 assisted contracts is adopted. 2. The Iowa City Municipal Airport will accept public comment for a period of 1 week following the adoption of this resolution. All comments received before the May 10, 2007, at said meeting, and during the following week shall be forwarded to the FAA. Passed and approved this day of , 2007. CHAIRPERSON Approved by ATTEST: ,Zirs,r,S C-3-01- SECRETARY City Attorney's Office It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent Farris Hartwig Horan Rettig Staley l Attachment 4 Section 26.45: Overall Goal Calculation Amount of Goal 1. The Iowa City Municipal Airport's overall goal for FY 2007 is the following: 8.0% of the Federal Financial assistance we will expend in DOT-assisted contracts. IFTA recipients add: exclusive of FTA funds to be used for the purchase of transit vehicles.] 2. $2,681,500 is the dollar amount of DOT-assisted contracts that the Iowa City Municipal Airport expects to award during FY 2007. This means that the Iowa City Municipal Airport has set a goal of expending$179,512 with DBEs during this fiscal year/projects. Methodology used to Calculate Overall Goal Step 1:26.45(c) Determine the base figure for the relative availability of DBEs. The base figure for the relative availability of DBE's was calculated as follows: Ready,willing, and able DBEs Base figure = All firms ready,willing and able The base figure was determined by the following: Base Figure= Heavy/Highway X ready,willing, able DBE Heavv/Highwav Total funds ready,willing, able Heavy/Highway +Engineer X ready,willing, able DBE engineering Total funds ready,willing, able engineering Base figure= $2,243,900/$2,681,500 X 5/59 + $437,600/2,681,500 X 4/56 = 0.84 (8.47%) + 0.16(7.15%) = 5.41% The data source or demonstrable evidence used to derive the numerator was the Iowa Department of Transportation 2007 DBE Directory. DBE listed firms within the three county area of the Iowa City—Cedar Rapids, Iowa, Metropolitan Area. The data source or demonstrable evidence used to derive the denominator was the 2004 County Business Patterns for the Iowa City—Cedar Rapids, Iowa Metropolitan Area. The data identified is for Heavy and Civil Engineering Construction (NIACS Code 237) and Engineering Services (NIACS Code 54133). Wien we divided the numerator by the denominator we arrived at the base figure for our overall goal and that number was 8.26%. _ et Step 2:26.45(d) After calculating a base figure of the relative availability of DBEs, evidence was examined to determine what adjustment was needed to the base figure in order to arrive at the overall goal. In order to reflect as accurately as possible the DBE participation we would expect in the absence of discrimination we have adjusted our base figure downward by 0.26%. The data used to determine the adjustment to the base figure was the DBE participation in FY 2005 (4.9%) and FY 2006 (11.1%). By identifying the average for FY 2005 and FY 2006 and averaging this value with the value arrived at from Step 1 and adjusted goal was determined that will accurately reflect what the Iowa City Municipal Airport can achieve for the type of work to be done in FY 2007. The reason we chose to adjust our figure using this data was because the historical trends indicate what has been available for similar projects at the Iowa City Municipal Airport. From this data,we have adjusted our base figure to 8.0%. Public Participation The goal information will be published in the minutes of the Iowa City Municipal Airport Commission public meetings. They will be presented at the Airport Commission meeting in May, 2007. Comments will be received prior to the meeting and for one-week after the meeting. A summary of the comments will be provided. Race Conscious—Race Neutral The Iowa City Municipal Airport will meet the maximum feasible portion of its overall goal by using race neutral means of facilitating DBE participation. The Iowa City Municipal Airport uses the following race-neutral means to increase DBE participation: • Provide DBE directories to all potential prime contractors. • Offer instructions and clarification on bid specifications, general bidding requirements, and our procurement policy and procedures to small businesses as requested. • Maintain a file of bid documents from past procurements and permit DBE's and other small business firms to review and evaluate these documents. • When requested, conduct debriefing sessions to explain why certain bids were unsuccessful. • Provide information on certification procedures, subcontracting, and bonding requirements to all small businesses. • Place bid notices in local newspapers and with trade associations. • Make bid specifications available to DBE contractor associations and technical assistance agencies. • Provide DBE's and DBE organizations with lists of majority firms bidding as prime contractors as requested. We estimate that, in meeting our overall goal of 8.0%, we will obtain 1.0% from race-neutral participation and 7.0%through race-conscious measures. This breakout is based on the fact that J in FY-06, the Iowa City Municipal Airport's accomplishments exceeded their goal by 2.1%, which is evidence of race-neutral participation. We will adjust the estimated breakout of race-neutral and race-conscious participation as needed to reflect actual DBE participation and we will track and report race-neutral and race-conscious participation separately. For reporting purposes, race-neutral DBE participation includes, but is not limited to the following: DBE participation through a prime contract a DBE obtains through customary competitive procurement procedures; DBE participation through a subcontract on a prime contract that does not carry a DBE goal; DBE participation on a prime contract exceeding a contract goal; and DBE participation through a subcontract from a prime contractor that did not consider a firm's DBE status in making the award. Contract Goals The Iowa City Municipal Airport will use contract goals to meet any portion of the overall goal that the Airport does not project being able to meet using race-neutral means. Contract goals are established so that, over the period to which the overall goals applies,they will cumulatively result in meeting any portion of our overall goal that is not projected to be met through the use of race- neutral means. We will establish contract goals only on those DOT-assisted contracts that have subcontracting possibilities. We need not establish a contract goal on every such contract, and the size of the contract goals will be adapted to the circumstances of each such contract. We will express our contract goals as a percentage of the total amount of a DOT-assisted contract. rage t or z Michael Tharp From: Hughes, David ( Des Moines) [David.Hughes@earthtech.com] Sent: Friday, May 04, 2007 10:57 AM To: Howard Horan Cc: Michael Tharp; Sue Dulek; Eaton, Steve Subject: RE: IOW Project Update Howard, Here's a summary of the projects as of May 4, 2007. See you next week. Are you planning on attending the bid opening on Tuesday? Box Culvert(AIP-10) No change on this project. All required closeout documentation for the construction has been submitted to FAA for review and concurrence. We are awaiting concurrence from FAA. Grant will be closed once Historic Documentation of United Hangar and Public Historic Booklet are completed. Iowa City Airport—Public Historic Booklet(AIP-10) Earth Tech subconsultant, Tallgrass Historians, is working on this element of the project. All internal reviews have been completed on this document to insure that the requirements of the Memorandum of Agreement(MOA) were addressed. We are waiting on approval / comment of the document from the State Historical Preservation Officer (SHPO). Once comments have been received from the SHPO, a type-set mock-up of the document will be completed for reviews prior to printing. Engineering Services for Runway Grading (AIP-11) This grant is completed. Closeout documentation requires updated Exhibit "A"- Airport Property Map. We are waiting to submit so that the updated Exhibit"A"will also reflect the sale of the Hagen Property. We are working with City Legal to complete the closeout of this project. South Airfield Planning Study (AIP -12) A meeting to review alternative layouts for the site development was held on March 28th. The airport has received some feedback from the Army Reserve and National Guard regarding their future plans at the airport and this will be taken into consideration in finalizing the alternatives. We have received some initial input from the steering committee on the inclusion of the grass runway in the development schemes and are now looking for input from the airport commission as to their desires to protect property for future development of a grass runway. Grading (AIP-13) We met with the contractor on-site last week and he indicated that materials that he is moving on adjacent projects are still high in moisture contents and he would like to wait a little longer before remobilizing equipment to the site to finish this work. We told him that everyone understood the need to move drier material and postponing construction for a few more weeks would not be a problem. Project has been shut down for the winter. Erosion control measures have been placed and barricades on Dane Road have been revised to restrict traffic from using the roadway. Work on this project will resume in the Spring of 2007 once weather conditions allow. Grading is approximately 90% complete with the overall phase of this project approximately 60%complete. Obstruction Mitigation (AIP-13) • 5/4/2007 rasc z. vi z. We have met with Mid-American Energy, Medicom and the McEleney Autoplex since the last airport commission meeting. Mid-American Energy and Medicom are preparing agreements that include project costs for the section of line that will have to be relocated along Highway 1. We anticipate having these agreements to review with the commission and FAA later this month. We have surveyed obstructions on the McElpney Autoplex and are preparing drawings showing proposed mitigation of these to discuss with FAA and the property owner later this month. Approach Surveys—405 Surveys (AIP-13) We received initial comments from FAA last week regarding the 405 Approach survey information which we submitted to FM for review in early January, 2007. We addressed the comments and resubmitted to FAA last week. FAA will use this information to develop instrument approaches to Runways 7, 25 and 30. We are coordinating with FAA to determine publication dates for the LPV approaches and will provide that information once it becomes available. Paving and Lighting (AIP-14) We have started our design on this project. Field survey has been completed and office design is started. We have a meeting next week with the city and the Iowa Department of Transportation to discuss requirements for removal / regarding of Dane Road in the Highway 1 Right of Way. Based on the FAA Project Initiation Letter we are working to complete the plans and specifications so that the project is ready to advertise June 1St Taxilanes—South Area(2007 State Grant) A pre-bid conference was held scheduled for May 151 and receipt of bids for May 8th. We anticipate having a recommendation of contract award for the Airport Commission Meeting on May 10th. T-Hangar A Rehabilitation (2007 State Grant) Receipt of bids or this project is scheduled for May 8th. We anticipate having a recommendation of contract award for the Airport Commission Meeting on May 10th. Letters requesting quotes for the Hangar Access Doors were sent to general contractors and door suppliers. Quotes will be received prior to the Airport Commission Meeting on May 10th. Terminal Apron Rehabilitation (AIP Recapture) We are planning to continue design so that late summer construction can take place in this area. David B. Hughes, P.E. Earth Tech Des Moines, IA 515-244-1470 515-244-4803 fax 5/4/2007 Prepared by: Michael Tharp,Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION NO. RESOLUTION AWARDING CONTRACT AND AUTHORIZING THE CHAIRPERSON TO SIGN AND THE SECRETARY TO ATTEST A CONTRACT FOR THE REHABILITATION OF THE SOUTH T-HANGAR TAXILANES. WHEREAS, has submitted the lowest responsible bid of __for construction of the above named project. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION, THAT: 1. The contract for the construction of the above named project is hereby awarded to subject to the condition that awardee secure adequate performance and payment bond, insurance certificates, and contract compliance program statements. 2. The Chairperson is hereby authorized to sign and the Secretary to attest the contract for construction of the above-named project, subject to the condition that awardee secure adequate performance and payment bond, insurance certificates, and contract compliance program statements. Passed and approved this day of , 2007. CHAIRPERSON Approved by ATTEST: vakitsa - 3 G� SECRETARY City Attorney's Office It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent Farris Hartwig Horan Rettig Staley Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION NO. RESOLUTION AWARDING CONTRACT AND AUTHORIZING THE CHAIRPERSON TO SIGN AND THE SECRETARY TO ATTEST A CONTRACT FOR THE INSTALLATION OF CONCRETE FLOORS IN HANGAR BUILDING A WHEREAS, has submitted the lowest responsible bid of for construction of the above named project. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION, THAT: 1. The contract for the construction of the above named project is hereby awarded to subject to the condition that awardee secure adequate performance and payment bond, insurance certificates, and contract compliance program statements. 2. The Chairperson is hereby authorized to sign and the Secretary to attest the contract for construction of the above-named project, subject to the condition that awardee secure adequate performance and payment bond, insurance certificates, and contract compliance program statements. Passed and approved this - day of , 2007. CHAIRPERSON Approved by ATTEST: ahs. Cr- 3 —a SECRETARY City Attorney's Office It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent Farris Hartwig Horan Rettig Staley • • Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION NO. • RESOLUTION AWARDING CONTRACT AND AUTHORIZING THE CHAIRPERSON TO SIGN AND THE SECRETARY TO ATTEST A CONTRACT FOR THE REPLACEMENT OF ACCESS DOORS ON HANGAR BUILDINGS A AND B. WHEREAS, has submitted the lowest ,responsible quote of for construction of the above named project. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION, THAT: 1. The contract for the construction of the above named project is hereby awarded to subject to the condition that awardee secure adequate performance and payment bond, if required by the City Attorney's Office, insurance certificates, and contract compliance program statements. 2. The Chairperson is hereby authorized to sign and the Secretary to attest the contract for construction of the above-named project, subject to the condition that awardee secure adequate performance and payment bond, if required by the City Attorney's Office, insurance certificates, and contract compliance program statements. Passed and approved this day of , 2007. CHAIRPERSON Approved by ATTEST: SECRETARY City Attorney's Office • It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent • Farris Hartwig Horan Rettig Staley . I Iowa City Municipal Airport Viewing Area Purpose Create a viewing area where the general public can have an unobstructed view of airport operations at the Iowa City Municipal Airport. The airport viewing area will consist for airport history display, picnic area, and playground area and airport observation panels that help explain airport operations. Planned Features • Airport History Panels —panels describing the airports history with an emphasis on the airport's role as a stop on the US Air Mail route. • Airport Layout Panels—panels that explain the airport layout and what the visitor can expect to see. • Miniature Runways— Runways 25/7 and 12/30 layout with markings. • Air Traffic Communications - Radio kiosk providing access to weather, local traffic and regional traffic communications. Patrons will have the ability to listen to communications between the pilots arriving or departing Iowa City. Kiosk allows visitors to select one of the three channels. Once select the communication will be "open"for 5 minutes that will automatically shut off. • Shelter Area —visitors will have access to picnic tables. Air Traffic Com kiosk will be locate in the Shelter Area • Aviation Themed Playground - Play area and facilities for younger visitors. Aviation themed equipment such as a spring ride-on plane, mock cockpit, pilot cut out face, etc. • Miscellaneous Equipment— Litter Receptacle, Bike Rack, Benches Proposed Viewing Area Layout Bench Bench _ Shelter area 111.1.1111V . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Information P..laygroarid:area : : : :: :• Panel Proposed Viewing Area Layout Bench >�Groundl: Information Panel Bench Development Plan Phase One —Shelter, shelter pad, information panel, picnic tables and litter receptacle. Phase Two — Benches, radio kiosk, information panels Phase Three— Miniature Runways, Playground 2007/04/30 14:52 MOW-Location Identifier-Iowa KI OW 301452Z AUTO 24009KT 1081‘11 CLR City Municipal Airport 23/12 A2991 RMK A02'SLP123 702330122 301452Z -Date and Time of obser- vations- 30th day at 1452 Zulu 58002 ' AUTO-Type of Observation- Auto- * mated weather station 24009KT-Wind direction and speed Wind from 240 at 09 knots 10SM-Visibility- 10 miles CLR-Cloud Cover- Clear • 23/12-Current Temperature and Dew Point, in Celsius k A2991 -Altimeter Setting-Baromet- ric Pressure measured in inches of mercury 29.91 InHg RMK-begins the remarks section A02-Station has a precipitation sen- sor-tells which type of precip is fal- ling SLP123-Barometric Pressure given in millibars-read as 1012.3 Select a radio frequency to tune in T02330122 Temperature and Dew Point in decimal form-Read as 023.3 and 012.2 • Common Traffic Advisory Frequency(CTAF) 58002-Barometric Pressure Trend Used by aircraft at the Iowa City Airport What are they saying??? O N-Number-Aircraft Tail Number- Iowa City Automated Weather Observation System Used to identify aircraft speaking Used by Pilots to get the most recent weather conditions O Cedar Rapids Approach Used by pilots in the vicinity of Cedar Rapids 0 Chicago Center Used by pilots in the vicinity. j r P ' P'=16' D a 0 <1\/> D D Shelter Footprint. Beanch Covered Shelter 20'Tall Picnic tables A \ / Displays Monthly Expense Report - April '07 Check Requests During Month Approved Airport Budget City Budget Check Requests 4/5/2007 Earth Tech(South Taxilane/Hangar A Rehab) $7,768.44 4/12/2007 Iowa Workforce Development(Elevator Operating Fee) $125.00 4/16/2007 Walker Welding(Mower Hitch Repair) $28.00 4/16/2007 Doors Inc(Door Lockset) $129.96 4/19/2007 Earth Tech(West Terminal Apron Rehab) $2,915.27 4/26/2007 Hawkeye Fire&Safety(Fire Extinguisher Check/Refills) $105.00 Airport Operating Expenses $387.96 • City CIP Fund Expenses $10,683.71 Total Expenses $11,071.67 Capital Projects Construction Contracts Project Bid Amount Paid During Month Paid During Year Paid To Date %-Paid Runway 7 Grading $950,154.00 $558,462.20 $558,462.20 58.8 South Economic Study-ALP Update $15,000.00 $8,696.00 $8,696.00 58.0 South T-Hangar Taxilane Hangar A-Concrete Floors Hangar A&B-Access Doors West Terminal Apron Pending Expenses Total Pending Expenses $0.00 $0.00 EXPE: 05.03.07 14:46:48 Page: 1 Iowa City General Ledger System Budget to Actuals Expenditures Summary FY 2007 Expense Reporting For the period 04.01.07 to 04.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport 560100 Airport Operations PERSONNEL 411000 Perm Full Time 36197.00 30666.12 2784.00 5530.88 84.72 412000 Perm Part Time 20935.00 19311.40 2051.64 1623.60 92.24 413000 Temporary Employees 5332.39 49.88 -5332.39 414100 Overtime Wages 1748.70 -1748.70 414500 Longevity Pay 1050.00 1050.00 100.00 421100 Health Insurance 11218.00 5509.20 550.92 5708.80 49.11 421200 Dental Insurance 461.00 373.40 37.34 87.60 81.00 421300 Life Insurance 182.00 180.91 1.09 99.40 • 421400 Disability Insurance 423.00 212.07 210.93 50.13 421500 Unemployment Compensation 8544.00 8544.00 422100 Fica 4983.00 4352.05 364.43 630.95 87.34 423100 Ipers 3745.00 3112.39 282.36 632.61 83.11 424500 Monthly Cellular/PCS 250.00 25.00 -250.00 Total PERSONNEL 87738.00 72098.63 6145.57 15639.37 82.17 SERVICES 431080 Recording Fees 7.00 7.00 432020 Annual Audit 138.00 553.92 -415.92 401.39 432060 Consultant Services 12000.00 2259.00 9741.00 18.83 432070 Management Services 8000.00 11250.00 -3250.00 140.63 433020 Local Phone Service 170.14 -170.14 433030 Long Distance Service 24.00 21.68 2.32 90.33 435060 Legal Publications 11.47 -11.47 436030 Transportation 650.00 855.40 380.16 -205.40 131.60 436050 Registration 775.00 200.00 575,00 25.81 436060 Lodging 875.00 1221.81 -346.81 139.64 436070 Misc Travel 40.00 -40.00 436080 Meals 250.00 112.00 36.00 138.00 44.80 437010 Comp Liability Ins 11936.00 7797.75 4138.25 65.33 437020 Fire & Casualty Ins 15515.00 10831.93 4683.07 69.82 437030 Worker's Comp Ins 293.00 66.00 227.00 22.53 437042 Fidelity Bond 1050.00 -1050.00 EXPE: 05.03.07 14:46:48 Page: 2 Iowa City General Ledger System Budget to Actuals Expenditures Summary FY 2007 Expense Reporting For the period 04.01.07 to 04.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) SERVICES (CONTINUED) 437200 Loss Reserve Payment 5000.00 5000.00 438010 Stormwater Utility Charges 6512.00 5327.64 1184.36 81.81 438030 Electricity 15212.00 12505.34 1129.64 2706.66 82.21 438070 Heating Fuel/Gas 5539.00 7286.89 830.64 -1747.89 131.56 438080 Sewer Utility Charge 1946.00 1015.08 930.92 52.16 438090 Water Utility Charge 1342.00 960.70 381.30 71.59 439020 Plant Care 68.90 -68.90 439030 Testing Services 956.00 797.60 158.40 83.43 439060 Other Prof Services 141.40 -141.40 441010 Vehicle Repairs and Maintenance 1402.00 2515.29 28.00 -1113.29 179.41 442010 Bldg Rep & Maint 3500.00 3524.73 75.00 -24.73 100.71 442020 Repair of Structure 207.00 626.70 129.96 -419.70 302.75 442030 Repair of Heating Equip 252.00 281.50 -29.50 111.71 442040 Repair of Cooling Equip 1175.58 -1175.58 442060 Repair of Electric/Plmbg 30.00 272.97 -242.97 909.90 442070 Bldg Pest Control 250.00 339.50 33.95 -89.50 135.80 443010 Equip Rep & Maint 1236.64 -1236.64 443050 Radio Equipment Rep 100.00 100.00 443060 Telecom Equip Rep 1865.00 1788.00 77.00 95.87 443070 Misc Comm Equip Rep 6688.00 -6688.00 443080 Other Repair & Maint 4074.00 767.38 125.00 3306.62 18.84 445060 Laundry Service 763.00 763.00 445070 Equipment Service 863.00 740.00 74.00 123.00 85.75 445090 Hauling 301.00 301.00 445140 Outside Printing 458.00 85.50 372.50 18.67 445230 Technical Services 2465.00 3521.22 655.10 -1056.22 142.85 446100 City Attorney Chgbck 3818.00 2577.57 1240.43 67.51 446130 ITS-PC/Peripheral Support 875.00 400.00 475.00 45.71 446140 ITS-Computer Replacement Chargeb 277.06 39.58 -277.06 446150 ITS-Application Development Fees 600.00 600.00 446160 ITS-Network/Internet Charge 510.00 420.00 30.00 90.00 82.35 446200 Photocopying Chargeback 192.00 331.92 -139.92 172.88 EXPE: 05.03.07 14:46:48 Page: 3 Iowa City General Ledger System Budget to Actuals Expenditures Summary FY 2007 Expense Reporting For the period 04.01.07 to 04.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) SERVICES (CONTINUED) 446220 Phone Service-Department Chargeb 484.00 433.08 50.92 89.48 446300 Phone Equipment/Line Charge 963.00 585,00 378.00 60.75 446320 Mail Chargebacks 178.00 542.43 -364.43 304.74 446350 City Vehicle Repl, 15098.00 9285.18 5812.82 61.50 449060 Dues & Memberships 385.00 525.00 -140.00 136.36 449140 Tools & Equip. Rent. 500.00 500.00 449360 Interest Expense 48157,00 40131.10 4013.11 8025.90 83.33 Total SERVICES 175260.00 143616.00 7580.14 .31644.00 81.94 SUPPLIES 452010 Office Supplies 112.00 694.01 -582.01 619.65 452030 Minor Off Equip/Furn 500.00 455.78 44.22 91.16 454020 Subscriptions 193.00 108.00 85.00 55.96 461040 Ag Chemicals 127.00 234.95 -107.95 185.00 462020 Minor Sanitation Equipment 1000.00 857.94 142.06 85.7Y 462030 Sanitation & Industrial Supplies 292.00 859.71 -567.71 294.42 465020 Gasoline 38.00 38.00 465050 Other Fuels 2582.00 2739.24 -157.24 106.09 465060 Grease & Oil 94.93 -94.93 465070 Other Lubricants 34.00 34.00 466020 Lumber/Hardware 167.00 167.00 466040 Plumbing Supplies 35.00 3.01 31.99 8.60 466050 Electrical Supplies 293.42 -293.42 466060 Bldg & Improvement Materials 1113.00 760.00 353.00 68.28 467020 Minor Equipment Repair Material 21.00 21.00 468020 Concrete 144.00 -144.00 468030 Asphalt 1830.00 246.01 1583.99 13.44 468050 Sand 47.00 50.92 -3.92 108.34 469040 Traffic Control Improvement 228.00 99.98 128.02 43.85 ' 469190 Tools & Minor Equipment 883.00 808.14 74.86 91.52 469210 First Aid/Safety Supplies 54.39 -54.39 469260 Fire Ext. & Refills 105.00 105.00 -105.00 EXPE: 05.03.07 14:46:48 Page: 4 Iowa City General Ledger System Budget to Actuals Expenditures Summary FY 2007 Expense Reporting For the period 04.01.07 to 04.30.07 YTD Period Account Appropriated Expenditures Expenditures Encumbrance Balance % Used 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) SUPPLIES (CONTINUED) 469320 Misc Supplies 477.00 477.00 Total SUPPLIES 9679.00 7849.43 105.00 760.00 1069.57 88.95 CAPITAL OUTLAY 473010 Contracted Improvements 20000.00 21689.10 -1689.10 108.45 473020 Non-Contracted Improvements 12463.00 12958.00 -495.00 103.97 474420 Other Operating Equipment Total CAPITAL OUTLAY 32463.00 34647.10 -2184.10 106.73 OTHER FINANCIAL USES 490150 Operating Subsidy 6259.00 6259.00 490190 Interfund Transfers Out- Fu 43543.00 36284.70 3628.47 7258.30 83.33 Total OTHER FINANCIAL USES 49802.00 36284.70 3628.47 13517.30 72.86 Total Airport Operations 354942.00 294495.86 17459.18 760.00 59686.14 83.18 Total Airport 354942.00 294495.86 17459.18 760.00 59686.14 83.18 "' GRAND TOTAL ttt 354942.00 294495.86 17459.18 760.00 59686.14 83.18 REVE: 05.03.07 14:46:56 Page: 1 Iowa City General Ledger System Budget to Actuals Revenues Summary FY 2007 Revenue Reporting For the period 04.01.07 to 04.30.07 Estimated YTD Period Account Revenue Revenue Revenue Remainder I 7600 Airport 560100 Airport Operations INTERGOVERNMENTAL REVENUE 334900 Other State Grants 3418.00 -3418.00 Total INTERGOVERNMENTAL REVENUE 3418.00 -3418.00 MISCELLANEOUS REV. 369100 Reimb of Expenses 220.00 30.00 190.00 13.64 Total MISCELLANEOUS REV. 220.00 30.00 190.00 13.64 USE OF MONEY & PROP. 381100 Interest on Investments 152.00 122.00 30.00 80.26 382100 Land Rental 37085.00 33144.44 6598.92 3940.56 89.37 382200 Building/Room Rental 174629.00 158734.51 18625.51 15894.49 90.90 384200 Vending Machine Comm 153.90 -153.90 384900 Other Commissions 15000.00 14579.40 500.00 420.60 97.20 Total USE OF MONEY & PROP. 226866.00 206734.25 25724.43 20131.75 91.13 OTHER FINANCING SOURCES 392100 Sale of Land 439649.00 439649.00 439649.00 100.00 393120 General Levy 199267.00 63583.31 135683.69 31.91 Total OTHER FINANCING SOURCES 638916.00 503232.31 439649.00 135683.69 78.76 Total Airport Operations 866002.00 713414.56 465373.43 152587.44 82.38 Total Airport 866002.00 713414.56 465373.43 152587.44 82.38 *1* GRAND TOTAL *** 866002.00 713414.56 465373.43 152587.44 82.38 TRID: 05.03.07 14:47:29 Page: 1 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport 560100 Airport Operations 411000 Perm Full Time 04.13.07 Old Sys 070411010008 473805\PAYROLL RECAP\PAYROLL 13-APR 1392.00 04.27.07 Old Sys 070425010007 474142\PAYROLL RECAP\PAYROLL 27-APR 1392.00 Total Perm Full Time 2784.00 412000 Perm Part Time 04.13.07 Old Sys 070411010008 473805\PAYROLL RECAP\PAYROLL 13-APR 1067.52 04.27.07 Old Sys 070425010007 474142\PAYROLL RECAP\PAYROLL 27-APR 984.12 Total Perm Part Time 2051.64 413000 Temporary Employees 04.13.07 Old Sys 070411010008 473805\PAYROLL RECAP\PAYROLL 13-APR 26.25 04.27.07 Old Sys 070425010007 474142\PAYROLL RECAP\PAYROLL 27-APR 23.63 Total Temporary Employees 49.88 421100 Health Insurance 04.12.07 Journal 070416084334 005737 APR BCBS\Apr health insurance old # 550.92 Total Health Insurance 550.92 421200 Dental Insurance 04.12.07 Journal 070416084334 005739 APR DELTA DENTAL\Apr dental insuran 37.34 Total Dental Insurance 37.34 422100 Fica 04.13.07 Old Sys 070411010008 4130599\FICA\CITY CONTRIBUTION 185.51 04.27.07 Old Sys 070425010007 4270599\FICA\CITY CONTRIBUTION 178.92 Total Fica 364.43 423100 Ipers 04.13.07 Old Sys 070411010008 4133599\IPERS\CITY CONTRIBUTION 143.65 04.27.07 Old Sys 070425010007 4273599\IPERS\CITY CONTRIBUTION 138.71 Total Ipers 282.36 TRID: 05.03.07 14:47:29 Page: 2 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 424500 Monthly Cellular/PCS 04.13.07 Old Sys 070411010008 473805\PAYROLL RECAP\PAYROLL 13-APR 12.50 04.27.07 Old Sys 070425010007 474142\PAYROLL RECAP\PAYROLL 27-APR 12.50 Total Monthly Cellular/PCS 25.00 436030 Transportation 04.20.07 New Vouch 070423030003 06861770 Check:599633\THARP, MICHAEL DEAN\TR 139.20 04.20.07 New Vouch 070423030003 06861776 Check:599630\RETTIG, JANELLE\TRAVEL 120.96 04.24.07 New Vouch 070425030005 06861812 Check:599605\KORAN, HOWARD\TRAVEL R 120.00 Total Transportation 380.16 436080 Meals 04.20.07 New Vouch 070423030003 06861770 Check:599633\THARP, MICHAEL DEAN\TR 36.00 Total Meals 36.00 438030 Electricity 04.16.07 New Vouch 070417030005 06861474 Check:598700\MIDAMERICAN ENERGY\ELE 89.67 04.16.07 New Vouch 070417030005 06861543 Check:598700\MIDAMERICAN ENERGY\ELE 723.14 04.16.07 New Vouch 070417030005 06861546 Check:598700\MIDAMERICAN ENERGY\ELE 60.08 04.16.07 New Vouch 070417030005 06861547 Check:598700\MIDAMERICAN ENERGY\ELE 256.75 Total Electricity 1129.64 438070 Heating Fuel/Gas 04.16.07 New Vouch 070417030005 06861473 Check:598700\MIDAMERICAN ENERGY\GAS 10.00 04.16.07 New Vouch 070417030005 06861487 Check:598702\MIDAMERICAN ENERGY\GAS 169.10 04.16.07 New Vouch 070417030005 06861544 Check:598700\MIDAMERICAN ENERGY\GAS 521.14 04.16.07 New Vouch 070417030005 06861545 Check:598700\MIDAMERICAN ENERGY\GAS 130.40 Total Heating Fuel/Gas 830.64 441010 Vehicle Repairs and Maintenance (Equipm 04.24.07 New Vouch 070425030005 06861803 Check:599566\WALKER WELDING\REPAIR 28.00 Total Vehicle Repairs and Maintenance (Equipmen 28.00 • TRID: 05.03.07 14:47:29 Page: 3 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 442010 Bldg Rep & Maint 04.17.07 New Vouch 070418030010 06861612 Check:598710\O'EEEFE ELEVATOR CO IN 75.00 Total Bldg Rep & Maint 75.00 442020 Repair of Structure 04.24.07 New Vouch 070425030005 06861830 Check:599493\DOORS INC\LOC%SET 129.96 Total Repair of Structure 129.96 442070 Bldg Pest Control 04.09.07 New Vouch 070410030004 06861167 Check:598387\HAWEEYE PEST CONTROL I 33.95 Total Bldg Pest Control 33.95 443080 Other Repair & Maint 04.17.07 New Vouch 070418030010 06861630 Check:598815\IOWA WORKFORCE DEVELOP 125.00 Total Other Repair & Maint 125.00 445070 Equipment Service 04.25.07 New Vouch 070426030225 06862041 Check:599597\ALLIED WASTE SERVICES\ 74.00 Total Equipment Service 74.00 445230 Technical Services 04.02.07 New Vouch 070403030007 06860873 Check:598090\MIDWEST JANITORIAL SER 655.10 Total Technical Services 655.10 446140 ITS-Computer Replacement Chargeback 04.01.07 Journal 070416084334 005729 I.S.-REPLACE CHG\ITS Apr replace ch 39.58 Total ITS-Computer Replacement Chargeback 39.58 446160 ITS-Network/Internet Charge 04.01.07 Journal 070416084334 005730 ITS-NH/INTERNET CHG\Apr internet ch 30.00 Total ITS-Network/Internet Charge 30.00 TRID: 05.03.07 14:47:29 Page: 4 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 449360 Interest Expense 04.30.07 Journal 070416084334 005735 Corp Hangar Loan Int\Apr Interfund 1988.45 04.30.07 Journal 070416084334 005735 Airprt S-T Hangarint\Apr Interfund 40.28 04.30.07 Journal 070416084334 005735 Airprt SE Hangar Int\Apr Interfund 1017.02 04.30.07 Journal 070416084334 005735 Airprt SW Hangar-Int\Apr Interfund 967.36 Total Interest Expense 4013.11 469260 Fire Ext. & Refills 04.30.07 New Vouch 070501030006 06862184 Check:599768\HAWKEYE FIRE AND SAFET 105.00 Total Fire Ext. & Refills 105.00 490190 Interfund Transfers Out- Fund 04.30.07 Journal 070416084334 005735 Corp Hangar Loan Prn\Apr Interfund 1011.55 04.30.07 Journal 070416084334 005735 Airprt S-T HangarPrn\Apr Interfund 1841.30 04.30.07 Journal 070416084334 005735 Airprt SE Hangar Prn\Apr Interfund 312.98 04.30.07 Journal 070416084334 005735 Airprt SW Hangar-Prn\Apr Interfund 462.64 Total Interfund Transfers Out- Fund 3628.47 Total Airport Operations 17459.18 TRID: 05.03.07 14:47:29 Page: 5 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.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 17459.18 TRID: 05.03.07 14:47:29 Page: 6 Iowa City General Ledger System Expenditures Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.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 *** 17459.18 • TRID: 05.03.07 14:47:38 Page: 1 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport 560100 Airport Operations 382100 Land Rental 04.16.07 Payment 070416095047 00005252 1-18\IC COMM SCHOOL DIST\APRIL 07\L 353.92 04.25.07 Old Sys 070426010006 4253063\TOYOTA OF IOWA CIT\LANT REN 6245.00 Total Land Rental 6598.92 382200 Building/Room Rental 04.02.07 Payment 070402095049 00005294 1-8\PATTSCHULL RICHARD\APRIL 07\HA 208.00 04.02.07 Payment 070402095049 00005333 1-3\DOWNES & ASSOCIATES\APRIL 07\HA 153.00 04.03.07 Payment 070403101550 00005279 1-10\BULGERELLI DAVID\APRIL 07\EAN 132.00 04.03.07 Payment 070403101550 00005318 1-7\GURNETT DON\APRIL 07\HANGAR #3 310.00 04.03.07 Payment 070403101550 00005319 1-8\ROOF, KEITH\APRIL 07\HANGAR #32 512.00 04.03.07 Payment 070403101550 00005331 1-4\KRUSE DAVE\APRIL 07\HANGAR #18 132.00 04.03.07 Payment 070403101550 00005357 1-13\LUST, GARY\APRIL 07\HANGAR #4 121.00 04.04.07 Payment 070404093220 00005254 1-2\FIELD HOWARD\APRIL 01\HANGAR # 153.00 04.04.07 Payment 070404093220 00005266 1-16\BRUMLEY JAMES\APRIL 07\HANGAR 132.00 04.04.07 Payment 070404093220 00005276 1-12\SCHNELL TOM\APRIL 07\HANGAR # 158.50 04.04.07 Payment 070404093220 00005287 1-26\HARTWIG RANDY\APRIL 07\HANGAR 153.00 04.04.07 Payment 070404093220 00005288 1-22\GORDON DENNIS\APRIL 07\HANGAR 459.00 04.04.07 Payment 070404093220 00005293 1-9\LACINA DAVE\APRIL 07\HANGAR #5 180.50 04.04.07 Payment 070404093220 00005306 1-17\EDMONDS TERRY\APRIL 07\HANGAR 285.00 04.04.07 Payment 070404093220 00005317 1-1\FLOOD BRYAN\APRIL 07\HANGAR #1 132.00 04.05.07 Payment 070405092359 00005298 1-6\ALLENDER PATRICK\APRIL 07\HANG 153.00 04.05.07 Payment 070405092359 00005302 1-10\TEARSE DAVID\APRIL 07\HANGAR 153.00 04.05.07 Payment 070405092359 00005327 1-5\SINGLETARY ROBERT\APRIL 07\HAN 121.00 04.05.07 Payment 070405092359 00005346 1-13\HERTZ CORPORATION\APRIL 07\OFF 100.00 04.06.07 Payment 070406093208 00005280 1-3\SHANKLIN DOUG\PAYMENT 153.00 04.06.07 Payment 070406093208 00005295 1-14\ANDERSON MARK\APRIL 07\HANGAR 175.00 04.06.07 Payment 070406093208 00005297 1-17\NE IA PAYS THERPY ASSOC\APRIL 180.50 04.06.07 Payment 070406093208 00005297 1-17\NE IA PHYS THERPY ASSOC\APRIL 158.50 04.06.07 Payment 070406093208 00005322 1-15\OPERATOR PERFORMANCE LAB\APRIL 1330.00 04.06.07 Payment 070406093208 00005322 1-15\OPERATOR PERFORMANCE LAB\APRIL 153.00 04.09.07 Payment 070409093624 00005285 1-2\MASCARI RICK\APRIL 07\HANGAR # 132.00 04.10.07 Payment 070410100608 00005264 1-22\RUYLE JOHN\APRIL 07\HANGAR #3 358.00 TRID: 05.03.07 14:47:38 Page: 2 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) 382200 Building/Room Rental (CONTINUED) 04.10.07 Payment 070410100608 00005278 1-28\HALL ROBERT\APRIL 07\HANGAR # 121.00 04.10.07 Payment 070410100608 00005281 1-24\HOLLY FORREST\APRIL 07\HANGAR 132.00 04.10.07 Payment 070410100608 00005299 1-2\TRATCHEL JACK\APRIL 07\HANGAR 132.00 04.10.07 Payment 070410100608 00005301 1-29\CRALKLEY BEN\APRIL 07\HANGAR 132.00 04.10.07 Payment 070410100608 00005315 1-1\SQUADRONS UP\APRIL 07\HANGAR #5 153.00 04.11.07 Payment 070411093254 00005277 1-7\BULLERS JONATHAN\APRIL 07\HANG 121.00 04.11.07 Payment 070411093254 00005323 1-1\WIECHERT RONALD\APRIL 07\HANGA 132.00 04.11.07 Payment 070411093254 00005326 1-6\STEARMAN\APRIL 07\HANGAR #47 153.00 04.12.07 Payment 070412091813 00005275 1-6\RANEY CHARLES\APRIL 07\HANGAR 121.00 04.12.07 Payment 070412091813 00005338 1-13\ALEXIS PARK INN & SUITES\APRIL. 121.00 04.13.07 Payment 070413093530 00004166 1-2\OPERATOR PERFORMANCE LAB\NOV 06 7660.51 04.13.07 Payment 070413093530 00005047 1-1\FULL JERRY\MARCH 07\HANGAR #45 186.00 04.13.07 Payment 070413093530 00005284 1-5\HALL DAN\APRIL 07\HANGAR #27 132.00 04.13.07 Payment 070413093530 00005303 1-9\ZUBROD ROY\APRIL 07\HANGAR #20 132.00 04.16.07 Payment 070416095047 00005054 1-21\TUCKER JIM\MARCH 07\HANGAR #3 153.00 04.16.07 Payment 070416095047 00005305 1-3\FARRIS GREG\APRIL 07\HANGAR #2 132.00 04.16.07 Payment 070416095047 00005336 1-23\FLANAGAN JAMES\APRIL 07\HANGA 134.00 04.16.07 Payment 070416095047 00005336 1-23\FLANAGAN JAMES\CREDIT 2.00 04.17.07 Payment 070417102231 00005292 1-2\OCKENFELS TRANSFER\APRIL 07\HAN 186.00 04.17.07 Payment 070417102231 00005340 1-7\VRANEK DOUGLAS\APRIL 07\HANGAR 121.00 04.18.07 Payment 070418094212 00005328 1-15\SAPPHIRE VISTAS LLC\APRIL 07\H 132.00 04.26.07 Payment 070426090602 00005041 1-6\ZIMMERMAN GREG\MARCH 07\HANGAR 132.00 04.26.07 Payment 070426090602 00005041 1-6\ZIMMERMAN GREG\MARCH 07\HANGAR 132.00 04.26.07 Payment 070426090602 00005041 1-6\ZIMMERMAN GREG\MARCH 07\HANGAR 153.00 04.26,07 Payment 070426090602 00005041 1-6\ZIMMERMAN GREG\MARCH 07\HANGAR 153.00 04.26.07 Payment 070426090602 00005283 1-7\ZIMMERMAN GREG\APRIL 07\HANGAR 132.00 04.26.07 Payment 070426090602 00005283 1-7\ZIMMERMAN GREG\APRIL 07\HANGAR 132.00 04.26.07 Payment 070426090602 00005283 1-7\ZIMMERMAN GREG\APRIL 07\HANGAR 153.00 04.26.07 Payment 070426090602 00005283 1-7\ZIMMERMAN GREG\APRIL 07\HANGAR 153.00 04.27.07 Payment 070427093144 00004398 1-5\KLEIN DEREK\DEC 06\HANGAR # 12 132.00 04.27.07 Payment 070427093144 00004629 1-6\KLEIN DEREK\JAN 07\HANGAR # 12 132.00 04.27.07 Payment 070427093144 00004862 1-7\KLEIN DEREK\FEB 07\HANGAR # 12 132.00 TRID: 05.03.07 14:47:38 Page: 3 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED( 560100 Airport Operations (CONTINUED( 382200 Building/Room Rental (CONTINUED( 04,27.07 Payment 070427093144 00005098 1-8\KLEIN DEREK\MARCH 07\HANGAR # 132.00 04.27.07 Payment 070427093144 00005339 1-9\KLBIN DBRBK\APRIL 07\HANGAR # 132.00 04.30.07 Payment 070430114214 00005060 9-1\TEARSB DAVID\MARCH 07\HANGAR # 153.00 Total Building/Room Rental 2.00 18627.51 384900 Other Commissions 04.20.07 Old Sys 070423010005 4203077\NEWTON HONE OIL CO\GAS FLOW 500.00 Total Other Commissions 500.00 392100 Sale of Land 04.19.07 Old Sys 070423010005 4193076\WILLIS AND WILLIS\SALE OF L 439649.00 Total Sale of Land 439649.00 Total Airport Operations 2.00 465375.43 TRID: 05.03.07 14:47:38 Page: 4 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) Total Airport 2.00 465375.43 • TRID: 05.03.07 14:47:38 Page: 5 Iowa City General Ledger System Revenues Detail FY 2007 Detail Reporting For the period 04.01.07 to 04.30.07 Trans Date Trans Type Report# Source Description Debit Credit 7600 Airport (CONTINUED) 560100 Airport Operations (CONTINUED) +*# GRAND TOTAL *** 2,00 465375.43 DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 1 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.30.07 Total Project Prior Fiscal This Year This This Year Remainder W G/L Account Description To Date Years To Date Month Budget In Budget Spent tttttt*tttttttttt******tttttttttttttttttttttttttttttttttt*t**tttttt 3403 Airport North Commercial Park Old System #: 37410 ttttttt#tttttttttttttttttttt if t tttt ttt ttttttttttttt******t t*t t t t t tt 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 4,000.00 3,986.45 .3 560300 393411 AirCapAcq From 02 GO Bonds 16,161.72 16,161.72 TOTAL RECEIPTS 54,754.95 54,741.40 13.55 4,000.00 3,986.45 .3 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 432080 AirCapAcq Other Prof Services 494.78 494.78 -494.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 40,252.17 37,150.99 3,101.18 4,000.00 898.82 77.5 560300 446200 AirCapAcq Photocopying Chgbk 25.00 25.00 560300 473010 AirCapAcq Contracted Improve 13,417.80 13,417.80 TOTAL EXPENDITURES 58,684.15 54,712.79 3,971.36 4,000.00 28.64 99.3 DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 2 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.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 NET FOR PROJECT -3,929.20 28.61 -3,957.81 Cash Balance: -3,957.81 Beginning Balance: ttt+tttftttttf+tftf#t+ft+++ttt#tttttttttttttttttttt*tiftf tfttffftft 3406 NE Property Development Old System #: 00000 ttttttt+fftttttt++t+fitittttt+++ttitttttttttttt+tff+tttttfftftftttt EXPENDITURES 560300 432060 AirCapAcq Consultant Services 1,050.00 1,050.00 -1,050.00 TOTAL EXPENDITURES 1,050.00 1,050.00 -1,050.00 NET FOR PROJECT -1,050.00 -1,050.00 Cash Balance: -1,050.00 Beginning Balance: tt#tttttititfit#tt#t+t+tttttttttt##tffffffffffiiit+ttittttttttt ittt 3415 Building B,C,K Roof Replacement GAVI-IOW Old System #: 37430 ttt+7+tittttt+ttt+t+hitt}tttttttttttifftttfttttt++tttttttttttttt++ 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 DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 3 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.30.07 Total Project Prior Fiscal This Year This This Year Remainder 8 G/L Account Description To Date Years To Date Month Budget In Budget Spent 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 ttttttttttttttttftitttttttttttttittttttttttttttttittttttttttttttttt 3416 Runway 7 Design, BA, Extension, FAA #10 Old System #: 37440 tttttttttttttttttttttttt******ttttttttttt+ttttt tttttt******tttttt** RECEIPTS 560300 331100 AirCapAcq Federal Grants 1,277,240.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 144,338.90 144,338.90 -98,327.00 -98,327.00 TOTAL RECEIPTS 1,440,822.83 1,326,789.83 114,033.00 129,524.00 15,491.00 88.0 • DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 4 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.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 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 291,999.66 271,081.95 20,917.71 -20,917.71 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 Basement • 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 188,566.00 142,770.00 24.3 TOTAL EXPENDITURES 1,232,192.37 1,165,435.06 66,757.31 188,566.00 121,808.69 35.4 NET FOR PROJECT 208,630.46 161,354.77 47,275.69 Cash Balance: 104,318.33 Beginning Balance: 57,042.64 ttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt**tttttt 3419 Aviation Commerce Park Site Development Old System #: 00000 ****t*tt i t t t t t t t t t ttttttttttttttittt t t t t t t t tt tt t t t t t t*t t t t t t t t t t t tt RECEIPTS 560300 362100 AirCapAcq Contrib & Donations 560300 393414 AirCapAcq From 05 GO Bonds 46,374.63 46,374.63 15,000.00 15,000.00 TOTAL RECEIPTS 46,374.63 46,374.63 15,000.00 15,000.00 DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 5 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.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 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 15,000.00 3,782.42 74.8 TOTAL EXPENDITURES 57,592.21 46,374.63 11,217.58 15,000.00 3,782.42 74.8 NET FOR PROJECT -11,217.58 -11,217.58 Cash Balance: -11,217.58 Beginning Balance: ******ttttttttttttttittttttttttttttt t tit t t t t tt tt ttttt t t t t t t t t t t t t tt 3420 Runway 7 Grading FAA #11 & #12 Old System #: 37441 tttttt******ttt ttttt******ttttttttttt t t t t t tt t t t t t t t t t t t*t*t tt tt t t tt RECEIPTS 560300 331100 AirCapAcq Federal Grants 137,876.00 110,379.00 27,497.00 1,534.00 39,621.00 12,124.00 69.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,434.40 124,937.40 27,497.00 1,534.00 32,957.00 5,460.00 83.4 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 145,133.31 133,273.11 11,860.20 24,622.00 12,761.80 48.2 560300 473010 AirCapAcq Contracted Improve • DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 6 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.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 TOTAL EXPENDITURES 145,133.31 133,273.11 11,860.20 24,622.00 12,761.80 48.2 NET FOR PROJECT 7,301.09 -8,335.71 15,636.80 1,534.00 Cash Balance: 7,301.09 Beginning Balance: -8,335.71 tttttttt tt++t+iii******tt++ttttttt+tttt******ttttt++++++++ttttttttt 3421 Runway 7 Paving/Lighting FAA #14 Old System #: 00000 +++tt+++tt+t+t+ttt+tttttttt+t+++t++++++++++ttttttttt+ttt++tt+tttt+t RECEIPTS 560300 331100 AirCapAcq Federal Grants 2,129,425.00 2,129,425.00 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: DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 7 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.30.07 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 +tttttt+ttttttt+t+tttttttttttt+ttttt+tttt+ttttttttttttttt+t+t+ttttt 3422 Airport Taxilane/Apron Pavement Rehab 9I Old System #: 37496 ++ttt******+t+tttttttttttttttt+ttttt+tttttttttttt tt++t#tttttttttttt 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 -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 171,171.00 6,159.89 96.4 TOTAL EXPENDITURES 191,432.95 11,844.55 179,588.40 171,171.00 -8,417.40 104.9 NET FOR PROJECT 6,254.98 -6,254.98 Cash Balance: Beginning Balance: 6,254.98 DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 8 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.30.07 Total Project Prior Fiscal This Year This This Year Remainder % Gib Account Description To Date Years To Date Month Budget In Budget Spent +++ttttttt+t+++t+t+++t++ttttttttttttt+++t++tttt+++++tttttttt++++t++ 3424 Hard Surface Floors Bldgs B & C #9I-05-0 Old System #: 37495 ttttt+ttt+tttttttttttttt++t+t+ttt+tttttttttttttt+tttttttt+ttttt+ttt 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 472010 AirCapAcq Building Improvemen 560300 473010 AirCapAcq Contracted Improve 59,128.75 56,172.31 2,956.44 19,651.00 16,694.56 15.0 TOTAL EXPENDITURES 68,103.03 65,146.59 2,956.44 19,651.00 16,694.56 15.0 NET FOR PROJECT 997.09 -189.77 1,186.86 Cash Balance: 997.09 Beginning Balance: -189.77 DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 9 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.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 tt++t+++#4t tt t+++++t t++t++t t tt tt t t+++tit++t+++++t++t+t t tt t t tt t+t+t+ 3425 FAA Runway 7 Grading/Obstruction Mitigat Old System #: 37443 tt+ttttttt+++tt+tttttt+t+++ttt++tt++ttt+t+tt ttt+t+++t+ttttt+ttt tt++ RECEIPTS 560300 331100 AirCapAcq Federal Grants 666,262.00 666,262.00 3,976.00 1,647,826.00 981,564.00 40.4 560300 393140 AirCapAcq General Fund CIP Fu 8,555.21 8,555.21 560300 393416 AirCapAcq From 07 GO Bonds 86,728.00 86,728.00 TOTAL RECEIPTS 674,817.21 8,555.21 666,262.00 3,976.00 1,734,554.00 1,068,292.00 38.4 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 142,346.18 8,370.68 133,975.50 288,300.00 154,324.50 46.5 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 1,446,254.00 887,781.80 38.6 TOTAL EXPENDITURES 701,328.28 8,555.21 692,773.07 1,734,554.00 1,041,780.93 39.9 NET FOR PROJECT -26,511.07 -26,511,07 3,976.00 Cash Balance: -26,511.07 Beginning Balance: DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 10 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.30.07 Total Project Prinr Fiscal This Year This This Year Remainder % G/L Account Description To Date Years To Date Month Budget In Budget Spent 3431 Rehabilitate Hangar A 9I-07-0I0N-300 Old System #: 37375 ::::xx}xaxtt#t###t#ta::xx:nx:xxxxxttttttttx:x::::xttxxzxxxxt#ttttt RECEIPTS 560300 334900 AirCapAcq Other State Grants 1,419.00 1,419.00 1,419.00 49,300.00 47,881.00 2.9 560300 393240 AirCapAcq From Airport Operat 8,700.00 8,700.00 TOTAL RECEIPTS 1,419.00 1,419.00 1,419.00 58,000.00 56,581.00 2.5 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 2,833.95 2,833.95 1,162.80 -2,833.95 560300 435060 AirCapAcq Legal Publications 19.40 19.40 19.40 -19.40 560300 473010 AirCapAcq Contracted Improve 58,000.00 58,000.00 TOTAL EXPENDITURES 2,853.35 2,853.35 1,182.20 58,000.00 55,146.65 4.9 NET FOR PROJECT -1,434,35 -1,434.35 236.80 Cash Balance: -1,434.35 Beginning Balance: tttttttt*#ttttttttttttttttttittttttttttt#tt#t#tttt#tt t t t t t t tttttttt 3432 Rehabilitate South T Hangar Taxi Lanes 9 Old System #: 37497 t#t##tttttttttttttttttttttttttttt*****ttttttttttttttttttttttttt tttt RECEIPTS 560300 334900 AirCapAcq Other State Grants 3,962.00 3,962.00 3,962.00 111,510.00 107,548.00 3.6 DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40 Page: 11 Iowa City General Ledger System CAPITAL PROJECTS RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007 THROUGH 04.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 560300 393240 AirCapAcq From Airport Operat 47,790.00 47,790.00 TOTAL RECEIPTS 3,962.00 3,962.00 3,962.00 159,300.00 155,338.00 2.5 EXPENDITURES 560300 431111 AirCapAcq Engineering Service 11,767.15 11,767.15 6,105.64 -11,767.15 560300 435060 AirCapAcq Legal Publications 20.47 20.47 20.47 -20.47 560300 473010 AirCapAcq Contracted Improve 159,300.00 159,300.00 TOTAL EXPENDITURES 11,787.62 11,787.62 6,126.11 159,300.00 147,512.38 7.4 NET FOR PROJECT -7,825.62 -7,825.62 -2,164.11 Cash Balance: -1,825.62 Beginning Balance: ittlttttttttt lititttit it i t ttttttttt t l 11111+4#tt l t t ti t tl t l t t l ttttttt 3433 West Terminal Apron Rehabilitation Old System #: 00000 titilt11ti1t1tti1114tt*1ifiii tttt it t1 t i111*1*t 111 t ttttt tt ti tttt 11 ti EXPENDITURES 560300 431111 AirCapAcq Engineering Service 2,915.27 2,915.27 2,915.27 -2,915.27 TOTAL EXPENDITURES 2,915.27 2,915.27 2,915.27 -2,915.27 NET FOR PROJECT -2,915.27 -2,915.27 -2,915.27 Cash Balance: Beginning Balance: