The URL can be used to link to this page

Home My WebLink About10-16-2014 Airport CommissionIOWA CITY AIRPORT COMMISSION MEETING AGENDA AIRPORT TERMINAL BUILDING 1801 S. RIVERSIDE DRIVE IOWA CITY, IOWA THURSDAY, OCTOBER 16, 2014 - 6:00 P.M. 1. Determine Quorum 2. Approval of Minutes from the following meetings: 2 min* September 18, 2014 3. Public Discussion - Items not on the agenda 5 min 4. Items for Discussion /Action: a. Airport Commerce Park 15 min b. Airport Master Plan 10 min c. FAA/IDOT Projects: AECOM / David Hughes 30 min i. Ruppert Land Purchase 1. Consider a resolution approving task order for Airport "Exhibit A" update ii. Runway 7/25 Parallel Taxiway iii. 2014 Iowa DOT Grant Projects 1. Taxiway B rehabilitation and overlay a. Consider a resolution accepting work as complete 2. Taxiway Blighting 3. North T -hangar pavement maintenance a. Consider a resolution accepting work as complete d. FBO /Flight Training Reports 10 min i. Jet Air ii. Iowa Flight Training e. Airport "Operations" 30 min i. Strategic Plan -Implementation ii. Budget 1. FY2016 Budget 2. Terminal Windows iii. Management f. Subcommittee Reports 15 min i. Review use of sub -committees g. Commission Members' Reports 2 min h. Staff Report 2 min 5. Set next regular meeting for November 20, 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 September 18, 2014 Page 1 MINUTES DRAFT IOWA CITY AIRPORT COMMISSION SEPTEMBER 18, 2014 — 6:00 P.M. AIRPORT TERMINAL BUILDING Members Present: Jose Assouline, David Davis, Minnetta Gardinier, A. Jacob Odgaard, Chris Ogren Staff Present: Michael Tharp, Eric Goers, Dennis Bockenstedt Others Present: Matt Wolford, Jeff Edberg, Larry Bell, Greg Broussard, Tim Busch RECOMMENDATIONS TO COUNCIL: (to become effective only after separate Council action): None. DETERMINE QUORUM: Chairperson Ogren called the meeting to order at 6:04 P.M. She welcomed new Member, Dave Davis. APPROVAL OF MINUTES: Minutes from the August 21, 2014, meeting were reviewed. Ogren noted that she gave Tharp a couple of corrections prior to the meeting. Gardinier moved to approve the minutes of the August 21, 2014, meeting as presented, seconded by Assouline. Motion carried 5-0. PUBLIC DISCUSSION: None. ITEMS FOR DISCUSSION/ACTION: a. Gilbert Street/Bell Lease — Larry Bell addressed the Commission, asking if they would release him from the lease on this property. He explained that when he originally came to the Commission five years ago, it was for the building at 1565 S. Gilbert Street. He has since sold this building to Jack Young, who would like to purchase the lot but has no intention of leasing the lot. The lot is no longer of use to Bell. He gave the Commission some background on its usage, noting that it really is of no use at this time to anybody. Bell continued, noting that he and his wife are now on Social Security and that he has no means to pay the $325 per month on this lease. He stated that he could honor the rest of this year. Tharp stated that until they complete the Master Plan they are currently working on, they should not consider selling this land. It may come under the Runway Protection Zone, as it has in the past. Ogren noted that the Commission discussed this at their last meeting and that the decision was to cut the remaining lease in half. Bell noted that he is aware of this and that he is asking for the Commission's mercy in getting out of the lease. He has no way to Airport Commission September 18, 2014 Page 2 generate revenue on the leased property and basically cannot afford to continue the lease since he sold his building. Tharp noted that this ultimately comes down to the Commission's decision. In previous meetings, Members had decided to offer half of the lease as the break point. He added that they can also offer something else. Bell asked if Young could buy the lot and make it into a parking lot, in order to avoid any building hassles. Tharp replied that they basically cannot sell it at this time, as they would have to get the FAA release in order to do this. With the Master Plan being worked on currently, this would not happen. Gardinier stated that she would not be comfortable making a decision this evening without addressing this further. She added that the Commission has already reduced the lease by 50%. Gardinier suggested they get an idea on where the Master Plan planning is going before they make any further suggestions at this point. Assouline asked Jeff Edberg what he thinks of this area, if this lot is developable. Edberg replied that the lot is, first of all, small. It is also in the flight path of the runway, which would limit what could be done there. Edberg continued, stating that really there are only three buyers who could use this lot — Jack Young, Tom Lepic who has a building to the north, and Java House, which abuts this property. Members continued to discuss this issue, questioning if they shouldn't look into selling this — once the Master Plan is completed and they see what comes out of that. Davis asked if the Airport operating budget depends on this amount, and Tharp responded that it accounts for approximately 1 % of their budget. He stated that they would be able to make adjustments, if necessary. Davis stated that it appears to him that due to the change in circumstances for Mr. Bell, he believes they should work something out with him. Ogren explained that this is what the Commission decided previously, to split the remainder of the lease in half. Davis noted that this does not appear to be acceptable to Mr. Bell, as he explained his situation to the Commission. Discussion continued, with Members weighing in on how they believe they could make this contingent upon completion of the Master Plan. Bell thanked the Members for listening, and Ogren noted that they will continue to discuss the issue. Tharp stated that if the Commission wants to they can form a subcommittee to discuss this further. He then responded to Members' questions regarding the Master Plan and how this piece of land may be viewed, but that until the Plan is done they really cannot move ahead at this point. b. Airport Commerce Park — Jeff Edberg addressed the Commission next. He shared a copy of a Letter of Intent to purchase three lots - #11, 12, and 13. He noted that the buyer has asked for confidentiality in this sale, and therefore the Letter of Intent has gone directly to City Manager Tom Markus first. Markus approved the price, noting that he would accept the offer, but not a penny less. Edberg stated that the price is the same as what the previous lot sold for, which was of course public record. Edberg then explained that if the Members approve the Letter of Intent amount, he will prepare a Purchase Agreement for the necessary signatures. He then further explained who the company is and what their background is. Assouline asked about the products this company will be selling and whether it will cause issues with the Airport. Edberg stated that he does not know of any, that basically it is going to be a 30,000 -square foot warehouse stacked with sheetrock and other building supplies. Gardinier asked if the amount of trucks coming to this location could become a problem for the Airport Commission September 18, 2014 Page 3 roadway in the area. Edberg stated that this is a good question, but that the trucks being used will be regular ones meant for normal city streets. Edberg noted that if the Commission approves this sale and everything goes as planned, they will only have lot #7 left to sell. Assouline stated that he sees no problem with moving ahead. Davis asked for some clarification of the selling price and how this was previously handled. Edberg responded, noting what other comparables in the area are. Members continued to discuss the Airport Commerce Park property and how far they have come in selling these lots. Tharp stated that this will go a long way in helping to pay down the Airport's debt. He stated that from what he is hearing, the Commission is agreeable to these terms. Goers noted that the Commission does not have to vote on this issue, that they are looking for consensus basically in order to move ahead with the Purchase Agreement. Edberg stated that he will get the process going on his end. C. Budget/LOST Presentation — Dennis Bockenstedt, the City's Finance Director, spoke to Members next regarding the local option sales tax referendum, City finances, and State property tax reform. He noted that he will be going around to the City's various boards and commissions and giving this presentation. Bockenstedt began by explaining the local option sales tax (LOST) issue, noting that a committee was formed to evaluate the overall feasibility of such a tax. Secondly the committee was to look at how the revenue from this tax would be used. The third directive was to look at the language used on the ballot when presenting the LOST issue for voter consideration. The essential factors identified by the committee, according to Bockenstedt, were the City's strategic plan, the property tax reform legislation that was adopted by the State in 2013, and then other state, regional, and local considerations identified. Bockenstedt went on to further explain what the City's strategic plan is and how it is used. He pointed out how these strategic plan priorities infiltrate their way through the budget. Looking at the State's property tax reform of 2013, Bockenstedt noted that this is probably one of the most significant pieces of property tax legislation in the state in some 25 or 30 years. He explained how the reform will shake out over the next eight to 10 years as the various provisions are phased in. Due to the provisions of this bill, Bockenstedt stated that the City expects to see a loss of revenue of around $37 million. In addition to this lost revenue, the City will also see a loss of $14.7 million that will be replaced through State funding. The State is reimbursing the County, the School District, and the other taxing jurisdictions for a portion of this lost revenue. Continuing, Bockenstedt stated that the State's history of paying these types of backfill situations has been less than stellar. How long it will continue is an unknown. Bockenstedt continued to explain those provisions of the State's property tax reform that primarily affect the City. Looking at residential property, he noted that it is looked at statewide cumulatively and that it was limited to grow 4% annually as a cumulative class across the entire state. The provision of the bill actually reduced that cumulative growth limit from 4% to 3%. The effect of this, according to Bockenstedt, is that taxable property growth would slow. The next provision involves commercial, industrial property valuation. The State implemented a rollback this year to 95%, after being taxed at 100% of their value. Next year the rollback goes to 90%. Bockenstedt continued, noting that in the current State Airport Commission September 18, 2014 Page 4 budget there is an appropriation to backfill this piece of the legislation to the taxing jurisdictions. The third provision, which creates a new classification for multi -residential, will have a significant impact on the City. This portion will be phased in as the others, according to Bockenstedt, but the State will not be backfilling any of this revenue. Bockenstedt fielded questions from Members on the new multi -residential aspect of the legislation. Continuing, Bockenstedt explained that the fourth provision is exemption of property for telecommunications. He stated that right now they are unsure what impacts this will have on the City. This takes portions of telecommunication property, perhaps underground as well as above, and exempts it from property taxes at a tiered rate. Overall the impact of this legislation is: it's going to slow the taxable growth of residential property it's going to lower the taxable values of commercial, industrial property; it's going to treat commercial, multi -residential property as residential; and it's going to exempt portions of telecommunication property from property taxes. Using a model that the Iowa League of Cities and the City of Des Moines created, it shows that Iowa City is looking at a $51.7 million reduction in property tax revenue over the next 10 years. The maximum backfill that is hoped to be received from the State is around $14.7 million. Bockenstedt continued, stating that in looking at this shortfall they have come up with three different approaches simultaneously. One is to diversify the City revenues, in light of the fact that property taxes are a huge part, about 70%, of the General Fund. Secondly is to develop a set of contingency and emergency funding, like a 'rainy day' type of fund. This could provide temporary relief when situations such as this arise. A third approach is to control spending and create better operating efficiencies. Bockenstedt noted that the City has been using this third approach for the past few years as they seek to control spending and diversify revenue. Speaking to the local option sales tax issue, Bockenstedt noted that Des Moines and Iowa City are the only two major metropolitan areas that do not have such a sales tax. Des Moines, unlike Iowa City, spans three counties and includes 10 or 12 other jurisdictions that are contiguous to it, creating even more complexity for them. Overall statewide 91 % of the Iowa jurisdictions have a 1 % local option sales tax. Using Ames as an example, Bockenstedt stated that in FY14 they received slightly over $7 million in sales tax revenue. Of this, 60% went to property tax relief, which reduced their property tax levy by $1.84 per $1,000 of value. The remaining dollars went to fund community betterment projects and human service agency funding. Bockenstedt noted that across the state there is a wide array of uses for these sales tax dollars. From a property tax rate comparison, Bockenstedt noted that Iowa City has historically had one of the highest rates. Looking at those areas where they have this sales tax, they are near the bottom of the rate list. He added that neighboring jurisdictions, such as North Liberty, Tiffin, and Coralville are all significantly lower than Iowa City. Bockenstedt then described the hotel/motel tax that is another revenue source for cities. He noted that it is generally 7% and that pretty much everybody charges the same rate. Gardinier asked if this rate has remained unchanged for many years, and Bockenstedt noted that it has, that there is a cap on the allowable rate. Airport Commission September 18, 2014 Page 5 Continuing, Bockenstedt noted that the franchise tax is another source of revenue. This is a percentage that shows up on consumers' gas and electric bills. Currently there is a 1 % franchise tax in Iowa City, which creates around $900,000 per year. Des Moines has a 5% and Dubuque collects 3%, according to Bockenstedt. Back to the local option sales tax issue, Bockenstedt noted that Cedar Rapids recently renewed their tax. The previous one was to cover flood costs, and the renewed one is for streets. Bockenstedt noted that Iowa City did have a 1 % local option sales tax for four years, but it expired last year. This was used for flood -related projects and also paid for a large portion of the south wastewater treatment plant reconstruction, which will then allow the north plant to close. This area is slated to become a riverfront park within the Riverfront Crossings area. The remaining $25 million, according to Bockenstedt, will help to pay for the reconstruction of Dubuque Street. Another form of revenue for the City comes in utility rates. He noted that Iowa City has some of the highest utility and property rates in the state, but that if you look at other sources of revenue — hotel/motel, franchise — they are much lower than other cities in the state. Bockenstedt noted some of the other forms of revenue around the state, such as gambling, and how this can be quite lucrative for these cities. Ames, for example, has an electric utility fee that gives them a substantial amount of revenue. Bockenstedt continued to explain the local option sales tax, noting that in order for a city to bring this issue to a vote, they must have more than 50% of the population of the jurisdictions, which Iowa City does at 52% of the county's population. He also explained how the contiguous, versus the non-contiguous entities, vote on this issue and how the sales tax ends up being distributed in the end, should it be voted in. If everyone does pass the LOST, Bockenstedt noted that they expect a pool of about $20 million. This would be distributed according to the formula, with Iowa City collecting slightly less than half of this. The County would collect approximately $4.7 million, and Coralville would see around $2.5 million. If only the contiguous cities were to pass the LOST, the pool would be slightly less at $19.3, with Iowa City seeing around $13.5 million, Coralville around $3.3 million, and North Liberty at approximately $2 million. Bockenstedt noted that the Committee then looked at what uses the LOST funds would be used for. It was decided that 50% would go for street and trail improvements, 40% for property tax relief, and 10% for affordable housing opportunities. The annual budget process will solidify these amounts. Assouline asked what the 10%, affordable housing opportunities, is exactly. Bockenstedt stated that this can mean economic development projects that include affordable housing, and there have been many discussions with the housing agencies that provide affordable housing within the community. The hope is to take this money and apply for federal grants and foundations, basically growing this money so that it can be used in the best ways possible. Bockenstedt noted that each year as the Council goes through its budget process, these types of dollars can be used as needed for specific projects, etc. Ogren asked if the Airport falls under any of these categories. Others noted that there doesn't appear to be anything directly related to the Airport. Bockenstedt noted that what would be most applicable is the property tax relief, since the Airport's funding comes from the Airport Commission September 18, 2014 Page 6 General Fund, which is funded through property tax revenues. He further explained what'property tax relief' means in this situation. As the presentation continued, Bockenstedt noted results from a citizen survey regarding the City's streets. He explained the road use tax revenue and how these have pretty much stagnated at this point. He continued, explaining the street overlay program and the annual trail program, and the funds the City sets aside for these types of projects. The LOST revenue would go a long way in helping to keep these projects going. Bockenstedt continued, stating that in looking at ways to raise revenue and/or save on costs where possible, the few options would be to cut services, raise rates on other revenues, and to diversify the City's revenues. He stated that the Committee also set a 'sunset clause' on this issue, with 10 years as the cutoff date. The length of time was chosen, according to Bockenstedt, so that they could see the impact of the LOST overall and whether it met with the public's expectations, as well. Bockenstedt then responded to Member questions regarding the LOST and how the previous LOST differed from the proposed one. d. Airport Master Plan — Greg Broussard addressed Members next. He stated that normally Melissa would be present but that they had to make some staff changes today. He basically gave Members a quick update on where they are with the Master Plan process. Broussard stated that last month they had their first Master Plan Advisory Group meeting. This group will lead the planning, basically. They discussed the goals of the Master Plan and the process that they will be following. Broussard noted that the group will meet four times throughout the Master Plan process, typically at critical times where they need to further discuss those areas needing specific input. There is also a web site now for the Airport's Master Plan. Tharp noted that they are in the process of adding a link to this from the City's web site. Broussard noted that they will keep this up-to-date so that Members can look at this at any time for an update. Broussard stated that he can email a direct link to all of the Members. One of the things that came out of the group's first meeting was the need to set up two surveys — one for pilot users and one for business users at the Airport. Broussard stated that they have sent these out and he urged Members to let them know of anyone they missed. There are also surveys online, according to Broussard, and he showed Members the web page and how it's laid out. Ogren noted that her husband received two copies of the survey. Broussard noted that he was in Kansas City this past weekend for the Federal Aviation Conference, and he spoke with a couple of airports in the area that also received the survey. Broussard then explained what the company Quantum Spatial does for them as far as the Master Plan process goes. He noted that they take survey shots and pictures from their planes, which then gives them information regarding any obstacles, such as trees, buildings, etc. The information that Quantum Spatial collects is then narrowed down to a usable data set. Broussard continued, further explaining the process that will be followed as the planning progresses. He noted that in the past year the FAA has put out new criteria regarding the runway protection zones (RPZ) and what can and cannot be allowed. Gardinier asked Broussard if he knew how many surveys were sent out in total. He stated that he is really unsure, but that there was a huge list. Tharp shared the many lists they used and how they also spoke with the Chamber of Commerce and the Airport Commission September 18, 2014 Page 7 Convention and Visitors Bureau, as well, for even more names. Broussard agreed, adding that Melissa also went through the DOT to get registered pilot names. Gardinier asked Tharp if he felt that most everyone was contacted that should be, and he stated that he is pretty confident they have. He added that there are also surveys in the building that they are asking pilots to complete as they come to the Airport. e. FAA/IDOT Projects: AECOM (David Hughes) — i. Runway 7/25 Parallel Taxiway — Tharp stated that David Hughes is not present and is actually in Minnesota with his wife, helping her with some medical issues. Giving Members an update on the 7/25 parallel taxiway, Tharp stated that they are finalizing quantities and working through many of the subs to get these finalized. Gardinier asked for some clarification, and Tharp noted that it is to close out the project and be able to bill for the work. ii. 2014 Iowa DOT Grant Projects — 1 . Taxiway B rehabilitation and overlay — Tharp stated that this should be ready to close out next month. 2. Taxiway B lighting — Tharp noted that there was a broken light on the corner and a few other things to complete, but that this should be wrapping up soon. 3. North T -hangar pavement maintenance — This project should also be ready to close next month, according to Tharp. iii. 2015 Iowa DOT Grants — Tharp stated that they do have both of the grants expected from the State in. 1. Fuel Tank Maintenance — Tharp stated that he has been working closely with Jet Air on this issue. They have been talking to the contractors and the paint manufacturer to get some pricing on this project. Basically the contractor they have been working with is getting ready to wrap up the work for the year before the weather gets too cold. Tharp stated that they all agree they should wait until spring to complete this project. Members talked about this project briefly, noting that with the grants arriving late for this project, they really do need to wait until spring to complete it. iv. Runway 12/30 Obstruction Mitigation — Tharp noted that he and Hughes have been speaking with the FAA to make sure they have what is needed for the environmental evaluation. They will know what they are going to target once they get to the obstruction mitigation work. f. FBO/Flight Training Reports — i. Jet Air — Matt Wolford with Jet Air shared his monthly reports with Members. He stated that August was mowing and getting prepared for the Sertoma breakfast. He added that the attendance for this was down due to the fog that morning. There was also trash pickup, weed control, and replacing fuel system filters. Members questioned the number of filters and Wolford further explained how the fuel system is set up. This was part of the Airport's annual replacement of fuel filters. Gardinier asked about the weeds that were a problem on the old runway. Tharp stated that Michael has been out there several times spraying and Airport Commission September 18, 2014 Page 8 mowing, trying to get this under control. Moving on to September's report, Wolford noted that it is more of the same — mowing, filter replacement, and some miscellaneous maintenance. Wolford then spoke to how Jet Air is doing. Their shop has been consistently busy, and in fact they need to hire another line service tech as their current techs are moving more into flying roles. A big thing for Jet Air is to do anything possible to maximize the runway length. He further explained what type of runway length a jet needs in order to land and why this is important to them. ii. Iowa Flight Training — Tim Busch spoke to Members next about IFT. He gave Members a brief history of IFT, stating that they are a multi -location, single -service business. Their object is to specialize in flight training and nothing else. In 2009, IFT partnered with Jet Air to offer flight training. However, with the economic downfall, things changed somewhat. Busch stated that things finally appear to be looking up, but that he was somewhat surprised when Jet Air announced that they intended to take over flight training again in Iowa City. He added that IFT would like to continue operating here in Iowa City and he briefly explained where IFT is currently with their operation. Tharp noted that for the Commission's information, there is an application process needed in order for IFT to stay at the Airport. As noted, IFT has been operating under Jet Air, but now that Jet Air is taking over the flight training operations themselves, IFT will need a direct agreement with the Airport in order to continue operating. Tharp stated that he can put together such an agreement for the Commission to review. Busch further explained what IFT does and how they benefit the Airport and the community. Wolford stated that Jet Air sees no problem with there being two flight training operations at this location. John Ockenfel spoke from the audience at this point, stating that the vast majority of people who learn to fly never get beyond the private pilot stage because that is all they are interested in. Gardinier stated that the one disappointment she has on the Commission side of this is that this is the first time the Commission has seen Busch in many months. He agreed that he has been absent from these meetings, and he noted that the Commission can count on seeing more of him now. He then responded to Member questions, trying to alleviate any concerns they may have about his operations. g. Airport "Operations:" — Tharp noted that he would begin with an issue regarding John Ockenfel's hangar. There are some water issues going on with hangar L. Tharp stated that he is having difficulty with the contractor fulfilling what he sees as warranty obligations. With the Commission's blessing, Tharp is going to have Goers send a 'strongly worded' letter to the contractor regarding this. Gardinier asked what the specific problems are, and Ockenfel stated that water is 'gushing' through the top, that he Airport Commission September 18, 2014 Page 9 has videos of this. This is basically a brand-new building with two hangars in it. There is a seven-year warranty on this hangar, according to Tharp. Discussion continued on this issue, with both Ockenfel and Tharp explaining exactly what they see as the problem. Members agreed that Legal needs to send a letter to the contractor in this instance. Tharp stated that another long-standing issue is the water coming through the terminal building. He stated that he did receive a proposal from the company that is also doing work for the University. The proposal would be first trying one set of windows to see if that solves the problem, and if not a second set of windows can be tried. Tharp stated that he would recommend replacing both sets of windows. The cost of this will be around $12,000. Ogren asked if they haven't had several companies look at this issue. Tharp stated that they have tuckpointed the building, reroofed it, and there is still water coming down the front. The windows are the only thing that has not been done. They have tried some different sealants on the windows, but have not replaced them. Ogren asked how doing this would be any different from where they are now. Tharp stated that what wasn't done with the tuckpointing was that the system was not pulled apart in order to see how the windows were draining to begin with. Members continued to question moving forward with this project, especially since it is a fairly expensive one and could result in what they already have. They questioned Tharp extensively over the proposed replacement, asking why all of the windows need to be replaced and if there is not some other method that can be tried. Assouline stated that he believes they need another opinion. Tharp responded that they have already done this, that they have done everything so far — except window replacement. He added that he wished Gene, the contractor, were present as he could probably better explain exactly what is going on with the water issue. Assouline asked if they have the funding for such a project, and Tharp stated that they do have the cash for it, even though it hasn't been budgeted. Davis asked if they could break the project down, do half of it to see if this is the problem. Tharp stated that they could do this, that the contractor did break the project down this way. After lengthy discussion, Tharp asked what the Commission would like him to do. Gardinier stated that she would like to have two independent window professionals assess the situation. Members agreed that by next month's meeting they would like to see another proposal on the windows and the water issue. i. Strategic Plan -Implementation — ii. Budget — Tharp noted that they are dealing with the University's underground storage tank, more specifically the system that monitors the leakage of the tank. There have been some issues with the way it is printing, at times coming out completely garbled. Tharp noted that the system is basically obsolete, so they are Airport Commission September 18, 2014 Page 10 unable to find replacement parts. He believes the control boards are beginning to die. Therefore they are looking at a system replacement, which will be fairly expensive to do. By next month he hopes to have some prices for this, but is expecting it to be around $15,000. Discussion continued on the underground tank and what replacement of something like this would entail. iii. Management— h. Subcommittee Reports — i. For September — Review use of subcommittees — Ogren suggested that in light of the time they put this off to next month's meeting. Members agreed with this sentiment. i. Commission Members' Reports — Ogren noted that she attended Sertoma. Gardinier reported that she is flying to Storm Lake on Sunday and Bardstown, Kentucky, the end of next week. Odgaard shared that on Sunday he took a student to Minneapolis to get further flying experience. Davis shared that he was an air traffic controller during his military career but that he is not a pilot. j. Staff Reports — Tharp reiterated that Sertoma had a fairly low turnout due to the poor weather. Gardinier stated that she went to the Dubuque flight breakfast and they had a really good turnout for it as the weather was good. SET NEXT REGULAR MEETING FOR: The next regular meeting of the Airport Commission will be held on Thursday, October 16, 2014, at 6:00 P.M. at the Airport Terminal Building. ADJOURN: Ogren made the motion to adjourn the meeting at 8:48 P.M.; seconded by Assouline. Motion carried 5-0. CHAIRPERSON DATE Airport Commission September 18, 2014 Page 11 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 O O N N W A Ln W V 00 (o NAME EXP. O -4 \ ?_ \ rn \ ?_ \ rn ? N O -4 -4 r; N W -4 N 00 A A 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 N N Howard M M M M M M M Horan Minnetta 03/01/15 X X X X X X X X X X O/ X X X Gardinier E Jose 03/01/16 X X X X X X X X X X X X X X Assouline Chris 03/01/18 X X X 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 N N Hofineyer M M M M M M A.Jacob 03/01/18 N N N N N N N N N N N X X X Odgaard M M M M M M M M M M M David 03/01/17 N N N N N N N N N N N N O X Davis M M M M M M M M 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 September 18, 2014 Page 12 Airport Commission ATTENDANCE RECORD 2014 (continued) TERM 0 NAME EXP. rn A Minnetta 03/01/15 Gardinier Jose 03/01/16 Assouline Chris 03/01/18 Ogren A.Jacob 03/01/18 Odgaard David 03/01/17 Davis Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr. Iowa City, IA 52246 (319) 350 5045 RESOLUTION NO. RESOLUTION APPROVING TASK ORDER NO. 2WITH AECOM TECHNICAL SERVICES, INC. FOR SERVICES RELATING TO UPDATE OF IOWA CITY AIRPORT EXHIBIT A WHEREAS, the Iowa City Airport Commission entered into a contract entitled "Consultant Services Agreement" with AECOM Technical Services, Inc. on May 15, 2014 to provide engineering services Federal Airport Improvement Program Projects; WHEREAS, Part I(A) of said agreement provides that the parties will enter into supplemental task orders for each project; WHEREAS, the Commission and AECOM have previously entered into Task Orders No. 1 WHEREAS, the Commission and AECOM now desire to enter into Task Order No. 2, a copy of which is attached. WHEREAS, it is in the best interest of the Commission to enter into Task Order No. 2 NOW, THEREFORE, BE IT RESOLVED BY THE AIRPORT COMMISSION OF THE CITY OF IOWA CITY: 1. The Chairperson is authorized and the Secretary to attest to Task Order No. 2. Passed and approved this ATTEST: SECRETARY day of 2014. It was moved by and seconded by adopted, and upon roll call there were: Approved By: City Attorney's Office Ayes Nays Absent the Resolution be Assouline Davis Gardinier Odgaard Ogren COM AE501 COM //A"A77�� Sycamore Street Suite 222 Waterloo, Iowa 50793 www.aecom.com UPDATE IOWA CITY AIRPORT EXHIBIT A IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA PROJECT TASK ORDER NO. 2 319-232-0531 tel 319-232-0271 fax Project Description: Seo attachment and incorporated herein. Scope of Services: See attachment and incorporated herein. Compensation A. Compensation for Engineering Services shall be a cost plus fixed fee not -to -exceed Seven Thousand Four Hundred Dollars ($7,400.00). See attachment and incorporated herein. General Conditions Except as specifically amended by this Individual Project Agreement, Services shall be provided in accordance with the Consultant Services Agreement for the Iowa City Municipal Airport, entered between AECOM Technical Services, Inc. ("ATS'), and the Iowa City Airport Commission ("Client'), dated May 15, 2014. APPROVED: IOWA CITY AIRPORT COMMISSION IS APPROVED: AECOM TECHNICAL SERVICES, INC. ay, Doug3as W. Schincli P.E. Associate Vice President Date October 13, 2014 UPDATE IOWA CITY AIRPORT EXHIBIT A IOWA CITY MUNICIPAL AIRPORT IOWA CITY, IOWA PROJECT TASK ORDER NO. 2 Project Description The project is described as updating the Iowa City Airport Exhibit A to meet the requirements of FAA SOP 3.0, Standard Operating Procedure (SOP) for FAA review of Exhibit "A" Airport Property Inventory Maps. The purpose of this project is to update the airport property map and data table that were prepared by AECOM as part of the Airport Layout Plan Update completed by AECOM that was approved by the Federal Aviation Administration on December 7, 2012, to reflect acquisition of the Ruppert parcel of property recently acquired as part of an FAA grant. The property map and data tables will be updated to reflect the current parcels owned and controlled by the Iowa City Airport. The property map and data tables will have additional information added, as required, to meet the requirement of FAA SOP 3.0. II. Scope of Services The work to be performed by the Consultant shall encompass and include detailed work, services, materials, equipment and supplies necessary to update the Iowa City Airport Property Inventory Map. Work shall be divided into the following tasks: Task 7 - Research Property Information On-line. This task involves the researching of parcels of land at the Iowa City Airport using the City Assessor's on-line system to determine deed book, page and parcel information to the extent possible prior to obtaining property records from the Johnson County Courthouse. Task 2 - Obtain Property Information from Courthouse Records. This task involves the researching and acquisition of deed information from the Johnson County Courthouse for the Iowa City Municipal Airport. Task 3 - Prepare Property Data Tables. This task involves preparing property data tables in accordance with the requirements of FAA SOP 3.0. These data tables will reflect parcels that are currently owned by the airport in addition to parcels that were once owned by the airport and released from federal obligations. Parcel information will include grantor, type of interest acquired, acreage, type of conveyance instrument, deed book and page number of recording and, if purchased with federal funds, identify the FAA grant number and year. For parcels that have been released from federal obligations, the tables will reflect the date of release and the date of disposal. Task 4 - Prepare Exhibit A Property Map. This task will involve updating the airport property map prepared as part of the Airport Layout Plan Update to include additional information as defined on the FAA SOP 3.0, Appendix B, Exhibit A, Review Checklist. Task 5 - Prepare Drawing for Property Data Tables. This task will involve preparing a drawing that presents all property data in one concise location- -1- Task 6 - Quality Control. This task consists of the quality review of work elements on the project. During the course of this project, quality reviews will be conducted by senior technical personnel not directly involved in the project. Task 7 - Project Administration. This task consists of office administration and coordination of the project. Interoffice meetings, general day-to-day administrative responsibilities, and typing of interoffice memoranda and minutes of meetings are included in this task. L:\work\ADMIN\AGREE\PROF\IC T02 Update Airport Exhibit A.doc -2- Update Iowa City Airport Exhibit A Iowa City Municipal Airport Iowa City, Iowa Engineering Services Consultant Cost Summary Direct Labor Cost Category Senior Professional Project Professional Staff Professional Professional CADD Operator II CADD Operator I Senior Technician Technician Project Support Payroll Burden and Overhead Costs Direct Project Expenses Hours Rate/Hour Amount 8 $80.00 $640.00 0 $53.10 $0.00 28 $42.20 $1,181.60 0 $32.00 $0.00 16 $31.35 $501.60 0 $22.65 $0.00 0 $33.20 $0.00 0 $25.25 $0.00 4 $28.45 $113.80 $2,437.00 56 0.00 GPS Equipment 0 25.00 150.00% $3,655.50 Category Units Rate/Unit Amount Mileage 300 0.560 168.00 Per Diem 0 40.00 0.00 Lodging 0 80.00 0.00 B/W Copies 100 0.06 6.00 Color Copies 100 0.22 22.00 Plan Copier 100 0.50 50.00 EDM Equipment 0 12.50 0.00 GPS Equipment 0 25.00 0.00 Nuclear Density Guage 0 40.00 0.00 Miscellaneous, Other 150.00 $396.00 AECOM Estimated Actual Costs Subcontract Expense Estimated Actual Costs Fixed Fee (15% of Items I & II) Maximum Amount Payable Rounded $6,488.50 $6,500.00 $0.00 $6,500.00 $900.00 $7,400.00 Update Iowa City Airport Exhibit Iowa City Municipal Airport Iowa City, Iowa Engineering Services Staff Hour Estimate Item No. Description Senior Prof Project Prof Staff Prof CADD Prof Operatorll CADD Senior Operatorl Technician Technician Project Support Totals 1 Research Property Information Online 8 8 2 Obtain Property Information from Courthouse Records 16 16 3 Prepare Property Data Tables 4 4 4 Prepare Exhibit A Property Map 8 8 5 Pre are Drawing for Property Data Tables 8 8 6 lQuality Control 4 4 7 Project Administration 4 1 4 1 8 Total Services 8 0 28 0 16 0 0 0 4 56 Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION RESOLUTION ACCEPTING THE WORK FOR THE TAXIWAY B REHABILITATION WHEREAS, the engineering consultant AECOM has recommended that the work on the above referenced project by L.L Pelling Co., Inc. be accepted as complete. WHEREAS, the final contract price is $103,229.99 which is established from the original contract cost of $107,527.00 MINUS $4,297.01 from Change Orders #1 and #2. 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 CHAIRPERSON ATTEST: SECRETARY It was moved by and seconded by adopted, and upon roll call there were: Ayes Nays Approved by City Attorney's Office Absent 2014. the Resolution be Assouline Davis Gardinier Odgaard Ogren A=COM October 13, 2014 Ms. Christine Ogren Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 SUBJECT: Rehabilitate South Taxiway Iowa City Municipal Airport Iowa City, Iowa Iowa DOT AIP Project 911401OW100 Contract No. 15252 AECOM ID No. 60306669 Dear Ms. Ogren: By this letter, we hereby state: AECOM 515 323 7910 tel 500 SW 7th Street 515 2444803 fax Suite 301 Des Moines, Iowa 50309 www-aecom.com We have made a final review of the project on June 9, 2014 and subsequent reviews on June 28, 2014 and October 6, 2014. 2. To the best of our knowledge and belief, based on observations of AECOM staff during construction, the contractor, L.L Pelling Co., 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 $ 103,229.99, P.%0306669 Iowa City Airport South Taxiway Rehab1600 Cons W cfion Supporti620 Corrsspondence1C0101314certificalion doc I hereby certify that this engineering document was prepared by me or " under my direct personal supervision and that I am a duly licensed na...... 4i�`-., Professional Engineer under the laws of the state of Iowa. r `o r tZ t DAVID a SG' W HUGHES u� 13037 David B. Hughes Date °W." . License No. 13037 My license renewal date is December 31, 2015. Pages or sheets covered by this seal: P.%0306669 Iowa City Airport South Taxiway Rehab1600 Cons W cfion Supporti620 Corrsspondence1C0101314certificalion doc Prepared by: Michael Tharp, Operations Specialist, 1801 S. Riverside Dr, Iowa City IA 52246 319-350-5045 RESOLUTION RESOLUTION ACCEPTING THE WORK FOR THE NORTH T -HANGAR PAVEMENT MAINTENANCE WHEREAS, the engineering consultant AECOM has recommended that the work on the above referenced project by L.L Pelling Co., Inc. be accepted as complete. WHEREAS, the final contract price is $35,374.90 which is established from the original contract cost of $25,450.00 PLUS $ 9,924.90 from Change Orders #1 and #2. 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 2014. CHAIRPERSON ATTEST: SECRETARY It was moved by and seconded by adopted, and upon roll call there were: Approved by City Attorney's Office Ayes Nays Absent the Resolution be Assouline Davis Gardinier Odgaard Ogren AXOM 500 SW 515 323 7910 tel 500 SW 7th Street 515 244 4803 fax Suite 301 Des Moines, Iowa 50309 www.aeconi.com October 13, 2014 Ms. Christine Ogren Iowa City Airport Commission 1801 S. Riverside Drive Iowa City, IA 52246 SUBJECT: Pavement Maintenance— North T -Hangar Area Iowa City Municipal Airport Iowa City, Iowa Iowa DOT AIP Project 911401OW100 Contract No. 15247 AECOM ID No. 60306664 Dear Ms. Ogren: By this letter, we hereby state: 2. 3 We have made a final review of the project on June 9, 2014 and subsequent reviews on June 28, 2014 and October 6, 2014. To the best of our knowledge and belief, based on observations of AECOM staff during construction, the contractor, L.L Pelling Co., has performed the work in accordance with the proposal requirements in effect for the above -referenced project. The total cost of the completed work is $ 35,374.90. „ „ r, I hereby certify that this engineering document was prepared by me or opessloN' under my direct personal supervision and that I am a duly licensed e f: ""•qe Professional Engineer under the laws of the state of Iowa. DAVID e w t HUGHES v Ci6 13037 IOWPk David B. Hughes License No. 13037 My license renewal date is December 31, 2015. Pages or sheets covered by this seal: P1603066641ow3 City Airport Pavement Maintenance 20141600 -Construction Suppon1620 Correspondence1C0101314.certification,doc iii Date Current Budget Year Reports 10/13/2014 14:10 CITY OF IOWA CITY mtharp INVOICE LIST BY GL ACCOUNT YEAR/PERIOD: 2015/3 TO 2015/3 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S 76850110 Airport Operations WARRANT CHECK DESCRIPTION P 1 apinvgla 7600-70-70-850-850100-850110-000-0000-432080-651 Other Professional Services 013219 HEARTLAND INN IOWA C 77650 2015 3 INV P 1,052.69 091914 125106 Hotel Rooms for Fly 013313 FUEL INC 0003142 2015 3 INV P 800.00 090514 124541 Fly Iowa - VIP airc 013314 NIELSEN, GRANT DAVID 1402 2015 3 INV P 1,250.00 090514 124625 Fly Iowa - Performe ACCOUNT TOTAL 3,102.69 7600-70-70-850-850100-850110-000-0000-438030- Electricity 010319 MIDAMERICAN ENERGY 20140929093311 2015 3 DIR P 1,728.23 W092614 6143989 MidAmBilling 092620 ACCOUNT TOTAL 1,728.23 7600-70-70-850-850100-850110-000-0000-438070- Heating Fuel/Gas 010319 MIDAMERICAN ENERGY 20140929093311 2015 3 DIR P 34.65 W092614 6143989 MidAmBilling 092620 ACCOUNT TOTAL 34.65 7600-70-70-850-850100-850110-000-0000-438100- Refuse Collection Charges 011001 ABC DISPOSAL SYSTEMS 711073 2015 3 INV P 71.07 092614 126762 Pickup/Disposal of ACCOUNT TOTAL 71.07 7600-70-70-850-850100-850110-000-0000-438100-651 Refuse Collection Charges 013231 HAWKEYE WASTE SYSTEM 168124 2015 3 INV P 182.03 091914 125102 Dumpster - Fly Iowa ACCOUNT TOTAL 182.03 7600-70-70-850-850100-850110-000-0000-438110- Local Phone Service 011001 ABC DISPOSAL SYSTEMS 711071 2015 3 INV P 28.84 092614 126762 Pickup/Disposal of 011001 ABC DISPOSAL SYSTEMS 711072 2015 3 INV P 24.19 092614 126762 Pickup/Disposal of 53.03 011937 ALLIANCE CONNECT 40009580 2015 3 INV P 85.47 091914 125047 INV 40009580 ACCOUNT TOTAL 138.50 7600-70-70-850-850100-850110-000-0000-442010- Other Building R&M Services 010358 OVERHEAD DOOR COMPAN W86715 2015 3 INV P 170.00 100314 127127 Hangar Door #29 Rep 010358 OVERHEAD DOOR COMPAN W90928 2015 3 INV P 893.58 091914 125161 Hangar #57 Door Sea 1,063.58 010495 WEST BRANCH ROOFING 139 2015 3 INV P 136.96 091914 125263 Hangar #54 roof rep 010856 JET AIR INC IOW IVI-14-002685 2015 3 INV P 500.00 091914 125129 Janitorial Services 010856 JET AIR INC IOW IVI-14-002687 2015 3 INV P 500.00 091914 125129 janitorial services 1,000.00 10/13/2014 14:10 (CITY OF IOWA CITY IP 2 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2015/3 TO 2015/3 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION ACCOUNT TOTAL 2,200.54 7600-70-70-850-850100-850110-000-0000-443080- Other Equipment R&M Services 010856 JET AIR INC IOW IVI-14-002683 2015 3 INV P 1,562.63 091914 125129 Maintenance Supplie ACCOUNT TOTAL 1,562.63 7600-70-70-850-850100-850110-000-0000-445030- Nursery Srvc-Lawn & Plant Care 010856 JET AIR INC IOW IVI-14-002684 2015 3 INV P 4,500.00 091914 125129 Groundskeeping/Mowi 010856 JET AIR INC IOW IVI-14-002686 2015 3 INV P 4,500.00 091914 125129 Mowing/groundskeepi 9,000.00 ACCOUNT TOTAL 9,000.00 7600-70-70-850-850100-850110-000-0000-445140-651 Outside Printing 013312 CEDAR GRAPICS IN 121295 2015 3 INV P 2,268.82 090514 124515 Fly Iowa - Program ACCOUNT TOTAL 2,268.82 7600-70-70-850-850100-850110-000-0000-449055- Permitting Fees 010262 IOWA WORKFORCE DEVEL 23754 2015 3 INV P 175.00 091214 124844 Permit Fee ACCOUNT TOTAL 175.00 7600-70-70-850-850100-850110-000-0000-461040- Other Agriculture Chemicals 010856 JET AIR INC IOW IVI-14-002683 2015 3 INV P 74.54 091914 125129 Maintenance Supplie ACCOUNT TOTAL 74.54 7600-70-70-850-850100-850110-000-0000-465010-651 Other Fluids & Gases 013242 PETROBLEND CORP 00139943 2015 3 INV P 371.10 090514 124633 Fly Iowa - Smoke Oi ACCOUNT TOTAL 371.10 7600-70-70-850-850100-850110-000-0000-466050- Electrical Supplies 010856 JET AIR INC IOW IVI-14-002683 2015 3 INV P 11.00 091914 125129 Maintenance Supplie ACCOUNT TOTAL 11.00 7600-70-70-850-850100-850110-000-0000-466070- Other Maintenance Supplies 010856 JET AIR INC IOW IVI-14-002683 2015 3 INV P 192.90 091914 125129 Maintenance Supplie ACCOUNT TOTAL 192.90 ORG 76850110 TOTAL 21,113.70 FUND 7600 Airport TOTAL: 21,113.70 10/13/2014 14:10 (CITY OF IOWA CITY IP 3 mtharp INVOICE LIST BY GL ACCOUNT apinvgla YEAR/PERIOD: 2015/3 TO 2015/3 ACCOUNT/VENDOR INVOICE PO YEAR/PR TYP S WARRANT CHECK DESCRIPTION ** END OF REPORT - Generated by Michael Tharp ** 10/13/2014 14:08 CITY OF IOWA CITY P 1 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 362100 Contrib & Donations 850110 Airport Operations 76850110 362100 651 Contrib & Donat 0 0 0 -1,709.00 .00 1,709.00 100.0°% TOTAL Airport Operations 0 0 0 -1,709.00 .00 1,709.00 100.0°% 381100 Interest on Investments 850110 Airport Operations 76850110 381100 Interest on Invest -1,314 0 -1,314 33.79 .00 -1,347.79 -2.6%* TOTAL Airport Operations -1,314 0 -1,314 33.79 .00 -1,347.79 -2.6% 382100 Land Rental 850110 Airport Operations 76850110 382100 Land Rental -45,647 0 -45,647 -2,633.21 .00 -43,013.83 5.8%* TOTAL Airport Operations -45,647 0 -45,647 -2,633.21 .00 -43,013.83 5.8% 382200 Building/Room Rental 850110 Airport Operations 76850110 382200 Building/Room Rent -250,000 0 -250,000 -86,125.67 .00 -163,874.33 34.5°% TOTAL Airport Operations -250,000 0 -250,000 -86,125.67 .00 -163,874.33 34.5°% 384200 Vending Machine Commission 850110 Airport Operations 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT ORIGINAL TRANFRS/ APPROP ADJSTMTS REVISED BUDGET YTD ACTUAL ENCUMBRANCES AVAILABLE BUDGET P 2 glytdbud PCT USED 76850110 384200 Vending Machine Co -130 0 -130 .00 .00 -129.60 .0°%* TOTAL Airport Operations -130 0 -130 .00 .00 -129.60 .0°% 384900 Other Commissions 850110 Airport Operations 76850110 384900 Other Commissions -25,000 0 -25,000 -6,453.70 .00 -18,546.30 25.8°% TOTAL Airport Operations -25,000 0 -25,000 -6,453.70 .00 -18,546.30 25.8°% 393120 General Levy 850110 Airport Operations 76850110 393120 General Lev -68,415 0 -68,415 -17,103.75 .00 -51,311.25 25.0°% TOTAL Airport Operations -68,415 0 -68,415 -17,103.75 .00 -51,311.25 25.0°% 411000 Perm Full Time 850110 Airport Operations 76850110 411000 Perm Full Time 55,307 0 55,307 12,717.60 .00 42,589.40 23.0°% TOTAL Airport Operations 55,307 0 55,307 12,717.60 .00 42,589.40 23.0°% 413000 Temporary Employees 850110 Airport Operations 76850110 413000 Temporary Employee 0 0 0 111.13 .00 -111.13 100.0°%* 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT ORIGINAL TRANFRS/ APPROP ADJSTMTS REVISED BUDGET YTD ACTUAL ENCUMBRANCES AVAILABLE BUDGET P 3 glytdbud PCT USED TOTAL Airport Operations 0 0 0 111.13 .00 -111.13 100.0°% 414500 Longevity Pay 850110 Airport Operations 76850110 414500 Longevity Pay 325 0 325 .00 .00 325.00 .0°% TOTAL Airport Operations 325 0 325 .00 .00 325.00 .0°% 421100 Health Insurance 850110 Airport Operations 76850110 421100 Health Insurance 4,650 0 4,650 1,176.84 .00 3,473.16 25.3°%* TOTAL Airport Operations 4,650 0 4,650 1,176.84 .00 3,473.16 25.3°% 421200 Dental Insurance 850110 Airport Operations 76850110 421200 Dental Insurance 327 0 327 82.14 .00 244.86 25.1°%* TOTAL Airport Operations 327 0 327 82.14 .00 244.86 25.1°% 421300 Life Insurance 850110 Airport Operations 76850110 421300 Life Insurance 135 0 135 36.12 .00 98.88 26.8°%* 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT ORIGINAL TRANFRS/ APPROP ADJSTMTS REVISED BUDGET YTD ACTUAL ENCUMBRANCES AVAILABLE BUDGET P 4 glytdbud PCT USED TOTAL Airport Operations 135 0 135 36.12 .00 98.88 26.8°% 421400 Disability Insurance 850110 Airport Operations 76850110 421400 Disability Insuran 248 0 248 66.36 .00 181.64 26.8°°%* TOTAL Airport Operations 248 0 248 66.36 .00 181.64 26.8°% 422100 FICA 850110 Airport Operations 76850110 422100 FICA 4,219 0 4,219 972.33 .00 3,246.67 23.0°% TOTAL Airport Operations 4,219 0 4,219 972.33 .00 3,246.67 23.0°% 423100 IPERS 850110 Airport Operations 76850110 423100 IPERS 4,968 0 4,968 1,145.61 .00 3,822.39 23.1% TOTAL Airport Operations 4,968 0 4,968 1,145.61 .00 3,822.39 23.1% 432020 Annual Audit 850110 Airport Operations 76850110 432020 Annual Audit 1,131 0 1,131 .00 .00 1,130.55 .0% 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations TOTAL Airport Operations 432080 Other Professional Services 850110 Airport Operations CITY OF IOWA CITY P 5 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 1,131 0 1,131 .00 .00 1,130.55 .0°% 76850110 432080 651 Other Professio 0 0 0 7,729.79 TOTAL Airport Operations 0 0 0 7,729.79 435056 Delivery Services 850110 Airport Operations 76850110 435056 Delivery Services 50 0 50 41.20 TOTAL Airport Operations 50 0 50 41.20 435060 Legal Publications 850110 Airport Operations 76850110 435060 Legal Publications 50 0 50 31.90 TOTAL Airport Operations 50 0 50 31.90 436030 Transportation 850110 Airport Operations 76850110 436030 Transportation 1,000 0 1,000 .00 00 -7,729.79 100.0°%* 00 -7,729.79 100.0°% 00 8.80 82.4°%* 00 8.80 82.4°% 00 18.10 63.8°%* 00 18.10 63.8°% 00 1,000.00 .0°% 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations TOTAL Airport Operations 436050 Registration 850110 Airport Operations 76850110 436050 Registration TOTAL Airport Operations 436060 Lodging 850110 Airport Operations 76850110 436060 Lodging TOTAL Airport Operations 436080 Meals 850110 Airport Operations 76850110 436080 Meals TOTAL Airport Operations 437010 Comp Liability Insurance 850110 Airport Operations CITY OF IOWA CITY P 6 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 437010 Comp Liability Ins 1,000 0 1,000 .00 .00 1,000.00 .0% 500 0 500 .00 .00 500.00 .0% 500 0 500 .00 .00 500.00 .0% 500 0 500 .00 .00 500.00 .0% 500 0 500 .00 .00 500.00 .0% 200 0 200 200 0 200 00 .00 200.00 .0% 00 .00 200.00 .0% 4,155 0 4,155 3,202.00 00 952.81 77.1%* 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY P 7 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 76850110 437010 651 Comp Liability TOTAL Airport Operations 437020 Fire & Casualty Insurance 850110 Airport Operations 76850110 437020 Fire & Casualty In TOTAL Airport Operations 437030 Worker's Comp Insurance 850110 Airport Operations 76850110 437030 Worker's Comp Insu TOTAL Airport Operations 437041 Bonding & Other Insurance 850110 Airport Operations 76850110 437041 Bonding & Other In TOTAL Airport Operations 437200 Loss Reserve Payment 850110 Airport Operations 76850110 437200 Loss Reserve Pavme 0 0 0 5,001.00 4,155 0 4,155 8,203.00 12,786 0 12,786 .00 12.786 0 12.786 .00 73 0 73 73 0 73 1,030 0 1,030 1,030 0 1,030 5,000 0 5,000 00 00 00 00 M 00 -5,001.00 100.0°%* 00 -4,048.19 197.4°% 00 12,785.75 .0°% 00 12,785.75 .0°% 00 72.97 .0°% 00 72.97 .0°% 00 1,029.88 .0°% 00 1,029.88 .0°% 00 5,000.00 .0°% 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY YEAR-TO-DATE BUDGET REPORT ORIGINAL TRANFRS/ APPROP ADJSTMTS REVISED BUDGET YTD ACTUAL ENCUMBRANCES AVAILABLE BUDGET P 8 glytdbud PCT USED TOTAL Airport Operations 5,000 0 5,000 .00 .00 5,000.00 .0°% 438010 Stormwater Utility Charges 850110 Airport Operations 76850110 438010 Stormwater Utilit 13,812 0 13,812 3,550.26 .00 10,261.33 25.7°°%* TOTAL Airport Operations 13,812 0 13,812 3,550.26 .00 10,261.33 25.7°% 438030 Electricity 850110 Airport Operations 76850110 438030 Electricity 16,956 0 16,956 6,337.78 .00 10,617.90 37.4°%* TOTAL Airport Operations 16,956 0 16,956 6,337.78 .00 10,617.90 37.4°% 438050 Landfill Use 850110 Airport Operations 76850110 438050 Landfill Use 217 0 217 30.80 .00 186.46 14.2% TOTAL Airport Operations 217 0 217 30.80 .00 186.46 14.2°% 438070 Heating Fuel/Gas 850110 Airport Operations 76850110 438070 Heating Fuel/Gas 4,931 0 4,931 430.57 .00 4,500.47 8.7% 10/13/2014 14:08 CITY OF IOWA CITY P 9 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 4,931 0 4,931 430.57 438080 Sewer Utility Charge 850110 Airport Operations 76850110 438080 Sewer Utility Char 1,362 0 1,362 503.49 TOTAL Airport Operations 1,362 0 1,362 503.49 438090 Water Utility Charge 850110 Airport Operations 76850110 438090 Water Utility Char 1,306 0 1,306 492.28 TOTAL Airport Operations 1,306 0 1,306 492.28 438100 Refuse Collection Charges 850110 Airport Operations 76850110 438100 Refuse Collection 1,211 0 1,211 265.07 76850110 438100 651 Refuse Collecti 0 0 0 182.03 TOTAL Airport Operations 1,211 0 1,211 447.10 438110 Local Phone Service 850110 Airport Operations 76850110 438110 Local Phone Servic 0 0 0 313.19 00 4,500.47 8.7% 00 858.07 37.0°°%* 00 858.07 37.0°% 00 813.39 37.7°%* 00 813.39 37.7°% 00 945.96 21.9°% 00 -182.03 100.0°%* 00 763.93 36.9°% 00 -313.19 100.0°%* 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY P 10 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 0 0 0 313.19 .00 -313.19 100.0°% 438120 Long Distance Service 850110 Airport Operations 76850110 438120 Long Distance Sery 55 0 55 15.09 .00 39.91 27.4°%* TOTAL Airport Operations 55 0 55 15.09 .00 39.91 27.4°% 442010 Other Building R&M Services 850110 Airport Operations 76850110 442010 Other Building R&M 12,000 0 12,000 6,088.06 .00 5,911.94 50.7°%* TOTAL Airport Operations 12,000 0 12,000 6,088.06 .00 5,911.94 50.7°% 442020 Structure R&M Services 850110 Airport Operations 76850110 442020 Structure R&M Sery 4,000 0 4,000 .00 .00 4,000.00 .0°% TOTAL Airport Operations 4,000 0 4,000 .00 .00 4,000.00 .0°% 442030 Heating Equipment R&M Services 850110 Airport Operations 76850110 442030 Heating Equipment 1,000 0 1,000 .00 .00 1,000.00 .0°% 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY P 11 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 442040 Cooling Equipment R&M Services 850110 Airport Operations 76850110 442040 Cooling Equipment TOTAL Airport Operations 442060 Electrical & Plumbing R&M Srvc 850110 Airport Operations 76850110 442060 Electrical & Plumb TOTAL Airport Operations 442070 Bldg Pest Control Services 850110 Airport Operations 1,000 0 1,000 .00 .00 1,000.00 .0°% 1,000 0 1,000 .00 .00 1,000.00 .0°% 1,000 0 1,000 .00 .00 1,000.00 .0°% 4,879 0 4,879 175.43 4,879 0 4,879 175.43 00 4,703.72 3.6% 00 4,703.72 3.6% 76850110 442070 Bldg Pest Control 424 0 424 .00 .00 423.86 .0°% TOTAL Airport Operations 424 0 424 .00 .00 423.86 .0°% 443080 Other Equipment R&M Services 850110 Airport Operations 76850110 443080 Other Equipment R& 3,000 0 3,000 1,566.86 .00 1,433.14 52.2°°%* 10/13/2014 14:08 CITY OF IOWA CITY P 12 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 3,000 0 3,000 1,566.86 444060 Cable & Electrical R&M Srvcs 850110 Airport Operations 76850110 444060 Cable & Electrical 0 0 0 320.34 TOTAL Airport Operations 0 0 0 320.34 445030 Nursery Srvc-Lawn & Plant Care 850110 Airport Operations 76850110 445030 Nursery Srvc-Lawn 49,200 0 49,200 18,207.79 TOTAL Airport Operations 49,200 0 49,200 18,207.79 445080 Snow and Ice Removal 850110 Airport Operations 76850110 445080 Snow and Ice Remov 18,000 0 18,000 .00 TOTAL Airport Operations 18,000 0 18,000 .00 445110 Testing Services 850110 Airport Operations 76850110 445110 Testing Services 814 0 814 382.60 00 1,433.14 52.2°% 00 -320.34 100.0°%* 00 -320.34 100.0°% 00 30,992.21 37.0°%* 00 30,992.21 37.0°% 00 18,000.00 .0°% 00 18,000.00 .0°% 00 431.62 47.0°%* 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY P 13 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 445140 Outside Printing 850110 Airport Operations 76850110 445140 Outside Printing 76850110 445140 651 Outside Printin TOTAL Airport Operations 446100 City Attorney Chargeback 850110 Airport Operations 76850110 446100 City Attorney Char TOTAL Airport Operations 446130 ITS-PC/Peripheral Supprt Chgbk 850110 Airport Operations 76850110 446130 ITS-PC/Peripheral TOTAL Airport Operations 446140 ITS -Computer Replacement Chgbk 850110 Airport Operations 76850110 446140 ITS -Computer Repla 814 0 814 382.60 100 0 100 .00 0 0 0 3,720.57 100 0 100 3.720.57 00 431.62 47.0°% 00 100.00 .0°% 00 -3,720.57 100.0°%* 00 -3.620.57 3720.6°% 2,981 0 2,981 .00 .00 2,981.45 .0°% 2.981 0 2.981 .00 .00 2.981.45 .0°% 800 0 800 .00 .00 800.00 .0°% 800 0 800 .00 .00 800.00 .0°% 2,867 0 2,867 486.20 00 2,380.47 17.0°% 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations TOTAL Airport Operations 446160 ITS-Network/Internet Chgbk CITY OF IOWA CITY P 14 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 850110 Airport Operations 76850110 446160 ITS-Network/Intern TOTAL Airport Operations 446200 Photocopying Chargeback 850110 Airport Operations 76850110 446200 Photocopying Charg TOTAL Airport Operations 446220 Phone Service Chargeback 850110 Airport Operations 76850110 446220 Phone Service Char TOTAL Airport Operations 446300 Phone Equipment/Line Chgbk 850110 Airport Operations 76850110 446300 Phone Equipment/Li 2,867 0 2,867 486.20 8,505 0 8,505 8,505.00 8,505 0 8,505 8,505.00 71 0 71 .06 71 0 71 .06 1,021 0 1,021 1,021 0 1,021 00 2,380.47 17.0°% 00 .00 100.0°%* 00 .00 100.0°% 00 71.10 .1% 00 71.10 .1% 00 .00 1,021.00 .0°% 00 .00 1,021.00 .0°% 1.140 0 1.140 300.00 00 840.00 26.3°%* 10/13/2014 14:08 CITY OF IOWA CITY P 15 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 1,140 0 1,140 300.00 446320 Mail Chargeback 850110 Airport Operations 76850110 446320 Mail Chargeback 323 0 323 9.84 TOTAL Airport Operations 323 0 323 9.84 446350 City Vehicle Replacement Chgbk 850110 Airport Operations 76850110 446350 City Vehicle Repla 16,757 0 16,757 4,952.56 TOTAL Airport Operations 16,757 0 16,757 4,952.56 446360 City Vehicle Rental Chargeback 850110 Airport Operations 76850110 446360 City Vehicle Renta 500 0 500 .00 TOTAL Airport Operations 500 0 500 .00 446370 Fuel Chargeback 850110 Airport Operations 76850110 446370 Fuel Chargeback 4,542 0 4,542 1,813.60 00 840.00 26.3°% 00 313.01 3.0% 00 313.01 3.0% 00 11,803.96 29.6°°%* 00 11,803.96 29.6°% 00 500.00 .0°% 00 500.00 .0°% 00 2.728.81 39.9°%* 10/13/2014 14:08 CITY OF IOWA CITY P 16 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ REVISED AVAILABLE PCT 76850110 Airport Operations APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 446380 Vehicle R&M Chargeback 850110 Airport Operations 76850110 446380 Vehicle R&M Charge TOTAL Airport Operations 449055 Permitting Fees 850110 Airport Operations 76850110 449055 Permitting Fees TOTAL Airport Operations 449060 Dues & Memberships 850110 Airport Operations 76850110 449060 Dues & Memberships TOTAL Airport Operations 449100 Vehicle Rental 850110 Airport Operations 76850110 449100 651 Vehicle Rental 4,542 0 4,542 1,813.60 1,200 9,023 0 9,023 6,033.78 0 9,023 0 9,023 6,033.78 65 0 65 175.00 65 0 65 175.00 1,200 0 1,200 .00 1,200 0 1,200 .00 0 0 0 1,817.67 00 2,728.81 39.9°% 00 2,989.20 66.9°%* 00 2,989.20 66.9°% 00 -110.00 269.2°%* 00 -110.00 269.2°% 00 1,200.00 .0°% 00 1,200.00 .0°% 00 -1,817.67 100.0°%* 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY P 17 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 0 0 0 1,817.67 .00 -1,817.67 100.0°% 449120 Equipment Rental 850110 Airport Operations 76850110 449120 Equipment Rental 500 0 500 150.00 .00 350.00 30.0°%* 76850110 449120 651 Equipment Renta 0 0 0 3,276.20 .00 -3,276.20 100.0°%* TOTAL Airport Operations 500 0 500 3,426.20 .00 -2,926.20 685.2°% 449360 Interest Expense 850110 Airport Operations 76850110 449360 Interest Expense 32,572 0 32,572 6,618.74 .00 25,953.26 20.3°% TOTAL Airport Operations 32,572 0 32,572 6,618.74 .00 25,953.26 20.3°% 452010 Office Supplies 850110 Airport Operations 76850110 452010 Office Supplies 317 0 317 171.36 .00 145.27 54.1°%* TOTAL Airport Operations 317 0 317 171.36 .00 145.27 54.1°% 454020 Subscriptions 850110 Airport Operations 76850110 454020 Subscriptions 125 0 125 .00 .00 124.80 .0% 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations CITY OF IOWA CITY P 18 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED TOTAL Airport Operations 125 0 125 .00 .00 124.80 735.47 .0°% 461040 Other Agriculture Chemicals 50 .00 50 0 50 .00 967 0 850110 Airport Operations 76850110 461040 Other Agriculture TOTAL Airport Operations 465010 Other Fluids & Gases 850110 Airport Operations 76850110 465010 651 Other Fluids & TOTAL Airport Operations 466040 Plumbing Supplies 850110 Airport Operations 76850110 466040 Plumbing Supplies TOTAL Airport Operations 466050 Electrical Supplies 122 0 122 207.95 122 0 122 207.95 0 0 0 735.47 0 0 0 735.47 50 0 50 .00 50 0 50 .00 00 -86.02 170.5°%* 00 -86.02 170.5°% 00 -735.47 100.0°%* 00 -735.47 100.0°% 00 50.00 .0°% 00 50.00 .0°% 850110 Airport Operations 76850110 466050 Electrical Supplie 967 0 967 11.00 .00 955.76 1.1% 10/13/2014 14:08 CITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT FOR 2015 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ 76850110 Airport Operations APPROP ADJSTMTS REVISED BUDGET YTD ACTUAL ENCUMBRANCES AVAILABLE BUDGET P 19 glytdbud PCT USED TOTAL Airport Operations 967 0 967 11.00 .00 955.76 1.1% 466070 Other Maintenance Supplies 850110 Airport Operations 76850110 466070 Other Maintenance 563 0 563 283.34 .00 279.76 50.3°°%* TOTAL Airport Operations 563 0 563 283.34 .00 279.76 50.3°% 467020 Equipment R&M Supplies 850110 Airport Operations 76850110 467020 Equipment R&M Supp 100 0 100 121.13 .00 -21.13 121.1%* TOTAL Airport Operations 100 0 100 121.13 .00 -21.13 121.1% 467160 Other Vehicle R&M Supplies 850110 Airport Operations 76850110 467160 Other Vehicle R&M 0 0 0 20.12 .00 -20.12 100.0°%* TOTAL Airport Operations 0 0 0 20.12 .00 -20.12 100.0°% 468030 Asphalt 850110 Airport Operations 76850110 468030 Asphalt 50 0 50 .00 .00 50.00 .0°% 10/13/2014 14:08 mtharp FOR 2015 03 ACCOUNTS FOR: 76850110 Airport Operations TOTAL Airport Operations 468050 Sand CITY OF IOWA CITY P 20 YEAR-TO-DATE BUDGET REPORT glytdbud ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES BUDGET USED 850110 Airport Operations 76850110 468050 Sand TOTAL Airport Operations 469040 Traffic Cntrl Imprvmt Supplies 850110 Airport Operations 76850110 469040 Traffic Cntrl Imnr TOTAL Airport Operations 469190 Minor Equipment 850110 Airport Operations 50 0 50 .00 .00 50.00 415.21 .0°% 50 0 50 .00 .00 50.00 415.21 .0°% 50 0 50 .00 .00 50.00 .0°% 500 0 500 33.66 500 0 500 33.66 00 466.34 6.7% 00 466.34 6.7% 76850110 469190 Minor Equipment 500 0 500 84.79 .00 415.21 17.0°% TOTAL Airport Operations 500 0 500 84.79 .00 415.21 17.0°% 469200 Tools 850110 Airport Operations 76850110 469200 Tools 500 0 500 .00 .00 500.00 .0°% 10/13/2014 14:08 CITY OF IOWA CITY mtharp YEAR-TO-DATE BUDGET REPORT FOR 2015 03 ACCOUNTS FOR: ORIGINAL TRANFRS/ 76850110 Airport Operations APPROP ADJSTMTS REVISED BUDGET YTD ACTUAL ENCUMBRANCES AVAILABLE BUDGET P 21 glytdbud PCT USED TOTAL Airport Operations 500 0 500 .00 .00 500.00 120,259.54 .0°% 469260 Fire Ext & Refills 850110 Airport Operations 76850110 469260 Fire Ext & Refills 750 0 750 .00 .00 750.00 .0°% TOTAL Airport Operations 750 0 750 .00 .00 750.00 .0°% 473010 Contracted Improvements 850110 Airport Operations 76850110 473010 Contracted Improve 40,000 0 40,000 .00 .00 40,000.00 .0°% TOTAL Airport Operations 40,000 0 40,000 .00 .00 40,000.00 .0°% 490190 Interfund Loan 850110 Airport Operations 76850110 490190 Interfund Loan 32,126 TOTAL Airport Operations 32,126 TOTAL Airport Operations 0 TOTAL REVENUES -390,506 TOTAL EXPENSES 390,506 0 32,126 9,555.84 00 0 32,126 9,555.84 -6,267.91*******°% 0 0 6,268.00 00 0 -390,506 -113,991.54 0 390,506 120,259.54 00 22,570.61 29.7°°%* 00 22,570.61 29.7°% 00 -6,267.91*******°% 00 -276,514.10 00 270,246.19 10/13/2014 14:08 CITY OF IOWA CITY P 22 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud FOR 2015 03 ORIGINAL TRANFRS/ REVISED APPROP ADJSTMTS BUDGET YTD ACTUAL ENCUMBRANCES GRAND TOTAL 0 0 0 6.268.00 ** END OF REPORT - Generated by Michael Tharp ** AVAILABLE PCT BUDGET USED 00 -6.267.91*******% 10/13/2014 14:08 CITY OF IOWA CITY P 23 mtharp YEAR-TO-DATE BUDGET REPORT glytdbud Field # Total Page Break Sequence 1 9 Y Y Sequence 2 11 N N Sequence 3 6 Y 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 Account type Account status REPORT OPTIONS Year/Period: 2015/ 3 Print MTD Version: N Roll projects to object: N Carry forward code: 1 FY 2016 Budget Preparation Materials 10/13/2014 16:20 CITY OF IOWA CITY Operations 76850110 P 1 mtharp NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 16150 FY 2016 Salary Proj from 1601 76850110 421100 FOR PERIOD 12 ACCOUNTS FOR: 421200 Dental Ins 76850110 421300 Life Ins 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DIVISION COMMENT 850110 Airport Operations 76850110 411000 Perm FT 76850110 413000 Temp Empl 76850110 414500 Longevity 76850110 421100 Health Ins 76850110 421200 Dental Ins 76850110 421300 Life Ins 76850110 421400 DisbltyIns 76850110 422100 FICA 76850110 423100 IPERS TOTAL UNDEFINED PROJECT TOTAL Airport Operations TOTAL Airport TOTAL REVENUE TOTAL EXPENSE GRAND TOTAL 51,279.12 55,307.00 55,307.00 14,844.80 55,307.00 57,138.00 1,203.53 .00 .00 208.63 .00 .00 325.00 325.00 325.00 .00 325.00 325.00 4,650.48 4,650.00 4,650.00 1,372.98 4,650.00 4,907.00 326.88 327.00 327.00 95.83 327.00 345.00 135.91 135.00 135.00 36.12 135.00 149.00 250.27 248.00 248.00 66.36 248.00 276.00 4,004.15 4,219.00 4,219.00 1,140.98 4,219.00 4,354.00 4,715.75 4,968.00 4,968.00 1,344.28 4,968.00 5,131.00 66,891.09 70,179.00 70,179.00 19,109.98 70,179.00 72,625.00 66,891.09 70,179.00 70,179.00 19,109.98 70,179.00 72,625.00 66,891.09 70,179.00 70,179.00 19,109.98 70,179.00 72,625.00 .00 .00 .00 .00 .00 .00 66,891.09 70,179.00 70,179.00 19,109.98 70,179.00 72,625.00 66,891.09 70,179.00 70,179.00 19,109.98 70,179.00 72,625.00 ** END OF REPORT - Generated by Michael Tharp ** 10/13/2014 16:20 Airport CITY OF IOWA CITY 76850110 381100 Int Invest P 1 mtharp Land Rent NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS 76850110 bgnyrpts PROJECTION: 16100 FY16 Operating Budget 384900 Oth Comm FOR PERIOD 12 ACCOUNTS FOR: S1 of Land 76850110 393120 Gen Levy 76850110 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DIVISION COMMENT 850110 Airport Operations 76850110 381100 Int Invest 76850110 382100 Land Rent 76850110 382200 BdngRmRent 76850110 384200 Vndg Comm 76850110 384900 Oth Comm 76850110 392100 S1 of Land 76850110 393120 Gen Levy 76850110 411000 Perm FT 76850110 413000 Temp Empl 76850110 414500 Longevity 76850110 421100 Health Ins 76850110 421200 Dental Ins 76850110 421300 Life Ins 76850110 421400 DisbltyIns 76850110 422100 FICA 76850110 423100 IPERS 76850110 431020 CourtCosts 76850110 432020 Audit 76850110 432080 OthProSrvc 76850110 435056 Delivery 76850110 435057 Couriers 411.23 -1,314.00 -1,314.00 33.79 .00 .00 -50,108.60 -45,647.04 -45,647.04 -2,633.21 -50,109.00 -50,109.00 -250,382.83 -250,000.00 -250,000.00 -86,125.67 -250,383.00 -250,383.00 -79.20 -129.60 -129.60 .00 -79.00 -79.00 -26,969.90 -25,000.00 -25,000.00 -6,453.70 -26,970.00 -26,970.00 -212,505.00 .00 .00 .00 .00 .00 -72,342.00 -68,415.00 -68,415.00 -17,103.75 .00 .00 51,279.12 55,307.00 55,307.00 14,844.80 .00 .00 1,203.53 .00 .00 208.63 .00 .00 325.00 325.00 325.00 .00 .00 .00 4,650.48 4,650.00 4,650.00 1,372.98 .00 .00 326.88 327.00 327.00 95.83 .00 .00 135.91 135.00 135.00 36.12 .00 .00 250.27 248.00 248.00 66.36 .00 .00 4,004.15 4,219.00 4,219.00 1,140.98 .00 .00 4,715.75 4,968.00 4,968.00 1,344.28 .00 .00 98.00 .00 .00 .00 98.00 98.00 1,386.83 1,130.55 1,130.55 .00 1,437.00 1,437.00 7,550.00 .00 .00 .00 .00 .00 .00 50.00 50.00 41.20 .00 .00 18.39 .00 .00 .00 .00 .00 10/13/2014 16:20 mtharp PROJECTION: 16100 ACCOUNTS FOR: Airport CITY OF IOWA CITY NEXT YEAR / CURRENT FY16 Operating Budget 2014 ACTUAL YEAR BUDGET 2015 ORIG BUD ANALYSIS 2015 REVISED BUD 2015 ACTUAL 2015 PROJECTION P 2 bgnyrpts FOR PERIOD 12 2016 DIVISION COMMENT 76850110 435060 Legal Pubs 165.93 50.00 50.00 31.90 205.00 205.00 76850110 436030 Transportn 137.76 1,000.00 1,000.00 .00 .00 .00 76850110 436050 Registratn 198.00 500.00 500.00 .00 .00 .00 76850110 436060 Lodging 232.96 500.00 500.00 .00 .00 .00 76850110 436080 Meals 54.00 200.00 200.00 .00 .00 .00 76850110 437010 CompLiabty 3,407.14 4,154.81 4,154.81 3,202.00 3,748.00 3,748.00 76850110 437020 Fir&CasIns 11,627.00 12,785.75 12,785.75 .00 12,790.00 12,790.00 76850110 437030 WrkCompIns 112.00 72.97 72.97 .00 123.00 123.00 76850110 437041 Bnd&OthIns 875.00 1,029.88 1,029.88 .00 875.00 875.00 76850110 437200 Loss RsvPay 5,150.00 5,000.00 5,000.00 .00 .00 .00 76850110 438010 Stormwater 13,018.08 13,811.59 13,811.59 3,550.26 14,320.00 14,320.00 76850110 438030 Electricty 14,928.84 16,955.68 16,955.68 6,337.78 17,290.00 17,290.00 76850110 438050 Landfill 35.64 217.26 217.26 30.80 .00 .00 76850110 438070 HeatngFuel 6,019.69 4,931.04 4,931.04 430.57 6,773.00 6,773.00 76850110 438080 Sewer 2,475.73 1,361.56 1,361.56 503.49 2,566.00 2,566.00 76850110 438090 Water 2,136.71 1,305.67 1,305.67 492.28 2,215.00 2,215.00 76850110 438100 Refuse 1,067.00 1,211.03 1,211.03 364.98 1,207.00 1,207.00 76850110 438110 Loc Phone 256.86 .00 .00 342.03 266.00 266.00 76850110 438120 LD Phone 60.30 55.00 55.00 15.09 63.00 63.00 76850110 442010 OthBldgR&M 16,423.04 12,000.00 12,000.00 6,088.06 18,940.00 18,940.00 76850110 442020 Struct R&M 1,094.00 4,000.00 4,000.00 .00 1,134.00 1,134.00 76850110 442030 HeatingR&M 217.50 1,000.00 1,000.00 .00 225.00 225.00 10/13/2014 16:20 mtharp PROJECTION: 16100 ACCOUNTS FOR: Airport CITY OF IOWA CITY NEXT YEAR / CURRENT FY16 Operating Budget 2014 ACTUAL YEAR BUDGET 2015 ORIG BUD ANALYSIS 2015 REVISED BUD 2015 ACTUAL 2015 PROJECTION P 3 bgnyrpts FOR PERIOD 12 2016 DIVISION COMMENT 76850110 442040 CoolingR&M .00 1,000.00 1,000.00 .00 .00 .00 76850110 442060 Elec PlmR&M 7,408.55 4,879.15 4,879.15 175.43 7,861.00 7,861.00 76850110 442070 Pest Cntrl 373.45 423.86 423.86 33.95 387.00 387.00 76850110 443080 Oth Eq R&M 6,656.73 3,000.00 3,000.00 1,566.86 6,904.00 6,904.00 76850110 444060 CblElecR&M .00 .00 .00 320.34 332.00 332.00 76850110 445030 Nursery 35,600.00 49,200.00 49,200.00 18,207.79 41,780.00 41,780.00 76850110 445080 SnowIceRem 18,000.00 18,000.00 18,000.00 .00 18,657.00 18,657.00 76850110 445110 Testing 400.00 814.22 814.22 382.60 811.00 811.00 76850110 445140 Printing 19.95 100.00 100.00 .00 .00 .00 76850110 445230 OthOptgSvc 264.00 .00 .00 .00 274.00 274.00 76850110 446100 Atty Chgbk 6,624.59 2,981.45 2,981.45 .00 .00 .00 76850110 446130 ITS PC Chg 800.00 800.00 800.00 .00 .00 .00 76850110 446140 ITSReplChg 810.14 2,866.67 2,866.67 486.20 .00 .00 76850110 446150 ITSDvlpChg 671.00 .00 .00 .00 .00 .00 76850110 446160 ITSNetwChg 720.00 8,505.00 8,505.00 8,505.00 .00 .00 76850110 446200 Copy Chgbk 24.90 71.16 71.16 .06 .00 .00 76850110 446220 PhoneChgbk 769.32 1,021.00 1,021.00 .00 .00 .00 76850110 446300 PhoneEgChg 1,110.00 1,140.00 1,140.00 300.00 .00 .00 76850110 446320 Mail Chgbk 302.68 322.85 322.85 9.84 .00 .00 76850110 446350 VehReplChg 18,041.08 16,756.52 16,756.52 4,952.56 18,582.00 18,582.00 76850110 446360 VehRentChg 248.59 500.00 500.00 .00 264.00 264.00 76850110 446370 Fuel Chgbk 4,871.30 4,542.41 4,542.41 1,813.60 4,944.00 4,944.00 10/13/2014 16:20 mtharp PROJECTION: 16100 ACCOUNTS FOR: Airport CITY OF IOWA CITY NEXT YEAR / CURRENT FY16 Operating Budget 2014 ACTUAL YEAR BUDGET 2015 ORIG BUD ANALYSIS 2015 REVISED BUD 2015 ACTUAL 2015 PROJECTION P 4 bgnyrpts FOR PERIOD 12 2016 DIVISION COMMENT 76850110 446380 VehR&MChg 19,194.01 9,022.98 9,022.98 6,033.78 20,346.00 20,346.00 76850110 448040 CtySpEvent 5,000.00 .00 .00 .00 5,000.00 5,000.00 76850110 449055 PermitFees 1,015.00 65.00 65.00 175.00 1,015.00 1,015.00 76850110 449060 Dues&Memb 1,210.00 1,200.00 1,200.00 .00 1,254.00 1,254.00 76850110 449120 Equip Rent .00 500.00 500.00 150.00 155.00 155.00 76850110 449280 MiscSrvcs 204.00 .00 .00 .00 .00 .00 76850110 449350 MealsNOTry 106.81 .00 .00 .00 .00 .00 76850110 449360 Interest 32,834.08 32,572.00 32,572.00 6,618.74 32,834.00 32,834.00 76850110 452010 Off Supply 526.77 316.63 316.63 171.36 724.00 724.00 76850110 452030 MinEq/Fern 250.00 .00 .00 .00 259.00 259.00 76850110 454020 Subscript 24.00 124.80 124.80 .00 .00 .00 76850110 455120 MiscHrdwr 201.76 .00 .00 .00 .00 .00 76850110 461040 OthAg Chem 364.56 121.93 121.93 207.95 516.00 516.00 76850110 466040 Plumbing .00 50.00 50.00 .00 .00 .00 76850110 466050 Electrical 181.10 966.76 966.76 11.00 188.00 188.00 76850110 466070 Oth Maint 351.03 563.10 563.10 283.34 416.00 416.00 76850110 467020 Equip R&M 421.14 100.00 100.00 121.13 562.00 562.00 76850110 467160 OthVehR&M .00 .00 .00 20.12 .00 .00 76850110 468030 Asphalt .00 50.00 50.00 .00 .00 .00 76850110 468050 Sand 40.23 50.00 50.00 .00 .00 .00 76850110 469040 TrafficCnt 283.42 500.00 500.00 33.66 329.00 329.00 76850110 469190 MinorEquip .00 500.00 500.00 84.79 88.00 88.00 10/13/2014 16:20 CITY OF IOWA CITY P 5 mtharp NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 16100 FY16 Operating Budget FOR PERIOD 12 ACCOUNTS FOR: 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DIVISION COMMENT 76850110 469200 Tools .00 500.00 500.00 .00 .00 .00 76850110 469260 FireExtRef 194.90 750.00 750.00 .00 202.00 202.00 76850110 469360 Food&Bever 31.80 .00 .00 .00 .00 .00 76850110 473010 Cont Impr 3,490.00 40,000.00 40,000.00 .00 .00 .00 76850110 473020 NonConImpr 1,225.00 .00 .00 .00 .00 .00 76850110 490040 CIPFunding -35,693.30 .00 .00 .00 .00 .00 76850110 490190 InterfndLn 180,512.66 32,126.45 32,126.45 9,555.84 .00 .00 TOTAL UNDEFINED PROJECT -140.653.56 .09 .09 -11.521.18 -78.582.00 -78.582.00 10/13/2014 16:20 CITY OF IOWA CITY 651 Contr&Dona P 6 mtharp NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS bgnyrpts PROJECTION: 16100 FY16 Operating Budget 76850110 438100 FOR PERIOD 12 ACCOUNTS FOR: 76850110 445140 651 Printing 76850110 2014 2015 2015 2015 2015 2016 Airport ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION DIVISION COMMENT 651 Fly Iowa 2014 76850110 362100 651 Contr&Dona 76850110 432080 651 OthProSrvc 76850110 437010 651 CompLiabty 76850110 438100 651 Refuse 76850110 445140 651 Printing 76850110 449100 651 Veh Rent 76850110 449120 651 Equip Rent 76850110 465010 651 Oth Fluids TOTAL Fly Iowa 2014 TOTAL Airport Operations TOTAL Airport TOTAL REVENUE TOTAL EXPENSE GRAND TOTAL -28,410.00 .00 .00 -1,709.00 -28,410.00 -28,410.00 4,000.00 .00 .00 7,729.79 .00 .00 .00 .00 .00 5,001.00 5,501.00 5,501.00 .00 .00 .00 182.03 .00 .00 .00 .00 .00 3,720.57 3,856.00 3,856.00 .00 .00 .00 1,817.67 1,884.00 1,884.00 .00 .00 .00 3,276.20 3,396.00 3,396.00 .00 .00 .00 735.47 772.00 772.00 -24,410.00 .00 .00 20,753.73 -13,001.00 -13,001.00 -165,063.56 .09 .09 9,232.55 -91,583.00 -91,583.00 -165,063.56 .09 .09 9,232.55 -91,583.00 -91,583.00 -640,386.30 -390,505.64 -390,505.64 -113,991.54 -355,951.00 -355,951.00 475,322.74 390,505.73 390,505.73 123,224.09 264,368.00 264,368.00 165,063.56 .09 .09 9,232.55 -91,583.00 -91,583.00 ** END OF REPORT - Generated by Michael Tharp **