Ask Financial Accounting Expert

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.

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M92084112
  • Price:- $45

Priced at Now at $45, Verified Solution

It solves a very complicated case study on state funding of public schools in United States, using the FTE value method.

Have any Question?


Related Questions in Financial Accounting

Case study - the athletes storerequiredonce you have read

Case Study - The Athletes Store Required: Once you have read through the assignment complete the following tasks in order and produce the following reports Part 1 i. Enter the business information including name, address ...

Scenario assume that a manufacturing company usually pays a

Scenario: Assume that a manufacturing company usually pays a waste company (by the pound to haul away manufacturing waste. Recently, a landfill gas company offered to buy a small portion of the waste for cash, saving the ...

Lease classification considering firm guidance issues

Lease Classification, Considering Firm Guidance (Issues Memo) Facts: Tech Startup Inc. ("Lessee") is entering into a contract with Developer Inc. ("Landlord") to rent Landlord's newly constructed office building located ...

A review of the ledger of oriole company at december 31

A review of the ledger of Oriole Company at December 31, 2017, produces these data pertaining to the preparation of annual adjusting entries. 1. Prepaid Insurance $19,404. The company has separate insurance policies on i ...

Chelsea is expected to pay an annual dividend of 126 a

Chelsea is expected to pay an annual dividend of $1.26 a share next year. The market price of the stock is $24.09 and the growth 2.6 percent. What is the cost of equity?

Sweet treats common stock is currently priced at 3672 a

Sweet treats common stock is currently priced at $36.72 a share. The company just paid $2.18 per share as its annual dividend. The dividends have been increasing by 2,2 percent annually and are expected to continue doing ...

Highway express has paid annual dividends of 132 133 138

Highway Express has paid annual dividends of $1.32, $1.33, $1.38, $1.40, and $1.42 over the past five years, respectively. What is the average divided growth rate?

An investment offers 6800 per year with the first payment

An investment offers $6,800 per year, with the first payment occurring one year from now. The required return is 7 percent. a. What would the value be today if the payments occurred for 20 years?  b. What would the value ...

Oil services corp reports the following eps data in its

Oil Services Corp. reports the following EPS data in its 2017 annual report (in million except per share data). Net income $1,827 Earnings per share: Basic $1.56 Diluted $1.54 Weighted average shares outstanding: Basic 1 ...

At the start of 2013 shasta corporation has 15000

At the start of 2013, Shasta Corporation has 15,000 outstanding shares of preferred stock, each with a $60 par value and a cumulative 7% annual dividend. The company also has 28,000 shares of common stock outstanding wit ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As