Loading...
HomeMy WebLinkAbout5. Streamline Budget to Actuals June 2021_UpdatedOperating 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,298,398 1,298,398 693,554 MDT-5311 Operating Grant 1,236,777 381,027 *381,027 30.81%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 26,667 26,667 98.77%26,667 Associated Students of MSU 164,500 133,170 133,170 0 80.95%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 $2,291,084 $2,176,084 $30,000 $42,500 $42,500 $0 0 $0 115.75%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 813,369 608,591 26,098 82,973 73,720 0 21,987 0 94.24%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 10,018 10,018 66.79%1,680 Mystery Rider Contract 8,000 9,408 9,408 117.60%8,064 Salaries and Fringe Benefits 150,000 141,247 141,247 94.16%124,490 HRDC Admin.Cost Allocations 82,000 83,961 83,961 102.39%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 154,252 123,649 4,924 11,933 10,562 0 3,184 0 61.70%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 16,674 16,674 128.26%16,271 Parking Garage Cleaning 15,000 27,800 27,800 185.34%13,317 Travel and Training 8,000 2,496 2,496 31.20%2,560 Advertising/PR 40,000 41,316 32,275 1,879 3,357 2,819 0 987 0 103.29%70,474 Supplies 5,000 11,302 11,302 226.03%5,069 DTC Space/Dispatcher (Donated In-Kind)0 0 -0 Communications 8,000 8,094 8,094 0 0 0 0 0 0 101.18%9,681 Audit 2,000 2,393 2,393 119.65%2,080 Other 2,000 1,072 1,072 53.62%473 Equipment-Other 1,000 18,034 18,034 1803.39%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,642,018 $1,324,540 $59,311 $120,285 $105,930 $0 31,951 $0 82.00%1,746,403 $1,646,080 Operating Surplus/(Deficit)1 649,066 *851,544 (29,311)(77,785)(63,430)0 (31,951)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 9/16/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_09.15.21