The URL can be used to link to this page

Home My WebLink About2016-09-19-J01F Annual Street Finance Reportfflo Woukee ` I �I r 1HE KEY TO GOOD LIVING AGENDA ITEM: CITY OF WAUKEE, IOWA CITY COUNCIL MEETING COMMUNICATION DATE: 09-19-2016 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 FY2016 Street Finance Report is provided for your review. FISCAL EWPACT: None if approved and submitted by September 30, 2016. 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: FY2016 Annual Street Finance Report PREPARED BY: Linda Burkhart, Finance Director REVIEWED BY: PUBLIC NOTICE INFORMATION — NAME OF PUBLICATION: N/A DATE OF PUBLICATION: NIA THE CITY OF WAUKEE, IOWA RESOLUTION 16- 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 2016 Street Finance Report for the City of Waukee, Iowa; AND WHEREAS, the report shows total Road Use Funds available in the amount of $1,704,158 and total expenditures of $1,704,158 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 $34,967,752 and total expenditures in the amount of $16,580,620; 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 19' day of September, 2016. William F. Peard, Mayor Attest: Rebecca D. Schuett, City Clerk I;Z1] 11I Anna Bergman Brian Harrison Shelly Hughes Larry R. Lyon Rick Peterson QIIOWADOT Form 517007 {5-2016} 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 I, 2015 to June 30, 2016 (Year) (Year) Contact Information Fiscal Year 1 2 1 of 11 1 Name E-mail Address Street Address city ZIP Code Tim Moerman 230 W Hickman Road ilWaukee 50263-0000 Hours Phone lExtension Phone(Altenative) 8-5 Mon -Friday 515-987-4522 15159787902 1515-978-7900 Preparer Information Name E-mail Address lPhone Extension Linda Burkhart lurkhart@waukee.org 515-978-7919 15159787919 Mayor Information IWlliam F. Peard Imavomeard(o?email.com 1230 W Hickman Road (Waukee 150263-0000 1 15-978-1492 Resolution Number William F. Peard Signature Mayor Linda Burkhart Signature City Clerk GOIOWADOT Form 517007 {5-20161 Office of Local Systems Ames, IA 50010 City Name WAUKEE Column 1 Column 2 Road use Other Steeet Tax Fund Monies City Street Financial Report Summary Statement Sheet Column 3 Column 4 Street Debt Totals Round Figures to Nearest Dollars Fiscal Year 2� 016 1 2of 11 1 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 EXPENSES 1. July 1 Balance 1 $0 $0 $18,428,1971 $18,428,197 D. Maintenance 2. Adjustments (Note on Explanation Sheet) $0 $0 $0 $0 1. Road Way Maintenancel $1,373,9521 $0 $0 $1,373,952 2. Snow and Ice Removal $270,782 $0 $0 $270,782 3. Adjusted Balance $0 $0 $18,428,197 $18,aza,197 E.Construction, Reconstruction and Improvements 1. Engineering $0 $0 $872,050 $872,050 B. REVENUES 2. Right of Way Purchased $0 $0 $109 $109 1. Road Use Tax $1,704,158 $1,704.158 2. Property Taxes $449.640 $1,729,724 $2,179,364 3. Street/Bridge Construction $1,800 $0 $8,313,027 $8,314,827 3. Special Assessments $0 $0 $0 4.Traffic Services $0 $0 $633,180 $633,180 4. Miscellaneous $48,926 $6,180,144 $6,22%ufu F. Administration $0 $279,813 $0 $279,813 5. Proceeds from Bonds,Notes, and Loans $0 $6,426,963 $6,426,963 G. Equipment $57,624 $218,753 $0 $276,377 6. Interest Earned $0 $0 $0 H. Miscellaneous 1 $0 $0 $0 7. Total Revenues (Lines 131 thru 136) $1,704,158 $498,566 $14,336,831 $16,539,555 J. street Debt 1. Bonds, Notes and Loans -Principal Paid $0 $0 $3,459,019 $3,459,019 C. Total Funds Available (Line A3 + Line 137) $1,704,158 $498,566 $32,765,028 $34,967,752 2. Bonds, Notes and Loans - Interest Paid $0 $0 $1,100,511 $1,100,511 TOTALS K. Total Expenses (Lines D thru J) $1,704,158 $498,566 $14,377,896 $16,580,620 L. Ending Balance (Line C-K) $0 $0 $18,387,132 $18,387.132 M. Total Funds Accounted For (K+L=C) $1,704,158 $498,566 $32,765,028 $34,967,752 010WA00T City Street Financial Report Form 517007 {5-20161 Office of Local Systems Ames, IA 50010 City Name WAUKEE Miscellaneous Revenues and Expenses Sheet 9/8/2016 3:401 PM Fiscal Year 201fi 1 3of11 1 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 170 --- Reimbursements (misc.) $11,836.00 $160,465.00 124 --- Iowa DOT $5,943.00 $0.06 I81 --- Junk and Old $22,290.00 $0.06 173--- Reimbursement For Damages $8,857.00 $56,099.06 122--- RISE Funds $0.00 $3,109,446.06 116--- Other Cities $0.00 $24,329.00 195 --- Tax Increment Financing (TIT) $0.00 $2,511,336.00 112--- Utility Revenue S0.00 $318,469.00 Line B4 Totalsi $48.926.00 $6,180,144.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 Form 517007 15-20161 Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Bonds, Notes and Loans Sheet 1 9/82016 3:40 PM I 2016 1 4of 11 1 New Debt Type Debt Purpose DOT Issue Issue % Related Year Principal Total Total Principal Interest Principal Bond ? Use Only Date Amount to Street - Due Balance Principal Interest Roads Roads Balance as as of 711 Paid .Paid of 6/30 ❑ General Obligation Street 101 02/01/2006 $701,076 100 2019 $306,741 $306,741 $5,531 $306,741 $5,531 $0 Improvements ❑ General obligation Street 104 06/28/2012 $1,206,000 100 2020 $582.750 $198,000 $10,665 $198,000 $10,665 $384,750 Improvements General Obligation Sveet 106 01/01/2005 $141,600 100 2016 $18,746 $9,190 $237 $9,190 $237 $9,556 Improvements ❑ General Obligation Street 107 04/28/2009 $945,000 100 2017 $234,604 $125,000 $8,675 $125,000 $8,675 $109,604 Improvements ❑ General obligation Paving& 302 01/01/1999 $1,010,000 100 2014 $41,679 $39,027 $1,288 $39,027 $1,288 $2,652 Construction ❑ General Obligation Paving& 303 01/01/2001 $340,000 100 2016 $15,241 $15.241 $569 $15,241 $569 $0 Construction ❑ General Obligation Paving& 305 06/02/2010 $500,000 100 2022 $310,340 $40,020 $9,879 $40,020 $9,879 $270,320 construction ❑ General Obligation Paving& 306 05/28/2013 $2,000,800 100 2028 $1,714,100 $198,250 $35,975 $198,250 $35,975$1,515,850 Construction ❑ General Obligation Paving& 307 12/12/2013 $6,205,400 100 2021 $4,713,000 $835,000 $276,131 $835,000 $276,131 $3,878,000 Consnction ❑ General Obligation Paving& 308 06/14/2012 $2,447,600 100 2021 $2.093,800 $359,600 $49,967 $359,600 $49,967 $1,734,200 Conswdion General Obligation Paving& 309 05/28/2013 $2,265,000 100 2020 $1.795,000 $475,000 $19,818 $475,000 $19,818 $1,320,006 Consta lion ❑ General Obligation Paving& 310 12/10/2014 $23,295,000 100 2034 $22.470.000 $210,000 $581,396 $210,000 $581,396 $22,260,000 Construdion ✓❑ General Obligation Paving& 311 11/20/2015 $6,426,963 100 2030 $6,426,963 $647,950 $100,380 $647,950 $100,380 $5,779,013 COneINe110n New Bond Totals $6,426,963 $6,426,963 Totals $40.722.964 $3.459,019 $1,100.511 $3,459,019 $1.100,511 137,263,945 LZIOWADor Form 517007 {5-2016) Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report 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 ❑✓ 9/8/20163:40 PM Fiscal Year 1 5of11 1 Project Final Costs Sheet (Section A) 1. Project Number 12. Estimated Cost 13. Project Type 14. Public Letting? 15. Location/Project Description (limits, length, size of structure) Project Final Costs Sheet (Section B) 1. Project Number 6. Contractor Name 7. Contract 8. Additions/ 9. Labor 10. Equipment 11. Materials 12. Overhead 13. Total Price Deductions Q0I0WADOT City Street Financial Report Form 517007 {5-2016} Office of Local Systems Ames, IA 50010 City Name WALKEE Road/Street Equipment Inventory Sheet I Fiscal Year I 1 6of11 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 NEW 2016 INTL 7400 SFA WIWING PLOW $240,716 $0 $0 No NEW 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 D185PJD $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 FS48003 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-2LP $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 $41,311 $0 $0 No NOCH QIIOWADOT Form 517007 {5-2016} Office of Local Systems Ames, IA 50010 City Name WAGKEF. City Street Financial Report Road/Street Equipment Inventory Sheet 9/8/20163:40 PM Fiscal V. 1 7of I 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 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 MS966RFDD-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 490042 $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,514 $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 & PLOW $24,408 $0 $0 No NOCH 2004 DUMPTRUCK/PLOW $48,284 $0 $0 No NOCH 2005 CHEW 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 L2IOWADOT Form 517007 {5-2016} Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Road/Street Equipment Inventory Sheet 9/8/2016 3:40 PM Fiscal Year 2016 1 8of 11 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 1979 CHEW 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 DUMP TRUCK $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 114 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 INTERNATIONAL DUMP TRUCK $37,884 $0 $0 No TRAD 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 470042 $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 Form 51700715-20161 Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Road/Street Equipment Inventory Sheet M/20163:40 PM Fiscal Year 1 9of 11 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 2010 BOBCAT AUGER 15C $3,365 $0 $0 No NOCH 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 PIOWADOT City Street Financial Report Form 517007 {5-20161 Office of Local Systems Ames, IA 50010 City Name WAUKEE Explanation Sheet I Fiscal Year I 1 10 of 11 1 4PIOWADOT Form 517007 {5-2016} Office of Local Systems Ames, IA 50010 City Name WAUKEE City Street Financial Report Monthly Payment Sheet Month Road Use tax Payments July $141,793.97 August $191,012.24 September $169,422.40 October $129,593.66 November $147,413.90 December $148,797.03 January $124,016.81 February 1$142,533.90 March $146,223.45 April $101,413.68 May $109,147.23 June $152,789.72 Totals $1,704,157.99 9/8/20163:40 PM Fiscal Year 1 11 of 11 1