Loading...
FY 2014 Second Budget Amendment_Setting Public HearingTHE CITY OF Dui Masterpiece on the Mississippi Dubuque band AI -America City r 2007 • 2012 • 2013 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2014 Second Budget Amendment DATE: March 27, 2014 Budget Director Jennifer Larson is recommending the second Fiscal Year 2014 Budget Amendment be set for public hearing for April 21, 2014. I concur with the recommendation and respectfully request Mayor and City Council approval. iitiW. kr.,,.,7)4ii„ Michael C. Van Milligen MCVM/jml Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Teri Goodmann, Assistant City Manager Jennifer Larson, Budget Director THE CITY OF Dui Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2014 Second Budget Amendment DATE: March 27, 2014 Dubuque band AI -America City r 2007 • 2012 • 2013 The purpose of this memorandum is to present a summary of the action items approved by City Council throughout the year subject to a future budget amendment and to set the public hearing date for the formal budget amendment process as required by Section 384.16 of the Code of Iowa. This budget amendment includes items, which have been authorized by City Council since the first amendment to the Fiscal Year 2014 budget was adopted in September 2013 and adjustments to reflect the amended Community Development Annual Plan. This amendment includes budget reductions related to the shortfall of local option sales tax, gaming and Section 8 administrative fee revenues. This amendment also reflects reappropriations of completed or canceled projects to fund increased operating and capital expenses. An increase of interfund transfers of $838,525 is also included. The amendment totals $26,225,209 in decreased appropriation authority and a decrease in resources of $26,892,842. The recommended Fiscal Year 2015 budget recommendation already considered a downturn in two important revenue sources, Dubuque Racing Association lease payments and local option sales taxes. The Fiscal Year 2015 budget recommendation projects a 5.8% decline in DRA lease payments, a 58.8% decline in DRA Distribution, and a 9.1% decline in local option sales tax. This budget amendment recommendation is related to the current Fiscal Year 2014 budget. The decline in DRA lease revenues is a long-term trend, reducing from a high of $9,757,458 in Fiscal Year 2007 to the projection of $6,000,001 in Fiscal Year 2015. 810,000,000 $9,758 $9,753,410 89,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 DRA Rent (FY 2007 - 2015) $8,406,929 $b,810,183 $6,343.130 $C,Q97 88 $',001,143 2007 2008 2009 2010 2011 $6,253,228 $6,000,001 gip $5,447,917 2012 2013 2014 2014 2015 Actual Actual Actual Actual Actual Actual Actual Revised Budget Budget 7 • Rent The City is working with the DRA on a Master Plan for Schmitt Island, working to eliminate the continued financial drain of pari-mutuel greyhound dog racing, and involved with other activities to improve the gaming revenues at Mystique Casino. There are other threats to future revenue growth at Mystique Casino with the introduction of video gaming terminals (VGT) in taverns in Illinois, as this has become an over $100 million business, and the possibility of additional competition with the Iowa Racing and Gaming Commission considering an application for a casino in Cedar Rapids. Even though the local option sales tax revenue is down, I have less concern about this revenue source. Sales tax has been a long-term reliable source of revenue and I anticipate this continuing. $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 Local Option Sales Tax M co .4 M CI 00 CM p N • M • M 4i CO Q1 T A cp O •Ci K Tr CO ai m c) a ▪ M ' w tiyr to_n w 44 I M07 co - 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2014 2015 Actual Actual Actual Actual Actual Actual Actual Actual Actual Revised Budget Budget The issue to deal with tonight relates to the current Fiscal Year 2014 budget. The Dubuque Racing Association annual distribution payment was $684,427 short of projections. This only impacts the City's Capital Improvement Budget, because these funds are dedicated to capital improvements. The projections for Fiscal Year 2014 DRA lease revenues and local option sales tax are less than anticipated when this budget was prepared in late 2012. The DRA lease revenues are budgeted 90% operating and 10% capital in FY 2014. The Local Option Sales Tax revenue is budgeted 50% operating and 50% capital. The Fiscal Year 2014 impact of the reduced Local Option Sales Tax and DRA lease revenues is a $555,531 reduction to Capital Improvement and a $1,199,780 reduction to the General Fund Operating Budget. I believe both of these revenues are being impacted by the coldest winter in almost 40 years. Another area of concern in this year's budget is caused by the use of road salt to combat this year's winter conditions. To begin this year, the City had almost 15,000 tons of salt available. This is thanks to the foresight of the City Council when a few years ago when 50 year riverfront leases were expiring, the City did not lease back all of the City - owned industrial riverfront property to private concerns. The City held back a few acres to create a salt storage pad for City salt. This allowed the City to buy salt direct from salt mines in Louisiana at volume discount prices and then ship it to Dubuque and store Targe volumes. In a typical winter, the City uses about 8,000 tons of salt. The most the City has ever used in one winter was in Fiscal Year 2008 when the City used 12,000 tons of salt. Going into this winter, the City had stored 15,000 tons of salt. There is the possibility the City will use all of this salt. With the City's new storage capabilities, the preference is to enter a winter with 12,000 tons of salt. Between the Fiscal Year 2014 and Fiscal Year 2015 budgets, the City has enough funds budgeted ($472,500) to purchase 8,670 tons of salt. Depending on salt usage the rest of the year (temperatures above freezing predicted all this week) the City could need an additional $181,485 for salt purchases to replenish stockpiles. The Section 8 Voucher program will have fewer vouchers than budgeted in FY 2014 due to the Federal sequestration which will result in less administrative fee revenue received from HUD of approximately $51,677. This reduction in revenue will need to be funded by the General Fund. The Grand River Center Floor Settlement Remediation Project was completed in November 2013 with a total project cost of $591,234. There were capital projects totaling $363,500 that were canceled to help fund the project; however there is still a project shortfall of $227,734 which will need to be funded by canceling additional capital projects. I stand by the Fiscal Year 2015 budget recommendations, but these Fiscal Year 2014 budget revenue shortfalls must be addressed. It is anticipated that the Capital Improvement Budget will have $1,239,958 Tess in revenues than anticipated and an increase in expenses of $227,734 which results in a total capital shortfall of $1,467,692. The General Fund Operating Budget will have $1,251,457 Tess in revenues and $181,485 in increased expense for salt purchases which results in a total operating deficit of $1,432,942. The following is the recommended solution: 1. Operating Budget Administratively initiate a hiring freeze on most general fund positions, excluding sworn public safety positions, positions in the Emergency Communications Center and the Leisure Services Recreation Supervisor position. Other general fund positions will be evaluated by the City Manager on a case-by-case basis as they become vacant, with there being few exceptions to the freeze. Along with the lag time in going through the lengthy civil service process to fill sworn public safety positions, this is anticipated to save $552,376 in Fiscal Year 2014. The need for additional funds will be accomplished through the cancellation of more general fund CIP projects than are required to fill the revenue issues related to Capital Improvement Projects. This hiring freeze will be extended into part of Fiscal Year 2015; until it is determined FY15 revenue projections are being met. How far into Fiscal Year 2015 will be determined by the revenues. Should this appear to be more of a long-term issue, it will need to be dealt with using a more long-term solution through the Fiscal Year 2016 budget process. The travel budget for property tax departments has been frozen unless the conferences or education is needed to retain job certifications, the registration has been already paid, and the employee is on the Board of Directors or has agreed to make a presentation. This is a one-time savings in FY14 totaling $140,563. The Fiscal Year 2015 travel budget will remain intact. There is equipment purchases budgeted in FY14 that will be canceled and budgeted in a future budget year totaling $51,052. The hiring freeze, vacancy savings, travel freeze and equipment cancelation savings totals $743,991. The operating deficit remaining of $688,951 is recommended to be funded by the cancelation of current year general fund capital projects. 2. Capital Improvement Budget The City needs to cancel some capital improvement projects that impact the general fund. This does not include projects for water, sanitary sewer, storm sewer or parking, or projects supported by tax increment financing. In fact, the City would have the option of moving some projects from being funded by the general fund to being funded with tax increment financing revenues, where appropriate. 1. The following projects are being recommended for elimination to be reconsidered for funding through the Fiscal Year 2016 budget process: Project Reduction Eligible for Alternative Funding (Type?) Recommending for Alternative Funding (Yes or No) Accessibility Barriers $50,000 Yes No Bath House Improvements $7,500 No No Cedar Cross Street Lighting $16,001 No No Concrete Section Repairs $23,504 No No Creekwood Park $95,791 No No Crosswalk Warning Devices $25,000 No No Curb Replacement $10,000 No No Curb/Catch Basin $10,824 No No Decorative Concrete $20,000 No No Development Standards $35,353 Yes No Development Standards $15,000 Yes No DLEC Battery Back -Ups $39,500 No No Downtown ADA Assistance $5,000 GDTIF No Downtown Street Light Replacement $26,329 GDTIF No Eagle Point Park Clear Trees on Bluff $15,000 No No Eagle Point Park Paint Pavilions $25,000 No No Eagle Point Park Retaining Wall $75,000 No No Eagle Point Park Riverfront Pavilion $94,282 No No Project Reduction Eligible for Alternative Funding (Type?) Recommending for Alternative Funding (Yes or No) Eagle Point Park Stonework $15,000 No No Eagle Valley Park Development $95,770 No No Ecological Restoration $20,000 No No Federal Building Renovation $40,000 GDTIF No Five Flags Seal Concrete Walkways $4,000 No No Flora & Sutton Storage Building $7,756 No No Flora Waterslide Pump $10,000 No No GRC Wall Coverings $7,263 GDTIF No Green Alley Project $30,000 GDTIF No Greenhouse Addition $85,173 No No Guard Rail Replacement $20,000 No No Highway 20 Roses Plan $21,000 No No Historic District Improvements $4,673 GDTIF No Historical/Architectural Surveys $11,983 No No Homeowner Grants Targeted Neighborhood $265,206 GDTIF No Homeowner Grants Targeted Neighborhood $28,151 GDTIF No LED Streetlight Retrofit $5,000 No No McAleece French Drains $10,000 No No Mystique Community Ice Center A/C1 $75,226 No No Mystique Community Ice Center Electrical Improvements' $29,060 No No Mystique Community Ice Center Generator' $91,198 No No Mystique Community Ice Center Ice Decking' $6,392 No No Mystique Community Ice Center Power Factor' $10,099 No No Painting Street Lights/Signals $3,238 No No Park Security Lights $14,305 No No Pet Park $94,308 No No Port Amenities Maintenance $6,313 No No Port of Dubuque - Leasehold $1,974 GDTIF No Port of Dubuque Outdoor Plaza2 $108,000 GDTIF No Portable Radar Speed Sign $10,624 No No Re -caulk Pool Decks $12,140 No No Renovate Recirculation Pumps $10,000 No No Riverfront 2000 Plan $5,000 GDTIF No Riverwalk Baskets - Irrigate $12,000 No No School Zone Countdown Signals $4,000 No No Project Reduction Eligible for Alternative Funding (Type?) Recommending for Alternative Funding (Yes or No) Skate Park $70,000 No No Stone Retaining Walls $49,752 No No Stone Retaining Walls $11,218 No No Street Light Replacement $15,000 No No Street Light/Signal Knockdown $10,000 No No Sub -Divisions Sub Drains $150,000 No No Surge and Grounding Improvements $5,000 No No Surge Tank Repair $15,000 No No Sustainability $8,700 No No SW Arterial Capacity Improvements $25,000 No No Traffic Operations Center Test Bench $25,000 No No Westbrook Park Development $96,178 No No Subtotal $2,244,784 Completed Project Savings3 $145,379 Grand Total $2,390,163 1 The Mystique Community Ice Center Improvements totaling $211,975 are no longer required and were funded by debt payable from the Greater Downtown TIF District. These funds are recommended to be reallocated to fund the budgeted improvements to Comiskey Park totaling $211,975 which includes replacement of play equipment ($200,000) and repair of siding ($11,831). 2 The Port of Dubuque Outdoor Plaza has a total budget of $250,000, of which $142,000 is recommended to be used to fund the additional franchise rebates. The balance of $108,000 is recommended to be canceled to help fund the capital budget shortfall. 3 I addition to the recommended project cuts, there are projects that have been completed with realized savings of $145,379 to help fund the deficit in the capital budget. 2. The following is a list of additional General Fund CIP projects that the City Council could choose to substitute for any of the above recommended projects: Project Balance Eligible for Alternative Funding 10g Backbone $65,000 No Accessibility Barriers $19,537 No Allison Henderson Exterior Improvement $3,549 No Americas River Fest Equipment $909 Yes Asbury Road Grinding $30,000 No Project Balance Eligible for Alternative Funding Asphalt Milling Program $48,389 No Bath House Improvements $1,780 No Bi -Lingual Trail Signage $14,595 No Bridge Repairs/Maintenance $199,280 No Bunker Chemical Storage $1,597 No Bunker Replace Roof $61,425 No Catfish Creek Fiber $6,122 No Catfish Creek Hike/Bike Study $5,400 No Cedar Cross $340,280 No Grand River Center Chairs $2,260 Yes City Hall Annex Maintenance $37,654 Yes City Hall Remodeling $299,977 Yes City Wide Multifunction Replacement $81,006 No City Wide Multifunction Replacement $175,900 No Cold Storage Building Mezzanine $7,097 No Comiskey Play Equipment $200,000 Yes Comiskey Siding Repair $11,831 Yes Comiskey New Entry $30,000 Yes Comiskey New Entry Sign $7,000 Yes Comiskey Park Amenities $58,808 Yes Comiskey Park Building - Security Alarm $10,000 Yes Comiskey Park Door $10,205 Yes Comiskey Sidewalk Lighting $100,131 Yes Corridor Study -Alternates $200,000 Yes Curb Ramp Program $102,308 No Dictaphone System Upgrade $10,574 No DLEC Telephone Upgrade $28,704 No Downtown Sign Replacement $40,000 Yes Eagle Point Park Clear Trees Bluff $15,000 No Eagle Point Park Stone $20,750 No Eagle Point Park Stone $15,000 No Electric Locks Restrooms $30,000 No Eagle Point Park Bridge Beam Support $17,039 No Eagle Point Park Overlay Lot Tennis Ct $92,040 No Eagle Point Park Paint Bridge $12,080 No Eagle Point Park Replace Walkway $5,372 No Eagle Point Park Retaining $25,000 No Eagle Point Park Riverfront Pavilion $50,000 No Erosion Control Study $22,672 No Fiber Optic Conduit $9,227 No Fiber Optic Conduit Miscellaneous $44,101 No Fiber Optic Connections - Private & Misc $49,256 No Fiber Optics To Airport $300,000 No Project Balance Eligible for Alternative Funding Finance Plus Upgrade $2,448 No Floodwall Post Repair $47,894 No Five Flags Arena Light Fixtures $170,903 Yes Five Flags Arena Roof $385,341 Yes Flora Playground Equipment $30,131 No GIS System Implementation $9,977 No GIS Training $6,750 No GRC - Concrete $32,800 Yes GRC Maintenance $14,274 No GRC Replace Outdoor Furniture $21,037 Yes GRC River Room Cool Study $25,000 Yes Harbor Area Maintenance $161,500 No Harbor Area Maintenance $58,528 No Hilltop Park $10,136 No Historic Preservation Assistance $5,000 No Improvements To Fire Headquarters $3,921 Yes Internet, Micros & Printer $72,071 No Intersection Preemption $5,000 No Intersection Preemption $4,650 No ITS Traffic Control Equipment $102,829 No Laserfiche Upgrade RIO $27,889 No Library Attic Access $24,600 Yes Lincoln Ave Spillway Repair $6,408 No Maint. Headquarters Restroom Rehab $5,792 No Maintenance Vacant/Abandoned $101,241 No Maintenance Vacant/Abandon Buildings $50,000 No Marshall Park-Pool Repair $18,721 No Miller Riverview Pave $25,000 No Miller Riverview Rip Rap $7,726 No Murphy Park Fence Bluff $5,220 No New Concept Snow Plow $31,312 No Northend Trail Lighting $31,227 No Outdoor Siren $28,500 No Paint Arena Ceiling $79,311 Yes Paint Ballrooms $15,540 Yes Park Drinking Fountains $9,957 No Park Security Lights $5,000 No Parking Lot Striping $9,208 No Pavement Marking $31,690 No Pennsylvania At Radford Intersection $160,000 No Plan Hwy 20 Roses $15,000 No Playground Improvements $42,545 No Police Computer POE $58,831 No Project Balance Eligible for Alternative Funding Problem Properties Management $69,938 No Radio Tower Relocation $142,642 No Reconstruct Signals/JFK Wacker $14,488 No Reconstruct Signals/JFK-Wacker $138,408 No Recycling Containers $10,000 No Rehabilitation Rail Road Track $49,703 No Renovate Park Sidewalks $19,050 No Renovate Park Water System $35,963 No Riverfront Leasehold Improvements $116,185 Yes Riverwalk Security Cameras $18,795 Yes Safe Routes To School $37,881 No Security Cameras $4,291 No Sidewalk City Owned $13,972 No Sidewalk Financial Assistance $12,451 No Signal Intersection Reconstruction $60,648 No Signalization Program $91,869 No Slattery Center Renovation $29,300 No Smart Meters $165,310 No Software Upgrade E -Gov Plus $6,521 No Street Tree Program $3,729 No Theatre Tuck -point Exterior $244,416 Yes Theatre Tuck -point Exterior $6,945 Yes Tourism Signage $24,853 No Traffic Control Battery $10,000 No Traffic Controller Replacement $4,306 No Traffic Operations Center Video Software $46,544 No Traffic Operations Equipment Test $59,795 No Traffic Signal Fiber Optic $93,877 No Traffic Signal Interconnect $52,570 No Traffic Signal Master Arm $81,101 No Traffic Signal Video Detection $6,154 No Trails/Complete Streets $47,000 No University & Asbury Inters Improvements $123,539 No Veterans Renovate 32nd Storage $14,884 No Video Detection Camera Upgrade $30,860 No Total $6,767,751 3. The previous actions will resolve the Fiscal Year 2014 current year revenue shortfalls. As I mentioned, the administrative hiring freeze will be carried into Fiscal Year 2015 until it is determined FY15 revenue projections are being met. If it is determined that the future budget needs exceed anticipated revenues through the Fiscal Year 2016 budget process in February, 2015, the City will need to resolve the issue with a more long-term solution. This could include permanent expense reductions. It could also include ways to increase revenues. Three things could be considered to enhance revenues: 1. Create opportunities to increase retail sales and property tax revenues through aggressive economic development and workforce development initiatives. 2. The City could intensify efforts to seek state legislation to increase the state gas tax and to eliminate pari-mutuel greyhound dog racing. In the case of the gas tax, the City would not only see the Southwest Arterial built sooner, along with the associated development that will begin happening along that corridor, but the City would receive approximately $1 million in additional annual revenues for road use expenditures. In the case of the elimination of pari-mutuel greyhound dog racing, a large tract of land on Schmitt Island would open for development and the DRA would have over $4 million in less expenditures now being used to subsidize the dog racing, leading to investments that will make the facility more competitive for the gaming dollars and leading to greater distribution revenues for the City and charities. 3. Increase the 3% Utility Franchise Fee from the current 3% to either 4% or 5%, the maximum allowed by State law. An increase to 4% would generate approximately $750,000, equal to a 3.12% increase in property taxes to the average homeowner, and an increase to 5% would generate approximately $1,500,000, equal to a 6.24% increase in property taxes to the average homeowner. The City Council could consider offering a rebate to sales tax exempt entities on the franchise fee increase or not. Additional revenues added in this amendment with offsetting appropriations are: • Transportation and Community System Preservation Grant ($600,000) for Elm Street Reconstruction Project (9th to 12th) • Mobility Grant ($112,731) for Transit Mobility Coordinator, • Lead Safe for Kids Grant ($50,000) for Housing Lead Paint Abatement, • Harbor Maintenance Private Contribution ($70,644) for Dredging, and • Neighborhood Stabilization House Sale ($139,119) for future assistance. Reduced revenues reflected in this amendment with offsetting reductions in appropriations are: • Section 8 Administrative Fees (-$54,027) due to less vouchers, • Section 8 Housing Assistance Payment Revenue (-$427,834) due to less vouchers, • Local Option Sales Tax (-$950,000) due to reduced local option sales tax, • Gaming Distribution and Rent (-$1,409,738) due to reduced gaming revenues, • Federal Aid (-$8,051,892) for Southwest Arterial due to conversion to a State project, • County Contribution (-$1,157,758) for Southwest Arterial adjusted to correspond to when contributions will be received (FY15 & FY16), • State/Federal Grants (-$4,540,858) for Bee Branch based on when revenue will be received in FY15 & FY16, • Land Sales (-$300,000) for Bee Branch due to houses sold in prior year, • General Obligation Bonds (-$10,052,739) for Bee Branch due to City receiving State Flood Mitigation Grant for $98.5 million, and • State Revolving Loan Fund (-$2,883,383) for Bee Branch to adjust for actual due to City receiving State Flood Mitigation Grant for $98.5 million. In addition, the department contribution rate for health insurance was increased from $1,015 per month per contract to $1,500 per month per contract effective January 1, 2014. This results in an increase of $850,486 to the general fund which will be funded by the one-time General Fund operating reserve of $500,000 in FY 2014 for health insurance claims exceeding expectations and the possibility of needing to boost the health insurance reserve. The remainder of $350,486 will be funded by canceled capital improvement projects. The action step is for City Council to adopt the attached resolution setting the public hearing date for the formal budget amendment process as required by State law. The attached resolution authorizes the City Clerk to publish notification for a public hearing to be held April 21, 2014. Attachments JML RESOLUTION NO. 101-14 SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE FISCAL YEAR 2014 BUDGET FOR THE CITY OF DUBUQUE Whereas, Iowa Code Section 384.16 provides that the City Council shall set a time and place for a public hearing on amendments to the budget and publish notice before the hearing as provided in Iowa Code Section 362.3. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF DUBUQUE, IOWA: Section 1. That the City Council shall conduct a public hearing on proposed Amendment No. 2 to the Fiscal Year 2014 budget for the City of Dubuque at the City Council Chambers at the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday, April 21, 2014, beginning at 6:30 p.m. Section 2. That the City Clerk be and is hereby authorized and directed to publish notice of the public hearing, according to law, together with the required budget information. Passed, approved and adopted this 71" day of April 2014. Attest: Key' Firnstahl, Ci y Cler Roy D. Buol, Mayor Nov -07 NOTICE OF PUBLIC HEARING Form 653 CI AMENDMENT OF CURRENT CITY BUDGET The City Council of Dubuque in DUBUQUE will meet at City Council Chambers at the Historic Federal Building at 6:30 p.m. on 04/21/2013 (hour) (Date) ,for the purpose of amending the current budget of the city for the fiscal year ending June 30, County, Iowa 2014 (veal) by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity. Explanation of increases or decreases in revenue estimates, appropriations, or available cash: This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation to spend the monies. Adjustments to reflect the amended Community Development Annual Plan budget are included along with savings from completed or cancelled projects and available cash balance is used to fund increased operations. Reduction in Local Option Sales Tax Revenue and Gaming Revenue with offsetting operating and capital expense reductions. There will be no increase in tax levies to be paid in the current fiscal year named above. Any increase in expenditures set out above will be met from the increased non -property tax revenues and cash balances not budgeted or considered in this current budget. This will provide for a balanced budget. City Clerk! Finance Officer Name Total Budget as certified or last amended Current Amendment Total Budget after Current Amendment Revenues & Other Financing Sources 23,197,623 23,197,623 Taxes Levied on Property 1 Less: Uncollected Property Taxes -Levy Year 2 0 Net Current Property Taxes 3 23,197,623 0 23,197,623 Delinquent Property Taxes 4 0 TIF Revenues 5 9,752,170 9,752,170 Other City Taxes 6 15,560,397 -950,000 14,610,397 Licenses & Permits 7 1,368,930 1,368,930 Use of Money and Property 8 14,164,131 -1,389,239 12,774,892 Intergovernmental 9 70,923,135 -13,392,074 57,531,061 Charges for Services 10 36,056,828 36,056,828 Special Assessments 11 960,008 960,008 Miscellaneous 12 10,836,652 -258,424 10,578,228 Other Financing Sources 13 76,276,032 -12,258,478 64,017,554 Total Revenues and Other Sources 14 259,095,906 -28,248,215 230,847,691 Expenditures & Other Financing Uses 27,740,226 187,761 27,927,987 Public Safety 15 Public Works 16 12,772,031 221,835 12,993,866 Health and Social Services 17 1,200,814 -3,538 1,197,276 Culture and Recreation 18 11,463,595 30,903 11,494,498 Community and Economic Development 19 13,766,814 -213,239 13,553,575 General Govemment 20 7,776,357 -48,339 7,728,018 Debt Service 21 7,613,632 7,613,632 Capital Projects 22 84,453,140 -11,091,382 73,361,758 Total Govemment Activities Expenditures 23 166,786,609 -10,915,999 155,870,610 Business Type ( Enterprises 24 120,914,450 -16,986,260 103,928,190 Total Gov Activities & Business Expenditures 25 287,701,059 -27,902,259 259,798,800 Transfers Out 26 25,086,630 838,525 25,925,155 Total Expenditures/Transfers Out 27 312,787,689 -27,063,734 285,723,955 Excess Revenues & Other Sources Over (Under) ExpenditureslTransfers Out Fiscal Year 28 -53,691,783 -1,184,481 -54,876,264 29 Beginning Fund Balance July 1 30 76,411,104 76,411,104 Ending Fund Balance June 30 31 22,719,321 -1,184,481 21,534,840 Explanation of increases or decreases in revenue estimates, appropriations, or available cash: This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation to spend the monies. Adjustments to reflect the amended Community Development Annual Plan budget are included along with savings from completed or cancelled projects and available cash balance is used to fund increased operations. Reduction in Local Option Sales Tax Revenue and Gaming Revenue with offsetting operating and capital expense reductions. There will be no increase in tax levies to be paid in the current fiscal year named above. Any increase in expenditures set out above will be met from the increased non -property tax revenues and cash balances not budgeted or considered in this current budget. This will provide for a balanced budget. City Clerk! Finance Officer Name FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Program Description GENERAL FUND City -Wide 90 City -Wide 90 City -Wide 90 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 1C Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Police Department 10 Emergency Comm 10 Emergency Comm 1C Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Fire Department 10 Local Option Sales Tax DRA Rent DRA Distribution Police Patrol - Full -Time Wages Records - Full-time wages Records - !PERS Records - Social Security Records - Life Insurance Administration - Health Insurance Dare Program- Health Insurance Staff Services- Health Insurance Records And Id- Health Insurance Police Training- Health Insurance Criminal Investigation- Health Insurance Comm Orientated Police- Health Insurance Police Patrol- Health Insurance In -Car Video Recorders Computer Storage System Drug Task Force Car Storage Area Network (SAN) DLEC Battery Back -Ups Police Patrol - Education & Training FY2013 Jag Grant FY2013 Jag Grant FY2013 Jag Grant ICE & Financial Crimes Task Force Proceeds ICE & Financial Crimes Task Force Proceeds ICE & Financial Crimes Task Force Proceeds ICE & Financial Crimes Task Force Proceeds ICE & Financial Crimes Task Force Proceeds Mercy Emergency Room Security Mercy Emergency Room Security Emergency Comm. Center- Health Insurance 911 Center Needs Analysis Study Fire Suppression - Micro Computer FireSuppression - Furniture Fire Suppression - Mowing Equipment Fire Suppression - Confined Space Equipment Fire Suppression - Headsets Fire Administration- Health Insurance Fire Training- Health Insurance Ambulance- Health Insurance Fire Suppression- Health Insurance Fire Prevention- Health Insurance Fire Administration - Travel -Conferences Fire Administration - Travel -City Business Fire Administration - Education & Training -Captain FY 14 Expense Amount Page 1 FY 14 Revenue Amount Fund Activity/CIP Account Explanation (475,000) 100 10010100 41530 (805,311) 100 10079250 43262 (604,427) 100 10079250 43261 (328,824) 100 10011700 61010 (17,098) 100 10011220 61010 (1,527) 100 10011220 61310 (1,308) 100 10011220 61320 (34) 100 10011220 61416 6,782 100 10011100 61410 2,261 100 10011180 61410 12,245 100 10011190 61410 9,042 100 10011220 61410 2,261 100 10011250 61410 29,388 100 10011300 61410 31,649 100 10011500 61410 166,155 100 10011700 61410 (5,924) 101 1011580 73410 (7,785) 101 1011752 71125 (7,938) 101 1012456 71311 (13,992) 102 1022454 71120 (39,500) 102 1021751 71120 (41,118) 100 10011700 62360 26,580 100 10011762 44125 14,625 100 10011762 61051 11,955 100 10011600 72218 15,311 100 10011600 53605 41,150 100 10011600 53620 (2,000) 100 10011600 61051 (11,322) 100 10011600 62672 50,324 100 10011600 72218 36,819 100 10011715 53102 36,819 100 10011715 61051 24,867 100 10012100 61410 (10,340) 102 1022354 62716 (4,800) 100 10013400 71124 (2,240) 100 10013400 71156 (951) 100 10013400 71611 (2,028) 100 10013400 72114 (69) 100 10013400 72421 4,521 100 10013100 61410 2,261 100 10013200 61410 29,388 100 10013300 61410 162,764 100 10013400 61410 4,521 100 10013700 61410 (1,863) 100 10013100 62310 (320) 100 10013100 62320 (2,000) 100 10013100 62362 28 -Mar -14 Adjust to Actual Adjust to Actual Adjust to Actual Vacancy Savings FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Project Complete Project Complete Project Complete Project Complete FY14 Budget Reduction FY14 Budget Reduction Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Increased Health Contribution Project Complete FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Fire Department Human Rights Human Rights Human Rights Human Rights Human Rights Human Rights Health Services Health Services Health Services Multicultural Family Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Program Description 10 Fire Training - Education & Training 1C Assistant Fire Fighter Grant / Video Conference 1C Mobile Data/Wireless Network - Equipment Acquisition 1C Improvement to Station #4 - Construction 1C 900 MHZ Safety Data Radio 1C Station #4 Improvements 1C Improvements to Fire Headquarters 1C Station #4 Improvements 1C Ladder, Pumper, Ambulance Replacement 1C Station #4 Improvements 1C Ladder, Pumper, Ambulance Replacement 1C Station #4 Improvements 30 Human Relations- Health Insurance 30 Workforce Development- Health Insurance 30 Human Relations - Travel -Conferences 30 Human Relations - Travel -City Business 30 Human Relations - Education & Training 30 Workforce Development - Travel -Conferences 30 Health Services Administr- Health Insurance 30 Insp. - Food Estblmnts- Health Insurance 30 Community Health Serv.- Health Insurance 40 Multicultural Family Ctr- Health Insurance 40 Park Maintenance - Full-time wages 40 Park Maintenance- IPERS 40 Park Maintenance - Social Security 40 Park Maintenance - Life Insurance 40 Park Administration- Health Insurance 40 Forestry- Health Insurance 40 Park Patrol- Health Insurance 40 Park Areas & Maintenance- Health Insurance 40 Park Equipment Maint.- Health Insurance 40 Downtown Maintenance- Health Insurance 40 Greenhouse- Full-time wages 40 Greenhouse- IPERS 40 Greenhouse- Social Security 40 Greenhouse- Life Insurance 40 Greenhouse- Health Insurance 40 Technology Park Maint.- Health Insurance 40 Ind. Center West Maint.- Health Insurance 4C Greenhouse Ventilation System 4C Veterans Memorial Park Ball Field 4C Creekwood Park 4C Eagle Point Park Clear Trees on Bluff 4C Eagle Point Park Retaining Wall 4C Eagle Point Park Riverfront Pavilion 4C Eagle Point Park Stonework 4C Eagle Valley Park Development 4C Eagle Valley Park Development 4C Greenhouse Addition FY 14 Expense Amount (10,248) (40,800) 19,530 21,270 (38,000) 38,000 (3,921) 3,921 (10,629) 10,629 (13,051) 13,051 9,042 2,261 (3,970) (306) (12,685) (5,791) 1,695 4,521 565 2,261 (51,328) (4,583) (3,927) (103) 6,601 6,782 2,441 25,658 3,301 942 (4,621) (413) (354) (9) 4,702 1,243 1,537 (2,598) (10,212) (95,791) (15,000) (75,000) (94,282) (15,000) (5,770) (90,000) (85,173) Page 2 FY 14 Revenue Amount Fund Activity/CIP Account Explanation 100 10013200 62360 100 1002356 72416 102 1021755 73410 102 1021460 73410 101 1012355 72410 101 1011444 73210 101 1011139 73210 101 1011444 73210 101 1011016 71318 101 1011444 73210 102 1021016 71318 102 1021460 73210 100 10016100 61410 100 10016300 61410 100 10016100 62310 100 10016100 62320 100 10016100 62360 100 10016300 62310 100 10017100 61410 100 10017300 61410 100 10017400 61410 100 10034600 61410 100 10030400 61010 100 10030400 61310 100 10030400 61320 100 10030400 61416 100 10030100 61410 100 10030220 61410 100 10030300 61410 100 10030400 61410 100 10030420 61410 100 10030430 61410 100 10030500 61010 100 10030500 61310 100 10030500 61320 100 10030500 61416 100 10030500 61410 100 10030520 61410 100 10030530 61410 101 1012297 73210 102 1021214 73211 101 1012375 73211 102 1022460 73211 102 1022459 73211 102 1022190 73210 102 1021677 73211 102 1022288 62712 102 1022288 73211 102 1022104 73210 28 -Mar -14 FY14 Budget Reduction Shift to Mobile Data/Station #4 Shift from Video Conference Shift from Video Conference Shift to Station #4 Shift from 900 MHZ Safety Radios Shift to Station #4 Shift from Improvements to HQ's Shift to Station #4 Shift from Pumper Replacement Shift to Station #4 Shift from Pumper Replacement Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution Project Complete Project Complete FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Park Division Americorp Americorp Civic Center Civic Center Grand River Center Grand River Center Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Recreation Library Library Library Library Library Library Library Library Library Library Library Division Division Division Division Division Division Division Division Division Division Division Division Division Division Division Division Division Division Division Division Program Description 4C Highway 20 Roses Plan 4C Park Security Lights 4C Skate Park 4C Westbrook Park Development 4C Westbrook Park Development 4C Comiskey Park Siding - Construction 4C Comiskey Park New Entry- Construction 40 Park Administration - Travel -City Business 40 Park Administration - Education & Training 40 Forestry- Travel -City Business 40 Forestry- Education & Training 40 Greenhouse - Education & Training 40 Americorp 13/14- Health Insurance 40 Americorp Nongrant- Health Insurance 40 Civic Center Administrati- Health Insurance 4C Audio -Visual and Sound Equipment 6C Upgrade Audio -Visual Equipment 6C Floor Vacuums 40 POD Marina - Education & Training 40 POD Dock Maintenance - Education & Training 40 Recreation Admin.- Health Insurance 40 Golf Operations- Health Insurance 40 Golf Maintenance- Health Insurance 40 Swimming- Health Insurance 40 Adult Athletics- Health Insurance 40 Children Activites- Health Insurance 40 Therapeutic Activity- Health Insurance 40 Recreation Classes- Health Insurance 4C Bath House Improvements 4C Flora Waterslide Pump 4C Re -caulk Pool Decks 4C Renovate Recirculation Pumps 4C Surge Tank Repair 40 Recreation Administration - Travel -City Business 40 Golf Maintenance - Travel -Conferences 40 Golf Maintenance - Education & Training 40 Swimming - Education & Training 40 Adult Athletics - Education & Training 40 Library Admin- Health Insurance 40 Adult Services- Health Insurance 40 Children Services- Health Insurance 40 Circulation Services- Health Insurance 40 Maintenance Services- Health Insurance 40 Information Technology- Health Insurance 40 Technical Services- Health Insurance 40 Library Administration - Travel -Conferences 40 Library Administration - Education & Training 40 Speakers/Programs 40 Speakers/Programs FY 14 Expense Amount (21,000) (14,305) (70,000) (12,498) (83,680) 144 144 (450) (775) (150) (455) (45) 2,125 136 339 (617) (142) (266) (50) (50) 6,624 942 5,463 1,582 2,261 1,130 678 1,130 (7,500) (10,000) (12,140) (10,000) (15,000) (166) (460) (200) (729) (200) 4,521 13,564 6,782 4,521 4,521 2,261 6,782 (1,626) (1,000) 1,000 140 Page 3 FY 14 Revenue Amount 28 -Mar -14 Fund Activity/CIP Account Explanation 102 1021588 62712 FY14 Budget Reduction 102 1022368 73211 FY14 Budget Reduction 101 1012461 73211 FY14 Budget Reduction 101 1011582 62712 FY14 Budget Reduction 101 1011582 73211 FY14 Budget Reduction 102 1021151 73211 Shift from MCIC Improv. 102 1021544 73211 Shift to correct CIP 100 10030100 62320 FY14 Budget Reduction 100 10030100 62360 FY14 Budget Reduction 100 10030220 62320 FY14 Budget Reduction 100 10030220 62360 FY14 Budget Reduction 100 10030500 62360 FY14 Budget Reduction 100 10034910 61410 Increased Health Contribution 100 10034911 61410 Increased Health Contribution 100 10032100 61410 Increased Health Contribution 101 1012302 72419 Project Complete 102 1022389 72416 Project Complete 101 1012466 71110 Project Complete 100 10030550 62360 FY14 Budget Reduction 100 10030560 62360 FY14 Budget Reduction 100 10034100 61410 Increased Health Contribution 100 10034200 61410 Increased Health Contribution 100 10034250 61410 Increased Health Contribution 100 10034300 61410 Increased Health Contribution 100 10034400 61410 Increased Health Contribution 100 10034420 61410 Increased Health Contribution 100 10034430 61410 Increased Health Contribution 100 10034460 61410 Increased Health Contribution 102 1022172 73210 FY14 Budget Reduction 102 1021563 73211 FY14 Budget Reduction 102 1021098 73210 FY14 Budget Reduction 102 1021850 73211 FY14 Budget Reduction 102 1022463 73211 FY14 Budget Reduction 100 10034100 62320 FY14 Budget Reduction 100 10034250 62310 FY14 Budget Reduction 100 10034250 62360 FY14 Budget Reduction 100 10034300 62360 FY14 Budget Reduction 100 10034400 62360 FY14 Budget Reduction 100 10036100 61410 Increased Health Contribution 100 10036200 61410 Increased Health Contribution 100 10036210 61410 Increased Health Contribution 100 10036220 61410 Increased Health Contribution 100 10036300 61410 Increased Health Contribution 100 10036440 61410 Increased Health Contribution 100 10036500 61410 Increased Health Contribution 100 10036100 62310 FY14 Budget Reduction 100 10036100 62360 FY14 Budget Reduction 100 10036210 62734 Correct Budgeted Activity 100 10036210 62734 Correct Budgeted Activity FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Library Library Airport Airport Airport Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Building Services Building Services Building Services Building Services Building Services Building Services Building Services Building Services Building Services Building Services Building Services Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Program Description 40 Adult Services - Video Materials 40 Children Services - Video Materials 20 Airport Admin.- Health Insurance 20 FB0 Operation- Health Insurance 20 Airport Operations- Health Insurance 20 Administration- Health Insurance 20 Riverfront Managemnt.- Health Insurance 20 Floodwall Oper./Maint.- Health Insurance 20 St. & Traffic Ltng- Health Insurance 20 St. Signs & Markings- Health Insurance 20 Port Of Dub. Maintenance- Health Insurance 20 Street & Traffic Lighting - Education & Training 20 Riverfront Management - Shop Equipment 20 Riverfront Management- Mowing Equipment 20 Street Signs and Markings - Partitions 20 Street Signs and Markings - Shop Equipment 20 Engineering Traffic - Full-time Wages 20 Engineering Traffic - IPERS 20 Engineering Traffic - Social Security 20 Engineering Traffic - Life Insurance 20 Engineering Admin.- Health Insurance 20 Project Engineering- Health Insurance 20 Traffic Engineering- Health Insurance 2C Curb/Catch Basin 2C Downtown Street Light Replacement 2C Federal Building Renovation 2C Port of Dubuque Outdoor Plaza 2C Elm Complete Street 2C Elm Complete Street 2C Harbor Area Maintenance 2C Harbor Area Maintenance 10 Building Serv. Admin.- Health Insurance 10 Electrical Code Enf.- Health Insurance 10 Bldg. Code Enforse- Health Insurance 60 City Hall Maint.- Health Insurance 60 City Hall Annex Maint.- Health Insurance 60 Federal Building Maint.- Health Insurance 60 1157 Central Ave Maint.- Health Insurance 10 Plbg/Mech. Code Enf.- Health Insurance 1C Downtown ADA Assistance 10 Electrical Code Enforcement - Education & Training 10 Plumbing/Mechanical Code Enforcement - Education & Training 40 Arts & Cultural Affairs - Full-time wages 40 Arts & Cultural Affairs - IPERS 40 Arts & Cultural Affairs - Social Security 50 Economic Development- Health Insurance 50 Washington Neigh Develop- Health Insurance 5C Develop Standards 5C Develop Standards FY 14 Expense Amount 2,313 1,718 6,217 5,086 15,824 9,042 1,418 1,211 4,181 3,586 1,950 (1,800) (500) (23,000) (2,103) (361) (44,636) (3,986) (3,414) (87) 4,035 10,964 1,967 (10,824) (26,329) (40,000) (108,000) 600,000 Page 4 70,644 4,521 2,261 4,521 1,922 273 3,909 1,243 4,521 (5,000) (1,058) (1,083) (16,768) (1,353) (1,283) 6,782 2,261 (35,353) (15,000) FY 14 Revenue Amount Fund Activity/CIP Account Explanation 100 10036210 62659 100 10036201 62659 100 10051100 61410 100 10051200 61410 100 10051400 61410 100 10054100 61410 100 10054330 61410 100 10054340 61410 100 10054430 61410 100 10054435 61410 100 10054450 61410 100 10054430 62360 100 10054330 71410 100 10054330 71611 100 10054435 71124 100 10054435 71410 100 10055700 61010 100 10055700 61310 100 10055700 61320 100 10055700 61416 100 10055100 61410 100 10055400 61410 100 10055700 61410 102 1021041 73211 102 1021608 73410 102 1021841 62712 100 1001855 73211 100 1002502 73211 600,000 100 1002502 44145 70,644 102 1021466 53102 102 1021466 73211 100 10057100 61410 100 10057200 61410 100 10057400 61410 100 10057500 61410 100 10057510 61410 100 10057520 61410 100 10057540 61410 100 10057700 61410 102 1022424 73211 100 10057200 62360 100 10057700 62360 100 10072500 61010 100 10072500 61310 100 10072500 61320 100 10060700 61410 100 10060900 61410 100 1001207 62765 102 1021207 62765 28 -Mar -14 Lost Book Money Lost Book Money Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Economic Devlopmt Housing Housing Housing Housing Housing Housing Housing Housing Housing Housing Housing Housing Housing Housing Housing Housing Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Planning Services Personnel Office Personnel Office Budget Office Budget Office Public Information City Council City Council City Manager's Office City Manager's Office Program Description 40 Arts & Cultural Affairs - Travel -Conferences 50 Administration- Health Insurance 50 Health Homes Grant- Health Insurance 50 General Housing Insp.- Health Insurance 50 Circles- Health Insurance 5C Homeowner Grants Targeted Neigh 5C Homeowner Grants Targeted Neigh 50 General Housing Inspection - Auto/Jeep Replacement 5C Healthy Homes Grant 50 Bridges Out of Poverty 50 Bridges Out of Poverty 50 Bridges Out of Poverty 5C Lead Safe for Kids Grant 5C Lead Safe for Kids Grant 5C Lead Safe for Kids Grant 5C Neighborhood Stabilization Grant 5C Neighborhood Stabilization Grant 5C Downtown Design Guideline 50 Administration- Health Insurance 50 Development Services- Health Insurance 50 City Planning/Historic Pr- Health Insurance 5C Historic District Improvements 5C Historical/Architectural Surveys 50 Planning Administration - Travel -City Business 50 Planning Administration - Education & Training 50 Development Services - Travel -Conferences 50 Development Services - Travel -City Business 50 Development Services - Education & Training 50 City Planning/Historic Preservation - Travel -Conferences 50 City Planning/Historic Preservation - Travel -Conferences 50 City Planning/Historic Preservation - Education & Training 5C Downtown Design Guideline 5C Downtown Design Guideline 5C Downtown Design Guideline 5C Historic District Improvements 60 Personnel - Travel -Conferences 60 Personnel - Travel -City Business 60 Budget - Travel -City Business 60 Budget - Travel -City Business 60 Public Information/Gis- Health Insurance 60 Sister City Program 60 Reimbursements General 60 Management - Full-time Employee 60 Management - IPERS FY 14 Expense Amount (4,000) 565 4,521 5,380 2,261 (265,206) (28,151) (11,560) 7,240 (2,335) 2,580 255 3,125 46,875 Page 5 139,119 5,000 565 9,947 7,573 (4,673) (11,983) (4,127) (239) (597) (73) (341) (2,706) (178) (2,904) 4,015 25,055 3,690 (4,015) (875) (1,948) (4,000) (48) 2,261 610 (13,469) (1,203) FY 14 Revenue Amount Fund Activity/CIP Account Explanation 100 10072500 62310 100 10061100 61410 100 10061135 61410 100 10061700 61410 100 10061922 61410 101 1011595 62765 102 1021595 62765 100 10061700 71310 100 1002340 62764 100 10061920 62010 100 10061920 62140 100 10061920 62110 100 1002498 62761 100 1002498 62764 50,000 100 1002498 53102 139,119 100 1002180 54104 100 1002180 73210 100 1001860 62716 100 10062100 61410 100 10062400 61410 100 10062700 61410 102 1021010 73210 102 1022432 62716 100 10062100 62310 100 10062100 62360 100 10062400 62310 100 10062400 62320 100 10062400 62360 100 10062700 62310 100 10062700 62310 100 10062700 62360 100 1001860 62716 100 1001860 62716 100 1001860 62716 100 1001010 62711 100 10072700 62310 100 10072700 62320 100 10072400 62310 100 10072400 62320 100 10072300 61410 100 10070100 62662 610 100 10070100 53620 100 10072100 61010 100 10072100 61310 28 -Mar -14 FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Revenue Received in FY2013 Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Shift from Historic District Imp Shift from Historic District Imp Shift from Historic Tech Assist Shift to DT Design Guideline FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Adjust for Reimbursements Adjust for Reimbursements FY14 Budget Reduction FY14 Budget Reduction FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Program City Manager's Office 60 City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Manager's Office City Clerk's Office City Clerk's Office Finance Department Finance Department Finance Department Finance Department Finance Department Finance Department Finance Department Legal Services Information Services Information Services Information Services Information Services Information Services Information Services Information Services Description Management - Social Security 60 Management - Life Insurance 60 Management- Health Insurance 60 Sustainable Comm Coord- Health Insurance 60 Arts And Cultural Affairs- Health Insurance 60 Neighborhood Development- Health Insurance 6C Sustainability 60 Management - Travel -Conferences 60 Management - Education & Training 60 Sustainability- Travel -City Business 50 Neighborhood Development - Travel -Conferences 50 Neighborhood Development - Education & Training 60 Sustainability- Software 60 Sustainability 6C ESMS 6C ESMS 6C ESMS 6C EECBG 60 City Clerk- Health Insurance 60 City Clerk - Travel -Conferences 60 Acctng/Payroll/Treas- Health Insurance 60 Utility Bill/Parking Tkts- Health Insurance 6C Community Plus Upgrade 6C Finance Plus Upgrade 6C Finance Plus Upgrade 60 Financial Services - Travel -Conferences 60 Financial Services - Education & Training 60 Legal Services- Health Insurance 60 Information Services- Full-time Wages 60 Information Services- IPERS 60 Information Services- Social Security 60 Information Services- Life Insurance 60 Information Services- Health Insurance 60 Information Services - Travel -Conferences 60 Information Services - Education & Training TOTAL GENERAL FUND TRANSIT FUND Transit 8C Transit 8C Transit 80 Transit 80 Transit 80 Transit 80 Transit 8C Transit 80 Transit 8C Transit 8C Transit Roof Maintenance/Repair Transit Fuel Station Transit Administration Bus Operations- Health Insurance Mini Bus Operations- Health Insurance Bus Maintenance- Health Insurance Transit Fuel Station Transit Administration Transit Roof Maintenance/Repair Transit Fuel Station TOTAL TRANSIT FUND FY 14 Expense Amount (1,030) (27) 13,225 2,261 226 723 (8,700) (11,710) (6,000) (3,918) (688) (662) (15,000) (35,000) 20,000 14,500 500 92,645 6,782 (1,900) 13,149 17,181 (30,000) (2,448) (7,987) (1,500) (1,000) 10,173 (39,651) (3,541) (3,033) (79) 17,678 (721) (1,830) FY 14 Revenue Amount (242,423) (904,505) 12,800 (17, 800) 112,731 14,317 4,521 2,261 (6,000) 112,731 14,290 (11,800) Page 6 130,320 107,731 28 -Mar -14 Fund Activity/CIP Account Explanation 100 10072100 61320 FY14 Budget Reduction 100 10072100 61416 FY14 Budget Reduction 100 10072100 61410 Increased Health Contribution 100 10072200 61410 Increased Health Contribution 100 10072500 61410 Increased Health Contribution 100 10072800 61410 Increased Health Contribution 102 1022218 62716 FY14 Budget Reduction 100 10072100 62310 FY14 Budget Reduction 100 10072100 62360 FY14 Budget Reduction 100 10072200 62310 FY14 Budget Reduction 100 10072800 62310 FY14 Budget Reduction 100 10072800 62360 FY14 Budget Reduction 100 10072200 71123 FY14 Budget Reduction 100 10072200 71123 Shift to ESMS 100 1002496 62360 Shift from Sustainability 100 1002496 62320 Shift from Sustainability 100 1002496 62030 Shift from Sustainability 100 1002338 62716 Adjust to Actual 100 10073100 61410 Increased Health Contribution 100 10073100 62310 FY14 Budget Reduction 100 10074100 61410 Increased Health Contribution 100 10074700 61410 Increased Health Contribution 102 1022053 71123 Project Complete 100 1002166 71123 Project Complete 100 1002166 71123 Project Complete 100 10074100 62310 FY14 Budget Reduction 100 10074100 62360 FY14 Budget Reduction 100 10076100 61410 Increased Health Contribution 100 10077100 61010 FY14 Budget Reduction 100 10077100 61310 FY14 Budget Reduction 100 10077100 61320 FY14 Budget Reduction 100 10077100 61416 FY14 Budget Reduction 100 10077100 61410 Increased Health Contribution 100 10077100 62310 FY14 Budget Reduction 100 10077100 62360 FY14 Budget Reduction 600 6001613 45701 600 6002486 45701 600 60053100 45771 600 60053400 61410 600 60053500 61410 600 60053700 61410 600 6002486 62712 600 60053100 62761 600 6001613 73210 600 6002486 73211 Adjust to Actual Adjust to Actual Adjust to Actual Increased Health Contribution Increased Health Contribution Increased Health Contribution Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Program Description DUBUQUE INDUSTRIAL CENTER TIF FUND Economic Devlopmt 70 Debt Service- Principal Economic Devlopmt 70 Debt Service - Interest TOTAL DUBUQUE INDUSTRIAL CENTER 71F FUND TECHNOLOGY PARK 71F FUND Economic Devlopmt Economic Devlopmt 70 Debt Service- Principal 70 Debt Service - Interest TOTAL TECHNOLOGY PARK TIF FUND GREATER DOWNTOWN TIF FUND Library Library Parking Parking Economic Devlopmt Economic Devlopmt 70 Debt Service- Principal 70 Debt Service - Interest 70 Debt Service- Principal 70 Debt Service - Interest 70 Debt Service- Principal 70 Debt Service - Interest TOTAL GREATER DOWNTOWN TIF FUND ROAD USE TAX FUND Public Works 20 Street Maintenance - Full-time Wages Public Works 20 Street Maintenance - !PERS Public Works 20 Street Maintenance - Social Security Public Works 20 Street Maintenance- Health Insurance Public Works 20 Street Cleaning- Health Insurance Public Works 20 Snow & Ice Control- Health Insurance Public Works 20 Street Maintenance - Life Insurance Public Works 20 Snow and Ice Control - Salt Purchase Engineering 2C LED Re -Lamp Schedule TOTAL ROAD USE TAX FUND COMMUNITY DEVELOPMENT BLOCK GRANT FUND Housing Housing Housing Housing Housing Housing City Manager's Office Housing Housing Housing City Manager's Office Engineering Engineering 50 CDBG Housing Inspection - Auto/Jeep Replacement 50 CDBG Monitoring - CDBG Grant 50 Administration- Health Insurance 50 Rehab. Program- Health Insurance 50 General Housing Insp.- Health Insurance 50 Cdbg Admin/Monitoring- Health Insurance 50 Neighborhood Development- Health Insurance 50 Housing Administration - Supplies 5C First Time Homebuyer Program 5C Rental Unit Rehab 5C Neighborhood Support Grants 2C Accessible Curb Ramps 2C Neighborhood Infrastructure Improvements TOTAL CDBG FUND FY 14 Expense Amount (1,295,171) (530,974) FY 14 Revenue Amount (1,826,145) (188,603) (30,958) (219,561) (151,725) (74,156) (355,000) (1,657,875) (553,626) (459,647) (3,252,029) (4,199) (375) (321) 36,935 9,349 13,375 (8) 181,485 (10,000) 226,241 28 -Mar -14 Fund Activity/CIP Account Explanation 210 21060210 74111 Correct Budgeted Activity 210 21060210 74112 Correct Budgeted Activity 225 22560225 74111 Correct Budgeted Activity 225 22560225 74112 Correct Budgeted Activity 240 24036240 74111 240 24036240 74112 240 24046350 74111 240 24046350 74112 240 24060240 74111 240 24060240 74112 250 25054400 61010 250 25054400 61310 250 25054400 61320 250 25054400 61410 250 25054410 61410 250 25054420 61410 250 25054400 61416 250 25054420 62640 250 2501916 73411 (5,440) 260 26061700 71310 31,331 260 26061800 44205 1,130 260 26061100 61410 9,042 260 26061300 61410 4,114 260 26061700 61410 2,261 260 26061800 61410 1,311 260 26072800 61410 30 260 26061100 62010 31,316 260 2601234 62764 (31,316) 260 2601233 62764 2,667 260 2601238 62765 34,584 260 2601236 73211 10,000 260 2601239 73211 Page 7 59,699 31,331 Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Increased Health Contribution Increased Health Contribution Increased Health Contribution FY14 Budget Reduction Adjust to Actual Shift to Traffic Signal Intersect FY14 Budget Reduction CDBG Amend #2 Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution CDBG Amend #2 CDBG Amend #2 CDBG Amend #2 CDBG Amend #2 CDBG Amend #2 CDBG Amend #2 FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department LEAD PAI NT GRANT Housing Housing Housing Housing Housing Housing Housing Program Description FUND 5C Lead Hazard Control Grant 5C Lead Hazard Control Grant 50 Lead Paint Abatement 2011 50 Lead Paint Abatement 2011 50 Lead Paint Abatement 2011 50 Lead Paint Abatement 2011- Health Insurance 5C Lead Hazard Control Grant TOTAL LEAD PAINT GRANT FUND SECTION 8 FUND Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 Housing 50 CABLE TV FUND Health Services 30 Public Information 60 City Manager's Office 60 Cable TV 60 Information Services 60 Section 8 Voucher Section 8 Voucher Moderate Rehab - 005 Section 8 Voucher Voucher HAP Section 8 Voucher Voucher HAP Administration- Health Insurance Section 8 Voucher- Health Insurance Voucher HAP Section 8 Voucher Voucher HAP Section 8 Voucher Voucher HAP Section 8 Voucher Voucher HAP Voucher HAP Section 8 Voucher Voucher HAP Moderate Rehab - 005 Section 8 Voucher Voucher HAP FSS Program Voucher TOTAL SECTION 8 FUND Health Services Administr- Health Insurance Public Information- Health Insurance Management- Health Insurance Cable TV- Health Insurance Information Services- Health Insurance TOTAL CABLE TV FUND STREET CONSTRUCTION FUND City -Wide 9C Local Option Sales Tax Engineering 2C Southwest Arterial - Investment Earnings Engineering 2C Southwest Arterial - Land Rent Engineering 2C Southwest Arterial - Federal Aid FY 14 Expense Amount 6,782 146,777 FY 14 Revenue Amount Fund Activity/CIP Account Explanation 444,419 29,325 (444,419) 35,758 2,000 153,559 565 24,415 38,178 (97,141) 112,360 (16,901) 58,392 1,361 54,027 54,027 (3,000) 3,000 (14,633) (3,762,275) 3,273,418 25,458 67,083 (59,709) 3,050 (6,067) (3,879,317) 3,589, 458 (137, 975) 54,027 (248,749) (436,533) Page 8 1,130 2,261 339 4,521 407 8,658 (285,000) 2,046 18,453 (7,700, 257) 275 2752429 44310 275 2752429 44310 275 27561211 44310 275 27561211 53605 275 27561211 53625 275 27561211 61410 275 2752429 62764 280 28061600 44215 280 28061600 44220 280 28061530 44310 280 28061600 44310 280 28061601 44310 280 28061600 44311 280 28061601 44325 280 28061100 61410 280 28061600 61410 280 28061601 62607 280 28061600 62608 280 28061601 62608 280 28061600 62609 280 28061601 62609 280 28061600 62610 280 28061601 62688 280 28061601 62688 280 28061600 62689 280 28061601 62689 280 28061530 62694 280 28061600 62694 280 28061601 62694 280 28061601 62774 290 29017100 61410 290 29072300 61410 290 29072100 61410 290 29075100 61410 290 29077100 61410 28 -Mar -14 Shift from Lead Paint Abate 2011 Adjust to Actual Shift to Lead Hazard Control Grant Adjust to Actual Adjust to Actual Increased Health Contribution Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Increased Health Contribution Increased Health Contribution Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution 300 30010300 41530 Adjust to Actual 300 3001287 43110 Adjust to Actual 300 3001287 43242 Adjust to Actual 300 3001287 44145 Adjust to Actual FISCAL YEAR 2014 AMENDMENT#2 Department Engineering Engineering Engineering Engineering Engineering Engineering Engineering Public Works Engineering Engineering Engineering Engineering Engineering Public Works Public Works Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Engineering Program Description 2C North Cascade Road - DMATS STP Funds 2C Cedar Cross Road - DMATS STP Funds 2C Southwest Arterial - Federal Pass-Thru 2C Southwest Arterial - County Contribution 2C Southwest Arterial - Miscellaneous Revenue 2C Southwest Arterial - Consulting 2C SW Arterial Capacity Improvements 2C Concrete Section Repairs 2C Crosswalk Warning Devices 2C Painting Street Lights/Signals 2C Traffic Signal Innerconnect Conduit Replacement 2C Traffic Signal Mastarm Retrofit 2C Southwest Arterial - Land Acquisition 2C Concrete Section Repairs 2C Curb Replacement 2C Cedar Cross Road - Construction 2C North Cascade Road - Construction 2C Southwest Arterial - Construction 2C Southwest Arterial - Construction 2C Cedar Cross Street Lighting 2C Crosswalk Warning Devices 2C Green Alley Project 2C Guard Rail Replacement 2C LED Streetlight Retrofit 2C Portable Radar Speed Sign 2C Stone Retaining Walls 2C Street Light Replacement 2C Street Light/Signal Knockdown 2C Sub -Divisions Sub Drains 2C Traffic Signal Intersection Reconstruction 2C Traffic Optic Conduit -Paving Projects 2C Traffic Signal Intersection Reconstruction 2C Traffic Signal Mastarm Retrofit 2C Traffic Signal Intersection Reconstruction 2C Street Light Replacement/New City Owned 2C Traffic Signal Intersection Reconstruction 2C Signalization Program 2C Traffic Signal Intersection Reconstruction 2C Traffic Signal Intersection Reconstruction 2C School Zone Countdown Signals 2C Surge and Grounding Improvements 2C Traffic Operations Center Test Bench TOTAL STREET CONSTRUCTION FUND SALES TAX FUND (20%) City -Wide 9C Grand River Center 4C Grand River Center 4C Planning Services 5C Local Option Sales Tax Outdoor Sign Wall Coverings Riverfront 2000 Plan FY 14 Expense Amount (3,989,834) (25,000) (5,000) (2,000) (3,238) (10,000) (5,000) (2,168,331) (18,504) (10,000) (340,433) 340,433 (3,793,461) 20,511 (16,001) (23,000) (30,000) (20,000) (5,000) (10,624) (49,752) (15,000) (10,000) (150,000) 10,000 (8,946) 8,946 (76,101) 81,101 (10,000) 10,000 (18,770) 18,770 10,000 (4,000) (5,000) (24,532) COUNCIL DETAIL FY 14 Revenue Amount Fund Activity/CIP Account Explanation 340,433 300 3002021 45725 (340,433) 300 3002139 45725 (351,635) 300 3001287 45771 (1,157,758) 300 3001287 46205 12 300 3001287 53605 300 3001287 62712 300 3002247 62712 300 3001006 62811 300 3002246 62811 300 3001917 62811 300 3001266 62811 300 3001133 62811 300 3001287 73110 300 3001006 73211 300 3001226 73211 300 3002139 73211 300 3002021 73211 300 3001287 73211 300 3001287 73211 300 3002326 73211 300 3002246 73211 300 3002044 73211 300 3001027 73211 300 3002484 73211 300 3002257 73211 300 3001029 73211 300 3001549 73211 300 3002252 73211 300 3002023 73211 300 3001615 73211 300 3001017 73211 300 3001615 73211 300 3001133 73211 300 3001615 73211 300 3001549 73211 300 3001615 73211 300 3001011 73211 300 3001615 73211 300 3001615 73211 300 3002328 73410 300 3002420 73410 300 3002485 73410 (10,347,766) (9,474,139) (190,000) 6,120 Page 9 (2,125) (5,000) 28 -Mar -14 Shift from Cedar Cross Shift to North Cascade Adjust to Actual Adjust to Actual Adjust to Actual Adjust to Actual FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Shift to Traffic Signal Intersect Shift to Traffic Signal Intersect Adjust to Actual FY14 Budget Reduction FY14 Budget Reduction Shift to North Cascade Shift from Cedar Cross Adjust to Actual Investment Income/Land Rent FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Shift from Traffic Signal Conduit Shift to Traffic Signal Intersect Shift from Traffic Optic Condiut Shift to Traffic Signal Intersect Shift from Traffic Signal Mastarmn Shift to Traffic Signal Intersection Shift from Street Light Replacement Shift to Traffic Signal Intersect Shift from Signalization Program Shift from LED Re -Lamp Schedule FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction 350 35010350 41530 Adjust to Actual 350 3502388 53620 Adjust to Actual 350 3502112 62712 FY14 Budget Reduction 350 3501015 62712 FY14 Budget Reduction FISCAL YEAR 2014 AMENDMENT#2 Department Park Division Park Division Park Division Park Division Grand River Center Recreation Division Engineering Building Services Park Division Park Division Civic Center Grand River Center Public Works Engineering Engineering Park Division Public Works GENERAL CONST Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Recreation Division Recreation Division Recreation Division Recreation Division Recreation Division Planning Services Building Services Program Description 4C Ecological Restoration 4C McAlleece Replace Plumging 4C Eagle Point Park Paint Pavilions 4C McAleece French Drains 4C Wall Coverings 4C Flora & Sutton Storage Building 2C Accessibility Barriers 6C City Hall Remodel 4C Pet Park 4C Riverwalk Baskets — Irrigate 4C Seal Concrete Walkways 4C Outdoor Sign 2C Ice Harbor Gates Timber 2C Decorative Concrete Barriers 2C Stone Retaining Walls 4C Ecological Restoration 2C Port Amenities Maintenance TOTAL SALES TAX FUND RUCTION FUND 5C 5C 5C 5C 5C 5C 4C 4C 4C 4C 4C 5C 6C DEBT SERVICE FUND Library Library Parking Parking Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Economic Devlopmt Washington Neighborhood Downtown Incentives - Bond Washington Neighborhood Downtown Incentives - Bond Future Industrial Acquisitions - Consultant Services Washington Neighborhood Downtown Incentives - Grants Future Industrial Acquisitions - Consultant Services Washington Neighborhood Downtown Incentives - Grants MCIC A/C MCIC Ice Decking MCIC Electrical Improvements MCIC Generator MCIC Power Factor Historic District Improvements ADA Restroom TOTAL GENERAL CONSTRUCTION FUND 70 Debt Service- Principal 70 Debt Service - Interest 70 Debt Service- Principal 70 Debt Service - Interest 70 Debt Service- Principal 70 Debt Service - Interest 70 Debt Service- Principal 70 Debt Service - Interest 70 Debt Service- Principal 70 Debt Service - Interest TOTAL DEBT SERVICE FUND FY 14 Expense Amount (10,000) (2,492) (25,000) (10,000) (5,138) (7,756) (50,000) (89,799) (94,308) (12,000) (4,000) 6,120 (18,958) (20,000) (11,218) (10,000) (6,313) FY 14 Revenue Amount (377,987) (183,880) (107,616) (1,499,576) 107,616 1,499,576 (75,226) (6,392) (29,060) (91,198) (10,099) (25,055) 89,799 Fund 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 350 (750,000) 360 750,000 360 360 360 360 360 360 360 360 360 360 360 360 (147,231) 151,725 74,156 355,000 1,657,875 553,626 459,647 1,295,171 530,974 188,603 30,958 5,297,735 Page 10 400 400 400 400 400 400 400 400 400 400 COUNCIL DETAIL Activity/CIP 3502367 3502361 3502358 3502360 3502112 3501090 3501034 3501045 3501978 3501937 3502303 3502388 350222 3501630 3501029 3502367 3502038 3602436 3602438 3602436 3602436 3602437 3602438 3602383 3602385 3602384 3602386 3602387 3601010 3602425 40036600 40036600 40046350 40046350 40060910 40060910 40060930 40060930 40060920 40060920 Account Explanation 71310 FY14 Budget Reduction 73210 Project Complete 73210 FY14 Budget Reduction 73210 FY14 Budget Reduction 73210 FY14 Budget Reduction 73210 FY14 Budget Reduction 73210 FY14 Budget Reduction 73210 Shift to ADA Restroom 73211 FY14 Budget Reduction 73211 FY14 Budget Reduction 73211 FY14 Budget Reduction 73211 Adjust to Actual 73211 Project Complete 73211 FY14 Budget Reduction 73211 FY14 Budget Reduction 73310 FY14 Budget Reduction 73510 FY14 Budget Reduction 54210 54210 62765 62765 62765 62765 73210 73210 73210 73210 73210 73210 73211 74111 74112 74111 74112 74111 74112 74111 74112 74111 74112 28 -Mar -14 Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction FY14 Budget Reduction Shift to DT Design Guideline Shift from City Hall Remodel Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity Correct Budgeted Activity FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL 28 -Mar -14 FY 14 FY 14 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation WATER & RESOURCE RECOVERY CENTER OPERATING FUND WRRC 80 WRRC Administration- Health Insurance 2,261 610 61043100 61410 Increased Health Contribution WRRC 80 WRRC Plant Operations- Health Insurance 31,649 610 61043400 61410 Increased Health Contribution WRRC 80 Environ -Monitoring- Health Insurance 6,782 610 61043700 61410 Increased Health Contribution Public Works 80 San- Sewer Mntnce- Health Insurance 12,548 610 61054300 61410 Increased Health Contribution Engineering 80 Project Engineering- Health Insurance 2,261 610 61055400 61410 Increased Health Contribution TOTAL WATER & RESOURCE RECOVERY CENTER 55,501 - STORMWATER OPERATING FUND Park Division 80 Storm Area Maintenance- Health Insurance 859 620 62030440 61410 Increased Health Contribution Public Works 80 Storm Sewer Maint- Health Insurance 4,513 620 62054310 61410 Increased Health Contribution Engineering 80 Stormwater Utility O&Amp;M- Health Insurance 2,374 620 62055620 61410 Increased Health Contribution TOTAL STORMWATER OPERATING FUND 7,746 - PARKING OPERATING FUND Parking 80 Locust Street Ramp- Health Insurance 4,883 630 63046300 61410 Increased Health Contribution Parking 80 Iowa Street Ramp- Health Insurance 4,137 630 63046310 61410 Increased Health Contribution Parking 80 5Th Street Ramp- Health Insurance 2,464 630 63046320 61410 Increased Health Contribution Parking 80 Five Flags Ramp- Health Insurance 1,876 630 63046330 61410 Increased Health Contribution Parking 80 10Th & Central Ramp- Health Insurance 1,695 630 63046360 61410 Increased Health Contribution Parking 80 Parking Lots- Health Insurance 769 630 63046400 61410 Increased Health Contribution Parking 80 St. Parking Meters- Health Insurance 2,261 630 63046420 61410 Increased Health Contribution TOTAL PARKING OPERATING FUND 18,085 WATER OPERATING FUND Water 80 Water Adminstration- Health Insurance 6,782 640 64042100 61410 Increased Health Contribution Water 80 Meters- Health Insurance 6,782 640 64042300 61410 Increased Health Contribution Water 80 Plant Oper. & Maint- Health Insurance 24,867 640 64042400 61410 Increased Health Contribution Water 80 Water Distr. System- Health Insurance 20,345 640 64042700 61410 Increased Health Contribution Water 80 Meter Reads/Service- Health Insurance 3,203 640 64074710 61410 Increased Health Contribution TOTAL WATER OPERATING FUND 61,979 REFUSE FUND Public Works 80 Refuse Collection- Health Insurance 23,049 670 67054500 61410 Increased Health Contribution Public Works 80 Yard Waste Collection- Health Insurance 2,672 670 67054510 61410 Increased Health Contribution Public Works 80 Large Item Collection- Health Insurance 337 670 67054520 61410 Increased Health Contribution Public Works 80 Recycling Coll. Prog.- Health Insurance 19,155 670 67054530 61410 Increased Health Contribution TOTAL REFUSE FUND 45,213 SANITARY SEWER CONSTRUCTION FUND Public Works 8C Sewer -Cleaning Jet Flusher Unit 42,490 710 7102405 71550 Adjust to Actual TOTAL SANITARY SEWER CONST FUND 42,490 STORM WATER CONSTRUCTION FUND Engineering 8C Bee Branch - State Grants - (3,840,858) 720 7201654 45701 Adjust to Actual Engineering 8C Bee Branch - State Highway Assistance - (700,000) 720 7201654 45725 Adjust to Actual Engineering 8C Bee Branch - Land Sales (300,000) 720 7201654 54105 Adjust to Actual Engineering 8C Bee Branch - GO Bonds (10,052,739) 720 7201654 54210 Adjust to Actual Engineering 8C Bee Branch - SRF Loan (2,883,383) 720 7201654 54230 Adjust to Actual Engineering 8C Bee Branch - Consultant Services 1,617,955 720 7201654 62712 Adjust to Actual Engineering 8C Bee Branch - Land Acquisition 1,493,014 720 7201654 73111 Adjust to Actual Page 11 FISCAL YEAR 2014 AMENDMENT#2 COUNCIL DETAIL Department Engineering Program Description 8C Bee Branch - Construction TOTAL STORM WATER CONST FUND ENGINEERING INTERNAL SERVICE FUND Engineering 80 Engineering Admin.- Health Insurance Engineering Engineering Engineering Engineering 80 Project Engineering- Health Insurance 80 Sanitary Sewer Int Serv- Health Insurance 80 Stormwater Utility O&M- Health Insurance 80 Traffic Engineering- Health Insurance TOTAL ENGINEERING INTERNAL SERVICE FUND GARAGE INTERNAL SERVICE FUND Public Works 80 Public Works Garage- Health Insurance TOTAL GARAGE INTERNAL SERVICE FUND GENERAL SERVICES INTERNAL SERVICE FUND Public Works 80 Street Maintenance- Health Insurance TOTAL GENERAL SERVICES INTERNAL SERVICE FUND LANDFILL FUND Public Works 80 Public Works 80 Public Works 80 Public Works 80 Public Works 80 Public Works 80 TRANSFERS Fire Department Fire Department Public Works Housing Grand River Center Engineering Building Services Planning Services Park Division Park Division Planning Services Fire Department Park Division Park Division Public Works Housing Engineering Grand River Center Building Services Tran s1 Transl Trans5 Trans8 Trans4 Trans6 Trans7 Trans9 Trans2 Trans3 Trans9 Transl Trans2 Trans3 Trans5 Trans8 Trans6 Trans4 Trans7 Landfill- Health Insurance Composting Landfill- Health Insurance Household Haz. Mat. R.C.C- Health Insurance E -Waste- Health Insurance Rural Recycling- Health Insurance Landfill Gas System- Health Insurance TOTAL LANDFILL FUND Transfer from General Fund to DRA Distribution Fund Transfer from General Fund to DRA Distribution Fund Transfer from General Fund to Road Use Tax Fund Transfer from General Fund to Section 8 Fund Transfer from DRA Distribution to Sales Tax Const Fund Transfer from Road Use Tax to Street Construction Transfer from Sales Tax Construction to General Construction Transfer from General Const. Fund to General Fund Transfer from General Const. Fund to DRA Distribution Fund Transfer from General Const. Fund to DRA Distribution Fund Transfer from General Const. Fund to General Fund Transfer from General Fund to DRA Distribution Fund Transfer from General Const. Fund to DRA Distribution Fund Transfer from General Const. Fund to DRA Distribution Fund Transfer from General Fund to Road Use Tax Fund Transfer from General Fund to Section 8 Fund Transfer from Road Use Tax to Street Construction Transfer from DRA Distribution to Sales Tax Const Fund Transfer from Sales Tax Construction to General Construction FY 14 FY 14 Expense Revenue Amount Amount (20,557,950) (17,446,981) (17,776,980) 6,138 18,695 6,217 16,005 294 47,349 Fund Activity/CIP Account Explanation 720 7201654 73211 Adjust to Actual 800 800 800 800 800 80055100 80055400 80055610 80055620 80055700 61410 61410 61410 61410 61410 28 -Mar -14 Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution 27,127 810 81054600 61410 Increased Health Contribution 27,127 47 47 20,210 782 1,187 1,026 338 1,321 24,864 Transfer Out 25,055 40,800 11,975 200,000 181,485 51,677 10,000 227,734 89,799 Transfer In 21,270 19,530 181,485 51,677 227,734 10,000 89,799 25,055 11,975 200,000 838,525 838,525 (27,063,734) (27,731,367) Page 12 820 82054400 61410 Increased Health Contribution 940 940 940 940 940 940 102 102 250 280 350 300 360 100 102 102 360 100 360 360 100 100 250 102 350 94054200 94054210 94054220 94054240 94054250 94054260 1021460 1021755 25054420 28010280 3501991 3001615 3602425 1001860 1021151 1022292 36010360 10010100 36010360 36010360 10010100 10010100 25010250 10210102 35010350 61410 61410 61410 61410 61410 61410 59100 59100 59100 59100 59102 59250 59350 59360 59360 59360 91100 91102 91102 91102 91250 91280 91300 91350 91360 Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Increased Health Contribution Trans Funds Trans Funds Transfer Funds Transfer Funds Trans Funds Trans Funds Trans Funds Transfer Funds Trans Funds Trans Funds Transfer Funds Trans Funds Trans Funds Trans Funds Transfer Funds Transfer Funds Trans Funds Trans Funds Trans Funds