Wed May 26 2021, 6:15pm
Woodland High School Library and Zoom
Regular Meeting

REPORTS TO THE BOARD

Financial/Enrollment Report

To: Michael Green, Superintendent

From: Stacy Brown, Director of Business Services

Date: May 20, 2021

RE: Financial/Enrollment Report

I have the month of April reconciled.  The first set of reports include YTD expenditures and revenues through 4/30/21 and projected revenues, expenditures, and fund balance through the end of the year.  The second set of reports are the Budget Status reports for all funds for April.  These reports are required to be documented and shared with the board.

The Month-End Balances (year over year trend) is the monthly actual ending fund balance for each month for 19-20, 18-19, 17-18. Also, it includes the 20-21 actual fund balance through April and the projected ending fund balance through the end of the fiscal year.  The beginning fund balance for this year was $3,953,697, and the projected fund balance is $4,274,342.  In March, the fund balance was projected to decrease by $260,000 for the 20-21 fiscal year.  However, in April, you can see that it is projected to increase by $320,000.  This is solely due to the Transportation Stabilization funds that the district will receive as a result of the 2021 Legislative session.  The district will receive $1,121,000 in May and July, over and above the calculated transportation allocation.  Before receiving this news, the projected KWRL unfunded was $1,361,000.  The adjusted unfunded is projected at $433,000.  We received additional transportation funds, but we also will receive approximately $592,000 less from the KWRL districts.  This is why the fund balance is not increasing by over $1,000,000. 

The General Fund Financial Summary compares the prior year-to-date revenue and expenditures as a percentage of actual year-to-date totals. This summary also compares the current year-to-date revenues and expenditures as a percentage of the budget.  Last year, as of April, we had collected 65.24% of our year-to-date revenues. This year we have only collected 61.5% of our revenues in comparison to budget.  Transportation decreases account for the majority of this difference (this will jump considerably once we receive the $895,000 in Transportation Stabilization in May).  Expenditures last April accounted for 68.15% of our annual year-to-date expenditures.  The current year's expenditures through April are only 60.04% of the budget.  Now that we are back to school face-to-face, I expect this difference to lessen somewhat in the next few months as we are paying out the final 2 days of district-directed certificated days in May. We are using much more certificated and classified subs, we have hired some new positions (filled vacant para and custodial jobs, sanitizing and disinfection hours, buildings needing considerably more supplies and other items).

The General Fund Financial Forecast by Source/Object report includes prior year revenues and expenditures through April, current year through April, projected totals for an annual total, and comparison to budget.  This details the projected revenues and expenditures and how the projected ending fund balance is calculated. I have highlighted the projected surplus of $446,351.

The General Fund Revenues Dashboard Summary shows a summary of revenues and the amounts collected to date in comparison with projected revenues.  We have collected a total of 61.21% of the budgeted revenues, compared with 63.70% expected.  If you look at the graph, you can see we have collected more than the previous year in Local, Federal, and Other.  We are collecting more property taxes, and we received over $300,000 in State Forest funds (which are not budgeted but very welcome when we receive them), and the ESSER funds have increased our Federal funds.  We have collected less in-state funds due to decreased Apportionment and Transportation allocation. 

The General Fund Expenditure Dashboard Summary shows a summary of year-to-date expenditures in comparison with projected expenditures.  Through April, we have spent only 59.81% of the budgeted expenditures.  This is in comparison with projected expenditures based on budget and history of 66.89%.  Looking at the comparison graph by the object of this year’s expenditures in comparison to other years you can see that Classified Salaries are way down in comparison with other years.  As the year has progressed, we have caught up or are catching up in almost all other objects. 

The Budget Status reports are included and are printed directly from the financial system.  These reports are required to be presented to the board each month.  This is the only monthly financial information that is provided on the other funds.  The previous slides all refer to the General Fund (Operating Fund).  We will discuss each of the other funds in more detail when I present them to the board in June.  There is nothing out of the ordinary in any of the other funds in April. 

Enrollment

The enrollment slides include summaries by headcount for September through May and a comparison of budgeted FTE to actual average FTE.  Enrollment decreased by 12 students and 19.42 FTE (9 of these were students that graduated from TEAM), making the May count 98 students below budget.  The average FTE is 70.37 students below budget. 

Districtwide, between April 2 and May 1, we had 14 new students enroll, 8 students return, 5 status changes (change in FTE), 25 students withdraw, 9 students graduate, and 10 students transfer within the district.  Jody has also updated the Special Ed counts to average, and we are only 5.88 students below budget through May.  Special Education numbers continue to increase each month.  

Please let me know if you have any questions. 



Attached Files:
Woodland SD – April 2021 Financial Report.pdf application/pdf 694K
Woodland SD – April 2021 Financial Report.pptx application/vnd.openxmlformats-officedocument.presentationml.presentation 985K