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

Budget Case Problem

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

Your school will be allocated anadditional:

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 is20:1

The school will also receive:

A.  $ 4 per student for administrative supplies

B.  $16 per student for classroom supplies for regularteacher

C.  $ 5 per student for custodial supplies

D.  $ 300 per classroom teacher (ALL teachersexcept 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 presentationsfor 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 basedon the increased enrollment. Use State of FloridaFunction andObjectcodes (Redbookcodes), and group the budgeted items by commonfunction.

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

  FUNCTION  OBJECT    DESCRIPTION     EMP.CT.  SALARY  NON-SALARY

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

  Variable Benefits  FixedBenefits

  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 foreach of the personnel items?  – (4 points, ½ point foreach incorrect Function or Object code).

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

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

4. What are the total variable andfixed employee benefit costs? (1 point, ½ pointeach)