Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
02 Budget Hearing Packet - Public Works
2020 BUDGET PRESENTATION DEPARTMENT OF PUBLIC WORKS AUGUST 7, 2019 PowerPoint Presentation ....................................................................................................................................................................... 1-41 Budget Summary Sheets .............................................................................................................................................................. 42-74 Engineering ................................................................................................................................................................................. 42-48 Fund 101– GENERAL FUND ............................................................................................................................................ 43 Fund 227–LOSS RECOVERY FUND ............................................................................................................................. 44 Fund 251–LOCAL ROADS & STREETS ........................................................................................................................ 45 Fund 257–LOIT SPECIAL DISTRIBUTION ................................................................................................................ 46 Fund 265–LOCAL ROAD & BRIDGE GRANT ........................................................................................................... 47 Fund 412–MAJOR MOVES CONSTRUCTION ........................................................................................................ 48 Solid Waste ........................................................................................................................................................................ 49-51 Fund 610– SOLID WASTE OPERATIONS .................................................................................................................. 50 Fund 611–SOLID WASTE CAPITAL ............................................................................................................................. 51 Sustainability & AmeriCorps ........................................................................................................................................ 52-54 Fund 101-GENERAL FUND....................................................................................................................................... 53-54 Streets & Sewers ...................................................................................................................................................................... 55-59 Fund 202– MOTOR VEHICLE HIGHWAY ................................................................................................................. 56 Fund 266–MVH RESTRICTED FUND .......................................................................................................................... 57 Fund 640–SEWER REPAIR INSURANCE ................................................................................................................... 58 Fund 655–PROJECT RELEAF .......................................................................................................................................... 59 Utilities – Water Works ........................................................................................................................................................ 60-66 Fund 620– WATER WORKS OPERATIONS .............................................................................................................. 61 Fund 622–WATER WORKS CAPITAL ......................................................................................................................... 62 Fund 624–WATER WORKS CUSTOMER DEPOSIT .............................................................................................. 63 Fund 625–WATER WORKS SINKING (DEBT SERVICE) ..................................................................................... 64 Fund 626–WATER WORKS BOND RESERVE ......................................................................................................... 65 Fund 629–WATER WORKS RESERVE OPERATIONS & MAINTENANCE .................................................. 66 Utilities – Wastewater .......................................................................................................................................................... 67-74 Fund 641–SEWAGE WORKS OPERATIONS ............................................................................................................ 68 Fund 642–SEWAGE WORKS CAPITAL ...................................................................................................................... 69 Fund 643–SEWAGE WORKS RESERVE OPERATIONS & MAINTENANCE ............................................... 70 Fund 649–SEWAGE SINKING (DEBT SERVICE) ..................................................................................................... 71 Fund 653–SEWAGE DEBT SERVICE RESERVE ....................................................................................................... 72 Fund 654–SEWAGE WORKS CUSTOMER DEPOSIT ........................................................................................... 73 Fund 667–STORM SEWER FUND ................................................................................................................................. 74 Staffing Summary ........................................................................................................................................................................... 75-78 Line Level Budget Detail .............................................................................................................................................................. 79-96 CITY OF SOUTH BEND, IN Common Council 2020 Budget Hearing #2 Department of Public Works August 7, 2019 CITY OF SOUTH BEND, IN WE BUILD THE FOUNDATION FOR A THRIVING CIT Y PUBLIC WORKS MISSION We accomplish this mission by: 1. Providing essential household services 2. Developing sustainable assets and infrastructure 3. Enhancing the community’s quality of life 1 CITY OF SOUTH BEND, IN PUBLIC WORKS ORGANIZATION EXECUTIVE ASSISTANT LINDA MARTIN DEPUTY DIRECTOR SUSTAINABILITY DIRECTOR THERESE DORAU STREETS & SEWERS DIRECTOR SEAN WARD ENGINEERING CITY ENGINEER KARA BOYLES UTILITIES DIRECTOR AL GREEK SOLID WASTE DIRECTOR KELLY SMITH DIRECTOR ERIC HORVATH DIRECTOR OF MARKETING CARA GRABOWSKI CITY OF SOUTH BEND, IN WHAT WE DO •1,262 driving lane miles •29,200 tons of trash annually •700 miles of sewers •580 miles of water main •160 signalized intersections and 3,000 streetlights •10,000 catch basins, inlets and drains •398 miles of alleys •13,000 tons of leaves, brush and yard waste collected •4,800 fire hydrants 2 CITY OF SOUTH BEND, IN ENGINEERING Manages the development and expansion of our city’s infrastructure. Oversees Public Works projects from setting the standards to issuing the permits, administering the contracts, and inspecting construction. CITY OF SOUTH BEND, IN Organizational Chart Kara Boyles City Engineer Roger Nawrot Assistant City Engineer TRAFFIC Jacob Klosinski Assistant City Engineer WASTEWATER Sue Ellen Doudrick Assistant City Engineer Kyle Silveus Assistant City Engineer REDEVELOPMENT Kieran Fahey Director, LTCP Toy Villa Construction Manager 3 CITY OF SOUTH BEND, IN 2020 Engineering Goals •Improve communication •Both internal and external communication •Reduce emails •Schedule "needed" meetings only •More community outreach •Initiate 2020 Projects upon Budget approval •Identify project needs in 2019 •Execute PSAs with BPW in early 2020 •Document and develop policies and procedures •Document existing procedures •Create SOP manual •Develop standard method for Project organization/notes CITY OF SOUTH BEND, IN 2020 Budget Overview •Engineering 2017 Actual 2018 Actual 2019 Budget (Original) 2020 Proposed Budget Year Over Year Variance ($) Year Over Year Variance (%) Revenue Property Taxes ---- -0.0% Local Income Taxes ---- -0.0% Charges for Services - - 50 -(50)-100.0% Other Revenue 4,264,514 4,154,285 3,682,060 3,739,387 57,327 1.6% Interest Earnings 95,563 177,817 74,000 22,233 (51,767)-70.0% Transfers In 1,000,000 1,624,500 3,100,000 1,000,000 (2,100,000)-67.7% Interfund Allocation Reimb - - 1,400,059 1,436,881 36,822 2.6% Debt Proceeds ---- -0.0% Total Revenue 5,360,076 5,956,602 8,256,169 6,198,501 (2,057,668)-24.9% Expenditures Salaries & Wages 541,662 651,541 1,807,736 1,841,018 33,282 1.8% Fringe Benefits 189,958 247,411 558,778 617,268 58,490 10.5% Professional Services 414,001 596,007 920,000 1,340,000 420,000 45.7% Repairs & Maintenance 1,657,696 3,160,371 1,877,500 2,676,500 799,000 42.6% Supplies 479,538 568,930 274,450 273,100 (1,350)-0.5% Debt Service 29,227 21,289 15,045 10,949 (4,096)-27.2% Other Expenses 131,990 525,853 262,215 79,050 (183,165)-69.9% Transfers Out 1,000,000 1,624,500 600,000 1,000,000 400,000 66.7% Other Interfund Allocations 254,496 344,631 365,366 420,075 54,709 15.0% Operating Expenditures 4,698,568 7,740,533 6,681,090 8,257,960 1,576,870 23.6% Operating Income 661,508 (1,783,931)1,575,079 (2,059,459) Capital 1,410,272 1,362,372 4,750,000 400,000 (4,350,000)-91.6% Rev in Excess of Exp (748,764) (3,146,303) (3,174,921) (2,459,459) 4 CITY OF SOUTH BEND, IN 2020 Capital Projects Department of Public Works CITY OF SOUTH BEND, IN Traffic Calming •Description: •Traffic calming has become a common term for addressing a wide range of citizen concerns. The primary objective of traffic calming is to create safer streets and increase the quality of life for the neighborhoods within our City. •Public Works Duties: •Managing Design, Procurement and Inspection •Cost: $400,000 •Funding: LRSA 5 CITY OF SOUTH BEND, IN Traffic Calming –2019 Accomplishments •2019 Budget ($250,000) •Longfellow Avenue •3 Permanent speed humps - $43,710 •900 Block of Riverside Drive •2 Permanent speed humps - $29,140 •Temporary Traffic Calming Materials & Installation •3 locations (2 on 1000-1100 blocks of Riverside Drive and 1 near Madison School) - $67,350 •Hudson & Riverside Drive •Traffic Circle - $35,000 (estimated) •Walnut Grove Neighborhood •3 Permanent speed humps - $45,000 (estimated) •700/800 Block N. Riverside Drive 2 Permanent speed humps - $30,000 (estimated) CITY OF SOUTH BEND, IN Traffic Calming –Looking Ahead to 2020 •Plan to employ a variety of traffic calming measures: •Chicanes •Speed Humps •Traffic Circles •Radar Speed Feedback Signs •Residential Speed Limit Zones •Targeted areas: •Monroe Park Neighborhood •Northeast Neighborhood •Near West Side Neighborhood •Lincoln Way West Gateway •Rum Village Neighborhood •Miami Street & Ridgedale Road 6 CITY OF SOUTH BEND, IN Light Up South Bend •Description: •Annual partnering program with I&M Power Co. to install additional street lights in neighborhoods throughout South Bend •Lamppost Program to install residential lamppost lights (solar) •Public Works Duties: •Selecting Locations, Coordinating Installation with I&M Power •Administering Lamppost Program – procuring and distributing lampposts to residents •Budget: $200,000 •Funding: COIT CITY OF SOUTH BEND, IN Curb and Sidewalk •Description: •Annual program to replace sidewalks, curbs, and curb ramps in poor condition at residential properties throughout the City. •City Council members select the locations and they are reviewed by Engineering for bidding as a public works project. •Public Works Duties: •Managing Design, Procurement, and Inspection •Budget: $500,000 (2020 Letting) •Funding: MVH 7 CITY OF SOUTH BEND, IN Community Crossing –City Paving •Description: •Community Crossings Matching Grant project includes pavement reconstruction - asphalt milling and resurfacing and curb ramps •Public Works Duties: •Managing Design, Procurement, and Inspection •Cost: $2,000,000 (2020 Letting) •Funding: 265 Local Road and Bridge Matching Grant •Revenue: $1,000,000 State of Indiana/$1,000,000 LRSA CITY OF SOUTH BEND, IN Bendix Drive Pavement Replacement •Description: •Road reconstruction along Bendix Drive from Lathrop Road to the south end of the bridges over the Indiana Toll Road •Public Works Duties: •Managing Design, Procurement, and Inspection •Construction Cost Estimate: $4,816,000 (2020 Letting) •Funding: LRSA (20% Local Match) with Transfer In from EDIT •City’s Obligation: $2.5M including CE 8 CITY OF SOUTH BEND, IN CCorby, Ironwood & Rockne Intersection Improvement •Description: •Intersection improvement consisting of reconstruction of the existing signalized intersection •Public Works Duties: •Managing Design, Procurement, and Inspection •Construction Cost Estimate: $3,600,000 (2020 Letting) •Funding: Major Moves (20% Local) •City’s Obligation: $1.2M including CE CITY OF SOUTH BEND, IN Olive Street Pavement Replacement •Description: •Road Reconstruction from Prairie Avenue (State Road 23) North to Tucker Drive •Public Works Duties: •Managing Design, Procurement, and Inspection •Cost: Estimated $4,200,000 (2020 Letting) •Funding: Local Share TBD - $2M Federal Grant 9 CITY OF SOUTH BEND, IN Cleveland Road Pavement Replacement •Description: •Concrete pavement replacement near the intersection of Cleveland Road and Ameritech Drive, near the entrance to the heavily-traveled Portage Prairie industrial park •Public Works Duties: •Managing Design, Procurement, and Inspection •Cost: Estimated $1,667,000 (2020 Letting) •Funding: River West TIF Development Area CITY OF SOUTH BEND, IN Prairie Avenue Water Main Extension •Description: •Water main extension to Four Winds Casino and looping the existing system •Boring under US 31/US 20 •New customers along SR 23 •Easement acquisitions •Public Works Duties: •Managing Design, Procurement, and Inspection •Cost: Estimated $1.8M (2020 Letting) •Funding: SSDA TIF, Water Capital, Pokagon Donation 10 CITY OF SOUTH BEND, IN North Station •Description: •The list of upgrades and replacements includes: •the outdated chlorine gas system •scrubber chemical •filter media •raw water piping •dehumidification system •HVAC compressors •outdated PLCs •high service pumps •Public Works Duties: •Managing Study, Design, Procurement and Inspection •Budget: $950K (2019) and $672K (2020) •Funding: RWDA TIF and Water Capital CITY OF SOUTH BEND, IN Pinhook Filtration •Description: •Potential project elements include: •Replacement of electronic actuator valves •Replacement of filter underdrains •Control panel and motor upgrades •Air handling system upgrades •Building roof repairs •Public Works Duties :Managing Design, Procurement, and Inspection •Budget: $2M (2019 and 2020 Budgets) •Funding: Water Capital 11 CITY OF SOUTH BEND, IN Booster Pump Stations •Description: •Locust Booster ($80K) •Topsfiled Booster ($31K) •Winterberry Booster ($95K) •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $205,000 •Funding: Water Capital CITY OF SOUTH BEND, IN Edison Filtration Plant Roof Replacement •Description: •Full replacement of exterior roof with newly coated truss support system. •Installation of ventilation system for each room. •Public Works Duties: Project Management, Design Review, and Construction Inspection •Cost: $630,000 (2019 Budget) •Funding: Building Improvements 12 CITY OF SOUTH BEND, IN Water Meter Replacement •Description: •The water system contains approximately 43,000 water meters in the system. The current meters are past their shelf life. •Aging meters can contribute to major recording errors and revenue loss. •Annual costs are based on a 15-year replacement schedule for all meters. •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $800,000 •Funding: Water Capital CITY OF SOUTH BEND, IN Stormwater •Description: •Stormwater focused projects for studies and improvements of stormwater infrastructure. •Downspout Disconnection Program •Street Drainage Corrections •Stormwater Study •DSSMR for South Bend Dam •Miscellaneous Drainage Repairs •Public Works Duties: •Managing Study, Design, Procurement and Inspection •Cost: $495,000 •Funding: 667 Stormwater 13 CITY OF SOUTH BEND, IN St. Joseph Riverbank Stabilization •Description: •Spring 2019 Feasibility Study – conceptual bank stabilization treatment alternatives •Fall/Winter 2019 Design Phase – development of construction documents and application for IDNR LARE Construction funding •Public Works Duties: •Managing Design, Procurement and Inspection •IDNR LARE Grant Applications & Coordination •Cost: •Feasibility Study – Spring 2019: $40,000 ($8,000 local match) •Design Phase - Fall/Winter 2019: $50,000 ($10,000 local match) •Construction Estimate: $300,000 (2020/2021, pending funding) •Funding: Indiana Department of Natural Resources Division of Fish & Wildlife Lake and River Enhancement Grant Program (80/20 local match) CITY OF SOUTH BEND, IN WWTP Upgrades –Final Clarifiers 1 -5 •Description: •Structural Concrete Repairs and Tank Coatings •Replace scrapper mechanism, bridges, drive assemblies and handrail; rehabilitate weirs •Raise Final Clarifier 1-3 Influent Walls •Public Works Duties: •Manage design and construction activities •Construction observation and field inspections •Cost: $4.1M - $5.3M •Funding: Sewage Works Capital (Fund 642) 14 CITY OF SOUTH BEND, IN WW TP Upgrades Aeration Basins 1-4 •Description: •Replace Pass 1-2 Gates, Provide new stop log frame and stop logs for east aeration tank influent channel isolation. •Lengthen Effluent Weirs •Demolish old equipment and piping at tanks and in Aeration Gallery tunnel. •Public Works Duties: •Project Management, Design Review •Construction Observation and Field Inspection •Cost: $520,000 to $600,000 •Funding: Sewage Works Capital (Fund 642) CITY OF SOUTH BEND, IN WW TP Upgrades Disinfection Building •Description: •Replace chlorine and sulfur dioxide distribution systems; evaporators and scrubber system •Programmable logic controller and SCADA upgrades •Public Works Duties: •Project Management, Design Review •Construction Observation and Field Inspection •Cost: $1.6 Million to $2.2 Million •Funding: Sewage Works Capital (Fund 642) 15 CITY OF SOUTH BEND, IN Douglas Road Lift Station Relocation •Description: •Relocate Douglas Road Lift Station due to the impact of the St. Joseph County Douglas Road Widening project •Provide new wet wells, submersible pumps, control panel and sanitary force main •Public Works Duties: •Project Management, Design Review •Construction Observation and Field Inspection •Cost: Est. $2.2 Million •Funding: TBD CITY OF SOUTH BEND, IN Colfax Lift Station •Description: •Due to the increased development in the East Bank area, including the new Cascade condominiums and the Commerce Center mixed-use development, the existing lift station near the Colfax Avenue bridge over the river will be upgraded to handle the additional capacity required to serve these new buildings. •Public Works Duties: •Managing Design, Procurement and Inspection •Cost: Estimated $500,000 •Funding: River East Development Area TIF 16 CITY OF SOUTH BEND, IN Sheridan and Sample Intersection •Description: •Includes signal modification, changes to the intersection geometry, paving, curb, sidewalks, curb ramps, pavement markings, and storm sewer installation •Public Works Duties: •Managing Design, Procurement and Inspection •Cost: Estimated $477,000 •Funding: River West Development Area TIF CITY OF SOUTH BEND, IN Sheridan Avenue •Description: •Includes the replacement of pavement, curb, approaches and storm sewer installation along Sheridan Avenue from Lincolnway West to Progress Drive. •Public Works Duties: •Managing Design, Procurement and Inspection •Cost: Estimated $2,200,000 •Funding: River West Development Area TIF Progress Drive Terminal Drive 17 CITY OF SOUTH BEND, IN Downtown Cross Streets •Description: •Includes streetscape improvements along Washington Street and Jefferson Blvd between Main Street and Michigan Street •Public Works Duties: •Managing Design, Procurement and Inspection •Cost: Estimated $1,500,000 •Funding: River West Development Area TIF CITY OF SOUTH BEND, IN School Zone Safety •Description: •The City, in partnership with the SBCSC, strives to provide safe passage for children to travel to and from schools. •Review and recommend improvements for traffic and pedestrian movements around schools •Public Works Duties: Gathering Data, Field Observation, Project Management •Cost: ~$100,000 •Funding: TBD (shared with SBCSC) 18 CITY OF SOUTH BEND, IN School Zone Flashing Beacons •Description: •Installation of school zone flashing beacons at 39 school properties within City limits. •Public Works Duties: Project management, design review, procurement, and inspection. •Cost: Federal Contribution is $600,000 (Letting in 2022) •Funding: (90/10) TBD CITY OF SOUTH BEND, IN Pinhook Park Improvements •Description: •Trail and Access Improvements •Playground Improvements •Boat and Kayak Launch Improvements •Pinhook Pavilion Internal Improvements •Public Works Duties: •Managing Design, Procurement and Inspection •Budget: $1,500,000 (Fall 2019 Bid) •Funding: Park Bond 19 CITY OF SOUTH BEND, IN Morris Theater Plaster Ceiling Work •Description: •Remedial repairs to the decorative plaster wrapping the base of each of 4 domes in the ceiling of the Morris Performing Arts Center theater •Public Works Duties: •Managing Design, Procurement and Inspection •Construction Cost Estimate: $200,000 - $250,000 depending on plaster condition(Fall 2019 Re-Bid) •Funding: Morris Performing Arts Center Capital CITY OF SOUTH BEND, IN Muessel Grove Public Restroom •Description: •Renovate existing public restroom building •Public Works Duties: •Managing Design, Procurement and Inspection •Construction Cost Estimate: $350,000 (Fall 2019 Re-Bid) •Funding: VPA (TBD) 20 CITY OF SOUTH BEND, IN Fire Stations 3 & 6 Renovations •Description: •Station 3: •Concrete drive & Apparatus Bay concrete replacement •Bathroom remodel and plumbing replacement •New electric panel and service & HVAC upgrade •Strip and polish flooring throughout station •Kitchen gut and remodel •Station 6: •Renovate restrooms to private single with shower, sink and toilet •Reconfigure entrance to bathroom/locker & top of stairs areas •Provide carpeting for bedroom area •Replace upstairs windows for energy efficiency •Public Works Duties: •Managing Design, Procurement and Inspection •Construction Cost Estimate: $800,000 (Fall 2019 Bid) •Funding: Fire Department Capital CITY OF SOUTH BEND, IN SOLID WASTE Provides exceptional waste management services for residents through weekly trash, yard waste and bulky items pickup. 21 CITY OF SOUTH BEND, IN Organizational Chart Kelly Smith Director Ernest Taylor Superintendent V Darryl Biggs Superintendent V CITY OF SOUTH BEND, IN 2020 Solid Waste Goals •Decrease truck maintenance costs •Decrease hourly/overtime costs •Decrease contamination in yard waste •Implement new branding 22 CITY OF SOUTH BEND, IN 2020 Budget Overview •Solid Waste 2017 Actual 2018 Actual 2019 Budget (Original) 2020 Proposed Budget Year Over Year Variance ($) Year Over Year Variance (%) Revenue Property Taxes - - - - - 0.0% Local Income Taxes - - - - - 0.0% Charges for Services 5,346,176 5,408,816 5,402,500 5,404,450 1,950 0.0% Other Revenue 74,536 77,030 101,200 12,700 (88,500)-87.5% Interest Earnings 4,960 11,395 12,300 588 (11,712)-95.2% Transfers In 778,600 1,004,039 1,132,616 1,231,349 98,733 8.7% Interfund Allocation Reimb - - - - - 0.0% Debt Proceeds - - - - - 0.0% Total Revenue 6,204,271 6,501,280 6,648,616 6,649,087 471 0.0% Expenditures Salaries & Wages 1,071,780 1,067,278 1,110,697 1,132,274 21,577 1.9% Fringe Benefits 554,259 502,791 467,437 518,320 50,883 10.9% Professional Services 115,208 - - - - 0.0% Repairs & Maintenance 830,841 972,796 660,000 720,000 60,000 9.1% Supplies 233,123 277,367 375,200 424,500 49,300 13.1% Debt Service 1,076,141 1,002,470 1,132,616 1,231,349 98,733 8.7% Other Expenses 924,955 898,388 769,550 1,066,850 297,300 38.6% Transfers Out 778,600 1,004,039 1,132,616 1,231,349 98,733 8.7% Other Interfund Allocations 596,856 851,115 998,406 963,421 (34,985)-3.5% Operating Expenditures 6,181,764 6,576,245 6,646,522 7,288,063 641,541 9.7% Operating Income 22,508 (74,964)2,094 (638,976) Capital ---- -0.0% Rev in Excess of Exp 22,508 (74,964)2,094 (638,976) CITY OF SOUTH BEND, IN Operating Budget –Highlights & Changes •Need rate increase to support ongoing operations •Reduction in Energy rebate revenue •Health insurance increase of 19.6% •Increase costs of Yard Waste program •2018 - 52% participation in yard waste program •2019 – 61% participation •Requires additional totes, overtime, & benefits •Auto equipment repair & maintenance increase - mirrors current experience. •Disposal Cost adjusted to be more realistic with current cost trend and includes 3% increase in 2020. •Interfund Allocations increased by 42.5% in 2018 and 17.3% in 2019 which is an increase of 67% in two years. 23 CITY OF SOUTH BEND, IN 2020 Solid Waste Capital •$300,000 – New route and camera system with GPS tracking •$10,000 - Used Bobcat loader – remove trash from yard waste •$365,000 – New truck – Replace truck 569/2011 CITY OF SOUTH BEND, IN SUSTAINABILITY Prepares for the impacts of climate change in the community by incorporating sustainability into awareness, culture and common practice of South Bend businesses and residents. It has also created a culture of sustainability as “business as usual” across all municipal operations. 24 CITY OF SOUTH BEND, IN Organizational Chart Sustainability Director Therese Dorau AmeriCorps Program Director Amber Werner CITY OF SOUTH BEND, IN Sustainability Office Goals Create a culture of sustainability as “business as usual” across all municipal operations Incorporate sustainability into awareness, culture, and common practice of South Bend businesses and residents Prepare for impacts of climate change in the community Reduce the community’s greenhouse gas emissions To comply with Global Covenant of Mayors and Common Council Climate Resolution 25 CITY OF SOUTH BEND, IN 2020 Budget Overview •Sustainability & AmeriCorps 2017 Actual 2018 Actual 2019 Budget (Original) 2020 Proposed Budget Year Over Year Variance ($) Year Over Year Variance (%) Revenue Property Taxes ---- -0.0% Local Income Taxes -----0.0% Charges for Services -----0.0% Other Revenue - 69,005 149,130 177,238 28,108 18.8% Interest Earnings -----0.0% Transfers In -- 120,000 70,000 (50,000)-41.7% Interfund Allocation Reimb -----0.0% Debt Proceeds -----0.0% Total Revenue - 69,005 269,130 247,238 (21,892)-8.1% Expenditures Salaries & Wages 145,032 166,402 193,302 372,974 179,672 92.9% Fringe Benefits 57,548 63,938 67,838 87,861 20,023 29.5% Professional Services 16,130 20,978 313,368 234,051 (79,317)-25.3% Repairs & Maintenance -----0.0% Supplies 143 264 78,890 73,000 (5,890)-7.5% Debt Service ---- -0.0% Other Expenses 4,385 11,426 26,167 38,250 12,083 46.2% Transfers Out -----0.0% Other Interfund Allocations 33,396 58,667 32,367 9,764 (22,603)-69.8% Operating Expenditures 256,633 321,677 711,932 815,900 103,968 14.6% Operating Income (256,633) (252,672) (442,802) (568,662) Capital ---- -0.0% Rev in Excess of Exp (256,633) (252,672) (442,802) (568,662) CITY OF SOUTH BEND, IN Operating Budget –Highlights & Changes •Significant Budget Changes •Revenue increase – successful reapplication to Serve Indiana increased AmeriCorps program match •Revenue decrease – AmeriCorps program funding less reliant on support from Utilities after start-up year •Salaries and Wages – move AC stipends from Prof Svcs to Temp/Intern •Professional Services •Move AC stipends •Create work plans for 2/5 of Climate Action Plan strategies •Assess systems/populations vulnerable to changes in climate •Personnel •Increase salary cap for AmeriCorps Operations Manager to more competitively recruit/retain 26 CITY OF SOUTH BEND, IN Business Education Reduce one-use plastics (SBGC) Less trash at events (SBGC) Regional Green Drinks Pipe Insulation (SBGC) Electric Vehicle Charging Conservatory (SBGC)Food Rescue (SBGC)Kid’s Education (SBGC) CITY OF SOUTH BEND, IN STREETS & SEWERS We maintain the foundation that keeps the city moving. 27 CITY OF SOUTH BEND, IN Organization Chart Sean Ward Director Pete Kaminski Street Manager Larry Parker Sewer Manager Traffic & Lighting Manager CITY OF SOUTH BEND, IN 2020 Department Goals •Pave 20 lane miles through own forces •Maintain 2019 level of Curb & Sidewalk program •Crack Seal 50 lane miles •Implement CityWorks in Streets division 28 CITY OF SOUTH BEND, IN 2020 Budget Overview •Streets 2017 Actual 2018 Actual 2019 Budget (Original) 2020 Proposed Budget Year Over Year Variance ($) Year Over Year Variance (%) Revenue Property Taxes ---- -0.0% Local Income Taxes ---- -0.0% Charges for Services 232,443 246,361 228,245 229,670 1,425 0.6% Other Revenue 6,097,891 6,927,341 6,304,113 6,087,800 (216,313)-3.4% Interest Earnings 61,002 137,767 47,845 30,447 (17,398)-36.4% Transfers In 3,964,974 3,814,963 3,787,750 4,613,703 825,953 21.8% Interfund Allocation Reimb -- 138,150 149,020 10,870 7.9% Debt Proceeds ---- -0.0% Total Revenue 10,356,311 11,126,434 10,506,103 11,110,640 604,537 5.8% Expenditures Salaries & Wages 2,580,742 2,885,203 3,226,146 3,283,216 57,070 1.8% Fringe Benefits 1,230,730 1,351,638 1,266,423 1,370,053 103,630 8.2% Professional Services 854,940 670,422 540,468 549,014 8,546 1.6% Repairs & Maintenance 1,245,145 1,679,173 1,093,368 1,086,834 (6,534)-0.6% Supplies 1,721,517 1,701,021 2,934,307 2,618,515 (315,792)-10.8% Debt Service 712,623 756,530 925,627 770,072 (155,555)-16.8% Other Expenses 144,302 146,960 231,330 203,734 (27,596)-11.9% Transfers Out -- 2,500,000 250,000 (2,250,000)-90.0% Other Interfund Allocations 853,056 1,018,733 1,628,279 1,538,377 (89,902)-5.5% Operating Expenditures 9,343,054 10,209,680 14,345,948 11,669,815 (2,676,133)-18.7% Operating Income 1,013,256 916,753 (3,839,845) (559,175) Capital 26,795 27,868 ---0.0% Rev in Excess of Exp 986,461 888,885 (3,839,845) (559,175) CITY OF SOUTH BEND, IN Operating Budget –Highlights & Changes •Curb & Sidewalk at 2019 funding levels •Added 2 new tiers to reimbursement program in 2019 •Will review reimbursement program for 2020 •No Safe Routes to Schools funding in 2020 •Street resurfacing funded $1M less than 2019 •Olive Street local share is not budgeted •Continued investment in road preservation program through enhanced level of crack sealing 29 CITY OF SOUTH BEND, IN UTILITY We sustain well being through essential water services and accomplish this by: 1.Providing Water for South Bend’s people and places 2.Treating Wastewater to protect our people and waterways 3.Developing and instituting sustainable solutions CITY OF SOUTH BEND, IN Organization Chart Al Greek Director of Utilities Kim Thompson Assistant Director of Utilities Sheila Enos Administrative Assistant Brad VanOosterum Water Treatment Operations Manager Shawn McCubbin Director of Customer Service & Billing Michelle Smith Lab & Water Quality Director Scott Horvath Operations Manager Water Distribution Andrea Alexander Manager of Environmental Compliance Mark Rzepnicki Director of Utility Safety Nancy Clay Operations Manager WWTP Ken Smith Director of Wastewater Maintenance Richard Radcliff Operations Manager (CSO Area) Lauren Trapp Industrial Pretreatment Manager Brent Hussung Director of SCADA 30 CITY OF SOUTH BEND, IN 2020 Utilities Goals •Capital asset plans for water and wastewater treatment, pumping, linear assets (pipes & valves), and wellfields •Drinking Water Risk and Resiliency Program, as required by 2018 Water Infrastructure Act •Purchase of hydro-excavator for increased maintenance of sewer and appurtenances •Key Performance Indicators •100% Compliance with NPDES permit •100% Compliance with Safe Drinking Water •Zero Dry Weather Combined Sewer Overflows •90% or greater CSO Emnet uptime •95% or greater water service orders completed on time CITY OF SOUTH BEND, IN 2020 Budget Overview •Utilities – Water Works 2017 Actual 2018 Actual 2019 Budget (Original) 2020 Proposed Budget Year Over Year Variance ($) Year Over Year Variance (%) Revenue Property Taxes ---- -0.0% Local Income Taxes -----0.0% Charges for Services 13,658,131 15,614,014 19,042,730 19,519,036 476,306 2.5% Other Revenue 87,373 33,509 63,200 47,500 (15,700)-24.8% Interest Earnings 108,081 202,882 170,000 155,000 (15,000)-8.8% Transfers In 2,224,554 2,156,131 5,576,041 5,983,486 407,445 7.3% Interfund Allocation Reimb 1,613,364 1,390,950 1,734,889 1,788,327 53,438 3.1% Debt Proceeds -----0.0% Total Revenue 17,691,502 19,397,486 26,586,860 27,493,349 906,489 3.4% Expenditures Salaries & Wages 3,460,112 3,495,419 3,608,115 3,665,888 57,773 1.6% Fringe Benefits 1,692,283 1,684,791 1,428,992 1,526,296 97,304 6.8% Professional Services 1,374,922 1,384,945 2,179,580 2,600,930 421,350 19.3% Repairs & Maintenance 358,530 359,337 381,700 390,200 8,500 2.2% Supplies 1,231,737 1,319,059 1,728,743 1,684,010 (44,733)-2.6% Debt Service 2,231,491 715,453 2,434,920 2,239,028 (195,892)-8.0% Other Expenses 1,964,385 2,014,189 2,901,770 2,441,295 (460,475)-15.9% Transfers Out 4,010,478 3,886,962 7,298,665 7,682,928 384,263 5.3% Other Interfund Allocations 1,350,528 1,339,518 1,979,352 2,190,893 211,541 10.7% Operating Expenditures 17,674,466 16,199,674 23,941,837 24,421,468 479,631 2.0% Operating Income 17,036 3,197,812 2,645,023 3,071,881 Capital 445,099 512,295 3,766,000 3,142,000 (624,000)-16.6% Rev in Excess of Exp (428,063)2,685,517 (1,120,977) (70,119) 31 CITY OF SOUTH BEND, IN Utility –Personnel Changes •Distribution Records Drafter to Manager of Distribution Services and Records – increase to $52,000 •Transition of an existing position to better suit the current needs of the water distribution system operation. This will involve purchasing of goods and services, management of water system tap applications, and revisions to utility maps. •Operations Manager to Director of Distribution - increase to $80,000 •24/7 operation and emergency response to 500 miles of distribution pipes delivering clean water to 40,000 service locations. Oversight of 26 bargaining employees, and 3 managers. Current salary has made it a challenge to identify and recruit a qualified candidate. CITY OF SOUTH BEND, IN Operating Budget –Highlights & Changes •Slight reduction in supplies line – mostly due to rollover purchaseorders •Professional services is down from 2019 amended budget but up from the 2019 original budget •Reduction in forecasted debt service is largely due to the final pay off of Vehicle Equipment Lease # 149 in 2021 & #158 in 2022. Leases were for water meter purchases – now built into ongoingcapital requirement •Decrease in Other Services & Charges is attributed to the 2019 Budget including capital for the New Utility Billing Software. 32 CITY OF SOUTH BEND, IN Operating Budget –Highlights & Changes •Transfers Out provide the funding for annual debt service payments, capital expenditures, additional O&M cash reserves, and for payment in lieu of tax.. •2020-2024 Interfund Transfer In budget includes $800,000 annually for Water Meters replacement •Significant Capital Spending in 2020: •- North Station Filtration Plant Rehabilitation $672,000 •- Pinhook Filtration Plant Rehabilitation $ 771,000 CITY OF SOUTH BEND, IN 2020 Budget Overview •Utilities – Wastewater 2017 Actual 2018 Actual 2019 Budget (Original) 2020 Proposed Budget Year Over Year Variance ($) Year Over Year Variance (%) Revenue Property Taxes ---- -0.0% Local Income Taxes ---- -0.0% Charges for Services 39,314,218 40,291,820 39,783,810 41,118,752 1,334,942 3.4% Other Revenue 541,989 98,616 51,432 50,784 (648)-1.3% Interest Earnings 336,455 681,329 523,725 369,927 (153,798)-29.4% Transfers In 13,657,674 13,088,259 13,064,676 15,844,015 2,779,339 21.3% Interfund Allocation Reimb -- 421,463 446,759 25,296 6.0% Debt Proceeds ---- -0.0% Total Revenue 53,850,336 54,160,024 53,845,106 57,830,237 3,985,131 7.4% Expenditures Salaries & Wages 5,104,480 5,261,016 5,260,954 5,351,696 90,742 1.7% Fringe Benefits 2,241,637 2,340,913 1,967,878 2,095,979 128,101 6.5% Professional Services 1,348,986 1,383,933 1,867,000 1,617,000 (250,000)-13.4% Repairs & Maintenance 2,313,087 1,580,483 2,290,363 2,435,436 145,073 6.3% Supplies 1,542,303 1,781,313 2,257,600 2,237,726 (19,874)-0.9% Debt Service 9,938,391 9,844,542 8,373,594 8,325,031 (48,563)-0.6% Other Expenses 4,851,629 4,013,777 4,456,928 4,137,335 (319,593)-7.2% Transfers Out 18,430,082 17,937,462 18,235,944 20,819,451 2,583,507 14.2% Other Interfund Allocations 3,394,488 3,869,504 5,846,594 5,776,939 (69,655)-1.2% Operating Expenditures 49,165,083 48,012,943 50,556,855 52,796,593 2,239,738 4.4% Operating Income 4,685,253 6,147,081 3,288,251 5,033,644 Capital 4,270,370 2,291,171 7,520,000 8,486,000 966,000 12.8% Rev in Excess of Exp 414,883 3,855,909 (4,231,749) (3,452,356) 33 CITY OF SOUTH BEND, IN Operating Budget –Highlights & Changes •Personnel expenditures includes 2% salary increases. Change in the accounting of shared staffing costs. •Transfers Out includes: interfund transfers to the Sewage Works Sinking Fund (649) to fund debt service payments on bonds and interfund transfers to the Sewage Works Capital Fund (642) to fund capital expenditures. •Sewer project capital includes sewer lining rehabilitation and LTCP expenditures(detailed earlier) CITY OF SOUTH BEND, IN 2020 Special Initiatives Department of Public Works 34 CITY OF SOUTH BEND, IN Customer Assistance Program (CAP) •CAP Committee: •Kicked off November 2018 •Reviewed affordability, various approaches for assistance, methods of funding, etc. •Partnership with Real Services: •Area Agency on Aging, Community Action Agency (Energy Assistance Program) •Engaged with to better understand the need in our community •Established a partnership for program enrollment and qualification •Proposed Program: •Monthly Impact/Surcharge (for all ratepayers): $1.75 •Proposed Monthly Credit (for eligible low-income customers): •100% (60% State MHI): $10 +$1.75 = $$11.75 •75% (60% State MHI): $14 + $1.75 = $$15.75 •50% (60% State MHI): $19 + $1.75 = $$20.75 •Funding: Rate funded – revenue neutral CITY OF SOUTH BEND, IN Long-Term Control Plan •Negotiations with Federal (DOJ,EPA) and State (IDEM) to reduce cost of LTCP by $500M ($715M to $215M) ongoing and at latter stages. •Working to conclude negotiations, then need to secure funds, design and implement plan from 2020 to 2034. •2020 costs will be limited to plan design. WWTP upgrades (detailed earlier) & design of WWTP CSO storage tank. •Capital will be funded through Wastewater Revenue Smart Sewer Sensor 35 CITY OF SOUTH BEND, IN •Norfolk Southern Quiet Zone was established on June 17, 2019. •CN/GTW Quiet Zone is under review and design for modifications to the crossing •Safety measures include mountable median, commercial drive relocation, and warning bells. •The grade crossing consisting of Grandview Avenue and NICTD is the last of the three establishments of quiet zones on the West Side. •Safety measures for the NICTD crossing will consist of mountable median, concrete curb, and Alternative Safety Measure review by the FRA. •Managing Procurement, Installation, and Coordination with respective railroad companies and the FRA •Cost: $350K (2019 Budget) Funding: LRSA (2019) West Side Quiet Zone CITY OF SOUTH BEND, IN 2018 February Flood –Residential Impact •Downspout Disconnect •Assisted with the removal of 554 residential direct connections to the sewer system. •Basement Valve •Installed backflow valve to residents' sanitary sewer line to prevent sewer backup into homes. •Storm Outfall Backflow Prevention •Designing and determining the optimal locations for the installation of duckbill check valves to the City's stormwater outflow. 36 CITY OF SOUTH BEND, IN 2018 February Flood –Infrastructure Impact •East Bank Trail •Damages: Major cracking in the asphalt trail and erosion along embankment directly adjacent to trail path. Dissipater fencing on the culvert has substantial damage. •Estimated Cost: $700,000 •Estimated Completion Date: May 2020 •East Bank Sinkhole •Damages: 15 feet sinkhole from exposed under •Contract Amount: $83,210.75 •Completion Date: July 17, 2019 •East Bank Boat Launch •Damages: Erosion along embankment, damages to gabion baskets, and sediment buildup on boat dock. •Contract Amount: $49,204 •Estimated Completion Date: August 31, 2019 CITY OF SOUTH BEND, IN 2018 February Flood –Infrastructure Impact •Governor Kernan Walkway •Damages: Cracking and undermining of sidewalk. Portions of wall lining the path have become dislodged or damaged. •Estimated Cost: $1,040,510 •Estimated Completion Date: April 2020 •North Pumping Station •Damages: Cracking and undermining of sidewalk adjacent to facility. Potential undermining of main water line. •Estimated Cost: $78,404 •Estimated Completion Date: October 2019 •Pier Park •Damages: 175 feet of wooden pedestrian boardwalk. •Estimated Cost: $220,000 •Estimated Completion Date: April 2020 37 CITY OF SOUTH BEND, IN 2020 –Special Initiatives •New Route and Camera System with GPS tracking. CITY OF SOUTH BEND, IN 38 CITY OF SOUTH BEND, IN 2020 –Special Initiatives •Rate increase trash and yard waste •New branding for solid waste trucks CITY OF SOUTH BEND, IN Streets Special Initiatives •Road temperature sensors •Pilot program that uses sensors to measure road surface temperature and other conditions •Help determine mix and application rate of road salt and liquid de- icing material. •Alternate hot patch material •Pilot program to heat asphalt material in hot-boxes to make an available hot-mix pothole patch for use during the winter months when the asphalt plants are closed. Hot mix is more stable and durable than the cold mix currently used. 39 CITY OF SOUTH BEND, IN Sustainability Special Initiatives •2020 initiatives will include •Continue with obligations of Global Covenant: •Begin implementation of climate action plan •Complete vulnerability assessment in preparation of climate adaptation plan •Update government operations greenhouse gas inventory •Grow and strengthen South Bend Green Corps program •Expand measures to better serve homeowners and respond to identified needs •Bring in additional funding, partnerships, and in-kind support •Recruit great members and ensure they grow and thrive •Build capacity in other city departments with dedicated AmeriCorps members CITY OF SOUTH BEND, IN Sustainability Special Initiatives •Expand electric vehicle charging network •Streetlight modernization – both city- and utility-owned will be converted to LED •Partner with utilities, advocate for smarter energy policies, pursue energy efficiency and renewable energy for city facilities, continue public engagement (Green Ribbon Commission, education, outreach, events, social media). 40 CITY OF SOUTH BEND, IN Utility Special Initiatives •Hydrant Inspection Program •Coordination with the Fire Department and upcoming ISO inspection. •More rigorous inspection process will minimize the risk that any hydrant will be inoperable when needed, and may help the City receive the highest ISO rating. •Implementation of new customer service and billing software, which will go live in 2020. •Will improve the overall customer experience. •Updated portal will have a new payment processor, including a PayGo option where customers can pay their utility bill at several local retail locations. Will allow for real-time payment posting to accounts after hours and on weekends. •Self-service options both through the web portal and the IVR phone system will make utility transactions more convenient. CITY OF SOUTH BEND, IN Questions? 41 Engineering Department 42 City of South Bend, Indiana 2020 Budget Fund 101 - General Fund Engineering Department (0602) 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Expenditures by Type Personnel Salaries & Wages 541,662 651,541 1,807,736 843,073 1,841,018 2,019,112 2,056,622 2,094,873 2,133,894 33,282 2% Health Insurance 82,974 120,048 197,688 95,051 247,159 286,480 302,580 320,980 339,380 49,471 25% Fringe Benefits 106,984 127,363 361,090 172,433 370,109 404,936 412,531 420,286 428,202 9,019 2% Total Personnel 731,620 898,952 2,366,514 1,110,557 2,458,286 2,710,528 2,771,733 2,836,139 2,901,476 91,772 4% Supplies 24,223 13,530 28,952 9,068 23,100 22,700 22,550 22,300 22,300 (5,852) -20% Services & Charges Professional Services 116,007 118,203 352,919 87,639 160,000 160,000 158,000 157,000 157,000 (192,919) -55% Printing & Advertising 400 2,265 7,000 2,254 6,500 6,400 6,300 6,200 6,100 (500) -7% Education & Training 8,359 24,323 21,000 6,998 21,000 21,000 21,000 21,000 21,000 - 0% Travel 16,212 11,736 16,400 7,585 15,250 15,250 13,500 13,500 13,500 (1,150) -7% Repairs & Maintenance 7,763 19,988 23,800 809 26,500 26,500 26,500 26,500 26,500 2,700 11% Other Interfund Allocations 254,496 344,631 365,366 182,684 420,075 477,355 485,918 495,947 504,193 54,709 15% Debt Service Principal 28,092 20,605 14,637 7,293 10,755 4,493 - - - (3,882) -27% Interest & Fees 1,135 684 408 232 194 51 - - - (214) -52% Other Services & Charges 8,620 17,788 23,125 13,404 21,300 21,300 20,700 20,700 20,500 (1,825) -8% Transfers Out - - - - - - - - - - - Total Services & Charges 441,084 560,223 824,655 308,899 681,574 732,349 731,918 740,847 748,793 (143,081) -17% Capital - - - - - - - - - - - Total Expenditures 1,196,927 1,472,705 3,220,121 1,428,525 3,162,960 3,465,577 3,526,201 3,599,286 3,672,569 (57,161) -2% Revenue Licenses & Permits 117,880 146,082 132,000 66,160 127,000 129,250 131,500 132,000 132,000 (5,000) -4% Charges for Services - - 50 - - - - - - (50) -100% Other Income 157,210 126,428 236,364 115,248 229,597 234,089 238,671 243,344 248,111 (6,767) -3% Interfund Allocation Reimb - - 1,400,059 700,021 1,436,881 1,466,826 1,497,271 1,528,893 1,561,045 36,822 3% Total Revenue 275,090 272,510 1,768,473 881,429 1,793,478 1,830,165 1,867,442 1,904,237 1,941,156 25,005 1% Department Purpose: The Engineering Department oversees the design and execution of the City's construction projects. 43 City of South Bend, Indiana 2020 Budget Fund 227 - Loss Recovery Fund Type Special Revenue Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 8,645 12,871 11,400 7,218 4,544 4,601 4,658 4,715 4,774 (6,856) -60% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 8,645 12,871 11,400 7,218 4,544 4,601 4,658 4,715 4,774 (6,856) -60% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services 12,532 73,065 33,997 1,211 - - - - - (33,997) -100% Repairs & Maintenance - - - - - - - - - - - Other Services & Charges 98,400 135,000 236,100 36,100 - - - - - (236,100) -100% Transfers Out - - - - - - - - - - - Total Services & Charges 110,932 208,065 270,097 37,311 - - - - - (270,097) -100% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Bldgs & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 21,660 24,273 2,409 - - - - - - (2,409) -100% Total Capital 21,660 24,273 2,409 - - - - - - (2,409) -100% Total Expenditures 132,592 232,338 272,506 37,311 - - - - - (272,506) -100% Net Surplus / (Deficit)(123,947) (219,467) (261,106) (30,092) 4,544 4,601 4,658 4,715 4,774 Beginning Cash Balance 968,861 847,926 627,325 366,219 370,763 375,364 380,022 384,737 Cash Reserve Cash Adjustments 3,012 (1,134) - - - - - - Ending Cash Balance 847,926 627,325 366,219 370,763 375,364 380,022 384,737 389,511 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement This fund was established in 2008 with the recovery of monies from lawsuits brought about by environmental actions on the Studebaker and Oliver industrial sites. The fund continues to receive, intermittently, monies from similar settlements. The fund is used for capital projects related to environmental cleanup. 44 City of South Bend, Indiana 2020 Budget Fund 251 - Local Roads & Streets Fund Type Special Revenue Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Intergov./ Shared Revenues 1,334,565 1,827,580 1,695,689 930,370 1,539,462 1,544,462 1,549,462 1,554,462 1,559,462 (156,227) -9% Intergov./ Grants 202,729 292,498 320,000 86,812 350,000 50,000 - - - 30,000 9% Interest Earnings 26,512 70,031 75,000 51,565 4,342 6,809 10,609 14,519 18,539 (70,658) -94% Other Income 8,996 412,635 30,000 28,978 - - - - - (30,000) -100% Transfers In - - 2,500,000 1,250,000 - - - - - (2,500,000) -100% Total Revenue 1,572,802 2,602,744 4,620,689 2,347,726 1,893,804 1,601,271 1,560,071 1,568,981 1,578,001 (2,726,885) -59% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies 455,306 555,400 339,675 58,342 250,000 - - - - (89,675) -26% Services & Charges Professional Services - 14,000 878,000 122,955 680,000 - - - - (198,000) -23% Repairs & Maintenance 152,327 764,121 923,926 157,078 650,000 - - - - (273,926) -30% Other Services & Charges - - 5,000 5,000 15,000 - - - - 10,000 200% Transfers Out - 284,500 600,000 - 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 400,000 67% Total Services & Charges 152,327 1,062,621 2,406,926 285,033 2,345,000 1,000,000 1,000,000 1,000,000 1,000,000 (61,926) -3% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Bldgs & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 459,657 391,854 4,348,109 364,290 400,000 400,000 250,000 250,000 250,000 (3,948,109) -91% Total Capital 459,657 391,854 4,348,109 364,290 400,000 400,000 250,000 250,000 250,000 (3,948,109) -91% Total Expenditures 1,067,290 2,009,875 7,094,710 707,665 2,995,000 1,400,000 1,250,000 1,250,000 1,250,000 (4,099,710) -58% Net Surplus / (Deficit)505,512 592,869 (2,474,021) 1,640,061 (1,101,196) 201,271 310,071 318,981 328,001 Beginning Cash Balance 2,825,065 3,340,696 3,929,500 1,455,479 354,283 555,554 865,625 1,184,606 Cash Reserve Cash Adjustments 10,120 (4,065) - - - - - - Ending Cash Balance 3,340,696 3,929,500 1,455,479 354,283 555,554 865,625 1,184,606 1,512,607 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement This fund is used to track expenditures for road projects. 45 City of South Bend, Indiana 2020 Budget Fund 257 - LOIT Special Distribution Fund Type Special Revenue Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Intergov./ Grants - 670,000 215,000 - - - - - - (215,000) -100% Interest Earnings 34,717 37,969 12,500 6,459 2,209 2,237 2,264 2,293 2,321 (10,291) -82% Donations 100,000 - - - - - - - - - - Other Income 314,272 185,734 92,453 92,453 - - - - - (92,453) -100% Transfers In - 254,000 - - - - - - - - - Total Revenue 448,989 1,147,703 319,953 98,912 2,209 2,237 2,264 2,293 2,321 (317,744) -99% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services 285,462 390,739 322,319 111,776 - - - - - (322,319) -100% Repairs & Maintenance - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out 1,000,000 1,340,000 - - - - - - - - - Total Services & Charges 1,285,462 1,730,739 322,319 111,776 - - - - - (322,319) -100% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Bldgs & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 907,255 939,155 578,944 313,189 - - - - - (578,944) -100% Total Capital 907,255 939,155 578,944 313,189 - - - - - (578,944) -100% Total Expenditures 2,192,717 2,669,894 901,263 424,965 - - - - - (901,263) -100% Net Surplus / (Deficit)(1,743,728) (1,522,191) (581,310) (326,053) 2,209 2,237 2,264 2,293 2,321 Beginning Cash Balance 4,025,066 2,281,338 759,357 178,047 180,256 182,493 184,757 187,050 Cash Reserve Cash Adjustments - 210 - - - - - - Ending Cash Balance 2,281,338 759,357 178,047 180,256 182,493 184,757 187,050 189,371 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement - one-time distribution - spend down to zero This fund was established in 2016, per the State Board of Accounts (SBOA), to receive a one-time payment of local income taxes from the State for the purpose of infrastructure expenditures. Per the state statute, a minimum of 75% must be spent on infrastructure projects. A total of $4,217,549, representing 75% of the total distribution, was deposited in May 2016, comprised of $4,160,901 distributed to the City and $56,648 distributed to the Redevelopment Authority. The remainder was deposited into the Rainy Day Fund (102). 46 City of South Bend, Indiana 2020 Budget Fund 265 - Local Road & Bridge Grant Fund Type Special Revenue Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Intergov./ Grants 1,000,000 - 600,000 - 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 400,000 67% Interest Earnings - 6,282 6,000 3,862 3,138 - - - - (2,862) -48% Other Income - - - - - - - - - - - Transfers In 1,000,000 1,370,500 600,000 - 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 400,000 67% Total Revenue 2,000,000 1,376,782 1,206,000 3,862 2,003,138 2,000,000 2,000,000 2,000,000 2,000,000 797,138 66% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Repairs & Maintenance 1,007,057 1,704,898 1,283,291 798 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 716,709 56% Other Services & Charges - 334,741 - - - - - - - - - Transfers Out - -- - - - - - - - - Total Services & Charges 1,007,057 2,039,640 1,283,291 798 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 716,709 56% Capital - - - - - - - - - - - Total Expenditures 1,007,057 2,039,640 1,283,291 798 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 716,709 56% Net Surplus / (Deficit)992,943 (662,857) (77,291) 3,064 3,138 - - - - Beginning Cash Balance - 992,943 330,177 252,886 256,024 256,024 256,024 256,024 Cash Reserve Cash Adjustments - 91 - - - - - - Ending Cash Balance 992,943 330,177 252,886 256,024 256,024 256,024 256,024 256,024 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement - Grant fund - spend down to zero This fund was established in December 2016 to account for the receipt of the Community Crossings state grant and matching revenue and for the payment of expenditures on eligible projects, per the Indiana State Board of Accounts (SBOA). Community Crossings is a partnership between the Indiana Department of Transportation (INDOT) and Hoosier communities, both urban and rural, to invest in infrastructure projects that catalyze economic development, create jobs, and strengthen local transportation networks. 47 City of South Bend, Indiana 2020 Budget Fund 412 - Major Moves Construction Fund Type Capital Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 25,689 50,664 47,500 32,623 8,000 5,000 5,000 5,000 5,000 (39,500) -83% Other Income 1,028,861 493,328 511,807 265,293 493,328 493,328 493,328 493,328 138,515 (18,479) -4% Transfers In - - - - - - - - - - - Total Revenue 1,054,550 543,992 559,307 297,916 501,328 498,328 498,328 498,328 143,515 (57,979) -10% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - 100,000 - 500,000 500,723 498,328 498,328 143,515 400,000 400% Repairs & Maintenance 490,548 671,364 922,187 159,909 - - - - - (922,187) -100% Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges 490,548 671,364 1,022,187 159,909 500,000 500,723 498,328 498,328 143,515 (522,187) -51% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Bldgs & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 21,700 7,090 1,619,049 143,662 - - - - - (1,619,049) -100% Total Capital 21,700 7,090 1,619,049 143,662 - - - - - (1,619,049) -100% Total Expenditures 512,248 678,454 2,641,236 303,571 500,000 500,723 498,328 498,328 143,515 (2,141,236) -81% Net Surplus / (Deficit)542,302 (134,462) (2,081,929) (5,655) 1,328 (2,395) - - - Beginning Cash Balance 2,359,939 2,910,880 2,772,697 690,768 692,096 689,701 689,701 689,701 Cash Reserve Cash Adjustments 8,639 (3,722) - - - - - - Ending Cash Balance 2,910,880 2,772,697 690,768 692,096 689,701 689,701 689,701 689,701 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement - Capital fund - spend down to zero This fund was established in 2006 with the City's share of the proceeds for the lease of the Indiana Toll Road (I-80/90). The fund is used to finance capital improvements projects and also makes loans to other funds. 48 Solid Waste 49 City of South Bend, Indiana 2020 Budget Fund 610 - Solid Waste Operations Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services 5,346,176 5,408,816 5,402,522 2,688,390 5,404,450 5,404,450 5,404,450 5,404,450 5,404,450 1,928 0% Interest Earnings 3,933 9,741 11,500 5,817 - - - - - (11,500) -100% Other Income 74,536 75,596 113,463 12,263 12,700 12,700 12,700 12,700 12,700 (100,763) -89% Transfers In - - - - - - - - - - - Total Revenue 5,424,644 5,494,152 5,527,485 2,706,470 5,417,150 5,417,150 5,417,150 5,417,150 5,417,150 (110,335) -2% Expenditures by Type Personnel Salaries & Wages 1,071,780 1,067,278 1,110,697 501,830 1,132,274 1,144,327 1,156,537 1,168,926 1,181,476 21,577 2% Health Insurance 333,775 281,510 223,044 101,427 268,710 284,810 300,910 319,310 337,710 45,666 20% Fringe Benefits 220,484 221,281 244,393 108,263 249,610 252,253 254,933 257,652 260,409 5,217 2% Total Personnel 1,626,040 1,570,069 1,578,134 711,520 1,650,594 1,681,390 1,712,380 1,745,888 1,779,595 72,460 5% Supplies 233,123 277,367 377,388 122,378 424,500 442,500 461,850 483,135 506,549 47,112 12% Services & Charges Professional Services 115,208 - - - - - - - - - - Printing & Advertising 43 - 250 - 250 250 250 250 250 - 0% Education & Training 8,564 11,509 5,900 975 20,000 10,000 10,000 10,000 10,000 14,100 239% Travel 3,659 2,556 9,900 1,137 9,900 9,900 9,900 9,900 9,900 - 0% Repairs & Maintenance 830,841 972,796 665,431 335,863 720,000 720,000 720,000 720,000 720,000 54,569 8% Other Interfund Allocations 596,856 851,115 998,406 499,200 963,421 1,087,142 1,106,244 1,127,521 1,146,767 (34,985) -4% Other Services & Charges 912,690 884,322 761,958 420,799 1,036,700 1,064,900 1,113,200 1,163,900 1,227,674 274,742 36% Transfers Out 778,600 1,004,039 1,132,616 829,065 1,231,349 1,004,506 868,382 650,419 532,767 98,733 9% Total Services & Charges 3,246,460 3,726,338 3,574,461 2,087,039 3,981,620 3,896,698 3,827,976 3,681,990 3,647,358 407,159 11% Capital - - - - - - - - - - - Total Expenditures 5,105,623 5,573,774 5,529,983 2,920,936 6,056,714 6,020,588 6,002,206 5,911,013 5,933,502 526,731 10% Net Surplus / (Deficit)319,022 (79,622) (2,498) (214,466) (639,564) (603,438) (585,056) (493,863) (516,352) Beginning Cash Balance 193,005 533,909 526,853 524,355 (115,209) (718,647) (1,303,703) (1,797,566) Cash Reserve Cash Adjustments 21,883 72,566 - - - - - - Ending Cash Balance 533,909 526,853 524,355 (115,209) (718,647) (1,303,703) (1,797,566) (2,313,918) Cash Reserves Target 510,562 557,377 552,998 605,671 602,059 600,221 591,101 593,350 Fund Purpose: 10% of Annual expenditures This fund accounts for the operations of the Solid Waste Department. Solid Waste provides exceptional waste management services for the residents of South Bend. They collect an average of 29,200 tons of trash annually through weekly service. Additional services available to residents include trash extra bulky collection, weekly yard waste collection, yard waste extra bulky collection, and Christmas tree collection. 50 City of South Bend, Indiana 2020 Budget Fund 611 - Solid Waste Capital Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 1,027 1,654 2,800 2,215 588 - - - - (2,212) -79% Other Income - 1,435 - - - - - - - - - Transfers In 778,600 1,004,039 1,132,616 829,065 1,231,349 1,004,506 868,382 650,419 532,767 98,733 9% Total Revenue 779,627 1,007,128 1,135,416 831,280 1,231,937 1,004,506 868,382 650,419 532,767 96,521 9% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Debt Service Principal 1,034,520 937,090 1,037,025 448,483 1,159,236 945,778 819,918 611,768 497,979 122,211 12% Interest & Fees 41,621 65,381 95,591 32,515 72,113 58,728 48,464 38,651 34,788 (23,478) -25% Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges 1,076,141 1,002,470 1,132,616 480,998 1,231,349 1,004,506 868,382 650,419 532,767 98,733 9% Capital - - - - - - - - - - - Total Expenditures 1,076,141 1,002,470 1,132,616 480,998 1,231,349 1,004,506 868,382 650,419 532,767 98,733 9% Net Surplus / (Deficit)(296,514) 4,657 2,800 350,282 588 - - - - Beginning Cash Balance 335,856 39,995 44,603 47,403 47,991 47,991 47,991 47,991 Cash Reserve Cash Adjustments 652 (49) - - - - - - Ending Cash Balance 39,995 44,603 47,403 47,991 47,991 47,991 47,991 47,991 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement - Capital fund - spend down to zero This fund is used for debt service and capital expenditures related to the Solid Waste Department. 51 Sustainability & AmeriCorps 52 City of South Bend, Indiana 2020 Budget Combined Historical Budget Office of Sustainability 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Historical Expenditures by Fund Central Services Fund (222)256,633 304,308 17,237 5,894 - - - - - (17,237) -100% General Fund (101)- - 278,815 98,007 377,567 476,253 274,990 278,925 282,853 98,752 35% Total Expenditures 256,633 304,308 296,052 103,901 377,567 476,253 274,990 278,925 282,853 81,515 28% Expenditures by Type Personnel Salaries & Wages 145,032 152,978 98,302 40,497 110,252 112,457 114,706 117,001 119,341 11,950 12% Health Insurance 30,640 31,292 10,056 5,028 11,610 12,310 13,010 13,810 14,610 1,554 15% Fringe Benefits 26,908 29,394 17,716 8,123 19,191 19,555 19,929 20,309 20,697 1,475 8% Total Personnel 202,580 213,664 126,074 53,647 141,053 144,322 147,645 151,120 154,648 14,979 12% Supplies 143 211 30,050 4,486 23,950 11,950 11,950 11,950 11,950 (6,100) -20% Services & Charges Professional Services 16,130 20,978 88,000 31,116 190,000 295,000 90,000 90,000 90,000 102,000 116% Printing & Advertising 205 184 639 - 500 500 500 500 500 (139) -22% Education & Training 1,345 3,655 2,800 18 2,800 2,800 2,800 2,800 2,800 - 0% Travel 2,138 1,019 6,374 - 3,800 3,800 3,800 3,800 3,800 (2,574) -40% Repairs & Maintenance - - - - - - - - - - - Other Interfund Allocations 33,396 58,667 32,367 9,616 9,764 11,381 11,595 11,855 12,055 (22,603) -70% Grants & Subsidies - 5,320 4,800 2,434 - - - - - (4,800) -100% Other Services & Charges 696 610 4,948 2,584 5,700 6,500 6,700 6,900 7,100 752 15% Transfers Out - - - - - - - - - - - Total Services & Charges 53,911 90,434 139,928 45,768 212,564 319,981 115,395 115,855 116,255 72,636 52% Capital - - - - - - - - - - - Total Expenditures 256,633 304,308 296,052 103,901 377,567 476,253 274,990 278,925 282,853 81,515 28% 53 City of South Bend, Indiana 2020 Budget Fund 101 - General Fund AmeriCorps Grant Program (0628) 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Expenditures by Type Personnel Salaries & Wages - 13,424 315,000 97,915 262,722 280,736 300,386 321,834 345,253 (52,278) -17% Health Insurance - 1,296 20,112 8,352 23,221 24,621 26,021 27,621 29,221 3,109 15% Fringe Benefits - 1,956 19,954 12,558 33,839 35,478 37,247 39,157 41,226 13,885 70% Total Personnel - 16,677 355,066 118,825 319,782 340,835 363,654 388,612 415,700 (35,284) -10% Supplies - 53 128,757 6,213 49,050 48,740 49,061 49,415 49,807 (79,707) -62% Services & Charges Professional Services - - 204,868 2,399 44,051 46,131 50,619 55,556 46,131 (160,817) -78% Printing & Advertising - - 1,000 - 1,000 1,000 1,000 1,000 1,000 - 0% Education & Training - - 9,800 304 7,624 7,624 7,624 7,624 7,624 (2,176) -22% Travel - - 9,706 2,699 10,006 11,007 12,107 13,318 14,650 300 3% Grants & Subsidies - - - - - 65,000 80,000 95,000 105,000 - - Other Services & Charges - 638 4,042 1,078 6,820 7,249 7,721 8,240 8,811 2,778 69% Transfers Out - -- - - - - - - - - Total Services & Charges - 638 229,416 6,480 69,501 138,011 159,071 180,738 183,216 (159,915) -70% Capital - - - - - - - - - - - Total Expenditures - 17,368 713,239 131,519 438,333 527,586 571,786 618,765 648,723 (274,906) -39% Revenue Intergov./ Grants - - 149,130 76,822 177,238 194,962 204,710 214,946 225,693 28,108 19% Other Income - - - - - - - - - - - Transfers In - - 120,000 - 70,000 70,000 70,000 70,000 70,000 (50,000) -42% Total Revenue - - 269,130 76,822 247,238 264,962 274,710 284,946 295,693 (21,892) -8% Department Purpose: In 2018, the City of South Bend won a $150,000 grant to fund South Bend Home Corps, a new residential efficiency, health, and safety program staffed by 10 full-time AmeriCorps members. This is a division of Public Works and works directly with the Office of Sustainability. Goals: - Empower homeowners to understand bills and manage energy and water use. - Assess homes for energy or water savings and safety or health hazards. - Install basic efficiency and weatherization measures. - Facilitate homeowner in accessing other City or community programs for significant repair or health/safety issues. - Hold public workshops and education events. What is AmeriCorps? - AmeriCorps is a network of national service programs, made up of three primary programs that each take a different approach to improving lives and fostering civic engagement. - Members commit their time to address critical community needs like increasing academic achievement, mentoring youth, fighting poverty, and preparing for disasters. - AmeriCorps help communities recover from damage caused by natural and other disasters, as well as, assist to build affordable housing units for families to increase economic opportunity for those living in poverty. 54 Streets & Sewers 55 City of South Bend, Indiana 2020 Budget Fund 202 - Motor Vehicle Highway Fund Type Special Revenue Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Intergov./ Shared Revenues 6,040,898 6,870,730 3,149,516 1,634,962 3,041,250 3,046,250 3,051,250 3,056,250 3,061,250 (108,266) -3% Charges for Services 232,443 246,361 228,245 135,718 229,670 231,916 234,185 236,478 238,793 1,425 1% Licenses & Permits - - 3,000 1,525 - - - - - (3,000) -100% Interest Earnings 61,002 137,767 140,000 87,954 39,628 - - - - (100,372) -72% Other Income 56,993 56,611 10,102 10,102 5,300 5,300 5,300 5,300 5,300 (4,802) -48% Interfund Allocation Reimb - - 138,150 69,078 149,020 152,558 156,142 159,934 163,779 10,870 8% Transfers In 3,964,974 3,814,963 3,852,066 1,893,875 4,777,699 3,787,750 3,787,750 3,787,750 3,787,750 925,633 24% Total Revenue 10,356,311 11,126,434 7,521,079 3,833,214 8,242,567 7,223,774 7,234,627 7,245,712 7,256,872 721,488 10% Expenditures by Dept Streets / Traffic & Lighting 7,859,564 8,914,649 10,498,035 5,524,423 6,891,293 6,953,293 6,963,894 7,151,767 7,271,312 (3,606,742) -34% Curb & Sidewalk 1,510,285 1,322,900 1,671,576 339,504 1,481,932 1,587,742 1,518,932 1,533,594 1,548,942 (189,644) -11% Total Expenditures 9,369,849 10,237,548 12,169,611 5,863,927 8,373,225 8,541,035 8,482,826 8,685,361 8,820,254 (3,796,386) -31% Expenditures by Type Personnel Salaries & Wages 2,580,742 2,885,203 2,116,646 1,454,966 2,295,114 2,400,958 2,350,356 2,388,734 2,418,123 178,468 8% Health Insurance 702,012 759,086 400,984 261,409 441,195 467,795 494,395 524,795 555,195 40,211 10% Fringe Benefits 528,717 592,552 464,214 306,426 487,582 509,895 511,351 506,961 512,849 23,368 5% Total Personnel 3,811,471 4,236,841 2,981,844 2,022,801 3,223,891 3,378,648 3,356,102 3,420,490 3,486,167 242,047 8% Supplies 1,721,517 1,701,021 2,317,927 685,801 1,440,549 1,195,054 1,199,649 1,204,334 1,209,113 (877,378) -38% Services & Charges Professional Services 854,940 670,422 802,793 73,805 549,014 549,014 549,014 549,014 549,014 (253,779) -32% Printing & Advertising 323 263 1,000 141 1,250 1,250 1,250 1,250 1,250 250 25% Utilities 42,517 45,568 52,502 27,123 49,200 50,015 50,846 51,694 52,558 (3,302) -6% Education & Training 5,710 4,425 10,000 9,540 15,000 15,000 15,000 15,000 15,000 5,000 50% Travel 2,575 1,716 10,000 1,586 15,000 15,000 15,000 15,000 15,000 5,000 50% Repairs & Maintenance 1,245,145 1,679,173 780,505 583,924 647,588 647,738 647,890 648,043 648,198 (132,917) -17% Other Interfund Allocations 853,056 1,018,733 1,628,279 814,139 1,538,377 1,737,890 1,764,388 1,794,046 1,821,491 (89,902) -6% Debt Service Principal 677,271 719,026 857,551 358,383 724,287 775,643 698,845 788,585 805,971 (133,264) -16% Interest & Fees 35,352 37,504 68,076 22,281 45,785 52,499 61,558 74,621 93,208 (22,291) -33% Other Services & Charges 93,177 94,989 159,134 14,402 123,284 123,284 123,284 123,284 123,284 (35,850) -23% Transfers Out - - 2,500,000 1,250,000 - - - - - (2,500,000) -100% Total Services & Charges 3,810,066 4,271,818 6,869,840 3,155,325 3,708,785 3,967,333 3,927,075 4,060,537 4,124,974 (3,161,055) -46% Capital 26,795 27,868 - - - - - - - - - Total Expenditures 9,369,849 10,237,548 12,169,611 5,863,927 8,373,225 8,541,035 8,482,826 8,685,361 8,820,254 (3,796,386) -31% Net Surplus / (Deficit)986,461 888,885 (4,648,532) (2,030,712) (130,658) (1,317,261) (1,248,199) (1,439,649) (1,563,382) Beginning Cash Balance 6,122,507 7,132,834 8,012,501 3,363,969 3,233,311 1,916,050 667,851 (771,798) Cash Reserve Cash Adjustments 23,865 (9,218) - - - - - - Ending Cash Balance 7,132,834 8,012,501 3,363,969 3,233,311 1,916,050 667,851 (771,798) (2,335,180) Cash Reserves Target 2,342,462 2,559,387 3,042,403 2,093,306 2,135,259 2,120,707 2,171,340 2,205,064 Fund Purpose: 25% of Annual expenditures This fund accounts for the operations of the following divisions of the Public Works Department: Streets, Traffic & Lighting, and Curb & Sidewalk. STREETS: The Office of Streets repairs and maintains 2,200 lane miles of road surface in the city limits. Maintenance on streets ranges from paving and patching in the summer to plowing snow in the winter. In 2017, 19.06 miles of streets were resurfaced and 363 tons of patch mix were used to fix potholes. In addition to maintenance, Streets maintains around 398 miles of alley surface. Also operating under the Street Department is Unit 211, a 24/7 response vehicle that works with the South Bend Police Department and the South Bend Fire Department for emergencies. TRAFFIC & LIGHTING: The Office of Traffic & Lighting maintains traffic signs, signals and city-owned street lights, and is responsible for approximately 160 signalized intersections and 3,000 street lights. In 2017, there were roughly 1,650 work orders for sign maintenance, installation and/or removal. Not only does this office provide traffic control in construction areas for the Offices of Streets and Sewers, but Traffic & Lighting also works with the South Bend Police Department to provide traffic control for special events in the city, setting up traffic control for an average of 100 different events in a year. 56 City of South Bend, Indiana 2020 Budget Fund 266 - MVH Restricted Fund Fund Type Special Revenue Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Intergov./ Shared Revenues - - 3,149,515 1,634,962 3,041,250 3,046,250 3,051,250 3,056,250 3,061,250 (108,265) -3% Charges for Services - - - - - - - - - - - Interest Earnings - - - - - - - - - - - Other Income - - - - - - - - - - - Interfund Allocation Reimb - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue - - 3,149,515 1,634,962 3,041,250 3,046,250 3,051,250 3,056,250 3,061,250 (108,265) -3% Expenditures by Dept Streets / Traffic & Lighting - - 3,148,615 286,496 3,046,590 3,128,951 3,157,330 3,188,051 3,218,926 (102,025) -3% Curb & Sidewalk - - - - - - - - - - - Total Expenditures - - 3,148,615 286,496 3,046,590 3,128,951 3,157,330 3,188,051 3,218,926 (102,025) -3% Expenditures by Type Personnel Salaries & Wages - - 1,109,500 - 988,102 1,032,016 1,040,893 1,049,851 1,058,899 (121,398) -11% Health Insurance - - 192,320 - 243,818 270,829 286,229 303,829 321,429 51,498 27% Fringe Benefits - - 208,905 - 197,458 206,670 208,505 210,356 212,224 (11,447) -5% Total Personnel - - 1,510,725 - 1,429,378 1,509,515 1,535,627 1,564,036 1,592,552 (81,347) -5% Supplies - - 1,195,690 236,343 1,177,966 1,180,189 1,182,456 1,184,768 1,187,127 (17,724) -1% Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - 442,200 50,153 439,246 439,247 439,247 439,247 439,247 (2,954) -1% Other Interfund Allocations - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges - - 442,200 50,153 439,246 439,247 439,247 439,247 439,247 (2,954) -1% Capital - - - - - - - - - - - Total Expenditures - - 3,148,615 286,496 3,046,590 3,128,951 3,157,330 3,188,051 3,218,926 (102,025) -3% Net Surplus / (Deficit)- - 900 1,348,467 (5,340) (82,701) (106,080) (131,801) (157,676) Beginning Cash Balance - - - 900 (4,440) (87,141) (193,221) (325,022) Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance - - 900 (4,440) (87,141) (193,221) (325,022) (482,698) Cash Reserves Target - - 787,154 761,648 782,238 789,333 797,013 804,732 Fund Purpose: 25% of Annual expenditures The MVH Restricted Fund was established in 2019 due to a directive from the State Board of Accounts: Starting on January 1, 2019, the political subdivision must post at the time of receipt of the distribution from the State Motor Vehicle Highway Account fifty percent (50%) of the distribution to MVH Restricted. The political subdivision, by ordinance or resolution, may elect to allocate more than fifty percent (50%) of the distributions to MVH Restricted. During the same fiscal year, the political subdivision may transfer, by ordinance or resolution, the amount allocated in excess of the 50% requirement from MVH Restricted to MVH. In no event can any transfers from MVH Restricted to MVH reduce the fiscal year distributions from the State Motor Vehicle Highway Account below the 50% requirement for MVH Restricted. Any amounts allocated in excess of the required 50% of distributions which remain in MVH Restricted at the end of the fiscal year must remain in MVH Restricted until expended for construction, reconstruction, or preservation. 57 City of South Bend, Indiana 2020 Budget Fund 640 - Sewer Repair Insurance Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services 639,249 640,050 637,863 326,357 645,105 651,557 658,073 664,655 671,301 7,242 1% Interest Earnings 16,588 34,121 37,500 24,058 25,058 25,228 25,411 25,605 25,810 (12,442) -33% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 655,836 674,171 675,363 350,415 670,163 676,785 683,484 690,260 697,111 (5,200) -1% Expenditures by Type Personnel Salaries & Wages 144,804 148,298 113,545 57,803 115,313 116,783 118,362 119,968 121,601 1,768 2% Health Insurance 38,273 38,605 20,112 10,056 23,221 24,621 26,021 27,621 29,221 3,109 15% Fringe Benefits 29,755 31,156 24,524 12,593 25,026 25,334 25,666 26,006 26,350 502 2% Total Personnel 212,832 218,059 158,181 80,452 163,560 166,738 170,049 173,595 177,172 5,379 3% Supplies 17,120 32,495 71,355 8,247 16,965 17,150 17,339 17,532 17,728 (54,390) -76% Services & Charges Professional Services - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance 277,584 250,641 351,655 139,306 386,000 386,020 386,040 386,060 386,080 34,345 10% Other Interfund Allocations 18,948 17,868 75,495 37,743 84,511 86,527 88,584 90,741 92,930 9,016 12% Debt Service Principal 14,112 - - - - - - - - - - Interest & Fees 106 - - - - - - - - - - Other Services & Charges 6,313 6,150 6,500 1,516 6,500 6,500 6,500 6,500 6,500 - 0% Transfers Out - - - - - - - - - - - Total Services & Charges 317,063 274,659 433,650 178,565 477,011 479,047 481,124 483,301 485,510 43,361 10% Capital - - - - - - - - - - - Total Expenditures 547,016 525,213 663,186 267,264 657,536 662,935 668,512 674,428 680,410 (5,650) -1% Net Surplus / (Deficit)108,821 148,958 12,177 83,151 12,627 13,850 14,972 15,832 16,701 Beginning Cash Balance 1,752,931 1,866,378 2,019,718 2,031,895 2,044,522 2,058,372 2,073,344 2,089,176 Cash Reserve Cash Adjustments 4,627 4,382 - - - - - - Ending Cash Balance 1,866,378 2,019,718 2,031,895 2,044,522 2,058,372 2,073,344 2,089,176 2,105,877 Cash Reserves Target 136,754 131,303 165,797 164,384 165,734 167,128 168,607 170,103 Fund Purpose: 25% of Annual expenditures The Sewer Insurance program is funded by a monthly charge on City residents' sewer bills. The City is responsible for the main sewer line; from the main line to the house is the homeowner's responsibility. This program helps residents who have an issue with their lateral that cannot be resolved by a simple clean-out by a plumber, i.e., collapsed line, complete root infiltration, etc. that requires excavation work - a "dig". The program is set up so that the homeowner pays a maximum $500.00 deductible toward the cost of the repair and the City pays the rest. 58 City of South Bend, Indiana 2020 Budget Fund 655 - Project ReLeaf Fund Type Special Revenue Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services 444,734 447,240 447,139 223,731 451,610 456,126 460,688 465,295 469,948 4,471 1% Interest Earnings 8,114 14,198 7,350 7,200 4,869 5,198 5,572 5,995 6,466 (2,481) -34% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 452,847 461,438 454,489 230,931 456,479 461,324 466,260 471,290 476,414 1,990 0% Expenditures by Type Personnel Salaries & Wages 28,198 43,222 72,660 2,314 73,920 73,920 73,920 73,920 73,920 1,260 2% Fringe Benefits 2,157 3,307 5,559 139 5,655 5,655 5,655 5,655 5,655 96 2% Total Personnel 30,355 46,529 78,219 2,453 79,575 79,575 79,575 79,575 79,575 1,356 2% Supplies 3,092 1,184 - - 5,000 5,000 5,000 5,000 5,000 5,000 - Services & Charges Professional Services - - - - - - - - - - - Repairs & Maintenance 10,591 9,606 - 7,860 - - - - - - - Other Interfund Allocations 32,400 31,381 40,243 20,119 42,385 43,411 44,462 45,540 46,646 2,142 5% Debt Service Principal 70,659 48,404 - - - - - - - - - Interest & Fees 1,560 576 - - - - - - - - - Other Services & Charges 6,245 5,773 6,500 1,649 6,500 6,565 6,631 6,697 6,764 - 0% Transfers Out 350,000 550,000 550,000 275,000 300,000 300,000 300,000 300,000 300,000 (250,000) -45% Total Services & Charges 471,454 645,740 596,743 304,627 348,885 349,976 351,093 352,237 353,410 (247,858) -42% Capital - - - - - - - - - - - Total Expenditures 504,901 693,453 674,962 307,080 433,460 434,551 435,668 436,812 437,985 (241,502) -36% Net Surplus / (Deficit)(52,054) (232,015) (220,473) (76,149) 23,019 26,773 30,592 34,478 38,429 Beginning Cash Balance 871,573 822,096 594,755 374,282 397,301 424,074 454,666 489,144 Cash Reserve Cash Adjustments 2,577 4,674 - - - - - - Ending Cash Balance 822,096 594,755 374,282 397,301 424,074 454,666 489,144 527,573 Cash Reserves Target 126,225 173,363 168,741 108,365 108,638 108,917 109,203 109,496 Fund Purpose: 25% of Annual expenditures This fund accounts for the fall and spring leaf collection program. This fund was established in 1989 (ordinance 8007-89) in response to the problems brought about by the layers of dead leaves that collect in the fall. The City instituted a leaf pick-up program, called "Operation Re-Leaf," which encompassed using leaf vacuums as the primary collection tool. The City collects and disposes of leaves for residents to mitigate the practice of burning leaves. Burning leaves impacts air quality and can cause house/wild fires. (Ord. No. 7895-88, § 1; Ord. No. 8023-89, § 1; Ord. No. 9641-05, § I, 11-18-05) 59 Utilities - Water Works 60 City of South Bend, Indiana 2020 Budget Fund 620 - Water Works Operations Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services 13,658,131 15,388,151 18,958,930 7,906,775 19,419,036 19,419,036 19,419,036 19,419,036 19,419,036 460,106 2% Interest Earnings 25,855 52,112 60,000 37,014 30,000 30,000 30,000 30,000 30,000 (30,000) -50% Other Income 74,623 33,509 88,120 22,198 47,500 47,500 47,500 47,500 47,500 (40,620) -46% Interfund Allocation Reimb 1,613,364 1,390,950 1,734,889 867,445 1,788,327 1,843,227 1,899,789 1,958,166 2,018,308 53,438 3% Transfers In 60,894 108,690 95,000 69,825 100,000 100,000 100,000 95,000 95,000 5,000 5% Total Revenue 15,432,866 16,973,411 20,936,939 8,903,257 21,384,863 21,439,763 21,496,325 21,549,702 21,609,844 447,924 2% Expenditures by Type Personnel Salaries & Wages 3,460,112 3,495,419 3,578,355 1,638,330 3,665,888 3,710,885 3,758,111 3,806,156 3,855,349 87,533 2% Health Insurance 972,402 953,867 656,952 296,123 738,137 782,237 826,337 876,737 927,137 81,185 12% Fringe Benefits 719,881 730,924 772,040 346,042 788,159 797,469 807,394 817,418 827,686 16,119 2% Total Personnel 5,152,395 5,180,210 5,007,347 2,280,495 5,192,184 5,290,591 5,391,842 5,500,311 5,610,172 184,837 4% Supplies 1,231,737 1,319,059 1,957,065 801,633 1,684,010 1,686,209 1,715,913 1,748,421 1,781,911 (273,055) -14% Services & Charges Professional Services 1,313,412 1,373,050 2,898,340 968,924 2,600,930 2,070,548 1,927,003 2,167,267 2,153,181 (297,410) -10% Printing & Advertising 193 469 2,250 567 1,750 1,793 1,847 1,902 1,959 (500) -22% Utilities 715,247 777,050 785,550 354,462 833,700 859,047 884,819 911,363 938,704 48,150 6% Education & Training 15,218 11,331 36,368 9,011 30,175 31,080 32,014 32,973 33,963 (6,193) -17% Travel 4,035 2,785 18,750 2,134 18,750 19,313 19,892 20,489 21,103 - 0% Repairs & Maintenance 358,530 359,337 438,019 163,565 390,200 401,821 413,929 426,346 439,136 (47,819) -11% Other Interfund Allocations 1,350,528 1,339,518 1,979,352 989,676 2,190,893 2,363,508 2,395,556 2,444,000 2,488,622 211,541 11% Debt Service Principal 211,041 394,755 396,983 197,666 402,017 296,671 201,048 - - 5,034 1% Interest & Fees 15,354 35,731 23,015 12,446 15,525 8,064 3,131 - - (7,490) -33% Other Services & Charges 1,229,691 1,222,554 2,066,212 568,727 1,556,920 1,564,351 1,571,976 1,579,889 1,588,010 (509,292) -25% Transfers Out 3,949,584 3,778,273 7,203,665 3,685,362 7,582,928 6,845,024 6,675,464 6,496,917 6,442,335 379,263 5% Total Services & Charges 9,162,833 9,294,853 15,848,504 6,952,540 15,623,788 14,461,220 14,126,679 14,081,146 14,107,013 (224,716) -1% Capital - - - - - - - - - - - Total Expenditures 15,546,965 15,794,122 22,812,916 10,034,668 22,499,982 21,438,020 21,234,434 21,329,878 21,499,096 (312,934) -1% Net Surplus / (Deficit)(114,098) 1,179,289 (1,875,977) (1,131,412) (1,115,119) 1,743 261,891 219,824 110,748 Beginning Cash Balance 3,801,473 3,482,307 4,629,470 2,753,493 1,638,374 1,640,117 1,902,008 2,121,832 Cash Reserve Cash Adjustments (205,068) (32,125) - - - - - - Ending Cash Balance 3,482,307 4,629,470 2,753,493 1,638,374 1,640,117 1,902,008 2,121,832 2,232,580 Cash Reserves Target 777,348 789,706 1,140,646 1,124,999 1,071,901 1,061,722 1,066,494 1,074,955 Fund Purpose: 5% of Annual expenditures This fund was established to account for all revenue and operational expenses of the water utility. This fund provides the monies for debt service obligations, reserve requirements and revenue funded capital improvements through transfer of monies to other funds within the utility operations. 61 City of South Bend, Indiana 2020 Budget Fund 622 - Water Works Capital Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services - 225,863 100,000 29,925 100,000 100,000 100,000 100,000 100,000 - 0% Interest Earnings 21,393 35,872 35,000 30,313 25,000 25,000 25,000 25,000 25,000 (10,000) -29% Other Income - - - - - - - - - - - Transfers In 44,388 8,053 3,241,000 1,620,498 3,862,000 3,319,000 3,141,000 3,396,000 3,339,000 621,000 19% Total Revenue 65,781 269,787 3,376,000 1,680,736 3,987,000 3,444,000 3,266,000 3,521,000 3,464,000 611,000 18% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services 61,511 11,896 179,404 4 - - - - - (179,404) -100% Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges 61,511 11,896 179,404 4 - - - - - (179,404) -100% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg. Improve.- - 630,000 - 235,000 211,231 - 350,000 350,000 (395,000) -63% Motor Equipment 395,202 499,300 757,287 215,287 507,000 409,000 441,000 496,000 359,000 (250,287) -33% Machinery & Equipment 23,098 12,995 30,235 - 20,000 10,000 - - 80,000 (10,235) -34% Infrastructure 26,799 - 1,584,365 - 2,380,000 2,522,461 2,000,000 1,850,000 1,850,000 795,635 50% Water Meters - - 800,000 - - - - - - (800,000) -100% Total Capital 445,099 512,295 3,801,887 215,287 3,142,000 3,152,692 2,441,000 2,696,000 2,639,000 (659,887) -17% Total Expenditures 506,610 524,191 3,981,291 215,291 3,142,000 3,152,692 2,441,000 2,696,000 2,639,000 (839,291) -21% Net Surplus / (Deficit)(440,829) (254,403) (605,291) 1,465,445 845,000 291,308 825,000 825,000 825,000 Beginning Cash Balance 2,582,972 2,150,002 1,892,832 2,087,541 2,932,541 3,223,849 4,048,849 4,873,849 Cash Reserve Cash Adjustments 7,858 (2,767) 800,000 - - - - - Ending Cash Balance 2,150,002 1,892,832 2,087,541 2,932,541 3,223,849 4,048,849 4,873,849 5,698,849 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement - Capital fund - spend down to zero This fund is used for acquiring, constructing, and improving water utility capital assets. Water utility capital assets include wells, reservoirs, transmission and distribution mains, water meters, pumping equipment, treatment equipment, transportation equipment, and other general plant items. 62 City of South Bend, Indiana 2020 Budget Fund 624 - Water Works Customer Deposit Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 13,935 26,882 22,000 17,458 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 13,935 26,882 22,000 17,458 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Other Services & Charges - - - - - - - - - - - Transfers Out 13,729 24,957 22,000 17,041 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Total Services & Charges 13,729 24,957 22,000 17,041 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Capital - - - - - - - - - - - Total Expenditures 13,729 24,957 22,000 17,041 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Net Surplus / (Deficit)206 1,925 - 416 - - - - - Beginning Cash Balance 1,541,423 1,518,552 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 Cash Reserve Cash Adjustments (23,078) (13,485) - - - - - - Ending Cash Balance 1,518,552 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 Cash Reserves Target 1,518,552 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 1,506,992 Fund Purpose: 100% cash reserves for customer deposits This fund was established to retain the security deposits collected from utility customers. Upon termination of service, the security deposited is refunded in the form of a credit to the customer's final bill. 63 City of South Bend, Indiana 2020 Budget Fund 625 - Water Works Sinking (Debt Service) Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 9,951 15,393 14,500 11,537 20,000 20,000 20,000 15,000 15,000 5,500 38% Debt Proceeds - - - - - - - - - - - Other Income 12,750 - - - - - - - - - - Transfers In 1,968,000 1,987,140 2,015,041 1,008,000 1,821,486 1,826,582 1,835,022 1,401,475 1,403,893 (193,555) -10% Total Revenue 1,990,701 2,002,533 2,029,541 1,019,537 1,841,486 1,846,582 1,855,022 1,416,475 1,418,893 (188,055) -9% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Debt Service Principal 1,395,912 - 2,918,962 1,431,617 1,338,099 1,383,877 1,434,682 1,045,513 1,086,373 (1,580,863) -54% Interest & Fees 609,185 284,967 811,748 548,169 483,387 442,705 400,340 355,962 317,520 (328,361) -40% Other Services & Charges - - - - - - - - - - - Transfers Out 7,700 15,827 10,000 11,059 20,000 20,000 20,000 15,000 15,000 10,000 100% Total Services & Charges 2,012,797 300,794 3,740,710 1,990,845 1,841,486 1,846,582 1,855,022 1,416,475 1,418,893 (1,899,224) -51% Capital - - - - - - - - - - - Total Expenditures 2,012,797 300,794 3,740,710 1,990,845 1,841,486 1,846,582 1,855,022 1,416,475 1,418,893 (1,899,224) -51% Net Surplus / (Deficit)(22,096) 1,701,739 (1,711,169) (971,308) - - - - - Beginning Cash Balance 50,069 28,105 1,730,279 19,110 19,110 19,110 19,110 19,110 Cash Reserve Cash Adjustments 131 435 - - - - - - Ending Cash Balance 28,105 1,730,279 19,110 19,110 19,110 19,110 19,110 19,110 Cash Reserves Target 28,105 1,730,279 19,110 19,110 19,110 19,110 19,110 19,110 Fund Purpose: 100% cash reserves per bond covenants The purpose of this fund is to disburse principal and interest payments on obligated debt to paying agent trustees. Biannual installments are disbursed at the end of June and December. June's payment includes 50% of the annual interest and December's payment comprises the rest of the interest and all of the principal. 64 City of South Bend, Indiana 2020 Budget Fund 626 - Water Works Bond Reserve Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 13,144 25,420 22,000 16,586 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 13,144 25,420 22,000 16,586 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out 16,000 24,000 22,000 9,582 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Total Services & Charges 16,000 24,000 22,000 9,582 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Capital - - - - - - - - - - - Total Expenditures 16,000 24,000 22,000 9,582 20,000 20,000 20,000 20,000 20,000 (2,000) -9% Net Surplus / (Deficit)(2,856) 1,420 - 7,005 - - - - - Beginning Cash Balance 1,424,915 1,426,658 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 Cash Reserve Cash Adjustments 4,600 (1,765) - - - - - - Ending Cash Balance 1,426,658 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 Cash Reserves Target 1,426,658 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 1,426,313 Fund Purpose: 100% cash reserves per bond covenants and Crowe Horwath The purpose of this fund is to ensure compliance with certain debt service bond covenants. The required cash balance is determined by the debt service financing arrangements at the time of issuance. 65 City of South Bend, Indiana 2020 Budget Fund 629 - Water Works Reserve Operations & Maintenance Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 23,804 47,204 41,000 32,882 40,000 40,000 40,000 40,000 40,000 (1,000) -2% Other Income - - - - - - - - - - - Transfers In 151,272 52,249 225,552 225,552 200,000 - - - - (25,552) -11% Total Revenue 175,076 99,453 266,552 258,434 240,000 40,000 40,000 40,000 40,000 (26,552) -10% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out 23,465 43,905 41,000 32,144 40,000 40,000 40,000 40,000 40,000 (1,000) -2% Total Services & Charges 23,465 43,905 41,000 32,144 40,000 40,000 40,000 40,000 40,000 (1,000) -2% Capital - - - - - - - - - - - Total Expenditures 23,465 43,905 41,000 32,144 40,000 40,000 40,000 40,000 40,000 (1,000) -2% Net Surplus / (Deficit)151,611 55,548 225,552 226,290 200,000 - - - - Beginning Cash Balance 2,457,950 2,617,920 2,670,169 2,895,721 3,095,721 3,095,721 3,095,721 3,095,721 Cash Reserve Cash Adjustments 8,360 (3,299) - - - - - - Ending Cash Balance 2,617,920 2,670,169 2,895,721 3,095,721 3,095,721 3,095,721 3,095,721 3,095,721 Cash Reserves Target 1,933,283 2,003,042 2,602,062 2,486,673 2,432,652 2,426,980 2,472,655 2,509,962 Fund Purpose: 16.67% of annual operating expenses in Fund 620, net of transfers The purpose of this fund is to hold cash reserves equivalent to two months of Water Works' budgeted operating expenses. This serves as fiscal protection against the risk of revenue shortfalls, emergencies, and other economic risks that may impact the Water Utility's ability to meet financial commitments. 66 Utilities - Wastewater 67 City of South Bend, Indiana 2020 Budget Fund 641 - Sewage Works Operations Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services 38,230,235 38,513,117 37,258,510 19,207,667 38,680,677 38,680,914 38,681,152 38,681,393 38,681,393 1,422,167 4% Interest Earnings 132,819 234,125 290,000 182,600 45,000 45,000 45,000 45,000 45,000 (245,000) -84% Other Income 141,989 98,616 57,644 34,800 50,784 51,240 51,701 52,166 52,166 (6,860) -12% Interfund Allocation Reimb - - 421,463 210,725 446,759 458,075 469,553 481,698 494,006 25,296 6% Transfers In 45,349 456,442 284,000 162,549 145,000 145,000 145,000 145,000 145,000 (139,000) -49% Total Revenue 38,550,392 39,302,300 38,311,617 19,798,341 39,368,220 39,380,229 39,392,406 39,405,257 39,417,565 1,056,603 3% Expenditures by Dept Sewer Division (0621)7,216,917 6,335,739 9,390,013 2,646,041 6,803,657 6,982,515 7,072,876 7,173,067 7,256,236 (2,586,356) -28% Concrete Crew (0625)337,481 387,496 516,390 220,514 517,611 531,227 539,145 546,635 554,574 1,221 0% Wastewater Division (0630)30,065,014 29,266,937 34,550,924 22,110,763 34,798,285 30,315,108 30,252,290 30,127,247 30,144,705 247,361 1% Organic Resources (0631)1,288,328 1,557,590 1,683,610 846,234 1,656,029 1,488,293 1,399,294 1,226,279 1,253,653 (27,581) -2% Clay Sewage (0650)895 6,417 2,000 321 - - - - - (2,000) -100% Total Expenditures 38,908,636 37,554,179 46,142,937 25,823,873 43,775,582 39,317,143 39,263,605 39,073,228 39,209,168 (2,367,355) -5% Expenditures by Type Personnel Salaries & Wages 4,931,477 5,069,496 5,074,749 2,309,094 5,162,463 5,227,531 5,293,779 5,360,805 5,436,396 87,714 2% Health Insurance 1,164,977 1,219,920 852,984 365,303 953,806 1,010,506 1,067,206 1,132,006 1,196,806 100,822 12% Fringe Benefits 1,006,475 1,047,926 1,064,699 489,540 1,088,271 1,101,788 1,116,398 1,129,491 1,145,211 23,572 2% Total Personnel 7,102,930 7,337,342 6,992,432 3,163,937 7,204,540 7,339,825 7,477,383 7,622,302 7,778,413 212,108 3% Supplies 1,522,091 1,747,634 2,534,365 809,171 2,215,761 2,251,944 2,305,759 2,348,657 2,389,704 (318,604) -13% Services & Charges Professional Services 1,348,986 1,383,933 2,351,055 555,498 1,617,000 1,643,800 1,671,097 1,698,899 1,727,217 (734,055) -31% Printing & Advertising 1,134 746 3,950 251 3,950 3,950 3,950 3,950 3,950 - 0% Utilities 1,024,579 1,045,885 1,201,775 631,726 1,314,860 1,334,415 1,354,372 1,374,744 1,395,439 113,085 9% Education & Training 11,551 12,948 35,200 13,205 41,500 41,500 41,500 41,500 41,500 6,300 18% Travel 7,878 16,671 44,500 3,157 49,500 49,500 49,500 49,500 49,500 5,000 11% Repairs & Maintenance 2,024,912 1,320,235 2,596,465 1,044,145 2,049,436 2,097,877 2,148,217 2,200,541 2,242,382 (547,029) -21% Other Interfund Allocations 3,343,140 3,820,255 5,730,856 2,865,412 5,650,043 6,009,303 6,119,661 6,253,840 6,384,452 (80,813) -1% Debt Service Principal 654,296 602,115 566,921 280,836 523,738 294,414 188,482 - - (43,183) -8% Interest & Fees 38,478 41,596 25,997 14,096 16,278 7,815 2,935 - - (9,719) -37% Other Services & Charges 3,793,929 2,925,605 6,407,149 1,129,351 2,714,525 2,754,665 2,796,081 2,838,813 2,882,906 (3,692,624) -58% Transfers Out 18,034,733 17,299,215 17,652,272 15,313,088 20,374,451 15,488,135 15,104,668 14,640,482 14,313,705 2,722,179 15% Total Services & Charges 30,283,615 28,469,203 36,616,140 21,850,764 34,355,281 29,725,374 29,480,463 29,102,269 29,041,051 (2,260,859) -6% Capital - - - - - - - - - - - Total Expenditures 38,908,636 37,554,179 46,142,937 25,823,873 43,775,582 39,317,143 39,263,605 39,073,228 39,209,168 (2,367,355) -5% Net Surplus / (Deficit)(358,244) 1,748,121 (7,831,320) (6,025,532) (4,407,362) 63,086 128,801 332,029 208,397 Beginning Cash Balance 13,289,872 13,004,372 15,201,615 7,370,295 2,962,933 3,026,019 3,154,820 3,486,849 Cash Reserve Cash Adjustments 72,744 449,122 - - - - - - Ending Cash Balance 13,004,372 15,201,615 7,370,295 2,962,933 3,026,019 3,154,820 3,486,849 3,695,246 Cash Reserves Target 1,945,432 1,877,709 2,307,147 2,188,779 1,965,857 1,963,180 1,953,661 1,960,458 Fund Purpose: 5% of Annual expenditures This fund accounts for the operations of the following divisions of the Department of Public Works: Wastewater, Sewer, Organic Resources, and Concrete Crew. Wastewater Division: Facilitates the collection, treatment and disposal of wastewater. Responsible for the operation of the treatment facility, which is a conventional activated sludge plant, the interceptor sewer system, the combined sewer overflow (CSO) system and the remote sewage lift stations. Sewer Division: Responsible for sewer maintenance preventative program that cleans and inspects the storm and sanitary sewer system in the City and Clay Township and sewer construction program that repairs sewer mains, catch basins, manholes, and structure raising for the Street Department paving program. Organic Resources Division: Recycles collected yard waste, leaves, and brush for compost and mulch products. 68 City of South Bend, Indiana 2020 Budget Fund 642 - Sewage Works Capital Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services - 691,413 250,000 74,196 300,000 250,000 250,000 250,000 250,000 50,000 20% Interest Earnings 59,733 150,885 155,000 111,115 60,000 60,000 60,000 60,000 60,000 (95,000) -61% Other Income 400,000 - - - - - - - - - - Transfers In 3,942,000 3,219,930 5,000,000 5,000,000 7,911,000 3,052,000 2,690,000 2,210,000 1,862,000 2,911,000 58% Total Revenue 4,401,733 4,062,227 5,405,000 5,185,311 8,271,000 3,362,000 3,000,000 2,520,000 2,172,000 2,866,000 53% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges - - - - - - - - - - - Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Bldgs & Bldg Improve.- - - - - - - - - - - Motor Equipment 854,537 1,029,521 2,396,361 583,494 1,396,000 1,527,000 690,000 495,000 482,000 (1,000,361) -42% Machinery & Equipment 3,415,833 1,261,651 7,859,974 1,377,407 15,000 25,000 - 15,000 30,000 (7,844,974) -100% Infrastructure - - 4,766,957 232,684 6,250,000 1,750,000 2,250,000 1,950,000 1,600,000 1,483,043 31% Total Capital 4,270,370 2,291,171 15,023,292 2,193,586 7,661,000 3,302,000 2,940,000 2,460,000 2,112,000 (7,362,292) -49% Total Expenditures 4,270,370 2,291,171 15,023,292 2,193,586 7,661,000 3,302,000 2,940,000 2,460,000 2,112,000 (7,362,292) -49% Net Surplus / (Deficit)131,363 1,771,056 (9,618,292) 2,991,725 610,000 60,000 60,000 60,000 60,000 Beginning Cash Balance 7,204,341 7,359,724 9,122,983 (495,309) 114,691 174,691 234,691 294,691 Cash Reserve Cash Adjustments 24,020 (7,797) - - - - - - Ending Cash Balance 7,359,724 9,122,983 (495,309) 114,691 174,691 234,691 294,691 354,691 Cash Reserves Target - - - - - - - - Fund Purpose: No reserve requirement - Capital fund - spend down to zero This fund is used to purchase capital equipment and fund major renovations/restorations for the following divisions of the Department of Public Works: Wastewater Division, Sewer Division, Organic Resources Division, and Concrete Crew Division. 69 City of South Bend, Indiana 2020 Budget Fund 643 - Sewage Works Reserve Operations & Maintenance Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 45,976 94,712 119,000 64,041 120,000 120,000 120,000 120,000 120,000 1,000 1% Other Income - - - - - - - - - - - Transfers In 516,755 238,226 151,717 151,717 - - - - - (151,717) -100% Total Revenue 562,731 332,938 270,717 215,758 120,000 120,000 120,000 120,000 120,000 (150,717) -56% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out 45,349 88,247 84,000 62,549 120,000 120,000 120,000 120,000 120,000 36,000 43% Total Services & Charges 45,349 88,247 84,000 62,549 120,000 120,000 120,000 120,000 120,000 36,000 43% Capital - - - - - - - - - - - Total Expenditures 45,349 88,247 84,000 62,549 120,000 120,000 120,000 120,000 120,000 36,000 43% Net Surplus / (Deficit)517,382 244,692 186,717 153,209 - - - - - Beginning Cash Balance 4,627,379 5,160,858 5,399,084 5,585,801 5,585,801 5,585,801 5,585,801 5,585,801 Cash Reserve Cash Adjustments 16,097 (6,466) - - - - - - Ending Cash Balance 5,160,858 5,399,084 5,585,801 5,585,801 5,585,801 5,585,801 5,585,801 5,585,801 Cash Reserves Target 3,479,680 3,376,502 4,749,394 3,900,969 3,972,296 4,027,295 4,072,939 4,150,074 Fund Purpose: 16.67% of annual operating expenses in Fund 641, net of transfers The purpose of this fund is to hold cash reserves equivalent to two months of Sewage Works' budgeted operating expenses (Fund 641). This serves as fiscal protection against the risk of revenue shortfalls, emergencies, and other economic risks that may impact the Sewage Works' ability to meet financial commitments. 70 City of South Bend, Indiana 2020 Budget Fund 649 - Sewage Sinking (Debt Service) Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 46,510 87,392 36,000 26,768 45,000 45,000 45,000 45,000 45,000 9,000 25% Other Income - - - - - - - - - - - Transfers In 9,153,570 9,173,661 7,780,676 7,780,676 7,788,015 7,802,089 7,822,319 7,838,133 7,859,356 7,339 0% Total Revenue 9,200,080 9,261,052 7,816,676 7,807,444 7,833,015 7,847,089 7,867,319 7,883,133 7,904,356 16,339 0% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Debt Service Principal 6,997,472 7,147,038 5,931,732 - 6,076,557 6,236,519 6,406,619 6,581,863 6,767,255 144,825 2% Interest & Fees 2,161,709 2,004,813 1,849,494 923,098 1,708,458 1,562,570 1,412,700 1,253,270 1,089,101 (141,036) -8% Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges 9,159,181 9,151,851 7,781,226 923,098 7,785,015 7,799,089 7,819,319 7,835,133 7,856,356 3,789 0% Capital - - - - - - - - - - - Total Expenditures 9,159,181 9,151,851 7,781,226 923,098 7,785,015 7,799,089 7,819,319 7,835,133 7,856,356 3,789 0% Net Surplus / (Deficit)40,899 109,202 35,450 6,884,346 48,000 48,000 48,000 48,000 48,000 Beginning Cash Balance 814,230 857,884 966,030 1,001,480 1,049,480 1,097,480 1,145,480 1,193,480 Cash Reserve Cash Adjustments 2,755 (1,056) - - - - - - Ending Cash Balance 857,884 966,030 1,001,480 1,049,480 1,097,480 1,145,480 1,193,480 1,241,480 Cash Reserves Target 857,884 966,030 1,001,480 1,049,480 1,097,480 1,145,480 1,193,480 1,241,480 Fund Purpose: 100% cash reserves per bond covenants This fund is used to pay all debt service obligations for Sewage Works. 71 City of South Bend, Indiana 2020 Budget Fund 653 - Sewage Debt Service Reserve Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings 26,716 65,897 42,000 39,049 45,000 45,000 45,000 45,000 45,000 3,000 7% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 26,716 65,897 42,000 39,049 45,000 45,000 45,000 45,000 45,000 3,000 7% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges - - - - - - - - - - - Capital - - - - - - - - - - - Total Expenditures - - - - - - - - - - - Net Surplus / (Deficit)26,716 65,897 42,000 39,049 45,000 45,000 45,000 45,000 45,000 Beginning Cash Balance 4,111,633 4,138,349 4,204,246 4,246,246 4,291,246 4,336,246 4,381,246 4,426,246 Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance 4,138,349 4,204,246 4,246,246 4,291,246 4,336,246 4,381,246 4,426,246 4,471,246 Cash Reserves Target 4,138,349 4,204,246 4,246,246 4,291,246 4,336,246 4,381,246 4,426,246 4,471,246 Fund Purpose: 100% cash reserves per bond covenants and Crowe Horwath This fund accounts for required debt service reserves as required by bond documents. 72 City of South Bend, Indiana 2020 Budget Fund 654 - Sewage Works Customer Deposit Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Interest Earnings - - - - 25,000 25,000 25,000 25,000 25,000 25,000 - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue - - - - 25,000 25,000 25,000 25,000 25,000 25,000 - Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Transfers Out - - - - 25,000 25,000 25,000 25,000 25,000 25,000 - Total Services & Charges - - - - 25,000 25,000 25,000 25,000 25,000 25,000 - Capital - - - - - - - - - - - Total Expenditures - - - - 25,000 25,000 25,000 25,000 25,000 25,000 - Net Surplus / (Deficit)- - - - - - - - - Beginning Cash Balance - - - - - - - - Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance - - - - - - - - Cash Reserves Target - - - - - - - - Fund Purpose: 100% cash reserves for customer deposits This fund was established to retain the security deposits collected from utility customers. Upon termination of service, the security deposited is refunded in the form of a credit to the customer's final bill. 73 City of South Bend, Indiana 2020 Budget Fund 667 - Storm Sewer Fund Fund Type Enterprise Funds Control City Funds 2019 2020 Budget 2017 2018 Amended 06/30/19 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2021 2022 2023 2024 2019-2020 Change Revenue Charges for Services - - 600,000 6,723 1,041,360 1,041,360 1,041,360 1,041,360 1,041,360 441,360 74% Interest Earnings - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue - - 600,000 6,723 1,041,360 1,041,360 1,041,360 1,041,360 1,041,360 441,360 74% Expenditures by Type Personnel Salaries & Wages - - - - - - - - - - - Fringe Benefits - - - - - - - - - - - Total Personnel - - - - - - - - - - - Supplies - - - - - - - - - - - Services & Charges Professional Services - - 100,000 13,275 - - - - - (100,000) -100% Other Services & Charges - - - - - - - - - - - Transfers Out - - - - - - - - - - - Total Services & Charges - - 100,000 13,275 - - - - - (100,000) -100% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Bldgs & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure - - 500,000 23,677 825,000 1,000,000 1,035,000 1,035,000 1,040,000 325,000 65% Total Capital - - 500,000 23,677 825,000 1,000,000 1,035,000 1,035,000 1,040,000 325,000 65% Total Expenditures - - 600,000 36,952 825,000 1,000,000 1,035,000 1,035,000 1,040,000 225,000 38% Net Surplus / (Deficit)- - - (30,229) 216,360 41,360 6,360 6,360 1,360 Beginning Cash Balance - - - - 216,360 257,720 264,080 270,440 Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance - - - 216,360 257,720 264,080 270,440 271,800 Cash Reserves Target - - 150,000 206,250 250,000 258,750 258,750 260,000 Fund Purpose: 25% of Annual expenditures On January 14, 2019, the Common Council passed an ordinance to establish a storm water user fee (ordinance 10633-19). This fund was established to track receipt of the storm water fee revenue and expense of that revenue on storm water projects. - The storm sewer system consist of sewers, storm inlets, catch basins, manholes, curbs, gutters, ditches, swales, retention and/or detention ponds or basins, dams, and flood control facilities designed for the collection, control, transport or discharge of stormwater. A stormwater utility fee is a fee that produces revenue dedicated to improving drainage, controlling flooding, improving water quality and implementing regulations. What is a storm sewer system? - The storm sewer system consists of sewers, storm inlets, catch basins, manholes, curbs, gutters, ditches, swales, retention and/or detention ponds or basins, dams, and flood control facilities designed for the collection, control, transport or discharge of stormwater. What is a storm sewer utility fee? - A storm sewer utility fee is a fee that produces revenue dedicated to improving drainage, controlling flooding, improving water quality and implementing regulations. The fee is charged to a property based on the potential runoff resulting from a property in a storm event. Why is the fee necessary? - Aging infrastructure - Unresolved issues - Equity - Funding - Mandatory The state of the Infrastructure: Aging infrastructure is all around us. These buried assets are often forgotten about. Key Issues: - Flooding – real, growing and unresolved: alleviate pressure on Sanitary/Combined and add sewers where non-existant - Infrastructure – aging, failing - Quality of life – service values and property values - Sustainability: green approaches to storm and MS-4 Compliance How to Fund a Storm Utilty How was the management and operation of storm sewer funded before the fee? - Little funding has been available. The funding that has been provided was through Wastewater and Road funding. How is the fee calculated? - The fee structure is based on a flat rate of $2/residential customer/month and a tiered rate for non- residential customer/month of $4, $8, or $20 depending on the amount of impervious surface. Are any properties exempt? - All properties are subject to the storm sewer utility fee, except unimproved lots and the pubic right- of-way. Storm Sewer Capital Needs Professional Services - Riverbank Stabilization - $200,000 - Downspout Disconnection Plan - $100,000 Capital Improvement Projects - Drainage Projects - $800,000 - Riverbank Stabilization - $150,000 - South Bend Dam - $500,000 - Flood Mitigation - $500,000 - Western Avenue Phase III Storm Sewer - $400,000 - Michigan Street Separation - $250,000 Operations & Maintenance - TBD in the future Total Expenses: $2.9M 74 2020 Proposed Staffing Summary City of South Bend Fund Department Position Status FTE 2019 Salary Cap Proposed % Increase 2020 Salary Cap 101-0602 Engineering Administrative Assistant I NB 1 41,336$ 2.0%42,163$ 101-0602 Engineering Administrative Assistant II NB 1 42,558$ 2.0%43,409$ 101-0602 Engineering Assistant City Engineer NB 3 85,568$ 2.0%87,279$ 101-0602 Engineering City Engineer NB 1 106,423$ 2.0%108,551$ 101-0602 Engineering Deputy Director of Public Works NB 1 99,367$ 2.0%101,354$ 101-0602 Engineering Director of CSO Project Management NB 1 85,172$ 2.0%86,875$ 101-0602 Engineering Director of Marketing - Public Works NB 1 67,018$ 2.0%68,358$ 101-0602 Engineering Director of Public Works NB 1 121,904$ 2.0%124,342$ 101-0602 Engineering Director of Redevelopment Engineering NB 1 101,167$ 2.0%103,190$ 101-0602 Engineering Engineer I NB 5 69,276$ 2.0%70,662$ 101-0602 Engineering Executive Assistant & Director of Special Projects NB 1 55,251$ 2.0%56,356$ 101-0602 Engineering Manager - Permits NB 1 50,414$ 2.0%51,422$ 101-0602 Engineering Manager - Public Construction NB 1 69,080$ 2.0%70,462$ 101-0602 Engineering Project Inspector NB 4 55,279$ 2.0%56,385$ Total FTES - Engineering 23 101-0616 Sustainability / AmeriCorps Director of Office of Sustainability NB 1 83,620$ 2.0%85,292$ 101-0628 Sustainability / AmeriCorps Manager - Operations - AmeriCorps NB 1 40,800$ 12.7%46,000$ 101-0628 Sustainability / AmeriCorps Program Director - AmeriCorps NB 1 56,100$ 2.0%57,222$ Total FTES - Sustainability & AmeriCorps 3 202-0607 Streets & Sewers Director of Financial Services NB 1 67,885$ 2.0%69,243$ 202-0607 Streets & Sewers Director of Streets & Sewers NB 1 86,489$ 2.0%88,219$ 202-0607 Streets & Sewers Manager - Streets NB 1 68,042$ 2.0%69,403$ 202-0607 Streets & Sewers Manager - Traffic & Lighting NB 1 68,042$ 2.0%69,403$ 202-0607 Streets & Sewers Superintendent III NB 2 53,490$ 2.0%54,560$ 202-0607 Streets & Sewers Superintendent IV NB 1 56,308$ 2.0%57,434$ 202-0607 Streets & Sewers Superintendent V NB 1 58,716$ 2.0%59,890$ 202-0607 Streets & Sewers Equipment Operator II TM 7.5 37,294$ 1.0%37,667$ 202-0607 Streets & Sewers Equipment Operator III TM 0.5 38,751$ 1.0%39,139$ 202-0607 Streets & Sewers General Laborer TM 1.0 34,175$ 1.0%34,517$ 202-0607 Streets & Sewers Heavy Equipment Operator I TM 0.5 40,207$ 1.0%40,609$ 202-0607 Streets & Sewers Heavy Equipment Operator II TM 5.5 41,184$ 1.0%41,596$ 202-0607 Streets & Sewers Job Leaders TM 2.0 42,390$ 1.0%42,814$ 202-0607 Streets & Sewers Operations Tech Job Leader TM 0.5 42,391$ 1.0%42,815$ 202-0607 Streets & Sewers Operations Technicians TM 1.5 37,815$ 1.0%38,193$ 202-0607 Streets & Sewers Sign Artist Job Leader TM 0.5 42,391$ 1.0%42,815$ 202-0607 Streets & Sewers Signal Tech Job Leader TM 0.5 42,391$ 1.0%42,815$ 202-0607 Streets & Sewers Signal Technician II TM 2.0 40,893$ 1.0%41,302$ 202-0619 Streets & Sewers Superintendent V NB 1 58,716$ 2.0%59,890$ 202-0619 Streets & Sewers Concrete Finisher TM 6 41,891$ 1.0%42,310$ 202-0619 Streets & Sewers Job Leader TM 1 43,327$ 1.0%43,760$ 266-0607 Streets & Sewers Equipment Operator II TM 7.5 37,294$ 1.0%37,667$ 266-0607 Streets & Sewers Equipment Operator III TM 0.5 38,751$ 1.0%39,139$ 266-0607 Streets & Sewers Heavy Equipment Operator I TM 0.5 40,207$ 1.0%40,609$ 266-0607 Streets & Sewers Heavy Equipment Operator II TM 5.5 41,184$ 1.0%41,596$ 266-0607 Streets & Sewers Job Leaders TM 2.0 42,390$ 1.0%42,814$ 266-0607 Streets & Sewers Operations Tech Job Leader TM 0.5 42,391$ 1.0%42,815$ 266-0607 Streets & Sewers Operations Technicians TM 1.5 37,815$ 1.0%38,193$ 266-0607 Streets & Sewers Sign Artist Job Leader TM 0.5 42,391$ 1.0%42,815$ 266-0607 Streets & Sewers Signal Tech Job Leader TM 0.5 42,391$ 1.0%42,815$ 266-0607 Streets & Sewers Signal Technician II TM 2.0 40,893$ 1.0%41,302$ 640-0620 Streets & Sewers Superintendent V NB 1 58,716$ 2.0%59,890$ 640-0620 Streets & Sewers Job Leader TM 1 43,327$ 1.0%43,760$ 641-0621 Streets & Sewers Administrative Assistant I NB 1 41,336$ 2.0%42,163$ 641-0621 Streets & Sewers Administrative Assistant II NB 1 42,558$ 2.0%43,409$ 641-0621 Streets & Sewers Manager - Sewer Operations NB 1 68,931$ 2.0%70,310$ 641-0621 Streets & Sewers Superintendent III NB 1 53,490$ 2.0%54,560$ 641-0621 Streets & Sewers Superintendent V NB 2 58,716$ 2.0%59,890$ 641-0621 Streets & Sewers Equipment Operator II TM 5 37,295$ 1.0%37,668$ 641-0621 Streets & Sewers Equipment Operator III - Sweepers TM 5 38,959$ 1.0%39,349$ 641-0621 Streets & Sewers Equipment Operator III - Vactors TM 4 38,959$ 1.0%39,349$ 641-0621 Streets & Sewers Heavy Equipment Operator I TM 10 40,206$ 1.0%40,608$ 641-0621 Streets & Sewers Job Leader TM 5 43,326$ 1.0%43,759$ 75 2020 Proposed Staffing Summary City of South Bend Fund Department Position Status FTE 2019 Salary Cap Proposed % Increase 2020 Salary Cap 641-0625 Streets & Sewers Concrete Finishers TM 3 41,891$ 1.0%42,310$ 641-0625 Streets & Sewers Job Leader TM 1 43,327$ 1.0%43,760$ Total FTES - Streets & Sewers 100 610-0610 Solid Waste Administrative Assistant I NB 1 41,336$ 2.0%42,163$ 610-0610 Solid Waste Director of Solid Waste NB 1 73,140$ 2.0%74,603$ 610-0610 Solid Waste Secretary V NB 1 34,764$ 2.0%35,459$ 610-0610 Solid Waste Superintendent V NB 2 58,716$ 2.0%59,890$ 610-0610 Solid Waste Driver TM 15 38,709$ 1.0%39,096$ 610-0610 Solid Waste Job Leader TM 2 42,307$ 1.0%42,730$ 610-0610 Solid Waste Picker I TM 2 36,982$ 1.0%37,352$ Total FTES - Solid Waste 24 620-0640 Water Works Assistant Director of Utilities NB 1 86,489$ 2.0%88,219$ 620-0640 Water Works Assistant Manager - Customer Service NB 1 48,379$ 2.0%49,347$ 620-0640 Water Works Director of Customer Service & Billing Office NB 1 75,641$ 2.0%77,154$ 620-0640 Water Works Director of Distribution (was Manager-Operations)NB 1 71,394$ 12.1%80,000$ 620-0640 Water Works Engineer Aide IV NB 1 43,096$ 2.0%43,958$ 620-0640 Water Works Financial Specialist III NB 1 44,500$ 2.0%45,390$ 620-0640 Water Works Financial Specialist IV NB 3 49,277$ 2.0%50,263$ 620-0640 Water Works Locator NB 1 43,903$ 2.0%44,781$ 620-0640 Water Works Manager - Billing and Customer Accounts NB 1 58,566$ 2.0%59,737$ 620-0640 Water Works Manager - Customer Service NB 1 56,500$ 2.0%57,630$ 620-0640 Water Works Manager - Distribution Services and Records (was Distribution Records Drafter)NB 1 43,096$ 20.7%52,000$ 620-0640 Water Works Manager - Maintenance NB 2 66,856$ 2.0%68,193$ 620-0640 Water Works Manager - Meter Service NB 1 66,855$ 2.0%68,192$ 620-0640 Water Works Manager - Operations NB 1 71,394$ 2.0%72,822$ 620-0640 Water Works Manager - Service Line Repair NB 1 66,855$ 2.0%68,192$ 620-0640 Water Works Quality Assurance Distribution Technician NB 1 43,485$ 2.0%44,355$ 620-0640 Water Works Supervisor - Operations NB 2 61,195$ 2.0%62,419$ 620-0640 Water Works System Specialist III NB 1 61,703$ 2.0%62,937$ 620-0640 Water Works Utilities System Specialist NB 1 57,463$ 2.0%58,612$ 620-0640 Water Works Water Quality Specialist NB 1 59,762$ 2.0%60,957$ 620-0640 Water Works Auditor I TM 1 36,899$ 1.0%37,268$ 620-0640 Water Works Auditor II TM 2 39,291$ 1.0%39,684$ 620-0640 Water Works Customer Service & Billing TM 4 34,694$ 1.0%35,041$ 620-0640 Water Works Data Processor TM 3 38,314$ 1.0%38,697$ 620-0640 Water Works Field Repairman/Inspector I TM 2 40,248$ 1.0%40,650$ 620-0640 Water Works Field Repairman/Inspector II TM 1 40,768$ 1.0%41,176$ 620-0640 Water Works Field Repairman/Inspector III TM 1 41,090$ 1.0%41,501$ 620-0640 Water Works Group Leader-Meter Reading TM 1 40,664$ 1.0%41,071$ 620-0640 Water Works Heavy Equipment Operator II TM 4 41,662$ 1.0%42,079$ 620-0640 Water Works Job Leader TM 5 42,307$ 1.0%42,730$ 620-0640 Water Works Machinist TM 1 40,768$ 1.0%41,176$ 620-0640 Water Works Maintenance Tech I TM 3 37,398$ 1.0%37,772$ 620-0640 Water Works Maintenance Tech II TM 4 39,749$ 1.0%40,146$ 620-0640 Water Works Meter Serviceman IV TM 8 38,043$ 1.0%38,423$ 620-0640 Water Works Operator II TM 3 37,296$ 1.0%37,669$ Total FTES - Water Works 67 641-0630 Wastewater Administrative Assistant I NB 1 41,336$ 2.0%42,163$ 641-0630 Wastewater Assistant Director of SCADA Information Systems NB 1 68,931$ 2.0%70,310$ 641-0630 Wastewater Chemist NB 3 51,549$ 2.0%52,580$ 641-0630 Wastewater Chemist Lead NB 1 54,833$ 2.0%55,930$ 641-0630 Wastewater Director of SCADA Information Systems NB 1 79,494$ 2.0%81,084$ 641-0630 Wastewater Director of Utilities NB 1 97,419$ 2.0%99,367$ 641-0630 Wastewater Director of Utility Safety NB 1 56,774$ 2.0%57,909$ 641-0630 Wastewater Director of Wastewater Maintenance NB 1 74,285$ 2.0%75,771$ 641-0630 Wastewater Director of Water Quality & Laboratory NB 1 74,285$ 2.0%75,771$ 641-0630 Wastewater Industrial Pretreatment Specialist I NB 1 54,864$ 2.0%55,961$ 641-0630 Wastewater Manager - Environmental Compliance NB 1 71,776$ 2.0%73,212$ 641-0630 Wastewater Manager - Industrial Pretreatment NB 1 62,612$ 2.0%63,864$ 641-0630 Wastewater Manager - Maintenance NB 1 66,856$ 2.0%68,193$ 76 2020 Proposed Staffing Summary City of South Bend Fund Department Position Status FTE 2019 Salary Cap Proposed % Increase 2020 Salary Cap 641-0630 Wastewater Manager - Operations NB 2 71,394$ 2.0%72,822$ 641-0630 Wastewater Manager - Utility Purchasing & Storeroom NB 1 54,121$ 2.0%55,203$ 641-0630 Wastewater SCADA Instrument Specialist NB 1 58,149$ 2.0%59,312$ 641-0630 Wastewater Superintendent V NB 1 58,716$ 2.0%59,890$ 641-0630 Wastewater CSO Rep II TM 2 41,184$ 1.0%41,596$ 641-0630 Wastewater General Laborer TM 1 34,174$ 1.0%34,516$ 641-0630 Wastewater Lift Station Rep. II TM 2 42,931$ 1.0%43,360$ 641-0630 Wastewater Maintenance Electrician V TM 1 47,362$ 1.0%47,836$ 641-0630 Wastewater Maintenance Lead TM 1 48,027$ 1.0%48,507$ 641-0630 Wastewater Maintenance Repair IV TM 4 44,637$ 1.0%45,083$ 641-0630 Wastewater Operator - General TM 5 41,184$ 1.0%41,596$ 641-0630 Wastewater Operator - Lead TM 2 48,027$ 1.0%48,507$ 641-0630 Wastewater Operator - Senior TM 4 42,931$ 1.0%43,360$ 641-0630 Wastewater Sanitation Operator TM 2 35,922$ 1.0%36,281$ 641-0631 Organic Resources Administrative Assistant I NB 1 41,336$ 2.0%42,163$ 641-0631 Organic Resources Supervisor - Operations NB 1 61,195$ 2.0%62,419$ 641-0631 Organic Resources Heavy Equipment Operator II TM 4 41,184$ 1.0%41,596$ Total FTES - Wastewater & Organic Resources 50 Total FTES - Public Works 267 77 CITY OF SOUTH BEND, IN Public Works Director of Public Works Deputy Director of Public Works Director of Office of Sustainability Program Director - AmeriCorps Manager - Operations - AmeriCorps Director of Streets & Sewers Director of Financial Services Manager -Streets Superintendent V (42) Manager -Sewer Operations Superintendent V (13) Superintendent V (10) Superintendent V (12) (Concrete Team) Superintendent V (1) Manager -Traffic & Lighting Superintendent V (9) City Engineer Assistant City Engineer Assistant City Engineer (2) Engineer I (5) Director of Redevelopment Engineering (1) Director of CSO Project Management (1) Public Construction Manager Project Inspectors (4) Director of Utilities Assistant Director of Utilities Director of Water Quality & Laboratory (6) Director of Customer Service & Billing Office (19) Manager – Customer Service Manager –Billing and Customer AccountsManager - Operations (16) Manager - Operations (12) Manager - Pretreatment (1) Director of Waste Water Maintenance (15) Manager - Environmental Compliance Director of Distribution (32) Manager- Distribution Services & Records Manager –Meter Service Manager – Service Line Repair Manager - Operations (2) Director of Utility Safety Director of SCADA Information Systems (1) Director of Solid Waste Superintendent V (11) Superintendent V (11) Executive Assistant (3) Director of Marketing Key Existing Position, Standard Raise Existing Position, Raise > 2% New Position 78 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 101-0602-431.10-01 SALARIED WAGES Engineering Salaries & Wages 512,310 591,535 1,663,887 1,663,887 674,888 1,697,169 1,875,263 1,912,773 1,951,024 1,990,045 101-0602-431.10-03 SEASONAL & INTERNS Engineering Salaries & Wages 12,950 26,955 37,440 37,440 978 37,440 37,440 37,440 37,440 37,440 101-0602-431.10-04 EXTRA AND OVERTIME Engineering Salaries & Wages 367 - - - - - - - - - 101-0602-431.10-09 PERMANENT PART-TIME Engineering Salaries & Wages 16,036 31,641 106,409 106,409 26,137 106,409 106,409 106,409 106,409 106,409 101-0602-431.10-10 HIRING BONUS Engineering Salaries & Wages - 1,410 - - - - - - - - 101-0602-431.11-01 FICA - REGULAR Engineering Fringe Benefits 41,461 49,266 140,111 140,111 53,636 142,688 156,310 159,182 162,108 165,093 101-0602-431.11-04 PERF - REGULAR Engineering Fringe Benefits 57,067 67,094 189,019 189,019 76,940 192,791 212,737 216,939 221,224 225,592 101-0602-431.11-07 UNEMPLOYMENT COMP Engineering Fringe Benefits - - - - - 170 563 957 1,366 1,793 101-0602-431.11-08 HEALTH INSURANCE Engineering Fringe Benefits 82,974 120,048 197,688 197,688 79,277 247,159 350,880 362,380 385,380 408,380 101-0602-431.11-09 LIFE INSURANCE Engineering Fringe Benefits 900 1,063 2,760 2,760 1,155 2,760 3,000 3,000 3,000 3,000 101-0602-431.11-11 SHOE ALLOWANCE Engineering Fringe Benefits 65 130 260 390 195 320 320 320 320 320 101-0602-431.11-12 AUTO ALLOWANCE Engineering Fringe Benefits 2,259 2,241 12,300 12,170 5,125 12,300 12,300 12,300 12,300 12,300 101-0602-431.11-22 PARKING ALLOWANCE Engineering Fringe Benefits 1,148 1,260 1,260 1,260 525 1,260 1,260 1,260 1,260 1,260 101-0602-431.11-24 CELL PHONE ALLOWANCE Engineering Fringe Benefits 4,083 4,767 11,220 11,220 5,115 11,880 11,880 11,880 11,880 11,880 101-0602-431.11-29 PARENTAL LEAVE Engineering Fringe Benefits - 1,541 4,160 4,160 1,598 5,940 8,439 8,608 8,778 8,955 101-0602-431.21-01 OFFICIAL RECORDS Engineering Supplies 608 893 750 750 - 750 750 750 750 750 101-0602-431.21-02 PRINT SHOP Engineering Supplies 667 116 400 400 - 400 400 400 400 400 101-0602-431.21-03 C.S. OFFICE SUPPLIES Engineering Supplies 615 1,002 1,250 1,250 - - - - - - 101-0602-431.21-04 OFFICE SUPPLIES Engineering Supplies 4,189 3,926 9,600 10,089 2,996 9,600 9,600 9,600 9,600 9,600 101-0602-431.21-05 SMALL OFFICE EQUIPMENT Engineering Supplies 6,273 1,463 - - - - - - - - 101-0602-431.22-01 C.S. GASOLINE Engineering Supplies 1,499 1,425 1,750 1,750 412 2,250 2,250 2,250 2,250 2,250 101-0602-431.22-24 OTHER OPERATING SUPPLIES Engineering Supplies 987 31 3,600 7,613 4,491 3,600 3,600 3,600 3,600 3,600 101-0602-431.22-60 COMPUTER SUPPLIES/EQUIP Engineering Supplies 8,968 - - - - - - - - - 101-0602-431.23-20 SMALL TOOLS & EQUIPMENT Engineering Supplies 330 3,648 5,300 5,300 668 5,300 4,900 4,750 4,500 4,500 101-0602-431.23-99 OTHER R&M SUPPLIES Engineering Supplies 88 1,026 1,800 1,800 - 1,200 1,200 1,200 1,200 1,200 101-0602-431.31-01 LEGAL SERVICES Engineering Professional Services - - 10,000 10,000 - 10,000 10,000 10,000 10,000 10,000 101-0602-431.31-06 OTHER PROFESSIONAL SVCS Engineering Professional Services 116,007 118,203 140,000 342,919 81,862 150,000 150,000 148,000 147,000 147,000 101-0602-431.31-70 ADM FEE ALLOCATION Engineering Other Interfund Allocations 38,688 45,996 55,204 55,204 23,004 117,035 125,754 128,269 130,834 133,451 101-0602-431.31-71 CENTRAL STORES ALLOCATION Engineering Other Interfund Allocations 660 1,600 2,191 2,191 910 - - - - - 101-0602-431.31-73 PRINT SHOP ALLOCATION Engineering Other Interfund Allocations 2,748 2,962 3,459 3,459 1,443 1,635 1,484 1,456 1,487 1,518 101-0602-431.31-76 IT ALLOCATION Engineering Other Interfund Allocations 197,664 279,301 276,287 276,287 115,119 276,638 332,429 329,324 330,028 331,240 101-0602-431.31-78 LIABILITY INSURANCE ALLOC Engineering Other Interfund Allocations - - 28,225 28,225 11,761 24,767 31,939 32,578 33,230 33,895 101-0602-431.32-02 POSTAGE Engineering Other Services & Charges 1,267 960 2,000 2,000 1,163 2,000 2,000 2,000 2,000 2,000 101-0602-431.32-03 TRAVEL Engineering Travel - - 14,900 14,900 7,439 15,250 15,250 13,500 13,500 13,500 101-0602-431.32-21 TRAVEL - MILEAGE Engineering Travel 508 1,027 - - - - - - - - 101-0602-431.32-22 TRAVEL - AIRFARE Engineering Travel 6,829 4,763 - - - - - - - - 101-0602-431.32-23 TRAVEL - HOTEL Engineering Travel 6,948 4,763 - 1,500 - - - - - - 101-0602-431.32-24 TRAVEL - MEALS Engineering Travel 1,008 758 - - - - - - - - 101-0602-431.32-25 TRAVEL - OTHER Engineering Travel 919 424 - - - - - - - - 101-0602-431.33-01 OUTSIDE PRINTING SERVICES Engineering Printing & Advertising 330 861 5,000 5,000 1,020 4,500 4,400 4,300 4,200 4,100 101-0602-431.33-02 PUBLICATION LEGAL NOTICE Engineering Printing & Advertising 70 1,404 2,000 2,000 989 2,000 2,000 2,000 2,000 2,000 101-0602-431.34-02 LIABILITY INSURANCE Engineering Other Interfund Allocations 14,736 14,772 - - - - - - - - 101-0602-431.36-01 BUILDING & STREET MAINT Engineering Repairs & Maintenance - 13,392 21,000 17,300 - 21,000 21,000 21,000 21,000 21,000 101-0602-431.36-02 OFFICE EQUIP R&M Engineering Repairs & Maintenance 3,178 3,118 2,500 2,500 - 1,500 1,500 1,500 1,500 1,500 101-0602-431.36-03 AUTO EQUIPMENT R&M Engineering Repairs & Maintenance 4,586 3,478 4,000 3,800 675 4,000 4,000 4,000 4,000 4,000 101-0602-431.36-04 COMPUTER EQUIP R&M Engineering Repairs & Maintenance - - - - - - - - - - 101-0602-431.37-11 CAPITAL LEASE PRINCIPAL Engineering Debt Service 28,092 20,605 - - - - - - - - 101-0602-431.37-12 CAPITAL LEASE INTEREST Engineering Debt Service 1,135 684 - - - - - - - - 101-0602-431.38-01 PRINCIPAL Engineering Debt Service - - 14,637 14,637 7,293 10,755 4,493 - - - 101-0602-431.38-02 INTEREST Engineering Debt Service - - 408 408 232 194 51 - - - 101-0602-431.39-01 REFNDS,AWARDS,INDEMNITIES Engineering Other Services & Charges 2,290 - - 3,700 3,698 1,800 1,800 1,200 1,200 1,000 101-0602-431.39-10 SUBSCRIPTIONS Engineering Other Services & Charges 172 887 900 900 - 1,000 1,000 1,000 1,000 1,000 101-0602-431.39-11 DUES & MEMBERSHIPS Engineering Other Services & Charges 2,309 3,615 3,900 3,900 1,930 4,000 4,000 4,000 4,000 4,000 79 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 101-0602-431.39-39 BANK CREDIT CARD CHARGES Engineering Other Services & Charges 443 552 515 515 251 500 500 500 500 500 101-0602-431.39-70 EDUCATION & TRAINING Engineering Education & Training 8,359 24,323 21,000 21,000 6,998 21,000 21,000 21,000 21,000 21,000 101-0602-431.39-89 MISC CHARGES & SVCS Engineering Other Services & Charges 2,140 11,774 12,000 12,110 5,332 12,000 12,000 12,000 12,000 12,000 101-0616-419.10-01 SALARIED WAGES Sustainability Salaries & Wages - - 81,142 81,142 34,254 85,292 136,978 139,718 142,513 145,363 101-0616-419.10-09 PERMANENT PART-TIME Sustainability Salaries & Wages - - 17,160 17,160 - 24,960 - - - - 101-0616-419.11-01 FICA - REGULAR Sustainability Fringe Benefits - - 7,571 7,571 2,587 8,484 10,580 10,789 11,003 11,221 101-0616-419.11-04 PERF - REGULAR Sustainability Fringe Benefits - - 9,162 9,162 3,867 9,627 15,490 15,797 16,109 16,428 101-0616-419.11-08 HEALTH INSURANCE Sustainability Fringe Benefits - - 10,056 10,056 4,190 11,610 30,221 31,221 33,221 35,221 101-0616-419.11-09 LIFE INSURANCE Sustainability Fringe Benefits - - 120 120 50 120 240 240 240 240 101-0616-419.11-24 CELL PHONE ALLOWANCE Sustainability Fringe Benefits - - 660 660 275 660 1,320 1,320 1,320 1,320 101-0616-419.11-29 PARENTAL LEAVE Sustainability Fringe Benefits - - 203 203 86 299 616 628 641 654 101-0616-419.21-02 PRINT SHOP Sustainability Supplies - - 150 150 4 150 150 150 150 150 101-0616-419.21-03 C.S. OFFICE SUPPLIES Sustainability Supplies - - 150 150 - - - - - - 101-0616-419.21-04 OFFICE SUPPLIES Sustainability Supplies - - 22,000 22,000 3,574 23,800 15,800 15,800 15,800 15,800 101-0616-419.31-01 LEGAL SERVICES Sustainability Professional Services - - 15,000 15,000 - 10,000 10,000 100,000 100,000 101-0616-419.31-06 OTHER PROFESSIONAL SVCS Sustainability Professional Services - - 70,000 70,000 18,451 180,000 165,000 90,000 90,000 90,000 101-0616-419.31-73 PRINT SHOP ALLOCATION Sustainability Other Interfund Allocations - - - - - 24 22 21 22 22 101-0616-419.31-76 IT ALLOCATION Sustainability Other Interfund Allocations - - 32,367 32,367 8,013 9,149 18,375 18,204 18,242 18,310 101-0616-419.31-78 LIABILITY INSURANCE ALLOC Sustainability Other Interfund Allocations - - - - - 591 663 676 690 704 101-0616-419.32-03 TRAVEL Sustainability Travel - - 6,374 6,374 - 3,800 3,800 3,800 3,800 3,800 101-0616-419.33-03 PROMOTIONAL Sustainability Printing & Advertising - - 500 500 - 500 500 500 500 500 101-0616-419.39-11 DUES & MEMBERSHIPS Sustainability Other Services & Charges - - 1,800 1,800 - 4,500 5,300 5,500 5,700 5,900 101-0616-419.39-70 EDUCATION & TRAINING Sustainability Education & Training - - 2,800 2,800 18 2,800 2,800 2,800 2,800 2,800 101-0616-419.39-89 MISC CHARGES & SVCS Sustainability Other Services & Charges - - 1,600 1,600 196 1,200 1,200 1,200 1,200 1,200 101-0628-419.10-01 SALARIED WAGES Sustainability Salaries & Wages - 13,424 95,000 98,000 65,298 103,222 105,286 107,391 109,539 111,729 101-0628-419.10-03 SEASONAL & INTERNS Sustainability Salaries & Wages - - - 217,000 - 159,500 175,450 192,995 212,295 233,524 101-0628-419.11-01 FICA - REGULAR Sustainability Fringe Benefits - 999 7,368 7,368 4,691 20,199 21,577 23,081 24,722 26,514 101-0628-419.11-04 PERF - REGULAR Sustainability Fringe Benefits - 837 10,788 10,788 3,946 11,709 11,940 12,176 12,416 12,662 101-0628-419.11-07 UNEMPLOYMENT COMP Sustainability Fringe Benefits - - - - - 11 32 54 77 101 101-0628-419.11-08 HEALTH INSURANCE Sustainability Fringe Benefits - 1,296 20,112 20,112 7,095 23,221 30,221 31,221 33,221 35,221 101-0628-419.11-09 LIFE INSURANCE Sustainability Fringe Benefits - 10 240 240 85 240 240 240 240 240 101-0628-419.11-24 CELL PHONE ALLOWANCE Sustainability Fringe Benefits - 110 1,320 1,320 550 1,320 1,320 1,320 1,320 1,320 101-0628-419.11-29 PARENTAL LEAVE Sustainability Fringe Benefits - - 238 238 - 361 474 483 493 503 101-0628-419.21-02 PRINT SHOP Sustainability Supplies - - 200 200 - 200 230 265 304 350 101-0628-419.21-03 C.S. OFFICE SUPPLIES Sustainability Supplies - - 150 150 - - - - - - 101-0628-419.21-04 OFFICE SUPPLIES Sustainability Supplies - 24 56,240 94,436 124 2,600 2,860 3,146 3,461 3,807 101-0628-419.22-06 COMPUTER SUPPLIES Sustainability Supplies - 29 - 13,971 154 250 250 250 250 250 101-0628-419.23-20 SMALL TOOLS & EQUIPMENT Sustainability Supplies - - - 20,000 4,436 46,000 45,400 45,400 45,400 45,400 101-0628-419.31-06 OTHER PROFESSIONAL SVCS Sustainability Professional Services - - 228,368 204,868 1,217 44,051 46,131 50,619 55,556 46,131 101-0628-419.32-03 TRAVEL Sustainability Travel - - 4,853 9,706 1,394 10,006 11,007 12,107 13,318 14,650 101-0628-419.33-03 PROMOTIONAL Sustainability Printing & Advertising - - 1,000 1,000 - 1,000 1,000 1,000 1,000 1,000 101-0628-419.39-11 DUES & MEMBERSHIPS Sustainability Other Services & Charges - - 1,200 2,400 250 2,530 2,530 2,530 2,530 2,530 101-0628-419.39-30 GRANTS AND SUBSIDIES Sustainability Grants & Subsidies - - - - - - 90,000 105,000 120,000 135,000 101-0628-419.39-70 EDUCATION & TRAINING Sustainability Education & Training - - 4,900 9,800 304 7,624 7,624 7,624 7,624 7,624 101-0628-419.39-89 MISC CHARGES & SVCS Sustainability Other Services & Charges - 638 1,140 1,642 828 4,290 4,719 5,191 5,710 6,281 202-0607-431.10-01 SALARIED WAGES Streets & Sewers Salaries & Wages 540,562 602,081 518,874 388,874 212,356 531,296 541,666 552,244 563,031 574,035 202-0607-431.10-02 TEAMSTER WAGES Streets & Sewers Salaries & Wages 1,469,349 1,557,927 1,729,446 864,446 683,387 904,044 911,000 917,908 924,864 931,873 202-0607-431.10-03 SEASONAL & INTERNS Streets & Sewers Salaries & Wages 29,822 39,012 74,880 74,880 6,276 18,720 19,095 19,476 19,866 20,263 202-0607-431.10-04 EXTRA AND OVERTIME Streets & Sewers Salaries & Wages 132,233 263,094 310,056 217,056 121,177 200,239 204,064 206,105 208,166 210,248 202-0607-431.10-06 LONGEVITY PAY Streets & Sewers Salaries & Wages 5,275 5,100 6,000 6,000 1,700 6,100 6,100 6,000 6,000 6,000 202-0607-431.10-08 OVERTIME - SPECIAL EVENTS Streets & Sewers Salaries & Wages 21,081 17,755 17,610 17,610 1,378 17,610 17,964 17,610 17,610 17,610 202-0607-431.10-09 PERMANENT PART-TIME Streets & Sewers Salaries & Wages 63,744 66,145 73,413 62,413 30,072 106,613 108,745 110,920 113,139 115,401 202-0607-431.10-10 HIRING BONUS Streets & Sewers Salaries & Wages - 420 - - - - - - - - 80 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 202-0607-431.10-13 CONTRACT ADD PAYS Streets & Sewers Salaries & Wages 40,648 48,172 70,297 59,797 33,166 80,075 80,875 81,865 82,501 83,326 202-0607-431.11-01 FICA - REGULAR Streets & Sewers Fringe Benefits 173,409 194,435 214,749 134,219 82,312 144,451 146,351 148,078 149,843 151,645 202-0607-431.11-04 PERF - REGULAR Streets & Sewers Fringe Benefits 247,218 282,077 297,795 186,120 119,843 197,447 199,947 202,193 204,481 206,823 202-0607-431.11-05 PERF - UNION Streets & Sewers Fringe Benefits 22,838 21,877 32,011 20,011 9,116 18,405 18,584 18,726 18,869 19,019 202-0607-431.11-07 UNEMPLOYMENT COMP Streets & Sewers Fringe Benefits - - - - - 174 526 890 1,261 1,641 202-0607-431.11-08 HEALTH INSURANCE Streets & Sewers Fringe Benefits 621,437 678,522 512,856 320,536 190,200 348,312 453,312 468,312 498,312 528,312 202-0607-431.11-09 LIFE INSURANCE Streets & Sewers Fringe Benefits 5,628 5,909 6,120 3,820 2,470 3,600 3,600 3,600 3,600 3,600 202-0607-431.11-12 AUTO ALLOWANCE Streets & Sewers Fringe Benefits 810 1,284 - - - - - - - - 202-0607-431.11-24 CELL PHONE ALLOWANCE Streets & Sewers Fringe Benefits 6,065 6,150 5,940 5,940 2,200 5,280 5,280 5,280 5,280 5,280 202-0607-431.11-27 JOB READINESS ALLOWANCE Streets & Sewers Fringe Benefits 16,724 16,974 18,275 18,275 17,000 18,275 18,275 18,275 18,275 18,275 202-0607-431.11-29 PARENTAL LEAVE Streets & Sewers Fringe Benefits - 6,029 6,396 3,996 2,377 6,088 7,929 8,018 8,111 8,205 202-0607-431.11-99 OTHER FRINGE BENEFITS Streets & Sewers Fringe Benefits 2,314 2,175 6,500 6,500 - 6,500 6,500 6,500 6,500 6,500 202-0607-431.21-02 PRINT SHOP Streets & Sewers Supplies 388 1,014 1,100 1,100 20 1,100 1,100 1,100 1,100 1,100 202-0607-431.21-03 C.S. OFFICE SUPPLIES Streets & Sewers Supplies 365 581 600 600 376 - - - - - 202-0607-431.21-04 OFFICE SUPPLIES Streets & Sewers Supplies 1,823 3,070 5,000 6,020 2,372 5,600 5,600 5,600 5,600 5,600 202-0607-431.22-01 C.S. GASOLINE Streets & Sewers Supplies 195,882 275,958 335,421 224,731 91,569 222,630 227,083 231,625 236,257 240,982 202-0607-431.22-02 DIESEL/CNG Streets & Sewers Supplies 3,963 5,347 7,500 3,087 3,104 750 750 750 750 750 202-0607-431.22-05 UNIFORMS Streets & Sewers Supplies 10,617 13,299 15,000 18,848 5,402 15,000 15,000 15,000 15,000 15,000 202-0607-431.22-06 COMPUTER SUPPLIES Streets & Sewers Supplies 1,051 1,427 - 270 212 - - - - - 202-0607-431.22-20 C.S. MEDICAL/SAFETY Streets & Sewers Supplies - - - - - - - - - - 202-0607-431.22-21 C.S. CLEANING SUPPLIES Streets & Sewers Supplies 1,575 2,992 2,500 2,500 1,215 2,500 2,500 2,500 2,500 2,500 202-0607-431.22-22 MEDICAL/SAFETY SUPPLIES Streets & Sewers Supplies 2,299 2,574 2,600 2,600 1,610 1,024 1,024 1,024 1,024 1,024 202-0607-431.22-24 OTHER OPERATING SUPPLIES Streets & Sewers Supplies 29,308 21,591 35,000 28,751 2,638 35,000 35,000 35,000 35,000 35,000 202-0607-431.22-30 TRAFFIC/SIGN/OTHER Streets & Sewers Supplies 176,122 161,238 200,000 237,374 39,595 267,500 17,500 17,500 17,500 17,500 202-0607-431.22-40 SIGNALS/LIGHTS Streets & Sewers Supplies 178,627 185,467 175,000 183,244 64,724 17,500 17,500 17,500 17,500 17,500 202-0607-431.23-01 BUILDING MATERIALS Streets & Sewers Supplies 1,551 - - - - - - - - - 202-0607-431.23-02 STREET MATERIAL Streets & Sewers Supplies 716,815 557,704 1,430,846 614,313 166,685 174,830 174,830 174,830 174,830 174,830 202-0607-431.23-03 CONCRETE SUPPLIES/REPAIRS Streets & Sewers Supplies 1,576 - 5,000 5,000 - 5,000 5,000 5,000 5,000 5,000 202-0607-431.23-20 SMALL TOOLS & EQUIPMENT Streets & Sewers Supplies 39,219 61,715 75,000 88,882 35,187 37,500 37,500 37,500 37,500 37,500 202-0607-431.23-24 OTHER OPERATING SUPPLIES Streets & Sewers Supplies - - - - - - - - - - 202-0607-431.23-40 SALT/ICE MELT Streets & Sewers Supplies 266,927 317,664 540,760 797,561 219,891 540,760 540,760 540,760 540,760 540,760 202-0607-431.23-99 OTHER R&M SUPPLIES Streets & Sewers Supplies - - - - - - - - - - 202-0607-431.31-06 OTHER PROFESSIONAL SVCS Streets & Sewers Professional Services 2,297 - 36,000 69,000 33,000 - - - - - 202-0607-431.31-70 ADM FEE ALLOCATION Streets & Sewers Other Interfund Allocations 305,424 310,309 365,280 365,280 152,200 501,545 538,909 549,687 560,681 571,895 202-0607-431.31-71 CENTRAL STORES ALLOCATION Streets & Sewers Other Interfund Allocations 4,140 10,849 12,208 12,208 5,089 - - - - - 202-0607-431.31-73 PRINT SHOP ALLOCATION Streets & Sewers Other Interfund Allocations 3,336 2,496 2,866 2,866 1,193 3,390 3,077 3,020 3,083 3,147 202-0607-431.31-76 IT ALLOCATION Streets & Sewers Other Interfund Allocations 187,740 245,960 431,471 431,471 179,779 384,384 470,790 466,392 467,388 469,105 202-0607-431.31-77 PAYROLL COST ALLOCATION Streets & Sewers Other Interfund Allocations - - 273,309 273,309 113,884 282,036 292,363 297,315 302,361 307,511 202-0607-431.31-78 LIABILITY INSURANCE ALLOC Streets & Sewers Other Interfund Allocations - - 471,559 471,559 196,480 288,023 410,227 418,432 426,801 435,337 202-0607-431.31-79 FACILITIES MGMT ALLOC Streets & Sewers Other Interfund Allocations - - - - - 1,398 1,530 1,555 1,615 1,622 202-0607-431.32-03 TRAVEL Streets & Sewers Travel - - 10,000 10,000 1,173 15,000 15,000 15,000 15,000 15,000 202-0607-431.32-04 TELEPHONE Streets & Sewers Other Services & Charges 1,552 8,399 720 1,441 716 720 720 720 720 720 202-0607-431.32-21 TRAVEL - MILEAGE Streets & Sewers Travel 189 161 - - - - - - - - 202-0607-431.32-23 TRAVEL - HOTEL Streets & Sewers Travel 1,546 1,011 - - - - - - - - 202-0607-431.32-24 TRAVEL - MEALS Streets & Sewers Travel 605 374 - - - - - - - - 202-0607-431.32-25 TRAVEL - OTHER Streets & Sewers Travel 235 169 - - - - - - - - 202-0607-431.33-02 PUBLICATION LEGAL NOTICE Streets & Sewers Printing & Advertising 249 97 500 500 74 750 750 750 750 750 202-0607-431.34-02 LIABILITY INSURANCE Streets & Sewers Other Interfund Allocations 300,612 398,568 - - - - - - - - 202-0607-431.35-01 ELECTRIC Streets & Sewers Utilities 18,459 20,769 25,000 25,000 7,756 23,148 25,000 25,000 25,000 25,000 202-0607-431.35-02 NATURAL GAS Streets & Sewers Utilities 15,916 16,392 18,990 18,990 13,472 17,583 18,990 18,990 18,990 18,990 202-0607-431.35-03 TRASH REMOVAL Streets & Sewers Other Services & Charges - 1,455 1,008 1,008 682 1,464 1,464 1,464 1,464 1,464 202-0607-431.35-04 WATER Streets & Sewers Utilities 8,142 8,407 8,512 8,512 3,481 8,469 8,469 8,469 8,469 8,469 202-0607-431.36-01 BUILDING & STREET MAINT Streets & Sewers Repairs & Maintenance 241,297 670,241 56,618 180,890 61,154 71,334 71,334 71,334 71,334 71,334 81 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 202-0607-431.36-02 OFFICE EQUIP R&M Streets & Sewers Repairs & Maintenance 2,811 2,357 - - - - - - - - 202-0607-431.36-03 AUTO EQUIPMENT R&M Streets & Sewers Repairs & Maintenance 972,284 986,633 1,005,000 567,865 383,895 550,754 550,754 550,754 550,754 550,754 202-0607-431.36-04 COMPUTER EQUIP R&M Streets & Sewers Repairs & Maintenance - - - - - - - - - - 202-0607-431.36-05 OTHER EQUIP R&M Streets & Sewers Repairs & Maintenance 3,331 3,128 3,500 3,500 2,620 3,500 3,500 3,500 3,500 3,500 202-0607-431.36-06 RADIO EQUIP R&M Streets & Sewers Repairs & Maintenance 4,710 9,242 7,250 7,250 4,812 7,000 7,000 7,000 7,000 7,000 202-0607-431.37-11 CAPITAL LEASE PRINCIPAL Streets & Sewers Debt Service 677,271 719,026 - - - - - - - - 202-0607-431.37-12 CAPITAL LEASE INTEREST Streets & Sewers Debt Service 35,352 37,504 - - - - - - - - 202-0607-431.38-01 PRINCIPAL Streets & Sewers Debt Service - - 857,551 857,551 358,383 724,287 490,310 243,853 152,575 - 202-0607-431.38-02 INTEREST Streets & Sewers Debt Service - - 68,076 68,076 22,281 45,785 20,255 10,171 2,770 - 202-0607-431.39-10 SUBSCRIPTIONS Streets & Sewers Other Services & Charges 3,454 52 - - - - - - - - 202-0607-431.39-39 CREDIT CARD CHARGES Streets & Sewers Other Services & Charges - - - - 40 - - - - - 202-0607-431.39-70 EDUCATION & TRAINING Streets & Sewers Education & Training 5,710 4,425 10,000 10,000 9,540 15,000 15,000 15,000 15,000 15,000 202-0607-431.39-88 PENALTY FEES Streets & Sewers Other Services & Charges 5,000 - - - - - - - - - 202-0607-431.39-89 MISC CHARGES & SVCS Streets & Sewers Other Services & Charges 3,843 1,979 5,800 6,385 2,070 5,800 5,800 5,800 5,800 5,800 202-0607-431.43-01 FURNITURE & FIXTURES Streets & Sewers Capital - 15,998 - - - - - - - - 202-0607-431.43-02 MOTOR EQUIPMENT Streets & Sewers Capital 10,800 - - - - - - - - - 202-0607-431.43-03 OFFICE EQUIPMENT Streets & Sewers Capital 15,995 - - - - - - - - - 202-0607-431.43-04 STREET EQUIPMENT Streets & Sewers Capital - 11,870 - - - - - - - - 202-0607-431.50-02 INTERFUND TRANSFER OUT Streets & Sewers Transfers Out - - 2,500,000 2,500,000 625,000 - - - - - 202-0619-431.10-01 SALARIED WAGES Streets & Sewers Salaries & Wages 67,933 71,575 58,716 58,716 24,841 59,890 61,088 62,310 63,556 64,827 202-0619-431.10-02 TEAMSTER WAGES Streets & Sewers Salaries & Wages 166,384 166,283 294,675 294,675 94,786 297,606 300,581 332,890 306,623 309,690 202-0619-431.10-03 SEASONAL & INTERNS Streets & Sewers Salaries & Wages 33,545 34,102 49,920 49,920 4,824 49,920 57,283 19,476 59,598 60,790 202-0619-431.10-04 EXTRA AND OVERTIME Streets & Sewers Salaries & Wages 5,872 8,187 10,758 10,758 1,285 10,863 10,972 11,082 11,193 11,305 202-0619-431.10-06 LONGEVITY PAY Streets & Sewers Salaries & Wages 450 450 450 450 450 650 650 750 750 800 202-0619-431.10-13 CONTRACT ADD PAYS Streets & Sewers Salaries & Wages 3,844 4,901 11,051 11,051 5,013 11,488 80,875 11,720 11,837 11,955 202-0619-431.11-01 FICA - REGULAR Streets & Sewers Fringe Benefits 20,558 21,160 32,816 32,816 9,431 33,187 40,797 42,269 36,425 36,899 202-0619-431.11-04 PERF - REGULAR Streets & Sewers Fringe Benefits 27,341 28,148 42,453 42,453 13,934 42,996 51,248 47,281 44,504 45,021 202-0619-431.11-05 PERF - UNION Streets & Sewers Fringe Benefits 2,643 2,710 4,799 4,799 1,156 4,854 5,941 5,391 5,000 5,051 202-0619-431.11-07 UNEMPLOYMENT COMP Streets & Sewers Fringe Benefits - - - - - 38 136 208 276 359 202-0619-431.11-08 HEALTH INSURANCE Streets & Sewers Fringe Benefits 80,575 80,564 80,448 80,448 25,966 92,883 120,883 124,883 132,883 140,883 202-0619-431.11-09 LIFE INSURANCE Streets & Sewers Fringe Benefits 618 623 960 960 310 960 960 960 960 960 202-0619-431.11-24 CELL PHONE ALLOWANCE Streets & Sewers Fringe Benefits 453 453 420 420 175 420 420 420 420 420 202-0619-431.11-27 JOB READINESS ALLOWANCE Streets & Sewers Fringe Benefits 1,700 1,700 2,975 2,975 1,700 2,975 2,975 2,975 2,975 2,975 202-0619-431.11-29 PARENTAL LEAVE Streets & Sewers Fringe Benefits - 650 910 910 250 1,332 2,044 1,884 1,773 1,794 202-0619-431.11-99 OTHER FRINGE BENEFITS Streets & Sewers Fringe Benefits 400 200 - - - 600 600 600 600 600 202-0619-431.22-01 C.S. GASOLINE Streets & Sewers Supplies 5,182 6,323 6,825 6,825 2,967 5,200 5,252 5,305 5,358 5,412 202-0619-431.22-05 UNIFORMS Streets & Sewers Supplies 1,278 1,172 1,905 1,905 467 1,905 1,905 1,905 1,905 1,905 202-0619-431.23-03 CONCRETE SUPPLIES/REPAIRS Streets & Sewers Supplies 80,369 76,344 87,500 87,500 697 100,000 100,000 100,000 100,000 100,000 202-0619-431.23-21 C.S. SMALL TOOLS & EQUIP Streets & Sewers Supplies 5,460 4,090 5,000 5,000 541 5,000 5,000 5,000 5,000 5,000 202-0619-431.23-24 OTHER OPERATING SUPPLIES Streets & Sewers Supplies 1,119 1,451 1,750 1,816 530 1,750 1,750 1,750 1,750 1,750 202-0619-431.31-06 OTHER PROFESSIONAL SVCS Streets & Sewers Professional Services 852,643 670,422 504,468 733,793 19,364 549,014 549,014 549,014 549,014 549,014 202-0619-431.31-70 ADM FEE ALLOCATION Streets & Sewers Other Interfund Allocations 51,804 50,551 52,063 52,063 21,690 56,055 60,231 61,436 62,665 63,918 202-0619-431.31-77 PAYROLL COST ALLOCATION Streets & Sewers Other Interfund Allocations - - 19,523 19,523 8,134 21,546 22,561 22,946 23,337 23,736 202-0619-431.32-02 POSTAGE Streets & Sewers Other Services & Charges - - 300 300 - 300 300 300 300 300 202-0619-431.33-02 PUBLICATION LEGAL NOTICE Streets & Sewers Printing & Advertising 74 167 500 500 67 500 500 500 500 500 202-0619-431.36-03 AUTO EQUIPMENT R&M Streets & Sewers Repairs & Maintenance 20,712 7,572 21,000 21,000 6,573 15,000 15,150 15,302 15,455 15,610 202-0619-431.39-05 CURB & SIDEWALK REIMBURSE Streets & Sewers Other Services & Charges 79,329 83,103 150,000 150,000 3,080 115,000 115,000 115,000 115,000 115,000 217-0674-415.31-06 OTHER PROFESSIONAL SVCS Engineering Professional Services - - - - - - - - - 222-0616-419.10-01 SALARIED WAGES Sustainability Salaries & Wages 132,042 144,815 - - - - - - - - 222-0616-419.10-03 SEASONAL & INTERNS Sustainability Salaries & Wages 12,990 8,145 - - - - - - - - 222-0616-419.10-04 EXTRA AND OVERTIME Sustainability Salaries & Wages - 18 - - - - - - - - 222-0616-419.11-01 FICA - REGULAR Sustainability Fringe Benefits 10,619 11,215 - - - - - - - - 222-0616-419.11-04 PERF - REGULAR Sustainability Fringe Benefits 14,789 16,367 - - - - - - - - 82 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 222-0616-419.11-08 HEALTH INSURANCE Sustainability Fringe Benefits 30,640 31,292 - - - - - - - - 222-0616-419.11-09 LIFE INSURANCE Sustainability Fringe Benefits 235 240 - - - - - - - - 222-0616-419.11-24 CELL PHONE ALLOWANCE Sustainability Fringe Benefits 1,265 1,210 - - - - - - - - 222-0616-419.11-29 PARENTAL LEAVE Sustainability Fringe Benefits - 362 - - - - - - - - 222-0616-419.21-02 PRINT SHOP Sustainability Supplies 1 1 - - - - - - - - 222-0616-419.21-03 C.S. OFFICE SUPPLIES Sustainability Supplies - 67 - - - - - - - - 222-0616-419.21-04 OFFICE SUPPLIES Sustainability Supplies 142 143 - 7,750 907 - - - - - 222-0616-419.31-06 OTHER PROFESSIONAL SVCS Sustainability Professional Services 16,130 20,978 - 3,000 165 - - - - - 222-0616-419.31-70 ADM FEE ALLOCATION Sustainability Other Interfund Allocations 11,736 11,178 - - - - - - - - 222-0616-419.31-71 CENTRAL STORES ALLOCATION Sustainability Other Interfund Allocations 264 588 - - - - - - - - 222-0616-419.31-73 PRINT SHOP ALLOCATION Sustainability Other Interfund Allocations 288 204 - - - - - - - - 222-0616-419.31-76 IT ALLOCATION Sustainability Other Interfund Allocations 20,700 46,277 - - - - - - - - 222-0616-419.32-21 TRAVEL - MILEAGE Sustainability Travel 477 519 - - - - - - - - 222-0616-419.32-22 TRAVEL - AIRFARE Sustainability Travel 496 - - - - - - - - - 222-0616-419.32-23 TRAVEL - HOTEL Sustainability Travel 971 271 - - - - - - - - 222-0616-419.32-24 TRAVEL - MEALS Sustainability Travel 85 161 - - - - - - - - 222-0616-419.32-25 TRAVEL - OTHER Sustainability Travel 110 69 - - - - - - - - 222-0616-419.33-03 PROMOTIONAL Sustainability Printing & Advertising 205 184 - 139 - - - - - - 222-0616-419.34-02 LIABILITY INSURANCE Sustainability Other Interfund Allocations 408 420 - - - - - - - - 222-0616-419.36-04 COMPUTER EQUIP R&M Sustainability Repairs & Maintenance - - - - - - - - - - 222-0616-419.39-30 GRANTS AND SUBSIDIES Sustainability Grants & Subsidies - 5,320 - 4,800 2,434 - - - - - 222-0616-419.39-70 EDUCATION & TRAINING Sustainability Education & Training 1,345 3,655 - - - - - - - - 222-0616-419.39-89 MISC CHARGES & SVCS Sustainability Other Services & Charges 696 610 - 1,548 72 - - - - - 227-0602-431.42-03 STREETS AND ALLEYS Engineering Capital 21,660 24,273 - 2,409 - - - - - - 227-0640-601.39-55 RECYCLING Engineering Other Services & Charges 98,400 125,000 200,000 200,000 - - - - - - 227-1001-460.31-01 LEGAL SERVICES Engineering Professional Services 12,532 63,308 - 1,211 1,211 - - - - - 227-1001-460.31-06 OTHER PROFESSIONAL SVCS Engineering Professional Services - 9,756 25,000 32,786 - - - - - - 227-1201-415.39-89 MISC CHARGES & SVCS Engineering Other Services & Charges - 10,000 - 36,100 36,100 - - - - - 251-0608-431.22-30 TRAFFIC/SIGN/OTHER Engineering Supplies 5,670 - - - - - - - - - 251-0608-431.23-02 STREET MATERIAL Engineering Supplies 449,636 555,400 250,000 339,675 57,512 250,000 250,000 250,000 250,000 250,000 251-0608-431.31-06 OTHER PROFESSIONAL SVCS Engineering Professional Services - 14,000 680,000 878,000 68,640 680,000 680,000 680,000 680,000 680,000 251-0608-431.36-10 STREET MAINTENANCE Engineering Repairs & Maintenance 22,278 211,920 250,000 260,359 20,317 250,000 250,000 250,000 250,000 250,000 251-0608-431.36-67 TRAFFIC SIGNAL MAINT Engineering Repairs & Maintenance 109,430 525,200 400,000 662,041 107,126 400,000 350,000 300,000 275,000 250,000 251-0608-431.39-89 MISC CHARGES & SVCS Engineering Other Services & Charges - - - 5,000 5,000 15,000 15,000 15,000 15,000 15,000 251-0608-431.42-93 LANE MARKING Engineering Repairs & Maintenance 20,620 27,000 - 1,526 - - - - - - 251-0608-431.42-96 MAJOR PROJECTS Engineering Capital 459,657 391,854 3,550,000 4,348,109 198,290 400,000 1,000,000 1,000,000 1,000,000 1,000,000 251-0608-431.50-02 INTERFUND TRANSFER OUT Engineering Transfers Out - 284,500 600,000 600,000 - 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 252-0801-421.22-24 OTHER OPERATING SUPPLIES Engineering Supplies 8 - - - - - - - - 257-0608-431.31-06 OTHER PROFESSIONAL SVCS Engineering Professional Services 285,462 390,739 65,000 322,319 102,559 - - - - - 257-0608-431.42-96 MAJOR PROJECTS Engineering Capital 907,255 939,155 - 578,944 292,055 - - - - - 257-0608-431.50-02 INTERFUND TRANSFER OUT Engineering Transfers Out - 1,340,000 - - - - - - - - 257-0608-452.50-02 INTERFUND TRANSFER OUT Engineering Transfers Out 1,000,000 - - - - - - - - - 265-0608-431.36-10 STREET MAINTENANCE Engineering Repairs & Maintenance 1,007,057 1,704,898 1,200,000 1,283,291 798 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 265-0608-431.39-01 REFNDS,AWARDS,INDEMNITIES Engineering Other Services & Charges - 334,741 - - - - - - - - 266-0607-431.10-01 SALARIED WAGES Streets & Sewers Salaries & Wages - - - 130,000 - - - - - - 266-0607-431.10-02 TEAMSTER WAGES Streets & Sewers Salaries & Wages - - - 865,000 - 849,217 890,493 897,196 903,944 910,745 266-0607-431.10-03 SEASONAL & INTERNS Streets & Sewers Salaries & Wages - - - - - 56,160 57,283 58,429 59,598 60,790 266-0607-431.10-04 EXTRA AND OVERTIME Streets & Sewers Salaries & Wages - - - 93,000 - 50,060 51,067 51,578 52,094 52,615 266-0607-431.10-06 LONGEVITY PAY Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0607-431.10-08 OVERTIME - SPECIAL EVENTS Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0607-431.10-09 PERMANENT PART-TIME Streets & Sewers Salaries & Wages - - - 11,000 - 18,096 18,458 18,828 19,204 19,588 266-0607-431.10-13 CONTRACT ADD PAYS Streets & Sewers Salaries & Wages - - - 10,500 - 14,569 14,715 14,862 15,011 15,161 266-0607-431.11-01 FICA - REGULAR Streets & Sewers Fringe Benefits - - - 80,530 - 75,590 78,950 79,627 80,313 81,005 83 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 266-0607-431.11-04 PERF - REGULAR Streets & Sewers Fringe Benefits - - - 111,675 - 102,351 107,103 107,928 108,757 109,592 266-0607-431.11-05 PERF - UNION Streets & Sewers Fringe Benefits - - - 12,000 - 13,708 14,345 14,454 14,564 14,677 266-0607-431.11-07 UNEMPLOYMENT COMP Streets & Sewers Fringe Benefits - - - - - 91 284 482 679 881 266-0607-431.11-08 HEALTH INSURANCE Streets & Sewers Fringe Benefits - - - 192,320 - 243,818 332,429 343,429 365,429 387,429 266-0607-431.11-09 LIFE INSURANCE Streets & Sewers Fringe Benefits - - - 2,300 - 2,520 2,640 2,640 2,640 2,640 266-0607-431.11-24 CELL PHONE ALLOWANCE Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0607-431.11-27 JOB READINESS ALLOWANCE Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0607-431.11-29 PARENTAL LEAVE Streets & Sewers Fringe Benefits - - - 2,400 - 3,198 4,303 4,337 4,371 4,403 266-0607-431.11-99 OTHER FRINGE BENEFITS Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0607-431.21-02 PRINT SHOP Streets & Sewers Supplies - - - - - - 266-0607-431.21-04 OFFICE SUPPLIES Streets & Sewers Supplies - - - - - - 266-0607-431.22-01 C.S. GASOLINE Streets & Sewers Supplies - - - 110,690 - 111,124 113,347 115,614 117,926 120,285 266-0607-431.22-02 DIESEL/CNG Streets & Sewers Supplies - - - 6,750 - 6,750 6,750 6,750 6,750 6,750 266-0607-431.22-05 UNIFORMS Streets & Sewers Supplies - - - - - - 266-0607-431.22-21 C.S. CLEANING SUPPLIES Streets & Sewers Supplies - - - - - - 266-0607-431.22-22 MEDICAL/SAFETY SUPPLIES Streets & Sewers Supplies - - - - - 1,576 1,576 1,576 1,576 1,576 266-0607-431.22-24 OTHER OPERATING SUPPLIES Streets & Sewers Supplies - - - 7,000 - - 266-0607-431.22-30 TRAFFIC/SIGN/OTHER Streets & Sewers Supplies - - - - - 157,500 157,500 157,500 157,500 157,500 266-0607-431.22-40 SIGNALS/LIGHTS Streets & Sewers Supplies - - - 52,500 - 157,500 157,500 157,500 157,500 157,500 266-0607-431.23-02 STREET MATERIAL Streets & Sewers Supplies - - - 1,000,000 24,000 706,016 706,016 706,016 706,016 706,016 266-0607-431.23-03 CONCRETE SUPPLIES/REPAIRS Streets & Sewers Supplies - - - - - - 266-0607-431.23-20 SMALL TOOLS & EQUIPMENT Streets & Sewers Supplies - - - 18,750 1,496 37,500 37,500 37,500 37,500 37,500 266-0607-431.23-40 SALT/ICE MELT Streets & Sewers Supplies - - - - - - 266-0607-431.31-06 OTHER PROFESSIONAL SVCS Streets & Sewers Professional Services - - - - - - 266-0607-431.31-70 ADM FEE ALLOCATION Streets & Sewers Other Interfund Allocations - - - - - - 266-0607-431.31-71 CENTRAL STORES ALLOCATION Streets & Sewers Other Interfund Allocations - - - - - - 266-0607-431.31-76 IT ALLOCATION Streets & Sewers Other Interfund Allocations - - - - - - 266-0607-431.31-77 PAYROLL COST ALLOCATION Streets & Sewers Other Interfund Allocations - - - - - - 266-0607-431.31-78 LIABILITY INSURANCE ALLOC Streets & Sewers Other Interfund Allocations - - - - - - 266-0607-431.32-03 TRAVEL Streets & Sewers Travel - - - - - - 266-0607-431.32-04 TELEPHONE Streets & Sewers Other Services & Charges - - - - - - 266-0607-431.33-02 PUBLICATION LEGAL NOTICE Streets & Sewers Printing & Advertising - - - - - - 266-0607-431.35-01 ELECTRIC Streets & Sewers Utilities - - - - - - 266-0607-431.35-02 NATURAL GAS Streets & Sewers Utilities - - - - - - 266-0607-431.35-03 TRASH REMOVAL Streets & Sewers Other Services & Charges - - - - - - 266-0607-431.35-04 WATER Streets & Sewers Utilities - - - - - - 266-0607-431.36-01 BUILDING & STREET MAINT Streets & Sewers Repairs & Maintenance - - - - - - 266-0607-431.36-03 AUTO EQUIPMENT R&M Streets & Sewers Repairs & Maintenance - - - 442,200 3,850 439,246 439,247 439,247 439,247 439,247 266-0607-431.36-05 OTHER EQUIP R&M Streets & Sewers Repairs & Maintenance - - - - - - 266-0607-431.36-06 RADIO EQUIP R&M Streets & Sewers Repairs & Maintenance - - - - - - 266-0607-431.38-01 PRINCIPAL Streets & Sewers Debt Service - - - - - - 266-0607-431.38-02 INTEREST Streets & Sewers Debt Service - - - - - - 266-0607-431.39-70 EDUCATION & TRAINING Streets & Sewers Education & Training - - - - - - 266-0607-431.39-89 MISC CHARGES & SVCS Streets & Sewers Other Services & Charges - - - - - - 266-0607-431.50-02 INTERFUND TRANSFER OUT Streets & Sewers Transfers Out - - - - - - 266-0619-431.10-01 SALARIED WAGES Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0619-431.10-02 TEAMSTER WAGES Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0619-431.10-03 SEASONAL & INTERNS Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0619-431.10-04 EXTRA AND OVERTIME Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0619-431.10-06 LONGEVITY PAY Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0619-431.10-13 CONTRACT ADD PAYS Streets & Sewers Salaries & Wages - - - - - - - - - - 266-0619-431.11-01 FICA - REGULAR Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.11-04 PERF - REGULAR Streets & Sewers Fringe Benefits - - - - - - - - - - 84 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 266-0619-431.11-05 PERF - UNION Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.11-07 UNEMPLOYMENT COMP Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.11-08 HEALTH INSURANCE Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.11-09 LIFE INSURANCE Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.11-24 CELL PHONE ALLOWANCE Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.11-27 JOB READINESS ALLOWANCE Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.11-29 PARENTAL LEAVE Streets & Sewers Fringe Benefits - - - - - - - - - - 266-0619-431.22-01 C.S. GASOLINE Streets & Sewers Supplies - - - - - - 266-0619-431.22-05 UNIFORMS Streets & Sewers Supplies - - - - - - 266-0619-431.23-03 CONCRETE SUPPLIES/REPAIRS Streets & Sewers Supplies - - - - 2,052 - 266-0619-431.23-21 C.S. SMALL TOOLS & EQUIP Streets & Sewers Supplies - - - - - - 266-0619-431.23-24 OTHER OPERATING SUPPLIES Streets & Sewers Supplies - - - - - - 266-0619-431.31-06 OTHER PROFESSIONAL SVCS Streets & Sewers Professional Services - - - - - - 266-0619-431.31-70 ADM FEE ALLOCATION Streets & Sewers Other Interfund Allocations - - - - - - 266-0619-431.31-77 PAYROLL COST ALLOCATION Streets & Sewers Other Interfund Allocations - - - - - - 266-0619-431.32-02 POSTAGE Streets & Sewers Other Services & Charges - - - - - - 266-0619-431.33-02 PUBLICATION LEGAL NOTICE Streets & Sewers Printing & Advertising - - - - - - 266-0619-431.36-03 AUTO EQUIPMENT R&M Streets & Sewers Repairs & Maintenance - - - - - - 266-0619-431.39-05 CURB & SIDEWALK REIMBURSE Streets & Sewers Other Services & Charges - - - - - - 412-0401-415.36-01 BUILDING R&M Engineering Repairs & Maintenance 490,548 671,364 - 922,187 144,936 - - - - - 412-0401-415.42-03 STREETS AND ALLEYS Engineering Capital - - - 173,020 - - - - - - 412-0602-431.31-06 OTHER PROFESSIONAL SVCS Engineering Professional Services - - - 100,000 - 500,000 500,000 500,000 500,000 500,000 412-0602-431.42-03 STREETS AND ALLEYS Engineering Capital 21,700 7,090 1,200,000 1,446,029 139,672 - - - - - 610-0610-791.10-01 SALARIED WAGES Solid Waste Salaries & Wages 197,881 237,583 260,493 260,493 94,902 272,005 277,445 282,994 288,653 294,426 610-0610-791.10-02 TEAMSTER WAGES Solid Waste Salaries & Wages 788,533 704,467 747,531 747,431 283,482 756,588 762,183 767,816 773,508 779,236 610-0610-791.10-03 SEASONAL & INTERNS Solid Waste Salaries & Wages - - - - - - - - - - 610-0610-791.10-04 EXTRA AND OVERTIME Solid Waste Salaries & Wages 84,617 124,328 100,773 100,773 34,338 101,781 102,799 103,827 104,865 105,914 610-0610-791.10-06 LONGEVITY PAY Solid Waste Salaries & Wages 750 900 1,900 1,900 750 1,900 1,900 1,900 1,900 1,900 610-0610-791.10-13 CONTRACT ADD PAYS Solid Waste Salaries & Wages - - - 100 100 - - - - - 610-0610-791.11-01 FICA - REGULAR Solid Waste Fringe Benefits 80,945 81,304 85,785 85,785 31,511 87,564 88,487 89,420 90,368 91,328 610-0610-791.11-04 PERF - REGULAR Solid Waste Fringe Benefits 115,387 117,700 125,593 125,593 47,017 128,198 129,550 130,917 132,303 133,709 610-0610-791.11-05 PERF - UNION Solid Waste Fringe Benefits 9,778 6,700 12,893 12,893 2,289 13,037 13,137 13,236 13,337 13,439 610-0610-791.11-07 UNEMPLOYMENT COMP Solid Waste Fringe Benefits - - - - - 113 344 578 817 1,064 610-0610-791.11-08 HEALTH INSURANCE Solid Waste Fringe Benefits 333,775 281,510 224,544 223,044 84,972 268,710 349,210 360,710 383,710 406,710 610-0610-791.11-09 LIFE INSURANCE Solid Waste Fringe Benefits 2,779 2,334 2,880 2,880 922 2,880 2,880 2,880 2,880 2,880 610-0610-791.11-10 CLOTHING ALLOWANCE Solid Waste Fringe Benefits 193 - 800 800 - 800 800 800 800 800 610-0610-791.11-12 AUTO ALLOWANCE Solid Waste Fringe Benefits 600 1,503 - 1,500 625 1,500 1,500 1,500 1,500 1,500 610-0610-791.11-24 CELL PHONE ALLOWANCE Solid Waste Fringe Benefits 1,452 1,366 1,320 1,320 550 1,980 1,980 1,980 1,980 1,980 610-0610-791.11-27 JOB READINESS ALLOWANCE Solid Waste Fringe Benefits 9,350 7,863 9,350 9,350 7,119 8,075 8,075 8,075 8,075 8,075 610-0610-791.11-29 PARENTAL LEAVE Solid Waste Fringe Benefits - 2,322 2,772 2,772 712 3,963 5,150 5,204 5,259 5,315 610-0610-791.11-99 OTHER FRINGE BENEFITS Solid Waste Fringe Benefits - 190 1,500 1,500 - 1,500 1,500 1,500 1,500 1,500 610-0610-791.21-02 PRINT SHOP Solid Waste Supplies - 593 500 500 185 500 500 500 500 500 610-0610-791.21-03 C.S. OFFICE SUPPLIES Solid Waste Supplies 3,444 899 1,200 1,200 - - - - - - 610-0610-791.21-04 OFFICE SUPPLIES Solid Waste Supplies 458 60 3,000 3,000 818 4,200 4,200 4,200 4,200 4,200 610-0610-791.22-01 C.S. GASOLINE Solid Waste Supplies 43,661 38,859 50,000 50,000 4,785 50,000 50,000 50,000 50,000 50,000 610-0610-791.22-02 DIESEL/CNG Solid Waste Supplies 138,994 160,651 150,000 151,197 51,489 180,000 180,000 180,000 180,000 180,000 610-0610-791.22-05 UNIFORMS Solid Waste Supplies 6,069 5,467 7,000 7,791 1,701 7,800 7,800 7,800 7,800 7,800 610-0610-791.22-20 C.S. MEDICAL/SAFETY Solid Waste Supplies 2,047 1,283 3,000 3,000 - - - - - - 610-0610-791.22-21 C.S. CLEANING SUPPLIES Solid Waste Supplies 1,253 1,554 5,000 5,000 - 1,500 1,500 1,500 1,500 1,500 610-0610-791.22-22 MEDICAL/SAFETY SUPPLIES Solid Waste Supplies 3,373 - 500 500 - 5,000 5,000 5,000 5,000 5,000 610-0610-791.22-24 OTHER OPERATING SUPPLIES Solid Waste Supplies 33,824 68,001 155,000 155,200 2,851 175,500 193,500 212,850 234,135 257,549 610-0610-791.31-07 MGMT FEE TO WATER WORKS Solid Waste Other Interfund Allocations 156,768 171,435 190,788 190,788 79,495 195,305 201,359 207,601 214,037 220,672 610-0610-791.31-70 ADM FEE ALLOCATION Solid Waste Other Interfund Allocations 166,200 163,194 189,287 189,287 78,869 214,315 230,281 234,887 239,585 244,377 85 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 610-0610-791.31-71 CENTRAL STORES ALLOCATION Solid Waste Other Interfund Allocations 1,944 4,118 7,056 7,056 2,940 - - - - - 610-0610-791.31-73 PRINT SHOP ALLOCATION Solid Waste Other Interfund Allocations 5,160 5,464 5,797 5,797 2,416 4,443 4,033 3,958 4,041 4,125 610-0610-791.31-76 IT ALLOCATION Solid Waste Other Interfund Allocations 163,824 400,944 439,517 439,517 183,135 352,832 439,071 434,969 435,898 437,500 610-0610-791.31-77 PAYROLL COST ALLOCATION Solid Waste Other Interfund Allocations - - 34,122 34,122 14,214 35,087 35,766 36,431 37,110 37,802 610-0610-791.31-78 LIABILITY INSURANCE ALLOC Solid Waste Other Interfund Allocations - - 131,839 131,839 54,930 161,439 216,664 220,997 225,417 229,925 610-0610-791.32-02 POSTAGE Solid Waste Other Services & Charges 5,541 1,921 1,200 1,350 21 2,500 2,500 2,500 2,500 2,500 610-0610-791.32-03 TRAVEL Solid Waste Travel - - 9,900 9,900 - 9,900 9,900 9,900 9,900 9,900 610-0610-791.32-04 TELEPHONE Solid Waste Other Services & Charges 10,738 11,886 16,200 17,373 3,739 15,000 15,000 15,000 15,000 15,000 610-0610-791.32-22 TRAVEL - AIRFARE Solid Waste Travel 1,179 434 - - - - - - - - 610-0610-791.32-23 TRAVEL - HOTEL Solid Waste Travel 2,197 1,166 - - - - - - - - 610-0610-791.32-24 TRAVEL - MEALS Solid Waste Travel 185 759 - - - - - - - - 610-0610-791.32-25 TRAVEL - OTHER Solid Waste Travel 97 197 - - - - - - - - 610-0610-791.33-02 PUBLICATION LEGAL NOTICE Solid Waste Printing & Advertising 43 - 250 250 - 250 250 250 250 250 610-0610-791.34-02 LIABILITY INSURANCE Solid Waste Other Interfund Allocations 76,404 105,960 - - - - - - - - 610-0610-791.36-01 BUILDING R&M Solid Waste Repairs & Maintenance 37,611 7,058 20,000 10,000 - 20,000 20,000 20,000 20,000 20,000 610-0610-791.36-02 OFFICE EQUIP R&M Solid Waste Repairs & Maintenance 192 - - - - - - - - - 610-0610-791.36-03 AUTO EQUIPMENT R&M Solid Waste Repairs & Maintenance 772,539 934,935 625,000 622,799 204,897 675,000 675,000 675,000 675,000 675,000 610-0610-791.36-04 COMPUTER EQUIP R&M Solid Waste Repairs & Maintenance - - - - - - - - - - 610-0610-791.36-06 RADIO EQUIP R&M Solid Waste Repairs & Maintenance 20,498 30,803 15,000 32,632 3,790 25,000 25,000 25,000 25,000 25,000 610-0610-791.37-11 CAPITAL LEASE PRINCIPAL Solid Waste Debt Service - - - - - - - - - - 610-0610-791.39-11 DUES & MEMBERSHIPS Solid Waste Other Services & Charges 257 - 2,000 2,000 - 1,500 1,500 1,500 1,500 1,500 610-0610-791.39-45 LICENSES & PERMITS Solid Waste Other Services & Charges 62,243 - - - - - - - - - 610-0610-791.39-70 EDUCATION & TRAINING Solid Waste Education & Training 8,564 11,509 10,000 5,900 - 20,000 10,000 10,000 10,000 10,000 610-0610-791.39-85 LANDFILL Solid Waste Other Services & Charges 726,980 785,488 675,000 685,985 348,422 935,700 963,900 1,012,200 1,062,900 1,126,674 610-0610-791.39-89 MISC CHARGES & SVCS Solid Waste Other Services & Charges 17,290 3,703 5,000 5,250 775 5,000 5,000 5,000 5,000 5,000 610-0610-791.50-02 INTERFUND TRANSFER OUT Solid Waste Transfers Out 778,600 1,004,039 1,132,616 1,132,616 629,065 1,231,349 924,530 704,912 401,285 194,043 610-0610-791.63-70 BAD DEBT EXP/RECYCLING Solid Waste Other Services & Charges 78,398 77,002 50,000 50,000 23,046 77,000 77,000 77,000 77,000 77,000 610-0615-791.31-08 SW MD RECYCLING FEE Solid Waste Professional Services 115,208 - - - - - - - - - 610-0615-791.31-70 ADM FEE ALLOCATION Solid Waste Other Interfund Allocations 26,556 - - - - - - - - - 610-0615-791.63-70 BAD DEBT EXP/RECYCLING Solid Waste Other Services & Charges 11,243 4,324 - - (94) - - - - - 611-0610-415.37-11 CAPITAL LEASE PRINCIPAL Solid Waste Debt Service 1,034,520 937,090 - - - - - - - - 611-0610-415.37-12 CAPITAL LEASE INTEREST Solid Waste Debt Service 41,621 65,381 - - - - - - - - 611-0610-415.38-01 PRINCIPAL Solid Waste Debt Service - - 1,037,025 1,037,025 448,395 1,159,236 871,664 672,114 386,187 188,654 611-0610-415.38-02 INTEREST Solid Waste Debt Service - - 95,591 95,591 32,512 72,113 52,865 32,798 15,098 5,389 620-0630-711.61-02 PLUMBING CONTRACTORS Water Works Other Services & Charges 806,175 790,529 1,030,000 1,030,000 232,797 1,030,000 1,030,000 1,030,000 1,030,000 1,030,000 620-0630-751.74-01 BAD DEBT EXPENSE Water Works Other Services & Charges 6,279 5,329 9,000 9,000 1,591 9,000 9,000 9,000 9,000 9,000 620-0640-601.21-05 SMALL OFFICE EQUIPMENT Water Works Supplies - 2,307 - - - - - - - - 620-0640-601.22-01 C.S. GASOLINE Water Works Supplies - 8,295 3,540 5,541 2,654 5,000 5,150 5,305 5,464 5,628 620-0640-601.23-01 BUILDING MATERIALS Water Works Supplies 1,490 2,987 3,000 3,000 436 3,000 3,090 3,183 3,278 3,377 620-0640-601.23-10 REPAIR PARTS Water Works Supplies 41,627 41,395 309,000 309,661 9,742 72,500 74,675 75,000 77,250 79,568 620-0640-601.23-20 SMALL TOOLS & EQUIPMENT Water Works Supplies - (1) - - - - - - - - 620-0640-601.23-21 C.S. SMALL TOOLS & EQUIP Water Works Supplies 180 170 250 250 - - - - - - 620-0640-601.23-62 MATERIALS & SUPPLIES Water Works Supplies 2,772 2,028 4,000 4,000 831 5,000 5,150 5,305 5,464 5,628 620-0640-601.35-01 ELECTRIC Water Works Utilities 664,969 721,486 704,000 704,000 224,320 750,000 772,500 795,675 819,545 844,132 620-0640-602.31-06 OTHER PROFESSIONAL SVCS Water Works Professional Services 82,345 99,933 150,000 285,123 34,450 150,000 154,500 159,135 163,909 168,826 620-0640-602.31-35 CONTRACTUAL SERV. OTHER Water Works Professional Services 18,617 22,481 42,500 46,803 5,114 285,000 44,500 45,835 47,210 48,626 620-0640-602.36-01 BUILDING R&M Water Works Repairs & Maintenance - - - - - - - - - - 620-0640-602.36-02 OFFICE EQUIP R&M Water Works Repairs & Maintenance 900 982 - - - - - - - - 620-0640-602.36-05 OTHER EQUIP R&M Water Works Repairs & Maintenance 80,790 143,753 150,000 182,807 71,880 150,000 154,500 159,135 163,909 168,826 620-0640-602.37-11 CAPITAL LEASE PRINCIPAL Water Works Debt Service 992 1,140 - - - - - - - - 620-0640-602.37-12 CAPITAL LEASE INTEREST Water Works Debt Service 93 127 - - - - - - - - 620-0640-602.38-01 PRINCIPAL Water Works Debt Service - - 91 91 - - - - - - 620-0640-602.38-02 INTEREST Water Works Debt Service - - 1 1 - - - - - - 86 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 620-0640-603.21-02 PRINT SHOP Water Works Supplies 71 8 100 100 - 100 103 106 109 113 620-0640-603.21-03 C.S. OFFICE SUPPLIES Water Works Supplies 477 505 500 500 172 - - - - - 620-0640-603.21-04 OFFICE SUPPLIES Water Works Supplies 1,824 2,660 4,960 21,869 19,868 4,960 5,109 5,262 5,420 5,583 620-0640-603.22-07 LANDSCAPING MATERIAL Water Works Supplies 2,510 3,004 3,000 3,044 423 3,000 3,090 3,183 3,278 3,377 620-0640-603.22-20 C.S. MEDICAL/SAFETY Water Works Supplies 1,455 1,493 1,500 1,500 410 - - - - - 620-0640-603.22-21 C.S. CLEANING SUPPLIES Water Works Supplies 501 497 600 600 2 - - - - - 620-0640-603.22-22 MEDICAL/SAFETY SUPPLIES Water Works Supplies 15,193 15,627 15,000 15,087 11,289 15,000 15,450 15,914 16,391 16,883 620-0640-603.22-25 CHEMICALS Water Works Supplies 125,477 124,432 152,657 178,035 58,007 152,657 157,237 161,954 166,812 171,817 620-0640-603.23-20 SMALL TOOLS & EQUIPMENT Water Works Supplies 15,982 9,936 11,000 11,025 3,594 8,600 8,858 9,124 9,397 9,679 620-0640-603.23-60 LAB MATERIALS & SUPPLIES Water Works Supplies 37,912 42,514 43,000 52,898 19,650 43,000 44,290 45,619 46,987 48,397 620-0640-603.23-62 MATERIALS & SUPPLIES Water Works Supplies 5,649 5,105 16,000 19,435 3,732 16,000 16,480 16,974 17,484 18,008 620-0640-603.31-35 OTHER Water Works Professional Services 17,774 27,687 58,000 83,520 3,618 268,000 59,740 41,000 42,230 43,497 620-0640-603.31-37 COMPUTER RELATED SERVICES Water Works Professional Services 4,125 - - - - - - - - - 620-0640-603.31-51 LABORATORY WATER TESTING Water Works Professional Services 22,642 24,265 62,000 62,600 10,896 30,000 30,900 31,827 32,782 33,765 620-0640-603.32-04 TELEPHONE Water Works Other Services & Charges 36,290 36,231 40,000 40,000 12,754 40,000 41,200 42,436 43,709 45,020 620-0640-603.35-02 NATURAL GAS Water Works Utilities 27,976 29,323 55,000 55,000 10,951 55,000 56,650 58,350 60,100 61,903 620-0640-603.36-05 OTHER EQUIP R&M Water Works Repairs & Maintenance - - - - - - - - 620-0640-603.37-04 UNIFORM RENTAL Water Works Other Services & Charges 4,694 5,750 7,500 7,500 2,470 7,500 7,725 7,957 8,195 8,441 620-0640-603.39-70 EDUCATION & TRAINING Water Works Education & Training 6,725 8,992 15,000 21,193 6,328 15,000 15,450 15,914 16,391 16,883 620-0640-604.23-10 REPAIR PARTS Water Works Supplies 209,077 342,504 285,000 323,570 140,595 300,000 309,000 318,270 327,818 337,653 620-0640-604.36-01 BUILDING R&M Water Works Repairs & Maintenance 17,385 4,956 5,000 6,370 1,370 5,000 5,150 5,305 5,464 5,628 620-0640-604.36-05 OTHER EQUIP R&M Water Works Repairs & Maintenance 3,383 13,018 5,000 6,398 2,452 7,000 7,210 7,426 7,649 7,879 620-0640-604.37-02 EQUIPMENT RENTAL Water Works Other Services & Charges - - 1,000 1,830 113 1,000 1,030 1,061 1,093 1,126 620-0640-605.21-02 PRINT SHOP Water Works Supplies 271 334 600 600 96 600 618 637 656 675 620-0640-605.21-03 C.S. OFFICE SUPPLIES Water Works Supplies 748 330 600 600 - - - - - - 620-0640-605.21-04 OFFICE SUPPLIES Water Works Supplies 1,676 1,404 9,900 9,900 1,350 12,000 12,360 12,731 13,113 13,506 620-0640-605.21-05 SMALL OFFICE EQUIPMENT Water Works Supplies 2,341 1,072 - - - - - - - - 620-0640-605.22-06 COMPUTER SUPPLIES Water Works Supplies - 81,168 - - - - - - - - 620-0640-605.22-07 LANDSCAPING MATERIAL Water Works Supplies 136 - 500 500 - 500 515 530 546 563 620-0640-605.22-20 C.S. MEDICAL/SAFETY Water Works Supplies 717 1,597 500 500 - - - - - - 620-0640-605.22-21 CLEANING SUPPLIES Water Works Supplies 285 850 1,000 1,000 93 1,000 1,030 1,061 1,093 1,126 620-0640-605.23-01 BUILDING MATERIALS Water Works Supplies 82 2,744 2,000 2,000 - 2,500 2,575 2,652 2,732 2,814 620-0640-605.23-20 SMALL TOOLS & EQUIPMENT Water Works Supplies 14,718 14,477 14,000 14,000 493 14,000 14,420 14,853 15,298 15,757 620-0640-605.23-21 C.S. SMALL TOOLS & EQUIP Water Works Supplies - 482 250 250 250 - - - - 620-0640-605.23-62 MATERIALS & SUPPLIES Water Works Supplies 60,479 36,313 78,500 110,153 37,254 178,500 150,000 150,000 150,000 150,000 620-0640-605.24-05 OTHER OPERATING SUPPLIES Water Works Supplies 795 4,718 - 369 369 - - - - - 620-0640-605.24-51 NON-CAPITAL OFFICE EQUIP.Water Works Supplies 995 - - - - - - - - - 620-0640-605.31-06 OTHER PROFESSIONAL SVCS Water Works Professional Services 115,802 88,720 151,000 170,203 11,937 80,000 155,000 80,000 155,000 80,000 620-0640-605.31-35 CONTRACTUAL SERVICE-OTHER Water Works Professional Services 15,237 12,444 20,000 22,462 7,246 20,000 20,600 21,218 21,855 22,510 620-0640-605.31-37 COMPUTER RELATED SERVICES Water Works Professional Services 2,090 - - - - - - - - - 620-0640-605.33-01 OUTSIDE PRINTING SERVICES Water Works Printing & Advertising - - 750 750 - 750 773 796 820 844 620-0640-605.35-01 ELECTRIC Water Works Utilities 8,584 8,539 10,000 10,000 3,171 10,000 10,300 10,609 10,927 11,255 620-0640-605.35-02 NATURAL GAS Water Works Utilities 8,162 11,827 10,000 10,000 7,158 12,000 12,360 12,731 13,113 13,506 620-0640-605.36-01 BUILDING R&M Water Works Repairs & Maintenance 25,057 - - - - - - - - - 620-0640-605.36-08 CONSTRUCTION EQUIP REPAIR Water Works Repairs & Maintenance - 154 1,200 1,200 - 1,200 1,236 1,273 1,311 1,351 620-0640-605.37-04 UNIFORM RENTAL Water Works Other Services & Charges 8,307 8,285 11,000 11,000 3,190 11,000 11,330 11,670 12,020 12,381 620-0640-605.39-70 EDUCATION & TRAINING Water Works Education & Training 3,673 100 4,000 4,000 1,107 4,000 4,120 4,244 4,371 4,502 620-0640-606.22-01 C.S. GASOLINE Water Works Supplies 65,038 78,734 112,206 112,206 25,009 105,938 109,116 112,390 115,761 119,234 620-0640-606.22-06 COMPUTER SUPPLIES Water Works Supplies 2,880 426 - - - - - - - - 620-0640-606.23-10 REPAIR PARTS Water Works Supplies 122,925 99,746 120,000 120,000 64,708 120,000 123,600 127,308 131,127 135,061 620-0640-606.23-20 SMALL TOOLS & EQUIPMENT Water Works Supplies 34,260 17,476 20,000 23,179 5,177 20,000 20,600 21,218 21,855 22,510 620-0640-606.23-30 CONCRETE & ASPHALT Water Works Supplies 53,360 78,344 120,000 120,402 34,198 100,000 103,000 106,090 109,273 112,551 620-0640-606.23-62 MATERIALS & SUPPLIES Water Works Supplies 386,698 269,774 362,255 451,871 132,251 482,255 482,255 482,255 482,255 482,255 87 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 620-0640-606.24-05 OTHER OPERATING SUPPLIES Water Works Supplies 7,690 5,196 - 150 115 - - - - - 620-0640-606.31-37 COMPUTER RELATED SERVICES Water Works Professional Services - - - - - - - - - - 620-0640-606.31-51 CONTRACTUAL SERVICE-OTHER Water Works Professional Services 44,372 80,212 250,000 251,675 23,006 500,000 515,000 530,450 546,364 562,754 620-0640-606.36-01 BUILDING R&M Water Works Repairs & Maintenance 15,140 18,161 12,000 12,000 1,479 15,000 15,450 15,914 16,391 16,883 620-0640-606.36-02 OFFICE EQUIP R&M Water Works Repairs & Maintenance 1,167 1,141 - - - - - - - - 620-0640-606.36-03 AUTO EQUIPMENT R&M Water Works Repairs & Maintenance 79,334 69,507 85,000 85,000 28,340 85,000 87,500 90,177 92,882 95,668 620-0640-606.36-08 CONSTRUCTION EQUIP REPAIR Water Works Repairs & Maintenance - 951 3,500 4,400 900 3,500 3,605 3,713 3,825 3,939 620-0640-606.36-50 STOP BOX REPAIRS Water Works Repairs & Maintenance 65,580 76,175 75,000 75,000 17,975 75,000 77,250 79,568 81,955 84,413 620-0640-606.36-61 WATER SYSTEM REPAIRS Water Works Repairs & Maintenance 14,928 16,671 40,000 40,690 1,559 40,000 41,200 42,436 43,709 45,020 620-0640-606.37-11 CAPITAL LEASE PRINCIPAL Water Works Debt Service 9,578 9,771 - - - - - - - - 620-0640-606.37-12 CAPITAL LEASE INTEREST Water Works Debt Service 544 366 - - - - - - - - 620-0640-606.38-01 PRINCIPAL Water Works Debt Service - - 8,843 8,843 4,408 8,963 - - - - 620-0640-606.38-02 INTEREST Water Works Debt Service - - 216 216 123 93 - - - - 620-0640-606.39-70 EDUCATION & TRAINING Water Works Education & Training 1,373 100 5,000 5,000 - 5,000 5,150 5,305 5,464 5,628 620-0640-657.21-02 PRINT SHOP Water Works Supplies 840 594 1,000 1,000 368 1,000 1,030 1,061 1,093 1,126 620-0640-657.21-03 C.S. OFFICE SUPPLIES Water Works Supplies 204 608 1,000 1,000 - - - - - - 620-0640-657.21-04 OFFICE SUPPLIES Water Works Supplies 6,282 7,200 22,850 23,839 4,378 8,000 8,240 8,487 8,742 9,004 620-0640-657.21-05 SMALL OFFICE EQUIPMENT Water Works Supplies 1,560 7,448 - 4,705 4,702 - - - - - 620-0640-657.22-06 COMPUTER SUPPLIES Water Works Supplies - 74 - - - - - - - - 620-0640-657.22-21 OTHER - MEDICAL/SAFETY Water Works Supplies 541 495 500 500 - 750 773 796 820 844 620-0640-657.22-22 MEDICAL/SAFETY SUPPLIES Water Works Supplies 32 55 350 350 - 500 515 530 546 563 620-0640-657.23-01 BUILDING MATERIALS Water Works Supplies 87 260 250 250 - 300 309 318 328 338 620-0640-657.24-51 NON-CAPITAL OFFICE EQUIP.Water Works Supplies 990 - - - - - - - - - 620-0640-657.31-06 OTHER PROFESSIONAL SVCS Water Works Professional Services 10,970 1,048 1,500 411,260 380,059 1,500 1,545 1,591 1,639 1,688 620-0640-657.31-35 CONTRACTUAL SERVICE-OTHER Water Works Professional Services 636,490 672,924 922,430 924,323 312,831 981,930 795,088 818,941 843,509 868,814 620-0640-657.31-37 COMPUTER RELATED SERVICES Water Works Professional Services 8,270 - - - - - - - - - 620-0640-657.31-39 COLLECTION AGENCY FEES Water Works Professional Services 8,338 9,623 12,000 12,000 7,301 30,000 30,900 31,827 32,782 33,765 620-0640-657.32-02 POSTAGE Water Works Other Services & Charges 5,434 5,150 6,000 6,000 2,430 6,000 6,180 6,365 6,556 6,753 620-0640-657.33-02 PUBLICATION LEGAL NOTICE Water Works Printing & Advertising - - 500 500 - - - - - - 620-0640-657.35-01 ELECTRIC Water Works Utilities 4,115 4,212 4,200 4,200 1,322 4,500 4,905 5,052 5,204 5,360 620-0640-657.35-02 NATURAL GAS Water Works Utilities 1,442 1,663 2,350 2,350 1,164 2,200 2,332 2,402 2,474 2,548 620-0640-657.36-01 BUILDING R&M Water Works Repairs & Maintenance 8,241 1,722 5,000 24,154 - 5,000 5,150 5,305 5,464 5,628 620-0640-657.36-02 OFFICE EQUIP R&M Water Works Repairs & Maintenance 43,772 8,918 - - - - - - - - 620-0640-657.37-04 UNIFORM RENTAL Water Works Other Services & Charges 1,770 1,408 2,100 2,100 742 2,100 2,163 2,228 2,295 2,364 620-0640-657.37-11 CAPITAL LEASE PRINCIPAL Water Works Debt Service 1,076 1,055 - - - - - - - - 620-0640-657.37-12 CAPITAL LEASE INTEREST Water Works Debt Service 100 31 - - - - - - - - 620-0640-657.39-10 SUBSCRIPTIONS Water Works Other Services & Charges - - 490,000 490,000 - - - - - - 620-0640-657.39-70 EDUCATION & TRAINING Water Works Education & Training - 1,799 3,000 3,000 990 3,000 3,090 3,183 3,278 3,377 620-0640-657.63-70 BAD DEBT EXPENSES Water Works Other Services & Charges 97,482 83,630 115,000 115,000 27,083 95,000 97,850 100,786 103,810 106,924 620-0640-657.63-71 CASHIER OVER/SHORT Water Works Other Services & Charges 35 169 125 125 1 200 200 200 200 200 620-0640-658.10-01 SALARIED WAGES Water Works Salaries & Wages 1,588,784 1,569,776 1,414,707 1,384,947 551,824 1,466,296 1,459,696 1,488,892 1,518,671 1,549,044 620-0640-658.10-02 TEAMSTER WAGES Water Works Salaries & Wages 1,545,664 1,568,202 1,718,910 1,718,910 673,599 1,734,372 1,743,206 1,755,984 1,768,918 1,782,340 620-0640-658.10-03 SEASONAL & INTERNS Water Works Salaries & Wages 17,186 19,207 51,200 51,200 - 52,224 53,280 54,336 55,424 56,544 620-0640-658.10-04 EXTRA AND OVERTIME Water Works Salaries & Wages 190,658 205,597 265,901 265,901 88,064 255,000 277,000 279,000 281,000 283,000 620-0640-658.10-06 LONGEVITY PAY Water Works Salaries & Wages 7,100 6,521 7,350 7,350 1,850 6,550 5,000 5,000 5,000 5,000 620-0640-658.10-09 PERMANENT PART-TIME Water Works Salaries & Wages 31,758 39,010 33,280 33,280 19,039 33,946 34,632 35,318 36,026 36,754 620-0640-658.10-13 SUPPLEMENTAL PAY Water Works Salaries & Wages 78,962 87,107 116,767 116,767 51,936 117,500 118,385 119,270 120,165 121,065 620-0640-658.11-01 FICA - REGULAR Water Works Fringe Benefits 256,848 259,729 277,786 277,786 103,103 282,607 284,543 288,109 291,734 295,451 620-0640-658.11-04 PERF - REGULAR Water Works Fringe Benefits 382,135 386,466 397,232 397,232 151,584 404,100 406,737 411,761 416,870 422,102 620-0640-658.11-05 PERF - UNION Water Works Fringe Benefits 24,795 22,078 31,908 31,908 9,020 32,050 32,202 32,437 32,675 32,920 620-0640-658.11-07 UNEMPLOYMENT COMP Water Works Fringe Benefits - - - - - 358 1,082 1,823 2,586 3,365 620-0640-658.11-08 HEALTH INSURANCE Water Works Fringe Benefits 972,402 953,867 656,952 656,952 245,323 738,137 958,637 990,137 1,053,137 1,116,137 620-0640-658.11-09 LIFE INSURANCE Water Works Fringe Benefits 7,976 7,917 8,040 8,040 3,000 8,040 8,040 8,040 8,040 8,040 88 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 620-0640-658.11-10 CLOTHING ALLOWANCE Water Works Fringe Benefits 4,096 1,159 5,000 5,000 179 5,000 5,000 5,000 5,000 5,000 620-0640-658.11-12 AUTO ALLOWANCE Water Works Fringe Benefits 2,100 2,380 - - - - - - - - 620-0640-658.11-22 PARKING ALLOWANCE Water Works Fringe Benefits 15,565 16,665 16,500 16,500 6,235 17,160 17,160 17,160 17,160 17,160 620-0640-658.11-24 CELL PHONE ALLOWANCE Water Works Fringe Benefits 6,604 6,232 4,800 4,800 1,660 5,040 5,040 5,040 5,040 5,040 620-0640-658.11-27 JOB READINESS ALLOWANCE Water Works Fringe Benefits 17,638 17,638 18,275 18,275 17,744 18,275 18,275 18,275 18,275 18,275 620-0640-658.11-29 PARENTAL LEAVE Water Works Fringe Benefits - 8,661 8,499 8,499 3,073 12,529 16,218 16,419 16,621 16,830 620-0640-658.11-99 OTHER FRINGE BENEFITS Water Works Fringe Benefits 2,125 2,000 4,000 4,000 - 3,000 3,000 3,000 3,000 3,000 620-0640-658.21-02 PRINT SHOP Water Works Supplies 37 49 350 350 - 350 361 371 382 394 620-0640-658.21-03 C.S. OFFICE SUPPLIES Water Works Supplies 902 753 1,175 1,175 - - - - - - 620-0640-658.21-04 OFFICE SUPPLIES Water Works Supplies 1,023 872 5,800 6,051 290 7,000 7,210 7,426 7,649 7,879 620-0640-658.21-05 SMALL OFFICE EQUIPMENT Water Works Supplies 910 - - - - - - - - - 620-0640-658.22-21 C.S. CLEANING SUPPLIES Water Works Supplies - - 50 50 - - - - - 620-0640-658.24-05 OTHER OPERATING SUPPLIES Water Works Supplies 35 - - - - - - - - - 620-0640-658.31-01 LEGAL SERVICES Water Works Professional Services 86,231 42,160 10,000 10,000 293 10,000 10,300 10,609 10,927 11,255 620-0640-658.31-02 ENGINEERING Water Works Professional Services 14,500 124,167 360,000 457,654 8,451 100,000 103,000 106,090 109,273 112,551 620-0640-658.31-04 ACCOUNTING Water Works Professional Services - - 5,000 4,881 - 5,000 5,150 5,305 5,464 5,628 620-0640-658.31-06 OTHER PROFESSIONAL SVCS Water Works Professional Services 200,352 128,150 100,000 119,759 3,410 100,000 103,000 - 109,273 112,551 620-0640-658.31-35 CONTRACTUAL SERVICE-OTHER Water Works Professional Services 25,254 21,032 25,150 26,077 8,911 27,500 28,325 29,175 30,050 30,951 620-0640-658.31-70 ADM FEE ALLOCATION Water Works Other Interfund Allocations 572,772 574,371 597,803 597,803 249,084 848,561 911,776 930,012 948,612 967,584 620-0640-658.31-71 CENTRAL STORES ALLOCATION Water Works Other Interfund Allocations 6,156 13,484 19,630 19,630 8,178 - - - - - 620-0640-658.31-73 PRINT SHOP ALLOCATION Water Works Other Interfund Allocations 6,216 5,197 7,538 7,538 3,142 6,559 5,953 5,843 5,966 6,090 620-0640-658.31-76 IT ALLOCATION Water Works Other Interfund Allocations 603,852 588,214 687,065 687,065 286,280 639,405 816,122 808,499 810,226 813,202 620-0640-658.31-77 PAYROLL COST ALLOCATION Water Works Other Interfund Allocations - - 474,284 474,284 197,616 494,691 513,348 522,440 531,713 541,176 620-0640-658.31-78 LIABILITY INSURANCE ALLOC Water Works Other Interfund Allocations - - 193,032 193,032 80,430 172,436 195,368 199,275 203,261 207,326 620-0640-658.31-79 FACILITIES MGMT ALLOC Water Works Other Interfund Allocations - - - - - 29,241 31,992 32,507 33,762 33,917 620-0640-658.32-02 POSTAGE Water Works Other Services & Charges 406 721 425 547 88 800 824 849 874 900 620-0640-658.32-03 TRAVEL Water Works Travel - - 18,750 18,750 2,134 18,750 19,313 19,892 20,489 21,103 620-0640-658.32-04 TELEPHONE Water Works Other Services & Charges 9,876 13,793 14,000 14,000 7,180 14,000 14,420 14,823 15,298 15,757 620-0640-658.32-21 TRAVEL - MILEAGE Water Works Travel 1,102 1,161 - - - - - - - - 620-0640-658.32-23 TRAVEL - HOTEL Water Works Travel 1,846 1,127 - - - - - - - - 620-0640-658.32-24 TRAVEL - MEALS Water Works Travel 731 398 - - - - - - - - 620-0640-658.32-25 TRAVEL - OTHER Water Works Travel 356 99 - - - - - - - - 620-0640-658.33-02 PUBLICATION LEGAL NOTICE Water Works Printing & Advertising 193 469 1,000 1,000 567 1,000 1,020 1,051 1,082 1,115 620-0640-658.33-03 PROMOTIONAL Water Works Printing & Advertising - - - - - - - - - 620-0640-658.34-02 LIABILITY INSURANCE Water Works Other Interfund Allocations 161,532 158,252 - - - - - - - - 620-0640-658.36-02 OFFICE EQUIP R&M Water Works Repairs & Maintenance 2,853 3,230 - - - - - - - - 620-0640-658.36-04 COMPUTER EQUIP R&M Water Works Repairs & Maintenance - - - - - - - - - - 620-0640-658.36-06 RADIO EQUIP R&M Water Works Repairs & Maintenance - - - - - 3,500 3,570 3,677 3,787 3,901 620-0640-658.37-04 UNIFORM RENTAL Water Works Other Services & Charges - 285 150 365 65 300 309 318 328 338 620-0640-658.37-06 BUILDING RENTAL Water Works Other Services & Charges 52,421 52,825 55,000 55,000 26,696 58,000 59,740 61,532 63,378 65,280 620-0640-658.37-11 CAPITAL LEASE PRINCIPAL Water Works Debt Service 199,395 382,790 - - - - - - - - 620-0640-658.37-12 CAPITAL LEASE INTEREST Water Works Debt Service 14,616 35,208 - - - - - - - - 620-0640-658.38-01 PRINCIPAL Water Works Debt Service - - 387,930 388,049 192,728 393,054 296,671 201,048 - - 620-0640-658.38-02 INTEREST Water Works Debt Service - - 22,798 22,798 12,291 15,432 8,064 3,131 - - 620-0640-658.39-11 DUES & MEMBERSHIPS Water Works Other Services & Charges 6,095 6,599 11,225 11,225 7,206 12,000 12,360 12,731 - - 620-0640-658.39-70 EDUCATION & TRAINING Water Works Education & Training 3,447 340 3,175 3,175 285 3,175 3,270 3,368 3,469 3,573 620-0640-658.50-01 STATE BOARD OF ACCOUNTS Water Works Professional Services - 18,205 10,000 10,000 - 12,000 13,000 14,000 15,000 16,000 620-0640-658.50-02 INTERFUND TRANSFER OUT Water Works Transfers Out 2,163,660 2,047,442 5,541,041 5,541,041 2,415,967 5,953,486 5,215,582 5,046,022 4,867,475 4,812,893 620-0640-658.60-02 STATE GROSS INCOME TAX Water Works Other Services & Charges 154,500 170,000 228,000 226,300 45,000 225,000 225,000 225,000 225,000 225,000 620-0640-658.60-03 PILOT TRANSFER OUT Water Works Transfers Out 1,785,924 1,730,831 1,662,624 1,662,624 692,760 1,629,442 1,629,442 1,629,442 1,629,442 1,629,442 620-0640-658.60-09 OTHER TAXES & LICENSES Water Works Other Services & Charges 5 5 20 20 5 20 20 20 20 20 620-0640-658.63-75 MISCELLANEOUS EXPENSES Water Works Other Services & Charges 39,643 39,643 42,000 43,700 43,700 45,000 45,000 45,000 45,000 45,000 620-0660-657.63-70 BAD DEBT EXPENSES Water Works Other Services & Charges 280 2,203 2,500 2,500 66 - - - - - 89 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 622-0640-415.42-02 BUILDING IMPROVEMENTS Water Works Capital - - 630,000 630,000 - 235,000 211,231 - 350,000 350,000 622-0640-415.43-02 MOTOR EQUIPMENT Water Works Capital 395,202 499,300 542,000 757,287 215,287 507,000 409,000 441,000 496,000 359,000 622-0640-415.43-10 MISCELLANEOUS EQUIPMENT Water Works Capital 23,098 12,995 38,000 30,235 - 20,000 10,000 - - 80,000 622-0640-415.43-61 PUMPING EQUIPMENT Water Works Capital - - - - - 78,000 81,000 100,000 200,000 200,000 622-0640-415.43-62 WATER TREATMENT EQUIPMENT Water Works Capital - - 1,231,000 1,051,600 - 1,443,000 822,000 - 350,000 350,000 622-0640-661.31-02 ENGINEERING Water Works Professional Services 61,511 11,896 - 179,404 4 - - - - 622-0640-661.46-02 WELLS Water Works Capital 26,799 - 525,000 532,765 - 179,000 422,461 - 350,000 350,000 622-0640-661.46-03 DISTRIBUTION RESERVOIRS Water Works Capital - - - - - - 330,000 - 350,000 350,000 622-0640-661.46-04 MAINS Water Works Capital - - - - - 680,000 867,000 1,900,000 600,000 600,000 622-0640-661.46-05 WATER METERS Water Works Capital - - 800,000 800,000 - - - - - - 624-0640-658.50-02 INTERFUND TRANSFER OUT Water Works Transfers Out 13,729 24,957 22,000 22,000 13,638 20,000 18,931 19,166 19,404 19,645 625-0640-471.38-01 PRINCIPAL Water Works Debt Service 1,395,912 - 1,487,345 2,918,962 1,431,617 1,338,099 1,383,877 1,434,682 1,045,513 1,086,373 625-0640-472.38-02 INTEREST Water Works Debt Service 608,550 283,967 527,196 811,248 284,050 482,387 441,705 399,340 354,962 316,520 625-0640-472.38-03 PAYING AGENT FEES Water Works Debt Service 635 1,000 500 500 500 1,000 1,000 1,000 1,000 1,000 625-0640-658.50-02 INTERFUND TRANSFER OUT Water Works Transfers Out 7,700 15,827 10,000 10,000 9,186 20,000 20,000 20,000 15,000 15,000 626-0640-658.50-02 INTERFUND TRANSFER OUT Water Works Transfers Out 16,000 24,000 22,000 22,000 9,582 20,000 17,918 18,140 18,365 18,593 629-0640-658.50-02 INTERFUND TRANSFER OUT Water Works Transfers Out 23,465 43,905 41,000 41,000 25,541 40,000 38,889 39,372 39,860 40,355 640-0620-811.10-01 SALARIED WAGES Streets & Sewers Salaries & Wages 88,977 94,140 58,716 58,716 24,841 59,890 61,088 62,310 63,556 64,827 640-0620-811.10-02 TEAMSTER WAGES Streets & Sewers Salaries & Wages 42,733 43,635 44,055 44,055 18,595 44,491 44,817 45,147 45,480 45,815 640-0620-811.10-04 EXTRA AND OVERTIME Streets & Sewers Salaries & Wages 3,973 3,300 2,625 2,625 1,157 2,652 2,679 2,706 2,733 2,760 640-0620-811.10-06 LONGEVITY Streets & Sewers Salaries & Wages 150 150 150 150 - 200 200 200 200 200 640-0620-811.10-13 CONTRACT ADD PAYS Streets & Sewers Salaries & Wages 8,972 7,073 7,999 7,999 3,708 8,080 7,999 7,999 7,999 7,999 640-0620-811.11-01 FICA - REGULAR Streets & Sewers Fringe Benefits 10,798 11,112 8,801 8,801 3,635 8,937 9,049 9,170 9,293 9,418 640-0620-811.11-04 PERF - REGULAR Streets & Sewers Fringe Benefits 16,129 16,802 12,886 12,886 5,508 13,084 13,248 13,425 13,605 13,788 640-0620-811.11-05 PERF - UNION Streets & Sewers Fringe Benefits 825 825 829 829 361 844 848 853 859 864 640-0620-811.11-07 UNEMPLOYMENT COMP Streets & Sewers Fringe Benefits - - - - - 12 35 59 83 109 640-0620-811.11-08 HEALTH INSURANCE Streets & Sewers Fringe Benefits 38,273 38,605 20,112 20,112 8,380 23,221 30,221 31,221 33,221 35,221 640-0620-811.11-09 LIFE INSURANCE Streets & Sewers Fringe Benefits 315 318 240 240 100 240 240 240 240 240 640-0620-811.11-24 CELL PHONE ALLOWANCE Streets & Sewers Fringe Benefits 1,262 1,295 1,080 1,080 450 1,080 1,080 1,080 1,080 1,080 640-0620-811.11-27 JOB READINESS ALLOWANCE Streets & Sewers Fringe Benefits 425 425 425 425 425 425 425 425 425 425 640-0620-811.11-29 PARENTAL LEAVE Streets & Sewers Fringe Benefits - 380 263 263 123 404 526 532 540 547 640-0620-811.21-02 PRINT SHOP Streets & Sewers Supplies 354 - 700 700 - 700 700 700 700 700 640-0620-811.21-03 C.S. OFFICE SUPPLIES Streets & Sewers Supplies 146 269 330 330 - - - - - - 640-0620-811.22-01 C.S. GASOLINE Streets & Sewers Supplies 1,693 2,299 3,704 3,704 788 9,248 9,433 9,622 9,815 10,011 640-0620-811.22-05 UNIFORMS Streets & Sewers Supplies 236 345 300 300 98 300 300 300 300 300 640-0620-811.22-22 MEDICAL/SAFETY SUPPLIES Streets & Sewers Supplies - - - - - - - - - 640-0620-811.22-24 OTHER OPERATING SUPPLIES Streets & Sewers Supplies 264 - 4,000 4,000 - 4,217 4,217 4,217 4,217 4,217 640-0620-811.23-04 SEWER MAINT MATERIALS Streets & Sewers Supplies 14,427 29,582 56,903 62,321 2,546 2,500 2,500 2,500 2,500 2,500 640-0620-811.31-70 ADM FEE ALLOCATION Streets & Sewers Other Interfund Allocations 18,840 17,763 20,457 20,457 8,522 24,608 26,441 26,970 27,509 28,059 640-0620-811.31-77 PAYROLL COST ALLOCATION Streets & Sewers Other Interfund Allocations - - 54,561 54,561 22,732 59,509 62,337 63,394 64,472 65,572 640-0620-811.31-78 LIABILITY INSURANCE ALLOC Streets & Sewers Other Interfund Allocations - - 477 477 197 394 442 451 460 469 640-0620-811.32-04 TELEPHONE Streets & Sewers Other Services & Charges 36 - - - - - - - - - 640-0620-811.34-02 LIABILITY INSURANCE Streets & Sewers Other Interfund Allocations 108 105 - - - - - - - - 640-0620-811.36-03 AUTO EQUIPMENT R&M Streets & Sewers Repairs & Maintenance 323 783 2,000 2,000 301 1,000 1,020 1,040 1,060 1,080 640-0620-811.36-09 SEWER REPAIR Streets & Sewers Repairs & Maintenance 277,261 249,859 325,000 349,655 120,472 385,000 385,000 385,000 385,000 385,000 640-0620-811.37-11 CAPITAL LEASE PRINCIPAL Streets & Sewers Debt Service 14,112 - - - - - - - - - 640-0620-811.37-12 CAPITAL LEASE INTEREST Streets & Sewers Debt Service 106 - - - - - - - - - 640-0620-811.63-70 BAD DEBT EXPENSE Streets & Sewers Other Services & Charges 6,277 6,150 6,500 6,500 1,528 6,500 6,500 6,500 6,500 6,500 641-0621-792.10-01 SALARIED WAGES Wastewater Salaries & Wages 442,922 485,222 318,578 318,578 108,279 331,778 333,315 339,983 346,781 353,717 641-0621-792.10-02 TEAMSTER WAGES Wastewater Salaries & Wages 1,112,477 1,107,418 1,186,890 1,186,890 465,520 1,200,348 1,209,443 1,218,585 1,227,807 1,237,095 641-0621-792.10-03 SEASONAL & INTERNS Wastewater Salaries & Wages 22,211 22,603 58,419 58,419 7,419 76,378 77,906 79,464 81,053 82,674 641-0621-792.10-04 EXTRA AND OVERTIME Wastewater Salaries & Wages 93,009 174,209 185,042 185,042 75,598 171,776 178,594 180,411 182,287 184,163 641-0621-792.10-06 LONGEVITY PAY Wastewater Salaries & Wages 3,600 3,342 3,250 3,250 1,100 2,300 2,500 3,250 3,450 4,100 90 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 641-0621-792.10-09 PERMANENT PART-TIME Wastewater Salaries & Wages 78,151 77,647 92,290 92,290 27,896 94,100 95,982 97,902 99,860 101,857 641-0621-792.10-10 HIRING BONUS Wastewater Salaries & Wages - 420 - - - - - - - - 641-0621-792.10-13 STAND BY PAY Wastewater Salaries & Wages 75,617 86,503 100,000 100,000 43,361 100,987 101,997 103,017 104,047 105,087 641-0621-792.11-01 FICA - REGULAR Wastewater Fringe Benefits 137,682 147,177 150,011 150,011 55,248 152,689 154,375 156,138 157,863 159,653 641-0621-792.11-04 PERF - REGULAR Wastewater Fringe Benefits 193,454 209,660 202,744 202,744 79,532 204,451 206,542 208,731 210,855 213,073 641-0621-792.11-05 PERF - UNION Wastewater Fringe Benefits 19,091 18,087 22,315 22,315 6,911 22,366 22,546 22,738 22,918 23,111 641-0621-792.11-07 UNEMPLOYMENT COMP Wastewater Fringe Benefits - - - - - 181 548 924 1,307 1,696 641-0621-792.11-08 HEALTH INSURANCE Wastewater Fringe Benefits 496,195 498,319 351,960 351,960 122,463 406,364 528,864 546,364 581,364 616,364 641-0621-792.11-09 LIFE INSURANCE Wastewater Fringe Benefits 4,095 4,212 4,200 4,200 1,512 4,200 4,200 4,200 4,200 4,200 641-0621-792.11-12 VEH/TOOL ALLOWANCE Wastewater Fringe Benefits 810 1,284 - - - - - - - - 641-0621-792.11-24 CELL PHONE ALLOWANCE Wastewater Fringe Benefits 3,949 3,878 3,960 3,960 1,155 5,940 5,940 5,940 5,940 5,940 641-0621-792.11-27 JOB READINESS ALLOWANCE Wastewater Fringe Benefits 12,495 10,795 12,495 12,495 11,900 12,325 12,325 12,495 12,325 12,325 641-0621-792.11-29 PARENTAL LEAVE Wastewater Fringe Benefits - 4,602 4,226 4,226 1,600 6,325 8,216 8,303 8,390 8,477 641-0621-792.11-99 OTHER FRINGE BENEFITS Wastewater Fringe Benefits 2,300 2,500 4,000 4,000 - 4,000 4,000 4,000 4,000 4,000 641-0621-792.21-02 PRINT SHOP Wastewater Supplies 386 749 750 750 - 750 750 750 750 750 641-0621-792.21-03 C.S. OFFICE SUPPLIES Wastewater Supplies 365 323 600 600 465 - - - - - 641-0621-792.21-04 OFFICE SUPPLIES Wastewater Supplies 1,061 1,752 4,500 4,658 1,335 5,100 5,100 5,100 5,100 5,100 641-0621-792.22-02 DIESEL/CNG Wastewater Supplies 136,210 130,427 172,296 172,296 40,296 166,460 169,790 173,185 180,183 183,787 641-0621-792.22-05 UNIFORMS Wastewater Supplies 7,402 7,831 9,328 9,328 2,072 9,375 9,375 9,375 9,375 9,375 641-0621-792.22-06 COMPUTER SUPPLIES Wastewater Supplies 710 1,291 - 75 67 - - - - - 641-0621-792.22-21 C.S. CLEANING SUPPLIES Wastewater Supplies 1,259 1,495 1,500 1,500 1,215 2,200 2,200 2,200 2,200 2,200 641-0621-792.22-22 MEDICAL/SAFETY SUPPLIES Wastewater Supplies 3,214 2,793 3,300 3,300 1,913 5,475 5,475 5,475 5,475 5,475 641-0621-792.22-24 OTHER OPERATING SUPPLIES Wastewater Supplies 10,436 16,924 43,000 43,901 1,376 43,000 43,000 43,000 43,000 43,000 641-0621-792.23-01 BUILDING MATERIALS Wastewater Supplies - - - - - - - - - - 641-0621-792.23-02 STREET MATERIAL Wastewater Supplies 135,401 105,877 200,000 220,402 23,081 200,000 200,000 200,000 200,000 200,000 641-0621-792.23-03 SEWER CONST. MATERIALS Wastewater Supplies 56,249 73,176 110,000 110,416 13,841 110,000 110,000 110,000 110,000 110,000 641-0621-792.23-04 SEWER MAINT MATERIALS Wastewater Supplies 80,869 48,060 141,733 142,375 9,981 141,733 141,733 141,733 141,733 141,733 641-0621-792.23-10 REPAIR PARTS Wastewater Supplies - - - - - - - - - - 641-0621-792.23-20 SMALL TOOLS & EQUIPMENT Wastewater Supplies 25,839 19,726 35,000 36,765 2,668 35,000 35,000 35,000 35,000 35,000 641-0621-792.23-40 SALT & WINTER MATERIALS Wastewater Supplies 60,330 51,576 109,200 175,760 64,674 109,200 109,200 109,200 109,200 109,200 641-0621-792.23-99 OTHER R&M SUPPLIES Wastewater Supplies - - - - - - - - - - 641-0621-792.31-01 LEGAL SERVICES Wastewater Professional Services 11,536 - 1,000 1,000 - 1,000 1,000 1,000 1,000 1,000 641-0621-792.31-70 ADM FEE ALLOCATION Wastewater Other Interfund Allocations 253,356 248,681 290,055 290,055 120,858 262,807 282,385 288,033 293,794 299,670 641-0621-792.31-71 CENTRAL STORES ALLOCATION Wastewater Other Interfund Allocations 3,360 7,980 11,133 11,133 4,637 - - - - - 641-0621-792.31-73 PRINT SHOP ALLOCATION Wastewater Other Interfund Allocations 2,112 2,449 3,750 3,750 1,559 3,712 3,369 3,306 3,376 3,446 641-0621-792.31-76 IT ALLOCATION Wastewater Other Interfund Allocations 33,108 383,412 500,231 500,231 208,429 401,956 515,753 510,935 512,026 513,908 641-0621-792.31-77 PAYROLL COST ALLOCATION Wastewater Other Interfund Allocations - - 375,501 375,501 156,457 388,205 403,144 409,762 416,508 423,388 641-0621-792.31-78 LIABILITY INSURANCE ALLOC Wastewater Other Interfund Allocations - - 140,185 140,185 58,411 165,649 204,726 208,821 212,997 217,257 641-0621-792.31-79 FACILITIES MGMT ALLOC Wastewater Other Interfund Allocations - - - - - 1,099 1,202 1,221 1,269 1,274 641-0621-792.32-03 TRAVEL Wastewater Travel - - 10,000 10,000 1,240 15,000 15,000 15,000 15,000 15,000 641-0621-792.32-04 TELEPHONE Wastewater Other Services & Charges 2,165 3,178 1,200 2,453 641 1,200 1,200 1,200 1,200 1,200 641-0621-792.32-22 TRAVEL - AIRFARE Wastewater Travel - 432 - - - - - - - - 641-0621-792.32-23 TRAVEL - HOTEL Wastewater Travel 966 480 - - - - - - - - 641-0621-792.32-24 TRAVEL - MEALS Wastewater Travel 55 737 - - - - - - - - 641-0621-792.32-25 TRAVEL - OTHER Wastewater Travel 56 479 - - - - - - - - 641-0621-792.33-02 PUBLICATION LEGAL NOTICE Wastewater Printing & Advertising 53 81 750 750 23 750 750 750 750 750 641-0621-792.34-02 LIABILITY INSURANCE Wastewater Other Interfund Allocations 110,268 118,812 - - - - - - - - 641-0621-792.35-01 ELECTRIC Wastewater Utilities 14,504 16,319 19,685 19,685 6,094 19,685 19,685 19,685 19,685 19,685 641-0621-792.35-02 NATURAL GAS Wastewater Utilities 12,505 12,879 15,675 15,675 10,585 15,675 15,675 15,675 15,675 15,675 641-0621-792.35-03 TRASH REMOVAL Wastewater Other Services & Charges - 1,143 792 792 536 1,464 1,464 1,464 1,464 1,464 641-0621-792.35-04 WATER Wastewater Utilities 6,397 6,440 6,400 6,400 2,735 7,200 7,200 7,200 7,200 7,200 641-0621-792.36-01 BUILDING R&M Wastewater Repairs & Maintenance 18,681 15,811 55,743 71,088 12,751 61,334 63,175 65,070 67,021 67,021 641-0621-792.36-02 OFFICE EQUIP R&M Wastewater Repairs & Maintenance 2,208 1,852 - - - - - - - - 91 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 641-0621-792.36-03 AUTO EQUIPMENT R&M Wastewater Repairs & Maintenance 500,293 445,160 497,000 497,000 138,101 497,000 506,940 517,079 527,420 527,420 641-0621-792.36-04 COMPUTER EQUIP R&M Wastewater Repairs & Maintenance - - - - - - - - - - 641-0621-792.36-05 OTHER EQUIP R&M Wastewater Repairs & Maintenance 5,506 505 3,500 3,500 - 3,500 3,500 3,500 3,500 3,500 641-0621-792.36-06 RADIO EQUIP R&M Wastewater Repairs & Maintenance 6,867 9,687 11,420 11,420 1,195 6,000 6,000 6,000 6,000 6,000 641-0621-792.36-07 COLLECTION SYSTEM Wastewater Repairs & Maintenance 11,182 9,553 20,000 20,000 5,305 30,000 30,000 30,000 30,000 30,000 641-0621-792.36-10 HAZARDOUS WASTE DISPOSAL Wastewater Repairs & Maintenance 63,039 41,648 90,000 124,432 16,414 145,102 145,102 145,102 145,102 145,102 641-0621-792.37-02 CAPITAL LEASE PAYMENTS Wastewater Other Services & Charges 24,300 16,322 30,000 30,000 - 30,000 30,000 30,000 30,000 30,000 641-0621-792.37-11 CAPITAL LEASE PRINCIPAL Wastewater Debt Service 184,065 102,319 - - - - - - - - 641-0621-792.37-12 CAPITAL LEASE INTEREST Wastewater Debt Service 4,192 2,008 - - - - - - - - 641-0621-792.38-01 PRINCIPAL Wastewater Debt Service - - 55,379 55,379 27,584 6,984 - - - - 641-0621-792.38-02 INTEREST Wastewater Debt Service - - 733 733 472 73 - - - - 641-0621-792.39-10 SUBSCRIPTIONS Wastewater Other Services & Charges - 41 - - - - - - - - 641-0621-792.39-11 DUES & MEMBERSHIPS Wastewater Other Services & Charges - - - - - - - - - - 641-0621-792.39-70 EDUCATION & TRAINING Wastewater Education & Training 4,145 4,279 10,000 10,000 9,440 15,000 15,000 15,000 15,000 15,000 641-0621-792.39-89 MISC CHARGES & SVCS Wastewater Other Services & Charges - 7,652 11,104 11,104 1,062 11,104 11,104 11,104 11,104 11,104 641-0621-792.63-35 CONTRACTUAL SERVICE-OTHER Wastewater Other Services & Charges 2,464,778 1,316,782 847,357 3,333,926 189,481 847,357 847,357 847,357 847,357 847,357 641-0621-792.63-70 BAD DEBT EXPENSE Wastewater Other Services & Charges 259,432 238,739 221,315 221,315 55,393 240,000 240,000 240,000 240,000 240,000 641-0625-792.10-01 SALARIED WAGES Wastewater Salaries & Wages 58,500 60,113 - - - - - - - - 641-0625-792.10-02 TEAMSTER WAGES Wastewater Salaries & Wages 108,836 123,446 171,081 171,081 69,834 172,770 174,050 175,340 176,639 177,949 641-0625-792.10-03 SEASONAL & INTERNS Wastewater Salaries & Wages 551 - 1,000 1,000 - - - - - - 641-0625-792.10-04 EXTRA AND OVERTIME Wastewater Salaries & Wages 7,786 13,166 15,960 15,960 7,438 15,987 16,147 16,308 16,471 16,636 641-0625-792.10-06 LONGEVITY PAY Wastewater Salaries & Wages - - - - 450 350 500 500 650 650 641-0625-792.10-09 PERMANENT PART-TIME Wastewater Salaries & Wages 682 1,346 - - - - - - - - 641-0625-792.10-10 HIRING BONUS Wastewater Salaries & Wages - 60 - - - - - - - - 641-0625-792.10-13 STAND BY PAY Wastewater Salaries & Wages 2,116 3,718 3,000 3,000 3,046 3,000 3,030 3,000 3,091 3,122 641-0625-792.11-01 FICA - REGULAR Wastewater Fringe Benefits 13,349 15,061 14,795 14,795 6,050 14,877 15,051 15,344 15,240 15,354 641-0625-792.11-04 PERF - REGULAR Wastewater Fringe Benefits 19,835 22,721 21,549 21,549 9,207 21,780 22,036 22,464 22,311 22,481 641-0625-792.11-05 PERF - UNION Wastewater Fringe Benefits 1,611 1,385 2,876 2,876 909 2,917 2,941 3,009 2,988 3,011 641-0625-792.11-07 UNEMPLOYMENT COMP Wastewater Fringe Benefits - - - - - 19 58 98 138 179 641-0625-792.11-08 HEALTH INSURANCE Wastewater Fringe Benefits 48,080 56,159 40,224 40,224 16,341 46,442 60,442 62,442 66,442 70,442 641-0625-792.11-09 LIFE INSURANCE Wastewater Fringe Benefits 418 461 480 480 195 480 480 480 480 480 641-0625-792.11-12 VEH/TOOL ALLOWANCE Wastewater Fringe Benefits 630 798 - - - - - - - - 641-0625-792.11-24 CELL PHONE ALLOWANCE Wastewater Fringe Benefits 310 311 660 660 165 660 1,320 660 660 660 641-0625-792.11-27 JOB READINESS ALLOWANCE Wastewater Fringe Benefits 850 1,275 1,700 1,700 1,275 1,700 1,700 1,700 1,700 1,700 641-0625-792.11-29 PARENTAL LEAVE Wastewater Fringe Benefits - 497 468 468 206 672 871 892 885 893 641-0625-792.11-99 OTHER FRINGE BENEFITS Wastewater Fringe Benefits - 200 - - - 1,000 1,000 1,000 1,000 1,000 641-0625-792.22-02 DIESEL/CNG Wastewater Supplies 2,727 6,913 9,264 9,264 1,227 9,248 9,433 9,622 9,815 10,010 641-0625-792.22-05 UNIFORMS Wastewater Supplies 488 439 1,350 1,727 357 1,350 1,350 1,350 1,350 1,350 641-0625-792.22-24 OTHER OPERATING SUPPLIES Wastewater Supplies 10,984 332 24,000 31,334 7,334 20,000 20,000 20,000 20,000 20,000 641-0625-792.23-04 SEWER MAINT MATERIALS Wastewater Supplies 35,480 51,226 69,468 73,444 16,349 73,000 73,000 73,000 73,000 73,000 641-0625-792.23-20 SMALL TOOLS & EQUIPMENT Wastewater Supplies 1,047 5,423 10,000 10,000 - 10,000 10,000 10,000 10,000 10,000 641-0625-792.31-70 ADM FEE ALLOCATION Wastewater Other Interfund Allocations 15,192 14,979 16,484 16,484 6,866 19,617 21,078 21,500 21,930 22,369 641-0625-792.31-77 PAYROLL COST ALLOCATION Wastewater Other Interfund Allocations - - 82,529 82,529 34,383 86,796 89,808 91,374 92,962 94,588 641-0625-792.31-78 LIABILITY INSURANCE ALLOC Wastewater Other Interfund Allocations - - 715 715 295 6,946 13,447 13,716 13,990 14,270 641-0625-792.34-02 LIABILITY INSURANCE Wastewater Other Interfund Allocations 408 417 - - - - - - - - 641-0625-792.36-03 AUTO EQUIPMENT R&M Wastewater Repairs & Maintenance 4,099 7,051 17,100 17,100 1,287 8,000 8,160 8,323 8,490 8,660 641-0625-792.39-88 PENALTIES/FEES Wastewater Other Services & Charges 3,500 - - - - - - - - - 641-0630-793.10-01 SALARIED WAGES Wastewater Salaries & Wages 1,358,898 1,410,166 1,271,884 1,271,884 505,109 1,297,324 1,323,269 1,349,737 1,376,731 1,404,266 641-0630-793.10-02 TEAMSTER WAGES Wastewater Salaries & Wages 977,295 948,063 1,061,824 1,061,824 403,647 1,075,971 1,084,158 1,092,393 1,100,694 1,109,061 641-0630-793.10-03 SEASONAL & INTERNS Wastewater Salaries & Wages 16,939 - 20,480 20,480 - 20,480 20,480 20,480 20,480 20,480 641-0630-793.10-04 EXTRA AND OVERTIME Wastewater Salaries & Wages 167,946 130,009 153,600 153,600 68,458 159,900 161,499 163,114 164,745 166,393 641-0630-793.10-06 LONGEVITY PAY Wastewater Salaries & Wages 4,100 3,825 5,000 5,000 2,054 5,200 5,400 5,508 5,618 5,731 641-0630-793.10-09 PERMANENT PART-TIME Wastewater Salaries & Wages 7,847 15,485 - - - - - - - - 92 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 641-0630-793.10-10 HIRING BONUS Wastewater Salaries & Wages - 690 - - - - - - - - 641-0630-793.10-13 STAND BY PAY Wastewater Salaries & Wages 93,617 97,198 109,874 109,874 41,072 113,152 114,284 115,426 116,581 117,746 641-0630-793.11-01 FICA - REGULAR Wastewater Fringe Benefits 197,035 195,570 202,203 202,203 76,729 205,934 208,772 211,644 214,566 217,534 641-0630-793.11-04 PERF - REGULAR Wastewater Fringe Benefits 291,274 292,820 293,743 293,743 115,712 299,204 303,355 307,562 311,841 316,187 641-0630-793.11-05 PERF - UNION Wastewater Fringe Benefits 17,203 14,691 20,107 20,107 6,260 20,466 20,633 20,801 20,966 21,136 641-0630-793.11-07 UNEMPLOYMENT COMP Wastewater Fringe Benefits - - - - - 265 806 1,363 1,934 2,521 641-0630-793.11-08 HEALTH INSURANCE Wastewater Fringe Benefits 565,159 611,805 400,464 400,464 150,091 461,158 597,658 617,158 656,158 695,158 641-0630-793.11-09 LIFE INSURANCE Wastewater Fringe Benefits 5,266 5,308 5,280 5,280 2,020 5,280 5,280 5,280 5,280 5,280 641-0630-793.11-12 AUTO ALLOWANCE Wastewater Fringe Benefits 1,891 2,570 2,400 2,400 750 1,800 1,800 1,800 1,800 1,800 641-0630-793.11-24 CELL PHONE ALLOWANCE Wastewater Fringe Benefits 8,637 8,747 7,920 7,920 2,705 7,920 7,920 7,920 7,920 7,920 641-0630-793.11-27 JOB READINESS ALLOWANCE Wastewater Fringe Benefits 9,669 9,775 10,200 10,200 9,350 10,200 10,200 10,200 10,200 10,200 641-0630-793.11-29 PARENTAL LEAVE Wastewater Fringe Benefits - 6,660 6,218 6,218 2,484 9,280 12,100 12,269 12,441 12,613 641-0630-793.11-99 OTHER FRINGE BENEFITS Wastewater Fringe Benefits 1,920 1,588 2,500 2,500 - 2,500 2,500 2,500 2,500 2,500 641-0630-793.21-02 PRINT SHOP Wastewater Supplies 99 184 200 200 31 200 200 200 200 200 641-0630-793.21-03 C.S. OFFICE SUPPLIES Wastewater Supplies 1,570 663 1,500 1,500 - - - - - - 641-0630-793.21-04 OFFICE SUPPLIES Wastewater Supplies 7,399 5,030 9,000 9,000 5,720 10,000 10,000 10,000 10,000 10,000 641-0630-793.21-05 SMALL OFFICE EQUIPMENT Wastewater Supplies - 5,041 - - - - - - - - 641-0630-793.22-01 C.S. GASOLINE Wastewater Supplies 14,781 23,305 26,063 26,063 7,734 28,167 29,575 31,054 32,607 34,237 641-0630-793.22-02 DIESEL/CNG Wastewater Supplies 3,309 4,531 6,000 6,000 - 5,000 5,050 5,101 5,152 5,203 641-0630-793.22-05 UNIFORMS Wastewater Supplies 18,662 18,883 23,500 26,717 8,041 23,000 23,000 23,000 23,000 23,000 641-0630-793.22-12 OIL Wastewater Supplies 9,839 17,785 8,500 8,689 3,579 14,000 14,700 15,435 16,207 17,017 641-0630-793.22-20 C.S. MEDICAL/SAFETY Wastewater Supplies 947 679 1,500 1,500 - - - - - - 641-0630-793.22-21 C.S. CLEANING SUPPLIES Wastewater Supplies 4,430 3,773 5,000 5,000 1,735 5,000 5,000 5,000 5,000 5,000 641-0630-793.22-22 MEDICAL/SAFETY SUPPLIES Wastewater Supplies 8,539 5,419 6,275 6,275 66 6,275 6,401 6,529 6,659 6,792 641-0630-793.22-61 PROCESS COMPUTERS Wastewater Supplies 11,763 20,439 - - - - - - - - 641-0630-793.23-10 REPAIR PARTS Wastewater Supplies 247,894 506,819 400,000 455,968 174,322 400,000 404,000 424,200 428,442 432,726 641-0630-793.23-20 SMALL TOOLS & EQUIPMENT Wastewater Supplies 21,459 27,207 25,000 26,901 4,389 27,000 27,000 27,000 27,000 27,000 641-0630-793.23-21 C.S. SMALL TOOLS & EQUIP Wastewater Supplies - - 100 100 - - - - - - 641-0630-793.23-60 LAB MATERIALS & SUPPLIES Wastewater Supplies 40,955 35,393 43,000 52,684 23,643 40,000 40,400 40,804 41,212 41,624 641-0630-793.23-62 MATERIALS & SUPPLIES Wastewater Supplies 198,680 183,113 215,000 256,098 91,144 210,000 211,050 212,105 213,166 214,232 641-0630-793.31-01 LEGAL SERVICES Wastewater Professional Services 330,700 190,329 400,000 400,000 12,064 350,000 353,500 357,035 360,605 364,211 641-0630-793.31-02 ENGINEERING Wastewater Professional Services 959,781 1,138,782 1,150,000 1,798,007 389,006 1,150,000 1,173,000 1,196,460 1,220,389 1,244,797 641-0630-793.31-04 ACCOUNTING Wastewater Professional Services 17,459 5,250 40,000 62,541 - 40,000 40,000 40,000 40,000 40,000 641-0630-793.31-06 OTHER PROFESSIONAL SVCS Wastewater Professional Services - - - 3,500 3,500 - - - - - 641-0630-793.31-07 MGMT FEE TO WATER WORKS Wastewater Other Interfund Allocations 1,442,856 1,205,781 1,438,428 1,438,428 599,345 1,485,327 1,531,372 1,578,845 1,627,789 1,678,250 641-0630-793.31-09 CONTRACT LAB ANALYSIS Wastewater Professional Services 28,010 30,631 60,000 70,007 12,263 60,000 60,300 60,602 60,905 61,209 641-0630-793.31-10 BOND ISSUANCE COSTS Wastewater Professional Services 1,500 - - - - - - - - - 641-0630-793.31-70 ADM FEE ALLOCATION Wastewater Other Interfund Allocations 981,276 1,041,111 1,250,680 1,250,680 521,119 1,254,547 1,348,007 1,374,967 1,402,466 1,430,515 641-0630-793.31-71 CENTRAL STORES ALLOCATION Wastewater Other Interfund Allocations 7,248 14,308 22,631 22,631 9,429 - - - - - 641-0630-793.31-73 PRINT SHOP ALLOCATION Wastewater Other Interfund Allocations 1,380 1,128 1,177 1,177 491 999 907 890 909 928 641-0630-793.31-76 IT ALLOCATION Wastewater Other Interfund Allocations 242,796 456,929 562,970 562,970 234,572 459,284 575,087 569,715 570,932 573,029 641-0630-793.31-77 PAYROLL COST ALLOCATION Wastewater Other Interfund Allocations - - 629,653 629,653 262,356 648,149 666,717 678,276 690,063 702,085 641-0630-793.31-78 LIABILITY INSURANCE ALLOC Wastewater Other Interfund Allocations - - 253,364 253,364 105,566 253,826 262,456 267,705 273,059 278,520 641-0630-793.31-79 FACILITIES MGMT ALLOC Wastewater Other Interfund Allocations - - - - - 37,212 40,713 41,367 42,964 43,163 641-0630-793.32-02 POSTAGE Wastewater Other Services & Charges 4,028 2,670 5,000 6,014 1,125 5,000 5,000 5,000 5,000 5,000 641-0630-793.32-03 TRAVEL Wastewater Travel - - 30,000 30,000 1,100 30,000 30,000 30,000 30,000 30,000 641-0630-793.32-04 TELEPHONE Wastewater Other Services & Charges 7,675 9,000 10,850 12,472 4,475 6,000 6,060 6,121 6,182 6,244 641-0630-793.32-21 TRAVEL - MILEAGE Wastewater Travel 1,441 1,158 - - - - - - - - 641-0630-793.32-22 TRAVEL - AIRFARE Wastewater Travel - 2,140 - - - - - - - - 641-0630-793.32-23 TRAVEL - HOTEL Wastewater Travel 2,763 6,467 - - - - - - - - 641-0630-793.32-24 TRAVEL - MEALS Wastewater Travel 1,082 1,633 - - - - - - - - 641-0630-793.32-25 TRAVEL - OTHER Wastewater Travel 595 1,393 - - - - - - - - 641-0630-793.33-02 PUBLICATION LEGAL NOTICE Wastewater Printing & Advertising 1,041 570 3,000 3,000 228 3,000 3,000 3,000 3,000 3,000 93 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 641-0630-793.34-02 LIABILITY INSURANCE Wastewater Other Interfund Allocations 193,908 208,803 - - - - - - - - 641-0630-793.35-01 ELECTRIC Wastewater Utilities 844,676 866,465 926,500 926,500 329,355 900,000 909,000 918,090 927,271 936,544 641-0630-793.35-02 NATURAL GAS Wastewater Utilities 122,244 122,390 185,300 185,300 86,887 340,000 350,200 360,706 371,527 382,573 641-0630-793.35-04 WATER Wastewater Utilities 16,774 12,085 30,000 35,915 9,155 20,000 20,100 20,201 20,302 20,403 641-0630-793.36-01 BUILDING R&M Wastewater Repairs & Maintenance 378,866 226,233 443,500 603,907 81,142 643,500 675,675 709,459 744,932 782,178 641-0630-793.36-03 AUTO EQUIPMENT R&M Wastewater Repairs & Maintenance 57,035 54,776 42,000 42,000 14,291 55,000 55,550 56,106 56,667 57,233 641-0630-793.36-04 COMPUTER EQUIP R&M Wastewater Repairs & Maintenance - - - - - - - - - - 641-0630-793.36-05 OTHER EQUIP R&M Wastewater Repairs & Maintenance 766,883 197,965 595,000 1,009,408 279,356 395,000 396,975 398,960 400,955 402,959 641-0630-793.36-06 RADIO EQUIP R&M Wastewater Repairs & Maintenance 8,628 2,285 1,500 2,350 1,196 2,500 2,500 2,500 2,500 2,500 641-0630-793.36-10 HAZARDOUS MAT'L REMOVAL Wastewater Repairs & Maintenance 200 - 500 1,000 500 500 500 500 500 500 641-0630-793.37-11 CAPITAL LEASE PRINCIPAL Wastewater Debt Service 145,947 17,296 - - - - - - - - 641-0630-793.37-12 CAPITAL LEASE INTEREST Wastewater Debt Service 14,400 1,985 - - - - - - - - 641-0630-793.38-01 PRINCIPAL Wastewater Debt Service - - 10,083 10,083 3,511 7,233 4,370 - - - 641-0630-793.38-02 INTEREST Wastewater Debt Service - - 846 846 343 331 90 - - - 641-0630-793.39-10 SUBSCRIPTIONS Wastewater Other Services & Charges 52,015 1,747 490,000 972,354 384,757 - - - - - 641-0630-793.39-11 DUES & MEMBERSHIPS Wastewater Other Services & Charges 16,945 18,220 28,500 25,000 - 28,500 28,500 28,500 28,500 28,500 641-0630-793.39-39 CREDIT CARD FEES Wastewater Other Services & Charges 1,303 1,290 500 1,300 504 1,300 1,300 1,300 1,300 1,300 641-0630-793.39-70 EDUCATION & TRAINING Wastewater Education & Training 7,232 8,559 24,000 23,200 3,765 24,000 24,000 24,000 24,000 24,000 641-0630-793.39-88 PENALTIES Wastewater Other Services & Charges - 2,080 3,000 3,000 - 3,000 3,000 3,000 3,000 3,000 641-0630-793.39-89 MISC CHARGES & SVCS Wastewater Other Services & Charges - - 100 100 - 100 100 100 100 100 641-0630-793.50-01 STATE BOARD OF ACCOUNTS Wastewater Professional Services - 18,942 16,000 16,000 - 16,000 16,000 16,000 16,000 16,000 641-0630-793.50-02 INTERFUND TRANSFER OUT Wastewater Transfers Out 13,612,325 12,697,559 12,923,578 12,973,906 5,560,230 15,782,102 10,895,786 10,512,319 10,048,133 9,721,356 641-0630-793.60-03 PAYMENT IN LIEU OF TAX Wastewater Transfers Out 4,422,408 4,601,656 4,678,366 4,678,366 1,949,318 4,592,349 4,592,349 4,592,349 4,592,349 4,592,349 641-0630-793.63-35 CONTRACTUAL SERVICE-OTHER Wastewater Other Services & Charges 641,007 1,113,921 1,175,500 1,408,966 310,035 1,215,500 1,251,965 1,289,524 1,328,210 1,368,056 641-0630-793.63-36 WASTE HAULING Wastewater Other Services & Charges 62,000 57,663 72,000 75,400 31,533 72,000 75,600 79,380 83,349 87,516 641-0630-793.63-37 BASEMENT VALVE FUND Wastewater Other Services & Charges 68,631 38,945 50,000 50,000 3,550 50,000 50,000 50,000 50,000 50,000 641-0630-793.65-06 VARIOUS CHEMICALS Wastewater Supplies 284,939 273,560 378,150 505,187 130,760 401,350 421,418 442,488 464,613 487,843 641-0631-793.10-01 SALARIED WAGES Wastewater Salaries & Wages 117,028 120,501 102,530 102,530 43,026 104,582 106,673 108,806 110,982 113,202 641-0631-793.10-02 TEAMSTER WAGES Wastewater Salaries & Wages 154,463 163,499 164,736 164,736 67,441 166,384 167,632 168,888 170,156 171,432 641-0631-793.10-04 EXTRA AND OVERTIME Wastewater Salaries & Wages 15,884 9,567 38,016 38,016 5,450 38,301 39,067 39,848 40,645 48,775 641-0631-793.10-05 TEMPORARY SERVICES Wastewater Salaries & Wages 1,807 - - - - - - - - - 641-0631-793.10-06 LONGEVITY PAY Wastewater Salaries & Wages 400 650 900 900 450 900 900 900 900 900 641-0631-793.10-13 STAND BY PAY Wastewater Salaries & Wages 8,796 10,631 10,395 10,395 7,405 10,495 10,705 10,919 11,137 11,360 641-0631-793.11-01 FICA - REGULAR Wastewater Fringe Benefits 23,004 23,699 24,399 24,399 9,642 24,711 25,041 25,377 25,718 26,624 641-0631-793.11-04 PERF - REGULAR Wastewater Fringe Benefits 33,241 34,532 35,721 35,721 14,084 36,178 36,662 37,153 37,652 38,979 641-0631-793.11-05 PERF - UNION Wastewater Fringe Benefits 2,237 2,100 3,236 3,236 915 3,267 3,300 3,334 3,368 3,513 641-0631-793.11-07 UNEMPLOYMENT COMP Wastewater Fringe Benefits - - - - - 32 97 164 233 311 641-0631-793.11-08 HEALTH INSURANCE Wastewater Fringe Benefits 55,543 53,637 60,336 60,336 14,640 39,842 50,342 51,842 54,842 57,842 641-0631-793.11-09 LIFE INSURANCE Wastewater Fringe Benefits 714 744 720 720 300 720 720 720 720 720 641-0631-793.11-12 AUTO ALLOWANCE Wastewater Fringe Benefits 600 740 - - - - - - - - 641-0631-793.11-24 CELL PHONE ALLOWANCE Wastewater Fringe Benefits 792 792 660 660 275 660 660 660 660 660 641-0631-793.11-27 JOB READINESS ALLOWANCE Wastewater Fringe Benefits 1,913 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 641-0631-793.11-29 PARENTAL LEAVE Wastewater Fringe Benefits - 790 763 763 319 1,122 1,463 1,481 1,502 1,555 641-0631-793.11-99 OTHER FRINGE BENEFITS Wastewater Fringe Benefits 200 200 450 450 - 450 450 450 450 450 641-0631-793.21-02 PRINT SHOP Wastewater Supplies - - 100 100 - 100 102 104 106 108 641-0631-793.21-04 OFFICE SUPPLIES Wastewater Supplies 234 281 1,000 1,000 349 1,000 1,050 1,103 1,158 1,216 641-0631-793.22-01 C.S. GASOLINE Wastewater Supplies 73,128 86,514 88,586 88,586 14,463 94,278 98,992 103,941 109,139 114,595 641-0631-793.22-05 UNIFORMS Wastewater Supplies 1,574 1,300 2,400 3,402 592 3,000 3,000 3,000 3,000 3,000 641-0631-793.22-21 C.S. CLEANING SUPPLIES Wastewater Supplies 395 252 300 300 - 300 300 300 300 300 641-0631-793.22-22 MEDICAL/SAFETY SUPPLIES Wastewater Supplies 156 200 200 200 - 200 200 200 200 200 641-0631-793.23-10 REPAIR PARTS Wastewater Supplies 388 529 2,000 2,000 116 2,000 2,100 2,205 2,315 2,431 641-0631-793.23-21 C.S. SMALL TOOLS & EQUIP Wastewater Supplies 112 171 2,000 2,000 219 - - - - - 641-0631-793.23-62 MATERIALS & SUPPLIES Wastewater Supplies 385 232 1,000 1,000 311 3,000 3,000 3,000 3,000 3,000 94 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 641-0631-793.31-70 ADM FEE ALLOCATION Wastewater Other Interfund Allocations 47,616 53,452 56,806 56,806 23,668 63,701 68,446 69,815 71,211 72,635 641-0631-793.31-71 CENTRAL STORES ALLOCATION Wastewater Other Interfund Allocations 456 1,254 1,297 1,297 541 - - - - - 641-0631-793.31-76 IT ALLOCATION Wastewater Other Interfund Allocations 6,576 59,508 63,403 63,403 26,415 43,523 56,902 56,370 56,490 56,698 641-0631-793.31-77 PAYROLL COST ALLOCATION Wastewater Other Interfund Allocations - - 28,434 28,434 11,844 29,239 29,805 30,359 30,924 31,501 641-0631-793.31-78 LIABILITY INSURANCE ALLOC Wastewater Other Interfund Allocations - - 1,430 1,430 597 37,141 74,683 76,177 77,701 79,255 641-0631-793.31-79 FACILITIES MGMT ALLOC Wastewater Other Interfund Allocations - - - - - 308 337 342 355 357 641-0631-793.32-02 POSTAGE Wastewater Other Services & Charges 85 211 200 234 83 300 315 331 347 365 641-0631-793.32-03 TRAVEL Wastewater Travel - - 3,000 3,000 107 3,000 3,000 3,000 3,000 3,000 641-0631-793.32-04 TELEPHONE Wastewater Other Services & Charges - - 1,000 1,000 - - - - - - 641-0631-793.32-05 OTHER COMM/TRANS Wastewater Travel 710 710 1,500 1,500 365 1,500 1,500 1,500 1,500 1,500 641-0631-793.32-21 TRAVEL - MILEAGE Wastewater Travel 210 477 - - - - - - - - 641-0631-793.32-23 TRAVEL - HOTEL Wastewater Travel - 537 - - - - - - - - 641-0631-793.32-24 TRAVEL - MEALS Wastewater Travel - 26 - - - - - - - - 641-0631-793.33-02 PUBLICATION LEGAL NOTICE Wastewater Printing & Advertising 40 95 200 200 - 200 200 200 200 200 641-0631-793.34-02 LIABILITY INSURANCE Wastewater Other Interfund Allocations 1,224 1,251 - - - - - - - - 641-0631-793.35-01 ELECTRIC Wastewater Utilities 2,217 2,506 3,600 3,600 979 3,600 3,636 3,672 3,709 3,746 641-0631-793.35-02 NATURAL GAS Wastewater Utilities 4,740 5,675 7,000 7,000 4,362 7,000 7,210 7,426 7,649 7,879 641-0631-793.35-04 WATER Wastewater Utilities 521 1,125 1,700 1,700 292 1,700 1,709 1,717 1,726 1,734 641-0631-793.36-01 BUILDING R&M Wastewater Repairs & Maintenance 30,803 5,499 35,000 42,160 397 20,000 20,000 20,000 20,000 20,000 641-0631-793.36-03 AUTO EQUIPMENT R&M Wastewater Repairs & Maintenance 169,532 300,734 150,000 150,000 109,435 180,000 181,800 183,618 185,454 187,309 641-0631-793.36-04 COMPUTER EQUIP R&M Wastewater Repairs & Maintenance - - - - - - - - - - 641-0631-793.36-05 OTHER EQUIP R&M Wastewater Repairs & Maintenance - - 100 100 - 500 500 500 500 500 641-0631-793.36-06 RADIO EQUIP R&M Wastewater Repairs & Maintenance 1,092 1,476 1,000 1,000 72 1,500 1,500 1,500 1,500 1,500 641-0631-793.37-11 CAPITAL LEASE PRINCIPAL Wastewater Debt Service 324,284 482,499 - - - - - - - - 641-0631-793.37-12 CAPITAL LEASE INTEREST Wastewater Debt Service 19,885 37,603 - - - - - - - - 641-0631-793.38-01 PRINCIPAL Wastewater Debt Service - - 501,459 501,459 249,442 509,521 290,044 188,482 - - 641-0631-793.38-02 INTEREST Wastewater Debt Service - - 24,418 24,418 13,261 15,874 7,725 2,935 - - 641-0631-793.39-11 DUES & MEMBERSHIPS Wastewater Other Services & Charges 70 70 250 250 - 1,400 1,400 1,400 1,400 1,400 641-0631-793.39-70 EDUCATION & TRAINING Wastewater Education & Training 174 110 2,000 2,000 - 2,500 2,500 2,500 2,500 2,500 641-0631-793.63-35 CONTRACTUAL SERVICE-OTHER Wastewater Other Services & Charges 185,100 87,165 177,950 212,119 47,673 132,950 132,950 132,950 132,950 132,950 641-0631-793.63-36 WASTE HAULING Wastewater Other Services & Charges - - 10,000 10,000 - 40,000 40,000 40,000 40,000 40,000 641-0631-793.63-39 CLOSED LANDFILL MONITORIN Wastewater Other Services & Charges - 2,350 25,000 27,350 2,350 27,350 27,350 27,350 27,350 27,350 641-0650-851.74-01 BAD DEBT EXPENSE Wastewater Other Services & Charges 895 6,417 2,000 2,000 321 - - - - - 642-0621-415.42-05 SEWER REHABILITATION Wastewater Capital - - 2,500,000 4,766,957 232,684 6,250,000 1,750,000 2,250,000 1,950,000 1,600,000 642-0621-415.43-02 MOTOR EQUIPMENT Wastewater Capital 638,930 982,437 1,280,000 1,941,811 343,195 1,010,000 1,137,000 370,000 265,000 405,000 642-0630-415.43-02 MOTOR EQUIPMENT Wastewater Capital 215,607 47,083 225,000 454,550 229,550 386,000 390,000 320,000 230,000 77,000 642-0630-415.43-08 COMPUTER EQUIP. & NETWORK Wastewater Capital - - - 15,200 15,200 - - - - - 642-0630-415.43-10 MISCELLANEOUS EQUIPMENT Wastewater Capital 5,192 - 515,000 515,000 - 15,000 25,000 - 15,000 30,000 642-0630-415.43-66 TREATMENT & DISPOSAL EQ.Wastewater Capital 3,410,641 1,261,651 2,000,000 7,329,774 927,435 - - - - - 643-0630-415.50-02 INTERFUND TRANSFER OUT Wastewater Transfers Out 45,349 88,247 84,000 84,000 49,894 120,000 70,170 71,041 71,922 72,815 649-0630-472.38-01 PRINCIPAL Wastewater Debt Service 6,835,000 6,980,000 5,760,000 5,760,000 - 5,900,000 6,055,000 6,220,000 6,390,000 6,570,000 649-0630-472.38-02 INTEREST Wastewater Debt Service 2,094,861 1,942,480 1,786,988 1,786,988 893,279 1,654,328 1,513,402 1,368,632 1,214,446 1,055,669 649-0630-472.38-03 PAYING AGENT FEES Wastewater Debt Service 2,750 2,800 5,000 5,550 2,400 5,000 5,000 5,000 5,000 5,000 649-0630-473.38-01 PRINCIPAL 98 BOND SRF Wastewater Debt Service 162,472 167,038 171,732 171,732 - 176,557 181,519 186,619 191,863 197,255 649-0630-473.38-02 INTEREST SRF BONDS Wastewater Debt Service 64,098 59,533 53,956 53,956 27,420 49,130 44,168 39,068 33,824 28,432 649-0630-473.38-03 PAYING AGENT FEES Wastewater Debt Service - - 3,000 3,000 - - - - - - 654-0630-793.50-02 INTERFUND TRANSFER OUT Wastewater Transfers Out - - - - - 25,000 25,000 25,000 25,000 25,000 655-0609-435.10-03 SEASONAL & INTERNS Streets & Sewers Salaries & Wages 22,056 40,948 43,680 43,680 1,522 53,760 53,760 53,760 53,760 53,760 655-0609-435.10-04 EXTRA AND OVERTIME Streets & Sewers Salaries & Wages 2,174 2,274 16,380 16,380 292 20,160 20,160 20,160 20,160 20,160 655-0609-435.10-16 ATTENDANCE BONUS Streets & Sewers Salaries & Wages 3,968 - 12,600 12,600 500 - - - - - 655-0609-435.11-01 FICA - REGULAR Streets & Sewers Fringe Benefits 2,157 3,307 5,559 5,559 139 5,655 5,655 5,655 5,655 5,655 655-0609-435.22-24 OTHER OPERATING SUPPLIES Streets & Sewers Supplies 3,092 1,184 - - - 5,000 5,000 5,000 5,000 5,000 655-0609-435.31-07 MGMT FEE TO WATER WORKS Streets & Sewers Other Interfund Allocations 13,740 13,734 15,876 15,876 6,615 16,150 16,651 17,167 17,699 18,248 95 2020 Proposed Budget - Line-Level Detail City of South Bend ACCOUNT DESCRIPTION DEPARTMENT CATEGORY NAME 2017 ACTUAL 2018 ACTUAL 2019 ORIGINAL BUDGET 2019 AMENDED BUDGET 6/30/2019 ACTUAL 2020 PROPOSED BUDGET 2021 FORECAST 2022 FORECAST 2023 FORECAST 2024 FORECAST 655-0609-435.31-70 ADM FEE ALLOCATION Streets & Sewers Other Interfund Allocations 18,252 17,647 24,367 24,367 10,150 26,235 28,189 28,753 29,328 29,915 655-0609-435.34-02 LIABILITY INSURANCE Streets & Sewers Other Interfund Allocations 408 - - - - - - - - - 655-0609-435.36-03 AUTO EQUIPMENT R&M Streets & Sewers Repairs & Maintenance 10,591 9,606 - - - - - - - - 655-0609-435.37-11 CAPITAL LEASE PRINCIPAL Streets & Sewers Debt Service 70,659 48,404 - - - - - - - - 655-0609-435.37-12 CAPITAL LEASE INTEREST Streets & Sewers Debt Service 1,560 576 - - - - - - - - 655-0609-435.50-02 INTERFUND TRANSFER OUT Streets & Sewers Transfers Out 350,000 550,000 550,000 550,000 137,500 300,000 300,000 300,000 300,000 300,000 655-0609-435.63-70 BAD DEBT EXPENSES Streets & Sewers Other Services & Charges 6,245 5,773 6,500 6,500 1,660 6,500 6,565 6,631 6,697 6,764 661-0621-415.42-05 SEWER REHABILITATION Wastewater Capital 1,206,728 628,214 - - - - - - - - 661-0621-415.50-02 INTERFUND TRANSFER OUT Wastewater Transfers Out - 17,136 - - - - - - - - 661-0630-415.42-06 WASTEWATER PLANT Wastewater Capital 1,056,681 - - - - - - - - - 667-0621-792.31-06 OTHER PROFESSIONAL SVCS Wastewater Professional Services - - 200,000 100,000 13,275 - - - - - 667-0621-792.42-04 SEWERS Wastewater Capital - - 1,000,000 500,000 23,527 825,000 1,000,000 1,035,000 1,035,000 1,040,000 96