As we close out May activity it becomes much easier to hit the target for what June 30 (year-end) may look like with the many changes/variations to the budget/plan approved at the beginning of the fiscal year. There is much less room for large unexpected variances with only 30 days remaining in the fiscal year.

With this months review of the current month’s activity (May) showing a YTD surplus of $285K in combination with the previous months in this fiscal year there was an overall improvement to my projections to what Jun 30 may look like. I’m currently expecting a year end surplus of $168K, however there are some area’s that could affect this number that have a small level of unpredictability. From my perspective this $168K surplus at year end is a conservative estimate, possible to improve – HOWEVER, I have previously recorded $301K of Revenue from the Foundation. We had discussed at the close of June’s activity the desire may be to reduce this amount of revenue to lessen the impact to the Foundation, but still allow the School to end the year positively. I’ll take direction from you all on that and what your expectation of the year end surplus is in conjunction with the Foundation’s Transfers on record.

In other new, I had a meeting with Dr. O’prey and Dr. Miller with Drew and Kim present as well to go over the remaining ESSER III funds available on Tues this week. In preparation for that meeting I gathered $51K of eligible ESSER expenses for submission to the district for reimbursement. As we’ve discussed in the past a large portion of the ESSER plans are for Software which is renewed annually typically starting in late Spring carrying over into early Fall, this is where a large portion of the $51K was categorized. The Tutoring program and reimbursement of 1 teacher and 1 custodian makes up a large majority of the remaining eligible expenses per the approved plan. I’ll continue to monitor this through September 2024 when the final expenses are to be made for this program. 

The audit engagement letter has been signed and returned to the firm, they will reach out at any point I’m sure to start gathering information and/or have preliminary conversations with administrators at the school.

Budget conversations have remained very active, we met Tues also for this purpose. A few more changes were discussed/requested, which Desi and I have worked through, I’ll be sending that updated document out also in the next few hours.

Let me know if you guys need anything. I’ll be talking with you all on the call Monday.

The goal is to secure a less than $260,000 dependency on the Foundation for operating costs. 

During the 2022-2023 year the dependency on the Foundation Was: $360,000

Tom/Tricia Notes

Updated Salary Scales (Click here)

Finance and HR Director

Front Office Team

Principals

In addition to the list below, see screenshot and attached estimate.

This list needs prioritizing to be placed in the budget, or aligned to an ESSR fund/grant opportunity. 

• Along with Kim's requests below are my proposals for tech refresh.  These are based on observations made the past year. 

 

• Increase in contract hours from 40 to 60 for the month.  There are backend maintenance requirements that have gone neglected, while the team supports onsite support requests for both schools.  The additional hours will be used to maintain the system as well as respond to requests made during the week while not onsite.

 

• Internet outages seemed to cause the most chaos for both schools.  This is due to a single point of failure at the highschool with both the internet and server.  We suggest each school be independent, both with ISP and hardware to support it.  
• High Level Plan:

1. Both Schools get separate ISP fiber connections, but keep MPLS for failover
2. Move to an SD-WAN Architecture with new Meraki hardware.  This hardware will allow communication between both sites and allow for internet fail-over when one location is down.  Currently when the highschool goes down so does the middle school.  Not sure what this costs in productivity, but we want to minimize the risk especially during testing.  
3. Install new servers to support network operations, and add capability to create and deploy labs for CTE programs, etc.

• SD-WAN Hardware/Software Requirements Estimate: (Note this is just an estimate, but should be cheaper once negotiated with vendor)
  • 2 Meraki SD_WAN Firewalls + licensing = $13550
  • 2 Meraki 48Port POE Switches + licensing = $14600
  • 8 Meraki Wifi Radios + licensing = $7500
  • 2 Dell Poweredge Servers + licensing = $15000
    • Estimate Total = $50,000

As always if you have questions please call me or setup a time on my calendar at https://calendly.com/yourtechourbusiness