To: Michael Green, Superintendent
From: Stacy Brown, Director of Business Services
Subject: Financial Enrollment Report
Date: April 25, 2022
I have the months of September through March reconciled. I attached some reports that include YTD expenditures and revenues through 3/31/22 and projected revenues, expenditures, and fund balance through the end of the year. I made updates to projected expenditures and revenues based upon what is known at this time. The projected fund balance is now projected to increase by $155,000. This is an increase of approximately $200,000 in comparison with January. You can see this in the Month-End Balances (page 2) and the Financial Forecast (page 5).
The General Fund Revenues Dashboard Summary (page 3) shows a summary of revenues and the amounts collected to date in comparison with projected revenues. If you look at the first half, you can see that we have collected a total of 52.81% of the budgeted revenues, compared with 51.43% expected. This is approximately 1.4% more than projected, compared to the .5% difference in January. In January, I had some ESSER funds that had not yet been claimed and I was behind on claiming some of the foodservice revenues. Now that those are updated to actuals, that results in higher actual revenues compared to projected. This accounts for the majority of the difference regarding the increase to fund balance in comparison to January.
The General Fund Expenditure Dashboard Summary (page 4) shows a summary of year-to-date expenditures in comparison with projected expenditures. If you look at the second donut (red) you can see that through March we have spent only 55.9% of the budgeted expenditures. This is in comparison with projected expenditures based on budget and history of 57.08%. This is consistent with prior months. The gap between actual salaries and benefits and projected salaries and benefits has increased slightly from .47% in January to .70% in March. I expect this gap to decrease in the future considering the number of paras we have hired in recent months.
Budget status reports for all funds for February and March are included (pages 6-15).
Enrollment
The enrollment spreadsheets are attached (pages 16-17), with summaries by headcount for September through April and a comparison of budgeted FTE to actual average FTE. Enrollment decreased by just 11 students and 11.15 FTE, making the April count 33.81 students below budget. The average FTE is 14.46 students below budget. Districtwide between March 2 and April 1, we had 6 students enter that are new, 5 students returned to the district, 7 status changes (change in FTE), 21 students withdrew (4 to Homeschool) and 16 students transferred within the district. Seeing these numbers (decreases overall) it does not look like the mask mandate has had a positive effect on enrollment. I had hoped to see an increase (or at least some stability) in the enrollment in the last few months of the year, but it looks like that is not happening. On a positive note, the special education enrollment continues to increase each month.
Please let me know if you have any questions.