Fiscal Year 2013 First Budget AmendmentNOTICE OF PUBLIC HEARING
AMENDMENT OF CURRENT CITY BUDGET
Form 653.C1
The City Council of Dubuque In DUBUQUE
will meet at City Council Chambers at the Historic Federal Building
at 6:30 p.m. ? on 09/17/2012
(hour) (Date)
,for the purpose of amending the current budget of the city for the fiscal year ending June 30,
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.
County, Iowa
2013
(Year)
Explanation of Increases or decreases in revenue estimates, approeatlonnss, or available cash:
This amendment adds the capital budget carryovers of $77,397,388 & associated revenue of $62,233,518, & encumbrance
carryovers of $20,209,008 (continuing appropriation "authority,not requiring formal amendment! or reporting purposes only).
Adds operating budget carryovers of $1,065,112 & associated revenue of $1 ,361,319, requiring a formal amendment.
Reduction of $1,915,103 in new expense & associated reduced revenue of $9,888,455 due to project borrowing done in
previous fiscal year. Reduction in interfund transfers of $3,067,539,
There will be no Increase in tax levies to be paid In the current fiscal year named above. Any Increase In
expenditures set out above will be met from the Increased non - property tax revenues and cash balances not
budgeted or considered In this current budget. This will provide for a balanced budget,
...9/5
Kevin S. Fimstahl, CMC
City Clerk
518505 -01 -5
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: September 05, 2012, and for which the charge is $146.98.
Subscribed to before me, a tary Public in and for Dubuque County, Iowa,
, 20 7..
this /1r0 day of
•1. -�
Notary Public in and for Dubuque County, Iowa.
Commti io Nui1bS(154, 9
Total Budget
as cerlilied
or I at amended
Current
Amendment
Total Budget
after Current
Amendment
Revenues & Other Flnanclna Sources
1
22,007,300
0
. 122,007,300
Taxes Levied on Propert
Less: Uncollected Pro •erlyTaxes-Lev Year
, 2
-. 0
0
0
Nat Current Pro • e Taxes
3
22,007,300.
0
22,007,300
Delin, cent Propel' Taxes
4
0
0
0
TIF Revenues
5
10,289,839
0
10,289,839
Other City Taxes
6
14,922 912
0
14,922,012
Licenses & Permits
7
1,339,574
0
0
MEM
12,385;426
Use of Mona and Pro.erty
8
12,366,426
Inte •ovemmental
9
50224931
40,.5916
91,08 0 1
Char as for Services
`10
34,178,789
33,000
-34,211 789
S , eclal Assessments
11
74,273
1,769,541.
Miscellaneous
12
6,759,820
1,784,648
Other Financin. Sources
13
92,703,315
6,207;492
98,91'., '07
Total Revenues and Other Sources
' 14
244,865,078
50,858,841
296,6$$` -;6
Expenditures & Other Flnanclna Uses
115
25,339,063.
508 630
25,045,893
Public Safet
Public Works
18
12,049,060
398,928
12,447,988
Health and Social Serviced
17
1,030,919
105,134
1,136 053
Culture and Recreation
18
10 548195
128,007
10,674, 02
Communit and Economic Development
19
12,781,522
282,850
13,084,372
General Government
20
,317,326
269,1103
7,504 919
Debt Service
21
0
6,994,075
Ca , Ital Pro ects
22
44 312,974
56,145,710
' 100 458,;94
Total Government ActiVitba Expenditures
23
120,371,334
9 `
Business T is I Enter rises
24
94,088,699
214,480,033
36,999,E 3
96,838,385
133,088,432
311,296,418
Total Gov Activities & Business Expenditures
25
Transfers Out
28
32,484,076
- 3,087,539
29,398,537
Total Ex . enditureslTransfers Out
27
- 246,924,109
340 2,955
Ekcess Revenues & Other Sources Over
Under Ex . endlturesrfransfers Out for Fiscal Yei
28
� -;. _
2 059 031
8g03,768,846
- 43,110,005
- 451.89,036
22,279,858
43,110,005
65,389,883
Ele . Innin. Fund Balance Jul 1
39
ndln. Fund Balance June 30
31
20,220,527
0
20 220,827
Explanation of Increases or decreases in revenue estimates, approeatlonnss, or available cash:
This amendment adds the capital budget carryovers of $77,397,388 & associated revenue of $62,233,518, & encumbrance
carryovers of $20,209,008 (continuing appropriation "authority,not requiring formal amendment! or reporting purposes only).
Adds operating budget carryovers of $1,065,112 & associated revenue of $1 ,361,319, requiring a formal amendment.
Reduction of $1,915,103 in new expense & associated reduced revenue of $9,888,455 due to project borrowing done in
previous fiscal year. Reduction in interfund transfers of $3,067,539,
There will be no Increase in tax levies to be paid In the current fiscal year named above. Any Increase In
expenditures set out above will be met from the Increased non - property tax revenues and cash balances not
budgeted or considered In this current budget. This will provide for a balanced budget,
...9/5
Kevin S. Fimstahl, CMC
City Clerk
518505 -01 -5
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: September 05, 2012, and for which the charge is $146.98.
Subscribed to before me, a tary Public in and for Dubuque County, Iowa,
, 20 7..
this /1r0 day of
•1. -�
Notary Public in and for Dubuque County, Iowa.
Commti io Nui1bS(154, 9
31 -288
CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION
To the Auditor of
DUBUQUE County, Iowa:
The City Council of Dubuque in said County /Counties met on 09/17/2012
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. 2 5 7 -12
A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE 31 2013
(AS AMENDED LAST ON 4 -16 -2012 .)
Be it Resolved by the Council of the City of Dubuque
Section 1. Following notice published 9 -18 -2012
and the public hearing held, 09/17/2012 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:
Total Budget
as certified
or last amended
Current
Amendment
Total Budget
after Current
Amendment
Revenues & Other Financing Sources
Taxes Levied on Property
1
22,007,300
22,007,300
Less: Uncollected Property Taxes -Levy Year
2
0
0
0
Net Current Property Taxes
3
22,007,300
0
22,007,300
Delinquent Property Taxes
4
0
0
0
TIF Revenues
5
10,289,639
0
10,289,639
Other City Taxes
6
14,922,012
0
14,922,012
Licenses & Permits
7
1,339,574
0
1,339,574
Use of Money and Property
8
12,365,425
0
12,365,425
Intergovernmental
9
50,224,931
40,859,160
91,084,091
Charges for Services
10
34,178,789
33,000
34,211,789
Special Assessments
11
74,273
1,769,541
1,843,814
Miscellaneous
12
6,759,820
1,789,648
8,549,468
Other Financing Sources
13
92,703,315
6,207,492
98,910,807
Total Revenues and Other Sources
14
244,865,078
50,658,841
295,523,919
Expenditures & Other Financing Uses
Public Safety 15
25,339,063
506,630
25,845,693
Public Works 16
12,049,060
398,928
12,447,988
Health and Social Services 17
1,030,919
105,134
1,136,053
Culture and Recreation 18
10,546,195
128,007
10,674,202
Community and Economic Development 19
12,781,522
282,850
13,064,372
General Government
20
7,317,526
269,393
7,586,919
Debt Service
21
6,994,075
0
6,994,075
Capital Projects 22
44,312,974
56,145,710
100,458,684
Total Government Activities Expenditures 23
120,371,334
57,836,652
178,207,986
Business Type / Enterprises 24
94,088,699
38,999,733
133,088,432
Total Gov Activities & Business Expenditures 25
214,460,033
96,836,385
311,296,418
Transfers Out
26
32,464,076
- 3,067,539
29,396,537
Total Expenditures/Transfers Out 27
246,924,109
93,768,846
340,692,955
Excess Revenues & Other Sources Over
(Under) Expenditures/Transfers Out Fiscal Year 28
- 2,059,031
- 43,110,005
- 45,169,036
29
Beginning Fund Balance July 1
30
22,279,858
43,110,005
65,389,863
Ending Fund Balance June 30
31
20,220,827
0
20,220,827
City Clerk/Finance Officer
17
(Day)
day of
Se ' tember 2
(Mont
Signature
Mayor
FISCAL YEAR 2013 AMEN DM ENT #1
CITY COUNCIL
11- Sep -12
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
GENERALFUND
Police Department
1C
Replace Police /CAD Software
600,000
101
1011167
71123
C/O
Police Department
1C
Replace Police /CAD Software - County Reimbursement
400,000
101
1011167
46205
C/O
Police Department
1C
Restore Police Car - Private Contributions
9,160
100
1002280
62528
C/O - Additional Contributions
Police Department
1C
Restore Police Car- Motor Vehicle Maintenance
11,288
100
1002280
62528
C/O
Police Department
1 C
Computer Storage System - Servers
22,683
101
1011752
71125
C/O
Police Department
1C
In -Car Video Recorders
7,183
101
1011580
73410
C/O
Police Department
1
School Resource Officer - Dubuque Community Schools
62,600
100
10011322
53102
C/O
Police Department
1
Narcotics Grant Investigation - Byrne /Jag Grant
23,458
101
1011320
44176
C/O
Police Department
1
Records and ID - DCSO shared server
10,000
100
10011220
53620
C/O
Police Department
1
2009 Justice Assistance Grant - Reimb OT
1,974
100
10011775
61051
C/O
Police Department
1
2009 Justice Assistance Grant- Supplies /Equipment
1,334
100
10011775
72218
C/O
Police Department
1
2009 Justice Assistance Stimulus Grant - Reimbursable OT
69,865
100
10011740
61051
C/O
Police Department
1
2009 Justice Assistance Stimulus Grant - Misc Op Supplies
7,702
100
10011740
62671
C/O
Police Department
1
2010 Justice Assistance Stimulus Grant - Reimbursable OT
16,498
100
10011776
61051
C/O
Police Department
1
2010 Justice Assistance Stimulus Grant - Special Equip
29,064
100
10011776
72218
C/O
Police Department
1
2010 Justice Assistance Stimulus Grant - Special Equip
39,979
100
10011752
72218
C/O
Police Department
1
Domestic Abuse Grant - Federal Grant
1,972
100
10011754
44135
C/O
Police Department
1
Police Traffic Service Grant - Governor's Traffic Safety
12,376
100
10011771
44125
C/O
Police Department
1
Police Traffic Service Grant - Travel
849
100
10011771
62360
C/O
Police Department
1
Police Traffic Service Grant - Reimb OT
7,658
100
10011771
61050
C/O
Police Department
1
Police Admin - Training
(30)
100
10011100
62360
C/O - Prespend FY13
Police Department
1
Police Training- Training
56,724
100
10011250
62360
C/O
Police Department
1
Police Patrol - Training
52,260
100
10011700
62360
C/O
Police Department
1
Police Patrol - Training
(1,200)
100
10011700
62360
C /O- Prespend FY13
Police Department
1
Community Policing - Training
6,403
100
10011500
62360
C/O
Police Department
1
Community Policing - Training
(100)
100
10011500
62360
C/O - Prespend FY13
Emergency Communii
1 C
Emergency Dispatch Protocols Software
60,000
100
1002186
71123
C/O
Fire Department
1
Fire Training - Education & Training
7,505
100
10013200
62360
C/O
Fire Department
1
Fire Suppression - Backup Camera
4,078
100
10013400
72113
C/O
Fire Department
1C
Pumper Replacement
17,752
102
1021016
71318
C/O
Fire Department
1C
Improvements to Fire Headquarters
27,363
101
1011139
73210
C/O
Fire Department
1C
Fire Protection Equipment Replacements
9,013
101
1012286
72116
C/O
Fire Department
1C
Fire Protection Equipment Replacements - Federal Grant
7,244
101
1012286
44170
C/O - Assistance to Firefighters Grant
Fire Department
1C
Smoke Detectors /Fire Extinguishers- Prevention Grant
22,421
101
1012345
44170
C/O
Fire Department
1C
Smoke Detectors /Fire Extinguishers- Safety Equipment
14,802
101
1012345
72116
C/O
Fire Department
1C
Station #6 Improvements - Construction
4,786
101
1012287
73210
C/O
Human Relations
3
Human Relations Administration - Misc Operating Supplies
600
100
10016100
62671
C/O
Human Relations
3
Human Relations Administration - Travel Conferences
(2,105)
100
10016100
62310
C/O - Prespend FY13
Human Relations
3
Human Relations Administration - Travel City Business
(100)
100
10016100
6232
C/O - Prespend FY13
Human Relations
3
Human Relations Grant Funds- Printing & Binding
32,275
100
10016200
62090
C/O
Human Relations
3
Human Relations Grant Funds- Education & Training
13,589
100
10016200
62360
C/O
Human Relations
3
Human Relations Grant Funds- Misc Services
17,089
100
10016200
62731
C/O
Human Relations
3
Human Relations Grant Funds- Fair Housing Training
35,611
100
10016200
62753
C/O
Health Services
1
Animal Control - Education & Training
427
100
10017200
62360
C/O
Health Services
1
Animal Control - Uniforms
296
100
10017200
62011
C/O
Health Services
3
Health Services Admin - Dues & Memberships
(200)
100
10017100
62190
C/O - Prespend FY13
Health Services
3
Health Services Admin - Travel
(455)
100
10017100
62310
C/O - Prespend FY13
Health Services
3
Community Health Services - Conferences
500
100
10017400
62310
C/O
Page I
FISCAL YEAR 2013 AMEN DM ENT #1
CITY COUNCIL
11- Sep -12
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Health Services
3
Community Health Services - Emergency Preparedness
2,000
100
10017400
45771
C/O
Health Services
3
Lead Paint Program - Childhood Lead Grant
5,289
100
10017500
45701
C/O
Health Services
3
Lead Paint Program - Childhood Lead Grant
4,945
100
10017500
45701
C/O
Health Services
3
Lead Paint Program - Education & Training
2,500
100
10017500
62360
C/O
Health Services
3
Food Inspections - Radon Grant
2,500
100
10017300
45701
C/O
Health Services
3
Food Inspections - Travel Conferences
500
100
10017300
62310
C/O
Parks Division
4C
Ham House Repairs - Construction
30,000
102
1022184
73210
C/O - Shift from Retaining Walls
Parks Division
4C
Comiskey Repair Siding - Construction
15,675
102
1021151
73210
C/O
Parks Division
4C
Miller Riverview Rip Rap
57,816
100
1001170
73211
C/O
Parks Division
4C
Vets Memorial Park Ballfield - Construction
23,093
102
1021214
73211
C/O
Parks Division
4C
Comiskey Sidewalk Lights - Consulting
10,000
102
1021544
62712
C/O
Parks Division
4C
Comiskey Sidewalk Lights - Construction
90,000
102
1021544
73211
C/O
Parks Division
4C
Westbrook Park Development- Eng. Division Svcs
12,600
101
1011582
62712
C/O
Parks Division
4C
Westbrook Park Development- Construction
53,447
101
1011582
73211
C/O
Parks Division
4C
Highway 20 Roses Plan - Consulting
21,000
102
1021588
62712
C/O
Parks Division
4C
Eagle Point Park Stone - Construction
25,000
101
1011677
73211
C/O
Parks Division
4C
BMX Bike Course
4,379
102
1021871
73211
C/O
Parks Division
4C
Schmitt Island Master Plan - Consulting
100,000
102
1021883
62712
C/O
Parks Division
4C
Dubuque History Trail - Federal Grants
148,500
100
1001956
44170
C/O
Parks Division
4C
Dubuque History Trail - Consultant Services
14,850
100
1001956
62716
C/O
Parks Division
4C
Dubuque History Trail - Equipment Acquisition
133,650
100
1001956
73411
C/O
Parks Division
4C
Marshall Park - Pool Repair
18,721
101
1011983
73211
C/O
Parks Division
4C
Erosion Control Study
19,610
100
1001987
62712
C/O
Parks Division
4C
Roosevelt Property- Road Repair
1,246
102
1022103
73510
C/O
Parks Division
4C
Ham House Repairs - Construction
6,000
102
1022184
73210
C/O - Shift from Erosion Control
Parks Division
4C
Catfish Creek Hike -Bike Trail Study- Consultant Services
5,400
101
1012078
62716
C/O
Parks Division
4C
Park Drinking Fountains - Consultant Engineers
9,957
100
1002101
62712
C/O
Parks Division
4C
Greenhouse - Addition - Contt Contr - Bldg
85,173
102
1022104
73210
C/O
Parks Division
4C
EB Lyons Expansion - REAP Grant
200,000
100
1002171
45707
C/O
Parks Division
4C
EB Lyons Expansion - Land Acquisition
200,000
100
1002171
73110
C/O
Parks Division
4C
EPP - Rivertront Pavilion - Construction
12,435
102
1022190
62712
C/O
Parks Division
4C
EPP - Rivertront Pavilion - Consulting Engineers
131,847
102
1022190
73210
C/O
Parks Division
2C
NW Hike /Bike Trail - REAP Grant
20,000
100
1002273
45707
C/O
Parks Division
2C
NW Hike /Bike Trail - Construction Not Building
47,925
100
1002273
73211
C/O
Parks Division
4C
Dubuque Water Trail - State DNR Grant
6,000
100
1002277
45701
C/O
Parks Division
4C
Eagle Valley Park Development - Consulting
5,770
102
1022288
62712
C/O
Parks Division
4C
Eagle Valley Park Development - Construction
90,000
102
1022288
73211
C/O
Parks Division
4C
Eagle Point Park Overlay Tennis Court Lot - Consulting
9,000
102
1022289
62712
C/O
Parks Division
4C
Eagle Point Park Overlay Tennis Court Lot - Construction
83,040
102
1022289
73211
C/O
Parks Division
4C
Comiskey Entry Sign - Signage
7,000
102
1022293
71227
C/O
Parks Division
4C
Comiskey Playground Replacement - Playground Equip
200,000
102
1022292
72713
C/O
Parks Division
4C
Greenhouse Vent System - Construction
11,800
101
1012297
73210
C/O
Parks Division
4C
Lincoln Ave Spillway Replant - Construction
17,700
101
1012298
73211
C/O
Parks Division
4C
Hilltop Park - 735 Calendonia Place Expansion
17,094
102
1022449
73211
C/O - Shift from Elec to Pole Sheds
Parks Division
4C
Urban Youth Corp Grant - Fed Grant
6,275
100
1002343
45771
C/O
Parks Division
4C
S Grandview Park Entrance - Land Acquisition
11,460
100
1002440
73111
C/O
Parks Division
4
Park Areas - Truck Replacement
26,000
100
10030400
71314
C/O
Parks Division
4
Park Areas - Snow Blade
5,000
100
10030400
71619
C/O
Parks Division
4
Greenhouse - truck accessories
4,496
100
10030500
71312
C/O
Civic Center Division
4C
Paint Arena Ceiling - Construction
95,000
101
1012117
73210
C/O
Page 2
FISCAL YEAR 2013 AMEN DM ENT #1
CITY COUNCIL
11- Sep -12
FY 13
FY 13
Expense
Revenue
Department Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Civic Center Division
4C
Five Flags Entryway Renovation - Misc Equipment
7,513
101
1012283
71550
C/O
Civic Center Division
4C
Five Flags Audio Equipment - PA System
37,475
101
1012302
72419
C/O
Civic Center Division
4C
Ice Machine Replacement - Concession Equipment
14,000
100
1002304
72310
C/O
Conference Center
6C
GRC- Replace Clouds
35,000
102
1022305
73210
C/O
Conference Center
6C
GRC- Replace Outdoor Furniture
35,000
102
1022306
71156
C/O
Conference Center
6C
GRC- Cool Room Study
25,000
102
1022307
71156
C/O
Recreation
4C
Flora & Sutton Pool Storage
1,738
101
1012334
73210
C/O - A/C Concession Stands
Library
4
Children Services- Books
1,324
100
10036400
62651
Lost Book Fees
Library
4
Children Services - Speakers /Programs
(425)
100
10036400
62734
C/O - Prespend FY13
Library
4
Adult Services - Books
3,242
100
10036200
62659
Lost Book Fees
Library
4
Adult Services - Travel City Business
(400)
100
10036200
62310
C/O - Prespend FY13
Library
4
Children Services - Travel Conferences
(400)
100
10036210
62310
C/O - Prespend FY13
Airport Department
2
Airport Operations - Misc Services
25,000
100
10051400
62731
C/O
Public Works
2C
Underground Tank Removal
750
100
1002152
73211
C/O
Public Works
2C
Bi- Lingual Trail Signage- Signage
14,595
100
1002169
71227
C/O
Engineering
2C
Accessibility Barriers- Construction
19,537
101
1011034
73210
C/O
Engineering
2C
Curb /Catch Basin Replacement- Construction
43,290
102
1021041
73211
C/O
Engineering
2C
Riverfront Leasehold Improvements- Consultant Services
12,000
101
1011053
62716
C/O
Engineering
4C
Library Renovation - Construction
8,382
100
1001141
73210
C/O
Engineering
4C
Library Renovation - Contributions
29,813
100
1001141
53103
C/O - Pledges Receivable
Engineering
4C
Library Renovation - Sale of Assets - Heade Painting
253,710
100
1001141
54104
C/O - Heade Painting Receivable
Engineering
2C
Decorative Concrete Maint- Construction
33,703
102
1021630
73211
C/O
Engineering
2C
Federal Building Renovation - Construction
68,499
102
1021841
62712
C/O
Engineering
2C
Port of Dubuque Outdoor Plaza - Eng Division Services
100,000
100
1001855
62811
C/O
Engineering
2C
Port of Dubuque Outdoor Plaza - Construction
600,000
100
1001855
73211
C/O
Engineering
2C
Port of Dubuque Outdoor Plaza - Private Participant
450,000
100
1001855
53102
C/O
Engineering
2C
Riverwalk Security Camera- Camera Related Equipment
29,578
100
1001963
72417
C/O
Engineering
2C
Ice Harbor Maintenance /Dredging
101,500
102
1021466
73211
C/O
Engineering
2C
Tourism Signage Program - Signage
24,853
102
1021512
71227
C/O
Engineering
2C
Downtown Street Light Replacement
33,971
102
1021608
73410
C/O
Engineering
2C
Fiber Optic Con - Priv & Misc - Eng Division Svc
49,256
102
1021609
73211
C/O
Engineering
2C
Transient Docks- Main Channel - Consulting Engineers
60,450
101
1011861
62712
C/O
Engineering
2C
Safes Routes to School - Const Contract Not Building
104,156
101
1011922
73211
C/O
Engineering
2C
Safes Routes to School - IDOT Grant
70,750
101
1011922
45701
C/O
Engineering
2C
Riverwalk Security Camera- Camera Related Equipment
5,000
102
1021963
72417
C/O
Engineering
2C
Flood Plain Buyout
(336)
101
1012419
73111
C /O- Prespend FY13
Engineering
2C
Port of Dubuque - Leasehold Improvements
27,584
102
1022330
73211
C/O
Engineering
2C
Port of Dubuque - Leasehold Improvements
3,500
101
1012330
73211
C/O
Engineering
2C
Recon Sign als /JFK- Wacker- Construction
147,965
101
1011919
73211
C/O
Engineering
2C
5 Points Intersection Signal - Construction
77,712
102
1021920
73211
C/O
Building Services
1
Building Services Admin - Light Grants
34,900
100
10057100
62765
C/O
Building Services
1
Building Services Admin - Travel
(335)
100
10057100
62310
C/O - Prespend FY13
Economic Developme
5C
Port of DBQ- Develop.Standards (Int Write Down)
35,353
100
1001207
62764
C/O
Economic Developme
5C
Port of DBQ- Develop.Standards (Int Write Down)
15,000
102
1021207
62764
C/O
Economic Developme
5C
Warehouse Master Planning - Private Participant
11,000
100
1002081
53102
CO - John Gronen
Housing & Comm Deg
6
Federal Building - Property Maintenance
118,881
100
10061150
62431
C/O
Housing & Comm Deg
5C
Maint of Vacant /Abandoned - Property Maintenance
105,641
101
1011002
73210
C/O
Housing & Comm Deg
5C
Maint of Vacant /Abandoned - Property Maintenance
102,256
100
1001002
73210
C/O
Housing & Comm Deg
5C
Purchase /Resale /Rehab- Land Acquisition
50,000
102
1021231
73111
C/O
Housing & Comm Deg
5C
Historic Preservation Revolving Loan
200,000
100
1001247
54210
C/O
Page 3
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Page 4
FY 13
FY 13
Expense
Revenue
Department Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Housing & Comm Deg
5C
Historic Preservation Revolving Loans
200,000
100
1001247
62764
C/O
Housing & Comm Deg
5C
Homeownership Grants - Target
277,197
101
1011595
62765
C/O
Housing & Comm Deg
5C
Homeownership Grants - Target
70,000
102
1021595
62765
C/O
Housing & Comm Deg
5C
Homeless Prevention Grant - Federal Stimulus Grant
988
100
1002175
44175
C/O
Housing & Comm Deg
5C
NBHD Stabilization Grant - Stimulus Fed Pass Thru Grant
134,728
100
1002180
44176
C/O
Housing & Comm Deg
5C
NBHD Stabilization Grant - Land Acquisition with Improv.
67,098
100
1002180
73111
C/O
Housing & Comm Deg
5C
NBHD Stabilization Grant - Land Acquisition with Improv.
2,812
100
1002180
73111
C/O
Housing & Comm Deg
5C
NBHD Stabilization Grant - Land Acquisition with Improv.
750
100
1002180
73111
C/O
Housing & Comm Deg
5C
NBHD Stabilization Grant - Land Acquisition with Improv.
52,000
100
1002180
73111
C/O
Housing & Comm Deg
5C
Healthy Homes Grant - HUD Payments
249,113
100
1002340
44310
C/O
Housing & Comm Deg
5C
Healthy Homes Grant- Grants
39,146
100
1002340
62765
C/O
Housing & Comm Deg
5C
IFA Our Home Grant - Grants
250,000
100
1002269
62765
C/O
Housing & Comm Deg
5C
IFA Our Home Grant - Iowa Finance Authority
250,000
100
1002269
45703
C/O
Housing & Comm Deg
5C
IFA Housing Grant 10 -10
4,500
100
1002270
62765
C/O
Housing & Comm Deg
5C
IFA Housing Grant 11 -19
92,607
100
1002285
62765
C/O
Housing & Comm Deg
5C
IFA Housing Grant 12 -14
132,637
100
1002443
45703
C/O
Housing & Comm Deg
5
Rehab Program - Property Taxes
7,783
100
10061300
62211
C/O
Housing & Comm Deg
5
445 Loras - Maintenance
8,386
100
10061710
62431
C/O
Housing & Comm Deg
5
Getting Ahead - Programming
5,600
100
10061921
62140
C/O
Housing & Comm Deg
5
Circles - Programming
10,194
100
10061922
62140
C/O
Housing & Comm Deg
5
Housing Circles Program - Furniture
(3,200)
100
10061922
71211
C/O - Prespend FY13
Housing & Comm Deg
5
Housing Circles Program - Computer
(2,100)
100
10061922
71124
C/O - Prespend FY13
Housing & Comm Deg
5
Housing Circles Program - Phone
(250)
100
10061922
71110
C/O - Prespend FY13
Housing & Comm Deg
5
Section 8 Voucher- Furniture
(3,500)
100
10061600
71211
C /O- Prespend FY13
Housing & Comm Deg
5
Section 8 Voucher- Computer
(4,200)
100
10061600
71124
C /O- Prespend FY13
Housing & Comm Deg
5
Section 8 Voucher- Phone
(250)
100
10061600
71110
C /O- Prespend FY13
Housing & Comm Deg
5
Section 8 Voucher- Construction
(7,000)
100
10061600
73210
C /O- Prespend FY13
Housing & Comm Deg
5
Housing Administration - Phone
(250)
100
10061100
71110
C/O - Prespend FY13
Housing & Comm Deg
5
Housing Administration - Pay to Other Agency
105,000
100
10061100
62761
C/O
Planning Services
5C
Historic District Improvements - Construction
25,305
100
1001010
62711
C/O
Planning Services
5C
Historic District Improvements - Construction
95,873
102
1021010
73210
C/O
Planning Services
5C
Annexation Study /Implementation - Consultant Services
10,199
102
1021012
62716
C/O
Planning Services
5
Development Services - Travel Conferences
2,000
100
10062400
62310
C/O - Smart Growth Conference
City Council
6
City Council - Travel Conferences
(295)
100
10070100
62310
C/O - Prespend FY13
City Manager
6C
GIB Implementation - Consultant Services
1,852
100
1001070
62716
C/O
City Manager
6C
GIB Enhancements - Peripherals, Computer
3,082
102
1021946
71120
C/O
City Manager
6C
City of Dbq 175th Birthday
3,390
100
1001948
62734
C/O
City Manager
6C
GIB Training
7,760
100
1002165
62360
C/O
City Manager
6C
Americas River Fest Equip
14,587
100
1002050
72115
C/O
City Manager
6C
Sustainability Initiative - Consultant Services
17,064
102
1022218
62716
C/O
City Manager
6C
Electric PILOT Program Consultant Services
2,980
100
1002272
62716
C/O
City Manager
6C
Climate Showcase Grant - Consultant Services
310,394
100
1002334
62716
C/O
City Manager
6C
Climate Showcase Grant - Federal Grants
313,467
100
1002334
44170
C/O
City Manager
6C
EECBG Grant - Grants
102,042
100
1002338
62716
C/O
City Manager
6C
EECBG Grant - Federal Grants
102,042
100
1002338
44175
C/O
City Manager
6C
Marketing Grant - Vision Iowa
5,000
100
1002275
45761
C/O
City Manager
6
City Manager - Full Time Employee
7,887
100
10072100
61010
FY13 Manager Increase
City Manager
6
City Manager - Social Security
117
100
10072100
61320
FY13 Manager Increase
City Manager
6
City Manager- IPERS
459
100
10072100
61310
FY13 Manager Increase
City Manager
6
City Manager - Life Insurance
16
100
10072100
61416
FY13 Manager Increase
Page 4
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Department
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Clerk
Finance
Finance
Information Services
TRANSIT FUND
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Transit Division
Program Description
6 City Manager - Car Allowance
6 Administration - Spirit Expense
6 Administration - Travel Conference
6 Administration - Travel Conference
6 Budget- Education & Training
6 Special Projects Art Grants - Pay to Other Agency
6 Our Town NEA Grant
6 Our Town NEA Grant - Pay to Other Agency
6 Public Information - Travel Conferences
6 Sustainability- Seasonal Employees
6 Administration - Education & Training
6C Finance Plus Upgrade - Software
6C Software Upgrade E -Gov- Software
6 City -Wide Computer Replacements
TOTAL GENERAL FUND
8C
8C
8C
8C
8C
8C
8C
8C
8C
8C
8C
8C
8C
8C
FY 13 FY 13
Expense Revenue
Amount Amount
179
3,342
(155)
(665)
1,500
5,341
100,000
100,000
(455)
3,000
4,000
4,500
6,241
2,100
7,015,975 3,238,828
Fund Activity /CIP Account Explanation
100
10072100
61655
FY13 Manager Increase
100
10072100
62756
C/O
100
10072100
62310
C/O - Prespend FY13
100
10072100
62320
C/O - Prespend FY13
100
10072400
62360
C/O - NCDA speaker revenue
100
10072500
62761
C/O
100
10072500
44170
C/O
100
10072500
62761
C/O
100
10072300
62310
C/O - Prespend FY13
100
10072200
61030
C/O - SD Intern
100
10073100
62360
C/O
100
1002166
71123
C/O
100
1002217
71123
C/O
102
1021069
71124
C/O - Park Patrol
Replace Mini Buses - Clean Fuels Grant
64,622
600
6001222
44150
C/O
Replace Fixed Route Buses - State of Good Repair Grant
698,885
600
6001224
44150
C/O
Replace Fixed Route Buses - Equipment
557,150
600
6001224
73411
C/O
Transit Roof Repair - State Grant
245,000
600
6001613
45701
C/O
Transit Roof Repair- Construction
243,510
600
6001613
73210
C/O
Intermodal Feasibility Study - Construction
12,308,405
600
6001614
62716
C/O
Intermodal Feasibility Study- State Grants
8,000,000
600
6001614
45701
C/O
Keyline Facility Improvements
33,200
600
6002045
73210
C/O
Keyline Facility Improvements - State Grant
12,610
600
6002045
45701
C/O
Electronic Fare Boxes
477,525
600
6002321
71120
C/O
Bus Stop Improvements - ARC Transfer Station
265,063
600
6002235
73210
C/O
Bus Stop Improvements - Public Transportation Infrast. Grant
254,248
600
6002235
45701
C/O
Intermodal Feasibility Study- Consulting
120,000
600
6001614
62716
C/O - shift from 1 -Wayto 2 -Way
Intermodal Feasibility Study- Consulting
1,230,000
600
6001614
62716
C /O- shift from Millwork Parking
Transit Administration - FTA Operating Assistance
440,058
600
60053100
44160
C/O
Minibus Operations - East Dubuque Contract
33,000
600
60053500
51715
C/O
Transit Administration - State Transit Assistance
23,396
600
60053100
45701
State Transit Assistance
TOTAL TRANSIT FUND
15,234,853
9,771,819
DUBUQUE INDUSTRIAL PARK
Economic Developme 5 Dubuque Industrial West - BAB Subsidy
Parks Division 4 Industrial Center West - accessories for truck
TOTAL DUBUQUE INDUSTRIAL CENTER -TIF FUND
TECHNOLOGY PARK SOUTH
Parks Division 4 Tech Park South - accessories for truck
TOTAL TECHNOLOGY PARK SOUTH -TIF FUND
GREATER DOWNTOWN T1F -TIF FUND
Economic Developme 5C Downtown Rehab Consultant - Financial Consultant
TOTAL GREATER DOWNTOWN T1F -TIF FUND
DOWNTOWN LOAN POOL - T1F FUND
Economic Developme 5C Loan Pool, Downtown TIF - Loans
28,370 210 21060210 44100 BAB Subsidy
1,768 210 21030530 71315 C/O
1,768 28,370
6Y�ir�Ybi�YbY�irb9Aii Ki 6�NL�]
30,000 240 2402157 62721 C/O
30,000
537,733 241 2411033 62764 C/O
Page 5
FISCAL YEAR 2013 AMEN DM ENT #1
CITY COUNCIL
FY 13
FY 13
Expense
Revenue
Department Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Economic Developme
5C
Downtown Rehab Grant Program
34,467
241
2411942
62765
C/O
TOTAL DOWNTOWN LOAN POOL -T1F FUND
572,200
-
ROAD USE TAX FUND
Engineering
2C
Fiber Optic Conduit Project - Construction
61,669
250
2501017
73211
C/O
Engineering
2C
Brunskill Rd Bridge Repl - Construction
173,091
250
2501077
73211
C/O
Engineering
2C
Railroad Cross Improvement - Construction
9,208
250
2502026
73211
C/O
Engineering
2C
NW Arterial Capacity Imp
42,343
250
2501814
73211
C/O
Engineering
2C
LED Re -Lamp Schedule- Construction
41,063
250
2501916
73211
C/O
TOTAL ROAD USE TAX FUND
327,374
-
RESTRICTED TERMINAL PROJECT FUND
Airport Department
2C
Restricted Terminal Project - Private Participant
9,927
252
2522447
73210
C/O
Airport Department
2C
Restricted Terminal Project - Investment Fees
(230)
252
2522447
73210
C/O
TOTAL RESTRICTED TERMINAL PROJECT FUND
9,697
-
SPECIAL ASSESSMENT FUND
Engineering
2C
Special Assessment Receivable
217,772
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
296,000
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
212,000
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
89,000
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
110,000
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
233,650
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
124,000
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
180,119
255
25510255
52101
C/O
Engineering
2C
Special Assessment Receivable
307,000
255
25510255
52101
C/O
TOTAL SPECIAL ASSESSMENT FUND
-
1,769,541
COMMUNITY DEVELOPMENT BLOCK GRANT FUND
City Manager
6C
Neighborhood Grants
5,174
260
2601238
62765
C/O
Engineering
2C
Accessible Curb Ramps - Construction
22,787
260
2601236
73211
C/O CDBG Funds
Building Services
6C
Kephart Building Improvement- Construction
76,259
260
2601976
73210
C/O CDBG Funds
Economic Developme
5C
Commercial /Industrial Rehab Loan - CDBG
60,562
260
2601235
62764
C/O CDBG Funds
Economic Developme
5C
Commercial /Industrial Rehab Loan - CDBG
117,948
260
2601746
62764
C/O CDBG Funds
Housing & Comm Deg
5C
Homeownership Rehab Program -Loans
91,660
260
2601065
62764
C/O CDBG Funds
Housing & Comm Deg
5C
Homeownership Rehab Program -Loans
68,669
260
2601065
73210
C/O CDBG Funds
Housing & Comm Deg
5C
Purchase /Resale /Rehab- Construction
29,369
260
2601231
73210
C/O CDBG Funds
Housing & Comm Deg
5C
Lead Paint Abatement Program - Loans
14,426
260
2601232
62764
C/O CDBG Funds
Housing & Comm Deg
5C
Rental Rehab - Loans
46,960
260
2601233
62764
C/O CDBG Funds
Housing & Comm Deg
5C
First Time Homebuyer Program -Loans
50,000
260
2601234
62764
C/O CDBG Funds
Housing & Comm Deg
5C
Historic Preservation Rehab Grant -Loans
7,059
260
2601237
62764
C/O CDBG Funds
City Manager
5
Neighborhood Development- Zoning Enforcement
3,139
260
26072800
62834
C/O - CDBG
Housing & Comm Deg
5
Housing Rehab - NeighborWorks Certification
5,068
260
26061300
62360
C/O - CDBG
Human Relations
3
Community Development Block Grant - Dispute Resolution
332
260
26016100
62140
C/O CDBG Funds
Human Relations
3
Community Development Block Grant - Dispute Resolution
500
260
26016100
62360
C/O CDBG Funds
Housing & Comm Deg
5
Community Development Block Grant
663,121
260
26061800
44205
C/O CDBG Funds
Engineering
5C
Neighborhood Infrastructure Improvements- Construction
17,131
260
2601239
73211
CDBG Amend #1
TOTAL CDBG FUND
617,043
663,121
CARADCO COMMUNITY DEVELOPMENT BLOCK GRANT FUND
Page 6
11- Sep -12
FISCAL YEAR 2013 AMEN DM ENT #1
CITY COUNCIL
FY 13
FY 13
Expense
Revenue
Department Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Economic Developme
5C
CDBG Grant - Caradco
1,705,556
263
2632341
45771
C/O
TOTAL CARADCO CDBG FUND
-
1,705,556
UDAG FUND
Economic Developme
5C
Job Creation - Loans
21,480
265
2651246
62764
C/O
Economic Developme
5C
Historic Preservation - Revolving Loans
31,247
265
2651247
62764
C/O
Economic Developme
5C
Airport Revenue Guarantee - Pay to Other Agency
150,000
265
2651796
62761
C/O
TOTAL UDAG FUND
202,727
-
STATE RENTAL REHAB FUND
Housing & Comm Deg
5C
Homeownership Rehab Program- Construction
480,837
270
2701065
73210
C/O
Housing & Comm Deg
5C
Homeownership Rehab Program- Construction
9,293
270
2701065
73210
C/O
Housing & Comm Deg
5C
Home - Rental Five Points
36,845
270
2701250
73210
C/O
TOTAL STATE RENTAL REHAB FUND
526,975
-
LEAD PAINT GRANT FUND
Housing & Comm Deg
5
Lead Paint Grant
275,630
275
2752429
44310
C/O
Housing & Comm Deg
5
Lead Paint Grant - Training Fees
5,665
275
27561211
62360
C/O
Housing & Comm Deg
5
Lead Paint Grant - Software
33,668
275
27561200
71123
C/O
Housing & Comm Deg
5
Lead Paint Grant - Grants
24,650
275
2752429
62764
C/O
TOTAL LEAD PAINT GRANT FUND
63,983
275,630
CABLE TV FUND
City Manager
6
Public Information - Printing & Binding
20,000
290
29072300
62090
C/O
TOTAL CABLE TV FUND
20,000
-
STREET CONSTRUCTION FUND
Engineering
2C
Signalization Program - Equipment Acquisition
79,381
300
3001011
73410
C/O
Engineering
2C
Fiber Optic Conduit Project - Construction
78,173
300
3001017
73211
C/O
Engineering
2C
Brunskill Rd Bridge Repl - Construction
718,169
300
3001077
73211
C/O
Engineering
2C
Brunskill Rd Bridge Repl - State Grant
722,000
300
3001077
45701
C/O
Engineering
2C
Bridge Repairs /Maintenance - Construction
2,600
300
3001258
73211
C/O
Engineering
2C
Southwest Arterial- Construction Not Building
3,931,675
300
3001287
73113
C/O
Engineering
2C
Southwest Arterial - SAFETEA -LU
6,958,717
300
3001287
45771
C/O
Engineering
2C
Southwest Arterial- County Match
511,885
300
3001287
46205
C/O
Engineering
2C
White Water Creek Bridge - State Grant
13,650
300
3001634
45701
C/O
Engineering
2C
White Water Creek Bridge - Private Participant
10,000
300
3001634
53102
C/O
Engineering
2C
Sub - Divisions Subdrains - Construction Not Building
173,360
300
3002023
73211
C/O
Engineering
2C
Sub - Divisions Subdrains- Consulting Engineers
28,125
300
3002023
62712
C/O
Engineering
2C
US 61/151 Corridor- State Grants - ICAAP
19,953
300
3002028
45701
C/O
Engineering
2C
US 61/151 Corridor- Federal Pass Thru Grant - USTEP
5,323
300
3002028
45771
C/O
Engineering
2C
US 61/151 Corridor- Federal Pass Thru Grant - STP
12,889
300
3002028
45771
C/O
Engineering
2C
US 61/151 Corridor -3R Primary
2,908
300
3002028
45771
C/O
Engineering
2C
NW Arterial Capacity Imp - Contt. Contr Not Building
132,349
300
3002029
73211
C/O
Engineering
2C
Cedar Cross Reconstruction - State Highway Assistance
1,280,000
300
3002139
45725
C/O
Engineering
2C
Cedar Cross Reconstruction - Land Acquisition
307,498
300
3002139
73111
C/O
Engineering
2C
Cedar Cross Reconstruction - Construction
1,412,000
300
3002139
73211
C/O
Engineering
2C
Cedar Cross Reconstruction - Consulting Eng
49,817
300
3002139
62712
C/O
Engineering
2C
Kaufmann Ave Resurfacing - Fed Pass thru State Grant
36,177
300
3002140
45771
C/O
Engineering
2C
SW Arterial - US 20 Cap Imp - Consulting
43,927
300
3002247
62712
C/O
Page 7
11- Sep -12
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Page 8
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Engineering
2C
SW Arterial - US 20 Cap Imp - State Grants
100,000
300
3002247
45701
C/O
Engineering
2C
N Grandview Estates Road- Construction
210,204
300
3002336
73211
C/O
Engineering
2C
N Grandview Estates Road- Reimbursements
33,163
300
3002336
53620
C/O
Engineering
2C
Manson Road Bridge - FEMA
75,000
300
3002349
44405
C/O
Engineering
2C
Signalization Program - Equipment Acquisition
76,868
300
3001011
73410
C/O
Engineering
2C
Traffic Signal Masterarm Rep. - Construction
15,097
300
3001133
73211
C/O
Engineering
2C
Traffic Signal Interconnect - Construction Not Building
41,854
300
3001266
73211
C/O
Engineering
2C
Traffic Controller Replacement - Equip Acquisition
52,000
300
3001274
73410
C/O
Engineering
2C
Street Light Replacement - Construction
42,698
300
3001549
73211
C/O
Engineering
2C
Signal Intersec Reconstruc- Construction
14,359
300
3001615
73211
C/O
Engineering
2C
Traffic Signal Fiber Optic Net - Construction
57,175
300
3001631
73211
C/O
Engineering
2C
Traffic Signal Video Detection
6,804
300
3001816
73211
C/O
Engineering
2C
Ramona /Pamela- Eng Division Services
(290)
300
3001819
62811
C /O- Prespend FY13
Engineering
2C
Fiber Optic Conduit - Misc - Construction
51,466
300
3002144
73211
C/O
Engineering
2C
Crosswalk Warning Devices
20,000
300
3002246
73211
C/O
Engineering
2C
Central Avenue Payment - IDOT
59,846
300
3002248
45725
C/O
Engineering
2C
Street Light /Signal Knockdown - Construction
23,135
300
3002252
73211
C/O
Engineering
2C
ITS Traffic Control Equipment
27,829
300
3002253
73211
C/O
Engineering
2C
JFK @ Wacker Signal Reconstruction - Construction
44,500
300
3002254
73211
C/O
Engineering
2C
Pennsylvania at Radford Intersection - Eng Division Services
20,000
300
3002256
62811
C/O
Engineering
2C
Pennsylvania at Radford Intersection - Construction
140,000
300
3002256
73211
C/O
Engineering
2C
Portable Radar Speed Sign
13,373
300
3002257
73211
C/O
Engineering
2C
University & Asbury Intersection
189,539
300
3002324
73211
C/O
Engineering
2C
University & Asbury Intersection - Fed Aid
116,000
300
3002324
44145
C/O
Engineering
2C
Video Detection Camera Upgrade
40,000
300
3002325
73410
C/O
Engineering
2C
Cedar Cross Lighting
16,000
300
3002326
73211
C/O
Engineering
2C
Catfish Creek Bridge Fiber
9,434
300
3002327
62712
C/O
Engineering
2C
School Zone Count -Down
4,000
300
3002328
73211
C/O
Public Works
2C
Curb Ramp Program - Construction
(33,399)
300
3001230
73211
C /O- Prespend FY13
Public Works
2C
Downtown Sign /Post Replacement - Signage
(11,269)
300
3001938
71227
C /O- Prespend FY13
Engineering
2C
White Water Creek Bridge - Construction
(15,183)
300
3001634
73211
C /O - Prespend FY13
Engineering
2C
N Cascade Road Reconstruction - Consulting Engineers
(18,608)
300
3002021
62712
C /O- Prespend FY13
Engineering
2C
Green Alley Pilot Project
(1,267)
300
3002044
73211
C /O- Prespend FY13
Engineering
2C
Street Construction - General
(60,000)
300
3002142
73211
C /O- Prespend FY13
Engineering
2C
US 61/151 Corridor - Construction
(117,932)
300
3002028
73211
C /O- Reduce Encumbrances
Engineering
2C
Central Avenue Payment - Construction
(574,458)
300
3002248
73211
C/O - Reduce Encumbrances
Public Works
2C
Curb Ramp Program - Construction
52,015
300
3001230
73211
C /O- Shift from Asphalt Milling
Public Works
2C
Downtown Sign /Post Replacement - Signage
11,269
300
3001938
71227
C /O- Shift from Asphalt Milling
Engineering
2C
Traffic Consultant Serv- Consulting Engineers
(28,494)
300
3001815
62712
C /O- Prespend FY13
TOTAL STREET CONSTRUCTION FUND
7,275,793
9,957,511
SALES TAX FUND (20 %)
Parks Division
4C
Northend Trail Lighting - Construction
145,000
350
3501129
73211
C/O
Parks Division
4C
Renovate Park Water System - Consulting
11,578
350
3501158
62712
C/O
Parks Division
4C
Renovate Park Water System - Construction
31,794
350
3501158
73211
C/O
Parks Division
4C
Renovate Park Water System - Construction
388
350
3501158
73211
C/O
Parks Division
4C
Renovate Park Sidewalks - Construction
9,050
350
3501438
73211
C/O
Parks Division
4C
EPP Replace Walkway - Connt Cont- Not Bldg
5,372
350
3501453
73211
C/O
Parks Division
4C
Street Tree Program - Tree Planting
7,483
350
3501458
73311
C/O
Parks Division
4C
Riverwalk Baskets - Irrigate
12,000
350
3501937
73211
C/O
Page 8
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Page 9
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Parks Division
4C
Pet Park Terminal Street - Construction
94,308
350
3501978
73211
C/O
Parks Division
4C
Allison- Henderson Remodel Interior- Construction
4,854
350
3502291
73210
C/O
Parks Division
4C
McAleece Replace Fence Fabric- Construction
11,125
350
3502294
73211
C/O
Parks Division
4C
McAleece Fence on Bluff- Construction
5,220
350
3502296
73211
C/O
Civic Center Division
4C
Theatre Tuck -point Exterior - Construction
247,000
350
3501708
73210
C/O
Civic Center Division
4C
Theatre Tuckpoint Exterior- Consultant Services
2,200
350
3501708
62716
C/O
Civic Center Division
4C
Seal Concrete Walkways - Construction
25,000
350
3502303
73211
C/O
Conference Center
6C
Grand River Center Chairs
3,850
350
3501990
71212
C/O
Conference Center
6C
Grand River Center Level Floors
20,234
350
3501991
73210
C/O
Library
4C
Elm Veneer Replacement
10,425
350
3502308
73210
C/O
Public Works
2C
Steps, Railings and Fencing - Construction Not Building
9,417
350
3501432
73211
C/O
Public Works
2C
Floodwall Post Flood Repair- Construction
34,033
350
3501445
73211
C/O
Public Works
2C
Cold Storage Building Mezz- Construction Not Building
17,782
350
3502037
73211
C/O
Public Works
2C
Ice Harbor Gates Timber
18,958
350
3502222
73211
C/O
Public Works
2C
Port Amenities Project
1,420
350
3502038
73510
C/O
Engineering
2C
Stone Retaining Walls- Construction Not Building
1,270
350
3501029
73211
C/O
Engineering
2C
Accessibility Barriers- Construction
58,458
350
3501034
73210
C/O
Engineering
2C
Rivertront Leasehold Improvements- Consultant Services
66,284
350
3501053
62716
C/O
Engineering
2C
Decorative Concrete Maint- Construction
154,795
350
3501630
73211
C/O
Engineering
2C
Sidewalk Financial Assistance
12,451
350
3501727
62761
C/O
Engineering
2C
Rehab Railroad Tracks
79,507
350
3501465
73211
C/O
Engineering
2C
Ice Harbor Maintenance /Dredging
288,106
350
3501466
73211
C/O
Engineering
2C
Transient Docks - Main Channel - Big Tier Grant
1,272,671
350
3501861
45771
C/O
Engineering
2C
Millwork District Security Cameras
66,372
350
3502329
72417
C/O
Engineering
2C
Downtown Street Light Replacement- Construction
4,979
350
3501608
73211
C/O
Building Services
6C
City Hall Annex Maintenance - Construction
28,577
350
3501757
73210
C/O
Building Services
6C
Smart Meters - Construction
259,713
350
3502259
73210
C/O
Building Services
6C
Smart Meters - Consultant
13,400
350
3502259
62712
C/O
Planning Services
5C
Rivertront 2000 Plan - Consulting
5,000
350
3501015
62712
C/O
Building Services
6C
18th Street Building Improvements
207,000
350
3501975
73210
C /O- Land Sales
Engineering
2C
Stone Retaining Walls- Construction Not Building
(9,348)
350
3501029
73211
C /O- Prespend FY13
Building Services
6C
18th Street Building Improvements - Tax Credits
672,207
350
3501975
53620
C/O
Building Services
6C
18th Street Building Improvements
(48,988)
350
3501975
73210
C /O- Prespend FY13
Parks Division
4C
Street Tree Program - Tree Planting
5,750
350
3501458
73311
C/O - Private Participant
Conference Center
6C
Grand River Center Level Floors
70,768
350
3501991
73210
C/O - shift from carpet
Conference Center
6C
Grand River Center Level Floors
12,000
350
3501991
73210
C/O - Shift from Mechanic Room
Conference Center
6C
Grand River Center Level Floors
70,202
350
3501991
73210
C/O - shift from paint
Conference Center
6C
Grand River Center Level Floors
130,250
350
3501991
73210
C/O - shift from Vet's Ballfeld
TOTAL SALES TAX FUND
2,205,037
1,944,878
GENERAL CONSTRUCTION FUND
Parking Division
8C
Port of Dubuque Ramp Repairs - Construction
620,786
360
3601957
73211
C/O
Engineering
2C
Millworking District Street- Construction
(25,271)
360
3602137
73211
C/O
Engineering
2C
7th Street Improvements - Construction
3,988,376
360
3602441
73211
C/O
Engineering
2C
7th Street Improvements - RISE Grant
680,892
360
3602441
45741
C/O
Economic Devlopmt
5C
Industrial Site Development - North Sievert - RISE Grant
57,736
360
3601943
45741
C/O
Economic Devlopmt
5C
DICW - Wildflowers - Landscaping Contract
154,970
360
3602158
73310
C/O
Economic Devlopmt
5C
DICW - Wildflowers - Consulting Engineers
10,000
360
3602158
62712
C/O
Economic Devlopmt
5C
Design South Sievert Farm - Construction
4,067,150
360
3602160
73211
C/O
Economic Devlopmt
5C
Design South Sievert Farm - Construction
82,776
360
3602160
73211
C/O - Shift from N. Sievert
Page 9
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Page 10
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Economic Devlopmt
5C
Design South Sievert Farm - Construction
5,400
360
3602160
73211
C/O
Economic Devlopmt
5C
Design South Sievert Farm - Construction
1,127
360
3602160
73211
C/O
Economic Devlopmt
5C
Design South Sievert Farm - Construction
1,020
360
3602160
73211
C/O
Economic Devlopmt
5C
Downtown Housing Incentive- Pay to Other Agency
1,858,509
360
3602267
62761
C/O
Economic Devlopmt
5C
Downtown Housing Incentive- Pay to Other Agency
1,072
360
3602267
62761
C/O
Economic Devlopmt
5C
Downtown Housing Incentive- Pay to Other Agency
4,589
360
3602267
62761
C/O
Economic Devlopmt
5C
Downtown Housing Incentive- Pay to Other Agency
5,793
360
3602267
62761
C/O
Economic Devlopmt
5C
Millwork District Parking Imp - Construction
1,553,049
360
3602250
73211
C/O
Economic Devlopmt
5C
Millwork District Parking Imp - Construction
11,735
360
3602250
73211
C/O
Economic Devlopmt
5C
Millwork District Parking Imp - Construction
(1,230,000)
360
3602250
73211
C/O - Shift to Intermodal
Engineering
2C
1 Way to 2 Way Conversion
1,493,216
360
3602442
73211
C/O
Engineering
2C
1 Way to 2 Way Conversion
(120,000)
360
3602442
73211
C /O- Shift to Intermodal
TOTAL GENERAL CONSTRUCTION FUND
12,484,297
738,628
AIRPORT CONSTRUCTION FUND
Airport Department
2C
Runway Safety Area
24,205
390
3901788
73210
C/O
Airport Department
2C
Terminal - RW 31 Parallel - Consulting Engineers
248,100
390
3901891
62712
C/O
Airport Department
2C
Terminal - RW 31 Parallel - Construction
3,181,772
390
3901891
73211
C/O
Airport Department
2C
Terminal - RW 31 Parallel -FAA Funds
3,295,567
390
3901891
44105
C/O
Airport Department
2C
Extend Gem's Aviation Ramp - Consulting Engineers
5,000
390
3901893
62712
C/O
Airport Department
2C
Extend Gem's Aviation Ramp - Construction
49,000
390
3901893
73211
C/O
Airport Department
2C
Hanger Repairs /Replace - Construction
3,054
390
3902008
73210
C/O
Airport Department
2C
Terminal Site work - Consulting Engineers
15,330
390
3902009
62712
C/O
Airport Department
2C
Terminal Site work - Construction - 15% Contingency
28,462
390
3902009
73211
C/O
Airport Department
2C
Terminal Site work - FAA Funds
2,411,404
390
3902009
44105
C/O
Airport Department
2C
Paint Hangar Exteriors - Construction
13,332
390
3902125
73210
C/O
Airport Department
2C
Paint Hangar Exteriors - Construction
20
390
3902125
73210
C/O
Airport Department
2C
New Terminal Facility- Construction
6,861,886
390
3902213
72310
C/O
Airport Department
2C
New Terminal Facility- FAA Funds
6,413,565
390
3902213
44105
C/O
Airport Department
2C
New Terminal Facility- State Grants
431,298
390
3902213
45701
C/O
Airport Department
2C
New Term Facilities Roads and Aprons - Construction
106,127
390
3902316
62716
C/O
Airport Department
2C
New Term Facilities Roads and Aprons - FAA Funds
103,948
390
3902316
44105
C/O
Airport Department
2C
New Terminal Facilities Roads and Aprons - RISE Grant
116,804
390
3902316
45741
C/O
Airport Department
2C
Hangar Paving - Construction
68,332
390
3902346
73211
C/O
Airport Department
2C
Hangar Paving - FAA
91,156
390
3902346
41105
C/O
Airport Department
2C
Terminal Sitework - Construction
540,775
390
3902009
73211
C /O- incr. FAA
Airport Department
2C
Terminal Sitework- Consulting Engineers
82
390
3902009
62712
C /O -int
Airport Department
2C
Terminal Sitework- Consulting Engineers
550
390
3902009
62712
C/O -reimb
TOTAL AIRPORT CONSTRUCTION FUND
11,146,027
12,863,742
DEBT SERVICE FUND
Debt Service
7
Debt Service - BAB Subsidy
1,914
400
40055400
44100
BAB Subsidy
Debt Service
7
Debt Service - BAB Subsidy
21,749
400
40013800
44100
BAB Subsidy
Debt Service
7
Debt Service - BAB Subsidy
3,532
400
40051300
44100
BAB Subsidy
TOTAL DEBT SERVICE FUND
-
27,195
BOND PROCEEDS FUND
Debt Service
7
Bond Proceeds
(6,321,967)
440
44010440
54210
Borrowing done in FY12
TOTAL BOND PROCEEDS FUND
-
(6,321,967)
Page 10
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Department Program Description
STORMWATER OPERATING FUND
Engineering 8 Stormwater Debt Service
TOTAL STORMWATER OPERATING FUND
PARKING OPERATING FUND
Parking Division 8 Parking Debt Service
TOTAL PARKING OPERATING FUND
FY 13 FY 13
Expense Revenue
Amount Amount Fund Activity /CIP Account Explanation
17,843 620 62055620 44100 BAB Subsidy
17,843
141,532 630 63046360 44100 BAB Subsidy
141,532
REFUSE FUND
Public Works
8C
Dual Packer Recylcle Vehicles
587,769
670
6701533
73410
C/O
Public Works
8C
Public Works Fleet GPS /AVL Project
20,000
670
6701935
73410
C/O
Public Works
8C
Litter and Recycling Receptacle - Receptacles
60,000
670
6702226
72821
C/O
Public Works
8
Refuse Collection - Tipper Carts and lids
1,110
670
67054500
71221
C/O
Public Works
8
Yard Waste Collection - Legal Notice & Ads
365
670
67054510
62130
C/O
Public Works
8
Yard Waste Collection - Promotion
500
670
67054510
62140
C/O
Public Works
8
Recycling- Printing and Binding
559
670
67054530
62090
C/O
Public Works
8
Recycling- Legal Notices &Ads
865
670
67054530
62130
C/O
Public Works
8
Recycling- Promotion
3,303
670
67054530
62140
C/O
Public Works
8
Recycling- Recycling Containers
14,529
670
67054530
72818
C/O
TOTAL REFUSE FUND
689,000
-
AMERICA'S RIVER PROJECT FUND
Engineering
8C
Art in Port of Dubuque - Consultant Services
156,593
700
7001853
62731
C/O
TOTAL AMERICA'S RIVER PROJECT FUND
156,593
-
SANITARY SEWER CONSTRUCTION FUND
Water & Resource Re
8C
Beadle System Upgrade - Construction - Not Building
42,929
710
7101339
73211
C/O
Water & Resource Re
8C
WPC Plant Facility Study- SRF Bond Proceeds
11,696,491
710
7101837
54230
C/O
Water & Resource Re
8C
Pumping Station Telemetry - Equipment Acquisition
61,590
710
7101930
73410
C/O
Water & Resource Re
8C
Terminal Street Mag Meter Repair - Consulting
287,755
710
7102211
62712
C/O
Water & Resource Re
8C
Terminal Street Mag Meter Repair- Consulting
1,006
710
7102211
62712
C/O
Water & Resource Re
8C
Bradley Street Pumping Station - Consulting Engineers
8,925
710
7102315
62712
C/O
Water & Resource Re
8C
Bradley Street Pumping Station - Construction
93,812
710
7102315
73211
C/O
Water & Resource Re
8C
Bradley Street Pumping Station - Construction
432
710
7102315
73211
C/O
Public Works
8C
Sewer Pipeline Inspection Equipment - Equipment
14,486
710
7101840
73410
C/O
Public Works
8C
Mobile GIB System - Equipment
10,000
710
7102225
73410
C/O
Engineering
8C
Green Alley Pilot Project - Bond Proceeds
(50,000)
710
7102044
54210
FY12 Borrowed
Engineering
8C
King Street Sanitary Sewer- Bond proceeds
(50,500)
710
7102407
54210
FY12 Borrowed
Engineering
8C
Green Alley SEP Project - Bond Proceeds
(180,000)
710
7102411
54210
FY12 Borrowed
Engineering
8C
Cedar Lift Pump /Generator /Trailer- Bond Proceeds
(225,000)
710
7102412
54210
FY12 Borrowed
Engineering
8C
Relocate 30" Main Old Garage- Bond Proceeds
(849,124)
710
7102412
54210
FY12 Borrowed
Engineering
8C
Sewer Conn Asst -Low /Mod - Miscellaneous Services
34,717
710
7101067
62731
C/O
Engineering
8C
Sanitary Sewer Internal Main - Construction
226,000
710
7101293
73510
C/O
Engineering
8C
Sanitary Sewer Internal Main - Private Participant
222,362
710
7101293
53102
C/O
Engineering
8C
I &I Reduction Program - Construction Not Bldg
6,712
710
7101294
73211
C/O
Engineering
8C
Lateral Repl Asst. Low Inc- Eng. Division Services
20,000
710
7101297
62811
C/O
Engineering
8C
Nightengale Lane Sanitary Sewer- Eng Division Services
40,000
710
7101301
62811
C/O
Engineering
8C
Nightengale Lane Sanitary Sewer- Construction
269,908
710
7101301
73510
C/O
Engineering
8C
Sewer Lateral Assistance - Eng Division Services
46,448
710
7101309
62811
C/O
Engineering
8C
Sewer Lateral Assistance - Construction Not Bldg
55,216
710
7101309
73211
C/O
Page 11
FISCAL YEAR 2013 AMEN DM ENT #1
CITY COUNCIL
11- Sep -12
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Engineering
8C
Laterals - I &I Reduction
10,966
710
7101320
73211
C/O
Engineering
8C
Alley Washington- Jackson Sewer - Construction
130,000
710
7101327
73211
C/O
Engineering
8C
LorasA/Valnut to Prairie St Sewer- Construction
54,572
710
7101328
73211
C/O
Engineering
8C
Hwy 20 Annexation Sanitary Sewers - Construction
262,973
710
7101336
73211
C/O
Engineering
8C
Sanitary Sewer Lining Program - Const Not Bldg
111,501
710
7101637
73211
C/O
Engineering
8C
Street Program /Related- Const Not Bldg
224,475
710
7101638
73211
C/O
Engineering
8C
Monroe St Sanitary Sewer- Construction
6,947
710
7101797
73211
C/O
Engineering
8C
Southfork Interceptor- Consulting Engineers
26,340
710
7101899
62712
C/O
Engineering
8C
Southfork Interceptor- Const Cont - Not Bldg
371,991
710
7101899
73211
C/O
Engineering
8C
Century Sewer Manholes - Engineering
4,000
710
7101905
62811
C/O
Engineering
8C
Century Sewer Manholes - Construction
15,000
710
7101905
73211
C/O
Engineering
8C
Green Alley Pilot Project - Construction
50,183
710
7102044
73211
C/O
Engineering
8C
Laurel St Sanitary Sewer- Eng Division Services
28,777
710
7102130
62811
C/O
Engineering
8C
Laurel St Sanitary Sewer - Const Not Bldg
300,000
710
7102130
73211
C/O
Engineering
8C
North Fork Sanitary Sewer Improvements- SRF
362,057
710
7102178
54230
C/O
Engineering
8C
Brunswick Sanitary Sewer - Construction
58,490
710
7102232
73211
C/O
Engineering
8C
Brunswick Sanitary Sewer- Engineering Division Services
8,146
710
7102232
62811
C/O
Engineering
8C
Fairway Dr Sanitary Sewer - Construction
20,000
710
7102233
73211
C/O
Engineering
8C
Fairway Dr Sanitary Sewer- Engineering Division Services
3,500
710
7102233
62811
C/O
Engineering
8C
Southgate Sanitary Sewer - Construction
34,000
710
7102234
73211
C/O
Engineering
8C
Southgate Sanitary Sewer- Eng Division Services
4,000
710
7102234
62811
C/O
Engineering
8C
SEP Green Alleys
15,288
710
7102350
73211
C/O
Engineering
8C
Hawthorne Sanitary - Engineering
4,000
710
7102322
62811
C/O
Engineering
8C
Hawthorne Sanitary - Construction
15,065
710
7102322
73211
C/O
Engineering
8C
Knob Hill - Duggan Dr- Engineering
15,000
710
7102322
62811
C/O
Engineering
8C
Knob Hill - Duggan Dr- Construction
93,394
710
7102322
73211
C/O
Engineering
8C
Forcemain Repair
650,000
710
7102347
54210
C/O
City Manager
8C
GIB Enhancements - Peripherals, Computer
5,291
710
7101946
71120
C/O
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
8,840,716
710
7101837
73210
C/O
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
626
710
7101837
73210
C/O
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
501,397
710
7101837
73210
C/O
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
5,150
710
7101837
73210
C/O
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
149,096
710
7101837
73210
C/O - Shift from 02 Mixers
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
70,291
710
7101837
73210
C/O - Shift from Perry St Pumping
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
2,049
710
7101837
73210
C/O - Shift from Sluice Grates
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
24,617
710
7101837
73210
C/O - Shift from Standby Generator
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
13,283
710
7101837
73210
C/O - Shift from Switch Gear
Engineering
8C
Historic Millwork - Sanitary Sewer - Const Not Bldg
(53,146)
710
7102129
73211
C/O - Over Encumbered
Water & Resource Re
8C
WPC Plant Facility Study- Construction Building
(270,531)
710
7101837
73210
C /O- Prespend FY13
Engineering
8C
Historic Millwork - Sanitary Sewer- Const Not Bldg
(118,458)
710
7102129
73211
C/O - Prespend FY13
TOTAL SANITARY SEWER CONST FUND
12,258,925
11,576,286
STORM WATER CONSTRUCTION FUND
Parks Division
8C
Eagle Point Park Stormwater - Construction
112,312
720
7202301
73211
C/O
Parks Division
8C
Bee Branch Trees Forever- Tree Planting
6,130
720
7202337
73311
C/O
Public Works
8C
Sewer Pipeline Inspection Equipment - Equipment
5,404
720
7201840
73410
C/O
Public Works
8C
PW Fleet GPS Project- Pager /Radio Equipment
10,000
720
7201935
73410
C/O
Public Works
8C
Mobile GIB System - Equipment
10,000
720
7202225
73410
C/O
Public Works
8C
Bee Branch Pump Station
97,370
720
7202319
73211
C/O
Engineering
8C
Green Alley Pilot Project - Bond Proceeds
(33,000)
720
7202044
54210
FY12 Borrowed
Page 12
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Page 13
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Engineering
8C
Windsor Storm - Bond Proceeds
(39,200)
720
7202414
54210
FY12 Borrowed
Engineering
8C
W 32nd Detention Basin - Bond Proceeds
(41,500)
720
7202416
54210
FY12 Borrowed
Engineering
8C
Millwork District - Bond Proceeds
(91,000)
720
7202131
54210
FY12 Borrowed
Engineering
8C
14th Street - Bond Proceeds
(200,000)
720
7202418
54210
FY12 Borrowed
Engineering
8C
Catch BasinA/Vestside - Construction Not Building
77,457
720
7201081
73211
C/O
Engineering
8C
Carter Road Culvert - Eng Division Services
9,000
720
7201356
62811
C/O
Engineering
8C
Carter Road Culvert- Construction
58,000
720
7201356
73211
C/O
Engineering
8C
Gunite Rock Stormsewer- Construction
36,310
720
7201363
73211
C/O
Engineering
8C
General Detention Basin Silt Removal - Construction
89,523
720
7201375
73211
C/O
Engineering
8C
Bee Branch Alignment - State Revolving Loan Funds
4,672,385
720
7201654
54230
C/O
Engineering
8C
Bee Branch Alignment - State Trail Grant
100,000
720
7201654
45701
C/O
Engineering
8C
Bee Branch Alignment- National Trail Grant
1,000,000
720
7201654
45771
C/O
Engineering
8C
Bee Branch Alignment- Construction
3,524,874
720
7201654
73211
C/O
Engineering
8C
Bee Branch Alignment- Construction
(1,928,327)
720
7201654
73211
Adjust to actual
Engineering
8C
Bond Proceeds- Bee Branch
1,472,179
720
7201654
54210
C/O
Engineering
8C
Storm Sewer Cleaning - Construction
179,888
720
7201659
73211
C/O
Engineering
8C
Stoneman Road Storm Sewer- Construction
91,845
720
7201664
73211
C/O
Engineering
8C
Amy Ct Storm Sewer Imprv- Eng. Division Services
1,800
720
7201666
62811
C/O
Engineering
8C
Amy Ct Storm Sewer Improv- Construction
12,000
720
7201666
73211
C/O
Engineering
8C
32nd & Grandview Storm Improvements - Eng Division Services
38,378
720
7201808
62811
C/O
Engineering
8C
Villa St Storm Sewer Prot - Eng Division Services
11,551
720
7201809
62811
C/O
Engineering
8C
Villa St Storm Sewer Prot - Construction
95,000
720
7201809
73211
C/O
Engineering
8C
Stormwater System Assessment
295,242
720
7202015
62712
C/O
Engineering
8C
Hillcrest /Keyway Storm Sewer - Construction
30,000
720
7202016
73211
C/O
Engineering
8C
Hillcrest /Keyway Storm Sewer- Consulting Engineers
4,300
720
7202016
62712
C/O
Engineering
8C
Green Alley Pilot Project - Construction
33,000
720
7202044
73211
C/O
Engineering
8C
Iowa Street Storm Sewer- Engineering
2,933
720
7202132
62811
C/O
Engineering
8C
Iowa Street Storm Sewer- Construction
35,509
720
7202132
73211
C/O
Engineering
8C
Kane Kaufman Storm Sewer- Engineering
22,788
720
7202133
62811
C/O
Engineering
8C
Kane Kaufman Storm Sewer- Construction
148,382
720
7202133
73211
C/O
Engineering
8C
Peru Road Storm Sewer- Engineering
3,144
720
7202133
62811
C/O
Engineering
8C
Peru Road Storm Sewer- Construction
10,486
720
7202133
73211
C/O
Engineering
8C
Cedar Cross Rd Storm - Engineering
5,000
720
7202238
62811
C/O
Engineering
8C
Cedar Cross Rd Storm - Construction
10,000
720
7202238
73211
C/O
Engineering
8C
Floodwall Breach Analysis
30,000
720
7202239
62811
C/O
Engineering
8C
Ice Harbor /Maus Aux Pump
50,000
720
7202240
62811
C/O
Engineering
8C
Lower Bee Branch Construction
910
720
7202281
73211
C/O
Engineering
8C
Millwork District Storm Sewer- Construction
(86,064)
720
7202131
73211
C /O- Over Encumbered
Engineering
8C
Millwork District Storm Sewer- Construction
(91,000)
720
7202131
73211
C /O- Prespend FY13
Engineering
8C
Windsor Storm - Construction
(26)
720
7202414
73211
C /O - Prespend FY13
TOTAL STORM WATER CONST FUND
3,043,119
6,839,864
PARKING CONSTRUCTION FUND
Parking Division
8C
Seal Coating Parking Lots - Consultant Services
10,000
730
7301380
62716
C/O
Parking Division
8C
Seal Coating Parking Lots - Construction Contract
250,000
730
7301380
73211
C/O
Parking Division
8C
Locust Ramp Video Cameras - Bond Proceeds
(175,000)
730
7302427
54210
FY12 Borrowed
Parking Division
8C
Locust Street Ramp Repairs - Construction
250,000
730
7301671
73210
C/O
Parking Division
8C
Port of Dubuque Ramp Maint - Construction
273,090
730
7302162
73211
C/O
Parking Division
8C
7th Street Pedestrian Walkway Study- Consulting
10,000
730
7302163
62712
C/O
Parking Division
8C
POD Ramp Special Expenses
25,558
730
7302260
73211
C/O
Page 13
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Page 14
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount
Fund
Activity /CIP
Account Explanation
Building Services
8C
Smart Meters - Construction
59,000
730
7302259
73210
C/O
City Manager
8C
GIB Enhancements - Peripherals, Computer
5,291
730
7301946
71120
C/O
TOTAL PARKING CONSTRUCTION FUND
882,939
(175,000)
WATER CONSTRUCTION FUND
Water Department
8C
GIB Maintenance /Upgrade- Consulting Engineers
31,906
740
7401389
62712
C/O
Water Department
8C
Service Line Assistance - Misc Services
28,761
740
7401390
62731
C/O
Water Department
8C
Eagle Point Plant Office & Lab Pump Room - Construction
50,671
740
7401397
73210
C/O
Water Department
8C
Water Internal Lines /Loan - Construction
330,530
740
7401398
73211
C/O
Water Department
8C
Water Internal Lines /Loan - Consulting Engineers
30,000
740
7401398
62712
C/O
Water Department
8C
Water Internal Lines /Loan - Private Participant
288,503
740
7401398
53102
C/O
Water Department
8C
Water Meter Exchange
50,952
740
7401400
73410
C/O
Water Department
8C
Annual Tank Inspection
12,000
740
7401412
62712
C/O
Water Department
8C
Shallow Well Rehab
4,035
740
7401415
73211
C/O
Water Department
8C
Water Main Replacements - Bond Proceeds
(400,000)
740
7401389
54210
Borrowed FY12
Water Department
8C
Fire Hydrant Replacements- Bond Proceeds
(42,000)
740
7401409
54210
Borrowed FY12
Water Department
8C
Main Extension - Bond Proceeds
(125,000)
740
7401411
54210
Borrowed FY12
Water Department
8C
Bunker Hill Pump Station - Bond Proceeds
(325,000)
740
7401422
54210
Borrowed FY12
Water Department
8C
Asbury Tank Painting
(592,500)
740
7402204
54210
Borrowed FY12
Water Department
8C
North Softening Basin - Bond Proceeds
(120,000)
740
7402396
54210
Borrowed FY12
Water Department
8C
McAleece Water Improvements
(91,000)
740
7402397
54210
Borrowed FY12
Water Department
8C
Eagle Point Treatment- Bond Proceeds
(85,000)
740
7402398
54210
Borrowed FY12
Water Department
8C
Water Usage Audit - Bond Proceeds
(50,000)
740
7402399
54210
Borrowed FY12
Water Department
8C
North Plant Motor Control - Bond Proceeds
(20,000)
740
7402401
54210
Borrowed FY12
Water Department
8C
Bunker Hill Pump Station - Construction
239,347
740
7401422
73211
C/O
Water Department
8C
Bunker Hill Pump Station - Construction
878
740
7401422
73211
C/O
Water Department
8C
Roosevelt Rd. Main Ext. - Consult Eng
21,493
740
7401672
62712
C/O
Water Department
8C
Roosevelt Rd. Main Ext. - Construction
75,000
740
7401672
73211
C/O
Water Department
8C
Roosevelt Rd. Main Ext. - Bond Proceeds
75,000
740
7401672
54210
C/O
Water Department
8C
Olympic Heigths Pump Station - Construction
18,558
740
7402031
73211
C/O
Water Department
8C
Drinking Water Study- Consulting Engineers
32,959
740
7402147
62712
C/O
Water Department
8C
Drinking Water Study- Consulting Engineers
108
740
7402147
62712
C/O
Water Department
8C
Fire Hydrant Painting - Miscellaneous Services
88,150
740
7402201
62731
C/O
Water Department
8C
Water Circulator System - Construction
31,657
740
7402202
73510
C/O
Water Department
8C
Water Circulator System - Construction
192
740
7402202
73510
C/O
Water Department
8C
Asbury Tank Painting - Consulting
10,000
740
7402204
62712
C/O
Water Department
8C
Asbury Tank Painting - Construction Not Building
75,253
740
7402204
73211
C/O
Water Department
8C
Asbury Tank Painting - Construction Not Building
346
740
7402204
73211
C/O
Water Department
8C
Pump Replacement Vacuum Filter- Pumps
25,000
740
7402205
71511
C/O
Water Department
8C
Park Hill Pumping Roof- Construction
15,179
740
7402207
73210
C/O
Water Department
8C
Electrical Usage Integrated - Equipment
62,280
740
7402210
62716
C/O
Water Department
8C
Electrical Usage Integrated - Equipment
466
740
7402210
62716
C/O
Water Department
8C
Mobile GIB System
40,000
740
7402225
73510
C/O
Water Department
8C
Ramp Water Utility Relocate- Const Not Bldg
131,327
740
7402261
73211
C/O
Water Department
8C
Ramp Water Utility Relocate - Const Not Bldg
534
740
7402261
73211
C/O
Water Department
8C
Eagle Point Plant Driveway and Parking Lot - Construction
60,000
740
7402309
73211
C/O
Water Department
8C
Eagle Point Plant Driveway and Parking Lot - Consulting
5,000
740
7402309
62712
C/O
Water Department
8C
Well Field Electrical Updates- Consulting
22,671
740
7402309
62712
C/O
Water Department
8C
Well Field Electrical Updates- Construction
141,439
740
7402309
73211
C/O
Water Department
8C
Well Field Electrical Updates- Construction
696
740
7402309
73211
C/O
Page 14
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Department
Program Description
Water Department
8C
Manson Road Bridge Water Main - FEMA
Water Department
8C
#7 Well House Structure Update - Construction
Water Department
8C
#7 Well House Structure Update - Construction
Water Department
8C
Auto Meter Reading System Maintenance - Construction
City Manager
8C
GIB Enhancements - Peripherals, Computer
Information Services
8C
Water Micro-Computers
Water Department
8C
Millwork Dist - Water Main - Construction
12,000
100
TOTAL WATER CONSTRUCTION FUND
LANDFILL FUND
Public Works 8 Landfill - Consulting Engineers
TOTAL LANDFILL FUND
FY 13 FY 13
Expense Revenue
Amount Amount Fund
150,000 740
10,935 740
89 740
15,000 740
2,841 740
57,257 740
(66,566) 740
1,656,944 (1,336,997)
Activity /CIP Accoun
7402349 44405
7402313 73211
7402313 73211
7402314 73211
7401946 71120
7401069 71124
7402145 73211
t Explanation
C/O
C/O
C/O
C/O
C/O
C/O
C/O - Over Encumberec
125,578 940 94054200 62712 C/O - Correct PO Budget
125,578
TRANSFERS
Transfer Out Transfer In
Parks Division
Trans01 Transfer from General Fund to DRA Distribution
6,000
100
10010100
91102
Trans Funds
Parks Division
Trans01 Transfer from General Fund to DRA Distribution
6,000
102
1022184
59100
Trans Funds
Conference Center
Trans02 Transfer from General Fund to Sales Tax Const Fund
12,000
100
10010100
91350
Trans Funds
Conference Center
Trans02 Transfer from General Fund to Sales Tax Const Fund
12,000
350
3501991
59100
Trans Funds
Conference Center
Trans03 Transfer from DRA Dist Fund to Sales Tax Const Fund
130,250
102
10210102
91350
Trans Funds
Conference Center
Trans03 Transfer from DRA Dist Fund to Sales Tax Const Fund
130,250
350
3501991
59102
Trans Funds
Airport Department
Trans04 Transfer from PFC Fund to Airport Construction Fund
134,305
391
39110391
91390
Trans Funds
Airport Department
Trans04 Transfer from PFC Fund to Airport Construction Fund
134,305
390
3901891
59391
Trans Funds
Airport Department
Trans05 Transfer from DRA Dist Fund to Airport Construction Fund
54,000
102
10210102
91390
Trans Funds
Airport Department
Trans05 Transfer from DRA Dist Fund to Airport Construction Fund
54,000
390
3901893
59102
Trans Funds
Airport Department
Trans06 Transfer from Gen Fund to Airport Construction Fund
28,462
100
10010100
91390
Trans Funds
Airport Department
Trans06 Transfer from Gen Fund to Airport Construction Fund
28,462
390
3902009
59100
Trans Funds
Airport Department
Trans07 Transfer from PFC Fund to Airport Construction Fund
67,179
391
39110391
91390
Trans Funds
Airport Department
Trans07 Transfer from PFC Fund to Airport Construction Fund
67,179
390
3902009
59391
Trans Funds
Airport Department
Trans08 Transfer from DRA Distrib Fund to Airport Construction Fund
9,000
102
10210102
91390
Trans Funds
Airport Department
Trans08 Transfer from DRA Distrib Fund to Airport Construction Fund
9,000
390
3902125
59102
Trans Funds
Airport Department
Trans09 Transfer From CFC Fund to Airport Const. Fund
170,443
350
35010350
91390
Trans Funds
Airport Department
Trans09 Transfer From CFC Fund to Airport Const. Fund
170,443
390
3902213
59252
Trans Funds
Airport Department
Trans10 Transfer from DRA Dist Fund to Airport Construction Fund
216,923
102
10210102
91390
Trans Funds
Airport Department
Trans10 Transfer from DRA Dist Fund to Airport Construction Fund
216,923
390
3902316
59102
Trans Funds
Airport Department
Trans11 Transfer from General Fund to Airport Construction Fund
23,504
100
10010100
91390
Trans Funds
Airport Department
Trans11 Transfer from General Fund to Airport Construction Fund
23,504
390
3902346
59100
Trans Funds
Transit Division
Trans12 Transfer from General Const to Transit Fund
1,230,000
360
3602250
91600
Trans Funds
Transit Division
Trans12 Transfer from General Const to Transit Fund
1,230,000
600
6001614
59360
Trans Funds
Transit Division
Trans13 Transfer from General Const to Transit Fund
120,000
360
3602442
91600
Trans Funds
Transit Division
Trans13 Transfer from General Const to Transit Fund
120,000
600
6001614
59360
Trans Funds
Transit Division
Trans14 Transfer from Sales Tax Const to Transit Fund
20,400
350
35010350
91600
Trans Funds
Transit Division
Trans14 Transfer from Sales Tax Const to Transit Fund
20,400
600
6002045
59350
Trans Funds
Transit Division
Trans15 Transfer from Sales Tax Const to Transit Fund
24,000
350
35010350
91600
Trans Funds
Transit Division
Trans15 Transfer from Sales Tax Const to Transit Fund
24,000
600
6002235
59350
Trans Funds
Engineering
Trans16 Transfer from General Fund to Sanitary Sewer Fund
28,498
710
7101067
59101
Trans Funds
Engineering
Trans16 Transfer from General Fund to Sanitary Sewer Fund
28,498
101
10110101
91710
Trans Funds
Engineering
Trans17 Transfer from Spec. Assessment Fund to Street Construction
296,000
255
25510255
91300
Trans Funds
Engineering
Trans17 Transfer from Spec. Assessment Fund to Street Construction
296,000
300
30010300
59255
Trans Funds
Engineering
Trans17 Transfer from Spec. Assessment Fund to General Const. Fund
233,650
255
25510255
91360
Trans Funds
Engineering
Trans17 Transfer from Spec. Assessment Fund to General Const. Fund
233,650
300
3001972
59255
Trans Funds
Page 15
FISCAL YEAR 2013 AMEN DM ENT #1
CITY COUNCIL
FY 13
FY 13
Expense
Revenue
Department
Program
Description
Amount
Amount Fund
Activity /CIP
Account Explanation
Engineering
Trans17
Transfer from
Spec.
Assessment Fund to General Const. Fund
217,772
255
25510255
91360
Trans
Funds
Engineering
Trans17
Transfer from
Spec.
Assessment Fund to General Const. Fund
217,772 360
3602137
59255
Trans
Funds
Engineering
Trans18
Transfer from
Spec.
Assessment Fund to Street Const
212,000
255
25510255
91300
Trans
Funds
Engineering
Trans18
Transfer from
Spec.
Assessment Fund to Street Const
212,000 300
3002139
59255
Trans
Funds
Engineering
Trans19
Transfer from
Spec.
Assessment Fund to Street Const. Fund
89,000
255
25510255
91300
Trans
Funds
Engineering
Trans19
Transfer from
Spec.
Assessment Fund to Street Const. Fund
89,000 300
3002141
59255
Trans
Funds
Engineering
Trans20
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
110,000
255
25510255
91710
Trans
Funds
Engineering
Trans20
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
110,000 710
7101301
59255
Trans
Funds
Engineering
Trans21
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
124,000
255
25510255
91710
Trans
Funds
Engineering
Trans21
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
124,000 710
7101336
59255
Trans
Funds
Engineering
Trans22
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
180,119
255
25510255
91710
Trans
Funds
Engineering
Trans22
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
180,119 710
7101801
59255
Trans
Funds
Engineering
Trans23
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
307,000
255
25510255
91710
Trans
Funds
Engineering
Trans23
Transfer from
Spec.
Assessment Fd to Sewer Con st Fund
307,000 710
7102130
59255
Trans
Funds
Engineering
Trans24
Transfer From
Sales Tax 20% Fd to Stormwater Const. Fund
13,800
350
35010350
91720
Trans
Funds
Engineering
Trans24
Transfer From
Sales Tax 20% Fd to Stormwater Const. Fund
13,800 720
7201666
59350
Trans
Funds
Engineering
Trans25
Transfer from
General
Fund to America's River Fund
142,856
100
10010100
91700
Trans
Funds
Engineering
Trans25
Transfer from
General
Fund to America's River Fund
142,856 700
7001853
59100
Trans
Funds
Economic Developme
Trans26
Transfer from
Bond
Proceeds Fund to General Const Fund
(991,733)
440
44010440
91360
Trans
Funds
Economic Developme
Trans26
Transfer from
Bond
Proceeds Fund to General Const Fund
(991,733) 360
36010360
59440
Trans
Funds
Economic Developme
Trans27
Transfer from
Bond
Proceeds Fund to General Const Fund
(1,814,863)
440
44010440
91360
Trans
Funds
Economic Developme
Trans27
Transfer from
Bond
Proceeds Fund to General Const Fund
(1,814,863) 360
3602160
59440
Trans
Funds
Economic Developme
Trans28
Transfer from
Bond
Proceeds Fund to General Const Fund
(750,000)
440
44010440
91360
Trans
Funds
Economic Developme
Trans28
Transfer from
Bond
Proceeds Fund to General Const Fund
(750,000) 360
3602438
59440
Trans
Funds
Economic Developme
Trans29
Transfer from
General
Const Fund to Water Const Fund
(650,000)
360
36010360
91740
Trans
Funds
Economic Developme
Trans29
Transfer from
General
Const Fund to Water Const Fund
(650,000) 740
7402395
59360
Trans
Funds
Economic Developme
Trans30
Transfer from
General
Const Fund to Sewer Const Fund
(391,733)
360
36010360
91710
Trans
Funds
Economic Developme
Trans30
Transfer from
General
Const Fund to Sewer Const Fund
(391,733) 710
7102409
59360
Trans
Funds
Fire Department
Trans29
Transfer from
Bond
Proceeds Fund to DRA Gaming
(278,255)
440
44010440
91101
Trans
Funds
Fire Department
Trans29
Transfer from
Bond
Proceeds Fund to DRA Gaming
(278,255) 101
1011016
59440
Trans
Funds
Fire Department
Trans3
Transfer from
Bond
Proceeds Fund to DRA Gaming
(68,800)
440
44010440
91101
Trans
Funds
Fire Department
Trans30
Transfer from
Bond
Proceeds Fund to DRA Gaming
(68,800) 101
1011555
59440
Trans
Funds
Engineering
Trans31
Transfer from
Bond
Proceeds Fund to DRA Gaming
(112,500)
440
44010440
91101
Trans
Funds
Engineering
Trans31
Transfer from
Bond
Proceeds Fund to DRA Gaming
(112,500) 101
1012419
59440
Trans
Funds
Building Services
Trans32
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(575,000)
440
44010440
91350
Trans
Funds
Building Services
Trans32
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(575,000) 350
3501045
59440
Trans
Funds
Recreation
Trans33
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(10,000)
440
44010440
91350
Trans
Funds
Recreation
Trans33
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(10,000) 350
3501090
59440
Trans
Funds
Recreation
Trans34
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(10,000)
440
44010440
91350
Trans
Funds
Recreation
Trans34
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(10,000) 350
3501775
59440
Trans
Funds
Library
Trans35
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(70,000)
440
44010440
91350
Trans
Funds
Library
Trans35
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(70,000) 350
3502308
59440
Trans
Funds
Emergency Communii
Trans36
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(242,628)
440
44010440
91350
Trans
Funds
Emergency Communii
Trans36
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(242,628) 350
3502353
59440
Trans
Funds
Parks Division
Trans37
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(75,000)
440
44010440
91350
Trans
Funds
Parks Division
Trans37
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(75,000) 350
3502369
59440
Trans
Funds
Civic Center
Trans38
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(385,560)
440
44010440
91350
Trans
Funds
Civic Center
Trans38
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(385,560) 350
3502378
59440
Trans
Funds
Civic Center
Trans39
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(171,000)
440
44010440
91350
Trans
Funds
Civic Center
Trans39
Transfer from
Bond
Proceeds Fund to Sales Tax Const
(171,000) 350
3502379
59440
Trans
Funds
Page 16
11- Sep -12
FISCAL YEAR 2013 AMEN DM ENT #1 CITY COUNCIL
11- Sep -12
Department Program Description
Conference Center Trans40 Transfer from Bond Proceeds Fund to Sales Tax Const
Conference Center Trans40 Transfer from Bond Proceeds Fund to Sales Tax Const
Airport Department Trans41 Transfer from Bond Proceeds Fund to Airport Const
Airport Department Trans41 Transfer from Bond Proceeds Fund to Airport Const
Airport Department Trans42 Transfer from Bond Proceeds Fund to Airport Const
Airport Department Trans42 Transfer from Bond Proceeds Fund to Airport Const
Airport Department Trans43 Transfer from Bond Proceeds Fund to Airport Const
Airport Department Trans43 Transfer from Bond Proceeds Fund to Airport Const
Building Services Trans44 Transfer from General Fund to Sales Tax Const Fund
Building Services Trans44 Transfer from General Fund to Sales Tax Const Fund
TOTAL TRANSFERS
ENCUMBRANCE C /O's
Back out Non Budgeted Encumb Rollovers
Total Amend #1 with Enc, C /O's, and New
FY 13 FY 13
Expense Revenue
Amount Amount Fund Activity /CIP Account Explanation
(62,100) 440 44010440 91350 Trans Funds
(62,100) 350 3502388 59440 Trans Funds
(35,000) 440 44010440 91350 Trans Funds
(35,000) 390 3902008 59440 Trans Funds
(613,016) 440 44010440 91350 Trans Funds
(613,016) 390 3902316 59440 Trans Funds
(56,512) 440 44010440 91350 Trans Funds
(56,512) 390 3902403 59440 Trans Funds
95,000 100 1002338 91350 Trans Funds - EECBG
95,000 350 3501045 59100 Trans Funds - EECBG
(3,067,539) (3,067,539)
73,479,838 50,658,841
20,418,998
(129,990)
93,768,846 50,658,841
Page 17