Fiscal Year 2017 Second Budget Amendment_Initiate Copyrighted
March 6, 2017
City of Dubuque Items to be set for Public Hearing # 1.
ITEM TITLE: Fiscal Year 2017 Second Budget Amendment
SUMMARY: City Manager recommending the second Fiscal Year 2017
Budget Amendment be set for public hearing for March 20,
2017.
RESOLUTION Setting the date for the public hearing on
Amendment No. 2 to the Fiscal Year 2017 Budget for the
City of Dubuque
SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt
Resolution(s), Set Public Hearing for March 20, 2017
ATTACHMENTS:
Description Type
MVM Memo City Manager Memo
Staff Memo Staff Memo
Resolution Resolutions
Notice of Public Hearing Supporting Documentation
FY17 Amend 2 Detail Supporting Documentation
THE CITY OF Dubuque
UBE 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: February 28, 2017
Budget Director Jennifer Larson is recommending the second Fiscal Year 2017 Budget
Amendment be set for public hearing for March 20, 2017.
1 concur with the recommendation and respectfully request Mayor and City Council
approval.
1)4)U4t
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
UBE 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: February 28, 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 canceling 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 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 March 20, 2017.
Attachments
JML
RESOLUTION NO. 85-17
SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 2 TO THE
FISCAL YEAR 2017 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 2017 budget for the City of Dubuque at the City Council Chambers at
the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday, March 20,
2017, beginning at 6:00 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 6th day of March 2017.
Attest:
Kevn Firnstahl, City Clerk
Roy D. Buol, Mayor
Jun15
NOTICE OF PUBLIC HEARING
Form 653 c1 AMENDMENT OF FY2016-2017 CITY BUDGET
The City Council of Dubuque in DUBUQUE County, Iowa
will meet at City Council Chambers atthe Historic Federal Building
at 6:00 p.m. on 3/20/2017
(h,,l) (Date)
,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2017
Near)
by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given.
Additional detail is available atthe city clerk's 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
Taxes Levied on Property 1 25,555,634 25,555,634
Less:Uncollected Property Taxes-Levy Year 2 0 0
Net Current Property Taxes 3 25,555,634 0 25,555,634
Delinquent Property Taxes 4 0 0
TIF Revenues 5 11,112,6491 11,112,649
Other City Taxes 6 18,106,679 -372,860 17,733,819
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
Special Assessments 11 0 0
Miscellaneous 12 2,196,637 82,303 2,278,940
Other Financing Sources 13 18,882,272 20,497,950 39,380,222
Transfers In 14 31,375,8891 505,021 31,880,910
Total Revenues and Other Sources 15 255,772,863 22,442,257 278,215,120
Expenditures&Other Financing Uses
Public Safety 16 29,733,055 -180,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 989,508
Culture and Recreation 19 12,585,861 -59,283 12,526,578
Community and Economic Development 20 14,326,749 32,828 14,359,577
General Government 21 9,508,806 -25,822 9,482,984
Debt Service 22 10,088,563 11,699,375 21,787,938
Capital Projects 23 79,773,622 931,937 80,705,559
Total Government Activities Expenditures 24 171,498,069 12,305,751 183,803,820
Business Type/Enterprises 25 91,506,763 8,575,218 100,081,981
Total Gov Activities&Business Expenditures 26 263,004,832 20,880,969 283,885,801
Transfers Out 27 31,375,889 505,021 31,880,910
Total Expenditures/Transfers Out 28 294,380,721 21,385,990 315,766,711
Excess Revenues&Other Sources Over
(Under)Expenditures/Transfers Out Fiscal Year 29 -38,607,858 1,056,267 -37,551,591
Beginning Fund Balance July 1 301 75,864,3841 75,864,384
Ending Fund Balance June 30 311 37,256,5261 1,056,267 38,312,793
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.
There will be no increase in tax levies to be paid in the current fiscal year named above related to the proposed
budget amendment. 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.
Kevin S. Firnstahl
City Clerk/Finance Officer Name
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