The URL can be used to link to this page

Home My WebLink AboutSession IV - Transpotrans P o south bend public transportation corporation 2018 FISCAL OPERATING & CAPITAL BUDGET January 1, 2018 through December 31, 2018 Prepared By South Bend Public Transportation I a I F I I I Imi''i"; lima 4111 I 2018 Revenue Projection .................................................................................... 1 2018 Expense Projection .................................................................................... 2 2018 Appropriations ............................................................................................ 3 2018 Budget Assumptions .................................................................................. 4 2018 Budget Policy Statements .......................................................................... 6 2018 Budget Summaries by Category — All Accounts .........................................7 2018 REVENUE PROJECTION %° CHANGE - 2017 BUDGET VS. Actual SOURCE 2018 BUDGET 2017 BUDGET 2016 ACTUAL 2018 BUDGET 2016 ACTUAL FAREBOX $ 1,642,051 $ 1,469,079 $ 1,364,468 11.77% 20.34% CHARTER Is - $ - $ - 0.00% 0.00% ADVERTISING $ 79,497 $ 72,000 $ 72,000 10.41% 10.41% LEASE REVENUE $ 2,400 $ 2,400 $ 253,150 0.00% -99.05% CONCESSIONS AND MISCELLANEOUS $ 34,311 $ 23,500 $ 27,860 46.00% 23.15% INTEREST INCOME $ 13,045 $ 12,985 $ 2,713 0.46% 380.83% PROPERTY TAX $ 2,954,329 $ 2,883,701 $ 2,844,454 2.45% 3.86% LICENSE EXCISE TAX $ 208,548 $ 227,789 $ 228,762 -8.45% -8.84% FINANCIAL INSTITUTION TAX Is - $ - $ - 0.00% 0.00% OPTION INCOME TAX $ 547,130 $ 433,262 $ 685,597 26.28% -20.20% STATE ASSISTANCE $ 2,130,958 $ 2,029,483 $ 1,9841401 5.00% 7.39% FEDERAL PREVENTIVE MAINTENANCE $ 11440,000 $ 1,640,000 $ 1,202,592 -12% 19.74% FEDERAL ASSISTANCE $ 1,410,000 $ 1,875,000 $ 1,344,600 -25% 4.86% LEASE PAYMENT FROM CITY $ 200,000 $ 200,000 $ 200,000 0% 0.00% TOTAL $10,662,269 $ 10,869,199 $ 10,210,597 -1.90%1 4.42% 2018 EXPENSE PROJECTION % CHANGE - 2018 BUDGET VS. Actuz Expense Category 2018 BUDGET 2017 BUDGET 2016 AUDITED 2017 BUDGET 2016 AUDITED Tang ible Property / Fixed Assets $ - $ - $ - N/A N/A Salaries ,& Wages $ 5,801,603 $ 5,806,671 $ 5,214,135 -0.09% 11.27% Fringe Benefits $ 2,204,108 $ 2,438,603 $ 2,326,561 -9.62% -5.26% Services $ 479,200 $ 502,661 $ 808,875 -4.67% -40.76% Materials & Supplies $ 1,015,465 $ 1,029,736 $ 1,278,078 -1.39% -20.55% Utilities $ 299,223 $ 278,857 $ 232,241 7.30% 28.84% Insurance $ 230,477 $ 230,477 $ 215,543 0.00% 6.93% Other Taxes $ - $ - N/A N/A Miscellaneous $ 132,192 $ 132,192 $ 157,975 0.00% -16.32% SUB -TOTAL $ 10,162,269 $10,419,199 $ 10,233,408 -2.47% -0.70% Transfer - Capital Improvements / Reserve for Liability $ 500,000 $ 450,000 $ - 11.11% 100.00% TOTAL $ 10,662,269 $10,869,199 $ 10,233,408 -1.90% 4.19% TRANSPO Budgeted Appropriations Category O eratin Budget Capital Bud et Total 2018 Appropriations 2018 2017 2018 2017 Personnel Services Other Services and Charges Supplies Capital Outlays 8,005,711 1,641,092 1,015,466 239,620 8,245,274 1,594,187 1,029,736 181,310 1,087,860 1,043,138 8,005,711 1,641,092 1,015,466 1,327,480 Total Appropriations $10,901,888 $11,050,507 $ 1,087,860 $1,043,138 $ 11,989,748 Federal, State, and Local: In the past, Transpo has been successful in securing adequate funding through Federal Capital Grants for major capital projects; however, funding opportunities are decreasing. Transpo is able to continue to avail ourselves of annual federal capital formula grant funds toward preventative maintenance and operating assistance, such funds available to the operations budget. In 2018, the State of Indiana has fixed PMTF rate for the next two years and has made it a line item in the State's Budget. We based the 2018 PMTF revenue on discussion with Indiana Department of Transportation. This caused our budget figure to be increase by $101,475 from the 2017 budget. Property Tax revenue was budgeted at $51,386 increase from the prior year. iidershii2 and Revenue: Transpo has entered into new contracts with Notre Dame and St. Mary's College's in 2017 that have provided increases in farebox revenues. Transpo is also looping into other options to increase future revenues, for example the DTSB Game Day express that will begin this fall. Transpo Access has realized an increase in ridership since 2008 and is expected to continue this trend in future years EmpDpAfee Wages and Benefits: For 2018, Transpo budgeted, a slight decrease in wages for employees. Employee benefits reflect an estimated decrease of 10.63% from 2017 budget. This decrease is mainly due to changing health insurance carriers in 2017. Vehicullar ancel Opefraton o Vehicular and other insurances costs will be maintained at the 2017 budget. Diesel fuel has been budgeted at an average of $2.00 per gallon and gasoline at $2.00 per gallon. In 2017, Transpo received an additional three CNG fueled vehicles, increasing our total CNG vehicles to twenty-two. Transpo budgeted a decrease, in its overall fuel cost, of $86,605. This decrease in fuel expenses should continue to as more of fixed route vehicles are converted to CNG. U'L'(dflUeso Utility costs were budgeted with an increased from the 2017 forecasted levels. MaUk o Marketing contracts, services, and advertising placement accounts have not been changed from 2017 budgeted figures. 4 Training: The 2018 budgeted amounts increased from 2017 budgeted provisions. Transpo plans to use federal grants to offset most of the cost associated with training. The current budget provides continued opportunities for all positions. Transfer — Capital Improvement Fund/Restricted Liability Reserve: The 2018 budget provides the opportunity to transfer up to $500,000 to the Capital Improvements fund for future capital expenditures or deposit up to $500,000 into a restricted liability reserve account, to be used pay off the second year installments on sixteen fixed route vehicles. UPON THE ADOPTION OF BUDGET BY THE SOUTH1D PUBLIC TRANSPORTATION BOARD OF DIRECTORS, A MONTHLY BUDGET, BASED ON HISTORICAL AND FUTURE TRENDS, WILL BE ESTABLISHED. THIS WILL • FACILITATE THE MONTHLYOF REPORTS BYBOARD MEMBERS AND INTERNAL MANAGEMENT. C trans P o 2018 ®PERi4TJNG : UDD GLT POUC Y STA TEMC N ITSS 1. Management will continue to search for investment, grant and funding opportunities so as to maximize revenues. 2. Management will assure cash handling practices to safeguard funds in its protection and toward timely collection of funds owed. SERVOC E POUCCY: J. A review of current services levels will be conducted and recommendations will follow based upon the results of the analysis. 4. Access service will be provided in accordance with all applicable FTA guidelines. H At NI A3 GEPulENT- 5. A professional workforce will carry out our Mission Statement. Management will assure fairness, even-handedness, consistency, and effective Equal Employment Opportunity and Affirmative Action policies and practices. 6. Assumes continuation of team development, employee recognition, and continuation of increased opportunities for employee training. 7. Assumes continued pursuit of programs of wellness and accident prevention in an effort to stem, to whatever extent possible, rising insurance costs. C 2018 BUDGET SUBMISSION All ACCOUNT TITLE: Salaries & Wages Summary 2016 ACTUAL $ 5,036,056 2018 BUDGET REQUEST $ 5,801,603 2017 MONTHLY AVERAGE $ 444,901 2017 APPROVED BUDGET $ 5,806,671 2017 EST EXPENSE $ 5,338,806 BUDGET CHANGE $ (5,068) Account Title 2017 2018 Operators $ 3,548,243 $ 3,486,899 Access Drivers & Clerk 460,277 472,854 Operations Administration 457,724 525,115 Revenue -Vehicle Maintenance 722,279 686,318 Maintenance Administration 123,792 127,216 Non -Revenue -Vehicle Maintenance 73,064 74,136 General Administration 421,292 429,065 Total $5,806,671 $ 5,801,603 h 1 t114.3.1irelki ACCOUNT TITLE: Fringe Benefits Summary 2016 ACTUAL $ 1,779,272 2018 BUDGET REQUEST $ 2,204,108 2017 MONTHLY AVERAGE $ 163,404 2017 APPROVED BUDGET $ 2,438,604 2017 EST EXPENSE $ 1,960,847 BUDGET CHANGE $ (234,496) Account Title 2017 2018 FICA $ 444,211 $ 443,822 Pension plan 248,694 257,216 Medical Insurance 1,492,087 1,245,731 Dental Insurance 53,878 54,464 Life Insurance 27,221 28,000 Short -Term Disability 20,664 21,420 Unemployment Insurance 10,925 11,246 Worker's Compensation 89,805 89,654 Uniforms 47,119 48,555 Tool Allowance 4,000 4,000 Total $2,438,604 $ 2,204,108 DEPARTMENT: All ACCOUNT TITLE: Services 2018 BUDGET SUBMISSION Summary 2016 ACTUAL $ 984,072 2018 BUDGET REQUEST $ 479,200 2017 MONTHLY AVERAGE $ 45,751 2017 APPROVED BUDGET $ 502,661 2017 EST EXPENSE $ 551,509 BUDGET CHANGE $ (23,461) Account Title 2017 2018 Professional & Technical $ 240,939 $ 205,939 Board Travel 10,000 10,000 Temporary Help 2,500 2,500 Contract Services Operations 12,050 12,050 Contract Services Maintenance 118,582 130,121 Contract Services Administration 54540 541540 Security Services 64,050 64,050 Physical Damage Repairs 20,000 20,000 Recoveries of Physical Damage Repairs (20,000) (20,000) Total $ 502,661 9 $ 479,200 DEPARTMENT: 2018 BUDGET SUBMISSION All Materials & Supplies Summary 2016 ACTUAL $ 1,479,781 2018 BUDGET REQUEST $ 1,015,465 2017 MONTHLY AVERAGE $ 52,285 2017 APPROVED BUDGET $ 813,732 2017 EST EXPENSE $ 627,425 BUDGET CHANGE $ 201,733 Account Title 2017 2018 Fuel & Lubricants Operations $ 511,118 $ 640,517 Fuel & Lubricants Maintenance 11,954 10,981 Tires & Tubes Maintenance 2,560 2,560 Materials & Supplies Operations 25,000 25,000 Materials & Supplies Maintenance 210,000 285,307 Materials & Supplies Marketing 35,600 33,600 Other Materials & Supplies Operations 4,500 4,500 Other Materials & Supplies Maintenance 2,600 2,600 Other Materials & Supplies General Administration 10,400 10,400 Total $ 813,732 $ 1,015,465 2018 BUDGET SUBMISSION DEPARTMENT: Administration & Maintenance ACCOUNT TITLE: Utilities ACCOUNT NUMBER: 505-0x50-00 505-Ox2x-00 2016 ACTUAL $ 209,394 2018 BUDGET REQUEST $ 299,223 2017 MONTHLY AVERAGE $ 21,906 2017 APPROVED BUDGET $ 278,857 2017 EST EXPENSE $ 262,868 BUDGET CHANGE $ 20,366 Account Title 2017 2018 Electricity $ 98,014 $ 98,014 Electricity -CNG $ 45,941 $ 65,307 Water & Sewage $ 16,654 $ 16,654 Trash Collection $ 5,000 $ 6,000 Telephone $ 34,000 $ 34,000 Natural Gas $ 79,248 $ 79,248 Totals $ 278,857 $ 299,223 11 J DEPARTMENT: ACCOUNT TITLE: Insurance Summary 2016 ACTUAL $ 190,051 2018 BUDGET REQUEST $ 230,477 2017 MONTHLY AVERAGE $ 17,592 2017 APPROVED BUDGET $ 230,477 2017 EST EXPENSE $ 2117108 BUDGET CHANGE $ - Insurance - Liability & Physical Damage Other Corporate Insurance M $ 224,192 6,285 Total $ 230,477 2018 BUDGET SUBMISSION DEPARTMENT: All ACCOUNT TITLE: Miscellaneous Summary 2016 ACTUAL $ 151,083 2018 BUDGET REQUEST $ 132,192 2017 MONTHLY AVERAGE $ 15,522 2017 APPROVED BUDGET $ 132,192 2017 EST EXPENSE $ 188,537 BUDGET CHANGE $ - Account Title 2017 2018 Dues & Subscriptions $ 25,192 $ 25,192 Travel & Meetings 30,000 307000 Community Services 15,000 15,000 Promotion 6,000 67000 Advertising Placements 451500 457500 Interest Expense on Tax Warrants/Loans 101500 10,500 Total $ 132,192 $ 132,192 13 DEPARTMENT: All ACCOUNT TITLE: Transfer - Capital Improvement Fund/Reserve for Liability ACCOUNT NUMBER: 301-0101-00 2016 ACTUAL $ - 2018 BUDGET REQUEST $ 500)000 2017 MONTHLY AVERAGE $ 41,667 2017 APPROVED BUDGET $ 450,000 2017 EST EXPENSE $ 500,000 BUDGET CHANGE $ 50,000 This account is used for the transfer to the Capital Improvement Fund for the "Local Share" or to fund a reserve for future liabilities. The capital expenditures are detailed in the monthly Capital Improvement resolutions. Loan Payment E Total 500,000 1' • DEPARTMENT: All ACCOUNT TITLE: Capital Fund Requirements ACCOUNT NUMBER: 301-0101-00 2016 ACTUAL $ 6,121,744 2018 BUDGET REQUEST $ 1,087,860 2017 MONTHLY AVERAGE $ 173,785 2017 APPROVED BUDGET $ 1,043,138 2017 EST EXPENSE $ 21085,425 BUDGET CHANGE $ 44,722 $$$ FTA/State Total Grant Number Available Funded Required Grant- IN -34-019 $ 56,391 $ 45,113 $ 11,278 Grant- IN -95-0048 $ 185,097 $ 148,078 $ 37,019 Grant- IN -04-0053 $ 1,600,000 $ 1,290,200 $ 309,800 Grant IN -16-21 $ 26,000 $ 26,000 Grant -IN -90-X650 $ 100,000 $ 80,000 $ 20,000 Grant -IN -90-X685 $ 200,000 $ 160,000 $ 400,000 Grant- IN- 90-X694 $ 100,000 $ 80,000 $ 20,000 2016-2017 FTA GRANT $ 2,000,000 $ 1,600,000 $ 400,000 Total $ 4,267,488 W $ 3,429,390 $ 1,198,098 J C ky, I M1 rel ACCOUNT TITLE: Passenger Fares Summary ACCOUNT NUMBER: 413-0100-00 2016 ACTUAL: $ 1,408,767 2018 BUDGET REQUEST $ 1,642,051 2017 AVERAGE: $ 117,420 2017 APPROVED BUDGET $ 1,504,253 2017 ESTIMATED: $ 1,409,034 BUDGET CHANGE: $ 137,798 Account Title 2017 2018 Passenger Revenue $ 802,698 $ 778,419 Access Passenger Revenue 51,187 63,013 Access Punch Card Revenue 73,321 104,770 Passport Revenue 166,075 189,840 Student Pass Revenue 41,130 47,320 Tripper Revenue 9,623 9 676 ' Two Week Pass 90, 048 133, 254 One Day Pass 263,721 311,860 Student Summer Pass 6,450 3,900 $ 1,504,252 $ 1,642,051 IN