The URL can be used to link to this page

Home My WebLink About07-16-2015 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, JULY 16, 2015 - 6:00 P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: 2 min* June 25. 2015 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion /Action: a. Airport Master Plan 20 min b. FAA/IDOT Projects: AECOM / David Hughes 20 min i. FY15 Obstruction Mitigation ii. Fuel Tank Rehabilitation iii. North T -hangar Electrical Service & LED lighting c. Airport "Operations" 15 min i. Strategic Plan -Implementation ii. Budget iii. Management d. FBO /Flight Training Reports 10 min i. Jet Air e. Commission Members' Reports 2 min f. Staff Report 5. Set next regular meeting for August 20, 2015 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: July 16, 2015 Page 2 of 36 Airport Commission June 25, 2015 Page 1 MINUTES IOWA CITY AIRPORT COMMISSION JUNE 25, 2015 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Jose Assouline, Jacob Odgaard, Chris Ogren Members Absent: David Davis, Minnetta Gardinier Staff Present: Michael Tharp, Sue Dulek Others Present: Matt Wolford, Melissa Underwood DRAFT RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM: Chairperson Gardinier called the meeting to order at 6:05 P.M. APPROVAL OF MINUTES: Minutes from the May 21, 2015, meeting were reviewed. Ogren moved to accept the minutes of the May 21, 2015, meeting as presented. Assouline seconded the motion. The motion carried 3-0. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: a. Airport Master Plan — Underwood gave the Commission members an update of the master plan group activities. Underwood discussed the process to date and then discussed runway design options that the master plan group had considered for recommendation. Underwood noted that one of the alternative design options to gain the most runway landing distance included changing the design category of the runway. Underwood stated they could get back 700 feet by changing this design item. Underwood also stated that there might be some other changes the Commission should weigh, which were that the runway width could decrease to 75 feet wide. Members asked questions regarding the change to which Underwood responded. Ogren asked Wolford what impact the change would have on Jet Air's operations. Wolford stated that the change would be appreciated. He stated that pilot's see the landing distance available and now might choose to use Cedar Rapids. With the change the landing distance Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 Page 3 of 36 Airport Commission June 25, 2015 Page 2 available would be closer to 4900 feet and instead they might say that's "good enough" for landing distance needed. Members continued to discuss the alternative designs of the runway ends. She stated additional alternatives to the runway 7 end could include a potential for a stopway, as well as additional lighting to aid aircraft. Members discussed those options. Underwood stated that next month she would have a presentation with AECOM regarding the obstruction mitigation work that would be required. b. FAA/IDOT Projects: AECOM (David Hughes) — i. FY15 Obstruction Mitigation— Tharp noted that Hughes was not presented stated they would have a presentation on the obstruction mitigation project at the next meeting ii. Fuel Tank Rehabilitation — Tharp noted that one of the inspections on some of the storage systems had been completed but that he needed to get information from the technician that did the inspection. He noted they had identified some valves that might needed to be replaced. Wolford reminded the Commission that during the work, the self-service pumps would also be offline and that Jet Air was preparing to serve everyone with full service. Ogren asked about the end date in time for SERTOMA and Tharp stated that it would be close. Odgaard asked about tenant notifications and Tharp stated that they were waiting until the first to send out the notices so that tenants had time to react but not forget. iii. North T -hangar Electrical Service & LED lighting — Tharp noted that the contractor was continuing to work and that they were waiting for some dryer weather to continue C. Airport Operations — i. Strategic Plan- Implementation — Tharp reminded the Commission that were holding on the Master Plan to update the strategic plan ii. Budget — Tharp noted that June was the end of the fiscal year. Tharp noted that they would have a better idea of the remaining. Tharp noted that they wanted to do a debt -free ceremony, but was giving some space as Cedar Rapids just did an event. iii. Management - 1. Use of E -Cigarettes - Tharp noted that the City Council was updating the city policy to include E -Cigarettes as a banned product under the policy. He stated that the Commission had the option to continue to policy. Members agreed by consensus to continue with the city policy d. FBO/Flight Training Reports I. Jet Air — Wolford talked about the maintenance work that had been done during the month. Wolford talked about some of the well-known politicians and others that have been through the Airport recently and in the past. Wolford discussed flight training operations with the Commission and what aircraft they're operating. Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 Page 4 of 36 Airport Commission June 25, 2015 Page 3 e. Commission Members' Reports — Ogren stated that she was looking at the Air Race Classic web site today to see how Gardinier did and that she did complete the race this year. Tharp added that he did post a couple updates during the race on both Twitter and Facebook. Odgaard shared that he recently flew to St. Louis and that they had to divert over to Springfield, Illinois due to a thunderstorm. He also spoke to several other trips he has taken. f. Staff Report — Tharp stated that he will be off for his birthday, June 26`n Ogren then asked for an update on the new windows and blinds. Tharp stated that he sent an email, but that he has not yet heard anything back. SET NEXT REGULAR MEETING FOR: The next regular meeting of the Airport Commission will be held on Thursday. July 16. 2015. at 6:00 P.M. in the Airport Terminal Building. ADJOURN: Ogren moved to adjourn the meeting at 7:10 P.M. Assouline seconded the motion. The motion carried 3-0 (Davis, Gardinier absent). CHAIRPERSON DATE Airport Commission June 25, 2015 Page 4 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 Page 5 of 36 Airport Commission ATTENDANCE RECORD 2015 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. s o 0 0 0 0 0 0 0 co w O N N W A ? N 0) V NAME EXP. N "" co m N o s 0 0 s m m O -i W o N N 0 rn ? ? ? ? ? UI UI N N N N UI UI Minnetta 03/01/19 X X O/ X X X X X X X X O/ Gardinier E E Jose 03/01/16 X X O/ X X O/ X X O/ X X X Assouline E E E Chris 03/01/18 X X X X X X X X X X X X Ogren A.Jacob 03/01/18 X X X O/ X X X X X X X X Odgaard E David 03/01/17 O/ X X O/ X X O/ X X O/ X O/ Davis E E E E E 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 KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY 53,923.43 1 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget .00 FOR PERIOD 12 ACCOUNTS FOR: Land Rent -50,108.60 325.00 -45,647.04 7600-70-70-850-850100-850110-000-0000-382100 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT 850110 Airport Operations 53,923.43 57,138.00 76850110 381100 Int Invest 411.23 -1,314.00 7600-70-70-850-850100-850110-000-0000-381100 .00 .00 76850110 382100 Land Rent -50,108.60 325.00 -45,647.04 7600-70-70-850-850100-850110-000-0000-382100 325.00 4,650.00 Anticipate loss of revenue due to Gilbert Street Lease 76850110 382200 BdngRmRent -250,382.83 327.00 -250,000.00 7600-70-70-850-850100-850110-000-0000-382200 345.00 345.00 Building Rentals 144.48 76850110 384200 Vndg Comm 149.00 -79.20 -129.60 7600-70-70-850-850100-850110-000-0000-384200 265.44 276.00 Avg Vending Machine Commissions 76850110 384900 Oth Comm -26,969.90 -25,000.00 7600-70-70-850-850100-850110-000-0000-384900 Fuel Sales Commissions 76850110 392100 S1 of Land -212,505.00 .00 7600-70-70-850-850100-850110-000-0000-392100 76850110 393120 Gen Levy -72,342.00 -68,415.00 7600-70-70-850-850100-850110-000-0000-393120 76850110 411000 Perm FT 51,279.12 55,307.00 7600-70-70-850-850100-850110-000-0000-411000 76850110 413000 Temp Empl 1,203.53 .00 7600-70-70-850-850100-850110-000-0000-413000 76850110 414500 Longevity 325.00 325.00 7600-70-70-850-850100-850110-000-0000-414500 76850110 421100 Health Ins 4,650.48 4,650.00 7600-70-70-850-850100-850110-000-0000-421100 76850110 421200 Dental Ins 326.88 327.00 7600-70-70-850-850100-850110-000-0000-421200 76850110 421300 Life Ins 135.91 135.00 7600-70-70-850-850100-850110-000-0000-421300 76850110 421400 DisbltyIns 250.27 248.00 7600-70-70-850-850100-850110-000-0000-421400 -1,314.00 -45,647.04 -250,000.00 -129.60 -25,000.00 351.82 -47,998.30 -275,683.86 -32.40 -27.412.40 -799.393.00 -930.843.00 -68,415.00 -68,415.00 .00 -50,109.00 -250,383.00 -79.00 -26.970.00 MIS .00 -48,000.00 -250,000.00 -100.00 -26.000.00 -79.00 -121,929.00 55,307.00 53,923.43 57,138.00 57,138.00 .00 816.13 .00 .00 325.00 325.00 325.00 325.00 4,650.00 4,707.36 4,907.00 4,907.00 327.00 328.56 345.00 345.00 135.00 144.48 149.00 149.00 248.00 265.44 276.00 276.00 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY 4,177.14 4,004.15 2 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget 5,131.00 4,715.75 FOR PERIOD 12 ACCOUNTS FOR: .00 .00 110.00 1,000.00 76850110 431020 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT 76850110 422100 FICA 4,177.14 4,004.15 4,219.00 7600-70-70-850-850100-850110-000-0000-422100 4,354.00 50.00 4,968.00 37.61 76850110 423100 IPERS 5,131.00 4,715.75 4,968.00 7600-70-70-850-850100-850110-000-0000-423100 .00 .00 110.00 1,000.00 76850110 431020 CourtCosts 98.00 98.00 .00 7600-70-70-850-850100-850110-000-0000-431020 533.20 1,437.00 76850110 432020 Audit .00 1,386.83 1,130.55 7600-70-70-850-850100-850110-000-0000-432020 .00 .00 .00 76850110 432080 OthProSrvc 41.20 7,550.00 .00 7600-70-70-850-850100-850110-000-0000-432080 .00 3,748.00 12,785.75 76850110 435056 Delivery 12,790.00 .00 50.00 7600-70-70-850-850100-850110-000-0000-435056 72.97 151.00 123.00 76850110 435057 Couriers 18.39 .00 7600-70-70-850-850100-850110-000-0000-435057 76850110 435060 Legal Pubs 165.93 50.00 7600-70-70-850-850100-850110-000-0000-435060 76850110 436030 Transportn 137.76 1,000.00 7600-70-70-850-850100-850110-000-0000-436030 Travel to Des Moines and Kansas City Aviation Conferences 76850110 436050 Registratn 198.00 500.00 7600-70-70-850-850100-850110-000-0000-436050 Des Moines and Kansas City Aviation Conferences 76850110 436060 Lodging 232.96 500.00 7600-70-70-850-850100-850110-000-0000-436060 Des Moines and Kansas City Aviation Conferences 76850110 436080 Meals 54.00 200.00 7600-70-70-850-850100-850110-000-0000-436080 Des Moines and Kansas City Aviation Conferences 76850110 437010 CompLiabty 3,407.14 4,154.81 7600-70-70-850-850100-850110-000-0000-437010 76850110 437020 Fir&CasIns 11,627.00 12,785.75 7600-70-70-850-850100-850110-000-0000-437020 76850110 437030 WrkCompIns 112.00 72.97 7600-70-70-850-850100-850110-000-0000-437030 4,219.00 .00 4,177.14 4,354.00 .00 4,354.00 50.00 4,968.00 37.61 4,917.30 5,131.00 5,131.00 .00 .00 110.00 1,000.00 98.00 500.00 98.00 99.00 1,130.55 .00 533.20 1,437.00 1,437.00 .00 .00 4,626.50 200.00 .00 .00 .00 50.00 41.20 21,767.82 .00 .00 3,748.00 .00 23.29 .00 .00 50.00 37.61 205.00 205.00 1,000.00 .00 .00 1,000.00 500.00 99.00 .00 500.00 500.00 122.08 .00 500.00 200.00 25.00 .00 200.00 4,154.81 21,767.82 3,748.00 3,748.00 12,785.75 11,928.00 12,790.00 12,790.00 72.97 151.00 123.00 166.00 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY 1,816.07 .00 3 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget 5,000.00 FOR PERIOD 12 ACCOUNTS FOR: 13,811.59 13,811.59 14,201.04 1,207.00 14,320.00 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT 76850110 437041 Bnd&OthIns 875.00 7600-70-70-850-850100-850110-000-0000-437041 76850110 437200 Loss RsvPay 5,150.00 7600-70-70-850-850100-850110-000-0000-437200 Anticipate Loss Reserve Payment 76850110 438010 Stormwater 13,018.08 7600-70-70-850-850100-850110-000-0000-438010 76850110 438030 Electricty 14,928.84 7600-70-70-850-850100-850110-000-0000-438030 76850110 438050 Landfill 35.64 7600-70-70-850-850100-850110-000-0000-438050 Avg Landfill Use 76850110 438070 HeatngFuel 6,019.69 7600-70-70-850-850100-850110-000-0000-438070 76850110 438080 Sewer 2,475.73 7600-70-70-850-850100-850110-000-0000-438080 76850110 438090 Water 2,136.71 7600-70-70-850-850100-850110-000-0000-438090 76850110 438100 Refuse 1,067.00 7600-70-70-850-850100-850110-000-0000-438100 76850110 438110 Loc Phone 256.86 7600-70-70-850-850100-850110-000-0000-438110- 76850110 438120 LD Phone 60.30 7600-70-70-850-850100-850110-000-0000-438120 76850110 442010 OthBldgR&M 16,423.04 7600-70-70-850-850100-850110-000-0000-442010 76850110 442020 Struct R&M 1,094.00 7600-70-70-850-850100-850110-000-0000-442020 76850110 442030 HeatingR&M 217.50 7600-70-70-850-850100-850110-000-0000-442030 Avg Expenses 76850110 442040 CoolingR&M .00 7600-70-70-850-850100-850110-000-0000-442040 Avg Expenses 1,029.88 1,029.88 1,816.07 .00 875.00 2,566.00 875.00 1,305.67 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 1,211.03 13,811.59 13,811.59 14,201.04 1,207.00 14,320.00 .00 14,320.00 1,155.58 16,955.68 16,955.68 18,082.50 17,290.00 55.00 17,290.00 63.00 217.26 217.26 80.46 12,000.00 12,000.00 .00 150.00 4.931.04 4.931.04 4.055.76 4,000.00 6.773.00 1,134.00 6.773.00 1,134.00 1,361.56 1,361.56 1,816.07 2,566.00 2,566.00 1,305.67 1,305.67 1,916.18 2,215.00 2,215.00 1,211.03 1,211.03 1,216.62 1,207.00 1,207.00 .00 .00 1,155.58 266.00 266.00 55.00 55.00 39.72 63.00 63.00 12,000.00 12,000.00 12,241.38 18,940.00 18,940.00 4,000.00 4,000.00 600.00 1,134.00 1,134.00 1,000.00 1,000.00 1,613.90 225.00 500.00 1,000.00 1,000.00 528.00 .00 500.00 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY 4,879.15 4 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget 423.86 FOR PERIOD 12 ACCOUNTS FOR: 387.00 .00 387.00 3,000.00 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT 76850110 442060 Elec PlmR&M 7,408.55 7600-70-70-850-850100-850110-000-0000-442060 Avg Expenses 76850110 442070 Pest Cntrl 373.45 7600-70-70-850-850100-850110-000-0000-442070 76850110 443080 Oth Eq R&M 6,656.73 7600-70-70-850-850100-850110-000-0000-443080 76850110 444060 CblElecR&M .00 7600-70-70-850-850100-850110-000-0000-444060- 76850110 445030 Nursery 35,600.00 7600-70-70-850-850100-850110-000-0000-445030 76850110 445080 SnowIceRem 18,000.00 7600-70-70-850-850100-850110-000-0000-445080 76850110 445110 Testing 400.00 7600-70-70-850-850100-850110-000-0000-445110 76850110 445140 Printing 19.95 7600-70-70-850-850100-850110-000-0000-445140 76850110 445230 OthOptgSvc 264.00 7600-70-70-850-850100-850110-000-0000-445230 76850110 446100 Atty Chgbk 6,624.59 7600-70-70-850-850100-850110-000-0000-446100 76850110 446130 ITS PC Chg 800.00 7600-70-70-850-850100-850110-000-0000-446130 76850110 446140 ITSReplChg 810.14 7600-70-70-850-850100-850110-000-0000-446140 76850110 446150 ITSDvlpChg 671.00 7600-70-70-850-850100-850110-000-0000-446150 76850110 446160 ITSNetwChg 720.00 7600-70-70-850-850100-850110-000-0000-446160 76850110 446200 Copy Chgbk 24.90 7600-70-70-850-850100-850110-000-0000-446200 4,879.15 4,879.15 3,110.81 7,861.00 5,000.00 423.86 423.86 203.70 .00 387.00 .00 387.00 3,000.00 .00 3,000.00 .00 6,751.45 .00 6,904.00 6,904.00 2,981.45 .00 2,981.45 .00 389.00 332.00 332.00 49,200.00 49,200.00 40,103.33 41,780.00 41,780.00 18,000.00 18,000.00 18,000.00 18,657.00 18,657.00 814.22 814.22 622.60 811.00 811.00 100.00 100.00 .00 .00 .00 .00 .00 .00 274.00 274.00 2,981.45 2,981.45 6,083.06 3,856.00 6,892.00 800.00 800.00 800.00 830.00 830.00 2,866.67 2,866.67 2,449.10 4,267.00 4,267.00 .00 .00 .00 .00 .00 8,505.00 8,505.00 8,505.00 8,761.00 8,761.00 71.16 71.16 .48 .00 .00 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 (CITY OF IOWA CITY mtharp NEXT YEAR / CURRENT PROJECTION: 16100 FY16 Operating Budget ACCOUNTS FOR: 2014 Airport ACTUAL YEAR BUDGET 2015 ORIG BUD ANALYSIS 2015 REVISED BUD 2015 ACTUAL 2015 PROJECTION IP 5 bgnyrpts FOR PERIOD 12 2016 ADOPTED COMMENT 76850110 446220 PhoneChgbk 769.32 1,021.00 1,021.00 .00 800.00 800.00 7600-70-70-850-850100-850110-000-0000-446220 76850110 446300 PhoneEgChg 1,110.00 1,140.00 1,140.00 1,200.00 1,320.00 1,320.00 7600-70-70-850-850100-850110-000-0000-446300 76850110 446320 Mail Chgbk 302.68 322.85 322.85 190.32 303.00 303.00 7600-70-70-850-850100-850110-000-0000-446320 76850110 446350 VehReplChg 18,041.08 16,756.52 16,756.52 17,713.06 18,582.00 18,582.00 7600-70-70-850-850100-850110-000-0000-446350 76850110 446360 VehRentChg 248.59 500.00 500.00 257.00 264.00 264.00 7600-70-70-850-850100-850110-000-0000-446360 76850110 446370 Fuel Chgbk 4,871.30 4,542.41 4,542.41 5,104.76 4,944.00 4,944.00 7600-70-70-850-850100-850110-000-0000-446370 76850110 446380 VehR&MChg 19,194.01 9,022.98 9,022.98 26,163.37 20,346.00 20,346.00 7600-70-70-850-850100-850110-000-0000-446380 76850110 448040 CtySpEvent 5,000.00 .00 .00 .00 5,000.00 .00 7600-70-70-850-850100-850110-000-0000-448040 No anticipated sponsor event costs 76850110 449055 PermitFees 1,015.00 65.00 65.00 440.00 1,015.00 250.00 7600-70-70-850-850100-850110-000-0000-449055 Avg Annual Fees (previous year had 5 year stormwater permit) 76850110 449060 Dues&Memb 1,210.00 1,200.00 1,200.00 1,185.00 1,254.00 1,254.00 7600-70-70-850-850100-850110-000-0000-449060 76850110 449120 Equip Rent .00 500.00 500.00 .00 155.00 200.00 7600-70-70-850-850100-850110-000-0000-449120 Avg equipment rental 76850110 449280 MiscSrvcs 204.00 .00 .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-449280- 76850110 449350 MealsNOTry 106.81 .00 .00 .00 .00 .00 7600-70-70-850-850100-850110-000-0000-449350 76850110 449360 Interest 32,834.08 32,572.00 32,572.00 22,062.56 32,834.00 .00 7600-70-70-850-850100-850110-000-0000-449360 76850110 452010 Off Supply 526.77 316.63 316.63 215.13 724.00 724.00 7600-70-70-850-850100-850110-000-0000-452010 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY .00 .00 6 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget .00 522.42 FOR PERIOD 12 ACCOUNTS FOR: 416.00 .00 .00 .00 100.00 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT 76850110 452030 MinEq/Fern 250.00 7600-70-70-850-850100-850110-000-0000-452030 76850110 452040 SanitSuppl .00 7600-70-70-850-850100-850110-000-0000-452040 76850110 454020 Subscript 24.00 7600-70-70-850-850100-850110-000-0000-454020 76850110 455120 MiscHrdwr 201.76 7600-70-70-850-850100-850110-000-0000-455120 76850110 461040 OthAg Chem 364.56 7600-70-70-850-850100-850110-000-0000-461040 76850110 466040 Plumbing .00 7600-70-70-850-850100-850110-000-0000-466040 Avg Supplies Costs 76850110 466050 Electrical 181.10 7600-70-70-850-850100-850110-000-0000-466050 76850110 466070 Oth Maint 351.03 7600-70-70-850-850100-850110-000-0000-466070 76850110 467020 Equip R&M 421.14 7600-70-70-850-850100-850110-000-0000-467020 76850110 467160 OthVehR&M .00 7600-70-70-850-850100-850110-000-0000-467160 76850110 468030 Asphalt .00 7600-70-70-850-850100-850110-000-0000-468030 Avg Asphalt Expense 76850110 468050 Sand 40.23 7600-70-70-850-850100-850110-000-0000-468050 Avg Sand Expense 76850110 469040 TrafficCnt 283.42 7600-70-70-850-850100-850110-000-0000-469040- 76850110 469190 MinorEquip .00 7600-70-70-850-850100-850110-000-0000-469190 Minor Equipment Purchases 76850110 469200 Tools .00 7600-70-70-850-850100-850110-000-0000-469200 Minor tools purchases .00 .00 .00 259.00 259.00 .00 .00 126.36 .00 .00 522.42 124.80 124.80 416.00 .00 .00 .00 100.00 .00 1,315.24 .00 192.82 .00 .00 .00 121.93 121.93 .00 324.44 516.00 516.00 .00 50.00 50.00 .00 .00 50.00 966.76 966.76 229.42 188.00 188.00 563.10 563.10 522.42 416.00 416.00 100.00 100.00 1,315.24 562.00 562.00 .00 .00 33.01 .00 .00 50.00 50.00 147.87 .00 50.00 50.00 50.00 .00 .00 50.00 500.00 500.00 163.01 329.00 329.00 500.00 500.00 528.94 88.00 500.00 500.00 500.00 32.43 .00 500.00 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY 194.90 202.00 7 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget .00 FOR PERIOD 12 ACCOUNTS FOR: 76850110 469320 Miscsuppl .00 33,500.00 .00 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT 76850110 469260 FireExtRef 194.90 202.00 750.00 750.00 .00 7600-70-70-850-850100-850110-000-0000-469260 .00 .00 .00 .00 .00 76850110 469320 Miscsuppl .00 33,500.00 .00 .00 7600-70-70-850-850100-850110-000-0000-469320 76850110 469360 Food&Bever 31.80 .00 .00 7600-70-70-850-850100-850110-000-0000-469360 76850110 473010 Cont Impr 3,490.00 40,000.00 40,000.00 7600-70-70-850-850100-850110-000-0000-473010 76850110 473020 NonConImpr 1,225.00 .00 .00 7600-70-70-850-850100-850110-000-0000-473020 Local Replacements of Hangar Heating fixtures, major HVAC items (furnaces boilers), Hangar Door motors. 76850110 490040 CIPFunding -35,693.30 .00 .00 7600-70-70-850-850100-850110-000-0000-490040 76850110 490190 InterfndLn 180,512.66 32,126.45 512,126.45 7600-70-70-850-850100-850110-000-0000-490190 TOTAL UNDEFINED PROJECT -140.653.56 .09 -319.392.91 313.35 202.00 202.00 335.00 .00 .00 .00 .00 .00 .00 .00 .00 9,700.00 .00 33,500.00 4,663.19 .00 .00 672,534.67 .00 .00 -325.704.49 19.101.00 -99.957.00 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY .00 8 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget -324,307.81 FOR PERIOD 12 ACCOUNTS FOR: -1,709.00 -28,410.00 -319,392.91 .00 7600-70-70-850-850100-850110-000-0000-362100-651 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT 651 Fly Iowa 2014 -24,410.00 .00 .00 1,396.68 TOTAL Airport Operations -165,063.56 76850110 362100 651 Contr&Dona -28,410.00 -324,307.81 .00 .00 -1,709.00 -28,410.00 -319,392.91 .00 7600-70-70-850-850100-850110-000-0000-362100-651 TOTAL REVENUE -640,386.30 -390,505.64 -1,189,898.64 -1,351,742.14 TOTAL EXPENSE 475,322.74 Account used to track Fly Iowa donations and income GRAND TOTAL -165,063.56 .09 -319,392.91 76850110 432080 651 OthProSrvc 4,000.00 ** .00 .00 2,727.15 .00 .00 7600-70-70-850-850100-850110-000-0000-432080-651 76850110 438100 651 Refuse .00 .00 .00 182.03 .00 .00 7600-70-70-850-850100-850110-000-0000-438100-651 76850110 445140 651 Printing .00 .00 .00 122.96 3,856.00 .00 7600-70-70-850-850100-850110-000-0000-445140-651 Fly Iowa printing 76850110 449120 651 Equip Rent .00 .00 .00 73.54 3,396.00 .00 7600-70-70-850-850100-850110-000-0000-449120-651 Fly Iowa Expense TOTAL Fly Iowa 2014 -24,410.00 .00 .00 1,396.68 TOTAL Airport Operations -165,063.56 .09 -319,392.91 -324,307.81 TOTAL Airport -165,063.56 .09 -319,392.91 -324,307.81 TOTAL REVENUE -640,386.30 -390,505.64 -1,189,898.64 -1,351,742.14 TOTAL EXPENSE 475,322.74 390,505.73 870,505.73 1,027,434.33 GRAND TOTAL -165,063.56 .09 -319,392.91 -324,307.81 ** END OF REPORT - Generated by Michael Tharp ** 21,158.00 -2,057.00 -2,057.00 -356,030.00 353,973.00 -2,057.00 .00 99,957.00 99,957.00 -446,029.00 346,072.00 -99,957.00 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:11 OF IOWA CITY Sequence 1 1 Y Y 9 mtharp (CITY NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS IP bgnyrpts PROJECTION: 16100 FY16 Operating Budget 07/13/2015 15:11 CITY OF IOWA CITY FOR PERIOD 12 ACCOUNTS FOR: NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 16100 FY16 Operating Budget Report type: 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION ADOPTED COMMENT Field # Total Page Break Sequence 1 1 Y Y Sequence 2 6 Y Y Sequence 3 12 Y Y Sequence 4 0 N N Report title: 07/13/2015 15:11 CITY OF IOWA CITY mtharp NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS PROJECTION: 16100 FY16 Operating Budget Report type: 1 Budget level: 5 Percentage change calculation method: 1 Print first or second year of budget requests: F Print revenue as credit: Y Include cfwd in rev bud: N Include cfwd in actuals: N Print totals only: N Include segment code: N Include report grand totals by account type: Y Print full GL account: Y Double space: N Suppress zero bdgt accts: Y Print as worksheet: N Print percent change or comment: C Print text: Y Amounts/totals exceed 999 million dollars: N Print five budget levels: N Report view: F Find Criteria Field Name Field Value Org 76850110 Object Project Account type Account status P 9 bgnyrpts FOR PERIOD 12 Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:05 (CITY OF IOWA CITY IP 1 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2015/12 TO 2015/12 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S 76850110 Airport Operations 7600-70-70-850-850100-850110-000-0000-431020- WARRANT CHECK Court Costs & Services 010269 JOHNSON COUNTY May Recording Fees 2015 12 INV P 139544 May 2015 Recording 78.00 ACCOUNT TOTAL 7600-70-70-850-850100-850110-000-0000-438030- 2015 12 DIR P 46.92 Electricity W062615 010319 MIDAMERICAN ENERGY 20150528105223 2015 12 DIR P 010319 MIDAMERICAN ENERGY 20150626124433 2015 12 DIR P 7600-70-70-850-850100-850110-000-0000-438070- 010319 MIDAMERICAN ENERGY 20150528105223 010319 MIDAMERICAN ENERGY 20150626124433 7600-70-70-850-850100-850110-000-0000-438100- 011001 ABC DISPOSAL SYSTEMS 772870 011001 ABC DISPOSAL SYSTEMS 772871 011001 ABC DISPOSAL SYSTEMS 772872 7600-70-70-850-850100-850110-000-0000-442010- 010576 RAYNOR DOOR OF CEDAR 33808 010856 JET AIR INC IOW IVI-15-001884 010856 JET AIR INC IOW IVI-15-001885 7600-70-70-850-850100-850110-000-0000-442020- 012238 OTIS ELEVATOR COMPAN CER65338315 7600-70-70-850-850100-850110-000-0000-442060- 010564 LYNCH'S PLUMBING INC 20184 34.38 W060115 2,545.66 W062615 WARRANT CHECK DESCRIPTION ACCOUNT TOTAL 2,580.04 78.00 061915 139544 May 2015 Recording 78.00 33.97 W060115 34.38 W060115 2,545.66 W062615 7600-70-70-850-850100-850110-000-0000-443080- Other Equipment R&M Services 29 MidAmBilling 060120 50 MidAmBilling 062620 29 MidAmBilling 060120 50 MidAmBilling 062620 139147 Pickup/Disposal of 139147 Pickup/Disposal of 139147 Pickup/Disposal of 139022 Hangar 72 Door 138968 Janitorial Services 138968 Maintenance Reimbur 139592 ELEVATOR SERVICE CO 139566 Plumbing Repairs - 2,580.04 ACCOUNT TOTAL 2,580.04 Heating Fuel/Gas 2015 12 DIR P 33.97 W060115 2015 12 DIR P 46.92 W062615 80.89 ACCOUNT TOTAL 80.89 Refuse Collection Charges 2015 12 INV P 28.84 061215 2015 12 INV P 28.84 061215 2015 12 INV P 71.07 061215 128.75 ACCOUNT TOTAL 128.75 Other Building R&M Services 2015 12 INV P 686.50 060515 2015 12 INV P 600.00 060515 2015 12 INV P 140.13 060515 740.13 ACCOUNT TOTAL 1,426.63 Structure R&M Services 2015 12 INV P 150.00 061915 ACCOUNT TOTAL 150.00 Electrical & Plumbing R&M Srvc 2015 12 INV P 73.00 061915 ACCOUNT TOTAL 73.00 7600-70-70-850-850100-850110-000-0000-443080- Other Equipment R&M Services 29 MidAmBilling 060120 50 MidAmBilling 062620 29 MidAmBilling 060120 50 MidAmBilling 062620 139147 Pickup/Disposal of 139147 Pickup/Disposal of 139147 Pickup/Disposal of 139022 Hangar 72 Door 138968 Janitorial Services 138968 Maintenance Reimbur 139592 ELEVATOR SERVICE CO 139566 Plumbing Repairs - Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:05 (CITY OF IOWA CITY IP 2 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2015/12 TO 2015/12 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION 010014 ADVANCED ELECTRICAL 48970 2015 12 INV P 235.50 060515 138883 Beacon Light Repair 010856 JET AIR INC IOW IVI-15-001885 2015 12 INV P 1,064.10 060515 138968 Maintenance Reimbur ACCOUNT TOTAL 1,299.60 7600-70-70-850-850100-850110-000-0000-445030- Nursery Srvc-Lawn & Plant Care 010856 JET AIR INC IOW IVI-15-001883 2015 12 INV P 4,500.00 060515 138968 Groundskeeping/Snow 010856 JET AIR INC IOW IVI-15-001885 2015 12 INV P 28.79 060515 138968 Maintenance Reimbur 4,528.79 ACCOUNT TOTAL 4,528.79 7600-70-70-850-850100-850110-000-0000-461040- Other Agriculture Chemicals 010856 JET AIR INC IOW IVI-15-001885 2015 12 INV P 78.42 060515 138968 Maintenance Reimbur ACCOUNT TOTAL 78.42 7600-70-70-850-850100-850110-000-0000-466050- Electrical Supplies 010856 JET AIR INC IOW IVI-15-001885 2015 12 INV P 182.15 060515 138968 Maintenance Reimbur ACCOUNT TOTAL 182.15 7600-70-70-850-850100-850110-000-0000-467020- Equipment R&M Supplies 010856 JET AIR INC IOW IVI-15-001885 2015 12 INV P 63.58 060515 138968 Maintenance Reimbur ACCOUNT TOTAL 63.58 ORG 76850110 TOTAL 10,669.85 FUND 7600 Airport TOTAL: 10,669.85 ** END OF REPORT - Generated by Michael Tharp ** 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 1 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 Airport Operations 362100 Contrib & Donations 850110 Airport Operations 76850110 362100 651 Contrib & Donat 0 0 0 -1,709.00 381100 Interest on Investments 850110 Airport Operations 76850110 381100 Interest on Invest -1,314 0 -1,314 351.82 382100 Land Rental 850110 Airport Operations 76850110 382100 Land Rental -45,647 0 -45,647 -47,998.30 382200 Building/Room Rental 850110 Airport Operations 76850110 382200 Building/Room Rent -250,000 0 -250,000 -275,683.86 384200 Vending Machine Commission 850110 Airport Operations 76850110 384200 Vending Machine Cc -130 0 -130 -32.40 00 1,709.00 100.0°% 00 -1,665.82 -26.8°%* 00 2,351.26 105.2°% 00 25.683.86 110.3% 00 -97.20 25.0°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 2 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 384900 Other Commissions 850110 Airport Operations 76850110 384900 Other Commissions 392100 Sale of Land 850110 Airport Operations 76850110 392100 Sale of Land 393120 General Levy 850110 Airport Operations 76850110 393120 General Lev 411000 Perm Full Time 850110 Airport Operations 76850110 411000 Perm Full Time 413000 Temporary Employees 850110 Airport Operations 76850110 413000 Temporary Employee -25.000 0 -25.000 -27.412.40 0 -799,393 -799,393 -930,843.00 -68,415 0 -68,415 -68,415.00 55,307 0 55,307 53.923.43 0 0 0 816.13 00 2.412.40 109.6°% 00 131,450.00 116.4°% M 00 100.0°% 00 1,383.57 97.5°% 00 -816.13 100.0°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 3 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 414500 Longevity Pay 850110 Airport Operations 76850110 414500 Longevity Pay 421100 Health Insurance 850110 Airport Operations 76850110 421100 Health Insurance 421200 Dental Insurance 850110 Airport Operations 76850110 421200 Dental Insurance 421300 Life Insurance 850110 Airport Operations 76850110 421300 Life Insurance 421400 Disability Insurance 850110 Airport Operations 76850110 421400 Disability Insuran 325 0 325 325.00 4,650 0 4,650 4,707.36 327 0 327 328.56 135 0 135 144.48 248 0 248 265.44 M11 00 100.0°% 00 -57.36 101.2°%* 00 -1.56 100.5°%* 00 -9.48 107.0°%* 00 -17.44 107.0°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 4 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 422100 FICA 850110 Airport Operations 76850110 422100 FICA 423100 IPERS 850110 Airport Operations 76850110 423100 IPERS 431020 Court Costs & Services 850110 Airport Operations 76850110 431020 Court Costs & Sery 432020 Annual Audit 850110 Airport Operations 76850110 432020 Annual Audit 432080 Other Professional Services 850110 Airport Operations 76850110 432080 Other Professional 4.219 0 4.219 4.177.14 4,968 0 4,968 4,917.30 0 0 0 110.00 1,131 0 1,131 533.20 0 0 0 4,626.50 00 41.86 99.0°% 00 50.70 99.0°% 00 -110.00 100.0°%* 00 597.35 47.2% 00 -4,626.50 100.0°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 RW ICITY OF IOWA CITY P 5 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 432080 651 Other Professio 435056 Delivery Services 850110 Airport Operations 76850110 435056 Delivery Services 435057 Couriers 850110 Airport Operations 76850110 435057 Couriers 435060 Legal Publications 850110 Airport Operations 76850110 435060 Legal Publications 436030 Transportation 850110 Airport Operations 76850110 436030 Transportation 436050 Registration 850110 Airport Operations 76850110 436050 Registration 0 0 0 2,727.15 50 0 50 41.20 0 0 0 23.29 50 0 50 37.61 1,000 0 1,000 500 0 500 99.00 00 -2,727.15 100.0°%* 00 8.80 82.4°% 00 -23.29 100.0°%* 00 12.39 75.2°% 00 1,000.00 .0°% 00 401.00 19.8°% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 6 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 436060 Lodging 850110 Airport Operations 76850110 436060 Lodging 436080 Meals 850110 Airport Operations 76850110 436080 Meals 437010 Comp Liability Insurance 850110 Airport Operations 76850110 437010 Comp Liability Ins 437020 Fire & Casualty Insurance 850110 Airport Operations 76850110 437020 Fire & Casualty In 437030 Worker's Comp Insurance 850110 Airport Operations 76850110 437030 Worker's Comp Insu 500 0 500 122.08 200 0 200 25.00 4,155 0 4,155 21,767.82 12.786 0 12.786 11.928.00 73 0 73 151.00 00 377.92 24.4°% 00 175.00 12.5°% 00 -17,613.01 523.9°%* 00 857.75 93.3% 00 -78.03 206.9°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 7 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 437041 Bonding & Other Insurance 850110 Airport Operations 76850110 437041 Bonding & Other In 437200 Loss Reserve Payment 850110 Airport Operations 76850110 437200 Loss Reserve Payme 438010 Stormwater Utility Charges 850110 Airport Operations 76850110 438010 Stormwater Utilit 438030 Electricity 850110 Airport Operations 76850110 438030 Electricity 438050 Landfill Use 850110 Airport Operations 1.030 0 1.030 00 .00 1.029.88 .0% 5,000 0 5,000 5,000.00 13,812 0 13,812 14,201.04 16,956 0 16,956 18,082.50 M 00 100.0°% 00 -389.45 102.8%* 00 -1.126.82 106.6%* 76850110 438050 Landfill Use 217 0 217 80.46 .00 136.80 37.0°% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 8 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 438070 Heating Fuel/Gas 850110 Airport Operations 76850110 438070 Heating Fuel/Gas 438080 Sewer Utility Charge 850110 Airport Operations 76850110 438080 Sewer Utility Char 438090 Water Utility Charge 850110 Airport Operations 76850110 438090 Water Utility Char 438100 Refuse Collection Charges 850110 Airport Operations 76850110 438100 Refuse Collection 76850110 438100 651 Refuse Collecti 438110 Local Phone Service 850110 Airport Operations 76850110 438110 Local Phone Servic 4.931 0 4.931 4.055.76 1,362 0 1,362 1,816.07 1,306 0 1,306 1,916.18 1,211 0 1,211 1,216.62 0 0 0 182.03 0 0 0 1.155.58 00 875.28 82.20 00 -454.51 133.4%- 00 -610.51 146.8°%* 00 -5.59 100.5°%* 00 -182.03 100.0°%* 00 -1.155.58 100.0°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 9 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 438120 Long Distance Service 850110 Airport Operations 76850110 438120 Long Distance Sery 442010 Other Building R&M Services 850110 Airport Operations 76850110 442010 Other Building R&M 442020 Structure R&M Services 850110 Airport Operations 76850110 442020 Structure R&M Sery 442030 Heating Equipment R&M Services 850110 Airport Operations 76850110 442030 Heating Equipment 442040 Cooling Equipment R&M Services 850110 Airport Operations 76850110 442040 Cooling Equipment 55 0 55 39.72 12,000 0 12,000 12,241.38 4,000 0 4,000 600.00 1,000 0 1,000 1,613.90 1,000 0 1,000 528.00 00 15.28 72.2°% 00 -241.38 102.0°%* 00 3,400.00 15.0°% 00 -613.90 161.4%* 00 472.00 52.8°% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 10 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 442060 Electrical & Plumbing R&M Srvc 850110 Airport Operations 76850110 442060 Electrical & Plumb 442070 Bldg Pest Control Services 850110 Airport Operations 76850110 442070 Bldg Pest Control 443080 Other Equipment R&M Services 850110 Airport Operations 76850110 443080 Other Equipment R& 444060 Cable & Electrical R&M Srvcs 850110 Airport Operations 76850110 444060 Cable & Electrical 445030 Nursery Srvc-Lawn & Plant Care 850110 Airport Operations 76850110 445030 Nursery Srvc-Lawn 4.879 0 4.879 3.110.81 424 0 424 203.70 3,000 0 3,000 6,751.45 0 0 0 389.00 49,200 0 49,200 40,103.33 00 1.768.34 63.8°% 00 220.16 48.1°% 00 -3,751.45 225.0°%* 00 -389.00 100.0°%* 00 9,096.67 81.5°% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 11 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 445080 Snow and Ice Removal 850110 Airport Operations 76850110 445080 Snow and Ice Remov 445110 Testing Services 850110 Airport Operations 76850110 445110 Testing Services 445140 Outside Printing 850110 Airport Operations 76850110 445140 Outside Printing 76850110 445140 651 Outside Printin 446100 City Attorney Chargeback 850110 Airport Operations 76850110 446100 City Attorney Char 446130 ITS-PC/Peripheral Supprt Chgbk 850110 Airport Operations 76850110 446130 ITS-PC/Peripheral 18.000 0 18.000 18.000.00 814 0 814 622.60 100 0 100 .00 0 0 0 122.96 2,981 0 2,981 6,083.06 800 0 800 800.00 Met 00 100.0°% 00 191.62 76.5°% 00 100.00 .0°% 00 -122.96 100.0°%* 00 -3,101.61 204.0°%* M99 00 100.0°% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 12 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 446140 ITS -Computer Replacement Chgbk 850110 Airport Operations 76850110 446140 ITS -Computer Repla 446160 ITS-Network/Internet Chgbk 850110 Airport Operations 76850110 446160 ITS-Network/Intern 446200 Photocopying Chargeback 850110 Airport Operations 76850110 446200 Photocopying Charg 446220 Phone Service Chargeback 850110 Airport Operations 76850110 446220 Phone Service Char 446300 Phone Equipment/Line Chgbk 850110 Airport Operations 76850110 446300 Phone Equipment/Li 2.867 0 2.867 2.449.10 8,505 0 8,505 8,505.00 00 417.57 85.4°% M 00 100.0°% 71 0 71 .48 .00 70.68 .7°% 1,021 0 1,021 .00 .00 1,021.00 .0°% 1,140 0 1,140 1,200.00 00 -60.00 105.3°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 13 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 446320 Mail Chargeback 850110 Airport Operations 76850110 446320 Mail Chargeback 446350 City Vehicle Replacement Chgbk 850110 Airport Operations 76850110 446350 City Vehicle Repla 446360 City Vehicle Rental Chargeback 850110 Airport Operations 76850110 446360 City Vehicle Renta 446370 Fuel Chargeback 850110 Airport Operations 76850110 446370 Fuel Chargeback 446380 Vehicle R&M Chargeback 850110 Airport Operations 76850110 446380 Vehicle R&M Charge 323 0 323 190.32 16,757 0 16,757 17,713.06 500 0 500 257.00 4,542 0 4,542 5,104.76 9,023 0 9,023 26,163.37 00 132.53 58.9°% 00 -956.54 105.7°%* 00 243.00 51.4°% 00 -562.35 112.4%* 00 -17,140.39 290.0°%* Airport Commission Agenda & Info Packet 07/13/2015 15:05 (CITY OF IOWA CITY IP 14 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 12 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 449055 Permitting Fees 850110 Airport Operations 76850110 449055 Permitting Fees 65 0 65 440.00 .00 -375.00 676.9%- 449060 Dues & Memberships 850110 Airport Operations 76850110 449060 Dues & Memberships 1,200 0 1,200 1,185.00 .00 15.00 98.80 449120 Equipment Rental 850110 Airport Operations 76850110 449120 Equipment Rental 500 0 500 .00 .00 500.00 .0°% 76850110 449120 651 Equipment Renta 0 0 0 73.54 .00 -73.54 100.0°%* 449360 Interest Expense 850110 Airport Operations 76850110 449360 Interest Expense 32,572 0 32,572 22,062.56 .00 10,509.44 67.7°% 452010 Office Supplies 850110 Airport Operations 76850110 452010 Office Supplies 317 0 317 215.13 .00 101.50 67.9°% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 15 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 452040 Sanitation & Indust Supplies 850110 Airport Operations 76850110 452040 Sanitation & Indus 454020 Subscriptions 850110 Airport Operations 76850110 454020 Subscriptions 455120 Misc Computer Hardware 850110 Airport Operations 76850110 455120 Misc Computer Hard 461040 Other Agriculture Chemicals 850110 Airport Operations 76850110 461040 Other Agriculture 466040 Plumbing Supplies 850110 Airport Operations 76850110 466040 Plumbing Supplies 0 0 0 126.36 125 0 125 MM 0 0 0 192.82 122 0 122 324.44 50 0 50 MM 00 -126.36 100.0°%* 00 124.80 .0°% 00 -192.82 100.0°%* 00 -202.51 266.1°%* 00 50.00 .0°% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 16 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 466050 Electrical Supplies 850110 Airport Operations 76850110 466050 Electrical Supplie 466070 Other Maintenance Supplies 850110 Airport Operations 76850110 466070 Other Maintenance 467020 Equipment R&M Supplies 850110 Airport Operations 76850110 467020 Equipment R&M Supp 467160 Other Vehicle R&M Supplies 850110 Airport Operations 76850110 467160 Other Vehicle R&M 468030 Asphalt 850110 Airport Operations 76850110 468030 Asphalt 967 0 967 229.42 563 0 563 522.42 100 0 100 1,315.24 0 0 0 33.01 50 0 50 147.87 00 737.34 23.7°% 00 40.68 92.8°% 00 -1,215.24 1315.2%- 00 -33.01 100.0°%* 00 -97.87 295.7°%* 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 17 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 468050 Sand 850110 Airport Operations 76850110 468050 Sand 469040 Traffic Cntrl Imprvmt Supplies 850110 Airport Operations 76850110 469040 Traffic Cntrl Impr 469190 Minor Equipment 850110 Airport Operations 76850110 469190 Minor Equipment 469200 Tools 850110 Airport Operations 76850110 469200 Tools 469260 Fire Ext & Refills 850110 Airport Operations 76850110 469260 Fire Ext & Refills 50 0 50 MIS 500 0 500 163.01 500 0 500 528.94 500 0 500 32.43 750 0 750 313.35 00 50.00 .0°% 00 336.99 32.6°% 00 -28.94 105.8°%* 00 467.57 6.5% 00 436.65 41.8% 07/13/2015 15:05 mtharp FOR 2015 12 Airport Commission Agenda & Info Packet Meeting Date: July 16, 2015 atylererpsDlution ICITY OF IOWA CITY P 18 YEAR-TO-DATE BUDGET REPORT Iglytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 469320 Miscellaneous Supplies 850110 Airport Operations 76850110 469320 Miscellaneous Supp 0 0 0 335.00 76850110 469320 651 Miscellaneous S 0 0 0 405.47 473010 Contracted Improvements 850110 Airport Operations 76850110 473010 Contracted Improve 40,000 0 40,000 .00 473020 Non -Contracted Improvements 850110 Airport Operations 76850110 473020 Non -Contracted Imp 0 0 0 9,700.00 490040 Capital Project Funding 850110 Airport Operations 76850110 490040 Capital Project Fu 0 0 0 4,663.19 490190 Interfund Loan 850110 Airport Operations 76850110 490190 Interfund Loan 32,126 480,000 512,126 672,534.67 00 -335.00 100.0°%* 00 -405.47 100.0°%* 00 40,000.00 .0°% 00 -9,700.00 100.0°%* 00 -4,663.19 100.0°%* 00 -160.408.22 131.3%* Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:05 (CITY OF IOWA CITY IP 19 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 12 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 0 -319,393 -319,393 -323,902.34 .00 4,509.43 101.4% TOTAL REVENUES -390,506 -799,393 -1,189,899 -1,351,742.14 .00 161,843.50 TOTAL EXPENSES 390,506 480,000 870,506 1,027,839.80 .00 -157,334.07 GRAND TOTAL 0 -319,393 -319,393 -323,902.34 .00 4,509.43 101.4% ** END OF REPORT - Generated by Michael Tharp ** Airport Commission Agenda & Info Packet KAPPfinn nntP .iov 1F gams 07/13/2015 15:05 (CITY OF IOWA CITY IP 20 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud Field # Total Page Break Sequence 1 9 Y N Sequence 2 11 N N Sequence 3 6 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: 2015/ 1 To Yr/Per: 2015/ 9 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: F Amounts/totals exceed 999 million dollars: N Find Criteria Field Name Field Value Org 76850110 Object Project Rollup code Account type Account status REPORT OPTIONS Year/Period: 2015/12 Print MTD Version: N Roll projects to object: N Carry forward code: 1