Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

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

Assignment -part a -background saturn petcare australia and

Assignment - Part A - Background: Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since openin ...

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 ...

Comprehensive problem - lou barlow a divisional manager for

Comprehensive Problem - Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division's ...

Consider the following account starting balances and

Consider the following account starting balances and transactions involving these accounts. Use T-accounts to record the starting balances and the offsetting entries for the transactions. The starting balance of Cash is ...

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 ...

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?

Exercise 1 copying formatting and calculating sums and

EXERCISE 1: COPYING, FORMATTING, AND CALCULATING SUMS AND AVERAGES Let's assume that Groth Donut Company has three stores, only one of which is shown at the top of the sheet titled "p = r-­-e". The revenue and expenses f ...

Budgets and managerial responsibilitythis module explores

Budgets and Managerial Responsibility This module explores budgets and the benefits of creating budgets. In recent years, many organizations faced one of the hardest economic conditions with the recession. Many organizat ...

Assessment task 1question no 1assessment taskbilby cos

Assessment Task 1 Question no. 1 Assessment Task: Bilby Co's income statement for the year ended 31 December 2015 and statements of financial position at 31 December 2014 and 31 December 2015 were as follows: Bilby co's ...

Asset retirement obligation changes in estimate versus

Asset Retirement Obligation, Changes in Estimate versus Errors, Writing an Issues Memo Facts: Mega¬Corp's corporate headquarters, built in 1970, has asbestos in its insulation. The Company's financial statements reflect ...

  • 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