Loading...
HomeMy WebLinkAbout01-13-2022 Airport Commission*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 If you will need disability-related accommodations in order to participate in this program/event, please contact Michael Tharp, Airport Manager, at 319-356-5045 or at michael-tharp@iowa-city.org. Early requests are strongly encouraged to allow sufficient time to meet your access needs. IOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JANUARY 13, 2022 – 6:00 P.M. 1. Determine Quorum 1 min* 2. Approval of Minutes from the following meetings: 2 min December 9, 2021 3. Public Comment - Items not on the agenda 5 min 4. Items for Discussion / Action: a. Airport Signage/Wayfinding 5 min b. FAA/IDOT Projects: 30 min i. Obstruction Mitigation 1. Phase 1 a. Consider a resolution accepting the project as complete (A22-01) 2. Phase 2 a. Consider a resolution accepting the project as complete (A22-02) ii. Runway 7/25 Rehab East End 1. Consider a resolution setting a public hearing for the plans, specifications, and form of contract for the Runway 7/25 rehabilitation phase 1 project (A22-03) iii. Runway 25 Threshold Relocation 1. Consider a resolution accepting bids and awarding contract (A22-04) iv. South T-hangar infrastructure v. Hangar A Door Replacement (phase 1) vi. FAA Bipartisan Infrastructure Law (BIL) Grant programs c. Airport "Operations" 45 min i. Management 1. Airport Frontage Area/Parking Lot ii. Budget a. Art Mural i. Fundraising ii. RFQ 2. Fuel Flowage Fees iii. Events d. FBO / Flight Training Reports 10 min i. Jet Air 1. Jet Air Outlook Plan e. Commission Members' Reports 2 min f. Staff Report 2 min 5. Set next regular meeting for February 10, 2022 6. Adjourn December 9, 2021 Page 1 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. MINUTES DRAFT IOWA CITY AIRPORT COMMISSION THURSDAY, DECEMBER 9, 2021 – 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Judy Pfohl, Warren Bishop, Hellecktra Orozco, Chris Lawrence, Scott Clair Staff Present: Michael Tharp, Jennifer Schwickerath Others Present: Matt Wolford, Carl Byers, John Moes, Bill Bollman RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM The meeting was called to order at 6:00 pm. APPROVAL OF MINUTES FROM THE NOVEMBER 18TH MEETING: Modification by Tharp: John Yeomans is listed as being present, but was not in attendance. Motion to accept modified minutes by Bishop, seconded by Pfohl. The motion carried 5-0. PUBLIC COMMENT: None. ITEMS FOR DISCUSSION / ACTION a.Airport Signage/Wayfinding Using prior feedback received from the Commission, Moes and Bollman proposed options for lighted, aluminum-framed monument-style entrance/exit signage approximately 78" x 36", mounted on a cement foundation. Entrance signage directs visitors to parking, ambulance, terminal/Jet Air, the viewing area, and the UI Performance Lab. Exit signage, on the other face of the sign, directs people to Highway 1/6 and 380, and thanks them for visiting. Both sides carry the new airport logomark. For legibility, the scale is the same as that at the Des Moines airport for. Bollman said the lettering can be changed to reflect future changes at the airport, and the signs can be lit externally or internally. Byers said that bid pricing two years ago on such signs, lit internally, ran to $5500 including pedestal, lettering and lighting, but not running power to the signs, and said he expected the price would be higher now. He estimated that a similar externally- lit sign would cost something similar. Pfohl asked whether this was one or two signs; Bollman confirmed it was a single structure with different signage on each side. Byers pointed out that the externally-lit sign had an advantage in that lettering was appliquéd and could be changed easily; internally-lit signs would need a new aluminum face manufactured. The logomark could be lit and colored blue in either option, and could stand proud of the signage or be incorporated within. The proposed design bolds the historic IOW three-letter identifier in the "Iowa City" name. Orozco Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 2 of 37 December 9, 2021 Page 2 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. asked whether the blue strip at the bottom of the sign could also be lit; this was confirmed. Tharp was concerned about the potential cost of replacing wayfinding directions on an internally lit sign, seeing no future revenues available to cover manufacture of a new outer aluminum layer. Various suggested modes of sign manufacture to get around this problem were discussed. Pfohl and Bishop said they liked the design concept, scale, font, and internal lighting, but wanted more information on possibilities for internal lighting that did not require cutting a new aluminum exterior layer for each wayfinding change. Moes thought several options would be available, and either Byers or he and Byers will go back to the sign manufacturer for more information and concepts. Orozco raised durability concerns. All agreed that they preferred the logo embedded inside the peak of the monument face. Bishop asked where the sign would be installed, and Commissioners discussed placement. Interior wayfinding signs were also discussed: four 12" x 8" signs were presented signposting Jet Air, Pilot's Lounge, Flight Simulator, and Restrooms. Bishop, Pfohl, and Wolford requested other signage for the conference room and Airport Manager's office; no Jet Air sign is needed. Commissioners agreed that it would be a good idea to bring in mock-ups and try them out. A vinyl back entry door skin design incorporating a QR code was also presented and colors discussed. The QR code would go to a hidden airport webpage with helpful information for pilots. The front door would have the same design with a QR code linking to the airport homepage. Bollman, Moes, and Tharp assured the Commissioners that QR codes are unique and free to generate. Bollman will get an estimate for the vinyl door skins. Bollman presented a concept for the air side of the airport building that included glass brick and the new logomark mounted on the end of the building. Logomark colors were discussed and agreed upon. Orozco asked whether the logomark sign would be lit, and Bollman said the proposed design could be lit internally. Commissioners indicated that they preferred external lighting. Bollman will work with Byers on pricing. b.FAA/IDOT Projects: i.Obstruction Mitigation Tharp is working with the contractor on payroll and paperwork approval to have it for the January meeting, and says that the work itself is done. ii.Runway 7/25 Rehab East End The threshold rehabilitation bidding process is ready to begin. The public hearing process will begin in January, and grant applications to fund the project will be submitted in March. iii.Runway 25 Threshold Relocation Bishop asked whether the amended specifications included LED lighting, and Tharp confirmed that they were. Public hearing was opened 6:38pm. 1.Public hearing Amendment to specifications include the addition of an equal-opportunity employment clause and a statement forbidding contracting with those Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 3 of 37 December 9, 2021 Page 3 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. convicted of wage theft. Both are required by the City. The project will be bid for the entire runway either with or without heating elements on the LED lights; the Commission can accept either kind of bid. Incandescent lighting is not requested in the bid. Lawrence asked about project funding; Tharp said that the FAA has not yet committed to helping to fund the runway lights project, but that City environmental funds are available if the FAA does not come through with funding. Clair recapped the Commission's November inclination to unheated lights due to energy savings and the likely limited need for ice-melting. Tharp agreed that likely the airport did not need heated lights. The engineering estimate is approximately $600,000 for the project. Lawrence confirmed that runway, runway end, and identification strobes will all be LED. The Commission discussed converting the beacon to LED as well as a future separate project, converting the airport to all-LED. Public hearing was closed at 6:46pm 2.Consider a resolution (A21-16) approving the plans, specifications, and form of contract as amended or the remarking and relighting of Runway 25. Moved by Bishop, seconded by Lawrence. Motion carried 5-0. iv.South T-hangar infrastructure Tharp reports no current progress; survey crews have been out. Project will begin in spring. v.Hangar A Door Replacement (phase 1) Tharp reports no current progress; crews have been out to examine the site. Project will begin in spring. Tharp and Carl estimated the project would run a year. vi.FAA FY23 ACIP Pre-Application FAA has commented positively on a draft proposal's feasibility but warned that reliance on discretionary funds may not compete well, and that it may be necessary for the Airport to build up entitlement funds for a couple of years. c.Airport Operations i.Management Airport Frontage Area/Parking Lot Tharp has met with Iowa National Guard reps and says that they will be ready to move in in February or March. They are interested in renting some of the ground around the parking lot, which Tharp believes is possible, and he will bring a lease to the Commission or approval. The Guard intend to use the building. Tharp also reports that the parking lot plan will square off the north and south ends of Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 4 of 37 December 9, 2021 Page 4 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. Beacon Circle. This should add 10 parking spots on the south end and 12 on the north end. ADA regulations require another handicapped stall. Using straight-in rather than angled allowed for more stalls. The parking lot will be concrete with a curb. Pfohl asked for a timeline, and Tharp said that engineering would need formal quotes and that work would not begin until spring. Bishop asked for measurements from the beacon with respect to green space. Commission signaled approval of Tharp's moving ahead with the project. ii. Budget Tharp said City Council had received the Airport's annual report in its meeting packet, and asked for a Commissioner to come to the meeting and give an executive summary of how the airport has done, particularly with regard to Covid's effect on the airport. The airport's recovery has been exceptionally good. Bishop and Orozco offered to attend. 1. Art Mural and Fundraising Bishop and Pfohl met with Marcia to discuss fundraising and getting cost estimates. The City will give $8000, and the Airport will need to cover the balance with private donations. They discussed a history timeline mural incorporating paintings of donors' aircraft. Marcia will find out approximate mural cost. The opportunity will be advertised in February or March, and the City will select candidates to bring concepts to the Commission. The Arts Advisory Commission will handle the contracts. A timeline is not yet set for awarding the contract and project completion. 2. Fuel Flowage Fees Bishop indicated that an update will be brought to the Commission in approximately a month. iii. Events No upcoming events planned. d. FBO / Flight Training Reports i. Jet Air Maintenance has slowed for the season. Some carpet cleaning has been done, storage has been cleared up, and facilities made ready for winter. Wolford is grateful for having a hangar space out of the wind for the plow. Jet Air had its Christmas party. Wolford and Tharp were invited to Randtizo to see heavy-duty cropdusting drones and found them impressive. They weigh about 150 lbs and fly at very low altitude so as not to deplete their batteries getting up. Tharp saw potential for environmental gains with drone cropdusting, but also for job losses. Wolford noted that Jet Air has had some heavy traffic days with 30-40% higher volume than last year. He saw no particular cause for this. There were 7 roundtrip charter trips during the Big 10 Championship as compared to 1-2 last year. The supply chain continues to present problems, but Wolford said he is well-stocked for now. Orozco asked after the Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 5 of 37 December 9, 2021 Page 5 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. simulator, and Tharp explained that there was a known software bug involving imagery layer loading problems. Pfohl and Clair suggested that the simulator could be used more. e.Commission Members' Reports - none. f.Staff Report Tharp will be on vacation from Dec 23 - Jan 3. SET NEXT REGULAR MEETING FOR JANUARY 13, 2022 The next regular meeting of the Airport Commission will be held on Thursday, January 13th at 6:00 pm. Bishop noted that he might not be in attendance. ADJOURN Pfohl moved to adjourn and Bishop seconded. The motion carried 5-0 and the Commission adjourned at 7:20 pm. ______________________________________________ ___________________ CHAIRPERSON DATE Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 6 of 37 December 9, 2021 Page 6 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. Airport Commission ATTENDANCE RECORD 2021 NAME TERM EXP. 10/08/20 11/12/20 11/30/20 12/12/20 01/14/21 02/11/21 03/11/21 04/08/21 05/03/21 05/13/21 06/10/21 07/08/21 07/15/21 08/12/21 09/09/21 10/21/21 11/18/21 12/09/21 Warren Bish op 06/30/22 X X X X X X X X X X X X O/E X X X X X Scott Clair 06/30/23 X X X X X X X X O/E X X X X X X X O/E X Christopher Lawr ence 06/30/25 X X X X X X X X X X O/E X X X X X O/E X Hellecktra Oroz co 06/30/24 X O/E X X X X X X/E O/E X X O/E O/E X X X X X Judy Pfohl 06/30/22 X X X X X X X/E X X X X X X X X X X X Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 7 of 37 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 8 of 37 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 9 of 37 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 10 of 37 AECOM 500 SW 7th Street Des Moines IA, 50309 USA aecom.com January 11, 2022 Mr. Scott Clair Airport Commission Chair Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 SUBJECT: Obstruction Removals – Phase 2 Iowa City Municipal Airport FAA AIP Project No. 3-19-0047-031 AECOM ID No. 60642468 Dear Mr. Clair, By this letter, we hereby state: 1. We have made a final review of the project and recommend acceptance. 2. To the best of our knowledge and belief, based on observations of AECOM staff during construction, the contractor, Rathje Construction, has performed the work in accordance with the contract requirements in effect for the above-referenced project. 3. The total cost of the completed work is $ 220,250.00. I hereby certify that this engineering document was prepared by me or under my direct personal supervision and that I am a duly licensed Professional Engineer under the laws of the state of Iowa. David B. Hughes Date License No. 13037 My license renewal date is December 31, 2023. Pages or sheets covered by this seal: Hughes, David (Des Moines) Digitally signed by Hughes, David (Des Moines) Date: 2022.01.11 13:14:02 -06'00' Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 11 of 37 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 12 of 37 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 13 of 37 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 14 of 37 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 15 of 37 Iowa City Airport Mural Project Request for Qualifications Accepted through Friday, March 4, 2022 Online Application (this link is to another project but gives you an idea of what it will look like) Introduction The Iowa City Public Art Advisory Committee and the Iowa City Airport Commission are seeking artists who would be interested in designing and creating a mural on the east facing wall of an airport hangar located closest to Riverside Drive: Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 16 of 37 The artist would be responsible for working with the Airport Commission and other stakeholders to design a mural utilizing their input about themes and design, refining a final design and creating the mural on the hanger wall no later than September30, 2022, subject to the timing of new door installation scheduled during the summer of 2022 (discussed further Project Details). The goal of the project is to create an eye-catching mural that will greet drivers and pedestrians entering Iowa City from the south on S. Riverside Drive as well as provide a visual cue about the history, activities and highlights of the Iowa City Airport. Project Details The Iowa City Airport is located at 1801 S Riverside Drive in Iowa City; approximately ½ m ile south of the Riverside Drive/Hwy 1 intersection. To the north of the terminal building, which is set back from Riverside Drive by about 700’, there are three airplane hangars. The one closest to Riverside Drive provides a large canvas to exhibit a mural. The Public Art Advisory Committee was particularly interested in this project as there is little to no public art in that area of Iowa City and is a major entranceway for many into Iowa City. The hanger wall is 300’ long. Six smaller passage doors and six larger hanger doors run the length of the building. Both the smaller service doors and airplane hangar doors are scheduled for replacement in the summer of 2022 and the installation schedule is uncertain at this time. . If the installation delays the mural painting project, the deadline for completing the mural may be extended by mutual agreement of the artist, the Iowa City Public Art Advisory Committee and the Iowa City Airport Commission. The new doors will have a similar surface and painted to match the existing blue siding. Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 17 of 37 Members of the Airport Commission approached the Public Art Advisory Committee to request consideration to fund a mural and share examples of existing murals that provided inspiration for a mural at the airport: Shannon Lake’s Aviation Heritage Mural, Hapeville, GA Portion of Eric Sloane’s Earth Flight Environment Mural - Smithsonian Nation Air and Space Museum Kurt Anderson’s Prairie Sky Mural, Parks Library, Iowa State University Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 18 of 37 The vision also Included components of the unique history of the Iowa City Airport which celebrated its 100th Anniversary in 2018: In addition to designing and creating the mural, the project will involve the selected artist meeting with Airport Commission members and stakeholders to further discuss the concept for the artwork. These meetings can be onsite or via zoom/virtual platform. The artist will then create a selection of concepts for the stakeholders to review as part of a second meeting or via email communications. Budget The budget for the project is $8000 which must include all costs of design and installation of mural including final sealing. Payments will be issued in three installments: • 1/3 within 14 days of entering into agreement • 1/3 within 14 days of design approval • 1/3 within 14 days of project completion The Airport Commission is also interested in offering the opportunity for pilots and other members of the public to sponsor customized aircraft images that will be incorporated into the mural – perhaps their own or other aircraft of significance to them. This opportunity will be offered after the artist and concept design is finalized with placeholders for such aircrafts, and with the number, vintage, size, locations, and orientation of such aircrafts being predetermined in order to maintain the overall artistic integrity of the mural. The selected artist should plan to work with members of the Airport Commission and Public Art staff on developing a pricing system likely based on size and location on the mural. The artist should plan to create these additional images as commissioned through September 30, 2022. Dependent upon the interest/number of planes requested, the final completion date can be extended as agreed upon by the artist, Airport Commission and Public Art staff. Submission requirements Online Application Interested artists are being asked to provide: • Applicant’s contact information. • Statement of Interest. • Maximum two-page resume that outlines professional accomplishments. Commercial passenger, 1927 Transcontinental airmail, 1918 First flight in Iowa City, 1910 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 19 of 37 • A minimum of six (6) and maximum of eight (8) images of past works. Identify images with project title, location, date completed, media, dimensions, budget, commissioning agency, project partners, and/or brief description of the project/conceptual information. Review Process/Criteria Stakeholders will be responsible for reviewing the RFQ responses and recommending an artist based on the following criteria: • Quality, creativity & strength of past work as provided in the application materials • Technical competence demonstrated by past work • Understanding of the project goals as indicated in the letter of interest • Relevance of submitted materials to the project • Aptitude for planning and budgeting as indicated by past project information submitted • Experience working on public art projects to meet project goals as indicated in the letter of interest • Experience and commitment to participate with agency/community as part of concept development • Preference will be given to Iowa City artists or those who create art or exhibit their art in Iowa City. The recommendation of the stakeholders will then be reviewed by the stakeholders/Airport Commission and Public Art Advisory Committee according to the schedule below. Project Schedule • Submission Deadline – Friday, March 4, 2022 - 5:00 PM • Selection of Preferred Artist by stakeholders/airport commission – Friday, March 18, 2022 • Review of Artists Selection by Public Art Advisory Committee – Thursday, April 7, 2022 • First meeting with stakeholders – no later than Friday, April 22, 2022 • Design concepts created and made available to stakeholders for review – May 13, 2022 • Determine Final Design – Friday, May 20, 2022 • Enter into Project Agreement – June 3, 2022, 2022 • Installation Completed – September 30,, 2022 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 20 of 37 01/11/2022 11:11 |CITY OF IOWA CITY |P 1 mtharp |INVOICE LIST BY GL ACCOUNT |apinvgla YEAR/PERIOD:2022/6 TO 2022/6 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION____________________________________________________________________________________________________________________________________ 76850110 Airport Operations 76850110 432080 Other Professional Services 013364 BOLTON & MENK INC 0265657 0 2022 6 INV P 1,100.00 121721 28725 Solar Power RFP Ass ACCOUNT TOTAL 1,100.00 76850110 438030 Electricity 010319 MIDAMERICAN ENERGY 20211215094233 0 2022 6 INV P 1,432.85 121721 28743 MidAmBilling 121520 ACCOUNT TOTAL 1,432.85 76850110 438070 Heating Fuel/Gas 010319 MIDAMERICAN ENERGY 20211215094233 0 2022 6 INV P 940.02 121721 28743 MidAmBilling 121520 ACCOUNT TOTAL 940.02 76850110 438100 Refuse Collection Charges 010507 JOHNSON COUNTY REFUS LRS-200332 0 2022 6 INV P 181.50 121721 266413 DEC FY22 Monthly Ga 010507 JOHNSON COUNTY REFUS LRS-200334 0 2022 6 INV P 45.00 121721 266413 DEC FY22 Monthly Re__________________ 226.50 ACCOUNT TOTAL 226.50 76850110 442010 Other Building R&M Services 010358 OVERHEAD DOOR COMPAN YW25540 0 2022 6 INV P 674.40 121021 266288 Hangar 41 Cable Rep 010856 JET AIR INC IOW IVI-21-006706 0 2022 6 INV P 600.00 121721 266404 Janitorial Services 013610 STANDARD PEST CONTRO 47432 0 2022 6 INV P 30.00 121721 266459 Pest Control Servic 014647 DAN'S OVERHEAD DOORS 526755 0 2022 6 INV P 138.82 121721 28729 Hangar Door Repairs 014647 DAN'S OVERHEAD DOORS 527245 0 2022 6 INV P 189.15 121721 28729 Hangar 56 Door Repa__________________ 327.97 ACCOUNT TOTAL 1,632.37 76850110 442060 Electrical & Plumbing R&M Srvc 010014 ADVANCED ELECTRICAL 64045 0 2022 6 INV P 147.00 121721 28717 Replace Fuse on Bea 010014 ADVANCED ELECTRICAL 64105 0 2022 6 INV P 270.48 122421 28769 Replace Front Facad__________________ 417.48 010564 LYNCH'S PLUMBING INC 30537 0 2022 6 INV P 166.50 121721 266422 Replace pressure ta 010564 LYNCH'S PLUMBING INC 30597 0 2022 6 INV P 104.00 122421 266561 Sink Drain cleanout__________________ 270.50 010856 JET AIR INC IOW IVI-21-006704 0 2022 6 INV P 202.10 121721 266404 Maintenance Reimbur ACCOUNT TOTAL 890.08 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 21 of 37 01/11/2022 11:11 |CITY OF IOWA CITY |P 2 mtharp |INVOICE LIST BY GL ACCOUNT |apinvgla YEAR/PERIOD:2022/6 TO 2022/6 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION____________________________________________________________________________________________________________________________________ 76850110 445080 Snow and Ice Removal 010856 JET AIR INC IOW IVI-21-006704 0 2022 6 INV P 59.31 121721 266404 Maintenance Reimbur 010856 JET AIR INC IOW IVI-21-006705 0 2022 6 INV P 5,500.00 121721 266404 Groundskeeping/Snow__________________ 5,559.31 013997 CRYOTECH DEICING TEC IN59698 0 2022 6 INV P 6,741.82 122421 266517 Runway DeIcer ACCOUNT TOTAL 12,301.13 76850110 449060 Dues & Memberships 012853 AMERICAN ASSOCIATION 1097775 0 2022 6 INV P 275.00 121721 266356 Annual Dues - Accou ACCOUNT TOTAL 275.00 76850110 455120 Misc Computer Hardware 090448 AMAZON MKTPLACE PMTS 396791 0 2022 6 INV P 9.59 PCARD P-Card invoice for ACCOUNT TOTAL 9.59 76850110 466070 Other Maintenance Supplies 010856 JET AIR INC IOW IVI-21-006704 0 2022 6 INV P 127.16 121721 266404 Maintenance Reimbur ACCOUNT TOTAL 127.16 76850110 467020 Equipment R&M Supplies 010647 CENTRAL PETROLEUM EQ 46881 0 2022 6 INV P 609.12 122421 266510 Fuel Cabinet Motor ACCOUNT TOTAL 609.12 ORG 76850110 TOTAL 19,543.82 ==================================================================================================================================== FUND 7600 Airport TOTAL: 19,543.82==================================================================================================================================== ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 22 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 1 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 Airport Operations _________________________________________ 76850110 321910 Misc Permits & 0 0 0 .00 .00 .00 .0% 76850110 331100 Federal Grants 0 0 0 -59,000.00 .00 59,000.00 100.0% 2022/06/120435 12/03/2021 CRP -59,000.00 REF 3614869 FAA 3-19-0047-033-2021 CARES 76850110 363910 Misc Sale of Me -260 0 -260 -510.00 .00 250.00 196.2% 76850110 369100 Reimb of Expens 0 0 0 .00 .00 .00 .0% 76850110 369900 Miscellaneous O 0 0 0 .00 .00 .00 .0% 76850110 381100 Interest on Inv -1,000 0 -1,000 143.83 .00 -1,143.83 -14.4%* 76850110 382100 Land Rental -50,090 0 -50,090 -13,208.96 .00 -36,881.04 26.4%* 2022/06/120462 12/17/2021 GBI -600.00 REF LAND RENT 76850110 382200 Building/Room R -280,000 0 -280,000 -141,499.42 .00 -138,500.58 50.5%* 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR # 19 RENT 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR RENT #54 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR RENT - #36 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR RENT #48 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR RENT - #47 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #13 2022/06/120462 12/17/2021 GBI -230.00 REF HANGAR #57 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #30 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #7 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #16 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #24 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #4 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #10 2022/06/120462 12/17/2021 GBI -235.00 REF HANGAR #46 2022/06/120462 12/17/2021 GBI -190.00 REF Hangar Rent #41 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #11 2022/06/120462 12/17/2021 GBI -149.00 REF Hangar #2 2022/06/120462 12/17/2021 GBI -358.00 REF HANGAR #33 2022/06/120462 12/17/2021 GBI -110.00 REF Office Rent (Bldg G) 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #5 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 23 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 2 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 382200 Building/Room R 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #38 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #27 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #39 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #8 2022/06/120462 12/17/2021 GBI -4,606.00 REF D, E, F, H 2022/06/120462 12/17/2021 GBI -500.00 REF Hangar M 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #1 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR #59 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR #60 2022/06/120462 12/17/2021 GBI -650.00 REF HANGAR #72 2022/06/120462 12/17/2021 GBI -187.75 REF AIRPORT RENTAL - HANGAR N 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #51 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #20 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #42 2022/06/120462 12/17/2021 GBI -4,824.00 REF HANGAR #35 2022/06/120462 12/17/2021 GBI -684.00 REF HANGAR #32 2022/06/120462 12/17/2021 GBI -325.00 REF HANGAR #34 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #9 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #53 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #18 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #3 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #14 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #40 2022/06/120462 12/17/2021 GBI -248.00 REF HANGAR #61 2022/06/120462 12/17/2021 GBI -235.00 REF HANGAR #55 2022/06/120462 12/17/2021 GBI -650.00 REF HANGAR #71 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR #63 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #49 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #37 2022/06/120462 12/17/2021 GBI -235.00 REF HANGAR #45 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #25 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #44 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #50 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #28 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #17 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR #6 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #22 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR #62 2022/06/120462 12/17/2021 GBI -230.00 REF HANGAR #58 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #43 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #23 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #21 2022/06/120462 12/17/2021 GBI -215.00 REF HANGAR #64 2022/06/120462 12/17/2021 GBI -404.00 REF HANGAR #31 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #12 2022/06/120462 12/17/2021 GBI -100.00 REF OFFICE SPACE RENT 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #26 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 24 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 3 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 382200 Building/Room R 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #29 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR #52 76850110 382300 Equipment Renta -6,750 0 -6,750 -1,422.00 .00 -5,328.00 21.1%* 2022/06/120491 12/17/2021 CRP -144.00 REF 3621846 JET AIR INC OTHER 76850110 384100 Telephone Commi 0 0 0 .00 .00 .00 .0% 76850110 384200 Vending Machine 0 0 0 .00 .00 .00 .0% 76850110 384900 Other Commissio -35,000 0 -35,000 -25,005.20 .00 -9,994.80 71.4%* 2022/06/120793 12/29/2021 CRP -5,465.20 REF 3631733 TITAN AVIATION FUELS OTHER 76850110 392100 Sale of Land 0 0 0 .00 .00 .00 .0% 76850110 392300 Sale of Equipme 0 0 0 .00 .00 .00 .0% 76850110 392400 Gain/Loss on Sa 0 0 0 .00 .00 .00 .0% 76850110 393120 General Levy 0 0 0 .00 .00 .00 .0% 76850110 393910 Misc Transfers 0 0 0 .00 .00 .00 .0% 76850110 411000 Perm Full Time 66,337 0 66,337 31,795.89 .00 34,541.11 47.9% 2022/06/120063 12/03/2021 PRJ 2,500.80 REF 112721 WARRANT=112721 RUN=1 BIWEEKLY 2022/06/120711 12/17/2021 PRJ 2,500.80 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY 2022/06/120824 12/30/2021 PRJ 2,500.80 REF 122521 WARRANT=122521 RUN=1 BIWEEKLY 76850110 412000 Perm Part Time 0 0 0 .00 .00 .00 .0% 76850110 413000 Temporary Emplo 991 0 991 123.69 .00 867.31 12.5% 2022/06/120711 12/17/2021 PRJ 52.50 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY 76850110 414500 Longevity Pay 650 0 650 650.00 .00 .00 100.0% 76850110 421100 Health Insuranc 6,956 0 6,956 3,698.40 .00 3,257.60 53.2% 2022/06/120063 12/03/2021 PRJ 308.20 REF 112721 WARRANT=112721 RUN=1 BIWEEKLY 2022/06/120711 12/17/2021 PRJ 308.20 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 25 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 4 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 421200 Dental Insuranc 399 0 399 190.56 .00 208.44 47.8% 2022/06/120063 12/03/2021 PRJ 15.88 REF 112721 WARRANT=112721 RUN=1 BIWEEKLY 2022/06/120711 12/17/2021 PRJ 15.88 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY 76850110 421300 Life Insurance 150 0 150 74.04 .00 75.96 49.4% 2022/06/120711 12/17/2021 PRJ 12.34 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY 76850110 421350 Group Life - Im 0 0 0 .00 .00 .00 .0% 76850110 421400 Disability Insu 242 0 242 118.68 .00 123.32 49.0% 2022/06/120711 12/17/2021 PRJ 19.78 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY 76850110 422100 FICA 5,131 0 5,131 2,461.67 .00 2,669.14 48.0% 2022/06/120063 12/03/2021 PRJ 188.46 REF 112721 WARRANT=112721 RUN=1 BIWEEKLY 2022/06/120711 12/17/2021 PRJ 192.59 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY 2022/06/120824 12/30/2021 PRJ 191.31 REF 122521 WARRANT=122521 RUN=1 BIWEEKLY 76850110 423100 IPERS 6,417 0 6,417 3,069.67 .00 3,346.88 47.8% 2022/06/120063 12/03/2021 PRJ 236.08 REF 112721 WARRANT=112721 RUN=1 BIWEEKLY 2022/06/120711 12/17/2021 PRJ 236.08 REF 121721 WARRANT=121721 RUN=1 BIWEEKLY 2022/06/120824 12/30/2021 PRJ 236.08 REF 122521 WARRANT=122521 RUN=1 BIWEEKLY 76850110 424900 Other Post Empl 0 0 0 .00 .00 .00 .0% 76850110 431020 Court Costs & S 139 0 139 .00 .00 139.00 .0% 76850110 432020 Annual Audit 474 0 474 .00 .00 474.00 .0% 76850110 432050 Appraisal Servi 0 0 0 .00 .00 .00 .0% 76850110 432080 Other Professio 0 0 0 2,300.00 .00 -2,300.00 100.0%* 2022/06/120403 12/14/2021 API 1,100.00 VND 013364 VCH BOLTON & MENK INC Solar Power RFP Assistance 28725 76850110 435055 Mail & Delivery 200 0 200 25.00 .00 175.00 12.5% 76850110 435056 Delivery Servic 0 0 0 .00 .00 .00 .0% Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 26 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 5 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 435057 Couriers 0 0 0 .00 .00 .00 .0% 76850110 435060 Legal Publicati 0 0 0 .00 .00 .00 .0% 76850110 436030 Transportation 750 0 750 402.24 .00 347.76 53.6% 76850110 436050 Registration 525 0 525 295.00 .00 230.00 56.2% 76850110 436060 Lodging 500 0 500 403.58 .00 96.42 80.7% 76850110 436070 Miscellaneous T 0 0 0 .00 .00 .00 .0% 76850110 436080 Meals 50 0 50 75.00 .00 -25.00 150.0%* 76850110 437010 Comp Liability 18,348 0 18,348 5,207.67 .00 13,140.33 28.4% 76850110 437020 Fire & Casualty 14,493 0 14,493 12,733.00 .00 1,760.00 87.9% 76850110 437030 Worker's Comp I 194 0 194 2,000.00 .00 -1,806.00 1030.9%* 76850110 437041 Bonding & Other 870 0 870 1,888.00 .00 -1,018.00 217.0%* 76850110 437200 Loss Reserve Pa 5,000 0 5,000 3,000.00 .00 2,000.00 60.0% 76850110 438010 Stormwater Util 19,416 0 19,416 9,469.32 .00 9,946.68 48.8% 2022/06/120384 12/15/2021 UBB 1,578.22 REF 211215 C -211215 4200 UB AR GEN 76850110 438030 Electricity 17,491 0 17,491 7,666.38 .00 9,824.62 43.8% 2022/06/120412 12/15/2021 API 281.26 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 2022/06/120412 12/15/2021 API 148.31 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 2022/06/120412 12/15/2021 API 75.45 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 2022/06/120412 12/15/2021 API 850.15 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 2022/06/120412 12/15/2021 API 77.68 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 27 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 6 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 438050 Landfill Use 0 0 0 2.16 .00 -2.16 100.0%* 76850110 438070 Heating Fuel/Ga 4,521 0 4,521 1,298.02 .00 3,222.98 28.7% 2022/06/120412 12/15/2021 API 98.93 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 2022/06/120412 12/15/2021 API 439.41 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 2022/06/120412 12/15/2021 API 401.68 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 76850110 438080 Sewer Utility C 1,921 0 1,921 706.27 .00 1,214.73 36.8% 2022/06/120384 12/15/2021 UBB 102.61 REF 211215 C -211215 2000 UB AR GEN 76850110 438090 Water Utility C 2,782 0 2,782 951.24 .00 1,830.76 34.2% 2022/06/120384 12/15/2021 UBB 139.40 REF 211215 C -211215 1000 UB AR GEN 76850110 438100 Refuse Collecti 2,560 0 2,560 1,359.00 .00 1,201.00 53.1% 2022/06/120320 12/07/2021 API 181.50 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Garbage Servi 266413 2022/06/120320 12/07/2021 API 45.00 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Recycling Ser 266413 76850110 438110 Local Phone Ser 1,064 0 1,064 .00 .00 1,064.00 .0% 76850110 438120 Long Distance S 0 0 0 .00 .00 .00 .0% 76850110 442010 Other Building 13,000 0 13,000 14,177.87 .00 -1,177.87 109.1%* 2022/06/120098 12/01/2021 API 674.40 VND 010358 VCH OVERHEAD DOOR COMPAN Hangar 41 Cable Replacement/Re 266288 2022/06/120400 12/01/2021 API 30.00 VND 013610 VCH STANDARD PEST CONTRO Pest Control Services VAR NOV 266459 2022/06/120403 12/14/2021 API 600.00 VND 010856 VCH JET AIR INC IOW Janitorial Services 266404 2022/06/120403 12/14/2021 API 189.15 VND 014647 VCH DAN'S OVERHEAD DOORS Hangar 56 Door Repair 28729 2022/06/120427 12/14/2021 API 138.82 VND 014647 VCH DAN'S OVERHEAD DOORS Hangar Door Repairs 28729 76850110 442020 Structure R&M S 1,256 0 1,256 504.59 .00 751.41 40.2% 76850110 442030 Heating & Cooli 1,876 0 1,876 474.88 .00 1,401.12 25.3% 76850110 442040 Cooling Equipme 0 0 0 .00 .00 .00 .0% Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 28 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 7 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 442060 Electrical & Pl 4,555 0 4,555 2,315.62 .00 2,239.38 50.8% 2022/06/120403 12/14/2021 API 202.10 VND 010856 VCH JET AIR INC IOW Maintenance Reimbursement 266404 2022/06/120403 12/14/2021 API 147.00 VND 010014 VCH ADVANCED ELECTRICAL Replace Fuse on Beacon Tower 28717 2022/06/120403 12/14/2021 API 166.50 VND 010564 VCH LYNCH'S PLUMBING INC Replace pressure tank - Hangar 266422 2022/06/120634 12/21/2021 API 270.48 VND 010014 VCH ADVANCED ELECTRICAL Replace Front Facade lights to 28769 2022/06/120634 12/21/2021 API 104.00 VND 010564 VCH LYNCH'S PLUMBING INC Sink Drain cleanout 266561 76850110 442070 Bldg Pest Contr 0 0 0 .00 .00 .00 .0% 76850110 443050 Radio Equipment 0 0 0 .00 .00 .00 .0% 76850110 443080 Other Equipment 10,232 0 10,232 3,489.42 .00 6,742.58 34.1% 76850110 444060 Cable & Electri 0 0 0 .00 .00 .00 .0% 76850110 445030 Nursery Srvc-La 50,000 0 50,000 33,000.00 .00 17,000.00 66.0% 76850110 445080 Snow and Ice Re 30,000 0 30,000 12,301.13 .00 17,698.87 41.0% 2022/06/120403 12/14/2021 API 5,500.00 VND 010856 VCH JET AIR INC IOW Groundskeeping/Snow Removal/Ma 266404 2022/06/120403 12/14/2021 API 59.31 VND 010856 VCH JET AIR INC IOW Maintenance Reimbursement 266404 2022/06/120634 12/21/2021 API 6,741.82 VND 013997 VCH CRYOTECH DEICING TEC Runway DeIcer 266517 76850110 445100 Towing 0 0 0 .00 .00 .00 .0% 76850110 445110 Testing Service 1,000 0 1,000 354.50 .00 645.50 35.5% 76850110 445140 Outside Printin 0 0 0 .00 .00 .00 .0% 76850110 445230 Other Operating 1,448 0 1,448 528.99 .00 919.01 36.5% 76850110 446010 Administrative 0 0 0 .00 .00 .00 .0% 76850110 446100 City Attorney C 7,642 0 7,642 3,821.02 .00 3,820.98 50.0% 2022/06/120530 12/31/2021 GEN 636.83 REF REJE#2 Airport to Attorney Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 29 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 8 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 446120 ITS-Server/Stor 641 0 641 508.69 .00 132.31 79.4% 2022/06/120859 12/31/2021 GNI 49.14 REF AO Storage of files AIR 2022/06/120861 12/31/2021 GNI 6.00 REF AO DUO Two Factor 2022/06/120863 12/31/2021 GNI 34.72 REF AO Storage of Email 76850110 446130 ITS-PC/Peripher 14,478 0 14,478 7,980.00 .00 6,498.00 55.1% 2022/06/120874 12/31/2021 GNI 1,316.50 REF AO DEC ITS Repl Chgbk 76850110 446140 ITS-Capital Rep 0 0 0 .00 .00 .00 .0% 76850110 446150 ITS-Application 0 0 0 .00 .00 .00 .0% 76850110 446160 ITS-Infrastuctu 8,761 0 8,761 .00 .00 8,761.00 .0% 76850110 446190 ITS-Software SA 233 0 233 114.60 .00 118.40 49.2% 2022/06/120864 12/31/2021 GNI 19.40 REF AO Office software 76850110 446200 Photocopying Ch 565 0 565 144.94 .00 420.06 25.7% 76850110 446220 Phone Service C 0 0 0 .00 .00 .00 .0% 76850110 446300 Phone Equipment 1,410 0 1,410 685.50 .00 724.50 48.6% 2022/06/120872 12/31/2021 GNI 112.50 REF AO CH DEC PHONE ASSET CHARGE 2022/06/120873 12/31/2021 GNI .45 REF AO CH DEC LONG DISTANCE CHARGES 76850110 446320 Mail Chargeback 0 0 0 .70 .00 -.70 100.0%* 76850110 446350 City Vehicle Re 25,051 0 25,051 17,788.98 .00 7,262.02 71.0% 2022/06/120898 12/31/2021 GNI 2,964.83 REF TLW DEC REPLACEMENT COST 76850110 446360 City Vehicle Re 0 0 0 .00 .00 .00 .0% Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 30 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 9 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 446370 Fuel Chargeback 3,875 0 3,875 1,837.01 .00 2,037.99 47.4% 2022/06/120898 12/31/2021 GNI 321.16 REF TLW DEC DIVISION FUEL 76850110 446380 Vehicle R&M Cha 12,303 0 12,303 1,828.30 .00 10,474.70 14.9% 2022/06/120898 12/31/2021 GNI 233.98 REF TLW DEC DIVISION SERVICE 76850110 448040 City Sponsored 0 0 0 .00 .00 .00 .0% 76850110 449055 Permitting Fees 265 0 265 .00 .00 265.00 .0% 76850110 449060 Dues & Membersh 1,250 0 1,250 275.00 .00 975.00 22.0% 2022/06/120403 12/14/2021 API 275.00 VND 012853 VCH AMERICAN ASSOCIATION Annual Dues - Account number 2 266356 76850110 449120 Equipment Renta 500 0 500 923.25 .00 -423.25 184.7%* 76850110 449280 Misc Services & 0 0 0 .00 .00 .00 .0% 76850110 449350 Meals (non-trav 0 0 0 .00 .00 .00 .0% 76850110 449360 Interest Expens 0 0 0 .00 .00 .00 .0% 76850110 449370 Depreciation Ex 0 0 0 .00 .00 .00 .0% 76850110 452010 Office Supplies 100 0 100 41.35 .00 58.65 41.4% 76850110 452030 Minor Office Eq 0 0 0 .00 .00 .00 .0% 76850110 452040 Sanitation & In 0 0 0 .00 .00 .00 .0% 76850110 454020 Subscriptions 334 0 334 416.00 .00 -82.00 124.6%* 76850110 455110 Software 0 0 0 .00 .00 .00 .0% Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 31 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 10 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 455120 Misc Computer H 0 0 0 9.59 .00 -9.59 100.0%* 2022/06/120904 12/21/2021 API 9.59 VND 090448 VCH AMAZON MKTPLACE PMTS P-Card invoice for statement c 76850110 461040 Other Agricultu 0 0 0 .00 .00 .00 .0% 76850110 461050 Other Agricultu 0 0 0 .00 .00 .00 .0% 76850110 466040 Plumbing Suppli 0 0 0 .00 .00 .00 .0% 76850110 466050 Electrical Supp 0 0 0 .00 .00 .00 .0% 76850110 466070 Other Maintenan 1,404 0 1,404 318.51 .00 1,085.49 22.7% 2022/06/120403 12/14/2021 API 127.16 VND 010856 VCH JET AIR INC IOW Maintenance Reimbursement 266404 76850110 467020 Equipment R&M S 200 0 200 2,472.54 .00 -2,272.54 1236.3%* 2022/06/120634 12/21/2021 API 609.12 VND 010647 VCH CENTRAL PETROLEUM EQ Fuel Cabinet Motor repairs 266510 76850110 467160 Other Vehicle R 0 0 0 .00 .00 .00 .0% 76850110 468030 Asphalt 0 0 0 .00 .00 .00 .0% 76850110 468050 Sand 0 0 0 .00 .00 .00 .0% 76850110 469040 Traffic Cntrl I 0 0 0 .00 .00 .00 .0% 76850110 469190 Minor Equipment 500 0 500 .00 .00 500.00 .0% 76850110 469200 Tools 500 0 500 74.18 .00 425.82 14.8% 76850110 469210 First Aid/Safet 308 0 308 1,321.95 .00 -1,013.95 429.2%* Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 32 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 11 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 469260 Fire Ext & Refi 0 0 0 .00 .00 .00 .0% 76850110 469290 Purchases For R 0 0 0 .00 .00 .00 .0% 76850110 469320 Miscellaneous S 0 0 0 26.47 .00 -26.47 100.0%* 76850110 469360 Food and Bevera 0 0 0 .00 .00 .00 .0% 76850110 469999 PCard Reconcili 0 0 0 .00 .00 .00 .0% 76850110 473010 Contracted Impr 0 0 0 .00 .00 .00 .0% 76850110 473020 Non-Contracted 0 0 0 .00 .00 .00 .0% 76850110 474240 Tractors 0 0 0 .00 .00 .00 .0% 76850110 475010 Furniture & Off 0 0 0 .00 .00 .00 .0% 76850110 476070 PC Hardware 0 0 0 .00 .00 .00 .0% 76850110 490040 Capital Project 0 0 0 .00 .00 .00 .0% 76850110 490150 Operating Subsi 0 0 0 .00 .00 .00 .0% 76850110 490190 Interfund Loan 0 0 0 .00 .00 .00 .0% 651 Fly Iowa 2014 _________________________________________ 76850110 362100 651 Contrib & Do 0 0 0 .00 .00 .00 .0% 76850110 432080 651 Other Profes 0 0 0 .00 .00 .00 .0% 2022/06/120403 12/14/2021 API 1,100.00 VND 013364 VCH BOLTON & MENK INC Solar Power RFP Assistance 28725 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 33 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 12 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 436030 651 Transportati 0 0 0 .00 .00 .00 .0% 76850110 436060 651 Lodging 0 0 0 .00 .00 .00 .0% 76850110 437010 651 Comp Liabili 0 0 0 .00 .00 .00 .0% 76850110 438100 651 Refuse Colle 0 0 0 .00 .00 .00 .0% 2022/06/120320 12/07/2021 API 181.50 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Garbage Servi 266413 2022/06/120320 12/07/2021 API 45.00 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Recycling Ser 266413 76850110 445140 651 Outside Prin 0 0 0 .00 .00 .00 .0% 76850110 449100 651 Vehicle Rent 0 0 0 .00 .00 .00 .0% 76850110 449120 651 Equipment Re 0 0 0 .00 .00 .00 .0% 76850110 465010 651 Other Fluids 0 0 0 .00 .00 .00 .0% 76850110 469320 651 Miscellaneou 0 0 0 .00 .00 .00 .0% 652 100 Year Anniversary Celebration _________________________________________ 76850110 363910 652 Misc Sale of 0 0 0 .00 .00 .00 .0% 76850110 432080 652 Other Profes 0 0 0 .00 .00 .00 .0% 2022/06/120403 12/14/2021 API 1,100.00 VND 013364 VCH BOLTON & MENK INC Solar Power RFP Assistance 28725 76850110 437010 652 Comp Liabili 0 0 0 .00 .00 .00 .0% 76850110 438100 652 Refuse Colle 0 0 0 .00 .00 .00 .0% 2022/06/120320 12/07/2021 API 181.50 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Garbage Servi 266413 2022/06/120320 12/07/2021 API 45.00 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Recycling Ser 266413 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 34 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 13 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ACCOUNTS FOR:ORIGINAL TRANFRS/REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ 76850110 445140 652 Outside Prin 0 0 0 .00 .00 .00 .0% 76850110 449120 652 Equipment Re 0 0 0 .00 .00 .00 .0% 76850110 466070 652 Other Mainte 0 0 0 .00 .00 .00 .0% 2022/06/120403 12/14/2021 API 127.16 VND 010856 VCH JET AIR INC IOW Maintenance Reimbursement 266404 76850110 469290 652 Purchases Fo 0 0 0 .00 .00 .00 .0% 76850110 469360 652 Food and Bev 0 0 0 .00 .00 .00 .0% 907 Wind Storm 8/10/20 _________________________________________ 76850110 466070 907 Other Mainte 0 0 0 .00 .00 .00 .0% 2022/06/120403 12/14/2021 API 127.16 VND 010856 VCH JET AIR INC IOW Maintenance Reimbursement 266404 TOTAL Airport Operations -843 0 -843 -40,801.69 .00 39,959.05 4842.1% TOTAL Airport -843 0 -843 -40,801.69 .00 39,959.05 4842.1% TOTAL REVENUES -373,100 0 -373,100 -240,501.75 .00 -132,598.25 TOTAL EXPENSES 372,257 0 372,257 199,700.06 .00 172,557.30 PRIOR FUND BALANCE 63,719.34 CHANGE IN FUND BALANCE - NET OF REVENUES/EXPENSES 40,801.69 REVISED FUND BALANCE 104,521.03 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 35 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 14 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL FOR 2022 06 JOURNAL DETAIL 2022 6 TO 2022 6 ORIGINAL TRANFRS/REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ GRAND TOTAL -843 0 -843 -40,801.69 .00 39,959.05 4842.1% ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 36 of 37 01/11/2022 11:13 |CITY OF IOWA CITY |P 15 mtharp |YEAR-TO-DATE BUDGET REPORT |glytdbud DECEMBER DETAIL REPORT OPTIONS ____________________________________________________________________________________________________________________________________ Field # Total Page Break Sequence 1 1 Y Y Sequence 2 9 Y N Sequence 3 12 N N Sequence 4 0 N N Report title: YEAR-TO-DATE BUDGET REPORT Includes accounts exceeding 0% of budget. Print totals only: N Year/Period: 2022/ 6 Print Full or Short description: F Print MTD Version: N Print full GL account: N Format type: 1 Roll projects to object: Y Double space: N Carry forward code: 1 Suppress zero bal accts: N Include requisition amount: N Print Revenues-Version headings: N Print revenue as credit: Y Print revenue budgets as zero: N Include Fund Balance: Y Print journal detail: Y From Yr/Per: 2022/ 6 To Yr/Per: 2022/ 6 Include budget entries: Y Incl encumb/liq entries: Y Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Multiyear view: D Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Org 76850110 Object Project Rollup code Account type Account status Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 37 of 37