City Street Financing Report for Fiscal Year 2016 Copyright 2014
City of Dubuque Consent Items # 15.
ITEM TITLE: City Street Financing Report for Fiscal Year 2016
SUMMARY: City Manager recommending approval of the City of
Dubuque's Fiscal Year 2016 City Street Financing Report.
RESOLUTION Approving the City of Dubuque Fiscal Year
2016 City Street Financing Report
SUGGESTED DISPOSITION: Suggested Disposition: Receive and File; Adopt
Resolution(s)
ATTACHMENTS:
Description Type
FY16 City Street Financing Report-MVM Memo Staff Memo
Street Financing Report Memo Staff Memo
Street Financing Report- FY2016 Supporting Documentation
Street Financing Report Resolution Resolutions
THE CITY OF Dubuque
DUB E 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 2016 City Street Financing Report
DATE: September 14, 2016
Finance Director Jean Nachtman recommends City Council approval of the City of
Dubuque's Fiscal Year 2016 City Street Financing Report.
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
Jean Nachtman, Finance Director
THE CITY OF Dubuque
DUB E A"
Masterpiece on the Mississippi
2007
TO: Mike Van Milligen, City Manager
FROM: Jean Nachtman, Finance Director
SUBJECT: Fiscal Year 2016 City Street Financing Report.
DATE: September 13, 2016
INTRODUCTION
The purpose of this memorandum is to request that the City Council adopt a resolution
approving the City of Dubuque's Fiscal Year 2016 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
withholding Road Use Tax Funds allocated to the City until compliance is achieved.
RECOMMONDATION
I recommend adoption of the enclosed resolution approving the attached annual report
and authorize filing with the Iowa Department of Transportation.
ACTION TO BE TAKEN
The City Council is requested to adopt the attached resolution approving the City Street
Finance Report for Fiscal Year 2016.
cc: Gus Psihoyos, City Engineer
Jenny Larson, Budget Director
RESOLUTION NO. 325-16
APPROVING THE CITY OF DUBUQUE FISCAL YEAR 2016 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, 2015, to June
30, 2016, 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 19th day of September 2016
Attest:
Kevin '. Firnstahl, Cit
Kevin J. Lync h , Mayor Pro Tem
IOWA OT
Form 517007 {5-2016}
Office of Local Systems
Ames, IA 50010
City Name
DUBUQUE
fiber
2100
City Street Financial Report
Cover Sheet
Now therefore let it be resolved that the city council
DUBUQUE , Iowa
(City Name)
On 09/19/2016 did hereby approve and adopt the annual
(month/day/year)
City Street Financial Report from July 1, 2015 to June 30, 2016
(Year)
Contact Information
(Year)
Report Venerated
9/14/2016 9:46 AM
Fiscal Year
2016
Sheet
1 of 12
Natne .., ;. :
Email Address . ,.v, ,, i..,
Street Address ,., yz "., .' , :. v . µ < ..
city _,. .., ._ . -,>..,
ZIP Code`;x
Kevin Firnstahl
kfirnsta@cityofdubuque.org
50 West 13th Street
Dubuque, IA
52001-4864
Hours . w: r..a' Mw..... ;.,
Phone .. f . _ ,
; .
Extension. .. ''.., r ,. r
x . s ' t.it rte- .
Phone(Altenat veti.. z .`
8:00 AM - 5:00 PM
563-589-4121
563-556-0418
Preparer Information
E`-mail'Address , F , , t
Phone «IO..x.
Extension E
Tami L. Lansing
tlansing@cityofdubuque.org
563-589-4133
Mayor Information
E-mail Andre
Street Address' :r}ti
city` T' ` ... ` - 1 .
ZIP Code .21
Roy D. Buol
rbuol@cityofdubuque.org
52001-4864
Dubuque, IA
52001-4864
Phone
Extension r -
563-589-4121
Resolution Number
ea
Signaturetl*layor
Pro—Tem
325-16
0I0WADOT City Street Financial Report
Tom 517007 (5 2016) 9na20169:46 AM
office of Local Systems Thai
Ames, Is, 50010 2016
City Name
Du0up11e 2 of 12
Summary Statement Sheet
Column Column Column Column Column Column Column Column
Road use Other Street Street Debt Totals Road use Other Steeet StreetOebt Totals
Taxruntl Monies Taxruntl Monies
Round Figures to Nearest Dollars Round Figures to Nearest Dollars
A.BEGINNING BALANCE EXPENSES
t . July t Balance 1 $1 ,262322 $o $o $1 ,252322 D. Maintenance
2. Atljustments $o IT $o $0 1. Roatl Way Maintenance $3524 225 $o $o $3,44225
(Note on Explanation 25nowand ice Removal $1 p0.59A6 $o $o $1045046
She
3. Adjusted Balance $1262322 $o $o $1262322 E.Construction, Reconstruction and Improvements
B. REVENUES 1 Engineering $59739 $31316 $o $91 ,115
1 . Road Use Tax $7122738 $7122736 2Right of Way $o $6705063 $o $6705063
Purchased
2. Pmpeny Taxes $9615726 $0 $9615726 3. Street/Bridge $182056 $7731069 $o $1,975125
3. Special $183040 $o $183070 Construction
Assessments
ATafim Services $386575 $21 ,473 $o $408,048
4. Miscellaneous $6,859,024 $o $6859,024 F. Administration $213362 $38196 $o $251558
5. Pmcemsfmm $o $o $o G. Equipment $207160 $1559,071 $o $1766,231
Bonds Notes, and
Loans
6. Interest Earned $29016 $o $29616 H. Miscellaneous $o $o $o
7. Total Revenues $7 122 738 $16,687706 $o $23,810,444 J.street Debt
(Lines B1 tbm %) 1 . Bonds, Notes and $33714 $369126 90 $402600
Loans-wmopal Paia
C. Total Funds $8385,060 $16,681706 $0 45,072766 2. Bontls, Notesantl $12416 $1]0332 $o $182748
Available Loa s- Interest Paitl
(Line A3 + Line B]) TOTALS
K.Total Expenses $5 665 153 $16,687706 $0 $22352,859
(Lines D the R
L Ending Balance $2719607 $o $o $2719607
(Line C 0
M.Total Funds $8385,060 $16,607706 $o $25,072766
Accounted
For (K . L = C)
PIOWADOT City Street Financial Report
Form 517007 (5 2016) 9na20169:46 AM
Office of Local Systems riw,w
Ames, IA 50010 2016
City Name
uu0up11e 3 of 12
Miscellaneous Revenues and Expenses Sheet
Cotle No mbe r an it llemlzalio n of Miscella ne ous Revs no as (Lin e BA on the 5u more IS Column2 Columna
Statement 5heel)(See Instructions) Other Street Monies Street Debt
191-9ile,Tu /Lc90pum $2,988,53200 $000
182—P,N,oyo,B,,W,l s(9ele oe Rerfi $36,93300 $000
100—Petleal OovemmeN(misc) $3,521,92500 $000
190—OAeeMisoel1em0as $900 $000
173 Reimbwsa,,,d F0Oemeges $25,91500 $000
190—ReimbwsaoeNs(misc) $0,86000 $000
191—O emal Fmd Temffees $081,25000 $000
Line BA Totals $6,859,02100 $600
Cotle Number anltamization of Mismllaneous Expenses(Gne Hon the Summary Column Columna
Statement Sheet) "On street parkingeyenses, greet maintanance, builtlings, lnsuan Other Street Monies Street Debt
at mini9ative costs(or printing, legal(eesibontl fees stc (See In9ructions)
H Totals
0I0WADOT City Street Financial Report
Foam 517007 (5 2016) 9nan0169:46 AM
Office of Local Systems riwew
Ames, CA 50010 2016
City Name
0u0up11e 4 of 12
Bonds, Notes and Loans Sheet
Naw oam rypa oam Purpose DoT Issue Issue % Relateit Year Principal Total Total wmopal mleres Principal
6ona2 Use Ony Date Amount to Street Due Balance Principe interest Roads Roads Balance as
asof7S Re it Re it 2!6816
❑ o erelobllgs 364 69N182611 $6316,666 16 2031 $5540,000 $276,666 $114,600 $43266 $16350 $52]6066
onerii
❑ o erelobligs 305 63/1582612 $],495,666 74 2031 $67251000 $355,666 $167,426 $262]66 $123095 $6316066
onerii
❑ o erelobligs 366 6083682616 $4,4]6,666 12 2036 $3555,000 $225,666 $114,688 $2]066 $13763 $3 X316066
onerii❑ o erelobligs 3W 12/1982612 $3,646,666 35 2032 $3245,000 $206,666 $16,466 $]6 p66 $20746 $3045066
onermmeNew Bond Totals $6 $6 Totals $191061000 81 os0 Doo $423202 $402y66 $182740 $18 10151000
PIOWADOT City Street Financial Report
Form 517007 F 2016) 9na20169:46 AM
Office of Local Systems rw.--
Ames, IA 50010 2016
City Name
uuauplle 5 of 12
Project Final Costs Sheet
For construction, re const non on, and improvement prod ects with costs equal to or greater
than 90% of the bid threshold in effect as the beginning of the Csscal year.
Check here W there are no entries for this year El
Project Final Costs Sheet (Section A)
1 . Project Numbar 2. Estimated CoA 3. ProjectType a. Public Lellmg2 5. LoalionNrojed Description (limits length size of structure)
3 $1 ,413229 ROs0 Yes Reconstruction on alleys
1 $696,824 ROs0 Yes Reconstruction of alleys.
2 $961,666 ROSO Yes Reconstruction of alleys.
a $286,213 ROs0 Yes Reconstruction of a alleys.
5 $214,883 ROs0 Yes Reconstruction of 3 alleys.
Project Final Costs Sheet (Section B)
1 . Project Number 6. Contractor Name ]. Contract 8Additions/ 9. Labor 10. Equipment 11. Materials 12. Overhead 13 Total
Prim Deductions
3 Pmtran Construction $1 ,415]69 -$151 ,486 $0 $0 $0 $0 $1n4283
1 Drew Cook and Sons $]66264 $16,403 $0 $0 $0 $0 $662661
2 Draw Cook and Sons $1 006 608 -$161,648 $0 $0 $0 $0 $836660
4 Draw Cook and Sons $284634 -$10586 $0 $0 $0 $0 $214348
5 MCD ermott Ezavatin a $211351 $8,860 $0 $0 $0 $0 $228211
0I0WADOT City Street Financial Report
Form 517007 (5 2016) 9na20169:46 AM
Office of Local Systems riw,,,
Ames, IA 50010 2016
City Name
uu0up11e 6 of 12
Road/Street Equipment Inventory Sheet
1 . 2. 3. 4 5. 6. 7Used On 6.
Local Class Model Description Purchase Lease Nni1 Rental Nni1 Project Status
LD. # Year Coal Coal CoA aisFY2
4034 2009 JD Skid leader $32,056 $0 $0 No NOCH
2730 2009 Sewer Easement Machine $36763 $0 $0 No NOCH
3296 2006 BBBTailer $5585 $0 $0 No NOCH
3230 2007 Ford F550 Crew Cab $91 ,609 $0 $0 No NOCH
3241 2006 International $36,411 $0 $0 No FEAR
3236 2007 International 4200 $101 ]28 $0 $0 No NOCH
3213 2007 John Deere Beckons Leader $6!754 $0 $0 No NOCH
3208 2006 International 400 $36,411 $0 $0 No FEAR
3206 2006 International 400 $36,411 $0 $0 No FEAR
3203 2006 ]4004x2 Dump Truck $94582 $0 $0 No NOCH
3102 2007 Chevrolet Silverado $25,666 $0 $0 No NOCH
2704 2007 International 7500 SFAW4 $194,616 $0 $0 No NOCH
2702 2006 Ford F350 $31560 $0 $0 No NOCH
2715 2006 Godwin 4" Trash Pump $16782 $0 $0 No NOCH
2701 2006 Ford F350 $31 ,075 $0 $0 No NOCH
4006 2010 John Deere Trader $]9560 $0 $0 No NOCH
4006 2010 Elgin Whirlwind Sweeper $1]],010 $0 $0 No NOCH
3290 2006 John Deere Gator $],960 $0 $0 No NOCH
2705 2009 Chevrolet 3500 Sewer Cancer Silverado $]6593 $0 $0 No NOCH
0I0WADOT City Street Financial Report
Foam 517007 (5 2016) 9dV20169:46 AM
Office of Local Systems riw,w
Ames, IA 50010 2016
City Name
uu0up11e 7 of 12
Road/Street Equipment Inventory Sheet
1 . 2. 3. 4 5. 6. 7Used On 6.
Local Class Model Description Purchase Lease Nni1 Rental Nni1 Project Status
LD. # Year Coal Coal CoA aisFY2
2706 1999 CH&S-6" Trash Pump $13,846 $0 $0 No NOCH
2710 1996 PECO Manhole Cutter $13,260 $0 $0 No NOCH
2719 1965 Gorman Rupp 6"Trash Pump $11595 $0 $0 No NOCH
2721 2003 Honda 3" Trash Pump $1 ,107 $0 $0 No NOCH
2711 2007 Ford He Cube Van 2/CCTVEquip $99,000 $0 $0 No NOCH
2726 2000 Portable Jet/RootCuter $6595 $0 $0 No NOCH
2727 2000 Kawasaki Mule 4 wheeler $],011 $0 $0 No NOCH
3201 2009 Freightliner35000 GVW $65X633 $0 $0 No NOCH
3202 1996 International WRosco Distributor $60795 $0 $0 No NOCH
3204 2006 International 7400 Dump Truck $87000 $0 $0 No NOCH
3209 2009 John Deere endloader6i $129,292 $0 $0 No NOCH
3210 2004 John Deere Beckons Loader $58375 $0 $0 No NOCH
3215 2001 Caterpillar Vibratory Asphalt Roller $23390 $0 $0 No NOCH
3216 2006 International 7400 Tamtlem Dump Truck $106,431 $0 $0 No LEAD
3216 2009 Freightliner Bucket Truck $137049 $0 $0 No NOCH
32231 1997 Snow Equipment AnWctng Unit $6,176 $0 $0 No NOCH
3224 2003 Atlas Caere Air Compressor $7819 $0 $0 No NOCH
3227 2006 John Deere Beckons Loader $71 ,880 $0 $0 No NOCH
3229 1967 International Tractor $7250 $0 $0 No NOCH
3231 2002 Ford F450 SEVEN $29585 $0 $0 No NOCH
0I0WADOT City Street Financial Report
Form 517007 (5 2016) 9na20169:46 AM
Office of Local Systems riw,w
Ames, IA 50010 2016
City Name
uu0up11e 8 of 12
Road/Street Equipment Inventory Sheet
1 . 2. 3. 4 5. 6. 7Used On 6.
Local Class Model Description Purchase Lease Nni1 Rental Nni1 Project Status
LD. # Year Coal Coal CoA aisFY2
3225 2005 Dynapac CC12212 Series $25,642 $0 $0 No NOCH
3235 1996 John Deere Meal Leader $95,62 $0 $0 No TRAD
3237 2001 Atlas Creep Ar Compressor $] 282 $0 $0 No NOCH
3236 1991 Town master Trailer $5,461 $0 $0 No NOCH
3240 1996 Target Pro 65111 Concrete Saw $892] $0 $0 No NOCH
3245 2006 Freightliner Tandem Dump Trust $104,052 $0 $0 No TRAD
3247 1990 Cimline Crack Saw $2561 $0 $0 No NOCH
3235 1990 Cimline Crack Saw $3,669 $0 $0 No NOCH
3250 2000 John Deere Meal Loader $116,]50 $0 $0 No NOCH
3251 1991 Caterpillar Paver Finisher $24,411 $0 $0 No NOCH
3255 2007 John Deere 6247 Endloader $136,106 $0 $0 No NOCH
3256 2006 John Deere Lawn Tractor $19,112 $0 $0 No NOCH
3256 1979 Massey Ferguson Trader $11500 $0 $0 No NOCH
3262 2000 Cimline Crack Sealer $16,931 $0 $0 No NOCH
3267 1985 Trailer Wng Taller $2,636 $0 $0 No NOCH
3272 1991 Ingersoll Rand Roller $3,210 $0 $0 No NOCH
3212 2010 International Dump Truck $104]]5 $0 $0 No NOCH
3270 2009 Husrvarna30" Pavement Saw $21 ,9]0 $0 $0 No NOCH
3243 2009 Atlas Creep Air Compressor $10351 $0 $0 No NOCH
3104 2010 Caterpillar Roller $465]5 $0 $0 No NOCH
0I0WADOT City Street Financial Report
Form 517007 (5 2016) 9na20169:46 AM
Office of Local Systems riw...
Ames, IA 50010 2016
City Name
uu0up11e 9 of 12
Road/Street Equipment Inventory Sheet
1 . 2. 3. 4 5. 6. 7Used On 6.
Local Class Model Description Purchase Lease Nni1 Rental Nni1 Project Status
LD. # Year Coal Coal CoA aisFY2
3276 2002 Ingersoll Rand Roller $5356 $0 $0 No NOCH
3279 1996 Myroe Skid Steer Loader $26108 $0 $0 No NOCH
3280 1931 Honda Generator $1560 $0 $0 No NOCH
3281 1931 Speed Served $352] $0 $0 No NOCH
3282 1994 Berming Machine $4,280 $0 $0 No NOCH
3292 2006 Catemller $27],632 $0 $0 No NOCH
3506 2004 Gorman Rupp 10 Trash Pump $35]28 $0 $0 No NOCH
4002 2004 Elgin Pelican Sweeper $31,275 $0 $0 No TEAR
4003 1996 International Vac/Flusher Unit $124]56 $0 $0 No NOCH
4004 2009 International 56,000 GM $105510 $0 $0 No NOCH
4103 1996 Sno-Go Loader Attachment $]5,000 $0 $0 No NOCH
2131 2009 John Deere Gamr $9550 $0 $0 No NOCH
3223 2011 Freigmlmerw/Henderson Combo Dump Box $119427 $0 $0 No NOCH
3226 2010 John Deere Motor Grader $194535 $0 $0 No NOCH
3214 2010 John Deere Beckons /Loader $82518 $0 $0 No NOCH
3104 2010 Caterpillar $485]5 $0 $0 No NOCH
4113 2011 SNOGO unit loader mounted $204,000 $0 $0 No NOCH
3233 2012 International Tandem Dump Truck $110,675 $0 $0 No NOCH
3101 2012 Chevrolet Pickup Truck $29328 $0 $0 No NOCH
3207 2012 International Tandem Dump Truck $110,675 $0 $0 No NOCH
0I0WADOT City Street Financial Report
Form 517007 (5 2016) 9na20169:46 AM
Office of Local Systems riw,w
Ames, IA 50010 2016
City Name
uu0up11e 10 of 12
Road/Street Equipment Inventory Sheet
1 . 2. 3. 4 5. 6. 7Used On 6.
Local Class Model Description Purchase Lease Nni1 Rental Nni1 Project Status
LD. # Year Coal Coal CoA aisFY2
3217 2010 John Deere Wheel Leader Forks Attachment $5,433 $0 $0 No NOCH
4007 2013 Elgin Pelican P Dual Sweeper $1&9,459 $0 $0 No NOCH
3242 2013 International Dump TruckwlCembe Dox $106,659 $0 $0 No NOCH
4011 2013 John Deere Lawn TraAerwlsnew equipment $14516 $0 $0 No NOCH
3236 2014 Jet Flusher Truck /Pipe Cleaner $207490 $0 $0 No NOCH
3205 2013 International 7400 w/mmbobox $106,659 $0 $0 No NOCH
3244 2012 John Deere Wheel Loader644K $220000 $0 $0 No NOCH
3246 2013 Silverado 4WD 12,000 GM Dump w/snow Equpment $56,695 $0 $0 No NOCH
3252 2013 Chevrolet 4WD 12,000 GNVDump w/snowequip $56,695 $0 $0 No NOCH
4001 2013 International 7400 w/Ioadal $131X251 $0 $0 No NOCH
2706 2014 TsrumK"trash pump $15]94 $0 $0 No NOCH
3219 2014 Sullivan D165PJD Air Compressor $951] $0 $0 No NOCH
4047 2014 H&H Trailer GT20 $6,1]5 $0 $0 No NOCH
3241 2016 Freightliner Single Axle Dump Truck $124,039 $0 $0 No NEW
3208 2016 Freightliner Single Axle Dump Truck $124,039 $0 $0 No NEW
3206 2016 Freightliner Single Axle Dump Truck $124,039 $0 $0 No NEW
3216 2016 Freightliner Tandem Dump Truck $136,215 $0 $0 No NEW
3235 2015 John Deere Wheel Loader624K $1]6,000 $0 $0 No NEW
3235 2016 Freightliner Tandem Dump Truck $136,216 $0 $0 No NEW
4002 2015 M2106 Freightliner with Schwarsa Sweeper $190515 $0 $0 No NEW
QIOWADDT City Street Financial Report
Form 517007 (5 2016) 9na20169:46 AM
Office of Local Systems Fi 11(...
Ames, fA 50010 2016
City Name
0uaupuF 11 of 12
Explanation Sheet
Comments
QIOWADDT City Street Financial Report
Form 517007 (5 2016) 9na20169:46 AM
Office of Local Systems riw...
Ames, Is, 50010 2016
City Name
uu0up11e 12 of 12
Monthly Payment Sheet
Month Road Use to z Payme no
July $592,64533
August $]9535915
September $]06,121 74
John bar $541 ,652.61
November $616 134 50
Demonto r $621 915 48
January $515,34351
February $595]3]96
March $611 ,15590
April $423,5]095
May $456 194 25
June $636,60340
Totals $]122]3]]8