Loading...
HomeMy WebLinkAboutPort Ludlow Trails Coslition 2 DRAFT Budgetvs.Actuals__Budget_FY26_P&L_adjustments needed to Q2__Report printed 9.14.26 1/2 TOTAL Actual Budget Over budget by Percent of budget Revenue 4000 Contributions and Grants 4010 Individual Contributions 99,505.07 179,656.26 -80,151.19 55.39 % 4015 Map Donations 3,898.00 250.02 3,647.98 1559.08 % 4020 Sponsorships 13,500.00 49,999.98 -36,499.98 27.0 % 4050 Foundation Grants 161,337.48 -161,337.48 0.0 % 4060 Government Grants 40,127.16 109,410.00 -69,282.84 36.68 % Total for 4000 Contributions and Grants $157,030.23 $500,653.74 -$343,623.51 31.37 % 4200 Membership Dues 2,690.00 1,999.98 690.02 134.5 % 4300 Events Income 66,728.40 40,000.02 26,728.38 166.82 % 4500 Merchandise Sales 7,945.96 499.98 7,445.98 1589.26 % Uncategorized Income 1,000.02 -1,000.02 0.0 % Total for Revenue $234,394.59 $544,153.74 -$309,759.15 43.08 % Cost of Goods Sold 5000 Cost of Goods Sold 14,250.00 -14,250.00 0.0 % Total for Cost of Goods Sold $14,250.00 -$14,250.00 0.0 % Gross Profit $234,394.59 $529,903.74 -$295,509.15 44.23 % Expenditures 5100 Program Services $234.41 $234.41 5110 Maps 11,250.00 -11,250.00 0.0 % 5120 Outreach and Education 9,611.98 22,999.98 -13,388.00 41.79 % Total for 5100 Program Services $9,846.39 $34,249.98 -$24,403.59 28.75 % 5200 Trail Work 5210 Trail Preparatory Work 2,000.00 2,000.00 5220 Construction 2,646.11 7,500.00 -4,853.89 35.28 % 5250 Trail Maintenance 12.47 13,200.00 -13,187.53 0.09 % 5260 Equipment Rental 16,402.56 41,800.02 -25,397.46 39.24 % 5290 Trail Crew Expenses 2,552.37 2,749.98 -197.61 92.81 % Total for 5200 Trail Work $23,613.51 $65,250.00 -$41,636.49 36.19 % 5900 Partnerships 5,000.00 12,499.98 -7,499.98 40.0 % 6000 General and Operating Expenses 6010 Salaries and Wages 57,772.91 138,250.02 -80,477.11 41.79 % 6020 Payroll Taxes and Benefits 7,223.42 48,387.48 -41,164.06 14.93 % 6025 Employee Benefits 7,500.00 7,500.00 6030 Office Supplies 639.41 3,750.00 -3,110.59 17.05 % 6040 Insurance 1,387.00 1,500.00 -113.00 92.47 % 6050 Professional Fees (Legal, Acct, Consultants)28,375.45 43,000.02 -14,624.57 65.99 % 6051 Contractors (excludes Ambassadors)51,700.00 20,749.98 30,950.02 249.16 % 6055 Marketing & Communications (includes Social Media, Ads)1,500.00 13,500.00 -12,000.00 11.11 % 6056 Mailing and Postage 1,712.24 1,000.02 712.22 171.22 % 6057 Volunteer and Appreciation expense 4,500.00 -4,500.00 0.0 % 6060 Occupancy and Storage (Rent/Utilities)6,034.89 8,700.00 -2,665.11 69.37 % 6070 Information Technology (Hardware or 3,211.64 8,749.98 -5,538.34 36.7 % DRAFT Q2 financials - Please note that this is an incomplete picture of the PTC's finances in Q2 and we are working with our accountant to include the following: entries from balance sheet to income statement, grant activity, Angeles millworks credit usage, and RunSignUp holdbacks 2/2 TOTAL Actual Budget Over budget by Percent of budget Subscriptions) 6080 Strategic Sustainment 8,753.49 22,500.00 -13,746.51 38.9 % 6090 Licenses, Permits and Membership Fees 2,150.90 1,500.00 650.90 143.39 % 6091 Travel & Expense 1,776.40 12,499.98 -10,723.58 14.21 % 6099 Other General and Operating Expenses 3,499.98 -3,499.98 0.0 % Total for 6000 General and Operating Expenses $179,737.75 $332,087.46 -$152,349.71 54.12 % 6100 Bank and Investment Fees -553.22 4,000.02 -4,553.24 -13.83 % 7000 Fundraising Expenses 7010 Fundraising Salaries 4,999.98 -4,999.98 0.0 % 7020 Fundraising Event Expenses (including Consultants)40,021.87 47,500.02 -7,478.15 84.26 % 7030 Fundraising Materials & Supplies 14,793.12 22,000.02 -7,206.90 67.24 % 7035 Fundraising Mailing & Postage 3,237.58 7,999.98 -4,762.40 40.47 % 7040 Other Fundraising Expenses (financial txn fees)1,190.48 1,549.98 -359.50 76.81 % Total for 7000 Fundraising Expenses $59,243.05 $84,049.98 -$24,806.93 70.49 % Total for Expenditures $276,887.48 $532,137.42 -$255,249.94 52.03 % Net Operating Revenue -$42,492.89 -$2,233.68 -$40,259.21 1902.37 % Other Revenue 4810 Interest Income 1,164.57 17,500.02 -16,335.45 6.65 % 4820 Dividend Income 9,076.51 9,076.51 4840 Unrealized Gains (Losses)37,010.84 37,010.84 Total for Other Revenue $47,251.92 $17,500.02 $29,751.90 270.01 % Other Expenditures 6200 Depreciation Expense 2,250.00 -2,250.00 0.0 % Total for Other Expenditures $2,250.00 -$2,250.00 0.0 % Net Other Revenue $47,251.92 $15,250.02 $32,001.90 309.85 % Net Revenue $4,759.03 $13,016.34 -$8,257.31 36.56 %