HomeMy WebLinkAbout08-25-2011 Airport CommissionAIRPORT TERMINAL BUILDING
1801 S. RIVERSIDE DRIVE
IOWA CITY, IOWA
THURSDAY, AUGUST 25,2011 — 5:OOP.M.
1, Determine Quorum
2. Approval of Minutes from the following meetings:
July 21, 2011; August 4, 2011
3. Public Discussion - Items not on the agenda
4. Items for Discussion/Action:
a. Corporate Hangar L
i. Consider a resolution accepting bids and awarding contract
ii. Consider a resolution approving contract with of Infrastructure and
Environment LLC for engineering construction administration and
observation services
iii. Hangars
1. Consider a resolution setting a public hearing on Hangar L leases
b. Terminal Building Brick Repair
i. Consider a resolution approving contract with VJ Engineering for design
and construction engineering services.
c. Ruppert Land
d. Airport Commerce Park
e. Airport Farming / Farmer's National Agreement
f. FAAIIDOT Projects ® AEC OM David Hughes
I. Runway 7/25 & 12/30
ii. Obstruction Mitigation
iii. 7-25 Parallel Taxiway
1. Consider a resolution approving agreement with AEC OM for
construction related services for the construction of the Runway 7-
25 Parallel Taxiway Grading and Drainage
g. Airport "Operations": Strategic Plan -implementation; Budget; Management
i. Airport Operations Specialist Position
h. FBO / Iowa Flight Training / Whirly.bird Reports
I. Subcommittees' Reports
j. Commission Members'Reports
k. Staff Report
5. Set next regular meeting for September 15, 2011 at 6.00 p.m.
6. Adjourn
Airport Commission
July 21, 2011
Page 1
MINUTES
IOWA CITYAIRPORT COMMISSION
JULY 21, 2011 — 6:00 P.M.
AIRPORT TERMINAL BUILDING
Members Present: Jose Assouline, Steve Crane, Minnetta Gardinier, Howard Horan, Rick
Mascari
Staff Present: Sue Dulek, Michael Tharp
RECOMMENDATIONS TO COU® s touncil
actionl- None
CALL TO ORDER:
Chairperson Gardinier called the meeting to order at 6:08 P.M.
APPROVAL OF MEETING MINUTES:
The minutes of the June 16, 2011, meeting were briefly discussed. Mascari moved to
approve the June 16, 2011, minutes as submitted; seconded by Crane. Motion carried 5-
0.
None.
a. Aviation Commerce Park — Jeff Edberg — Edberg addressed the Members, noting that
they have a new reporting system. He noted that since the last meeting he has not
received any additional calls on the lots, but that another broker thought he had a
possibility. Edberg continued, noting that he does have a very interested party and
plans are being developed for a 7,000 -square foot facility for a commissary (kitchen)
type business. He also noted that the dog business who is interested in a lot is still
struggling with financing at this point.
i. Public Hearing — Gardinier opened the public hearing. Eric Scott joined the
Members at the table, noting that he has plans and specs to share with them. Tharp
noted that what the Members are seeing is a modification of the previous plans. He
noted that the pricing of the 62 ft. x 65 ft. hangars is just too high for their budget.
Tharp continued to respond to questions and concerns about this change in the
hangar plans and specs. Members voiced their concerns about the sizing of this
hangar, with Mascari noting that he believes they are not ready yet to move forward
with this. He believes they need to Kook at this a bit more. Tharp stated that with the
Airport Commission
July 21, 2011
Page 2
budget they have to work with, they do have some limitations. Scott responded to
Members' questions, as well. Mascari asked for some clarification on the funding thal
they do have and how much they would need to come up with. He asked if the State
still offers 70% money on infrastructure projects. Tharpdo
respond,o questions,a.ning what led them to offer the alternative plans.
discussion centered on a hangar with various sized doors'and spaces, with Members
noting that they need to think about future needs and being flexible. Members
continued to discuss various configurations for a hangar. Jet Air weighed in as well
on what size hangars needs.4' agreed
theirlike to have Eric Scott 'return with a cost estimate for the alternative configuration for
f Gardinier
went around the table to get everyone's opinion. Dulek then informed the Members
+' they need to -o in this situation. '
1 acceptplan as discussed, addendum alternate opt
Members decided to hold a special meeting on Thursday,
P.M. Mascari '� , August4
111 meeting.
Horan seconded the motion. Motion carried -0..
Constructionii. Consider a Resolution Approving Plans, Specifications, and Form of Contract for the
ao defer this
to the 814111
Horan seconded motion. MotionM I,..
fflascari asked if the Commissiond; jump to Item g.i, as he has another commitment
and meeting:
1. Runway 7125 & 12130 — Tharp noted that there isn't much to update. They are still
awaiting the FAA to get throughdocumentation before this project
closedcompletely
Obstruction Mitigation — Nothing new to report
7-25 Parallel >,` p noted that Public-' is currentlydoing g
meansindependent review on this. That
next meeting.
1. Consider a Resolution Approving Agreement With AECOM for Construction
Related Services for the Construction of the Runway 7-25 Parallel Taxiway
Grading and Drainage — Horan}': l defer the resolution
August
special4, 2011 seconded the motion.4-0;
LEDs,Mascari absent.
d. FY2012 Iowa Department of Transportation Grants — Tharp noted that the paperwork
has been received on one of the grants. This is for the exterior lighting, switching over to
f more electrical work on the hangars, along with security upgrades.";-
that the entire programapproved; g for about $750,000 wor
pending signature „ i«,
Airport Commission
July 21, 2011
Page 3
L Consider a Resolution Accepting Grant Agreement 911201OW100 —Horan moved to
recommend Resolution #A11-18 Accepting Grant Agreement 911201OW100 as
discussed. Assouline seconded the motion. Motion carried 4-0; Mascari
absent.
e. 2011 Air Race Classic — Tharp noted that he put this on the agenda, as he wanted to
thank the Jet Air staff for all they did during the Air Race Classic. He added that it was a
good event even though they did not get the final send-off due to the weather. Gardinier
noted that she received good feedback from the racers. One of the comments made at
the end of the race, according to Gardinier, was that the Air Race Classic should
consider places like Iowa City in the future.
f. 2011 — 2012 T -Hangar Rates and Charges — Gardinier recused herself from this
discussion, as she has a conflict of interest in the matter. Tharp noted that it is that time
of the year again to start looking at rates and fees at the Airport. He noted that Members
received a memo from him laying out the background on this matter. His recom-
mendation is to raise rates based on the inflationary factor. Tharp responded to
Members' questions concerning hangar rates. Members also discussed the waiting list
numbers with the commission. Gardinier commented from the public that she felt
renters at the airport were paying a premium to have their aircraft here. Gardinier then
asked about the status of the waiting list to which Tharp responded. Wolford
commented that the construction of the new hangars would also impact the list. Tharp
noted that leases expire in September. Members looked at several different scenarios
and came to the agreement that a 2.5% increase is what they would like to go with.
Tharp stated that they will be using the same lease agreement, as this has not changed.
Horan moved to increase all rents by 2.5%. Crane seconded the motion. Motion
carried 3-0; Gardinier recused herself and Mascari absent.
g. Airport "Operations": Strategic Plan Implementation; Budget; Management —
Airport Operations Specialist Position [This item was discussed earlier, following
Item b.ii., as noted above.]— Mascari noted that he would like to review the
Operations Specialist position. He continued, stating that he believes they should
change this position from part-time status to full-time. He explained his reasoning
for this, adding that if they were to lose Tharp to another airport it would be a huge
loss for the Commission. He would like to see this change made in order to protect
their interests of having a full-time Airport manager. Gardinier noted that she would
support such a change. Gardinier asked Tharp to draft a rationale with specific
goals for how the additional time would benefit the Airport and the Commission. A
discussion ensued, with Members agreeing that this position should be full time.
The history of how this position developed was also discussed. Gardinier noted that
she would like to speak with the City Manager regarding the amount the Airport puts
toward the Economic Development Coordinator position. This amount would help
them in bringing the Airport position up to full time. (Mascari left the meeting at this
point.)
ii. Gardinier asked if anyone had anything regarding Airport operations. Tharp noted
that they are now in the new fiscal year. He stated that they ended with about
$70,000, but the parking lot overlay is still needed and that is around $40,000. This
leaves around $30,000 from last fiscal year. Tharp noted that he was notified of a
July 21, 2011
Page 4
"homeless" encampment on some Airport property recently. Me added that it will
take some time to clean up this area and that everything needs to be removed.
This will take some tractors that are able to knock down large brush. Tharp stated
that he is working with Carol Sweeting from City Hall on this issue. The discussion
continued, with Tharp noting that there were two areas with about 5 or 6 tents.
Gardinier stated that she believes the police should be watching this area more
closely if there are that many camps being kept. Tharp will let Members know what
he finds out from City staff. Gardinier stated that she believes they should get som;��
estimates on cost for removing this brush. Tharp added that he wants to see what
Carol Sweeting can come up with as she is suggesting volunteer help.
Tharp noted that he and Gardinier have been working on the accelerated hangar
debt repayment agreement. He noted that the current agreement distributed to
them is from the City Manager's office. He briefly explained the idea behind this
70/30 split, with 70% of sales proceeds paid directly to the City and with 30% of
sales proceeds retained by the Commission if needed for airport expenditures. This
will maintain the current status quo policy of the City matching funds. Tharp added
that if the Members are in agreement, they can move forward with this. Horan
moved to approve the agreement regarding hangar debt repayment and lot
sales, per the City Manager's agreement. Crane seconded the motion.
Motion carried 4-0; Mascari absent.
Iowa Flight Training I Whirlybird Reports — Matt Wolford of Jet Air addressed
the Members, stating that they were really happy with the Air Race Classic turnout. He
noted that they have still been mowing a lot and keeping bushes trimmed. Philip
Wolford spoke next, stating that they will be switching fuel vendors in the near future,
sometime between August 15 and September 15. They will be going with Shell once the
change is made. He added that this brings his three locations under one fuel vendor
and ordering system. Philip also noted that Pat Sheridan's last day was the last day of
the Air Race (June 21) and that he has moved to Colorado for a job.
A 0 W1, wff -, M-3 !� }, 4 i "
j. Commission Members' Reports — Horan asked that Members check the Facebook
page for the Airport, adding that he put some photos up.
Staff Report — Tharp reminded Members that the FAA Airports Conference is coming u;t
in Kansas City, September 27-28, 2011. He added that if anyone would like to join him
to please let him know.
SET INEXT REGULAR MEETING:
A special meeting will be held on Thursday, August 4, 2011, at 6:00 P.M., and the next regular
meeting will be Thursday, August 18, 2011, at 6:00 P.M. at the Airport Terminal building.
ADJOURN:
Gardinier made the motion to adjourn the meeting at 8:40 P.M.; seconded by Horan.
Motion carried 4-0; Mascari absent.
Airport Commission
July 21, 2011
Page 5
Kim
M
KIEWN10=1
NM = Not a Member at this time
TERM
NAME
EXP.
04
CD
CA
(D
CO
I
C-4
C—f)
LO
CO
r—
Rick
03/01/13
X
x
x
x
x
x i
x
x
X/E
Mascan
Howard
03101/14
x
x
x
x
x
x
X
x
x
Horan
Minnetta
i 03/01115
X
X
X
X
X
X
X
O/E
x
Gardinier
jI—
Jose
03102112
j X
X
X
j X
O/E
O/E
X
X
X
Assouline
Steve
03102/14
O/E
I X
X
i X
X
I O/E
X
x
X
Crane
M
KIEWN10=1
NM = Not a Member at this time
Airport Commission
August 4, 2011
Page 1
MINUTES'
IOWA CITYAIRPORT COMMISSION
AUGUST 4, 2011— m
AIRPORT TERMINAL BUILDING
Members Present- Jose Assouline,Horan,
Mascari
.firCOMMENDATIONS TO UNCII1L„w (to becomeffeetive onl
Uki��u�lUw I��u�
Au
b. FY2012 Iowa Department of Transportation Grant
i. Tharp noted this is the other grant that had been expected from the state. Tharp
noted this grant
Airport Commission
August 4, 2011
Page 2
value of the grant was, and if there were matching funds required. Tharp noted
the • value was $100,300 and that there was a 15% local match. Mascari
moved resolution #A1 1-20, seconded by • Motion carried 5-0.
Airport Commission
August 4, 2011
Page 3
Airport Commission
ATTENDANCE RECORD
KM
TERM
NAME
C14
C14
LO
0
r--
00
Rick
03/01/13
X
x
x
x
x
x x
X
X/E
Mascari
Howard
03101/14
X
x
x
x
x
x x
x
x
Horan
Minnetta'
03101115
X
x
x
x
x
x X
O/E
X
Gardinier
Jose
03102112
X
x
x
X
O/E
O/E X
x
x
Assoullne
Steve
03102114
O/E
X
x
x
X
OIE X
x
x
Crane
onml��
X/E = Present for Part of Meeting
NM = Not a Member at this time
Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045
•• -� • •_
CHAIRPERSON SIGN AND � • •
FOR THE CONSTRUCTIONOF
WHEREAS,
of 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 bids for the above named projected are accepted.
2. The contract for the construction of the above named project is hereby awarded to
subject to the conditions:
a. That awardee secures adequate performance and payment bond, insurance
certificates, and contract compliance program statements.
3. 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 upon instruction from legal counsel.
Passed and approved this ___ day of
It was moved by and seconded by
adopted, and upon roll call there were:
Ayes
Nays
Approved b
City Attorney's Office
Absent
2011,.
the Resolution be
Assouline
Crane
Gardinier
Horan
Mascari
WHEREAS, the Commission desires to secure the services of Foth Infrastructure and
Environment, LLC to provide engineering construction administration and observation services
relM ted to the proposed Iowa City Municipal Airport Hangar'L' Construction.
NOW, THEREFORE, BE IT RESOLVED BY THE AIRPORT Cn1,4hMSXM-O-14!-T�C1TY-O-F
IOWA CITY:
MA"1140MIN M11111 Al, I
Passedand approved this day of ................................................. ..... . ... .. ........ . . ........................ ................................................... ___, 2011.
CHAIRPERSON
Approveby
A 7EST:
......... ......................... . .............. . ............ . .. . ......
SECRETARY City Attorney's Office
It was moved by and seconded by
adopted, and upon roll call there were:
MM
THIS AGREEMENT, made and entered into this day of
2011 , by and between the Iowa City Airport Commission, Iowa City, Iowa, hereinafter referred
to as the Commission and Foth Infrastructure and Environment, LLC. , of Cedar Rapids ,
hereinafter referred to as the Consultant.
WHEREAS, the Commission desires to secure the services of the Consultant to provide
engineering construction administration and observation services related to the proposed Iowa
City Municipal Airport Hangar 'L' Construction.
NOW THEREFORE, it is agreed by and between the parties hereto that the Commission does
now contract with the Consultant to provide services as set forth herein.
Consultant agrees to perform the engineering services for the Commission, and to do so in a
timely and satisfactory manner. Services provided under this agreement shall be as further
described in Attachment A, attached and incorporated herein.
���1111#7►1
The Consultant shall complete construction phase services for the Project on or before February
24th, 2012.
A. The Consultant shall not commit any of the following employment practices and
agrees to prohibit the following practices in any subcontracts.
To discharge or refuse to hire any individual because of their race, color,
religion, sex, national origin, disability, age, marital status, gender identity,
or sexual orientation.
2. To discriminate against any individual in terms, conditions, or privileges of
employment because of their race, color, religion, sex, national origin,
disability, age, marital status, gender identity, or sexual orientation.
B. Should the Commission terminate this Agreement, the Consultant shall be paid for
all work and services performed up to the time of termination. However, such
sums shall not be greater than the "Not -to -exceed" amount listed in Section IV.
The Commission may terminate this Agreement upon seven (7) calendar days'
written notice to the Consultant.
C. This Agreement shall be binding upon the successors and assigns of the parties
hereto, provided that no assignment shall be without the written consent of all
Parties to said Agreement.
D. It is understood and agreed that the retention of the Consultant by the Commission
for the purpose of the Project shall be as an independent contractor and shall be
exclusive, but the Consultant shall have the right to employ such assistance as
may be required for the performance of the Project.
Foth Infrastructure and Environment, LLC.
Project No. 111010.00
F-114 a r-1101 0 1 JA 1:4 ki Ill
Iowa City Municipal Airport Hangar'L' Construction
Iowa City, Iowa
Construction Phase Services
Iowa City, Iowa
work, services, materials, equipment and supplies necessary to complete the proposed Iowa City
Municipal Airport Hangar'L' Construction administration and observation phase services.
The proposed project involves construction administration and observation phase services for the
construction of Hangar'Lsite-work and pre-engineered aircraft hangars.
The scope of services to be performed by the Consultant shall be completed in accordance with generally
accepted standards of practice and shall include the services to complete the following phases/tasks:
I I
Previously completed
#
1.0 General Administration of Construction Contract.
2.0 Coordinate and attend preconstruction meeting and distribute minutes to the Contractor and
Owner.
3.0 Attend bi-weekly construction meetings.
4.0 Respond to Requests for Information (I's) during construction.
5.0 Shop Drawing Review
6.0 Issue clarification and change documents.
7.0 Process Applications for Payment.
8.0 Process reimbursement requests from Iowa DOT.
9.0 Review O&M manuals for completeness and coordinate submission to Owner.
10.0 Perform review and develop punchlist at the completion of project.
11,0 Develop as -built drawings based upon Contractor "redlines" and deliver one (1) hard copy of
as -built drawings to owner along with electronic copy (CAD and pdf).
Half-time onsite construction observation is anticipated for the duration of the project. Estimate is bas's
on approximately twenty (20) hours a week and a construction schedule of September 2011 through
January 2012. Additional observation and site visits by Engineer at intervals appropriate to the variou
stages of construction as the Engineer deems necessary.
ADDITIONAL SERVICES
Additional Services not incWded in this Agreement. If authorized under a Supplemental Agreement, the
Consultant shall furnish or obtain from others the following services:
1.) Construction Staking.
2.) Construction Testing.
3.) Construction Observation/Resident Project Services beyond schedule noted in Task C.
4.) ALP Update.
5.) Airport Tenant Coordination.
6.) Pavement Management Program Update.
X:\CR\[E\2011X1110I0-00\1000BudgetXCACO\Final- Revised Construction length-0822111sos--08222011-ICIOA-CACO.doc
Foth Infrastructure and Environment, LLC. Iowa City Municipal Airport Hangar Construction
Project No. 111010.00 Iowa City, Iowa
ATTACHMENT "B"
Iowa City Municipal Airport Hangar Construction
Iowa City, Iowa
X:\CR\IE'•2011\111D10-00\1000 Budget\CACO\Final - Revised Construction length-082211\sos-08222011-ICIOA-CAIO.doc
2
-
C
O
r7
----------
....
.
2-M
.....
RS
3.
-3
2
Et
0
a
m
on
1.4
-0 m
= A
U3 m
CD
rg
0 to
0 13
cm,
CD W >
mg m
0 tl
rA
Project Manager III
Lead Engineer
Project Engineer 11
A
m
AmA
AA
Nm
Nm
Am
Project Engineer I
Engineering Tech 11
jj.
Field Technician 11
Administrati—
Assistarrt
R.
Z.
Z
Ca
MITI
m
3
Iowa City Municipal Airport Hangar Construction
FOTH
1.Direct Salary Costs
Hours
Ratehlour
Cost
..'Title —
Z 7-60
Lead Engineer
16
$ 40.59
$
649..44
Project Engrn
Total Direct Salary Costs $
14,732.40
o. Labor & General Administrative Overhead
Percentage ofDirect Salary Costs 162.50%
Total In -Direct Salary Costs *
3. Out -of -Pocket Expenses
a. Transportation
Personal Vehicle Miles @$u.555/mile $
u.Per Diem
c. Materials and Supplies (Survey) $
u.Other (Phnmng.Reproduction, and Mailing ufContract Documents) $
Total Expenses $
4.Subtotal uritems 1.u.and o v
= =i..ap...~~-, 1500m $
�. ~~.. -,.__
6. Subcontract costs
Miller ounwid iemoitemue
KJvvVxEngineering Consultants
�
�
Total Subcontracted Costs $
23,940.15
7.Total Project Costs
Item 4,s.plus O
Rounded $ 61,300.00
miller dunwiddie
A, RCH� {"EC FU RE
I Direct Sallary Costs
TUB
Houm
Rate/Hour
Cost
-r-i ger
40
5 14 0
2, 1 36 00
Sr, Ar(,,1h1tecA - Specs
0
5 30
II 1ojed Archkx,1
l6
29.90----
.... ......
ArdhrtedwW Desligncii
0
21 DO
'i
AdiiiiiiIiinII,strafive AsslsPanl
4
Total Direct Salary Costs $
2,674.40
2. Labor & General Administrative Overhead
Percentage of Direct Salary Costs
3.O -of®Pocket Expenses
a. Transportation
Personal Vehicle Miles
Airfare
b. Printing and Reproduction
c. Courier / Postage / Shipping
d. Lodging
4. Subtotal of Items 1, 2, and 3
S.. Fixed Payment .15.00% of Items 1 and 2
6. Subcontract Costs
14&92%
Total In -Direct Salary Costs
1,800 0 $0.51 / mile
0 0 $900 roundtrip
3 @ $100
Total Expenses
HgERM
$918.00
$0.00
$150.00
$150.00
8
$...?5.00
. . ... .......... .......... -
$1,503.00
F"M
7. Total Project Costs (items 4, 5, and 6) $9 �066 42
9 000M
.)uncI ed 44140
.. ........ . .. .......... I
.................... .......... ......... .................. . . ... .... . .... . ............................ . ........................ ........................................ . ...... . ...........................
Iowa City Municipal Airport Hangar Construction
KJWW Engineering Consultants, PC
1. Direct Salary Costs
1� Wile
Hours
Rate"Hoi.ir
....... . .....
..............................................
Cost
. .............. —
.. .. .......................... . . . .....
ir, Engiineer .................
8
11 .1--l- ...................................
$ 53.17
. .................................. I - —1-1.1 .-1 .....................
$
1. .......... —1
425.36
1 1 . ... . . . ........
....... ....... ".. -_1 - _1 ........................ . .... . ......................... . -
gineer
16
441.72
$
567.52
$ 24.06
. ... . ..........................
$
... —
1102.48:
_ . .............................................
Admik-iistrative Assl�stan_t
10
$ 17.96
. .. . . .. .. . . ................
. ... . ....... $
179-60
. .........................
................ ...... ... ........................... . ..............................
Construcfion AdirNirdstn,-ition
........... .......................... . ..... .......... . ... . - . ..................... .................. . .
...
32
.. . .......................................
.......
$ 33.44
. ...... . .......... . . ............................ . . .1 .....................
$
1,070.08
................ 11.1
Total Direct Salary Costs $
2,535.04
2. Labor & General Administrative Overhead
Percentage of Direct Salary Costs
161.19%
Total In -Direct Salary Costs $ 4,086.23
3. Out-of-pocket Expenses
a. Transportation
Personal Vehicle Miles 0 @ $0.51 1 mile $
b. Per Diem
c. Materials and Supplies $
d. Other $
Total Expenses $ -
4. Subtotal of Items 1, 2, and 3 $ 6,621.27
S. Fixed Payment 12.00% of Items I and 2 $ 794.55
6. Subcontract Costs
Total Subcontracted Costs $
7, Total Project Costs
Item 4, 5, plus 6 $ 7,416.82
Rounded $ 7,500.00
Foth Infrastructure and Environment, LLC. Iowa City Municipal Airport Hangar Construction
Project No. 111010.00 Iowa City, Iowa
A r"II! AGHMEim r,,,c,'. INSURANCEG11:..:.-R F111:::`1CA
...........................
Iowa City Municipal Airport Hangar Construction
Iowa City, Iowa
The pertinent insurance certificates to be submitted upon acceptance of Engineering Proposal.
X:\CR\IE\2011\111010-00\100OBudget\CACO\FiriaI Revised Constnict.lonlength-OB2211\sos-08222011-ICIOA-GAGO.doe 3
-2-
E It is agreed by the Commission that all records and files pertaining to information
needed by the Consultant for the project shall be available by said Commission
upon reasonable request to the Consultant. The Commission agrees to furnish all
reasonable assistance in the use of these records and files.
F. It is further agreed that no Party to this Agreement shall perform contrary to any
state, federal, or local law or any of the ordinances of the City of Iowa City, Iowa.
G. At the request of the Commission, the Consultant shall attend meetings of the
Commission relative to the work set forth in this Agreement. Any requests made
by the Commission shall be given with reasonable notice to the Consultant to
assure attendance.
H. The Consultant agrees to furnish, upon termination of this Agreement and upon
demand by the Commission, copies of all basic notes and sketches, charts,
computations, and any other data prepared or obtained by the Consultant pursuant
to this Agreement without cost, and without restrictions or limitation as to the use
relative to specific projects covered under this Agreement. In such event, the
Consultant shall not be Liable for the Commission's use of such documents on
other projects.
The Consultant agrees to furnish all reports, specifications, and drawings, with the
seal of a professional engineer affixed thereto or such seal as required by Iowa
law.
The Commission agrees to tender the Consultant all fees in a timely manner,
excepting, however, that failure of the Consultant to satisfactorily perform in
accordance with this Agreement shall constitute grounds for the Commission to
withhold payment of the amount sufficient to properly complete the Project in
accordance with this Agreement.
K. Should any section of this Agreement be found invalid, it is agreed that the
remaining portion shall be deemed severable from the invalid portion and continue
in full force and effect.
L. Original contract drawings shall become the property of the Commission. The
Consultant shall be allowed to keep mylar reproducible copies for the Consultant's
own filing use.
M. Fees paid for securing approval of authorities having jurisdiction over the Project
will be paid by the Commission.
N. Upon signing this agreement, Consultant acknowledged that Section 362.5 of the
Iowa Code prohibits a City officer or employee from having an interest in a contract
with the City, and certifies that no employee or officer of the City, which includes
members of the City Council and City boards and commissions, has an interest,
either direct or indirect, in this agreement, that does not fall within the exceptions to
said statutory provision enumerated in Section 362.5.
O. The Consultant agrees at all times material to this Agreement to have and maintain
professional liability insurance covering the Consultant's liability for the
Consultant's negligent acts, errors and omissions to the Commission in the sum of
$1,000,000.
M
In consideration of the Construction Phase services, work, equipment, supplies, or materials
provided herein, the Commission agrees to pay the Consultant $61,300-00 NOT -TO -EXCEED
FEE (Unit Cost/Time Charges), including any authorized reimbursable expenses, pursuant to the
Schedule of Fees set forth in Attachment B, attached and incorporated herein.
Construction Phase Services $ 61,300.00
Total $ 61,300.00
V. MISCELLANEOUS
A. All provisions of the Agreement shall be reconciled in accordance with the
generally accepted standards of the Engineering Profession.
B. It is further agreed that there are no other considerations or monies contingent
upon or resulting from the execution of this Agreement, that it is the entire
Agreement, and that no other monies or considerations have been solicited.
wffsflml��l
Im=
"Title-,
FOR THE CONSULTANT
Foth Infrastructure and Environment, LLC
Signature,.,. ------------
Name" David D. K Pler I ........................ . ......... I., . .....
............ _ ................. I . ....... . ............... . ......... . . . ......... . . ............. .. I . .............. . .. . ........... I..., . . ............. I.,
Title. So Iro'ect IMan
Senior P�-cL 11 �,a �er
Date: Date:
Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 350 5045
RESOLUTION NO.
HEARINGSRESOLUTION SETTING PUBLIC SEPTEMBER
15,
2011, REGARDINGTO ENTER INTO GROUND LEASES
WHEREAS, the Commission has awarded a contract to construct Hangar L which will
contain hangars; and
WHEREAS, the Airport Operations Manager has negotiated leases for said hangars.
NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
IOWA CITY, IOWA, THAT:
1. The Iowa City Airport Commission does hereby declare its intent to enter into lease
agreements for Hangar L.
2. Public hearings on said proposed lease agreements should be and are hereby set for
September 15, 2011 at 6:00 p.m. in the Terminal Building, Iowa City Airport, 1801 S.
Riverside Drive, Iowa City, Iowa, or if said meeting is cancelled, at the next meeting of
the Airport Commission thereafter as posted by the City Clerk. The City Clerk is hereby
directed to cause Notice of Public Hearing for each hangar lease to be published as
provided by law.
Passed and approved this day of 2011.
Approved By:
CI to tR.PERSO.N
ATTEST:
SECRETARY City Atto ey's Office
It was moved by and seconded by the
Resolution be adopted, and upon roll call there were:
Ayes Nays Absent
Assouline
Crane
Gardinier
_Horan
Mascari
Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 350 5045
RESOLUTIONNO.
RESOLUTION APPROVING TASK ORDER NO. 7 WITA AECO01 FOR
CONSTRUCTION RELATED SERVICES RELATING TO THE RUNWAY 7-25
PARALLEL TAXIWAY GRADING AND DRAINAGE
WHEREAS, the Iowa City Airport Commission entered into a contract entitled "Professional
Services Agreement" with Earth Tech (n/k/a AECOM) on December 11, 2008 to provide
engineering services for Federal Airport Improvement Program Projects;
WHEREAS, Part I(A) of said agreement provides that the parties will enter into supplemental
task orders for each project;
WHEREAS, the Commission and AECOM have previously entered into Task Orders Nos, 1, 2,
3, 4, 5 and No. 6;
WHERAS, the Commission and AECOM now desire to enter into Task Order No. 7, a copy of
which is attached.
1. The Chairperson is authorized and the Secretary to attest to Task Order No. 7 following
advice of counsel®
Passed and approved this . ....................... . ..................... — day of
CHAIRPERSON
It was imoved by and seconded by
adopted, and upon iroIl call there were:
2011.
... ......... . .
City Attorney's Office
F.Al 6=2 I
the ResoLtion be
Crane
Gardinier
Horan
Mascari
AECOM
A 501 Sycamore Street
Suite 222
Waterloo, Iowa 50703
www.aecom.com
k:
GRADING AND DRAINAGE
IOWA CITY, IOWA
319 232 6531 tel
319 232 0271 fax
Project Description - See attachment and incorporated herein.
Scope of Services - See attachment and incorporated herein.
Compensation
A. Compensation for services for the Construction Phase shall be a cost plus fixed fee not -to -exceed
One Hundred Twenty -Eight Thousand Seven Hundred Dollars ($128,700.00). See attachment and
incorporated herein.
General Conditions
Except as specifically amended by this agreement, services shall be provided in accordance with the
Consultant Services Agreement for the Iowa City Municipal Airport between AECOM Technical Services,
Inc., and the Iowa City Airport Commission dated December 22, 2008.
APPROVED
kom 1; 1. k, r�-t I V.: .%• 111111 1 1 1•
By L
Joe A. Becker
Date Date Auaust22 2011
SCOPE OF SERVICES
FOR
RUNWAY 7/25 PARALLEL TAXIWAY
GRADING AND DRAINAGE
IOWA
MUNICIPAL ,lRy . ,
IOWA CITY, IOWA
FAA AIP 3-19-0047-20
X t 4, A
070 IN
11,116 NOW W,
phaseThe work to be performed by the Consultant shall encompass and include detailed work, services,
materials, equipment and supplies necessary to provide construction -phase services. The design
oid The c .
divided r i ti
Assianment of #., x;.w This task consists of assigning
engineer oproject r will be the principal liaison
assemblingbetween the Sponsor, Consultant and regulatory agencies.
Z Assemble Construction Documents, This task consists of assisting the Sponsor
in o . the Contractor and the
;
Sponsor.
3. Conference. This task consists of attending and conducting a
Pre -Construction
Contractor,pre-construction conference with representatives of the Sponsor,
Consultant,^ and affected utilities.
4. Construction SurveylgS. This task consists o; establishing horizontal
vertical control for the project. do " task it ^
Contractor «"
will be checked on a weekly basis prior to beginning work in the area staked, and
periodically for grade and alignment. The survey notes received from the
Contractor will be organized, checked and filed for reference during the project.
5. Shop Drawings and Submittals. This task consists of reviewing shop drawings
and other submittals as required of the Contractor by the contract documents for
conformance with the design concept of the project and compliance with the
information given in the contract documents.
6. Construction Observation Program. This task consists of preparation of
Construction Observation Program which will detail the measures and procedures
that are required to assure conformance with the approved plans and
specifications. This program will be developed in accordance with the FAA Central
Region AIP Sponsor Guide.
7. Construction Assistance. This task consists of answering design interpretation
questions from the Sponsor, Contractor, review staff and appropriate agencies.
8. Pay Applications and Reimbursement Forms. This task consists of preparing
and processing monthly applications for payment to the Contractor and forwarding
to the Sponsor for execution with recommendations for approval and payment.
This task also includes preparation of federal reimbursement forms for the
Sponsor.
9. Labor and Payroll Reports. This task consists of reviewing weekly labor and
payroll reports for compliance with Davis-Bacon Act, conducting on-site employee
interviews, and conducting E.E.O. site inspections. Original documents will be
submitted to the Sponsor at completion of project for storage.
10. Testing of Materials. This task consists of providing field testing and materials
testing in accordance with the Construction Inspection Program. A subconsultant
will provide quality assurance testing for establishing proctor values for the pipe
backfill and embankment materials.
11. Site Visits. This task consists of providing periodic site visits to the construction
site by design personnel at appropriate stages of construction to review the quality
of the work and to determine, in general, whether the work conforms with the
contract documents.
12. Change Orders. This task consists of coordinating with the Sponsor and
Contractor in preparing and processing contract change orders.
13. Construction Observation. This task consists of providing field observation
during construction to review the work of the Contractor to determine if the work is
proceeding in general accordance with the contract documents and that completed
work appears to conform to the contract documents. Also included in this task will
be the monitoring of DBE participation in the project. Staffing requirements may
be adjusted during the project in relation to the level of construction activity.
14. Weeklv Construction Meeliqqs. This task consists of meeting with the airport
staff, tenants, and the Contractor for weekly progress meetings throughout the
construction phase of the project. The meetings are 1discuss roj ti
operations, construction lY n upcoming construction
15. Non-[;omg)liance geporting. This task consists of reporting to the Sponsor any
work , r or does
contractand advising the Sponsor of any work thate
correctedor i;
1R Contractor Modifications. This task co of reviewing, evaluating and
making i;' io o the Sponsor on suggestions for modifications
have been made by the Contractor.
17. Projectfiles, This task consists of maintaining files for correspondence, „"f
of the job conferences,4 drawings and samplesubmissions,� do
original contract documents including addenda, change orders, field modifications,
additional drawingsissued subsequentexecutionof the contract,
clarifications and interpretations of the contract documents, progress reports and
other project -related documents.
18. Daily Elports. This task consists of the resident field representative keeping a
diary, log book or those times on d the job site;
weather conditions; data relative to questions of extras or deductions; list of visiting
officials and representatives of manufacturers, fabricators, suppliers and
distributors;decisions,
in general and specific observations
detailin more of observing test procedures.As
part of this task, weekly construction progress and inspection
prepared
*. Punch List. This task consists of conducting f. review of the project
completion and preparing a list of items (punch list) to be completed or corrected.
20. Final Review. This task consists of performing a field observation of the
completed project before a final application for payment is processed for the
Contractor.
21. - ,y assisting the -.. «.
ct Closeout. This task consists of
ct
completion and final closeout documentation from the Contractor for the FAA by
providing the r', If, 'K documentation as identified in the Central,aI Airports
Divisiony " Sponsor Guide dated Octobe
a. Sponsor Certification for Final Acceptance
b. Final Outlay Report — Standard Form SF -271
0. Final Project Cost Summary
d. Summary of DBE Utilization
e. Final o -Report
Brief Narrative
Accomplished
3)
Contract Time, including Explanation of Liquidated Damages (if
Required)
4)
Statement of Compliance with Contract Labor Provisions
5)
Administrative Costs
6)
Engineering Costs
7)
Force Account (If Any)
8)
Construction Costs
9)
Buy American Provisions
10)
Construction Material Testing and Acceptance
11)
Final Inspection Report/Record of Completion
12)
Contractor's Final Statement of Completion
13)
Project Photographs
f. As -Built Record Drawings
g. Sponsor Cover Letter
1)
Sponsor Amendment Request
2)
Statement of Compliance with Approved Plans and Specifications
3)
Eligibility of Claimed Costs
h. Record Drawings
i. SF -425 Financial Report
j. OMB
Audit A-133
22. Record Drawings. This task consists of providing the Sponsor with a copy of
"record drawings" of the construction plans for the project based on the
construction observation records of the review staff and Contractor showing those
changes made during construction considered significant. Two copies of the
"record drawings" in electronic and reproducible format will be provided to the
Sponsor. One electronic copy would be for the FAA. Electronic drawings shall be
in MicroStation V8 format. Task does not include updating of the Airport Layout
Plans.
23. Construction Administration. This task consists of construction administration
and coordination of the project. Interoffice meetings, general day-to-day
administrative responsibilities, and typing of interoffice memoranda and minutes of
meetings are included in this task.
L:\workMDMI NWGREE\PROF\ICTaskOrder7Runway7-25.doc
Attachment B
Iowa City Municipal Airport
Ruuiru ay '7-26 Par heli "iraali ay Grading & Drainage
FAA AIRS lPr sect INN. 3-19-0047.20
Construction IRelated Services
onsuuk int. Cost Summary
Project Professional
130
Staff Professional
2.22
CADD Operator
48
Senior Technician
700
Technician
40
Project Support
110
Direct Labor Total
1250
li. Payroll Burden and Overhead costs
Ill. Direct Project Expenses
category
Bruits
Mileage
3600
Per Diem
0
Lodging
Copier
2600
Plan Copier
400
CAPS
10
eodirneter
20
Nuclear [tensity Gua e
30
Miscellaneous
IV. AE d, IM Estimate Costs
V. Subcontract Expense
Terracon
VI.
Estimated Costs
VII.
Fixed Pee.
VIII,
Maximum Amount Payable
Rate/Unit
$®510
32.00
$03.00
0.0
$0.50
26.00
12.50
0,00
1; f
i
$38,939.00
160.00% $62.302.40
$8,000.00
$113,500.00
$15,200.00
$126,700.00
5*
0
0
,:3
CD
�3
0
'7
>
w3 r 3
C5 C:� Ca 0, ID C,
0
0
55 > > K
yc)
�z
^x7 Ll
C7
6 Ll T.
H
0 X
vii
Ea -
15,
-n
O
C,
C222
0 C:l Ci 41 can O
O Cl b r3 hJ C,
CL
C,
rr
Id
o
cgs
Id
ciS.roCJen
0
0
,:3
CD
�3
0
'7
REVE: 08.22.11 10:37:36 Method: 3
Page 1 of 21
Page: I
Iowa City General Ledger System
FY 2012 Revenue Reporting
For the period 07.01.1:, to 07.31.11
Estimated YTD Period
Account Revenue Revenue Revenue Remainder $
------------------------------------------------------------------- ...®R...a--- ------------ ------------ ---- ------- _-----
7600 Airport
INTEREST REVENUES
381100 Interest on Investments 600.00 23.47 23.47 576.53 33.91
Total INTEREST REVENUES
RENTS
382100 Land Rental
38220C Building/Room Rental
Total RENTS
ROYALTIES & COMMISS?ONS
384200 Vending Machine Comm
384900 Other Commissions
Tota! ROYALTIES & COMMISSIONS
TRANSFERS
TRANSFERS FROM GOVERNMENTAL ACTIVITIES
393120 General Levy
Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES
Total TRANSFERS
Total Airport
*** GRAND TOTAL ***
600.00
23.47
23.47
576.53
3.91
41968.00
1000.00
1006.00
40968.00
2.38
231842.00
1-7404.00
11404.00
214438,00
7.51
---------- ------------
273810.00
------
18404.00
----- ------------
18404.00
------
255406.00
6.72
83.00
83.00
20000.01
1580.10
1580.10
18419.90
7.90
20083.00
1580.10
1580.10
18502.90
7.87
100000.00
8333.33
8333.33
91666.67
8.33
----------- ------------
100000.00
------------
8333.33
-----
8333.33
------
91666,67
---__-
8.33
100000.00
8333.33
8333.33
91666.67
8.33
3944933.00
28340.90
28340.90
366152.10
7.18
394493.01
28340.90
28340.90
366152.10
7,18
SRPE: 08.22.11 10:37:11 Method: 1
Iowa City Generral. Ledger System
FY 2012 Expense Reporting
For the period 07.01.11 to 07.31.11
Page 2 of 21
Total REGULAR SALARIES & WAGES
OTHER WAGES
414500 Longevity Pay
Total OTHER WAGES
Total SALARIES & WAGES
EMPLOYER BENEFITS
GROUP INSURANCE
421100 Bealth Insurance
421200 Dental Insurance
421300 Life Insurance
421400 Disability Insurance
Total GROUP INSURANCE
SOCIAL SECURITY CONTRIBUTIONS
422100 FICA
Total SOCIAL SECURITY CONTRIBUTIONS
RETIREMENT CONTRIBUTIONS
423100 IPRRS
Total RETIREMENT CONTRIBUTIONS
Total EMPLOYER BENEFITS
36891.00
YTD
Period
32938.90
Account
Appropriated Expenditures
Expenditures Encumbrance
Balance 6 Used
7600 Airport
244.00
AIRPORT
244.00
37135.00
560100 Airport Operations
3952.10
33182.90
10.64
SALARIES & WAGES
329.82
329,82
3268.18
REGULAR SALARIES & WAGES
232.00
19.32
19.32
411000 Perm Full Time
1.00
79.00
1.00
412000 Perm Part Time
36370.00 3927.60
3927.60
32442,4C 10.80
413000 Temporary Employees
520.00 24.50
24.50
495.50 4.71
Total REGULAR SALARIES & WAGES
OTHER WAGES
414500 Longevity Pay
Total OTHER WAGES
Total SALARIES & WAGES
EMPLOYER BENEFITS
GROUP INSURANCE
421100 Bealth Insurance
421200 Dental Insurance
421300 Life Insurance
421400 Disability Insurance
Total GROUP INSURANCE
SOCIAL SECURITY CONTRIBUTIONS
422100 FICA
Total SOCIAL SECURITY CONTRIBUTIONS
RETIREMENT CONTRIBUTIONS
423100 IPRRS
Total RETIREMENT CONTRIBUTIONS
Total EMPLOYER BENEFITS
36891.00
3952,10
3952.10
32938.90
10.71
244.00
244.00
244.00
244.00
37135.00
3952.10
3952.10
33182.90
10.64
3598.00
329.82
329,82
3268.18
9.17
232.00
19.32
19.32
212,68
8.33
79.00
7.31
7.31
71.69
9.25
176.00
13,50
13.50
162.50
7.67
4085.00
369.95
369.95
3715.05
9.06
2841.00
293.45
293.45
2547.55
10.33
2841.00
293.45
293,45
2547.55
10,33
2997.00
318.93
318.93
2678.07
10.64
2997,00
318.93
318,93
2678.07
10.64
9923.00
982.33
98233
8940,67
9.90
Page 3 of 21
EXPE: 08.22.11 10:37:12 Method: 1 Page: 2
Icaa City General Ledger System
F`1 2012 Expense Reporting
For the period 07.01.11 to 07.31.11
YTD Period
Account Appropriated Expenditures Expenditures Encumbrance Balance p Used
7600 Airport ICON3I115ED)
AIRPORT (CONTINUED}
560100 Airport Operations (CONTINUED)
PROFESSIONAL & TECHNICAL SERVICES
OFFICIAW ADMINSTRATIVE SERVICES
431020 Court Costs & Services 78.00 78.00
Total OFFICIA11ADMINSTRATIVE SERVICES
PROFESSIONAL SERVICES
432020 Annual Audit
Total PROFESSIONAL SERVICES
DATA AND COMMUNICATION SERVICES
435056 Delivery Services
435057 Couriers
435060 Legal Publications
Total DATA AND CONNUNICATION SERVICES
TRAINING & EDUCATION
436030 Transportation
436050 Registration
436060 Lodging
436080 Meals
Total TRAINING i EDUCATION
INSURANCE
437+010 Comp Liability Insurance
437020 Fire & Casualty Insurapce
437030 Worker`s Come Insurance
437041 3ondinu & Other Insurance
437200 Loss Reserve Payment
Total INSURANCE
UTILITY SERVICES
438011.0 Stormwater Utility Charges
438030 Electricity
78.00 78,00
1202.00 1202.00
1262.00 1202.00
52.00
52.00
85.00
85.00
98.00
98.00
235.00
235.00
700.00 700.00
400.00 400.00
5003,00 5803.00
200.00 200.00
6303,00 6303.00
4148.00
3950.00
3950.00
198.00
95.23
12745.00
750.00
750.00
11995.010
5.88
36,00
36.00
90.00
901.00
5150.00
5150.00
------------------
22980.00
------------
4700.00
------------
4700.00
------------
18280,00
------
20,45
7104.00
789.11
789._1
6314.89
11.11
12903.00
1337.23
1337.23
11565.77
10.36
EXPE: 08.22.11 10:37:12 Method: 1 Pagee 3
Iowa City General Ledger System
FY 2012 Expense'Reporting
For the period 47.01.11 to 07.31.11
Total PROFESSIONAL & TECHNICAL SERVICES
REPAIR & MAINTENANCE
BUILDING REPAIR & MAINTENANCE SERVICES
442010 Other Building Repair & Maintena
442020 Structure Repair &Maintenance S
442030 Heating Equipment Repair & Maint
442040 Cooling Equipment Repair & Maint
442060 Electrical & Plumbing Repair & M
442070 Bldg Pest Control Services
Total BUILDING REPAIR & MAINTENANCE SERVICE
EQUIPMENT REPAIR & MAINTENANCE SERVICES
443050 Radio Equipment Repair & Mainten
443060 Telecom Equipment Repair & Maint
443080 Other Equipment Repair & Mainten
Total EQUIPMENT REPAIR & MAINTENANCE SERVIC
TECHNICAL SERVICES
445030 Nursery Service -Lawn and Plant C
445080 Snow and Ice Removal
445110 Testing Services
445140 Outside Printing
62627.00
7235.52
YTD
Period
11.55
12085.00
Account
Appropriated
Expenditures
Expenditures Encumbrance
Balance t
Used
7600 Airport (CONTINUED)
4625.01
7.50
1500.00
AIRPORT (CONTINUED)
1000.00
1000,00
560100 Airport Operations (CONTINUED)
1000.00
750.08
750,08
249.92
75.01
PROFESSIONAL & TECHNICAL SERVICES (CONTINUED)
419.00
21004.00
UTILITY SERVICES (CONTINUED)
1851.07
19152,93
8.81
283.00
1127.42
438070 Heating Fuel/Gas
6489.00
40.36
40.36
6448.64
.62
438080 Sewer Utility Charge
1654.00
119.18
119.18
1534.82
7.21
438090 Nater Utility Charge
1454,00
109.23
109.23
1344,77
7.51
438100 Refuse Collection Charges
1253,00
131.00
131.00
1122.00
10.45
438110 Local Phone Service
967.00
18540,00
907.00
438120 Long Distance Service
65.00
9.41
9.41
55.59
14.48
Total UTILITY SERVICES
31829.00
2535.52
2535.52
29293.48
7.97
Total PROFESSIONAL & TECHNICAL SERVICES
REPAIR & MAINTENANCE
BUILDING REPAIR & MAINTENANCE SERVICES
442010 Other Building Repair & Maintena
442020 Structure Repair &Maintenance S
442030 Heating Equipment Repair & Maint
442040 Cooling Equipment Repair & Maint
442060 Electrical & Plumbing Repair & M
442070 Bldg Pest Control Services
Total BUILDING REPAIR & MAINTENANCE SERVICE
EQUIPMENT REPAIR & MAINTENANCE SERVICES
443050 Radio Equipment Repair & Mainten
443060 Telecom Equipment Repair & Maint
443080 Other Equipment Repair & Mainten
Total EQUIPMENT REPAIR & MAINTENANCE SERVIC
TECHNICAL SERVICES
445030 Nursery Service -Lawn and Plant C
445080 Snow and Ice Removal
445110 Testing Services
445140 Outside Printing
62627.00
7235.52
7235.52
55391.48
11.55
12085.00
726.00
726.00
11359.00
6.01
5000.00
374.99
374.99
4625.01
7.50
1500.00
1500.00
1000.00
1000,00
1000.00
750.08
750,08
249.92
75.01
419.00
419.00
21004.00
1851.07
1851.07
19152,93
8.81
283.00
1127.42
1127.42
-844.42
398,38
454.00
454.00
5898.00
5898.00
6635.00
1127e42
1127.42
5507,58
16.99
37080,00
4500.00
4500.00
32580.00
12.14
18540.00
18540,00
850.00
850.00
127,00
127.00
EXPE: 08.22,11 10:37,12 Method: 1
Page 5 of 21
Page: 4
Iowa City General Ledger System
FY 2012 Expense Reporting
For the period 07,01.11 to 07.31.11
YTD Period
Account Appropriated Expenditures Expenditures Encumbrance Balance % Used
------_._-_@A_.___m---a_______------------------- ------------ __--- - __-- ------------ ___--__ __-
7600 Ain ort (CONTINUED)
AIRPORT {CONTINUED)
560100 Airport Operations (CONTINUED;
REPAIR & MAINTENANCE (CONTINUED)
TECHNICAL SERVICES ,CONTINUED)
Total TECHNICAL SRRVICES
INTRA -DEPARTMENT SERVICES
446100 City Attorney Char-geback
446132 ITS-PC/Peripheral Support Charge
446140 ITS -Computer Replacement Chargeb
446160 ITS-Network/Internet Chargeback
446200 Photocopying Chargeback
446220 Phone Service Chargeback
446300 Phone Equipmenz Line Chargeback
446320 Mail Chargeback
446350 City Vehicle Replacement Chargeb
446360 City Vehicle Rental Chargeback
446370 Fuel Chargeback
446380 Vehicle Repair & Maintenance Cha
446390 Auto Body Repair Chargeback
Total INTRA -DEPARTMENT SERVICES
I4I810ELLAHROUS SERVICES & CHARGES
449055 Permitting Fees
449060 Dues & Memberships
449120 Equipment Rental
449350 Meals iron -travel)
449360 Interest Expense
Total MISCELLANEOUS SERVICES & CHARGES
Total REPAIR & MAINTENANCE
- 56597.00 ®_..
4500.00
4500.00
52097.00
7.95
5233,00
5233.00
400.00
4C0.00
400,00
100.00
517.00
43.08
43.08
473.92
8.33
360.00
30.00
30,00
330.00
8.33
231.00
1.08
1.08
229.92
.47
692.00
93.31
93.31
598,69
13.48
1020.00
92.50
97.50
927.50
9.07
529.00
3.85
3,85
525,15
.73
14397.00
1353.72
1363.72
13033.28
9.47
500.00
500.00
3669.00
418.48
418.48
3250.52
11,41
15132.00
287.48
W-48
14844.52
1.90
224.00
224.00
42904.00
2733,50
2733.50
40170,50
6.37
65.00
65.00
675.00
675.00
754.00
425.00
425.00
329.00
56.37
39.46
38.46
-38,46
60060.00
4823.10
49233.10
5:236.90
8.03
61554.00
5266,56
5286.56
56267.44
8.59
188694.00
15498.55
15498.55
173195,45
8.21.
SIPE: x8.22.11 1x:37:17. Method: 1
on
Iowa City General Ledger System
FY 2012 Expense Reporting
For the period 07.01.11 to 07.31.11
YTD Period
Account Appropriated Expenditures Expenditures Encumbrance Balance Used
7600 Airport (CONTINUED)
AIRPORT (CONTINUED)
560100 Airport Operations (CONTINUED)
OTHER PURCHASED SERVICES (CHANGE TO OFFICE SU
GENERAL SUPPLIES
452010 Office Supplies 577.00 78.56 78.56 498.44 13.62
Total GENERAL SUPPLIES
BOOKS & PERIODICALS
454010 Reference Materials & Books
454020 Subscriptions
Total BOOKS & PERIODICALS
COMPUTER & PRINTING SUPPLIES
455120 disc Computer Hardware
Total COMPUTER & PRINTING SUPPLIES
Total OTHER PURCHASED SERVICES (CHANGE TO OFF
OPERATING SUPPLIES
AGRICULTURE SUPPLIES
461030 Plants & Trees
461040 Other Agriculture Chemicals
Total AGRICULTURE SUPPLIES
REPAIR & MAINTENANCE SUPPLIES
466030 Paint Supplies
466050 Electrical Supplies
466060 Other Construction Supplies
466070 Other Maintenance Supplies
Total REPAIR & MAINTENANCE SUPPLIES
SURFACING MATERIALS
468030 Asphalt
Total SURFACING 6iATERIALS
577.00 78.56 78.56 498.44 13,62
16.00
2099.00
2115.00
16,00
2099.00
2115.00
2600.00 2600.00
2600.00 2604.00
5292.00 78.56 78,56 5213.44 1.48
3000.00
1500.00
4500.00
3000.00
1500.00
4500.00
23.00 23.00
1066.00 1066.00
119.00 119.00
200.00 200.00
140$.00 146b.Ca
103.00 103.00
103,00 103.00
Page 7of21
E%P&: 08,22,11 101:37:12 Method-, 1 Page; 6
Iowa City General Ledger System
FY 2012 Expense Reporting
For the period 07.01.11 to 07,31.11
YTD Period
Account Appropriated Expenditures Expenditures Encumbrance Balance % Used
------------------------------------------------------ ------------ ------------ _- I --------- ------------ ------------ ------
N )
7600 Airport (,CONTINUED)
AIRPORT (CONTINUED)
560100 Airport Operations ,CONTINUED)
OPERATING SUPPLIES (CONTINUED)
OTHER SUPPLIES & EQUIPMENT
469040 Traffic Control Improvement Supp 138.00 138.00
469200 Tools 76,00 76.00
469260 Fire Ext & Refills 465.00 466.00
469320 Miscellaneous Supplies 552,00 552.00
Total OTHER SUPPLIES & EQUIPMENT
Total OPERATING SUPPLIES
IMPROVEMENTS OTHER THAN BUILDING
IMPROVEMENTS OTHER THAN BUILDING 'GREATER
4730101 Contracted Improvements
473020 Non -Contracted Improvements
Total IMPROVEMENTS OTHER THAN BUILDING
OTHER FINANCIAL USES
490150 Operating Subsidy
490190 Interfund Loan
?otal OTHER FINANCIAL USES
Total Airport Operations
Total Airport
1232.00 1232.00
7243,00 7243.00
20000.00
9000.00
20000.00
9000.00
29000,00 29000.00
11517.00
959.75
959.75
10557.25
8,33
45236.00
3656,82
3656.82
41579.18
8.08
56753.00
4616.57
4616.57
52136.43
8.13
------------ ------------
396667,00
396667,00
----
32363,63
-------------------
32363.63
------------ ------
354303.37
----
8.16
------------ ------------
396667,00
--
32363,63
--------- --->--------
32363.63
------------
364303.37
__----
8.15
RIPE: 08.22.11 10:37:12 Method: I
Page: 7
Iowa City General Ledger System
FY 2012 Expense Reporting
For the period 07,01,11 to 07.31.11
YTD Period
Account Appropriated Expenditures Expenditures Encumbrance Balance % Used
-----
7600 Airport (CONTINUED)
AIRPORT (CONTINUM)
560100 Airport Operations (CONTINUED)
OTHER FINANCIAL USES (CONTINUED)
GRAND TOTAL 396667.00 32363.63 32363,63 364303.37 0.16
TRID: 09,22.11 10:38:24 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07,31.11
Page 9 of 21
Pace: 1
Trans Date Trans Type Report# Source Description Debit Credit
----------- --------- -- .___-___ -------------------------------- -- ------------ --w_®___----
7600 Airport
560100 Airport Operations
412000 Perm Dart Time
07.01.11 Old Sys 110701010009
07.15.11 Old Sys 110713010005
07.29.1.1 Old Sys 110727010007
Total Perin Part Time
413000 Temporary Employees
07.01.11 Old Sys 110701010009
Total Temporary Employees
42:00 Health Insurance
07.22.11 Journal
Total Health Insurance
421200 Dental Insurance
07.22.11 Journal
503221jCIC
PAYROLL
RECAPIPAYROLL 01
1297.20
a03383\CIC
PAYROLL
RECAP�PAYROLL 15
1297.20
503543\CIC
PAYROLL
RECAP�PAYROLL 29
1333.20
Check:691528`MADISON NATIONAL LIFE
Total Disability
Insurance
3927,60
503221�CIC PAYROLL RECAP�PAYROLL 01 24.50
24.50
110802172316 009456 NL HEALTH INSURANC&iCIC HEALTH INS 329,82
------------ ------------
329.82
110802172316 009455 JUL MAL INSURANCE\CIC DENTAL INS 19.32
Total Dental Insurance 19.32
421300 Life Insurance
07.18.11 New Vouch 110719030008 06769411 Check:691524\MADISON NATIONAL LIFE
Total Life Insurance
421400 Disability
Insurance
07,18.11
New
Vouch
110719030008 06769512
Check:691528`MADISON NATIONAL LIFE
Total Disability
Insurance
422100 FICA
07.01,11
Old
Sys
110701010009
70i0599\,FICA\CITY CONTRIBUTION
07.15.11
Old
Sys
110713010005
7150599�FICA\CITY CONTRIBUTION
07,29.11
Old
Sys
110727010007
7290599\FICA`CITY CONTRIBUTION
Total FICA
7.31
7.31
13.50
13.50
96.67
94.79
101.99
293.43
TRID: 08.22.11 10:38:24 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
Trans Date
Trans Type
Report#
Source Description
7600 Airport (CONTINUED)
Check;692319\MIDAMERICAN
ENERGY%f
1024.14
560100 Airport Operations
(CONTINUED)
ENERGY\ELR
37.96
423100 MRS
Check:692319\MIDAMERICAN
ENERGY\ELE
161.22
07.01.11
Old Sys
110701010009
7010599\1PERS�CITY CONTRIBUTION
07.15.11
Old Sys
110713010005
7150599`IPERS\CITY CONTRIBUTION
07.29.11
Old Sys
110727010007
7290599,IPERS\CITY CONTRIBUTION
Total IPERS
437010 Comp Liability Insurance
07.14.11 New Vouch 110720030040 03304336 Check:691361\AW WELT AMBRISCO INSUR
Total Camp Liability Insurance
437020 Fire & Casualty Insurance
07.13.11 Nev Vouch 110714030016 06769089 Check:691343\PBTROLRUM MARRRTRRS MA
Total Fire & Casualty Insurance
438010 Stormwater Utility Charges
07.20.11 Journal 110802172316 009453 057-095-03�STORMWTRl7.20.11 Bill Da
Total Stormwater Utility Charges
438030 Electricity
07.27,11 New Vouch
07.27.11 New Vouch
07.27.11 New Vouch
07.27.11 New Vouch
Total Electricity
438070 Heating Fuel/Gas
07,27,11 New Vouch
07.27.11 New Vouch
07.29.11 New Vouch
Total Heating Fuel/Gas
Debit Credit
106.66
104.68
107.59
318.93
3950.00
3950.00
750.00
750.00
789.11
789.11
110728030137 06770181
Check;692316\MIDABERICAN
ENERGY`ELR
113.91
110728030137 067702.80
Check;692319\MIDAMERICAN
ENERGY%f
1024.14
110728030137 06770282
Check:692319\MIDAMERICAN
ENERGY\ELR
37.96
110728030137 06770284
Check:692319\MIDAMERICAN
ENERGY\ELE
161.22
1337,23
110728030137 06770281 Check:692319\MIDAMERICAN ENHRGY\GAS 12.59
110728030137 06770283 Check:692319`MIDAMERICAN ENERGY\GAS 11.30
110801030008 06770434 Check:692648`MIDAMERICAN ENERGY,GAS 16.47
40.36
TRID: 08.22.11 10:38:24 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
Page 11 of 21
Page: 3
Trans Date
Trans Type
Report#
Source
Description
Debit Credit
7600 Airport (CONTINUED)
560100 Airport Operations
(CONTINUED)
438080 Sewer Utility
Charge
07.20.11
Journal
110802172316
OC9453
057-115-00\SEWER\7.20,11 Bill Date
8.15
07,20.11
Journal
110802172316
009453
057-ll7-00\SEWER\7.20.11 Bill Date
20.12
07.20.11
Journal
110802172316
009453
057-118-03\SEWER\7.20.11 Bill Date
20.12
07.20.11
Journal
110802172316
009453
057-120-00\S8WHR\7.20.11 Bill Date
____________
70.79
______®_....---.
Total Sewer Utility
Charge
119.18
438090 Water Utility
Charge
07.20.11
Journal
110802172316
009453
057-095-G3\WATER\7,20,11 Bill Date
8.65
07.20.11
Journal
110802172316
009453
057-115-00`WATBRj7.20.11 Bill Date
16.47
07.20.11
Journal
110802172316
009453
057-117-00\WATER17.20,11 Bill Date
15.38
07.20.11
Journal
110802172316
009453
057-118-03\WATER\7.20.11 Bill Date
15.38
07.20.11
Journal
110802172316
009453
057-120-001WATRR`7.20,11 Bill Date
53.35
Total Water Utility
Charge
109.23
438100 Refuse Collection. Charges
07.19.11
New Vouch
110720030040
06769735
Cheek:691427\ABC DISPOSAL SYSTEMS I
34,00
07.19.11
New Vouch
110720030040
06769736
Check:691427\ABC DISPOSAL SYSTEMS 1
28.00
07.19.11
New Vouch
110720030040
06769737
Check:691427\ABC DISPOSAL SYSTEMS 1
69.00
Total Refuse Collection Charges
131.00
436120 Long Distance Service
07.01.11
Ph Lar. Dst
110801101545
000670119
JUL LONG DIST CHGBR
9.41
Total Lang Distance
service
9.41
442010 Other Building Repair &
Maintenance Ser
07.2).11
New Vouch
110721030158
06769902
Check:691503\JET AIR INC IOW`CLEANI
500.00
07.26.11
New Vouch
110727030012
0677G011
Check:692313\MARV'S GLASS SPECIALTI
226.00
Total Other Building Repair & Maintenance Servi
726.00
442020 Structure Repair & Maintenance Services
07.18.11
New Vouch
110719030006
06769614
Check:691576\T & R ROOFING & SHRBT
325.00
07,21,11
P -Card
11CB04103810
17800367
03C*07IS ELEVATOR CO\JONE NASBY
49.99
TRID: 08,22.11 10:38:24 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
Trans Date Trans Type Report# Source Description Debit Credit
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
442020 Structure Repair & Maintenance Services
Total Structure Repair & Maintenance Services
442060 Electrical & Plumbing Repair & Maintena
07.13.11 New Vouch 110714030016 06900774 Check:691168`ADFANCED ELECTRICAL SH
07.13.11 New Vouch 110714030016 06900805 Cheek:6912401LYNCE'S PLUMBING INC\O
Total Electrical & Plumbing Repair & Maintenanc
443050 Radio Equipment Repair & Maintenance Se
07.13.11 New Vouch 110714030016 06769077 Check,6912321JET AIR INC IOW\FUEL F
Total Radio Equipment Repair & Maintenance Sery
445030 Nursery Service -Lawn and Plant Care
07.20.11 New Vouch 110721030158 06769903 Check:691503\JBT AIR INC IOW\MAINT
Total Nursery Service -Lawn and Plant Care
446130 ITS-PC/Peripheral Support Chargeback
07.01.11 IT Support 110729162551 00007024 FY12 ITS ANNUAL CHGB
Total ITS-PC/Peripheral Support Chargeback
446140 ITS -Computer Replacement Chargeback
47.01.11 IT Repl 110706170021 00007025 JUL ITS REPL CHGBCk
Total ITS -Computer Replacement Chargeback
446160 ITS-Network/Internet Chargeback
07.01.11 IT Int/Nwk 110706153206 00007031 JUL ITS META/INTRNET
Total ITS-Network/Internet Chargeback
446200 Photocopying Chargeback
07.01.11 Copier Chg 110726115702 00700048 JUN PHOTOCOPY CHARGR
Total Photocopying Chargeback
374.99
200.58
549.50
750.08
1121.42
1127.42
4500.00
4500.00
400.00
400.00
43.08
43.08
30.00
34.00
l.oa
1.08
TRID: 08.22.11 10:38:24 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
Page 13 of 21
Page: 5
Trans Date Trans Type Report# Source Description Debit Credit
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
446220 Phone Service Chargeback
07.31.11 Qwest Chrg 110805103236 00007032 Jul Telecom Charges
Total Phone Service Chargeback
446300 Phone Equipment/Line Chargeback
07.01.11 Ph Egaipmt 110801101545 00007018 JUL PHON EQUIP CHGBk
Total Phone EquipmentfLine Chargeback
446320 Mail Chargeback
07.01.11 Mail 110706114159 00700054 JUN POSTAL CHARGES
Total Mail Chargeback
446350 City Vehicle Replacement Chargeback
07.31.11 EQ Repl 110803104915 00007006 JUL REPLACEMENT COST
Total City Vehicle Replacement Chargeback
446370 Fuel Chargeback
07.31.11 EQ Div 110803104915 00007708 JUL DIVISION FUEL
Total Fuel Chargeback
446380 Vehicle Repair & Maintenance Chargeback
07.31.11 EQ Dili 110803104915 00007008 JUL DIVISION SERVICE
Total Vehicle Repair & Maintenance Chargeback
449120 Equipment trental
07.19,11 New Vouch 110720030040 06769666 Check:6915911YOTTY'S INC�GOLF CART
Total Equipment Rental
449350 Meals (non -travel)
07.21.11 P -Card
Total Meals (non -travel)
93.31
93.31
92.50
92.50
3.85
3.85
1363.72
------------ -------
1163.72
418,48
418.48
287.48
287.48
425.00
------------ ____________
425.00
110804103810 17800551 ZIO JOHNOS SPAGHETTI H\MICHAEL THAR 38.46
... ..........
38.46
TRID: 08.22.11 10:38:24 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
on
Trans Date
Trans Type
Report#
Source
Description
Debit Credit
7600 Airport (CONTINUED)
UI Hangar Loan Princ\Jul
Interfund
1136.95
110802172316
009463
560100 Airport Operations
(CONTINUED)
727.54
110802172316
009463
SW T-Hngr Loan Princ�Jul
449360 Interest Expense
562.36
07.31.11
Journal
110802172316
009463
Corp Hangar Loan IntjJul Interfund
1770.03
07.31.11
Journal
110802172316
009463
UI Hangar Loan Int�Jul Interfund Lo
1254.57
07.31.11
Journal
110802172316
009463
SE T-Hngr Loan Int�Jul Interfund Lo
930.86
07.31.11
Journal
110802172316
009463
SW T-Hngr Loan Int�Jul Interfund Lo
867.64
Total Interest Expense
452010 Office Supplies
07.21.11 P -Card
Total Office Supplies
490150 Operating Subsidy
07.31.11 Journal
Total Operating Subsidy
490190 Interfund Loan
07.31.11 Journal
07.31.11 Journal
07.31.11 Journal
07.31.11 Journal
Total Interfund Loan
4823.10
110804103810 17800552 STAPLESCONTRACTCOMMBRC�MICHAEL THAR 78.56
78.56
110809133644 009488 Airport 101 BD Coord�Jul Budgeted 0 959.75
959.75
110802172316
009463
Corp Hangar Loan PrnjJul
Interfund
1229.97
110802172316
009463
UI Hangar Loan Princ\Jul
Interfund
1136.95
110802172316
009463
SE T-Hngr Loan Princ�Ju1
Interfupd
727.54
110802172316
009463
SW T-Hngr Loan Princ�Jul
Interfund
562.36
3656.82
Total Airport Operations 32363.63
TRID: 08.22.11 10:38:24 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2x12 Detail Reporting
For the period 07.01.11 to 07.31.11
Page 15 of 21
Page: 7
Trans Date Trans Type Report# Source Descriptio: Debit Credit
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
490190 Interfund Loan (CONT
___®_d_®____ ________u___
Total, Airport 32363.63
ID: D8'22.11 18:38/24 Method: 4
Iowa City General Ledger System
ExD9uditmrgo Detail
BY %V12 Detail Reporting
For the period 07.01.11 to 07.31.11
Trans Date Trans Type Report—#' Source Description Debit Credit
7608 Airport (CONTINUED)
960100 &i%pD%± Operations (CONTINUED)
490190 IotVzIuDd Loan (CONTINUED)
w*
GRAND TOTAL *+' ]2]63.63
============
TRID: OB,22.11 1,:38:31 Method: 4
Iowa City General Ledger System
Revenues Detail
FY 2012 Detail Reporting
For the Deriod 07.01.11 to 07.31.11
Page 17 of 21
Page: 1
Trans Date Trans Type Report# Source Description Debit Credit
7600 Airport
560100 Airport Operations
381100 Interest on TnVeStment6
07.31.11 Allocation 11080914281. Jul interest allocation: 23.47
Total Interest on Investments
------------
-------- --
23.47
—Total
382100 Land Rental
07.06.11
Misc Pymt
1107111635:.6
70-5\ARMRD FORCES RESERVE\AIRPORT L
350.00
07.14.11
Payment
110714091739
00019599
2-6%BELL LARRY & SANDRA\PAYMENT
300.00
07.29.11
Misc Pym"-
110802112416
70-11�ARMED FORCES RESERVEjAIRPORT
350.09
Total Land Rental
1000.00
382200.BuildirgjRoo:t
Rental
07.01,11
Payment
110701091523
00019565
2-6'AWERS ROBERT\JUL 11`vHANGAR #9
141,0111
07.01.11
Payment
110701091523
00019573
2-31DOW11ES GREGIJUL 11y 1.:7 P. #51
168,00
07.05.11
Payment
110705094028
00419514
2-14\DEMARIA JOSEPE\JUL 11lHANGAR
148.00
07.05.11
Payment
110705094028
00019566
2-6�OPERATOR PERFORMANCE LAB\JUL 11
4038.00
07.05.11
Payment
114705094028
00019566
2-6\0PERATOR PERFORMANCE LABIJUL 11
615.00
07.06.11
Payment
110706093756
00019516
1-26\SCHNELL T0�1�JUL 111HANGAR #62
174,00
07.06.11
Payment
110706093756
00019544
1-22'�AEROHAWKS\JUL 11\HANGAR #19
148,00
07,06,11
Payment
110706093756
00019569
1-25\ST&ARMAN'\JUL 11lHANGAR 447
168,00
07.36.11
Payment
110706093750
00019584
1-21\11UST GARY\JUL 111HANGAR #4
141.00
07.06.11
Payment
110706093756
00019584
1-21�LUST GARY;JUL 11\EANGAR #21
148,00
47,3?.11
Payment
110707092304
30019562
2-4\RCOF KEITH`JUL 11\HANGAR #42
168.00
07.x$.11
Payment
1107,08092?57
0001951.5
2-7\RANEY CHARLES�JUL 11'tiFnNGAR #1
141,00
07.48.11
Pavment
1107080092757
00019517
3-21BULLERS JONATHAN�11, 11\HANGAR
141,00
07,08,11
Payment
i10708P92757
00019524
3-1\B7LER 70HN\JUL 11;HANGAR #36
168.00
07.08,11
Payment
110708092757
00019524
3-1"BUTLER JOi?N�JL'L 11`,HANGAR #37
168.00
07,08.11
Payment
110708092757
00019614
2-61PCLASKI h'IGHAELAJUL 11'1EAIaGAR
148,00
0;.11,11
Payment
1'07110°5633
00019513
2-3�PITTON MIKE\JUL 11!HANGAR #26
148.00
07.11.11
Payment
110711495633
00019519
2-4�BULGARELLI DAVID\JUL I1\HANGAR
148.00
07.11.11
Payrent
110711095633
00019523
2-6\MASCARi RICK\'JUL 11\HANGAR #30
148.00
07,12.11
Payment
110712090715
00019533
1-26�NE lA PHYS THERPY ASSOC\JUL 11
396.00
07.12.11
Payment
110712090715
00019567
1-19�WIRCAERT RONALD\JUL 111,HANGAR
192.00
07,13.11
Paynent
110713090837
00019490
1-13\FIELD HOWARD\JUL 11\HANGAR 45
1n8,00
ZMEM
TRID: 08.22.11 10:38:31 Method: 4 Page: 2
Iowa City General Ledger System
Revenues Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
Trans Date Trans Type Report# Source Description Debit Credit
7600 Airport (CONTINUED)
560100 Airport Operations
(CONTINUED)
382200 Building/Room
Rental (CONTINUED)
07.13.11
Payment
110713090837
00019538
2-7\ZUBROD ROY\JUL 11\HANGAR #20
148.00
07.13.11
Payment
110713090837
00019547
2-13\GERR FR8D\JUL 11\HANGAR #16
148.00
07.15.11
Payment
110715090742
00019531
2-4\LACINA DAVE\JUL 11\HANGAR #57
198,00
07.15,11
Payment
110715115029
00019487
99-1\MILLBR RICHARD\JUL 11\HANGAR.
168.00
07.15.11
Payment
110715115029
00019501
89-4\HIKCKLEY HARRY\JUL 11\HANGAR
404.00
07,15.11
Payment
110715115029
00019501
89-4\HINCKLEY HARRY\JUL 11\HANGAR
141.00
07-15,11
Payment
110715115029
00019504
89-5\VOS JEREMY\JUL 11\HARNGAR #41
168.00
07.15.11
Payment
110715115029
00019529
89-6\PISHBAUGH JUSTIN\JUL 11\RANGA
174.00
07.15.11
Payment
110715115029
00019532
89-7\PATTSCHRL RICHARD\JUL 11\HAN
229.00
07.15.11
Payment
110715115029
00019534
89-8\ALLENDZR PATRICK\JUL 11\HARGA
168.00
07.15.11
Payment
110715115029
00019550
89-10\EDRONDS TERRY\JUL 11\HANGAR
4113.00
07.15.11
Payment
110715115029
00019559
89-13%VADRONS UP\JUL 11\HANGAR #5
168.00
07.15.11
Payment
110715115029
00019561
89-14\GURNETT DON\JUL 11\HANGAR #3
310.00
07.15.11
Payment
110715115029
00019570
89-15\SINGLETARY ROBERT\JUL 11\HAN
141.00
07.15.11
Payment
110715115029
00019580
89-17\SWANSON NAOMI\JUL 11\HANGER
141.00
07.15.11
Payment
110715115029
00019603
89-22\COHN GARY\JUL 11\RANGAR #22
148.00
07.15.11
Payment
110715115029
00019604
89-23\DOUGLAS BRIAN\JUL 11\HANGAR
141.00
07.15.11
Payment
110715115029
00019607
89-25\MHADE JAMES N\JUL 11\HANGAR
168.00
07.18,11
Payment
110718092032
00019305
2-6\FULL JERRY\JUR 11\HANGAR #45
204.00
07,18.11
Payment
110718092032
00019489
2-11\ODGAARD JACOB\JUL 11\HANGAR #
141.00
07.18.11
Payment
110718092032
00019503
2-13\RUYLE JOHN\JUL 11\HANGAR #33
358.00
07.18,11
Payment
110718092032
00019520
2-7\IOWAAERO\JUL 11\HANGAR #43
168.00
07.18.11
Payment
110718092032
00019536
2-5\CHALKLEY BEN\JUL 11\HANGAR f14
148.00
07.18.11
Payment
110718092032
00019563
2-19\JET AIR INC\JUL 11\BUILDINGS D
3926.00
07.18.11
Payment
110718092032
00019575
3-3\PLANAGAN JAMES\JUL 11\HANGAR #
168.00
07.18.11
Payment
110718092032
00019578
2-19\JET AIR\JUL 11\HANGAR #60
174.00
07.18.11
Payment
110718092032
00019578
2-19\JET AIR\JUL 11\HANGAR #59
174.00
07.18.11
Payment
110718092032
00019611
1-11\YELDER ROY\JUL 11\HARGAR #18
148.00
07.26.11
Payment
110726093852
00019609
1-31\RORR BRIAN\JUL 11\HANGAR #27
148,00
07.29.11
Payment
110729091707
00019861
1-13\BRUMLEY JAXES\AUG !I\HkNGAR #
148.00
Total Building/Room Rental 17404.00
TRID: 08.22.11 10:38:31 Method: 4
Iowa City General Ledger System
Revenues Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
Page 19 of 21
Page: 3
Trans Date Trans Type Report# Source Description Debit Credit
7600 Airport (CONTINUED)
560103 Airport Operations ;CONTINUED)
354900 Other Commissions
07.14.11 Misc Pymt 110714491744 2-12\WESTERN PETROLEUM COMPANY\GAS 1580.10
Total Other Commissions 1580.10
393120 General Levy
07.31.11 Journal 110809133644 009488 Ptax to Airport�Jul Budgeted Operat 8333.33
Total General Levy 8333.33
------_-.®- ------------
Total Airport Operations 28340.90
%RID: 08.22.11 10:0:31 Method/ 4
Iowa City General LedprDvDtem
Revenues Detail
FY 2012 Detail Reporting
For the period 07.01.11 to 07.31.11
Trans Date Trans Tvoa DeDvc # 8nnree Description Debit Credit
7600 Airport (CU0TI0OQD)
560100 Airport Operations (CONTINUED)
Total AirDort 3040.90
TRID: 08,22,11 10:38:31 Method: 4
Iowa City General hedger System
Revenues Detail
FY 2012 Detail Reporting
For rhe period 07.01,11 to 07,31.11.
Page 21 of 21
Page: 51
Trans Date Trans Type Report# Source Description Debit Credit
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
ttt GRAND TOTALS 29340.90