Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Session I - Public Works (2) Financials - Streets & Engineering
City of South Bend, Indiana 2018 Budget Fund 202 - Motor Vehicle Highway 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 Other Taxes 5,814,812 5,647,108 5,650,000 2,717,422 7,220,000 6,750,000 6,850,000 6,950,000 6,950,000 1,570,000 28% Charges for Services 255,529 216,632 223,365 114,139 223,365 235,651 248,612 262,286 276,712 - 0% Interest Earnings 27,508 55,020 21,813 29,296 30,861 31,170 41,082 55,008 55,008 9,048 41% Other Income 95,101 41,819 73,958 8,711 26,082 23,082 23,082 23,082 23,082 (47,876) -65% Transfers In 3,703,000 3,703,000 3,964,974 1,982,487 3,787,750 3,787,750 3,767,750 3,767,750 3,757,750 (177,224) -4% Total Revenue 9,895,950 9,663,579 9,934,110 4,852,054 11,288,058 10,827,653 10,930,526 11,058,126 11,062,552 1,353,948 14% Expenditures by Type Personnel Salaries & Wages 2,633,984 2,707,544 3,099,779 1,260,118 3,146,192 3,185,480 3,226,396 3,272,353 3,317,658 46,413 1% Fringe Benefits 1,031,664 1,152,248 1,485,923 628,395 1,601,025 1,650,663 1,702,049 1,755,250 1,810,327 115,102 8% Total Personnel 3,665,648 3,859,792 4,585,702 1,888,513 4,747,217 4,836,143 4,928,445 5,027,603 5,127,985 161,515 4% Supplies 2,086,254 1,615,606 2,639,357 638,792 2,448,534 2,182,424 2,202,160 2,216,609 2,233,958 (190,823) -7% Services & Charges Professional Services 567,799 557,766 1,105,364 252,678 708,662 500,000 500,000 500,000 500,000 (396,702) -36% Printing & Advertising 465 549 1,130 204 850 862 874 887 901 (280) -25% Utilities 43,644 40,299 49,460 26,263 50,163 50,666 51,173 51,686 52,203 703 1% Education & Training 4,839 3,250 5,710 5,710 8,000 8,160 8,323 8,490 8,659 2,290 40% Travel 1,957 1,513 3,093 2,546 6,500 6,630 6,763 6,898 7,036 3,407 110% Repairs & Maintenance 1,173,901 1,113,144 1,523,756 546,107 1,975,335 1,187,013 1,210,113 1,233,567 1,257,387 451,579 30% Other Interfund Allocations 283,422 372,345 552,449 276,222 620,165 632,568 645,220 658,124 671,287 67,716 12% Debt Service Principal 357,769 484,917 733,595 362,941 831,871 878,821 960,108 1,115,132 916,366 98,276 13% Interest & Fees 19,934 23,960 41,950 19,796 42,958 47,715 52,940 62,275 62,574 1,008 2% Insurance 292,320 389,124 300,614 150,306 398,564 406,535 414,666 422,959 431,418 97,950 33% Transfers Out - - - - - - - - - - - Other Services & Charges 93,533 169,479 203,351 24,853 185,399 185,417 185,435 185,453 185,472 (17,952) -9% Total Services & Charges 2,839,583 3,156,346 4,520,472 1,667,627 4,828,467 3,904,387 4,035,614 4,245,471 4,093,303 307,995 7% Capital 39,458 39,458 20,000 15,995 - - - - - (20,000) -100% Total Expenditures 8,630,943 8,671,202 11,765,531 4,210,926 12,024,218 10,922,954 11,166,219 11,489,683 11,455,246 258,687 2% Net Surplus / (Deficit)1,265,007 992,377 (1,831,421) 641,128 (736,160) (95,302) (235,693) (431,557) (392,694) Beginning Cash Balance 3,891,051 5,210,952 6,122,507 4,291,086 3,554,926 3,459,625 3,223,931 2,792,375 Cash Reserve Cash Adjustments 54,893 (80,821) - - - - - - Ending Cash Balance 5,210,952 6,122,507 4,291,086 3,554,926 3,459,625 3,223,931 2,792,375 2,399,681 Cash Reserves Target 2,157,736 2,167,801 2,941,383 3,006,055 2,730,739 2,791,555 2,872,421 2,863,811 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 25% of Annual expenditures This fund accounts for the operations of the following departments: Streets, Traffic & Lighting, and Curb & Sidewalk. Indiana HEA 1002 increased road funding significantly, adding approximately 40.6% to the Motor Highway Vehicle Fund for 2018. Increases projected by Umbaugh for future years: 2019 +28.7%; 2020 +31.8% and 2021 +33.9%. Revenue from the previous incarnation of the Curb & Sidewalk program, where residents could take a loan from the City to repair their curb or sidewalk, is expected to decline to $0.00 in 2019 as loan repayments are completed. Title changes and salary adjustments are requested for three (3) administrative personnel in the division. 36 City of South Bend, Indiana 2018 Budget Fund 202 - Motor Vehicle Highway 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 -BE Output 20.19 20 22 -BE Output 1531 1500 1500 -GG Output 145 90 99 - - - - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - People/Places (PP) C&S: Address trip hazards on critical pedestrian corridors to improve the walkability for business development needs. Street Paving (lane miles) Alley Improvements (blocks) LED Street Light Upgrades Streets: Ended the winter season with a surplus in de-icing materials T&L: Continuing Olive Street Bridge lighting project Currently painting lane lines, crosswalks, and stop bars through the city C&S: Continue to address ADA curb ramps creating greater anti-icing possibilities, with less clean-up and storm line infiltration after the storm. T&L: Continue to address street light traffic signal concerns to reduce public reporting of possible safety issues. Good Government (GG) T&L: Continue program to upgrade existing City-Owned street lights to LED lamps to improve the lighting quality, energy efficiency of the street lights, and to provide a safer environment for the walking public. Completed City, State, and County signal inspections on time Supported 73 events YTD Streets: Continue to review and update snow removal routes and anti-icing technologies. Planning to use more salt and less sand when possible, Basics are Easy (BE) T&L: Continue to replace old and fading traffic signs and markers. 37 City of South Bend, Indiana 2018 Budget Fund 202 - Motor Vehicle Highway 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 STREETS Director of Streets 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 Manager of Streets 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager of Traffic & Lighting 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Superintendent V 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Superintendent III 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Superintendent IV 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 *Administrative Assistant I 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 *Administrative Assistant II 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 *Director of Financial Services 0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 CURB & SIDEWALK Director of Streets 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Superintendent V 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 *Administrative Assistant I 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 *Administrative Assistant II 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 *Director of Financial Services 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1 Total Non-Bargaining 8.8 8.8 8.8 8.8 8.8 8.8 8.8 8.8 Bargaining STREETS Job Leaders 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 Heavy Equipment Operator II 11.0 11.0 11.0 11.0 11.0 11.0 11.0 11.0 Equipment Operator III 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Equipment Operator II 14.0 14.0 14.0 14.0 14.0 14.0 14.0 14.0 Equipment Operator I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 General Laborer 0.6 0.6 0.6 0.6 0.6 0.6 0.6 0.6 Sign Artist - Job Leader 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Signal Technician II - Job Leader 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Signal Technician II 2.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Signal Technician I - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Operations Technician Job Leader - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Operations Technician 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 CURB & SIDEWALK Job Leader 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Curb & Sidewalk Finisher 3.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Total Bargaining 43.6 46.6 46.6 46.6 46.6 46.6 46.6 46.6 Total Full-Time Employees 52.4 55.4 55.4 55.4 55.4 55.4 55.4 55.4 Explain Significant Staffing Changes Below: * new titles 38 City of South Bend, Indiana2018 BudgetFund 202 - Motor Vehicle HighwayFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement Capital1 EA Skid Loader w/Mill Attachment & TrailerLease112,500 - - - - 112,500 Replace 222 (2001)1 EA 1-Ton Utility TruckLease68,800 - - - - 68,800 Replace 211 (2014)1 EA 9-Ton Roller & Trailer Lease150,000 - - - - 150,000 Replace 217R (1994)1 EA Low-Boy TrailerLease26,000 - - - - 26,000 Replace 218-T (1981)1 EA 3/4-Ton Pick-up Truck, Stndrd Cab, 4WD, w/V-Plow, CNG (T&L)Lease47,450 - - - - 47,450 Replace 423 (2005)1 EA Mill, Track Drive & TrailerLease500,000 - - - - 500,000 Replace 223 (2000)2 EA Radar/Message Boards (T&L)Lease44,000 - - - - 44,000 New2 EA Single Axle Dump TrucksLease- 330,000 - - - 330,000 Replace 262 & 281 (1998)1 EA Tandem Axle Dump TruckLease- 225,000 - - - 225,000 Replace 251 (1998)1 EA Skid Loader w/Attachments & TrailerLease- 102,450 - - - 102,450 Replace 292 (2004)1 EA 4 x 4 SUVLease- 35,000 - - - 35,000 Replace 201 (2007)1 EA 3/4-Ton Pick-up Truck, Stndrd Cab, 4WD, w/V-Plow, CNG Lease- 49,850 - - - 49,850 Replace 212 (2004)1 EA Bucket Truck (T&L)Lease- 165,000 - - - 165,000 Replace 430 (2004)4 EA Tandem Axle Dump TrucksLease- - 900,000 - - 900,000 Replace 230, 239, 240, 265 (2003, 2008)1 EA 1-Ton Utility TruckLease- - 68,800 - - 68,800 Replace 211 (2016)1 EA 3/4-Ton Pick-up Truck, Crew Cab, 4WD, w/V-Plow, CNG Lease- - 52,350 - - 52,350 Replace 210 (2006)1 EA Alley MaintainerLease- - 145,000 - - 145,000 Replace 285 (1995)1 EA Road PatcherLease- - - 200,000 - 200,000 Replace 246 (2001)2 EA Single Axle Dump TrucksLease- - - 330,000 - 330,000 Replace 248, 256 (2004)2 EA Tandem Axle Dump TrucksLease- - - 450,000 - 450,000 Replace 227, 268 (2006)1 EA ForkliftLease- - - 20,000 - 20,000 Replace 214 (1987)1 EA 12-Ton Roller & TrailerLease- - - 150,000 - 150,000 Replace 224R (2000)1 EA Alley MaintainerLease- - - 153,700 - 153,700 Replace 286 (1997)1 EA 5-Yard Front End LoaderLease- - - 275,000 - 275,000 Replace 299 (2000)1 EA 3/4-Ton Pick-up Truck, Crew Cab, 4WD, w/V-Plow, CNG Lease- - - - 57,585 57,585 Replace 208 (2016)1 EA Road PatcherLease- - - - 210,000 210,000 Replace 242 (2004)1 EA Alley MaintainerLease- - - - 161,385 161,385 Replace 289 (1995)1 EA 3/4-Ton Pick-up Truck, Stndrd Cab, 4WD, w/V-Plow, CNG Lease- - - - 57,585 57,585 Replace 424Total Replacement Capital948,750 907,300 1,166,150 1,578,700 486,555 5,087,455 Project CapitalTotal Project Capital- - - - - - Minimum Thresholds:Total Capital948,750 907,300 1,166,150 1,578,700 486,555 5,087,455 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:39 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueMOTOR VEHICHLE HWY FUND202-0000-335.07-00 GASOLINE TAX DIST. M.V.H. 3,679,371 3,640,561 3,600,000 3,600,000 2,083,500 1,762,376 5,170,000LEVEL TEXTTEXT AMT02 HEA 1002 INCREASED ROAD FUNDING - 40.6% INCREASE 5,170,000FISCAL YEAR 7/1/15 TO 6/30/16 PLUS 40.6%$3,682,531 + $1,495,1082019 28.7%, 2020 31.8%, 2021 33.9%ESTIMATED PER UMBAUGH MEMO DATED 5/25/175,170,000202-0000-335.09-00 WHEEL TAX2,135,441 2,006,547 2,050,000 2,050,000 1,327,951 955,046 2,050,000LEVEL TEXTTEXT AMT02 DISTRIBUTION FROM ST. JOSEPH COUNT2,050,000PROJECTION BASED ON HISTORICAL TRENDS, PRIOR TOESTIMATE BASED ON TRENDS. PAYMENTS SPORADIC.2017 - MAINTAIN 2016 BUDGET AMOUNT2,050,000------------ ------------ ------------ ------------ ------------ ------------ ------------*5,814,812 5,647,108 5,650,000 5,650,000 3,411,451 2,717,422 7,220,000202-0000-360.00-00 MISCELLANEOUS REVENUE0000 1,366 1,3660LEVEL TEXTTEXT AMT02 MISC REIMBURSEMENTS2013 MOVED TO 202-0607-380.10-99------------ ------------ ------------ ------------ ------------ ------------ ------------*0000 1,366 1,3660202-0000-361.00-00 INTEREST EARNINGS27,508 55,020 21,813 21,813 38,434 29,296 30,861LEVEL TEXTTEXT AMT02 INTEREST ON FUND BALANCES30,8612018 - BASED ON AVG 2014, 2015, 201630,861------------ ------------ ------------ ------------ ------------ ------------ ------------*27,508 55,020 21,813 21,813 38,434 29,296 30,861202-0000-391.01-00 SALE OF FIXED ASSETS13,529 19,09000000------------ ------------ ------------ ------------ ------------ ------------ ------------*13,529 19,09000000202-0000-392.00-00 INTERFUND OPER. TRANSFER 3,703,000 3,703,000 3,964,974 3,964,974 1,982,487 1,982,487 3,787,750LEVEL TEXTTEXT AMTFund 202 - Motor Vehicle HighwayCity of South BendRevenue40 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue02 TRNSFR FROM PROJECT RELEAF FUND 655-0609-435.50-02 350,000TO COVER SUPERVISORY WAGES, SUPPLIES, FUEL, VACTORREPAIR A AND OTHER EXPENSES PAID BY MVH. TRANSFERHAS BEEN INCREASED TO COVER MORE ACTUAL EXPENSES.TRANSFER FROM COIT FUND 404-0619-431.50-021,500,000TO FUND CURB & SIDEWALK PROGRAMTRANSFER FROM EDIT FUND 408-0607-431.50-021,937,750TO COVER STREETS3,787,750------------ ------------ ------------ ------------ ------------ ------------ ------------*3,703,000 3,703,000 3,964,974 3,964,974 1,982,487 1,982,487 3,787,750------------ ------------ ------------ ------------ ------------ ------------ ------------** MOTOR VEHICHLE HWY FUND9,558,849 9,424,218 9,636,787 9,636,787 5,433,738 4,730,570 11,038,611Fund 202 - Motor Vehicle HighwayCity of South BendRevenue41 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue202-0607-342.03-00 TRAFFIC SIGNAL MAINTENANC 255,529 216,632 223,365 223,365 114,139 114,139 223,365LEVEL TEXTTEXT AMT02 REVENUE MOVED FROM GENERAL FUND 101 TO MVH FUND223,365202 IN 20112017 INDOT MAINT CONTRACT - APPROX 175,980.00INDOT CONTRACT LESS IN 2017 DUE TO THE REMOVAL OFSTATE-OWNED SIGNALS, SIGNALS ON MICHIGAN/ST JOEWILL BE CITY-OWNED WHEN TRANSFER OF RESPONSIBLITYFROM STATE TO CITY TAKES PLACE2017 ST JOE CTY CONTRACT - APPROX 47,385.00223,365------------ ------------ ------------ ------------ ------------ ------------ ------------*255,529 216,632 223,365 223,365 114,139 114,139 223,365202-0607-360.02-00 SALE OF SCRAP METAL5,714 4,637 4,896 4,896 3,838 3,838 5,082LEVEL TEXTTEXT AMT02 SALE OF SCRAP5,082BASED ON 3-YEAR AVERAGE5,082------------ ------------ ------------ ------------ ------------ ------------ ------------*5,714 4,637 4,896 4,896 3,838 3,838 5,082202-0607-380.10-18 SALE OF SIGNS - MATERIALS 31,736 5,520 34,062 34,062 4,073 3,496 15,000LEVEL TEXTTEXT AMT02 TRAFFIC & LIGHTING - SALE OF SIGNS15,000REVENUE FROM THIS ACCOUNT HAS DROPPED DRAMATICALLYIN 2017-LOWERING 2018 ESTIMATE15,000202-0607-380.10-99 MISC. REIMBURSEMENTS5,155 1,127 3,000 3,00000 3,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS REIMBURSEMENTS3,0002017 - BASED ON 3-YEAR AVERAGE3,000------------ ------------ ------------ ------------ ------------ ------------ ------------*36,891 6,647 37,062 37,062 4,073 3,496 18,000------------ ------------ ------------ ------------ ------------ ------------ ------------** STREET298,134 227,916 265,323 265,323 122,050 121,472 246,447Fund 202 - Motor Vehicle HighwayCity of South BendRevenue42 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue202-0619-360.86-00 SEWER CONCRT UTIL CUT MAT 38,967 11,445 32,000 32,0001111 3,000LEVEL TEXTTEXT AMT02 CURB & SIDEWALK REVENUE3,000ANNUAL REVENUE IS DECLINING: THIS VERSION OF THECURB & SIDEWALK PROGRAM WHERE RESIDENTS TOOK OUT ALOAN WITH THE CITY AND THEN MADE PAYMENTS HAS BEENDISCONTINUED. REVENUES DECLINED BY AN AVERAGE OF$29,000/YR SINCE THE PROGRAM'S INCEPTION IN 2012AND WILL CONTINUE TO DECLINE AS PEOPLE PAY OFFTHEIR NOTES. ESTIMATE REVENUE OF $0.00 BY 2019.3,000------------ ------------ ------------ ------------ ------------ ------------ ------------*38,967 11,445 32,000 32,0001111 3,000------------ ------------ ------------ ------------ ------------ ------------ ------------** CURB/SIDEWALK PROGRAM38,967 11,445 32,000 32,0001111 3,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** MOTOR VEHICHLE HWY FUND9,895,950 9,663,579 9,934,110 9,934,110 5,555,799 4,852,054 11,288,0589,895,950 9,663,579 9,934,110 9,934,110 5,555,799 4,852,054 11,288,058Fund 202 - Motor Vehicle HighwayCity of South BendRevenue43 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresMOTOR VEHICHLE HWY FUND202-0607-431.10-01 REGULAR WAGES485,980 530,674 587,289 587,289 298,605 253,960 606,335LEVEL TEXTTEXT AMT02 DIRECTOR OF STREETS - 84,793.00 - 45%38,157MANAGER OF STREETS - 66,708.0066,708TRAFFIC & LIGHTING MANAGER - 66,708.0066,708SUPERINTENDENT V - 57,565.0057,565SUPERINTENDENT IV - 55,204.0055,204SUPERINTENDANT III - 52,441.0052,441SUPERINTENDENT III - 52,441.0052,441*ADMINISTRATIVEASSISTANTI-40,525.00-30%12,158*ADMINISTRATIVE ASSISTANT II - 41,724.00 - 45%18,776*DIR OF FINANCIAL SVCS - 62,132.00 - 35%21,746DIRECTOR OF PUBLIC WORKS - 119,515.00 - 10%14,342DEPUTY DIRECTOR OF PUBLIC WORKS - 97,419.00 -10%11,690CITY ENGINEER - 104,336.00 - 14%14,607ASST CITY ENGINEER - 83,890.00 - 14%11,745PUBLIC CONSTRUCTION MANAGER - 67,725.00 - 14%9,481ENGINEER I - 67,917.00 - 14%9,508ENGINEER I - 67,917.00 - 5%3,396ENGINEER I - 67,917.00 - 14%9,508ENGINEER I - 67,917.00 - 14%9,508EXEC ASST/DIR OF SPECIAL PROJ - 54,168.00 - 10%5,417PROJECT INSPECTOR - 54,195.00 - 14%7,587PROJECT INSPECTOR - 54,195.00 - 14%7,587PROJECT INSPECTOR - 54,195.00 - 14%7,587ADMINISTRATIVE ASSISTANT II - 41,724.00 - 14%5,841PERMITS MANAGER - 49,425.00 - 14%6,920ADMINISTRATIVE ASSISTANT I - 40,525.00 - 14%5,673ASST CITY ENGINEER - 83,890.00 - 5%4,195ENGINEER 1 - 67,917.00 - 14%9,508*DIR OF INFORMATION SYSTEMS - 83,000.00 - 14%11,620PUBLIC INFORMATION OFFICER - 65,704.00 - 14%9,199SALARY ALLOWANCE10,488-FTE: 10.05606,335202-0607-431.10-02 HOURLY WAGES1,450,335 1,487,443 1,675,224 1,675,224 862,022 744,268 1,688,743LEVEL TEXTTEXT AMT02 STREET DEPARTMENT WORK GROUP4 - JOB LEADERS (4 X 20.23 X 2080)168,3141 - HE OPERATOR I (19.18 X 2080)39,89511 - HE OPERATOR II (11 X 19.65 X 2080)449,5921 - EQUIP OPERATOR III (18.49 X 2080)38,46014 - EQUIP OPERATOR II (14 X 17.80 X 2080)518,3361 - EQUIP OPERATOR I (17.19 X 2080)35,756Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures44 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures.60 - GENERAL LABORER (16.31 X 1248)18,998TRAFFIC & LIGHTING WORK GROUP1 - SIGN ARTIST JOB LEADER (20.23 X 2080)42,0791 - SIGNAL TECH II - JOB LEADER (20.23 X 2080)42,0793 - SIGNAL TECH II (3 X 19.52 X 2080)121,8053 - OPERATIONS TECH (3 X 18.04 X 2080)112,5701-SIGNALTECHI-18.69X208038,8761-OPTECH-JOBLEADER-20.23X208042,079CERTIFICATION PAYSIGN ARTIST JOB LEADER - .90 X 20801,872SIGNAL TECH JOB LEADER - 1.00 X 20802,080SIGNALTECHS-2X1.00X20804,160SIGNAL TECH - 1 X .80 X 20801,664SIGNAL TECH - 1 X .40 X 2080832OPERATIONS TECHS - 3 X .60 X 20803,120OPERATIONSTECH-1X.20X2080416NIGHT PREMIUM16 EMPLOYEES X 40 HRS X 20 WKS X .455,76042.60 FTE1,688,743202-0607-431.10-03 SEASONAL & INTERNS40,668 41,318 63,648 63,648 12,433 6,755 63,648LEVEL TEXTTEXT AMT02 6 T&L SUMMER HELP 6 X 10.20/HR X 40 HRS X 26 WKS)63,648STAFFING: 3.00 FTE63,648202-0607-431.10-04 EXTRA AND OVERTIME249,974 235,933 299,883 299,883 51,286 44,075 309,588LEVEL TEXTTEXT AMT02 AVERAGE: 2013 - 2016270,177NEW IN 2017: ADD 3RD DT HOLIDAY - PLOWINGAVG WAGE 19.50 X 2 X 8 HRS X 41 EMPLOYEES19,656NEW IN 2017: ADD MEMORIAL DAY & 4TH OF JULY AS DTHOLIDAYS FOR T&L - PARADESAVGWAGE19.50X2X4HRSX4EMPLOYEESX2DAYS3,120C&S OT FOR SNOW CONTROL:2012-2016 AVG 1ST/4TH QTR15,170NEW IN 2017: ADD 3RD DT HOLIDAY - PLOWINGC&SAVGWAGE20.34X2X12HRSX31,465309,588202-0607-431.10-06 LONGEVITY PAY00 5,700 5,700 2,875 2,525 5,700LEVEL TEXTTEXT AMT02 NEW IN 2017 - BASED ON YEARS OF SERVICE5,7005,700Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures45 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures202-0607-431.10-08 OVERTIME - SPECIAL EVENTS 17,965 13,783 25,000 25,000 9,320 7,833 17,500LEVEL TEXTTEXT AMT02 NEW IN 2014 - TRACK SPECIAL EVENT O/T COSTAVERAGE 2014 - 201617,50017,500202-0607-431.10-09 PERMANENT PART-TIME70,861 80,095 93,729 93,729 39,269 35,356 94,228LEVEL TEXTTEXT AMT02 3 - P/T 211 DRIVERS 3 X 11.70 X 912 HOURS32,011P/T ACCTNG CLERK - 1508 HRS X 14.9122,485P/T ADMIN ASSISTANT III - 1508 HRS - 31,110.0031,110P/T CITY ENGINEER - 44,822.00 - 14%6,275P/T SECRETARY V - 16,765.00 - 14%2,34794,228202-0607-431.10-13 CONTRACT ADD PAYS45,402 35,969 59,683 59,683 29,829 28,723 61,560LEVEL TEXTTEXT AMT02 STREETS STAND BYDAYS:19.50AVGWAGEX3HRSX6EMPX36DAYS12,636NIGHTS:19.50A/W+.45NPX3HRSX16EMPX3634,474TRAFFIC & LIGHTING STAND BYSIGNAL TECH: 19.50 A/W X 28.5 HRS X 26 PP14,45061,560202-0607-431.10-14 PRODUCTIVITY BONUS9,356 17,30600000LEVEL TEXTTEXT AMT02 PRODUCTIVITY BONUSREPLACED IN 2017 W/JOB READINESS ALLOWANCE -SEE 202-0607-431.11-27202-0607-431.11-01 FICA - REGULAR177,377 181,907 216,965 216,965 99,127 85,515 219,843LEVEL TEXTTEXT AMT02 ALL INCOME/WAGES X 7.65%219,204AUTO ALLOWANCE - 1,764.00 X 7.65%135CELL PHONE ALLOWANCE - 6,586.00 X 7.65%504219,843202-0607-431.11-04 PERF - REGULAR252,368 257,742 299,092 299,092 140,272 121,037 303,244LEVEL TEXTTEXT AMT02 ALL INCOME/WAGES EXCEPT SEASONAL & PT X 11.20%303,244303,244202-0607-431.11-05 PERF - UNION00 29,892 29,892 13,803 12,041 30,247Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures46 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 NEW IN 2017 - CITY WILL PAY 1.5% OF TEAMSTER PERF30,24730,247202-0607-431.11-07 UNEMPLOYMENT COMP6,861 3,164 7,070 7,070000LEVEL TEXTTEXT AMT02 NOT CHARGING IN 2018202-0607-431.11-08 HEALTH INSURANCE465,932 559,015 756,725 756,725 370,615 318,954 857,985LEVEL TEXTTEXT AMT02 LONG TERM DISABILITY:52.65 EMP X 4.00 X 24 PAY PERIODS5,055HEALTH INSURANCE COVERAGE:52.65 EMP X 675.00 X 24 PAY PERIODS852,930857,985202-0607-431.11-09 LIFE INSURANCE5,468 5,737 6,340 6,340 3,293 2,838 6,340LEVEL TEXTTEXT AMT02 52.65 EMP X 5.00 X 24 PAY PERIODS6,3406,340202-0607-431.11-11 SHOE ALLOWANCE9,080 9,37400000LEVEL TEXTTEXT AMT02 REPLACED IN 2017 W/JOB READINESS ALLOWANCESEE 202-0607-431.11-27202-0607-431.11-12 AUTO ALLOWANCE728978 1,230 1,230473405 1,764LEVEL TEXTTEXT AMT02 DIRECTOR OF PUBLIC WORKS - 6,000.00 - 12%720DEPUTY DIRECTOR OF PUBLIC WORKS - 2,400.00 - 12%288CITY ENGINEER - 2,400.00 - 14%336ASST CITY ENGINEER - 1,500.00 - 14%210MGR - PUBLIC CONSTRUCTION - 1,500.00 - 14%2101,764202-0607-431.11-24 CELL PHONE ALLOWANCE5,138 6,242 7,059 7,059 3,538 3,025 6,586LEVEL TEXTTEXT AMT02 DIRECTOR OF STREETS - 660.00 - 45%297STREET MANAGER - 55.00/MO X 12660STREET SUPT V - 35.00/MO X 12448STREET SUPT III - 55.00/MO X 12660STREET SUPT III - 55.00/MO X 12660STREET SUPT III - 55.00/MO X 12660Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures47 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresTRAFFIC & LIGHTING MANAGER - 55.00/MO X 12660T&L JOB LEADER - 55.00/MO X 12660T&L LOCATOR - 55.00/MO X 12660ENGINEERING ALLOCATIONSDIRECTOR OF PUBLIC WORKS - 660.00 - 10%66DEPUTY DIRECTOR OF PUBLIC WORKS - 660.00 - 10%66CITY ENGINEER - 660.00 - 14%93ASST CITY ENGINEER - 660.00 - 14%93ASST CITY ENGINEER - 660.00 - 5%33MGR, PUBLIC CONSTRUCTION - 660.00 - 14%93ENGINEER I - 660.00 - 14%93ENGINEER I - 660.00 -5%33ENGINEER I - 660.00 - 14%93ENGINEER I - 660.00 - 14%93ENGINEER I - 660.00 - 14%93PROJECT INSPECTOR - 660.00 - 14%93PROJECT INSPECTOR - 660.00 - 14%93PROJECT INSPECTOR - 660.00 - 14%93DIR OF OPERATIONS & ASSETS - 660.00 - 14%936,586202-0607-431.11-27 JOB READINESS ALLOWANCE00 17,680 17,680 16,724 16,724 18,105LEVEL TEXTTEXT AMT02 42.6 EMPLOYEES X 425.0018,105NEW IN 2017 - REPLACES PRODUCTION BONUS ANDSHOE ALLOWANCE18,105202-0607-431.11-29 PARENTAL LEAVE000000 7,119LEVEL TEXTTEXT AMT02 NEW IN 2018 - ALL WAGES X .25%7,1197,119202-0607-431.11-99 OTHER FRINGE BENEFITS3,014 4,800 6,500 6,50000 6,500LEVEL TEXTTEXT AMT02 TEAMSTER 457 MATCH PAID TWICE PER YEAR6,5006,500------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES3,296,507 3,471,480 4,158,709 4,158,709 1,953,484 1,684,032 4,305,035202-0607-431.21-02 PRINT SHOP625176 1,100 1,100219219 1,100LEVEL TEXTTEXT AMT02 MATERIALS AND SUPPLIES1,100Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures48 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures1,100202-0607-431.21-03 C.S. OFFICE SUPPLIES69634860060000600LEVEL TEXTTEXT AMT02 COPY PAPER600600202-0607-431.21-04 OTHER OFFICE SUPPLIES2,334761 4,800 5,137716640 4,800LEVEL TEXTTEXT AMT02 SUPPLIES UNAVAILABLE THROUGH CS4,8004,800202-0607-431.22-01 CENTRAL SERVICE GASOLINE 290,390 197,414 357,625 357,625 85,943 73,887 311,293LEVEL TEXTTEXT AMT02 CS RECOMMENDATION124,517 GAL X 2.50311,293311,293202-0607-431.22-02 COMPRESSED GAS4,302 3,990 11,000 11,126 2,833 2,542 12,000LEVEL TEXTTEXT AMT02 PROPANE FOR PAVING, CYLINDER RENTALS12,00012,000202-0607-431.22-05 UNIFORMS12,916 11,852 15,000 17,610 7,338 6,243 15,000LEVEL TEXTTEXT AMT02 UNIFORMS, T-SHIRTS - 3-YEAR AVERAGE15,00015,000202-0607-431.22-06 COMPUTER SUPPLIES2,362849 3,000 3,000697453 3,000LEVEL TEXTTEXT AMT02 INK CARTRIDGES, CABLES, REPLACEMENT PARTS3,0003,000202-0607-431.22-20 INSTITUTIONAL & MEDICAL0010010000100LEVEL TEXTTEXT AMT02 PRESCRIPTION SAFETY GLASSES100100202-0607-431.22-21 C.S. CLEANING SUPPLIES1,613 1,927 3,000 3,000872872 3,000LEVEL TEXTTEXT AMTFund 202 - Motor Vehicle HighwayCity of South BendExpenditures49 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 JANITORIAL SUPPLIES3,0003,000202-0607-431.22-22 MEDICAL/SAFETY SUPPLIES2,295 2,657 2,875 2,8756464 2,875LEVEL TEXTTEXT AMT02 MISCELLANEOUS SAFETY EQUIPMENT, VESTS, GLASSES2,8752,875202-0607-431.22-24 OTHER OPERATING SUPPLIES3,765 7,143 44,500 49,774 11,461 10,054 44,500LEVEL TEXTTEXT AMT02 MISCELLANEOUS OPERATING SUPPLIES44,500IN 2017: MOVED 23-01, 23-24, 23-99 HERE44,500202-0607-431.22-30 TRAFFIC/SIGN/OTHER112,882 127,461 165,000 185,961 128,246 127,921 200,000LEVEL TEXTTEXT AMT02 COSTS PAID FROM THE GENERAL FUND T&L200,000THROUGH 2012, MOVED TO FUND 202 IN 2013200,000202-0607-431.22-40 SIGNALS/LIGHTS144,404 175,212 175,000 271,726 111,545 104,846 175,000LEVEL TEXTTEXT AMT02 SIGNAL EQUIPMENT MAINTENANCE/REPAIR/CONSTRUCTION175,000175,000202-0607-431.23-01 BUILDING MATERIALS1,726 3,1210 1,904 2,252 1,7560LEVEL TEXTTEXT AMT02 MOVED TO 22-24 IN 2017202-0607-431.23-02 STREET MATERIAL906,552 550,310 644,333 707,187 112,029 99,942 918,676LEVEL TEXTTEXT AMT02 HMA MATERIAL - PAVING, PATCHING, SEALING918,676918,676202-0607-431.23-03 CONCRETE SUPPLIES/REPAIRS 9,506 4,381 50,000 6,926472232 10,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS CONCRETE REPAIRS10,00010,000202-0607-431.23-20 SMALL TOOLS & EQUIPMENT 77,547 23,456 70,000 91,832 30,951 28,986 70,000LEVEL TEXTTEXT AMTFund 202 - Motor Vehicle HighwayCity of South BendExpenditures50 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 SNOW BLADES, PAVING/CONSTRUCTION SUPPLIES, SHOVELS70,000HAND HELD TOOLSADDITIONAL EQUIPMENT CHGD HERE DUE TO NEW CAPITALLIMITS70,000202-0607-431.23-24 OTHER OPERATING SUPPLIES341 6,97100000LEVEL TEXTTEXT AMT02 MOVED TO 22-24 IN 2017202-0607-431.23-40 SALT/ICE MELT447,997 399,003 565,960 821,680 160,301 160,301 574,360LEVEL TEXTTEXT AMT02 PER SBOA, COST OF SALT TO BE SHARED BY FUNDS 202AND 641 (SEE ACCTS 202-0607-431.23-40 AND641-0621-792.23-40) COSTS TO BE APPORTIONED BASEDON FORMULA APPROVED BY SBOA AND WILL BE CHARGEDDIRECTLY TO EACH ACCOUNT.ESTIMATED PURCHASE IN 2017-2018 8,400 TONS70.00/TON - 117,600.00 TO BE PAID BY SEWERS470,400SAND,SLAG FOR TRACTION CONTROL25,000LIQUID ICE/SNOW TREATMENT SOLUTION - 56,000 GAL78,960574,360202-0607-431.23-99 OTHER R&M SUPPLIES930 1,50607000LEVEL TEXTTEXT AMT02 2017 - MOVED TO 22-24------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES2,023,183 1,518,538 2,113,893 2,539,170 655,939 618,957 2,346,304202-0607-431.31-01 LEGAL SERVICES32700000 1,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS LEGAL FEES1,0001,000202-0607-431.31-06 OTHER PROFESSIONAL SVCS2,230200 1,000 3,284 2,297 2,297 1,000LEVEL TEXTTEXT AMT02 UNPLANNED PROFESSIONAL SERVICES NEEDS1,0002015 - MOVED CONSTRUCTION TYPE SERVICES TO 36-011,000202-0607-431.31-70 ADM FEE ALLOCATION238,658 283,956 305,429 305,429 178,164 152,712 310,309LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #1310,309Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures51 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresADMINISTRATIVE FEE310,309202-0607-431.31-71 CENTRAL STORES ALLOCATION 2,934 3,696 4,136 4,140 2,415 2,070 10,849LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #310,849CENTRAL STORES10,849202-0607-431.31-73 PRINT SHOP ALLOCATION00 3,333 3,336 1,946 1,668 2,496LEVEL TEXTTEXT AMT02 2018 FIXED ALLOCATION #42,496PRINT SHOP2,496202-0607-431.31-75 311 CALL CENTER ALLOC0 21,57300000LEVEL TEXTTEXT AMT02 MOVED TO IT ALLOCATION #7 IN 2017311 CALL CENTER202-0607-431.31-76 IT ALLOCATION000000 245,960LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7245,960INFORMATION TECHNOLOGYNEW IN 2017 - INCLUDES 311, VOIP, GIS, IT245,960202-0607-431.32-04 TELEPHONE6,240 5,842 2,640 2,962702599 2,640LEVEL TEXTTEXT AMT02 TELEPHONELANDLINE - MOVED TO IT ALLOCATION #7 IN 2017CELLS/TABLETS - AVG 220.00/MO X 122,6402,640202-0607-431.32-21 TRAVEL - MILEAGE185161450450159159500LEVEL TEXTTEXT AMT02 APWA CONFERENCE, MISC TRAINING500500202-0607-431.32-22 TRAVEL - AIRFARE000000 1,500LEVEL TEXTTEXT AMT02 CONFERENCES, SEMINARS1,500Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures52 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures1,500202-0607-431.32-23 TRAVEL - HOTEL1,184927 1,750 1,750 1,546 1,546 2,250LEVEL TEXTTEXT AMT02 APWA CONFERENCE, MISCELLANEOUS TRAINING2,2502,250202-0607-431.32-24 TRAVEL - MEALS495370605605623623 1,500LEVEL TEXTTEXT AMT02 APWA CONFERENCE, MISCELLANEOUS TRAINING1,5001,500202-0607-431.32-25 TRAVEL - OTHER9355288288217217750LEVEL TEXTTEXT AMT02 APWA CONFERENCE, MISCELLANEOUS TRAINING750750202-0607-431.33-02 PUBLICATION LEGAL NOTICE170298275871140130350LEVEL TEXTTEXT AMT02 ADVERTISING BPW BIDS350350202-0607-431.34-02 LIABILITY INSURANCE292,320 389,124 300,614 300,614 175,357 150,306 398,564LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #5398,564LIABILITY INSURANCE398,564202-0607-431.35-01 ELECTRIC19,702 20,192 21,653 21,653 9,507 9,507 21,653LEVEL TEXTTEXT AMT02 ELECTRIC SERVICE - PWSC BUILDING21,65321,653202-0607-431.35-02 GAS16,692 12,417 18,990 18,990 13,174 13,152 18,990LEVEL TEXTTEXT AMT02 GAS SERVICE - PWSC BUILDING18,99018,990202-0607-431.35-03 TRASH REMOVAL00 1,008 1,00800 1,008LEVEL TEXTTEXT AMTFund 202 - Motor Vehicle HighwayCity of South BendExpenditures53 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 NEW IN 2017 - SOLID WASTE CHARGING FOR TRASHPICK UP FOR CITY DEPARTMENTS150.00/MO - 44% TO SEWERS1,0081,008202-0607-431.35-04 WATER7,250 7,690 7,809 7,809 4,250 3,605 8,512LEVEL TEXTTEXT AMT02 WATER SERVICE AT PWSC BUILDING7,8097,809202-0607-431.36-01 BUILDING & STREET MAINT 211,943 99,834 150,000 355,788 16,618 15,204 928,900LEVEL TEXTTEXT AMT02 PEST CONTROL, ANNUAL SPRINKLER/FIRE EXTINGUISHERINSPECTIONS, MONTHLY ALARM MONITORING, WEATHERSATELLITE SERVICE6,231BUILDING/HVAC/MECHANICAL REPAIRS57,669ROOF REPAIRS - ESTIMATED50,000MISC REPAIRS - SIGNALS/FIBER OPTICS15,000CONTRACTED PAVING PROJECTS800,000928,900202-0607-431.36-02 OFFICE EQUIP R&M2,321 2,539 4,000 4,000 2,162 2,133 4,000LEVEL TEXTTEXT AMT02 COPIER EXPENSES, OTHER OFFICE EQUIPMENT, MISC4,0004,000202-0607-431.36-03 AUTO EQUIPMENT R&M951,373 985,406 1,133,450 1,133,450 564,530 506,666 1,005,000LEVEL TEXTTEXT AMT02 STREET/T&L DEPT VEHICLE VEHICLE REPAIRS COSTS1,005,000AVG 2014 - 20151,005,000202-0607-431.36-04 COMPUTER EQUIP R&M9,038 10,416 187,734 187,740 109,515 93,8700202-0607-431.36-05 OTHER EQUIP R&M4,284 2,550 3,500 4,518 1,193 1,126 3,500LEVEL TEXTTEXT AMT02 ATSI CERTIFICATIONS, GLOVE SAFETY CERTIFICATIONS3,5003,500202-0607-431.36-06 RADIO EQUIP R&M3,980 6,541 5,000 5,000 1,781 1,748 12,935LEVEL TEXTTEXT AMT02 2014 - 2016 AVERAGE, REALIGNMENT SERVICES12,93512,935Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures54 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures202-0607-431.37-02 CAPITAL LEASE PAYMENTS1,350000000LEVEL TEXTTEXT AMT02 FRONT END LOADER RENTAL - REMOVE FOR 2016202-0607-431.37-11 CAPITAL LEASE PRINCIPAL 357,769 484,917 733,595 733,595 561,291 362,941 831,871LEVEL TEXTTEXT AMT02 2013 LEASES - VEHICLES/EQUIP - SCHEDULE 11070,6282013 LEASES - VEHICLES/EQUIP - SCHEDULE 11376,0732014 LEASES - VEHICLES/EQUIP - SCHEDULE 124119,3712015 LEASES - VEHICLES/RADIOS - SCHEDULE 14087,9622015 LEASES - PAINT TRUCK - SCHEDULE 14438,0182016 LEASES: VEHICLES/EQUIP - SCHEDULE 152242,4122017- PENDING2 EA - TANDEM AXLE TRUCK W/SNOW EQUIPMENT & CNGUPGRADE. TRUCKS ARE 225,000.00 EACHREPLACING 251 & 258PURCHASE PRICE OF 450,000.00FIGURED AT 2% INTEREST FOR 5 YEARS, BI-ANNUALPAYMENTS, 2018 - 106,722.64106,7232018: 2% INTEREST, 5-YR LEASE, BI-ANNUAL PAYMENTS90,6841-SKID LOADER - 1 PYMNT IN 2018 - 10,752.981-1 TON UTILITY TRUCK - 1 PYMNT IN 2018 - 6,576.051-9 TON ROLLER W/TRLR - 1 PYMNT IN 2018 - 14,337.31-LOWBOYTRLR-1PYMNTIN2018-2,485.131-3/4 TON PU - 1 PYMNT IN 2018 - 4,535.371-TRACK MILL & TRLR - 1 PYMNT IN 2018 - 47,791.042-RADAR/MSG BOARDS - 1 PYMNT IN 2018 - 4,205.61831,871202-0607-431.37-12 CAPITAL LEASE INTEREST19,934 23,960 41,950 41,950 31,059 19,796 42,958LEVEL TEXTTEXT AMT02 2013 LEASES - VEHICLES/EQUIP - SCHEDULE 1106472013 LEASES - VEHICLES/EQUIP - SCHEDULE 1139062014 LEASES - VEHICLES/EQUIP - SCHEDULE 1243,2692015 LEASES - VEHICLES/EQUIP - SCHEDULE 1403,4032015 LEASES - PAINT TRUCK - SCHEDULE 1441,6422016 LEASES - VEHICLES/EQUIP - SCHEDULE 15214,1852017 - PENDING9,4182 EA - TANDEM AXLE TRUCK W/SNOW EQUIPMENT & CNGUPGRADE. TRUCKS ARE 225,000 EACHREPLACING 251 & 258PURCHASE PRICE OF 450,000.00FIGURED AT 2% INTEREST FOR 5 YEARS, BI-ANNUAL2018 PYMNT - 9,417.642018: 2% INTEREST, 5-YR LEASE, BI-ANNUAL PYMNTS9,488Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures55 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures1-SKID LOADER - 1 PYMNT IN 2018 - 1,125.001-1 TON UTILITY TRK - 1 PYMNT IN 2018 - 688.001-9 TON ROLLER W/TRLR - 1 PYMNT IN 2018 - 1,500.001-LOWBOYTRLR-1PYMNTIN2018-260.001-3/4 TON PU TRUCK - 1 PYMNT IN 2018 - 474.501-MILL & TRLR - 1 PYMNT IN 2018 - 5,000.002-MSG/RADAR BORDS - 1 PYMNT IN 2018 - 440.0042,958202-0607-431.39-10 SUBSCRIPTIONS8,10984 8,930 12,300 3,454 3,454584LEVEL TEXTTEXT AMT02 SOUTH BEND TRIBUNE SUBSCRIPTION84OTHER SUBSCRIPTIONS500584202-0607-431.39-11 DUES & MEMBERSHIPS0030030000300LEVEL TEXTTEXT AMT02 DUES, PROFESSIONAL FEES300300202-0607-431.39-70 EDUCATION & TRAINING4,839 3,250 4,500 5,710 5,710 5,710 8,000LEVEL TEXTTEXT AMT02 APWA SEMINARS, PAVING/CONSTRUCTION SEMINARS,8,000COMPUTER CLASSES, IMSA8,000202-0607-431.39-88 PENALTY FEES000 5,000 5,000 5,0000202-0607-431.39-89 MISC CHARGES & SVCS1,260 2,939 3,500 6,114 3,839 3,839 5,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS CHARGES5,0005,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES2,164,680 2,368,937 2,946,439 3,168,654 1,696,649 1,360,079 3,872,879202-0607-431.43-01 FURNITURE AND FIXTURES39,458 39,45800000202-0607-431.43-03 OFFICE EQUIPMENT00 20,000 20,000 15,995 15,9950------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL39,458 39,458 20,000 20,000 15,995 15,9950------------ ------------ ------------ ------------ ------------ ------------ ------------** STREET7,523,828 7,398,413 9,239,041 9,886,533 4,322,067 3,679,063 10,524,218Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures56 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures202-0619-431.10-01 REGULAR WAGES64,385 65,189 67,885 67,885 39,193 33,967 71,618LEVEL TEXTTEXT AMT02 CURB AND SIDEWALK REPAIR PROGRAMINMVHFUNDTOBEPAIDFROMATRANSFERFROM COIT FUND 404DIRECTOR OF STREETS - 84,793.00 - 5%4,240SUPERINTENDENT V - 57,565.0057,566*ADMINISTRATIVEASSTI-40,525.00-5%2,026*ADMINIISTRATIVE ASST II - 41,724 - 5%2,086DIR FINANCIAL SVCS - 62,132.00 - 10%6,213SALARY ALLOWANCE513-FTE: 1.2571,618202-0619-431.10-02 HOURLY WAGES166,698 164,752 166,484 166,484 95,899 83,093 167,753LEVEL TEXTTEXT AMT02 JOB LEADER - 20.68 X 2,08043,0153 - CONCRETE FINISHERS 3 X 19.99 X 2080124,738STAFF: 4 FTE167,753202-0619-431.10-03 SEASONAL & INTERNS17,435 20,185 45,760 45,760 21,907 15,538 46,676LEVEL TEXTTEXT AMT02 4 SEASONAL - WORK APRIL - APPROX END OF SEPT4 X 40 HRS X 26 WKS X 11.22/HR46,67646,676202-0619-431.10-04 EXTRA AND OVERTIME9,325 8,903 2,800 2,800739723 6,102LEVEL TEXTTEXT AMT02 50 HRS/EMPLOYEE:AVGWAGE20.34X1.5X4X506,1026,102202-0619-431.10-06 LONGEVITY PAY00450450300300450LEVEL TEXTTEXT AMT02 NEW IN 2017 - BASED ON YEARS OF SERVICE450450202-0619-431.10-13 CONTRACT ADD PAYS4,600 3,994 6,244 6,244 3,003 3,003 6,291LEVEL TEXTTEXT AMT02 STAND BY:6,291JOB LEADER - 20.68 X 3HRS/WK X 26 WKS 1,612.04Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures57 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresCONCRETE FINISHER -3 X 19.99 X 3 HRS/WK X 26 WKS 4,677.666,291202-0619-431.10-14 PRODUCTIVITY BONUS1,000 2,00000000LEVEL TEXTTEXT AMT02 NEW IN 2014 - PRODUCTIVITY BONUS - 250.00/MANREPLACED IN 2017 W/JOB READINESS ALLOWANCE -SEE 202-0619-431.11-27202-0619-431.11-01 FICA - REGULAR19,022 19,189 22,322 22,322 11,915 10,118 23,031LEVEL TEXTTEXT AMT02 ALL INCOME/WAGES X 7.65%22,996PHONE ALLOWANCE: 453.00 X 7.65%3523,031202-0619-431.11-04 PERF - REGULAR26,893 27,152 27,504 27,504 15,541 13,519 28,439LEVEL TEXTTEXT AMT02 ALL INCOME/WAGES LESS SEASONAL X 11.20%28,43928,439202-0619-431.11-05 PERF - UNION00 2,666 2,666 1,493 1,301 2,735LEVEL TEXTTEXT AMT02 NEW IN 2017 - 1.5% OF TEAMSTER PERF PAID BY CITY2,7352,735202-0619-431.11-07 UNEMPLOYMENT COMP700340729729000LEVEL TEXTTEXT AMT02 NOT CHARGING IN 2018202-0619-431.11-08 HEALTH INSURANCE56,800 74,656 81,372 81,372 47,462 40,682 85,556LEVEL TEXTTEXT AMT02 LTD - 5.25 X $4.00 X 24 PAY PERIODS506HEALTH - 5.25 X 648.00 X 24 PAY PERIODS85,050RATE INCREASED FROM 600.00 IN 201685,556202-0619-431.11-09 LIFE INSURANCE564611624624364312630LEVEL TEXTTEXT AMT02 LIFE - 5.25 X 5.00 X 24 PAY PERIODS630630202-0619-431.11-11 SHOE ALLOWANCE74889900000Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures58 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 SHOE ALLOWANCE - 4 X $2502014 INCREASE PER TEAMSTER CONTRACTREPLACED IN 2017 W/JOB READINESS ALLOWANCE -SEE 202-0619-431.11-27202-0619-431.11-12 AUTO ALLOWANCE8000000202-0619-431.11-24 CELL PHONE ALLOWANCE563442453453264227453LEVEL TEXTTEXT AMT02 DIRECTOR OF STREETS - 660.00 - 5%33SUPERINTENDENT V - 35.00/MO X 12420453202-0619-431.11-27 JOB READINESS ALLOWANCE00 1,700 1,700 1,700 1,700 1,700LEVEL TEXTTEXT AMT02 NEW IN 2017 - REPLACES PRODUCTION BONUS ANDSHOE ALLOWANCE - 4 EMPLOYEES X 425.001,7001,700202-0619-431.11-29 PARENTAL LEAVE000000748LEVEL TEXTTEXT AMT02 PARENTAL LEAVE ALL WAGES X .25%748748202-0619-431.11-99 OTHER FRINGE BENEFITS400000000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES369,141 388,312 426,993 426,993 239,780 204,481 442,182202-0619-431.22-01 CENTRAL SERVICE GASOLINE0 4,068 6,250 6,250 3,527 3,166 6,825LEVEL TEXTTEXT AMT02 TRUCKS 455, 460, 474 & LOADER 2916,825CS RECOMMENDATIONAVG 2014 - 2016 2,730 GAL X 2.506,825202-0619-431.22-05 UNIFORMS1,207 1,674 1,155 1,184752618 1,155LEVEL TEXTTEXT AMT02 UNIFORMS FROM CINTAS, T-SHIRTS1,1551,155202-0619-431.23-03 CONCRETE SUPPLIES/REPAIRS 56,981 85,612 80,000 82,253 34,090 12,076 87,500LEVEL TEXTTEXT AMTFund 202 - Motor Vehicle HighwayCity of South BendExpenditures59 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 CONCRETE AND RELATED MATERIALS, ADA RAMPS87,500AVG 2014 - 201687,500202-0619-431.23-21 C.S. SMALL TOOLS & EQUIP1,963 3,858 8,500 8,500 3,618 3,543 5,000LEVEL TEXTTEXT AMT02 TOOLS AND EQUIPMENT5,0005,000202-0619-431.23-24 OTHER OPERATING SUPPLIES2,920 1,856 1,750 2,000 1,737431 1,750LEVEL TEXTTEXT AMT02 VESTS, SAFETY GLASSES, CURB LAWN REPAIR MATERIAL,1,750MISC. MASONRY SUPPLIES1,750------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES63,071 97,068 97,655 100,187 43,724 19,835 102,230202-0619-431.31-06 OTHER PROFESSIONAL SVCS 565,242 557,566 830,717 1,102,080 439,221 250,381 706,662LEVEL TEXTTEXT AMT02 TREE REMOVAL32,000TREE PLANTING15,000CONTRACTED CURB/SIDEWALK WORK659,662706,662202-0619-431.31-70 ADM FEE ALLOCATION32,792 52,704 51,803 51,804 30,219 25,902 50,551LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #150,551ADMINISTRATIVE FEE50,551202-0619-431.32-02 POSTAGE1010010000300LEVEL TEXTTEXT AMT02 MAILING COSTS ASSOCIATED WITH PROGRAM300300202-0619-431.33-02 PUBLICATION LEGAL NOTICE2952512502597474500LEVEL TEXTTEXT AMT02 COSTS FOR PUBLICATION OF LEGAL NOTICE OF BIDS500500202-0619-431.36-03 AUTO EQUIPMENT R&M0 16,274 21,000 21,000 20,219 19,229 21,000Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures60 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 NEW IN 2016 - CHARGE TRUCKS 455,460, 474 &21,000LOADER 291 - PREVIOUSLY CHARGED TO SEWERS21,000202-0619-431.39-05 CURB & SIDEWALK REIMBURSE 76,573 160,614 76,575 176,575 16,282 11,961 176,575LEVEL TEXTTEXT AMT02 NEW IN 2015 - REIMBURSE HOMEOWNER FOR PORTION OF176,575CONTRACTOR COST TO REPLACE CURB AND/OR SIDEWALK176,575------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES674,903 787,409 980,445 1,351,818 506,015 307,547 955,588------------ ------------ ------------ ------------ ------------ ------------ ------------** CURB/SIDEWALK PROGRAM1,107,115 1,272,789 1,505,093 1,878,998 789,519 531,863 1,500,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** MOTOR VEHICHLE HWY FUND8,630,943 8,671,202 10,744,134 11,765,531 5,111,586 4,210,926 12,024,2188,630,943 8,671,202 10,744,134 11,765,531 5,111,586 4,210,926 12,024,218Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures61 City of South Bend, Indiana 2018 Budget Fund 101 - General Fund Department 0602 - Engineering 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Expenditures by Type Personnel Salaries & Wages 501,594 495,042 606,350 261,506 725,101 738,275 751,713 765,420 779,400 118,751 20% Fringe Benefits 173,760 168,830 235,286 94,689 246,488 251,355 259,163 267,279 275,715 11,202 5% Total Personnel 675,354 663,872 841,636 356,195 971,589 989,631 1,010,876 1,032,698 1,055,115 129,953 15% Supplies 25,596 53,808 34,113 11,364 31,600 31,800 31,800 32,550 32,550 (2,513) -7% Services & Charges Professional Services 83,475 138,698 221,250 41,713 150,000 150,000 150,000 150,500 150,500 (71,250) -32% Printing & Advertising 3,318 2,629 7,159 389 7,000 7,000 7,000 7,000 7,000 (159) -2% Utilities - - - - - - - - - - - Education & Training 10,446 15,977 21,263 3,477 21,000 21,000 21,000 21,000 21,000 (263) -1% Travel 14,960 12,304 14,900 7,014 14,900 14,900 14,900 14,900 14,900 - 0% Repairs & Maintenance 49,389 33,018 12,905 3,847 11,500 11,500 11,500 11,500 11,500 (1,405) -11% Other Interfund Allocations 45,427 50,116 239,770 119,880 329,860 335,600 335,600 335,600 335,600 90,090 38% Debt Service Principal 10,748 17,796 26,330 16,349 26,644 15,244 10,029 4,602 - 314 1% Interest & Fees 1,035 1,029 1,778 568 1,365 414 197 51 - (413) -23% Grants & Subsidies - - - - - - - - - - - Insurance 9,612 11,676 14,738 7,368 14,772 14,800 14,800 14,800 14,800 34 0% Transfers Out - - - - - - - - - - - Other Services & Charges 7,285 14,164 9,315 4,732 12,185 9,225 9,150 9,275 9,250 2,870 31% Total Services & Charges 235,695 297,407 569,408 205,336 589,226 579,683 574,176 569,227 564,550 19,818 3% Capital - - - - - - - - - - - Total Expenditures 936,645 1,015,087 1,445,157 572,895 1,592,415 1,601,114 1,616,853 1,634,476 1,652,215 147,258 10% Revenue Licenses & Permits - 35,583 100,000 60,380 100,500 101,000 101,500 102,000 102,500 500 1% Charges for Services - 3,000 - 5,802 12,000 12,500 13,000 13,500 14,000 12,000 - Interest Earnings - - - - - - - - - - - Donations - - - - - - - - - - - Other Income 6,858 39,256 217,337 400 220,167 224,449 228,817 233,273 237,817 2,830 1% Total Revenue 6,858 77,839 317,337 66,582 332,667 337,949 343,317 348,773 354,317 15,330 5% Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Engineering Department oversees the design and execution of the City's construction projects. Excluding the 2016 encumbrance rollovers for outstanding purchase orders (which shows as amended budget), the effective change for the 2018 budget is an increase of approximately $222,907. Of this change, $90,124 are for an increase of Allocation Charges, such as, Admin Fee, Central Stores, Print Shop, IT, and Liability Insurance. Personnel changes including all taxes and benefits account for approximately $130,212. Net impact to wages for the 3 additional employees represent $83,017, impact of 2% increase represents an increase of $10,956, with an increase in FICA, PERF, and other benefit of $10,918, $8,000 increase for the part time and intern programs, shift of allocations throughout Public Works increased wages for engineering by $4,711. The remaining $12K is a result of the actual versus budget for salary deductions which changed from $23,555 in 2017 to $11,300 in 2018. This allows the department to reward and acknowledge mid-year evaluations and review of employees. In 2018 supplies and contractuals show an increase of approximately $2,600. 62 City of South Bend, Indiana 2018 Budget Department 101-0602 - Engineering Accomplishments, Goals, KPI's 2017 Accomplishments & Outcomes - - - - - - - - - - 2018 Department Goals & Objectives and Linkage to City Results - - - - - - - - - - - - - - - - Key Performance Indicators (KPI's) Measure Type 2018 Long Term Goal 2015 Actual 2016 Estimated 2017 Target - - - - - - - Types: output, efficiency, effectiveness, quality, outcome, technology 2018 Significant Changes/Challenges/Opportunities - - - - - - - - - - Apply for LPA funding (90/10) to install Flashing Beacons in School Zones across the City Educate the public to create a bike and pedestrian friendly downtown Number of 311/Council Requests (Open/Closed) % Project Management Grades Drainage issues resulting from Subdivisions and bankrupt Developers have left the City with problems that require capital investment. Stormwater Fee - a common means for creating revenue to address storm water projects is needed. Downspout Disconnections - how will the City address the disregard for the Ordinance? Successful conversion of Main and Michigan/MLK downtown Hiring of the first Full-Time Asset Manager (Jeff Weaver) for Public Works Hiring of a new Full-Time Assistant City Engineer (Sue Ellen Doudrick) to focus on Water and Drainage Successful implementation of System Development Charges (SDCs) by the Permits Office Providing engineering support for various City Departments Resolution for School Zone Flashing Beacons 2017 Community Crossing Grant funding for improvements on Ironwood and Edison Roads Completion and implementation of the Neighborhood Traffic Calming Policy Implement Neighborhood Traffic Calming Policy Implementation of new City Standards and Specifications Address drainage service requests throughout the City with dedicated funding Implementation of an online Permitting software system for the ease of doing business with the City Implementation of a city-wide storm water fee to address storm water projects in the City Continued engineering project management and assistance to various City Departments Creation of a standardized method for asset inventory and management tool for decision making in 2018 63 City of South Bend, Indiana 2018 Budget Department 101-0602 - Engineering 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 Director of Public Works 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Deputy Director of Public Works 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 City Engineer 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Assistant City Engineer 2.0 1.0 1.0 1.0 2.0 2.0 2.0 2.0 Engineer I (80% TIF funded)1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Engineer I 1.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 Exec Assist & Director of Special Projects 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Manager - Public Construction 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Permits Manager 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Administrative Assistant I - 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Administrative Assistant II 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Services (Asset Manager)- - - 1.0 1.0 1.0 1.0 1.0 Redevelopment Engineer (100% TIF funded)- 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Project Inspector II 4.0 3.0 3.0 3.0 3.0 3.0 3.0 3.0 Secretary V 1.0 - - - - - - - Public Information Officer - - - 1.0 1.0 1.0 1.0 1.0 Total Non-Bargaining 16.0 18.0 18.0 20.0 21.0 21.0 21.0 21.0 Bargaining Total Bargaining - - - - - - - - Total Full-Time Employees 16.0 18.0 18.0 20.0 21.0 21.0 21.0 21.0 Explain Significant Staffing Changes Below: In 2017, two position were brought on board with engineering, Director of Operations (Assets) and Assistant City Engineer. These two positions are not reflected in 2017 budget detail. For 2018 we are proposing to add one new position, Public information Officer. 2018 shows a net increase of 3 for engineering staff. As in 2017, 2018 will repeat the billing of two positions, Engineer I and Director of Redevelopment Engineer, to tax increment financing funds. 64 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueGENERAL FUND101-0602-322.10-00 ENGINEERING0 35,583 100,000 100,000 69,335 60,380 100,500LEVEL TEXTTEXT AMT02 ENGINEERING REVENUE: PERMITS100,500100,500101-0602-322.10-10 SPECIFICATIONS0 3,00000 5,927 5,802 12,000LEVEL TEXTTEXT AMT02 ENGINEERING: SPECIFICATIONS12,00012,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 38,583 100,000 100,000 75,262 66,182 112,500101-0602-360.00-00 MISCELLANEOUS REVENUE4,299 4,817 10,000 10,000625400 6,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS ENGINEERING REIMBURSEMENTS, 20186,0006,000------------ ------------ ------------ ------------ ------------ ------------ ------------*4,299 4,817 10,000 10,000625400 6,000101-0602-380.10-19 BLUEPRINTS/COPIES451001000050LEVEL TEXTTEXT AMT02 BLUEPRINTS, COPIES, 20185050101-0602-380.10-22 STATE PROJECTS00 3,000 3,000000101-0602-380.10-99 MISC. REIMBURSEMENTS2,555 34,434 204,237 204,23700 214,117LEVEL TEXTTEXT AMT02 RIVER WEST TIF REIMB OF ENGINEER I78,320REDEVELOPMENT ENGINEER 100% TIF FUNDED135,797PER THE ENGINEERING SERVICES AGREEMENT214,117------------ ------------ ------------ ------------ ------------ ------------ ------------*2,559 34,439 207,337 207,33700 214,167------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING6,858 77,839 317,337 317,337 75,887 66,582 332,667------------ ------------ ------------ ------------ ------------ ------------ ------------*** GENERAL FUND6,858 77,839 317,337 317,337 75,887 66,582 332,667101-0602 Engineering DeptCity of South BendRevenue65 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresGENERAL FUND101-0602-431.10-01 REGULAR WAGES424,336 423,611 547,844 547,844 291,413 247,946 658,715LEVEL TEXTTEXT AMT02 1 DIR OF PUBLIC WORKS (119,515 X 12%)14,3421 DEPUTY DIR PUBLIC WORKS (97,419 X 12%)*11,6901 CITY ENGINEER (104,336 X 47%)49,0381 ASST CITY ENGINEER (83,890 X 47%)*39,4281 ASST CITY ENGINEER (83,890 X 15%)12,5841 ADMIN ASST II (41,724 X 47%)*19,6101ENGINEERI-TIF-FUNDED(100%)*67,9174 ENGINEER I (4 X $67,917 X 47%)**127,6841 EXEC ASST & DIR SPEC PROJ (54,168 X 15%)*8,1251 MGR - PUBLIC CONST (67,725 X 47%)*31,8311 PERMITS MANAGER (49,425 X 47%)*23,2303 PROJECT INSPECTORS (3 X 54,195 X 47%)***76,4161 ADMIN ASST I (40,525 X 47%)19,0471 DIRECTOR OF REDEVELOPMENT ENGINEERING - TIF 100%99,1831 DIRECTOR OF OPERATIONS:ASSETS ($83,000 X 47%)*39,0091 PUBLIC INFORMATION OFFICER ($65,704 X 47%)30,881DEDUCTION FOR ACTUAL11,300-658,715101-0602-431.10-03 SEASONAL & INTERNS16,616 43,218 37,440 37,440 11,474 7,756 37,440LEVEL TEXTTEXT AMT02 2018 ENGINEERING INTERN PROGRAM:37,4406 INTERNS, $13/HR, 40 HRS X 12 WEEKS37,440101-0602-431.10-04 EXTRA AND OVERTIME130 1,883002691560101-0602-431.10-09 PERMANENT PART-TIME60,512 26,330 21,066 21,066 6,991 5,648 28,946LEVEL TEXTTEXT AMT02 PT ASST CITY ENGINEER ($44,822 X 47%)21,066PT SECRETARY V ($16,765 X 47%)7,88028,946101-0602-431.11-01 FICA - REGULAR37,586 37,620 46,387 46,387 23,818 20,102 56,335LEVEL TEXTTEXT AMT02 ALL SALARIES - $736,400.88 X 7.65%56,33556,335101-0602-431.11-04 PERF - REGULAR46,331 47,122 61,359 61,359 32,348 27,563 75,042LEVEL TEXTTEXT AMT02 REGULAR SALARIES - $670,014.88 X 11.2%75,042101-0602 Engineering DeptCity of South BendExpenditures66 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures75,042101-0602-431.11-07 UNEMPLOYMENT COMP1,323728 1,516 1,516000LEVEL TEXTTEXT AMT02 ALL WAGES - $706,306 X 0.25% (EXEMPT IN 2018)101-0602-431.11-08 HEALTH INSURANCE79,535 76,440 117,816 117,816 50,153 42,681 103,282LEVEL TEXTTEXT AMT02 HEALTH INSURANCE - 5.97 FTE X $16,200 = $96,714103,282LTD 9.59 FTE X $96 = $921INSURANCE REBATE - 3.62 FTE X $1,560 =$5,647103,282101-0602-431.11-09 LIFE INSURANCE865808 1,016 1,016531447 1,151LEVEL TEXTTEXT AMT02 LIFE INSURANCE - 9.59 FTE X $1201,1511,151101-0602-431.11-11 SHOE ALLOWANCE2412552605206565260LEVEL TEXTTEXT AMT02 SHOE ALLOWANCE - 4 X $65260260101-0602-431.11-12 AUTO ALLOWANCE1,658 1,869 2,010 2,010 1,415 1,207 2,841LEVEL TEXTTEXT AMT02 DIR OF PUBLIC WORKS (6,000 X 12%)720DEPUTY DIRECTOR OF PUBLIC WORKS ($2,400 X 12%)288CITY ENGINEER (2,400 X 47%)1,128ASST CITY ENGINEER (1,500 X 47%)7052,841101-0602-431.11-22 PARKING ALLOWANCE2,619420420420770560 1,260LEVEL TEXTTEXT AMT02 3 EMPLOYEES:PERSON @ $35/MONTHDEPUTY DIR (1 @ $35/MONTH)420CITY ENGINEER (1 @ $35/MONTH)420EXEC ASST $ DIR OF SPEC OPERATION (1 @ $35/MONTH)4201,260101-0602-431.11-24 CELL PHONE ALLOWANCE3,602 3,568 4,242 4,242 2,442 2,065 4,642LEVEL TEXTTEXT AMT02 ALL PHONE ALLOCATIONS $660 ANNUALLY101-0602 Engineering DeptCity of South BendExpenditures67 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresDIRECTOR PUB WKS (12%)79DEP DIR PUB WKS (12%)79CITY ENGINEER (47%)3101 ASST CITY ENGINEER (47% EACH)3101 ASST CITY ENGINEER ($660 @ 15%)994 ENGINEER I (47%)584ENGINEER I - TIF FUNDED660PUBLIC CONSTRUCTION MGR (47%)310DIRECTOR OF OPERATIONS: ASSETS 47%)3103 PROJECT INSPECTOR 47% EACH)931PUBLIC INFORMATION OFFICER (47%)310REDEVELOPMENT ENGINEER6604,642101-0602-431.11-29 PARENTAL LEAVE000000 1,675LEVEL TEXTTEXT AMT02 PARENTAL LEAVE PROGRAM ($670,014.88 X 0.25%)1,6751,675------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES675,354 663,872 841,376 841,636 421,689 356,195 971,589101-0602-431.21-01 OFFICIAL RECORDS404427500500572572750LEVEL TEXTTEXT AMT02 ESTIMATED COSTS BASED ON TRENDS750USED TO PAY ST JOSEPH COUNTY RECORDER AND OTHERITEMS750101-0602-431.21-02 PRINT SHOP3,330352500500467139400LEVEL TEXTTEXT AMT02 MISCELLANEOUS PRINTING SUPPLIES400400101-0602-431.21-03 C.S. OFFICE SUPPLIES997 1,165 1,500 1,500500376 1,250LEVEL TEXTTEXT AMT02 ESTIMATED CENTRAL SERVICE OFFICE SUPPLIES1,2501,250101-0602-431.21-04 OTHER OFFICE SUPPLIES5,235 3,843 4,500 5,069 2,606 2,485 5,000LEVEL TEXTTEXT AMT02 SUPPLIES PURCHASE FROM OTHER THAN CENTRAL STORES5,000ESTIMATE BASED ON TRENDS, BLANKET PO ISSUED TO101-0602 Engineering DeptCity of South BendExpenditures68 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresOFFICE MAX5,000101-0602-431.21-05 SMALL OFFICE EQUIPMENT1,721 14,622 5,000 5,160566169 4,600LEVEL TEXTTEXT AMT02 SMALL OFFICE EQUIPMENT INCLUDING SMALL FURNTIURE4,600SUCH AS CHAIRS, KEYBOARD TRAYS, OVERHEAD CABINETS,ETC.4,600101-0602-431.22-01 CENTRAL SERVICE GASOLINE2,023 1,391 1,500 1,500963858 1,750LEVEL TEXTTEXT AMT02 2018 ESTIMATE PER CENTRAL SERVICES1,750ESTIMATED PRICE PER GALLON OF $2.501,750101-0602-431.22-24 OTHER OPERATING SUPPLIES0004429879870101-0602-431.22-60 COMPUTER SUPPLIES/EQUIP 10,997 11,270 11,000 12,142 5,381 5,381 10,750LEVEL TEXTTEXT AMT02 NEW COMPUTER EQUIPMENT INCLUDES UPGRADES FOR10,750HAND-HELD DEVICES FOR STAFF10,750101-0602-431.23-20 SMALL TOOLS & EQUIPMENT889 20,328 5,300 5,300330330 5,300LEVEL TEXTTEXT AMT02 2018 ESTIMATE OF R&M5,3005,300101-0602-431.23-99 OTHER R&M SUPPLIES0410 2,000 2,0006767 1,800LEVEL TEXTTEXT AMT02 ESTIMATED COSTS1,8001,800------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES25,596 53,808 31,800 34,113 12,439 11,364 31,600101-0602-431.31-01 LEGAL SERVICES4,8600 10,000 10,00000 10,000LEVEL TEXTTEXT AMT02 ESTIMATED LEGAL SERVICES10,00010,000101-0602-431.31-06 OTHER PROFESSIONAL SVCS 78,615 138,698 140,000 211,250 41,878 41,713 140,000101-0602 Engineering DeptCity of South BendExpenditures69 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 STORMWATER SERVICES40,000TRANSPORTATION STUDIES40,000OTHER SERVICES AS THEY ARISE60,000140,000101-0602-431.31-70 ADM FEE ALLOCATION00 38,691 38,691 22,568 19,344 45,997LEVEL TEXTTEXT AMT02 2018 ADMIN ALLOCATION45,997(2017 - $38,691)45,997101-0602-431.31-71 CENTRAL STORES ALLOCATION809744660660385330 1,600LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION1,600CENTRAL STORES(2017 - $660)1,600101-0602-431.31-72 GIS ALLOCATION36,759 38,59600000101-0602-431.31-73 PRINT SHOP ALLOCATION0 2,448 2,753 2,753 1,603 1,374 2,962LEVEL TEXTTEXT AMT02 2018 PRINT SHOP ALLOCATION2,962(2017-$2,753)2,962101-0602-431.31-76 IT ALLOCATION000000 279,301LEVEL TEXTTEXT AMT02 2018 IT ALLOCATION NOW INCLUES INNOVATION OFFICE,279,301GIS, AND IT(2017-$197,666)279,301101-0602-431.32-02 POSTAGE1,830 1,532 2,000 2,000806695 2,000LEVEL TEXTTEXT AMT02 BOARD OF PUBLIC WORKS AND ENGINEERING POSTAGE2,000ESTIMATE BASED ON TRENDS2,000101-0602-431.32-03 TRAVEL1,570000000101-0602-431.32-21 TRAVEL - MILEAGE1,094 1,765 2,000 2,000305305 2,000LEVEL TEXTTEXT AMT101-0602 Engineering DeptCity of South BendExpenditures70 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 ESTIMATED MILEAGE PAID WHEN USING PERSONAL VEHICLE2,0002,000101-0602-431.32-22 TRAVEL - AIRFARE3,159 2,953 3,000 3,000 3,091 2,105 3,000LEVEL TEXTTEXT AMT02 AIRFARE AND OTHER LONG DISTANCE TRANSPORTATION3,0003,000101-0602-431.32-23 TRAVEL - HOTEL7,054 6,122 8,000 8,000 3,973 3,973 8,000LEVEL TEXTTEXT AMT02 HOTEL EXPENDITURES, ESTIMATED8,0008,000101-0602-431.32-24 TRAVEL - MEALS1,383 1,141 1,500 1,500429313 1,500LEVEL TEXTTEXT AMT02 TRAVEL MEALS BASED ON PER DIEM1,5001,500101-0602-431.32-25 TRAVEL - OTHER700323400400431319400LEVEL TEXTTEXT AMT02 INCLUDES CONFERENCE REGISTRATION FEES400400101-0602-431.33-01 OUTSIDE PRINTING SERVICES 2,818 2,360 5,000 5,159330330 5,000LEVEL TEXTTEXT AMT02 ANY MATERIAL PRINTED BY OUTSIDE VENDORS5,0005,000101-0602-431.33-02 PUBLICATION LEGAL NOTICE500269 2,000 2,0005959 2,000LEVEL TEXTTEXT AMT02 LEGAL ADVERTISING & JOBS BID FOR BOARD OF PUBLIC2,000WORKS - THIS INCLUDES COSTS THAT CAN NOT BE PAIDDIRECTLY BY THE DEPARTMENT REQUESTING THE PROJECT2,000101-0602-431.34-02 LIABILITY INSURANCE9,612 11,676 14,738 14,738 8,596 7,368 14,772LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION14,772LIABILITY INSURANCE(2017-$14,738)14,772101-0602 Engineering DeptCity of South BendExpenditures71 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0602-431.36-01 BUILDING & STREET MAINT 18,300 21,653 5,000 5,00000 5,000LEVEL TEXTTEXT AMT02 BASIC REPAIRS5,0005,000101-0602-431.36-02 OFFICE EQUIP R&M28,269 4,198 2,500 3,905 2,258 2,035 2,500LEVEL TEXTTEXT AMT02 ESTIMATED COSTS OF OFFICE EQUIPMENT REPAIR2,500NOT TO BE USED FOR EQUIPMENT PURCHASES2,500101-0602-431.36-03 AUTO EQUIPMENT R&M2,768 6,855 4,000 4,000 2,507 1,812 4,000LEVEL TEXTTEXT AMT02 ESTIMATED COSTS4,0004,000101-0602-431.36-04 COMPUTER EQUIP R&M7,859 8,640 197,666 197,666 115,304 98,8320101-0602-431.36-06 RADIO EQUIP R&M52000000LEVEL TEXTTEXT AMT02 RADIO EXPENDITURES NO LONGER ALLOCATED; ESTIMATE6,0006,000101-0602-431.37-11 CAPITAL LEASE PRINCIPAL 10,748 17,796 26,330 26,330 22,426 16,349 26,644LEVEL TEXTTEXT AMT02 CURRENT LEASES:2013 VEHICLES #1105,0622013 PLOTTER/SCANNER #1112,4582014 VEHICLES #1243,9792015 VEHICLES #1401,7152015 VEHICLES-2 #1445,0692016 VEHICLES #1524,252NEW LEASES:2017 PLOTTER/SCANNER, CAR (CNG-FUELED)4,10926,644101-0602-431.37-12 CAPITAL LEASE INTEREST1,035 1,029 1,778 1,778817568 1,365LEVEL TEXTTEXT AMT02 CURRENT LEASES:2013 VEHICLES #110462013 PLOTTER/SCANNER #1111342014 VEHICLES #124108101-0602 Engineering DeptCity of South BendExpenditures72 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures2015 VEHICLES #140662015 VEHICLES-2 #1442192016 VEHICLES-2 #152249NEW LEASES2017 PLOTTER/SCANNER, CAR (CNG-FUELED)5431,365101-0602-431.39-01 REFNDS,AWARDS,INDEMNITIES 1,320 8,29300 2,290 2,2900101-0602-431.39-10 SUBSCRIPTIONS5611669159151720900LEVEL TEXTTEXT AMT02 ZOHO REPORTS540SOUTH BEND TRIBUNE160OTHER200900101-0602-431.39-11 DUES & MEMBERSHIPS2,247 2,616 4,000 4,000 1,414 1,414 3,900LEVEL TEXTTEXT AMT02 ASCE1,000IMSA100IACE100IWEA/WEF, 3 @ $150 EACH450APWA500OTHER1,7503,900101-0602-431.39-39 BANK CREDIT CARD CHARGES608494400400273209515LEVEL TEXTTEXT AMT02 MONTHLY CHARGES DUE TO CREDIT CARD MACHINE515515101-0602-431.39-70 EDUCATION & TRAINING10,446 15,977 21,000 21,263 4,292 3,477 21,000LEVEL TEXTTEXT AMT02 INCLUDESS TRAINING AT IACT, PURDUE UNIVERSITY,21,000ASCE, APWA.INCREASED TRAINING DUE TO INCLUSION OF TWOWWTP EMPLOYEES AND INTERN TRAINING21,000101-0602-431.39-89 MISC CHARGES & SVCS719 1,063 2,000 2,000161124 4,870LEVEL TEXTTEXT AMT02 MISC. EXPENSES NOT COVERED ELSEWHERE1,900AT&T MOBILITY:IPAD: 220-7519495101-0602 Engineering DeptCity of South BendExpenditures73 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresIPAD: 220-7521495IPAD: 220-75495IPAD: 855-6245495IPAD: 904-6769495IPAD: 993-18024954,870------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES235,695 297,407 496,331 569,408 236,368 205,336 589,226------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING936,645 1,015,087 1,369,507 1,445,157 670,496 572,895 1,592,415------------ ------------ ------------ ------------ ------------ ------------ ------------*** GENERAL FUND936,645 1,015,087 1,369,507 1,445,157 670,496 572,895 1,592,415936,645 1,015,087 1,369,507 1,445,157 670,496 572,895 1,592,415101-0602 Engineering DeptCity of South BendExpenditures74 City of South Bend, Indiana 2018 Budget Fund 251 - Local Roads & Streets 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 Other Taxes 1,045,516 1,046,446 1,068,000 546,751 1,570,000 1,600,000 1,650,000 1,700,000 1,700,000 502,000 47% Grants/Intergovernmental - 162,655 256,000 89,299 280,000 250,000 200,000 175,000 150,000 24,000 9% Interest Earnings 15,179 27,338 20,000 13,061 18,000 18,100 18,150 18,200 18,250 (2,000) -10% Other Income 446,360 405,709 330,275 4,575 - - - - - (330,275) -100% Transfers In - - - - - - - - - - - Total Revenue 1,507,055 1,642,148 1,674,275 653,686 1,868,000 1,868,100 1,868,150 1,893,200 1,868,250 193,725 12% Expenditures by Type Supplies 357,704 469,122 500,378 128,503 670,000 550,000 550,000 550,000 550,000 169,622 34% Services & Charges Professional Services 11,000 22,900 20,000 - 30,000 30,000 30,000 30,000 30,000 10,000 50% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - 299,840 774,905 74,682 750,000 750,000 750,000 750,000 750,000 (24,905) -3% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 11,000 322,740 794,905 74,682 780,000 780,000 780,000 780,000 780,000 (14,905) -2% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 855,424 747,625 916,261 223,986 600,000 600,000 600,000 600,000 600,000 (316,261) -35% Total Capital 855,424 747,625 916,261 223,986 600,000 600,000 600,000 600,000 600,000 (316,261) -35% Total Expenditures 1,224,128 1,539,487 2,211,544 427,171 2,050,000 1,930,000 1,930,000 1,930,000 1,930,000 (161,544) -7% Net Surplus / (Deficit)282,927 102,661 (537,269) 226,515 (182,000) (61,900) (61,850) (36,800) (61,750) Beginning Cash Balance 2,441,825 2,723,225 2,825,065 2,287,796 2,105,796 2,043,896 1,982,046 1,945,246 Cash Reserve Cash Adjustments (1,527) (821) - - - - - - Ending Cash Balance 2,723,225 2,825,065 2,287,796 2,105,796 2,043,896 1,982,046 1,945,246 1,883,496 Cash Reserves Target 244,826 384,872 552,886 512,500 482,500 482,500 482,500 482,500 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 25% of Annual expenditures This fund is used to track expenditures for road projects. In 2008, wheel tax revenue was moved from this fund to the Motor Vehicle Highway Fund (202). This fund receives gas taxes as its primary revenue source. The most significant change for this fund is the increase of approximately $500,000 for the anticipated receipt of revenue from State Gasoline Tax. Other Income is made up of insurance reimbursements and miscellaneous reimbursements. The City received a reimbursement from INDOT for State Road 933 in the amounts of $404,537 in 2015 and $367,660 in 2016. The 2018 budget for other income has been reduced based upon year to date actual revenue. Capital spending is reduced based on 2018 budget allowance for Traffic Calming Devices and small drainage projects. 75 City of South Bend, Indiana2018 BudgetFund 251 - Local Roads & StreetsFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalTraffic Calming DevicesCash100,000 - - - - 100,000 Drainage ProjectsCash500,000 - - - - 500,000 Total Project Capital600,000 - - - - 600,000 Minimum Thresholds:Total Capital600,000 - - - - 600,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:76 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueLOCAL ROADS & STREETS251-0000-331.03-03 INDOT GRANTS0 162,655 256,000 256,000 89,299 89,299 280,000LEVEL TEXTTEXT AMT02 REIMBURSEMENT FOR INDOT PROJECTS 2018280,000INDOT PAYS APPROXIMATELY 3 MONTHS AFTERREIMBURSEMENT REQUEST SUBMITTED280,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 162,655 256,000 256,000 89,299 89,299 280,000251-0000-335.08-00 GASOLINE TAX-L. RDS. & ST 1,045,516 1,046,446 1,068,000 1,068,000 648,434 546,751 1,570,000LEVEL TEXTTEXT AMT02 HEA 1002 INCREASED ROAD FUNDING - 49.3% INCREASE 1,570,000FISCAL YEAR 7/1 TO 6/30 PLUS 49.3%$1,051,771 + $518,2291,570,000------------ ------------ ------------ ------------ ------------ ------------ ------------*1,045,516 1,046,446 1,068,000 1,068,000 648,434 546,751 1,570,000251-0000-360.51-00 INSURANCE REIMBURSEMENT 41,823 38,0490275 4,087 4,0870------------ ------------ ------------ ------------ ------------ ------------ ------------*41,823 38,0490275 4,087 4,0870251-0000-361.00-00 INTEREST EARNINGS15,179 27,338 20,000 20,000 17,017 13,061 18,000LEVEL TEXTTEXT AMT02 INTEREST EARNINGS BASED ON TRENDS18,00018,000------------ ------------ ------------ ------------ ------------ ------------ ------------*15,179 27,338 20,000 20,000 17,017 13,061 18,000251-0000-380.10-77 INDOT SR 933 TRANSFER000 330,000000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 330,000000------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS1,102,518 1,274,488 1,344,000 1,674,275 758,837 653,198 1,868,000Fund 251 - Local Roads & StreetsCity of South BendRevenue77 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue251-0608-380.10-99 MISC. REIMBURSEMENTS404,537 367,660004884880------------ ------------ ------------ ------------ ------------ ------------ ------------*404,537 367,660004884880------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS404,537 367,660004884880------------ ------------ ------------ ------------ ------------ ------------ ------------*** LOCAL ROADS & STREETS1,507,055 1,642,148 1,344,000 1,674,275 759,325 653,686 1,868,0001,507,055 1,642,148 1,344,000 1,674,275 759,325 653,686 1,868,000Fund 251 - Local Roads & StreetsCity of South BendRevenue78 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLOCAL ROADS & STREETS251-0608-431.22-30 TRAFFIC/SIGN/OTHER000 50,000000251-0608-431.23-02 STREET MATERIAL357,704 469,122 450,000 450,378 415,246 128,503 670,000LEVEL TEXTTEXT AMT02 STREET PAVING - TO SUPPLEMENT THE MVH FUND 202550,000MEDIAN CHANNELIZATION DEVICES120,000670,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES357,704 469,122 450,000 500,378 415,246 128,503 670,000251-0608-431.31-06 OTHER PROFESSIONAL SVCS 11,000 22,900 20,000 20,00000 30,000LEVEL TEXTTEXT AMT02 MACOG, FOR TRAFFIC COUNTERS30,00030,000251-0608-431.36-10 STREET MAINTENANCE0 85,755 250,000 250,000 22,691 6,970 300,000LEVEL TEXTTEXT AMT02 VARIOUS MAINTENANCE PROJECTS-STREET MAINTENANCE250,000-MARKING MAINTENANCE50,000300,000251-0608-431.36-67 TRAFFIC SIGNAL MAINT0 214,085 450,000 524,905 67,712 67,712 450,000LEVEL TEXTTEXT AMT02 TRAFFIC SIGNAL MAINTENANCE450,000450,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES11,000 322,740 720,000 794,905 90,403 74,682 780,000251-0608-431.42-93 LANE MARKING00 50,000 50,000000LEVEL TEXTTEXT AMT02 SPECIALTY MARKINGS (BIKE LANES, ETC.)251-0608-431.42-96 MAJOR PROJECTS855,424 747,625 270,000 866,261 306,063 223,986 600,000LEVEL TEXTTEXT AMT02 TRAFFIC CALMING DEVICES100,000DRAINAGE PROJECTS500,000600,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL855,424 747,625 320,000 916,261 306,063 223,986 600,000Fund 251 - Local Roads & StreetsCity of South BendExpenditures79 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS1,224,128 1,539,487 1,490,000 2,211,544 811,712 427,171 2,050,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** LOCAL ROADS & STREETS1,224,128 1,539,487 1,490,000 2,211,544 811,712 427,171 2,050,0001,224,128 1,539,487 1,490,000 2,211,544 811,712 427,171 2,050,000Fund 251 - Local Roads & StreetsCity of South BendExpenditures80 City of South Bend, Indiana 2018 Budget Fund 257 - LOIT Special Distribution 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 Local Income Taxes - 4,217,549 - - - - - - - - - Grants/Intergovernmental - - 1,278,000 - 2,200,000 - - - - 922,000 72% Interest Earnings - - 40,000 16,892 40,000 - - - - - 0% Other Income - 130,394 153,000 205,397 - - - - - (153,000) -100% Transfers In - - - - - - - - - - - Total Revenue - 4,347,943 1,471,000 222,289 2,240,000 - - - - 769,000 52% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - 852,100 60,158 - - - - - (852,100) -100% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - 1,000,000 1,000,000 - - - - - (1,000,000) -100% Other Services & Charges - - - - - - - - - - - Total Services & Charges - - 1,852,100 1,060,158 - - - - - (1,852,100) -100% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure - 322,876 1,905,357 181,456 2,950,000 - - - - 1,044,643 55% Total Capital - 322,876 1,905,357 181,456 2,950,000 - - - - 1,044,643 55% Total Expenditures - 322,876 3,757,457 1,241,614 2,950,000 - - - - (807,457) -21% Net Surplus / (Deficit)- 4,025,067 (2,286,457) (1,019,325) (710,000) - - - - Beginning Cash Balance - - 4,025,066 1,738,609 1,028,609 1,028,609 1,028,609 1,028,609 Cash Reserve Cash Adjustments - (1) - - - - - - Ending Cash Balance - 4,025,066 1,738,609 1,028,609 1,028,609 1,028,609 1,028,609 1,028,609 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was established in 2016, per the State Board of Accounts (SBOA), to receive a one-time payment of local income taxes from the State for the purpose of infrastructure expenditures. Per the state statute, a minimum of 75% must be spent on infrastructure projects. The remainder was deposited into the Rainy Day Fund (102). The most significant change in this fund for 2018 is the Community Crossing Grant for work to be done on Ironwood and State Road 23 to Corby. The matching grant provides $1M in revenue with an estimated project cost of $2.3M. Expenses for Professional Services are anticipated lower as a result of projects going into the construction phase. 81 City of South Bend, Indiana2018 BudgetFund 257 - LOIT Special DistributionFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalBendix Drive, Lathrop Road to the south end of the bridges over the Indiana Toll RoadCash100,000 - - - - 100,000 Road reconstruction, to improve safety and road conditionOlive Street, Prairie Avenue (State Road 23) north to Tucker Drive Cash100,000 - - - - 100,000 Pavement replacement, improve road condition and traffic flowSafe Routes to School (SRTS), LaSalle Intermediate/Marquette Primary Cash450,000 - - - - 450,000 Improve the sidewalks and curb ramps in the area around and between the schools, to improve safetyCommunity Crossing Grant, Ironwood from State Road 23 to Corby Cash1,300,000 - - - - 1,300,000 Replace and improve deteriorating pavement in the City, this portion funded by CityCommunity Crossing Grant, Ironwood from State Road 23 to Corby Grant1,000,000 - - - - 1,000,000 Replace and improve deteriorating pavement in the City, this portion funded by Grant dollarsTotal Project Capital2,950,000 - - - - 2,950,000 Minimum Thresholds:Total Capital2,950,000 - - - - 2,950,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:The Community Crossing project is made possible by a 50/50 matching grant, up to max of $1 million with the State of Indiana. This is a simpler and more efficient revenue stream (a one year cycle) that allows a shovel-ready project out to bid. The City's target is a $2 million project to maximize the cost-share.82 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueLOIT 2016 SPECIAL DIST257-0000-316.10-00 SPECIAL DISTRIBUTION0 4,217,54900000------------ ------------ ------------ ------------ ------------ ------------ ------------*0 4,217,54900000257-0000-361.00-00 INTEREST EARNINGS00 40,000 40,000 20,738 16,892 40,000LEVEL TEXTTEXT AMT02 INTEREST INCOME40,00040,000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 40,000 40,000 20,738 16,892 40,000------------ ------------ ------------ ------------ ------------ ------------ ------------** LOIT 2016 SPECIAL DIST0 4,217,549 40,000 40,000 20,738 16,892 40,000Fund 257 - LOIT 2016 Special DistributionCity of South BendRevenue83 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue257-0608-331.03-03 INDOT GRANTS00 1,278,000 1,278,00000 2,200,000LEVEL TEXTTEXT AMT02 INDOT REIMBURSEMENTS FOR ELIGIBLE CONSTRUCTIONPROJECTS - PAID APPROX. 1-3 MONTHS AFTER INVOICESUBMITTAL (ASSUME 75% LAG FACTOR)COMM CROSSING GRANT-IRONWOOD, SR23 TO CORBY1,000,000SRTS, MONROE/STUDE, $1M X 80% X 75%600,000SRTS, LASALLE/MARQ $1M X 80% X 75%600,000BOLAND TRAIL, $280K X 80% X 75% FD251BENDIX,LATHROP->I-80, $900K MILL X 80% X 75% FD2512,200,000------------ ------------ ------------ ------------ ------------ ------------ ------------*00 1,278,000 1,278,00000 2,200,000257-0608-380.10-99 MISC. REIMBURSEMENTS0 130,3940 153,000 205,397 205,3970------------ ------------ ------------ ------------ ------------ ------------ ------------*0 130,3940 153,000 205,397 205,3970------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS0 130,394 1,278,000 1,431,000 205,397 205,397 2,200,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** LOIT 2016 SPECIAL DIST0 4,347,943 1,318,000 1,471,000 226,135 222,289 2,240,0000 4,347,943 1,318,000 1,471,000 226,135 222,289 2,240,000Fund 257 - LOIT 2016 Special DistributionCity of South BendRevenue84 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLOIT 2016 SPECIAL DIST257-0608-431.31-06 OTHER PROFESSIONAL SVCS000 852,100 109,315 60,1580------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000 852,100 109,315 60,1580257-0608-431.42-96 MAJOR PROJECTS0 322,876 2,130,000 1,905,357 213,317 181,456 2,950,000LEVEL TEXTTEXT AMT02 BENDIX, LATHROP -> I-80100,000OLIVE ROAD: PRAIRIE TO TUCKER100,000SRTS, LASALLE/MARQUETTE450,000COMM CROSSING: IRONWOOD,SR23 TO CORBY2,300,000BOLAND TRAIL-280000SRTS, MONROE/STUDEBAKER-4250002,950,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL0 322,876 2,130,000 1,905,357 213,317 181,456 2,950,000257-0608-452.50-02 INTER-FUND OPER. TRANSFRS000 1,000,000 1,000,000 1,000,0000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES000 1,000,000 1,000,000 1,000,0000------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS0 322,876 2,130,000 3,757,457 1,322,632 1,241,614 2,950,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** LOIT 2016 SPECIAL DIST0 322,876 2,130,000 3,757,457 1,322,632 1,241,614 2,950,0000 322,876 2,130,000 3,757,457 1,322,632 1,241,614 2,950,000Fund 257 - LOIT 2016 Special DistributionCity of South BendExpenditures85 City of South Bend, Indiana 2018 Budget Fund 265 - Local Road & Bridge Grant 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 Grants/Intergovernmental - - 1,000,000 1,000,000 - - - - - (1,000,000) -100% Interest Earnings - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - 1,000,000 1,000,000 - - - - - (1,000,000) -100% Total Revenue - - 2,000,000 2,000,000 - - - - - (2,000,000) -100% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - 2,000,000 - - - - - - (2,000,000) -100% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - 2,000,000 - - - - - - (2,000,000) -100% Capital - - - - - - - - - - - Total Expenditures - - 2,000,000 - - - - - - (2,000,000) -100% Net Surplus / (Deficit)- - - 2,000,000 - - - - - Beginning Cash Balance - - - - - - - - Cash Reserve Cash Adjustments - - - - - - - - Ending Cash Balance - - - - - - - - Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was established in December 2016 to account for the receipt of the Community Crossings grant and matching revenue and for the payment of expenditures on eligible projects, per the Indiana State Board of Accounts. 86 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueLOCAL ROAD & BRIDGE GRANT265-0608-331.03-03 INDOT GRANTS000 1,000,000 1,000,000 1,000,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 1,000,000 1,000,000 1,000,0000265-0608-392.00-00 INTERFUND OPER. TRANSFER000 1,000,000 1,000,000 1,000,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 1,000,000 1,000,000 1,000,0000------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS000 2,000,000 2,000,000 2,000,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*** LOCAL ROAD & BRIDGE GRANT000 2,000,000 2,000,000 2,000,0000000 2,000,000 2,000,000 2,000,0000Fund 265 - Local Road & Bridge GrantCity of South BendRevenue87 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLOCAL ROAD & BRIDGE GRANT265-0608-431.36-10 STREET MAINTENANCE000 2,000,0006400------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES000 2,000,0006400------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS000 2,000,0006400------------ ------------ ------------ ------------ ------------ ------------ ------------*** LOCAL ROAD & BRIDGE GRANT000 2,000,0006400000 2,000,0006400Fund 265 - Local Road & Bridge GrantCity of South BendExpenditures88 City of South Bend, Indiana 2018 Budget Fund 412 - Major Moves Construction 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 - - - - - - - - - - - Interest Earnings 19,069 21,524 25,000 12,107 25,000 25,000 26,000 27,000 28,000 - 0% Other Income 786,187 1,355,375 1,028,786 596,589 493,178 493,178 493,178 493,178 493,178 (535,608) -52% Transfers In - - - - - - - - - - - Total Revenue 805,256 1,376,899 1,053,786 608,696 518,178 518,178 519,178 520,178 521,178 (535,608) -51% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - 31,191 1,468,808 1,514 750,000 - - - - (718,808) -49% Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - 31,191 1,468,808 1,514 750,000 - - - - (718,808) -49% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment 31,990 - - - - - - - - - - Infrastructure 2,257,939 1,138,607 1,001,900 - 1,300,000 - - - - 298,100 30% Total Capital 2,289,929 1,138,607 1,001,900 - 1,300,000 - - - - 298,100 30% Total Expenditures 2,289,929 1,169,798 2,470,708 1,514 2,050,000 - - - - (420,708) -17% Net Surplus / (Deficit)(1,484,673) 207,101 (1,416,922) 607,182 (1,531,822) 518,178 519,178 520,178 521,178 Beginning Cash Balance 3,637,756 2,153,707 2,359,939 1,693,017 161,195 679,373 1,198,551 1,718,729 Cash Reserve Cash Adjustments 624 (869) 750,000 - - - - - Ending Cash Balance 2,153,707 2,359,939 1,693,017 161,195 679,373 1,198,551 1,718,729 2,239,907 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was established in 2006 with the City's share of the proceeds for the lease of the Indiana Toll Road (I-80/90). The fund is used to finance capital improvements projects and also makes loans to other funds. Annual revenue is the loan payments from those other funds. In recent years, this fund has been used in connection with the City's Smart Streets program. The Interfund Loans are being repaid on the Eddy Street Commons Phase I project and the Triangle Development Project, south of the University of Notre Dame. Ending cash balance for 2017 has been adjusted upward by $750,000. This adjustment results from an existing encumbrance for parking garage repairs which will be deferred to 2018. 89 City of South Bend, Indiana2018 BudgetFund 412 - Major Moves ConstructionFive-Year Capital Improvement PlanFunding 2018ForecastNameSource Budget 2019202020212022TotalJustificationReplacement CapitalTotal Replacement Capital- - - - - - Project CapitalIronwood/Corby/Rockne Intersection ModernizationCash1,200,000 - - - - 1,200,000 Improve safety and service at this intersection.School Zones Flashing BeaconsCash100,000 - - - - 100,000 Improve safety for school children and staff.Total Project Capital1,300,000 - - - - 1,300,000 Minimum Thresholds:Total Capital1,300,000 - - - - 1,300,000 Equipment $10,000 | Buildings $100,000Explain Significant Spending on Capital Projects Below:90 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueMAJOR MOVES CONSTRUCTION412-0000-361.00-00 INTEREST EARNINGS19,069 21,524 25,000 25,000 15,887 12,107 25,000LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST EARNINGS ON FUND BALANCE25,00025,000------------ ------------ ------------ ------------ ------------ ------------ ------------*19,069 21,524 25,000 25,000 15,887 12,107 25,000412-0000-380.10-99 MISC. REIMBURSEMENTS0 121,00900000LEVEL TEXTTEXT AMT02 DOUGLAS ROAD AND EDDY STREET COMMONS PRINCIPAL ANDINTEREST PAYMENTS BUDGETED IN NEW ACCOUNTS IN FUND412------------ ------------ ------------ ------------ ------------ ------------ ------------*0 121,00900000412-0000-399.02-06 PRINCIPAL INCOME555,782 1,034,787 1,304,283 879,011 696,691 515,610 376,264LEVEL TEXTTEXT AMT02 EDDY STREET COMMONS - SCHEDULE #85279,741TRIANGLE DEVELOPMENT - SCHEDULE #8496,523376,264412-0000-399.02-07 INTEREST230,405 199,579 173,189 149,775 85,506 80,979 116,914LEVEL TEXTTEXT AMT02 EDDY STREET COMMONS - SCHEDULE #8592,695TRIANGLE DEVELOPMENT - SCHEDULE #8424,219116,914------------ ------------ ------------ ------------ ------------ ------------ ------------*786,187 1,234,366 1,477,472 1,028,786 782,197 596,589 493,178------------ ------------ ------------ ------------ ------------ ------------ ------------** MAJOR MOVES CONSTRUCTION805,256 1,376,899 1,502,472 1,053,786 798,084 608,696 518,178------------ ------------ ------------ ------------ ------------ ------------ ------------*** MAJOR MOVES CONSTRUCTION805,256 1,376,899 1,502,472 1,053,786 798,084 608,696 518,178805,256 1,376,899 1,502,472 1,053,786 798,084 608,696 518,178Fund 412 - Major Moves ConstructionCity of South BendRevenue91 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresMAJOR MOVES CONSTRUCTION412-0401-415.36-01 BUILDING R&M0 31,191 750,000 1,468,808 275,560 1,514 750,000LEVEL TEXTTEXT AMT02 2018 GARAGE MAINTENANCE (SEE INTER-FUND LOAN)750,000750,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 31,191 750,000 1,468,808 275,560 1,514 750,000412-0401-415.42-03 STREETS AND ALLEYS000 173,020000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000 173,020000------------ ------------ ------------ ------------ ------------ ------------ ------------** CONTROLLER0 31,191 750,000 1,641,828 275,560 1,514 750,000Fund 412 - Major Moves ConstructionCity of South BendExpenditures92 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures412-0602-431.42-03 STREETS AND ALLEYS2,257,939 1,138,607 750,000 828,88000 1,300,000LEVEL TEXTTEXT AMT02 IRONWOOD/CORBY/ROCKNE INTERSECTION MODERNIZATION 1,200,000SCHOOL ZONES FLASHING BEACONS100,0001,300,000412-0602-431.43-09 MATERIALS & EQUIPMENT31,990000000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL2,289,929 1,138,607 750,000 828,88000 1,300,000------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING2,289,929 1,138,607 750,000 828,88000 1,300,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** MAJOR MOVES CONSTRUCTION2,289,929 1,169,798 1,500,000 2,470,708 275,560 1,514 2,050,0002,289,929 1,169,798 1,500,000 2,470,708 275,560 1,514 2,050,000Fund 412 - Major Moves ConstructionCity of South BendExpenditures93 City of South Bend, Indiana 2018 Budget Fund 227 - Loss Recovery 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 23,551 8,952 9,000 4,337 4,000 3,500 3,250 3,000 2,750 (5,000) -56% Other Income 30,500 - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 54,051 8,952 9,000 4,337 4,000 3,500 3,250 3,000 2,750 (5,000) -56% Expenditures by Type Supplies 72,461 - - - - - - - - - - Services & Charges Professional Services 244,630 - 300,000 6,009 50,000 - - - - (250,000) -83% Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges 2,776,504 21,969 250,333 - 200,000 3,500 3,250 3,000 2,750 (50,333) -20% Total Services & Charges 3,021,134 21,969 550,333 6,009 250,000 3,500 3,250 3,000 2,750 (300,333) -55% Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure 1,831,099 9,667 48,342 12,860 - - - - - (48,342) -100% Total Capital 1,831,099 9,667 48,342 12,860 - - - - - (48,342) -100% Total Expenditures 4,924,694 31,636 598,675 18,869 250,000 3,500 3,250 3,000 2,750 (348,675) -58% Net Surplus / (Deficit)(4,870,643) (22,684) (589,675) (14,532) (246,000) - - - - Beginning Cash Balance 5,857,602 991,738 968,861 379,186 133,186 133,186 133,186 133,186 Cash Reserve Cash Adjustments 4,779 (193) - - - - - - Ending Cash Balance 991,738 968,861 379,186 133,186 133,186 133,186 133,186 133,186 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No reserve requirement This fund was established in 2008 with the recovery of monies from lawsuits brought about by environmental actions on the Studebaker and Oliver industrial sites. The fund continues to receive, intermittently, monies from similar settlements. The fund is used for capital projects and the Vacant and Abandoned Housing initiative. In 2018, this fund will be used for some Community Investment projects and granular activated carbon reconditioning. 94 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueLOSS RECOVERY FUND227-0000-361.00-00 INTEREST EARNINGS23,551 8,952 1,000 9,000 5,554 4,337 4,000------------ ------------ ------------ ------------ ------------ ------------ ------------*23,551 8,952 1,000 9,000 5,554 4,337 4,000------------ ------------ ------------ ------------ ------------ ------------ ------------** LOSS RECOVERY FUND23,551 8,952 1,000 9,000 5,554 4,337 4,000Fund 227 - Loss RecoveryCity of South BendRevenue95 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLOSS RECOVERY FUND227-0401-415.31-06 OTHER PROFESSIONAL SVCS5,323000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES5,323000000------------ ------------ ------------ ------------ ------------ ------------ ------------** CONTROLLER5,323000000Fund 227 - Loss RecoveryCity of South BendExpenditures96 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures227-0602-431.22-40 SIGNALS/LIGHTS72,461000000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES72,461000000227-0602-431.42-03 STREETS AND ALLEYS1,831,099 9,6670 48,342 12,860 12,8600------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL1,831,099 9,6670 48,342 12,860 12,8600------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING1,903,560 9,6670 48,342 12,860 12,8600Fund 227 - Loss RecoveryCity of South BendExpenditures97 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures227-0631-793.31-06 OTHER PROFESSIONAL SVCS 134,707000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES134,707000000------------ ------------ ------------ ------------ ------------ ------------ ------------** ORGANIC RESOURCES134,707000000Fund 227 - Loss RecoveryCity of South BendExpenditures98 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures227-0640-601.39-55 RECYCLING00 200,000 200,000 98,4000 200,000LEVEL TEXTTEXT AMT02 GRANULAR ACTIVATED CARBON RECONDITIONING200,000"OLIVE GAC UNITS"200,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 200,000 200,000 98,4000 200,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WATER WORKS00 200,000 200,000 98,4000 200,000Fund 227 - Loss RecoveryCity of South BendExpenditures99 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures227-1001-460.31-01 LEGAL SERVICES000 75,000 6,009 6,0090227-1001-460.31-06 OTHER PROFESSIONAL SVCS 104,6000 300,000 225,00000 50,000LEVEL TEXTTEXT AMT02 ESTIMATED LEGAL ENVIRONMENTAL WORK AS FOLLOWS:INDIANA AVENUE SETTLEMENT25,000IVY TOWER15,000HONEYWELL/CURTIS PRODUCTS10,00050,000227-1001-460.39-89 MISC CHARGES & SVCS54,031 1,96900000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES158,631 1,969 300,000 300,000 6,009 6,009 50,000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT158,631 1,969 300,000 300,000 6,009 6,009 50,000Fund 227 - Loss RecoveryCity of South BendExpenditures100 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures227-1201-415.39-89 MISC CHARGES & SVCS2,722,473 20,0000 50,333000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES2,722,473 20,0000 50,333000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD CODE ENF.2,722,473 20,0000 50,333000------------ ------------ ------------ ------------ ------------ ------------ ------------*** LOSS RECOVERY FUND4,924,694 31,636 500,000 598,675 117,269 18,869 250,0004,924,694 31,636 500,000 598,675 117,269 18,869 250,000Fund 227 - Loss RecoveryCity of South BendExpenditures101 City of South Bend, Indiana 2018 Budget Fund 101 - General Fund Department 0302 - WNIT Contract 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 43,000 43,000 43,000 43,000 43,000 43,000 43,000 - - - 0% Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Other Interfund Allocations - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Grants & Subsidies - - - - - - - - - - - Insurance - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 43,000 43,000 43,000 43,000 43,000 43,000 43,000 - - - 0% Capital - - - - - - - - - - - Total Expenditures 43,000 43,000 43,000 43,000 43,000 43,000 43,000 - - - 0% Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: In 2012 the City, along with the City of Mishawaka and St. Joseph County, entered into an agreement with WNIT Public Television for the establishment and maintenance of a public access channel which is used to broadcast all public Common Council meetings, among other things. The allocation of costs is $43,000 to South Bend, $13,000 to Mishawaka and $29,000 to Saint Joseph County. The current WNIT contract expires February 2, 2020. This annual expenditure was previously paid from the Council department (101-0301) but was segregated upon the Council's request. 102 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresGENERAL FUND101-0302-411.31-06 OTHER PROFESSIONAL SVCS 43,000 43,000 43,000 43,000 43,000 43,000 43,000LEVEL TEXTTEXT AMT02 WNIT CONTRACT ESTIMATE43,000THE CURRENT CONTRACT EXPIRES 2/1/18. CURRENTLY,THE COST ALLOCATION IS AS FOLLOWS:SOUTH BEND - $43,000MISHAWKAKA - 13,000ST. JOE COUNTY - 29,000TOTAL - $85,00043,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES43,000 43,000 43,000 43,000 43,000 43,000 43,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WNIT CONTRACT43,000 43,000 43,000 43,000 43,000 43,000 43,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** GENERAL FUND43,000 43,000 43,000 43,000 43,000 43,000 43,00043,000 43,000 43,000 43,000 43,000 43,000 43,000101-0302 WNIT ContractCity of South BendExpenditures103