Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018 Overall Budget Changes with Detail
Memorandum Monday, October 09, 2017 TO: Common Council Members, City Clerk FROM: Jen Hockenhull SUBJECT: 2018 Budget Changes Overview Memo Overall 2018 Budget Changes subsequent to Department Presentations Due to opportunities and challenges that arise throughout the budget process, we are providing to you budget summaries and detail sheets for those funds which have been modified since the original presentation by individual departments. All revisions will be online prior to the end of business tomorrow, October 10th. We are happy to discuss in detail any questions you may have prior to or at the October 16th Budget Clean Up meeting. Administration & Finance (Fund 101-0401): Decrease in other professional services set aside for miscellaneous projects to cover other general fund requests. (Pages 2-9) Legal Department (Fund 101-0501): Increase in salaries and benefits in order to cover the full potential cost of health insurance for all staff and increasing the total salary line item to allow for the opportunity to increase compensation within the salary caps set forth. Also increased training and dues line items to assist with the cost of legal training for licensed attorneys. (Pages 10-15) Engineering Department (Fund 101-0602): Small changes due to changes in IT allocations and IT related expenditures. (Pages 16-25) Motor Vehicle Highway (Fund 202): Small changes due to changes in IT allocations and IT related expenditures. (Pages 26-44) Public Safety LOIT (Fund 249): Added Director of Public Safety position. (Pages 45-51) County Option Income Tax – COIT (Fund 404): Added funding Permanent Supportive Housing (Homeless Initiative). (Pages 52-69) 2017 Parks Bond (Fund 471): Not previously included in any presentations. Relates to MY SB Parks and Trails projects as presented during the VPA budget presentation. (Pages 70- 80) Sewage Capital (Fund 672): Added estimated revenue and expense for potential TIF-funded capital projects. (Pages 81-84) As always, thank you for your continued efforts throughout the budget process. Sincerely, Jen Hockenhull City Controller 1 City of South Bend, Indiana 2018 Budget Fund 101 - General Fund Department 0401 - Administration & Finance 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 1,207,387 1,285,999 1,424,633 695,518 1,581,515 1,613,145 1,645,408 1,678,316 1,711,883 156,882 11% Fringe Benefits 437,706 499,785 629,182 280,675 698,935 720,696 743,209 766,499 790,597 69,753 11% Total Personnel 1,645,093 1,785,784 2,053,815 976,193 2,280,450 2,333,842 2,388,617 2,444,816 2,502,480 226,635 11% Supplies 32,487 22,195 25,158 15,487 23,500 23,500 23,500 23,500 23,500 (1,658) -7% Services & Charges Professional Services 51,207 68,664 103,373 71,753 53,200 53,200 54,264 54,264 55,349 (50,173) -49% Printing & Advertising 891 878 1,500 780 900 500 200 - - (600) -40% Utilities - - - - - - - - - - - Education & Training 9,665 18,241 7,560 4,605 10,210 10,000 10,000 10,000 10,000 2,650 35% Travel 7,848 8,790 12,600 5,525 11,100 11,100 11,100 11,100 11,100 (1,500) -12% Repairs & Maintenance 10,006 9,900 6,616 2,323 8,000 8,000 8,000 8,000 8,000 1,384 21% Other Interfund Allocations 12,202 25,127 229,062 114,528 190,598 190,598 194,134 197,742 201,421 (38,464) -17% Debt Service Principal 2,440 4,303 4,493 2,434 2,801 2,295 2,430 - - (1,692) -38% Interest & Fees 1,732 2,165 586 313 348 211 76 - - (238) -41% Grants & Subsidies - - - - - - - - - - - Insurance 5,616 9,180 4,705 2,352 6,150 6,273 6,398 6,526 6,657 1,445 31% Transfers Out - - - - - - - - - - - Other Services & Charges 34,015 32,788 26,883 20,558 32,539 31,139 30,139 30,139 30,139 5,656 21% Total Services & Charges 135,622 180,036 397,378 225,171 315,846 313,316 316,742 317,771 322,666 (81,532) -21% Capital - - - - - - - - - - - Total Expenditures 1,813,202 1,988,015 2,476,351 1,216,850 2,619,796 2,670,658 2,728,859 2,786,087 2,848,646 143,445 6% Revenue Charges for Services - - - - - - - - - - - Interest Earnings - - - - - - - - - - - Donations - - - - - - - - - - - Other Income 1,168 16,699 12,304 12,262 12,050 13,000 13,000 13,000 13,000 (254) -2% Total Revenue 1,168 16,699 12,304 12,262 12,050 13,000 13,000 13,000 13,000 (254) -2% Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Department of Administration & Finance provides financial management and administrative services to City operations including finance and accounting services, human resources, risk management, and benefits administration. The majority of the revenue received is procurement-card commissions. Personnel costs increased due to the continued consolidation of fiscal officers within the Administration & Finance Department. Also, a new position of an Administrative Assistant is being requested to serve Admininstration & Finance, Human Resources and Innovation & Technology. An increase in professional services is due to required outside work for bonding and other legally required professional services. The 2018 budget includes costs for the evolving Diversity & Inclusion Program that is being put into place at the City. 2 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0401-415.10-01 REGULAR WAGES1,170,053 1,249,770 1,418,587 1,418,587 972,010 692,013 1,567,375LEVEL TEXTTEXT AMT02 FINANCE:CITY CONTROLLER119,514CHIEF FINANCIAL OFFICER97,420DIRECTOR OF TREASURY76,159DIRECTOR OF BUDGET & ACCOUNTING76,159DIRECTOR OF FINANCE - WATER WORKS66,554DIRECTOR OF FINANCE - WASTEWATER66,554DIRECTOR OF FINANCE - MORRIS/PALAIS (VPA)66,554DIRECTOR OF FINANCE - PARKS (VPA)66,554DIRECTOR OF FINANCE - PUBLIC SAFETY66,554DIRECTOR OF FINANCE - DCI (DIRECTOR II DCI)79,070DIRECTOR OF FINANCE - CODE/ACC/ENGINEERING66,554SENIOR BUDGET ANALYST63,673GRANTS MANAGER60,581ACCOUNTS PAYABLE SUPERVISOR49,045PAYROLL SUPERVISOR47,852ACCOUNTING ASSISTANT43,629HUMAN RESOURCES:DIRECTOR OF HUMAN RESOURCES90,096DEPUTY DIRECTOR OF HUMAN RESOURCES75,000SR. HUMAN RESOURCE GENERALIST62,424BENEFITS MANAGER59,533HUMAN RESOURCE GENERALIST/BENEFITS COORDINATOR41,616ADMINISTRATIVE ASSISTANT II41,726INCLUSION:DIVERSITY COMPLIANCE/INCLUSION OFFICER78,030SHARED POSITIONS:ADMINISTRATIVE ASSISTANT I40,524LESS SALARY CAP ADJUSTMENT34,000-1,567,375101-0401-415.10-03 SEASONAL & INTERNS36,674 27,7650 6,046 6,682 3,505 14,140LEVEL TEXTTEXT AMT02 HRANDFINANCEINTERNS-2INTERNSX9WEEKSX 20 HOURS X $10.103,636DIVERSITY & INCLUSION INTERN$10.10 X 20 HOURS X 52 WEEKS10,50414,140101-0401-415.10-04 EXTRA AND OVERTIME66046400000101-0401-415.10-10 HIRING BONUS0 8,00000000101-0401-415.11-01 FICA - REGULAR89,649 95,909 108,522 108,522 72,463 51,445 120,527LEVEL TEXTTEXT AMT101-0401 Department of Administration & FinanceCity of South BendExpenditures2:00pm 09/25/173 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 TOTAL PAYROLL $1,561,366 X 7.65%119,445INTERNS $14,140 X 7.65%1,082120,527101-0401-415.11-04 PERF - REGULAR130,302 141,566 158,882 158,882 108,788 77,505 174,873LEVEL TEXTTEXT AMT02 ELIGIBLE WAGES $1,561,366 X 11.2%174,873174,873101-0401-415.11-07 UNEMPLOYMENT COMP3,260 1,626 3,5460000101-0401-415.11-08 HEALTH INSURANCE199,580 247,411 359,858 351,898 209,621 146,353 394,363LEVEL TEXTTEXT AMT02 HEALTH INSURANCE - 24.2 X $16,200 PER YEAR392,040LTD - 24.2 X $96 PER YEAR2,323394,363101-0401-415.11-09 LIFE INSURANCE2,305 2,130 2,760 2,760 1,681 1,156 2,904LEVEL TEXTTEXT AMT02 LIFE INSURANCE - 24.2 X $1202,9042,904101-0401-415.11-12 AUTO ALLOWANCE150 7,2000 4,800 4,700 2,9000101-0401-415.11-22 PARKING ALLOWANCE8,507336-00000101-0401-415.11-24 CELL PHONE ALLOWANCE2,875 3,515660 1,320 1,155825 1,320LEVEL TEXTTEXT AMT02 HR EMPLOYEES ($55 X 12 MONTHS X 2 EMPLOYEES)1,3201,320101-0401-415.11-25 FRINGE BENEFIT TAXES1,078764 1,000 1,000679491 1,000LEVEL TEXTTEXT AMT02 MISC TAXES ON FRINGE BENEFITS1,0001,000101-0401-415.11-29 PARENTAL LEAVE000000 3,948LEVEL TEXTTEXT AMT02 SALARY $1,579,065 X 0.25%3,9483,948------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES1,645,093 1,785,784 2,053,815 2,053,815 1,377,779 976,193 2,280,450101-0401-415.21-02 PRINT SHOP8,927 1,073 1,500 1,500925707 1,500101-0401 Department of Administration & FinanceCity of South BendExpenditures2:00pm 09/25/174 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresLEVEL TEXTTEXT AMT02 ESTIMATE FOR 2018:PAFR COPIES350EMPLOYEE HANDBOOKS750BUDGET BOOKS4001,500101-0401-415.21-03 C.S. OFFICE SUPPLIES3,895 3,898 4,000 4,000 2,571 2,039 4,000LEVEL TEXTTEXT AMT02 ESTIMATED COSTS 20184,0004,000101-0401-415.21-04 OTHER OFFICE SUPPLIES16,789 11,597 16,000 17,642 15,105 12,069 16,000LEVEL TEXTTEXT AMT02 ESTIMATED COSTS 201816,00016,000101-0401-415.21-05 SMALL OFFICE EQUIPMENT2,876 3,427 2,000 1,01600 2,000LEVEL TEXTTEXT AMT02 ESTIMATED COSTS 20182,0002,000101-0401-415.22-24 OTHER OPERATING SUPPLIES0 2,20000000101-0401-415.22-50 EMPLOYEE RECOGNITION PROG000 1,0009436710LEVEL TEXTTEXT AMT02 EST COST FOR PRIZES AND LUNCH WINNERS(MOVE TO FUND 711 FOR 2018)------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES32,487 22,195 23,500 25,158 19,544 15,487 23,500101-0401-415.31-01 LEGAL SERVICES79930000000101-0401-415.31-06 OTHER PROFESSIONAL SVCS 50,362 68,364 44,600 103,373 76,749 71,753 53,200LEVEL TEXTTEXT AMT02 NYHART - GASB 45 UPDATE - EVERY TWO YEARS ($7,200)7,2002017 CAFR PREPARATION ASSISTANCE31,000UMBAUGH MCDC BOND DISCLOSURE COMPLIANCE15,00053,200101-0401-415.31-39 COLLECTION AGENCY EXPENSE46000000101-0401-415.31-71 CENTRAL STORES ALLOCATION 2,378 2,316 2,555 2,555 1,704 1,278 5,365LEVEL TEXTTEXT AMT101-0401 Department of Administration & FinanceCity of South BendExpenditures2:00pm 09/25/175 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 2018 FIXED COST ALLOCATION #3 - CENTRAL STORES5,3655,365101-0401-415.31-73 PRINT SHOP ALLOCATION0 6,048 8,988 8,988 5,992 4,494 8,410LEVEL TEXTTEXT AMT02 2018 ALLOCATION8,4108,410101-0401-415.31-75 311 CALL CENTER ALLOC0 5,92700000101-0401-415.31-76 IT ALLOCATION000000 176,823LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION INFORMATION TECH176,823FINANCE (INCLUDES PBB $20K)HUMAN CAPITAL & INCLUSION(INCLUDES LINKEDIN $19K)176,823101-0401-415.32-02 POSTAGE7,382 7,654 7,500 7,500 5,325 4,446 8,900LEVEL TEXTTEXT AMT02 ESTIMATE POSTAGE COSTS 20188,900(2018 SHOULD BE FINAL YEAR TO MAIL OUT W-2'S)8,900101-0401-415.32-21 TRAVEL - MILEAGE1,860 1,043 2,200 2,200606577 2,200LEVEL TEXTTEXT AMT02 ESTIMATED TRAVEL COSTS - DLGF, SBOA, IACT1,000FISCAL OFFICER TRAVEL400HR TRAVEL TO CONFERENCES8002,200101-0401-415.32-22 TRAVEL - AIRFARE1,281 2,153 3,300 3,300 3,904 1,500 1,800LEVEL TEXTTEXT AMT02 GFOA ANNUAL CONFERENCE (MAX OF 2 ATTENDEES)1,000FISCAL OFFICE TRAVEL8001,800101-0401-415.32-23 TRAVEL - HOTEL3,358 4,091 5,000 5,000 3,961 2,601 5,000LEVEL TEXTTEXT AMT02 GFOA CONFERENCE2,000HR CONFERENCES2,000FISCAL OFFICER TRAVEL1,0005,000101-0401 Department of Administration & FinanceCity of South BendExpenditures2:00pm 09/25/176 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0401-415.32-24 TRAVEL - MEALS663695 1,500 1,500 1,334704 1,500LEVEL TEXTTEXT AMT02 GFOA CONFERENCE500HR CONFERENCES500FISCAL OFFICER TRAVEL5001,500101-0401-415.32-25 TRAVEL - OTHER686808600600299144600LEVEL TEXTTEXT AMT02 GFOA CONFERENCE200HR CONFERENCES300FISCAL OFFICER TRAVEL100600101-0401-415.33-02 PUBLICATION LEGAL NOTICE891878 1,500 1,500780780900LEVEL TEXTTEXT AMT02 SOUTH BEND TRIBUNE AND TRI COUNTY NEWS LEGAL ADS900BUSINESS LICENSING AND ANNUAL GATEWAY REPORTS900101-0401-415.34-02 LIABILITY INSURANCE5,616 9,180 4,705 4,705 3,136 2,352 6,150LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #56,150LIABILITY INSURANCE6,150101-0401-415.36-01 BUILDING R&M425 1,14900000101-0401-415.36-02 OFFICE EQUIP R&M9,581 8,751 8,000 6,456 3,281 2,323 8,000LEVEL TEXTTEXT AMT02 COPIER MAINTENANCE8,0008,000101-0401-415.36-04 COMPUTER EQUIP R&M9,824 10,836 217,519 217,519 145,008 108,7560101-0401-415.36-05 OTHER EQUIP R&M000160000101-0401-415.37-11 CAPITAL LEASE PRINCIPAL2,440 4,303 4,493 4,493 3,412 2,434 2,801LEVEL TEXTTEXT AMT02 2013 ADMINISTRATIVE COPIER #1146342016 ADMINISTRATIVE COPIER #1512,1672,801101-0401-415.37-12 CAPITAL LEASE INTEREST132565586586396313348LEVEL TEXTTEXT AMT101-0401 Department of Administration & FinanceCity of South BendExpenditures2:00pm 09/25/177 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 2013 ADMINISTRATIVE COPIER #114102016 ADMINISTRATIVE COPIER #151338348101-0401-415.38-03 PAYING AGENT FEES1,600 1,60000000101-0401-415.39-01 REFNDS,AWARDS,INDEMNITIES01600128128280101-0401-415.39-10 SUBSCRIPTIONS270 1,745 1,7000000101-0401-415.39-11 DUES & MEMBERSHIPS3,145 2,629 3,939 4,655 4,655 4,320 12,139LEVEL TEXTTEXT AMT02 GFOA1,680ASSOCIATION OF GOVERNMENT ACCOUNTANTS95AMERICAN PAYROLL ASSOCIATION219IMA225SOCIETY OF HUMAN RESOURCES570MICHIANA SOCIETY OF HUMAN RESOURCES35INTERNATIONAL PUBLIC MANAGEMENT390FINANCIAL EXECUTIVES225LAW LICENSES200MID-STATES MSDC (D&I)3,000G.A.R.E. (D&I)3,000WBENC (D&I)2,50012,139101-0401-415.39-39 BANK CREDIT CARD CHARGES1,373 1,597 3,000 3,000 1,485 1,343 3,000LEVEL TEXTTEXT AMT02 BUSINESS LICENSE FUNCTION ACCEPTS CREDIT CARD3,000ESTIMATE BASED ON TRENDS3,000101-0401-415.39-70 EDUCATION & TRAINING9,665 18,241 9,960 7,560 9,140 4,605 10,210LEVEL TEXTTEXT AMT02 GFOA ANNUAL CONFERENCE (2 ATTENDEES ANNUALLY)900PAYROLL CONTINUING EDUCATION1,760AIM BUDGET SEMINARS600STATE BOARD OF ACCOUNTS TRAINING500OTHER GFOA/FINANCE TRAINING1,000OTHER HR TRAINING3,200ACCA CONFERENCE (D&I)650D&I TRAINING (CITY WIDE)1,60010,210101-0401-415.39-89 MISC CHARGES & SVCS21,845 19,003 6,800 11,600 11,429 10,422 8,500LEVEL TEXTTEXT AMT02 OTHER COSTS1,000101-0401 Department of Administration & FinanceCity of South BendExpenditures2:00pm 09/25/178 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresVETERNS' LUNCHEON3,500NCIBC @ ST MARY'S COLLEGE (SPONSOR LUNCH)4,0008,500------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES135,622 180,036 338,445 397,378 282,724 225,171 315,846------------ ------------ ------------ ------------ ------------ ------------ ------------** CONTROLLER1,813,202 1,988,015 2,415,760 2,476,351 1,680,047 1,216,850 2,619,796101-0401 Department of Administration & FinanceCity of South BendExpenditures2:00pm 09/25/179 City of South Bend, Indiana 2018 Budget Fund 101 - General Fund Department 0501 - Legal Department 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 675,920 689,144 705,738 326,770 760,139 775,342 790,849 806,666 822,799 54,401 8% Fringe Benefits 215,746 248,712 260,865 125,472 321,864 328,216 338,187 348,497 359,158 60,999 23% Total Personnel 891,666 937,856 966,603 452,242 1,082,003 1,103,558 1,129,035 1,155,162 1,181,957 115,400 12% Supplies 5,735 1,184 5,977 2,908 3,450 3,450 3,450 3,450 3,450 (2,527) -42% Services & Charges Professional Services 3,374 172 48,355 45,477 2,550 2,550 2,550 2,550 2,550 (45,805) -95% Printing & Advertising - - - - - - - - - - - Utilities - - - - - - - - - - - Education & Training 8,475 4,173 8,000 767 10,000 8,000 8,000 8,000 8,000 2,000 25% Travel 1,123 47 3,450 197 3,450 3,450 3,450 3,450 3,450 - 0% Repairs & Maintenance 10 1,633 2,120 1,620 3,320 1,820 1,820 1,820 1,820 1,200 57% Other Interfund Allocations 6,746 8,707 101,944 50,976 75,858 77,375 78,923 80,501 82,111 (26,086) -26% Debt Service Principal 1,172 1,163 1,232 625 1,232 1,232 1,232 1,232 1,232 - 0% Interest & Fees 99 108 40 11 40 40 40 40 40 - 0% Grants & Subsidies - - - - - - - - - - - Insurance 3,348 2,988 2,246 1,122 2,294 2,340 2,387 2,434 2,483 48 2% Transfers Out - - - - - - - - - - - Other Services & Charges 22,759 18,426 18,600 7,821 16,600 16,062 16,329 16,602 16,880 (2,000) -11% Total Services & Charges 47,106 37,417 185,987 108,616 115,344 112,869 114,731 116,629 118,566 (70,643) -38% Capital - - - - - - - - - - - Total Expenditures 944,507 976,457 1,158,567 563,766 1,200,797 1,219,877 1,247,216 1,275,242 1,303,973 42,230 4% Revenue Charges for Services - - - - - - - - - - - Interest Earnings - - - - - - - - - - - Donations - - - - - - - - - - - Other Income 58,088 76,486 75,377 37,350 76,885 78,422 79,991 81,590 83,222 1,508 2% Total Revenue 58,088 76,486 75,377 37,350 76,885 78,422 79,991 81,590 83,222 1,508 2% Department Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: The Legal Department provides quality legal representation to the City of South Bend’s Mayor, departments, commissions and agencies with a dedicated and professionally-skilled staff, efficiently and cost effectively, in furtherance of the City’s strategic goals, and preserving the legal and ethical integrity of the City. The Legal Department's budget has decreased in 2018 by $35,418. This budget reduction is primarily due to decreases in allocations from other departments. Also, at the beginning of 2017, the Department renovated its reception area and conference room using funds that were transferred to the Professional Services line item and the Supplies line item. The large percentage decreases in these areas reflect a one-time use of funds in 2017 that were transferred to those accounts and spent on the Legal Department's 2017 Office Renovation project. There are no pending projects of this nature for 2018. 10 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0501-415.10-01 REGULAR WAGES666,520 688,144 705,738 705,738 461,271 326,770 760,139LEVEL TEXTTEXT AMT02 6 ASST FULL TIME ATTORNEY (6 X 87,533)525,1981 EXECUTIVE ASSISTANT54,6472 ADMINISTRATIVE ASSISTANTS (2 X 40,524)81,0481 CORPORATE COUNSEL124,633TOTAL FTE'S = 10 (50% OF CLAIMS ATTNY SEE BELOW)1 PART TIME CITY ATTORNEY66,380LESS 50% OF CLAIMS ATTORNEY TO BE PAID FROM 22643,767-LESS SALARY CAP TO ACTUAL ADJUSTMENT48,000-760,139101-0501-415.10-05 TEMPORARY SERVICES9,400000000101-0501-415.10-10 HIRING BONUS0 1,00000000101-0501-415.11-01 FICA - REGULAR50,013 50,902 53,989 53,989 34,321 24,323 58,151LEVEL TEXTTEXT AMT02 REGULAR SALARIES $760,139 X 7.65%58,15158,151101-0501-415.11-04 PERF - REGULAR74,650 77,086 79,043 79,043 51,662 36,598 85,136LEVEL TEXTTEXT AMT02 REGULAR SALARIES $760,139 X 11.20%85,13685,136101-0501-415.11-07 UNEMPLOYMENT COMP1,732980 1,7650000101-0501-415.11-08 HEALTH INSURANCE80,097 114,408 122,313 122,313 86,344 61,899 171,156LEVEL TEXTTEXT AMT02 LONG-TERM DISABILITY:11 EMP X $961,056HEALTH INSURANCE COVERAGE:11 EMP X $16,200178,200LESS: 50% INSURANCE FOR CLAIMS ATTORNEY PAIDTHROUGH FUND 2268,100-171,156101-0501-415.11-09 LIFE INSURANCE1,115 1,160 1,260 1,260730523 1,260LEVEL TEXTTEXT AMT02 10.5 EMP X $1201,2601,260101-0501-415.11-12 AUTO ALLOWANCE3,600 3,600 3,600 3,600 2,400 1,800 3,600LEVEL TEXTTEXT AMT101-0501 Legal DepartmentCity of South BendExpenditures2:00pm 09/25/1711 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 $300.00 X 12 MONTHS3,6003,600101-0501-415.11-22 PARKING ALLOWANCE4,03984-00000101-0501-415.11-24 CELL PHONE ALLOWANCE500660660660440330660LEVEL TEXTTEXT AMT02 MONTHLY CELL ALLOWANCE $55 X 12 MONTH660660101-0501-415.11-29 PARENTAL LEAVE000000 1,901LEVEL TEXTTEXT AMT02 REGULAR SALARIES $760,139 X 0.25%1,9011,901------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES891,666 937,856 968,368 966,603 637,168 452,242 1,082,003101-0501-415.21-02 PRINT SHOP1,921025025000250LEVEL TEXTTEXT AMT02 PRINT SHOP250250101-0501-415.21-03 C.S. OFFICE SUPPLIES615335700700340188700LEVEL TEXTTEXT AMT02 2017 ESTIMATE700700101-0501-415.21-04 OTHER OFFICE SUPPLIES2,884849 1,500 1,500494193 1,500LEVEL TEXTTEXT AMT02 OFFICE SUPPLIES OTHER THAN THOSE OBTAINED FROM1,500CENTRAL SERVICES1,500101-0501-415.21-05 SMALL OFFICE EQUIPMENT3150 1,000 3,527 2,527 2,527 1,000LEVEL TEXTTEXT AMT02 OFFICE EQUIPMENT - UNANTICIPATED UPDATES TO EQUIP.1,000INCLUDES CHAIRS, FILE CABINETS, ETC.1,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES5,735 1,184 3,450 5,977 3,361 2,908 3,450101-0501 Legal DepartmentCity of South BendExpenditures2:00pm 09/25/1712 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0501-415.31-01 LEGAL SERVICES2,324000000101-0501-415.31-06 OTHER PROFESSIONAL SVCS1,050172 2,550 48,355 45,507 45,477 2,550LEVEL TEXTTEXT AMT02 IN.GOV/CIVICNET400PACER - DISTRICT COURT ON-LINE SERVICES150COURT FILINGS2,0002,550101-0501-415.31-71 CENTRAL STORES ALLOCATION556612585585392294 1,035LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #31,035CENTRAL STORES1,035101-0501-415.31-72 GIS ALLOCATION1,081 1,13500000101-0501-415.31-73 PRINT SHOP ALLOCATION0 1,956 2,024 2,024 1,352 1,014 1,008LEVEL TEXTTEXT AMT02 2018 PRINT SHOP ALLOCATION #51,0081,008101-0501-415.31-76 IT ALLOCATION000000 73,815LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #773,81573,815101-0501-415.32-02 POSTAGE2,811 2,036 3,600 3,600 1,088752 2,000LEVEL TEXTTEXT AMT02 POSTAGE CHARGED BY ADMINISTRATION & FINANCE2,000AVERAGING ~$125/MONTH2,000101-0501-415.32-21 TRAVEL - MILEAGE4610750750290750LEVEL TEXTTEXT AMT02 2017 ESTIMATE750750101-0501-415.32-23 TRAVEL - HOTEL3240 2,000 2,000197197 2,000LEVEL TEXTTEXT AMT02 2017 ESTIMATE2,000HOTEL COSTS FOR MUNICIPAL LAW SEMINARS2,000101-0501 Legal DepartmentCity of South BendExpenditures2:00pm 09/25/1713 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0501-415.32-24 TRAVEL - MEALS185050050000500LEVEL TEXTTEXT AMT02 2017 ESTIMATE500MEALS FOR IMLA/IACT MUNICIPAL LAW SEMINARS500101-0501-415.32-25 TRAVEL - OTHER1534720020000200LEVEL TEXTTEXT AMT02 2017 ESTIMATE200200101-0501-415.34-02 LIABILITY INSURANCE3,348 2,988 2,246 2,246 1,496 1,122 2,294LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #52,294LIABILITY INSURANCE2,294101-0501-415.36-02 OFFICE EQUIP R&M10 1,633 2,120 2,120 1,620 1,620 1,820LEVEL TEXTTEXT AMT02 FOR REPAIRS TO OFFICE EQUIPMENT200COPIER ANNUAL MAINTENANCE COST1,6201,820101-0501-415.36-04 COMPUTER EQUIP R&M5,109 5,004 99,335 99,335 66,224 49,668 1,500LEVEL TEXTTEXT AMT02 PRACTICE MASTER1,5001,500101-0501-415.37-11 CAPITAL LEASE PRINCIPAL1,172 1,163 1,232 1,232940625 1,232LEVEL TEXTTEXT AMT02 RICOH COPIER LEASE1,2321,232101-0501-415.37-12 CAPITAL LEASE INTEREST991084040141140LEVEL TEXTTEXT AMT02 RICOH COPIER INTEREST4040101-0501-415.39-10 SUBSCRIPTIONS19,469 15,690 14,300 14,300 8,756 6,570 13,100LEVEL TEXTTEXT AMT101-0501 Legal DepartmentCity of South BendExpenditures2:00pm 09/25/1714 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 THOMSON WEST $1,091/MONTH13,10013,100101-0501-415.39-11 DUES & MEMBERSHIPS475700700700500500 1,500LEVEL TEXTTEXT AMT02 MUNICIPAL LAW TRAINING1,5001,500101-0501-415.39-70 EDUCATION & TRAINING8,475 4,173 8,000 8,000 5,071767 10,000LEVEL TEXTTEXT AMT02 NBI TRAINING PACKAGE4,000OTHER TRAINING FOR 8 ATTORNEYS AND SUPPORT STAFF6,00010,000101-0501-415.39-89 MISC CHARGES & SVCS4000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES47,106 37,417 140,182 185,987 133,186 108,616 115,344------------ ------------ ------------ ------------ ------------ ------------ ------------** LEGAL DEPARTMENT944,507 976,457 1,112,000 1,158,567 773,715 563,766 1,200,797101-0501 Legal DepartmentCity of South BendExpenditures2:00pm 09/25/1715 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 20,850 31,800 31,800 32,550 32,550 (13,263) -39% 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 331,860 335,600 335,600 335,600 335,600 92,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 19,025 9,225 9,150 9,275 9,250 9,710 104% Total Services & Charges 235,695 297,407 569,408 205,336 598,066 579,683 574,176 569,227 564,550 28,658 5% Capital - - - - - - - - - - - Total Expenditures 936,645 1,015,087 1,445,157 572,895 1,590,505 1,601,114 1,616,853 1,634,476 1,652,215 145,348 10% Revenue Licenses & Permits - 35,583 100,000 60,380 120,000 101,000 101,500 102,000 102,500 20,000 20% Charges for Services - 3,000 6,127 5,802 12,000 12,500 13,000 13,500 14,000 5,873 96% 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 323,464 66,582 352,167 337,949 343,317 348,773 354,317 28,703 9% 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 $223,998. Of this change, $95,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 will decrease approximately $1,400. 16 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0602-431.10-01 REGULAR WAGES424,336 423,611 547,844 547,844 357,704 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 12,950 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,883003671560101-0602-431.10-09 PERMANENT PART-TIME60,512 26,330 21,066 21,066 9,089 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 29,139 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 39,752 27,563 75,042LEVEL TEXTTEXT AMT02 REGULAR SALARIES - $670,014.88 X 11.2%75,04275,042101-0602 EngineeringCity of South BendExpenditures2:00pm 09/25/1717 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-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 61,060 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,016657447 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,624 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,619420420420875560 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,844 2,065 4,642LEVEL TEXTTEXT AMT02 ALL PHONE ALLOCATIONS $660 ANNUALLYDIRECTOR PUB WKS (12%)79101-0602 EngineeringCity of South BendExpenditures2:00pm 09/25/1718 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresDEP 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 516,126 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,330352500500488139400LEVEL 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 3,407 2,485 5,000LEVEL TEXTTEXT AMT02 SUPPLIES PURCHASE FROM OTHER THAN CENTRAL STORES5,000ESTIMATE BASED ON TRENDS, BLANKET PO ISSUED TOOFFICE MAX101-0602 EngineeringCity of South BendExpenditures2:00pm 09/25/1719 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures5,000101-0602-431.21-05 SMALL OFFICE EQUIPMENT1,721 14,622 5,000 5,160961169 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,500 1,107858 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,3810LEVEL TEXTTEXT AMT02 NEW COMPUTER EQUIPMENT INCLUDES UPGRADES FOR10,750HAND-HELD DEVICES FOR STAFF..................................................2018-THIS LINE ITEM BUDGET HAS BEEN REDISTRIBUTED10,750-$5,000 TO ACCT 31.76 IT ALLOCATION-NEW IPADS &$6,840 TO ACCT 39.89 FOR 15 DATA PLANS101-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 13,800 11,364 20,850101-0602-431.31-01 LEGAL SERVICES4,8600 10,000 10,00000 10,000LEVEL TEXTTEXT AMT02 ESTIMATED LEGAL SERVICES10,000101-0602 EngineeringCity of South BendExpenditures2:00pm 09/25/1720 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures10,000101-0602-431.31-06 OTHER PROFESSIONAL SVCS 78,615 138,698 140,000 211,250 51,338 41,713 140,000LEVEL TEXTTEXT AMT02 STORMWATER SERVICES40,000TRANSPORTATION STUDIES40,000OTHER SERVICES AS THEY ARISE60,000140,000101-0602-431.31-70 ADM FEE ALLOCATION00 38,691 38,691 25,792 19,344 45,997LEVEL TEXTTEXT AMT02 2018 ADMIN ALLOCATION45,997(2017 - $38,691)45,997101-0602-431.31-71 CENTRAL STORES ALLOCATION809744660660440330 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,832 1,374 2,962LEVEL TEXTTEXT AMT02 2018 PRINT SHOP ALLOCATION2,962(2017-$2,753)2,962101-0602-431.31-76 IT ALLOCATION000000 281,301LEVEL TEXTTEXT AMT02 2018 IT ALLOCATION NOW INCLUDES INNOVATION OFFICE, 279,301GIS, AND IT.................................................2018 ADD ON FOR NEW PURCHASE OF 10 IPADS W/CASESAND ACCESSORIES:$369 FOR 32GB IPADS+CASE, CAR CHARGER, CABLE2,000.................................................(2017-$197,666)281,301101-0602-431.32-02 POSTAGE1,830 1,532 2,000 2,000939695 2,000LEVEL TEXTTEXT AMT101-0602 EngineeringCity of South BendExpenditures2:00pm 09/25/1721 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 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 AMT02 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 EngineeringCity of South BendExpenditures2:00pm 09/25/1722 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0602-431.34-02 LIABILITY INSURANCE9,612 11,676 14,738 14,738 9,824 7,368 14,772LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION14,772LIABILITY INSURANCE(2017-$14,738)14,772101-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,456 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 3,539 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 131,776 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 23,065 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 EngineeringCity of South BendExpenditures2:00pm 09/25/1723 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures101-0602-431.37-12 CAPITAL LEASE INTEREST1,035 1,029 1,778 1,778826568 1,365LEVEL TEXTTEXT AMT02 CURRENT LEASES:2013 VEHICLES #110462013 PLOTTER/SCANNER #1111342014 VEHICLES #1241082015 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 2,009 1,414 3,900LEVEL TEXTTEXT AMT02 ASCE1,000IMSA100IACE100IWEA/WEF, 3 @ $150 EACH450APWA500OTHER1,7503,900101-0602-431.39-39 BANK CREDIT CARD CHARGES608494400400305209515LEVEL TEXTTEXT AMT02 MONTHLY CHARGES DUE TO CREDIT CARD MACHINE515515101-0602-431.39-70 EDUCATION & TRAINING10,446 15,977 21,000 21,263 5,427 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 TRAINING101-0602 EngineeringCity of South BendExpenditures2:00pm 09/25/1724 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures21,000101-0602-431.39-89 MISC CHARGES & SVCS719 1,063 2,000 2,000768124 11,710LEVEL TEXTTEXT AMT02 MISC. EXPENSES NOT COVERED ELSEWHERE1,900AT&T MOBILITY: 5 EXISTING PLANS COVERED BY IT 2017IPAD: 220-7519495IPAD: 220-7521495IPAD: 220-75495IPAD: 855-6245495IPAD: 904-6769495IPAD: 993-1802495AT&T MOBILITY: 15 DATAS PLANS ADDEDADDED 2017: 5 NEW IPADS - DATA PLAN @ $456/YR EACH2,280ADDED 2018: 10 NEW IPADS-DATA PLANS @ $456/YR EACH4,56011,710------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES235,695 297,407 496,331 569,408 271,416 205,336 598,066------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING936,645 1,015,087 1,369,507 1,445,157 801,342 572,895 1,590,505101-0602 EngineeringCity of South BendExpenditures2:00pm 09/25/1725 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 60,000 29,296 30,861 31,170 41,082 55,008 55,008 (29,139) -49% Other Income 95,101 41,819 91,655 8,711 26,082 23,082 23,082 23,082 23,082 (65,573) -72% 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,989,994 4,852,054 11,288,058 10,827,653 10,930,526 11,058,126 11,062,552 1,298,064 13% 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 630,165 642,768 655,624 668,736 682,111 77,716 14% 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,838,467 3,914,587 4,046,018 4,256,083 4,104,127 317,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,034,218 10,933,154 11,176,623 11,500,295 11,466,070 268,687 2% Net Surplus / (Deficit)1,265,007 992,377 (1,775,537) 641,128 (746,160) (105,502) (246,097) (442,169) (403,518) Beginning Cash Balance 3,891,051 5,210,952 6,122,507 4,346,970 3,600,810 3,495,309 3,249,211 2,807,042 Cash Reserve Cash Adjustments 54,893 (80,821) - - - - - - Ending Cash Balance 5,210,952 6,122,507 4,346,970 3,600,810 3,495,309 3,249,211 2,807,042 2,403,524 Cash Reserves Target 2,157,736 2,167,801 2,941,383 3,008,555 2,733,289 2,794,156 2,875,074 2,866,518 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. 26 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 365,966 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,441ADMINISTRATIVE ASSISTANT I - 40,525.00 - 30%12,158ADMINISTRATIVE ASSISTANT II - 41,724.00 - 45%18,776DIR 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,508DIR 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 1,033,623 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 BendExpenditures2:00pm 09/25/1727 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 18,212 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 63,917 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 3,475 2,525 5,700LEVEL TEXTTEXT AMT02 NEW IN 2017 - BASED ON YEARS OF SERVICE5,7005,700Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1728 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 12,151 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 46,096 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 31,484 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 119,167 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 168,988 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 16,303 12,041 30,247Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1729 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 447,279 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 4,011 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,230540405 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 4,059 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 BendExpenditures2:00pm 09/25/1730 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,500 1,8610 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 2,353,856 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 BendExpenditures2:00pm 09/25/1731 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 SUPPLIES6963486006003650600LEVEL TEXTTEXT AMT02 COPY PAPER600600202-0607-431.21-04 OTHER OFFICE SUPPLIES2,334761 4,800 5,137866640 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 104,770 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 3,161 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,996 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 BendExpenditures2:00pm 09/25/1732 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,87594964 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 12,504 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 129,380 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 115,423 104,846 175,000LEVEL TEXTTEXT AMT02 SIGNAL EQUIPMENT MAINTENANCE/REPAIR/CONSTRUCTION175,000175,000202-0607-431.23-01 BUILDING MATERIALS1,726 3,1210 1,904 1,902 1,7560LEVEL TEXTTEXT AMT02 MOVED TO 22-24 IN 2017202-0607-431.23-02 STREET MATERIAL906,552 550,310 644,333 907,187 503,391 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,926 1,267232 10,000LEVEL TEXTTEXT AMT02 MISCELLANEOUS CONCRETE REPAIRS10,00010,000202-0607-431.23-20 SMALL TOOLS & EQUIPMENT 77,547 23,456 70,000 91,832 31,394 28,986 70,000LEVEL TEXTTEXT AMTFund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1733 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 621,680 243,166 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 1,158,322 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 203,616 152,712 310,309LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #1310,309Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1734 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,760 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 2,224 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 255,960LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION #7255,960INFORMATION TECHNOLOGYNEW IN 2017 - INCLUDES 311, VOIP, GIS, IT255,960202-0607-431.32-04 TELEPHONE6,240 5,842 2,640 2,962754599 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 BendExpenditures2:00pm 09/25/1735 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 - MEALS495370605605605623 1,500LEVEL TEXTTEXT AMT02 APWA CONFERENCE, MISCELLANEOUS TRAINING1,5001,500202-0607-431.32-25 TRAVEL - OTHER9355288288235217750LEVEL 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 200,408 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 12,420 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,196 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 BendExpenditures2:00pm 09/25/1736 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,963 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 27,944 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,326 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 620,142 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 125,160 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 2,591 1,748 12,935LEVEL TEXTTEXT AMT02 2014 - 2016 AVERAGE, REALIGNMENT SERVICES12,93512,935Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1737 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,606 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,062 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 BendExpenditures2:00pm 09/25/1738 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,835,350 1,360,079 3,882,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 5,363,523 3,679,063 10,534,218Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1739 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 47,031 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,566ADMINISTRATIVE ASST I - 40,525.00 - 5%2,026ADMINIISTRATIVE 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 115,109 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 29,354 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,800798723 6,102LEVEL TEXTTEXT AMT02 50 HRS/EMPLOYEE:AVGWAGE20.34X1.5X4X506,1026,102202-0619-431.10-06 LONGEVITY PAY00450450450300450LEVEL 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 BendExpenditures2:00pm 09/25/1740 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 14,485 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 18,594 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,785 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 57,396 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 INSURANCE564611624624440312630LEVEL TEXTTEXT AMT02 LIFE - 5.25 X 5.00 X 24 PAY PERIODS630630202-0619-431.11-11 SHOE ALLOWANCE74889900000Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1741 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 ALLOWANCE563442453453302227453LEVEL 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 BENEFITS40000040000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES369,141 388,312 426,993 426,993 290,847 204,481 442,182202-0619-431.22-01 CENTRAL SERVICE GASOLINE0 4,068 6,250 6,250 3,879 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,184842618 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 44,379 12,076 87,500LEVEL TEXTTEXT AMTFund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1742 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,000908431 1,750LEVEL TEXTTEXT AMT02 VESTS, SAFETY GLASSES, CURB LAWN REPAIR MATERIAL,1,750MISC. MASONRY SUPPLIES1,750------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES63,071 97,068 97,655 100,187 53,626 19,835 102,230202-0619-431.31-06 OTHER PROFESSIONAL SVCS 565,242 557,566 830,717 1,102,080 449,975 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 34,536 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,361 19,229 21,000Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1743 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 31,277 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 536,223 307,547 955,588------------ ------------ ------------ ------------ ------------ ------------ ------------** CURB/SIDEWALK PROGRAM1,107,115 1,272,789 1,505,093 1,878,998 880,696 531,863 1,500,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** MOTOR VEHICHLE HWY FUND8,630,943 8,671,202 10,744,134 11,765,531 6,244,219 4,210,926 12,034,218Fund 202 - Motor Vehicle HighwayCity of South BendExpenditures2:00pm 09/25/1744 City of South Bend, Indiana 2018 Budget Fund 249 - Public Safety LOIT 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 6,466,190 6,791,160 7,467,618 3,733,809 7,629,539 7,782,130 7,937,772 8,096,528 8,258,458 161,921 2% Interest Earnings 5,373 6,989 11,000 4,263 6,000 6,120 6,242 6,367 6,495 (5,000) -45% Other Income 13 - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue 6,471,576 6,798,149 7,478,618 3,738,072 7,635,539 7,788,250 7,944,015 8,102,895 8,264,953 156,921 2% Expenditures by Dept Police (0805)3,868,694 3,546,339 4,181,866 2,145,871 4,339,380 4,371,935 4,458,664 4,547,099 4,637,273 157,514 4% Fire (0905)3,254,182 2,953,297 3,280,779 1,549,796 3,424,968 3,440,924 3,510,790 3,582,094 3,654,867 144,189 4% Total Expenditures 7,122,876 6,499,636 7,462,645 3,695,667 7,764,348 7,812,859 7,969,453 8,129,193 8,292,140 301,703 4% Expenditures by Type Personnel Salaries & Wages 5,187,944 4,666,735 5,279,241 2,691,779 5,469,960 5,448,407 5,532,567 5,617,419 5,702,935 190,719 4% Fringe Benefits 1,934,932 1,832,901 2,183,404 1,003,888 2,294,388 2,364,453 2,436,886 2,511,774 2,589,205 110,984 5% Total Personnel 7,122,876 6,499,636 7,462,645 3,695,667 7,764,348 7,812,859 7,969,453 8,129,193 8,292,140 301,703 4% Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Education & Training - - - - - - - - - - - Travel - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - - - - - - - - - - Capital - - - - - - - - - - - Total Expenditures 7,122,876 6,499,636 7,462,645 3,695,667 7,764,348 7,812,859 7,969,453 8,129,193 8,292,140 301,703 4% Net Surplus / (Deficit)(651,300) 298,513 15,973 42,405 (128,809) (24,610) (25,438) (26,298) (27,187) Beginning Cash Balance 1,291,845 640,958 938,797 954,770 825,961 801,351 775,913 749,615 Cash Reserve Cash Adjustments 413 (674) - - - - - - Ending Cash Balance 640,958 938,797 954,770 825,961 801,351 775,913 749,615 722,428 Cash Reserves Target 569,830 519,971 597,012 621,148 625,029 637,556 650,335 663,371 Fund Purpose: Explain Significant Revenue, Expenditure and Staffing Changes/Variances Below: 8% of Annual expenditures - one month reserve The Public Safety Local Option Income Tax (LOIT) Fund was established in 2010 due to Indiana's property tax "circuit breaker" system that effectively limited property tax receipts. The City has adopted a special income tax of one quarter of one percent (0.25%) to be used solely for the salaries of public safety employees who were formerly paid by property taxes. There are no significant changes in expenditures as the collective bargaining agreement calls for 2% wage increase for Police and assume 2% for Fire. Public Safety Local Option Income Tax (LOIT) revenue is expected to increase approximately 2% per year. 45 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresPUBLIC SAFETY - LOIT FUND249-0805-421.10-01 REGULAR WAGES2,337,419 2,091,995 2,445,023 2,445,023 1,778,796 1,250,527 2,536,736LEVEL TEXTTEXT AMT02 43 1ST CLASS PATROLMAN43 X $57,9982,493,923ADJUST BUDGET SO THAT REVENUE = EXPENDITURES9,687-DIRECTOR OF PUBLIC SAFETY (50%)52,5002,536,736249-0805-421.10-04 EXTRA AND OVERTIME329,890 312,250 301,437 301,437 275,787 190,484 307,466LEVEL TEXTTEXT AMT02 PS LOIT FUNDED OT 1ST CLASS PATROLMAN$41.82 X 7,352 HOURS307,466307,466249-0805-421.10-06 SPECIAL PAYS168,423 143,475 258,243 258,243 186,077 129,865 258,243LEVEL TEXTTEXT AMT02 PS LOIT SPECIALITY PAYSNIGHT INCENTIVE PAYSECOND DETAIL $2,500X 6 EMP15,000THIRD DETAIL $3,500X 15 EMP52,500STREET CRIMES UNIT $1,200 X 2 EMP2,400HAZARD PAYSOSREGULARPAY$1,150X0EMPSWAT $1,150 X 7 EMP8,050K9UNITS$1,150X3EMP3,450STREET CRIMES UNIT $900 X 21,800HOSTAGE NEGOTIATORS $800 X 1 EMP800CRIME SCENE TECHNICIAN $1,000 X 77,000CUT(RAPIDRESPONSE)$450X7EMP3,150DIAGRAMMER$450X4EMP1,8004-9 SERVICE YEARS $1,200 X 2530,00010-14 SERVICE YEARS $2,000 X 1530,000SENORITY SHIFT2ND DETAIL $1,100 X 88,8003RD DETAIL $1,400 X 6 EMP8,400INVESTIGATOR PRO PAYINVESTIGATOR FROM PFC $3,421 X 5 EMP17,105FIELD TRAINING OFFICER PRO PAY325.5 DAYS X $50 PER DAY16,275ON CALL STATUS PAY$650 X 106,500SICK LEAVE BUY BACK 1610 HOURS X $26.1042,013RESIDENCY INCENTIVE $400 X 8 EMP3,200258,243Fund 249 - Public Safety Local Option Income Tax (PS LOIT)City of South BendExpenditures2:00pm 09/25/1746 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures249-0805-421.10-12 CRITICAL DUTY DAYS11,897 10,407 19,350 19,350 10,538 6,971 19,350LEVEL TEXTTEXT AMT02 CRITICAL DUTY PAY (6&3) 120 EMP $15019,35019,350249-0805-421.11-01 FICA - REGULAR000000 4,017LEVEL TEXTTEXT AMT02 REGULAR SALARY = $52,500 X 7.65%4,0174,017249-0805-421.11-03 FICA - POLICE42,110 37,522 44,911 44,911 32,396 22,717 41,250LEVEL TEXTTEXT AMT02 43 SWORN OFFICERS TOTAL WAGES 2,844,800 X 1.45%41,25041,250249-0805-421.11-04 PERF - REGULAR000000 5,880LEVEL TEXTTEXT AMT02 REGULAR SALARY = $52,5005,8805,880249-0805-421.11-06 PERF - POLICE UNION473,938 408,825 441,424 441,424 324,531 228,241 460,893LEVEL TEXTTEXT AMT02 43 OFFICERS X $61,250 X 17.5%460,893460,893249-0805-421.11-07 UNEMPLOYMENT COMP2,500 3,650 5,000 5,000000LEVEL TEXTTEXT AMT02 UNEMPLOYMENT COMP ALLOCATION249-0805-421.11-08 HEALTH INSURANCE439,373 480,771 603,998 603,998 414,542 280,793 633,758LEVEL TEXTTEXT AMT02 SWORN HEALTH INSURANCE38 EMP X $671 X 24 PERIODS612,5605 EMP X 218 X 12 PERIODS (INS REBATE)13,08037 GROUP TERM LIFE INSURANCE EMP X $0.04 X 12181 DIRECTOR OF PUBLIC SAFETY8,100633,758249-0805-421.11-09 LIFE INSURANCE4,975 4,555 2,280 2,280 3,780 2,590 5,220LEVEL TEXTTEXT AMTFund 249 - Public Safety Local Option Income Tax (PS LOIT)City of South BendExpenditures2:00pm 09/25/1747 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 LIFE INSURANCE FRINGE BENEFIT38 OFFICERS X $10 X 12 PERIODS5,1601 DIRECTOR OF PUBLIC SAFETY605,220249-0805-421.11-10 CLOTHING ALLOWANCE58,169 52,889 60,200 60,200 50,135 33,685 60,200LEVEL TEXTTEXT AMT02 SWORN CLOTHING ALLOWANCEANNUAL CASH ALLOWANCE $1,400 X 43 EMP60,20060,200249-0805-421.11-29 PARENTAL LEAVE000000 6,367LEVEL TEXTTEXT AMT02 .25% OF PAYROLL6,3676,367------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES3,868,694 3,546,339 4,181,866 4,181,866 3,076,582 2,145,871 4,339,380------------ ------------ ------------ ------------ ------------ ------------ ------------** POLICE - PS LOIT FUNDED3,868,694 3,546,339 4,181,866 4,181,866 3,076,582 2,145,871 4,339,380Fund 249 - Public Safety Local Option Income Tax (PS LOIT)City of South BendExpenditures2:00pm 09/25/1748 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures249-0905-422.10-01 REGULAR WAGES1,997,226 1,797,315 1,983,870 1,983,870 1,364,021 979,985 2,076,047LEVEL TEXTTEXT AMT02 35 FIREFIGHTER 1ST CLASS SALARIES @ $57,8162,023,5471 DIRECTOR OF PUBLIC SAFETY (50%)52,5002,076,047249-0905-422.10-04 EXTRA AND OVERTIME203,111 239,714 155,880 155,880 156,943 101,873 155,880LEVEL TEXTTEXT AMT02 EXTRA AND OVERTIME155,880155,880249-0905-422.10-06 SPECIAL PAYS11,140 24,048 23,650 23,650 4,080 3,795 24,450LEVEL TEXTTEXT AMT02 SPECIAL PAY24,45024,450249-0905-422.10-07 FLSA24,196 18,655 18,000 18,000 15,243 12,429 18,000LEVEL TEXTTEXT AMT02 2,035 HOURS X $9.40 FLSA PAY18,00018,000249-0905-422.10-08 SICK LEAVE BUY BACK/RETIR 13,753000000249-0905-422.10-11 WORKING OUT OF CLASSIFICA 12,164 11,576 13,200 13,200 16,033 10,035 13,200LEVEL TEXTTEXT AMT02 OUT OF CLASSIFICATION PAY13,20013,200249-0905-422.10-12 CRITICAL DUTY DAYS13,518 17,300 60,588 60,588 6,655 5,818 60,588LEVEL TEXTTEXT AMT02 $204CRITICALDUTYDAYX9DAYSX 33FIREFIGHTERS 60,58860,588249-0905-422.10-13 NEO-NATAL16,754000340 14,101-0249-0905-422.10-14 FIRE PRO PAY48,4530000 14,1010249-0905-422.11-01 FICA - REGULAR000000 4,017LEVEL TEXTTEXT AMT02 REGULAR SALARY = $52,500 X 7.65%4,0174,017249-0905-422.11-02 FICA - FIRE33,314 31,215 46,026 46,026 22,922 16,390 46,946LEVEL TEXTTEXT AMTFund 249 - Public Safety Local Option Income Tax (PS LOIT)City of South BendExpenditures2:00pm 09/25/1749 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 FICA @ 1.45% OF SALARIES46,94646,946249-0905-422.11-04 PERF - REGULAR000000 5,880LEVEL TEXTTEXT AMT02 REGULAR SALARY = $52,500 X 11.2%5,8805,880249-0905-422.11-05 PERF - UNION425,266 355,731 362,490 362,490 248,564 178,855 369,433LEVEL TEXTTEXT AMT02 PENSION BASE OF $60,316 @ 17.5%369,433369,433249-0905-422.11-07 UNEMPLOYMENT COMP1,875 2,984 4,960 4,960000LEVEL TEXTTEXT AMT02 UNEMPLOYMENT COMP ALLOCATION249-0905-422.11-08 HEALTH INSURANCE405,577 391,795 542,500 542,500 317,503 222,411 575,100LEVEL TEXTTEXT AMT02 HEALTH INSURANCE $16,200 EACH567,000DIRECTOR OF PUBLIC SAFETY8,100575,100249-0905-422.11-09 LIFE INSURANCE4,059 3,850 4,200 4,200 2,869 2,020 4,260LEVEL TEXTTEXT AMT02 LIFE INSURANCE (35 X $120)4,200DIRECTOR OF PUBLIC SAFETY604,260249-0905-422.11-10 CLOTHING ALLOWANCE30,826 28,614 32,375 32,375 24,045 16,188 32,375LEVEL TEXTTEXT AMT02 CLOTHING ALLOWANCE AT $925 PER FIREFIGHTER32,37532,375249-0905-422.11-15 MEDICAL, SURGICAL, DENTAL0 20,160 20,790 20,79000 21,350LEVEL TEXTTEXT AMT02 FIREFIGHTER PHYSICALS @ $630 PER FIREFIGHTER21,35021,350249-0905-422.11-29 PARENTAL LEAVE000000 5,192LEVEL TEXTTEXT AMTFund 249 - Public Safety Local Option Income Tax (PS LOIT)City of South BendExpenditures2:00pm 09/25/1750 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 .25% OF PAYROLL5,1925,192249-0905-422.11-99 OTHER FRINGE BENEFITS12,950 10,340 12,250 12,250 10,4070 12,250LEVEL TEXTTEXT AMT02 DEFFERED COMPENSATION CONTRIBUTION @ $350 PER FF12,25012,250------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES3,254,182 2,953,297 3,280,779 3,280,779 2,189,625 1,549,796 3,424,968------------ ------------ ------------ ------------ ------------ ------------ ------------** FIRE - PS LOIT FUNDED3,254,182 2,953,297 3,280,779 3,280,779 2,189,625 1,549,796 3,424,968------------ ------------ ------------ ------------ ------------ ------------ ------------*** PUBLIC SAFETY - LOIT FUND7,122,876 6,499,636 7,462,645 7,462,645 5,266,207 3,695,667 7,764,348Fund 249 - Public Safety Local Option Income Tax (PS LOIT)City of South BendExpenditures2:00pm 09/25/1751 City of South Bend, Indiana 2018 Budget Fund 404 - County Option Income Tax 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 8,859,912 9,454,023 10,459,265 5,229,633 10,906,293 11,233,482 11,570,486 11,917,600 12,275,128 447,028 4% Interest Earnings 84,868 97,589 100,000 38,605 95,000 97,000 99,000 101,000 103,000 (5,000) -5% Other Income 970,750 876,349 504,153 370,364 610,131 320,132 135,659 137,585 12,965 105,978 21% Transfers In - 3,039 - - - - - - - - - Total Revenue 9,915,530 10,431,000 11,063,418 5,638,602 11,611,424 11,650,614 11,805,145 12,156,185 12,391,093 548,006 5% Expenditures by Type Personnel Salaries & Wages 242,049 291,039 - - - - - - - - - Fringe Benefits 84,108 112,652 - - - - - - - - - Total Personnel 326,157 403,691 - - - - - - - - - Supplies 793,015 770,006 1,234,438 449,200 806,390 810,000 817,000 824,000 831,000 (428,048) -35% Services & Charges Professional Services 870,749 1,465,713 827,376 435,942 1,284,500 1,059,500 1,059,500 1,059,500 1,059,500 457,124 55% Printing & Advertising 151,440 1,739 2,000 975 2,000 2,000 2,000 2,000 2,000 - 0% Utilities 1,545,997 1,541,784 1,580,000 787,137 1,652,000 1,622,000 1,642,000 1,662,000 1,682,000 72,000 5% Education & Training 28,809 8,502 14,114 12,430 - - - - - (14,114) -100% Travel 21,557 13,074 - - - - - - - - - Repairs & Maintenance 1,535,804 2,433,438 1,667,678 695,657 1,310,865 1,320,000 1,340,000 1,360,000 1,380,000 (356,813) -21% Other Interfund Allocations 531,168 519,600 - - - - - - - - - Debt Service Principal 2,061,389 2,213,678 1,224,053 643,795 993,679 995,000 100,000 1,005,000 1,010,000 (230,374) -19% Interest & Fees 385,609 348,865 58,284 34,451 60,933 50,000 52,000 54,000 56,000 2,649 5% Grants & Subsidies 541,938 553,857 530,874 282,937 1,344,575 540,000 540,000 540,000 540,000 813,701 153% Insurance 7,308 8,220 7,137 3,570 6,873 6,900 7,000 7,100 7,200 (264) -4% Transfers Out 1,500,000 1,500,000 3,442,578 1,546,116 2,787,600 3,900,000 4,800,000 5,000,000 6,000,000 (654,978) -19% Other Services & Charges 1,672,496 1,584,370 968,432 496,501 931,800 1,296,800 1,296,800 1,296,800 1,296,800 (36,632) -4% Total Services & Charges 10,854,264 12,192,840 10,322,526 4,939,510 10,374,825 10,792,200 10,839,300 11,986,400 13,033,500 52,299 1% Capital Land - 27,550 123,350 - 115,000 115,000 115,000 115,000 115,000 (8,350) -7% Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment 805,680 135,143 26,279 24,868 - - - - - (26,279) -100% Infrastructure 2,860 74,281 365,000 - 180,000 180,000 180,000 180,000 180,000 (185,000) -51% Total Capital 808,540 236,974 514,629 24,868 295,000 295,000 295,000 295,000 295,000 (219,629) -43% Total Expenditures 12,781,976 13,603,511 12,071,593 5,413,578 11,476,215 11,897,200 11,951,300 13,105,400 14,159,500 (595,378) -5% Net Surplus / (Deficit)(2,866,446) (3,172,511) (1,008,175) 225,025 135,209 (246,586) (146,155) (949,215) (1,768,407) Beginning Cash Balance 14,935,342 12,066,548 8,935,608 7,927,433 8,062,642 7,816,056 7,669,901 6,720,686 Cash Reserve Cash Adjustments (2,348) 41,571 - - - - - - Ending Cash Balance 12,066,548 8,935,608 7,927,433 8,062,642 7,816,056 7,669,901 6,720,686 4,952,279 Cash Reserves Target 6,390,988 6,801,756 6,035,797 5,738,108 5,948,600 5,975,650 6,552,700 7,079,750 Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: 50% of Annual expenditures This fund accounts for the receipt and expense of County Option Income Tax (COIT). The revenue is determined annually by the Indiana Department of Local Government Finance (DLGF). Expenditures in this fund include debt service payments, maintenance, and the Curb & Sidewalk program. The COIT tax rate is 0.6% of gross wages in Saint Joseph County and the City of South Bend receives an allocated percentage of this revenue. The growth rate of COIT revenue is projected to be 2% per year for 2018 - 2022. Other income represents principal payments on an interfund loan to the Urban Development Action Grant (UDAG) Fund 410 in connection with the 1st Source Bank/Hotel renovation project. In 2018, telephone expenditures in the amount of $550,329 were transferred from the COIT Fund to the IT-Innovation Fund 279. Transfers are requested to fund EMS operations and EMS capital in 2019-2022. Total transfers for 2019-2022 = $7.4 million. 52 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresC.O.I.T.404-0401-415.31-06 OTHER PROFESSIONAL SVCS000000 274,500LEVEL TEXTTEXT AMT02 OPIOD EPIDEMIC SERVICES74,500EARLY CHILDHOOD EDUCATION (CAPACITY BUILDING100,000MEASURES)PERMANENT SUPPORTIVE HOUSING (HOMELESS INITIATIVE) 100,000274,500404-0401-415.37-03 OFFICE SPACE40,000 40,000 40,000 40,00000 40,000LEVEL TEXTTEXT AMT02 ST JOSEPH COUNTY PROSECUTOR/FAMILY JUSTICE40,000CENTER - METRO HOMICIDE - SPECIAL VICTIM UNIT($40,000 PAID IN 2010 AND 2011)BPW AGREEMENT APPROVED 10/18/12. SOUTH BEND PAYS$40,000 PER YEAR FOR FIVE YEARS. 2013-2017ST. JOE COUNTY PAYS $45,000 PER YEAR FOR THE SAMETIME PERIOD40,000404-0401-415.37-11 CAPITAL LEASE PRINCIPAL 1,569,039 1,686,730 909,733 909,733 794,628 449,475 993,679LEVEL TEXTTEXT AMT02 2011 CENTURY CENTER BOND REFUNDING (25%)- FUND 4072014 POLICE VEHICLES KEY GOVT FINANCE #124222,8242015 POLICE VEHICLES BANK OF AMERICA #140 - % CCD167,4852015 POLICE VEHICLES PNC BANK #1445,0692016 POLICE VEHICLES PNC BANK #152258,4732016 HP COMPUTER #15525,5812017 POLICE/SUSTAINABILITY LEASE #162314,247993,679404-0401-415.37-12 CAPITAL LEASE INTEREST343,261 319,287 52,024 52,024 47,519 28,331 60,933LEVEL TEXTTEXT AMT02 2011 CENTURY CENTER BOND REFUNDING (25%)- FUND 4072014 POLICE VEHICLES KEY GOVT FINANCE #1246,1022015 POLICE VEHICLES BANK OF AMERICA #140 - 50%6,1502015 POLICE VEHICLES PNC BANK #1442192016 POLICE VEHICLES PNC BANK #15215,1242016 HP COMPUTER LEASE #1553,5742017 POLICE/SUSTAINABILITY LEASE #16229,76460,933------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES1,952,300 2,046,017 1,001,757 1,001,757 842,147 477,805 1,369,112Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1753 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures------------ ------------ ------------ ------------ ------------ ------------ ------------** CONTROLLER1,952,300 2,046,017 1,001,757 1,001,757 842,147 477,805 1,369,112Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1754 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0408-453.39-30 GRANTS AND SUBSIDIES65,000 65,000 65,000 65,00000 65,000LEVEL TEXTTEXT AMT02 SOUTH BEND MUSEUM OF ART GRANT65,000SAME AMOUNT AS IN PRIOR YEARS65,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES65,000 65,000 65,000 65,00000 65,000------------ ------------ ------------ ------------ ------------ ------------ ------------** ART ASSOCIATION65,000 65,000 65,000 65,00000 65,000Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1755 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0409-453.34-02 LIABILITY INSURANCE7,308 7,128 7,137 7,137 4,760 3,570 6,873LEVEL TEXTTEXT AMT02 2018 FIXED COST ALLOCATION6,873LIABILITY INSURANCE - STUDEBAKER6,873404-0409-453.39-30 GRANTS AND SUBSIDIES255,938 260,857 265,874 265,874 199,406 132,937 270,991LEVEL TEXTTEXT AMT02 STUDEBAKER MUSEUM SUBSIDY - 2% INCREASE260,991MAINTENANCE RESERVE FUND - MATCHING CITY AMOUNT10,000270,991------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES263,246 267,985 273,011 273,011 204,166 136,507 277,864------------ ------------ ------------ ------------ ------------ ------------ ------------** STUDEBAKER MUSEUM263,246 267,985 273,011 273,011 204,166 136,507 277,864Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1756 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0602-431.22-40 SIGNALS/LIGHTS89,928 146,528 140,000 140,000 63,0000 140,000LEVEL TEXTTEXT AMT02 LIGHT UP SOUTH BEND PROGRAM - STREET LIGHTS140,000LIGHTING SUPPLIES140,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES89,928 146,528 140,000 140,000 63,0000 140,000404-0602-431.31-06 OTHER PROFESSIONAL SVCS0 24,407 60,000 60,000 39,691 39,691 60,000LEVEL TEXTTEXT AMT02 LIGHT UP SOUTH BEND - PROFESSIONAL SERVICES60,000FOR THE LAMPOST PROGRAM60,000404-0602-431.33-01 OUTSIDE PRINTING SERVICES010300000404-0602-431.39-01 REFNDS,AWARDS,INDEMNITIES025000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 24,760 60,000 60,000 39,691 39,691 60,000404-0602-431.43-10 OTHER EQUIPMENT755,680 135,14300000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL755,680 135,14300000------------ ------------ ------------ ------------ ------------ ------------ ------------** ENGINEERING845,608 306,431 200,000 200,000 102,691 39,691 200,000Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1757 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0608-431.36-10 STREET MAINTENANCE0 304,0940 312,251 291,639 249,5930------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 304,0940 312,251 291,639 249,5930------------ ------------ ------------ ------------ ------------ ------------ ------------** LOCAL ROADS & STREETS0 304,0940 312,251 291,639 249,5930Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1758 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0617-415.21-04 OTHER OFFICE SUPPLIES0 3,563 8,000 8,000000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES0 3,563 8,000 8,000000404-0617-415.36-02 OFFICE EQUIP R&M047500000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES047500000404-0617-431.31-01 LEGAL SERVICES294,644 146,752 180,000 30,000 25,999 17,942 200,000LEVEL TEXTTEXT AMT02 OTHER LEGAL COSTS NOT PAID IN DEPT BUDGETS OR IN200,000THE LIABILITY INSURANCE FUND200,000404-0617-431.31-06 OTHER PROFESSIONAL SVCS 117,268 226,242 125,000 201,200 140,828 108,5190LEVEL TEXTTEXT AMT02 PRIORITY BASED BUDGETING - THIRD YEARLINKED IN LITEBOTH IN IT ALLOCATION FOR 2018404-0617-431.31-20 ACCOUNTING SERVICES000 22,500 22,500 7,5000404-0617-431.32-04 TELEPHONE545,366 525,088 550,000 550,329 516,754 332,4900LEVEL TEXTTEXT AMT02 CITY TELEPHONE COSTS (MOVED TO FUND 279)404-0617-431.33-03 PROMOTIONAL151,440 1,636 2,000 2,000 1,097975 2,000LEVEL TEXTTEXT AMT02 RECYCLING FEES2,0002,000404-0617-431.35-01 ELECTRIC1,545,997 1,541,784 1,578,000 1,578,000 1,035,477 787,137 1,650,000LEVEL TEXTTEXT AMT02 STREET LIGHTS AND SIGNALS ELECTRICITY - AEP1,650,0001,650,000404-0617-431.35-04 WATER00 2,000 2,00000 2,000LEVEL TEXTTEXT AMT02 NEW ACCOUNT FOR 2017 - WATER SPRINKLERS ON2,000ROUNDABOUTS AND MEDIANS ON ST. JOE STREET2,000404-0617-431.36-01 BUILDING & STREET MAINT 449,384 425,973 500,000 452,113 3,1360 470,000LEVEL TEXTTEXT AMTFund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1759 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures02 BUILDING MAINTENANCE FOR COUNTY-CITY BLDG450,000PAID TO ST. JOSEPH COUNTYPAID ONCE PER YEAR FOR THE PRIOR FISCAL YEAROTHER COUNTY CITY MAINTENANCE COSTS20,000470,000404-0617-431.36-05 OTHER EQUIP R&M5,639 5,864 6,099 6,099 6,099 6,0990404-0617-431.37-05 PARKING SPACE RENTAL000 9,800 5,0960 20,400LEVEL TEXTTEXT AMT02 PARKING LOT NEAR THE COUNTY-CITY BUILDING20,40020,400404-0617-431.37-11 CAPITAL LEASE PRINCIPAL 178,539 186,263 194,320 314,320 194,320 194,3200404-0617-431.37-12 CAPITAL LEASE INTEREST22,040 14,317 6,260 6,260 6,120 6,1200404-0617-431.39-11 DUES & MEMBERSHIPS27,080 29,137 31,800 31,800 19,834 19,834 32,400LEVEL TEXTTEXT AMT02 AIM DUES20,600US CONFERENCE OF MAYORS10,000INDIANA CONFERENCE OF MAYORS300INDIANA UBRAN MAYOR'S CONFERENCE1,50032,400404-0617-431.39-30 GRANTS AND SUBSIDIES0 28,00000000404-0617-431.39-60 ELECTION EXPENSE0 112,44000000404-0617-431.39-89 MISC CHARGES & SVCS138,532 135,230 152,500 142,70000 149,000LEVEL TEXTTEXT AMT02 ST. JOE COUNTY ANNUAL ARCHIVES FEE96,000ST. JOE COUNTY ANNUAL WEIGHTS AND MEASURES FEE53,000149,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES3,475,929 3,378,726 3,327,979 3,349,121 1,977,260 1,480,935 2,525,800------------ ------------ ------------ ------------ ------------ ------------ ------------** UTILITIES & SERVICES3,475,929 3,382,764 3,335,979 3,357,121 1,977,260 1,480,935 2,525,800Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1760 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0619-431.50-02 INTER-FUND OPER. TRANSFRS 1,500,000 1,500,000 1,677,224 1,677,224 838,612 838,612 1,500,000LEVEL TEXTTEXT AMT02 TRANSFER TO MVH FUND 202 TO COVER CURB AND1,500,000SIDEWALK PROGRAM BUDGET(202-0619)TRANSFER TO ACCT #202-0000-392.00-001,500,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES1,500,000 1,500,000 1,677,224 1,677,224 838,612 838,612 1,500,000------------ ------------ ------------ ------------ ------------ ------------ ------------** CURB/SIDEWALK PROGRAM1,500,000 1,500,000 1,677,224 1,677,224 838,612 838,612 1,500,000Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1761 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0672-415.10-01 REGULAR WAGES233,109 291,03900000404-0672-415.10-03 SEASONAL & INTERNS8,940000000404-0672-415.11-01 FICA - REGULAR18,860 21,41600000404-0672-415.11-04 PERF - REGULAR25,976 31,53300000404-0672-415.11-07 UNEMPLOYMENT COMP068300000404-0672-415.11-08 HEALTH INSURANCE37,502 57,60000000404-0672-415.11-09 LIFE INSURANCE37076000000404-0672-415.11-22 PARKING ALLOWANCE960000000LEVEL TEXTTEXT AMT02 PARKING (MOVING ALL EMPLOYEES TO CITY LOT)404-0672-415.11-24 CELL PHONE ALLOWANCE44066000000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES326,157 403,69100000404-0672-415.21-04 OTHER OFFICE SUPPLIES6,491 21,4320 3,476 3,118 3,1180404-0672-415.21-05 SMALL OFFICE EQUIPMENT19,098 32,7620 3,709 1,470 1,4700404-0672-415.23-25 COMPUTER EQUIPMENT17,561 15,8780 161,571 149,182 149,1820------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES43,150 70,0720 168,756 153,770 153,7700404-0672-415.31-06 OTHER PROFESSIONAL SVCS 305,198 847,3150 458,676 321,834 262,290 600,000LEVEL TEXTTEXT AMT02 ERP SYSTEM IMPLEMENTATION600,000600,000404-0672-415.31-70 ADM FEE ALLOCATION531,168 519,60000000404-0672-415.32-21 TRAVEL - MILEAGE1,265 3,38500000404-0672-415.32-22 TRAVEL - AIRFARE4,404 1,96300000404-0672-415.32-23 TRAVEL - HOTEL11,944 5,52600000404-0672-415.32-24 TRAVEL - MEALS2,011 1,53000000404-0672-415.32-25 TRAVEL - OTHER1,93367000000404-0672-415.34-02 LIABILITY INSURANCE0 1,09200000404-0672-415.36-04 COMPUTER EQUIP R&M634,825 923,5640 49,728 37,564 13,5640404-0672-415.37-11 CAPITAL LEASE PRINCIPAL 313,811 340,68500000404-0672-415.37-12 CAPITAL LEASE INTEREST20,308 15,26100000404-0672-415.39-11 DUES & MEMBERSHIPS030000000404-0672-415.39-70 EDUCATION & TRAINING28,809 8,5020 14,114 12,430 12,4300------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES1,855,676 2,669,3930 522,518 371,828 288,285 600,000404-0672-415.43-08 COMPUTER EQUIP. & NETWORK 50,00000 26,279 24,868 24,8680------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL50,00000 26,279 24,868 24,8680------------ ------------ ------------ ------------ ------------ ------------ ------------** INFORMATION TECHNOLOGY2,274,983 3,143,1560 717,553 550,466 466,922 600,000Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1762 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0801-421.22-01 CENTRAL SERVICE GASOLINE 530,023 437,339 717,682 717,682 313,053 233,370 500,000LEVEL TEXTTEXT AMT02 POLICE DEPARTMENT GASOLINE500,000500,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES530,023 437,339 717,682 717,682 313,053 233,370 500,000404-0801-421.31-06 OTHER PROFESSIONAL SVCS 100,000000000404-0801-421.31-15 GOODWILL STRATEGIC UNIT000000 150,000LEVEL TEXTTEXT AMT02 GOODWILL STRATEGIC FOCUS OUTREACH UNIT150,000COMMUNITY ORIENTED POLICING150,000404-0801-421.36-03 AUTO EQUIPMENT R&M294,650 575,152 729,400 729,400 545,032 408,314 729,400LEVEL TEXTTEXT AMT02 POLICE DEPARTMENT AUTO REPAIR COSTS729,400SEE ALSO ACCOUNT NO. 101-0801-421-36-03729,400404-0801-421.36-04 COMPUTER EQUIP R&M25,684 100,0730 18,087 18,087 18,0870404-0801-421.36-06 RADIO EQUIP R&M49,001000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES469,335 675,225 729,400 747,487 563,119 426,401 879,400------------ ------------ ------------ ------------ ------------ ------------ ------------** POLICE DEPARTMENT999,358 1,112,564 1,447,082 1,465,169 876,172 659,771 1,379,400Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1763 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-0901-422.22-01 CENTRAL SERVICE GASOLINE 129,914 112,504 200,000 200,000 83,814 62,060 166,390LEVEL TEXTTEXT AMT02 FIRE DEPARTMENT GASOLINE166,390166,390------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES129,914 112,504 200,000 200,000 83,814 62,060 166,390404-0901-422.36-03 AUTO EQUIPMENT R&M0 98,243 100,000 100,000 53,4260 111,465LEVEL TEXTTEXT AMT02 FIRE VEHICLE REPAIRS100,000FLEET MAINT COSTS TRANSFERRED FROM ACCOUNT NO.11,465101-0901-422-36-03111,465------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 98,243 100,000 100,000 53,4260 111,465------------ ------------ ------------ ------------ ------------ ------------ ------------** FIRE DEPT129,914 210,747 300,000 300,000 137,240 62,060 277,855Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1764 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-1001-460.31-06 OTHER PROFESSIONAL SVCS 53,639 220,9970 55,000000404-1001-460.39-30 GRANTS AND SUBSIDIES221,000 200,000 200,000 200,000 150,000 150,000 1,008,584LEVEL TEXTTEXT AMT02 WEST SIDE MAIN STREETS MATCHING GRANTS200,000SMALL BUSINESS DEVELOPMENT ASSISTANCE454,465(ALSO SEE 408-1001-460-39-30)NEIGHBORHOOD STRATEGY IMPLEMENTATION - OWNER273,564OCCUPIED TRANSFERRED FROM 408-1001-460-39-30NEIGHBORHOOD STRATEGY IMPLEMENTATION - OWNER80,555OCCUPIED TRANSFERRED FROM 408-1001-460-39-301,008,584404-1001-460.39-64 PROPERTY MANAGEMENT6,965000000404-1001-460.39-79 NEIGHBORHOOD PARTNERSHIPS0 118,1240 9,503 9,385 9,385 50,000LEVEL TEXTTEXT AMT02 WEST SIDE MAIN STREETS IMPLEMENTATION50,00050,000404-1001-460.39-89 MISC CHARGES & SVCS48,091 7,04500000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES329,695 546,166 200,000 264,503 159,385 159,385 1,058,584404-1001-460.41-01 LAND0 27,550 95,000 123,35000 115,000LEVEL TEXTTEXT AMT02 PROPERTY ACQUISITION115,000115,000404-1001-460.42-03 STREETS AND ALLEYS2,860 74,281 180,000 365,000 36,3910 180,000LEVEL TEXTTEXT AMT02 COMPLETE STREETS TRANSPORTATION PROJECTS180,000180,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL2,860 101,831 275,000 488,350 36,3910 295,000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD ENGAGEMENT332,555 647,997 475,000 752,853 195,776 159,385 1,353,584Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1765 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-1050-452.50-02 INTER-FUND OPER. TRANSFRS000 350,347000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES000 350,347000404-1050-460.39-64 PROPERTY MANAGEMENT000 1,650000404-1050-460.39-89 MISC CHARGES & SVCS00 350,3470000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 350,347 1,650000------------ ------------ ------------ ------------ ------------ ------------ ------------** COMMUNITY INVESTMENT00 350,347 351,997000Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1766 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-1100-452.50-02 INTER-FUND OPER. TRANSFRS00 1,415,007 1,415,007 707,504 707,504 1,287,600LEVEL TEXTTEXT AMT02 TRANSFER TO THE PARKS & REC FUND 2011,800,000TRANSFER TO ACCT #201-0000-338.00-00REDUCE TRANSFER TO PARKS TO BALANCE PARKS BUDGET512,400-1,287,600------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES00 1,415,007 1,415,007 707,504 707,504 1,287,600------------ ------------ ------------ ------------ ------------ ------------ ------------** ADMINISTRATION00 1,415,007 1,415,007 707,504 707,504 1,287,600Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1767 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-1101-460.39-79 NEIGHBORHOOD PARTNERSHIPS00 140,000 140,000 143,902 119,592 140,000LEVEL TEXTTEXT AMT02 CORRIDORS AMBASSADOR PROGRAM - BLOCK BY BLOCK140,000140,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES00 140,000 140,000 143,902 119,592 140,000------------ ------------ ------------ ------------ ------------ ------------ ------------** PARK MAINTENANCE00 140,000 140,000 143,902 119,592 140,000Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1768 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures404-1201-415.39-87 VACANT & ABANDONED866,462 616,7560 42,650 15,200 15,200 500,000LEVEL TEXTTEXT AMT02 V&A DEMOLITIONS - WAS IN EDIT FUND500,000408-1201-415-39-89 IN 2017ACCOUNT TO BE MANAGED BY CODE ENFORCEMENT IN 2018500,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES866,462 616,7560 42,650 15,200 15,200 500,000404-1201-431.36-04 COMPUTER EQUIP R&M76,621000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES76,621000000------------ ------------ ------------ ------------ ------------ ------------ ------------** NEIGHBORHOOD CODE ENF.943,083 616,7560 42,650 15,200 15,200 500,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** C.O.I.T.12,781,976 13,603,511 10,680,407 12,071,593 6,882,775 5,413,578 11,476,215Fund 404 - County Option Income Tax (COIT)City of South BendExpenditures2:00pm 09/25/1769 City of South Bend, Indiana 2018 Budget Fund 471 - 2017 Parks Bond Fund Type Capital Project Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings - - - - 3,000 500 - - - 3,000 - Bond Proceeds - - - - - - - - - - - Other Income - - - - - - - - - - - Transfers In - - - - - - - - - - - Total Revenue - - - - 3,000 500 - - - 3,000 - Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services - - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Other Interfund Allocations - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges - - - - - - - - - - - Capital Land - - - - - - - - - - - Land Improvements - - - - 10,309,100 3,479,400 - - - 10,309,100 - Buildings & Bldg Improve.- - - - - - - - - - - Motor Equipment - - - - - - - - - - - Machinery & Equipment - - - - - - - - - - - Infrastructure - - - - - - - - - - - Total Capital - - - - 10,309,100 3,479,400 - - - 10,309,100 - Total Expenditures - - - - 10,309,100 3,479,400 - - - 10,309,100 - Net Surplus / (Deficit)- - - - (10,306,100) (3,478,900) - - - Beginning Cash Balance - - - 13,785,000 3,478,900 - - - Cash Reserve Cash Adjustments - - 13,785,000 - - - - - Ending Cash Balance - - 13,785,000 3,478,900 - - - - Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: These are the various projects: Series A - Howard Park Series G - Seitz Park Riverfront promenade AM General parking and plaza area Stormwater habitat area East Race promenade and bridge Series B - St. Louis Street Series H - Pinhook Park St. Louis Street parking and street upgrades (Howard Park) Pavillion upgrade Series C - Colfax-Seitz Reconnect river flow to lagoon Riverfront trail upgrades - Colfax to Seitz Park Playground and site improvements Series D - Howard-Farmers Series I - Other Park Improvements Riverfront trail upgrades - Howard Park to Farmer's Market Park security, lighting, and storage Series E - Miami-Twyckenham Restrooms modernization & ADA compliance Riverfront trail upgrades - Miami to Twyckenham Series J - Pinhook Park Series F - Seitz-Howard Pinhook Park neighborhood connectivity Riverfront trail upgrades - Seitz Park to Howard Park Series K - Future Project Seitz Park parking Future park acquisitions, partnerships, and build-outs Bond fund - spend down to zero - no reserves required During 2017, the City of South Bend plans to issue a Parks bond in the amount of $14,010,000 for certain improvements in connection with the MY SB Parks and Trails initiative. The bond is expected to go the the Parks Board and Common Council for approval in September and October and the closing is expected in December 2017. The bonds will be issued on a competitive basis and net proceeds after bond issuance costs are expected to be $13,785,000. The bonds will be repaid over a period of 15 years with the first debt service payment due on July 15, 2018 and the final payment due on January 15, 2033. 70 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue2017 PARKS BOND471-0000-361.00-00 INTEREST EARNINGS000000 3,000------------ ------------ ------------ ------------ ------------ ------------ ------------*0000003,000------------ ------------ ------------ ------------ ------------ ------------ ------------** 2017 PARKS BOND000000 3,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** 2017 PARKS BOND000000 3,000Fund 471 - 2017 Parks BondCity of South BendRevenue2:00pm 09/25/1771 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures2017 PARKS BOND471-1130-452.42-01 LAND IMPROVEMENTS000000 1,109,000LEVEL TEXTTEXT AMT02 RIVERFRONT PROMENADE HOWARD PARK410,000STORMWATER HABITAT AREA HOWARD PARK554,000CONTINGENCY145,0001,109,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 1,109,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES A - HOWARD PARK000000 1,109,000Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1772 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1131-452.42-01 LAND IMPROVEMENTS000000 1,437,100LEVEL TEXTTEXT AMT02 ST. LOUIS PARKING & STREET IMPROVEMENTS1,250,000HOWARD PARKCONTINGENCY187,1001,437,100------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 1,437,100------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES B - ST. LOUIS ST000000 1,437,100Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1773 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1132-452.42-01 LAND IMPROVEMENTS000000 1,050,000LEVEL TEXTTEXT AMT02 COLFAX TO SEITZ PARK - RIVERFRONT TRAIL1,050,000UPGRADES1,050,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 1,050,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES C - COLFAX-SEITZ000000 1,050,000Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1774 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1133-452.42-01 LAND IMPROVEMENTS000000 1,250,000LEVEL TEXTTEXT AMT02 VIEWING TRAIL - HOWARD TO FARMER'S MARKET1,250,000RIVERFRONT TRAIL UPGRADES1,250,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 1,250,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES D - HOWARD-FARMERS000000 1,250,000Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1775 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1134-452.42-01 LAND IMPROVEMENTS000000 800,000LEVEL TEXTTEXT AMT02 LWW MIAMI TO TWYCHENHAM - RIVERFRONT TRAIL800,000UPGRADE800,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 800,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES E - MIAMI - TWYCH000000 800,000Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1776 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1135-452.42-01 LAND IMPROVEMENTS000000 750,000LEVEL TEXTTEXT AMT02 SEITZ PARK TO HOWARD PARK750,000SEITZ PARK PARKING - $375,000 (2019)750,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 750,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES F - SEITZ PARK000000 750,000Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1777 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1137-452.42-01 LAND IMPROVEMENTS000000 1,750,000LEVEL TEXTTEXT AMT02 RESTROOMS MODERNIZATION & ADA COMPLIANCE550,000PARK SECURITY, LIGHTING AND STORAGE1,200,0001,750,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 1,750,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES I - OTHER PARK IMP000000 1,750,000Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1778 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1139-452.42-01 LAND IMPROVEMENTS000000 1,000,000LEVEL TEXTTEXT AMT02 FUTURE PARK ACQUISITIONS AND PARTNERSHIPS1,000,0001,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 1,000,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES K - FUTURE PROJECT000000 1,000,000Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1779 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures471-1141-452.42-01 LAND IMPROVEMENTS000000 1,163,000LEVEL TEXTTEXT AMT02 EAST RACE PROMENADE AND BRIDGE875,000CONTINGENCY288,000AM GENERAL PARKING & PLAZA - $350,000 (2019)1,163,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL000000 1,163,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SERIES G - EAST RACE/AM000000 1,163,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** 2017 PARKS BOND000000 10,309,100Fund 471 - 2017 Parks BondCity of South BendExpenditures2:00pm 09/25/1780 City of South Bend, Indiana 2018 Budget Fund 642 - Sewage Works Capital Fund Type Enterprise Control City Funds 2017 2018 Budget 2015 2016 Amended 06/30/17 Proposed Forecast Variance % Actual Actual Budget Actual Budget 2019 2020 2021 2022 2017-2018 Change Revenue Interest Earnings 34,993 71,137 52,000 28,132 45,000 45,000 45,000 45,000 45,000 (7,000) -13% Bond Proceeds - - - - - - - - - - - Other Income - - 400,000 400,000 - - - - - (400,000) -100% Transfers In 8,000,000 2,487,000 4,442,000 1,442,000 9,855,000 1,263,000 1,147,000 - - 5,413,000 122% Total Revenue 8,034,993 2,558,137 4,894,000 1,870,132 9,900,000 1,308,000 1,192,000 45,000 45,000 5,006,000 102% Expenditures by Type Supplies - - - - - - - - - - - Services & Charges Professional Services 37,895 - - - - - - - - - - Printing & Advertising - - - - - - - - - - - Repairs & Maintenance - - - - - - - - - - - Debt Service Principal - - - - - - - - - - - Interest & Fees - - - - - - - - - - - Transfers Out - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - Total Services & Charges 37,895 - - - - - - - - - - Capital Land - - - - - - - - - - - Land Improvements - - - - - - - - - - - Buildings & Bldg Improve.- - - - - - 400,000 400,000 - - - Motor Equipment 1,036,942 178,256 1,525,424 704,424 1,545,000 1,613,000 1,147,000 751,000 1,312,500 19,576 1% Machinery & Equipment 1,975,527 3,899,220 6,515,031 2,119,321 5,310,000 650,000 600,000 750,000 700,000 (1,205,031) -18% Infrastructure - - - - 3,000,000 - - - - 3,000,000 - Total Capital 3,012,469 4,077,476 8,040,455 2,823,745 9,855,000 2,263,000 2,147,000 1,901,000 2,012,500 1,814,545 23% Total Expenditures 3,050,364 4,077,476 8,040,455 2,823,745 9,855,000 2,263,000 2,147,000 1,901,000 2,012,500 1,814,545 23% Net Surplus / (Deficit)4,984,629 (1,519,339) (3,146,455) (953,613) 45,000 (955,000) (955,000) (1,856,000) (1,967,500) Beginning Cash Balance 3,747,697 8,723,058 7,204,341 6,270,400 6,315,400 5,360,400 4,405,400 2,549,400 Cash Reserve Cash Adjustments (9,267) 622 2,212,514 - - - - - Ending Cash Balance 8,723,058 7,204,341 6,270,400 6,315,400 5,360,400 4,405,400 2,549,400 581,900 Cash Reserves Target - - - - - - - - Fund Purpose: Explain Significant Revenue and Expenditure Changes/Variances Below: No Reserves - transfer from operating account as needed This fund is used to purchase capital equipment and fund major renovations/restorations for the Wastewater and Sewer Departments. Cash adjustment of $2,212,514 is to bring cash balance to $6,263,400 actual at 6/30/17. The 2018 budget includes $1.5 million dollars in revenue transferred from TIF for improvements related to the expansion of the South Bend Chocolate Café.C2 81 201720172017 6/30/17 201820152016 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueSEWAGE DEPRECIATION FUND642-0000-360.91-01 POKAGON CONTRIBUTION000 400,000 400,000 400,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 400,000 400,000 400,0000642-0000-361.00-00 INTEREST EARNINGS34,993 71,137 45,000 52,000 44,368 28,132 45,000LEVEL TEXTTEXT AMT02 ESTIMATED INTEREST BASED ON FUND BALANCE45,00045,000------------ ------------ ------------ ------------ ------------ ------------ ------------*34,993 71,137 45,000 52,000 44,368 28,132 45,000642-0000-392.00-00 INTERFUND OPER. TRANSFER 8,000,000 2,487,000 4,442,000 4,442,000 2,442,000 1,442,000 9,855,000LEVEL TEXTTEXT AMT02 2018 BUDGET:FOR SEWER DEPT. CAPITAL REQUESTS2,750,000FOR WASTEWATER CAPITAL REQUESTS5,605,000FUNDS FROM TIF FOR CHOCOLATE CAFE EXPANSION1,500,0009,855,000------------ ------------ ------------ ------------ ------------ ------------ ------------*8,000,000 2,487,000 4,442,000 4,442,000 2,442,000 1,442,000 9,855,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWAGE DEPRECIATION FUND8,034,993 2,558,137 4,487,000 4,894,000 2,886,368 1,870,132 9,900,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE DEPRECIATION FUND8,034,993 2,558,137 4,487,000 4,894,000 2,886,368 1,870,132 9,900,000Fund 642 - Sewage Works CapitalCity of South BendRevenue2:00pm 09/25/1782 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresSEWAGE DEPRECIATION FUND642-0621-415.42-05 SEWER REHABILITATION000000 3,000,000LEVEL TEXTTEXT AMT02 SEWER LINING750,000LTCP750,000SEWER EXTENSION FOR CHOCOLATE CAFE EXPANSION1,500,000FUNDS RECEIVED FROM TIF3,000,000642-0621-415.43-02 MOTOR EQUIPMENT982,983 118,032 675,000 1,297,130 628,130 628,130 1,250,000LEVEL TEXTTEXT AMT02 2 EA CREW TRUCKS320,0002 EA SINGLE AXLE DUMP TRUCKS300,0001 EA RUBBER TRACK EXCAVATOR200,0002 EA ZTR MOWERS & TRAILER30,0001 EA JET RODDER/VACTOR400,0001,250,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL982,983 118,032 675,000 1,297,130 628,130 628,130 4,250,000------------ ------------ ------------ ------------ ------------ ------------ ------------** SEWER DEPARTMENT982,983 118,032 675,000 1,297,130 628,130 628,130 4,250,000Fund 642 - Sewage Works CapitalCity of South BendExpenditures2:00pm 09/25/1783 201720172017 6/30/17 201820152016 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures642-0630-415.31-06 OTHER PROFESSIONAL SVCS 37,895000000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES37,895000000642-0630-415.43-02 MOTOR EQUIPMENT53,959 60,224 152,000 228,294 76,294 76,294 295,000LEVEL TEXTTEXT AMT02 CRANE TRUCK-REPLACE 2000 S/N 470240,0003/4 TON CARGO VAN-REPLACE 2006 S/N 49440,000UTILITY CART-REPLACE 2006 S/N 67615,000295,000642-0630-415.43-08 COMPUTER EQUIP. & NETWORK00 15,000 15,00000 30,000LEVEL TEXTTEXT AMT02 UPGRADE SCADA SERVER #315,000UPGRADE SCADA SERVER #415,00030,000642-0630-415.43-10 MISCELLANEOUS EQUIPMENT0 170,7380 5,192 5,192 5,192 80,000LEVEL TEXTTEXT AMT02 REPLACE AGING ICP EQUIPMENT IN WASTEWATER LAB80,00080,000642-0630-415.43-66 TREATMENT & DISPOSAL EQ. 1,975,527 3,728,482 3,600,000 6,494,839 2,729,433 2,114,129 5,200,000LEVEL TEXTTEXT AMT02 FARMINGTON 14B LIFT STATION REPLACEMENT500,000WWTP ELECTRICAL & BACK-UP GENERATORS4,000,000UPGRADE RAW PUMP #2500,000INSTALL CL2 RAS FOR FILAMENT CONTROL200,0005,200,000------------ ------------ ------------ ------------ ------------ ------------ ------------* CAPITAL2,029,486 3,959,444 3,767,000 6,743,325 2,810,919 2,195,615 5,605,000------------ ------------ ------------ ------------ ------------ ------------ ------------** WASTEWATER DEPARTMENT2,067,381 3,959,444 3,767,000 6,743,325 2,810,919 2,195,615 5,605,000------------ ------------ ------------ ------------ ------------ ------------ ------------*** SEWAGE DEPRECIATION FUND3,050,364 4,077,476 4,442,000 8,040,455 3,439,049 2,823,745 9,855,000Fund 642 - Sewage Works CapitalCity of South BendExpenditures2:00pm 09/25/1784