Loading...
HomeMy WebLinkAbout4. Galavan Budget to Actuals June 2021_Updated Operating Percent of Capital Actual FUND REVENUES Budget Actual YTD Budget Actual YTD FYE 6/30/20 MDT Capital Grants (Vehicles)$$$55,128 $ MDT-CARES ACT 413,869 212,024 MDT-TransAde 163,789 163,789 100.00%210,717 Title III Revenue 21,400 21,400 100.00%21,400 Local Revenue:- Friends of Galavan 3,500 7,500 214.29%3,500 Gallatin County 80,000 80,000 100.00%78,500 City of Bozeman 129,000 129,423 100.33%122,183 City of Belgrade 10,000 10,000 100.00%10,000 United Way 10,000 0 0.00%5,000 Rider Donations 15,000 3,798 25.32%4,884 Contributions 2,000 3,297 164.84%2,655 Contract Income-Family Promise 5,000 0 -0 Smyth Trust/Misc Investment Income 10,500 10,500 100.00%11,053 Insurance Proceeds 0 3,749 6,422 Storage Space Rental Income 5,000 2,464 49.28%5,596 Streamline Paratransit Contract 127,411 101,500 79.66%101,500 TOTAL REVENUE $582,900 $951,287 163.20%$55,128 $795,434 FUND EXPENSES $$$$ Salaries and Fringe Benefits 391,400 383,015 97.86%349,499 HRDC Admin.Cost Allocations 55,000 54,667 99.39%44,028 Gas and Oil 55,000 42,258 76.83%42,980 Repairs and Maintenance 40,000 37,942 94.85%36,685 Insurance 18,000 20,200 112.22%20,008 Bus Barn Operating Costs 5,000 5,997 119.94%5,898 Travel and Training 2,500 937 37.47%411 Advertising/PR 1,500 985 65.70%457 Supplies 3,500 5,576 159.30%4,134 Cleaning 0 41,891 1329.86%12,150 Communications 4,500 3,038 67.52%6,090 Audit 1,000 1,309 130.87%1,386 Other (incl RM Software)5,000 6,421 128.41%11,145 Equipment-Other 500 0 0.00%32,698 413 Equipment-Vehicles 0 0 64,857 0 TOTAL EXPENSES $582,900 $604,235 103.10%$97,555 $535,284 Operating Suplus/(Deficit)0 347,053 (42,426)260,150 Match Obligations/Capital Outlays (10,000)(42,426)(7,127) Total excess/(deficit)(10,000)253,023 GALAVAN - EMILY SMYTH TRUST DONATION Beginning net assets 276,869 23,846 (as of 6/30/2021) BUDGET Ending net assets 266,869 276,869 CASH IN BANK 276,898.14 INVESTMENT ACCOUNT - STIFEL 722,833.18 - 4%LOAN RECEIVABLE - SHERWOOD APTS INC.0.00 5,500 4.2%LOAN RECEIVABLE - HOME CORP (W. BABCOCK APTS)162,588.55 5,000 1,162,319.87 10,500 *Footnote: MDT TransAde Grant is on a reimbursement basis with MDT payments received quarterly (estimates may be used) GALAVAN 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