Loading...
Public Works Department FY19 Budget Presentation Copyrighted February 26, 2018 City of Dubuque Public Hearings # 3. ITEM TITLE: Public Works FY2019 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type FY19 Public Works Department Budget Supporting Documentation Recommendation Public Works 59- This page intentionally left blank. -60- PUBLIC WORKS DEPARTMENT FY 2017 FY 2018 FY 2019 % Change From Budget Highlights Actual Budget Requested FY2018 Budget Expenses Employee Expense 7,626,729 8,219,087 8,075,566 (1.7)% Supplies and Services 6,369,091 6,840,644 6,763,449 (1.1)% Machinery and Equipment 274,749 394,450 743,911 88.6 % Subtotal 14,270,569 15,454,181 15,582,926 0.8 % Public Works Administrative/Garage Stores 761,217 981,516 882,360 (10.1)% Administrative Overhead Recharge 1,458,134 1,278,811 1,287,797 0.7 % Less Recharges/Service Fund Charges (1,923,158) (2,269,404) (2,097,596) (7.6)% Total Expenses 14,566,762 15,445,104 15,655,487 1.4 % Resources Operating Revenue 37,461 69,137 61,271 (11.4)% Salt Operations Fund 90,227 137,754 113,065 (17.9)% Road Use Tax Fund 5,221,667 5,811,726 6,147,241 5.8 % Sewer Utility Operating Fund 573,671 781,129 830,141 6.3 % Stormwater User Fund 272,744 268,577 241,698 (10.0)% Refuse Collection Fund 3,880,626 3,811,026 3,906,921 2.5 % Landfill Operating Fund 3,205,882 3,449,577 3,365,257 (2.4)% Total Resources 13,282,278 14,328,926 14,665,594 2.3 % Debt Service abated with Sales Tax 30% 529,798 121,337 137,208 13.1 % Debt Service abated with Landfill Fees 479,961 667,559 662,659 (0.7)% Debt Service abated with Solid Waste Fees 59,853 6,842 7,363 7.6 % Total Non-Property Tax Debt Service 1,069,612 795,738 807,230 1.4 % Property Tax Support 1,284,484 1,116,178 989,893 (126,285) Percent Increase (Decrease) (11.3)% Personnel -Authorized FTE 92.09 92.09 91.96 -61- FY 2017 FY 2018 FY 2019 %Change From Solid Waste Collection Fund Summary Actual Budget Requested FY 2018 Budget Administrative Overhead Recharges/Utility Billing 1,089,206 914,569 927,857 1.5 % Refuse Operations 2,791,420 2,896,457 2,979,064 2.9 % Debt Service - Refuse 59,853 6,842 7,363 7.6 % Payment to Depreciation 224,374 350,000 460,000 31.4 % Total Requirements 4,164,853 4,167,868 4,374,284 5.0 % Refuse Fees (Incl tipper carts/other) 3,783,126 3,816,978 3,954,135 3.6 % UBP Single Use Refuse Sticker 101,457 91,750 101,457 10.6 % Sales Tax Collection 7,555 8,534 7,555 (11.5)% Yard Waste Stickers&Ties 131,726 122,860 164,761 34.1 % Leaf Rake Out Fees 5,136 4,656 5,136 10.3 % Food Scrap 8,403 3,600 8,403 133.4 % Recyclable Sales 10,069 - 10,069 - Subscription Recycling 3,548 3,385 3,548 4.8 % Large Item Pickup 22,770 21,369 24,770 15.9 % Miscellaneous Revenue 115,790 57,421 60,476 5.3 % Total Resources 4,189,580 4,130,553 4,340,310 5.1 % Annual Operating Surplus (Deficit) 24,727 (37,315) (33,974) 3,341 Personnel -Authorized FTE 20.75 20.75 20.75 Solid Waste User Fee Rate Increase 6.26% 2.30% 1.70% Solid Waste User Fee $ 14.77 $ 15.11 $ 15.37 Revenue 1% Rate Increase Generates $ 34,893 FY 2017 FY 2018 FY 2019 %Change From Salt Operations Fund Summary Actual Budget Requested FY 2018 Budget Salt Purchase 71,593 117,760 90,400 (23.2)% Salt Handling Fees 7,327 11,440 11,440 - Miscellaneous Fees 7,062 3,173 5,996 89.0 % Administrative Overhead 4,245 5,024 4,879 (2.9)% Property Maintenance - 357 350 (2.0)% Total Requirements 90,227 137,754 113,065 (17.9)% Salt Sales 72,530 117,760 90,440 (23.2)% Salt Storage Fees 7,193 11,500 11,500 - Salt Handling Fees 7,164 11,440 11,440 - Total Resources 86,887 140,700 113,380 (19.4)% Annual Operating Surplus (Deficit) (3,340) 2,946 315 (2,631) -62- Improvement Package Summary General Fund 1 of 1 This decision package provides funds to increase the hours of the part-time clerical position from 1,040 hours (0.50 FTE) to 1,414 hours (0.68 FTE) annually. The Public Works Department staff includes one full time account clerk and one full time secretary position. In addition to the full-time positions, there is also one part-time clerical position. Over the past years, the increase volume related to phone calls and Web Q/A data entries has increased. In Fiscal Year 2016, the Public Works reported a 30% increase in the number of Web Q/A entries reported (6,101) over Fiscal Year 2015. In Fiscal year 2017, the department saw a 37% increase in Web Q/A entries, with 8,369 records entered during FY17 (this included a major windstorm). The department is making sure all issues get entered into Web Q/A. There have been several instances when full time staff were on vacation or sick time and leaving one full- time staff person available to answer the phone, provide radio communication with field crews and enter citizen requests into the Web Q/A system until the part-time staff arrives. By providing additional funding to increase the part-time clerical position from 0.50 FTE to 0.68 FTE (additional 374 hours), it will allow for adequate staffing at the front desk during times of vacation and sick leave usage and ensure the success of the departments goal to continue providing effective and efficient services to our citizens. Funding this request will also assist the Department in its goal of providing High Performance Government within the City's organization. Related Cost: $ 5,473 Tax Funds Recurring Recommend -Yes Property Tax Impact: $ 0.0022 0.02% Activity:Administration Sanitary Sewer Fund 1 of 1 This decision package would provide funding to convert the current diesel-powered vehicles to Compressed Natural Gas (CNG) powered vehicles. CNG is the cleanest burning transportation fuel on the market today. CNG burns cleaner that than petroleum based products because of its lower carbon content. Studies show CNG produces 20-30% fewer greenhouse gas emissions and 95%fewer tailpipe emissions then petroleum products. This decision package is designed to help support the goal to reduce the community's carbon footprint (50% by 2030) and would position the department to use Bio-CNG which is produced locally and may become available as early at 2020. The additional up -front cost would add to the life cycle cost of the units, however, some of the cost would be reduced due to lower maintenance costs of the unit. The department will continue to explore partnerships with Black Hills Energy and a local CNG provider to take advantage of any rebates for the purchase of the unit or future fuel purchases. Funding this request will support the City Council's goal of Sustainable Environment: Preserving and Enhancing Natural Resources. The following vehicle conversions to CNG powered units are requested: Life Cycle Cost Vehicle CNG Cost Increase 4WD Sewer Rodding Truck#2705 $ 22,000 $ 19,620 58,000 GVWJetNac Sewer Cleaning #2704 $ 40,000 $ 34,236 Total Sanitary Sewer CNG Cost $ 62,000 $ 53,856 Related Cost: $ 62,000 Sanitary User Fees Non-Recurring Recommend - No Sanitary Rate Impact: 0.61% Activity: Sewer Maintenance -63- Garage Service Fund 1 of 1 This decision package provides additional funds for training opportunities necessary for the mechanics in regard to the maintenance and upkeep of vehicles using new technology. One of the ways to provide learning opportunities for this workforce is peer to peer training which is best received by attending various types of training events or conferences available throughout the year. Funding this decision package will provide our mechanics the opportunity to obtain training and gain first-hand information which will make them highly productive employees and increase the success of the department's goal to continue providing effective and efficient services to our departments, which provide the services to our citizens. In order to keep up with the needs of a growing municipality and to continue our sustainability initiative, the Public Works Department along with other departments like Police and Fire, are using highly technical vehicles and equipment which are maintained by the vehicle technicians in the Public Works Department. Alternative fuel vehicles and innovative snow and ice control equipment, fire equipment and the police fleet all require that vehicle technicians receive more precise maintenance training then those in the past. Related Cost: $ 10,000 Garage Service Fund Recurring Recommend -Yes Activity: Garage Service Road Use Tax 1 of 5 This decision package provides additional funds for development of a Public Works Utility Worker Apprenticeship program. The Public Works Department has been unable to recruit a diverse and qualified workforce for entry-level positions using our current practices. Under this program, the Department will develop a registered apprenticeship program which would meet the requirements of the Iowa Statewide Apprenticeship Program. The program will include a set minimum hours of structured and supervised on- the-job training and a set minimum hours of classroom related training and instruction over a two-year program. The program will be developed by creating local partnerships with Iowa Works, NICC, union representatives and Public Works field staff, to take full advantage of training grants provided for this type of program. The program will provide the apprentice the education and experience opportunities necessary to develop the skills and knowledge to prepare them for the Public Works Utility Worker Civil Service test. Funding for this program will come in part from the elimination of four (4) seasonal positions in the street maintenance activity. These positions are usually filled by college age students and are short-term three- month positions. There may also be federal grant opportunities for apprenticeships. Related Cost: $ 58,295 Road Use Tax Recurring Recommend -Yes Related Savings: $ (36,105) Road Use Tax Recurring Net Cost: $ 22,190 Activity: Street Maintenance 2 of 5 This decision package provides funds for the purchase of one 85G mini excavator and trailer. These funds would supplement funds requested in the street maintenance operating budget ($86,000) for the replacement of unit#3210, a 14-year-old tractor backhoe scheduled for replacement in FY 2018. Replacing the current backhoe unit with the request mini excavator unit would provide the operator with improved maneuverability in congested work zones.The rotating, short-radius house gives the mini excavator a much broader range of reach for loading trucks and can fit in places where wheel loader backhoes cannot go. The department would benefit from having one of these units available which will used in many different applications including curb repair, concrete section repair,and asphalt pavement base repair. The total cost of the mini excavator and trailer is $135,000. The estimated life of the -64- requested mini excavator is fifteen (15) years. The estimated life of the trailer is twenty (20) years. Related Cost: $ 30,000 Road Use Tax Non-Recurring Recommend -Yes Activity: Street Maintenance 3 of 5 This decision package provides funds to purchase a trailer mounted, variable message board. This unit would be used to provide the driving public additional information related to detours at work zone sites on high volume roadways. The Federal Manual on Uniform Traffic Control Devices (MUTCD) provides guidelines on the required work zone signage for work zones on roadways. The manual also allows for additional optional signage which would provide information to alert the motorist of oncoming work zones. Placed before the work zone, the message board alerts the driver of upcoming lane changes and detours due to street maintenance projects. The availability of these types of units to rent during the construction season, for short term projects is very difficult, so this option is very seldom used on street maintenance projects. Owning our own unit will provide us with an additional tool to communicate with the driving public. This unit would also be made available for use during emergency operations and at large community events. Related Cost: $ 22,000 Road Use Tax Non-Recurring Recommend -Yes Activity: Street Maintenance 4 of 5 This decision package provides funds for the initial acquisition and annual subscription to Cartegraph's Scenario builder for pavement management. The new feature of the Cartegraph Operations Management System will allow the City to enter in multi-year pavement budgets and select rehabilitation options based on budget. It will also show how the pavement conditions city wide would be affected by different rehabilitation strategies. With this information, long term maintenance strategies and budgets could be developed which would best extend the life of our current pavements. The cost to add Scenario Builder to the City's existing license for Cartegraph is $8,700 per year. The one- time implementation cost and training is $4,000. Related Cost: $ 8,700 Road Use Tax Recurring Recommend -Yes Related Cost: $ 4,000 Road Use Tax Non-Recurring Total Cost: $ 12,700 Activity: Street Maintenance 5 of 5 This decision package would provide funding to convert the current diesel-powered vehicles to Compressed Natural Gas (CNG) powered vehicles. CNG is the cleanest burning transportation fuel on the market today. CNG burns cleaner that than petroleum based products because of its lower carbon content. Studies show CNG produces 20-30% fewer greenhouse gas emissions and 95%fewer tailpipe emissions then petroleum products. This decision package is designed to help support the goal to reduce the community's carbon footprint (50% by 2030) and would position the department to use Bio-CNG which is produced locally and may become available as early at 2020. The additional up -front cost would add to the life cycle cost of the units, however, some of the cost would be reduced due to lower maintenance costs of the unit. The department will continue to explore partnerships with Black Hills Energy and a local CNG provider to take advantage of any rebates for the purchase of the unit or future fuel purchases. Funding this request will support the City Council's goal of Sustainable Environment: Preserving and Enhancing Natural Resources. -65- The following vehicle conversions to CNG powered units are requested: Life Cycle Cost Vehicle CNG Cost Increase 15,000 GVW Dump Truck#3231 $ 22,000 $ 17,925 58,000 GVW Dump Truck#3223 $ 40,000 $ 29,950 42,000 GVW Dump Truck#3212 $ 40,000 $ 35,030 Total Street Maintenance CNG Cost $ 62,000 $ 47,875 Related Cost: $ 62,000 Road Use Tax Non-Recurring Recommend - No Activity: Street Maintenance Solid Waste Collection Fund 1 of 4 This decision package would provide funding for collection of electronics to the City's large item pickup collection program. In 2006, the Dubuque Metropolitan Area Solid Waste Agency (DMASWA) adopted a landfill ban on electronics to divert items from being landfilled. Electronics include all types of computer monitors and televisions (both cathode ray tubes, CRTs, and LED/Plasma TV's) VCR's, DVD/Blu-ray players, audio equipment, computer towers and associated equipment, fax machines and associated cables. In discussion with Public Works staff assigned to the landfill and solid waste operations, along with the Dubuque Area Task Force on Illegal Littering and Illegal Dumping (DATFOILID), Public Works staff finds that most of the City's illegal dumps and curbside items contain TV's and monitors. Part of the challenge as identified by staff is that some residents do not have the time or ability to transport these items to a drop-off location. The minimum cost for curb side collection of all types of electronics including one devise with an electronic screen (laptops, monitors, TV's, etc.) will be $20. An additional $15 fee will apply for each additional devise with an electronic screen set out per collection. By including electronics in the City's large item collection program, residents are offered a more convenient and accessible service to manage electronic waste. Related Cost: $ 1,500 Solid Waste User Fees Recurring Recommend -Yes Related Revenue: $ 2,000 Net Cost: $ (500) Solid Waste Rate Impact: (0.01)% Activity: Large Item Collection 2 of 4 This decision package would provide funding for the purchase of an additional 100 wheeled carts for the City's curbside recyclable collection services. As of November 2016, a total of 881, 95-gallon recycling carts have been provided to its "star (3+ recycling bins per week) performers." Recycling carts offers customers a more convenient and greater capacity storage/set-out container to increase recycle habits. It is also equally important to acknowledge the impact that carts have on the workforce. Carts significantly reduces the likelihood of collection worker injury due to repetitive manual heavy lifting. With the increase in recycling carts distributed throughout the community to its "star recyclers," there has been a growing demand for a recycling cart from other active recycling customers. To meet the needs of our recycling customers, this request would provide funds for the purchase of additional tipper carts to meet the growing increased requests by our customers for the larger recycling carts. Estimated life of the -66- carts is fifteen (15) years. Related Cost: $ 5,010 Solid Waste User Fees Non-Recurring Recommend -Yes Solid Waste Rate Impact: 0.14% Activity: Solid Waste Collection 3 of 4 This decision package would provide funding for purchase of an additional 500, 65 gallon wheeled carts to meet the current increased demand in subscription for city refuse carts. The proposal would also help meet the need that is anticipated when customers realize that refuse carts more affordable then subscribing to other optional refuse service such as over-sized can and second can fees. In FY17, the City refuse cart fees were lowered to be more in line with those charged by other similar-sized Iowa municipalities. The result of the lower cart fees was an increase in demand for 65 gallon wheeled carts. This decision package may also help reduce staff injuries associated with repetitive manual lifting of solid waste containers and/or heavy bags and improve neighborhood aesthetics through reduced litter typically associated with torn garbage bags. This proposal is to increase the FY19's maintenance level budget to purchase additional refuse carts based on the demands and anticipation of new subscribers. Estimated life of the carts is fifteen (15) years. Related Cost: $ 25,050 Solid Waste User Fees Non-Recurring Recommend -Yes Related Revenue: $ 32,592 Solid Waste User Fees Recurring Net Cost: $ (7,542) Solid Waste Rate Impact: (0.22)% Activity: Recycling 4 of 4 This decision package would provide funding to convert the current diesel-powered vehicles to Compressed Natural Gas (CNG) powered vehicles. CNG is the cleanest burning transportation fuel on the market today. CNG burns cleaner that than petroleum based products because of its lower carbon content. Studies show CNG produces 20-30% fewer greenhouse gas emissions and 95%fewer tailpipe emissions then petroleum products. This decision package is designed to help support the goal to reduce the community's carbon footprint (50% by 2030) and would position the department to use Bio-CNG which is produced locally and may become available as early at 2020. The additional up -front cost would add to the life cycle cost of the units, however, some of the cost would be reduced due to lower maintenance costs of the unit. The department will continue to explore partnerships with Black Hills Energy and a local CNG provider to take advantage of any rebates for the purchase of the unit or future fuel purchases. Funding this request will support the City Council's goal of Sustainable Environment: Preserving and Enhancing Natural Resources. The following vehicle conversions to CNG powered units are requested: Life Cycle Cost Black Hill Energy Net Life Cycle Vehicle CNG Cost Increase Rebate Cost Increase Rear Loader Cab-Over#3403 $ 40,000 $ 24,363 $ 14,000 $ 10,363 Real Loader Cab-Over#3407 $ 40,000 $ 31,528 $ 14,000 $ 17,528 GVW 4WD Pickup Truck#3419 $ 15,000 $ 14,890 $ — $ 14,890 Small Rear Loader Packer#3406 $ 22,000 $ 20,607 $ — $ 20,607 Total Solid Waste CNG Cost $ 117,000 $ 91,388 $ 28,000 $ 63,388 -67- Related Cost: $ 117,000 Solid Waste User Fees Non-Recurring Recommend - No Related Revenue: $ 28,000 Black Hills Energy Rebate Recurring Net Cost: $ 89,000 Solid Waste Rate Impact: 2.55% Activity: Recycling Dubuque Metropolitan Area Solid Waste Agency (DMASWA) 1 of 3 This decision package would provide funding to purchase an aluminum fork lift ramp to facilitate the loading of materials in the DMASWA's semi-trailer for shipment. This addition will assist with removing potential safety and environmental hazards and reduce time required to load trucks. To offset the expense of this purchase staff anticipates requesting a RCC Innovative Grant of$10,000 to assist with this purchase in FY19. The DMASWA collects and processes over 350,000 pounds of electronics and 90,000 pounds of hazardous waste annually. Electronics includes computers, computer peripherals, cordless tools and small household appliances such as blenders, toasters and mixers, and television and computer monitors. Hazardous waste collected is from residents and select businesses from Dubuque and Delaware counties. Once these items are collected and processed for shipping and loaded into a semi- trailer. Currently staff places double stacked pallets of electronics or single stacked waste drums of hazardous on the rear of the trailer, climb into the trailer and use a pallet jack to move the pallets to the rear of the trailer. This process has significant safety hazards and poses a significant risk to the wellbeing of staff conducting this task. Currently the DMASWA loads over 17 trucks per year. Related Cost: $ 12,000 DMASWA Funds Non-Recurring Recommend -Yes Related Revenue: $ 10,000 RCC Grant Non-Recurring Net Cost: $ 2,000 Activity: DMASWA 2 of 3 This decision package would provide funding to address the changes to the website accessibility as required by the American Disabilities Act (ADA) recently identified as a potential issue. The DMASWA website was first established before 2001. The site has been modified and changed about every two - three years to keep it "fresh" and relevant. This modification will be tasked under the current vendor's service agreement to address in FY18 if approved. During this time, changes will be made to the site regarding some of the pages and update the appearance of the site. This process will be guided through the analytical data collected over the past two years. The website annual website session has increased from 9,000 in 2015 to over 15,000 in 2017 with over 40,000 pages visited the last year. By making these modifications the information easily available to those with vision difficulties and increase the visitors to a "Call to action" activity. The ADA update is estimated at $3,500 and other website design modifications are estimated at $4,500. These modifications will address the Board of Directors goal of community engagement and increase the awareness of diversion programs available to the customer, potentially increasing the amount of material diverted from the landfill. Related Cost: $ 8,000 DMASWA Funds Non-Recurring Recommend -Yes Activity: DMASWA -68- 3 of 3 This decision package would provide funding to add a bucket thumb attachment to the DMASWA's John Deere 350 Excavator. The purpose of a thumb attachment is to allow the operator to utilize the equipment to pick up loose materials to either load materials quickly or separate items from other materials. Specifically, this attachment will allow operators to load tires in a semi-truck at a faster pace than that of the end loader saving time and equipment hours for this operation (fuel and maintenance costs) extending the life of the machines. As the Agency looks to potentially diverting wood waste, this attachment can be used to separate the various types of wood such as untreated from treated for processing. This provides a safe alternative to removing materials by hand. This request requires the machine to be modified by adding hydraulic lines on the boom to the attachment to allow the addition of this attachment and the addition of a thumb to the bucket. The purchase price of the equipment with the installation of the required hydraulic lines and valves is $19,500. Related Cost: $ 19,500 DMASWA Funds Non-Recurring Recommend -Yes Activity: DMASWA Significant Line Items Employee Expense 1. FY 2019 employee expense reflects a 1.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution increased from 8.93% in FY 2018 to 9.44% in FY 2019. This resulted in an increase of City (PERS expense of$26,680 in Public Works. The employee contribution increased from 5.95% in FY 2018 to 6.29% in FY 2019. 3. The City portion of health insurance expense is decreased from $1,325 in FY 2018 to $1,193 in FY 2019 per month per contract which results in an annual cost savings of-$128,360 or -10.00%. 4. Workers' Compensation decreased from $429,301 in FY 2018 to $362,859 in FY 2019. FY 2017 actual was 446,864. 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 decreased from $331,391 in FY 2018 to $304,391 in FY 2019. FY 2017 actual was $244,493. 6. Sick Leave Payout decreased from $66,873 in FY 2018 to $59,911 in FY 2019. 7. The Assistant Horticulturalist position shared with the Parks Division (0.58 FTE in Public Works) is tentatively unfrozen effective March 1, 2019 with cost of$9,610 ($29,460 in FY 2020). Supplies & Services 8. Repair Parts and Supplies decreased from $97,059 in FY 2018 to $81,057 in FY 2019 based on FY 2017 actual of$78,059 plus 4%. 9. Electric Utility Expense increased from $137,664 in FY 2018 to $148,327 in FY 2019. FY 2017 actual was $150,838. Based on the benefits of LED lights that have been installed inside and outside of the Public Works facility, Street Maintenance decreased from $60,643 in FY 2018 to $55,674 in FY 2019; Solid Waste Collection decreased from $10,616 in FY 2018 to $9,097 in FY 2019; and Garage increased from $13,083 in FY 2018 to $15,656 in FY 2019. In addition, -69- Floodwall increased from $25,414 in FY 2018 to $39,632 in FY 2019 based on FY 2017 actual of $35,228 plus 12.50%. 10. Street Lighting increased from $561,511 in FY 2018 to $697,123 in FY 2019 based on FY 2018 Year to Date plus 5%. Increase is due to an audit performed by Alliant Energy that discovered that the City was not being billed for all of the street lights owned by the City of Dubuque. The street lighting budget is split $34,560 general fund and $662,563 road use tax fund in FY 2019. 11. Property Maintenance increased from $152,871 in FY 2018 to $167,321 in FY 2019 based on FY 2017 actual of$147,639. Public Works Garage decreased $(8,220) based on FY 2017 actual. 12. Motor Vehicle Fuel increased from $231,034 in FY 2018 to $243,888 in FY 2019 based on FY 2017 actual of$239,105 plus 2%. 13. Motor Vehicle Maintenance increased from $449,714 in FY 2018 to $472,589 in FY 2019 based on a three year average. FY 2017 actual was $488,697. 14. Motor Vehicle Maintenance Outsourced decreased from $130,550 in FY 2018 to $114,537 in FY 2019 based on a three year average. FY 2017 actual was $112,900. 15. Machinery and Equipment Maintenance decreased from $659,687 in FY 2018 to $574,013 in FY 2019 based on a three year average. FY 2017 actual was $624,077. 16. Machinery and Equipment Maintenance Outsourced decreased from $183,750 in FY 2018 to $143,474 in FY 2019 based on a three year average. FY 2017 actual was $154,631. 17. Asphalt decreased from $734,010 in FY 2018 to $709,678 in FY 2019 based on purchasing 16,600 tons of hot and cold mix asphalt, completing five center line street miles, and a 2% increase over FY 2017 bid prices. FY 2017 actual was $871,043. 18. Concrete decreased from $140,595 in FY 2018 to $138,766 in FY 2019 based on buying 1,500 cubic yards of concrete and k-crete and based on a three year average of costs. FY 2017 actual was $135,641. 19. Stone increased from $105,975 in FY 2018 to $109,458 in FY 2019 based on FY 2017 actual of $108,957. This line item represents the purchase of 2,700 tons of stone for street maintenance ($47,331) and stone for resurfacing Landfill gravel roads and cell face access lanes ($60,017). 20. Road Salt for Snow and Ice Control decreased from $294,400 in FY 2018 to $226,000 in FY 2019. Road Salt decreased $68,400 based on the purchase of 5,000 tons of road salt at $45.20 per ton (In FY 2018 budget is based on the purchase of 5,000 tons at$58.88 per ton). 21. Road Salt for Bid Partners decreased from $117,760 in FY 2018 to $90,400 in FY 2019. Bid partner salt decreased $(27,360) based on the purchase of 2,000 tons at $45.20 per ton (In FY 2018 the budget is based on the purchase of 2,000 tons at $58.88 per ton) which is off-set from the revenue of salt purchased by bid partners. 22. Consulting Engineers increased from $122,448 in FY 2018 to $167,927 in FY 2019. FY 2017 actual was $137,619. 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. -70- 23. Landfill Fees increased from $445,769 in FY 2018 to $477,677 in FY 2019. FY 2017 actual was $400,894. Solid Waste Collection increased from $352,948 in FY 2018 to $388,812 in FY 2019 based on FY17 actual tons collected of 11,283 at the estimated FY 2019 fee per ton of$34.46. 24. Payment to Iowa DNR increased from $275,237 in FY 2018 to $294,000 in FY 2019. FY 2017 actual was $276,292. This line item represents the amount paid by the Landfill based on tonnage. FY 2019 is based on 140,000 tons at $2.10 per ton and FY 2018 was based on 131,065 tons at $2.10 per ton. Tonnage increased 8,935 in FY 2019. 25. The administrative overhead recharge increased from $1,278,811 in FY 2018 to $1,287,797 in FY 2019. The administrative overhead formula was modified in FY18 to remove Neighborhood Development, Economic Development and Workforce Development from all recharges to utility funds. In addition, the Landfill calculation was modified to remove GIS and Planning. 26. Hauling Services decreased from $105,472 in FY 2018 to $75,572 in FY 2019. FY 2017 actual was $72,362. This line item represents snow removal in the Port of Dubuque ($22,000), snow removal in downtown streets and alleys ($50,000), use of semi-tankers to haul untreated wastewater to the Water & Resource Recovery Center during emergency operations ($1,000), a private contractor to haul stone from area quarries for the Landfill ($1,812), and use of a private contractor to pull the E- waste trailer to the recycling center at the Landfill ($500). Machinery & Equipment 27. Equipment replacement items at maintenance level ($743,911) includes: Administration Smart Phone (2) $ 700 Riverfront Management Shop Equipment $ 500 Saws $ 600 Weed Whips $ 1,000 Street and Traffic Lighting Signal Controllers $ 12,000 Shop Equipment $ 1,000 Megohmeter $ 650 Cell Phone $ 120 Street Skins and Markings Shop Equipment $ 500 Sign Making Equipment $ 10,500 Street Maintenance 15,000 GVW 4WD Dump Truck $ 75,000 Curb Forms $ 2,000 Skid Loader $ 89,500 33,000 GVW Truck with Oil Distributor $ 99,000 Asphalt Roller $ 28,000 Barricades/Signs $ 25,400 Vibratory Tamper $ 2,800 -71- Snow& Ice Control Cell Phone (2) $ 120 5 Cubic Yard Spreader $ 18,000 Sanitary Sewer Maintenance 4WD Truck with Sewer Rodding Unit $ 94,500 Sanitary Inspection All-Terrain Vehicle $ 15,500 Gas monitor (1) $ 1,500 Jet flusher hose (3) $ 5,250 Cell Phone (2) $ 120 CCTV Printer (1) $ 250 Stormwater Maintenance Hand Concrete Saw $ 1,000 Refuse Collection Refuse Collection Carts (100) $ 33,050 Cell Phone (1) $ 350 Sm. Rear Loader Solid Waste Packer $ 120,773 Recycling Collection Program Recycling Bins/Lids (1,074) $ 11,500 Recycling Wheeled Cars (337) $ 23,010 Salt Operations Security Cameras $ 800 Public Works Garage Shop Equipment $ 5,000 Custodial Equipment $ 6,600 Smart Phone $ 570 Landfill Shop Equipment $ 2,000 Smart Phone $ 450 Printer $ 153 Propane Fueled Furnace $ 6,645 Replacement Tarp Assembly $ 12,000 Recommended Improvement Requests $ 35,500 Total Equipment $ 743,911 -72- Debt Service Debt service reflects repayment to ($807,230): Final Call Amount Debt Series Source Purpose Payment Date $ 50,400 G.O. Series 2014B Sales Tax 30% Equipment Replacement 2022 2021 $ 36,143 G.O. Series 2017A Road Use Tax Equipment Replacement 2030 2025 $ 36,676 G.O. Series 2014B Sales Tax 30% Curb Ramp Program 2034 2021 $ 4,746 G.O. Series 2017A Solid Waste Fees Solid Waste Trucks 2030 2025 $ 2,617 G.O. Series 2011A Solid Waste Fees Solid Waste Trucks 2031 2018 $ 13,989 Planned Sales Tax 20% Radio Replacement 2038 Dubuque County - $ 311,184 G.O. Series 2014 Landfill Fees Landfill Improvements 2034 2022 Dubuque County- $ 351,475 G.O. Series 2016 Landfill Fees Landfill Improvements 2036 2024 $ 807,230 Total Public Works Debt Service Revenue 28. Solid Waste monthly base fees increased from FY18 Budget of$3,453,639 to $3,501,625 in FY 2019 based on FY 2017 actual of$3,363,856 plus the FY 2018 rate increase of 2.30% and the FY 2019 projected rate increase of 1.70%. 29. Tipper Carts increased from $363,339 in FY 2018 to $452,510 in FY 2019 based on FY 2017 actual of$419,270 . 30. Refuse Single Use Stickers increased from $91,750 in FY 2018 to $101,457 in FY 2019 based on a three year average. FY 2017 actual was $101,457. 31. Yard Waste Single Sticker increased from$122,860 in FY 2018 to $164,761 in FY 2019 based on FY 2018 plus 34%. FY 2017 actual was $131,726. 32. Purina Drive Salt Operations represent the purchase and sale of salt for the City and the City's bid partners. The FY 2019 budget includes $90,440 in salt sales, $11,440 in salt handling fees, and $11,500 in salt storage/tarping fees. 33. The Solid Waste Agency payment decreased from $4,119,386 in FY 2018 to $4,062,416 in FY 2019. 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 2019. 34. 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 2019 overhead rate of$71.58 which is a 2% increase from the FY 2018 overhead rate of$70.18. Revenue is also received from recharges to users for parts and fuel purchased from the vehicle maintenance garage inventory. -73- The following is a summary of the operating expenses and revenues for the City Garage: %Change From FY FY 2017 FY 2018 FY 2019 2018 City Garage Actual Budget Requested Budget Expenses Employee Expense 1,020,026 1,074,199 1,050,892 (2.2)% Supplies and Services 119,107 129,258 127,777 (1.1)% Garage Stores 773,105 1,006,635 906,757 (9.9)% Machinery and Equipment 7,922 56,800 12,170 (78.6)% Total Expenses 1,920,160 2,266,892 2,097,596 (7.5)% Resources Specialized Services 1,150,527 1,150,527 1,164,696 1.2 % Fuel/Parts 984,800 984,800 789,531 (19.8)% County Fuel Sales 85,901 85,901 81,521 (5.1)% Reimbursements 45,664 45,664 51,848 13.5 % Total Resources 2,266,892 2,266,892 2,087,596 (7.9)% Annual Operating Surplus (Deficit) 346,732 — (10,000) (10,000) Garage Overhead Rate $ 70.18 $ 71.58 $ 73.26 -74- City of Dubuque PUBLIC WORKS DEPARTMENT Organizational Chart 1 Public Works Director 1 Accountant Clerk II 1 Secretary .50 Part Time Clerical 1 Assistant Public Works Director Street Maintenance Floodwall/ Street Lighting/ Refuse collection/ Municipal Garage Street Signs& Sewer Maintenance Signal Maintenance Recycling 1.0 Fleet.Maint.Supv. Markings 2.00 Foremen 2.00 Traffic Signal Techs II 1.0 Resource Mgmt 2.0 Lead Mechanic 1.00 Equip.Operator II 2:00 Total Full-time Coordinator&Supv. 7.0 Mechanics 1.00-PW Field Supervisor 5.00 Equip.Operators I 1.00 Lead San.Driver 2.0 Stock Clerks 4.00 Foremen 8.00 Total Full-time 19.00 Sanitation Drivers 12 Full-time Employees 6.00 Equipment Operators II 21.00 Full-time Employees 0.15 Part-time Custodian 6.00 Equipment Operators I 0.67 Seasonal San.Driver 6.00 Truck Drivers 0.08 Part-time Custodian 5.00 Utility Workers 0.42 Gardener 28.42 Total Full-time Empl. 1.00 Utility Worker Apprentice 0.67 Seasonal Employee Landfill/Composting/HHMRCC 0.38 part-time Custodian 1.00 Solid Waste Agency Administrator 1.00 Solid Waste Facility Supervisor Riverfront Management 1.00 Foreman 1.00 Maintenance Worker 5.00 Landfill Equipment Operators 1.00 Full-time Employee 2.00 Scale Operators 0.67 Seasonal Laborer 1.00 Mechanic 11.00 Full-time Employees 0.75 Seasonal Employee -75- This page intentionally left blank. -76- 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 1 I I I 1 1 I Street Sewer Riverfront Vehicle Resource Maintenance Maintenance Maintenance& Maintenance Management DMASWA Operations 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, riverfront, and sewer PEOPLE infrastructure, the maintenance of the City's Public Works staff are provided vehicles and heavy equipment, the management of professional development opportunities the municipal solid waste and recyclables to improve their knowledge and generated by our citizens, and the management expertise in order to provide for the and operation of the DMASWA's facilities. development and promotion of public education and customer outreach programs to schools, civic a' ° ' pr organizations, city councils, county .n,' , • supervisors, and citizens throughout c-.r' 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. _77_ PUBLIC WORKS Resources °Perati�9 I $$37 61 61,271 Salt • $$ 7 754 ■ $113,065 Road Use Tax I $5,221,667 $5,811,726 $6,147,241 Server $571N1,129 57$,681 129 $ $830,141 St°" ater $268,577 $241,698 Refuse $3,880,626 3 811,026 13,906,921 land ftt $3,205,882 $3,449, 77 Prop ertYTax SuppOrt $184 $3,365,2 7 $989, ,284,4893'178 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 FY 2017 ! FY 2018 FY 2019 The Public Works Department is supported by 91.96 full-time equivalent employees, which accounts for 52% of the department expense as seen below. Overall, the department's expenses are expected to increase by 1% in FY 2019 compared to FY 2018. Expenditures by Category by Fiscal Year $7,626,729 Employee Expense $8,219,087 $8,075,566 $6,369,091 Supplies and Services $6,840,644 $6,763,449 $274,749 Machinery and Equipment $394,450 $743,911 $761,217 Garage/Stores $981,516 $882,360 $1,458,134 Administrative OH $1,278,811 $1,287,797 $1,069,612 Debt Service $795,738 $807,230 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 FY 2017 U FY 2018 FY 2019 -78- PUBLIC WORKS Public Works Administration Overview The Public Works Director directs and supervises the activities of over ninety-two (92.09) full time, part-time and seasonal employees including,87 full time, two (2) part-time, nine (9) seasonal workers and one (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, 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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $12,871 $(9,953) $8,569 Resources $205 $136 $205 Administration Position Summary FY 2019 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 2015 - 2017 • Received and responded to 4,658 citizen requests for service in FY 2015 • Received and responded to 6101 citizens requests for service in FY 2016 • Received and responded to 8,369 citizen requests for service in FY 2017 Future Initiatives • Recruit and retain a highly qualified and well-trained diverse work force • Continue to improve the high level of customer service provided to our citizens -79- PUBLIC WORKS Performance Measures Public Works Administration -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 "' 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. DID YOU ALSO KNOW? Public Works Department staff provide 24/7 citizen The additional services added to the service through twenty-four separate departmental Public Works Department's service activities in a timely and responsible responsibilities over the last 40 years manner. 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, This objective is particularly important since the Purina Drive Barge Terminal department is not staffed for 24/7 operations Maintenance, DMASWA Composting supervision. As a result, the workers on the streets Operations, DMASWA Household and in the sewers are trained to be problem-solvers Hazardous Materials Management, and authorized to make decisions when the Public DMASWA Education Outreach, Works Director and Street and Sewer Maintenance DMASWA Discarded Electronics Supervisor are not available for on-site command. 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 (1) hour. DID YOU ALSO KNOW? The Public Works Department Even though the Public Works Department is not received and responded to 8,369 considered a public safety department, a citizen who has WEBQA requests for service in raw sewage filling the basement of his or her home, or a FY2017 which is 37% increase citizen trying to get to work or the hospital during a over FY 2016 requests (2,268 blizzard or ice storm, would likely assert that public health, requests) 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. -80- PUBLIC WORKS Street Maintenance Overview Street Maintenance (Funded by Road Use Tax Dollars) Provides for maintaining and repairing 280.43 centerline miles of city streets, curb and gutter, alleys, including 80 green alleys, 10 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 280.43 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 light system is actually two separate subsystems, with separate ownership and responsibility for maintenance and operation: Alliant-owned street lights total 2,620 with 1 ,209 of those lights being high pressure sodium and 1 ,411 being LED lights. The City-owned street light system is made up of 1,153 high pressure sodium and 884 LED lights, 7 incandescent and 146 MH for a total of 2,190 street lights. All City owned street lights and traffic signals are maintained by the Public Works Department's two traffic signal technicians. Our traffic technicians also assist in the 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. -81- PUBLIC WORKS Street Maintenance Funding Summary FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $5,947,189 $6,162,336 $6,051,246 Resources $3,222,118 $3,257,028 $3,405,884 Street Maintenance Position Summary FY 2019 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 I 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-2017 • Completed asphalt overlay projects on 26 streets equaling 4.35 centerline miles in calendar 2014, on 34 streets equaling 6.29 centerline miles in calendar 2015, 50 streets equaling 7.11 miles in 2016 and 43 streets equaling 7.64 miles in 2017. • Completed full depth concrete repairs on 11 streets in calendar 2014, 17 streets in calendar 2015, on 10 streets in 2016 and 10 streets in calendar 2017. -82- PUBLIC WORKS Assisted in the installation of 172 ADA curb ramps (116 contractors and 56 Public Works) _ ; , ; et_i - c . 6 Purchased one heavy duty/snow and ice control dedicated CNG mo • o . fueled dump truck in 2017 (the first municipally owned in the state of Iowa). I _ Purchased one CNG bi-fuel 1/2 ton pick-up truck in 2017. 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 CNG 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. Al;IGoal: Connected Community Outcome #1: Provide an effective and efficient road transportation network. Asphalt overlay 5 centerline miles of streets in fiscal year , 2019. In calendar year 2017 a 7.64 mile overlay project was =V DID YOU KNOW? completed. Studies show that for every The Public Works Department's asphalt paving program provides for $1 spent on street pavement safe, smooth, and well-maintained streets by correcting pavement preventive maintenance deficiencies, extending the useful life of City streets, and thereby projects, it would cost $4 to delaying the need for costly street reconstruction projects. In FY19, $5 more if those preventive five (5) centerline miles of streets will be paved, along with maintenance projects were constructing ADA-compliant curb ramps to meet the updated delayed and more extensive guidelines for curb ramp construction on streets receiving an asphalt pavement rehabilitation is overlay needed at a later time. -83- PUBLIC WORKS SNOW AND ICE CONTROL Plow open for safe travel arterial streets within 18 hours and residential streets within 48 hours of the cessation a winter storm. VDID YOU ALSO KNOW? The City has a Snow Plow Progress Mapping system. Visit This program provides for the safe and efficient movement of www.cityofdubuque/snow for motor vehicles and public safety vehicles throughout the city during and after winter storm events. additional information. Maintain an effective and efficient pedestrian walkway network by clearing City-maintained walks in a timely and efficient manner after winter storms. • sidt This program provides for the safe movement of pedestrians on City walks and steps after winter storms. Winter Season 2012/2013 2013/2014 2014/2015 2015/2016 2016/2017 Number of Storms 26 42 19 15 12 Total Seasonal Snowfall 54.5" 63.3" 33.7" 34.8" 27.1 Salt Used for De-icing 5,246 tons 13,411 tons 5,346 tons 3,242 tons 3,474 tons Citizen Requests During the winter of 2016-2017, the department received a total of 303 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. -84- 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 2016-2017 was 23,007 gallons. De-icing: The department's FY19 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 7,000 tons of roadway deicer salt at an estimated cost of $45.20/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 DID YOU ALSO KNOW? control equipment and related electrical systems. The Public Works Department, under the guidance of the Engineering Department, is Public safety is also assured by maintaining all City-owned street replacing City-owned high lighting and street camera equipment, including light heads, poles, pressure sodium street lights with and wiring systems. 115 traffic signal installations and 2,173 City- LED street lights. The new LED owned high pressure sodium and LED street lights are maintained street lights are more energy by the department's two technicians. efficient and have a longer life span. Sign Replacement Program In calendar 2017, 49 street names, 47 JULE, and 593 other types of traffic control signs and posts were installed or replaced at various locations throughout the city. -85- 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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $846,415 $1,049,706 $1,071,839 Resources $846,415 $1,049,706 $1,071,839 Sewer Maintenance Position Summary FY 2019 Foreman -Sanitary 1.31 Foreman-Storm 0.73 Field Supervisor- Storm 0.00 Equipment Operator I -Sanitary 3.38 Equipment Operator I -Storm 1.12 Equipment Operator II -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 2015 - 2017 • Cleaned or Inspected 138.81 miles of the sanitary sewer system pipe in calendar 2015 (through 1111115) • 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) 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. -86- 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. C° z_ -14T Goal: Sustainable Environment A 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 2013 2014 2015 2016 2017 Total Service Requests: 116 126 96 96 97 Private Sewer Problems 98 110 85 84 86 City Sewer Problems 18 16 11 12 11 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. Root Control 18000 15909 16000 14000IJiiii338112680 12139 12000 10000 8000 6000 4000 2000 0 Root Rot PR 2014 e 2015 ■2016 ■2017 -87- PUBLIC WORKS Outcome #2: Ensure contractors' and developers' compliance with City specifications by completing DID YOU KNOW? post-construction inspection of new or repaired The Public Works Department's sanitary and storm sewer infrastructure digital sewer inspection reports, In order to ensure contractor compliance with City along with sewer construction specifications, all newly-constructed or repaired sanitary and documents, are both linked to the storm sewer infrastructure will be inspected with closed-circuit City's Geographic Information television equipment (CCTV). System (GIS). Year 2014 2015 2016 2017 Total sewer pipe inspection footage using CCTV equipment 131,118 85,387 65,936 95,383 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 6.2 mile long floodwall 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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $447,038 $423,882 $448,485 Resources $9,345 $11,498 $9,345 -88- PUBLIC WORKS Riverfront Maintenance and Operations Position Summary FY 2019 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 65 private and public events held in the Port of Dubuque in 2017 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. -89- 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. am. 416 a *:= ..., .ti "'. .$"-« r ukN P �i. .r 9 uu lii 1 J _L.'x,.-,�1,. 4 ~ 3✓ ,, v6 Grp yy - . a 4, • 17 1 14 1#4t Outcome #2: Provide flood protection to the community by maintaining and operating the City's 6.2 mile long floodwall system. Make continual improvements to the City's floodwall 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 floodwall'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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $ 1,920,160 $ 2,266,892 $ 2,097,596 Resources $ 2,058,854 $ 2,266,892 $ 2,087,596 -90- PUBLIC WORKS Vehicle Maintenance Position Summary FY 2019 Equipment Maintenance Supervisor 1.00 Lead Mechanic 2.00 Mechanic 7.00 Stock Clerk 2.00 Custodian I 0.15 Total FT Equivalent Employees 12.15 Highlights of the Past Year • Successful recruitment of mechanics to fill all vacant positions. • Successful recruitment of Fleet Maintenance Supervisor. • Provided technical training for two mechanics related to heavy duty CNG fueled vehicles. Future Initiatives • Recruitment and retention of experienced heavy equipment and diesel engine mechanics. Performance Measures Vehicle Maintenance -Activity Statement Maintain and repair the City's fleet to ensure safe and efficient operation of all City-owned vehicles. Goal: Financially Responsible, High Performance Organization 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, except for the vehicles belonging to the Airport Department. Public safety vehicles, Police/Fire year-round and Snow/Ice Control in the winter, must be ready to respond to any emergency at any time to protect the public from bodily harm and property damage. The department's nine mechanics and two service workers will receive training annually to keep them abreast of the latest automotive and equipment technologies. While greater reliance on outsourcing vehicle repairs has allowed the department to reduce its complement of mechanics over the last fifteen years, those private sector service providers are not available to service an ambulance, fire truck, police car, or snow plow truck at 3AM on a -91- PUBLIC WORKS Sunday, Christmas Day, etc. 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 City/department 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 City already is using CNG-fueled and electric/gas-engine hybrid vehicles. Yet to be evaluated are diesel/hydraulic-launch hybrid trucks and plug-in electric automobiles. While the benefits of improved fuel efficiency and reduced carbon footprint are obvious, initial higher purchase costs for alternative technology vehicles, new clean diesel engine technology, low oil/conventional vehicle fuel prices, and constantly evolving alternative technologies argue for continued comparison before any attempts at mass fleet conversion. Resource Management Overview The 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 efficient refuse collection and disposal service to 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 from the City's 20,000 customers. Recycling bins and carts are provided to the City's customers for the recycling of a full spectrum of paper, plastic and metal materials. Another activity service is the collection of furniture, appliances, and other large and/or 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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $3,940,479 $3,817,868 $3,914,284 Resources $4,136,704 $4,130,553 $4,340,310 -92- PUBLIC WORKS Resource Management Position Summary FY 2019 Resource Management Coordinator 1.00 Lead Sanitation Driver 1.00 Sanitation Driver 17.00 Sanitation Laborer 1.00 Custodial I 0.08 Seasonal Sanitation Driver 0.67 Total FT Equivalent Employees 20.75 Highlights of the Past Year • The purchase and distribution of 881 large (95 gallon) wheeled carts to its "star" (3+ bins weekly) recycling customers. • The installation of five (5) multilingual (English and Spanish) ReThink Waste graphic design decals on five (5) recycling collection vehicles • Purchased the first Cab-over Resource Management Collection vehicle for the fleet. • Created new hard and e-copy Resource Management brochure in English, Spanish and Marshallese. • Over 586 customers downloaded the Rethink Waste mobile device Future Initiatives • The department will incorporate an equity lens into its operation to continually evaluate its curbside collection services for the purposes of improving operational efficiencies and diverting more materials from landfill disposal. • The department is continuing to explore the possible future use of CNG-fueled collection vehicles. • Completion of Solid Waste Study. • The department is evaluating the greater use of City-owned carts for the collection of refuse, recyclables, and yard/food debris. • The department will propose the collection of electronics to the City's large item collection to improve city service delivery. 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, yard debris, food scraps and other food-related compost. -93- PUBLIC WORKS @CGoal: Sustainable Environment --101. 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 waste from landfills, we help preserve natural resources and protect the environment Total Municipal Materials Collected 69% 69% 70% 71% 71% /(r6 i t% 40% 3014 24% 23% 22% 21% 21% 20% 896 to% 796 8% 8% f�"> 0% FY13 FY14 FY15 FY16 1Y17 Refuse —Yard Waste —Recycling Outcome#2: Increase customer convenience, and advance worker safety through expanded use of City-owned, wheeled collection carts. Cart Subscribers Per Yr 11,k) 967 1000 800 635 600 505 423 4C0 362 283 294 276 333 200 257 0 13 14 IS 16 17 X64 Gal —96-Gal 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. -94- PUBLIC WORKS 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 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $3,537,742 $3,979,063 $3,856,650 Resources $3,537,742 $3,979,063 $3,856,650 DMASWA Position Summary FY 2019 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 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 FY15, the Agency partnered with Dubuque County to borrow $4.5 million for construction of Cell #9's Phase II. The project was subsequently completed in FY16. -95- PUBLIC WORKS • 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. 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. 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-off facilities, landfill methane system, and, appliance! metals/tire/electronics recycling programs. Goal: Sustainable Environment Outcome#1: Maintain the financial integrity of the DID YOU KNOW? The DMASWA's landfill and other DMASWA in order to continue to provide easily services are not tax-supported.The fees paid by the Agency's Iowa, accessible and affordable municipal solid waste Illinois, and Wisconsin customers to management services to the region. 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 landfilling, if not compensated through the expansion of the Agency's customer base, could result in a significant loss of revenue and even more Agency debt. Resulting in higher service fees, reduced services and decrease support for non-revenue positive diversion programs. -96- PUBLIC WORKS Expand the DMASWA's customer base YOU ALSO KNOW? In order to ensure that the Agency's facilities and services are The DMASWA Landfill serves not financially sustainable in future years, its current customer base only all of Dubuque county, but must be maintained and new customers added. If the Agency's also all of Delaware county and substantial near-term capital project costs are not supported by a many homes and businesses in broader customer base, more monies will have to be borrowed and Grant and Jo Daviess counties. 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 greenhouse 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 FY16 Actual FY17 Actual FY18 Adopted FY19 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 400 43110 INVESTMENT EARNINGS 0 490 0 0 670 43110 INVESTMENT EARNINGS 6,704 7,476 6,704 7,413 680 43110 INVESTMENT EARNINGS (32) 0 0 0 100 43230 LEASE, PROPERTY 2,335 0 2,335 0 940 43230 LEASE, PROPERTY 3,162 0 0 0 43-USE OF MONEY AND PROPERTY 12,169 7,966 9,039 7,413 940 45701 STATE GRANTS 0 1,000 0 10,000 940 45731 IA DNR RCC OPERATION 10,094 15,553 0 0 45-STATE GRANTS 10,094 16,553 0 10,000 810 46105 FUEL SALES, COUNTY 85,901 81,521 85,901 81,521 46-LOCAL GRANT AND REIMBURSE 85,901 81,521 85,901 81,521 670 51215 PENALTIES 50,670 52,056 50,670 52,056 610 51250 SEWER TV SERVICE CHARGES 11,598 5,106 9,585 8,076 670 51605 SOLID WASTE MONTHLY FEE 3,222,322 3,410,894 3,502,792 3,548,663 670 51606 SOLID WASTE REFUSE CREDIT (49,153) (47,038) (49,153) (47,038) 670 51610 TIPPER CARTS 258,475 322,773 258,475 356,013 670 51615 EXTRA/OVERSIZE CAN SUBSCR 104,864 96,497 104,864 96,497 670 51620 REFUSE SINGLE USE REFUSE 91,750 101,457 91,750 101,457 670 51630 YARD WASTE STICKER ANNUAL 31,241 30,285 31,241 30,285 670 51635 YARD WASTE SINGLE USE STI 83,453 98,692 88,945 131,726 670 51640 YARD WASTE BRUSH TIE SALE 2,674 2,750 2,674 2,750 670 51641 SUBSCRIPTION RECYCLING 3,385 3,548 3,385 3,548 670 51642 FOOD SCRAP 9,250 8,403 3,600 8,403 940 51643 E-SCRAP RECYCLING FEES 31,260 0 0 0 940 51644 GAS SALES 5,075 0 0 0 670 51645 LEAF RAKE OUT FEES 4,360 5,136 4,656 5,136 670 51650 LARGE ITEM PICKUP FEES 21,369 22,770 21,369 24,770 940 51655 CUSTOMER FEES, HHMRCC 38,481 131 0 0 940 51660 SOLID WASTE AGENCY PMT 0 0 4,119,386 3,984,556 670 51665 RECYCABLE SALES 16,271 10,069 0 10,069 940 51670 GOVERNMENT FEES, HHMRCC 0 162 0 0 940 51685 COMPOST LANDFILL FEES 37,919 0 0 0 940 51687 MRF REVENUE 1,479 323 0 0 100 51910 STATE HIGHWAY MAINT 36,082 3,749 26,644 24,770 250 51910 STATE HIGHWAY MAINT 0 0 3,200 0 100 51956 PAVILION FEES 9,163 9,345 9,163 9,345 940 51965 EVENTS REVENUE 19,793 0 0 0 680 51975 SALE OF SALT 66,465 72,530 117,760 90,440 680 51976 SALT HANDLING FEE 6,571 7,164 11,440 11,440 680 51977 SALT STORAGE FEE 7,281 5,679 9,000 9,000 680 51978 TARPING FEE 1,403 1,514 2,500 2,500 51 -CHARGES FOR SERVICES 4,123,501 4,223,995 8,423,946 8,464,462 250 53201 REFUNDS 0 15,000 0 0 670 53201 REFUNDS 0 1,680 0 0 -99- Recommended Operating Revenue Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY19 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 670 53204 IOWA FUEL TAX REFUND 0 604 0 604 810 53204 IOWA FUEL TAX REFUND 42,200 48,873 42,200 48,873 100 53403 IA DISTRICT COURT FINES 675 0 675 0 810 53530 SPECIALIZED SERVICES 1,055,788 1,135,955 1,150,527 1,164,696 820 53530 SPECIALIZED SERVICES 0 0 2,512 0 810 53570 FUEL/PARTS INTERNAL SVC 788,828 789,531 984,800 789,531 100 53605 MISCELLANEOUS REVENUE 740 0 0 0 610 53605 MISCELLANEOUS REVENUE 0 580 0 0 670 53610 INSURANCE CLAIMS 576 757 0 0 940 53610 INSURANCE CLAIMS 0 2,965 0 0 100 53615 DAMAGE CLAIMS 20,094 16,433 20,909 19,034 100 53620 REIMBURSEMENTS-GENERAL 3,135 5,094 3,135 3,695 250 53620 REIMBURSEMENTS-GENERAL 4,405 4,574 2,121 3,765 610 53620 REIMBURSEMENTS-GENERAL 0 2,349 0 0 620 53620 REIMBURSEMENTS-GENERAL 30 0 0 0 670 53620 REIMBURSEMENTS-GENERAL 47 403 47 403 810 53620 REIMBURSEMENTS-GENERAL 945 77 945 77 940 53620 REIMBURSEMENTS-GENERAL 1,731 4,940 0 0 670 53630 SALES TAX COLLECTION 7,570 7,555 8,534 7,555 53-MISCELLANEOUS 1,926,764 2,037,370 2,216,405 2,038,233 250 54104 SALE OF ASSETS OTHER 0 500 0 0 100 54109 SALVAGE SALES 1,378 2,274 2,238 1,659 610 54109 SALVAGE SALES 1,329 1,885 1,329 1,885 670 54109 SALVAGE SALES 32 0 0 0 810 54109 SALVAGE SALES 2,519 2,898 2,519 2,898 940 54109 SALVAGE SALES 4,239 0 0 0 100 54110 SALE OF SIGNS AND MARKING 3,236 566 4,038 2,768 400 54210 GO BOND PROCEEDS 0 396,824 0 0 670 54210 GO BOND PROCEEDS 0 51,165 0 0 400 54220 BOND DISCOUNT 0 12,782 0 0 670 54220 BOND DISCOUNT 0 1,648 0 0 54-OTHER FINANCING SOURCES 12,733 470,542 10,124 9,210 400 59250 FR ROAD USE TAX 38,724 37,177 32,237 36,143 400 59300 FR STREET CONSTRUCTION 87,847 85,973 89,100 87,076 400 59350 FR SALES TAX CONSTRUCTION 0 0 0 13,989 59-TRANSFER IN AND INTERNAL 126,571 123,150 121,337 137,208 54-PUBLIC WORKS TOTAL 6,297,733 6,961,097 10,866,752 10,748,047 -100- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-TIME EMPLOYEES 605,511 526,766 575,619 591,514 250 61010 FULL-TIME EMPLOYEES 1,242,430 1,240,641 1,428,972 1,471,212 610 61010 FULL-TIME EMPLOYEES 297,666 250,963 329,192 333,431 620 61010 FULL-TIME EMPLOYEES 119,445 137,072 104,547 110,152 670 61010 FULL-TIME EMPLOYEES 962,102 1,035,901 1,093,347 1,099,744 810 61010 FULL-TIME EMPLOYEES 593,922 655,300 676,089 676,995 820 61010 FULL-TIME EMPLOYEES - 2,221 - - 940 61010 FULL-TIME EMPLOYEES 588,011 632,593 652,054 665,531 100 61020 PART-TIME EMPLOYEES 12,518 13,482 11,887 17,658 250 61020 PART-TIME EMPLOYEES 12,434 13,066 17,441 17,855 670 61020 PART-TIME EMPLOYEES 8,807 9,255 3,617 3,759 810 61020 PART-TIME EMPLOYEES - - 6,782 7,048 100 61030 SEASONAL EMPLOYEES 36,276 20,207 48,687 35,649 250 61030 SEASONAL EMPLOYEES 12,097 8,410 25,743 8,474 610 61030 SEASONAL EMPLOYEES 460 52 620 61030 SEASONAL EMPLOYEES 688 160 670 61030 SEASONAL EMPLOYEES 25,254 16,317 20,653 20,963 940 61030 SEASONAL EMPLOYEES 112 109 23,119 23,466 100 61050 OVERTIME PAY 29,584 38,434 35,241 35,241 250 61050 OVERTIME PAY 109,723 126,784 163,000 136,000 610 61050 OVERTIME PAY 20,287 3,952 10,250 10,250 620 61050 OVERTIME PAY 727 1,119 2,050 2,050 670 61050 OVERTIME PAY 20,741 18,336 21,400 21,400 810 61050 OVERTIME PAY 50,540 10,886 28,250 28,250 940 61050 OVERTIME PAY 74,799 44,981 71,200 71,200 100 61071 HOLIDAY PAY-OVERTIME 2,308 5,700 4,100 4,100 250 61071 HOLIDAY PAY-OVERTIME 12,130 23,811 13,050 13,050 610 61071 HOLIDAY PAY-OVERTIME 398 612 750 750 620 61071 HOLIDAY PAY-OVERTIME 195 103 - - 670 61071 HOLIDAY PAY-OVERTIME 21,523 30,611 19,700 19,700 810 61071 HOLIDAY PAY-OVERTIME 2,344 1,869 3,000 3,000 940 61071 HOLIDAY PAY-OVERTIME 14,058 19,596 16,100 16,500 100 61091 SICK LEAVE PAYOFF 1,496 15,326 15,793 15,793 250 61091 SICK LEAVE PAYOFF 12,503 17,768 19,916 17,840 610 61091 SICK LEAVE PAYOFF 226 620 61091 SICK LEAVE PAYOFF 1,491 670 61091 SICK LEAVE PAYOFF - 539 - 4,345 810 61091 SICK LEAVE PAYOFF 21,088 21,088 18,800 16,109 940 61091 SICK LEAVE PAYOFF 9,140 11,365 12,364 4,333 100 61092 VACATION PAYOFF 3,643 9,352 250 61092 VACATION PAYOFF 5,756 9,693 610 61092 VACATION PAYOFF 2,944 670 61092 VACATION PAYOFF 888 1,170 940 61092 VACATION PAYOFF - 2,840 - - -101- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61310 (PERS 60,361 53,052 60,418 64,584 250 61310 (PERS 123,392 125,574 148,363 155,430 610 61310 (PERS 28,432 22,819 30,379 32,515 620 61310 (PERS 10,773 12,350 9,518 10,591 670 61310 (PERS 92,731 99,161 103,476 110,034 810 61310 (PERS 57,760 59,657 63,769 67,523 820 61310 (PERS - 198 - - 940 61310 (PERS 60,444 62,257 67,877 73,320 100 61320 SOCIAL SECURITY 51,423 46,348 52,967 53,546 250 61320 SOCIAL SECURITY 104,044 106,277 128,292 127,328 610 61320 SOCIAL SECURITY 23,812 18,729 26,024 26,348 620 61320 SOCIAL SECURITY 8,999 10,220 8,156 8,698 670 61320 SOCIAL SECURITY 76,397 81,681 88,639 89,497 810 61320 SOCIAL SECURITY 49,613 50,971 56,070 55,955 820 61320 SOCIAL SECURITY - 166 - - 940 61320 SOCIAL SECURITY 50,269 51,983 59,091 59,751 100 61410 HEALTH INSURANCE 157,667 141,102 138,965 126,935 250 61410 HEALTH INSURANCE 412,306 390,467 421,190 390,803 610 61410 HEALTH INSURANCE 95,532 89,857 94,445 86,001 620 61410 HEALTH INSURANCE 29,370 29,796 29,097 27,908 670 61410 HEALTH INSURANCE 322,742 339,827 325,948 286,200 810 61410 HEALTH INSURANCE 193,645 190,751 190,799 171,720 820 61410 HEALTH INSURANCE 1,452 409 940 61410 HEALTH INSURANCE 177,509 174,429 174,899 157,416 100 61415 WORKMENS'COMPENSATION 25,443 24,922 22,929 17,718 250 61415 WORKMENS'COMPENSATION 156,432 146,494 151,947 127,143 610 61415 WORKMENS'COMPENSATION 13,028 13,271 13,228 10,033 620 61415 WORKMENS'COMPENSATION 3,887 4,126 4,041 3,162 670 61415 WORKMENS'COMPENSATION 142,780 142,596 129,359 112,940 810 61415 WORKMENS'COMPENSATION 27,486 25,405 25,138 19,741 820 61415 WORKMENS'COMPENSATION 157 940 61415 WORKMENS'COMPENSATION 91,358 90,050 82,659 72,122 100 61416 LIFE INSURANCE 446 429 1,148 455 250 61416 LIFE INSURANCE 994 934 2,852 1,008 610 61416 LIFE INSURANCE 215 178 659 190 620 61416 LIFE INSURANCE 93 110 209 115 670 61416 LIFE INSURANCE 781 788 2,181 810 810 61416 LIFE INSURANCE 473 486 1,351 500 820 61416 LIFE INSURANCE - 2 - - 940 61416 LIFE INSURANCE 456 458 1,304 497 100 61417 UNEMPLOYMENT INSURANCE 3,791 4,242 250 61417 UNEMPLOYMENT INSURANCE 2,302 2,516 670 61417 UNEMPLOYMENT INSURANCE 3,957 4,829 3,624 - 100 61640 SAFETY EQUIPMENT 699 951 703 959 -102- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 250 61640 SAFETY EQUIPMENT 2,465 2,401 2,447 2,449 610 61640 SAFETY EQUIPMENT 1,186 728 2,000 2,000 620 61640 SAFETY EQUIPMENT 232 197 389 236 670 61640 SAFETY EQUIPMENT 2,742 2,367 2,605 1,255 810 61640 SAFETY EQUIPMENT 998 1,192 1,201 1,311 940 61640 SAFETY EQUIPMENT 5,891 4,035 3,528 3,000 810 61645 TOOL ALLOWANCE 1,600 1,800 1,800 1,800 940 61645 TOOL ALLOWANCE - 200 200 200 100 61650 MEAL ALLOWANCE 456 570 895 682 250 61650 MEAL ALLOWANCE 3,306 3,264 4,871 3,682 610 61650 MEAL ALLOWANCE 396 42 396 369 620 61650 MEAL ALLOWANCE 55 55 670 61650 MEAL ALLOWANCE - 12 25 25 810 61650 MEAL ALLOWANCE 438 378 800 590 940 61650 MEAL ALLOWANCE 90 150 50 100 100 61660 EMPLOYEE PHYSICALS 242 367 120 242 250 61660 EMPLOYEE PHYSICALS 1,228 126 1,228 1,228 610 61660 EMPLOYEE PHYSICALS 482 21 750 750 620 61660 EMPLOYEE PHYSICALS 278 - 300 280 670 61660 EMPLOYEE PHYSICALS 375 398 300 150 810 61660 EMPLOYEE PHYSICALS 262 242 350 350 940 61660 EMPLOYEE PHYSICALS 739 449 350 350 100 61665 OTHER MEDICAL COSTS 113 100 61680 EMPLOYEE MOVING EXPENSE - 8,467 - - 61 -WAGES AND BENEFITS 7,621,631 7,626,724 8,219,087 8,075,566 100 62010 OFFICE SUPPLIES 2,267 3,426 2,412 2,510 250 62010 OFFICE SUPPLIES - - 50 - 610 62010 OFFICE SUPPLIES 12 154 150 154 670 62010 OFFICE SUPPLIES 121 239 124 239 810 62010 OFFICE SUPPLIES 294 470 300 470 940 62010 OFFICE SUPPLIES 2,055 1,979 2,196 2,079 100 62011 UNIFORM PURCHASES 2,154 1,561 2,197 1,562 250 62011 UNIFORM PURCHASES 10,028 6,869 10,228 8,448 610 62011 UNIFORM PURCHASES 1,583 1,353 1,614 1,353 620 62011 UNIFORM PURCHASES 860 432 877 432 670 62011 UNIFORM PURCHASES 4,975 4,342 5,075 4,341 810 62011 UNIFORM PURCHASES 4,139 2,205 4,222 3,680 940 62011 UNIFORM PURCHASES 3,821 1,535 3,897 1,535 810 62013 UNIFORM MAINTENANCE 2,888 3,452 2,946 3,452 940 62013 UNIFORM MAINTENANCE 167 827 170 827 100 62030 POSTAGE AND SHIPPING 1,062 1,331 3,985 1,178 250 62030 POSTAGE AND SHIPPING 122 198 122 198 610 62030 POSTAGE AND SHIPPING 1,562 1,429 1,562 1,429 670 62030 POSTAGE AND SHIPPING 207 730 201 730 -103- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 940 62030 POSTAGEAND SHIPPING 876 867 976 967 100 62033 HAND TOOLS/EQUIPMENT 248 89 253 202 250 62033 HAND TOOLS/EQUIPMENT 9,994 5,584 10,194 6,037 610 62033 HAND TOOLS/EQUIPMENT 3,671 546 3,745 546 620 62033 HAND TOOLS/EQUIPMENT 123 421 125 421 670 62033 HAND TOOLS/EQUIPMENT - 38 - 38 810 62033 HAND TOOLS/EQUIPMENT 902 35 920 405 940 62033 HAND TOOLS/EQUIPMENT 4,884 6,021 2,000 6,021 100 62034 REPAIR PARTS/SUPPLIES 8,719 6,048 7,893 6,731 250 62034 REPAIR PARTS/SUPPLIES 21,051 23,604 21,472 22,338 610 62034 REPAIR PARTS/SUPPLIES 21,807 12,516 22,243 12,516 620 62034 REPAIR PARTS/SUPPLIES 13,936 4,776 10,500 9,432 670 62034 REPAIR PARTS/SUPPLIES 555 1,491 565 1,491 680 62034 REPAIR PARTS/SUPPLIES - 200 - 200 810 62034 REPAIR PARTS/SUPPLIES 1,502 1,272 1,532 1,272 940 62034 REPAIR PARTS/SUPPLIES 29,396 28,151 32,854 27,077 250 62036 CONSTRUCTION SUPPLIES 55,664 31,071 56,778 41,094 100 62060 O/E MAINT CONTRACTS - 5,040 - - 100 62061 DP EQUIP. MAINT CONTRACTS 5,243 5,903 6,496 6,887 810 62061 DP EQUIP. MAINT CONTRACTS 3,701 3,041 3,346 3,548 940 62061 DP EQUIP. MAINT CONTRACTS 1,735 250 62062 JANITORIAL SUPPLIES 7,374 8,093 7,521 8,093 670 62062 JANITORIAL SUPPLIES 1,384 1,522 1,412 1,522 810 62062 JANITORIAL SUPPLIES 2,630 2,834 2,683 2,834 940 62062 JANITORIAL SUPPLIES 1,849 1,283 1,886 1,283 100 62063 SAFETY RELATED SUPPLIES - 3,150 - - 250 62063 SAFETY RELATED SUPPLIES - 4,410 - - 100 62064 ELECTRICAL SUPPLIES 1,590 2,473 1,622 1,842 250 62064 ELECTRICAL SUPPLIES 3,208 868 3,272 868 670 62064 ELECTRICAL SUPPLIES 605 160 617 160 810 62064 ELECTRICAL SUPPLIES 1,150 304 1,173 304 940 62064 ELECTRICAL SUPPLIES 178 2,310 182 2,310 100 62090 PRINTING&BINDING 350 290 357 790 250 62090 PRINTING&BINDING 1,771 328 1,807 328 670 62090 PRINTING&BINDING 13,257 9,108 13,522 9,108 810 62090 PRINTING&BINDING 159 16 162 159 940 62090 PRINTING&BINDING 215 246 329 247 100 62110 COPYING/REPRODUCTION 980 945 980 944 250 62110 COPYING/REPRODUCTION 670 62110 COPYING/REPRODUCTION 146 159 146 159 810 62110 COPYING/REPRODUCTION 108 103 108 103 940 62110 COPYING/REPRODUCTION 866 1,134 866 1,134 100 62130 LEGAL NOTICES&ADS 903 2,828 250 62130 LEGAL NOTICES&ADS - 2,704 - 2,704 -104- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 670 62130 LEGAL NOTICES&ADS 2,927 3,244 2,985 3,244 810 62130 LEGAL NOTICES&ADS 1,387 - 881 1,124 940 62130 LEGAL NOTICES&ADS 3,087 2,716 3,149 2,716 670 62140 PROMOTION 3,269 1,763 7,334 6,250 940 62140 PROMOTION 11,871 24,042 18,061 24,715 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 1,209 1,209 1,233 1,209 940 62170 SUBSCRIPTIONS-BOOKS-MAPS 201 256 204 306 100 62190 DUES&MEMBERSHIPS 1,403 1,266 1,538 1,465 610 62190 DUES&MEMBERSHIPS - 20 - - 670 62190 DUES&MEMBERSHIPS 322 212 329 212 810 62190 DUES&MEMBERSHIPS 179 184 183 184 940 62190 DUES&MEMBERSHIPS 1,231 1,726 2,305 1,726 100 62204 REFUNDS - 75 - - 610 62204 REFUNDS 500 - 2,000 2,000 670 62204 REFUNDS 2,738 3,357 2,794 2,993 100 62206 PROPERTY INSURANCE 167 141 145 3,842 250 62206 PROPERTY INSURANCE 19,038 15,694 19,419 16,680 670 62206 PROPERTY INSURANCE 1,218 810 62206 PROPERTY INSURANCE 8,264 6,984 7,201 2,592 940 62206 PROPERTY INSURANCE 33,012 70,614 37,169 34,585 100 62207 BOILER INSURANCE 378 - 386 - 810 62207 BOILER INSURANCE 4,432 100 62208 GENERAL LIABILITY INSURAN 12,996 14,477 15,195 13,749 250 62208 GENERAL LIABILITY INSURAN 32,521 36,223 38,021 34,403 610 62208 GENERAL LIABILITY INSURAN 7,494 8,347 8,761 7,927 620 62208 GENERAL LIABILITY INSURAN 9,064 10,096 10,597 9,589 670 62208 GENERAL LIABILITY INSURAN 19,658 21,899 22,985 20,797 810 62208 GENERAL LIABILITY INSURAN 12,451 13,503 14,216 13,365 940 62208 GENERAL LIABILITY INSURAN 34,700 37,732 39,621 32,855 670 62210 SALES TAX 7,627 7,527 8,534 7,527 940 62210 SALES TAX 6,944 15,177 7,083 15,177 940 62211 PROPERTY TAX 2,300 2,514 2,346 2,514 100 62230 COURT COSTS&RECORD FEES 123 - 125 - 100 62310 TRAVEL-CONFERENCES 9,663 9,212 11,940 13,840 670 62310 TRAVEL-CONFERENCES 1,012 898 1,840 1,860 810 62310 TRAVEL-CONFERENCES 4,453 1,196 4,542 3,160 940 62310 TRAVEL-CONFERENCES 3,959 2,375 3,770 4,150 100 62320 TRAVEL-CITY BUSINESS - 3,218 300 286 670 62320 TRAVEL-CITY BUSINESS 310 373 316 373 940 62320 TRAVEL-CITY BUSINESS 2,369 2,839 2,585 3,039 100 62340 MILEAGE/LOCAL TRANSP 437 213 446 446 670 62340 MILEAGE/LOCAL TRANSP 112 246 114 246 940 62340 MILEAGE/LOCAL TRANSP 743 835 923 836 100 62360 EDUCATION&TRAINING 484 1,943 2,172 2,172 -105- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 250 62360 EDUCATION&TRAINING 3,050 12,301 10,111 10,727 610 62360 EDUCATION&TRAINING 3,055 2,908 8,000 8,000 620 62360 EDUCATION&TRAINING 65 75 300 300 670 62360 EDUCATION&TRAINING 1,198 290 1,222 1,200 810 62360 EDUCATION&TRAINING 1,483 1,015 1,513 12,000 940 62360 EDUCATION&TRAINING 3,204 3,102 3,768 3,436 940 62363 GREEN VISION-EDUC/TRAIN - 34,492 58,648 59,821 100 62411 UTILITY EXP-ELECTRICITY 25,024 39,919 26,025 40,386 250 62411 UTILITY EXP-ELECTRICITY 58,310 57,059 60,643 55,674 620 62411 UTILITY EXP-ELECTRICITY 1,579 1,529 1,642 1,720 670 62411 UTILITY EXP-ELECTRICITY 10,208 10,139 10,616 9,097 810 62411 UTILITY EXP-ELECTRICITY 19,394 19,264 13,083 15,656 940 62411 UTILITY EXP-ELECTRICITY 24,668 22,928 25,655 25,794 250 62412 UTILITY EXP-GAS 12,143 10,898 13,357 11,443 670 62412 UTILITY EXP-GAS 1,702 1,700 1,872 1,785 810 62412 UTILITY EXP-GAS 3,234 3,230 3,557 3,392 940 62412 UTILITY EXP-GAS 7,514 4,726 8,266 4,962 940 62415 UTILITY EXPENSE STORMWATR 5,210 5,552 5,315 5,552 100 62419 UTILITY EXP-ELEC ST LTNG 162,501 360,979 165,751 34,560 250 62419 UTILITY EXP-ELEC ST LTNG 388,000 114,706 395,760 662,563 100 62421 TELEPHONE 5,375 4,283 5,375 4,283 250 62421 TELEPHONE 2,924 2,512 2,924 2,512 610 62421 TELEPHONE 148 152 148 152 620 62421 TELEPHONE 79 - 79 79 670 62421 TELEPHONE 969 1,750 1,345 1,750 810 62421 TELEPHONE 1,465 1,519 1,465 1,519 940 62421 TELEPHONE 3,759 3,772 3,759 3,772 100 62424 RADIO/PAGER FEE 2,589 2,638 2,667 2,638 250 62424 RADIO/PAGER FEE 11,313 11,746 11,652 11,746 610 62424 RADIO/PAGER FEE 1,726 1,759 1,778 1,759 620 62424 RADIO/PAGER FEE 863 879 889 879 670 62424 RADIO/PAGER FEE 4,887 4,983 5,034 4,983 810 62424 RADIO/PAGER FEE 863 879 889 879 940 62424 RADIO/PAGER FEE 3,454 3,792 3,558 3,792 100 62431 PROPERTY MAINTENANCE 340 1,709 1,821 21,709 250 62431 PROPERTY MAINTENANCE 49,997 53,410 50,997 53,390 670 62431 PROPERTY MAINTENANCE 8,697 7,945 8,871 7,883 680 62431 PROPERTY MAINTENANCE 350 - 357 350 810 62431 PROPERTY MAINTENANCE 31,407 18,933 27,035 18,815 940 62431 PROPERTY MAINTENANCE 62,539 65,642 63,790 65,174 100 62436 RENTAL OF SPACE 720 720 735 720 250 62436 RENTAL OF SPACE 504 196 514 316 940 62436 RENTAL OF SPACE 1,768 1,767 1,803 1,803 100 62437 BARRICADE RENTAL 684 910 698 910 -106- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 250 62437 BARRICADE RENTAL 7,223 7,001 7,367 7,001 610 62437 BARRICADE RENTAL 1,153 520 1,176 520 620 62437 BARRICADE RENTAL 70 670 250 670 100 62511 FUEL, MOTOR VEHICLE 11,616 11,028 11,616 11,248 250 62511 FUEL, MOTOR VEHICLE 102,691 107,553 102,691 109,703 610 62511 FUEL, MOTOR VEHICLE 11,146 9,775 11,146 9,971 620 62511 FUEL, MOTOR VEHICLE 4,324 4,298 4,324 4,384 670 62511 FUEL, MOTOR VEHICLE 94,315 100,480 94,314 102,491 810 62511 FUEL, MOTOR VEHICLE 4,545 3,448 4,545 3,517 940 62511 FUEL, MOTOR VEHICLE 2,398 2,523 2,398 2,574 100 62512 FUEL,OFF ROAD VEHICLE 1,779 - 1,779 1,779 810 62512 FUEL,OFF ROAD VEHICLE 426 259 426 264 940 62512 FUEL,OFF ROAD VEHICLE 90,583 98,614 90,583 100,586 100 62521 MOTOR VEHICLE MAINT. 34,242 22,279 34,927 22,725 250 62521 MOTOR VEHICLE MAINT. 155,213 162,986 158,317 166,245 610 62521 MOTOR VEHICLE MAINT. 28,010 32,688 28,570 27,367 620 62521 MOTOR VEHICLE MAINT. 10,211 11,743 10,415 11,978 670 62521 MOTOR VEHICLE MAINT. 199,718 245,251 203,712 230,250 810 62521 MOTOR VEHICLE MAINT. 5,942 6,043 6,061 6,164 940 62521 MOTOR VEHICLE MAINT. 7,561 7,706 7,712 7,860 670 62522 VEHICLE MAINT.,ACCIDENT - 1,193 - - 100 62528 MOTOR VEH. MAINT. OUTSOUR 16,678 5,734 17,012 5,850 250 62528 MOTOR VEH. MAINT. OUTSOUR 43,278 40,635 44,143 41,447 610 62528 MOTOR VEH. MAINT. OUTSOUR 1,877 3,066 1,915 3,127 620 62528 MOTOR VEH. MAINT. OUTSOUR - 1,494 - 904 670 62528 MOTOR VEH. MAINT. OUTSOUR 53,893 55,901 54,971 57,019 810 62528 MOTOR VEH. MAINT. OUTSOUR 76 269 77 274 940 62528 MOTOR VEH. MAINT. OUTSOUR 12,188 5,800 12,432 5,916 100 62611 MACH/EQUIP MAINTENANCE 23,392 28,588 23,859 22,523 250 62611 MACH/EQUIP MAINTENANCE 423,613 466,262 432,086 428,169 610 62611 MACH/EQUIP MAINTENANCE 4,168 16,180 4,251 9,275 620 62611 MACH/EQUIP MAINTENANCE 4,661 3,242 3,867 3,242 810 62611 MACH/EQUIP MAINTENANCE 22,006 18,740 15,447 18,740 940 62611 MACH/EQUIP MAINTENANCE 200,758 91,065 180,177 92,064 100 62614 EQUIP MAINT CONTRACT 6,303 6,043 6,429 5,442 250 62614 EQUIP MAINT CONTRACT 10,669 9,478 10,882 12,355 610 62614 EQUIP MAINT CONTRACT 774 1,443 789 1,443 620 62614 EQUIP MAINT CONTRACT 387 721 395 721 670 62614 EQUIP MAINT CONTRACT 7,837 4,088 7,994 4,087 680 62614 EQUIP MAINT CONTRACT 1,325 1,325 1,352 1,325 810 62614 EQUIP MAINT CONTRACT 387 300 395 300 940 62614 EQUIP MAINT CONTRACT 7,352 7,425 7,499 7,425 100 62615 MACH/EQUIP MAINT. OUTSOUR 4,717 5,877 7,871 5,877 250 62615 MACH/EQUIP MAINT. OUTSOUR 33,692 56,721 34,367 42,169 -107- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 670 62615 MACH/EQUIP MAINT. OUTSOUR 7,586 - 7,738 3,394 810 62615 MACH/EQUIP MAINT. OUTSOUR 3,960 383 1,883 383 940 62615 MACH/EQUIP MAINT. OUTSOUR 223,260 91,651 131,891 91,651 100 62616 TRAFFIC&ST LT COMPONENT 80,538 64,247 82,149 64,247 100 62617 TRAFFIC CONTROLLER REPAIR - 3,201 4,282 3,201 250 62618 ASPHALT 737,497 866,871 717,262 693,864 610 62618 ASPHALT 19,498 - 10,000 11,642 620 62618 ASPHALT 5,051 4,172 5,152 4,172 940 62618 ASPHALT 1,565 - 1,596 - 100 62619 CONCRETE - 628 500 500 250 62619 CONCRETE 154,147 110,893 125,200 119,294 610 62619 CONCRETE 9,112 8,165 9,294 8,165 620 62619 CONCRETE 7,068 15,955 5,601 10,807 100 62620 STONE 446 66 455 566 250 62620 STONE 37,335 47,331 38,082 47,331 610 62620 STONE 2,526 17 1,000 17 620 62620 STONE 1,635 1,472 250 1,472 670 62620 STONE - 55 - 55 940 62620 STONE 64,890 60,017 66,188 60,017 250 62636 DE-ICING PRODUCTS 14,637 5,616 19,359 17,658 940 62636 DE-ICING PRODUCTS - 2,679 1,100 1,200 100 62637 LANDSCAPE/FERT/PLANTS 10,246 8,789 10,450 9,517 250 62637 LANDSCAPE/FERT/PLANTS 500 500 250 62640 SALT 272,247 284,785 294,400 226,000 680 62640 SALT 66,317 71,593 117,760 90,400 940 62649 BEVERAGE/ICE 1,079 1,097 1,100 1,097 100 62661 MISC.OPER. EXPENS 3 100 62663 SOFTWARE LICENSE EXP 7,420 51 7,568 7,975 250 62663 SOFTWARE LICENSE EXP 5,539 619 10,860 19,560 610 62663 SOFTWARE LICENSE EXP 3,953 3,953 24,170 24,170 670 62663 SOFTWARE LICENSE EXP 162 10,167 10,273 9,167 680 62663 SOFTWARE LICENSE EXP 72 - 73 73 810 62663 SOFTWARE LICENSE EXP 4,624 6,235 4,717 6,235 940 62663 SOFTWARE LICENSE EXP 25,576 12,735 11,684 20,735 810 62664 LICENSE/PERMIT FEES 220 220 224 220 940 62664 LICENSE/PERMIT FEES 733 629 748 629 940 62666 CREDIT CARD CHARGE 7,600 9,228 7,752 9,228 100 62667 INTERNET SERVICES 308 240 308 240 610 62667 INTERNET SERVICES 478 363 478 478 620 62667 INTERNET SERVICES 80 120 80 120 670 62667 INTERNET SERVICES 366 324 323 324 940 62667 INTERNET SERVICES 1,725 1,791 1,725 1,791 810 62669 PROGRAMMING 1,848 1,848 1,848 1,847 940 62671 MISC.OPERATING SUPPLIES - 250 - 250 -108- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 670 62673 FOOD SCRAP SUPPLIES 2,100 670 62674 BRUSH TIES 1,800 103 1,836 103 940 62679 MRF CUSTOMER PAYMENTS 44,869 250 62680 MANHOLE COMPONENTS - 24,206 - 24,206 610 62680 MANHOLE COMPONENTS 60,915 37,005 62,133 37,005 100 62685 SIGN SUPPLIES 58,911 20,906 60,090 60,090 940 62685 SIGN SUPPLIES 5,044 990 2,000 500 250 62686 CRACKSEAL MATERIALS 7,608 24,004 7,760 12,790 250 62687 TAC OIL 7,278 5,405 7,423 5,405 250 62692 LANDFILL FEES 55,433 45,492 56,541 51,267 670 62692 LANDFILL FEES 347,263 352,365 388,970 426,152 680 62692 LANDFILL FEES 253 3,037 258 258 100 62696 OUTSIDE COLLECTOR EXPENSE 249 437 254 503 670 62696 OUTSIDE COLLECTOR EXPENSE 3,534 2,955 3,605 2,955 610 62697 LABOR RELATIONS - 1,050 - - 940 62699 CASH SHORT AND OVER (452) 134 - 134 100 62710 CONTRACTOR SERVICES 10,960 9,486 15,390 14,686 250 62710 CONTRACTOR SERVICES 5,259 24,252 6,103 12,915 610 62710 CONTRACTOR SERVICES 10,873 - 11,091 11,091 670 62710 CONTRACTOR SERVICES - 7 - 7 810 62710 CONTRACTOR SERVICES 1,645 920 1,678 920 940 62710 CONTRACTOR SERVICES 13,925 8,627 14,204 8,627 100 62712 CONSULTING ENGINEERS 1,160 350 5,100 5,100 940 62712 CONSULTING ENGINEERS 112,466 137,269 117,348 162,827 100 62713 LEGAL SERVICES 10,341 324 400 62713 LEGAL SERVICES - 829 - - 670 62713 LEGAL SERVICES - 107 - - 940 62713 LEGAL SERVICES 3,724 72 1,000 1,000 250 62715 FORECASTING SERVICE 6,239 4,739 6,364 4,803 670 62716 CONSULTANT SERVICES - - 30,000 - 940 62716 CONSULTANT SERVICES 34,444 8,833 35,133 8,833 400 62721 FINANCIAL CONSULTANT - 716 - - 670 62721 FINANCIAL CONSULTANT - 92 - 92 940 62721 FINANCIAL CONSULTANT 8,000 5,000 7,500 5,000 670 62726 AUDIT SERVICES 700 750 750 830 940 62726 AUDIT SERVICES 3,525 4,200 3,800 4,180 940 62727 FINANCIAL SERVICE FEES 641 650 654 650 400 62731 MISCELLANEOUS SERVICES - 1,903 - - 670 62731 MISCELLANEOUS SERVICES - 245 - 245 670 62732 TEMP HELPCONTRACT SERV. 41,808 5,206 10,471 5,206 940 62732 TEMP HELPCONTRACT SERV. 59,462 27,499 60,651 60,000 100 62734 SPEAKERS/PROGRAMS 1,500 100 62736 CATERING SERVICES 844 940 62737 CONTRACT ADM SERVICE 84,193 86,959 49,398 52,657 -109- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 62746 ONE CALL OPERATION 3,518 4,416 3,588 4,416 100 62747 MACH/EQUIPMENT RENTAL 816 1,060 1,332 1,314 250 62747 MACH/EQUIPMENT RENTAL 387 1,050 5,394 5,607 940 62747 MACH/EQUIPMENT RENTAL 45,473 - 25,000 25,000 670 62748 APPLIANCE RECYCLING 1,500 940 62748 APPLIANCE RECYCLING 4,760 13,086 12,176 13,086 670 62750 TIRE RECYCLING 285 600 291 600 940 62750 TIRE RECYCLING 20,033 19,558 20,433 20,433 670 62761 PAY TO OTHER AGENCY 386 15,464 24,000 15,464 940 62761 PAY TO OTHER AGENCY 183,337 136,211 198,498 217,629 940 62763 PAYMENT TO IOWA DNR 224,236 276,292 275,237 294,000 940 62767 ENVIRON.TESTING/MON. 39,148 37,558 40,681 38,058 670 62770 GRIND/COMPOST SERVICE 16,057 13,247 940 62770 GRIND/COMPOST SERVICE 21,577 35,589 49,300 49,300 100 62780 HAULING SERVICES 15,435 13,773 35,082 22,000 250 62780 HAULING SERVICES 1,810 - 50,000 50,000 610 62780 HAULING SERVICES 2,850 - 1,000 1,000 940 62780 HAULING SERVICES 58,687 58,589 19,390 2,572 100 62781 LAWN CARE SERVICES 21,993 18,365 22,433 21,221 250 62782 HANDLING FEES 26,072 27,154 40,040 40,040 680 62782 HANDLING FEES 6,626 7,327 11,440 11,440 250 62783 TARPING FEES 6,039 20,013 6,160 20,013 680 62783 TARPING FEES 1,461 2,500 1,490 3,340 940 62784 ASPHALT SHINGLE RECYCLING 21,513 16,884 30,000 25,000 100 62811 ENG. DIVISION SERVICES 31,712 32,126 100 62833 SERVICE FROM WPC 2,000 2,000 62-SUPPLIES AND SERVICES 6,613,266 6,368,339 6,840,644 6,762,699 940 62724 BOND PAYING AGENT FEE - 750 - 750 627-CONTRACTUAL SERVICES - 750 - 750 810 63210 STORES-GARAGE 787,458 751,879 981,516 882,360 100 63311 ADMIN.OVERHEAD 52,155 56,037 55,262 53,673 250 63311 ADMIN.OVERHEAD 213,362 193,162 226,071 222,015 610 63311 ADMIN.OVERHEAD 28,448 25,472 30,142 29,277 620 63311 ADMIN.OVERHEAD 14,224 12,736 15,072 14,638 670 63311 ADMIN.OVERHEAD 66,380 59,434 70,307 68,312 680 63311 ADMIN.OVERHEAD 4,741 4,245 5,024 4,879 810 63311 ADMIN.OVERHEAD 23,707 21,227 25,119 24,397 820 63311 ADMIN.OVERHEAD 2,371 - 2,512 - 940 63311 ADMIN.OVERHEAD 68,752 61,557 72,843 69,584 100 63312 LESS ADMIN. RECHARGES (474,140) (424,531) (502,352) (486,775) 63-ADMIN/OVERHEAD/STORES GAR 787,458 761,218 981,516 882,360 100 71113 CALCULATORS - 17 - - 940 71113 CALCULATORS - 27 - - 100 71120 PERIPHERALS,COMPUTER 109 108 -110- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 250 71120 PERIPHERALS,COMPUTER 60 810 71120 PERIPHERALS,COMPUTER 165 940 71120 PERIPHERALS,COMPUTER 282 108 610 71122 PRINTER - 103 250 250 940 71122 PRINTER 91 - 350 153 100 71123 SOFTWARE 1,183 250 71123 SOFTWARE 4,000 940 71123 SOFTWARE 1,122 940 71125 SERVERS 615 810 71211 DESKS/CHAIRS - - 800 - 940 71212 SIDE CHAIRS 1,824 940 71213 TABLES 317 670 71221 CARTS 36,685 42,571 26,000 56,060 250 71314 TRUCK-REPLACEMENT - - - 75,000 610 71314 TRUCK-REPLACEMENT - - - 94,500 620 71314 TRUCK-REPLACEMENT - - 39,800 - 670 71314 TRUCK-REPLACEMENT - - 36,225 120,773 810 71314 TRUCK-REPLACEMENT - - 29,500 - 250 71318 HEAVY EQUIP-REPLACEMENT - - 86,000 89,500 250 71323 ASPHALT ROLLER 28,000 250 71328 TRAILERS 7,597 8,250 100 71410 SHOP EQUIPMENT 1,834 1,802 2,000 2,000 810 71410 SHOP EQUIPMENT 4,402 5,262 5,000 5,000 940 71410 SHOP EQUIPMENT 2,360 10,708 2,000 2,000 100 71411 TRAFFIC CONTROL EQUIPMENT 9,847 24,333 12,000 12,000 250 71414 AIR HAMMER/DRILL - 599 - - 100 71415 SAWS 600 250 71415 SAWS 999 620 71415 SAWS - 909 - 1,000 250 71416 PLOWS - 36,959 - - 250 71418 SALT SPREADERS 35,000 18,000 250 71420 EARTH COMPACTOR - 7,600 2,800 2,800 620 71420 EARTH COMPACTOR - 1,750 - - 250 71425 CURB FORMS - 1,995 - 2,000 610 71511 PUMPS 1,326 1,220 250 71512 COMPRESSORS 12,000 940 71520 HVAC 4,575 3,100 6,645 6,645 100 71550 MISCELLANEOUS EQUIPMENT - 7,130 - 11,150 250 71550 MISCELLANEOUS EQUIPMENT - 7,096 33,000 - 810 71550 MISCELLANEOUS EQUIPMENT - 2,298 21,500 - 940 71550 MISCELLANEOUS EQUIPMENT - 9,027 2,000 - 810 71610 CUSTODIAL EQUIPMENT 6,600 100 71611 MOWING EQUIPMENT - 35,177 - - 100 71612 WEED WHIPS/SICKLE BAR 1,000 -111- Recommended Operating Expenditure Budget - Department Total 54- PUBLIC WORKS FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 250 71615 LEAF BLOWER - 500 - - 100 71619 OTHER MAINT. EQUIPMENT - 6,400 - - 250 71619 OTHER MAINT. EQUIPMENT 99,000 610 71619 OTHER MAINT. EQUIPMENT - 725 20,000 15,500 940 71619 OTHER MAINT. EQUIPMENT 1,550 11,510 10,000 43,500 610 72111 GAS SAFETY MONITOR 814 1,519 1,500 1,500 940 72111 GAS SAFETY MONITOR - 820 - - 610 72114 CONFINED SPACE EQUIMENT - - 650 - 680 72417 CAMERA RELATED EQUIPMENT 800 940 72417 CAMERA RELATED EQUIPMENT - 14,941 - - 100 72418 TELEPHONE RELATED - 422 - 820 250 72418 TELEPHONE RELATED 120 610 72418 TELEPHONE RELATED 120 670 72418 TELEPHONE RELATED 337 246 450 350 810 72418 TELEPHONE RELATED - 362 - 570 940 72418 TELEPHONE RELATED 180 450 940 72419 PA SYSTEM - 3,182 - - 610 72816 JET FLUSHER HOSE 3,500 5,250 670 72818 RECYCLING CONTAINER 24,218 12,666 11,500 11,500 940 72818 RECYCLING CONTAINER - 2,567 2,400 - 71 -EQUIPMENT 114,312 264,009 391,050 718,511 250 72115 BARRICADESNVARN SIGNALS 905 5,742 3,400 25,400 72-EQUIPMENT 905 5,742 3,400 25,400 610 73211 CONST.CONTR-NOT BLDG - 5,000 - - 73-CIP EXPENDITURES - 5,000 - - 400 74111 PRINCIPAL PAYMENT 86,231 491,837 93,136 100,130 670 74111 PRINCIPAL PAYMENT 4,627 56,953 4,999 4,977 940 74111 PRINCIPAL PAYMENT 185,000 290,000 395,000 400,000 400 74112 INTEREST PAYMENT 40,340 37,961 28,201 37,078 670 74112 INTEREST PAYMENT 3,012 2,900 1,843 2,386 940 74112 INTEREST PAYMENT 127,584 189,961 272,559 262,659 74-DEBT SERVICE 446,794 1,069,612 795,738 807,230 670 91100 TO GENERAL 1,043,050 1,089,206 914,569 927,857 810 91100 TO GENERAL 4,134 940 91100 TO GENERAL 352,307 368,928 364,242 359,940 91 -TRANSFER TO 1,399,491 1,458,134 1,278,811 1,287,797 54-PUBLIC WORKS TOTAL 16,983,857 17,559,528 18,510,246 18,560,313 -112- Recommended Expenditure Budget Report by Activity & Funding Source 54- PUBLIC WORKS ADNIINISTRATION -54100 ANIM= FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR (424,531) (502,352) (486,775) DEBT SERVICE 59,853 6,842 7,363 EQUIPMENT 487 - 700 SUPPLIES AND SERVICES 39,441 44,357 42,900 TRANSFER TO 1,089,206 914,569 927,857 WAGES AND BENEFITS 397,918 448,042 452,081 ADMINISTRATION 1,162,375 LANDFILL 54200 FUNDING SOURCE:DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 33,962 40,188 38,391 CIP EXPENDITURES 5,000 CONTRACTUAL SERVICES 750 - 750 DEBT SERVICE 479,961 667,559 662,659 EQUIPMENT 53,950 23,575 21,248 SUPPLIES AND SERVICES 1,132,448 1,298,612 1,174,659 TRANSFER TO 368,928 364,242 359,940 WAGES AND BENEFITS 964,776 976,540 867,672 LANDFILL 3,039,774 3,370,716 I 1 I COMPOSTING LANDFILL -54210 FUNDING SOURCE:DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 4,245 5,024 4,799 SUPPLIES AND SERVICES 39,842 55,741 53,565 WAGES AND BENEFITS 16,192 23,870 30,130 COMPOSTING LANDFILL 60,280 84,635 HOUSEHOLD HAZ.MAT.R.C.C-54220 FUNDING SOURCE:DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 4,245 5,024 4,799 EQUIPMENT 12,000 SUPPLIES AND SERVICES 68,049 111,756 126,886 WAGES AND BENEFITS 56,816 96,710 1 00,31 0 HOUSEHOLD HAZ.MAT.R.C.0 129,110 213,490 DMASWA EDUCATION&COMM. -54230 -113- Recommended Expenditure Budget Report by Activity & Funding Source 54- PUBLIC WORKS FUNDING SOURCE:DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 4,245 5,024 4,799 EQUIPMENT - - - SUPPLIES AND SERVICES 143,855 133,049 135,605 WAGES AND BENEFITS 30,862 DMAS WA EDUCATION&COMM. 148,100 E-WASTE -54240 FUNDING SOURCE:DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 4,245 5,024 4,799 SUPPLIES AND SERVICES 62,808 43,990 63,307 WAGES AND BENEFITS 27,549 43,320 64,810 RURAL RECYCLING -54250 FUNDING SOURCE:DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 2,123 2,512 2,399 EQUIPMENT 19,500 SUPPLIES AND SERVICES 126,194 113,109 107,926 WAGES AND BENEFITS 3,401 3,093 16,087 RURAL RECYCLING 131,717 118,71 LANDFILL GAS SYSTEM -54260 FUNDING SOURCE:DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 8,491 10,047 9,598 EQUIPMENT 2,040 SUPPLIES AND SERVICES 44,967 67,865 72,501 WAGES AND BENEFITS 26,761 21,262 37,915 LANDFILL GAS SYSTEM 82,259 SAN-SEWER MNTNCE -5430 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 25,472 30,142 29,277 EQUIPMENT 3,567 25,900 117,120 SUPPLIES AND SERVICES 143,407 217,014 181,107 -114- Recommended Expenditure Budget Report by Activity & Funding Source 54- PUBLIC WORKS WAGES AND BENEFITS 401,225 508,073 502,637 a SAN-SEWER MNTNCE 573,671 830,14 STORM SEWER MAIN, -5431 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 12,736 15,072 14,638 EQUIPMENT 2,659 39,800 1,000 SUPPLIES AND SERVICES 62,096 55,343 61,322 WAGES AND BENEFITS 195,253 158,362 1 64,73 8 STORM SEWER MA INT 272,744 268,5 RIVERFRONT MANAGEMNT. -543 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 4,245 5,024 4,879 EQUIPMENT 27,590 500 2,100 SUPPLIES AND SERVICES 23,661 25,622 22,401 WAGES AND BENEFITS 47,584 56,982 59,770 RIVERFRONT MANAGEMNT. 103,080 FLOODWALL OPER./MAINT. -5434 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 12,736 15,071 14,638 SUPPLIES AND SERVICES 88,162 77,900 90,912 WAGES AND BENEFITS 75,412 72,234 66,918 El -II LOODWALL OPERJMAINT. 176,310 165,205 STREET MAINTENANCE -54400 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 84,906 100,477 97,589 EQUIPMENT 27,966 125,200 325,700 SUPPLIES AND SERVICES 1,616,249 1,480,514 1,464,577 WAGES AND BENEFITS 1,485,275 1,526,204 1,496,807 ET MAINTENANCE 3,214,397 3,232,395 STREET CLEANING -54410 FUNDING SOURCE:ROAD USE TAX Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 25,472 30,142 29,277 -115- Recommended Expenditure Budget Report by Activity & Funding Source 54- PUBLIC WORKS EQUIPMENT 500 SUPPLIES AND SERVICES 346,834 308,887 313,040 WAGES AND BENEFITS 322,314 355,183 352,146 STREET CLEANING 695,119 694,212 SNOW&ICE CONTROL -54420 FUNDING SOURCE:ROAD USE TAX Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 82,784 97,964 95,149 EQUIPMENT 40,275 35,000 18,120 SUPPLIES AND SERVICES 663,750 711,698 669,724 WAGES AND BENEFITS 420,192 647,925 624,549 SNOW&ICE CONTROL 1,207,000 1,492,587 SALT OPS-PURINA DRIVE - 54425 FUNDING SOURCE:SALT OPERATIONS Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 4,245 5,024 4,879 EQUIPMENT 800 SUPPLIES AND SERVICES 85,982 132,730 107,386 SALT OPS-PURINA DRIVE 90,227 137,75 AM ST.&TRAFFIC LTNG -54430 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 8,491 10,048 9,759 EQUIPMENT 32,580 13,000 13,770 SUPPLIES AND SERVICES 551,293 677,105 766,242 WAGES AND BENEFITS 193,802 197,863 1 96,51 9 7111 TRAFFIC LTNG 786,166 898,016 ST. SIGNS&MARKINGS -54435 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 8,491 10,048 9,759 EQUIPMENT 692 500 11,000 SUPPLIES AND SERVICES 41,741 104,632 95,770 WAGES AND BENEFITS 117,844 128,934 1 26,31 2 ST.SIGNS&MARKINGS 168,767 244,114 242,8 AIL ONE CALL LOCATION SERVICE- 54440 FUNDING SOURCE:GENERAL -116- Recommended Expenditure Budget Report by Activity & Funding Source 54- PUBLIC WORKS Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 9,338 SUPPLIES AND SERVICES 4,416 24,300 25,542 WAGES AND BENEFITS (1,950) ONE CALL LOCATION SERVICE 11,805 24,300 25,542 PORT OF DUB.MAINTENANCE-54450 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 12,736 15,071 14,638 EQUIPMENT 14,041 SUPPLIES AND SERVICES 68,321 90,061 1 08,64 0 WAGES AND BENEFITS 72,550 65,417 63,589 PORT OF DUB.MAINTENANCE 167,647 MIL DEBT SERVICE -54490 FUNDING SOURCE:DEBT SERVICE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget DEBT SERVICE 529,798 121,337 137,208 SUPPLIES AND SERVICES 3,448 I= DEBT SERVICE 533,246 REFUSE COLLECTION -54500 41111 FUNDING SOURCE:REFUSE COLLECTION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 21,227 25,119 24,397 EQUIPMENT 24,067 44,675 154,173 SUPPLIES AND SERVICES 650,545 639,752 689,533 WAGES AND BENEFITS 933,119 952,327 932,608 REFUSE COLLECTION 1,628,958 1,661,873 1,800,71 YARD WASTE COLLECTION -545 1, FUNDING SOURCE:REFUSE COLLECTION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 8,491 10,047 9,759 EQUIPMENT - - - SUPPLIES AND SERVICES 63,750 78,715 75,226 WAGES AND BENEFITS 139,825 114,086 117,915 YARD WASTE COLLECTION 212,066 202,848 202,900 LARGE ITEM COLLECTION -54520 -117- Recommended Expenditure Budget Report by Activity & Funding Source 54- PUBLIC WORKS FUNDING SOURCE:REFUSE COLLECTION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 12,736 15,047 14,638 SUPPLIES AND SERVICES 2,711 9,056 3,843 WAGES AND BENEFITS 10,929 15,646 15,805 LARGE ITEM COLLECTION 26,376 39,74 RECYCLING COLL.PROG. - 54530 FUNDING SOURCE:REFUSE COLLECTION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 16,981 20,094 19,518 EQUIPMENT 31,415 29,500 34,510 SUPPLIES AND SERVICES 175,265 209,578 182,308 WAGES AND BENEFITS 699,914 732,815 704,494 RECYCLING COLL.PROG. 923,575 PUBLIC WORKS GARAGE -54600 FUNDING SOURCE:GARAGE SERVICE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR 773,105 1,006,635 906,757 EQUIPMENT 7,922 56,800 12,170 SUPPLIES AND SERVICES 119,107 129,258 127,777 TRANSFER TO - - - WAGES AND BENEFITS 1,020,026 1,074,199 1,050,892 PUBLIC WORKS GARAGE 1,920,160 2,266,89 2,097,596 PCARD CLEARING -99999 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 0 0 0 PCARD CLEARING PUBLIC WKS 0 0 0 PUBLIC WORKS TOTAL $17,559,532.06 $18,510,246.00 $18,560,313.00 -118- Recommended Expenditure Budget Report by Activity & Funding Source 82- DMASWA METRO LANDFILL -82800 FUNDING SOURCE: DMASWA-GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 197,402 43,250 — SUPPLIES AND SERVICES 49,046 176,405 49,054 TRANSFER TO 203,929 — — METRO LANDFILL-GENL. 450,377 219,655 49,054 TRANSFER TO 199,955 — — UNDISTRIBUTED 941 199,955 — — DMASWA TOTAL $ 650,332.03 $ 219,655.00 $ 49,054.00 -119- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 54 PUBLIC WORKS DEPARTMENT FY 2017 FY 2018 FY 2019 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 3325 GE-41 PUBLIC WORKS DIRECTOR 1.00 $ 113,720 1.00 $ 113,491 1.00 $ 117,283 100 1490 GE-38 ASSIST PUBLIC WORKS DIRECTOR 0.00 $ - 1.00 $ 84,185 1.00 $ 81,065 STREET MAINTENANCE 100 3100 GE-37 SUPERVISOR 1.00 $ 91,796 0.00 $ - 0.00 $ - 810 3225 GE-35 EQUIP MAINT. SUPERVISOR 1.00 $ 79,252 1.00 $ 80,611 1.00 $ 68,953 670 6100 GE-35 RESOURCE MANAGEMENT COORD. 1.00 $ 64,653 1.00 $ 69,306 1.00 $ 74,221 940 2625 GE-35 DMASWAADMINISTRATOR 1.00 $ 79,577 1.00 $ 84,187 1.00 $ 85,447 940 2625 GE-35 LANDFILL SUPERVISOR 1.00 $ 78,467 1.00 $ 80,527 1.00 $ 81,734 100 2925 GE-31 TRAFFIC SIGNAL TECHNICIAN II 1.88 $ 127,901 1.88 $ 116,488 1.88 $ 120,858 250 2925 GE-31 TRAFFIC SIGNAL TECHNICIAN II 0.12 $ 8,192 0.12 $ 7,310 0.12 $ 7,617 100 225 GE-25 SECRETARY 1.00 $ 47,357 1.00 $ 48,120 1.00 $ 48,841 100 2655 GD-11 FOREMAN 0.48 $ 27,599 0.44 $ 25,699 0.31 $ 18,356 250 2655 GD-11 FOREMAN 4.35 $ 261,559 3.41 $ 201,576 3.65 $ 217,137 610 2655 GD-11 FOREMAN 1.35 $ 79,840 1.35 $ 81,328 1.31 $ 79,308 620 2655 GD-11 FOREMAN 0.82 $ 48,829 0.80 $ 48,403 0.73 $ 42,988 940 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 1.00 $ 58,487 100 GD-11 FIELD SUPERVISOR 0.00 $ - 0.04 $ 2,576 0.10 $ 6,863 250 GD-11 FIELD SUPERVISOR 0.00 $ - 0.94 $ 60,527 0.90 $ 61,763 620 GD-11 FIELD SUPERVISOR 0.00 $ - 0.02 $ 1,288 0.00 $ - 670 2655 GD-11 LEAD SANITATION DRIVER 1.00 $ 59,546 1.00 $ 60,502 1.00 $ 61,412 810 7250 GD-11 LEAD MECHANIC 2.00 $ 111,135 2.00 $ 113,194 2.00 $ 116,231 810 2525 GD-10 MECHANIC 7.00 $ 384,621 7.00 $ 390,861 7.00 $ 397,566 940 2525 GD-10 MECHANIC 1.00 $ 55,603 1.00 $ 54,199 1.00 $ 57,346 100 2300 GD-08 EQUIPMENT OPERATOR II 0.92 $ 49,695 0.92 $ 50,466 0.91 $ 49,767 250 2300 GD-08 EQUIPMENT OPERATOR II 5.24 $ 285,786 5.24 $ 288,316 5.27 $ 293,417 610 2300 GD-08 EQUIPMENT OPERATOR II 0.77 $ 42,778 0.77 $ 41,810 0.72 $ 39,682 620 2300 GD-08 EQUIPMENT OPERATOR II 0.07 $ 3,846 0.07 $ 3,801 0.10 $ 5,512 820 2300 GD-08 EQUIPMENT OPERATOR II 0.00 $ - 0.00 $ - 0.00 $ - 940 2300 GD-08 EQUIPMENT OPERATOR II 6.00 $ 320,541 3.00 $ 166,539 2.00 $ 113,501 940 GD-08 LANDFILL EQUIPMENT OPERATOR 0.00 $ - 3.00 $ 162,027 3.00 $ 165,278 250 GD-05 UTILITY WORKER 0.00 $ - 1.00 $ 48,330 4.70 $ 232,432 610 GD-05 UTILITY WORKER 0.00 $ - 0.00 $ - 0.30 $ 15,069 250 NA-48 UTILITY WORKER APPRENTICE 0.00 $ - 0.00 $ - 1.00 $ 37,524 670 GD-04 SANITATION LABORER 1.00 $ 51,813 1.00 $ 52,646 1.00 $ 53,436 810 835 GD-03 STOCK CLERK 2.00 $ 88,467 2.00 $ 91,423 2.00 $ 94,245 100 2375 GD-06 EQUIPMENT OPERATOR I 0.85 $ 44,052 0.60 $ 31,586 0.90 $ 48,931 250 2375 GD-06 EQUIPMENT OPERATOR I 4.70 $ 241,920 6.07 $ 319,244 5.60 $ 300,862 610 2375 GD-06 EQUIPMENT OPERATOR I 3.53 $ 187,231 3.41 $ 184,313 3.38 $ 183,625 620 2375 GD-06 EQUIPMENT OPERATOR I 0.92 $ 48,944 0.92 $ 49,986 1.12 $ 61,652 670 1300 GD-06 SANITATION DRIVER 17.00 $ 889,995 17.00 $ 910,893 17.00 $ 910,675 100 2205 GD-06 MAINTENANCE WORKER 0.84 $ 45,581 0.84 $ 46,314 0.77 $ 43,090 250 2205 GD-06 MAINTENANCE WORKER 1.16 $ 62,943 0.16 $ 8,822 0.23 $ 12,872 250 GD-06 ASSISTANT HORTICULTURALIST 0.42 $ - 0.42 $ - 0.42 $ 6,606 100 1475 GD-05 TRUCK DRIVER 0.02 $ 1,051 0.02 $ 1,069 0.00 $ - 250 1475 GD-05 TRUCK DRIVER 10.50 $ 538,453 9.55 $ 494,847 5.70 $ 300,982 610 1475 GD-05 TRUCK DRIVER 0.46 $ 23,856 0.41 $ 21,741 0.30 $ 15,747 -120- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 54 PUBLIC WORKS DEPARTMENT FY 2017 FY 2018 FY 2019 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 620 1475 GD-05 TRUCK DRIVER 0.02 $ 1,051 0.02 $ 1,069 0.00 $ - 940 870 GD-04 SCALE HOUSE OPERATOR 2.00 $ 98,463 2.00 $ 102,177 2.00 $ 103,738 100 811 NA-50 ACCOUNT CLERK II 1.00 $ 54,744 1.00 $ 55,625 1.00 $ 56,460 TOTAL FULL TIME EMPLOYEES 86.42 $ 4,800,857 86.42 $4,857,422 87.42 $4,948,579 61020 Part Time Employee Expense 250 0E-06 CUSTODIAN I 0.38 $ 16,908 0.38 $ 17,441 0.38 $ 17,855 670 0E-06 CUSTODIAN I 0.08 $ 3,560 0.08 $ 3,617 0.08 $ 3,759 810 0E-06 CUSTODIAN I 0.15 $ 6,674 0.15 $ 6,782 0.15 $ 7,048 100 NA-22 CLERICAL ASSISTANT 0.50 $ 11,933 0.50 $ 11,887 0.68 $ 17,658 TOTAL PART TIME EMPLOYEES 1.11 $ 39,075 1.11 $ 39,727 1.29 $ 46,320 61030 Seasonal Employee Expense 670 1325 NA-26 SANITATION DRIVER 0.67 $ 20,733 0.67 $ 20,653 0.67 $ 20,963 940 1325 NA-26 EQUIPMENT OPERATOR 0.75 $ 23,208 0.75 $ 23,119 0.75 $ 23,466 100 898 NA-01 LABORER-STNVNWV-SEASONAL 2.03 $ 48,874 2.03 $ 48,687 1.47 $ 35,649 250 898 NA-01 LABORER-STNVNVW-SEASONAL 1.11 $ 25,842 1.11 $ 25,743 0.36 $ 8,474 TOTAL SEASONAL EMPLOYEES 4.56 $ 118,657 4.56 $ 118,202 3.25 $ 88,552 TOTAL PUBLIC WORKS DEPARTMENT 92.09 $4,958,589 92.09 $5,015,351 91.96 $5,083,451 -121- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Public Works Administration-FT 10054100 61010 100 3325 GE-41 PUBLIC WORKS DIRECTOR 1.00 $ 113,720 1.00 $ 113,491 1.00 $ 117,283 ASST PUBLIC WORKS 10054100 61010 100 1490 GE-38 DIRECTOR 0.00 $ - 1.00 $ 84,185 1.00 $ 81,065 10054100 61010 100 225 GE-25 SECRETARY 1.00 $ 47,357 1.00 $ 48,120 1.00 $ 48,841 10054100 61010 100 811 NA-50 ACCOUNT CLERK II 1.00 $ 54,744 1.00 $ 55,625 1.00 $ 56,460 STREET MAINTENANCE 10054100 61010 100 3100 GE-37 SUPERVISOR 1.00 $ 91,796 0.00 $ - 0.00 $ - Total 4.00 $ 307,617 4.00 $ 301,421 4.00 $ 303,649 Public Works Administration-Part-Time 10054100 61030 100 400 NA-22 CLERICAL ASSISTANT 0.50 $ 11,933 0.50 $ 11,887 0.68 $ 17,658 Total 0.50 $ 11,933 0.50 $ 11,887 0.68 $ 17,658 Riverfront Management-FT General Fund 10054330 61010 100 1475 GD-05 TRUCK DRIVER 0.02 $ 1,051 0.02 $ 1,069 0.00 $ - 10054330 61010 100 2375 GD-07 EQUPMENT OPERATOR II 0.02 $ 1,069 0.02 $ 1,086 0.10 $ 5,566 10054330 61010 100 2205 GD-06 MAINTENANCE WORKER 0.50 $ 27,131 0.50 $ 27,568 0.50 $ 27,981 10054330 61010 100 GE-31 FIELD SUPERVISOR 0.00 $ - 0.02 $ 1,288 0.00 $ - 10054330 61010 100 GD-11 FOREMAN 0.02 $ 1,191 0.00 $ - 0.00 $ - Total 0.56 $ 30,442 0.56 $ 31,011 0.60 $ 33,547 Riverfront Management-Seasonal General Fund LABORER-ST/VV/WW- 10054330 61030 100 898 NA-01 SEASONAL 0.21 $ 5,218 0.21 $ 5,198 0.21 $ 5,271 Total 0.21 $ 5,218 0.21 $ 5,198 0.21 $ 5,271 Floodwall O p e r./M a i nt e n an c e 10054340 61010 100 2205 GD-06 MAINTENANCE WORKER 0.02 $ 1,086 0.02 $ 1,103 0.02 $ 1,119 10054340 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.06 $ 3,259 0.06 $ 3,269 0.04 $ 2,211 10054340 61010 100 2655 GD-11 FOREMAN 0.46 $ 26,408 0.44 $ 25,699 0.31 $ 18,356 10054340 61010 100 GE-31 FIELD SUPERVISOR 0.00 $ - 0.02 $ 1,288 0.10 $ 6,863 10054340 61010 100 2375 GD-06 EQUPMENT OPERATOR I 0.10 $ 5,314 0.10 $ 5,415 0.10 $ 5,458 Total 0.64 $ 36,067 0.64 $ 36,774 0.57 $ 34,007 Floodwall O per./M ai nt en an ce-Seasonal 10054340 61030 100 898 NA-01 LABORER SEASONAL 0.13 $ 3,027 0.13 $ 3,015 0.13 $ 3,060 Total 0.13 $ 3,027 0.13 $ 3,015 0.13 $ 3,060 Street&Traffic Lighting-FT General Fund 10054430 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.02 $ 1,079 0.02 $ 1,097 0.02 $ 1,091 TRAFFIC SIGNAL 10054430 61010 100 2925 GE-31 TECHNICIAN II 1.87 $ 127,207 1.87 $ 115,928 1.86 $ 119,664 Total 1.89 $ 128,286 1.89 $ 117,025 1.88 $ 120,755 Street Signs&Markings-FT General Fund TRAFFIC SIGNAL 10054435 61010 100 2925 GE-31 TECHNICIAN II 0.00 $ - 0.00 $ - 0.01 $ 597 10054435 61010 100 2375 GD-06 EQUIPMENT OPERATOR I 0.75 $ 38,738 0.50 $ 26,171 0.45 $ 23,992 10054435 61010 100 2300 GD-08 EQUIPMENT OPERATOR II 0.82 $ 44,288 0.82 $ 45,014 0.85 $ 46,465 Total 1.57 $ 83,026 1.32 $ 71,185 1.31 $ 71,054 Street Signs&Markings-Seasonal General Fund LABORER-ST/VV/VVW- 10054435 61030 100 898 NA-01 SEASONAL 0.67 $ 15,598 0.67 $ 15,539 0.67 $ 15,772 Total 0.67 $ 15,598 0.67 $ 15,539 0.67 $ 15,772 -122- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Port of Dubuque Maintenance-FT 10054450 61010 100 2205 GD-06 MAINTENANCE WORKER 0.32 $ 17,364 0.32 $ 17,643 0.25 $ 13,990 TRAFFIC SIGNAL 10054450 61010 100 2925 GE-31 TECHNICIAN II 0.01 $ 694 0.01 $ 560 0.01 $ 597 10054450 61010 100 1475 GD-05 EQUIPMENT OPERATOR I 0.00 $ - 0.00 $ - 0.25 $ 13,915 Total 0.33 $ 18,058 0.33 $ 18,203 0.51 $ 28,502 Port of Dubuque Maintenance-Seasonal 10054450 61030 100 898 NA-01 LABORER-SEASONAL 1.02 $ 25,031 1.02 $ 24,935 0.46 $ 11,546 Total 1.02 $ 25,031 1.02 $ 24,935 0.46 $ 11,546 Street Maintenance-FT Road Use Tax Fund ASSISTANT 25054400 61010 250 GD-06 HORTICULTURALIST 0.25 $ - 0.25 $ - 0.25 $ 3,932 25054400 61010 100 2205 GD-06 MAINTENANCE WORKER 0.00 $ - 0.00 $ - 0.07 $ 3,918 25054400 61010 250 GD-05 UTILITY WORKER 0.00 $ - 0.83 $ 40,114 3.85 $ 190,356 UTILITY WORKER 25054400 61010 NA-48 APPRENTICE 0.00 $ - 0.00 $ - 1.00 $ 37,524 25054400 61010 250 2300 GD-08 EQUIPMENT OPERATOR II 2.43 $ 132,560 2.43 $ 133,269 0.94 $ 52,374 25054400 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 2.41 $ 123,331 2.78 $ 145,892 3.88 $ 207,910 25054400 61010 250 2655 GD-11 FOREMAN 3.40 $ 197,601 2.63 $ 155,406 2.75 $ 163,682 25054400 61010 250 GE-31 FIELD SUPERVISOR 0.00 $ - 0.77 $ 49,581 0.73 $ 50,096 25054400 61010 250 1475 GD-05 TRUCK DRIVER 7.81 $ 400,561 7.03 $ 366,662 3.87 $ 203,691 Total 16.30 $ 854,053 16.72 $ 890,924 17.34 $ 913,483 Street Maintenance-PT Road Use Tax Fund 25054400 61020 250 OE-06 CUSTODIAN I 0.38 $ 16,908 0.38 $ 17,441 0.38 $ 17,855 Total 0.38 $ 16,908 0.38 $ 17,441 0.38 $ 17,855 Street Maintenance-Seasonal Road Use Tax Fund LABORER-ST/VV/WW- 25054400 61030 250 898 NA-01 SEASONAL 0.75 $ 17,461 0.75 $ 17,394 0.00 $ - Total 0.75 $ 17,461 0.75 $ 17,394 0.00 $ - Street Cleaning-Full lime Road Use Tax Fund 25054410 61010 250 1475 GD-05 TRUCK DRIVER 0.85 $ 40,730 0.85 $ 42,303 0.83 $ 45,021 25054410 61010 250 2205 GD-06 MAINTENANCE WORKER 0.84 $ 45,581 0.00 $ - 0.00 $ - 25054410 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 0.75 $ 38,308 1.59 $ 83,032 0.00 $ - 25054410 61010 250 2300 GD-08 EQUIPMENT OPERATOR II 1.68 $ 91,555 1.68 $ 93,029 3.21 $ 178,967 Total 4.12 $ 216,174 4.12 $ 218,364 4.04 $ 223,988 Street Cleaning-Seasonal-Road Use Tax Fund LABORER-ST/VV/VVW- 25054410 61030 250 898 NA-01 SEASONAL 0.36 $ 8,381 0.36 $ 8,349 0.36 $ 8,474 Total 0.36 $ 8,381 0.36 $ 8,349 0.36 $ 8,474 Snow Removal-FT 25054420 61010 250 2925 GE-31 TRAFFIC SIGNAL TECH II 0.12 $ 8,192 0.12 $ 7,310 0.12 $ 7,617 25054420 61010 250 GD-05 UTILITY WORKER 0.00 $ - 0.17 $ 8,216 0.85 $ 42,076 ASSISTANT 25054420 61010 250 GD-06 HORTICULTURALIST 0.17 $ - 0.17 $ - 0.17 $ 2,674 25054420 61010 250 2205 GD-06 MAINTENANCE WORKER 0.32 $ 17,362 0.16 $ 8,822 0.16 $ 8,954 25054420 61010 250 2655 GD-11 FOREMAN 0.95 $ 63,958 0.78 $ 46,170 0.90 $ 53,455 25054420 61010 250 GE-31 FIELD SUPERVISOR 0.00 $ - 0.17 $ 10,946 0.17 $ 11,667 25054420 61010 250 2300 GD-08 EQUIPMENT OPERATOR II 1.13 $ 61,671 1.13 $ 62,018 1.12 $ 62,076 25054420 61010 250 2375 GD-06 EQUIPMENT OPERATOR I 1.54 $ 80,281 1.70 $ 90,320 1.72 $ 92,952 -123- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET 25054420 61010 250 1475 GD-05 TRUCK DRIVER 1.84 $ 97,162 1.67 $ 85,882 1.00 $ 52,270 Total 6.07 $ 328,626 6.07 $ 319,684 6.21 $ 333,741 Sanitary Sewer Maintenance-FT Sewer Use Fund 61054300 61010 610 2375 GD-06 EQUIPMENT OPERATOR I 3.53 $ 187,231 3.41 $ 184,313 3.38 $ 183,625 61054300 61010 610 2300 GD-08 EQUIPMENT OPERATOR II 0.77 $ 42,778 0.77 $ 41,810 0.72 $ 39,682 61054300 61010 610 1475 GD-05 TRUCK DRIVER 0.46 $ 23,856 0.41 $ 21,741 0.30 $ 15,747 61054300 61010 610 2655 GD-11 FOREMAN 1.35 $ 79,840 1.35 $ 81,328 1.31 $ 79,308 Total 6.11 $ 333,705 5.94 $ 329,192 6.01 $ 333,431 Storm Sewer Maintenance-FT Stormwater Fund 62054310 61010 620 2300 GD-08 EQUIPMENT OPERATOR II 0.07 $ 3,846 0.07 $ 3,801 0.10 $ 5,512 61054300 61010 610 GD-05 UTILITY WORKER 0.00 $ - 0.00 $ - 0.30 $ 15,069 62054310 61010 620 2375 GD-06 EQUIPMENT OPERATOR I 0.92 $ 48,944 0.92 $ 49,986 1.12 $ 61,652 62054310 61010 620 1475 GD-05 TRUCK DRIVER 0.02 $ 1,051 0.02 $ 1,069 0.00 $ - 62054310 61010 620 GE-31 FIELD SUPERVISOR 0.00 $ - 0.02 $ 1,288 0.00 $ - 62054310 61010 620 2655 GD-11 FOREMAN 0.82 $ 48,829 0.80 $ 48,403 0.73 $ 42,988 Total 1.83 $ 102,670 1.83 $ 104,547 1.95 $ 110,152 Refuse Collection-FT Refuse Fund RESOURCE MGMT 67054500 61010 670 6100 GE-35 COORDINATOR 0.40 $ 25,862 0.40 $ 27,723 0.40 $ 29,688 67054500 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.40 $ 23,818 0.40 $ 24,201 0.40 $ 24,565 67054500 61010 670 GD-04 SANITATION LABORER 1.00 $ 51,813 1.00 $ 52,646 1.00 $ 53,436 67054500 61010 670 1300 GD-06 SANITATION DRIVER 8.75 $ 467,563 8.80 $ 475,221 8.75 $ 472,910 Total 10.55 $ 569,056 10.60 $ 579,791 10.55 $ 580,599 Refuse Collection-PT 67054500 61020 670 OE-06 CUSTODIAN I 0.08 $ 3,560 0.08 $ 3,617 0.08 $ 3,759 Total 0.08 $ 3,560 0.08 $ 3,617 0.08 $ 3,759 Refuse Collection-Seasonal Refuse Fund LABORER-ST/VV/WW- 67054500 61030 670 898 NA-01 SEASONAL 0.09 $ 2,785 0.09 $ 2,774 0.09 $ 2,816 Total 0.09 $ 2,785 0.09 $ 2,774 0.09 $ 2,816 Yard Waste Collection-FT Refuse Fund 67054510 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.10 $ 5,955 0.10 $ 6,050 0.10 $ 6,141 67054510 61010 670 1300 GD-06 SANITATION DRIVER 0.80 $ 42,151 0.80 $ 42,428 0.90 $ 49,034 RESOURCE MGMT 67054510 61010 670 6100 GE-35 COORDINATOR 0.10 $ 6,465 0.10 $ 6,930 0.10 $ 7,422 Total 1.00 $ 54,571 1.00 $ 55,408 1.10 $ 62,597 Yard Waste Collection-Seasonal Refuse Fund 67054510 61030 670 1325 NA-26 SANITATION DRIVER 0.50 $ 15,472 0.50 $ 15,413 0.50 $ 15,644 Total 0.50 $ 15,472 0.50 $ 15,413 0.50 $ 15,644 Large Item Collection-FT Refuse Fund 67054520 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.10 $ 5,955 0.10 $ 6,050 0.10 $ 6,141 RESOURCE MGMT 67054520 61010 670 6100 GE-35 COORDINATOR 0.06 $ 3,879 0.06 $ 4,159 0.06 $ 4,454 Total 0.16 $ 9,834 0.16 $ 10,209 0.16 $ 10,595 Recycling Collection Program-FT Refuse Fund RESOURCE MGMT 67054530 61010 670 6100 GE-35 COORDINATOR 0.44 $ 28,447 0.44 $ 30,494 0.44 $ 32,657 67054530 61010 670 2655 GD-11 LEAD SANITATION DRIVER 0.40 $ 23,818 0.40 $ 24,201 0.40 $ 24,565 67054530 61010 670 1300 GD-06 SANITATION DRIVER 7.45 $ 380,281 7.40 $ 393,244 7.35 $ 388,731 Total 8.29 $ 432,546 8.24 $ 447,939 8.19 $ 445,953 -124- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Recycling Collection Program-Seasonal Refuse Fund SANITATION DRIVER- 67054530 61030 670 898 NA-01 SEASONAL 0.08 $ 2,476 0.08 $ 2,466 0.08 $ 2,503 Total 0.08 $ 2,476 0.08 $ 2,466 0.08 $ 2,503 City Garage-FT Service Fund 81054600 61010 810 3225 GE-35 EQUIP MAINT.SUPERVISOR 1.00 $ 79,252 1.00 $ 80,611 1.00 $ 68,953 81054600 61010 810 2525 GD-10 MECHANIC 7.00 $ 384,621 7.00 $ 390,861 7.00 $ 397,566 81054600 61010 810 835 GD-03 STOCK CLERK 2.00 $ 88,467 2.00 $ 91,423 2.00 $ 94,245 81054600 61010 810 7250 GD-11 LEAD MECHANIC 2.00 $ 111,135 2.00 $ 113,194 2.00 $ 116,231 Total 12.00 $ 663,475 12.00 $ 676,089 12.00 $ 676,995 City Garage-PT Service Fund 81054600 61020 810 3056 OE-06 CUSTODIAN I 0.15 $ 6,674 0.15 $ 6,782 0.15 $ 7,048 Total 0.15 $ 6,674 0.15 $ 6,782 0.15 $ 7,048 Street Maintenance-FT Internal Service 82054400 61010 820 1475 GD-05 TRUCK DRIVER 0.00 $ - 0.00 $ - 0.00 $ - Total 0.00 $ - 0.00 $ - 0.00 $ - Street Maintenance-Seasonal Internal Service 82054400 61030 820 898 NA-01 LABORER-SEASONAL 0.00 $ - 0.00 $ - 0.00 $ - Total 0.00 $ - 0.00 $ - 0.00 $ - Landfill-FT 94054200 61010 940 2625 GE-35 DMASWAADMINISTRATOR 0.75 $ 59,682 0.75 $ 63,139 0.40 $ 34,179 94054200 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.70 $ 54,927 0.70 $ 56,369 0.63 $ 51,493 94054200 61010 620 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 0.63 $ 36,847 94054200 61010 940 2525 GD-10 MECHANIC 1.00 $ 55,603 1.00 $ 54,199 1.00 $ 57,346 94054200 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 5.35 $ 285,798 3.00 $ 166,539 1.55 $ 88,208 LANDFILL EQUIP 94054200 61010 940 2948 GD-08 OPERATOR 0.00 $ - 2.45 $ 132,298 2.80 $ 154,319 94054200 61010 940 870 GD-04 LABORER-G.D. 1.20 $ 59,036 1.20 $ 61,294 1.10 $ 57,084 Total 9.00 $ 515,046 9.10 $ 533,838 8.11 $ 479,476 Landfill-Seasonal 94054200 61030 940 1325 NA-26 EQUIPMENT OPERATOR 0.75 $ 23,208 0.75 $ 23,119 0.75 $ 23,466 Total 0.75 $ 23,208 0.75 $ 23,119 0.75 $ 23,466 Composting-Landfill Program-FT 94054210 61010 940 2625 GE-35 DMASWAADMINISTRATOR 0.03 $ 2,388 0.03 $ 2,526 0.05 $ 4,272 94054210 61010 620 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 0.05 $ 2,924 94054210 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 0.15 $ 7,704 0.00 $ - 0.00 $ - LANDFILL EQUIP 94054210 61010 940 2948 GD-08 OPERATOR 0.00 $ - 0.15 $ 8,081 0.15 $ 8,267 94054210 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.05 $ 3,923 0.05 $ 4,026 0.05 $ 4,086 Total 0.23 $ 14,015 0.23 $ 14,633 0.30 $ 19,549 HHMRCC-Landfill Program-FT 94054220 61010 940 2625 GE-35 DMASWAADMINISTRATOR 0.10 $ 7,957 0.10 $ 8,419 0.10 $ 8,545 94054220 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.10 $ 7,847 0.10 $ 8,053 0.10 $ 8,174 94054220 61010 620 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 0.10 $ 5,849 94054220 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 0.05 $ 2,568 0.00 $ - 0.10 $ 5,621 LANDFILL EQUIP 94054220 61010 940 2948 GD-08 OPERATOR 0.00 $ - 0.05 $ 2,644 0.05 $ 2,692 94054220 61010 940 870 GD-04 LABORER-G.D. 0.80 $ 39,427 0.80 $ 40,883 0.65 $ 33,680 Total 1.05 $ 57,799 1.05 $ 59,999 1.10 $ 64,561 -125- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Education&Communication-Landfill Program-FT 94054230 61010 940 2625 GE-35 DMASWAADMINISTRATOR 0.00 $ - 0.00 $ - 0.05 $ 4,272 94054230 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.00 $ - 0.00 $ - 0.05 $ 4,086 94054230 61010 620 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 0.05 $ 2,924 94054230 61010 940 870 GD-04 SCALE HOUSE OPERATOR 0.00 $ - 0.00 $ - 0.20 $ 10,379 Total 0.00 $ - 0.00 $ - 0.35 $ 21,661 E-Scrap Recycling-Landfill Program-FT 94054240 61010 940 2625 GE-35 DMASWAADMINISTRATOR 0.03 $ 2,388 0.03 $ 2,526 0.15 $ 12,817 94054240 61010 940 2625 GE-33 LANDFILL SUPERVISOR 0.05 $ 3,923 0.05 $ 4,026 0.05 $ 4,086 94054240 61010 620 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 0.05 $ 2,924 LANDFILL EQUIP 94054240 61010 940 2948 GD-08 OPERATOR 0.00 $ - 0.35 $ 19,004 0.00 $ - 94054240 61010 940 870 GD-04 SCALE HOUSE OPERATOR 0.00 $ - 0.00 $ - 0.05 $ 2,595 94054240 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 0.35 $ 19,074 0.00 $ - 0.35 $ 19,672 Total 0.43 $ 25,385 0.43 $ 25,556 0.65 $ 42,094 DMASWA Rural Recycling Program-FT 94054250 61010 940 2625 GE-35 DMASWAADMINISTRATOR 0.02 $ 1,591 0.02 $ 1,684 0.10 $ 8,545 94054250 61010 620 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 0.02 $ 1,170 94054250 61010 940 2625 GE-33 LANDFILL SUPERVISOR 0.00 $ - 0.00 $ - 0.02 $ 1,635 Total 0.02 $ 1,591 0.02 $ 1,684 0.14 $ 11,350 DMASWA Gas Collection-FT 94054260 61010 940 2625 GE-35 DMASWAADMINISTRATOR 0.07 $ 5,571 0.07 $ 5,893 0.15 $ 12,817 94054260 61010 940 2625 GE-35 LANDFILL SUPERVISOR 0.10 $ 7,847 0.10 $ 8,053 0.10 $ 8,174 94054260 61010 620 2655 GD-11 FOREMAN 0.00 $ - 0.00 $ - 0.10 $ 5,849 94054260 61010 940 2300 GD-08 EQUIPMENT OPERATOR II 0.10 $ 5,397 0.00 $ - 0.00 $ - Total 0.27 $ 18,815 0.17 $ 13,946 0.35 $ 26,840 TOTAL PUBLIC WORKS DEPT. 92.09 $4,958,589 92.09 $5,015,351 91.96 $5,083,451 -126- Capital Improvement Projects by Department/Division PUBLIC WORKS CIP FY 16 Actual FY 17 Actual FY 18 Adopted FY 19 Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 1022541 MSC LED LIGHTING - 50,251 - - 1022718 JULE BUILDING CONVERSION - - 9,606 - 2501227 CURB RAMP PROGRAM 357,353 412,062 2501230 ASPHALT MILLING PROGRAM 1,649 68,928 53,202 - 2502223 LIQUID DEICER BLEND SYST - - 44,604 - 2502604 RADIO REPLACEMENT - - 23,156 - 2502630 RETRO CLEAN DIESEL PROJ 6,343 3001006 CONCRETE SECTION REPAIR 25,182 11,912 35,000 - 3001226 CURB REPLACEMENT PROGRAM 13,012 60,022 25,000 25,000 3001227 CURB RAMP PROGRAM 293,587 318,476 3001230 ASPHALT MILLING PROGRAM 95,838 32,636 52,544 103,595 3001432 STEPS,RAILINGS,FENCING 6,709 22,593 10,000 5,000 3001445 FLOODWALL POST FLOOD REPA - 4,565 25,000 25,000 3001839 AERIAL BUCKET TRUCK - - 125,876 - 3001936 ENDLOADERPURCHASES 178,000 3001938 DT SIGN POST REPLAC PROJ 15,886 9,977 40,000 - 3002038 PORT AMENITIES MAINT - 19,393 5,000 - 3002039 DUMP TRUCK REPLACEMENT 472,797 157,319 3002151 WAYFINDING SIGN REPLACE 476 3002221 TRUCK-MOUNTED NEW CONCEPT 98,355 19,000 3002225 MOBILE GIS SYSTEM 21,118 800 3002539 DUMP TRK REPLC 183,084 142,010 3002540 FLOODWALL MANHOLE INSTALL 25,680 3002541 MSC LED LIGHTING 18,060 10,068 3002604 RADIO REPLACEMENT 27,904 - 103,649 - 3002665 VEH REFUEL SYSTEM UPGRADE - 8,636 - - 3002717 POD IRRIGATION REPLACEMEN 10,000 10,000 3002719 SALT STORAGE BUILDING 354,500 305,085 3502480 PURINA DRIVE FLOODWALL 85,488 6701533 DUAL PACKER RECYCLE VEH 327,000 - 243,000 415,720 6702601 RADIO REPLACEMENT - - 58,410 - 7101341 SANITARY SEWER ROOT FOAM 24,248 20,482 30,000 30,000 7101840 SEWER PIPELINE INSPC EQUP - - 22,700 - 7102405 HIGH PRESSURE SEWER JET 216,645 7202155 FLOOD CONTROL LEVEE CERT 701 50,000 7202405 HIGH PRESSURE JETVAC 69,438 7202601 RADIO REPLACEMENT - - 9,735 - 7402630 RETRO CLEAN DIESEL PROJ 6,343 8102601 RADIO REPLACEMENT - - 12,980 - 9402631 LANDFILL CELL#9 PHASE 2 2,730,218 (16,811) 9402640 CELLS 4-8 CLOSURE 40,874 9402685 SHORT-TERM FACILITIES 101,458 148,308 PUBLIC WOR TAL 4,714,519 770,235 111111= 2,071,362 -127- PRGRM /DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE PUBLIC WORKS Public Works Curb Replacement Program $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 125,000 123 Floodwall Post-Flood Repair Program $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 125,000 124 Steps, Hand Railings and Wall-Top Fencing $ 5,000 $ 25,000 $ 25,000 $ 25,000 $ 25,000 $ 105,000 125 Asphalt Milling Program $ 103,595 $ 105,667 $ 105,102 $ 109,936 $ 112,135 $ 536,435 126 Curb Ramp Program $ 412,062 $ 420,304 $ 428,710 $ 437,284 $ 446,030 $2,144,390 127 Street Sign and Post Replacement $ - $ 16,756 $ 30,000 $ 30,000 $ 30,000 $ 106,756 128 Concrete Street Section Repair Program $ - $ 25,000 $ - $ 25,000 $ 25,000 $ 75,000 129 56,000 Gross Vehicle VVeight (GVW) Dump Truck Replacement $ 157,319 $ 320,930 $ - $ - $ - $ 478,249 130 35,000 GVW Dump Truck Replacement $ 142,010 $ - $ - $ 301,404 $ - $ 443,414 131 Truck-Mounted Snow Plows $ 19,000 $ - $ - $ - $ - $ 19,000 132 Purina Drive Storage Building $ 305,085 $ - $ - $ - $ - $ 305,085 133 Floodwall Replacement $ 85,488 $ - $ - $ - $ - $ 85,488 134 Port of Dubuque Irrigation Replacement $ 10,000 $ 10,000 $ - $ - $ - $ 20,000 135 Aerial Bucket Truck Replacement $ - $ 173,791 $ - $ - $ - $ 173,791 136 Hawthorne Street Boat Ramp Repair $ - $ 41,410 $ 333,300 $ - $ - $ 374,710 137 Vacuum Street Sweeper Replacement $ - $ - $ 210,000 $ 214,200 $ - $ 424,200 138 Wheel Loader Purchase $ - $ - $ 206,350 $ - $ - $ 206,350 139 Municipal Service Center CNG Retrofit $ - $ - $ 334,810 $ - $ - $ 334,810 140 Business Type Cab-Over Solid Waste Vehicles $ 415,720 $ 512,978 $ 596,260 $ 528,628 $ 540,800 $2,594,386 141 Sanitary Sewer Root Foaming $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 142 Flood Control Levee Repair $ 50,000 $ 200,000 $ - $ - $ - $ 250,000 143 JetVac $ 286,083 $ - $ - $ - $ - $ 286,083 144 Flood Control Units $ - $ - $ - $ 386,000 $ - $ 386,000 145 Total- Public Works $2,071,362 $1,931,836 $2,349,532 $2,137,452 $1,258,965 $9,749,147 -128-