FY 2010 Second Budget AmendmentMasterpiece on the Mississippi
April 13, 2010
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2010 Second Budget Amendment
Dubuque
Ibtkil
All-America City
1 '
2007
Budget Director Jennifer Larson is recommending adoption of the Fiscal Year 2010
Second Budget Amendment.
The amendment totals $9,115,280 in reduced appropriation authority and an decrease
in resources of $9,304,308. The additional revenues to the City include $12,835,147 in
federal and state grants and private contributions.
This budget amendment includes items, which have been authorized by City Council
since the first amendment to the Fiscal Year 2010 budget was adopted in September
2009 and adjustments to reflect the amended Community Development Annual Plan.
This amendment also reflects reappropriations of completed or cancelled projects to
fund increased operating and capital expenses. Interfund transfers have been reduced
by $35,730,578 due to simplifying the process of receipting bond proceeds into the
City's general ledger. The bond proceeds for projects related to the Enterprise Funds
will be recorded directly into the Enterprise Funds rather than through the Bond
Proceeds Fund thus eliminating the related internal transfers.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
MCVM /JML
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Jennifer Larson, Budget Director
M(chael C. Van Milligen
Masterpiece on the Mississippi
April 9, 2010
TO: Michael C. Van Milligen, City Manager
FROM: Jennifer Larson, Budget Director
SUBJECT: Fiscal Year 2010 Second Budget Amendment
The purpose of this memorandum is to present a summary of the action items approved by
City Council throughout the year subject to a future budget amendment and to set the
public hearing date for the formal budget amendment process as required by Section
384.16 of the Code of Iowa.
This budget amendment includes items, which have been authorized by City Council since
the first amendment to the Fiscal Year 2010 budget was adopted in September 2009 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 have been reduced by
$35,730,578 due to simplifying the process of receipting bond proceeds into the City's
general ledger. The bond proceeds for projects related to the Enterprise Funds will be
recorded directly into the Enterprise Funds rather than through the Bond Proceeds Fund
thus eliminating the related internal transfers.
The amendment totals $9,115,280 in reduced appropriation authority and a decrease in
resources of $9,304,308.
Additional revenues added in this amendment with offsetting appropriations are:
Dubuque
u4menacl y
1
2007
• Federal Transportation Investment Generating Economic Recovery Grant (TIGER)
($5,600,000) for Historic Millwork District Complete Streets,
• Federal Stimulus Grant ($2,909,534) for Southwest Arterial,
• Private Participant Funds from EB Lyons ($1,082,794) for EB Lyons Expansion
Project.
• Federal Aviation Administration Funds ($590,088) for Airport New Terminal Project,
• Federal Omnibus Act Funds ($554,347) for Southwest Arterial,
• Iowa Clean Air Attainment Program Funds ($448,086) for Northwest Arterial
Capacity Improvements,
• State Transit Assistance (STA) Rebuild Iowa Infrastructure Fund (300,000) for
Intermodal Feasibility Study,
• Revitalize Iowa's Sound Economy Grant (RISE) ($285,002) for North Siegert Farm
Development,
• State I -Jobs Grant ($252,150) for Southwest Arterial,
• Private Donation ($235,000) for Grandview /Rockdale Park,
• Repayment from Kerper TIF ($223,048) for Dubuque Community Ice Arena and
RAGBRAI,
• State Stimulus Grant ($183,402) for North Fork Catfish Creek Stormwater
Improvements,
• Federal National Scenic Byways Grant ($183,200) for EB Lyons Expansion Project,
• Federal Justice Assistance Grant ($87,467) for Police overtime and equipment,
• State DMATS Funding ($70,000) for Northwest Arterial Capacity Improvements,
• Private Pledge Contributions ($67,246) for Library Renovation,
• Additional Bond Proceeds from Bond Sale ($59,518) for Fire Pumper Replacement
Airport Improvements and Engineering Projects,
• Resale of Millings ($33,600) for 2009 Asphalt Milling Program,
• Federal Generation Green U.S. Environmental Protection Agency Grant ($28,000)
for Sustainability Education,
• Federal Occupant Protection Grant ($20,025) for Police overtime and education and
training and
• State Alcohol Tobacco Compliance Grant ($8,850) for Police overtime.
Revenues that were reduced in this amendment with offsetting reductions in appropriations
are:
• Federal Safe, Accountable, Flexible, Efficient Transportation Equity Act Funds: A
Legacy for Users (SAFETEA -LU) (- $5,568,888) for Southwest Arterial,
• Economic Development Administration Grant (- $7,463,997) for Downtown Parking
Ramp,
• State DMATS Funding (- $1,213,463) for Southwest Arterial,
• Bond Proceeds (- $1,859,003) for Downtown Parking Ramp,
• Private Participant (- $322,000) for Developing New Pet Park,
• Building Permit Revenue (- $121,635) for Reduced Building Permit Revenue
projected,
• Private Participant Funds from Dubuque County Historical Society (- $72,252) for
Riverwalk Pledge Obligation fulfilled,
• State Grant (- $15,000) for Planning Phase VI Survey for Section 106 reviews and
• Housing and Urban Development Fair Housing Grant (- $4,822) for Human Rights.
The action step is for City Council to adopt the attached resolution approving the FY 2010
second budget amendment.
Attachments
JML
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. 117-10
CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION
To the Auditor of DUBUQUE County, Iowa:
The City Council of DUBUQUE in said County /Counties met on 04/19/2010
,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.
A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE : 2010
(AS AMENDED LAST ON 09/21/2009 .)
Be it Resolved by the Council of the City of DUBUQUE
Section 1. Following notice published
and the public hearing held, 04/19/2010 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:
Signature
City Clerk/Finance Officer
19th day of April, 20
(Oa
31 -288
Signature
Mayor
Total Budget
as certified
or last amended
Current
Amendment
Total Budget
after Current
Amendment
Revenues & Other Financing Sources
18,331,912
0
18,331,912
Taxes Levied on Property
1
Less: Uncollectted Property Taxes -Levy Year
2
0
0
0
Net Current Property Taxes
3
18,331,912
0
18,331,912
Delinquent Property Taxes
4
0
0
0
TIF Revenues
5
6,610,851
0
6,610,851
Other City Taxes
6
13,913,509
0
13,913,509
Licenses & Permits
7
1,336,745
- 121,635
1,215,110
Use of Money and Property
8
12,836,582
91,466
12,928,048
Intergovernmental
9
61,354,443
- 2,937,065
58,417,378
Charges for Services
10
27,422,276
•
0
27,422,276
Special Assessments
11
1,599,650
- 258,093
1,341,557
Miscellaneous
12
8,251,551
1,677,799
9,929,350
Other Financing Sources
13
125,488,718
- 43,487,358
82,001,360
Total Revenues and Other Sources
14
277,146,237
- 45,034,886
232,111,351
Expenditures & Other Financing Uses
22,667,259
126,312
22,793,571
Public Safety
15
Public Works
16
11,873,397
- 11,044
11,862,353
Health and Social Services
17
958,395
17,506
975,901
Culture and Recreation
18
9,060,529
73,554
9,134,083
Community and Economic Development
19
12,242,719
- 30,356
12,212,363
General Government
20
6,863,357
93,158
6,956,515
Debt Service
21
5,970,043
0
5,970,043
Capital Projects
22
75,327,014
166,819
75,493,833
Total Government Activities Expenditures
23
144,962,713
435,949
145,398,662
Business Type / Enterprises
24
94,854,604
- 9,551,229
85,303,375
Total Gov Activities & Business Expenditures
25
239,817,317
- 9,115,280
230,702,037
Transfers Out
26
67,767,930
- 35,730,578
32,037,352
Total Expenditures/Transfers Out
27
307,585,247
- 44,845,858
262,739,389
Excess Revenues & Sources Over
(Under) Expenditures/Transfers Out Fiscal Year
28
- 30,439,010
- 189,028
..
- 30,628,038
Continuing Appropriation
29
0
N/A
0
Beginning Fund Balance July 1
30
43,598,570
9,238,013
52,836,583
Ending Fund Balance June 30
31
13,159,560
9,048,85
22,208,545
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. 11 —10
RESOLUTION No.
CITY BUDGET AMENDMENT AND CERTIFICATION RESOLUTION
To the Auditor of DUBUQUE County, Iowa:
The City Council of DUBUQUE in said County /Counties met on 04/19/2010
,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.
A RESOLUTION AMENDING THE CURRENT BUDGET FOR THE FISCAL YEAR ENDING JUNE : 2010
(AS AMENDED LAST ON 09/21/2009 .)
Be it Resolved by the Council of the City of DUBUQUE
Section 1. Following notice published
and the public hearing held, 04/19/2010 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:
Signature
City Clerk/Finance Officer
19th day of April, 20
(Oa
31 -288
Signature
Mayor
FISCAL YEAR 2010 AMENDMENT #2
Department Description
GENERAL FUND
Police Departme Police Patrol - Copier Machine
Police Departme Police Patrol - Pager/Radio Equipment
Police Departme 09 JAG Grant - Fed Pass Thru State Grant
Police Departme 09 JAG Grant - Other Police Equipment
Police Departme Occupant Protection Grant - Fed Aid Law Enforcement
Police Departme Occupant Protection Grant - Overtime
Police Departme Occupant Protection Grant - Mileage
Police Departme Occupant Protection Grant - Education & Training
Police Departme Helping Services of NE Iowa - Fed Pass Thru State Grant
Police Departme Helping Services of NE Iowa - Misc Operating Supplies
Police Departme Helping Services of NE Iowa - Overtime Reimbursable
Police Departme Alcohol Tobacco Compliance - State Compliance
Police Departme Alcohol Tobacco Compliance - Overtime
Building Service Building Code Enforcement - 850 Air Hill Assessment
Building Service Building Code Enforcement - 850 Air Hill Assessment
Building Service Building Code Enforcement - 850 Air Hill Assessment
Building Service Building Code Enforcement - Building Permits
Human Rights Human Relations - Fair Housing Grant
Human Rights Human Rights Grant Funds - Fair Housing Training
Human Rights Human Rights Grant Funds - Misc Services
Health Services Public Health Emerg Preparedness - Fed Pass Thru State Gr
Health Services Public Health Emerg Preparedness - Misc Services
Health Services Lead Paint Program - Fed pass Thru State Grant
Health Services Lead Paint Program - State Grant
Recreation Divis
Recreation Divis
Recreation Divis
Recreation Divis
Recreation Divis
Recreation Divis
Recreation Divis
Library Departm
Library Departm
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
Recreation - Multicultural Family Center - Full -time
Recreation - Multicultural Family Center - Part-time
Recreation - Multicultural Family Center - Seasonal
Recreation - Multicultural Family Center - IPERS
Recreation - Multicultural Family Center - Social Security
Recreation - Multicultural Family Center - Health
Recreation - Multicultural Family Center - Life Ins
Adult Services - Library Cont/Serials
Youth Services - Library Books
Arts and Cultural Affairs
Arts and Cultural Affairs
Arts and Cultural Affairs
Arts and Cultural Affairs
Arts and Cultural Affairs
Arts and Cultural Affairs
- ICCG Grant
- Part-time Wages
- Social Security
- IPERS
- Conferences
- Consultant Services
Planning Service City Planning/Historic Preservation - State Grant
Planning Service City Planning/Historic Preservation - Consultant Services
City Manager Sustainable Comm Coord - Full -time Employee
FY 10
Expense
Amount
13,251
(13,251)
87,467
18,750
750
525
2,750
1,820
8,850
5,400
(2,500)
(2,322)
22,328
25,492
19,784
(4,547)
2,643
3,038
4,590
49
1,923
774
15,581
1,191
1,036
4,000
(2,000)
(15,000)
54,549
Page 1
FY 10
Revenue
Amount
Fund Activity/CIP Account Explanation
100 10011700 71116
100 10011700 72410
87,467 100 10011775 45771
100 10011775 72218
20,025 100 10011771 44125
100 10011771 61050
100 10011771 62340
100 10011771 62360
4,570 100 10011324 45771
100 10011324 62671
100 10011324 61051
8,850 100 10011764 45701
100 10011764 61050
100 10057400 62731
4,860 100 10057400 52101
540 100 10057400 52102
(121,635) 100 10057400 42205
(4,822) 100 10016100 44320
100 10016200 62753
100 10016200 62731
22,328 100 10017400 45771
100 10017400 62731
(23,865) 100 10017500 45771
23,865 100 10017500 45701
100 10034100 61010
100 10034100 61020
100 10034100 61030
100 10034100 61310
100 10034100 61320
100 10034100 61410
100 10034100 61415
100 10036200 62654
100 10036400 62651
13.700 100 10072500 45701
100 10072500 61020
100 10072500 61320
100 10072500 61310
100 10072500 62310
100 10072500 62716
(15,000) 100 10062700 45701
100 10062700 62716
100 10072200 61010
09 -Apr -10
Shift from Pager/Radio Equipment
Shift to Copier Machine
New Grant
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant Appropriation
New Grant Appropriation
New Grant
New Grant Appropriation
New Grant Appropriation
New Grant
Grant Appropriation
Assessment for 850 Air Hill
Assessment for 850 Air Hill
Assessment for 850 Air Hill
Amend to projected actual
Adjust to actual HUD Contract
Adjust to actual HUD Contract
Adjust to actual HUD Contract
Adjust to actual Grant Contract
Adjust to actual Grant Contract
Reclassify to Lead State Grant
Reclassify from Lead Fed Pass Thru
From FY 09 CIP Savings
From FY 09 CIP Savings
From FY 09 CIP Savings
From FY 09 CIP Savings
From FY 09 CIP Savings
From FY 09 CIP Savings
From FY 09 CIP Savings
Lost book money
Lost book money
New Grant
Grant Appropriation
Grant Appropriation
Grant Appropriation
FY09 C/O Correction
FY09 C/O Correction
Remove - grant not received
Remove - grant not received
Shift from 10072100 to Sustainability
Department
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Manager
City Clerk
Transit Division
Fire Department
Public Works
Public Works
Public Works
Engineering
Engineering
Engineering
Parks Division
Parks Division
Parks Division
Parks Division
Description
Sustainable Comm Coord - IPERS
Sustainable Comm Coord - Social Security
Sustainable Comm Coord - Health Insurance
Sustainable Comm Coord - Life Insurance
Sustainable Comm Coord - Growing Sust Comm - Misc Svcs
Sustainable Comm Coord - Growing Sust Comm - Postage
Sustainable Comm Coord - Growing Sust Comm - Printing
Sustainable Comm Coord - Growing Sust Comm - Speakers
Sustainable Comm Coord - Growing Sust Comm - Misc Rev
Sustainable Comm Coord - Growing Sust Comm - Printing
Sustainable Comm Coord - Travel /Conferences
Sustainable Comm Coord - Parking Space Rental
City Mgr Mgmt - Private Participant (Green Comm Sponsor)
Sustainable Comm Coord - Private Part (Green Comm Spons)
City Manager Mgmt - Federal Grants (Energy Block Grant)
Sustainable Comm Coord - Fed Stimulus (Energy Block Grant)
City Mgr Mgmt - Full -time Employee
City Mgr Mgmt - IPERS
City Mgr Mgmt - Social Security
City Mgr Mgmt - Health Insurance
City Mgr Mgmt - Life Insurance
City Mgr Mgmt - Misc Svcs
City Mgr Mgmt - Postage
City Mgr Mgmt - Printing
City Mgr Mgmt - Speakers
City Mgr Mgmt - Misc Rev
City Mgr Mgmt - Printing
City Mgr Mgmt - Travel /Conferences
City Mgr Mgmt- Parking Space Rental
City Mgr Mgmt - Stimulus Coordinator -Full -time Employee
City Mgr Mgmt - Stimulus Coordinator - IPERS
City Mgr Mgmt - Stimulus Coordinator - Social Security
City Mgr Mgmt - Consultant Services - Safe Comm Task Force
City Mgr Mgmt - Consultant Services - Grant Writing
City Mgr Mgmt - Consultant Services - Grant Writing
City Clerk - Elections Expense
Burlington Trailways - Pay to Other Agency
Pumper Replacement - Heavy Equipment Replacement
Railroad Depot Phase 1- Construction
Railroad Depot Phase 1- Fed Pass Thru State Grant
Bi- Lingual Trail Signage - Signage
Port of Dubuque Outdoor Plaza - Park - Engineering Services
Port of Dubuque Outdoor Plaza - Park - Construction
Sidewalk Inspection Program - Construction Not Bldg
EB Lyons Expansion - Private Participant
EB Lyons Expansion - Const Contract Building
EB Lyons Expansion - Fed Pass Thru State Grant
EB Lyons Expansion - Private Participant
FY 10
Expense
Amount
3,628
4,173
7,500
109
25,000
1,500
3,500
5,000
5,000
7,450
420
(54,549)
(3,628)
(4,173)
(7,500)
(109)
(25,000)
(1,500)
(3,500)
(5,000)
(5,000)
(7,450)
(420)
27,914
1,856
2,135
44,600
25,000
44,000
(61,947)
9,600
32,439
16,809
22,667
(25,000)
(225,000)
(40,000)
1,036,994
Page 2
FY 10
Revenue
Amount Fund Activity/CIP Account Explanation
100 10072200 61310 Shift from 10072100 to Sustainability
100 10072200 61320 Shift from 10072100 to Sustainability
100 10072200 61320 Shift from 10072100 to Sustainability
100 10072200 61320 Shift from 10072100 to Sustainability
100 10072200 62731 Shift from 10072100 to Sustainability
100 10072200 62030 Shift from 10072100 to Sustainability
100 10072200 62090 Shift from 10072100 to Sustainability
100 10072200 62734 Shift from 10072100 to Sustainability
5,000 100 10072200 53605 Shift from 10072100 to Sustainability
100 10072200 62090 Shift from 10072100 to Sustainability
100 10072200 62310 Shift from 10072100 to Sustainability
100 10072200 62436 Shift from 10072100 to Sustainability
(20,000) 100 10072100 53102 Shift to Sustainable Comm Coord
20,000 100 10072200 53102 Shift from City Mgr Mgmt
(93,489) 100 10072100 44170 Shift to Sustainable Comm Coord
93,489 100 10072200 44175 Shift from City Mgr Mgmt
100 10072100 61010 Shift to 10072200 Sustainability
100 10072100 61310 Shift to 10072200 Sustainability
100 10072100 61320 Shift to 10072200 Sustainability
100 10072100 61320 Shift to 10072200 Sustainability
100 10072100 61320 Shift to 10072200 Sustainability
100 10072100 62731 Shift to 10072200 Sustainability
100 10072100 62030 Shift to 10072200 Sustainability
100 10072100 62090 Shift to 10072200 Sustainability
100 10072100 62734 Shift to 10072200 Sustainability
(5,000) 100 10072100 53605 Shift to 10072200 Sustainability
100 10072100 62090 Shift to 10072200 Sustainability
100 10072100 62310 Shift to 10072200 Sustainability
100 10072100 62436 Shift to 10072200 Sustainability
100 10072100 61020 Stimulus Coordinator Appropriation
100 10072100 61310 Stimulus Coordinator Appropriation
100 10072100 61320 Stimulus Coordinator Appropriation
100 10072100 62716 Shift from election savings
100 10072100 62716 Shift from election/dept savings
100 10072100 62716 Shift from Petrakis Field
100 10073100 62698 Shift to Safe Comm Task Force
100 10079195 62761 Lease Appropriation
100 1001016 71318 Adjust to actual bond proceeds
100 1001201 73210 Increase appropriation
43,990 100 1001201 45771 Grant Appropriation
100 1002169 71227 Shift from Riverfront 2000 Plan
100 1001855 62716 Rebudgeted in FY 2011
100 1001855 62716 Rebudgeted in FY 2011
100 1001108 73211 Re- budgeted in future years
1,036,994 100 1002171 53102 New Grant
100 1002171 73210 New Grant Appropriation
183,200 100 1002171 45771 New Grant
45,800 100 1002171 53102 New Grant
Department
Parks Division
Parks Division
Parks Division
Parks Division
Parks Division
Parks Division
Parks Division
Engineering
Engineering
Engineering
Description
EB Lyons Expansion - Const Contract Building
Grandview/Rockdale Park - Private Participant
Grandview /Rockdale Park - Land Acquisition
Grandview /Rockdale Park - Const Cont Not Bldg
Create Pet Park - South - Construction Not Bldg
Create Pet Park - South - Municipal Assistance
Dubuque Community Ice Arena - Pay to Other Agency
Library Renovation - Pledge Revenue
Library Renovation - Interest Earnings
Library Renovation - Construction
Engineering Library Renovation - Construction
Economic Dever Warehouse Masterplan - Consultant Services
Housing & Comi Maintenance of Vacant/Abandoned Property - Reimburse
Housing & Conn Maintenance of Vacant/Abandoned Property - Construction
Housing & Comi Neighborhood Stabilization Grant - Fed Pass Thru State Grant
Housing & Comi Neighborhood Stabilization Grant - Federal Stimulus Grant
Housing & Comi Housing Trust - IAF - Principal
Housing & Comi Housing Trust - IAF - Interest
Housing & Corm Housing Trust - 1AF - Loan Proceeds
Housing & Cony Housing Trust - IAF - General Reimbursements
Housing & Comt Homeless Prevention Grant - Federal Grants Misc
Housing & Comi Homeless Prevention Grant - Federal Stimulus Grant
Housing & Corm Homeless Prevention Grant - Education & Training
Housing & Conti Homeless Prevention Grant - Grants
Planning Service Downtown Design Guideline - State Grants
Planning Service Downtown Design Guideline - Fed Pass Thru State Grant
City Manager City of Dubuque 175th Birthday - Misc Revenue
City Manager City of Dubuque 175th Birthday - Speakers/Programs
City Manager Generation Green EPA - Federal Grants Misc
City Manager Generation Green EPA - Misc Services
Police Departme Police Admin Office Remodel - Const Cont Bldg
Police Departme In Car Video Recorders - Equip Acquisition
Housing & Conn Homeownership Grants - Principal, Loans
Housing & Conn Homeownership Grants - Grants
Engineering Fiber Optic Conduit Paving Projects - Construction
Engineering Fiber Optic Conduit Paving Projects - Construction
Planning Service Annexation Study Implementation Strategy - Study /Legal
Planning Service Annexation Study Implementation Strategy - Study/Legal
Planning Service Riverfront 2000 Plan Implementation - Consultant Services
TOTAL GENERAL FUND
TRANSIT FUND
Transit Division Intermodal Feasibility Study - Consultant Services
Transit Division Intermodal Feasibility Study - State Grant
TOTAL TRANSIT FUND
DOWNTOWN LOAN POOL - TIF FUND
Economic Dever Downtown Loan Pool - IBM Forgivable Loan
FY 10
Expense
Amount
229,000
150,000
85,000
(322,000)
150,000
108,571
104,972
5,000
29,621
250,000
3,308
(501,538)
501,538
30
28,000
(1,515)
1,515
81,514
(56,506)
(56,506)
(50.000)
(50,000)
(22,667)
1,781,776
300,000 600 6001614 62716 Grant Appropriation
300,000 600 6001614 45701 Grant Appropriation
300,000
300.000 241 2411033 62764 Development Agreement
Page 3
FY 10
Revenue
Amount
235,000
Fund Activity/CIP Account
100 1002171 73210
100 1002181 53102
100 1002181 73110
100 1002181 73211
100 1001577 73211
(322,000) 100 1001577 45620
100 1002084 62761
67.246 100 1001141 53103
298 100 1001141 43110
100 1001141 73210
100 1001141 73210
100 1002081 62716
29,621 100 1001002 53620
100 1001002 73210
(444,328) 100 1002180 45771
444.328 100 1002180 44176
100 1001021 74111
100 1001021 74112
(250,000) 100 1001021 54205
250,000 100 1001021 53620
(502,294) 100 1002175 44170
502.294 100 1002175 44175
100 1002175 62360
100 1002175 62761
(16,117) 100 1001860 45701
16,117 100 1001860 45771
30 100 1001948 53605
100 1001948 62734
28,000 100 1002182 44170
100 1002182 62731
101 1011863 73210
101 1011580 73410
81,514 101 1011595 43405
101 1011595 62765
102 1021017 73211
102 1021017 73211
102 1021012 62716
102 1021012 62716
102 1021015 62712
1,450,576
300,000
Explanation
New Grant Appropriation
Record Private Donation
Record Private Donation Appropriation
Record Private Donation Appropriation
Cancel private participant
Cancel private participant
Increase appropriation
Library Renovation pledge revenue
Library Renovation interest earnings
Increase appropriation
Amendment 41 correction
Amend to actual Grant amount
Record actual reimbursements
Increased due to reimbursements
Shift to Stimulus Grant Revenue
Shift from Fed Pass Thru State Grant
Amend in Debt Payment
Amend in Debt Payment
Shift to General Reimbursements
Shift from Loan Proceeds
Shift to Federal Stimulus Grants
Shift from Federal Grants Misc
Shift to Grants
Shift from Education & Training
Shift to Fed Pass Thru State Grant
Shift from State Grants
Record additional revenue
Increased due to add'1 misc revenue
Record appropriation for add'] revenue
Record appropriation for add'l revenue
Shift to In Car Video Recorders
Shift from Admin Office Remodel
Record add'I loan payments
Increase due to loan payments
Rebudgeted in FY 2011
Re- budgeted in future years
Cancel and Rebudget FYI 1
Cancel and Rebudget FY11
Shift to Bi- Lingual Trail Signage
Department Description
TOTAL DOWNTOWN LOAN POOL -TIF FUND
FY 10 FY 10
Expense Revenue
Amount Amount
300,000
Fund Activity/CIP Account Explanation
Department Description
ROAD USE TAX FUND
Public Works
Public Works
Public Works
Public Works
Public Works
Public Works
Engineering
SPECIAL ASSESSMENT FUND
Public Works
Public Works
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Street Maintenance - Truck Replacement
Street Sweeper
Railroad Crossing Improv - Const Contract Not Bldg
Asphalt Milling Program - Reimbursements
Asphalt Milling Program - Const. Not Bldg
Snow and Ice Control Camera Project - Equipment
Fiber Optic Conduit Paving Projects - Const Not Bldg
TOTAL ROAD USE TAX FUND
Street Assessment - Principal
Street Assessment - Interest
Undistributed - Special Assessment -
Undistributed - Special Assessment -
Undistributed - Special Assessment -
Undistributed - Special Assessment -
Special Assessments - Principal
Special Assessments - Interest
TOTAL SPECIAL ASSESSMENT FUND
Principal Payments
Interest Payments
Principal Payments
Interest Payments
COMMUNITY DEVELOPMENT BLOCK GRANT FUND
Housing & Conn Housing Code Enforcement - Auto /Jeep Replacement
Housing & Comt Housing Rehabilitation - Office Supplies
Housing & Conn Lead Paint Hazard Abatement - Loans
Housing & Comm Neighborhood Development Services - Leadership Training
Housing & Comi CDBG Admin/Monitoring -CD Block Grant Receivable
Engineering ADA Curb Ramp Const Project - Construction Not Bldg
Housing & Comt First Time Homebuyer Program - Grants
Housing & Comt Historic Preservation Rehab - Grants
Housing & Comt Homeowner Rehab Program - Grants
Housing & Conn Commercial /Industrial Building Rehab Loans
Housing & Conn Accessible Curb Ramps - Construction Not Building
Housing & Comt Multicultural Family Center- Construction
Housing & Comt Neighborhood Support Grants - Grants
Housing & Comi Lead Paint Hazard Abatement - Grants
TOTAL CDBG FUND
COMMUNITY DEVELOPMENT RECOVERY FUND
Housing & Cotm Green Alley Pilot Project - Construction Not Building
Housing & Comt Residential Rehab Program - Loans
TOTAL CDBG RECOVERY FUND
LEAD PAINT GRANT FUND
Housing & Comt Lead Paint Abatement - Misc Revenue
Housing & Comt Lead Paint Abatement - Reimbursements Training
Housing & Comi Lead Paint Abatement - Grants
FY 10
Expense
Amount
(11,044) 250 25054400 71314
26,965 250 2501209 71321
(5,411) 250 2502026 73211
33,600 250 2501230 53620
250 2501230 73211
250 2502183 71118
250 2501017 73211
33,600
9,200
1,239
54,549
(3,476) 260 26061700 71310
2,505 260 26061300 62010
(60,000) 260 26061200 62765
(2,000) 260 26072800 62755
26,833 260 26061800 44205
260 2601236 73211
260 2601234 62764
260 2601237 62764
260 2601065 62764
260 2601746 62764
260 2601236 73211
260 2601976 73210
260 2601238 62765
260 2601232 62764
(47,000)
45,686
19,467
2,242
29,920
(1)
49,240
(2,517)
60,000
94,066
47,615
Page 5
FY 10
Revenue
Amount
33,600
26,833
42,155 275
5.460 275
275
Fund Activity/CIP Account Explanation
102,648 255 25510255 52101
11,405 255 25510255 52102
(27,000) 255 25510255 52101
(3,000) 255 25510255 52102
(27.000) 255 25510255 52101
(3.000) 255 25510255 52102
(285,791) 255 25510255 52101
(31,755) 255 25510255 52102
(263,493)
27561200
27561200
27561200
Shift to Street Sweeper CIP #2501209
Shift from #2502026,3001252,2505440
Shift to Street Sweeper CIP #2501209
Private Participant Reimbursement
Reimbursement appropriation
Shift from Dept Savings
Adjust to actual bond proceeds
Actual Cleveland Assessments
Actual Cleveland Assessments
Cancel Main St CIP #3602020
Cancel Main St CIP #3602020
Cancel Warehse Reconst CIP #3602137
Cancel Warehse Reconst CIP #3602137
Reduce to Actual
Reduce to Actual
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
Re- budgeted in future years
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
CDBG Amendment #2
49,240 262 2622044 73211 CDBG Amendment #2
(49,240) 262 2621065 62764 CDBG Amendment #2
53605 Record actual misc revenue
53625 Record add'I reimbursements training
62765 Record appropriation for add'I revenue
Department Description
TOTAL LEAD PAINT GRANT FUND
STREET CONSTRUCTION FUND
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
Engineering
Engineering
Warning Flashers Hawthorne - Equip Acquisition
Curb Ramp Program - Const. Not Bldg
Curb Replacement Program - Const. Not Bldg
Special Assessment Assistance - Pay to Other Agency
Locust - 9th to 17th Street - State Highway Assistance
Locust - 9th to 17th Street - Fed Pass Thru State Grant
Locust - 9th to 17th Street - Construction
Kaufmann Avenue Resurfacing - State Highway Assistance
Kaufmann Avenue Resurfacing - Fed Pass Thru State Grant
NW Arterial Capacity Improv - State Highway Assistance
NW Arterial Capacity Improv - Fed Pass Thru State Grant
US 61/151 Corridor - State Highway Assistance
US 61/151 Corridor - Fed Pass Thru State Grant
Street Light Replacement - Const Not Bldg
Southwest Arterial - Federal Aid - SAFETEA -LU Funds
Southwest Arterial - Federal Grants - Omnibus Act Funds
Southwest Arterial - State Highway Assistance- DMATS
Southwest Arterial - County Share
Southwest Arterial - Federal Stimulus Grants
Southwest Arterial - State Grants - I -Jobs
Southwest Arterial - Right -of -Way Acquisition
Southwest Arterial - Miscellaneous Services
Southwest Arterial - Consulting Engineers
NW Arterial Capacity Improvements - State Hwy Assist
NW Arterial Capacity Improvements - DMATS
NW Arterial Capacity Improvements - ICAAP
NW Arterial Capacity Improvements - Construction
NW Arterial Capacity Improvements - USTEP Grant
TOTAL STREET CONSTRUCTION FUND
SALES TAX FUND (20 %)
Engineering Curb Catch Basin Replacements - Construction
Engineering Decorative Concrete Maint - Construction Not Bldg
Civic Center Div Paint Arena Ceiling - Const Cont Building
Civic Center Div Espresso machine & Kiosk - Concession Equip
Civic Center Div Pipe and Drain - Misc Equip
Civic Center Div Meeting Room AV Equipment - Video Equip
Civic Center Div Floor Scrubber - Misc Equip
TOTAL SALES TAX FUND
GENERAL CONSTRUCTION FUND
Engineering Millwork Street Re- Construction - Federal Stimulus
Engineering Millwork Street Re- Construction
Engineering Millwork Streetscape - Construction Not Bldg
Engineering Main St Streetscape Improvements - Eng Div Services
FY 10
Expense
Amount
47,615
(10,510)
(4,704)
4,704
(40,000)
488,800
375
(2,724,960)
(835,000)
1,552,570
448,086
(1,120,639)
(125,000)
(10,221)
(95,000)
21,250
24,310
24,440
25,000
(135,221)
5,600,000
10,221
(85,000)
Page 6
FY 10
Revenue
Amount
47,615
Fund Activity/CIP Account Explanation
300 3001252 73411
300 3001227 73211
300 3001226 73211
300 3001256 62761
(488,800) 300 3002068 45725
488,800 300 3002068 45771
300 3002068 73211
(480,000) 300 3002140 45725
480,000 300 3002140 45771
(430,000) 300 3002029 45725
430,000 300 3002029 45771
(354,545) 300 3002028 45725
354,545 300 3002028 45771
300 3001549 73211
(5,568,888) 300 3001287 44145
554,347 300 3001287 44170
(1,213,463) 300 3001287 45725
(64,417) 300 3001287 46205
2,909,534 300 3001287 44175
252,150 300 3001287 45701
300 3001287 73113
300 3001287 62731
300 3001287 62712
(430,000) 300 3001287 45725
500,000 300 3001287 45771
448,086 300 3001287 45771
300 3001287 73211
110,000 300 3001287 45771
(2,502,651)
350 3501041 73211
350 3501630 73211
350 3502117 73210
350 3502262 72310
350 3502263 71550
350 3502264 72416
350 3502265 71550
5,600,000 360 3602137 44175
360 3602137 73211
360 3602136 73211
360 3602020 62811
Shift to Street Sweeper CIP #2501209
Shift to Curb Replace Program
Shift from Curb Ramp Program
Re- budgeted in future years
Shift to Fed Pass Thru State Grant
Shift from State Highway Assistance
DMATS appropriation
Shift to Fed Pass Thru State Grant
Shift from State Highway Assistance
Shift to Fed Pass Thru State Grant
Shift from State Highway Assistance
Shift to Fed Pass Thru State Grant
Shift from State Highway Assistance
Adjust to actual bond proceeds
Amend to actual
Amend to actual
Amend to actual
Amend to actual
Amend to actual
Amend to Actual
Amend to actual
Amend to actual
Amend to actual
Amend to actual
Amend to actual
New Grant
Grant Appropriation
Amend to actual
Re- budgeted in future years
Shift to Millwork St CIP #3602136
Shift to CIP 3502262- 3502265
Shift from Paint Arena Ceiling
Shift from Paint Arena Ceiling
Shift from Paint Arena Ceiling
Shift from Paint Arena Ceiling
TIGER Grant Appropriation
TIGER Grant Appropriation
Shift from Decor Concrete #3501630
Cancel Main St CIP #3602020
Department
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Description
Main St Streetscape Improvements - Const Not Bldg
Warehouse Fiber Optics - Eng Division Services
Warehouse Fiber Optics - Const Not Bldg
Warehouse Streetscape - Eng Division Services
Warehouse Streetscape - Const Not Bldg
Warehouse Reconstruction - Eng Division Services
Warehouse Reconstruction - Const Not Bldg
Economic Dever Community Marketing - Business Recruitment Payment
Economic Develi Industrial Site Development -N. Siegert - Investment Eamings
Economic Develi Industrial Site Development -N. Siegert - Const. Not Bldg
Economic Develb Industrial Site Development -N. Siegert - Const. Not Bldg
Economic Devell Industrial Site Development -N. Siegert - Const. Not Bldg
Economic Develi Industrial Site Development -N. Siegert - RISE Grant
Economic Dever Industrial Site Development -N. Siegert - Const. Not Bldg
Economic Develi Industrial Site Development -N. Siegert - Const. Not Bldg
Economic Deveh Industrial Site Development -N. Siegert - Const. Not Bldg
Economic Dever Industrial Site Development -N. Siegert - Const. Not Bldg
Economic Devell Purchase Building - GO Bond Proceeds
Economic Devell Purchase Building - Right -of -Way Acquisition
Economic Dever Purchase Building - Construction
Economic Dever Port of Dubuque Improvements - Const Contract
Economic Develo Design South Siegert Farm - Consulting Engineers
Economic Devel( Design South Siegert Farm - Const Not Bldg
Building Service Multicultural Family Center - Construction
Building Service Multicultural Family Center - Investment Earnings
Building Service Multicultural Family Center - Reimbursements General
Building Service Multicultural Family Center - Construction
TOTAL GENERAL CONSTRUCTION FUND
AIRPORT CONSTRUCTION FUND
Airport Departm Terminal - Land Acquisition - Construction
Airport Departm Terminal - Land Acquisition - FAA Funds
Airport Departm. Runway Safety Area - Construction
Airport Departm. Runway Safety Area -FAA Funds
Airport Departm Terminal - Sche /Site Design - Consulting Engineers
Airport Departm Terminal - Sche /Site Design -State Grants
Airport Departm Terminal - Sche /Site Design - Consulting Engineers
Airport Departm Terminal - Sche /Site Design -FAA Funds
Airport Departm Terminal Sche /Site Design - State Grants
Airport Departm. Iowa Hanger Heater Replacement - Construction
Airport Departm FBO Hanger Heating System - Construction
Airport Departm Terminal Boiler Replacement - Construction
Airport Departm Airport Runway Painting - Const Not Bldg
Airport Departm Asphalt Parking Lots - Const Not Bldg
Airport Departm Hanger Repairs/Replacement - Construction
Airport Departm Paint Hangar Exteriors - Construction
TOTAL AIRPORT CONSTRUCTION FUND
FY 10
Expense
Amount
(334,995)
(40,000)
(60,000)
(120,000)
(30.000)
(50,000)
(320,000)
(100,000)
8,957
(142,000)
644,993
85,002
23.783
19,825
17,850
(648,021)
(100,000)
(1,000,000)
(250,000)
(4,446.883)
1.342
131,251
(1,183,675)
31,550
(155,029)
413,699
299,868
664
742
1,518
1.518
1,707
979
262
597,478
Page 7
FY 10
Revenue
Amount Fund Activity /CIP Account Explanation
360 3602020 73211 Cancel Main St CIP #3602020
360 3602135 62811
360 3602135 73211
360 3602136 62811
360 3602136 73211
360 3602137 62811
360 3602137 73211
360 3601842 62716
8,957 360 3601943 43110
360 3601943 73211
360 3601943 73211
360 3601943 73211
285.002 360 3601943 45741
360 3601943 73211
360 3601943 73211
360 3601943 73211
360 3601943 73211
330,000 360 3602159 54210
360 3602159 73113
360 3602159 73210
360 3602156 73510
360 3602160 62712
360 3602160 73211
360 3601976 73210
697 360 3601976 43110
645 360 3601976 53620
360 3601976 73210
6,225,301
390 3901795 73210
31,550 390 3901795 44105
390 3901788 73210
(155.029) 390 3901788 44105
390 3901892 62712
413,699 390 3901892 45701
390 3901892 62712
299,868 390 3901892 44105
(26,050) 390 3901892 45701
390 3902124 73210
390 3902123 73210
390 3902126 73210
390 3902128 73211
390 3902007 73211
390 3902008 73210
390 3902125 73210
564,038
Cancel Warehouse Fiber CIP #3602135
Cancel Warehouse Fiber CIP #3602135
Cancel Warehse St CIP#3602136
Cancel Warehse St CIP #3602136
Cancel Warehse Reconst CIP #3602137
Cancel Warehse Reconst CIP #3602137
Cancel
Record actual investment earnings
Increase due to investment earnings
TIF revenue canceled
Increase due to bond proceeds
RISE Grant Appropriation
Increase due to additional RISE
Increase due to bond interest
Increase due to land sales
Add'I bond proceeds
Amend to actual
Amend to actual
Amend to actual
Cancel Port of Dub CIP#3602156
Cancel Design S. Siegert CIP #3602160
Cancel Design S. Siegert CIP #3602160
Increased invest earnings & reimburse
Record actual investment earnings
Record actual reimbursements
FY09 Add'1 Bond proceeds
Adjust to actual Grant Contract
Adjust to actual Grant Contract
Adjust to actual Grant Contract
Adjust to actual Grant Contract
Adjust to actual Grant Contract
Adjust to actual Grant Contract
Grant Appropriation
Grant Appropriation
Correct funding source
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Department Description
DEBT SERVICE FUND
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Debt Service
Engineering
Engineering
Engineering
Engineering
Engineering
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
GO Bond Proceeds
TOTAL DEBT SERVICE FUND
REFUSE FIJND
Public Works Duel Packer Recycle Vehicle - Equipment Acquisition
TOTAL REFUSE FUND
AMERICA'S RIVER PROJECT FUND
Mississippi Riverwalk - Private Participant
Mississippi Riverwalk - Misc Operating Supplies
Art in Port of Dubuque - Misc Revenue
Art in Port of Dubuque - Misc Services
Ice Harbor Additional Parking Lots - Construction
TOTAL AMERICA'S RIVER PROJECT FUND
SANITARY SEWER CONSTRUCTION FUND
Water Pollution ( Perry Street Pumping Station - Consulting Engineers
Water Pollution 1 Standby Generator for Catfish Creek Pumping Station
Water Pollution 1 WPC Plant Facility Study - SRF GO Bond Proceeds
Water Pollution 1 Annexation Study/Implementation - GO Bond Proceeds
Water Pollution 1 Annexation Middle Road - GO Bond Proceeds
Water Pollution 1 Sewer Extensions New Development - GO Bond Proceeds
Water Pollution ( Southfork Interceptor Sewer - GO Bond Proceeds
Water Pollution 1 Warehouse Sanitary Sewer - GO Bond Proceeds
Engineering General Sanitary Sewer Repairs - Const Not Bldg
Engineering Sewer Clearing /Grubbing - Const Not Bldg
Engineering Flow Monitoring - Full -Time Employees
Engineering I &I Reduction Program - Const Not Bldg
Engineering South Fork Sanitary Sewer - Full -Time Employees
Engineering South Fork Interceptor Sewer - Consulting Engineers
Engineering Miller Road Sanitary Sewer - Full -Time Employees
Engineering South Fork Interceptor Sewer - Consulting Engineers
FY 10
Expense
Amount
(422,526)
(422,526)
(72,252)
3,500
(48,300)
(117,052)
8,500
100,000
12,362
(12,362)
595
(595)
149
(149)
1,736
(1,736)
Page 8
FY 10
Revenue
Amount
7,390
600,000
6,546
644,993
(1,859,003)
375
1,239
32,439
25,465
(3,453,235)
(7,110,446)
(3,093,000)
(13,070,050)
(2,378,420)
(1,041,995)
(5,784,356)
(36,472,058)
(68,752)
13,070,050
1,498,000
433,000
212,420
125,000
110,000
Fund Activity/CIP Account Explanation
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54210 Bond Proceeds for CIP #3601943
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54210 Adjust to actual bond proceeds
440 44010440 54230 Amend bonds directly in projects
440 44010440 54210 Amend bonds directly in projects
440 44010440 54210 Amend bonds directly in projects
440 44010440 54230 Amend bonds directly in projects
440 44010440 54210 Amend bonds directly in projects
440 44010440 54210 Move Bond proceeds to projects
440 44010440 54210 Move Bond proceeds to projects
670 6701533 73410 Amend out truck purchases
(72,252) 700 7001054 53102
700 7001054 62761
3,500 700 7001853 53605
700 7001853 62731
700 7001513 73211
710 7102212 62712
710 7102149 73211
710 7101837 54230
710 7101012 54210
710 7101641 54210
710 7101350 54210
710 7101899 54210
710 7102129 54210
710 7101289 73211
710 7101636 73211
710 7101295 61010
710 7101294 73211
710 7101299 61010
710 7101899 62712
710 7101311 61010
710 7101899 62712
Obligation fulfilled by Chamber
Obligation fulfilled by Chamber
Record mist revenue received
Increase appropriation
Cancel Encumbrance
Move from FY11 to Fy10
Move from FY11 to Fy10
Amend bonds directly in projects
Amend bonds directly in projects
Amend bonds directly in projects
Amend bonds directly in projects
Amend bonds directly in projects
Amend bonds directly in projects
Shift from Sewer Clearing #7101636
Shift to Gen Sanitary Sewer #7101289
Shift from I &I Reduction #7101294
Shift to Flow Monitoring #7101295
Shift from South Fork lnt #7101899
Shift to South Fork San Sew #7101299
Shift from South Fork Int #7101899
Shift to Miller Rd San Sew #7101311
Department
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Description
Oak Grove Sanitary Sewer - Const Not Bldg
Sewer Clearing/Grubbing - Const Not Bldg
Sanitary Sewer Lining Program - Const Not Bldg
Quince Street Sewer Reconstruction - Const Not Bldg
Comp Sanitary Sewer Masterplan - Full -Time Employees
I &I Reduction Program - Const Not Bldg
Catfish Interceptor Recon -Sec 3 - Full -Time Employees
South Fork Interceptor Sewer - Consulting Engineers
Ramp Utility Relocate - Sanitary - Const Not Building
Sanitary Sewer Extension - New Developments
TOTAL SANITARY SEWER CONST FUND
STORM WATER CONSTRUCTION FUND
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
General Repairs - Const Not Bldg
Clifford & Lagen Storm - Const Not Bldg
West 32nd Street Detention - Const Not Bldg
Clifford & Lagen Storm - Const Not Bldg
Keyway/Penn Storm Sewer Improv - Full -Time Employees
Keyway Channel & Culvert Improv - Eng Division Services
Kerper Storm Sewer Extension - Const Not Bldg
Clifford & Lagen Storm - Const Not Bldg
32nd & Grandview Storm Improv - Full -Time Employees
Clifford & Lagen Storm - Const Not Bldg
NPDES - Erosion Control - Eng Division Services
Clifford & Lagen Storm - Const Not Bldg
NPDES - Municipal Operation - Consultant Services
Clifford & Lagen Storm - Const Not Bldg
Bee Branch Creek Restoration - Const Not Bldg
Sewer Pipeline Inspection Equipment - Equip Acquisition
Iowa Street Storm Construction - Const Not Bldg
Kane/Kaufmann Storm Sewer Const - Const Not Bldg
Peru Road Storm Construction - Const Not Bldg
Flood Control Levee Cert - Consulting Engineers
Bee Branch Creek Restoration - GO Bond Proceeds
Rosemont/NW Arterial Channel - GO Bond Proceeds
Warehouse Storm Sewer - GO Bond Proceeds
Foye Storm Sewer Program - GO Bond Proceeds
1-I & W Storm Sewer - GO Bond Proceeds
Keyway Channel & Culvert Improv - State Stimulus Grant
Rosemont Culvert Improvements - Engineering Div Services
Rosemont Culvert Improvements - Construction Not Bldg
Pennsylvania/JFK Culvert Improv - Construction Not Bldg
Keyway to Rosemont - Construction Not Bldg
Rosemont to NW Arterial - Construction Not Bldg
Keyway Channel & Culvert Improv - Construction Not Bldg
Keyway to Rosemont - SRF Borrowing
Rosemont to NW Arterial - GO Borrowing
TOTAL STORM WATER CONST FUND
FY 10
Expense
Amount
9,867
(9,867)
418
(418)
873
(873)
73
(73)
307,351
(307,351)
108,500
23,237
(23,237)
121,320
(121,320)
1,822
(1,822)
172
(172)
39,919
(39,919)
1,124
(1,124)
6,668
(6,668)
18,649
1,249
870
3,781
344
572
(12,000)
(70,209)
(151,525)
(195,388)
(150,477)
(89,868)
(644,002) 10,277,210
Page 9
FY 10
Revenue
Amount
15,448,470
Fund Activity/CIP Account
710 7101344 73211
710 7101636 73211
710 7101637 73211
710 7101903 73211
710 7101644 61010
710 7101294 73211
710 7101803 61010
710 7101899 62712
710 7102261 73211
710 7101350 73510
720 7201066 73211
720 7201368 73211
720 7201357 73211
720 7201368 73211
720 7201658 61010
720 7201662 62811
720 7201806 73211
720 7201368 73211
720 7201808 61010
720 7201368 73211
720 7202062 62811
720 7201368 73211
720 7202064 62716
720 7201368 73211
720 7201654 73211
720 7201840 73410
720 7202132 73211
720 7202133 73211
720 7202134 73211
720 7202155 62712
10,179,954 720 7201654 54210
150,477 720 7202018 54210
115,250 720 7202131 54210
63,000 720 7202019 54210
55,000 720 7202017 54210
183,402 720 7201662 45790
720 7201911 62811
720 7201911 73211
720 7201655 73211
720 7201807 73211
720 7202018 73211
720 7201662 73211
(319,396) 720 7201807 54230
(150,477) 720 7202018 54210
Explanation
Shift from Sewer Clearing #7101636
Shift to Oak Grove San Sew #7101344
Shift from Quince St Sewer #7101903
Shift to San Sew Lining #7101637
Shift from I &I Reduction #7101294
Shift to San Sew Master #7101644
Shift from South Fork Int #7101899
Shift to Catfish Inter CIP #7101803
New Appropriation
Shift to Ramp Utility Relocate
Shift from Clifford CIP #7201368
Shift to General Repairs CIP#7201066
Shift from Clifford CIP #7201368
Shift to W 32nd Detent CIP #7201357
Shift from Keyway Channel #7201662
Shift to Keyway Storm CIP #7201658
Shift from Clifford CIP #7201368
Shift to Kerper Storm CIP #7201806
Shift from Clifford CIP #7201368
Shift to 32nd & Grand Storm #7201808
Shift from Clifford CIP #7201368
Shift to NPDES Erosion CIP #7202062
Shift from Clifford CIP #7201368
Shift to NPDES Municipal #7202064
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Adjust to actual bond proceeds
Amend bonds directly in projects
Amend bonds directly in projects
Amend bonds directly in projects
Amend bonds directly in projects
Amend bonds directly in projects
New Grant
Reduce to Actual
Reduce to Actual
Reduce to Actual
Reduce to Actual
Reduce to Actual
Reduce to Actual
Reduce to Actual
Reduce to Actual
Department Description
PARKING CONSTRUCTION FUND
Parking Division Downtown Ramp - 10th & Central - EDA Capital
Parking Division Downtown Ramp - 5th & Bluff - State Grant
Parking Division Downtown Ramp - 5th & Bluff - Consulting Engineers
Parking Division Downtown Ramp - 5th & Bluff - Const. Cont. Not Bldg
Parking Division Downtown Ramp - 10th & Central - Consultant Services
Parking Division Downtown Ramp - 10th & Central - Const. Cont. Bldg
Parking Division Locust Office Remodel - Construction Contract
TOTAL PARKING CONSTRUCTION FUND
WATER CONSTRUCTION FUND
Water Departmei Bunker Hill Pump Station - Const Not Bldg
Water Departmei Ramp Water Utility Relocate - Const Not Bldg
Water Departmei Undistributed - Water - Pay to Other Agency
Water Departmei Water Meter Replacement Program - SRF GO Bond Proceeds
Water Departmei Annexation Study /Implementation - GO Bond Proceeds
Water Departmei Annexation Study - Phase 11- GO Bond Proceeds
Water Departmei Water Main Replacements - GO Bond Proceeds
Water Departmei ADA Improvements Water PI - GO Bond Proceeds
Water Departmei Vacuum Filter Back -Up - GO Bond Proceeds
Water Departmei Roosevelt Road Main Extension - GO Bond Proceeds
TOTAL WATER CONSTRUCTION FUND
GRAND TOTAL AMENDMENT #2
TRANSFERS
Fire Department Transfer from GO Bond Fund to General Fund
Fire Department Transfer from GO Bond Fund to General Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Departmei Transfer from Bond Proceeds to Water Const Fund
Water Pollution
Water Pollution
Water Pollution
Water Pollution
Water Pollution
Water Pollution
Water Pollution
Transfer from Bond Proceeds to Sanitary Sewer Const Fund
I Transfer from Bond Proceeds to Sanitary Sewer Const Fund
1 Transfer from Bond Proceeds to Sanitary Sewer Const Fund
1 Transfer from Bond Proceeds to Sanitary Sewer Const Fund
I Transfer from Bond Proceeds to Sanitary Sewer Const Fund
I Transfer from Bond Proceeds to Sanitary Sewer Const Fund
I Transfer from Bond Proceeds to Sanitary Sewer Const Fund
Parking Division Transfer from Bond Proceeds to 5th & Bluff Ramp
FY 10
Expense
Amount
(2,168,685)
(17,717,040)
595,439
9,967,286
46,851
(9,276,149)
(150,000)
150,000
500,000
500,000
(9,115,280)
Transfer Out
32,439 100 1001016 59440 Transfer Funds
32,439 440 44010440 91100 Transfer Funds
(3,093,000)
(15,448,470)
Page 10
FY 10
Revenue
Amount
1,500,000
(8,963,997)
(7,463,997)
2,000,000
655,000
200,000
155,000
30,000
28,000
25,000
3,093,000
(9,304,308)
Transfer In
Fund Activity /CIP Account Explanation
730
730
730
730
730
730
730
740
740
740
740
740
740
740
740
740
740
7302179
7302168
7302168
7302168
7302179
7302179
7302170
7401422
7402261
74010740
7402052
7401954
7402146
7401405
7401402
7402030
7401672
(2,000,000) 740 7402052 59440
(655,000) 740 7401954 59440
(200,000) 740 7402146 59440
(155,000) 740 7401405 59440
(30,000) 740 7401402 59440
(28,000) 740 7402030 59440
(25,000) 740 7401672 59440
440 44010440 91740
(13,070,050) 710 7101837 59440
(1,498,000) 710 7101012 59440
(433,000) 710 7101641 59440
(212,420) 710 7101350 59440
(125,000) 710 7101899 59440
(110,000) 710 7102129 59440
440 44010440 91710
44115 Grant Appropriation
45701 Adjust to actual
62712 Adjust to actual
73211 Adjust to actual
62716 Adjust to actual
73210 Adjust to actual
73210 Moved from Meter Replacement
73210 Move to Ramp Utility Relocate
73211 Move from Bunker Hill Pump Station
62761 Water Conservation Payment
54230 Amend bonds directly in projects
54210 Amend bonds directly in projects
54210 Amend bonds directly in projects
54210 Amend bonds directly in projects
54210 Amend bonds directly in projects
54210 Amend bonds directly in projects
54210 Amend bonds directly in projects
(11,169,003) 730 7302168 59440 Transfer Funds
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Department Description
Parking Division Transfer to Bond Proceeds from 5th & Bluff Ramp
Parking Division Transfer from Bond Proceeds to 10th & Central Ramp
Parking Division Transfer from Bond Proceeds to 5th & Bluff Ramp
Parking Division Transfer to 5th & Bluff Ramp and 10th & Central Ramp
Airport Departm Transfer from Passenger Facility to Airport Construction
Airport Departm Transfer from Passenger Facility to Airport Construction
Airport Departm Transfer from GO Bond Fund to Airport Construction
Airport Departm Transfer from GO Bond Fund to Airport Construction
Airport Departm. Transfer from GO Bond Fund to Airport Construction
Airport Departm Transfer from GO Bond Fund to Airport Construction
Airport Departm Transfer from GO Bond Fund to Airport Construction
Airport Departm Transfer from GO Bond Fund to Airport Construction
Airport Departm Transfer from GO Bond Fund to Airport Construction
Airport Departm Transfer from GO Bond Fund to Airport Construction
Public Works
Public Works
Transfer from Warning Flashers CIP to Street Sweeper CIP
Transfer to Street Sweeper CIP from Warning Flashers CIP
Public Works Transfer to General Fund CIP to Sales Tax Fund CIP
Public Works Transfer from Sales Tax Fund CIP to General Fund CIP
Engineering Transfer from GO Bond Fund to Street Construction
Engineering Transfer from GO Bond Fund to Street Construction 375
Engineering Transfer from GO Bond Fund to Road Use Tax Fund
Engineering Transfer from GO Bond Fund to Road Use Tax Fund 1,239
Engineering Transfer from GO Bond Fund to Storm Water Const Fund
Engineering Transfer from GO Bond Fund to Storm Water Const Fund
Engineering Transfer from GO Bond Fund to Storm Water Const Fund
FY 10 FY 10
Expense Revenue
Amount Amount
(11,169,003)
Fund Activity/CIP Account Explanation
440 44010440 91730 Transfer Funds
9,062,725 730 7302179 59440 Transfer Funds
247,275 730 7302168 59440 Transfer Funds
9,310,000 440 44010440 91730 Transfer Funds
26,050 390 3901892 59391 Transfer Funds
26,050 391 39110391 91390 Transfer Funds
664 390 3902124 59440 Transfer Funds
742 390 3902123 59440 Transfer Funds
1,518 390 3902126 59440 Transfer Funds
1,518 390 3902128 59440 Transfer Funds
1,707 390 3902007 59440 Transfer Funds
979 390 3902008 59440 Transfer Funds
262 390 3902125 59440 Transfer Funds
7,390 440 44010440 91390 Transfer Funds
10,510 300 30010300 91250 Transfer Funds
10.510 250 2501209 59300 Transfer Funds
28,228 350 35010350 91100 Transfer Funds
28,228 100 1002042 59350 Transfer Funds
Public Works Transfer from Special Assessment to Street Const Fund 114.053 255 25510255 91300 Transfer Funds
Public Works Transfer to Street Const Fund from Special Assessment 114,053 300 3001972 59255 Transfer Funds
Public Works Transfer from GO Bond Fund to General Fund 6,546 440 44010440 91400 Transfer Funds - Proceeds from refund
Public Works Transfer from GO Bond Fund to General Fund 6,546 400 40054400 59440 Transfer Funds - Proceeds from refund
Engineering Transfer from Sales Tax Fund to General Construction Fund 10,221 350 35010350 91360 Transfer Funds
Engineering Transfer from General Construction Fund to Sales Tax Fund 10,221 360 3602136 59350 Transfer Funds
Engineering Transfer to General Fund from Expendable Library Gifts 41.027 100 1001141 59295 Transfer Funds
Engineering Transfer from Expendable Library Gifts to General Fund 41,027 295 29536480 91100 Transfer Funds
Engineering Transfer from Sales Tax Fund to Storm Water Const Fund 12,747 350 35010350 91720 Transfer Funds - For previous year
Engineering Transfer from Sales Tax Fund to Storm Water Const Fund 12,747 720 7201806 59350 Transfer Funds - For previous year
Page 11
375 300 3001549 59440 Transfer Funds
440 44010440 91300 Transfer Funds
1,239 250 2501017 59440 Transfer Funds
440 44010440 91250 Transfer Funds
18,649 720 7201654 59440 Transfer Funds
1,249 720 7201840 59440 Transfer Funds
870 720 7202132 59440 Transfer Funds
Department
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Engineering
Economic Develi
Economic Develt
Economic Dever
Economic Dever
Economic Dever
Economic Develi
Economic Dever
Economic Develt
Economic Dever
Economic Dever
Description
Transfer from GO Bond Fund to Storm Water Const Fund
Transfer from GO Bond Fund to Storm Water Const Fund
Transfer from GO Bond Fund to Storm Water Const Fund
Transfer from GO Bond Fund to Storm Water Const Fund
Transfer from Bond Proceeds to Storm Water Const Fund
Transfer from Bond Proceeds to Storm Water Const Fund
Transfer from Bond Proceeds to Storm Water Const Fund
Transfer from Bond Proceeds to Storm Water Const Fund
Transfer from Bond Proceeds to Storm Water Const Fund
Transfer from Bond Proceeds to Storm Water Const Fund
Transfer from Special Assessment to General Const Fund
Transfer from Special Assessment to General Const Fund
Transfer from Special Assessment to General Const Fund
Transfer from Special Assessment to General 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 Spec Assessments to Sanitary Sewer
Transfer from Spec Assessments to Sanitary Sewer
Transfer from DRA Distrib to General Construction
Transfer from General to General Construction
Transfer from Road Use Tax Fund to Street Construction
Transfer from Road Use Tax Fund to Street Construction
Transfer to General Construction from Tech Park South
Transfer to General Construction from Tech Park South
Transfer to GDTIF Loan Pool from Greater Downtown TIF
Transfer to GDTIF Loan Pool from Greater Downtown TIF
Transfer from GO Bond Fund to General Construction Fund
Transfer from GO Bond Fund to General Construction Fund
Remove trans from DICW to General Const
Remove trans from DICW to General Const
Transfer from TIF Downtown to DICW
Transfer from TIF Downtown to DICW
FY 10
Expense
Amount
25,465
(10,563,681)
(30,000)
(30,000)
(1,041,995)
(317,546)
366,813
(100,000)
300,000
Page 12
FY 10
Revenue
Amount
3,781
344
572
(10,179,954)
(150,477)
(115,250)
(63,000)
(55,000)
Fund Activity/CIP Account
720 7202133 59440
720 7202134 59440
720 7202155 59440
440 44010440 91720
720 7201654 59440
720 7202018 59440
720 7202131 59440
720 7202019 59440
720 7202017 59440
440 44010440 91720
Explanation
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds
(30,000) 360 3602020 59255 Transfer Funds
255 25510255 91360 Transfer Funds
(30,000) 360 3602137 59255 Transfer Funds
255 25510255 91360 Transfer Funds
(340,000) 360 3602137 59440
(301,995) 360 3602020 59440
(300,000) 360 3602136 59440
(100,000) 360 3602135 59440
440 44010440 91360
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds
(317,546) 710 7101638 59255 Reduce to Actual
255 25510255 91710 Reduce to Actual
(91,014) 360 3601976 59102 Transfer Funds
91,014 360 3601976 59101 Transfer Funds
366,813 300 3001287 59250 Transfer Funds
250 25010250 91300 Transfer Funds
225 22560225 91360 Transfer Funds
(100,000) 360 3601842 59225 Transfer Funds
240 24060240 91241 Transfer Funds
300,000 241 241033 59240 Transfer Funds
644,993 360 3601943 59440 Transfer Funds
644,993 440 44010440 91360 Transfer Funds
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
Transfer Funds - Directly to projects
(142,000) 360 3601943 59210 Transfer Funds - remove
(142,000) 210 21060210 91360 Transfer Funds - remove
175,352 210 21060210 59240 Transfer Funds - correct debt pymt
175,352 240 24060240 91210 Transfer Funds - correct debt pymt
Department Description
Economic Dever Transfer from Bond Proceeds to General Construction Fund
Economic Develi Transfer from Bond Proceeds to General Construction Fund
Economic Dever Transfer from Bond Proceeds to General Construction Fund
Economic Devell Transfer from Bond Proceeds to General Construction Fund
Economic Devell Transfer from Bond Proceeds to General Construction Fund
Economic Develi Transfer from Bond Proceeds to General Construction Fund
Economic Dever Transfer from Kerper TIF to General Fund
Economic Dever Transfer from Kerper TIF to General Fund
Planning Service Transfer from DRA Distrib to General Fund
Planning Service Transfer from DRA Distrib to General Fund
City Manager Transfer from Water Fund to General Fund- 30% Stim Coord
City Manager Transfer from Water Fund to General Fund- 30% Stim Coord
City Manager Transfer from Sewer Fund to General Fund- 25% Stim Coord
City Manager Transfer from Sewer Fund to General Fund- 25% Stim Coord
City Manager Transfer from Refuse Fund to General Fund- 5% Stim Coord
City Manager Transfer from Refuse Fund to General Fund- 5% Stim Coord
City Manager
City Manager
City Manager
City Manager
Transfer from Parking Fund to General Fund- 25% Stim Coord
Transfer from Parking Fund to General Fund- 25% Stim Coord
Transfer from Landfill Fund to General Fund- 10% Stim Coord
Transfer from Landfill Fund to General Fund- 10% Stim Coord
TOTAL TRANSFERS
FY 10
Expense
Amount
600,000
FY 10
Revenue
Amount
600,000
Fund Activity/CIP Account Explanation
360 3601943 59440 Transfer Funds
440 44010440 91360 Transfer Funds
(1,000,000) 360 3602156 59440
(1,078,021) 360 3602159 59440
(3,706,335) 360 3602160 59440
(5.784,356) 440 44010440 91360
223,048 232 23260232 91100 Repayment of On -Site Improvements
223,048 100 10010100 59232 Repayment of On -Site Improvements
22,667 102 10210102 91100 Transfer Funds
22,667 100 1002169 59102 Transfer Funds
9,572 640 64010640 91100 Transfer Funds
9,572 100 10010100 59640 Transfer Funds
7,976 610 61010610 91100 Transfer Funds
7,976 100 10010100 59610 Transfer Funds
1,595 670 67054100 91100 Transfer Funds
1,595 100 10010100 59670 Transfer Funds
7,976 630 63010630 91100
7,976 100 10010100 59630
3,191 940 94054200 91100
3,191 100 10010100 59940
(35,730,578) (35,730,578)
(44,845,858) (45,034,886)
Page 13
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds
Transfer Funds