Preschool Teacher Template by buj14803

VIEWS: 604 PAGES: 8

Preschool Teacher Template document sample

More Info
									READ ME…

This Excel file consists of 3 tabs -
(1) The tab 'State PS Begin Salary' is an hypothetical example of a State Preschool budget using Step 1
of Public School Teacher Salary Schedule (i.e., Beginning K-12 teacher salary).
 (2) The tab 'State PS Avg Salary' is an hypothetical example of a State Preschool budget using Step 5 of
the Public School Teacher Salary Schedule (equivalent to the average K-12 teacher salary).
 (3) The tab ' budget template' is a budget tool for users to estimate the cost of a preschool progarm,
before and after it has been upgraded to meet quality standards. The template has step-by-step
instructions on the right side of the sheet to help users navigate this tool.
                                                        State Preschool Program Budget
                                                    Parity with Low-End K-12 Teacher Salary
                                                               2007-08
                                             Estimated Cost of Changing One State Preschool Program
                                                            to Meet Quality Standards
                                                                           "Before" Budget                                           "After" Budget
    Number of days of service per year                                           175                                                       175
    Number of sessions per day                                                     2                                                         2
    Number of preschool hours per day                                              3                                                         3
    Number of preschool hours per year                                           525                                                       525
    Number of children (total)                                                    96                                                       120
    Number of classes                                                              4                                                         6
    Number of classrooms                                                           2                                                         3
    Number of FTE instructional staff                                              6                                                         7
    Class size                                                                    24                                                        20
    Annual cost                                                                 $4,321                                                   $5,348
                                                            Annual Expense as                         Annual Expense After Preschool Meet Quality
                                                              State Preschool                                         Standards
                Budget Item
                                                            (3 hours, 175 days,                                   (3 hours, 175 days,
                                                            2 sessions per day)                                  2 sessions per day)

                                                FTE        Salary/per FTE         Total Salaries       FTE     Salary/per FTE                 Salaries
    Director                                    0.15       $      103,871    $           15,581        0.15    $      103,871    $             15,581
    Site Supervisor (also a Master Teacher)      1         $       36,392    $           36,392         1      $       47,150    $             47,150
    Lead/Master Teacher                          1         $       30,327    $           30,327         2      $       39,292    $             78,584
    Teacher                                      0                           $              -           3      $       31,434    $             94,302
    Teacher Aide                                 4         $        19,624   $           78,496         0                        $                 -
    Floater                                      0                           $              -           1      $       31,434    $             31,434
    Accountant/Bookkeeper                       0.15       $        57,720   $            8,658        0.15    $       57,720    $              8,658
    Education Specialist*                       0.15       $        68,043   $           10,206        0.15    $       68,043    $             10,206
                                                0.15
    Enrollment Specialist/Family Resource Coordinator      $        38,137   $            5,721        0.15    $       38,137    $              5,721
    Substitutes ($23/hr)                                               $23   $           16,560                $           23    $             19,320
Subtotal                                                                     $          201,941                                  $            310,956

Mandatory Benefits
    FICA (6.2%)                                 6.20%                        $          11,494         6.20%                     $             18,081
    Medicare (1.45%)                            1.45%                        $           2,688         1.45%                     $              4,229
    Unemployment (3.4%)                         3.40%                        $           6,303         3.40%                     $              9,916
    Workers' Compensation (7%)                     7%                        $          12,977            7%                     $             20,414
    State Disability Insurance 1.18%            1.18%                        $           2,187         1.18%                     $              3,441
    State Employment Training Tax ($7/employee)    $7                        $              46            $7                     $                 53
Subtotal                                       19.23%                        $          35,695        19.23%                     $             56,135

Other Benefits
    Health, Dental, Retirement, Life              12.77%                     $          23,673        12.77%                     $             37,242
Subtotal                                                                     $          23,673                                   $             37,242

    Subtotal Personnel                                                       $         261,309                                   $            404,332

Non-personnel
                                                     37%                     $         153,467           37%                     $            237,465
Subtotal                                                                     $         153,467                                   $            237,465

Total                                                                        $         414,776                                   $            641,797
Cost per child year                                                          $           4,321                                   $              5,348
2007-08 state reimbursement rate                                             $           3,714
Diff bet current cost and reimbursement                                      $             607
Current cash reimb diff + new PS cost
Cost per hour                                                                                                                    $              1,634
                                                                                                                                                   10
Cost difference per-child-year between State Preschool and Preschool for All                                                     $              1,634

Budget Assumptions and Source Information
Program and Staffing Characteristics
    Budgets are based on a typical State Preschool program, running two 3-hour sessions per day. Staff work eight hours per
    day, 180 days per year (includes 5 in-service days), and have 15 days of leave, unless otherwise noted. In the hypothetical
    example, the existing State Preschool Program has 2 classrooms that serve 24 children per session--thus 48 children are served per
    day per classroom, for a total of 96 children per program. After the upgrade, the program has 3 classrooms that serve 20
    children per session--thus 40 children are served per day per classroom, for a total of 120 children per program. There is
    one Program Director, one Education Specialist, and one Enrollment Specialist, each working 15 percent time, who play
    lead administrative roles. There is also an Accountant/Bookkeeper working 15 percent time.
    Non-personnel costs are 37 percent of the program's total costs.
    * The Education Specialist is similar to the Child Development and Education Manager in the Head Start Program.
Source: Child, staff, salary and non-personnel information obtained from Inside the Pre-K Classroom: A Study of Staffing and
        Stability in State-Funded Prekindergarten Program, written by Dan Bellm, Alice Burton, Marcy Whitebook, etc. and
        published by the Center for the Child Care Workforce in Washington, DC. Additional staff and salary information
        obtained from State Preschool (and other) program directors across the state.




     7e9cd6c6-d3cc-4014-b5fb-b71100de4534.xls State PS Begin Salary                                                                                   7/7/2011 2:13 PM
                                                 State Preschool Program Budget
                                               Parity with Mean K-12 Teacher Salary
                                                            2007-08
                                      Estimated Cost of Changing One State Preschool Program
                                                     to Include Preschool for All
                                                           Before Preschool for All
       Number of days of service per year                            175
       Number sessions per day                                         2
       Number of Preschool hours per day                               3
       Number of Preschool hours per year                            525
       Number of children (total)                                     96
       Number of classes                                               4
       Number of classrooms                                            2
       Number of FTE instructional staff                               6
       Class size                                                     24
       Staff to child ratio (1:X)                                      8
       cost per day                                                $21.22
       State reimbursement rate 07-08                             $3,713.50
       Projected state reimbursement rate                         $4,195.00
       Annual cost                               projected         $4,486
                                                             Annual Expense as                        Annual Expens
                                                               State Preschool                         Preschool for
                 Budget Item
                                                            (3.5 hours, 175 days,                     (3 hours, 175 d
                                                             2 sessions per day)                      2 sessions per

Salaries
0.15    Director                                                                    $14,530    0.15
1       Site Supervisor (also a Master Teacher)                                     $42,325       1
1       Lead/Master Teacher                                                         $31,184       2
0       Teacher                                                                                   3
4       Teacher Aide                                                                $78,496       0
0       Floater                                                                                   1
0.15    Accountant/Bookkeeper                                                     $8,117       0.15
0.15    Education Specialist*                                                    $10,400       0.15
0.15    Enrollment Specialist/Family Resource Coordinator                         $5,829       0.15
        Substitutes ($20/hr)                                                     $16,287
Subtotal                                                                        $207,168

Mandatory Benefits
       FICA (6.2%)                                                                  $11,835
       Medicare (1.45%)                                                              $2,768
       Unemployment (3.4%)                                                           $6,490
       Workers' Compensation (7%)                                                   $13,362
       State Disability Insurance 1.18%                                              $2,252
       State Employment Training Tax ($7/employee)                                      $46
Subtotal (18.02 percent)                                                            $36,752

Other Benefits
       Health, Dental, Retirement, Life, EAP                                        $27,391
Subtotal (14.35 percent)                                                            $27,391
       Subtotal Personnel                                                      $271,312

Non-personnel
                                                         37%                   $159,342                 37%
Subtotal                                                                       $159,342

Total                                                                    $430,653
Cost per child year                                                          $4,486
Current reimbursement rate (projected to 2011, COLA)                         $4,195
Diff bet current cost and reimbursement                                        $291
Current cash reimb diff + new PS cost
Cost difference per-child-year between State Preschool and Preschool for All

Budget Assumptions and Source Information
Program and Staffing Characteristics
      Budgets are based on a typical State Preschool program, running two 3-hour sessions per day. Staff work eight hours p
      day, 180 days per year (includes 5 in-service days), and have 15 days of leave, unless otherwise noted. Before Presch
      for All, the State Preschool Program has 2 classrooms that serve 24 children per session--thus 48 children are served
      day per classroom, for a total of 96 children per program. After Preschool for All, the program has 3 classrooms that se
      children per session--thus 40 children are served per day per classroom, for a total of 120 children per program. There
      one Program Director, one Education Specialist, and one Enrollment Specialist, each working 15 percent time, who pla
      lead administrative roles. There is also an Accountant/Bookkeeper working 15 percent time. A cost-of-living adjustmen
      2.5 percent was made for staff who did not receive a salary increase through Preschool for All. Non-personnel costs ar
      percent of the program's total costs.

       * The Education Specialist is similar to the Child Development and Education Manager in the Head Start Program.

Source: Child, staff, salary and non-personnel information obtained from Inside the Pre-K Classroom: A Study of Staffing and
          Stability in State-Funded Prekindergarten Program, written by Dan Bellm, Alice Burton, Marcy Whitebook, etc. and
          published by the Center for the Child Care Workforce in Washington, DC. Additional staff and salaray information
          obtained from State Preschool (and other) program directors across the state.
gram


           After Preschool for All
                    175
                      2
                      3
                    525
                    120
                      6
                      3
                      7
                     20
                     10




                   $7,051
       Annual Expense as
        Preschool for All
       (3 hours, 175 days,
       2 sessions per day)


                              $14,530
                              $65,239
                             $108,732
                             $130,478
                                   $0
                              $43,493
                               $8,117
                              $10,400
                               $5,829
                              $16,287
                             $403,103


                              $23,983
                               $5,609
                              $13,152
                              $27,077
                               $4,564
                                  $46
                              $74,431


                              $55,508
                              $55,508
                                    $533,043


                                    $313,057
                                    $313,057

                                    $846,099
                                      $7,051


                                      $2,856
                                      $2,856



  day. Staff work eight hours per
erwise noted. Before Preschool
 thus 48 children are served per
am has 3 classrooms that serve 20
 children per program. There is
 ing 15 percent time, who play
e. A cost-of-living adjustment of
r All. Non-personnel costs are 37


he Head Start Program.

om: A Study of Staffing and
 Marcy Whitebook, etc. and
aff and salaray information
                                                                                                                                                                Purpose:
                                                                                                                                                                This template is designed to guide you through the process of developing 'proxy' budgets that will estimate the cost (e.g., annual cost per child) of upgrading an existing
                                                                                                                                                                preschool program to meet quality standards. The proxy budgets estimate the direct costs of a current program before and after the upgrade ("before" and 'after" costs).
  Estimated Cost of Changing One State Preschool Program to Meet Quality Standards,                                                                             The direct cost components consist mostly of personnel (e.g., teacher compensation) and non-personnel expenses (e.g., supplies, rentals), and do not include infrastructural
                                       2007-08                                                                                                                  costs such as professional development, program evaluation, or construction of new facilities.
                                                                                     (Col. 4) 'Before'
                           (Col. 1)                    (Col. 2)       (Col. 3)             Cost            (Col. 5)      (Col. 6)       (Col. 7) 'After' Cost   Section I. Program Features. This section displays the critical program features of a preschool program: the existing preschool program and the quality preschool program .
Section I. Program Features                                                                                                                                     Steps to complete this section (The blue cells are formual-linked and do not require data entry, while the yellow cells are intended for users to enter preschool program data):
   Number of days of service per year                                                                                                                           1. Enter the number of days of preschool service per year: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Number of sessions per day                                                                                                                                   2. Enter the number of preschool sessions per day: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Number of preschool hours per day                                                                                                                            3. Enter the number of preschool hours per day: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Number of preschool hours per year                                                        0                                                   0              4. This formula automatically calculates the number of preschool hours per year: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Number of children (total)                                                                                                                                   5. Enter the number of children served in the program: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Number of classes                                                                                                                                            6. Enter the number of classes: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Number of classrooms                                                                                                                                         7. Enter the number of classrooms: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Number of FTE instructional staff                                                                                                                            8. Enter the number of instructional staff: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Class size                                                                             #DIV/0!                                             #DIV/0!           9. This formula automatically calculates the class size: Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
   Annual cost                                                                        #DIV/0!                                            #DIV/0!                10. This formula automatically calculates the cost per child per year:Col. 4 (existing program, or 'before' preschool upgrade), and Col. 7('after' preschool upgrade)
                                                                     Annual Expense as                                Annual Expense after
                        Budget Item                                   State Preschool                             Preschool has been Upgraded

                                                                                                                                                                Section II. Staffing. This section calculates the personnel costs of your preschool program (before and after the upgrade). We have included a list of staffing categories
Section II. Staffing                                     FTE        Salary/1 FTE         Total Salaries     FTE        Salary/1 FTE                  Salaries   (administrative, instructional and instructional support) that are typically found in a preschool program.
Administrative                                                                                                                                                  To complete this section, enter the number of full-time equivalents (FTEs) and the annual gross salary (per FTE) for each position in your program:
   Director                                                                          $              -                                   $                -      Col. 2 (FTE) and Col. 3 (annual gross salary) for the current program, and Col. 5 (FTE) and Col. 6 (gross salary) for the 'after' budget
   Site Supervisor                                                                   $              -                                   $                -      Col. 4 and Col. 7 automatically calculate the total salaries for the 'before' and 'after' budgets, respectively.
Instructional                                                                                                                                                   Data sources to project teacher or other staff salaries in the preschool programs:
   Lead/Master Teacher                                                                                                                  $                -      (1) California Department of Education certificated salaries J-90 (e.g., beginning teacher salary): http://www.cde.ca.gov/ds/fd/cs/
   Teacher                                                                           $              -                                   $                -      (2) Bureau of Labor Statistics, Occupational Employment Statistics. http://www.bls.gov/oes/
   Teacher Aide                                                                      $              -                                   $                -      (3) Existing state preschool program budgets and expenditure reports
   Floater                                                                           $              -                                   $                -
Other Support
   Accountant/Bookkeeper                                                             $              -                                   $                -
   Education Specialist                                                              $              -                                   $                -
   Enrollment Specialist/Family Resource Coordinator                                 $              -                                   $                -
   other staff (1) ____________                                                      $              -                                   $                -
                                                       No. of hrs    Hourly rate                          No. of hrs    Hourly rate
  Substitutes                                                                        $              -                                   $                -
Subtotal                                                                             $              -                                   $                -


Section III. Benefits                                                                                                                                           Section III. Benefits. This section, with formulas in selected cells, estimates the amount of benefits that staff receive as part of their employment with the preschool program.
Mandatory Benefits                                                                                                                                              Col. 2 ('before') and Col. 5 ('after') display the default percentage of each type of mandatory and optional benefit, and assumes a total benefit package of 32%.
   FICA (6.2%)                                             6.2%                      $              -         6.2%                      $                -      Users can adjust these percentages in the yellow cells based on their program budget actuals.
   Medicare (1.45%)                                        1.5%                      $              -         1.5%                      $                -
   Unemployment (3.4%)                                     3.4%                      $              -         3.4%                      $                -
   Workers' Compensation (7%)                              7.0%                      $              -         7.0%                      $                -
   State Disability Insurance 1.18%                        1.2%                      $              -         1.2%                      $                -
   State Employment Training Tax ($7/employee)               $7                  0   $              -           $7                  0   $                -
Subtotal                                                  19.2%                      $              -        19.2%                      $                -
Other Benefits
  Health, Dental, Retirement, Life                        12.8%                      $              -        12.8%                      $                -
Subtotal                                                                             $              -                                   $                -

   Subtotal Personnel                                                                $              -                                   $                -

                                                                                                                                                                Section IV. Non personnel: This section calculates the non-personnel budget of your preschool program ('before' and 'after'). Non-personnal expenses typically include
Section IV. Non-personnel                                                                                                                                       supplies and materials, utilities, facility rentals, insurance,and other costs associated with direct service.
                                                            35%                      $              -          35%                      $                -      Col. 2 ('before') and Col 5 ('after') reflect the nonpersonnel amount as a percentage of the total preschool budget.
Subtotal                                                                             $              -                                   $                -      Col. 2 and Col. 5 have been defaulted to 35%. Users can adjust this based on their program budget actuals.
Total                                                                                $              -                                   $                -

                                                                                                                                                                Section V. Cost Per Child: This section calculates the annual cost of serving a child in preschool (before and after preschool upgrade) and computes the difference between
Section V. Cost Per Child Per Year                                                                                                                              CA state reimbursement and the cost of upgrading an existing preschool program to meet quality standards.
Cost per child                                                                            #DIV/0!                                             #DIV/0!
2007-08 CA reimbursement rate (175 days * $21.2/day)                                 $           3,714
Difference between current cost and reimbursement                                         #DIV/0!
Cost difference per-child-year between State Preschool and the upgrade preschool program                                                      #DIV/0!

   Note:Adapted from the original cost model developed by IWPR/ECPR.
        7e9cd6c6-d3cc-4014-b5fb-b71100de4534.xls                                                                                                                                             7/7/2011
7e9cd6c6-d3cc-4014-b5fb-b71100de4534.xls   7/7/2011

								
To top