Loading...
HomeMy WebLinkAboutAgenda 11-15-23*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 WEDNESDAY, NOVEMBER 15, 2023 – 5:00 P.M. 1. Determine Quorum 1 min* 2. Approval of Minutes from the following meetings: 2 min October 19, 2023 3. Public Comment - Items not on the agenda 5 min 4. Items for Discussion / Action: a. Unhoused encampments (Stevens Drive/Sturgis Ferry) 10 min b. Hangar A Mural Project 10 min i. Consider a resolution accepting project as complete c. Airport Construction Projects: 20 min i. FAA grant projects 1. Runway 25 Threshold Relocation 2. Runway 12/30 Displaced Threshold/Relocation 3. Terminal Area Study 4. Solar Power Project 5. FAA FY24 AIP Pre-Application ii. Iowa DOT grant projects 1. FY23 Program a. Terminal Building Improvements iii. Airport/Locally Funded Projects iv. Future Projects d. Airport "Operations" 10 min i. Budget 1. FY25 Budget ii. Management iii. Events e. FBO / Flight Training Reports 10 min i. Jet Air f. Commission Members' Reports 2 min g. Staff Report 2 min 5. Set next regular meeting for December 14, 2023 6. Adjourn MINUTES DRAFT IOWA CITY AIRPORT COMMISSION October 19, 2023 – 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Judy Pfohl, Chris Lawrence, Hellecktra Orozco, Members Absent: Warren Bishop, Ryan Story Staff Present: Michael Tharp, Jennifer Schwickerath, Others Present: Matt Wolford, Sam Brooks, Via Zoom: Carl Byers, Kevin Bailey RECOMMENDATIONS TO COUNCIL: None DETERMINE QUORUM A quorum was determined at 6:00 pm and Orozco called the meeting to order. APPROVAL OF MINUTES Pfohl moved to accept the minutes of September 14, 2023, seconded by Lawrence. Motion carried 3-0 (Story, Bishop absent) PUBLIC COMMENT - None ITEMS FOR DISCUSSION / ACTION a. Unhoused encampments (Stevens Drive/Sturgis Ferry) – Tharp stated that he had notified the Commission about the fire at an encampment. Tharp stated that Kevin and Sam’s work behind the scenes and during the last few months helped to limit the anxiety by nearby property owners. Bailey noted that he had been in communication with the business owners in the area and even though they weren’t pleased that the incident happened, they were still aware of the timeline. Bailey noted that some folks had moved on, or that Sam had been able to find housing for some of those in the area. Bailey noted that the business owners’ concerns are also to not allow the camp to get that big or established in the area again. Tharp stated that they were talking about how to keep people from re-establishing in the Spring. b.Hangar A Mural Project – Tharp noted that the meet and greet was delayed until Thursday October 26th from noon to 3pm. Tharp noted they’d have some self- guiding signs for anyone interested in seeing the mural up close. Tharp also stated that the artist planned to make the touch-ups before the event. c.Airport Construction Projects: i.FAA grant projects 1.Runway 25 Threshold Relocation – Tharp noted they were waiting for the remaining lights to be installed. Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 2 of 34 Airport Commission October 19, 2023 Page 2 of 4 2.Runway 12/30 Displaced Threshold/Relocation – Still on track for the spring. 3.Terminal Area Study – Tharp noted that the grant application was submitted. Lawrence asked about the timelines to which Tharp noted this grant application covered the historical and environmental review as well as to design and bid the new terminal. Tharp stated he expected the historical and environmental reviews would take about a year. Byers noted that the FAA was looking through the draft report for the space study and they were expecting to get comments back. 4.Solar Power Project – Tharp noted they were submitted the airspace study for the solar panels. Tharp also stated that the BIL allocation has come out at the end of November so once that happened, they would seek to move forward. Orozco asked if the consultants had seen the new layout to which Tharp stated they had. Tharp noted there were no concerns with making the solar power fit into the future parking layouts. ii.Iowa DOT grant projects 1. FY23 Program a.Terminal Building Improvements – Tharp noted that it appears this would be a spring project based on feedback from the contractor for ordering materials. iii.Airport/Locally Funded Projects – none iv.Future Projects – Tharp stated that the call letter for the next year of AIP applications was out. Tharp shared with members a timeline of projects noting that this was a draft and some projects would need to be extended out due to limited local match dollars. d.Airport “Operations” i.Budget – Tharp noted that the FY25 budget info was in the packet. Tharp noted that Lawrence and Orozco helped put the budget together. Tharp noted they did have a lease agreement that was expiring without renewal. Tharp also stated that he was talking to the Army about expanding the footprint around the reserve area. Tharp noted that as part of the budget that wasn’t accounted for was the cost savings from the solar power project. Lawrence asked when they were targeting for that project to be completed. Tharp noted that it was likely to be in the later part of 2024. Lawrence moved to submit the budget to the City, seconded by Pfohl Motion carried 3-0 (Story, Bishop absent) ii.Management – iii.Events – Tharp noted that the events were done for the year e.FBO / Flight Training Reports – i.Jet Air – Tharp stated that Wolford was out for the National Business Aviation Association conference. Tharp stated that they were getting ready for the winter season and doing a few things during the time between needing to mow and needing to snow plow. Pfohl noted that she had weeded some areas in front of the terminal. f.Commission Members' Reports – none g.Staff Report – Tharp noted that he would most likely be scheduling a vacation from Christmas to New Year Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 3 of 34 Airport Commission October 19, 2023 Page 3 of 4 SET NEXT REGULAR MEETING – Members set the next meeting for November 9th. ADJOURN Pfohl moved to adjourn, seconded by Lawrence. Motion carried 3-0 (Story, Bishop absent) . Meeting adjourned at 6:25pm. ______________________________________________ ___________________ CHAIRPERSON DATE Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 4 of 34 Airport Commission October 19, 2023 Page 4 of 4 Airport Commission ATTENDANCE RECORD 2022-2023 NAME TERM EXP. 10 / 1 3 / 2 2 11 / 1 0 / 2 2 12 / 0 8 / 2 2 01 / 1 9 / 2 3 02 / 0 9 / 2 3 03 / 0 9 / 2 3 0/ 3 / 2 0 / 2 3 04 / 1 3 / 2 3 05 / 0 2 / 2 3 05 / 1 8 / 2 3 06 / 0 8 / 2 3 07 / 1 3 / 2 3 08 / 1 0 / 2 3 09 / 1 4 / 2 3 10 / 1 9 / 2 3 Warren Bishop 06/30/26 X X X X X X X X X X X X X X O/E Scott Clair 06/30/23 X O/E X X X X X O/E O/E X/E O/E NM NM NM NM Christopher Lawrence 06/30/25 X X X X O/E X O/E X X X X X X X X Hellecktra Orozco 06/30/24 X X X X X X/E O/E O/E O/E X X X X X X Judy Pfohl 06/30/26 X X X X X X X X X X X X X X X Ryan Story 06/30/27 Not A Member X O/E X O/E Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time X/S = Present for subcommittee meeting O/S = Absent, not a member of the subcommittee Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 5 of 34 Airport Name:Telephone: Prepared By:Date Approved: Date Prepared: 150,000$ 300,000$ 150,000$ 150,000$ 300,000$ 180,000$ 687,700$ 292,000$ 584,000$ Federal -$ -$ -$ -$ -$ -$ BIL 687,700.00$ -$ -$ -$ -$ -$ State -$ -$ -$ -$ -$ -$ Local 76,411.00$ -$ -$ -$ -$ -$ Total 764,111.00$ -$ -$ -$ -$ -$ Federal -$ -$ -$ -$ -$ -$ BIL -$ -$ -$ -$ -$ -$ BIL-ATP 665,000.00$ -$ -$ -$ -$ -$ State -$ -$ -$ -$ -$ -$ Local 35,000.00$ -$ -$ -$ -$ -$ Total 700,000.00$ -$ -$ -$ -$ -$ Federal -$ -$ -$ -$ -$ -$ BIL -$ -$ -$ -$ -$ -$ BIL-ATP -$ 6,555,000.00$ -$ -$ -$ -$ State -$ -$ -$ -$ -$ -$ Local -$ 345,000.00$ -$ -$ -$ -$ Total -$ 6,900,000.00$ -$ -$ -$ -$ Federal -$ -$ -$ -$ -$ -$ BIL -$ -$ -$ -$ -$ -$ State -$ -$ 127,500.00$ -$ -$ -$ Local -$ -$ 22,500.00$ -$ -$ -$ Total -$ -$ 150,000.00$ -$ -$ -$ Federal -$ -$ 360,000.00$ -$ -$ -$ BIL -$ -$ -$ -$ -$ -$ State -$ -$ -$ -$ -$ -$ Local -$ -$ 40,000.00$ -$ -$ -$ Total -$ -$ 400,000.00$ -$ -$ -$ Federal -$ -$ -$ -$ -$ -$ BIL -$ -$ -$ -$ -$ -$ State -$ -$ -$ 399,500.00$ -$ -$ Local -$ -$ -$ 70,500.00$ -$ -$ Total -$ -$ -$ 470,000.00$ -$ -$ Federal -$ -$ -$ -$ 270,000.00$ -$ BIL -$ -$ -$ -$ -$ -$ State -$ -$ -$ -$ 320,000.00$ -$ Local -$ -$ -$ -$ 110,000.00$ -$ Total -$ -$ -$ -$ 700,000.00$ -$ Federal -$ -$ -$ -$ -$ -$ BIL -$ -$ -$ -$ -$ -$ State -$ -$ -$ -$ -$ 493,000.00$ Local -$ -$ -$ -$ -$ 87,000.00$ Total -$ -$ -$ -$ -$ 580,000.00$ Federal -$ -$ -$ -$ -$ -$ BIL -$ -$ -$ -$ -$ -$ State -$ -$ -$ -$ -$ -$ Local -$ -$ -$ -$ -$ -$ Total -$ -$ -$ -$ -$ -$ 150,000$ -$ -$ 150,000$ 30,000$ 180,000$ -$ 292,000$ 584,000$ Bolton & Menk Inc. FIVE-YEAR AIRPORT CAPITAL IMPROVEMENT PROGRAM (CIP) Iowa City Municipal Airport (IOW) Solar Power Panels BIL fund project Revised Draft 10-30-23 Available Entitlement Funds Available BIL Funds Project Description Funding Source FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 Available BIL Funds Terminal Building - Design BIL ATP FY 2024 Submission Terminal Building - Construction Planned BIL ATP FY 2025 Apron and Taxilane for Hangar - SE Corner of Hangar Area - State Funded Airfield Pavement Maintenance Runway 7/25 (West End) & Runway 12/30 Fuel System Improvements (New Cabinets) Terminal Apron Expansion - Phase 1 Apron and Taxilane for Hangars - Phase 2 State Funded Available Entitlement Funds Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 7 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 1 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 850110 Airport Operations 76850110 321910 -.00 76850110 331100 -.00 76850110 363910 -.00 Sales of Airport T-shirts during events and throughout the year. 2022 - sold remaining inventory and not replenishing. 76850110 369100 -.00 Don't plan for these annually 76850110 369900 -.00 Don't plan for this annually 76850110 381100 -.00 Don't annually plan for these 76850110 382100 -47,000.00 FY22 Army Reserve ended parking lease (~$4800) FY24 Lease ends ($600/month) Dreusicke/Budget HWY 1 (no offsetting lease) Active leases: Farm - FNC Managed (~$35,000/year) Toyota Iowa City Expires 2033 ~$10,000/year Jet Air Hangar N Expires 2046 ~$2250/year Edmonds - Expires 2046 ~$600/year 76850110 382200 - 320,000.00 FY22 JA operating agreement 5-year inflationary adjustment. Hangar rents increased in for 2020-2021 cycle (10/20 - 9/21) FY23 - T-hangar rates increased 10% October 2022, some additional CPI triggers at end of CY2022 FY24 - Some hangar contracts escalate (CPI) expect hangar rate adjustment for inflation Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 8 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 2 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 382300 -1,500.00 Flight simulator use - 2020 contained pre-purchase sales of flight time to gauge interest and build up cash to purchase. Annual sales estimate to roughly 150 hours (@ $45/hour after fees) FY22 Most free hours expire from initial fundraising purchase (FY20) FY23 Airport Commission reduced rate on sim to encourage continued use. 76850110 384900 -72,000.00 FY2020 - Fuel Sales Commissions increase due to higher activity FY2022 - Had a couple of missed flowage fees from OPL lab that were recovered in 2022. FY24 - Fuel flowage rate increased 50% (from $.10/gallon to $.15/gallon) beginning 9/1/23 76850110 392100 -.00 76850110 393120 -.00 76850110 411000 -85,200.00 76850110 413000 -.00 76850110 414500 -.00 76850110 421100 -9,200.00 76850110 421200 -400.00 76850110 421300 -200.00 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 9 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 3 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 421400 -300.00 76850110 422100 -6,500.00 76850110 423100 -8,000.00 76850110 431020 -.00 76850110 432020 -900.00 Average Annual Costs 76850110 432030 -.00 76850110 432050 -.00 76850110 432080 -.00 76850110 435055 -.00 Misc Mailings - Hangar Lease renewals,etc. 76850110 435060 -.00 76850110 436030 -750.00 Travel to Iowa Aviation Conference (site random) and 4 States Regional (Formerly FAA) Aviation Conference in Kansas City 22 - Iowa City 23 - Cedar Rapids 24 - Cedar Falls 25 - Okoboji 76850110 436050 -500.00 Travel to Iowa Aviation Conference and 4 States Regional (Formerly FAA) Aviation Conference Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 10 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 4 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 436060 -500.00 Travel to Iowa Aviation Conference and 4 States Regional (Formerly FAA) Aviation Conference 76850110 436080 -100.00 Travel to Iowa Aviation Conference and 4 States Regional (Formerly FAA) Aviation Conference 76850110 437010 -9,000.00 Pollution policy, $19,000 (est), every 3 years, 2022/2025/2028/2031 76850110 437020 -24,400.00 35% increase to FY24 ACTUALS 76850110 437030 -2,100.00 76850110 437041 -4,000.00 Bond for New Commission Members 76850110 437200 -3,000.00 Annual Loss Reserve Payment 76850110 438010 -19,800.00 76850110 438030 -10,000.00 Installation of phase 1 should be complete during FY25. Meter charges were $12,300 for last 12 months (10/22-10/23) which would be covered by solar. 76850110 438050 -200.00 Avg Landfill Use 76850110 438070 -5,000.00 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 11 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 5 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 438080 -1,800.00 76850110 438090 -4,300.00 76850110 438100 -2,800.00 76850110 438110 -200.00 76850110 438120 -.00 Long Distance Chargebacks 76850110 442010 -13,600.00 Avg Expenses FY18 had a motor replacement and other single issue charges. FY22 had 2 door motor replacements 76850110 442020 -800.00 76850110 442030 -2,000.00 2017 - Replaced HVAC Control units in terminal and maintenance shop FY2019 - Combined Heating & Cooling R&M Line Items FY2022 had 3 heater replacements (~$13,000) and elevated HVAC Equipment repairs 76850110 442060 -5,000.00 Avg Expenses 2017 - Previous expenses included water heater replc 2018 - Had single issue electrical repairs ($4000) 2021 - Had substantial lighting and water repair work to various locations at airport 76850110 443050 -.00 76850110 443080 -10,000.00 FY2019 - Avg Recent Expenses Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 12 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 6 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 445030 -50,000.00 JA Contract (groundskeeping) $6215/month x 8 months Gilbert Street Lot Mowing - $7500 76850110 445080 -26,700.00 Snow removal portion of maintenance contract and deicing supplies JA Contract, DeIcer material $6215x4 (remaining groundskeeping contract months) $8000 ~3 tons of deicer material 76850110 445110 -1,500.00 FY2025/FY2028/FY2031- 3 year UST Cathodic Protection testing due (add $2500), UST Monitoring and Spill Bucket Annual Line/Leak testing for UST (~$600) Annual Backflow Testing Services (~$800) 76850110 445230 -1,000.00 76850110 446100 -8,100.00 Adjusted by annual pay inc - 2.25% for FY25. 76850110 446120 -300.00 76850110 446130 -15,900.00 76850110 446160 -9,000.00 76850110 446190 -200.00 76850110 446200 -600.00 76850110 446300 -1,500.00 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 13 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 7 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 446320 -200.00 76850110 446350 -37,700.00 Increased for Tractor purchase 76850110 446360 -.00 76850110 446370 -4,700.00 76850110 446380 -15,800.00 76850110 448040 -.00 76850110 449055 -400.00 FY2019/FY2024/FY2029 5-year Stormwater Permit Due (add 750) 76850110 449060 -1,000.00 Iowa Public Airports Association Iowa Aviation Promotion Group ICCVB AAAE Iowa City Area Business Partnership 76850110 449120 -.00 Avg equipment rental 76850110 452010 -100.00 Paper/Pens etc. 76850110 452040 -.00 76850110 454020 -1,000.00 Corridor Business Journal CR Gazette Flight Sim data subscription Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 14 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 8 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 455110 -400.00 76850110 455120 -.00 76850110 461050 -.00 76850110 466070 -700.00 Avg Costs 76850110 467020 -1,000.00 FY22 had unplanned fuel hose/nozzle replacement due to damage 76850110 467160 -100.00 Misc Costs 76850110 468030 -100.00 Maintenance potholes 76850110 468050 -100.00 Avg Sand Expense 76850110 469040 -400.00 Avg Expenses Increase for materials for remarking tie-downs and parking lots 76850110 469190 -500.00 FY22 - Funds for as needed equipment purchases during year (weedeater, chainsaw, vacuum etc) 76850110 469200 -500.00 Minor tools purchases Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 15 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 9 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 76850110 469210 -300.00 FY22 had a couple of extinguisher replacements in annual check 76850110 469290 -.00 FY22 Ended the t-shirt sales 76850110 469320 -.00 76850110 469360 -.00 FY17 had costs related to Airport Emergency Drill (3-5 year drill) FY18 had costs related to Airport Commission special meetings 76850110 473010 -.00 76850110 473020 -.00 76850110 474240 -25,000.00 Brush attachment for tractor per agreement with Jet Air for fuel flowage increase. 76850110 475010 -.00 76850110 490040 -.00 TOTAL UNDEFINED PROJECT 881,950.00 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 16 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 10 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 120 Airport Mural 76850110 362100 - 120 .00 76850110 473010 - 120 .00 TOTAL Airport Mural .00 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 17 of 34 CITY OF IOWA CITY NEXT YEAR BUDGET DETAIL REPORT Report generated: 11/06/2023 13:56 User:mtharp Program ID: bgnyrpts Page 11 PROJECTION: 25100 FY25 Operating Budget ACCOUNTS FOR: Airport VENDOR QUANTITY UNIT COST 2025 FINANCE 907 Wind Storm 8/10/20 76850110 466070 - 907 .00 TOTAL Wind Storm 8/10/20 .00 TOTAL Airport Operations .00 TOTAL Airport .00 TOTAL REVENUE 440,500.00 TOTAL EXPENSE 435,450.00 GRAND TOTAL 5,050.00 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 18 of 34 CITY OF IOWA CITY INVOICE LIST BY GL ACCOUNT Report generated: 11/06/2023 13:58 User:mtharp Program ID: apinvgla Page 1 YEAR/PERIOD: 2024/4 TO 2024/4 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION 76850110 Airport Operations 76850110 382200 Building/Room Rental 010836 TREASURER STATE OF I 2023 Treasure Hunt 0 2024 4 DIR P 155.00 W103023 1063 2023 Treasure Hunt ACCOUNT TOTAL 155.00 76850110 438030 Electricity 010319 MIDAMERICAN ENERGY 20231011105422 0 2024 4 INV P 1,217.75 101323 43757 MidAmBilling 101120 ACCOUNT TOTAL 1,217.75 76850110 438070 Heating Fuel/Gas 010319 MIDAMERICAN ENERGY 20231011105422 0 2024 4 INV P 36.43 101323 43757 MidAmBilling 101120 ACCOUNT TOTAL 36.43 76850110 442010 Other Building R&M Services 010358 OVERHEAD DOOR COMPAN 022368 0 2024 4 INV P 835.00 101323 292541 Hangar 72 Door Cabl 010856 JET AIR INC IOW IVI-23-005870 0 2024 4 INV P 678.00 101323 292501 Groundskeeping/Jani 011047 HAWKEYE COMMUNICATIO 18630 0 2024 4 INV P 145.00 102023 43803 2023 Alarm Inspecti 016684 STANDARD PEST 452012 0 2024 4 INV P 90.00 102023 292766 Sep FY24 Quarterly ACCOUNT TOTAL 1,748.00 76850110 442020 Structure R&M Services 010823 SCHUMACHER ELEVATOR 90594184 0 2024 4 INV P 252.35 102023 43833 FY24 Quarterly OG M ACCOUNT TOTAL 252.35 76850110 442060 Electrical & Plumbing R&M Srvc 010014 ADVANCED ELECTRICAL 66547 0 2024 4 INV P 345.45 101323 43718 Replace bulbs on be 011374 CARE AMBULANCE SERVI 2937 0 2024 4 INV P 579.58 102023 292616 Electrical Repairs ACCOUNT TOTAL 925.03 76850110 445030 Nursery Srvc-Lawn & Plant Care 010856 JET AIR INC IOW IVI-23-005870 0 2024 4 INV P 6,215.00 101323 292501 Groundskeeping/Jani ACCOUNT TOTAL 6,215.00 76850110 445230 Other Operating Services 011047 HAWKEYE COMMUNICATIO 17659 0 2024 4 INV P 228.00 101323 43742 2023-2024 Fire Alar ACCOUNT TOTAL 228.00 76850110 449060 Dues & Memberships 010229 IOWA CITY AREA BUSIN 4299 0 2024 4 INV P 342.00 101323 292491 Annual Dues Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 19 of 34 CITY OF IOWA CITY INVOICE LIST BY GL ACCOUNT Report generated: 11/06/2023 13:58 User:mtharp Program ID: apinvgla Page 2 YEAR/PERIOD: 2024/4 TO 2024/4 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION ACCOUNT TOTAL 342.00 76850110 466070 Other Maintenance Supplies 010856 JET AIR INC IOW IVI-23-005909 0 2024 4 INV P 22.89 101323 292501 maintenance reimbur ACCOUNT TOTAL 22.89 76850110 469200 Tools 010856 JET AIR INC IOW IVI-23-005909 0 2024 4 INV P 53.39 101323 292501 maintenance reimbur ACCOUNT TOTAL 53.39 ORG 76850110 TOTAL 11,195.84 FUND 7600 Airport TOTAL:11,195.84 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 20 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 1 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 76850110 Airport Operations 76850110 321910 Misc Permits & 0 0 0 .00 .00 .00 .0% 76850110 331100 Federal Grants 0 0 0 .00 .00 .00 .0% 76850110 363910 Misc Sale of Me 0 0 0 .00 .00 .00 .0% 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 0 0 0 1,688.96 .00 -1,688.96 100.0%* 76850110 382100 Land Rental -50,697 0 -50,697 -12,406.78 .00 -38,290.22 24.5%* 2024/04/100550 10/18/2023 GBI -600.00 REF LAND RENT 76850110 382200 Building/Room R -302,600 0 -302,600 -102,043.52 .00 -200,556.48 33.7%* 2024/04/100479 10/12/2023 APM -155.00 VND 000119 VCH MISC REFUND Hanger 13, Overpayment 2024/04/100550 10/18/2023 GBI -25,705.13 REF 2024/04/101453 10/30/2023 API 155.00 VND 010836 VCH TREASURER STATE OF I 2023 Treasure Hunt 1063 76850110 382300 Equipment Renta -1,500 0 -1,500 -432.50 .00 -1,067.50 28.8%* 2024/04/101413 10/31/2023 CRP -140.00 REF 4412455 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 -52,000 0 -52,000 -17,863.20 .00 -34,136.80 34.4%* 2024/04/101413 10/31/2023 CRP -5,295.70 REF 4412465 TITAN AVIATION OTHER 2024/04/101413 10/31/2023 CRP -8,025.30 REF 4412466 TITAN AVIATION OTHER Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 21 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 2 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 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 80,130 0 80,130 23,041.37 .00 57,088.63 28.8% 2024/04/100153 10/06/2023 PRJ 3,043.20 REF 093023 WARRANT=093023 RUN=1 BIWEEKLY 2024/04/101092 10/20/2023 PRJ 3,043.20 REF 101423 WARRANT=101423 RUN=1 BIWEEKLY 76850110 412000 Perm Part Time 0 0 0 .00 .00 .00 .0% 76850110 413000 Temporary Emplo 0 0 0 .00 .00 .00 .0% 76850110 414500 Longevity Pay 650 0 650 .00 .00 650.00 .0% 76850110 421100 Health Insuranc 8,623 0 8,623 2,826.16 .00 5,796.84 32.8% 2024/04/100153 10/06/2023 PRJ 353.27 REF 093023 WARRANT=093023 RUN=1 BIWEEKLY 2024/04/101092 10/20/2023 PRJ 353.27 REF 101423 WARRANT=101423 RUN=1 BIWEEKLY 76850110 421200 Dental Insuranc 419 0 419 133.84 .00 285.16 31.9% 2024/04/100153 10/06/2023 PRJ 16.73 REF 093023 WARRANT=093023 RUN=1 BIWEEKLY 2024/04/101092 10/20/2023 PRJ 16.73 REF 101423 WARRANT=101423 RUN=1 BIWEEKLY 76850110 421300 Life Insurance 170 0 170 59.84 .00 110.16 35.2% 2024/04/101092 10/20/2023 PRJ 14.96 REF 101423 WARRANT=101423 RUN=1 BIWEEKLY 76850110 421350 Group Life - Im 0 0 0 .00 .00 .00 .0% 76850110 421400 Disability Insu 248 0 248 96.28 .00 151.72 38.8% 2024/04/101092 10/20/2023 PRJ 24.07 REF 101423 WARRANT=101423 RUN=1 BIWEEKLY 76850110 422100 FICA 6,130 0 6,130 1,736.42 .00 4,393.58 28.3% 2024/04/100153 10/06/2023 PRJ 229.21 REF 093023 WARRANT=093023 RUN=1 BIWEEKLY 2024/04/101092 10/20/2023 PRJ 229.45 REF 101423 WARRANT=101423 RUN=1 BIWEEKLY Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 22 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 3 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 76850110 423100 IPERS 7,565 0 7,565 2,175.12 .00 5,389.88 28.8% 2024/04/100153 10/06/2023 PRJ 287.28 REF 093023 WARRANT=093023 RUN=1 BIWEEKLY 2024/04/101092 10/20/2023 PRJ 287.28 REF 101423 WARRANT=101423 RUN=1 BIWEEKLY 76850110 424900 Other Post Empl 0 0 0 .00 .00 .00 .0% 76850110 431020 Court Costs & S 0 0 0 .00 .00 .00 .0% 76850110 432020 Annual Audit 856 0 856 .00 .00 856.00 .0% 76850110 432030 Financial Servi 0 0 0 .00 .00 .00 .0% 76850110 432050 Appraisal Servi 0 0 0 .00 .00 .00 .0% 76850110 432080 Other Professio 0 0 0 3,346.00 .00 -3,346.00 100.0%* 76850110 435055 Mail & Delivery 0 0 0 .00 .00 .00 .0% 76850110 435056 Delivery Servic 0 0 0 .00 .00 .00 .0% 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 447.38 .00 302.62 59.7% 76850110 436050 Registration 525 0 525 325.00 .00 200.00 61.9% 76850110 436060 Lodging 500 0 500 387.46 .00 112.54 77.5% 76850110 436070 Miscellaneous T 0 0 0 .00 .00 .00 .0% 76850110 436080 Meals 100 0 100 65.00 .00 35.00 65.0% Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 23 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 4 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 76850110 437010 Comp Liability 9,000 0 9,000 .00 .00 9,000.00 .0% 76850110 437020 Fire & Casualty 14,006 0 14,006 18,085.00 .00 -4,079.00 129.1%* 76850110 437030 Worker's Comp I 2,000 0 2,000 2,000.00 .00 .00 100.0% 76850110 437041 Bonding & Other 2,027 0 2,027 .00 .00 2,027.00 .0% 76850110 437200 Loss Reserve Pa 3,000 0 3,000 3,000.00 .00 .00 100.0% 76850110 438010 Stormwater Util 19,834 0 19,834 6,314.88 .00 13,519.12 31.8% 2024/04/100981 10/18/2023 CRP 1,578.72 REF C -231018 2024 UB UB 76850110 438030 Electricity 20,117 0 20,117 5,694.62 .00 14,422.38 28.3% 2024/04/100357 10/11/2023 API 789.57 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 2024/04/100357 10/11/2023 API 117.12 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 2024/04/100357 10/11/2023 API 22.77 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 2024/04/100357 10/11/2023 API 277.43 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 2024/04/100357 10/11/2023 API 10.86 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 76850110 438050 Landfill Use 185 0 185 .00 .00 185.00 .0% 76850110 438070 Heating Fuel/Ga 5,000 0 5,000 114.37 .00 4,885.63 2.3% 2024/04/100357 10/11/2023 API 11.44 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 2024/04/100357 10/11/2023 API 11.44 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 2024/04/100357 10/11/2023 API 13.55 VND 010319 VCH MIDAMERICAN ENERGY MidAmBilling 10112023 43757 76850110 438080 Sewer Utility C 1,793 0 1,793 1,595.44 .00 197.56 89.0% 2024/04/100981 10/18/2023 CRP 385.68 REF C -231018 2024 UB UB 76850110 438090 Water Utility C 2,254 0 2,254 1,508.36 .00 745.64 66.9% 2024/04/100981 10/18/2023 CRP 363.16 REF C -231018 2024 UB UB Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 24 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 5 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 76850110 438100 Refuse Collecti 2,846 0 2,846 649.50 .00 2,196.50 22.8% 76850110 438110 Local Phone Ser 186 0 186 .00 .00 186.00 .0% 76850110 438120 Long Distance S 0 0 0 .00 .00 .00 .0% 76850110 442010 Other Building 13,599 0 13,599 3,968.11 .00 9,630.89 29.2% 2024/04/100189 10/02/2023 API 835.00 VND 010358 VCH OVERHEAD DOOR COMPAN Hangar 72 Door Cable Broken 292541 2024/04/100189 10/02/2023 API 678.00 VND 010856 VCH JET AIR INC IOW Groundskeeping/Janitorial serv 292501 2024/04/100629 10/10/2023 API 145.00 VND 011047 VCH HAWKEYE COMMUNICATIO 2023 Alarm Inspections 43803 2024/04/100989 10/02/2023 API 90.00 VND 016684 VCH STANDARD PEST Sep FY24 Quarterly Pest Contro 292766 76850110 442020 Structure R&M S 770 0 770 252.35 .00 517.65 32.8% 2024/04/100629 10/10/2023 API 252.35 VND 010823 VCH SCHUMACHER ELEVATOR FY24 Quarterly OG Maint 43833 76850110 442030 Heating & Cooli 1,963 0 1,963 848.99 .00 1,114.01 43.2% 76850110 442040 Cooling Equipme 0 0 0 .00 .00 .00 .0% 76850110 442060 Electrical & Pl 5,000 0 5,000 1,558.87 .00 3,441.13 31.2% 2024/04/100189 10/02/2023 API 345.45 VND 010014 VCH ADVANCED ELECTRICAL Replace bulbs on beacon tower 43718 2024/04/101039 10/17/2023 API 579.58 VND 011374 VCH CARE AMBULANCE SERVI Electrical Repairs - Building 292616 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,000 0 10,000 739.10 .00 9,260.90 7.4% 76850110 444060 Cable & Electri 0 0 0 .00 .00 .00 .0% 76850110 445030 Nursery Srvc-La 50,000 0 50,000 30,745.00 .00 19,255.00 61.5% 2024/04/100189 10/02/2023 API 6,215.00 VND 010856 VCH JET AIR INC IOW Groundskeeping/Janitorial serv 292501 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 25 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 6 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 76850110 445080 Snow and Ice Re 29,723 0 29,723 .00 .00 29,723.00 .0% 76850110 445100 Towing 0 0 0 .00 .00 .00 .0% 76850110 445110 Testing Service 1,500 0 1,500 228.00 .00 1,272.00 15.2% 76850110 445140 Outside Printin 0 0 0 .00 .00 .00 .0% 76850110 445230 Other Operating 956 0 956 541.02 .00 414.98 56.6% 2024/04/100275 10/02/2023 API 228.00 VND 011047 VCH HAWKEYE COMMUNICATIO 2023-2024 Fire Alarm Monitorin 43742 76850110 446010 Administrative 0 0 0 .00 .00 .00 .0% 76850110 446100 City Attorney C 7,970 0 7,970 2,656.64 .00 5,313.36 33.3% 2024/04/101273 10/26/2023 GEN 664.17 REF REJE#2 Airport to Attorney 76850110 446120 ITS-Server/Stor 294 0 294 81.18 .00 212.82 27.6% 76850110 446130 ITS-PC/Peripher 16,424 0 16,424 3,874.50 .00 12,549.50 23.6% 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,958 0 8,958 .00 .00 8,958.00 .0% 76850110 446190 ITS-Software SA 239 0 239 58.65 .00 180.35 24.5% 76850110 446200 Photocopying Ch 1,200 0 1,200 400.00 .00 800.00 33.3% 2024/04/101277 10/31/2023 GEN 100.00 REF CopChb FY24Copier Chargebacks 76850110 446220 Phone Service C 0 0 0 .00 .00 .00 .0% Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 26 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 7 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 76850110 446300 Phone Equipment 1,455 0 1,455 358.90 .00 1,096.10 24.7% 76850110 446320 Mail Chargeback 200 0 200 150.21 .00 49.79 75.1% 76850110 446350 City Vehicle Re 36,278 0 36,278 10,095.46 .00 26,182.54 27.8% 76850110 446360 City Vehicle Re 0 0 0 .00 .00 .00 .0% 76850110 446370 Fuel Chargeback 4,481 0 4,481 1,048.08 .00 3,432.92 23.4% 76850110 446380 Vehicle R&M Cha 19,830 0 19,830 1,922.83 .00 17,907.17 9.7% 76850110 448040 City Sponsored 0 0 0 .00 .00 .00 .0% 76850110 449055 Permitting Fees 440 0 440 700.00 .00 -260.00 159.1%* 76850110 449060 Dues & Membersh 950 0 950 342.00 .00 608.00 36.0% 2024/04/100189 10/02/2023 API 342.00 VND 010229 VCH IOWA CITY AREA BUSIN Annual Dues 292491 76850110 449120 Equipment Renta 0 0 0 200.00 .00 -200.00 100.0%* 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 .00 .00 100.00 .0% Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 27 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 8 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 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 1,000 0 1,000 .00 .00 1,000.00 .0% 76850110 455110 Software 394 0 394 .00 .00 394.00 .0% 76850110 455120 Misc Computer H 0 0 0 2,588.48 .00 -2,588.48 100.0%* 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 678 0 678 22.89 .00 655.11 3.4% 2024/04/100189 10/02/2023 API 22.89 VND 010856 VCH JET AIR INC IOW maintenance reimbursement 292501 76850110 467020 Equipment R&M S 1,000 0 1,000 5.89 .00 994.11 .6% 76850110 467160 Other Vehicle R 148 0 148 .00 .00 148.00 .0% 76850110 468030 Asphalt 100 0 100 .00 .00 100.00 .0% 76850110 468050 Sand 100 0 100 .00 .00 100.00 .0% 76850110 469040 Traffic Cntrl I 365 0 365 .00 .00 365.00 .0% Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 28 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 9 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 76850110 469190 Minor Equipment 500 0 500 .00 .00 500.00 .0% 76850110 469200 Tools 500 0 500 53.39 .00 446.61 10.7% 2024/04/100189 10/02/2023 API 53.39 VND 010856 VCH JET AIR INC IOW maintenance reimbursement 292501 76850110 469210 First Aid/Safet 278 0 278 172.78 .00 105.22 62.2% 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 .00 .00 .00 .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% Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 29 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 10 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 120 Airport Mural 76850110 362100 120 Contrib & Do 0 0 0 .00 .00 .00 .0% 76850110 473010 120 Contracted I 0 0 0 12,800.00 .00 -12,800.00 100.0%* 651 Fly Iowa 2014 76850110 432080 651 Other Profes 0 0 0 .00 .00 .00 .0% 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% 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% Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 30 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 11 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ACCOUNTS FOR:ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 7600 Airport APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL 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% 76850110 437010 652 Comp Liabili 0 0 0 .00 .00 .00 .0% 76850110 438100 652 Refuse Colle 0 0 0 .00 .00 .00 .0% 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% 2024/04/100189 10/02/2023 API 22.89 VND 010856 VCH JET AIR INC IOW maintenance reimbursement 292501 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% 2024/04/100189 10/02/2023 API 22.89 VND 010856 VCH JET AIR INC IOW maintenance reimbursement 292501 TOTAL Airport Operations -490 0 -490 18,958.32 .00 -19,448.32-3869.0% TOTAL Airport -490 0 -490 18,958.32 .00 -19,448.32-3869.0% TOTAL REVENUES -406,797 0 -406,797 -131,057.04 .00 -275,739.96 TOTAL EXPENSES 406,307 0 406,307 150,015.36 .00 256,291.64 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 31 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 12 FY2024 BUDGET - OCTOBER DETAIL FOR 2024 04 JOURNAL DETAIL 2024 4 TO 2024 4 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USE/COL GRAND TOTAL -490 0 -490 18,958.32 .00 -19,448.32-3869.0% ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 32 of 34 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT Report generated: 11/06/2023 14:00 User:mtharp Program ID: glytdbud Page 13 FY2024 BUDGET - OCTOBER 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: 2024/ 4 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: N Print journal detail: Y From Yr/Per: 2024/ 4 To Yr/Per: 2024/ 4 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: November 9, 2023 Page 33 of 34 Airport Commission Agenda & Info Packet Meeting Date: November 9, 2023 Page 34 of 34