Question

This assignment is the same for both Florida & non Florida students. This problem requires the student to develop a simple budget. At the end of the course, the student will receive a STAR for completing this assignment. This assignment must be completed in either MS Excel or in with a MS Word table*

Budget Case Problem

Meadow Lake Elementary will receive 600 additional students next fiscal year. This increase in student enrollment will raise the school over the number needed for several additional staff. You are only concerned with the budget for the additional students.

Your school will be allocated an additional:

Description    Salary Costs

Assistant Principal $ 53,000

Guidance Counselor $ 48,000

4 six-hour Teacher Aides $  9,600 each

Regular Classroom Teachers $ 48,000 each

One ESE Classroom Teacher $ 48,000 each

One Speech/Language Teacher  $ 48,000 each

One ESOL Teacher $ 48,000 each

One Custodian     $ 20,000

Secretary Clerk    $ 14,000

Data Processor,   $ 16,000

The regular education student-teacher formula is 20:1

The school will also receive:

A.  $ 4 per student for administrative supplies

B.  $16 per student for classroom supplies for regular teacher

C.  $ 5 per student for custodial supplies

D.  $ 300 per classroom teacher (ALL teachers except speech/language) for textbooks

E.  $ 200 per ESE teacher for ESE supplies

F.  $ 200 per ESOL Teacher for ESOL supplies

G.  A computer package for making class presentations for each regular, ESE, and ESOL teacher (not Speech) (package includes laptop computer with LCD projector) - cost per package is $3,500 per teacher.

H.  Substitute budget for $ 5,000

Outline and total the school's additional budget resources based on the increased enrollment. Use State of Florida Function and Objectcodes (Redbook codes), and group the budgeted items by common function.

Use the following headers: (an Excel spreadsheet is available to assist with this assignment)

  FUNCTION  OBJECT     DESCRIPTION     EMP. CT.  SALARY  NON-SALARY

Using the following employee benefit costs, determine the TOTAL employee costs for the enrollment increase (Salary + Benefits)

  Variable Benefits  Fixed Benefits

  Retirement   10.40%     Health $ 7,500

  FICA     7.65%   Life $   125

  Work Comp    1.50%

  Total   19.55%      $ 7,625

1. What are the Function & Object codes for each of the personnel items?  – (4 points, ½ point for each incorrect Function or Object code).

2. What are the Employee Counts for each Function group? (2 points, ½ point for each incorrect employee count)

3. What are the total non-Salary Costs, by Function and Object, for the non-salary items for these additional 600 students? (3 points, ½ points for each incorrect Function, Object, or total cost)

4. What are the total variable and fixed employee benefit costs? (1 point, ½ point each)

Answer 1

Students - 600
Ratio of students per teacher - 20:1
No. of Regular Classroom Teachers required (600/20)	30

Total teacher count
Regular Classroom teacher	30
ESE Classroom teacher	1
Language Teacher	1
ESOL Teacher	1
Total Teachers	33

Salary cost for teachers (A)
Regular Classroom Teachers $ 48,000 each for 30 teachers	1,440,000
One ESE Classroom Teacher $ 48,000 each	48,000
One Speech/Language Teacher  $ 48,000 each	48,000
One ESOL Teacher $ 48,000 each	48,000
	1,584,000
Variable Cost (B)
Retirement   (10.40% of 1,584,000)	164,736
FICA     (7.65% of 1,584,000)	121,176
Work Comp    (1.50% of 1,584,000)	23,760
	309,672
Fixed Benefits (C )
Health $ 7,500 each for 33 teachers	247,500
Life $ 125 each for 33 teachers	4,125
	251,625
Total Cost (A+B+C)	2,145,297

Other Expenses	Per Student	600 Student
$ 4 per student for administrative supplies	4	2,400
B.  $16 per student for classroom supplies for regular teacher	16	9,600
C.  $ 5 per student for custodial supplies	5	3,000
D.  $ 300 per classroom teacher (ALL teachers except speech/language) for textbooks	300	9,600
E.  $ 200 per ESE teacher for ESE supplies	200	200
F.  $ 200 per ESOL Teacher for ESOL supplies	200	200
G.  A computer package for making class presentations for each regular, ESE, and ESOL teacher (not Speech) (package includes laptop computer with LCD projector) - cost per package is $3,500 per teacher.	3,500	112,000
H.  Substitute budget for $ 5,000	5,000	5,000
Total other expenses		142,000

Particulars	Per Student	600 Student
Assistant Principal $ 53,000	53,000	53,000
Guidance Counselor $ 48,000	48,000	48,000
4 six-hour Teacher Aides $  9,600 each	9,600	38,400
One Custodian     $ 20,000	20,000	20,000
Secretary Clerk    $ 14,000	14,000	14,000
Data Processor,   $ 16,000	16,000	16,000
Total other staff expenses	160,600	189,400