The URL can be used to link to this page

Home My WebLink About07-17-2014 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JULY 17, 2014 - 6:00 P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: 2 min* June 23, 2014; July 14, 2014 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion /Action: a. Airport Commerce Park 5 min b. Airport Master Plan 10 min c. FAA/IDOT Projects: AECOM / David Hughes 30 min i. Runway 7/25 Parallel Taxiway ii. Roofing Rehabilitation 1. Consider a resolution accepting project as complete iii. 2014 IDOT Grant Projects 1. Taxiway B rehabilitation and overlay 2. Taxiway Blighting 3. North T -hangar pavement maintenance d. Fuel System Storage Rehabilitation 15 min e. Gilbert Street Land Lease 10 min f. FBO / Flight Training Reports 5 min i. Jet Air ii. Iowa Flight Training g. Airport "Operations" 10 min i. Strategic Plan -Implementation ii. Budget iii. Management h. Subcommittee Reports 5 min i. For July: None ii. For August: Budget i. Commission Members' Reports 2 min j. Staff Report 2 min 5. Set next regular meeting for August 21, 2014 at 6:00 p.m. 6. Adjourn *The times listed in the agenda are the anticipated duration of that particular agenda item. The actual discussion may take more or less time than anticipated Airport Commission Agenda & Info Packet Meeting Date: 07-17-14 Page 2 of 23 Airport Commission June 23, 2014 Page 1 MINUTES IOWA CITY AIRPORT COMMISSION JUNE 23, 2014 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Jose Assouline, Chris Ogren Members Absent: Minnetta Gardinier Staff Present: Eleanor Dilkes, Michael Tharp Others Present: Matt Wolford, Jeff Edberg, Melissa Underwood DRAFT RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM: Chairperson Ogren called the meeting to order at 6:07 P.M. APPROVAL OF MINUTES: Minutes from the May 15, 2014, meeting were reviewed. Tharp noted a correction from Dulek: on page 5, the votes for going into and returning from Executive Session. Assouline moved to approve the minutes of the May 15, 2014, meeting as amended; seconded by Ogren. Motion carried 2-0, Gardinier absent. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: a. Airport Commerce Park — Jeff Edberg addressed Members, stating that there hasn't been much activity lately in land sales. He noted that the closing for Lot #8 is scheduled for September. Edberg then presented some current figures on prices of land in the area and what the real estate market has been like for the past few years. Members briefly discussed this issue with Edberg. b. Fly Iowa — Ogren asked if there was anything they needed to cover on this this evening. She noted the problems she ran into in sending an email message to members of the local chapter of the Experimental Aircraft Association, but that the message was sent out. Wolford stated that he has come up with a sign-up list for volunteers. So far they have several signed up for this and he will be meeting with the Boy Scouts tonight about helping with parking at the Fairgrounds. Wolford spoke further about the volunteer groups that have signed up so far to help. Airport Commission Agenda & Info Packet Meeting Date: 07-17-14 Page 3 of 23 Airport Commission June 23, 2014 Page 2 C. Airport Master Plan — Melissa Underwood addressed Members regarding the Airport's Master Plan schedule. She noted that last Friday a staff engineer and a planner were at the Airport performing an inventory. They took a large volume of pictures using a GPS app at the Airport for this part of the process. Then about two weeks ago, staff flew over the airport in order to gather the data they need for obstruction data, hangar heights, etc., for that portion of the process. Next a survey crew will be out to do their portion of the process. Underwood then spoke about the Master Plan Advisory Group that will need to be formed. Their plan is to have the first meeting in July. It should take somewhere between 12 and 18 months to complete the entire process, according to Underwood. Underwood then addressed who might make up the Master Plan Advisory Group. . Members discussed this, with Tharp stating that his thoughts were to have himself, someone from Jet Air, and a pilot for the Airport side; someone from the City Manager's office; someone from either Economic Development or Planning; and then one or two neighbors of the Airport. Underwood further explained what this first meeting would encompass and the need for them to get things moving. Tharp stated that he will work with Underwood to get this group together for a July date. d. FAA/IDOT Projects: AECOM (David Hughes) — i. Runway 7/25 Parallel Taxiway — Tharp noted that work has begun on the west ditch, which is the last item to be completed on this project. ii. Roofing Rehabilitation — Tharp stated that this is about 95% done. He added that they had some water leakage recently, and they are trying to figure out where this is coming from. iii. 2014 IDOT Grant Projects: 1. Taxiway B rehabilitation and overlay — Tharp stated that this is complete and they are awaiting final paperwork at this time. 2. Taxiway B lighting — The lights and signs were completed late last week, according to Tharp. 3. North T -hangar pavement maintenance —Tharp noted that this is also complete and awaiting final paperwork. iv. Runway 7/25 Obstruction Mitigation — Light Pole Replacement — Tharp stated that this involves the three poles that were lowered at the car dealership. He, the contractor, and the owner all met recently to make sure things were in working order. 1. Consider a resolution accepting project as complete — Ogren moved to consider Resolution #A14-04 accepting this project as complete, seconded by Assouline. Motion carried 2-0, Gardinier absent. e. FBO / Flight Training Reports — i. Jet Air — Matt Wolford shared the monthly reports with Members. He briefly touched on such tasks as changing light bulbs, mowing, and weeding. Painting projects were a large part of the past month's tasks. Wolford further explained some of the projects. Wolford stated that staff also mulched and trimmed the area around the Airport sign out on Riverside Drive. Continuing, Airport Commission Agenda & Info Packet Meeting Date: 07-17-14 Page 4 of 23 Airport Commission June 23, 2014 Page 3 Wolford spoke about the Air Race Classic that recently came through and the increase in fuel sales. He then spoke about Jet Air's in-house training for pilots, noting that they will be partnering with SimuFlight. Ogren thanked Wolford for all of his efforts with Fly Iowa. ii. Iowa Flight Training — None. f. Airport "Operations:" i. Strategic Plan -Implementation — None. ii. Budget — Tharp noted that things have been very busy with the Air Race Classic last week and the upcoming Fly Iowa event. He added that if things go okay operationally, he will be taking the last half of July off. Ogren added that she will be out of the country those last two weeks in July. Tharp stated that the fiscal year is almost up. Wolford asked if there are any extra funds available as the fuel system needs to be freshly painted. Tharp noted that he has some ideas on funding this. iii. Management — None. g. Subcommittee Reports — i. For June — Infrastructure - Ogren asked who is on this subcommittee. Tharp noted that he and Assouline are the Infrastructure subcommittee. Ogren stated that she believes they should rethink having these subcommittees and instead have ad hoc committees as needed. Others agreed that ad hoc committees would probably work best at this point in time. ii. For July — None. h. Commission Members' Reports — Ogren shared that she helped with timing for the Air Race Classic event. Assouline asked how the event went, and Tharp noted that they had 14 or 15 pilots spend the night, and all but two had left by 7:00 the next morning. i. Staff Reports — Tharp stated that he will continue to be busy with the Fly Iowa planning. SET NEXT REGULAR MEETING FOR: The next regular meeting of the Airport Commission will be held on Thursday, July 17, 2014, at 6:00 P.M. at the Airport Terminal Building. ADJOURN: Assouline made the motion to adjourn the meeting at 7:04 P.M.; seconded by Ogren. Motion carried 2-0, Gardinier absent. CHAIRPERSON DATE Airport Commission June 23, 2014 Page 4 Airport Commission Agenda & Info Packet Meeting Date: 07-17-14 Page 5 of 23 Airport Commission ATTENDANCE RECORD 2014 Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time TERM O O O O O O O O O O O O N N W A Ln W V NAME EXP. O -4 \ ?_ \ rn \ ?_ \ rn ?_ N o -4 -4 Ln N W A A A A A A A A A A A A 03/01/14 X X X X X X X N N N N N Howard M M M M M Horan Minnetta 03/01/15 X X X X X X X X X X O/ Gardinier E Jose 03/01/16 X X X X X X X X X X X Assouline Chris 03/01/14 X X X X X X X X X X X Ogren Paul 03/01/17 X X X X X X X X N N N N Hofineyer M M M M Key: X = Present X/E = Present for Part of Meeting O = Absent O/E = Absent/Excused NM = Not a Member at this time Airport Commission Agenda & Info Packet Meeting Date: 07-17-14 Page 6 of 23 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION NO. RESOLUTION ACCEPTING THE WORK FOR THE REHABILITATION OF TERMINAL BUILDING AND BUILDING D ROOFS PROJECT WHEREAS, the engineering consultant AECOM has recommended that the work on the above referenced project by T&K Roofing, Inc. be accepted as complete; and WHEREAS, the final contract price is $126,898.00 which is established from the original contract cost of $127,874.00 minus $976.00 from Change Orders #1 for actual quantities installed. NOW, THEREFORE, BE IT RESOLVED BY THE IOWA CITY AIRPORT COMMISSION THAT: Said improvements are hereby accepted by the Iowa City Airport Commission. Passed and approved this day of ., • ATTEST: SECRETARY It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays Approved b City Attorney's Office Absent 2014. the Resolution be ASSOUIine Gardinier Ogren A_COM June 12, 2014 Ms. Christine Ogren Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 Airport Commission Agenda & Info Packet Meeting Date: 07-17-14 AECOM SUBJECT: Rehabilitate Terminal Building And Building `D' Roofs Iowa City Municipal Airport Iowa City, Iowa Iowa DOT GAVI Project 911301OW300 Contract No. 14146 AECOM ID No. 60299358 500 SW 7th Street Suite 301 Des Moines, Iowa 50309 www.aecom.com Page 7 of 23 5153237910 tel 515 244 4803 fax Dear Ms. Ogren: By this letter, we hereby state: 1. We have made a final review of the project on June 9, 2014. 2. To the best of our knowledge and belief, based on observations of AECOM staff during construction, the contractor, T&K Roofing Company, has performed the work in accordance with the proposal requirements in effect for the above -referenced project. 3. The total cost of the completed work is $ 126,898.00. P\00299358 low Roofing Project 2013300-Communications'.310 Client\C0091214.certiflcatlon doc I hereby certify that this engineering document was prepared by me or °"`deessra"`"" under my direct personal supervision and that I am a duly licensed Professional Engineer under the laws of the state of Iowa. r`hOj OAYIu B. S45' HUGHES :2 E David B. Hughes Date OWP ° a` License No. 13037 My license renewal date is December 31, 2015. Pages or sheets covered by this seal: P\00299358 low Roofing Project 2013300-Communications'.310 Client\C0091214.certiflcatlon doc Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:05 (CITY OF IOWA CITY IP 1 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2014/12 TO 2014/12 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION 76850110 Airport Operations 7600-70-70-850-850100-850110-000-0000-432080-651 Other Professional Services 013205 EDGREN, ERIK Fly Iowa #1 2014 12 INV P 2,000.00 M062714 119566 FLY IOWA AIRSHOW PE 013206 VANGUARD SQUADRON IN Fly Iowa #2 2014 12 INV P 2,000.00 M062714 119567 Fly Iowa Performer ACCOUNT TOTAL 4,000.00 7600-70-70-850-850100-850110-000-0000-435060- Legal Publications 010238 IOWA CITY PRESS CITI 0002298963 2014 12 INV P 12.10 062014 119075 Publications 5/5/14 ACCOUNT TOTAL 12.10 7600-70-70-850-850100-850110-000-0000-436030- Transportation 013141 OGREN, CHRISTINE 042314 2014 12 INV P 137.76 060614 118551 Travel Refund - Des ACCOUNT TOTAL 137.76 7600-70-70-850-850100-850110-000-0000-436080- Meals 013141 OGREN, CHRISTINE 042314 2014 12 INV P 27.00 060614 118551 Travel Refund - Des ACCOUNT TOTAL 27.00 7600-70-70-850-850100-850110-000-0000-437020- Fire & Casualty Insurance 010810 SELECTIVE INSURANCE FLD1074169 2014 12 INV P 3,622.00 060614 118598 FY15 FLOOD INSURANC ACCOUNT TOTAL 3,622.00 7600-70-70-850-850100-850110-000-0000-438100- Refuse Collection Charges 011001 ABC DISPOSAL SYSTEMS 689591 2014 12 INV P 28.00 062714 119255 SOLID WASTE SERVICE 011001 ABC DISPOSAL SYSTEMS 689592 2014 12 INV P 69.00 062714 119255 SOLID WASTE SERVICE 97.00 ACCOUNT TOTAL 97.00 7600-70-70-850-850100-850110-000-0000-438110- Local Phone Service 011937 ALLIANCE CONNECT 40008309 2014 12 INV P 85.62 062014 118993 NN 2014 INV 400083 ACCOUNT TOTAL 85.62 7600-70-70-850-850100-850110-000-0000-442010- Other Building R&M Services 010292 LIBERTY DOORS INC 091384 2014 12 INV P 586.00 060614 118518 Terminal Door Latch 010452 T & K ROOFING & SHEE 2698 2014 12 INV P 248.00 060614 118605 Roof Leak Inspectio ACCOUNT TOTAL 834.00 7600-70-70-850-850100-850110-000-0000-442020- Structure R&M Services 012238 OTIS ELEVATOR COMPAN CER65338 314 2014 12 INV P 150.00 061314 118841 ELEVATOR SERVICE CO ACCOUNT TOTAL 150.00 Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:05 (CITY OF IOWA CITY IP 2 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2014/12 TO 2014/12 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION 7600-70-70-850-850100-850110-000-0000-442060- Electrical & Plumbing R&M Srvc 010014 ADVANCED ELECTRICAL 46869 2014 12 INV P 2,830.00 060614 118419 Hangar 29 & 30 new 010014 ADVANCED ELECTRICAL 46902 2014 12 INV P 189.75 060614 118419 Hangar #2 Electrica 3,019.75 ACCOUNT TOTAL 3,019.75 7600-70-70-850-850100-850110-000-0000-442070- Bldg Pest Control Services 010192 HAWKEYE PEST CONTROL 062414 2014 12 INV P 33.95 070314 120073 Pest Control ACCOUNT TOTAL 33.95 7600-70-70-850-850100-850110-000-0000-452010- Office Supplies 090215 OFFICEMAX CT*IN#1142 48533 2014 12 INV P 188.22 PCARD P -Card invoice for ACCOUNT TOTAL 188.22 7600-70-70-850-850100-850110-000-0000-455120- Misc Computer Hardware 090448 AMAZON MKTPLACE PMTS 48566 2014 12 INV P 201.76 PCARD P -Card invoice for ACCOUNT TOTAL 201.76 7600-70-70-850-850100-850110-000-0000-466070- Other Maintenance Supplies 010164 FREEMAN LOCK AND ALA 48413 2014 12 INV P 9.75 PCARD P -Card invoice for ACCOUNT TOTAL 9.75 ORG 76850110 TOTAL 12,418.91 FUND 7600 Airport TOTAL: 12,418.91 ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet nn PP}inn na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 1 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 362100 Contrib & Donations 76850110 362100 651 Contrib & Donat 381100 Interest on Investments 76850110 381100 Interest on Invest 382100 Land Rental 76850110 382100 Land Rental 382200 Building/Room Rental 76850110 382200 Building/Room Rent 384200 Vending Machine Commission 76850110 384200 Vending Machine Cc 384900 Other Commissions 76850110 384900 Other Commissions 392100 Sale of Land 76850110 392100 Sale of Land 393120 General Levy 76850110 393120 General LevV 411000 Perm Full Time 76850110 411000 Perm Full Time 0 0 0 -28,410.00 -1,314 0 -1,314 402.72 -43,757 0 -43,757 -50,108.60 -250,000 0 -250,000 -250,382.83 -108 0 -108 -79.20 -24,140 0 -24,140 -26,969.90 0 -457,000 -457,000 -212,505.00 -72,342 0 -72,342 -72,342.00 52,955 0 52,955 51,279.12 00 28,410.00 100.0°% 00 -1,716.72 -30.6°%* 00 6,351.60 114.5°% 00 382.83 100.2°% 00 -28.80 73.3°%* 00 2,829.90 111.7% 00 -244,495.00 46.5°%* 00 .00 100.0°% 00 1,675.88 96.8°% Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 2 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 413000 Temporary Employees 76850110 413000 Temporary Employee 414500 Longevity Pay 76850110 414500 Longevity Pay 421100 Health Insurance 76850110 421100 Health Insurance 421200 Dental Insurance 76850110 421200 Dental Insurance 421300 Life Insurance 76850110 421300 Life Insurance 421400 Disability Insurance 76850110 421400 Disability Insuran 422100 FICA 76850110 422100 FICA 423100 IPERS 76850110 423100 IPERS 431020 Court Costs & Services 76850110 431020 Court Costs & Sery 0 0 0 1,203.53 .00 -1,203.53 100.0°%* 325 0 325 325.00 .00 .00 100.0°% 4,671 0 4,671 4,650.48 .00 20.52 99.6°% 327 0 327 326.88 .00 .12 100.0°% 115 0 115 135.91 .00 -20.91 118.2%* 256 0 256 250.27 .00 5.73 97.8°% 4,076 0 4,076 4,004.15 .00 71.85 98.2°% 4,758 0 4,758 4,715.75 .00 42.25 99.1% 0 0 0 98.00 .00 -98.00 100.0°%* Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 3 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 432020 Annual Audit 76850110 432020 Annual Audit 432080 Other Professional Services 76850110 432080 Other Professional 76850110 432080 651 Other Professio 435056 Delivery Services 76850110 435056 Delivery Services 435057 Couriers 76850110 435057 Couriers 435060 Legal Publications 76850110 435060 Legal Publications 436030 Transportation 76850110 436030 Transportation 436050 Registration 76850110 436050 Registration 436060 Lodging 76850110 436060 Lodging 436080 Meals 76850110 436080 Meals 347 0 347 1,386.83 .00 -1,039.83 399.7%- 0 0 0 7,550.00 .00 -7,550.00 100.0°%* 0 0 0 4,000.00 .00 -4,000.00 100.0°%* 15 0 15 .00 .00 15.00 .0°% 0 0 0 18.39 .00 -18.39 100.0°%* 54 0 54 165.93 .00 -111.93 307.3°%* 950 0 950 137.76 .00 812.24 14.5% 380 0 380 198.00 .00 182.00 52.1°% 380 0 380 232.96 .00 147.04 61.3% 190 0 190 54.00 .00 136.00 28.4% 07/15/2014 11:08 mtharp FOR 2014 12 ACCOUNTS FOR: 76850110 Airport Operations Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT P 4 glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 437010 Comp Liability Insurance 3,407.14 76850110 437010 Comp Liability Ins 5,170 437020 Fire & Casualty Insurance 112.00 76850110 437020 Fire & Casualty In 11,871 437030 Worker's Comp Insurance 5,150.00 76850110 437030 Worker's Comp Insu 50 437041 Bonding & Other Insurance 14,928.84 76850110 437041 Bonding & Other In 910 437200 Loss Reserve Payment 6,019.69 76850110 437200 Loss Reserve Pavme 5,150 438010 Stormwater Utility Charges .00 76850110 438010 Stormwater Utilit 9,469 438030 Electricity 00 76850110 438030 Electricity 15,994 438050 Landfill Use 76850110 438050 Landfill Use 0 438070 Heating Fuel/Gas 93.3°% 76850110 438070 Heating Fuel/Gas 4,290 0 5,170 3,407.14 0 11,871 11,627.00 0 50 112.00 0 910 875.00 0 5,150 5,150.00 0 9,469 13,018.08 0 15,994 14,928.84 0 0 35.64 0 4,290 6,019.69 00 1,762.86 65.9°% 00 244.00 97.9°% 00 -62.00 224.0°%* 00 35.00 96.2°% 00 .00 100.0°% 00 -3,549.08 137.5°%* 00 1,065.16 93.3°% 00 -35.64 100.0°%* 00 -1,729.69 140.3%* 07/15/2014 11:08 mtharp FOR 2014 12 ACCOUNTS FOR: 76850110 Airport Operations Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT P 5 glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 438080 Sewer Utility Charge 2,475.73 76850110 438080 Sewer Utility Char 1,124 438090 Water Utility Charge -1,035.71 76850110 438090 Water Utility Char 1,101 438100 Refuse Collection Charges 0 0 76850110 438100 Refuse Collection 1,198 438110 Local Phone Service 60.30 76850110 438110 Local Phone Servic 0 438120 Long Distance Service -5.30 76850110 438120 Long Distance Sery 55 442010 Other Building R&M Services 0 952 76850110 442010 Other Building R&M 10,392 442020 Structure R&M Services .00 76850110 442020 Structure R&M Sery 3,865 442030 Heating Equipment R&M Services 734.50 76850110 442030 Heating Equipment 952 442040 Cooling Equipment R&M Services 846.00 76850110 442040 Cooling Equipment 846 0 1,124 2,475.73 220.3°%* 0 1,101 2,136.71 -1,035.71 0 1,198 1,067.00 00 0 0 256.86 0 55 60.30 100.0°%* 0 10,392 16,423.04 -5.30 0 3,865 1,094.00 00 0 952 217.50 0 846 .00 28.3°% 00 -1,351.73 220.3°%* 00 -1,035.71 194.1°%* 00 131.00 89.1°% 00 -256.86 100.0°%* 00 -5.30 109.6°%* 00 -6,031.04 158.0°%* 00 2,771.00 28.3°% 00 734.50 22.8°% 00 846.00 .0°% 07/15/2014 11:08 mtharp FOR 2014 12 ACCOUNTS FOR: 76850110 Airport Operations Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT P 6 glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 442060 Electrical & Plumbing R&M Srvc 7,408.55 76850110 442060 Electrical & Plumb 4,154 442070 Bldg Pest Control Services 49.55 76850110 442070 Bldg Pest Control 423 443050 Radio Equipment R&M Services 0 2,284 76850110 443050 Radio Equipment R& 1,172 443080 Other Equipment R&M Services 35,600.00 76850110 443080 Other Equipment R& 2,284 445030 Nursery Srvc-Lawn & Plant Care 1,840.00 76850110 445030 Nursery Srvc-Lawn 37,440 445080 Snow and Ice Removal 0 0 76850110 445080 Snow and Ice Remov 18,720 445110 Testing Services 264.00 76850110 445110 Testing Services 1,017 445140 Outside Printing -19.95 76850110 445140 Outside Printing 0 445230 Other Operating Services -264.00 76850110 445230 Other Operating Se 0 0 4,154 7,408.55 178.3°%* 0 423 373.45 49.55 0 1,172 .00 0 2,284 6,656.73 .0°% 0 37,440 35,600.00 291.5°%* 0 18,720 18,000.00 1,840.00 0 1,017 400.00 00 0 0 19.95 0 0 264.00 39.3°% 00 -3,254.55 178.3°%* 00 49.55 88.3°% 00 1,172.00 .0°% 00 -4,372.73 291.5°%* 00 1,840.00 95.1°% 00 720.00 96.2°% 00 617.00 39.3°% 00 -19.95 100.0°%* 00 -264.00 100.0°%* Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 7 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 446100 City Attorney Chargeback 76850110 446100 City Attorney Char 446130 ITS-PC/Peripheral Supprt Chgbk 76850110 446130 ITS-PC/Peripheral 446140 ITS -Computer Replacement Chgbk 76850110 446140 ITS -Computer Repla 446150 ITS -Application Dvlp Fee Chgbk 76850110 446150 ITS -Application Dv 446160 ITS-Network/Internet Chgbk 76850110 446160 ITS-Network/Intern 446200 Photocopying Chargeback 76850110 446200 Photocopying Charg 446220 Phone Service Chargeback 76850110 446220 Phone Service Char 446300 Phone Equipment/Line Chgbk 76850110 446300 Phone Eguinment/Li 446320 Mail Chargeback 76850110 446320 Mail Chargeback 5,731 0 5,731 6,624.59 .00 -893.59 115.6%* 800 0 800 800.00 .00 .00 100.0°% 2,867 0 2,867 810.14 .00 2,056.86 28.3°% 477 0 477 671.00 .00 -194.00 140.7°%* 360 0 360 720.00 .00 -360.00 200.0°%* 179 0 179 24.90 .00 154.10 13.9% 1,021 0 1,021 769.32 .00 251.68 75.3°% 1,110 0 1,110 1,110.00 .00 .00 100.0°% 280 0 280 302.68 .00 -22.68 108.1°%* 07/15/2014 11:08 mtharp FOR 2014 12 ACCOUNTS FOR: 76850110 Airport Operations Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT P 8 glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 446350 City Vehicle Replacement Chgbk 18,041.08 76850110 446350 City Vehicle Repla 16,389 446360 City Vehicle Rental Chargeback 0 3,953 76850110 446360 City Vehicle Renta 326 446370 Fuel Chargeback 19,194.01 76850110 446370 Fuel Chargeback 3,953 446380 Vehicle R&M Chargeback 123.2%* 76850110 446380 Vehicle R&M Charge 16,457 448040 City Sponsored Event 0 1,175 76850110 448040 City Sponsored Eve 5,000 449055 Permitting Fees .00 76850110 449055 Permitting Fees 65 449060 Dues & Memberships 00 76850110 449060 Dues & Memberships 1,175 449120 Equipment Rental 76850110 449120 Equipment Rental 464 449280 Misc Services & Charges 103.0°%* 76850110 449280 Misc Services & Ch 0 0 16,389 18,041.08 0 326 248.59 0 3,953 4,871.30 0 16,457 19,194.01 00 0 5,000 5,000.00 123.2%* 0 65 1,015.00 -2,737.01 0 1,175 1,210.00 0 464 .00 0 0 204.00 00 00 -1,652.08 110.1%* 00 77.41 76.3°% 00 -918.30 123.2%* 00 -2,737.01 116.6%* 00 .00 100.0°% 00 -950.00 1561.5%* 00 -35.00 103.0°%* 00 464.00 .0°% 00 -204.00 100.0°%* Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 9 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 449350 Meals (non -travel) 76850110 449350 Meals (non -travel) 449360 Interest Expense 76850110 449360 Interest Expense 452010 Office Supplies 76850110 452010 Office Supplies 452030 Minor Office Equip/Furniture 76850110 452030 Minor Office Eauin 454020 Subscriptions 76850110 454020 Subscriptions 455120 Misc Computer Hardware 76850110 455120 Misc Computer Hard 461040 Other Agriculture Chemicals 76850110 461040 Other Agriculture 466040 Plumbing Supplies 76850110 466040 Plumbing Supplies 466050 Electrical Supplies 76850110 466050 Electrical Supplie 0 0 0 106.81 .00 -106.81 100.0°%* 33,830 0 33,830 33,829.44 .00 .56 100.0°% 830 0 830 526.77 .00 303.23 63.5°% 291 0 291 250.00 .00 41.00 85.9°% 630 0 630 24.00 .00 606.00 3.8% 0 0 0 201.76 .00 -201.76 100.0°%* 50 0 50 364.56 .00 -314.56 729.1°%* 22 0 22 .00 .00 22.00 .0°% 1,114 0 1,114 181.10 .00 932.90 16.3% Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 10 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 466070 Other Maintenance Supplies 76850110 466070 Other Maintenance 467020 Equipment R&M Supplies 76850110 467020 Equipment R&M Supp 467160 Other Vehicle R&M Supplies 76850110 467160 Other Vehicle R&M 468050 Sand 76850110 468050 Sand 469040 Traffic Cntrl Imprvmt Supplies 76850110 469040 Traffic Cntrl Impr 469190 Minor Equipment 76850110 469190 Minor Equipment 469200 Tools 76850110 469200 Tools 469260 Fire Ext & Refills 76850110 469260 Fire Ext & Refills 469320 Miscellaneous Supplies 76850110 469320 Miscellaneous Supp 800 0 800 351.03 .00 448.97 43.9°% 67 0 67 421.14 .00 -354.14 628.6°%* 60 0 60 .00 .00 60.00 .0% 28 0 28 40.23 .00 -12.23 143.7%* 0 0 0 283.42 .00 -283.42 100.0°%* 337 0 337 .00 .00 337.00 .0°% 604 0 604 .00 .00 604.00 .0°% 682 0 682 194.90 .00 487.10 28.6°% 270 0 270 .00 .00 270.00 .0°% Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 11 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 469360 Food and Beverages -31.80 100.0°%* 00 -3,490.00 76850110 469360 Food and Beverages 0 0 0 31.80 473010 Contracted Improvements 78,438.20 100.0°% 00 171,251.70 76850110 473010 Contracted Improve 0 0 0 3,490.00 473020 Non -Contracted Improvements -208,266.19 00 261.906.16 76850110 473020 Non -Contracted Imp 40,000 0 40,000 1,225.00 490040 Capital Project Funding 76850110 490040 Capital Project Fu 0 0 0 -78,438.20 490190 Interfund Loan 76850110 490190 Interfund Loan 30,869 319,900 350,769 179,517.30 TOTAL Airport Operations -17,077 -137,100 -154,177 -207,816.97 TOTAL REVENUES -391,661 -457,000 -848,661 -640,394.81 TOTAL EXPENSES 374.584 319.900 694.484 432.577.84 00 -31.80 100.0°%* 00 -3,490.00 100.0°%* 00 38,775.00 3.1% 00 78,438.20 100.0°% 00 171,251.70 51.2°% 00 53,639.97 134.8°% 00 -208,266.19 00 261.906.16 Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 12 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2014 12 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED GRAND TOTAL -17.077 -137.100 -154.177 -207.816.97 ** END OF REPORT - Generated by Michael Tharp ** 00 53.639.97 134.8°% Airport Commission Agenda & Info Packet nn PPfin� na}Pn7-17-14 07/15/2014 11:08 (CITY OF IOWA CITY IP 13 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud Field # Total Page Break Sequence 1 9 Y Y Sequence 2 11 N N Sequence 3 0 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: Y 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: N From Yr/Per: 2013/ 1 To Yr/Per: 2014/ 1 Include budget entries: Y Incl encumb/liq entries: Y Sort by JE # or PO #: J Detail format option: 1 Include additional JE comments: N Sort/Total Budget Rollup: N Multiyear view: D Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Org 76850110 Object Project Rollup code Rollup year Rollup program Account type Account status REPORT OPTIONS Year/Period: 2014/12 Print MTD Version: N Roll projects to object: N Carry forward code: 1 Airport Commission Agenda & Info Packet Meeting Date: 07-17-14 Sub -committee List Iowa City Municipal Airport Commission Assignment Budget Community Liason Economic Development Events Infrastructure Last Updated: June 2014 Members Chair, Secretary, Ops Specialist Assouline, Ogren, Tharp Assouline, <open>, Tharp Gardinier, <open>, Tharp Gardinier, <open>, Tharp Reports Due August/February September/March October/April November/May January/June Page 23 of 23