Spreadsheet: 1364d387-3504-4681-a05e-076ee2ab9424
Sheet: Step 3 - Staffing Tool

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - Enter in White Cells - |  |  |  |  |  |  | Step 3 - Staff Your School
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Determine staffing needs for years 0-5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Several SBB allocations have FTE requirements.  They have been
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pre-populated for you.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Don't forget expenses employee costs for your planning year (year 0)
 |  | INFORMATIONAL - REQUIRED PURCHASES
 |  | Nurse Days |  |  |  |  |  |  |  |  |  |  | 0
 |  | Mental Health Days |  |  |  |  |  |  |  |  |  |  | 0
 |  | Mild Moderate FTE |  |  |  |  |  |  |  |  |  |  | 0
 |  | Arts FTEs |  |  |  |  |  |  |  |  |  |  | 0
 |  | Arts Purchase General Fund |  |  |  |  |  |  |  |  |  |  | 0
 |  | Arts Purchase [NAME] |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | YEAR 0
JOB CODE |  | Type | SALARY COST | GF BENEFIT COST | NON-GF BENEFIT COST | GENERAL FUND AVERAGE SALARY + BENEFITS | YEAR 1 AVERAGE | YEAR 2 AVERAGE | YEAR 3 AVERAGE | YEAR 4 AVEARGE | YEAR 5 AVERAGE |  | YEAR 0 - FTE/HOURS | YEAR 0 -            $ |  | YEAR 1 - FTE/HOURS | YEAR 1 -            $ |  | YEAR 2 - FTE/HOURS | YEAR 2 -            $ |  | YEAR 3 - FTE/HOURS | YEAR 3 -            $ |  | YEAR 4 - FTE/HOURS | YEAR 4 -            $ |  | YEAR 5 - FTE/HOURS | YEAR 5 -            $
 |  | PART TIME
 |  | PARAPROFESSIONALS | 13.25 |  |  |  |  |  |  |  |  |  |  |  |  | 1440 |  |  | 1440 |  |  | 2880 |  |  | 2880 |  |  | 2880
 |  | PARAPROFESSIONALS | 13.25 |  |  |  |  |  |  |  |  |  | 0 |  |  | 1440 |  |  | 1440 |  |  | 1440 |  |  | 1440 |  |  | 1440
 |  | PARAPROFESSIONALS | 13.25 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | PARAPROFESSIONALS | 13.25 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | PART TIME TOTAL
 |  | CLASSROOM STAFF
3328 |  | Intervention Teacher | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0
3302 |  | Regular/Supplemental Teacher | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 13 |  |  | 14 |  |  | 15 |  |  | 16 |  |  | 17
3302 |  | Gifted & Talented Teacher | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
3329 |  | Gifted & Talented Itinerant Teacher | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0.25 |  |  | 0.25 |  |  | 0.25 |  |  | 0.25 |  |  | 0.25
3337 |  | Mild/Moderate Teacher (Recommended) | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2
3302 |  | ESL / Zone Teacher | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
3302 |  | Arts Teacher | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2
3306 |  | Libarian | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0
7300 |  | [NAME] | 38704 | 11121 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
3362 |  | Guidance Counselor | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  | listed for PE & Spanish
3372 |  | Student Advisor | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
1401 |  | Mental Health FTE (Psych and/or Social Worker) | 58726 | 15974 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0.6 |  |  | 0.6 |  |  | 0.6 |  |  | 0.6 |  |  | 0.6
1530 |  | Nurse FTE | 52914 | 14886 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0.6 |  |  | 0.6 |  |  | 0.6 |  |  | 0.6 |  |  | 0.6
3382 |  | Technology Teacher | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
3382 |  | Administrative Assistant | 50814 | 14494 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
3332 |  | General Fund Facilitator, Humanities | 58622 | 15955 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
3407 |  | Lead Teacher | 65137 | 17175 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2
 |  | CLASSROOM STAFF TOTAL
 |  | PRO TECH STAFF
6339 |  | LPN | 26457 | 8789 | 10403 | 41516 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
6282 |  | Community Liaison 233 | 34117 | 10223 | 11437 | 46742 |  |  |  |  |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
6123 |  | SFPC [NAME] 200 | 40001 | 11324 | 10875 | 44636 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
6354 |  | Educational ProTech 200 | 45010 | 12262 | 12009 | 48886 |  |  |  |  |  |  | 0
6327 |  | Media Technician 200 | 33536 | 10114 | 10280 | 42400 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
6226 |  | School PC Apps Specialist 220 |  |  | 17054 | 67816 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
9685 |  | Associate Teacher |  |  | 9378 | 25000 |  |  |  |  |  |  | 0 |  |  | 9 |  |  | 10 |  |  | 11 |  |  | 12 |  |  | 13
9686 |  | School Technology Spec II 212 |  |  | 12095 | 49209 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
9687 |  | School Technology Spec III 212 |  |  | 14811 | 59400 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
6169 |  | Project Coordinator 184 |  |  | 16816 | 66922 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
9644 |  | Project Coordinator 240 |  |  | 19620 | 77442 |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | PRO TECH STAFF TOTAL
 |  | ADMINISTRATIVE STAFF
 |  | Principal |  |  | 19620 |  |  |  |  |  |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Asst. Principal |  |  | 19620 |  |  |  |  |  |  |  | 0
 |  | Business Manager |  |  | 19620 |  |  |  |  |  |  |  | 0
 |  | Office Manager |  |  | 19620 |  |  |  |  |  |  |  | 0
 |  | ADMINISTRATIVE STAFF TOTAL
 |  | CLERICAL STAFF
1749 |  | OFFICE SUPPORT I - 220 | 29526 | 9403 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
1706 |  | OFFICE SUPPORT II - 200 | 32352 | 9932 | 19620 |  |  |  |  |  |  |  | 0
1614 |  | OFFICE SUPPORT III - 200 | 34645 | 10362 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
1711 |  | OFFICE SUPPORT I - 220 | 32715 | 10001 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
1709 |  | OFFICE SUPPORT II - 220 | 34715 | 10375 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
1722 |  | OFFICE SUPPORT III - 220 | 38826 | 11144 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
1702 |  | OFFICE SUPPORT I - 240 | 28371 | 9187 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
1704 |  | OFFICE SUPPORT II - 240 | 38547 | 11092 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
1613 |  | OFFICE SUPPORT III - 240 | 42538 | 11839 | 19620 |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | CLERICAL STAFF TOTAL
 |  | GRAND TOTAL FULL TIME
 |  |  | Principal |  |  | AP |  |  | Business Mgr |  |  |  | Office Manager
 | 1 | ES | 7500-207 | 91154 | 20854 | 7318-207 | 72257 | 17317 | 7458-207 | 63557 | 15688 |  | 7464-207 | 43615 | 11955
 | 2 | K8 | 7500-223 | 95776 | 21719 | 7318-212 | 79876 | 18743 | 7458-223 | 64840 | 15928 |  | 7464-223 | 43207 | 11878
 | 3 | MS | 7500-233 | 106563 | 23739 | 7318-235 | 103862 | 23233 | 7458-233 | 66095 | 16163 |  | 7464-233 | 43941 | 12016
 | 4 | 6-12 | 7500-233 | 106563 | 23739 | 7318-235 | 103862 | 23233 | 7458-233 | 66095 | 16163 |  | 7464-233 | 43941 | 12016
 | 5 | HS | 7500-233 | 106563 | 23739 | 7318-235 | 103862 | 23233 | 7458-233 | 66095 | 16163 |  | 7464-233 | 43941 | 12016