Fiscal Year 2018 First Budget Amendment_Hearing Copyrighted
September 5, 2017
City of Dubuque Public Hearings # 2.
ITEM TITLE: Fiscal Year 2018 First Budget Amendment
SUMMARY: Proof of publication on notice of public hearing to consider
approval of the Fiscal Year 2018 First Budget Amendment
and the City Manager recommending approval.
RESOLUTION Amending the current budget for the Fiscal
Year Ending June 30, 2018
SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt
Resolution(s)
ATTACHMENTS:
Description Type
MVM Memo City Manager Memo
Staff Memo Staff Memo
Resolution Resolutions
Amendment Detail Supporting Documentation
THE CITY DF DubuqueSUB E
Masterpiece ars the Mississippi
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2018 First Budget Amendment
DATE: August 23, 2017
Budget Director Jennifer Larson is recommending approval of the first Fiscal Year 2018
Budget Amendment, which amends the Fiscal Year 2018 budget for City Council
actions since the beginning of the Fiscal Year and includes items which City Council
has expressed support. Second, the amendment includes Fiscal Year 2017 budget
carryovers to Fiscal Year 2018 of encumbrances totaling $27,210,478, capital projects
totaling $41 ,851 ,553 that were not completed during the prior Fiscal Year, and
associated revenues totaling $39,512,047. There are operating budget appropriation
carryovers of$1 ,749,490 and operating receivables of$1 ,474,387. Also, total transfers
between funds of$2,759,004 are reflected.
The City maintains a general fund reserve, or working balance, to allow for unforeseen
expenses that may occur. The Fiscal Year 2017 budget recommendation anticipated
an additional contribution to the general fund reserve of$600,000. The actual fiscal
results of 2017 has allowed for the $600,000 contribution to be added to the general
fund reserve. The estimated unrestricted General Fund Reserve balance as of June 30,
2017 is $9,866,669 on an accrual basis, which is estimated to be 14.20% of general
fund revenues.
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
Teri Goodmann, Assistant City Manager
Jennifer Larson, Budget Director
THE CDubuque
Uj4B E All-America City
1
Masterpiece on the Mississippi 11110
2007•2012•2013•2017
TO: Michael C. Van Milligen, City Manager
FROM: Jennifer Larson, Budget Director
SUBJECT: Fiscal Year 2018 First Budget Amendment
DATE: August 23, 2017
The purpose of this memorandum is to provide an explanation regarding the first amendment
for Fiscal Year 2018. This amendment is twofold. First, it amends the Fiscal Year 2018
budget for City Council actions since the beginning of the Fiscal Year and includes items
which City Council has expressed support. Second, the amendment includes Fiscal Year
2017 budget carryovers to Fiscal Year 2018 of encumbrances totaling $27,210,478, capital
projects totaling $41,851,553 that were not completed during the prior Fiscal Year, and
associated revenues totaling $39,512,047. There are operating budget appropriation
carryovers of$1,749,490 and operating receivables of$1 ,474,387. Also, total transfers
between funds of $2,759,004 are reflected.
During Fiscal Year 2017, many projects were completed. These projects include the
following:
Bunker Hill Cart Paths
Fire Improvement to Fire Headquarters Bunker Clubhouse Repairs
Fire ADA Improvements Library Attic Access
Fire Breathing Apparatus Replacement Library Maker Space
Fire Station Mechanical/Electrical System Airport Water Extension
Valentine Park Expansion English Mill Water Main Extension
Flora Brick Pavilion Roof CIWA Water System Purchase
Park Maintenance Restroom Rehab Parking Gate Equipment Replacement
Eagle Point Park Environmental Airport Extend General Aviation Ramp
Grand Opera House Digital Sign Replace Airport Hangar Repairs
Allison-Henderson Furnace Replacement Airport New Terminal
Five Flags Security System Public Works Curb Replacement Program
Five Flags Renovate Employee Area Public Works Asphalt Milling Program
Grand River Center Fabric Wall Coverings Public Works Port Amenities Maintenance
Grand River Center Carpet Replacement Engineering Catch Basin Improvements
Grand River Center Outdoor Furniture Engineering Drain Tile Program
Grand River Center Upgrade AV Equip Engineering City Owned Sidewalks
Grand River Center Maintenance Equip Fairway Drive Sanitary Sewer
Pavement Marking Annual Program ADA Compliance Consultant
Catfish Creek Bridge Fiber Optics ADA Compliance Software
18th Street Wall Reconstruction Financial Software Upgrade
JFK Sanitary Sewer Information Technology Test Environment
9th to 11th Railroad Improvements Information Technology Office Remodel
Grandview/Delhi Roundabout City-Wide Multifunction Replacement
South Grandview Stormwater City-Wide Computer Replacements
Catfish Creek Bridge
Northwest Arterial Left Turn Lane
Many other enhancements are reflected throughout the community.
CARRYOVER AMENDMENT TO FISCAL YEAR 2018
CAPITAL BUDGET CARRYOVER AMENDMENT
Some significant projects were started and remain in process, which are carried forward into
Fiscal Year 2018. The most significant of the capital project expenditure carryovers, including
associated revenue, are:
Southwest Arterial ($6,776,825) Airport Terminal Construction ($1 ,207,764)
Kerper Sanitary Sewer ($3,888,875) North Cascade Road ($1 ,851 ,348)
North Cascade Road ($3,484,231) Corridor Study Alternates ($1 ,050,000)
Gate Replacement ($1 ,967,008) Millwork District Parking ($994,744)
Bee Branch ($1 ,480,996) Relocation of 30" Force Main ($958,586)
Catfish Creek Watershed ($1 ,300,570) Southwest Arterial Water Main ($453,364)
Chavenelle Trail ($1 ,393,330) HOME Program ($439,956)
Derby Grange Annexation ($924,362) IFA Housing Trust ($493,796)
Skate Park ($773,723) Residential Rehab ($360,301)
Flood Control Maint. Facility ($942,833) Washington Neighborhood ($348,599)
Kerper Sanitary ($663,552) Purchase/Rehab/Resale ($342,338)
Washington 8th to 9th ($651 ,495) Neighborhood Related Improve ($335,176)
New Terminal Sitework ($1 ,103,788) Port of Dubuque Ramp Maint ($330,207)
Roosevelt Rd Water Extension ($1 ,076,619) Homeownership Grants ($319,608)
Corridor Study Alternates ($1 ,050,000) Downtown TIF Loans ($300,000)
- 2 -
OPERATING BUDGET CARRYOVER AMENDMENT
The most significant operating budget carryovers into Fiscal Year 2018 include such items
as:
Street Lighting ($399,663) Greenhouse Landscaping ($20,000)
Electric Franchise Fee Refund ($283,217) W&RRC Consulting ($20,000)
Forestry Aerial Truck ($187,250) Fair Housing Training ($24,829)
Forestry Dump Truck ($79,000) Police Other Equipment ($18,815)
Water Meters Truck ($70,000) AmeriCorps Summer Grant ($18,050)
Water Distribution Truck ($70,000) Sustainability Community Grants ($16,007)
Housing LHAP Loans ($51 ,878) Traffic Equipment ($14,259)
Purchase of Services ($39,690) Forestry Ash Borer Maintenance ($13,681)
Police Canine Trust ($28,373) Parks Heavy Equipment ($10,483)
Police ICE Enforcement ($31 ,483) Recreation AmeriCorps ($10,000)
Parks Property Maintenance ($30,000) GIS Consulting ($9,970)
Parks Security Cameras ($29,688) Jackson Park Picnic Tables ($9,600)
Garage Vehicle Hoist ($29,000) Rehab Escrow Payment ($8,674)
Downtown Maintenance Truck ($27,000) Snow & Ice Cameras ($8,520)
Recreation Program Equipment ($24,781) Airport Wireless Enhancement ($8,500)
Police Education & Training ($22,922) Water Distribution Trailer ($8,000)
Transit Vehicle Replacement ($22,500) Golf Handheld POS Devices ($6,964)
FIRST AMENDMENT TO THE FISCAL YEAR 2018 CERTIFIED BUDGET
There have been numerous actions by City Council and changes requiring amendments for
the Fiscal Year 2018 budget.
CAPITAL BUDGET AMENDMENT
The capital budget amendments total a decrease of$1 ,206,571 , with a decrease in
associated revenue of$467,080. The capital amendment items include a decrease of
$1 ,562,117 to the HUD Resiliency project due to pre-spending the Fiscal Year 2018 budget;
decrease of$245,279 to the West Rural Water Purchase due to pre-spending the Fiscal Year
2018 budget; decrease of$153,332 to the Homeownership project due to adjusting the
budget for actual Housing TIF received in previous years; decrease of$145,797 to the Bus
Storage Facility project due to pre-spending the Fiscal Year 2018 budget; decrease of
$121 ,821 to the Alternative Oxygen Study due to adjusting the project to the actual amount
expected to be spent; decrease of$127,635 to the Lead Hazard Reduction Program due to
pre-spending the Fiscal Year 2018 budget; and decrease of$92,760 to the Pavement
Marking Program due to pre-spending the Fiscal Year 2018 budget
The capital amendment items include an increase of$1 ,279,453 for CDBG funded programs,
which include Purchase/Rehab/Resale, Neighborhood Related Improvements, Residential
Rehab Program, Microenterprise Assistance, Rental Rehab, Wheel Chair Ramps, Bee
Branch Lead Waterline/Sewer and Historic Preservation Grants and an increase of$130,000
for the Lead Hazard Reduction program.
- 3 -
OPERATING BUDGET AMENDMENT
The operating budget amendments total an increase of$28,492, with an increase in
associated revenue of$1 ,831 ,915. The operating amendment items include a decrease of
$386,458 for the July 2017 Section 8 Housing Assistance Payments that were paid in June
2017; and a decrease of$34,641 for the Lead Hazard Reduction Program for pre-spending
the Fiscal Year 2018 budget.
The operating amendment items include an increase of$250,000 for street lighting to adjust
the budget line item to actual cost; $185,749 for Dental Insurance Premium which is
completely offset by employee payments; $11 ,773 for CDBG related programs; and $4,505
for the purchase of replacements from lost Library books fines.
In addition, the City maintains a general fund reserve, or working balance, to allow for
unforeseen expenses that may occur. The Fiscal Year 2017 budget recommendation
anticipated an additional contribution to the general fund reserve of$600,000. The actual
fiscal results of 2017 has allowed for the $600,000 contribution to be added to the general
fund reserve. The estimated unrestricted General Fund Reserve balance as of June 30, 2017
is $9,866,669 on an accrual basis, which is estimated to be 14.20% of general fund
revenues. These balances will be refined when the June 30, 2017 audited Certified Annual
Financial Report is completed in December 2017. Moody's Investor Service recommends a
factor of 20 percent for "AX rated cities and the City continues to work towards that number.
The action step is for City Council to adopt the attached resolution approving the FY 2017
first budget amendment.
Attachments
JML
- 4 -
31-288
CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION - FY 2018 - AMENDMENT #1
To the Auditor of DUBUQUE County, Iowa:
The City Council of Dubuque in said County/Counties met on 09/05/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. 315-17
A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 3C 2018
(AS AMENDED LAST ON N/A .)
Be it Resolved by the Council of the City of Dubuque
Section 1. Following notice published 08/23/2017
and the public hearing held, 09/05/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 29
2
3
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
Beginning Fund Balance July 1 30
Ending Fund Balance June 30 31
P-ssed this
Signature
City Clerk/Finance Officer
Total Budget Total Budget
as certified Current after Current
or last amended Amendment Amendment
25,062,297 ::::..............::::::0 25,062,297
0
25,062,297
0
11,903,432
18,061,248
1,529,906
12,553,589
76,756,897
42,881,139
30,000
8,133,059
9,424,132
31,751,321
238,087,020
29, 607,185
14,123,592
943,516
12,750,234
14,580,550
9,585,753
10,873,974
69,423,034
161,887,838
77,268,489
239,156,327
31,751,321
270,907,648
0
25,062,297
0
11,903,432
18,061,248
1,529,906-
12,553,589
,529,906-12,553,589
41,763,315
42,877,311
30,000
7,681,272
2,522,060 -
28,992,317
192,976,747,
0
0
0.
0
0
0
0
34,993,582
3,828
0
451,787
6,902,072
2,759,004
45,110,273
29,244,056
12,682,233
915,654
12,054,279
14,755,628
9,029,607
10,873,974
29,769,433
119,324,864
50,388,083
169,712,947
28,992,317
198,705,264
363,129
1,441,359
27,862
695,955
-175,078
556,146
0
39,653,601
42,562,974
26,880,406
69,443,380
2,759,004
72,202,384
-5,728,517 27,092,111 32,820,628
35,830,708 37,320,239 73,150,947
30,102,191
5th day of
(Day)
10,228,1?t8 40,330,319
September 01/
(Month
Signature
Mayor
FISCAL YEAR 2018 AMENDMENT#1 CIN COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
GENERALFUND
Police Department 10 Staff Services-Other Police Equipment 18,815 100 10011190 72218 C/O
Police Department 10 Staff Services-Other Police Equipment 669 100 10011190 72218 C/O- FY17 Revenue
Police Department 10 Staff Training- Education &Training 22,922 100 10011250 62360 C/O
Police Department 10 ICE Enforcement-Other Police Equipment 31,483 100 10011600 72218 C/O
Police Department 10 State&Community HWY Safety-Grant 5,806 100 10011771 45771 C/O
Police Department 10 2017 JAG Grant-Equipment 2,615 100 10011753 72218 C/O
Police Department 10 2017 JAG Grant-Overtime 3,569 100 10011753 61051 C/O
Police Department 10 State&Community HWY Safety-Overtime 3,678 100 10011771 61051 C/O
Police Department 10 Department of Justice Crime Victim-Grant 235 100 10011754 45771 C/O
Police Department 10 2018 Drug Task Force Grant-Grant (37,800) 100 10011330 45771 Shift to 10011320
Police Department 10 2018 Drug Task Force Grant-Grant 26,664 100 10011320 45771 Shift from 10011330
Police Department 10 2017 Hot Spots Grant-Grant 1,670 100 10011319 45771 C/O
Emergency Communis 10 Emergency Communications-Consultant Services 6,000 100 10012100 62716 C/O
Emergency Communis 10 Emergency Communications-County Contribution 2,000 100 10012100 46120 C/O
Emergency Communis 10 Emergency Communications-Printing& Binding 3,600 100 10012100 62716 C/O
Emergency Communis 10 Emergency Communications-County Contribution 1,200 100 10012100 46120 C/O
Emergency Communis 1C Emergency Dispatch Protocol-Software (2,900) 100 1002186 71123 Adjust to actual
Fire Department 10 Fire Suppression-Construction 5,000 100 10013400 73210 C/O
Emergency Managem 10 Emergency Management-Reimbursements 790 100 10015100 53620 C/O
Human Rights 30 Human Rights Grant Funds- Fair Housing Training 19,829 100 10016200 62753 C/O
Human Rights 30 Human Rights Grant Funds- Fair Housing Training 5,000 100 10016100 62342 C/O
Health Services 30 Lead Paint Program-Grants 3,160 100 10017500 45701 C/O
Health Services 10 Animal Control- Uniforms 459 100 10017200 62011 C/O
Health Services 10 Animal Control- Education&Training 3,600 100 10017200 62360 C/O
Health Services 30 Health Inspections-Travel Conferences 999 100 10017300 62310 C/O
Park Division 40 Forestry-Tree Maintenance-Ash Borer 13,681 100 10030220 62720 C/O
Park Division 40 Forestry-Aerial Truck 187,250 100 10030220 71614 C/O
Park Division 40 Forestry- Dump Truck 79,000 100 10030220 71614 C/O
Park Division 40 Park Areas& Maintenance- Property Maintenance 30,000 100 10030400 62431 C/O
Park Division 40 Park Areas& Maintenance-Software 2,000 100 10030400 71123 C/O
Park Division 40 Park Areas& Maintenance-Camera Related Equip 29,688 100 10030400 72417 C/O
Park Division 40 Park Areas& Maintenance- Picnic Tables 9,600 100 10030400 72710 C/O
Park Division 40 Park Areas& Maintenance-Truck Replacement 3,777 100 10030400 71314 C/O
Park Division 40 Park Areas& Maintenance- Heavy Equipment 10,483 100 10030400 71318 C/O
Park Division 40 Park Areas&Maintenance- Mowing Equipment 5,517 100 10030400 71611 C/O
Park Division 40 Park Areas&Maintenance-Vehicle Replacement 6,893 100 10030400 71310 C/O
Park Division 40 Downtown Maintenance-Truck 27,000 100 10030430 71312 C/O
Park Division 40 Greenhouse-Landscape 20,000 100 10030500 62637 C/O
Park Division 40 Technology Park Maintenance- Landscape 2,000 100 10030520 62637 C/O
Park Division 40 DICW Park Maintenance-Landscape 3,000 100 10030530 62637 C/O
Park Division 4C Comiskey Repair Siding-Construction 12,017 102 1021151 73210 C/O
Park Division 4C Valentine Expansion-Land Acquisition 10,360 100 1001560 73110 C/O
Park Division 4C Valentine Expansion-REAP Grant 140,790 100 1001560 45707 C/O
Park Division 4C Valentine Expansion-Parks to People Grant 30,210 100 1001560 45701 C/O
Park Division 4C NW Bike Hike Trail-Construction 56,906 100 1002273 73211 C/O
Park Division 4C NW Bike Hike Trail- REAP Grant 339,978 100 1002273 45707 C/O
Park Division 4C Comiskey Playground Improv-Consultant 201,802 102 1022292 62716 C/O
Pagel
FISCAL YEAR 2018 AMENDMENT#1 CIN COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Park Division 4C ITC Grant Tree/Park Development-Playground 47,880 100 1002637 72713 C/O
AmeriCorps 40 AmeriCorps Grant-Grant 26,355 100 10034918 45771 C/O
AmeriCorps 40 AmeriCorps Grant- Private Participant 16,046 100 10034918 53102 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Grant 34,242 100 10034910 45771 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Private Participant 9,711 100 10034910 53102 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Full-Time Employees 7,103 100 10034910 61010 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Seasonal Employees 2,492 100 10034910 61030 C/O
AmeriCorps 40 AmeriCorps Summer Grant- IPERS 641 100 10034910 61310 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Social Security 543 100 10034910 61320 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Workers Compensation 80 100 10034910 61415 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Office Supplies 260 100 10034910 62010 C/O
AmeriCorps 40 AmeriCorps Summer Grant- Program Supplies 850 100 10034910 62688 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Travel Conferences 403 100 10034910 62310 C/O
AmeriCorps 40 AmeriCorps Summer Grant- Mileage 219 100 10034910 62340 C/O
AmeriCorps 40 AmeriCorps Summer Grant- Education&Training 888 100 10034910 62360 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Telephone 12 100 10034910 62421 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Software License 161 100 10034910 62663 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Background Check 398 100 10034910 62717 C/O
AmeriCorps 40 AmeriCorps Summer Grant-Playground Equipment 4,000 100 10034910 72713 C/O
Civic Center Division 40 Five Flags Administration-Networking Contract 3,500 100 10032100 62061 C/O
Civic Center Division 4C Five Flags Improv-SMG-Construction 30,000 100 1002569 73210 C/O
Grand River Center 4C GRC Replace Electrical FLR Box-Construction 29,400 102 1022651 73210 C/O
Grand River Center 4C GRC Tech Replacement Support- Phones 20,500 100 1002519 71120 C/O
Grand River Center 4C GRC Replace Carpet-Construction 10,030 102 1022113 73210 C/O
Grand River Center 4C GRC Kitchen Equipment-Concession Equipment 8,233 102 1022588 72310 C/O
Recreation 40 Recreation Administration- Program Equipment 24,781 100 10034100 62668 C/O
Recreation 40 Recreation Administration- Pay to Other Agency 10,000 100 10034100 62761 C/O
Recreation 40 Golf Operations- Handheld POS Device 6,964 100 10034200 71120 C/O
Recreation 40 Golf Operations-Concession Equipment 3,861 100 10034200 72310 C/O
Recreation 40 AmeriCorps Supplemental-Miscellaneous 3,013 100 10034912 62661 C/O
Recreation 4C Marina Security Cameras-Cameras 3,572 102 1022587 72417 C/O
Recreation 4C F&S Pool Assessments-Consultant 13,974 102 1022648 62716 C/O
Recreation 4C Pool Maintenance-Construction 103,099 102 1021890 73210 C/O
Library 40 Library Administration-Travel Conferences 1,367 100 10036100 62310 C/O
Library 40 Adult Services- Library Books 2,997 100 10036200 62651 Lost Books
Library 40 Adult Services- Education and Training 3,764 100 10036200 62360 C/O
Library 40 Adult Services-Adult Books 364 100 10036200 62651 C/O
Library 40 Adult Services-Adult Audio Books 440 100 10036200 62652 C/O
Library 40 Adult Services-Continuums 550 100 10036200 62654 C/O
Library 40 Youth Services-Library Books 1,416 100 10036210 62651 Lost Books
Library 40 Youth Services-Travel Conferences 1,736 100 10036210 62310 C/O
Library 40 Maintenance Services- HVAC 2,361 100 10036300 62434 C/O
Library 40 Maintenance Services- Property Maintenance 293 100 10036300 62614 C/O
Library 40 Information Technology-Video Equipment 52 100 10036440 72416 Lost Equipment
Library 40 Technical Services-Travel Conferences 263 100 10036500 62310 C/O
Library 40 Technical Services- Education &Training 488 100 10036500 62360 C/O
Airport 20 Airport Operations-Peripheral Computers 8,500 100 10051400 71120 C/O
Public Works 20 Traffic and Street Light Components-Traffic Equip 14,259 100 10054430 62616 C/O
Page 2
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Public Works 20 Port of Dubuque Maint-Cameras 4,600 100 10054450 72417 C/O
Public Works 2C MSC LED Lighting-Lighting 18,590 102 1022541 71517 C/O
Engineering 4C Library Renovation-Sale of Heade Painting 178,601 100 1001141 54104 C/O
Engineering 2C Riverwalk Security Camera-Cameras 20,000 102 1021963 72417 C/O
Engineering 2C Kerper Boulevard Fiber and Cameras-Construction 122,687 102 1022674 73211 C/O
Engineering 20 Leases- Electricity 1,800 100 10055150 62411 Adjust to actual
Building Services 1C Permit Tracking System-Software 13,200 100 1001178 71123 C/O
Economic Developmei 5C Brownfelds Grants-Federal Grant 99,370 100 1001111 44170 C/O
Economic Developmei 5C Brownfelds Grants-Consulting Engineers 15,267 100 1001111 62712 C/O
Economic Developmei 5C DT Brownfelds Assessment- Federal Grant 4,478 100 1002567 44170 C/O
Economic Developmei 5C DT Brownfelds Assessment-Consultant 5,615 100 1002567 62716 C/O
Economic Developmei 5C DT Brownfelds Assessment- Federal Grant 17,483 100 1002567H 44170 C/O
Economic Developmei 5C DT Brownfelds Assessment-Consultant 14,394 100 1002567H 62716 C/O
Housing 50 Housing Administration- Promotions HOME 4,394 100 10061100 62140 C/O
Housing 50 Rehab-Escrow Payment 8,674 100 10061300 62758 C/O
Housing 5C Homeownership Grants-Grants 58,116 101 1011595 62765 C/O
Housing 5C Neighborhood Stabilization Grant-Construction 93,637 100 1002180 73210 C/O
Planning Services 5C Comp Plan Community Engagement-Promotion 14,409 102 1022623 62140 C/O
Planning Services 5C Comp Plan Community Engagement-Consultant (9,832) 102 1022623 62716 C/O
Planning Services 5C Comp Plan Community Engagement-Printing& Binding 1,694 102 1022623 62090 C/O
Personnel 60 Human Resources- Dental Insurance Premium 185,749 100 10072700 61411 Adjust to actual
Personnel 60 Human Resources-Self Insurance Premium 185,749 100 10072700 53550 Adjust to actual
Public Info-GIS 60 GIS Implementation-Consultant Services 9,970 100 10072300 62716 C/O
Public Info-GIS 60 GIS Training- Education &Training 6,750 100 10072300 62360 C/O
City Manager's Office 5C Neighborhood Grants-Grants 5,732 102 1021238 62765 C/O
City Manager's Office 60 Sustainability- Pay to Other Agency 16,007 100 10072200 62761 C/O
City Manager's Office 60 Sustainability-Special Events 4,900 100 10072200 62645 Adjust to actual
City Manager's Office 60 Sustainability- Miscellaneous Revenue 4,900 100 10072200 53605 Adjust to actual
Finance 6C Replacement of Radios-Radio Equipment 7,490 102 1022601 72410 C/O
Finance 60 Accounting/Payroll- Electric Franchise Refund 283,217 100 10074100 62214 C/O
Finance 60 Accounting/Payroll-Officer Bond (8,033) 100 10074100 62202 Prespend FY18
Information Services 6C Laserfche Full User License-Software 5,000 102 1022684 71123 C/O
Purchase of Services 50 Purchase of Services-Pay to Other Agency 39,690 100 10079450 62761 C/O
TOTAL GENERAL FUND 2,155,736 1,091,638
TRANSIT FUND
Transit Division 8C Replace Mini Buses-Equipment 29,175 600 6001222 73411 C/O
Transit Division 8C Bus Stop Improvements-Construction 5,028 600 6002235 73211 C/O
Transit Division 8C Bus Storage Facility-Construction (145,797) 600 6002446 73210 Prespend FY18
Transit Division 8C Bus Storage Facility-State Grants 572,181 600 6002446 45701 C/O
Transit Division 8C Bus Storage Facility- Fed Pass Thru Grants 2,063,587 600 6002446 45771 C/O
Transit Division 8C Portable Radio Replacements-GO Bond Proceeds 95,000 600 6002604 54210 Approved Budget
Transit Division 80 Transit Admin-Full-Time Employees 995 600 60053100 61010 Adjust to actual
Transit Division 80 Transit Admin-Vehicle Replacement 22,500 600 60053100 71312 C/O
Transit Division 80 Bus Operations-STA Special Project Grant 3,828 600 60053400 51726 C/O
Transit Division 80 Bus Administration- FY18 STA Grant (220,544) 600 60053100 45721 Adjust to actual
Transit Division 80 Bus Operations- FY18 STA Grant 124,626 600 60053400 45721 Adjust to actual
Transit Division 80 Mini Bus- FY18 STA Grant 70,810 600 60053500 45721 Adjust to actual
Page 3
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Transit Division 80 Trolley Operations- FY18 STA Grant 8,497 600 60053600 45721 Adjust to actual
Transit Division 80 Bus Maintenance-FY18 STA Grant 11,330 600 60053700 45721 Adjust to actual
Transit Division 80 Bus Administration- FY17 FTA Operating 66,468 600 60053100 44160 C/O
Transit Division 80 Bus Operations- FY17 FTA Operating 731,151 600 60053400 44160 C/O
Transit Division 80 Mini Bus- FY17 FTA Operating 465,278 600 60053500 44160 C/O
Transit Division 80 Bus Maintenance-FY17 FTA Operating 66,468 600 60053700 44160 C/O
TOTAL TRANSIT FUND (88,099) 4,058,680
DOWNTOWN LOAN POOL-TIF FUND
Economic Developmei 5C Downtown TIF Loan Pool- Loans 300,000 241 2411033 62764 C/O
Economic Developmei 5C Downtown Rehab Grant Program-Grants 80,197 241 2411942 62765 C/O
TOTAL DOWNTOWN LOAN POOL-TF FUND 380,197 -
ROAD USE TAX FUND
Public Works 20 Snow&Ice Control-Camera Related 8,520 250 25054420 72417 C/O
Public Works 20 Street and Traffic-Street Lighting 399,663 250 25054430 62419 C/O
Public Works 20 Street and Traffic-Street Lighting 250,000 250 25054430 62419 Adjust to actual
Public Works 2C Asphalt Milling Program-Construction 288,200 250 2501230 73211 C/O
Public Works 2C Dump Truck Replacement- Heavy Equipment 24,477 250 2502539 71318 C/O
Engineering 2C Brunskill Road Bridge Replacement-Construction 75,508 250 2501077 73211 C/O
Engineering 2C Brunskill Road Bridge Replacement- Fed Pass Thru 62,201 250 2501077 45771 C/O
Engineering 2C Railroad Crossing Improvement-Construction 36,031 250 2502026 73211 C/O
Engineering 2C ITS Traffic Control Equipment-Construction 20,500 250 2502253 73211 C/O
TOTAL ROAD USE TAX FUND 1,102,899 62,201
COMMUNITY DEVELOPMENT BLOCK GRANT FUND
Recreation 40 Senior Center-Pay to Other Agency 208 260 26079180 62761 CDBG Amend#1
Recreation 40 Neighborhood Recreation Program 1,098 260 26034500 62668 CDBG Amend#1
Engineering 2C Wheel Chair Ramps-Construction 51,035 260 2601236 73211 CDBG Amend#1
Engineering 2C Neighborhood Related Improvement-Construction 335,176 260 2601239 73211 CDBG Amend#1
Economic Developmei 5C Microenterprise Assistance-Loans 149,970 260 2602636 62764 CDBG Amend#1
Housing 5C Residential Rehab Program-Construction 187,586 260 2601065 73211 CDBG Amend#1
Housing 5C Purchase/Resale/Rehab-Construction 342,338 260 2601231 73111 CDBG Amend#1
Housing 50 CDBG Administration-CDBG Grant 59,648 260 26061800 44205 CDBG Amend#1
Housing 50 CDBG Administration-CDBG Grant 634,729 260 26061800 44205 CDBG Amend#1
Housing 50 CDBG Administration-CDBG Grant 963,306 260 26061800 44205 CDBG Amend#1
Housing 50 Housing Code Enforcement-Telephone 300 260 26061700 62421 CDBG Amend#1
Housing 50 Housing Administration-Subscriptions (142) 260 26061100 62421 CDBG Amend#1
Housing 50 Rehab Program-Court Costs (22) 260 26061300 62230 CDBG Amend#1
Housing 5C Lead Paint Abatement-Loans 16,650 260 2601232 62764 CDBG Amend#1
Housing 5C Rental Rehab Unit- Loans 125,724 260 2601233 62764 CDBG Amend#1
Housing 5C First Time Homebuyer-Loans 25,000 260 2601234 62764 CDBG Amend#1
Housing 5C Historic Preservation Grants-Loans 10,000 260 2601237 62764 CDBG Amend#1
Housing 5C Salvia House Elevator-Grants (8,250) 260 2602689 62765 CDBG Amend#1
Housing 2C Bee Branch Lead Waterline/Sewer-Grants 30,000 260 2602732 62765 CDBG Amend#1
Housing 2C Bee Branch Lead Waterline/Sewer-Grants 14,224 260 2602732 62765 CDBG Amend#1
City Manager's Office 50 Neighborhood Development-Zoning 8,710 260 26072800 62834 CDBG Amend#1
Purchase of Services 30 Purchase of Services-Pay to Other Agency 1,921 260 26079450 62761 CDBG Amend#1
Page 4
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
TOTAL COMMUNITY DEVELOPMENT BLOCK FUND 1,291,526 1,657,683
HUD RESILIENCY GRANT FUND
Housing 5C HUD Resiliency-Consulting Engineers (1,562,117) 264 2642690 62712 Prespend FY18
Housing 5C HUD Resiliency- Fed Pass Thru State 10,304 264 2642690 45771 C/O
TOTAL HUD RESILIENCY GRANT FUND (1,562,117) 10,304
UDAG FUND
Economic Developmei 5C Job Creation-Loans 21,480 265 2651246 62764 C/O
Economic Developmei 5C Historic Preservation Revolving Loan-Loans 75,797 265 2651247 62764 C/O
Economic Developmei 5C Historic Preservation Revolving Loan-Loans 11,014 265 2651247 62764 C/O
Economic Developmei 5C Airport Revenue Guarantee- Pay to Other Agency 150,000 265 2651796 62761 C/O
TOTAL UDAG FUND 258,291 -
HOUSING TRUST FUND
Housing 5C Housing Trust Fund- Pay to Other Agency 30,597 268 2681021 62761 C/O
Housing 5C Housing Trust Fund- Pay to Other Agency 36,762 268 2681021 62761 C/O
Housing 5C Housing Trust Fund- Pay to Other Agency 38,000 268 2681021 62761 C/O
Housing 5C Housing Trust Fund-Washington Neigh- Loans 348,599 268 2681021 62764 C/O
Housing 5C Housing Trust Fund-Washington Neigh- Loans 19,655 268 2681021 62764 C/O
Housing 5C Housing Trust Fund-Washington Neigh- Loans 20,183 268 2681021 62764 Adjust to actual
Housing 5C Housing Trust Fund-Washington Neigh- IFA 20,183 268 2681021 45703 Adjust to actual
Housing 5C Housing Trust Fund-Washington Neigh- IFA 323,269 268 2681021 45703 C/O
TOTAL HOUSING TRUST FUND 493,796 343,452
STATE RENTAL REHAB FUND
Housing 5C Residential Rehab Program-Construction 360,301 270 2701065 73211 C/O
Housing 50 Housing LHAP-Loans 51,868 270 27061320 62764 C/O
Housing 5C Home Rental-Construction 439,956 270 2701250 73210 C/O
TOTAL STATE RENTAL REHAB FUND 852,125 -
LEAD PAINT ABATEMENT
Housing 50 Lead Paint Program-Grants 39,979 275 27561211 44310 C/O
Housing 5C Lead Hazard Reduction Program- Loans 130,000 275 2752429 62765 Adjust to actual
Housing 5C Lead Hazard Reduction Program- Loans (110,462) 275 2752429 62764 Reduce Encumbrance Budget
Housing 5C Lead Hazard Reduction Program-Grants (17,173) 275 2752429 62765 Reduce Encumbrance Budget
Housing 50 Lead Hazard Reduction Program- Relocations (33,200) 275 27561211 73112 Reduce Encumbrance Budget
Housing 50 Lead Hazard Reduction Program- Education (1,095) 275 27561211 62360 Reduce Encumbrance Budget
Housing 50 Lead Hazard Reduction Program- Dust Wipes (346) 275 27561211 62729 Reduce Encumbrance Budget
Housing 5C Lead Hazard Reduction Program- Loans 48,044 275 2752429 62764 C/O
Housing 5C Lead Hazard Reduction Program-Construction 250 275 2752429 73112 C/O
Housing 5C Lead Hazard Reduction Program- HUD Payments 77,394 275 2752429 44310 C/O
TOTAL LEAD PAINT ABATEMENT 16,018 117,373
SECTION 8 FUND
Housing 50 Voucher HAP-Housing Assistance Payments (386,458) 280 28061601 62694 Prespend FY18
TOTAL SECTION 8 FUND (386,458) -
Page 5
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
LIBRARY TRUST FUND
Library 40 Maker Space Operations- Equipment 40 295 29536500 62668 Lost Equipment
TOTAL LIBRARY TRUST FUND 40 -
POLICE TRUST FUND
Police Department 10 1948 Stylemaster Trust-Vehicle Maintenance 5,583 297 29711100 62528 C/O
Police Department 10 Canine Trust-Other Police Equipment 28,373 297 29711500 72218 C/O
TOTAL POLICE TRUST FUND 33,956 -
STREET CONSTRUCTION FUND
Recreation 4C Marina Signage-Signage 29,163 300 3002692 71227 C/O
Public Works 2C Portable Radio Replacements-GO Bond Proceeds 103,649 300 3002604 54210 Approved Budget
Public Works 2C Concrete Section Repair- Engineering 5,000 300 3001006 62811 C/O
Public Works 2C Steps and Railings-Construction 2,760 300 3001432 73211 C/O
Public Works 2C Curb Replacement Program-Construction (11,422) 300 3001226 73211 Prespend FY18
Public Works 2C Curb Ramp Program-Construction 32,366 300 3001227 73211 C/O
Public Works 2C Asphalt Milling Program-Construction 10,240 300 3001230 73211 C/O
Public Works 2C Floodwall Post Flood Repair-Construction 5,550 300 3001445 73211 C/O
Public Works 2C Downtown Sign Post Replace-Signage 20,353 300 3001938 71227 C/O
Public Works 2C Wayfinding Sign Replacement-Signage 2,497 300 3002151 71227 C/O
Engineering 2C Guardrail Replacement-Construction 5,000 300 3001027 73211 C/O
Engineering 2C Corridor Study Alternatives-Consulting 1,050,000 300 3001039 62712 C/O
Engineering 2C Corridor Study Alternatives-Fed Pass Thru Grant 800,000 300 3001039 45771 C/O
Engineering 2C Curb Catch Basin Replacement-Construction 7,742 300 3001041 73211 C/O
Engineering 2C Grandview Avenue Light Poles-Construction 35,772 300 3001210 73211 C/O
Engineering 2C Grandview Avenue Light Poles-Equipment Acquisition 33,441 300 3001210 73410 C/O
Engineering 2C Special Assessment Assistance-Pay to Other Agency 72,000 300 3001256 62761 C/O
Engineering 2C Bridge Repairs/Maint-Construction 27,570 300 3001258 73211 C/O
Engineering 2C Southwest Arterial-Consultant Services 447,580 300 3001287 62716 C/O
Engineering 2C Southwest Arterial-Construction 6,329,245 300 3001287 73113 C/O
Engineering 2C Southwest Arterial-State Grants 4,174,700 300 3001287 45701 C/O
Engineering 2C Southwest Arterial- Fed Pass Thru Grant 10,984,864 300 3001287 45771 C/O
Engineering 2C Southwest Arterial-County Share 1,596,271 300 3001287 46205 C/O
Engineering 2C Sidewalk Program City Owned-Construction 3,096 300 3001425 73211 C/O
Engineering 2C Decorative Concrete Maintenance-Construction 71,287 300 3001630 73211 C/O
Engineering 2C White Water Creek Bridge- Lighting 10,000 300 3001634 62616 C/O
Engineering 2C White Water Creek Bridge- Private Participant 10,000 300 3001634 53102 C/O
Engineering 2C Crosswalk Warning Device- Private Participant (30,000) 300 3002246 53102 Received FY 2017
Engineering 2C LED Re-Lamp Schedule- Equipment 9,825 300 3001916 73410 C/O
Engineering 2C Safe Routes to School-Construction 10,000 300 3001922 73211 C/O
Engineering 2C N Cascade Road Reconstruct-Engineering 21,381 300 3002021 62811 C/O
Engineering 2C N Cascade Road Reconstruct-Construction 1,751,348 300 3002021 73211 C/O
Engineering 2C N Cascade Road Reconstruct-Fed Pass Thru Grant 1,356,800 300 3002021 45771 C/O
Engineering 2C Street Construction-General-Construction (4,103) 300 3002142 73211 Prespend FY18
Engineering 2C Pavement Marking-Construction (92,760) 300 3002245 73211 Prespend FY18
Engineering 2C Pavement Marking- IDOT (13,637) 300 3002245 45733 Received FY 2017
Engineering 2C Pennsylvania at Radford- Engineering 80,000 300 3002256 62811 C/O
Engineering 2C University&Asbury Intersection Improv-Construction 68,713 300 3002324 73211 C/O
Page 5
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering 2C University&Asbury Intersect Improv- Fed Pass Grant 117,475 300 3002324 45771 C/O
Engineering 2C N Grandview Estate Road-Engineering 15,000 300 3002336 62811 C/O
Engineering 2C N Grandview Estate Road-Construction 279,001 300 3002336 73211 C/O
Engineering 2C Grandview/Delhi Roundabout- Fed Pass thru 62,387 300 3002611 45771 C/O
Engineering 2C ROW Management-America's River Festival 34,626 300 3002613 53620 C/O
Engineering 2C ROW Management-Construction 30,551 300 3002613 73211 C/O
Engineering 2C Washington Neighborhood Street Lights-Construction 14,797 300 3002615 73211 C/O
Engineering 2C JFK Rd Coordination Wacker/Asbury-Construction 224,225 300 3002617 73211 C/O
Engineering 2C Stone Retaining Walls-Construction 10,677 300 3001029 73211 C/O
Engineering 2C Accessibility Barriers-Construction 17,333 300 3001034 73211 C/O
Engineering 2C Harbor Area Maintenance-Construction 35,000 300 3001466 73211 C/O
Engineering 2C Smarter Travel Project- Pay to Other Agency 16,863 300 3002634 62761 C/O
Engineering 2C Intersection Preemption-Equipment Acquisition 6,377 300 3001023 73410 C/O
Engineering 2C Traffic Signal Master arm Retrofit-Traffic Control 59,888 300 3001133 71411 C/O
Engineering 2C Traffic Controller Battery Pack-Equipment Acquisition 17,209 300 3001229 73410 C/O
Engineering 2C Traffic Signal Interconnect-Construction 3,997 300 3001266 73211 C/O
Engineering 2C Traffic Controller Replacement- Equipment 70,231 300 3001274 73410 C/O
Engineering 2C Street Light Replacement-Equipment 53,730 300 3001549 73410 C/O
Engineering 2C Signal Intersection Reconstruction-Construction 8,233 300 3001615 73211 C/O
Engineering 2C Traffic Signal Fiber Optic-Construction 43,296 300 3001631 73211 C/O
Engineering 2C Traffic Consultant Services-Consultant Services 4,875 300 3001815 62716 C/O
Engineering 2C Traffic Signal Video Detection-Traffic Equipment 7,749 300 3001816 71411 C/O
Engineering 2C Fiber Optic Misc.-Traffic Equipment 32,902 300 3002144 71411 C/O
Engineering 2C Street Light Signal Knockdown-Construction (1,154) 300 3002252 73211 Prespend FY18
Engineering 2C Surge and Ground Improvements-Equipment 25,263 300 3002420 73410 C/O
Engineering 2C Traffic Operations Center Video-Software 38,660 300 3002422 71123 C/O
Engineering 2C Traffic Ops Center Test Equip-Software 29,231 300 3002423 71123 C/O
Engineering 2C LED Streetlight Retrofit- Equipment 5,381 300 3002484 73410 C/O
Engineering 2C Fiber Optics to Airport- Equipment 20,464 300 3002491 73411 C/O
Engineering 2C Flashing Yellow Left Turn- Lighting 22,500 300 3002557 71517 C/O
Engineering 2C Replacement LED Signs Beacons- Lighting 15,920 300 3002558 71517 C/O
Engineering 2C Grandview Signal Reconstruction-Construction 6,515 300 3002559 73211 C/O
Engineering 2C West Locust Communication/Cameras 43,094 300 3002618 73211 C/O
Engineering 2C Fiber/Network Management Program-Software 30,588 300 3002620 71123 C/O
Engineering 2C New Street Lights City-Wide-Construction 7,428 300 3002672 73211 C/O
TOTAL STREET CONSTRUCTION FUND 11,229,468 19,197,135
DICW CIP REPLACEMENT FUND
Park Division 4C DICW CIP Replacement- Playground Equipment 16,539 325 3252568 72713 C/O
TOTAL DICW CIP REPLACEMENT FUND 16,539 -
SALES TAX INCREMENT CONSTRUCTION FUND
Engineering 8C Bee Branch Alignment-Construction 1,480,996 340 3401654 73211 C/O
Engineering 8C Gate Replacement Flood Mitigation-Construction 1,967,008 340 3402608 73211 C/O
Engineering 8C Flood Control Maintenance Facility-Consulting 200,000 340 3402609 62712 C/O
Engineering 8C Flood Control Maintenance Facility-Land Acquisition 742,833 340 3402609 73110 C/O
TOTAL SALES TAX INCREMENT CONSTRUCTION FUI 4,390,837 -
Page 7
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
SALES TAX FUND(20%)
Police Department 1C CJISI-Software 75,000 350 3502503 71123 C/O
Fire Department 1C Mechanical/Electrical System-Consultant 5,463 350 3502575 62716 C/O
Fire Department 1C Breathing Air Comp Filter-Air Masks 79,663 350 3501553 72110 C/O
Fire Department 1C Ambulance Replacement- Heavy Equipment 23,417 350 3502507 71318 C/O
Park Division 4C Northend Trail Lighting-Construction 31,227 350 3501129 73211 C/O
Park Division 4C Ham House Improvements-Construction 66,871 350 3501212 73210 C/O
Park Division 4C Street Tree Program-Tree Planting 16,003 350 3501458 73311 C/O
Park Division 4C Slattery Center-Construction 10,495 350 3501468 73210 C/O
Park Division 4C Comiskey Park- New Entry-Construction 30,270 350 3501544 73211 C/O
Park Division 4C Comiskey Park Amenities-Construction 59,837 350 3501578 73211 C/O
Park Division 4C Plan Hwy 20 Roses-Landscaping 35,000 350 3501588 73310 C/O
Park Division 4C Flora Restroom-Consultant Services 10,300 350 3501767 62716 C/O
Park Division 4C Flora Restroom-Construction 72,558 350 3501767 73210 C/O
Park Division 4C Flora Playground Improvements-Equipment 30,461 350 3502377 73410 C/O
Park Division 4C Skate Park-Construction 773,723 350 3502461 73211 C/O
Park Division 4C Skate Park- Private Participant 185,000 350 3502461 43102 C/O
Park Division 4C Skate Park- Bond Proceeds 547,471 350 3502461 54210 C/O
Park Division 4C EPP Riverfront Pavilion-Construction 57,143 350 3502508 73210 C/O
Park Division 4C EP Bridge Complex Roof-Consulting Engineers 2,000 350 3502509 62712 C/O
Park Division 4C EP Bridge Complex Roof-Construction 50,879 350 3502509 73210 C/O
Park Division 4C Replace Interpretive Signs-Signage 16,000 350 3501774 71227 C/O
Park Division 4C Flora Pave Lots-Consulting Engineers 6,000 350 3501557 62712 C/O
Park Division 4C Flora Pave Lots-Construction 29,000 350 3501557 73211 C/O
Civic Center Division 4C Five Flags market Study-Private Participant 30,000 350 3502584 53102 C/O
Civic Center Division 4C Accessibility Building Modification-Consulting 1,568 350 3502647 62712 C/O
Grand River Center 4C GRC Replace Patio Caulk-Construction 20,000 350 3502649 73211 C/O
Grand River Center 4C GRC Tech Replacement Support-Wireless 10,958 350 3502519 71120 C/O
Grand River Center 4C GRC Chairs-Side-Chairs 60,336 350 3501990 71212 C/O
Grand River Center 4C GRC-Paint Entrance-Construction 5,000 350 3501993 73210 C/O
Grand River Center 4C GRC Outdoor Furniture-Furniture 2,244 350 3502306 71156 C/O
Grand River Center 4C GRC Paint Rooms-Construction 5,165 350 3502391 73210 C/O
Grand River Center 4C GRC Landscaping-Construction 14,480 350 3502591 73210 C/O
Recreation 4C F&S Pool Heaters-Construction 31,000 350 3501446 73210 C/O
Recreation 4C Golf Course Irrigation-Construction 4,139 350 3501530 73211 C/O
Library 4C HVAC Handling Units-HVAC 22,524 350 3502521 71520 C/O
Library 4C Library Generator-Consulting 5,000 350 3502652 62712 C/O
Library 4C Library Generator-Construction 55,000 350 3502652 73210 C/O
Public Works 2C Mooring Dolphin Install- Engineering 15,917 350 3502605 62811 C/O
Engineering 6C Federal Building Renovation-Construction 181,295 350 3501841 73210 C/O
Engineering 6C Federal Building Renovation- HVAC 5,525 350 3501841 71520 Shift from City Hall Remodel
Engineering 2C Sidewalk Financial Assistance- Pay to Other Agency 12,451 350 3501727 62761 C/O
Engineering 2C N Cascade Road Reconstruct-Consulting 97,494 350 3502021 62712 C/O
Engineering 2C N Cascade Road Reconstruct-Land Acquisition 318,000 350 3502021 73110 C/O
Engineering 2C N Cascade Road Reconstruct-Construction 1,296,008 350 3502021 73211 C/O
Engineering 2C N Cascade Road Reconstruct-Fed Pass Thru Grant 1,203,000 350 3502021 45771 C/O
Engineering 2C Stone Retaining Walls-Construction 83,881 350 3501029 73211 C/O
Engineering 2C Accessibility Barriers-Construction 18,170 350 3501034 73210 C/O
Page 8
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering 2C Rehab RR Track-Construction 16,590 350 3501465 73211 C/O
Engineering 2C Harbor Area Maintenance-Construction 31,292 350 3501466 73211 C/O
Engineering 2C Chavenelle Trail- IDOT Reimbursement 42,555 350 3502642 45733 C/O
Engineering 5C Trails/Complete Streets- REAP Grant 124,278 350 3502430 45707 C/O
Engineering 5C Trails/Complete Streets-Construction 80,037 350 3502430 73210 C/O
Building Services 6C City Hall Remodeling-Construction 150,993 350 3501045 73210 C/O
Building Services 6C City Hall Remodeling-Construction (80,000) 350 3501045 73210 Shift to Federal Building HVAC
Economic Developmei 5C Economic Development Software-Software 20,000 350 3502680 71123 C/O
Planning Services 5C Kiosk Map Replacements-Consulting 1,000 350 3502433 62712 C/O
Planning Services 5C Kiosk Map Replacements-Construction 4,000 350 3502433 73211 C/O
Public Info-GIS 6C Augmented Data Support Services-Consultant Services 33,679 350 3502624 62716 C/O
Public Info-GIS 6C Geoevent Processor Ext-Servers 6,425 350 3502625 71125 C/O
Public Info-GIS 6C GIS Implementation-Consultant Services 41,713 350 3501070 62716 C/O
City Manager's Office 6C Greenhouse Gas Inventory-Consultant Services 25,000 350 3502682 62716 C/O
City Manager's Office 6C Energy Efficiency Revolving Fund-Loans 20,000 350 3502681 62764 C/O
Information Services 6C Novell File Management Suite-Software 26,475 350 3502628 71123 C/O
Information Services 6C 10 GBE Network Card Cable-Software 17,255 350 3502565 71123 C/O
TOTAL SALES TAX FUND 4,141,924 2,132,304
GENERAL CONSTRUCTION FUND
Park Division 4C Comiskey Landscape-Construction 50,000 360 3601105 73210 C/O
Park Division 4C Comiskey Park Amenities-Construction (59,595) 360 3601578 73410 Eliminate duplicate
Park Division 4C Replace Park Signs DICW-Signage 10,000 360 3601774 71227 C/O
Park Division 4C McAleece Sidewalks-Construction 20,439 360 3602374 73211 C/O
Park Division 4C Relandscape Seippel/Chavenelle- Landscape 25,000 360 3602645 62637 C/O
Park Division 4C Relandscape Seippel/Chavenelle-Consultant 3,307 360 3602645 62712 C/O
Park Division 4C Comiskey Park New Entrance-Construction (30,147) 360 3602711 73211 Eliminate duplicate
Civic Center Division 4C Arena Roof A/C Unit-Construction 150,000 360 3602583 73210 C/O
Civic Center Division 4C Arena Roof A/C Unit-Bond Proceeds 150,000 360 3602583 54210 C/O
Parking 8C Millwork District Parking-Construction 994,744 360 3602250 73211 C/O
Transit Division 8C Bus Storage Facility-Construction 184,606 360 3602446 73210 C/O
Transit Division 8C Bus Storage Facility-GO Bond Proceeds (261,240) 360 3602446 54210 Reduce to approved budget
Transit Division 8C Bus Storage Facility- Fed Pass Thru Grants 217,500 360 3602446 45771 C/O
Engineering 2C Chavenelle Trail-Consulting 129,330 360 3602273 62712 C/O
Engineering 2C Chavenelle Trail- Land Acquisition 115,500 360 3602273 73110 C/O
Engineering 2C Chavenelle Trail-Construction 1,148,500 360 3602273 73211 C/O
Engineering 2C Chavenelle Trail- REAP Grant 175,000 360 3602273 45707 C/O
Engineering 2C Chavenelle Trail- Fed Pass Thru Grant 1,149,040 360 3602273 45771 C/O
Engineering 2C 18th St Wall Reconstruction-Construction 5,207 360 3602481 73211 C/O
Engineering 2C Washington 8th to 9th-Construction 651,495 360 3602552 73211 C/O
Engineering 2C 11th St Stairs Reconstruction-Construction 69 360 3602554 73211 C/O
Engineering 2C Riverfront Leasehold Improvement-Construction 258,095 360 3601053 73211 C/O
Engineering 2C DT Security Cameras-Cameras 107,498 360 3602494 72417 C/O
Engineering 2C Downtown Streetlights-Construction 24,857 360 3602671 73211 C/O
Engineering 2C Downtown Security Cameras 10,000 360 3602677 73410 C/O
Economic Developmei 5C Downtown Housing Incentives-Grants 57,798 360 3602267 62765 C/O
Economic Developmei 5C Washington Neighborhood Business Incent-Grants 5,000 360 3602436 62765 C/O
Economic Developmei 5C Future Industrial Acquisitions-Land Acquisitions 88,808 360 3602437 73110 C/O
Page 9
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Economic Developmei 5C Washington Neighborhood Downtown Incent-Grants 48,615 360 3602438 62765 C/O
Economic Developmei 5C Central Avenue Corridor-Consultant 19,447 360 3602679 62716 C/O
Housing 5C Homeownership Grants- Property Maintenance 1,503 360 3601595 62431 C/O
Housing 5C Homeownership Grants- Loans 70,294 360 3601595 62764 C/O
Housing 5C Homeownership Grants- Pay to Other Agency (38,000) 360 3601595 62761 Shift to 2681021
Housing 5C Homeownership Grants-Grants 13,238 360 3601595 62765 C/O
Housing 5C Homeownership Grants- Land Acquisition 124,153 360 3601595 73111 C/O
Housing 5C Homeownership Grants-Construction 301,752 360 3601595 73210 C/O
Housing 5C Homeownership Grants-Construction (153,332) 360 3601595 73210 Adjust to actual
Housing 5C CHI-Pay to Other Agency 130 360 3602573 62761 C/O
TOTAL GENERAL CONSTRUCTION FUND 4,338,311 1,430,300
GOLF CONSTRUCTION FUND
Recreation 4C Bunker Clubhouse Repairs-Construction 2,445 370 3702195 73210 C/O
TOTAL GOLF CONSTRUCTION FUND 2,445 -
AIRPORT CONSTRUCTION FUND
Airport 2C Airport Rental Car Lot-Construction 209,955 390 3902731 73211 C/O
Airport 2C Pavement Condition Index-Consulting 892 390 3901060 62712 C/O
Airport 2C Pavement Condition Index-FAA Funds 45,180 390 3901060 44105 C/O
Airport 2C Airport Improvements-Consulting 38,830 390 3901723 62712 C/O
Airport 2C New Terminal Site Work-Construction (72,952) 390 3902009 73211 Reduce Encumbrances
Airport 2C Construct Terminal Apron-Construction (27,624) 390 3902316 73211 Reduce Encumbrances
Airport 2C New Terminal Design& Build-Consulting Engineers (654) 390 3902213 62712 Reduce Encumbrances
Airport 2C New Terminal Utilities-Consulting Engineers (14,357) 390 3902010 62712 Reduce Encumbrances
Airport 2C Hanger Repairs-Construction 6,315 390 3902008 73210 C/O
Airport 2C Terminal Sitework- Damage Claims 1,103,788 390 3902009 62221 C/O
Airport 2C Terminal Sitework- FAA Funds 788,868 390 3902009 44105 C/O
Airport 2C Onsite Water&Wastewater-Consulting 4,020 390 3902011 62712 C/O
Airport 2C Onsite Water&Wastewater-FAA funds 3,585 390 3902011 44105 C/O
Airport 2C Paint Hangar Exteriors-Construction 10,319 390 3902125 73210 C/O
Airport 2C Boiler Replacement 38,000 390 3902126 73210 C/O
Airport 2C Replace Runway Regulators-Construction 35,026 390 3902215 73211 C/O
Airport 2C ADF Containment-Consultant Services 79,459 390 3902448 62716 C/O
Airport 2C Electronic Fuel Tank Gauge-construction 25,000 390 3902602 73211 C/O
Airport 2C Decommission Airport Lagoon-Construction 34,180 390 3902660 73211 C/O
Airport 2C FBO Restroom Update-Construction 11,845 390 3902661 73210 C/O
Airport 2C Airport Storm Drain-Construction 14,299 390 3902662 73210 C/O
Airport 2C Airport Asphalt Repair-Construction 53,921 390 3902664 73211 C/O
Airport 2C New Terminal Furnishings- Misc. Office Equipment 4,455 390 3902531 71110 C/O
Airport 2C New Terminal Passenger Bridge-Construction 44,454 390 3902532 73211 C/O
Airport 2C New Terminal Passenger Bridge- FAA Funds 74,201 390 3902532 44105 C/O
Airport 2C New Terminal Landscaping 47,857 390 3902535 62712 C/O
TOTAL AIRPORT CONSTRUCTION FUND 1,647,028 911,834
SANITARY OPERATING FUND
W&RRC 80 Administration-Consultant 20,000 610 61043100 62712 C/O
TOTAL SANITARY OPERATING FUND 20,000 -
Page 10
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
WATER OPERATING FUND
Water 80 Meters-Vehicle Replacement 70,000 640 64042300 71312 C/O
Water 80 Water Distribution-Vehicle Replacement 70,000 640 64042700 71314 C/O
Water 80 Water Distribution-Trailer 8,000 640 64042700 71328 C/O
Finance 8C Meter Service-Radio Equipment 6,490 640 64074710 72410 C/O
TOTAL WATER OPERATING FUND 154,490 -
AMERICA'S RIVER PROJECT FUND
Economic Developmei 5C Art in Port of Dubuque- Miscellaneous 34,157 700 7001853 62731 C/O
TOTAL AMERICA'S RIVER PROJECT FUND 34,157 -
SANITARY SEWER CONSTRUCTION FUND
W&RRC 8C Alternative Oxygen Study-Consulting (121,851) 710 7101730 62712 Adjust to actual
W&RRC 8C WRR Plant Renovation-Construction 35,047 710 7101837 73210 C/O
W&RRC 8C HS Waste Receive&Store-Construction 76,036 710 7102701 73211 C/O
W&RRC 8C Frack Tank- Equipment Acquisition 3,875 710 7102730 73410 C/O
W&RRC 8C Bradley Force Main -Consulting 5,045 710 7102474 62712 C/O
W&RRC 8C Bradley Force Main -Construction 90,000 710 7102474 73211 C/O
W&RRC 8C Clarifier Realign/Repair-Construction 44,924 710 7102598 73210 C/O
W&RRC 8C Kerper Pump Motor/Control-Construction 35,000 710 7102599 73210 C/O
W&RRC 8C Replacement Radios-Radio Equipment 6,785 710 7102601 72410 C/O
W&RRC 8C Ash Pond Abandonment-Construction 117,466 710 7102697 73211 C/O
Engineering 8C Sewer Connection Assist-Grants 27,456 710 7101067 62765 C/O
Engineering 8C I&I Reduction Program-Construction 8,838 710 7101294 73211 C/O
Engineering 8C I&I Reduction Program-Software (4,197) 710 7101294 71123 Reduce Encumbrances
Engineering 8C I&I Reduction Program-Consultant (10,595) 710 7101294 62716 Reduce Encumbrances
Engineering 8C Lateral Replacement Assistance- Engineering 23,332 710 7101297 62811 C/O
Engineering 8C Sewer Lateral Assistance- Engineering 46,448 710 7101309 62811 C/O
Engineering 8C Sewer Lateral Assistance-Construction 49,056 710 7101309 73211 C/O
Engineering 8C Laterals I&I Reduction- Engineering 10,000 710 7101320 62811 C/O
Engineering 8C Laterals I&I Reduction- Engineering 40,042 710 7101320 73211 C/O
Engineering 8C Sanitary Sewer Manhole Replacement-Construction 286,245 710 7101335 73211 C/O
Engineering 8C Sanitary Sewer Manhole Replacement-SRF Loan (216,000) 710 7101335 54230 Eliminate debt
Engineering 8C Sewer Extensions- New Develop-Const 200,958 710 7101350 73211 C/O
Engineering 8C Sanitary Sewer Lining-Construction 297,542 710 7101637 73211 C/O
Engineering 8C Street Related Sanitary-Construction 10,000 710 7101638 73211 C/O
Engineering 8C Monroe St Sewer-Construction 6,947 710 7101797 73211 C/O
Engineering 8C Hawthorne Sanitary Sewer- Engineering 4,000 710 7102322 62811 C/O
Engineering 8C Hawthorne Sanitary Sewer-Construction 15,359 710 7102322 73211 C/O
Engineering 8C Relocation 30" Force Main-Construction 958,586 710 7102413 73211 C/O
Engineering 8C Relocation 30" Force Main-SRF Loan Proceeds 665,000 710 7102413 54230 C/O
Engineering 8C $9.4 Green Alleys-Construction 223,048 710 7102450 73211 C/O
Engineering 8C $9.4 Green Alleys-SRF Loan Proceeds 1,279,591 710 7102450 54230 C/O
Engineering 8C Washington Sanitary 7th to 9th-Engineering 46,475 710 7102547 62811 C/O
Engineering 8C Washington Sanitary 7th to 9th-Construction 214,684 710 7102547 73211 C/O
Engineering 8C Cedar/Terminal Assessments-Construction 7,869 710 7102606 73211 C/O
Engineering 8C Kerper Sanitary-Construction 3,200,000 710 7102663 73211 C/O
Page 11
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering 8C Kerper Sanitary-SRF Loan 3,200,000 710 7102663 54230 C/O
Engineering 8C Kerper Sanitary-Construction 688,875 710 7102663 73211 C/O
Engineering 8C Kerper Sanitary-Consulting (25,323) 710 7102663 62712 Reduce Encumbrances
Engineering 8C Methane Gas-General Reimbursements 4,965 710 7102698 53620 Reimbursement
Engineering 8C 30th &Jackson Sanitary Sewer-SRF Loan Proceeds (170,000) 710 7102720 54230 Eliminate debt
Engineering 8C 30th &Jackson Sanitary Sewer-Construction 35 710 7102720 73211 C/O
Engineering 8C Coates Sanitary Sewer-Construction 57,141 710 7102728 73211 C/O
Engineering 8C Derby Grange Annexation-Construction 924,362 710 7102729 73211 C/O
TOTAL SANITARY SEWER CONST FUND 7,599,510 4,763,556
STORM WATER CONSTRUCTION FUND
Park Division 4C EPP Storm Sewer-Construction 71,917 720 7202301 73211 C/O
Public Works 2C Purina Drive Floodwall-Consulting 5,000 720 7202480 62712 C/O
Public Works 2C Purina Drive Floodwall-Construction 12,400 720 7202480 73211 C/O
Public Works 2C Concrete Section Repair-Construction 24,375 720 7202480 73211 C/O
Engineering 8C Storm General Repairs-Construction 85,225 720 7201066 73211 C/O
Engineering 8C Kaufmann Ave Storm- Engineering 2,000 720 7201085 62811 C/O
Engineering 8C Kaufmann Ave Storm- Land Acquisition 3,000 720 7201085 73110 C/O
Engineering 8C Bee Branch Alignment- EDA Grant 169,697 720 7201654 44115 C/O
Engineering 8C Bee Branch Alignment-State Grants 5,001 720 7201654 45701 C/O
Engineering 8C Bee Branch Alignment-Vision Iowa Grant 443,839 720 7201654 45761 C/O
Engineering 8C Bee Branch Alignment- Federal Pass Thru Grant 205,728 720 7201654 45771 C/O
Engineering 8C Bee Branch Alignment-SRF Loan 1,330,000 720 7201654 54230 C/O
Engineering 8C Villa St Storm Sewer-Construction 22,439 720 7201809 73211 C/O
Engineering 8C Catfish Creek Watershed Partnership-Construction 1,300,570 720 7202331 73211 C/O
Engineering 8C Catfish Creek Watershed Partnership-State Grants 1,400,000 720 7202331 45701 C/O
Engineering 8C Washington St Sanitary 7th to 9th- Engineering 5,000 720 7202547 62811 C/O
Engineering 8C Washington St Sanitary 7th to 9th-Construction 33,456 720 7202547 73211 C/O
Engineering 8C Flood Control Maintenance Facility-Federal Grant 400,000 720 7202609 44170 C/O
Engineering 8C Avoca Storm Improvement-Construction 40,917 720 7202667 73211 C/O
Engineering 8C SW Arterial/Menard Utility Relocate- Fed Pass Thru 450,544 720 7202669 45771 C/O
Engineering 8C SW Arterial HWY 20 Utility Relocate- Fed Pass Thru 10,000 720 7202670 45771 C/O
TOTAL STORM WATER CONST FUND 1,606,299 4,414,809
PARKING CONSTRUCTION FUND
Parking 8C Major Maintenance on Ramps-Construction 82,802 730 7301385 73210 C/O
Parking 8C Parking Ramp OCC Cert-Consulting 36,435 730 7302046 62712 C/O
Parking 8C Port of Dubuque Ramp Maint-Construction 330,207 730 7302162 73211 C/O
TOTAL PARKING CONSTRUCTION FUND 449,444 -
WATER CONSTRUCTION FUND
Water 8C Roosevelt Rd Extension-Construction 1,076,619 740 7401672 73211 C/O
Water 8C Online Process Analyzer-Equipment 15,201 740 7402524 73410 C/O
Water 8C Generator-Construction 121,098 740 7402527 73211 C/O
Water 8C SW Arterial Main Ext-Construction 453,364 740 7402594 73211 C/O
Water 8C SW Arterial Main Ext- DMATS 2,160,000 740 7402594 45771 C/O
Water 8C Creek Crossing-Consultant 22,764 740 7402595 62716 C/O
Water 8C Creek Crossing-Construction 24,591 740 7402595 73211 C/O
Page 12
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Water 8C Main Relate Sewer Manhole-Construction 20,267 740 7402596 73211 C/O
Water 8C Lime Slaker Replace Study-Consultant 10,000 740 7402653 62716 C/O
Water 8C Fire Hydrant Assembly- Equipment 12,000 740 7402654 73410 C/O
Water 8C Main Water Main- Retaining Wall 20,000 740 7402655 73211 C/O
Water 8C Water Main Upgrades-Street-Consulting 2,500 740 7402657 62712 C/O
Water 8C Water Main Upgrades-Street-Construction 17,500 740 7402657 73211 C/O
Water 8C Water Main Replacement-Sewer Const-Construction 241,738 740 7402658 73211 C/O
Water 8C West Rural Water Purchase-Consultant (245,279) 740 7402703 62716 Pre-Spend FY18
Water 8C Timber Ridge/Rustic Point Water-Construction 177,905 740 7402704 73211 C/O
Water 8C Grandview/Loras Intersection-Construction 57,670 740 7402705 73211 C/O
TOTAL WATER CONSTRUCTION FUND 2,027,938 2,160,000
GARAGE INTERNAL SERVICE FUND
Public Works 20 Public Works Garage-Vehicle Hoist 29,000 810 81054600 71535 C/O
TOTAL GARAGE INTERNAL SERVICE FUND 29,000 -
LANDFILL FUND
Public Works 80 Landfill Operations- Full-Time Employees (2,398) 940 94054200 61010 Adjust to actual
Public Works 9C Short-Term Facilities-Consultant Services 785,809 940 9402685 62716 C/O
Public Works 9C Cell 9 Phase 3-Construction 2,009,598 940 9402702 73211 C/O
Landfill 9C Landfill Environmental Management-Construction 44,393 940 9402268 73211 C/O
TOTAL LANDFILL FUND 2,837,402 -
TRANSFERS Transfer Out Transfer In
Park Division Trans1 Transfer from GDTIF fund to General Const. Fund 50,000 240 24060240 91360 Transfer of Funds
Park Division Trans1 Transfer from GDTIF fund to General Const. Fund 50,000 360 3601105 59240 Transfer of Funds
Park Division Trans2 Transfer from GDTIF Fund to General Const Fund (59,565) 240 24060240 91360 Transfer of Funds
Park Division Trans2 Transfer from GDTIF Fund to General Const Fund (59,565) 360 3601578 59240 Transfer of Funds
Park Division Trans3 Transfer from DICW Fund to General Const Fund 10,000 210 21060210 91360 Transfer of Funds
Park Division Trans3 Transfer from DICW Fund to General Const Fund 10,000 360 3601774 59210 Transfer of Funds
Park Division Trans4 Transfer from General Const Fund to General Fund 200,665 360 36010360 91102 Transfer of Funds
Park Division Trans4 Transfer from General Const Fund to General Fund 200,665 102 1022292 59360 Transfer of Funds
Park Division Trans5 Transfer from N Cascade to General Construction 150,000 215 21560215 91360 Transfer of Funds
Park Division Trans5 Transfer from N Cascade to General Construction 150,000 360 3602375 59215 Transfer of Funds
Park Division Trans6 Transfer from DICW Fund to General Const Fund 28,307 210 21060210 91360 Transfer of Funds
Park Division Trans6 Transfer from DICW Fund to General Const Fund 28,307 360 3602645 59210 Transfer of Funds
Park Division Trans7 Transfer from GDTIF Fund to General Const Fund (30,147) 240 24060240 91360 Transfer of Funds
Park Division Trans7 Transfer from GDTIF Fund to General Const Fund (30,147) 360 3602711 59240 Transfer of Funds
Airport Trans8 Transfer from Customer Facility to Airport Construction 209,955 252 25210252 91390 Transfer of Funds
Airport Trans8 Transfer from Customer Facility to Airport Construction 209,955 390 3902731 59252 Transfer of Funds
Airport Trans9 Transfer from General Fund to Airport Construction 4,262 102 10210102 91390 Transfer of Funds
Airport Trans9 Transfer from General Fund to Airport Construction 4,262 390 3901060 59102 Transfer of Funds
Airport Trans10 Transfer from Sales Tax Fund to Airport Construction 1,650 350 35010350 91390 Transfer of Funds
Airport Trans10 Transfer from Sales Tax Fund to Airport Construction 1,650 390 3901060 59350 Transfer of Funds
Airport Trans11 Transfer from Sales Tax Fund to Airport Construction 11,821 350 35010350 91390 Transfer of Funds
Airport Trans11 Transfer from Sales Tax Fund to Airport Construction 11,821 390 3901448 59350 Transfer of Funds
Airport Trans12 Transfer from General Fund to Airport Construction 38,830 350 35010350 91390 Transfer of Funds
Airport Trans12 Transfer from General Fund to Airport Construction 38,830 390 3901723 59350 Transfer of Funds
Page 13
FISCAL YEAR 2018 AMENDMENT#1 CIN COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Airport Trans14 Transfer from Sales Tax Fund to Airport Construction 684 350 35010350 91390 Transfer of Funds
Airport Trans14 Transfer from Sales Tax Fund to Airport Construction 684 390 3901893 59350 Transfer of Funds
Airport Trans15 Transfer from Sales Tax Fund to Airport Construction 7,888 350 35010350 91390 Transfer of Funds
Airport Trans15 Transfer from Sales Tax Fund to Airport Construction 7,888 390 3902008 59350 Transfer of Funds
Airport Trans16 Transfer from Customer Facility Fund to Airport Const 89,374 252 25251400 91390 Transfer of Funds
Airport Trans16 Transfer from Customer Facility Fund to Airport Const 89,374 390 3902009 59252 Transfer of Funds
Airport Trans17 Transfer from Sales Tax Fund to Airport Construction 226,291 350 35010350 91390 Transfer of Funds
Airport Trans17 Transfer from Sales Tax Fund to Airport Construction 226,291 390 3902009 59350 Transfer of Funds
Airport Trans18 Transfer from Sales Tax Fund to Airport Construction 10,319 350 35010350 91390 Transfer of Funds
Airport Trans18 Transfer from Sales Tax Fund to Airport Construction 10,319 390 3902125 59350 Transfer of Funds
Airport Trans19 Transfer from Sales Tax Fund to Airport Construction 38,000 350 35010350 91390 Transfer of Funds
Airport Trans19 Transfer from Sales Tax Fund to Airport Construction 38,000 390 3902126 59350 Transfer of Funds
Airport Trans20 Transfer from Sales Tax Fund to Airport Construction 35,000 350 35010350 91390 Transfer of Funds
Airport Trans20 Transfer from Sales Tax Fund to Airport Construction 35,000 390 3902215 59350 Transfer of Funds
Airport Trans21 Transfer from General Fund to Airport Construction 25,000 102 10210102 91390 Transfer of Funds
Airport Trans21 Transfer from General Fund to Airport Construction 25,000 390 3902602 59102 Transfer of Funds
Airport Trans22 Transfer from Sales Tax Fund to Airport Construction 35,000 350 35010350 91390 Transfer of Funds
Airport Trans22 Transfer from Sales Tax Fund to Airport Construction 35,000 390 3902660 59350 Transfer of Funds
Airport Trans23 Transfer from Sales Tax Fund to Airport Construction 11,845 350 35010350 91390 Transfer of Funds
Airport Trans23 Transfer from Sales Tax Fund to Airport Construction 11,845 390 3902661 59350 Transfer of Funds
Airport Trans24 Transfer from Sales Tax Fund to Airport Construction 15,736 350 35010350 91390 Transfer of Funds
Airport Trans24 Transfer from Sales Tax Fund to Airport Construction 15,736 390 3902662 59350 Transfer of Funds
Airport Trans25 Transfer from General Fund to Airport Construction 70,483 102 10210102 91390 Transfer of Funds
Airport Trans25 Transfer from General Fund to Airport Construction 70,483 390 3902664 59102 Transfer of Funds
Airport Trans26 Transfer from Sales Tax Fund to Airport Construction 47,857 350 35010350 91390 Transfer of Funds
Airport Trans26 Transfer from Sales Tax Fund to Airport Construction 47,857 390 3902535 59350 Transfer of Funds
Transit Division Trans27 Transfer from Sales Tax Fund to Transit Fund 29,175 350 35010350 91600 Transfer of Funds
Transit Division Trans27 Transfer from Sales Tax Fund to Transit Fund 29,175 600 6001222 59350 Transfer of Funds
Transit Division Trans28 Transfer from Sales Tax Fund to Transit Fund 20,000 350 35010350 91600 Transfer of Funds
Transit Division Trans28 Transfer from Sales Tax Fund to Transit Fund 20,000 600 6002235 59350 Transfer of Funds
Transit Division Trans29 Transfer from GDTIF fund to General Construction 195,267 360 3602446 59240 Transfer of Funds
Transit Division Trans29 Transfer from GDTIF fund to General Construction 195,267 240 24060240 91360 Adjust to actual
Transit Division Trans30 Transfer from General Fund to Transit Fund 601 600 60010600 59100 Adjust to actual
Transit Division Trans30 Transfer from General Fund to Transit Fund 601 100 10010100 91600 Adjust to actual
Engineering Trans31 Transfer from General Fund to Sanitary 22,801 101 10110101 91710 Transfer of Funds
Engineering Trans31 Transfer from General Fund to Sanitary 22,801 710 7101067 59101 Transfer of Funds
Engineering Trans32 Transfer from General Fund to Sanitary 1,876 102 10210102 91710 Transfer of Funds
Engineering Trans32 Transfer from General Fund to Sanitary 1,876 710 7101067 59102 Transfer of Funds
Engineering Trans33 Transfer from Road Use Tax to Street Const. Fund 478,799 250 25010250 91300 Transfer of Funds
Engineering Trans33 Transfer from Road Use Tax to Street Const. Fund 478,799 300 3002021 59250 Transfer of Funds
Engineering Trans34 Transfer from DICW fund to Street Const. Fund 112,260 210 21060210 91360 Transfer of Funds
Engineering Trans34 Transfer from DICW fund to Street Const. Fund 112,260 360 3602273 59210 Transfer of Funds
Engineering Trans35 Transfer from GDTIF fund to General Construction 258,124 240 24060240 91360 Transfer of Funds
Engineering Trans35 Transfer from GDTIF fund to General Construction 258,124 360 3601053 59240 Transfer of Funds
Engineering Trans36 Transfer from GDTIF fund to General Construction 204,315 240 24060240 91360 Transfer of Funds
Engineering Trans36 Transfer from GDTIF fund to General Construction 204,315 360 3602494 59240 Transfer of Funds
Engineering Trans37 Transfer from GDTIF fund to General Construction 25,000 240 24060240 91360 Transfer of Funds
Engineering Trans37 Transfer from GDTIF fund to General Construction 25,000 360 3602671 59240 Transfer of Funds
Page 14
FISCAL YEAR 2018 AMENDMENT#1 CITY COUNCIL
17-Aug-17
FY 18 FY 18
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
Engineering Trans38 Transferfrom GDTIF fund to General Construction 10,000 240 24060240 91360 Transfer of Funds
Engineering Trans38 Transfer from GDTIF fund to General Construction 10,000 360 3602677 59240 Transfer of Funds
Economic Developmei Trans39 Transfer from GDTIF to General Construction Fund 19,447 360 3602679 59240 Transfer of Funds
Economic Developmei Trans39 Transfer from GDTIF to General Construction Fund 19,447 240 24060240 91360 Transfer of Funds
Economic Developmei Trans40 Transfer from General Fund to America's River Fund 36,253 700 7001853 59100 Transfer of Funds
Economic Developmei Trans40 Transfer from General Fund to America's River Fund 36,253 100 10010100 91700 Transfer of Funds
Housing Trans41 Transfer from GDTIF to General Construction Fund 38,000 268 2681021 59240 Transfer of Funds
Housing Trans41 Transfer from GDTIF to General Construction Fund 38,000 240 24060240 91268 Transfer of Funds
Housing Trans42 Transfer from GDTIF to General Construction Fund 51,794 360 3601595 59240 Transfer of Funds
Housing Trans42 Transfer from GDTIF to General Construction Fund 51,794 240 24060240 91360 Transfer of Funds
Housing Trans43 Transfer from N Cascade to General Construction 179,369 360 3601595 59215 Transfer of Funds
Housing Trans43 Transfer from N Cascade to General Construction 179,369 215 21560215 91360 Transfer of Funds
Housing Trans44 Transfer from N Cascade to General Construction (153,332) 360 3601595 59215 Transfer of Funds
Housing Trans44 Transfer from N Cascade to General Construction (153,332) 215 21560215 91360 Transfer of Funds
TOTAL TRANSFERS 2,759,004 2,759,004
47,831,706 45,110,273
ENCUMBRANCE C/O's 27,210,478
Back out Non Budgeted Encumber Rollovers (2,839,800)
Total Amend#1 with Enc,C/O's,and New 72,202,384 45,110,273
Page 15
STATE OF IOWA {SS:
DUBUQUE COUNTY
CERTIFICATION OF PUBLICATION
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: August 23, 2017, and for which the charge is $166.65.
Subscribed to before me, a Notary Public in and for Dubuque County, Iowa,
this joiy, day of „._ , 20 /7
Notary Public in and for Dubuque County, Iowa.
WESTERMEYER
OA� , MARY K
gym. A
2 Commission Number 154885
My Commission Exp. Feb. 1, M
NOTICE OF PUBLIC HEARING
AMENDMENT OF FY2017-2018 CITY BUDGET
Form 653.C1
The City Council of Dubuque in DUBUQUE County„Iowa
will meet at Historic Federal Building 350 West 6th St
at 6:00 p.m. on 09/05!2017
(hour) (Date)
,for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2018
(year)
',by changing estimates of revenue and expenditure appropriations in the following programs for the reasons
- given. Additional detail is available at the city clerk's office showing revenues and expenditures by fund type
and by activity.
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
Tranfers In
1 otal Mevenues ana Omer bources
Exoenditures & Other Financing Uses
Public Safety
Public Works
Health and Social Services
Culture and Recreation
Community and EconomicDevelopment
General ,Government
Debt Service
Capital Projects
1 otal (3(vernment Activities txpenanures
Business Type / Enterprises
otal (. ov Activities & Business txpenoltures
Transters'Out •
Total Expenditures/Transfers. Out
- Excess Revenues & Other Sources Over
(Under) Expenditures/Transfers Out for Fiscal Year
Beginning Fund Balance July '1
Ending Fund Balance June 30
Total Budget Total Budget
as certified Current after Current
or last amended - Amendment - Amendment
25,062,297 0 25,062,297
2 0 0 0
3 25,062,297 0 25,062,297
4 0 0 0
5- 11,903,432 0 11,903,432
6 18,061,248 0 18,061,248
7+ ' 1,529,906 0 1,529,906
8 12,553,589- 0- 12,553,589
9 41,763,315 34,993,582 76,756,897
10 42,877,311 3,828- 42,881,139
11' ' . 30,000 0 30,000
12 7,681,272 451,787 8,133,059
13 - 2,522,060 6,902,072 9,424,132
14 28,992,317 ' 2,759,004 31,751,321
"Ib '192,'9/b,/4/I 40,1"IU,2/;5, Liti,U0t,02U
16 29;244,056 363129 29,607,1'85
17 12,682,233 1,441,359 14,123,592
18 915,654 27,862 943,516
19 12,054,279 695,955 12,750,234
20 14,755,628 ' -175,078 14,580,550
21 9,029,607 556,146 9,585,753
22 ; 10,873,974 0 10,873,974
23 29,769,433 39,653,601 69,423,034
24 '119,324,bb4 4L,bb4,y/4 Ib"I ,db ,bjb
25 50,388,083 26,880,406 77,268,489
20 Ib9,/'IL,`J4! b`9,443,d8U 2,9,ibb,3L!
'27 28,992,317 2,759,004 31,751,321
28 198,705,264 72,202,384 270,907,648
29 5,728,517 -27,092,111 -32,820,628
30 35,830,708 37,320,239_ _ 73,150,947
31 30,102,19. 10,228,128 40,330,319
Explanation of increases or decreases in revenue estimates, appropriations, or available cash:
p a rrryo. d. ,
This amendment adds ca ltal budget car 'overs of $41,851,553 &associaterevenue of $39,512,047 &
encumbrance carryovers of $27,210,478 (continuing appropriation authority). Adds operating budget carryovers of
$1,749,490 & associated revenue of $1,474,387, requiring a formal amendment. Also included is $1,206,571
reduction in captial expense due to prespending Fiscal Year 2018 budget. Capitalrevenue decrease of $467,080
related to elimination of debt. Operating expense increase of $28,492. Interfund transfers of $2,759,004.
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 fora balanced budget.
'It 8/23
Jennifer Larson, Budget Director
City Clerk/Finance Officer
adno=676293-0