Loading...
HomeMy WebLinkAboutSession III - Venues Parks & Arts (3) - Parks & Rec and Parking Garages2018 Budget Presentation Venues, Parks & Arts August 23, 2017 TABLE OF CONTENTS MORRIS PERFORMING ARTS CENTER ......................................................................... 2‐33 POWERPOINT PRESENTATION .................................................................................................. 2‐6 101‐0404 MORRIS PERFORMING ARTS CENTER ......................................................................... 7‐22 273 MORRIS & PALAIS MARKETING ........................................................................................... 23‐26 274 MORRIS & PALAIS SELF‐PROMOTION ................................................................................ 27‐29 416 MORRIS PERFORMING ARTS CENTER IMPROVEMENT ..................................................... 30‐33 PALAIS ROYALE BALLROOM ........................................................................................ 34‐46 101‐0405 PALAIS ROYALE BALLROOM .................................................................................... 34‐42 450 PALAIS HISTORIC PRESERVATION ....................................................................................... 43‐46 CENTURY CENTER ......................................................................................................... 47‐104 POWERPOINT PRESENTATION ............................................................................................. 47‐50 670 CENTURY CENTER OPERATING ........................................................................................... 51‐97 671 CENTURY CENTER CAPITAL ............................................................................................. 98‐101 672 CENTURY CENTER ENERGY CONSERVATION DEBT SERVICE ...................................... 102‐104 PARKS & RECREATION FUNDS ............................................................................... 105‐229 POWERPOINT PRESENTATION ........................................................................................ 105‐116 201 PARKS DEPARTMENT ....................................................................................................... 117‐181 203 RECREATION NONREVERTING ....................................................................................... 182‐198 271 EAST RACE WATERWAY .................................................................................................. 199‐201 401 COVELESKI STADIUM........................................................................................................ 202‐206 403 ZOO ENDOWMENT ............................................................................................................ 207‐209 405 PARK NONREVERTING CAPITAL .................................................................................... 210‐219 730 CITY CEMETERY ................................................................................................................ 220‐222 751 PARKS/EDIT BOND CAPITAL PROJECTS FUND ........................................................... 223‐226 757 PARKS/EDIT BOND DEBT SERVICE FUND .................................................................. 227‐229 601 PARKING GARAGE FUND .................................................................................. 230‐243 AAugust 23, 2017 Executive Director Facilities & Grounds Recreation Venue Ops Experience Deputy Director Admin & Finance DOWNTOWN 105 ¾Provide Experiences in Recreation, Arts, & Culture ¾Support and Enhance Economic & Neighborhood Development ¾Promote Health and Wellness ¾Increase Cultural Unity & Social Equality ¾Strengthen our Community Image and Quality of Place DEPARTMENTAL MISSION 2017 Accomplishments •More than $100,000 in efficiencies with consolidated contracts throughout VPA •Transitioned umbrella branding to South Bend Venues Parks & Arts •Major community planning effort: Riverfront Parks & Trails Conceptual Framework •Restoration of Historic Building in Howard Park: Experience Lodge •Development Director: increased sponsorship/donations by $100,000 •Consolidated marketing purchases creates increased exposure •$5 Million Regional Cities Grant Award •MADE Program (MLK) Recognized as “Most Innovative Program” by IPRA •A. Perri Published in National Parks & Recreation Association Magazine •Creation of Ecological Advocacy Committee (Drafted Natural Resources Mgmt Plan) •Inaugural BEST. WEEK. EVER. – 50,000 attendees •Cost Recovery: 19 ÆÆ 28% 106 •$100,000+ Savings Credited to VPA Service Contract Consolidations •Staffing Levels Remain Neutral •No Program/Event/Athletic Fee Increases •Mobile Experience Vehicle •Sustain all Recreation Center Programming & Staff Throughout Renovations •Expected Increase Sponsors and Donations •Increase Youth Scholarship Fund by $25,000 •New Streetscape Responsibilities for Smart Streets •Continued Deferred Maintenance Projects ~$250K (city cemetery, neighborhood parks) •Parking Garage Revenues Allow for Capital Investments •Break-even Budget with Decreased Burden on General Fund •MY South Bend Parks & Trails 2018 Budget Highlights 107 PLANNING & PRIORITIES Addresses All Major Capital Improvement Recommendations In 2014 Parks Master Plan Conforms with 2005 City Plan Riverfront Parks & Trails: 10 month Community Planning Process Consults with Local / National Standards and Benchmarks Tackles Shortcomings in Equity and Accessibility WHY PARKS & TRAILS? 108 WHY PARKS & TRAILS? MAJOR CAPITAL PROJECTS Completed Past 2 Years 109 Martin Luther King Jr. Center HV/AC & Park Upgrades Freemont Park Upgrades & Splash Pad Kennedy Park New Basketball Court & Playground Pinhook Pavilion New Roof & Boiler Rum Village Nature Center – New Roof Potawatomi Parking Lot Expansion South Bend Boat House Acquisition Leeper Park Projects Restoration of Howard Park Stone Lodge General Deferred Maintenance Playgrounds, Grills, Benches, Picnic Tables, Water Fountains, Trash Receptacles, etc. CAPITAL PROJECTS: Completed Within Past 2 Years Rum Village Aerial Adventure Park Elbel Park Clubhouse Upgrades Boehm Park Entrance South East Park Splash Pad Potawatomi Playgrounds Upgraded Niles Avenue Dog Park Leeper Tennis Courts Resurfacing CAPITAL PROJECTS: Completed Within Past 2 Years 110 MAJOR CAPITAL PROJECTS Currently In Progress Charles Black Center Expansion & Renovation Rum Village Dog Park Addition Kelly Park Upgrades MLK Center Exterior Enhancements City Cemetery Entrance & Headstone Repair Veterans Memorial Park Upgrades Walker Park Renovation Erskine Park Clubhouse Restoration & Modernization CAPITAL PROJECTS: Currently In Progress Greenhouse Roof Repair Leeper Park Irrigation & Lavender Labyrinth Fredrickson Park Neighborhood Access Trail Elbel Park Re-Prairie & Trail Installation Riverview Windows 111 CAPITAL PROJECTS: Currently In Progress MAJOR CAPITAL PROJECTS Planned & Proposed 112 Howard Park Howard Park Water & Ice Facility Howard Park Recreation Center Howard Park Play, Trail & Landscape St. Louis On-Street Parking/Upgrades Riverfront Trail Upgrades Colfax to Seitz Park West Bank (LaSalle to Jefferson) Viewing Park Trail (Howard to Farmer’s Market) East Bank Pedestrian Bridge Michigan Street Bridge Underpass Seitz Park to Howard Park Lincoln Way West (Sample to Twyckenham) ADA Compliance / Wayfinding / Multi-Use Amenities Throughout CAPITAL PROJECTS: Planned & Proposed Seitz Park Multi-Use Pavilion with Restrooms Performance Plaza Enhanced Accessibility New Entrance & Sitescaping Leeper Park Riverside Trail Studebaker Fountain Restroom Upgrades Tennis Facility Modernization Park Landscaping Playground Upgrades (Universal) Pinhook Park Pavilion Upgrades Playground Upgrades Water Quality & Water Recreation Neighborhood Connectivity Pulaski Visibility & Neighborhood Access Irrigated Soccer Fields New Restroom Facility & Playground Sitescaping & Amenities O’Brien Recreation Center & Outside Upgrades Reclaim Office & Hall Space for Recreation Use Locker Room Relocation & Upgrades Single Entrance / Modernize Facility Various Playground, Pavilion, & Equipment Upgrades throughout City CAPITAL PROJECTS: Planned & Proposed (cont’d) Charles Black Center & LaSalle Park (Additional Investments) Irrigated Soccer Fields Replace & Upgrade Pavilions ј Costs for Expansion & Renovation Park Restroom Modernization & ADA Compliance (x22) Park Security, Lighting, Storage Mobile Recreation Vehicle & Youth Transportation New Park Partnerships/Acquisitions & Build Outs 113 Trust for Public Land Park Access Map Trust for Public Land Park Access Map 114 MAJOR CAPITAL PROJECTS Completed Past 2 Years Currently In Progress Planned & Proposed www.MySBParksandTrails.com 115 FINANCING PLAN TIF Funds Parks Bond Private & Outside Funding $12.07 M Outside Funds $14.13 M TIF Commitment * $13.78 M New Parks Bond $39.9 Million Investment *$16.38M Total: $5.8 Cash plus $10.6M River West Bond. FINANCING PLAN TIF Funds Parks Bond Private & Outside Funding $12.07 M Outside Funds $14.13 M TIF Commitment $13.78 M New Parks Bond $39.9 Million Investment Committed $18.86 M Pending TIF Bond $10.60 M Pending Park Bond $13.78 M Prior Park Bond $5.0 M Operational Capital $1.5 M TOTAL 5 Year Plan $47.49 M 116 City of South Bend, Indiana 2018 Budget Fund 201 - Parks & Recreation Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Property Taxes 7,487,554 7,902,995 8,900,000 4,976,456 8,943,000 9,044,000 8,602,000 8,774,000 8,900,000 43,000 0% Other Taxes 666,224 667,306 670,000 379,124 670,000 670,000 670,000 670,000 670,000 - 0% Grants/Intergovernmental - - 5,095,000 - 2,050,000 2,050,000 50,000 50,000 50,000 (3,045,000) -60% Charges for Services 1,764,469 1,685,696 2,954,847 737,988 2,903,820 2,731,386 2,732,531 2,733,684 2,734,856 (51,027) -2% Interest Earnings 8,547 23,779 10,000 11,598 24,996 25,000 25,000 25,000 25,000 14,996 150% Donations - 1,650 - - 20,000 20,000 20,000 20,000 20,000 20,000 - Other Income 1,105,170 1,068,853 1,844,938 840,145 301,100 301,100 301,100 301,100 301,100 (1,543,838) -84% Transfers In - - 625,347 200,000 1,287,600 1,485,406 2,063,648 1,953,379 1,699,014 662,253 106% Total Revenue 11,031,964 11,350,279 20,100,132 7,145,311 16,200,516 16,326,892 14,464,279 14,527,163 14,399,969 (3,899,616) -19% Expenditures by Type Personnel Salaries & Wages 5,058,898 5,096,221 5,877,548 2,604,919 5,792,921 5,862,694 5,952,226 6,040,345 6,125,983 (84,627) -1% Fringe Benefits 1,816,886 2,020,122 2,487,733 1,125,776 2,559,204 2,743,053 2,797,140 2,812,110 2,827,005 71,471 3% Total Personnel 6,875,784 7,116,343 8,365,281 3,730,695 8,352,125 8,605,748 8,749,366 8,852,455 8,952,987 (13,156) 0% Supplies 982,761 893,773 1,343,520 449,646 1,224,056 1,224,056 1,224,056 1,224,056 1,224,056 (119,464) -9% Services & Charges Professional Services 782,692 735,360 1,637,633 633,909 1,073,178 1,102,524 702,524 702,524 702,524 (564,455) -34% Printing & Advertising 19,229 30,619 124,629 21,626 117,767 117,767 117,767 117,767 117,767 (6,862) -6% Utilities 543,728 541,015 562,741 287,943 652,017 652,017 652,017 652,017 652,017 89,276 16% Education & Training 5,449 4,381 11,325 5,312 8,600 8,600 8,600 8,600 8,600 (2,725) -24% Travel 27,649 24,504 24,662 5,961 8,300 8,300 8,300 8,300 8,300 (16,362) -66% Repairs & Maintenance 249,321 275,027 786,710 435,273 1,135,155 915,155 915,155 915,155 915,155 348,445 44% Other Interfund Allocations 363,599 419,598 1,135,665 544,926 941,238 941,238 941,238 941,238 941,238 (194,427) -17% Debt Service Principal 292,172 189,341 256,925 131,827 317,042 374,756 378,318 347,870 128,825 60,117 23% Interest & Fees 7,686 5,725 22,766 10,372 29,257 34,950 25,157 15,400 6,719 6,491 29% Grants & Subsidies - - 15,000 15,000 31,060 31,060 31,060 31,060 31,060 16,060 107% Insurance - 101,270 119,335 64,141 136,460 136,460 136,460 136,460 136,460 17,125 14% Transfers Out - - 102,850 - 104,850 104,850 104,850 104,850 104,850 2,000 2% Other Services & Charges 463,069 414,711 416,275 170,293 469,411 469,411 469,411 469,411 469,411 53,136 13% Total Services & Charges 2,754,594 2,741,551 5,216,516 2,326,583 5,024,335 4,897,088 4,490,857 4,450,652 4,222,926 (192,181) -4% Capital - 22,760 4,000,000 - 1,600,000 1,600,000 - - - (2,400,000) -60% Total Expenditures 10,613,139 10,774,427 18,925,317 6,506,923 16,200,516 16,326,892 14,464,279 14,527,163 14,399,969 (2,724,801) -14% Net Surplus / (Deficit)418,825 575,852 1,174,815 638,387 - - - - - Beginning Cash Balance 3,494,861 3,913,925 4,490,441 5,665,256 5,665,256 5,665,256 5,665,256 5,665,256 Cash Reserve Cash Adjustments 239 663 - - - - - - Ending Cash Balance 3,913,925 4,490,441 5,665,256 5,665,256 5,665,256 5,665,256 5,665,256 5,665,256 Cash Reserves Target 2,653,285 2,694,720 4,731,329 4,050,129 4,081,723 3,616,070 3,631,791 3,599,992 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 25% of Annual expenditures This fund accounts for the operation of the Venues Parks & Arts (VPA) that are predominantly taxpayer funded. The purpose is to provide quality spaces, places and experiences within the City of South Bend. There are six divisions within the department: Administration, Maintenance, Golf, Recreation, Graffiti, and Experience. Potawatomi Zoo will cease having personnel costs as the last remaining employee will become a Zoo employe in June 2018. In 2017 VPA was awarded a Regional Cities grant of $5 million that is funded via the Northern Indiana Regional Development Authority. On the revenue lines "Other Income and Transfers In" there were some internal accounting changes and less reliance on additional transfers in due to cost savings. 117 City of South Bend, Indiana 2018 Budget Fund 201 - Parks & Recreation Accomplishments, Goals, KPI's 2017 Accomplishments & Outcomes -More than $100,000 in effeciencies with consolidated contracts throughout Venues Parks & Arts Department - - - - - - - - - 2018 Department Goals & Objectives and Linkage to City Results - - - - - - - - - - - - - - - - Key Performance Indicators (KPI's) Measure Type Long Term Goal 2016 Actual 2017 Estimated 2018 Target -Output 800,000 725,000 745,000 775,000 -Output $1.5 M $934K $1.25M $1.39 M -Outcome 20K/$500K 15K/$327K 18K/$420K 20K/$500K -Quality 5 4.8 4.8 4.8 -Outcome 40% 19% 28% 34% - - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - Consolidated marketing purchases have realized discounts and greater clout with advertisers and partners. Implementation of new software has improved registrations and ticket sales at some venues $5 Million Regional Cities Grant Award. $1 Million Notre Dame Hydro Project Partnership at Seitz Park. Facilities & Grounds to upgrade all restroom facilities with a goal of ADA compliance and better service Installation of a Rum Village dog park Improve the flow of traffic and beautify entrance at City Cemetery, restore headstones Continue repairs and upgrades of neighborhood parks. Efficiences with Venues Parks & Arts consolidation continue to return savings Recreation Everywhere - the addition of the Mobile Recreation Vehicle can make a pop-up park or special event occur anywhere The Riverfront Parks and Trails project will lay the foundation for major renovations along the St. Joseph river. The negotiation of Energy Savings contracts for various locations will help defray operating expenditures Transitioned branding to South Bend Venues, Parks and Arts Established "My SB Parks and Trails" plan to accomplish identified needs throughout the entire park system. The Experience Lodge will be inhabited by fall; began with an unused building and restored it back to useful space at Howard Park By the end of 2017, the main building at Howard Park will have been demolished in order to make way for the new structures The addition of a Development Director has increased sponsorship and donations by more than $100,000 so far this year Final phase of VPA Realignment - Venue Operations Customer Service Scores Cost Recovery Implment My SB Parks & Trails Improvements throughout entire city Program Attendance Fee Based Revenue Volunteer Hours / Value 118 City of South Bend, Indiana 2018 Budget Fund 201 - Parks & Recreation Staffing (Full-Time Employees only) 2017 2018 2016 Amended 06/30/17 Proposed Forecast Position (* New title or additional position)Actual Budget Actual Budget 2019 2020 2021 2022 Non-Bargaining ADMINISTRATION (1100) Executive Director - VPA 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Financial Services 1.0 - - - - - - - Financial Specialist IV - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Financial Specialist III 1.0 - - - - - - - Financial Specialist II 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Administrative Assistant I 1.0 1.0 - - - - - - Departmental System Specialist 1.0 - - - - - - - NEW - Executive Assistant - - 1.0 1.0 1.0 1.0 1.0 1.0 Office Manager 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 MAINTENANCE (1101) Administrative Assistant I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Park Police II 2.0 - - - - - - - Custodian (MPAC)- 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Superintendent IV 2.0 2.0 - - - - - - Foreman IV 1.0 1.0 2.0 2.0 2.0 2.0 2.0 2.0 Foreman V 2.0 2.0 1.0 1.0 1.0 1.0 1.0 1.0 Horticulturalist Tech - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 HVAC Technician - 1.0 - - - - - - Manager - Asst Facility Ops (MPAC)- 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Facilities 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Facility Ops (MPAC)- 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Operations - 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Operations - Forester 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Park Grounds 1.0 1.0 2.0 2.0 2.0 2.0 2.0 2.0 Superintendent - Park Maintenance 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Superintendent III 1.0 - 1.0 1.0 1.0 1.0 1.0 1.0 GOLF DIVISION (1102) Club Pro Municipal Golf Course 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Director Of Golf Operations 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Assistant Facility Operations - - - 1.0 1.0 1.0 1.0 1.0 Manager - Concessions - 1.0 - - - - - - Foreman V - - 1.0 - - - - - Golf Course/Rink Manager 1.0 - - - - - - - Superintendent V 1.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 RECREATION (1103) Assistant Director Of Recreation 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Deputy Director of Parks 1.0 1.0 - - - - - - Director Of Recreation - - 1.0 1.0 1.0 1.0 1.0 1.0 Fitness Supervisor 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Naturalist 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Program Coordinator 8.0 8.0 7.0 7.0 7.0 7.0 7.0 7.0 Supervisor - Administrative Asst 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Supervisor - Asst Program 2.0 1.0 2.0 2.0 2.0 2.0 2.0 2.0 Supervisor - Athletic 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Supervisor - Center 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Supervisor - Program 2.0 1.0 2.0 2.0 2.0 2.0 2.0 2.0 Supervisor - Youth 1.0 1.0 - - - - - - Supervisor - Rum Village Park 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 119 City of South Bend, Indiana 2018 Budget Fund 201 - Parks & Recreation Staffing (Full-Time Employees only) 2017 2018 2016 Amended 06/30/17 Proposed Forecast Position (* New title or additional position)Actual Budget Actual Budget 2019 2020 2021 2022 GRAFFITI REMOVAL (1108) Foreman V 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 MARKETING & EVENTS (1110) Director Of Development - VPA - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director Of Marketing & Promotions 1.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Graphic Designer - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Events - 1.0 - - - - - - Manager - Interactive Marketing - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 NEW - Communications Coordinator - - - 1.0 1.0 1.0 1.0 1.0 NEW - Volunteer Coordinator - - - 1.0 1.0 1.0 1.0 1.0 Program Coordinator - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Project Manager 1.0 1.0 2.0 2.0 2.0 2.0 2.0 2.0 Supervisor - Program - 1.0 - - - - - - Supervisor - Administrative Asst - 1.0 1.0 - - - - - Supervisor - Special Events - - 1.0 1.0 1.0 1.0 1.0 1.0 Total Non-Bargaining 52.0 59.0 59.0 60.0 60.0 60.0 60.0 60.0 Bargaining Arborist I 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Arborist II 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Arborist-Weed Control 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Athletic Field Maintenance 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Bldg Maint Custod & Labor 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Building & Structure Maint I 2.0 1.0 2.0 1.0 1.0 1.0 1.0 1.0 Building & Structure Maint II 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Constr Maint Carpenter II 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Constr Maint Carpenter III 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Constr Maint Mason 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Electrician 1.0 1.0 - - - - - - Equipment Operator II 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Group Leader 6.0 6.0 5.0 6.0 6.0 6.0 6.0 6.0 Head Custodian 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 Heavy Equipment Operator I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Job Leader 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Job Leader - Mower Shop 1.0 - 1.0 1.0 1.0 1.0 1.0 1.0 Mechanic IV 3.0 2.0 3.0 1.0 1.0 1.0 1.0 1.0 Operator I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Painter IV 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Plumber IV-Park 2.0 2.0 1.0 2.0 2.0 2.0 2.0 2.0 Park Rangers - 2.0 - - - - - - Total Bargaining 38.0 37.0 35.0 34.0 34.0 34.0 34.0 34.0 Total Full-Time Employees 90.0 96.0 94.0 94.0 94.0 94.0 94.0 94.0 Explain Significant Staffing Changes Below: Staffing changes, 2017 Budget vs. 2018 Budget: Two (2) Park Ranger positions have been eliminated and the Electrician will be filled as a contract worker instead of a City employee. 120 City of South Bend, Indiana2018 BudgetFund 201 - Parks & RecreationFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalRegional Cities Grant projectsCash1,600,000 1,600,000 - - - 3,200,000 Funded by Regional Cities reimbursement grantTotal Project Capital1,600,000 1,600,000 - - - 3,200,000 Minimum Thresholds:Total Capital1,600,000 1,600,000 - - - 3,200,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:121 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenuePARK DEPARTMENT FUND201-0000-311.00-00 GENERAL PROPERTY TAX 7,487,554 7,902,995 7,878,000 8,900,000 4,976,456 4,976,456 8,943,000LEVEL TEXTTEXT AMT02 2018 PROPERTY TAX ESTIMATE PER UMBAUGH REPORT8,943,0008,943,000------------ ------------ ------------ ------------ ------------ ------------ ------------*7,487,554 7,902,995 7,878,000 8,900,000 4,976,456 4,976,456 8,943,000201-0000-312.02-00 AUTO EXCISE514,154 531,810 520,000 520,000 306,048 306,048 520,000LEVEL TEXTTEXT AMT02 ETIMATE BASED ON TRENDS520,000520,000201-0000-312.03-00 COMMERCIAL VEHICLE TAX152,070 135,496 150,000 150,000 73,075 73,075 150,000LEVEL TEXTTEXT AMT02 ESTIMATE BASED ON TRENDS150,000150,000------------ ------------ ------------ ------------ ------------ ------------ ------------*666,224 667,306 670,000 670,000 379,123 379,124 670,000201-0000-338.00-00 PILOT TRANSFERS IN884,835 926,268 1,415,007 1,415,007 707,504 707,5040LEVEL TEXTTEXT AMT02 TRANSFER FROM COIT FUND TO REPLACE PILOTMOVED TO 201-0000-392-00-00------------ ------------ ------------ ------------ ------------ ------------ ------------*884,835 926,268 1,415,007 1,415,007 707,504 707,5040201-0000-360.00-00 MISCELLANEOUS REVENUE10,236 4,14100000201-0000-360.51-00 INSURANCE REIMBURSEMENT7,676 6,7730 4,000 4,698 4,1490------------ ------------ ------------ ------------ ------------ ------------ ------------*17,912 10,9140 4,000 4,698 4,1490201-0000-361.00-00 INTEREST EARNINGS8,547 23,779 10,000 10,000 14,456 11,598 24,996LEVEL TEXTTEXT AMT02 INTEREST ON INVESTMENTS ON FUND BALANCES24,99624,996------------ ------------ ------------ ------------ ------------ ------------ ------------*8,547 23,779 10,000 10,000 14,456 11,598 24,996201-0000-380.10-99 MISC. REIMBURSEMENTS30,14449800000Fund 201 - Parks & RecreationCity of South BendRevenue122 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue------------ ------------ ------------ ------------ ------------ ------------ ------------*30,14449800000201-0000-391.01-00 SALE OF FIXED ASSETS1,10482800000------------ ------------ ------------ ------------ ------------ ------------ ------------*1,10482800000201-0000-392.00-00 INTERFUND OPER. TRANSFER000000 1,287,600LEVEL TEXTTEXT AMT02 TRANSFER IN FROM COIT FUND1,800,000404-1100-452-50-02REDUCE TRANSFER IN BY $512,400 TO BALANCE512,400-PARKS BUDGET1,287,600------------ ------------ ------------ ------------ ------------ ------------ ------------*000000 1,287,600------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK DEPARTMENT FUND9,096,320 9,532,588 9,973,007 10,999,007 6,082,237 6,078,830 10,925,596Fund 201 - Parks & RecreationCity of South BendRevenue123 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1100-354.00-00 ORDINANCE VIOLATION25-000000LEVEL TEXTTEXT AMT02 ORDINANCE VIOLATIONS CITED BY PARK RANGERS500500------------ ------------ ------------ ------------ ------------ ------------ ------------*25-000000201-1100-360.00-00 MISCELLANEOUS REVENUE23498100100489349100LEVEL TEXTTEXT AMT02 2018 ESTIMATE100CE 15 MAY 2017100------------ ------------ ------------ ------------ ------------ ------------ ------------*23498100100489349100201-1100-362.03-01 PICNIC RENTALS3,245 3,474 3,500 3,500 2,976 2,244 3,300LEVEL TEXTTEXT AMT02 PICNIC SITE RENTAL, ANY SITE, 365 X $9, ROUNDED3,300CE 15 MAY 20173,300201-1100-362.03-02 PAVILION RENTAL10,275 11,242 15,000 15,000 15,779 14,659 25,000LEVEL TEXTTEXT AMT02 RENTAL OF PINHOOK PARK PAVILION25,000CE 15 MAY 201725,000201-1100-362.03-03 PICNIC SHELTER20,663 17,576 25,000 25,000 16,130 13,560 14,000LEVEL TEXTTEXT AMT02 PICNIC PAVILION RENTALS IN POTAWATOMI, RUM VILLAGE14,000SOUTHEAST AND O'BRIEN PARKS, $50 X 275, ROUNDEDCE 15 MAY 201714,000------------ ------------ ------------ ------------ ------------ ------------ ------------*34,183 32,292 43,500 43,500 34,885 30,463 42,300------------ ------------ ------------ ------------ ------------ ------------ ------------** ADMINISTRATION34,392 32,390 43,600 43,600 35,374 30,812 42,400Fund 201 - Parks & RecreationCity of South BendRevenue124 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1101-347.01-40 LEASE OF STADIUM75,000 75,500 75,000 75,000 45,000 30,000 75,000LEVEL TEXTTEXT AMT02 LEASE OF COVELESKI STADIUM PER AGREEMENT75,000PAYABLE IN 5 EQUAL INSTALMENTS, MAY 1 - SEP 1ORIGINAL LEASE SIGNED IN 2011FIRST RENEWAL FOR ADD'L 5 YEARS - 2017FIRST RENEWAL EXPIRES 31 DEC 2021CE 15 MAY 201775,000201-1101-347.01-71 SITE MOWING158,494 139,069 164,000 164,000 25,574 25,574 150,000LEVEL TEXTTEXT AMT02 COMM INVESTMNT LOT MAINTENANCE25,000CODE ENFORCEMENT SITE MOWING125,0002018 BUDGET150,000201-1101-347.01-72 SNOW REMOVAL0 18,6000000 18,600LEVEL TEXTTEXT AMT02 REDEVELOPMENT SNOW REMOVAL18,60018,600201-1101-347.01-73 TREE MAINTENANCE0 7,478 130,000 130,000 2,190 2,190 130,000LEVEL TEXTTEXT AMT02 PER TREE MAINTENANCE AGREEMENT WITH DCI130,0002018 AMOUNT: $130,000 BASE + $81.76 PER TREE OVER1,500 TREES (NONE EXPECTED)CE 15 MAY 2017TO BE INVOICED QUARTERLY130,000201-1101-347.01-77 MPAC SMA/MARKETING00 397,763 397,76300 372,372LEVEL TEXTTEXT AMT02 SERVICE MAINTENANCE AGREEMENT (SMA) WITH MPACFOR TRANSFER OF MPAC MAINTENANCE BUDGET INTOVPA (FORMERLY PARKS)MPAC230,136PALAIS142,236372,372201-1101-347.01-79 DCI SMA000000 220,650LEVEL TEXTTEXT AMTFund 201 - Parks & RecreationCity of South BendRevenue125 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue02 CITY-OWNED PROPERTY MAINTENANCE220,650220,650------------ ------------ ------------ ------------ ------------ ------------ ------------*233,494 240,647 766,763 766,763 72,764 57,764 966,622201-1101-360.00-00 MISCELLANEOUS REVENUE68,941 65,078 48,600 48,600 25,778 23,861 30,000LEVEL TEXTTEXT AMT02 FORESTRY FEES FOR TREE REMOVALS20,000MISCELLANEOUS10,00030,000------------ ------------ ------------ ------------ ------------ ------------ ------------*68,941 65,078 48,600 48,600 25,778 23,861 30,000201-1101-367.00-00 DONATION PRIVATE SOURCES0 1,65000000------------ ------------ ------------ ------------ ------------ ------------ ------------*01,65000000201-1101-380.10-99 MISC. REIMBURSEMENTS0 1,2820 267,000 103,775 62,193 266,000LEVEL TEXTTEXT AMT02 MISC REVENUES, 20181,000REIMB FOR CLEAN & SAFE PROGRAM, DOWNTOWN, FROM265,000DTSB266,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 1,2820 267,000 103,775 62,193 266,000201-1101-392.00-00 INTERFUND OPER. TRANSFER00 400,000 625,347 200,000 200,0000LEVEL TEXTTEXT AMT02 TRANSFER FROM EDIT TO DEFRAY DTSB400,000NOW PART OF PILOT TRANSFER, 2018400,000------------- ------------ ------------ ------------ ------------ ------------ ------------*00 400,000 625,347 200,000 200,0000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE302,435 308,657 1,215,363 1,707,710 402,317 343,818 1,262,622Fund 201 - Parks & RecreationCity of South BendRevenue126 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1102-347.01-19 SEASON PASS SALES160,697 151,979 143,389 143,389 152,959 152,584 200,000LEVEL TEXTTEXT AMT02 SEASON PASS SALESELBEL98,500ERSKINE98,500STUDE3,0002018 BUDGET200,000201-1102-347.01-20 GOLF COURSE GREEN FEES428,136 426,392 595,372 595,372 308,991 212,841 558,000LEVEL TEXTTEXT AMT02 DAILY GRREEN FEESELBEL240,000ERSKINE235,500STUDE82,5002018 BUDGET558,000201-1102-347.01-22 GOLF CART RENTALS417,256 399,178 413,239 413,239 178,972 121,226 400,000LEVEL TEXTTEXT AMT02 CART RENTALSELBEL184,000ERSKINE192,000STUDE24,0002018 BUDGET400,000201-1102-347.01-23 PRO SHOP RETAIL SALES133,028 87,193 134,127 134,127 41,324 31,198 100,000LEVEL TEXTTEXT AMT02 PRO SHOP/MERCHANDISE SALESELBEL47,000ERSKINE42,000STUDE11,0002018 BUDGET100,000201-1102-347.01-25 DRIVING RANGE15,247 18,451 15,436 15,436 11,436 8,489 25,000LEVEL TEXTTEXT AMT02 DRIVING RANGE FEESELBEL25,0002018 BUDGET25,000Fund 201 - Parks & RecreationCity of South BendRevenue127 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1102-347.01-26 GIFT CERTIFICATES3,194 3,5920 6,000 2,125 2,901 4,000LEVEL TEXTTEXT AMT02 ELBEL1,920ERSKINE1,920STUDEBAKER1602018 BUDGET, BASED ON WHERE USED4,000201-1102-347.01-30 CONCESSION00 204,8650000LEVEL TEXTTEXT AMT02 CONCESSION REVENUES MOVED TO SPECIFIC TYPES201-1102-347.01-34 SPECIAL EVENTS\MISC.050000000LEVEL TEXTTEXT AMT02 RENTAL OF CLUBHOUSES FOR PRIVATE PARTIES $10,000REMOVED 2017 BUDGET DOLLARS TO COMPLY WITH KEEGANRECOMMENDATIONS201-1102-347.01-35 FOOD SALES64,032 59,9840 62,846 27,727 18,855 62,450LEVEL TEXTTEXT AMT02 CONCESSIONS REVENUESELBEL37,000ERSKINE24,200STUDEBAKER1,2502018 BUDGET62,450201-1102-347.01-37 NON-ALCOHOLIC BEVERAGES 40,969 38,9300 43,833 17,411 11,541 44,200LEVEL TEXTTEXT AMT02 CONCESSION REVENUESELBEL20,500ERSKINE18,700STUDEBAKER5,0002018 BUDGET44,200201-1102-347.01-38 ALCOHOLIC BEVERAGE SALES 95,316 94,6910 98,186 47,989 31,809 98,250LEVEL TEXTTEXT AMT02 CONCESSIONS REVENUEELBEL60,000ERSKINE38,250NO ALCOHOL SOLD AT STUDEBAKER2018 BUDGET98,250Fund 201 - Parks & RecreationCity of South BendRevenue128 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1102-347.01-39 GOLF OUTINGS2,846 2,85700730730 4,506LEVEL TEXTTEXT AMT02 CONCESSIONS SOLD FOR OUTINGSELBEL3,000ERSKINE1,5062018 BUDGET4,506201-1102-347.99-00 CASH OVER/SHORT145868-0076-20------------ ------------ ------------ ------------ ------------ ------------ ------------*1,360,866 1,282,879 1,506,428 1,512,428 789,588 592,176 1,496,406201-1102-360.00-00 MISCELLANEOUS REVENUE9,056 1,736 13,506 13,506 4,410 4,282 5,000LEVEL TEXTTEXT AMT02 MISC REVELBEL2,000ERSKINE3,0002018 BUDGET5,000------------ ------------ ------------ ------------ ------------ ------------ ------------*9,056 1,736 13,506 13,506 4,410 4,282 5,000201-1102-380.10-99 MISC. REIMBURSEMENTS030700000------------ ------------ ------------ ------------ ------------ ------------ ------------*030700000------------ ------------ ------------ ------------ ------------ ------------ ------------** GOLF COURSES1,369,922 1,284,922 1,519,934 1,525,934 793,998 596,459 1,501,406Fund 201 - Parks & RecreationCity of South BendRevenue129 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1103-347.01-10 SWIMMING POOL35,833 47,434 49,000 49,000 34,335 12,435 42,000LEVEL TEXTTEXT AMT02 POTAWATOMI POOL22,000KENNEDY WATER PLAYGROUND20,00042,000201-1103-347.01-35 FOOD SALES2,343915 2,000 2,000000201-1103-347.01-37 NON-ALCOHOLIC BEVERAGES3,634 1,754 3,500 3,500000201-1103-347.01-50 EAST RACEWAY43,005 45,675 54,125 54,125 28,339 11,785 44,000LEVEL TEXTTEXT AMT02 RAFT RIDES44,00044,000201-1103-347.01-60 ICE SKATING34,801 18,047 36,000 36,000000LEVEL TEXTTEXT AMT02 NO ACTIVITY FOR 2018201-1103-347.01-62 SKATE RENTAL\SHARP\LCKRS8,005 4,107 5,000 5,000000LEVEL TEXTTEXT AMT02 NO ACTIVITY FOR 2018201-1103-347.01-90 SPECIAL EVENTS REVENUE7,969 11,765 7,060 7,060 6,790 5,343 21,060LEVEL TEXTTEXT AMT02 LEARN TO SWIM5,000DISCOUNTED REVENUE16,060SWIM PROGRAM OFFERS DISCOUNTED FEES FOR CERTAINQUALIFIED PARTICIPANTS. DISCOUNT IS OFFSET BYGRANT/SUBSIDY EXPENDITURE.21,060201-1103-347.99-00 CASH OVER/SHORT3361810043570------------ ------------ ------------ ------------ ------------ ------------ ------------*135,926 129,878 156,685 156,685 69,507 29,620 107,060201-1103-360.00-00 MISCELLANEOUS REVENUE855000 1,30100------------ ------------ ------------ ------------ ------------ ------------ ------------*855000 1,30100------------ ------------ ------------ ------------ ------------ ------------ ------------** RECREATION136,781 129,878 156,685 156,685 70,808 29,620 107,060Fund 201 - Parks & RecreationCity of South BendRevenue130 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1104-360.00-00 MISCELLANEOUS REVENUE0100000LEVEL TEXTTEXT AMT02 FACILITY RENTALS, MISC REVENUESZOO OPERATED BY POTAWATOMI ZOOLOGICAL SOCIETY------------ ------------ ------------ ------------ ------------ ------------ ------------*0100000------------ ------------ ------------ ------------ ------------ ------------ ------------** POTAWATOMI ZOO0100000Fund 201 - Parks & RecreationCity of South BendRevenue131 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1108-347.01-85 GRAFFITI REMOVAL0000 27,965 27,965 106,459LEVEL TEXTTEXT AMT02 GRAFFITI REMOVAL AS BILLED TO COSB106,459NEW ACCT FOR 2018; PREV 201-1108-380.10-99REVENUES BASED ON BUDGETED EXPENDITURES106,459------------ ------------ ------------ ------------ ------------ ------------ ------------*0000 27,965 27,965 106,459201-1108-380.10-99 MISC. REIMBURSEMENTS92,089 61,843 96,725 96,725 66,789 37,5760------------ ------------ ------------ ------------ ------------ ------------ ------------*92,089 61,843 96,725 96,725 66,789 37,5760------------ ------------ ------------ ------------ ------------ ------------ ------------** GRAFFITI REMOVAL92,089 61,843 96,725 96,725 94,754 65,540 106,459Fund 201 - Parks & RecreationCity of South BendRevenue132 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1110-331.01-80 GRANTS00 95,000 95,00000 50,000LEVEL TEXTTEXT AMT02 GRANTS TO BE PURSUED AND REVEICED BY THE NEW50,000DEVELOPMENT DIRECTOR50,000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 95,000 95,00000 50,000201-1110-347.01-77 MPAC SMA/MARKETING00 254,821 254,82100 184,973LEVEL TEXTTEXT AMT02 MPAC MARKETING106,768PALAIS MARKETING78,205184,973201-1110-347.01-79 DCI SMA00 220,650 220,650000LEVEL TEXTTEXT AMT02 PER AP AND BP - DCI SMAPER AP - WAS BUDGETED FOR CLEAN & SAFE REIMB, BUTACTUALLY REIMBURSED TO MAINT (1101)REMOVED FOR 2018------------ ------------ ------------ ------------ ------------ ------------ ------------*00 475,471 475,47100 184,973201-1110-367.00-00 DONATION PRIVATE SOURCES0000 1,5000 20,000LEVEL TEXTTEXT AMT02 DONATIONS TO DEFRAY COST OF EVENTS20,00020,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0000 1,5000 20,000201-1110-380.10-99 MISC. REIMBURSEMENTS00004482310------------ ------------ ------------ ------------ ------------ ------------ ------------*00004482310------------ ------------ ------------ ------------ ------------ ------------ ------------** MARKETING & EVENTS00 570,471 570,471 1,948231 254,973Fund 201 - Parks & RecreationCity of South BendRevenue133 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue201-1111-337.01-01 REGIONAL CITIES GRANT000 5,000,00000 2,000,000LEVEL TEXTTEXT AMT02 REGIONAL CITIES GRANT - REIMBURSEMENT TYPE2,000,0002,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 5,000,00000 2,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------** REGIONAL CITIES GRANT000 5,000,00000 2,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARK DEPARTMENT FUND11,031,939 11,350,279 13,575,785 20,100,132 7,481,436 7,145,311 16,200,516Fund 201 - Parks & RecreationCity of South BendRevenue134 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresPARK DEPARTMENT FUND201-1100-452.10-01 REGULAR WAGES405,520 428,658 316,057 312,857 177,556 153,881 321,302LEVEL TEXTTEXT AMT02 1 EXECUTIVE DIRECTOR - VPA (TITLE CHANGE)117,3001 DIRECTOR-FINANCIAL SERVICES (PAID FROM 101-0401)1 FINANCIAL SPECIALIST IV (UPGRADE BP FROM FS III)48,3112 FINANCIAL SPECIALIST II (39,002 EA)78,0031 EXECUTIVE ASSISTANT48,8501 OFFICE MANAGER37,274ADJUST TO ACTUAL8,436-321,302201-1100-452.10-02 HOURLY WAGES70,722 69,48700000LEVEL TEXTTEXT AMT02 2 PARK POLICE II @ $34,898 - MOVED TO MAINT201-1100-452.10-03 SEASONAL & INTERNS70,057 38,989 5,870 5,870 3,530 2,3030LEVEL TEXTTEXT AMT02 SEASONAL SUMMER INTERN - OFFICE HELP5,8705,870201-1100-452.10-04 EXTRA AND OVERTIME13,148 2,61200000LEVEL TEXTTEXT AMT02 OVERTIME FOR PARK RANGERS - MOVED TO MAINT201-1100-452.10-09 PERMANENT PART-TIME5,131 35,880 31,512 31,512 4,295 4,295 15,756LEVEL TEXTTEXT AMT02 PART TIME OFFICE STAFFOFFICE STAFF-15,75615,756201-1100-452.10-11 PARK BOARD STIPEND900900 2,000 2,00000 1,200LEVEL TEXTTEXT AMT02 PARKBOARDSTIPEND-4X$300.00PERYEAR1,200PAID IN DECEMBER1,200201-1100-452.11-01 FICA - REGULAR41,785 43,442 24,827 24,827 13,878 12,016 25,877LEVEL TEXTTEXT AMT02 SALARIES * 7.65%25,87725,877201-1100-452.11-04 PERF - REGULAR54,805 52,298 32,595 32,595 19,886 17,235 35,986Fund 201 - Parks & RecreationCity of South BendExpenditures135 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 REG SALARIES * 11.2%35,98635,986201-1100-452.11-07 UNEMPLOYMENT COMP1,395772826826000LEVEL TEXTTEXT AMT02 ESTIMATED UNEMPLOYMENT COMPENSATION FORADMINISTRATION DIVISION BASED ON 0.25% OF PAYROLL826826201-1100-452.11-08 HEALTH INSURANCE106,886 128,764 93,876 93,876 54,761 46,938 97,776LEVEL TEXTTEXT AMT02 6 FT EMPLOYEESGROUP HEALTH (6 * 16,200)97,200LTD (6 * 96)57697,776201-1100-452.11-09 LIFE INSURANCE1,195 1,182720720420360720LEVEL TEXTTEXT AMT02 6 EMP X $5 X 24 PAY PERIODS720720201-1100-452.11-12 AUTO ALLOWANCE0 3,2000 3,200 1,867 1,6000201-1100-452.11-24 CELL PHONE ALLOWANCE1,320 1,485 1,320 1,320770660 1,320LEVEL TEXTTEXT AMT02 2 EMPLOYEES @ $660/YR1,3201,320201-1100-452.11-29 PARENTAL LEAVE000000846LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%846846------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES772,864 807,669 509,603 509,603 276,963 239,287 500,783201-1100-452.21-02 STATIONERY & PRINTING2,382159 1,000 1,000663638 1,000LEVEL TEXTTEXT AMT02 MATERIALS AND SUPPLIES1,0001,000Fund 201 - Parks & RecreationCity of South BendExpenditures136 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1100-452.21-03 CENTRAL STORES - OFFICE2,247 2,508 3,762 3,762 1,292 1,264 3,762201-1100-452.21-04 OTHER OFFICE SUPPLIES8,567 8,146 9,000 8,996 2,515 2,143 9,000201-1100-452.21-05 SMALL OFFICE EQUIPMENT600960 1,000 1,010 1,009 1,009 1,000201-1100-452.22-05 UNIFORMS1,36650200000LEVEL TEXTTEXT AMT02 UNIFORMS FOR PARK RANGERS- FULL AND PART TIMEMOVED TO MAINT201-1100-452.22-24 OTHER OPERATING SUPPLIES 12,077 7,367 4,750 5,731 2,222 2,070 4,750LEVEL TEXTTEXT AMT02 MISC COMPUTER, OTHER SUPPLIES4,7504,750201-1100-452.23-01 BUILDING MATERIALS5,670000000201-1100-452.23-20 SMALL TOOLS & EQUIPMENT5,961000000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES38,870 19,642 19,512 20,499 7,701 7,124 19,512201-1100-452.31-01 LEGAL SERVICES25,8622500000201-1100-452.31-06 OTHER PROFESSIONAL SVCS3,155000000201-1100-452.31-70 ADM FEE ALLOCATION44,616 31,068 36,485 36,485 21,280 18,240 45,609LEVEL TEXTTEXT AMT02 2017 FIXED COST ALLOCATION - ADMIN FEE45,60945,609201-1100-452.31-71 CENTRAL STORES ALLOCATION 2,476 2,568 2,858 2,858 1,666 1,428 6,213LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION - CENTRAL STORES6,2136,213201-1100-452.31-72 GIS ALLOCATION10,811 34,05600000LEVEL TEXTTEXT AMT02 2017 FIXED COST ALLOCATION - GIS ADMIN FEESEE IT ALLOCATION201-1100-452.31-75 311 CALL CENTER ALLOC0 3,48600000LEVEL TEXTTEXT AMT02 #9 311 CALL CENTER ALLOCATIONSEE IT ALLOCATION201-1100-452.31-76 IT ALLOCATION000000 482,794LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7482,794INFORMATION TECHNOLOGYFund 201 - Parks & RecreationCity of South BendExpenditures137 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures482,794201-1100-452.32-02 POSTAGE5,084 8,824 2,375 7,375 3,091 2,236 2,375201-1100-452.32-22 TRAVEL - AIRFARE3890 2,850 2,85000 2,850201-1100-452.32-23 TRAVEL - HOTEL1,392215 1,425 1,4256220 1,425201-1100-452.32-24 TRAVEL - MEALS334820475475187187475201-1100-452.32-25 TRAVEL - OTHER2,0847100000201-1100-452.33-03 PROMOTIONAL40085200000201-1100-452.34-02 LIABILITY INSURANCE0 101,270 119,335 119,335 74,086 64,141 136,460LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION - LIABILITY INS136,460136,460201-1100-452.36-04 COMPUTER EQUIP R&M34,187 33,744 748,893 741,893 413,854 354,7320201-1100-452.39-01 REFNDS,AWARDS,INDEMNITIES 2,234 2,131 4,000 3,100 1,930 1,930 4,000LEVEL TEXTTEXT AMT02 REFUNDS FOR PARK RENTALS4,000INCREASED BY $2,000 - PINHOOK HAS A $100 DEPOSITFOR ALL RENTALS, WHICH IS A REFUNDABLE DEPOSITPLUS ANY STORM DAMAGE, AND VARIOUS OTHER REASONS4,000201-1100-452.39-10 SUBSCRIPTIONS1,313000000201-1100-452.39-11 DUES & MEMBERSHIPS360 1,956 1,900 4,800 4,800 4,800 4,000LEVEL TEXTTEXT AMT02 INDIANA PARKS AND RECREATION ASSOCNATIONAL RECREATION AND PARKS ASSOC4,0004,000201-1100-452.39-70 EDUCATION & TRAINING1,305 1,454 1,425 2,198 1,370 1,370 1,425201-1100-452.39-89 CONTRACT SERVICES/CHARGES 33,770 29,998 15,400 15,400 10,226 10,210 20,000LEVEL TEXTTEXT AMT02 VERMONT SYSTEMS RECTRAC SOFTWARE MAINTNENANCEAGREEMENT5,500VARIOUS SERVICES AND REPAIRS- VENDORS UNKNOWN14,50020,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES169,772 252,538 937,421 938,194 533,112 459,273 707,626------------ ------------ ------------ ------------ ------------ ------------ ------------** ADMINISTRATION981,506 1,079,849 1,466,536 1,468,296 817,776 705,684 1,227,921Fund 201 - Parks & RecreationCity of South BendExpenditures138 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1101-452.10-01 REGULAR WAGES479,018 508,927 748,314 783,909 434,267 376,489 765,012LEVEL TEXTTEXT AMT02 1-PARK MAINTENANCE SUPERINTENDENT..66,5691-MANAGER - FACILITIES62,7771-MANAGER - OPERATIONS62,7771-MANAGER - OPERATIONS - FORESTER62,7772-MANAGER - PARK GROUNDS (62777 EA)125,5541-MANAGER - FACILITY OPS (MPAC)59,9941-SUPERINTENDENT III52,4412-FOREMAN IV (48850 EA)97,7001-FOREMAN V48,8501-HORTICULTURALIST TECH48,8501-ADMIN ASSISTANT 140,5251-MANAGER - ASST FACILITY OPERATIONS (MPAC)36,3361-CUSTODIAN (MPAC)25,473ADJUST TO ACTUAL25,611-765,012201-1101-452.10-02 HOURLY WAGES1,386,057 1,365,784 1,464,938 1,409,743 765,017 660,416 1,362,045LEVEL TEXTTEXT AMT02 3-ARBORIST I (40872 EA)122,6162-ARBORIST II (44408 EA)88,8161-ARBORIST WEED CONTROL39,3121-ATHLETIC FIELD MAINTENANCE37,2111-BLDG MAINT CUSTODIAL & LABOR33,9251-BLDG & STRUCT MAINT I42,8481-BLDG & STRUCT MAINT II44,4081-CONSTR MAINT CARPENTER II42,8481-CONSTR MAINT CARPENTER III44,4081-CONSTR MAINT MASON42,8482-EQUIPMENT OPERATOR II (36816 EA)73,6326-GROUP LEADERS (39312 EA)235,8724-HEAD CUSTODIANS (35381 EA)141,5231-HEAVY EQUIPMENT OPERATOR I39,8942-JOB LEADERS (41995 EA)83,9901-JOB LEADER - MOWER SHOP (EXTRA ALLOWANCES)41,9951-MECHANIC IV40,9971-OPERATOR I35,7551-PAINTER IV40,3312-PLUMBER IV - PARK (44408 EA)88,8161,362,045201-1101-452.10-03 SEASONAL & INTERNS272,704 288,440 440,431 395,296 145,031 93,389 400,500LEVEL TEXTTEXT AMT02 SEASONAL EMPLOYEES-Fund 201 - Parks & RecreationCity of South BendExpenditures139 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresK61AMT - ATHLETIC FIELD MAINTENANCE45,000K61COV - COVELESKI MAINTENANCE15,000K61ERM - EAST RACE MAINTENANCE17,000K61GMT - GROUNDS MAINTENANCE100,000K61KPL - KENNEDY POOL MAINTENANCE4,500K1CMOW -CENTRALIZED MOWING (CITY OWNED PROPERTIES)92,000K61PMT - PLAZA MAINTENANCE15,000K61PPL - POTAWATOMI POOL MAINTENANCE7,500K1PROP - PROPERTY MANAGEMENT94,500K1PNHK - PINHOOK10,000400,500201-1101-452.10-04 EXTRA AND OVERTIME64,067 53,856 90,096 91,096 33,806 24,560 59,000LEVEL TEXTTEXT AMT02 OVERTIME FOR FULL AND PART TIMEK61RMT2,000K61FOR14,000K61GMT19,000K61AMT10,000K61PMT5,000K1CMOW5,000K1PROP3,000K3CCBL1,00059,000201-1101-452.10-05 TEMPORARY SERVICES00 3,247 3,247000LEVEL TEXTTEXT AMT02 K1MPAC3,000K61SBT2473,247201-1101-452.10-06 LONGEVITY PAY00 8,200 8,200 4,200 3,900 7,450LEVEL TEXTTEXT AMT02 LONGEVITY PAY PER TEAMSTERS CONTRACTK61FOR1,350K61GMT2,150K61RMT1,950K61EMT350K61PMT200KC1MOW350K1OBRN400K3CCBL350K3CMLK3507,450Fund 201 - Parks & RecreationCity of South BendExpenditures140 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1101-452.10-09 PERMANENT PART-TIME102,085 136,363 14,000 173,635 116,515 102,123 144,500LEVEL TEXTTEXT AMT02 K61FOR - FORESTRY SECRETARY- 0.60 FTE14,500K61GMT - GROUNDS MAINTENANCE CREW100,000K61PMT - PLAZA MAINTENANCE10,000K61RMT - ROUTINE MAINTENANCE10,000K1OBRN - MAINTENANCE, O'BRIEN CENTER10,000144,500201-1101-452.10-14 PRODUCTIVITY BONUS8,875 7,50000000LEVEL TEXTTEXT AMT02 PER TEAMSTER CONTRACT- AWARDED FOR MEETINGESTABLISHED PRODUCTIVITY GOALS DURING THE YEAR201-1101-452.11-01 FICA - REGULAR173,590 175,310 211,838 219,638 112,593 94,786 209,496LEVEL TEXTTEXT AMT02 ALL SALARIES * 7.65%209,496209,496201-1101-452.11-04 PERF - REGULAR214,568 215,544 258,977 258,977 136,205 117,632 85,681LEVEL TEXTTEXT AMT02 REGULAR AND FULL-TIME OVERTIME SALARIES * 11.2%85,68185,681201-1101-452.11-05 PERF - UNION00 21,271 21,271 11,654 10,055 175,723LEVEL TEXTTEXT AMT02 TEAMSTERS SALARIES + OVERTIME * 12.7%175,723175,723201-1101-452.11-07 UNEMPLOYMENT COMP5,909 3,531 7,865 10,132000LEVEL TEXTTEXT AMT02 REPLACED BY PARENTAL LEAVE (11-29), 2018201-1101-452.11-08 HEALTH INSURANCE484,293 599,190 757,632 757,632 393,874 336,613 723,647LEVEL TEXTTEXT AMT02 GROUP HEALTH, 16,200 PER EE723,647LTD, 96 PER EE45 EMPLOYEES X 16,200 + 4 X 1560 (REBATES)723,647201-1101-452.11-09 LIFE INSURANCE5,110 5,117 6,240 6,240 3,190 2,725 5,760LEVEL TEXTTEXT AMTFund 201 - Parks & RecreationCity of South BendExpenditures141 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 49 EMPLOYEES * 965,7605,760201-1101-452.11-10 CLOTHING ALLOWANCE7,809 12,83000000LEVEL TEXTTEXT AMT02 ESTIMATED COST OF NEW ALLOWANCE PER UPCOMING22,000POLICY22,000201-1101-452.11-11 TOOL ALLOWANCE3,964 3,560 5,200 5,200 2,232 1,695 3,600LEVEL TEXTTEXT AMT02 PER TEAMSTERS CONTRACT:9 POSITIONS QUALIFY FOR TOOL ALLOWANCE @ $4003,6003,600201-1101-452.11-22 PARKING ALLOWANCE00 1,620 1,620615435 1,980LEVEL TEXTTEXT AMT02 PARKING - MPAC1,980ALLOWANCE FOR EES WHO MUST PARK IN CITY LOTS1,980201-1101-452.11-24 CELL PHONE ALLOWANCE2,985 3,903 4,980 4,980 2,905 2,485 6,600LEVEL TEXTTEXT AMT02 CELL PHONE ALLOWANCE, 660 EA6,6006,600201-1101-452.11-27 JOB READINESS ALLOWANCE00 16,150 16,150 14,450 14,450 14,450LEVEL TEXTTEXT AMT02 JOB READINESS ALLOWANCE PER TEAMSTER$425 X 34 TEAMSTERS14,45014,450201-1101-452.11-29 PARENTAL LEAVE000000 6,846LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%6,8466,846201-1101-452.11-99 OTHER FRINGE BENEFITS1,805 2,099 5,000 5,000000LEVEL TEXTTEXT AMT02 ADDITIONAL FUNDING BY EMPLOYER FOR5,000TEAMSTERSFund 201 - Parks & RecreationCity of South BendExpenditures142 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures5,000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES3,212,839 3,381,954 4,065,999 4,171,966 2,176,554 1,841,753 3,972,290201-1101-452.21-02 STATIONERY & PRINTING1,321496 1,665 1,765147139 1,665LEVEL TEXTTEXT AMT02 MATERIALS AND SUPPLIES1,6651,665201-1101-452.21-03 CENTRAL STORES - OFFICE292947687682250380LEVEL TEXTTEXT AMT02 C.S. OFFICE SUPPLIES380380201-1101-452.21-04 OTHER OFFICE SUPPLIES3,604 3,465 4,075 4,075 1,770 1,133 5,000LEVEL TEXTTEXT AMT02 OFFICE SUPPLIES PURCHASED OUTSIDE OF CENTRAL5,000SERVICES5,000201-1101-452.21-05 SMALL OFFICE EQUIPMENT000000150LEVEL TEXTTEXT AMT02 SMALL EQUIPMENT NOT FULLY CONSUMED WITHIN 1 YR150150201-1101-452.22-01 CENTRAL SERVICE GASOLINE 145,158 116,056 202,489 206,689 70,014 59,558 174,000LEVEL TEXTTEXT AMT02 69,600 GALLONS X $2.50 PER GALLON174,000174,000201-1101-452.22-03 OIL00040000400LEVEL TEXTTEXT AMT02 LUBRICANTS400400201-1101-452.22-05 UNIFORMS00 2,200 2,200257257 22,700LEVEL TEXTTEXT AMT02 NEW UNIFORMS PER PENDING POLICY22,000K1MPAC400K1PALA300Fund 201 - Parks & RecreationCity of South BendExpenditures143 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures22,700201-1101-452.22-15 OTHER - CLEANING SUPPLIES229377475475000201-1101-452.22-20 C.S. - MEDICAL/SAFETY12488097097000495LEVEL TEXTTEXT AMT02 REGULAR SUPPLIES495495201-1101-452.22-21 CLEANING SUPPLIES00 19,500 19,500 4,218 2,951 19,500LEVEL TEXTTEXT AMT02 K1MPAC9,500K1PALA10,00019,500201-1101-452.22-22 MEDICAL/SAFETY SUPPLIES00083000 5,080LEVEL TEXTTEXT AMT02 K61SFT2,500K1PROP830K61FOR1,7505,080201-1101-452.22-24 OTHER OPERATING SUPPLIES 92,411 97,527 126,807 134,249 73,013 48,655 137,816LEVEL TEXTTEXT AMT02 K61ADM1,000K61AMT2,708K61COV4,750K61EMT2,500K61ERM713K61FOR5,000K61GMT9,880K61HTC28,000K61MAT58,450K61PLY6,650K61PMT3,515K61PPL6,650K61SBT100K1CMOW500K1MPAC300K1OBRN1,200K1PALA100K1PROP3,400K3CCBL1,200K3CMLK1,200137,816Fund 201 - Parks & RecreationCity of South BendExpenditures144 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1101-452.22-25 PLANTS CHEM. SEED & FERT. 10,104 17,000 70,725 21,913 12,823 8,346 73,250LEVEL TEXTTEXT AMT02 K61AMT2,375K61ERM500K61FOR14,325K61GMT8,525K61HTC42,000K61KPL4,275K61PMT750K1PROP50073,250201-1101-452.22-98 CENTRAL STORES - MPAC/PR0000020201-1101-452.22-99 GAS OTHER2070 2,905 2,90500 2,905LEVEL TEXTTEXT AMT02 1162 GALLONS X $2.50 PER GALLON2,9052,905201-1101-452.23-01 BUILDING MATERIALS32,743 51,524 56,950 60,282 9,501 7,155 16,650LEVEL TEXTTEXT AMT02 K61COV1,500K61NEW10,450K1MPAC4,500K1PALA20016,650201-1101-452.23-10 REPAIR PARTS37,680 37,724 42,775 48,876 28,242 22,510 47,300LEVEL TEXTTEXT AMT02 K61COV1,050K61EMT28,200K61FOR600K61KPL950K61PPL1,500K1CMOW9,500K1MPAC300K1PALA200K1PROP5,00047,300201-1101-452.23-20 SMALL TOOLS & EQUIPMENT 12,248 15,695 38,114 43,097 9,359 6,839 27,673LEVEL TEXTTEXT AMT02 K61AMT2,280Fund 201 - Parks & RecreationCity of South BendExpenditures145 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresK61EMT3,800K61ERM500K61FOR2,900K61GMT713K61KPL200K61PMT1,000K61PPL600K61SFT380K1CMOW2,000K1MPAC5,800K1PALA5,000K1PROP2,50027,673201-1101-452.23-99 OTHER R&M SUPPLIES60,424 61,017 77,470 153,136 37,539 25,227 141,915LEVEL TEXTTEXT AMT02 K61AMT9,500K61COV500K61ERM1,000K61GMT2,375K61KPL500K61MAT950K61PLY27,790K61PMT500K61PPL5,200K61SBT20,000K1CMOW500K1MPAC2,500K1PALA500K1PROP70,100141,915------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES396,282 402,055 647,888 702,130 247,108 182,774 676,879201-1101-452.31-01 LEGAL SERVICES03300000201-1101-452.31-06 OTHER PROFESSIONAL SVCS1,808000000201-1101-452.31-70 ADM FEE ALLOCATION143,784 166,284 180,384 180,384 105,224 90,192 204,040LEVEL TEXTTEXT AMT02 FIXED ALLOCATION FEE204,040204,040201-1101-452.31-71 CENTRAL STORES ALLOCATION 13,597 15,000 18,553 18,553 9,261 7,938 36,513LEVEL TEXTTEXT AMT02 PRINT SHOP ALLOCATIONFund 201 - Parks & RecreationCity of South BendExpenditures146 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresK61ADM34,122K1MPAC - FROM MPAC FUND 1012,39136,513201-1101-452.31-73 PRINT SHOP ALLOCATION0 1,440 1,418 1,418826708929LEVEL TEXTTEXT AMT02 PRINT SHOP ALLOCATIONK61ADM929929201-1101-452.32-02 POSTAGE2,37011750050060500201-1101-452.32-04 TELEPHONE33,561 32,995 30,492 30,973 7,547 6,220 30,492LEVEL TEXTTEXT AMT02 VOIP- 89 PHONES @ $20/MO X 12 MONTHS21,360NON VOIP PHONES/HOT SPOTS9,13230,492201-1101-452.32-05 OTHER COMM/TRANS15,463 14,103 12,132 12,132 5,991 3,5580LEVEL TEXTTEXT AMT02 BUILDING ALARMS12,13212,132201-1101-452.32-21 TRAVEL - MILEAGE029602001671670201-1101-452.32-22 TRAVEL - AIRFARE0621750750000201-1101-452.32-23 TRAVEL - HOTEL239 1,759 1,650 1,650491491 1,500LEVEL TEXTTEXT AMT02 K61ADM1,5001,500201-1101-452.32-24 TRAVEL - MEALS3112070050015072750LEVEL TEXTTEXT AMT02 K61ADM750750201-1101-452.32-25 TRAVEL - OTHER0115150150880201-1101-452.33-01 PROMOTIONAL SUPPLIES0038038000380LEVEL TEXTTEXT AMT02 K61ADM380380201-1101-452.33-02 PUBLICATION LEGAL NOTICE084608003071410201-1101-452.35-01 ELECTRIC306,974 315,689 280,000 280,000 163,933 137,270 282,500Fund 201 - Parks & RecreationCity of South BendExpenditures147 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 ESTIMATED ELECTRICITY USAGE, 2018282,500WILL BE IDENTIFIED TO SPECIFIC SITES THROUGHPROJECT CODES WHEN ALLOCATED BY ADMIN FIN282,500201-1101-452.35-02 GAS78,924 51,321 90,000 90,000 49,091 48,324 90,000LEVEL TEXTTEXT AMT02 ALLOCATED TO SPECIFIC SITES VIA PROJECT CODES BY90,000ADMIN FIN'S ALLOCATION90,000201-1101-452.35-03 TRASH REMOVAL3,434 8,104 15,500 23,500 9,495 6,585 17,000LEVEL TEXTTEXT AMT02 K61ADM5,500K61GMT8,500K1MPAC3,00017,000201-1101-452.35-04 WATER56,953 79,368 50,000 90,104 77,688 35,770 180,000LEVEL TEXTTEXT AMT02 WILL BE ALLOCATED TO SITES BY PROJECT CODE180,000IN 2017, SBWW STARTED BILLING VPA FOR ALL SITESLIMITED HISTORY SUGGESTS $180K IS APPROPRIATE180,000201-1101-452.36-01 BUILDING R&M5,188 5,238 432,721 503,821 245,731 203,345 599,530LEVEL TEXTTEXT AMT02 K61COV20,344K61KPL3,000K61PPL6,325K61RMT73,500K1MPAC74,041K1OBRN1,320K1PALA50,000K1DTSB - CONTRACT571,000LESS PORTION PAID FROM EDIT (FUND 408)200,000-599,530201-1101-452.36-02 OFFICE EQUIP R&M8,078 5,994 8,000 8,000 7,838 7,158 10,000LEVEL TEXTTEXT AMT02 COPIER MAINTENANCEFund 201 - Parks & RecreationCity of South BendExpenditures148 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresK61ADM8,500K1MPAC1,50010,000201-1101-452.36-03 AUTO EQUIPMENT R&M216,733 245,514 240,000 233,400 173,071 157,124 240,000LEVEL TEXTTEXT AMT02 PM FLEET ALLOCATION, PARTS AND LABOR240,000240,000201-1101-452.36-04 COMPUTER EQUIP R&M00 2,500 2,50000 2,500LEVEL TEXTTEXT AMT02 K1MPAC - MORRIS PERF. ARTS2,5002,500201-1101-452.36-05 OTHER EQUIP R&M00 6,100 4,100139139 6,100LEVEL TEXTTEXT AMT02 K1MPAC - MORRIS PERF. ARTS6,1006,100201-1101-452.36-06 RADIO EQUIP R&M2,582 7,013 7,000 15,000 17,175 14,621 15,000LEVEL TEXTTEXT AMT02 RADIO SHOP BUDGET15,00015,000201-1101-452.36-09 LAND IMPROVEMENTS0000 17,090- 41,508 250,000LEVEL TEXTTEXT AMT02 K61SBT10,000K1PROP20,000PLAYGROUND RESURFACING60,000PAVEMENT REPAIRS50,000SIDEWALK REPAIRS20,000CITY CEMETERY HEADSTONE REPAIRS25,000RUM VILLAGE PAVILION REPLACEMENT40,000ADA RESTROOM RENOVATIONS25,000250,000201-1101-452.36-10 EXTERMINATING3,523 4,747 4,275 7,375 7,316 7,316 5,075LEVEL TEXTTEXT AMT02 EXTERMINATING SERVICESK61ADM4,275K1MPAC8005,075Fund 201 - Parks & RecreationCity of South BendExpenditures149 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1101-452.37-11 CAPITAL LEASE PRINCIPAL 292,172 188,494 256,925 256,925 157,374 131,827 317,042LEVEL TEXTTEXT AMT02 2014 HP COMP LSE 1 (#125)2,2622014 HP COMP LSE 2 (#126)1642014 HP COMP LSE 6 (#128)1,0352015 HP COMP LSE 8 (#136)4692015 HP COMP LSE 9 (#138)6,6642015 VEH/EQP (#140)32,5912015 COPIER (HPSC) (#146)8582016 VEH/EQP #1 (#153)15,5212016 VEH/EQP #3 (#154)199,1342016 HP COMP LSE 13 (#155)4,1132016 COPIER (FORESTRY OFC) (#157)615VPA PROMOTION VEHICLE (4.9%, 5 YR, $600,000)53,616317,042201-1101-452.37-12 CAPITAL LEASE INTEREST7,686 5,503 22,766 22,766 11,955 10,372 29,257LEVEL TEXTTEXT AMT02 2014 HP COMP LSE 1 (#125)462014 HP COMP LSE 2 (#126)42014 HP COMP LSE 6 (#128)282015 HP COMP LSE 8 (#136)262015 HP COMP LSE 9 (#138)4992015 VEH/EQP (#140)1,2612015 COPIER (HPSC) (#146)1292016 VEH/EQP AMEND #1 (#153)9082016 VEH/EQP AMEND #3 (#154)11,4612016 HP COMP LSE 13 (#155)5752016 COPIER (FORESTRY OFC) (#157)165VPA PROMO VEHICLE LEASE (4.9%, 5 YR, $600,000)14,15529,257201-1101-452.39-10 SUBSCRIPTIONS125123 1,847 1,847650745LEVEL TEXTTEXT AMT02 K61FOR475K61PMT80K61SFT190745201-1101-452.39-11 DUES & MEMBERSHIPS035702001801800201-1101-452.39-12 SECURITY00008320 12,132LEVEL TEXTTEXT AMT02 SECURITY SVCS MOVED FROM 32-05Fund 201 - Parks & RecreationCity of South BendExpenditures150 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresK61ADM11,050K1MPAC780K1PALA30212,132201-1101-452.39-70 EDUCATION & TRAINING3,544 2,795 4,149 4,227 3,062 3,062 5,675LEVEL TEXTTEXT AMT02 K61ADM2,000K61FOR2,375K61SBT400K61SFT400K61MPAC5005,675201-1101-452.39-85 LANDFILL00 8,0000000201-1101-452.39-89 CONTRACT SERVICES/CHARGES 215,635 178,548 170,040 178,207 108,206 96,501 135,640LEVEL TEXTTEXT AMT02 PORTABLE TOILETS, OTHER SVCSK61ADM5,000K61AMT1,900K61CEM38,000K61EMT2,000K61ERM500K61FOR3,600K61GMT8,550K61KPL950K61PMT500K61RMT63,250INCLUDES SAFETY-KLEEN, CINTASK61SBT3,500K61SFT1,140K1CMOW4,750K1MPAC1,500K1PALA500135,640------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES1,412,404 1,332,537 1,846,932 1,970,362 1,146,039 1,010,598 2,473,300201-1101-452.43-02 MOTOR EQUIPMENT0 22,76000000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL0 22,76000000201-1101-452.50-02 INTER-FUND OPER. TRANSFRS000 9,85000 24,850LEVEL TEXTTEXT AMTFund 201 - Parks & RecreationCity of South BendExpenditures151 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 K1CMOW TO FUND 40515,000ESTIMATE BASED ON $3.40 PER CUTK1PROP TO FUND 4059,850TO BUILD CAPITAL FUND24,850------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES000 9,85000 24,850------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE5,021,525 5,139,306 6,560,819 6,854,308 3,569,701 3,035,125 7,147,319Fund 201 - Parks & RecreationCity of South BendExpenditures152 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1102-452.10-01 REGULAR WAGES242,141 246,845 300,914 292,369 158,166 135,087 295,038LEVEL TEXTTEXT AMT02 1 DIRECTOR GOLF OPERATIONS64,1822 CLUB PROS102,4221 MANAGER OF CONCESSIONS (ADDED MID YEAR 2016)48,8502 SUPERINTENDENT V @ $55,330 (1-O)115,129ORDINANCE LESS ACTUAL = $6,49735,545-295,038201-1102-452.10-02 HOURLY WAGES120,790 118,678 80,080 80,080 48,070 41,810 81,994LEVEL TEXTTEXT AMT02 2 MECHANIC IV81,994PER TEAMSTERS CONTRACT, 2017-202081,994201-1102-452.10-03 SEASONAL & INTERNS85,644 50,292 4,596 22,546 10,258 4,737 28,500LEVEL TEXTTEXT AMT02 SEASONAL PART TIME28,50028,500201-1102-452.10-04 EXTRA AND OVERTIME22,784 18,467 8,750 7,500 8,594 7,200 7,500LEVEL TEXTTEXT AMT02 OVERTTIME FOR FULL TIME AND PART TIME7,5007,500201-1102-452.10-06 LONGEVITY PAY00600600550550600LEVEL TEXTTEXT AMT02 2 TEAMSTERS - 1 @ $350; 1 @ $250600PER TEAMSTERS CONTRACT 2017-2020600201-1102-452.10-09 PERMANENT PART-TIME185,103 229,660 236,148 288,050 133,114 98,930 234,000LEVEL TEXTTEXT AMT02 K2ELBC22,500K62ELM40,000K62ELP35,000K2ERSC22,500K62ERM40,000K62ERP30,000K62STM14,000K62STP30,000234,000Fund 201 - Parks & RecreationCity of South BendExpenditures153 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1102-452.11-01 FICA - REGULAR49,306 48,855 48,280 52,874 26,725 21,453 49,544LEVEL TEXTTEXT AMT02 ALL SALARIES * 7.65%49,54449,544201-1102-452.11-04 PERF - REGULAR42,381 42,379 43,777 43,777 24,114 20,672 33,044LEVEL TEXTTEXT AMT02 REGULAR, HOURLY, OVERTIME SALARIES * 11.2%33,04433,044201-1102-452.11-05 PERF - UNION00 1,201 1,201856741 10,413LEVEL TEXTTEXT AMT02 TEAMSTER SALARIES * 12.7%10,41310,413201-1102-452.11-07 UNEMPLOYMENT COMP1,715 1,111 1,576 1,576000LEVEL TEXTTEXT AMT02 UNEMPLOYMENT ADMINISTRATIVE FEE0.25% OF PAYROLL1,5761,576201-1102-452.11-08 HEALTH INSURANCE90,175 107,858 125,168 125,168 64,784 55,523 130,368LEVEL TEXTTEXT AMT02 GROUP HEALTH, 8 EMPLOYEES * 16,200129,600LTD: 8 EMPLOYEES * 96768130,368201-1102-452.11-09 LIFE INSURANCE895893960960515435960LEVEL TEXTTEXT AMT02 8 EMPLOYEES @ $5 X 24 PAY PERIODS960960201-1102-452.11-10 CLOTHING ALLOWANCE24434900000LEVEL TEXTTEXT AMT02 CLOTHING ALLOWANCE FOR 8 EMPLOYEES@ $200/EMPLOYEE201-1102-452.11-11 TOOL ALLOWANCE641325800800799799800LEVEL TEXTTEXT AMT02 PER TEAMSTER CONTRACT 2@ $400800Fund 201 - Parks & RecreationCity of South BendExpenditures154 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures800201-1102-452.11-24 CELL PHONE ALLOWANCE6609266023400660LEVEL TEXTTEXT AMT02 1 EMPLOYEE660660201-1102-452.11-27 JOB READINESS ALLOWANCE00850 1,276 1,275 1,275850LEVEL TEXTTEXT AMT02 LONGEVITY PER TEAMSTER CONTRACT 2 @ $425850850201-1102-452.11-29 PARENTAL LEAVE000000 1,619LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%1,6191,619201-1102-452.11-99 OTHER FRINGE BENEFITS400400 2,500 2,500000LEVEL TEXTTEXT AMT02 OTHER EMPLOYER CONTRIBUTION TO TEAMSTER PLAN2,5002,500------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES842,879 866,204 856,860 921,511 477,820 389,213 875,890201-1102-452.21-02 STATIONERY & PRINTING705103003018300LEVEL TEXTTEXT AMT02 K62ADM300300201-1102-452.21-03 CENTRAL STORES - OFFICE064550500050LEVEL TEXTTEXT AMT02 K62ADM5050201-1102-452.21-04 OTHER OFFICE SUPPLIES1,5065490 1,318190190568LEVEL TEXTTEXT AMT02 K62ADM568568201-1102-452.21-05 SMALL OFFICE EQUIPMENT1,750000000Fund 201 - Parks & RecreationCity of South BendExpenditures155 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1102-452.22-01 CENTRAL SERVICE GASOLINE2,178466 48,412 12,7829292 2,000LEVEL TEXTTEXT AMT02 MINIMAL GAS PURCHASED AT CENTRAL STORESK62ELM1,000K62ERM1,0002,000201-1102-452.22-03 OIL899 1,52300000LEVEL TEXTTEXT AMT02 PRE KEEGAN $2,000201-1102-452.22-05 UNIFORMS000 3,871 1,249896 5,250LEVEL TEXTTEXT AMT02 K62ADM250K2ELBC500K62ELM1,550K62ELP500K2ERSC500K62ERM950K62STM250K62STP250K62ERP5005,250201-1102-452.22-24 OTHER OPERATING SUPPLIES 18,970 41,660 30,970 34,668 18,012 13,777 45,000LEVEL TEXTTEXT AMT02 K2ELBC8,000K62ELM13,000K62ELP1,000K2ERSC8,000K62ERM13,000K62ERP1,000K2STUC1,00045,000201-1102-452.22-25 PLANTS CHEM. SEED & FERT. 111,306 101,211 111,304 116,509 81,124 80,200 106,509LEVEL TEXTTEXT AMT02 K62ELM52,102K62ERM52,454K62STM1,953106,509201-1102-452.22-29 INVENTORY "FOR SALE"144,838 91,442 87,182 86,870 59,115 51,530 71,300LEVEL TEXTTEXT AMTFund 201 - Parks & RecreationCity of South BendExpenditures156 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 K2ELBC35,000K2ERSC35,000K2STUC1,30071,300201-1102-452.22-30 CONCESSIONS INVENTORY113,377 99,391 176,183 108,941 45,847 27,236 83,000LEVEL TEXTTEXT AMT02 K2ELBC40,000K2ERSC35,000K2STUC8,00083,000201-1102-452.22-99 GAS OTHER26,347 21,0130 40,152 9,980 7,624 20,000LEVEL TEXTTEXT AMT02 K62ELM8,000K62ERM8,000K62STM4,000GOLF COURSES HAVE ON-SITE GAS TANKS FILLED BYNELSON FUEL, USED MORE OFTEN THAN C.S. GAS20,000201-1102-452.23-10 REPAIR PARTS42,573 34,979099500995LEVEL TEXTTEXT AMT02 K62ELM422K62ERM573995201-1102-452.23-99 OTHER R&M SUPPLIES4,577 4,075 47,406 47,598 29,620 26,592 47,898LEVEL TEXTTEXT AMT02 K62ELM26,000K62ERM18,000K62STM3,89847,898------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES469,026 396,955 501,507 454,054 245,259 208,156 382,870201-1102-452.31-06 OTHER PROFESSIONAL SVCS1,115000000201-1102-452.31-70 ADM FEE ALLOCATION45,435 50,520 55,493 55,493 32,368 27,744 50,394LEVEL TEXTTEXT AMT02 ADMIN FEE - FIXED COST ALLOCATION50,39450,394Fund 201 - Parks & RecreationCity of South BendExpenditures157 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1102-452.31-71 CENTRAL STORES ALLOCATION 1,306 1,284 1,343 1,343784672 3,106LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION - CENTRAL STORES3,1063,106201-1102-452.31-73 PRINT SHOP ALLOCATION0492502502294252324LEVEL TEXTTEXT AMT02 FIXED ALLOCATION - PRINT SHOP324324201-1102-452.32-02 POSTAGE015200000LEVEL TEXTTEXT AMT02 PRE KEEGAN TOTAL $150201-1102-452.32-04 TELEPHONE8,160 8,282800838249187400LEVEL TEXTTEXT AMT02 K62ELP400400201-1102-452.32-05 OTHER COMM/TRANS4,625 5,677 1,225038 1,1370LEVEL TEXTTEXT AMT02 POST KEEGAN FIVE YEAR FORECAST1,225..................................PRE KEEGAN TOTALBUILDING ALARMS $4,2541,225201-1102-452.33-02 PUBLICATION LEGAL NOTICE47000000201-1102-452.35-01 ELECTRIC47,058 47,483 24,000 24,000 21,715 16,602 28,200LEVEL TEXTTEXT AMT02 K62ELM14,000K62ERM10,000K62STM4,20028,200201-1102-452.35-02 GAS23,072 16,982 16,000 16,000 16,223 15,931 16,000LEVEL TEXTTEXT AMT02 K62ELM11,002K62ERM4,99816,000201-1102-452.35-03 TRASH REMOVAL5,000 5,206 4,791 5,811 3,522 3,023 7,791Fund 201 - Parks & RecreationCity of South BendExpenditures158 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 K62ELM3,039K62ERM4,152K62STM6007,791201-1102-452.35-04 WATER1500 4,026 4,026333333 4,026LEVEL TEXTTEXT AMT02 K62STM4,026INCLUDES TRASH REMOVAL4,026201-1102-452.36-01 BUILDING R&M000300 13,508 2,7980201-1102-452.36-03 AUTO EQUIPMENT R&M3,378 4,87100000LEVEL TEXTTEXT AMT02 PRE KEEGAN TOTAL $3,700201-1102-452.36-10 EXTERMINATING1,982 1,650700700225225 2,100LEVEL TEXTTEXT AMT02 K2ELBC700K62ELP700K2ERSC7002,100201-1102-452.37-07 GOLF CARTS000000 60,000LEVEL TEXTTEXT AMT02 FIRST FULL YEAR OF EXPECTED OPERATING LEASEK62ELP40,000K62ERP20,00060,000201-1102-452.39-10 SUBSCRIPTIONS190- 23540040000400LEVEL TEXTTEXT AMT02 K62ELP400400201-1102-452.39-11 DUES & MEMBERSHIPS000 1,500 1,762 1,104 4,000LEVEL TEXTTEXT AMT02 K62ELP2,000K62ERP2,0004,000Fund 201 - Parks & RecreationCity of South BendExpenditures159 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1102-452.39-12 SECURITY000 4,820 2,387 1,250 1,263LEVEL TEXTTEXT AMT02 K62ELP1,218K62STM451,263201-1102-452.39-39 BANK CREDIT CARD CHARGES 19,313 19,321 19,000 19,000 10,348 7,242 19,000LEVEL TEXTTEXT AMT02 K62ELP10,000K62ERP9,00019,000201-1102-452.39-70 EDUCATION & TRAINING012204002952950LEVEL TEXTTEXT AMT02 PRE KEEGAN TOTAL $800201-1102-452.39-89 CONTRACT SERVICES/CHARGES 43,106 43,037 53,743 47,877 18,479 16,262 45,054LEVEL TEXTTEXT AMT02 K62ADM4,063K2ELBC1,340K62ELM14,735K62ELP4,400K2ERSC940K62ERM14,950K62ERP4,626MISC SERVICES INCLUDING JOY'S JOHNS, SAFETY-KLEEN,DISH NETWORK, ETC.45,054------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES203,557 205,314 182,023 183,010 122,530 95,057 242,058201-1102-452.50-02 INTER-FUND OPER. TRANSFRS00 80,000 80,00000 80,000LEVEL TEXTTEXT AMT02 GOLF NON-REVERTING FEES - TRANSFER TO FUND 40580,000BASED ON $1 PER 18-HOLE ROUND AND A PORTION OFSEASON TICKET PRICE80,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES00 80,000 80,00000 80,000------------ ------------ ------------ ------------ ------------ ------------ ------------** GOLF COURSES1,515,462 1,468,473 1,620,390 1,638,575 845,609 692,426 1,580,818Fund 201 - Parks & RecreationCity of South BendExpenditures160 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1103-452.10-01 REGULAR WAGES1,048,717 1,028,264 868,243 868,243 528,464 460,922 891,733LEVEL TEXTTEXT AMT02 1-DIRECTOR OF RECREATION73,9731-ASSISTANT DIR OF RECREATION59,5331-NATURALIST37,0697-PROGRAM COORDINATOR ($48,850 EA)341,9491-SUPERVISOR - ADMIN ASSIST37,3442-SUPERVISOR - ASST PROGRAM ($36,015 EA)72,0301-SUPERVISOR - ATHLETIC48,8503-SUPERVISOR - CENTER ($48,850 EA)146,5501-SUPERVISOR - FITNESS45,4432-SUPERVISOR - PROGRAM ($48,850 EA)97,7001-SUPERVISOR - RUM VILLAGE PARK42,076ADJUST TO ACTUAL110,784-891,733201-1103-452.10-03 SEASONAL & INTERNS255,943 245,608 317,830 290,546 148,316 57,999 311,879LEVEL TEXTTEXT AMT02 AQUATICS165,334ATHLETICS33,935CENTERS69,650PROGRAM42,960311,879201-1103-452.10-04 EXTRA AND OVERTIME5618910035800201-1103-452.10-05 TEMPORARY SERVICES4,557000000201-1103-452.10-09 PERMANENT PART-TIME102,364 114,720 176,233 203,517 112,687 97,454 156,105LEVEL TEXTTEXT AMT02 ATHLETICS4,992CENTERS144,683MANAGEMENT6,430156,105201-1103-452.11-01 FICA - REGULAR104,446 102,824 104,216 104,216 58,127 45,167 104,018LEVEL TEXTTEXT AMT02 ALL SALARIES * 7.65%104,018104,018201-1103-452.11-04 PERF - REGULAR117,386 114,583 97,243 97,243 59,070 51,505 99,874LEVEL TEXTTEXT AMT02 REGULAR SALARIES * 11.2%99,87499,874Fund 201 - Parks & RecreationCity of South BendExpenditures161 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1103-452.11-07 UNEMPLOYMENT COMP3,699 2,150 3,406 3,406000LEVEL TEXTTEXT AMT02 UNEMPLOYMENT FEE- 0.25% OF PAYROLL3,4063,406201-1103-452.11-08 HEALTH INSURANCE249,438 297,865 286,598 286,598 171,254 147,279 342,216LEVEL TEXTTEXT AMT02 AQUATICS32,592ATHLETICS32,592CENTERS211,848MANAGEMENT32,592PROGRAMS32,592342,216201-1103-452.11-09 LIFE INSURANCE2,970 2,998 2,520 2,520 1,506 1,295 2,520LEVEL TEXTTEXT AMT02 21 EMPLOYEES X $5 X 24 PAY PERIODS2,5202,520201-1103-452.11-24 CELL PHONE ALLOWANCE2,640 2,915 1,980 1,980 1,265 1,045 2,640LEVEL TEXTTEXT AMT02 AQUATICS1,320MANAGEMENT660PROGRAMS660$660 PER PERSON ANNUALLY2,640201-1103-452.11-29 PARENTAL LEAVE000000 3,399LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%3,3993,399------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES1,892,721 1,912,818 1,858,269 1,858,269 1,081,047 862,667 1,914,384201-1103-452.21-02 STATIONERY & PRINTING1,131938 5,666 5,777208208 5,566LEVEL TEXTTEXT AMT02 CENTERS300MANAGEMENT5,2665,566201-1103-452.21-03 CENTRAL STORES - OFFICE481811 4,200 4,200968752 4,200Fund 201 - Parks & RecreationCity of South BendExpenditures162 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 CENTERS4,2004,200201-1103-452.21-04 OTHER OFFICE SUPPLIES11418 1,600 1,198182182 1,550LEVEL TEXTTEXT AMT02 CENTERS100MANAGEMENT1,4501,550201-1103-452.21-05 SMALL OFFICE EQUIPMENT1,75042505505055050201-1103-452.22-05 UNIFORMS3,064 1,300 2,100 2,100 2,072622 2,900LEVEL TEXTTEXT AMT02 AQUATICS1,500MANAGEMENT100PROGRAMS1,300UNIFORMS FOR PROGRAMS AND PARTICIPANTS2,900201-1103-452.22-20 C.S. - MEDICAL/SAFETY1,599 1,094 2,514514271271 2,514LEVEL TEXTTEXT AMT02 AQUATICS2,514CLEANING SUPPLIES2,514201-1103-452.22-22 MEDICAL/SAFETY SUPPLIES1,412 1,046 2,576576500500 2,576LEVEL TEXTTEXT AMT02 AQUATICS2,5762,576201-1103-452.22-23 RECREATION SUPPLIES43,629 43,606 84,695 103,446 42,962 29,884 75,870LEVEL TEXTTEXT AMT02 CENTERS67,225MANAGEMENT2,000PROGRAMS6,64575,870201-1103-452.22-24 OTHER OPERATING SUPPLIES 11,343 15,514 15,837 20,357 12,108 11,460 13,587LEVEL TEXTTEXT AMT02 AQUATICS12,437CENTERS1,100Fund 201 - Parks & RecreationCity of South BendExpenditures163 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresMANAGEMENT5013,587201-1103-452.22-30 CONCESSIONS INVENTORY3,943 1,668 6,000 6,00066660LEVEL TEXTTEXT AMT02 ITEMS FOR RESALE THROUGH ATHLETICS6,0006,000201-1103-452.23-99 OTHER R&M SUPPLIES00 1,100 1,10000 1,750LEVEL TEXTTEXT AMT02 CENTERS1,7501,750------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES68,466 66,420 126,288 145,818 59,842 44,449 110,513201-1103-452.31-06 OTHER PROFESSIONAL SVCS3,568640 2,224 4,724 1,425 1,000 2,524LEVEL TEXTTEXT AMT02 CENTERS2,5242,524201-1103-452.31-70 ADM FEE ALLOCATION62,668 74,772 80,716 80,716 47,082 40,356 66,090LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION66,090ADMINISTRATIVE FEE66,090201-1103-452.32-02 POSTAGE0020020000200LEVEL TEXTTEXT AMT02 CENTERS200200201-1103-452.32-21 TRAVEL - MILEAGE2,39921200000LEVEL TEXTTEXT AMT02 USE OF PERSONAL VEHICLES FOR RECREATION PROGRAMSSPECIAL EVENTSAQUATICSCENTERSPROGRAMS201-1103-452.32-24 TRAVEL - MEALS005050000LEVEL TEXTTEXT AMTFund 201 - Parks & RecreationCity of South BendExpenditures164 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 REC ADMIN50SPECIAL EVENTSAQUATICSATHLETICSCENTERSPROGRAMSMARKETING - MOVED TO 201.1110 - K10ADM50201-1103-452.32-25 TRAVEL - OTHER3000000LEVEL TEXTTEXT AMT02 REC ADMINSPECIAL EVENTSAQUATICSATHLETICSCENTERSPROGRMAS201-1103-452.33-03 PROMOTIONAL18,782 28,921 3,714 9,462 5,289 4,857 3,700LEVEL TEXTTEXT AMT02 CENTERS1,700MANAGEMENT2,0003,700201-1103-452.36-02 OFFICE EQUIP R&M0005004435300LEVEL TEXTTEXT AMT02 CENTERS - COPIER MAINTENANCE300300201-1103-452.36-05 OTHER EQUIP R&M000 1,500 1,003 1,0030201-1103-452.37-05 RECREATION SPACE0006001000 1,200LEVEL TEXTTEXT AMT02 CENTERS1,200RENTAL OF SPACE AT ZION CHURCH FOR HOWARD PARKDURING RECONSTRUCTION, $100/MONTH THROUGH MAR 20191,200201-1103-452.37-11 CAPITAL LEASE PRINCIPAL084700000201-1103-452.37-12 CAPITAL LEASE INTEREST022200000201-1103-452.39-01 REFNDS,AWARDS,INDEMNITIES561790000 15,000LEVEL TEXTTEXT AMT02 USED TO REFUND FEES PAID FOR CAMPS, EVENTS, ETC.MANAGEMENT15,00015,000Fund 201 - Parks & RecreationCity of South BendExpenditures165 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1103-452.39-10 SUBSCRIPTIONS1,8066502900000201-1103-452.39-11 DUES & MEMBERSHIPS01440290175175 1,190LEVEL TEXTTEXT AMT02 CENTERS900MANAGEMENT2901,190201-1103-452.39-30 GRANTS AND SUBSIDIES000000 16,060LEVEL TEXTTEXT AMT02 TICKETS ARE SOLD AT DISCOUNT TO CERTAIN ELIGIBLEPARTICIPANTS. THE DIFFERENCE IS A SCHOLARSHIP:AQUATICS7,420CENTERS8,64016,060201-1103-452.39-39 BANK CREDIT CARD CHARGES9,549 9,757 9,500 9,500 6,721 5,493 8,000LEVEL TEXTTEXT AMT02 MANAGEMENT8,0008,000201-1103-452.39-70 EDUCATION & TRAINING60010 1,000 3,5002802800LEVEL TEXTTEXT AMT02 STAFF EDUCATION1,0001,000201-1103-452.39-89 CONTRACT SERVICES/CHARGES 65,589 58,736 25,589 24,046 17,861 12,196 34,509LEVEL TEXTTEXT AMT02 AQUATICS9,084CENTERS22,425MANAGEMENT2,000REC PROGRAMS1,00034,509201-1103-452.39-99 MILEAGE REIMBURSEMENT62 1,479 4,242 1,642872288 4,792LEVEL TEXTTEXT AMT02 AQUATICS1,500CENTERS850MANAGEMENT500PROGRAMS1,9424,792Fund 201 - Parks & RecreationCity of South BendExpenditures166 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES165,082 176,569 127,525 136,730 80,852 65,683 153,565201-1103-452.50-02 INTER-FUND OPER. TRANSFRS00 13,000 13,000000LEVEL TEXTTEXT AMT02 NON-REVERTING FEES - TRSFR TO FUND 405 - ICE RINK1,500NON-REVERTING FEES - TRSFR TO FUND 405 - EAST RACE11,500TRANSFER TO ACCT #405-1103-392.00-0013,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES00 13,000 13,000000------------ ------------ ------------ ------------ ------------ ------------ ------------** RECREATION2,126,269 2,155,807 2,125,082 2,153,817 1,221,741 972,799 2,178,462Fund 201 - Parks & RecreationCity of South BendExpenditures167 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1104-452.10-02 HOURLY WAGES42,814 42,086 42,515 42,515 24,528 21,258 17,853LEVEL TEXTTEXT AMT02 1 BLDG & STRUCTURE MAINT. ($20.44/HR)17,853ZOO OPERATED BY POTAWATOMI ZOOLOGICAL SOCIETYTHIS EMPLOYEE WILL REMAIN A CITY EMPLOYEEE UNTILREACHING 10 YEARS OF EMPLOYMENT - BECOMES ZOOEMPLOYEE IN JUNE 201817,853201-1104-452.10-04 EXTRA AND OVERTIME1,230 2,196 1,000 1,0004062910LEVEL TEXTTEXT AMT02 ANTICIPATED OVERTIME FOR CITY EMPLOYEE1,0001,000201-1104-452.10-06 LONGEVITY PAY00150150150150150LEVEL TEXTTEXT AMT02 LONGEVITY PAY 1 @ $150150150201-1104-452.11-01 FICA - REGULAR3,194 3,179 3,340 3,340 1,847 1,603 1,366LEVEL TEXTTEXT AMT02 ALL SALARIES * 7.65%1,3661,366201-1104-452.11-04 PERF - REGULAR4,933 4,960 4,938 4,938 2,809 2,4300LEVEL TEXTTEXT AMT02 $44,090 X 11.2%=4,9384,938201-1104-452.11-05 PERF - UNION00661661376325 2,267LEVEL TEXTTEXT AMT02 SALARIES * 12.7%2,2672,267201-1104-452.11-07 UNEMPLOYMENT COMP11061110110000LEVEL TEXTTEXT AMT02 UNEMPLOYMENT ADMIN FEE0.25% OF PAYROLL110110201-1104-452.11-08 HEALTH INSURANCE12,090 14,496 15,646 15,646 9,127 7,823 6,790Fund 201 - Parks & RecreationCity of South BendExpenditures168 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 EMPLOYEE BECOMES ZOO EMPLOYEE IN JUNE 2018GROUP HEALTH, JAN-MAY6,750LTD, JAN-MAY406,790201-1104-452.11-09 LIFE INSURANCE120120120120706050LEVEL TEXTTEXT AMT02 EMPLOYEE BECOMES ZOO EMPLOYEE IN JUNE 2018LIFE INSURANCE, JAN-MAY5050201-1104-452.11-10 CLOTHING ALLOWANCE92-000000LEVEL TEXTTEXT AMT02 CLOTHING ALLOWANCE PER UNION AGREEMENT1 EMPLOYEES X $200=201-1104-452.11-11 TOOL ALLOWANCE0040040000400LEVEL TEXTTEXT AMT02 TOOL ALLOWANCE PER TEAMSTERS CONTRACT: 1 @ $400400400201-1104-452.11-27 JOB READINESS ALLOWANCE00425425425425425LEVEL TEXTTEXT AMT02 JOB READINESS PER TEAMSTER CONTRACT 1 @ $425425425201-1104-452.11-29 PARENTAL LEAVE00000045LEVEL TEXTTEXT AMT02 SALARIES * 0.25%4545201-1104-452.11-99 OTHER FRINGE BENEFITS165200 1,250 1,250000LEVEL TEXTTEXT AMT02 OTHER EMPLOYER CONTRIBUTIONS FOR TEAMSTERS1,2501,250------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES64,564 67,298 70,555 70,555 39,738 34,366 29,346201-1104-452.22-01 CENTRAL SERVICE GASOLINE7380 1,000 1,000000------------ ------------ ------------ ------------ ------------ ------------ ------------Fund 201 - Parks & RecreationCity of South BendExpenditures169 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures* SUPPLIES7380 1,000 1,000000201-1104-452.31-06 OTHER PROFESSIONAL SVCS 12,693000000201-1104-452.31-20 ZOOLOGICAL SOCIETY734,491 734,662 632,909 632,909 632,909 632,909 670,654LEVEL TEXTTEXT AMT02 ZOO OPERATED BY POTAWATOMI ZOOLOGICAL SOCIETYPER MEMORANDUM OF UNDERSTANDINGFOR 2018 - CONTRIBUTION OF $700,000 BY CITY700,000LESS EXPENSE OF CITY EMPLOYEE THROUGH MAY29,346-670,654201-1104-452.35-01 ELECTRIC0000 10,207 8,9210201-1104-452.36-03 AUTO EQUIPMENT R&M7,857000000201-1104-452.39-01 REFNDS,AWARDS,INDEMNITIES10000000201-1104-452.39-89 CONTRACT SERVICES/CHARGES369-000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES754,682 734,662 632,909 632,909 643,116 641,830 670,654------------ ------------ ------------ ------------ ------------ ------------ ------------** POTAWATOMI ZOO819,984 801,960 704,464 704,464 682,854 676,196 700,000Fund 201 - Parks & RecreationCity of South BendExpenditures170 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1106-452.23-99 OTHER R&M SUPPLIES86075075000750------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES86075075000750201-1106-452.31-70 ADM FEE ALLOCATION1,623 1,728 1,734 1,734 1,099942 1,692LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION #11,692ADMINISTRATIVE FEE1,692201-1106-452.32-05 OTHER COMM/TRANS690495624003300201-1106-452.35-01 ELECTRIC126126 7,000 7,0007363200LEVEL TEXTTEXT AMT02 BUILDING AND NOTRE DAME COMPUTER POD200200201-1106-452.35-02 GAS19,831 14,513 20,000 20,000 13,977 13,931 24,000LEVEL TEXTTEXT AMT02 HEATING FOR YEAR24,00024,000201-1106-452.35-03 TRASH REMOVAL2,206 2,223 2,300 2,300 1,387 1,190 2,300201-1106-452.36-01 BUILDING R&M000 6,96400 2,000LEVEL TEXTTEXT AMT02 CLEANING SERVICES2,0002,000201-1106-452.39-12 SECURITY0006603300660LEVEL TEXTTEXT AMT02 SECURITY660660201-1106-452.39-30 GRANTS AND SUBSIDIES000 15,000 15,000 15,000 15,000LEVEL TEXTTEXT AMT02 2018 BOTANICAL SOCIETY OF SB SUBSIDY15,00015,000201-1106-452.39-89 CONTRACT SERVICES/CHARGES 20,177 16,828 22,0000000LEVEL TEXTTEXT AMT02 OTHER REPAIRS AND SERVICES TO MAINTAIN BUILDING7,0002018 CE 17 MAY 2017Fund 201 - Parks & RecreationCity of South BendExpenditures171 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures7,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES44,653 35,913 53,658 53,658 31,866 31,455 45,852------------ ------------ ------------ ------------ ------------ ------------ ------------** POTAWATOMI GREENHOUSE44,739 35,913 54,408 54,408 31,866 31,455 46,602Fund 201 - Parks & RecreationCity of South BendExpenditures172 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1108-452.10-01 REGULAR WAGES41,671 40,956 41,879 41,879 28,705 25,153 47,100LEVEL TEXTTEXT AMT02 1 FOREMAN V48,850ORDINANCE LESS ACTUAL = $5,2281,750-47,100201-1108-452.10-03 SEASONAL & INTERNS4,1410 15,0000000LEVEL TEXTTEXT AMT02 PART TIME GRAFFITI WORKER15,00015,000201-1108-452.10-09 PERMANENT PART-TIME22,154 20,1620 15,000 22,860 21,921 17,200LEVEL TEXTTEXT AMT02 PERMANENT PART TIME17,20017,200201-1108-452.11-01 FICA - REGULAR4,919 4,451 4,351 4,351 3,764 3,446 4,919LEVEL TEXTTEXT AMT02 SALARIES * 7.65%4,9194,919201-1108-452.11-04 PERF - REGULAR4,667 4,587 4,690 4,690 3,212 2,815 5,275LEVEL TEXTTEXT AMT02 REG SALARY * 11.2%5,2755,275201-1108-452.11-07 UNEMPLOYMENT COMP15579142142000LEVEL TEXTTEXT AMT02 UNEMPLOYMENT ADMIN FEE1400.25% OF PAYROLL2% WAGE INCREASE DIFF2142201-1108-452.11-08 HEALTH INSURANCE12,090 14,496 15,846 15,846 9,127 7,823 16,296LEVEL TEXTTEXT AMT02 GROUP HEALTH16,200LONG TERM DISABILITY9616,296201-1108-452.11-09 LIFE INSURANCE1201201201207060120LEVEL TEXTTEXT AMTFund 201 - Parks & RecreationCity of South BendExpenditures173 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 LIFE: 1 EMPLOYEES $5 X 24 PAY PERIODS120120201-1108-452.11-29 PARENTAL LEAVE000000161LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%161161------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES89,917 84,851 82,028 82,028 67,738 61,217 91,071201-1108-452.22-24 OTHER OPERATING SUPPLIES8,343 8,413 8,246 8,283 4,320 3,610 9,246LEVEL TEXTTEXT AMT02 SUPPLIES9,2469,246201-1108-452.22-99 GAS OTHER00 1,000 1,000000201-1108-452.23-20 SMALL TOOLS & EQUIPMENT950288 1,000 1,00000 1,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES9,293 8,701 10,246 10,283 4,320 3,610 10,246201-1108-452.31-70 ADM FEE ALLOCATION3,096 3,156 3,450 3,450 2,009 1,722 3,042LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION3,042ADMINISTRATIVE FEE3,042201-1108-452.32-04 TELEPHONE1,348862 2,100 2,100280240 2,100LEVEL TEXTTEXT AMT02 CEEL PHONE SERVICE2,1002,100------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES4,444 4,018 5,550 5,550 2,289 1,962 5,142------------ ------------ ------------ ------------ ------------ ------------ ------------** GRAFFITI REMOVAL103,654 97,570 97,824 97,861 74,347 66,789 106,459Fund 201 - Parks & RecreationCity of South BendExpenditures174 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1110-452.10-01 REGULAR WAGES00 478,959 478,959 237,579 201,814 624,597LEVEL TEXTTEXT AMT02 1 DIRECTOR OF DEVELOPMENT56,1002 DIRECTOR OF MKTG/PROMO (56,892 EA)113,7831 GRAPHIC DESIGNER48,8501 MANAGER - INTERACTIVE MARKETING48,8501 COMMUNICATIONS COORDINATOR28,1321 VOLUNTEER COORDINATOR48,8501 PROGRAM COORDINATOR48,8502 PROJECT MANAGER (54,345 EA)108,6891 SUPERVISOR - SPECIAL EVENTS48,850ADJUST TO ACTUAL19,877-MPAC93,520624,597201-1110-452.10-03 SEASONAL & INTERNS00 10,028 10,028000LEVEL TEXTTEXT AMT02 PART TIME - HELP FOR EVENTS10,02810,028201-1110-452.10-04 EXTRA AND OVERTIME00 1,601 1,60100 1,907LEVEL TEXTTEXT AMT02 MPAC1,9071,907201-1110-452.10-09 PERMANENT PART-TIME00 15,600 15,600 9,282 8,2880LEVEL TEXTTEXT AMT02 FULL TIME PART TIME MKTG STAFF (P&R)15,60015,600201-1110-452.11-01 FICA - REGULAR00 38,723 38,723 18,819 16,023 47,928LEVEL TEXTTEXT AMT02 SALARIES * 7.65%40,628MPAC7,30047,928201-1110-452.11-04 PERF - REGULAR00 53,823 53,823 26,609 22,603 69,955LEVEL TEXTTEXT AMT02 SALARIES * 11.2%59,267MPAC10,68869,955Fund 201 - Parks & RecreationCity of South BendExpenditures175 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1110-452.11-07 UNEMPLOYMENT COMP00 1,265 1,265000LEVEL TEXTTEXT AMT02 UNEMPLOYMENT COMP1,253WAGES OF APPROX. $501,200 X .00252% WAGE INCREASE DIFF121,265201-1110-452.11-08 HEALTH INSURANCE00 142,470 139,470 58,856 48,149 211,848LEVEL TEXTTEXT AMT02 11 FULL-TIME EMPLOYEESHEALTH INSURANCE, 16,200 EA178,200LTD, 96 EA1,056MPAC32,592211,848201-1110-452.11-09 LIFE INSURANCE00 1,200 1,200560460 1,560LEVEL TEXTTEXT AMT02 GROUP LIFE AT $120 X 11 EMPLOYEES1,320MPAC2401,560201-1110-452.11-12 AUTO ALLOWANCE000 3,000 1,750 1,5000201-1110-452.11-22 PARKING ALLOWANCE00 1,080 1,08000 1,080LEVEL TEXTTEXT AMT02 MPAC1,0801,080201-1110-452.11-24 CELL PHONE ALLOWANCE00 6,600 6,600 3,960 3,355 7,920LEVEL TEXTTEXT AMT02 CELL PHONE ALLOWANCE FOR 11 EMPLOYEES, 660/YR7,260MPAC6607,920201-1110-452.11-29 PARENTAL LEAVE000000 1,566LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%1,327MPAC2391,566------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES00 751,349 751,349 357,415 302,192 968,361Fund 201 - Parks & RecreationCity of South BendExpenditures176 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1110-452.21-02 STATIONERY & PRINTING00 3,751 3,751 1,364 1,364 3,751LEVEL TEXTTEXT AMT02 K63PRM600K3EEVE1,500MPAC1,6513,751201-1110-452.21-03 CENTRAL STORES - OFFICE0035035000350LEVEL TEXTTEXT AMT02 CENTRAL STORES350K63PRM -- 200MPAC -- 150350201-1110-452.21-04 OTHER OFFICE SUPPLIES00 1,500 1,500211211 2,900LEVEL TEXTTEXT AMT02 OFFICE SUPPLIES2,900K63PRM -- 1500MPAC -- 1,400K3EEVE -- 02,900201-1110-452.21-05 SMALL OFFICE EQUIPMENT00200200138138400LEVEL TEXTTEXT AMT02 MPAC200EXPERIENCE200400201-1110-452.22-23 RECREATION SUPPLIES00 2,785 2,785 1,827 1,819 10,785LEVEL TEXTTEXT AMT02 K3EEVE10,78510,785201-1110-452.22-24 OTHER OPERATING SUPPLIES004004001390 5,100LEVEL TEXTTEXT AMT02 OPERATION SUPPLIES5,100K63PRM -- 5000MPAC -- 1005,100------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES00 8,986 8,986 3,679 3,532 23,286Fund 201 - Parks & RecreationCity of South BendExpenditures177 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1110-452.31-70 ADM FEE ALLOCATION000000 29,656LEVEL TEXTTEXT AMT02 FIXED COST ALLOCATION - ADMIN FEE29,65629,656201-1110-452.31-73 PRINT SHOP ALLOCATION00 10,836 10,83600 10,836LEVEL TEXTTEXT AMT02 MPAC PRINT SHOP ALLOC10,83610,836201-1110-452.32-02 POSTAGE0030030000500LEVEL TEXTTEXT AMT02 K61ADM500500201-1110-452.32-03 TRAVEL00 2,400 2,000000LEVEL TEXTTEXT AMT02 K63PRM1,200K3EEVE1,2002,400201-1110-452.32-05 OTHER COMM/TRANS00 1,080 1,080000LEVEL TEXTTEXT AMT02 MPAC1,0801,080201-1110-452.32-22 TRAVEL - AIRFARE0050050000500LEVEL TEXTTEXT AMT02 TRAVEL AIRFARE:500K63PRM -- 500500201-1110-452.32-23 TRAVEL - HOTEL005005005010500LEVEL TEXTTEXT AMT02 TRAVEL HOTEL500K63PRM -- 500500201-1110-452.32-24 TRAVEL - MEALS003003002523300LEVEL TEXTTEXT AMTFund 201 - Parks & RecreationCity of South BendExpenditures178 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 TRAVEL MEALS300K63PRM -- 300300201-1110-452.32-25 TRAVEL - OTHER0001003290201-1110-452.33-01 PROMOTIONAL SUPPLIES00 4,700 4,700537537 4,700LEVEL TEXTTEXT AMT02 MPAC4,7004,700201-1110-452.33-02 PUBLICATION LEGAL NOTICE00030099990201-1110-452.33-03 PROMOTIONAL00 108,987 108,987 19,278 15,992 108,987LEVEL TEXTTEXT AMT02 PROMOTION108,987K63PRM -- $22,917MPAC -- $86,070K3EEVE -- $2,400108,987201-1110-452.36-04 COMPUTER EQUIP R&M00 2,550 2,55000 2,550LEVEL TEXTTEXT AMT02 MPAC2,5502,550201-1110-452.39-10 SUBSCRIPTIONS0092192100 1,000LEVEL TEXTTEXT AMT02 K63PRM1,0001,000201-1110-452.39-11 DUES & MEMBERSHIPS0058058000580LEVEL TEXTTEXT AMT02 OTHER SERVICES:580MPAC -- $580580201-1110-452.39-70 EDUCATION & TRAINING00 1,000 1,000305305 1,500LEVEL TEXTTEXT AMT02 EDUCATION & TRAINING:1,500K63PRM -- $1000MPAC -- $5001,500Fund 201 - Parks & RecreationCity of South BendExpenditures179 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1110-452.39-89 CONTRACT SERVICES/CHARGES00 57,099 57,099 3,873 3,780 58,179LEVEL TEXTTEXT AMT02 OTHER CONTRACTUAL SERVICES58,179K63PRM -- $8,564K3EEVE -- $48,53558,179201-1110-452.39-99 MILEAGE REIMBURSEMENT00 1,500 1,50000 1,500LEVEL TEXTTEXT AMT02 MILEAGE REIMB.:1,500K3EEVE -- $1,5001,500------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 193,253 193,253 24,877 20,724 221,288------------ ------------ ------------ ------------ ------------ ------------ ------------** MARKETING & EVENTS00 953,588 953,588 385,971 326,448 1,212,935Fund 201 - Parks & RecreationCity of South BendExpenditures180 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures201-1111-452.31-06 OTHER PROFESSIONAL SVCS000 1,000,00000 400,000LEVEL TEXTTEXT AMT02 EXPENDED FROM REGIONAL CITIES GRANT400,000400,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000 1,000,00000 400,000201-1111-452.42-01 LAND IMPROVEMENTS000 4,000,00000 1,600,000LEVEL TEXTTEXT AMT02 EXPENDED FROM REGIONAL CITIES REIMBURSEMENT GRANT 1,600,0001,600,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000 4,000,00000 1,600,000------------ ------------ ------------ ------------ ------------ ------------ ------------** REGIONAL CITIES GRANT000 5,000,00000 2,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARK DEPARTMENT FUND10,613,139 10,778,878 13,583,111 18,925,317 7,629,865 6,506,923 16,200,516Fund 201 - Parks & RecreationCity of South BendExpenditures181 City of South Bend, Indiana 2018 Budget Fund 203 - Recreation Nonreverting Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Charges for Services 944,718 934,733 1,365,787 568,947 1,392,436 1,392,436 1,396,436 1,396,436 1,446,000 26,649 2% Interest Earnings 5,004 8,093 6,000 4,112 6,000 6,000 6,000 6,000 6,000 - 0% Donations - - - - 120,000 120,000 120,000 120,000 120,000 120,000 - Other Income 58,416 576 10,000 1,356 5,000 5,000 5,000 5,000 5,000 (5,000) -50% Transfers In - - - - - - - - - - - Total Revenue 1,008,138 943,402 1,381,787 574,415 1,523,436 1,523,436 1,527,436 1,527,436 1,577,000 141,649 10% Expenditures by Type Personnel Salaries & Wages 473,660 351,612 523,295 146,000 444,463 445,217 445,985 446,574 447,171 (78,832) -15% Fringe Benefits 32,880 32,242 48,098 14,146 56,185 58,769 61,722 61,831 61,942 8,087 17% Total Personnel 506,540 383,854 571,393 160,146 500,648 503,986 507,708 508,405 509,112 (70,745) -12% Supplies 241,910 164,693 318,589 72,535 275,561 276,428 277,313 280,735 283,071 (43,028) -14% Services & Charges Professional Services - 102,210 126,674 47,209 142,090 142,234 142,380 144,516 146,684 15,416 12% Printing & Advertising 20,454 11,466 45,792 1,848 38,900 39,411 39,932 40,531 41,139 (6,892) -15% Education & Training 6,830 7,537 20,405 2,130 15,200 15,230 15,261 15,490 15,722 (5,205) -26% Travel 12,842 10,844 53,394 2,396 20,000 60,396 60,396 61,302 62,221 (33,394) -63% Repairs & Maintenance - - 7,700 500 13,500 13,500 13,500 13,703 13,908 5,800 75% Other Interfund Allocations 44,003 68,964 86,680 43,338 110,146 112,349 114,596 116,315 118,060 23,466 27% Grants & Subsidies - - - - 73,885 73,905 73,925 75,034 76,160 73,885 - Transfers Out 3,550 - - - - - - - - - - Other Services & Charges 164,213 164,129 254,056 73,546 282,300 284,074 285,884 290,142 294,465 28,244 11% Total Services & Charges 251,892 365,150 594,701 170,967 696,021 741,099 745,875 757,033 768,358 101,320 17% Capital Land - - - - - - - - - - - Land Improvements - - 85,000 - 125,000 125,000 125,000 125,000 125,000 40,000 47% Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - 41,299 30,000 - - - - - - (30,000) -100% Infrastructure - - - - - - - - - - - Total Capital - 41,299 115,000 - 125,000 125,000 125,000 125,000 125,000 10,000 9% Total Expenditures 1,000,342 571,142 1,028,290 243,502 1,597,230 1,646,513 1,655,896 1,671,173 1,685,542 68,292 7% Net Surplus / (Deficit)7,796 372,260 353,497 330,913 (73,794) (123,077) (128,460) (143,737) (108,542) Beginning Cash Balance 813,708 821,640 808,692 1,162,189 1,088,395 965,317 836,858 693,121 Cash Reserve Cash Adjustments 137 (385,208) - - - - - - Ending Cash Balance 821,640 808,692 1,162,189 1,088,395 965,317 836,858 693,121 584,578 Cash Reserves Target 250,086 238,749 399,921 399,308 411,628 413,974 417,793 421,386 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund comprises programs that are expected to recover most if not all of their costs through fee collections. Camps, leagues, fitness center, special events, and other activities. -Donations previously only accounted in Park Foundation account, will be transferred to 203 to track expenditures via city budget. -$73,000 in youth scholarship fund, approximately $35,000 more than 2017 (new line item, previously not accounted in this manner). Accounted for in Revenues and Expenses. -2017 saw major personnel increase due to $10.10 strategy, slightly reduced in 2018 due to better management of part-time staffing needs, increased reliance on volunteers. -Spending some reserves to restore atheletic and recreation equipment in neighborhood parks (soccer, tennis, basketball, pickelball, etc.). 182 City of South Bend, Indiana 2018 Budget Fund 203 - Recreation Nonreverting Accomplishments, Goals, KPI's 2017 Accomplishments & Outcomes - - - - - - - - - - 2018 Department Goals & Objectives and Linkage to City Results - - - - - - - - - - - - - - - - Key Performance Indicators (KPI's) Measure Type Long Term Goal 2016 Actual 2017 Estimated 2018 Target -Output 800,000 725,000 745,000 775,000 -Output $1.5 M $934K $1.25M $1.39 M -Outcome 20K/$500K 15K/$327K 18K/$420K 20K/$500K -Quality 5 4.8 4.8 4.8 -Outcome 40% 19% 28% 34% - - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - Program Attendance Fee Based Revenue Volunteer Hours / Value Continue to leverage the Experience Division for marketing, volunteers, fundraising, and placemaking. Customer Service Scores Cost Recovery Improve and Expand Impact of Best. Week. Ever. Promote, communicate and engage throughout all upcoming park improvements. The programs funded here have been self-sustaining for the year Youth scholarship programmed increased by $10,000 - fundraising efforts. Innagural Best. Week. Ever. celebration major city-wide success: ~50,000 attendees, $115K budget (privately fundraised) Working to translate all program guides, websites and forms to be avaialble in Spanish. Lifeguards & part-time employees now on "WhenIWork" software, making schedule adjustments and shift modifications much easier Ball field rentals now available online, saving staff time and improving the user experience East Race open for longer season MADE program had record attendance, received "Best In State" program award from IPRA Director of Business Operations to improve customer experience and business models (starts September 2017) Experience division recreating collateral and image for entire department Increased reliance on volunteers Continue to lean on empowerment model, as opposed to strictly programming model Acquisition of Mobile Recreation Vehicle to impact and reach more of the community in each neighborhood. 183 City of South Bend, Indiana 2018 Budget Fund 203 - Recreation Nonreverting Staffing (Full-Time Employees only) 2017 2018 2016 Amended 06/30/17 Proposed Forecast Position (* New title or additional position)Actual Budget Actual Budget 2019 2020 2021 2022 Non-Bargaining Fitness Supervisor 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Total Non-Bargaining 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Bargaining Total Bargaining - - - - - - - - Total Full-Time Employees 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Explain Significant Staffing Changes Below: 184 City of South Bend, Indiana2018 BudgetFund 203 - Recreation NonrevertingFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalProject CapitalCash125,000 - - - - 125,000 Total Project Capital125,000 - - - - 125,000 Minimum Thresholds:Total Capital125,000 - - - - 125,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:Projects to be named and completed within 2018.185 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueRECREATION-NONREVERTING203-1103-347.01-35 FOOD SALES41,390 24,646 43,125 43,125 26,784 15,269 42,000LEVEL TEXTTEXT AMT02 ATHLETICS29,500PROGRAMS12,50042,000203-1103-347.01-37 NON-ALCOHOLIC BEVERAGES 23,050 13,088 31,875 31,875 13,896 7,263 39,000LEVEL TEXTTEXT AMT02 ATHLETICS26,500PROGRAMS12,50039,000203-1103-347.01-90 SPECIAL EVENTS REVENUE880,082 896,986 1,290,787 1,290,787 529,697 546,382 1,250,436LEVEL TEXTTEXT AMT02 AQUATICS20,880ATHLETICS580,011CENTERS277,295REC ADMINISTRATION8,400PROGRAMS290,965DISCOUNTED FEES72,885THESE PROGRAMS OFFER DISCOUNTED FEES TO QUALIFIEDPARTICIPANTS. REVENUE IS OFFSET BY EXPENDITURE TOGRANTS/SUBSIDIES1,250,436203-1103-347.99-00 CASH OVER/SHORT196130094320------------ ------------ ------------ ------------ ------------ ------------ ------------*944,718 934,733 1,365,787 1,365,787 570,471 568,947 1,331,436203-1103-360.00-00 MISCELLANEOUS REVENUE58,41660 10,000 10,00000 5,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS REVENUES5,0005,000------------ ------------ ------------ ------------ ------------ ------------ ------------*58,41660 10,000 10,00000 5,000203-1103-361.00-00 INTEREST EARNINGS5,004 8,093 6,000 6,000 5,381 4,112 6,000LEVEL TEXTTEXT AMT02 INTEREST EARNINGS ON FUND BALANCES6,0006,000Fund 203 - Park NonrevertingCity of South BendRevenue186 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue------------ ------------ ------------ ------------ ------------ ------------ ------------*5,004 8,093 6,000 6,000 5,381 4,112 6,000203-1103-380.10-99 MISC. REIMBURSEMENTS051600119 1,3560------------ ------------ ------------ ------------ ------------ ------------ ------------*051600119 1,3560------------ ------------ ------------ ------------ ------------ ------------ ------------** RECREATION1,008,138 943,402 1,381,787 1,381,787 575,971 574,415 1,342,436Fund 203 - Park NonrevertingCity of South BendRevenue187 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue203-1110-347.01-90 SPECIAL EVENTS REVENUE0000 62,0200 61,000LEVEL TEXTTEXT AMT02 DADDY DAUGHTER 201835,500MOM SON 201815,500KIDS TRIATHLON10,000INCLUDES $1,000 IN REVENUE FOR DISCOUNTED DANCETICKETS TO ELIGIBLE PARTICIPANTS61,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0000 62,0200 61,000203-1110-367.00-00 DONATION PRIVATE SOURCES0000 43,0000 120,000LEVEL TEXTTEXT AMT02 BEST WEEK EVER, 2018120,000120,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0000 43,0000 120,000------------ ------------ ------------ ------------ ------------ ------------ ------------** MARKETING & EVENTS0000 105,0200 181,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** RECREATION-NONREVERTING1,008,138 943,402 1,381,787 1,381,787 680,991 574,415 1,523,436Fund 203 - Park NonrevertingCity of South BendRevenue188 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresRECREATION-NONREVERTING203-1103-452.10-01 REGULAR WAGES36,643 36,153 44,552 44,552 23,868 21,177 35,685LEVEL TEXTTEXT AMT02 1 - FITNESS SUPERVISOR45,443ADJ TO ACTUAL9,758-35,685203-1103-452.10-03 SEASONAL & INTERNS124,183 125,371 203,324 201,324 61,297 32,357 196,591LEVEL TEXTTEXT AMT02 PART TIME EMPLOYEES FOR SELF FUNDED RECREATIONAQUATICS5,092ATHLETICS53,044CENTERS10,543MANAGEMENT2,000PROGRAMS125,912196,591203-1103-452.10-04 EXTRA AND OVERTIME22422905004294290203-1103-452.10-05 TEMPORARY SERVICES137,804 14,443 3,210 1,020000203-1103-452.10-09 PERMANENT PART-TIME174,806 175,416 272,209 271,709 105,031 92,037 210,187LEVEL TEXTTEXT AMT02 ATHLETIC PROGRAMS182,634YOUTH/ADULT PROGRAMS27,553210,187203-1103-452.11-01 FICA - REGULAR25,713 25,918 40,032 39,878 14,648 11,229 33,848LEVEL TEXTTEXT AMT02 ALL SALARIES X 7.65%33,84833,848203-1103-452.11-04 PERF - REGULAR4,087 4,017 4,990 4,990 2,331 2,030 3,997LEVEL TEXTTEXT AMT02 REG SALARIES * 11.2%3,9973,997203-1103-452.11-07 UNEMPLOYMENT COMP1,310531 1,300 1,300000LEVEL TEXTTEXT AMT02 UNEMP COMP NOT USED IN 2018 - REPLACED BYPARENTAL LEAVE (11-29)203-1103-452.11-08 HEALTH INSURANCE1,650 1,656 1,656 1,656893828 16,296LEVEL TEXTTEXT AMTFund 203 - Recreation NonrevertingCity of South BendExpenditures189 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 GROUP HEALTH 201816,200LTD9616,296203-1103-452.11-09 LIFE INSURANCE1201201201206560120LEVEL TEXTTEXT AMT02 LIFE INS: 1 EMPLOYEE $5 X 24 PAY PERIODS120120203-1103-452.11-24 CELL PHONE ALLOWANCE000000660LEVEL TEXTTEXT AMT02 ATHLETICS, 1 PHONE660660203-1103-452.11-29 PARENTAL LEAVE000000 1,106LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%1,1061,106------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES506,540 383,854 571,393 567,049 208,562 160,146 498,490203-1103-452.21-02 STATIONERY & PRINTING19,595726 22,102 21,0776161 3,102LEVEL TEXTTEXT AMT02 ATHLETICS110CENTERS300PROGRAMS2,6923,102203-1103-452.21-03 CENTRAL STORES - OFFICE0155 2,000 2,00000 2,000LEVEL TEXTTEXT AMT02 ATHLETICS2,0002,000203-1103-452.21-04 OTHER OFFICE SUPPLIES0121 1,425 1,30055 1,300LEVEL TEXTTEXT AMT02 ATHLETICS1,000CENTERS3001,300203-1103-452.21-05 SMALL OFFICE EQUIPMENT4,294700 1,500 1,5002810 1,500LEVEL TEXTTEXT AMTFund 203 - Recreation NonrevertingCity of South BendExpenditures190 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 ATHLETICS1,5001,500203-1103-452.22-05 UNIFORMS462727 4,200 4,20032459 5,815LEVEL TEXTTEXT AMT02 ATHLETICS2,040CENTERS125MANAGEMENT1,000PROGRAMS2,6505,815203-1103-452.22-20 C.S. - MEDICAL/SAFETY00 2,514 2,514000203-1103-452.22-23 RECREATION SUPPLIES140,317 117,171 156,397 122,400 67,671 56,404 123,879LEVEL TEXTTEXT AMT02 ATHLETICS55,054CENTERS34,950MANAGEMENT4,500PROGRAMS29,375123,879203-1103-452.22-24 OTHER OPERATING SUPPLIES7,643 28,841 72,500 73,736 6,594 5,770 50,500LEVEL TEXTTEXT AMT02 ATHLETICS43,500CENTERS4,000PROGRAMS3,00050,500203-1103-452.22-29 INVENTORY "FOR SALE"3,498 2,149 7,000 7,038 3,319 2,335 3,000LEVEL TEXTTEXT AMT02 ATHLETIC - INVENTORY ITEMS FOR SALE (FITNESS)3,0003,000203-1103-452.22-30 CONCESSIONS INVENTORY65,986 14,029 51,600 51,834 9,444 6,839 41,100LEVEL TEXTTEXT AMT02 ATHLETICS27,500PROGRAMS13,60041,100203-1103-452.23-99 OTHER R&M SUPPLIES115744004001401400------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES241,910 164,693 321,638 287,999 87,839 71,611 232,196203-1103-452.31-06 OTHER PROFESSIONAL SVCS0 102,210 126,674 121,674 70,816 46,690 134,900Fund 203 - Recreation NonrevertingCity of South BendExpenditures191 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 AQUATICS13,309ATHLETICS106,971CENTERS1,120MANAGEMENT1,000PROGRAMS12,500134,900203-1103-452.31-70 ADM FEE ALLOCATION44,003 49,752 50,015 50,015 29,176 25,008 53,289LEVEL TEXTTEXT AMT02 2018 ALLOCATION53,289ADMINISTRATIVE FEE53,289203-1103-452.31-73 PRINT SHOP ALLOCATION0 19,212 36,665 36,665 21,385 18,330 56,857LEVEL TEXTTEXT AMT02 ALLOCATION #5- PRINTSHOP56,85756,857203-1103-452.32-02 POSTAGE1314 2,87523400184LEVEL TEXTTEXT AMT02 CENTERS184184203-1103-452.32-21 TRAVEL - MILEAGE775000000203-1103-452.32-22 TRAVEL - AIRFARE3,583 1,757 19,500 17,500 2,672398 8,600LEVEL TEXTTEXT AMT02 ATHLETICS500CENTERS5,600MANAGEMENT2,000PROGRAMS5008,600203-1103-452.32-23 TRAVEL - HOTEL5,794 6,066 20,660 19,030 2,502 1,160 7,200LEVEL TEXTTEXT AMT02 AQUATICSATHLETICS300CENTERS5,000MANAGEMENT1,500PROGRAMS4007,200Fund 203 - Recreation NonrevertingCity of South BendExpenditures192 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures203-1103-452.32-24 TRAVEL - MEALS2,269 2,167 10,506 8,836616636 3,350LEVEL TEXTTEXT AMT02 AQUATICSATHLETICS300CENTERS1,950MANAGEMENT800PROGRAMS3003,350203-1103-452.32-25 TRAVEL - OTHER421854 2,728 2,700157202850LEVEL TEXTTEXT AMT02 AQUATICSATHLETICS350CENTERS400MANAGEMENT50PROGRAMS50850203-1103-452.33-03 PROMOTIONAL20,454 11,466 45,350 20,242 3,519 1,430 13,350LEVEL TEXTTEXT AMT02 ATHLETICS950CENTERS1,100MANAGEMENT2,000PROGRAMS9,30013,350203-1103-452.36-05 OTHER EQUIP R&M000 8,200 8,100500 13,500LEVEL TEXTTEXT AMT02 ATHLETICS13,50013,500203-1103-452.39-01 REFNDS,AWARDS,INDEMNITIES 23,726 12,868 10,000 10,000 8,174 7,114 10,000LEVEL TEXTTEXT AMT02 MANAGEMENT10,00010,000203-1103-452.39-10 SUBSCRIPTIONS4,959 4,9130 2,200 2,028 2,02850LEVEL TEXTTEXT AMT02 CENTERS5050203-1103-452.39-11 DUES & MEMBERSHIPS0 1,201 10,450 10,760435435 8,635Fund 203 - Recreation NonrevertingCity of South BendExpenditures193 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 AQUATICS700ATHLETICS4,860CENTERS1,680MANAGEMENT610PROGRAMS7858,635203-1103-452.39-22 LICENSES-PARK DEPARTMENT0003503503500203-1103-452.39-30 GRANTS AND SUBSIDIES000000 72,885LEVEL TEXTTEXT AMT02 VPA OFFERS DISCOUNTED FEES TO ELIGIBLE GROUPSTHIS IS THE DIFFERENCE BETWEEN FULL PRICE ANDDISCOUNTED PRICEAQUATICS3,800ATHLETICS17,550CENTERS39,525PROGRAMS12,01072,885203-1103-452.39-70 EDUCATION & TRAINING6,830 7,537 15,628 15,027 1,425 2,130 13,700LEVEL TEXTTEXT AMT02 AQUATICSATHLETICS1,300CENTERS6,700MANAGEMENT2,200PROGRAMS3,50013,700203-1103-452.39-89 CONTRACT SERVICES/CHARGES 135,397 144,397 222,185 159,554 85,974 50,507 167,374LEVEL TEXTTEXT AMT02 ATHLETICS40,444CENTERS86,906MANAGEMENT10,200PROGRAMS29,824167,374203-1103-452.39-99 MILEAGE REIMBURSEMENT0746 5,340 5,34000 5,340LEVEL TEXTTEXT AMT02 ATHLETIC300PROGRAMS5,0405,340Fund 203 - Recreation NonrevertingCity of South BendExpenditures194 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES248,342 365,150 578,576 488,327 237,329 156,917 570,064203-1103-452.42-01 LAND IMPROVEMENTS00 85,000 85,00000 125,000LEVEL TEXTTEXT AMT02 CAPITAL PROJECTS125,000125,000203-1103-452.43-07 PARK EQUIPMENT0 41,299 30,000 30,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL0 41,299 115,000 115,00000 125,000203-1103-452.50-02 INTER-FUND OPER. TRANSFRS 3,550000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES3,550000000------------ ------------ ------------ ------------ ------------ ------------ ------------** RECREATION1,000,342 954,996 1,586,607 1,458,375 533,730 388,675 1,425,750Fund 203 - Recreation NonrevertingCity of South BendExpenditures195 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures203-1110-452.10-03 SEASONAL & INTERNS000 2,00000 2,000LEVEL TEXTTEXT AMT02 INTERNS & SEASONAL2,0002,000203-1110-452.10-05 TEMPORARY SERVICES000 2,190000203-1110-452.11-01 FICA - REGULAR00015400153LEVEL TEXTTEXT AMT02 ALL SALARIES * 7.65%153153203-1110-452.11-29 PARENTAL LEAVE0000005LEVEL TEXTTEXT AMT02 ALL SALARIES * 0.25%55------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES000 4,34400 2,158203-1110-452.21-02 STATIONERY & PRINTING000 1,02500 1,000LEVEL TEXTTEXT AMT02 STATIONERY & PRINTING1,0001,000203-1110-452.21-04 OTHER OFFICE SUPPLIES00012500225LEVEL TEXTTEXT AMT02 OTHER OFFICE SUPPLIES225225203-1110-452.22-23 RECREATION SUPPLIES000 29,440 9,073924 42,140LEVEL TEXTTEXT AMT02 RECREATIONAL SUPPLIES42,14042,140------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES000 30,590 9,073924 43,365203-1110-452.31-06 OTHER PROFESSIONAL SVCS000 5,000519519 7,190LEVEL TEXTTEXT AMT02 CONTRACTED SERVICES5,000TEMP LABOR SERVICES2,190Fund 203 - Recreation NonrevertingCity of South BendExpenditures196 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures7,190203-1110-452.32-02 POSTAGE000 2,64100 2,400LEVEL TEXTTEXT AMT02 POSTAGE2,4002,400203-1110-452.32-22 TRAVEL - AIRFARE000 2,000000203-1110-452.32-23 TRAVEL - HOTEL000 1,63031600203-1110-452.32-24 TRAVEL - MEALS000 1,6702000203-1110-452.32-25 TRAVEL - OTHER000284500203-1110-452.33-03 PROMOTIONAL000 25,550 2,666418 25,550LEVEL TEXTTEXT AMT02 PROMOTIONAL / MARKETING25,55025,550203-1110-452.39-01 REFNDS,AWARDS,INDEMNITIES00001000 2,000LEVEL TEXTTEXT AMT02 REIMBURSEMENTS FOR TICKETS SOLD TO PATRONS2,0002,000203-1110-452.39-11 DUES & MEMBERSHIPS000285000203-1110-452.39-30 GRANTS AND SUBSIDIES000000 1,000LEVEL TEXTTEXT AMT02 DIFFERENCE BETWEEN TICKETS SOLD AT FULL PRICE AND1,000DISCOUNTS OFFERED TO ELIGIBLE PARTICIPANTS1,000203-1110-452.39-70 EDUCATION & TRAINING000 2,3287050 1,500LEVEL TEXTTEXT AMT02 TRAINING FOR EXPERIENCE EMPLOYEES1,5001,500203-1110-452.39-89 CONTRACT SERVICES/CHARGES000 65,242 29,958 13,112 86,317LEVEL TEXTTEXT AMT02 MISC CONTRACT SERVICES86,317INCLUDES TALENT, ADDITIONAL SETUP SERVICES, MKTGSERVICES86,317------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000 106,374 34,329 14,049 125,957Fund 203 - Recreation NonrevertingCity of South BendExpenditures197 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures------------ ------------ ------------ ------------ ------------ ------------ ------------** MARKETING & EVENTS000 141,308 43,402 14,973 171,480------------ ------------ ------------ ------------ ------------ ------------ ------------*** RECREATION-NONREVERTING1,000,342 954,996 1,586,607 1,599,683 577,132 403,648 1,597,230Fund 203 - Recreation NonrevertingCity of South BendExpenditures198 City of South Bend, Indiana 2018 Budget Fund 271 - Eastrace Waterway Fund Type Special Revenue Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Charges for Services - - - - - - - - - - - Interest Earnings 21 12 22 6 - - - - - (22) -100% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 21 12 22 6 - - - - - (22) -100% Expenditures by Type Supplies 3,998 - 1,367 - - - - - - (1,367) -100% Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - - - - - - - - - - Capital - - - - - - - - - - - Total Expenditures 3,998 - 1,367 - - - - - - (1,367) -100% Net Surplus / (Deficit)(3,977) 12 (1,345) 6 - - - - - Beginning Cash Balance 5,307 1,333 1,345 - - - - - Cash Reserve Cash Adjustments 3 (0) - - - - - - Ending Cash Balance 1,333 1,345 - - - - - - Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was originally dedicated to accounting for revenues and expenses from East Race Waterway events and races. In recent years, there have been no races. Budgeted expenditures are for East Race equipment. This fund will be closed in 2017. 199 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueEASTRACE WATERWAY271-0000-361.00-00 INTEREST EARNINGS2112022860------------ ------------ ------------ ------------ ------------ ------------ ------------*2112022860------------ ------------ ------------ ------------ ------------ ------------ ------------** EASTRACE WATERWAY2112022860------------ ------------ ------------ ------------ ------------ ------------ ------------*** EASTRACE WATERWAY2112022860Fund 271 - Eastrace WaterwayCity of South BendRevenue200 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresEASTRACE WATERWAY271-1101-452.22-24 OTHER OPERATING SUPPLIES3,9980 1,367 1,367 1,35300------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES3,9980 1,367 1,367 1,35300------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE3,9980 1,367 1,367 1,35300------------ ------------ ------------ ------------ ------------ ------------ ------------*** EASTRACE WATERWAY3,9980 1,367 1,367 1,35300Fund 271 - Eastrace WaterwayCity of South BendExpenditures201 City of South Bend, Indiana 2018 Budget Fund 401 - Coveleski Stadium Capital Fund Type Capital Project Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Charges for Services 41,853 40,789 40,000 - 43,500 43,500 43,500 43,500 43,500 3,500 9% Interest Earnings 250 666 900 393 750 750 750 750 750 (150) -17% Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 42,103 41,455 40,900 393 44,250 44,250 44,250 44,250 44,250 3,350 8% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - 33,475 30,000 13,111 80,000 30,000 30,000 30,000 30,000 50,000 167% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - 33,475 30,000 13,111 80,000 30,000 30,000 30,000 30,000 50,000 167% Capital - - - - 65,000 - - 40,000 - 65,000 - Total Expenditures - 33,475 30,000 13,111 145,000 30,000 30,000 70,000 30,000 115,000 383% Net Surplus / (Deficit)42,103 7,980 10,900 (12,719) (100,750) 14,250 14,250 (25,750) 14,250 Beginning Cash Balance 40,407 82,428 90,376 101,276 526 14,776 29,026 3,276 Cash Reserve Cash Adjustments (82) (33) - - - - - - Ending Cash Balance 82,428 90,376 101,276 526 14,776 29,026 3,276 17,526 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund is used for minor capital improvements for Four Winds Field at Coveleski Stadium. Revenues are in the form of compensation received by the City based on stadium attendance. Painting, landscaping, and mechanical upgrades. 202 City of South Bend, Indiana2018 BudgetFund 401 - Coveleski Stadium CapitalFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalExterior irrigationCash50,000 - - - - 50,000 Provide water to landscaping around the stadiumLandscapingCash15,000 - - - - 15,000 Improve aestheticsOther projectsCash- - - 40,000 - 40,000 To be determinedTotal Project Capital65,000 - - 40,000 - 105,000 Minimum Thresholds:Total Capital65,000 - - 40,000 - 105,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:203 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueCOVELESKI STADIUM401-0000-347.01-40 LEASE OF STADIUM41,853 40,789 40,000 40,00000 43,500LEVEL TEXTTEXT AMT02 REVENUE FROM ATTENDANCE BONUS43,500BASED ON ATTENDANCE OF 174,000 X 0.25 PER SEAT43,500------------ ------------ ------------ ------------ ------------ ------------ ------------*41,853 40,789 40,000 40,00000 43,500401-0000-361.00-00 INTEREST EARNINGS250666200900492393750LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNED ON FUND BALANCES750750------------ ------------ ------------ ------------ ------------ ------------ ------------*250666200900492393750------------ ------------ ------------ ------------ ------------ ------------ ------------** COVELESKI STADIUM42,103 41,455 40,200 40,900492393 44,250------------ ------------ ------------ ------------ ------------ ------------ ------------*** COVELESKI STADIUM42,103 41,455 40,200 40,900492393 44,250Fund 401 - Coveleski StadiumCity of South BendRevenue204 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresCOVELESKI STADIUM401-0401-452.36-01 BUILDING R&M00 30,0000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 30,0000000------------ ------------ ------------ ------------ ------------ ------------ ------------** CONTROLLER00 30,0000000Fund 401 - Coveleski StadiumCity of South BendExpenditures205 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures401-1101-452.36-01 BUILDING R&M0 33,4750 30,000 14,889 13,111 80,000LEVEL TEXTTEXT AMT02 REPAIRS MADE TO COVELESKI STADIUM30,000CONCOURSE PAINTING50,00080,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 33,4750 30,000 14,889 13,111 80,000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE0 33,4750 30,000 14,889 13,111 80,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** COVELESKI STADIUM0 33,475 30,000 30,000 14,889 13,111 80,000Fund 401 - Coveleski StadiumCity of South BendExpenditures206 City of South Bend, Indiana 2018 Budget Fund 403 - Zoo Endowment Fund Type Capital Project Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings 284 453 200 151 400 400 400 400 400 200 100% Donations - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 284 453 200 151 400 400 400 400 400 200 100% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - - - - - - - - - - Capital Land - - - - - - - - - - - Land Improvements - - - 1,049 - - - - - - - Buildings & Bldg Improve.- - 49,688 49,000 - - - - - (49,688) -100% Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure - - - - - - - - - - - Total Capital - - 49,688 50,049 - - - - - (49,688) -100% Total Expenditures - - 49,688 50,049 - - - - - (49,688) -100% Net Surplus / (Deficit)284 453 (49,488) (49,898) 400 400 400 400 400 Beginning Cash Balance 49,109 49,370 49,811 323 723 1,123 1,523 1,923 Cash Reserve Cash Adjustments (23) (13) - - - - - - Ending Cash Balance 49,370 49,811 323 723 1,123 1,523 1,923 2,323 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund accounts for donations dedicated to Potawatomi Zoo. 207 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueZOO ENDOWMENT403-0000-361.00-00 INTEREST EARNINGS284453200200151151400LEVEL TEXTTEXT AMT02 INTEREST EARNINGS ON FUND BALANCES400400------------ ------------ ------------ ------------ ------------ ------------ ------------*284453200200151151400------------ ------------ ------------ ------------ ------------ ------------ ------------** ZOO ENDOWMENT284453200200151151400------------ ------------ ------------ ------------ ------------ ------------ ------------*** ZOO ENDOWMENT284453200200151151400Fund 403 - Zoo EndowmentCity of South BendRevenue208 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresZOO ENDOWMENT403-1101-452.36-09 LAND IMPROVEMENTS0000 1,049 1,0490------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0000 1,049 1,0490403-1101-452.42-02 BUILDINGS00 49,688 49,688 49,000 49,0000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL00 49,688 49,688 49,000 49,0000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE00 49,688 49,688 50,049 50,0490------------ ------------ ------------ ------------ ------------ ------------ ------------*** ZOO ENDOWMENT00 49,688 49,688 50,049 50,0490Fund 403 - Zoo EndowmentCity of South BendExpenditures209 City of South Bend, Indiana 2018 Budget Fund 405 - Park Nonreverting Capital Fund Type Capital Project Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Charges for Services 7,613 5,167 26,000 3,601 17,100 17,100 17,100 17,100 17,100 (8,900) -34% Interest Earnings 2,508 3,347 4,000 844 1,500 1,500 1,500 1,500 1,500 (2,500) -63% Donations - - 100,000 50,000 - - - - - (100,000) -100% Other Income 4,250 - 22,000 4,000 22,000 22,000 22,000 22,000 22,000 - 0% Transfers In - - 287,850 - 80,000 80,000 80,000 80,000 80,000 (207,850) -72% Total Revenue 14,371 8,514 439,850 58,445 120,600 120,600 120,600 120,600 120,600 (319,250) -73% Expenditures by Type Supplies 33,541 62,966 92,326 47,569 51,000 51,000 51,000 51,000 51,000 (41,326) -45% Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges 9,772 81,383 63,288 4,954 54,000 54,000 54,000 54,000 54,000 (9,288) -15% Total Services & Charges 9,772 81,383 63,288 4,954 54,000 54,000 54,000 54,000 54,000 (9,288) -15% Capital Land - - - - - - - - - - - Land Improvements - - 100,000 27,566 - - - - - (100,000) -100% Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - 160,000 20,829 - - - - - (160,000) -100% Machinery & Equipment 22,499 23,181 97,410 64,830 76,000 - - - - (21,410) -22% Infrastructure - - - - - - - - - - - Total Capital 22,499 23,181 357,410 113,224 76,000 - - - - (281,410) -79% Total Expenditures 65,812 167,530 513,024 165,748 181,000 105,000 105,000 105,000 105,000 (332,024) -65% Net Surplus / (Deficit)(51,441) (159,016) (73,174) (107,303) (60,400) 15,600 15,600 15,600 15,600 Beginning Cash Balance 520,605 469,009 310,163 236,989 176,589 192,189 207,789 223,389 Cash Reserve Cash Adjustments (155) 170 - - - - - - Ending Cash Balance 469,009 310,163 236,989 176,589 192,189 207,789 223,389 238,989 Cash Reserves Target 16,453 41,882 128,256 45,250 26,250 26,250 26,250 26,250 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This is a capital fund that accounts for revenues collected and expenses for specific purposes or locations. These locations are Potawatomi and Rum Village Picnic Areas, the East Race, Golf Courses, Forestry, and Howard Park Ice Rink. Currently, this fund is used for more than capital expenditures. Neighborhood park pavilion improvements at Kennedy and LaSalle. 210 City of South Bend, Indiana2018 BudgetFund 405 - Park Nonreverting CapitalFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalPavilion at LaSalle ParkCash35,000 - - - - 35,000 Forestry equipmentCash16,000 - - - - 16,000 Kennedy PavilionCash25,000 - - - - 25,000 Total Project Capital76,000 - - - - 76,000 Minimum Thresholds:Total Capital76,000 - - - - 76,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:211 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenuePARK NONREVERTING CAPITAL405-0000-361.00-00 INTEREST EARNINGS2,508 3,347 4,000 4,000 1,012844 1,500LEVEL TEXTTEXT AMT02 INTEREST EARNINGS ON FUND BALANCES1,5001,500------------ ------------ ------------ ------------ ------------ ------------ ------------*2,508 3,347 4,000 4,000 1,012844 1,500------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK NONREVERTING CAPITAL2,508 3,347 4,000 4,000 1,012844 1,500Fund 405 - Park Nonreverting CapitalCity of South BendRevenue212 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue405-1101-347.01-11 PICNIC AREA NONREVERTING4,873 5,167 6,000 6,000 4,459 3,601 3,900LEVEL TEXTTEXT AMT02 BASED ON $3.00 PER RENTAL OF PICNIC AREA +$10.00 PER RENTAL OF PAVILIONS275 PAVILION RENTALS, ROUNDED2,800365 PICNIC AREA RENTALS, ROUNDED1,1003,900405-1101-347.01-71 SITE MOWING2,7400 20,000 20,00000 13,200LEVEL TEXTTEXT AMT02 CAPITAL RECOVERY FROM MOWING FEES13,200BASED ON $3.40 X NUMBER OF ABATEMENTS13,200------------ ------------ ------------ ------------ ------------ ------------ ------------*7,613 5,167 26,000 26,000 4,459 3,601 17,100405-1101-360.00-00 MISCELLANEOUS REVENUE4,0000 22,000 22,000 4,000 4,000 22,000LEVEL TEXTTEXT AMT02 NON-REVERTING MAINTENANCE FEES10,000MISCELLANEOUS FORESTRY REVENUE12,00022,000------------ ------------ ------------ ------------ ------------ ------------ ------------*4,0000 22,000 22,000 4,000 4,000 22,000405-1101-367.00-00 DONATION PRIVATE SOURCES000 100,000 50,000 50,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 100,000 50,000 50,0000405-1101-392.00-00 INTERFUND OPER. TRANSFER000 194,850000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 194,850000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE11,613 5,167 48,000 342,850 58,459 57,601 39,100Fund 405 - Park Nonreverting CapitalCity of South BendRevenue213 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue405-1102-360.00-00 MISCELLANEOUS REVENUE250000000LEVEL TEXTTEXT AMT02 INCLUDED IN 405-1102-347.01-21------------ ------------ ------------ ------------ ------------ ------------ ------------*250000000405-1102-392.00-00 INTERFUND OPER. TRANSFER00 80,000 80,00000 80,000LEVEL TEXTTEXT AMT02 GOLF NON-REVERTING FEES-TRNSFER FROM PARKS FUND80,000TRANSFER FROM 201-1102-452.50-02(FORMERLY DEPOSITED IN ACCT #405-1102-347.01-21)80,000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 80,000 80,00000 80,000------------ ------------ ------------ ------------ ------------ ------------ ------------** GOLF COURSES2500 80,000 80,00000 80,000Fund 405 - Park Nonreverting CapitalCity of South BendRevenue214 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue405-1103-392.00-00 INTERFUND OPER. TRANSFER00 13,000 13,000000LEVEL TEXTTEXT AMT02 NON-REVERTING FEES - TRSFR FROM FUND 201 - E. RACE8,800TRANSFERS FROM ACCT #201-1103-452.50-028,800------------ ------------ ------------ ------------ ------------ ------------ ------------*00 13,000 13,000000------------ ------------ ------------ ------------ ------------ ------------ ------------** RECREATION00 13,000 13,000000------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARK NONREVERTING CAPITAL14,371 8,514 145,000 439,850 59,471 58,445 120,600Fund 405 - Park Nonreverting CapitalCity of South BendRevenue215 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresPARK NONREVERTING CAPITAL405-1101-452.22-24 OTHER OPERATING SUPPLIES8,173 13,762 8,000 8,000 7,054 6,694 8,000405-1101-452.22-25 PLANTS CHEM. SEED & FERT. 8,411 5,141 8,000 8,000 6,135 6,135 8,000405-1101-452.23-21 C.S. SMALL TOOLS & EQUIP000 25,000 10,038 10,0380------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES16,584 18,903 16,000 41,000 23,227 22,867 16,000405-1101-452.36-09 LAND IMPROVEMENTS000 100,000 89,074 27,5660405-1101-452.39-01 REFNDS,AWARDS,INDEMNITIES120000000405-1101-452.39-89 CONTRACT SERVICES/CHARGES0 21,60300000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES120 21,6030 100,000 89,074 27,5660405-1101-452.43-02 MOTOR EQUIPMENT000 160,000 71,829 20,8290405-1101-452.43-03 OFFICE EQUIPMENT00000 51,0000405-1101-452.43-07 PARK EQUIPMENT00 16,000 16,00000 76,000LEVEL TEXTTEXT AMT02 FORESTRY EQUIPMENT16,000PAVILION AT LASALLE PARK35,000KENNEDY PAVILION25,00076,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL00 16,000 176,000 71,829 71,829 76,000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE16,704 40,506 32,000 317,000 184,130 122,262 92,000Fund 405 - Park Nonreverting CapitalCity of South BendExpenditures216 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures405-1102-452.22-24 OTHER OPERATING SUPPLIES4,105 38,162 35,000 46,831 23,915 23,915 35,000LEVEL TEXTTEXT AMT02 MATERIALS FOR BUILDING IMPROVEMENTS15,000REFURBISH COURSE CONDITIONS15,000EQUIPMENT PURCHASE5,00035,000405-1102-452.23-21 C.S. SMALL TOOLS & EQUIP000 2,0007887880405-1102-452.23-99 OTHER R&M SUPPLIES12,852000000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES16,957 38,162 35,000 48,831 24,703 24,703 35,000405-1102-452.39-89 CONTRACT SERVICES/CHARGES 9,652 50,801 34,000 39,622 4,954 4,954 34,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES9,652 50,801 34,000 39,622 4,954 4,954 34,000405-1102-452.43-07 PARK EQUIPMENT22,499 23,181 24,000 81,410 64,830 64,8300------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL22,499 23,181 24,000 81,410 64,830 64,8300------------ ------------ ------------ ------------ ------------ ------------ ------------** GOLF COURSES49,108 112,144 93,000 169,863 94,487 94,486 69,000Fund 405 - Park Nonreverting CapitalCity of South BendExpenditures217 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures405-1103-452.22-24 OTHER OPERATING SUPPLIES0 5,9010 2,495000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES0 5,9010 2,495000405-1103-452.39-89 CONTRACT SERVICES/CHARGES0 6,480 20,000 23,66600 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 6,480 20,000 23,66600 20,000------------ ------------ ------------ ------------ ------------ ------------ ------------** RECREATION0 12,381 20,000 26,16100 20,000Fund 405 - Park Nonreverting CapitalCity of South BendExpenditures218 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures405-1104-452.39-89 CONTRACT SERVICES/CHARGES0 2,49900000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 2,49900000------------ ------------ ------------ ------------ ------------ ------------ ------------** POTAWATOMI ZOO0 2,49900000------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARK NONREVERTING CAPITAL65,812 167,530 145,000 513,024 278,617 216,748 181,000Fund 405 - Park Nonreverting CapitalCity of South BendExpenditures219 City of South Bend, Indiana 2018 Budget Fund 730 - City Cemetery Fund Type Trust & Agency Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings 164 261 200 129 250 - - - - 50 25% Donations - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 164 261 200 129 250 - - - - 50 25% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - 6,000 - 25,000 - - - - 19,000 317% Total Services & Charges - - 6,000 - 25,000 - - - - 19,000 317% Capital - - - - - - - - - - - Total Expenditures - - 6,000 - 25,000 - - - - 19,000 317% Net Surplus / (Deficit)164 261 (5,800) 129 (24,750) - - - - Beginning Cash Balance 28,347 28,498 28,752 24,750 - - - - Cash Reserve Cash Adjustments (13) (7) 1,798 - - - - - Ending Cash Balance 28,498 28,752 24,750 - - - - - Cash Reserves Target - - 1,500 6,250 - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This trust fund is designated for expenses specifically for the City Cemetery. Revenue was originally derived from the sale of cemetery plots and burial expenses. There are few sites available for sale and most plots are occupied, resulting in little burial activity. This fund is managed by Venues Parks and Arts. $25,000 to be spent on headstone repair during 2018. 220 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueCITY CEMETERY TRUST FUND730-0000-361.00-00 INTEREST EARNINGS164261200200166129250LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNED ON FUND BALANCES250250------------ ------------ ------------ ------------ ------------ ------------ ------------*164261200200166129250------------ ------------ ------------ ------------ ------------ ------------ ------------** CITY CEMETERY TRUST FUND164261200200166129250------------ ------------ ------------ ------------ ------------ ------------ ------------*** CITY CEMETERY TRUST FUND164261200200166129250Fund 730 - City Cemetery FundCity of South BendRevenue221 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresCITY CEMETERY TRUST FUND730-0000-452.39-89 CONTRACT SERVICES/CHARGES00 6,000 6,00000 25,000LEVEL TEXTTEXT AMT02 CEMETERY IMPROVEMENTS25,00025,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 6,000 6,00000 25,000------------ ------------ ------------ ------------ ------------ ------------ ------------** CITY CEMETERY TRUST FUND00 6,000 6,00000 25,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** CITY CEMETERY TRUST FUND00 6,000 6,00000 25,000Fund 730 - City Cemetery FundCity of South BendExpenditures222 City of South Bend, Indiana 2018 Budget Fund 751 - Parks Bond Capital Fund Type Capital Project Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings - - 7,500 2,541 4,500 - - - - (3,000) -40% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue - - 7,500 2,541 4,500 - - - - (3,000) -40% Expenditures by Type Supplies - - 60,000 840 - - - - - (60,000) -100% Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Other Interfund Allocations - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Grants & Subsidies - - - - - - - - - - - Insurance - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - 200,000 - - - - - - (200,000) -100% Total Services & Charges - - 200,000 - - - - - - (200,000) -100% Capital Land - - - - - - - - - - - Land Improvements - - 2,590,000 75,207 1,504,500 - - - - (1,085,500) -42% Buildings & Bldg Improve.- - 500,000 380,538 1,500,000 - - - - 1,000,000 200% Motor Equipment - - - - - - - - - - - Machinery & Equipment - - 150,000 89,738 - - - - - (150,000) -100% Infrastructure - - - - - - - - - - - Total Capital - - 3,240,000 545,482 3,004,500 - - - - (235,500) -7% Total Expenditures - - 3,500,000 546,322 3,004,500 - - - - (495,500) -14% Net Surplus / (Deficit)- - (3,492,500) (543,782) (3,000,000) - - - - Beginning Cash Balance - - 4,337,199 3,000,000 - - - - Cash Reserve Cash Adjustments - - 2,155,301 - - - - - Ending Cash Balance - - 3,000,000 - - - - - Cash Reserves Target - - 3,000,000 - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants This fund is used to account for the bond proceeds and expenditures of the 2015 Parks/EDIT bond that is accounted for by US Bank in trustee accounts. The City submits pay requests for costs incurred under the bond to US Bank. This fund was established in 2017 to integrate these trustee accounts into the City's regular accounting system. The original bond was issued in 2015 for $5,605,000. Bond proceeds are spent down on parks projects. The unspent balance at December 31, 2017 will be re-appropriated in 2018 and will be used primarily for improvements at the Charles Black Center. Funds expected to fully spent in 2018. 223 City of South Bend, Indiana2018 BudgetFund 751 - Parks Bond CapitalFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement Capital Total Replacement Capital- - - - - - Project CapitalCharles Black CenterBond Proceeds 3,004,500 - - - - 3,004,500 Improvements at an important community centerTotal Project Capital3,004,500 - - - - 3,004,500 Minimum Thresholds:Total Capital3,004,500 - - - - 3,004,500 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:224 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenuePARKS BOND CAPITAL751-1101-361.00-00 INTEREST EARNINGS00 7,500 7,500 3,193 2,541 4,500LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNINGS4,5004,500------------ ------------ ------------ ------------ ------------ ------------ ------------*00 7,500 7,500 3,193 2,541 4,500------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE00 7,500 7,500 3,193 2,541 4,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARKS BOND CAPITAL00 7,500 7,500 3,193 2,541 4,500Fund 751 - Parks Bond CapitalCity of South BendRevenue225 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresPARKS BOND CAPITAL751-1101-452.22-24 OTHER OPERATING SUPPLIES000 50,0008408400751-1101-452.23-01 BUILDING MATERIALS000 10,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES000 60,0008408400751-1101-452.39-89 CONTRACT SERVICES/CHARGES000 200,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000 200,000000751-1101-452.42-01 LAND IMPROVEMENTS00 3,500,000 2,590,000 77,452 75,207 1,504,500LEVEL TEXTTEXT AMT02 PARKS IMPROVEMENTS - CHARLES BLACK CENTER1,504,5001,504,500751-1101-452.42-02 BUILDINGS000 500,000 380,538 380,538 1,500,000LEVEL TEXTTEXT AMT02 CHARLES BLACK CENTER1,500,0001,500,000751-1101-452.43-07 PARK EQUIPMENT000 150,000 89,738 89,7380LEVEL TEXTTEXT AMT02 PARKS EQUIPMENT------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL00 3,500,000 3,240,000 547,728 545,482 3,004,500------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE00 3,500,000 3,500,000 548,568 546,322 3,004,500------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARKS BOND CAPITAL00 3,500,000 3,500,000 548,568 546,322 3,004,500Fund 751 - Parks Bond CapitalCity of South BendExpenditures226 City of South Bend, Indiana 2018 Budget Fund 757 - Parks Bond Debt Service Fund Type City Debt Service Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings - - 1,000 457 800 1,000 1,100 1,200 1,300 (200) -20% Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - 390,482 194,232 379,107 382,732 381,032 374,182 372,257 (11,375) -3% Total Revenue - - 391,482 194,689 379,907 383,732 382,132 375,382 373,557 (11,575) -3% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Other Interfund Allocations - - - - - - - - - - - Debt Service Principal - - 215,000 110,000 210,000 220,000 225,000 225,000 230,000 (5,000) -2% Interest & Fees - - 176,482 88,566 170,107 163,732 157,132 150,382 143,557 (6,375) -4% Grants & Subsidies - - - - - - - - - - - Insurance - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - 391,482 198,566 380,107 383,732 382,132 375,382 373,557 (11,375) -3% Capital - - - - - - - - - - - Total Expenditures - - 391,482 198,566 380,107 383,732 382,132 375,382 373,557 (11,375) -3% Net Surplus / (Deficit)- - - (3,876) (200) - - - - Beginning Cash Balance - - 561,943 561,943 561,743 561,743 561,743 561,743 Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance - - 561,943 561,743 561,743 561,743 561,743 561,743 Cash Reserves Target - - 561,943 561,743 561,743 561,743 561,743 561,743 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 100% cash reserves per bond covenants This fund accounts for the receipt of monthly lease rental payments from the City's EDIT Fund (408) and the subsequent semi-annual payment of debt service principal and interest to the bondholders. The accounting records are maintained in trustee bank accounts. This fund was established in 2017 to integrate these trustee accounts into the City's regular accounting system. The par amount of the 2015 Parks/EDIT bond was $5,605,000 and the final payment is due August 1, 2035. The principal and interest payments are set forth in the 20 year debt amortization schedule with the first payment made on February 1, 2016 and the final payment on August 1, 2035. The bond requires semi- annual payments and the City EDIT Fund (408) transfers money into this fund on a monthly basis, as per the bond ordinance. 227 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenuePARKS BOND DEBT SERVICE757-1101-361.00-00 INTEREST EARNINGS00 1,000 1,000596457800LEVEL TEXTTEXT AMT02 INTEREST EARNED ON ESCROW ACCOUNTS800800------------ ------------ ------------ ------------ ------------ ------------ ------------*00 1,000 1,000596457800757-1101-392.00-00 INTERFUND OPER. TRANSFER00 390,482 390,482 194,232 194,232 379,107LEVEL TEXTTEXT AMT02 CITY CONTRIBUTIONS OF DEBT SERVICE AMOUNTS379,1072015 PARKS/EDIT BOND379,107------------ ------------ ------------ ------------ ------------ ------------ ------------*00 390,482 390,482 194,232 194,232 379,107------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE00 391,482 391,482 194,828 194,689 379,907------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARKS BOND DEBT SERVICE00 391,482 391,482 194,828 194,689 379,907Fund 757 - Parks Bond Debt ServiceCity of South BendRevenue228 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresPARKS BOND DEBT SERVICE757-1101-452.37-11 CAPITAL LEASE PRINCIPAL00 215,000 215,000 110,000 110,000 210,000LEVEL TEXTTEXT AMT02 DEBT SERVICE PRINIPAL PAID BY ESCROW2015 PARKS/EDIT BOND #141210,000210,000757-1101-452.37-12 CAPITAL LEASE INTEREST00 175,482 175,482 88,566 88,566 169,107LEVEL TEXTTEXT AMT02 DEBT INTEREST PAID THROUGH ESCROW:2015 PARKS/EDIT BOND #141169,107169,107757-1101-452.38-03 PAYING AGENT FEES00 1,000 1,00000 1,000LEVEL TEXTTEXT AMT02 PAYING AGENT FEES PAID THROUGH ESCROW1,0001,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 391,482 391,482 198,566 198,566 380,107------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE00 391,482 391,482 198,566 198,566 380,107------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARKS BOND DEBT SERVICE00 391,482 391,482 198,566 198,566 380,107Fund 757 - Parks Bond Debt ServiceCity of South BendExpenditures229 City of South Bend, Indiana 2018 Budget Fund 601 - Parking Garages Fund Type Enterprise Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Charges for Services 890,228 923,301 1,000,629 593,773 1,162,700 1,122,700 1,122,700 1,122,700 1,122,700 162,071 16% Fines, Forfeitures, and Fees 78,191 70,396 99,000 27,268 55,700 55,700 55,700 55,700 55,700 (43,300) -44% Interest Earnings 6,709 6,786 12,000 4,679 10,000 10,000 10,000 10,000 10,000 (2,000) -17% Other Income 20 113 11,282 296 1,200 1,200 1,200 1,200 1,200 (10,082) -89% Transfers In - - - - - - - - - - - Total Revenue 975,148 1,000,596 1,122,911 626,017 1,229,600 1,189,600 1,189,600 1,189,600 1,189,600 106,689 10% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 632,093 587,790 666,302 268,892 670,000 670,000 670,000 670,000 670,000 3,698 1% Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Repairs & Maintenance 680,614 11,538 497,354 110,339 300,000 300,000 300,000 300,000 300,000 (197,354) -40% Other Interfund Allocations 20,667 57,504 31,638 15,822 32,880 32,880 32,880 32,880 32,880 1,242 4% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Insurance 8,424 9,420 8,724 4,356 8,064 8,064 8,064 8,064 8,064 (660) -8% Transfers Out - - - - - - - - - - - Other Services & Charges 3,994 4,740 4,200 1,904 4,400 4,400 4,400 4,400 4,400 200 5% Total Services & Charges 1,345,792 670,992 1,208,218 401,312 1,015,344 1,015,344 1,015,344 1,015,344 1,015,344 (192,874) -16% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.62,366 - 1,536 - 150,000 - - - - 148,464 9666% Motor Equipment - - - - - - - - - - - Machinery & Equipment - - 37,500 - 10,000 - - - - (27,500) -73% Infrastructure - - - - - - - - - - - Total Capital 62,366 - 39,036 - 160,000 - - - - 120,964 310% Total Expenditures 1,408,158 670,992 1,247,254 401,312 1,175,344 1,015,344 1,015,344 1,015,344 1,015,344 (71,910) -6% Net Surplus / (Deficit)(433,010) 329,604 (124,343) 224,705 54,256 174,256 174,256 174,256 174,256 Beginning Cash Balance 1,072,477 639,642 968,528 844,185 898,441 1,072,697 1,246,953 1,421,209 Cash Reserve Cash Adjustments 175 (719) - - - - - - Ending Cash Balance 639,642 968,528 844,185 898,441 1,072,697 1,246,953 1,421,209 1,595,465 Cash Reserves Target 352,040 167,748 311,814 293,836 253,836 253,836 253,836 253,836 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund accounts for the revenues and expenditures from the various parking garages owned by the City of South Bend. Parking garage operations are under outside contract with Downtown South Bend, Inc. Other contracts are for various repair & maintenance projects among the garages. Occupancy levels continue to increase with downtown density. 2017 rate changes increased revenue for much needed capital repairs (all surplus reserved for this purpose in the future). 230 City of South Bend, Indiana2018 BudgetFund 601 - Parking GaragesFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalNew projectsCash160,000 - - - - 160,000 Total Project Capital160,000 - - - - 160,000 Minimum Thresholds:Total Capital160,000 - - - - 160,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:New projects include building upgrades such as new computerized systems231 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenuePARKING GARAGE FUND601-0000-349.11-02 HANDICAP PARKING903940 2,000540540 2,000LEVEL TEXTTEXT AMT02 HANDICAPPED PARKING PERMITS, ALL GARAGES2,0002,000------------ ------------ ------------ ------------ ------------ ------------ ------------*903940 2,000540540 2,000601-0000-351.00-00 FINES & FEES75 8,3520 3,000 1,380 1,273 55,000LEVEL TEXTTEXT AMT02 FINES & FEES, ALL GARAGES55,00055,000601-0000-351.04-00 BAD CHECKS FINES0001002323200LEVEL TEXTTEXT AMT02 BAD CHECK FINES, ALL GARAGES200200------------ ------------ ------------ ------------ ------------ ------------ ------------*75 8,3520 3,100 1,403 1,295 55,200601-0000-361.00-00 INTEREST EARNINGS75655 4,000 4,000179179 10,000LEVEL TEXTTEXT AMT02 INTEREST EARNINGS10,000FOR 2018, COMBINES INT REV FROM 601-0463-361.00-0010,000------------ ------------ ------------ ------------ ------------ ------------ ------------*75655 4,000 4,000179179 10,000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARKING GARAGE FUND240 9,401 4,000 9,100 2,122 2,014 67,200Fund 601 - Parking GaragesCity of South BendRevenue232 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue601-0460-349.11-03 DAILY PARKING19,762 26,901 23,140 23,140 18,543 16,647 35,000LEVEL TEXTTEXT AMT02 DAILY PARKING FEES, MAIN ST. GARAGE35,00035,000601-0460-349.11-04 MONTHLY PARKING180,850 186,715 191,439 191,439 162,591 143,898 200,000LEVEL TEXTTEXT AMT02 MONTHLY PARKING FEES, MAIN ST. GARAGE200,000200,000601-0460-349.11-05 VALIDATIONS84021524424411260200LEVEL TEXTTEXT AMT02 VALIDATIONS, MAIN ST. GARAGE200200601-0460-349.11-06 SPECIAL EVENTS37,933 60,345 52,381 52,381 35,435 33,170 75,000LEVEL TEXTTEXT AMT02 SPECIAL EVENTS, MAIN ST. GARAGE75,00075,000601-0460-349.11-07 KEY CARD INCOME7806600800440440800LEVEL TEXTTEXT AMT02 KEY CARD INCOME, MAIN ST. GARAGE800800------------ ------------ ------------ ------------ ------------ ------------ ------------*240,165 274,836 267,204 268,004 217,121 194,215 311,000601-0460-360.00-00 MISCELLANEOUS REVENUE1268762762174174600LEVEL TEXTTEXT AMT02 MISC REVENUE, MAIN ST. GARAGE600600------------ ------------ ------------ ------------ ------------ ------------ ------------*1268762762174174600------------ ------------ ------------ ------------ ------------ ------------ ------------** MAIN STREET GARAGE240,177 274,904 267,966 268,766 217,295 194,389 311,600Fund 601 - Parking GaragesCity of South BendRevenue233 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue601-0462-349.11-03 DAILY PARKING33,715 41,189 47,226 47,226 21,507 18,831 35,000LEVEL TEXTTEXT AMT02 DAILY PARKING, LEIGHTON PLAZA35,00035,000601-0462-349.11-04 MONTHLY PARKING373,395 358,472 412,343 412,343 306,299 236,566 510,000LEVEL TEXTTEXT AMT02 MONTHLY PARKING, LEIGHTON PLAZA510,000510,000601-0462-349.11-05 VALIDATIONS11,173 10,203 18,235 18,235 10,725 9,305 18,000LEVEL TEXTTEXT AMT02 VALIDATIONS, LEIGHTON PLAZA18,00018,000601-0462-349.11-06 SPECIAL EVENTS028500000601-0462-349.11-07 KEY CARD INCOME6,385 5,4320 10,000 2,881 2,881 7,500LEVEL TEXTTEXT AMT02 KEY CARD INCOME, LEIGHTON PLAZA7,5007,500------------ ------------ ------------ ------------ ------------ ------------ ------------*424,668 415,581 477,804 487,804 341,412 267,583 570,500601-0462-360.00-00 MISCELLANEOUS REVENUE412 9,680 9,680122122500LEVEL TEXTTEXT AMT02 MISC REVENUE, LEIGHTON PLAZA500500------------ ------------ ------------ ------------ ------------ ------------ ------------*412 9,680 9,680122122500------------ ------------ ------------ ------------ ------------ ------------ ------------** LEIGHTON PLAZA GARAGE424,672 415,593 487,484 497,484 341,534 267,705 571,000Fund 601 - Parking GaragesCity of South BendRevenue234 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue601-0463-349.11-02 HANDICAP PARKING2,085 1,6620 1,5009008100------------ ------------ ------------ ------------ ------------ ------------ ------------*2,085 1,6620 1,5009008100601-0463-351.00-00 FINES & FEES77,836 62,044 80,000 80,000 34,937 25,9730------------ ------------ ------------ ------------ ------------ ------------ ------------*77,836 62,044 80,000 80,000 34,937 25,9730601-0463-361.00-00 INTEREST EARNINGS6,634 6,1310 8,000 6,032 4,5000------------ ------------ ------------ ------------ ------------ ------------ ------------*6,634 6,1310 8,000 6,032 4,5000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARKING ENFORCEMENT86,555 69,837 80,000 89,500 41,869 31,2830Fund 601 - Parking GaragesCity of South BendRevenue235 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue601-0464-349.11-03 DAILY PARKING5,721 7,487 5,853 5,853 4,394 3,784 7,500LEVEL TEXTTEXT AMT02 DAILY PARKING7,5007,500601-0464-349.11-04 MONTHLY PARKING217,070 222,676 234,575 234,575 145,223 126,213 270,000LEVEL TEXTTEXT AMT02 MONTHLY PARKING270,000270,000601-0464-349.11-05 VALIDATIONS69185693693429429 1,200LEVEL TEXTTEXT AMT02 VALIDATIONS1,2001,200601-0464-349.11-06 SPECIAL EVENTS030000000601-0464-349.11-07 KEY CARD INCOME3601800200260200500LEVEL TEXTTEXT AMT02 KEY CARD INCOME500500------------ ------------ ------------ ------------ ------------ ------------ ------------*223,220 230,828 241,121 241,321 150,306 130,626 279,200601-0464-360.00-00 MISCELLANEOUS REVENUE43384084000100LEVEL TEXTTEXT AMT02 MISC REVENUE100100------------ ------------ ------------ ------------ ------------ ------------ ------------*43384084000100------------ ------------ ------------ ------------ ------------ ------------ ------------** WAYNE STREET GARAGE223,224 230,861 241,961 242,161 150,306 130,626 279,300Fund 601 - Parking GaragesCity of South BendRevenue236 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue601-0465-351.00-00 FINES & FEES2800 15,900 15,90000500LEVEL TEXTTEXT AMT02 FINES & FEES500500------------ ------------ ------------ ------------ ------------ ------------ ------------*2800 15,900 15,90000500------------ ------------ ------------ ------------ ------------ ------------ ------------** EDDY STREET COMMONS2800 15,900 15,90000500------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARKING GARAGE FUND975,148 1,000,596 1,097,311 1,122,911 753,126 626,017 1,229,600Fund 601 - Parking GaragesCity of South BendRevenue237 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresPARKING GARAGE FUND601-0460-645.31-06 OTHER PROFESSIONAL SVCS 162,426 135,539 150,258 150,258 98,179 83,877 150,000LEVEL TEXTTEXT AMT02 INCLUDES BLOCK BY BLOCK CONTRACT150,000150,000601-0460-645.31-70 ADM FEE ALLOCATION5,497 8,424 8,100 8,100 4,725 4,050 8,779LEVEL TEXTTEXT AMT02 ADMIN ALLOC8,7798,779601-0460-645.34-02 LIABILITY INSURANCE840792833833483414789LEVEL TEXTTEXT AMT02 LIABILITY INS ALLOC789789601-0460-645.36-01 BUILDING R&M1,4500 100,000 100,000 49,321 49,321 100,000LEVEL TEXTTEXT AMT02 R&M100,000100,000601-0460-645.39-39 CREDIT CARD CHARGES1,577 2,100 2,200 2,200 1,185943 2,200------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES171,790 146,855 261,391 261,391 153,893 138,605 261,768601-0460-645.42-02 BUILDINGS4,2230050300 50,000LEVEL TEXTTEXT AMT02 CAPITAL PROJECTS50,00050,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL4,2230050300 50,000------------ ------------ ------------ ------------ ------------ ------------ ------------** MAIN STREET GARAGE176,013 146,855 261,391 261,894 153,893 138,605 311,768Fund 601 - Parking GaragesCity of South BendExpenditures238 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures601-0461-645.36-01 BUILDING R&M000006040------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000006040------------ ------------ ------------ ------------ ------------ ------------ ------------** ST JOSEPH GARAGE000006040Fund 601 - Parking GaragesCity of South BendExpenditures239 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures601-0462-645.31-06 OTHER PROFESSIONAL SVCS 239,749 228,533 269,549 284,689 98,129 86,349 285,000LEVEL TEXTTEXT AMT02 BLOCK BY BLOCK285,000285,000601-0462-645.31-70 ADM FEE ALLOCATION8,538 22,368 12,096 12,096 7,056 6,048 12,963LEVEL TEXTTEXT AMT02 ADMIN ALLOC12,96312,963601-0462-645.34-02 LIABILITY INSURANCE3,480 3,132 3,318 3,318 1,932 1,656 3,144LEVEL TEXTTEXT AMT02 LIABILITY INS ALLOC3,1443,144601-0462-645.36-01 BUILDING R&M23,618 11,538 100,000 284,762 33,329 30,284 100,000601-0462-645.36-05 OTHER EQUIP R&M000 10,000000601-0462-645.39-39 CREDIT CARD CHARGES1,778 2,040 1,000 1,000775637 1,200LEVEL TEXTTEXT AMT02 CREDIT CARD CHARGE FEES1,2001,200------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES277,163 267,611 385,963 595,865 141,221 124,974 402,307601-0462-645.42-02 BUILDINGS4,2230050300 50,000LEVEL TEXTTEXT AMT02 CAPITAL PROJECTS50,00050,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL4,2230050300 50,000------------ ------------ ------------ ------------ ------------ ------------ ------------** LEIGHTON PLAZA GARAGE281,386 267,611 385,963 596,368 141,221 124,974 452,307Fund 601 - Parking GaragesCity of South BendExpenditures240 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures601-0463-645.31-06 OTHER PROFESSIONAL SVCS 88,751 91,063 85,077 85,931 59,719 48,232 90,000LEVEL TEXTTEXT AMT02 BLOCK BY BLOCK90,00090,000601-0463-645.31-70 ADM FEE ALLOCATION2,701 2,868 3,343 3,343 1,953 1,674 3,034LEVEL TEXTTEXT AMT02 ADMIN ALLOC3,0343,034601-0463-645.34-02 LIABILITY INSURANCE1,320 2,976 1,901 1,901 1,106948 1,598LEVEL TEXTTEXT AMT02 LIABILITY INS ALLOC1,5981,598601-0463-645.39-01 REFNDS,AWARDS,INDEMNITIES00001000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES92,772 96,907 90,321 91,175 62,788 50,854 94,632601-0463-645.43-08 COMPUTER EQUIP. & NWTWRK.000 37,50000 10,000LEVEL TEXTTEXT AMT02 CAPITAL PROJECTS10,00010,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000 37,50000 10,000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARKING ENFORCEMENT92,772 96,907 90,321 128,675 62,788 50,854 104,632Fund 601 - Parking GaragesCity of South BendExpenditures241 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures601-0464-645.31-06 OTHER PROFESSIONAL SVCS 141,167 132,655 129,524 129,524 51,864 49,754 130,000LEVEL TEXTTEXT AMT02 BLOCK BY BLOC130,000130,000601-0464-645.31-70 ADM FEE ALLOCATION3,931 23,844 8,099 8,099 4,725 4,050 8,104LEVEL TEXTTEXT AMT02 ADMIN ALLOC8,1048,104601-0464-645.34-02 LIABILITY INSURANCE2,784 2,520 2,672 2,672 1,561 1,338 2,533LEVEL TEXTTEXT AMT02 LIABILITY INS ALLOC2,5332,533601-0464-645.36-01 BUILDING R&M655,5460 100,000 102,592 39,103 30,130 100,000601-0464-645.39-39 CREDIT CARD CHARGES639600 1,000 1,000380324 1,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES804,067 159,619 241,295 243,887 97,633 85,596 241,637601-0464-645.42-02 BUILDINGS53,9200053000 50,000LEVEL TEXTTEXT AMT02 CAPITAL PROJECTS50,00050,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL53,9200053000 50,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WAYNE STREET GARAGE857,987 159,619 241,295 244,417 97,633 85,596 291,637Fund 601 - Parking GaragesCity of South BendExpenditures242 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures601-0465-645.31-06 OTHER PROFESSIONAL SVCS00 15,900 15,900679679 15,000LEVEL TEXTTEXT AMT02 BLOCK BY BLOCK15,00015,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 15,900 15,900679679 15,000------------ ------------ ------------ ------------ ------------ ------------ ------------** EDDY STREET COMMONS00 15,900 15,900679679 15,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** PARKING GARAGE FUND1,408,158 670,992 994,870 1,247,254 456,214 401,312 1,175,344Fund 601 - Parking GaragesCity of South BendExpenditures243