City Street Financial Report FY 2015 Copyright 2014
City of Dubuque Consent Items # 24.
ITEM TITLE: City Street Financing Report for Fiscal Year 2015
SUMMARY: City Manager recommending approval of the City of Dubuque's Fiscal
Year 2015 City Street Financing Report and authorize filing with the Iowa
Department of Transportation.
RESOLUTION Approving the City of Dubuque Fiscal Year 2015 City
Street Financing Report
SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt Resolution(s)
ATTACHMENTS:
Description Type
❑ FY15 City Street Financing Report-MVM Memo City Manager Memo
❑ Fiscal Year 2015 City Street Financing Report Staff Memo
❑ Resolution Resolutions
❑ Street Financial Report Supporting Documentation
THE CITY OF Dubuque
UBE I
erica .i
Masterpiece on the Mississippi 2007-2012-2013
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: Fiscal Year 2015 City Street Financing Report
DATE: August 31, 2015
Finance Director Ken TeKippe recommends City Council approval of the City of
Dubuque's Fiscal Year 2015 City Street Financing Report and authorize filing with the
Iowa Department of Transportation.
I concur with the recommendation and respectfully request Mayor and City Council
approval.
Mic ael C. Van Milligen
MCVM:jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Teri Goodmann, Assistant City Manager
Ken TeKippe, Finance Director
THE CF � Dubuque
DUtB
EAll-AmedcaCity
.Masterpiece on the,Mississippi
2007
TO: Mike Van Milligen, City Manager
FROM: Ken TeKippe, Finance Director
SUBJECT: Fiscal Year 2015 City Street Financing Report.
DATE: August 31, 2015
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution
approving the City of Dubuque's Fiscal Year 2015 City Street Financing Report.
DISCUSSION
The Code of Iowa, Chapter 312, Section 14, provides for the submission of an annual
City Street Finance Report to the Iowa Department of Transportation by September 30,
2015. Failure of the City to submit this report on a timely basis results in the State l
withholding Road Use Tax Funds allocated to the City until compliance is achieved.
RECOMMONDATION
recommend adoption of the enclosed resolution approving the attached annual report
and authorize filing with the Iowa Department of Transportation.
i
ACTION TO BE TAKEN
The City Council is requested to adopt the attached resolution approving the City Street
Finance Report for Fiscal Year 2015.
cc: Gus Psihoyos, City Engineer
Jenny Larson, Budget Director
RESOLUTION NO. 300-15
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2015 CITY STREET
FINANCING REPORT
NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF
DUBQUE, IOWA:
Section 1. That the City Street Finance Report for the period of July 1, 2014, to June
30, 2015, is hereby approved and that the City Clerk is hereby authorized and directed
to file said report with the Iowa Department of Transportation.
Passed, approved and adopted this 8th day of September, 20
Attest:
Kevin S. Firnstahl, Cit Clerk
Q XL,
Roy D. Buol, Mayor
,IOWA®®'T
For517007(5-2014} City Street Financial Report
m
Office of Local Systems
Ames,IA 50010
City Name City Number Fiscal Year
DUBUQUE 2 t 00 2015
Welcome Page!
Welcome to the Iowa Department of Transportation,Office of Local Systems,City Street Financial Report(SFR)
Complete the City SFR according to the instructions that are available on the Iowa DOT SFR website located here.
Please direct all questions,comments,and feedback about the City SFR and the on-line process,to:Tammi Bell at tammi.bell@dot.iowa.gov,515-239-1529.
Thank you for using the City SFR on-line process.
I
i
i
I
i
r
I
I
i
i
i
& DDT
Form 517007 {5-2014}
Office of Local Systems
Ames, IA 50010
City Name
Cit/ Number
DUBUQUE
2100
Contact Information
City Street Financial Report
Cover Sheet
Now therefore let it be resolved that the city council of DUBUQUE , Iowa
(city name)
on 09/07/2015 did hereby approve and adopt the annual
(month/day/year)
City Street Financial Report from July 1,
2014
(year)
to June 30, 2015
(year)
Fiscal Year
2015
Name
E-mail Address; _, `
Street Address ,
City: ',
ZIPS Code
Kevin Firnstahl
lcfirnsta@cityofdubuque.org
50 West 13th Street
Dubuque, IA
52001-4864
171014-r. :;1',.
Phone
Extension ;".: F'
Alternate Phone, ,
8:00 AM - 5:00 PM
(563) 589-4121
(563) 556-0418
Preparer Information
Name,
E-mail Address
Phone
Extension
Jean M. Nachtman
jnachtma@cityofdubuque.org
(563) 589-4141
Mayor Information
Name
E-mail Address
Street Address
City
ZIP Code
Roy D. Buol
rbuol@cityofdubuque.org
50 West 13th Street
Dubuque, IA
52001-4864
Phone
Extension
(563) 589-4121
Resolution Number
Sigrtatur-'Mayor- Clerk
300-15
Sig iature City C1eck- Mayor
�,1 DOT City Street Financial Report
Form 517007 f5-2014}
Office of Local Systems
Ames,IA 50010
City Name City Number Fiscal Year
DUBUQUE 2100 2015
Summary Statement Sheet
Column 1 Column 2 Column 3 Column 4 Column 1 Column 2 Column 3 Column 4
Road Use Other Street Street Debt Totals Road Use Other Street Street Debt Totals
Tax Fund Monies Tax Fund Monies
Round Figures to Nearest Dollar Round Figures to Nearest Dollar
A.BEGINNING BALANCE EXPENSES`
1.July,l Balance 1,029,979 0 0 1;029,979 D.Maintenance
2.Adjustments 1.Roadway Maintenance 3,436,627 3,436,627
(Note on Explanation Sheet) 2.Snow and Ice Removal 1,783,9701 1 1 1,783,970
3.Adjusted Balance 1,029,979 0 0 1,029,9791 E.Construction,Reconstruction and Improvements
B.REVENUES 1.Engineering 89,808 2,242,223 2,332,031
1.Road Use Tax 5,993,239 5,993,239 2,Right of Way Purchased 0 0
2.Transfer of 3.Street/Bridge Construction 19,064 2,342,223 2,361,287
Jurisdictions Fund 4.Traffic Services 6,606 1,042,799 1,049,405
3.Property Taxes 590,509 590,509 F.Administration 213,332 757,876 971,208
4.Special Assessments 146,142 146,142
t i
Equpmen
5.Miscellaneous 6,953,627 6,953,627 G. F152,5T97797,608 950,205
6.Proceeds from Bonds, (Purchased or Leased)
Notes,and Loans 0 H.Miscellaneous
7.Interest Earned` 34,319 34,319 J Street Debt
8.Total Revenues .1Bonds,Notes,and Loans-
5,993,239 7,724,597 13,717,836 345778 363,622 398,400
(Lines B1 thru B7) Principal Paid
C.Total Funds Available 7,023,218 7,724,597 0 14,747,815 2•Bonds,Notes and Loans- 24,114 178,246 202,360
(Line A3+Line B8) Interest Paid
TOTALS
K.Total Expenses 5,760,896 7,724,597 13,485,493
(Lines D thru J)
L.Ending Balance
(Line C-K) 1,262,322 0 0 1,262,322
M.Total Funds Accounted 7,023,218 7,724,597 0 14,747,815
For(K+L=C)
OADO1
Form 517007{5-2014} City Street Financial Report
Office of Local Systems
Ames,IA 50010
City Name City Number Fiscal Year
DUBUQUE 2100 2015
Bonds, Notes and Loans Sheet
New DOT ° Principal Total Principal
Issue Issue /o Related Year Total Principal Interest
Bond Debt Type Debt Purpose Use Date Amount to Street Due Balance as Principal Interest Paid Roads Roads Balance as
? Only of 7/1 or after Paid of 6/30
General Obligation Paving&Construction 304 09/01/2011 6,330,000 16% 2031 5,805,000 265,000 192,780 42,400 30,844 5,540,000
❑ General Obligation Paving&Construction 305 03/15/2012 7,495,000 74% 2031 7,075,000 350,000 174,425 259,000 129,074 6,725,000
❑ General Obligation Paving&Construction 306 08/30/2010 4,470,000 12% 2030 3,780,000 225,0001 119,1881 27,0001 14,3021 3,555,000
❑ General Obligation Paving&Construction 307 12/19/2012 3,640,000 35% 2032 1 3,445,000 200,000 80,400 70,000 28,140 3,245,000
New Bond Totals 0 0 Totals 1 20,105,000 1,040,0001 566,7931 398,4001 202,3601 19,065,000
j
I
I
�, dAiADOT
Form 517007{5-2014} City Street Financial Report
F
Office of Local Systems
Ames,IA 50010
City Name City Number Fiscal Year
DUBUQUE 1 2100 2015
Project Final Costs Sheet
For construction,reconstruction,and improvement projects with costs equal to or greater than 90%of the bid threshold in effect as the beginning of the fiscal year.
Section A Check here if there are no entries for this year❑
Line 1. 2, 3. 4, 5,
No. Project Number Estimated Cost Project Type Public Letting? Location/Project Description(limits,length,size of structure);
1 9th and 1 I th One 1 856,245 Roadside Construction Yes This project involved the conversion of the following streets from one way to two in
2 SRF Green Alley Pfi 325,334 Roadside Construction Yes Three alleys-Johnson Street to Windsor Avenue(Between Providence Street and b
3 SRF Green Alley 16 232,416 Roadside Construction Yes Four alleys-Alleys between Prince&Queen Streets from 22nd Street to 24th Stre�
4 SRF Green Alley F 767,622 Roadside Construction Yes Nine alleys-Johnson Street to Marshall Street(Between Rhomberg Avenue and Lin
5 SRF Green Alley lA 192,963 Roadside Construction Yes Two alleys-Marshall Street to Hamilton Street(Between Rhomberg Avenue and q3
6 SRF Green Alley 1h 111,105 Roadside Construction Yes Two alleys-Alley from 24th St.to 25th St.(between Central Avenue and White SID
Section B
Contract Work City Labor
1. 6. 7. 8. 9. 10, 11. 12. 13.
Line Project Number Contractor Name Contract Additions/ Labor Equipment Materials Overhead Total
No. Price_ Deductions
1 9th and 11th One W;Portzen Construction 797,011 16,517 813,528
2 SRF Green Alley Big East Iowa Construction 280,208 -6,380_._ 273,828
3 SRF Green Alley bic Drew Cook and Sons Construction 189,683 -9,755 179,928
4 SRF Green Alley Bi Drew Cook and Sons Excavating 590,557 -48,170 542,387
5 SRF Green Alley Bi,Drew Cook and Sons Excavating 162,947 -20,092 142,855
6 SRF Green Alley bic Drew Cook and Sons Excavating 139,475 -1,433 138,042
�11BUA®®'T City Street Financial Report
Form 517007{5-2014}
Office of Local Systems
Ames,IA 50010
City Name I City Number Fiscal Year
DUBUQUE 1 2100 2015
Road/Street Equipment Inventory Sheet
Check here if there are no reportable equipment❑
1 2. 3. 4 5. 6. 7. 8:
Local Class Model Description Purchase Lease /Unit Rental /Unit Used on Project Status
I.D.# Year Cost Cost Cost this FY?
4034 2009 JD Skid loader 32,058 No No Change
2730 2009 Sewer Easement Machine 38,783 No No Change
3298 2008 B&B Trailer 5,585 No No Change
3230 .2007 Ford F550 Crew Cab 91,809 No No Change
3241 2006 International 36,411 No No Change
3236 2007 Intemational 4200 101,728 No No Change
3213 2007 John Deere Backhoe Loader 67,754 No No Change
3208 2006 International 7400 36,411 No No Change
3206 2006 International 7400 36,411 No No Change
3203 2008 7400 4X2 Dump Truck 94,382 No No Change
3102 2007 Chevrolet Silverado 25,666 No No Change
2704 2007 International 7500 SFA 6X4 194,618 No No Change
2702 2008 Ford F350 31,360 No No Change
2715 2006 Godwin 4"Trash Pump 18,782 No No Change
2701 2008 Ford F350 31,875 No No Change
4006 2010 John Deere Tractor 79,360 No No Change
4008 2010 Elgin Whirlwind Sweeper 177,010 No No Change
3290 2006 John Deere Gator 7,980 No No Change
2705 2009 Chevrolet 3500 Sewer Redder Silverado 76,593 No No Change
2706 1999 CH&S-6"Trash Pump 13,846 No No Change
2710 1998 PECO Manhole Cutter 13,260
No No Change j
2719 1985 Gonnan Rupp 6"Trash Pump 11,595 No No Change
2721 2003 Honda 3"Trash Pump 1,197 No No Change
CJIO ►AD®T City Street Financial Report
Form 517007 t5-20141
Office of Local Systems
Ames,IA 50010
City Name City Number Fiscal Year
DUBUQUE 2100 2015
1 2, 3, 4. . 5.. 6. 7. 8.
Local Class Model Description Purchase Lease /Unit Rental /Unit Used on Project Status
I.D.# Year CostCost Cost this FY?
2711 2007 Ford Hi-Cube Van 2/CCTV Equip 99,000 No No Change
2726 2000 Portable Jet/Root Cutter 8,595 No No Change
2727 2000 Kawasaki Mule 4 Wheeler 7,011 No No Change
3201 2009 Freightliner 35,000 GVW 85,633 No No Change
3202 1998 International W/Rosco Distributor 60,795 No No Change
3204 2008 International 7400 Dump Truck 87,000 No No Change
3209 2009 John Deere endloader 624K 129,292 No No Change
3210 2004 John Deere Backhoe Loader 58,375 No No Change
3215 2001 Caterpillar Vibratory Asphalt Roller 23,390 No No Change
3216 2008 International 7400 Tamdem Dump Truck 108,431 No No Change
3218 2009 Freightliner Bucket Truck 137,049 No No Change
3223-1 1997 Snow Equipment Anti-Icing Unit 8,176 No No Change
3224 2003 Atlas Copco Air Compressor 7,819 No No Change
3227 2008 John Deere Backhoe Loader 71,880 No No Change
3229 1967 International Tractor 7,280 No No Change
3231 2002 Ford F450 4WD 29,585 No INo Change
3225 2005 Dynapae CC122 12 Series 25,842 No No Change
3235 1996 John Deere Wheel Loader 95,672 No No Change
3237 2001 Atlas Copco Air Compressor 7,282 No No Change
3238 1993 Towmnaster Trailer 5,481 No No Change
3240 1998 Target Pro 65 III Concrete Saw 8,927 No No Change
3245 2008 Freightliner Tandem Dump Tract 104,052 No No Change
3247 1990 Cimline Crack Saw 2,381 No No Change
3235 1990 Cimline Crack Saw 3,869 No No Change
3250 2000 John Deere Wheel Loader 118,750 No No Change
3251 1991 Caterpillar Paver-Finisher 24,411 No No Change
X01 WADOT City Street Financial Report
Form 51700715-20141
Office of Local Systems
Ames,IA 50010
City Name I City Number Fiscal Year
DUBUQUE 2100 2015
1. 2. 3., 4. ;5: 6:` 7. 8.
Local Class Model Description' Purchase Lease /Unit Rental /Unit Used on Project Status .
I.D.# Year Cost Cost Cost this FY?
3255 2007 John Deere 6247 Endloader 136,108 No No Change
3256 2008 John Deere Lawn Tractor 19,112 No No Change
3258 1979 Massey Ferguson Tractor 11,500 No No Change
3262 2000 Cimline Crack Sealer 18,931 No No Change
3267 1985 Trailer King Trailer 2,836 No No Change
3272 1991 Ingersoll Rand Roller 3,210 No No Change
3212 2010 International Dump Truck 104,775 No No Change
3270 2009 lHuszvama 30"Pavement Saw 21,970 No No Change
3243 2009 Atlas Copco Air Compressor 10,351 No No Change
3104 2010 Caterpillar Roller 48,575 No No Change
3278 2002 Ingersoll Rand Roller 5,356 No No Change
3279 1996 Melroe Skid-Steer Loader 26,108 No No Change
3280 1993 Honda Generator 1,360 No No Change
3281 1993 Speed Screed 3,327 No No Change
3282 1994 Benning Machine 45200 No No Change
3292 2008 Catepiller 277,632 No No Change
3506 2004 Gorman Rupp 10"Trash Pump 35,720 No No Change
4002 2004 Elgin Pelican Sweeper 93,275 No No Change
4003 1998 International Vac/Flusher Unit 124,756 No No Change
4004 2009 International 56,000 GVW 105,310 No No Change
4103 1998 Sno-Go-Loader Attachment 75,000 No No Change
2731 2009 John Deere Gator 9,550 No No Change
3223 2011 Freightliner w/Henderson Combo Dump Box 119,427 No No Change
3226 2010 John Deere Motor Grader 194,335 No No Change
3214 2010 John Deere Backhoe/Loader 82,318 No No Change
3104 2010 Caterpillar 48,575 No No Change
,10 ADOT City Street Financial Report
Form 51700715-20141
Office of Local Systems
Ames,IA 50010
City Name City Number Fiscal Year
DUBUQUE 2100 2015
1; Z 3. 4. 5. 6. 7. 8.
Local Class Model Description ' Purchase Lease /Unit Rental /Unit Used on Project Status
I.D.# Year Cost Cost Cost this FY?
4113 2011 SNOGO unit-loader mounted 204,000 No No Change
3233 2012 International Tandem Dump Truck 110,675 No No Change
3101 2012 Chevrolet Pickup Truck 29,328 No No Change
3207 2012 International Tandem Dump Truck 110,675 No No Change
3217 2010 John Deere Wheel Loader Forks Attachment 5,433 No No Change
4007 2013 Elgin Pelican P Dual Sweeper 189,459 No No Change
3242 2013 International Dump Truck w/Combo Box 106,699 No No Change
4011 2013 John Deere Lawn Tractor w/snow equipment 14,516 No No Change
3236 2014 Jet Flusher Track/Pipe Cleaner 207,490 No No Change
3205 2013 International 7400 w/combo box 106,699 No No Change
3244 2012 John Deere Wheel Loader-644K 220,000 No No Change
3246 2013 Silverado 4WD 12,000 GVW Dump w/snow Fa 58,695 No No Change
3252 2013 Chevrolet 4WD 12,000 GVW Dump w/snow 58,695 No No Change
4001 2013 International 7400 w/loadal 131,251 No No Change
2708 2014 Tsrumi-6"trash pump 15,794 No No Change
3219 2014 Sullivan D185PJD Air Compressor 9,517 No No Change
4047 2014 H&H Trailer GT20 6,175 No No Change
J1® A®®T City Street Financial Report
Form 517007(5-2014)
Office of Local Systems
Ames,IA 50010
City Name I City Number I Fiscal Year
DUBUQUE 2100 2015
Explanation Sheet
Comments
�101i AD®T City Street Financial Report
Form 517007{5-2014}
Office of Local Systems
Ames,IA 50010
City Name City Number Fiscal Year
DUBUQUE 2100 2015
Monthly Payment Sheet
Month Road Use Transfer of
Tax Payments Jurisdictions Payments
JULY $444,690.31
AUGUST $653,828.32
SEPTEMBER $459,642.52
OCTOBER $638,338.25
NOVEMBER $494,124.38
DECEMBER $432,890.80
JANUARY $517,781.46
FEBRUARY $505,461.86
MARCH $525,220.94
APRIL $414,144.27
MAY $260,421.78
JUNE $646,694.15
Totals $5,993,239.04
Page of
??
Kevin Firnstahl Fwd: \[DUBUQUE\] Your SFR report has been approved
?
From:Kevin Firnstahl
To:Nachtman, Jean
Date:09/10/2015 3:17 PM
Subject:Fwd: \[DUBUQUE\] Your SFR report has been approved
Attachments:SFRDUBUQUE2015.pdf
>>
>>> <LiveCycle@dot.iowa.gov> 9/10/2015 3:16 PM >>>
Your SFR has been approved. Please find in attachment a copy of the SFR you submitted
Click
https://www.mailcontrol.com/sr/VyeivC0SBljGX2PQPOmvUvmldA89nuwl3Gm7HoqZGQPBN7LSFPTehhfBFEQL4hx0zqdlB8oqK3qSPFO0UaI8cQ==
to report this email as spam.
file:///C:/Users/kfirnsta/AppData/Local/Temp/XPgrpwise/55F19F20DBQ_DODBQ_PO1...10/26/2015