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

  Calculate break even point

Calculate Break-even point. - Compute the variable cost per unit and the fixed cost per month for the semi-variable expense based on the information provided using the high-low method.

  Line of credit has been established at the bank

Lewis is a merchandising company. Each month they buy the inventory that they expect to sell the next month. Then they pay for it 50% in the month of purchase and 50% the next month. The purchase price is $50. Prepare a cash budget for the first quar..

  Complete the research evaluation tablesand post

write aone-to-two-page introductionto the article. Include the following sections and include no opinions, judgments, or beliefs about the study. Only present the facts.

  Determine stantons net income for first year of operation

The balance sheet at the end of the first year reported $40,000 in dividends payable and $580,000 in ending retained earnings.-Determine Stanton's net income for its first year of operations.

  Prepare income statement using contribution margin approach

AJ Manufacturing Company incurred $56,000 of fixed product cost and $44,800 of variable product cost during its first year of operation. Also during its first year, AJ incurred $17,800 of fixed selling and administrative costs and $14,200 of variable..

  Question the december 31 2012 condensed balance sheets of

question the december 31 2012 condensed balance sheets of pym corp. and its 90 percent-owned subsidiary sy corp. are

  Determine gingers gift tax liability for 2015

Determine Ginger's gift tax liability for 2015 if she and Greg elect gift splitting and Greg gave their son Stevie stock valued at $80,000 during 2015.

  How much of engcos export gross profit

How would your answer modify if Engco sold its goods with title passing at the customer's location?

  United manufacturing planning

United manufacturing planning on spending up to $4000000 on new automated assembly machinery

  New sprinkler system economically attractive

RealTurf is considering purchasing an automatic sprinkler system for its sod farm by borrowing the entire $45,000 purchase price. The loan would be repaid with four equal annual payments at an interest rate of 12%/year. Show the internal rate of retu..

  What is the number of orders the company expects to receive

Tee Times, Inc. produces and sells the finest quality golf clubs in all of Moore County. The company has priced its Pinehurst No. 2 Series golf clubs at $600 per set. Normally, an order consists of one set of clubs. What is the number of orders the c..

  Evaluate operating income for 20x7

Evaluate operating income for 20X7, assuming the firm uses the variable-costing approach to product costing. (Do not prepare a statement.)

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