In response to 2020 HB641 the Charter Support Unit has created this calculator to assist schools with calculating the teacher salary increase amounts and to complete the state’s preliminary expenditure report template.
We strongly encourage before you complete begin working on this calculator that you read the information that has been made available by the state of Florida. The Department of Education has a page on its website dedicated to this topic at: http://www.fldoe.org/teaching/recognition/teacher-salary.stml
The attached Excel document includes instructions on how to use the calculator on the “Directions” tab. Please review that tab and then follow the directions as appropriate. The calculator will also automatically complete the state’s “Charter School Preliminary Expenditure Report Template” which was distributed on September 11. If you have any questions please feel free to reach out to the Charter Support Unit.
This document is available as either an Excel version, or in Google Docs.
I actually recommend using this as a Google Document and then sharing it with your key office staff who assist with the inventory. This will allow multiple people to access and update the file without needing to worry about sending a copy of the spreadsheet back and forth. The spreadsheet displayed above is an embedded version of the Google Doc. If you would like your own version of this spreadsheet, use this link (click here), and sign into your Google Account. Then click on “File” and then “Make a Copy” This will copy the spreadsheet into your own Google Docs/Drive folder, allowing you to manage your own inventory online.
This document provides a sample estimate that could be given to a party who makes a public records request to the school that will take time to comply with. Pursuant to Florida Statute 119.07 the school is able to pass costs on to the requestor. However, we highly recommend the school has a policy in place with regards to assessing these fees prior to charging these types of fees.
The Charter Support Unit has developed a budget template tool to assist schools in developing a comprehensive budget. The budget has been developed as a “Question and Answer” tool where individuals put together a budget. It is designed so that Board members who may not have an extensive knowledge of the Florida Red Book can develop a budget that is in compliance with the requirements.
There are numerous other additional resources available for schools who wish to use the Template Tool. Here are some additional resources which may be helpful:
This purchase order form can be used if a vendor requires a purchase order to ensure a purchase has been approved. Purchase Orders can also be used to accrue funds before they are spent.