Loading...
Public Works Department FY2020 Budget PresentationCopyrighted February 27, 2019 City of Dubuque Public Hearings # 3. ITEM TITLE: SUMMARY: SUGGESTED DISPOSITION: Public Works Department FY2020 Budget Presentation ATTACHMENTS: Description Type Public Works Department FY2020 Budget Outline Supporting Documentation Public Works This page intentionally left blank. -64- PUBLIC WORKS DEPARTMENT FY 2018 FY 2019 FY 2020 % Change From Budget Highlights Actual Budget Requested FY 2019 Budget Expenses Employee Expense 7,759,123 8,075,566 7,935,258 (1.7)% Supplies and Services 6,417,386 6,763,449 7,203,813 6.5 % Machinery and Equipment 311,478 743,911 352,240 (52.7)% Subtotal 14,487,987 15, 582, 926 15, 491, 311 (0.6) % Public Works Administrative / Garage Stores 888,129 882,360 957,449 8.5 % Administrative Overhead Recharge 1,291,784 1,287,797 1,443,513 12.1 % Less Recharges/Service Fund Charges (2,138,996) (2,097,596) (2,192,216) 4.5 % Total Expenses 14,528,904 15,655,487 15,700,057 0.3 % Resources Operating Revenue Salt Operations Fund Road Use Tax Fund Sewer Utility Operating Fund Stormwater User Fund Refuse Collection Fund Landfill Operating Fund Total Resources Debt Service abated with Sales Tax 30% Debt Service abated with Landfill Fees Debt Service abated with Solid Waste Fees Total Non -Property Tax Debt Service Property Tax Support Percent Increase (Decrease) 95,098 91,779 5,169,528 730,507 282,840 3,877,281 3,276,054 61,271 113,065 6,147, 241 830,141 241,698 3,906,921 3,365,257 58,843 172,450 6,070,107 758,438 258,342 3,942,222 3,513,486 (4.0) % 52.5 % (1.3)% (8.6)% 6.9 % 0.9 % 4.4 % 13, 523, 087 14, 665, 594 126,197 137,208 667,559 662,659 34,710 7,363 14, 773, 888 0.7 % 135,332 660,659 7,286 828,466 807,230 1,005,817 989,893 803,277 926,169 Personnel - Authorized FTE 92.09 91.96 91.96 (0.5)% (63, 724) (6.4) % -65- Solid Waste Collection Fund Summary Administrative Overhead Recharges/Utility Billing Refuse Operations Debt Service - Refuse Payment to Depreciation Total Requirements Refuse Fees (Inc' tipper carts/other) UBP Single Use Refuse Sticker Sales Tax Collection Yard Waste Stickers & Ties Leaf Rake Out Fees Food Scrap Recyclable Sales Subscription Recycling Large Item Pickup Miscellaneous Revenue Total Resources Annual Operating Surplus (Deficit) Personnel -Authorized FTE Solid Waste User Fee Rate Increase Solid Waste User Fee Revenue 1% Rate Increase Generates FY 2018 FY 2019 FY 2020 % Change From Actual Budget Requested FY 2019 Budget 914,569 927,857 1,055,920 2,962,712 2,979,064 2,886,302 34,710 7,363 7,286 350,000 460,000 510,000 13.8 % (3.1)% (1.0)% 10.9 % 4,261,991 4,374,284 4,459,508 3,887,191 105,381 7,558 119,376 4,563 9,412 3,247 3,542 27,212 97,758 1.9 % 3,954,135 4,054,887 2.5 % 101,457 101,457 - % 7,555 6,771 (10.4) % 164,761 125,117 (24.1)% 5,136 4,563 (11.2)% 8,403 9,412 12.0 % 10,069 3,247 (67.8) % 3,548 3,542 (0.2) % 24,770 23,196 (6.4) % 60,476 68,131 12.7 % 4,265,240 4,340,310 4,400,323 1.4 % 3,249 (33, 974) (59,185) (25, 211) 20.75 20.75 20.75 2.30% 1.70% 1.63% $ 15.11 $ 15.37 $ 15.62 $ 34,801 Salt Operations Fund Summary Salt Purchase Salt Handling Fees Miscellaneous Fees Administrative Overhead Property Maintenance Total Requirements Salt Sales Salt Storage Fees Salt Handling Fees Total Resources Annual Operating Surplus (Deficit) FY 2018 FY 2019 FY 2020 % Change From Actual Budget Requested FY 2019 Budget 72,419 90,400 151,775 9,713 11,440 14,450 4,623 5,996 807 5,024 4,879 4,918 350 500 67.9 % 26.3 % (86.5)% 0.8 % 42.9 % 91,779 75,033 12,019 9,221 113,065 172,450 90,440 11,500 11,440 151,775 14,250 14,450 52.5 % 67.8 % 23.9 % 26.3 % 96,273 113,380 180,475 4,494 315 8,025 59.2 % 7,710 -66- Improvement Package Summary General Fund 1 of 1 This decision package provides funds to allow the Public Works Director to attend the national Solid Waste Association of North America SWANApalooza conference. The conference covers all subjects related to the solid waste industry including landfill operations, gas collection system, zero waste principles, solid waste collection and recycling. This conference would provide the Public Works Director the opportunity to hear from national experts on subjects related to the solid waste industry. This request supports the City Council goal of Financially Responsible, High Performance City Organization: Sustainable, Equitable and Effective Service Delivery. Related Cost: Property Tax Impact: Activity: Administration $ 3,100 Tax Funds $ 0.0012 0.01% Recurring Recommend - Yes Road Use Tax 1 of 1 This decision package provides additional funds for the purchase of a self contained hotpatch heater that would warm cold mix asphalt patch during the non -paving season. The unit has two heating sources, an electric pre -heater and a diesel or gas powered heat pump. Properly warmed cold patch materials flow into potholes better and have better adhesion. By warming cold mix patch materials, staff would be able to work more efficiently and with less risk of injury. Warming high-performance cold mix material provides a more durable, and longer lasting repair. This unit would help Public Works continue to streamline the work process while prompting better results necessary for a successfully high performance governance organization. Related Cost: $ 18,000 Road Use Tax Non -Recurring Recommend - Yes Activity: Street Maintenance Solid Waste Collection Fund 1 of 3 This decision package would provide funding to purchase a tablet to be used by the Solid Waste field staff to streamline trash -related issues between the Solid Waste Foreman, office staff, and other departments. The tablet would allow staff to document and respond to solid waste issues within the right-of-ways or on other public or private properties. The tablet would allow field staff to document the violation in the field which would improve productivity related to resolving these type of issues. This request supports the City Council goal of Financially Responsible, High- Performance City Organization. Related Cost: $ 950 Solid Waste User Fees Non -Recurring Recommend - Yes Related Cost: $ 120 Solid Waste User Fees Recurring Total Cost: $ 1,070 Solid Waste Rate Impact: 0.03% Activity: Solid Waste Collection 2 of 3 This decision package would provide funding to purchase one rectangular closed top drop off container to be used for glass recycling collection. In 2011, the City ended its curbside collection of glass and in 2016 the local Material Recovery Facility (MRF) ended a glass drop off service at their facility. This proposal would establish a glass drop program for city residents who wish to recycle glass containers. Citizens who participated in the City of Dubuque's Comprehension Plan as well as input from citizens in the 2018 Curbside Collection Survey continue to identify glass recycling as a high priority. Among citizens who -67- responded to the curbside collection survey, 80% reported that they would recycle glass if there was a drop-off site. The drop-off glass container will be managed and supervised at the Municipal Service Center by the Public Works Department. Once the drop off container is filled with acceptable glass, the glass would be stored until Ripple Glass of Kansas City, Missouri, a partner in this project, collects the material at no cost to the City. The glass would be converted into fiberglass insulation and/or back into new glass containers. This request supports the City Council goal of Financially Responsible, High- Performance City Organization by being responsive to residents' requests. Related Cost: $ 10,000 Solid Waste User Fees Non -Recurring Recommend - Yes Solid Waste Rate Impact: 0.29% Activity: Recycling Collection 3 of 3 This decision package would provide funding to purchase an additional 500 65 -gallon wheeled carts to meet the current increased demand in subscriptions for City refuse carts. The proposal would also help meet the need that is anticipated when customers realize that refuse carts are more affordable than subscribing to other optional refuse service such as oversized, an additional oversized, and/or a second 35 -gallon refuse container. This request supports the City's goal for Excellent Municipal Service by allowing staff to be responsive to customers' demand for a subscription -based tipper cart. Related Cost: $ 27,000 Solid Waste User Fees Recurring Recommend - Yes Solid Waste Rate Impact: 0.78% Activity: Recycling Collection Significant Line Items Employee Expense FY 2020 employee expense reflects a 1.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2019 The employee contribution of 6.29% is unchanged from FY 2019. 3. The City portion of health insurance expense is decreased from $1,193 in FY 2019 to $921 in FY 2020 per month per contract which results in an annual cost savings of $302,741 or 22.77%. 4. Workers' Compensation decreased from $362,859 in FY 2019 to $338,053 in FY 2020. FY 2018 actual was $429,301. The Iowa Workers Compensation law changed effective July 1, 2017. This law change reduced the amount of liability employers incur for certain work-related injuries. 5. Overtime is increased from $304,391 in FY 2019 to $324,391 in FY 2020. Snow and Ice Control increased $20,000 based on a seven-year average. FY 2018 actual was $362,224. 6. Sick Leave Payout decreased from $59,911 in FY 2019 to $40,307 in FY 2020. 7. The Assistant Horticulturalist position shared with the Parks Division (0.42 FTE in Public Works) was unfrozen effective January 1, 2019 creating $17,600 in additional cost in FY 2020. -68- Supplies & Services 8. General Liability Insurance increased from $132,685 in FY 2019 to $140,398 in FY 2020 based on FY 2019 plus 6%. 9. Property Insurance increased from $58,917 in FY 2019 to $99,011 in FY 2020. The increase is due to the three-year pollution liability policy due for the Landfill in FY 2020. 10. Repair Parts and Supplies increased from $81,057 in FY 2019 to $96,477 in FY 2020 based on FY 2018 actual of $102,708. Floodwall unchanged $0 based on FY 2018 actual. Sanitary Sewer Maintenance increased $9,016 based on FY 2018 actual. Landfill increased $7,505 based on FY 2018 actual. 11. Electric Utility Expense increased from $148,327 in FY 2019 to $148,968 in FY 2020. This line item represents lighting at the Municipal Services Center and the Central Street Storage Facilities (formally the Jule Bus Facility on Central Avenue). FY 2018 actual was $148,967. Street Maintenance increased from $55,674 in FY 2019 to $59,192 in FY 2020; Solid Waste Collection increased from $9,097 in FY 2019 to $10,551 in FY 2020; Garage increased from $15,656 in FY 2019 to $20,048 in FY 2020 due to adding the Central Street Storage Facilities building; and Floodwall decreased from $39,632 in FY 2019 to $34,233 in FY 2020. 12. Street Lighting decreased from $697,123 in FY 2019 to $650,451 in FY 2020 based on FY 2018 actual. The street lighting budget is split $35,382 general fund and $613,843 road use tax fund in FY 2020. 13. Property Maintenance increased from $167,321 in FY 2019 to $236,351 in FY 2020. FY 2018 actual was $196,370. Public Works Garage increased $33,296 based on FY 2018 actual, adding the Central Street Storage Facilities (formally the Jule Bus Facility on Central Avenue), and the one-time expense of caulking repair to the Municipal Services Center in FY2020 ($20,000). Street Maintenance increased $6,596 which results from moving $13,404 of HVAC, Elevator Maintenance and Fire Suppression to separate line items and the addition of $20,000 for the one-time expense of caulking repair to the Municipal Services Center in FY 2020. Solid Waste Collection increased $17,688 due to the one-time expense of caulking repair to the Municipal Services Center in FY2020 ($20,000). Landfill increased $13,756 due to the addition of $10,000 for the anticipated changes necessary due to the construction of the Landfill road project for movement of the gate. 14. Motor Vehicle Fuel increased from $243,888 in FY 2019 to $259,157 in FY 2020 based on a three- year average of actual expense plus 8%. FY 2018 actual was $310,476. 15. Motor Vehicle Maintenance increased from $472,589 in FY 2019 to $480,340 in FY 2020 based on FY 2019 plus 2%. FY 2018 actual was $447,325. 16. Motor Vehicle Maintenance Outsourced increased from $114,537 in FY 2019 to $115,509 in FY 2020 based on FY 2019 plus 2%. FY 2018 actual was $159,403. 17. Machinery and Equipment Maintenance increased from $574,013 in FY 2019 to $648,041 in FY 2020. FY 2018 actual was $738,337. Street Maintenance decreased $11,754 based on FY 2018 actual. Street Cleaning increased $31,032 due to increased maintenance cost on street sweepers. Snow and Ice Control increased $15,517 based on a three-year average. Garage increased $10,223 based on FY 2018 actual. Landfill increased $28,994 based on FY 2018 actual less one- time repairs. -69- 18. Machinery and Equipment Maintenance Outsourced increased from $143,474 in FY 2019 to $151,759 in FY 2020. FY 2018 actual was $212,111. Floodwall increased $3,086 based on FY 2018 actual. Street Maintenance decreased $7,972 based on FY 2018 actual. Snow and Ice Control decreased $18,731 based on FY 2018 actual. Sanitary Sewer Maintenance increased $6,749 based on FY 2018 actual. Landfill increased $28,349 based on FY 2018 actual less 33% for one-time repairs. 19. Asphalt increased from $709,678 in FY 2019 to $729,214 in FY 2020 based on purchasing 15,000 tons of hot and cold mix asphalt, completing five center line street miles, and a 6% increase over FY 2018 bid prices. FY 2018 actual was $591,819 ($355,546 Road Use Tax Funds and $236,273 Community Development Block Funds). 20. Concrete increased from $138,766 in FY 2019 to $154,591 in FY 2020 based on buying 1,500 cubic yards of concrete and k-crete and based on a three year average of costs. FY 2018 actual was $140,460. 21. Stone increased from $109,458 in FY 2019 to $109,746 in FY 2020 based on FY 2018 actual of $98,757. This line item represents the purchase of $2,700 tons of stone for street maintenance ($36,704), stone for repairing sanitary sewer and storm sewer street excavations ($3,021), and stone for resurfacing Landfill gravel roads and cell face access lanes ($69,695). 22. Road Salt for Snow and Ice Control increased from $226,000 in FY 2019 to $333,905 in FY 2020. Road Salt increased $107,905 based on the purchase of 5,500 tons of road salt at $60.71 per ton (In FY 2019 budget is based on the purchase of 5,000 tons at $45.20 per ton). 23. Road Salt for Bid Partners increased from $90,400 in FY 2019 to $151,775 in FY 2020. Bid partner salt increased $61,375 based on the purchase of 2,500 tons at $60.71 per ton (In FY 2019 the budget is based on the purchase of 2,000 tons at $45.20 per ton) which is off -set from the revenue of salt purchased by bid partners. 24. Consulting Engineers increased from $167,927 in FY 2019 to $207,927 in FY 2020. FY 2018 actual was $93,719. The majority of this line item is for the engineering consulting firm contracted by the Landfill to complete semi-annual IDNR engineer's reports, hydrological monitoring reports, and air permit reports and the management of the landfill gas collection system. An additional $40,000 is included in the Landfill budget in FY2020 for anticipated engineering fees for a corrective action project. 25. Landfill Fees increased from $477,677 in FY 2019 to $498,734 in FY 2020. FY 2018 actual was $488,258. Street Cleaning increased $12,653 based on 1,700 tons of sweeper debris disposed at the Landfill. Solid 'Mste Collection increased $7,089 based on FY 2018 actual tons collected of 11,481 at the estimated FY 2020 fee per ton of $35.49 (3% increase). 26. Payment to Iowa DNR increased from $294,000 in FY 2019 to $304,500 in FY 2020. FY 2018 actual was $283,354. This line item represents the amount paid by the Landfill based on tonnage. FY 2020 is based on 145,000 tons at $2.10 per ton and FY 2019 was based on 140,000 tons at $2.10 per ton. Tonnage increased 5,000 in FY 2020. 27. Pay to Other Agency increased from $233,093 in FY 2019 to $235,588 in FY 2020. FY 2018 actual was $191,579. This line item includes the processing and marketing of recyclable materials $25,245, Landfill quarterly tonnage payments to Delaware county $15,985, Landfill collection and disposal of household, farm and small business chemicals, fluorescent light bulbs, paint and medical sharps $80,737, E -waste contractor for 112 tons of electronics $59,621, Rural Recycling transportation and processing of 10 recyclables drop off sites $54,000. -70- 28. The administrative overhead recharge increased from $1,287,797 in FY 2019 to $1,443,513 in FY 2020. 29. Hauling Services decreased from $75,572 in FY 2019 to $68,630 in FY 2020. FY 2018 actual was $75,697. This line item represents snow removal in the Port of Dubuque ($15,603), snow removal in downtown streets and alleys ($50,000), a private contractor to haul stone from area quarries for the Landfill ($3,027). Machinery & Equipment 30. Equipment replacement items ($352,240) includes: Riverfront Management Shop Equipment $ 500 Leaf Blower $ 1,200 Street and Traffic Lighting Signal Controllers $ 12,000 Shop Equipment $ 1,000 Street Signs and Markings Shop Equipment $ 500 Street Maintenance Backhoe Loader $ 88,000 33,000 GVW Truck with Oil Distributor $ 100,000 Barricades/Signs $ 3,400 Street Cleaning Self -Propelled Lawn Mower $ 550 Weedwhip $ 600 Snow & Ice Control 20" Snow Blower $ 1,200 Sanitary Sewer Maintenance Gas monitor (1) $ 1,500 Jet flusher hose (3) $ 3,500 6" Trash Pump $ 30,000 CCTV Printer (1) $ 250 Refuse Collection Refuse Collection Carts (100) $ 8,000 Cell Phone (1) $ 350 Recycling Collection Program Recycling Bins/Lids (1,074) $ 11,500 Recycling Wheeled Carts (337) $ 18,000 Yard Waste Collection Program Yard Waste Wheeled Carts $ 3,240 -71- Public Works Garage Shop Equipment $ 5,000 Landfill Shop Equipment $ 2,000 Replacement Tarp Assembly $ 12,000 Security Camera Replacements Recommended Improvement Requests $ 10,000 $ 37,950 Total Equipment $ 352,240 Debt Service Debt service reflects annual repayment to ($803,277): Amount Debt Series Source Final Call Purpose Payment Date $ 49,050 G.O. Series 2014B Sales Tax 30% Equipment Replacement 2022 2021 $ 36,390 G.O. Series 2017A Road Use Tax Equipment Replacement 2030 2025 $ 36,002 G.O. Series 2014B Sales Tax 30% Curb Ramp Program 2034 2021 $ 4,747 G.O. Series 2017A Solid Waste Fees Solid Waste Trucks 2030 2025 $ 2,539 G.O. Series 2011A Solid Waste Fees Solid Waste Trucks 2031 2018 $ 13,890 G.O. Series 2018A Sales Tax 20% Radio Replacement 2028 Dubuque County - $ 310,334 G.O. Series 2014 Landfill Fees Landfill Improvements 2034 2022 Dubuque County - $ 350,325 G.O. Series 2016 Landfill Fees Landfill Improvements 2036 2024 $ 803,277 Total Public Works Annual Debt Service Revenue 31. Solid Waste monthly base fees decreased from FY19 Budget of $3,501,625 to $3,488,744 in FY 2020 which is a $12,881 decrease in revenue. This line item is based on FY 2018 actual of $3,372,847 plus the FY 2019 rate increase of 1.70% and the FY 2020 recommended rate increase of 1.63%. 32. Tipper Carts and extra/oversize can subscriptions increased from $452,510 in FY 2019 to $566,143 in FY 2020 based on FY 2018 actual of $514,344 and the addition of 250 additional cart services added in FY 2019. 33. Refuse Single Use Stickers unchanged from $101,457 in FY 2019 to $101,457 in FY 2020 based on a three year average. FY 2018 actual was $105,381. 34. Yard Waste Annual Sticker/Single Use/Brush Ties decreased from $164,761 in FY 2019 to $125,117 in FY 2020 based on a five-year average of all sales. FY 2018 actual was $119,376. -72- 35. Purina Drive Salt Operations represent the purchase and sale of salt for the City and the City's bid partners. The FY 2020 budget includes $151,775 in salt sales, $14,450 in salt handling fees, and $14,250 in salt storage. 36. The Solid Waste Agency payment increased from $4,062,416 in FY 2019 to $4,185,735 in FY 2020. Departmental employees operate the landfill, yard waste, e -waste, recycling drop-off and household hazardous regional collection center facilities owned by the Dubuque Metropolitan Area Solid Waste Agency (DMASWA). Department employees also provide education and communication support services. The department is compensated for all operating expenses incurred. Revenue estimates are based on anticipated tonnages and fee schedule for FY 2020. 37. Garage personnel maintain and repair vehicles and equipment of all city departments and divisions except Airport. Labor costs are assessed using actual time charged out to each department at projected FY 2020 overhead rate of $74.36 which is a 1.50% increase from the FY 2019 overhead rate of $73.26. Revenue is also received from recharges to users for parts and fuel purchased from the vehicle maintenance garage inventory. The following is a summary of the operating expenses and revenues for the City Garage: City Garage Expenses Employee Expense Supplies and Services Garage Stores Machinery and Equipment Total Expenses % Change From FY FY 2018 FY 2019 FY 2020 2019 Actual Budget Requested Budget 1,003,753 173,420 913,248 33,090 1,050,892 1,017,538 127,777 187,639 906,757 982,039 12,170 5,000 2,123,511 2,097,596 2,192,216 Resources Specialized Services 1,164,696 1,164,696 1,255,489 Fuel/Parts 789,531 789,531 813,836 County Fuel Sales 81,521 81,521 93,143 Reimbursements 51,848 51,848 35,698 Total Resources 2,087,596 2,087,596 2,198,166 Annual Operating Surplus (Deficit) (35,915) (10,000) 5,950 Garage Overhead Rate $ 71.58 $ 73.26 $ 74.36 (3.2)% 46.8 % 8.3 % (58.9)% 4.5 % 5.3 ok 15,950 -73- Secretary Public Works Director Accountant Clerk II Part -Time Clerical Street Maintenance Street Signs & Markings Floodwall/Sewer Maintenance • PW Field Supervisor • Foreman (2) • Foreman (4) • Equipment • Eglipment Operator 11 Operators It (6) • Equipment • Equipment Operators 1(5) Operators I (6) • Truck Driven (6) • Utility Workers (5) • Gardener • utility Worker Apprentice • Seasonal Employee • PT Custodian ( Street Lighting/ Signal Maintenance • TraffC1ignal Technicians 11(2) Riverfront Management • Maintenance Worker • Seasonal Laborer -74- I Refuse Collection/Recycling Resource Management coordinator& Supervisor • Lead Sanitation Driver • Sanitation [rivers (19) • Seasonal San. Driver • PT Custodian Landfill/ Composting/ HHMRC Municipal Garage • Solid Waste Agency • Fleet Maintenance Administrator supervisor • Solid Waste Facility • Lead Mechanic (2) supervisor • MCUanite (7) • Foreman • Stock Clerks (2) • Landfill Equipment • Pr custodian operators (5) • Scale operators (2) • Mechanic • Seasonal Employee PUBLIC WORKS The Public Works Department provides for the timely and efficient delivery of numerous essential public services, ensures a safe, pleasant and sustainable community environment, and provides for the effective movement of goods and citizens on city streets. Public Works Administration Street Maintenance Sewer Maintenance Riverfront Maintenance & Operations Vehicle Maintenance Resource Management DMASWA SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING Department planning is focused on greater effectiveness and efficiencies in the maintenance of Dubuque's street, rivertront, and sewer infrastructure, the maintenance of the City's vehicles and heavy equipment, the management of the municipal solid waste and recyclables generated by our citizens, and the management and operation of the DMASWA's facilities. PEOPLE Public Works staff are provided professional development opportunities to improve their knowledge and expertise in order to provide for the development and promotion of public education and customer outreach programs to schools, civic organizations, city councils, county supervisors, and citizens throughout Dubuque and Delaware counties. 1 PARTNERSHIPS In addition to its strong partnerships with the Engineering, Water, Leisure Services, Fire, and Police departments, the Public Works Department partners with numerous state and federal agencies_ It also has contractual partnerships with the City of Asbury, Dubuque County, Scott County, Delaware County, Loras College, the University of Dubuque, the Iowa Northland Regional Council of Governments, Keep Iowa Beautiful, and the Dubuque County Conservation Board. -75- °Peratin9 Salt Rawl use rax Sewer Stprnwater Refuse Landfill PrppenY rax S,ppprt PUBLIC WORKS FY 2018 FY 2019 FY 2020 Full -Time Equivalent 92.09 91.96 91.96 Resources ■ $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 • FY 2018 FY 2019 FY 2020 The Public Works Department is supported by 91.96 full-time equivalent employees, which accounts for 51% of the department expense as seen below. Overall, the department's expenses are expected to decrease by 0% in FY 2020 compared to FY 2019. Expenditures by Category by Fiscal Year Employee Expense Supplies and Services Machinery and Equipment Garage/Stores Administrative OH Debt Service $311,478 $743,911 $352,240 $888,129 $882,360 $957,449 $1,291,784 $1,287,797 $1,443,513 $828,466 $807,230 $803,277 $7,759,123 $8,075,566 $7,935,258 $6,417,386 $6,763,449 $7,203,813 $0 $2,000,000 • FY 2018 $4,000,000 $6,000,000 $8,000,000 FY 2019 • FY 2020 -76- PUBLIC WORKS Public Works Administration Overview The Public Works Director directs and supervises the activities of 91.96 full-time, part-time and seasonal employees including 87 full-time,1 utility worker apprentice, 2 part-time, 4 seasonal workers and 1 shared worker with the Park Division. Those workers are responsible for maintaining and cleaning Dubuque's streets, alleys, sanitary sewers, storm sewers, retaining walls, sidewalks, steps and riverfront. Street and traffic sign repairs, traffic signal and street light maintenance, utility location support, refuse collection, floodwall operations, landfill operations, yard waste collection, DMASWA administrative and education support, large item collection, curbside recycling collection, curb side electronic recycling collection, e -scrap recycling, rural recycling drop-off facilities, composting operations, household hazardous materials regional collection center, landfill methane management, Port of Dubuque facility maintenance, JULE fleet maintenance, and City fleet maintenance are also administered through this activity. The Assistant Public Works Director is also based in this activity, assisting the Public Works Director and managing the department in his absence. Also based in this activity are the department's Account Clerk II, Secretary, and part-time Clerical Assistant. Administration Funding Summary FY 2018 Actual FY 2019 Budget FY 2020 Requested Expenditures $(14,748) $8,569 $3,100 Resources $54 $205 $136 Administration Position Summary FY 2020 Public Works Director 1.00 Assistant Public Works Director 1.00 Account Clerk II 1.00 Secretary 1.00 Clerical Assistant 0.68 Total FT Equivalent Employees 4.68 Highlights Fiscal Years 2016 - 2018 • Received and responded to 6,101 citizen requests for service in FY 2016 • Received and responded to 8,369 citizen requests for service in FY 2017 • Received and responded to 10,522 citizen requests for service in FY 2018 • Received approval by the US Department of Labor for the Utility Worker Apprenticeship Program in FY2018. Future Initiatives • Recruit and retain a highly qualified and well-trained diverse work force • Fill the position of Public Works Utility Worker Apprentice. • Continue to improve the high level of customer service provided to our citizens -77- PUBLIC WORKS Performance Measures Public Works Adm inistration - Activity Statement Provides direction and supervision for all department service activities to provide a safe and aesthetically - attractive community in which to live, work and play. Goal: Financially Responsible, High Performance Organization A Outcome #1: Improved quality of life in the city of Dubuque by providing efficient, effective and timely service delivery to ensure a safe and pleasant community environment. Public Works Department staff provide 24/7 citizen service through 24separate departmental service activities in a timely and responsible manner. This objective is particularly important since the department is not staffed for 24/7 operations supervision. As a result, the workers on the streets and in the sewers are trained to be problem -solvers and authorized to make decisions when the Director/Assistant Public Works Director or Public Works Field Supervisor are not available for on-site command. \nI/ 'X' DID YOU KNOW? The additional services added to the Public Works Department's responsibilities over the last 40 years are: Riverfront Maintenance, Floodwall Operations, Street and Traffic Lights, Utility Location Support, Port of Dubuque Maintenance, Yard Debris and Food Scraps Collection, Large Item Collection, Recyclables Collection, Electronics Collection, Purina Drive Barge Terminal Maintenance, DMASWA Composting Operations, DMASWA Household Hazardous Materials Management, DMASWA Education Outreach, DMASWA Discarded Electronics Recycling, DMASWA Rural Recycling Drop-offs, and, DMASWA Landfill Methane Management. Outcome #2: Provide effective and timely response to citizen requests for information and service in order to avoid disruption in our citizens' daily activities. - Respond to citizen requests for emergency action within one hour. DID YOU KNOW? The Public Works Department received or initiated, and responded to 10,522 WEBQA requests for service in FY2018 which is a 26% (2,153 requests) increase over FY 2017 requests Even though the Public Works Department is not considered a public safety department, our employees are recognized as 'first responders" during many incidents. A citizen who has raw sewage filling the basement of his or her home, or a citizen trying to get to work or the hospital during a blizzard or ice storm, would likely assert that public health, safety, and welfare are at stake. As a result, departmental response must be immediate no matter the time or day. - Respond to citizen requests for information or non -emergency action within 72 hours. Citizens frequently assume that the many essential services provided by the Public Works Department are supported by 24/7 staffing. Since that is not the case, responses to citizen inquiries and requests for non-essential service can take as long as 72 hours to complete. -78- PUBLIC WORKS Street Maintenance Overview Street Maintenance (Funded by Road Use Tax Dollars) Provides for maintaining and repairing 282.28 centerline miles of city streets, curb and gutter, alleys, including 80 green alleys, 8 sets of City steps, 61 sets of City walks, and numerous guardrails and large retaining walls. It also provides for the safe and functional mobility of pedestrians and motor vehicles. Street Cleaning (Funded by Road Use Tax Dollars) Sweeping, flushing and cleaning 282.28 miles of city streets and cutting weeds and brush on City properties and right-of-way ensures attractive and sanitary streets, alleys and other City -owned properties through a systematic street cleaning program utilizing mechanical and vacuum street sweepers, a street flusher/vacuum vehicle, a road kill/ litter/sweeper-debris collection truck, and weed/brush-cutting tractors and mowers. Snow and Ice Control (Funded by Road Use Tax Dollars) This activity is responsible for maintaining an effective and efficient road transportation network by systematically anti -icing, deicing and plowing Dubuque's public streets. It provides for removing snow from the downtown area and from the City -owned steps and walks noted above. Snow plow/deicer routes are determined in advance and priority routes include the city's arterial street network. Anti -icing and deicing operations are initiated and carried out in such a manner as to keep streets safe for motor vehicle travel. Street/Traffic Light Maintenance (Funded by General Fund/Road Use Tax Dollars) Street/Traffic Light Maintenance operates and maintains Dubuque's traffic signal system, which currently contains 115 sets of traffic signals. Dubuque's street Tight system is actually two separate subsystems, with separate ownership and responsibility for maintenance and operation: Alliant-owned street lights total 2,612 with 526 of those lights being high pressure sodium and 2089 being LED lights. The City -owned street light system is made up of 1,006 high pressure sodium and 1148 LED lights, 7 incandescent and 146 MH for a total of 2,307 street lights. All City owned street lights and traffic signals are maintained by the Public Works Department's two traffic signal technicians. Traffic technicians also assist in the -79- installation, maintenance and repair of the City-wide camera system and weather warning siren system. Street Signs and Markings (Funded by Road Use Tax Dollars) This activity is responsible for fabricating new street name signs, repairing damaged traffic and street name signs and poles, and installing all street, traffic, tourist, and informational signs in the city. It also provides for the safe and efficient movement of pedestrians and traffic on Dubuque's streets and alleys through the proper placement, installation and maintenance of the noted signs. -80- PUBLIC WORKS Street Maintenance Funding Summary FY 2018 Actual FY 2019 Budget FY 2020 Requested Expenditures $5,236,415 $6,051,246 $5,964,661 Resources $2,706,354 $3,405,884 $3,263,784 Street Maintenance Position Summary FY 2020 Foreman - Maintenance 2.75 Foreman - Snow and Ice 0.90 Field Supervisor - Maintenance 0.73 Field Supervisor - Snow and Ice 0.17 Truck Driver - Maintenance 3.87 Truck Driver - Snow and Ice 1.00 Truck Driver - Street Cleaning 0.83 Utility Worker - Maintenance 3.85 Utility Worker - Snow and Ice 0.85 Equipment Operator I - Street Signs 0.45 Equipment Operator I - Maintenance 3.88 Equipment Operator I - Snow & Ice 1.72 Equipment Operator I - Street Clean 0.00 Equipment Operator II - Traffic 0.02 Equipment Operator II - Street Signs 0.85 Equipment Operator II - Maint. 0.94 Equipment Operator II - Snow & Ice 1.12 Equipment Operator II - Street Clean 3.21 Assistant Horticulturist - Maint 0.25 Assistant Horticulturist - Snow and Ice 0.17 Custodian 1 0.38 Laborer - Street Signs 0.67 Utility Worker Apprentice 1.00 Laborer - Street Cleaning 0.36 Maintenance Worker - Maintenance 0.07 Maintenance Worker - Snow 0.16 Traffic Signal Technician II - Street Sign 0.01 Traffic Signal Technician II - Snow 0.12 Traffic Signal Technician II - Traffic 1.86 Total FT Equivalent Employees 32.19 Highlights of Fiscal Years 2014-2018 • Completed asphalt overlay projects on 34 streets equaling 6.29 centerline miles in calendar 2015, 50 streets equaling 7.11 miles in 2016, on 43 streets equaling 7.64 miles in 2017 and on 29 streets equaling 5.14 centerline miles in 2018 • Completed full depth concrete repairs on 17 streets in calendar 2015, on 10 streets in 2016 ,10 streets in calendar 2017 and on 11 streets in 2018 -81- PUBLIC WORKS • Assisted in the installation of 106 ADA curb ramps (105 constructed by contractors and 1 by Public Works staff). Asphalt required at all curb ramp installations was installed by Public Works. Future Initiatives - Identify and adopt new technologies which will improve the effectiveness and efficiency of Dubuque's snow and ice control program • Reduce the quantity of deicing chemicals applied per lane mile on Dubuque's streets without reducing the City's current high standard of snow and ice control service. ▪ Evaluate the additional use of alternative fuel powered maintenance vehicles. Performance Measures Street Maintenance - Activity Statement Provide for the safe and efficient movement of motor vehicles on City streets and alleys and the safe movement of pedestrians on public sidewalks and steps maintained by the department. Also, safeguard public health and provide for the general welfare of residents and visitors to the community through street sweeping and weed -cutting on City -owned properties and along City right-of-way. oal: Connected Community Outcome #1: Provide an effective and efficient road transportation network. - Cl Asphalt overlay 5 centerline miles of streets in fiscal year 2020. In calendar year 2018 a 5.14 mile overlay project was completed. The Public Works Department's asphalt paving program provides for safe, smooth, and well-maintained streets by correcting pavement deficiencies, extending the useful life of City strccts, and thereby delaying the need for costly street reconstruction projects. In FY20, five (5) centerline miles of streets will be paved, along with constructing ADA -compliant cuts tamps to meet the updated guidelines for curb ramp construction on strccts receiving an asphalt overlay. -82- 'DID YOU KNOW? Studies show that for every $1 spent on street pavement preventive maintenance projects, it would cost $4 to $5 more if those preventive maintenance projects were delayed and more extensive pavement rehabilitation is needed at a later time. PUBLIC WORKS SNOWAND ICE CONTROL - DID YOU KNOW? The City has a Snow Plow Progress Mapping system. Visit www.cityofdubuque/snow for additional information. - C5PIow open for safe travel arterial streets within 18 hours and residential streets within 48 hours of the cessation a winter storm. This program provides for the safe and efficient movement of motor vehicles and public safety vehicles throughout the city during and after winter stotm events. - Maintain an effective and efficient pedestrian walkway network by clearing City -maintained walks in a timely and efficient manner after winter storms. This program provides for safe movement of pedestrians on City walks and steps after winter storms. Winter Season 2013/2014 2014/2015 2015/2016 2016/2017 2017/2018 Number of Storms 42 19_ 15 12 26 Total Seasonal Snowfall 63.3" 33.7' 34.8" 27.1" 38.2 Salt Used for De-icing 13,411 tons 5,346 tons 3,242 tons 3,474 tons 5,749 tons Citizen Requests During the winter of 2017-2018, the department received a total of 325 Web Q/A requests for service related to snow and ice control. By responding to these requests for service in a timely manner, our citizens are provided a safe environment in which to commute to work, school, and home. -83- PUBLIC WORKS Strategies Anti -icing: Under certain conditions, the use of liquid deicers for pre -storm anti -icing application is often the most cost effective and environmentally safe practice for snow and ice control. Pre - storm anti -icing operations require approximately 25% of the material at 10% of the overall cost when compared to standard storm post -onset de-icing methods. The total amount of liquid deicer used for anti -icing operations during the winter of 2017-2018 was 31,959 gallons. De-icing: The department's FY20 budget requests include funds for labor and equipment to maintain 24/7 plowing and de-icing operations during winter storm events and for the purchase of 5,500 tons of roadway deicer salt at an estimated cost of $60.71/ton. Outcome #2: Provide clean and attractive streets and neighborhoods by maintaining City Right -of -Way (ROW) and properties. In order to provide our citizens and visitors an aesthetically attractive and sanitary community environment, Public Works Department crews sweep streets and downtown alleys, and also cut grass, weeds and brush on City properties and along City right-of-way. Street cleaning not only removes debris and litter from street gutters, but prevents those materials from entering the storm sewer system, which drains into the Mississippi River. Outcome #3: Safe and efficient movement of pedestrians and vehicles on Dubuque's streets and alleys is aided by the proper placement, installation, and maintenance of traffic signals, street lights, street signs, and traffic signs. This activity safeguards public health, safety and general welfare through the installation and maintenance of all traffic control equipment and related electrical systems. Public safety is also assured by maintaining all City -owned strcct lighting and street cameia equipment, including Tight heads, poles, and wiling systems. 115 traffic signal installations and 2307 City - owned high pressure sodium and LED strcct lights are maintained by the department's two technicians. DID YOU KNOW? The Public Works Department, under the guidance of the Engineering Department, is replacing City -owned high pressure sodium street lights with LED street lights. The new LED street lights are more energy efficient and have a longer life span. Sign Replacement Program In calendar 2018, 94 street names, 27 JULE, and 723 other types of traffic control signs and posts were installed or replaced at various locations throughout the city. -84- PUBLIC WORKS Sewer Maintenance Overview Sewer Maintenance provides for a safe and clean municipal environment by inspecting, cleaning and repairing Dubuque's sanitary and storm water sewers. Dubuque's sanitary sewer system 309 miles of gravity -flow pipe and 7,642 manholes. Department workers also inspect, clean and repair Dubuque's stormwater sewer system, which consists of 152 miles of pipe, 6,301 catch basins, and 1,997 manholes. Sewer Maintenance Funding Summary FY 2018 Actual FY 2019 Budget FY 2020 Requested Expenditures $1,013,347 $1,071,839 $1,016,780 Resources $1,013,347 $1,071,839 $1,016,780 Sewer Maintenance Position Summary FY 2020 Foreman - Sanitary 1.31 Foreman - Storm 0.73 Field Supervisor - Storm 0.00 Equipment Operator 1 - Sanitary 3.38 Equipment Operator 1 - Storm 1.12 Equipment Operator 11 - Sanitary 0.72 Equipment Operator II - Storm 0.10 Truck Driver - Sanitary 0.30 Utility Worker - Sanitary 0.30 Total FT Equivalent Employees 7.96 Highlights of Fiscal Years 2016 - 2018 • Cleaned or Inspected 74.3 miles of the sanitary sewer system pipe in calendar 2016 (through 11/1/16) • Cleaned or Inspected 143 miles of the sanitary sewer system pipe in calendar 2017 (through 11/30/17) • Cleaned or Inspected 73.68 miles of the sanitary sewer system pipe in calendar 2018 (through 12/20/18) Future Initiatives • Identify and adopt new techniques to improve the department's maintenance of the City's sanitary sewer system, in conformance with USEPA guidelines. -85- PUBLIC WORKS Performance Measures Sewer Maintenance - Activity Statement Provides for a safe and clean municipal environment by inspecting, cleaning and repairing Dubuque's sanitary and storm water sewer systems. t- 4Goal: Sustainable Environment Outcome #1: Reduce the number of sanitary sewer basement back-ups and non - basement sanitary sewer overflows attributed to compromised City sewer lines. With the goal of reducing sanitary sewer overflows and basement back-ups, the Public Works Department routinely cleans 25 miles of pipe previously identified and classified as warranting predictive/preventive maintenance. The department will also clean and inspect at least an additional 50 miles of City gravity -flow sanitary sewer pipe not scheduled for annual maintenance. Timely Response to Sanitary Sewer Service Requests The Public Works Department provides 24/7 response to sanitary sewer service requests. Most requests are responded to in less than one hour from the time of receiving the request to arriving at the scene, including nights, weekends and holidays. Year 2014 2015 2016 2017 2018 Total Service Requests: 126 96 96 97 106 Private Sewer Problems 110 85 84 86 93 City Sewer Problems 16 11 12 11 13 Root Control intrusive tree roots in a sanitary sewer line are one of the main causes of sanitary sewer overflows and basement back-ups. The Public Works Department manages an annual intrusive root -killing program, with the actual work performed by an expert private contractor. A total of 7,262 feet of pipe was treated in 2018. 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 Root Control 15909 13381 12139 Root Rot *2014 82015 w 201 w 201 12680 -86- PUBLIC WORKS Outcome #2: Ensure contractors' and developers' compliance with City specifications by completing post -construction inspection of new or repaired sanitary and storm sewer infrastructure In order to ensure contractor compliance with City specifications, all newly -constructed or repaired sanitary and storm sewer infrastructure will be inspected with closed-circuit television equipment (CCTV). DID YOU KNOW? The Public Works Departments digital sewer inspection reports, along with sewer construction documents, are both linked to the City's Geographic Information System (GIS) . Year 2015 2016 2017 2018 Total sewer pipe inspection footage using CCTV equipment 85,387 65,936 95,383 39,594 Riverfront Maintenance and Operations Overview Riverfront Maintenance and Operations provides for the Public Works Department's maintenance of: • over 6.5 miles of riverfront shoreline and two public boat ramps; • accessible and aesthetically -attractive municipal waterfront areas that can be fully utilized by recreational, commercial and industrial interests; • Dubuque's 5.8 mile long flood control system, which includes four permanent and one temporary pumping facilities, four auxiliary power generators, one harbor closure gate system, twelve storm sewer closure gates, five 16' vehicle access gates, and two 4' pedestrian access gates; and, • American Trust River's Edge Plaza, the Alliant Energy Amphitheater, the Mississippi Riverwalk, the Port of Dubuque's parking lots, the Riverwalk boat -mooring quay, the Port's shoreline, and other City -owned infrastructure in the Port of Dubuque. Lighting, sweeping, watering, landscaping, mowing, snow clearing, and other maintenance along Dubuque's entire riverfront are also provided as needed and required. Riverfront Maintenance and Operations Funding Summary FY 2018 Actual FY 2019 Budget FY 2020 Requested Expenditures $429,995 $448,485 $447,533 Resources $6,755 $9,345 $6,755 -87- PUBLIC WORKS Riverfront Maintenance and Operations Position Summary FY 2020 Foreman 0.31 Field Supervisor - Floodwall 0.10 Equipment Operator I 0.10 Equipment Operator I 0.25 Equipment Operator II - Riverfront 0.10 Equipment Operator II - Floodwall 0.04 Maintenance Worker - Riverfront 0.50 Maintenance Worker - Floodwall 0.02 Maintenance Worker - POD 0.25 Laborer- Riverfront 0.21 Laborer- Floodwall 0.13 Laborer- POD 0.46 Traffic Signal Technician 0.01 Total FT Equivalent Employees 2.48 Highlights of the Past Year • Provided staff support in preparation for Americas River Festival in the Port of Dubuque • Provided pre -event preparation for 56 private and public events held in the Port of Dubuque in 2018 Future Initiatives • Provide design input and recommendations for the improvement of the landing area for large capacity passenger riverboats in the Port of Dubuque Performance Measures Riverfront Maintenance and Operations -Activity Statement Provide for safe, accessible and aesthetically -attractive municipal waterfront areas for full utilization by recreational, commercial and industrial interests. Goal: Experiences and Activities Outcome #1: Provide maintenance of riverfront shoreline, including the Port of Dubuque, to ensure that citizens and visitors can enjoy the Mississippi River and the Port's many amenities. -88- PUBLIC WORKS A high level of maintenance at the City's two public boat launch/landing facilities, along Dubuque's shoreline, and in the Port of Dubuque provides our citizens and visitors aesthetic and safe access to and enjoyment of the Mississippi River. Outcome #2: Provide flood protection to the community by maintaining and operating the City's 5.8 mile long flood control system. Make continual improvements to the City's flood control system infrastructure through the acquisition of temporary flood barriers, re-establishment of operational easements, and conducting a study which would provide contingency plans and secondary protection measures for essential public infrastructure. Provide timely closing of the floodwall's access gates and storm sewer outlets, mobilizing and operating its portable 10" pumps, and operating the flood control system's four permanent pumping stations - all vital components of Dubuque's flood control system. Protecting Dubuque's tremendous public and private investment in its Mississippi River floodplain area, which is vital not only to preserving its economic base, but also ensuring that many of its older residential neighborhoods are not compromised and rendered uninhabitable. Vehicle Maintenance Overview Vehicle Maintenance maintains and repairs the City's fleet of 584 trucks, buses, heavy equipment, automobiles, and other machinery. Machinery, vehicles, and equipment maintained include the major fleets belonging to the Public Works, Police, Fire, and Water departments, along with the buses of the JULE public transit system. Vehicle Maintenance Funding Summary FY 2018 Actual FY 2019 Budget FY 2020 Requested Expenditures $ 2,136,484 $ 2,097,596 $ 2,192,216 Resources $ 2,214,903 $ 2,087,596 $ 2,198,166 -89- PUBLIC WORKS Vehicle Maintenance Position Summary FY 2020 Equipment Maintenance Supervisor 1.00 Lead Mechanic 2.00 Mechanic 7.00 Stock Clerk 2.00 Custodian 1 0.15 Total FT Equivalent Employees 12.15 Highlights of the Past Year • Implemented shop safety protocol (mandatory safety glasses, marked walk ways) • Established weekly safety meetings • Technician training increased from 125 total hours to 232 total training hours. • Sweeper and solid waste factory trainers conducted on-site training for shop technicians. • Develop and implement a City wide fleet replacement evaluation rating system. Future Initiatives • Recruitment and retention of experienced heavy equipment and diesel engine mechanics. Technician training schedule developed for web based training, advanced electrical and drivability training scheduled. Work with vendors to provide equipment specific training. Performance Measures Vehicle Maintenance - Activity Statement Maintain and repair the City's fleet to ensure safe and efficient operation of all City -owned vehicles and provide 24/7 support as needed during during storm events and other emergency operations. *Goal: Financially Responsible, High Performance Organization A Outcome: City vehicles and heavy equipment are always ready to provide timely service to the public in a cost-effective manner. The Public Works Department maintains the entire City fleet in its entirety except for the vehicles belonging to the Airport Department. The department insures that public safety vehicles, Police/Fire and snow and ice control in the winter; are ready to respond to any emergency at any time to protect the public from bodily harm and property damage. The department's nine mechanics will receive annual training annually to keep current in the latest automotive and equipment technologies. While private sector service providers are not available to service an ambulance, fire truck, police cat; or snow plow truck at 3AM on a -90- PUBLIC WORKS Sunday, Christmas Day, etc. the Public Works mechanics provide this support as needed 24/7. Continual training of our mechanics, especially regarding the technologies incorporated into those vehicles, is especially important. The department continues to evaluate the use of compressed natural gas (CNG) as a vehicle fuel for the City's heavy trucks, pickup trucks, SUVs, and automobiles. Three Cityldepartment goals are the commitment to reduce the City fleet's carbon footprint, improve the fleet's overall fuel efficiency, and reduce the City's reliance (vulnerability) on fuels from outside the USA. The department will continue to explore/evaluate the use of CNG vehicle fuel, hybrid power and plug-in powertrain technologies for future City vehicles. The Public Works department is currently operating the following CNG vehicles : 1 -Tandem axle plow truck, 1 -single axle street truck, 1-% ton pickup truck. In 2019 our first hybrid diesel/ electric bucket truck will be placed into service. The City garage will continue to evaluate CNG and electric/hybrid powered equipment with the commitment to reduce the City fleet's carbon footprint across all departments. -91- PUBLIC WORKS Solid Waste Resource Management Overview The Solid Waste Resource Management Activity provides City curbside collection services that reduce public health risks and improve community livability, while seeking to optimize materials diversion away from landfilling. The Public Works Department provides equitable refuse collection and disposal service to over 20,000 residential and small business customers through the City's Pay -As -You Throw (PAYT) program. It also monitors City compliance with all collection -related environmental and safety regulations, facilitates community aesthetic improvements, and assists in the protection of Dubuque's environment. This activity also provides for the efficient collection of recyclable materials. Recycling bins and/or carts are provided to City's customers for the recycling of a full spectrum of paper, plastic and metal materials. The third activity offered to City customers is the large item collection which includes the collection of furniture, appliances, electronics and/or other bulky items for subsequent recycling or landfill disposal. The curbside collection of yard debris materials (grass, leaves and brush), food scraps, and compostable paper is the activity's fourth service. Resource Management Funding Summary FY 2018 Actual FY 2019 Budget FY 2020 Requested Expenditures $3,911,991 $3,914,284 $3,949,508 Resources $4,237,240 $4,340,310 $4,400,323 Resource Management Position Summary FY 2020 Resource Management Coordinator 1.00 Lead Sanitation Driver 1.00 Sanitation Driver 17.00 Sanitation Laborer 1.00 Custodial 1 0.08 Seasonal Sanitation Driver 0.67 Total FT Equivalent Employees 20.75 Highlights of the Past Year • The purchase and distribution of 1310 large (95 gallon) wheeled carts to its recycling customers. • The department introduced curb side electronics collection to the City's large item collection program to offer city customers a more convenient and accessible service to manage electronics. • Over 783 customers downloaded the Rethink Waste mobile device app. -92- PUBLIC WORKS Future Initiatives • Evaluate and implement next steps in the Performance Analysis of the Solid Waste Operations and Rate Review study. • Improve pedestrian recycling through color -coding and improve signage. • Implement one-year civil service testing to advance equity through workforce recruitment and retention efforts. • Design and implement fully automated collection for refuse (only) in designated area. • The department is continuing to explore how we deliver service to ensure we are delivering equity municipal service. • The department is continuing to improve the possible future use of 100% Bio CNG - fueled collection vehicles. • The department is evaluating the greater use of City -owned mechanically tipper carts for the collection of refuse, recyclables, and yard/food debris. Performance Measures Resource Management -Activity Statement Provides efficient and comprehensive residential curbside collection services for the disposal of garbage and bulky items, and, the diversion and reuse of recyclables, electronics, yard debris, food scraps and other food - related compost. P( Goal: Sustainable Environment Outcome #1: Increase the percentage of collected municipal solid waste diverted from landfill disposal. What does this mean to the citizens of Dubuque? By diverting materials from landfilling, the City advances the goal of 50% by 2030 Greenhouse Gas Reduction. Reduction can extend the future capacity for local landfilling by years. -93- 80% 70% 60% 50% 40% 30% 20% 10% 0% 69% PUBLIC WORKS Total Municipal Materials Collected 70% 71% 71% 72% 23% 22% 21% 21% 20% 8% 8% 8% 8% 8% FY 14 FY 15 FY16 FY17 FY18 -Refuse -Yard Debris -Recycling Outcome #2: Increase expanded use of City owned wheeled collection carts. What does this mean to the citizens of Dubuque? Being responsive to city customer needs and calls for City service. 1400 1200 1000 800 600 400 200 0 Cart Subscribers Per Yr 1321 967 635 505 423 333 14 15 16 17 18 X64 -Gal X96 -Gal -94- 363 PUBLIC WORKS Dubuque Metropolitan Area Solid Waste Agency (DMASWA) Overview This activity provides a wide range of municipal solid waste management options to citizens and businesses in the tristate region through the Public Works Department's contracted operation and management of the DMASWA's facility and programs, which are owned by the 28E partnership of the City and County of Dubuque. The DMASWA's landfill is designed for the disposal of municipal solid waste, serves Dubuque, Delaware, Grant, and Jo Daviess counties, and is operated in conformance with state and federal environmental laws and permits. The DMASWA composts yard waste, food scraps, and compostable paper brought to it by some of its Dubuque and Delaware county customers. The operation and management of the DMASWA's Household Hazardous Materials Regional Collection Center (HHMRCC) provides convenient, no -fee, drop-off household hazardous materials disposal services to Dubuque and Delaware county residents from April through October. The DMASWA's electronic waste collection program accepts (e -scrap), old TVs, cell phones, computer related equipment, and batteries, year-round. Management and operational support is provided for the DMASWA's ten (10) recyclables drop-off facilities in Dubuque county (Cascade, Key West, Dyersville, Farley, Epworth, Durango, St. Catherine, and Dubuque) to increase access for opportunities for the diversion and recycling of paper, cardboard, metals, and plastics. This activity also manages and operates the DMASWA's landfill gas collection system. Landfill gas is mainly comprised of methane which is also known as natural gas. The Agency's landfill gas collection system currently burns the methane to ensure destruction of this most potent greenhouse gas. The Agency's near-term plans/options for the methane's future beneficial use include using this renewable energy source beneficially offsetting non- renewable fossil fuels DMASWA Funding Summary FY 2018 Actual FY 2019 Budget FY 2020 Requested Expenditures $3,822,998 $3,856,650 $4,002,934 Resources $3,822,998 $3,856,650 $4,002,934 DMASWA Position Summary FY 2020 Solid Waste Agency Administrator 1.00 Landfill Supervisor 1.00 Foreman 1.00 Equipment Operator II 2.00 Landfill Equipment Operator 3.00 Landfill Equipment Operator -Seasonal 0.75 Mechanic 1.00 Scale House Operator 2.00 Total FT Equivalent Employees 11.75 -95- PUBLIC WORKS Highlights of the Past Year • The DMASWA is implementing expansion of its customer base into Illinois and Wisconsin in order to increase its revenue stream and thereby keep future fee increases moderate and within the means of its current customers. In FY16, the Agency completed a new Master Site Plan process, and its Directors approved a schedule for interim and long-term facility improvements. Design of the interim plan has been placed on hold because of the Iowa DOT Swiss Valley Interchange Project will eliminate the DMASWA's current entrance. • The Agency recently opened bicycle and small engine equipment drop -off -for -reuse. • In FY15, the Agency established a new working partnership with the Greater Dubuque Development Corporation to assist it with marketing its landfill methane. • In FY16, the Agency partnered with Dubuque County to borrow $5.1 million for construction of Cell #9's Phase III. The project was subsequently completed in December 2017. • In March of 2018 release an RFQ/P to request proposals from developers for the development of a renewable natural gas (RNG) project at the Agency's facility. In December the Agency entered into an agreement with Trillium for a renewable gas project. • In 2018 staff successfully negotiated an agreement for the sale of property to the Sate of Iowa Department of Transportation related to the Swiss Valley intersection project. Future Initiatives • To identify and secure a beneficial end use of the Agency's landfill methane to continue to reduce greenhouse gas emissions in the region. • To replace the 1976 shop with a new modern maintenance shop that will meet the DMASWA's needs into the future. • To design and construct a new small vehicle off-loading facility. • To improve the traffic patterns to decrease customer wait times and time at the facility. • To recruit additional non-planning/service area tonnage to minimize or eliminate future borrowing and provide a stable fund source for non -revenue positive services, such as HHMRCC services and recycables drop off program. • Identify and implement more operational efficiencies to ensure all resources, human, financial and environmental, are maximized. -96- PUBLIC WORKS Performance Measures Dubuque Metropolitan Area Solid Waste Agency -Activity Statement Provide administrative, planning and operational support to the Dubuque Metropolitan Area Solid Waste Agency (DMASWA), a 28E partnership of the City and County of Dubuque, through the operation of the DMASWA's municipal solid waste landfill, yard debris and food scraps composting facility, household hazardous materials management facility, recycling drop -of facilities, landfill methane system, and, appliance/ metals/tire/electronics recycling programs. Goal: Sustainable Environment Outcome #1: Maintain the financial integrity of the DMASWA in order to continue to provide easily accessible and affordable municipal solid waste management services to the region. DID YOU KNOW? The DMASWA's landfill and other services are not tax -supported. The fees paid by the Agency's Iowa, Illinois, and Wisconsin customers to use its facilities are the only revenue it receives. The Agency faces the daunting prospect of spending $10,000,000 plus on major capital projects over the next five years. As a result, it will have to borrow most of those monies. Increased diversion by local customers of materials from Iandfllling, if not compensated through the expansion of the Agency's customer base, could result in a significant Toss of revenue and even more Agency debt. Resulting in higher service fees, reduced services and decrease support for non -revenue positive diversion programs. DID YOU KNOW? The DMASWA Landfill serves not only all of Dubuque county, but also all of Delaware county and many homes and businesses in Grant and Jo Daviess counties. Expand the DMASWA's customer base In order to ensure that the Agency's facilities and services are financially sustainable in future years, its current customer base must be maintained and new customers added. If the Agency's substantial near -teen capital project costs are not supported by a broader customer base, more monies will have to be borrowed and future fee increases will be more frequent and substantial. Identify a financially -sustainable use for the Agency's landfill methane. Whether burned now in the Agency's flare station or used in future years to fuel vehicles, injected into Black Hills' regional pipeline grid, heat Agency buildings, heat the building of a new employer in Dubuque's adjoining industrial park, or generate electricity, the DMASWA's methane is not being vented into the atmosphere - thereby significantly reducing the DMASWA Landfill's grccnhouse gas emissions. The key challenge is to ensure that any future methane beneficial use system is one that the Agency can afford. -97- This page intentionally left blank. -98- Recommended Operating Revenue Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title 400 670 43110 43,110 INVESTMENT EARNINGS INVESTMENT EARNINGS IFY17 Actual Revenue FY18 Actual Revenue FY19 Adopted Budget FY20 Recomm'd Budget 490 7,476 0 10,173 0 7,413 0 10,000 43 USE OF MONEY AND PROPERTY - Total 7,966 10,173 7,413 10,000 100 810 44,405 44,405 FEMA PUBLIC ASSISTANCE FEMA PUBLIC ASSISTANCE 0 0 7,006 1,294 0 0 0 0 44 INTERGOVERMENTAL - Total 0 8,300 0 0 940 940 45701 45,731 STATE GRANTS IA DNR RCC OPERATION 1,000 15,553 0 0 10,000 0 0 0 45 STATE GRANTS - Total 16,553 0 10,000 0 810 46,105 FUEL SALES, COUNTY 81,521 93,143 81,521 93,143 46 LOCAL GRANT AND REIMBURSE - Total 81,521 93,143 81,521 93,143- 670 51215 LATE PAYMENT PENALTY 610 51250 SEWER TV SERVICE CHARGES 670 51605 SOLID WASTE MONTHLY FEE 670 51606 SOLID WASTE REFUSE CREDIT 670 51610 TIPPER CARTS 670 51615 EXTRA/OVERSIZE CAN SUBSCR 670 51620 REFUSE SINGLE USE REFUSE 670 51630 YARD WASTE STICKER ANNUAL 670 51635 YARD WASTE SINGLE USE STI 670 51640 YARD WASTE BRUSH TIE SALE 670 51641 SUBSCRIPTION RECYCLING 670 51642 FOOD SCRAP 670 51645 LEAF RAKE OUT FEES 670 51650 LARGE ITEM PICKUP FEES 940 51655 CUSTOMER FEES, HHMRCC 940 51660 SOLID WASTE AGENCY PMT 670 51665 RECYCABLE SALES 940 51675 LANDFILL FEES -CASH 940 51687 MRF REVENUE 100 51910 STATE HIGHWAY MAINT 100 51956 PAVILION FEES 680 51975 SALE OF SALT 680 51976 SALT HANDLING FEE 680 51977 SALT STORAGE FEE 680 51978 TARPING FEE 52,056 5,106 3,410,894 (47,038) 322,773 96,497 101,457 30,285 98,692 2,750 3,548 8,403 5,136 22,770 131 0 10,069 162 323 3,749 9,345 72,530 7,164 5,679 1,514 55,553 1,206 3,421,889 (49,042) 431,202 83,141 105,381 27,271 89,738 2,367 3,542 9,412 4,563 27,212 0 0 3,247 0 0 22,896 6,755 75,033 9,221 10,058 1,961 52,056 8,076 3,548,663 (47,038) 356,013 96,497 101,457 30,285 131,726 2,750 3,548 8,403 5,136 24,770 0 4,062,416 10,069 0 0 24,770 9,345 90,440 11,440 9,000 2,500 55,553 5,969 3,537,786 (49,042) 491,981 74,162 101,457 31,305 91,053 2,759 3,542 9,412 4,563 23,196 0 4,185,735 3,247 0 0 26,644 6,755 151,775 14,450 14,250 0 51 CHARGES FOR SERVICES - Total 4,223,995 4,342,607 8,542,322 8,786,552 250 53201 REFUNDS 670 53201 REFUNDS 670 53204 IOWA FUEL TAX REFUND 810 53204 IOWA FUEL TAX REFUND 810 53530 SPECIALIZED SERVICES 810 53570 FUEL/PARTS INTERNAL SVC 940 53605 MISCELLANEOUS REVENUE -99- 15,000 1,680 604 48,873 1,135,955 789,531 580 0 2,358 588 32,512 1,184,778 899,765 0 0 0 604 48,873 1,164,696 789,531 0 0 2,358 0 32,512 1,255,489 813,836 0 Recommended Operating Revenue Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Revenue FY18 Actual Revenue FY19 Adopted Budget FY20 Recomm'd Budget 670 53,610 INSURANCE CLAIMS 940 53,610 INSURANCE CLAIMS 100 53,615 DAMAGE CLAIMS 100 53,620 REIMBURSEMENTS -GENERAL 250 53,620 REIMBURSEMENTS -GENERAL 610 53,620 REIMBURSEMENTS -GENERAL 670 53,620 REIMBURSEMENTS -GENERAL 810 53,620 REIMBURSEMENTS -GENERAL 940 53620 REIMBURSEMENTS -GENERAL 670 53,630 SALES TAX COLLECTION 757 2,965 16,433 5,094 4,574 2,349 403 77 4,940 7,555 0 0 29,612 27,747 3,913 549 1,086 226 901 7,558 0 0 19,034 3,695 3,765 0 403 77 0 7,555 0 0 21,681 2,680 4,860 549 220 0 0 6,771 53 MISCELLANEOUS - Total 2,037,369 2,191,591 2,038,233 2,140,956 250 54,104 SALE OF ASSETS OTHER 100 54,109 SALVAGE SALES 610 54,109 SALVAGE SALES 620 54,109 SALVAGE SALES 810 54,109 SALVAGE SALES 100 54,110 SALE OF SIGNS AND MARKING 400 54210 GO BOND PROCEEDS 670 54210 GO BOND PROCEEDS 400 54220 BOND DISCOUNT 670 54220 BOND DISCOUNT 500 2,274 1,885 0 2,898 566 396,824 51,165 12,782 1,648 0 540 2,621 42 3,186 543 0 27,600 0 400 0 1,659 1,885 0 2,898 2,768 0 0 0 0 0 540 2,621 0 3,186 543 0 0 0 0 54 OTHER FINANCING SOURCES - Total 470,541 34,932 9,210 6,890 400 59,250 FR ROAD USE TAX 400 59300 FR STREET CONSTRUCTION 400 59350 FR SALES TAX CONSTRUCTION 37,177 85,973 0 37,097 89,100 0 36,143 87,076 13,989 36,390 85,052 13,890 59 TRANSFER IN AND INTERNAL - Total 123,150 126,197 137,208 135,332 PUBLIC WORKS - Total I 6,961,095 I 6,806,943 I 10,825,907 I 11,172,873 -100- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 100 250 610 620 630 670 810 820 940 100 250 670 810 100 250 610 620 670 940 100 250 610 620 670 810 940 100 250 610 620 670 810 940 100 250 620 670 810 940 100 250 610 620 670 61010 61010 61010 61010 61010 61010 61010 61010 61010 61020 61020 61020 61020 61030 61030 61030 61030 61030 61030 61050 61050 61050 61050 61050 61050 61050 61071 61071 61071 61071 61071 61071 61071 61091 61091 61091 61091 61091 61091 61092 61092 61092 61092 61092 FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES PART-TIME EMPLOYEES PART-TIME EMPLOYEES PART-TIME EMPLOYEES PART-TIME EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES OVERTIME PAY OVERTIME PAY OVERTIME PAY OVERTIME PAY OVERTIME PAY OVERTIME PAY OVERTIME PAY HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME SICK LEAVE PAYOFF SICK LEAVE PAYOFF SICK LEAVE PAYOFF SICK LEAVE PAYOFF SICK LEAVE PAYOFF SICK LEAVE PAYOFF VACATION PAYOFF VACATION PAYOFF VACATION PAYOFF VACATION PAYOFF VACATION PAYOFF 526,766 547,021 1,240,641 1,259,773 250,963 286,492 137,072 112,613 317 591,514 1,471,212 333,431 110,152 603,445 1,525,649 342,859 112,866 1,035,901 1,046,103 1,099,744 1,13 5,83 0 655,300 630,367 676,995 699,835 2,221 632,593 599,836 665,531 681,513 13,482 14,351 17,658 18,058 13,066 13,209 17,855 18,263 9,255 9,356 3,759 3,845 7,048 7,209 20,207 30,507 35,649 36,456 8,410 4,843 8,474 8,670 52 284 160 22 16,317 16,095 20,963 21,444 109 23,466 24,004 38,434 39,306 35,241 35,241 126,784 205,551 136,000 156,000 3,952 42,002 10,250 10,250 1,119 2,450 2,050 2,050 18,336 22,496 21,400 21,400 10,886 21,536 28,250 28,250 44,981 28,883 71,200 71,200 5,700 2,721 4,100 4,100 23,811 21,369 13,050 13,050 612 4,340 750 750 103 30,611 22,134 19,700 19,700 1,869 1,745 3,000 3,000 19,596 8,920 16,500 16,500 15,326 15,793 15,793 15,793 17,768 20,450 17,840 11,258 1,319 1,491 5,784 539 2,006 4,345 4,345 21,088 18,800 16,109 716 11,365 11,551 4,333 2,411 -101- 9,352 7,575 9,693 12,952 4,513 8,207 1,170 6,090 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 810 61092 940 61092 100 61310 250 61310 610 61310 620 61310 630 61310 670 61310 810 61310 820 61310 940 61310 100 61320 250 61320 610 61320 620 61320 630 61320 670 61320 810 61320 820 61320 940 61320 100 61410 250 61410 610 61410 620 61410 630 61410 670 61410 810 61410 820 61410 940 61410 100 61415 250 61415 610 61415 620 61415 670 61415 810 61415 940 61415 100 61416 250 61416 610 61416 620 61416 630 61416 670 61416 810 61416 820 61416 VACATION PAYOFF VACATION PAYOFF IPERS IPERS IPERS IPERS IPERS IPERS IPERS IPERS IPERS SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE WORKMENS' COMPENSATION WORKMENS' COMPENSATION WORKMENS' COMPENSATION WORKMENS' COMPENSATION WORKMENS' COMPENSATION WORKMENS' COMPENSATION WORKMENS' COMPENSATION LIFE INSURANCE LIFE INSURANCE LIFE INSURANCE LIFE INSURANCE LIFE INSURANCE LIFE INSURANCE LIFE INSURANCE LIFE INSURANCE -102- 2,070 2,840 53,052 53,994 125,574 134,163 22,819 29,785 12,350 10,294 26 64,584 155,430 32,515 10,591 65,827 160,635 33,405 10,849 99,161 99,019 110,034 113,492 59,657 58,496 67,523 69,695 198 62,257 57,061 73,320 74,882 46,348 48,368 53,546 54,555 106,277 112,335 127,328 131,037 18,729 24,602 26,348 27,070 10,220 9,108 8,698 9,233 23 - - 81,681 81,642 89,497 92,299 50,971 49,033 55,955 56,534 166 51,983 46,869 59,751 60,863 141,102 138,871 126,935 96,114 390,467 419,511 390,803 295,931 89,857 94,445 86,001 65,125 29,796 29,097 27,908 21,132 94 - - 339,827 325,948 286,200 216,719 190,751 190,799 171,720 130,032 409 174,429 174,899 15 7, 416 119,189 24,922 22,929 17,718 16,032 146,494 151,947 127,143 126,541 13,271 13,228 10,033 7,924 4,126 4,041 3,162 2,597 142,596 129,359 112,940 102,426 25,405 25,138 19,741 17,953 90,050 82,659 72,122 64,580 429 434 455 526 934 972 1,008 1,513 178 182 190 331 110 77 115 111 788 486 2 798 810 1,104 468 500 660 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 940 61416 LIFE INSURANCE 100 61417 UNEMPLOYMENT INSURANCE 250 61417 UNEMPLOYMENT INSURANCE 670 61417 UNEMPLOYMENT INSURANCE 100 61640 SAFETY EQUIPMENT 250 61640 SAFETY EQUIPMENT 610 61640 SAFETY EQUIPMENT 620 61640 SAFETY EQUIPMENT 670 61640 SAFETY EQUIPMENT 810 61640 SAFETY EQUIPMENT 940 61640 SAFETY EQUIPMENT 810 61645 TOOL ALLOWANCE 940 61645 TOOL ALLOWANCE 100 61650 MEAL ALLOWANCE 250 61650 MEAL ALLOWANCE 610 61650 MEAL ALLOWANCE 620 61650 MEAL ALLOWANCE 670 61650 MEAL ALLOWANCE 810 61650 MEAL ALLOWANCE 940 61650 MEAL ALLOWANCE 100 61660 EMPLOYEE PHYSICALS 250 61660 EMPLOYEE PHYSICALS 610 61660 EMPLOYEE PHYSICALS 620 61660 EMPLOYEE PHYSICALS 670 61660 EMPLOYEE PHYSICALS 810 61660 EMPLOYEE PHYSICALS 940 61660 EMPLOYEE PHYSICALS 100 61665 OTHER MEDICAL COSTS 100 61680 EMPLOYEE MOVING EXPENSE 8,467 61- WAGES AND BENEFITS 7,626,729 7,759,123 458 4,242 2,516 4,829 951 2,401 728 197 2,367 1,192 4,035 1,800 200 570 3,264 42 433 696 604 1,082 3,342 1,096 334 2,924 2,623 4,824 1,800 200 528 5,022 282 18 12 54 378 630 150 252 367 386 126 2,051 21 830 646 398 1,238 242 248 449 298 100 250 610 670 810 940 100 250 610 620 670 810 940 810 62010 62010 62010 62010 62010 62010 62011 62011 62011 62011 62011 62011 62011 62013 OFFICE SUPPLIES OFFICE SUPPLIES OFFICE SUPPLIES OFFICE SUPPLIES OFFICE SUPPLIES OFFICE SUPPLIES UNIFORM PURCHASES UNIFORM PURCHASES UNIFORM PURCHASES UNIFORM PURCHASES UNIFORM PURCHASES UNIFORM PURCHASES UNIFORM PURCHASES UNIFORM MAINTENANCE -103- 3,426 3,970 121 154 - 239 291 470 814 1,979 2,305 1,561 676 6,869 8,217 1,353 879 432 261 4,342 3,737 2,205 1,963 1,535 1,071 3,452 1,259 497 611 959 1,097 2,449 3,408 2,000 1,003 236 334 1,255 3,018 1,311 1,604 3,000 4,540 1,800 1,800 200 200 682 513 3,682 4,638 369 - 55 18 25 25 590 250 100 150 242 242 1,228 2,051 750 280 646 150 150 350 350 113 8,075,566 2,510 154 239 470 2,079 1,562 8,448 1,353 432 4,341 3,680 1,535 3,452 300 7,935,258 3,970 121 291 814 2,304 1,562 8,448 1,353 432 4,341 3,680 1,535 3,452 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 940 62013 100 62030 250 62030 610 62030 670 62030 810 62030 940 62030 100 62033 250 62033 610 62033 620 62033 670 62033 810 62033 940 62033 100 62034 250 62034 610 62034 620 62034 670 62034 680 62034 810 62034 940 62034 250 62036 810 62050 100 62060 100 62061 810 62061 940 62061 250 62062 670 62062 810 62062 940 62062 100 62063 250 62063 100 62064 250 62064 670 62064 810 62064 940 62064 100 62090 250 62090 610 62090 670 62090 810 62090 UNIFORM MAINTENANCE 827 755 POSTAGE AND SHIPPING 1,331 790 POSTAGE AND SHIPPING 198 282 POSTAGE AND SHIPPING 1,429 597 POSTAGE AND SHIPPING 730 77 POSTAGE AND SHIPPING 8 POSTAGE AND SHIPPING 867 281 967 HAND TOOLS/EQUIPMENT 89 260 202 HAND TOOLS/EQUIPMENT 5,584 9,250 6,037 HAND TOOLS/EQUIPMENT 546 1,503 546 HAND TOOLS/EQUIPMENT 421 323 421 HAND TOOLS/EQUIPMENT 38 - 38 HAND TOOLS/EQUIPMENT 35 1,550 405 1,550 HAND TOOLS/EQUIPMENT 6,021 5,889 6,021 5,889 REPAIR PARTS/SUPPLIES 6,048 16,579 6,731 9,777 REPAIR PARTS/SUPPLIES 23,604 23,862 22,338 23,862 REPAIR PARTS/SUPPLIES 12,516 21,532 12,516 21,532 REPAIR PARTS/SUPPLIES 4,776 8,725 9,432 8,725 REPAIR PARTS/SUPPLIES 1,491 1,272 1,491 1,272 REPAIR PARTS/SUPPLIES 200 - 200 - REPAIR PARTS/SUPPLIES 1,272 803 1,272 803 REPAIR PARTS/SUPPLIES 28,151 29,935 27,077 30,506 CONSTRUCTION SUPPLIES 31,071 38,533 41,094 38,533 OFFICE EQUIPMENT MAINT - 30 30 O/E MAINT CONTRACTS 5,040 DP EQUIP. MAINTCONTRACTS 5,903 6,496 6,887 6,558 DP EQUIP. MAINT CONTRACTS 3,041 3,346 3,548 3,378 DP EQUIP. MAINT CONTRACTS 1,735 JANITORIAL SUPPLIES 8,093 7,687 8,093 7,687 JANITORIAL SUPPLIES 1,522 1,450 1,522 1,450 JANITORIAL SUPPLIES 2,834 2,756 2,834 2,756 JANITORIAL SUPPLIES 1,283 878 1,283 878 SAFETY RELATED SUPPLIES 3,150 SAFETY RELATED SUPPLIES 4,410 ELECTRICAL SUPPLIES 2,473 418 1,842 1,493 ELECTRICAL SUPPLIES 868 2,109 868 2,109 ELECTRICAL SUPPLIES 160 389 160 389 ELECTRICAL SUPPLIES 304 739 304 739 ELECTRICAL SUPPLIES 2,310 137 2,310 137 PRINTING & BINDING 290 563 790 602 PRINTING & BINDING 328 4,060 328 4,344 PRINTING & BINDING - 13 - 13 PRINTING & BINDING 9,108 13,140 9,108 14,060 PRINTING & BINDING 16 340 159 363 827 1,178 198 1,429 730 827 814 291 615 79 8 389 260 9,250 1,503 323 -104- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 940 62090 100 62110 250 62110 670 62110 810 62110 940 62110 100 62130 250 62130 670 62130 810 62130 940 62130 670 62140 940 62140 100 62170 940 62170 100 62190 610 62190 670 62190 810 62190 940 62190 100 62204 610 62204 670 62204 940 62204 100 62206 250 62206 670 62206 810 62206 940 62206 100 62208 250 62208 610 62208 620 62208 670 62208 810 62208 940 62208 670 62210 940 62210 940 62211 100 62310 670 62310 810 62310 940 62310 100 62320 PRINTING & BINDING COPYING/REPRODUCTION COPYING/REPRODUCTION COPYING/REPRODUCTION COPYING/REPRODUCTION COPYING/REPRODUCTION LEGAL NOTICES & ADS LEGAL NOTICES & ADS LEGAL NOTICES & ADS LEGAL NOTICES & ADS LEGAL NOTICES & ADS PROMOTION PROMOTION SUBSCRIPTIONS -BOOKS -MAPS SUBSCRIPTIONS -BOOKS -MAPS DUES & MEMBERSHIPS DUES & MEMBERSHIPS DUES & MEMBERSHIPS DUES & MEMBERSHIPS DUES & MEMBERSHIPS REFUNDS REFUNDS REFUNDS REFUNDS PROPERTY INSURANCE PROPERTY INSURANCE PROPERTY INSURANCE PROPERTY INSURANCE PROPERTY INSURANCE GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN SALES TAX SALES TAX PROPERTY TAX TRAVEL -CONFERENCES TRAVEL -CONFERENCES TRAVEL -CONFERENCES TRAVEL -CONFERENCES TRAVEL -CITY BUSINESS -105- 246 945 316 1,049 247 944 1,338 1,122 159 155 159 166 103 135 103 144 1,134 1,258 1,134 1,346 2,828 450 450 2,704 438 2,704 438 3,244 1,800 3,244 1,800 3,057 1,124 1,124 2,716 648 2,716 648 1,763 5,152 6,250 8,152 24,042 11,317 24,715 24,715 1,209 1,508 1,209 1,269 256 102 306 322 1,266 1,773 1,465 2,008 20 212 512 212 522 184 98 184 196 1,726 2,937 1,726 3,036 75 150 500 2,000 500 3,357 3,243 2,993 3,243 (31) - - 141 132 3,842 4,790 15,694 17,676 16,680 19,300 1,218 1,433 6,984 6,554 2,592 3,149 70,614 33,037 34,585 70,339 14,477 13,202 13,749 13,947 36,223 33,036 34,403 34,879 8,347 7,612 7,927 8,041 10,096 9,208 9,589 9,741 21,899 19,972 20,797 21,096 13,503 12,733 13,365 13,774 37,732 31,290 32,855 38,920 7,527 7,742 7,527 7,742 15,177 12,557 15,177 12,557 2,514 2,582 2,514 2,582 9,212 10,811 13,840 19,160 898 1,914 1,860 2,250 1,196 3,426 3,160 3,160 2,375 4,935 4,150 6,880 3,218 173 286 286 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 610 62320 670 62320 810 62320 940 62320 100 62340 670 62340 940 62340 100 62360 250 62360 610 62360 620 62360 670 62360 810 62360 940 62360 940 62363 100 62411 250 62411 610 62411 620 62411 670 62411 810 62411 940 62411 250 62412 670 62412 810 62412 940 62412 250 62415 940 62415 100 62419 250 62419 100 62421 250 62421 610 62421 620 62421 670 62421 810 62421 940 62421 100 62424 250 62424 610 62424 620 62424 670 62424 810 62424 940 62424 TRAVEL -CITY BUSINESS TRAVEL -CITY BUSINESS TRAVEL -CITY BUSINESS TRAVEL -CITY BUSINESS MILEAGE/LOCAL TRANSP MILEAGE/LOCAL TRANSP MILEAGE/LOCAL TRANSP EDUCATION & TRAINING EDUCATION & TRAINING EDUCATION & TRAINING EDUCATION & TRAINING EDUCATION & TRAINING EDUCATION & TRAINING EDUCATION & TRAINING GREEN VISION - EDUC/TRAIN UTILITY EXP -ELECTRICITY UTILITY EXP -ELECTRICITY UTILITY EXP -ELECTRICITY UTILITY EXP -ELECTRICITY UTILITY EXP -ELECTRICITY UTILITY EXP -ELECTRICITY UTILITY EXP -ELECTRICITY UTILITY EXP -GAS UTILITY EXP -GAS UTILITY EXP -GAS UTILITY EXP -GAS UTILITY EXPENSE STORMWATR UTILITY EXPENSE STORMWATR UTILITY EXP-ELEC ST LTNG UTILITY EXP-ELEC ST LTNG TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE RADIO/PAGER FEE RADIO/PAGER FEE RADIO/PAGER FEE RADIO/PAGER FEE RADIO/PAGER FEE RADIO/PAGER FEE RADIO/PAGER FEE -106- 1,058 373 308 373 373 1,186 - 1,186 2,839 3,061 3,039 3,039 213 536 446 536 246 246 246 835 1,025 836 1,108 1,943 802 2,172 2,452 12,301 9,708 10,727 10,727 2,908 7,069 8,000 8,000 75 225 300 300 290 1,238 1,200 1,200 1,015 3,935 12,000 12,000 3,102 4,868 3,436 5,639 34,492 47,520 59,821 58,355 39,919 35,266 40,386 35,266 57,059 59,192 55,674 59,192 349 349 1,529 1,469 1,720 1,469 10,139 10,551 9,097 10,551 19,264 20,048 15,656 20,048 22,928 22,092 25,794 22,093 10,898 20,395 11,443 20,395 1,700 2,756 1,785 2,756 3,230 5,236 3,392 5,236 4,726 4,507 4,962 4,507 215 244 5,552 5,910 5,552 6,712 360,979 179,108 34,560 35,382 114,706 615,069 662,563 615,069 4,283 4,145 4,283 4,145 2,512 2,025 2,512 2,026 152 226 152 226 79 79 1,750 1,320 1,750 1,320 1,519 1,558 1,519 1,558 3,772 3,490 3,772 3,490 2,638 2,685 2,638 2,791 11,746 12,093 11,746 12,577 1,759 1,806 1,759 1,879 879 903 879 939 4,983 5,118 4,983 5,323 879 903 879 939 3,792 3,964 3,792 4,123 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 100 62431 250 62431 670 62431 680 62431 810 62431 940 62431 250 62434 670 62434 810 62434 250 62435 670 62435 810 62435 100 62436 250 62436 940 62436 100 62437 250 62437 610 62437 620 62437 250 62438 670 62438 810 62438 100 62511 250 62511 610 62511 620 62511 670 62511 810 62511 940 62511 100 62512 810 62512 940 62512 100 62521 250 62521 610 62521 620 62521 670 62521 810 62521 940 62521 250 62522 610 62522 670 62522 100 62528 250 62528 PROPERTY MAINTENANCE PROPERTY MAINTENANCE PROPERTY MAINTENANCE PROPERTY MAINTENANCE PROPERTY MAINTENANCE PROPERTY MAINTENANCE HVAC MAINTENANCE HVAC MAINTENANCE HVAC MAINTENANCE ELEVATOR MAINTENANCE ELEVATOR MAINTENANCE ELEVATOR MAINTENANCE RENTAL OF SPACE RENTAL OF SPACE RENTAL OF SPACE BARRICADE RENTAL BARRICADE RENTAL BARRICADE RENTAL BARRICADE RENTAL FIRE SUPPRESSION FIRE SUPPRESSION FIRE SUPPRESSION FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE FUEL, OFF ROAD VEHICLE FUEL, OFF ROAD VEHICLE FUEL, OFF ROAD VEHICLE MOTOR VEHICLE MAINT. MOTOR VEHICLE MAINT. MOTOR VEHICLE MAINT. MOTOR VEHICLE MAINT. MOTOR VEHICLE MAINT. MOTOR VEHICLE MAINT. MOTOR VEHICLE MAINT. VEHICLE MAINT., ACCIDENT VEHICLE MAINT., ACCIDENT VEHICLE MAINT., ACCIDENT MOTOR VEH. MAINT. OUTSOUR MOTOR VEH. MAINT. OUTSOUR -107- 1,709 3,396 21,709 21,560 53,410 52,194 53,390 59,679 7,945 9,284 7,883 25,571 350 500 18,933 35,371 18,815 52,111 65,642 96,125 65,174 76,930 9,251 1,529 1,654 1,637 309 587 720 720 720 720 196 266 316 266 1,767 1,853 1,803 1,853 910 - 910 910 7,001 7,219 7,001 7,219 520 502 520 502 670 500 670 500 2,515 475 901 11,028 12,278 11,248 12,097 107,553 141,875 109,703 114,266 9,775 11,574 9,971 11,697 4,298 14,136 4,384 8,192 100,480 124,344 102,491 106,511 3,448 3,300 3,517 3,764 2,523 2,970 2,574 2,630 2,461 1,779 2,633 259 389 264 416 98,614 118,745 100,586 127,05 8 22,279 20,426 22,725 23,179 162,986 108,397 166,245 169,570 32,688 30,767 27,367 27,914 11,743 12,665 11,978 12,218 245,251 265,587 230,250 234,854 6,043 4,015 6,164 6,287 7,706 5,469 7,860 6,318 4,700 364 1,193 568 5,734 5,765 5,850 5,967 40,635 28,211 41,447 42,275 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 610 62528 620 62528 670 62528 810 62528 940 62528 100 62611 250 62611 610 62611 620 62611 670 62611 810 62611 940 62611 100 62614 250 62614 610 62614 620 62614 670 62614 680 62614 810 62614 940 62614 100 62615 250 62615 610 62615 670 62615 810 62615 940 62615 100 62616 100 62617 250 62618 610 62618 620 62618 940 62618 100 62619 250 62619 610 62619 620 62619 100 62620 250 62620 610 62620 620 62620 670 62620 940 62620 100 62627 250 62627 MOTOR VEH. MAINT. OUTSOUR MOTOR VEH. MAINT. OUTSOUR MOTOR VEH. MAINT. OUTSOUR MOTOR VEH. MAINT. OUTSOUR MOTOR VEH. MAINT. OUTSOUR MACH/EQUIP MAINTENANCE MACH/EQUIP MAINTENANCE MACH/EQUIP MAINTENANCE MACH/EQUIP MAINTENANCE MACH/EQUIP MAINTENANCE MACH/EQUIP MAINTENANCE MACH/EQUIP MAINTENANCE EQUIP MAINT CONTRACT EQUIP MAINT CONTRACT EQUIP MAINT CONTRACT EQUIP MAINT CONTRACT EQUIP MAINT CONTRACT EQUIP MAINT CONTRACT EQUIP MAINT CONTRACT EQUIP MAINT CONTRACT MACH/EQUIP MAINT. OUTSOUR MACH/EQUIP MAINT. OUTSOUR MACH/EQUIP MAINT. OUTSOUR MACH/EQUIP MAINT. OUTSOUR MACH/EQUIP MAINT. OUTSOUR MACH/EQUIP MAINT. OUTSOUR TRAFFIC & ST LT COMPONENT TRAFFIC CONTROLLER REPAIR ASPHALT ASPHALT ASPHALT ASPHALT CONCRETE CONCRETE CONCRETE CONCRETE STONE STONE STONE STONE STONE STONE CAMERA MAINTENANCE CAMERA MAINTENANCE -108- 3,066 1,835 3,127 1,872 1,494 1,038 904 922 55,901 112,223 57,019 58,159 269 120 274 279 5,800 10,211 5,916 6,035 28,588 22,575 22,523 23,075 466,262 493,868 428,169 462,964 16,180 5,850 9,275 5,850 3,242 12,893 3,242 6,932 81 81 18,740 46,144 18,740 28,963 91,065 156,925 92,064 120,176 6,043 3,807 5,442 3,807 9,478 10,805 12,355 10,805 1,443 699 1,443 699 721 350 721 350 4,088 4,847 4,087 4,848 1,325 734 1,325 734 300 350 300 350 7,425 8,755 7,425 8,755 5,877 8,627 5,877 8,627 56,721 15,049 42,169 15,049 6,749 6,749 542 3,394 542 383 792 383 792 91,651 180,352 91,651 120,000 64,247 49,758 64,247 49,758 3,201 3,201 3,200 866,871 339,432 693,864 713,100 5,651 11,642 5,651 4,172 9,202 4,172 9,202 1,261 1,261 628 1,169 500 1,168 110,893 111,321 119,294 125,453 8,165 12,372 8,165 12,372 15,955 15,598 10,807 15,598 66 326 566 326 47,331 25,715 47,331 36,704 17 1,095 17 1,095 1,472 1,926 1,472 1,926 55 55 60,017 69,695 60,017 69,695 1,512 1,512 84 84 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 940 62627 250 62636 940 62636 100 62637 250 62637 250 62640 680 62640 940 62649 100 62661 100 62663 250 62663 610 62663 670 62663 680 62663 810 62663 940 62663 810 62664 940 62664 940 62666 100 62667 250 62667 610 62667 620 62667 670 62667 810 62667 940 62667 810 62669 940 62671 670 62673 670 62674 250 62680 610 62680 100 62685 940 62685 250 62686 250 62687 250 62692 670 62692 680 62692 100 62696 670 62696 610 62697 940 62699 100 62710 CAMERA MAINTENANCE DE-ICING PRODUCTS DE-ICING PRODUCTS L AND S C APE/FERT/PL ANTS L AND S C APE/FERT/PL ANTS SALT SALT BEVERAGE/ICE MISC. OPER. EXPENS SOFTWARE LICENSE EXP SOFTWARE LICENSE EXP SOFTWARE LICENSE EXP SOFTWARE LICENSE EXP SOFTWARE LICENSE EXP SOFTWARE LICENSE EXP SOFTWARE LICENSE EXP LICENSE/PERMIT FEES LICENSE/PERMIT FEES CREDIT CARD CHARGE DATA SERVICES DATA SERVICES DATA SERVICES DATA SERVICES DATA SERVICES DATA SERVICES DATA SERVICES PROGRAMMING MISC. OPERATING SUPPLIES FOOD SCRAP SUPPLIES BRUSH TIES MANHOLE COMPONENTS MANHOLE COMPONENTS SIGN SUPPLIES SIGN SUPPLIES CRACKSEAL MATERIALS TAC OIL LANDFILL FEES LANDFILL FEES LANDFILL FEES OUTSIDE COLLECTOR EXPENSE OUTSIDE COLLECTOR EXPENSE LABOR RELATIONS CASH SHORT AND OVER CONTRACTOR SERVICES -109- 798 5,616 13,885 17,658 2,679 1,422 1,200 8,789 9,467 9,517 67 500 284,785 132,472 226,000 71,593 72,419 90,400 1,097 910 1,097 14 51 8,792 7,975 9,831 619 10,860 19,560 19,560 3,953 17,681 24,170 18,565 10,167 9,046 9,167 9,049 73 73 6,235 7,176 6,235 8,335 12,735 11,261 20,735 12,018 220 220 220 220 629 785 629 785 9,228 9,598 9,228 9,598 240 240 240 240 82 - 82 363 372 478 372 120 120 120 120 324 39 324 159 126 - 126 1,791 1,560 1,791 1,560 1,848 1,848 1,847 1,847 250 570 250 250 2,100 4,200 103 103 103 24,206 24,206 37,005 56,523 37,005 56,523 20,906 32,394 60,090 32,164 990 500 24,004 5,792 12,790 5,792 5,405 4,272 5,405 4,272 45,492 63,920 51,267 63,920 352,365 422,361 426,152 434,814 3,037 1,977 258 437 34 503 471 2,955 3,015 2,955 3,015 1,050 134 200 134 9,486 20,814 14,686 19,041 798 13,885 1,422 9,467 500 333,905 151,775 910 Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 250 62710 610 62710 670 62710 810 62710 940 62710 100 62712 940 62712 100 62713 400 62713 670 62713 940 62713 250 62715 940 62716 400 62721 670 62721 940 62721 670 62726 940 62726 940 62727 100 62731 400 62731 670 62731 940 62731 670 62732 940 62732 100 62734 940 62737 100 62746 100 62747 250 62747 940 62747 670 62748 940 62748 670 62750 940 62750 670 62761 940 62761 940 62763 940 62767 670 62770 940 62770 100 62780 250 62780 610 62780 CONTRACTOR SERVICES 24,252 CONTRACTOR SERVICES CONTRACTOR SERVICES CONTRACTOR SERVICES CONTRACTOR SERVICES CONSULTING ENGINEERS CONSULTING ENGINEERS LEGAL SERVICES LEGAL SERVICES LEGAL SERVICES LEGAL SERVICES FORECASTING SERVICE CONSULTANT SERVICES FINANCIAL CONSULTANT FINANCIAL CONSULTANT FINANCIAL CONSULTANT AUDIT SERVICES AUDIT SERVICES FINANCIAL SERVICE FEES MISCELLANEOUS SERVICES MISCELLANEOUS SERVICES 1,903 MISCELLANEOUS SERVICES 245 270 245 MISCELLANEOUS SERVICES 4,000 TEMP HELPCONTRACT SERV. 5,206 - 5,206 - TEMP HELPCONTRACT SERV. 27,499 23,001 60,000 23,001 SPEAKERS/PROGRAMS 1,500 CONTRACT ADM SERVICE 86,959 49,272 52,657 50,655 ONE CALL OPERATION 4,416 4,434 4,416 4,434 MACH/EQUIPMENT RENTAL 1,060 1,508 1,314 1,762 MACH/EQUIPMENT RENTAL 1,050 159 5,607 5,159 MACH/EQUIPMENT RENTAL 991 25,000 27,100 APPLIANCE RECYCLING 1,500 1,500 APPLIANCE RECYCLING 13,086 14,565 13,086 14,565 TIRE RECYCLING 600 610 600 610 TIRE RECYCLING 19,558 29,980 20,433 29,980 PAY TO OTHER AGENCY 15,464 25,245 15,464 25,245 PAY TO OTHER AGENCY 136,211 166,334 217,629 210,343 PAYMENT TOIOWA DNR 276,292 283,354 294,000 304,500 ENVIRON. TESTING/MON. 37,558 20,511 38,058 42,500 GRIND/COMPOST SERVICE 13,247 GRIND/COMPOST SERVICE 35,589 76,301 49,300 76,301 HAULING SERVICES 13,773 15,603 22,000 15,603 HAULING SERVICES 50,000 50,000 HAULING SERVICES 1,000 7 920 8,627 350 13 7,269 324 829 11,225 1,568 892 1,095 11,672 3,073 90,646 12,915 11,091 7 920 8,627 5,100 162,827 17,415 11,091 892 920 8,627 5,100 202,827 107 142 72 1,000 1,000 4,739 4,739 4,803 4,803 8,833 16,484 8,833 8,833 716 92 188 92 92 5,000 5,000 5,000 750 - 830 - 4,200 4,200 4,180 4,200 650 1,033 650 1,033 283 -110- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 940 62780 100 62781 250 62782 680 62782 250 62783 680 62783 940 62784 100 62811 100 62833 HAULING SERVICES LAWN CARE SERVICES HANDLING FEES HANDLING FEES TARPING FEES TARPING FEES ASPHALT SHINGLE RECYCLING ENG. DIVISION SERVICES SERVICE FROM WPC 58,589 18,365 27,154 7,327 20,013 2,500 16,884 60,094 19,679 21,154 9,713 23,414 1,912 13,129 2,572 21,221 40,040 11,440 20,013 3,340 25,000 32,126 2,000 3,027 19,679 34,320 14,45 0 13,129 32,548 2,000 62 - SUPPLIES AND SERVICES 6,368,341 6,417,386 6,762,699 7,203,063 940 62724 BOND PAYING AGENT FEE 627 - CONTRACTUAL SERVICES 810 100 250 610 620 670 680 810 820 940 100 250 63210 63311 63,311 63,311 63,311 63,311 63,311 63,311 63,311 63,311 63,312 63,313 STORES -GARAGE ADMIN. OVERHEAD ADMIN. OVERHEAD ADMIN. OVERHEAD ADMIN. OVERHEAD ADMIN. OVERHEAD ADMIN. OVERHEAD ADMIN. OVERHEAD ADMIN. OVERHEAD ADMIN. OVERHEAD LESS ADMIN. RECHARGES LESS SERVICE FD CHARGES 750 750 750 750 750 750 751,879 888,129 882,360 957,449 56,037 55,262 53,673 54,098 193,162 226,071 222,015 194,263 25,472 30,142 29,277 29,508 12,736 15,072 14,638 14,754 59,434 70,307 68,312 68,852 4,245 5,024 4,879 4,918 21,227 25,119 24,397 24,590 2,512 - - 61,557 72,843 69,584 71,313 (424,531) (502,352) (486,775) (491,804) 29,508 63 - ADMIN/OVERHEAD/STORES GAR 761,217 888,129 882,360 957,449 100 71113 CALCULATORS 17 940 71113 CALCULATORS 27 100 71120 PERIPHERALS, COMPUTER 108 670 71120 PERIPHERALS, COMPUTER - 950 810 71120 PERIPHERALS, COMPUTER 829 940 71120 PERIPHERALS, COMPUTER 108 670 71121 VIDEO GAME SYSTEM 27,000 610 71122 PRINTER 103 - 250 250 810 71122 PRINTER 2,292 940 71122 PRINTER 153 250 71123 SOFTWARE 4,000 810 71211 DESKS/CHAIRS 313 940 71211 DESKS/CHAIRS 174 940 71213 TABLES 75 670 71221 CARTS 42,571 38,377 56,060 29,240 100 71314 TRUCK -REPLACEMENT 90,634 250 71314 TRUCK -REPLACEMENT 31,674 75,000 610 71314 TRUCK -REPLACEMENT 94,500 670 71314 TRUCK -REPLACEMENT 120,773 -111- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 250 71318 810 71318 250 71323 250 71328 100 71410 810 71410 940 71410 100 71411 250 71414 100 71415 620 71415 940 71415 250 71416 250 71418 250 71420 620 71420 250 71425 610 71511 940 71520 100 71550 250 71550 810 71550 940 71550 810 71610 100 71611 250 71611 100 71612 250 71612 100 71615 250 71615 250 71616 100 71619 250 71619 610 71619 670 71619 940 71619 610 72111 940 72111 610 72114 680 72417 940 72417 100 72418 250 72418 610 72418 HEAVY EQUIP -REPLACEMENT HEAVY EQUIP -REPLACEMENT ASPHALT ROLLER 17,790 TRAILERS 8,250 SHOP EQUIPMENT 1,802 1,231 SHOP EQUIPMENT 5,262 4,560 SHOP EQUIPMENT 10,708 2,656 TRAFFIC CONTROL EQUIPMENT 24,333 428 AIR HAMMER/DRILL 599 SAWS 600 SAWS 909 1,000 SAWS - 400 PLOWS 36,959 SALT SPREADERS 18,000 EARTH COMPACTOR 7,600 2,265 2,800 EARTH COMPACTOR 1,750 - CURB FORMS 1,995 2,000 - PUMPS 1,220 30,000 HVAC 3,100 15,918 6,645 MISCELLANEOUS EQUIPMENT 7,130 - 11,150 MISCELLANEOUS EQUIPMENT 7,096 31,975 MISCELLANEOUS EQUIPMENT 2,298 7,306 MISCELLANEOUS EQUIPMENT 9,027 9,750 CUSTODIAL EQUIPMENT - 6,600 MOWING EQUIPMENT 35,177 - - MOWING EQUIPMENT 10,850 550 WEED WHIPS/SICKLE BAR 1,000 WEED WHIPS/SICKLE BAR 277 600 LEAF BLOWER - 1,200 LEAF BLOWER 500 SNOW BLOWER 1,200 OTHER MAMNT. EQUIPMENT 6,400 OTHER MAMNT. EQUIPMENT - 99,000 100,000 OTHER MAMNT. EQUIPMENT 725 15,500 OTHER MATNT. EQUIPMENT 10,000 OTHER MATNT. EQUIPMENT 11,510 5,504 43,500 12,000 GAS SAFETY MONITOR 1,519 937 1,500 1,500 GAS SAFETY MONITOR 820 - CONFINED SPACE EQUIMENT 602 CAMERA RELATED EQUIPMENT 800 CAMERA RELATED EQUIPMENT 14,941 3,747 10,000 TELEPHONE RELATED 422 820 TELEPHONE RELATED 120 TELEPHONE RELATED 120 89,500 28,000 2,000 5,000 2,000 12,000 88,000 2,000 5,000 2,000 12,000 -112- Recommended Operating Expenditure Budget - Department Total 54 - PUBLIC WORKS Fund Account Account Title FY17 Actual Expense FY18 Actual Expense FY19 Adopted Budget FY 20 Recomm'd Budget 670 810 940 940 610 670 940 72418 72418 72418 72419 72816 72818 72818 TELEPHONE RELATED TELEPHONE RELATED TELEPHONE RELATED PA SYSTEM JET FLUSHER HOSE RECYCLING CONTAINER RECYCLING CONTAINER 71- EQUIPMENT 250 72115 BARRICADES/WARN SIGNALS 246 362 3,182 291 291 12,666 26,450 2,567 100 264,007 307,697 5,742 3,781 350 570 450 5,250 11,500 350 3,500 11,500 718,511 348,840 25,400 3,400 72 - EQUIPMENT 5,742 3,781 25,400 3,400 940 73211 CONST.CONTR-NOT BLDG 5,000 73 - CIP EXPENDITURES 5,000 400 74,111 PRINCIPAL PAYMENT 670 74,111 PRINCIPAL PAYMENT 940 74,111 PRINCIPAL PAYMENT 400 74,112 INTEREST PAYMENT 670 74,112 INTEREST PAYMENT 940 74,112 INTEREST PAYMENT 491,837 56,953 290,000 37,961 2,900 189,961 91,357 31,993 395,000 34,840 2,717 272,559 100,130 4,977 400,000 37,078 2,386 262,659 104,289 5,222 410,000 31,043 2,064 250,659 74 - DEBT SERVICE 1,069,612 828,466 807,230 803,277 670 91,100 TO GENERAL 1,089,206 914,569 927,857 1,055,920 810 91,100 TO GENERAL 12,973 940 91,100 TO GENERAL 368,928 364,242 359,940 387,593 91- TRANSFER TO 1,458,134 1,291,784 1,287,797 1,443,513 54 - PUBLIC WORKS TOTAL 17,559,532 17,496,366 18,560,313 18,695,550 -113- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS ADMINISTRATION - 54100 Adi FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR DEBT SERVICE EQUIPMENT SUPPLIES AND SERVICES TRANSFER TO WAGES AND BENEFITS (502,352) 34,710 46,512 914,569 441,691 (486,775) 7,363 700 42,900 927,857 452,081 (491,804) 7,286 53,516 1,055,920 441,480 ADMINISTRATION 935,130 LANDFILL - 54200 FUNDING SOURCE: DMASWA-GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR CIP EXPENDITURES CONTRACTUAL SERVICES 40,188 DEBT SERVICE 667,559 EQUIPMENT 34,228 SUPPLIES AND SERVICES 1,230,902 TRANSFER TO 364,242 WAGES AND BENEFITS 888,573 38,391 39,344 750 750 662,659 660,659 21,248 24,000 1,174,659 1,346,347 359,940 387,593 867,672 842,404 LANDFILL 3,225,692 3,125,319 COMPOSTING LANDFILL - 54210 3,301,097 FUNDING SOURCE: DMASWA-GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR SUPPLIES AND SERVICES WAGES AND BENEFITS 5,024 80,100 17,575 4,799 53,565 30,130 4,918 82,201 29,922 COMPOSTING LANDFILL 102,699 88,494 Au HOUSEHOLD HAZ. MAT. R.C.C- 54220 FUNDING SOURCE: DMASWA-GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS 5,024 2,245 96,566 57,530 4,799 12,000 126,886 100,310 4,918 103,909 98,094 HOUSEHOLD HAZ. MAT. R.C.0 161,365 DMASWA iMI 1 L. 1 u u - -114- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS FUNDING SOURCE: DMASWA-GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR SUPPLIES AND SERVICES WAGES AND BENEFITS 5,024 115,591 4,799 135,605 30,862 4,919 135,997 30,295 DMASWA EDUCATION & COMM. 120,615 171,266 E -WASTE 54240 FUNDING SOURCE: DMASWA-GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR SUPPLIES AND SERVICES WAGES AND BENEFITS 5,024 4,799 4,919 59,631 63,307 59,631 26,660 64,810 64,966 E -WASTE 91,315 RURAL RECYCLING - 54250 FUNDING SOURCE: DMASWA-GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS 2,512 125,890 2,500 2,399 19,500 107,926 16,087 2,459 112,891 16,784 RURAL RECYCLING 130,902 145,912 132,134 LANDFILL GAS SYSTEM - 54260 FUNDING SOURCE: DMASWA-GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 10,047 EQUIPMENT 2,142 SUPPLIES AND SERVICES 74,988 WAGES AND BENEFITS 23,848 LANDFILL GAS SYSTEM 111,025 SAN- SEWER MNTNCE - 54300 FUNDING SOURCE: SEWAGE FACILITY OPERATION 9,598 72,501 37,915 120,014 9,836 67,911 38,478 111 Account FYIS Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 30,142 29,277 29,508 EQUIPMENT 1,539 117,120 35,250 SUPPLIES AND SERVICES 196,746 181,107 204,963 WAGES AND BENEFITS 502,081 502,637 488,717 -115- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS SAN- SEWER MNTNCE 730,507 830,141 758,438 STORM SEWER MATNT - 54310 FUNDING SOURCE: STORM WATER OPERATION Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS 15,072 89,541 178,228 NMI STORM SEWERMAINT 282,840 RIVERFRONT MANAGEMNT. - 54330 14,638 1,000 61,322 164,738 14,754 77,968 165,620 FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 5,024 EQUIPMENT 277 SUPPLIES AND SERVICES 24,898 WAGES AND BENEFITS 54,127 4,879 2,100 22,401 59,770 4,918 1,700 22,93 6 58,748 RIVERFRONT MANAGEMNT. IMP 84,326 89,150 FLOODWALL OPER./MAINT. - 54340 FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 15,071 14,638 14,754 SUPPLIES AND SERVICES 107,966 90,912 1 01,65 8 WAGES AND BENEFITS 62,330 66,918 65,685 M FLOODWALL OPERJMAINT. 185,366 STREET MAINTENANCE - 54400 FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 100,477 97,589 98,361 EQUIPMENT 69,694 325,700 191,400 SUPPLIES AND SERVICES 1,016,942 1,464,577 1,476,439 WAGES AND BENEFITS 1,465,324 1,496,807 1,474,352 STREET MAINTENANCE 2,652,438 3,240,552 STREET CLEANING - 54410 FUNDING SOURCE: ROAD USE TAX Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 30,142 29,277 29,508 EQUIPMENT 11,127 1,15 0 -116- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS SUPPLIES AND SERVICES WAGES AND BENEFITS 337,822 373,677 313,040 352,146 3 62,83 8 344,253 STREET CLEANING 752,768 SNOW & ICE CONTROL - 54420 FUNDING SOURCE: ROAD USE TAX Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS NOW & ICE CONTROL 97,964 526,569 528,489 95,149 18,120 669,724 624,549 1,153,021 1,407,54 SALT OPS - PURINA DRIVE - 5442 95,902 1,200 740,822 640,03 9 FUNDING SOURCE: SALT OPERATIONS Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 5,024 4,879 4,918 EQUIPMENT - 800 - SUPPLIES AND SERVICES 86,755 107,386 1 67,53 2 SALT OPS - PURINA DRIVE 91,779 113,065 172,450 ST. & TRAFFIC LTNG - 54430 FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 10,048 9,759 9,836 EQUIPMENT 1,383 13,770 13,000 SUPPLIES AND SERVICES 836,344 766,242 704,719 WAGES AND BENEFITS 203,079 196,519 195,391 ST. & TRAFFIC LTNG 1,050,853 986,290 922,946 ST. SIGNS & MARKINGS - 54435 FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY 19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 10,048 9,759 9,836 EQUIPMENT 90,634 11,000 500 SUPPLIES AND SERVICES 48,205 95,770 64,993 WAGES AND BENEFITS 94,833 126,312 123,965 ST. SIGNS & MARKINGS 243,720 242,841 ONE CALL LOCATION SERVICE- 54440 FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget -117- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS ADMIN/OVERHEAD/STORES GAR SUPPLIES AND SERVICES WAGES AND BENEFITS 4,434 25,542 25,982 ONE CALL LOCATION SERVICE 4,434 PORT OF DUB. MAINTENANCE - 54450 25,542 FUNDING SOURCE: GENERAL Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS 15,071 14,638 14,754 76,731 108,640 99,650 68,499 63,589 62,730 PORT OF DUB. MAINTENANCE 160,302 186,867 DEBT SERVICE - 54490 FUNDING SOURCE: DEBT SERVICE Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget DEBT SERVICE 126,197 137,208 135,332 SUPPLIES AND SERVICES WIT DEBT SERVICE 126,197 137,208 REFUSE COLLECTION - 54500 FUNDING SOURCE: REFUSE COLLECTION Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS 25,119 19,791 711,399 947,754 24,397 154,173 689,533 932,608 24,590 36,300 722,298 912,884 REFUSE COLLECTION 1,704,063 1,800,711 YARD WASTE COLLECTION - 54510 FUNDING SOURCE: REFUSE COLLECTION Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS 10,047 3,274 99,740 9,759 75,226 9,83 6 3,240 79,119 122,816 117,915 116,715 IP YARD WASTE COLLECTION 235,876 202,900 LARGE ITEM COLLECTION - 54520 FUNDING SOURCE: REFUSE COLLECTION -118- Recommended Expenditure Budget Report by Activity & Funding Source 54 - PUBLIC WORKS Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 15,047 SUPPLIES AND SERVICES 4,028 WAGES AND BENEFITS 10,884 LARGE ITEM COLLECTION 29,958 RECYCLING COLL. PROG. - 54530 FUNDING SOURCE: REFUSE COLLECTION 14,638 14,754 3,843 5,578 15,805 15,807 34,286 Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 20,094 19,518 EQUIPMENT 42,054 34,510 SUPPLIES AND SERVICES 245,653 182,308 19,672 39,500 195,526 WAGES AND BENEFITS 684,413 704,494 690,391 ECYCLING COLL. PROG. 992,214 PUBLIC WORKS GARAGE - 5460 FUNDING SOURCE: GARAGE SERVICE 940,83 Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 913,248 EQUIPMENT 33,090 SUPPLIES AND SERVICES 173,420 TRANSFER TO 12,973 WAGES AND BENEFITS 1,003,753 906,757 12,170 127,777 982,039 5,000 187,639 1,050,892 1,017,538 PUBLIC WORKS GARAGE 2,136,484 2,097,596 2,192,216 PCARD CLEARING - 99999 FUNDING SOURCE: GENERAL Account FYIS Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget SUPPLIES AND SERVICES 14 0 0 PCARD CLEARING PUBLIC WKS (11.111.) PUBLIC WORKS TOTAL 8177,496,366.21 818,560,313.00 $18,695,550.00 -119- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 54 PUBLIC WORKS DEPARTMENT FD JC WP -GR JOB CLASS 61010 Full Time Employee Expense 100 3325 GE -41 100 1490 GE -38 100 3100 GE -37 810 3225 GE -35 670 6100 GE -35 940 2625 GE -35 940 2625 GE -35 100 2925 GE -31 250 2925 GE -31 100 225 GE -25 100 2655 GD -11 250 2655 GD -11 610 2655 GD -11 620 2655 GD -11 940 2655 GD -11 100 GD -11 250 GD -11 620 GD -11 670 2655 GD -11 810 7250 GD -11 810 2525 GD -10 940 2525 GD -10 100 2300 GD -08 250 2300 GD -08 610 2300 GD -08 620 2300 GD -08 820 2300 GD -08 940 2300 GD -08 940 G D-08 250 GD -05 610 G D-05 250 NA -48 670 GD -04 810 835 GD -03 100 2375 GD -06 250 2375 GD -06 610 2375 GD -06 620 2375 GD -06 670 1300 GD -06 100 2205 GD -06 250 2205 GD -06 250 GD -06 100 1475 G D-05 250 1475 GD -05 610 1475 GD -05 PUBLIC WORKS DIRECTOR ASSIST PUBLIC WORKS DIRECTOR STREET MAINTENANCE SUPERVISOR EQUIP MAINT. SUPERVISOR RESOURCE MANAGEMENT COORD. DMASWA ADMINISTRATOR LANDFILL SUPERVISOR TRAFFIC SIGNAL TECHNICIAN II TRAFFIC SIGNAL TECHNICIAN II SECRETARY FOREMAN FOREMAN FOREMAN FOREMAN FOREMAN FIELD SUPERVISOR FIELD SUPERVISOR FIELD SUPERVISOR LEAD SANITATION DRIVER LEAD MECHANIC MECHANIC MECHANIC EQUIPMENT OPERATOR II EQUIPMENT OPERATOR II EQUIPMENT OPERATOR II EQUIPMENT OPERATOR II EQUIPMENT OPERATOR II EQUIPMENT OPERATOR II LANDFILL EQUIPMENT OPERATOR UTILITY WORKER UTILITY WORKER UTILITY WORKER APPRENTICE SANITATION LABORER STOCK CLERK EQUIPMENT OPERATOR I EQUIPMENT OPERATOR I EQUIPMENT OPERATOR I EQUIPMENT OPERATOR I SANITATION DRIVER MAINTENANCE WORKER MAINTENANCE WORKER ASSISTANT HORTICULTURALIST TRUCK DRIVER TRUCK DRIVER TRUCK DRIVER FY 2018 FY 2019 FY 2020 FTE BUDGET FTE BUDGET FTE BUDGET 1.00 $ 113,491 1.00 $ 117,283 1.00 $ 119,966 1.00 $ 84,185 1.00 $ 81,065 1.00 $ 78,495 0.00 $ - 0.00 $ - 0.00 $ - 1.00 $ 80,611 1.00 $ 68,953 1.00 $ 70,530 1.00 $ 69,306 1.00 $ 74,221 1.00 $ 80,071 1.00 $ 84,187 1.00 $ 85,447 1.00 $ 87,625 1.00 $ 80,527 1.00 $ 81,734 1.00 $ 83,579 1.88 $ 116,488 1.88 $ 120,858 1.88 $ 126,395 0.12 $ 7,310 0.12 $ 7,617 0.12 $ 8,001 1.00 $ 48,120 1.00 $ 48,841 1.00 $ 49,956 0.44 $ 25,699 0.31 $ 18,356 0.31 $ 18,789 3.41 $ 201,576 3.65 $ 217,137 3.65 $ 223,086 1.35 $ 81,328 1.31 $ 79,308 1.31 $ 81,116 0.80 $ 48,403 0.73 $ 42,988 0.73 $ 43,967 0.00 $ - 1.00 $ 58,487 1.00 $ 59,819 0.04 $ 2,576 0.10 $ 6,863 0.10 $ 7,018 0.94 $ 60,527 0.90 $ 61,763 0.90 $ 63,165 0.02 $ 1,288 0.00 $ - 0.00 $ - 1.00 $ 60,502 1.00 $ 61,412 1.00 $ 62,810 2.00 $ 113,194 2.00 $ 116,231 2.00 $ 120,400 7.00 $ 390,861 7.00 $ 397,566 7.00 $ 411,821 1.00 $ 54,199 1.00 $ 57,346 1.00 $ 58,646 0.92 $ 50,466 0.91 $ 49,767 0.91 $ 50,918 5.24 $ 288,316 5.27 $ 293,417 5.27 $ 304,238 0.77 $ 41,810 0.72 $ 39,682 0.72 $ 40,852 0.07 $ 3,801 0.10 $ 5,512 0.10 $ 5,674 0.00 $ - 0.00 $ - 0.00 $ - 3.00 $ 166,539 2.00 $ 113,501 2.00 $ 116,098 3.00 $ 162,027 3.00 $ 165,278 3.00 $ 169,613 1.00 $ 48,330 4.70 $ 232,432 4.70 $ 240,004 0.00 $ - 0.30 $ 15,069 0.30 $ 15,607 0.00 $ - 1.00 $ 37,524 1.00 $ 38,367 1.00 $ 52,646 1.00 $ 53,436 1.00 $ 54,717 2.00 $ 91,423 2.00 $ 94,245 2.00 $ 97,084 0.60 $ 31,586 0.90 $ 48,931 0.90 $ 50,083 6.07 $ 319,244 5.60 $ 300,862 5.60 $ 308,601 3.41 $ 184,313 3.38 $ 183,625 3.38 $ 189,029 0.92 $ 49,986 1.12 $ 61,652 1.12 $ 63,225 17.00 $ 910,893 17.00 $ 910,675 17.00 $ 938,232 0.84 $ 46,314 0.77 $ 43,090 0.77 $ 44,076 0.16 $ 8,822 0.23 $ 12,872 0.23 $ 13,166 0.42 $ - 0.42 $ 6,606 0.42 $ 20,424 0.02 $ 1,069 0.00 $ - 0.00 $ - 9.55 $ 494,847 5.70 $ 300,982 5.70 $ 306,597 0.41 $ 21,741 0.30 $ 15,747 0.30 $ 16,255 -120- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 54 PUBLIC WORKS DEPARTMENT FD JC WP -GR JOB CLASS 620 1475 GD -05 TRUCK DRIVER 940 870 GD -04 SCALE HOUSE OPERATOR 100 811 NA -50 ACCOUNT CLERK 11 TOTAL FULL TIME EMPLOYEES 61020 Part Time Employee Expense 250 OE -06 CUSTODIAN 1 670 OE -06 CUSTODIAN 1 810 0E-06 CUSTODIAN 1 100 NA -22 CLERICAL ASSISTANT TOTAL PART TIME EMPLOYEES 61030 Seasonal Employee Expense 670 1325 NA -26 SANITATION DRIVER 940 1325 NA -26 EQUIPMENT OPERATOR 100 898 NA -01 LABORER-ST/WNWV-SEASONAL 250 898 NA -01 LABORER-ST/WNWV-SEASONAL TOTAL SEASONAL EMPLOYEES FY 2018 FTE BUDGET 0.02 $ 1,069 2.00 $ 102,177 1.00 $ 55,625 86.42 $ 4,857,422 FY 2019 FTE BUDGET 0.00 $ - 2.00 $ 103,738 1.00 $ 56,460 87.42 $4,948,579 FY 2020 FTE BUDGET 0.00 $ - 2.00 $ 106,133 1.00 $ 57,749 87.42 $ 5,101, 997 0.38 $ 17,441 0.38 $ 17,855 0.38 $ 18,263 0.08 $ 3,617 0.08 $ 3,759 0.08 $ 3,845 0.15 $ 6,782 0.15 $ 7,048 0.15 $ 7,209 0.50 $ 11,887 0.68 $ 17,658 0.68 $ 18,058 1.11 $ 39,727 1.29 $ 46,320 1.29 $ 47,375 0.67 $ 20,653 0.67 $ 20,963 0.67 $ 21,444 0.75 $ 23,119 0.75 $ 23,466 0.75 $ 24,004 2.03 $ 48,687 1.47 $ 35,649 1.47 $ 36,456 1.11 $ 25,743 0.36 $ 8,474 0.36 $ 8,670 4.56 $ 118,202 3.25 $ 88,552 3.25 $ 90,574 TOTAL PUBLIC WORKS DEPARTMENT 92.09 $ 5,015,351 91.96 $ 5,083,451 91.96 $ 5,239,946 -121- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP -GR POSITION CLASS FY 2018 FY 2019 FY 2020 FTE BUDGET FTE BUDGET FTE BUDGET Public Works Administration -FT 10054100 61010 100 3325 GE -41 PUBLIC WORKS DIRECTOR 1.00 $ 113,491 1.00 $ 117,283 1.00 $ 119,966 ASST PUBLIC WORKS 10054100 61010 100 1490 GE -38 DIRECTOR 1.00 $ 84,185 1.00 $ 81,065 1.00 $ 78,495 10054100 61010 100 225 GE -25 SECRETARY 1.00 $ 48,120 1.00 $ 48,841 1.00 $ 49,956 10054100 61010 100 811 NA -50 ACCOUNT CLERK II 1.00 $ 55,625 1.00 $ 56,460 1.00 $ 57,749 STREET MAINTENANCE 10054100 61010 100 3100 GE -37 SUPERVISOR 0.00 $ 0.00 $ 0.00 $ Total 4.00 $ 301,421 4.00 $ 303,649 4.00 $ 306,166 Public Works Administration -Part -Time 10054100 61030 100 400 NA -22 CLERICAL ASSISTANT 0.50 $ 11,887 0.68 $ 17,658 0.68 $ 18,058 Total 0.50 $ 11,887 0.68 $ 17,658 0.68 $ 18,058 Riverfront Management -FT General Fund 10054330 61010 100 1475 GD -05 TRUCK DRIVER 0.02 $ 1,069 0.00 $ - 0.00 $ - 10054330 61010 100 2375 GD -07 EQUPMENT OPERATOR 11 0.02 $ 1,086 0.10 $ 5,566 0.10 $ 5,694 10054330 61010 100 2205 GD -06 MAINTENANCE WORKER 0.50 $ 27,568 0.50 $ 27,981 0.50 $ 28,621 10054330 61010 100 GE -31 FIELD SUPERVISOR 0.02 $ 1,288 0.00 $ 0.00 $ - 10054330 61010 100 GD -11 FOREMAN 0.00 $ 0.00 $ 0.00 $ Riverfront Management -Seasonal General Fund LABOR ER-STAIVNVW- 10054330 61030 100 898 NA -01 SEASONAL Total 0.56 $ 31,011 0.60 $ 33,547 0.60 $ 34,315 0.21 $ 5,198 0.21 $ 5,271 0.21 $ 5,388 Total 0.21 $ 5,198 0.21 $ 5,271 0.21 $ 5,388 Floodwall Oper.IMaintenance 10054340 61010 100 2205 GD -06 MAINTENANCE WORKER 0.02 $ 1,103 0.02 $ 1,119 0.02 $ 1,145 10054340 61010 100 2300 GD -08 EQUIPMENT OPERATOR 11 0.06 $ 3,269 0.04 $ 2,211 0.04 $ 2,274 10054340 61010 100 2655 GD -11 FOREMAN 0.44 $ 25,699 0.31 $ 18,356 0.31 $ 18,789 10054340 61010 100 GE -31 FIELD SUPERVISOR 0.02 $ 1,288 0.10 $ 6,863 0.10 $ 7,018 10054340 61010 100 2375 GD -06 EQUPMENT OPERATOR 1 0.10 $ 5,415 0.10 $ 5,458 0.10 $ 5,615 Total 0.64 $ 36,774 0.57 $ 34,007 0.57 $ 34,841 Floodwall Oper.IMaintenance-Seasonal 10054340 61030 100 898 NA -01 LABORER SEASONAL 0.13 $ 3,015 0.13 $ 3,060 0.13 $ 3,131 Total 0.13 $ 3,015 0.13 $ 3,060 0.13 $ 3,131 Street & Traffic Lighting -FT General Fund 10054430 61010 100 2300 GD -08 EQUIPMENT OPERATOR 11 0.02 $ 1,097 0.02 $ 1,091 0.02 $ 1,116 TRAFFIC SIGNAL 10054430 61010 100 2925 GE -31 TECHNICIAN II 1.87 $ 115,928 1.86 $ 119,664 1.86 $ 125,115 Total 1.89 $ 117,025 1.88 $ 120,755 1.88 $ 126,231 Street Signs & Markings -FT General Fund TRAFFIC SIGNAL 10054435 61010 100 2925 GE -31 TECHNICIAN II 0.00 $ - 0.01 $ 597 0.01 $ 640 10054435 61010 100 2375 GD -06 EQUIPMENT OPERATOR 1 0.50 $ 26,171 0.45 $ 23,992 0.45 $ 24,541 10054435 61010 100 2300 GD -08 EQUIPMENT OPERATOR 11 0.82 $ 45,014 0.85 $ 46,465 0.85 $ 47,528 Total 1.32 $ 71,185 1.31 $ 71,054 1.31 $ 72,709 Street Signs & Markings -Seasonal General Fund LABOR ER-STJW/WW- 10054435 61030 100 898 NA -01 SEASONAL 0.67 $ 15,539 0.67 $ 15,772 0.67 $ 16,136 Total 0.67 $ 15,539 0.67 $ 15,772 0.67 $ 16,136 -122- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP -GR POSITION CLASS FY 2018 FY 2019 FY 2020 FTE BUDGET FTE BUDGET FTE BUDGET Port of Dubuque Maintenance -FT 10054450 61010 100 2205 GD -06 MAINTENANCE WORKER 0.32 $ 17,643 0.25 $ 13,990 0.25 $ 14,310 TRAFFIC SIGNAL 10054450 61010 100 2925 GE -31 TECHNICIAN II 0.01 $ 560 0.01 $ 597 0.01 $ 640 10054450 61010 100 1475 GD -05 EQUIPMENT OPERATOR 1 0.00 $ - 0.25 $ 13,915 0.25 $ 14,233 Total 0.33 $ 18,203 0.51 $ 28,502 0.51 $ 29,183 Port of Dubuque Maintenance -Seasonal 10054450 61030 100 898 NA -01 LABORER -SEASONAL 1.02 $ 24,935 0.46 $ 11,546 0.46 $ 11,801 Total 1.02 $ 24,935 0.46 $ 11,546 0.46 $ 11,801 Street Maintenance -FT Road Use Tax Fund ASSISTANT 25054400 61010 250 GD -06 HORTICULTURALIST 0.25 $ 0.25 $ 3,932 0.25 $ 12,157 25054400 61010 100 2205 GD -06 MAINTENANCE WORKER 0.00 $ 0.07 $ 3,918 0.07 $ 4,007 25054400 61010 250 GD -05 UTILITY WORKER 0.83 $ 40,114 3.85 $ 190,356 3.85 $ 196,663 UTILITY WORKER 25054400 61010 NA -48 APPRENTICE 0.00 $ - 1.00 $ 37,524 1.00 $ 38,367 25054400 61010 250 2300 GD -08 EQUIPMENT OPERATOR 11 2.43 $ 133,269 0.94 $ 52,374 0.94 $ 57,133 25054400 61010 250 2375 GD -06 EQUIPMENT OPERATOR I 2.78 $ 145,892 3.88 $ 207,910 3.88 $ 213,308 25054400 61010 250 2655 GD -11 FOREMAN 2.63 $ 155,406 2.75 $ 163,682 2.75 $ 168,242 25054400 61010 250 GE -31 FIELD SUPERVISOR 0.77 $ 49,581 0.73 $ 50,096 0.73 $ 51,234 25054400 61010 250 1475 GD -05 TRUCK DRIVER 7.03 $ 366,662 3.87 $ 203,691 3.87 $ 206,570 Street Maintenance -PT Road Use Tax Fund 25054400 61020 250 OE -06 CUSTODIAN 1 Street Maintenance -Seasonal Road Use Tax Fund LABOR ER-STNVNVW- 25054400 61030 250 898 NA -01 SEASONAL Total 16.72 $ 890,924 17.34 $ 913,483 17.34 $ 947,681 0.38 $ 17,441 0.38 $ 17,855 0.38 $ 18,263 Total 0.38 $ 17,441 0.38 $ 17,855 0.38 $ 18,263 0.75 $ 17,394 0.00 $ - 0.00 $ Total 0.75 $ 17,394 0.00 $ - 0.00 $ Street Cleaning -Full Time Road Use Tax Fund 25054410 61010 250 1475 GD -05 TRUCK DRIVER 0.85 $ 42,303 0.83 $ 45,021 0.83 $ 46,046 25054410 61010 250 2205 GD -06 MAINTENANCE WORKER 0.00 $ - 0.00 $ 0.00 $ - 25054410 61010 250 2375 GD -06 EQUIPMENT OPERATOR 1 1.59 $ 83,032 0.00 $ 0.00 $ 25054410 61010 250 2300 GD -08 EQUIPMENT OPERATOR 11 1.68 $ 93,029 3.21 $ 178,967 3.21 $ 183,442 Total 4.12 $ 218,364 4.04 $ 223,988 4.04 $ 229,488 Street Cleaning -Seasonal -Road Use Tax Fund LABOR ER-STNV/WW- 25054410 61030 250 898 NA -01 SEASONAL 0.36 $ 8,349 0.36 $ 8,474 0.36 $ 8,670 Total 0.36 $ 8,349 0.36 $ 8,474 0.36 $ 8,670 Snow Removal -FT 25054420 61010 250 2925 GE -31 TRAFFIC SIGNAL TECH 11 0.12 $ 7,310 0.12 $ 7,617 0.12 $ 8,001 25054420 61010 250 GD -05 UTILITY WORKER 0.17 $ 8,216 0.85 $ 42,076 0.85 $ 43,341 ASSISTANT 25054420 61010 250 GD -06 HORTICULTURALIST 0.17 $ - 0.17 $ 2,674 0.17 $ 8,267 25054420 61010 250 2205 GD -06 MAINTENANCE WORKER 0.16 $ 8,822 0.16 $ 8,954 0.16 $ 9,159 25054420 61010 250 2655 GD -11 FOREMAN 0.78 $ 46,170 0.90 $ 53,455 0.90 $ 54,844 25054420 61010 250 GE -31 FIELD SUPERVISOR 0.17 $ 10,946 0.17 $ 11,667 0.17 $ 11,931 25054420 61010 250 2300 GD -08 EQUIPMENT OPERATOR 11 1.13 $ 62,018 1.12 $ 62,076 1.12 $ 63,663 25054420 61010 250 2375 GD -06 EQUIPMENT OPERATOR 1 1.70 $ 90,320 1.72 $ 92,952 1.72 $ 95,293 -123- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP -GR POSITION CLASS 25054420 61010 250 1475 GD -05 TRUCK DRIVER FY 2018 FTE BUDGET FY 2019 FY 2020 FTE BUDGET FTE BUDGET 1.67 $ 85,882 1.00 $ 52,270 1.00 $ 53,981 Total 6.07 $ 319,684 6.21 $ 333,741 6.21 $ 348,480 Sanitary Sewer Maintenance -FT Sewer Use Fund 61054300 61010 610 2375 GD -06 EQUIPMENT OPERATOR I 61054300 61010 610 2300 GD -08 EQUIPMENT OPERATOR II 61054300 61010 610 1475 GD -05 TRUCK DRIVER 61054300 61010 610 2655 GD -11 FOREMAN Storm Sewer Maintenance -FT Stormwater Fund 62054310 61010 620 2300 GD -08 61054300 61010 610 GD -05 62054310 61010 620 2375 GD -06 62054310 61010 620 1475 GD -05 62054310 61010 620 GE -31 62054310 61010 620 2655 GD -11 Refuse Collection -FT Refuse Fund 67054500 61010 670 6100 GE -35 67054500 61010 670 2655 GD -11 67054500 61010 670 GD -04 67054500 61010 670 1300 GD -06 Refuse Collection -PT 67054500 61020 670 OE -06 Refuse Collection -Seasonal Refuse Fund 67054500 61030 670 898 NA -01 Yard Waste Collection -FT Refuse Fund 67054510 61010 670 2655 GD -11 67054510 61010 670 1300 GD -06 67054510 61010 670 6100 GE -35 3.41 $ 184,313 0.77 $ 41,810 0.41 $ 21,741 1.35 $ 81,328 3.38 0.72 0.30 1.31 $ 183,625 3.38 $ 39,682 0.72 $ 15,747 0.30 $ 79,308 1.31 $ 189,029 $ 40,852 $ 16,255 $ 81,116 Total 5.94 $ 329,192 6.01 $ 333,431 6.01 $ 342,859 EQUIPMENT OPERATOR II UTILITY WORKER EQUIPMENT OPERATOR I TRUCK DRIVER FIELD SUPERVISOR FOREMAN 0.07 $ 3,801 0.10 $ 5,512 0.00 $ - 0.30 $ 15,069 0.92 $ 49,986 1.12 $ 61,652 0.02 $ 1,069 0.00 $ 0.02 $ 1,288 0.00 $ 0.80 $ 48,403 0.73 $ 42,988 0.10 0.30 1.12 0.00 0.00 0.73 $ 5,674 $ 15,607 $ 63,225 $ $ $ 43,967 Total 1.83 $ 104,547 1.95 $ 110,152 1.95 $ 112,866 RESOURCE MGMT COORDINATOR LEAD SANITATION DRIVER SANITATION LABORER SANITATION DRIVER CUSTODIAN I LABORER-STNVNVW- SEASONAL 0.40 $ 27,723 0.40 0.40 $ 24,201 0.40 1.00 $ 52,646 1.00 8.80 $ 475,221 8.75 $ 29,688 $ 24,565 $ 53,436 $ 472,910 0.40 $ 32,029 0.40 $ 25,124 1.00 $ 54,717 8.75 $ 486,410 Total 10.60 $ 579,791 10.55 $ 580,599 10.55 $ 598,280 0.08 $ 3,617 0.08 $ 3,759 0.08 $ 3,845 Total 0.08 $ 3,617 0.08 $ 3,759 0.08 $ 3,845 0.09 $ 2,774 0.09 $ 2,816 0.09 $ 2,881 Total 0.09 $ 2,774 0.09 $ 2,816 0.09 $ 2,881 LEAD SANITATION DRIVER 0.10 $ 6,050 0.10 $ 6,141 0.10 $ 6,281 SANITATION DRIVER 0.80 $ 42,428 0.90 $ 49,034 0.90 $ 50,156 RESOURCE MGMT COORDINATOR 0.10 $ 6,930 0.10 $ 7,422 0.10 $ 8,007 Total 1.00 $ 55,408 1.10 $ 62,597 1.10 $ 64,444 Yard Waste Collection -Seasonal Refuse Fund 67054510 61030 670 1325 NA -26 SANITATION DRIVER 0.50 $ 15,413 0.50 $ 15,644 0.50 $ 16,003 Total 0.50 $ 15,413 0.50 $ 15,644 0.50 $ 16,003 Large Item Collection -FT Refuse Fund 67054520 61010 670 2655 GD -11 LEAD SANITATION DRIVER 0.10 $ 6,050 0.10 $ 6,141 0.10 $ 6,281 RESOURCE MGMT 67054520 61010 670 6100 GE -35 COORDINATOR 0.06 $ 4,159 0.06 $ 4,454 0.06 $ 4,804 Recycling Collection Program -FT Refuse Fund RESOURCE MGMT 67054530 61010 670 6100 GE -35 COORDINATOR 67054530 61010 670 2655 GD -11 67054530 61010 670 1300 GD -06 Total 0.16 $ 10,209 0.16 $ 10,595 0.16 $ 11,085 0.44 $ 30,494 0.44 $ 32,657 0.44 $ 35,231 LEAD SANITATION DRIVER 0.40 $ 24,201 0.40 $ 24,565 0.40 $ 25,124 SANITATION DRIVER 7.40 $ 393,244 7.35 $ 388,731 7.35 $ 401,666 Total 8.24 $ 447,939 8.19 $ 445,953 8.19 $ 462,021 -124- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP -GR POSITION CLASS Recycling Collection Program -Seasonal Refuse Fund SANITATION DRIVER - 67054530 61030 670 898 NA -01 SEASONAL City Garage -FT Service Fund 81054600 61010 810 3225 GE -35 81054600 61010 810 2525 GD -10 81054600 61010 810 835 GD -03 81054600 61010 810 7250 GD -11 FY 2018 FTE BUDGET FY 2019 FY 2020 FTE BUDGET FTE BUDGET 0.08 $ 2,466 0.08 $ 2,503 0.08 $ 2,560 Total 0.08 $ 2,466 0.08 $ 2,503 0.08 $ 2,560 EQUIP MAINT. SUPERVISOR MECHANIC STOCK CLERK LEAD MECHANIC City Garage -PT Service Fund 81054600 61020 810 3056 OE -06 CUSTODIAN I Street Maintenance -FT Internal Service 82054400 61010 820 1475 GD -05 TRUCK DRIVER Street Maintenance -Seasonal Internal Service 82054400 61030 820 898 NA -01 LABORER -SEASONAL Landfill -FT 94054200 61010 940 2625 GE -35 94054200 61010 940 2625 GE -35 94054200 61010 620 2655 GD -11 94054200 61010 940 2525 GD -10 94054200 61010 940 2300 GD -08 94054200 61010 940 2948 GD -08 94054200 61010 940 870 GD -04 Landfill -Seasonal 94054200 61030 940 1325 NA -26 Composting -Landfill Program -FT 94054210 94054210 94054210 61010 61010 61010 940 2625 GE -35 620 2655 GD -11 940 2300 GD -08 94054210 61010 940 2948 GD -08 94054210 61010 940 2625 GE -35 HHMRCC-Landfill Program -FT 94054220 61010 940 2625 GE -35 94054220 61010 940 2625 GE -35 94054220 61010 620 2655 GD -11 94054220 61010 940 2300 GD -08 94054220 61010 940 2948 GD -08 94054220 61010 940 870 GD -04 1.00 $ 80,611 7.00 $ 390,861 2.00 $ 91,423 2.00 $ 113,194 1.00 7.00 2.00 2.00 $ 68,953 $ 397,566 $ 94,245 $ 116,231 1.00 7.00 2.00 2.00 $ 70,530 $ 411,821 $ 97,084 $ 120,400 Total 12.00 $ 676,089 12.00 $ 676,995 12.00 $ 699,835 0.15 $ 6,782 0.15 $ 7,048 0.15 $ 7,209 Total 0.15 $ 6,782 0.15 $ 7,048 0.15 $ 7,209 0.00 $ - 0.00 $ - 0.00 $ Total 0.00 $ - 0.00 $ - 0.00 $ 0.00 $ - 0.00 $ - 0.00 $ Total 0.00 $ DMASWAADMINISTRATOR LANDFILL SUPERVISOR FOREMAN MECHANIC EQUIPMENT OPERATOR II LANDFILL EQUIP OPERATOR LABORER-G.D. 0.75 0.70 0.00 1.00 3.00 - 0.00 $ - 0.00 $ $ 63,139 $ 56,369 $ $ 54,199 $ 166,539 0.40 0.63 0.63 1.00 1.55 $ 34,179 $ 51,493 $ 36,847 $ 57,346 $ 88,208 0.40 0.63 0.63 1.00 1.55 $ 35,049 $ 52,654 $ 37,686 $ 58,646 $ 90,227 2.45 $ 132,298 2.80 $ 154,319 2.80 $ 158,404 1.20 $ 61,294 1.10 $ 57,084 1.10 $ 58,403 Total 9.10 $ 533,838 8.11 $ 479,476 8.11 $ 491,069 EQUIPMENT OPERATOR 0.75 $ 23,119 0.75 $ 23,466 0.75 $ 24,004 Total 0.75 $ 23,119 0.75 $ 23,466 0.75 $ 24,004 DMASWAADMINISTRATOR 0.03 $ 2,526 0.05 $ 4,272 0.05 $ 4,381 FOREMAN 0.00 $ 0.05 $ 2,924 0.05 $ 2,991 EQUIPMENT OPERATOR II 0.00 $ - 0.00 $ - 0.00 $ - LANDFILL EQUIP OPERATOR 0.15 $ 8,081 0.15 $ 8,267 0.15 $ 8,456 LANDFILL SUPERVISOR 0.05 $ 4,026 0.05 $ 4,086 0.05 $ 4,179 Total 0.23 $ 14,633 0.30 $ 19,549 0.30 $ 20,007 DMASWAADMINISTRATOR LANDFILL SUPERVISOR FOREMAN EQUIPMENT OPERATOR II LANDFILL EQUIP OPERATOR LABORER-G.D. 0.10 0.10 0.00 0.00 $ 8,419 $ 8,053 0.10 0.10 0.10 0.10 8,545 8,174 5,849 5,621 0.10 0.10 0.10 0.10 8,763 8,358 5,982 5,749 0.05 $ 2,644 0.05 $ 2,692 0.05 $ 2,753 0.80 $ 40,883 0.65 $ 33,680 0.65 $ 34,458 Total 1.05 $ 59,999 1.10 $ 64,561 1.10 $ 66,063 -125- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COM PLEM ENT SUM MARY ACCT FD JC WP -GR POSITION CLASS Education & Communication -Landfill Program -FT 94054230 94054230 94054230 94054230 61010 61010 61010 61010 940 2625 GE -35 940 2625 GE -35 620 2655 GD -11 940 870 GD -04 E -Scrap Recycling -Landfill Program -FT 94054240 94054240 94054240 94054240 94054240 94054240 61010 61010 61010 61010 61010 61010 940 940 620 940 940 940 2625 GE -35 2625 GE -33 2655 GD -11 2948 GD -08 870 GD -04 2300 GD -08 DMASWA Rural Recycling Program - FT 94054250 61010 940 2625 GE -35 94054250 61010 620 2655 GD -11 94054250 61010 940 2625 GE -33 DMASWA Gas Collection - FT 94054260 61010 94054260 61010 94054260 61010 94054260 61010 940 2625 GE -35 940 2625 GE -35 620 2655 GD -11 940 2300 GD -08 FY 2018 FTE BUDGET FY 2019 FY 2020 FTE BUDGET FTE BUDGET DMASWAADMINISTRATOR 0.00 $ - 0.05 $ 4,272 0.05 $ 4,381 LANDFILL SUPERVISOR 0.00 $ - 0.05 $ 4,086 0.05 $ 4,179 FOREMAN 0.00 $ 0.05 $ 2,924 0.05 $ 2,991 SCALE HOUSE OPERATOR 0.00 $ - 0.20 $ 10,379 0.20 $ 10,618 Total 0.00 $ - 0.35 $ 21,661 0.35 $ 22,169 DMASWAADMINISTRATOR 0.03 $ 2,526 0.15 $ 12,817 0.15 $ 13,144 LANDFILL SUPERVISOR 0.05 $ 4,026 0.05 $ 4,086 0.05 $ 4,179 FOREMAN 0.00 $ 0.05 $ 2,924 0.05 $ 2,991 LANDFILL EQUIP OPERATOR 0.35 $ 19,004 0.00 $ - 0.00 $ - SCALE HOUSE OPERATOR 0.00 $ 0.05 $ 2,595 0.05 $ 2,654 EQUIPMENT OPERATOR 11 0.00 $ 0.35 $ 19,672 0.35 $ 20,122 Total 0.43 $ 25,556 0.65 $ 42,094 0.65 $ 43,090 DMASWAADMINISTRATOR 0.02 $ 1,684 0.10 $ 8,545 0.10 $ FOREMAN 0.00 $ 0.02 $ 1,170 0.02 $ LANDFILL SUPERVISOR 0.00 $ 0.02 $ 1,635 0.02 $ 8,763 1,196 1,672 Total 0.02 $ 1,684 0.14 $ 11,350 0.14 $ 11,631 DMASWAADMINISTRATOR 0.07 $ 5,893 0.15 $ 12,817 0.15 $ 13,144 LANDFILL SUPERVISOR 0.10 $ 8,053 0.10 $ 8,174 0.10 $ 8,358 FOREMAN 0.00 $ - 0.10 $ 5,849 0.10 $ 5,982 EQUIPMENT OPERATOR 11 0.00 $ - 0.00 $ - 0.00 $ - Total 0.17 $ 13,946 0.35 $ 26,840 0.35 $ 27,484 TOTAL PUBLIC WORKS DEPT. 92.09 $5,015,351 91.96 $5,083,451 91.96 $ 5,239,946 -126- Capital Improvement Projects by Department/Division PUBLIC WORKS CIP FY 17 Actual FY 18 Actual FY 19 Adopted FY 20 Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 1012477 MSC MR QUALITY 32,000 1022541 MSC LED LIGHTING 50,251 10,468 0 1022718 JULE BUILDING CONVERSION 48,000 2501227 CURB RAMP PROGRAM - 388,514 412,062 242,946 2501230 ASPHALT MILLING PROGRAM 68,928 86,841 0 2502223 LIQUID DEICER BLEND SYST 39,749 0 2502539 DUMP TRK REPLC 233,361 0 2502604 RADIO REPLACEMENT - 23,156 0 3001006 CONCRETE SECTION REPAIR 11,912 6,786 25,000 3001226 CURB REPLACEMENT PROGRAM 60,022 7,792 25,000 25,000 3001227 CURB RAMP PROGRAM 322,995 82,411 - 177,358 3001230 ASPHALT MILLING PROGRAM 32,636 - 103,595 80,000 3001432 STEPS, RAILINGS, FENCING 22,593 5,000 10,000 3001445 FLOODWALL POST FLOOD REPA 7,814 44,828 25,000 81,500 3001839 AERIAL BUCKET TRUCK 173,791 3001938 DT SIGN POST REPLAC PROJ 9,977 23,349 0 3002038 PORT AMENITIES MAINT 19,393 0 3002039 DUMP TRUCK REPLACEMENT - 186,732 157,319 320,930 3002151 WAYFINDING SIGN REPLACE 527 329 - 25,000 3002221 TRUCK -MOUNTED NEW CONCEPT - 71,360 19,000 0 3002225 MOBILE GIS SYSTEM 800 0 3002539 DUMP TRK REPLC - 252,633 142,010 0 3002541 MSC LED LIGHTING 10,068 0 3002542 MSC SECUIRTY CAMERAS - 19,295 0 3002604 RADIO REPLACEMENT 103,649 0 3002665 VEH REFUEL SYSTEM UPGRADE 8,636 18,949 - 0 3002719 SALT STORAGE BUILDING - 44,723 305,085 0 3002789 HAWTHORNE BOAT RAMP 41,410 3502480 PURINA DRIVE FL OODWALL 85,488 0 6701533 DUAL PACKER RECYCLE VEH 275,627 415,720 490,000 6702542 MSC SECUIRTY CAMERAS 18,086 - 0 6702601 RADIO REPLACEMENT - 58,410 - 0 7101341 SANITARY SEWER ROOT FOAM 20,482 24,686 30,000 30,000 7101840 SEWER PIPELINE INSPC EQUP - 22,700 - 0 7102405 HIGH PRESSURE SEWER JET - 216,645 0 7202155 FLOOD CONTROL LEVEE CERT 50,000 200,000 7202405 HIGH PRESSURE JETVAC 69,438 0 7202480 PURINA DRIVE FLOODWALL 0 7202601 RADIO REPLACEMENT 9,735 0 7202791 ASSET MANAGEMENT 81,206 7202792 ICE HARBOR ABUTMENT REP 0 0 0 190,000 8102601 RADIO REPLACEMENT 0 12,980 0 0 9402631 LANDFILL CELL#9 PHASE 2 -16,811 0 0 0 9402640 CELLS 4-8 CLOSURE 0 0 0 0 9402685 SHORT-TERM FACILITIES 148,308 0 0 0 9402702 CELL 9 PHASE 3 657,886 2,692,933 0 0 WINTR8 IMPERRIMR2 2, , 1111 -127- PRG RM /DEPT PROJECT DESCRIPTION FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 TOTAL PAGE PUBLIC WORKS Public Works Asphalt Milling Program $ 80,000 $ 82,500 $ 84,562 $ 86,676 $ 88,843 $ 422,581 117 Curb Ramp Program $ 420,304 $ 428,710 $ 437,284 $ 446,030 $ 446,030 $ 2,178,358 118 Floodwall Post -Flood Repair Program $ 81,500 $ 20,000 $ 25,000 $ 25,000 $ 25,000 $ 176,500 119 Wayfinding Signs Replacement $ 25,000 $ 25,000 $ $ - $ - $ 50,000 120 Curb Replacement Program $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 125,000 121 Steps, Hand Railings and Wall -Top Fencing $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 25,000 $ 65,000 122 Street Sign and Post Replacement $ - $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 60,000 123 Concrete Street Section Repair Program $ 25,000 $ - $ 25,000 $ 25,000 $ 25,000 $ 100,000 124 56,000 Gross Vehicle Weight (GVW) Dump Truck Replacement $ 320,930 $ - $ - $ - $ 427,384 $ 748,314 125 Jule Building Conversion $ 48,000 $ - $ - $ - $ - $ 48,000 126 Municipal Services Air Quality Detection $ 32,000 $ - $ - $ - $ - $ 32,000 127 Vacuum Street Sweeper Replacement $ - $ 210,000 $ - $ 214,200 $ - $ 424,200 128 35,000 GVW Dump Truck Replacement $ - $ - $ 381,404 $ - $ 816,424 $ 1,197,828 129 Aerial Bucket Truck Replacement $ 173,791 $ - $ - $ - $ - $ 173,791 130 Hawthorne Street Boat Ramp Repair $ 41,410 $ 333,300 $ - $ - $ - $ 374,710 131 Wheel Loader Purchase $ - $ 206,350 $ - $ - $ - $ 206,350 132 Municipal Service Center CNG Retrofit $ $ $ 27,163 $ 323,886 $ $ 351,049 133 Business Type Cab -Over Solid Waste Vehicles $ 490,000 $ 676,260 $ 608,628 $ 620,800 $ 627,314 $ 3,023,002 134 Sanitary Sewer Root Foaming $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 135 High Pressure Sewer Jet Cleaner $ - $ - $ - $ - $ 210,000 $ 210,000 136 Flood Control Levee Repair $ 200,000 $ - $ - $ - $ - $ 200,000 137 Flood Control Units $ - $ - $ 386,000 $ - $ - $ 386,000 138 Hard Surface Deep Cleaning Self -Propelled Unit $ - $ 166,100 $ - $ - $ - $ 166,100 139 Asset Management System $ 81,206 $ - $ - $ - $ - $ 81,206 140 Ice Harbor Concrete Abutment Repair $ 190,000 $ $ $ $ $ 190,000 141 Ice Harbor Gate Fender Replacement $ - $ - $ - $ 145,000 $ - $ 145,000 142 Grand Total $ 2,274,141 $ 2,228,220 $ 2,055,041 $ 1,966,592 $ 2,760,995 $11,284,989 -128-