Loading...
HomeMy WebLinkAbout5. Streamline BudgetActuals_June PreliminaryOperating MSU Percent of Capital Actual FUND REVENUES Budget Actual YTD Daytime Latenight Saturday Livingston Bridger Sunday Shuttle Budget Actual YTD FYE 6/30/20 MDT Capital Grants (Vehicles)$$1,436,010 $ MDT-5311 Capital Grant (Replace Engines) MDT-CARES ACT 23,235 1,300,000 1,300,000 693,554 MDT-5311 Operating Grant 1,236,777 0 *0 0.00%696,669 ARP Grant 0 9,080 9,080 - Local Revenue:0 -- MSU-Livingston/Saturday 85,000 85,000 42,500 42,500 100.00%135,000 MSU-Additional Hour (Evening)27,000 27,000 27,000 100.00%26,667 Associated Students of MSU 164,500 87,454 87,454 0 53.16%138,556 ASMSU-Late Night Service 30,000 30,000 0 30,000 100.00%30,000 Bozeman Health 10,000 0 -10,000 Contract Income - Bridger/Bohart 41,000 0 0 0.00%32,625 Contract Income - Reach 60,000 0 0 0.00%30,000 City of Bozeman 300,000 300,000 300,000 0 100.00%150,000 City of Belgrade 8,000 20,000 20,000 250.00%10,000 Contributions 1,000 20 20 0 2.00%1,305 Redesign Streamline 2020 Match 0 0 0 0 0 Advertising Revenue 2,000 0 0 0.00%0 Insuance Proceeds 1,000 1,000 4,943 Investment Income/Other 0 60 60 -0 Storage Space Rental Income 14,000 6,662 6,662 0 0 0 0 47.58%14,200 In-Kind Donations (DTC space/Dispatcher)0 0 0 -0 TOTAL REVENUE 2,002,512 $1,866,276 $1,751,276 $30,000 $42,500 $42,500 $0 0 $0 94.29%1,436,010 $1,973,519 FUND EXPENSES $Daytime Latenight Saturday Livingston Bridger Sunday MSU Shuttle Transportation Dev. Plan (TDP)0 0 56,979 0 Contract Services Karst Stage, Inc.863,100 771,084 579,091 26,098 76,465 69,134 0 20,295 0 89.34%777,996 Paratransit Contract (Galavan)127,411 0 0 0.00%101,500 Reach 60,000 0 0 0.00%30,000 ASMSU Monitors 15,000 0 0 0.00%1,680 Mystery Rider Contract 8,000 4,032 4,032 50.40%8,064 Salaries and Fringe Benefits 150,000 141,240 141,240 94.16%124,490 HRDC Admin.Cost Allocations 82,000 75,098 75,098 91.58%63,560 Gas and Oil 188,000 103,154 81,181 3,398 8,709 7,408 0 2,458 0 54.87%116,681 Repairs & Maintenance 250,000 147,398 117,991 4,924 11,399 10,039 0 3,045 0 58.96%0 175,856 Insurance 145,000 163,545 122,482 12,993 13,314 11,421 0 3,335 0 112.79%77,717 Bus Barn Operating Costs 13,000 13,463 13,463 103.57%16,271 Parking Garage Cleaning 15,000 30,565 30,565 203.77%13,317 Travel and Training 8,000 2,441 2,441 30.52%2,560 Advertising/PR 40,000 37,430 29,197 1,809 2,966 2,572 0 886 0 93.58%70,474 Supplies 5,000 12,024 12,024 240.47%5,069 DTC Space/Dispatcher (Donated In-Kind)0 0 -0 Communications 8,000 6,734 6,734 0 0 0 0 0 0 84.18%9,681 Audit 2,000 1,931 1,931 96.56%2,080 Other 2,000 806 806 40.32%473 Equipment-Other 1,000 17,278 17,278 1727.82%3,366 Equipment-Vehicles 0 0 0 0 -1,689,424 23,419 Equipment-Vehicle Wraps 0 14,193 14,193 -0 GPS/Fixed Route Software 20,000 19,689 19,689 98.44%21,826 Bus Shelters/Street Furniture 0 0 0 -0 TOTAL EXPENSES $2,002,511 $1,562,107 $1,269,437 $49,223 $112,852 $100,574 $0 30,020 $0 78.01%1,746,403 $1,646,080 Operating Surplus/(Deficit)1 304,169 *481,838 (19,223)(70,352)(58,074)0 (30,020)0 (310,393)327,439 Match Obligations/Capital Outlays (40,000)(310,393)(2,780) Total surplus/(deficit)(39,999)324,659 Beginning net assets 639,843 315,184 Ending net assets $599,844 $639,843 *Footnote: MDT 5311 Operating Grant is on a reimbursement basis with MDT payments received quarterly (estimates may be used) STREAMLINE BUDGET VS. ACTUAL COMPARISON July 1, 2020 through June 30, 2021 (100%) ~ Preliminary 7/15/2021 G:\Shared drives\Galavan Management\GLVN_Docs\Sunshine\Advisory Board\Budget to Actuals\FY2020-2021 BTA\2021.06 BTA\06 - 032+036 Aug BudgetActuals 21-22_sr update