This case problem requires you to create a school budget using a district allocation formula and table of employee costs.<\/p>\n
You will use the enrollment from the\u00a0Happy Trails (Florida) FTE Case problem. Using the enrollment, you will develop the school\u2019s operating budget, providing the Function & Object for each of the items listed in the budget.<\/p>\n
Below is a link to a staff & non-salary Allocation Formula from a major school district. Using this document, you will identify the number and types of personnel that will be assigned to the school based on the school\u2019s enrollment.\u00a0\u00a0The non-salary allocations are located on the 4th\u00a0page of the link below.\u00a0You will need to copy\/paste the link to open the Allocation formula.<\/p>\n
https:\/\/www.palmbeachschools.org\/UserFiles\/Servers\/Server_270532\/File\/Budget-Resources&Tools\/AllocationFormula\/4.061FY20PersonnelAllocationFormulas.pdf\u00a0(Links to an external site.)<\/p>\n
In addition to the resources provided in the Allocation Formula, your school will also be assigned the following Special Program allocations.<\/p>\n
ESE Allocation:<\/p>\n
3 ESE teachers to provide Academic Support\/Remediation<\/p>\n
1 Speech\/Language Therapist (teacher) to provide SL Therapy<\/p>\n
5 ESE PK teachers for the PK programs<\/p>\n
3 ESE 6-hr Paraprofessionals (Aides)<\/p>\n
$200 per ESE\/SL teacher for classroom supplies<\/p>\n
ELL Allocation:<\/p>\n
3 ELL Teachers<\/p>\n
$150 per ELL teacher for classroom supplies<\/p>\n
Custodial Allocation:<\/p>\n
1 Custodian Foreperson<\/p>\n
4 Custodians<\/p>\n
(Supplies based on non salary formula in standard allocation formula)<\/p>\n
The employee costs are derived from the \u201cTrade-Off Values\u201d table provided from the link below: (You will need to copy\/paste the link into your browser to open the link)<\/p>\n
https:\/\/www.palmbeachschools.org\/UserFiles\/Servers\/Server_270532\/File\/Budget-Resources&Tools\/TradeOffValues\/FY2021TradeOffValues.pdf\u00a0(Links to an external site.)<\/p>\n
The assignment will be completed on a spreadsheet provided by the instructor. On the spreadsheet, the student will list each of the items in the budget, including the Function, Object, Description, Employee Count (if it is a personnel item), and Average Salary.\u00a0\u00a0For non-Salary items (i.e. supplies), Employee Count and Average Salary columns will be blank and the total Non-Salary costs are posted in the column to the right of the yellow items (green).<\/p>\n
The yellow columns\/cells are formulas. Do\u00a0NOT\u00a0type in these cells. Once you enter information in the Employee Count and Average Salary columns, the benefit amounts will calculate automatically<\/p>\n
Employee Benefit costs are calculated from the DARK blue cells that must be updated from the \u201cTrade Off Values\u201d table.\u00a0\u00a0You enter the % as follows: 9% – .09.<\/p>\n
Function & Object codes come from the Financial and Program Cost Accounting and Reporting for Florida Schools manual. This document is also known as the \u201cRedbook\u201d. Chapter 4 provides a description of the Object and Function classifications. The link below (copy & paste) to this document:<\/p>\n
\u00a0http:\/\/www.fldoe.org\/finance\/fl-edu-finance-program-fefp\/financial-program-cost-accounting-repo.stml\u00a0(Links to an external site.)<\/p>\n
It is suggested that you list Descriptions using a main code word (i.e. Teacher) and then a descriptor (i.e. Teacher \u2013 K, Teacher \u2013 ESE, Teacher \u2013 ESE PK, Supplies \u2013 Classroom, Supplies \u2013 Custodial)<\/p>\n
You can only list items provided in the Allocation formula and the additional items listed above.<\/p>\n
There are two sample items included on the spreadsheet. You can type over the information in these rows for your first two items.<\/p>\n
Grading:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0This assignment will be grade based on the following:<\/p>\n
Each item in the budget based on the formula MUST be included (-.5 for any item missing)<\/p>\n
Function & Object classifications for each item (-.5 for any incorrect classifications)<\/p>\n
What are the\u00a0Function & Object codes\u00a0for each of the personnel items?\u00a0\u00a0\u2013 (6 points, \u00bd point for each incorrect Function or Object code).<\/p>\n
What are the\u00a0Employee Counts\u00a0for each\u00a0Function\u00a0group? (1 points, \u00bd point for each incorrect employee count)<\/p>\n
What are the total\u00a0non-Salary Costs,\u00a0by Function and Object,\u00a0for the non-salary items (2 points, \u00bd points for each incorrect Function, Object, or total cost).<\/p>\n
What are the total\u00a0variable\u00a0and\u00a0fixed\u00a0employee benefit costs? (1 point, \u00bd point each)<\/p>\n","protected":false},"excerpt":{"rendered":"
This case problem requires you to create a school budget using a district allocation formula and table of employee costs. You will use the enrollment from the\u00a0Happy Trails (Florida) FTE Case problem. Using the enrollment, you will develop the school\u2019s operating budget, providing the Function & Object for each of the items listed in the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-98109","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/98109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=98109"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/98109\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=98109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=98109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=98109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}