HomeMy WebLinkAbout05-10-2007 Airport CommissionIOWA CITY AIRPORT COMMISSION
3.
a
5.
MEETING AGENDA
AIRPORT TERMINAL BUILDING
1801 S. RIVERSIDE DRIVE
IOWA CITY, IOWA
THURSDAY, MAY 10, 2007 - 5:45P.M.
Determine Quorum
Approval of Minutes from the following meetings:
April 12, 2007
Public Discussion - Items not on the agenda
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
1) Public Comment
11) Consider a Resolution adopting the Disadvantaged Business Enterprise
Program
F) FAA/IDOT Projects - Earth Tech — David Hughes
1) Runway 7/25
11) South Aviation Development Study
111) South Taxilane Rehab
a. Consider a resolution awarding contract for the Rehabilitation of South
Taxilanes
IV) HangarA 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
VII I) 405 Approach Surveys
G) Airport Viewing Area
H) Airport Commission Meeting Schedule
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.
Adjourn
MINUTES
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 e. 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) JJR 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
N
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 Thornber y — 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 Thomberry
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
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.
1) 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) FAAADOT 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.
1) 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
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.
13
Airport Commission
ATTENDANCE RECORD
YEAR 2007
(Meetine Date)
NAME
TERM
EXP.
1/11
2/8
3/8
3/28
4/12
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/l/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
-- = Not a Member
May 1, 2007
Mr. David Larsen
Representative of the Dane Family
277 Hickory Street
Kalona, 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, MAI
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
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
5/2/2007
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,
4David
to or J Davis Foddition.
J,
nce. Larsen
IFAA
S
MMrS CONSULTANTS-, INC,
IOWA CITY IOWA
OFFICE: 319-351-8282
April 16, 2007
CEDAR RAPIDS IOWA
OFFICE: 319-341-5188
5479-006
Airport Commission
City of Iowa City
n 410 East Washington Street
Iowa City, Iowa 52240
Dear Chairperson,
m
I am a licensed civil engineer and I prepared the construction plans for JJR Davis 4 h 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
o 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.
0
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.
r
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,
Scott Pottorff, P.E.
MMS Consultants, hie.
1917 SOUTH GILBERT STREET • IOWA CITY • IOWA 52240
WEBSITE: WWW.MMSCONSULTANTS.NET EMAIL: MMS@MMSCONSULTANTS.NET
. .`
JJR DAVIS FOURTH ADDITION
DRAINAGE CALCULATIONS
Iowa City, Iowa
September 15, 2005
Revised November 8, 2006
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.2042 hr
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.
i
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 efs
(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):
%jmk = 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 efs
T:\5400\5479006\5479006dcl.doc
PROJECT DATE
LOCATION
LAND USE (SOIL COVER) N % USE PRODUCT BASIN AREA 2-7. rq AC
iorv�2�f .q I CN��2 L CHANN EL LENGTH
FT
SOIL TYPE B
CLIMATE FACTOR 1.19
CHANNEL SLOPE 3.50
LAG TIME 7
o42 HRS. (Tp'
SUMMATION = 100%
O= A: X Y Y X Z T95.l0 it a
(FREQUENCY
• •
FRE(
5
10
25
50
100
?ELEASE RATI
Y./ ?'
STORAGE
I zS sl
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
TIME (HOURS)
FIGURE A®3
LENGTH OF CHANNEL
vs.
LAG TIME °Tp'
Tc- f-�7•-rp .
5
05
. _ :�ii
I jo
MA
ais-
/!gym
1,000 107000
CHANNEL LENGTH (FEET)
•!L mem
FIGURE Ae4
l LAG TIME 'ip' V.S. If
1.0 -
0.9
0A
0.75 -
0.7
0.6
0.50 -
0.4
0.3
0.25 -
0.2
Z
I 0.10 -
0.09
0.08
0:075 -
0.07
0.06
0.050 -
0.04
0.03
0.025 -
0.02
0.15
0.010
0 00oo—
O ti 0
0
0
MEMO
iiiiiinominFAIIIIISENINEEN
11111100010111111100011
11111111511111111111111101
N Lo U — — N N ti d' 6 t� O
O O ~
O
T/TP
co V O\ Ln A W N'N.F- r r a 0 0 0 a a P. ct C7
*LA
. �. Y• G
CD00000(noNNOV (nAWNrr O H
00000000.ovlocn00000�ZJ'p w
H.
W W W W W W W W wNN NNNrr O^P'w w 0
1
t 0 W V O\ c n A N N O O o V G' l N O O
;• Vl O\tO O\Mr W Or tD V D`A W CD d
w
\ OOOOOrrrNtvN W AtnO+�1tO� r rt
W O P.
A [nUV tOr W UO W V AAOar rO O
l0 Ln W WOAr Orr V rCO W 000 ,J
z
G O
00000orrrrNNwwAA(nr, Fh
A LO O
• A A Cn 0\ V .tD r W O\ Oo N V A co W V (n� (n Fh r`d
N VAN O\:UIO W (n tDA Nlp W W Ln CD Fhr-
'11 O
O O O o 0 0 0 r r r r N N N W W N� w Fh
. . . . . . . . . . . . . Ln 0 n Fh
W A A( n 01 V t D O w (n V r D\ V O O t 0 O rt
U a O\N4 t tD W OV r O(nw 00 O 'rl
H w
n
00000000rrrr'rNNNrr--. 00 rt
. . . . . . . . . . . . . O` u, 0
W W W A L n O\ V Co O r w O. c O a r O ON1- h H
O W m W N A w m Ln m m w A W V 0 0 O
_ H X
000000000orrrrrrCDI mZ.Fh
0 0
NN W W ALn �/'l V 00(0 O N O\ Ol 11lN O\ (D H
Ill V rLn W NIO O LA V V O\O Otn O p
G r
w o
cDc=) 0000000rFl(=1 ro
. . . . . . . . . . . . w i
N NNN W A A vl O\V W 0000t0 ONO U'lrt •'C
O N cn CO A r U U'l (.n O O tD O O W 0 0 O (D
w
H
0 0 a 0 0 0 6 0 0 0 0 0 0 0 0 0 0, V
to O 'lj
r r N N N W W A A (/'l (n O\ V D\ [n W O H
U VaN 0\r4 r NW Ln0 W V 00 (D
G
00000000000000000r rn m
. .
rrrrNNNwwwaa��woo� CD n
w p (n V O p 0 r Ln 00 N V Q` O W O O
a 00a 0000000 000 ao'or rn
. . . . . . . . . . . . . . . . . r o
orrrrF-r ,"t NNNNNF (DCD,
ID Or N to V 00r w(n V �0\W V 00
TIME
Q
AVERAGE Q
Q x T
HOURS
CFS
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
TSr— 9A-v"7S FASfN
vI9�5 �7% i GN�Iou� Tv� /fir: 77 gq Fc
6 A C-
Z
r c 6t V1 �I
I,o�(/ c, 7 �XI�TfNC� Fi4GL rli Dy(Vr� i-f3vv.
A2 t3Y, s j N 1.6 9 A L
F�DDI�I�rl�;L I�,?q Ac
WI"fFl S�tMG� C��✓��tY��--'"�A'I�DY�rotV�C� %f�N� �`�ci��E'F �''
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 cuft
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
Q (cfs)
60.00
50.00
30.00
20.00
10.00
0.00
0 3 5
— Hyd No. 3
0
OFFSITE
Hyd. No. 3 -- 100 Yr
Hydrograph Volume = 234,892 cult
Q (cfs)
60.00
50.00
40.00
30.00
f IXIIU]
10.00
-4-1 i i ' ' ' " 0.00
10 13 15 18 20 23 25
Time (hrs)
Hydrograph Plot
Hydraflow Hydrographs by Intelisolve 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 cuft
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 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. 4 — Hyd No. 2 — Hyd No. 3
AREA
AVERAGE
DELTA
VOLUME
VOLUME
ELEVATION
(FT-2)
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 (cuft) Total storage (cuft)
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]
[BI
[C]
[D]
[A]
[Bl
[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 (It) = 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
Clrif. 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: Cu1.,lJ0r1fw autllowa have been analyzed
under Inlet and outlet cent el.
Stage I Storage I 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.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
--
--
- - - --
-
-
--
12.28
8.50 388,118 662.00
-
-
- - - -
-
-
-
21.26
10.50 629,740 664.00
---
-
- - - -
-
THIS SPREADSHEET DETERMINES THE CAPACITY OF
AN OUTLET PIPE FOR A STORM WATER BASIN
PROJ NO: 5479-006
DATE: 12/05/05
INLET CONTROL
Q=CA(2GH)A0.5
OUTLET CONTROL
Q=A(2GH/K)A0.5
PIPE DIA. (IN)
MANNINGS n
PIPE LENGTH (FT)
INVERT IN
INVERT OUT
TAILWATER ELEV
WS ELEV
654.00
656.00
658.00
660.00
662.00
664.00
WHERE: H= HEAD MEASURED FROM CENTROID OF PIPE AT INLET
C= 0.6
G= 32.2
WHERE: K=1.5+29*(NA2)*L/(RA(4/3))
R=D/4
H= HEAD MEASURED FROM CROWN OF PIPE AT OUTLET
OR FROM TAILWATER ELEVATION
24 AREA= 3.14159 FTA2
0.013 K= 4.216944
220 SLOPE= 0.01 FT/FT
653.50
651.30
661.00
:T CONTROL
H
Q
-0.5
#NUMI
1.5
18.53
3.5
28.30
5.6
35.48
7.5
41.43
9.5
46.62
-654.5
#NUMI
-654.5
#NUMI
-654.5
#NUMI
-654.5
#NUM!
-654.5
#NUMI
-654.5
#NUMI
-654.5
#NUMI
-654.5
#NUMI
-654.5
#NUM!
-654.5
#NUM!
-654.5
#NUM!
-654.5
#NUMI
-654.5
#NUM!
-654.5
#NUM!
-654.5
#NUMI
-654.5
#NUMI
-654.5
#NUM!
-654.5
#NUM!
-654.5
#NUMI
-654.5
#NUMI
-654.5
#NUM!
-654.5
#NUM!
-654.5
#NUMI
-654.5
#NUM!
-654.5
#NUM!
-654.5
#NUM!
-654.5
#NUM!
LET CONTROL
H
Q
-7
#NUMI
-5
#NUM!
-3
#NUMI
-1
#NUMI
1
12.28
3
21.26
-661
#NUM!
-661
#NUM!
-661
#NUM!
-661
#NUMI
-661
#NUM!
-661
#NUMI
-661
#NUMI
-661
#NUMI
-661
#NUMI
-661
#NUMI
-661
#NUM!
-661
#NUM!
-661
#NUM!
-661
#NUMI
-661
#NUMI
-661
#NUMI
-661
#NUM!
-661
#NUM!
-661
#NUM!
-661
#NUM!
-661
#NUM!
-661
#NUMI
-661
#NUM!
-661
#NUMI
-661
#NUM!
-661
#NUM!
-661
#NUM!
CONTROLLING
DISCHARGE
#NUM!
#NUMI
#NUMI
#NUMI
12.28
21.26
#NUM!
#NUMI
#NUMI
#NUMI
#NUMI
#NUMI
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUMI
#NUMI
#NUMI
#NUMI
#NUMI
#NUM!
#NUMI
#NUMI
#NUMI
#NUM!
#NUMI
#NUM!
#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 cuft
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 ® Req. Stor = 643,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.
tJ
a
CD
PROJECT: I-'1 "IS yo-t
IMptnpIV
STATION :
CULVERT DESIGN FORM
DESIGNER/DATE: /
SHEET OF
REVIEWER / DATE : /
HYDROLOGICAL DATA
ROADWAY ELEVATION 6 0
ELhd: 1/l) lltl
❑
METHOD:
'" ❑ DRAINAGE AREA: ❑ STREAM SLOPE:
'e ❑ CHANNEL SHAPE:
HWI -EL,f: (1/) Sa: H
w
❑ ROUTING: ❑ OTHER:
(�
_
'��Rl�iNk STREAM BEO TW
DESIGN FLOWS/TAILWATER
EC �G•�4 Ilt)
FALL
R.1.(YEARS) FLOWICIAI TW(111
01 t�
�•
SyS-FALL/
aI/, �
0
0 L.gO� EL.: (it)
too
—
S-
6sb.ro®
Ld•Of R� �jq4
CULVERT DESCRIPTION:
TOTAL
FLOW
HEADWATER
CALCULATIONS
M z
MATERIAL- SHAPE -SIZE- ENTRANCE
FLOW
PER
ARRLi
o < H
r o iwi
}
a
COMMENTS
INLET CONTROL
OUTLET
CONTROL
0/N
H2/D
HWI
FALL
ELhi
Ty
do
d�ZU
hD
AF
H
ELho
0
lelq11)
17
a
sw
o'i
N G cmi,.✓rm r 0
1,%
S,5L
0
iw,%
0
325
363
3b3
OS-
2-,m
Itux
645
L{ g" C LILV fi�
Liz, S
(.
5d36
U
gq.-q
Q
i.2li
3 �3
5..&3
0• �,
7-21
66z.! f
�bY 99
TECHNICAL FOOTNOTES:
(4) ELhi- HWI+ELIIINVERT OF
(6) ha • TW or (do+D/2H WHICHEVER IS GREATER)
(1)USE O/NB FOR BOX CULVERTS
INLET CONTROL SECTION)
(7) H• C+ 11.+(29 n2 L)/ RL33V 2/2D
121 HWI /D• HW /D OR HWI/D FROM DESIGN CHARTS
(5) TW BASED ON DOWNSTREAM
(B) ELho EL, +H4 h,
(3) FALL' HW IEL EL 1 FALL IS ZERO
I - hd- AI i
CONTROL OR FLOW DEPTH IN
CHANNEL.
O O VFATR ON GRADE
SUBSCRIPT DEFINITIONS :
COMMENTS / DISCUSSION :
CULVERT BARREL SELECTED ;
O. APPROXIMATE
l: CULVERT FACE
SIZE:
hd. DESIGN HEADWATER
hi. HEADWATER IN INLET CONTROL
ho. HEADWATER N OUTLET CONTROL
SHAPE:
I. INLET CONTROL SECTION
o. OUTLET
MATERIAL: R
•/. SIUEAMBED AT CULVERT FACE'
A
ENTgAN CE:
CHART 10
IBO
10,000
16B
8,000 EXAMPLE
6.
156
6,000 Da42 Inches (3.5 fast)
6
5.
5,000 On 120 do
144
4,000 y, Vt'! NM
6.
5.
132
D tact
3,000 III 2.5 SA5'
4.
120
(2) 2.1 T.4
2.000 (3) 2.2 7.7
4•
3•
I OB
nD In test
3'
96
1,000
3.
BOO
84
600
2
500 /
P.
72
400 /
=
300 E+/ =
I.S
1.5
z
it
60 p
200 //
S
54
/ 9
Ww
100
>
/ ¢
80 =
1.0
/ / =
60 0.
1.0
ob
42 0
H
I&I
SO HVH ENTRANCE
I'0
D SCALE TYPE
DIE40
r
36
f
.9
.9
30 (1) Sahara edge wish
3
.9
33
heedwell
G
20 (2) Grace and with Q
30 -
hsedwall S
13) 9r"ve end
.R
2T
9rsleeflag
10
T
T
.T
24
B
6 To use scale (2) or (3) project
21
5 horizontally to goals (1),thsn
4 use straight Inclined line through
D and D scales, or reverse as
.6
3 Illustrated.
g
'6
I8
2
15
0
5
.5
.5
1.0
L 12 HEADWATER DEPTH FOR
HEADWATER SCALES 2B3 CONCRETE PIPE CULVERTS
REVISED MAY1964 WITH INLET CONTROL
BUREAU OF PUBLIC ROADS JAN. 1963
181
OCHART 4
F
■■■■■■■■■■M��_�-�■
■■■■■■EN�a-■■■■■■■
■�! "■■■■■ . ■
I.r ■■■■■■■■■ ■
e
7
p-
W
6uJ
O
x
S F
a
ul
0
J
Q
�..,,0 V
DISCHARGE-0-CFS
V U
I
I
10
6
6
■■■■■■■■■■■■■■■■■■��
■■■■■■■■■■■■■■■"��■■
■■■■■■■■■■■■�i�■■■■■
■■■■■■■■■ONi�■■■■■■■
■■■%m■■■■■■ . - - ■
■■E M■■■■■■■ ■
■r■■■■■■■■■MEN ■■■■■
DISCHARGE-0-CFS
BUREAU OF PUBLIC ROADS
JAN. 1964
184
CRITICAL DEPTH
CIRCULAR PIPE
F 2000
1000
600
600 -
500
400
300
200
A
0
2
® 100
W T
a
x
V 60
W
® 50
30
20
10
8
6
5
4
O
CHART 5
NW —� o o
.4
m
z
u � slow sow
i SUBMERGED OUTLET CULVERT FLOWING FULL
5
r
120
For wrier cr� not wbmergee, r pure NW by
.6
method, Ceeeribe6 h rM UnieA Wo=dm
106
.6
96
1.0
64
72
66
'
cN W
60
yy«E/b°
4-, UJI
2
/0/ �O0
54
O
/ i
m
O
e4 0.6 00
3
/
N
Fa a
`�
az
®° w
a
c
36
S00 n°°
5
W
33
h00 500
6
H
w •
�
30
g®° F
6
0
27
•e
e 6
O 'N
10
24
P
21
I6
20
15
12
BUREAU OF PUBLIC ROADS JAI. 1963
185
HEAD FOR
CONCRETE PIPE CULVERTS
FLOWING FULL
n = 0.012
FLOW THROUGH TRAPEZOIDAL DRAINAGE SWALE
Q = (1.49 'A *
RA(2/3)
- SA(1/2))
/ N
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.6673
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.8671
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.6600
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,6159
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.6600
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.6664
2.1398
133.9044
1066.47
13.23
3.7
84.3600
38.5110
2.1905
142.2890
1133.24
13.43
MCCOMAS LACINA
McComas-Locina Construction LC
General Contractors
Date 4-23 2007
Tom Schnell
Iowa City, la 52240
RE: Building H Remodel @ Iowa City Airport
NO.2347 P. 1/1
Preliminary site investigation on the building expansion phase I & 2. The site is assumed to be uncontaminated and sub -grade clean
Of any utilities, old structures, unsuitable soils or hidden/latent problems. ArchitecturaMgineering Pees 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 of the
budgets below:
Budget on Phase 1:
60 by 30 Feet Hanger expansion ® S70.00 sqft (No Doors) (1800 sqft) $ 126,000.00
70 by 20 Feet Office Exp. Shell Only Q $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 sqft) S 42,000.00
60 by 20 2°d PIr. Interior Remodel@ $40.00 sqft (1200 sqft) S 48,000.00
4 by 30 feet Int, Steps & Grating Q $30.009gft (184 sqft) S 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 fare separation included.
Thank you for allowing us to bid this project.
sincerely,
Mark A robnson
Estimator & Project Manager
1310 highland Court Iowa City, Iowa 52240 Telephone: (319) 338-1 12.5 FAX: (319) 3M-5964
i
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 12007.
CHAIRPERSON
ATTEST:
SECRETARY
It was moved by and seconded by
adopted, and upon roll call there were:
Ayes
Nays
Approved by
City Attorney's Office
Absent
the Resolution be
Farris
Hartwig
Horan
Rettig
Staley
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:
Base figure
Ready, willing, and able DBEs
All firms ready, willing and able
The base figure was determined by the following:
Base Figure = Heavy/Highway X ready, willing. able DBE Heaw/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 5159 + $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).
When we divided the numerator by the denominator we arrived at the base figure for our overall
goal and that number was 8.26%.
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 i of
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 28w. 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
r agu � vi �
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 McEleney 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 FAA 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 15t
Taxilanes — South Area (2007 State Grant)
A pre -bid conference was held scheduled for May 1st and receipt of bids for May 8w. We anticipate having a
recommendation of contract award for the Airport Commission Meeting on May 10m.
T-Hangar A Rehabilitation (2007 State Grant)
Receipt of bids or this project is scheduled for May 8a'. We anticipate having a recommendation of contract
award for the Airport Commission Meeting on May 101.
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 10t'.
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
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,
responsible bid of
has submitted the lowest
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 12007.
CHAIRPERSON
ATTEST:
SECRETARY
It was moved by and seconded by
adopted, and upon roll call there were:
Ayes
Nays
Approved by
City Attorney's Office
Absent
the Resolution be
Farris
Hartwig
Horan
Rettig
Staley
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
ATTEST:
SECRETARY
It was moved by and seconded by
adopted, and upon roll call there were:
Ayes Nays
Approved by
Sp � C^- 3
City Attorney's Office
Absent
the Resolution be
Farris
Hartwig
Horan
Rettig
Staley
Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Or, Iowa City IA 52246 319-350-5045
RESOLUTION
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
CHAIRPERSON
ATTEST:
SECRETARY
It was moved by and seconded by
adopted, and upon roll call there were:
Ayes
Nays
Approved by
City Attorney's Office
Absent
2007.
the Resolution be
Farris
Hartwig
Horan
Rettig
Staley
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 25N 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 Corn
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
Informadon
Panel
Proposed Viewing Area Layout
Bench
Bench
Rlay::::
>Ground
t ......e....
Information
Panel
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
Select a radio frequency to tune in
Common Traffic Advisory Frequency (CTAF)
40
Used by aircraft at the Iowa City Airport
Iowa City Automated Weather Observation System
Used by Pilots to get the most recent weather conditions
Cedar Rapids Approach
Used by pilots in the vicinity of Cedar Rapids
Chicago Center
Used by pilots in the vicinity.
KIOW - Location Identifier - Iowa
City Municipal Airport
301452Z - Date and Time of obser-
vations - 30th day at 1452 Zulu
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
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
T02330122 Temperature and Dew
Point in decimal form - Read as
023.3 and 012.2
58002 - Barometric Pressure Trend
What are they sayer???
N-Number - Aircraft Tail Number -
Used to identify aircraft speaking
J
Shelter Footprint
Beanch
Covered Shelter 20' Tall picnic tables
0
Displays
1"=16'
Check Requests During Month
Approved
Monthly Expense Report - April '07
Check Requests
4/5/2007 Earth Tech (South Taxilane / Hangar A Rehab)
4/12/2007 Iowa Workforce Development (Elevator Operating Fee)
4/162007 Walker Welding (Mower Hitch Repair)
4/162007 Doors Inc (Door Lockset)
4/1912007 Earth Tech (West Terminal Apron Rehab)
4/26/2007 Hawkeye Fire & Safety (Fire Extinguisher Check/Refills)
Capital Projects
Pending Expenses
Airport Operating Expenses
City. CIP Fund Expenses
Total Expenses
Construction Contracts
Runway 7 Grading
South Economic Study - ALP Update
South T-Hangar Taxilane
Hangar A - Concrete Floors
Hangar A&B - Access Doors
West Terminal Apron
Total Pending Expenses
Airport Budget City Budget
$7,768.44
$125.00
$28.00
$129.96
$2,915.27
$105.00
$387.96
$10,683.71
$11,071.67
Project Bid Amount Paid During Month Paid During Year Paid To Date %Paid
$950,154.00 $558,462.20 $558,462.20 58.8
$15,000.00 $8,696.00 $8,696.00 58.0
$0.00 $0.00
E%PE: 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
412000 Perm Part Time
413000 Temporary Employees
414100 Overtime Wages
414500 Longevity Pay
421100 Health Insurance
421200 Dental Insurance
421300 Life Insurance
421400 Disability Insurance
421500 Unemployment Compensation
422100 Fica
423100 Ipers
424500 Monthly Cellular/PCS
Total PERSONNEL
SERVICES
431080 Recording Fees
432020 Annual Audit
432060 Consultant Services
432070 Management Services
433020 Local Phone Service
433030 Long Distance Service
435060 Legal Publications
436030 Transportation
436050 Registration
436060 Lodging
436070 Misc Travel
436080 Meals
437010 Comp Liability Ins
437020 Fire & Casualty Ins
437030 Worker's Comp Ins
437042 Fidelity Bond
36197.00
20935.00
1050.00
11218.00
461.00
192.00
423.00
8544.00
30666.12
19311.40
5332.39
1748.70
1050.00
5509.20
373.40
180.91
212.07
2784.00
2051.64
49.88
550.92
37.34
4983.00
4352.05
364.43
3745.00
3112.39
282.36
250.00
25.00
------------------------
97738.00
------------
72098.63
------------
6145.57
7.00
138.00
553.92
12000.00
2259.00
8000.00
11250.00
170.14
24.00
21.68
11.47
650.00
855.40
380.16
775.00
200.00
875.00
1221.81
40.00
250.00
112.00
36.00
11936.00
7797.75
15515.00
10831.93
293.00
66.00
1050.00
5530.88 84.72
1623.60 92.24
-5332.39
-1748.70
100.00
5708.80 49.11
87.60 81.00
1.09 99.40
210.93 50.13
8544.00
630.95 87.34
632.61 83.11
-250.00
15639.37 82.17
7.00
-415.92 401.39
9741.00 18.83
-3250.00 140.63
-170.14
2.32 90.33
-11.47
-205.40 131.60
575.00 25.81
-346.81 139.64
-40.00
138.00 14.80
4138.25 65.33
4683.07 69.82
227.00 22.53
-1050.00
E%PE: 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
Account
------------------------
7600 Airport (CONTINUED)
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
Appropriated expenditures Expenditures encumbrance Balance 8 Used
560100 Airport Operations (CONTINUED)
SERVICES (CONTINUED)
446220 Phone Service -Department Chargeb
446300 Phone Equipment/Line Charge
446320 Mail Chargebacks
446350 City Vehicle Repl.
449060 Dues & Memberships
449140 Tools & Equip. Rent.
449360 Interest Expense
Total SERVICES
SUPPLIES
452010 Office Supplies
452030 Minor Off Equip/Furs
454020 Subscriptions
461040 Ag Chemicals
462020 Minor Sanitation Equipment
462030 Sanitation & Industrial Supplies
465020 Gasoline
465050 Other Fuels
465060 Grease & Oil
465070 Other Lubricants
466020 Lumber/Hardware
466040 Plumbing Supplies
466050 Electrical Supplies
466060 Bldg & Improvement Materials
467020 Minor Equipment Repair Material
468020 Concrete
468030 Asphalt
468050 Sand
469040 Traffic Control Improvement
469190 Tools & Minor Equipment
469210 First Aid/Safety Supplies
469260 Fire Ext. & Refills
484.00
433.08
50.92
89.48
963.00
585.00
378.00
60.75
178.00
542.43
-364.43
304.74
15098.00
9285.18
5812.82
61.50
385.00
525.00
-140.00
136.36
500.00
500.00
48157.00
40131.10 4013.11
8025.90
83.33
175260.00
143616.00 7580.14
31644.00
81.94
112.00
694.01
-582.01
619.65
500.00
455.78
44.22
91.16
193.00
108.00
85.00
55.96
127.00
234.95
-107.95
185.00
1000.00
857.94
142.06
85.79
292.00
859.71
-567.71
294.42
38.00
38.00
2582.00
2739.24
-157.24
106.09
94.93
-94.93
34.00
34.00
167.00
167.00
35.00
3.01
31.99
8.60
293.42
-293.42
1113.00
760.00 353.00
68.28
21.00
21.00
144.00
-144.00
1830.00
246.01
1583.99
13.44
47.00
50.92
-3.92
108.34
228.00
99.98
128.02
43.85
883.00
808.14
74.86
91.52
54.39
-54.39
105.00 105.00
-105.00
EXPE: 05.03.07 14:46:48
Account
------------------------••-- _-------------
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
SUPPLIES (CONTINUED)
469320 Misc Supplies
Page: 4
Iowa City General Ledger System
Budget to Actuals Expenditures Summary
FY 2007 Expense Reporting
For the period 04.01.07 to 01.30.07
YTD Period
Appropriated Expenditures Expenditures Encumbrance Balance 8 Used
--------- ------------------------ ------------------------ ------------ ------
Total SUPPLIES
CAPITAL OUTLAY
473010 Contracted Improvements
473020 Non -Contracted Improvements
474420 Other Operating Equipment
Total CAPITAL OUTLAY
OTHER FINANCIAL USES
490150 Operating Subsidy
490190 Interfund Transfers Out
Total OTHER FINANCIAL USES
Total Airport Operations
Total Airport
"t GRAND TOTAL "t
477.00
477.00
------------------------
9679.00
------------
7849.43
------------
105.00
------------
760.00
1069.57
------
88.95
20000.00
21689.10
-1689.10
108.45
12463.00
12958.00
-495.00
103.97
------------------------
32463.00
------------
34647.10
------------
------------
-2184.10
------
106.73
6259.00
6259.00
Fu 43543.00
36284.70
3628.47
7258.30
83.33
------------ ------------
49802.00
------------
36284.70
------------
3628.47
------------
13517.30
--- ...
72.86
------------------------
354942.00
------------
294495.86
------------
17459.18
--------
760.00
59686.14
83.18
------------ ------------
354942.00
------------
294495.86
------------
17459.18
------------
760.00
59686.14
------
83.18
------------------------
354942.00
------------------------
------------------------
------------
294495.86
------------
------------
------------
17459.18
------------
------------
------------
760.00
------------
------------
59686.14
------
83.18
------
------
REVE: 05.03.07 14:46:56
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
-------------------------------------------------------------------- ----------------------------------
7600 Airport
560100 Airport Operations
INTERGOVERNMENTAL REVENUE
334900 Other State Grants
Total INTERGOVERNMENTAL REVENUE
MISCELLANEOUS REV.
�369100 Reimb of Expenses
Total MISCELLANEOUS REV.
USE OF MONEY & PROP.
381100 Interest on Investments
382100 Land Rental
382200 Building/Room Rental
384200 Vending Machine Comm
384900 Other Commissions
Total USE OF MONEY & PROP.
OTHER FINANCING SOURCES
392100 Sale of Land
393120 General Levy
Total OTHER FINANCING SOURCES
Total Airport Operations
Total Airport
"t GRAND TOTAL a+e
Page: 1
Remainder %
------------ ------
3418.00
-3418.00
------------ ------------
------------
3418.00
------------
-3418.00
------
220.00
30.00
190.00
13.64
-----------------
220.00
------------
30.00
------------
190.00
------
13.64
152.00
122.00
30.00
80.26
37085.00
33144.44
6598.92
3940.56
89.37
174629.00
158734.51
18625.51
15894.49
90.90
153.90
-153.90
15000.00
14579.40
500.00
420.60
97.20
------------------------
226866.00
------------
206734.25
------------
25724.43
20131.75
------
91.13
439649.00
439649.00
439649.00
100.00
199267.00
63583.31
135683.69
31.91
------------------------
638916.00
------------
503232.31
------------
439649.00
135683.69
------
78.76
------------ ------------
866002.00
------------
713414.56
------------
465373.43
152587.44
------
82.38
------------------------
866002.00
------------
713414.56
------------
465373.43
152587.44
------
82.38
------------------------
866002.00
------------------------
------------------------
------------
713414.56
------------
------------
------------
465373.43
------------
------------
152587.44
------
82.38
------
------
TRID: 05.03.07 14:47:29
Iowa City General Ledger System
Expenditures Detail
FY 2007 Detail Reporting
For the period 04.01.07 to 04.30.07
Page: 1
Trans Date Trans Type Report# Source Description Debit Credit
---------- ---------------------- ------------------------------------------------------ ------------
7600 Airport
560100 Airport Operations
411000 Perm Full Time
04.13.07 Old Sys 070411010008
04.27.07 Old Sys 070425010007
Total Perm Full Time
412000 Perm Part Time
04,13.07 Old Sys 070411010008
04.27.07 Old Sys 070425010007
Total Perm Part Time
413000 Temporary Employees
04.13.07 Old Sys
04.27.07 Old Sys
Total Temporary Employees
421100 Health Insurance
04.12.07 Journal
Total Health Insurance
421200 Dental Insurance
04.12.07 Journal
Total Dental Insurance
422100 Fica
04.13.07 Old Sys
04.27.07 Old Sys
Total Fica
423100 Ipers
04.13.07 Old Sys
04.27.07 Old Sys
Total Ipers
473805\PAYROLL RECAP\PAYROLL 13-APR
474142\PAYROLL RECAP\PAYROLL 27-APR
473805\PAYROLL RECAP\PAYROLL 13-APR
474142\PAYROLL RECAP\PAYROLL 27-APR
1392.00
1392.00
------------ ------------
2784 .00
1067.52
984.12
------------ ------
2051.64
070411010008 473805\PAYROLL RECAP\PAYROLL 13-APR 26.25
070425010007 474142\PAYROLL RECAP\PAYROLL 27-APR 23.63
------------ ----
49.88
070416084334 005737 APR BCBS\Apr health insurance old # 550.92
------------
550.92
070416084334 005739 APR DELTA DENTAL\Apr dental insuran 37.34
------------ ------------
37.34
070411010008 4130599\FICA\CITY CONTRIBUTION 185.51
070425010007 4270599\FICA\CITY CONTRIBUTION 178.92
------------------------
364.43
070411010008 4133599\IPERS\CITY CONTRIBUTION 143.65
070425010007 4273599\IPERS\CITY CONTRIBUTION 138.71
------------
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\HORAN, HOWARD\TRAVEL R
120.00
Total Transportation
------------
------------
390.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\MI➢AMERICAN 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 BNBRGY\ELE
60.08
04.16.07 New Vouch
070417030005
06861547
Check:598700\IfIDAMERICAN ENERGY\ELE
256.75
Total Electricity
------------
------------
1129.64
438070 Heating Fuel/Gas
04,16.07 New Vouch
070417030005
06861473
Check:598700\MIDAMERICAN BNERGY\GAS
10.00
04.16.07 New Vouch
070417030005
06861487
Check: 598702\MIDA14HRICAN 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
Iowa City General Ledger System
Expenditures Detail
FY 2007 Detail Reporting
For the period 04.01.07 to 04.30.07
Page: 3
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\0'KEEFE ELEVATOR CO IN
Total Bldg Rep & Maint
442020 Repair of Structure
04.24.07 New Vouch 070425030005 06861830 Check:599493\DOORS INC\LOCKSET
Total Repair of Structure
442070 Bldg Pest Control
04,09.07 New Vouch 070410030004 06861167 Check:598387\HAWKEYE PEST CONTROL I
Total Bldg Pest Control
443080 Other Repair & Maint
04.17.07 New Vouch 070418030010 06861630 Check:598815\IOWA WORKFORCE DEVELOP
Total Other Repair & Maint
445070 Equipment Service
04.25.07 New Vouch 070426030225 06862041 Check:599597\ALLIED WASTE SERVICES\
Total Equipment Service
445230 Technical Services
04.02.07 New Vouch 070403030007 06860873 Check:598090\MIDWEST JANITORIAL SER
Total Technical Services
446140 ITS -Computer Replacement Chargeback
04.01.07 Journal 070416084334 005729 I.S.-REPLACE CHG\ITS Apr replace ch
Total ITS -Computer Replacement Chargeback
446160 ITS-Network/Internet Charge
04.01.07 Journal 070416084334 005730 ITS-NN/INTERNET CHG\Apr internet ch
Total ITS-Network/Internet Charge
33.95
------------ ------------
33.95
125.00
------------------------
125.00
74.00
------------ ------------
74.00
655.10
------------ ------------
655.10
39.58
--------------- --------
39.58
30.00
------------ ------------
30.00
TRID: 05.03.07 14:47:29
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
----------- ---------- ------------ -------------------------------
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
449360 Interest expense
04.30.07 Journal
04.30.07 Journal
04.30.07 Journal
04.30.07 Journal
Total Interest expense
469260 Fire Ext. & Refills
04.30.07 New Vouch
Total Fire Ext. & Refills
490190 Interfund Transfers Out
04,30.07 Journal
04.30.07 Journal
04.30.07 Journal
04.30.07 Journal
070416084334 005735 Corp Hangar Loan Int\Apr Interfund
070416084334 005735 Airprt S-T HangarInt\Apr Interfund
070416084334 005735 Airprt SE Hangar Int\Apr Interfund
070416084334 005735 Airprt SW Hangar-Int\Apr Interfund
070501030006 06862184 Check:599768\HAW%EYE FIRE AND SAFET
_ Fund
070416084334 005735 Corp Hangar Loan Prn\Apr Interfund
070416084334 005735 Airprt S-T HangarPrn\Apr Interfund
070416084334 005735 Airprt Se Hangar Prn\Apr Interfund
070416084334 005735 Airprt SW Hangar-Prn\Apr Interfund
Total Interfund Transfers Out --Fund
Total Airport Operations
Page: 4
Debit Credit
1988.45
40.28
1017.02
967.36
------------ ------------
4013.11
105.00
------------------------
105.00
1011.55
1841.30
312.98
462.64
------------------------
3628.47
------------------------
17459.18
TRID: 05.03.07 14:47:29
Iowa City General Ledger System
Expenditures Detail
FY 2007 Detail Reporting
For the period 04.01.07 to 04.30.07
Page: 5
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
Trans Date Trans Type
---------------------
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
490190 Interfund Transfers Out-,
}+} GRAND TOTAL ***
Iowa City General Ledger System
Expenditures Detail
FY 2007 Detail Reporting
For the period 04.01.07 to 04.30.07
Report# Source Description
Fund (CON
Page: 6
Debit Credit
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
01.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 a ASSOCIATES\APRIL 07\HA
153.00
04.03.07
Payment
070403101550
00005279
1-10\BULGERELLI DAVID\APRIL 07\HAN
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, EEITH\APRIL 07\HANGAR #32
512.00
04.03.07
Payment
070403101550
00005331
1-4\HRUSE 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 JAMBS\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\SHANELIN DOUG\PAYMENT
153.00
04.06.07
Payment
070406093208
00005295
1-14\ANDERSON MARE\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 THBRPY 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 RICE\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
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
---------------------------------
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
382200 Building/Room Rental (CONTINUED)
04.10.07 Payment 070410100608
04.10.07 Payment 070410100609
04.10.07 Payment 070410100608
04.10.07 Payment 070410100608
04.10.07 Payment 070410100608
04.11.07 Payment 070411093254
04.11.07 Payment 070411093254
04.11.07 Payment 070411093254
04.12.07 Payment 070412091813
04.12.07 Payment 070412091813
04.13.07 Payment 070413093530
04.13.07 Payment 070413093530
04.13.07 Payment 070413093530
04.13.07 Payment 070413093530
04.16.07 Payment 070416095047
04.16.07 Payment 070416095047
04.16.07 Payment 070416095047
04.16.07 Payment 070416095047
04,17.07 Payment 070417102231
04.17.07 Payment 070417102231
04.18.07 Payment 070418094212
04.26.07 Payment 070426090602
04.26.07 Payment 070426090602
04.26.07 Payment 070426090602
04.26,07 Payment 070426090602
04.26.07 Payment 070426090602
04.26.07 Payment 070426090602
04.26.07 Payment 070426090602
04.26.07 Payment 070426090602
04.27.07 Payment 070427093144
04.27.07 Payment 070427093144
04.27.07 Payment 070427093144
00005278 1-28\HALL ROBERT\APRIL 07\HANGAR #
00005281 1-24\HOLLY FORREST\APRIL 07\HANGAR
00005299 1-2\TRATCHEL JACK\APRIL 07\HANGAR
00005301 1-29\CHALKLEY BBN\APRIL 07\HANGAR
00005315 1-1\SQUADRONS UP\APRIL 07\HANGAR #5
00005277 1-7\BULLERS JONATHAN\APRIL 07\HANG
00005323 1-1\WIECHERT RONALD\APRIL 07\HANGA
00005326 1-6\STEARMAN\APRIL 07\HANGAR #47
00005275 1-6\RAHEY CHARLES\APRIL 07\HANGAR
00005338 1-13\ALEKIS PARK INN & SUITZS\APRIL.
00004166 1-2\OPERATOR PERFORMANCE LAB\NOV 06
00005047 1-1\FULL JERRY\MARCH 07\HANGAR #45
00005284 1-5\HALL DAN\APRIL 07\HANGAR #27
00005303 1-9\ZUBROD ROY\APRIL 07\HANGAR #20
00005054 1-21\TUCKER JIM\MARCH 07\HANGAR #3
00005305 1-3\FARRIS GREG\APRIL 07\HANGAR #2
00005336 1-23\FLANAGAN DAMES\APRIL 07\HANGA
00005336 1-23\FLANAGAN JAMES\CREDIT
00005292 1-2\OCKENFELS TRANSFER\APRIL 07\HAN
00005340 1-7\VRANEK DOUGLAS\APRIL 07\HANGAR
00005329 1-15\SAPPHIRE VISTAS LLC\APRIL 07\H
00005041 1-6\ZIMMERMAN GRRG\MARCH 07\HANGAR
00005041 1-6\ZIMMERMAN GREG\MARCH 07\HANGAR
00005041 1-6\ZIMMERMAN GREG\MARCH 07\HANGAR
00005041 1-6\ZIMMERMAN GREG\MARCH 07\HANGAR
00005283 1-7\ZIMMERMAN GRRG\APRIL 07\HANGAR
00005283 1-7\ZIMMERMAN GREG\APRIL 07\HANGAR
00005283 1-7\ZIMMERMAN GRRG\APRIL 07\HANGAR
00005283 1-7\ZIMMERMAN GREG\APRIL 07\HANGAR
00004398 1-5\KLEIN DEREK\DEC 06\HANGAR # 12
00004629 1-6\KLEIN DEREK\JAN 07\HANGAR # 12
00004862 1-7\KLEIN DERHK\FBB 07\HANGAR # 12
Page: 2
Debit Credit
2.00
121.00
132.00
132.00
132.00
153.00
121.00
132.00
153.00
121.00
121.00
7660.51
186.00
132.00
132.00
153.00
132.00
134.00
186.00
121.00
132.00
132.00
132.00
153.00
153.00
132.00
132.00
153.00
153.00
132.00
132.00
132.00
TRID: 05.03.07 14:47:38
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
7600 Airport (CONTINUED(
560100 Airport Operations (CONTINUED(
382200 Building/Room Rental (CONTINUED(
04.27.07 Payment 070127093144 00005098 1-8\KLHIN DHRBK\MARCH 07\HANGAR #
04.27.07 Payment 070427093144 00005339 1-9\KLHIN DHRBK\APRIL 07\HANGAR #
04.30.07 Payment 070430114214 00005060 9-1\TEARSE DAVID\MARCH 07\HANGAR #
Total Building/Room Rental
384900 Other Commissions
04.20.07 Old Sys 070423010005
Total Other Commissions
392100 Sale of Land
04.19.07 Old Sys 070423010005
Total Sale of Land
Total Airport Operations
2.00
Page: 3
Credit
------------
132.00
132.00
153.00
------------
18627.51
4203077\NEWTON HOME OIL CO\GAS FLOW 500.00
------------------------
500.00
4193076\WILLIS AND WILLIS\SALE OF L 439649.00
------------------------
439649.00
------------------------
2.00 465375.43
TRID: 05.03.07 14:47:38
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
----------- ---------------------- -------- -----------------------
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
Total Airport
Page: 4
Debit Credit
--------------------------------
------------------------
2,00 465375.43
TRID: 05.03.07 14:47:38
Iowa City General Ledger System
Revenues Detail
FY 2007 Detail Reporting
For the period 04.01.07 to 04.30.07
Page: 5
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 %
GIL Account Description To Date Years To Date Month Budget In Budget Spent
------------- ----------------------------- ------------ ------------ ------------------------ ------------ ------------ -----
}}t}}ti{ifitt#Ott#itttt4ttttttYtttt{tttttt#ttt tt tttf }i }ti#t4#tttt}t
3403 Airport North Commercial Park Old System #: 37410
{{{}tti#tt{t}tint##ttttttttiftt{ttttitttttttt}t#i#tttt##ttitTt}ttt
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 o
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#4ttk}tt#t##t#t##4+tk4k#ttt#++}t+tf ttttttt##4##ttttttt t##tt##t##
3406 HE Property Development Old System #: 00000
t#t+}}}+ttt}t}}t#4#4ttti}ttt4++4}titttttt}tt#t44ttt######tf tttt#t#}
EXPENDITURES
560300 432060 AirCapAcq Consultant Services 1,050.00
------------
TOTAL EXPENDITURES 1,050.00
NET FOR PROJECT -1,050.00
Cash Balance:-1,050.00
Beginning Balance:
#t#t#titttttttttttt###4tt#ttttttt###t!#tttlttttti}#kt It+f tkttti4}tt
3415 Building B,C,K Roof Replacement GAVI-IOW Old System #: 37430
tft+#+ti+ttit#tt4+#4kt#!k}tt+#####ki ti+t ttttt tt tt+4+kt+4+ttttttt}44
RECEIPTS
1,050.00-1,050.00
-------- ----------------------------------- -----
1,050.00-1,050.00
--------- --------
-1,050.00
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
Iowa City General Ledger System
CAPITAL PROJECTS
RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
Page: 3
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
-------------------------------------------------------------------------------------------------- ------------ -----
EXPENDITURES
560300 431111 AirCapAcq Engineering Service
560300 432060 AirCapAcq Consultant Services
560300 433044 AirCapAcq Advertising
560300 442010 AirCapAcq Bldg Rep & Maint
560300 472010 AirCapAcq Building Improvemen
560300 473010 AirCapAcq Contracted Improve
TOTAL EXPENDITURES
NET FOR PROJECT
6,221.54 6,221.54
350.00 350.00
465.50 465.50
42,509.90 42,509.90
9,899.94 9,899.94
------------------------
59,446.88 59,446.86
------------------------
374.79
Cash Balance:
Beginning Balance:
t!}4#}f}#44k44#tf#ittkt4}tt}44##tt}t4t44 tt ttt}t}##t#tt#t#t+ttttt#tt
3416 Runway 7 Design, EA, Extension, FAA #10 Old System #: 37440
tttttttttti}}}#tt#ttt}tt#4tttt}#4#ftitit4+#tt}t}}}}}t}}44t}}}ttt++t
RECEIPTS
560300 331100 AirCapAcq Federal Grants
560300 393140 AirCapAcq General Fund CIP Fu
560300 393411 AirCapAcq From 02 GO Bonds
560300 393414 AirCapAcq From 05 GO Bonds
M�I�➢VA�I;Ic{y;113��Y
374.79
------------------- ------------
-------------------
-374.79
1,277,240.00 1,163,207.00 114,033.00
19,243.93 19,243.93
144,338.90 144,338.90
------------------------ ------------
1,440,822.83 1,326,789.83 114,033.00
227,851.00 113,818.00 50.1
-98,327.00-98,327.00
----------------------- -----
129,524.00 15,491.00 88.0
DF$GL_CUSTON:CIPPROJ: 05.03.07 14:48:40
Iowa City General Ledger System
CAPITAL PROJECTS
RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
G/L Account Description
------------- --------------------
EXPENDITURES
560300 431111 AirCapAcq Engineering Service
560300 432060 AirCapAcq Consultant Services
560300 433044 AirCapAcq Advertising
560300 435060 AirCapAcq Legal Publications
560300 446100 AirCapAcq City Attorney Chgbk
560300 471021 AirCapAcq Temporary Easement
560300 471030 AirCapAcq Right -of -Way
560300 473010 AirCapAcq Contracted Improve
TOTAL EXPENDITURES
NET FOR PROJECT
Page: 4
Total Project Prior Fiscal This Year This This Year Remainder 8
To Date Years To Date Month Budget In Budget Spent
------------ ------------ ------------------------------------ ------------ -----
291,999.66
271,081.95
20,917.71
-20,917.71
24,608.21
24,609.21
16:29
16.29
227.63
208.83
18.80
-18.80
24.80
24.80
-24.80
3,592.18
3,592.18
33,952.62
33,952.62
877,770.98
831,974.98
------------------------
45,796.00
------------
188,566.00 142,770.00 24.3
------------ ----------- -----
------------
1,232,192.37
1,165,435.06
66,757.31
188,566.00 121,808.69 35.4
------------
208,630.46
Cash Balance:
Beginning Balance:
161,354.77 47,275.69
104,318.33
57,042.64
++tt+++++t4tt+tttt++tt++ttt#ttttttt}tttt+#+#}+###t+#++t+}}t+rttt++t
3419 Aviation Commerce Park Site Development Old System #: 00000
++i#tt}}#}#+ttt#tti}t}434++++4++ttttt}ttttt tt ttttttt444ttttt}##4#44
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
Iowa City General Ledger System
CAPITAL PROJECTS
RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
Page: 5
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:
tt}#t##t#f}}##ft4}}4i4}#44ttttttff4tttttitt}tt tt tt}ii3t44}###4###t4
3420 Runway 7 Grading FAA #11 & #12 Old System #: 37441
ttttt+tt4f tt}}f tittt#t#t}ftf tt tt44tt4i##tf ttf t}ttff tffttt}}}ttYtt4t
RECEIPTS
560300 331100 AirCapAcq Federal Grants
560300 393140 AirCapAcq General Fund CIP Fu
560300 393240 AirCapAcq From Airport Operat
560300 393416 AirCapAcq From 07 GO Bonds
TOTAL RECEIPTS
EXPENDITURES
137,876.00 110,379.00 27,497.00 1,534.00 39,621.00 12,124.00 69.4
14,558.40 14,558.40
-6,664.00-6,664.00
------------------------------------ ------------------------ ----------- -----
152,434.40 124,937.40 27,497.00 1,534.00 32,957.00 5,460.00 83.4
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
G/L Account Description
------------- --------------------
TOTAL EXPENDITURES
Iowa City General Ledger System
CAPITAL PROJECTS
RBCBIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
Total Project Prior Fiscal This Year This
To Date Years To Date Month
--------------------------------------------
------------ ------------ --------------------
145,133.31 133,273.11 11,860.20
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
tttttttttt+ff+t++t+t+t+trtt+tttttt+ttt++tfttttt+t++t+t+t++t+t+t++t+
3421 Runway 7 Paving/Lighting FAA #14 Old System #: 00000
++++r+++t++t+t+++++tft++tt++t++++t+++++++++++r++tt+++tt++++++t+++++
Page: 6
This Year Remainder T
Budget In Budget Spent
----------------------- -----
----------- ----------- -----
24,622.00 12,761.80 48.2
RECEIPTS
560300 331100 AirCapAcq Federal Grants 2,129,425.00 2,129,425.00
560300 393416 AirCapAcq From 07 GO Bands 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
G/L Account Description
------------- -------------------------
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
To Date Years To Date Month
------------ --------------------------------
++++++++f tittttf#tfi#tttf ttttt}tttt++++}++fft++++++tt+t+t+++tff++7f
3422 Airport Taxilane/Apron Pavement Rehab 9I Old System #: 37496
}+ftttitt}#i++4}44tf}tt}tttttift#fk4}44tttttttttt}}+f +fftttf #tttt#t
RECEIPTS
560300 334900 AirCapAcq Other State Grants
560300 393140 AirCapAcq General Fund CIP Fu
560300 393240 AirCapAcq From Airport Operat
TOTAL RECEIPTS
EXPENDITURES
560300 431111 AirCapAcq Engineering Service
560300 435060 AirCapAcq Legal Publications
560300 473010 AirCapAcq Contracted Improve
TOTAL EXPENDITURES
NET FOR PROJECT
128,110.96 128,110.96
18,099.53 18,099.53
45,222.46 45,222.46
---------------------- -------------------
191,432.95 18,099.53 173,333.42
Page: 7
This Year Remainder t
Budget In Budget Spent
----------- ------------ -----
128,111.00 .04 100.0
36,805.00-8,117.46 122.9
---------- ----------- -----
164,916.00-8,417.42 105.1
26,329.06 11,844.55 14,484.51-14,484.51
92.78 92.78 -92.78
165,011.11 165,011.11 171,171.00 6,159.89 96.4
---------------------------------------------------------- ----------- -----
191,432.95 11,844.55 179,588.40 171,171.00 -8,417.40 104.9
------------------------------------
6,254.98-6,254.98
Cash Balance:
Beginning Balance: 6,254.98
DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40
Iowa City General Ledger System
CAPITAL PROJECTS
RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
Total Project Prior Fiscal This Year
G/L Account Description To Date Years To Date
---------------------------------------------------------------------------
++++ttfttttt+++t+t+t+t+tt}ttt+}++}tt}+++tt+tttttt+++tt++ttt++++++++
3424 Hard Surface Floors Bldgs B & C #9I-05-0 Old System #: 37495
itttttt}t+}}}t}t}#t#+tf##kt+ttttf+ttttttttt}+###+t it tf ttttttttttttt
RECEIPTS
560300 334900 AirCapAcq Other State Grants
560300 393140 AirCapAcq General Fund CIP Fu
560300 393240 AirCapAcq From Airport Operat
TOTAL RECEIPTS
EXPENDITURES
560300 431111 AirCapAcq Engineering Service
560300 435060 AirCapAcq Legal Publications
560300 472010 AirCapAcq Building Improvemen
560300 473010 AirCapAcq Contracted Improve
TOTAL EXPENDITURES
NET FOR PROJECT
47,672.12 43,528.82 4,143.30
21,428.00 21,428.00
Page: 8
This This Year Remainder %
Month Budget In Budget Spent
--------------------- ------------ -----
15,829.00 11,685.70 26.2
3,636.00 3,636.00
----------------------------------------------------------------------- -----
69,100.12 64,956.82 4,143.30 19,465.00 15,321.70 21.3
8,889.83 8,889.83
84.45 84.45
59,128.75 56,172.31 2,956.44 19,651.00 16,694.56 15.0
------------ ---------------------------------------------------------- -----
68,103.03 65,146.59 2,956.44 19,651.00 16,694.56 15.0
------------------------------------------
997.09-189.77 1,186.86
Cash Balance: 997.09
Beginning Balance:-189.77
DF$GL_CUSTOP4:CIPPROJ: 05.03.07 14:48:40
Iowa City General Ledger System
CAPITAL PROJECTS
RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
Page: 9
Total Project Prior Fiscal This Year This This Year Remainder %
G/L Account Description To Date Years To Date Month Budget In Budget Spent
------------- ----------------------------------------- ------------ ------------ ------------ ------------ ------------ -----
++++++++++++t+++++++++tt+++ttxf+t}++++tttt+++++t4++++tttttt t++tx+++
3425 FAA Runway 7 Grading/Obstruction Mitigat Old System #: 37443
tttttttttt}}ktt}ttt4f xtttttitttit tYkt44tttttttttt+4}t+tftt}}tttttt+
RECEIPTS
560300
331100
AirCapAcq
Federal
Grants
666,262.00
560300
393140
AirCapAcq
General
Fund CIP Fu
8,555.21
560300
393416
AirCapAcq
From 07
GO Bonds
------------
TOTAL RECEIPTS 674,817.21
EXPENDITURES
560300 431111 AirCapAcq Engineering Service 142,346.18
560300 435060 AirCapAcq Legal Publications 209.90
560300 449055 AirCapAcq Permitting Fees 300.00
560300 473010 AirCapAcq Contracted Improve 558,412.20
------------
TOTAL EXPENDITURES 701,328.28
------------ --
NET FOR PROJECT-26,511,07
Cash Balance:
Beginning BdldNe:
666,262.00 3,976.00 1,647,826.00 981,564.00 40.4
8,555.21
86,728.00 86,729.00
-------------------------------- ----------------------- -----
8,555.21 666,262.00 3,976.00 1,734,554.00 1,068,292.00 38.4
8,370.68 133,975.50 288,300.00 154,324.50 46.5
184.53 25.37 -25.37
300.00-300.00
558,472,20 1,446,254.00 887,781.00 38.6
8,555.21 0-92,773.07 1,734,554.00 1,041,780.93 39.9
-
----------- ----- ------
-26,511,07 3,976.00
-26,511.07
DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:48:40
Iowa Citv General Ledger System
CADTTAT, PROJECTS
RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
Paae: 10
Total Project Prior Fiscal This Year This This Year Remainder $
G/L Account Descriotion To Date Years To Date Month Budget In Budget Soent
------------ ----------------------------- -------- ---- ------------------------ ------------------------ ------------ -----
:.....:::::::t:...... :ttttttttttttttt......
:t
3431 Rehabilitate Hangar A 9I-07-0I0N-300 Old Svstem #: 37375
z:z:ii}%%ittit###t#tis}tilt}itii%i%tttttkttisit}#tit tiiiitiittt}iit
RECEIPTS
560300 334900 AirCapACq Other State Grants
560300 393240 AirCapACq From Airport Operat
TOTAL RECEIPTS
EXPENDITURES
5603UU 431111 AirCapAcq Engineering Service
560308 435060 AirCapACq Lagal Put' Ca, ion3
560300 473010 AirCapACo Contracted Improve
TOTAL _cPENDITURES
NET FOR PROJECT
1,419.60 1,419.00 1,419.o0 49,300.00 47,881.00 2.9
8;700.00 8,700.00
------------------------ ------------------------ ------------ ----------- -----
1,419.00 1,419.00 1,419.00 58,000.00 56,581.00 2.5
2,833.95
19.40
2,833.95 1,162.80
19.40 19.40
58,000.00
2,853.35 2,853.35 1,182.20 58,000.0o
-1;434.35-1,434,35 236,80
Cash Balance:-1,434.35
Beginning Balance;
tttt}ttt ttttttttttttf#tt+**tint tt ttt ttt ttt#ktt# t k t k t t t t t t t t t t t t t tt
3432 Rehabilitate South T Hangar Taxi Lanes 9 Old Svstem #: 37497
4#kt++tt+ttt ktk4ttt+tt+tttttttttt##kt#kkkk4k44kkkkkt+tt tkttttttttt+
RECEIPTS
-2,833.95
-19.40
59.000.00
SS,T46.65 -.9
560300 334900 AirCapACq Other State Grants 3,962.00 3,962.00 3,962.UU 111,510.00 107,548.00 3.6
DF$GL_CUSTOM:CIPPROJ: 05.03.07 14:49:40
Iowa City General Ledger System
CAPITAL PROJECTS
RECEIPTS AND EXPENDITURES FOR FISCAL YEAR 2007
THROUGH 04.30.07
Page: 11
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
TOTAL RECEIPTS 3,962.00
EXPENDITURES
560300 431111 AirCapAcq Engineering Service
560300 435060 AirCapAcq Legal Publications
560300 473010 AirCapAcq Contracted Improve
TOTAL EXPENDITURES
47,790.00 47,790.00
3,962.00 3,962.00 159,300.00 155,338.00 2.5
11,767.15 11,767.15 6,105.64-11,767.15
20.47 20.47 20.47 -20.47
159,300.00 159,300.00
--------------------- ------------------------------------ ------ --- ----
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:-7,825.62
Beginning Balance:
44ffttttttt#tttt}}#t}#i4}tt4tttktkttf tttttt#tt#t t}tti t#}#tt#ttttttt
3433 Nest Terminal Apron Rehabilitation Old System #: 00000
####t4f}fft#4t#}}}4f#}#}#}##}tkt}4ftff iff}44444#}}ttttt tt t}}tt}44#}
EXPENDITURES
560300 431111 AirCapAcq Engineering Service 2,915.27
------------
TOTAL EXPENDITURES 2,915.27
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:
-2,915.27
-2,915.27