HomeMy WebLinkAbout01-19-2012 Airport CommissionIOWA CITY AIRPORT COMMISSION
MEETING AGENDA -REVISED
AIRPORT TERMINAL BUILDING
1801 S. RIVERSIDE DRIVE
IOWA CITY, IOWA
THURSDAY, JANUARY 19, 2012 - 6:00 P.M.
1. Determine Quorum
1 min*
2. Approval of Minutes from the following meetings:
5 min
December 15, 2011
3. Public Discussion - Items not on the agenda
5 min
4. Items for Discussion / Action:
a. Airport Commerce Park
5 min
b. Hangar L
15 min
i. Public Hearing
ii. Consider a resolution approving the plans and specifications for Phase 1
construction project.
c. Terminal Building Brick Repair
15 min
i. Public Hearing
ii. Consider a resolution approving the plans and
specification for the
Terminal Brick Rehabilitation project
d. FAA/IDOT Projects: AECOM / David Hughes
5 min
i. Obstruction Mitigation
ii. 7/25 Parallel Taxiway
e. Care Ambulance
10 min
i. Consider a resolution approving Commercial Business Agreement with
Care Ambulance
f. Airport "Operations"
15 min
i. Strategic Plan -Implementation
ii. Budget
iii. Management
1. FY2011 Annual Report
2. Airport Operations Specialist Position
a. Evaluation
g. FBO / Flight Training Reports
5 min
i. Jet Air / Air Care
ii. Iowa Flight Training
h. Subcommittee Report
2 min
i. Subcommittee Assignments
ii. For January — Infrastructure (Horan, Mascari, Tharp)
iii. For February — Budget (Chair, Secretary, Tharp)
i. Commission Members' Reports
2 min
j. Staff Report
2 m i n
5. Set next regular meeting for February 16, 2012 at 6:00 p.m.
6. Adjourn
*The times listed in the agenda are the anticipated duration of that particular agenda item. The
actual discussion may take more or less time than anticipated
Airport Commission
December 15, 2011
Page 1
MINUTES DRAFT
IOWA CITY AIRPORT COMMISSION
DECEMBER 15, 2011 — 6:00 P.M.
AIRPORT TERMINAL BUILDING
Members Present: Minnetta Gardinier, Howard Horan, Rick Mascari, Jose Assouline, Steve
Crane
Members Absent:
Staff Present: Sue Dulek, Michael Tharp
Others Present: Matt Wolford, Philip Wolford, Jeff Edberg, David Hughes, Tim Busch,
John Yeomans, Chuck McDonald, Daryl Smith, Eric Scott
RECOMMENDATIONS TO COUNCIL: Approve Amendment #2 to listing agreement with
Skogman Realty to extend the term of the listing agreement
CALL TO ORDER:
Chairperson Gardinier called the meeting to order at 6:02 P.M.
APPROVAL OF MEETING MINUTES: Mascari moved and Assouline seconded a motion
to approve the minutes from the November 17 meeting. Motion passed 5-0
PUBLIC DISCUSSION: None.
ITEMS FOR DISCUSSION/ACTION:
A. Airport Farming Operations — John Yeomans stated he had given Tharp a lease
agreement for the packet. Yeomans discussed the details of the lease agreement
Crane asked if the price was changing, Tharp noted that the base rent increased from
$25,000 to $31,000. Yeomans mentioned that the rates at Iowa City were similar to the
rates at the Cedar Rapids airport.
B. Airport Commerce Park — Edberg mentioned that the listing agreement was due to
expire and that he has signed the amendment to extend the agreement. Edberg stated
the purchase agreement for Lots 16 and 17 had been approved by City Council. Edberg
stated he had contacted the individual that made a previous offer on Lot 17 to discuss
moving to a different lot and that he was going to meet Monday with him. Edberg said
he would be suggesting Lot #12. Assouline asked about leasing the other lots and the
vetting process for lease offers. Edberg responded to his questions.
i. Consider a resolution approving amendment #2 to listing agreement with
Skogman Realty — Mascari moved and Horan seconded resolution # A11-27.
Motion passed 5-0.
C. Privately Constructed and Owned Corporate Hangar— Tharp stated that he and
Gardinier had been involved in some discussions with a group interested in building their
own hangar at the airport. Tharp noted the Airport Commission needed to set some
policy decisions regarding privately constructed facilities. Tharp noted that one of these
is a policy regarding self -fueling systems. Tharp stated that he had been researching
Airport Commission
December 15, 2011
Page 2
airports around the state. The pattern he saw was that if the airport had a full-time Fixed
Base Operator then generally the self -fueling operations were not allowed. If there was
not a full time FBO, then they were treated on a case -by -case basis. Tharp stated that
there was one underground storage tank on the field that was attached to a building
leased by the University of Iowa. Tharp commented that as the Airport Commission
considered whether to allow more of these systems, they need to focus on the liability
issues associated with the facilities. Tharp noted that today there are significantly more
regulations in play and having some controls over the handling would be critical. Tharp
noted that if the Airport Commission was to allow these self -fueling facilities they should
be above ground systems. Members discussed different options regarding the storage
tanks. Mascari asked about the possible location of the hangar. Tharp responded that
the best area available now is just east of the university hangar. Gardinier questioned
whether the Commission wanted to set the precedent of allowing these tanks or to
consider giving priority to supporting the FBO on the field. Horan asked Wolford about
how much fuel is in a typical delivery. Wolford responded to his experience with fueling.
Wolford mentioned that Jet Air would be willing to work with any potential group to
provide fuel services. Wolford mentioned Jet Air has a similar operation with the airline
operating out of the Burlington Airport. Members continued to discuss the options of
supporting the FBO versus self -fueling. Horan asked about development in the south
area regarding folks putting in facilities there. Tharp noted that there are plans in place
for service roads to serve the south area until a time that traffic might justify a second
facility on the field. Gardinier stated that she would not like to see self -fueling systems.
Mascari stated he agreed with Gardinier's position. Members agreed to a consensus not
to allow self -fueling systems. Tharp mentioned the other item of concern was
infrastructure to the area. Tharp noted that if there is a group that does lease ground
getting taxiway infrastructure to the area would be something that needed to be done.
The immediate apron area for any private hangar would be the responsibility of the
hangar owner and part of their construction costs. Tharp noted that in the immediate
future, they would be able to work within the Hangar L project to extend the taxiway to
the area. Crane asked about how much cost they'd be looking at. Tharp mentioned he
had asked Eric Scott to put some costs together and stated the estimate is about
$80,000 to build the taxiway out to the building. Mascari asked about road access to the
area. Tharp mentioned that initially the entrance point would be the common gate by the
maintenance shop. He mentioned that phase 2 of the Hangar L project does finish the
area with a parking area for direct access from the south. Gardinier restated she wanted
to express that the Commission would be happy to have these facilities at the airport.
D. Hangar L —
i. Consider a resolution setting public hearing for plans and specification for
Phase 1 construction — Tharp stated he had the plans and specifications in
hand. Crane moved and Assouline seconded resolution #A11-28. Motion
passed 5-0.
E. Terminal Building Brick Repair —
i. Consider a resolution setting public hearing for plans and specifications
for the Terminal Brick Rehabilitation Repair Project — Tharp stated he had
the plans and specifications in hand. Mascari moved and Crane seconded
resolution #A11-29. Motion passed 5-0.
F. FAA/IDOT Projects: AECOM —
i. Runway 7/25 & 12/30 — Hughes stated that they did finally get closure of the
grants for the previous work. Tharp noted they did get their final payment from
FAA.
Airport Commission
December 15, 2011
Page 3
ii. Obstruction Mitigation — Hughes stated they were working with Dulek and the
attorney for the Hargrave property to lower some light poles.
iii. 7/25 Parallel Taxiway — Hughes stated they have hit winter shutdown. He
stated the contractor needs to do some stabilization work to complete that
process. Horan asked about when the project would be restarted. Hughes
stated they'd be looking toward mid -March. Hughes stated the contractor has
about 50 working days expired out of the 80 days allowed in the contract.
a. Consider a resolution approving Task Order #8 with AECOM for
design and construction services for Airport Electrical and Lighting
Rehabilitation — Horan asked about what all was in the project. Tharp
responded that the project would consist of LED light replacements for
the entire airport's exterior lighting. Tharp noted that originally he had
been working with the Public Works department, but due to the work and
the knowledge AECOM has from previous electrical work, he wanted to
pull it back and ask them for assistance. Horan moved and Assouline
seconded resolution #A11-29. Motion approved 5-0.
b. Consider a resolution approving Task Order #9 with AECOM for
design services agreement for construction of Runway 7/25 parallel
taxiway paving and lighting — Mascari moved and Crane seconded
resolution #A11-30. Motion approved 5-0
G. 2011 Pavement Repairs
i. Consider a Resolution Accepting Work for concrete replacement by All
American Concrete - Hughes stated the repair work had been completed by All
American concrete. Mascari stated he liked the work. Mascari moved and
Horan seconded resolution #A11-31. Motion approved 5-0.
H. FY2013 FAA Airport Improvement Program Application — Hughes handed out the
summary sheets from the program application. Hughes stated the sheets go along with
the comments from the last meeting. Gardinier asked about the Master Plan section and
the process for it. Tharp noted this would be a large process for the 20-year plan, with
the last plan completed in 1996. Members discussed the application package items.
Horan stated they need to begin planning for the south development now. Hughes
stated that would also be a component of the master plan.
I. Airport "Operations": Tharp noted that there was some electrical repair work to still be
done.
i. Strategic Plan -Implementation — No discussion.
ii. Budget — Crane asked about the land rental account noting the revenue planned
and paid to date did not appear to be in line. Tharp noted that the bulk of the
account is the farm lease payment.
iii. Management —
a. FY2011 Annual Report — Tharp noted that he had placed a draft of the
report into the packet for review. He noted that with the budget schedule
set up they could approve the report with revisions in January. Gardinier
asked if Tharp would send the report electronically. Tharp noted he
would send the electronic file to everyone.
b. Consider a resolution approving contract amendment to Airport
Maintenance Agreement with Jet Air — Mascari asked what services
Jet Air provides to which Tharp responded. Tharp stated the desire to
extend the contract in two parts. Tharp noted that if the contract were not
renewed at the end of the year, the Airport would be scrambling to
provide for winter services in the middle of the season. Tharp noted that
Airport Commission
December 15, 2011
Page 4
the other reason was to clean up and clarify some of the language in the
contract to better outline the responsibilities of each party. Members
discussed the extension. Mascari noted that the monthly maintenance
generated by Jet Air should be completed by Tharp. Crane moved
resolution #A11-32 and seconded by Mascari. Motion carried 5-0.
c. Airport Operations Specialist Position
1. Evaluation Process - Tharp noted that he was due for evaluation
in February, and he put this on the agenda for the Commission to
have an opportunity to discuss the evaluation process. Gardinier
asked if Tharp would send the evaluation form to her, and she
would forward to members. [Shouldn't Mike forward this to
members and request that their input be forwarded to Minnetta?
then I would take their input and complete a review document.
Can I communicate this to all of the Commission?]
J. FBO / Flight Training Reports —
i. Jet Air / Air Care — Matt Wolford handed out the maintenance activity list.
Wolford noted the hangar door seals were completed [on how many hangars?
He mentioned that, and it's better than giving the impression that all hangar
doors were completed.] prior to Thanksgiving. Wolford noted they were waiting
for the tractor blade. Tharp noted he had talked with the equipment shop and
that it was due yet within the week. Mascari asked about how the purchases
work. Wolford noted they usually purchase via their business credit card and
then give receipts to Tharp. Tharp noted that Jet Air does have some purchasing
authority in the contract to allow them to purchase things on behalf of the airport.
Wolford stated that they were working on some international aircraft sales. Philip
Wolford stated they had sold 4 corporate jet aircraft recently. He stated that one
went to Germany, but the others stayed locally. Philip Wolford mentioned that a
number of previously frequent charter customers are looking at purchasing their
own aircraft. Philip Woolford brought up the declared distances on the runway
and how they impact the airport operations. Members discussed the runway
distances with Wolford. Horan asked about the changes in the computer
weather station. Tharp noted that the default website is set to the National
Weather Service aviation site. Mascari stated that when the weather service was
installed it was cutting edge, but now due to other technology, it wasn't as
popular. Tharp noted the subscription cost was $2100 per year.
ii. Iowa Flight Training Tharp noted that both instructors appeared to be flying a
lot. Gardinier noted they had two simulators online for use.
K. Subcommittee Reports Gardinier noted that no subcommittee was due to report. She
noted that the infrastructure committee was due to report in January.
L. Commission Members' Reports — Mascari thanked Dulek for her work on recent
correspondence.
M. Staff Report —Tharp noted that he had been in contact with the owner of Whirlybird
Helicopters and that they were interested in having an opportunity to discuss with the
Commission a return to operation.
Airport Commission
December 15, 2011
Page 5
SET NEXT REGULAR MEETING FOR: Members set the next meeting for January 19, 2012.
ADJOURN: Gardinier moved to adjourn. Meeting adjourned at 7:40pm
CHAIRPERSON DATE
Airport Commission
December 15, 2011
Page 6
Airport Commission
ATTENDANCE RECORD
2011
TERM
N
N
N
,
`�
�'
,;
W
N
�
CDO
NJ
\
NAME
EXP.
O
\
\
O
d7
N
d7
\
\
C\
Rick
03/01 /13
X
X
X
X
X
X
X
X
X/E
X
X
X
X
X
X
X
Mascari
Howard
03/01 /14
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
X
Horan
M i n netta
Gardinier
03/01 /15
X
X
X
X
X
X
X
O/E
X
X
X
X
X
X
X
X
Jose
03/02/12
X
X
X
X
O/E
O/E
X
X
X
X
X
X
X
X
O/E
X
Assouline
Steve Crane
03/02/14
O/E
X
X
X
X
O/E
X
X
X
X
X
X
O/E
X
O/E
X
Key:
X = Present
X/E = Present for Part of Meeting
O = Absent
O/E = Absent/Excused
NM = Not a Member at this time
Marketing Services Report
January 5, 2012
Skogman Realty
2530 Corridor Way, Suite #302
Coralville, Iowa 52241
Prepared by: Leff Edberg, CCIM, SIOR, green
Prepared for: Gardinier, Minnetta
Tharp, Michael Email: M.gardinier@gmail.com
Michael-Tharp@iowa-city.org
Property: Ruppert Road, Iowa City -MASTER FILE
Flyer: www.icrealestatetours.com/FlyerPDFs/RuppertRdLots.pdf
Virtual Tour:
Pro -Forma:
IPW: http://It9ruppertrd.skogman.com/
Iowa City MLS: 20110622 Cedar Rapids MLS: 1100686
12/30/2011: Advertised in PC Real Estate Guide.
12/16/2011: Advertised in PC Real Estate Guide.
12/2/2011: Advertised in PC Real Estate Guide.
11/25/2011: Advertised in PC Real Estate Guide.
11/18/2011: Signed Offer to Purchase Lot 16 & 17
11/11/2011: Advertised in PC Real Estate Guide.
10/28/2011: Advertised in Press Citizen Real Estate Guide.
10/26/2011: Advertised in 10/14 Press Citizen Real Estate Guide.
10/3/2011: Advertised in 9/30 Press Citizen Real Estate Guide.
9/30/2011: Jeff working with client on LOI for lot 16.
9/16/2011: Advertised in 9/16 Press Citizen Real Estate Guide.
9/15/2011: Submitted Lot information to prospective Buyer.
8/30/2011: Submitted for ad in 9/2/2011 Press Citizen Real Estate Guide.
8/19/2011: Advertised in Press Citizen Real Estate Guide.
8/8/2011: Listings advertised in 8/5/2011 Press Citizen Real Estate Guide.
7/29/2011: Submitted for ad in August Insights magazine.
7/26/2011: Call from Cedar Falls developer wanting the lot, site prep and grading done for free by the
City.
7/19/2011: Listings to be advertised in 7/22/2011 Press Citizen Real Estate Guide.
7/11/2011: Listings advertised in 7/8/2011 Press Citizen Real Estate Guide.
7/6/2011: Attend June Commission meeting
6/24/2011: Listings advertised in Press Citizen Real Estate Guide.
6/14/2011: met with a client regarding building on the airport lots.
6/10/2011: Lots advertised in Press Citizen Real Estate Guide.
6/1/2011: Lots advertised in Press Citizen Real Estate Guide.
5/9/2011: Updated MLS, flyer, commence with Leasing data
5/1/2011: These new marketing reports reflect showings, advertising and significant marketing events
for your listing. They will be sent monthly to help you stay in touch with the marketing progress we're
making. We have started these reports on 5-1-2011, so no activity prior to that date will be reflected,
but everythng after that date will be. Thank you for your assignment!
January 10, 2011
January 18, 2011
Airport lots.
January 19, 2011
on Airport History
Attend City Council meeting for approval of listing Agreement
Obtain sales comparables for lots from, appraiser. Review legal records for
Meet Howard Horan and Michael Tharp at airport conference room for briefing
January 20, 2011 Attend Airport Commission Meeting.
January 21, 2011 Meet Tom Marcus, Sue Dulek, Dale Henning, Wendy Ford, Howard Horan and
Michael Tharp at City Manager's conference room for progress meeting.
January 22, 2011 Install site signs.
January 23, 2011 Receive sign call on lot 17, 16. Make appointment to spec outbuilding for Dog
Care business.
January 29, 2011 Meet client and builder to plan a building on lot 17. Will meet again next week.
February 9, 2011 Met client, went over building plans. Will meet lender next week and prepare
purchase offer.
February 11, 2011 Submit information on lots to Insites Magazine.
February 17, 2011 Submit information to Press Citizen for Real Estate Guide Back Cover
February 17, 2011 Call client regarding next meeting with lender. Client had surgery.
February 17, 2011 Commission meeting.
February 22, 2011 Promote site to potential industrial client
March 4, 2011 New Real Estate Guide came out with ad on back cover
March 9, 2011 Offer lot to industrial client for warehouse operation.
March 10, 2011 Commission meeting.
March 11, 2011 New Real Estate Guide came out with ad on back cover.
March 15, 2011 Contacted party interested in lot 16, made an appointment to meet at their lender to
pursue the financing on a building and an offer on lot #16.
March 15, 2011 prepared and sent a new schedule for leasing rates to City and Commission.
March 18, 2011 New Real Estate Guide came out with ad on back cover
March 25, 2011 New Real Estate Guide came out with ad on back cover
March 31, 2011 New Real Estate Guide came out with ad on back cover
April 7, 2011 New Real Estate Guide came out with ad on back cover
April 14, 2011 New Real Estate Guide came out with ad on back cover
April 14, 2011 Commission meeting.
April 15, 2011 Contacted dog business and suggested a lease scenario. They said they would consider
it. I'll follow up.
April 21, 2011 New Real Estate Guide came out with ad on back cover
April 29, 2011 New Real Estate Guide came out with ad on back cover
Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City,1A 52246 (319)4
RESOLUTION NO.
RESOLUTION APPROVING PLANS, SPECIFICATIONS, FORM OF CONTRACT, AND
ESTIMATE ON COST FOR "TERMINAL BUILDING EXTERIOR ENVELOPE REPAIRS"
CONSTRUCTION PROJECT AT THE I WA CITY MUNICIPAL AIRPORT
WIIERE S, notice of public hearing on the plans specifications, form of contract and estimate of cost for
the above -named project was published as required by law, and the hearing thereon held.
NOW, THEREFORE, RE, BE IT RESOLVED BY THE IOWIOWA CITY AIRPORT C 11 MSSI N THAT:
T:
The plans, specifications, form of contract and estimate of cost for the above -named project
are hereby approved
2. The amount of bid security to accompany each bid for the construction of the above -named
project shall be in the amount of 1 Or o (ten percent) of bid payable to the Iowa City Airport
Commission
. The City Clerk is hereby authorized and directed to publish notice for the receipt of bids for
the construction of the alcove -named project in a newspaper published at least once weekly
and having a general circulation in the city.
. Bids for the above -named project aret be received by the City of Iowa City, Iona at the
Office of the City Clerk, at the City Mall, before 2:00pm on the 9hday of February, 2012, or
at a later date and/or time as determined by the Commission Chairperson or their designee,
and thereupon referred to the Airport Commission, for action upon said bids at its next
meeting, to be held at the Iona City Airport Terminal Building, 1801 S. Riverside Drive,
Iowa City, Iowa at 6:0 pm on the 1 th day of February 2012, or at a later date and/or time as
determined by the Commission Chairperson or designee, with notice of said later date and/or
time to be published as required by. lave, or if said rneetin is cancelled, at the next meeting of
the Airport Commission thereafter as posted by the pity Clerk.
Passed and approved this
CHAIRPERSON
ATTEST:
SECRETARY
day of
It was moved by and seconded b
adopted, and upon roll call there were:
Ayes
Nays
2012.
Approved By:
1; 1�� I - l 1
City ttorney's Office
Absent
the Resolution on be
soul ine
Crane
Garrdinfer
Horan
Mars ari
Prepared by: Michael Tharp, Operations specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319)0 5045
RESOLUTION INTO.
RESOLUTION APPROVING PLANS, SPECIFICATIONS, FORM OF CONTRACT, AND
ESTIMATE N COST FOR 'HANGAR L PHASE 1" CONSTRUCTION PROJECT AT THE
I WA CITY M[UNICIPAL AIRPORT
T
WHEREAS, notice of public hearing on the plans specifications, form of contract and estimate of cost for
the above -named project was published as required by law, and the hearing thereon held.
NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION THAT:
1. The plans, specifications, form of contract and estimate of cost for the above -named project
are hereby approved
. The amount of bid security to accompany each bid for the construction of the above -named
project shall be in the amount of 1 % (ten percent) ofbid payable to the Iowa City Airport
Commission
The City Cleric is hereby authorized and directed to publish notice for the receipt of bids for
the construction of the above -named project in a newspaper published at least once weeny
and having a general circulation in the city.
4. Bids for the above -named project are to b received b the City of Iowa Cite, Iowa at the
Office of the City Clerk, at the City Hall, before 2:00 pm on March 6, 2012, or at a later date
and/or time as determined by the Commission Chairperson or their designee, and thereupon
referred to the Airport Commission, for action upon said bids at its next meeting, to be held at
the Iowa City Airport Terminal. Building, 18 01 S. Riverside Drive, , Iowa Cit y, Iowa at
6:00pm on the t th day of March 2012, or at a later date and/or time as determined by the
Commission Chairperson- or designee, with notice of said later date and/or time to be
published as required by law, or if said meeting is cancelled, at the next meeting of the
Airport Commission thereafter as posted by the City Clerk.
Passed and approved this day of 2012.
Approved By:
CHAIRPERSON
5W
ATTEST:
SECRETARY City Attorney's Office
It was moored by and seconded b
adopted, and upon roll call there were:
the Resolution be
Ayes Nays Absent
Assouline
Crane
Gardinier
Horan
Ma oari
0
CO
W
Lf)
LO
cz
0
O
O
Q
^
O
�
�
H
cz
O
O
O
w
O
O
O
L
O
-5q
�
O
M
�
Q)
s3
O
Q,
U
cz
a
O a1
O O 0o
N
o0
U)
O a1 N
N oo N
7t
r-
O N 0000
7t N
O
110
vF
bi)
Oc
LL
59 bMF} N
t O
a_
bF3
bF3 N
bF3
bF3
U
Q
a
kn CD o �n
CD CD 7
o �n �n O O CD
o� �n o o CD7t
o N
0000
CD�
�n
o 0
a1 �1 V 1 bF3
oq � bF3
O 01
l� M 59 M .-� 00
69 69 bF3 � .-�
0 0
�1 �n
� �
�
00
3
b�}
bqCIO
O
bF3
bF3 M
b�}
N
^
U
s3
�O
a
t6
X
t6
H
a)
15
(6 �
icn
.. Ln c6
Q U a)
L
(6 (� ❑
a)
.�
a) E
a)cn
N
N
cn
N
U O �
J m U >+
> O
N N M O O
ca N O a)
E *k U) O
U O X
.-. N >E N v��'
'^,
N
A' N
_ U d)
W � jR W
L
p /� >
`V
L
Q O O p
NQ)
cu
VLCN
M
t
X
m
U
`-' E�_0 t6
U
U U J Q O p>�
W
O N
O p cu a)
a) O U m Cl)a)
CA
a
LO
w
AW �� M 0) a O
O
c L) L) L)
LL 0 d) m. L C L
`- Y~
O W
AN
U 1_
L L L O O
> a_ a_
a N
U W
��,
�. co
En
w a_ U U-
a, c� a)
m m m w wLp-
a> a a
O O O O O O O
> 0 O—� t6 L H
-::i 0 cn LL a -J U Y c1
O O O O O O O O O
� .� +- o
Q U G H
O :3
U
cn
N N N N N N N
N N N N N N N N N
0\O 00 M M kn kn O
�--
a
� �
o
78
� U
U
O
0
0
o1n2/2o12
Page 1 of 23
DEVE: 0I.12.12 l]:43�3] Method: J
Iowa City General Ledger System
FY 2012 Revenue Reporting
For the period 12'0I.11 to 12.3I.11
Estimated YTD Period
Account Dmreun8 Revenue Revenue Remainder 11
----'---------------------- --------------------------------- ------------ ------------ --- ------ ------------ ---
76O0 Airport
OTHER MI3C REVENUE
369100 Deinb of Expenses 75.00 -75.00
�teI OTHER MZ8C REVENUE
IN7ER8OT REVENUES
381I00 Interest on Investments
Total INTEREST REVENUES
RENTS
382I00 Land Rental
382200 Building/Room Rental
Total RENTS
ROYALTIES G COMMISSIONS
384300 Vending Machine Comm
384900 Other Commissions
Total ROYALTIES & COMMISSIONS
TRANSFERS
IR&NQF8RS FROM GOVERNMENTAL ACTIVITIES
30120 General Levy
Total TRANSFERS FROM GOVERNMENTAL ACTIVITIES
Total TRANSFERS
lotal Airport
*** GRAND TOTAL **t
------------ ------------
------------
75.00
------------
'75.00
___
6OO.00
53I.69
5.26
68.31
88.62
------------ ------------
600.00
------------
53I.69
------------
9.26
68.32
___
88.62
41968.00
11650.O?
8400.07
30317.93
27.76
231842.00
117984.00
18545.00
113848.00
50.89
------------ ------
%7010.O0
----- --_
I29644.07
26945.07
144165.93
47.35
83.00
61.20
7.20
21.80
73.73
20000.00
14539.30
153}.]0
5468.70
72.70
------------ ------------
20083.00
-----------
14600.50
------------
1540.50
5482.50
___
72.70
100000.00
49999.98
033.33
50000.02
50.00
------------ ------------
100000.00
------------
49999.98
------------
8]3].32
50000.02
___
50.00
------------ ------------
100000.00
------------
49999.90
------------
8333.33
50000.02
___
50.00
------------ ------------
394493.00
------------
194851.24
------------
36824.16
199641.76
___
49.39
------------ ------------
]94403.UU
------------
194851.24
------------
36824.16
199641.76
---
49.39
01 /12/2012
Page 2 of 23
E PE : 01,1 .1 13 : 2 : 31 Method: 1
Iowa city General Ledger System
FY 2012 Expense Reporting
For the period. 1 .01.11 to 1 .31-11
Page: I
YTD
Period
Account
Appropriated
Expenditures
Expenditures Encumbrance
Balance
Used
---------------------------------------------
7600 Airport
____________
------------
------------ ---- _------- ------------
------
AIRPORT
560100 Airport Operations
SALARIES & WAGES
REGULAR SALARIES & WAGES
411000 Perm Full. Tlme
1.00
1.00
412000 Perm Part Time
36370.00
183 4.80
3945,60
17975.20
50.5
.3000 Temporary Employees
520.00
287.00
91.00
233.00
55,19
Total REGULAR SALARIES & WAGES
------ w-_
36891.00
------------
1868130 0
------------ ------------ ------------
4036,60
18209,20
------
50,64
OTHER WAGES
414500 Longevity Fay
244.00
3.75
.25
99.90
Total OTHER WAGES
244.00
243.75
.25
99,,90
Total SALARIES & WAGES
------------
37135,00
------------
15 5.55
------------ ------------ ------------
4036.60
18209,45
------
5 .9
EMPLOYEE BENEFITS
GROUP/ INSURANCE
gINSU�
"�
42110 Health Insurance
/�
5 8.
} V} {� f�
1978,92
9 I V r J 2
+� l� $�
32 w 8
¢ �!
161 s 09
1619.09
55.00
421200 Dental Insurance
232.00
115.92
19,32
116.V18
49,97
421300 Life Insurance
79.00
44.96
7.53
34.04
, 1
421400 Disability Insurance
1076.00
81.90
13.68
94,10
4 ,53
Total GROUP INSURANCE
4085.00
2221.70
370.35
1863.30
4.3
SOCIA"1 SECURITY CONTRIBUTIONS
d.2 Z,10 FICA
/�
2 1 s 00
✓� ft �{
13 J ♦ 3✓
P� $j f }
2 j r V J
1• s 6
j{ �j
4J x 8
Total SOCIAL SECURITY CONTRIBUTIONS
2841.00
1394.39
99.5
1446,61
------
49,08
RETIREMENT CONTRIBUTIONS
423100 IBERS
2997.00
1527,3.
325.76
1469.69
50.96
Total RETIREMENT CONTRIBUTIONS
2997.00
1527.31
325.76
1469.69
50-96
•. of a l EMPLOYEE BENEFITS
------------
9 L . Il V
------------
5144
1s 1T
------------ ------------ ------------
996,00
4779.60
--
51,83 A
01 /12/2012
Page 3 of 23
EXPE: 01,12.12 13:42:31 Method. I
�A,
Iowa City General Ledger System
EY 212 Expense Reporting
For the period 12. 1.1.1 to 12.31.11
YTD Period.
Account Appropriated Expenditures Expenditures Encumbrance Balance W Used
---------------------------------------------- ..-------- ------------ -------- ------ ----------- ------------ ______
760c A .rport. (CONTINUED)
AIRPORT (CONTINUED)
560100 Airport Operations {CONTINUED}
PRCEESSIONAL & TECHNICAL SERVICES
OFFICIAL/ADIINSTRATIVE SERVICES
431020 Court Costs & Services 78.00 78.00
Total OFFICIAbfADMINSTRATIVB SBRVICBS
PR4FBSSIONAi, SERVICES
432020 Annual Audit
Total PROFESSIONAL SERVICES
DATA AND COMMUNICATION SERVICES
435056 Delivery Services
435057 Couriers
4350�O Legal publications
Total DATA AND COMMUNICATION SERVICES
TRAINING & EDUCATION
436030 Transportation
436050 Registration
436060 Lodging
436070 Miscellaneous Travel Expense
43 080 Beals
Total TRAINING & EDUCATION
INSURANCE
437010 Cop Liability Insurance
437020 Fire & Casualty Insurance
437030 Worker's Comp Insurance
437041 3ondirg & Other Insurance
437240 Loss Reserve Payment
Total INSURANCE
------
78.00 78.0
1202.00 1202,00
------
1202.00 1202,00
52.00
52.00
85.00
85.00
98.00
13.78 13.78
84.22
14.
------------------------
2 5. 0
----- W------ -----------
13.78 13.78
-----------..
221.22
5.8
700.00
122.10
577,90
17.44
400.00
225.00
175,00
56.25
5D0,010
231.62
268.38
46.32
3.00
-30-00
200.00
200.00
1800,00
608.72
1191.28
------
33.82
4148.00
3950.00
198,00
✓ 5.23
12745.00
jJ�
7153.00
5592.00
56.12
36.00
45.00
- .00
125.00
5150.00
5150.00
100.00
22W.00
16298.00
6682.00
------
70,92
01 /12/2012
Page 4 of 23
tXPE! 01J2,12 1.1:4 ;31 Method: 1
Iona City General Ledger System
1Y 2012 Expense Reporting
For the Deriod 1. ,,1.11. to 1 .31,11
Page: 3
YTD
Period
Account
Appropriated
Expenditures
Expenditures Encumbrance
Balance
I Used
..--.-.---------rr .3.t [jatr�,s �r swwawi--.,. .n--.--.�. .--..-------.. sew ewe �r �r. rew w.. .s .. �
76 Airport $CONTINUED)
.,,.. .»�. �. ». �..... »,. �.... «»-.
gar .v .rrr.rrw. rc ur-
----------«------w--..w. r,r rrr-
w---- �---
-- _.---
AIRPORT CONTINUED
5 100 Airport Operations CONTINUED
PROFESSIONAL i TECHNICAL SERVICES (CONTINUED)
UTILITY SERVICES
438010 termwater Utility Charges
7104.00
4734.66
789.11
2369.34
66.65
438930 Electricity
12903.00
7352.42
1246,35
555O,5B
56.98
A638070 Heating Fuel/Gas
6489.00
1112.97
654.40
5376.03
w7.15
438 Sewer Utility Charge
1654.0
546,71
94,64
11. 7.2
3 . 5
438090 Water Utility Charge
1454-00
547.78
89,10
906,22
37: 7
43 110Refuse Collection Charges
1253.00
616.00
97.00
637,00
49.1E
43 110 Local Phone Service
907.00
907.00
438120 Long Distance Service
65.00
31..14
3.57
33.8E
47.1.
Total UTILITY SERVICES
31829.00
14941.68
2974.87
16887.32
46.94
Total PROFESSIONAL & TECRNICAL SERVICES
REPAIR & MAINTENANCE
BUILDING REPAIR & MAINTENANCE SERVICES
442010 Other Building Repair & Ra ntena
442020 Structure Repair & Maintenance
442030 Eeatinq Equipment Repair & Maint
442040 Cooling Equipment Repair & Ma nt
442060 Electrical & Plumbing Repair & M
442070 Bldg Pest Control Services
Total BUILDING REPAIR & MAINTENANCE SERVICE
EQUIPMENT REPAIR & MAINTENANCE SERVICES
443050 Radio Equipment Repair & Ma nten
443060 Telecom Equipment Repair & Ma nt
443080 Other Equipment Repai.i. & 14ainten
Total EQUIPMENT REPAIR & MAINTENANCE SERVIC
TECHNICAL SERVICES
445030 Nursery Service -Lawn and Plant C
445080 SnGw and Ice Removal
59124.00
31862.18
2988. C5
26261.
54s 8 2"'
12085.00
5442.24
848.75
6C42.76
45.03
5 "00
2135,44
795-00
2864.5E
4 2 .71
150 '00
366,00
366.00
1134.00
24.40
1000.00
1.3. 2
1 -
1.33
1000.00
3 .13
907.65
-1 32,13
223.21
419.00
03.7
33.95
215.30
48,62
210 4.00
11192.83
951 � 35
9811.17
53.29
283yi 0
1127.42
- 44i4
3 .3
454.00
5 . 0
454.00
,5 4} .
�� jd}�
5V Ys00
58.12
j0
�
5 39.0
j�
1.00
6635,00
1.186.34
5448.6E
---
17.88
18540.00 4500.00 4500.00
14040.00 24.27
01 /12/2012
Page 5 of 23
EXPE: 01.12.12 13;4 :31 e.hod: 1
Iowa. City General Ledger System
FY 2012 Expense Reporting
F'or the period 12.01.11 to 1 .31,11
Page: 4
YTD
Period
Account
Appropriated
Expenditures
Expenditures Encumbrance
Balance
'I Used
7 Airport CONTINUED
--
AIRPORT (CONTINUED)
56 100 Airport Operations (CONTINUED),
REPAIR & MAINTENANCE (CONTINUED)
TECHNICAL SERVICES (CONTINUED)
445110 Testing Services
E50,00
125.00
725.00
14.71
445140 outside Printing
17.w
127.00
Total TECHNICAL SERVICES
------------
56597.00
------------
7125.00
------------ ------------ ------------
4500.00
29472,00
------
1,93
INTRA-DEPARTMENT SERVICES
446100 City Attorney Chargeback
5233.00
3007.37
884.52
2225.63
57,47
44613 ITS-PC/Peripheral Support Charge
400.00
400.00
1 - 0
44 140 ITS -Computer Replacement Chargeb
517.00
341.,84
101.42
175.16
66.12
ITS-Application446150
446160 ITS-Network/Internet Chargeback
360.00
210,00
60.00
150.00
58J3
44 6200 Photocopying Chargeback
231.00
102.96
24.00
128.04
44.57
446220 Phone Service Chargeback
692.00
444.51
247,49
64,24
4463CO Phone Equipment/Line Chargeback
1020.00
555,
2.50
4654 0
54.41
446320 Mail Chargeback
52 i C
ik 1 •29
1{ 4747
1 Y 7
39.75
446350 City Vehicle Replacement Chargeb
14397,00
.32
1363,72
6190.68
5 M
446360 City vehicle Rental Chargeback
500.00
308.21
191,79
61,64
44 370 Fuel Chargeback
3669.00
1361.1E
240.01
2307.82
37.1
44 380 Vehicle Repair & Maintenance Cha
15132,00
10718,21
1049.58
44.13,79
70,83
4464190 Auto Body Repair Chargeback
224.00
224.00
Total 1NTRA-DEPARTMENT SERVICES
------------
42904,00
------------
26760.41
------------ ____________ ------------
3863,22
16143,59
------
62,37
MISCELLANEOUS SERVICES & CHARGES
449055 Permitting Fees
65,00
65,00
449060 Dues & Memberships
675.00
525.00
275.00
150.00
77,78
449120 Equipment Rental
754.00
446,00
308,00
59,15
449353 Meals (non -travel)
38.46
-38.46
449360 Interest Expense
60060.00
28938.60
4823,10
31121,40
48,1
{{ ((j`�'
Total REPAIR & MAINTENANCE
- - - - r - - /�`W r _ W -
886 4. 00
r w - .. - - .- r - ..
96212.64
- - - - r - - r - - - - w - - - - «... w - - -
16412,67
�'- w - - - - - -
- - n 92481.36
9 481. 36
------
50,99
01 /12/2012
Page 6 of 23
XPE= 01,12,12 13:4 :31 Method: 1
Iowa City General Ledger System
FY 2012 Expense Reporting
For the period 1 .0 .f11 to 1 .31.I
'TE
Period
Account
Appropriated
Expenditures
Expenditures Encumbrance
Balance
I Used
60 i Airport (CONTINUED)
AIRPORT (CONTINUED
560100 Airport Operations (CONTINUED)
OTHER PURCHASED SERVICES (CHANGE TO OFFICE SU
GENERAL SUPPLIES
45 010 Office Supplies
577.00
418.65
221.61
15 .35
72,56
45 030 Minor Office Equipment/Furniture
29.98
129.98
-1 9.9
Total GENERAL SUBDUE
- - - r - - r r - - - -
577.00
w w - - - - r -- - w
548.
- w - - r - r.- - - - - r - - - - - r
351.59
w - - : - - - -- - -
V.
------
95,0}
BOOKS & PERIODICALS
454010 Deference Materials & Books
16.00
16.00
454020 Subscriptions
2099.00
546,00
1553.00
26,01
`otal BOOKS & PERIODICALS2115.00
546.00
1569.00
25.82
COMPUTER & PRINTING SUPPLIES
455120 Mise Computer Hardware
2600.00
1138.99
398.99
1461. 01
43.81
To al COMPUTER & PRINTING SUPPLIES
2600.00
1138.99
398.99
1461.01
43.81
Total OTHER PURCEAM SERVICES �CEANGE TO OFF
5292.00
2233.62
750.58
3058.38
42.21
OPERATING SUPPLIES
AGRICULTURE SUPPLIES
461030 Plants & Trees
3000.00
3000.00
461040 Other Agriculture Chemicals
1500.00
1500.00
Taal AGRICULTURE SUPPLIES
4500,00
4500.00
REPAID. & MAIRTENANCE SUPPLIES
466030 Paint Supplies
23.00
23,00
466040 Plumbing Supplies
19.04
-1- .04
466050 Electrical Supplies
1066.00
607.62
458.38
57.00
466060 Other Construction supplies
119.00
119.00
466070 Other Maintenance Supplies
200.00
314.95
-114.95
157.48
Total REPAIR & MAINTENANCE SUPPLIES
140E.00
941.61
466,39
66,8
01 /12/2012
Page 7 of 23
lowta City General Ledger System
FY 2012 Expense Reporting
For the Period 12.01.1. to 12.31.11
Pages
1.
YTD Period
ACCOUnt Appropriated Expenditures Expenditures Encumbrance Balance I Used
------
16
00 A r rt(CONTINUED)
AIRPORT (CONTINUED)
560100 Airport Operations (CONTINUED)
OPERATING SUPPLIES (CONTINUED)
SURFACING MATERIALS
46 030 Asphalt 103.00 103.00
468050 Sand 26.55 26.55 - 6.55
Total SURFACING MATERIALS
OTHER SUPPLIES & EQUIPMENT
49040 Traffic Control Improvement Eupp
49190 141nor Equipment
46900 Took
490 Fire Ext & Refills
469320 Miscellaneous Supplies
Total OTHER SUPPLIES & EQUIPMENT
Total OPERATING SUPPLIES
IMPROVEMENTS OTHER THAN BUILDING
IMPROVEMENTS OTHER THAN BUILDING (GREATER
473010 Contracted Improvements
473020 Non -Contracted Improvements
Total IMPROVEMENTS OTHER THAN BUILDING
EQUIPMENT & FURNITURE
ER C3LAR EQUIPMENT (GREATER THAN $1,000)
47440 Tractors
Total VEHICULAR EQUIPMENT (GREATER THAN $1,
IT HARDWARE SOFTWARE (GREATER THAN $1,000
476070 PC Hardware
Total IT HARDWARE/SOFTWARE (GREATER THAN $1
Total EQUIPMENT & FURNITURE
------------ ------------
.03.00
------------
26.55
------------
26.55
------------
76.45
------
2537E
138,00
138.00
324.00
-3 4.00
76.00
581.17
3.50
-505.17
764.70
466,00
655,55
-1.9.55140,E
552.00
170.40
58.95
351. 0
30. E
1232.00
1731,12
62.45
-499.1
140.51
243.00
2699.28
► 9, 00
4543.72
37.2
0000.00
17100.00
17100.00
2900.00
85.50
9000.00
2822.00
617,00
31.3
9000.00
1.99 .00
17100.00
9078.00
65.70
4990.00 •4990.00
4990 , 00-4990.00
5025.81
- 50 5 . .
50 5.81
-50 5.81
5M. 1.
49 0.00-10015. 1.
o1n2/2o12
Page 8 of 23
FXP0! 01.12'I3 13;42;31 Method: 1
Page: ?
Inwu City Ceuer8I Ledger System
yY 2012 Expense Reporting
For the period 12,01.11 to 12.31.11
YTD Period
Account Appropriated 8xppudituzea Expenditures En -cumbrance Balance I Used
'''-'---~~''~~'-----''--- '-''' --''-~''~~— ''''''--- -- -'-'--' ---'-'''—' --'-- ''' -
?6UO Airport (CONTINUED)
&IRP0DT (CONTINUED`
560I00 Airport Operations (CONTINUED)
OTHER FINANCIAL DSRS
490150 Operating Subsidy 1I517.00 5758.50 959.75 5758.50 50.00
490190 Intezfuod Loan 46236.00 2I940.92 3656.82 23285.08 48.58
Total OTHER FINANCIAL USES
------------ ------------
56753.00
------------
27699.42
------------
46I6.57
------------
29053.58
------
48.81
TotaI Airport Operations
------
392164.00
------------
209723.90
------
46990.07
------
4990.00 177450.10
---
54.75
7bta"l Airport
------------ --------
392164.00
--- ------------
209723.90
------------
46990.07
------------
499030 177450.10
_—_
54.75
01 /12/2012
Page 9 of 23
3X : 01.12.12 13:42:31 Method: 1
Page; 8
Iowa City General Ledger System
FY 2012 Expense Reporting
For the period 12. 1.1.1 to 1 . 1.11
"TD Period
Account Appropriated Expenditures Expenditures Encumbrance Balance W Used
76 0 Airport (CONTINUED)
AIRPORT (CONTINUED)
560100 Airport Operations (CONTINUED)
OTHER FINANCIAL USES (CONTINUED)
GRAND TOTAL 392164.00 209723.9046990.07 4990.,00 177450.10 54.75
01 /12/2012
Page 10 of 23
TRID: 01,12,12 1 :44:15 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2G12 Detail Reporting
For the period 12. 1.11 to 12,31.11
Pa3es I
Trans Date Trans Type
Report#
Source
Description
Debt Credit
?0C, Airport
560100 Airport
operations
412000
Perm Part Tinie
12. 2.11 old Sys
111130010009
504957\CIC PAYROLL RECAP\PAYROLL 02
1315.2
12.1 .1. Old Sys
111214010009
5 5 95�CIC PAYROLL RECAP\PAYROLL 16
1315.20
12.3 .1. Old Sys
111229010008
5 5234 CIC PAYROLL RECAP\PAYROLL 30
1315,20
Total
Perm Part Time
3945.60
4.3100
Temporary Rmployees
12.1 .11 old Sys
111214010009
5 5095�CIC PkYRCLL RECAP�PAYROLL 16
91,0
Total
Temporary Employees
9.r
421100
Health Insurance
12=06.11 Journal
111219155355
009816
DEC HEALTH INSURANCE'CIC HEALTH INS
329.82
Total
Health Insurance
329.82
421200
Dental Insurance
12.06.11 Journal
111219155355
009815
DEC DENTAL INBURANCR CIC DENTAL INS
19.32
Total
Dental Insurance
19.32
421300
Life Insurance
12.14.11 New Vouch
111215030050
06779944
Check; 00922\MADI ON NATIONAL LIFE
7.53
Taal
Life Insurance
7.5
421400
Disability Insurance
12.14.11 New Vouch
111215030050
06780044
Check: 922�MkDISCN NATIONAL LIFE
13.68
Total
Disability Insurance
13.68
422100
FICA
12.02.1. Old Sys
111130010009
12 2o599 EICA�CITY CONTRIBUTION
96.1
.2.16.11 Old Sys
111214010009
1216059 FICA CITY CONTRIBUTION
103.12
!2 . 0 a 11 Old Sys
11!229 0
L 9\ I CA\C TY CONTRIBUTION
100.61
Total
FICA
299.89
o1n2/2o12
Page 11of23
��TD! 01,12.12 11/44/I5 Method: 4
Iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period I2.01.11 to 112.31.1l
Trans Date
Trans Type
Reoort#
G0uroo Description Debit Credit
-----------
?60O Airport (CONTINUED)
----------
------------
-------- ---------------------------------- -------- ---- —___--
560I00 Airport Operations
(CONTINUED)
423I00 IYER8
I2.02.II
Old 8vu
1111300I0009
12020599\ZPE8S\CIIY CONTRIBUTION I06.14
I2.16.11
Old Sys
11I214010009
I2I60599\IDDBQ\CZTY CONTRIBUTION 113.48
12.30.11
Old Sys
111229010008
12300599\IPERS\CIIY CONTRIBUTION I06.14
------------ ---- ____
Total HERS 335.76
435060 Legal Publications
12.21.11 New Vouch 111222030049 06780459 Checb�701210\I0WA CITY PRESS CITIZE I3.78
_____________
Total Lecal Publications 13M
438010 Sormwater Utility Cbazqao
12.21.11 Journal 130I04I73721 009826
Total 8tormmaCez Utility Charges
438030 EIemtrioity
I2.21.I1 New Vouch
12.2I.11 New Vouch
I%.]I.lI New Vouch
12,21.11 New Vouch
Total Electricity
438070 Heating Fuel/Gas
12.21.11 New Vouch
I2.21.1I New Vouch
12.2'1,11 New Vouch
Total Reatling Fuel/Gas
40080 Sewer Utility Cbazom
12.2I.11 Journal
I2.3I.11 Journal
I2.2I.I1 Journal
12.21.11 journal
057-085'03\ I%.2l.lI Dill D 789.I1
------------
?8g`11
111222030049 06780474 Cheok:70I196 FNEBOY\ELE
111222030049 06780596 Cheok�70I106\MIDAMERICAN ENERGY\ELE
111222030049 06780598 Chect:,70l106\MID&NERIC&N ENRDQY\RLE
11122203CO49 06780599 Check.-701195\MIDAMERICAN ENRRGY�ELF
11I22203O049 06780506 Cbeck-.701185\mID&HDRICAN ENER0Y\QA8
111222030049 06780596 Cboch�701196\MIDANDDICAN 0NERQY\QDB
I11322030049 06780597 Check:701I96\MID&NEDIC&N D0ERGY\GAS
12010417372I 009826 OS7'lI5-OU\SUWED\l2.2I.lI Bill Data
120I04I73721 009826 057-117'00\Rnwn» l2.2l.Il Bill Date
220104173721 009826 U57'II8-UJ\8EWDD\l2.21.1I Dill Date
120104173721 009826 057'130-00\8DWER\I2.2I.I1 Bill Date
165.39
797,40
68.6]
2l4.93
------------
l24G.35
42.26
46D.]4
161.80
------------
654.4U
44.06
26.13
12,14
22.3I
o1n2/2o12
Page 12 of 23
7RID: 01.12.12 13;44:15 Method, 4
Iowa City Qwoozal Ledger System
Expenditures DoC«iI
FY 2012 Detail Reporting
For the period 12.01.11 to 12.31.11
paue! I
Tran Dote Trans Type Depoxt# source Description Debit Credit
-----------
----------
------------
--------
-----------------------------------
------------
------
7600 Airport (C0NTINDED�
560I00 Airport Operations (CONTINUED)
438080 Sewer Utility Charge 'CONTINUED)
Iot�l Sewer UtilityCharge
____________
94.64
438090
Water Utility Charge
162.31.11 Journal 120I04I73721 009826
057'095-03\W&TEk\12.3I.1I
Bill Date
7.61
12.2I.I1 Journal 120104173721 009826
057-115-00 I2?1.I1
Bill Date
43.38
12.21.11 Journal 120104173721 009826
057-I1?-00\RATER 12.3I.1I
Bill Date
12.39
12.21.I1 Journal 120104I73721 009836
057-I18'03K I2.21.I1
DiII Date
9.40
12.2I.11 Journal 120104173721 009826
057-I20'00\WATDR\12.21.I1
Bill Date
17.02
Total
WaC8r Utility [harce
---_
--- ------------
89.80
438100
B8fuoo Collection Charges
1L07.II New Vouch III208030I26 06779278
Chmok:700574 DISPOSAL
SYSTEMS I
28.08
12.07.11 New V0oCb I11208030126 06779279
Cbenb�700574\ABC DISPOSAL
8Y8TRM@ I
69.00
lotul
Refuse Collection Charges
------------
______
97.00
438120
Long Distance Service
I2.O4.I1 Ph Lon Dot 120104II3046 000I2019
DEC LONG DI8T CHQDD
3.57
Total
Long Distance Service
------------
______
3.57
442010
Other Building Repair & Maintenance 8or
12.I4.1I New Vouch 1II315030050 06779544
Cheok-700909\JDT AIR INC
I0W\CL.P1A0I
500.00
12.I4.I1 New Vouch 11121500050 06779574
Cbeok,-,700935\0VER8EAD DOOR COMPANY
348.75
Total
Other Building Repair & Maintenance 3azvi
______
____ ------------
848.75
442020
Structure Repair 8 Maintenance Services
12.I4.1I New Vouch I1I215030050 06779492
Chenk-,700916\LIF8 TIME PENCE CO INC
795.00
Total
Structure Repair & Maintenance Services
________
--------
795.00
442030
Heating Equipment Repair & Maintenance
12.2I.11 New Vouch 111222030049 06780376
Cheok:701180\LAREW 0JPER
COMPANY LL
366.00
_______
_________
o1n2/2o12
Page 13 of 23
TRID; 01.I2.I2 13�44:15 Method: A
Iowa City General Ledger System
Rxnend1tnzea Detail
FY 2012 Detail Reporting
For the period 12.0I.II to 12.31.11
Trans
Date Trans Type Beoort# Source Description Debit Credit
-----------
----------
------------
__________________________________
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
442060 Electrical G Plumbing Repair 6 Naintoua',
12.07.11 New Vouch 11130800126 06779172 CheCb�700579\ADVANCQD ELECTRICAL GE 907.65
Total Electrical & Plumbing Repair & Madotooauc
442070 Bldg Bost Control Services
12.14.11 Now Vouch 11I215030050 06779789 Cbeok-.700893\B&WKEYB PEST CONTROL l
Total Bldg Peat Control Services
445080 8uon and Ice Removal
12,14.11 New Vouch 111215030050 06779543 Check;700909�JET AIR INC IOW\MAINT
Iot.aI Snow and Ioo Removal
446100 City Attorney Chargeback
12,31.1I Journal
------------ ______
907.65
33.95
------------
3J.95
4500.00
------------
450O.O0
I2U104lY372lO098l7Oct-Dee CityAttymq\interdepartmen8O4.S2
------------ ------------
Total Citv 8ttoruev Charqebaok 884.52
446140 ITS -Computer
^ _~~Replacement ok
12.01.11 IT Denl 111222144720 000I3025 DEC ITS BEPL C8Q8CK
Iotal ITS -Computer Replacement Cbarneback
44.6160 ITS-Network/Internet Cbuzgebuok
12.0I.II IT Int/Nwk 11I221133507 000I303I DEC ITS 0DTWUINTDNQT
Total ITS-Network/Internet Chargebaok
446200 Photocopying Chargebaok
12.01`11 Copier Cbo I11229135858 0120004I NOV PHOTOCOPY CHARGE
","otaI Photocopying Chargeback
44.8300 Phone Equipment/Li-ne Cbazgebaok
12.04.11 Ph EguipmC 120104113046 000120I8 DEC BHON EQUIP CE0BK
Total Phone Equipment/Line Cbargeback
101.42
------------__----
10l.42
60.00
------------ ------
60.O0
%4.00
------------
2A.00
9%.S0
------------ ______
92.50
o1n2/2o12
Page 14 of 23
T�ID; 0Ll2.12 I3;44;15 Method; A
Iowa City General Ledger System
Expenditures Detail
FY 20I7 Detail Reporting
For the period 12.011l to I2.31.I1
Trans Date Trans Type Reoort# Source Description Dobit Credit
-----------
----------
------------ -------- ------ ---------------------------- ------------ ------
7600 Airport (CONTINUED)
560I00 Airport Operations(CONTINUED)
446320 Mail Chargeback
13.01.I1 Mail I11208I13648 0I200045 NOV POSTAL CHARGES 47.47
Total Mail Chargeback
446350 City Vehicle Replacement Cbazoeback
I3.31.11 Q0 Repl 120I05145515 0O012006 DEC REPLACEMENT COST
Total City Vehicle Replacement Chargeback
446370 PoeI Chazgaback
12'31.11 B0 Div 130105I45515 00012008 DEC DIVISION FUEL
Total Fuel Charqeback
446380 Vehicle Repair & Maintenance Chargeback
I2.31.II DO Div I20105145515 000I2008 DEC DIVISION SERVICE
Total Vehicle Repair & Maintenance ChargabaCk
44906D Dues & Memberships
12.14.11 New Vouch 111215030050 06779636 Check:700850\AMEIRICAN ASSOCIATION 0
Total Dues 6 s
449360 Interest Rxoeooe
1.2.31.11 Journal
12.31.II Journal
12.31I1 Journal
12.31.11 Journal
Tot,aI Interest Expense
4520I0 Office Supplies
I2.21.11 P'Cazd
I2.21.1I D'Card
Total Office Supplies
1112I9155355 809813 Corp Hangar Loan Int\Deo Intarfuod
II1219155355 009813 DI Hangar Loan Into Intazfnud Lm
11I219155355 009813 8D T'Hunr .1jmao Iuto Iutorfuod Lo
1113I8155355 809813 8W T-Hoor Loan Int\Deo Iotarfuud Lo
------------ ------
4?.47
1363.72
------------ ______
1363.72
240.01
------------
340.0l
1049.58
------------
IO49.SO
275,00
------------
275.00
1770.03
1254,57
930.86
867.64
------------ ______
482].10
I20I05093951 I8300487 STAPLES C0NTRA00710004\mIC8AEL THAD 158.63
130I0509395I I8300488 STAPLES 00I06260\MIC8ADL THAR 62.98
------------ ______
2%l.61
01/12/2012
Page 15 of 23
TRID: 01,12.12 13:44:15 Method; 4
Iowa City General Ledger Systeia
EXpenditures Detail
FY 2012 Detail Reporting
For the period 12.01.11 to 12.31.11
Page: 6
Trans Date
Trans Type
Reports
Source
Description
Debit Credit
-----------
7600 Airport (CONTINUED)
----------
------------
--------
--------------------------------
--------- ------------
560100 Airport Operations
(CONTINUED)
452030 Minor Office
Equipment/Furniture
12.21.11
P-Card
120105093951
18300489
STAPL89222029668000\MICHAEL THARP
129.98
Total Minor Office Equipment/Furniture
------------
-- ---------
129.98
455120 Mist Computer Hardware
12,21,11
P-Card
120105093951
18300214
BUY.COM\GARY COHN
359.00
12.21-11
P-Card
120105093951
18300490
STAPLES 00106260\MICHAEL THAR
39.99
Total Misc Computer
Hardware
------------
------------
398.99
468050 Sand
12.14.11
New Vouch
111215030050
06779530
Check:700947\S & G MATERIALS\SAND
26.55
Total Sand
------------
------------
26.55
469200 Tools
12,14,11
New Vouch
111215 03 50
06779545
Check:700909\JET AIR INC 10WNOV MA
------------
3.50
------------
Total Tools 3.50
469320 Miscellaneous Supplies
12,14.11 New Vouch 111215030050 06779545 Check:700909\JET AIR INC IOW\NOV KA 58,95
------------ ------------
Total Miscellaneous Supplies 58,95
473010 Contracted Improvements
12,21.11 New Vouch 111222030049 06780450 Check:701183KRUSE TREE SERVICE INC 17100,00
Total Contracted IMDrovements 17100.00
490150 Operating Subsidy
12.31.11 Journal
Total Operating Subsidy
490190 Interfund Loan
12.31-11 Journal
12,31.11 journal
12,31,11 Journal
111219155355 009609 Airport 1A ED Coord�Dec Budgeted 0
111219155355 009813 Corp Hangar Loan Prn�Dec Interfund
111219155355 O04813 U1 Hangar Loan Princ\Dec Interfund
111219155355 009813 SE T-Hngr Loan Princ\Dec Interfund
959.75
------------ w -----------
959.75
1229.97
1136.95
727.54
01/12/2012
Page 16 of 23
liR.TD1. 01.12.12 13-144:15 Method; 4
.owa City General Ledger gystem
Expendittreg Detail
FY 2012 Detail Reporting
For the period 12.01.11 to 12,31,11
Page'. 7
Trans Date Trans Type Reput# Source Description Debit Credit
----------- ---------- ------------ -------- ---------- ------ ----- ------------ __.-----___-
79.00 Airport (CONTINUED)
V.
560100 Airport Operations (CONTINUED)
490190 Interfund Loan (CONTINUED)
12.31.11 Journal 111219155355 009813 SW T-Hngr Loan PrincDec Interfund 562,36
Total Inter and Loan
Total Airport Operations
------------ ------------
3656.82
------------ ------------
46990.07
01/12/2012
Page 17 of 23
TRID; 01,12.12 13:44:15 Methoda. 4
iowa City General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 12,01.11 to 12.31.11
pager 8
Trans Date Trans Type Report# Source Description Debit Credit
----------- ---------- ------------ -------- ----------------------------------- ------------ ------------
7600 Airport NCO NTINUED)
560100 Airport Operations (CONTINUED)
490196 *Interfund Loan (CONTINUED)
------------ ------------
Iotal Airport 46990.07
01/12/2012
Page 18 of 23
TRID; 01;12,12 13-44�15 Method: 4
iaowC1'ty General Ledger System
Expenditures Detail
FY 2012 Detail Reporting
For the period 12,01.11 to 12-31.11
Page: 9
TraBs Date Trans Type Report# Source Description Debit Credit
----------- ---------- ------------ -------- ----------------------------------- ------------ ------------
7600 Airport (CONTINUED)
560100 Airport Operations (CONTINUED)
490190 Inter and Loan (CONTINUED)
- - - - - - - - - - - - - - - - - - - - - - - -
GRAND TJOTIAL 4H90.07
01/12/2012
Page 19 of 23
TRID;, 01.12.12 13:44:27 Method; 4
Tow
a My General Ledger System
Revenues Detail
FY 2012 Detail Reporting
For the period 12,01.11 to 12.31.11
Page: 1
Trans Date Trans Type Report# Source Description Debit Credit
----------- ---------- ------------ -------- ----------------------------- ------------ ---------
1,600 Airport
560100 Airport Operations
381100 Interest on Investments
12,31.11 Allocation 120109150054 Dec interest allocation 5.,26
Total. Interest nterest on Investments
------------
------------
5,26
382100 'Land Rental
12.06,11
Payment
111206093530
00020655
2-4\TOYOTA OF IOWA CITYPAYKEXT
7399.00
12,13.11
Payment
111213093316
00020858
1-25\BELL LARRY & SANDRA\PAYMENT
3010,00
12.14.11
Misc Pymt
111222132957
70-9\ARMY RESERVE\AIRPORT LEASE
----------
701.07
Total Land Rental
8400.07
382200 Building/Room
Rental
12.02.11
Payment
111202092113
60020836
2-4\DOWNES GREG\DEC 11\HANGAR #51
172.00
12.02.11
Payment
111202111417
00020365
9-2\YEAGER DAN\OCT 11HANGAR #'7
3.00
12.02.1
Payment,
111202111417
GOU020559
9-1\YEAGER DAN\NOV 11\HANGAR #17
151,00
12.05.11
Payment
11.1 0509 303
00020777
2-5\PITTON MIKE�DEC 11HANGAR #26
151.00
12�05.11
Payment
111 050 303
00020781
2-3\8CHNELL TOM\DEC 11\HANGAR #62
178.00
12.,05.11
Payment
111205092303
00020793
2-4\8CHMEISER RUSS\DBC 11\HANGAR #
209.00
12.0-5.11
Payment
111205092303
0002C832
2 -1\STEARMAN�DEC 11\HANGAR #47
172,00
12.06.11
Payment
111206093530
00020756
1-23\FULLER SCOTT\DBC 11\HANGAR #3
172,00
12.06.11
Payment
111206093530
00020758
1-20�HEADINGTON MERLE & BEVERLY\DE
151,00
12.06.11
Payment
111206093530
00020778
1-13\DEMARIA JOSEPH\DEC 11\HANGAR
151,00
Payment
1112C6093530
00020828
1 -22�POWERS ROBERT\DEC 11�HANGAR #
144.00
12.07.11
Payment
111207092053
00020757
2-12�ANDERSEN JASON�DEC 11\HANGAR
144.00
12.07.1].
Payment
111207092053
00020757
2-12\ANDERSEN JASON\DEC 11\HANGAR
144,00
12.07.11
Payment
111207092053
00020782
2-11\BULLERS JONATHAN\DEC 11\HANGA
144.00
12.07.11
Payment
111207092053
00020788
2-9MASCARI RICK�DBC 11\HANGAR #30
151.00
12.07.11
Payment
111207092053
00020789
1-11\BUTLER JOHN\DEC 11\HANGAR #36
172.00
12.07.1 - I
Payment
111207092053
00020789
TLER JOHN\DEC 11\HANGAR #37
1-11\BUi
172.,00
12.,07.11
Paymeint
111207092053
00020810
1-10\GERR FRED\DEC 11\HANGAR #116
151-00
12,08.11
Payment
111208091056
00020790
1-12\HARTWIG RANDY�DEC 11\HANGAR #
172r00
12,08,11
Payment
111208091056
00020829
1-3�OPERATOR PERFORMANCE LAB\DK. 11
4038.00
12.0L11
Payment
111 080 105
00020829
1-3�OPERATOR PERFORMANCE LAB�DEC 11
615.00
12.09.11
Payment
111209091525
00020780
2-5RANEY CHARLES\DEC 11\HANGAR #1
144.00
01 /12/2012
Page 20 of 23
TRID: 01.12.12 13;44:28 WWI- 4
Iowa City General Ledger System
Revenues Detail
FY 2012 Detail Reporting
For the period 12 , 01.11 to 12.31..11
Page; 2
Trans Date
Trans Type
Report#
Source
Description Debit
Credit
7600 Airport 'CONTINUED
0100 Airport Operations
(CONTINUED)
382200 Building/Room
Rental (CONTINUED)
12.1.2.11
Payment
1112.2094 07
00020751
2-9 DDGAARD JACDH\DEC 14\HANGAR #2
151A0
12.13.1.1.
Payment
111213093316
00020766
1-9 RUYLE JDHN\DEC 11\HANGAR #33
3 8.00
1.2.13.11
Payment
111213093316/
�j020802�
1-J2�4\ZUHyROD1fp ROIL\}DEC 11\HANGAR #2
12 . 13 , 11
Payment
f� �
Ali 1 V 93 1 }�
111213093316
�j n
M 0 V 20`I25
-21\ROR/F �iEI•Tr.H\DEC 11\HANGAR #4
„151.0�
11¢72 t 00
12.14.1.1
Payment
111.214091. 49
00020607
2~17\SAPPHIRE VISTAS LLC�NDV 11\HAN
i001,
12.114.11
Payment
1.11214091 49
0002082
2-11\JET AIR INC\DEC 11\BUILDINGS D
Y�15.
3K" .00
1.2.14.11.
Payment
1.1 .214091 49
00020834
2-1.7�SAPPHIRE VISTAS LLCjDEC 11 HAN
1.E1. 00
12.14.11.
Payment
11121.4091649
00020840
2-1.1\JET AIR\DEC 11\HANGAR #0
1.78.00
12.1.4.1.
Payment
11121409149
00020840
2--11JET AIPDEC 11HAN�AR
178,00
2.16.11
Payment
11121 08 735
00020371
2-8�RULL JERRY\OCT 11\HANGAR #45
2,04.0
A-2.1 .11
Payment
11121. 08 73
00020807
1-16\AEROHAWKS\DEC 11\HANGAR #19
151.00
12.16.11
Payment
1.1216094838
00020749
89-1\MILLER RICHARD\DEC 11\HANGAR
172,00
12.1 .11
Payment
111216094838
00020764
89-4 HINCKLEY HARRY\DEC 11\HANGAR
404100
1.2 r 1. .11
Payment
11121 094838
00020764
89-4�HINCRLEY HARRY\DEC 11\HANGAR
1.44. 00
12.1 .11.
Payment
11.1.216094838
000207 7
89-5\VDB JEREMY\DEC 1.1 HARNGAR # 4
19 -00
12116.11
Payment
11121 094838
00020794
8 - PISHHAUGH JUSTIN\DEC 11 HANGA
178.00
12.16.11
Payment
11121 094838
00020797
89-7 PATTSCHILL RICHARD\DEC 11. HAN
234,00
12.1 ,11
Payment
111216094838
00020799
89-8\ALLENDER PATRICK\DEC 11\HANGA
172.00
12.1 .11
Payment
111.21 094838
00020813
89-10\EDMDNDS TERRY\DEC IM HAR AR
320.00
12.16.11
Payment
111216094838
00020822
8 -14\SQUADRONS UP\DEC 11\RANGAR. #5
172.00
12116.11
Payment
1.14.216094838
00020824
89-15 GDRN'ETT DON\DEC 11\HANGAR #3
310.00
iz.1 11.1
Payment
111216094838
00020833
8-16\8INGLETARY RDDERMEC 11\HAN
144,00
1L i6 . n
Payment
111216094838
00020841
89-18 8WAN8DN NADI I\DEC 1.1\HAN`GER
144. 00
1L16.11
Payment
111216094838
00020862
89-23\COH GARY\DEC 11\HANGAR #22
1 1.00
12,1 ,11
Payment
111210094838
00020865
89-2 \NEADE JAMES N�DEC 11\HANGAR
172.00
12.20.1.1.
Payment
111220091708
00020784
2-6 EULGARELLI DAVID\DEC 11\HANGAR
151.00
12.22,11
Payment
111222091424
00020867
2-3 RDHR BRIAN\DEC 11\HANGAR #27
151.00
12.27 ,11.
Payment
111228074349
00019109
9-1\GRRR 'RED\MA.Y iI\HANGAR #16
148.00
12,29;11.
Payment
111229092606
00020783
1-22�HALL RDEERT\DEC 11\HANGAR #6
144.00
12,,29.11
Payment
111229052606
00020783
1-22\HALL RDHERT\DEC 11 HANGAR #12
1 1.00
12.29.1.1.
Payment
111229092606
00021023
1-1 WILLIAMSKEITH & JEAN\JAN 12
151.00
12.29.11
Payment
11122909260
0002/044
1-19\HRIIMLEY JAMES JAN 12\HANGAR #
151.00
01 /12/2012
Page 21 of 23
141D.< 01,1.2.12 13:44:28 Methods 4
Iowa City General Ledger System
Revenues Detail
FY 2012 Detail Repo.r. tinq
For the period 12.01,11 to 12.31,11
Pad: 3
Trans Date
Trans Type
Report#
Source
Description Debit
Credit
-----------
700 Airport 'CONTINUED)
----------
------------
--------
- ..-----_---.._----__-__-----------------------
-_-....------_
560100 Airport Operations
(CONTINUED)
382200 Building/Room
Rental (CONTINUED)
12.2 .11
Payment
111229092606
00021054
1-20\HALL ROBERT JAN 12 HANGAR #6
144.00
1.2.29,11
payment
11122 092 0
00021054
1--20\HALL ROHERT�JAN 1.2\HANGAR #12
1.51.00
12.2 .11.
payment
11122 0 260
00021062
1-1. N622 W INC JAN 12 HANG R #49
172.00
,12.3D.11
Payment
111230085553
0002/022
2-25\FIELD H WARD\JAN 12�HANOAR #5
344.00
12.30.1.1
Payment
1.1.1230085553
00021028
2-8 HBABINGTON MERLB & BEVERLY\JAN
1.51.00
1.2,30.11.
payment
1.11230085553
00021141
2-11 POLASK1 N1CHAEL JAN 12�HANGAR
151..00
Total Building/Room Rental
384200 Vending Machine Comm
12.21..11. Mi o Pymt 11.1.22109243
Total Vending Machine Corm
384900 Other Commissions
12,16,11 Milo Pymt 11121 085 41.
Total Other Commissions
3931.20 Genera. Levy
1 545.00
2-9\THE AMERICAN BOTTLING COMPANY V 7.20
a k!
1-29 EASTERN AVIATION FUELS\FURL CO 1533.30
1533.30
12,31.1.1. Journal 1.11219155355 009809 Rtax to kirport\Dec Budgeted Operas
Total General Levy
Total Airport Operations
8333.33
8333,33
36824.1.E
01 /12/2012
Page 22 of 23
Iowa City General Ledger system
Revenues Detail
FY 2012 Detail Reporting
For the period 12x01;11 to 12,31.11
page! 4
Trans Date Trans Type Report# Source Description Debit Credit
-----------
----------
--...-----....-_--__----_..-------------------- ------------
----__--____
Airport CONTINUED)
560100 Airport Operations (CONTINUED)
Total Airport 36824.1
o1n2/2o12
Page 23 of 23
7RID: 01.I2.12 I3:44:28 HetbVd: 4
Iowa City General Ledger System
Revenues Detail
FY 2012 Detail Reporting
For the mi0d 12.01.1I to 12.31.11
Poam: 5
11*
Trans
DuCo Trans Tvno Renort# Source Description Debit Credit
-----------
----------
------------
--------
-----------------------------------
------------
______
7600 Air�urt (CONTINUED)
560100 Airport Ooamtimm (CONTINUED',
____________
+�� GRAND TOTAL 36824.16