Loading...
Fiscal Year 2017 Second Budget Amendment_Hearing Copyrighted March 20, 2017 City of Dubuque Public Hearings # 8. ITEM TITLE: Fiscal Year 2017 Second Budget Amendment SUMMARY: Proof of publication on notice of public hearing to consider approval of the Fiscal Year 2017 Second Budget Amendment. RESOLUTION Amending the current budget for the Fiscal Year Ending June 30, 2017 as amended last on September 19, 2016. SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt Resolution(s) ATTACHMENTS: Description Type MVM Memo City Manager Memo Staff Memo Staff Memo FY17 Amendment 2 Detail Supporting Documentation Resolution Resolutions Proof of Publication Supporting Documentation THE CITY OF Dubuque U E I erica .i Masterpiece on the Mississippi 2007-2012-2013 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2017 Second Budget Amendment DATE: March 7, 2017 Budget Director Jennifer Larson is recommending approval of the second Fiscal Year 2017 Budget Amendment, which amends the Fiscal Year 2017 budget for City Council actions since the first amendment to the Fiscal Year 2017 budget was adopted in September 2016 and adjustments to reflect the amended Community Development Annual Plan. The amendment totals $20,880,969 in increased appropriation authority and an increase in resources of $21,937,236. This amendment increases the debt service appropriation authority by $19,447,854 for the refunding bonds being sold at the March 20, 2017 City Council meeting. This refunding will provide an estimated $1.2 million in interest savings over the life of the bonds. There is an estimated shortfall in Dubuque Racing Association rent revenue of $258,649, a shortfall in Dubuque Racing Association Distribution of $284,961, and an estimated shortfall in local option sales tax of $372,860 based on actual year-to-date receipts and updated projections. This shortfall in gaming revenue and local option sales tax is covered by property insurance savings from negotiating a new contract ($50,835); employee vacancy savings ($221,877); vehicle replacement delays in health inspections, park patrol and greenhouse ($80,700); farmland rent of recently purchased land in Dubuque Industrial Center ($43,608); increased wharfage revenue ($75,000), increased building permit revenue ($46,000); canceled capital projects including fiber optics to the airport which is a completed project ($135,620) and crosswalk warning devices ($31,000); and uncommitted cash balance in the DRA gaming capital fund ($231,830). In addition, sanitary user fees are estimated to be $100,762 less than budget. The reduction in sanitary user fees revenue is covered by reducing operating expenses related to major repair element, oxygen plant maintenance, landfill fees, laboratory equipment, and education and training ($108,476). I concur with the recommendation and respectfully request Mayor and City Council approval. Michael C. Van Milligen MCVM/jml Attachment cc: Crenna Brumwell, City Attorney Cindy Steinhauser, Assistant City Manager Teri Goodmann, Assistant City Manager Jennifer Larson, Budget Director THE CITY OF Dubuque U E I erica .i Masterpiece on the Mississippi 2007-2012-2013 TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Budget Director SUBJECT: Fiscal Year 2017 Second Budget Amendment DATE: March 7, 2017 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 2017 budget was adopted in September 2016 and adjustments to reflect the amended Community Development Annual Plan. This amendment also reflects reappropriations of completed or canceled projects to fund increased operating and capital expenses. An increase of interfund transfers of $505,021 is also included. The amendment totals $20,880,969 in increased appropriation authority and an increase in resources of $21,937,236. Additional revenues added in this amendment with offsetting appropriations are: • Stormwater General Obligation Bond Refunding Series 2017A ($2,056,736), • Parking General Obligation Bond Refunding Series 2017B ($6,520,000), • Sanitary General Obligation Bond Refunding Series 2017A ($666,592), • Refuse General Obligation Bond Refunding Series 2017A ($52,597), • Greater Downtown Tax Increment Financing General Obligation Bond Refunding Series 2017A, 2017B and 2017C ($4,500,000), • Dubuque Industrial Center West Tax Increment Financing General Obligation Bond Refunding Series 2017B ($1,310,000), • Iowa Finance Authority Caradco Loan Additional Principal Payment from Developer ($500,000), • Airport General Obligation Bond Refunding Sales Tax (20%) Series 2017A ($291,860), • Public Works General Obligation Bond Refunding Road Use Tax Series 2017A ($405,606), • Engineering General Obligation Bond Refunding Greater Downtown TIF/Sales Tax/RUT Series 2017A ($3,597,483), • Building General Obligation Bond Refunding Series 2017A ($46,980), • HUD Resiliency Grant Appropriations for Program costs ($350,000), • DMATS Allocation for Southwest Arterial ($1 ,060,389), • Brownfield Grant Appropriation for Flood Control Maintenance Facility ($200,000), • DMATS Allocation for Traffic Signalization ($78,966), • Lead Hazard Federal Grant ($20,000), and • Community Development Block Grant ($672,357) for various programs due to uncommitted funds available. Reduced revenues reflected in this amendment with offsetting reductions in appropriations are: • Local Option Sales Tax (-$372,860) based on actual year-to-date receipts and estimates from the State of Iowa; • Dubuque Racing Association Rent Revenue (-$258,649) based on actual year-to- date revenue and updated projections from the DRA, • Dubuque Racing Association Distribution (-$284,961) based on the actual distribution received from the DRA in January 2017, and • Sanitary User Fees revenue (-$100,762) based on actual year-to-date and projected revenue. This shortfall in gaming revenue and local option sales tax is covered by property insurance savings from negotiating a new contract ($50,835); employee vacancy savings ($221 ,877); vehicle replacement delays in health inspections, park patrol and greenhouse ($80,700); farmland rent of recently purchased land in Dubuque Industrial Center ($43,608); increased wharfage revenue ($75,000), increased building permit revenue ($46,000); canceled capital projects ($166,620); and uncommitted cash balance in the DRA gaming capital fund ($231 ,830). The reduction in sanitary user fees revenue is covered by reducing operating expenses related to major repair element, oxygen plant maintenance, landfill fees, laboratory equipment, and education and training ($108,476). The action step is for City Council to adopt the attached resolution approving the Fiscal Year 2017 second budget amendment. Attachments JML 2 31 -288 CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION - FY 2017 - AMENDMENT #2 To the Auditor of • DUBUQUE County, Iowa: The City Council of Dubuque in said County/Counties met on 03/20/2017 ,at the place and hour set in the notice, a copy of which accompanies this certificate and is certified as to publication. Upon taking up the proposed amendment, it was considered and taxpayers were heard for and against the amendment. The Council, after hearing all taxpayers wishing to be heard and considering the statements made by them, gave final consideration to the proposed amendment(s) to the budget and modifications proposed at the hearing, if any. thereupon, the following resolution was introduced. RESOLUTION No. 106-17 A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 3C 2017 (AS AMENDED LAST ON 09/19/2016 .) Be it Resolved by the Council of the City of Dubuque Section 1. Following notice published 03/09/2017 and the public hearing held, 03/20/2017 the current budget (as previously amended) is amended as set out herein and in the detail by fund type and activity that supports this resolution which was considered at that hearing: Revenues & Other Financing Sources Taxes Levied on Property Less: Uncollected Property Taxes -Levy Year Net Current Property Taxes Delinquent Property Taxes TIF Revenues Other City Taxes Licenses & Permits Use of Money and Property Intergovernmental Charges for Services Special Assessments Miscellaneous Other Financing Sources Transfers In Total Revenues and Other Sources Expenditures & Other Financing Uses Public Safety Public Works Health and Social Services Culture and Recreation Community and Economic Development General Government Debt Service Capital Projects Total Government Activities Expenditures Business Type / Enterprises Total Gov Activities & Business Expenditures Transfers Out Total Expenditures/Transfers Out Excess Revenues & Other Sources Over (Under) Expenditures/Transfers Out Fiscal Year Beginning Fund Balance July 1 Ending Fund Balance June 30 Passe Signature City Clerk/Finance Officer Total Budget as certified or last amended 1 25,555,634 2 0 3 25,555,634 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 this 20t1- (Day) 0tf(Day) 0 11,112,649 18,106,679 1,505,981 12,893,350 74,639,823 59,503,949 0 2,196,637 18,882,272 31,375,889 255,772,863 Current Amendment 29,733,055 14,435,265 1,046,148 12,585,861 14,326,749 9,508,806 10,088,563 79,773,622 171,498,069 91,506,763 263,004,832 31,375,889 294,380,721 -38,607,858 75,864,384 37,256,526 day of 0 0 0 0 -372,860 26,000 84,998 1,718,607 -99,762 0 82,303 20,497,950 505,021 22,442,257 -180,606 -36,038 -56,640 - 59,283 32,828 - 25,822 11,699,375 931,937 12,305,751 8,575,218 20,880,969 505,021 21,385,990 1,056,267 0 1,056,267 March n17 (Montar) Q Signature Mayor Total Budget after Current Amendment 25,555,634 0 25,555,634 0 11,112,649 17,733,819 1,531,981 12,978,348 76,358,430 59,404,187 0 2,278,940 39,380,222 31,880,910 278,215,120 29,552,449 14,399,227 989,508 12,526,578 14,359,577 9,482,984 21,787,938 80,705,559 183,803,820 100,081,981 283,885,801 31,880,910 315,766,711 -37,551,591 75,864,384 38,312,793 FISCAL YEAR 2017 AMENDMENT#1 CIN COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation GENERALFUND City-Wide 0 Gas Franchise Fee Revenue (1,309,440) 100 10010100 42340 Shift to Finance City-Wide 0 Electric Franchise Fee Revenue (3,213,383) 100 10010100 42345 Shift to Finance City-Wide 0 Maquoketa Valley Electric Franchise Fee Revenue (73,710) 100 10010100 42335 Shift to Finance City-Wide 0 Local Option Sales Tax-General Fund (186,430) 100 10010100 41530 Adjustto Actual City-Wide 0 Dubuque Racing Association Rent Revenue (258,649) 100 10079250 43262 Adjustto Actual City-Wide 0 Dubuque Racing Association Distribution Revenue (284,961) 100 10079250 43261 Adjustto Actual Police 10 Administration-PROPERTY INSURANCE (620) 100 10011100 62206 Adjustto Actual Police 10 DARE-Sick Leave Payout (4,623) 100 10011180 61091 Shift to Police Patrol Police 10 Police Patrol-Sick Leave Payout 4,623 100 10011700 61091 Shift from DARE Police 10 Police Patrol-Full-Time Employees (158,000) 100 10011700 61010 Vacancy Savings Police 10 Police Patrol-Police&Fire Retirement (29,000) 100 10011700 61370 Vacancy Savings Police 10 JAG Grant-Overtime 5,852 100 10011753 61051 New FYi 6 JAG Grant Appropriation Police 10 JAG Grant-Social Security 448 100 10011753 61320 New FYi 6 JAG Grant Appropriation Police 10 JAG Grant-Police Equipment 11,510 100 10011753 72218 New FYi 6 JAG Grant Appropriation Police 10 JAG Grant-Federal Grant 17,810 100 10011753 44125 New FYi 6 JAG Grant Police 10 JAG Grant-Federal Grant (13,500) 100 10011761 44125 Reverse Estimated JAG Grant Police 10 JAG Grant-Education and Training (13,500) 100 10011761 62360 Reverse Estimated JAG Grant E911 10 Emerg Communications-PROPERTY INSURANCE (153) 100 10012100 62206 Adjust to Actual Fire 10 Administration-PROPERTY INSURANCE (32) 100 10013100 62206 Adjustto Actual Fire 10 Fire Suppression-Auto/Jeep Replacement (19,712) 100 10013400 71310 Shift to Vehicle Maint.Outsourced Fire 10 Fire Suppression-Vehicle Maint.Outsourced 19,712 100 10013400 62528 Shift from Auto Replacement Fire 10 Fire Suppression-PROPERTY INSURANCE (1,528) 100 10013400 62206 Adjustto Actual Human Rights 30 Human Rights-Full-Time Employees (29,581) 100 10016100 61010 Vacancy Savings Human Rights 30 Human Rights-IPERS (2,642) 100 10016100 61310 Vacancy Savings Human Rights 30 Human Rights-Social Security (2,654) 100 10016100 61320 Vacancy Savings Human Rights 30 Human Rights-PROPERTY INSURANCE (31) 100 10016100 62206 Adjustto Actual Health Services 30 Health Administration-PROPERTY INSURANCE (32) 100 10017100 62206 Adjustto Actual Health Services 30 Health Inspections-Vehicle Replacement (21,700) 100 10017300 71310 Vehicle Replacement Delay Parks 4C Valentine Park Extension-Consultant Services 16,675 100 1001560 62716 Shift from Park Renovate Water System Parks 40 Park Maintenance-Picnic tables 9,600 100 10030400 72717 Adjustto Actual Parks 40 Greenhouse-Social Security 12,731 100 10030500 61320 Adjustto Actual Parks 40 Park Administration-PROPERTY INSURANCE (32) 100 10030100 62206 Adjustto Actual Parks 40 Park Patrol-Pick-Up Replacement (30,000) 100 10030300 71312 Delayed Equipment Replace Parks 40 Park Maintenance-PROPERTY INSURANCE (5,346) 100 10030400 62206 Adjustto Actual Parks 40 Four Mounds-PROPERTY INSURANCE (443) 100 10030410 62206 Adjustto Actual Parks 40 Downtown Maint-PROPERTY INSURANCE (154) 100 10030430 62206 Adjustto Actual Parks 40 Greenhouse-Dump Track Replacement (29,000) 100 10030500 71314 Delayed Equipment Replace Civic Center 40 Civic Center-PROPERTY INSURANCE (4,460) 100 10032100 62206 Adjust to Actual Conference Center 40 GRC-PROPERTY INSURANCE (5,641) 100 10033300 62206 Adjustto Actual Recreation 40 POD Cstore-PROPERTY INSURANCE (813) 100 10030550 62206 Adjustto Actual Recreation 40 Recreation Admin-PROPERTY INSURANCE (322) 100 10034100 62206 Adjustto Actual Recreation 40 Golf Maint-PROPERTY INSURANCE (713) 100 10034250 62206 Adjustto Actual Recreation 40 Swimming-PROPERTY INSURANCE (708) 100 10034300 62206 Adjustto Actual Library 40 Adult Books 2,457 100 10036200 62651 Lost Books Library 40 Children's Books 1,671 100 10036210 62651 Lost Books Library 40 Circulation-Book Fines 4,128 100 10036220 53406 Lost Book Revenue Library 40 Maintenance Services-PROPERTY INSURANCE (7,911) 100 10036300 62206 Adjust to Actual Library 40 Technical Services-PROPERTY INSURANCE (199) 100 10036500 62206 Adjust to Actual Airport 20 Airport Admin-PROPERTY INSURANCE (32) 100 10051100 62206 Adjust to Actual Airport 20 Airport Operations-PROPERTY INSURANCE (4,478) 100 10051400 62206 Adjust to Actual Airport 20 Terminal Building Maint-PROPERTY INSURANCE (2,633) 100 10051700 62206 Adjust to Actual Airport 20 Airport Operations-Contractor Services 55,000 100 10051400 62710 Runway Painting Public Works 20 Public Works Admin-PROPERTY INSURANCE (32) 100 10054100 62206 Adjust to Actual Page 1 FISCAL YEAR 2017 AMENDMENT#1 CIN COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 20 Project Engineering-Vehicle Replacement (61,500) 100 10055400 71310 Vehicle Replacement Delay Engineering 20 Traffic Engineering-Vehicle Replacement (17,500) 100 10055700 71310 Vehicle Replacement Delay Engineering 20 Administration-Wharfage Revenue 75,000 100 10055100 43320 Adjustto Actual Engineering 20 Engineering Admin-PROPERTY INSURANCE (1,228) 100 10055100 62206 Adjustto Actual Building Services 10 Building Code Enforcement-Building Permits 46,000 100 10057400 42205 Adjustto Actual Building Services 10 Administration-Computer,Peripherals (5,318) 100 10057100 71120 Software Savings Building Services 10 Administration-Telephone 485 100 10057100 62421 Smart Phone Service Building Services 10 Administration-Education and Training 387 100 10057100 62360 Training Building Sew Mgr Building Services 10 Administration-Miscellaneous Revenue 1,499 100 10057100 53620 Scholarship Reimbursement Building Services 10 Administration-Education and Training 1,499 100 10057100 62360 Building Sew Mgr Conference Building Services 10 Building Sew Admin-PROPERTY INSURANCE (32) 100 10057100 62206 Adjust to Actual Building Services 10 Electrical Code Enforcement-Telephone 510 100 10057200 62421 Smart Phone Service Building Services 10 Electrical Code Enforcement-InternetServices 180 100 10057200 62667 Tablet Internet Service Building Services 10 Electrical Code Enforcement-Computer,Peripherals 205 100 10057200 71120 Tablet Accessories Building Services 10 Building Code Enforcement-Telephone 1,530 100 10057400 62421 Smart Phone Service Building Services 10 Building Code Enforcement-InternetServices 400 100 10057400 62667 Tablet Internet Service Building Services 10 Building Code Enforcement-Computer,Peripherals 315 100 10057400 71120 Tablet Accessories Building Services 10 Building Code Enforcement-Vehicle Maintenance 1,061 100 10057400 62521 Vehicle Repairs Building Services 60 City Hall Maint-PROPERTY INSURANCE (975) 100 10057500 62206 Adjust to Actual Building Services 60 City Hall Annex Maint-PROPERTY INSURANCE (664) 100 10057510 62206 Adjust to Actual Building Services 60 MFC-PROPERTY INSURANCE (288) 100 10057540 62206 Adjust to Actual Building Services 60 Ice Arena-PROPERTY INSURANCE (2,955) 100 10057550 62206 Adjustto Actual Building Services 10 Plumbing/Mechanical Enforcement-Telephone 510 100 10057700 62421 Smart Phone Service Building Services 10 Plumbing/Mechanical Enforcement-Internet Services 529 100 10057700 62667 Tablet and Laptop Internet Service Building Services 10 Building Code Enforcement-Computer,Peripherals 267 100 10057700 71120 Table Accessories Building Services 10 Plumbing/Mechanical-Vehicle Sales 2,950 100 10057700 54107 Eliminated Position Vehicle Sale Building Services 10 Plumbing/Mechanical-Vehicle Maintenance 750 100 10057700 62521 Vehicle Repairs Building Services 10 Plumbing/Mechanical-Vehicle Maint.Outsourced 1,139 100 10057700 62528 Vehicle Repairs Economic Development 50 Administration-Farm Land Rent 43,608 100 10060700 43242 Adjustto Actual Economic Development 50 Economic Development-PROPERTY INSURANCE (1,653) 100 10060700 62206 Adjustto Actual Economic Development 5C IFA DT Housing Loan Pool-Principal 500,000 100 1002279 43405 Adjustto Actual Housing&Community Development 60 Federal Building-PROPERTY INSURANCE (4,719) 100 10061150 62206 Adjustto Actual Housing&Community Development 50 General Housing lnsp-PROPERTY INSURANCE (110) 100 10061700 62206 Adjustto Actual Planning 50 Planning Admin-PROPERTY INSURANCE (31) 100 10062100 62206 Adjustto Actual Planning 50 Development Services-Billboard Inspection Fee 1,000 100 10062400 51917 Adjustto Actual Budget 60 Budget-PROPERTY INSURANCE (32) 100 10072400 62206 Adjustto Actual City Council 60 Legislation-Reimbursements 7,487 100 10070100 53620 Conference Reimbursement Finance 60 Accounting-PROPERTY INSURANCE (32) 100 10074100 62206 Adjustto Actual Finance 60 Accounting-Gas Franchise Fee Revenue 1,309,440 100 10074100 42340 Shift from Undistributed Finance 60 Accounting-Electric Franchise Fee Revenue 3,213,383 100 10074100 42345 Shift from Undistributed Finance 60 Accounting-Maquoketa Valley Franchise Fee Revenue 73,710 100 10074100 42335 Shift from Undistributed Legal Services 60 Legal Services-Full-Time Employee (91,323) 100 10076100 61010 Legal Reorganization Legal Services 60 Legal Services-Part-Time Employee 79,500 100 10076100 61020 Legal Reorganization Legal Services 60 Legal Services-IPERS 2,178 100 10076100 61310 Legal Reorganization Legal Services 60 Legal Services-Social Security 1,340 100 10076100 61320 Legal Reorganization Legal Services 60 Legal Services-Health Insurance (15,900) 100 10076100 61410 Legal Reorganization Legal Services 60 Legal Services-Life Insurance (201) 100 10076100 61416 Legal Reorganization Legal Services 60 Legal Services-Sick Leave Payout 10,938 100 10076100 61091 Legal Reorganization Legal Services 60 Legal Services-County Share 4,942 100 10076100 46205 Adjust to Actual Legal Services 60 Legal-PROPERTY INSURANCE (32) 100 10076100 62206 Adjust to Actual Information Services 60 Information Services-PROPERTY INSURANCE (1,771) 100 10077100 62206 Adjustto Actual Housing&Community Development 50 Administration-Private Participant 5,000 100 10061100 53102 Sisters of the Presentation Donation Housing&Community Development 50 Administration-Grants 5,000 100 10061100 62765 Sisters ofthe Presentation Donation Allocation Housing&Community Development 50 General Housing Inspection-Dwelling Unit Inspect Fee (20,000) 100 10061700 42322 Shift to Court Fines&Penalties Housing&Community Development 50 General Housing Inspection-IA District Court Fines 10,000 100 10061700 53403 Shift from Dwelling Unit Inspect Fees Page 2 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Housing&Community Development 50 General Housing Inspection-Inspection Penalty 10,000 100 10061700 43408 Shift from Dwelling Unit Inspect Fees Housing&Community Development 50 Circles-Private Donations (13,900) 100 10061922 53102 Shift to Circles Private Donations Housing&Community Development 50 Circles-General Reimbursements 1,472 100 10061922 53620 Great Lakes Intern Reimbursement TOTAL GENERAL FUND (333,987) (46,544) TRANSIT FUND Transit 80 Transit Administration-Full-Time Employee 5,324 600 60053100 61010 Adjustto Approved Transit 80 Transit Administration-Part-Time Employee 23,091 600 60053100 61020 Adjustto Approved Transit 80 Transit Administration-IPERS 2,539 600 60053100 61310 Adjustto Approved Transit 80 Transit Administration-Social Security 2,172 600 60053100 61320 Adjustto Approved Transit 80 Transit Administration-Life Insurance 10 600 60053100 61416 Adjustto Approved Transit 80 Bus Operations-Part-Time Employee 51,976 600 60053400 61020 Adjustto Approved Transit 80 Bus Operations-IPERS 2,968 600 60053400 61310 Adjust to Approved Transit 80 Bus Operations-Social Security 2,603 600 60053400 61320 Adjust to Approved Transit 80 Mini Bus Operations-Part-Time Employee 53,050 600 60053500 61020 Adjustto Approved Transit 80 Mini Bus Operations-IPERS 4,736 600 60053500 61310 Adjust to Approved Transit 80 Mini Bus Operations-Social Security 4,059 600 60053500 61320 Adjust to Approved Transit 80 Trolley Operations-Part-Time Employee (22,851) 600 60053600 61020 Adjust to Approved Transit 80 Trolley Operations-IPERS (2,041) 600 60053600 61310 Adjust to Approved Transit 80 Trolley Operations-Social Security (1,748) 600 60053600 61320 Adjust to Approved Transit 80 Trolley Operations -Health Insurance (1,000) 600 60053700 61410 Adjust to Actual Transit 80 Bus Maint-PROPERTY INSURANCE (886) 600 60053700 62206 Adjust to Actual Transit 80 Intermodal Ramp-PROPERTY INSURANCE (3,307) 605 60553380 62206 Adjust to Actual TOTAL TRANSIT FUND 120,695 - ROAD USE TAX FUND Public Works 20 Street Maintenance-Earth Compactor (2,280) 250 25054400 71420 Shift to Street Maintenance Track Replacement Public Works 20 Street Maintenance-Truck Replacement 2,280 250 25054400 71314 Shift from Street Maintenance Earth Compactor Public Works 20 Street Maint-PROPERTY INSURANCE (3,635) 250 25054400 62206 Adjustto Actual TOTAL ROAD USE TAX FUND (3,635) - COMMUNITY DENELOPMENr BLOCK GRANT FUND Engineering 2C Wheel Chair Ramps-Constmction 18,000 260 2601236 73211 CDBG Amend#2 Engineering 2C Neighborhood Related Improvements-Construction 126,000 260 2601239 73211 CDBG Amend#2 Engineering 2C Neighborhood Lighting 200,000 260 2601549 73410 CDBG Amend#2 Housing&Community Development 5C Residential Rehab Program-Loans 36,264 260 2601065 62764 CDBG Amend#2 Housing&Community Development 5C Purchase/Resale/Rehab-Constmction 250,600 260 2601231 73210 CDBG Amend#2 Housing&Community Development 50 Rehab Program-PROPERTY INSURANCE (88) 260 26061300 62206 Adjustto Actual Housing&Community Development 50 General Housing Inspection-Software 4,490 260 26061700 62663 CDBG Amend#2 Housing&Community Development 50 Housing Rehab Services-Hand Tools/Equipment 8,481 260 26061300 62033 CDBG Amend#2 Housing&Community Development 50 CDBG Administration-Conferences (100) 260 26061800 62310 CDBG Amend#2 City Manager's Office 50 Neighborhood Development-Services from Planning 8,710 260 26072800 62834 CDBG Amend#2 Purchase of Service 50 St Marks Tuckpointing-Construction 20,000 260 26079217 62761 CDBG Amend#2 TOTAL CDBG FUND 672,357 - HUD RESILIENCY GRANT FUND Housing&Community Development 5C HUD Resiliency-Employee Expense 61,875 264 2642690 61010 Grant Administrator Housing&Community Development 5C HUD Resiliency-Consultant Services 276,125 264 2642690 62716 HUD Grant Costs Housing&Community Development 5C HUD Resiliency-Federal Pass Thm State 338,000 264 2642690 45771 HUD Grant Reimbursements Housing&Community Development 50 HUD Resiliency-Federal Pass Thm State 12,000 264 26461850 45771 Resiliency Coordinator-HUD Grant Payment Housing&Community Development 50 HUD Resiliency-Employee Expense 12,000 264 26461850 61010 Resiliency Coordinator TOTAL HUD RESILIENCY GRANT FUND 350,000 350,000 CIRCLES RESTRICTED DONATIONS FUND Page 3 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Housing&Community Development 50 Circles Private Donations-Private Donations 13,900 269 26961922 53102 Shift from Circles TOTAL CIRCLES RESTRICTED DONATIONS FUND - 13,900 STATE HOME FUND Housing&Community Development 5C Residential Rehab Program-General Reimbursements 52,717 270 2701065 53620 Loan&Insurance Proceeds TOTAL STATE HOME FUND - 52,717 LEAD HAZARD MITIGATION FUND Housing&Community Development 5C Lead Hazard Reduction Program-Federal Grant 20,000 275 2752429 44310 Additional Grant Revenue Housing&Community Development 5C Lead Hazard Reduction Program-Loans 20,000 275 2752429 62764 Loans from Additional Grant Funds TOTAL LEAD HAZARD MITIGATION FUND 20,000 20,000 SECTION 8 FUND Housing&Community Development 50 Section 8-PROPERTY INSURANCE (178) 280 28061600 62206 Adjustto Actual Housing&Community Development 50 Section 8-Full-Time Employees (20,285) 280 28061600 61010 Reorganization Housing&Community Development 50 Section 8-IPERS (1,810) 280 28061600 61310 Reorganization Housing&Community Development 50 Section 8-Social Security (1,551) 280 28061600 61320 Reorganization Housing&Community Development 50 Section 8-Life Insurance (47) 280 28061600 61416 Reorganization TOTAL SECTION 8 FUND (23,871) - CABLE TV FUND Cable TV 60 Cable TV-PROPERTY INSURANCE (886) 290 29075100 62206 Adjust to Actual TOTAL CABLE TV FUND (886) - STREET CONSTRUCTION FUND City-Wide 0 Local Option Sales Tax-Street Construction Fund (111,858) 300 30010300 41530 Adjust to Actual Engineering 2C Crosswalk Warning Devices-Construction (31,000) 300 3002246 73211 Cancel and Rebudget Engineering 2C Fiber Optics to Airport-Constmction (135,620) 300 3002491 73211 Project Complete Public Works 2C Dump Truck Replacement-Truck Replacement 31,564 300 3002039 71314 Shift from Street Maintenance Asphalt Milling Revenue Engineering 2C Traffic Signalizations-Fed Pass Thru 78,966 300 3001011 45771 DMATS Allocation Engineering 2C Traffic Signalizations-Construction 78,966 300 3001011 73211 DMATS Appropriation Engineering 2C Guardrail Replacement-Construction (7,408) 300 3001027 73211 Shift to Asbury Rd Grinding&1-Way 2-Way Engineering 2C Curb/Catch Basin Replacements-Construction (30,738) 300 3001041 73211 Shift to General Street Construction Public Works 2C Curb Replacement Program-Construction (14,430) 300 3001226 73211 Shift to General Street Construction Engineering 2C Sidewalk Program City Owned-Construction (14,927) 300 3001425 73211 Shift to 1-Way 2-Way RR Crossing Engineering 2C General Street Construction-Construction 41,100 300 3002142 73211 Shift from Catch Basin&Curb Replacement Engineering 2C Asbury Road Grinding-Construction 1,106 300 3002482 73211 Shift from Guardrail Replacement Engineering 2C 1-Way to 2-Way RR Crossing-Construction 20,178 300 3002553 73211 Shift from Guardrail Replacement&Sidewalk Program Engineering 2C Flashing Yellow Left Tum-Lighting Equipment (14,739) 300 3002557 71517 Shift to Heeb St Engineering 2C Heeb Street Reconstruction-Engineering Services 5,778 300 3002612 62811 Shift from Flashing Yellow Left Turn Engineering 2C ROW Management-Engineering Services (6,940) 300 3002613 62811 Shift to Key West Drive Engineering 2C Key West Drive Reconstruction-Construction 20,596 300 3002694 73211 Shift from Flashing Yellow,ROW Mgmt,&Curb Replace TOTAL STREET CONSTRUCTION FUND (56,514) (32,892) SALES TAX FUND 120%1 City-Wide 0 Local Option Sales Tax-Sales Tax Construction 20% (74,572) 350 35010350 41530 Adjust to Actual Fire 1C ADA Compliance-Construction Contract Building 8,250 350 3501402 73210 Shift from Mechanical/Electrical Fire 1C Mechanical/Electrical Systems-Consultant Services (8,250) 350 3502575 62716 Shift to ADA Compliance Parks 4C Park Renovate Water System-Consulting Engineers (11,578) 350 3501158 62712 Shift to Valentine Park Extension Parks 4C Park Renovate Water System-Construction (5,510) 350 3501158 73211 Shift to Valentine Park Extension TOTAL SALES TAX FUND(20%) (17,088) (74,572) DEBT SERVICE FUND Debt-Service 70 Economic Development-Principal 500,000 400 40060400 74111 Additional Principal Paid by Developer Debt-Service 70 Economic Development-Principal 285,000 400 40060910 74111 2017A Bond Refunding Page 4 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Debt-Service 70 Economic Development-Principal 2,100,000 400 40060910 74111 2017C Bond Refunding Debt-Service 70 Economic Development-Principal 1,310,000 400 40060930 74111 2017B Bond Refunding Debt-Service 70 Economic Development-Principal 2,115,000 400 40060910 74111 2017B Bond Refunding Debt-Service 70 Fire-Principal 985,000 400 40013800 74111 2017A Bond Refunding Debt-Service 70 Park-Principal 62,446 400 40030600 74111 2017A Bond Refunding Debt-Service 70 Airport-Principal 291,860 400 40051300 74111 2017A Bond Refunding Debt-Service 70 Public Works-Principal 405,606 400 40054490 74111 2017A Bond Refunding Debt-Service 70 Engineering-Principal 3,597,483 400 40055400 74111 2017A Bond Refunding Debt-Service 70 Building-Principal 46,980 400 40057300 74111 2017A Bond Refunding Debt-Service 70 Economic Development-Bond Proceeds 4,500,000 400 40060910 54210 2017A/B Bond Refunding Debt-Service 70 Economic Development-Bond Proceeds 1,310,000 400 40060930 54210 2017B Bond Refunding Debt-Service 70 Fire-Bond Proceeds 985,000 400 40013800 54210 2017A Bond Refunding Debt-Service 70 Park-Bond Proceeds 62,446 400 40030600 54210 2017A Bond Refunding Debt-Service 70 Airport-Bond Proceeds 291,860 400 40051300 54210 2017A Bond Refunding Debt-Service 70 Public Works-Bond Proceeds 405,606 400 40054490 54210 2017A Bond Refunding Debt-Service 70 Engineering-Bond Proceeds 3,597,483 400 40055400 54210 2017A Bond Refunding Debt-Service 70 Building-Bond Proceeds 46,980 400 40057300 54210 2017A Bond Refunding TOTAL DEBT SERb10E FUND 11,699,375 11,199,375 SANITARY SEWER OPERATING FUND W&RRC 80 Plant Operations-Truck Replacement (50,000) 610 61043400 71314 Reallocate budget to Plant Operations Liquid 02 W&RRC 80 Plant Operations-Moving Equipment (15,000) 610 61043400 71611 Reallocate budget to Plant Operations Liquid 02 W&RRC 80 Plant Operations-Liquid 02 100,000 610 61043400 62639 Adjustto Actual W&RRC 80 Plant Operations-Major Repair Element (75,000) 610 61043400 62612 Cancel and Rebudget W&RRC 80 Plant Operations-02 Plant Maintenance (4,000) 610 61043400 62621 Cancel and Rebudget W&RRC 80 Plant Operations-Landfill Fees (4,000) 610 61043400 62692 Cancel and Rebudget W&RRC 80 Plant Operations-Laboratory Equipment (1,500) 610 61043400 71413 Cancel and Rebudget W&RRC 80 WRRC Plant Ops-PROPERTY INSURANCE (17,977) 610 61043400 62206 Adjustto Actual W&RRC 80 Environmental Monitoring-Repair Parts/Supplies (10,000) 610 61043700 62034 Reallocate budget to Plant Operations Liquid 02 W&RRC 80 Environmental Monitoring-Lab Supplies (25,000) 610 61043700 62061 Reallocate budget to Plant Operations Liquid 02 W&RRC 80 Environmental Monitoring-Seasonal Employees (4,199) 610 61043700 61030 Cancel and Rebudget W&RRC 80 Environmental Monitoring-Education&Training (1,800) 610 61043700 62360 Cancel and Rebudget W&RRC 80 Undistributed-Hormel Foods (160,000) 610 61010610 51221 Receipted in Sewage Fees W&RRC 80 Undistributed-Gas Royalty (40,762) 610 61010610 51260 Adjustto Actual W&RRC 80 Undistributed-San Rouesslot 100,000 610 61010610 51225 Adjustto Actual Engineering 80 Sanitary-Bond Proceeds 666,592 610 61043100 54210 2017A Bond Refunding Engineering 80 Sanitary-Principal 666,592 610 61043100 74111 2017A Bond Refunding Engineering 80 Sanitary-Consultant Services (105,000) 610 61055400 62716 Should be Stonnwater Engineering 80 Sanitary-Construction (200,000) 610 61055400 73211 Cancel and Rebudget Engineering 80 Sanitary-Flow Monitoring/SCADA (20,000) 610 61055400 72510 Cancel and Rebudget Engineering 80 Sanitary-Full-Time Employee (6,892) 610 61055400 61010 Adjustto Actual Engineering 80 Sanitary-IPERS (615) 610 61055400 61310 Adjustto Actual Engineering 80 Sanitary-Social Security (527) 610 61055400 61320 Adjustto Actual Engineering 80 Sanitary-Health Insurance (2,385) 610 61055400 61410 Adjustto Actual Engineering 80 Sanitary-Life Insurance (14) 610 61055400 61416 Adjustto Actual TOTAL SANITARY SEWER OPERATING FUND 222,683 565,830 STORMWATER OPERATING FUND Engineering 80 Stonnwater-Bond Proceeds 2,056,736 620 62055620 54210 2017A Bond Refunding Engineering 80 Stonnwater-Principal 2,056,736 620 62055620 74111 2017A Bond Refunding Engineering 80 Stonnwater-Consultant Services 105,000 620 62055620 62716 Fix budget entry Engineering 80 Stonnwater-Full-Time Employee (4,595) 620 62055620 61010 Cancel and Rebudget Engineering 80 Stonnwater-IPERS (410) 620 62055620 61310 Cancel and Rebudget Page 5 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 80 Stormwater-Social Security (352) 620 62055620 61320 Cancel and Rebudget Engineering 80 Stormwater-Health Insurance (1,590) 620 62055620 61410 Cancel and Rebudget Engineering 80 Stormwater-Life Insurance (9) 620 62055620 61416 Cancel and Rebudget TOTAL STORMWATER OPERATING FUND 2,154,780 2,056,736 PARKING OPERATING FUND Parking Division 80 Parking-Bond Proceeds 6,520,000 630 63046360 54210 2017B Bond Refunding Parking Division 80 Parking-Principal 6,520,000 630 63046360 74111 2017B Bond Refunding Parking Division 80 Locust St Ramp-PROPERTY INSURANCE (1,903) 630 63046300 62206 Adjustto Actual Parking Division 80 Iowa St Ramp-PROPERTY INSURANCE (2,257) 630 63046310 62206 Adjustto Actual Parking Division 80 5th St Ramp-PROPERTY INSURANCE (2,214) 630 63046320 62206 Adjustto Actual Parking Division 80 Five Flags Ramp-PROPERTY INSURANCE (2,214) 630 63046330 62206 Adjustto Actual Parking Division 80 Port of Dbq Ramp-PROPERTY INSURANCE (5,541) 630 63046350 62206 Adjustto Actual Parking Division 80 Central Ramp-PROPERTY INSURANCE (2,192) 630 63046360 62206 Adjustto Actual Parking Division 80 Intermodal Facility-PROPERTY INSURANCE (7,192) 630 63046370 62206 Adjustto Actual TOTAL PARKING OPERATING FUND 6,496,487 6,520,000 WATER OPERATING FUND Water 80 Water-PROPERTY INSURANCE (36) 640 64042100 62206 Adjustto Actual Water 80 Water Plant Op-PROPERTY INSURANCE (14,609) 640 64042400 62206 Adjustto Actual Water 80 Water Distrib-PROPERTY INSURANCE (1,679) 640 64042700 62206 Adjustto Actual TOTAL WATER OPERATING FUND (16,324) - SOLID WASTE OPERATING FUND Public Works 80 Refuse-Bond Proceeds 52,297 670 67054100 54210 2017A Bond Refunding Public Works 80 Refuse-Principal 52,297 670 67054100 74111 2017A Bond Refunding TOTAL SOLID WASTE OPERATING FUND 52,297 52,297 SANITARY SEWER CONSTRUCTION FUND W&RRC 8C WRRC Plant Renovation-Construction (254,000) 710 7101837 73210 Reallocate savings on project W&RRC 8C Nutrient Reduction Strategy-Consultant Services (5,000) 710 7102529 62712 Shift to Nutrient Reduction W&RRC 8C FOG Receiving Station-Construction (15,000) 710 7102529 62712 Shift to High Strength Waste W&RRC 8C Ash Pond Abandonment-Constmction 180,000 710 7102697 73211 Shift from WRRC Plant Renovation W&RRC 8C Methane Gas System-Consultant Services 15,000 710 7102698 62712 Shift from WRRC Plant Renovation W&RRC 8C Nutrient Reduction-Constmction 20,000 710 7102699 73211 Shift from WRRC Plant Renovation W&RRC 8C Nutrient Reduction-Consultant Services 5,000 710 7102699 62712 Shift from WRRC Plant Renovation W&RRC 8C Nutrient Reduction-Consultant Services 5,000 710 7102699 62712 Shift from Nutrient Reduction Strategy W&RRC 8C Level 4 Agreement-Consultant Services 34,000 710 7102700 62712 Shift from WRRC Plant Renovation W&RRC 8C High Strength Waste-Constmction 15,000 710 7102701 73211 Shift from FOG Receiving Station Engineering 8C SW Arterial Menards Frontage-Fed Pass Thru 48,475 710 7102669 45771 DMATS Allocation Engineering 8C SW Arterial Menards Frontage-Construction 10,594 710 7102669 73211 DMATS Appropriation Engineering 8C SW Arterial Seippel to English-Fed Pass Thru 200,015 710 7102670 45771 DMATS Allocation Engineering 8C SW Arterial Seippel to English-Construction 50,019 710 7102670 73211 Adjust to Actual TOTAL SANITARY SEWER CONSTRUCTION FUND 60,613 248,490 STORM WATER CONSTRUCTION FUND Engineering 8C Storm Improvements/Extensions-Construction (127,318) 720 7201008 73211 Cancel Project and Rebudget Engineering 8C General Storm Sewer Repairs-Constructions 75,000 720 7201066 73211 Adjust to Actual Engineering 8C Catch Basin Replacement-Construction (50,400) 720 7201081 73211 Cancel Project and Rebudget Engineering 8C Catch Basin Replacement-Engineering Services (8,704) 720 7201081 62811 Cancel Project and Rebudget Engineering 8C KaufmanNaleria Storm-Construction (37,999) 720 7201085 73211 Cancel Project and Rebudget Engineering 8C KaufmanNaleria Storm-Engineering Services (4,483) 720 7201085 62811 Cancel Project and Rebudget Engineering 8C Drain Tile Program-Construction (33,892) 720 7201354 73211 Cancel Project and Rebudget Engineering 8C Drain Tile Program-Engineering Services (3,742) 720 7201354 62811 Cancel Project and Rebudget Engineering 8C Gunite Rock Storm Sewer-Construction (50,981) 720 7201363 73211 Cancel Project and Rebudget Page 6 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 8C Gunite Rock Storm Sewer-Engineering Services (5,000) 720 7201363 62811 Cancel Project and Rebudget Engineering 8C Villa St Storm-Construction (26,883) 720 7201809 73211 Cancel Project and Rebudget Engineering 8C Hillcrest/Key Way Storm-Constmction (30,000) 720 7202016 73211 Cancel Project and Rebudget Engineering 8C Hillcrest/Key Way Storm-Consulting Engineers (4,300) 720 7202016 62712 Cancel Project and Rebudget Engineering 8C Drainage Basin Master Plan-Consulting Engineers (3,415) 720 7202240 62712 Cancel Project and Rebudget Engineering 8C Stonnwater I&I-Construction (71,671) 720 7202332 73211 Cancel Project and Rebudget Engineering 8C Stonnwater I&I-Engineering Services (6,930) 720 7202332 62811 Cancel Project and Rebudget Engineering 8C Windsor Storm Extension-Construction (39,447) 720 7202414 73211 Cancel Project and Rebudget Engineering 8C Center Grove Storm -Construction (58,000) 720 7202550 73211 Cancel Project and Rebudget Engineering 8C Center Grove Storm -Engineering Services (8,625) 720 7202550 62811 Cancel Project and Rebudget Engineering 8C SW Arterial Main Extension-Fed Pass Thru 1,151,355 720 7202594 45771 DMATS Allocation Engineering 8C SW Arterial Main Extension-Construction 1,151,355 720 7202594 73211 DMATS Appropriation Engineering 8C Flood Control Maintenance Facility-Federal Grant 200,000 720 7202609 44170 New Brownfield Grant Engineering 8C Flood Control Maintenance Facility-Land Acquisition (500,622) 720 7202609 73211 Adjust to Actual Engineering 8C Flood Control Maintenance Facility-Consultant Services 200,000 720 7202609 62716 New Brownfield Grant Appropriation Engineering 8C Admiral Sheehy Flood Gate-Construction (38,000) 720 7202610 73211 Cancel Project and Rebudget Engineering 8C Admiral Sheehy Flood Gate-Engineering Services (8,000) 720 7202610 62811 Cancel Project and Rebudget Engineering 8C Ice Harbor/Maus Pump Study-Engineering Services (75,000) 720 7202629 62811 Cancel Project and Rebudget Engineering 8C S Grandview Storm-Construction (61,385) 720 7202632 73211 Cancel Project and Rebudget Engineering 8C S Grandview Storm-Engineering Services (19,267) 720 7202632 62811 Cancel Project and Rebudget Engineering 8C Northridge Storm Extension-Construction (101,000) 720 7202668 73211 Cancel Project and Rebudget Engineering 8C Northridge Storm Extension-Engineering Services (12,000) 720 7202668 62811 Cancel Project and Rebudget Engineering 8C SW Arterial Menards Frontage-Construction 113,180 720 7202669 73211 DMATS Appropriation Engineering 8C SW Arterial Menards Frontage-Fed Pass Thru 50,544 720 7202669 45771 DMATS Allocation Engineering 8C SW Arterial Seippel to English-Fed Pass Thru (390,000) 720 7202670 45771 Adjust to Actual Engineering 8C SW Arterial Seippel to English-Construction (287,597) 720 7202670 73211 Adjust to Actual TOTAL STORM WATER CONST FUND (135,126) 1,011,899 WATER CONSTRUCTION FUND Water 8C Water Main Replacements-Construction (37,322) 740 7401405 73211 Reduce Project and Rebudget Water 8C Main Extension Annexation-Consulting Engineer (2,678) 740 7401411 62712 Reduce Project and Rebudget Water 8C Roosevelt Road Extension-Construction (292,107) 740 7401672 73211 Reduce Project and Rebudget Water 8C Green Alley-Construction (88,102) 740 7402044 73211 Reduce Project and Rebudget Water 8C Ramp Utility Relocation-Consulting Engineer (400) 740 7402261 62712 Reduce Project and Rebudget Water 8C English Mill Water Main-Consultant Services 25,451 740 7402504 62716 Adjust to Actual Water 8C Online Process Analyzer-Equipment Acquisition (15,006) 740 7402524 73410 Reduce Project and Rebudget Water 8C SRF Green Alley-Construction (240,350) 740 7402526 73211 Shift to Water Main Replacement Water 8C Southwest Arterial-Construction (1,606,265) 740 7402594 73211 Shift to CIWA Purchase,Timber Ridge Water Main Water 8C Creek Crossing-Construction (46,749) 740 7402595 73211 Reduce Project and Rebudget Water 8C Sewer Manhole Relocate-Construction (50,009) 740 7402596 73211 Reduce Project and Rebudget Water 8C Private Water System Purchase-Construction (63,964) 740 7402633 73211 Shift to Grandview/Loras Intersection Water 8C Private Water System Purchase-Pay to Other Agency (14,511) 740 7402633 62761 Reduce Project and Rebudget Water 8C Water Main Replace-Sewer-Construction 240,350 740 7402658 73211 Shift from SRF Green Alley Water 8C West Rural Water Purchase-Pay to Other Agency 1,110,000 740 7402703 62761 Payment for CIWA,Shift from SW Arterial Water 8C West Rural Water Purchase-Large Meters 75,728 740 7402703 71516 Meters for New Customers Water 8C West Rural Water Purchase-Construction 13,005 740 7402703 73211 Installation of New Meters Water 8C Timber Ridge Water Main-Construction 608,475 740 7402704 73211 Shift from SW Arterial Water 8C Grandview/Lours Inters Improv-Construction 57,331 740 7402705 73211 Shift from Private Water System Purchase TOTAL WATER CONSTRUCTION FUND (327,123) - ENGINEERING INTERNAL SERb10E FUND Engineering 80 Sanitary Projects-Full-Time Employee (22,974) 800 80055610 61010 Cancel and Rebudget Engineering 80 Sanitary Projects-IPERS (2,052) 800 80055610 61310 Cancel and Rebudget Engineering 80 Sanitary Projects-Social Security (1,758) 800 80055610 61320 Cancel and Rebudget Engineering 80 Sanitary Projects-Health Insurance (7,950) 800 80055610 61410 Cancel and Rebudget Page 7 FISCAL YEAR 2017 AMENDMENT#1 CITY COUNCIL 28-Feb-17 FY 17 FY 17 Expense Revenue Department Program Description Amount Amount Fund Activity/CIP Account Explanation Engineering 80 Sanitary Projects-Life Insurance (46) 800 80055610 61416 Cancel and Rebudget Engineering 80 Stonnvsater-Full-Time Employee (11,487) 800 80055620 61010 Cancel and Rebudget Engineering 80 Stonnvsater-IPERS (1,026) 800 80055620 61310 Cancel and Rebudget Engineering 80 Stonnvsater-Social Security (879) 800 80055620 61320 Cancel and Rebudget Engineering 80 Stonnvsater-Health Insurance (3,975) 800 80055620 61410 Cancel and Rebudget Engineering 80 Stonnvsater-Life Insurance (23) 800 80055620 61416 Cancel and Rebudget Garage 80 Garage-PROPERTY INSURANCE (1,594) 810 81054600 62206 Adjustto Actual TOTAL ENGINEERING INTERNAL SERVICE FUND (53,764) - TRANSFERS Transfer Out Transfer In City-Wide Transi Transferfrom General Fund to DRA Distribution Fund (2,850) 102 10210102 59100 Transferfunds City-Wide Transi Transferfrom General Fund to DRA Distribution Fund (2,850) 100 10010100 91102 Transferfunds Public Works Tmns2 Transfer from Road Use Tax to Street Const Fund 31,564 250 25010250 91300 Transfer Funds Public Works Tmns2 Transfer from Road Use Tax to Street Const Fund 31,564 300 3002039 59250 Transfer Funds Housing&Community Development Tmns3 Transfer from General Fund to Section 8 (23,693) 100 10010100 91280 Transfer Funds Housing&Community Development Tmns3 Transfer from General Fund to Section 8 (23,693) 280 28010280 59100 Transfer Funds Economic Development Tmns4 Transferfrom General Fund to Debt Service Fund 500,000 100 10010100 91400 Transfer Funds Economic Development Tmns4 Transferfrom General Fund to Debt Service Fund 500,000 400 40060400 59100 Transfer Funds TOTAL TRANSFERS 505,021 505,021 21,385,990 22,442,257 Page 8 i I STATE OF IOWA ISS: G DUBUQUE COUNTY CERTIFICATION OF PUBLICATION I i I, Suzanne Pike, a Billing Clerk for Woodward Communications, Inc., an Iowa corporation, publisher of the Telegraph Herald,a newspaper of general circulation published in the City of Dubuque, County of Dubuque and State of Iowa; hereby certify that the attached notice was published in said newspaper on the following dates: March 09, 2017, and for which the charge is $159.22. 'sL't��Pup Subscribed to before me, a Notary Public in and for Dubuque County, Iowa, this IM day of , 20� . 67 Notary Public in and for Dubuque County, Iowa. MARY K WESTERMEYER Commission Number 154885 My Commission Exp.Feb,t,2020 f k f i NOTICE OF PUBLIC HEARING AMENDMENT OF FY2016-2017 CITY BUDGET ., F,t , Form 653.C1 County,Iowa The City Council of Dubuque in DUBUQUE City will meet at Council Chambers at the Historic Federal Building at 6:00 p,K on 03/20/2017 (hour)t (Date) for purpose of amending the current budget of the oity for the fiscal year ending June 30, 2017 i (Year), by changing estimates of revenue and expenditure appropriations•in the following programs for the reasons given.Additional detail,is available at the city clerks office showing revenues and expenditures by fund type and by activity. Total Budget :Total Budget as certified - Current after Current or last amended Amendment Amendment Revenues&Other Financing Sources - 1 25,555,634 0 25,555,634 Taxes Levied on Property. 0 0 0 Less:Uncollected Property Taxes-Levy Year 2 25,555 0 ,634• 3 25,555,634 'I Net Current Property Taxes 0 0 0 Delinquent Property Taxes 4 TIF Revenues, 5 11,112,649 0 ' 11,112,649 t Taxes,' 6 18,106,679 372,860 17,733;819 Other,CiY, Licenses&Permits 7 1,505,981 26,000 1,531;981 Use of Money,and Property 8 12;893,350 84,998 12,978;348 Intergovernmental 9 74,639,823 1,718,607 76,358;430 Charges for Services 10 59,503,949 99,762 59,404;187 9 p 0 Special Assessments 11 0 Miscellaneous 12 2,196,637 82,303 2,278,940 . J Other,Financing Sources 13 18,882,272 20,497,950 39,380;222 Tranfers In 14 31,375,889 505,02: 31,880,910 o a evenues an er ources lb ZOO,t7TM Expenditures&Other Financing Uses Public Safety 16 29,733,055 -18Q,606 29,552 449 , Public Works 17 14,435,265 36,038 14,399,227 Health and Social Services 18 1,046,148 56,640 9$9,50$ Culture and Recreation 19 •12,585,861 759,283 12,526,578 onomic Development 20 14,326,749 32,828 14,359,577 Community and Economic p ;I General Government 21 ' 9,508,806 25,822 9,482,984 Debt Service 22 10,088,563 11,699,375 f 21,787,938 RTox1r, ojects 23 , 79,773,622 931,937 80,705,559 77 overnmen c Zvi ies xpen i ures' 7 7 ype nterprrses783;c ivi les usrness xpen i ures5,119 8 9g 5 5 2 31 ut:entlitures/Transfers Out 28 294380 721 21 385 990 --715,766,711 Excess Revenues&Other Sources Over. (Under}Expenddures/Transfers Out for Fiscal Year 29 -38,607,858, 1 056 267 -37,551,591 71 ,. -� l 0 75,864384 Beginning Fund Balance July 1•a 30 75;864,384 Ending Fund Balance June 30 31 37,256,526 1,056,267 38,312,793 I - estimates,appropriations,or available cash: nue esi Explanation of increases or decreases m revenue - 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 DevelopmentAnnual Plan; budget are included along with savings from completed or cancelled projects and available cash balance is used to fund increased operations. 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. Kevin S.Firnstahl City Clerk/Finance Officer adno=664267-01 1t3/9