How much revenue is raised through the fte calculations

Assignment Help Financial Accounting
Reference no: EM131329526

Assignment: Non Florida FTE Case Problem

In the State of XXX, funding of public education is handled through a Foundation program. The state funds a student at a weighted FTE value of $3,150. Based on a local school district's ability to raise property tax revenues through the "Fair Effort", the state provides the difference between the District's ability to raise funds and the state value of the students.

Students are counted two times throughout the school year, once in the fall (October) and once in the winter (February). Each student is funded for half their value in each count. This results in full funding for the student if included in both counts. If the student is counted in October and not in February, the local district is funded for half the value of the student.

In the State of XXX, students are funded in one or more programs, as set by the State Legislature. The Legislature annually sets the Program weights. Students can be funded in more than one program, although the total fractions for each of a student's program cannot exceed 1.0.

For students in special programs, the State of XXX funds students in the following categories:

  Program

 Pgm. Weight

Segments Each Segment = .2 FTE

 Comments

201 - Therapy Services - Speech/Language, OT, PT,*

3.75

1

Per program - SL, OT, PT

The remaining part of the week (4/5th) is funded at the base level

202 - ESE  -: Mildly Disabled (Learning Disabled, Other Health Impaired, Physical Impaired, Educable Mentally Handicapped)*

2.10

2

The remaining part of the week (3/5th) is funded at the base level

203 - ESE - Moderately Disabled (Trainable Mentally Handicapped)

1.75

5

The student is funded totally at the program weight. The state caps the % age of disabled students in this category at 8% of the special education population

204 - Profoundly Disabled - (autistic, PMH)

4.60

5

The student is funded totally at the program weight. The state caps the % age of disabled students in this category at 2% of the special education population.

205 - Gifted

1.25

1

The remaining part of the week (4/5th) is funded at the base level

150 - English Language Learner (ELL) **

1.30

4

The remaining part of the week (1/5th) is funded at the base level

* If the student is classified in more than one of these categories, both are counted. For example, if the student is both LD & requires SL services, the student would be .2 in 201 - SL, .4 in 202 - Mildly Disabled, and .4 in the basic program (see below). This insures some funding for the special programs.

** If the student is classified as ELL and receives services in either Pgm 201 or 202, the special education programs replace the segments in ELL. For example, for an ELL student who also has a Learning Disability, the student would be funded as .4 in 202 - Mildly Disabled, .4 in 150 - ELL, and .2 in the basic program.

The intent of the program weights is to provide additional funding from state sources to account for the excess cost of providing instructional programs for these students.

In addition to the special program weights, the following basic student programs/weights are applied to all students. Please note that a student cannot exceed 1.0 in total program categories. For example, a student receiving SL Therapy would be .2 in program 201 and the remainder of the funding (.8) in the base program (i.e. kindergarten - see below).

Program

Weight

100 - Kindergarten

1.10

101 - Grades 1 - 3

1.06

102 - Grades 4 - 8

1.00

103 - Grades 9 - 12

1.09

The state funds the difference between the "Fair Effort" and the value of the students from FTE. The State funds the cost of all Categorical Allocations at outlined below:

Categoricals

Formula

Amount

Administrative - Principal

1 per school

$80,000

Administrative - Assistant Principal

1 = enroll < 1000

2 = enroll 1,000 - 1,500

3 = enroll 1,500 - 2,000

$65,000

Instructional Support - Guidance

1 = enroll < 1000

2 = enroll 1,000 - 1,500

3 = enroll 1,500 - 2,000

$50,000

Administrative - Clerical (data processor, secretary, bookkeeper)

3 = enroll < 1000

4 = enroll 1,000 - 2,000

$20,000 each

Instructional/Administrative  School level materials

$50 per student


Textbooks

$150 per student, annually


Transportation

$400 per student,

Funds only eligible students

At-risk (funding to hire additional teachers for students at risk of dropping out)

$250 per student


Staff Development

$25 per student


Diagnostic Services (i.e. Psychologists)

$50 per student


Administrative Personnel

$315 per student


Based on the formula provided above, how much total funding, by category, would be generated for the following school scenario:

Calculating the FTE Value of the Students in a Typical Elementary School

Happy Trails Elementary School recently opened in your school district to serve students in grades Kindergarten through fifth. The students attend from 8:00 a.m. to 2:00 p.m. Each student receives a daily 30 minute lunch period, as well as 30 minutes per week of music, media, P.E., computer, and art. The school's enrollment is as follows:

Grade    Enrollment
K                145
1                140
2                155
3                163
4                166
5                158
Total           927

The school draws some of its population from a section of the county in which many of the residents do not use English as their primary language at home. To accommodate the diverse needs of the children from this population, ALL the regular education teachers at Happy Trails have completed the required in-service training to be able to provide English Language Learners (ELL) support. The school has two teachers hired to provide intensive ELL instruction. The ELL population is as follows:

Grade   ELL Students
K                12
1                10
2                12
3                13
4                15
5                14
Total           76

* ELL is often called Limited English Proficient (LEP) or English Speakers of (Other) Languages (ESL/ESOL). These terms are used interchangeably within the professional literature.

The school has a K-5 ESE population of 103 students. Many of these students are mildly disabled (Learning Disabled) or Speech/Language Impaired and are served in the regular classroom, with some " pullout" for direct instruction. Thirteen (13) of the students are Moderately Disabled and are enrolled in a self-contained special education program for all of their academic services. They do attend the regular PE, Art, Music, and computers with regular education students. The 55 Speech/Language students are seen by the SLP for an average of 60 minutes per week. None of the ESE students are ELL students, therefore the total ESE count is 103 and the LEP count is 76.

Grade  ESE Students      Type of Students  # Students    Kg  1  2  3  4  5
K      15 Speech/Language           55   12  12  7  8  9  7
1      18 Learning Disabled    35   2  4  5  8  8   8
2      14 TMH    13   1  2  2  3  3  2
3      19                       Total   103
4  20
5      17
Total      103   

In this school district, 75% of the students are eligible for transportation

In this school district, the "Fair Effort" property tax level raises $1,850 per student.

The student will produce a document that identifies

1. How much revenue is raised through the FTE calculations?

2. How much revenue is expected for the categorical allocations?

3. How much revenue is generated through the "Fair Effort" for the students at Happy Trails Elementary?

4. How much funding will the District receive from the State for the students at Happy Trails Elementary?

The student's submission will include charts/tables that identify the amount of revenue by program. The student should complete the document using Excel or use Tables in Word.

Reference no: EM131329526

Questions Cloud

Write rate law for disappearance of ch4 in this oxidation : First, write the rate law for the disappearance of CH4 in this oxidation.Then use this to obtain a differential equation for the rate of appearance of OH. Don't worry about solving the equation or isolating all the dependence on [OH].
What does the irr rule advise regarding payment? arrangement : Professor Wendy Smith has been offered the following? opportunity: A law firm would like to retain her for an upfront payment of $49,000. In ?return, for the next year the firm would have access to eight hours of her time every month. Smith's rate is..
What contributions did this individual make in the creation : Write a 2 page essay answering the following questions: What contributions did this individual make in the creation of our government? Why were these contributions so significant
Assumptions required to make dividend discount model : Discuss/explain the assumptions required to make the dividend discount model (DDM) easier to estimate the value of a company’s stock. Hint: You may want to discuss the main assumptions behind then general version of the DDM.
How much revenue is raised through the fte calculations : How much revenue is raised through the FTE calculations? How much revenue is expected for the categorical allocations? How much revenue is generated through the "Fair Effort" for the students at Happy Trails Elementary?
What are cultural hegemonic forces in spanish colonization : "Historians explain colonial control of Latin America as hegemony, a kind of domination that implies a measure of consent by those at the bottom" (57). What are two cultural hegemonic forces in Spanish colonization
Value preferred stock with a stated maturity : Explain how using the dividend discount model (DDM) to value a preferred stock with a stated maturity differs from valuing a preferred stock with no maturity, and discuss how the price of a share of preferred stock is calculated in both cases.
Estimate rate constants for formation of the four products : If the half-life of ethenyl cyclopropene overall is 1570 s, estimate the rate constants k1 , k2 , k3 , and k4 for formation of the four products.
Describe how dividend discount model values share of stock : What is meant by gearing. How does gearing affect the financial risk of a firm? How many visitors (people who are not local residents) attended the All-Star game? Describe how the dividend discount model (DDM) values a share of stock.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd