The URL can be used to link to this page

Home My WebLink About01-13-2022 Airport CommissionIOWA 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 2. Approval of Minutes from the following meetings: December 9, 2021 3. Public Comment - Items not on the agenda 4. Items for Discussion / Action: a. Airport Signage/Wayfinding b. FAA/IDOT Projects: 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 min* 2 min 5 min 5 min 30 min 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" 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 i. Jet Air 1. Jet Air Outlook Plan e. Commission Members' Reports f. Staff Report 5. Set next regular meeting for February 10, 2022 6. Adjourn 45 min fi[il11171 2 min 2 min *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 @io wa-city. org. Early requests are strongly encouraged to allow sufficient time to meet your access needs. Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 2 of 37 December 9, 2021 Page 1 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 appliqued 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 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 3 of 37 December 9, 2021 Page 2 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 7125 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 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. December 9, 2021 Page 3 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 4 of 37 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 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. December 9, 2021 Page 4 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 5 of 37 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 Ibs 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 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 6 of 37 December 9, 2021 Page 5 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 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. December 9, 2021 Page 6 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 7 of 37 Airport Commission ATTENDANCE RECORD 2021 TERM Q N o j 0 N 0 W 0 A 0 Cn 0 to 0 rn 0 -4 0 -4 0 0 0 m o N Oo N Q N A > i > Q Q co Q Q W � W � Q Q Q co -A Cn -AQ N Q w N j c0 Q co NAME EXP. N N N N N N N N N N N N N N N N N N Q Q Q Q i i i i 3 i i i Warren 06/30/22 X X Bish X X X X X X X X X X X X O/E X X X op 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 06/30/25 X Lawr X X X X X X X X X X O/E X X X X X O/E ence Hellecktra 06/30/24 X Oroz X O/E X X X X X X/E O/E X X O/E O/E X X X X co 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 These minutes represent only a reasonably accurate summary of the meeting of the Iowa City Airport Commission, December 9, 2021. Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 8 of 37 Prepared by: Michael Tharp, Airport Manager, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 Resolution number Resolution accepting the work for the Obstruction Mitigation Project (Phase 1) Whereas, our engineering consultant, AECOM, has reported that the work associated with this project has been completed by Rathje Construction Co. of Marion, Iowa, and has recommended that the work be accepted as complete; and Whereas, the final contract price is $ 454,845.84, which is established from the original contract cost of $496,770.00 and change order #1 which removed trees which were trimmed by property owners in lieu of removal, and other quantity adjustments. Now, therefore, be it resolved by the Iowa City Airport Commission: 1. Said improvements are hereby accepted by the Iowa City Airport Commission. Passed and approved this day of 2022• Chairperson Approved by Attest: i Secretary Cty Att rney's Office It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent Bishop Clair Lawrence Orozco Pfohl Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 9 of 37 A SCOM Imagine it. Ali Delivered. Mr. Scott Clair Airport Commission Chair Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 SUBJECT: Obstruction Removals — Phase 1 Iowa City Municipal Airport FAA AIP Project No. 3-19-0047-027 AECOM ID No. 60597183 Dear Mr. Clair, By this letter, we hereby state: AECOM 500 SW 7th Street Des Moines IA, 50309 USA aecom.com January 11, 2022 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. The total cost of the completed work is $ 454,845.84. I hereby certify that this engineering document was prepared by me or ` oFEss;o'V`, under my lrect personal that I am a licensed Professional Engineer underpthelsion laws of the the state of lowly = z DAVID B. .0 signed b Hughes, David (Des Hughes, David (Des Digitally 9 y 9 W: HUGHES i— Moines) Moines) u 13037 : T = Date:2022.01.11 13:17:40 06'00' •� David B. Hughes Date lowP. License No. 13037 My license renewal date is December 31, 2023. Pages or sheets covered by this seal: Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 10 of 37 Prepared by: Michael Tharp, Airport Manager, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 Resolution number Resolution accepting the work for the Obstruction Mitigation Project (Phase 2) Whereas, our engineering consultant, AECOM, has reported that the work associated with this project has been completed by Rathje Construction Co. of Marion, Iowa, and has recommended that the work be accepted as complete; and Whereas, the final contract price is $ 220,250.00, which is established from the original contract cost of $208,680.00 and change orders 1 and 2 totaling $11,570.00 which added additional trees to remove and reflect final quantities of materials used. Now, therefore, be it resolved by the Iowa City Airport Commission: 1. Said improvements are hereby accepted by the Iowa City Airport Commission. Passed and approved this day of , 2022. Chairperson Approvedby Attest: Secretary City Attarney's Office It was moved by and seconded by the Resolution be adopted, and upon roll call there were: Ayes Nays Absent Bishop Clair Lawrence Orozco Pfohl Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 11 of 37 ` _=COW ° ,I' ` _=CDW ` _=COW ° ,I'N_=COW 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: AECOM 500 SW 7th Street Des Moines IA, 50309 USA aecom.com January 11, 2022 We have made a final review of the project and recommend acceptance. 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. The total cost of the completed work is $ 220,250.00. r � ��°°°��° hereby certify a Is engineering document was prepare y me or ~, . under my direct personal supervision and that I am a duly licensed a o,. Professional Engineer under the laws of the state of Iowa. ,.....,... Hughes, David (Des Digitally signed by Hughes, David ;ter °-, VO = i (Des Moines) Moines 1 i 1 Date: 2022.01.11 13:14:02 -06'00' David B. Hughes Date � ` -x License No. 13037 My license renewal date is December 31, 2023. Pages or sheets covered by this seal: Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 12 of 37 Prepared by: Michael Tharp, Airport Manager, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 356-5045 Resolution number Resolution setting a public hearing on February 10, 2022 for the plans, specifications, form of contract, and estimate on cost for the construction of "Runway 7/25 Rehabilitation East End" project, and directing City Clerk to publish notice of said hearing, and directing the Chairperson to place said plans on file for public inspection. Be it resolved by the Airport Commission of the City of Iowa City: 1. That a public hearing on the plans, specifications, form of contract, and estimate of cost for the construction of the above -mentioned project is to be held on the 10th day of February, 2022 at 6:00 p.m. in the Iowa City Airport Terminal Building, 1801 S. Riverside Drive, Iowa City, Iowa, or if said meeting is cancelled, at the next meeting of the Airport Commission thereafter as posted by the City Clerk. If the meeting is held electronically due to health and safety concerns from COVID-19, the meeting will be an electronic meeting using Zoom Meetings. 2. That the City Clerk is hereby authorized and directed to publish notice of the public hearing for the above -named project in a newspaper published at least once weekly and having a general circulation in the City, not less that four (4) nor more than twenty (20) days before said hearing. 3. That the copy of plans, specifications, form of contract, and estimate of cost for the construction of the above -named project is hereby ordered placed on file by the Chairperson in the office of the City Clerk for public inspection Passed and approved this day of 2022. Approved By: Chairperson Attest:''°"' Secretary City Attorney's Office Bishop Clair Lawrence Orozco Pfohl Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 13 of 37 Prepared by: Michael Tharp, Airport Manager, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 Resolution number: Resolution accepting bids and awarding contract for the "Runway 25 Threshold Relocation" project. Whereas, Neumiller Electric, Inc. of Tiffin, Iowa has submitted the lowest responsive bid of $440,811.30 and; Whereas, the Iowa City Airport Commission desires to award the alternate bid items which called for remarking and relighting the entire runway, and install lights without heating elements for an additional amount of $35,742.60. Now, therefore, be it resolved by the Iowa City Airport Commission: 1. The bids for the above -named project are accepted. 2. The contract for the construction of the above -named project is hereby awarded to Neumiller Electric, Inc. subject to the conditions: a. That awardee secures adequate performance and payment bond, insurance certificates, and contract compliance program statements. b. Concurrence in the award by the Federal Aviation Administration. 3. The Chairperson is hereby authorized to sign and the Secretary to attest the contract for construction of the above -named project, subject to the condition that awardee secure adequate performance and payment bond, insurance certificates, and contract compliance program statements upon instruction from legal counsel. Passed and approved this day of Chairperson Attest: Secretary Approved by: C y Attarney's Office It was moved by and seconded by Resolution be adopted, and upon roll call there were: Ayes Nays Absent 2022. Bishop Clair Lawrence Orozco Pfohl the Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 QBOLTON { & MENK Real People. Real Solutions. January 7, 2022 Mr. Scott Clair, Chairman, Iowa City Airport Commission City of Iowa City 410 East Washington Street Iowa City, IA 52240 RE: Runway 7/25 Threshold Relocation Recommendation of Award Project No.: FAA AIP No. 3-19-0047-030-2022 Dear Mr. Clair: Page 14 of 37 401 1st St SE Suite 201 Cedar Rapids, IA 52401 Ph: (319) 362-3219 Bolton-Menk.com At 3:00 PM on January 6, 2022, bids were received for the Runway 7/25 Threshold Relocation project. The Engineer's Opinion of Probable Cost for the base bid of the project was $568,846.40. Three bids were received, all bidders were responsive, and bids for the base bid and all bid alternates are summarized as follows: Bidder Base Bid Bid Alt. 'A' Bid Alt "B' Bid Alt. 'C' Total— Base Bid & All Bid Alternates Engineer's Opinion of Probable Cost $568,846.40 $35,224.00 $40,000.00 ($6,390.00) $637,680.40 Neumiller Electric, Inc., Tiffin, IA $440,811.30 $18,492.60 $20,800.00 ($3,550.00) $476,553.90 Voltmer, Inc., Decorah, IA $514,003.64 $18,492.60 $22,232.00 ($3,736.73) $550,991.51 Advanced Electrical Services, Inc., Iowa City, IA $709,659.40 $18,492.60 $26,400.00 ($3,550.00) $751,002.00 The bid received from Neumiller Electric, Inc. of Tiffin Iowa was 25.25% below the Engineer's Opinion of Probable Cost for the project (including all bid alternates), and was determined to be the lowest responsive, responsible bidder. Bolton & Menk, Inc. has reviewed bid documents submitted, checked references on this bidder, and is satisfied with responses given. Prices bid for all bid alternates were extremely competitive. Therefore, Bolton & Menk, Inc. recommends award of the Runway 7/25 Threshold Relocation project to Neumiller Electric, Inc. of Tiffin,lowa, for the total of the Base Bid and all bid alternates (bid alternates 'A', 'B', and 'C') for the total bid amount of $476,553.90 (Four Hundred Seventy -Six Thousand, Five Hundred Fifty -Three and 90/100 Dollars), based on FAA concurrence and available funding. The bid tabulation is attached for your use. Feel free to contact me should there be any questions related to this project. Sincerely, Carl L. Byers, P.E. Aviation Project Manager BOLTON & MENK, INC. cc: Bid Tabulation Bolton & Menk is an equal opportunity employer. Iowa City, IA Airport Commission Age I P Iowa City Municipal Airport Meeting Date: Jar1 fTON Page 15 of 37401 Suite 201 Runway 7/25 Threshold Relocation & M E N K Cedar Rapids, IA 52401 TABULATION OF BIDS Bid Letting Date: Thursday January 6, 2022 @ 3:00 PM CST BASE BID Real People. Real Solutions. Apparent Low Bidder Ph:(3191362-3219 Bolton-Menk.com Line No. Description Unit Quantity Engineer's Opinion of Probable Cost Neumiller Electric, Inc. Tiffin, IA Voltmer, Inc. Decorah, IA Advanced Electrical Services, Inc. Iowa City, IA Unit Price Amount Unit Price Amount Unit Price Amount Unit Price Amount 1 CONSTRUCTION SURVEY LS 1 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 15,000.00 $ 15,000.00 $ 10,000.00 $ 10,000.00 2 MOBILIZATION LF 1 $ 25,000.00 $ 25,000.00 $ 25,000.00 $ 25,000.00 $ 32,400.00 $ 32,400.00 $ 65,000.00 $ 65,000.00 3 TRAFFIC CONTROL LS 1 $ 15,000.00 $ 15,000.00 $ 15,000.00 $ 15,000.00 $ 9,000.00 $ 9,000.00 $ 6,600.00 $ 6,600.00 4 REMOVE RUNWAY EDGE AND THRESHOLD LIGHTS EA 40 $ 200.00 $ 8,000.00 $ 250.00 $ 10,000.00 $ 300.00 $ 12,000.00 $ 350.00 $ 14,000.00 5 REMOVE PAPI SYSTEM EA 1 $ 18,000.00 $ 18,000.00 $ 11,480.00 $ 11,480.00 $ 11,800.00 $ 11,800.00 $ 13,500.00 $ 13,500.00 6 REMOVAL REIL SYSTEM EA 1 $ 2,500.00 $ 2,500.00 $ 2,000.00 $ 2,000.00 $ 1,400.00 $ 1,400.00 $ 3,000.00 $ 3,000.00 7 REMOVE PAVEMENT MARKING SF 41,123 $ 2.00 $ 82,246.00 $ 1.00 $ 41,123.00 $ 1.00 $ 41,123.00 $ 1.10 $ 45,235.30 8 PAVEMENT MARKING, SOLID WHITE, WITH BEADS SF 49,635 $ 2.00 $ 99,270.00 $ 1.05 $ 52,116.75 $ 1.05 $ 52,116.75 $ 1.05 $ 52,116.75 9 PAVEMENT MARKING, SOLID YELLOW, WITH BEADS SF 1,276 $ 2.00 $ 2,552.00 $ 1.05 $ 1,339.80 $ 1.05 $ 1,339.80 $ 1.05 $ 1,339.80 10 PAVEMENT MARKING, BLACK OUTLINE, NO BEADS SF 13,915 $ 2.00 $ 27,830.00 $ 1.05 $ 14,610.75 $ 1.05 $ 14,610.75 $ 1.05 $ 14,610.75 11 CRUSHED ROCK BASE, 4" THICK (PAPI ACCESS ROAD) SY 350 $ 12.00 $ 4,200.00 $ 20.00 $ 7,000.00 $ 11.00 $ 3,850.00 $ 10.00 $ 3,500.00 12 CONCRETE PAVEMENT, 5" THICK (PAPI ACCESS ROAD) SY 350 $ 55.00 $ 19,250.00 $ 90.00 $ 31,500.00 $ 62.00 $ 21,700.00 $ 60.00 $ 21,000.00 13 TRENCHING FOR ELECTRICAL CONDUIT LF 5,874 $ 2.50 $ 14,685.00 $ 2.00 $ 11,748.00 $ 1.60 $ 9,398.40 $ 7.50 $ 44,055.00 14 ELECTRICAL CONDUIT, 2", BORED IN PLACE LF 700 $ 30.00 $ 21,000.00 $ 10.00 $ 7,000.00 $ 19.60 $ 13,720.00 $ 35.00 $ 24,500.00 15 NO. 8 AWG, 5KV, L-824, TYPE C CABLE, INSTALLED IN TRENCH, DUCT BANK OR CONDUIT LF 6,434 $ 1.80 $ 11,581.20 $ 2.50 $ 16,085.00 $ 1.85 $ 11,902.90 $ 2.20 $ 14,154.80 16 NO. 6 AWG, SOLID, BARE COUNTERPOISE WIRE, INSTALLED IN TRENCH, INCLUDING GROUND RODS AND GROUND CONNECTORS LF 5,874 $ 1.801 10,573.20 $ 3.00 $ 17,622.00 $ 1.50 $ 8,811.00 $ 4.50 $ 26,433.00 17 NON -ENCASED ELECTRICAL CONDUIT, 2" PVC/HDPE, IN TRENCH LF 5,874 $ 3.50 $ 20,559.00 $ 7.00 $ 41,118.00 $ 3.46 $ 20,324.04 $ 11.00 $ 64,614.00 18 ELECTRICAL HANDHOLE, L-867, SIZE B EA 29 $ 800.00 $ 23,200.00 $ 1,200.00 $ 34,800.00 $ 752.00 $ 21,808.00 $ 1,000.00 $ 29,000.00 19 L-861 RUNWAY EDGE LIGHT, BASE -MOUNTED EA 23 $ 1,200.00 $ 27,600.00 $ 1,700.00 $ 39,100.00 $ 2,190.00 $ 50,370.00 $ 2,200.00 $ 50,600.00 20 L-861E RUNWAY THRESHOLD LIGHT, BASE -MOUNTED EA 8 $ 1,200.00 $ 9,600.00 $ 1,500.00 $ 12,000.00 $ 1,386.00 $ 11,088.00 $ 1,900.00 $ 15,200.00 21 L-861SE RUNWAY THRESHOLD LIGHT, BASE -MOUNTED EA 8 $ 1,400.00 $ 11,200.00 $ 1,500.00 $ 12,000.00 $ 1,795.00 $ 14,360.00 $ 2,400.00 $ 19,200.00 22 L-880 PAPI SYSTEM, COMPETE, INSTALL FAA-FURNSHED SYSTEM LS 1 $ 90,000.00 $ 90,000.00 $ 18,168.00 $ 18,168.00 $ 118,823.00 $ 118,823.00 $ 148,000.00 $ 148,000.00 23 L-8491 REIL SYSTEM, COMPLETE, IN PLACE EA 1 $ 17,000.001 $ 17,000.00 $ 12,000.00 1 $ 12,000.00 $ 17,058.00 $ 17,058.00 $ 24,000.00 $ 24,000.00 TOTAL- BASE BID 1 $ 568,846.40 $ 440,811.30 $ 514,003.64 $ 709,659.40 BID ALTERNATE 'A' Al PAVEMENT MARKING, SOLID WHITE, WITH BEADS I SF 14,969 1 $ 2.00 $ 29,938.00 1 $ 1.05 1 $ 15,717.45 1 $ 1.05 1 $ 15,717.45 1 $ 1.05 1 $ 15,717.45 A2 PAVEMENT MARKING, BLACK OUTLINE, NO BEADS SF 2,643 $ 2.00 $ 5,286.00 $ 1.05 $ 2,775.15 $ 1.05 $ 2,775.15 $ 1.05 $ 2,775.15 TOTAL - BIDALTERNATE'A' $ 35,224.00 $ 18,492.60 $ 18,492.60 $ 18,492.60 BID ALTERNATE 'B' Bl L-861 LED RUNWAY EDGE LIGHT, INSTALL NEW FIXTURE ON EXISTING BASE EA 1 24 1,200.00 $ 28,800.00 $ 650.00 1 $ 15,600.00 1 $ 597.00 1 $ 14,328.00 1 $ 700.00 1 $ 16,800.00 B2 L-861SE LED RUNWAY THRESHOLD LIGHT, NEW FIXTURE ON EXISTING BASE EA 1 8 1 $ 1,400.001 $ 11,200.00 1 $ 650.00 1 $ 5,200.00 1 $ 988.00 1 $ 7,904.00 1 $ 1,200.00 1 $ 9,600.00 TOTAL - BID ALTERNATE W 1 $ 40,000.001 $ 20,800.00 1 $ 22,232.00 1 $ 26,400.00 BID ALTERNATE 'C' C1 DELETE HEATERS FROM LED LIGHTS I EA 1 71 1 $ (90.00) $ (6,390.001) $ (50.00) $ (3,550.00) $ (52.63) $ (3,736.73) $ (50.00) $ (3,550.00) TOTAL - BID ALTERNATE 'C' $ (6,390.00) $ (3,550.00) $ (3,736.73) $ (3,550.00) TOTAL - BASE BID AND BID ALTERNATES'A','B', AND 'C' $ 637,680.40 1 $ 476,553.90 1 $ 550,991.51 $ 751,002.00 I hereby certify that this is a true and correct tabulation of bids received and opened on January 6, 2022 for the "Runway 7/25 Threshold Relocation" project at the Iowa City Municipal Airport, Iowa City, Iowa Carl L. Byers, P.E. low Reg. No. 12845 H:\IACYIA\T51122513\6_Plans-Specs\A_Bid Documents\Rwy 25 Threshold Relocation\Bid Docs\2022-01-07 -Threshold Relocation - Bid Tabulation.xlsx Page 1 of 1 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 16 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 17 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 % mile 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 18 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 19 of 37 The vision also Included components of the unique history of the Iowa City Airport which celebrated its 100t" Anniversary in 2018: Rik First flight in Iowa City, 1910 Transcontinental airmail, 1918 l Commercial passenger, 1927 �S 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. Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 Page 20 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 FV 6.601-0 a tyler erp solution 0000 01/11/2022 11:11 ICITY OF IOWA CITY IP 1 mtharp JINVOICE LIST BY GL ACCOUNT lapinvgla 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 ACCOUNT TOTAL 1,100.00 76850110 438030 Electricity 010319 MIDAMERICAN ENERGY 20211215094233 0 2022 6 INV P 1,432.85 121721 ACCOUNT TOTAL 1,432.85 76850110 438070 Heating Fuel/Gas 010319 MIDAMERICAN ENERGY 20211215094233 0 2022 6 INV P 940.02 121721 ACCOUNT TOTAL 940.02 76850110 438100 Refuse Collection Charges 010507 JOHNSON COUNTY REFUS LRS-200332 0 2022 6 INV P 181.50 121721 010507 JOHNSON COUNTY REFUS LRS-200334 0 2022 6 INV P 45.00 121721 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 010856 JET AIR INC IOW IVI-21-006706 0 2022 6 INV P 600.00 121721 013610 STANDARD PEST CONTRO 47432 0 2022 6 INV P 30.00 121721 014647 DAN'S OVERHEAD DOORS 526755 0 2022 6 INV P 138.82 121721 014647 DAN'S OVERHEAD DOORS 527245 0 2022 6 INV P 189.15 121721 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 010014 ADVANCED ELECTRICAL 64105 0 2022 6 INV P 270.48 122421 417.48 010564 LYNCH'S PLUMBING INC 30537 0 2022 6 INV P 166.50 121721 010564 LYNCH'S PLUMBING INC 30597 0 2022 6 INV P 104.00 122421 270.50 010856 JET AIR INC IOW IVI-21-006704 0 2022 6 INV P 202.10 121721 ACCOUNT TOTAL 890.08 28725 Solar Power RFP Ass 28743 MidAmBilling 121520 28743 MidAmBilling 121520 266413 DEC FY22 Monthly Ga 266413 DEC FY22 Monthly Re 266288 Hangar 41 Cable Rep 266404 Janitorial Services 266459 Pest Control Servic 28729 Hangar Door Repairs 28729 Hangar 56 Door Repa 28717 Replace Fuse on Bea 28769 Replace Front Facad 266422 Replace pressure to 266561 Sink Drain cleanout 266404 Maintenance Reimbur Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 01/11/2022 11:11 ICITY OF IOWA CITY mtharp JINVOICE LIST BY GL ACCOUNT YEAR/PERIOD: 2022/6 TO 2022/6 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S ••:,:�. m u n i s- • a tyler erp solutionapinvgla 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 01/11/2022 11:13 ICITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 7600 Airport APPROP ADJSTMTS BUDGET 76850110 Airport Operations 76850110 321910 Misc Permits & 76850110 331100 Federal Grants 2022/06/120435 12/03/2021 CRP 76850110 363910 Misc Sale of Me 76850110 369100 Reimb of Expens 76850110 369900 Miscellaneous 0 76850110 381100 Interest on Inv 76850110 382100 Land Rental 2022/06/120462 12/17/2021 GBI 76850110 382200 Building/Room R 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI 2022/06/120462 12/17/2021 GBI JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 0 0 0 .00 .00 .00 .0% 0 0 0 -59,000.00 .00 59,000.00 100.0% -59,000.00 REF 3614869 FAA 3-19-0047-033-2021 CARES -260 0 -260 -510.00 .00 250.00 196.2% 0 0 0 .00 .00 .00 .0% 0 0 0 .00 .00 .00 .0% -1,000 0 -1,000 143.83 .00 -1,143.83 -14.4%* -50,090 0 -50,090 -13,208.96 .00 -36,881.04 26.4%* -600.00 REF LAND RENT -280,000 0 -280,000 -141,499.42 .00 -138,500.58 50.5%* -160.00 REF HANGAR # 19 RENT -190.00 REF HANGAR RENT #54 -190.00 REF HANGAR RENT - #36 -190.00 REF HANGAR RENT #48 -190.00 REF HANGAR RENT - #47 -160.00 REF HANGAR #13 -230.00 REF HANGAR #57 -160.00 REF HANGAR #30 -149.00 REF HANGAR #7 -160.00 REF HANGAR #16 -160.00 REF HANGAR #24 -149.00 REF HANGAR #4 -149.00 REF HANGAR #10 -235.00 REF HANGAR #46 -190.00 REF Hangar Rent #41 -160.00 REF HANGAR #11 -149.00 REF Hangar #2 -358.00 REF HANGAR #33 -110.00 REF Office Rent (Bldg G) -149.00 REF HANGAR #5 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 01/11/2022 11:13 ICITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 7600 Airport APPROP ADJSTMTS BUDGET :, ••:• m u n i s • a tyler erp solution JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 382200 Building/Room R 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -4,606.00 REF D, E, F 2022/06/120462 12/17/2021 GBI -500.00 REF Hangar 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -650.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -187.75 REF AIRPORT 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -4,824.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -684.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -325.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -248.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -235.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -650.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -235.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -149.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -200.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -230.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -190.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -215.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -404.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR 2022/06/120462 12/17/2021 GBI -100.00 REF OFFICE 2022/06/120462 12/17/2021 GBI -160.00 REF HANGAR #38 #27 #39 #8 , H M #1 #59 #60 #72 RENTAL #51 #20 #42 #35 #32 #34 #9 #53 #18 #3 #14 #40 #61 #55 #71 #63 #49 #37 #45 #25 #44 #50 #28 #17 #6 #22 #62 #58 #43 #23 #21 #64 #31 #12 - HANGAR N SPACE RENT #26 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 01/11/2022 11:13 ICITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 7600 Airport APPROP ADJSTMTS BUDGET 76850110 382200 Building/Room R 2022/06/120462 12/17/2021 GBI -160.00 REF 2022/06/120462 12/17/2021 GBI -190.00 REF 76850110 382300 Equipment Renta -6,750 2022/06/120491 12/17/2021 CRP -144.00 REF 3621846 76850110 384100 Telephone Commi 0 76850110 384200 Vending Machine 0 76850110 384900 Other Commissio -35,000 2022/06/120793 12/29/2021 CRP -5,465.20 REF 3631733 76850110 392100 Sale of Land 0 76850110 392300 Sale of Eguipme 0 76850110 392400 Gain/Loss on Sa 0 76850110 393120 General Levy 0 76850110 393910 Misc Transfers 0 76850110 411000 Perm Full Time 66,337 2022/06/120063 12/03/2021 PRJ 2,500.80 REF 112721 2022/06/120711 12/17/2021 PRJ 2,500.80 REF 121721 2022/06/120824 12/30/2021 PRJ 2,500.80 REF 122521 76850110 412000 Perm Part Time 0 76850110 413000 Temporary Emplo 991 2022/06/120711 12/17/2021 PRJ 52.50 REF 121721 76850110 414500 Longevity Pay 650 76850110 421100 Health Insuranc 6,956 2022/06/120063 12/03/2021 PRJ 308.20 REF 112721 2022/06/120711 12/17/2021 PRJ 308.20 REF 121721 . ••:0 m u n i s • a tyler erp solution JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED HANGAR #29 HANGAR #52 0 -6,750 -1,422.00 .00 -5,328.00 21.1%* JET AIR INC OTHER 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 -35,000 -25,005.20 .00 -9,994.80 71.4%* TITAN AVIATION FUELS OTHER 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 66,337 31,795.89 .00 34,541.11 47.9% WARRANT=112721 RUN=1 BIWEEKLY WARRANT=121721 RUN=1 BIWEEKLY WARRANT=122521 RUN=1 BIWEEKLY 0 0 .00 .00 .00 .0% 0 991 123.69 .00 867.31 12.5% WARRANT=121721 RUN=1 BIWEEKLY 0 650 650.00 .00 .00 100.0% 0 6,956 3,698.40 .00 3,257.60 53.2% WARRANT=112721 RUN=1 BIWEEKLY WARRANT=121721 RUN=1 BIWEEKLY Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 OL 01/11/2022 11:13 ICITY OF IOWA CITY IP 4 mtharp YEAR-TO-DATE BUDGET REPORT Iglytdbud 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 01/11/2022 11:13 ICITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 7600 Airport APPROP ADJSTMTS BUDGET 76850110 435057 Couriers 76850110 435060 Legal Publicati 76850110 436030 Transportation 76850110 436050 Registration 76850110 436060 Lodging 76850110 436070 Miscellaneous T 76850110 436080 Meals 76850110 437010 Comp Liability 76850110 437020 Fire & Casualty 76850110 437030 Worker's Comp I 76850110 437041 Bonding & Other 76850110 437200 Loss Reserve Pa 76850110 438010 Stormwater Util 2022/06/120384 12/15/2021 UBB 76850110 438030 Electricity 2022/06/120412 12/15/2021 API 2022/06/120412 12/15/2021 API 2022/06/120412 12/15/2021 API 2022/06/120412 12/15/2021 API 2022/06/120412 12/15/2021 API . ••:0 m u n i s • a tyler erp solution JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 0 0 0 .00 .00 .00 .0% 0 0 0 .00 .00 .00 .0% 750 0 750 402.24 .00 347.76 53.6% 525 0 525 295.00 .00 230.00 56.2% 500 0 500 403.58 .00 96.42 80.7% 0 0 0 .00 .00 .00 .0% 50 0 50 75.00 .00 -25.00 150.0%* 18,348 0 18,348 5,207.67 .00 13,140.33 28.4% 14,493 0 14,493 12,733.00 .00 1,760.00 87.9% 194 0 194 2,000.00 .00 -1,806.00 1030.9%* 870 0 870 1,888.00 .00 -1,018.00 217.0%* 5,000 0 5,000 3,000.00 .00 2,000.00 60.0% 19,416 0 19,416 9,469.32 .00 9,946.68 48.8% 1,578.22 REF 211215 C-211215 4200 UB AR GEN 17,491 0 17,491 7,666.38 .00 9,824.62 43.8% 281.26 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 148.31 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 75.45 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 850.15 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 77.68 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 01/11/2022 11:13 ICITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 7600 Airport APPROP ADJSTMTS BUDGET 76850110 438050 Landfill Use 76850110 438070 Heating Fuel/Ga 2022/06/120412 12/15/2021 API 2022/06/120412 12/15/2021 API 2022/06/120412 12/15/2021 API 76850110 438080 Sewer Utility C 2022/06/120384 12/15/2021 UBB 76850110 438090 Water Utility C 2022/06/120384 12/15/2021 UBB 76850110 438100 Refuse Collecti 2022/06/120320 12/07/2021 API 2022/06/120320 12/07/2021 API 76850110 438110 Local Phone Ser 76850110 438120 Long Distance S 76850110 442010 Other Building 2022/06/120098 12/01/2021 API 2022/06/120400 12/01/2021 API 2022/06/120403 12/14/2021 API 2022/06/120403 12/14/2021 API 2022/06/120427 12/14/2021 API 76850110 442020 Structure R&M S 76850110 442030 Heating & Cooli 76850110 442040 Cooling Eguipme .0 •e :s. munis* • a tyler erp solution JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 0 0 0 2.16 .00 -2.16 100.0%* 4,521 0 4,521 1,298.02 .00 3,222.98 28.7% 98.93 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 439.41 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 401.68 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 12152021 28743 1,921 0 1,921 706.27 .00 1,214.73 36.8% 102.61 REF 211215 C-211215 2000 UB AR GEN 2,782 0 2,782 951.24 .00 1,830.76 34.2% 139.40 REF 211215 C-211215 1000 UB AR GEN 2,560 0 2,560 1,359.00 .00 1,201.00 53.1% 181.50 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Garbage Servi 266413 45.00 VND 010507 VCH JOHNSON COUNTY REFUS DEC FY22 Monthly Recycling Ser 266413 1,064 0 1,064 .00 .00 1,064.00 .0% 0 13,000 674.40 VND 010358 VCH 30.00 VND 013610 VCH 600.00 VND 010856 VCH 189.15 VND 014647 VCH 138.82 VND 014647 VCH 1,256 1,876 0 0 0 .00 .00 .00 .0% 0 13,000 14,177.87 .00-1,177.87 109.1%* OVERHEAD DOOR COMPAN Hangar 41 Cable Replacement/Re 266288 STANDARD PEST CONTRO Pest Control Services VAR NOV 266459 JET AIR INC IOW Janitorial Services 266404 DAN'S OVERHEAD DOORS Hangar 56 Door Repair 28729 DAN'S OVERHEAD DOORS Hangar Door Repairs 28729 0 1,256 504.59 .00 751.41 40.2% 0 1,876 474.88 .00 1,401.12 25.3% 0 0 .00 .00 .00 .0% Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 OL 01/11/2022 11:13 ICITY OF IOWA CITY IP 7 mtharp YEAR-TO-DATE BUDGET REPORT Iglytdbud 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 & P1 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 01/11/2022 11:13 ICITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 7600 Airport APPROP ADJSTMTS BUDGET - a . e �0 ••:,:s. m u n i s • a tyler erp solution JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 446120 ITS-Server/Stor 641 0 641 508.69 2022/06/120859 12/31/2021 GNI 49.14 REF AO 2022/06/120861 12/31/2021 GNI 6.00 REF AO 2022/06/120863 12/31/2021 GNI 34.72 REF AO 76850110 446130 ITS-PC/Peripher 14,478 0 14,478 7,980.00 2022/06/120874 12/31/2021 GNI 1,316.50 REF AO 76850110 446140 ITS -Capital Rep 0 0 0 .00 76850110 446150 ITS -Application 0 0 0 .00 76850110 446160 ITS-Infrastuctu 8,761 0 8,761 .00 76850110 446190 ITS -Software SA 233 0 233 114.60 2022/06/120864 12/31/2021 GNI 19.40 REF AO 76850110 446200 Photocopying Ch 565 0 565 144.94 76850110 446220 Phone Service C 0 0 0 .00 76850110 446300 Phone Equipment 1,410 0 1,410 685.50 2022/06/120872 12/31/2021 GNI 112.50 REF AO 2022/06/120873 12/31/2021 GNI .45 REF AO 76850110 446320 Mail Chargeback 0 0 0 .70 76850110 446350 City Vehicle Re 25,051 0 25,051 17,788.98 2022/06/120898 12/31/2021 GNI 2,964.83 REF TLW 76850110 446360 City Vehicle Re 0 0 0 .00 .00 132.31 79.4% Storage of files AIR DUO Two Factor Storage of Email .00 6,498.00 55.1% DEC ITS Repl Chgbk .00 .00 .0% .00 .00 .0% .00 8,761.00 .0% .00 118.40 49.2% Office software .00 420.06 25.7% .00 .00 .0% .00 724.50 48.6% CH DEC PHONE ASSET CHARGE CH DEC LONG DISTANCE CHARGES .00 -.70 100.0%* .00 7,262.02 71.0% DEC REPLACEMENT COST .00 .00 .0% Airport Commission Agenda & Info Packet nnoori- n�ro• 1-.n- I ')n)) O1/11/2022 11:13 ICITY OF IOWA CITY IP 9 mtharp YEAR-TO-DATE BUDGET REPORT Iglytdbud DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: 7600 Airport ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 76850110 446370 Fuel Chargeback 3,875 2022/06/120898 12/31/2021 GNI 321.16 REF TLW 76850110 446380 Vehicle R&M Cha 12,303 2022/06/120898 12/31/2021 GNI 233.98 REF TLW 76850110 448040 City Sponsored 0 76850110 449055 Permitting Fees 265 76850110 449060 Dues & Membersh 1,250 2022/06/120403 12/14/2021 API 275.00 VND 012853 VCH 76850110 449120 Equipment Renta 500 76850110 449280 Misc Services & 0 76850110 449350 Meals (non-trav 0 76850110 449360 Interest Expens 0 76850110 449370 Depreciation Ex 0 76850110 452010 Office Supplies 100 76850110 452030 Minor Office Eq 0 76850110 452040 Sanitation & In 0 76850110 454020 Subscriptions 334 76850110 455110 Software 0 JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 0 3,875 1,837.01 .00 2,037.99 47.4% DEC DIVISION FUEL 0 12,303 1,828.30 .00 10,474.70 14.9% DEC DIVISION SERVICE 0 0 .00 .00 .00 .0% 0 265 .00 .00 265.00 .0% 0 1,250 275.00 .00 975.00 22.0% AMERICAN ASSOCIATION Annual Dues - Account number 2 266356 0 500 923.25 .00 -423.25 184.7%* 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 100 41.35 .00 58.65 41.4% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 334 416.00 .00 -82.00 124.E%* 0 0 .00 .00 .00 .0% Airport Commission Agenda & Info Packet nnooti- n�to• 1-.n- I ')n)) O1/11/2022 11:13 ICITY OF IOWA CITY IP 10 mtharp YEAR-TO-DATE BUDGET REPORT Iglytdbud DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: 7600 Airport ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET 76850110 455120 Misc Computer H 0 2022/06/120904 12/21/2021 API 9.59 VND 090448 VCH 76850110 461040 Other Agricultu 0 76850110 461050 Other Aaricultu 0 76850110 466040 Plumbing Suppli 0 76850110 466050 Electrical Supp 0 76850110 466070 Other Maintenan 1,404 2022/06/120403 12/14/2021 API 127.16 VND 010856 VCH 76850110 467020 Eguipment R&M S 200 2022/06/120634 12/21/2021 API 609.12 VND 010647 VCH 76850110 467160 Other Vehicle R 0 76850110 468030 Asphalt 0 76850110 468050 Sand 0 76850110 469040 Traffic Cntrl I 0 76850110 469190 Minor Eguipment 500 76850110 469200 Tools 500 76850110 469210 First Aid/Safet 308 JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 0 0 9.59 .00 -9.59 100.0%* AMAZON MKTPLACE PMTS P-Card invoice for statement c 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 1,404 318.51 .00 1,085.49 22.7% JET AIR INC IOW Maintenance Reimbursement 266404 0 200 2,472.54 .00 -2,272.54 1236.3%* CENTRAL PETROLEUM EQ Fuel Cabinet Motor repairs 266510 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 500 .00 .00 500.00 .0% 0 500 74.18 .00 425.82 14.8% 0 308 1,321.95 .00 -1,013.95 429.2%* Airport Commission Agenda & Info Packet nnoori- n�ro• 1-.n- I ')n)) O1/11/2022 11:13 mtharp FOR 2022 06 ACCOUNTS FOR: 7600 Airport ICITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT DECEMBER ORIGINAL TRANFRS/ APPROP ADJSTMTS DETAIL REVISED BUDGET YTD ACTUAL JOURNAL DETAIL ENCUMBRANCES 2022 6 TO AVAILABLE BUDGET IP 11 Iglytdbud 2022 6 PCT 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 01/11/2022 11:13 ICITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED 7600 Airport APPROP ADJSTMTS BUDGET 76850110 436030 651 Transportati 76850110 436060 651 Lodging 76850110 437010 651 Comp Liabili 76850110 438100 651 Refuse Colle 2022/06/120320 12/07/2021 API 2022/06/120320 12/07/2021 API 76850110 445140 651 Outside Prin 76850110 449100 651 Vehicle Rent 76850110 449120 651 Equipment Re 76850110 465010 651 Other Fluids 76850110 469320 651 Miscellaneou 652 100 Year Anniversary Celebration 76850110 363910 652 Misc Sale of 76850110 432080 652 Other Profes 2022/06/120403 12/14/2021 API 76850110 437010 652 Comp Liabili 76850110 438100 652 Refuse Colle 2022/06/120320 12/07/2021 API 2022/06/120320 12/07/2021 API 0 0 0 0 181.50 VND 010507 VCH 45.00 VND 010507 VCH 0 0 0 0 0 0 0 1,100.00 VND 013364 VCH 0 0 181.50 VND 010507 VCH 45.00 VND 010507 VCH --!.4.*,Xn u n I S a tyler erp solution .. JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% JOHNSON COUNTY REFUS DEC FY22 Monthly Garbage Servi 266413 JOHNSON COUNTY REFUS DEC FY22 Monthly Recycling Ser 266413 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% BOLTON & MENK INC Solar Power RFP Assistance 28725 0 0 .00 .00 .00 .0% 0 0 .00 .00 .00 .0% JOHNSON COUNTY REFUS DEC FY22 Monthly Garbage Servi 266413 JOHNSON COUNTY REFUS DEC FY22 Monthly Recycling Ser 266413 Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 01/11/2022 11:13 ICITY OF IOWA CITY IP 13 mtharp YEAR-TO-DATE BUDGET REPORT Iglytdbud DECEMBER DETAIL FOR 2022 06 ACCOUNTS FOR: 7600 Airport ORIGINAL APPROP TRANFRS/ ADJSTMTS REVISED BUDGET JOURNAL DETAIL YTD ACTUAL ENCUMBRANCES 2022 6 TO AVAILABLE BUDGET 2022 6 PCT 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 01/11/2022 11:13 ICITY OF IOWA CITY IP 14 mtharp YEAR-TO-DATE BUDGET REPORT Iglytdbud DECEMBER DETAIL FOR 2022 06 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET JOURNAL DETAIL 2022 6 TO 2022 6 AVAILABLE PCT YTD ACTUAL ENCUMBRANCES BUDGET USED GRAND TOTAL -843 0 -843-40,801.69 .00 39,959.05 4842.10 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet Meeting Date: January 13, 2022 O1/11/2022 11:13 ICITY OF IOWA CITY mtharp 1YEAR-TO-DATE BUDGET REPORT 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 Print Full or Short description: F Print full GL account: N Format type: 1 Double space: N 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 Year/Period: 2022/ 6 Print MTD Version: N Roll projects to object: Y Carry forward code: 1 •••'•• m u, M46 a tyler erp solution glyt ..