The URL can be used to link to this page

Home My WebLink About2017-09-18-J01D Street Finance Report►1► Waukee ' 7 j1 r THE KEY TO GOOD LIVING AGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION DATE: 09-18-2017 AGENDA ITEM: Consideration of Approving Annual Street Finance Report and directing the Finance Director to file the report with the Iowa Department of Transportation. FORMAT: Resolution SYNOPSIS: A copy of the completed FY2017 Street Finance Report is provided for your review. FISCAL IMPACT: None if approved and submitted by September 30, 2017. ADVISORY COMMITTEE REVIEW AND COMMENT: NIA STAFF REVIEW AND COMMENT: Staff has prepared and reviewed the enclosed report. RECOMMENDATION: Staff recommends approving the attached Resolution, approving the City of Waukee's annual Street Finance Report, and directs the Finance Director of Waukee to file the report with the Iowa Department of Transportation. ATTACHMENTS: FY2017 Annual Street Finance Report PREPARED BY: Linda Burkhart, Finance Director REVIEWED BY: PUBLIC NOTICE INFORMATION — NAME OF PUBLICATION: NIA DATE OF PUBLICATION: NIA THE CITY OF WAUKEE, IOWA RESOLUTION 17- RESOLUTION OF THE CITY OF WAUKEE'S ANNUAL STREET FINANCE REPORT, AND DIRECTING THE FINANCE DIRECTOR OF THE CITY OF WAUKEE TO FILE THE REPORT WITH THE DEPARTMENT OF TRANSPORTATION WHEREAS, the Waukee Director of Finance has submitted to the City Council of the City of Waukee the 2017 Street Finance Report for the City of Waukee, Iowa; AND WHEREAS, the report shows total Road Use Funds available in the amount of $1,952,603 and total expenditures of $1,952,603 in the Road Use Fund, with an ending Road Use Fund Balance of $0; AND WHEREAS, the report shows total Road Use related funds available from all funds in the amount of $38,696,206 and total expenditures in the amount of $14,806,689; AND WHEREAS, the City Council finds that the funds for road use purposes have been used for their intended purpose. NOW, THEREFORE, BE IT RESOLVED that the City of Waukee hereby approves the Street Finance Report and directs the Finance Director to file the same with the Department of Transportation on this 18'h day of September, 2017. William F. Peard, Mayor Attest: Rebecca D. Schuett, City Clerk ROLL CALL VOTE AYE NAY ABSENT ABSTAIN Anna Bergman R. Charles Bottenberg Brian Harrison Shelly Hughes Larry R. Lyon L2IOWADOT Form 517007 15-20171 Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Cover Sheet Now therefore let it be resolved that the city council WAUKEE , Iowa (City Name) On did hereby approve and adopt the annual (month/day/year) City Street Financial Report from July 1, 2016 to June 30, 2017 (Year) (Year) Contact Information 9/12/20174:02 PNI Fiscal Year 2017 I of 12 I Name E-mail Address Street Address city ZIP Code Tim Moennan tmoerman@waukee.org 230 W Hickman Road lWaukee 50263-0000 Hours Phone Extension Phone(Altemtive) 8-5 Mon -Friday 515-987-4522 5159787902 515-978-7900 Preparer Information (Linda Burkhart lburkhartQwaukee.ore 1515-978-7919 15159787919 1 Mayor Information 15-978-1492 Resolution Number Signature Mayor tr Signature City Clerk Q1IOWADOT Form 517007 15-20171 Office of Local Systems Ames, IA 50010 City Name W.4UKEE City Street Financial Report Summary Statement Sheet Column 1 Column 2 Column 3 Column 4 Road use Other Steeet Street Debt Totals Tax Fund Monies Round Figures to Nearest Dollars A.BEGINNING BALANCE 1. July 1 Balance I 1i0 $0 $18,387,1321 $18,387,132 2. Adjustments (Note on Explanation Sheet) $0 $0 $0 $0 3. Adjusted Balance $0 $0 $18,387,132 $18,387,132 B. REVENUES 1. Road Use Tax $1.952,603 $1,952,603 2. Property Taxes $115.210 $1,773,546 $1,888,756 3. Special Assessments $0 $0 $0 4. Miscellaneous $157,871 $4,182,044 $4,339.915 5. Proceeds from Bonds,Notes, and Loans $0 $12,127.800 $12,127,800 6. Interest Earned 1 $0 $0 $0 7. Total Revenues (Lines B1 thru B6) $1,952,603 $273,081 $18,083,390 $20,309,074 C. Total Funds Available (Line A3 + Line B7) $1,952,603 $273,081 $36,470,522 $38,666,206 9/12/2017 4:02 Pal Fiscal Year 2017 2of12 1 Column 1 Column 2 Column 3 Column 4 Road use Other Steeet Street Debt Totals Tax Fund Monies Round Figures to Nearest Dollars EXPENSES D. Maintenance 1. RoadWay Maintenance $1,394,758 $0 $0 $1,394.758 2. Snow and Ice Removal $153,078 $0 $0 $153.078 E-Construction, Reconstruction and Improvements 1. Engineering $0 $0 $2,093,117 $2.093,117 2. Right of Way Purchased $0 $0 $358,260 $358,260 3. Street/Bridge Construction $0 $193,603 $5,356,998': $5,550,601 4.TrafBc Services $0 $0 $11,320 $11,326 F. Administration $291,572 $79,478 $0 S371,050 r. Equipment $113,195 $0 $0 $113,195 H. Miscellaneous $0 $0 $0 J. street Debt 1. Bonds, Notes and Loans -Principal Paid $0 $0 $3,652.1361 3,652,136 2. Bonds, Notes and Loans- Interest Paid $0 $0 $1,109,174 $1,109,174 TOTALS K. Total Expenses (Lines D thru J) $1,952,603 $273,081 $12,581,005 $14,806,689 L. Ending Balance (Line C-K) $0 $0 $23,889,517 $23,889,517 M. Total Funds Accounted For (K + L = C) $1,952.603 $273,081 $36,470,522 $38,696,206 LZlOWADOT City Street Financial Report Form 517007 {5-2017} Office of Local Systems Ames, IA 50010 City Name WAUKEE Miscellaneous Revenues and Expenses Sheet Fiscal Year 1-7 3 of 12 Code Number and Itemization of Miscellaneous Revenues (Line B4 on the. Summary Statement Sheet)(See Instructions) Column 2 Other Street Monies Column 3 Street Debt 195 --- Tax Increment Financing(TIF) $0.00 $2,669,046.00 112--- Utility Revenue $0.00 $318,719.00 140--Federal Government (mist.) $0.00 $343,997.001 122--RISE Funds $0.00 $611.335.00 116--Other Cities $0.00 $116,133.00 170--- Reimbursements (mist.) $122,136,00 $122,814.00 173 --- Reimbursement For Damages $19,033.00 $0.00 1I8 --- School Districts $6,269.00 $0.00 181--Junk and Old $10,334.00 $0.00 171--Sales of New Material (Rock, Culverts, etc.) $100.00 $0.00 Line B4 Totalsi $157,871.001 $4,182,044.00 Code Number and Itemization of Miscellaneous Expenses (Line H on the Summary Column 2 Column 3 Statement Sheet) "On street" parking expenses, street maintenance, buildings, insurance, Other Street Monies Street Debt administrative costs for printing, legal fees,bond fees etc. (See Instructions) Line H Totals [PIOWADOT Form 517007 {5-2017} Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Bonds, Notes and Loans Sheet Fiscal Year 2017 1 4of 12 1 New Debt Type Debt Purpose DOT Issue Issue %Related Year Principal Total Total Principal interest Principal Bond ? Use Only Data Amount to Street Due Balance Principal Interest Roads Roads Balance as as of 7/1 Paid Paid of 6130 ❑ General Obligation Street 104 06/28/20121 $1,206,000 100 2020 $384,750 $202,500 $7,695 $202,500 $7,695 $182,250 Improvements ❑ General Obligation Street 106 01/01/2005 $141,600 100 2016 $9,556 $9,556 $0 $9,556 $0 $0 Impmvements ❑ General Obligation Street 107 04/28/2009 $945,000 100 2017 $109,604 $109,604 $4,550 $109,604 $4,550 $0 Improvements ❑ General Obligation Paving& 302 01/01/1999 $1,010.000 100 2014 $2,652 $2,652 $0 $2,652 $0 $0 Construction ❑ General Obligation Paving& 305 06/02/2010 $500,000 100 2022 $270,320 $41,760 $8,678 $41,760 $8,678 $228,560 Construction ❑ General Obligation Paving& 306 05/28/2013 $2,000,800 100 2028 $1.515,850 $201,300 $32,010 $201,300 $32,010$1,314,550 Construction ❑ General Obligation Paving& 307 12/12/2013 $6,205,400 100 2021 $3,878,000 $850,000 $251,081 $850,000 $251,081 $3,028,000 Construction ❑ General Obligation Paving& 308 06/14/2012 $2,447,600 100 2021 $1.734,200 $365,400 $44,573 $365,400 $44,573 $1,368,800 Construction ❑ General Obligation Paving& 309 05/28/2013 $2,265,000 100 2020 $1.320,000 $485,000 $14,618 $485,000 $14,618 $835,000 Construction ❑ General Obligation Paving& 310 12/10/2014 $23,295,000 100 2034 $22260.000 $500.000 $577,196 $500,000 $577,196 $21,760,000 Construction ❑ General Obligation Paving& 311 11/20/2015 $6,426,963 100 2030 $5,779,013 $884,364 $168.773 $884,364 $168,773 $4,894,649 Construction ❑✓ General Obligation Paving& 312 05/24/2017 $12, 127,800 100 2036 $12,127,800 $0 $0 $0 $0$12.127,800 Construction New Bond Totals $12,127,800 $12,127,800 Totals $49.391,7115 $3,652.136 $1.109,174 $3.652,136 $1,109,174 $45,739,609 LZIOWADOT City Street Financial Report Form 517007 15-20171 Office of Local Systems Ames, IA 50010 City Name WAOKEE 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. Check here if there are no entities for this year ❑ Project Final Costs Sheet (Section A) 1 9/12/2017 4:02 PM I 2017 5 of 12 1 1. Project Number 2. Estimated Cost 3. Project Type 4. Public Letting? 5. Location/Project Description (limits, length, size of structure) 1601 $430,000 TRAF Yes Traffic Signals at Hickman / Dartmoor 1610 $100,000 TRAF Yes Traffic Signals - Ashworth Rd / LA Grant 7740 $1,575,000 RDWY Yes Construction of Douglas Pkwy from Alice's Rd to Warrior Lane 8030-2017 $165,000 RDWY Yes Developer Lane Additions-Olson/Alices, Ashworth/Grand Prairie 213-1 $2,500,000 BRID Yes 180/Alices/105th Street Bridge 213-2 $7,500,000 RDWY Yes Grand Prairie Pkwy - 180 to Ashworth - Local Project 213-3 $9,825,000 RDWY Yes Grand Prairie Pkwy- Ashworth to University 213-4 $2,500,000 RDWY Yes Grand Prairie- University Intersection 213-5 $1,290,000 RDWY Yes Grand Prairie Pkwy - Street Lighting - 180 to University 213-6 $1,500,000 RDWY Yes Grand Prairie Pkwy - Traffic Signals & Trails i 213-7 $686,319 RDWY Yes Grand Prairie Pkwy - Esker Ridge Intersection Project Final Costs Sheet (Section B) 1. Project Number 6. Contractor Name 7. Contract Price B. Additions/ Deductions 9. Labor 10. Equipment 11. Materials 12. Overhead 13. Total 1601 PG Construction $432,957 $2,300 $0 $0 $0 $0 $435,257 1610 PG Construction $93,973 $0 $0 $0 $0 $0 $93,973 7740 Hawkeye Paving $889,250 $69,131 $0 $0 $0 $0 $958,381 8030-2017 Manatts $154,107 $10,261 $0 $0 $0 $0 $164,368 213-1 Elder Corporation $2,040,383 $0 $0 $0 $0 $0 $2,040,383 213-2 McAninch Corporation $4,728,797 $119,271 $0 $0 $0 $0 $4,848,068 CJIOWADOT Form 517007 {5-2017} Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Project Final Costs Sheet (Section B) 1 9/12/2017 4:02 PNI I 2017 6 of 1. Project Number 6. Contractor Name 7. Contract Price 8. Additions/ Deductions 9. Labor 10. Equipment 11. Materials 12. Overhead 13. Total 213-3 Manatts Inc $9,803,414 -$221,389 $0 $0 $0 $0 $9,582,026 2134 Manatt's $1,796,033 -$19,335 $0 $0 $0 $0 $1,776,698 213-5 Iowa Signal $1,036,580 $36,759 $0 $0 $0 $0 $1,073,339 213-6 Howrey Construction $1,385,113 $149,441 $0 $0 $0 $0 $1,534,554 213-7 Manatt's $662,394 $5,982 $0 $0 $0 $0 $668,376 0IOWADOT Form 517007 15-2017} Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Road/Street Equipment Inventory Sheet 1 9/12/20174:02 PNI 2017 7 of 12 1 1. Local Class I.D. # 2. Model Year 3. Description 4. Purchase Cost 5. Lease cost /Unit 6. Rental cost /Unit 7. Used On Project this FY? 8. Status 2016 FORD F250 PU $30,545 $0 $0 No NOCH 2016 INTL 7400 SFA WAVING PLOW $240,716 $0 $0 No NOCH 2011 WESTERN POLY V PLOW $5,100 $0 $0 No NOCH 2012 CHEW SILVERADO $26,486 $0 $0 No NOCH 2012 FORD F350 $24,810 $0 $0 No NOCH 2012 HOSE REEL W/HOSE $2,645 $0 $0 No NOCH 2012 COMPRESSOR 0185PJD $13,043 $0 $0 No NOCH 2012 JOHN DEERE 1600 WIDE AREA MOWER $47,757 $0 $0 No NOCH 2012 JOHN DEERE 5065M UTIL TRACTOR $19,884 $0 $0 No NOCH 2012 BUFFALO KB4 $6,425 $0 $0 No NOCH 2013 INTL 7300 SFA 4X2 $153,308 $0 $0 No NOCH 2012 FS4800 3 SPEED SAW $19,974 $0 $0 No NOCH 2012 Ford F550 Aerial Bucket Truck $75,565 $0 $0 No NOCH 2013 INTL 7300 SFA 4x2 $169,867 $0 $0 No NOCH 2013 FELLING TRAILER FT20-21LP $10,000 $0 $0 No NOCH 2013 BOBCAT S750 SKIDSTEER $44,928 $0 $0 No NOCH 2013 SIGN POST DRIVER $4,900 $0 $0 No NOCH 2014 INTL 7300 SFA 4X2 w/SNOW BLADE $47,037 $0 $0 No NOCH 2014 JOHN DEERE 544K LOADER S41,311 $0 $0 No NOCH CJIOWADOT Form 517007 {5-2017j Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Road/Street Equipment Inventory Sheet 9/12/2017 4:a2 FM Fiscal Year 8of12 1 1. Local Class I.D. # 2. Model Year 3. Description 4. Purchase Cost 5. Lease Cost /Und 6. Rental Cost /Unit 7. Used On Project this FYT 8. Status 2014 HOT PATCH TRAILER-4 TON $30,125 $0 $0 No NOCH 2014 SUPER SHOT 125D MELTER $33,750 $0 $0 No NOCH 2015 CHEVY SILVERADO PU w/PLOW $37,180 $0 $0 No NOCH 2015 INTERNATIONAL 7300 $178,974 $0 $0 No NOCH 2011 AS-3 ELECTRONIC SPREADER $3,875 $0 $0 No NOCH 2011 MONROE MS966RFDO-304SS $4,742 $0 $0 No NOCH 2011 FORD F150 UTILITY BODY $8,000 $0 $0 No NOCH 2011 FORD F350 XL $20,488 $0 $0 No NOCH 2001 INTERNATIONAL 4900 4z2 $43,000 $0 $0 No NOCH 2010 84' SNOWBLOWER SBX240 $5,048 $0 $0 No NOCH 2009 GRADER JD770CH $120,000 $0 $0 No NOCH 2009 BOBCAT TRACKLOADER T300 $26,901 $0 $0 No NOCH 2007 INTERNATIONAL 7300 DUMP TRUCK $108,614 $0 $0 No NOCH 2006 DOOLITTLE CARGO TRAILER $7,470 $0 $0 No NOCH 1996 USED INTERNATIONAL 4700 DUMP TRUCK $23,500 $0 $0 No NOCH 2006 FORD F350 PICKUP 8 PLOW $24,408 $0 $0 No TRAD 2004 DUMPTRUCK/PLOW $48,284 $0 $0 No NOCH 2005 CHEVY SILVERADO $4,384 $0 $0 No NOCH 2005 TYMCO STREET SWEEPER $98,889 $0 $0 No NOCH 2005 REAR SPREADER $6,724 $0 $0 No NOCH G0IOWADOT Form 517007 {5-2017} Office of Local Systems Ames, IA 50010 City Name W.4UKEE City Street Financial Report Road/Street Equipment Inventory Sheet 9/12/2017 4:02 PM Fiscal Year 2017 9 of 12 1. Local Class I.D. # 2. Model Year 3. Descrip0on 4. Purchase Cost 5. Lease Cost /Unit 6. Rental Cost /Unit 7. Used On Project this FY7 8. Status 1979 CHEVY PICKUP $5,630 $0 $0 No NOCH 1979 CHEW PICKUP 4WHEEL DRIVE $6,200 $0 $0 No NOCH 1994 FORD F700 DUMP TRUCK $26,828 $0 $0 No NOCH 1994 HEIL 10' DUMP BODY $6,628 $0 $0 No NOCH 1998 DUMPTRUCK $11,500 $0 $0 No NOCH 1998 JOHN DEERE 10' ROTARY MOWER $7,225 $0 $0 No NOCH 1999 FORD F250 TRUCK $22,933 $0 $0 No NOCH 1998 1/4 JOHN DEERE 5410 MFWD TRACTOR $5,061 $0 $0 No NOCH 2000 ROAD CRACK SEALER $17,600 $0 $0 No NOCH 2000 CANON NP3050 COPIER $5,849 $0 $0 No NOCH 2003 MOWER $5,300 $0 $0 No NOCH 2003 MOWER $12,846 $0 $0 No NOCH 1995 INTERNATIONAL DUMP TRUCK $18,500 $0 $0 No NOCH 2004 MOWER $17,032 $0 $0 No NOCH 2007 FORD EXPLORER $21,556 $0 $0 No NOCH 2000 INTERNATIONAL 47004x2 $55,025 $0 $0 No NOCH 2009 78OFM SNOWBLOWER $2,600 $0 $0 No NOCH 2010 INTERNATIONAL 7300SFA 4x2 $114,011 $0 $0 No NOCH 2010 JOHN DEERE 5075E UTIL TRACTOR $33,368 $0 $0 No NOCH 2010 BOBCATAUGER15C $3,365 $0 $0 No NOCH iC410WADOT Form 517007 {5-2017} Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Road/Street Equipment Inventory Sheet 9/13/2017 4:02 PM Fhs .l Year 10 of 12 1 1. Local Class I.D. # 2. Model Year 3. Description 4. Purchase Cost 5. Lease Cost /Unit 6. Rental Cost /Unit 7. Used On Project this FY7 8. Status 2011 AS3 ELECTRONIC SPREADER $3,875 $0 $0 No NOCH 2011 KNAPHEIDE GOOSENECK PLATFORM $3,368 $0 $0 No NOCH 2011 MULTI POSITION V PLOW $5,100 $0 $0 No NOCH 2017 Bobcat T750/T4 $9,591 $0 $0 No NEW 2017 JOHN DEERE 1585 TERRAIN CUT MOWER $38,520 $0 $0 No NEW 2017 JOHN DEERE T0310 BACKHOE LOADER $22,650 $0 $0 No NEW 2017 FORD F350 $35,462 $0 $0 No NEW 2017 FORD F150 W/PLOW $27,233 $0 $0 No NEW ,C41OWADOT Form 517007 {5-2017) Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Explanation Sheet 1 9112"0174:01Mid Fisca� 1 Yee II of 12 1 CJIOWADOT Form 517007 {5-20171 Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Monthly Payment Sheet Month Road Use tax Payments July $123,337.89 August $188,587.81 September $177,842.39 October $137,090.90 November $153,838.63 December $127,511.74 January $200,251.14 February 1$209,497.05 March $176,862.44 April $125,691.24 May $141,105.54 June $185,986.64 Totals $1,952,603.41 9/12/2017 4:02 Phi Fiseal Year 2017 12 of 12