Fiscal Year 2011 Third Budget AmendmentMasterpiece on the Mississippi
March 30, 2011
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2011 Third Budget Amendment
Dubuque
A0- AmmicaCity
2007
Budget Director Jennifer Larson is recommending the third Fiscal Year 2011 Budget
Amendment be set for public hearing for April 18, 2011.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
e l
MCVM /jml
Attachment
cc: Barry Lindahi, City Attorney
Cindy Steinhauser, Assistant City Manager
Jennifer Larson, Budget Director
Mich C. Van Milligen
Masterpiece on the Mississippi
March 30, 2011
TO: Michael C. Van Milligen, City Manager
FROM: Jennifer Larson, Budget Director
SUBJECT: Fiscal Year 2011 Third Budget Amendment
Dubuque
kraal
All - America City
2007
The purpose of this memorandum is to present a summary of the action items approved by
City Council throughout the year subject to a future budget amendment and to set the
public hearing date for the formal budget amendment process as required by Section
384.16 of the Code of Iowa.
This budget amendment includes items, which have been authorized by City Council since
the second amendment to the Fiscal Year 2011 budget was adopted in September 2010
and adjustments to reflect the amended Community Development Annual Plan. This
amendment also reflects reappropriations of completed or canceled projects to fund
increased operating and capital expenses. Interfund transfers of $8,584,237 are also
included.
The amendment totals $26,128,367 in increased appropriation authority and an increase in
resources of $24,856,265. Additional revenues added in this amendment with offsetting
appropriations are:
• Federal Aviation Administration Safety Management Systems Implementation Grant
($208,930) for Airport Operations,
• Federal Aviation Administration Airport GIS Data Collection Grant ($456,000) for
Airport Operations,
• Federal Community Health Center Capital Improvement Program Stimulus Grant
($251,502) for 18 Street Community Education Room,
• Federal Neighborhood Stabilization Program Stimulus Grant ($372,513) to
redevelop abandoned and foreclosed homes as part of a strategy to revitalize
downtown neighborhoods,
• Federal Climate Showcase Communities Grant ($249,068) to help demonstrate to
volunteer residents how vehicle miles traveled, energy consumption and water use
create a personal carbon footprint,
• Federal Energy Efficiency Conservation Block Grant ($484,700) for sustainability
efforts,
• Federal Transit Administration Clean Fuels Grant Program ($1,500,000) for the
replacement of buses,
• Federal Transit Administration State of Good Repair Bus and Bus Facilities Initiative
Grant ($2,300,000) for the replacement of buses and addition of technology,
• Iowa Public Transportation Infrastructure Grant ($298,357) for the Area Residential
Care Transfer Station,
• Federal Transit Capital Investment Grant ($302,120) for the replacement of buses,
• Federal Transit Capital Investment Grant ($250,760) for the replacement of buses,
• Revenue Bond ($301,000) for 44 Main LLC,
• Special Assessments ($1,678,460) for the Millwork Street Reconstruction,
• Developer Line of Credit ($214,316) for the road construction in North Grandview
Estates,
• Federal Aviation Administration Airport Improvement Program ($535,324) for Airport
Runway Safety Area 13/31 Improvements,
• Federal Aviation Administration Airport Improvement Program ($743,772) for Airport
Runway 31 Parallel Construction
• Federal Aviation Administration Airport Improvement Program ($1,662,536) for
Airport Terminal Facility Design, and
• State Revolving Loan Funds ($2,542,037) for Water Pollution Control Plant
Renovation for accelerated construction schedule.
The Fiscal Year 2011 Snow and Ice Control budget was depleted and the following
operating and capital items totaling $48,218 were canceled and will be rebudgeted: Street
Light Demo Project ($20,000) and Railroad Signal Line Project ($28,218). In addition, the
following project savings totaling $451,782 were identified: Police Staff Services Chairs
Savings ($8,698); Fire Administration Miscellaneous Services Savings ($25,110); Animal
Control Truck Replacement Savings ($8,825), Catfish Creek Hike -Bike Trail Study Savings
($10,000), Flora Park Replace Play Equipment ($30,000), Flora Pool Paint Filter Tank
($35,549), Flora Pool Renovate Circulation Pumps Savings ($2,698), Airport FBO
Operations Truck Replacement Savings ($18,671), Sewer Connection Assistance
($40,000), Project Engineering Auto Replacement Savings ($10,372),
Private /Miscellaneous Fiber Optic Conduit ($112,042), Asphalt Milling Program Savings
($46,140), Snow and Ice Control Camera Equipment Savings ($1,609), Replace Motor
Grader Savings ($1,304), Railroad Crossing Improvements Savings ($60,000), Computer
Replacement Savings ($16,818), and Airport Asphalt Parking Lots Savings ($23,946).
There was also $250,000 received over budget from the DRA for the City's annual
distribution payment which will be used to help cover the Snow and Ice Control budget
deficit.
The Federal Transit Administration Clean Fuels and State of Good Repairs Bus and Bus
Facilities Grants require a local match of approximately $700,000. The following operating
and capital items totaling $99,500 were canceled and will be rebudgeted: Dubuque Police
Firearms Range ($27,500), Emergency Communications Burglar /Fire Alarm System
($42,000), and Fire Headquarters Energy Evaluation ($30,000). In addition, the following
project savings totaling $598,221 were identified: Fire Pumper Replacement Savings
($94,674), Sale of Cox Street ($50,125), 18 Street Building Improvements ($111,000),
Housing Purchase /Resale /Rehab ($50,000), Planning Annexation Study /Implementation
($53,000), Fire Station Expansion /Relocation Debt Service Savings ($85,000), Fixed
Route Bus Salvage Sales ($10,500), FY10 Downtown Shuttle Savings ($43,922) and
Gunite Rock Stormsewer ($100,000).
This amendment provides for the purchase of 645 HESCO food control units to be used as
temporary flood control along the City of Dubuque's floodwall system and at other
locations in the City as deemed necessary and the purchase of skid -steer sandbag filler.
The total cost of $299,694 for the flood control units and $6,475 for the skid -steer sandbag
filler will be allocated $289,442 to Stormwater Construction Fund, $7,434 Water
Construction Fund and $9,293 Sanitary Sewer Construction Fund.
The State Rental Rehab Fund cash balance is included in this amendment to be budgeted
for Housing home rehabilitation projects ($549,237).
The action step is for City Council to adopt the attached resolution setting the public
hearing date for the formal budget amendment process as required by State law. The
attached resolution authorizes the City Clerk to publish notification for a public hearing to
be held April 18, 2011.
Attachments
JML
RESOLUTION NO. 115-11
SETTING THE DATE FOR THE PUBLIC HEARING ON AMENDMENT NO. 3
TO THE FISCAL YEAR 2011 BUDGET FOR THE CITY OF DUBUQUE
Whereas, Iowa Code Section 384.16 provides that the City Council shall set a time
and place for a public hearing on amendments to the budget and publish notice before the
hearing as provided in Iowa Code Section 362.3.
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
DUBUQUE, IOWA:
Section 1. That the City Council shall conduct a public hearing on proposed
Amendment No. 3 to the Fiscal Year 2011 budget for the City of Dubuque at the City Council
Chambers at the Historic Federal Building, 350 West 6th Street, Dubuque, Iowa, on Monday,
April 18, 2011, beginning at 6:30 p.m.
Section 2. That the City Clerk be and is hereby authorized and directed to publish
notice of the public hearing, according to law, together with the required budget information.
Passed, approved and adopted this 4th day of April 2011.
Attest:
eanne F. Schneider, City Clerk
B �I
Roy D. , Mayor
Nov -07
NOTICE OF PUBLIC HEARING
Form 653C1 AMENDMENT OF CURRENT CITY BUDGET
The City Council of DUBUQUE in DUBUQUE
will meet at City Council Chambers at the Historic Federal Building
at 6:30 p.m. on 4/18/11
County, Iowa
(hour) (Date)
for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2011
(year)
by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given.
Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity.
Explanation of increases or decreases in revenue estimates, appropriations, or available cash:
This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation
to spend the monies. Adjustments to reflect the amended Community Development Annual Plan budget are included
along with savings from completed or cancelled projects and available cash balance is used to fund increased
operations.
There will be no increase in tax levies to be paid in the current fiscal year named above. Any increase in
expenditures set out above will be met from the increased non - property tax revenues and cash balances not
budgeted or considered in this current budget. This will provide for a balanced budget.
City Clerk/ Finance Officer Name
Total Budget
as certified
or last amended
Current
Amendment
Total Budget
after Current
Amendment
Revenues & Other Financing Sources
19,177,697
19,177,697
Taxes Levied on Property 1
Less: Uncollectted Property Taxes -Levy Year 2
0
Net Current Property Taxes 3
19,177,697
0
19,177,697
Delinquent Property Taxes 4
0
0
TIF Revenues 5
9,080,612
9,080,612
Other City Taxes 6
14,628,325
14,628,325
Licenses & Permits 7
1,187,750
1,187,750
Use of Money and Property 8
17,339,673
110,776
17,450,449
Intergovernmental 9
75,343,184
13,743,896
89,087,080
Charges for Services 10
30,276,561
331
30,276,892
Special Assessments 11
1,086,809
1,678,460
2,765,269
Miscellaneous 12
9,109,157
642,512
9,751,669
Other Financing Sources 13
96,719,903
8,680,290
105,400,193
Total Revenues and Other Sources 14
273,949,671
24,856,265
298,805,936
Expenditures & Other Financing ancin
pe g Uses
23,844,906
58,382
23,903,288
Public Safety 15
Public Works 16
12,366,285
720,957
13,087,242
Health and Social Services 17
962,372
0
962,372
Culture and Recreation 18
9,510,486
188,916
9,699,402
Community and Economic Development 19
12,058,987
190,809
12,249,796
General Government 20
7,185,821
4,321
7,190,142
Debt Service 21
5,807,717
- 85,000
5,722,717
Capital Projects 22
87,495,426
6,994,785
94,490,211
Total Government Activities Expenditures 23
159,232,000
8,073,170
167,305,170
Business Type / Enterprises 24
110,627,348
9,470,960
120,098,308
Total Gov Activities & Business Expenditures 25
269,859,348
17,544,130
287,403,478
Transfers Out 26
29,521,061
8,584,237
38,105,298
Total Expenditures/Transfers Out 27
299,380,409
26,128,367
325,508,776
Excess Revenues & Other Sources Over
( Under) Expenditures /Transfers Out Fiscal Year 28
- 25,430,738
- 1,272,102
- 26,702,840
Continuing Appropriation 29
N/A
0
Beginning Fund Balance July 1 30
49,741,215
49,741,215
Ending Fund Balance June 30 31
24,310,477
- 1,272,102
23,038,375
Nov -07
NOTICE OF PUBLIC HEARING
Form 653C1 AMENDMENT OF CURRENT CITY BUDGET
The City Council of DUBUQUE in DUBUQUE
will meet at City Council Chambers at the Historic Federal Building
at 6:30 p.m. on 4/18/11
County, Iowa
(hour) (Date)
for the purpose of amending the current budget of the city for the fiscal year ending June 30, 2011
(year)
by changing estimates of revenue and expenditure appropriations in the following functions for the reasons given.
Additional detail is available at the city clerk's office showing revenues and expenditures by fund type and by activity.
Explanation of increases or decreases in revenue estimates, appropriations, or available cash:
This amendment adds additional revenue from grants received, private funding, bond proceeds, and the appropriation
to spend the monies. Adjustments to reflect the amended Community Development Annual Plan budget are included
along with savings from completed or cancelled projects and available cash balance is used to fund increased
operations.
There will be no increase in tax levies to be paid in the current fiscal year named above. Any increase in
expenditures set out above will be met from the increased non - property tax revenues and cash balances not
budgeted or considered in this current budget. This will provide for a balanced budget.
City Clerk/ Finance Officer Name
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department Program Description
GENERAL FUND
5 11 Police Departme IC
6 11 Police Departme 1
9 11 Police Departme 1
10 11 Police Departme 1
11 11 Police Departme 1
12 11 Police Departme 1
13 I 1 Police Departme 1
14 11 Police Departme I
15 11 Police Departme 1
16 11 Police Departme 1
17 11 Police Departme 1
18 11 Police Departme 1
19 11 Police Departme 1
20 11 Police Departme 1
21 11 Police Departme 1
22 11 Police Departme 1
23 11 Police Departme: 1
24 11 Police Departme 1
25 11 Police Departme 1
26 11 Police Departme 1
27 11 Police Departme 1
28 11 Police Departme 1 C
29 11 Police Departme IC
30 11 Police Departme IC
31 11 Police Departme IC
32 11 Police Departme IC
33 11 Police Departme: IC
34 11 Police Departme 1C
35 12 Emergency Corn IC
36 13 Fire Department 1
39 13 Fire Department 1C
40 13 Fire Department 1C
41 13 Fire Department I C
42 13 Fire Department 1C
43 13 Fire Department 1C
44 13 Fire Department 1C
45 13 Fire Department 1C
46 13 Fire Department 1
49 17 Health Services 1
50 30 Parks Division 4C
51 30 Parks Division 4C
52 30 Parks Division 4C
53 30 Parks Division 4C
54 30 Parks Division 2C
55 30 Parks Division 2C
Tactical Deploy Vehicle - Vehicle Replacement
Police Patrol - Video Equipment
Helping Services of IA Grant - Underage Alcohol - Reimb OT
Helping Services of IA Grant - Underage Alcohol - Grant
Records and ID - Part-time Employee
Records and ID - Social Security
Records and ID - IPERS
Iowa Pledge Program - Alcohol/Tobacco Compliance Grant
Iowa Pledge Program - Alcohol/Tobacco Compliance - OT
Occupant Protection Grant
Occupant Protection Grant - Overtime
Bulletproof Vest Grant - 2010 - Body Armor
Bulletproof Vest Grant - 2010
Target Crime Prevention Grant
Target Crime Prevention Grant
FY 2010 JAG Grant
FY 2010 JAG Grant
Stop Violence Against Women Grant
Stop Violence Against Women Grant
Staff Services - Desks /Chairs
Police Patrol - Iowa District Court Fines
Police Admin Office Remodel - County Share
Police Admin Office Remodel - Construction
Police Admin Office Remodel - Construction
Restore Police Car - Private Contributions
Restore Police Car - Motor Vehicle Outsourcing
Dbq Police Firearms Range - R.O.W.
Dbq Police Firearms Range - Construction
Burglar/Fire Alarm System
Fire Administration - Miscellaneous Services
Pumper Replacement
Pumper Replacement - Investment Earnings
Pumper Replacement
Fire Headquarters Energy Evaluation
Fire Gear Cleaning Equipment - Federal Grant
Fire Gear Cleaning Equipment - Misc Equipment
Fire Gear Cleaning Equipment - Misc Equipment
Fire Administration - Miscellaneous Services
Animal Control - Truck Replacement
Catfish Creek Hike -Bike Trail Study - Consultant Services
Flora Park Replace Play Equipment - Construction
Comiskey Park Lighting - Lighting Equipment
McAleece& Rec Parking Lots - Consulting Engineers
Trolley Line Trail - REAP Grant
Trolley Line Trail - State Grant
FY 11
Expense
Amount
Page 1
FY 11
Revenue
Amount
Fund Activity/CIP Account Explanation
4,000 102 1022185 71312
1,000 100 10011700 72416
(1,536) 100 10011324 61051
(1,536) 100 10011324 45771
(21,477) 100 10011700 61020
(1,643) 100 10011700 61320
(1,493) 100 10011700 61310
5,503 100 10011764 61050
5,503 100 10011764 45701
40,975 100 10011772 44125
40,975 100 10011772 61050
4,425 100 10011703 72213
4,425 100 10011703 44125
1,750 100 10011760 61051
1,750 100 10011760 53102
85,521 100 10011776 61051
85,521 100 10011776 45771
307 100 10011754 61050
307 100 10011754 44135
(8,698) 100 10011190 71211
43,000 100 10011700 53403
15,881 101 1011863 46205
15,881 101 1011863 73210
(3,812) 101 1011863 73210
8,706 100 1002280 53102
8,706 100 1002280 62528
(7,500) 101 1011589 73113
(20,000) 101 1011589 73211
(42,000) 100 1001729 73411
(25,110) 100 10013100 62731
1,875 100 1001016 71318
1,875 100 1001016 43110
(94,674) 100 1001016 71318
(30,000) 101 1012188 62716
4,372 101 1012187 44170
4,372 101 1012187 71550
12,317 101 1012187 71550
(12,317) 100 10013100 62731
(8,825) 100 10017200 71312
(10,000) 101 1012078 62716
(30,000) 102 1021451 73211
13,100 102 1022284 71517
(13,100) 102 1022191 62712
(17,940) 100 1001989 45707
20,000 100 1001989 45701
30- Mar -11
New Grant Appropriation
New Grant Appropriation
Adjust grant to actual
Adjust grant to actual
Position moved to Records
Position moved to Records
Position moved to Records
New Grant Appropriation
New Grant
New Grant
New Grant Appropriation
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
Shift to Snow and Ice Control
Increase to actual
County Contribution
County Contribution
Shift to Five Flags Entryway Renovatioi
Private Contribution
Appropriation
Shift to Transit Bus Match
Shift to Transit Bus Match
Shift to Transit Bus Match
Shift to Snow and Ice Control
Increase for Investment Earnings
Investment Earnings
Shift to Transit Bus Match
Shift to Transit Bus Match
Increase to actual
Increase to actual
Shift from Misc Services
Shift to Fire Gear Cleaning Equipment
Shift to Snow and Ice Control
Shift to Snow and Ice Control
Shift to Snow and Ice Control
Shift from McAleece &Rec Parking Lots
Shift to Comiskey Park Lighting
Shift to State Grant
Shift from REAP Grant
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department Program
58 32 Civic Center Div 4C
62 34 Recreation Divis 4C
63 34 Recreation Divis 4C
65 34 Recreation Divis 4
66 34 Recreation Divis 4
67 34 Recreation Divis 4
68 34 Recreation Divis 4
69 34 Recreation Divis 4
70 34 Recreation Divis 4
70 36 Library 4
70 36 Library 4
127 51 Airport Departm 2
130 51 Airport Departm4 2C
131 51 Airport Departm, 2C
132 51 Airport Departm 2C
133 51 Airport Departm. 2C
217 55 Engineering 2C
218 55 Engineering 2C
219 55 Engineering 2
250 55 Engineering 4C
251 55 Engineering 4C
252 55 Engineering 4C
262 55 Engineering 2C
263 55 Engineering 2C
271 55 Engineering 2C
272 55 Engineering 2C
273 55 Engineering 2C
290 57 Building Service 6C
291 57 Building Service 6C
292 57 Building Service 6C
293 57 Building Service 6C
294 57 Building Service 6C
295 60 Economic Devlo 5
312 61 Housing & Comi 5C
313 61 Housing & Comp 5C
314 61 Housing & Com, 5C
315 61 Housing & Com] 5C
316 61 Housing & Comi 5C
317 61 Housing & Comi 5C
328 61 Housing & Comi 5C
329 61 Housing & Comi 5C
330 61 Housing & Comi 5C
331 61 Housing & Comi 5
332 61 Housing & Comi 5
333 61 Housing & Com] 5
334 61 Housing & Com] 5
335 61 Housing & Comi 5
FY 11
Expense
Description Amount
Five Flags Entryway Renovation - Miscellaneous Equipment 23,000
Flora Pool Paint Filter Tank - Construction Not Building (35,549)
(2,698)
Renovate Circulation Pumps
AmeriCorps 10/11
AmeriCorps 10 /11
AmeriCorps 10 /11 117,012
AmeriCorps Non -Grant - Consultant Services 1,980
AmeriCorps Supplemental
AmeriCorps Supplemental 74,567
Children Services - Books 1,313
Adult Services - Books 2,120
FBO Operations - Truck Replacement (18,671)
Safety Mgmt Systems Grant - Consultant Services 208,930
Safety Mgmt Systems Grant - Safety Mgmt Systems
Airport GIS - Consultant Services 456,000
Airport GIS - FAA Funds
Loras /Cox Street - Construction Not Building (50,125)
Sewer Conn Asst - Low/Mod - Miscellaneous Services (40,000)
Project Engineering - Auto Replacement (10,372)
Library Renovation - General Reimbursements
Library Renovation - Construction 89,167
Library Renovation - Construction (59,274)
Fiber Optic Conduit - Private/Miscellaneous - Construction (112,042)
Fiber Optic Conduit - Private /Miscellaneous - Construction (40,000)
Hempstead Safety Improvements - Const Contract Not Bldg (162,920)
Hempstead Safety Improvements - State Traffic Grant
Hempstead Safety Improvements - Private Participation
18th Street Building Improvement - Construction (111,000)
18th Street Building Improvement - Construction 10,800
18th Street Building Improvement - Office of Energy Independence
18th Street Building Improvement - Construction 251,502
18th Street Building Improvement - Health Center Grant
Economic Development - Pay to Other Agency 40,000
Maint of Vacant/Abandoned - Property Maintenance 42,663
Maint of Vacant/Abandoned - Reimbursements General
Housing Trust - IA Finance - Grants (157,250)
Purchase/Resale/Rehab - Construction (50,000)
Purchase/Resale/Rehab - Construction 372,513
Purchase/Resale/Rehab - Neighborhood Stabilization Grant
Homeownership Grants - Target 111,961
Homeownership Grants - Target
Homeownership Grants - Target
AmeriCorps Grant
AmeriCorps Grant
AmeriCorps Grant - Part-time Employees
AmeriCorps Grant - Seasonal Employees
AmeriCorps Grant - IPERS
(38,333)
(132,460)
(2,664)
Page 2
FY 11
Revenue
Amount Fund Activity/CIP Account Explanation
101 1012283 71550
101 1011999 73211
101 1011850 73211
114,001 100 10034910 45771
3,011 100 10034910 53102
100 10034910 61030
100 10034911 62716
74,577 100 10034916 45771
100 10034916 61030
100 10036400 62651
100 10036200 62659
100 10051200 71314
100 1001969 73211
208,930 100 1001969 44105
100 1002282 62712
456,000 100 1002282 44105
100 1002076 73211
100 1001067 62731
100 10055400 71310
13,093 100 1001141 53620
100 1001141 73210
100 1001141 73210
102 1021609 73211
102 1021609 73211
101 1012077 73211
(170,699) 101 1012077 45701
7,779 101 1012077 53102
102 1021975 73210
102 1021975 73210
10,800 102 1021975 44176
102 1021975 73210
251,502 102 1021975 44175
100 10060700 62761
100 1001002 73210
42,663 100 1001002 53620
100 1001021 62765
102 1021231 73111
102 1021231 73210
372,513 102 1021231 44170
101 1011595 62765
31,638 101 1011595 43405
80,323 101 1011595 53620
(38,701) 100 10061910 53102
(154,805) 100 10061910 45771
100 10061910 61020
100 10061910 61030
100 10061910 61310
30 -Mar-11
Shift from 3501998;1011863;1012278
Shift to Snow and Ice Control
Shift to Snow and Ice Control
Shift from Housing
Shift from Housing
Shift from Housing
Amend due to retirements
New Grant
New Grant
Lost Book Fees
Lost Book Fees
Shift to Snow and Ice Control
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
Shift to Transit Bus Match
Shift to Snow & Ice Control
Shift to Snow & Ice Control
Utility Rebates
Gen Reimb; FY10 Pledges
Correct FY10 Carryover Amount
Shift to Snow & Ice Control
Shift to US 52 /Central Traffic Improv
Adjust to actual
Adjust to actual
Adjust DCSD to actual
Shift to Transit Bus Match
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
Hotel Julien Marketing
Reimbursements General
Reimbursements General
Adjust Budget to Actual
Shift to Transit Bus Match
New Grant Appropriation
New Grant
Loan Repayments
Loan Repayments
Loan Repayments
Shift to Recreation
Shift to Recreation
Shift to Recreation
Shift to Recreation
Shift to Recreation
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department Program Description
336 61 Housing & Comi 5 AmeriCorps Grant - Social Security
337 61 Housing & Comi 5 AmeriCorps Grant - Office Supplies
338 61 Housing & Comi 5 AmeriCorps Grant - Uniforms
339 61 Housing & Comi 5 AmeriCorps Grant - Miscellaneous
340 61 Housing & Comi 5 AmeriCorps Grant - Mileage
341 61 Housing & Comi 5 AmeriCorps Grant - Education & Training
342 61 Housing & Comi 5 AmeriCorps Grant - Misc Operating Supplies
343 61 Housing & Comi 5 AmeriCorps Non Grant
344 61 Housing & Comi 5 AmeriCorps Stimulus Grant
345 61 Housing & Comi 5 AmeriCorps Stimulus Grant
346 61 Housing & Comi 5 AmeriCorps Stimulus Grant - Seasonal Employees
347 61 Housing & Com] 5 AmeriCorps 3
348 61 Housing & Com] 5 AmeriCorps 3
349 61 Housing & Comi 5 AmeriCorps 3 - Seasonal Employees
350 61 Housing & Comi 5 AmeriCorps Supplemental
360 62 Planning Service 5C Annexation Study/Implementation - Consultant Services
361 62 Planning Service 5C Annexation Study/Implementation -Legal Services
362 72 City Manager 6 Consultant Services - RECAT Grant Consultant
363 72 City Manager 6C Ragbrai Reimbursements
364 72 City Manager 6C Climate Showcase Grant - Federal Grant
365 72 City Manager 6C Climate Showcase Grant - Full -Time Employee
366 72 City Manager 6C Climate Showcase Grant - Social Security
367 72 City Manager 6C Climate Showcase Grant - IPERS
368 72 City Manager 6C Climate Showcase Grant - Health Insurance
369 72 City Manager 6C Climate Showcase Grant - Life Insurance
370 72 City Manager 6C Climate Showcase Grant - Conferences Travel
371 72 City Manager 6C Climate Showcase Grant - Office Supplies
372 72 City Manager 6C Climate Showcase Grant - Consultant Services
374 72 City Manager 6C EECBG Grant
375 72 City Manager 6C EECBG Grant - Grants
TOTAL GENERAL FUND
TRANSIT FUND
134 53 Transit Division
135 53 Transit Division
136 53 Transit Division
137 53 Transit Division
158 53 Transit Division
159 53 Transit Division
160 53 Transit Division
161 53 Transit Division
162 53 Transit Division
163 53 Transit Division
164 53 Transit Division
165 53 Transit Division
166 53 Transit Division
167 53 Transit Division
8C Minibus Purchase
8C Minibus Purchase - State Transit Funds
8C Replace Fixed Route Buses
8C Replace Fixed Route Buses - Salvage Sales
8C Replace Fixed Route Buses
8C Replace Fixed Route Buses - Federal Clean Fuels Grant
8C Replace Fixed Route Buses
8C Replace Fixed Route Buses - Federal State of Good Repairs Grant
8C Bus Stop Improvements - ARC Transfer Station
8C Bus Stop Improvements - Public Transportation Infrast. Grant
8C Replace Fixed Route Buses
8C Replace Fixed Route Buses - Capital Investment Assist Project
8C Replace Fixed Route Buses
8C Replace Fixed Route Buses - Capital Investment Assist Project
FY 11
Expense
Amount
(13,065)
(126)
5
(2,380)
(719)
(604)
(447)
7,440
39,942
10
(3,000)
(50,000)
4,321
(12,448)
40,000
2,234
2,030
6,472
58
2,568
1,500
194,206
484,700
1,350,414 2,369,903
91,964
692,721
1,500,000
2,300,000
298,357
302,120
250,760
Page 3
FY 11
Revenue
Amount Fund Activity/CIP Account
100 10061910 61320
100 10061910 61320
100 10061910 62011
100 10061910 62240
100 10061910 62340
100 10061910 62340
100 10061910 62340
(1,147) 100 10061911 53620
43,474 100 10061914 44176
1,850 100 10061914 53102
100 10061914 61030
40,804 100 10061917 45771
35,690 100 10061917 53102
100 10061917 61030
100 10061916 62011
102 1021012 62716
102 1021012 62713
100 10072100 62716
101 1012278 62761
249,068 100 1002334 44170
100 1002334 61010
100 1002334 61320
100 1002334 61310
100 1002334 61410
100 1002334 61415
100 1002334 62310
100 1002334 62010
100 1002334 62716
484,700 100 1002338 44175
100 1002338 62765
62,250
10,500
1,500,000
2,300,000
298,357
302,120
250,760
600 6001222 62716
600 6001222 45723
600 6001614 73411
600 6001224 54109
600 6001614 73411
600 6001614 44150
600 6001614 73411
600 6001614 44150
600 6002235 73210
600 6002235 45701
600 6001614 73210
600 6001614 45701
600 6001614 73210
600 6001614 45701
New Grant Appropriation
New Grant
Shift from various CIPs
Salvage Sales
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant
30 -Mar-11
Explanation
Shift to Recreation
Shift to Recreation
Shift to Recreation
Shift to Recreation
Shift to Recreation
Shift to Recreation
Shift to Recreation
Shift to Recreation
New Grant
Private Participation
New Grant
New Grant
New Grant
New Grant
New Grant
Shift to Transit Bus Match
Shift to Transit Bus Match
RECAT grant Consultant
Shift to Five Flags Entryway Renovatioi
New Grant
New Grant Appropriation
New Grant Appropriation
New Grant Appropriation
New Grant Appropriation
New Grant Appropriation
New Grant Appropriation
New Grant Appropriation
New Grant Appropriation
New Grant
New Grant Appropriation
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department Program Description
168 53 Transit Division 8C Replace Fixed Route Buses
169 53 Transit Division 8C Replace Fixed Route Buses - Insurance Claim
170 53 Transit Division 8C Intermodel Feasibility Study - Consultant Services
TOTAL TRANSIT FUND
GREATER DOWNTOWN TIF - TIF FUND
296 60 Economic Devlo 5 Greater Downtown TIF - Loans
296 60 Economic Devlo 5 Greater Downtown TIF - Revenue Bond
296 60 Economic Devlo 5 Greater Downtown TIF - TIF Receipts
TOTAL GREATER DOWNTOWN TIF - TIF FUND
DUBUQUE BREWING AND MALTING TIF - TIF FUND
297 60 Economic Devlo 5 Dubuque Brewing & Malting TIF - TIF Receipts
TOTAL DUBUQUE BREWING AND MALTING TIF - T
ROAD USE TAX FUND
172 54 Public Works 2
175 54 Public Works 2C
176 54 Public Works 2C
177 54 Public Works 2C
178 54 Public Works 2C
179 54 Public Works 2C
220 55 Engineering 2C
221 55 Engineering 2C
222 55 Engineering 2C
245 55 Engineering 2C
261 55 Engineering 2C
285 55 Engineering 2C
286 55 Engineering 2C
376 77 Information Sery 6C
Snow and Ice Control - Equipment Maintenance
Asphalt Milling Program - Construction Not Building
Snow and Ice Control - Camera Equipment
Replace Motor grader - Equipment
Street Light Demo Project - Construction Not Building
Asphalt Milling Program - General Reimbursements
Railroad Cross Improvement - Construction
Railroad Cross Improvement - Construction
Railroad Cross Improvement - General Reimbursements
Railroad Signal Line - Construction
Traffic Signal Video Detection - Construction
Fiber Optic Conduit Project - Construction
Fiber Optic Conduit Project - Investment Earnings
Internet, Micros & Printer - Road Use Tax Fund
TOTAL ROAD USE TAX FUND
SPECIAL ASSESSMENT FUND
265 55 Engineering 2C Special Assessments - Principal Payments
266 55 Engineering 2C Special Assessments- Interest Payments
TOTAL SPECIAL ASSESSMENT FUND
FY 11 FY 11
Expense Revenue
Amount Amount
12,550
12,550
16,782
5,465,254 4,736,537
Page 4
Fund Activity/CIP
600 6001614
600 6001614
600 6001614
301,000 240 24060240 62764 40 Main Loan
301,000 240 24060240 54215 40 Main Loan
(13,555) 240 24060240 41205 Shift DBQ Brewing & Malting
301,000 287,445
13,555 243 24360243 41205 Shift from Greater Downtown TIF
13,555
750,000 250 25054420 62611
(46,140) 250 2501230 73211
(1,609) 250 2502183 71118
(1,304) 250 2502219 71318
(20,000) 250 2502224 73211
18,750 250 2501230 53620
(60,000) 250 2502026 73211
3,357 250 2502026 73211
3,357 250 2502026 53620
(45,000) 250 2502143 73211
(27,072) 250 2501816 73211
337 250 2501017 73211
Account Explanation
73210 New Grant Appropriation
53610 New Grant
62716 Shift from RR Line
Shift from Various CIPs
Shift to Snow and Ice Control
Shift to Snow and Ice Control
Shift to Snow and Ice Control
Shift to Snow and Ice Control
Sale of Millings
Shift to Snow & Ice Control
Increase to actual
Increase to actual
Shift to Intermodal /Snow & Ice Control
Shift to US 52 /Central Traffic Improv
Increase to actual
337 250 2501017 43110 Investment Earnings
(16,818) 250 2501069 71124 Shift to Snow and Ice Control
535,751 22,444
1,510,614
167,846
1,678,460
255 25510255 52101 Special Assessment Revenue
255 25510255 52102 Special Assessment Revenue
30- Mar -11
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department Program Description
COMMUNITY DEVELOPMENT BLOCK GRANT FUND
64 34 Recreation Divis 4 CD Target Area Prog - Pay to Other Agency
274 55 Engineering 5C Neighborhood Infrastructure Improvements - Construction
318 61 Housing & Comi 5C First Time Homebuyer Program -Loans
319 61 Housing & Comi 5C Historic Preservation Rehab Grant -Loans
320 61 Housing & Comi 5C Homeownership Rehab Program -Loans
321 61 Housing & Comi 5C Housing Code Enforcement - Computer
322 61 Housing & Comi 5C Lead Paint Abatement Program - Loans
323 61 Housing & Comi 5C Purchase/Resale/Rehab - Construction
351 60 Economic Devel 5C Commercial /Industrial Rehab Loan - CDBG
352 62 Planning Service 5 City Planning - Postage and Shipping
353 62 Planning Service 5 City Planning - Office Supplies
354 62 Planning Service 5 City Planning - Subscriptions
355 62 Planning Service 5 City Planning - Conferences Travel
356 62 Planning Service 5 City Planning - Misc Operating Supplies
357 62 Planning Service 5 City Planning - Legal Notices & Ads
358 62 Planning Service 5 City Planning - Dues and Memberships
359 62 Planning Service 5 City Planning - City Business Travel
373 72 City Manager 5C Neighborhood Grants
TOTAL CDBG FUND
STATE RENTAL REHAB FUND
325 61 Housing & Comi 5C State Rental Rehab - Loan Interest
326 61 Housing & Comi 5C State Rental Rehab - RRP Loan Repayments
327 61 Housing & Comi 5C State Rental Rehab - Home Loan Repayments
324 61 Housing & Comi 5C State Rental Rehab - Construction
TOTAL STATE RENTAL REHAB FUND
STREET CONSTRUCTION FUND
256 55 Engineering 2C Street Light/Signal Knockdown - Insurance Reimbursement
257 55 Engineering 2C Street Light/Signal Knockdown - Construction Not Building
258 55 Engineering 2C US 52 /Central Traffic Improvements - Construction
260 55 Engineering 2C Street Light Replacement - Construction
267 55 Engineering 2C North Grandview Estates Road - Construction
268 55 Engineering 2C North Grandview Estates Road - General Reimbursements
269 55 Engineering 2C Sub - Divisions Subdrains - Construction Not Building
270 55 Engineering 2C US 61/151 Corridor - Consulting Engineers
275 55 Engineering 2C Street Const General - Construction Not Building
276 55 Engineering 2C Street Const General - General Reimbursement
281 55 Engineering 2C Bridge Repairs/Maintenance - IDOT Funding
282 55 Engineering 2C Bridge Repairs/Maintenance - Construction
283 55 Engineering 2C Southwest Arterial -Farm Land Rent
284 55 Engineering 2C Southwest Arterial- Consulting Eng
287 55 Engineering 2C Street Light Replacement - Construction
288 55 Engineering
289 55 Engineering
2C Street Light Replacement - Investment Earnings
2C Fiber Optic Conduit - Misc - Construction
TOTAL STREET CONSTRUCTION FUND
FY 11
Expense
Amount
Page 5
FY 11
Revenue
Amount
Fund Activity/CIP Account Explanation
(8,076) 260 26034500 62761
10,000 260 2601239 73211
(88,213) 260 2601234 62764
(10,000) 260 2601237 62764
100,000 260 2601065 73210
(1,800) 260 26061700 71124
30,000 260 2601232 62764
(15,915) 260 2601231 73210
(10,000) 260 2601235 62764
(2,138) 260 26062700 62030
(1,070) 260 26062700 62010
(262) 260 26062700 62170
(630) 260 26062700 62310
(815) 260 26062700 62671
(878) 260 26062700 62130
(666) 260 26062700 62190
(331) 260 26062700 62320
(8,693) 260 2601238 62765
(9,487)
977 270 27061320 43105
46 270 27061300 43425
8,087 270 27061300 43430
549,237 270 2701065 73210
549,237 9,110
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
CDBG Amend #2
Loan Interest
RRP Loan Repayments
Home Loan Repayments
Amend in Cash Balance
27,656 300 3002252 53610
27,656 300 3002252 73211
117,072 300 3002274 73211
(25,000) 300 3001549 73211
214,316 300 3002336 73211
214,316 300 3002336 53620
(115,403) 300 3002023 62712
115,403 300 3002028 62712
20,670 300 3002142 73211
20,670 300 3002142 53620
243 300 3001258 45725
243 300 3001258 73211
14,703 300 3001287 43242
14,703 300 3001287 62712
113 300 3001549 73211 Increase to actual
Insurance Proceeds
Insurance Proceeds
Shift from various Traffic CIPs
Shift to US 52 /Central Traffic Improv
Road Construction
Gen Reimb - Developer LOC
Correct FY10 Carryover Amount
Correct FY10 Carryover Amount
General Reimbursement
General Reimbursement
State Share of 3rd St Overpass
State Share of 3rd St Overpass
Farm Land Rent
Farm Land Rent
113 300 3001549 43110 Investment Earnings
43,000 300 3002144 73211 Central Ave Fiber Install
412,773 277,701
30- Mar -11
SALES TAX FUND (20 %)
59 32 Civic Center Div 4C Five Flags Chair Replacement
259 55 Engineering 2C Downtown Street Light Replacement - Construction
TOTAL SALES TAX FUND
264 55
298 60
299 60
300 60
301 60
302 60
303 60
308 60
309 60
1 0
2 0
4 0
3 0
4 0
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department Program Description
GENERAL CONSTRUCTION FUND
Engineering 2C
Economic Devlo 5C
Economic Devlo 5C
Economic Devlo 5C
Economic Devlo 5C
Economic Devlo 5C
Economic Devlo 5C
Economic Devlo 5C
Economic Devlo 5C
AIRPORT CONSTRUCTION FUND
103 51 Airport Departm 2C Runway Safety Area - Construction
104 51 Airport Departm 2C Runway Safety Area -FAA Funds
105 51 Airport Departm 2C Terminal - RW 31 Parallel - Construction
106 51 Airport Departm. 2C Terminal - RW 31 Parallel -FAA Funds
107 51 Airport Departm. 2C FBO Hanger Heating System - Construction
108 51 Airport Departm. 2C FBO Hanger Heating System - Investment Income
109 51 Airport Departm, 2C Iowa Hanger Heater Replacement - Construction
110 51 Airport Departm. 2C Iowa Hanger Heater Replacement - Investment Income
111 51 Airport Departm. 2C Paint Hangar Exteriors - Construction
112 51 Airport Departm. 2C Paint Hangar Exteriors - Investment Earnings
113 51 Airport Departm 2C Terminal Boiler Replacement - Construction
114 51 Airport Departm 2C Terminal Boiler Replacement - Investment Earnings
115 51 Airport Departm 2C Airport Runway Painting - Construction
116 51 Airport Departm. 2C Airport Runway Painting - Investment Earnings
117 51 Airport Departm, 2C Terminal Facility Design - Consultant Services
118 51 Airport Departm. 2C Terminal Facility Design - FAA Funds
119 51 Airport Departm 2C Terminal Facility Design - State Funds
126 51 Airport Departm 2C Asphalt Parking Lots - Construction Not Building
TOTAL AIRPORT CONSTRUCTION FUND
DEBT SERVICE FUND
Debt Service 7
Debt Service
Debt Service
Debt Service
Debt Service
7
7
7
7
Millworking District Street - Construction
Industrial Site Development - North Siegert - Construction
Downtown Housing Incentive- Pay to Other Agency
Downtown Housing Incentive- Investment Earnings
Downtown Housing Incentive- Loan Interest
Millwork District Parking Imp - Consulting Engineers
Millwork District Parking Imp - Investment Earnings
40 Main Landscaping - Construction
40 Main Landscaping - Investment Earnings
TOTAL GENERAL CONSTRUCTION FUND
Fire Station Expansion Relocation Principle
Fire Station Expansion Relocation Interest
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
TOTAL DEBT SERVICE FUND
FY 11
Expense
Amount
(6,740)
(25,000)
(31,740)
1,678,460
(51,762)
131,471
98,832
292
1,857,293
535,324
743,772
84
1,931,526
(23,946)
3,186,799
(52,815)
(32,185)
(85,000)
Page 6
FY 11
Revenue
Amount Fund Activity/CIP Account Explanation
360
360
360
7,875 360
1,507 360
360
8,601 360
360
24 360
18,007
390
535,324 390
390
743,772 390
390
84 390
5 390
5 390
23 390
23 390
6 390
6 390
5 390
5 390
390
1,662,536 390
(14,839) 390
390
2,926,916
646,177
4,487,863
122,089
5,256,129
30 -Mar-11
350 3501998 71212 Shift to Five Flags Entryway Renovatioi
350 3501608 73211 Shift to US 52 /Central Traffic Improv
400
400
440
440
440
3602137
3601943
3602267
3602267
3602267
3602250
3602250
3602251
3602251
3901788
3901788
3901891
3901891
3902123
3902123
3902124
3902124
3902125
3902125
3902126
3902126
3902128
3902128
3902213
3902213
3902213
3902007
40013800
40013800
44010440
44010440
44010440
73211
73211
62761
43110
43105
62712
43110
62712
43110
73210
44105
73211
44105
73210
43110
73210
43110
73210
43110
73210
43110
73210
43110
62712
44105
45701
73211
74111
74112
54215
54210
54210
Special Assessments
Adjust Budget to Actual
Increased Bond Proceeds
Earnings on Bond Proceeds
Loan Interest
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
New Grant Appropriation
New Grant
New Grant Appropriation
New API Grant
Increase to actual
Increase to actual
Increase to actual
Increase to actual
Increase to actual
Increase to actual
Increase to actual
Increase to actual
Increase to actual
Increase to actual
New Grant Appropriation
New Grant
Removal of Grant
Shift to Snow and Ice Control
Shift to Transit Bus Match
Shift to Transit Bus Match
Adjust to actual
Shift from Storm Fund
Adjust to actual
95 43
96 43
97 43
98 43
206 54
253 55
277 55
278 55
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department
Water Pollution
Water Pollution
Water Pollution
Water Pollution
Public Works
Engineering
Engineering
Engineering
STORM WATER CONST
Division
Parks Division
Public Works
Public Works
Public Works
Public Works
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Program Description
SANITARY SEWER CONSTRUCTION FUND
8C WPC Plant Facility Study - Construction
8C WPC Plant Facility Study - SRF Bond Proceeds
8C WPC Plant Facility Study - Construction
8C WPC Plant Facility Study - Insurance Claims
8C Purchase of HESCO Flood Barriers
8C Rockdale Road Sanitary Sewer - Construction
8C Sanitary Utility Relocate - 10th and Central Ramp - Const
8C Sanitary Utility Relocate - 10th and Central Ramp - Reimb
TOTAL SANITARY SEWER CONST FUND
TRUCTION FUND
56 30 8C Bee Branch - Trees Forever
57 30 8C Bee Branch - Trees Forever
173 54 8C Sewer Pipeline Inspection Equipment - Equipment
174 54 8C Sewer Pipeline Inspection Equipment - Investment Earnings
204 54 8C Purchase of HESCO Flood Barriers
207 54 8C Purchase of Sandbagging Attachment for endloader
216 55 8C Gunite Rock Stormsewer - Construction
223 55 8C Bee Branch Alignment - State Revolving Loan Funds
224 55 8C Bee Branch Alignment - I -Jobs II Grant
225 55 8C Bee Branch Alignment - Private Participation
226 55 8C Bee Branch Alignment - Construction
227 55 8C Bee Branch Alignment - Investment Earnings
228 55 8C Bee Branch Alignment - Construction
229 55 8C Bee Branch Alignment - Salvage Sales
230 55 8C Bee Branch Alignment - Construction
231 55 8C Bee Branch Alignment - Construction
232 55 8C Bee Branch Alignment - GO Bond Proceeds
233 55 8C Bee Branch Alignment - Construction
234 55 8C Lower Bee Branch Bridges - Construction
235 55 8C Lower Bee Branch Bridges - Construction
236 55 8C Lower Bee Branch Bridges - Investment Earnings
239 55 8C Iowa Street Storm Sewer - Engineering
240 55 8C Iowa Street Storm Sewer - Investment Earnings
241 55 8C Kane Storm Sewer - Engineering
242 55 8C Kane Storm Sewer - Investment Earnings
243 55 8C Peru Storm Sewer - Engineering
244 55 8C Peru Storm Sewer - Investment Earnings
279 55 8C Custer /Allison Henderson - Construction
280 55 8C Custer /Allison Henderson - Connection Charges
TOTAL STORM WATER CONST FUND
PARKING CONSTRUCTION FUND
99 46 Parking Division 8C Port of Dubuque Ramp Maint - Construction Not Building
100 46 Parking Division 8C Port of Dubuque Ramp Maint - Private Participant
FY 11
Expense
Amount
FY 11
Revenue
Amount
2,542,037
2,542,037
50,000
50,000
9,293
(167,447)
1,440
1,440
2,435,323 2,593,477
6,130
6,130
24
24
282,967
6,475
(100,000)
(3,965,000)
3,965,000
59,000
59,000
2,664
2,664
3,813
3,813
200,000
(4,258,426)
(2,850,000)
2,850,000
969
969
144
144
626
626
50
50
331
331
Page 7
463,193 (4,184,675)
Fund Activity/CIP Account Explanation
710 7101837 73211
710 7101837 54230
710 7101837 73211
710 7101837 53610
710 7102335 71550
710 7101307 73510
710 7102261 73211
710 7102261 53620
720 7202337 53102
720 7202337 73311
720 7201840 73410
720 7201840 43110
720 7202335 71550
720 7202335 71550
720 7201363 73211
720 7201654 54230
720 7201654 45703
720 7201654 54210
720 7201654 73211
720 7201654 43110
720 7201654 73211
720 7201654 54109
720 7201654 73211
720 7201654 73211
720 7201654 54210
720 7201654 73211
720 7202281 73211
720 7202281 73211
720 7202281 43110
720 7202132 62811
720 7202132 43110
720 7202133 62811
720 7202133 43110
720 7202134 62811
720 7202134 43110
720 7201376 73211
720 7201376 51245
30 -Mar -11
Increase for construction schedule
Increase for construction schedule
Increase for Insurance Proceeds
Insurance Proceeds
Purchase of flood control units
Rebudget FY 12
Increase to actual
Increase to actual
2,039 730 7302162 73211 Increase to actual
2,039 730 7302162 53102 Increase to actual
New Grant
New Grant Appropriation
Increase to actual
Increase to actual
Purchase of flood control units
Purchase of sandbagging unit
Shift to Transit Bus Match
Reduce SRF Borrowing for Grant
New Grant
America's River III
New Grant Appropriation
Investment Earnings
Increase to actual
Salvage Sales
Increase to actual
From Dredging CIP
Shift to Bond Fund
Shift to Lower Bee Branch Bridge CIP
Shift from Bee Branch Alignment CIP
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Increase to actual
101 46
101 46
101 46
101 46
101 46
102 46
7 11
8 11
37 13
38 13
47 13
48 13
60 32
61 32
81 42
82 42
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department Program
Parking Division
Parking Division
Parking Division
Parking Division
Parking Division
Parking Division
TRANSFERS
Police Departme:
Police Departme
Fire Department
Fire Department
Fire Department
Fire Department
Civic Center Div
Civic Center Div
Water Departmei
Water Departmei
8C
8C
8C
8C
8C
8C
Trans01
Trans01
Trans02
Trans02
Trans03
Trans03
Trans04
Trans04
Trans05
Trans05
WATER CONSTRUCTIO
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmel
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departme]
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Water Departmei
Public Works
Description
Port of Dubuque Special Expenses - Legal Services
Port of Dubuque Special Expenses - Consultant Services
Port of Dubuque Special Expenses - Bond Proceeds
10th & Central Parking Ramp - Construction
10th & Central Parking Ramp - Construction
10th & Central Parking Ramp - Investment Earnings
TOTAL PARKING CONSTRUCTION FUND
N FUND
71 42 8C Water Internal Lines/Loan - Repayments
72 42 8C Bunker Hill Pump Station - Investment Earnings
73 42 8C Bunker Hill Pump Station - Construction
74 42 8C Roosevelt Road Main Ext - Investment Earnings
75 42 8C Roosevelt Road Main Ext - Construction
76 42 8C Vacuum Filter Back -Up - Investment Income
77 42 8C Vacuum Filter Back -Up - Construction
78 42 8C Millwork Dist - Water Main - Bond Proceeds
79 42 8C Millwork Dist - Water Main - Investment Earnings
80 42 8C Millwork Dist - Water Main - Construction
83 42 8C Drinking Water Study - Investment Earnings
84 42 8C Drinking Water Study - Consulting Engineers
85 42 8C Fluoride Tank Upgrade - Investment Earnings
86 42 8C Fluoride Tank Upgrade - Construction
87 42 8C Asbury Tank Painting - Investment Earnings
88 42 8C Asbury Tank Painting - Construction
89 42 8C Pump Room Roof Replacement - Investment Earnings
90 42 8C Pump Room Roof Replacement - Construction
91 42 8C Electrical Usage Integration - Investment Earnings
92 42 8C Electrical Usage Integration - Consulting
93 42 8C ADA Improvements Water Plant - Investment Earnings
94 42 8C ADA Improvements Water Plant - Construction
205 54 8C Purchase of HESCO Flood Barriers
TOTAL WATER CONSTRUCTION FUND
GRAND TOTAL AMENDMENT #3
Transfer from General Fund to DRA Distribution Fund
Transfer from General Fund to DRA Distribution Fund
Transfer from General Fund to Debt Service Fund
Transfer from General Fund to Debt Service Fund
Transfer from General Fund to General Fund Gaming
Transfer from General Fund to General Fund Gaming
Transfer from Sales Tax Construction to General Fund
Transfer from Sales Tax Construction to General Fund
Transfer from Bond Proceeds to Water Fund
Transfer from Bond Proceeds to Water Fund
FY 11
Expense
Amount
700,622
873,156
(500,000)
28,808
1,104,625
Transfer Out
4,000
Page 8
FY 11
Revenue
Amount Fund Activity/CIP Account
730 7302260 62713
730 7302260 62716
578,000 730 7302260 54210
730 7302179 73211
730 7302179 73211
28,808 730 7302179 43110
608,847
87,587 740 7401398 53102
26 740 7401398 43110
26 740 7401398 73210
26 740 7401672 43110
26 740 7401672 73210
29 740 7402030 43110
29 740 7402030 73211
(431,000) 740 7402145 54210
988 740 7402145 43110
664 740 7402145 73211
47 740 7402147 43110
47 740 7402147 62712
33 740 7402148 43110
33 740 7402148 73211
89 740 7402204 43110
89 740 7402204 73211
115 740 7402206 43110
115 740 7402206 73210
185 740 7402210 43110
185 740 7402210 62716
47 740 7401402 43110
47 740 7401402 73210
7,434 740 7402335 71550
8,695 (341,828)
17,544,130 16,272,028
(85,000)
12,317
6,740
646,177
Transfer In
4,000
(85,000)
12,317
6,740
646,177
100
102
101
400
100
101
350
101
440
740
10010100
1022185
10110101
40013800
10010100
1012187
35010350
1012283
44010440
7402145
91102
59100
91400
59101
91101
59100
91101
59350
91740
59440
Explanation
Shift from 10th & Central
Additional Expense
Additional Borrowing
Shift to POD Special Expenses
Increase to actual
Increase to actual
30- Mar -11
Amend in Rec- Westbrook/N GrandvieH
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Eliminate Bond Proceeds
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Investment Earnings
Increase to actual
Purchase of flood control units
Trans Funds
Trans Funds
Trans Funds
Trans Funds
Trans Funds
Trans Funds
Trans Funds
Trans Funds
Trans Funds
Trans Funds
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
FY 11 FY 11
Expense Revenue
Department Program Description Amount Amount Fund Activity/CIP Account Explanation
120 51 Airport Departm. Trans06 Transfer from Passenger Facility Charge to Airport Const. 191,260 391 39110391 91390 Trans Funds
121 51 Airport Departm. Trans06 Transfer from Passenger Facility Charge to Airport Const. 191,260 390 3902213 59391 Trans Funds
122 51 Airport Departm, Trans07 Transfer from Customer Facility Charge to Airport Const. 25,236 252 25210252 91390 Trans Funds
123 51 Airport Departm, Trans07 Transfer from Customer Facility Charge to Airport Const. 25,236 390 3902213 59252 Trans Funds
124 51 Airport Departm Trans08 Transfer from DRA Distribution to Airport Construction 67,333 102 10210102 91390 Trans Funds
125 51 Airport Departm Trans08 Transfer from DRA Distribution to Airport Construction 67,333 390 3902213 59102 Trans Funds
128 51 Airport Departmo Trans09 Transfer from Airport Construction to Road Use Tax Fund 23,946 390 39010390 91250 Trans Funds
129 51 Airport Departm Trans09 Transfer from Airport Construction to Road Use Tax Fund 23,946 250 25054420 59390 Trans Funds
138 53 Transit Division Trans10 Transfer from General Fund to Transit Fund 80,000 101 10110101 91600 Trans Funds
139 53 Transit Division Trans10 Transfer from General Fund to Transit Fund 80,000 600 6001224 59101 Trans Funds
140 53 Transit Division Transl l Transfer from DRA Distribution to Transit Fund 111,000 102 10210102 91600 Trans Funds
141 53 Transit Division Trans 11 Transfer from DRA Distribution to Transit Fund 111,000 600 6001224 59102 Trans Funds
142 53 Transit Division Trans 12 Transfer from General Fund to Transit Fund 42,000 100 10010100 91600 Trans Funds
143 53 Transit Division Trans 12 Transfer from General Fund to Transit Fund 42,000 600 6001224 59100 Trans Funds
144 53 Transit Division Trans13 Transfer from General Fund to Transit Fund 92,799 100 10010100 91600 Trans Funds
145 53 Transit Division Trans13 Transfer from General Fund to Transit Fund 92,799 600 6001224 59100 Trans Funds
146 53 Transit Division Trans14 Transfer from General Fund to Transit Fund 30,000 101 10110101 91600 Trans Funds
147 53 Transit Division Trans14 Transfer from General Fund to Transit Fund 30,000 600 6001224 59101 Trans Funds
148 53 Transit Division Trans15 Transfer from Stormwater Fund to Transit Fund 100,000 720 72010720 91600 Trans Funds
149 53 Transit Division Trans 15 Transfer from Stormwater Fund to Transit Fund 100,000 600 6001224 59720 Trans Funds
150 53 Transit Division Trans16 Transfer from DRA Distribution to Transit Fund 53,000 102 10210102 91600 Trans Funds
151 53 Transit Division Transl6 Transfer from DRA Distribution to Transit Fund 53,000 600 6001224 59102 Trans Funds
152 53 Transit Division Trans17 Transfer from DRA Distribution to Transit Fund 50,000 102 10210102 91600 Trans Funds
153 53 Transit Division Trans17 Transfer from DRA Distribution to Transit Fund 50,000 600 6001224 59102 Trans Funds
154 53 Transit Division Trans18 Transfer from General Fund to Transit Fund 27,500 101 10110101 91600 Trans Funds
155 53 Transit Division Trans18 Transfer from General Fund to Transit Fund 27,500 600 6001224 59101 Trans Funds
156 53 Transit Division Trans19 Transfer from General Fund to Transit Fund 50,125 100 10010100 91600 Trans Funds
157 53 Transit Division Transl9 Transfer from General Fund to Transit Fund 50,125 600 6001224 59100 Trans Funds
180 54 Public Works Trans20 Transfer from DRA Distribution to Road Use Tax Fund 250,000 102 10210102 91250 Trans Funds
181 54 Public Works Trans20 Transfer from DRA Distribution to Road Use Tax Fund 250,000 250 25054420 59102 Trans Funds
182 54 Public Works Trans21 Transfer from General Fund to Road Use Tax Fund 10,372 100 10010100 91250 Trans Funds
183 54 Public Works Trans2l Transfer from General Fund to Road Use Tax Fund 10,372 250 25054420 59100 Trans Funds
184 54 Public Works Trans22 Transfer from General Fund to Road Use Tax Fund 18,671 100 10010100 91250 Trans Funds
185 54 Public Works Trans22 Transfer from General Fund to Road Use Tax Fund 18,671 250 25054420 59100 Trans Funds
186 54 Public Works Trans23 Transfer from General Fund to Road Use Tax Fund 8,698 100 10010100 91250 Trans Funds
187 54 Public Works Trans23 Transfer from General Fund to Road Use Tax Fund 8,698 250 25054420 59100 Trans Funds
188 54 Public Works Trans24 Transfer from General Fund to Road Use Tax Fund 8,825 100 10010100 91250 Trans Funds
189 54 Public Works Trans24 Transfer from General Fund to Road Use Tax Fund 8,825 250 25054420 59100 Trans Funds
190 54 Public Works Trans25 Transfer from General Fund to Road Use Tax Fund 25,110 100 10010100 91250 Trans Funds
191 54 Public Works Trans25 Transfer from General Fund to Road Use Tax Fund 25,110 250 25054420 59100 Trans Funds
192 54 Public Works Trans26 Transfer from General Fund to Road Use Tax Fund 35,549 101 10110101 91250 Trans Funds
193 54 Public Works Trans26 Transfer from General Fund to Road Use Tax Fund 35,549 250 25054420 59101 Trans Funds
194 54 Public Works Trans27 Transfer from General Fund to Road Use Tax Fund 40,000 100 10010100 91250 Trans Funds
195 54 Public Works Trans27 Transfer from General Fund to Road Use Tax Fund 40,000 250 25054420 59100 Trans Funds
196 54 Public Works Trans28 Transfer from General Fund to Road Use Tax Fund 2,698 101 10110101 91250 Trans Funds
197 54 Public Works Trans28 Transfer from General Fund to Road Use Tax Fund 2,698 250 25054420 59101 Trans Funds
198 54 Public Works Trans29 Transfer from DRA Distribution to Road Use Tax Fund 112,042 102 10210102 91250 Trans Funds
Page 9
30-Mar-11
199 54
200 54
201 54
202 54
203 54
208 55
209 55
210 55
211 55
212 55
213 55
214 55
215 55
237 55
238 55
246 55
247 55
248 55
249 55
254 55
255 55
304 60
305 60
306 60
307 60
310 60
311 60
FISCAL YEAR 2011 AMENDMENT #3 CITY COUNCIL
Department
Public Works
Public Works
Public Works
Public Works
Public Works
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Economic Devlo
Economic Devlo
Economic Devlo
Economic Devlo
Economic Devlo
Economic Devlo
Program
Trans29
Trans30
Trans30
Trans31
Trans31
Trans32
Trans32
Trans33
Trans33
Trans34
Trans34
Trans35
Trans35
Trans36
Trans36
Trans37
Trans37
Trans38
Trans38
Trans39
Trans39
Trans40
Trans40
Trans41
Trans41
Trans42
Trans42
Description
Transfer from DRA Distribution to Road Use Tax Fund
Transfer from DRA Distribution to Road Use Tax Fund
Transfer from DRA Distribution to Road Use Tax Fund
Transfer from General Fund to Road Use Tax Fund
Transfer from General Fund to Road Use Tax Fund
Transfer from DRA Distribution to Street Construction Fund
Transfer from DRA Distribution to Street Construction Fund
Transfer from Sales Tax Construction to Street Construction
Transfer from Sales Tax Construction to Street Construction
Transfer from Road Use Tax Fund to Street Construction Fund
Transfer from Road Use Tax Fund to Street Construction Fund
Transfer from Special Assessment Fund to General Constructio
Transfer from Special Assessment Fund to General Construction
Transfer from Bond Proceeds to Storm Construction Fund
Transfer from Bond Proceeds to Storm Construction Fund
Transfer from Road Use Tax Fund to Transit Fund
Transfer from Road Use Tax Fund to Transit Fund
Transfer from Library Trust Fund to General Fund
Transfer from Library Trust Fund to General Fund
Transfer from Spec. Assessment Fd to Sewer Const Fund
Transfer from Spec. Assessment Fd to Sewer Const Fund
Transfer from Bond Proceeds to General Construction Fund
Transfer from Bond Proceeds to General Construction Fund
Transfer from Bond Proceeds to General Construction Fund
Transfer from Bond Proceeds to General Construction Fund
Transfer from Bond Proceeds to General Construction Fund
Transfer from Bond Proceeds to General Construction Fund
TOTAL TRANSFERS
GRAND TOTAL WITH TRANSFERS
FY 11
Expense
Amount
FY 11
Revenue
Amount Fund Activity/CIP Account Explanation
112,042 250 25054420 59102 Trans Funds
30,000 102 10210102 91250 Trans Funds
30,000 250 25054420 59102 Trans Funds
10,000 101 10110101 91250 Trans Funds
10,000 250 25054420 59101 Trans Funds
40,000 102 10210102 91300 Trans Funds
40,000 300 3002274 59102 Trans Funds
25,000 350 35010350 91300 Trans Funds
25,000 300 3002274 59350 Trans Funds
27,072 250 25010250 91300 Trans Funds
27,072 300 3002274 59250 Trans Funds
1,678,460 255 25510255 91360 Trans Funds
1,678,460 360 3602137 59255 Trans Funds
4,487,863 440 44010440 91720 Trans Funds
4,487,863 720 7201654 59440 Trans Funds
16,782 250 25010250 91600 Trans Funds
16,782 600 6001614 59250 Trans Funds
76,074 295 29536480 91100 Trans Funds
76,074 100 1001141 59295 Trans Funds
(60,000) 255 25510255 91710 Trans Funds
(60,000) 710 7101307 59255 Trans Funds
90,231 440 44010440 91360 Trans Funds
90,231 360 3602250 59440 Trans Funds
122,089 440 44010440 91360 Trans Funds
122,089 360 3602267 59440 Trans Funds
268 440 44010440 91360 Trans Funds
268 360 3602251 59440 Trans Funds
8,584,237 8,584,237
26,128,367 24,856,265
Page 10
30- Mar -11